search

getstrake / aws-pricing-sheets-addon

Google Sheets add-on for AWS Pricing
https://workspace.google.com/marketplace/app/aws_pricing_by_strake/378787760903
33 stars 0 forks source link

EC2_OD not working for RedHat #15

Closed Tawha closed 1 year ago

Tawha commented 2 years ago

=EC2_OD("c5.24xlarge", "af-south-1", "rhel") is giving me following error

"Found too many instances that matched c5.24xlarge (line 52)."

Same error for =EC2_RHEL_OD("c5.24xlarge", "af-south-1")

mheffner commented 2 years ago

Thanks for the report @Tawha. I believe what is happening is that the announcement of RHEL Microsoft SQL server has created multiple SKUs for RHEL now. We likely need to expand the platform option to include a rhel_std, rhel_web, etc.

Tawha commented 2 years ago

When is it going to be ready approx ? I was looking to pul this data for RHEL

mheffner commented 2 years ago

Unfortunately I don't have a lot of availability at the moment to add this support. If you are looking for a project it likely wouldn't be too difficult to follow the existing code and add the support in. I'd be open to reviewing a PR.

reganbrianpatrick commented 1 year ago

@Tawha this has been fixed in the new version of the add-on: AWS Pricing by Strake. The formulas have been updated, so here is the formula you can use to get the same price:

=AWS_EC2("ondemand","c5.24xlarge", "af-south-1", "rhel")

Please let us know if there is anything else we can help with!