I'm working with a large Excel sheet that contains details for resources across various AWS services, and I'm looking for a more efficient way to generate estimates and export them using the AWS calculator. Is it possible to automate this process with a script or something similar? Any insights or suggestions would be greatly appreciated!
5 Answers
There are definitely ways to approach this! For instance, I've reverse-engineered some calculations and even built a free API for AWS pricing. While it won't cover every service out there, it's a good starting point. You can check it out here: https://zmynx.github.io/aws-lambda-calculator/. There are other projects out there that might help too!
If you're seeking real customization, AWS does have a pricing API that can pull data for all services in different regions. It's straightforward to use, but I have to warn you, the documentation is pretty rough—especially when dealing with SKUs. Here's the link to check it out: https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/price-changes.html.
I've found that you can bulk import estimates for EC2 and EBS into the AWS calculator, but unfortunately, this doesn't extend to all resources. I'd love to know if anyone else has found automation tools to ease this process since navigating the calculator can be a real hassle.
I had decent luck using ChatGPT in Agent Mode! You can describe your architecture, and it can guide you through the AWS Calculator step by step in a browser. It might save you some time!
I haven't exactly found a method to do everything programmatically, but I did create a spreadsheet using numpy that aligns with the AWS calculator format and then imported that. Might be a solid workaround for now!

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