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
» Butterfly Junction
by trolleydriver Today at 8:01 am

» Holy snow Batman!
by MrBooker Today at 7:27 am

» Garlic: Freeze, thaw, and heave
by camprn Today at 7:05 am

» Happy Birthday!!
by AtlantaMarie Today at 6:10 am

» CANADIAN REGION: What are you doing December 2016
by Kelejan Today at 12:36 am

» Garbanzo (Chickpeas, Cicer arietinum) and Kidney Beans
by BeetlesPerSqFt Yesterday at 11:28 pm

» Northern California & Coastal Valleys - What are you doing this month?
by countrynaturals Yesterday at 10:43 pm

» What are you eating from your garden today?
by Scorpio Rising Yesterday at 9:43 pm

» Second Year SFG in Canada
by trolleydriver Yesterday at 9:41 pm

» N&C Midwest: December 2016
by Scorpio Rising Yesterday at 9:18 pm

» CHALLENGE - Smallest possible footprint
by Kelejan Yesterday at 5:19 pm

» TrolleyDriver's Compost Thermometer
by trolleydriver Yesterday at 4:51 pm

» GF Collard Greens, Kale Recipes
by BeetlesPerSqFt Yesterday at 12:49 pm

» 2016 SFG in Brooks, Ga
by sanderson Yesterday at 11:48 am

» Tomato Tuesday 2016
by llama momma 12/6/2016, 4:35 pm

» New England, December 2016
by CapeCoddess 12/6/2016, 3:27 pm

» Bon fires on the Levee
by Cajun Cappy 12/6/2016, 12:17 pm

» Mid-South: December 2016
by Scorpio Rising 12/5/2016, 10:26 pm

» Mid-Atl - Dec 2016 - Seed Catalog ?
by Scorpio Rising 12/5/2016, 10:24 pm

» Gardening in Central Pennsylvania
by Scorpio Rising 12/5/2016, 10:21 pm

» 1st Seed Catalog Arrived :)
by Scorpio Rising 12/5/2016, 10:15 pm

» Amaranth
by countrynaturals 12/5/2016, 12:06 pm

» Live and learn
by jimmy cee 12/5/2016, 9:08 am

» AtlantaMarie's Garden
by countrynaturals 12/4/2016, 2:04 pm

» Mychorrhizae Fungi
by audrey.jeanne.roberts 12/4/2016, 1:28 pm

» December 2016 Avatar: Show your Winter Season Colors!
by Scorpio Rising 12/3/2016, 11:17 pm

» SFG not giving the results I expected
by No_Such_Reality 12/3/2016, 7:21 pm

» New Member
by trolleydriver 12/3/2016, 4:14 pm

» First season SFG results / lessons learned
by countrynaturals 12/3/2016, 10:36 am

» Eat Broccoli Leaves? Brussels Sprouts? Cauliflower?
by sanderson 12/3/2016, 2:55 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

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

mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 76
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

mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 76
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.

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

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.

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/

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

mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 76
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

mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 76
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.

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

mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 76
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

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

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

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

mckr3441

Certified SFG Instructor

Female Posts : 765
Join date : 2010-03-05
Age : 76
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

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 Today at 9:24 am


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