Spreadsheet Growing Planning

Proper planning be ish in progress with the boys in the castle for tha now.

Faffing around like we casually do, with our DIY spreadsheet growing planning. Whilst we wait a bit longer, for the weather to pick up from minus whatever it be @ daft o’clock this side of the coil.

Won’t be long now, ’till we actually start sowing a few random unknown seeds. In the meantime, thought we’d move forward with our planning section for our DIY growing spreadsheet.

Just maybe we’ve gone a tad overboard sharing every cell? Then again, it really does help us in the castle to remember our whatevers. Move On.

Planning Sowing (Guesstimate ish Dates) Section

Spreadsheet Growing Planning

Sorta like adding a dash for our empty, DIY auto calculated cells.

Approx Date To Sow. Column N, Cell N3.

Enter Guesstimate Date Approx Date To Sow Cell N3

Approx Weeks To Thin. Column O, Cell O3.

Enter Guesstimate Number Approx Weeks To Thin Cell O3

Approx Days To Thin. Column P, Cell P3

=IF(O3=0,"-",(O3*7))

Approx Date Thin Seedlings. Column Q, Cell Q3

=IF(O3=0,"-",N3+(O3*7))

Approx Weeks to plant out. Column R, Cell R3

Enter Guesstimate Number Approx Weeks to plant out Cell R3

Approx Days to plant out. Column S, Cell S3

=IF(R3=0,"-",(R3*7))

Approx Date Sow Outside. Column T, Cell T3

=IF(OR(O3=0,R3=0),"-",Q3+(R3*7))

Approx Weeks to plant out. Column U, Cell U3

Enter Guesstimate Number for Weeks to plant out Cell U3

Approx Days to Harvest. Column V, Cell V3

=IF(U3=0,"-",(U3*7))

Approx Date To Harvest. Column W, Cell W3

=IF(OR(O3=0,U3=0),"-",T3+(U3*7))

Planting Sowing (Actual Dates) Section

Actual Date To Sow. Column X, Cell X3

Enter Actual Date To Sow Cell X3

Actual Date Thin Seedlings. Column Y, Cell Y3

Enter Actual Date Thin Seedlings Cell Y3

Actual Date Sow Outside. Column Z, Cell Z3

Enter Actual Date Sow Outside Cell Z3

Actual Date To Harvest. Column AA, Cell AA3

Enter Actual Date To Harvest Cell AA3

Actual Growing Time Days. Column AB, Cell AB3

=IF(ISBLANK(X3),"-",IF(ISBLANK(AA3),TODAY()-X3,AA3-X3))

Actual Growing Time Weeks. Column AC, Cell AC3

=IF(ISBLANK(X3),"-",IF(ISBLANK(AA3),TODAY()-X3,AA3-X3)/7)

Actual Growing Time Months. Column AD, Cell AD3

=IF(ISBLANK(X3),"-",IF(ISBLANK(AA3),TODAY()-X3,AA3-X3)/(365/12))

Travel Safe

Inabit