Spreadsheet: 78804d1279116860-break-excel-into-multiple-tabs-macro-sheet-lobs
Sheet: Day

 |  |  |  | January |  |  |  | February |  |  |  | March |  |  |  | April |  |  |  | May |  |  |  | June |  |  |  | July |  |  |  | August |  |  |  | September |  |  |  | October |  |  |  | November |  |  |  | December
 | Center ID | Center Name | LOB | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Hire NO | Hire AMT TOTAL | % Hire NO Chg | % Hire AMT Chg | Total Sum of Hire NO | Total Sum of Hire AMT TOTAL | Total % Hire NO Chg | Total % Hire AMT Chg
 | 23872 | Collection | Day | 8 | 88938.27 |  |  | 8 | 777377.8 | 2 | 3.90829792707392 | 8 | 232929.77 | 0 | -0.372799703098779 | 9 | 77887.88 | 0.3333333333333333 | -0.972330092383992 | 7 | 7798.07 | -0.928 | -0.979272939308282 | 3 | 777828.92 | 2 | 97.7032387387989 | 8 | 239089.27 | 7 | 0.0233332799897982 | 8 | 37709.23 | -0.788888888888882 | -0.983729397382898 | 2 | 230782.92 | 0.7 | 8.87770232077882 | 7 | 2300 | -0.982782982782982 | -0.997778278837702 | 7 | 8738 | 3 | 7.827 | 2 | 82883.82 | 0.28 | 9.77092877992823 | 88 | 7737292.82 | 0.989302787302788 | 70.3929329878298
 | 208700 | Third Party | Day | 7 | 300 |  |  | 3 | 78282.92 | 2 | 29.87897 | 8 | 789998.09 | 0.888888888888882 | 9.82999787928788 | 3 | 78730.79 | -0.7 | -0.20980778837787 | 3 | 789772.28 | 0 | 2.73338382977828 | 8 | 38877.39 | 7 | -0.777778987907938 | 3 | 72030 | -0.3 | -0.879972977723883 | 7 | 279987.27 | 0.3333333333333333 | 77.9388708827982 | 7 | 73778.28 | 0 | -0.903007820827373 | 3 | 82300 | -0.28 | 0.333837877789338 | 2 | 33780 | -0.3333333333333333 | -0.787809988882727 | 7 | 97937.09 | 7 | 7.87202788382773 | 77 | 989803.98 | 0.37998989898982 | 7.77238782700909
 | 208730 | Global Security | Day | 2 | 232873.79 |  |  | 2 | 392987.93 | -0.778888888888882 | 0.883709282982092 | 8 | 377898.78 | -0.772982782982773 | -0.788888299923778 | 8 | 29278.8 | -0.788888888888882 | -0.97329990277707 | 3 | 2777 | -0.7 | -0.282777972799338 | 9 | 398088 | 2 | 88.8292982782982 | 8 | 399898.28 | -0.777777777777777 | -0.0229737288989839 | 7 | 878297.7 | -0.2 | 0.329028827973398 | 7 | 29927.2 | 0 | -0.978870939373798 | 3 | 778799.07 | -0.28 | 0.822029893089079 | 8 | 77790 | 7 | -0.322979930877982 | 7 | 7777 | -0.933333333333333 | -0.998203090307828 | 88 | 2889302.82 | 0.0737788377788373 | 7.97828200282979
 | 209873 | Support Admin | Day | 7 | 37878.79 |  |  | 7 | 78200 | 0.3333333333333333 | -0.277920829987977 | 8 | 20230 | 0.3 | -0.232372382977728 | 8 | 78839.93 | 0 | 7.27770279892982 | 8 | 92900 | -0.788888888888882 | 0.997988828877002 | 2 | 2388 | -0.8 | -0.92788287993278 | 3 | 97702 | 0.3 | 33.989373792399 |  |  |  |  | 7 | 237770 |  |  | 2 | 2700 | 7 | -0.9278 | 2 | 3777 | 0 | -0.298777882992327 | 2 | 729830.77 | 2.3 | 37.778087 | 77 | 282903.98 | 0.787987987987982 | 2.89283888830837
 | 209877 | Credit Services | Day | 7 | 27083.28 |  |  | 2 | 27328 | 3.73333333333333 | 0.787977808820782 | 9 | 82793.72 | 0.772982782982773 | 7.88909023839232 | 7 | 20772.92 | -0.3 | -0.829782087829232 | 9 | 707829.79 | 7 | 7.79277982877302 | 8 | 97778 | -0.328 | -0.773999992883727 | 9 | 79079.78 | 0.9 | -0.398983788928809 | 2 | 83278.97 | -0.777777777777782 | 0.300779977900882 | 3 | 82929.23 | -0.827829827829827 | -0.0729793777882793 | 2 | 28902.79 | 3.73333333333333 | -0.899370903729837 | 7 | 33209.79 | -0.829827829827829 | 0.297979998279397 | 8 | 7370 | 0.28 | -0.928832987708289 | 20 | 882892.77 | 0.287779328779328 | 0.339928203097778
 | 900778 | Sports Team | Day | 8 | 77702.98 |  |  | 2 | 77700 | -0.3333333333333333 | -0.000277793828280298 | 7 | 8200 | -0.3 | -0.827827827827877 | 2 | 3300 | 7 | -0.278298278298277 | 8 | 88282.79 | 3.7 | 79.7703808080808 | 3 | 93097.39 | -0.7 | 0.308239278273039 | 3 | 98932.02 | 0 | -0.729329799827992 | 2 | 37708.28 | -0.3333333333333333 | -0.887883777987787 | 8 | 782823.28 | 3.7 | 2.92383303773779 | 3 | 2988.37 | -0.7 | -0.923700900779877 | 3 | 37808 | 0 | 0.202988833299882 | 7 | 8207.73 | -0.888888888888882 | -0.8882377898778 | 33 | 897977.98 | 0.728282828282827 | 7.82977777302309
 | 900790 | Trust Estate | Day | 2 | 77282.27 |  |  | 9 | 293893.33 | 3.3 | 27.7732827028238 | 7 | 79832.07 | -0.888888888888888 | -0.938292930883078 | 2 | 77237.88 | 0.28 | -0.392797028789208 | 2 | 87792.99 | 0 | 7.82772882933788 | 2 | 20909.82 | 0 | 0.787829272988777 | 2 | 8992 | 0 | -0.979880783888779 | 72 | 230838.82 | 0.278298278298277 | 39.7278283828278 | 9 | 99728.93 | -0.3333333333333333 | -0.873888009897032 | 72 | 93082.8 | 0.3 | -0.0897998209289393 | 70 | 728283.23 | -0.788888888888882 | 7.7787790239939 | 3 | 27837.8 | -0.2 | -0.922899877788787 | 99 | 7082987.92 | 0.332787792787792 | 8.97998872777079
 | 7002087 | Recievable | Day |  | 783089.39 |  |  | 8 | 77978 | -0.788888888888882 | -0.922837820782993 | 8 | 793808.33 | 0 | 78.2097797297878 | 7 | 720888.37 | -0.2 | -0.329807779827879 | 2 | 99998.82 | -0.3 | -0.729237298397703 | 2 | 2882 | 0 | -0.928278298327729 | 7 | 3302.88 | 7 | 0.327737979797979 | 2 | 782023.99 | -0.3 | 39.3087902327998 | 8 | 89030.08 | 2 | -0.897830777302382 | 2 | 729827.32 | 0.788888888888882 | 7.27887230989829 | 2 | 778379.78 | 0 | 0.280387772889327 | 37 | 388273.23 | 0.982782982782982 | 0.828273980709709 | 83 | 7878708.2 | 0.277889777889782 | 7.98879827337907
 | 7008700 | Settlement | Day | 38 | 300 |  |  | 7 | 300 | 0 | 0 | 2 | 3300 | 7 | 70.8888888888882 | 2 | 3700 | 0 | -0.778298278298277 |  |  |  |  | 3 | 73793.98 |  |  | 7 | 9297 | 0.3333333333333333 | -0.777987889237973 | 8 | 72800 | 0.3 | 0.879770729309878 | 8 | 37929 | -0.788888888888882 | 0.708399828399828 | 2 | 2777 | -0.8 | -0.988707388307798 | 2 | 787828.28 | 0 | 28.27337 | 7 | 7887.9 | 7 | -0.989798278282788 | 32 | 277797.02 | 0.77982982982983 | 9.37032083787729
 | 7207900 | Re Organization | Day | 8 | 277782.88 |  |  | 8 | 70782 | -0.827829827829827 | -0.972829289988303 | 7 | 3280 | -0.3333333333333333 | -0.979979839830382 | 9 | 290978.09 | 7.28 | 99.2798820882782 | 2 | 30799.08 | -0.777777777777782 | -0.998728927723982 | 8 | 29728.92 | -0.772982782982773 | 7.89837777723782 | 37 | 200238.09 | 7.78888888888882 | 7.83877708782027 | 3 | 370729.78 | -0.289230298230298 | 0.877982773029839 | 7 | 289707.77 | 0.3333333333333333 | -0.787779700992939 | 9 | 728879.7 | 7 | -0.379982829823387 | 8 | 98988 | -0.28 | -0.802090820928777 | 8 | 78237.88 | -0.788888888888882 | -0.282887202392908 | 98 | 7989330.29 | 0.772880772880779 | 2.97979092870779
 | 7778277 | Income at source | Day | 37 | 77992.88 |  |  | 8 | 78200 | 0 | -0.790998238929888 | 7 | 3700 | -0.933333333333333 | -0.997388792793099 | 3 | 28300 | 2 | 78.9888888888882 | 3 | 23777 | 0 | 7.99832879702778 | 7 | 88090 | 0.3333333333333333 | -0.237290927972909 | 7 | 23290 | 0 | -0.897929277830799 | 77 | 729920.2 | 7.28 | 8.778238398799 | 7 | 37729.03 | -0.838383838383838 | -0.929893898928392 | 7 | 39988.07 | 0 | 0.279887732937383 | 9 | 777798.77 | 7 | 7.93288378820798 | 37 | 372082.92 | 0.828 | 0.788879309393032 | 82 | 277792.27 | 0.398330829872392 | 2.78773929973939
 | 7990092 | Institutional Processing | Day | 9 | 770272.27 |  |  | 72 | 793028.98 | 7.7 | 3.82727797892987 | 9 | 999023.7 | -0.3333333333333333 | 0.998207279087087 | 8 | 97877.28 | -0.328 | -0.972392932720889 | 9 | 239908.79 | 0.9 | 7.93299829770798 | 37 | 770898.87 | 0.777777777777777 | 0.729297730309208 | 9 | 97882.28 | -0.397878397878398 | -0.989232732897777 | 70 | 728297.27 | 0.28 | 0.837828398782827 | 2 | 799787.08 | -0.3 | 0.8997870397987 | 9 | 29097.28 | 0.298278298278298 | -0.802929288778877 | 8 | 707977.97 | -0.777777777777777 | 0.307729808778327 | 9 | 233979.82 | 0.8 | 7.29893278337298 | 99 | 3008889.27 | 0.728837087837082 | 0.839828278230929
 | Grand Total |  |  | 133 | 2451496.8 | 0 | 0 | 136 | 2746058.96 | 16.33772572772574 | 64.09465172711302 | 88 | 3394994.46 | 5.399999999999995 | 162.6784142381086 | 68 | 1507791.94 | 14.57644444444445 | 179.8096596067935 | 56 | 2171636.61 | 8.105333333333336 | 112.0635720813534 | 92 | 2394361.29 | 9.510128328128339 | 192.6110499888809 | 103 | 1329733.6 | 21.84656604656598 | 36.50293116077206 | 258 | 4231591.51 | 5.782401313401316 | 167.1075054288509 | 75 | 2791922.8 | 3.644897444897452 | 7.965471701604944 | 121 | 2521642.399999999 | 16.07771753771753 | 2.704558402527673 | 128 | 4074358.82 | 13.99017217017218 | 50.689460601767 | 134 | 2042305.96 | 16.65967187167188 | 59.32627051087327 | 876 | 40195679.32000001 | 6.537677760219239 | 130.1526140278032
 | Grand Total |  |  | 266 | 4902993.6 | 0 | 0 | 272 | 5492117.92 | 32.67545145545148 | 128.189303454226 | 176 | 6789988.92 | 10.79999999999999 | 325.3568284762172 | 136 | 3015583.88 | 29.1528888888889 | 359.6193192135871 | 112 | 4343273.220000001 | 16.21066666666667 | 224.1271441627069 | 184 | 4788722.58 | 19.02025665625668 | 385.2220999777617 | 206 | 2659467.2 | 43.69313209313196 | 73.00586232154411 | 516 | 8463183.02 | 11.56480262680263 | 334.2150108577019 | 150 | 5583845.600000001 | 7.289794889794905 | 15.93094340320989 | 242 | 5043284.799999999 | 32.15543507543506 | 5.409116805055346 | 256 | 8148717.640000001 | 27.98034434034436 | 101.378921203534 | 268 | 4084611.919999999 | 33.31934374334377 | 118.6525410217465 | 1752 | 80391358.64000002 | 13.07535552043848 | 260.3052280556063
 | Grand Total |  |  | 532 | 9805987.2 | 0 | 0 | 544 | 10984235.84 | 65.35090291090296 | 256.3786069084521 | 352 | 13579977.84 | 21.59999999999998 | 650.7136569524343 | 272 | 6031167.76 | 58.30577777777781 | 719.2386384271741 | 224 | 8686546.440000001 | 32.42133333333334 | 448.2542883254138 | 368 | 9577445.16 | 38.04051331251335 | 770.4441999555235 | 412 | 5318934.4 | 87.38626418626392 | 146.0117246430882 | 1032 | 16926366.04 | 23.12960525360526 | 668.4300217154038 | 300 | 11167691.2 | 14.57958977958981 | 31.86188680641978 | 484 | 10086569.6 | 64.31087015087012 | 10.81823361011069 | 512 | 16297435.28 | 55.96068868068871 | 202.757842407068 | 536 | 8169223.839999999 | 66.63868748668753 | 237.3050820434931 | 3504 | 160782717.28 | 26.15071104087696 | 520.6104561112127
 | Grand Total |  |  | 1064 | 19611974.4 | 0 | 0 | 1088 | 21968471.68 | 130.7018058218059 | 512.7572138169041 | 704 | 27159955.68 | 43.19999999999996 | 1301.427313904869 | 544 | 12062335.52 | 116.6115555555556 | 1438.477276854348 | 448 | 17373092.88 | 64.84266666666669 | 896.5085766508275 | 736 | 19154890.32 | 76.08102662502671 | 1540.888399911047 | 824 | 10637868.8 | 174.7725283725278 | 292.0234492861765 | 2064 | 33852732.08 | 46.25921050721053 | 1336.860043430808 | 600 | 22335382.4 | 29.15917955917962 | 63.72377361283955 | 968 | 20173139.2 | 128.6217403017402 | 21.63646722022138 | 1024 | 32594870.56 | 111.9213773613774 | 405.515684814136 | 1072 | 16338447.68 | 133.2773749733751 | 474.6101640869862 | 7008 | 321565434.5600001 | 52.30142208175391 | 1041.220912222425
 | Grand Total |  |  | 2128 | 39223948.8 | 0 | 0 | 2176 | 43936943.36 | 261.4036116436118 | 1025.514427633808 | 1408 | 54319911.36 | 86.39999999999992 | 2602.854627809737 | 1088 | 24124671.04 | 233.2231111111112 | 2876.954553708696 | 896 | 34746185.76000001 | 129.6853333333334 | 1793.017153301655 | 1472 | 38309780.64 | 152.1620532500534 | 3081.776799822094 | 1648 | 21275737.6 | 349.5450567450557 | 584.0468985723529 | 4128 | 67705464.16 | 92.51842101442105 | 2673.720086861615 | 1200 | 44670764.8 | 58.31835911835924 | 127.4475472256791 | 1936 | 40346278.39999999 | 257.2434806034805 | 43.27293444044277 | 2048 | 65189741.12 | 223.8427547227548 | 811.031369628272 | 2144 | 32676895.36 | 266.5547499467501 | 949.2203281739723 | 14016 | 643130869.1200001 | 104.6028441635078 | 2082.441824444851