ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for using this workbook:
2
1If not already enabled, enable macros in Excel and then close and reopen this workbook; link to instructions below.
3
https://support.microsoft.com/en-us/office/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6
4
5
2Export map data from DRA (choose "Precinct Assignment (as .csv)") - result should be a file with two attributes: 'GEOID20' and 'District'; link to instructions below.
6
https://medium.com/dra-2020/exporting-maps-f8b2097579d2
7
8
3Delete old 'GEOID20' and 'District' attribute data from the corresponding columns in the 'Map Data Input' worksheet.
9
10
4In the 'Map Input Data' worksheet, paste the exported map data, with exception of the attribute headings, into the corresponding columns, and enter applicable metrics from DRA into the corresponding cells (cells highlighted blue are protected and automatically filled/calculated).
11
12
5Review the analysis results in the 'Summary' worksheet. If interested in a specific metric, click on it's corresponding worksheet to view a description of the evaluation/calculation and detailed results. Attributes can be moved in and out of pivot tables for analysis; return the pivot table to its original configuration when finished to ensure results are reporting correctly.
13
14
NOTE: the following worksheets are either fully or partially 'protected' to disallow user input.
Partially protected worksheets: 'Map Data Input'.
Fully protected worksheets: 'README', 'Summary', 'Map Data Checks', 'Database', 'Database Dictionary'.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100