Pre-Cat Talent ID Data Collection Documentation
Index
- What this workbook does?
- Important Considerations
- How to use it
- Coach and Assessor Subjective Annotations
- Where to start
- Tests and Tabs Overview
- Troubleshooting
The main objective for this excel file is to unify the Talent ID data collection across all the Pathway activities nationally (e.g SIS/SAS Para Units, FG&G). The Pre-Cat Talent ID Data Collection Excel is intended to be used until the AMS forms are released as the preferential Talent ID collection tool. All data collected in the Excel file will be uploaded to AMS in the future.
The current version of the excel file is V4 - Pre-Cat Talent ID Data Collection_V4
What this workbook does?
- Enter athlete information and test scores across dedicated tabs.
- Automatically calculate useful fields and tests scores.
- Store test scores to be uploaded to AMS in the future.
Important Considerations
Data Entry
- One participant = one row (across all category tabs). Do not merge cells.
- Numbers only in number cells (no text, no units).
- Use dots for decimals: "3.25" not "3,25".
- Use dropdowns when available.
- Fill in only the white cells. Color filled cells are blocked.
- Results tab is blocked as it is for read only. No data should be introduced on this tab.
- Some tests include a “Measurement Details” or "Observations" field; when present, please complete it appropriately.
Privacy
- Collect only what’s needed for Talent ID.
- Store files in approved secure locations (Share Point).
- Do NOT download the file on the device, open it on the web browser.
- Avoid emailing or downloading files.
How to use it
The excel file should only be opened in their designated Share Point using the web browser. Do NOT download the file onto a device.
If one assessor is testing one participant through all tests, the assessor should open the Excel file in a web browser on their device and enter results as the participant completes each test. If assessors are stationed at different tests and the participant rotates between stations, each assessor should open the same file in a web browser from the same SharePoint location. This allows real-time co-authoring. When one assessor records a result, it will appear for all others who have the file open.
Do not Unhide columns.
Coach and Assessor Subjective Annotations
- Some tests have an Observations column. This is a space for the assessor/coach to write notes about the test that may not be recorded on the other columns.
-
Each test has a Movement Score column. This is a score of 1 to 3 of the quality of movement of the participant for that specific test. Please select from the dropdown menu.
- Poor (1 point): Increased compensatory strategies, breakdown in technique, increased postural sway or inability to complete the task as prescribed.
- Moderate (2 points): Movement completed but characterised by observable compensations and inconsistent motor control or joint alignment.
- Good (3 points): Movement is executed with optimal control, alignment, and technique, meeting criteria without compensations.
Where to start
Start by filling the information required on the Personal Info tab:
- Test day info: State (location where the test takes place) and Date.
- Athlete info: Participant UUID (use the same UUID they have on the AMS), Participant Full Name, Date of Birth, Gender, Participant Address, Participant Phone Number, Participant Email, and Parent Email and Phone number (only if participant is under 18).
If a test is null, it is not performed or the column is not relevnt for the participant, then type NA.
Tests and Tabs Overview
Personal Info
- State: of the Para Unit coordinating the test.
- Date tested: date of when the test is conducted.
- AMS UUID: AMS UUID of the participant - If the participant do not have an AMS account at the point of the test, please write NA, and progresswith the tests as normal.
- Full Name: Full name of the participant.
-
Signed Data Consent Form: Please confirm that the participant has signed the Data Consent Form. If not, data cannot be collected form the particpant.
- If the particpant has an AMS account already, that means they have signed thre Data Consent Form, please tick YES n that case.
- DOB: Date of birth of the participant.
- Gender: Gender of the participant.
- Address: Address of the participant.
- Phone: Phone number fo the participant.
- Email: Email address of the participant.
- Parent/Guardian Email: In case the athlete is under 18, email of the parent or guardian.
-
Parent Phone: In case the athlete is under 18, phone of the parent or guardian.
Anthropometric
This station is for anthropometry, which involves measuring height, arm span, and sitting height.
These measurements can be important in various sports. For example, rowers are usually taller, and in para-table tennis, a large arm span can be beneficial.
For taking standing height, please remove your shoes and hats. Socks can stay on, and ensure your pockets are empty. We will guide everyone through this station one person at a time.
If we cannot take a measurement for any reason, or if you prefer not to have a measurement taken, that’s perfectly fine. Just let us know. However, if you know your height or sitting height, please share that information with us, and we will record it.
Standing Height (cm)
Equipment
A wall-mounted or free-standing stadiometer (accurate to 0.1 cm, minimum measurement range 600–2100 mm). It should be checked prior to testing against a standard height.
If a stadiometer is not available: a measuring tape fixed to a wall, checked for height and vertical positioning, used with a headboard/ruler/set square. A spirit level should be glued to the horizontal edge of the set square. Ensure the wall does not have a skirting board (if possible).
Testing Protocol
Ensure the floor surface is even and firm.
Make sure the participant is barefoot (or wearing socks).
The participant should stand with feet together (or as close as possible), the heels, buttocks and upper part of the back touching the scale, with the arms hanging freely by the sides (palms facing thighs).
Instruct the participant to look straight ahead. The head should be placed in the Frankfort plane. When aligned, the vertex is the highest point of the skull.
Instruct the participant to take and hold a deep breath while keeping the head in the Frankfort plane (ensure the head is not tilted backward). Apply a gentle upward lift through the mastoid processes.
Lower the headboard onto the vertex of the participant’s head, being sure to press firmly through any hair.
Ensure the participant’s feet do not come off the floor and that the position of the head is maintained in the Frankfort plane.
If using a tape measure, place a set square against the wall with the base on top of the head, ensuring the set square is level by using the spirit level as an indicator.
Measurement
Measure and record the standing height to the nearest 0.1 cm.
Adaptations
For participants that use a wheelchair with an acquired impairment, ask them if their standing height is known and record - marking as "reported (known prior to impairment)"
Sitting Height (cm)
Equipment
Stadiometer (wall-mounted or free-standing).
Alternative (if no stadiometer): Measuring tape fixed to a flat wall (verified for height and true vertical) used with a headboard/ruler/set square. Attach a spirit level to the horizontal edge of the set square. Use a wall without skirting if possible.
Box or bench of known height (record the exact height on the data sheet).
Testing Protocol
Place the stadiometer firmly against a wall. Ensure the floor surface is even and firm.
Place the box centrally at the base of the stadiometer.
Ask the participant to sit with their buttocks and upper part of the back touching the scale, and hands resting on the thighs, which should be parallel with the floor.
The head, when placed in the Frankfort plane, doesn’t need to be touching the scale.
The Frankfort plane is achieved when the orbital (lower edge of the eye socket) is in the same horizontal plane as the tragion (the notch superior to the tragus of the ear). When aligned, the vertex is the highest point on the skull.
Instruct the participant to take and hold a deep breath. Apply a gentle upward lift through the mastoid processes.
Lower the headboard onto the vertex of the head, being sure to press firmly through any hair.
Ensure the participant’s feet do not come off the floor and that the head remains in the Frankfort plane.
Measurement is taken at the end of a deep inward breath.
If using a tape measure, place a set square against the wall with the base on top of the head, ensuring the set square is level by using the spirit level as an indicator.
Measurement
Measure and record the sitting height to the nearest 0.1 cm.
To calculate sitting height, subtract the box height.
Adaptations
For wheelchair users, if the participant can transfer to a chair or box, use the method above.
If the participant cannot be measured due to their disability but knows their approximate sitting height, record this as their sitting height, noting that it is an estimate.
Arm Span (cm)
Equipment
A wall-mounted arm span scale (preferred), measurement range 0–2500 mm, with etched or painted markings.
Alternatively, a measuring tape (at least 3 m in length and accurate to 0.1 cm) fixed horizontally on a wall.
Tape to fix the arm span scale or measuring tape to the wall.
Testing Protocol
Fix the measurement scale at approximately the shoulder height of the participant.
Ask the participant to stand tall with their back against the wall, feet together, heels against the wall, and looking straight ahead.
Extend the arms laterally at shoulder level (horizontal) with the hands facing forward.
Ask the participant to reach out as far as they can, ensuring they do not go over zero.
Measurement
Measure the distance between the tips of the middle fingers with the arms outstretched laterally.
Record arm span to the nearest 0.5 cm.
Adaptations
Wheelchair users: Ensure the chair is against the wall and the participant is sitting upright. Move the chart so it is at approximately the shoulder height of the participant.
Single upper limb deficiency: Measure the distance between the top of the fingers and the sternoclavicular notch on the unaffected side. Record this, noting single arm span and the side measured
Lower Body Power
This station will be used to assess your lower body power. Lower body power is important for short-duration explosive sports such as sprint cycling, long jump, high jump, triple jump, sprinting, and dynamic team sports. If we cannot take a measurement for any reason, or if you prefer not to have a measurement taken, that’s fine—please let us know.
Vertical Jump (cm)
Equiptment
Vertex (Yardstick)
Painter’s tape to mark the jump position at 20 cm on either side of the yardstick
Testing Protocol
Standing Maximal Reach
Ask the participant to stand side-on to the yardstick with feet together, with the arch of the foot in line with the yardstick. Their dominant arm should be closest to the yardstick
Ensuring heels stay on the floor and eyes look straight ahead, ask the athlete to slowly swing the dominant hand backward and upward as high as possible, fully elevating the shoulder to displace the vanes of the yardstick.
Have them repeat twice to ensure the vanes have been displaced.
Record this as the standing reach height - vanes displaced (cm).
Absolute standing reach height from the floor is calculated as the pole setting height plus the number of vanes moved.
Jump Height
Move several vanes away prior to the first jump.
Ask the participant to stand 20 cm back from the yardstick.
The participant uses an arm swing and countermovement to jump as high as possible and displace the vanes at the height of the jump.
Take-off must be from both feet simultaneously with no preliminary steps or shuffling; feet may be apart.
Allow three trials, and allow the participant to continue if improvements are being made.
The best trial is the highest vane displaced, recorded as the jump height - vanes displaced.
Measurement
Standing reach height (cm): Recorded on the "Vertical Jump - Standing reach height - vanes displaced (cm)"
Jump height (cm): Record the best of the three trials in column "Vertical Jump - Jump height - vanes displaced (cm)"
Vertical jump (cm) = "Vertical Jump - Jump height - vanes displaced (cm)" minus "Vertical Jump - Standing reach height - vanes displaced (cm)". This will be automatically calculated in the excel.
Adaptations
Record any use of athletic equipment.
Counter Movement Jump
Reference: Australia Sports Commission – National Protocols for the Assessment of Strength and Power 2025
Equipment
Force plate
Operating system/software
Testing Protocol
Force Plate Set Up
Place the force plate(s) on a flat surface and confirm they are level.
Zero the force plate before beginning the test as per system instructions.
Ensure left and right plates are correctly placed and identified.
Conduct a pre-test trial to confirm force output accuracy (analyse system weight).
Where appropriate (e.g., athletes with limb loss), extension of body part(s) may be used to perform the assessment. Record aid use.
Procedure
Follow the procedure to obtain Jump Height via the Impulse-Momentum of the froce plates. Rember to weight in the particpant to have an accurate resutl of the Jump Height.
Measurement
Record each of the three trials under ech column. Trial 1 -> "CMJ - TRIAL 1"; TRIAL 2 -> "CMJ - TRIAL 2"; etc.
Best CMJ Trial will be extracted automatically into "BEST CMJ".
Standing Broad (Long) Jump
Equipment
Measuring tape (at least 5 meters in length)
Painter’s tape
Testing Protocol
Mark out the starting line and lay the tape perpendicular to the start line.
Ask the participant to stand squarely with toes just behind the start line and feet comfortably apart.
The participant swings arms backward and performs a countermovement jump to propel forward as far as possible, using a two-foot take-off and landing on both feet, falling forward instead of backward if balance is lost.
Allow three trials for each participant.
Measurement
Measure the length of each jump from the start line to the heel of the foot closest to the start line on landing.
Record the best trial to the nearest 1 cm.
Triple Hop for Distance (Right & Left)
Equipment
Measuring tape (at least 10 meters in length)
Painter’s tape
Testing Protocol
Ensure the floor surface is even and firm.
Mark out the starting line and lay the tape perpendicular to the start line.
Athletes stand behind the start line, with the front of the foot as close to the line as possible.
Ask the participant to stand on one (1) leg and perform three (3) consecutive hops as far as possible, landing on the same leg. There are no restrictions on arm movement.
Perform the test first with one (1) leg, then the other.
Allow three trials for each participant.
Measurement
Measure the distance from the start line to the heel of the third hop on landing.
Measure and record to the nearest 1 cm the participant’s best triple hop for each leg (left and right).
Upper Body Power
This station measures upper body power, relevant to sports such as throwing events, athletics, and paddle. Participants perform a seated, two-handed chest throw of a medicine ball away from the wall. If they need to adjust how they hold the ball or their seated position, that is permitted. Participation is optional. Each participant completes three trials.
Medicine Ball Chest Throw
Equipment
2 kg medicine ball or
1 kg medicine ball (if the 2 kg ball cannot be controlled) or
Tennis ball
Tape measure accurate to 5 cm
Set- Up
Lay the measuring tape in a straight line perpendicular to a wall, with zero against the wall.
Participnt Position
Participant sits with back and head against the wall and legs straight out in front.
Record any adaptations to the seated position on the data sheet.
Procedure
Participant holds the 2 kg medicine ball with both hands at chest level.
Perform a two-handed chest pass, pushing the ball forward as far as possible.
Allow three trials.
Measurement
Record the distance to the nearest 5 cm.
Measure from the wall to the base of the ball where it first contacts the ground (first bounce).
Equipment and Measurement Details
One-arm chest pass is allowed for upper-limb or one-side impairment.
Adjusted seated position or chair use if unable to sit on the floor.
Wheelchair users: remain in the wheelchair with feet on the footrest, positioned as close to the wall as possible.
If handling is difficult, use a 1 kg medicine ball, or a tennis ball if required.
Speed and Acceleration
The 20m sprint is a test of speed and acceleration. This test is important for sports such as various athletics events and team sports.
Before we start the test, we will do some warm-up efforts. Run or push along the course, at 60%, 70%, and 80% of your maximum.
For this test, you will start 30cm behind the line. Once the light gates are set, you can go when you are ready. Start in a comfortable standing position, no rocking backwards is allowed. Go as fast as you can until you get to the cones past the final light gate.
Everyone will get three trials. If we cannot take a measurement for any reason, or if you prefer not to have a measurement taken, that’s perfectly fine. Just let us know.
Remember, we just want you to try your best!
Equipment
Measuring tape
Electronic light gates x 4 pairs and system
Marking/painter’s tape
Cones
Testing Protocol
Measure distances with the measuring tape. Check the tape lies flat with no twists. A straight-line marking can assist when laying the tape.
Mark the start line (0 m) and intervals (5 m, 10 m, 20 m) with tape.
Place two cones approximately 4 m beyond the last set of light gates.
-
Set light gates at 0–5–10–20 m.
Start-line gates: set at a lower height to ensure capture of the start.
Other gates: set at approximately torso height and ~1.5–2.0 m apart.
Start position: front foot toe 30 cm behind the start line; back heel up; body mass over the front foot; shoulders and hips square in a crouched ready position.
Once in the ready position, all movement must be forward (no rocking).
Instruct the participant to sprint as fast as possible and not decelerate until past the cones placed 4 m after the final gate.
The participant starts in their own time once advised the timing system is ready.
Allow three attempts with at least 2 min recovery between trials.
Measurement
Record split times at 5, 10, 20 m and the final time of each trial, to the nearest 0.01 s.
Adaptations
Wheelchair users: start with the wheelchair front wheels touching the 30 cm line behind the start line.
Strength
This station is a measure of muscular strength. Muscular strength is important for many sports, for example, para-powerlifting.
Today we are measuring grip strength. You will hold the dynamometer in your hand with your upper arm beside your body and your elbow bent at a right angle. Whenever you are ready, squeeze as hard as you can for 5 seconds. We will give you 3 trials on each hand.
If we cannot take a measurement for any reason, or if you prefer not to have a measurement taken, that’s perfectly fine. Just let us know.
This station measures muscular strength via grip strength. Each participant performs three trials per hand.
Grip Strength
Equipment
Calibrated handheld dynamometer
Testing Protocol
Ask the participant which one is the dominate hand and select on the dropdown menu.
Test both hands dominant hand first.
Participant holds the dynamometer in the dominant hand.
Forearm at right angles; elbow by the side of the body.
Adjust handle if required: base rests on the first metacarpal (heel of palm); handle rests on the middle of the four fingers.
On “ready,” participant squeezes maximally (isometric) and maintains for ~5 seconds.
No other body movement is allowed.
Provide strong encouragement to give maximum effort.
Three trials with 30 s between efforts.
Repeat the above steps for the non-dominant hand.
Allow three trials per hand.
Measurement
Select which one is the dominant hand.
Record force output (Kg) for all three trials.
Agility
This station assesses agility (ability to move and change direction). Agility is important in sports such as wheelchair basketball, rugby, and tennis. The sequence is: go as fast as possible to the first cone → run/push back as fast as possible → weave in and out of the middle cones up and back → run/push as fast as possible to the far cone, turn, and return as fast as possible.
Each participant completes three attempts.
Participation is optional.
Illinois Agility Test (Modified for Wheelchair Users)
Equipment
Cones/markers × 8
Painter’s tape
2 sets of light gates or stopwatch
Testing Protocol
-
Using a tape measure and marking tape, mark out the course:
Cones form a 10 × 6 m rectangle.
Cones on the horizontal lines are placed 3 m apart.
Cones on the vertical line are positioned 3.3 m apart.
-
If using light gates:
Set gates at approximately torso height and 1.5–2.0 m apart.
Participant starts standing or in a wheelchair 30 cm behind the first cone (marked with a taped line).
Once the light gates are set, instruct the participant to begin when ready.
-
If using a stopwatch:
Participant starts standing next to the first cone.
Tester counts 3–2–1–Go; start the stopwatch on Go.
-
The participant runs/wheels the course as illustrated in the figure:
Forward 10 m to cross the line inside the cone,
Back 10 m,
Up and back through a slalom of four cones,
Then 10 m up and back past the finishing cone; stop timing at the finish.
Three trials per participant.
Measurement
Record time for each trial to the nearest 0.1 s.
Adaptation
For athletes with intellectual impairment, keep instructions as simple as possible.
Aerobic
Beep Test
This station is to measure your aerobic capacity/endurance. All participants complete the test at the same time.
Aerobic capacity is important for sports and events of longer duration such as athletics and swimming long distance events.
In this test, you will line up along the line. When you hear the beep, jog to the other line, you must reach the other line before the next beep. Your foot must be on or over the line before the beep. When you hear the beep, head back the other way. The test gets quicker over time. Keep going for as long as you can. If you miss the line once, you will receive a warning, and you must get to the other end before the next beep. If you miss the line twice before the beep, then you are out. If you miss it once, then make the next one, you can keep going. You can only be eliminated if you miss the line before the beep twice in a row. If you aren’t sure whether you have missed two beeps, keep going if you can! We will pull you out when we see you miss two beeps.
Everyone will do the test at the same time.
Remember, this is not a competition against anyone else, we understand that people will perform differently, we just want to see you do your best.
If you prefer not to do this test, that’s perfectly fine. Just let us know.
Equipment
Beep test recording
Portable speaker
Measuring tape
Marker cones
Testing Protocol
Measure and clearly mark 20 m.
Participants line up along one of the lines, ready to start.
Provide instructions, then a 5 s countdown before the test begins.
A single beep is emitted at intervals. Participants must be at the opposite end of the 20 m track by the time the following beep sounds.
After approximately each minute, the interval between beeps decreases; running speed increases accordingly.
Participants must place one foot on or over the 20 m mark at each beep.
If a participant arrives before the beep, they wait for the beep before continuing.
If a participant fails to reach the line at the beep, issue a warning that they will be eliminated if they are not at the opposite end at the next beep.
If a participant falls short of the 20 m line twice in succession, terminate the test and record the score.
Measurement
Record Level and Shuttle. The total Meters, Speed and VO2 Max is calculated automatically in the Results tab.
Adaptation
For participants who use a wheelchair, measure and clearly mark 12 m.
Participants must cross the line with the front wheels by each beep.
If a participant fails to reach the line at the beep, issue a warning that they will be eliminated if they are not at the opposite end of the 12 m distance at the next beep.
7-Minute Push Test
This station measures aerobic capacity/endurance. Aerobic capacity is important for longer-duration sports and events such as athletics and long-distance swimming.
On 3-2-1, Go, participants start on Go, push to the other end, cross the line, turn, and return. They continue completing as many lengths as possible in 7 minutes.
All participants complete the test at the same time. Emphasise that it is not a competition; participants should do their best. Participation is optional.
Equipment
Cone markers × 6
Stopwatch
Measuring tape to mark out 20 m
Testing Procedure
Use the measuring tape to mark out 20 m.
Place a marker on the corners on the 20 m sides.
Participants start next to a marker (spread participants around the rectangle; no more than one athlete per marker).
Assign one volunteer per participant to count the number of laps.
On “Go”, start the stopwatch for 7 minutes. Participants push up to the line and back, continuously for the full 7 minutes.
At 7 minutes, instruct participants to stop and stay where they are so results can be recorded.
Measurement
Record total distance covered for each participant: total number of laps plus the additional metres of the next lap not completed.
Saftey
Participants should overtake carefully.
Advise that it is easier and safer to overtake on the straight rather than on corners.
Ensure there is enough area to allow room for overtaking.
Bike Capacity
Equipment
Bike ergometer / Wattbike
Testing Protocol
Participant completes all three tests in a row.
Tester counts 3–2–1–Go.
If using a Wattbike, tester hits Start on “2.”
Participant begins pedalling during the countdown at the desired cadence and wattage.
Test 1 - Sprint
Wattbike gear 1 or 2 - 6s max (power and cadence; sprint/anaerobic capacity).
Performed out of the saddle (record in observations if unable
2 trials × 6 s → record best effort.
Assessor chooses gear based on athlete capability.
1 minute rest between trials and before Test 2. Keep spinning legs during rest period (light pressure).
Test 2 - Sprint
Wattbike gear 4 or 6 - 6s max (power and cadence; sprint/anaerobic capacity).
Performed out of the saddle (record if unable).
1 trial × 6 s.
Assessor chooses gear based on athlete capability.
2 minutes rest before Endurance test (heart rate to return to resting rate). Keep spinning legs during rest period (light pressure)
Test 3 - Endurance
Duration: 2 minutes.
Gear: self-selected (usually 2 or 4), aiming to maintain ~80–90 rpm.
The participant produces the highest possible average power in two minutes; average power across the two minutes is recorded (&average cadence)
Performed in the saddle.
Encourage even pacing as much as possible.
Instruction to athlete: “Do the maximum pace you think you can maintain for 2 minutes; start at what feels like 90% then increase to 100% through the last minute - don’t blow yourself up early.”
Measurement
Sprint:
Record peak power (W) and peak cadence (RPM).
Record any impact of high-speed turnover of movement quality e.g. if impacted by tone
Endurance:
Record average wattage and average cadence (RPM).
Precision
This station evaluates the ability to perform tasks requiring accuracy, consistency, and attention to detail. Precision is important for para-sports such as wheelchair basketball, para-shooting, para-archery, and boccia. In this test, participants throw a ball from set distances toward a target, aiming to get as close to the bullseye as possible. Two practice throws are allowed to start, followed by three throws from 3 m and three throws from 6 m, which together provide a total score. Participation is optional.
Throw for Accuracy
Equipment
Bullseye map
Boccia balls
Measuring tape
Marking tape
Markers
Testing Protocol
Use tape to mark 1.5 m, 3 m, and 6 m from the bullseye target.
Athletes will throw from 3 m and 6 m unless a variation is required.
Begin at the 3 m position.
The athlete may position themselves as they wish, provided they remain behind the line.
Throwing action is determined by the athlete.
Allow two (2) practice throws from each location.
Then allow three (3) scoring throws.
Balls are allocated a score based on the landing position.
If a ball lands on a border line, score based on the zone where most of the hemisphere lies; if 50/50, assign the average of the two zones.
Repeat the process from 6 m.
Adaptations
If the athlete is unable to reach a zone, allow a second round from 1.5 m and note this on the "Observations" column.
Coach Eye
Quality of movement under fatigue
Likely fit within classification profiles
-
Trainability
These are subjective athlete attributes and provide context on potential for specific sports.
Results
The Results tab consolidates everything entered on the data-entry sheets (Personal Info, Anthropometric, Lower Body Power, Upper Body Power, Speed & Acceleration, Strength, Agility, Aerobic, Precision, Coach Eye). It presents:
One row per athlete (and per test date, if applicable).
Raw scores and (where configured) trial summaries (e.g., Best, Mean).
Derived metrics (e.g., estimations or totals calculated from inputs).
Column names mirror the source sheets to make back-tracking simple.
-
Key identifiers (name, DOB, sex/category, session details) to support selection and reporting
If a value looks wrong here, fix it on the original data-entry sheet. The Results tab updates automatically.
Do not type in cells, paste over values, insert rows/columns, or change headers.
To correct anything, go to the source sheet (e.g., Agility, Strength), update the input, then return here to confirm the change.
If you need to copy results out, use Copy and then Paste Special → Values into your report file to avoid bringing formulas across.
Filtering and Sorting
Use the header filter arrows on each column:
Filter examples:
By session: Filter Test Date or Location to review a single testing day or venue.
By performance: Filter Illinois Agility Best (s) to show values ≤ a benchmark; filter CMJ Best (cm) to show ≥ a target.
By status/notes: Filter Measurement Details or Adaptations to audit special conditions.
Sort examples:
Top performers: Sort descending by a score (e.g., 7-minute Push Distance high → low).
Fastest times: Sort ascending by time (e.g., 20 m Sprint Best (s) low → high).
Most recent: Sort Test Date newest → oldest for recency.
Troubleshooting
- Dates show as mm/dd/yyyy: Right‑click → Format Cells → Date → choose `dd/mm/yyyy`.
- Cells show ####: Widen the column (double‑click the column edge).
- Formula errors (#VALUE!, #N/A): Remove text from number cells; correct typos.