Parameters¶

From an Excel spreadsheet there are some basic parameters to generate the query. If you change any of the parameters, the system will update data bindings, and refresh the data, in other words, the data will also change.

.jpg)

Figure 21. Parameters on a Refreshable Nutrition Workbook

Enable Macros if these are disabled, otherwise nothing will work. Click on Options and select ‘Enable this content’

• Server: there are different servers. At the moment this is the draft server because the other one has no nutrition data.

• Country: is the one parameter that users will change. If you type in the country name it will approve the database to get that data

• Dates: Both fields in blank will tell the system to use all the available data.

• Start Date: if you need recent data and you set the start date for later, the system will take less time to refresh/download the data into the spreadsheet. It should not take more than 5 minutes.

• End date: if you are interested in a certain period, 2-3 years, then you can pick an end date.

• The Data Domain will always be nutrition

• Token number is used to authenticate and everyone will have one.

• Data URL: It builds the URL automatically