ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet is meant to support colleges in tracking their regional and values based purchases. Please make a copy of this spreadsheet and delete the sample data in order to begin using it for your institution. This is the beta version of this tool and is currently available for manual entries (See below).

To use this tool, you will, at a minimum, need to enter and code all purchases that you believe are regional or values-based (e.g., sustainable, fair, humane). However, even more functionality will be available to you if you add ALL of your purchases (you do not need to code every purchase but make sure you've added a dollar amount.)

Note that FINE's geographic defintion of "regional" is within the six New England states plus a 50 mile buffer.

There are a few ways you can use this spreadsheet:

Beta version functionality:
1. Manual entries for every purchase: Use the "Purchase Tracker" tab to manually enter single or aggregated purchases. Code each purchase according to the column headers (see "Key" tab for more detail). The "Summary report" tab will calculate your regional, sustainable, and fair purchases. The data calculated in this tab can be inserted directly into FINE's Campus Data Center (available in January 2022).

2. Layer on top of existing spreadsheets: We know many are already using their own systems to track regional purchases. We hope this spreadsheet can still be a useful for those looking to add additional metrics to their tracking. We also encourage you to borrow any of the formulas to make your own spreadsheets more effective.

Future versions:
Automated coding based on database of your vendors and items: Coming soon!


If you have any questions or would like assistance using this tool, please contact Hannah Leighton at hannah@farmtoinstitution.org

This tool is draws from work done by the National Farm to Institution Metrics Collaborative. For more information visit https://ftimetrics.localfoodeconomics.com/
2
3
4
5
6
7
8
9
10
11
12
13
14
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