Square Foot Gardening Forum

Hello Guest!
Welcome to the official Square Foot Gardening Forum.
There's lots to learn here by reading as a guest. However, if you become a member (it's free, ad free and spam-free) you'll have access to our large vermiculite databases, our seed exchange spreadsheets, Mel's Mix calculator, and many more members' pictures in the Gallery. Enjoy.


Search
 
 

Display results as :
 

 


Rechercher Advanced Search

Latest topics
» Ground Cherries
by CapeCoddess Today at 3:24 pm

» New England March 2017
by CapeCoddess Today at 3:19 pm

» What are you eating from your garden today?
by sanderson Today at 2:50 pm

» New from OK City
by phoeg Today at 2:50 pm

» CANADIAN REGION: What are you doing in March 2017
by CapeCoddess Today at 12:32 pm

» Butterfly Junction
by countrynaturals Today at 11:56 am

» Squares under siege... by grass!
by has55 Today at 7:38 am

» Tomato Mystery Mix
by Avinash Today at 12:06 am

» How's the Weather Where You're At?
by TCgardening Yesterday at 9:46 pm

» New to SFG!
by TCgardening Yesterday at 9:39 pm

» N & C Midwest: March 2017 Brink of Spring
by CitizenKate Yesterday at 9:12 pm

» North Texas - Square Foot Garden
by Scorpio Rising Yesterday at 8:34 pm

» How can we save this tree?
by countrynaturals Yesterday at 2:30 pm

» Terrible News: Bumblebees In Trouble
by countrynaturals Yesterday at 1:18 pm

» Ontario - trying out SFG
by Kelejan Yesterday at 12:39 pm

» List of Forum Members with Blogs
by Cajun Cappy Yesterday at 12:31 pm

» SUGA 2017
by SQWIB Yesterday at 9:26 am

» Happy Birthday!!
by AtlantaMarie Yesterday at 8:42 am

» who has chickens
by sanderson 3/21/2017, 3:00 pm

» Rolling Boxes
by sanderson 3/21/2017, 2:50 pm

» Bok Choy
by Scorpio Rising 3/20/2017, 7:16 pm

» 2017 SFG in Brooks, Ga
by countrynaturals 3/20/2017, 11:53 am

» Need Plant Chart for Nighttime Lows
by Judy McConnell 3/20/2017, 10:55 am

» Collecting Rain Water - Come on Rain!
by newbeone 3/20/2017, 3:39 am

» Did I kill my strawberry plants
by bigdogrock 3/19/2017, 8:45 pm

» Carrot Week 2017!
by Turan 3/19/2017, 6:05 pm

» Gift Amaryllis
by countrynaturals 3/19/2017, 12:48 pm

» question about Garlic and winter
by GWN 3/19/2017, 10:41 am

» has55's R & D Journey:expanding my SFG to front yard
by AtlantaMarie 3/19/2017, 9:56 am

» Northern California & Coastal Valleys - What are you doing this month?
by sanderson 3/19/2017, 12:35 am

Google

Search SFG Forum

Does anyone use excel for maping their garden?

View previous topic View next topic Go down

Does anyone use excel for maping their garden?

Post  nursekat424 on 5/25/2010, 1:06 pm

was having fun maping out may garden in excel but havent really used it much so not sure how to do a few things. how do you lock or flatten the page so when you adjust the column/row the images change size also? i worked with it in a larger set up to see and edit better. now that i'm done i want to make it small enough to fit on 1 piece of paper. any tips for using excel would be appreciated. thanks a ton, Crystal
avatar
nursekat424

Female Posts : 74
Join date : 2010-04-28
Age : 38
Location : Detriot Lakes, MN

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  mckr3441 on 5/25/2010, 1:10 pm

ABSOLUTELY!

Couldn't funtion in this world without Excel. I used to teach Excel at our Community College! I'll check out your questions and post answers. Give me a day or so.

Claire
avatar
mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 77
Location : Cleveland Heights, Ohio (5b)

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  mckr3441 on 5/25/2010, 1:41 pm

