unconfirmed
Well-Known Member
- Thread starter
- #1
UPDATE (9/1/2019): In order to make this easier for those of you who don't have MS Excel or can't run Excel macros due to security settings, I have ported this over to a web-based system.
You can access it here: http://redbarrister.com/jeepchecklist/
It's very simple, and inelegant, but it gets the job done.
A couple of notes:
1) Once you get the checklist generated, you can then print it from your browser. If you want the alternating row colors to show up, enable the "Print Background Colors" or similar in your browser's print dialog.
2) You should be able to save it as a PDF from your browser (easily if you have a Mac, somewhat easily with a PC if you have Adobe Acrobat).
Let me know if you run into any issues.
________________
Good evening!
For the last month or so, I’ve been working on an interactive delivery checklist, which combines the hard work of @K9Jeeper, who started the sticky thread for items that should come with your Jeep, and @Sunin-Retired who compiled some of the other suggestions for things to check from the thread, and all the others who contributed to that thread.
K9Jeeper had indicated his list was intended to only really be about the things that should come with the Jeep, so, to avoid hijacking his thread with yet another checklist, I started this one for mine. It’s based on the JL Unlimited options.
The attached checklist allows you to pick the trim level, and once you do, it will only show the options available to you from that trim. Then, you select what items you’ve included in your jeep. Once you click the “Generate Checklist” button, it will create a custom checklist for you based on the selected options, and only show those items that are relevant to your Jeep.
A couple of tech notes:
1) This uses Microsoft Excel VBA macros to do the logic (for loops, if…then…else, etc.) and to hide and show rows. When you open the file, it will ask you if you want to enable macros. For this to work properly, you’ll have to say “Enable” or “Yes”. The spreadsheet does not interact with your file system beyond this workbook, and if anyone wants to see the code, I’ll be happy to share it.
2) You may notice a couple of moments of hesitation (or the hourglass or spinning wheel) for a couple of seconds while it "thinks" when you do something (namely when you pick a trim option, or when you click "Generate Checklist"). This appears to be normal behavior. It's running a lot of checks in the background to see what to turn on or off.
3) It's not programmatically pretty, and there are probably much more elegant ways of doing this. This is my first attempt at using Microsoft VBA. This is the second iteration, as the first way I did it was painfully slow.
If you see something missing or that needs correction, please let me know. I’ve tried to think through this thoroughly, but I’m sure I’ve missed something.
I hope you all find it helpful.
Cheers,
Unconfirmed
CURRENT VERSION: 1.0.1 7/23/2019
DROPBOX DOWNLOAD LINK: CLICK HERE
You can access it here: http://redbarrister.com/jeepchecklist/
It's very simple, and inelegant, but it gets the job done.
A couple of notes:
1) Once you get the checklist generated, you can then print it from your browser. If you want the alternating row colors to show up, enable the "Print Background Colors" or similar in your browser's print dialog.
2) You should be able to save it as a PDF from your browser (easily if you have a Mac, somewhat easily with a PC if you have Adobe Acrobat).
Let me know if you run into any issues.
________________
Good evening!
For the last month or so, I’ve been working on an interactive delivery checklist, which combines the hard work of @K9Jeeper, who started the sticky thread for items that should come with your Jeep, and @Sunin-Retired who compiled some of the other suggestions for things to check from the thread, and all the others who contributed to that thread.
K9Jeeper had indicated his list was intended to only really be about the things that should come with the Jeep, so, to avoid hijacking his thread with yet another checklist, I started this one for mine. It’s based on the JL Unlimited options.
The attached checklist allows you to pick the trim level, and once you do, it will only show the options available to you from that trim. Then, you select what items you’ve included in your jeep. Once you click the “Generate Checklist” button, it will create a custom checklist for you based on the selected options, and only show those items that are relevant to your Jeep.
A couple of tech notes:
1) This uses Microsoft Excel VBA macros to do the logic (for loops, if…then…else, etc.) and to hide and show rows. When you open the file, it will ask you if you want to enable macros. For this to work properly, you’ll have to say “Enable” or “Yes”. The spreadsheet does not interact with your file system beyond this workbook, and if anyone wants to see the code, I’ll be happy to share it.
2) You may notice a couple of moments of hesitation (or the hourglass or spinning wheel) for a couple of seconds while it "thinks" when you do something (namely when you pick a trim option, or when you click "Generate Checklist"). This appears to be normal behavior. It's running a lot of checks in the background to see what to turn on or off.
3) It's not programmatically pretty, and there are probably much more elegant ways of doing this. This is my first attempt at using Microsoft VBA. This is the second iteration, as the first way I did it was painfully slow.
If you see something missing or that needs correction, please let me know. I’ve tried to think through this thoroughly, but I’m sure I’ve missed something.
I hope you all find it helpful.
Cheers,
Unconfirmed
CURRENT VERSION: 1.0.1 7/23/2019
DROPBOX DOWNLOAD LINK: CLICK HERE
Sponsored
Last edited: