Topic Description
Originally done by hand on paper these spreadsheets started in DOS Lotus 123
and were ported to SuperCalc5 and eventually Mesa2. Salesbook and Cashbook (for
a travel agency) have gradually evolved over eighteen years as the business grew.
This session will show an integrated collection of spreadsheets that are
structured to meet the requirement of Canadian and Ontario legal and tax reporting
requirements. Supporting dual, Canadian and American currencies these sheets rely
heavily on Mesa2 scripts to ease the process of maintaining accounts and
commissions receivable. Session attendees will be taught the use of primary and
secondary data entry, script creation and execution, and how to create formulas
across multiple sheets to track expense accounts monthly and yearly.
A CDROM will be distributed with notes, sample MESA2.M2 files and a demo version
of MESA2.
Schedule
-
date not yet set
-
time not yet set
-
room not yet set
Speaker Info
Edgar Scrutton (BA York'66) (MA Windsor 78) has retired from 32 years of
teaching Guidance, Special Ed, Reading, Math, Computers, and Family Studies at
General Amherst High School. He now 'works for his wife' as IT expert and
bookkeeper-accountant at Allison's Travel Agency in Windsor, Ontario. He has
used OS/2 since 2.0 and programs in Basic, Turing, C++ and Rexx. OS/2 is the
server of choice at Allison's.
|