Tuesday February 1, 6:00 – 8:00 pm
Green Mountain College, Griswold Library, Computer lab 206 (second floor of the library). Here’s a map of the GMC campus. The Library is the southern most building.
Please register for this workshop here!
Agenda and details below.This workshop will focus on the use of Excel for production planning purposes. The use of spreadsheet software like Excel can greatly facilitate vegetable production planning. Green Mountain College Farm Manager Kenneth Mulder will demonstrate how to use Excel to calculate and record planting and transplanting dates, planting amounts, estimated harvest dates and yields, and succession planting dates. Participants will then use Excel to develop their own spreadsheets. No familiarity with Excel or the use of spreadsheets is required. Familiarity with production planning is helpful but also not required.
**Bring a thumb drive with you to save your work and bring it home. If you don’t have one, you should be able to email the file you create during the workshop to yourself*** If you work on a mac laptop, bring that too.
6:00 Introductions and objectives
- Who are we and why are we here?
- What do we hope to accomplish?
6:15 Introduction to Excel
- Using Excel to perform calculations
- Navigating within and between spreadsheets
6:30 Production planning with Excel
- Determining planting dates
- Determining planting quantities
- Determining seed requirements
7:30 Developing a planting schedule and planting records
If time: Using pivot tables to summarize data
This is a follow up workshop from our Summer New Farmer Workshop on Crop Succession Planning. (If you didn’t make the summer workshop, that’s okay. Watch a video of that workshop and review handouts here)