IMD 1.16: 29/05/2007 12:36:05 FOGCPM.039 ååååååååååååååå--FOGCPM039NETWORTHCALL NETWORTHDOCA REIA CALCREIA DOC !"REIA-S CALB#$%&'()*+HEARING CAL~,-./0123456789:;HEARING DOC|<=>?@ABCDEFGHIJKTABLE1 DOCLMTABLE2 DOCNTABLE3 DOC,OPQRSTTABLE4 DOCUVWCOST86-MCAL€XYZ[\]^_`abcdefgCOST86-MCALhi-04-00 86  COST86-MDOC jkCASHFAX DOC9lmnopqrsFORM-A XQTtFORM-B XQTuFORM-F XQT vwCF-A40 XQTxyCF-A50 XQTz{CF-A60 XQT|}CF-A90 XQT~CF-B40 XQT€‚CF-B50 XQTƒ„…CF-B60 XQT†‡ˆCF-B90 XQT‰Š‹CF-F40 XQT(ŒŽCF-F50 XQT(‘’“”•CF-F60 XQT(–—˜™šCF-F90 XQT(›œžŸ-CPM039 DOC¡¢£¤ååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååThis is the disk name. ååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååSuperCalc Ver. 1.05 L·P7 "NETWORTH" <--- FilenameO61)CALCULAT" ( Print Range A3:O54 )" PERSONAL NET WORTH CALCULATION: " DATE: AB‚12.823" .-'-"-." |" ASSETS" | " LIABILITIESavings A" |" |SSETS'_SH ASSETS" | '_" |" |"CASH ASSETS" | Cash on h "CASH LIABILITIES|" |" |"Savings Accounts:" | "Notes Payable:" |" |" |"Bank Name" |" Acct No." |" $ Value" | "Creditor " |WORTH "Loan No. " | "$ Value" | " | "1st Natl " | "1-10001-1000 " | AD#E‰2345.89 " | "Credit Un " | "666-34666-34 " | AD%2500 " | " | "1st Federal " | "9870-6 " | @CR0523 " | "Eq Life " | "A889-B " | AD331333.33 " | " | "Credit Union " | "18779 " | ADP5000 " | " | " | " | " | " | " | " | " | " | " | " | " Cash on hand " | AC”"0942.23 " | " | " | " |" |" |'-" |'-" | '- " | '- " | '-" |" |" Total Cash" |DˆSUM(H10:H14)" | " Total Notes Payable " | D833SUM(N10:N14)" |" |" |" |" |"Stocks & Bonds: |" | "Income Tax Owing:" |" |" |"No.ue"| Total Cas"$peresidence" |" | " Govt. " | " Year " |" |" |" NameStocks" |"Shs Sh"|" Sh" |"$ Value Bond" | " | " |B28*" |" |"AT&T" |@C100"|al EstateABC‡P43.875" |DC‡PF21*D21|" | "US Fed " | AD‚1982 " | ACƒ$832.49" |" |"Jones&Son" |@CP500"| Mortgage AARP5.25" |D&%F22*D22" | "State " | AD‚1982 " |B28* @C5350" |" |" |"|acts" |F23*D23" | " | " |" |" |'-" | '-" |" |--" Total Stocks & Bondsds" | Vehicle #DpPSUM(H21:H23))" | " Total Taxes Owing " | D‚ISUM(N20:N23))" |" |" |Cash Value" |" |" Total Liquid Assetsar #3" |E‚6 H16+H25r Vehicles" | " Total Liquid Liabes Oth " |h DP‚N16+N25" |" |" | " ******************************"**" |" | " * LIQUID NET WORTH " | E€xH27-N27" *" |" | " ******************************------"**T WORTH" |"Real Estatet" |" | "Real Estate " |" |" |" Residence" |AF120000" | " Home Mortgage " | AERVtP52567.45" | " | " Furnishings | " | AEP13500 " | " Cabin Mortgage " | ADrƒG7283.47 " |!" |!" Vacation Cabincts!" |!AD•950097!" | !" |!" |"" |"" Brown Mortgage"" |"AD…#8523.07"" | "" |"" |#" |#'- Total Aut#" |s #'-#" |$" |$" Total Real Estate$" |er Assets$F#SUM(H32:H35)ortgage$" | Retiremen $" Total Mortgages $" | $EY… SUM(N32:N35)$" |%" |%" |%" |&" |&"Automobiles & Other Vehicles&" | &" Vehicle Loans" | &" |&" |'" |'" 81 Buick1'" |'ADe6500'" | '"Credit Union '" #V1234 '" | 'AD0#d3023.64'" |(" |(" 78 Chevy2(" |(AD%2500(" | (" |(" |)" |)" Boat & Trailer)" |)AD2P3250)" | )"Marina Sales )" #AA-993 )" | )AD…#1285.23)" |*" |*'-& Bonds*" | *'-*" |+" |+"Total Autos/Vehiclessiclesles+" |+E%SUM(H40:H42))+" | +"Total Vehicle Loans +" | +DC‡SUM(N40:N42))+" |," |," | ," |," |-" |-"Other Assets-" |-" | -"TOTAL LIABILITIES -" | -EiVN27+N37+N44-" |." |." Retirement Funds." |.AD2u3275." | ." |." |/" |/" Life Ins Cash Valueelue/" |/AD1500/" | /" |/" |0" |0" |0" | 0" ***************************** -------0"**1" |1" |1" | 1" * TOTAL NET WORTH 1" | 1FQ–H53-N46|1" *2" |2" Total Other Assets2" | Life Insu2DGuSUM(H47:H50)2" | 2" *****************************2"**3" |-3'-3" |4" |4" TOTAL ASSETS|4" |4FCqiH27+H37+H44+H514" | 4"TOTAL LIAB+NET WORTHH 4" | 4FCqiN46+N50|4" |5" |=5'=5"=|;" PERSONAL NET WORTH CALCULATION: ;" DATE: ;B‚N383<" .-<'-<"-.=" |=" ASSETS=" | =" LIABILITIES=" |>" |>'_>" | >'_>" | 1FQ–H53-N46|1" *2" |2" Total Other Assets2" | Life Insu2DGuSUM(H47:H50)2" | 2" *****************************2"**3" |-3'-3" |4" |4" TOTAL ASSETS|4" |4FCqiH27+H37+H44+H514" | 4"TOTAL LIAB+NET WORTHH 4" | 4FCqiN46+N50|Own Name: NETWORTH.DOC Subject Name: NETWORTH.CAL Program Type: SuperCalc Application Program Brief: The article below describes the meaning of the terms and application of the program NETWORTH.CAL to calculate personal networth using a SuperCalc spreadsheet. --- # --- CALCULATION OF PERSONAL NETWORTH USING SUPERCALC by Bob Thomson Many years ago when I was applying for a mortgage loan, the bank required me to give them a statement of my net worth as an indication of my ability to assume the mortgage. This was, indeed, an interesting and revealing exercise. In going through the process you may learn something about your financial status which you didn't know. (I hope you don't learn something which you don't want the bank to know.) Recently, I ran across the bank's form and thought that it might be of interest to others. Consequently, I have adapted it to the Supercalc spreadsheet format and present it here for your use. What is Net Worth? Your networth is simply the difference between your financial assets and liabilities. Your assets consist of things which you own such as cash savings, stocks and bonds and property such as your home, automobiles, etc. Your liabilities are what you owe to other people. The most obvious are your home mortgage and bank loans. The supercalc program , which is the companion to this document, NETWORTH.CAL has been setup using the format of a Balance Sheet with Assets on one side and Liabilities on the other. The sheet is arranged so that each asset is matched with a corresponding or similar liability opposite it on the same line. Assets Cash and securities are considered to be liquid assets, since they can be converted to cash immediately. In the same way, unsecured loans, which use no property as collateral, are considered to be liquid liabilities (callable on demand). The arithmetic difference between these is called your Liquid Net Worth. It is to be hoped that this is a positive number! Property such as your home, car, boat, loans or mortgages which you hold on someone else's property, are also assets but are not considered to be "liquid" since it normally takes some time to sell them and clear their title of ownership. Similarly, the mortgage against your home, or loans on property are considered to be nonliquid liabilities. In the example, NETWORTH.CAL,there are three savings accounts, which, with the cash on hand totals $ 8811.12. The stocks and bonds total $ 7012.50. Notice that the value of these assets is calculated from the number of shares owned multiplied by a price per share. Because the columns containing the number of shares and their value are narrower than the standard 9 characters, the values shown are sometimes rounded. For example, 100 shares of AT&T at 43 7/8 per share was entered as 43.875 but round off to 44 on the Supercalc display. The $ Value, however, shows the correct amount as $ 4387.50. Remember that these are examples and that there may be other forms of liquid assets which you own (hold) - like a demand loan which you made to your brother-in-law and for which you hold a promisory note. Depending on your own personal holdings (and the trustworthiness and liquidity of your brother- in-law) you need to make adjustments in the statement to fit your own situation. In the example, adding the total cash & savings amount and the total stocks and bonds amount together results in the value of the total liquid assets. Liabilities Looking at the liabilities side of the sheet, we see two loans which are owed totalling $ 3833.33. These are, for example, a signature loan from the Credit Union and a loan against the cash value of a life insurance policy - both considered to be "liquid" liabilities. Below the loans (Notes Payable) is an entry for any taxes owed at the time at which the Net Worth statement is made up. As shown taxes are owed to both the federal and state governments totalling $ 1182.49. Again, note that these are examples, and you may have other obligations which you would enter here. The total liquid liabilities are $ 5015.82. Liquid Net Worth is simply the difference between Total Liquid Assets and Total Liquid Liabilities. Other Assets and Liabilities The remainder of the sheet contains the statement of value of your other assets and obligations. In Real Estate you list the current market value of your home & furnishings, vacation cabin and a mortgage which you hold on Mr & Mrs Brown's home. Balancing this you show the current outstanding amount on the mortgages on your home and cabin. Notice that the values for your residence, furnishings and cabin are to the nearest $ 500 or $ 1000, while the values of the mortgages are given to the penny. This is because the value of your residence is its estimated market value while the mortgage has an exact value at each monthly payment date which is stated in the amortization table. Obviously you can round off the mortgage and loan values as well if you wish. The other entries on the sheet are derived in a similar manner. The valuation of the automobiles and boat may be made by reading the "want ads" in the newspaper, or if you have access to one, from a "Blue Book" on current vehicle prices. Total Net Worth - A Snapshot in Time The Total Net Worth is determined by taking the difference between the Total Assets, which is the sum of all assets (liquid and nonliquid), and Total Liabilities which is the sum of all liabilities (liquid and nonliquid). The Net Worth statement is a picture of your financial situation at a given instant in time. For this reason, in order to give you a reasonably accurate picture, you should be careful to enter information that is correct or representative of the correct value on the date which you are using. You should be able, for example, to obtain stock prices from the newspaper, bank balances from your passbook or bank statement, property valuations from current real estate valuations for similar properties, etc. When to Run When should you run this program? One common time to run a Net Worth calculation is at the end of each year. By doing this you can determine how your net worth changes from year to year. Another obvious time to run it is when you need it to convince someone to lend you money. I hope  this program is useful to you - and convincing!! One Final Tip If you have more line items than I have left room for on one page, you may have to carry your net worth calculation over onto another page. In such a case you would probably want to repeat the headings by copying the block A3:O6 into the area starting with A67. (Remember that the default page length is 66 lines). You also will have to be careful how you sum the data onto the second page so that the totals are correct. The tip I want to pass on is this: If you enter the "as of" date of the calculation on page 1 as a numeric value instead of as text you can copy it onto the next page using the recalculate feature of Supercalc. This means that you need only enter the date on page 1 and it will be corrected automatically on succeeding pages. For example, suppose you enter the date as 12.82 for December 1982 in cell N3. Then if you enter N3 into cell N67 the value 12.82 will be placed into cell N67 upon any recalculation. s than I have left room for on one page, you may have to carry your net worth calculation over onto another page. In such a case you would probably want to repeat the headings by copying the block A3:O6 into the area starting with A67. (Remember that the default page length is 66 lines). You also will have to be careful how you sum the data onto the second page so that the totals are correct. The tip I want to pass on is this: If you enter the "as of" date of the calculation on page 1 as a numeric value instead of as text you can copy it onto the next page using the recalculate feature of Supercalc. This means that you need only enter the date on page 1 and it will be corrected automatically on succeeding pages. For example, suppose you enter the date as 12.82 for December 1982 in cell N3. Then if you enter N3 into cell SuperCalc ver. 1.00 ÏÏÏ4:        $"REAL ESTATE INVESTMENT ANALYSISRTY ) !"FORMULASTE I "*RMU#"************************ALYS#"INVESTMENT INFORMATION:ALYS !"E9 = D8/D6N#"*************************LYS!"INPUT*******!"MONTHLY***** "YEAR !"E11 = E40***!"************!" **********!" ******* !"G13 = D13*12#"SALE PRICE---------------LYSP!05000 !"F14 = D13---!"DOWN PAYMENT ""G14 = D13*D12-------#" FIXED DOWN-------------LYSP!03000 #"F16 = (.01*D15)*D13+D13-LYS""% OF SALE PRICE-13+D¢ ERRORD8/D6Y FACT !"G16 = F16*12 !"LOAN BALANCE ¡!E40 ""F19 = (.01*D19)*D13D #"MONTHS-1st. YEAR---------LYS P0ONTH ""G19 = F19*D12AR----- #"SCHED. INCOME PER MONTH--LYS P!000D ¢!D13*12 FACT ""F20 = (.01*D20)*F16N #"SCHEDULED INCOME-1ST. YRLYS ¡!D13 ¢!D13*D12FACT !"G20 = F20*12#" % INCREASE INCOME-2nd YRLYSP0 IN#" PROJECTED INCOME-2nd YRLYS£!(.01*D15)*D13+D13ES¢!F16*125)*D1 ""F23 = D13-F19)*ƒ +#"*************************LYS ""G23 = F23*D12*******#"VACANCY FACTOR( % EST )*LYS ""F24 = F16-F20( % EST#" FIRST YEAR------------LYSP05FI£!(.01*D19)*D13D13ES¢!F19*D12)*D1 !"G24 = F24*12#" SECOND YEAR-----------LYSP0 SE£!(.01*D20)*F16D13ES¢!F20*120)*F1#"*************************LYS ""E40 = D28+D32+D36***#"GROSS OPERATING INCOME**LYS ""F40 = D31+D35+D39COM!" 1ST. YEAR¢!D13-F19)*F1¢!F23*D12)*F1 !"G40 = F40*12!" 2ND. YEAR¢!F16-F20)*F1¢!F24*12)*F1#"*************************LYS !"E44 = E85***!"LOAN DATA*** !"G44 = E86***#"*************************LYS ""E45 = G23-E85*******#" 1st NEW OR EXISTING----LYSP!02000 ""G45 = G24-E86XISTING#" INTEREST RATE---------LYSP0.75 ""E46 = F40*D12TE-----#" NO. YEARS------------LYSP0 N !"G46 = G40ARS#" MO. PAYMENT----------LYSP095.4#" 2nd LOAN---------------LYSP!00000 ""E48 = E45-E46------- #" INTEREST RATE--------LYS P0.5I ""G48 = G45-G46ATE----!#" NO. YEARS------------LYS!P00/5"#" MO.PAYMENT-----------LYS"P062M """G54 = SUM(D50:D53)--##" SPECIAL NOTES----------LYS#P0ERRO$#" INTEREST RATE--------LYS$P0ERRO%#" NO. YEARS------------LYS%P0ERRO %!"E56 = E48ARS&#" MO. PAYMENT----------LYS&P0ERRO &""G56 = G48-G54T------'!"TOTAL LOAN54'¢!D28+D32+D36'¢!D31+D35+D39'¢!F40*12+D39(#"*************************LYS (""E59 = E56+E58*******)""OPERATING DATA******)!"1st.YEAR DAT)!"2nd.YEAR DAT )""G59 = G56+G58*******#"*************************LYS+""OPERATING EXPENSE***+¡!E85+¡!E86 +""E61 = D61/D60NSE***,""NET OPERATING INCOME,¢!G23-E85D39,¢!G24-E86D39 ,""E62 = D62/D60NCOME-""LOAN PAYMENTSNCOME-¢!F40*D12D39-¡!G40.#"*************************LYS .""F64 = (D64*.01)*D6**/#"GROSS SPENDABLE (-LOSS)*LYS/¢!E45-E46D39/¢!G45-G46D39 /!"F65 = D6-F640#"*************************LYS1#"SPECIAL RESERVE-EST/YEARLYS 1""E65 = 100-D64E-EST/Y2#" FURNITURE--------------LYS3#" CARPET-----------------LYS4#" HEATERS,APPLIANCE ETC.-LYS 4#"E85 = SUM(D69:D84)/12*D12LYS5!"TOTALSUM(D695£SUM(D50:D53)D13ES 5""E86 = SUM(D69:D84)26#"*************************LYS7#"ADJUSTED GROSS SPENDABLELYS7¡!E487¢!G48-G54D53)8#"*************************LYS 8!"E89 = D6/D889""PAID ON PRINCIPAL***9!"ENTERN PRINC9P02ER9P049R 9!"E92 = G13/D6:#"TOTAL RETURN*************LYS:¢!E56+E58D53):¢!G56+G58D53);#"ASSESSED VALUE-CURRENT**LYS;P!05667 ;!"E93 = G16/D6<#" LAND------------------LYS""E106= D102+D1031---?#"IMPROVEMENTS(% SALE PRICE)YS?P0PRO?£!(D64*.01)*D6D13ES ?$"E108= L93+(E106/D104)*(D12/12)RTY )@#" LAND (% SALE PRICE)(D12/12@¢C100-D64)*D6@¢!D6-F64)*D6 @#"E109= L94+(E106/D104)(D12/12A#"*************************/12B#"OPERATING EXPENSE (YEAR)/12 B#"E112= (E109*D111)*(0.01)+E56C#"*************************56 C#"E113= (E109*D111)*(0.01)+G56D!"TAXES(E109*DE#" CALIF.-1.025%*S.P.----56E‚!.01025*D6D6 E""F115= E113+F100/D8P.F#" OTHER-----------------56FP0ERROG#"INSURANCE----------------56GP04UR G""K89 = D98/D99*100---H#"UTILITIES----------------56HP060II#" WATER, SEWER-----------56IP0ERRO I""K91 = D6-(F65+E106)-J#" ELECT.-----------------56JP0ERROK#" GAS--------------------56KP0ERRO K""L93 = K91*K89/12*D12 L""N93 = K91-L9312*D12M#"MANAGEMENT FEE-----------56MP0ANAG M""L94 = (N93-L93)*K89-N#"POOL MAINTANCE-----------56NP0ERRO N""N94 = N93-L94-------O#"GARDENER-----------------56OP00DE O""L95 = N94*K89-------P#"TRASH--------------------56PP0ERRO P""N95 = N94-L95-------Q#"GENERAL MAINTANCE--------56QP00ER Q""L96 = N95*K89NCE----R#"LICENSE & FEE------------56RP0CEN R""N96 = N95-L96-------S#"*************************56 S""L97 = N96*K89*******T""TOTAL-1st YEAR******T£!SUM(D69:D84)/12*D12 T""N97 = N96-L97E:ƒT)/1U""TOTAL-2nd YEAR:ƒT)/1U£!SUM(D69:D84)12*D12V#"*************************56 V$"DEPRECIATION SCHEDULE- BUILDINGRTY )W#"NUMBER OF UNITS----------LDIWP0UMBEX!"UNIT VALUENIX¢!ERRORD6/D88:D84) X!"RATE:ƒ/ƒ X£ERRORD98/(D99*100)2*D12Y#"*************************LDI Y%"BASIS: S.P.-(LAND+PERSONAL PROPERTY ))ÏÏÏÏÏZ""PURCHASE PRICE ISPER Z£D6-(F65+E106)2*D12[#" TIMES GROSS-CURRENT RENT PR[¢ ERRORG13/D6+E106\#" TIMES GROSS-PROJECT.RENT PR\¢ ERRORG16/D6+E106 \!"1 st.YEAR/ƒ \£!ERRORK91*K89/12*D12*D12 \¢!ERRORK91-L9312*D]#"************************* PR ]!"2 nd YEAR*** ]£!ERROR(N93-L93)*K89*D12 ]¢!ERRORN93-L94)*K8^#"DEPRECIATION/TAX SHELTER PR ^!"3 rd YEARON/ ^¢!ERRORN94*K89)*K8 ^¢!ERRORN94-L95)*K8_#"************************* PR _!"4 th YEAR*** _¢!ERRORN95*K89)*K8 _¢!ERRORN95-L96)*K8`#"BUILDING DEPRECIATION*** PR `!"5 th YEAREPR `¢!ERRORN96*K89)*K8 `¢!ERRORN96-L97)*K8a#" NO. YEARS--ACC.DEPREC.- PRaP0NO.b#" ACCEL. DEPRECIATION RATE PRbP075Ec#"EST. % APPRECIATION/YEAR- PRcP0ST. c£(D100*D6)*.01*D12 c£!ERRORSUM(L93:L97)*D12d""PERSONAL PROPERTY)e#" APPLIANCES------------- PReP!000Pf#" MISC./DRAPES,CARPETS--- PRfP!000Sg#" NO. YEARS DEPRECIATION- PRgP0 NO.g!" (S/L)RS Di!"TOTALL)RS Di¢!D102+D1037)j#"************************* PRk#"TOTAL DEPRECIATION-1st.YR PRk¤!ERRORL93+(E106/D104)*(D12/12) l#"TOTAL DEPRECIATION-2nd.YR)Rl£!ERRORL94+(E106/D104)(D12m#"*************************)Rn#"TAX SHELTER BRACKET-%----)RnP0X So!" 1st YEAR Bo¤!ERROR(E108*D111)*(0.01)+E56) p!" 2nd YEARl*p¤!ERROR(E109*D1 11)*(0.01)+G56) q#"*************************Rr#"EST.% RETURN ON INVEST.*Rr£ ERROR(E113+F100)/D801)+Gs#"*************************Rt%"ENTER DATA IN FIRST OR INPUT COLUMN (0)ÏÏÏÏÏu$"ALL OTHER DATA POINTS ARE PROTECTED(v$"TO FORCE A RECALCULATION ENTER !ED((D100*D6)*.01*D12 c£!ERRORSUM(L93:L97)*D12d""PERSONAL PROPERTY)e#" APPLIANCES------------- PReP!000Pf#" MISC./DRAPES,CARPETS--- PRfP!000Sg#" NO. YEARS DEPRECIATION- PRgP0 NO.g!" (S/L)RS Di!"TOTALL)RS Di¢!D102+D1037)j#"************************* PRk#"TOTAL DEPRECIATION-1st.YR PRk¤!ERRORL93+(E106/D104)*(D12/12) l#"TOTAL DEPRECIATION-2nd.YR)Rl£!ERRORL94+(E106/D104)(D12m#"*************************)Rn#"TAX SHELTER BRACKET-%----)RnP0X So!" 1st YEAR Bo¤!ERROR(E108*D111)*(0.01)+E56) p!" 2nd YEARl*p¤!ERROR(E109*D1 REAL ESTATE INVESTMENT ANALYSIS (REIA)(V1.10) COMMERCIAL INCOME PROPERTY THIS INVESTMENT ANALYSIS IS FOR PLANNING PURPOSES ONLY. VERIFY DEPRECIATION AND OTHER DATA WITH YOUR CPA. NOTE: BUILDING & PERSONAL PROPERTY DEPRECIATION IS BASED ON TAX CODE FOR 1984 & 1985. THE NEW PROPOSED TAX CHANGES FOR 1986 WILL CHANGE LINES A97:A106. UPDATE OF THIS PROGRAM WILL BE MADE. THIS PROGRAM USES SC2 TEMPLATE(V1.00), OSBORNE 1. IT CONSISTS OF THE BASIC PROGRAM "REIA" WHICH IS PROTECTED IN SC2 FORMAT AND A SAMPLE PROGRAM "REIA-S". COPY "AMORTAB3.CAL" FROM /APP#048. YOU CAN USE THIS TABLE FOR THE INTREST AND PRINCIPAL PAYMENTS. LOAD "REIA" AND ENTER DATA IN THE INPUT COLUMN AT EACH PLACE PROVIDED WITH A "0". ALL DATA COLUMNS "A"THRU"C" AND"E"THRU"N" ARE PROTECTED. FORMULAS USED ARE SHOWN J1:N85. PRINT OUT "REIA" A1:G59 PAGE 1 AND A60:G116 PAGE 2. FORMULA PRINT OUT J1:N51 PAGE 1 AND J52:N100 PAGE 2. ENTER INVESTMENT INFORMATION AS FOLLOWS: SALES PRICE, DOWN PAYMENT, NUMBER OF MONTHS IN 1st. YEAR, AND THE CURRENT SCHEDULED INCOME PER MONTH. ENTER % OF THE PROJECTED RENTAL INCREASE FOR THE 2nd YEAR. ALSO ENTER THE 1st. YEAR ESTIMATED VACANCY RATE (%) AND THE 2nd. YEAR ESTIMATED RATE (%). ENTER LOAN DATA FOR THE 1st, 2nd AND ANY SPECIAL NOTES. IT WILL BE NECESARY TO CALCULATE THE PRINCIPAL PAID ON THE LOANS FOR THE 1st AND 2nd YEARS. ENTER AS SHOWN "PAID ON PRINCIPAL" COLUMN FOR EACH YEAR. ENTER TOTAL CURRENT ASSESSED VALUE OF THE PROPERTY, LAND AND IMPROVEMENTS, FROM THE THE TAX BILL. FROM THE RATIO SHOWN, ENTER THE % OF IMPROVEMENTS FOR THIS ANALYSIS. REAL ESTATE TAXES ARE SHOWN FOR CALIFORNIA AS A % OF THE SALES PRICE. ENTER UNDER "OTHER" ANY INCREASE OR (-) FOR LESS THAN THAT SHOWN. YOU MAY CHANGE THE TAX BASIS AT D70. ENTER OPERATING EXPENSES AS SHOWN, BASED ON THE CURRENT YEAR. ENTER NUMBER OF UNITS. ŠNOTE: SEE REMARKS ON DEPRECIATION AT THE BEGINING OF THIS DOC. ENTER THE NUMBER OF YEARS YOU WANT TO TAKE BUILDING DEPRECIATION AND THE METHOD: THAT IS 1.50, 1.75 ETC. THE TOTAL DEPRECIATION IS SHOWN FOR THE 1st. AND 2nd. YEAR. SEE J87:N100 FOR A 5 YEAR SUMMARY.TOTAL DEPREC. IS BASED ON THE SALES PRICE LESS THE LAND AND PERSONAL PROPERTY VALUES. ENTER THE ESTIMATED % FOR THE BUILDING APPRECIATION. ENTER APPROXIMATE REPLACEMENT COST FOR PERSONAL ITEMS, APPLIANCES, DRAPES, CARPETS ETC. THESES ITEMS TO BE DEPRECIATED AT A DIFFERENT RATE-GENERALY STRAIGHT LINE. ENTER NUMBER OF YEARS TO BE DEPRECIATED. THE LAST ITEM OF DATA TO BE ENTERED IS THE TAX BRACKET BASED ON TOTAL OF FEDERAL, STATE AND LOCAL TAXES PAID. ONCE THE DATA HAS BEEN ENTERED, IT MAY BE PRINTED OUT AS SHOWN ABOVE. CHANGE ANY DATA POINT AND WATCH THE RESULTS. AS EXAMPLE: CHANGE THE DOWN PAYMENT OR THE % USED IN THE IMPROVEMENTS TO LAND RATIO. IF YOU WISH TO CHANGE ANY FORMULAS YOU MUST "UNPROTECT" BEFORE YOU CAN MAKE THE CHANGE. WILLIAM E. KIRK 97966 BUBB LANE BROOKINGS, OREGON 97415 6/10/85  EE J87:N100 FOR A 5 YEAR SUMMARY.TOTAL DEPREC. IS BASED ON THE SALES PRICE LESS THE LAND AND PERSONAL PROPERTY VALUES. ENTER THE ESTIMATED % FOR THE BUILDING APPRECIATION. ENTER APPROXIMATE REPLACEMENT COST FOR PERSONAL ITEMS, APPLIANCES, DRAPES, CARPETS ETC. THESES ITEMS TO BE DEPRECIATED AT A DIFFERENT RATE-GENERALY STRAIGHT LINE. ENTER NUMBER OF YEARS TO BE DEPRECIATED. THE LAST ITEM OF DATA TO BE ENTERED IS THE TAX BRACKET BASED ON TOTAL OF FEDERAL, STATE AND LOCAL TAXES PAID. ONCE THE DATA HAS BEEN ENTERED, IT MAY BE PRINTED OUT AS SHOWN ABOVE. CHANGE ANY DATA POINT AND WATCH THE RESULTS. AS EXAMPLE: CHANGE THE DOWN PAYMENT OR THE % USED IN THE IMPROVEMENTS TO LAND RATIO. IF YOU WISH TO CHANGE ANY FORMULAS YOU MUST "UNPROTECT" BEFORE YOU CAN MAKE THE CHANGE. WILLIAM E. KIRK 97966 BUBB LANE BROOKINGS, OREGON 97415 6/10/85  SuperCalc ver. 1.00 ÏÏÏ41B:B        $"REAL ESTATE INVESTMENT ANALYSISRTY ) "FORMULASTE I "*RMU"************************ALYS"INVESTMENT INFORMATION:ALYS "E9 = D8/D6N"*************************LYS"INPUT*******"MONTHLY*****"YEAR "E11 = E40***"************" **********" ******* "G13 = D13*12"SALE PRICE---------------LYSQ!525000RICE--- "F14 = D13---"DOWN PAYMENT "G14 = D13*D12-------" FIXED DOWN-------------LYSQ!183000D DOWN- "F16 = (.01*D15)*D13+D13-LYS"% OF SALE PRICE-13+D‚ @4…qB…qB†D8/D6ING EX "G16 = F16*12 "LOAN BALANCE !F4 E40 "F19 = (.01*D19)*D13D "MONTHS-1st. YEAR---------LYS P7ONTH "G19 = F19*D12AR----- "SCHED. INCOME PER MONTH--LYS P!4200D ‚!EP@D13*12NG EX "F20 = (.01*D20)*F16N "SCHEDULED INCOME-1ST. YRLYS !DBD13 ‚!E)@D13*D12G EX "G20 = F20*12" % INCREASE INCOME-2nd YRLYSP10 IN" PROJECTED INCOME-2nd YRLYSƒ!DF (.01*D15)*D13+D13(Y‚!EUDF16*125)*D1 "F23 = D13-F19)*ƒ +"*************************LYS "G23 = F23*D12*******"VACANCY FACTOR( % EST )*LYS "F24 = F16-F20( % EST" FIRST YEAR------------LYSP1.5FIƒ!Bc(.01*D19)*D13D13(Y‚!CDF19*D12)*D1 "G24 = F24*12" SECOND YEAR-----------LYSP1 SEƒ!BF (.01*D20)*F16D13(Y‚!CUDF20*120)*F1"*************************LYS "E40 = D28+D32+D36***"GROSS OPERATING INCOME**LYS "F40 = D31+D35+D39COM" 1ST. YEAR‚!DA7D13-F19)*F1‚!E(•F23*D12)*F1 "G40 = F40*12" 2ND. YEAR‚!DEs€F16-F20)*F1‚!ETˆVF24*12)*F1"*************************LYS "E44 = E85***"LOAN DATA*** "G44 = E86***"*************************LYS "E45 = G23-E85*******" 1st NEW OR EXISTING----LYSQ!162000NEW OR "G45 = G24-E86XISTING" INTEREST RATE---------LYSP11.75 "E46 = F40*D12TE-----" NO. YEARS------------LYSP30 N "G46 = G40ARS" MO. PAYMENT----------LYSQ1695.43 PAYME" 2nd LOAN---------------LYSQ!180000LOAN--- "E48 = E45-E46------- " INTEREST RATE--------LYS P13.5I "G48 = G45-G46ATE----!" NO. YEARS------------LYS!"30/5"" MO.PAYMENT-----------LYS"P2062M ""G54 = SUM(D50:D53)--#" SPECIAL NOTES----------LYS$" INTEREST RATE--------LYS%" NO. YEARS------------LYS %"E56 = E48ARS&" MO. PAYMENT----------LYS &"G56 = G48-G54T------'"TOTAL LOAN54'‚!F4 D28+D32+D36'‚!D7WCD31+D35+D39'‚!EE‘`F40*12+D39("*************************LYS ("E59 = E56+E58*******)"OPERATING DATA******)"1st.YEAR DAT)"2nd.YEAR DAT )"G59 = G56+G58*******"*************************LYS+"OPERATING EXPENSE***+!DU3dX3333E85+!D”†%E86 +"E61 = D61/D60NSE***,"NET OPERATING INCOME,‚!E#BSTffgG23-E85D39,‚!EE9“PG24-E86D39 ,"E62 = D62/D60NCOME-"LOAN PAYMENTSNCOME-‚!E&0 F40*D12D39-!EE‘`G40."*************************LYS ."F64 = (D64*.01)*D6**/"GROSS SPENDABLE (-LOSS)*LYS/‚!Ä(veX3330E45-E46D39/‚!C1G45-G46D39 /"F65 = D6-F640"*************************LYS1"SPECIAL RESERVE-EST/YEARLYS 1"E65 = 100-D64E-EST/Y2" FURNITURE--------------LYS3" CARPET-----------------LYS4" HEATERS,APPLIANCE ETC.-LYS 4"E85 = SUM(D69:D84)/12*D12LYS5"TOTALSUM(D695ƒSUM(D50:D53)D13(Y 5"E86 = SUM(D69:D84)26"*************************LYS7"ADJUSTED GROSS SPENDABLELYS7!Ä(veX3330E487‚!C1G48-G54D53)8"*************************LYS 8"E89 = D6/D889"PAID ON PRINCIPAL***9"ENTERN PRINC9P812ER9P1749R 9"E92 = G13/D6:"TOTAL RETURN*************LYS:‚!Ä deX3330E56+E58D53):‚!D YG56+G58D53);"ASSESSED VALUE-CURRENT**LYS;Q!245667ED VALU ;"E93 = G16/D6<" LAND------------------LYS"E106= D102+D1031---?"IMPROVEMENTS(% SALE PRICE)YS?P85PRO?ƒ!FDbP(D64*.01)*D6D13(Y ?"E108= L93+(E106/D104)*(D12/12)RTY )@" LAND (% SALE PRICE)*(D12/1@‚B100-D64)* D6@‚!ExuD6-F64)*D6 @"E109= L94+(E106/D104)(D12/1A"*************************2/1B"OPERATING EXPENSE (YEAR)2/1 B"E112= (E109*D111)*(0.01)+E56C"*************************56 C"E113= (E109*D111)*(0.01)+G56D"TAXES(E109*DE" CALIF.-1.025%*S.P.----56E‚!DS%.01025*D6D6 E"F115= E113+F100/D8P.F" OTHER-----------------56G"INSURANCE----------------56GP824UR G"K89 = D98/D99*100---H"UTILITIES----------------56HP1560II" WATER, SEWER-----------56 I"K91 = D6-(F65+E106)-J" ELECT.-----------------56K" GAS--------------------56 K"L93 = K91*K89/12*D12 L"N93 = K91-L9312*D12M"MANAGEMENT FEE-----------56MP0ANAG M"L94 = (N93-L93)*K89-N"POOL MAINTANCE-----------56 N"N94 = N93-L94-------O"GARDENER-----------------56OP900DE O"L95 = N94*K89-------P"TRASH--------------------56 P"N95 = N94-L95-------Q"GENERAL MAINTANCE--------56QP800ER Q"L96 = N95*K89NCE----R"LICENSE & FEE------------56RP21CEN R"N96 = N95-L96-------S"*************************56 S"L97 = N96*K89*******T"TOTAL-1st YEAR******Tƒ!DU3dX3333SUM(D69:D84)/12*D12 T"N97 = N96-L97E:ƒT)/1U"TOTAL-2nd YEAR:ƒT)/1Uƒ!D”†%SUM(D69:D84)12*D12V"*************************56 V"DEPRECIATION SCHEDULE- BUILDINGRTY )W"NUMBER OF UNITS----------LDIWP7UMBEX"UNIT VALUENIX‚!EuD6/D88:D84) X"RATE:ƒ/ƒ Xƒ@(W(W)D98/(D99*100)2*D12Y"*************************LDI Y"BASIS: S.P.-(LAND+PERSONAL PROPERTY ))ÏÏÏÏÏZ"PURCHASE PRICE ISPER ZƒFCPD6-(F65+E106)2*D12[" TIMES GROSS-CURRENT RENT PR[‚ ?–G13/D6+E106\" TIMES GROSS-PROJECT.RENT PR\‚ @VG16/D6+E106 \"1 st.YEAR/ƒ \ƒ!E%‡PK91*K89/12*D12*D12 \‚!F@SuK91-L9312*D]"************************* PR ]"2 nd YEAR*** ]ƒ!E9B…qB…s(N93-L93)*K89*D12 ]‚!F6c@qB…qCN93-L94)*K8^"DEPRECIATION/TAX SHELTER PR ^"3 rd YEARON/ ^‚!E7hY6sIN94*K89)*K8 ^‚!F2†Y•QN94-L95)*K8_"************************* PR _"4 th YEAR*** _‚!E3€P#•3RxN95*K89)*K8 _‚!F)HT“Hh€N95-L96)*K8`"BUILDING DEPRECIATION*** PR `"5 th YEAREPR `‚!E02y5wR“dN96*K89)*K8 `‚!F&E&™Ss9DN96-L97)*K8a" NO. YEARS--ACC.DEPREC.- PRaP18NO.b" ACCEL. DEPRECIATION RATE PRbP1.75Ec"EST. % APPRECIATION/YEAR- PRcP5ST. cƒE&%(D100*D6)*.01*D12 cƒ!Fg#F&`VSUM(L93:L97)*D12d"PERSONAL PROPERTY)e" APPLIANCES------------- PReP!7000Pf" MISC./DRAPES,CARPETS--- PRfP!8000Sg" NO. YEARS DEPRECIATION- PRgP5 NO.g" (S/L)RS Di"TOTALL)RS Di‚!ED102+D1037)j"************************* PRk"TOTAL DEPRECIATION-1st.YR PRk„!E'bPL93+(E106/D104)*(D12/12) l"TOTAL DEPRECIATION-2nd.YR)Rlƒ!EBB…qB…sL94+(E106/D104)(D12m"*************************)Rn"TAX SHELTER BRACKET-%----)RnP40X So" 1st YEAR Bo„!Ds4Afffp(E108*D111)*(0.01)+E56) p" 2nd YEARl*p„!E9(W)(E109*D111)*(0.01)+G56) q"*************************Rr"EST.% RETURN ON INVEST.*Rrƒ @#p‡s“(E113+F100)/D801)+Gs"*************************Rt"ENTER DATA IN FIRST OR INPUT COLUMN (0)ÏÏÏÏÏu"ALL OTHER DATA POINTS ARE PROTECTED(v"TO FORCE A RECALCULATION ENTER !ED(CEL. DEPRECIATION RATE PRbP1.75Ec"EST. % APPRECIATION/YEAR- PRcP5ST. cƒE&%(D100*D6)*.01*D12 cƒ!Fg#F&`VSUM(L93:L97)*D12d"PERSONAL PROPERTY)e" APPLIANCES------------- PReP!7000Pf" MISC./DRAPES,CARPETS--- PRfP!8000Sg" NO. YEARS DEPRECIATION- PRgP5 NO.g" (S/L)RS Di"TOTALL)RS Di‚!ED102+D1037)j"************************* PRk"TOTAL DEPRECIATION-1st.YR PRk„!E'bPL93+(E106/D104)*(D12/12) l"TOTAL DEPRECIATION-2nd.YR)Rlƒ!EBB…qB…sL94+(E106/D104)(D12m"*************************)Rn"TAX SHELTER BRACKET-%----)RnP40X So" 1st YEAR Bo„!Ds4Afffp(E108*D111)*(0.01)+E56) p" 2nd YEARl*p„!E9(W)(E109*D111)*(0.01)+G56) q"*******************SuperCalc ver. 1.00 PREDICTION TABLE FOR HEARING LOSS WITH AGEÏÏÏ‚‚J‚‚ €‚‚‚‚@€‚ €€€€€€4: „        %"PREDICTION TABLE FOR HEARING LOSS WITH AGEÏÏ &"Enter AGE GROUP as either 25,30,35 etc. DO NOTÏÏÏÏÏÏ$"FOR FEMALES, jump to cell AC70,35 et %"use 20 or less (not available in tables)...O#"FOR MALES, jump to cell A7le$" by pressing:  =AC7in tabl %"instead, insert 25 for anyone younger, since#" by pressing: =A7"...more about age groups->> #"the difference is trivial.>$"PRINTOUT: /O D A7:J41 SS Per "(FULL DOCUMENTATION IN FILE: HEARING.DOC)ce$"PRINTOUT: /O D AC7:AL41 SS P'-INT%"PREDICTION TABLE FOR HEARING LOSS WITH AGEe $"(based on the method describedSS WIT#"adapted for SUPERCALCescribe%"PREDICTION TABLE FOR HEARING LOSS WITH AGEe'$"(based on the method describedSS WIT0#"adapted for SUPERCALCescribe6"****************************************Ee "" by SPOOR, A; in****""by Dr Peter Dodwell*'"" by SPOOR, A; inll*0""by Dr Peter Dodwell*6%"copyright P. Dodwell: This SC template*Ee!" NAME:. "CITIZEN,John" * FOR INSTRUCTIONS, =A1templat "MALE $"PRESBYCUSIS VALUES IN RELATIONemplat""Dept of Health,ES IN!" NAME:lt"CITIZEN,Jane"" * FOR INSTRUCTIONS, =A1emplat#!"FEMALE INSTR'$"PRESBYCUSIS VALUES IN RELATIONemplat0""Dept of Health,ES IN6%"may be freely used and copied, providedEe !" NUMBER:ly $"TO NOISE INDUCED HEARING LOSS provid !"Box 5013,NDU !" NUMBER:DU' $"TO NOISE INDUCED HEARING LOSS provid0 !"Box 5013,NDU6 #"its origin is acknowledged.S !"AGE GROUP:is PB55E G " toG ¢€BYC11+46-AF2 "yrs "*s !"DATE:‚ +4 "15/11/84‚ +4 #"Int. Aud. (1967); 6:48-57.S #"Wellington, New Zealand..S !"AGE GROUP:/p PB60E G " toG ¢€BdAE11+46-AF2! "yrs" "*s# !"DATE:ž +4$ "15/11/84ž +4' ""Int. Aud. 6, 48-57la0 #"Wellington, New Zealand..S6 "****************************************Ee '_*** "*** '_***6 "____ !"FREQ-******* " |Q- !" ACTUAL***** !"Predicted*** ""DIFFERENCE,Actual*** "|FFE !"AGE GPNCE,Ac " PVG !"FREQ-NCE,Ac " |Q- !" ACTUALCE,Ac !"Predicted,Ac" ""DIFFERENCE,Actual***& "|FFE' "AGEE( " PVE "ENCY " |Y !" LOSSNCE,Ac !" LOSSCE,Ac "" from Predictedl*** "|rom !" 250Predict !" 500Predict !" 1000Predict !" 2000Predict !" 3000Predict !" 4000Predict !" 6000Predict !" 8000Predict "ENCY " |Y !" LOSSredict !" LOSSedict" "" from Predictedl***& "|rom' !" 250Predict) !" 500redict+ !" 1000edict- !" 2000edict/ !" 3000edict1 !" 4000edict3 !" 6000edict5 !" 8000edict!" (Hz)0edict!" (dB)edict!" (dB)edict!" (Hz))edict" |z)!" (dB)edict !" (dB)edict& "| (d '_ (d  "| (d  '_ (d" (d '_ (d& "| (d' '_ (d6 "____" |_ "LEFT!"RIGHT)edict "LEFT!"RIGHT)edict" |HT "LEFT!"RIGHT)edict# "LEFT$!"RIGHT)edict& "|GHT" |HT  "|HT p25HT p0HT p25HTp0HTp25HTp0HTp25HTp0HTp25HTp1HTp25HTp1HTp25HTp2HTp25HTp1HT" |HT& "|HT'p25HT(p0HT)p25HT*p0HT+p25HT,p0HT-p25HT.p0HT/p25HT0p0HT1p25HT2p1HT3p25HT4p1HT5p25HT6p1HTp250HT" |HT¡N/ANA1¡N/ANA1£@A`LOOKUP(C11,L18:L30)¤N/AIF((E19-C19)>-15,0,E19-C19)¤N/AIF((E19-D19)>-15,0,E19-D19)  "|/A ¢B0L18+59-D19) p0 ¢B0N18+59-D19)p0¢B0P18+59-D19)p0¢B0R18+59-D19)p1¢B0T18+59-D19)p3¢B0V18+59-D19)p4¢B0X18+59-D19)p5¢B0Z18+59-D19)p4p250" |¡N/ANA+¡N/ANA+ ¤@A€LOOKUP(AE11,AN18:AN29)D19)#¥N/AIF((AG19-AE19)>-15,0,AG19-AE19)____$¥N/AIF((AG19-AF19)>-15,0,AG19-AF19)____& "|/A'¢B0AN18+59-AF1(p0)¢B0AP18+59-AF1*p1+¢B0AR18+59-AF1,p1-¢B0AT18+59-AF1.p1/¢B0AV18+59-AF10p11¢B0AX18+59-AF12p23¢B0AZ18+59-AF14p35¢B0BB18+59-AF16p2p500" |¡N/ANA8¡N/ANA8£@ApLOOKUP(C11,N18:N30)¤N/AIF((E20-C20)>-15,0,E20-C20)¤N/AIF((E20-D20)>-15,0,E20-D20)  "|/A ¢B5L19+50-D20) p1 ¢B5N19+50-D20)p1¢B5P19+50-D20)p1¢B5R19+50-D20)p3¢B5T19+50-D20)p5¢B5V19+50-D20)p7¢B5X19+50-D20)p9¢B5Z19+50-D20)p8p500" |¡N/ANA+¡N/ANA+ ¤@ALOOKUP(AE11,AP18:AP29)D20)#¥N/AIF((AG20-AE20)>-15,0,AG20-AE20)____$¥N/AIF((AG20-AF20)>-15,0,AG20-AF20)____& "|/A'¢B5AN19+50-AF2(p1)¢B5AP19+50-AF2*p2+¢B5AR19+50-AF2,p2-¢B5AT19+50-AF2.p3/¢B5AV19+50-AF20p31¢B5AX19+50-AF22p43¢B5AZ19+50-AF24p6 5¢B5BB19+50-AF26p5p1000" |¡N/ANA9¡N/ANA9£@ApLOOKUP(C11,P18:P30)¤N/AIF((E21-C21)>-15,0,E21-C21)¤N/AIF((E21-D21)>-15,0,E21-D21)  "|/A ¢B@L20+51-D21) p2 ¢B@N20+51-D21)p2¢B@P20+51-D21)p2¢B@R20+51-D21)p5¢B@T20+51-D21)p8¢B@V20+51-D21)p11¢B@X20+51-D21)p14¢B@Z20+51-D21)p13p1000" |¡N/ANA+¡N/ANA+ ¤@BLOOKUP(AE11,AR18:AR29)D21)#¥N/AIF((AG21-AE21)>-15,0,AG21-AE21)____$¥N/AIF((AG21-AF21)>-15,0,AG21-AF21)____& "|/A'¢B@AN20+51-AF2(p2)¢B@AP20+51-AF2*p3+¢B@AR20+51-AF2,p3-¢B@AT20+51-AF2.p4/¢B@AV20+51-AF20p51¢B@AX20+51-AF22p73¢B@AZ20+51-AF24p95¢B@BB20+51-AF26p8p2000" |¡N/ANA0¡N/ANA0£@BLOOKUP(C11,R18:R30)¤N/AIF((E22-C22)>-15,0,E22-C22)¤N/AIF((E22-D22)>-15,0,E22-D22)  "|/A ¢BEL21+52-D22) p3 ¢BEN21+52-D22)p3¢BEP21+52-D22)p3¢BER21+52-D22)p7¢BET21+52-D22)p11¢BEV21+52-D22)p16¢BEX21+52-D22)p19¢BEZ21+52-D22)p18p2000" |¡N/ANA+¡N/ANA+ ¤@BLOOKUP(AE11,AT18:AT29)D22)#¥N/AIF((AG22-AE22)>-15,0,AG22-AE22)____$¥N/AIF((AG22-AF22)>-15,0,AG22-AF22)____& "|/A'¢BEAN21+52-AF2(p3)¢BEAP21+52-AF2*p4+¢BEAR21+52-AF2,p4-¢BEAT21+52-AF2.p6/¢BEAV21+52-AF20p81¢BEAX21+52-AF22p103¢BEAZ21+52-AF24p135¢BEBB21+52-AF26p12p3000" |P25P45£@B LOOKUP(C11,T18:T30)¤IF((E23-C23)>-15,0,E23-C23)¤Â%IF((E23-D23)>-15,0,E23-D23)  "| ¢BPL22+53-D23) p4 ¢BPN22+53-D23)p5¢BPP22+53-D23)p5¢BPR22+53-D23)p10¢BPT22+53-D23)p15¢BPV22+53-D23)p21¢BPX22+53-D23)p24¢BPZ22+53-D23)p24p3000" |P25P20 ¤@BLOOKUP(AE11,AV18:AV29)D23)#¥IF((AG23-AE23)>-15,0,AG23-AE23)____$¥IF((AG23-AF23)>-15,0,AG23-AF23)____& "|'¢BPAN22+53-AF2(p4)¢BPAP22+53-AF2*p5+¢BPAR22+53-AF2,p6-¢BPAT22+53-AF2.p8/¢BPAV22+53-AF20p111¢BPAX22+53-AF22p133¢BPAZ22+53-AF24p175¢BPBB22+53-AF26p16p4000" |P25P25£B&LOOKUP(C11,V18:V30)¤IF((E24-C24)>-15,0,E24-C24)¤IF((E24-D24)>-15,0,E24-D24)  "| ¢BUL23+54-D24) p6 ¢BUN23+54-D24)p7¢BUP23+54-D24)p7¢BUR23+54-D24)p13¢BUT23+54-D24)p20¢BUV23+54-D24)p26¢BUX23+54-D24)p30¢BUZ23+54-D24)p31p4000" |P35P20 ¤B!LOOKUP(AE11,AX18:AX29)D24)#¥IF((AG24-AE24)>-15,0,AG24-AE24)____$¥IF((AG24-AF24)>-15,0,AG24-AF24)____& "|'¢BUAN23+54-AF2(p6)¢BUAP23+54-AF2*p7+¢BUAR23+54-AF2,p8-¢BUAT23+54-AF2.p11/¢BUAV23+54-AF20p141¢BUAX23+54-AF22p173¢BUAZ23+54-AF24p225¢BUBB23+54-AF26p22p6000" |P20P25£B0LOOKUP(C11,X18:X30)¤IF((E25-C25)>-15,0,E25-C25)¤IF((E25-D25)>-15,0,E25-D25)  "| ¢B`L24+55-D25) p8 ¢B`N24+55-D25)p9¢B`P24+55-D25)p9¢B`R24+55-D25)p17¢B`T24+55-D25)p25¢B`V24+55-D25)p31¢B`X24+55-D25)p37¢B`Z24+55-D25)p39p6000" |P45P45 ¤B'LOOKUP(AE11,AZ18:AZ29)D25)#¥ÂIF((AG25-AE25)>-15,0,AG25-AE25)____$¥ÂIF((AG25-AF25)>-15,0,AG25-AF25)____& "|'¢B`AN24+55-AF2(p8)¢B`AP24+55-AF2*p9+¢B`AR24+55-AF2,p10-¢B`AT24+55-AF2.p14/¢B`AV24+55-AF20p171¢B`AX24+55-AF22p213¢B`AZ24+55-AF24p275¢B`BB24+55-AF26p29p8000" |P25P20£B1LOOKUP(C11,Z18:Z30)¤IF((E26-C26)>-15,0,E26-C26)¤IF((E26-D26)>-15,0,E26-D26)  "| ¢BeL25+56-D26) p10 ¢BeN25+56-D26)p12¢BeP25+56-D26)p12¢BeR25+56-D26)p22¢BeT25+56-D26)p31¢BeV25+56-D26)p37¢BeX25+56-D26)p44¢BeZ25+56-D26)p48p8000" |P50P40 ¤B)LOOKUP(AE11,BB18:BB29)D26)#¥Â!IF((AG26-AE26)>-15,0,AG26-AE26)____$¥IF((AG26-AF26)>-15,0,AG26-AF26)____& "|'¢BeAN25+56-AF2(p10)¢BeAP25+56-AF2*p11+¢BeAR25+56-AF2,p12-¢BeAT25+56-AF2.p17/¢BeAV25+56-AF20p211¢BeAX25+56-AF22p263¢BeAZ25+56-AF24p335¢BeBB25+56-AF26p37 '_  "| ¢BpL26+56-AF2 p13 ¢BpN26+56-AF2p15¢BpP26+56-AF2p15¢BpR26+56-AF2p27¢BpT26+56-AF2p37¢BpV26+56-AF2p44¢BpX26+56-AF2p51¢BpZ26+56-AF2p58 '_& "|'¢BpAN26+56-AF2(p13)¢BpAP26+56-AF2*p14+¢BpAR26+56-AF2,p15-¢BpAT26+56-AF2.p21/¢BpAV26+56-AF20p261¢BpAX26+56-AF22p313¢BpAZ26+56-AF24p395¢BpBB26+56-AF26p46#"* not accurate above 85 yrs.  "|not ¢BuL27+56-AF2 p16 ¢BuN27+56-AF2p18¢BuP27+56-AF2p19¢BuR27+56-AF2p33¢BuT27+56-AF2p44¢BuV27+56-AF2p51¢BuX27+56-AF2p59¢BuZ27+56-AF2p68#"* not accurate above 85 yrs.& "|not'¢BuAN27+56-AF2(p16)¢BuAP27+56-AF2*p17+¢BuAR27+56-AF2,p18-¢BuAT27+56-AF2.p25/¢BuAV27+56-AF20p311¢BuAX27+56-AF22p373¢BuAZ27+56-AF24p465¢BuBB27+56-AF26p57  "| ¢B€L28+56-AF2 p19 ¢B€N28+56-AF2p22¢B€P28+56-AF2p23¢B€R28+56-AF2p40¢B€T28+56-AF2p52¢B€V28+56-AF2p59¢B€X28+56-AF2p67¢B€Z28+56-AF2p80& "|'¢B€AN28+56-AF2(p20)¢B€AP28+56-AF2*p21+¢B€AR28+56-AF2,p22-¢B€AT28+56-AF2.p29/¢B€AV28+56-AF20p361¢B€AX28+56-AF22p443¢B€AZ28+56-AF24p535¢B€BB28+56-AF26p69'" The pairs of columns above, for your left and right ear,ÏÏÏ  "|he p85he ¡N/ANA8 p85/A¡N/ANA8p85/A¡N/ANA8p85/A¡N/ANA8p85/A¡N/ANA8p85/A¡N/ANA8p85/A¡N/ANA8p85/A¡N/ANA8'" The pairs of columns above, for your left and right ear,ÏÏÏ& "|he 'p85he (¡N/ANA8)p85/A*¡N/ANA8+p85/A,¡N/ANA8-p85/A.¡N/ANA8/p85/A0¡N/ANA81p85/A2¡N/ANA83p85/A4¡N/ANA85p85/A6¡N/ANA8'" tell you two things: on the left are the actual readingsÏÏÏ  "|ell'" tell you two things: on the left are the actual readingsÏÏÏ& "|ell'" for your hearing loss at each frequency, uncorrected.gsÏÏÏ  "|or '" for your hearing loss at each frequency, uncorrected.gsÏÏÏ& "|or '" On the right, is an interpretation of whether your lossÏÏÏ "|n t '" On the right, is an interpretation of whether your lossÏÏÏ& "|n t!&" is greater than predicted for your age and sex.ur l ! "|s g!&" is greater than predicted for your age and sex.ur l&! "|s g " "|s g&" "|s g#'" A zero means you are either better than predicted, orsÏÏÏ # "| ze#'" A zero means you are either better than predicted, orsÏÏÏ&# "| ze$&" that the loss is within 15 dB of predicted, and soo $ "|hat$&" that the loss is within 15 dB of predicted, and soo&$ "|hat%'" not significant. A loss greater than 20 dB will need toÏÏÏ % "|ot %'" not significant. A loss greater than 20 dB will need toÏÏÏ&% "|ot &&" be checked by a further more detailed audiogram.eed & "|e c&&" be checked by a further more detailed audiogram.eed&& "|e c ' "|e c&' "|e c ( "|e c&( "|e c)"****************************************diog*%"copyright P. Dodwell: This SC template*diog+%"may be freely used and copied, provideddiog,#"its origin is acknowledged.d-"****************************************diog- '_***'- '_*** <"|*** <‚APL60+56-AF2 -15,0,E19-C19) Sï here¬  mù formulá meanó thaô iæ thå  person'ó hearinç   foò  thaô  frequencù  ió  BETTEÒ  thaî predicteä  (á pluó value© oò aô leasô  NÏ  WORSÅ THAΠ -1µ (d belo÷ predicted)¬  theî á zerï  ió printeä  (Exp2)»   Iæ  iô  IÓ  WORSE¬  theî  thå differencå  froí  predicteä ió printeä  (aó  haó happeneä iî celì I23). Thereº  althougè iô tooë á loô oæ words¬ É thinë yoõ  wilì  seå  thaô  thå  taskó  involveä  werå essentiallù  simplå  anä  boring®  Á  repetitivå lookuð involvinç largå tables® Iô deserveä tï bå 'Supeä  up'®  É aí surå thaô yoõ wilì bå ablå tï thinë  oæ á similaò fairlù simplå uså oæ Sà aó á practicå piece® Whaô abouô á financiaì one¬ sucè aó  á  Statemenô oæ Positioî foò  youò  proposeä Šmortgagor¿ I'lì beô THAÔ strikeó á familiaò notå tï manù oæ you¡  Thaô ió á prograí É finä myselæ periodicallù re-using¬ anä iô takeó á loô oæ thå irritatioî  ouô  oæ  thaô  chore¬   tï  havå   á spreadsheeô thaô automaticallù recalculateó wheî É  finä  onå  morå  erroò oò  omissioî  froí  mù balancå sheet®  Then¬  wheî É thinë I'vå goô  iô right¬  É SAVÅ thå currenô version®  And¬ wheî É finä  thå Ntè omissioî nexô week¬  É caî  resumå wherå É lefô off. Peter Dodwell January 1985 CROG, New Zealand (Copyright®  Permissioî ió giveî foò thå copyinç anä uså oæ thió Sà applicatioî anä documentatioî provideä  nï  chargå ió made®  Commentó  tï  thå authoò, oî improvementó, arå welcomed) .cp 15 FOOTNOTE: Foò thoså readinç thió froí á disë file¬  É havå economiseä  oî  spacå  bù noô  storinç  separatå fileó  foò Tables¬  excepô foò Tablå ³  (below)® Thå  otheró caî bå simplù printeä ouô (usinç  Sà anä thå filå 'HEARING.CAL'), as follows: BOOÔ youò Sà disë iî Á drive¬  witè thió disë iî B. LOAD 'HEARING'. Now, for... Tablå  1º  follo÷ thå directionó listeä iî  celì A4: i.e... /ODA7:J41SSP (Thå  SSP oò alternatively¬  uså commanä filå M¬ bù issuinç thå following: /XM. Table 3: Display of SC program "HEARING.CAL" Togglå oî thå bordeò displaù (issuå /GB)® Iæ yoõ havå aî 8° columî printer¬ yoõ wilì neeä tï havå condenseä  prinô  OÎ (eitheò  viá  INSTALLS¬  oò usinç á FOÇ prograí sucè aó EPSNPRTR¬  oò  usinç thå  SETUÐ optioî SÓ iî thå commandó above¬  anä enterinç   youò  printer'ó  controì   codå   foò condenseä  prinô  jusô prioò tï thå  )®  Thå onlù   differencå   otherwiså   ió   thå   rangå specified¬ whicè ió A1:AA41. Table 4: CONTENTS OF SC program HEARING.CAL Use this command line: /OCA11:I26P anä  iô  printó  ouô likå  á  BASIà listing®  É printeä iô tï disë anä useä WORDSTAÒ tï tidù it¬ as described in the text, by issuing: /OCA11:I26DHEARCONT and then printed it using WS. ================================================================= Š Table 2: CONTENTS OF SC FILE "M" Thå actuaì Sà filå contentó appeaò below¬  afteò thå doublå line.  Thió  commanä filå ió useä tï prinô parô  oæ  SC prograí "HEARING"; -iô ió executeä bù loadinç ¦ runninç "HEARING"» -wheî   readù  tï  print¬   yoõ  thå  typå   thå following: /X  [yoõ  arå  promptedº   (EXECUTE© Enteò Filå Namå ] M. [youò filenamå MUSÔ enä iî ".¢ ] [youò  filå no÷ getó executeä aó below] ================================================================= /ODA7:J41 SS P    thå   rangå specified¬ whicè ió A1:AA41. Table 4: CONTENTS OF SC program HEARING.CAL Use this command line: /OCA11:I26P anä  iô  printó  ouô likå  á  BASIà listing®  É printeä iô tï disë anä useä WORDSTAÒ tï tidù it¬ as described in the text, by issuing: /OCA11:I26DHEARCONT and then printed it using WS. ================================================================= Š Table 2: CONTENTS OF SC FILE "M" Thå actuaì Sà filå contentó appeaò below¬  afteò thå doublå line. Table 1: Printout for each player PREDICTION TABLE FOR HEARING LOSS WITH AGE NAME:CITIZEN,John * MALE NUMBER: AGE GROUP: 55 to 59 yrs * DATE:15/11/84 __________________________________________________________ FREQ- | ACTUAL Predicted DIFFERENCE,Actual ENCY | LOSS LOSS from Predicted (Hz) (dB) (dB) ________________________________________________________ | LEFT RIGHT LEFT RIGHT | 250 | N/A N/A 6 N/A N/A 500 | N/A N/A 7 N/A N/A 1000 | N/A N/A 7 N/A N/A 2000 | N/A N/A 13 N/A N/A 3000 | 25 45 20 0 -25  4000 | 25 25 26 0 0 6000 | 20 25 30 0 0 8000 | 25 20 31 0 0 ________________________________________________________ * not accurate above 85 yrs. The pairs of columns above, for your left and right ear tell you two things: on the left are the actual reading for your hearing loss at each frequency, uncorrected. On the right, is an interpretation of whether your loss is greater than predicted for your age and sex. A zero means you are either better than predicted, or that the loss is within 15 dB of predicted, and so not significant. A loss greater than 20 dB will need to be checked by a further more detailed audiogram.  Table 2: CONTENTS OF SC FILE "M" Thå actuaì Sà filå contentó appeaò below¬ afteò thå doublå line. Thió   commanä  filå  ió  useä  tï  prinô  parô  oæ  Sà  prograí "HEARING.CAL"; -iô ió executeä bù loadinç ¦ runninç "HEARING.CAL"» -wheî readù tï print¬ yoõ theî typå thå following: /X  [yoõ  arå  promptedº   (EXECUTE© Enteò Filå Namå ] M. [youò filenamå MUSÔ enä iî ".¢ ] [youò  filå no÷ getó executeä aó below] ================================================================= /ODA7:J41 SS P ååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååTable 3: (part) DISPLAY OF SC FILE HEARING.CAL .dm YOU MAY NEED TO SET TO COMPRESSED PRINT HERE .DM BY REPLACING THE CONTROL CODE ^E  .rm 128 ..  | A || B|| C ||D|| E || F ||G|| H || I || J | | L || M|| N|| O|| P|| Q|| R|| S|| T|| U|| V|| W|| X|| Y|| Z||AA| 1|PREDICTION TABLE FOR HEARING LOSS WITH AGE Enter AGE GROUP as either 25,30,35 etc. DO NOT 2|FOR FEMALES, jump to cell AC7 use 20 or less (not available in tables)... 3| by pressing: =AC7 instead, insert 25 for anyone younger, since 4| ...more about age groups-> the difference is trivial. 5|PRINTOUT: /O D A7:J41 SS P (FULL DOCUMENTATION IN FILE: HEARING.DOC) 6|---------------------------------------------------------------------------------------------------------------------------------- 7|PREDICTION TABLE FOR HEARING LOSS WITH AGE (based on the method described adapted for SUPERCALC 8| by SPOOR, A; in by Dr Peter Dodwell 9| NAME:CITIZEN,John * MALE PRESBYCUSIS VALUES IN RELATION Dept of Health, 10| NUMBER: TO NOISE INDUCED HEARING LOSS Box 5013, 11|AGE GROUP: 55 to 59 yrs * DATE:15/11/84 Int. Aud. (1967); 6:48-57 Wellington, New Zealand. 12|____________________________________________________________________________________________________________________________ 13|FREQ- | ACTUAL Predicted DIFFERENCE,Actual | AGE GP PV 14|ENCY | LOSS LOSS from Predicted |  250 500 1000 2000 3000 4000 6000 8000 15| (Hz) (dB) (dB) 16|________________________________________________________| __________________________________________________________________ 17| | LEFT RIGHT LEFT RIGHT 18| | | 25 0 25 0 25 0 25 0 25 1 25 1 25 2 25 1 19| 250 | N/A N/A 6 N/A N/A | 30 0 30 0 30 0 30 1 30 3 30 4 30 5 30 4 20| 500 | N/A N/A 7 N/A N/A | 35 1 35 1 35 1 35 3 35 5 35 7 35 9 35 8 21| 1000 | N/A N/A 7 N/A N/A | 40 2 40 2 40 2 40 5 40 8 40 11 40 14 40 13 22| 2000 | N/A N/A 13 N/A N/A  | 45 3 45 3 45 3 45 7 45 11 45 16 45 19 45 18 23| 3000 | 25 45 20 0 -25 | 50 4 50 5 50 5 50 10 50 15 50 21 50 24 50 24 24| 4000 | 25 25 26 0 0 | 55 6 55 7 55 7 55 13 55 20 55 26 55 30 55 31 25| 6000 | 20 25 30 0 0 | 60 8 60 9 60 9 60 17 60 25 60 31 60 37 60 39 26| 8000 | 25 20 31 0 0 | 65 10 65 12 65 12 65 22 65 31 65 37 65 44 65 48 27|________________________________________________________| 70 13 70 15 70 15 70 27 70 37 70 44 70 51 70 58 28|* not accurate above 85 yrs. | 75 16 75 18 75 19 75 33 75 44 75 51 75 59 75 68 29| | 80 19 80 22 80 23 80 40 80 52 80 59 80 67 80 80 30| The pairs of columns above, for your left and right ear| 85 N/A 85 N/A 85 N/A 85 N/A 85 N/A 85 N/A 85 N/A 85 N/A 31| tell you two things: on the left are the actual reading| 32| for your hearing loss at each frequency, uncorrected. | 33| On the right, is an interpretation of whether your loss| 34| is greater than predicted for your age and sex. | 35| | 36| A zero means you are either better than predicted, or | 37| that the loss is within 15 dB of predicted, and so | 38| not significant. A loss greater than 20 dB will need to| 39| be checked by a further more detailed audiogram. | 40| | 41| | edicted for your age and sex. | 35| | 36| A zero means you are either better than predicted, or | 37| that the loss is within 15 dB of predicted, and so | 38| not signif.FO HEARING.DOC Table 4: SuperCalc ver. 1.12 partial contents of file HEARING.CAL PREDICTION TABLE FOR HEARING LOSS WITH AGE .LM 7 A11 P= "AGE GROUP:/p C11 RI = 55 D11 P= " to E11 L P= C11+4 F11 P= "yrs G11 = "* H11 P= "DATE: I11 = "15/11/84 A12 P= '_ A13 P= "FREQ- B13 P= " | C13 P= " ACTUAL E13 P= "Predicted G13 P= "DIFFERENCE,Actual A14 P= "ENCY B14 P= " | C14 P= " LOSS E14 P= " LOSS G14 P= " from Predicted A15 P= " (Hz) C15 P= " (dB) E15 P= " (dB) A16 P= '_ B17 = " | C17 P= "LEFT D17 P= "RIGHT H17 P= "LEFT I17 P= "RIGHT B18 = " | A19 P= 250 B19 = " |  C19 P= NA D19 P= NA E19 R P= LOOKUP(C11,L18:L30) H19 P= IF((E19-C19)>-15,0,E19-C19) I19 P= IF((E19-D19)>-15,0,E19-D19) .PA Š .RM 111 .LM 60 A20 P= 500 B20 = " | C20 P= NA D20 P= NA E20 R P= LOOKUP(C11,N18:N30) H20 P= IF((E20-C20)>-15,0,E20-C20) I20 P= IF((E20-D20)>-15,0,E20-D20) A21 P= 1000 B21 = " | C21 P= NA D21 P= NA E21 R P= LOOKUP(C11,P18:P30) H21 P= IF((E21-C21)>-15,0,E21-C21) I21 P= IF((E21-D21)>-15,0,E21-D21) A22 P= 2000 B22 = " | C22 P= NA D22 P= NA E22 R P= LOOKUP(C11,R18:R30) H22 P= IF((E22-C22)>-15,0,E22-C22) I22 P= IF((E22-D22)>-15,0,E22-D22) A23 P= 3000 B23 = " | C23 = 25 D23 = 45 E23 R P= LOOKUP(C11,T18:T30) H23 P= IF((E23-C23)>-15,0,E23-C23) I23 P= IF((E23-D23)>-15,0,E23-D23) A24 P= 4000 B24 = " | C24 = 25 D24 = 25 E24 P= LOOKUP(C11,V18:V30) H24 P= IF((E24-C24)>-15,0,E24-C24) I24 P= IF((E24-D24)>-15,0,E24-D24) A25 P= 6000 B25 = " | C25 = 20 D25 = 25 E25 P= LOOKUP(C11,X18:X30) H25 P= IF((E25-C25)>-15,0,E25-C25) ŠI25 P= IF((E25-D25)>-15,0,E25-D25) A26 P= 8000 B26 = " | C26 = 25 D26 = 20 E26 P= LOOKUP(C11,Z18:Z30) H26 P= IF((E26-C26)>-15,0,E26-C26) I26 P= IF((E26-D26)>-15,0,E26-D26) 21-C21)>-15,0,E21-C21) I21 P= IF((E21-D21)>-15,0,E21-D21) A22 P= 2000 B22 = " | C22 P= NA D22 P= NA E22 R P= LOOKUP(C11,R18:R30) H22 P= IF((E22-C22)>-15,0,E22-C22) I22 P= IF((E22-D22)>-15,0,E22-D22) A23 P= 3000 B23 = " | C23 = 25 D23 = 45 E23 R P= LOOKUP(C11,T18:T30) H23 P= IF((E23-C23)>-15,0,E23-C23) I23 P= IF((E23-D23)>-15,0,E23-D23) A24 P= 4000 B24 = " | C24 = 25 D24 = 25 E24 PSuperCalc ver. 1.00 (COST86/M) 1986 INCOMES & EXPENSES PER MONTH for _______________________ÏÏÏ ""ˆ" # "$$  P:ÿÿ          )"(COST86/M) 1986 INCOMES & EXPENSES PER MONTH for _______________________ÏÏÏ!"(COST86/M) 1("TODAY'S DATE: =============PRINTING INSTRUCTIONS----->___""first output=A1:Q88 ""TODAY'S DATE:1:Q88 %"QUARTERLY REPORT of INCOMES & EXPENSESRINTINbˆE1!TODAY.00 ""second output=O1:U88bˆE1!TODAY.00 "LAST:(CHK.# ????) 00/00/86 & '-ST: '-ST:""INCOME CATEGORY) 00/ "||OM!"JANUARYATEGO!"FEBRUARYTEGO!"MARCHRYTEGO!"APRILRYTEGO "MAYL "JUNE "JULY !"AUGUSTYTEGO !"SEPTEMBEREGO !"OCTOBERREGO !"NOVEMBEREGO !"DECEMBEREGO!"TOTALSREGO""INCOME CATEGORY) 00/!"QRT 1 CATEGO!"QRT 2 CATEGO!"QRT 3 CATEGO!"QRT 4 CATEGO '-T 4 '-T 4#" SALARY/BUSINESS INCOME & "||SA#" SALARY/BUSINESS INCOME &¢ SUM(C8:E8) ¢ SUM(F8:H8) ¢ SUM(I8:K8) ¢ SUM(L8:N8) "1. "||P2000¢ D SUM(B9:N9)  "1.¢ D SUM(C9:E9) ¢ SUM(F9:H9) ¢ SUM(I9:K9) ¢ SUM(L9:N9) "2. "|| BC 100+1009)  £ C SUM(B10:N10)INESS I "2. £ C SUM(C10:E10)INESS I £ SUM(F10:H10)INESS I £ SUM(I10:K10)INESS I £ SUM(L10:N10)INESS I "3. "|| CC0100+50+50+100NESS I £ C0SUM(B11:N11)NESS I "3. £ C0SUM(C11:E11)NESS I £ SUM(F11:H11)NESS I £ SUM(I11:K11)NESS I £ SUM(L11:N11)NESS I "4. "|| P10 £ BSUM(B12:N12)NESS I £ BSUM(C12:E12)NESS I £ SUM(F12:H12)NESS I £ SUM(I12:K12)NESS I £ SUM(L12:N12)NESS I "" INTERST EARNINGS "|| I "" INTERST EARNINGS £ SUM(C13:E13)NESS I £ SUM(F13:H13)NESS I £ SUM(I13:K13)NESS I £ SUM(L13:N13)NESS I "1. "|| £ SUM(B14:N14)NESS I "1. £ SUM(C14:E14)NESS I £ SUM(F14:H14)NESS I £ SUM(I14:K14)NESS I £ SUM(L14:N14)NESS I"2. "||£ SUM(B15:N15)NESS I "2.£ SUM(C15:E15)NESS I£ SUM(F15:H15)NESS I£ SUM(I15:K15)NESS I£ SUM(L15:N15)NESS I"3. "||£ SUM(B16:N16)NESS I "3.£ SUM(C16:E16)NESS I£ SUM(F16:H16)NESS I£ SUM(I16:K16)NESS I£ SUM(L16:N16)NESS I"4. "||£ SUM(B17:N17)NESS I "4.£ SUM(C17:E17)NESS I£ SUM(F17:H17)NESS I£ SUM(I17:K17)NESS I£ SUM(L17:N17)NESS I"5. "||£ SUM(B18:N18)NESS I£ SUM(C18:E18)NESS I£ SUM(F18:H18)NESS I£ SUM(I18:K18)NESS I£ SUM(L18:N18)NESS I#" SECURITIES--DIVIDENDS & "|| S#" SECURITIES--DIVIDENDS &£ SUM(C19:E19)NESS I£ SUM(F19:H19)NESS I£ SUM(I19:K19)NESS I£ SUM(L19:N19)NESS I"1. "||£ SUM(B20:N20)NESS I "1.£ SUM(C20:E20)NESS I£ SUM(F20:H20)NESS I£ SUM(I20:K20)NESS I£ SUM(L20:N20)NESS I"2. "||£ SUM(B21:N21)NESS I "2.£ SUM(C21:E21)NESS I£ SUM(F21:H21)NESS I£ SUM(I21:K21)NESS I£ SUM(L21:N21)NESS I"3. "||£ SUM(B22:N22)NESS I "3.£ SUM(C22:E22)NESS I£ SUM(F22:H22)NESS I£ SUM(I22:K22)NESS I£ SUM(L22:N22)NESS I"4. "||£ SUM(B23:N23)NESS I "4.£ SUM(C23:E23)NESS I£ SUM(F23:H23)NESS I£ SUM(I23:K23)NESS I£ SUM(L23:N23)NESS I"5. "||£ SUM(B24:N24)NESS I "5.£ SUM(C24:E24)NESS I£ SUM(F24:H24)NESS I£ SUM(I24:K24)NESS I£ SUM(L24:N24)NESS I"6. "||£ SUM(B25:N25)NESS I£ SUM(C25:E25)NESS I£ SUM(F25:H25)NESS I£ SUM(I25:K25)NESS I£ SUM(L25:N25)NESS I#" MONEY FUNDS-DIVIDENDS & "||MO#" MONEY FUNDS-DIVIDENDS &£ SUM(C26:E26)NESS I£ SUM(F26:H26)NESS I£ SUM(I26:K26)NESS I£ SUM(L26:N26)NESS I"1. "||£ SUM(B27:N27)NESS I "1.£ SUM(C27:E27)NESS I£ SUM(F27:H27)NESS I£ SUM(I27:K27)NESS I£ SUM(L27:N27)NESS I"2. "||£ SUM(B28:N28)NESS I "2.£ SUM(C28:E28)NESS I£ SUM(F28:H28)NESS I£ SUM(I28:K28)NESS I£ SUM(L28:N28)NESS I"3. "||£ SUM(B29:N29)NESS I "3.£ SUM(C29:E29)NESS I£ SUM(F29:H29)NESS I£ SUM(I29:K29)NESS I£ SUM(L29:N29)NESS I"4. "||£ SUM(B30:N30)NESS I "4.£ SUM(C30:E30)NESS I£ SUM(F30:H30)NESS I£ SUM(I30:K30)NESS I£ SUM(L30:N30)NESS I"5. "||£ SUM(B31:N31)NESS I£ SUM(C31:E31)NESS I£ SUM(F31:H31)NESS I£ SUM(I31:K31)NESS I£ SUM(L31:N31)NESS I#" TAX-EXEMPT INCOMEDS & "|| T£ SUM(B32:N32)NESS I#" TAX-EXEMPT INCOMEDS &£ SUM(C32:E32)NESS I£ SUM(F32:H32)NESS I£ SUM(I32:K32)NESS I£ SUM(L32:N32)NESS I "1. "|| £ SUM(B33:N33)NESS I "1. £ SUM(C33:E33)NESS I £ SUM(F33:H33)NESS I £ SUM(I33:K33)NESS I £ SUM(L33:N33)NESS I!"2.! "||!£ SUM(B34:N34)NESS I! "2.!£ SUM(C34:E34)NESS I!£ SUM(F34:H34)NESS I!£ SUM(I34:K34)NESS I!£ SUM(L34:N34)NESS I""3." "||"£ SUM(B35:N35)NESS I" "3."£ SUM(C35:E35)NESS I"£ SUM(F35:H35)NESS I"£ SUM(I35:K35)NESS I"£ SUM(L35:N35)NESS I#"4.# "||#£ SUM(B36:N36)NESS I# "4.#£ SUM(C36:E36)NESS I#£ SUM(F36:H36)NESS I#£ SUM(I36:K36)NESS I#£ SUM(L36:N36)NESS I$"5.$ "||$£ SUM(B37:N37)NESS I$ "5.$£ SUM(C37:E37)NESS I$£ SUM(F37:H37)NESS I$£ SUM(I37:K37)NESS I$£ SUM(L37:N37)NESS I%"6.% "||%£ SUM(B38:N38)NESS I% % % % &#" ALL NONRECURRING INCOME&& "|| A&#" ALL NONRECURRING INCOME&&£ SUM(C39:E39)NESS I&£ SUM(F39:H39)NESS I&£ SUM(I39:K39)NESS I&£ SUM(L39:N39)NESS I'"1.' "||'£ SUM(B40:N40)NESS I' "1.'£ SUM(C40:E40)NESS I'£ SUM(F40:H40)NESS I'£ SUM(I40:K40)NESS I'£ SUM(L40:N40)NESS I("2.( "||(£ SUM(B41:N41)NESS I( "2.(£ SUM(C41:E41)NESS I(£ SUM(F41:H41)NESS I(£ SUM(I41:K41)NESS I(£ SUM(L41:N41)NESS I)"3.) "||)£ SUM(B42:N42)NESS I) "3.)£ SUM(C42:E42)NESS I)£ SUM(F42:H42)NESS I)£ SUM(I42:K42)NESS I)£ SUM(L42:N42)NESS I*"4.* "||*£ SUM(B43:N43)NESS I* "4.*£ SUM(C43:E43)NESS I*£ SUM(F43:H43)NESS I*£ SUM(I43:K43)NESS I*£ SUM(L43:N43)NESS I+"5.+ "||+£ SUM(B44:N44)NESS I+ "5.+£ SUM(C44:E44)NESS I+£ SUM(F44:H44)NESS I+£ SUM(I44:K44)NESS I+£ SUM(L44:N44)NESS I,"6., "||,£ SUM(B45:N45)NESS I,£ SUM(C45:E45)NESS I,£ SUM(F45:H45)NESS I,£ SUM(I45:K45)NESS I,£ SUM(L45:N45)NESS I- '-- '-.#"TOTAL PERSONAL INCOME:COME&. "||AL.£D%SUM(C7:C46)NESS I.£SUM(D7:D46)NESS I.£SUM(E7:E46)NESS I.£SUM(F7:F46)NESS I.£SUM(G7:G46)NESS I.£SUM(H7:H46)NESS I.£SUM(I7:I46)NESS I .£SUM(J7:J46)NESS I .£SUM(K7:K46)NESS I .£SUM(L7:L46)NESS I .£SUM(M7:M46)NESS I .£SUM(N7:N46)NESS I.£ D%SUM(B47:N47)NESS I.#"TOTAL PERSONAL INCOME:COME&.£!D%SUM(C47:E47)NESS I.£!SUM(F47:H47)NESS I.£!SUM(I47:K47)NESS I.£!SUM(L47:N47)NESS I/ '=/ '=0#"PERSONAL EXPENSE CATEGORYE&0 "||SO0!"JANUARY EXPE0!"FEBRUARYEXPE0!"MARCHRYEXPE0!"APRILRYEXPE0 "MAYL0 "JUNE0 "JULY 0!"AUGUSTYEXPE 0!"SEPTEMBERXPE 0!"OCTOBERRXPE 0!"NOVEMBERXPE 0!"DECEMBERXPE0!"TOTALSRXPE0#"PERSONAL EXPENSE CATEGORYE&0!"QRT 1AL EXPE0!"QRT 2AL EXPE0!"QRT 3AL EXPE0!"QRT 4AL EXPE1 '-T 41 '-T 42""AUTO-GASOLINESE CATE2 "||O-2P10O-2£"BSUM(B51:N51)NESS I2""AUTO-GASOLINE3:3)E2£ BSUM(C51:E51)NESS I2£ SUM(F51:H51)NESS I2£ SUM(I51:K51)NESS I2£ SUM(L51:N51)NESS I3""AUTO-INSURANCE:3)E3 "||O-3P20O-3£"B SUM(B52:N52)NESS I3""AUTO-INSURANCE:4)E3£ B SUM(C52:E52)NESS I3£ SUM(F52:H52)NESS I3£ SUM(I52:K52)NESS I3£ SUM(L52:N52)NESS I4""AUTO-MAINT.& REPAIRS4 "||O-4P30O-4£"B0SUM(B53:N53)NESS I4""AUTO-MAINT.& REPAIRS4£ B0SUM(C53:E53)NESS I4£ SUM(F53:H53)NESS I4£ SUM(I53:K53)NESS I4£ SUM(L53:N53)NESS I5!"ELECTRICITY(5 "||CT5P40CT5£"B@SUM(B54:N54)NESS I5!"ELECTRICITY(5£ B@SUM(C54:E54)NESS I5£ SUM(F54:H54)NESS I5£ SUM(I54:K54)NESS I5£ SUM(L54:N54)NESS I6""ENTERTAINMENT6:6)6 "||ER6P50ER6£"BPSUM(B55:N55)NESS I6""ENTERTAINMENT7:7)6£ BPSUM(C55:E55)NESS I6£ SUM(F55:H55)NESS I6£ SUM(I55:K55)NESS I6£ SUM(L55:N55)NESS I7#"FOOD & HOUSEHOLD SUPPLIESE&7 "||D 7P60D 7£"B`SUM(B56:N56)NESS I7""FOOD & SUPPLIES8)P7£ B`SUM(C56:E56)NESS I7£ SUM(F56:H56)NESS I7£ SUM(I56:K56)NESS I7£ SUM(L56:N56)NESS I8#"INSURANCE--DISABILITYIESE&8 "||UR8P70UR8£"BpSUM(B57:N57)NESS I8#"INSURANCE--DISABILITYIESE&8£ BpSUM(C57:E57)NESS I8£ SUM(F57:H57)NESS I8£ SUM(I57:K57)NESS I8£ SUM(L57:N57)NESS I9""INSURANCE--HEALTH)Y9 "||UR9P80UR9£"B€SUM(B58:N58)NESS I9""INSURANCE--HEALTH)Y9£ B€SUM(C58:E58)NESS I9£ SUM(F58:H58)NESS I9£ SUM(I58:K58)NESS I9£ SUM(L58:N58)NESS I:""INSURANCE--OTHER:)Y: "||UR:P90UR:£"BSUM(B59:N59)NESS I:""INSURANCE--OTHER;)Y:£ BSUM(C59:E59)NESS I:£ SUM(F59:H59)NESS I:£ SUM(I59:K59)NESS I:£ SUM(L59:N59)NESS I;!"LAUNDRYSUM(; "||ND;P100ND;£"CSUM(B60:N60)NESS I;!"LAUNDRYSUM(;£ CSUM(C60:E60)NESS I;£ SUM(F60:H60)NESS I;£ SUM(I60:K60)NESS I;£ SUM(L60:N60)NESS I""MORTGAGE OR RENT>)Y> "||TG>P130TG>£"CSUM(B63:N63)NESS I>#"RENT--438 16TH AVE.SO.ESE&>£ CSUM(C63:E63)NESS I>£ SUM(F63:H63)NESS I>£ SUM(I63:K63)NESS I>£ SUM(L63:N63)NESS I?$"PERSONAL--GROOMING & CLOTHINGEXPENSE? "||SO?P140SO?£"CSUM(B64:N64)NESS I?$"PERSONAL--GROOMING & CLOTHINGEXPENSE?£ CSUM(C64:E64)NESS I?£ SUM(F64:H64)NESS I?£ SUM(I64:K64)NESS I?£ SUM(L64:N64)NESS I@!"POSTAGESUM(@ "||TA@P150TA@£"CSUM(B65:N65)NESS I@!"POSTAGESUM(@£ CSUM(C65:E65)NESS I@£ SUM(F65:H65)NESS I@£ SUM(I65:K65)NESS I@£ SUM(L65:N65)NESS IA#"STORAGE & SAFE DEPOSIT BOXESA "||RAAP160RAA£"CSUM(B66:N66)NESS IA#"STORAGE & SAFE DEPOSIT BOXESA£ CSUM(C66:E66)NESS IA£ SUM(F66:H66)NESS IA£ SUM(I66:K66)NESS IA£ SUM(L66:N66)NESS IB!"TAXES-INCOMEB "||ESBP170ESB£"CSUM(B67:N67)NESS IB""TAXES--INCOMEC:C)IB£ CSUM(C67:E67)NESS IB£ SUM(F67:H67)NESS IB£ SUM(I67:K67)NESS IB£ SUM(L67:N67)NESS IC""TAXES-REAL ESTATE)IC "||ESCP180ESC£"CSUM(B68:N68)NESS IC""LAKELAND--R.E.TAXESIC£ CSUM(C68:E68)NESS IC£ SUM(F68:H68)NESS IC£ SUM(I68:K68)NESS IC£ SUM(L68:N68)NESS ID!"TELEPHONEUM(D "||EPDP190EPD£"CSUM(B69:N69)NESS ID!"TELEPHONEUM(D£ CSUM(C69:E69)NESS ID£ SUM(F69:H69)NESS ID£ SUM(I69:K69)NESS ID£ SUM(L69:N69)NESS IE#"TELEVISION SERVICE (CABLE)SE "||EVEP200EVE£"C SUM(B70:N70)NESS IE!"T.V.SERVICE(E£ C SUM(C70:E70)NESS IE£ SUM(F70:H70)NESS IE£ SUM(I70:K70)NESS IE£ SUM(L70:N70)NESS IF""VACATIONS & TRAVELCF "||ATFP210ATF£"C!SUM(B71:N71)NESS IF""VACATIONS & TRAVELCF£ C!SUM(C71:E71)NESS IF£ SUM(F71:H71)NESS IF£ SUM(I71:K71)NESS IF£ SUM(L71:N71)NESS IG "?G "||GP220G£"C"SUM(B72:N72)NESS IG "?G£ C"SUM(C72:E72)NESS IG£ SUM(F72:H72)NESS IG£ SUM(I72:K72)NESS IG£ SUM(L72:N72)NESS IH "?H "||HP230H£"C#SUM(B73:N73)NESS IH "?H£ C#SUM(C73:E73)NESS IH£ SUM(F73:H73)NESS IH£ SUM(I73:K73)NESS IH£ SUM(L73:N73)NESS II '-I '-J#"PERSONAL EXPENSE TOTALS:)SJ "||SOJ£D'`SUM(C50:C74)NESS IJ£SUM(D50:D74)NESS IJ£SUM(E50:E74)NESS IJ£SUM(F50:F74)NESS IJ£SUM(G50:G74)NESS IJ£SUM(H50:H74)NESS IJ£SUM(I50:I74)NESS I J£SUM(J50:J74)NESS I J£SUM(K50:K74)NESS I J£SUM(L50:L74)NESS I J£SUM(M50:M74)NESS I J£SUM(N50:N74)NESS IJ£D'`SUM(C75:N75)NESS IJ£SUM(P50:P74)NESS IJ#"PERSONAL EXPENSE TOTALS:)SJ£D'`SUM(R50:R74)NESS IJ£SUM(S50:S74)NESS IJ£SUM(T50:T74)NESS IJ£SUM(U50:U74)NESS IK '=K '=L$" Incomes - Expenses for month:XPENSEL¢Ã%C47-C75U74)L¢D47-D75U74)L¢E47-E75U74)L¢F47-F75U74)L¢G47-G75U74)L¢H47-H75U74)L¢I47-I75U74) L¢J47-J75U74) L¢K47-K75U74) L¢L47-L75U74) L¢M47-M75U74) L¢N47-N75U74)L$" Incomes - Expenses for month:XPENSEL¢Ã%R47-R75U74)L¢S47-S75U74)L¢T47-T75U74)L¢U47-U75U74)M$" Incomes - Expenses for year :XPENSEM¢Ã%B78+C77U74)M¢Ã%C78+D77U74)M¢Ã%D78+E77U74)M¢Ã%E78+F77U74)M¢Ã%F78+G77U74)M¢Ã%G78+H77U74)M¢Ã%H78+I77U74) M¢Ã%I78+J77U74) M¢Ã%J78+K77U74) M¢Ã%K78+L77U74) M¢Ã%L78+M77U74) M¢Ã%M78+N77U74)M$" Incomes - Expenses for year :XPENSEM¢Ã%Q78+R77U74)M¢Ã%R78+S77U74)M¢Ã%S78+T77U74)M¢Ã%T78+U77U74)N '=N '=P '*Q"INCOME-TAXABLE INTERESTyear Q "||OMQ£"SUM(B82:N82)NESS IQ"INCOME-TAXABLE INTERESTyear R"INCOME-TAXABLE DIVIDENEDear R "||OMR£"SUM(B83:N83)NESS IR"INCOME-TAXABLE DIVIDENEDear S"INCOME-NON TAXABLE DIV.& INT.XPENSES "||OMS£"SUM(B84:N84)NESS IS"INCOME-NON TAXABLE DIV.& INT.XPENSET"EXPENSE-INTERST PAIDT "||OMT£"SUM(B85:N85)NESS IT"EXPENSE-INTERST PAIDU"EXPENSE-R.E.TAXES+ OU "||ENU£"SUM(B86:N86)NESS IU"EXPENSE-R.E.TAXES)OV"ESTIMATED TAX PAIDOV "||IMV£"SUM(B87:N87)NESS IV"ESTIMATED TAX PAIDOW '*TIM4) M¢Ã%K78+L77U74) M¢Ã%L78+M77U74) M¢Ã%M78+N77U74)M$" Incomes - Expenses for year :XPENSEM¢Ã%Q78+R77U74)M¢Ã%R78+S77U74)M¢Ã%S78+T77U74)M¢Ã%T78+U77U74)N '=N '=P '* COST86/M.CAL ============= August 12, 1985 SUPERCALC 2 APPLICATION by Barry Witt COST86/M.CAL is an application of SC2 that I have found to be a useful aid for tracking income and expense in a form which can quickly give one a picture of his or her personal budget. To print out the first section of the report, you will need a WIDE CARRIAGE PRINTER(set for compressed printing). The quarterly report will work with most printers. The setup for my SC2 program is set for compressed printing, 88 lines per page, width 233. (for those of you new to Supercalc) This program is set: /Title,Both. To move to column A use the command =A1. Obviously, everyone's financial situation is different so I suggest you experiment with this application and come up with one that suits you best. Once you have listed your INCOME AND EXPENSE categories in Column A you can experiment with the application by creating formulas which will reflect items that go on your Federal Tax Returns. I have left space for this at the bottom.  Barry Witt COST86/M.CAL is an application of SC2 that I have found to be a useful aid for tracking income and expense in a form which can quickly give one a picture of his or her personal budget. To print out the first section of the report, you will need a WIDE CARRIAGE PRINTER(set for compressed printing). The quarterly report will work with most printers. The setup for my SC2 program is set for compressed printing, 88 lines per page, width 233. (for those of you new to Supercalc) This program is set: /Title,Both. To move to column A use the command =A1. Obviously, everyone's financial situation is different so I suggest you experiment with this application and come up with one that suits you best. Once yo CASHFAX Copyright (C) March 25, 1986 by Sivert O. Mysse, PO Box 315, Ingomar, MT 59039. The author grants permission to copy this file on a not-for-profit basis, provided that this Copyright notice is not altered or deleted from any copy. No copies of this file may be sold for profit except by the author. For a small business or an agricultural enterprise: You can dï youò bookkeepinç aó yoõ writå youò checkó iæ yoõ assigî numberó tï thå variouó categorieó oæ casè outflow¬ anä codå youò checkó anä check-stubó aó yoõ writå them¬ whilå yoõ stilì remembeò thå details® Ouò banë offereä á similaò servicå tï uó somå yearó back» youò computeò wilì dï thå samå foò yoõ witè SuperCalc² oò SuperCalc³ anä theså programs. Chooså thå programó appropriatå foò you» thå FORM-A.XQÔ program¬ wheî executeä froí thå initiaì SuperCalã emptù spreadsheeô wilì builä á templatå designeä foò sortinç checkó intï á maximuí oæ 5° expenså codå categorieó anä 2° non-expenså casè outflo÷ categories» likewise¬ FORM-B.XQÔ buildó á templatå froí aî emptù spreadsheet¬ foò á maximuí oæ 6° expenså anä 2° non-expenså codå categories» FORM-F.XQÔ buildó á templatå foò á maximuí oæ 11² exenså anä 3´ non-expenså casè outflo÷ categories® Thå FORM-Æ forí provideó thå mosô detaileä accounting¬ buô ió mucè sloweò foò sortinç checkó thaî thå FORM-Á oò thå FORM- forms» uså thå shortesô forí whicè provideó foò youò needó anä á fe÷ sparå accounô numberó foò contingencies» theså formó caî alsï bå useä tï sorô incomå anä non-incomå casè inflo÷ intï codeä accounts® Yoõ caî uså Wordstaò tï changå thå accounô numberó produceä iî Columî Å bù FORM-A.XQÔ (oò FORM-B.XQÔ oò FORM-F.XQT© tï suiô youò needs» thå otheò XQÔ programó refeò tï celì locatioî anä wilì noô bå impaireä aó lonç aó yoõ neitheò deletå noò adä carriagå returns¬ anä don'ô alteò thå locationó useä foò totaló oò repeatinç text® (Uså ^QÆ tï finä "=E4¢ anä thå accounô numberó begiî oî thå followinç line.)  Uså thå shortesô "CF¢ prograí whicè ió adequatå tï handlå thå numbeò oæ youò checë datá entrieó foò thå currenô month» CF-A40.XQÔ sortó á maximuí oæ 4° checë entrieó foò thå templatå produceä bù FORM-A.XQT» CF-B60.XQÔ sortó 6° checë entrieó foò thå templatå produceä bù FORM-B.XQT» CF-F60.XQÔ sortó 6° checë entrieó foò FORM-F.XQT® Thå programó tï sorô 4° entrieó sortó fasteò thaî thå 50¬ 60¬ oò 90-checë programs» yoõ musô uså thå CF-A40¬ CF-A50¬ CF-A6° oò CF-A9° sortinç witè Form-A¬ CF- sortinç witè Form-B¬ anä CF-Æ witè Form-Æ tï geô accuratå results® Iô mighô bå besô tï storå thå "A¢ "B¢ anä "F¢ formó anä sortinç programó oî separatå discó tï avoiä errors. Iô ió intendeä thaô thå templateó formeä bù FORM-Á - oò -F.xqô bå useä aó formó iî whicè tï enteò casè outflo÷ data¬ anä thå CASHFAØ "CF-xxx.XQT¢ programó bå useä tï sorô checkó bù codå numbers® Theså providå á counô oæ thå numbeò oæ entries¬ thå Dollaò Total¬ anä Percentagå oæ Totaì foò eacè codå category® Theù wilì alsï savå thå sorteä anä totaleä datá oî thå samå disc¬ undeò thå samå namå aó whicè thå templatå waó loaded¬ anä savå thå unsorteä datá aó á backuð file® Wheî enterinç datá iî Columnó A¬ B¬ ¦ Cº Checë £ goeó iî Columî Á (oò "DÒ foò Banë charges)¬ youò checë Codå numbeò iî Columî  musô bå onå oæ thå Accounô Codå numberó listeä iî Columî E¬ anä thå amounô goeó iî Columî C® Onå checë numbeò woulä bå listeä morå thaî oncå iæ portionó oæ thå totaì shoulä bå chargeä tï morå thaî onå cash-outflo÷ account¬ buô thå totaì amountó musô equaì thå checë total¬ iæ youò accounô ió tï balance. Wheî yoõ havå entereä alì checkó anä otheò debitó foò thå currenô montè intï youò choseî forí¬ save iô undeò thå namå desireä, zap thå screen¬ and reloaä iô undeò itó correcô filå name® Next¬ iæ yoõ useä thå "F¢ form¬ givå thå ordeò /XA:CF-F40¬ iæ thå CASHFAØ CF-F40.XQÔ prograí ió oî thå "A¢ drivå (oò /XB:CF-F400),1,0) /RF4,F5:F43,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A43),I4) /RI4,I5:I53,ANYNNNY=I55 IF(OR(B4=G53,B4=0),SUM(I3:I54),I55) =I57 IF(OR(B4=G57,B4=0),SUM(A4:A43),I57) /RI57,I58:I76,ANYNNNY=I78 IF(OR(B4=G76,B4=0),SUM(I56:I77),I78) =I80 I55+I78 =A4 IF(B4=D4,E4,0) /RA4,A5:A43,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =C3 '= /BA4:B43 /BF4:F43 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I55>0,(100*I4/I55),0) /RJ4,J5:J53,ANYN=J55 SUM(J3:J54) =J57 IF(I78>0,(100*I57/I78),0) /RJ57,J58:J76,ANYN=J78 SUM(J56:J77) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV /GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(F4:F53),H4) /RH4,H5:H53,ANYNNNY=H55 IF(OR(B4=G53,B4=0),SUM(H3:H54),H55) =H57 IF(OR(B4=G57,B4=0),SUM(F4:F53),H57) /RH57,H58:H76,ANYNNNY=H78 IF(OR(B4=G76,B4=0),SUM(H56:H77),H78) =H80 H55+H78 =F4 IF(AND(B4=D4,B4>0),1,0) /RF4,F5:F53,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A53),I4) /RI4,I5:I53,ANYNNNY=I55 IF(OR(B4=G53,B4=0),SUM(I3:I54),I55) =I57 IF(OR(B4=G57,B4=0),SUM(A4:A53),I57) /RI57,I58:I76,ANYNNNY=I78 IF(OR(B4=G76,B4=0),SUM(I56:I77),I78) =I80 I55+I78 =A4 IF(B4=D4,E4,0) /RA4,A5:A53,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =C3 '= /BA4:B53 /BF4:F53 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I55>0,(100*I4/I55),0) /RJ4,J5:J53,ANYN=J55 SUM(J3:J54) =J57 IF(I78>0,(100*I57/I78),0) /RJ57,J58:J76,ANYN=J78 SUM(J56:J77) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV /GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(F4:F63),H4) /RH4,H5:H53,ANYNNNY=H55 IF(OR(B4=G53,B4=0),SUM(H3:H54),H55) =H57 IF(OR(B4=G57,B4=0),SUM(F4:F63),H57) /RH57,H58:H76,ANYNNNY=H78 IF(OR(B4=G76,B4=0),SUM(H56:H77),H78) =H80 H55+H78 =F4 IF(AND(B4=D4,B4>0),1,0) /RF4,F5:F63,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A63),I4) /RI4,I5:I53,ANYNNNY=I55 IF(OR(B4=G53,B4=0),SUM(I3:I54),I55) =I57 IF(OR(B4=G57,B4=0),SUM(A4:A63),I57) /RI57,I58:I76,ANYNNNY=I78 IF(OR(B4=G76,B4=0),SUM(I56:I77),I78) =I80 I55+I78 =A4 IF(B4=D4,E4,0) /RA4,A5:A63,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =C3 '= /BA4:B63 /BF4:F63 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I55>0,(100*I4/I55),0) /RJ4,J5:J53,ANYN=J55 SUM(J3:J54) =J57 IF(I78>0,(100*I57/I78),0) /RJ57,J58:J76,ANYN=J78 SUM(J56:J77) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV /GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(F4:F93),H4) /RH4,H5:H53,ANYNNNY=H55 IF(OR(B4=G53,B4=0),SUM(H3:H54),H55) =H57 IF(OR(B4=G57,B4=0),SUM(F4:F93),H57) /RH57,H58:H76,ANYNNNY=H78 IF(OR(B4=G76,B4=0),SUM(H56:H77),H78) =H80 H55+H78 =F4 IF(AND(B4=D4,B4>0),1,0) /RF4,F5:F93,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A93),I4) /RI4,I5:I53,ANYNNNY=I55 IF(OR(B4=G53,B4=0),SUM(I3:I54),I55) =I57 IF(OR(B4=G57,B4=0),SUM(A4:A93),I57) /RI57,I58:I76,ANYNNNY=I78 IF(OR(B4=G76,B4=0),SUM(I56:I77),I78) =I80 I55+I78 =A4 IF(B4=D4,E4,0) /RA4,A5:A93,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =C3 '= /BA4:B93 /BF4:F93 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I55>0,(100*I4/I55),0) /RJ4,J5:J53,ANYN=J55 SUM(J3:J54) =J57 IF(I78>0,(100*I57/I78),0) /RJ57,J58:J76,ANYN=J78 SUM(J56:J77) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV /GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(F4:F43),H4) /RH4,H5:H63,ANYNNNY=H65 IF(OR(B4=G63,B4=0),SUM(H3:H64),H65) =H67 IF(OR(B4=G67,B4=0),SUM(F4:F43),H67) /RH67,H68:H86,ANYNNNY=H88 IF(OR(B4=G86,B4=0),SUM(H66:H87),H88) =H90 H65+H88 =F4 IF(AND(B4=D4,B4>0),1,0) /RF4,F5:F43,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A43),I4) /RI4,I5:I63,ANYNNNY=I65 IF(OR(B4=G63,B4=0),SUM(I3:I64),I65) =I67 IF(OR(B4=G67,B4=0),SUM(A4:A43),I67) /RI67,I68:I86,ANYNNNY=I88 IF(OR(B4=G86,B4=0),SUM(I66:I87),I88) =I90 I65+I88 =A4 IF(B4=D4,E4,0) /RA4,A5:A43,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B43 /BF4:F43 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV  =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B43 /BF4:F43 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,/GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(F4:F53),H4) /RH4,H5:H63,ANYNNNY=H65 IF(OR(B4=G63,B4=0),SUM(H3:H64),H65) =H67 IF(OR(B4=G67,B4=0),SUM(F4:F53),H67) /RH67,H68:H86,ANYNNNY=H88 IF(OR(B4=G86,B4=0),SUM(H66:H87),H88) =H90 H65+H88 =F4 IF(AND(B4=D4,B4>0),1,0) /RF4,F5:F53,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A53),I4) /RI4,I5:I63,ANYNNNY=I65 IF(OR(B4=G63,B4=0),SUM(I3:I64),I65) =I67 IF(OR(B4=G67,B4=0),SUM(A4:A53),I67) /RI67,I68:I86,ANYNNNY=I88 IF(OR(B4=G86,B4=0),SUM(I66:I87),I88) =I90 I65+I88 =A4 IF(B4=D4,E4,0) /RA4,A5:A53,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B53 /BF4:F53 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV  =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B53 /BF4:F53 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,/GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(F4:F63),H4) /RH4,H5:H63,ANYNNNY=H65 IF(OR(B4=G63,B4=0),SUM(H3:H64),H65) =H67 IF(OR(B4=G67,B4=0),SUM(F4:F63),H67) /RH67,H68:H86,ANYNNNY=H88 IF(OR(B4=G86,B4=0),SUM(H66:H87),H88) =H90 H65+H88 =F4 IF(AND(B4=D4,B4>0),1,0) /RF4,F5:F63,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A63),I4) /RI4,I5:I63,ANYNNNY=I65 IF(OR(B4=G63,B4=0),SUM(I3:I64),I65) =I67 IF(OR(B4=G67,B4=0),SUM(A4:A63),I67) /RI67,I68:I86,ANYNNNY=I88 IF(OR(B4=G86,B4=0),SUM(I66:I87),I88) =I90 I65+I88 =A4 IF(B4=D4,E4,0) /RA4,A5:A63,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B63 /BF4:F63 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV  =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B63 /BF4:F63 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,/GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(F4:F93),H4) /RH4,H5:H63,ANYNNNY=H65 IF(OR(B4=G63,B4=0),SUM(H3:H64),H65) =H67 IF(OR(B4=G67,B4=0),SUM(F4:F93),H67) /RH67,H68:H86,ANYNNNY=H88 IF(OR(B4=G86,B4=0),SUM(H66:H87),H88) =H90 H65+H88 =F4 IF(AND(B4=D4,B4>0),1,0) /RF4,F5:F93,ANYN=C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A93),I4) /RI4,I5:I63,ANYNNNY=I65 IF(OR(B4=G63,B4=0),SUM(I3:I64),I65) =I67 IF(OR(B4=G67,B4=0),SUM(A4:A93),I67) /RI67,I68:I86,ANYNNNY=I88 IF(OR(B4=G86,B4=0),SUM(I66:I87),I88) =I90 I65+I88 =A4 IF(B4=D4,E4,0) /RA4,A5:A93,ANYY=C3 "Calculating Cash-Totals and Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B93 /BF4:F93 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV  =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =C3 '= /BA4:B93 /BF4:F93 =F4 "| /RF4,F5:F81 /S,BV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I65>0,(100*I4/I65),0) /RJ4,J5:J63,ANYN=J65 SUM(J3:J64) =J67 IF(I88>0,(100*I67/I88),0) /RJ67,J68:J86,ANYN=J88 SUM(J66:J87) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,/GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(A4:A40),H4) /RH4,H5:H115,ANYNNNY=H117 IF(OR(B4=G115,B4=0),SUM(H3:H116),H117) =H119 IF(OR(B4=G119,B4=0),SUM(A4:A40),H119) /RH119,H120:H152,ANYNNNY=H154 IF(OR(B4=G152,B4=0),SUM(H118:H153),H154) =H156 H117+H154 =A4 IF(AND(B4=D4,B4>0),1,0) /RA4,A5:A40,ANYN=C3 "Calculating and Entering Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4 G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! /BA4:B40,=B4 0 /S,BV /ZY/L,A/GM/GC =C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A40),I4) /RI4,I5:I115,ANYNNNY=I117 IF(OR(B4=G115,B4=0),SUM(I3:I116),I117) =I119 IF(OR(B4=G119,B4=0),SUM(A4:A40),I119) /RI119,I120:I152,ANYNNNY=I154 IF(OR(B4=G152,B4=0),SUM(I118:I153),I154) =I156 I117+I154 =A4 IF(B4=D4,E4,0) /RA4,A5:A40,ANYY=C3 "Calculating and Entering Cash-Totals =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4  G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! =C3 '= /BA4:B40 /S,OV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I117>0,(100*I4/I117),0) /RJ4,J5:J115,ANYN=J117 SUM(J4:J115) =J119 IF(I154>0,(100*I119/I154),0) /RJ119,J120:J152,ANYN=J154 SUM(J119:J152) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV  /GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(A4:A50),H4) /RH4,H5:H115,ANYNNNY=H117 IF(OR(B4=G115,B4=0),SUM(H3:H116),H117) =H119 IF(OR(B4=G119,B4=0),SUM(A4:A50),H119) /RH119,H120:H152,ANYNNNY=H154 IF(OR(B4=G152,B4=0),SUM(H118:H153),H154) =H156 H117+H154 =A4 IF(AND(B4=D4,B4>0),1,0) /RA4,A5:A50,ANYN=C3 "Calculating and Entering Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4 G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! /BA4:B50,=B4 0 /S,BV /ZY/L,A/GM/GC =C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A50),I4) /RI4,I5:I115,ANYNNNY=I117 IF(OR(B4=G115,B4=0),SUM(I3:I116),I117) =I119 IF(OR(B4=G119,B4=0),SUM(A4:A50),I119) /RI119,I120:I152,ANYNNNY=I154 IF(OR(B4=G152,B4=0),SUM(I118:I153),I154) =I156 I117+I154 =A4 IF(B4=D4,E4,0) /RA4,A5:A50,ANYY=C3 "Calculating and Entering Cash-Totals =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4  G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! =C3 '= /BA4:B50 /S,OV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I117>0,(100*I4/I117),0) /RJ4,J5:J115,ANYN=J117 SUM(J4:J115) =J119 IF(I154>0,(100*I119/I154),0) /RJ119,J120:J152,ANYN=J154 SUM(J119:J152) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV !/GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(A4:A60),H4) /RH4,H5:H115,ANYNNNY=H117 IF(OR(B4=G115,B4=0),SUM(H3:H116),H117) =H119 IF(OR(B4=G119,B4=0),SUM(A4:A60),H119) /RH119,H120:H152,ANYNNNY=H154 IF(OR(B4=G152,B4=0),SUM(H118:H153),H154) =H156 H117+H154 =A4 IF(AND(B4=D4,B4>0),1,0) /RA4,A5:A60,ANYN=C3 "Calculating and Entering Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4 G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! /BA4:B60,=B4 0 /S,BV /ZY/L,A/GM/GC =C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A60),I4) /RI4,I5:I115,ANYNNNY=I117 IF(OR(B4=G115,B4=0),SUM(I3:I116),I117) =I119 IF(OR(B4=G119,B4=0),SUM(A4:A60),I119) /RI119,I120:I152,ANYNNNY=I154 IF(OR(B4=G152,B4=0),SUM(I118:I153),I154) =I156 I117+I154 =A4 IF(B4=D4,E4,0) /RA4,A5:A60,ANYY=C3 "Calculating and Entering Cash-Totals =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4  G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! =C3 '= /BA4:B60 /S,OV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I117>0,(100*I4/I117),0) /RJ4,J5:J115,ANYN=J117 SUM(J4:J115) =J119 IF(I154>0,(100*I119/I154),0) /RJ119,J120:J152,ANYN=J154 SUM(J119:J152) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV "/GM/GC /ICA:B /FCA,$12  =C3 "Entering Item-Count Formulae =H4 IF(OR(B4=G4,B4=0),SUM(A4:A90),H4) /RH4,H5:H115,ANYNNNY=H117 IF(OR(B4=G115,B4=0),SUM(H3:H116),H117) =H119 IF(OR(B4=G119,B4=0),SUM(A4:A90),H119) /RH119,H120:H152,ANYNNNY=H154 IF(OR(B4=G152,B4=0),SUM(H118:H153),H154) =H156 H117+H154 =A4 IF(AND(B4=D4,B4>0),1,0) /RA4,A5:A90,ANYN=C3 "Calculating and Entering Item-Count =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4 G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! /BA4:B90,=B4 0 /S,BV /ZY/L,A/GM/GC =C3 "Entering Cash-Totals Formulae =I4 IF(OR(B4=G4,B4=0),SUM(A4:A90),I4) /RI4,I5:I115,ANYNNNY=I117 IF(OR(B4=G115,B4=0),SUM(I3:I116),I117) =I119 IF(OR(B4=G119,B4=0),SUM(A4:A90),I119) /RI119,I120:I152,ANYNNNY=I154 IF(OR(B4=G152,B4=0),SUM(I118:I153),I154) =I156 I117+I154 =A4 IF(B4=D4,E4,0) /RA4,A5:A90,ANYY=C3 "Calculating and Entering Cash-Totals =B4 0 ! =B4 G4 ! =B4 G5 ! =B4 G6 ! =B4 G7 ! =B4 G8 ! =B4 G9 ! =B4 G10 ! =B4 G11 ! =B4 G12 ! =B4 G13 ! =B4 G14 ! =B4 G15 ! =B4 G16 ! =B4 G17 ! =B4 G18 ! =B4 G19 ! =B4 G20 ! =B4 G21 ! =B4 G22 ! =B4 G23 ! =B4 G24 ! =B4 G25 ! =B4 G26 ! =B4 G27 ! =B4 G28 ! =B4 G29 ! =B4 G30 ! =B4 G31 ! =B4 G32 ! =B4 G33 ! =B4 G34 ! =B4 G35 ! =B4 G36 ! =B4 G37 ! =B4 G38 ! =B4 G39 ! =B4 G40 ! =B4 G41 ! =B4 G42 ! =B4 G43 ! =B4 G44 ! =B4 G45 ! =B4 G46 ! =B4 G47 ! =B4 G48 ! =B4 G49 ! =B4 G50 ! =B4 G51 ! =B4 G52 ! =B4 G53 ! =B4 G54 ! =B4 G55 ! =B4 G56 ! =B4 G57 ! =B4 G58 ! =B4 G59 ! =B4 G60 ! =B4 G61 ! =B4 G62 ! =B4 G63 ! =B4 G64 ! =B4 G65 ! =B4 G66 ! =B4 G67 ! =B4 G68 ! =B4 G69 ! =B4 G70 ! =B4 G71 ! =B4 G72 ! =B4 G73 ! =B4 G74 ! =B4 G75 ! =B4 G76 ! =B4 G77 ! =B4 G78 ! =B4 G79 ! =B4 G80 ! =B4 G81 ! =B4 G82 ! =B4 G83 ! =B4 G84 ! =B4 G85 ! =B4 G86 ! =B4 G87 ! =B4 G88 ! =B4 G89 ! =B4 G90 ! =B4 G91 ! =B4 G92 ! =B4 G93 ! =B4 G94 ! =B4 G95 ! =B4 G96 ! =B4 G97 ! =B4 G98 ! =B4 G99 ! =B4 G100 ! =B4 G101 ! =B4 G102 ! =B4 G103 ! =B4 G104 ! =B4 G105 ! =B4  G106 ! =B4 G107 ! =B4 G108 ! =B4 G109 ! =B4 G110 ! =B4 G111 ! =B4 G112 ! =B4 G113 ! =B4 G114 ! =B4 G115 ! =B4 G119 ! =B4 G120 ! =B4 G121 ! =B4 G122 ! =B4 G123 ! =B4 G124 ! =B4 G125 ! =B4 G126 ! =B4 G127 ! =B4 G128 ! =B4 G129 ! =B4 G130 ! =B4 G131 ! =B4 G132 ! =B4 G133 ! =B4 G134 ! =B4 G135 ! =B4 G136 ! =B4 G137 ! =B4 G138 ! =B4 G139 ! =B4 G140 ! =B4 G141 ! =B4 G142 ! =B4 G143 ! =B4 G144 ! =B4 G145 ! =B4 G146 ! =B4 G147 ! =B4 G148 ! =B4 G149 ! =B4 G150 ! =B4 G151 ! =B4 G152 ! =C3 '= /BA4:B90 /S,OV /ZY/L,A/GM/GC /FCJ,$ =J2 " % =C3 "Entering Percentage Formulae =J4 IF(I117>0,(100*I4/I117),0) /RJ4,J5:J115,ANYN=J117 SUM(J4:J115) =J119 IF(I154>0,(100*I119/I154),0) /RJ119,J120:J152,ANYN=J154 SUM(J119:J152) =C3 "Calculating Percentages !=C3 '= /DCA:B /S,OV # This is the release date of the disk. FORM-B XQT €u€FORM-F XQT €v€CF-A40 XQT €xCF-A50 XQT €zCF-A60 XQT €|CF-A90 XQT €~CF-B40 XQT €€€CF-B50 XQT €ƒ€CF-B60 XQT €†€CF-B90 XQT €‰€CF-F40 XQT €ŒCF-F50 XQT €‘CF-F60 XQT €–CF-F90 XQT €›TABLE3 .DOC 16 E0 5632 44 TABLE4 .DOC 7B 99 2560 20 COST86/M.CAL 5A 59 18176 142 COST86/M.DOC 47 DE 1280 10 CASHFAX .DOC 2C 79 7296 57 FORM-A .XQT 13 83 768 6 FORM-B .XQT 20 1E 896 7 FORM-F .XQT 44 24 1152 9 CF-A40 .XQT DE B2 2048 16 CF-A50 .XQT 42 E2 2048 16 CF-A60 .XQT F6 33 2048 16 CF-A90 .XQT B1 E4 2048 16 CF-B40  Fog Library Disk FOG-CPM.039 Copyright (1986) by Fog International Computer Users Group to the extent not copyrighted by the original author for the exclusive use and enjoyment of its members. Any reproduction or distribution for profit or personal gain is strictly forbidden. For information, contact FOG, P. O. Box 3474, Daly City, CA. 94015-0474. as part of the description of a file indicates that the program is distributed on a "try first, pay if you like it" basis. If you find the program(s) meet your need, please refer to the author's documentation for information on becoming a registered user. Only by registering and paying for the programs you like and use will the authors of such programs continue development. Often, more complete documentation, additional modules, and new releases are available only to registered users. Supercalc applications. Filename Description -04-00 .86 This is the release date of the disk. -CPM039 .DOC This is the description of the disk contents. NETWORTH.CAL D1BD 10K [Networth 1 of 2] SuperCalc 1.05 or higher template for calculating your net worth. Allows you to balance you assets. NETWORTH.DOC AB51 9K [Networth 2 of 2] REIA .CAL 86A1 9K ver. 1.10 [REIA 1 of 3] SuperCalc 2 Real Estate Investment Analysis for commercial property. Includes sample spreadsheet. REIA .DOC 7010 4K ver. 1.10 [REIA 2 of 3] REIA-S .CAL D558 9K ver. 1.10 [REIA 3 of 3] HEARING .CAL 6748 16K [Hearing 1 of 6] SuperCalc 2 template for audiogram comparisons. Excellent example of the LOOKUP and IF expressions. HEARING .DOC 6457 16K [Hearing 2 of 6] TABLE1 .DOC AE5F 2K [Hearing 3 of 6] TABLE2 .DOC 14A0 1K [Hearing 4 of 6] TABLE3 .DOC 16E0 6K [Hearing 5 of 6] TABLE4 .DOC 7B99 3K [Hearing 6 of 6] COST86/M.CAL 5A59 18K [COST86/M 1 of 2] Personal budget, income, and expense tracking system for use SuperCalc 2. Part of this is designed for a wide printer with condensed mode so modification will be needed for smaller printers. COST86/M.DOC 47DE 2K [COST86/M 2 of 2] CASHFAX .DOC 2C79 8K [CashFacts 1 of 16] A small business or agricultural cash journal. Requires SuperCalc 2. Fully automated with eXecute files. FORM-A .XQT 1383 1K [CashFacts 2 of 16] FORM-B .XQT 201E 1K [CashFacts 3 of 16] FORM-F .XQT 4424 2K [CashFacts 4 of 16] CF-A40 .XQT DEB2 2K [CashFacts 5 of 16] CF-A50 .XQT 42E2 2K [CashFacts 6 of 16] CF-A60 .XQT F633 2K [CashFacts 7 of 16] CF-A90 .XQT B1E4 2K [CashFacts 8 of 16] CF-B40 .XQT 5B12 3K [CashFacts 9 of 16] CF-B50 .XQT 1A56 3K  [CashFacts 10 of 16] CF-B60 .XQT D99A 3K [CashFacts 11 of 16] CF-B90 .XQT 2505 3K [CashFacts 12 of 16] CF-F40 .XQT D8FE 5K [CashFacts 13 of 16] CF-F50 .XQT A842 5K [CashFacts 14 of 16] CF-F60 .XQT 3986 5K [CashFacts 15 of 16] CF-F90 .XQT CF10 5K [CashFacts 16 of 16]  SET ALTE ON DO WHILE diskno="&mdiskno".AND. .NOT. EOF() IF diskno="000" IF dfile="FOG-DOS" ? " åååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååååå$ååååå%ååååå&ååååå'ååååå