Spreadsheet: 169470d1342871450-vlookup-formula-with-changing-sheet-reference-excel-2003-total-loss-rei-workbook-test-2
Sheet: TL1

 |  |  |  |  |  |  |  |  | Owner Name: |  | Reinspector Name:
 |  |  |  |  |  |  |  |  | Estimate Version: | E01 | Reinspection Location: | Salvage Yard
 |  |  |  |  |  |  |  |  | [NAME]: |  | Repair Phase: | -- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1 | 1 |  |  |  | Alternate Repair Method | Exception - Alternate Repair Method: This exception indicates the selected line item may be replaced with an alternate repair method. | 0
 |  |  |  |  |  |  |  |  | Reinspection Type: | Total Loss Reinspection | Reinspection Complete: | 2012-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 246.72 | 0.004053177691309987 | 0.004053177691309973 |  |  | Mechanical
 |  |  |  |  |  |  |  |  | Reinspector Notes: | FPIT***T/L REI***Orl FIC ***06-25-12***HO, FPL, DE Garretson***Decision proper***Red tag missing***Supp consideration for mechanical LT drive damage noted possible shaft at trans flange damage..LT side innerstructure in rocker and "B" pillar may require removal of outer for repair or replacement to inner. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Missed Damage | Exception - Missed Damage: This exception indicates the estimate is missing a line item. | 1
[NAME] and Opportunity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Damage | Exception - No Damage: This exception indicates that the line item listed represents an item that is not damaged. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Visible Damage | Exception - No Visible Damage: This exception indicates that the line item listed represents an item that is not visibly damaged. | 1
 |  |  |  |  |  |  |  |  | Estimate Accuracy (%): | 0.8929 | Dollar Accuracy: | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 244.72 |  |  |  |  | Open Item | Exception - Open Item: This exception indicates that the selected line item may not be damaged and requires further inspection. | 0
 |  |  |  |  |  |  |  |  | Opportunity (%): | 0.07 | Dollar Opportunity: | -1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Part Only
Estimate Line Item Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partial Panel Replace
 |  |  |  |  |  |  |  |  | Line # |  | Version |  | Operation |  | Part Type |  | Description |  | Qty |  | Unit Price |  | Extended Price |  | Adj % |  | Bett % |  | Labor Units |  | Labor Type |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Parts Price Difference | Exception - Parts Price Difference: This exception indicates the part price on the estimate is incorrect. | 1
 |  |  |  |  |  |  |  |  | 21 |  | E01 |  | Remove / Replace |  | OEM |  | LT Inner rail |  | 1 |  | 81.95 |  | 81.95 |  | -0.1 |  | 0 |  | 5.5T |  | Body
 |  |  |  |  |  |  |  |  | Exception - No Visible Damage: This exception indicates that the line item listed represents an item that is not visibly damaged.
 |  |  |  |  |  |  |  |  | This item will be removed. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -311.39 |  |  |  |  |  |  |  |  |  |  |  |  | Alternate Part Usage | Exception - Alternate Parts Usage: This exception specifies the use of alternate parts. | 0
 |  |  |  |  |  |  |  |  | Reinspector Notes: |  |  |  | It appears as though this part may have been selected for replace in error. When damage to adjacent part selected for repair appears accurate without this part .NVD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non OEM Parts | Exception - Non OEM: This exception specifies the use of a non-OEM part. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overlap | Exception - Overlap: This exception indicates that labor required for this part overlaps labor required for another part in the estimate. | 0
 |  |  |  |  |  |  |  |  | 29 |  | E01 |  | Remove / Replace |  | OEM |  | Module |  | 1 |  | 40.15 |  | 40.15 |  | -0.1 |  | 0 |  | 0.0T |  | Body |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastic Repair Replace | Exception - Plastic Repair vs. Replace: This exception indicates the selected line item should be plastic repair instead of replace. | 0
 |  |  |  |  |  |  |  |  | Exception - Parts Price Difference: This exception indicates the part price on the estimate is incorrect. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastic Repair Replace Sublet
 |  |  |  |  |  |  |  |  |  |  |  |  | Remove / Replace |  | OEM |  | Module |  | 1 |  | 150 |  | 150 |  | -0.1 |  | 0 |  | 0.0T |  | Body |  | 104.8
 |  |  |  |  |  |  |  |  | Reinspector Notes: |  |  |  | Module selected is inside vehicle. The correct part would be greater cost. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recycled Parts | Exception - Recycled Part: This exception specifies the use of recycled parts. | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repair vs. Replace | Exception - Repair vs. Replace: This exception indicates the selected line item should be repair instead of replace. | 0
 |  |  |  |  |  |  |  |  | 35 |  | E01 |  | Remove / Replace |  | OEM |  | LT Lower cntrl arm |  | 1 |  | 182 |  | 182 |  | -0.1 |  | 0 |  | 0.0T |  | Body |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repair vs. [NAME]
 |  |  |  |  |  |  |  |  | Exception - Recycled Part: This exception specifies the use of recycled parts. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Straightening | Exception - Straightening: This exception indicates that the selected line item contains incorrect labor units. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Remove / Replace |  | LKQ |  | LT Lower cntrl arm |  | 1 |  | 22 |  | 22 |  | -0.1 |  | 0 |  | 0.0T |  | Body |  | -150.3 |  |  |  |  |  |  |  |  |  |  |  |  | Unibody Frame | Exception - Unibody / Frame: This exception is specific to line items for Unibody or Frame damage. | 0
 |  |  |  |  |  |  |  |  | Reinspector Notes: |  |  |  | LKQ knee assy would offer more favorable parts pricing than the OEM individual parts. Locted knee assy for 160.00 net less than combined OEM parts.
 |  |  |  |  |  |  |  |  | Exception - Missed Damage: This exception indicates the estimate is missing a line item. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional Charges
 |  |  |  |  |  |  |  |  |  |  |  |  | Remove / Replace |  | LKQ |  | LT [NAME] |  | 1 |  | 100 |  | 100 |  | 0.2 |  | 0 |  | 0.3T |  | Body |  | 139.92 |  |  |  |  |  |  |  |  |  |  |  |  | Agreement | Exception - Agreement: This exception indicates the selected line item was not written as agreed with the repair facility. | 0
 |  |  |  |  |  |  |  |  | Reinspector Notes: |  |  |  | LT [NAME] damaged and requiring replace. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Exception - Appearance Allowance: This exception indicates that the line item should be adjusted for appearance allowance. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Betterment | Exception - Betterment: This exception will update selected categories on the line item by applying a percentage for betterment. | 0
