|
|
|
![]() |
|
|||||||
|
||||||||
A tool which can be used to provide better scouting estimates of fuel counts.
This workbook is a tool which can be used to help determine how many fuels were scored in 2017 matches. Data is pulled from the TBA API in the "data import" sheet. To use the "data import" sheet, simply enter an event key into cell B2 and press the "Update" button. 2017 event keys can be found in the "Event keys" sheet. To determine adjusted fuel counts for a single match, use the "single match adjustments" sheet. Simply enter a match number into cell B1 and fill data into cells B8:D11 and B17:D20. Adjusted fuel counts will be put into cells I8:K11 and I17:K20. To determine adjusted fuel counts for multiple matches simultaneously, use the "multiple match adjustments" sheet. Enter a category in cell B2, then enter unadjusted data into cells A10:G310 and the adjusted data will be placed into cells L10:S310.
fuel counting assistant v2016.1.xlsm
Yesterday 22:37
Caleb SykesPrimary discussion thread can be found here: https://www.chiefdelphi.com/forums/s...10#post1643210