Spreadsheet: 881329d1729378353-how-many-vehicles-can-be-held-on-o-license-o-license
Sheet: Cash Balance

DAY | Date | BANK BALANCE | Monthly Figure calculated as the average of the sum of the 3 highest values and the lowest value. |  |  |  | Represent # Vehicles | ([NAME] Used)
SUNDAY | 2024-10-20 00:00:00 | 84371.87 |  |  |  |  | 1 | G2 : =(F8-8500) | H3 : =ROUNDDOWN(G3,0)
MONDAY |  | 90814.73 |  |  |  |  |  | G3 : =(G2/4500)
TUESDAY |  | 68369.11999999997 |  |  |  | Total Number Of Vehicles |  | H4 : =H2+H3
WEDNESDAY |  | 72953.68999999997
THURSDAY |  | 73097.26999999997 |  | 2024-11-01 00:00:00
FRIDAY |  | 27813.87999999998 |  | 3 High | Average | expected result
SATURDAY |  | 27813.87999999998 |  |  |  | 24
SUNDAY |  | 27813.87999999998
MONDAY |  | 29411.05999999998
TUESDAY |  | 29271.05999999998 |  | 1 Low
WEDNESDAY |  | 33855.62999999998
THURSDAY |  | 33855.62999999998
FRIDAY |  | 63896.24999999998
SATURDAY |  | 63896.24999999998 |  | =(F39-8500)
SUNDAY |  | 63896.24999999998
MONDAY |  | 70523.10999999997
TUESDAY |  | 70383.10999999997
WEDNESDAY |  | 73301.00999999998
THURSDAY |  | 68071.32999999999
FRIDAY |  | 128948.34
SATURDAY |  | 128948.34
SUNDAY |  | 128948.34
MONDAY |  | 132665.92
TUESDAY |  | 131291.12
WEDNESDAY |  | 135875.69
THURSDAY |  | 142756.37
FRIDAY |  | 135286.55
SATURDAY |  | 135286.55
SUNDAY |  | 135286.55
MONDAY |  | 131155.75
TUESDAY |  | 131015.75
WEDNESDAY |  | 134350.32
THURSDAY |  | 133966.32
FRIDAY |  | 146111.24
SATURDAY |  | 146111.24
SUNDAY |  | 146111.24 |  | 2024-12-01 00:00:00
MONDAY |  | 86123.79999999994 |  | 3 High | Average | expected result
TUESDAY |  | 61990.93999999994 |  |  |  | 42
WEDNESDAY |  | 66575.50999999995
THURSDAY |  | 61345.82999999995
FRIDAY |  | 106622.83 |  | 1 Low
SATURDAY |  | 106622.83
SUNDAY |  | 106622.83
MONDAY |  | 109543.42
TUESDAY |  | 109403.42
WEDNESDAY |  | 113787.99
THURSDAY |  | 113787.99
FRIDAY |  | 154415.1899999999
SATURDAY |  | 154415.1899999999
SUNDAY |  | 154415.1899999999
MONDAY |  | 161242.0499999999
TUESDAY |  | 182038.0099999999
WEDNESDAY |  | 186622.5799999999
THURSDAY |  | 195708.7999999999
FRIDAY |  | 243232.3499999999
SATURDAY |  | 243232.3499999999
SUNDAY |  | 243232.3499999999
MONDAY |  | 208957.9399999999
TUESDAY |  | 207319.3899999999
WEDNESDAY |  | 200946.2999999999
THURSDAY |  | 200946.2999999999
FRIDAY |  | 247219.8499999999
SATURDAY |  | 247219.8499999999
SUNDAY |  | 247219.8499999999
MONDAY |  | 227501.7699999999
TUESDAY |  | 227505.3499999999 |  | 2025-01-01 00:00:00
WEDNESDAY |  | 158347.5699999999 |  | 3 High | Average | expected result
THURSDAY |  | 114730.8699999999 |  |  |  | 53
FRIDAY |  | 156024.7399999999
SATURDAY |  | 156024.7399999999
SUNDAY |  | 156024.7399999999 |  | 1 Low
MONDAY |  | 162851.5999999999
TUESDAY |  | 162711.5999999999
WEDNESDAY |  | 161143.3499999999
THURSDAY |  | 161143.3499999999
FRIDAY |  | 208466.8999999998
SATURDAY |  | 208466.8999999998
SUNDAY |  | 208466.8999999998
MONDAY |  | 213627.0899999998
TUESDAY |  | 208257.4099999998
WEDNESDAY |  | 212841.9799999998
THURSDAY |  | 212841.9799999998
FRIDAY |  | 280653.1199999999
SATURDAY |  | 280653.1199999999
SUNDAY |  | 280653.1199999999
MONDAY |  | 286245.1799999999
TUESDAY |  | 296426.1999999999
WEDNESDAY |  | 301010.7699999999
THURSDAY |  | 240788.1499999999
FRIDAY |  | 277307.5599999999
SATURDAY |  | 277307.5599999999
SUNDAY |  | 277307.5599999999
MONDAY |  | 282884.4199999999
TUESDAY |  | 282360.4199999999
WEDNESDAY |  | 258052.3499999999
THURSDAY |  | 258252.3499999999
FRIDAY |  | 232656.5999999998 |  | 2025-02-01 00:00:00
SATURDAY |  | 232656.5999999998 |  | 3 High | Average | expected result
SUNDAY |  | 232656.5999999998 |  |  |  | 69
MONDAY |  | 195866.7599999998
TUESDAY |  | 190497.0799999998
WEDNESDAY |  | 195081.6499999998 |  | 1 Low
THURSDAY |  | 195081.6499999998
FRIDAY |  | 241429.8199999998
SATURDAY |  | 241429.8199999998
SUNDAY |  | 241429.8199999998
MONDAY |  | 243279.2399999998
TUESDAY |  | 242939.2399999998
WEDNESDAY |  | 247523.8099999998
THURSDAY |  | 245857.1399999998
FRIDAY |  | 288151.0099999998
SATURDAY |  | 288151.0099999998
SUNDAY |  | 288151.0099999998
MONDAY |  | 315265.4599999998
TUESDAY |  | 315125.4599999998
WEDNESDAY |  | 318475.2299999998
THURSDAY |  | 328796.2499999998
FRIDAY |  | 376319.7999999998
SATURDAY |  | 376319.7999999998
SUNDAY |  | 376319.7999999998
MONDAY |  | 322877.5599999998
TUESDAY |  | 311779.8999999998
WEDNESDAY |  | 316364.4699999998
THURSDAY |  | 314730.4699999998
FRIDAY |  | 333391.3699999998
SATURDAY |  | 333391.3699999998
SUNDAY |  | 333391.3699999998
MONDAY |  | 340331.8199999998 |  | 2025-03-01 00:00:00
TUESDAY |  | 267128.9399999997 |  | 3 High | Average | expected result
WEDNESDAY |  | 228096.8099999997 |  |  |  | 75
THURSDAY |  | 228096.8099999997
FRIDAY |  | 269215.2999999998
SATURDAY |  | 269215.2999999998 |  | 1 Low
SUNDAY |  | 269215.2999999998
MONDAY |  | 271064.7199999997
TUESDAY |  | 270724.7199999997
WEDNESDAY |  | 275309.2899999997
THURSDAY |  | 273642.6199999998
FRIDAY |  | 315936.4899999998
SATURDAY |  | 315936.4899999998
SUNDAY |  | 315936.4899999998
MONDAY |  | 343050.9399999998
TUESDAY |  | 342910.9399999998
WEDNESDAY |  | 346260.7099999998
THURSDAY |  | 356581.7299999998
FRIDAY |  | 404105.2799999998
SATURDAY |  | 404105.2799999998
SUNDAY |  | 404105.2799999998
MONDAY |  | 350663.0399999998
TUESDAY |  | 339565.3799999998
WEDNESDAY |  | 344149.9499999998
THURSDAY |  | 342515.9499999998
FRIDAY |  | 361176.8499999997
SATURDAY |  | 361176.8499999997
SUNDAY |  | 361176.8499999997
MONDAY |  | 368117.2999999998