Paper: Fuel Counting Assistant

Thread created automatically to discuss a document in CD-Media.

Fuel Counting Assistant
by: Caleb Sykes

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 (120 KB)
fuel counting assistant v2017.1.xlsm (119 KB)

Primary discussion thread can be found here: paper: Fuel Counting Assistant