Category : Lotus and other Spreadsheets
Archive   : 123ABC.ZIP
Filename : 123.WKS

§
/


ÿ


ÿ®
q ›
H\MZ
Z
ÿÿÿÿÿÿÿÿÿÿÿÿ0
?
I
I
B
C
ÿÿÿÿ0
ÿÿÿÿÿÿÿÿ

ÿ# ÿÿÿÿ ÿÿÿÿÿÿÿÿ$
%ò&ò'((
LB)
'*ÿÿÿÿÿÿÿÿ-µ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
;ÿ'Lotus 123 Easy as ABC E.Posey Dec 1988ÿ
'For Beginners:ÿ'Keyboard and disks:ÿ'-------------------Iÿ'Arrows in the number section move the cursor (lighted area) in theFÿ' direction indicated (use down to read the rest of this sheet)Hÿ'Arrow at the top deletes from line you are typing (backspace key)Dÿ'Two beige (up arrow) keys are for capital letters (shift key)*ÿ'Caps lock makes all capital lettersPÿ 'Arrow with tail is enter (or carriage return) key and is used after everyÿ
' command.Jÿ'The / key is the main key to see the menu at the top of the screen.Fÿ 'Menu (or line you are typing) will be at the top of your screenIÿ
'Alt, ctrl (on left) and del (on right) pressed at same time causesÿ' computer to start overKÿ'Disks are never kept near electronic field (phone,top of computer or:ÿ' printer) and open areas never touched with hands.3ÿ'Do not write with a pen on disk-use a flair.Lÿ'*****Do not format a disk unless you indicate the drive i.e. format ADÿ'1. Insert Lotus system disk in drive A (label in left corner)Pÿ' out (nearest you)put this tutorial disk in drive B. If red light doesHÿ' not go on in drive B after you boot up: type: set default to bHÿ'2. Turn on computer (boot up the system) (C drive does not apply)Gÿ' You will hear a lot of noise and some printing on the screen.Dÿ' *If you do not format a disk, hit enter twice and go to 7.Bÿ'TO FORMAT A DISK (which must be done before it can be used)ÿ' see #3 below.Kÿ'3. AFter step 2, you will see a mneu from which you will select yourÿ' next move.4ÿ' Move cursor over to disk manager. (return)Sÿ'*If you have drive c:type format a:(if you do not indicate A you could eraseÿ' all of drive c)2ÿ '4. Then follow instructions on your screen.Rÿ!' After formatting is complete, type n (you don't want to format any more)Eÿ"' Later release do not have this same menu with disk manager.Oÿ#' Therefore, any disk can be formatted in DOS. AT the a> type the word8ÿ$' "format". (no parens) and follow instructionsÿ%'AFTER FORMATTING:Gÿ&'5. Computer will tell you to insert System Disk in Drive A again"ÿ'' System Disk is Lotus 123?ÿ('6. When you see copyright message, hit return (or enter)>ÿ)'7. You will the come to the Lotus (or 123) spreadsheet.Jÿ+' do /fr & choose computer & hit return (/=menu,f=file,r=retrieve)Rÿ-'8. The spreadsheet is filled in just as though you were using a typewriter.Hÿ.' The ESC key gets you out of the line you are typing (or menu).Mÿ/' Right now, in an empty area, put in any letters you wish, hit ESC. ÿ0' Also try arrow keys.;ÿ1' Computer will only do what you instruct it to do.3ÿ2' You are in a spreadsheet (worksheet) now.'ÿ3'9. A simple spreadsheet follows:Bÿ4' formula is the command to the computer to do arithmetic.ÿC'ADDITIONÿD'Aÿ
D'BÿD'C
ÿE'BUDGETÿG'RENT
‚G ÿH'HEAT
‚H}ÿI'ELECTRIC
‚I- ÿJ'PHONE
‚J  ÿL'TOTALHÿN'With cursor on C77 do a formula-formula is: @sum(c72.c76) ÿO'next:NÿP'With cursor on c77, you will see the formula in the menu section at theÿQ' top of the screen
ÿQ'on c77LÿR'do /re and you will erase the answer.(/=menu,r=range,e=erase)@ÿS' Then do the formula again and see the answer reappear.KÿT'To edit the line you are on, put cursor at beginning of sentence andKÿU' hit the f2 key. With cursor, insert and delete keys you can move*ÿV' across line to make any changes.RÿW'Note: the cursor is the spot you are on on the page. Typing appears in menuÿX'section.ÿZ'SUBTRACTIONÿ['Aÿ
['Bÿ['C
ÿ]'SALARY
ÿ]„ ÿ^'LUNCH
ÿ^
ÿ_'TRAVEL
ÿ_ÿa'BALANCECÿc'With cursor on line c98, put in formula +c94-c95-c96ÿe'MULTIPLICATIONNÿg'Use the star above the 8 (*) for multiplication sign or on Prt Scr key.?ÿh'9 times 10 = 90 right? do 9*10 arrow over to blank spaceÿj'DIVISIONSÿk'Use the slash key near the up arrow for the division sign (same as menu key)<ÿl'144 divided by 12=12, right? Hit 144/12 or any keysÿm'Feel free to show off!!ÿo'PERCENTAGEÿq'Aÿ
q'Bÿq'Cÿq'FORMULA ÿs'MARCH
ÿsd²sUUUUUUÕ?
þ¿€
þ¿€ P
 ÿt'APRIL
