Connect dynamic lists, ranked records and saved draws
Build complete array projects, change their inputs, and explain what each spill represents.
Start with cell addresses and ordinary formulas. Ten original steps connect live validation choices, exact/cutoff Top N, unique/repeated sampling, capacity schedules and Table-fed date/clock/text generation. Move freely between steps; save only a checked current attempt.
0 of 10 historical passing attempts saved on this device.
Step 1
Build distinct choices and a linked report →
A generated choice list changes with its source. A dependent team list also reads the applied Region and Active controls; the dropdown points at that live spill.
Before this step: Read cell ranges, Boolean values and spill references.
Step 2
Intersect conditions without treating punctuation as a wildcard →
The complete record must satisfy Region, a chosen Team and the Active condition together. Literal text equality retains punctuation; a displayed amount of zero is still a numeric record.
Before this step: Build the live Region and Team choices.
Step 3
Rank whole records and return exactly N →
Amount descending and ID ascending move complete records together. With cutoff ties off, equal amounts do not increase the requested row count.
Before this step: Filter the source before ranking it.
Step 4
Include every record tied at the cutoff →
The Nth ordered amount is a threshold. Including ties can return more than N complete records; it does not change the eligible source population.
Before this step: Understand exact-N ordering.
Step 5
Select unique whole records from saved draw keys →
RANDARRAY keys are volatile. Capturing writes a separate literal draw; a nonreplacement sample orders eligible IDs by those saved keys and cannot repeat an ID.
Before this step: Keep a filtered population and complete records together.
Step 6
Draw more times than there are eligible records →
Replacement sampling uses each saved key to address an eligible record. Repeated IDs are allowed, and asking for more draws than eligible records guarantees repetition.
Before this step: Distinguish labels, IDs and selected record counts.
Step 7
Assign every eligible record to a capacity-limited session →
A session schedule uses every eligible record once. Capacity determines session/seat positions; the sample-N control does not truncate the schedule.
Before this step: Understand saved-key ordering without replacement.
Step 8
Generate numeric dates across a complete leap-year month →
A date is a numeric day serial. The selected month determines its actual number of days; a saved key selects a day within those month boundaries.
Before this step: Separate volatile generation from a saved report.
Step 9
Generate same-day times on an explicit interval grid →
Clock time is a fraction of one day. An inclusive grid from 09:00 through 17:00 in fifteen-minute steps has 33 slots; no timezone or daylight-saving model is implied.
Before this step: Understand numeric day serials and fractional days.
Step 10
Complete a growing Table-fed calendar and text report →
Each physical choice row has weight, even when labels repeat. A real Table expansion changes the formula population; a fixed original range cannot include the new row.
Before this step: Generate dates and clock slots from saved keys.
Saved records contain unit, version, check/scenario counts and date only. They do not restore worksheet data or certify mastery. Native Excel rendering, recalculation and edit/save require separate checks.