- #Garden tracker spreadsheet how to#
- #Garden tracker spreadsheet software#
- #Garden tracker spreadsheet series#
You can ungroup, regroup, or group with other shapes/groups as needed. To do this select two or more shapes, right click and go to GROUP. If you create a scene that involves a lot of shapes (like the patio, or a table and chairs set) it is convenient to group them together so you can move them as one item.To move things you can use your mouse or for finer movements use your arrow keys. You only have to do the first few, cut and paste after that.
#Garden tracker spreadsheet series#
For example for the patio pattern, I made a series of rectangles, sized them, filled them in with texture then placed them to look like patio stones. Next I colour in any details I want in the plan. You can also double click on the shape, go to the SIZE box and you will see a rotation box - just enter a number eg 90 to rotate right 90 degrees.
You can rotate a shape once you make it in either of two ways: click on the shape & if you have a green dot you can just drag it around until you like it’s placement. If you fill you will have to be careful of the “order” of your objects (we’ll get into that in a bit). You can fill or not fill your beds as you desire. Than I delete the circle when I am happy. 
Put it along side your curve and now make your points follow the curve. I place a circle shape on the grid, size it (double click a shape and you can get very precise using the SIZE box).
To make nice curves I make a temporary circle and follow the pattern. Under view zoom in fairly large, this makes editing easier. For fancier editing, right click your mouse on one of these points and you will see a lot more options - you can delete a point, open up a curve you closed, make a segment between points straight or curved. Also you can pick up any spot on the line and make a new point. You can literally pick these up and move them around. You will now see a series of small black squares marking every spot where you clicked on your graph paper. Now that you have your rough bed shape drawn, right click on the shape (sometimes you have to be right on the line) and select EDIT POINTS. If you need to close in your shape (eg a stand alone bed) curve back to the starting point and DOUBLE CLICK and it will automatically close your shape. Don’t worry if it’s rough - you can adjust the shape later. Everywhere you click you get a point anchored to your plan. Now just draw your shape in by clicking on your grid paper, keep clicking along the way. To make curved beds I use the curve line option under autoshapes. You can select lines, arrows, squares, circles and a huge variety of shapes under AUTOSHAPES. I use the features in the drawing toolbar to do this. Next I draw in the hardscapes (house, patio, etc) and basic bed shapes. You now have a spreadsheet that looks like graph paper with measurements down the top and left side. Put your measurement scale along the top and along the left. For my purposes I count one square as 2 feet but it could be anything you want depending on how big the garden is you are drawing. Each square now represents your scale. Make as many columns and rows this scale as you think you will need. Looking at my saved sheets they say the column width is 2 and the row height is 14.5. I do this by changing the column width and row heights so they look like grid paper. 
Start by making a grid in your Excel worksheet.Step 1: Create a gridīasically I use an Excel spreadsheet like it is graph paper and just draw out my plan to scale.
#Garden tracker spreadsheet how to#
You can even track information about your plants in the sheet if you like to.īelow are some simple instructions on how to draw a garden design plan without using special garden design software. The end result can give you a plan of your garden as well as a useful plant list.
I eventually found that it was easier to use an Excel spreadsheet by treating it like graph paper and combining this with the many autoshape tools in Excel. Many of them were very cumbersome or too limited for what I wanted.
#Garden tracker spreadsheet software#
I experimented with quite a few different garden design software packages.
0 kommentar(er)
