Spreadsheet: 824885d1680922263-can-averageifs-work-with-my-variable-range-book1-jomili-
Sheet: L1001O Overtime

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining Months in Fiscal Year+1
 | FY_AP
DEPTID | 2023_01 | 2023_02 | 2023_03 | 2023_04 | 2023_05 | 2023_06 | 2023_07 | Proj-2023_08 | Proj-2023_09 | Proj-2023_10 | Proj-2023_11 | Proj-2023_12 | YTD Total | Avg Monthly Expenses | Projected Expense in Remaining Months | Total Projected Expense | Difference To Load | Prior Projection (from [NAME]'s book) | Prior Projection ([NAME], going as far as we want)
11ADDINH | 54024.22000000001 | 58325.38000000001 | 58325.38000000001 | 58325.38 | 58325.38 | 58325.38000000001 | 0
00FCLCSS | 7560.1 | 7560.1 | 4218.75 | 5287.530000000001 | 7615.68 | 7647.7 | 0
00FCLSWI | 1393895.61 | 1373524.58 | 1397344.54 | 1389997.869999999 | 1389171.429999999 | 1383963.579999999 | 4065.269999999997
00SWISDD | 300072.4899999999 | 301334.4599999999 | 296514.4599999998 | 293863.8999999999 | 296314.3699999999 | 299873.1799999998 | 0
00SWISCR | 5209.87 | 5209.87 | 5209.87 | 5209.87 | 5209.87 | 5209.87 | 0
00FCECEN | 0 | 0 |  | 0
00HRDOSS | 190176.27 | 197733.63 | 196783.7 | 200823.28 | 196602.88 | 191754.04 | 0
00CLOSCP | 156250.11 | 156250.11 | 156250.11 | 156250.11 | 151344.68 | 151689.0699999999 | 0
00ACCOTH | 52710.44 | 52710.44 | 52710.44 | 57176.44 | 57176.44000000001 | 57176.44 | 0
00CDDOTH | 96075.88000000002 | 98470.6 | 99436.75 | 99444.23999999999 | 103928.21 | 103744.81 | 0
00FCECEN | 17249.9 | 17249.9 | 17249.9 | 16666.57 | 13617.33 | 16958.24 | 0
00FCLAED | 0 | 0
00FCLCCS |  | 0
00FCLCOA | 10787.15 | 10787.15 | 10787.15 | 15933.91 | 16746.55 | 16746.55 | 0
00FCLCSO | 0 | 0
00FCLCSS | 6334.45 | 6334.45 | 6334.45 | 6334.45 | 6334.45 | 6334.45 | 0
00FCLCVS | 11246.35 | 11246.35 | 11246.35 | 11246.35 | 11246.35 | 11246.35 | 0
00FCLDDS | 57753.23 | 54039.97 | 66224.22 | 73692.25999999998 | 73450.98 | 68852.32 | 0
00FCLLCI | 0 | 0 |  | 0
00FCLLEG | 53285.71 | 56741.97 | 61705.86 | 61705.86000000001 | 61705.86 | 61705.86 | 0
00FCLOTH | 65799.37 | 65799.37 | 67467.91999999998 | 72244.84999999998 | 77343.71999999999 | 74242.93999999999 | 0
00FCLRES | 4987.5 | 4987.5 | 4987.5 | 4987.5 | 4987.5 | 4987.5 | 0
00FCLRSI |  | 0
00FCLSWI | 10921.21 | 10921.21 | 10921.21 | 10921.21 | 10921.21 | 10921.21 | 0
00FSSOTH | 0 | 0
00INVARS | 0 | 0
00INVCSS | 43658.92 | 43658.92 | 43658.92 | 37872.23 | 37872.23 | 42085.52999999999 | 0
00MEDOTH | 15791.96 | 12971.04 | 0 | 0 |  | 0 | 0
00OCACEN | 5643.75 | 5643.75 | 5205 | 5205 | 5205 | 5205 | 0
00PACCEN | 14248.09 | 14248.09 | 14248.09 | 14248.09 | 18171.19 | 19325.05 | 0
00PERDDO | 81934.1 | 83506.97 | 89319.36000000002 | 94791.44 | 98027.37 | 100882.06 | 0
00PLCDDO | 0 | 0
00RESRVS | 0 | 0
00RSI000 | 25128.32 | 25128.32 | 25128.32 | 25128.32 | 25128.32 | 25128.32 | 0
01CDDOTH | 7388.299999999999 | 7388.299999999999 | 7388.299999999999 | 7388.299999999998 | 7388.299999999999 | 7388.299999999999 | 0
01INVOTH | 15616.6 | 17046.18 | 14658.83 | 14658.83 | 14658.83 | 14658.83 | 0
02CDDOTH | 32218.7 | 31714.73 | 27668.96 | 40108.61 | 36966.03 | 45741.2 | 0
04CDDOTH | 13560.15 | 13560.15 | 13560.15 | 13560.15 | 13560.15 | 13560.15 | 0
04INVOTH | 28400.37 | 28400.37 | 23193.13 | 23193.13 | 23193.13 | 23193.13 | 0
05CDDOTH | 83040.52 | 80411.39 | 76343.16 | 73755.99 | 72613.93999999999 | 87288.3 | 345.0299999999988
07CDDOTH | 21128.64 | 21128.64 | 21128.64 | 21128.64 | 21128.64 | 21128.64 | 0
07INVOTH | 37865.45 | 36563.8 | 38946.31 | 39475.75999999999 | 39475.75999999999 | 39475.75999999999 | 0
08CDDCVS | 40028.91 | 40028.91 | 40028.91 | 40028.91 | 41465.74999999999 | 54827.17000000001 | 0
08CDDOTH | 8339.29 | 8339.29 | 8339.29 | 8339.29 | 8339.29 | 8339.29 | 0
08INVOTH |  |  | 4665.05 | 4665.05 | 4665.05 | 4665.05 | 0
09CDDFAD | 10989.83 | 12433.63 | 14091.67 | 14091.67 | 14091.67 | 14091.67 | 0
09CDDOTH | 2343.54 | 2343.54 | 2343.54 | 5875.63 | 7523.94 | 7523.94 | 0
09INVOTH | 38114.18 | 38114.18 | 38114.18 | 38114.18 | 38114.18 | 42893.96 | 0
10CDDOTH | 69402.68000000001 | 73145.74999999999 | 71814.68 | 73869.22999999998 | 76334.68 | 83625.79000000001 | 0
11CDDOTH | 11445.47 | 11445.47 | 11445.47 | 11445.47 | 11445.47 | 11445.47 | 0
11INVOTH | 4848.95 | 4848.95 | 4848.95 | 4848.95 | 4848.95 | 4848.95 | 0
3ECDDCVS | 2939.46 | 2939.46 | 2939.46 | 2939.46 | 2939.46 | 2939.46 | 0
3ECDDELG | 135351.79 | 132573.15 | 136573.85 | 132459.8 | 129082.44 | 143088.17 | 65.41000000000349
3ECDDOTH | 8822.58 | 8822.58 | 8822.58 | 8822.58 | 8822.58 | 8822.58 | 0
3EINVOTH | 103408.86 | 106358.31 | 106343.71 | 106358.31 | 106358.31 | 110844.12 | 288.5
3WCDDOTH | 21679.72 | 21679.72 | 21679.72 | 21679.72 | 21679.72 | 21679.72 | 0
3WINVOTH | 126291.28 | 128768.81 | 128768.81 | 128768.81 | 137335.58 | 143608.91 | 0
6ACDDOTH | 7143.4 | 5447.78 | 5447.78 | 5447.780000000001 | 5447.78 | 8199.91 | 0
6AINVOTH | 32853.59 | 32853.59 | 32853.59 | 35083.82000000001 | 35306.84 | 35306.84 | 0
6BCDDOTH | 11285.1 | 11285.1 | 11285.1 | 11285.1 | 11285.1 | 11285.1 | 0
6BINVOTH |  | 0
00SWISCR | 67082.87000000001 | 64151.68000000001 | 59469.52 | 57158.41 | 58137.85000000001 | 65362.19 | 0
00EPR000 | 0 | 0
00INVDDF | 84206.83 | 84206.83 | 84206.83000000002 | 84206.83 | 84206.83 | 84206.83 | 0
00OOACRM | 282889.5899999999 | 282889.5899999999 | 280495.7 | 288576.1399999998 | 288576.1399999998 | 283944.0499999999 | 0
00OOACSS |  | 0 | 16239.89 | 16239.89 | 16239.89 | 16239.89 | 0
00AAIAIA | 78297.45999999999 | 78297.45999999999 | 78297.45999999999 | 78290.06000000001 | 78297.45999999999 | 78297.45999999999 | 0
00CDDMCV | 0 | 0
00FCECEN | 0 | 0