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

Reinspection Rort:
 |  |  |  |  |  |  |  |  | Owner Name: |  | Reinspector Name:
 |  |  |  |  |  |  |  |  | Estimate Version: | E01 | Reinspection Location: | Other Location
 |  |  |  |  |  |  |  |  | [NAME]: |  | Repair Phase: | -- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7238.43 | -7238.43 |  |  |  | Alternate Repair Method | Exception - Alternate Repair Method: This exception indicates the selected line item may be replaced with an alternate repair method. | 1
 |  |  |  |  |  |  |  |  | Reinspection Type: | Total Loss Reinspection | Reinspection Complete: | 2012-01-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A |  |  | Mechanical
 |  |  |  |  |  |  |  |  | Reinspector Notes: | Total loss reinspection 2007 Toyota Camry at Copart Punta Gorda. Options: missed BBS wheels and aftermarket window tint. Conditioning- 1 difference- exterior trim from minor to moderate- all 4 wheels are curbed, 2 pretty serously. Estimatics: I re-wrote entire estimate using a rear section that is listed at Ole South, I confirmed it has been there for over 60 days. Using a rear section vs individual pieces cuts the price of the repairs substantially, and eliminated supplement requests for additional parts. Does not validate as a total loss. No red sticker. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Missed Damage | Exception - Missed Damage: This exception indicates the estimate is missing a line item. | 0
 |  |  |  |  |  |  |  |  | Coaching Recipient Notes: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Damage | Exception - No Damage: This exception indicates that the line item listed represents an item that is not damaged. | 0
[NAME] and Opportunity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No Visible Damage | Exception - No Visible Damage: This exception indicates that the line item listed represents an item that is not visibly damaged. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  | Open Item | Exception - Open Item: This exception indicates that the selected line item may not be damaged and requires further inspection. | 0
 |  |  |  |  |  |  |  |  | Estimate Accuracy (%): | 0.6813 | Dollar Accuracy: | 7238.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Part Only
 |  |  |  |  |  |  |  |  | Opportunity (%): | 0.3187 | Dollar Opportunity: | -3385.67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Partial Panel Replace
Estimate Line Item Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parts Price Difference | Exception - Parts Price Difference: This exception indicates the part price on the estimate is incorrect. | 0
 |  |  |  |  |  |  |  |  | Line # |  | Version |  | Operation |  | Part Type |  | Description |  | Qty |  | Unit Price |  | Extended Price |  | Adj % |  | Bett % |  | Labor Units |  | Labor Type |  | [NAME]
 |  |  |  |  |  |  |  |  | 4 |  | E01 |  | Refinish |  | Other |  | Side Rail Assembly RT |  | 1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0.7T |  | Refinish
 |  |  |  |  |  |  |  |  | Exception - Alternate Repair Method: This exception indicates the selected line item may be replaced with an alternate repair method. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alternate Part Usage | Exception - Alternate Parts Usage: This exception specifies the use of alternate parts. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Refinish |  | Other |  | Side Rail Assembly RT |  | 1 |  | -3194.03 |  | -3194.03 |  | 0 |  | 0 |  | 0.7T |  | Refinish |  | -3385.67 |  |  |  |  |  |  |  |  |  |  |  |  | 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
Part Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastic Repair Replace | Exception - Plastic Repair vs. Replace: This exception indicates the selected line item should be plastic repair instead of replace. | 0
There are no Part Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastic Repair Replace Sublet
Labor Summary Exceptions
There are no Labor Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recycled Parts | Exception - Recycled Part: This exception specifies the use of recycled parts. | 0
Material Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repair vs. Replace | Exception - Repair vs. Replace: This exception indicates the selected line item should be repair instead of replace. | 0
There are no Material Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repair vs. [NAME]
Additional Charges Summary Exceptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Straightening | Exception - Straightening: This exception indicates that the selected line item contains incorrect labor units. | 0
There are no Additional Charges Summary Exceptions on this Reinspection. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unibody Frame | Exception - Unibody / Frame: This exception is specific to line items for Unibody or Frame damage. | 0
Vehicle Information Exceptions
There are no Vehicle Information Exceptions on this Reinspection.
Total Loss Valuation and Opportunity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Additional Charges
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Agreement | Exception - Agreement: This exception indicates the selected line item was not written as agreed with the repair facility. | 0
 |  |  |  |  |  |  |  |  | Valuation Amount: | 16277.1 | Valuation Amount Variance: | 195 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Exception - Appearance Allowance: This exception indicates that the line item should be adjusted for appearance allowance. | 0
 |  |  |  |  |  |  |  |  | Actual [NAME]: | 55 | Valuation Amount Accuracy (%): | 0.988 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Betterment | Exception - Betterment: This exception will update selected categories on the line item by applying a percentage for betterment. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | Repair Cost |  |  |  |  |  | Total Loss Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discount/[NAME]
 |  |  | Appraiser Value |  | Reinspector Value |  |  |  | Appraiser Value |  | Reinspector Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Included Operation | Exception - INC Operation: This exception indicates that the line item listed is included in another line item on the estimate. | 0
 | Estimate $ (including taxes |  | 10624.1 |  | 7238.43 |  | ACV $ (including taxes and |  | 16218.8 |  | 16277.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Rates
 | and before deductible) |  |  |  |  |  | before deductible) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material Rates
 | Projected Loss of Use $ |  | 0 |  | 0 |  | Projected Loss of Use $ |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non-Included Operation
 | Projected Supplement |  | 548.08 |  | 0 |  | Less Projected Salvage |  | 6489 |  | 6489 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prior Damage | Exception - Prior Damage: This exception indicates that the part listed in the line item is prior damage. | 0
 | Consideration |  |  |  |  |  | Recovery |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supplement Reconciliation | Exception - Supplement Reconciliation: This exception indicates the selected line item did not resolve an item on the original estimate. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Update Included in Other
 | Projected Repair Cost |  | 11172.18 |  | 7238.43 |  | Projected Repair Cost |  | 9729.8 |  | 9788.1
Total Loss Valuation Exceptions
 |  |  |  |  |  |  |  |  | Exception Code |  | [NAME] |  | Reinspector Notes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blending | Exception - Blending: This exception indicates that spot paint and blend should be used. | 0
 |  |  |  |  |  |  |  |  | Conditioning |  | -70 |  | exterior trim, from minor to moderate wear- all 4 wheels have curb scrapes on them, some have very obvious deeps scrapes. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Clearcoat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Refinish | Exception - Refinish: This exception indicates that the selected line item contains incorrect refinish labor hours or material units. | 0
 |  |  |  |  |  |  |  |  | Equipment / Mileage |  | 25 |  | alloy wheels to BBS wheels
 |  |  |  |  |  |  |  |  | Equipment / Mileage |  | 100 |  | aftermarket window tint |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compliance | Exception - Compliance: This exception indicates the selected line item is not in compliance with appraisal guidelines. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miscellaneous | [NAME]: This exception indicates the selected line item contains an issue that does not fall under one of the standard exception codes. | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Body | B-- | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | Body | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | G-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Carpets | C-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | D-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Headliner | H-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Seats | S-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Engine | E-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Transmission | T-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paint | P-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FT-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | RT-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Equipment/Mileage | EM-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prior Collision Damge | PD-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | O-- | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Repairable