Setting up of an Exchange ratio

For all currencies listed in the "Export" column of one spreadsheet which i am having, in that sheet it is being asked to set up an exchange ratio:

1. To AUD

2. From AUD

3. To NZD

4. From NZD

The sample extract of the excel sheet is given below in word format for reference.

FOREIGN CURRENCY QUOTING & SOURCING TABLE

Highlighted currencies are designated by NYTO as a "Hard Currency"

Currencies noted with "(S3)" are defined by NYTO as a "Soft 3 Currency" experiencing hyperinflation 2

(At present there are no "soft 3" currencies currently defined by NYTO)

SUPPLIER'S

COUNTRY OF LOCAL CCY QUOTING SOURCING CURRENCY 1

MANUFACTURE CURRENCY CODE LOCAL EXPORT

Argentina Peso ARS ARS $U.S.

Australia Aust. Dollar AUD AUD AUD

Austria Euro EUR EUR EUR

Belgium Euro EUR EUR EUR

Botswana Pula BWP BWP $U.S.

Brazil Real BRL BRL $U.S.

Bulgaria Lev BGN BGN Euro

1. Definition of Local & Export

Local: When supplier's component, product, or service is consumed by company within the supplier's country of manufacture.

Export: When supplier's component, product, or service is consumed by company outside the supplier's country of manufacture

2. Hyperinflation

Due to the local price instability of u201CSoft 3u201D currencies, for local company use, the company will request quotes

and contract in local currency with an index to the applicable export currency

Hence, anyone can help me...