ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Descriptive Statistics with the NELF Explorer and Recent Trends
2
This introduction will explain the purpose of each worksheet in this document and will provide step by step instructions to retrieve and analyze the data you need from the NELF Explorer. All you need is a computer with an internet connection and a free Google account so that you can edit a copy of this document.
3
4
5
6
Contents of this document
7
Sheet NameDescription
8
InstructionsExplains the purpose of each worksheet in the document
9
Explains how to navigate to the necessary chart in the NELF Explorer (see below)
10
StatisticsContains the table that the user fills in with acreages from the NELF Explorer
11
Derives other statistics and calculations automatically based on the user's input
12
ChartsCreates two pie charts showing present and future land use
13
Creates one bar chart showing change in developed and conserved acres over time
14
ExampleShows how the statistics and charts from this document can be used to create a place based narrative
15
Citation / FAQ
Provides a suggested citation for Recent Trends data and a link to FAQs
16
17
Instructions to retrieve data and use this document
18
Part 1: Edit access to this Google Sheets
19
1. If you do not have a free Google account,
create one here.
20
2. Create a copy of this Google Sheets document that you can edit. On this document, go to File and select either Add to My Drive or Make a copy... and the copy will save to your Google Drive.
21
22
Part 2: Retrieving land use acres from NELF Explorer
23
1. Open the NELF Explorer in Chrome, Firefox, or Safari -
click here to open.
24
2. Click the "Skip to maps" button.
25
3. Click the "Explore Areas" button on the navigation bar at the top of the Explorer.
26
4. From the "Explore Areas" dropdown menu that appears, select your spatial scale. Polygons showing those areas will apear on the map.
27
Note: Depending on your internet speed and the spatial scale selected, this may take a minute. Be patient!
28
5. On the map, click on the area that you want to generate statistics for. (You may need to zoom in to find it.) Once you click, a new section of the NELF Explorer will appear on the bottom of the page, with charts on the left and text on the right.
29
6. On the left side of this new section, find the Recent Trends chart below "Land uses over time for [your area]". The land use charts are labeled with the scenario name.
30
7. Hover your computer mouse over the Recent Trends land use chart at 2010. Enter these numbers into Table 1 on the "Statistics" worksheet.
31
8. Repeat for a future decade of Recent Trends, such as 2050 or 2060.
32
9. Some tips to make retrieving the land use acreages from the chart smoother:
33
a.
Write the acreages down on paper first, then enter them into Table 1. This reduces moving the mouse off the chart and the acreages disappearing.
34
b.Make sure this document and the NELF Explorer are open in different browser windows so you can view both at the same time. When hovering over a decade in the Recent Trends land use chart, right click with your mouse. This will freeze the acreage table so that it does not disappear when your mouse leaves, and you can enter the acreages into Table 1 more easily. You can also try using the "Copy image" option that appears when you right click, and paste the photo of land use acres into the spreadsheet in order to copy the numbers more easily.
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