A string trellis is more like a bunch of vertical trellis’s side by side right over the box.An angled trellis will be wider and extend away from the box.If you want to edit the contents of the box below, simply move the auto shape out of the way. You can add a fill color or texture, change the opacity, etc.A vertical trellis isn’t very wide from above so make it look that way.Draw your trellis over the middle of the box you just created.Insert > Picture > Autoshapes will bring up the autoshapes menu.So I have a 1 foot wide by 8 foot high box, with a 6 foot high vertical trellis up the middle. I use Sugar snaps as a vertical block around my fire pit. String: Peas (shorter varieties can grow a few feet easily. Vertical: Peas (Taller varieties like Sugar Snap), Cucumber, Pole beans Heavier vining vegetables like squash I grow on an angled trellis as well. Sugar snap peas can grow 6′ easily – and are powerful climbers so vertical trellis’s are fine. Will germinate at temps of 7C – Will take a light frost.Īdding a box with some plants is fine, but what if we want a trellis? Plant how many weeks before frost (Transplants): 0ĭays after frost plant: -2 (Can be planted as soon as soil is workable. Number of plants per square: 8 (4 on either side of vertical 6′ trellis)Ĭode: Ps (Pea – sugar) – Colour Background is yellow (Pb – Pea bush) Planting weeks – weeks before last frost to plant indoors (-6) – don’t forget the “-”Įxample 2: Adding Sugar Snap Peas (on trellis)
You need to give the plant an identifier for the calculations to work (PG) – also good to add a background colour. Grayed boxes require you to enter something. Pick a new row to enter your information in. Plant how many weeks before frost (Transplants): 2-4 weeks before last frost – I used larger pots and 6 weeks as I live in the North. Number of plants per square: 0.33 (Needs 1×3 + room to vine) Plant how many weeks before last frost (if available)ĭays after frost to plant outdoors (transplants) Useful if you have something that died off after planting or have picked already. Last Plant Date: This is the estimated date by which you could conceivably still plant (Based on Maturity and First frost date). Maturity: Plant maturity – usually on seed packetsĭone by: Calculated estimate of the done growing date (estimated harvest). Transplant on/by: Calculated value, I Only use this for transplants – but could be for any seed planted after the last frost. Germination days: Some seeds have this, some don’t.ĭays after frost plant: Some plants need to be transplanted after the risk of last frost has passed or germination requires a warmer temperature. Plant by: This calculated field simply subtracts the planting weeks from the last frost date. This is where you enter the weeks before last frost you can plant (transplant or direct in garden). Planting (weeks to frost): Some seeds need to be planted indoors or can be planted outdoors before the last frost date. Transplant: For my own personal use as I just want to know what I am transplanting Total plants: This is calculated from the count of the squares per plant and the Per square allotment. Plant Name: Well this is where you put the plant name
#Excel garden planner code
I also colour code my boxes for quick reference – simply highligh the box and change the background colour. I Use trellis’s and due to my northern climate some of my numbers are not standard.Ĭode: Simple 2-3 letter code for each plant – this is what will “count” for all the automated features. Per square: These are the standard or modified SFG plants per square foot – easily found by Googling the plant name square foot spacing. # squares : Calculated when you add a box and assign it a 1 (for empty) or plant code. These dates are used for most of the calculations in the planting guide. It will calculate your grow days and days remaining (days until season is over)
The Last Frost and First Frost dates must be added here.
Here is where the grunt work is done – from calculating box space (available and used) to determining how many seeds/plants you need and even works out a planting schedule for you.Īt the top of the planting guide are the dates.
0 kommentar(er)
