2020 Gladiator Pricing - Google Sheets - Orig. by RTDNECO

  1. eternus

    eternus Well-Known Member

    First Name:
    Jody
    Vehicle(s):
    2014 JKU Anvil
    Joined:
    Mar 23, 2018
    Location:
    Longmont, CO
    Posts:
    473
    Liked:
    434
    I took the Excel spreadsheet created by @RTDNECO, made some "logic'ing" tweaks to how it's used and put it in Google Sheets. You can see the sheet here.

    I posted in his thread but decided to create a post so that suggestions specific to my version can be tracked better as well as to clarify how to use the sheet.

    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 accomodate 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 G.

    Enjoy
     
  2. RTDNECO

    RTDNECO Active Member

    First Name:
    Artie
    Vehicle(s):
    Ford F-150
    Joined:
    Nov 5, 2018
    Location:
    New Hampshire
    Posts:
    36
    Liked:
    54
    @eternus - appreciate the consistent tags!

    I'm happy to quote your efforts in my original post if you don't want to add/maintain another thread.
     
  3. OP
    OP
    eternus

    eternus Well-Known Member

    First Name:
    Jody
    Vehicle(s):
    2014 JKU Anvil
    Joined:
    Mar 23, 2018
    Location:
    Longmont, CO
    Posts:
    473
    Liked:
    434
    You definitely deserve the tags, you did all the heavy lifting... I just rearranged the furniture and put it an online format.

    A link in your post would be great, definitely better than me starting a new thread. Too many cooks and all that.
     
Loading...

Share This Page