ABCDEFGHIJKLMNO
1
by Shay CapehartDayPositionTimeCustom $ā†
You can either use an advanced setup, which will give you the status and time of last update,

ā†’
or you can use a very simple setup that still guards against the loading error.		DayPositionTimeCustom $
2
Go LIVE!Pulling LIVE dataMondayFSA6:00am - 8:00amMondayFSA6:00am - 8:00am
3
Last Good UpdatePulling LIVE dataLast update: 11/17/2025 4:03:09 PMMondayKitchen Aide6:00am - 8:00amMondayKitchen Aide6:00am - 8:00am
4
Last checked: 11/29/2025 9:45:47 AMMondayFSA (HS)8:00am - 10:00amMondayFSA (HS)8:00am - 10:00am
5
Bypass Safeguard/ResetMondayFSA (HS)8:00am - 10:00amMondayFSA (HS)8:00am - 10:00am
6
Click to use LIVE feed good or badMondaySalad Bar8:00am - 10:30am MondaySalad Bar8:00am - 10:30am
7
MondayDish8:00am - 10:30am MondayDish8:00am - 10:30am
8
Source SSID11PSVhrp5kk9QS0VqqNx9Efr_P9m1m2QrBwrQGMakA60MondayDish8:00am - 10:30am MondayDish8:00am - 10:30am
9
MondayDish8:00am - 10:30am MondayDish8:00am - 10:30am
10
FridayPizza/Pasta8:00am - 12:00pmFridayPizza/Pasta8:00am - 12:00pm
11
Source RangeData!A:DMondayKitchen Aide8:00am - 12:00pmMondayKitchen Aide8:00am - 12:00pm
12
Can be a1notation or named rangeMondayKitchen Aide8:00am - 12:00pmMondayKitchen Aide8:00am - 12:00pm
13
MondayFSA (Classic)10:00am - 12:00pm MondayFSA (Classic)10:00am - 12:00pm
14
Force UpdateMondayFSA (Deli)10:00am - 12:00pm MondayFSA (Deli)10:00am - 12:00pm
15
IMPORTRANGE can take a while to refresh. Click here to manually refresh data.MondayDish10:00am - 12:00pm MondayDish10:00am - 12:00pm
16
MondayDish10:00am - 12:00pm MondayDish10:00am - 12:00pm
17
MondayFSA (HS)10:00am - 2:00pmMondayFSA (HS)10:00am - 2:00pm
18
Simulate Loading ErrorMondayFSA (HS)10:00am - 2:00pmMondayFSA (HS)10:00am - 2:00pm
19
MondayFSA (HS)10:30am - 2:30pmMondayFSA (HS)10:30am - 2:30pm
20
Click to cause error on source sheet
(might take a few seconds to appear)		MondayGrill10:30am - 2:30pmMondayGrill10:30am - 2:30pm
21
MondaySalad Bar10:30am - 12:30pm Meal DollarsMondaySalad Bar10:30am - 12:30pm Meal Dollars
22
MondayPizza11:00am - 2:30pmMondayPizza11:00am - 2:30pm
23
Make change to A10 in Source Data (F10 here)
MondayDish12:00pm - 2:00pmMondayDish12:00pm - 2:00pm
24
FridayThis change may take a few seconds to show.MondayFSA (Deli)12:00pm - 2:30pmMondayFSA (Deli)12:00pm - 2:30pm
25
MondayKitchen Aide12:00pm - 2:30pmMondayKitchen Aide12:00pm - 2:30pm
26
MondayKitchen Aide12:00pm - 2:30pmMondayKitchen Aide12:00pm - 2:30pm
27
Iterative calculations must be enabled for this to work.

File > Settings > Calculations

