A living plan, not a snapshot — edit any blue cell and watch it recompute.
State Mode Medical · Live trial planner
① The weekly log — what actually happened
The ledger.Fill the blue cells each week.
/Starting point — set once
Opening extract
g
Opening sweets
ea
Opening isomalt
g
Signed up before start
ppl
Trialled before start
ppl
Target participants
ppl
Assumed harvest until logged
g/wk
/Live position — automatic
Extract stock
Sweets in stock
Isomalt stock
Measured extract / lollipop
Latest weekly harvest
Weeks logged
Blue = you type. Everything else recomputes.
/Weekly tally
Wk
W/c
Extract collected (g)
Sweets made
Extract used (mg)
Isomalt in (g)
New sign-ups
Dispatched
Notes
State Mode Medical · Live trial planner
② Recipe & trial assumptions
The recipe.What each person needs.
/Per lollipop
Extract dose — recipe target
mg
Production loss allowance
%
Isomalt per lollipop
g
Effective extract used in planning
Measured from actuals
Planning uses your measured yield once the log has actuals; until then, recipe dose + loss allowance.
/Per person, whole trial
Lollipops per week
Weeks on trial
Lollipops per person
Extract per person
Isomalt per person
Dosing pattern: one per day, five days on / two off. Production-planning quantities only.
One number rules the plan — extract per person.
State Mode Medical · Live trial planner
③ The ramp — sign-ups per week (blue), everything else predicted
The ramp to 500.
Extract stock, week by week
Target reached
Lollipops to make
Lowest extract stock
New people in plan
Feasible on extract?
/New sign-ups per week — shape the ramp; entries clip automatically once the target is met
State Mode Medical · Live trial planner
④ What the numbers mean
What it means.Extract is the constraint.
/What today's stock covers
Lollipops makeable from extract
People suppliable from extract
Lollipops makeable from isomalt
Isomalt needed for remaining people
Isomalt to order beyond stock
Isomalt never limits the timeline — it's just a purchase. Extract sets the pace.
Isomalt to order
Covers everyone still to sign up
Sustainable sign-ups / wk
At the current weekly harvest
/Pace scenarios — at the current harvest
Sign-ups / wk
Weeks to target
Sweets / wk
Extract / wk
Verdict
Pace is a choice — the harvest decides which choices are open.
State Mode Medical · Live trial planner
The working method
Log the harvest every week and the plan recomputes itself — the numbers stay honest.
Edits live in your browser until saved. Save (top right) publishes them for everyone with the edit key. Rebuilt from Lollipop_Trial_Planner.xlsx · STATE MODE LAB DOCS / 8. Supporting Document.
Internal planning document. No efficacy or health claims are made or implied.