F3F Spreadsheets

Simon Hall's spreadsheet

This spreadsheet, originally developed by Simon Hall, is well proven in UK competition.

• Fix v2.2: Import Timer File now supports Mac OSX
• New in v2.1: Compatible with 32- and 64-bit Excel
• Import scores (via CSV file) from Edison's timer system
• Up to 99 pilots, 20 rounds
• Flexible discards
• Supports group scoring*
• Sheets are protected to prevent accidental modification
• Choice of rounded or truncated FAI scores
• Times to 2 or 3 decimal places
• Excel format

*Group scoring is achieved by splitting a round into two or more partial rounds and assigning zero scores for those not participating in each partial round. To compensate for the dummy zero scores, the number of discards must be increased by (number_of_partial_rounds - 1), starting from the last partial round.

Example: round 12 is group scored, with three partial rounds 12, 13 and 14. The number of discards must be increased by 2, starting from round 14.

Downloads

• SH spreadsheet v 2.2

Windows security: After opening the file, you may see a banner "SECURITY RISK: Microsoft has blocked macros from running". If you see this, highlight the file in File Manager, go into File Properties and tick the 'unblock' checkbox.