Hirudin
Member
- Thread starter
- #1
Howdy y'all, I'm new here - this is my fist post. I have a Lightning reservation (put in ~6 hours after the presentation, I think) and have learned a lot from reading this forum. Thanks!
I was having trouble keeping track of what options each trim level of Lightning comes with or allows to be chosen so I created this spreadsheet to make it much easier to sort out. It's not the most user-friendly thing in the world, but it served my needs and I figured it might be helpful for other people too.
File versions, updates, inaccuracies...
I tried to keep the options/prices/packages accurate, but sources of information about the Lightning are usually incomplete and sometimes conflict. Also, some of the prices are just guesses. If you spot something that is either incorrect or should be included, post it here and either I can update it or someone else can. I have given this first file a version number of "0.9", if you update it, please give it a new (higher) version number. Also, I would like to request that my screen name, Hirudin, stays on the document as its original creator.
- - - - -
Update: 01/23/22 - I've updated the file to version 1.01 but I'm not updating the screenshots. The changes are in post #11...
Update: 01/26/22 - Another update, I decided to call this one version "1.2" for some reason. The changes are described in post #14... AAAAaaaannnnnnddddd, now it's version 1.21, with a minor cosmetic fix
Update: 01/27/22 - v1.3 uploaded to fix a bad problem with how the discount row was calculated, thanks ShirBlackspots!
Update: 02/11/22 - v1.4 (the final iteration of the file?) uploaded to make it more accurate, largely based on the 146-page eSourceBook. More info in post #18 of this thread...
Update 2 - v1.4b Replaced "cargo" with "towing" in what is now the "Additional towing capacity" row.
- - - - -
How to use the file...
One of the screenshots shows my file as I have it set up for my tastes. I'll reference that when describing how to use the file for yourself...
Column A - The pink cells are where you will enter what you think the "value" of each one of these options is to you. The red cells shouldn't be changed.
Explanation: Cell A-31, another person might really want BlueCruise and would be willing to pay, say, $1000 for that functionality while I only sort-of want it, so I only put a "value" of 500 on that feature.
Column B - This has the name or description of the feature. I attempted to use Ford's names for things most of the time, but not even Ford seems to be 100% consistent with what they call things. Sorry if the features seem to be shuffled together! I sorted them a bit, but it could definitely be better.
Row 2 (Trims/option packages) - I've made columns for each trim level and also additional columns for major options packages. For instance, I think the $9,500 XLT option group is effectively a different trim level, so I've put it into its own column.
Rows 15 through 21 - The calculating portion of this spreadsheet...
Row 15 (Starting cost) - This is the base price/cost of each trim level
Row 16 (Selected options cost) - This will add-up all the options you set in the column (dark blue cells). This represents how much Ford charges, not necessarily its "value", which is calculated in...
Row 19 (Selected options "value") - These cells add-up all the "values" you set (pink cells) for all the dark blue cells you've set in each column. (I hope this makes some sense!)
Row 20 (Standard features "value") - For every trim column beyond Pro, these cells add-up all the "values" you set (pink cells) for all the standard features not included in the Pro trim. For example, the standard-range Lariat includes a cargo net in the frunk as a "standard feature". Row 20 takes that and all other standard features in the Lariat column, grabs the "value" you've assigned to them, and adds them up. If you don't care whether you get a cargo net or not, you would want to put a "0" in the pink cell next to the "Frunk cargo net" option (cell A-26).
Row 21 (Cost premium over Pro...) - This row shows the most important thing in this spreadsheet, IMO: this is the calculated additional "cost" of each trim level over a Pro with the options you have set, taking into account the "values" of all the options that either come standard or that you have set with the dark blue cells. For instance, the difference between the base price of the Pro and the XLT is $13,000 BUT the XLT comes with cloth seats as standard equipment; if someone considers the "value" of cloth seats to be $1,000, the difference in "value" between these two models would be more like $12,000. In the example I have in the screenshot, you can see that, when considering the "value" of the options included in the XLT, the spreadsheet has calculated the cost premium of the XLT to be $3,757 more than the Pro trim with the options I would want.
Cell colors...
Green "Standard" cells - These are things that I believe to come as standard features with each trim/option package.
Red cells - These are things that aren't available. Some of these cells are just important stuff that shouldn't be messed with.
Dark blue cells - These cells (most of which will be set to "0" in an empty file) are options that are available for that column's trim. If you click on the cell a "drop-down" arrow should appear, letting you select either "0" or the price of that option (eg. "865", as is the case for the Max Trailer Tow Package). The value you choose will be added to the "Selected options cost" row (row 16). See cell D-23 in the image for a visualization of what the drop-down looks like.
Light blue cells - These are options included as part of a grouping of options (eg. the Onboard Scales feature is included in the Tow Technology Package group). Do not change the values of these cells manually, they will be populated by a dark blue cell near them. I have made it so these cells say what "Group #" they come with. Example: "w/ 2" means this option comes with Group #2 (marked in a red cell in the leftmost column next to the)
Yellow cells - These are things that I assumed to be the case, but couldn't find any documentation to confirm. The most notable example of this would be rain-sensing windshield wipers; I don't believe I've seen anything that actually says the Platinum trim has rain-sensing wipers... I assume it does though so I've marked it as "Standard" with a yellow background.
Also, some cells were made yellow because they may be important.
Pink cells - (see "Column A" description above)
Big section of green "Standard" cells making up the bottom of the file - these are features that come on every 2022 Ford Lightning.
P.S. Sorry about the seat descriptions... they're confusing in Ford's literature and they're confusing in my spreadsheet. I wanted to break-out the features in order to make it easier to assign them values. Like, what is the "value" of having the seat settings stored in memory? What's the "value" of a manual passenger lumbar adjustment? I very badly want ventilated seats, so I wanted to have that feature broken-out so that I could assign that specific functionality its own "value".
View attachment 37246
I was having trouble keeping track of what options each trim level of Lightning comes with or allows to be chosen so I created this spreadsheet to make it much easier to sort out. It's not the most user-friendly thing in the world, but it served my needs and I figured it might be helpful for other people too.
File versions, updates, inaccuracies...
I tried to keep the options/prices/packages accurate, but sources of information about the Lightning are usually incomplete and sometimes conflict. Also, some of the prices are just guesses. If you spot something that is either incorrect or should be included, post it here and either I can update it or someone else can. I have given this first file a version number of "0.9", if you update it, please give it a new (higher) version number. Also, I would like to request that my screen name, Hirudin, stays on the document as its original creator.
- - - - -
Update: 01/23/22 - I've updated the file to version 1.01 but I'm not updating the screenshots. The changes are in post #11...
Update: 01/26/22 - Another update, I decided to call this one version "1.2" for some reason. The changes are described in post #14... AAAAaaaannnnnnddddd, now it's version 1.21, with a minor cosmetic fix
Update: 01/27/22 - v1.3 uploaded to fix a bad problem with how the discount row was calculated, thanks ShirBlackspots!
Update: 02/11/22 - v1.4 (the final iteration of the file?) uploaded to make it more accurate, largely based on the 146-page eSourceBook. More info in post #18 of this thread...
Update 2 - v1.4b Replaced "cargo" with "towing" in what is now the "Additional towing capacity" row.
- - - - -
How to use the file...
One of the screenshots shows my file as I have it set up for my tastes. I'll reference that when describing how to use the file for yourself...
Column A - The pink cells are where you will enter what you think the "value" of each one of these options is to you. The red cells shouldn't be changed.
Explanation: Cell A-31, another person might really want BlueCruise and would be willing to pay, say, $1000 for that functionality while I only sort-of want it, so I only put a "value" of 500 on that feature.
Column B - This has the name or description of the feature. I attempted to use Ford's names for things most of the time, but not even Ford seems to be 100% consistent with what they call things. Sorry if the features seem to be shuffled together! I sorted them a bit, but it could definitely be better.
Row 2 (Trims/option packages) - I've made columns for each trim level and also additional columns for major options packages. For instance, I think the $9,500 XLT option group is effectively a different trim level, so I've put it into its own column.
Rows 15 through 21 - The calculating portion of this spreadsheet...
Row 15 (Starting cost) - This is the base price/cost of each trim level
Row 16 (Selected options cost) - This will add-up all the options you set in the column (dark blue cells). This represents how much Ford charges, not necessarily its "value", which is calculated in...
Row 19 (Selected options "value") - These cells add-up all the "values" you set (pink cells) for all the dark blue cells you've set in each column. (I hope this makes some sense!)
Row 20 (Standard features "value") - For every trim column beyond Pro, these cells add-up all the "values" you set (pink cells) for all the standard features not included in the Pro trim. For example, the standard-range Lariat includes a cargo net in the frunk as a "standard feature". Row 20 takes that and all other standard features in the Lariat column, grabs the "value" you've assigned to them, and adds them up. If you don't care whether you get a cargo net or not, you would want to put a "0" in the pink cell next to the "Frunk cargo net" option (cell A-26).
Row 21 (Cost premium over Pro...) - This row shows the most important thing in this spreadsheet, IMO: this is the calculated additional "cost" of each trim level over a Pro with the options you have set, taking into account the "values" of all the options that either come standard or that you have set with the dark blue cells. For instance, the difference between the base price of the Pro and the XLT is $13,000 BUT the XLT comes with cloth seats as standard equipment; if someone considers the "value" of cloth seats to be $1,000, the difference in "value" between these two models would be more like $12,000. In the example I have in the screenshot, you can see that, when considering the "value" of the options included in the XLT, the spreadsheet has calculated the cost premium of the XLT to be $3,757 more than the Pro trim with the options I would want.
Cell colors...
Green "Standard" cells - These are things that I believe to come as standard features with each trim/option package.
Red cells - These are things that aren't available. Some of these cells are just important stuff that shouldn't be messed with.
Dark blue cells - These cells (most of which will be set to "0" in an empty file) are options that are available for that column's trim. If you click on the cell a "drop-down" arrow should appear, letting you select either "0" or the price of that option (eg. "865", as is the case for the Max Trailer Tow Package). The value you choose will be added to the "Selected options cost" row (row 16). See cell D-23 in the image for a visualization of what the drop-down looks like.
Light blue cells - These are options included as part of a grouping of options (eg. the Onboard Scales feature is included in the Tow Technology Package group). Do not change the values of these cells manually, they will be populated by a dark blue cell near them. I have made it so these cells say what "Group #" they come with. Example: "w/ 2" means this option comes with Group #2 (marked in a red cell in the leftmost column next to the)
Yellow cells - These are things that I assumed to be the case, but couldn't find any documentation to confirm. The most notable example of this would be rain-sensing windshield wipers; I don't believe I've seen anything that actually says the Platinum trim has rain-sensing wipers... I assume it does though so I've marked it as "Standard" with a yellow background.
Also, some cells were made yellow because they may be important.
Pink cells - (see "Column A" description above)
Big section of green "Standard" cells making up the bottom of the file - these are features that come on every 2022 Ford Lightning.
P.S. Sorry about the seat descriptions... they're confusing in Ford's literature and they're confusing in my spreadsheet. I wanted to break-out the features in order to make it easier to assign them values. Like, what is the "value" of having the seat settings stored in memory? What's the "value" of a manual passenger lumbar adjustment? I very badly want ventilated seats, so I wanted to have that feature broken-out so that I could assign that specific functionality its own "value".
View attachment 37246
Last edited:
Thank you...
