Mock run of apps-script/Code.gs (placeholder data). Clock: 21/09/2026 09:00 to 19/10/2026 08:00 Australia/Melbourne
Events replayed: 73 form submissions, 258 staff edits, 28 daily refreshes, 4 weekly summaries
Triggers installed by setup(): onFormSubmit, refreshTracker, weeklySummary
Gmail drafts created: 4 (none sent)

[2026-09-21 09:00] Setup complete: 3 triggers installed.
[2026-09-21 10:42] CPC-0001 added: Routine, Appliances, Unit 12, 140 Brenvale Rd, assigned to Ivan P. (HVAC)
[2026-09-21 15:21] CPC-0002 added: Urgent, Heating & cooling, 11 Wickmere St, assigned to Ivan P. (HVAC)
[2026-09-22 07:00] Tracker refreshed: 2 rows, 0 overdue
[2026-09-22 11:25] CPC-0003 added: Routine, Plumbing, 118 Callowfield St, assigned to Rafe M. (plumber)
[2026-09-22 11:57] CPC-0004 added: Routine, Electrical, Unit 12, 140 Brenvale Rd, assigned to Noor S. (electrician)
[2026-09-22 19:53] CPC-0005 added: Routine, General repairs, 118 Callowfield St, assigned to Dan T. (handyman)
[2026-09-23 07:00] Tracker refreshed: 5 rows, 0 overdue
[2026-09-23 21:57] CPC-0006 added: Emergency, Plumbing, 20 Ardenvine Way, assigned to Rafe M. (plumber)
[2026-09-24 06:24] CPC-0007 added: Routine, Electrical, 90 Callowfield St, assigned to Noor S. (electrician)
[2026-09-24 07:00] Tracker refreshed: 7 rows, 0 overdue
[2026-09-24 07:24] CPC-0008 added: Routine, General repairs, Unit 2, 118 Sorrelby Rd, assigned to Dan T. (handyman)
[2026-09-24 09:25] CPC-0009 added: Urgent, Electrical, Unit 4, 86 Pellowe Cres, assigned to Noor S. (electrician)
[2026-09-24 13:38] CPC-0010 added: Routine, Electrical, 49 Quoyle Ave, assigned to Noor S. (electrician)
[2026-09-24 14:57] CPC-0011 added: Urgent, Plumbing, 118 Callowfield St, assigned to Rafe M. (plumber)
[2026-09-24 21:18] CPC-0012 added: Routine, Appliances, Unit 1, 37 Pellowe Cres, assigned to Ivan P. (HVAC)
[2026-09-25 07:00] Tracker refreshed: 12 rows, 0 overdue
[2026-09-25 07:16] CPC-0013 added: Routine, Electrical, Unit 12, 87 Haskerton St, assigned to Noor S. (electrician)
[2026-09-26 07:00] Tracker refreshed: 13 rows, 0 overdue
[2026-09-26 08:26] CPC-0014 added: Urgent, Heating & cooling, Unit 12, 140 Brenvale Rd, assigned to Ivan P. (HVAC)
[2026-09-26 14:11] CPC-0015 added: Urgent, Locks & security, 117 Marrowby Ct, assigned to Dan T. (handyman)
[2026-09-27 06:33] CPC-0016 added: Routine, Locks & security, 118 Callowfield St, assigned to Dan T. (handyman)
[2026-09-27 07:00] Tracker refreshed: 16 rows, 0 overdue
[2026-09-28 07:00] Tracker refreshed: 16 rows, 3 overdue
[2026-09-28 08:00] Tracker refreshed: 16 rows, 3 overdue
[2026-09-28 08:00] Weekly summary draft created (r-mock-1): Sample Property Care maintenance summary: Mon 21 Sep to Sun 27 Sep 2026
[2026-09-28 08:58] CPC-0017 added: Urgent, Electrical, Unit 4, 86 Pellowe Cres, assigned to Noor S. (electrician)
[2026-09-28 10:53] CPC-0018 added: Urgent, Locks & security, 90 Callowfield St, assigned to Dan T. (handyman)
[2026-09-28 14:07] CPC-0019 added: Routine, Electrical, 110 Marrowby Ct, assigned to Noor S. (electrician)
[2026-09-28 16:25] CPC-0020 added: Urgent, General repairs, 118 Callowfield St, assigned to Dan T. (handyman)
[2026-09-29 07:00] Tracker refreshed: 20 rows, 1 overdue
[2026-09-29 07:11] CPC-0021 added: Routine, Heating & cooling, 117 Marrowby Ct, assigned to Ivan P. (HVAC)
[2026-09-29 08:48] CPC-0022 added: Urgent, General repairs, 40 Haskerton St, assigned to Dan T. (handyman)
[2026-09-29 17:45] CPC-0023 added: Routine, Locks & security, 55 Sorrelby Rd, assigned to Dan T. (handyman)
[2026-09-29 18:30] CPC-0024 added: Routine, General repairs, 137 Brenvale Rd, assigned to Dan T. (handyman)
[2026-09-30 07:00] Tracker refreshed: 24 rows, 1 overdue
[2026-09-30 16:17] CPC-0025 added: Routine, Electrical, Unit 1, 37 Pellowe Cres, assigned to Noor S. (electrician)
[2026-09-30 18:13] CPC-0026 added: Routine, Plumbing, Unit 1, 37 Pellowe Cres, assigned to Rafe M. (plumber)
[2026-10-01 07:00] Tracker refreshed: 26 rows, 0 overdue
[2026-10-01 16:29] CPC-0027 added: Urgent, Heating & cooling, 99 Quoyle Ave, assigned to Ivan P. (HVAC)
[2026-10-01 22:25] CPC-0028 added: Urgent, Electrical, 40 Haskerton St, assigned to Noor S. (electrician)
[2026-10-02 07:00] Tracker refreshed: 28 rows, 0 overdue
[2026-10-02 14:33] CPC-0029 added: Routine, Heating & cooling, 55 Sorrelby Rd, assigned to Ivan P. (HVAC)
[2026-10-02 15:43] CPC-0030 added: Urgent, Locks & security, 2 Wickmere St, assigned to Dan T. (handyman)
[2026-10-03 07:00] Tracker refreshed: 30 rows, 0 overdue
[2026-10-03 12:53] CPC-0031 added: Routine, Plumbing, 20 Ardenvine Way, assigned to Rafe M. (plumber)
[2026-10-03 14:39] CPC-0032 added: Urgent, Appliances, Unit 1, 37 Pellowe Cres, assigned to Ivan P. (HVAC)
[2026-10-04 07:00] Tracker refreshed: 32 rows, 0 overdue
[2026-10-04 07:31] CPC-0033 added: Emergency, Locks & security, 20 Ardenvine Way, assigned to Dan T. (handyman)
[2026-10-04 17:27] CPC-0034 added: Routine, General repairs, 90 Callowfield St, assigned to Dan T. (handyman)
[2026-10-04 17:54] CPC-0035 added: Emergency, Electrical, Unit 2, 109 Tindle Pde, assigned to Noor S. (electrician)
[2026-10-05 07:00] Tracker refreshed: 35 rows, 3 overdue
[2026-10-05 08:00] Tracker refreshed: 35 rows, 3 overdue
[2026-10-05 08:00] Weekly summary draft created (r-mock-2): Sample Property Care maintenance summary: Mon 28 Sep to Sun 4 Oct 2026
[2026-10-05 09:30] CPC-0036 added: Routine, General repairs, 100 Quoyle Ave, assigned to Dan T. (handyman)
[2026-10-05 11:54] CPC-0037 added: Routine, Plumbing, 73 Wickmere St, assigned to Rafe M. (plumber)
[2026-10-05 17:25] CPC-0038 added: Emergency, Locks & security, 73 Wickmere St, assigned to Dan T. (handyman)
[2026-10-05 18:35] CPC-0039 added: Routine, General repairs, 55 Sorrelby Rd, assigned to Dan T. (handyman)
[2026-10-05 19:17] CPC-0040 added: Routine, Appliances, 86 Brenvale Rd, assigned to Ivan P. (HVAC)
[2026-10-06 05:22] CPC-0041 added: Routine, Appliances, 49 Quoyle Ave, assigned to Ivan P. (HVAC)
[2026-10-06 07:00] Tracker refreshed: 41 rows, 1 overdue
[2026-10-06 18:58] CPC-0042 added: Routine, General repairs, 11 Wickmere St, assigned to Dan T. (handyman)
[2026-10-06 20:49] CPC-0043 added: Urgent, General repairs, Unit 12, 87 Haskerton St, assigned to Dan T. (handyman)
[2026-10-07 07:00] Tracker refreshed: 43 rows, 1 overdue
[2026-10-07 14:48] CPC-0044 added: Urgent, General repairs, Unit 1, 37 Pellowe Cres, assigned to Dan T. (handyman)
[2026-10-08 07:00] Tracker refreshed: 44 rows, 1 overdue
[2026-10-09 07:00] Tracker refreshed: 44 rows, 1 overdue
[2026-10-09 07:40] CPC-0045 added: Routine, Plumbing, 86 Wickmere St, assigned to Rafe M. (plumber)
[2026-10-09 10:53] CPC-0046 added: Routine, Appliances, 118 Callowfield St, assigned to Ivan P. (HVAC)
[2026-10-09 11:47] CPC-0047 added: Routine, General repairs, 117 Marrowby Ct, assigned to Dan T. (handyman)
[2026-10-09 12:29] CPC-0048 added: Urgent, General repairs, Unit 12, 87 Haskerton St, assigned to Dan T. (handyman)
[2026-10-10 07:00] Tracker refreshed: 48 rows, 1 overdue
[2026-10-10 07:36] CPC-0049 added: Emergency, Plumbing, Unit 2, 118 Sorrelby Rd, assigned to Rafe M. (plumber)
[2026-10-11 07:00] Tracker refreshed: 49 rows, 2 overdue
[2026-10-11 08:30] CPC-0050 added: Routine, Heating & cooling, Unit 4, 84 Pellowe Cres, assigned to Ivan P. (HVAC)
[2026-10-11 08:50] CPC-0051 added: Routine, Locks & security, 137 Brenvale Rd, assigned to Dan T. (handyman)
[2026-10-11 13:45] CPC-0052 added: Urgent, General repairs, 110 Marrowby Ct, assigned to Dan T. (handyman)
[2026-10-12 07:00] Tracker refreshed: 52 rows, 2 overdue
[2026-10-12 08:00] Tracker refreshed: 52 rows, 2 overdue
[2026-10-12 08:00] Weekly summary draft created (r-mock-3): Sample Property Care maintenance summary: Mon 5 Oct to Sun 11 Oct 2026
[2026-10-12 14:08] CPC-0053 added: Routine, Electrical, 137 Brenvale Rd, assigned to Noor S. (electrician)
[2026-10-13 07:00] Tracker refreshed: 53 rows, 1 overdue
[2026-10-13 09:40] CPC-0054 added: Routine, Electrical, Unit 2, 109 Tindle Pde, assigned to Noor S. (electrician)
[2026-10-13 09:51] CPC-0055 added: Routine, Electrical, Unit 5, 120 Callowfield St, assigned to Noor S. (electrician)
[2026-10-14 07:00] Tracker refreshed: 55 rows, 1 overdue
[2026-10-14 07:42] CPC-0056 added: Routine, Electrical, Unit 12, 87 Haskerton St, assigned to Noor S. (electrician)
[2026-10-14 13:12] CPC-0057 added: Routine, Appliances, 40 Marrowby Ct, assigned to Ivan P. (HVAC)
[2026-10-14 17:26] CPC-0058 added: Routine, General repairs, 137 Brenvale Rd, assigned to Dan T. (handyman)
[2026-10-15 02:46] CPC-0059 added: Routine, Plumbing, Unit 2, 109 Tindle Pde, assigned to Rafe M. (plumber)
[2026-10-15 06:20] CPC-0060 added: Urgent, Heating & cooling, 125 Tindle Pde, assigned to Ivan P. (HVAC)
[2026-10-15 07:00] Tracker refreshed: 60 rows, 3 overdue
[2026-10-15 08:17] CPC-0061 added: Routine, Electrical, 117 Marrowby Ct, assigned to Noor S. (electrician)
[2026-10-15 10:22] CPC-0062 added: Routine, Electrical, 90 Callowfield St, assigned to Noor S. (electrician)
[2026-10-16 06:47] CPC-0063 added: Routine, Plumbing, 137 Brenvale Rd, assigned to Rafe M. (plumber)
[2026-10-16 07:00] Tracker refreshed: 63 rows, 1 overdue
[2026-10-16 14:02] CPC-0064 added: Routine, Electrical, 55 Sorrelby Rd, assigned to Noor S. (electrician)
[2026-10-16 15:08] CPC-0065 added: Routine, Locks & security, 2 Wickmere St, assigned to Dan T. (handyman)
[2026-10-17 07:00] Tracker refreshed: 65 rows, 1 overdue
[2026-10-17 08:33] CPC-0066 added: Routine, Electrical, 117 Marrowby Ct, assigned to Noor S. (electrician)
[2026-10-17 09:23] CPC-0067 added: Urgent, General repairs, 105 Ardenvine Way, assigned to Dan T. (handyman)
[2026-10-17 09:25] CPC-0068 added: Routine, Electrical, 73 Wickmere St, assigned to Noor S. (electrician)
[2026-10-17 10:14] CPC-0069 added: Urgent, Appliances, 49 Quoyle Ave, assigned to Ivan P. (HVAC)
[2026-10-17 15:11] CPC-0070 added: Routine, Heating & cooling, 2 Wickmere St, assigned to Ivan P. (HVAC)
[2026-10-18 02:47] CPC-0071 added: Urgent, Heating & cooling, 118 Callowfield St, assigned to Ivan P. (HVAC)
[2026-10-18 07:00] Tracker refreshed: 71 rows, 0 overdue
[2026-10-18 09:25] CPC-0072 added: Urgent, Plumbing, 11 Wickmere St, assigned to Rafe M. (plumber)
[2026-10-18 15:32] CPC-0073 added: Urgent, General repairs, 125 Tindle Pde, assigned to Dan T. (handyman)
[2026-10-19 07:00] Tracker refreshed: 73 rows, 3 overdue
[2026-10-19 08:00] Tracker refreshed: 73 rows, 4 overdue
[2026-10-19 08:00] Weekly summary draft created (r-mock-4): Sample Property Care maintenance summary: Mon 12 Oct to Sun 18 Oct 2026
