About this template
Check vCPU-to-thread ratio, RAM commitment and thin-provisioned storage before you add the next VM.
What you get: Excel planner (example + blank): host hardware, N+1 node-loss option, 80 guest rows with qty and running flag, vCPU per thread/core, RAM ratio, provisioned vs used disk, status flags against YOUR limits, and how many more guests of a chosen size fit; 15 built-in tests.
Who it is for: Proxmox VE, ESXi, Hyper-V or KVM homelab owners and students learning capacity planning.
Files:
- `virtualization-resource-planner-BLANK.xlsx`
- `virtualization-resource-planner-EXAMPLE.xlsx`
How to use: open the EXAMPLE file first to see every formula working (yellow cells = your inputs, blue-grey = formulas); then use the BLANK file for your own data. See Start_here sheet / included notes. Test examples are in the Tests sheet or `--selftest` where included.
What it is NOT: Not a monitoring tool; it does not read your hypervisor. Default limits are adjustable starting values, not Proxmox rules.
Questions
What file types do I get?
One Excel (.xlsx) planner, delivered as two files: an EXAMPLE workbook and a BLANK workbook. The download also includes README.md and SOURCES.md.
Can I edit the formulas and limits?
Yes. Yellow cells are your inputs and blue-grey cells are formulas. The status flags are checked against your own limits, and the default limits can be changed.
How do I start?
Open the EXAMPLE file first to see every formula working. Then use the BLANK file for your own data, and see the Start_here sheet for notes. The workbook also has 15 built-in tests.