Some questions for you and a couple of quick solutions:

  1. What version of Excel are you using?
  2. Which "view" are you working in -- Normal, Page Layout, Page Break Preview?
  3. Adjust size of image -- Are you inserting photos? After you change column/row sizes, adjust the size of the image independently by clicking on the image and using a corner to stretch or compact the image. Use the corner so you don't distort the pic.
  4. How much do you want to fit on one page? Select the print area by highlighting the rows/columns you want to include then -- on the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
  5. Then select print preview (ctrl + F2), then page setup. See "Fit to ___ page wide, ____ tall.
  6. You can adjust the VIEW of the page on your screen by going to the lower right corner where there is a slide bar for making the view bigger or smaller.

This should be a start for you. I'll wait to hear back.

Claire
avatar
mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 77
Location : Cleveland Heights, Ohio (5b)

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  Wyldflower on 5/25/2010, 2:12 pm

I'm actually using MS Word for my garden maps... what I did was make a table and set the Row height to 1" exactly, and the column width to 1", but I kept the text size at 10 points, which allows for six lines of type in each box. So then what I can do is type in the info in each cell that corresponds to a square in the garden. This way I really have 'squares' to look at, and there's enough space for variety, date of planting, how many per square and a few small notes.

My gardens are 4'x7' and 3'x6', so they fit on a single page with space to write extra notes outside the table

I'm also thinking of using the cell fill to indicate warm weather crops vs cool weather, by highlighting the cool boxes in a light blue and the warm in a light yellow.

My document is on my home computer, so I can't show you a picture now, but I will when I get home this evening.
avatar
Wyldflower

Female Posts : 530
Join date : 2010-03-21
Age : 65
Location : Colorado Springs, CO Zone 5b

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  nursekat424 on 5/25/2010, 4:07 pm



  1. What version of Excel are you using?
  2. Which "view" are you working in -- Normal, Page Layout, Page Break Preview?
  3. Adjust size of image -- Are you inserting photos? After you change column/row sizes, adjust the size of the image independently by clicking on the image and using a corner to stretch or compact the image. Use the corner so you don't distort the pic.
  4. How much do you want to fit on one page? Select the print area by highlighting the rows/columns you want to include then -- on the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.
  5. Then select print preview (ctrl + F2), then page setup. See "Fit to ___ page wide, ____ tall.
  6. You can adjust the VIEW of the page on your screen by going to the lower right corner where there is a slide bar for making the view bigger or smaller.



1- using 2007
2-page layout
3&4- already doing these.
5 didnt even think about the fit to page- a duh moment, lol
6- oh yay, i didnt know about that one. sweet. thanks so so so much.

now how do i make it as an single image or flatten it, not sure if i'm asking the right question. i want to be able to post it as a pic on here and face book. i use photoshop elements to scrapbook and in that you "flatten" it and save a copy as a jpeg. you cant modify it anymore but you can post and view it. this is the only way i can think to ask it.

you have been most helpful. not just on this, many of your past posts have answered gardening questions i didnt even know i had. lol
avatar
nursekat424

Female Posts : 74
Join date : 2010-04-28
Age : 38
Location : Detriot Lakes, MN

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  nursekat424 on 5/25/2010, 4:21 pm

using MS Word for my garden maps....My document is on my home computer, so I can't show you a picture now, but I will when I get home this evening.

i started to use word, but decided on excel since it is made for doing things like this. i love the versatlity with it but am still learning. i would love to see you document. i will post mine as soon as i figure out how. lol
i'm still learning the forum also. but i know i have def became addicted to it. it's so very useful and everyone is so helpful. thanks for replying.
avatar
nursekat424

Female Posts : 74
Join date : 2010-04-28
Age : 38
Location : Detriot Lakes, MN

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  chocolatepop on 5/25/2010, 4:24 pm

You can try uploading your file here:
http://www.rapidshare.com/
http://upload.megashare.com/
avatar
chocolatepop

Female Posts : 768
Join date : 2010-03-11
Age : 37
Location : Flint Area, Michigan (zone 5a-5b)

