2021 Gladiator Pricing Worksheet - Google Sheets

[D10S86]

This is for the 2021 Gladiator. You can see the sheet HERE.

Update: August 11th - All model options up to date. Added High Altitude build and confirmed the Willys models are accurate.

Update: Augsut 14th adde the 80th Anniversary page still.

With Google Sheets, if I give you edit permissions then you have the keys to the farm... it's possible for you to tweak values. Additionally, if we are all using the same sheet, we'll all see the same edits and have our edits overwritten. If 2+ people are using it at the same time, and both pricing out a Rubicon then it's gonna get messy real fast.

I included steps in the sheet but will re-state them here: You'll need to go to the File menu and copy the sheet to your drive before you can edit it. I will make a point of updating this post as well as my sheet with the date last edited so you can be sure you have the most recent version. If you have any requests, feel free to add them here and I'll accommodate to the best of my abilities.

One last note, I have compared the feature availability and price changing logic to the Jeep site, so you can expect the options to be priced correctly. If you've checked a box and the price isn't what you're expecting then there should be a note explaining why in Column H.

Enjoy

This sheet is awesome dude. Do we have access to something similar for leases? If not, I’ve built one in the past for plug and play, not as elaborate as yours by any means.

Sponsored

 

[eternus]

This sheet is awesome dude. Do we have access to something similar for leases? If not, I’ve built one in the past for plug and play, not as elaborate as yours by any means.

I'm hoping to rebuild it so that all of the finance is it's own tab sometime and could add lease details, but I don't know anything about the numbers for that though so would need some advice. (c:

 

[AEsco48]

@eternus
First of big thank you!
Was wondering if you have an idea of when you will have an opportunity to updates the prices that came into effect 1/1/21?

 

[eternus]

@eternus
First of big thank you!
Was wondering if you have an idea of when you will have an opportunity to updates the prices that came into effect 1/1/21?

I'm hoping to work on it this weekend, or as soon as I get into a spreadsheet mood.

That being said, the most recent sheet I see is from December 4th. There isn't a new price sheet from 1/1/21 that I'm aware of. If you have a link, please share it. (c:

 

[AEsco48]

I'm hoping to work on it this weekend, or as soon as I get into a spreadsheet mood.

That being said, the most recent sheet I see is from December 4th. There isn't a new price sheet from 1/1/21 that I'm aware of. If you have a link, please share it. (c:

I dont have a new price sheet, but I do have a quote I got on a jeep I am looking to order that has some info. Byt prob best to wait till you have full price sheet for all the trim a d all options.

 

[eternus]

I dont have a new price sheet, but I do have a quote I got on a jeep I am looking to order that has some info. Byt prob best to wait till you have full price sheet for all the trim a d all options.

If anything dramatic has changed then they seem to drop it a couple of weeks into the month. Working on it right now with the December numbers and I'm not seeing any real change in $, just adding items. That being said... the Freedom Edition w/ Max Tow is gonna be the new darling of the non-Rubicon folks. (Sport S, now with more Rubicon!)

 

[eternus]

Updated January 8th, added Texas Trail & Freedom sheets. Working on a separate finance page for calculating/comparing Lease & Purchase options.

 

[Borrego]

Wow this is an incredible resource..
I’m brand new here and came to find this exact info but had no idea I’d hit the gold mine.
I’m looking to buy my first Jeep, a Mojave.
I have opened the link but am unable to download.
Any help appreciated
Thanks

 

[eternus]

Wow this is an incredible resource..
I’m brand new here and came to find this exact info but had no idea I’d hit the gold mine.
I’m looking to buy my first Jeep, a Mojave.
I have opened the link but am unable to download.
Any help appreciated
Thanks

You need to copy it to your Google Drive (instructions are on the first tab)

Welcome to the Gladiator World!

 

[Terminator84]

Thanks for all of your work on this, GREAT tool for Gladiator buyers!

 

[Leonard1818]

When I build a sport S on the Jeep.com site, it allows me to add "Black Perforated Leather Upgrade by Mopar" for seats but I'm not seeing that on the spreadsheet. Am I missing something obvious (like usual)? HA! Thanks.

 

[TheSolarWizard]

When I build a sport S on the Jeep.com site, it allows me to add "Black Perforated Leather Upgrade by Mopar" for seats but I'm not seeing that on the spreadsheet. Am I missing something obvious (like usual)? HA! Thanks.

That’s on the tab to the far right and personally I wouldn’t suggest it

 

[Leonard1818]

That’s on the tab to the far right and personally I wouldn’t suggest it

Ah thanks. Why do you recommend against?

 

[TheSolarWizard]

Ah thanks. Why do you recommend against?

You can get better leather aftermarket for less

 

[Detroit Dave]

Question about the Googlesheets tool...did i do this right?

A: Picked vehicle with options
B: Picked % below invoice
C: Added in $1,495 destination
D: Add 6% MI sales tax
E: Final price. +/- doc fees, etc.

I am math impaired, btw.

Sponsored