OFN international dashboard
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet is an important record of global OFN acheivements. Please update your instance's details quarterly. If everyone contributes to this spreadsheet it will be a valuable asset when applying for grants and demonstrating the OFN's impact and potential.

The spreadsheet is broken into 7 parts:
Part 1 - Sales
Part 2 - Number of Users - Profiles,Shops, Customers & Orders
Part 3 - Grants received
Part 4 - Contributors (volunteers and staff)
Part 5 - Testimonials
Part 6 - Business Models
Part 7 - Media Mentions
2
KEY
3
Yellow cells need to be filled out with information.
4
White cells have been completed. Please remember to turn cells white after filling out.
5
-
Mark a cell with a dash if it doesn't apply. E.g. if your instance was not active at the time.
6
Green cells contain a calculation, please don't edit
7
Grey cells are in the future, don't fill out until the time has come.
8
9
Part 1 - Sales Through the Platform
10
This information should be collected by downloading the OC Customer Totals report as SuperAdmin for the quarter's date range. Depending on the level of activity at your instance you may need to download this report in segments due to large file sizes. Once you have all data of all orders for the quarter you should remove any known 'demo' or 'testing' data that you know of. Next you should highlight all the data and create a pivot table (Insert>Pivot Table) on a new sheet. Drag the 'hubs' field into the 'Row Labels' box, and drag the 'Total' field into the 'Values' box. Right click on the Totals and change it from 'Count of totals' to 'Sum of Totals'. You should now have a Pivot Table showing all active shops in the quarter, with a sum of their unique order totals, and the instance's cumulative sales total. Let sally know if you have trouble (via hello@openfoodnetwork.org).
11
20162017
12
Q1Q2Q3Q4Q1Q2Q3Q4TotalTotal Euros
Convert to Euros
13
OFN Australia$255,103.00$289,012.00$243,679.00$269,649.00$237,602.00$0.00$0.00$0.00$1,295,045.00€912,003.521.42
14
OFN UK£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00£0.00€0.000.86
15
OFN Scandinavia0.00 kr0.00 kr0.00 kr0.00 kr0.00 kr20,561.00 kr0.00 kr0.00 kr20,561.00 kr€2,185.029.41
16
OFN France€0.00€0.00€0.00€0.00€0.00€0.00
17
OFN USA$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00€0.00
18
OFN Canada$0.00$0.00$0.00$1,171.80$2,321.00$0.00$0.00$0.00$3,492.80€2,479.890.71
19
OFN India₹0.00₹0.00₹0.00₹0.00₹0.00₹0.00₹0.00₹0.00₹0.00€0.00
20
Total€916,668.43
21
Part 2 - Number of Users (Proxy for Engagement)
22
KEY:Report Required
Instructions to extract the figure
23
Producer Profiles
Users and Enterprises - Downloaded just after the end of the quarter
Remove duplicated in 'Enterprise' column (Data Tab>Remove Duplicates). Remove unconfirmed profiles. Filter by Producer=TRUE and Visible=t and count the number of enterprises (include all 'sells' categories)
24
Hub Profiles
Users and Enterprises - Downloaded just after the end of the quarter
Remove duplicated in 'Enterprise' column (Data Tab>Remove Duplicates). Remove unconfirmed profiles. Filter by Producer=FALSE and Visible=t and count the number of enterprises (include all 'sells' categories)
25
Active Producer Shops
OC Customer Totals - Downloaded for the quarter date range (note you may need to do it in parts due to large file size)You should have downloaded this report for your instance sales figure (Part 1 of this spreadsheet). When you have this, you can remove duplicates for the Hub column and count all Producer Shops. Or you can create a pivot table to get the number of shops with orders in the quarter.
26
Active Hub ShopsOC Customer Totals - Downloaded for the quarter date range (note you may need to do it in parts due to large file size)You should downloaded this report for your instance sales figure (Part 1 of this spreadsheet). You can remove duplicates for the Hub column and count all Non-Producer Shops. Or you can create a pivot table.
27
Number of Customers
Homepage Counter - Checked just after the end of the quarter
Go to your instance homepage and get the 'Shoppers' figure. Subtract this from last quarter's figure to get the 'new shoppers' figure. Note if your instance is not using this tool, you will need to turn it on momentarily in Configuration and turn it off when you have the figures.
28
Number of Orders
Homepage Counter - Checked just after the end of the quarter
Go to your instance homepage and get the 'Orders' figure. Subtract this from last quarter's figure to get the New Orders this quarter figure. Note if your instance is not using this tool, you will need to turn it on momentarily in Configuration and turn it off when you have the figures.
29
30
201620172018
31
AustraliaQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
32
Producer Profiles710
33
Hub Profiles234
34
Active Producer Shops
12
35
Active Hub Shops4
36
Number of Customers
----1625
37
Number of Orders----13225
38
201620172018
39
UKQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
40
Producer Profiles
41
Hub Profiles
42
Active Producer Shops
43
Active Hub Shops
44
Number of Customers
45
Number of Orders
46
201620172018
47
ScandanaviaQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
48
Producer Profiles
49
Hub Profiles
50
Active Producer Shops
1
51
Active Hub Shops2
52
Number of Customers
136
53
Number of Orders654
54
201620172018
55
FranceQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
56
Producer Profiles335061102130
57
Hub Profiles
58
Active Producer Shops
89132226
59
Number of Customers
3792636
60
Number of Customers
61
Number of Orders
62
201620172018
63
USAQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
64
Producer Profiles----
65
Hub Profiles----
66
Active Producer Shops
----
67
Active Hub Shops----
68
Number of Customers
----
69
Number of Orders----
70
201620172018
71
CanadaQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
72
Producer Profiles-52
73
Hub Profiles-3
74
Active Producer Shops
-4
75
Active Hub Shops-2
76
Number of Customers
-15
77
Number of Orders-89
78
201620172018
79
IndiaQ1Q2Q3Q4Q1Q2Q3Q4Q1Q2Q3Q4
80
Producer Profiles--
81
Hub Profiles--
82
Active Producer Shops
--
83
Active Hub Shops--
84
Number of Customers
--
85
Number of Orders--
86
87
Part 3 - Grants
88
Please take note of all grants received by your Instance.
89
InstanceSourceValueWhenValue in €
90
Australia
Department of Health
$440,000 €309,859.15
91
Lord Mayors?
92
Crowdfunding£62,667.00 €44,131.69
93
TOTAL grants Australia
£502,667.00 €353,990.85
94
UKEsmee Fairbairn Foundation£13,500.00 €15,697.67
95
Esmee Fairbairn Foundation£135,000.00 €156,976.74
96
Award£10,000.00 €11,627.91
97
N8 Agrifood£13,000.00 €15,116.28
98
TOTAL grants UK$171,500.00 €199,418.60
99
ScandanaviaPrivate donors80,000.00 kr2015 €8,501.59
100
France-$0.00
Loading...
Main menu