\n<\/strong><\/p>\n
Open Excel. Click the \u2018File\u2019 tab in the ribbon and select \u2018Options\u2019 in the left hand menu.<\/p>\n
This should launch the Excel Options Window. In the left hand pane, choose Add-ins which will bring up the list of installed add-ins and whether they are active (enabled) or not.<\/p>\n
Initially the IA Data Manager may be in the list but it will not be active. To activate it, click the \u2018Go\u2019 button at the bottom of the add-in screen in order to start managing your add-ins.<\/p>\n
If the IA Data Manager is not present in the Add-Ins dialog, click \u2018Browse…\u2019 and browse to the file called \u2018IA Data Manager.xla\u2019 which is located in the root folder of the InstantAtlas Desktop installation, usually \u2018C:\\Program Files\\EsriUK\\InstantAtlas\u2019, and click OK. It will now be available in the list of Add-Ins.<\/p>\n
Select the InstantAtlas Data Manager from the checklist and click \u2018OK\u2019.<\/p>\n
If you have multiple versions of the add-in available because you have upgraded from a previous version of InstantAtlas, please ensure that the most recent version has been enabled.<\/p>\n You will now need to close and then reopen Excel.<\/p>\n The add-ins tab should now display three new buttons. There is also a menu item called InstantAtlas from which these functions can also be selected.<\/p>\n The Excel add-in is used in conjunction with any workbook in which you enter your data. An example workbook has been provided with your InstantAtlas software. Use the InstantAtlas Excel Data Manager shortcut created in the Windows Start menu to open the workbook. Alternatively, you can browse to the \u2018IAworkbook.xls\u2019 file created during installation, the default location of which is C:\\Program Files\\EsriUK\\InstantAtlas\\workbooks\\. Click on the name of the \u2018Example 1 iadatasheet\u2019 worksheet at the bottom of the screen.<\/p>\n You will see that columns A and B contain codes and names identifying each of the post code sectors. Columns C onwards contain data values. Data must be organised using three levels in InstantAtlas reports: theme, indicator and time period. You can see that in this datasheet there are two themes (Theme 1 and Theme 2). Theme 1 contains two indicators (Indicator 1 and Indicator 2) and Theme 2 also contains two indicators (Indicator 3 and Indicator 4). Each indicator has two time periods.<\/p>\n Change the value in cell C1 from \u2018Theme 1\u2019 to \u2018Social deprivation\u2019. Change the value in cell C2 from \u2018Indicator 1\u2019 to \u2018% of population unemployed\u2019. Change the value in cell E2 from \u2018Indicator 2\u2019 to \u2018% of population receiving incapacity benefit\u2019. You can replace some of the data values below with your own values if you wish.<\/p>\n Now that you have created some of your own theme and indicator names, you can update the report with this data.<\/p>\n To use the Excel Data Manager add-in you must have at least one active datasheet in your workbook. A worksheet becomes an active datasheet when its name starts with \u2018iadatasheet\u2019. To rename the worksheet \u2018Example 1 iadatasheet\u2019 in Excel, you simply right click on the worksheet name and select \u2018Rename\u2019.<\/p>\n Click the \u2018InstantAtlas\u2019 menu in Excel and then click \u2018Export Data File\u2019. Alternatively click the \u2018IA Export\u2019 button in the InstantAtlas toolbar. A dialog box will open in which you are asked to select the file type. Data files for HTML dynamic reports need to be in JSON format. The option to export to XML format exists for debugging purposes, as the XML format is more human-readable<\/span>. Please select the JSON option.<\/p>\n Please also ensure that the option ‘Generate data file for local atlas’ is ticked. This will ensure that the local file variant of the data.js file called data-vars.js.js is also updated.<\/p>\n Click OK. You will be prompted to browse for a destination folder.<\/p>\n Browse to your report folder (i.e. C:\\demo) and click \u2018Save\u2019.<\/p>\n If your InstantAtlas report is still open, click the \u2018Refresh\u2019 button in the browser to restart the report. If the report is not open, browse to the report folder and double click the \u2018atlas.html\u2019 file to start it. The report should now look similar to this:<\/p>\n Click the \u2018Data\u2019 button (top left). You will see that the theme and indicator names that you entered into the Excel workbook are displayed.<\/p>\n","protected":false},"excerpt":{"rendered":" After a report has been newly published, the data values that are being displayed in the report are example values generated by the Publisher. You can use the InstantAtlas Excel Data Manager to create a JSON data file that contains your own values. To do this, follow the steps below. You can close the InstantAtlas … Continue reading Changing the Data<\/span><\/a><\/p>\n","protected":false},"author":22,"featured_media":0,"parent":331,"menu_order":4,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-821","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/821","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/comments?post=821"}],"version-history":[{"count":0,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/821\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/331"}],"wp:attachment":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/media?parent=821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-content\/uploads\/sites\/31\/2021\/12\/Exceladdin6120.png\")
<\/a><\/p>\n<\/a><\/p>\nCreating Some New Data<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\nUpdating the Report<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\n\u00a0You should not change the filename away from \u2018data.js\u2019.<\/p>\n<\/a><\/p>\n