Spreadsheet Growing

All but sorted sharing our DIY Growing Spreadsheet. Casually as we like with our 5th and final sheet for the now.

At the end of the day. Just maybe, random bits and bobs of the formula we’ve used comes in useful for the both of us. Then again maybe not. Either, either way, ’tis what it is.

Seeds Section

First section of our growing sheet. 3 columns for the seeds we’re growing.

Spreadsheet Growing

Select cell A3 on our new growing sheet. Choose Data from the menus and then click on Validity from the drop down menu available.

In Criteria, change All values, currently chosen and select Cell range.

Enter named range, SeedFamily into Source (from index sheet, column A).

Allow: Cell Range

Source: SeedFamily (Taken from Our Named Ranges)

Drop down box with our named range (SeedFamily) available in cell A3.

Select cell B3 on our new growing sheet. Choose Data from the menus and then click on Validity from the drop down menu available.

Import the content from our index sheet, named ranges into our Seed Name, Column B, Cell B3. Enter INDIRECT(A3) in the Source tab.

Allow: Cell Range

Source: INDIRECT(A3)

Provided we’ve made a selection, from our seed family group in Cell A3.

We are now able to choose content from our index sheet, for our named ranges (Seed Name) in Cell B3.

Growing Space / Area Section

Second section of our new DIY growing sheet.

10 columns for the random growing spaces down on our allotment/plot.

If truth be known from inside me head. We are only entering information into 3 of the 10 columns we’ve created.

We will be using LibreOffice Calc, If functions (statements) in the other 7, to do what we do and calculate the information we’d like to know?

Random formula used in our Growing Space / Area Section

Section Length (Feet): Column D, Cell D3.

Entered Information, example used 1

Section Length (Inches): Column E, Cell E3.

(PS: Change the dash for a zero or whatever else you want?)

=IF(D3=0,"-",D3*12)

Section Length (cm): Column F, Cell F3.

=IF(D3=0,"-",(D3*30.48))

Crop Spacing (Inches): Column G, Cell G3.

Entered Information, example used 1

Crop Spacing (cm): Column H, Cell H3.

=IF(G3=0,"-",G3*2.54)

Row Spacing (Inches): Column I, Cell I3.

Entered Information, example used 1

Row Spacing (cm): Column J, Cell J3.

=IF(I3=0,"-",I3*2.54)

Approx Seeds per Row: Column K, Cell K3.

=IF(G3=0,"-",(30/G3))

Approx Number of Rows: Column L, Cell L3.

=IF(OR(D3=0,I3=0),"-",(E3/I3))

Approx Total Seeds Required: Column M, Cell M3.

=IF(OR(D3=0,G3=0,I3=0),"-",(K3*L3))

Travel Safe

Inabit