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

 |  |  |  | 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
 | 2770820 | Collection | Evening | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 78777 |  |  | 7 | 2777 | -0.3 | -0.8828 | 3 | 32777.78 | 2 | 3.89802782982773 | 8 | 88777.78 | 0.28 | 7.87828027829827
 | 7990099 | Recievable | Evening | 7 | 983238.82 |  |  | 77 | 7293298.77 | -0.779827829827829 | 0.798279877992702 | 33 | 820777.03 | 0.777777777777782 | -0.878289973299808 | 38 | 938897.77 | 0.0808080808080808 | 0.87077720398307 | 28 | 889087.78 | -0.282782982782982 | -0.707789278798788 | 20 | 787879.07 | -0.230298230298237 | -0.798298999298287 | 37 | 829377.99 | 0.2 | -0.0887823982793999 | 82 | 7777727.02 | 0.829777288208992 | 7.77077882888097 | 39 | 987732.83 | -0.28 | -0.889792808299823 | 27 | 292930.88 | -0.787839787839782 | -0.797082309877993 | 79 | 870977.97 | -0.0982390982390982 | -0.797282028998802 | 77 | 888938.38 | 0.827082837829982 | -0.372829908783989 | 398 | 70337332.89 | 0.0378289877777987 | 0.777078977792828
 | 7990200 | Re Organization | Evening |  | 377999.09 |  |  | 9 | 30799.82 | 0.9 | -0.289929820288878 | 8 | 33877.28 | -0.3333333333333333 | 0.70289098887702 | 8 | 290290.97 | 0 | 2.83237799997027 | 3 | 38700 | -0.3 | -0.92780777399292 | 2 | 37902.33 | -0.3333333333333333 | -0.723828 | 8 | 82390.88 | 2 | 0.877879270077089 | 8 | 97782.82 | -0.788888888888882 | 0.770932830829307 | 3 | 27370.89 | -0.7 | -0.232929829839992 | 3 | 789297.72 | 0 | 8.87720297777097 | 8 | 797777.97 | 0.888888888888882 | 0.279827873737799 | 7 | 73798 | -0.2 | -0.972393398282977 | 82 | 7097878.07 | 0.379393939393939 | 7.07799703878837
 | 7990237 | Income at source | Evening |  | 799777.39 |  |  | 7 | 2830 | -0.982302982302982 | -0.989823990907378 | 8 | 72939.2 | 0.28 | 0.829798029733723 | 9 | 29377.82 | 0.8 | 7.20879328090289 | 3 | 77372.83 | -0.828 | -0.809829803303037 | 8 | 77977.27 | 7 | 3.03778297789332 | 7 | 33977.77 | -0.3333333333333333 | -0.273003798898703 | 9 | 272337.98 | 7 | 8.39829829877799 | 9 | 82029.93 | 0.728 | -0.277888827783092 | 9 | 73097.87 | -0.777777777777777 | -0.308777832028208 | 9 | 788307.88 | 0 | 2.93828783297998 | 9 | 99799 | 0.728 | -0.780702080297082 | 98 | 908278.28 | 0.727889998889992 | 0.998282932378239
 | 7990298 | Third Party | Evening | 787 | 878287.8 |  |  | 7 | 8700 | -0.928 | -0.992890998329207 | 8 | 303992.07 | 3 | 78.272928 | 8 | 308387.82 | -0.788888888888882 | -0.39772792990329 | 7 | 79080.78 | -0.2 | -0.93289028209298 | 9 | 708790 | 7.28 | 7.87997379792888 | 7 | 77377.23 | -0.888888888888888 | -0.890733278098729 | 77 | 239898.83 | 7.28 | 7.38988388297287 | 3 | 87378 | -0.777777777777782 | -0.777898337879237 | 3 | 9873 | 0 | -0.927278889877709 | 8 | 89877.7 | 7 | 2.79709798987877 | 7 | 32379.38 | -0.3333333333333333 | -0.730980823897797 | 87 | 7992778.89 | 0.889329282078877 | 9.02989399902998
 | 7990299 | Credit Services | Evening | 298 | 8700 |  |  | 8 | 88790 | 7 | 72.0382977728827 | 3 | 88330 | -0.7 | -0.782328887832977 | 7 | 32989.77 | 0.3333333333333333 | -0.779892373997029 | 7 | 20708.3 | 0 | -0.399097829777777 | 9 | 27723.93 | 7 | 2.83239077027772 | 70 | 70299 | 0.28 | -0.979790779390373 | 2 | 87978 | -0.3 | 7.09828882789889 | 8 | 98839.28 | -0.772982782982773 | 0.289778200897828 | 2 | 3779.23 | -0.888888888888882 | -0.982702878282077 | 2 | 7778 | 0 | -0.87707777792039 | 8 | 33399 | 3.7 | 28.2888702070978 | 82 | 782378.03 | 0.308209988209982 | 3.97787979782877
 | 7990777 | Institutional Processing | Evening | 777 | 8330 |  |  |  |  |  |  | 3 | 8828.79 |  |  |  |  |  |  |  |  |  |  | 7 | 77777 |  |  |  |  |  |  | 7 | 73777 |  |  |  |  |  |  |  |  |  |  | 7 | 78700 |  |  | 7 | 78298.83 | 3 | 7.92327770779777 | 72 | 729777.77 | 3 | 7.92327770779777
 | 7990779 | Trades | Evening | 377 | 88300 |  |  | 3 | 28829.7 | -0.28 | -0.823297897897898 | 3 | 700983.3 | 0 | 2.92073720778787 | 2 | 382798.27 | 3.73333333333333 | 2.87098937799787 | 2 | 98377.72 | 0 | -0.23089889820908 | 70 | 390298.78 | 0.829827829827829 | 3.08287038829398 | 9 | 299929.29 | -0.7 | -0.280872393888298 | 70 | 392989.29 | 0.777777777777777 | 0.372837832079379 | 9 | 792898.72 | -0.7 | -0.303377987300808 | 9 | 339080.03 | -0.777777777777777 | 0.287877038020773 | 2 | 792979.77 | -0.728 | -0.777787777799032 | 77 | 290777 | 7 | 0.778287788829798 | 97 | 7737882.29 | 0.799909823909827 | 0.987298777909078
 | 7990779 | Settlement | Evening | 777 | 38200 |  |  | 9 | 83082.97 | 7 | 0.277708827987929 | 8 | 9002.7 | -0.328 | -0.923779798797809 | 8 | 89798.92 | 0 | 8.73777888987777 | 2 | 8989 | -0.8 | -0.907798288239989 | 8 | 78308 | 3.7 | 7.9728778700272 | 8 | 77373 | 0.2 | -0.773277028087777 | 8 | 87738.39 | -0.788888888888882 | 3.73977727779878 | 7 | 82939.82 | -0.2 | -0.232787023277987 | 7 | 70898.89 | 0 | -0.779928770038297 | 3 | 72889.82 | -0.28 | -0.98977309877897 | 8 | 728387.89 | 0.888888888888882 | 9.90797778779883 | 88 | 792792.3 | 0.783783838383838 | 7.8820920970898
 | 7990800 | Support Admin | Evening | 3 | 39337.97 |  |  | 2 | 200 | -0.888888888888882 | -0.997779928388707 | 2 | 79790 | 2.3 | 28.7782982782982 | 7 | 90 | -0.982782982782982 | -0.998370082327877 | 3 | 37777.07 | 2 | 777.988 | 8 | 70970.9 | 0.888888888888882 | -0.789930379927979 | 2 | 2979 | 0.7 | -0.778292028299378 |  |  |  |  | 3 | 3200 |  |  |  |  |  |  |  |  |  |  | 7 | 2777 |  |  | 38 | 98779.88 | 0.823909823909827 | 29.7779887777828
 | 2850103 | Sports Team | Evening | 27900 | 88388 |  |  | 3 | 30300 | -0.827829827829827 | -0.787777939339933 | 7 | 9728.88 | 0.3333333333333333 | -0.23729202920292 | 2 | 78878 | 0.28 | 7.07977787832878 | 3 | 20300 | -0.827829827829827 | 0.279898787099829 | 7 | 33907.29 | 0.3333333333333333 | 0.820798209898882 | 3 | 77773.89 | -0.28 | -0.339070930920908 | 3 | 77828.77 | 0 | 0.98820782898288 | 2 | 89088.83 | 3.73333333333333 | 0.398209979790387 |  |  |  |  | 3 | 79300 |  |  | 8 | 729882.08 | 0.888888888888882 | 8.30800302982309 | 79 | 733377.77 | 0.777987827987828 | 0.298287879398038
 | 2850104 | Trust Estate | Evening | 398 | 3078 |  |  | 8 | 72887.98 | 7 | 2.30092987377799 | 9 | 700797.07 | 0.3333333333333333 | 7.82239893092779 | 9 | 77897.77 | 0.728 | -0.778872888799897 | 7 | 787792.29 | -0.888888888888888 | 7.09779292382879 | 77 | 37090.88 | 7.28 | -0.299999928379797 | 3 | 999.87 | -0.777777777777782 | -0.920207828982787 | 78 | 792978.72 | 7.33333333333333 | 792.83977989778 | 37 | 773708.39 | -0.7928 | -0.888887839379289 | 8 | 72978.98 | -0.839787839787839 | -0.977799027892783 | 3 | 32700 | -0.3 | 3.70283978298989 | 8 | 39320.32 | 0.888888888888882 | 0.797770829072378 | 92 | 7277723.92 | 0.879770379778983 | 78.9227279730983
 | Grand Total |  |  | 31326 | 3313637.07 | 0 | 0 | 133 | 7639719.24 | 17.21315047115048 | 70.5337157774893 | 92 | 2829046.32 | 5.663111111111114 | 116.5053607464911 | 98 | 2229407.11 | 4.18380287580288 | 26.64563135603256 | 65 | 2058185.77 | -2.127501699501697 | 780.4495795565141 | 225 | 2328625.45 | 33.74841848841847 | 23.01463670671392 | 154 | 1552477.92 | 0.3999999999999969 | -4.446151194769264 | 344 | 9901036.82 | 21.34311062154234 | 829.368785506001 | 120 | 3025186.69 | 0.237772772572775 | -2.915574473072013 | 70 | 1730713.6 | -4.072072072072056 | 4.391510307794676 | 131 | 3614066.11 | 6.182649790649783 | 5.393332796089244 | 226 | 3030534.66 | 19.3884161711633 | 57.04530896898555 | 1221 | 104577757.87 | 9.68801389032089 | 155.5310862371923
 | Grand Total |  |  | 62652 | 6627274.14 | 0 | 0 | 266 | 15279438.48 | 34.42630094230095 | 141.0674315549786 | 184 | 5658092.64 | 11.32622222222223 | 233.0107214929822 | 196 | 4458814.22 | 8.36760575160576 | 53.29126271206512 | 130 | 4116371.54 | -4.255003399003393 | 1560.899159113028 | 450 | 4657250.899999999 | 67.49683697683695 | 46.02927341342784 | 308 | 3104955.84 | 0.7999999999999938 | -8.892302389538528 | 688 | 19802073.64 | 42.68622124308467 | 1658.737571012002 | 240 | 6050373.38 | 0.4755455451455499 | -5.831148946144026 | 140 | 3461427.2 | -8.144144144144112 | 8.783020615589352 | 262 | 7228132.22 | 12.36529958129957 | 10.78666559217849 | 452 | 6061069.32 | 38.77683234232659 | 114.0906179379711 | 2442 | 209155515.74 | 19.37602778064178 | 311.0621724743845
 | Grand Total |  |  | 125304 | 13254548.28 | 0 | 0 | 532 | 30558876.96 | 68.85260188460191 | 282.1348631099572 | 368 | 11316185.28 | 22.65244444444446 | 466.0214429859644 | 392 | 8917628.44 | 16.73521150321152 | 106.5825254241302 | 260 | 8232743.08 | -8.510006798006787 | 3121.798318226056 | 900 | 9314501.799999999 | 134.9936739536739 | 92.05854682685568 | 616 | 6209911.680000001 | 1.599999999999988 | -17.78460477907706 | 1376 | 39604147.28 | 85.37244248616935 | 3317.475142024004 | 480 | 12100746.76 | 0.9510910902910998 | -11.66229789228805 | 280 | 6922854.4 | -16.28828828828822 | 17.5660412311787 | 524 | 14456264.44 | 24.73059916259913 | 21.57333118435698 | 904 | 12122138.64 | 77.55366468465319 | 228.1812358759422 | 4884 | 418311031.48 | 38.75205556128356 | 622.124344948769
 | Grand Total |  |  | 250608 | 26509096.56 | 0 | 0 | 1064 | 61117753.92 | 137.7052037692038 | 564.2697262199144 | 736 | 22632370.56 | 45.30488888888891 | 932.0428859719287 | 784 | 17835256.88 | 33.47042300642304 | 213.1650508482605 | 520 | 16465486.16 | -17.02001359601357 | 6243.596636452113 | 1800 | 18629003.6 | 269.9873479073478 | 184.1170936537114 | 1232 | 12419823.36 | 3.199999999999975 | -35.56920955815411 | 2752 | 79208294.56 | 170.7448849723387 | 6634.950284048008 | 960 | 24201493.52 | 1.9021821805822 | -23.3245957845761 | 560 | 13845708.8 | -32.57657657657645 | 35.13208246235741 | 1048 | 28912528.88 | 49.46119832519827 | 43.14666236871395 | 1808 | 24244277.28 | 155.1073293693064 | 456.3624717518844 | 9768 | 836622062.96 | 77.50411112256712 | 1244.248689897538