Arena Snapshot - [TEMPLATE]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGH
1
2
Arena Snapshot Quick Guide
3
4
5
The Snapshot spreadsheet is a dynamic tool designed to synthesize all available data related to a campaign. This information can include, but is not limited to the current number of registered voters, past and future (modeled) turnout levels, partisan support breakdown, and previous election results in a given political geography.
6
7
8
9
The Snapshot calculates what would happen if the election were held today and estimates how far you are from achieving 51% of the vote in a district.
10
11
12
In addition to understanding how many votes stand between you and victory, the Snapshot allows you to simulate the effects of a targeted, programmatic campaign on the electorate.
13
14
15
For more information on how to use a snapshot see our guide.
16
17
How It Works
18
19
The data in this template is just example data. Upload data from your VAN or voterfile to the Arena Snapshot PivotTable Excel (link below) sheet to update this template with information for the desired district.

Once your update the Arena Snapshot PivotTable Excel doc use the numbers from this document to update the District Overview tab of this Google Sheets document.

Links below go into detail about how to update this document with your own data.
20
21
22
23
24
25
How-to Build Your Own Snapshot
26
Pivot Excel Workbook
27
28
Copying This Workbook
29
30
< File
31
<Make copy
32
<Rename & select your personal Google Drive
33
<Select OK
34
35
Navigating Cells in This Workbook
36
Yellow cells should be edited to create pathway to victory scenarios.
37
38
39
40
Light blue cells can be edited to update registration, turnout, and polling data from the Arena Snapshot Pivot Excel document. Or, you can update the District_Overview tab manually, using election results from the Secretary of State.
41
42
43
44
Grey cells should not be edited. These cells contain formulas to calculate the state of the race.
45
46
47
48
Navigating Tabs in This Workbook
49
50
Pathway_to_VictoryShows current voterfile for the district, population counts based on demographics, past voter registration numbers, and modeled or polling averages. Enter data from the pivot table excel workbook into light blue cells. . Formulas in the grey cells calculate pathway to victory and program numbers.
51
52
53
54
District_OverviewContains key dates related to your election, past elections results for the district, as well as related elections results, which can provide helpful insights as you create a pathway to victory for your campaign.
55
56
57
58
Helpful Tips in the Doc
59
60
On the Pathway_to_Victory Tab rows 7, 19, and 27 have helpful language to remind you which fields to update and where that data may come from. You may have to unhide these rows if they are hidden from view.
61
Loading...
Main menu