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
Oct 1 2020 USD EUR JPY GBP AUD CNY
Cloud Spend Currencies USD 1.0000
1.1470
0.0091
1.2757
0.6910
0.1454
EUR 0.8725
1.0000
0.0085
1.1057
0.6149
0.1269
JPY 109.6443
123.9432
1.0000
139.9591
74.3257
15.1400
GBP 0.7842
0.9046
0.0075
1.0000
0.5562
0.1140
AUD 1.4475
1.6266
0.0135 1.7986
1.0000
0.2049
CNY 6.8781
7.8889
0.0661
8.7648
4.8845
1.0000
ARS 76.1914
89.4750
0.7220
98.3128
54.7417
11.2243
BRL 5.6287
6.6101 
0.0533
7.2630
4.0441
0.8292
CAD 1.3641
1.5550
0.0132
1.7402
0.9382
0.1999
CHF 0.9191
1.0582
0.0090
1.1763
0.6542
0.1340
DKK 6.5152
7.4682
0.0601
8.2412
4.5831
0.9475 
HKD 7.8326
9.1018
0.0715
9.9924
5.3556
1.1391
IDR 14406.8422
17453.8888
140.8328
19177.8769
10208.1879
2189.5327
INR 75.7676
84.6653
0.7056
94.6228
52.0568
10.6802
KRW 1164.2429
1350.1909
11.4667
1532.8553
831.0780
173.5728
MXN 22.8801
26.4674
0.2127
28.3089
15.8097
3.2320 
MYR 4.3463
4.7437
0.0405
5.2763
2.9624
0.6015
NOK 9.5656
10.7488
0.0889
11.8852
6.6096
1.3537
NZD 1.5469
1.7384
0.0144
1.9220
1.0500
0.2189
RUB 77.4287
90.9280
0.7337
99.9093
55.6307
11.4066 
SAR 3.7465
4.2938
0.0342
4.7774
2.5934
0.5447
SEK 9.3227
10.9656
0.0867
12.1293 6.4418
1.3160
TRY 7.7439
9.0940
0.0734
9.9922 
5.5638
1.1408
TWD 28.9009
33.2220
0.2796
36.6128
20.3612
4.1701
ZAR 16.6512
19.7968
0.1578
22.3651
11.8893
2.5450