Spreadsheet: 78765d1279086027-split-excel-into-multiple-tabs-macro-sheet-lobs
Sheet: Night

Output Example
 |  |  |  | 2008-07-30 00:00:00 |  |  |  | 2008-08-29 00:00:00 |  |  |  | 2008-08-30 00:00:00 |  |  |  | 2/37/2008 |  |  |  | 9/37/2008 |  |  |  | 2008-09-30 00:00:00 |  |  |  | 70/30/2008 |  |  |  | 77/30/2008 |  |  |  | 72/37/2008 |  |  |  | 2002-07-29 00:00:00 |  |  |  | 2002-02-28 00:00:00 |  |  |  | 3/37/2070
 | 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
 | 23770 | Collection | Night | 2 | 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
 | 23720 | Recievable | Night | 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
 | 23370 | Trades | Night | 72 | 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
 | 277799 | Settlement | Night | 3 | 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
 | 207787 | Re Organization | Night | 3 | 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
 | 207783 | Third Party | Night | 3 | 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
 | 207787 | Global Security | Night | 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
 | 203070 | Credit Services | Night | 8 | 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
 | 23797 | Support Admin | Night | 7 | 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
 | 23870 | Sports Team | Night | 77 | 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
 | 23877 | Trust Estate | Night | 8 | 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
 | Grand Total | 0 | 0 | 192 | 1681224.53 |  |  | 64 | 1953029.98 | 0.7852477934296126 | 5.478852158925741 | 79 | 2395970.76 | 0.5212121212121207 | 14.69820063263832 | 60 | 1409914.66 | 1.354949494949496 | 16.43473204904677 | 47 | 1931727.82 | 0.7205333333333337 | 10.41305737836455 | 55 | 1623462.42 | 0.8732350550350562 | 19.18817522585717 | 94 | 1231851.32 | 2.022222222222216 | 3.408378535788167 | 188 | 3503294.24 | 0.5502401313401315 | 16.62696770300681 | 73 | 1992135.72 | 0.3944897444897452 | 0.7065684661806244 | 112 | 2492545.12 | 1.434494476312657 | 0.3188625173915046 | 120 | 3366380.85 | 1.342540904359087 | 4.580157344817152 | 125 | 1808326.14 | 1.441788351970171 | 4.7297579752273 | 777 | 37186790.05 | 0.5280764247620143 | 11.75570779541566