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 Formula error - t2.nano RI in us-east-1 #37

Closed reganbrianpatrick closed 1 year ago

reganbrianpatrick commented 1 year ago

This issue was originally raised in our slack community.

This formula is no longer working: =AWS_EC2(“reserved”, “t2.nano”, “us-east-1”, “linux”, “convertible”, “3yr”, “no_upfront”)

We will add notes to the issue when we have an idea of what caused this and what the path to resolution is.

reganbrianpatrick commented 1 year ago

The issue looks to be the types of quotes (“ instead of ") used in the formula - meaning this is an issue using Google Sheets rather than with the AWS Pricing plugin.

When this formula is executed, there is an error: =AWS_EC2(“reserved”, “t2.nano”, “us-east-1”, “linux”, “convertible”, “3yr”, “no_upfront”)

When this formula is executed, we get the correct result of $0.0029: =AWS_EC2("reserved", "t2.nano", "us-east-1", "linux", "convertible", "3yr", "no_upfront")