Generate dates, clock slots and text from a growing Table
Explain the current array project
Predict eligible original input rows, not the number of returned rows or possible clock slots. The lesson and actual workbook are checked separately; changing either requires a fresh current check.
Complete the applied settings, two explanations and input-row prediction.
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.
- Inspect the actual Report, Source and Draw worksheets. Dates stay numeric; clock times are fractions of one day.
- Apply the report formula. Recalculate to change live keys while saved-key results remain stable, or capture a fresh live draw deliberately.
- 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…
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.
| Draw | Calendar date | Clock time | Source row | Text 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.