missesfrancis
New Member
- Joined
- Oct 2, 2017
- Messages
- 2
Hi!
I have below a small portion of a file. I have sorted my file by 'PART_NUMBER'. But now I want to see if there is a formula to tell me if the part number in red has a different rate than the part number in black.
I am trying to see which ones are equal to, less than or more than the white rows.
I have about 12000 lines on this excel file and I'd like to find out which rates changed in price or stayed the same - by doing a formula rather than going down line by line.
[TABLE="width: 1783"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SERVICE_DESCRIPTION[/TD]
[TD]PART_NUMBER[/TD]
[TD]PURCHASE_CATEGORY_CODE[/TD]
[TD]ITEM_MASTER[/TD]
[TD]DATE_FROM[/TD]
[TD]DATE_TO[/TD]
[TD]DETAIL_COMMENTS[/TD]
[TD]QUALIFIER[/TD]
[TD]QUANTITY_THRESHOLD[/TD]
[TD]UNITS[/TD]
[TD]MIN_RATE[/TD]
[TD]MAX_RATE[/TD]
[/TR]
[TR]
[TD]10001352-ZFF - Field Specialist-Fishing[/TD]
[TD]10001352-ZFF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3850.00[/TD]
[TD="align: right"]3850.00[/TD]
[/TR]
[TR]
[TD]10001352-ZFL - Field Specialist-Fishing[/TD]
[TD]10001352-ZFL[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.00[/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]Fishing Tool Supervisor Technician-SERV-FS PER 24 HRS[/TD]
[TD]10001352-ZFL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]10001352-ZHF - Field Specialist-Fishing[/TD]
[TD]10001352-ZHF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3955.00[/TD]
[TD="align: right"]3955.00[/TD]
[/TR]
[TR]
[TD]Fishing Tool Supervisor Technician-SERV-TS HAZARDOUS[/TD]
[TD]10001352-ZHF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]3955.00[/TD]
[/TR]
[TR]
[TD]10001352-ZPES - Fishing Tool Supervisor Technician PERSONEL STDBYPERDAY[/TD]
[TD]10001352-ZPES[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.00[/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]10001352-ZPES - Fishing Tool Supervisor Technician PERSONEL STDBYPERDAY[/TD]
[TD]10001352-ZPES[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]10/27/2015[/TD]
[TD="align: right"]6/30/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.03[/TD]
[TD="align: right"]2795.03[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-RENT-STANDBY[/TD]
[TD]10005067-ZSB[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]75.00[/TD]
[TD="align: right"]75.00[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-MILEAGE-CAR/PICKUP[/TD]
[TD]10005067-ZWF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3.75[/TD]
[TD="align: right"]3.75[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-MILEAGE-CAR/PICKUP[/TD]
[TD]10005067-ZWF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]3.75[/TD]
[/TR]
[TR]
[TD]10005067-ZWP - Miles/KM - Fishing Service[/TD]
[TD]10005067-ZWP[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]10005067-ZX8 - MILES/KM - FISHING SERVICE[/TD]
[TD]10005067-ZX8[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]6.00[/TD]
[TD="align: right"]6.00[/TD]
[/TR]
[TR]
[TD]3rd Party Svc - Fishing Service-REPAIR-DAMAGED ITEM[/TD]
[TD]10005080-ZZC[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-FLAT RT[/TD]
[TD]10005120-ZLJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-INITIAL[/TD]
[TD]10005120-ZMH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-ADD'L[/TD]
[TD]10005120-ZQF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-STANDBY[/TD]
[TD]10005120-ZQG[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Assistant Oper. - Fishing-SERVICE - 24 HR[/TD]
[TD]10068646-ZWS[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2853.00[/TD]
[TD="align: right"]2853.00[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - AMT - STANDBY[/TD]
[TD]10071484-ZAMS[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]647.80[/TD]
[TD="align: right"]647.80[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-AMT - STANDBY[/TD]
[TD]10071484-ZAMS[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - Advanced MillingTech[/TD]
[TD]10071484-ZAMT[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1457.55[/TD]
[TD="align: right"]1457.55[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-Advanced MillingTech[/TD]
[TD]10071484-ZAMT[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1457.55[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - RENT-PREM TOOL[/TD]
[TD]10071484-ZBR[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1082.25[/TD]
[TD="align: right"]1082.25[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-RENT-PREM TOOL[/TD]
[TD]10071484-ZBR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1082.25[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - RENT-O.D. INCH/JOB[/TD]
[TD]10071484-ZOD[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1266.30[/TD]
[TD="align: right"]1266.30[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-RENT-O.D. INCH/JOB[/TD]
[TD]10071484-ZOD[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1266.30[/TD]
[/TR]
</tbody>[/TABLE]
I have below a small portion of a file. I have sorted my file by 'PART_NUMBER'. But now I want to see if there is a formula to tell me if the part number in red has a different rate than the part number in black.
I am trying to see which ones are equal to, less than or more than the white rows.
I have about 12000 lines on this excel file and I'd like to find out which rates changed in price or stayed the same - by doing a formula rather than going down line by line.
[TABLE="width: 1783"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]SERVICE_DESCRIPTION[/TD]
[TD]PART_NUMBER[/TD]
[TD]PURCHASE_CATEGORY_CODE[/TD]
[TD]ITEM_MASTER[/TD]
[TD]DATE_FROM[/TD]
[TD]DATE_TO[/TD]
[TD]DETAIL_COMMENTS[/TD]
[TD]QUALIFIER[/TD]
[TD]QUANTITY_THRESHOLD[/TD]
[TD]UNITS[/TD]
[TD]MIN_RATE[/TD]
[TD]MAX_RATE[/TD]
[/TR]
[TR]
[TD]10001352-ZFF - Field Specialist-Fishing[/TD]
[TD]10001352-ZFF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3850.00[/TD]
[TD="align: right"]3850.00[/TD]
[/TR]
[TR]
[TD]10001352-ZFL - Field Specialist-Fishing[/TD]
[TD]10001352-ZFL[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.00[/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]Fishing Tool Supervisor Technician-SERV-FS PER 24 HRS[/TD]
[TD]10001352-ZFL[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]10001352-ZHF - Field Specialist-Fishing[/TD]
[TD]10001352-ZHF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3955.00[/TD]
[TD="align: right"]3955.00[/TD]
[/TR]
[TR]
[TD]Fishing Tool Supervisor Technician-SERV-TS HAZARDOUS[/TD]
[TD]10001352-ZHF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]3955.00[/TD]
[/TR]
[TR]
[TD]10001352-ZPES - Fishing Tool Supervisor Technician PERSONEL STDBYPERDAY[/TD]
[TD]10001352-ZPES[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]7/1/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.00[/TD]
[TD="align: right"]2795.00[/TD]
[/TR]
[TR]
[TD]10001352-ZPES - Fishing Tool Supervisor Technician PERSONEL STDBYPERDAY[/TD]
[TD]10001352-ZPES[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]10/27/2015[/TD]
[TD="align: right"]6/30/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2795.03[/TD]
[TD="align: right"]2795.03[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-RENT-STANDBY[/TD]
[TD]10005067-ZSB[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]75.00[/TD]
[TD="align: right"]75.00[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-MILEAGE-CAR/PICKUP[/TD]
[TD]10005067-ZWF[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]3.75[/TD]
[TD="align: right"]3.75[/TD]
[/TR]
[TR]
[TD]Miles/KM - Fishing Service-MILEAGE-CAR/PICKUP[/TD]
[TD]10005067-ZWF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]3.75[/TD]
[/TR]
[TR]
[TD]10005067-ZWP - Miles/KM - Fishing Service[/TD]
[TD]10005067-ZWP[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]5.00[/TD]
[TD="align: right"]5.00[/TD]
[/TR]
[TR]
[TD]10005067-ZX8 - MILES/KM - FISHING SERVICE[/TD]
[TD]10005067-ZX8[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]6.00[/TD]
[TD="align: right"]6.00[/TD]
[/TR]
[TR]
[TD]3rd Party Svc - Fishing Service-REPAIR-DAMAGED ITEM[/TD]
[TD]10005080-ZZC[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-FLAT RT[/TD]
[TD]10005120-ZLJ[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-INITIAL[/TD]
[TD]10005120-ZMH[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-ADD'L[/TD]
[TD]10005120-ZQF[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3rd Party Equip - Fishing Service-OUTSIDE RENT-STANDBY[/TD]
[TD]10005120-ZQG[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Assistant Oper. - Fishing-SERVICE - 24 HR[/TD]
[TD]10068646-ZWS[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]1/24/2012[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]2853.00[/TD]
[TD="align: right"]2853.00[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - AMT - STANDBY[/TD]
[TD]10071484-ZAMS[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]647.80[/TD]
[TD="align: right"]647.80[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-AMT - STANDBY[/TD]
[TD]10071484-ZAMS[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - Advanced MillingTech[/TD]
[TD]10071484-ZAMT[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1457.55[/TD]
[TD="align: right"]1457.55[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-Advanced MillingTech[/TD]
[TD]10071484-ZAMT[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1457.55[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - RENT-PREM TOOL[/TD]
[TD]10071484-ZBR[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1082.25[/TD]
[TD="align: right"]1082.25[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-RENT-PREM TOOL[/TD]
[TD]10071484-ZBR[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1082.25[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY - RENT-O.D. INCH/JOB[/TD]
[TD]10071484-ZOD[/TD]
[TD][/TD]
[TD="align: right"]3012205[/TD]
[TD="align: right"]9/20/2017[/TD]
[TD="align: right"]12/31/2017[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]EA[/TD]
[TD="align: right"]1266.30[/TD]
[TD="align: right"]1266.30[/TD]
[/TR]
[TR]
[TD]WATERMELON/STRING MILL SUPERLOY-RENT-O.D. INCH/JOB[/TD]
[TD]10071484-ZOD[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]EA[/TD]
[TD] [/TD]
[TD="align: right"]1266.30[/TD]
[/TR]
</tbody>[/TABLE]