Tutorial for Spreadsheet Data Analysis
MS Excel Program for Physiology Students
D.E. Byrne & F. Bowser-Riley
Department of Biomedical Sciences, Marischal College
University of Aberdeen
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
- 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
Any problems with the software - email
Any problems with downloading - email
Compendium contents page