Tutorial for Spreadsheet Data Analysis

MS Excel Program for Physiology Students

The software is contained in BMSEXCEL.EXE (a PC self-extracting archive). The archive file contains Excel macros for both Mac and PC versions of MS Excel. You will need to have Excel version 4.0 or higher installed on either your Mac or PC in order to run these macros.

To install the software:

1. Download BMSEXCEL.EXE by clicking on the filename at the bottom of this page.

Type the following:

BMSEXCEL -d -n <return>

This will unpack the files into 2 directories on the disk:

XLDEMOS and MACEXCEL, each containing 4 files:

GLOBAL.XLM, TOOLBKEG.XLW, RESPDEMO.XLW and MEDBOOK.XLW.

2i. On a PC:

Start up WINDOWS File Manager.

a. copy xldemos\global.xlm to c:\excel\xlstart

b. copy the xldemos directory to c:\excel

c. open c:\excel\xldemos

d. double-click on any of the three .xlw files to run.

2ii. On a Mac (with system 7 or higher), copy the files from the PC onto a floppy disk and then:

Start up Excel.

a. From Excel File menu, open untitled:MACEXCEL:GLOBAL.XLM

b. Save this sheet in the Excel Startup Folder (within the Preferences folder in the System folder on your Mac's hard disk) with the name GLOBAL.XLM.

c. switch back to Finder (or close Excel)

d. Double click on the floppy icon (untitled) on your desktop and copy all .XLW files from untitled to the Excel folder on your Mac.

e. switch back to Excel (or re-start Excel) and open any of the three new .xlw files to run.

These files were developed on the PC version of Excel at a screen resolution of 800x600pixels.

You will need this file:

The files that you will need are all archived in BMSEXCEL.EXE.

Make sure that your software is correctly configured to download to disk (BUT NOT TO RUN .EXE FILES IMMEDIATELY) and then click on the filename.

bmsexcel.exe (150595 bytes)

Any problems with the software - email

Any problems with downloading - email

Compendium contents page