The tool generates a spreadsheet like Azure-Quote-Tool-20190222.xlsx

Unofficial tool for an estimation on Azure VM migration projects. It generates a spreadsheet for performing calculations

For creating a new spreadsheet:

#ONLY IF YOU HAD NOT INSTALLED PIP3 AND THE XLSWRITER LIBRARY
$ sudo apt install -y python3-pip
$ pip3 install xlsxwriter

#COMMAND REQUIRED FOR CREATING A SPREADSHEET
# python3 xlsGenerator.py [nameOfOutputXLSFile]
$ python3 xlsGenerator.py Azure-Quote-Tool-$(date +%d%m%y).xlsx
$ ls -1
Azure-Quote-Tool-020618.xlsx

It works for Excel 2016 and beyond

• This is a unofficial tool for providing a first order estimation on Azure migration projects

• It contains Azure pricing information read from Azure pricing APIs at the day of the spreadsheet creation

• The tool consider IaaS projects and estimates compute, storage and ASR costs

• Managed Disks for OS and data drives
• Premium or Standard Managed Disk for OS and data drives
  • OS Disk sizes limited to P4, P4, P10, S4, S6 or S10
• ASR Costs per VM
• ASR Disk duplication costs
• PAYG(hour), 3 or 1 year Reserved Instance pricing models
• VMs certified for SAP NetWeaver loads
• VMs equipped with GPU cards
• Usage of burstable VMs
• Percent performance improvement in Azure
  • If I input 20% performance win per CPU and memory on Azure, a VM request for 100 GB RAM will look VMs sizes starting at 80 GB
• Selection based on CPU and Memory or just Memory

• VPN or Express Route (ER) Gateway costs
• If ER is used, the cost of the ER circuit in Azure and telco costs
• Outgoing bandwidth costs
• VM Backups
• Cost for services other than compute, managed disks and ASR