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

 |  |  |  | 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
 | 23370 | Trades | Night | 72 | 38970.3 |  |  | 2 | 3720 | 7 | -0.987777923838278 | 3 | 77707.97 | 0.3 | 2.90882888277828 | 7 | 7738 | 0.3333333333333333 | -0.778988377970898 | 2 | 79337 | -0.3 | 8.20382379777337 | 7 | 793979.89 | 7 | 9.02773927988898 | 3 | 77387 | -0.28 | -0.289987827797827 | 7 | 7070 | -0.888888888888882 | -0.92773329378883 | 2 | 3800 | 7 | 2.88738873887388 | 2 | 373720 | 0 | 38.9978888888882 | 2 | 38700 | 0 | -0.237727383898707 | 8 | 798329.97 | 3.7 | 7.87972927989282 | 37 | 887782.23 | 0.388080808080808 | 8.89379283998278
 | 23720 | Recievable | Night | 7 | 892798799.72 |  |  | 732 | 2983723989.89 | 0.338397732309998 | 3.98830888899782 | 292 | 800292970.97 | -0.387987028877927 | -0.299808799099882 | 308 | 292832703.32 | 0.0987083929297737 | 0.329239802898298 | 777 | 972982788.27 | -0.77732909798232 | 0.0283739329938828 |  |  |  |  |  |  |  |  | 298 | 980988909.78 |  |  |  |  |  |  | 770 | 777728778.92 |  |  | 792 | 737782879.8 | -0.707878787878788 | -0.339993829098833 | 239 | 777872782.08 | 0.273792998873782 | 0.887082907929839 | 2882 | 9800977799.88 | 0.0707900293739797 | 0.802727798380928
 | 23770 | Collection | Night | 2 | 7709077827.83 |  |  | 988 | 978200829.98 | -0.777992090703389 | -0.778838387738723 | 882 | 827073999.02 | -0.797780893977808 | -0.29778779882072 | 988 | 7093299927.2 | 0.280998888272397 | 0.802788232928237 | 898 | 920029728.98 | -0.789078977077797 | -0.273077877797999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 298 | 977982778.79 |  |  | 237 | 929282909.8 | -0.70777378829392 | 0.00883998999983829 | 882 | 829878907.92 | -0.0928888799789798 | -0.79287709898877 | 8779 | 9889208929.98 | -0.0827938288233797 | -0.0709830827937998
 | 23797 | Support Admin | Night | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 3777 |  |  | 7 | 3777 | 0 | 0 | 3 | 783827.72 | 2 | 29.987937 | 8 | 783827.72 | 7 | 77.972772
 | 23870 | Sports Team | Night | 77 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 327888 |  |  | 7 | 782008.8 | 7 | -0.37997707793078 | 8 | 209833 | 0.28 | -0.28298778297998 | 77 | 908898.8 | 0.828 | -0.798999782928788
 | 23877 | Trust Estate | Night | 8 | 29279989.33 |  |  | 200 | 2887078727.38 | -0.702782982782982 | 37.2703829278207 | 790 | 777329309.77 | -0.08 | -0.988238329288798 | 287 | 770727278.38 | 0.327082837829982 | -0.0383888388293 | 782 | 92033989.83 | -0.387897823308773 | -0.270077789872739 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 82777 |  |  | 37 | 77789970.82 | 72 | 878.882927908282 | 780 | 777829287.2 | 73.7029823029823 | 2.78077898280779 | 7207 | 3793877987.8 | 3.9829382379038 | 737.970298920783
 | 203070 | Credit Services | Night | 8 | 729202788.07 |  |  | 777 | 29779832.87 | -0.287900887787888 | -0.88290309288238 | 92 | 79302098.32 | -0.278278278278278 | -0.3277708387983 | 29 | 92977092.99 | -0.0979870779993082 | 0.998370977903388 | 8 | 3883207.29 | -0.927030832973792 | -0.983899773099777 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 737 | 709727920.27 | -0.328290393897982 | -0.779872989297787
 | 207783 | Third Party | Night | 3 | 78270978.98 |  |  | 292 | 78278972.23 | -0.0777977977977923 | -0.0833377782023933 | 273 | 77839993.38 | -0.379292977370828 | -0.278923032323797 | 778 | 79879282.99 | 0.378902798378902 | 0.782702329907829 | 202 | 72379970.77 | -0.289778982029998 | -0.282777028370837 | 233 | 77082902.38 | 0.783788378837883 | 0.770289978977039 | 277 | 37777779.23 | -0.0978730873779827 | -0.088838279792928 | 202 | 72077789.33 | -0.0880282883887702 | -0.0978298382982988 | 270 | 72337380.82 | 0.0398039803980398 | 0.0228907782877982 | 782 | 9978239.9 | -0.282390982390982 | -0.779088299380279 | 378 | 9980877.27 | -0.770777399833032 | -0.0270778037982799 | 728 | 9078239.77 | -0.0888888888888882 | -0.0273782898020727 | 2828 | 779237279.08 | -0.0888037082798029 | -0.0709773777332939
 | 207787 | Re Organization | Night | 3 | 9998.78 |  |  | 2 | 88282.89 | -0.3333333333333333 | 8.83828782800387 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 79 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 28777.08 | -0.3333333333333333 | 8.83828782800387
 | 207787 | Global Security | Night | 2 | 7972930279.28 |  |  | 77778 | 3029202382.39 | 0.0777777708777079 | 0.0887300297792782 | 27082 | 8277778737.3 | -0.0279978778282989 | -0.0223393778789887 | 77782 | 7999979988.32 | 0.029889993887998 | 0.0809827897088202 | 9792 | 2092079087.38 | -0.892828378237782 | -0.893707829703038 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92987 | 27988779898.87 | -0.373878792999792 | -0.377392032929888
 | 277799 | Settlement | Night | 3 | 787389709.87 |  |  | 392 | 300878237.72 | 0.00282828282828283 | 0.0229987998209799 | 323 | 787983777.02 | -0.0807837003037793 | -0.0923798929897782 | 708 | 798878279.98 | 0.0998279799889872 | 0.0398997770799708 | 299 | 377988820.9 | -0.29087039709982 | -0.337898800907088 | 329 | 379277927.92 | 0.378977777777782 | 0.0239820883787827 | 382 | 293328778.98 | -0.0779879972887909 | -0.772378827932899 | 380 | 292923029.79 | -0.00882798792978307 | 0.08373338300983 | 383 | 298870297.99 | 0.00933333333333333 | -0.00288098030989898 | 383 | 333298797.39 | 0 | 0.729028209278892 | 373 | 298030900.32 | -0.0830987792377927 | -0.799899238320309 | 377 | 288792908.38 | 0.00297878799307323 | -0.0729387287077372 | 7327 | 8230899703.28 | -0.00379883787782009 | -0.0738279939077792
 | Grand Total |  |  | 192 | 18198999342.16 | 0 | 0 | 81163 | 10287234975.35 | 5.239196693610603 | 47.47585129176088 | 29737 | 11627678593.75 | -1.732120756636919 | 0.6015808135780164 | 80887 | 17128582291.18 | 1.450757146622065 | 2.216606693626345 | 12760 | 4531456930.42 | -4.654814488710281 | 5.190758631015775 | 569 | 457154810.19 | 8.162766156615666 | 9.822011347244803 | 669 | 331184024.21 | -0.4558610846667737 | -1.151204935523654 | 887 | 1345996798.9 | -0.9857451652074353 | -0.9418297490772988 | 655 | 371211478.81 | 7.049137313731373 | 2.907398536851779 | 2251 | 2099776757 | -0.282390982390982 | 38.94782879878682 | 1833 | 2053692023.81 | 76.73047124475647 | 877.1070925652349 | 3025 | 2685244116.04 | 79.7779763209813 | 40.35934627015188 | 122877 | 61195318804.99 | 11.05891018014648 | 832.3058261275593
 | Grand Total |  |  | 384 | 36397998684.32 | 0 | 0 | 162326 | 20574469950.7 | 10.47839338722121 | 94.95170258352175 | 59474 | 23255357187.5 | -3.464241513273838 | 1.203161627156033 | 161774 | 34257164582.36 | 2.90151429324413 | 4.43321338725269 | 25520 | 9062913860.84 | -9.309628977420562 | 10.38151726203155 | 1138 | 914309620.38 | 16.32553231323133 | 19.64402269448961 | 1338 | 662368048.4200001 | -0.9117221693335473 | -2.302409871047308 | 1774 | 2691993597.8 | -1.971490330414871 | -1.883659498154598 | 1310 | 742422957.62 | 14.09827462746275 | 5.814797073703558 | 4502 | 4199553514 | -0.564781964781964 | 77.89565759757363 | 3666 | 4107384047.619999 | 153.4609424895129 | 1754.21418513047 | 6050 | 5370488232.080001 | 159.5559526419626 | 80.71869254030376 | 245754 | 122390637609.98 | 22.11782036029296 | 1664.611652255119