Author Topic: Spreadsheet for cropping  (Read 4933 times)

mat

  • Hectare
  • *****
  • Posts: 826
  • Ryedale, North Yorks. Sandy loam, over sandstone
Spreadsheet for cropping
« on: January 10, 2006, 12:53:11 »
Due to the number of personal emails I have had requesting to see my spreadsheet I mentioned, I have now created a modified version for yourselves.  I am unable to find a way of attaching it here, so if you wish to see a copy, please email myself on lottieholder@tiscali.co.uk.  (I will upload it to a website soon)  It is large - 3.5MB.

The spreadsheet allows you to enter crop details and work out the total length of "bed space" required, depending upon the "yield" you require.  It also shows how much spare space is available for each "rotation".  It also monitors costs and suppliers.  The whole thing is customisable for yourself and is currently unprotected. 

I don't know how it compares to others, but you are welcome to have a look.  Others may be better/more advanced

It does rely on some Excel knowledge.  I have written instructions though.

Pleae note, this is a Beta version (version 1)  and is currently quite manual/basic as I wrote it for my own purposes.  If you find any defects or need further instructions, or have any suggestions for future releases, please let me know.  I have in my own copy with further functionality, currently "work in progress"


Not sure which area to post this in, so decided on the "basics" area.  If this is wrong, let me know, ro move it  ::)

Enjoy!
mat

mat

  • Hectare
  • *****
  • Posts: 826
  • Ryedale, North Yorks. Sandy loam, over sandstone
Re: Spreadsheet for cropping
« Reply #1 on: January 10, 2006, 12:58:11 »
Update on size - now just over 2MB and zipped up is only 41k.  You will need winzip though if you want the zipped version

mat

mat

  • Hectare
  • *****
  • Posts: 826
  • Ryedale, North Yorks. Sandy loam, over sandstone
Re: Spreadsheet for cropping
« Reply #2 on: January 10, 2006, 20:49:13 »
Update on size - now just over 2MB and zipped up is only 41k.  You will need winzip though if you want the zipped version

mat

If you email me, please let me know which version you'd like (they are the same; the zipped version just relies on you having winzip or equiv to unzip it...)  those of you who have already emailed me and not stated which, I have sent you an email to ask you!

mat.

mat

  • Hectare
  • *****
  • Posts: 826
  • Ryedale, North Yorks. Sandy loam, over sandstone
Re: Spreadsheet for cropping
« Reply #3 on: February 08, 2006, 18:33:33 »
I have emailed many copies now (not counted yet!)  I know I have a few more to email out, and that some of you have not heard back over the last two weeks, but My father had a serious accident recently and the prognosis is that if he is lucky, he may start learning to walk again in a years time... and I found out a few days back that I need to go into hosp tomorrow for a small op, so will not be near a PC for a few days. 

So, please bear with me and if you have not heard from me by next Friday, please send me another email as I may have "lost" your email. 

I am very glad to hear any feedback from those of you with suggestions or who have found it useful (especially the person who with the spreadsheet managed to avoid planting a potential huge carrot glut...)

Now signing off.
mat

adam04

  • Hectare
  • *****
  • Posts: 725
  • Who are you?
    • FedEx VG
Re: Spreadsheet for cropping
« Reply #4 on: February 08, 2006, 18:37:41 »
if i send you an email, send me the thing and i can pt the zipped version on a site, so it can be downloaded.

Zippy Seale

  • Half Acre
  • ***
  • Posts: 151
  • Laughing all the way to the plot
    • The Cherry Tree Plot
Re: Spreadsheet for cropping
« Reply #5 on: February 08, 2006, 18:58:37 »
Zip files  can be expanded with stuffit as well  ;D ;D ;D
For us Mac users  :P :P :P
they say it wouldn't grow.....ha

The Cherry Tree Plot

Art of Sowing

lorna

  • Hectare
  • *****
  • Posts: 7,837
  • March. Cambridgeshire
Re: Spreadsheet for cropping
« Reply #6 on: February 08, 2006, 18:59:33 »
Mat. Just to say how sorry I was to hear about your father's accident. My best wishes to him and all your family. Lorna.

Admin aka Dan

  • Administrator
  • Hectare
  • *****
  • Posts: 1,676
    • Allotments 4 All
Re: Spreadsheet for cropping
« Reply #7 on: February 08, 2006, 19:17:22 »
Mat,

I am happy to place the spreadsheet on the server to save you some hastle, you could then publish the link.

I can possibly give you ftp access to upload new versions as well.

