RTDNECO
Well-Known Member
- First Name
- Artie
- Joined
- Nov 5, 2018
- Threads
- 7
- Messages
- 46
- Reaction score
- 79
- Location
- New Hampshire
- Vehicle(s)
- Ford F-150
- Thread starter
- #1
Edit 12.5.2019: New spreadsheet uploaded based on the November 2019 Order Guide. Changes include: 8.4" Radio (including Premium Audio) as well as Body-Colored Fender Flares added to the Sport S trim, New North Edition package (added as separate sheet - also includes Mopar options for Sunbonnets) and BSW AT Tires added to Overland trim, base price increase on Rubicon trim, and Retro Side Body Graphic and Window Tie Down Straps added to Mopar Options (all trims).
Edit 11.8.19: I've uploaded a new spreadsheet based on the October 2019 Order Guide. It appears that the following options have increased: Dueler Tires (Sport, S, and Overland), both trailer tow packages, roll up tonneau cover, premium LED lighting (Overland and Rubicon), 8.4" radio/audio package (Overland and Rubicon), steel front bumper (Rubicon), and colors billet silver, granite crystal, hydro blue, and punk'n. I've also added the Mopar options.
Edit 6.12.19: Shout-out to @eternus who created a Google Docs version of the spreadsheet (post #42) -
https://docs.google.com/spreadsheets/d/1lNPLxHPGh_onZPcqoOjKGjXe0qJBNV8PGdqvKFb1xbE/edit?usp=sharing
Edit 5.10.19: Community based update! As always, let me know of any errors, suggestions, etc.
Edit 4.23.19: Added a finance/monthly payment calculator to the bottom of each sheet.
Edit 4.9.19: Added 6% and 7% off invoice. The FOUR (4) trims are on separate sheets.
Edit 4.9.19: Formatting.
Edit 4.8.19: Updated spreadsheet with invoice pricing provided by @Travis@TriCityJeep
Edit 3.30.19: This is an update to my 'SWAG Gladiator Pricing' worksheet I posted in February. Invoice pricing is still a guess at this point.
As with the first version, feel free to edit as you see fit. The estimated invoice is a basic calculation which you can adjust with a new formula percentage. Let me know if you find any errors or pricing issues and I'll re-upload to this first post.
Enjoy!
Edit 11.8.19: I've uploaded a new spreadsheet based on the October 2019 Order Guide. It appears that the following options have increased: Dueler Tires (Sport, S, and Overland), both trailer tow packages, roll up tonneau cover, premium LED lighting (Overland and Rubicon), 8.4" radio/audio package (Overland and Rubicon), steel front bumper (Rubicon), and colors billet silver, granite crystal, hydro blue, and punk'n. I've also added the Mopar options.
Edit 6.12.19: Shout-out to @eternus who created a Google Docs version of the spreadsheet (post #42) -
https://docs.google.com/spreadsheets/d/1lNPLxHPGh_onZPcqoOjKGjXe0qJBNV8PGdqvKFb1xbE/edit?usp=sharing
Edit 5.10.19: Community based update! As always, let me know of any errors, suggestions, etc.
- As discovered by @Trez23 the spreadsheets now include tax with 6% and 7% under invoice calculations.
- As suggested by @BlckJT TWO (2) rows have been added for 'dealer fees' and 'other costs.'
- As recommended by @JwadsRenegade the spreadsheets now only require an X input into corresponding cells.
Edit 4.23.19: Added a finance/monthly payment calculator to the bottom of each sheet.
Edit 4.9.19: Added 6% and 7% off invoice. The FOUR (4) trims are on separate sheets.
Edit 4.9.19: Formatting.
Edit 4.8.19: Updated spreadsheet with invoice pricing provided by @Travis@TriCityJeep
Edit 3.30.19: This is an update to my 'SWAG Gladiator Pricing' worksheet I posted in February. Invoice pricing is still a guess at this point.
As with the first version, feel free to edit as you see fit. The estimated invoice is a basic calculation which you can adjust with a new formula percentage. Let me know if you find any errors or pricing issues and I'll re-upload to this first post.
Enjoy!
Sponsored
Attachments
-
39.2 KB Views: 1,993
Last edited: