Allotments 4 All

Allotment Stuff => The Basics => Topic started by: mat on January 10, 2006, 12:53:11

Title: Spreadsheet for cropping
Post by: mat 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
Title: Re: Spreadsheet for cropping
Post by: mat 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
Title: Re: Spreadsheet for cropping
Post by: mat 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.
Title: Re: Spreadsheet for cropping
Post by: mat 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
Title: Re: Spreadsheet for cropping
Post by: adam04 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.
Title: Re: Spreadsheet for cropping
Post by: Zippy Seale 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
Title: Re: Spreadsheet for cropping
Post by: lorna 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.
Title: Re: Spreadsheet for cropping
Post by: Admin aka Dan 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
Title: Re: Spreadsheet for cropping
Post by: adam04 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.
Title: Re: Spreadsheet for cropping
Post by: MikeB 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
Title: Re: Spreadsheet for cropping
Post by: flowerlady on February 09, 2006, 09:21:06
would this be a good topic for the wiki pages?  :)
Title: Re: Spreadsheet for cropping
Post by: MikeB on February 09, 2006, 09:23:01
How do you add a spreadsheet to a wiki?

MikeB
Title: Re: Spreadsheet for cropping
Post by: Admin aka Dan 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
Title: Re: Spreadsheet for cropping
Post by: Admin aka Dan 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
Title: Re: Spreadsheet for cropping
Post by: flowerlady on February 09, 2006, 09:42:56
;D ;D ;D that will be fantastic, thank you ALL so much  ;D ;D ;D
Title: Re: Spreadsheet for cropping
Post by: MikeB on February 09, 2006, 09:46:29
Hi Dan,

I've sent it.

MikeB
Title: Re: Spreadsheet for cropping
Post by: kenkew 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
Title: Re: Spreadsheet for cropping
Post by: adam04 on February 09, 2006, 16:45:36
download zipped version here (http://baronroadallotments.50webs.com/Vegetables_allotment_template.zip)

will sort out the instructions asap
Title: Re: Spreadsheet for cropping
Post by: Jimmy 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
Title: Re: Spreadsheet for cropping
Post by: Dirkdigger 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
Title: Re: Spreadsheet for cropping
Post by: Jimmy on February 10, 2006, 15:19:24
Accessed fine from home, really appreciated as gauging some of this can result in a tad too much (bucket loads!) of one thing or another.

Echo the sentiments of others regarding you and your Dad as well,

Jim
Title: Re: Spreadsheet for cropping
Post by: adam04 on February 10, 2006, 15:30:26
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

hey, sorry about that, put too many / in.  try it again and it should work.
Title: Re: Spreadsheet for cropping
Post by: MrsKP on February 10, 2006, 21:24:48
:o

I opened it and closed it again very quickly !!!!  I'm only just getting to grip with loo roll pots and this nearly freaked me out.  I'm going to have a lie down in a dark room with my seeds and try again when I feel a bit braver.

It looks very well thought out though and a big "well done you" to mat and all those involved getting the thing to the board.

Sorry to hear of all your troubles mat.  I hope things get better for you and your family very quickly.
Title: Re: Spreadsheet for cropping
Post by: mat on February 11, 2006, 12:23:37
Hi

Thanks for all the emails and offers of hosting.  I am now out of hospital and at home, but dad won't be for a long time.  Thanks to those of you for hosting the spreadsheet; I hadn't uploaded it to a site yet, in case there were any major bugs I wished to know who had a copy.  However, that has not been required and I think it is pretty stable as I have made no changes for quite a while (only changes were instructions.)  I will upload it to my site next week (I need to re-install Frontpage)  I don't mind others hosting the SS until I have uploaded it, but once I have, it may be easier for version control for it to be in one location only!!!

Mrs KP - It does look complicated at first, but it will get easier! 

The spreadsheet is there to help anyone; it was created over the last two years and I don't even suggest it is perfect - all suggestions and future improvements gratefully received.

mat
Title: Re: Spreadsheet for cropping
Post by: Admin aka Dan on February 12, 2006, 15:55:41
mat (and eveyone else)

I've plaecd the zip file in the downloads section,

http://www.allotments4all.co.uk/joomla/component/option,com_docman/Itemid,60/

Please help yourselves!

Cheers

Dan
Title: Re: Spreadsheet for cropping
Post by: powerspade on February 12, 2006, 18:10:59
I`ve tried to dwnload but it does not open  :(
Title: Re: Spreadsheet for cropping
Post by: mat on February 12, 2006, 18:14:09
Thanks Dan

Powerspade, I have just looked and it downloads and opens for me.  Do you have winzip (or equivalent)? If not, download winzip...

mat
Title: Re: Spreadsheet for cropping
Post by: Admin aka Dan on February 12, 2006, 22:02:41
I`ve tried to dwnload but it does not open  :(

Hi,

Does the file download to your computer, or can you not download it at all?

Dan
SimplePortal 2.3.5 © 2008-2012, SimplePortal