Let me know.

And I hope all works out for you and your father.

Cheers

Dan

adam04

  • Hectare
  • *****
  • Posts: 725
  • Who are you?
    • FedEx VG
Re: Spreadsheet for cropping
« Reply #8 on: February 08, 2006, 20:49:05 »
if anyone ever got the spreadsheet, would they please send it me, rather than letting mat mess around, as it looks like she has lots o her plate.

MikeB

  • Hectare
  • *****
  • Posts: 936
  • Harleston, Norfolk
Re: Spreadsheet for cropping
« Reply #9 on: February 09, 2006, 07:47:25 »
Hi Adam04,

I've emailed you a copy of the spreadsheet.  Dan would you also like a copy?

Regards

MikeB

flowerlady

  • Hectare
  • *****
  • Posts: 1,422
  • "Tug-o-Weeed!"
Re: Spreadsheet for cropping
« Reply #10 on: February 09, 2006, 09:21:06 »
would this be a good topic for the wiki pages?  :)
To everything there is a season and a time to every purpose under heaven: a time to be born and time to die: a time to plant, and a time to pluck up what is planted.     Ecclesiastes, 3:1-2

MikeB

  • Hectare
  • *****
  • Posts: 936
  • Harleston, Norfolk
Re: Spreadsheet for cropping
« Reply #11 on: February 09, 2006, 09:23:01 »
How do you add a spreadsheet to a wiki?

MikeB

Admin aka Dan

  • Administrator
  • Hectare
  • *****
  • Posts: 1,676
    • Allotments 4 All
Re: Spreadsheet for cropping
« Reply #12 on: February 09, 2006, 09:30:36 »
Hi Adam04,

I've emailed you a copy of the spreadsheet.  Dan would you also like a copy?

Regards

MikeB

Mike, thanks, that would be good.

I'll not publish it though, unless mat says it is OK.

Cheers

Dan

Admin aka Dan

  • Administrator
  • Hectare
  • *****
  • Posts: 1,676
    • Allotments 4 All
Re: Spreadsheet for cropping
« Reply #13 on: February 09, 2006, 09:32:12 »
would this be a good topic for the wiki pages?  :)

I'm going to add a file are to the site, where we can all upload and download usefull files.

Once it is working I'll post a link to it!

Cheers

Dan

flowerlady

  • Hectare
  • *****
  • Posts: 1,422
  • "Tug-o-Weeed!"
Re: Spreadsheet for cropping
« Reply #14 on: February 09, 2006, 09:42:56 »
;D ;D ;D that will be fantastic, thank you ALL so much  ;D ;D ;D
To everything there is a season and a time to every purpose under heaven: a time to be born and time to die: a time to plant, and a time to pluck up what is planted.     Ecclesiastes, 3:1-2

MikeB

  • Hectare
  • *****
  • Posts: 936
  • Harleston, Norfolk
Re: Spreadsheet for cropping
« Reply #15 on: February 09, 2006, 09:46:29 »
Hi Dan,

I've sent it.

MikeB

kenkew

  • Hectare
  • *****
  • Posts: 4,336
  • Don't look now but...
Re: Spreadsheet for cropping
« Reply #16 on: February 09, 2006, 14:25:25 »
Well done, Mike. Seems Mat has a lot to deal with at the moment. Could you forward me a copy, please, and thanks and best wishes to Mat at this time.
Ken.
kenkew@hotmail.com

adam04

  • Hectare
  • *****
  • Posts: 725
  • Who are you?
    • FedEx VG
Re: Spreadsheet for cropping
« Reply #17 on: February 09, 2006, 16:45:36 »
download zipped version here

will sort out the instructions asap
« Last Edit: February 10, 2006, 15:32:01 by adam04 »

Jimmy

  • Quarter Acre
  • **
  • Posts: 64
Re: Spreadsheet for cropping
« Reply #18 on: February 10, 2006, 10:25:37 »
Link not working - there was an additional '/' before domain name which when removed allowed access to home page. Alas, not to link.

Any chance of this being mailed?

Jim

Dirkdigger

  • Hectare
  • *****
  • Posts: 558
Re: Spreadsheet for cropping
« Reply #19 on: February 10, 2006, 10:39:27 »
Just downloaded it, works fine at this address
http://baronroadallotments.50webs.com/Vegetables_allotment_template.zip
A big thank you Mat for all your hard work and sharing of file.
Hope you and your dad are well.
DD

 

anything
SimplePortal 2.3.5 © 2008-2012, SimplePortal