Spreadsheet: 782468d1654072014-determine-in-which-month-sample-data-will-pass-limit-based-on-monthly-average-sample-data_2
Sheet: Sample Data 2

Customer | Column | Column | Column | Column | Column | Minimum of Start Date | Sub Item End Date | Description | Charge Type | Last Bill Date | % Plan Limit Used | Apr [NAME] | Included Units | [NAME] | Feb Cumulative Qty | Jan Cumulative Qty | Date Due | Late?
Name1 |  |  |  |  |  | 2020-12-22 00:00:00 | 2023-12-21 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 73739491.24 | 200000000 | 68512823.37 | 63266824.26 | 58987145.31
[NAME] |  |  |  |  |  | 2022-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5159467.67 | 90000000 | 3801557.75 | 2606521.21 | 5813334.08
Name3 |  |  |  |  |  | 2021-09-13 00:00:00 | 2022-09-12 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 2043229.1 | 2500000 | 1770563.2 | 1494093.83 | 1231223.69
Name4 |  |  |  |  |  | 2021-06-22 00:00:00 | 2022-06-21 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 78748.03 | 150000 | 38826.14 | 32646.76 | 32646.76
Name5 |  |  |  |  |  | 2021-05-24 00:00:00 | 2022-05-23 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 48331029.8 | 41666666.7 | 44803503.51 | 37910673 | 32728463.08
Name6 |  |  |  |  |  | 2021-10-01 00:00:00 | 2023-12-27 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 13721111.69 | 130000000 | 11432637.91 | 9336781.67 | 7287726.97
Name7 |  |  |  |  |  | 2021-09-29 00:00:00 | 2024-09-28 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 16885402.61 | 140000000 | 14423931.01 | 11663846.19 | 9301836.4
Name8 |  |  |  |  |  | 2021-11-01 00:00:00 | 2023-10-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 32275469.29 | 132000000 | 27377607.38 | 21909292.56 | 16959287.17
Name9 |  |  |  |  |  | 2021-11-01 00:00:00 | 2022-10-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5163939.41 | 8500000 | 4245841.19 | 3306564.39 | 2517195.94
Name10 |  |  |  |  |  | 2022-02-01 00:00:00 | 2022-04-29 00:00:00 |  |  | 2022-04-29 00:00:00 |  | 571838.01 | 639424 | 571838.01 | 2853514.53 | 2550576.39
Name11 |  |  |  |  |  | 2022-01-13 00:00:00 | 2023-01-12 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5606232.405 | 20000000 | 4025986.472 | 2444799.717 | 2230176.08
Name12 |  |  |  |  |  | 2021-03-01 00:00:00 | 2024-02-29 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 48622009.12 | 170000000 | 44861258.63 | 41191424.51 | 37647102.57
Name13 |  |  |  |  |  | 2021-12-07 00:00:00 | 2022-12-06 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1015241.06 | 4000000 | 786630.54 | 540284.76 | 319604
Name14 |  |  |  |  |  | 2021-10-01 00:00:00 | 2022-09-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1933233.695 | 3800000 | 1654977.395 | 1348209.29 | 1107369.63
Name15 |  |  |  |  |  | 2021-12-28 00:00:00 | 2023-12-27 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 3030499.4 | 34000000 | 2020507.79 | 1222165.4 | 541915.31
[NAME] |  |  |  |  |  | 2020-07-01 00:00:00 | 2023-06-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 72442509.27 | 75000000 | 72442509.27 | 68915625.221 | 62501505.461
Name17 |  |  |  |  |  | 2022-02-01 00:00:00 | 2023-01-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 43287496.27 | 200000000 | 29937271.53 | 11932776.37 | 153136062.28
Name18 |  |  |  |  |  | 2021-07-23 00:00:00 | 2022-07-22 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1413557.472 | 1650000 | 1236209.009 | 1047180.469 | 878734.395
Name19 |  |  |  |  |  | 2022-02-11 00:00:00 | 2023-02-10 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 555425.938 | 1500000 | 317070.441 | 98137.51 | 1158796.79
[NAME] |  |  |  |  |  | 2019-12-01 00:00:00 | 2022-11-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 8656422.58 | 12000000 | 8350772.17 | 8030183.76 | 7757314.92
Name21 |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 10874497.32 | 5700000 | 4721979.53 | 4721979.53 | 5059770.576
Name22 |  |  |  |  |  | 2021-07-01 00:00:00 | 2022-06-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 16864510.829 | 22000000 | 14745306.622 | 12485030.938 | 11606745.56
Name23 |  |  |  |  |  | 2021-09-02 00:00:00 | 2024-09-01 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 7790359.21 | 22500000 | 6695070.22 | 5556873.45 | 4558607.86
Name24 |  |  |  |  |  | 2021-12-30 00:00:00 | 2022-12-29 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 325731.03 | 1020000 | 243581.72 | 158891.07 | 84033.97
Name25 |  |  |  |  |  | 2021-12-10 00:00:00 | 2024-12-09 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 463705.09 | 3600000 | 361596.42 | 248005.66 | 152122.72
Name26 |  |  |  |  |  | 2021-11-17 00:00:00 | 2022-11-16 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 22497207.82 | 68000000 | 17552909.01 | 13077892.49 | 9245799.29
Name27 |  |  |  |  |  | 2021-07-01 00:00:00 | 2024-06-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 13504157.2 | 60000000 | 11843296.25 | 11007327.94 | 9588947.51
Name28 |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 2902231.42 | 8000000 | 2226401.43 | 1335204.1 | 630606.99
Name29 |  |  |  |  |  | 2021-09-01 00:00:00 | 2022-08-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 2061080.4 | 4000000 | 1843160.45 | 1592636.67 | 1383858.89
Name30 |  |  |  |  |  | 2021-06-01 00:00:00 | 2022-05-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 12858376.95 | 12000000 | 11669796.41 | 10389920.56 | 9242511.65
Name31 |  |  |  |  |  | 2021-04-12 00:00:00 | 2023-04-11 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1511615.48 | 2000000 | 1345519.04 | 1175697.09 | 1026039.99
Name32 |  |  |  |  |  | 2021-12-01 00:00:00 | 2023-07-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5591538.415 | 42000000 | 4274093.585 | 3089900.853 | 2082003.268
Name33 |  |  |  |  |  | 2021-06-01 00:00:00 | 2022-05-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 13609657.9 | 19000000 | 12173488.6 | 10726029.26 | 9418544.4
[NAME] |  |  |  |  |  | 2022-04-01 00:00:00 | 2023-03-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 196484.52 | 2600000 | #N/A | #N/A | #N/A
Name35 |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 795242.32 | 2600000 | 545441.5 | 376240.42 | 4201556.06
Name36 |  |  |  |  |  | 2021-11-16 00:00:00 | 2022-11-15 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 15520268.95 | 20000000 | 11675193.32 | 8730513.49 | 6574551.57
Name37 |  |  |  |  |  | 2021-09-30 00:00:00 | 2024-09-29 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 4535978.25 | 40920000 | 3242520.03 | 2582802.78 | 2011670.02
Name38 |  |  |  |  |  | 2021-04-01 00:00:00 | 2024-03-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 48110568.58 | 132400000 | 48110568.58 | 48110568.58 | 43518860.57
[NAME] |  |  |  |  |  | 2021-09-23 00:00:00 | 2024-09-22 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 189411.64 | 2460000 | 154897.98 | 126209.87 | 102862.41
Name40 |  |  |  |  |  | 2021-11-18 00:00:00 | 2023-11-17 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1791957.08 | 8500000 | 1344366.29 | 946908.81 | 683639.22
Name41 |  |  |  |  |  | 2022-03-01 00:00:00 | 2023-02-28 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 799171.839 | 6000000 | 391394.648 | 5700163.92 | 5271659.22
Name42 |  |  |  |  |  | 2020-07-01 00:00:00 | 2023-06-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 868338.177 | 1050000 | 747623.214 | 651885.384 | 573855.363
Name43 |  |  |  |  |  | 2022-03-30 00:00:00 | 2023-03-29 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 806844.06 | 5700000 | 215362.08 | #N/A | #N/A
Name44 |  |  |  |  |  | 2022-03-01 00:00:00 | 2022-09-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 3949030.24 | 15400000 | 1982433.42 | 28138973.56 | 26234279.22
Name45 |  |  |  |  |  | 2021-08-11 00:00:00 | 2022-08-10 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 13013029.42 | 18000000 | 11534155.16 | 9955286.32 | 8549878.5
Name46 |  |  |  |  |  | 2021-12-01 00:00:00 | 2023-03-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 22459168.64 | 73000000 | 18986079.39 | 15164127.08 | 11464906.23
[NAME] |  |  |  |  |  | 2021-11-01 00:00:00 | 2022-10-31 00:00:00 |  |  | 2021-11-30 00:00:00 |  | 2470955.89 | 42000000 | 18986079.39 | 15164127.08 | 11464906.23
Name48 |  |  |  |  |  | 2021-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 49250827.1 | 52500000 | 43632957.62 | 43632957.62 | 40940435.09
Name49 |  |  |  |  |  | 2021-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1370635.52 | 3750000 | 1280208.26 | 869300.77 | 805172.62
Name50 |  |  |  |  |  | 2021-07-30 00:00:00 | 2024-07-29 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 9835139.57 | 45000000 | 7439016.81 | 4091146.36 | 2537702.68
Name51 |  |  |  |  |  | 2021-10-05 00:00:00 | 2022-10-04 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 4858564.82 | 10000000 | 4180772.86 | 3390706.71 | 2685567.65
[NAME] |  |  |  |  |  | 2021-11-22 00:00:00 | 2022-11-21 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5974853.7 | 36000000 | 4737682.33 | 3505834.4 | 2431272.35
Name53 |  |  |  |  |  | 2020-07-01 00:00:00 | 2022-06-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 22004876.99 | 23000000 | 20490464.74 | 19087870.54 | 18060077.28
Name54 |  |  |  |  |  | 2021-10-01 00:00:00 | 2022-09-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1405988.25 | 2140000 | #N/A | #N/A | #N/A
Name55 |  |  |  |  |  | 2022-02-26 00:00:00 | 2025-02-25 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1343777.264 | 61500000 | 715360.058 | 9920068.232 | 8703802.52
Name56 |  |  |  |  |  | 2020-10-01 00:00:00 | 2023-09-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 37428283.572 | 45000000 | 34898313.546 | 32808838.899 | 30694009.495
Name57 |  |  |  |  |  | 2021-11-01 00:00:00 | 2022-10-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 756378.5 | 1500000 | 479512.37 | 479512.37 | 359959.82
Name58 |  |  |  |  |  | 2021-04-01 00:00:00 | 2023-03-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 57920693.02 | 70000000 | 49034442.7 | 49034442.7 | 44365407.98
Name59 |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 37227665.8 | 70000000 | 30683329.3 | 25607549.11 | 70429033.35
Name60 |  |  |  |  |  | 2021-05-01 00:00:00 | 2022-04-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 34952939.8 | 37500000 | 32170236.18 | 29293563.53 | 25688151.75
Name61 |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1325847.02 | 2600000 | 918219.04 | 581516.109 | 266165.385
Name62 |  |  |  |  |  | 2022-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 14356967.052 | 165000000 | 10936398.793 | 7433201.861 | 6092688.557
Name63 |  |  |  |  |  | 2021-06-29 00:00:00 | 2022-07-28 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 13168350.49 | 12600000 | 11957984.63 | 10607212.64 | 10561622.58
Name64 |  |  |  |  |  | 2022-03-01 00:00:00 | 2023-02-28 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 2554306.72 | 15000000 | 1333885.16 | 5587521.8 | 3644489.13
Name65 |  |  |  |  |  | 2021-10-01 00:00:00 | 2022-09-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 8076305.68 | 18500000 | 5767378.51 | 5767378.51 | 4688536.05
Name66 |  |  |  |  |  | 2021-11-01 00:00:00 | 2022-10-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 50154898.66 | 91500000 | 41041517.79 | 31774780.98 | 64959137.71
[NAME] |  |  |  |  |  | 2021-11-05 00:00:00 | 2024-08-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5519271.21 | 150000000 | 4596005.26 | 2925412.82 | 2238124.3
[NAME] |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5119514.48 | 11000000 | 3705551.97 | 2208139.78 | 1079264
Name69 |  |  |  |  |  | 2021-07-23 00:00:00 | 2022-07-22 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 8509734.38 | 11500000 | 7531472.57 | 6423114.69 | 5495422.61
Name70 |  |  |  |  |  | 2021-10-01 00:00:00 | 2024-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 993091.955 | 4300000 | 729373.532 | 459878.961 | 322706.878
Name71 |  |  |  |  |  | 2020-09-01 00:00:00 | 2022-08-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 37099588.87 | 47000000 | 34983460.5 | 30345427.31 | 28008135.34
Name72 |  |  |  |  |  | 2021-10-01 00:00:00 | 2024-09-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 94297343.5 | 525000000 | 79429557.14 | 64342893.26 | 51092338.34
[NAME] |  |  |  |  |  | 2022-02-01 00:00:00 | 2022-09-06 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 1249674.01 | 2000000 | 819984.58 | 370222.89 | 1226566.98
Name74 |  |  |  |  |  | 2022-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 9530312.07 | 55000000 | 6087428.79 | 3816624.98 | 13564076.69
Name75 |  |  |  |  |  | 2021-01-31 00:00:00 | 2024-01-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5503656.21 | 55000000 | 5088546.32 | 4902845.64 | 4571068.05
Name76 |  |  |  |  |  | 2021-12-01 00:00:00 | 2023-11-30 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 28368731.739 | 145000000 | 22359395.541 | 16442577.578 | 10868794.421
Name77 |  |  |  |  |  | 2022-02-01 00:00:00 | 2023-01-31 00:00:00 |  |  | 2022-03-31 00:00:00 |  | 5307451.25 | 32000000 | 5307451.25 | 9114524.4 | 24254396.58
Name78 |  |  |  |  |  | 2022-03-01 00:00:00 | 2022-08-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 3152556.82 | 8000000 | 1471937.2 | 26053796.79 | 26053796.79
Name79 |  |  |  |  |  | 2021-09-30 00:00:00 | 2026-09-29 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 21290542.739 | 235000000 | 15547097.87 | 15547097.87 | 12722498.34
Name80 |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  | 2022-04-30 00:00:00 |  | 5022447.48 | 22000000 | 3560317.14 | 2360240.18 | 1335822.21