Stats

Setup

1. Install the Cryptosheets add-in from Microsoft [AppSource Store](https://appsource.microsoft.com/en-us/product/office/WA104381695?src=intercom-Smartable Coronavirus API)

2. Make sure you are logged into your Cryptosheets account

   

Using the console

1. From the Cryptosheets ribbon click data
2. Type in type in "Smartable Coronavirus API..." then click on Stats
3. Scroll through the console parameters and input your values
4. Select the cell you want to place the data into
5. Click make request

Using custom functions

1. In any cell type the following: =CS.QUERY("Smartable Coronavirus API","Stats",{"Subscription-Key","Your Subscription-Key";"location","CA"})
2. In any console, after selecting the parameters to configure the query string as desired, simply click the radio button to toggle the the function/formula builder, then click the clipboard icon to copy the full formula string and paste it into any cell see detailed examples and tutorial

Hint: If you need help remembering the exact parameters for any function, you can always just type in any cell: =CS.PARAMETERS("Smartable Coronavirus API","Stats")

Using templates

1. From the Cryptosheets ribbon click templates OR click on the templates tab in the browse section
2. Load the template called Query Builder and type Smartable Coronavirus API and Stats
3. You can also try searching "Smartable Coronavirus API..." for other templates specific or related to Get Gains