Snapshots of Spreadsheets
Just a quick note. I hope it’s obvious. With examples in this book I’m not going to show you the full columns of the spreadsheets, because that’s awkward. Numbers would have to get very small. I use my spreadsheets for sales forecast and other normal monthly projections with a standard layout.
I base this on the standard spreadsheet layout as used in Microsoft Excel, Lotus 1-2-3, Apple Works, Quattro Pro, and even the true pioneer, Visicalc, the first spreadsheet, from 30 years ago. The rows are labeled from 1 to whatever, and the columns are labeled from A to whatever. When you get past the 26 letters of the alphabet you start over again, with AA, AB, AC, etc.
| Labels in column A | Special uses for column B | 12 months monthly in columns C-N | Annual Columns as needed. |
| I run the labels along the lefthand side. This is like sales, expenses, profits, etc. | I keep column B open for variables like growth rates and such. This is convenient for starting balances too. | My months go off towards the right, one by one, in 12 columns. | The first year picks up the numbers from the 12 months. Then come the additional years as needed. |