I'm working with a large Excel sheet that contains details about various AWS resources and I need to generate a price estimate using the AWS calculator. Manually doing this is quite tedious, so I'm wondering if there's a way to automate the process with a script or program. Is it even possible to create these estimates programmatically?
6 Answers
Yes, it's definitely possible! Some developers have reverse-engineered the AWS calculator and created APIs for it. One example is a free API for price calculations that you can explore. Just keep in mind that support for all services may vary, so it's wise to check if your needed configurations are covered.
I had some luck using ChatGPT in Agent Mode. You provide your architecture details, and it can automate the clicking process on the AWS Calculator for you!
While you can bulk import pricing for EC2 and EBS resources in the AWS calculator, automation for other resources isn’t supported. Manipulating the calculator can be a pain, but there are people out there looking for solutions too!
If you have a Technical Account Manager (TAM), they might be able to provide you with tools or guidance specific to your needs.
I've found success using NumPy to create a spreadsheet that aligns with the AWS calculator template, which I then import. However, I haven’t figured out a full automation process just yet.
For a more hardcore approach, AWS does have a pricing API that allows you to access the prices of services across regions. The documentation isn't stellar, so be prepared for some trial and error with the API.
Related Questions
How To: Running Codex CLI on Windows with Azure OpenAI
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically