@Kim_Bottu … Virtually Gung Ho
I have created an excel table to calculate cluster sizes based on some variables. Take note that all values in black are VARIABLES (A total of 19 variables can be adjusted). Changing any of them will change the recommendations in the top and throughout the whole table. This is a work in progress though, potentially storage recommendations will be made as well. Check regularly to see new updates.
I have used a small trick to calculate the impact of sharing CPUs (vCPU to pCPU ratio). First I calculate the total amount (peak or average) of CPU usage in MHz and I divide that value that potentially can be the vCPU to pCPU ratio. It is not completely exact and if someone has a better idea, please let me know.
The clever thing in this table is that when the PEAK or AVG CPU load (which ever value you decide to use for your calculation, I have only one field for this) go up, the vCPU to pCPU ratio will go down and you will need more hosts. If on the contrary the PEAK or AVG CPU load goes down, the CPU consolidation Ratio line will show you a higher consolidation ratio and the table will show you when you need more or less hosts for the workloads you want to support.
Feel free to have a look and use this xls file.
Sincere thanks to Ariel Sanchez, Ahmed Ragab and Richard Diaz for their willingness to review this spreadsheet.
Also have a look at Josh Odgers wonderfull online cluster calculator: http://www.joshodgers.com/vsphere-cluster-sizing-calculator/