Spreadsheet: 52748d1252587279-filtering-for-multiple-pay-types-demo-book
Sheet: Sheet1

OPERNO | OPER_TYPE | INV_DATE | MILEAGE_OUT | LAST_SERV_DATE | RO_CNT | RONO | SERV_ADV | TECH | HOURS1 | OPER_COST | [NAME] | OPER_AMT | OPER_PART_COST | OPER_PART_AMT | OPER_AMT_2 | SLSNO | LINE | C&W
SI | C | 08/01/2009 | 75896 | 08/01/2009 | 1 | 42144 | DEW | A07 | 0.3 | 7.5 | 16 | 16 | 0 | 0 | 16 | WFJ | A
27 | C | 08/01/2009 | 75896 | 08/01/2009 | 1 | 42144 | DEW | A07 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | WFJ | B
SS | C | 08/01/2009 | 51998 | 08/01/2009 | 9 | 42145 | DEW | A10 | 0.6 | 13.8 | 449.48 | 21.95 | 14.11 | 18 | 21.95 | DWW | A
27 | C | 08/01/2009 | 51998 | 08/01/2009 | 9 | 42145 | DEW | A10 | 0 | 0 | 449.48 | 0 | 0 | 0 | 0 | DWW | B
ADD50 | C | 08/01/2009 | 51998 | 08/01/2009 | 9 | 42145 | DEW | A10 | 2.8 | 64.4 | 449.48 | 216.44 | 100.37 | 173.51 | 216.44 | DWW | C
C0182 | W | 08/01/2009 | 67759 | 08/01/2009 | 14 | 42146 | DEW | A07 | 0.8 | 20 | 147.57 | 66.4 | 57.98 | 81.17 | 66.4 | LMP | A
SS8 | C | 08/01/2009 | 177835 | 08/01/2009 | 1 | 42147 | DEW | A10 | 0.6 | 13.8 | 48.25 | 21.95 | 18.35 | 24 | 21.95 | AUG | A
27 | C | 08/01/2009 | 177835 | 08/01/2009 | 1 | 42147 | DEW | A10 | 0 | 0 | 48.25 | 0 | 0 | 0 | 0 | AUG | B
RMS | C | 08/01/2009 | 177835 | 08/01/2009 | 1 | 42147 | DEW | A10 | 0 | 0 | 48.25 | 0 | 0 | 0 | 0 | AUG | C
SI | C | 08/01/2009 | 19983 | 08/01/2009 | 6 | 42148 | DEW | A07 | 0.3 | 7.5 | 16 | 16 | 0 | 0 | 16 | DWW | A
SS8 | C | 08/01/2009 | 90162 | 08/01/2009 | 8 | 42149 | DEW | A07 | 0.6 | 15 | 335.61 | 21.95 | 18.35 | 24 | 21.95 | APR | A | 1
27 | C | 08/01/2009 | 90162 | 08/01/2009 | 8 | 42149 | DEW | A07 | 0 | 0 | 335.61 | 0 | 0 | 0 | 0 | APR | B | 1
SI | C | 08/01/2009 | 90162 | 08/01/2009 | 8 | 42149 | DEW | A07 | 0.3 | 7.5 | 335.61 | 16 | 0 | 0 | 16 | APR | C | 1
Wipers | C | 08/01/2009 | 90162 | 08/01/2009 | 8 | 42149 | DEW | A07 | 0.1 | 2.5 | 335.61 | 5.45 | 9.14 | 14.5 | 5.45 | APR | D | 1
N0734 | W | 08/01/2009 | 90162 | 08/01/2009 | 8 | 42149 | DEW | A07 | 0.2 | 5 | 335.61 | 16.6 | 0.42 | 0.59 | 16.6 | APR | E | 1
N0735 | W | 08/01/2009 | 90162 | 08/01/2009 | 8 | 42149 | DEW | A07 | 0.2 | 5 | 335.61 | 16.6 | 0.42 | 0.59 | 16.6 | APR | F | 1
E5840 | W | 08/01/2009 | 90162 | 08/01/2009 | 8 | 42149 | DEW | A07 | 0.8 | 20 | 335.61 | 66.4 | 106.5 | 149.1 | 66.4 | APR | G | 1
SSS | C | 08/01/2009 | 44164 | 08/01/2009 | 1 | 42152 | DEW | A10 | 0.6 | 13.8 | 73.45 | 26.45 | 36.98 | 43.5 | 26.45 | AUG | A
27 | C | 08/01/2009 | 44164 | 08/01/2009 | 1 | 42152 | DEW | A10 | 0 | 0 | 73.45 | 0 | 0 | 0 | 0 | AUG | B
V1993 | W | 08/01/2009 | 65211 | 08/01/2009 | 4 | 42153 | DEW | A07 | 0.2 | 5 | 50.09 | 16.6 | 12.49 | 17.49 | 16.6 |  | A | 1
SI | C | 08/01/2009 | 65211 | 08/01/2009 | 4 | 42153 | DEW | A07 | 0.3 | 7.5 | 50.09 | 16 | 0 | 0 | 16 |  | B | 1
27 | C | 08/01/2009 | 65211 | 08/01/2009 | 4 | 42153 | DEW | A07 | 0 | 0 | 50.09 | 0 | 0 | 0 | 0 |  | C | 1
 | C | 08/01/2009 | 82097 | 08/01/2009 | 1 | 42154 | DEW | A10 | 0.3 | 6.9 | 103.64 | 29.95 | 40 | 70.18 | 29.95 | AUG | A
 | C | 08/03/2009 | 91254 | 08/03/2009 | 45 | 42155 | DEW | A10 | 4 | 92 | 1009.44 | 420 | 300.72 | 551.85 | 420 | C. | A
