Spreadsheet: 72603d1273286151-change-currency-formatting-based-on-value-of-another-cell-macro-start
Sheet: Data

 |  | Transport | Insurance etc. | Terms and location | Special column to allow both options | Special column to allow both options (2) | Clause re. transport mode + price | Price Summary | 2nd CIF total | Summary! Price to customer
 |  | Air | Air Freight and Insurance | Total CIF Brisbane Airport | ——————————————— | Ocean freight may be available on request
 |  | Ocean | Ocean Freight and Insurance | Total CIF Brisbane Port | ——————————————— | Air freight may be available on request
 |  | Air and Ocean | Air Freight and Insurance | Total CIF Brisbane Airport | Ocean Freight and Insurance | Total CIF Brisbane Port | 2.2   The [NAME], through their purchase order, must inform the [NAME] of their preferred method of transport. | (Air Price) | 0
 |  | Delivery Times
 |  | Air | 0.5
 |  | Ocean | 1
 |  | Air and Ocean | 1
 |  | CUSTOMER | Attn: | Dear ……… | TELEPHONE NUMBER | FAX NUMBER | Airport Delivery | Port Delivery | Site | Terms |  | Insurance | Risk | Appropriate price | Inland Costs | Terms and Conditions | ($) Inland Cost
 |  | Origin Energy | [NAME] | Dear Laurie, | (07) 4778 1700 | (07) 4729 0245 | Total CIF Brisbane Airport | Total CIF Brisbane Port | Origin Energy Mt. Stuart | The service provided is on a CIF basis. |  | 5.1    The Buyer must obtain and maintain at its sole cost and expense,             insurance from an authorised business and under the name of the             [NAME] and [NAME] which covers the transportation of Goods, at             replacement value, from Australian port until full payment is made.       5.2     The [NAME] may, through instruction, allow the [NAME] to assist in the              process of obtaining the insurance referred to in clause 5.1 above.     5.3     The [NAME] shall compensate the [NAME] for any claim made by the              insurance company, referred to in clause 5.1, including but not limited              to excess payments.     5.4     The Buyer must produce a certificate of insurance to show that the              [NAME] has taken out this insurance if so requested by the [NAME]. | an Australian port or airport. | 1.6       In accordance with clause 3.1 and 2.3, the [NAME] shall pay in full the total price, stated in clause 1, corresponding to the [NAME]'s preferred method of transport as stipulated in the [NAME]'s purchase order. |  | Subject to the Umbrella Agreement.
 |  | QNI | [NAME] | Dear Gordon, | (07)47206050 | (07) 4751 1050 | Total [NAME] (Air) | Total [NAME] (Ocean) | NQX - Eagle Farm | The service provided is on a DDP basis. |  | 5.1    The [NAME], on behalf of the [NAME], must obtain and maintain at its sole             cost and expense, insurance from an authorised business and under              the name of the [NAME] and [NAME] which covers the transportation of             Goods, at replacement value, from Australian port to Site.     5.2    The Buyer must obtain and maintain, at its sole cost and expense,             insurance from an authorised business which covers the transportation             of Goods, at replacement value, from the time of delivery of Goods to             Site until full payment is made.     5.3    The [NAME] shall compensate the [NAME] for any claim made by the             insurance company, referred to in clause 5.1 and 5.2, including but             not limited to excess payments.     5.4     The Buyer must produce a certificate of insurance to show that the              [NAME] has taken out insurance, in accordance with clause 5.2, if so              requested by the [NAME]. | Site | 1.6       In accordance with clause 3.1 and 2.3, the [NAME] shall pay in full the total price, stated in clause 1,                   corresponding to the [NAME]'s preferred method of transport as stipulated in the [NAME]'s purchase order. | Estimated Inland Costs to Site |  | 0
 |  | Flinders Power | [NAME] | Dear [NAME], | (08) 8372 8634 | (08) 8305 4919 | Total CIF Adelaide Airport | Total CIF Adelaide port | Turbogenerator [NAME] main store, Pt. Augusta | The service provided is on a CIF basis. |  | 5.1    The Buyer must obtain and maintain at its sole cost and expense,             insurance from an authorised business and under the name of the             [NAME] and [NAME] which covers the transportation of Goods, at             replacement value, from Australian port until full payment is made.       5.2     The [NAME] may, through instruction, allow the [NAME] to assist in the              process of obtaining the insurance referred to in clause 5.1 above.     5.3     The [NAME] shall compensate the [NAME] for any claim made by the              insurance company, referred to in clause 5.1, including but not limited              to excess payments.     5.4     The Buyer must produce a certificate of insurance to show that the              [NAME] has taken out this insurance if so requested by the [NAME]. | an Australian port or airport. | . | Estimated Inland Costs to Site |  | 0
 |  | [NAME] | [NAME] | Dear Natalie, | (07) 4973 0298 | (07) 4973 0920 | Total CIF Brisbane Airport | Total CIF Brisbane port | [NAME], Queensland | The service provided is on a CIF basis. |  | 5.1    The Buyer must obtain and maintain at its sole cost and expense,             insurance from an authorised business and under the name of the             [NAME] and [NAME] which covers the transportation of Goods, at             replacement value, from Australian port until full payment is made.       5.2     The [NAME] may, through instruction, allow the [NAME] to assist in the              process of obtaining the insurance referred to in clause 5.1 above.     5.3     The [NAME] shall compensate the [NAME] for any claim made by the              insurance company, referred to in clause 5.1, including but not limited              to excess payments.     5.4     The Buyer must produce a certificate of insurance to show that the              [NAME] has taken out this insurance if so requested by the [NAME]. | an Australian port or airport. | 1.6       In accordance with clause 3.1 and 2.3, the [NAME] shall pay in full the total price, stated in clause 1,                   corresponding to the [NAME]'s preferred method of transport as stipulated in the [NAME]'s purchase order.
 |  | Alcoa of Australia | [NAME] | Dear Cliff, | (08) 9530 2540 | (08) 9530 2589 | Total [NAME] | Total [NAME] port | Pinjarra Alcoa site | The service provided is on a CIF basis. |  | 5.1    The Buyer must obtain and maintain at its sole cost and expense,             insurance from an authorised business and under the name of the             [NAME] and [NAME] which covers the transportation of Goods, at             replacement value, from Australian port until full payment is made.       5.2     The [NAME] may, through instruction, allow the [NAME] to assist in the              process of obtaining the insurance referred to in clause 5.1 above.     5.3     The [NAME] shall compensate the [NAME] for any claim made by the              insurance company, referred to in clause 5.1, including but not limited              to excess payments.     5.4     The Buyer must produce a certificate of insurance to show that the              [NAME] has taken out this insurance if so requested by the [NAME]. | an Australian port or airport. | 1.6       In accordance with clause 3.1 and 2.3, the [NAME] shall pay in full the total price, stated in clause 1,                   corresponding to the [NAME]'s preferred method of transport as stipulated in the [NAME]'s purchase order. |  | Subject to the Long Term Services Agreement.
 |  | Mobil Refining Australia | [NAME] | Dear Anthony, | (03) 8633 8737 | (03) 9270 3193 | Total [NAME] | Total [NAME] port | Mobil [NAME] | The service provided is on a CIF basis. |  | 5.1    The Buyer must obtain and maintain at its sole cost and expense,             insurance from an authorised business and under the name of the             [NAME] and [NAME] which covers the transportation of Goods, at             replacement value, from Australian port until full payment is made.       5.2     The [NAME] may, through instruction, allow the [NAME] to assist in the              process of obtaining the insurance referred to in clause 5.1 above.     5.3     The [NAME] shall compensate the [NAME] for any claim made by the              insurance company, referred to in clause 5.1, including but not limited              to excess payments.     5.4     The Buyer must produce a certificate of insurance to show that the              [NAME] has taken out this insurance if so requested by the [NAME]. | an Australian port or airport. | 1.6       In accordance with clause 3.1 and 2.3, the [NAME] shall pay in full the total price, stated in clause 1,                   corresponding to the [NAME]'s preferred method of transport as stipulated in the [NAME]'s purchase order.
 |  | AETV | [NAME] | Dear [NAME], |  |  | Total [NAME] | Total [NAME] | Tamar Valley Power Station | The service provided is on a CIF basis. |  | 5.1    The [NAME], on behalf of the [NAME], must obtain and maintain at its sole             cost and expense, insurance from an authorised business and under              the name of the [NAME] and [NAME] which covers the transportation of             Goods, at replacement value, from Australian port to Site.     5.2    The Buyer must obtain and maintain, at its sole cost and expense,             insurance from an authorised business which covers the transportation             of Goods, at replacement value, from the time of delivery of Goods to             Site until full payment is made.     5.3    The [NAME] shall compensate the [NAME] for any claim made by the             insurance company, referred to in clause 5.1 and 5.2, including but             not limited to excess payments.     5.4     The Buyer must produce a certificate of insurance to show that the              [NAME] has taken out insurance, in accordance with clause 5.2, if so              requested by the [NAME]. | Site | 1.6       In accordance with clause 3.1 and 2.3, the [NAME] shall pay in full the total price, stated in clause 1,                   corresponding to the [NAME]'s preferred method of transport as stipulated in the [NAME]'s purchase order. | Estimated Inland Costs to Site | Subject to the Long Term Services Agreement.
 |  | Payment Method | Terms | Tradeline | Summary! Payment terms
 |  | CIF | 3.1  100% of the total price must be paid by the [NAME] through T.T. Remittance          into the Nominated Bank Account, within 30 days from date of [NAME]’s           invoice .    3.2  The total price in clause 1 does not include the following which must be           fully paid by the [NAME] through T.T. Remittance into the Nominated Bank          Account, within 30 days from date of [NAME]’s invoice:          i)    Inland Costs.          ii)   the Administration Fee.          iii)  GST payable on Goods, in accordance with clause 7.    3.3  The [NAME] shall be entitled to suspend the relevant and any subsequent          orders by notice to the [NAME], if the [NAME] fails to make all payment due          under this Agreement.  The cost to the [NAME] together with foregone profit,          occasioned by the suspension and the subsequent resumption of work,          shall be added to the suspended Price. |  | 30 days after invoicing |  | Figure Input
 |  | DDP | 3.1  100% of the total price must be paid by the [NAME] through           T.T. Remittance into the Nominated Bank Account, within 30 days          from date of [NAME]’s invoice .    3.2  The total price in clause 1 does not include the following which must be          fully paid by the [NAME] through T.T. Remittance into the Nominated Bank          Account, within 30 days from date of [NAME]’s invoice:          i)   the Administration Fee.          ii)  GST payable on Goods, in accordance with clause 7.    3.3   The [NAME] shall be entitled to suspend the relevant and any subsequent            orders by notice to the [NAME], if the [NAME] fails to make all payment due           under this Agreement.  The cost to the [NAME] together with foregone profit,           occasioned by the suspension and the subsequent resumption of work,           shall be added to the suspended Price. |  | 30 days after invoicing |  | Air Freight and Insurance | 0
 |  | Advanced Payment | Advanced Payment must be made by the [NAME] under the following terms:           i)    Advanced payment of 100% of the FOB Price, air freight and insurance                  in the specified currency shall be paid in full to the Seller’s Nominated                 Bank Account prior to [NAME] proceeding with the order.           ii)   Advanced payment of any GST payable on the Goods and 110% of the                 estimated Inland Costs (Inland Costs includes [NAME]) shall                 be made in Australian dollars.           iii)   In case of the estimated Inland Costs exceeding the actual Inland                 Costs total stated on the relevant invoice, the [NAME] shall refund the                 difference to the [NAME], within 30 days of delivery, to the [NAME]’s                 nominated account.           iv)   In case of actual Inland Costs exceeding estimated inland costs, the                 [NAME] shall pay the difference in full to the [NAME], within 30 days of                 delivery, to the Seller’s Nominated Account. | Not Applicable (Advanced Payment) | Not Applicable (Advanced Payment) |  | Ocean Freight and Insurance | 0
 |  | Letter of Credit | A standby letter of credit to guarantee payment must be arranged by the [NAME] under the following terms:          i)   The [NAME] must arrange for an irrevocable standby letter(s) of                credit issued and advised by one of Australia’s Four Major Banking               Institutions prior to the official purchase order being received by the               [NAME].          ii)  The value of the Irrevocable Letter of Credit shall be set at 110% of               the Price, plus 110% of the Inland Costs (Inland Costs includes the               Administration Fee).          iii)  The [NAME] shall have the discretion to approve or disapprove the form                of the letter of credit.          iv)   100% of the Price, applicable GST, importation charges and inland                 transport must be paid by the [NAME] through T.T. Remittance into the                Nominated Bank Account, within 30 days from date of [NAME]’s invoice. | Not Applicable (Letter of Credit) | 30 days after invoicing (LoC as guarantee)
 |  | Figure Input
 |  |  |  | Unit Price 1 | Unit Price 2 | Unit Price 3 | Air Frieght | Ocean Freight | 2nd CIF Total | Summary! Price to customer | Exchange Rate | Exchange Rate 2 | Exchange Rate 3 | Exchange Rate 4 | Exchange Rate title
 |  | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0
 |  | Australian Dollars |  | 0 | 0 | 0 | 0 | 0 | 0 |  | These quoted prices are based on an exchange rate of | -4 | JPY/$A and any price increase as a result | of changes in the exchange rate shall be paid by the [NAME] in accordance with clause 3. | Exchange Rate