Before every meeting, I often see the VPEs or secretary went thru what I call a “cyclical drudgery” of preparing a meeting rundown:
1) call up speakers to take up assignments
2) typing away new meeting rundown
3) accommodating any last-minute changes in the rundown.
This process often takes hours, if not an entire day - think how much hassle the VPEs has to go through for a club with weekly meeting!
In dozens of Toastmasters clubs that I visited, 100% of the clubs that I’ve visited used Word processing software as an rundown write-up platform. Despite being easy to use, however, Word Processing software doesn’t offer much formulating capabilities unless specifically programmed to do so. Inside the same software package, however, we can find spreadsheet software. Inside spreadsheet, another opportunity unfolds – with simple built-in tools, rundown write up can be easily automated - all that is required are a few quick and simple techniques.
Here I’ve a 5 minutes one-off spreadsheet trick that helps listing accurate timing on a reusable meeting rundown. This trick can be learn about anyone, even Toastmasters with no spreadsheet experience. After several minutes, you and your club then enjoy the long lasting benefit of rapid rundown creation!
Several common spreadsheets software are Microsoft Excel, Lotus 123, WordPerfect Quattro Pro and OpenOffice.org Calc. I use OpenOffice.org Calc (Calc) as demonstration for the following example. The working is almost identical for all other spreadsheet operations, I choose Calc for demonstration since it is open sourced software, which means there is no propriety right and everyone can download and use it for free. You can download a copy of the OpenOffice.org suite by typing in http://www.openoffice.org in your internet browser.
After Installing OpenOffice.org, double click into the Calc icon to open the application.

Make sure that your rundown is on the spreadsheet application.
Before we begin modifying our actual rundown, let us first go through the basics as to what makes time calculation possible in our meeting rundown.
In another worksheet under the same file, type in a time. For example, if your agenda is on “Sheet 1”, type in the time in “Sheet 2”
Whenever we type in a time, Calc automatically convert it into a default time format.
Date and time can be calculated in all spreadsheet programs.

First, we need more understanding of the number format of spreadsheet programs.
To see the numeric format for the time listed in the spreadsheet, selecting the cell where we have typed in the time, then click Format menu and click Cells.

The time format being use will be shown under the Number tag in the Format Cells window.

Now, if we select Number under the category window, you’ll see that all time that you type in can be converted into a number.

Spreadsheet program use the numeric value as shown in our preview box to recognize and calculate time difference. A good way to remember all time calculation is that the value 1 equals 1 day.

To find out how hours, minutes and seconds are calculated, simple divide 1 by the respective hours, minutes and seconds.
The result will be as shown on figure 3.1. For best result, type all numeric value for the seconds, minutes and hour in a worksheet different from the one we used for our rundown to ensure the presentation of our rundown. Or to change text to white/hide it.
Now we can work on our actual rundown.
In the worksheet that contains the rundown, type in the starting time and the duration of the first program of your meeting.
We can calculate the start time for the next program using the following calculation circled as on figure 5.1.

To calculate, simply type in the following formula above the spreadsheet in the circled location call “Formula bar”:
= Cell name of start time + cell name for the duration of the program in the ‘minute’ * cell name where the numeric format of the minute was listed.

In my example, I have written the minute’s numeric format on another worksheet and I have also cross referenced the formula with it.

Later on we’d need to copy the formula to the location in the starting time.
To ensure that the formula will always refer to same location where our numeric value for the minutes locate, we’d need to click on the value in the formula bar, and then press SHIFT+F4 once (press F4 for Microsoft Excel user).
Dollar signs appear in front of the cell name which fixated the value to its location regardless of how we copy the formula.

The last step we need to do is to fill in the blanks for program minutes, then we copy the formula on the starting time column by dragging the cell down from the bottom right hand side of the selection.
In my example here, I click on B15, mouse click on its bottom right hand corner and drag until the end of the agenda.
There, we’ve got the job done!