ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Work in progress, subject to change without notice.
2
3
To make changes to this sheet, save a copy to your own Drive account.
4
To use the existing values, check the Menu tab to see what would be grown and what the nutrient balance looks like.
5
The Results tab compiles some data including m² and kcal per person.
6
7
Warning: Values assume a vertical clearance of 4m. The sheet needs to be reworked to provide volume estimates.
8
9
10
11/18/2015
First published. Originally compiled as part of a larger project, but extracted into this format for further work.
11
11/25/2015
Added separate menu columns for adults of each gender and children, with summation rows based on appropriate data
12
12/9/2015
Added peanuts, oats, barley. Adjusted default menu to be eggs/fish/peanut and eliminated beef/pork.
13
5/15/2017
Error caught and corrected in power calculations, thanks to /u/3015. Also added total and per capita energy requirements.
14
5/18/2017
Error caught and corrected in power calculations, thanks to /u/3015. This affected area and volume as well.
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