Spreadsheet: 100806d1299045097-vlookup-error-in-some-cells-but-not-others-costings-template-automated-bigresource
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 | FX Rate | Interest Rate | 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 | Alloy 800HT |  | 12000 | 3000 | 20 | 3.2 | 1 | - |  |  |  |  | p/Tonne |  | 1000 |  |  |  | 1 | 0.025 | 0 | 0 | 30 | 60 | 0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 100 |  |  |  |  |  |  |  |  |  | 1400
 |  | Section | PFC 150 x 90 x 24 |  |  |  |  |  | 10 | 12 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Section | Stainless Steel 400S |  | 6000 | 2000 | 12 |  | 3 | - |  |  |  |  | p/Tonne |  | 500 |  |  |  | 1 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Tubular | HE 320 A |  |  |  |  |  | 1 | 12 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Plate | Carbon Steel |  | 10000 | 2000 | 2000 |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 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
 |  | Tubular | Multimet N155 |  | 1000 | 10 | - |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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