When it comes to sizing customer environments who are looking to migrate from on-premises into VMware Cloud on AWS we always use the VMC Sizer website. The tool allows us to input and modify various parameters to correctly size the environment. Basic values that we need to gather from customers to size the environment are:
Number of VMs
Storage per VM
vCPU per VM
vRAM per VM
Once you click Upload the tool will analyse the spreadsheet and fill in the correct values based on the extract:
No need to manipulate the data to find the average VM size anymore. If you want to perform multiple sizing based on different clusters then simply just filter the data and copy/paste to a new .xlsx file and upload it individually.