{"id":1200,"date":"2015-12-29T17:10:23","date_gmt":"2015-12-29T22:10:23","guid":{"rendered":"http:\/\/fivefurrow.net\/?p=1200"},"modified":"2016-01-13T12:10:52","modified_gmt":"2016-01-13T17:10:52","slug":"logs-data","status":"publish","type":"post","link":"https:\/\/fivefurrow.net\/?p=1200","title":{"rendered":"Logs & Data"},"content":{"rendered":"

In order to track our progress each year, I try to quantify the harvest as best I can. I keep a written journal of most of the important activities and progress\u00a0in the garden, and the journal includes a penciled-in log of any harvests that happen during each week of the season. When I have the chance, I copy that handwritten data into a little spreadsheet I made which handles some of the calculations I’m interested in and updates the totals automatically for me. This spreadsheet is designed specifically for small gardens, not farms, and possibly not even for very large gardens. It’s targeted for situations where you harvest small amounts and can keep track of harvested items as single units (for most things) or small bunches (for herbs), rather than as large bulk amounts such as bushels.<\/p>\n

The concept behind this spreadsheet is that once you add in some typical values at the start of the season for the weight of a given variety when harvested (like the average weight of one cherry tomato), the spreadsheet does all the rest of the calculations as you add to your counts each week. It does its math based on counts, so that you don’t have to keep weighing each time you harvest, just tally how many single items you harvested that week.<\/p>\n

Here is a PDF\u00a0version of our 2015 harvest spreadsheet:
\nHarvest Spreadsheet PDF<\/a><\/p>\n

I’ll post a link to a working .xlsx spreadsheet at the end of this post, which is free for you to use and tweak as you see fit.<\/p>\n

Here’s how it works:<\/p>\n

\"2015<\/p>\n

Column A: (Name and Variety)<\/strong><\/p>\n

B (Ounces per Unit):<\/strong> A unit might be a Single (for things like tomatoes or cucumbers), or a Bunch (for things like greens or herbs), or I could call one a Dozen, which would work for some varieties.<\/p>\n

C (Unit Name):<\/strong> Name of the Unit referred to in B.<\/p>\n

D (Singles per Unit):<\/strong> How many single items are there in a Unit? This is arbitrary and up to you. For example, 20 in a Bunch or 12 in a dozen. I have 10 leaves of Kale equals one Bunch, for example.\u00a0This is only for determining the average weight of a single leaf, bean, etc so that further math can be done later.<\/p>\n

E (Calculated ounces per single):<\/strong>\u00a0This assists\u00a0in the next calculation. This is the weight of one tomato, or pepper, or eggplant, or bunch of basil or kale, etc. I can just\u00a0weigh a total\u00a0harvest of say 20 beans, and let the spreadsheet calculate the very small weight of one bean\u2014probably too small for my scale to measure accurately. Then when I harvest, I can count the singles, for example\u00a0127\u00a0beans in a given week, and the spreadsheet does the rest of the multiplication.<\/p>\n

F: Lbs (pounds) total.<\/strong> This is the calculated sum of all of the harvested single items\u00a0in the row (F), times the calculated ounces per single (E), divided by 16 (ounces per pound) to convert to pounds\u00a0from\u00a0ounces. So the value is the total pounds of harvest for this variety all season. At the bottom of Column F is the grand total weight of the season’s harvest across the board.<\/p>\n

G (Count Total):<\/strong> Here, the total count of singles for the season for that variety is calculated. For example, total number of tomatoes picked all season, or total number of leaves\u00a0of kale picked.<\/p>\n

\"2015<\/a><\/p>\n

I’ve added some additional columns as well.<\/p>\n

H (Market Price per lb):<\/strong>\u00a0 This is the price I see at the local farmer’s market for a similar item, so it is what I would have paid per pound if we\u00a0had purchased it rather than grown it ourselves.<\/p>\n

I (Harvest Value):<\/strong> This is the calculated value of the equivalent amount of produce if our own season’s harvest was purchased at the market. For example, Our twenty Brandywines added up to 11.56 lbs, so at the local price of $4\/lb we grew the equivalent of $46.25 worth of them.<\/p>\n

J (Designated Space):<\/strong> This is a rough idea of how much total space this variety\u00a0took up in the garden. For example, we had two Fox Cherry plants which each took up about two square feet of soil, so I have them taking up a total of eight square feet. The bottom of this column should add up to the total amount of soil I have available to plant, in our case roughly 220 sq ft.<\/p>\n

K (Productivity):<\/strong> This is a calculation of the Harvest Value (I) dividied by the Designated Space (J), and shows the relative value of using garden space for growing one crop versus another, in pure dollar terms. So I can see that using a square foot of soil to grow Brandywines ($7.71 per sq ft) is more than twice as valuable than using the same square foot to grow\u00a0Pickling Cucumbers
\n($3.09 per sq ft). I can also see that\u00a0herbs are the most productive crop in dollar per square foot terms. This makes sense, as shoppers pay a proportionally\u00a0large amount for the tiny bunches\u00a0of herbs that they need for cooking. A bunch of kale might weigh half a pound and cost $3, but a home cook would never buy a pound of sage; they might\u00a0pay $3 for half an ounce. This is why most of the herbs show very high equivalent market prices per pound.<\/p>\n

\"2015<\/a><\/p>\n

Further over to the right, we see the actual harvest data, divided up by week. These are always singles,\u00a0as in three individual tomatoes or 73 individual beans or 12 individual leaves of collards. Each date marks the last day of that week, so the value in the Aug 21 entry would be the total of that variety harvested from the week ending on the 21st. This means that the last ‘week’ of each month might be ten or eleven days\u2014each month has three 7-day weeks followed by one long week in order to bring us to the end of the month without extra days.<\/p>\n

So in summary, to use the spreadsheet:<\/p>\n

    \n
  1. Enter the names of your varieties in Column A.<\/li>\n
  2. Determine the average weight per unit\u00a0using a scale. For example, weigh 5 cucumbers together and divide the total weight by 5. Or weigh 10 leaves of kale, call that a Bunch, enter 10 in column D, and the spreadsheet will figure out the single leaf weight. At this point you really won’t need your scale again.<\/li>\n
  3. Optionally enter your own figures for H, I and J if these calculations are of interest to you regarding dollar values and productivity.<\/li>\n
  4. At the end of each week of the season, enter your total counts. Again, it’s a single count for a tomato, or a single count for a leaf\u00a0of greens. If I picked 25\u00a0leaves of kale on a single day and no more kale for the week, I put ’25’ as the value for that week. Two tomatoes on the first day of the week and two more on the last day of the week?\u00a0The value for that week would be ‘4’.<\/li>\n
  5. Let the spreadsheet calculate the rest!<\/li>\n<\/ol>\n

    Using this method, after the initial setup of the first few columns, I simply tally up my counts for the week and enter them. The rest is done for me.<\/p>\n

    The spreadsheet tells\u00a0me, for example:<\/p>\n

    \u2014 We harvested about\u00a087.44 lbs of produce this year\u2014similar to last year.
    \n\u2014 We harvested the equivalent of about\u00a0$458.23 worth of produce.
    \n\u2014\u00a0The award for the longest growing season goes to… Chives! April – December.
    \n\u2014 Chives also brought in the best value per square foot, at $43.75\/sq ft.
    \nThis is due to their high equivalent market price, multiplied by their long season.
    \n\u2014 Our average value of harvested produce per sq ft of soil is $2.06.
    \n\u2014 1333 hops cones, totaling 1.88\u00a0pounds…\u00a0all given\u00a0to local homebrewers.
    \n\u2014 Each square foot of soil used for Cherry tomatoes proves to be\u00a0slightly more productive in dollar terms ($8.13) than if it were\u00a0used for Brandywines ($7.71).<\/p>\n

    Here is a link to the same spreadsheet, ready for you to customize. I hope you find it useful.<\/p>\n

    Downloadable Harvest Spreadsheet (.xlsx)<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    In order to track our progress each year, I try to quantify the harvest as best I can. I keep a written journal of most of the important activities and progress\u00a0in the garden, and the journal includes a penciled-in log of any harvests that happen during each week of the season. When I have the … Continue reading Logs & Data<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[75,19,18,14,11],"tags":[136,135,137,99,138],"class_list":["post-1200","post","type-post","status-publish","format-standard","hentry","category-75","category-harvest","category-herbs","category-hops-and-beer","category-vegetables","tag-data","tag-harvest","tag-logs","tag-urban-agriculture","tag-vegetable-harvest"],"_links":{"self":[{"href":"https:\/\/fivefurrow.net\/index.php?rest_route=\/wp\/v2\/posts\/1200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fivefurrow.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fivefurrow.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fivefurrow.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fivefurrow.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1200"}],"version-history":[{"count":10,"href":"https:\/\/fivefurrow.net\/index.php?rest_route=\/wp\/v2\/posts\/1200\/revisions"}],"predecessor-version":[{"id":1220,"href":"https:\/\/fivefurrow.net\/index.php?rest_route=\/wp\/v2\/posts\/1200\/revisions\/1220"}],"wp:attachment":[{"href":"https:\/\/fivefurrow.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1200"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fivefurrow.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1200"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fivefurrow.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}