GlennCMC70
08-08-2009, 06:40 PM
here is a new points sheet that i've been able to get some help w/ over the last week or so.
this sheet will automatically determin which of your finish results are your "low score" or "drops" and drop them and display them in the drop column. the only input that is required durring the season is to change 1 numbers on the 3rd tab. you must tell it how many races we have run for the season. the sheet is setup to change the number of drops based on the number of races.
play w/ it and telme what you think. this is very timely since our last event is coming soon. to see what you need to do to move up or to not drop in the season points durring ECR is to go to the 3rd tab and change the 19 in the Numbe of Races cell (one cell for each of the 4 classes) then go back to the 1st tab and input various race results of your choosing for yourself and whoever. the non-drop season points column will be in greatest to smallest sort and the drop column will not affect the orderin which the names are displayed.
feedback please.
see attachment in my next post. fixed some issues.
this sheet will automatically determin which of your finish results are your "low score" or "drops" and drop them and display them in the drop column. the only input that is required durring the season is to change 1 numbers on the 3rd tab. you must tell it how many races we have run for the season. the sheet is setup to change the number of drops based on the number of races.
play w/ it and telme what you think. this is very timely since our last event is coming soon. to see what you need to do to move up or to not drop in the season points durring ECR is to go to the 3rd tab and change the 19 in the Numbe of Races cell (one cell for each of the 4 classes) then go back to the 1st tab and input various race results of your choosing for yourself and whoever. the non-drop season points column will be in greatest to smallest sort and the drop column will not affect the orderin which the names are displayed.
feedback please.
see attachment in my next post. fixed some issues.