Calculations of Cloud Health Spend

 

VMware Currencies

  • Based on VMware Price List currencies

 

Cloud Spend Currencies

  • Based on the current billing currencies offered by AWS & Azure. CNY is also included.

 

FX-rate Source Oanda

  • Free and publicly available source for FX-rate data
  • “The FX-rates are calculated taking the average from all collected data over a 24-hour period, reflecting the fact that the foreign exchange market never really "closes" on a global basis. However, market activity is lower on weekends and holidays, so the number of prices varies from day to day. Our Rates are rounded to up to five significant digits, with a few exceptions.” (For further information please visit https://www.oanda.com/currency/help/how-to-read-currency-conversion-results)

 

FX-rate Schedule

  • Reference date is the first day of the calendar month prior to the start of each VMware fiscal quarter
  • Previous full day Oanda Ask Price used
  • If FX-rate changes by less than 5% then there will be no update to the FX-rate. If the FX-rate change is greater or equal to 5% then the FX-rate will be updated using the “Previous full day Oanda Ask Price”

 Compared to July 1st 2019, six currencies required updates and therefore 31 FX-rates were changed as of April 1st 2020.

 

Oanda ASK Price Threshold
Jan 1 2021 USD EUR JPY GBP AUD CNY
Cloud Spend Currencies USD 1.0000 1.2219 0.0097 1.3669 0.7694 0.1531
EUR 0.8189 1.0000 0.0079 1.1057 0.6149 0.1269
JPY 103.339 123.9432 1.0000 139.9591 79.5 15.14
GBP 0.7319 0.9046 0.0071 1.0000 0.5562 0.114
AUD 1.3002 1.6266 0.0126 1.7986 1.0000 0.2049
CNY 6.5316 7.8889 0.0661 8.7648 4.8845 1.0000
ARS 84.5643 103.3291 0.8187 115.5876 65.0638 12.9509
BRL 5.1952 6.6101 0.0503 7.263 4.0441 0.8292
CAD 1.2736 1.555 0.0123 1.7402 0.9382 0.1999
CHF 0.9191 1.0582 0.009 1.1763 0.6542 0.134
DKK 6.0938 7.4682 0.0601 8.2412 4.5831 0.9475
HKD 7.8326 9.1018 0.0715 10.5973 5.9652 1.1391
IDR 14406.8422
17453.8888
140.8328
19177.8769
10888.6577
2189.5327
INR 75.7676 89.3661 0.7056 99.968 56.2716 10.6802
KRW 1087.249 1350.191 10.5255 1532.8553
831.078 173.5728
MXN 19.9058 24.3229 0.1927 28.3089 15.8097 3.0485
MYR 4.025 4.7437 0.0405 5.2763 2.9624 0.6015
NOK 8.5929 10.7488 0.0832 11.8852 6.6096 1.3537
NZD 1.3927 1.7384 0.0135 1.922 1.05 0.2189
RUB 77.4287 90.928 0.7337 99.9093 55.6307 11.4066
SAR 3.7465 4.5904 0.0364 5.135 2.8905 0.5753
SEK 8.2377 10.0629 0.0797 11.2598 6.4418 1.316
TRY 7.7439 9.094 0.0734 9.9922 5.5638 1.1408
TWD 28.9009 33.222 0.2796 36.6128 21.6211 4.1701
ZAR 14.7015 17.9638 0.1423 20.0949 11.8893 2.2515