Development preview

Mapping / Alignment

Workbook census vs canonical template registry (read-only)

Last census hash
25ae1f9083fc3fae…
Last census at
2026-06-07T18:57:02.690Z
Live verification
Live Google verification skipped — no credentials/session.
Unknown/custom fields
10

Mapping coverage

Mapped 41/51Writeback 42Sensitive 1
  • Daglig Tracker: 41/51 columns mapped; writeback whitelist 42 client fields
  • 5 split - Lets get shredded and: Workout log writeback weeks 1–12; week 1 set 1 = T/U
  • Dropdown helper: Ignored/replaced by app dropdowns
  • PED plan: Detected, sensitive, not exposed by default
  • Step Load Model: Optional — empty OK
  • Food Database: Option source foodOptions[]
  • Exercise Log: Option source exerciseOptions[]
  • TD Nutrition: Primary meal blocks; secondary #REF ignored
  • NTD Nutrition: Rest day meal blocks
  • Mad udbytning: foodSwapOptions[]
  • Averages: Derived/read-only analytics
  • Tidsplan: Coach-owned plan + startDate week logic

Writeback readiness

  • Daily tracker: ready
  • Workout log: ready
  • · Training weeks 1–12 mapped
  • · Week 1 Set 1 = T/U confirmed
  • · Dry-run: GET /api/google/writeback/workout-log/mapping

Reports: docs/architecture/workbook-census-kim-felix-wii-planer.md

Registry: src/lib/spreadsheet/templateMappings/jonathanCuttingPlanV1.ts

Sheet Control Lab

CoachGrid Workbook Template V1

Safely draft, validate, and preview template changes — no live Google writes.

WorkspaceKim Felix Wii - Planer.xlsxCoachv1
Draft only — no live writescoachgrid_workbook_template_v1Dev preview
← Template workspace

Template status

Active registry

Known sheets

12

Writeback areas

2

Custom fields (est.)

10

Risk level

none

Sheet structure inspector

Jonathan Cutting Plan v1 — mapped sheets, ownership, writeback

Daglig Trackerrequiredclient

Daily check-ins — weight, steps, sleep, hunger, performance, client metrics

Writeback
daily_tracker
Unknown fields
0 (placeholder)

Client-owned columns; writeback whitelisted only

ColLabelOwnerWB
BCoach/system column Bcoach—
CCoach/system column Ccoach—
DCoach/system column Dcoach—
HCoach/system column Hcoach—
AZCoach/system column AZcoach—
EKropsvægt (kg)client✓
IProtein actual (g)client✓
JFedt actual (g)client✓
KKulhydrat actual (g)client✓
LKalorier actual (kcal)client✓
NFiber indtagclient✓
OVæske (L)client✓

+23 more mapped columns

Tidsplanrequiredcoach

Plan timeline — weeks, phases, training/rest calendar

Writeback
none
Unknown fields
1 (placeholder)
ColLabelOwnerWB
A–ZWeek rows, phases, training/rest flagscoach—
5 split - Lets get shredded andrequiredcoach

5-day training split — exercises, sets, reps, load targets

Writeback
workout_log
Unknown fields
1 (placeholder)

Aliases: 5 split - Lets get shredded and big

Logged reps/load per set are client-owned writeback cells

ColLabelOwnerWB
A–GExercise, sets, reps, load targetscoach—
H+Logged reps/load per setclient✓
TD Nutritionrequiredcoach

Training day nutrition — meals, macros, portions

Writeback
none
Unknown fields
1 (placeholder)
ColLabelOwnerWB
A–FMeals, foods, macroscoach—
NTD Nutritionrequiredcoach

Rest day nutrition plan

Writeback
none
Unknown fields
1 (placeholder)
ColLabelOwnerWB
A–FRest day mealscoach—
Food Databaserequiredcoach

Food macro database — coach-maintained reference

Writeback
none
Unknown fields
1 (placeholder)
ColLabelOwnerWB
A–EFood name, protein, fat, carbs, kcal per 100gcoach—
Exercise Logrequiredcoach

Exercise library — cues, setup, muscle groups

Writeback
none
Unknown fields
1 (placeholder)
ColLabelOwnerWB
A–DExercise, muscle, cues, setupcoach—
Mad udbytningrequiredcoach

Mad udbytning — approved food swap library

Writeback
none
Unknown fields
1 (placeholder)
ColLabelOwnerWB
A–DSwap from/to, multipliercoach—
Averagesrequiredclient

Weekly averages and progress analytics

Writeback
none
Unknown fields
1 (placeholder)

Derived from client tracker data

ColLabelOwnerWB
A–ZWeekly averages derived from trackerclient—
PED planoptionalclient

Private health / protocol log

Writeback
none
Unknown fields
1 (placeholder)

Sensitive — hidden from AI and client app by default

ColLabelOwnerWB
A–ZPrivate health protocol logclient—
Step Load Modeloptionalcoach

Step load progression model

Writeback
future
Unknown fields
1 (placeholder)

Blank template rows may import as empty

ColLabelOwnerWB
A–ZStep load labels (template may be empty)coach—
Dropdown helperignoredignored

Spreadsheet dropdown helper (legacy formulas)

Writeback
none
Unknown fields
0 (placeholder)

Broken formulas safely ignored; replaced by app dropdown logic

Dropdown / value control

App-managed options — legacy Dropdown helper is read-only

Daily Tracker 1–7 scores

App-managed

dailyTracker · score_fields

Hunger, cravings, motivation, performance, soreness, energy, stress, sleep quality

1234567

Macro day type

App-managed

dailyTracker · macroDay

Column H — coach-owned target row; client sees mirrored value

TRÆNINGSHVILE

Food swap multipliers

App-managed

foodSwaps · multiplier

Danish decimal patterns normalized on import

0.5X0.75X1X1.25X1.5X2X

Training day yes/no

App-managed

dailyTracker · trainingDay

JANEJ

Legacy Dropdown helper

Legacy

dropdownHelper · legacy

Ignored — broken #REF formulas; do not modify directly

No direct edits — replaced by app export path

Future export can write Google Sheet data validation rules. Stage 5.17 only drafts and validates options.

Draft operations builder

Simulated changes — local state only, uses real operation types

Allowed types: add_column, rename_column, add_dropdown_option, remove_dropdown_option, create_custom_metric, ignore_column, map_column_to_existing_field, mark_column_coach_owned, mark_column_client_owned

Proposed changes

0 draft operation(s)

No draft operations yet. Use the builder above to simulate changes.

Change preview

Before / after diff with ownership and risk

Preview appears when draft operations are added.

Validation summary

Draft set is valid

Valid

Writeback risk: none

Add simulated operations to run validation.

How this ships to spreadsheet

Export / apply strategy

  • Export metadata JSONavailable

    Safe now — template structure, ownership, writeback whitelist, draft schema

  • Export .xlsx templateplanned

    Generate workbook from validated draft operations

  • Apply to copied test Google Sheetplanned

    Next stage — coach-owned test copy only

  • Apply to live coach sheetlater

    Requires coach Google authorization + rollback/versioning

Safety rules

No unknown field becomes writable without approval

  • No unknown or custom field becomes writable until mapped, validated, and approved
  • Dropdown helper sheet is ignored — options are app-managed
  • PED / private health log is never auto-written
  • Draft operations are local preview only — no Google Sheets mutation in Stage 5.17
  • Live coach spreadsheet requires OAuth + explicit confirmation (later stage)

read_only_until_mapped

Writeback whitelist: 30 Daily Tracker columns (client-owned).

Import existing sheet via Sync Center →