There are a few calculations the system will need to perform in order to support Crops V2.0. The detailed underlying schema and pre-populated values for crops can be found here: https://docs.google.com/spreadsheets/d/1BoY6mEU1om14oc799m7XK9FCemxzrF406eie4V-5ozc/edit?usp=sharing. In most cases, users can overwrite these values in the app (shown in the below table as “From data & overridable”).

Please be aware that all variables need to be normalized to the same unit system! For more information on displaying values, please check out Unit displays.

Variables

Attribute	Type	Units	Measure	Notes
Total Area	Calculated & overridable	Decimal	Area	Calculated and overridable when creating / editing a location of type area.
% of location	User entered	Decimal	Area	Validation: ≥ 0, ≤ 100
Seeding Rate	From data & overridable	Decimal	Weight / Area	This is essentially the number of seeds needed to “saturate” a given area. In either kg / ha or lbs / ac.
Yield per area	From data	Decimal	Weight	Will be given in kg / m^2. May need to be converted to imperial for calculations if the user’s display is in imperial.
Yield per plant	From data	Decimal	Weight	Will be given in kg. May need to be converted to imperial for calculations if the user’s display is in imperial.
Average seed weight	From data	Decimal	Weight	Will be given in g. May need to be converted to imperial for calculations if the user’s display is in imperial.
# of plants	User input	Integer		Validation: 1 - 1,000,000
# of beds	User input	Integer		Validation: 1 - 1,000,000
# of rows in bed	User input	Integer		Validation: 1 - 1,000,000
# of rows	User input	Integer		Validation: 1 - 1,000,000
Length of row	User input	Decimal	Distance	Validation: 1 - 1,000,000
Total length of rows	User input	Decimal	Distance	Validation: 1 - 1,000,000 For users who have variable length rows, we ask them to add up the approximate length of their rows for calculating estimated seed required and estimated yield.
# of containers	User input	Integer		Validation: 1 - 1,000,000
# of plants / container	User input	Integer		Validation: 1 - 1,000,000
Planting depth	From data & overridable	Decimal	Distance	Validation: 1 - 1,000,000
Plant spacing	From data & overridable	Decimal	Distance	Validation: 1 - 1,000,000
Bed length	User input	Decimal	Distance	Validation: 1 - 1,000,000
Bed width	User input	Decimal	Distance	Validation: 1 - 1,000,000

Calculations

Attribute

Type

Units

Measure

Formula

Notes

Area Used

Calculated

Decimal

Area

For broadcast:

Area_used = Total_Area * %_of_location

Unit from Total_Area (e.g. Ha, Ac, etc.) should be maintained.

Estimated seed required

Calculated & overridable

Seed (Integer) or Weight (Decimal)

Seed or Weight

For broadcast:

Estimated_seed_required (in weight) = area_used * seeding_rate

Estimated_seed_required (in seeds) = area_used * seeding_rate * average_seed_weight

For container:

Estimated_seed_required (in weight) = #_of_containers * #_of_plants/container * average_seed_weight

Estimated_seed_required (in seeds) = #_of_containers * #_of_plants/container

For in ground:

Estimated_seed_required (in weight) = #_of_plants * average_seed_weight

Estimated_seed_required (in seeds) = #_of_plants

For rows (same length rows):

Estimated_seed_required (in weight) = ((#_of_rows * length_of_rows) / plant_spacing) * average_seed_weight

Estimated_seed_required (in seeds) = ((#_of_rows * length_of_rows) / plant_spacing)

For rows (variable length rows):

Estimated_seed_required (in weight) = ((Total_length_of_rows) / plant_spacing) * average_seed_weight

Estimated_seed_required (in seeds) = ((Total_length_of_rows) / plant_spacing)

For beds:

Estimated_seed_required (in weight) = ((#_of_beds * #_of_rows_per_bed * bed_length) / plant_spacing) * average_seed_weight

Estimated_seed_required (in seeds) = ((#_of_beds * #_of_rows_per_bed * bed_length) / plant_spacing)

Estimated seed required can be displayed in either weight or seeds. The weight will be a standard weight unit (e.g. kg, lbs) and seeds will be its own unit. Weight will display to two decimal places beyond the decimal. Seeds will be whole numbers (ceiling). For both cases, you will need to ensure that the variables are converted to the desired output (e.g. g → kg).

Estimated yield

Calculated & overridable

Decimal

Weight

For broadcast:

Estimated_yield = Area_used * yield_per_area

For rows:

Estimated_yield = ((#_of_rows * length_of_rows) / plant_spacing) * yield_per_plant

For beds:

Estimated_yield = ((#_of_beds * #_of_rows_per_bed * bed_length) / plant_spacing) * yield_per_plant

For containers:

Estimated_yield = #_of_containers * #_of_plants/container * yield_per_plant

For individual plants:

Estimated_yield = #_of_plants * yield_per_plant

For all cases, may need to convert from one unit system to another (e.g. cm → in) and/or normalize for a unit (e.g. ft → in).

Crop variables and calculations

Variables

Calculations