StrikerHawk
Full Access Member
So I had a few spare minutes today while things were slow at the office and decided to throw this Excel (Version 2013) Spreadsheet together to help me decide just how much bang for the buck each of the Equipment Groups actually provides versus just adding lots of extras to a lower price Equipment Group.
It's built solely around the SuperCrew, sorry for those considering the SuperCab.
Simply update Columns J, N and R with either Y or N, and the cells should update color and price totals to reflect the options you select. Unfortunately, I don't yet have a good method for updating the color of the selected options (Column A) based on the Y or N input. Still working on that feature.
This is a work in progress. I'm happy to accept corrections if you find something that's in error.
Hope someone finds this at least somewhat useful.
Respectfully,
P.S.: Since the website doesn't allow the posting of Excel files, 4DRHTRD has been kind enough to drop the file into a dropbox and host it for our access. Please let us know if you run into any problems accessing the file.
https://www.dropbox.com/sh/8mruncv7mmo3qi7/AABBirzzAyAX9hsT286urqtfa?dl=0
In order to make the Excel file work, open it in the DropBox application, then in the upper right corner, choose to Download it to your computer. When the registration box pops up, simply select the No Thank You, Continue To Download link at the bottom of the window. Once downloaded, you'll be able to open it in Excel and all of the functions will work.
Sorry for the extra steps.
It's built solely around the SuperCrew, sorry for those considering the SuperCab.
Simply update Columns J, N and R with either Y or N, and the cells should update color and price totals to reflect the options you select. Unfortunately, I don't yet have a good method for updating the color of the selected options (Column A) based on the Y or N input. Still working on that feature.
This is a work in progress. I'm happy to accept corrections if you find something that's in error.
Hope someone finds this at least somewhat useful.
Respectfully,
P.S.: Since the website doesn't allow the posting of Excel files, 4DRHTRD has been kind enough to drop the file into a dropbox and host it for our access. Please let us know if you run into any problems accessing the file.
https://www.dropbox.com/sh/8mruncv7mmo3qi7/AABBirzzAyAX9hsT286urqtfa?dl=0
In order to make the Excel file work, open it in the DropBox application, then in the upper right corner, choose to Download it to your computer. When the registration box pops up, simply select the No Thank You, Continue To Download link at the bottom of the window. Once downloaded, you'll be able to open it in Excel and all of the functions will work.
Sorry for the extra steps.