EBM BASELINE PERFORMANCE SCAN – GOOGLE SHEET BUILD BRIEF Your job is to build a Google Sheet that I can use in under 2 minutes per client. If it’s confusing, cluttered, or breaks when duplicated, I won’t use it. Keep it clean, simple, and automated. Your Objective Build a clean, automated Google Sheet that allows me to enter client performance test results in under 2 minutes, auto-save them, and generate simple line graphs showing progress over time for each test. No scoring formulas. No combined score. No clutter. 1. SHEET STRUCTURE A. Dashboard (Home Page) Client name Test date Dropdown to select test cycle (Baseline, Retest 1, Retest 2, etc.) Preview of all graphs (pulled from graphs tab) Clean layout using EBM colours only (dark grey, white, teal) B. Data Entry Tab (Main Input Sheet) One column = test names Next column = today’s results Tests to Include: Longevity Markers Blood Pressure (Systolic/Diastolic) Resting Heart Rate Waist Circumference (cm) Height (cm) Waist-to-Height Ratio (auto-calc: waist ÷ height) Grip Strength (best of 3, kg) Knee-to-Wall (cm) Sit & Reach (cm) Single-Leg Balance – Eyes Open (seconds) Biering-Sørensen Hold (seconds) Body Weight (kg) VO2 Max / Cardiovascular Beep Test Level OR 1-Mile Run Time Estimated VO₂ Max (auto-calculated) Resting HR (also listed above) Strength & Performance Chin Hold (seconds) Dead Hang / Bar Hang (seconds) Vertical Jump (cm) Tempo Push-Ups (max reps) Wall Sit (seconds) Maximal Plank Hold (seconds) BlazePod Reactive Plank Test (reaction average, ms) EBM Agility Test EBM Agility – 6-Point BlazePod Sprint Grid Metric: Total Hits in 60 seconds Value must be a whole number Graph shows total hits over time C. Historical Data Tab (Auto-Saving Log) This must be automatic. Columns: Client Name Test Name Result Date Use ARRAYFORMULA so the sheet auto-logs new test entries without me manually touching anything. D. Graphs Tab One graph per test. Graph format: Line chart X-axis = Test Date Y-axis = Result Dynamic ranges (no fixed cell references) Auto-update when new results are entered 2. REQUIRED FORMULAS Waist-to-Height Ratio Use: =WaistCell / HeightCell VO₂ Max (Beep Test) Formula: =3.48 × ShuttleLevel + 14.4 VO₂ Max (1-Mile Run) Use: =132.853 – (0.0769 × weight_lbs) – (0.3877 × age) + (6.315 × gender) – (3.2649 × TimeMinutes) – (0.1565 × HR) (Gender: Male = 1, Female = 0) Historical Log Automation Use ARRAYFORMULA(), FILTER(), and QUERY() so each new entry adds itself to the log tab. 3. RULES (NON-NEGOTIABLE) This must be simple. If it looks complicated, you’ve done it wrong. Data entry MUST take under 2 minutes total. If I have to click around, delete, or adjust anything — fix it. All graphs must auto-update. No manual ranges. No editing required. No scoring system. No radar charts. No weighting. I only want raw test results → simple graphs. The template must be duplicate-safe. I must be able to copy the whole sheet for a new client without formulas breaking. Clean design only No bright colours, no weird fonts. Just clean EBM aesthetic. 4. Include this at the top of the build instructions