Spreadsheet: 834952d1688186042-calculate-february-correctly-for-monthly-allocation-working-copy-aligw
Sheet: Sheet1

START | END | ANNUAL COMPOSITE RATE | Monthly Rate factor(.08333) | Daily Rate factor (.00278) | TOTAL COST PER COMPOSITE RATE | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Total Order | Total Full Months |  | Days for Beginning Month | Days for Ending Month |  | Total Billable days | Total Order matches monthly [NAME]
 |  |  |  |  |  | 2022-10-30 00:00:00 | 2022-11-30 00:00:00 | 2022-12-30 00:00:00 | 2023-01-30 00:00:00 | 2023-02-28 00:00:00 | 2023-03-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-30 00:00:00 | 2023-08-30 00:00:00 | 2023-09-30 00:00:00
2022-11-01 00:00:00 | 2023-09-30 00:00:00 | 206546 | 17212.1667 | 573.73889 | 189333.83 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 30 | 30 | 0 | 330
2022-11-14 00:00:00 | 2023-06-05 00:00:00 | 88084 | 7340.3333 | 244.67778 | 49424.91 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 17 | 5 | 22 | 202
2022-11-14 00:00:00 | 2023-09-30 00:00:00 | 206546 | 17212.1667 | 573.73889 | 181875.23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 17 | 30 | 17 | 317
2022-11-14 00:00:00 | 2023-09-30 00:00:00 | 68804 | 5733.6667 | 191.12222 | 60585.74 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 17 | 30 | 17 | 317
2022-12-11 00:00:00 | 2023-09-30 00:00:00 | 139678 | 11639.8333 | 387.99444 | 112518.39 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 20 | 30 | 20 | 290
2023-01-09 00:00:00 | 2023-09-30 00:00:00 | 88084 | 7340.3333 | 244.67778 | 64105.58 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 22 | 30 | 22 | 262
2023-02-06 00:00:00 | 2023-09-30 00:00:00 | 139678 | 11639.8333 | 387.99444 | 91178.69 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 25 | 30 | 25 | 235
2023-01-09 00:00:00 | 2023-09-30 00:00:00 | 139678 | 11639.8333 | 387.99444 | 101654.54 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 22 | 30 | 22 | 262
2023-01-23 00:00:00 | 2023-09-30 00:00:00 | 206546 | 17212.1667 | 573.73889 | 142287.24 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8 | 30 | 8 | 248
2023-02-04 00:00:00 | 2023-02-28 00:00:00 | 239499 | 19958.25 | 665.275 | 16631.88 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25 | 0 | 25 | 25
2023-02-06 00:00:00 | 2023-02-18 00:00:00 | 162373 | 13531.0833 | 451.03611 | 5863.47 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 13 | 0 | 13 | 13
2023-02-20 00:00:00 | 2023-09-30 00:00:00 | 162373 | 13531.0833 | 451.03611 | 99678.98 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 11 | 30 | 11 | 221
2023-02-20 00:00:00 | 2023-09-30 00:00:00 | 172697 | 14391.4167 | 479.71389 | 106016.77 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 11 | 30 | 11 | 221
2023-04-01 00:00:00 | 2023-09-26 00:00:00 | 206546 | 17212.1667 | 573.73889 | 100978.04 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 30 | 26 | 26 | 176
2023-02-20 00:00:00 | 2023-06-07 00:00:00 | 162373 | 13531.0833 | 451.03611 | 48711.9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 11 | 7 | 18 | 108
2023-04-01 00:00:00 | 2023-09-30 00:00:00 | 206546 | 17212.1667 | 573.73889 | 103273 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 30 | 30 | 0 | 180
2023-04-05 00:00:00 | 2023-08-02 00:00:00 | 139678 | 11639.8333 | 387.99444 | 45783.34 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 26 | 2 | 28 | 118
2023-03-13 00:00:00 | 2023-09-30 00:00:00 | 88084 | 7340.3333 | 244.67778 | 48446.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 18 | 30 | 18 | 198
2023-03-11 00:00:00 | 2023-09-30 00:00:00 | 206546 | 17212.1667 | 573.73889 | 114747.78 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 20 | 30 | 20 | 200
2023-04-15 00:00:00 | 2023-09-30 00:00:00 | 110026 | 9168.8333 | 305.62778 | 50734.21 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 16 | 30 | 16 | 166
2023-05-06 00:00:00 | 2023-06-19 00:00:00 | 162373 | 13531.0833 | 451.03611 | 19845.59 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25 | 19 | 44 | 44
2023-05-20 00:00:00 | 2023-09-30 00:00:00 | 206546 | 17212.1667 | 573.73889 | 75159.79 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 11 | 30 | 11 | 131
2023-05-27 00:00:00 | 2023-09-30 00:00:00 | 162373 | 13531.0833 | 451.03611 | 55928.48 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4 | 30 | 4 | 124
2023-07-08 00:00:00 | 2023-09-30 00:00:00 | 121561 | 10130.0833 | 337.66944 | 28026.56 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 23 | 30 | 23 | 83
2023-07-08 00:00:00 | 2023-09-30 00:00:00 | 110026 | 9168.8333 | 305.62778 | 25367.11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 23 | 30 | 23 | 83
 |  |  |  |  |  | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00