Skip to main content
← Random samples and session schedules

Generate dates, clock slots and text from a growing Table

Generate three independent draw columns with RANDARRAY, explicitly capture numeric keys, then build a reproducible report from those saved keys. Starting saved keys are fixed teaching draws, not a seeded random generator. Repeated text rows are separate choices; Table filters do not remove choices from this formula.

  1. Inspect the actual Report, Source and Draw worksheets. Dates stay numeric; clock times are fractions of one day.
  2. Apply the report formula. Recalculate to change live keys while saved-key results remain stable, or capture a fresh live draw deliberately.
  3. Edit or append actual Table text, inspect its selected physical source rows, then check every result against six complete populations before downloading.

Loading your interactive spreadsheet…

Applied calendar and clock controls
Actual choice Table

Current native Table: loading

Live draws and saved keys

=RANDARRAY(30,3) returns thirty rows by three columns. Capturing replaces only the ninety saved numeric inputs; subsequent recalculation does not replace them.

Actual report formula

Applied: No report formula applied.

Unapplied inputs: yes. Dates include every day in the selected month; slot endpoints are inclusive when on the interval grid. Text rows are equally addressable, so repeated labels carry repeated weight.

Apply the report formula, then check its complete current results.

DrawCalendar dateClock timeSource rowText choice

Saved keys make a report reproducible only while its source and controls stay the same. Clock values have no timezone or daylight-saving rules. Native copies preserve real formulas and the current Table; desktop recalculation, row expansion and edit/save remain separate compatibility checks. No source is uploaded.