Hi Folks,
I created a simple spreadsheet that I'm using to help me figure out where the 'best bang for buck' items are for my next flight judging. It calculates the new score you would pickup based on fixing particular items.
NCRTS-Helper2.jpg
You can copy the spreadsheet here (if you have a Google Account), or I've also included an Excel version attached to the thread which you can edit.
All you have to do to is fill out the parts in dark green, and the scoring setup for your car.
0. Fill out the "Scoring Setup" section with the maximum available points for the car being judged.
1. Fill out Section 3 "Scoring as Judged" and "Miles Driven" from your scoring sheet
2. Fill out the miles you plan to drive to the next event in Section 4 "Scoring after improvements"
3. In Section 5 "Clawbacks", Fill out the line items you need to fix, and points deducted.
4. Enter the points for items you are going to fix in the "Fixed" column for each judging section
5. The spreadsheet will do the rest and calculate how many points you will pick up.
I hope someone else finds this sheet useful, and let me know if you have feedback or corrections. Maybe there is already a tool that does this kind of thing, but I was not aware of one.
Thanks
Mick
EDIT : Updated to V1.1 4/18/23 thanks to feedback from Mark!
EDIT : Updated to V1.2 4/18/23 added Mark's code to autodetect Flight Award.
I created a simple spreadsheet that I'm using to help me figure out where the 'best bang for buck' items are for my next flight judging. It calculates the new score you would pickup based on fixing particular items.
NCRTS-Helper2.jpg
You can copy the spreadsheet here (if you have a Google Account), or I've also included an Excel version attached to the thread which you can edit.
All you have to do to is fill out the parts in dark green, and the scoring setup for your car.
0. Fill out the "Scoring Setup" section with the maximum available points for the car being judged.
1. Fill out Section 3 "Scoring as Judged" and "Miles Driven" from your scoring sheet
2. Fill out the miles you plan to drive to the next event in Section 4 "Scoring after improvements"
3. In Section 5 "Clawbacks", Fill out the line items you need to fix, and points deducted.
4. Enter the points for items you are going to fix in the "Fixed" column for each judging section
5. The spreadsheet will do the rest and calculate how many points you will pick up.
I hope someone else finds this sheet useful, and let me know if you have feedback or corrections. Maybe there is already a tool that does this kind of thing, but I was not aware of one.
Thanks
Mick
EDIT : Updated to V1.1 4/18/23 thanks to feedback from Mark!
EDIT : Updated to V1.2 4/18/23 added Mark's code to autodetect Flight Award.
Comment