ÿtȲtUUUUUUå?
þ¿€
þ¿€ P
ÿu'---------ÿu'---------ÿvÀr@ €ý¿€þ¿P
 ÿv'TOTAL²vð? €ý¿€þ¿P
>ÿx'PUT CURSOR ON ANSWER AND CHECK MENU SECTION FOR FORMULAÿz'THINGS TO REMEMBER:?ÿ|'10. In order to get the dollar sign and 2 decimal places9ÿ}' place cursor on c119, hit /frc, accept 2,return(ÿ~' (menu,range,format,currency,2)Lÿ€'11. To save your spreadsheet: hit /fs and give it a name of 8 letters7ÿ' or less such as Budget (/=menu,f=file,s=save)Mÿƒ'12. To retrieve a spreadsheet: hit /fr and select the name you want toPÿ„' retrieve such as budget (/=menu,f=file,r=retrieve) With later versionsMÿ…' of Dos, you can do /fr and hit the f3 key then select the file withÿ†' the cursorBÿˆ'13. To erase: hit/re and highlight range you want to erase."ÿ‰' (/=menu,r=range,e=erase)Nÿ‹'14. In the beginning, we were asked if we wanted numbers to come beforeRÿŒ' letters and we chose letters. Therefore, you will find that many times Pÿ' numbers will not work properly, therfore use the ' (apostrophe) beforeÿŽ' putting in a number.Lÿ' Tip: if you forget and get a beep, hit home, apostrophe and returnÿ‘'COLUMNSFÿ’'15. Columns are usually 9 spaces wide. You can change this by:Pÿ“' /wcs and the number of the width you want. Return. (worksheet, column,ÿ”' set)Jÿ•' Try it but do /wcs and set it back to 9 or this printing will beÿ–' mixed up.0ÿ˜'16. Each column is referred to as a cell.Qÿš'17. Usually you will want to put a label at the top of each cell: such as:ÿ
›'Nameÿ›'Dateÿ›'PositionNÿ'18. When starting a spreadsheet, you can change the column width to fit(ÿž' each label you want to put in.Mÿ '19. You can place labels to the left of a cell by using ' (apostrophe)"ÿ¡' before the name of labelNÿ¢' You can place them in the center by using ^ (located above number 6)5ÿ£' You can place them to the right by using ".Hÿ¥'20. Try this with your name. Move cursor to d166 and do each oneÿ¦' below the other.ÿ§'Janeÿ¨^Janeÿ©"JaneLÿ«'You have now done addition, subtraction, multiplication, division andÿ¬' percentage.Nÿ®'21. Down the numbered side of spreadsheet, you may want to place titlesGÿ¯' such as before when we did the budget. i.e. Rent, Phone, etc.Oÿ°' You can practice making a spreadsheet by moving over to the L column.Kÿ²'22. A down arrow key stroke will skip a line or as many as you wish.Rÿ³' Pg Up and Pg Dwn do exactly what they say. They move up or down a page.Hÿµ'23. If you want to insert a row: hit /wi, select row (not column)ÿ¶' and returnPÿ·' If you want to delete a row: hit /wd, select row (not column), return.Jÿ¹'24. If you want to insert a column: hit /wi, select column, return.Eÿº' To delete a column, do /wd col and hit return: but careful,5ÿ»' you might delete a column you want to keep.ÿ
¼'janeÿ
½'janeÿ
¾'janeKÿÀ' Put cursor on middle name above. Do /wi row and hit return twice.MÿÁ' Do /wd row and put back in. (delete a row) If this is not done, any6ÿÂ' reference to specific rows will not be true.ÿÄ'MOVE A BLOCK OF TEXTQÿÆ'Have cursor on the first word. Do /m, period, move cursor to cover entireKÿÇ'area you want to move. Hit return, then indicate the first spot youÿÈ'want to put the text.JÿÉ'i.e. To begin moving, put cursor on A199. Do menu, move, period andSÿÊ'highlight with cursor down to h201. Hit return. Move to? indicate L201 and)ÿË'text will be moved to column L199.JÿÍ'You can insert rows and move the text just as you would if you wereÿÎ'writing a letter.ÿÏ'testÿÐ'testÿÑ'testRÿÒ'On line A208, do /wir (insert a row) and indicate how many rows you want toÿÓ'insert. i.e. a208.a211SÿÔ'Then move cursor to a199 and do /m period, highlight to H201ÿÕ'then indicate A208.ÿ×'RECALCULATEQÿÙ'As you input a worksheet, the computer will recalculate each time you make:ÿÚ'an entry, therefore, do /wgrm (manual calculation).KÿÛ'When you complete your worksheet, hit the f9 Key (Calc key) and your%ÿÜ'worksheet will be recalulated.GÿÞ'25. Make sure your printer is on-line (light lit ready to print)Kÿß' Printing your worksheet: hit /pp r (r is the range) Generally theIÿà' range is the entire worksheet (highlight entire area by hittingNÿá'return, return then putting a period behind first number such as A1 andPÿâ' using arrow key, go down and right to include the entire area you wantÿã' to print.ÿä' Hit align and go.Qÿå'Note: Always align printer (move cursor to align and hit return) Make sure)ÿæ' your printer is at top of page.Lÿç' Select options. Select margings. Left is usually 4, right 240 (toCÿè' accommodate large print) top usually 4, bottom usually 3.+ÿé' Page length is usually set at 66.;ÿê' Then choose setup which is setting the size printMÿë' Generally, the printer is set at \027 unless using compressed printÿì' Compressed print=\015>ÿí'Then go to the word (with your cursor) "align" and "go"3ÿ
î'See further printing tips at bottom of page.ÿï'SORTINGÿð'---------ÿñ'Name ÿñ'State
ÿñ'Zip
ÿó'Fultonÿó'Maryland
ÿó6Rÿô'Prowÿô'Maryland
ÿôVVÿõ'Longÿõ'Pennsylvania
ÿõ90ÿö'Harrington ÿö'Maine
ÿö:0ÿ÷'Logsdonÿ÷'Ohio
ÿ÷;0ÿø'Pattersonÿø'Maryland
ÿø5RGÿû'Do /ds (data, sort)(A242) hit period and highlight to E249.Dÿü'Always start with the first name and last line i.e.A244.E.2499ÿý'Choose Primary Key. Could be Name or state or Zip0ÿþ'Hit return and then a for ascending order+ÿÿ'Watch the a column and hit G for Go.9ÿ

'Try another. You can sort by each of the columns.Gÿ
'Primary Key can be c242 and they will be in alpha order by stateÿ
'COPYING A FORMULA
ÿ
90
ÿ

:0
ÿ
;0
ÿ
=0
ÿ
 [
ÿ

¡[
ÿ
£[
ÿ
¢[
ÿ
 Fà@
ÿ

€³å@
ÿ
` ë@
ÿ
 ·ò@
ÿ

€³õ@
ÿ


ðiø@
ÿ

€³õ@
ÿ

ðiø@
ÿ
g+
ÿ

ÎV
ÿ
 Fà@
ÿ
€³å@Kÿ
'PUT CURSOR ON A270 AND DO A FORMULA TO ADD FIGURES. @SUM(A264.A268)Fÿ
'FORMULA WILL SHOW IN MENU AREA. WITH THE CURSOR STILL ON A270,@ÿ
' DO /C AND RETURN. MENU WILL THEN ASK RANGE TO COPY TO...ÿ
'HIGHLIGHT B270.D270Bÿ
'WITH CURSOR ON TOTALS LOOK AT MENU AREA AND SEE HOW COPYINGUÿ
'FORMULA HAS WORKED. COL B WILL HAVE B264.B268, COL C WILL HAVE C264.C268,ETC.ÿ
'DATA QUERYÿ
'---------------#ÿ
'IN ORDER TO DO A DATA QUERY:Mÿ
'1. THE INPUT NUMBER IS THE ENTIRE WORKSHEET FROM THE WORD NAME TO THE ;ÿ
' LAST ENTRY.(ALL RECORDS YOU WILL BE LOOKING INTO)Gÿ
'2. THE CRITERION RANGE IS BELOW YOUR WORK, YOU PUT WHAT YOU WANTMÿ
' TO EXTRACT. (I.E. CODE ON FIRST LINE AND THE NUMBER ON SECOND LINE)Cÿ!
' lABEL AND SPECIFIC ITEM YOU WANT TO GET FROM ALL RECORDSHÿ#
'3. THE OUTPUT IS ON THE LINE BELOW THIS WHERE YOU COPY THE LABELSÿ$
' FROM ABOVE.Dÿ%
' WHERE ALL THE RECORDS YOU ARE SEARCHING FOR WILL SHOW UP.ÿ)
'JUNE 1984 YEAR TO DATE!ÿ+
'RELOCATION EXPENSES TOTALSÿ-
'OPERATING PROPERTIESÿ.
\-ÿ
.
\-ÿ/
'Aÿ
/
^Bÿ/
^Cÿ/
^Dÿ/
^Eÿ/
^Fÿ/
^Gÿ/
^Hÿ/
^Iÿ /
^Jÿ0
'NAMEÿ0
'DIVISIONÿ0
'CODEÿ0
'HHTRIPS
ÿ0
'TLAÿ0
'RHTRIPS ÿ 0
'TOTALÿ2
'ABURN,Cÿ2
'FANEUIL HALL ÿ2
'05
ÿ2

ÿ2
J
ÿ2
ÿ 2
”¨@ ý¿€ÿ¿€P
ÿ3
'ALKEN,Kÿ3
'NEW HIRE/STATEN IS. ÿ3
'09
ÿ3

 3

 3
ÿ 3
ý¿€ÿ¿€P
ÿ4
'ARMSTRONG, Lÿ4
'RANDHURST/ECHELON ÿ4
'05
 4

 4

 4
ÿ 4
ý¿€ÿ¿€P
ÿ5
'ATHERTON, Lÿ5
'HULEN/CHERRY HILL ÿ5
'08
 5
w
 5
d
 5
¾ÿ 5
€ÌÃ@ ý¿€ÿ¿€P
ÿ6
'BADAGIIACCO,Jÿ6
'WOODBRDG/NW ARK ÿ6
'04
ÿ6

ÿ6

ÿ6
ÿ 6
ý¿€ÿ¿€P

ÿ7
'BAIN,Eÿ7
'NEW HIRE/GALLERY ÿ7
'09
 7

 7

 7
I
ÿ 7
\‘@ ý¿€ÿ¿€P
ÿ8
'BAKLOR,E.ÿ8
'TRC/PARAMUS ÿ8
'05
 8
ö
 8
R

 8
l
ÿ 8
´²@ ý¿€ÿ¿€P
ÿ9
'BALAZS,Sÿ9
'WESTLAND/N.STAR ÿ9
'05
 9

 9

 9
ÿ 9
ý¿€ÿ¿€P

ÿ:
'BALL,Dÿ:
'DUTCHESS/GREENGATE ÿ:
'04
ÿ:

ÿ:

ÿ:
ÿ :
ý¿€ÿ¿€P
ÿ;
'BARRY,Mÿ;
'GOV.SQ/NORTHCROSS ÿ;
'02
 ;

 ;
‚
 ;
ÿ ;
‚¾@ ý¿€ÿ¿€P
ÿ<
'BENEDICT, Jÿ<
'ALMEDA/KEOSIPPI ÿ<
'04
 <

 <

 <
ÿ <
ý¿€ÿ¿€P
ÿ=
'BOHEN,Eÿ=
'NEW HIRE/PLY MEET ÿ=
'08
 =

 =
1
 =
ÿ =
Ĝ@ ý¿€ÿ¿€P
ÿ>
'CAMPBELL,M.ÿ>
'MUSCATINE/BURLINGTN ÿ>
'08
ÿ>

ÿ>

ÿ>
ÿ >
ý¿€ÿ¿€P
ÿ?
'CARRELL,Jÿ?
'EXTON/CENTRAL PK ÿ?
'08
 ?
¹
 ?
ó
 ?
ÿ ?
°–@ ý¿€ÿ¿€P
/ÿA
'THE INPUT FOR THE WORKSHEET IS A305.J320!ÿB
'THE CRITERION IS A327.A328ÿC
'THE OUTPUT IS A330.J330WÿD
'THE LABELS ON LINE 330 WERE COPIED FROM LINE A305.J305. DO /C AND HIGHLIGHT THERÿE
'AREA. GO TO A323 AND DO /DQ AND PUT IN THE THREE RANGES ABOVE. THEN HIT THEÿF
'CODEÿ
F
'= CRITERION ÿG
'04ÿ
G
'= CRITERION,ÿH
'WITH CURSOR BELOW NAME DO EXTRACTÿI
'NAMEÿI
'DIVISIONÿI
'CODEÿI
'HHTRIPS
ÿI
'TLAÿI
'RHTRIPS ÿ I
'TOTAL5ÿP
'YOU CAN CHANGE THE CRITERION TO DO ANY NUMBER. ÿR
'MACROÿS
'---------IÿU
'WATCH A MACRO WORK. A MACRO IS A CODE-LIKE METHOD OF WRITING YOUR QÿV
'INSTRUCTIONS AND THEN USING A SINGLE ALPHA NAME ASSIGNED TO IT./RNC M@ÿW
'CURSOR ON D351, HIT ALT KEY AND M. WATCH THE MACRO WORK.ÿ
W
' ÿX
'MACRO \MÿX
'DEFINITION OF MACROÿZ
'REGULAR PAY
‚Z
âÿZ
'{GOTO}D351~ÿZ
'GO TO D351ÿ[
'@SUM(D347.D349)~ÿ[
'ADD D347 TO D349ÿ\
'OVERTIME PAY
‚\
4ÿ\
'{DOWN}~ÿ\
'DOWN ONE LINEÿ]
'.067*D351{DOWN}~1ÿ]
'MULTIPLY .067 TIMES TOTAL PAY. DOWN A LINEÿ^
'TOTAL PAY ‚^
ÿ^
'.033*D351{DOWN}~1ÿ^
'MULTIPLY .033 TIMES TOTAL PAY. DOWN A LINEÿ_
'FICA ‚_
ÿ_
'.011*D351{DOWN}~1ÿ_
'MULTIPLY .011 TIMES TOTAL PAY. DOWN A LINEÿ`
'FED TAX ‚`
ÿ`
'{DOWN}~ÿ`
'DOWN A LINEÿa
'STATE TAX ‚a
ÿa
'+D351-D352-D353-D354~#ÿa
'ADD TOTAL PAY-MINUS THE REST ‚b
ÿc
'TAKE HOME PAY ‚c
8ÿf
'YOU CANNOT DO MOVE, INSERT, DELETE OR COPY OR THE%ÿg
'MACRO WILL HAVE TO BE CHANGED.ÿi
\-ÿ
i
\-ÿi
\-ÿi
\-ÿi
\-ÿi
\-ÿi
\-ÿi
\-ÿi
\-ÿk
'PRINTINGLÿm
'TO DO A HEADER IN THE PRINT COMMAND DO: MENU, PRINT, RETURN, OPTIONS,%ÿn
'HEADER AND TYPE IN YOUR TITLE.Jÿp
'BORDER IN PRINT COMMAND: TO HAVE THE TITLES APPEAR ON EACH PAGE DO:Qÿq
'MENU, PRINT, PRINTER, RETURN, OPTIONS, BORDERS, ROW, RETURN WITH CURSOR ONPÿr
'FIRST TITLE IN COLUMN A, HIT PERIOD TO HIGHLIGHT WITH CURSOR OVER TO LAST
ÿs
'TITLE.Oÿu
'TO NUMBER PAGES IN THE PRINT COMMAND YOU CAN DO MENU, OPTIONS,HEADER AND4ÿv
'PUT IN HEADER SUCH AS: JANUARY PRODUCE:PAGE #0ÿw
'TO HAVE PAGE NUMBER FURTHER TO THE RIGHT  ÿx
'DO: JANUARY PRODUCE|PAGE#>ÿy
'||PAGE # WILL PLACE THE NUMBER ALL THE WAY TO THE RIGHTLÿ|
'End key: to get there fast hit End and up arrow or End and down arrowLÿ}
'as well as End left arrow and End right arrow. Home takes you to the ¢}
¢}
ÿ~
'very beginning. ñ~
ñ~
ñ~
¢~
¢~
ñ
ñ
ñ
¢
¢
ñ€
ñ€
ñ€
¢€
¢€
ñ
ñ
ñ
¢
¢
#ÿ‚
'NOW LET'S LOOK AT A PAYROLL.+ÿ‚
'A PAYROLL. CLEAR MENU WITH ESC KEY. ñ‚
ñ‚
ñ‚
¢‚
¢‚
/ÿƒ
'MOVE DOWN TO A LINE IN THE PAYROLL SHEET ‚ƒ
‚ƒ
‚ƒ
‚ƒ
¢ƒ
2ÿ†
'WITH CURSOR ON A LINE READ ACROSS THE LINE. ÿ‡
'NOTE: > MEANS MORE THAN ñ‡
ÿˆ
'@ STARTS THE FORMULA._ÿ‰
'Look at formula in J:if E406 is more than 75, then 1.5 times E46-75 times per hour, or 08ÿŠ
'0 MEANS IF IT IS NOT MORE THAN 75 THEN FORGET IT.LÿŒ
'THE * BELOW PRTSC KEY IS THE MULTIPLIER (or the asterick above the 8)8ÿ
'THE / MARK UNDER THE ? MARK IS USED FOR DIVISION.6ÿŽ
'SEE COL H. REG. PAY DIVIDED BY 75 GIVES PER HR.6ÿ
'MOVE CURSOR TO EACH COL. AND LOOK AT MENU AREA.Gÿ
'THIS IS WHAT IS CALLED BOOLEAN ALGEBRA. READ IT. IT MAKES SENSE.Hÿ‘
'FICA TAX (soc sec)IS 0.067. FEDERAL TAX IS .11. CITY TAX IS .033.ÿ“
'Aÿ
“
'Bÿ“
"Cÿ“
"Dÿ“
"Eÿ“
"Fÿ“
"Gÿ“
"Hÿ“
^Iÿ “
^Jÿ
“
^Kÿ“
^Lÿ “
^Mÿ
“
^Nÿ“
^Oÿ“
^Pÿ
”
'NAME
ÿ”
"HRSÿ”
"REG HRS ÿ”
"OT HR
¢”
"PER HR¢”
"REG PAY
¢ ”
"OT PAY¢
”
"OT+REG PAY¢”
"FICA¢ ”
"FED TAX
ÿ
”
"ST TAXÿ”
"CITY TAXÿ”
'TAKE HOME PAYÿ
•
'MARILEE PLUSH
ñ•
P
ñ•
Kñ•
@
þ¿€
ÿ¿€

‚•
®Gáz®#@‚•
‡@
ý¿€
ÿ¿€P
7‚ •
33333sR@(
û¿€Kø?
û¿€K

þ¿€;‚
•
fffff^‰@
þ¿€
ÿ¿€ P
‚•
§èH.ÿ1K@ôýÔxé&±?
ÿ¿€‚ •
Õxé&1@a@Ãõ(\ÂÅ?
þ¿€‚
•
P—nSV@)\Âõ(¼?
ý¿€‚•
`vOÊ:@L7‰A`å ?
ü¿€-‚•
“Vu@
û¿€
ü¿€

ý¿€

þ¿€

ÿ¿€
 ‚•
ÿ
–
'DEBRAH CATHCART
ñ–
F
ñ–
Kñ–
À
þ¿€
ÿ¿€

‚–

×£p=
@‚–
{@
ý¿€
ÿ¿€P
7‚ –
(
û¿€Kø?
û¿€K

þ¿€;‚
–
{@
þ¿€
ÿ¿€ P
‚–
Œlçû©ñ<@ôýÔxé&±?
ÿ¿€‚ –
]Âõ(\R@Ãõ(\ÂÅ?
þ¿€‚
–
Ãõ(\ÂG@)\Âõ(¼?
ý¿€‚–
P—nƒ,@L7‰A`å ?
ü¿€-‚–
=
×£p½p@
û¿€
ü¿€

ý¿€

þ¿€

ÿ¿€
 ‚–
ÿ
—
'JAMES BROWN
ñ—
Z
ñ—
Kñ—
.@
þ¿€
ÿ¿€

‚—
×£p=
W%@‚—
‰@
ý¿€
ÿ¿€P
7‚ —
fffffn@(
û¿€Kø?
û¿€K

þ¿€;‚
—
ÍÌÌÌLA@
þ¿€
ÿ¿€ P
‚—
¡‰°áélQ@ôýÔxé&±?
ÿ¿€‚ —
î|?5^f@Ãõ(\ÂÅ?
þ¿€‚
—
ÙÎ÷Sã›\@)\Âõ(¼?
ý¿€‚—
|a2U*A@L7‰A`å ?
ü¿€-‚—
Ž—n(„@
û¿€
ü¿€

ý¿€

þ¿€

ÿ¿€
 ‚—
ÿ
˜
'DANIEL BOONE
ñ˜
_
ñ˜
Kñ˜
4@
þ¿€
ÿ¿€

‚˜
š™™™™™@‚˜
X@
ý¿€
ÿ¿€P
7‚ ˜
Àk@(
û¿€Kø?
û¿€K

þ¿€;‚
˜
Hˆ@
þ¿€
ÿ¿€ P
‚˜
e;ßOJ@ôýÔxé&±?
ÿ¿€‚ ˜
{®Gá‚`@Ãõ(\ÂÅ?
þ¿€‚
˜
®Gáz^U@)\Âõ(¼?
ý¿€‚˜
k¼t“¤9@L7‰A`å ?
ü¿€-‚˜
¤p=
×~@
û¿€
ü¿€

ý¿€

þ¿€

ÿ¿€
 ‚˜
ÿ
™
'JOHN BURNS
ñ™
n
ñ™
Kñ™
€A@
þ¿€
ÿ¿€

‚™
Ãõ(\B*@‚™

Ǝ@
ý¿€
ÿ¿€P
7‚ ™
š™™™™Š…@(
û¿€Kø?
û¿€K

þ¿€;‚
™
ÎÌÌÌL(š@
þ¿€
ÿ¿€ P
‚™
Ûho
\@ôýÔxé&±?
ÿ¿€‚ ™
E‹lç{Éq@Ãõ(\ÂÅ?
þ¿€‚
™
:´Èv¾g@)\Âõ(¼?
ý¿€‚™
FØðôJŸK@L7‰A`å ?
ü¿€-‚™
û~j¼´7@
û¿€
ü¿€

ý¿€

þ¿€

ÿ¿€
 ‚™
ÿ
š
@ €û¿€ÿ¿R
‚š
Ð{@ €û¿€ÿ¿P
‚š
pw@ €û¿€ÿ¿P
‚š
€Q@ €û¿€ÿ¿P
‚š
gfffffG@ €û¿€ÿ¿P
‚š
l«@ €û¿€ÿ¿P
‚ š
ÍÌÌÌÌ$“@ €û¿€ÿ¿P
‚
š
43333²@ €û¿€ÿ¿P
‚š
–Ô h"Ôs@ €û¿€ÿ¿P
‚ š
Zd;ß'‰@ €û¿€ÿ¿P
‚
š
æÐ"ÛùF€@ €û¿€ÿ¿P
‚š
G”ö_ˆc@ €û¿€ÿ¿P
‚š
Ð÷Sã¥ï¦@ €û¿€ÿ¿P
 ‚š
eÿœ
'The number 5 (411B) is gotten by doing a formula. First erase with /re and highlight e26.p26.Dÿ
'Then do @count(b20.b25). This gives you the number of names.3ÿž
'MOVE TO TOTAL IN COLUMN E AND DO /RE E26.p26tÿŸ
'MOVE TO E411 AND DO A FORMULA: @SUM (E406.E410) YOU ARE TELLING COMPUTER TO ADD LINES 406 to 410 in column E.Rÿ 
'with cursor on E411, do /c period and highlight from (return) to:f411.p411.ÿ
 
'53 AND DO´ÿ¡
'YOU NOW HAVE YOUR TOTALS BACK. YOU HAVE COPIED THE FORMULA IN COL D TO THE REST OF THE COLUMNS. MOVE YOUR CURSOR ACROSS THIS LINE AND CHECK THE MENU SECTION TO SEE FORMULAS.tÿ¢
'WITH CURSOR ON E411, DO /RFC 2 & RETURN. THEN HIT THE PERIOD AND USE ARROW KEY TO HIGHLIGHT LINE ACROSS PAGE.$¢£
'YOU HAVE CHANGED TO CURRENCY.!ÿ¥
'WANT TO PRINT THE PAYROLL?7ÿ¦
'ENTER /P AND THE RANGE WHICH IS THE ENTIRE SHEET?ÿ§
'CHECK MARGINS, PAGE LENGTH, SETUP AND THEN ALIGN AND GO.