View user profile http://chocolatepopsurbangarden.wordpress.com/

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  mckr3441 on 5/25/2010, 4:48 pm

I'm trying out this process... I scanned a section of my Excel worksheet from last summer. I saved it as a jpeg file. Now I will try to upload it. The picture isn't very good though (if this even works) because my printer is nearly out of ink! Sorry.



Holy Cow! It worked! Hope this helps you. Thank you for the nice comments.

Claire
avatar
mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 77
Location : Cleveland Heights, Ohio (5b)

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  mckr3441 on 5/25/2010, 4:52 pm

Ooops! I forgot to say that first I printed it THEN scanned it!

Claire
avatar
mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 77
Location : Cleveland Heights, Ohio (5b)

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  nursekat424 on 5/25/2010, 4:58 pm

I scanned a section of my Excel worksheet from last summer.

so you actually printed it first from excel then scanned it it? i'm completely out of ink so that wont work. was hoping to copy/paste, save in a diff format, something. but i'm trying pdf format at the moment. maybe that will work. if not i might have 1 more trick up my sleave. lol. i'll let you know. and your welcome. i do enjoy reading the forums.
avatar
nursekat424

Female Posts : 74
Join date : 2010-04-28
Age : 38
Location : Detriot Lakes, MN

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  mckr3441 on 5/25/2010, 5:09 pm

Another try... Copied, then pasted to Word, then saved as a pdf. --- the upload won't take a pdf "File type not allowed."

What else can we try?

Claire
avatar
mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 77
Location : Cleveland Heights, Ohio (5b)

View user profile

Back to top Go down

yay - i figured it out

Post  nursekat424 on 5/25/2010, 5:18 pm

What else can we try?

got it!!!!!

ok here's the garden layout and garden key for it. here is how i got it from excel to a jpeg (with out printing and scanning). i opened my adobe photoshop elements program, but i imagine and photo editor program would work, i clicked file, open, the selected the pdf (i saved excel as a pdf). it showed the pages and some options to resize it. i chose something close a full she of paper, make sure to have the constrain image box selected (this prevents distortion). after that i went to file, save as, and saved as a jpeg. there is a little more to it than that. but that is the basics. if anyone wants more details let me know. also i will try to make it a jpeg straight from excel instead of saving as a pdf first. will update this after i try it.



this is my garden key



here is the layout
avatar
nursekat424

Female Posts : 74
Join date : 2010-04-28
Age : 38
Location : Detriot Lakes, MN

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  Ole Joe Clark on 5/25/2010, 5:19 pm

I made a simple excel spreadsheet to lay out my boxes. If I had a e-mail address I could send you a blank. PM me if you want a copy.

Leon
avatar
Ole Joe Clark

Male Posts : 46
Join date : 2010-03-08
Location : Alabama

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  Ole Joe Clark on 5/25/2010, 5:21 pm

I made a simple excel spreadsheet to lay out my boxes. If I had a e-mail address I could send you a blank. PM me if you want a copy.

Leon
avatar
Ole Joe Clark

Male Posts : 46
Join date : 2010-03-08
Location : Alabama

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  mckr3441 on 5/25/2010, 5:22 pm

SUPER! Great solution and GREAT garden plan. Also, great working with you.

Claire
avatar
mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 77
Location : Cleveland Heights, Ohio (5b)

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  nursekat424 on 5/25/2010, 5:25 pm

the file has to be saved as a pdf first, btw you should be able to "save as" in excel and save as pdf from there, well at least in excel 2007 you can, dont know about older versions. and i have a cpl other photo editor programs on my pc, will try and see if it can be done with them as well. wow this has been a learning experience for me. thanks for your help.

also what am i doing wrong with the quote function. i see i'm not doing something right. lol
avatar
nursekat424

Female Posts : 74
Join date : 2010-04-28
Age : 38
Location : Detriot Lakes, MN

View user profile

Back to top Go down

Re: Does anyone use excel for maping their garden?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum