market-farming AT lists.ibiblio.org
Subject: Market Farming
List archive
- From: Jen and Derek Campbell <jenanddereksfarm AT gmail.com>
- To: Market Farming <market-farming AT lists.ibiblio.org>
- Subject: Re: [Market-farming] Crop planning software
- Date: Thu, 26 Jan 2012 10:50:24 -0400
Great ideas and responses to this, thanks everyone. Kathryn, your system is pretty impressive.
Derek and I have been playing around with spreadsheets and are getting close to figuing out how to link all the sheets better. I'll post what we figure out when we're all done.
Jen
On Wed, Jan 25, 2012 at 10:23 AM, <KAKerby AT aol.com> wrote:
Excellent observation. I didn't do that on mine, and it would have made year-to-year maintenance a whole lot easier. Maybe I'll start a "improvements to be made" file for Master Calendar 2.0 in 2013. But it's planting season now, so that particular task will have to wait. Funny how winter seems so long sometimes, yet winter projects just sort of all suddenly take a back seat at the end of January.Kathryn KerbySnohomish, WARuminations - essays on the farming life at frogchorusfarm.com/weblog.htmlIn a message dated 1/25/2012 6:04:29 A.M. Pacific Standard Time, farmer AT twoonionfarm.com writes:I have one specific comment on interlinking lots of Excel worksheets
within one file. If you have a number such as the number of CSA members
which you would like to change in one place and then have the changes
apply to lots and lots of formulas in the file, you should consider
defining a "name" (such as NumberOfCSAMembers) for the one cell with the
number of CSA members and then refer to that name in all of your other
formulas. You can look up in the Excel help how to define and use
names. It's pretty simple, it makes your formulas much easier to type
and understand, and your formulas will stay the way you want them when
you move, copy, paste, fill cells, etc.
Chris
On 1/25/2012 4:47 AM, market-farming-request AT lists.ibiblio.org wrote:
Date: Tue, 24 Jan 2012 13:16:29 -0400
From: Jen and Derek Campbell<jenanddereksfarm AT gmail.com>
Subject: Re: [Market-farming] Crop planning software
To: Market Farming<market-farming AT lists.ibiblio.org>
Message-ID:
<CAOQzSqFheWjmmaTvi1_=igm48bSxg8P8k8G9CDM1zVAzs=HmtA AT mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
thanks Richard. I've been using an open source version of Microsoft Excel
for the past 5 years and had bought the crop planning book last year as it
seemed really highly reccomended. What I'm finding however is that the
spreadsheet templates they give do not have formulas and I'm having trouble
linking sheets. My vision is that if all sheets are property linked that
next year when I change the amount of CSA members I have that sheets will
automatically calculate the proper information. The book seems to want you
to copy and paste data which is fine for this year but when the CSA numbers
or restaurant projections change I'll have to recopy and paste all over
again. Maybe what I should have asked for in the last e-mail was a good
spreadsheet tutorial website!! thanks again for the response,
jen
_______________________________________________
Market-farming mailing list
Market-farming AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/market-farming
Market Farming List Archives may be found here:
https://lists.ibiblio.org/sympa/arc/market-farming/
Unsubscribe from the list here (you will need to login in with your email
address and password):
http://lists.ibiblio.org/mailman/options/market-farming
_______________________________________________
Market-farming mailing list
Market-farming AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/market-farming
Market Farming List Archives may be found here:
https://lists.ibiblio.org/sympa/arc/market-farming/
Unsubscribe from the list here (you will need to login in with your email
address and password):
http://lists.ibiblio.org/mailman/options/market-farming
--
Jen and Derek Campbell
579 MacMurdo Road
North Bedeque
PE C1N 4J9
-
Re: [Market-farming] Crop planning software
, (continued)
-
Re: [Market-farming] Crop planning software,
rstewart AT zoomtown.com, 01/24/2012
-
Re: [Market-farming] Crop planning software,
Jen and Derek Campbell, 01/24/2012
-
Re: [Market-farming] Crop planning software,
Etienne Goyer, 01/24/2012
-
Re: [Market-farming] Crop planning software,
Beth Spaugh, 01/24/2012
- Re: [Market-farming] Crop planning software, Etienne Goyer, 01/24/2012
-
Re: [Market-farming] Crop planning software,
Beth Spaugh, 01/24/2012
-
Re: [Market-farming] Crop planning software,
Etienne Goyer, 01/24/2012
-
Re: [Market-farming] Crop planning software,
Jen and Derek Campbell, 01/24/2012
- Re: [Market-farming] Crop planning software, KAKerby, 01/24/2012
-
Re: [Market-farming] Crop planning software,
KAKerby, 01/25/2012
- Re: [Market-farming] Crop planning software, Roots Farm, 01/25/2012
- Re: [Market-farming] Crop planning software, Two Onion Farm, 01/25/2012
-
Re: [Market-farming] Crop planning software,
KAKerby, 01/25/2012
- Re: [Market-farming] Crop planning software, Jen and Derek Campbell, 01/26/2012
-
Re: [Market-farming] Crop planning software,
KAKerby, 01/26/2012
- Re: [Market-farming] Crop planning software, Road's End Farm, 01/26/2012
- Re: [Market-farming] Crop planning software, Richard Robinson, 01/26/2012
- Re: [Market-farming] Crop planning software, KAKerby, 01/26/2012
-
Re: [Market-farming] Crop planning software,
rstewart AT zoomtown.com, 01/24/2012
Archive powered by MHonArc 2.6.24.