Spreadsheet: 104221d1301880662-replace-a-concatenate-from-pivot-table-with-fx-to-raw-data-concatenate-from-pivot-sample
Sheet: OT

 |  |  |  |  |  |  |  |  | Total |  | Total | 1864.75
Resource Type | C | Div | OT/DT | PCC | PCC Descrip | Program | Program Descrip | Cat | Cat Descrip | Activity Type | Activity Type Description | OT | [NAME]/Exp Lookup | [NAME]/Exp w/o [NAME]
DG | C | 1 | 55 | 500 | Ford | 1 | IT | 1 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 37.25 | 321321 | 321321
DT | C | 1 | 17 | 400 | Van | 3 | CBTV | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 167.5 | 321321 | 321321
GC | C | 1 | 120 | 300 | SUV | 5 | TBGF | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 1.5 | 321321 | 321321
DT | C | 1 | 28 | 100 | Truck | 9 | ERT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 16 | 321321 | 321321
GC | C | 1 | 40 | 500 | Ford | 11 | JIR | 2 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 9 | 321321 | 321321
DG | C | 1 | 19 | 400 | Van | 13 | IT | 3 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 63.75 | 321321 | 321321
DT | C | 1 | 57 | 300 | SUV | 15 | CBTV | 4 | IT | MO-OT | Maintain & Operate Overtime Services | 224.5 | 321321 | 321321
GC | C | 1 | 60 | 200 | Sport | 17 | TBGF | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 1 | 321321 | 321321
DG | C | 1 | 22 | 100 | Truck | 19 | DSA | 2 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 4 | 321321 | 321321
DT | C | 1 | 125 | 500 | Ford | 21 | ERT | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 10 | 321321 | 321321
GC | C | 1 | 21 | 400 | Van | 23 | JIR | 4 | IT | MO-OT | Maintain & Operate Overtime Services | 4.25 | 321321 | 321321
DG | C | 1 | 33 | 300 | SUV | 25 | IT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 202 | 321321 | 321321
DT | E | 1 | 45 | 200 | Sport | 27 | CBTV | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 2 | 321321 | 321321
GC | E | 1 | 24 | 100 | Truck | 29 | TBGF | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 21 | 321321 | 321321
DT | E | 1 | 65 | 400 | Van | 33 | ERT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 82.75 | 321321 | 321321
GC | E | 1 | 27 | 300 | SUV | 35 | JIR | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 88.5 | 321321 | 321321
DG | E | 2 | 130 | 200 | Sport | 37 | IT | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 17.5 | 321321 | 321321
DT | E | 2 | 26 | 100 | Truck | 39 | CBTV | 4 | IT | MO-OT | Maintain & Operate Overtime Services | 12.5 | 321321 | 321321
GC | E | 2 | 38 | 500 | Ford | 41 | TBGF | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 4.5 | 321321 | 321321
DG | E | 2 | 50 | 400 | Van | 43 | DSA | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 134 | 321321 | 321321
DT | E | 2 | 29 | 300 | SUV | 45 | ERT | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 22.25 | 321321 | 321321
GC | E | 2 | 67 | 200 | Sport | 47 | JIR | 4 | IT | MO-OT | Maintain & Operate Overtime Services | 9.5 | 321321 | 321321
DG | E | 2 | 70 | 100 | Truck | 49 | IT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 15 | 321321 | 321321
DT | E | 2 | 32 | 500 | Ford | 51 | CBTV | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 3 | 321321 | 321321
GC | E | 2 | 135 | 400 | Van | 53 | TBGF | 3 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 1.5 | 321321 | 321321
DT | C | 2 | 43 | 200 | Sport | 57 | ERT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 4.5 | 321321 | 321321
GC | C | 2 | 55 | 100 | Truck | 59 | JIR | 2 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 15.75 | 321321 | 321321
DG | C | 2 | 34 | 500 | Ford | 61 | IT | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 136.75 | 321321 | 321321
DT | C | 2 | 72 | 400 | Van | 63 | CBTV | 4 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 3 | 321321 | 321321
GC | C | 2 | 75 | 300 | SUV | 65 | TBGF | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 2.5 | 321321 | 321321
DG | C | 2 | 37 | 200 | Sport | 67 | DSA | 2 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 5.5 | 321321 | 321321
DT | C | 2 | 140 | 100 | Truck | 69 | ERT | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 30.5 | 321321 | 321321
GC | C | 2 | 36 | 500 | Ford | 71 | JIR | 4 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | -0.5 | 321321 | 321321
DG | C | 2 | 48 | 400 | Van | 73 | IT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | -8 | 321321 | 321321
DT | C | 2 | 60 | 300 | SUV | 75 | CBTV | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 91.25 | 321321 | 321321
GC | C | 3 | 39 | 200 | Sport | 77 | TBGF | 3 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 19.5 | 321321 | 321321
DT | C | 3 | 80 | 500 | Ford | 81 | ERT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 11 | 321321 | 321321
GC | E | 3 | 42 | 400 | Van | 83 | JIR | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 0.5 | 321321 | 321321
DG | E | 3 | 145 | 300 | SUV | 85 | IT | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 0.5 | 321321 | 321321
DT | E | 3 | 41 | 200 | Sport | 87 | CBTV | 4 | IT | MO-OT | Maintain & Operate Overtime Services | 6 | 321321 | 321321
GC | E | 3 | 53 | 100 | Truck | 89 | TBGF | 1 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 52.75 | 321321 | 321321
DG | E | 3 | 65 | 500 | Ford | 91 | DSA | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 226.25 | 321321 | 321321
DT | E | 3 | 44 | 400 | Van | 93 | ERT | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 24.5 | 321321 | 321321
GC | E | 3 | 82 | 300 | SUV | 95 | JIR | 4 | IT | MO-OT | Maintain & Operate Overtime Services | 22.5 | 321321 | 321321
DG | E | 3 | 85 | 200 | Sport | 97 | IT | 1 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 0.5 | 321321 | 321321
DT | E | 3 | 47 | 100 | Truck | 99 | CBTV | 2 | IT | MO-OT | Maintain & Operate Overtime Services | 0.5 | 321321 | 321321
GC | E | 3 | 150 | 500 | Ford | 101 | TBGF | 3 | IT | MO-OT | Maintain & Operate Overtime Services | 11 | 321321 | 321321
DT | E | 3 | 58 | 300 | SUV | 105 | ERT | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 2.5 | 321321 | 321321
GC | E | 3 | 70 | 200 | Sport | 107 | JIR | 2 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 15.75 | 321321 | 321321
DG | E | 3 | 49 | 100 | Truck | 109 | IT | 3 | IT | MO-DT | Maintenance & Operations Doubletime Svcs | 18.5 | 321321 | 321321
DT | E | 3 | 87 | 500 | Ford | 111 | CBTV | 4 | IT | MO-OT | Maintain & Operate Overtime Services | 6.5 | 321321 | 321321
GC | CC | 3 | 90 | 400 | Van | 113 | TBGF | 1 | IT | MO-OT | Maintain & Operate Overtime Services | 10 | 321321 | 321321