The only required setting in the range is region. The generic function for computing storage cost accepts an optional settings range, similar to the EC2 functions above.

Lastly, EBS snapshot usage cost can be computed. Provisioned IOPS cost can be computed with the _IOPS() functions. The storage functions end in _GB() and compute the cost based on total number of Gigabytes consumed. You can compute the cost of EBS storage and provisioned IOPS with the EC2_EBS_*() functions. The price is the effective hourly rate when using reserved instances. Prices are currently returned in hourly durations. Where sqlLicense is either web, std, or enterprise and platform is either LINUX or WINDOWS. They follow the form:ĮC2_MSSQL_RI_(instanceType, region, sqlLicense, purchaseTerm) There are also several alias functions that encode the pricing details in the function name.

EC2_RI(instanceType, region, platform, offeringClass, purchaseTerm, paymentOption).

The simplest EC2 RI function requires multiple parameters to specify all the RI pricing details:

EC2_WINDOWS_MSSQL_OD(instanceType, region, sqlLicense).

EC2_LINUX_MSSQL_OD(instanceType, region, sqlLicense).

To explicitly grab on-demand pricing use these functions: This will popup a dialog to configure and generate a new sheet and a named settings range. Find the 'AWS Pricing' menu under the 'Add-ons' top-level menu and select 'New settings sheet'. The add-on provides an easy way to configure and generate a named range of configuration settings.

If the purchase_type is reserved, you must also specify the following parameters: The supported property names and the supported values match the parameters defined earlier. EC2(settingsRange, instanceType, region: optional): ( region is optional and overrides settingsRange).This approach makes it simple to define per-environment or per-organization pricing policy defaults and reference them per unique instance type. The range must be a 2 column x N row selection, where the first column in the row is the property name and the second column in the row is the property value. The range may be an explicit one from the sheet, eg A1:B4 or it may reference a named range. To minimize the repetition of standard instance pricing details, the EC2() function accepts a range parameter that points to pre-configured instance properties. paymentOption: payment option of reserved instance, either no_upfront, partial_upfront, or all_upfront.purchaseTerm: duration of reserved instance purchase in years, either 1 or 3.offeringClass: type of reserved instance, either standard or convertible.sqlLicense: name of MSSQL license, either: std, web, or enterprise.platform: name of OS platform, currently supports: linux, windows, rhel, suse, linux_std (Linux SQL Standard), linux_web (Linux SQL Web), linux_enterprise (Linux SQL Enterprise), windows_std (Windows SQL Std), windows_web (Windows SQL Web), windows_enterprise (Windows SQL Enterprise).purchaseType: name of the purchasing type, either ondemand or reserved.region: name of AWS region, eg us-east-1 and eu-west-1.instanceType: name of instance represented as.

These define the parameters used in the following functions and instance settings. All the functions here include parameter documentation that will appear when you've selected a particular function and help describe the order of parameters.įunctions are documented here without the required leading ' =' for ease of reading. Oftentimes the sheets editor will popup a command completion dialog that searches as you type. To invoke a custom function (or any function), start by typing a ' =' followed by the name of the function. This addon supplies multiple custom functions that you can invoke from a Google Sheets cell. Pricing options support on-demand and reserved purchasing. EBS storage, Provisioned IOPS and snapshots.EC2 instances (Linux, RHEL, SUSE and Windows).The following services are currently supported with more to come: Add the AWS Pricing addon to your Google Sheets document.

Ec2 pricing