AD | C | 08/03/2009 | 91254 | 08/03/2009 | 45 | 42155 | DEW | A10 | 0 | 0 | 1009.44 | 0 | 0 | 0 | 0 | C. | B
SS8 | C | 08/03/2009 | 24750 | 08/03/2009 | 3 | 42156 | KF | A04 | 0.6 | 15 | 258.2 | 21.95 | 18.35 | 24 | 21.95 | DWW | A
ADD25 | C | 08/03/2009 | 24750 | 08/03/2009 | 3 | 42156 | KF | A04 | 1.3 | 32.5 | 258.2 | 98.56 | 78.1 | 101.39 | 98.56 | DWW | B
02 | I | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 0.3 | 7.5 | 363.83 | 16 | 18.35 | 23.95 | 16 | WFJ | A
SI | I | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 0.3 | 7.5 | 363.83 | 16 | 0 | 0 | 16 | WFJ | B
Cert | I | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 1 | 25 | 363.83 | 85 | 0 | 0 | 85 | WFJ | C
[NAME] | W | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 0.5 | 12.5 | 363.83 | 41.5 | 0 | 0 | 41.5 | WFJ | D
Afcs | I | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 0.1 | 2.5 | 363.83 | 7.5 | 12.02 | 12.45 | 7.5 | WFJ | E
CAB | I | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 0.2 | 5 | 363.83 | 17 | 37.29 | 42.95 | 17 | WFJ | F
AD | I | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 0 | 0 | 363.83 | 0 | 56.85 | 71.06 | 0 | WFJ | G
AD | I | 08/03/2009 | 49313 | 08/03/2009 | 0 | 42157 | DAB | A20 | 0.2 | 5 | 363.83 | 17 | 8.42 | 13.42 | 17 | WFJ | H
Rech | C | 08/03/2009 | 238457 | 08/03/2009 | 11 | 42159 | KF | A10 | 1.3 | 29.9 | 252.74 | 110.5 | 55.86 | 130.2 | 110.5 | MAR | A
Rech | C | 08/03/2009 | 238457 | 08/03/2009 | 11 | 42159 | KF | A10 | 0 | 0 | 252.74 | 0 | 0 | 0 | 0 | MAR | B
[NAME] | I | 08/03/2009 | 14506 | 08/03/2009 | 1 | 42160 | DAB | A04 | 0.3 | 7.5 | 201.78 | 21.45 | 35.7 | 42.38 | 21.45 |  | A
SI | I | 08/03/2009 | 14506 | 08/03/2009 | 1 | 42160 | DAB | A04 | 0.3 | 7.5 | 201.78 | 16 | 0 | 0 | 16 |  | B
Cert | I | 08/03/2009 | 14506 | 08/03/2009 | 1 | 42160 | DAB | A04 | 1 | 25 | 201.78 | 85 | 0 | 0 | 85 |  | C
AFT | I | 08/03/2009 | 14506 | 08/03/2009 | 1 | 42160 | DAB | A04 | 0.1 | 2.5 | 201.78 | 8.5 | 17.22 | 28.45 | 8.5 |  | D
02 | C | 08/03/2009 | 93119 | 08/03/2009 | 14 | 42162 | KF | A20 | 0.3 | 7.5 | 231.33 | 16 | 18.35 | 23.95 | 16 | APR | A
SI | C | 08/03/2009 | 93119 | 08/03/2009 | 14 | 42162 | KF | A20 | 0.3 | 7.5 | 231.33 | 16 | 0 | 0 | 16 | APR | B
27 | C | 08/03/2009 | 93119 | 08/03/2009 | 14 | 42162 | KF | A20 | 0 | 0 | 231.33 | 0 | 0 | 0 | 0 | APR | C
Afcs | C | 08/03/2009 | 93119 | 08/03/2009 | 14 | 42162 | KF | A20 | 0.1 | 2.5 | 231.33 | 7.5 | 4.76 | 12.45 | 7.5 | APR | D
CAB | C | 08/03/2009 | 93119 | 08/03/2009 | 14 | 42162 | KF | A20 | 0.2 | 5 | 231.33 | 17 | 37.29 | 42.95 | 17 | APR | E
PSF | C | 08/03/2009 | 93119 | 08/03/2009 | 14 | 42162 | KF | A20 | 0.5 | 12.5 | 231.33 | 53.96 | 23.99 | 35.99 | 53.96 | APR | F
SI | C | 08/03/2009 | 28456 | 08/03/2009 | 2 | 42164 | KF | A07 | 0.3 | 7.5 | 16 | 16 | 0 | 0 | 16 |  | A
V1321 | W | 08/03/2009 | 37135 | 08/27/2009 | 2 | 42166 | DAB | A20 | 0.7 | 17.5 | 250.98 | 58.1 | 0 | 0 | 58.1 | DWW | A
[NAME] | I | 08/03/2009 | 37135 | 08/27/2009 | 2 | 42166 | DAB | A20 | 0.3 | 7.5 | 250.98 | 21.45 | 35.7 | 42.38 | 21.45 | DWW | B
SI | I | 08/03/2009 | 37135 | 08/27/2009 | 2 | 42166 | DAB | A20 | 0.3 | 7.5 | 250.98 | 16 | 0 | 0 | 16 | DWW | C
UVI | I | 08/03/2009 | 37135 | 08/27/2009 | 2 | 42166 | DAB | A20 | 1 | 25 | 250.98 | 85 | 0 | 0 | 85 | DWW | D