Spreadsheet: 113305d1309265419-how-can-i-nest-more-than-seven-functions-in-ms-excel-travel-budget-template-by-aak
Sheet: Travel Expenses

 | DASHBOARD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Currency |  |  |  |  |  |  |  |  |  | Currency Rates Provided by MSN Money
 |  | Country | Forecasted Expenses |  | Country Target In $ |  |  | Allocation in $ | Allocation % |  |  | Nights Spent |  | Days Spent | Time Allocation | Total Working Days |  | % Travelling |  | Country | FX to $ |  |  |  |  |  |  |  |  | Click here to visit MSN Money
 |  | Algeria | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A | 240 |  | 0 |  | US | $ | 1
 |  | Angola | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | Europe | € | 1.4221 |  |  |  |  |  |  |  | Name | In US$ | Per US$
 |  | Bahrain | 0 |  | 50000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | UK | [NAME] | 1.5967 |  |  |  |  |  |  |  | Argentine Peso to US Dollar | 0.24372 | 4.103
 |  | Egypt | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | UAE | AED | 0.27221 |  |  |  |  |  |  |  | Australian Dollar to US Dollar | 1.0421 | 0.96
 |  | Ethiopia | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | Qatar | QAR | 0.27221 |  |  |  |  |  |  |  | Bahraini Dinar to US Dollar | 2.6497 | 0.377
 |  | Jordan | 0 |  | 125000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | Egypt | EGP | 0.16756 |  |  |  |  |  |  |  | [NAME] to US Dollar | 0.14245 | 7.02
 |  | Kenya | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | KSA | SAR | 0.01155 |  |  |  |  |  |  |  | Brazilian Real to US Dollar | 0.6227 | 1.606
 |  | Kuwait | 0 |  | 500000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | Bahrain | BD | 2.6497 |  |  |  |  |  |  |  | British Pound to US Dollar | 1.5967 | 0.626
 |  | Lebanon | 0 |  | 625000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | Oman | OMR | 2.5967 |  |  |  |  |  |  |  | Canadian Dollar to US Dollar | 1.0112 | 0.989
 |  | Libya | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | Jordan | [NAME] | 1.4088 |  |  |  |  |  |  |  | Chile Peso to US Dollar | 0.00211 | 474.8
 |  | Morocco | 0 |  | 400000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  | Kuwait | KD | 3.6291 |  |  |  |  |  |  |  | Chinese Yuan to US Dollar | 0.15405 | 6.492
 |  | Nigeria | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Colombian Peso to US Dollar | 0.00056 | 1789
 |  | Oman | 0 |  | 150000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to US Dollar | 0.05815 | 17.198
 |  | Qatar | 0 |  | 1510000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to US Dollar | 0.19074 | 5.243
 |  | South Africa | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Euro to US Dollar | 1.4221 | 0.703
 |  | Tunisia | 0 |  | 0.1 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Egyptian Pound* to US Dollar | 0.16756 | 5.968
 |  | UAE | 0 |  | 1340000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hong Kong Dollar to US Dollar | 0.1284 | 7.788
 |  | KSA | 0 |  | 7300000 |  |  | 0 | 0 |  |  | 0 |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to US Dollar | 0.00529 | 188.9
 | Total Travel Expenses |  | 0 | Total Sales Target | 12000000.9 |  |  |  | 0 |  | Total Time Spent | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] to US Dollar | 0.02219 | 45.06
 | Expenses /Country |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indonesia Rupiah to US Dollar | 0.00012 | 8625
 | Country | Month | Hotel Rate/per night | Currency | Stay Duration (Number of night) |  | Number of days | Air Fare | Currency |  | Visa fees | Currency |  | Car Rent | Currency | Car Rent duration in days |  | Total Cost in $ |  |  |  |  | Country | Month |  |  |  |  |  | [NAME] to US Dollar | 0.01235 | 80.98
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Algeria | Jan |  |  |  |  |  | Jordanian Dinar to US Dollar | 1.4088 | 0.71
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Angola | Feb |  |  |  |  |  | [NAME] to US Dollar | 0.01101 | 90.83
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Bahrain | Mar |  |  |  |  |  | South Korean Won to US Dollar | 0.00092 | 1085
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Egypt | Apr |  |  |  |  |  | Kuwaiti Dinar to US Dollar | 3.6291 | 0.276
 |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Ethiopia | May |  |  |  |  |  | [NAME] to US Dollar | 0.12587 | 7.945
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Jordan | Jun |  |  |  |  |  | Malaysian Ringgit to US Dollar | 0.3269 | 3.059
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Kenya | Jul |  |  |  |  |  | Mexican Peso to US Dollar | 0.08409 | 11.892
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Kuwait | Aug |  |  |  |  |  | Norwegian Krone to US Dollar | 0.1823 | 5.486
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Lebanon | Sep |  |  |  |  |  | Omani Rial to US Dollar | 2.5967 | 0.385
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Libya | Oct |  |  |  |  |  | [NAME] to US Dollar | 0.3614 | 2.767
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Morocco | Nov |  |  |  |  |  | Philippine Peso to US Dollar | 0.02289 | 43.68
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Nigeria | Dec |  |  |  |  |  | [NAME] to US Dollar | 0.01155 | 86.55
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Oman |  |  |  |  |  |  | Saudi Riyal to US Dollar | 0.26662 | 3.751
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Qatar |  |  |  |  |  |  | Singapore Dollar to US Dollar | 0.80373 | 1.244
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | South Africa |  |  |  |  |  |  | South African Rand to US Dollar | 0.14535 | 6.88
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | Tunisia |  |  |  |  |  |  | Swedish Krona to US Dollar | 0.15462 | 6.467
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | UAE |  |  |  |  |  |  | Swiss Franc to US Dollar | 1.1986 | 0.834
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  | KSA |  |  |  |  |  |  | Taiwan Dollar to US Dollar | 0.03442 | 29.05
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Thai Baht to US Dollar | 0.03234 | 30.92
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Tunisian Dinar to US Dollar | 0.72343 | 1.382
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] to US Dollar | 0.27221 | 3.674
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | United States Dollar | 1 | 1
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | [NAME] to US Dollar | 0.23283 | 4.295
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | MSN Money |  | Microsoft Office Update
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Discover Investor's tools, columns, and more! |  | Get the latest from Microsoft Office
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Privacy
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Legal
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | Advertise
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | MSN Worldwide
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | About our ads
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | © 2011 Microsoft
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0
 |  |  |  |  |  | 0 | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 | 0