Click here to display our home page

Lesson Ideas
Main Events
Putting Time In Perspective

Spreadsheets for Calculating Where Events Fall

I've developed an Excel spreadsheet for doing the calculations in this activity.  You can download it in either Excel 97 or Excel 5/95 format.  If you are unable to open spreadsheets in either of these formats, e-mail me.  In your message tell me what spreadsheet you have, and what formats you can open.  If I can convert my sheet to one that you can use, I will do so and e-mail the file back to you.

The spreadsheet includes instructions as well as macros to simplify most tasks.  If you have any questions about it or problems with it, please e-mail me  your question or a description of your problem. I'll get back to you as soon as I can.

Click here to view a GIF image of the spreadsheet as it looks when running in Excel 97.  (This image will open in a standalone browser window.  Close it without exiting your browser to return to this window.)

When you are ready to download the spreadsheet

To download one of the files below, right click on its link then choose Save Target As and specify the location to which you want it saved. You may also click on the file's link. If you have Quick View+ installed on your computer, you will see an error message; choose the Save option it gives you, then save the file to a folder on your hard drive from that window. If you do not have this viewing program installed, a small window should open. One of the options presented should be to save the file. Click on that option. You should then be prompted to specify where on your hard drive you want to save the file. Put it in the folder where you save and open Excel spreadsheets. Once the file has completed downloading, the small window will close on its own.

Click here for the Excel 97 sheet (timevu97.xls)

Click here for the Excel 5/95 sheet (timevu95.xls)

return to the Putting Time In Perspective page

copyright 1998-2008 All Rights Reserved.
original web posting: Wednesday, September 9, 1998
last modified: Thursday, April 10, 2008