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

 |  | MCO: | Melbourne
 |  | SUMMARY SHEET |  |  |  | DATE: | 2012-07-21 00:00:00
Reinspections: | #N/A
Field MOI:
TriageMOI:
PRO MOI:
 | REPAIR COST |  |  |  |  |  | TOTAL LOSS COST
 | T/L Tech |  | Reinspector |  |  |  | T/L Tech |  | Reinspector
Total Base Dollars: | 10625.1 |  | 7239.43 |  |  | Total ACV Dollars: | 16219.8 |  | 16278.1
Field MOI: | 10625.1 |  | 7239.43 |  |  | Field MOI: | 16219.8 |  | 16278.1
TriageMOI: |  |  |  |  |  | TriageMOI:
PRO MOI: |  |  |  |  |  | PRO MOI:
Total Est. [NAME].: | 7239.43 |  | 0.6813517049251301 |  |  | Total ACV Dollars Sat.: | 16278.1 |  | 0.9964056276896138 | 58.30000000000109
Repair Variance: | 3385.67 |  | 0.3186482950748699 |  |  | ACV Variance: | 58.30000000000109 |  | 0.003594372310386139
 | T/L Tech |  | Reinspector |  |  |  | T/L Tech |  | Reinspector
Total Repair LOU: | 0 |  | 1 |  |  | Total Loss LOU: | 9 |  | 1
Field MOI: | 0 |  | 1 |  |  | Field MOI: | 9 |  | 1
TriageMOI: |  |  |  |  |  | TriageMOI:
PRO MOI: |  |  |  |  |  | PRO MOI:
 | T/L Tech |  | Reinspector |  |  |  | T/L Tech |  | Reinspector
Total Repair Supp.: | 549.08 |  | 1 |  |  | Total Loss Salvage: | 6490 |  | 6490
Field MOI: | 549.08 |  | 1 |  |  | Field MOI: | 6490 |  | 6490
TriageMOI: |  |  |  |  |  | TriageMOI:
PRO MOI: |  |  |  |  |  | PRO MOI:
 | T/L Tech |  | Reinspector |  |  |  | T/L Tech |  | Reinspector
Total Repair Cost: | 11173.18 |  | 7239.43 |  |  | Total Loss Cost: | 9730.8 |  | 9789.1
Field MOI: | 11173.18 |  | 7239.43 |  |  | Field MOI: | 9730.8 |  | 9789.1
TriageMOI: |  |  |  |  |  | TriageMOI:
PRO MOI: |  |  |  |  |  | PRO MOI:
VALUATION EXCEPTIONS
 | Total Additions: | Total Deductions: | Net Difference: | Exception Count: | Number of Files Affected: |  | Total Additions: | Total Deductions: | Net Difference: | Exception Count: | Number of Files Affected:
Body | #N/A | #N/A | #N/A | #N/A |  | Transmission | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A |  | Paint | #N/A | #N/A | #N/A | #N/A
Carpets | #N/A | #N/A | #N/A | #N/A |  | [NAME] | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A |  | [NAME] | #N/A | #N/A | #N/A | #N/A
Headliner | #N/A | #N/A | #N/A | #N/A |  | Equipment/Mileage | #N/A | #N/A | #N/A | #N/A
Seats | #N/A | #N/A | #N/A | #N/A |  | Prior Collision Damge | #N/A | #N/A | #N/A | #N/A
Engine | #N/A | #N/A | #N/A | #N/A |  | Other | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | Equiment/Mileage Exceptions | #N/A |  |  |  | Conditioning Exceptions | #N/A |  |  |  |  | #N/A
 |  |  | Number of Files Affected |  |  |  |  | Number of Files Affected |  |  |  |  |  | #N/A
 |  | Total Additions: | #N/A |  |  |  | Total Additions: | #N/A |  |  |  |  |  | #N/A
 |  | Total Subtractions: | #N/A |  |  |  | Total Subtractions: | #N/A |  |  |  |  |  | #N/A
 |  | Net Difference: | #N/A |  |  |  | Net Difference: | #N/A
 |  |  | Prior Damage Exceptions | #N/A |  |  |  | Year / Make / Model Exceptions | 0
 |  |  | Number of Files Affected |  |  |  |  | Number of Files Affected
 |  | Total Additions: | #N/A |  |  |  | Total Additions: | 0
 |  | Total Subtractions: | #N/A |  |  |  | Total Subtractions: | 0
 |  | Net Difference: | #N/A |  |  |  | Net Difference: | 0
Settlement Accuracy Amount:
Reinspector ACV: | 16278.1
Settlement Amount: | 11173.18
Dollar Variance: | 5104.92
% Accuracy: | 0.6863933751482053