From the category archives:

Spreadsheets in Gardening

Using spreadsheets in garden planning: Part 4

January 21, 2007

In part 3 I showed how to put the finishing touches on a spreadsheet that calculated the potential cost of a plant order in progress. But because of its tabular format, a spreadsheet is often used in situations where a lot of information needs to be organized, even if no calculations are made. Below are [...]

0 comments Read the full article →

Using spreadsheets in garden planning: Part 3

January 20, 2007

In our last part we had finished entering data and were getting ready to sum up. Actually it’s best to create this autosumming Subtotal before you enter much data. That way, you have a good idea how much your wishlist is costing you as you go along.
Creating a Subtotal
The first thing you need to do [...]

1 comment Read the full article →

Using spreadsheets in garden planning: Part 2

January 17, 2007

In part 1 we logged into Google Spreadsheets and got things set up. Now let’s get this thing to do some work for us.
Creating the Formula
We’re going to teach this worksheet to multiply the price of a plant by the number of plants we want to give us the total price. The end result will [...]

4 comments Read the full article →

Using spreadsheets in garden planning: Part 1

January 16, 2007

I mentioned in a recent post that I use a spreadsheet to plan my garden purchases. Others have mentioned using a spreadsheet to track their seed sowing. But that doesn’t help you much if you don’t know a spreadsheet from a tablecloth, so let’s start right there: a spreadsheet is a computer program that arranges [...]

9 comments Read the full article →