LnSOS BOOT 1.1 SOS.KERNEL SOS KRNLI/O ERRORFILE 'SOS.KERNEL' NOT FOUND%INVALID KERNEL FILE: xةw,@  ȱlmi8#)!)>C50:"disk documentation >B50:" D Scellato 11k >A50:"Template Documentation - Util >C48:"check ledger sheet >B48:" Anonymous 20k >A48:"Check Master - Home & Business >C46:"reconcile business statements >B46:" D Scellato 1: +(TEMP.DOC.NEW&+,COMP.SHOPPER 3 3 .COMP.SHOP.DEMO 4 4 -AVON.REC.DEMO9+5 6 *BANK.RECON : ; ,CHECK.MASTER:++'PRINTERTEMP.DOC.AW ܢ-SPEARMAN.RANKC! /PEARSON.PRODUCTHI " /BUDGET.TEMPLATEN# /SMALL.BUS.START^0 & & .DEMO.NET.WORTHf( ) .SMALL.BUS.DEMOv + , OA3.VC.TEMP.1.1u' 'CATALOGI  +)NET.WORTHK p*LINEAR.REG  /EXPONENTIAL.REG)  /INCOME.TAX.DEMO3 .STOCK.ANALYSIS; >dLԡm#i㰼m#iЕOLԡȱfg hi !dLԡ憦  Ljmkm l y`2 Lԡ8(Je稽)ʈ@L 8k >A46:"Bank Reconciliation -Small Bus >C44:"avon campaign profit & tax >B44:" Anonymous 16k >A44:"Avon Records Demo - Small Bus >C42:"demo of comparative shopper >B42:" D Scellato 6k >A42:"Comparative Shopper Demo >C40:"select Assets >A234:" Long Te >C233:+C117 >B233:"l Property >A233:" Persona >C232:+D67+D84+D100 >B232:"ies >A232:" Securit >C231:+C48 >A231:" Cash >C230:+C34 >B230:"tate >A230:" Real Es >A229:"------- >A228:"Assets: >D227:/-- >C227:/-- >B227:/-- >A227:/ " Unpaid >C241:+C166 >B241:" Bills >A241:" Current >C240:+C149 >B240:"es >A240:" Mortgag >B239:"- >A239:/-- >B238:"s >A238:"Liabilitie >C236:@SUM(C230...C234 >B236:"ssets >A236:" Total A >C235:/-- >B235:/-- >A235:" ------- >C234:+C136 >B234:"rm >C248:+C236-C246 >A248:"Net Worth >C246:@SUM(C240...C244 >B246:"iabilities >A246:" Total L >C245:/-- >B245:/-- >A245:" ------- >C244:+C219 >B244:"ment Debt >A244:" Install >C243:+C197 >B243:"o Individ >A243:" Debts t >C242:+C181 >B242:"Taxes >A242:A5:/-- >B4:"plate Disk #1 >A4:" Visicalc Tem >B3:"ents >A3:" Pres >B2:"& The Original Apple///ers >A2:"The San Francisco Apple Core /W1 /GOC /GRA /GC30 /X>A1:>A1: complet >B10:/-- >A10:/-- >B9:"P C50 to print the catalog >A9:" Set cursor to A1 and press /P >B8:"w keys to view catalog. >A8:" Scan down and right with arro >B7:/-- >A7:/-- >B6:" A L O G * * * * * * * * * * * >A6:" * * * * * * * * * * * * C A T >B5:/-- > 3k >A16:"Catalog Utility >C15:/-= >B15:/-= >A15:/-= >C14:" description >B14:" Author Memory>>>>>>>>> >A14:" Template Name Type >C13:/-- >B13:/-- >A13:/-- >B12:"e documention of each template >A12:"Press /SL TEMP.DOC for ear regression curve fit >B20:" W Liswood 8k >A20:"Linear Regression - Statistic >C18:"compute personal net worth >B18:" J Conklin/D Scellato 10k >A18:"Net Worth Worksheet - HH Mgt >C16:"catalogs contents this disk >B16:" D Scellato 6k >A26:"Stock Analysis - Financial >C24:"1980-1981 tax computation demo >B24:"t Anonymous 5k >A24:"Income Tax Demo - Household Mg >C22:"exponential curve fit >B22:"c W Liswood 7k >A22:"Exponential Regress - Statisti >C20:"linute pearson r product >B30:" W Liswood 4k >A30:"Pearson Product - Statistic >C28:"compute spearman rank diff. >B28:" W Liswood 3k >A28:"Spearman Rank Diff - Statistic >C26:"compute present stock value >B26:" Gary Knox 10k >A36:"Net Worth Demo - Template Demo >C34:"compute 1st yr profit/loss >B34:" D Scellato 4k >A34:"Small Bus Start Up - Business- >C32:"set up home budget >B32:"t J Conklin 10k >A32:"Budget Template - Household Mg >C30:"comp minimum price - 3 alts >B40:"d D Scellato 5k >A40:"Comparative Shopper - Househol >C38:"demo of start up template >B38:" D Scellato 10k >A38:"Small Bus Start Up Demo - Demo >C36:"demo of net worth template >B36:" D Scellato -- >C226:/FR"As of: >A226:"For: >C225:/-- >B225:/-- >C224:"Statement >B224:"Net Worth >C223:"3 >B223:"ype /PPC25 >A223:"To print t >C221:/-= >B221:/-= >A221:/-= >C219:@SUM(C206...C217 >A219:/FR"Total >C217:0 >A217:"J Magnin >C216:0 >A216:"JC Penney >C215:0 >B215:"an >A215:"Medical Lo >C214:0 >A214:"Auto Loan >C213:0 >A213:"Shell Oil >C212:0 >A212:"Capwells >C211:0 >A211:"Mervyn's >C210:0 >A210:"Macy's >C209:0 >A209:"Wards >C208:0 >A208:"Sears >C207:0 >A207:"Visa >C206:0 >B206:"ss >A206:"Amer Expre Number >A88:"Firm >A87:"----- >A86:"Other >D84:@SUM(D73...D82 >B84:@SUM(B73...B82 >A84:/FR"Total >D82:/F$+B82*C82 >D81:+B81*C81 >D80:+B80*C80 >D79:+B79*C79 >D78:+B78*C78 >D77:+B77*C77 >D76:+B76*C76 >D75:+B75*C75 >D74:+B74*C74 >D73:+B73*C73 >D72:/-- >C72:/-UM(B90...B98 >A100:/FR"Total >D98:/F$+B98*C98 >D97:/F$+B97*C97 >D96:/F$+B96*C96 >D95:/F$+B95*C95 >D94:/F$+B94*C94 >D93:/F$+B93*C93 >D92:/F$+B92*C92 >D91:/F$+B91*C91 >D90:/F$+B90*C90 >D89:/-- >C89:/-- >B89:/-- >A89:/-- >D88:"Mkt Value >C88:"Mkt Price >B88:"C105:"Est Value >B105:"Descript >A105:"Category >C104:"------- >B104:/-- >A104:/-- >C103:"rksheet >B103:"roperty Wo >A103:"Personal P >C102:"2 >B102:"ype /PPC12 >A102:"To print t >D101:/-- >C101:/-- >B101:/-- >A101:/-- >D100:@SUM(D90...D98 >B100:@S114:"Gear >A114:"Elctronic >C113:0 >B113:"ystem >A113:"Computer S >C112:0 >B112:"ues >A112:"Art, Antiq >C111:0 >B111:"Furs >A111:"Clothing, >C110:0 >A110:"Furniture >C109:0 >A109:"Auto >C108:0 >A108:"Auto >C107:0 >A107:"Auto >C106:/-- >B106:/-- >A106:/-- >ory >C122:" Present >C121:"------ >B121:/-- >A121:/-- >C120:"ksheet >B120:"Assets Wor >A120:"Long Term >C119:"1 >B119:"ype /PPC14 >A119:"To print t >C118:/-- >B118:/-- >A118:/-- >C117:@SUM(C107...C115 >A117:/FR"Total >C115:0 >A115:"Other >C114:0 >Bing >A131:"Profit Sha >C130:0 >B130:"Options >A130:"Benefits >C129:0 >A129:"Pension >C128:0 >A128:"Annuities >C127:0 >A127:"Co. Ins >C126:0 >A126:"Life Ins >C125:0 >A125:"Life Ins >C124:/-- >B124:/-- >A124:/-- >C123:"Cash Value >B123:"Descript >A123:"Categ9:"Mortgages >C138:"4 >B138:"ype /PPC15 >A138:"To print t >C137:/-- >B137:/-- >A137:/-- >C136:@SUM(C125...C134 >A136:/FR"Total >C134:0 >A134:"Other >C133:0 >B133:"nterests >A133:"Business I >C132:0 >B132:"Royalties >A132:"Patents - >C131:0 >B131:"rUM(C144...C147 >A149:/FR"Total >C147:0 >A147:"Other >C146:0 >A146:"Bare Land >C145:0 >A145:"2nd/Vac >C144:0 >A144:"Prim Res >C143:/-- >B143:/-- >A143:/-- >C142:" Balance >B142:"n >A142:"Descriptio >C141:"Outstnding >B140:/-- >A140:/-- >B139:"Worksheet >A13Doctor >C156:/-- >B156:/-- >A156:/-- >C155:" Amount >A155:"Descript >C154:"Outstnding >C153:"--- >B153:/-- >A153:/-- >C152:"eet >B152:"lls Worksh >A152:"Current Bi >C151:"2 >B151:"ype /PPC17 >A151:"To print t >C150:/-- >B150:/-- >A150:/-- >C149:@S169:"To print t >C168:/-- >B168:/-- >A168:/-- >C166:@SUM(C157...C164 >A166:/FR"Total >C164:0 >A164:"Other >C163:0 >A163:"Alimony >C162:0 >A162:"Phone >C161:0 >A161:"Utilities >C160:0 >A160:"Rent >C159:0 >A159:"Dentist >C158:0 >A158:"Dentist >C157:0 >A157:" Inco >C175:0 >A175:"Fed Income >C174:0 >B174:"ents >A174:"On Investm, >C173:/-- >B173:/-- >A173:/-- >C172:"Amount >B172:"Type >A172:"Descript >C171:"-- >B171:/-- >A171:/-- >C170:"et >B170:"es Workshe >A170:"Unpaid Tax >C169:"6 >B169:"ype /PPC18 >A >B183:"ype /PPC20 >A183:"To print t >C182:/-- >B182:/-- >A182:/-- >C181:@SUM(C174...C179 >A181:/FR"Total >C179:0 >B179:"Bare Land >A179:"Property >C178:0 >B178:"2nd/Vac >A178:"Property >C177:0 >B177:"Prim Res >A177:"Property >C176:0 >B176:"me >A176:"StateM(C188...C195 >A197:/FR"Total >C195:0 >C194:0 >C193:0 >C192:0 >C191:0 >C190:0 >C189:0 >C188:0 >C187:/-- >B187:/-- >A187:/-- >C186:"Amount >A186:"Individual >C185:/-- >B185:/-- >A185:/-- >C184:" Worksheet >B184:"ndividuals >A184:"Debts to I >C183:"3>C205:/-- >B205:/-- >A205:/-- >C204:" Amount >A204:"Creditor >C203:"Outstnding >C202:"------ >B202:/-- >A202:/-- >C201:"ksheet >B201:"t Debt Wor >A201:"Installmen >C200:"4 >B200:"ype /PPC22 >A200:"To print t >C199:/-- >B199:/-- >A199:/-- >C197:@SU- >B72:/-- >A72:/-- >D71:"Mkt Value >C71:"Mkt Price >B71:"Number >A71:"Firm >A70:"----- >A69:"Bonds >D67:@SUM(D57...D65 >B67:@SUM(B57...B65 >A67:/FR"Total >D65:+B65*C65 >D64:+B64*C64 >D63:+B63*C63 >D62:+B62*C62 >D61:+B61*C61 >D60:+B60*C60 >D59:+B59*C59 >D58:+B58*C58 >D57:+B57*C57 >D56:/-- >C56:/-- >B56:/-- >A56:/-- >D55:"Mkt Value >C55:"Mkt Price >B55:"Shares >A55:"Firm >A54:"------ >A53:"Stocks >B52:/-- >A52:/-- >B51:" Worksheet >A51:"Securities >C50:"5 >B50:"ype /PPD10 >A50:"To print t >C49:/-- >B* >A92:/-* >D91:"TANT >C91:"NT IMPOR >B91:" IMPORTA >A91:"IMPORTANT >D90:/-* >C90:/-* >B90:/-* >A90:/-* >E88:"uture. >D88:"ict the f >C88:"u to pred >B88:" allow yo >A88:"This will >C87:"value. >B87:"or any X >A87:"Y value f >G86:"ict any >F8 !"#$%&' man >B96:" data is >A96:"where the >F95:"olumns >E95:" actual c >D95:"below the >C95:"g stored >B95:"ents bein >A95:"data elem >F94:"eliminary >E94:"th the pr >D94:" model wi >C94:"leave the >B94:"ected to >A94:"I have el >D92:/-* >C92:/-* >B92:/->G99:"r >F99:"ions clea >E99:"ula locat >D99:" the form >C99:"at all of >B99:"ertain th >A99:"to make c >G98:"es >F98:"a few tim >E98:"culation >D98:"ual recal >C98:"e use man >B98:" therefor >A98:"You must, >D96:"ipulated. >C96:"firstent >D1:" Net Worth >C1:/F$" VisiCalc /W1 /GOC /GRA /GF$ /GC10 /X>A1:>D1: c /W1 /GOC /GRA /GF$ /GC10 /X>A1:>B1: 1: >G4:"ndividual >F4:"tained. I >E4:"s self-con >D4:"ent. It i >C4:"e a statem >B4:" to produc >A4:"worksheets >G3:"es of >F3:"ing a seri >E3:"ment by us >D3:"orth state >C3:"es a net w >B3:"ate produc >A3:"This templ >E2:/-- >D2:/-- >C2:/-- >E1:" Stateme>>>>> >A12:" 1. Real E >C11:/-- >B11:/-- >A11:/-- >C10:" Location >A10:"Title >C9:"Data Entry >C8:/-- >B8:/-- >A8:/-- >B6:"te at D226 >A6:" Enter Da >G5:"w. >F5:"cated belo >E5:"et as indi >D5:"master she >C5:"ed on the >B5:" are locat >A5:"worksheetsen >C17:/FR"C148 >B17:"ges >>>>>> >A17:" 6. Mortga >C16:/FR"B129 >B16:"erm Assets >A16:" 5. Long T >C15:/FR"B111 >B15:"al prop.>> >A15:" 4. Person >C14:/FR"A61 >B14:"ties>>>>>> >A14:" 3. Securi >C13:/FR"C46 >B13:/-> >A13:" 2. Cash>> >C12:/FR"B33 >B12:"statTURN> >B23:"ype /PPC39 >A23:"To print t >C22:/-- >B22:/-- >A22:/-- >C21:/FR"C210 >B21:"lment Debt >A21:"10. Instal >C20:/FR"A192 >B20:"to Indiv.> >A20:" 9. Debts >C19:/FR"C178 >B19:" Taxes>>>> >A19:" 8. Unpaid >C18:/FR"C161 >B18:"t Bills>>> >A18:" 7. Currare Land >C30:0 >B30:0 >A30:"2nd/Vac >C29:0 >B29:0 >A29:"Prim. Res. >C28:/-- >B28:/-- >A28:/-- >C27:" Value >B27:" Price >A27:"Descript. >C26:" Present >B26:" Purchase >C25:"- >B25:/-- >A25:"---------- >C24:"t. >B24:"e Workshee >A24:"Real Estat >C23:"C38:"-- >B38:/-- >A38:/-- >C37:"et >B37:"nd Workshe >A37:"Cash on Ha >C36:" >B36:"ype /PPC53 >A36:"To print t >C35:/-- >B35:/-- >A35:/-- >C34:@SUM(C29...C32 >B34:@SUM(B29...B32 >A34:/FR"Total >C32:0 >B32:0 >A32:"Other >C31:0 >B31:0 >A31:"B49:/-- >A49:/-- >C48:@SUM(C42...C46 >A48:/FR"Total >C46:0 >B46:"cket >A46:"Cash in Po >C45:0 >A45:"Svgs Bonds >C44:0 >A44:"Checking >C43:0 >A43:"Savings >C42:0 >A42:"Savings >C41:/-- >B41:/-- >A41:/-- >C40:" Balance >B40:"Location >A40:"Descript. >C39:" 6:"will pred >E86:"he model >D86:" top of t >C86:"ox at the >B86:" second b >A86:"Also, the >G84:". >F84:" column g >E84:"ppears in >D84:"at data a >C84:"odel. Th >B84:"rom the m >A84:"derived f >F81:"rmula >E81:"ng the fo >D81:"value usi >C81:"s your Y >B81:"l predict >A81:"This mode >F79:"problem. >E79:" type of >D79:"d to this >C79:"re applie >B79:"as they are >A79:"formulas >F78:"reserve >E78:"ward to p >D78:"umns down >C78:"f the col >B78:"ate all o >A78:"to replic >F77:" remember >E77:"del, the>H10:"* >G10:/-* >F10:/-* >E10:/-* >D10:"* * >C10:/-* >B10:/-* >A10:" * >G8:/-- >F8:/-- >E8:/-- >D8:/-- >C8:/-- >B8:/-- >A8:/-- >B7:"ons =>A73 >A7:"Instructi >G6:/-- >F6:/-- >E6:/-- >D6:/-- >C6:/-- >B6:/-- >A6:/-- >E4:/-* >C4:"30, 1980 >B4:"Deedicted >D13:"* * >C13:/FG(D65 >B13:"Corelat = >A13:" * >H12:"* >E12:"Therefore >D12:"* * >C12:(C51 >B12:"Y Intcp = >A12:" * >H11:"* >G11:2 >F11:"ue = >E11:"New X Val >D11:"* * >C11:(B47 >B11:"Slope = >A11:" * 17:/FR"Y from X >G16:/FR"Estimate >E16:/FR" X Y >D16:/FR" Y^2 >C16:/FR" X^2 >B16:/FR" Y >A16:/FR" X >H14:"* >G14:/-* >F14:/-* >E14:/-* >D14:"* * >C14:/-* >B14:/-* >A14:" * >H13:"* >G13:(C51)+(G11*B47) >F13:" Y Value= >E13:"Pr(B21^2 >C21:(A21)^2 >B21:1300 >A21:3 >G20:(C51)+(A20*B47) >E20:(A20*B20 >D20:(B20^2 >C20:(A20)^2 >B20:1200 >A20:2 >G19:(C51)+(A19*B47) >E19:(A19*B19 >D19:(B19^2 >C19:(A19)^2 >B19:1000 >A19:1 >G18:/-- >F18:/-- >E18:/-- >D18:/-- >C18:/-- >B18:/-- >A18:/-- >G*B47) >E24:(A24*B24 >D24:(B24^2 >C24:(A24)^2 >B24:1700 >A24:6 >G23:(C51)+(A23*B47) >E23:(A23*B23 >D23:(B23^2 >C23:(A23)^2 >B23:1300 >A23:5 >G22:(C51)+(A22*B47) >E22:(A22*B22 >D22:(B22^2 >C22:(A22)^2 >B22:1200 >A22:4 >G21:(C51)+(A21*B47) >E21:(A21*B21 >D21:0 >A28:10 >G27:(C51)+(A27*B47) >E27:(A27*B27 >D27:(B27^2 >C27:(A27)^2 >B27:1700 >A27:9 >G26:(C51)+(A26*B47) >E26:(A26*B26 >D26:(B26^2 >C26:(A26)^2 >B26:1600 >A26:8 >G25:(C51)+(A25*B47) >E25:(A25*B25 >D25:(B25^2 >C25:(A25)^2 >B25:1900 >A25:7 >G24:(C51)+(A24 >C31:(A31)^2 >B31:2500 >A31:13 >G30:(C51)+(A30*B47) >E30:(A30*B30 >D30:(B30^2 >C30:(A30)^2 >B30:2200 >A30:12 >G29:(C51)+(A29*B47) >E29:(A29*B29 >D29:(B29^2 >C29:(A29)^2 >B29:2100 >A29:11 >G28:(C51)+(A28*B47) >E28:(A28*B28 >D28:(B28^2 >C28:(A28)^2 >B28:200>F34:/-- >E34:/-- >D34:/-- >C34:/-- >B34:/-- >A34:/-- >G33:(C51)+(A33*B47) >E33:(A33*B33 >D33:(B33^2 >C33:(A33)^2 >B33:2500 >A33:15 >G32:(C51)+(A32*B47) >E32:(A32*B32 >D32:(B32^2 >C32:(A32)^2 >B32:2600 >A32:14 >G31:(C51)+(A31*B47) >E31:(A31*B31 >D31:(B31^2"----- >D40:/-- >C40:/-- >B40:" ---- >A40:"for slope >E39:"UM Y) >D39:"(SUM X)(S >C39:"UM XY) - >B39:"quals N(S >A39:"Formula e >E36:@SUM(E18...E34 >D36:@SUM(D18...D34 >C36:@SUM(C18...C34 >B36:@SUM(B18...B34 >A36:@SUM(A18...A34 >A35:"Sum of >G34:/-- A34 >C50:/FR"Y int >B50:/FR"mean Y >A50:/FR"mean X >B47:(C43-D43)/(C45-D45) >B46:/FR"slope = >D45:(A36^2 >C45:(A44*C36 >D44:/-- >C44:/-- >A44:@COUNT(A18...A34 >D43:(A36*B36 >C43:(A44*E36 >A43:"N equals= >D41:"(SUM X)^2 >C41:"UM X^2) - >B41:" N(S >E40:) * (SUM >B59:") - (SUM >A59:"N (SUM XY >C57:"a equals >B57:"on formul >A57:"correlati >D54:") >C54:"mean of X) >B54:"- coeff ( >A54:"mean of Y >C53:"equals >B53:"or Y int >A53:"formula f >C51:(B51)-(B47*A51) >B51:@AVERAGE(B18...B34 >A51:@AVERAGE(A18...(A64)/(A66*B66) >C65:"equals >B65:/-- >A65:/-- >A64:(A44*E36)-(A36*B36) >G61:"2) >F61:"-(SUM Y)^ >E61:"(SUM Y^2) >D61:" *SQRT (N >C61:"SUM X)^2 >B61:"UM X^2)-( >A61:"SQRT (N(S >G60:"-- >F60:/-- >E60:/-- >D60:/-- >C60:/-- >B60:/-- >A60:/-- >D59:" Y) >C59:"X>F74:"n in this >E74:"lues show >D74:"the 15 va >C74:"ata than >B74:"ve less d >A74:"If you ha >F73:"d Y. >E73:"beled X an >D73:"olumns la >C73:"der the c >B73:"r data un >A73:"Enter you >B66:@SQRT((A44*D36)-(B36^2)) >A66:@SQRT((A44*C36)-(A36^2)) >D65:/FGn >D77:"of the mo >C77:"e middle >B77:"ows in th >A77:"add the r >F76:"ntries, >E76:"than 15 e >D76:"eed more >C76:" If you n >B76:"for data. >A76:"not need >F75:"at you do >E75:"e rows th >D75:"delete th >C75:" need to >B75:" you will >A75:"template, cember >A4:/-* >E3:/-* >D3:" Liswood* >C3:" by Woody >B3:"Developed >A3:/-* >D1:"Model >C1:"gression >B1:"Linear Re /W1 /GOR /GRM /GFI /GC9 /X>A1:>A1: 0: >I82:". >H82:"w columns >G82:"to the ne >F82:"rmulas in >E82:"te the fo >D82:"o replica >C82:"emember t >B82:". Then r >A82:"the model >I81:"ter of >H81:"o the cen >G81:" rows int >F81:"ld insert >E81:" you shou >D81:"eed more, >C81:" If you n >B81:"tem26:4 >H25:(A69)*(A64^A25) >F25:(C25^2 >E25:(A25^2 >D25:(A25*C25 >C25:@LOG10(B25 >B25:18 >A25:3 >H24:(A69)*(A64^A24) >F24:(C24^2 >E24:(A24^2 >D24:(A24*C24 >C24:@LOG10(B24 >B24:4 >A24:2 >H23:(A69)*(A64^A23) >F23:(C23^2 >E23:(A23^2 >D23:(A23*C23 >C23:@LOG10(B)*(A64^A28) >F28:(C28^2 >E28:(A28^2 >D28:(A28*C28 >C28:@LOG10(B28 >B28:75 >A28:6 >H27:(A69)*(A64^A27) >F27:(C27^2 >E27:(A27^2 >D27:(A27*C27 >C27:@LOG10(B27 >B27:34 >A27:5 >H26:(A69)*(A64^A26) >F26:(C26^2 >E26:(A26^2 >D26:(A26*C26 >C26:@LOG10(B26 >B26:16 >A(C31^2 >E31:(A31^2 >D31:(A31*C31 >C31:@LOG10(B31 >B31:576 >A31:9 >H30:(A69)*(A64^A30) >F30:(C30^2 >E30:(A30^2 >D30:(A30*C30 >C30:@LOG10(B30 >B30:259 >A30:8 >H29:(A69)*(A64^A29) >F29:(C29^2 >E29:(A29^2 >D29:(A29*C29 >C29:@LOG10(B29 >B29:125 >A29:7 >H28:(A69:(A34*C34 >C34:@LOG10(B34 >B34:4000 >A34:12 >H33:(A69)*(A64^A33) >F33:(C33^2 >E33:(A33^2 >D33:(A33*C33 >C33:@LOG10(B33 >B33:2300 >A33:11 >H32:(A69)*(A64^A32) >F32:(C32^2 >E32:(A32^2 >D32:(A32*C32 >C32:@LOG10(B32 >B32:1000 >A32:10 >H31:(A69)*(A64^A31) >F31: >B37:25000 >A37:15 >H36:(A69)*(A64^A36) >F36:(C36^2 >E36:(A36^2 >D36:(A36*C36 >C36:@LOG10(B36 >B36:15000 >A36:14 >H35:(A69)*(A64^A35) >F35:(C35^2 >E35:(A35^2 >D35:(A35*C35 >C35:@LOG10(B35 >B35:7500 >A35:13 >H34:(A69)*(A64^A34) >F34:(C34^2 >E34:(A34^2 >D34AGE(A22...A38 >F39:@SUM(F22...F38 >E39:@SUM(E22...E38 >D39:@SUM(D22...D38 >C39:@SUM(C22...C38 >A39:"mean of X >H38:/-- >G38:/-- >F38:/-- >E38:/-- >D38:/-- >C38:/-- >B38:/-- >A38:/-- >H37:(A69)*(A64^A37) >F37:(C37^2 >E37:(A37^2 >D37:(A37*C37 >C37:@LOG10(B37>E46:/-- >D46:/-- >C46:/-- >B46:/-- >G45:" Y >F45:"UM of LOG >E45:"SUM X * S >D45:" X(LOGY)- >C45:"als N SUM >B45:"slope equ >A45:/FL@COUNT(A22...A38 >A44:"N equals >C42:@AVERAGE(C22...C38 >A42:/FL@SUM(A22...A38 >C41:"mean LOGY >A41:"sum of X >A40:/FL@AVER LOG slo >B58:"an LOG Y >A58:"equals me >B57:"cept >A57:"LOG inter >D55:(D51-E51)/(D53-E53) >C55:"LOG slope >E53:(A42^2 >D53:(A45*E39 >E52:/-- >D52:/-- >E51:(A42*C39 >D51:(D39*A45) >F47:"^2 >E47:"UM of (X) >D47:"(X^2) - S >C47:" N SUM >G46:/-- >F46:/-- Y=A >A71:"formula e >A69:10^B60 >C67:"s=======A >B67:"tcp equal >A67:"10^LOG in >B66:"nt equals >A66:"coefficie >A64:10^D55 >D62:"===B >C62:"E equals= >B62:"^LOG slop >A62:"base = 10 >B60:(C42-(D55*A40) >A60:"LOG intcp= >E58:" of X >D58:"pe * mean >C58:"-75:"cattered >E75:"ion are s >D75:"nal solut >C75:"or the fi >B75:" needed f >A75:"The parts >I74:"te. >H74:"he templa >G74:"ll over t >F74:" worked a >E74:"se I have >D74:"red becau >C74:"er scatte >B74:"l is rath >A74:"This mode >C71:"(B)^X >B71:"qualson a nu >E77:"recalcula >D77:"e manual >C77:"u must us >B77:"alues, yo >A77:"X and y v >I76:"al >H76:"our orgin >G76:"used as y >F76:"bers you >E76:"rs of num >D76:"m the pai >C76:"alues fro >B76:"icted Y v >A76:"your pred >H75:" To get >G75:"all over. >F(*+,-./01plate. >A81:"from the >I80:"d rows >H80:"the unuse >G80:"t delete >F80:"less, jus >E80:"You need >D80:"ems. If >C80:"for 15 it >B80:"now room >A80:"There is >C78:". >B78:"ry values >A78:"prelimina >I77:"lear >H77:"imes to c >G77:"mber of t >F77:"ti23 >B23:2 >A23:1 >H22:/-- >G22:/-- >F22:/-- >E22:/-- >D22:/-- >C22:/-- >B22:/-- >A22:/-- >H20:/FR"PRED Y >F20:/FR"LOG Y SQD >E20:/FR"X^2 >D20:/FR"X * LOG Y >C20:/FR"LOG Y >B20:/FR"Y >A20:/FR"X >H18:/-- >G18:/-- >F18:/-- >E18:/-- >D18:/-- >C18:/-- >B18:/-- >A18:/-- >A17:"below it. >E16:"* >D16:/-* >C16:/-* >B16:"l appear >A16:"value wil >E15:"* >D15:(A69)*(A64^D13) >C15:"* Y= >B15:"cted Y >A15:"the predi >E14:"* >C14:"* then >B14:"ght and >A14:"to the ri >E13:"* >D13:9 >C13:"* X= >B13:"the box >B32:"T J Conklin 10k >A32:"Tax Prep >D31:23 >C31:23 >B31:"mi or actua >A31:"Auto .08/mi or actuals >D30:100 >C30:100 >B30:"ributions >A30:"OtherContr >D29:100 >C29:100 >A29:"Goodwill >D28:100 >C28:100 >B28:"d >A28:"UnitedFund >D27:150 >C27:1"Zero Bracket >D36:@SUM(D18...D34 >C36:@SUM(C18...C34 >B36:"uctions * >A36:"Total Deductions >D35:4 >C35:4 >B35:"ns >A35:"#Exemptions >D34:25 >C34:25 >B34:" D Scellato 4k >A34:"Education >D33:40 >C33:25 >B33:"s >A33:"Work Tools >D32:50 >C32:5075 >C40:@LOOKUP(C39,B64...B70) >B40:" * >A40:"Fed Tax >D39:+D16-D38-(D35*1000) >C39:+C16-C38-(C35*1000) >B39:"le Entry* >A39:"TaxSchedule Entry >D38:+D36-D37 >C38:+C36-C37 >B38:"ions * >A38:"NetDeductions >D37:3400 >C37:3400 >B37:"ket * >A37:5:"W-2, 2 >D44:6000 >C44:5000 >B44:" Anonymous 16k >A44:"W-2, 1 >D43:74 >C43:74 >A43:"Credits >D42:+C41*.15 >C42:"- - - - * >B42:"$300 max >A42:" 15% ; >D41:" ->->->-> >C41:600 >B41:"1981 Totl >A41:"Cnsrvtion >D40:@LOOKUP(D39,C72...C78)*.98C36*.0494 >B48:" * >A48:"Tax >D47:+D16-D10-(.06*(D12+D13)) >C47:+C16-C10-(.06*(C12+C13)) >B47:"ross * >A47:"StateAdjGross >D46:+D44+D45+D43-D40+D42 >C46:+C44+C45+C43-C40 >B46:"d * >A46:"Refund,Fed >G45:0 >E45:0 >D45:793/7549*D8 >C45:500 >A4 * >A53:"NetRefunds >D52:+D51+D50-D48+D49 >C52:+C50-C48 >B52:"ate * >A52:"Refund,State >D51:+(64*9) >A51:"Wthldng 2 >D50:188*12 >C50:1500 >A50:"Wthldng 1 >D49:+C41*.4 >C49:"1500max)* >B49:"ion 40%($ >A49:"Conservat >F48:0 >D48:+D47-D36*.0494 >C48:+C47-39-20200)) >B65:20200 >C64:2265+(.24*(C39-16000)) >B64:16000 >A63:"1980Tax Schedule >D62:"eturns >C62:" Joint R >D61:"e Y >C61:" Schedul >C56:/FG >D54:+D40+D48 >C54:+C40+C48 >B54:" Total * >A54:"TaxBurden Total >D53:+D52+D46 >C53:+C52+C46 >B53:"s 245678916000)) >C72:16000 >A71:"1981Tax Schedule >C70:19678+(.54*(C39-60000)) >B70:60000 >C69:12720+(.49*(C39-45800)) >B69:45800 >C68:8162+(.43*(C39-35200)) >B68:35200 >C67:6201+(.37*(C39-29900)) >B67:29900 >C66:4505+(.32*(C39-24600)) >B66:24600 >C65:3273+(.28*(C>D78:19678+(.54*(D39-60000)) >C78:60000 >D77:12720+(.49*(D39-45800)) >C77:45800 >D76:8162+(.43*(D39-35200)) >C76:35200 >D75:6201+(.37*(D39-29900)) >C75:29900 >D74:4505+(.32*(D39-24600)) >C74:24600 >D73:3273+(.28*(D39-20200)) >C73:20200 >D72:2265+(.24*(D39-RM /GC9 /X>A1:>A1: >A13:"value in >E12:"* >D12:/-* >C12:/-* >B12:"r new X >A12:"Enter you >B7:"on at A74 >A7:"Instructi >E4:/-* >C4:"981 >B4:"May 22, 1 >A4:/-* >E3:/-* >D3:" Liswood >C3:" by Woody >B3:"Developed >A3:/-* >D1:"sion >C1:"al Regres >B1:"Exponenti /W1 /GOR /G50 >B27:"rest >A27:"Loan Interest >D26:250 >C26:150 >B26:"ds >A26:"CreditCards >D25:1200 >B25:"age >A25:"2nd Mortg >D24:3000 >C24:3000 >B24:"rest >A24:"Mort Interest >D23:0 >C23:0 >A23:"OtherTax >D22:26 >C22:26 >B22:"se >A22:"Autolicense >D21:400 >C21:200 >A21:"Salestax >D20:800 >C20:700 >B20:" W Liswood 8k >A20:"Proptax >D19:+C48 >C19:2376 >A19:"State Tax >D18:200 >C18:74 >B18:"3% Gross* >A18:"Medical > >D17:.03*D16 >C17:.03*C16 >B17:" * >A17:" 3% Gross >D16:@SUM(D7...D13)-D15 >C16:@S/FI+B22-(E22*F22+G22) >B22:/FR(A22*E22)-G22 >A22:32.75 >J21:+C21-I21 >I21:@IF((C11-H21)<101,C21,0) >H21:8111 >G21:98 >F21:27.75 >E21:500 >D21:/FR"US STEEL >C21:/FI+B21-(E21*F21+G21) >B21:/FR(A21*E21)-G21 >A21:29.625 >J20:+C20-I20 >I20:@IF((C11-H20)<101,C20:+C23-I23 >I23:@IF((C11-H23)<101,C23,0) >H23:8111 >G23:70 >F23:34.75 >E23:200 >D23:/FR"G MOTOR >C23:/FI+B23-(E23*F23+G23) >B23:/FR(A23*E23)-G23 >A23:38 >J22:+C22-I22 >I22:@IF((C11-H22)<101,C22,0) >H22:8111 >G22:100 >F22:31.625 >E22:700 >D22:/FR"EXXON >C22:NSTRUCTIONS >J26:"= >I26:"= >H26:"= >G26:"= >F26:"= >E26:"= >D26:"= >C26:"= >B26:"= >A26:"= >J25:@SUM(J16...J24 >I25:@SUM(I16...I24 >C25:@SUM(C16...C24 >B25:@SUM(B16...B24 >J24:"- >I24:"- >H24:"- >G24:"- >F24:"- >E24:"- >D24:"- >C24:"- >B24:"- >A24:"- >J23:" PER SHARE, AND THE DATE OF THE >A42:" PURCHASED, THE PURCHASE PRICE >A41:" THE STOCK NAME, NUMBER OF SHARES >A40:" AS EACH STOCK IS PURCHASED ENTER >A39:" A. PURCHASE OF STOCKS >A37:" /GC37 CONTINUE TO LINE 84 >A36:"TYPE: ISS >A50:" THE COMPUTED VALUE IS COLUMN A >A49:" CURRENT QUOTED PRICE IN COLUMN A >A48:" B. TO VALUE THE STOCKS ENTER THE >A46:" MONTH. (JAN 82 WOULD BE 8201) >A45:" XX IS THE YEAR AND YY IS THE >A44:" PURCHASE. DATE IS XXYY WHERE >A4357:" ONE YEAR. IF THE HOLDING PERIOD >A56:" C. THE LONG TERM HOLDING PERIOD IS >A54:" PAID AT THE TIME OF THE PURCHASE >A53:" TO BE THE SAME AS THE COMMISSION >A52:" AN ESTIMATED COMMISSION (ASSUMED >A51:" TIMES THE NUMBER OF SHARES LE 95 >A66:" FOR A NINE MONTH HOLDING PERIOD >A64:" C11,0) >A63:" (C5-H11)>88)), >A62:" @AND((C5-H11)<95, >A61:" @IF(@OR((C5-H11)<7, >A59:" FORMULA FOR COLUMN I WOULD BE: >A58:" WERE REDUCED TO 6 MONTHS THE >A:<=>?@A PURCHASED IN JANUARY DOES NOT >A73:" THE GAIN OR LOSS FOR A STOCK >A72:" THE MONTH INDICATED; THEREFORE, >A71:" IS PURCHASED ON THE LAST DAY OF >A70:" THE MODEL ASSUMES THAT THE STOCK >A68:" TO 98. >A67:" CHANGE THE 7 TO 10 AND THE>A84:" >C5 >A83:"TYPE: >A82:"TYPE: /GC9 >A80:" AND BEFORE THE SUMMATION LINE. >A79:" ADDED TO THE MODEL AFTER LINE 10 >A78:" D. AS MANY LINES AS NEEDED MAY BE >A76:" OF THE FOLLOWING YEAR. >A75:" BECOME LONG TERM UNTIL FEBRUARY >A74:" /-- >B4:/-- >A4:/-- >D3:1981 >C3:1980 >A3:"Period >B2:" Demo >A2:"Use Date: >D1:"is >C1:"ax Analys >B1:" Income T >A1:"1980,1981 /W1 /GOC /GRA /XH18 /GFI /GC9 /X>A1:>A1:;/GFI /GC9 /X>A53:>D54:; ; >C11:100 >B11:"Income >A11:"Business Income >D10:+C52 >C10:200 >B10:"s >A10:"TaxRefunds >D9:500 >C9:200 >A9:"Interest >D8:5000 >C8:4000 >A8:"Wages 2 >D7:35000 >C7:30000 >A7:"Wages 1 >D6:/-- >C6:/-- >B6:/-- >A6:/-- >B5:" Enter@ * >A5:" Don't >D4:/-- >C4:UM(C7...C13)-C15 >B16:"ross * >A16:"AdjustedGross >D15:0 >C15:688 >B15:/-= >A15:"Keogh/IRA >D14:1000 >C14:" description >B14:"age >A14:"2nd Mortg >D13:200 >C13:598 >B13:"ip >A13:"Partnership >D12:200 >C12:756 >B12:"ain >A12:"Capital G >D11:-1000 ,0) >H20:8111 >G20:80 >F20:50.625 >E20:300 >D20:/FR"IBM >C20:/FI+B20-(E20*F20+G20) >B20:/FR(A20*E20)-G20 >A20:54.625 >J19:+C19-I19 >I19:@IF((C11-H19)<101,C19,0) >H19:8111 >G19:105 >F19:19.125 >E19:1000 >D19:/FR"APPLE COM >C19:/FI+B19-(E19*F19+G19) >B19:/FR(A19*E19)-G19 >A19:19 >J18:+C18-I18 >I18:@IF((C11-H18)<101,C18,0) >H18:8111 >G18:50 >F18:24.25 >E18:100 >D18:/FR"BNK AM >C18:/FI+B18-(E18*F18+G18) >B18:/FR(A18*E18)-G18 >A18:23.875 >J17:+C17-I17 >I17:@IF((C11-H17)<101,C17,0) >H17:8111 >G17:90 >F17:61.375 >>G54:". >F54:"your data >E54:"to cover >D54:" columns >C54:"icate the >B54:"Then repl >G53:" data. >F53:"nter your >E53:"ore you e >D53:"model bef >C53:"r of the >B53:"the cente >G52:"ws in >F52:"ber of ro >E52:"riate num >D52:"he approp >C52:" inse"* >B7:/-* >A7:" * >D4:" ***** >C4:" 1/1/81 >B4:" by >A4:/-* >D3:"wood***** >C3:"Woody Lis >B3:"Template >A3:/-* >F1:"on >E1:"Correlati >D1:"fference >C1:"Rank - Di >B1:"Spearman /W1 /GOR /GRM /GF$ /GC9 /X>A1:>A1: 8: 17)^2 >B17:14 >A17:10 >C16:(A16-B16)^2 >B16:5 >A16:9 >C15:(A15-B15)^2 >B15:6 >A15:4 >C14:(A14-B14)^2 >B14:8 >A14:11 >C13:/-- >B13:/-- >A13:/-- >C12:"Diff^2 >B12:"Rank Y >A12:"Rank X >A10:/FG >C9:"* >B9:/-* >A9:" * >C8:"* >B8:(B44 >A8:" * >C7:2 >B25:2 >A25:2 >C24:(A24-B24)^2 >B24:10 >A24:6 >C23:(A23-B23)^2 >B23:4 >A23:7 >C22:(A22-B22)^2 >B22:1 >A22:3 >C21:(A21-B21)^2 >B21:3 >A21:1 >C20:(A20-B20)^2 >B20:8 >A20:12.5 >C19:(A19-B19)^2 >B19:12 >A19:14.5 >C18:(A18-B18)^2 >B18:15 >A18:14.5 >C17:(A17-B5:" 1 - >C34:"6 SUM D^2 >A34:"formula = >B32:@COUNT(A13...A29 >A32:"N equals >C30:@SUM(C13...C29 >B30:"Sum of = >C29:/-- >B29:/-- >A29:/-- >C28:(A28-B28)^2 >B28:11 >A28:12.5 >C27:(A27-B27)^2 >B27:8 >A27:8 >C26:(A26-B26)^2 >B26:13 >A26:5 >C25:(A25-B25)^>C47:"vidual ra >B47:" the indi >A47:"calculate >F46:"st first >E46:"on you mu >D46:"Correlati >C46:"fference >B46:"e Rank-Di >A46:"To use th >B44:1-(C39/C41 >A44:"equals >C41:+B32*(B32^2-1) >C40:/-- >B40:" 1- >C39:6*C30 >C36:"N(N^2-1) >C35:/-- >B3BDEFn i >D52:"alues tha >C52:"se more v >B52:" if you u >A52:"Remember, >C50:"lues. >B50:" the Y va >A50:"the X and >F49:"for both >E49:" entered >D49:" the data >C49:"t rank as >B49:" uses tha >A49:"The model >F47:" scores. >E47:"ch set of >D47:"nk for ea >C55:"wnward. >B55:"olumns do >A55:"formula c >F54:"te the >E54:"n replica >D54:"odel, the >C54:" of the m >B54:"he center >A54:"rows in t >F53:"er of >E53:"iate numb >D53:"e appropr >C53:"insert th >B53:"u should >A53:"model, yo >F52:"n the >E52:"n show11:"CURRENT D >C8:" >A55 >C7:" TYPE: >B7:"UCTIONS: >A7:"FOR INSTR >C3:"***** >B3:"* >C2:" KNOX >B2:"BY GARY L >C1:"LYSIS >B1:"STOCK ANA /W1 /GOR /GRA /GC9 /X>A1:>A1: /F-"- >A15:/FR"PRICE >A14:/FR"CURRENT >A11:"CURRENT D >A7:"FOR INSTR /W1 /GOR /GRA /GC9 /FR"STOCK >C15:/FR"(LOSS) >B15:/FR"VALUE >A15:/FR"PRICE >J14:/FR"LONG >I14:/FR"SHORT >H14:/FR"PURCHASE >G14:/FR"COMMIS- >F14:/FR"PURCHASE >E14:/FR"NUMBER OF >C14:/FR"GAIN >A14:/FR"CURRENT >J13:"- >I13:"- >J12:"LOSS) >I12:/FR"GAIN( >C11:8112 >B11:"ATE: >AE17:200 >D17:/FR"AT&T >C17:/FI+B17-(E17*F17+G17) >B17:/FR(A17*E17)-G17 >A17:59.375 >J16:"- >I16:"- >H16:"- >G16:"- >F16:"- >E16:"- >D16:"- >C16:"- >B16:"- >A16:"- >J15:/FR"TERM >I15:/FR"TERM >H15:/FR"DATE >G15:/FR"SIONS >F15:/FR"PRICE >E15:/FR"SHARES >D15:rt t >B52:"template, >G51:"n the >F51:"e shown i >E51:"s than ar >D51:"ata point >C51:"ve more d >B51:"If you ha >G49:"tly. >F49:"te correc >E49:"s calcula >D49:"l formula >C49:"insure al >B49:"times to >G48:"e two >F48:"ecalculat >E48:" manual r >D48:"hGIJKL >J58:+J56-J57 >I58:+I56-I57 >H58:+H56-H57 >G58:+G56-G57 >F58:+F56-F57 >E58:+E56-E57 >D58:+D56-D57 >C58:+C56-C57 >A58:"Balance >N57:+N50 >M57:+M50 >L57:+L50 >K57:+K50 >J57:+J50 >I57:+I50 >H57:+H50 >G57:+G50 >F57:+F50 >E57:+E50 >D57:+D50 >C57:+C50 >B57:"resMOPQRSTUVWXYZ[\47+K48) >J59:+J58-(J47+J48) >I59:+I58-(I47+I48) >H59:+H58-(H47+H48) >G59:+G58-(G47+G48) >F59:+F58-(F47+F48) >E59:+E58-(E47+E48) >D59:+D58-(D47+D48) >C59:+C58-(C47+C48) >B59:"e Balance >A59:"Disposabl >N58:+N56-N57 >M58:+M56-M57 >L58:+L56-L57 >K58:+K56-K57>C61:0 >B61:" Bal.Fwd. >A61:"Retirem.- >P60:/-- >O60:/-- >N60:/-- >M60:/-- >L60:/-- >K60:/-- >J60:/-- >I60:/-- >H60:/-- >G60:/-- >F60:/-- >E60:/-- >D60:/-- >C60:/-- >B60:/-- >A60:/-- >N59:+N58-(N47+N48) >M59:+M58-(M47+M48) >L59:+L58-(L47+L48) >K59:+K58-(Knt Coef >C1:"roduct-Mo >B1:"Pearson P /W1 /GOR /GRM /GFI /GC9 /X>A1:>A1: : 9:"* >C9:/-* >B9:/-* >A9:" * >D7:" ***** >C7:" 1/1/81 >B7:" by >A7:/FR/-* >D6:"wood***** >C6:"Woody Lis >B6:"Template >A6:/-* >C4:"A47 >B4:"ons at=== >A4:"Instructi >D2:"nal Data >C2:"from Orgi >G1:"tion >F1:"f Correla >E1:"ficient o >D1:"me>D16:/-- >C16:/-- >B16:/-- >A16:/-- >E15:" XY >D15:" Y^2 >C15:" X^2 >B15:" Y >A15:" X >D13:"* >C13:/-* >B13:/-* >A13:" * >D12:"* >A12:" * >D11:"* >C11:/FG(C44 >B11:"R equals >A11:" * >D10:"* >A10:" * >D1:(B21^2 >C21:(A21^2 >B21:2 >A21:7 >E20:(A20*B20 >D20:(B20^2 >C20:(A20^2 >B20:7 >A20:8 >E19:(A19*B19 >D19:(B19^2 >C19:(A19^2 >B19:3 >A19:10 >E18:(A18*B18 >D18:(B18^2 >C18:(A18^2 >B18:11 >A18:12 >E17:(A17*B17 >D17:(B17^2 >C17:(A17^2 >B17:7 >A17:13 >E16:/-- 6^2 >C26:(A26^2 >B26:6 >A26:1 >E25:(A25*B25 >D25:(B25^2 >C25:(A25^2 >B25:9 >A25:3 >E24:(A24*B24 >D24:(B24^2 >C24:(A24^2 >B24:2 >A24:4 >E23:(A23*B23 >D23:(B23^2 >C23:(A23^2 >B23:6 >A23:6 >E22:(A22*B22 >D22:(B22^2 >C22:(A22^2 >B22:12 >A22:6 >E21:(A21*B21 >D2(SUM XY >B33:"SQR RT of >A33:"formula >B31:@COUNT(A16...A27 >A31:" N = >E29:@SUM(E16...E27 >D29:@SUM(D16...D27 >C29:@SUM(C16...C27 >B29:@SUM(B16...B27 >A29:@SUM(A16...A27 >A28:" sum of >E27:/-- >D27:/-- >C27:/-- >B27:/-- >A27:/-- >E26:(A26*B26 >D26:(B2(B31*C29)-(A29^2) >D38:/-- >C38:/-- >C37:((B31*E29)-(A29*B29)^2 >B37:"R^2 >G35:"SUM Y)^2) >F35:"M Y^2 - ( >E35:"2 )*(N*SU >D35:")-SUM(X)^ >C35:"(N*SUM X^ >F34:/-- >E34:/-- >D34:/-- >C34:/-- >A34:"equals >F33:") )^2 >E33:"X) (SUM Y >D33:") - (SUM >C33:"(Nen press >C48:" and Y. T >B48:"labeled X >G47:"umns >F47:"n the col >E47:"X and Y i >D47:"lues for >C47:"e your va >B47:"Substitut >A47:"To use: >C44:/FG@SQRT(C37/(C39*D39) >B44:"R equals >C42:/FG+C37/(C39*D39) >B42:"R^2 == >D39:(B31*D29)-(B29^2) >C39: >A57:"Expenditu >N56:+N11 >M56:+M11 >L56:+L11 >K56:+K11 >J56:+J11 >I56:+I11 >H56:+H11 >G56:+G11 >F56:+F11 >E56:+E11 >D56:+D11 >C56:+C11 >A56:"Income >P55:/-- >O55:/-- >N55:/-- >M55:/-- >L55:/-- >K55:/-- >J55:/-- >I55:/-- >H55:/-- >G55:/-- >F55:/-- >E55:/-- >D55:/-- >C55:/-- >B55:/-- >A55:/-- >Y54:/FR >X54:/FR >W54:/FR >V54:/FR >U54:/FR >T54:/FR >S54:/FR >R54:/FR >Q54:/FR >P54:/FR >O54:/FR >N54:/FR"Dec >M54:/FR"Nov >L54:/FR"Oct >K54:/FR"Sep >J54:/FR"Aug >I54:/FR"Jul >H54:/FR"Jun >G54:/FR"May >F54:/FR"Apr >Ecash >A26:"7a Contri >Q25:"! ! >O25:@SUM(C25...N25) >B25:" Sundr's >A25:" d >Q24:"! ! >O24:@SUM(C24...N24) >B24:" Drugs >A24:" c >Q23:"! ! >O23:@SUM(C23...N23) >B23:" Insur. >A23:" b >Q22:"! ! >O22:@SUM(C22...N22) >B22:"l-MD/9:+F29 >F29:+E29 >E29:+D29 >D29:+C29 >C29:0 >B29:" Protec. >A29:"8 Income >Q28:"! ! >O28:@SUM(C28...N28) >B28:" Misc. >A28:" c >Q27:"! ! >O27:@SUM(C27...N27) >B27:" out/pocket >A27:" b >Q26:"! ! >O26:@SUM(C26...N26) >B26:"bu.-lds :" - Other >A32:" b >Q31:"! ! >O31:@SUM(C31...N31) >B31:"p.- Auto >A31:"10a Trans >Q30:"! ! >O30:@SUM(C30...N30) >B30:"tion >A30:"9 Recrea >Q29:"! ! >O29:@SUM(C29...N29) >M29:+L29 >L29:+K29 >K29:+J29 >J29:+I29 >I29:+H29 >H29:+G29 >G2! ! >O35:@SUM(C35...N35) >B35:"uc.Books,magazines >A35:" /ii Ed >Q34:"! ! >O34:@SUM(C34...N34) >B34:"c.Educ.Supplies >A34:"11d/i Mis >Q33:"! ! >O33:@SUM(C33...N33) >B33:"llaneous >A33:"11 Misce >Q32:"! ! >O32:@SUM(C32...N32) >B32:+I38 >I38:+H38 >H38:+G38 >G38:+F38 >F38:+E38 >E38:+D38 >D38:+C38 >C38:0 >B38:"s'l Org. >A38:"12 Profes >Q37:"! ! >O37:@SUM(C37...N37) >B37:"ass Registration >A37:" /iv Cl >Q36:"! ! >O36:@SUM(C36...N36) >B36:"onferences >A36:" /iii C >Q35:" ! >O39:@SUM(C39...N39) >N39:+M39 >M39:+L39 >L39:+K39 >K39:+J39 >J39:+I39 >I39:+H39 >H39:+G39 >G39:+F39 >F39:+E39 >E39:+D39 >D39:+C39 >C39:0 >B39:"-Federal >A39:"13a Taxes >Q38:"! ! >O38:@SUM(C38...N38) >N38:+M38 >M38:+L38 >L38:+K38 >K38:+J38 >J38l) >Q41:"! ! >O41:@SUM(C41...N41) >B41:"-Sales >A41:" c(incl) >Q40:"! ! >O40:@SUM(C40...N40) >N40:+M40 >M40:+L40 >L40:+K40 >K40:+J40 >J40:+I40 >I40:+H40 >H40:+G40 >G40:+F40 >F40:+E40 >E40:+D40 >D40:+C40 >C40:0 >B40:"-State >A40:" b >Q39:"! ! >O45:@SUM(C45...N45) >B45:"gs-Demand >A45:"15a Savin >Q44:"! ! >O44:@SUM(C44...N44) >B44:"ayments >A44:"14 Loan P >Q43:"! ! >O43:@SUM(C43...N43) >B43:"Auto License >A43:" e >Q42:"! ! >O42:@SUM(C42...N42) >B42:"-Gasoline >A42:" d(inc ! >O47:@SUM(C47...N47) >N47:+M47 >M47:+L47 >L47:+K47 >K47:+J47 >J47:+I47 >I47:+H47 >H47:+G47 >G47:+F47 >F47:+E47 >E47:+D47 >D47:+C47 >C47:0 >B47:" -Retirement >A47:" c >Q46:"! ! >O46:@SUM(C46...N46) >B46:" -Investments >A46:" b >Q45:"! :/-- >G49:/-- >F49:/-- >E49:/-- >D49:/-- >C49:/-- >B49:/-- >A49:/-- >Q48:"! ! >O48:@SUM(C48...N48) >N48:+M48 >M48:+L48 >L48:+K48 >K48:+J48 >J48:+I48 >I48:+H48 >H48:+G48 >G48:+F48 >F48:+E48 >E48:+D48 >D48:+C48 >C48:0 >B48:" -T.S.A. >A48:" d >Q47:"! >F50:@SUM(F15...F40,F43,F44,F46) >E50:@SUM(E15...E40,E43,E44,E46) >D50:@SUM(D15...D40,D43,D44,D46) >C50:@SUM(C15...C40,C43,C44,C46) >B50:"enditures >A50:"Total Exp >Q49:"! ! >P49:/-- >O49:/-- >N49:/-- >M49:/-- >L49:/-- >K49:/-- >J49:/-- >I49:/-- >H49M(N15...N40,N43,N44,N46) >M50:@SUM(M15...M40,M43,M44,M46) >L50:@SUM(L15...L40,L43,L44,L46) >K50:@SUM(K15...K40,K43,K44,K46) >J50:@SUM(J15...J40,J43,J44,J46) >I50:@SUM(I15...I40,I43,I44,I46) >H50:@SUM(H15...H40,H43,H44,H46) >G50:@SUM(G15...G40,G43,G44,G46) ...O40,O43,O44,O46) >B52:"(col. o) >A52:"Check Sum >Q51:"! ! >P51:/-= >O51:/-= >N51:/-= >M51:/-= >L51:/-= >K51:/-= >J51:/-= >I51:/-= >H51:/-= >G51:/-= >F51:/-= >E51:/-= >D51:/-= >C51:/-= >B51:/-= >A51:/-= >Q50:"! ! >O50:@SUM(C50...N50) >N50:@SU54:/FR"Mar >D54:/FR"Feb >C54:/FR"Jan >B54:"ummary >A54:"Monthly S >Q53:"! ! >P53:/-= >O53:/-= >N53:/-= >M53:/-= >L53:/-= >K53:/-= >J53:/-= >I53:/-= >H53:/-= >G53:/-= >F53:/-= >E53:/-= >D53:/-= >C53:/-= >B53:/-= >A53:/-= >Q52:"! ! >O52:@SUM(O15DDS >A22:"6a Medica >Q21:"! ! >O21:@SUM(C21...N21) >B21:"uter >A21:"5a - Comp >Q20:"! ! >O20:@SUM(C20...N20) >B20:"ld Maint. >A20:"5 Househo >Q19:"! ! >O19:@SUM(C19...N19) >B19:"g >A19:"4 Clothin >Q18:"! ! >O18:@SUM(C18...N18) >A18:"3 Food >Q17:"! ! >O17:@SUM(C17...N17) >B17:"Prop.Tax >A17:" c >Q16:"! ! >O16:@SUM(C16...N16) >B16:"Insurance >A16:" b >Q15:"! ! >O15:@SUM(C15...N15) >N15:+C15 >M15:+C15 >L15:+C15 >K15:+C15 >J15:+C15 >I15:+C15 >H15:+C15 >G15:+C15 >F1533 >G35:+G24+G33 >F35:+F24+F33 >E35:+E24+E33 >D35:+D24+D33 >C35:"enses >B35:"Total Expe >A35:" (F) >P33:@SUM(P27...P31 >O33:@SUM(O27...O31 >N33:@SUM(N27...N31 >M33:@SUM(M27...M31 >L33:@SUM(L27...L31 >K33:@SUM(K27...K31 >J33:@SUM(J27...J31 >I33:@SUM(I27]_`abcd36:/-- >O36:/-- >N36:/-- >M36:/-- >L36:/-- >K36:/-- >J36:/-- >I36:/-- >H36:/-- >G36:/-- >F36:/-- >E36:/-- >D36:/-- >C36:/-- >B36:/-- >P35:+P24+P33 >O35:+O24+O33 >N35:+N24+N33 >M35:+M24+M33 >L35:+L24+L33 >K35:+K24+K33 >J35:+J24+J33 >I35:+I24+I33 >H35:+H24+H>P38:+P10-P35 >O38:+O10-O35 >N38:+N10-N35 >M38:+M10-M35 >L38:+L10-L35 >K38:+K10-K35 >J38:+J10-J35 >I38:+I10-I35 >H38:+H10-H35 >G38:+G10-G35 >F38:+F10-F35 >E38:+E10-E35 >D38:+D10-D35 >C38:"xes >B38:"before ta >C37:"t/(Loss) >B37:"Net Profi >A37:" (G) >PA1: 1: G"Running >Q1:"! ! >P1:/FR"Per Cent >O1:/FR"Totals >N1:/FR"Dec >M1:/FR"Nov >L1:/FR"Oct >K1:/FR"Sep >J1:/FR"Aug >I1:/FR"Jul >H1:/FR"Jun >G1:/FR"May >F1:/FR"Apr >E1:/FR"Mar >D1:/FR"Feb >C1:/FR"Jan >B1:"Month--> >A1:"1982 /W1 /GOC /GRA /GF$ /GC9 /X>A1:>:+G3 >G3:+F3 >F3:+E3 >E3:+D3 >D3:+C3 >C3:0 >B3:"Salary >A3:"Income - >T2:/-- >S2:/-- >R2:/-- >Q2:"! ! >P2:/-- >O2:/-- >N2:/-- >M2:/-- >L2:/-- >K2:/-- >J2:/-- >I2:/-- >H2:/-- >G2:/-- >F2:/-- >E2:/-- >D2:/-- >C2:/-- >B2:/-- >A2:/-- >S1:"Totals >R1:/F5) >B5:"Int.Depos >T4:@SUM(C57...N57)-(12-A100)*N57 >S4:"res >R4:"Expenditu >Q4:"! ! >O4:@SUM(C4...N4) >B4:"Qual.Div. >T3:@SUM(C56...N56)-(12-A100)*N56 >R3:"Income >Q3:"! ! >O3:@SUM(C3...N3) >N3:+M3 >M3:+L3 >L3:+K3 >K3:+J3 >J3:+I3 >I3:+H3 >H3! ! >O8:@SUM(C8...N8) >B8:"Rent,Royl >Q7:"! ! >O7:@SUM(C7...N7) >B7:"Loan Int. >T6:@SUM(C59...N59)-(12-A100)*N59 >S6:"e Balance >R6:"Disposabl >Q6:"! ! >O6:@SUM(C6...N6) >B6:"Miscell. >T5:+T3-T4 >R5:"Balance >Q5:"! ! >O5:@SUM(C5...N>O10:/-- >N10:/-- >M10:/-- >L10:/-- >K10:/-- >J10:/-- >I10:/-- >H10:/-- >G10:/-- >F10:/-- >E10:/-- >D10:/-- >C10:/-- >B10:/-- >A10:/-- >Q9:"! ! >O9:@SUM(C9...N9) >B9:"Cap.Gains >T8:+C61+@SUM(C47...N47)-(12-A100)*N47 >S8:"t Depos. >R8:"Retiremen >Q8:":@SUM(M3...M9) >L11:@SUM(L3...L9) >K11:@SUM(K3...K9) >J11:@SUM(J3...J9) >I11:@SUM(I3...I9) >H11:@SUM(H3...H9) >G11:@SUM(G3...G9) >F11:@SUM(F3...F9) >E11:@SUM(E3...E9) >D11:@SUM(D3...D9) >C11:@SUM(C3...C9) >B11:"ome >A11:"Total Inc >Q10:"! ! >P10:/-- O9) >B13:" (Col. O) >A13:"Check Sum >Q12:"! ! >P12:/-= >O12:/-= >N12:/-= >M12:/-= >L12:/-= >K12:/-= >J12:/-= >I12:/-= >H12:/-= >G12:/-= >F12:/-= >E12:/-= >D12:/-= >C12:/-= >B12:/-= >A12:/-= >Q11:"! ! >O11:@SUM(C11...N11) >N11:@SUM(N3...N9) >M11:+C15 >E15:+C15 >D15:+C15 >C15:0 >B15:"Payments >A15:"2a House- >Q14:"! ! >P14:/-= >O14:/-= >N14:/-= >M14:/-= >L14:/-= >K14:/-= >J14:/-= >I14:/-= >H14:/-= >G14:/-= >F14:/-= >E14:/-= >D14:/-= >C14:/-= >B14:/-= >A14:/-= >Q13:"! ! >O13:@SUM(O3......I31 >H33:@SUM(H27...H31 >G33:@SUM(G27...G31 >F33:@SUM(F27...F31 >E33:@SUM(E27...E31 >D33:@SUM(D27...D31 >C33:"ed >B33:"Total Fix >A33:" (E) >P32:/-- >O32:/-- >N32:/-- >M32:/-- >L32:/-- >K32:/-- >J32:/-- >I32:/-- >H32:/-- >G32:/-- >F32:/-- >E32:/-- >D32:/-- >C32:/-- >B32:/-- >P31:@SUM(D31...O31 >C31:"Only >B31:"Interest >P30:@SUM(D30...O30 >C30:"icenses >B30:"Taxes & L >P29:@SUM(D29...O29 >B29:"Rent >P28:@SUM(D28...O28 >B28:"Insurance >P27:@SUM(D27...O27 >C27:"ion >B27:"Depreciat >C26:"enses: >B26:"FiA238:" Long Te >C237:+C121 >B237:"l Property >A237:" Persona >C236:+D71+D88+D104 >B236:"ies >A236:" Securit >C235:+C52 >A235:" Cash >C234:+C38 >B234:"tate >A234:" Real Es >A233:"------- >A232:"Assets: >D231:/-- >C231:/-- >B231:/-- >A231:/-- >C230eghijklmnopqrstUnpaid >C245:+C170 >B245:" Bills >A245:" Current >C244:+C153 >B244:"es >A244:" Mortgag >B243:"- >A243:/-- >B242:"s >A242:"Liabilitie >C240:(C234...C238 >B240:"ssets >A240:" Total A >C239:/-- >B239:/-- >A239:" ------- >C238:+C140 >B238:"rm Assets >>C252:+C240-C250 >A252:"Net Worth >C250:(C244...C248 >B250:"iabilities >A250:" Total L >C249:/-- >B249:/-- >A249:" ------- >C248:+C223 >B248:"ment Debt >A248:" Install >C247:+C201 >B247:"o Individ >A247:" Debts t >C246:+C185 >B246:"Taxes >A246:" ted >B1:"(Budget) /W1 /GOC /GRA /GC9 /X>A1:>A1: 1: th 7 >I5:" Month 6 >H5:" Month 5 >G5:" Month 4 >F5:" Month 3 >E5:" Month 2 >D5:" Month 1 >B5:" Item >J2:/-. >I2:/-. >H2:/-. >G2:/-. >F2:"rated by. >E2:"To be ope >J1:/-. >I1:/-. >H1:/-. >G1:"for...... >F1:" Profit >E1:"pense and >D1:" Sales-Ex >C1:"Projec >P7:@SUM(D7...O7 >B7:"Sales >A7:" (a) >P6:/-= >O6:/-= >N6:/-= >M6:/-= >L6:/-= >K6:/-= >J6:/-= >I6:/-= >H6:/-= >G6:/-= >F6:/-= >E6:/-= >D6:/-= >C6:/-= >B6:/-= >P5:" Total >O5:"Month 12 >N5:"Month 11 >M5:"Month 10 >L5:" Month 9 >K5:" Month 8 >J5:" Mon8 >F10:+F7-F8 >E10:+E7-E8 >D10:+D7-D8 >C10:"fit >B10:"Gross Profi >A10:" (c) >P9:/-- >O9:/-- >N9:/-- >M9:/-- >L9:/-- >K9:/-- >J9:/-- >I9:/-- >H9:/-- >G9:/-- >F9:/-- >E9:/-- >D9:/-- >C9:/-- >B9:/-- >P8:@SUM(D8...O8 >C8:"ales >B8:"Cost of S >A8:" (b) >C15:"ng >B15:"Advertisi >P14:@SUM(D14...O14 >C14:"axes >B14:"Payroll T >P13:@SUM(D13...O13 >B13:"Salaries >C12:"Expenses >B12:"Variable >P10:+P7-P8 >O10:+O7-O8 >N10:+N7-N8 >M10:+M7-M8 >L10:+L7-L8 >K10:+K7-K8 >J10:+J7-J8 >I10:+I7-I8 >H10:+H7-H8 >G10:+G7-G1 >B21:"Utilities >P20:@SUM(D20...O20 >B20:"Telephone >P19:@SUM(D19...O19 >B19:"Supplies >P18:@SUM(D18...O18 >C18:"ccounting >B18:"Legal & A >P17:@SUM(D17...O17 >C17:"bscript'n >B17:"Dues & Su >P16:@SUM(D16...O16 >C16:"e >B16:"Automobil >P15:@SUM(D15...O15M(D13...D22 >C24:"iable >B24:"Total Var >A24:" (D) >P23:/-- >O23:/-- >N23:/-- >M23:/-- >L23:/-- >K23:/-- >J23:/-- >I23:/-- >H23:/-- >G23:/-- >F23:/-- >E23:/-- >D23:/-- >C23:/-- >B23:/-- >P22:@SUM(D22...O22 >C22:"eous >B22:"Miscellane >P21:@SUM(D21...O2xed Exp >P24:@SUM(P13...P22 >O24:@SUM(O13...O22 >N24:@SUM(N13...N22 >M24:@SUM(M13...M22 >L24:@SUM(L13...L22 >K24:@SUM(K13...K22 >J24:@SUM(J13...J22 >I24:@SUM(I13...I22 >H24:@SUM(H13...H22 >G24:@SUM(G13...G22 >F24:@SUM(F13...F22 >E24:@SUM(E13...E22 >D24:@SU:/FR"As of: >A230:"For: >C229:/-- >B229:/-- >C228:"Statement >B228:"Net Worth >C227:"t)-C253 >B227:"ype /P1(re >A227:"To print t >C225:/-= >B225:/-= >A225:/-= >C223:(C210...C221 >A223:/FR"Total >C221:0 >A221:"J Magnin >C220:0 >A220:"JC Penney >C219:1000 >B219:"an >A219:"Medical Lo >C218:1500 >A218:"Auto Loan >C217:25 >A217:"Shell Oil >C216:20 >A216:"Capwells >C215:20 >A215:"Mervyn's >C214:20 >A214:"Macy's >C213:5 >A213:"Wards >C212:5 >A212:"Sears >C211:10 >A211:"Visa >C210:20 >B210:"ss >A210:"Amer Expre >C:/-- >D92:"Mkt Value >C92:"Mkt Price >B92:"Number >A92:"Firm >A91:"----- >A90:"Other >D88:(D77...D86 >B88:(B77...B86 >A88:/FR"Total >D86:/F$+B86*C86 >D85:+B85*C85 >D84:+B84*C84 >D83:+B83*C83 >D82:+B82*C82 >D81:+B81*C81 >D80:+B80*C80 >D79:+B79*C79 >D78:+B78 >A105:/-- >D104:(D94...D102 >B104:(B94...B102 >A104:/FR"Total >D102:/F$+B102*C102 >D101:/F$+B101*C101 >D100:/F$+B100*C100 >D99:/F$+B99*C99 >D98:/F$+B98*C98 >D97:/F$+B97*C97 >D96:/F$+B96*C96 >D95:/F$+B95*C95 >D94:/F$+B94*C94 >D93:/-- >C93:/-- >B93:/-- >A93A111:"Auto >C110:/-- >B110:/-- >A110:/-- >C109:"Est Value >B109:"Descript >A109:"Category >C108:"------- >B108:/-- >A108:/-- >C107:"rksheet >B107:"roperty Wo >A107:"Personal P >C106:"t)-C122 >B106:"ype /P1(re >A106:"To print t >D105:/-- >C105:/-- >B105:/--A119:"Other >C118:0 >B118:"Gear >A118:"Elctronic >C117:5000 >B117:"ystem >A117:"Computer S >C116:150 >B116:"ues >A116:"Art, Antiq >C115:2000 >B115:"Furs >A115:"Clothing, >C114:25000 >A114:"Furniture >C113:100 >A113:"Auto >C112:1500 >A112:"Auto >C111:2500 >>B127:"Descript >A127:"Category >C126:" Present >C125:"------ >B125:/-- >A125:/-- >C124:"ksheet >B124:"Assets Wor >A124:"Long Term >C123:"t)-C141 >B123:"ype /P1(re >A123:"To print t >C122:/-- >B122:/-- >A122:/-- >C121:(C111...C119 >A121:/FR"Total >C119:0 >135:3500 >B135:"ring >A135:"Profit Sha >C134:1500 >B134:"Options >A134:"Benefits >C133:0 >A133:"Pension >C132:0 >A132:"Annuities >C131:0 >A131:"Co. Ins >C130:25000 >A130:"Life Ins >C129:15000 >A129:"Life Ins >C128:/-- >B128:/-- >A128:/-- >C127:"Cash Value B143:"Worksheet >A143:"Mortgages >C142:"t)-C154 >B142:"ype /P1(re >A142:"To print t >C141:/-- >B141:/-- >A141:/-- >C140:(C129...C138 >A140:/FR"Total >C138:0 >A138:"Other >C137:0 >B137:"nterests >A137:"Business I >C136:0 >B136:"Royalties >A136:"Patents - >C:/-- >C153:(C148...C151 >A153:/FR"Total >C151:0 >A151:"Other >C150:25000 >A150:"Bare Land >C149:0 >A149:"2nd/Vac >C148:75000 >A148:"Prim Res >C147:/-- >B147:/-- >A147:/-- >C146:" Balance >B146:"n >A146:"Descriptio >C145:"Outstnding >B144:/-- >A144:/-- >161:200 >A161:"Doctor >C160:/-- >B160:/-- >A160:/-- >C159:" Amount >A159:"Descript >C158:"Outstnding >C157:"--- >B157:/-- >A157:/-- >C156:"eet >B156:"lls Worksh >A156:"Current Bi >C155:"t)-C172 >B155:"ype /P1(re >A155:"To print t >C154:/-- >B154:/-- >A154pe /P1(re >A173:"To print t >C172:/-- >B172:/-- >A172:/-- >C170:(C161...C168 >A170:/FR"Total >C168:0 >A168:"Other >C167:0 >A167:"Alimony >C166:50 >A166:"Phone >C165:100 >A165:"Utilities >C164:0 >A164:"Rent >C163:0 >A163:"Dentist >C162:100 >A162:"Dentist >CA180:"State Inco >C179:1500 >A179:"Fed Income >C178:0 >B178:"ents >A178:"On Investm, >C177:/-- >B177:/-- >A177:/-- >C176:"Amount >B176:"Type >A176:"Descript >C175:"-- >B175:/-- >A175:/-- >C174:"et >B174:"es Workshe >A174:"Unpaid Tax >C173:"t)-C186 >B173:"y"t)-C203 >B187:"ype /P1(re >A187:"To print t >C186:/-- >B186:/-- >A186:/-- >C185:(C178...C183 >A185:/FR"Total >C183:100 >B183:"Bare Land >A183:"Property >C182:0 >B182:"2nd/Vac >A182:"Property >C181:1000 >B181:"Prim Res >A181:"Property >C180:100 >B180:"me >.C199 >A201:/FR"Total >C199:0 >C198:0 >C197:0 >C196:0 >C195:0 >C194:0 >C193:0 >C192:100 >A192:"Chartlie >C191:/-- >B191:/-- >A191:/-- >C190:"Amount >A190:"Individual >C189:/-- >B189:/-- >A189:/-- >C188:" Worksheet >B188:"ndividuals >A188:"Debts to I >C187:209:/-- >B209:/-- >A209:/-- >C208:" Amount >A208:"Creditor >C207:"Outstnding >C206:"------ >B206:/-- >A206:/-- >C205:"ksheet >B205:"t Debt Wor >A205:"Installmen >C204:"t)-C224 >B204:"ype /P1(re >A204:"To print t >C203:/-- >B203:/-- >A203:/-- >C201:(C192..*C78 >D77:+B77*C77 >C77:55 >B77:10 >A77:"Natomas >D76:/-- >C76:/-- >B76:/-- >A76:/-- >D75:"Mkt Value >C75:"Mkt Price >B75:"Number >A75:"Firm >A74:"----- >A73:"Bonds >D71:(D61...D69 >B71:(B61...B69 >A71:/FR"Total >D69:+B69*C69 >D68:+B68*C68 >D67:+B67*C67 >D66:+B66*C66 >D65:+B65*C65 >D64:+B64*C64 >C64:75 >B64:10 >A64:"IBM >D63:+B63*C63 >C63:19 >B63:10 >A63:"Apple >D62:+B62*C62 >D61:+B61*C61 >D60:/-- >C60:/-- >B60:/-- >A60:/-- >D59:"Mkt Value >C59:" Mkt Price >B59:"Shares >A59:"Firm >A58:"------ >A57:"Stocks >33 >G35:+G24+G33 >F35:+F24+F33 >E35:+E24+E33 >D35:+D24+D33 >C35:"enses >B35:"Total Expe >A35:" (F) >P33:@SUM(P27...P31 >O33:@SUM(O27...O31 >N33:@SUM(N27...N31 >M33:@SUM(M27...M31 >L33:@SUM(L27...L31 >K33:@SUM(L27>J33...J31 >I33:@SUM(I27...I31 >H33:0 >Guwxyz{|}~36:/-- >O36:/-- >N36:/-- >M36:/-- >L36:/-- >K36:/-- >J36:/-- >I36:/-- >H36:/-- >G36:/-- >F36:/-- >E36:/-- >D36:/-- >C36:/-- >B36:/-- >P35:+P24+P33 >O35:+O24+O33 >N35:+N24+N33 >M35:+M24+M33 >L35:+L24+L33 >K35:+K24+K33 >J35:+J24+J33 >I35:+I24+I33 >H35:+H24+H>P38:+P10-P35 >O38:+O10-O35 >N38:+N10-N35 >M38:+M10-M35 >L38:+L10-L35 >K38:+K10-K35 >J38:+J10-J35 >I38:+I10-I35 >H38:+H10-H35 >G38:+G10-G35 >F38:+F10-F35 >E38:+E10-E35 >D38:+D10-D35 >C38:"xes >B38:"before ta >C37:"t/(Loss) >B37:"Net Profi >A37:" (G) >Ph >A1:/F$" visicalc /W1 /GOC /GRA /GF$ /GC10 /X!/X>A1:>A1: "worksheets >A5:"series of >C4:"sing a >B4:"ement by u >A4:"worth stat >C3:"es a net >B3:"ate produc >A3:"This templ >C2:/-- >B2:/-- >A2:/-- >C1:" Statement >B1:" Net Worth >A1:/F$" Visicalc /W1 /GOC /GRA /GF$ /GC10 /X>A1:>A1: 27: statement >B1:" net wort>A11:"below- ent >C10:"cated >B10:"et as indi >A10:"master she >C9:"ed on the >B9:" are locat >A9:"worksheets >C8:"vidual >B8:"mory. Indi >A8:" 10k of me >C7:"ccupies >B7:"ined and o >A7:"self-conta >C6:" It is >B6:"statement. >A6:"produce a >C5:" to >B5:/FR"A61 >B18:"ties>>>>>> >A18:" 3. Securi >C17:/FR"C46 >B17:/-> >A17:" 2. Cash>> >C16:/FR"B33 >B16:"state>>>>> >A16:" 1. Real E >C15:/-- >B15:/-- >A15:/-- >C14:" Location >A14:"Title >C13:"Data Entry >C12:/-- >B12:/-- >A12:/-- >C11:" D230 >B11:"er date at to Indiv.> >A24:" 9. Debts >C23:/FR"C178 >B23:" Taxes>>>> >A23:" 8. Unpaid >C22:/FR"C161 >B22:"t Bills>>> >A22:" 7. Curren >C21:/FR"C148 >B21:"ges >>>>>> >A21:" 6. Mortga >C20:/FR"B129 >B20:"erm assets >A20:" 5. Long T >C19:/FR"B111 >A19:" 4. Person >C18:ript. >C30:" Present >B30:" Purchase >C29:"- >B29:/-- >A29:"---------- >C28:"t. >B28:"e Workshee >A28:"Real Estat >C27:"t)-C39 >B27:"ype /P1(re >A27:"To print t >C26:/-- >B26:/-- >A26:/-- >C25:/FR"C210 >B25:"lment Debt >A25:"10. Instal >C24:/FR"A192 >B24:"- >A39:/-- >C38:(C33...C36 >B38:(B33...B36 >A38:/FR"Total >C36:0 >B36:0 >A36:"Other >C35:35000 >B35:20000 >A35:"Bare Land >C34:0 >B34:0 >A34:"2nd/Vac >C33:150000 >B33:120000 >A33:"Prim. Res. >C32:/-- >B32:/-- >A32:/-- >C31:" Value >B31:" Price >A31:"Desc"Savings >C46:5000 >A46:"Savings >C45:/-- >B45:/-- >A45:/-- >C44:" Balance >B44:"Location >A44:"Descript. >C43:" Current >C42:"-- >B42:/-- >A42:/-- >C41:"et >B41:"nd Workshe >A41:"Cash on Ha >C40:"t)-C53 >B40:"ype /P1(re >A40:"To print t >C39:/-- >B39:/-B56:/-- >A56:/-- >B55:" Worksheet >A55:"Securities >C54:"t)-D105 >B54:"ype /P1(re >A54:"To print t >C53:/-- >B53:/-- >A53:/-- >C52:(C46...C50 >A52:/FR"Total >C50:25 >B50:"cket >A50:"Cash in Po >C49:0 >A49:"Svgs Bonds >C48:2500 >A48:"Checking >C47:200 >A47:33:@SUM(G27...G31 >F33:@SUM(F27...F31 >E33:@SUM(E27...E31 >D33:@SUM(D27...D31 >C33:"ed >B33:"Total Fix >A33:" (E) >P32:/-- >O32:/-- >N32:/-- >M32:/-- >L32:/-- >K32:/-- >J32:/-- >I32:/-- >H32:/-- >G32:/-- >F32:/-- >E32:/-- >D32:/-- >C32:/-- >B32:/-- >P31:@SUM(D31...O31 >C31:"Only >B31:"Interest >P30:@SUM(D30...O30 >D30:100 >C30:"icenses >B30:"Taxes & L >P29:@SUM(D29...O29 >O29:300 >N29:300 >M29:300 >L29:300 >K29:300 >J29:300 >I29:300 >H29:300 >G29:300 >F29:300 >E29:300 >D29:300 >B29:"Rent >P28:@SUM(D28..>L52:+L49+L50 >J52:+J49+J50 >H52:+H49+H50 >F52:+F49+F50 >C52:"Total Cost >L51:/-- >K51:/-- >J51:/-- >I51:/-- >H51:/-- >G51:/-- >F51:/-- >E51:/-- >D51:/-- >C51:/-- >L50:+L49*.065 >J50:+J49*.065 >H50:+H49*.065 >F50:+F49*.065 >D50:" @ 6.5% >C50:" Sales Tax >B/-. >I1:/-. >H1:/-. >G1:"for...... >F1:" Profit >E1:"pense and >D1:" Sales-Ex >C1:"Projected >B1:"(Budget) /W1 /GOC /GRA /GC9 /X>A28:>A47: /GOC /GRA /GC9 /X-/X>A1:>A1: :" Total >O5:"Month 12 >N5:"Month 11 >M5:"Month 10 >L5:" Month 9 >K5:" Month 8 >J5:" Month 7 >I5:" Month 6 >H5:" Month 5 >G5:" Month 4 >F5:" Month 3 >E5:" Month 2 >D5:" Month 1 >B5:" Item >J2:/-. >I2:/-. >H2:/-. >G2:/-. >F2:"rated by. >E2:"To be ope >J1:000 >N7:11000 >M7:12000 >L7:9000 >K7:2500 >J7:7000 >I7:5000 >H7:9000 >G7:12000 >F7:10000 >E7:1200 >D7:2000 >B7:"Sales >A7:" (a) >P6:/-= >O6:/-= >N6:/-= >M6:/-= >L6:/-= >K6:/-= >J6:/-= >I6:/-= >H6:/-= >G6:/-= >F6:/-= >E6:/-= >D6:/-= >C6:/-= >B6:/-= >P59:/-- >I9:/-- >H9:/-- >G9:/-- >F9:/-- >E9:/-- >D9:/-- >C9:/-- >B9:/-- >P8:@SUM(D8...O8 >O8:2000 >N8:2300 >M8:8500 >L8:3500 >K8:1000 >J8:2000 >I8:1000 >H8:1000 >G8:6000 >F8:3000 >E8:650 >D8:2000 >C8:"ales >B8:"Cost of S >A8:" (b) >P7:@SUM(D7...O7 >O7:10riable >P10:+P7-P8 >O10:+O7-O8 >N10:+N7-N8 >M10:+M7-M8 >L10:+L7-L8 >K10:+K7-K8 >J10:+J7-J8 >I10:+I7-I8 >H10:+H7-H8 >G10:+G7-G8 >F10:+F7-F8 >E10:+E7-E8 >D10:+D7-D8 >C10:"fit >B10:"Gross Profi >A10:" (c) >P9:/-- >O9:/-- >N9:/-- >M9:/-- >L9:/-- >K9:/-- >J4:150 >H14:150 >G14:150 >F14:150 >E14:150 >D14:150 >C14:"axes >B14:"Payroll T >P13:@SUM(D13...O13 >O13:1000 >N13:1000 >M13:1000 >L13:1000 >K13:1000 >J13:1000 >I13:1000 >H13:1000 >G13:1000 >F13:1000 >E13:1000 >D13:1000 >B13:"Salaries >C12:"Expenses >B12:"Va0 >C16:"e >B16:"Automobil >P15:@SUM(D15...O15 >O15:100 >N15:100 >M15:100 >L15:100 >K15:100 >J15:100 >I15:100 >H15:100 >G15:100 >F15:100 >E15:100 >D15:100 >C15:"ng >B15:"Advertisi >P14:@SUM(D14...O14 >O14:150 >N14:150 >M14:150 >L14:150 >K14:150 >J14:150 >I18:50 >F18:50 >E18:50 >D18:50 >C18:"ccounting >B18:"Legal & A >P17:@SUM(D17...O17 >L17:50 >D17:100 >C17:"bscript'n >B17:"Dues & Su >P16:@SUM(D16...O16 >O16:100 >N16:100 >M16:100 >L16:100 >K16:100 >J16:100 >I16:100 >H16:100 >G16:100 >F16:100 >E16:100 >D16:1020:15 >E20:15 >D20:15 >B20:"Telephone >P19:@SUM(D19...O19 >O19:10 >N19:10 >M19:10 >L19:10 >K19:10 >J19:10 >I19:10 >H19:10 >G19:10 >F19:10 >E19:10 >D19:10 >B19:"Supplies >P18:@SUM(D18...O18 >O18:50 >N18:50 >M18:50 >L18:50 >K18:50 >J18:50 >I18:50 >H18:50 >G1 >B22:"Miscellane >P21:@SUM(D21...O21 >O21:100 >N21:100 >M21:100 >L21:100 >K21:100 >J21:100 >I21:100 >H21:100 >G21:100 >F21:100 >E21:100 >D21:100 >B21:"Utilities >P20:@SUM(D20...O20 >O20:15 >N20:15 >M20:15 >L20:15 >K20:15 >J20:15 >I20:15 >H20:15 >G20:15 >F3...F22 >E24:@SUM(E13...E22 >D24:@SUM(D13...D22 >C24:"iable >B24:"Total Var >A24:" (D) >P23:/-- >O23:/-- >N23:/-- >M23:/-- >L23:/-- >K23:/-- >J23:/-- >I23:/-- >H23:/-- >G23:/-- >F23:/-- >E23:/-- >D23:/-- >C23:/-- >B23:/-- >P22:@SUM(D22...O22 >C22:"eousB27:"Depreciat >C26:"enses: >B26:"Fixed Exp >P24:@SUM(P13...P22 >O24:@SUM(O13...O22 >N24:@SUM(N13...N22 >M24:@SUM(M13...M22 >L24:@SUM(L13...L22 >K24:@SUM(K13...K22 >J24:@SUM(J13...J22 >I24:@SUM(I13...I22 >H24:@SUM(H13...H22 >G24:@SUM(G13...G22 >F24:@SUM(F1.O28 >O28:10 >N28:10 >M28:10 >L28:10 >K28:10 >J28:10 >I28:10 >H28:10 >G28:10 >F28:10 >E28:10 >D28:10 >B28:"Insurance >P27:@SUM(D27...O27 >O27:100 >N27:100 >M27:100 >L27:100 >K27:100 >J27:100 >I27:100 >H27:100 >G27:100 >F27:100 >E27:100 >D27:100 >C27:"ion >50:"California >L49:@SUM(L28...L47 >J49:@SUM(J28...J47 >H49:@SUM(H28...H47 >F49:@SUM(F28...F47 >C49:"erchandise >B49:"Subtotal M >L48:/-= >K48:/-= >J48:/-= >I48:/-= >H48:/-= >G48:/-= >F48:/-= >E48:/-= >D48:/-= >C48:/-= >B48:/-= >A48:/-= >L47:+D47*K47 >K47:d and >B10:"items requ >A10:"enter the >C9:"should >B9:" The user s >A9:"as needed. >C8:" and rows >B8:"ng columns >A8:"by inserti >C7:"nd width >B7:"n length a >A7:"expanded i >C6:"It may be >B6:"t l52. >A6:"and ends a >C5:"A20 >B5:"begins at >A5:"works>C15:"item then >B15:" for each >A15:"each store >C14:" price for >B14:"rows. Unit >A14:"of double >C13:"f each set >B13:" the top o >A13:"entered at >C12:"ld be >B12:"names shou >A12:"the store >C11:"tem req'd. >B11:" of each i >A11:"the number >C10:"iree >G20:"(insert pr >F20:/-. >E20:/-. >D20:/-. >C20:"or........ >B20:"e prices f >A20:"Comparativ >C18:"e project. >B18:"ice for th >A18:"minimum pr >C17:"rice and >B17:"te store p >A17:"will compu >D16:"e >C16:"he templat >B16:"entered. T >A16:"should be :"tores >K22:" All S >J22:" No 3 >I22:" Store >H22:" No 2 >G22:" Store >F22:" No 1 >E22:" Store >L21:"m Price >K21:" Minimu >J21:"Name of >I21:" Enter >H21:"Name of >G21:" Enter >F21:"Name of >E21:" Enter >I20:") >H20:"oject namore >K25:/FL" Unit >J25:" Store >I25:/FL" Unit >H25:" Store >G25:/FL" Unit >F25:" Store >E25:/FL" Unit >D25:" Number >J24:/-. >I24:/-. >H24:/-. >G24:/-. >F24:/-. >E24:/FR/-. >J23:"ow >I23:/FR"Bel >H23:"ow >G23:/FR"Bel >F23:"ow >E23:/FR"Bel >L2227:/-- >I27:/-- >H27:/-- >G27:/-- >F27:/-- >E27:/-- >D27:/-- >C27:/-- >B27:/-- >A27:/-- >L26:" Price >K26:" Cost >J26:" Price >I26:" Cost >H26:" Price >G26:" Cost >F26:" Price >E26:" Cost >D26:" Required >B26:"iption >A26:"Item Descr >L25:" St,I30) >J30:+D30*I30 >H30:+D30*G30 >F30:+D30*E30 >A30:/FR3 >L29:+D29*K29 >K29:@MIN(E29,G29,I29) >J29:+D29*I29 >H29:+D29*G29 >F29:+D29*E29 >A29:/FR2 >L28:+D28*K28 >K28:@MIN(E28,G28,I28) >J28:+D28*I28 >H28:+D28*G28 >F28:+D28*E28 >A28:/FR1 >L27:/-- >K27:/-- >J+D33*I33 >H33:+D33*G33 >F33:+D33*E33 >A33:/FR6 >L32:+D32*K32 >K32:@MIN(E32,G32,I32) >J32:+D32*I32 >H32:+D32*G32 >F32:+D32*E32 >A32:/FR5 >L31:+D31*K31 >K31:@MIN(E31,G31,I31) >J31:+D31*I31 >H31:+D31*G31 >F31:+D31*E31 >A31:/FR4 >L30:+D30*K30 >K30:@MIN(E30,G3036:+D36*G36 >F36:+D36*E36 >A36:/FR9 >L35:+D35*K35 >K35:@MIN(E35,G35,I35) >J35:+D35*I35 >H35:+D35*G35 >F35:+D35*E35 >A35:/FR8 >L34:+D34*K34 >K34:@MIN(E34,G34,I34) >J34:+D34*I34 >H34:+D34*G34 >F34:+D34*E34 >A34:/FR7 >L33:+D33*K33 >K33:@MIN(E33,G33,I33) >J33:39:+D39*E39 >A39:/FR12 >L38:+D38*K38 >K38:@MIN(E38,G38,I38) >J38:+D38*I38 >H38:+D38*G38 >F38:+D38*E38 >A38:/FR11 >L37:+D37*K37 >K37:@MIN(E37,G37,I37) >J37:+D37*I37 >H37:+D37*G37 >F37:+D37*E37 >A37:/FR10 >L36:+D36*K36 >K36:@MIN(E36,G36,I36) >J36:+D36*I36 >H42:/FR15 >L41:+D41*K41 >K41:@MIN(E41,G41,I41) >J41:+D41*I41 >H41:+D41*G41 >F41:+D41*E41 >A41:/FR14 >L40:+D40*K40 >K40:@MIN(E40,G40,I40) >J40:+D40*I40 >H40:+D40*G40 >F40:+D40*E40 >A40:/FR13 >L39:+D39*K39 >K39:@MIN(E39,G39,I39) >J39:+D39*I39 >H39:+D39*G39 >F+D44*K44 >K44:@MIN(E44,G44,I44) >J44:+D44*I44 >H44:+D44*G44 >F44:+D44*E44 >A44:/FR17 >L43:+D43*K43 >K43:@MIN(E43,G43,I43) >J43:+D43*I43 >H43:+D43*G43 >F43:+D43*E43 >A43:/FR16 >L42:+D42*K42 >K42:@MIN(E42,G42,I42) >J42:+D42*I42 >H42:+D42*G42 >F42:+D42*E42 >A@MIN(E47,G47,I47) >J47:+D47*I47 >H47:+D47*G47 >F47:+D47*E47 >A47:/FR20 >L46:+D46*K46 >K46:@MIN(E46,G46,I46) >J46:+D46*I46 >H46:+D46*G46 >F46:+D46*E46 >A46:/FR19 >L45:+D45*K45 >K45:@MIN(E45,G45,I45) >J45:+D45*I45 >H45:+D45*G45 >F45:+D45*E45 >A45:/FR18 >L44:heet >C4:". The >B4:" worksheet >A4:"entry to a >C3:"es direct >B3:"ate requir >A3:"This templ >C2:/-- >B2:/-- >A2:/-- >C1:" Template >B1:"e Shopping >A1:"Comparativ /W1 /GOC /GRA /GF$ /GC10 /X>G64:>G83: >L52:+L49+L50 >J52:+J49+J50 >H52:+H49+H50 >F52:+F49+F50 >C52:"Total Cost >L51:/-- >K51:/-- >J51:/-- >I51:/-- >H51:/-- >G51:/-- >F51:/-- >E51:/-- >D51:/-- >C51:/-- >L50:+L49*.065 >J50:+J49*.065 >H50:+H49*.065 >F50:+F49*.065 >D50:" @ 6.5% >C50:" Sales Tax >Bequired >B26:"iption >A26:"Item Descr >L25:" Store >K25:/FL" Unit >J25:" Store >I25:/FL" Unit >H25:" Store >G25:/FL" Unit >F25:" Store >E25:/FL" Unit >D25:" Number >J24:/-. >I24:/-. >H24:/-. >G24:/-. >F24:/-. >E24:/FR/-. >J23:"ow >I23:/FR"Bel >B28:"Apple II C >A28:/FR1 >L27:/-- >K27:/-- >J27:/-- >I27:/-- >H27:/-- >G27:/-- >F27:/-- >E27:/-- >D27:/-- >C27:/-- >B27:/-- >A27:/-- >L26:" Price >K26:" Cost >J26:" Price >I26:" Cost >H26:" Price >G26:" Cost >F26:" price >E26:" cost >D26:" r9,I29) >J29:+D29*I29 >I29:395 >H29:+D29*G29 >G29:450 >F29:+D29*E29 >E29:400 >D29:2 >C29:" II Drives >B29:"Apple Disk >A29:/FR2 >L28:+D28*K28 >K28:@MIN(E28,G28,I28) >J28:+D28*I28 >I28:1550 >H28:+D28*G28 >G28:1450 >F28:+D28*E28 >E28:1500 >D28:1 >C28:"omputer1*G31 >G31:200 >F31:+D31*E31 >E31:169 >D31:1 >B31:"Visicalc >A31:/FR4 >L30:+D30*K30 >K30:@MIN(E30,G30,I30) >J30:+D30*I30 >I30:142 >H30:+D30*G30 >G30:125 >F30:+D30*E30 >E30:100 >D30:1 >C30:"trlr Card >B30:"Disk II Cn >A30:/FR3 >L29:+D29*K29 >K29:@MIN(E29,G20 Printer >B33:"Epson MX-1 >A33:/FR6 >L32:+D32*K32 >K32:@MIN(E32,G32,I32) >J32:+D32*I32 >I32:112 >H32:+D32*G32 >G32:118 >F32:+D32*E32 >E32:125 >D32:1 >C32:"ssor >B32:"Word Proce >A32:/FR5 >L31:+D31*K31 >K31:@MIN(E31,G31,I31) >J31:+D31*I31 >I31:185 >H31:+D3K34:@MIN(E34,G34,I34) >J34:+D34*I34 >I34:95 >H34:+D34*G34 >G34:125 >F34:125 >E34:125 >D34:1 >C34:"roller Crd >B34:"Epson Cont >A34:/FR7 >L33:+D33*K33 >K33:@MIN(E33,G33,I33) >J33:+D33*I33 >I33:705 >H33:+D33*G33 >G33:640 >F33:+D33*E33 >E33:695 >D33:1 >C33:"036:3.5 >H36:+D36*G36 >G36:2.5 >F36:+D36*E36 >E36:2.25 >D36:10 >C36:"s - 10 ea >B36:"Blank Disk >A36:/FR9 >L35:+D35*K35 >K35:@MIN(E35,G35,I35) >J35:+D35*I35 >I35:38 >H35:+D35*G35 >G35:30 >F35:+D35*E35 >E35:35 >D35:1 >B35:"Box Paper >A35:/FR8 >L34:+D34*K34 >39:+D39*E39 >A39:/FR12 >L38:+D38*K38 >K38:@MIN(E38,G38,I38) >J38:+D38*I38 >H38:+D38*G38 >F38:+D38*E38 >A38:/FR11 >L37:+D37*K37 >K37:@MIN(E37,G37,I37) >J37:+D37*I37 >H37:+D37*G37 >F37:+D37*E37 >A37:/FR10 >L36:+D36*K36 >K36:@MIN(E36,G36,I36) >J36:+D36*I36 >I42:/FR15 >L41:+D41*K41 >K41:@MIN(E41,G41,I41) >J41:+D41*I41 >H41:+D41*G41 >F41:+D41*E41 >A41:/FR14 >L40:+D40*K40 >K40:@MIN(E40,G40,I40) >J40:+D40*I40 >H40:+D40*G40 >F40:+D40*E40 >A40:/FR13 >L39:+D39*K39 >K39:@MIN(E39,G39,I39) >J39:+D39*I39 >H39:+D39*G39 >F+D44*K44 >K44:@MIN(E44,G44,I44) >J44:+D44*I44 >H44:+D44*G44 >F44:+D44*E44 >A44:/FR17 >L43:+D43*K43 >K43:@MIN(E43,G43,I43) >J43:+D43*I43 >H43:+D43*G43 >F43:+D43*E43 >A43:/FR16 >L42:+D42*K42 >K42:@MIN(E42,G42,I42) >J42:+D42*I42 >H42:+D42*G42 >F42:+D42*E42 >A@MIN(E47,G47,I47) >J47:+D47*I47 >H47:+D47*G47 >F47:+D47*E47 >A47:/FR20 >L46:+D46*K46 >K46:@MIN(E46,G46,I46) >J46:+D46*I46 >H46:+D46*G46 >F46:+D46*E46 >A46:/FR19 >L45:+D45*K45 >K45:@MIN(E45,G45,I45) >J45:+D45*I45 >H45:+D45*G45 >F45:+D45*E45 >A45:/FR18 >L44:50:"California >L49:@SUM(L28...L47 >J49:@SUM(J28...J47 >H49:@SUM(H28...H47 >F49:@SUM(F28...F47 >C49:"erchandise >B49:"Subtotal M >L48:/-= >K48:/-= >J48:/-= >I48:/-= >H48:/-= >G48:/-= >F48:/-= >E48:/-= >D48:/-= >C48:/-= >B48:/-= >A48:/-= >L47:+D47*K47 >K47:>H23:"ow >G23:/FR"Bel >F23:"ow >E23:/FR"Bel >L22:"tores >K22:" All S >J22:" No 3 >I22:" Store >H22:" No 2 >G22:" Store >F22:" No 1 >E22:" Store >L21:"m Price >K21:" Minimu >J21:"Name of >I21:" Enter >H21:"Name of >G21:" Enter >F21:"Name of >E21:" Enter >I20:") >H20:"oject name >G20:"(insert pr >F20:/-. >E20:/-. >D20:/-. >C20:"or........ >B20:"e prices f >A20:"Comparativ >C18:"e project. >B18:"ice for th >A18:"minimum pr >C17:"rice and >B17:"te store p >A17:"will compu >D16:"e >C"hool: 2/c >E62:"Castro Sc >D62:+D60-D61 >C62:"e(1a-1b)= >B62:"1c balanc >H61:20 >G61:"/campaign >F61:"School: 2 >E61:"Anderson >D61:+AD15 >C61:"s = >B61:"1b return >H60:20 >G60:"paign >F60:"ts: 1/cam >E60:"to Stewar >D60:+AD24 >C60:"sales = >B6ancis >D65:+D62-D64 >C65:"t(1c-2) = >B65:"oss profi >A65:" 3 gr >H64:10 >G64:" 20mi ea >F64:"eetings @ >E64:"monthly m >D64:+D88 >C64:"line 8) = >B64:"(sch c-1, >H63:20 >E63:"goodman >C63:"ds >B63:"st of goo >A63:" 2 co >H62:8 >G62:"ampaign >F62:B69:"d debts >A69:" 8 bad >C68:"s >B68:"Deduction >A68:"Part II >D67:+D65+D66 >C67:"e(3+4) = >B67:"tal incom >A67:" 5 to >H66:@SUM(H59...H65 >G66:"total = >C66:"e = >B66:"her incom >A66:" 4 ot >H65:30 >G65:"n @30 >F65:"1/campaig >E65:"Fr3:" 32a d >D72:/F$@SUM(AD47...AD49 >C72:" = >B72:"stage >A72:" 23 po >D71:/F$+AD45+AD46 >C71:"lies = >B71:"fice supp >A71:" 21 of >D70:/F$+D93 >C70:" (c-2) = >B70:"reciation(sch c-2) >A70:" 13dep >D69:/F$+AD52+AD53 >C69:" = > >C76:"6thru32)= >B76:"tal ded ( >A76:" 33 to >D75:/F$+AD40+AD41+AD54+AD55 >C75:"ous = >B75:"iscellane >A75:" 32c m >D74:/F$@SUM(AD36...AD39 >C74:"ustomers= >B74:"ifts to c >A74:" 32b g >D73:/F$+AD26*(1+B8) >C73:"ials = >B73:"emo mater >A7:"ersonal u >A81:" 2b p >D80:/F$ >C80:" = >B80:"urchases >A80:" 2a p >D79:/F$ >C79:"eginning= >B79:"ventory,b >A79:" 1 in >B78:"C-1 >A78:"Schedule >D77:/F$+D67-D76 >C77:"ss>5-33 = >B77:"profitA77:" 34net >D76:/F$@SUM(D69...D75):"to expens >A85:" 5 au >D84:/F$+AD30-AD17 >C84:" suppls = >B84:"terials & >A84:" 4 ma >D83:/F$+AD50+AD51 >C83:"or = >B83:"st of lab >A83:" 3 co >D82:/F$+D80-D81 >C82:"-2b) = >B82:"alance(2a >A82:" 2c b >D81:/F$ >C81:"se items= >B81"Schedule >D88:/F$+D86-D87 >C88:"ds sold = >B88:"st of goo >A88:" 8 co >D87:/F$ >C87:"ear end = >B87:"ventory,y >A87:" 7 in >D86:/F$+D79+D82+D83+D84+D85 >C86:"d 3,4,5 = >B86:"m 1,2c,and >A86:" 6 su& >D85:/F$+AD42+AD43+AD44 >C85:"e = >B85>D93:/F$258 >C93:" = >B93:"tals >A93:" 3 to >D92:/F$ >C92:" = >B92:"inter >A92:" pr >D91:/F$ >C91:" = >B91:"mputer >A91:" 2 co >D90:/F$ >C90:"first-yr= >B90:"ditional >A90:" 1 ad >C89:"ciation >B89:"C-2 deprec >A89:A6:"and ends a >C5:"A20 >B5:"begins at >A5:"worksheet >C4:". The >B4:" worksheet >A4:"entry to a >C3:"es direct >B3:"ate requir >A3:"This templ >C2:/-- >B2:/-- >A2:/-- >C1:" Template >B1:"e Shopping >A1:"Comparativ /W1 /GOC /GRA /GF$ /GC10 /X>A1:>A1: eq'd. >B11:" of each i >A11:"the number >C10:"ired and >B10:"items requ >A10:"enter the >C9:"should >B9:" The user s >A9:"as needed. >C8:" and rows >B8:"ng columns >A8:"by inserti >C7:"nd width >B7:"n length a >A7:"expanded i >C6:"It may be >B6:"t l52. >16:"he templat >B16:"entered. T >A16:"should be >C15:"item then >B15:" for each >A15:"each store >C14:" price for >B14:"rows. Unit >A14:"of double >C13:"f each set >B13:" the top o >A13:"entered at >C12:"ld be >B12:"names shou >A12:"The store >C11:"tem r0:"1a gross >H59:24 >F59:"ound trip >E59:"Almaden r >B59:"come >A59:"Part I In >H58:"es/campgn >G58:"kdown mil >F58:"nses brea >E58:"auto expe >C58:"040) >B58:"C (Form 1 >A58:"Schedule >C57:" Data >B57:"ncome Tax >A57:"Federal I >AG56:/-- >AF56:/-- >AE56:/-- >AD56:/-- >AC56:/-- >AB56:/-- >AA56:/-- >Z56:/-- >Y56:/-- >X56:/-- >W56:/-- >V56:/-- >U56:/-- >T56:/-- >S56:/-- >R56:/-- >Q56:/-- >P56:/-- >O56:/-- >N56:/-- >M56:/-- >L56:/-- >K56:/-- >J56:/-- >I56:/-- >H56:/-- >G56:/-- >F56:/-- >E56:/-- >D56:/-- >C56:-- >AF33:/-- >AE33:/-- >AD33:/-- >AC33:/-- >AB33:/-- >AA33:/-- >Z33:/-- >Y33:/-- >X33:/-- >W33:/-- >V33:/-- >U33:/-- >T33:/-- >S33:/-- >R33:/-- >Q33:/-- >P33:/-- >O33:/-- >N33:/-- >M33:/-- >L33:/-- >K33:/-- >J33:/-- >I33:/-- >H33:/-- >G33:/-- >F33:/-- >E3335:+L35+1 >L35:+K35+1 >K35:+J35+1 >J35:+I35+1 >I35:+H35+1 >H35:+G35+1 >G35:+F35+1 >F35:+E35+1 >E35:+D35+1 >D35:/FR1 >C35:"campaign >AG34:"s********** >AF34:" expense >AE34:"****other >AD34:"**total** >C34:"enses**** >B34:"Other Exp >A34:"********* >AG33:/:"omers = >B36:"s to cust >A36:" +Gift >AD35:" 1981 >AC35:/FR26 >AB35:+AA35+1 >AA35:+Z35+1 >Z35:+Y35+1 >Y35:+X35+1 >X35:+W35+1 >W35:+V35+1 >V35:+U35+1 >U35:+T35+1 >T35:+S35+1 >S35:+R35+1 >R35:+Q35+1 >Q35:+P35+1 >P35:+O35+1 >O35:+N35+1 >N35:+M35+1 >M= >B37:"ustomer p >A37:" (at c >AG36:"omers > >AF36:"s to cust >AE36:" +Gift >AD36:@SUM(D36...AC36) >AB36:407.35 >Z36:128.93 >W36:42.6 >V36:35.34 >U36:59.63 >S36:4.89 >R36:37.24 >P36:52.28 >O36:12.25 >N36:90.52 >L36:10.55 >K36:25.43 >J36:13.77 >C36nment >A40:" +Ente >AG39:" > >AD39:@SUM(D39...AC39) >C39:" = >AG38:" > >AD38:@SUM(D38...AC38) >C38:" = >AG37:"rice > >AF37:"ustomer p >AE37:" (at c >AD37:@SUM(D37...AC37) >AA37:201.97 >Z37:76.37 >P37:7.43 >C37:"rice) 42:132 >G42:132 >F42:132 >E42:132 >D42:70 >C42:" = >B42:" mileage >A42:" +Auto >AG41:" > >AD41:@SUM(D41...AC41) >C41:" = >AG40:" > >AF40:"rtainment >AE40:" +Ente >AD40:@SUM(D40...AC40) >Z40:34.87 >C40:" = >B40:"rtai> >AF42:" mileage >AE42:" +auto >AD42:@SUM(D42...AC42)*.2 >AC42:132 >AB42:132 >AA42:132 >Z42:132 >Y42:132 >X42:132 >W42:132 >V42:132 >U42:132 >T42:132 >S42:132 >R42:132 >Q42:132 >P42:132 >O42:132 >N42:132 >M42:132 >L42:132 >K42:132 >J42:132 >I42:132 >HC44:" = >AG43:/FL.2 >AF43:/FL"le rate)= >AE43:" ($/mi >AD43:@SUM(D43...AC43)*.2 >AB43:10 >Z43:10 >X43:10 >V43:10 >T43:10 >R43:10 >P43:10 >N43:10 >L43:10 >J43:10 >H43:10 >F43:10 >D43:10 >C43:/FL.2 >B43:/FL"le rate)= >A43:" ($/mi >AG42:" = >AG45:"es > >AF45:"ce suppli >AE45:" +Offi >AD45:@SUM(D45...AC45) >Z45:1.04 >U45:3.1 >T45:41.3 >S45:21.51 >P45:25.34 >M45:29.46 >J45:233.95 >I45:5.96 >C45:"es = >B45:"ce suppli >A45:" +Offi >AG44:" > >AD44:@SUM(D44...AC44)*.2 >Y47:17.77 >V47:1.05 >S47:10.7 >R47:2.15 >O47:10.34 >L47:2.77 >K47:1.08 >J47:2.95 >I47:20.26 >H47:8 >G47:8 >C47:" = >B47:"age >A47:" +Post >AG46:" > >AD46:@SUM(D46...AC46) >V46:33.39 >U46:.75 >S46:22.45 >P46:29.35 >J46:5 >I46:5 >C46:" > >AD49:@SUM(D49...AC49) >L49:.69 >K49:1.28 >J49:1.39 >C49:" = >AG48:" > >AD48:@SUM(D48...AC48) >R48:3.33 >Q48:10.7 >O48:2.72 >L48:2.7 >K48:2.1 >C48:" = >AG47:" > >AF47:"age >AE47:" +Post >AD47:@SUM(D47...AC47) >Z47:2.55 >..AC50) >AC50:5 >AB50:5 >AA50:5 >Z50:5 >Y50:5 >X50:5 >W50:5 >V50:5 >U50:5 >T50:5 >S50:5 >R50:5 >Q50:5 >P50:20 >O50:5 >N50:5 >M50:5 >L50:5 >K50:5 >J50:5 >I50:5 >H50:5 >G50:5 >F50:5 >E50:5 >D50:5 >C50:"r = >B50:"very labo >A50:" +Deli >AG49:" >AG52:" > >AF52:"debts >AE52:" +bad >AD52:@SUM(D52...AC52) >T52:12.36 >H52:4.5 >C52:" = >B52:"debts >A52:" +Bad >AG51:" > >AD51:@SUM(D51...AC51) >C51:" = >AG50:"r > >AF50:"very labo >AE50:" +Deli >AD50:@SUM(D50./-- >B56:/-- >A56:/-- >AG55:" > >AD55:@SUM(D55...AC55) >C55:" = >AG54:" > >AF54:"ellaneous >AE54:" +Misc >AD54:@SUM(D54...AC54) >C54:" = >B54:"ellaneous >A54:" +Misc >AG53:" > >AD53:@SUM(D53...AC53) >C53:" = :/-- >D33:/-- >C33:/-- >B33:/-- >A33:/-- >AG32:"s order > >AF32:"harge thi >AE32:"service c >AD32:@SUM(D32...AC32 >AB32:0 >AA32:0 >Z32:0 >Y32:0 >X32:0 >W32:0 >C32:"s order = >B32:"harge thi >A32:"service c >AG30:"r items > >AF30:", custome >AE30:"your cost >AD30:@SUM(D30...AC30 >AB30:599.73 >AA30:424.89 >Z30:352.55 >Y30:430.13 >X30:309.93 >W30:263.73 >V30:255.97 >U30:294.56 >T30:194.43 >S30:125.36 >R30:145.62 >Q30:230.18 >P30:300.16 >O30:165.38 >N30:277.97 >L30:252.62 >K30:181.34 >J30:126.11 >I30:201.81 >H3/-- >Z10:/-- >Y10:/-- >X10:/-- >W10:/-- >V10:/-- >U10:/-- >T10:/-- >S10:/-- >R10:/-- >Q10:/-- >P10:/-- >O10:/-- >N10:/-- >M10:/-- >L10:/-- >K10:/-- >J10:/-- >I10:/-- >H10:/-- >G10:/-- >F10:/-- >E10:/-- >D10:/-- >C10:/-- >B10:/-- >A10:/-- >AC9:/FL26 >AB9:/F** >AD13:" 1981 >C13:"** >B13:"Credits** >A13:" **** >AD12:"totals >AG11:"ement > >AF11:"your stat >AE11:"ies from >AD11:" entr >D11:": >C11:"statement >B11:"rom your >A11:"Entries f >AG10:/-- >AF10:/-- >AE10:"AD10:/-- >AC10:/-- >AB10:/-- >AA10:40.92 >R15:53.51 >Q15:20.65 >P15:34.47 >O15:71.92 >N15:37.51 >M15:72.97 >L15:0 >K15:2.24 >J15:20.98 >I15:19.98 >H15:70.34 >G15:73.21 >F15:84.49 >E15:128.49 >D15:55.94 >C15:"lcredits= >B15:"rice,tota >A15:"customerp >AG13:"** >AF13:"credits** >AE13:"*******69 >E17:76.32 >D17:33.56 >C17:"redits = >B17:", total c >A17:"your cost >AG15:"lcredits> >AF15:"rice,tota >AE15:"customerp >AD15:@SUM(D15...AC15 >AB15:120.28 >AA15:165.97 >Z15:112.37 >Y15:98.44 >X15:33.95 >W15:98.57 >V15:79.41 >U15:110.82 >T15:48.99 >S15:D17...AC17 >AB17:70.55 >AA17:100.17 >Z17:69.37 >Y17:59.24 >X17:20.37 >W17:61.69 >V17:47.65 >U17:66.41 >T17:29.99 >S17:24 >R17:32.11 >Q17:12.95 >P17:20.68 >O17:42.64 >N17:22.51 >M17:44.67 >L17:0 >K17:1.34 >J17:12.59 >I17:11.99 >H17:42.19 >G17:46.15 >F17:50.:/-- >U18:/-- >T18:/-- >S18:/-- >R18:/-- >Q18:/-- >P18:/-- >O18:/-- >N18:/-- >M18:/-- >L18:/-- >K18:/-- >J18:/-- >I18:/-- >H18:/-- >G18:/-- >F18:/-- >E18:/-- >D18:/-- >C18:/-- >B18:/-- >A18:/-- >AG17:"redits > >AF17:", total c >AE17:"your cost >AD17:@SUM( - - - >C20:"s section >B20:" from thi >A20:" no entry >AG19:"r**** >AF19:"your orde >AE19:"********* >C19:"r**** >B19:"Your Orde >A19:" **** >AG18:/-- >AF18:/-- >AE18:/-- >AD18:/-- >AC18:/-- >AB18:/-- >AA18:/-- >Z18:/-- >Y18:/-- >X18:/-- >W18:/-- >V1821:/-- >U21:/-- >T21:/-- >S21:/-- >R21:/-- >Q21:/-- >P21:/-- >O21:/-- >N21:/-- >M21:/-- >L21:/-- >K21:/-- >J21:/-- >I21:/-- >H21:/-- >G21:/-- >F21:/-- >E21:/-- >D21:/-- >C21:/-- >B21:/-- >A21:/-- >AG20:"s section >AF20:" from thi >AE20:" no entry >AD20:" -4:117.52 >C24:" items = >B24:"mer price >A24:" custo >AG22:"**** >AF22:"statement >AE22:"********** >C22:"**** >B22:"Statement >A22:" **** >AG21:/-- >AF21:/-- >AE21:/-- >AD21:/-- >AC21:/-- >AB21:/-- >AA21:/-- >Z21:/-- >Y21:/-- >X21:/-- >W21:/-- >V.41 >Y24:712.89 >X24:529.8 >W24:453.06 >V24:436.13 >U24:502.58 >T24:321.65 >S24:201.78 >R24:233.78 >Q24:372.94 >P24:496.76 >O24:276.39 >N24:449.56 >M24:434.9 >L24:420.41 >K24:310.85 >J24:210.62 >I24:331.66 >H24:436.5 >G24:283.89 >F24:268.47 >E24:417.84 >D21.61 >K26:77.7 >J26:83.06 >I26:75.65 >H26:70.28 >G26:41.26 >F26:40.32 >E26:54.62 >D26:32.5 >C26:"ems = >B26:"scount it >A26:" no-di >Z25:4.2 >AG24:" items > >AF24:"mer price >AE24:" custo >AD24:@SUM(D24...AC24 >AB24:1005.81 >AA24:747.93 >Z24:587:"ems > >AF26:"scount it >AE26:" no-di >AD26:@SUM(D26...AC26 >AB26:47.1 >AA26:39.29 >Z26:101.46+Z25 >Y26:157.16 >X26:132.78 >W26:121.1 >V26:109.62 >U26:86.9 >T26:4.94 >S26:83.7 >R26:78.63 >Q26:65.08 >P26:52.46 >O26:59.45 >N26:62.47 >M26:64.87 >L26:727:/-- >AA27:/-- >Z27:/-- >Y27:/-- >X27:/-- >W27:/-- >V27:/-- >U27:/-- >T27:/-- >S27:/-- >R27:/-- >Q27:/-- >P27:/-- >O27:/-- >N27:/-- >M27:/-- >L27:/-- >K27:/-- >J27:/-- >I27:/-- >H27:/-- >G27:/-- >F27:/-- >E27:/-- >D27:/-- >C27:/-- >B27:/-- >A27:/-- >AG260:277.45 >G30:174.82 >F30:165.63 >E30:244.17 >D30:71.03 >C30:"r items = >B30:", custome >A30:"your cost >AG28:"r charges >AF28:"ry of you >AE28:"****summa >C28:"r charges >B28:"ry of you >A28:" Summa >AG27:/-- >AF27:/-- >AE27:/-- >AD27:/-- >AC27:/-- >ABL+AA9+1 >AA9:/FL+Z9+1 >Z9:/FL+Y9+1 >Y9:/FL+X9+1 >X9:/FL+W9+1 >W9:/FL+V9+1 >V9:/FL+U9+1 >U9:/FL+T9+1 >T9:/FL+S9+1 >S9:/FL+R9+1 >R9:/FL+Q9+1 >Q9:/FL+P9+1 >P9:/FL+O9+1 >O9:/FL+N9+1 >N9:/FL+M9+1 >M9:/FL+L9+1 >L9:/FL9 >K9:/FL+J9+1 >J9:/FL+I9+1 >I9:/FL+H9+1 >H9:/FL+G9+1 >G9:/FL+F9+1 >F9:/FL+E9+1 >E9:/FL+D9+1 >D9:/FL1 >C9:"Campaign: >C8:" Date: >B8:/FL.065 >A8:"Sales Tax >C6:"-678 >B6:"Acc 2345 >A6:"Dist 123 >B5:"Ca, Zip >A5:"City, >C4:"et >B4:"Your Stre >A4:"12345 >A3:"Ms Smith >B2:" 1981 >C1:"ecords >BB102:/-= >A102:/-= >H101:/FR/-. >G101:/-. >F101:"al)::::::> >E101:"r individu >D101:"(company O >C101:"n for : >B101:"onciliatio >A101:" Bank rec >C100:/-. >B100:"pared::::> >A100:" Date pre >F99:/-. >E99:/-. >D99:/FR/-. >C99:"Phone::::> >F98:/-. >E98:/--- >B106:/-- >A106:/-- >A105:" Mon/Yr >> >H104:/-= >G104:/-= >F104:/-= >E104:/-= >D104:/-= >C104:/-= >B104:/-= >A104:/-= >H103:" mon/yr >G103:" Mon/Yr >F103:" Mon/Yr >E103:"Mon/Yr >D103:" Mon/yr >H102:/-= >G102:/-= >F102:/-= >E102:/-= >D102:/-= >C102:/-= >G109:/-- >F109:/-- >E109:/-- >D109:/-- >C109:/-- >B109:/-- >A109:/-- >H108:/F$+C42 >G108:/F$+C41 >F108:/F$+C40 >E108:/F$+C39 >D108:/F$+C38 >B108:"nt >A108:" stateme >B107:"ce per >A107:"Bank balan >H106:/-- >G106:/-- >F106:/-- >E106:/-- >D106:/-- >C106:/ (Less out >H112:/-- >G112:/-- >F112:/-- >E112:/-- >D112:/-- >C112:/-- >B112:/-- >A112:/-- >H111:/F$+C47 >G111:/F$+C46 >F111:/F$+C45 >E111:/F$+C44 >D111:/F$+C43 >B111:" of month) >A111:" (to end >C110:"- add >B110:"n transit >A110:"Deposits i >H109:/-- >d o >A117:" =balanc >H115:/-= >G115:/-= >F115:/-= >E115:/-= >D115:/-= >C115:/-= >B115:/-= >A115:/-= >H114:/F$-C52 >G114:/F$-C51 >F114:/F$-C50 >E114:/F$-C49 >D114:/F$-C48 >C114:") >B114:"d of month >A114:" (to en >C113:"hecks) >B113:"standing c >A113:"/-= >A120:/-= >H118:/-= >G118:/-= >F118:/-= >E118:/-= >D118:/-= >C118:/-= >B118:/-= >A118:" ======= >H117:/F$+H108+H111+H114 >G117:/F$+G108+G111+G114 >F117:/F$+F108+F111+F114 >E117:/F$+E108+E111+E114 >D117:/F$+D108+D111+D114 >C117:"f month >B117:"e to en3:/-- >E123:/-- >D123:/-- >C123:/-- >B123:/-- >A123:/-- >H122:/F$+C57 >G122:/F$+C56 >F122:/F$+C55 >E122:/F$+C54 >D122:/F$+C53 >B122:" of month) >A122:"(beginning >B121:"ce >A121:"Book balan >H120:/-= >G120:/-= >F120:/-= >E120:/-= >D120:/-= >C120:/-= >B120:) >C126:"entire >B126:"ursements >A126:"(Less disb >H125:/-- >G125:/-- >F125:/-- >E125:/-- >D125:/-- >C125:/-- >B125:/-- >A125:/-- >H124:/F$+C62 >G124:/F$+C61 >F124:/F$+C60 >E124:/F$+C59 >D124:/F$+C58 >B124:" add >A124:"Deposits - >H123:/-- >G123:/-- >F12:/F$+E122+E124+E127 >D130:/F$+D122+D124+D127 >C130:"onth >B130:"e end of m >A130:" =balanc >H128:/-- >G128:/-- >F128:/-- >E128:/-- >D128:/-- >C128:/-- >B128:/-- >A128:/-- >H127:/F$-C67 >G127:/F$-C66 >F127:/F$-C65 >E127:/F$-C64 >D127:/F$-C63 >A127:" month:/F$+D117-D130 >B135:"ance >A135:"client bal >C134:" (-) in >B134:"r decrease >A134:"Increase o >H132:/-= >G132:/-= >F132:/-= >E132:/-= >D132:/-= >C132:/-= >B132:/-= >A132:/-= >H130:/F$+H122+H124+H127 >G130:/F$+G122+G124+G127 >F130:/F$+F122+F124+F127 >E130>H139:+C37 >G139:+C36 >F139:+C35 >E139:+C34 >D139:+C33 >B139:" # used::: >A139:"Last check >H137:/-= >G137:/-= >F137:/-= >E137:/-= >D137:/-= >C137:/-= >B137:/-= >A137:/-= >H135:/F$+H117-H130 >G135:/F$+G117-G130 >F135:/F$+F117-F130 >E135:/F$+E117-E130 >D1351:" Avon R /W1 /GOC /GRA /GC9 /X>A1:>C1:/TV /X>A1:>D1: /X>A1:>A1: . >D98:/-. >C98:/FR"City/St::> >F97:/-. >E97:/-. >D97:/-. >C97:/FR"Address::> >F96:/-. >E96:/-. >D96:/-. >C96:/FR"Name:::::> >D70:"ret) >C70:"ret)-H139( >B70:" hit /P1 ( >A70:"at A 95 & >C69:"lace crsor >B69:"tatement p >A69:"To print s >D68:/-* >C68:/-* >B68:/-* >A68:/-* >D67:/-* >C67:/F$/-. >B67:"s - 5th mo >A67:"Disbursmnt >D66:/-* >C66:/F$/-. >B66:"s - 4th mo >A66:"Disbursmnt >D65:/-* >C65:/F$/-. >B65:"s - 3rd mo >A65:"Disbursmnt >D64:/-* >C64:/F$/-. >B64:"s - 2nd mo >A64:"Disbursmnt >D63:/-* >C63:/F$/-63:+H9+H62 >G63:+G9+G62 >F63:+F9+F62 >D63:/F$+D9+D62 >B63:"L >A63:" CUM. TOTA >M62:@SUM(M11...M60) >L62:@SUM(L11...L60) >K62:@SUM(K11...K60) >J62:@SUM(J11...J60) >I62:@SUM(I11...I60) >H62:@SUM(H11...H60) >G62:@SUM(G11...G60) >F62:@SUM(F11...F60) >D62:/F$@S>D72:/F$ >D71:/F$ >D70:/F$ >D69:/F$ >D68:/F$ >D67:/F$ >D66:/F$ >D65:/F$ >M64:/-= >L64:/-= >K64:/-= >J64:/-= >I64:/-= >H64:/-= >G64:/-= >F64:/-= >E64:/-= >D64:/-= >C64:/-= >B64:/-= >A64:/-= >M63:+M9+M62 >L63:+L9+L62 >K63:+K9+K62 >J63:+J9+J62 >I63:+I9+I62 >Hr Rt >B7:".......A28 >A7:/FR"Upper Left >B6:" Location >A6:"Data Entry >C4:" 1982 >B4:"August 1, >A4:/FR"Date: >C3:"ato >B3:" Don Scell >A3:"Written by >C2:"ciliation >B2:"Bank Recon >A2:/FR"Title: /W1 /GOC /GRA /GC10 /X>A1:>A1: 3: : * >C25:/-* >B25:/-* >A25:/-* >B16:"......H139 >A16:/FR"Lower Rt >B15:".......A95 >A15:"Upper Left >B14:"Location >A14:"Worksheet >B12:"......H139 >A12:/FR"Lower Rt >B11:".......A95 >A11:"Upper Left >B10:"ation >A10:"Output Loc >B8:".......C68 >A8:/FR"Lowe>A30:"Preparer>> >D29:"ksheet.... >C29:"low on wor >B29:">>enter be >A29:"Stmnt Date >D28:"heet...... >C28:"w on worksh >B28:"enter belo >A28:"Client>>>> >D27:/-* >C27:/-* >B27:/-* >A27:/-* >D26:/-* >C26:"Below***** >B26:"ired Data >A26:"Enter Requ >D25:/-5:"-3rd mo... >A35:"Last ck no >D34:/-* >C34:/FI/-. >B34:"-2nd mo... >A34:"Last ck no >D33:/-* >C33:/FI/-. >B33:"-1st mo... >A33:"Last ck no >D32:/-* >C32:/-. >B32:/-> >A32:"Date chked >D31:/-. >C31:/-. >B31:/-. >A31:"Chked by>> >D30:/-. >C30:/-. >B30:/-. 0:"Statement >D39:/-* >C39:/F$/-. >B39:"bal-2nd mo >A39:"Statement >D38:/-* >C38:/F$/-. >B38:"bal-1st mo >A38:"Statement >D37:/-* >C37:/FI/-. >B37:"-5th mo... >A37:"Last ck no >D36:/-* >C36:/FI/-. >B36:"-4th mo... >A36:"Last ck no >D35:/-* >C35:/FI/-. >B3D44:/-* >C44:/F$/-. >B44:"ns-2nd mo >A44:"Dep in tra >D43:/-* >C43:/F$/-. >B43:"ns-1st mo >A43:"Dep in tra >D42:/-* >C42:/F$/-. >B42:"bal-5th mo >A42:"Statement >D41:/-* >C41:/F$/-. >B41:"bal-4th mo >A41:"Statement >D40:/-* >C40:/F$/-. >B40:"bal-3rd mo >A4/-. >B49:"hks-2nd mo >A49:"Outstand c >D48:/-* >C48:/F$/-. >B48:"hks-1st mo >A48:"Outstand c >D47:/-* >C47:/F$/-. >B47:"ns-5th mo >A47:"Dep in tra >D46:/-* >C46:/F$/-. >B46:"ns-4th mo >A46:"Dep in tra >D45:/-* >C45:/F$/-. >B45:"ns-3rd mo >A45:"Dep in tra >. >A54:"Bk bal beg >D53:/-* >C53:/F$/-. >B53:" 1st mo... >A53:"Bk bal beg >D52:/-* >C52:/F$/-. >B52:"hks-5th mo >A52:"Outstand c >D51:/-* >C51:/F$/-. >B51:"hks-4th mo >A51:"Outstand c >D50:/-* >C50:/F$/-. >B50:"hks-3rd mo >A50:"Outstand c >D49:/-* >C49:/F$>D58:/-* >C58:/F$/-. >B58:" 1st mo... >A58:"Deposits - >D57:/-* >C57:/F$/-. >B57:" 5th mo... >A57:"Bk bal beg >D56:/-* >C56:/F$/-. >B56:" 4th mo... >A56:"Bk bal beg >D55:/-* >C55:/F$/-. >B55:" 3rd mo... >A55:"Bk bal beg >D54:/-* >C54:/F$/-. >B54:" 2nd mo... >B63:"s - 1st mo >A63:"Disbursmnt >D62:/-* >C62:/F$/-. >B62:" 5th mo... >A62:"Deposits - >D61:/-* >C61:/F$/-. >B61:" 4th mo... >A61:"Deposits - >D60:/-* >C60:/F$/-. >B60:" 3rd mo... >A60:"Deposits - >D59:/-* >C59:/F$/-. >B59:" 2nd mo... >A59:"Deposits - UM(D11...D60) >B62:"L >A62:" PAGE TOTA >M61:" ------- >L61:" ------- >K61:" ------- >J61:" ------- >I61:" ------- >H61:" ------- >G61:" ------- >F61:" ------- >D61:/F$" ------ >M60:@IF(E60=M7,D60,0) >L60:@IF(E60=L7,D60,0) >K60:@IF( >D48:" $$$ >C48:" PAID TO >B48:"CHECK NO. >A48:"MONTH/DAY >M47:@IF(E47=M7,D47,0) >L47:@IF(E47=L7,D47,0) >K47:@IF(E47=K7,D47,0) >J47:@IF(E47=J7,D47,0) >I47:@IF(E47=I7,D47,0) >H47:@IF(E47=H7,D47,0) >G47:@IF(E47=G7,D47,0) >F47:@IF(E47=F7,D47,0) >E47:/FI"C $$$ >C49:" PAID TO >B49:"CHECK NO. >A49:"MONTH/DAY >M48:@IF(E48=M7,D48,0) >L48:@IF(E48=L7,D48,0) >K48:@IF(E48=K7,D48,0) >J48:@IF(E48=J7,D48,0) >I48:@IF(E48=I7,D48,0) >H48:@IF(E48=H7,D48,0) >G48:@IF(E48=G7,D48,0) >F48:@IF(E48=F7,D48,0) >E48:/FI"CHECK CODE0:" PAID TO >B50:"CHECK NO. >A50:"MONTH/DAY >M49:@IF(E49=M7,D49,0) >L49:@IF(E49=L7,D49,0) >K49:@IF(E49=K7,D49,0) >J49:@IF(E49=J7,D49,0) >I49:@IF(E49=I7,D49,0) >H49:@IF(E49=H7,D49,0) >G49:@IF(E49=G7,D49,0) >F49:@IF(E49=F7,D49,0) >E49:/FI"CHECK CODE >D49:" TO >B51:"CHECK NO. >A51:"MONTH/DAY >M50:@IF(E50=M7,D50,0) >L50:@IF(E50=L7,D50,0) >K50:@IF(E50=K7,D50,0) >J50:@IF(E50=J7,D50,0) >I50:@IF(E50=I7,D50,0) >H50:@IF(E50=H7,D50,0) >G50:@IF(E50=G7,D50,0) >F50:@IF(E50=F7,D50,0) >E50:/FI"CHECK CODE >D50:" $$$ >C5CHECK NO. >A52:"MONTH/DAY >M51:@IF(E51=M7,D51,0) >L51:@IF(E51=L7,D51,0) >K51:@IF(E51=K7,D51,0) >J51:@IF(E51=J7,D51,0) >I51:@IF(E51=I7,D51,0) >H51:@IF(E51=H7,D51,0) >G51:@IF(E51=G7,D51,0) >F51:@IF(E51=F7,D51,0) >E51:/FI"CHECK CODE >D51:" $$$ >C51:" PAID >A53:"MONTH/DAY >M52:@IF(E52=M7,D52,0) >L52:@IF(E52=L7,D52,0) >K52:@IF(E52=K7,D52,0) >J52:@IF(E52=J7,D52,0) >I52:@IF(E52=I7,D52,0) >H52:@IF(E52=H7,D52,0) >G52:@IF(E52=G7,D52,0) >F52:@IF(E52=F7,D52,0) >E52:/FI"CHECK CODE >D52:" $$$ >C52:" PAID TO >B52:"NTH/DAY >M53:@IF(E53=M7,D53,0) >L53:@IF(E53=L7,D53,0) >K53:@IF(E53=K7,D53,0) >J53:@IF(E53=J7,D53,0) >I53:@IF(E53=I7,D53,0) >H53:@IF(E53=H7,D53,0) >G53:@IF(E53=G7,D53,0) >F53:@IF(E53=F7,D53,0) >E53:/FI"CHECK CODE >D53:" $$$ >C53:" PAID TO >B53:"CHECK NO.M54:@IF(E54=M7,D54,0) >L54:@IF(E54=L7,D54,0) >K54:@IF(E54=K7,D54,0) >J54:@IF(E54=J7,D54,0) >I54:@IF(E54=I7,D54,0) >H54:@IF(E54=H7,D54,0) >G54:@IF(E54=G7,D54,0) >F54:@IF(E54=F7,D54,0) >E54:/FI"CHECK CODE >D54:" $$$ >C54:" PAID TO >B54:"CHECK NO. >A54:"MO55=M7,D55,0) >L55:@IF(E55=L7,D55,0) >K55:@IF(E55=K7,D55,0) >J55:@IF(E55=J7,D55,0) >I55:@IF(E55=I7,D55,0) >H55:@IF(E55=H7,D55,0) >G55:@IF(E55=G7,D55,0) >F55:@IF(E55=F7,D55,0) >E55:/FI"CHECK CODE >D55:" $$$ >C55:" PAID TO >B55:"CHECK NO. >A55:"MONTH/DAY >,0) >L56:@IF(E56=L7,D56,0) >K56:@IF(E56=K7,D56,0) >J56:@IF(E56=J7,D56,0) >I56:@IF(E56=I7,D56,0) >H56:@IF(E56=H7,D56,0) >G56:@IF(E56=G7,D56,0) >F56:@IF(E56=F7,D56,0) >E56:/FI"CHECK CODE >D56:" $$$ >C56:" PAID TO >B56:"CHECK NO. >A56:"MONTH/DAY >M55:@IF(E@IF(E57=L7,D57,0) >K57:@IF(E57=K7,D57,0) >J57:@IF(E57=J7,D57,0) >I57:@IF(E57=I7,D57,0) >H57:@IF(E57=H7,D57,0) >G57:@IF(E57=G7,D57,0) >F57:@IF(E57=F7,D57,0) >E57:/FI"CHECK CODE >D57:" $$$ >C57:" PAID TO >B57:"CHECK NO. >A57:"MONTH/DAY >M56:@IF(E56=M7,D567,D58,0) >K58:@IF(E58=K7,D58,0) >J58:@IF(E58=J7,D58,0) >I58:@IF(E58=I7,D58,0) >H58:@IF(E58=H7,D58,0) >G58:@IF(E58=G7,D58,0) >F58:@IF(E58=F7,D58,0) >E58:/FI"CHECK CODE >D58:" $$$ >C58:" PAID TO >B58:"CHECK NO. >A58:"MONTH/DAY >M57:@IF(E57=M7,D57,0) >L57:>K59:@IF(E59=K7,D59,0) >J59:@IF(E59=J7,D59,0) >I59:@IF(E59=I7,D59,0) >H59:@IF(E59=H7,D59,0) >G59:@IF(E59=G7,D59,0) >F59:@IF(E59=F7,D59,0) >E59:/FI"CHECK CODE >D59:" $$$ >C59:" PAID TO >B59:"CHECK NO. >A59:"MONTH/DAY >M58:@IF(E58=M7,D58,0) >L58:@IF(E58=LE60=K7,D60,0) >J60:@IF(E60=J7,D60,0) >I60:@IF(E60=I7,D60,0) >H60:@IF(E60=H7,D60,0) >G60:@IF(E60=G7,D60,0) >F60:@IF(E60=F7,D60,0) >E60:/FI"CHECK CODE >D60:" $$$ >C60:" PAID TO >B60:"CHECK NO. >A60:"MONTH/DAY >M59:@IF(E59=M7,D59,0) >L59:@IF(E59=L7,D59,0) HECK CODE >D47:" $$$ >C47:" PAID TO >B47:"CHECK NO. >A47:"MONTH/DAY >M46:@IF(E46=M7,D46,0) >L46:@IF(E46=L7,D46,0) >K46:@IF(E46=K7,D46,0) >J46:@IF(E46=J7,D46,0) >I46:@IF(E46=I7,D46,0) >H46:@IF(E46=H7,D46,0) >G46:@IF(E46=G7,D46,0) >F46:@IF(E46=F7,D46,0) >E46:/FI"CHECK CODE >D46:" $$$ >C46:" PAID TO >B46:"CHECK NO. >A46:"MONTH/DAY >M45:@IF(E45=M7,D45,0) >L45:@IF(E45=L7,D45,0) >K45:@IF(E45=K7,D45,0) >J45:@IF(E45=J7,D45,0) >I45:@IF(E45=I7,D45,0) >H45:@IF(E45=H7,D45,0) >G45:@IF(E45=G7,D45,0) >F45:@IF(E45=F7K7,D32,0) >J32:@IF(E32=J7,D32,0) >I32:@IF(E32=I7,D32,0) >H32:@IF(E32=H7,D32,0) >G32:@IF(E32=G7,D32,0) >F32:@IF(E32=F7,D32,0) >E32:/FI"CHECK CODE >D32:" $$$ >C32:" PAID TO >B32:"CHECK NO. >A32:"MONTH/DAY >M31:@IF(E31=M7,D31,0) >L31:@IF(E31=L7,D31,0) >K31 >J33:@IF(E33=J7,D33,0) >I33:@IF(E33=I7,D33,0) >H33:@IF(E33=H7,D33,0) >G33:@IF(E33=G7,D33,0) >F33:@IF(E33=F7,D33,0) >E33:/FI"CHECK CODE >D33:" $$$ >C33:" PAID TO >B33:"CHECK NO. >A33:"MONTH/DAY >M32:@IF(E32=M7,D32,0) >L32:@IF(E32=L7,D32,0) >K32:@IF(E32=(E34=J7,D34,0) >I34:@IF(E34=I7,D34,0) >H34:@IF(E34=H7,D34,0) >G34:@IF(E34=G7,D34,0) >F34:@IF(E34=F7,D34,0) >E34:/FI"CHECK CODE >D34:" $$$ >C34:" PAID TO >B34:"CHECK NO. >A34:"MONTH/DAY >M33:@IF(E33=M7,D33,0) >L33:@IF(E33=L7,D33,0) >K33:@IF(E33=K7,D33,0)35,0) >I35:@IF(E35=I7,D35,0) >H35:@IF(E35=H7,D35,0) >G35:@IF(E35=G7,D35,0) >F35:@IF(E35=F7,D35,0) >E35:/FI"CHECK CODE >D35:" $$$ >C35:" PAID TO >B35:"CHECK NO. >A35:"MONTH/DAY >M34:@IF(E34=M7,D34,0) >L34:@IF(E34=L7,D34,0) >K34:@IF(E34=K7,D34,0) >J34:@IF6:@IF(E36=I7,D36,0) >H36:@IF(E36=H7,D36,0) >G36:@IF(E36=G7,D36,0) >F36:@IF(E36=F7,D36,0) >E36:/FI"CHECK CODE >D36:" $$$ >C36:" PAID TO >B36:"CHECK NO. >A36:"MONTH/DAY >M35:@IF(E35=M7,D35,0) >L35:@IF(E35=L7,D35,0) >K35:@IF(E35=K7,D35,0) >J35:@IF(E35=J7,D=I7,D37,0) >H37:@IF(E37=H7,D37,0) >G37:@IF(E37=G7,D37,0) >F37:@IF(E37=F7,D37,0) >E37:/FI"CHECK CODE >D37:" $$$ >C37:" PAID TO >B37:"CHECK NO. >A37:"MONTH/DAY >M36:@IF(E36=M7,D36,0) >L36:@IF(E36=L7,D36,0) >K36:@IF(E36=K7,D36,0) >J36:@IF(E36=J7,D36,0) >I3) >H38:@IF(E38=H7,D38,0) >G38:@IF(E38=G7,D38,0) >F38:@IF(E38=F7,D38,0) >E38:/FI"CHECK CODE >D38:" $$$ >C38:" PAID TO >B38:"CHECK NO. >A38:"MONTH/DAY >M37:@IF(E37=M7,D37,0) >L37:@IF(E37=L7,D37,0) >K37:@IF(E37=K7,D37,0) >J37:@IF(E37=J7,D37,0) >I37:@IF(E37F(E39=H7,D39,0) >G39:@IF(E39=G7,D39,0) >F39:@IF(E39=F7,D39,0) >E39:/FI"CHECK CODE >D39:" $$$ >C39:" PAID TO >B39:"CHECK NO. >A39:"MONTH/DAY >M38:@IF(E38=M7,D38,0) >L38:@IF(E38=L7,D38,0) >K38:@IF(E38=K7,D38,0) >J38:@IF(E38=J7,D38,0) >I38:@IF(E38=I7,D38,0D40,0) >G40:@IF(E40=G7,D40,0) >F40:@IF(E40=F7,D40,0) >E40:/FI"CHECK CODE >D40:" $$$ >C40:" PAID TO >B40:"CHECK NO. >A40:"MONTH/DAY >M39:@IF(E39=M7,D39,0) >L39:@IF(E39=L7,D39,0) >K39:@IF(E39=K7,D39,0) >J39:@IF(E39=J7,D39,0) >I39:@IF(E39=I7,D39,0) >H39:@I41:@IF(E41=G7,D41,0) >F41:@IF(E41=F7,D41,0) >E41:/FI"CHECK CODE >D41:" $$$ >C41:" PAID TO >B41:"CHECK NO. >A41:"MONTH/DAY >M40:@IF(E40=M7,D40,0) >L40:@IF(E40=L7,D40,0) >K40:@IF(E40=K7,D40,0) >J40:@IF(E40=J7,D40,0) >I40:@IF(E40=I7,D40,0) >H40:@IF(E40=H7,2=G7,D42,0) >F42:@IF(E42=F7,D42,0) >E42:/FI"CHECK CODE >D42:" $$$ >C42:" PAID TO >B42:"CHECK NO. >A42:"MONTH/DAY >M41:@IF(E41=M7,D41,0) >L41:@IF(E41=L7,D41,0) >K41:@IF(E41=K7,D41,0) >J41:@IF(E41=J7,D41,0) >I41:@IF(E41=I7,D41,0) >H41:@IF(E41=H7,D41,0) >G0) >F43:@IF(E43=F7,D43,0) >E43:/FI"CHECK CODE >D43:" $$$ >C43:" PAID TO >B43:"CHECK NO. >A43:"MONTH/DAY >M42:@IF(E42=M7,D42,0) >L42:@IF(E42=L7,D42,0) >K42:@IF(E42=K7,D42,0) >J42:@IF(E42=J7,D42,0) >I42:@IF(E42=I7,D42,0) >H42:@IF(E42=H7,D42,0) >G42:@IF(E4IF(E44=F7,D44,0) >E44:/FI"CHECK CODE >D44:" $$$ >C44:" PAID TO >B44:"CHECK NO. >A44:"MONTH/DAY >M43:@IF(E43=M7,D43,0) >L43:@IF(E43=L7,D43,0) >K43:@IF(E43=K7,D43,0) >J43:@IF(E43=J7,D43,0) >I43:@IF(E43=I7,D43,0) >H43:@IF(E43=H7,D43,0) >G43:@IF(E43=G7,D43,,D45,0) >E45:/FI"CHECK CODE >D45:" $$$ >C45:" PAID TO >B45:"CHECK NO. >A45:"MONTH/DAY >M44:@IF(E44=M7,D44,0) >L44:@IF(E44=L7,D44,0) >K44:@IF(E44=K7,D44,0) >J44:@IF(E44=J7,D44,0) >I44:@IF(E44=I7,D44,0) >H44:@IF(E44=H7,D44,0) >G44:@IF(E44=G7,D44,0) >F44:@:@IF(E31=K7,D31,0) >J31:@IF(E31=J7,D31,0) >I31:@IF(E31=I7,D31,0) >H31:@IF(E31=H7,D31,0) >G31:@IF(E31=G7,D31,0) >F31:@IF(E31=F7,D31,0) >E31:/FI"CHECK CODE >D31:" $$$ >C31:" PAID TO >B31:"CHECK NO. >A31:"MONTH/DAY >M30:@IF(E30=M7,D30,0) >L30:@IF(E30=L7,D30,0) >K30:@IF(E30=K7,D30,0) >J30:@IF(E30=J7,D30,0) >I30:@IF(E30=I7,D30,0) >H30:@IF(E30=H7,D30,0) >G30:@IF(E30=G7,D30,0) >F30:@IF(E30=F7,D30,0) >E30:/FI"CHECK CODE >D30:" $$$ >C30:" PAID TO >B30:"CHECK NO. >A30:"MONTH/DAY >M29:@IF(E29=M7,D29,0) >L29:@IF(,0) >E17:/FI"CHECK CODE >D17:" $$$ >C17:" PAID TO >B17:"CHECK NO. >A17:"MONTH/DAY >M16:@IF(E16=M7,D16,0) >L16:@IF(E16=L7,D16,0) >K16:@IF(E16=K7,D16,0) >J16:@IF(E16=J7,D16,0) >I16:@IF(E16=I7,D16,0) >H16:@IF(E16=H7,D16,0) >G16:@IF(E16=G7,D16,0) >F16:@IF(E/FI"CHECK CODE >D18:" $$$ >C18:" PAID TO >B18:"CHECK NO. >A18:"MONTH/DAY >M17:@IF(E17=M7,D17,0) >L17:@IF(E17=L7,D17,0) >K17:@IF(E17=K7,D17,0) >J17:@IF(E17=J7,D17,0) >I17:@IF(E17=I7,D17,0) >H17:@IF(E17=H7,D17,0) >G17:@IF(E17=G7,D17,0) >F17:@IF(E17=F7,D17 CODE >D19:" $$$ >C19:" PAID TO >B19:"CHECK NO. >A19:"MONTH/DAY >M18:@IF(E18=M7,D18,0) >L18:@IF(E18=L7,D18,0) >K18:@IF(E18=K7,D18,0) >J18:@IF(E18=J7,D18,0) >I18:@IF(E18=I7,D18,0) >H18:@IF(E18=H7,D18,0) >G18:@IF(E18=G7,D18,0) >F18:@IF(E18=F7,D18,0) >E18:0:" $$$ >C20:" PAID TO >B20:"CHECK NO. >A20:"MONTH/DAY >M19:@IF(E19=M7,D19,0) >L19:@IF(E19=L7,D19,0) >K19:@IF(E19=K7,D19,0) >J19:@IF(E19=J7,D19,0) >I19:@IF(E19=I7,D19,0) >H19:@IF(E19=H7,D19,0) >G19:@IF(E19=G7,D19,0) >F19:@IF(E19=F7,D19,0) >E19:/FI"CHECK$ >C21:" PAID TO >B21:"CHECK NO. >A21:"MONTH/DAY >M20:@IF(E20=M7,D20,0) >L20:@IF(E20=L7,D20,0) >K20:@IF(E20=K7,D20,0) >J20:@IF(E20=J7,D20,0) >I20:@IF(E20=I7,D20,0) >H20:@IF(E20=H7,D20,0) >G20:@IF(E20=G7,D20,0) >F20:@IF(E20=F7,D20,0) >E20:/FI"CHECK CODE >D2PAID TO >B22:"CHECK NO. >A22:"MONTH/DAY >M21:@IF(E21=M7,D21,0) >L21:@IF(E21=L7,D21,0) >K21:@IF(E21=K7,D21,0) >J21:@IF(E21=J7,D21,0) >I21:@IF(E21=I7,D21,0) >H21:@IF(E21=H7,D21,0) >G21:@IF(E21=G7,D21,0) >F21:@IF(E21=F7,D21,0) >E21:/FI"CHECK CODE >D21:" $$B23:"CHECK NO. >A23:"MONTH/DAY >M22:@IF(E22=M7,D22,0) >L22:@IF(E22=L7,D22,0) >K22:@IF(E22=K7,D22,0) >J22:@IF(E22=J7,D22,0) >I22:@IF(E22=I7,D22,0) >H22:@IF(E22=H7,D22,0) >G22:@IF(E22=G7,D22,0) >F22:@IF(E22=F7,D22,0) >E22:/FI"CHECK CODE >D22:" $$$ >C22:" K NO. >A24:"MONTH/DAY >M23:@IF(E23=M7,D23,0) >L23:@IF(E23=L7,D23,0) >K23:@IF(E23=K7,D23,0) >J23:@IF(E23=J7,D23,0) >I23:@IF(E23=I7,D23,0) >H23:@IF(E23=H7,D23,0) >G23:@IF(E23=G7,D23,0) >F23:@IF(E23=F7,D23,0) >E23:/FI"CHECK CODE >D23:" $$$ >C23:" PAID TO >5:"MONTH/DAY >M24:@IF(E24=M7,D24,0) >L24:@IF(E24=L7,D24,0) >K24:@IF(E24=K7,D24,0) >J24:@IF(E24=J7,D24,0) >I24:@IF(E24=I7,D24,0) >H24:@IF(E24=H7,D24,0) >G24:@IF(E24=G7,D24,0) >F24:@IF(E24=F7,D24,0) >E24:/FI"CHECK CODE >D24:" $$$ >C24:" PAID TO >B24:"CHECDAY >M25:@IF(E25=M7,D25,0) >L25:@IF(E25=L7,D25,0) >K25:@IF(E25=K7,D25,0) >J25:@IF(E25=J7,D25,0) >I25:@IF(E25=I7,D25,0) >H25:@IF(E25=H7,D25,0) >G25:@IF(E25=G7,D25,0) >F25:@IF(E25=F7,D25,0) >E25:/FI"CHECK CODE >D25:" $$$ >C25:" PAID TO >B25:"CHECK NO. >A2@IF(E26=M7,D26,0) >L26:@IF(E26=L7,D26,0) >K26:@IF(E26=K7,D26,0) >J26:@IF(E26=J7,D26,0) >I26:@IF(E26=I7,D26,0) >H26:@IF(E26=H7,D26,0) >G26:@IF(E26=G7,D26,0) >F26:@IF(E26=F7,D26,0) >E26:/FI"CHECK CODE >D26:" $$$ >C26:" PAID TO >B26:"CHECK NO. >A26:"MONTH/7,D27,0) >L27:@IF(E27=L7,D27,0) >K27:@IF(E27=K7,D27,0) >J27:@IF(E27=J7,D27,0) >I27:@IF(E27=I7,D27,0) >H27:@IF(E27=H7,D27,0) >G27:@IF(E27=G7,D27,0) >F27:@IF(E27=F7,D27,0) >E27:/FI"CHECK CODE >D27:" $$$ >C27:" PAID TO >B27:"CHECK NO. >A27:"MONTH/DAY >M26:>L28:@IF(E28=L7,D28,0) >K28:@IF(E28=K7,D28,0) >J28:@IF(E28=J7,D28,0) >I28:@IF(E28=I7,D28,0) >H28:@IF(E28=H7,D28,0) >G28:@IF(E28=G7,D28,0) >F28:@IF(E28=F7,D28,0) >E28:/FI"CHECK CODE >D28:" $$$ >C28:" PAID TO >B28:"CHECK NO. >A28:"MONTH/DAY >M27:@IF(E27=ME29=L7,D29,0) >K29:@IF(E29=K7,D29,0) >J29:@IF(E29=J7,D29,0) >I29:@IF(E29=I7,D29,0) >H29:@IF(E29=H7,D29,0) >G29:@IF(E29=G7,D29,0) >F29:@IF(E29=F7,D29,0) >E29:/FI"CHECK CODE >D29:" $$$ >C29:" PAID TO >B29:"CHECK NO. >A29:"MONTH/DAY >M28:@IF(E28=M7,D28,0) 16=F7,D16,0) >E16:/FI"CHECK CODE >D16:" $$$ >C16:" PAID TO >B16:"CHECK NO. >A16:"MONTH/DAY >M15:@IF(E15=M7,D15,0) >L15:@IF(E15=L7,D15,0) >K15:@IF(E15=K7,D15,0) >J15:@IF(E15=J7,D15,0) >I15:@IF(E15=I7,D15,0) >H15:@IF(E15=H7,D15,0) >G15:@IF(E15=G7,D15,0) >F15:@IF(E15=F7,D15,0) >E15:/FI"CHECK CODE >D15:" $$$ >C15:" PAID TO >B15:"CHECK NO. >A15:"MONTH/DAY >M14:@IF(E14=M7,D14,0) >L14:@IF(E14=L7,D14,0) >K14:@IF(E14=K7,D14,0) >J14:@IF(E14=J7,D14,0) >I14:@IF(E14=I7,D14,0) >H14:@IF(E14=H7,D14,0) >G14:@IF(E14=G7 10 TEXT:HOME 20 REM 30 REM ***VISICALC /// FILE PRINTER*** 40 REM 50 I=1 60 DIM B$(1000) 70 VPOS=10 80 IMAGE 79C 90 PRINT USING 80;"* * * VisiCalc File Printer * * *" 100 PREFIX$=".D1" 110 CAT 120 PRINT:PRINT"Input Fil/GC35 /X>A1:>A1: Vers >B6:"late Disk No. 1 >A6:/FR"VisiCalc Temp >B5:"co Apple Core >A5:/FR"San Francis >B4:"/ Version of >A4:/FR"VisiCalc // >B2:"pple ///rs >A2:/FR"Original A >A1:" Print to B165 /W1 /GOC /GRA VisiCalc >A12:"listed below and in the "catalog" t >B11:"iness users. The templates are >A11:"should prove useful to home and bus >B10:"VisiCalc templates and demos which >A10:"This disk contains a collection of >B7:"ion 1.1 >A7:" S >A3:" 2 = MED >J2:"E R >I2:" M A S T >H2:"C H E C K >B2:" 5 = CHAR >A2:" 1 = BUS >B1:"DE LIST >A1:" CHECK CO /W1 /GOC /GRM /XH8 /GF$ /GC10 /X>A1:>A1:;/GF$ /GC10 /X>A8:>A8:; CODE >G6:/FL" CODE >F6:/FL" CODE >M5:" MISC. >L5:" AUTO >K5:" INSURANCE >J5:" CHARITY >I5:" INTEREST >H5:" TAXES >G5:" MEDICAL >F5:/FL" BUSINESS >B5:" 8 = MISC >A5:" 4 = INT >D4:"CALCULATE >B4:" 7 = AUTO >A4:" 3 = TAX >D3:"TYPE ! TO >B3:" 6 = IN7:/FI1+L7 >L7:/FI1+K7 >K7:/FI1+J7 >J7:/FI1+I7 >I7:/FI1+H7 >H7:/FI1+G7 >G7:/FI1+F7 >F7:/FI1 >E7:"CHECK CODE >D7:" AMOUNT >C7:" PAID TO >B7:"CHECK NO. >A7:"MONTH/DAY >M6:/FL" CODE >L6:/FL" CODE >K6:/FL" CODE >J6:/FL" CODE >I6:/FL" CODE >H6:/FL" 0:/-= >M9:" $$$$ >L9:" $$$$ >K9:" $$$$ >J9:" $$$$ >I9:" $$$$ >H9:" $$$$ >G9:" $$$$ >F9:" $$$$ >D9:" $$$$ >B9:"RWARD >A9:"BALANCE FO >M8:/-= >L8:/-= >K8:/-= >J8:/-= >I8:/-= >H8:/-= >G8:/-= >F8:/-= >E8:/-= >D8:/-= >C8:/-= >B8:/-= >A8:/-= >M1=H7,D11,0) >G11:@IF(E11=G7,D11,0) >F11:@IF(E11=F7,D11,0) >E11:/FI"CHECK CODE >D11:/F$" $$$ >C11:" PAID TO >B11:/FI"CHECK NO. >A11:"MONTH/DAY >M10:/-= >L10:/-= >K10:/-= >J10:/-= >I10:/-= >H10:/-= >G10:/-= >F10:/-= >E10:/-= >D10:/-= >C10:/-= >B10:/-= >A10) >G12:@IF(E12=G7,D12,0) >F12:@IF(E12=F7,D12,0) >E12:/FI"CHECK CODE >D12:" $$$ >C12:" PAID TO >B12:"CHECK NO. >A12:"MONTH/DAY >M11:@IF(E11=M7,D11,0) >L11:@IF(E11=L7,D11,0) >K11:@IF(E11=K7,D11,0) >J11:@IF(E11=J7,D11,0) >I11:@IF(E11=I7,D11,0) >H11:@IF(E1IF(E13=G7,D13,0) >F13:@IF(E13=F7,D13,0) >E13:/FI"CHECK CODE >D13:" $$$ >C13:" PAID TO >B13:"CHECK NO. >A13:"MONTH/DAY >M12:@IF(E12=M7,D12,0) >L12:@IF(E12=L7,D12,0) >K12:@IF(E12=K7,D12,0) >J12:@IF(E12=J7,D12,0) >I12:@IF(E12=I7,D12,0) >H12:@IF(E12=H7,D12,,D14,0) >F14:@IF(E14=F7,D14,0) >E14:/FI"CHECK CODE >D14:" $$$ >C14:" PAID TO >B14:"CHECK NO. >A14:"MONTH/DAY >M13:@IF(E13=M7,D13,0) >L13:@IF(E13=L7,D13,0) >K13:@IF(E13=K7,D13,0) >J13:@IF(E13=J7,D13,0) >I13:@IF(E13=I7,D13,0) >H13:@IF(E13=H7,D13,0) >G13:@e Name ",N$ 130 INPUT N$ 140 HOME:PRINT:VPOS=10 150 PRINT USING 80;"Reading File":PRINT:PRINT 160 PRINT USING 80;N$ 170 OPEN#1 AS INPUT,N$ 180 ON EOF#1:GOTO 240 190 INPUT#1;A$ 200 I=I+1 210 B$(I)=B$(I)+A$ 220 GOTO 190 230 R ending at cell C67 to set >A146:"data entry location starting at cel >B145:"h the financial records. It uses a >A145:"statement for a business agrees wit >B144:"e computes whether or not a bank >A144:"Bank Reconciliation -- This templat >B142:"nd press !A151:"Check Master -- This template is a >A149:"each month by the user. >B148:"er of months and may be printed >A148:"ends at cell H139. It spans a numbe >B147:"on report starts at cell A95 and >A147:"up the statement. The reconciliatio >B146:"l C33 andinue >A154:"transfer your cum. total to the bal >B153:"te. File it to another disk, >A153:"filled the sheet press ! to calcula >B152:"pper left corner and when you have >A152:"information and the code from the u >B151:"check ledger. Type in your check >r of this diskette >B160:"N O T E >A160:" S P E C I A L >B156:"ness needs. >A156:"be changed to suit you home or busi >B155:"ck codes and column headings may >A155:"on for your accounting period. Che >B154:"ance forward section and cont>A165:"California 94101 >B164:"//ers, P.O. Box 813, San Francisco, >A164:"please contact the Original Apple / >B163:"future VisiCalc template disks, >A163:"favorite template for inclusion in >B162:"would like to contribute his or her >A162:"If the purchase PRINT USING 80;"Completed" 470 END 1000 PRINT USING 80;N$:PRINT 1010 PRINT USING 80;"File" 1020 FOR R=I-2 TO 0 STEP-1 1030 PRINT b$(r) 1040 L=L+1:IF L=50 THEN L=0:FOR P=1 TO 16:PRINT:NEXT P 1050 NEXT R 1060 RETURN 1070 END0;N$:PRINT 380 PRINT USING 80;"File" 390 OPEN#2 AS OUTPUT,".PRINTER" 400 FOR R=I-2 TO 0 STEP-1 410 PRINT#2;B$(R) 420 L=L+1:IF L=50 THEN L=0:FOR P=1 TO 16:PRINT#2:NEXT P 430 NEXT R 440 CLOSE#2 450 HOME:VPOS=10:GOSUB 1000 460 PRINT:PRINT 320 PRINT USING 80;"Do you want a HARD COPY ...Printer On?" 330 HPOS=37:INPUT"(Y/N)?";O$ 340 IF O$="Y" OR O$="y" THEN GOTO 360 350 IF O$="N" OR O$="n" THEN 450 360 HOME:VPOS=10:PRINT USING 80;"Printing":PRINT 370 PRINT USING 8EM 240 REM *** END OF FILE *** 250 REM 260 CLOSE#1 270 HOME 280 VPOS=10:PRINT USING 80;N$:PRINT:PRINT 290 PRINT USING 80;"File has been read. There are...":PRINT:PRINT 300 HPOS=39:PRINT I:PRINT 310 PRINT USING 80;"lines to print.":. >A142:"Also place the cursor on cell D64 a >B141:" cursor on cell D60 and press !. >A141:"To clear the error flags, place the >B140:"h a series of Avon sales campaigns. >A140:"and business expense associated wit >B139:"is a complex analysis of the profit >A139:"Avon Records Demo -- This template >A137:"shopper presented above. >B136:"mplate demos the comparative >A136:"Comparative Shopper Demo -- This te >A133:"command is used in this template. >B132:"h lowest store price. The @min >A132:"or he may juslisted for 1980 >B80:"es annual amounts which are entered >A80:"Income Tax Demo -- This template us >B78:"key to recalculate. >A78:"cursor at cell D15 and press the ! >B77:"flags in the template, place the >A77:"into cell D13. To clear the error f >B76:"m of the screen is used to >B83:"ess the ! key. The window used on >A83:"place the cursor on cell C46 and pr >B82:" of the error flags on the demo, >A82:"burden for each year. To clear all >B81:"and 1981 to compute the total tax >A81:"into each category cell C39 with a lookup table runnin >B86:"in row 40 by comparing the value in >A86:"The federal tax burden is computed >B85:"eared by pressing the / W 1 keys. >A85:"burden for each year. It may be cle >B84:" highlight the tax refund and >A84:"the bottomt term gains or losses >B91:"ows the user to compute the long >A91:"Stock Analysis -- This template all >A89:"1981 tax level. >B88:"72 to C78 is used to compute the >A88:"Another lookup table running from C >B87:"g from B64 to B70 for the 1980 tax. >A87:"putation date and date of purcha >B94:"ld be entered as stock is bought. >A94:"purchase price, and commission shou >B93:"r. Number of shares, stock name, >A93:"must be entered from the daily pape >B92:" of his portfolio. Current price >A92:"term and shorsquare of >A99:"Spearman Rank Analysis -- This temp >B97:"I to operate properly. >A97:"allow the boolean statement in row >B96:"er - i.e. 8111) in the same cell to >A96:"(year number followed by month numb >B95:"se are entered as four digit entry >A95:"Comor at cell >A102:"the ranks listed. To clear the erro >B101:"relation of the differences between >A101:"the user. It then computes the corr >B100:"cores. Rank to be precomputed by >A100:"the difference between two ranked s >B99:"late first computes the ce the cursor at cell C11 >B106:" by the user. To clear the error >A106:"coefficient from X and Y data input >B105:"mputes the Pearson Product moment >A105:"Pearson Product -- This template co >A103:"B8 and press the ! key. >B102:"or flags, place the curse categories to >A111:"classifications. The user may wish >B110:"variety of income and expense >A110:"income and expense data for a wide >B109:"lows the insertion of monthly >A109:"Budget Template -- This template al >B107:" and press !. >A107:"flags, plaown in >A114:"shown in row O while percent of total inc >B113:"uted in row T. Annual totals are >A113:"the sheet. Running totals are computed >B112:"es are provided at the bottom of >A112:"reflect his needs. Monthly summarie >B111:" to replace or delet119:"business. It may also be used to de >B118:" year's cash flow for a small >A118:"which may be used to plan the first >B117:"plate is a straightforward template >A117:"Small Business Start Up -- This temp >A115:"row R. >B114:"al income or expense is sh8 and replicating this formula from c >B121:"ormula such as "+D7 * .45" into >A121:"or may be computed by inserting a formu >B120:"ay either be input for each month >A120:"courses of action. Cost of sales ma >B119:"evelop budgets or examine alternate >Aper -- This templat >A127:"above. >B126:"iness start up template presented >A126:"Small Bus Demo -- Demo of small bus >B124:"plate on diskette. >A124:"Demo Net Worth -- Demo of first tem >A123:"desired. >B122:"a from cell E8 to cell O8 if so >A122:"cell Dt select the store wit >B131:"to obtain the absolute lowest price >A131:"have to travel from store to store >B130:" by three different stores. He may >A130:"minimum price for each item offered >B129:"e allows the user to select the >A129:"Comparative Shopputed by inputting the new X value >A76:"Y value for a new X value may be co >B75:" been input into rows A and B, the >A75:"Once a series of X and Y values has >B74:"ing exponential smoothing methods. >A74:"values to provide a curve fit by us >B73:"ate is used to smooth a series of >A73:"Exponential Regression -- The templ >A68:"template. >B67:"hing method is used in this >A67:"the sheet. The least squares smooth >B66:"ate formulas as required to expand >A66:"you desire, insert rows, and replic >B65:"tute ntaining the templates. >A15:"from your disk drive and insert the >B14:"system, remove the VisiCalc disk >A14:"VisiCalc has been loaded into your >B13:"emplates on the diskette. Once >A13:"must be loaded prior to using the t >B12:"emplate on the diskette.:"key or you may examine the list of >A18:"templates by using the right arrow >B17:"en. You may scan the titles of the >A17:"editing line at the top of the scre >B16:"he name of each template in the >A16:"Then press / S L keys to bring up t >B15:" disk cos >B21:"f the screen. Scroll down through >A21:"when "catalog" appears at the top o >B20:"plate by pressing the "return" key >A20:"is called "catalog." Load this temp >B19:"mplate on the disk. This template >A19:"templates presented on the first te >B18) to print the >B24:" top of the catalog template and >A24:"direction. Place the cursor at the >B23:"eft arrow keys to select cursor >A23:"cursor movement and the right and l >B22:" to select horizontal or vertical >A22:"the catalog by using the arrow key>A30:" ----- --- >B29:" Memory Required >A29:" Title Use >B28:"------------------- >A28:/FR"-------------------- >B27:"Template Disk No. 1 >A27:/FR"Catalog of VisiCalc >B25:" catalog. >A25:"press /PP B50 (returnential Regression Statistics >B33:" 8k >A33:"Linear Regression Statistics >B32:"Mgt 10k >A32:"Net Worth Worksheet Household >B31:" 4k >A31:"Catalog Utility >B30:" --------------- duct Statistics >B37:" 3k >A37:"Spearman Rank Statistics >B36:" 6k >A36:"Stock Analysis Financial >B35:"Mgt 5k >A35:"Income Tax Demo Household >B34:" 7k >A34:"Exponl Bus Start Demo Demo >B41:" 10k >A41:"Net Worth Demo Demo >B40:" 4k >A40:"Small Business Start Up Business >B39:"Mgt 10k >A39:"Budget Template Household >B38:" 4k >A38:"Pearson Pro6:"Bank Reconciliation Business >B45:" 16k >A45:"Avon Records Demo Demo >B44:" 6k >A44:"Comp Shopper Demo Demo >B43:"Mgt 5k >A43:"Comparative Shopper Household >B42:" 10k >A42:"Smalatalog -- This template lists and >B50:"e follows below: >A50:"A brief explanation of each templat >B48:" 11k >A48:"Template Documentation Utility >B47:"iness 20k >A47:"Check Master Home & Bus >B46:" 8k >A4tement by bringing the subtotals >B56:"f worksheets to a net worth >A56:"columns. It builds from a series of >B55:"e works down the length of a few >A55:"Net Worth Worksheet -- This templat >A53:"the disk. >B52:"briefly describes each template on >A52:"C and Y values on the sheet. >A62:"correlation factor of 15 points lis >B61:"computes the slope, Y intercept, & >A61:"Linear Regression -- This template >B58:"ement. >A58:"to the appropriate line in the stat >B57:" of each asset or liability sheet >A57:"staX and Y values in the sheet as >A65:""shift" 1 keys (!). You may substit >B64:"lace the cursor on G13 and press >A64:"the error flags on this template, place >B63:"lue for a new X value. To clear >A63:"It also computes the predicted Y va >B62:"ted as X