Hello, wondering if anyone is aware of a framework or script that can do something similar:

we have about 60 ec2 instances across 4 AWS regions, and I'm in process of figuring out the overall costs per instance OnDemand vs Reserved

I put toghether a spreadsheet showing 1Y seat vs 3Year seat cost difference + expiration for each seat

this is a list of each ec2 instance, its type, current OnDemand cost per hour, month, year vs 1Y and 3Y seats

is there any framework or script that can automate this kind of book keeping, basically query my ec2 instances, get each ones size, query the price for that size (on demand, 1Y, 3Y pricing) and generate a similar spreadsheet + if check if I have a seat applied to the instance and get its expiration

was gona script this via python + awscli but dont want to reinvent the wheel is something like this is available.

thanks