Spreadsheet: 90245d1290002838-excel-2007-trying-to-extract-data-from-an-excel-data-only-file-desired-result
Sheet: Sheet1

NDC Team | Page -1 of 1
DC01 | NDC Team | DC Service
#WOs | #Seg | Invoiced Hours | Dock/Gain | Actual Hours | Labor $$ | Parts $$ | Misc $$ | Total $$
250 | 466 | 852.9 | 18.6 | 1098.4 | 65219.0832 | 60737.4214 | 53.54 | 126010.0446
NDC Team | $$ Per Hour | 59.37644136926438 | P to Lbr % | 93.12829684180534 | PP/Lbr Hr | 55.29626857246905
External | 1
#WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to Lbr % | PP/Lbr Hr | Total $$
127 | 231 | 458.6 | 16.3 | 446.8 | 40.67734887108522 | 41783.3434 | 93.51688316920323 | 53.54 | 49811.91189999999 | 119.2147584340989 | 111.4859263652641 | 91648.7953
The # of rows between the external and interanal data varies with each team and can change from month to month.
Internal | 2
#WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to Lbr % | PP/Lbr Hr | Total $$
118 | 194 | 386.9 | 7.4 | 386.9 | 35.22396212672979 | 22827.0998 | 58.99999948307056 | 0 | 7148.2095 | 31.31457593224348 | 18.47559963814939 | 29975.3093
[NAME] | Total Invoice Days: | 18 | Avg Labor $ P/Day: | 1066.261111111111 | [NAME] $ P/Day: | 258.4183166666667 | Avg Labor Hours P/Day: | 18.07222222222222
#WOs | #Seg | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$
103 | 168 | 325.3 | 7.4 | 325.3 | 29.61580480699199 | 19192.7 | 59 | 0 | 4651.5297 | 24.23593189077097 | 14.29919981555487 | 23844.2297
 |  | 1 |  |  | 3 | 0.2731245447924254 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Meeting | 1 | 7 |  |  | 21.5 | 1.957392571012381 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Account | [NAME] | #WOs | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$
 |  | 1 |  |  | 21.5 | 1.957392571012381 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Paid Sick/Personal | 1 | 1 |  |  | 8 | 0.7283321194464676 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Account | [NAME] | #WOs | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$
 |  | 1 |  |  | 8 | 0.7283321194464676 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Team Leader Time | 1 | 3 |  |  | 6.5 | 0.5917698470502549 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Account | [NAME] | #WOs | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$
 |  | 1 |  |  | 6.5 | 0.5917698470502549 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Training Classes | 1 | 7 |  |  | 70 | 6.372906045156592 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Account | [NAME] | #WOs | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$
 |  | 1 |  |  | 70 | 6.372906045156592 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Training OJT | 1 | 17 |  |  | 127.2 | 11.58048069919884 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Account | [NAME] | #WOs | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$
 |  | 1 |  |  | 127.2 | 11.58048069919884 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Vacation | 1 | 2 |  |  | 16 | 1.456664238892935 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Account | [NAME] | #WOs | Inv Hours | Dock/Gain | Actual Hours | % Total | Labor $$ | $$ Per Hour | Misc $$ | Parts $$ | P to lbr % | P P/Lbr Hr | Total $$
 |  | 1 |  |  | 16 | 1.456664238892935 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Summary Overview of Revenue and Hours by Category
 |  | [NAME] | Externally Billed | Internal Departmental | Rental Maintenance | Unbilled Time | Warranty | Total
0 - Travel | Revenue | 3534.1 | 4103.79 | 625.4 | 472 | 0 | 177 | 8912.29
 | Hrs Spent | 59.9 | 40.3 | 10.6 | 8 | 0 | 3 | 121.8
1 - Breakdown | Revenue | 7039.2 | 28195.1404 | 734.3297 | 188.8 | 0 | 2104.47 | 38261.9401
 | Hrs Spent | 79.7 | 184.7 | 9 | 3.2 | 0 | 5 | 281.6
2 - Scheduled Maintenance | Revenue | 3693.97 | 5112.5 | 0 | 0 | 0 | 0 | 8806.47
 | Hrs Spent | 62.1 | 42.6 | 0 | 0 | 0 | 0 | 104.7
3 - Repair  Field | Revenue | 9576.9597 | 54237.3649 | 3364.2899 | 746.26 | 0 | 2104.47 | 70029.3445
 | Hrs Spent | 123.6 | 179.2 | 27 | 3.8 | 0 | 4.5 | 338.1
Courtesy Call | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hrs Spent | 0 | 0 | 0 | 0 | 3 | 0 | 3
Meeting | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hrs Spent | 0 | 0 | 0 | 0 | 21.5 | 0 | 21.5
Paid Sick/Personal | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hrs Spent | 0 | 0 | 0 | 0 | 8 | 0 | 8
Team Leader Time | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hrs Spent | 0 | 0 | 0 | 0 | 6.5 | 0 | 6.5
Training Classes | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hrs Spent | 0 | 0 | 0 | 0 | 70 | 0 | 70
Training OJT | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hrs Spent | 0 | 0 | 0 | 0 | 127.2 | 0 | 127.2
Vacation | Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Hrs Spent | 0 | 0 | 0 | 0 | 16 | 0 | 16
Total | Revenue | 23844.2297 | 91648.79530000001 | 4724.019600000001 | 1407.06 | 0 | 4385.94 | 126010.0446
 | Hrs Spent | 325.3 | 446.8 | 46.6 | 15 | 252.2 | 12.5 | 1098.4