Part Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delete Included in Other | Exception - Delete - Included in Another Exception: This exception indicates that the selected line item is already included in another exception previously recorded. | 0
There are no Part Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discount/[NAME]
Labor Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Included Operation | Exception - INC Operation: This exception indicates that the line item listed is included in another line item on the estimate. | 0
There are no Labor Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Rates
Material Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material Rates
There are no Material Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Included Operation
Additional Charges Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prior Damage | Exception - Prior Damage: This exception indicates that the part listed in the line item is prior damage. | 0
There are no Additional Charges Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supplement Reconciliation | Exception - Supplement Reconciliation: This exception indicates the selected line item did not resolve an item on the original estimate. | 0
Vehicle Information Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Update Included in Other
There are no Vehicle Information Exceptions on this Reinspection.
Total Loss Valuation and Opportunity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blending | Exception - Blending: This exception indicates that spot paint and blend should be used. | 0
 |  |  |  |  |  |  |  |  | Valuation Amount: | 1 | Valuation Amount Variance: | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clearcoat
 |  |  |  |  |  |  |  |  | Actual [NAME]: | 1 | Valuation Amount Accuracy (%): | 0.9793 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Refinish | Exception - Refinish: This exception indicates that the selected line item contains incorrect refinish labor hours or material units. | 0
 | Repair Cost |  |  |  |  |  | Total Loss Cost
 |  |  | Appraiser Value |  | Reinspector Value |  |  |  | Appraiser Value |  | Reinspector Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compliance | Exception - Compliance: This exception indicates the selected line item is not in compliance with appraisal guidelines. | 0
 | Estimate $ (including taxes |  | 1 |  | 1 |  | ACV $ (including taxes and |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miscellaneous | [NAME]: This exception indicates the selected line item contains an issue that does not fall under one of the standard exception codes. | 0 | ABS Total | Negative Totals | Positive Totals
 | and before deductible) |  |  |  |  |  | before deductible)
 | Projected Loss of Use $ |  | 1 |  | 1 |  | Projected Loss of Use $ |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Body | B-- | 1 | 1 | -1 | 0
 | Projected Supplement |  | 1 |  | 1 |  | Less Projected Salvage |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | G-- | 1 | 1 | -1 | 0
 | Consideration |  |  |  |  |  | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carpets | C-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | DA-- | 1 | 1 | -1 | 0
 | Projected Repair Cost |  | 1 |  | 1 |  | Projected Repair Cost |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Headliner | H-- | 1 | 1 | -1 | 0
Total Loss Valuation Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seats | S-- | 1 | 1 | 0 | 1
 |  |  |  |  |  |  |  |  | Exception Code |  | [NAME] |  | Reinspector Notes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Engine | E-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  | Conditioning |  | 1 |  | S--Seats did not meet the criteria for rating of "fair"..Group review agreed conditioning rating of "private" would be appropriate. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transmission | TR-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  | Equipment / Mileage |  | 1 |  | EM--Vehicle is equipped with alloy wheels |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paint | P-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FT-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | P--Large Scrathes and numerous chips all over vehicle |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | RT-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Equipment/Mileage | EM-- | 3 | 3 | -1 | 2
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | C--Numerous tears in rear door panels |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prior Collision Damge | PCD-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | O-- | 1 | 1 | -1 | 0
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | G--Rear glass
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repairable
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | FT--measured
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | DA--two items
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | B--numerous
 |  |  |  |  |  |  |  |  | Equipment / Mileage |  | -1 |  | EM--Vehicle
 |  |  |  |  |  |  |  |  | Equipment / Mileage |  | 1 |  | EM--12 disc
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | H--dealer
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | E--Private
 |  |  |  |  |  |  |  |  | Prior Collision Damage |  | -1 |  | PCD--UPD
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | RT--measured
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | O--measured
 |  |  |  |  |  |  |  |  | Conditioning |  | -1 |  | TR-- measured
Estimate Line Item Exceptions |  |  |  |  |  |  |  |  |  |  |  | 75.4618672199158
There are no Estimate Line Item Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  | -150.676742738594
Part Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  | -376.815352697094
There are no Part Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  | -602.953962655604
Labor Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  | -829.092572614104
There are no Labor Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  | -1055.23118257261
Material Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  | -1281.36979253112
There are no Material Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  | -1507.50840248962
Additional Charges Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  | -1733.64701244813
There are no Additional Charges Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  | -1959.78562240664
Vehicle Information Exceptions |  |  |  |  |  |  |  |  |  |  |  | -2185.92423236514
There are no Vehicle Information Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  | -2412.06284232365
Total Loss Valuation and Opportunity |  |  |  |  |  |  |  |  |  |  |  | -2638.20145228216