Spreadsheet: 100923d1299137644-vlookup-error-in-some-cells-but-not-others-costings-template-automated-rev10-big-resource
Sheet: Costings

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sell Currency: |  |  |  |  |  |  |  |  |  | Financial Costs |  |  |  |  |  |  |  |  | Shipping Costs |  |  |  |  |  |  |  | Summary
[NAME] | [NAME] | Type | Material / Section Type | Grade | Dimensions |  |  | Minimum Certification | Quantity (Approx) | [NAME] (Approx) | Mtrs / Square Mtrs   (Approx) | Kg Each / Per Mtr  (Approx) | Total Weight (Approx) | Price Per Unit | Unit | Extended Price | Material Unit Cost (Base Currency) p/Tonne | Material Total Cost (Base Currency) | Supplier | Terms | Import LC required | Export LC required | Guarantee required | FX Rate | Interest Rate | Import LC required | Export LC required | Guarantee required | Commission Receivable | Commission Payable | No. Of days (terms) supplier | No. Of days (terms) Customer | Duty (suppliers) | Duty (Local) | Wharfage | Discharge stevedoring | Extras Yard/ Unpacking | Agency | Cartage | [NAME] (Base Currency, includes [NAME]) | FOB Purchase Cost p/Tonne | CIF Purchase Cost p/Tonne | Duty Total (Base Currency) | Clearance Total (Base Currency) | Total Commision Payable | Bank Charge | Interest | Gross FIS Purchase Cost p/Tonne | Gross Cost | Sell Price p/Tonne | Extended Price | Profit | Margin
1 | 1 | Plate | Zirconium 702 |  | 12000 | 3000 | 20 | 3.2 | 1 | 12 |  |  |  |  | p/Tonne |  | 1000 |  |  |  | YES | Yes | Yes | 1 | 0.025 |  |  |  | 0 | 0 | 30 | 60 | 0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 100 |  |  |  |  |  |  |  |  |  | 1400
 |  | Section | Jumbo SHS 550 x 550 x 19 |  | 12000 |  |  |  | 10 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Section | PFC 180 x 90 x 26 |  | 6000 | 2000 | 12 |  | 3 | 12 |  |  |  |  | p/Tonne |  | 500 |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Tubular | Alloy 42 |  |  |  |  |  | 1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Plate | Carbon Steel |  | 10000 | 2000 | 10000 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Section | PFC 230 x 90 x 32 |  |  |  |  |  | 1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Tubular | Carbon Steel |  | 1000 | 10 | - |  | 1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Section | UB 914 x 305 x 253 |  |  |  |  |  | 1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Tubular | Carbon Steel |  |  |  |  |  | 1 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Section | PFC 200 x 90 x 30 |  |  |  |  |  | 1 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p/mtr |  | 0 |  |  |  |  |  |  | 1 | 0 |  |  |  | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0