Gavin O'Leary

Carolyn Hurley wrote:How do you debug?

Sheets("Calendar").Activate                                                                     'Activate the Calendar sheet
   calRowNum = Application.WorksheetFunction.Match(CLng(actionDate), weekRange, 0)                 'Set the calRownum as the row number of the matching date in col A of the calendar sheet
   

Hi Carolyn, could you please message me with a screenshot or copy of the error message you're seeing? I'm thinking there's either an issue with the actionDate or the weekRange variable here.

New release and thanks to who-ever put me in the daily-ish! https://github.com/gtoleary5/MarketGardenCropPlanner/releases

Sena Kassim wrote:I'll enter in some of info and let you know if anything looks odd. So far it's totally rad.

Thank you Sena! Please let me know if you think of any ways we can make this better.

Jesse Glessner wrote:However, some suggestions to help other people step into actually using this worksheet.

1. Build a step-by-step INSTRUCTIONS listing. Refer people back to the worksheet shown in #2 below.
2. Show an example of a completed system worksheet.

Hey JayGee, thank you for taking the time to look through this and leaving feedback. These are really great points, so I've just published a new release containing a filled-in Example Workbook along with an expanded user manual. Let me know what you think!

im imlach wrote:gorgeous work , brother. i teach org farming online and if ok, this could be something so valuable.....

Thank you Im and please feel free to use this in your classes! I would love to hear any suggestions or feedback from your students. Best of luck in your work!

Skandi Rogers wrote:AgSquared  and tend are two I have heard people mention, but I think they are much more comprehensive packages with both app and a full computer program.

I checked out AgSquared's site over the weekend and they've got a really polished toolkit. This spreadsheet is a long ways away from competing with the big dogs, but maybe someday...

Great job on the build and I'm looking forward to your upcoming article! I've been investigating the pros & cons of earthbag homes in the Blue Ridge / East TN area so this is right up my alley.

New release has been posted. I just realized I can't edit my OP so here's the new link: https://github.com/gtoleary5/MarketGardenCropPlanner/releases

I will be recording a short video tutorial this weekend and should have something posted in the next few days.

Hi Ash & Skandi, thank you for taking a look!

Skandi Rogers wrote:First comment is the sheet "Weekly CSA share content" appears to be blank, meaning there is no clue how to populate it. It would also be nice (when there is something to fill in there) to be able to see what crops would be available. of course that might be there on your copy of the spreadsheet.

To populate the Weekly CSA Share Content, you can click the Recalculate Availability button on the Intro sheet. That will cause the worksheet to calculate which crops are available during your season. From there you can then click Create Farm Plan to generate the calendar, seed bill, crop sheets, etc. In hindsight, I realize that I should clean up the Intro sheet to make it a bit clearer what the proper order of execution is.

Skandi Rogers wrote:Other comments, the finance shorthand PMT IRR etc are not known to me not will they be to many and looking at the PMT it assumes there is debt to be serviced?

Very good point. In this case the PMT is the annual loan payment on your startup costs. When designing the tool I assumed that I would have to take out a loan to finance my startup costs. I will clean up the Annual Plan sheet to make it a bit clearer as well.

Skandi Rogers wrote:It's fine for me as I am fairly used to spreadsheets but most of the other farmers I know use apps on their phone to track this type of thing and don't want to be coming in to the computer (I have only a dumb phone)

Interesting, I'll need to do some research on what sort of features the mobile apps carry.

Thanks again for your feedback. I'm planning a second release for this Saturday and will be recording a short video tutorial to showcase the tool's features.

In Singapore there aren't many opportunities to set up your own market garden, much less in the middle of our Covid lockdown. To fight quarantine-induced boredom and learn a bit about a new business idea, I began reading The Market Gardener by JM Fortier and Crop Planning for Vegetable Growers. Following along, I decided to build my own crop planning spreadsheet to model the economics and operations of a market garden farm. I finally have something halfway functional, so I thought I would share it with the Permies community for feedback.

In its current form, this tool organizes crop and planting season reference data and uses that to model the growing season for your farm. You can specify how much of each crop you want to deliver for your CSA shares, as well as customize the number of shares you're offering. The tool features an Annual Plan sheet which helps model some of the long-term financial performance of your farm. Once you have configured your CSA offerings, the tool can create a farm plan including seed bills, greenhouse and planting schedules, and a full field prep calendar for you to follow.

I want to emphasize that my background is in spreadsheets, not farming, so there is a lot of room for improvement. The two things that I'm hoping to get feedback on are the user-friendliness of the tool and whether its model lines up with the reality of farming. Please feel free to comment below with any bugs, questions, or suggestions!

Github Link: https://github.com/gtoleary5/MarketGardenCropPlanner/releases
Download the Source code .zip file and extract it to access the Excel workbook and ReadMe doc.

Hi everyone, I'm an American engineer who's working between HK and Singapore for the past few years. I first found out about permaculture coming from a systems design perspective and I'm trying to learn as much as I can before moving back to the US and (hopefully) starting a homestead. My day job is focused on information management and production planning, so that's what I've put most of my recent efforts towards. Right now I'm working on an Excel-based market garden planner heavily inspired by Frederic Theriault's and Daniel Brisebois' excellent book Crop Planning for Organic Vegetable Growers. I'm planning on releasing it in the next two weeks and would appreciate any comments or feedback from those with more experience than myself.

Other than that, I'm looking to learn from the community here and contribute in whatever ways I can. Covid lockdowns in Asia mean I've got more free time than I'm used to, so if anyone has any open-source permaculture projects, let me know!

Cheers,
Gavin