Set max iterations to 1		MondaySalad Bar12:30pm - 2:30pmMondaySalad Bar12:30pm - 2:30pm
28
MondayDish1:00pm - 3:00pmMondayDish1:00pm - 3:00pm
29
MondayDish1:00pm - 4:00pmMondayDish1:00pm - 4:00pm
30
TuesdayFSA (HS)8:00am - 9:15amTuesdayFSA (HS)8:00am - 9:15am
31
TuesdayFSA (HS)8:00am - 9:15amTuesdayFSA (HS)8:00am - 9:15am
32
TuesdaySalad Bar8:00am - 9:15amTuesdaySalad Bar8:00am - 9:15am
33
TuesdayDish8:00am - 9:15amTuesdayDish8:00am - 9:15am
34
TuesdayDish8:00am - 9:15amTuesdayDish8:00am - 9:15am
35
TuesdayDish8:00am - 9:15amTuesdayDish8:00am - 9:15am
36
TuesdayPizza/Pasta8:00am - 9:15amTuesdayPizza/Pasta8:00am - 9:15am
37
TuesdayKitchen Aide8:00am - 9:15amTuesdayKitchen Aide8:00am - 9:15am
38
TuesdayKitchen Aide8:00am - 9:15amTuesdayKitchen Aide8:00am - 9:15am
39
TuesdayKitchen Aide8:00am - 12:00pmTuesdayKitchen Aide8:00am - 12:00pm
40
TuesdayFSA (HS)9:15am - 10:30amTuesdayFSA (HS)9:15am - 10:30am
41
TuesdayFSA (Classic)9:15am - 10:30amTuesdayFSA (Classic)9:15am - 10:30am
42
TuesdayKitchen Aide9:15am - 10:30amTuesdayKitchen Aide9:15am - 10:30am
43
TuesdayDish9:15am - 10:30amTuesdayDish9:15am - 10:30am
44
TuesdayDish9:15am - 10:30amTuesdayDish9:15am - 10:30am
45
TuesdayPizza/Pasta9:15am - 10:30amTuesdayPizza/Pasta9:15am - 10:30am
46
TuesdaySalad Bar9:15am - 10:30amTuesdaySalad Bar9:15am - 10:30am
47
TuesdayFSA10:00am - 12:00pm TuesdayFSA10:00am - 12:00pm
48
TuesdayGrill10:30am - 12:15pmTuesdayGrill10:30am - 12:15pm
49
TuesdayFSA (HS)10:00am - 2:00pmTuesdayFSA (HS)10:00am - 2:00pm
50
TuesdayFSA (Classic)11:00am - 12:15pmTuesdayFSA (Classic)11:00am - 12:15pm
51
TuesdayFSA (Deli)11:00am - 12:15pmTuesdayFSA (Deli)11:00am - 12:15pm
52
TuesdayKitchen Aide11:00am - 12:15pmTuesdayKitchen Aide11:00am - 12:15pm
53
TuesdayKitchen Aide11:00am - 12:15pmTuesdayKitchen Aide11:00am - 12:15pm
54
TuesdayDish11:00am - 12:15pmTuesdayDish11:00am - 12:15pm
55
TuesdayDish11:00am - 12:15pmTuesdayDish11:00am - 12:15pm
56
TuesdayPizza/Pasta11:00am - 12:15pmTuesdayPizza/Pasta11:00am - 12:15pm
57
TuesdayPizza/Pasta11:00am - 12:15pmTuesdayPizza/Pasta11:00am - 12:15pm
58
TuesdaySalad Bar11:00am - 12:15pmTuesdaySalad Bar11:00am - 12:15pm
59
TuesdayGrill12:15pm - 2:30pmTuesdayGrill12:15pm - 2:30pm
60
TuesdayFSA (Deli)12:30pm - 1:15pmTuesdayFSA (Deli)12:30pm - 1:15pm
61
TuesdayFSA12:30pm - 1:15pmTuesdayFSA12:30pm - 1:15pm
62
TuesdayKitchen Aide12:30pm - 1:15pmTuesdayKitchen Aide12:30pm - 1:15pm
63
TuesdayKitchen Aide12:30pm - 1:15pmTuesdayKitchen Aide12:30pm - 1:15pm
64
TuesdayDish12:30pm - 1:15pmTuesdayDish12:30pm - 1:15pm
65
TuesdayDish12:30pm - 1:15pmTuesdayDish12:30pm - 1:15pm
66
TuesdayPizza/Pasta12:30pm - 1:15pmTuesdayPizza/Pasta12:30pm - 1:15pm
67
TuesdayPizza/Pasta12:30pm - 1:15pmTuesdayPizza/Pasta12:30pm - 1:15pm
68
TuesdaySalad Bar12:30pm - 1:15pmTuesdaySalad Bar12:30pm - 1:15pm
69
TuesdayFSA (HS)1:30pm - 2:15pmTuesdayFSA (HS)1:30pm - 2:15pm
70
TuesdayFSA (Classic)1:30pm - 2:15pmTuesdayFSA (Classic)1:30pm - 2:15pm
71
TuesdayKitchen Aide1:30pm - 2:15pmTuesdayKitchen Aide1:30pm - 2:15pm
72
TuesdayKitchen Aide1:30pm - 2:15pmTuesdayKitchen Aide1:30pm - 2:15pm
73
TuesdayPizza/Pasta1:30pm - 2:15pmTuesdayPizza/Pasta1:30pm - 2:15pm
74
TuesdayPizza/Pasta1:30pm - 2:15pmTuesdayPizza/Pasta1:30pm - 2:15pm
75
TuesdayDish1:30pm - 2:15pmTuesdayDish1:30pm - 2:15pm
76
TuesdayDish1:30pm - 2:15pmTuesdayDish1:30pm - 2:15pm
77
TuesdaySalad Bar1:30pm - 2:15pmTuesdaySalad Bar1:30pm - 2:15pm
78
WednesdayFSA6:00am - 8:00amWednesdayFSA6:00am - 8:00am
79
WednesdayKitchen Aide6:00am - 8:00amWednesdayKitchen Aide6:00am - 8:00am
80
WednesdayFSA8:00am - 10:00amWednesdayFSA8:00am - 10:00am
81
WednesdayFSA8:00am - 10:00amWednesdayFSA8:00am - 10:00am
82
WednesdaySalad Bar8:00am - 10:30am WednesdaySalad Bar8:00am - 10:30am
83
WednesdayDish8:00am - 10:30am WednesdayDish8:00am - 10:30am
84
WednesdayDish8:00am - 10:30am WednesdayDish8:00am - 10:30am
85
WednesdayDish8:00am - 10:30am WednesdayDish8:00am - 10:30am
86
WednesdayPizza/Pasta8:00am - 12:00pmWednesdayPizza/Pasta8:00am - 12:00pm
87
WednesdayKitchen Aide8:00am - 12:00pmWednesdayKitchen Aide8:00am - 12:00pm
88
WednesdayKitchen Aide8:00am - 12:00pmWednesdayKitchen Aide8:00am - 12:00pm
89
WednesdayFSA10:00am - 12:00pm WednesdayFSA10:00am - 12:00pm
90
WednesdayFSA10:00am - 12:00pm WednesdayFSA10:00am - 12:00pm
91
WednesdayDish10:00am - 12:00pm WednesdayDish10:00am - 12:00pm
92
WednesdayDish10:00am - 12:00pm WednesdayDish10:00am - 12:00pm
93
WednesdayFood Runner10:00am - 2:00pmWednesdayFood Runner10:00am - 2:00pm
94
WednesdayFood Runner10:30am - 2:30pmMeal DollarsWednesdayFood Runner10:30am - 2:30pmMeal Dollars
95
WednesdayFSA (HS)10:30am - 2:30pmWednesdayFSA (HS)10:30am - 2:30pm
96
WednesdaySalad Bar10:30am - 2:30pmMeal DollarsWednesdaySalad Bar10:30am - 2:30pmMeal Dollars
97
WednesdayFSA10:30am - 12:30pm WednesdayFSA10:30am - 12:30pm
98
WednesdayPizza11:00am - 2:30pmWednesdayPizza11:00am - 2:30pm
99
WednesdayDish12:00pm - 2:00pmWednesdayDish12:00pm - 2:00pm
100
WednesdayFSA12:00pm - 2:30pmWednesdayFSA12:00pm - 2:30pm