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

 |  |  |  | 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
 | 900372 | Collection | Morning | 3 | 87820.78 |  |  | 77 | 289798.27 | 0.827829827829827 | 3.0028897799898 | 3 | 207028.37 | -0.777777777777782 | -0.777779827099937 | 78 | 233827.28 | 7 | 0.787977907087787 | 8 | 98308.3 | -0.888888888888882 | -0.837008977990792 | 77 | 787299.37 | 7.2 | 0.998298087787827 | 72 | 782828.2 | 0.09090909090909091 | -0.0973930330882977 | 9 | 98320 | -0.3333333333333333 | -0.832387777082989 | 3 | 82090.02 | -0.828 | -0.787879997233027 | 7 | 79838 | 0.3333333333333333 | -0.888009837923397 | 7 | 97978.98 | 0 | 3.32828270097037 | 2 | 39373.92 | 0.28 | -0.839838999878279 | 90 | 7827097.33 | 0.772897880283829 | 0.773777777083978
 | 909302 | Trades | Morning | 2 | 709270 |  |  | 78 | 732392.23 | 0.8 | 2.92239370032798 | 2 | 27782.83 | -0.8828 | -0.977729997398387 | 37 | 99992.82 | 0.982782982782982 | 2.98392880083992 | 8 | 29823.82 | -0.839787839787839 | -0.989899892777793 | 77 | 82098.98 | 0.933333333333333 | 0.933783732070992 | 77 | 793923.77 | 0.777777777777773 | 9.29977709292877 | 72 | 727777.3 | -0.772982782982773 | -0.879888878377779 | 9 | 97887.82 | -0.28 | -0.820770903970238 | 8 | 78323.88 | -0.3333333333333333 | -0.977793890370208 | 37 | 779033.97 | 7.78888888888882 | 9.98772039093882 | 2 | 30882.39 | -0.787839787839782 | -0.88007797799828 | 727 | 7983978.98 | 0.377078332782988 | 7.28397389992982
 | 909303 | Settlement | Morning | 70 | 382770.09 |  |  | 78 | 728270.79 | 3.7 | -0.799823309309709 | 23 | 272078.27 | 0.833333333333333 | 3.08989789979992 | 29 | 877707.87 | 0.280998888272397 | -0.0988988279879972 | 9 | 27820.93 | -0.989888777737293 | -0.987798777782792 | 72 | 279887.29 | 0.999999999999999 | 2.98399707029832 | 20 | 298298.98 | 0.728820899238297 | 0.309898277988882 | 28 | 837888.92 | 0.28 | 7.77039782020877 | 23 | 303200.07 | -0.09 | -0.822798770999929 | 23 | 879982.79 | 0 | 7.07777828773082 | 77 | 7097792.02 | -0.0738292809988882 | 0.283829783207872 | 72 | 878280.97 | -0.777777777777782 | -0.879833828297877 | 779 | 8899779.92 | 0.233889888979993 | 7.08298798279987
 | 973700 | Re Organization | Morning | 8 | 793877 |  |  | 30 | 928233.7 | -0.037789087878729 | 0.209380333397797 | 30 | 837298.29 | 0 | -0.287782097997329 | 32 | 827979.97 | 0.0888888888888882 | 0.0777033387878773 | 27 | 7778327.28 | -0.28 | 0.977823202309277 | 29 | 292979.97 | 0.209333333333333 | -0.239990878203097 | 32 | 972788.99 | 0.703779778982098 | 2.08779200273829 | 88 | 7237827.88 | 0.27928 | 0.907877798939978 | 88 | 7933733.92 | 0.0797979797979792 | 0.0877270399398797 | 82 | 298707.3 | -0.0278298278298277 | -0.820898309993977 | 77 | 987787.88 | -0.277839787839782 | -0.720238809780387 | 89 | 3700982.77 | 0.777837778377783 | 0.9937799879798 | 820 | 77282898.72 | 0.097709703900799 | 0.373778282793727
 | 2030088 | Credit Services | Morning | 70 | 293078.27 |  |  | 77 | 287272.27 | -0.283782998239882 | -0.70983373788989 | 28 | 709878.92 | 0.298278298278298 | 0.889283829828288 | 28 | 797998.09 | 0 | 0.79382823372727 | 78 | 379729.79 | -0.7 | -0.373297982307997 | 37 | 787832.29 | -0.373333333333333 | -0.877323087878298 | 72 | 288288.7 | 0.302982302982309 | 0.778272989829999 | 79 | 723987.2 | 0.772882089923829 | -0.379977778927709 | 79 | 723778.79 | -0.0828378299823987 | -0.299239938387793 | 77 | 782902.7 | -0.399999999999999 | 0.792307777887783 | 77 | 792977.32 | 0.777777777777773 | 7.78230079978272 | 77 | 202987.87 | 0 | -0.889709770820937 | 207 | 3327082.87 | 0.0223828827987872 | 0.780297937823277
 | 2770030 | Sports Team | Morning | 3 | 203302.97 |  |  | 2 | 82737.77 | -0.728 | -0.277792373797777 | 72 | 782038.23 | 0.278298278298277 | 7.90979898093323 | 77 | 708230.98 | 0.788888888888882 | -0.383908898970798 | 72 | 298898.92 | -0.772982782982773 | 7.29778882338977 | 77 | 898829.37 | -0.0933333333333333 | 7.07709308988078 | 77 | 373370.7 | 0.777777777777773 | -0.827739077777889 | 79 | 290823.23 | 0.298278298278298 | -0.787079398337277 | 77 | 328983.08 | -0.777777777777782 | 0.293803773277773 | 70 | 377707.07 | -0.298278298278298 | -0.789999987707282 | 72 | 808337.98 | 0.2 | 0.972720272077797 | 78 | 282988.2 | 0.28 | -0.897039998088777 | 782 | 3803782.9 | 0.0938808377998989 | 0.320892997378278
 | 2777770 | Support Admin | Morning | 2 | 72970 |  |  |  |  |  |  | 2 | 7900 |  |  | 2 | 8820.8 | 0 | 2.72288888888888 |  |  |  |  | 7 | 7777 |  |  | 8 | 232878.7 | 7 | 89.3988 |  |  |  |  | 8 | 9979.79 |  |  | 2 | 720828.29 | -0.8 | 78.3208200889799 | 2 | 8772.89 | 0 | -0.98923930723238 | 8 | 77978.78 | 3.7 | 3.27209230288877 | 28 | 820887.87 | 0.99 | 78.9789877828299
 | 7002080 | Institutional Processing | Morning | 79 | 79779.87 |  |  | 7 | 27300 | -0.9 | -0.793998797998997 | 3 | 82300 | 2 | 7.77298278298277 | 2 | 33982 | -0.3333333333333333 | -0.388298239098239 | 7 | 70370 | 7 | 0.798770377793799 | 7 | 779300 | 0 | 7.98778978987789 | 7 | 777700 | -0.28 | -0.882383239872038 | 2 | 7700 | 7 | -0.923 | 7 | 27923.98 | -0.3 | 28.8398 | 2 | 23087.9 | 7 | -0.829378773803923 | 8 | 20999.79 | 3.7 | -0.0939982998928329 | 8 | 737708.78 | 0 | 7.77200820303877 | 70 | 289870.02 | 0.388787878787878 | 2.99202982379778
 | 7002082 | Third Party | Morning | 9 | 2373.98 |  |  |  |  |  |  |  |  |  |  | 7 | 7777 |  |  | 2 | 8300 | 7 | 0.328 |  |  |  |  | 7 | 8282 |  |  | 2 | 27777 | 7 | 2.92989383779097 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 37770 |  |  | 9 | 97200.98 | 7 | 7.8277972883987
 | 7777309 | Income at source | Morning | 37 | 77728 |  |  | 8 | 93708.27 | 0.888888888888882 | 8.23892370708877 | 2 | 2732.37 | -0.8 | -0.909897737377828 | 2 | 2700 | 0 | -0.00732372378829392 | 2 | 27770 | 0 | 7.2077077077077 | 2 | 73980 | 0 | 7.7978 | 2 | 787797 | 2.3 | 2.9882920828297 | 3 | 90782.97 | -0.827829827829827 | -0.799299307703789 | 2 | 77877.37 | -0.3333333333333333 | -0.920382987323098 | 8 | 728370 | 2 | 2.83230299970972 | 8 | 20028 | 0 | -0.939938882070087 | 70 | 93232.78 | 0.888888888888882 | 3.7780897789708 | 30 | 889737.03 | 0.393308793308793 | 7.83909903027098
 | 7990808 | Global Security | Morning | 2 | 27883.88 |  |  | 2 | 82777 | 0 | 7.72083828977923 | 8 | 23028.83 | 3.7 | 0.883239809870839 | 7 | 70777.99 | -0.2 | -0.780798908329828 | 7 | 777879.73 | 0 | 2.82920200997772 | 8 | 77078 | 0.28 | -0.27072393777702 | 9 | 702392 | 0.9 | 7.87832388232877 | 8 | 3982 | -0.777777777777777 | -0.988879827838232 | 2 | 98983.78 | 0.7 | 28.7977980239383 | 8 | 32087.29 | -0.298278298278298 | -0.878782398727908 | 2 | 8870 | -0.8 | -0.987297829378872 | 2 | 32829.8 | 2.3 | 7.99839079983202 | 82 | 877823.98 | 0.388379208379208 | 2.97023972008938
 | Grand Total |  |  | 285 | 2730854.84 | 0 | 0 | 359 | 3252490.3 | 4.267146630600098 | 19.5129775915872 | 173 | 2952066.11 | 4.649332132132126 | 17.59201364354157 | 301 | 3669794.8 | 8.608226315499817 | 5.707098571156578 | 220 | 9497228.770000001 | 9.528451710603214 | 16.25128649031889 | 393 | 4067062.27 | 9.155999999999997 | 26.39072386605739 | 383 | 6018549.040000001 | 13.30204762766734 | 110.9336409779062 | 370 | 10046866.5 | 12.91851666627842 | 6.017656488671943 | 298 | 9684438.62 | -1.912150961295535 | 54.36805623924187 | 287 | 4001835.22 | 7.175613575613577 | 83.83834595578153 | 367 | 10622578.83 | 11.31499759782792 | 18.62414081862302 | 415 | 6115016.260000001 | 6.661109101649101 | 19.42786049762601 | 3624 | 112100140.6 | 10.75831540702217 | 117.2238625231957
 | Grand Total |  |  | 570 | 5461709.680000001 | 0 | 0 | 718 | 6504980.600000001 | 8.534293261200196 | 39.0259551831744 | 346 | 5904132.220000001 | 9.298664264264252 | 35.18402728708313 | 602 | 7339589.6 | 17.21645263099963 | 11.41419714231316 | 440 | 18994457.54 | 19.05690342120643 | 32.50257298063779 | 786 | 8134124.54 | 18.31199999999999 | 52.78144773211478 | 766 | 12037098.08 | 26.60409525533468 | 221.8672819558124 | 740 | 20093733 | 25.83703333255683 | 12.03531297734389 | 596 | 19368877.24 | -3.82430192259107 | 108.7361124784837 | 574 | 8003670.439999999 | 14.35122715122715 | 167.6766919115631 | 734 | 21245157.66 | 22.62999519565584 | 37.24828163724604 | 830 | 12230032.52 | 13.3222182032982 | 38.85572099525202 | 7248 | 224200281.2 | 21.51663081404435 | 234.4477250463914
 | Grand Total |  |  | 1140 | 10923419.36 | 0 | 0 | 1436 | 13009961.2 | 17.06858652240039 | 78.0519103663488 | 692 | 11808264.44 | 18.5973285285285 | 70.36805457416627 | 1204 | 14679179.2 | 34.43290526199927 | 22.82839428462631 | 880 | 37988915.08000001 | 38.11380684241286 | 65.00514596127557 | 1572 | 16268249.08 | 36.62399999999999 | 105.5628954642296 | 1532 | 24074196.16 | 53.20819051066936 | 443.7345639116247 | 1480 | 40187466 | 51.67406666511366 | 24.07062595468777 | 1192 | 38737754.48 | -7.64860384518214 | 217.4722249569675 | 1148 | 16007340.88 | 28.70245430245431 | 335.3533838231261 | 1468 | 42490315.32 | 45.25999039131169 | 74.49656327449209 | 1660 | 24460065.04 | 26.64443640659641 | 77.71144199050404 | 14496 | 448400562.4000001 | 43.0332616280887 | 468.8954500927828