1 | Presidential Fitness Challenge Spreadsheet | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | |||||||||||||
3 | The below spreadsheet was requested in order to allow for AFJROTC Units to give greater transparency to their cadets on PT performance. It is a tool that can be used by cadets and Instructors alike. Macros must be enabled in excel for this to have full functionality | ||||||||||||
4 | |||||||||||||
5 | |||||||||||||
6 | Most Recent Version: | V1.2 | (Click Version to download) | ||||||||||
7 | |||||||||||||
8 | Instructional Videos: | Spreadsheet Introduction and Set-up | |||||||||||
9 | Inputting Scores | ||||||||||||
10 | |||||||||||||
11 | This is not an official document endorsed or created by Holm Center or AFJROTC | Problems/Inaccuracies Already Identified but not fixed: | |||||||||||
12 | It is possible there are errors that have not yet been detected. If you would like to receive an email if a flaw is found with the spreadsheet or a major revision comes out, please enter your contact information. | Click here to provide your contact information | 1 | WINGS Seems to have errors (Ex, 16 year old female with a score of 41 on sit and reach receives an answer that is different from the provided spreadsheet). However, until more information is discovered, this tool goes off of the official spreadsheet, not WINGS. | |||||||||
13 | Version History | 2 | Partial Curl-ups only go up to the 95 percentile and Sit and Reach only goes to 99. This mirrors what WINGS does, as well as the Normative Data Spreadsheet. | ||||||||||
14 | Version Number | Release Date | Notes | 3 | For some exercises and ages, performing 0 reps or exercises could actually give points (such as pull ups) | ||||||||
15 | 1.2 | 16-Dec-16 | Fixed an error where females were being graded to male standards. Additionally, fixed the issue where pressing "TAB" would cause the sheet to crash. Increased calculation speed by ~10 times. Added button to mass add names in the "Mass Input" Sheet | 4 | After Print Previewing some of the pages, the buttons might flicker. This can be resolved by closing the document, and reopening. Currently working to resolve this issue. | ||||||||
16 | 1.1 | 30-Aug-16 | Fixed an error where cadet names could not be properly selected in Mass Input. Discovered error with flickering buttons, and currently working to resolve (can be temporarily fixed by closing the document) | 5 | |||||||||
17 | 1.0 | 28-Jul-16 | Full Version released to public. | 6 | |||||||||
18 | 0.99.8 | 28-Jul-16 | Removing test data used to create sppreadsheet for privacy issues | 7 | |||||||||
19 | 0.99.6 | 27-Jul-16 | Slight Formatting/Bug Corrections | 8 | |||||||||
20 | 0.99.5 | 27-Jul-16 | First Released Version. Still possibility of many small errors | 9 | |||||||||
21 | |||||||||||||
22 | The calculations are based off of the attached spreadsheet: | Normative Data | |||||||||||
23 | |||||||||||||
24 | |||||||||||||
25 | For questions, comments, or for requests for similar spreadsheets, please email Lt Patrick Dunkel at: Patrick.Dunkel1@gmail.com | ||||||||||||
26 | You Can Also Provide Feedback by clicking here | ||||||||||||
27 | |||||||||||||
28 | |||||||||||||
29 | |||||||||||||
30 | |||||||||||||
31 | |||||||||||||
32 | |||||||||||||
33 | |||||||||||||
34 | |||||||||||||
35 | |||||||||||||
36 |