Spreadsheet: 674121d1587667501-creating-running-total-with-inconsistent-periods-rolling-utilization-example
Sheet: Sheet1

 |  | Period End Date | Fiscal Month | Fiscal Year | Week Day | Employee | Utilized Hours | Total Hours | Weekly Utilzation | Rolling 1 Year Utilization
 |  | 2020-04-17 00:00:00 | 4 | 2020 | Friday | [NAME] | 35 | 40
 |  | 2020-04-10 00:00:00 | 4 | 2020 | Friday | [NAME] | 35 | 40
 |  | 2020-04-03 00:00:00 | 4 | 2020 | Friday | [NAME] | 36 | 40
 |  | 2020-03-28 00:00:00 | 4 | 2020 | Saturday | [NAME] | 0 | 0
 |  | 2020-03-27 00:00:00 | 3 | 2020 | Friday | [NAME] | 28 | 40
 |  | 2020-03-20 00:00:00 | 3 | 2020 | Friday | [NAME] | 20 | 40
 |  | 2020-03-13 00:00:00 | 3 | 2020 | Friday | [NAME] | 39 | 40
 |  | 2020-03-06 00:00:00 | 3 | 2020 | Friday | [NAME] | 40 | 40
 |  | 2020-02-29 00:00:00 | 3 | 2020 | Saturday | [NAME] | 0 | 0
 |  | 2020-02-28 00:00:00 | 2 | 2020 | Friday | [NAME] | 28 | 40
 |  | 2020-02-21 00:00:00 | 2 | 2020 | Friday | [NAME] | 20 | 40
 |  | 2020-02-14 00:00:00 | 2 | 2020 | Friday | [NAME] | 39 | 40
 |  | 2020-02-07 00:00:00 | 2 | 2020 | Friday | [NAME] | 40 | 40
 |  | 2020-02-01 00:00:00 | 2 | 2020 | Saturday | [NAME] | 0 | 0
 |  | 2020-01-31 00:00:00 | 1 | 2020 | Friday | [NAME] | 28 | 40
 |  | 2020-01-24 00:00:00 | 1 | 2020 | Friday | [NAME] | 20 | 40
 |  | 2020-01-17 00:00:00 | 1 | 2020 | Friday | [NAME] | 39 | 40
 |  | 2020-01-10 00:00:00 | 1 | 2020 | Friday | [NAME] | 40 | 40
 |  | 2020-01-03 00:00:00 | 1 | 2020 | Friday | [NAME] | 35 | 39
 |  | 2020-01-01 00:00:00 | 1 | 2020 | Wednesday | [NAME] | 0 | 1
 |  | 2019-12-31 00:00:00 | 12 | 2019 | Tuesday | [NAME] | 10 | 16
 |  | 2019-12-27 00:00:00 | 12 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-12-20 00:00:00 | 12 | 2019 | Friday | [NAME] | 38 | 40
 |  | 2019-12-13 00:00:00 | 12 | 2019 | Friday | [NAME] | 34 | 40
 |  | 2019-12-06 00:00:00 | 12 | 2019 | Friday | [NAME] | 37 | 40
 |  | 2019-11-30 00:00:00 | 12 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-11-29 00:00:00 | 11 | 2019 | Friday | [NAME] | 28 | 40
 |  | 2019-11-22 00:00:00 | 11 | 2019 | Friday | [NAME] | 20 | 40
 |  | 2019-11-15 00:00:00 | 11 | 2019 | Friday | [NAME] | 39 | 40
 |  | 2019-11-08 00:00:00 | 11 | 2019 | Friday | [NAME] | 40 | 40
 |  | 2020-11-02 00:00:00 | 11 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-11-01 00:00:00 | 10 | 2019 | Friday | [NAME] | 28 | 40
 |  | 2019-10-25 00:00:00 | 10 | 2019 | Friday | [NAME] | 20 | 40
 |  | 2019-10-18 00:00:00 | 10 | 2019 | Friday | [NAME] | 39 | 40
 |  | 2019-10-11 00:00:00 | 10 | 2019 | Friday | [NAME] | 40 | 40
 |  | 2019-10-04 00:00:00 | 10 | 2019 | Friday | [NAME] | 35 | 38
 |  | 2019-09-28 00:00:00 | 10 | 2019 | Saturday | [NAME] | 2 | 2
 |  | 2019-09-27 00:00:00 | 9 | 2019 | Friday | [NAME] | 20 | 40
 |  | 2019-09-20 00:00:00 | 9 | 2019 | Friday | [NAME] | 0 | 40
 |  | 2019-09-13 00:00:00 | 9 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-09-06 00:00:00 | 9 | 2019 | Friday | [NAME] | 37 | 40
 |  | 2019-08-31 00:00:00 | 9 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-08-30 00:00:00 | 8 | 2019 | Friday | [NAME] | 30 | 40
 |  | 2019-08-23 00:00:00 | 8 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-08-16 00:00:00 | 8 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-08-09 00:00:00 | 8 | 2019 | Friday | [NAME] | 30 | 35
 |  | 2019-08-03 00:00:00 | 8 | 2019 | Saturday | [NAME] | 4 | 5
 |  | 2019-08-02 00:00:00 | 7 | 2019 | Friday | [NAME] | 25 | 40
 |  | 2019-07-26 00:00:00 | 7 | 2019 | Friday | [NAME] | 30 | 40
 |  | 2019-07-19 00:00:00 | 7 | 2019 | Friday | [NAME] | 39 | 40
 |  | 2019-07-12 00:00:00 | 7 | 2019 | Friday | [NAME] | 40 | 40
 |  | 2019-07-05 00:00:00 | 7 | 2019 | Friday | [NAME] | 20 | 40
 |  | 2019-06-29 00:00:00 | 7 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-06-28 00:00:00 | 6 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-06-21 00:00:00 | 6 | 2019 | Friday | [NAME] | 39 | 40
 |  | 2019-06-14 00:00:00 | 6 | 2019 | Friday | [NAME] | 40 | 40
 |  | 2019-06-07 00:00:00 | 6 | 2019 | Friday | [NAME] | 20 | 39
 |  | 2019-06-01 00:00:00 | 6 | 2019 | Saturday | [NAME] | 1 | 1
 |  | 2019-05-31 00:00:00 | 5 | 2019 | Friday | [NAME] | 40 | 40
 |  | 2019-05-24 00:00:00 | 5 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-05-17 00:00:00 | 5 | 2019 | Friday | [NAME] | 38 | 40
 |  | 2019-05-10 00:00:00 | 5 | 2019 | Friday | [NAME] | 27 | 40
 |  | 2019-05-03 00:00:00 | 5 | 2019 | Friday | [NAME] | 25 | 40
 |  | 2020-04-27 00:00:00 | 5 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-04-26 00:00:00 | 4 | 2019 | Friday | [NAME] | 32 | 40
 |  | 2019-04-19 00:00:00 | 4 | 2019 | Friday | [NAME] | 31 | 40
 |  | 2019-04-12 00:00:00 | 4 | 2019 | Friday | [NAME] | 33 | 40
 |  | 2019-04-05 00:00:00 | 4 | 2019 | Friday | [NAME] | 25 | 40
 |  | 2019-03-30 00:00:00 | 4 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-03-29 00:00:00 | 3 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-03-22 00:00:00 | 3 | 2019 | Friday | [NAME] | 38 | 40
 |  | 2019-03-15 00:00:00 | 3 | 2019 | Friday | [NAME] | 29 | 40
 |  | 2019-03-08 00:00:00 | 3 | 2019 | Friday | [NAME] | 30 | 40
 |  | 2019-03-02 00:00:00 | 3 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-03-01 00:00:00 | 2 | 2019 | Friday | [NAME] | 38 | 40
 |  | 2019-02-22 00:00:00 | 2 | 2019 | Friday | [NAME] | 39 | 40
 |  | 2019-02-15 00:00:00 | 2 | 2019 | Friday | [NAME] | 40 | 40
 |  | 2019-02-08 00:00:00 | 2 | 2019 | Friday | [NAME] | 45 | 45
 |  | 2019-02-02 00:00:00 | 2 | 2019 | Saturday | [NAME] | 0 | 0
 |  | 2019-02-01 00:00:00 | 1 | 2019 | Friday | [NAME] | 30 | 40
 |  | 2019-01-25 00:00:00 | 1 | 2019 | Friday | [NAME] | 35 | 40
 |  | 2019-01-18 00:00:00 | 1 | 2019 | Friday | [NAME] | 20 | 40
 |  | 2019-01-11 00:00:00 | 1 | 2019 | Friday | [NAME] | 10 | 40
 |  | 2019-01-04 00:00:00 | 1 | 2019 | Friday | [NAME] | 15 | 32
 |  | 2019-01-01 00:00:00 | 1 | 2019 | Tuesday | [NAME] | 6 | 8
 |  | 2018-12-31 00:00:00 | 12 | 2018 | Monday | [NAME] | 0 | 8
 |  | 2018-12-28 00:00:00 | 12 | 2018 | Friday | [NAME] | 32 | 40
 |  | 2018-12-21 00:00:00 | 12 | 2018 | Friday | [NAME] | 29 | 40
 |  | 2018-12-14 00:00:00 | 12 | 2018 | Friday | [NAME] | 35 | 40
 |  | 2018-12-07 00:00:00 | 12 | 2018 | Friday | [NAME] | 26 | 40
 |  | 2018-12-01 00:00:00 | 12 | 2018 | Saturday | [NAME] | 0 | 0
 |  | 2018-11-30 00:00:00 | 11 | 2018 | Friday | [NAME] | 13 | 40
 |  | 2018-11-23 00:00:00 | 11 | 2018 | Friday | [NAME] | 29 | 40
 |  | 2018-11-16 00:00:00 | 11 | 2018 | Friday | [NAME] | 35 | 40
 |  | 2018-11-09 00:00:00 | 11 | 2018 | Friday | [NAME] | 35 | 35
 |  | 2018-11-03 00:00:00 | 11 | 2018 | Saturday | [NAME] | 5 | 5
 |  | 2018-11-02 00:00:00 | 10 | 2018 | Friday | [NAME] | 39 | 40
 |  | 2018-10-26 00:00:00 | 10 | 2018 | Friday | [NAME] | 38 | 40
 |  | 2018-10-19 00:00:00 | 10 | 2018 | Friday | [NAME] | 35 | 40
 |  | 2018-10-12 00:00:00 | 10 | 2018 | Friday | [NAME] | 19 | 40
 |  | 2018-10-05 00:00:00 | 10 | 2018 | Friday | [NAME] | 26 | 40
 |  | 2020-09-29 00:00:00 | 10 | 2018 | Saturday | [NAME] | 0 | 0
 |  | 2018-09-28 00:00:00 | 9 | 2018 | Friday | [NAME] | 32 | 40