| A | B | C | D | |
|---|---|---|---|---|
1 | Google Sheets Tools for USATF Course Measurement and Certification | |||
2 | Measurer Tools | |||
3 | Link | Version | Description | Completed example |
4 | LDE measurement data sheet (includes application) | 2022-2.6 | This sheet is for recording data from a course measurement that will be submitted by the certifier or final signatory using the LDE process. This is primarily for courses that are measured in segments, rather than in a single continuous measurement from start to finish or finish to start. The sheet is formatted for easily viewing on a phone. | Links to example files are given in the google sheet at bottom of Instructions tab. |
5 | Calibration course measurement data sheet | 2022-1.0 | This sheet is for recording data from a calibration course measurement. It allows the entry of multiple segments that are not necessarily the same length, and then sums them to show the total length of the course. It includes an adjustment calculation for the measuring tape end loop offset for the case when the end loop is placed over nails pounded into the pavement. It also does the 2 measurement averaging and the calculation for temperature adjustment. There are tabs for both Metric and Imperial measurement. The sheet is formatted for easily viewing on a phone. | Example with Imperial measuring tape. |
6 | Standalone certification application | 2022-1.0 | This sheet is for completing the certification application to send to your certifier when the LDE submission process will be used. It includes a check on the length of the course name, measurer contact info, and race contact info, to make sure they will not be truncated on the certificate. The sheet can be used to do these length checks even when the normal (non LDE) process is used. | |
7 | Certifier Tools | |||
8 | Link | Version | Description | Completed example |
9 | Certification map review sheet for certifiers | 2022-1.0 | This sheet can be used by certifiers to provide feedback to measurers about changes needed on their maps. It includes a checklist of requested changes and an image of the map with markers. | Landscape map example |
10 | LDE measurement data sheet Checker for certifiers | 2022-2.6 | This sheet can be used to check meaurer submissions of LDE measurement sheet. The input fields of the measurer's sheet are imported into this Checker, and then it can be confirmed that both sheets give the same final course distance. This would be used primarily to ensure that the formulaa on the measurer's sheet are still accurate. | Example on the Instructions sheet. |