{"id":5601,"date":"2015-08-28T12:01:32","date_gmt":"2015-08-28T11:01:32","guid":{"rendered":"https:\/\/help.instantatlas.com\/dashboard-builder-desktop\/desktop-user-guide\/the-instantatlas-election-template\/data-preparation\/"},"modified":"2015-09-29T13:16:52","modified_gmt":"2015-09-29T12:16:52","slug":"data-preparation","status":"publish","type":"page","link":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/en\/welcome\/desktop-user-guide\/the-instantatlas-election-template\/data-preparation\/","title":{"rendered":"Data Preparation"},"content":{"rendered":"

The required data structure is represented below, and an example workbook containing fictitious election results has been included in the \u2018iadatasheet\u2019 worksheet of the workbook named IAworkbookElectionResults.xls. This file is found in the \u2018workbooks\u2019 subfolder of your installation folder of InstantAtlas.<\/p>\n

\"image231\"<\/a><\/span><\/p>\n

The data in the iadatasheet of the example workbook provided is divided into two themes containing a number of indicators and associates. These are discussed below in detail, in reference to the example workbook, to help you create your own election results workbook.<\/p>\n

Theme 1<\/span><\/h2>\n

theme (row 1, merged across Column C to K) contains a number of indicators that contain all data except for the breakdown of election results. It is named \u2018Electoral Area Details\u2019 in the example workbook, as shown below.<\/p>\n

\"image232\"<\/a><\/span><\/p>\n

Theme 1, Indicator 1<\/h3>\n

This indicator (row 2, merged across Column C to F) contains data populating three areas of the report: the \u2018Winning Party\u2019 shown in the first theme of the Spine Chart; the winning parties shown in the Table below the Map; and all of the Comparison Table at the top-right of the report. This indicator is named \u2018Winning Party\u2019 in the example workbook.<\/p>\n

The indicator type is designated \u2018categoric\u2019 in cell C4, and associates are assigned in cell D5 as \u2018seats\u2019, in cell E5 as \u2018voteCount\u2019, and in cell F5 as \u2018votePercent\u2019.<\/p>\n

For the \u2018Winning Party\u2019 and \u2018Name\u2019 lines of the first theme of the Spine Chart and all of the data shown in the Table below the Map, displayed values are taken from text entered in Column C. Note that no associate values are displayed for those two areas.<\/p>\n

The Comparison Table data is set up slightly differently. Comparison data codes are entered in Column A but preceded with hash symbols, as shown in cells A80-A86 in\u00a0the screen shot\u00a0above. Enter each party name as it will appear in the Comparison Table of the report in Column B, next to its code. Note that no indicator value is given in column C. Instead, the data for the Comparison Table is taken from the associate columns (D to F). Accordingly, the total won seats are given as values in column D, the numbers of votes are given in column E, and the percentages of votes won are given in column F.<\/p>\n

Theme 1, Indicators 2-6<\/h3>\n

Cells G2, H2, I2, J2, and K2 contain indicators 2-6 of Theme 1. These indicators have been assigned as \u2018Name\u2019, \u2018Eligible Voters\u2019, \u2018Total Votes\u2019, \u2018Turnout %\u2019, and \u2018Seats\u2019 in the example workbook. This data is displayed in the first theme of the Spine Chart.<\/p>\n

Theme 2<\/span><\/h2>\n

The second theme is the breakdown of an election. This theme provides the data shown in the second theme of the Spine Chart.<\/p>\n

The indicator type is categoric and the value is the name of a candidate. The number of indicators in this theme depends on the maximum number of candidates that stood for an election in the area(s) displayed in the Map. Stars have been added to winning candidates\u2019 names and associate values for \u2018Votes\u2019, \u2018Party\u2019 and \u2018Percentage of Vote\u2019 have been included, as shown below.<\/p>\n

\"image233\"<\/a><\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

The required data structure is represented below, and an example workbook containing fictitious election results has been included in the \u2018iadatasheet\u2019 worksheet of the workbook named IAworkbookElectionResults.xls. This file is found in the \u2018workbooks\u2019 subfolder of your installation folder of InstantAtlas. The data in the iadatasheet of the example workbook provided is divided into two … Continue reading Data Preparation<\/span><\/a><\/p>\n","protected":false},"author":41,"featured_media":0,"parent":5571,"menu_order":1,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-5601","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5601","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\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/comments?post=5601"}],"version-history":[{"count":0,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5601\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/pages\/5571"}],"wp:attachment":[{"href":"https:\/\/help.instantatlas.com\/instantatlas-desktop\/wp-json\/wp\/v2\/media?parent=5601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}