| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 2016 | 2017 | ||||||||||||||||||||||||
12 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Total | Total 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.52 | 1.42 | ||||||||||||||
14 | OFN UK | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | €0.00 | 0.86 | ||||||||||||||
15 | OFN Scandinavia | 0.00 kr | 0.00 kr | 0.00 kr | 0.00 kr | 0.00 kr | 20,561.00 kr | 0.00 kr | 0.00 kr | 20,561.00 kr | €2,185.02 | 9.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.89 | 0.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 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 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 | 2016 | 2017 | 2018 | |||||||||||||||||||||||
31 | Australia | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||
32 | Producer Profiles | 710 | ||||||||||||||||||||||||
33 | Hub Profiles | 234 | ||||||||||||||||||||||||
34 | Active Producer Shops | 12 | ||||||||||||||||||||||||
35 | Active Hub Shops | 4 | ||||||||||||||||||||||||
36 | Number of Customers | - | - | - | - | 1625 | ||||||||||||||||||||
37 | Number of Orders | - | - | - | - | 13225 | ||||||||||||||||||||
38 | 2016 | 2017 | 2018 | |||||||||||||||||||||||
39 | UK | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||
40 | Producer Profiles | |||||||||||||||||||||||||
41 | Hub Profiles | |||||||||||||||||||||||||
42 | Active Producer Shops | |||||||||||||||||||||||||
43 | Active Hub Shops | |||||||||||||||||||||||||
44 | Number of Customers | |||||||||||||||||||||||||
45 | Number of Orders | |||||||||||||||||||||||||
46 | 2016 | 2017 | 2018 | |||||||||||||||||||||||
47 | Scandanavia | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||
48 | Producer Profiles | |||||||||||||||||||||||||
49 | Hub Profiles | |||||||||||||||||||||||||
50 | Active Producer Shops | 1 | ||||||||||||||||||||||||
51 | Active Hub Shops | 2 | ||||||||||||||||||||||||
52 | Number of Customers | 136 | ||||||||||||||||||||||||
53 | Number of Orders | 654 | ||||||||||||||||||||||||
54 | 2016 | 2017 | 2018 | |||||||||||||||||||||||
55 | France | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||
56 | Producer Profiles | 33 | 50 | 61 | 102 | 130 | ||||||||||||||||||||
57 | Hub Profiles | |||||||||||||||||||||||||
58 | Active Producer Shops | 8 | 9 | 13 | 22 | 26 | ||||||||||||||||||||
59 | Number of Customers | 3 | 7 | 9 | 26 | 36 | ||||||||||||||||||||
60 | Number of Customers | |||||||||||||||||||||||||
61 | Number of Orders | |||||||||||||||||||||||||
62 | 2016 | 2017 | 2018 | |||||||||||||||||||||||
63 | USA | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||
64 | Producer Profiles | - | - | - | - | |||||||||||||||||||||
65 | Hub Profiles | - | - | - | - | |||||||||||||||||||||
66 | Active Producer Shops | - | - | - | - | |||||||||||||||||||||
67 | Active Hub Shops | - | - | - | - | |||||||||||||||||||||
68 | Number of Customers | - | - | - | - | |||||||||||||||||||||
69 | Number of Orders | - | - | - | - | |||||||||||||||||||||
70 | 2016 | 2017 | 2018 | |||||||||||||||||||||||
71 | Canada | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||
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 | 2016 | 2017 | 2018 | |||||||||||||||||||||||
79 | India | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | |||||||||||||
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 | Instance | Source | Value | When | Value 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 | UK | Esmee 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 | Scandanavia | Private donors | 80,000.00 kr | 2015 | €8,501.59 | |||||||||||||||||||||
100 | France | - | $0.00 | |||||||||||||||||||||||
Loading...