Excel file link with two worksheet calculation
 

Hi ,

Could anyone help me.
I had a excel file consist of sheet 1 and sheet 2.
Sheet 1 consist of a table of different country freight cost.
Sheet 2 is a standard template to calculate the actual total cost.
If I entered 100 and Origin Italy it will auto take 100*0.65*2.1=136.5 as
formula
The Fuel and security also convert according

Sheet 1
Table
Airport Dest Currency Origin Min -45 +45 +100 +500
ABC SIN USD USA 35 0.36 0.31 0.27 0.26
Rate 1.45
Fuel USD 0.55/kg
Security USD 0.17/kg

Airport Dest Currency Origin Min -45 +45 +100 +500
EFG SIN EUR Italy 40 0.55 0.66 0.65 0.64
Rate 2.1
Fuel EUR 0.45/kg
Security EUR 0.20/kg

Airport Dest Currency Origin Min -45 +45 +100 +500
HIJ SIN AUD Aust 40 0.55 0.40 0.39 0.38
Rate 1.1
Fuel AUD 0.35/kg
Security AUD 0.25/kg

Sheet 2
Template
Origin Italy
Airport Description Rate Comment
Eur Port to Port 136.5 (100*0.65*2.1)
SIN Agency Fee 45
SIN Delivery Charge 30
SIN DO Fee 60
SIN Permit Fee 60
SIN Wharfage 60
EUR Fuel 115.5 (0.55*100*2.1)
EUR Security 35.7 ( 0.17*100*2.1)
SIN Total 542.70