LnSOS BOOT 1.1 SOS.KERNEL SOS KRNLI/O ERRORFILE 'SOS.KERNEL' NOT FOUND%INVALID KERNEL FILE: xةw,@  ȱlmi8#)!)>J91:/F$ >I91:/F$ >G91:/F$" ========== >F91:/F$" ========== >E91:/F$" ========== >A91:+A90+1 >J90:/F$ >I90:/F$ >G90:/F$@SUM(G29...G88) >F90:/F$@SUM(F29...F88) >E90:/F$@SUM(E29...E88) >C90:/FL >A90:+A89+1 >J89:/F$ >I89:/F$ >G89:/F$" --------- >F89:/F$" ----j3(Ÿ/ DISKNAME.DAT ۸ ۸ *MENU.MAKER 3)8(BANKCALCP Xܸ$ܸ$/BANKCALC3.ASCII 8ܸ%ܸ%III.AWZ.09u' &MODEL12``+$&MODEL2.INFO:2a$&MODEL3.INFOl86$&MODEL4.INFO@|$&MODEL5.INFO$%SEG.T >dLԡm#i㰼m#iЕOLԡȱfg hi !dLԡ憦  Ljmkm l y`2 Lԡ8(Je稽)ʈ@L----- >E89:/F$" --------- >A89:+A88+1 >J88:/F$@IF(B88=0,0,+J87+G88) >I88:/F$@IF(B88=0,0,+I87+F88) >H88:/F$+H87-G88 >G88:/F$+E88-F88 >F88:/F$@INT((+H87*I17/12)+.5)/100 >E88:/F$@IF(@COUNT(E29...E88)=N12,H87+(@INT(H87*I17/12+.5)/100),@IF(@COUNT(E29...E88)>N12  !"#$%&'()*+,-./01234567879+1,C79)) >B80:@IF(@COUNT(B29...B80>N12,0,@IF(B79=12,1,B79+1)) >A80:+A79+1 >J79:/F$@IF(B79=0,0,+J78+G79) >I79:/F$@IF(B79=0,0,+I78+F79) >H79:/F$+H78-G79 >G79:/F$+E79-F79 >F79:/F$@INT((+H78*I17/12)+.5)/100 >E79:/F$@IF(@COUNT(E29...E79)=N12,H78+(@INT(H78*I17B80=0,0,+I79+F80) >H80:/F$+H79-G80 >G80:/F$+E80-F80 >F80:/F$@INT((+H79*I17/12)+.5)/100 >E80:/F$@IF(@COUNT(E29...E80)=N12,H79+(@INT(H79*I17/12+.5)/100),@IF(@COUNT(E29...E80)>N12,0,I19) >D80:@IF(@COUNT(D29...D80)>N12,0,+D79+1) >C80:/FL@IF(B80=0,0,@IF(B80=1,C12,H80+(@INT(H80*I17/12+.5)/100),@IF(@COUNT(E29...E81)>N12,0,I19) >D81:@IF(@COUNT(D29...D81)>N12,0,+D80+1) >C81:/FL@IF(B81=0,0,@IF(B81=1,C80+1,C80)) >B81:@IF(@COUNT(B29...B81>N12,0,@IF(B80=12,1,B80+1)) >A81:+A80+1 >J80:/F$@IF(B80=0,0,+J79+G80) >I80:/F$@IF((B82=0,0,@IF(B82=1,C81+1,C81)) >B82:@IF(@COUNT(B29...B82>N12,0,@IF(B81=12,1,B81+1)) >A82:+A81+1 >J81:/F$@IF(B81=0,0,+J80+G81) >I81:/F$@IF(B81=0,0,+I80+F81) >H81:/F$+H80-G81 >G81:/F$+E81-F81 >F81:/F$@INT((+H80*I17/12)+.5)/100 >E81:/F$@IF(@COUNT(E29...E81)=N81+G82) >I82:/F$@IF(B82=0,0,+I81+F82) >H82:/F$+H81-G82 >G82:/F$+E82-F82 >F82:/F$@INT((+H81*I17/12)+.5)/100 >E82:/F$@IF(@COUNT(E29...E82)=N12,H81+(@INT(H81*I17/12+.5)/100),@IF(@COUNT(E29...E82)>N12,0,I19) >D82:@IF(@COUNT(D29...D82)>N12,0,+D81+1) >C82:/FL@IF(@COUNT(E29...E83)=N12,H82+(@INT(H82*I17/12+.5)/100),@IF(@COUNT(E29...E83)>N12,0,I19) >D83:@IF(@COUNT(D29...D83)>N12,0,+D82+1) >C83:/FL@IF(B83=0,0,@IF(B83=1,C82+1,C82)) >B83:@IF(@COUNT(B29...B83>N12,0,@IF(B82=12,1,B82+1)) >A83:+A82+1 >J82:/F$@IF(B82=0,0,+J,+D83+1) >C84:/FL@IF(B84=0,0,@IF(B84=1,C83+1,C83)) >B84:@IF(@COUNT(B29...B84>N12,0,@IF(B83=12,1,B83+1)) >A84:+A83+1 >J83:/F$@IF(B83=0,0,+J82+G83) >I83:/F$@IF(B83=0,0,+I82+F83) >H83:/F$+H82-G83 >G83:/F$+E83-F83 >F83:/F$@INT((+H82*I17/12)+.5)/100 >E83:/F$@IF84:/F$@IF(B84=0,0,+J83+G84) >I84:/F$@IF(B84=0,0,+I83+F84) >H84:/F$+H83-G84 >G84:/F$+E84-F84 >F84:/F$@INT((+H83*I17/12)+.5)/100 >E84:/F$@IF(@COUNT(E29...E84)=N12,H83+(@INT(H83*I17/12+.5)/100),@IF(@COUNT(E29...E84)>N12,0,I19) >D84:@IF(@COUNT(D29...D84)>N12,0+.5)/100 >E85:/F$@IF(@COUNT(E29...E85)=N12,H84+(@INT(H84*I17/12+.5)/100),@IF(@COUNT(E29...E85)>N12,0,I19) >D85:@IF(@COUNT(D29...D85)>N12,0,+D84+1) >C85:/FL@IF(B85=0,0,@IF(B85=1,C84+1,C84)) >B85:@IF(@COUNT(B29...B85>N12,0,@IF(B84=12,1,B84+1)) >A85:+A84+1 >JUNT(D29...D86)>N12,0,+D85+1) >C86:/FL@IF(B86=0,0,@IF(B86=1,C85+1,C85)) >B86:@IF(@COUNT(B29...B86>N12,0,@IF(B85=12,1,B85+1)) >A86:+A85+1 >J85:/F$@IF(B85=0,0,+J84+G85) >I85:/F$@IF(B85=0,0,+I84+F85) >H85:/F$+H84-G85 >G85:/F$+E85-F85 >F85:/F$@INT((+H84*I17/12)6+1)) >A87:+A86+1 >J86:/F$@IF(B86=0,0,+J85+G86) >I86:/F$@IF(B86=0,0,+I85+F86) >H86:/F$+H85-G86 >G86:/F$+E86-F86 >F86:/F$@INT((+H85*I17/12)+.5)/100 >E86:/F$@IF(@COUNT(E29...E86)=N12,H85+(@INT(H85*I17/12+.5)/100),@IF(@COUNT(E29...E86)>N12,0,I19) >D86:@IF(@COF$@INT((+H86*I17/12)+.5)/100 >E87:/F$@IF(@COUNT(E29...E87)=N12,H86+(@INT(H86*I17/12+.5)/100),@IF(@COUNT(E29...E87)>N12,0,I19) >D87:@IF(@COUNT(D29...D87)>N12,0,+D86+1) >C87:/FL@IF(B87=0,0,@IF(B87=1,C86+1,C86)) >B87:@IF(@COUNT(B29...B87>N12,0,@IF(B86=12,1,B8,0,I19) >D88:@IF(@COUNT(D29...D88)>N12,0,+D87+1) >C88:/FL@IF(B88=0,0,@IF(B88=1,C87+1,C87)) >B88:@IF(@COUNT(B29...B88>N12,0,@IF(B87=12,1,B87+1)) >A88:+A87+1 >J87:/F$@IF(B87=0,0,+J86+G87) >I87:/F$@IF(B87=0,0,+I86+F87) >H87:/F$+H86-G87 >G87:/F$+E87-F87 >F87://12+.5)/100),@IF(@COUNT(E29...E79)>N12,0,I19) >D79:@IF(@COUNT(D29...D79)>N12,0,+D78+1) >C79:/FL@IF(B79=0,0,@IF(B79=1,C78+1,C78)) >B79:@IF(@COUNT(B29...B79>N12,0,@IF(B78=12,1,B78+1)) >A79:+A78+1 >J78:/F$@IF(B78=0,0,+J77+G78) >I78:/F$@IF(B78=0,0,+I77+F78) >H78:/F$+H77-G78 >G78:/F$+E78-F78 >F78:/F$@INT((+H77*I17/12)+.5)/100 >E78:/F$@IF(@COUNT(E29...E78)=N12,H77+(@INT(H77*I17/12+.5)/100),@IF(@COUNT(E29...E78)>N12,0,I19) >D78:@IF(@COUNT(D29...D78)>N12,0,+D77+1) >C78:/FL@IF(B78=0,0,@IF(B78=1,C77+1,C77)) >B78:@IF(69=0,0,@IF(B69=1,C68+1,C68)) >B69:@IF(@COUNT(B29...B69>N12,0,@IF(B68=12,1,B68+1)) >A69:+A68+1 >J68:/F$@IF(B68=0,0,+J67+G68) >I68:/F$@IF(B68=0,0,+I67+F68) >H68:/F$+H67-G68 >G68:/F$+E68-F68 >F68:/F$@INT((+H67*I17/12)+.5)/100 >E68:/F$@IF(@COUNT(E29...E68)=N12+G69) >I69:/F$@IF(B69=0,0,+I68+F69) >H69:/F$+H68-G69 >G69:/F$+E69-F69 >F69:/F$@INT((+H68*I17/12)+.5)/100 >E69:/F$@IF(@COUNT(E29...E69)=N12,H68+(@INT(H68*I17/12+.5)/100),@IF(@COUNT(E29...E69)>N12,0,I19) >D69:@IF(@COUNT(D29...D69)>N12,0,+D68+1) >C69:/FL@IF(BCOUNT(E29...E70)=N12,H69+(@INT(H69*I17/12+.5)/100),@IF(@COUNT(E29...E70)>N12,0,I19) >D70:@IF(@COUNT(D29...D70)>N12,0,+D69+1) >C70:/FL@IF(B70=0,0,@IF(B70=1,C69+1,C69)) >B70:@IF(@COUNT(B29...B70>N12,0,@IF(B69=12,1,B69+1)) >A70:+A69+1 >J69:/F$@IF(B69=0,0,+J68D70+1) >C71:/FL@IF(B71=0,0,@IF(B71=1,C70+1,C70)) >B71:@IF(@COUNT(B29...B71>N12,0,@IF(B70=12,1,B70+1)) >A71:+A70+1 >J70:/F$@IF(B70=0,0,+J69+G70) >I70:/F$@IF(B70=0,0,+I69+F70) >H70:/F$+H69-G70 >G70:/F$+E70-F70 >F70:/F$@INT((+H69*I17/12)+.5)/100 >E70:/F$@IF(@:/F$@IF(B71=0,0,+J70+G71) >I71:/F$@IF(B71=0,0,+I70+F71) >H71:/F$+H70-G71 >G71:/F$+E71-F71 >F71:/F$@INT((+H70*I17/12)+.5)/100 >E71:/F$@IF(@COUNT(E29...E71)=N12,H70+(@INT(H70*I17/12+.5)/100),@IF(@COUNT(E29...E71)>N12,0,I19) >D71:@IF(@COUNT(D29...D71)>N12,0,+5)/100 >E72:/F$@IF(@COUNT(E29...E72)=N12,H71+(@INT(H71*I17/12+.5)/100),@IF(@COUNT(E29...E72)>N12,0,I19) >D72:@IF(@COUNT(D29...D72)>N12,0,+D71+1) >C72:/FL@IF(B72=0,0,@IF(B72=1,C71+1,C71)) >B72:@IF(@COUNT(B29...B72>N12,0,@IF(B71=12,1,B71+1)) >A72:+A71+1 >J71T(D29...D73)>N12,0,+D72+1) >C73:/FL@IF(B73=0,0,@IF(B73=1,C72+1,C72)) >B73:@IF(@COUNT(B29...B73>N12,0,@IF(B72=12,1,B72+1)) >A73:+A72+1 >J72:/F$@IF(B72=0,0,+J71+G72) >I72:/F$@IF(B72=0,0,+I71+F72) >H72:/F$+H71-G72 >G72:/F$+E72-F72 >F72:/F$@INT((+H71*I17/12)+.1)) >A74:+A73+1 >J73:/F$@IF(B73=0,0,+J72+G73) >I73:/F$@IF(B73=0,0,+I72+F73) >H73:/F$+H72-G73 >G73:/F$+E73-F73 >F73:/F$@INT((+H72*I17/12)+.5)/100 >E73:/F$@IF(@COUNT(E29...E73)=N12,H72+(@INT(H72*I17/12+.5)/100),@IF(@COUNT(E29...E73)>N12,0,I19) >D73:@IF(@COUN@INT((+H73*I17/12)+.5)/100 >E74:/F$@IF(@COUNT(E29...E74)=N12,H73+(@INT(H73*I17/12+.5)/100),@IF(@COUNT(E29...E74)>N12,0,I19) >D74:@IF(@COUNT(D29...D74)>N12,0,+D73+1) >C74:/FL@IF(B74=0,0,@IF(B74=1,C73+1,C73)) >B74:@IF(@COUNT(B29...B74>N12,0,@IF(B73=12,1,B73+,I19) >D75:@IF(@COUNT(D29...D75)>N12,0,+D74+1) >C75:/FL@IF(B75=0,0,@IF(B75=1,C74+1,C74)) >B75:@IF(@COUNT(B29...B75>N12,0,@IF(B74=12,1,B74+1)) >A75:+A74+1 >J74:/F$@IF(B74=0,0,+J73+G74) >I74:/F$@IF(B74=0,0,+I73+F74) >H74:/F$+H73-G74 >G74:/F$+E74-F74 >F74:/F$,0,@IF(B75=12,1,B75+1)) >A76:+A75+1 >J75:/F$@IF(B75=0,0,+J74+G75) >I75:/F$@IF(B75=0,0,+I74+F75) >H75:/F$+H74-G75 >G75:/F$+E75-F75 >F75:/F$@INT((+H74*I17/12)+.5)/100 >E75:/F$@IF(@COUNT(E29...E75)=N12,H74+(@INT(H74*I17/12+.5)/100),@IF(@COUNT(E29...E75)>N12,0/F$+E76-F76 >F76:/F$@INT((+H75*I17/12)+.5)/100 >E76:/F$@IF(@COUNT(E29...E76)=N12,H75+(@INT(H75*I17/12+.5)/100),@IF(@COUNT(E29...E76)>N12,0,I19) >D76:@IF(@COUNT(D29...D76)>N12,0,+D75+1) >C76:/FL@IF(B76=0,0,@IF(B76=1,C75+1,C75)) >B76:@IF(@COUNT(B29...B76>N12UNT(E29...E77)>N12,0,I19) >D77:@IF(@COUNT(D29...D77)>N12,0,+D76+1) >C77:/FL@IF(B77=0,0,@IF(B77=1,C76+1,C76)) >B77:@IF(@COUNT(B29...B77>N12,0,@IF(B76=12,1,B76+1)) >A77:+A76+1 >J76:/F$@IF(B76=0,0,+J75+G76) >I76:/F$@IF(B76=0,0,+I75+F76) >H76:/F$+H75-G76 >G76:@COUNT(B29...B78>N12,0,@IF(B77=12,1,B77+1)) >A78:+A77+1 >J77:/F$@IF(B77=0,0,+J76+G77) >I77:/F$@IF(B77=0,0,+I76+F77) >H77:/F$+H76-G77 >G77:/F$+E77-F77 >F77:/F$@INT((+H76*I17/12)+.5)/100 >E77:/F$@IF(@COUNT(E29...E77)=N12,H76+(@INT(H76*I17/12+.5)/100),@IF(@CO,H67+(@INT(H67*I17/12+.5)/100),@IF(@COUNT(E29...E68)>N12,0,I19) >D68:@IF(@COUNT(D29...D68)>N12,0,+D67+1) >C68:/FL@IF(B68=0,0,@IF(B68=1,C67+1,C67)) >B68:@IF(@COUNT(B29...B68>N12,0,@IF(B67=12,1,B67+1)) >A68:+A67+1 >J67:/F$@IF(B67=0,0,+J66+G67) >I67:/F$@IF(B67=0,0,+I66+F67) >H67:/F$+H66-G67 >G67:/F$+E67-F67 >F67:/F$@INT((+H66*I17/12)+.5)/100 >E67:/F$@IF(@COUNT(E29...E67)=N12,H66+(@INT(H66*I17/12+.5)/100),@IF(@COUNT(E29...E67)>N12,0,I19) >D67:@IF(@COUNT(D29...D67)>N12,0,+D66+1) >C67:/FL@IF(B67=0,0,@IF(B67=1,C667+1) >C58:/FL@IF(B58=0,0,@IF(B58=1,C57+1,C57)) >B58:@IF(@COUNT(B29...B58>N12,0,@IF(B57=12,1,B57+1)) >A58:+A57+1 >J57:/F$@IF(B57=0,0,+J56+G57) >I57:/F$@IF(B57=0,0,+I56+F57) >H57:/F$+H56-G57 >G57:/F$+E57-F57 >F57:/F$@INT((+H56*I17/12)+.5)/100 >E57:/F$@IF(@COF$@IF(B58=0,0,+J57+G58) >I58:/F$@IF(B58=0,0,+I57+F58) >H58:/F$+H57-G58 >G58:/F$+E58-F58 >F58:/F$@INT((+H57*I17/12)+.5)/100 >E58:/F$@IF(@COUNT(E29...E58)=N12,H57+(@INT(H57*I17/12+.5)/100),@IF(@COUNT(E29...E58)>N12,0,I19) >D58:@IF(@COUNT(D29...D58)>N12,0,+D5/100 >E59:/F$@IF(@COUNT(E29...E59)=N12,H58+(@INT(H58*I17/12+.5)/100),@IF(@COUNT(E29...E59)>N12,0,I19) >D59:@IF(@COUNT(D29...D59)>N12,0,+D58+1) >C59:/FL@IF(B59=0,0,@IF(B59=1,C58+1,C58)) >B59:@IF(@COUNT(B29...B59>N12,0,@IF(B58=12,1,B58+1)) >A59:+A58+1 >J58:/D29...D60)>N12,0,+D59+1) >C60:/FL@IF(B60=0,0,@IF(B60=1,C59+1,C59)) >B60:@IF(@COUNT(B29...B60>N12,0,@IF(B59=12,1,B59+1)) >A60:+A59+1 >J59:/F$@IF(B59=0,0,+J58+G59) >I59:/F$@IF(B59=0,0,+I58+F59) >H59:/F$+H58-G59 >G59:/F$+E59-F59 >F59:/F$@INT((+H58*I17/12)+.5)) >A61:+A60+1 >J60:/F$@IF(B60=0,0,+J59+G60) >I60:/F$@IF(B60=0,0,+I59+F60) >H60:/F$+H59-G60 >G60:/F$+E60-F60 >F60:/F$@INT((+H59*I17/12)+.5)/100 >E60:/F$@IF(@COUNT(E29...E60)=N12,H59+(@INT(H59*I17/12+.5)/100),@IF(@COUNT(E29...E60)>N12,0,I19) >D60:@IF(@COUNT(NT((+H60*I17/12)+.5)/100 >E61:/F$@IF(@COUNT(E29...E61)=N12,H60+(@INT(H60*I17/12+.5)/100),@IF(@COUNT(E29...E61)>N12,0,I19) >D61:@IF(@COUNT(D29...D61)>N12,0,+D60+1) >C61:/FL@IF(B61=0,0,@IF(B61=1,C60+1,C60)) >B61:@IF(@COUNT(B29...B61>N12,0,@IF(B60=12,1,B60+1)19) >D62:@IF(@COUNT(D29...D62)>N12,0,+D61+1) >C62:/FL@IF(B62=0,0,@IF(B62=1,C61+1,C61)) >B62:@IF(@COUNT(B29...B62>N12,0,@IF(B61=12,1,B61+1)) >A62:+A61+1 >J61:/F$@IF(B61=0,0,+J60+G61) >I61:/F$@IF(B61=0,0,+I60+F61) >H61:/F$+H60-G61 >G61:/F$+E61-F61 >F61:/F$@I,@IF(B62=12,1,B62+1)) >A63:+A62+1 >J62:/F$@IF(B62=0,0,+J61+G62) >I62:/F$@IF(B62=0,0,+I61+F62) >H62:/F$+H61-G62 >G62:/F$+E62-F62 >F62:/F$@INT((+H61*I17/12)+.5)/100 >E62:/F$@IF(@COUNT(E29...E62)=N12,H61+(@INT(H61*I17/12+.5)/100),@IF(@COUNT(E29...E62)>N12,0,I$+E63-F63 >F63:/F$@INT((+H62*I17/12)+.5)/100 >E63:/F$@IF(@COUNT(E29...E63)=N12,H62+(@INT(H62*I17/12+.5)/100),@IF(@COUNT(E29...E63)>N12,0,I19) >D63:@IF(@COUNT(D29...D63)>N12,0,+D62+1) >C63:/FL@IF(B63=0,0,@IF(B63=1,C62+1,C62)) >B63:@IF(@COUNT(B29...B63>N12,0T(E29...E64)>N12,0,I19) >D64:@IF(@COUNT(D29...D64)>N12,0,+D63+1) >C64:/FL@IF(B64=0,0,@IF(B64=1,C63+1,C63)) >B64:@IF(@COUNT(B29...B64>N12,0,@IF(B63=12,1,B63+1)) >A64:+A63+1 >J63:/F$@IF(B63=0,0,+J62+G63) >I63:/F$@IF(B63=0,0,+I62+F63) >H63:/F$+H62-G63 >G63:/FOUNT(B29...B65>N12,0,@IF(B64=12,1,B64+1)) >A65:+A64+1 >J64:/F$@IF(B64=0,0,+J63+G64) >I64:/F$@IF(B64=0,0,+I63+F64) >H64:/F$+H63-G64 >G64:/F$+E64-F64 >F64:/F$@INT((+H63*I17/12)+.5)/100 >E64:/F$@IF(@COUNT(E29...E64)=N12,H63+(@INT(H63*I17/12+.5)/100),@IF(@COUN:/F$+H64-G65 >G65:/F$+E65-F65 >F65:/F$@INT((+H64*I17/12)+.5)/100 >E65:/F$@IF(@COUNT(E29...E65)=N12,H64+(@INT(H64*I17/12+.5)/100),@IF(@COUNT(E29...E65)>N12,0,I19) >D65:@IF(@COUNT(D29...D65)>N12,0,+D64+1) >C65:/FL@IF(B65=0,0,@IF(B65=1,C64+1,C64)) >B65:@IF(@C2+.5)/100),@IF(@COUNT(E29...E66)>N12,0,I19) >D66:@IF(@COUNT(D29...D66)>N12,0,+D65+1) >C66:/FL@IF(B66=0,0,@IF(B66=1,C65+1,C65)) >B66:@IF(@COUNT(B29...B66>N12,0,@IF(B65=12,1,B65+1)) >A66:+A65+1 >J65:/F$@IF(B65=0,0,+J64+G65) >I65:/F$@IF(B65=0,0,+I64+F65) >H65+1,C66)) >B67:@IF(@COUNT(B29...B67>N12,0,@IF(B66=12,1,B66+1)) >A67:+A66+1 >J66:/F$@IF(B66=0,0,+J65+G66) >I66:/F$@IF(B66=0,0,+I65+F66) >H66:/F$+H65-G66 >G66:/F$+E66-F66 >F66:/F$@INT((+H65*I17/12)+.5)/100 >E66:/F$@IF(@COUNT(E29...E66)=N12,H65+(@INT(H65*I17/1UNT(E29...E57)=N12,H56+(@INT(H56*I17/12+.5)/100),@IF(@COUNT(E29...E57)>N12,0,I19) >D57:@IF(@COUNT(D29...D57)>N12,0,+D56+1) >C57:/FL@IF(B57=0,0,@IF(B57=1,C56+1,C56)) >B57:@IF(@COUNT(B29...B57>N12,0,@IF(B56=12,1,B56+1)) >A57:+A56+1 >J56:/F$@IF(B56=0,0,+J55+G56) >I56:/F$@IF(B56=0,0,+I55+F56) >H56:/F$+H55-G56 >G56:/F$+E56-F56 >F56:/F$@INT((+H55*I17/12)+.5)/100 >E56:/F$@IF(@COUNT(E29...E56)=N12,H55+(@INT(H55*I17/12+.5)/100),@IF(@COUNT(E29...E56)>N12,0,I19) >D56:@IF(@COUNT(D29...D56)>N12,0,+D55+1) >C56:/FL@IF(B569...D47)>N12,0,+D46+1) >C47:/FL@IF(B47=0,0,@IF(B47=1,C46+1,C46)) >B47:@IF(@COUNT(B29...B47>N12,0,@IF(B46=12,1,B46+1)) >A47:+A46+1 >J46:/F$@IF(B46=0,0,+J45+G46) >I46:/F$@IF(B46=0,0,+I45+F46) >H46:/F$+H45-G46 >G46:/F$+E46-F46 >F46:/F$@INT((+H45*I17/12)+.5)/1>A48:+A47+1 >J47:/F$@IF(B47=0,0,+J46+G47) >I47:/F$@IF(B47=0,0,+I46+F47) >H47:/F$+H46-G47 >G47:/F$+E47-F47 >F47:/F$@INT((+H46*I17/12)+.5)/100 >E47:/F$@IF(@COUNT(E29...E47)=N12,H46+(@INT(H46*I17/12+.5)/100),@IF(@COUNT(E29...E47)>N12,0,I19) >D47:@IF(@COUNT(D2((+H47*I17/12)+.5)/100 >E48:/F$@IF(@COUNT(E29...E48)=N12,H47+(@INT(H47*I17/12+.5)/100),@IF(@COUNT(E29...E48)>N12,0,I19) >D48:@IF(@COUNT(D29...D48)>N12,0,+D47+1) >C48:/FL@IF(B48=0,0,@IF(B48=1,C47+1,C47)) >B48:@IF(@COUNT(B29...B48>N12,0,@IF(B47=12,1,B47+1)) ) >D49:@IF(@COUNT(D29...D49)>N12,0,+D48+1) >C49:/FL@IF(B49=0,0,@IF(B49=1,C48+1,C48)) >B49:@IF(@COUNT(B29...B49>N12,0,@IF(B48=12,1,B48+1)) >A49:+A48+1 >J48:/F$@IF(B48=0,0,+J47+G48) >I48:/F$@IF(B48=0,0,+I47+F48) >H48:/F$+H47-G48 >G48:/F$+E48-F48 >F48:/F$@INTIF(B49=12,1,B49+1)) >A50:+A49+1 >J49:/F$@IF(B49=0,0,+J48+G49) >I49:/F$@IF(B49=0,0,+I48+F49) >H49:/F$+H48-G49 >G49:/F$+E49-F49 >F49:/F$@INT((+H48*I17/12)+.5)/100 >E49:/F$@IF(@COUNT(E29...E49)=N12,H48+(@INT(H48*I17/12+.5)/100),@IF(@COUNT(E29...E49)>N12,0,I19E50-F50 >F50:/F$@INT((+H49*I17/12)+.5)/100 >E50:/F$@IF(@COUNT(E29...E50)=N12,H49+(@INT(H49*I17/12+.5)/100),@IF(@COUNT(E29...E50)>N12,0,I19) >D50:@IF(@COUNT(D29...D50)>N12,0,+D49+1) >C50:/FL@IF(B50=0,0,@IF(B50=1,C49+1,C49)) >B50:@IF(@COUNT(B29...B50>N12,0,@E29...E51)>N12,0,I19) >D51:@IF(@COUNT(D29...D51)>N12,0,+D50+1) >C51:/FL@IF(B51=0,0,@IF(B51=1,C50+1,C50)) >B51:@IF(@COUNT(B29...B51>N12,0,@IF(B50=12,1,B50+1)) >A51:+A50+1 >J50:/F$@IF(B50=0,0,+J49+G50) >I50:/F$@IF(B50=0,0,+I49+F50) >H50:/F$+H49-G50 >G50:/F$+NT(B29...B52>N12,0,@IF(B51=12,1,B51+1)) >A52:+A51+1 >J51:/F$@IF(B51=0,0,+J50+G51) >I51:/F$@IF(B51=0,0,+I50+F51) >H51:/F$+H50-G51 >G51:/F$+E51-F51 >F51:/F$@INT((+H50*I17/12)+.5)/100 >E51:/F$@IF(@COUNT(E29...E51)=N12,H50+(@INT(H50*I17/12+.5)/100),@IF(@COUNT(F$+H51-G52 >G52:/F$+E52-F52 >F52:/F$@INT((+H51*I17/12)+.5)/100 >E52:/F$@IF(@COUNT(E29...E52)=N12,H51+(@INT(H51*I17/12+.5)/100),@IF(@COUNT(E29...E52)>N12,0,I19) >D52:@IF(@COUNT(D29...D52)>N12,0,+D51+1) >C52:/FL@IF(B52=0,0,@IF(B52=1,C51+1,C51)) >B52:@IF(@COU.5)/100),@IF(@COUNT(E29...E53)>N12,0,I19) >D53:@IF(@COUNT(D29...D53)>N12,0,+D52+1) >C53:/FL@IF(B53=0,0,@IF(B53=1,C52+1,C52)) >B53:@IF(@COUNT(B29...B53>N12,0,@IF(B52=12,1,B52+1)) >A53:+A52+1 >J52:/F$@IF(B52=0,0,+J51+G52) >I52:/F$@IF(B52=0,0,+I51+F52) >H52:/,C53)) >B54:@IF(@COUNT(B29...B54>N12,0,@IF(B53=12,1,B53+1)) >A54:+A53+1 >J53:/F$@IF(B53=0,0,+J52+G53) >I53:/F$@IF(B53=0,0,+I52+F53) >H53:/F$+H52-G53 >G53:/F$+E53-F53 >F53:/F$@INT((+H52*I17/12)+.5)/100 >E53:/F$@IF(@COUNT(E29...E53)=N12,H52+(@INT(H52*I17/12+0,0,+I53+F54) >H54:/F$+H53-G54 >G54:/F$+E54-F54 >F54:/F$@INT((+H53*I17/12)+.5)/100 >E54:/F$@IF(@COUNT(E29...E54)=N12,H53+(@INT(H53*I17/12+.5)/100),@IF(@COUNT(E29...E54)>N12,0,I19) >D54:@IF(@COUNT(D29...D54)>N12,0,+D53+1) >C54:/FL@IF(B54=0,0,@IF(B54=1,C53+154+(@INT(H54*I17/12+.5)/100),@IF(@COUNT(E29...E55)>N12,0,I19) >D55:@IF(@COUNT(D29...D55)>N12,0,+D54+1) >C55:/FL@IF(B55=0,0,@IF(B55=1,C54+1,C54)) >B55:@IF(@COUNT(B29...B55>N12,0,@IF(B54=12,1,B54+1)) >A55:+A54+1 >J54:/F$@IF(B54=0,0,+J53+G54) >I54:/F$@IF(B54==0,0,@IF(B56=1,C55+1,C55)) >B56:@IF(@COUNT(B29...B56>N12,0,@IF(B55=12,1,B55+1)) >A56:+A55+1 >J55:/F$@IF(B55=0,0,+J54+G55) >I55:/F$@IF(B55=0,0,+I54+F55) >H55:/F$+H54-G55 >G55:/F$+E55-F55 >F55:/F$@INT((+H54*I17/12)+.5)/100 >E55:/F$@IF(@COUNT(E29...E55)=N12,H00 >E46:/F$@IF(@COUNT(E29...E46)=N12,H45+(@INT(H45*I17/12+.5)/100),@IF(@COUNT(E29...E46)>N12,0,I19) >D46:@IF(@COUNT(D29...D46)>N12,0,+D45+1) >C46:/FL@IF(B46=0,0,@IF(B46=1,C45+1,C45)) >B46:@IF(@COUNT(B29...B46>N12,0,@IF(B45=12,1,B45+1)) >A46:+A45+1 >J45:/F$@IF(B45=0,0,+J44+G45) >I45:/F$@IF(B45=0,0,+I44+F45) >H45:/F$+H44-G45 >G45:/F$+E45-F45 >F45:/F$@INT((+H44*I17/12)+.5)/100 >E45:/F$@IF(@COUNT(E29...E45)=N12,H44+(@INT(H44*I17/12+.5)/100),@IF(@COUNT(E29...E45)>N12,0,I19) >D45:@IF(@COUNT(D29...D45)>N12,0,+D44+>D36:@IF(@COUNT(D29...D36)>N12,0,+D35+1) >C36:/FL@IF(B36=0,0,@IF(B36=1,C35+1,C35)) >B36:@IF(@COUNT(B29...B36>N12,0,@IF(B35=12,1,B35+1)) >A36:+A35+1 >J35:/F$@IF(B35=0,0,+J34+G35) >I35:/F$@IF(B35=0,0,+I34+F35) >H35:/F$+H34-G35 >G35:/F$+E35-F35 >F35:/F$@INT(((B36=12,1,B36+1)) >A37:+A36+1 >J36:/F$@IF(B36=0,0,+J35+G36) >I36:/F$@IF(B36=0,0,+I35+F36) >H36:/F$+H35-G36 >G36:/F$+E36-F36 >F36:/F$@INT((+H35*I17/12)+.5)/100 >E36:/F$@IF(@COUNT(E29...E36)=N12,H35+(@INT(H35*I17/12+.5)/100),@IF(@COUNT(E29...E36)>N12,0,I19) 7-F37 >F37:/F$@INT((+H36*I17/12)+.5)/100 >E37:/F$@IF(@COUNT(E29...E37)=N12,H36+(@INT(H36*I17/12+.5)/100),@IF(@COUNT(E29...E37)>N12,0,I19) >D37:@IF(@COUNT(D29...D37)>N12,0,+D36+1) >C37:/FL@IF(B37=0,0,@IF(B37=1,C36+1,C36)) >B37:@IF(@COUNT(B29...B37>N12,0,@IF9...E38)>N12,0,I19) >D38:@IF(@COUNT(D29...D38)>N12,0,+D37+1) >C38:/FL@IF(B38=0,0,@IF(B38=1,C37+1,C37)) >B38:@IF(@COUNT(B29...B38>N12,0,@IF(B37=12,1,B37+1)) >A38:+A37+1 >J37:/F$@IF(B37=0,0,+J36+G37) >I37:/F$@IF(B37=0,0,+I36+F37) >H37:/F$+H36-G37 >G37:/F$+E3(B29...B39>N12,0,@IF(B38=12,1,B38+1)) >A39:+A38+1 >J38:/F$@IF(B38=0,0,+J37+G38) >I38:/F$@IF(B38=0,0,+I37+F38) >H38:/F$+H37-G38 >G38:/F$+E38-F38 >F38:/F$@INT((+H37*I17/12)+.5)/100 >E38:/F$@IF(@COUNT(E29...E38)=N12,H37+(@INT(H37*I17/12+.5)/100),@IF(@COUNT(E2+H38-G39 >G39:/F$+E39-F39 >F39:/F$@INT((+H38*I17/12)+.5)/100 >E39:/F$@IF(@COUNT(E29...E39)=N12,H38+(@INT(H38*I17/12+.5)/100),@IF(@COUNT(E29...E39)>N12,0,I19) >D39:@IF(@COUNT(D29...D39)>N12,0,+D38+1) >C39:/FL@IF(B39=0,0,@IF(B39=1,C38+1,C38)) >B39:@IF(@COUNT)/100),@IF(@COUNT(E29...E40)>N12,0,I19) >D40:@IF(@COUNT(D29...D40)>N12,0,+D39+1) >C40:/FL@IF(B40=0,0,@IF(B40=1,C39+1,C39)) >B40:@IF(@COUNT(B29...B40>N12,0,@IF(B39=12,1,B39+1)) >A40:+A39+1 >J39:/F$@IF(B39=0,0,+J38+G39) >I39:/F$@IF(B39=0,0,+I38+F39) >H39:/F$40)) >B41:@IF(@COUNT(B29...B41>N12,0,@IF(B40=12,1,B40+1)) >A41:+A40+1 >J40:/F$@IF(B40=0,0,+J39+G40) >I40:/F$@IF(B40=0,0,+I39+F40) >H40:/F$+H39-G40 >G40:/F$+E40-F40 >F40:/F$@INT((+H39*I17/12)+.5)/100 >E40:/F$@IF(@COUNT(E29...E40)=N12,H39+(@INT(H39*I17/12+.50,+I40+F41) >H41:/F$+H40-G41 >G41:/F$+E41-F41 >F41:/F$@INT((+H40*I17/12)+.5)/100 >E41:/F$@IF(@COUNT(E29...E41)=N12,H40+(@INT(H40*I17/12+.5)/100),@IF(@COUNT(E29...E41)>N12,0,I19) >D41:@IF(@COUNT(D29...D41)>N12,0,+D40+1) >C41:/FL@IF(B41=0,0,@IF(B41=1,C40+1,C+(@INT(H41*I17/12+.5)/100),@IF(@COUNT(E29...E42)>N12,0,I19) >D42:@IF(@COUNT(D29...D42)>N12,0,+D41+1) >C42:/FL@IF(B42=0,0,@IF(B42=1,C41+1,C41)) >B42:@IF(@COUNT(B29...B42>N12,0,@IF(B41=12,1,B41+1)) >A42:+A41+1 >J41:/F$@IF(B41=0,0,+J40+G41) >I41:/F$@IF(B41=0,,0,@IF(B43=1,C42+1,C42)) >B43:@IF(@COUNT(B29...B43>N12,0,@IF(B42=12,1,B42+1)) >A43:+A42+1 >J42:/F$@IF(B42=0,0,+J41+G42) >I42:/F$@IF(B42=0,0,+I41+F42) >H42:/F$+H41-G42 >G42:/F$+E42-F42 >F42:/F$@INT((+H41*I17/12)+.5)/100 >E42:/F$@IF(@COUNT(E29...E42)=N12,H41) >I43:/F$@IF(B43=0,0,+I42+F43) >H43:/F$+H42-G43 >G43:/F$+E43-F43 >F43:/F$@INT((+H42*I17/12)+.5)/100 >E43:/F$@IF(@COUNT(E29...E43)=N12,H42+(@INT(H42*I17/12+.5)/100),@IF(@COUNT(E29...E43)>N12,0,I19) >D43:@IF(@COUNT(D29...D43)>N12,0,+D42+1) >C43:/FL@IF(B43=0T(E29...E44)=N12,H43+(@INT(H43*I17/12+.5)/100),@IF(@COUNT(E29...E44)>N12,0,I19) >D44:@IF(@COUNT(D29...D44)>N12,0,+D43+1) >C44:/FL@IF(B44=0,0,@IF(B44=1,C43+1,C43)) >B44:@IF(@COUNT(B29...B44>N12,0,@IF(B43=12,1,B43+1)) >A44:+A43+1 >J43:/F$@IF(B43=0,0,+J42+G431) >C45:/FL@IF(B45=0,0,@IF(B45=1,C44+1,C44)) >B45:@IF(@COUNT(B29...B45>N12,0,@IF(B44=12,1,B44+1)) >A45:+A44+1 >J44:/F$@IF(B44=0,0,+J43+G44) >I44:/F$@IF(B44=0,0,+I43+F44) >H44:/F$+H43-G44 >G44:/F$+E44-F44 >F44:/F$@INT((+H43*I17/12)+.5)/100 >E44:/F$@IF(@COUN+H34*I17/12)+.5)/100 >E35:/F$@IF(@COUNT(E29...E35)=N12,H34+(@INT(H34*I17/12+.5)/100),@IF(@COUNT(E29...E35)>N12,0,I19) >D35:@IF(@COUNT(D29...D35)>N12,0,+D34+1) >C35:/FL@IF(B35=0,0,@IF(B35=1,C34+1,C34)) >B35:@IF(@COUNT(B29...B35>N12,0,@IF(B34=12,1,B34+1)) >A35:+A34+1 >J34:/F$@IF(B34=0,0,+J33+G34) >I34:/F$@IF(B34=0,0,+I33+F34) >H34:/F$+H33-G34 >G34:/F$+E34-F34 >F34:/F$@INT((+H33*I17/12)+.5)/100 >E34:/F$@IF(@COUNT(E29...E34)=N12,H33+(@INT(H33*I17/12+.5)/100),@IF(@COUNT(E29...E34)>N12,0,I19) >D34:@IF(@COUNT(D29. >A12:+A11+1 >M11:"YMENT MADE >L11:"BALLOON PA >A11:+A10+1 >A10:+A9+1 >N9:" ........ >M9:"? MONTHS >L9:" BASED ON >A9:+A8+1 >M8:"YMENT >L8:"MONTHLY PAYM >A8:+A7+1 >A7:+A6+1 >N6:/F$" ........ >M6:"MOUNT >L6:"PROCEEDS AMOU >A6:+A5+1 >A5:+A4+1 >N4:"======:+A16+1 >M16:"T MADE IN >L16:"1ST PAYMENT >A16:+A15+1 >H15:" PAYMENT >G15:"TH BALLOON >F15:"IZATION WITH >E15:"LOAN AMORTI >A15:+A14+1 >N14:" ......... >M14:"ATE (APR) >L14:"INTEREST R >A14:+A13+1 >A13:+A12+1 >N12:" ........ >M12:"ONTH ? >L12:" IN WHAT M*100)/100 >H19:"YMENT : >G19:"MONTHLY PAY >E19:+F90 >D19:" : >C19:"INTEREST >A19:+A18+1 >A18:+A17+1 >N17:" ........ >M17:"R >L17:" WHAT YEAR >J17:"% >I17:+N14 >H17:"ATE : >G17:"INTEREST R >E17:/F$+N6 >D17:"MOUNT : >C17:"PROCEEDS A >A17+N9 >H21:" : >G21:"TERM >E21:/F$+E19+E17 >D21:"AYMENTS : >C21:"TOTAL OF P >A21:+A20+1 >N20:" ........ >M20:"TH-1 TO 12 >L20:" WHAT MONTH >A20:+A19+1 >M19:"T MADE IN >L19:"1ST PAYMENT >I19:/F$@INT((N6/(1-((1+(N14/100/12))^-N9)/(N14/100/12)))+.005RECALCULATI >A25:+A24+1 >N24:"TWO >M24:" REQUIRES >L24:" >A24:+A23+1 >N23:"RAM >M23:" THIS PROGR >L23:"**** NOTE: >I23:/FI+N12 >H23:"RIOD : >G23:"PAYMENT PE >E23:@MAX(E29...E88) >D23:"YMENT : >C23:"BALLOON PAY >A23:+A22+1 >A22:+A21+1 >I21:ST >H27:" BALANCE >G27:" PAYMENT >F27:" PAYMENT >E27:" PAYMENT >D27:" PAYMENT # >C27:" YEAR >B27:" MONTH >A27:+A26+1 >J26:" ACCUM. >I26:" ACCUM. >H26:" LOAN >G26:" PRINCIPAL >F26:" INTEREST >E26:/FG" AMOUNT OF >A26:+A25+1 >N25:"IONS. **** >M25:" MAXIMUM T >J28:" ========= >I28:" ========= >H28:" ========= >G28:" ========= >F28:" ========= >E28:" ========= >D28:" ========= >C28:" ===== >B28:" ====== >A28:+A27+1 >N27:"EPORT. >M27:"" TO RUN REP >L27:" GOTO "B15" TO >J27:" PRINCIPAL >I27:" INTERE:@IF(@COUNT(B29...B30>N9,0,@IF(B29=12,1,B29+1)) >A30:+A29+1 >J29:/F$+G29 >I29:/F$+F29 >H29:/F$+E17-G29 >G29:/F$+E29-F29 >F29:/FG@INT(+E17*(I17/100)/12+.005*100)/100 >E29:/F$+I19 >D29:1 >C29:/FL+N17 >B29:+N20 >A29:+A28+1 >N28:"MONTHS. >M28:"ERM IS 60 >L28:"F30 >H30:/F$+H29-G30 >G30:/F$+E30-F30 >F30:/F$@INT((+H29*I17/12)+.5)/100 >E30:/F$@IF(@COUNT(E29...E30)=N12,H29+(@INT(H29*I17/12+.5)/100),@IF(@COUNT(E29...E30)>N12,0,I19) >D30:@IF(@COUNT(D29...D30)>N9,0,+D29+1) >C30:/FL@IF(B30=0,0,@IF(B30=1,C29+1,C29)) >B30E29...E31)=N12,H30+(@INT(H30*I17/12+.5)/100),@IF(@COUNT(E29...E31)>N12,0,I19) >D31:@IF(@COUNT(D29...D31)>N12,0,+D30+1) >C31:/FL@IF(B31=0,0,@IF(B31=1,C30+1,C30)) >B31:@IF(@COUNT(B29...B31>N12,0,@IF(B30=12,1,B30+1)) >A31:+A30+1 >J30:/F$+J29+G30 >I30:/F$+I29+ >C32:/FL@IF(B32=0,0,@IF(B32=1,C31+1,C31)) >B32:@IF(@COUNT(B29...B32>N12,0,@IF(B31=12,1,B31+1)) >A32:+A31+1 >J31:/F$@IF(B31=0,0,+J30+G31) >I31:/F$@IF(B31=0,0,+I30+F31) >H31:/F$+H30-G31 >G31:/F$+E31-F31 >F31:/F$@INT((+H30*I17/12)+.5)/100 >E31:/F$@IF(@COUNT(F(B32=0,0,+J31+G32) >I32:/F$@IF(B32=0,0,+I31+F32) >H32:/F$+H31-G32 >G32:/F$+E32-F32 >F32:/F$@INT((+H31*I17/12)+.5)/100 >E32:/F$@IF(@COUNT(E29...E32)=N12,H31+(@INT(H31*I17/12+.5)/100),@IF(@COUNT(E29...E32)>N12,0,I19) >D32:@IF(@COUNT(D29...D32)>N12,0,+D31+1) >E33:/F$@IF(@COUNT(E29...E33)=N12,H32+(@INT(H32*I17/12+.5)/100),@IF(@COUNT(E29...E33)>N12,0,I19) >D33:@IF(@COUNT(D29...D33)>N12,0,+D32+1) >C33:/FL@IF(B33=0,0,@IF(B33=1,C32+1,C32)) >B33:@IF(@COUNT(B29...B33>N12,0,@IF(B32=12,1,B32+1)) >A33:+A32+1 >J32:/F$@I..D34)>N12,0,+D33+1) >C34:/FL@IF(B34=0,0,@IF(B34=1,C33+1,C33)) >B34:@IF(@COUNT(B29...B34>N12,0,@IF(B33=12,1,B33+1)) >A34:+A33+1 >J33:/F$@IF(B33=0,0,+J32+G33) >I33:/F$@IF(B33=0,0,+I32+F33) >H33:/F$+H32-G33 >G33:/F$+E33-F33 >F33:/F$@INT((+H32*I17/12)+.5)/100===== >M4:"=========== >L4:"========== >A4:+A3+1 >M3:"OAN >L3:"TERMS OF LOAN >A3:3 >L2:" >E2:"ON >D2:" AMORTIZAT >C2:"YMENT LOAN >B2:"BALLOON PA >A2:"MODEL 1 - >N1:" N >M1:" M >L1:" L >K1:" K >J1:" J >I1:" I >H1:" H >G1:" G >F1:" F >E1:" E >D1:" D >C1:" C >B1:" B /W1 /GOR /GRM /GC10 /X>A1:>A1: /PSLY /PSBY /PSTY /PS#Y /PSP55 /PSW70 /PSF66 /PSM0 /PSR 6:/F$@INT((+H85*I20/12)+.5)/100 >E86:/FG@IF(B86=0,0,@IF(@COUNT(E33...E86)D86:@IF(@COUNT(D33...D86)>N9,0,+D85+1) >C86:/FL@IF(B86=0,0,@IF(B86=1,C85+1,C85)) >B86:@IF(@COUNT(B33...B86>N9,0,@IF(B85=12,/100),I22))) >D87:@IF(@COUNT(D33...D87)>N9,0,+D86+1) >C87:/FL@IF(B87=0,0,@IF(B87=1,C86+1,C86)) >B87:@IF(@COUNT(B33...B87>N9,0,@IF(B86=12,1,B86+1)) >A87:+A86+1 >J86:/F$@IF(B86=0,0,+J85+G86) >I86:/F$@IF(B86=0,0,+I85+F86) >H86:/F$+H85-G86 >G86:/F$+E86-F86 >F88>N9,0,@IF(B87=12,1,B87+1)) >A88:+A87+1 >J87:/F$@IF(B87=0,0,+J86+G87) >I87:/F$@IF(B87=0,0,+I86+F87) >H87:/F$+H86-G87 >G87:/F$+E87-F87 >F87:/F$@INT((+H86*I20/12)+.5)/100 >E87:/FG@IF(B87=0,0,@IF(@COUNT(E33...E87)F88:/F$@INT((+H87*I20/12)+.5)/100 >E88:/FG@IF(B88=0,0,@IF(@COUNT(E33...E88)D88:@IF(@COUNT(D33...D88)>N9,0,+D87+1) >C88:/FL@IF(B88=0,0,@IF(B88=1,C87+1,C87)) >B88:@IF(@COUNT(B33...B8T((H88*I20/12)+.5)/100),I22))) >D89:@IF(@COUNT(D33...D89)>N9,0,+D88+1) >C89:/FL@IF(B89=0,0,@IF(B89=1,C88+1,C88)) >B89:@IF(@COUNT(B33...B89>N9,0,@IF(B88=12,1,B88+1)) >A89:+A88+1 >J88:/F$@IF(B88=0,0,+J87+G88) >I88:/F$@IF(B88=0,0,+I87+F88) >H88:/F$+H87-G88 >GIF(@COUNT(B33...B90>N9,0,@IF(B89=12,1,B89+1)) >A90:+A89+1 >J89:/F$@IF(B89=0,0,+J88+G89) >I89:/F$@IF(B89=0,0,+I88+F89) >H89:/F$+H88-G89 >G89:/F$+E89-F89 >F89:/F$@INT((+H88*I20/12)+.5)/100 >E89:/FG@IF(B89=0,0,@IF(@COUNT(E33...E89)G90:/F$+E90-F90 >F90:/F$@INT((+H89*I20/12)+.5)/100 >E90:/FG@IF(B90=0,0,@IF(@COUNT(E33...E90)D90:@IF(@COUNT(D33...D90)>N9,0,+D89+1) >C90:/FL@IF(B90=0,0,@IF(B90=1,C89+1,C89)) >B90:@IF(D91=N9,H90+(@INT((H90*I20/12)+.5)/100),I22))) >D91:@IF(@COUNT(D33...D91)>N9,0,+D90+1) >C91:/FL@IF(B91=0,0,@IF(B91=1,C90+1,C90)) >B91:@IF(@COUNT(B33...B91>N9,0,@IF(B90=12,1,B90+1)) >A91:+A90+1 >J90:/F$@IF(B90=0,0,+J89+G90) >I90:/F$@IF(B90=0,0,+I89+F90) >C91+1,C91)) >B92:@IF(@COUNT(B33...B92>N9,0,@IF(B91=12,1,B91+1)) >A92:+A91+1 >J91:/F$@IF(B91=0,0,+J90+G91) >I91:/F$@IF(B91=0,0,+I90+F91) >H91:/F$+H90-G91 >G91:/F$+E91-F91 >F91:/F$@INT((+H90*I20/12)+.5)/100 >E91:/FG@IF(B91=0,0,@IF(@COUNT(E33...E91)?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghij92=0,0,+I91+F92) >H92:/F$+H91-G92 >G92:/F$+E92-F92 >F92:/F$@INT((+H91*I20/12)+.5)/100 >E92:/FG@IF(B92=0,0,@IF(@COUNT(E33...E92)D92:@IF(@COUNT(D33...D92)>N9,0,+D91+1) >C92:/FL@IF(B92=0,0,@IF(B92=1,>G95:" ========= >F95:" ========= >E95:" ========= >A95:+A94+1 >G94:/F$@SUM(G33...G93) >F94:/F$@SUM(F33...F93) >E94:/F$@SUM(E33...E93) >A94:+A93+1 >G93:" ---------- >F93:" ---------- >E93:" ---------- >A93:+A92+1 >J92:/F$@IF(B92=0,0,+J91+G92) >I92:/F$@IF(B1,B85+1)) >A86:+A85+1 >J85:/F$@IF(B85=0,0,+J84+G85) >I85:/F$@IF(B85=0,0,+I84+F85) >H85:/F$+H84-G85 >G85:/F$+E85-F85 >F85:/F$@INT((+H84*I20/12)+.5)/100 >E85:/FG@IF(B85=0,0,@IF(@COUNT(E33...E85)D85:@IF(@COUNT(D33...D85)>N9,0,+D84+1) >C85:/FL@IF(B85=0,0,@IF(B85=1,C84+1,C84)) >B85:@IF(@COUNT(B33...B85>N9,0,@IF(B84=12,1,B84+1)) >A85:+A84+1 >J84:/F$@IF(B84=0,0,+J83+G84) >I84:/F$@IF(B84=0,0,+I83+F84) >H84:/F$+H83-G84 >G84:/F$+E84-F84 >F84:/F$@INT((+H83*I2+H74-G75 >G75:/F$+E75-F75 >F75:/F$@INT((+H74*I20/12)+.5)/100 >E75:/FG@IF(B75=0,0,@IF(@COUNT(E33...E75)D75:@IF(@COUNT(D33...D75)>N9,0,+D74+1) >C75:/FL@IF(B75=0,0,@IF(B75=1,C74+1,C74)) >B75:@IF(@COUN9,H75+(@INT((H75*I20/12)+.5)/100),I22))) >D76:@IF(@COUNT(D33...D76)>N9,0,+D75+1) >C76:/FL@IF(B76=0,0,@IF(B76=1,C75+1,C75)) >B76:@IF(@COUNT(B33...B76>N9,0,@IF(B75=12,1,B75+1)) >A76:+A75+1 >J75:/F$@IF(B75=0,0,+J74+G75) >I75:/F$@IF(B75=0,0,+I74+F75) >H75:/F$76)) >B77:@IF(@COUNT(B33...B77>N9,0,@IF(B76=12,1,B76+1)) >A77:+A76+1 >J76:/F$@IF(B76=0,0,+J75+G76) >I76:/F$@IF(B76=0,0,+I75+F76) >H76:/F$+H75-G76 >G76:/F$+E76-F76 >F76:/F$@INT((+H75*I20/12)+.5)/100 >E76:/FG@IF(B76=0,0,@IF(@COUNT(E33...E76)H77:/F$+H76-G77 >G77:/F$+E77-F77 >F77:/F$@INT((+H76*I20/12)+.5)/100 >E77:/FG@IF(B77=0,0,@IF(@COUNT(E33...E77)D77:@IF(@COUNT(D33...D77)>N9,0,+D76+1) >C77:/FL@IF(B77=0,0,@IF(B77=1,C76+1,C)D78:@IF(@COUNT(D33...D78)>N9,0,+D77+1) >C78:/FL@IF(B78=0,0,@IF(B78=1,C77+1,C77)) >B78:@IF(@COUNT(B33...B78>N9,0,@IF(B77=12,1,B77+1)) >A78:+A77+1 >J77:/F$@IF(B77=0,0,+J76+G77) >I77:/F$@IF(B77=0,0,,@IF(B79=1,C78+1,C78)) >B79:@IF(@COUNT(B33...B79>N9,0,@IF(B78=12,1,B78+1)) >A79:+A78+1 >J78:/F$@IF(B78=0,0,+J77+G78) >I78:/F$@IF(B78=0,0,+I77+F78) >H78:/F$+H77-G78 >G78:/F$+E78-F78 >F78:/F$@INT((+H77*I20/12)+.5)/100 >E78:/FG@IF(B78=0,0,@IF(@COUNT(E33...E7879:/F$@IF(B79=0,0,+I78+F79) >H79:/F$+H78-G79 >G79:/F$+E79-F79 >F79:/F$@INT((+H78*I20/12)+.5)/100 >E79:/FG@IF(B79=0,0,@IF(@COUNT(E33...E79)D79:@IF(@COUNT(D33...D79)>N9,0,+D78+1) >C79:/FL@IF(B79=0,0F(@COUNT(E33...E80)D80:@IF(@COUNT(D33...D80)>N9,0,+D79+1) >C80:/FL@IF(B80=0,0,@IF(B80=1,C79+1,C79)) >B80:@IF(@COUNT(B33...B80>N9,0,@IF(B79=12,1,B79+1)) >A80:+A79+1 >J79:/F$@IF(B79=0,0,+J78+G79) >IC81:/FL@IF(B81=0,0,@IF(B81=1,C80+1,C80)) >B81:@IF(@COUNT(B33...B81>N9,0,@IF(B80=12,1,B80+1)) >A81:+A80+1 >J80:/F$@IF(B80=0,0,+J79+G80) >I80:/F$@IF(B80=0,0,+I79+F80) >H80:/F$+H79-G80 >G80:/F$+E80-F80 >F80:/F$@INT((+H79*I20/12)+.5)/100 >E80:/FG@IF(B80=0,0,@I1=0,0,+J80+G81) >I81:/F$@IF(B81=0,0,+I80+F81) >H81:/F$+H80-G81 >G81:/F$+E81-F81 >F81:/F$@INT((+H80*I20/12)+.5)/100 >E81:/FG@IF(B81=0,0,@IF(@COUNT(E33...E81)D81:@IF(@COUNT(D33...D81)>N9,0,+D80+1) >:/FG@IF(B82=0,0,@IF(@COUNT(E33...E82)D82:@IF(@COUNT(D33...D82)>N9,0,+D81+1) >C82:/FL@IF(B82=0,0,@IF(B82=1,C81+1,C81)) >B82:@IF(@COUNT(B33...B82>N9,0,@IF(B81=12,1,B81+1)) >A82:+A81+1 >J81:/F$@IF(B883)>N9,0,+D82+1) >C83:/FL@IF(B83=0,0,@IF(B83=1,C82+1,C82)) >B83:@IF(@COUNT(B33...B83>N9,0,@IF(B82=12,1,B82+1)) >A83:+A82+1 >J82:/F$@IF(B82=0,0,+J81+G82) >I82:/F$@IF(B82=0,0,+I81+F82) >H82:/F$+H81-G82 >G82:/F$+E82-F82 >F82:/F$@INT((+H81*I20/12)+.5)/100 >E823+1 >J83:/F$@IF(B83=0,0,+J82+G83) >I83:/F$@IF(B83=0,0,+I82+F83) >H83:/F$+H82-G83 >G83:/F$+E83-F83 >F83:/F$@INT((+H82*I20/12)+.5)/100 >E83:/FG@IF(B83=0,0,@IF(@COUNT(E33...E83)D83:@IF(@COUNT(D33...D0/12)+.5)/100 >E84:/FG@IF(B84=0,0,@IF(@COUNT(E33...E84)D84:@IF(@COUNT(D33...D84)>N9,0,+D83+1) >C84:/FL@IF(B84=0,0,@IF(B84=1,C83+1,C83)) >B84:@IF(@COUNT(B33...B84>N9,0,@IF(B83=12,1,B83+1)) >A84:+A8NT(B33...B75>N9,0,@IF(B74=12,1,B74+1)) >A75:+A74+1 >J74:/F$@IF(B74=0,0,+J73+G74) >I74:/F$@IF(B74=0,0,+I73+F74) >H74:/F$+H73-G74 >G74:/F$+E74-F74 >F74:/F$@INT((+H73*I20/12)+.5)/100 >E74:/FG@IF(B74=0,0,@IF(@COUNT(E33...E74)D74:@IF(@COUNT(D33...D74)>N9,0,+D73+1) >C74:/FL@IF(B74=0,0,@IF(B74=1,C73+1,C73)) >B74:@IF(@COUNT(B33...B74>N9,0,@IF(B73=12,1,B73+1)) >A74:+A73+1 >J73:/F$@IF(B73=0,0,+J72+G73) >I73:/F$@IF(B73=0,0,+I72+F73) >H73:/F$+H72-G73 >G73:/F$+IF(B64=0,0,+I63+F64) >H64:/F$+H63-G64 >G64:/F$+E64-F64 >F64:/F$@INT((+H63*I20/12)+.5)/100 >E64:/FG@IF(B64=0,0,@IF(@COUNT(E33...E64)D64:@IF(@COUNT(D33...D64)>N9,0,+D63+1) >C64:/FL@IF(B64=0,0,@IF(B6T(E33...E65)D65:@IF(@COUNT(D33...D65)>N9,0,+D64+1) >C65:/FL@IF(B65=0,0,@IF(B65=1,C64+1,C64)) >B65:@IF(@COUNT(B33...B65>N9,0,@IF(B64=12,1,B64+1)) >A65:+A64+1 >J64:/F$@IF(B64=0,0,+J63+G64) >I64:/F$@@IF(B66=0,0,@IF(B66=1,C65+1,C65)) >B66:@IF(@COUNT(B33...B66>N9,0,@IF(B65=12,1,B65+1)) >A66:+A65+1 >J65:/F$@IF(B65=0,0,+J64+G65) >I65:/F$@IF(B65=0,0,+I64+F65) >H65:/F$+H64-G65 >G65:/F$+E65-F65 >F65:/F$@INT((+H64*I20/12)+.5)/100 >E65:/FG@IF(B65=0,0,@IF(@COUNJ65+G66) >I66:/F$@IF(B66=0,0,+I65+F66) >H66:/F$+H65-G66 >G66:/F$+E66-F66 >F66:/F$@INT((+H65*I20/12)+.5)/100 >E66:/FG@IF(B66=0,0,@IF(@COUNT(E33...E66)D66:@IF(@COUNT(D33...D66)>N9,0,+D65+1) >C66:/FL(B67=0,0,@IF(@COUNT(E33...E67)D67:@IF(@COUNT(D33...D67)>N9,0,+D66+1) >C67:/FL@IF(B67=0,0,@IF(B67=1,C66+1,C66)) >B67:@IF(@COUNT(B33...B67>N9,0,@IF(B66=12,1,B66+1)) >A67:+A66+1 >J66:/F$@IF(B66=0,0,+0,+D67+1) >C68:/FL@IF(B68=0,0,@IF(B68=1,C67+1,C67)) >B68:@IF(@COUNT(B33...B68>N9,0,@IF(B67=12,1,B67+1)) >A68:+A67+1 >J67:/F$@IF(B67=0,0,+J66+G67) >I67:/F$@IF(B67=0,0,+I66+F67) >H67:/F$+H66-G67 >G67:/F$+E67-F67 >F67:/F$@INT((+H66*I20/12)+.5)/100 >E67:/FG@IF8:/F$@IF(B68=0,0,+J67+G68) >I68:/F$@IF(B68=0,0,+I67+F68) >H68:/F$+H67-G68 >G68:/F$+E68-F68 >F68:/F$@INT((+H67*I20/12)+.5)/100 >E68:/FG@IF(B68=0,0,@IF(@COUNT(E33...E68)D68:@IF(@COUNT(D33...D68)>N9,5)/100 >E69:/FG@IF(B69=0,0,@IF(@COUNT(E33...E69)D69:@IF(@COUNT(D33...D69)>N9,0,+D68+1) >C69:/FL@IF(B69=0,0,@IF(B69=1,C68+1,C68)) >B69:@IF(@COUNT(B33...B69>N9,0,@IF(B68=12,1,B68+1)) >A69:+A68+1 >J6UNT(D33...D70)>N9,0,+D69+1) >C70:/FL@IF(B70=0,0,@IF(B70=1,C69+1,C69)) >B70:@IF(@COUNT(B33...B70>N9,0,@IF(B69=12,1,B69+1)) >A70:+A69+1 >J69:/F$@IF(B69=0,0,+J68+G69) >I69:/F$@IF(B69=0,0,+I68+F69) >H69:/F$+H68-G69 >G69:/F$+E69-F69 >F69:/F$@INT((+H68*I20/12)+.)) >A71:+A70+1 >J70:/F$@IF(B70=0,0,+J69+G70) >I70:/F$@IF(B70=0,0,+I69+F70) >H70:/F$+H69-G70 >G70:/F$+E70-F70 >F70:/F$@INT((+H69*I20/12)+.5)/100 >E70:/FG@IF(B70=0,0,@IF(@COUNT(E33...E70)D70:@IF(@CONT((+H70*I20/12)+.5)/100 >E71:/FG@IF(B71=0,0,@IF(@COUNT(E33...E71)D71:@IF(@COUNT(D33...D71)>N9,0,+D70+1) >C71:/FL@IF(B71=0,0,@IF(B71=1,C70+1,C70)) >B71:@IF(@COUNT(B33...B71>N9,0,@IF(B70=12,1,B70+122))) >D72:@IF(@COUNT(D33...D72)>N9,0,+D71+1) >C72:/FL@IF(B72=0,0,@IF(B72=1,C71+1,C71)) >B72:@IF(@COUNT(B33...B72>N9,0,@IF(B71=12,1,B71+1)) >A72:+A71+1 >J71:/F$@IF(B71=0,0,+J70+G71) >I71:/F$@IF(B71=0,0,+I70+F71) >H71:/F$+H70-G71 >G71:/F$+E71-F71 >F71:/F$@I@IF(B72=12,1,B72+1)) >A73:+A72+1 >J72:/F$@IF(B72=0,0,+J71+G72) >I72:/F$@IF(B72=0,0,+I71+F72) >H72:/F$+H71-G72 >G72:/F$+E72-F72 >F72:/F$@INT((+H71*I20/12)+.5)/100 >E72:/FG@IF(B72=0,0,@IF(@COUNT(E33...E72)F73:/F$@INT((+H72*I20/12)+.5)/100 >E73:/FG@IF(B73=0,0,@IF(@COUNT(E33...E73)D73:@IF(@COUNT(D33...D73)>N9,0,+D72+1) >C73:/FL@IF(B73=0,0,@IF(B73=1,C72+1,C72)) >B73:@IF(@COUNT(B33...B73>N9,0,4=1,C63+1,C63)) >B64:@IF(@COUNT(B33...B64>N9,0,@IF(B63=12,1,B63+1)) >A64:+A63+1 >J63:/F$@IF(B63=0,0,+J62+G63) >I63:/F$@IF(B63=0,0,+I62+F63) >H63:/F$+H62-G63 >G63:/F$+E63-F63 >F63:/F$@INT((+H62*I20/12)+.5)/100 >E63:/FG@IF(B63=0,0,@IF(@COUNT(E33...E63)D63:@IF(@COUNT(D33...D63)>N9,0,+D62+1) >C63:/FL@IF(B63=0,0,@IF(B63=1,C62+1,C62)) >B63:@IF(@COUNT(B33...B63>N9,0,@IF(B62=12,1,B62+1)) >A63:+A62+1 >J62:/F$@IF(B62=0,0,+J61+G62) >I62:/F$@IF(B62=0,0,+I61+F6F(B53=0,0,+J52+G53) >I53:/F$@IF(B53=0,0,+I52+F53) >H53:/F$+H52-G53 >G53:/F$+E53-F53 >F53:/F$@INT((+H52*I20/12)+.5)/100 >E53:/FG@IF(B53=0,0,@IF(@COUNT(E33...E53)D53:@IF(@COUNT(D33...D53)>N9,0,+D52+>E54:/FG@IF(B54=0,0,@IF(@COUNT(E33...E54)D54:@IF(@COUNT(D33...D54)>N9,0,+D53+1) >C54:/FL@IF(B54=0,0,@IF(B54=1,C53+1,C53)) >B54:@IF(@COUNT(B33...B54>N9,0,@IF(B53=12,1,B53+1)) >A54:+A53+1 >J53:/F$@I...D55)>N9,0,+D54+1) >C55:/FL@IF(B55=0,0,@IF(B55=1,C54+1,C54)) >B55:@IF(@COUNT(B33...B55>N9,0,@IF(B54=12,1,B54+1)) >A55:+A54+1 >J54:/F$@IF(B54=0,0,+J53+G54) >I54:/F$@IF(B54=0,0,+I53+F54) >H54:/F$+H53-G54 >G54:/F$+E54-F54 >F54:/F$@INT((+H53*I20/12)+.5)/100 :+A55+1 >J55:/F$@IF(B55=0,0,+J54+G55) >I55:/F$@IF(B55=0,0,+I54+F55) >H55:/F$+H54-G55 >G55:/F$+E55-F55 >F55:/F$@INT((+H54*I20/12)+.5)/100 >E55:/FG@IF(B55=0,0,@IF(@COUNT(E33...E55)D55:@IF(@COUNT(D335*I20/12)+.5)/100 >E56:/FG@IF(B56=0,0,@IF(@COUNT(E33...E56)D56:@IF(@COUNT(D33...D56)>N9,0,+D55+1) >C56:/FL@IF(B56=0,0,@IF(B56=1,C55+1,C55)) >B56:@IF(@COUNT(B33...B56>N9,0,@IF(B55=12,1,B55+1)) >A56D57:@IF(@COUNT(D33...D57)>N9,0,+D56+1) >C57:/FL@IF(B57=0,0,@IF(B57=1,C56+1,C56)) >B57:@IF(@COUNT(B33...B57>N9,0,@IF(B56=12,1,B56+1)) >A57:+A56+1 >J56:/F$@IF(B56=0,0,+J55+G56) >I56:/F$@IF(B56=0,0,+I55+F56) >H56:/F$+H55-G56 >G56:/F$+E56-F56 >F56:/F$@INT((+H5=12,1,B57+1)) >A58:+A57+1 >J57:/F$@IF(B57=0,0,+J56+G57) >I57:/F$@IF(B57=0,0,+I56+F57) >H57:/F$+H56-G57 >G57:/F$+E57-F57 >F57:/F$@INT((+H56*I20/12)+.5)/100 >E57:/FG@IF(B57=0,0,@IF(@COUNT(E33...E57) >F58:/F$@INT((+H57*I20/12)+.5)/100 >E58:/FG@IF(B58=0,0,@IF(@COUNT(E33...E58)D58:@IF(@COUNT(D33...D58)>N9,0,+D57+1) >C58:/FL@IF(B58=0,0,@IF(B58=1,C57+1,C57)) >B58:@IF(@COUNT(B33...B58>N9,0,@IF(B57+.5)/100),I22))) >D59:@IF(@COUNT(D33...D59)>N9,0,+D58+1) >C59:/FL@IF(B59=0,0,@IF(B59=1,C58+1,C58)) >B59:@IF(@COUNT(B33...B59>N9,0,@IF(B58=12,1,B58+1)) >A59:+A58+1 >J58:/F$@IF(B58=0,0,+J57+G58) >I58:/F$@IF(B58=0,0,+I57+F58) >H58:/F$+H57-G58 >G58:/F$+E58-F58..B60>N9,0,@IF(B59=12,1,B59+1)) >A60:+A59+1 >J59:/F$@IF(B59=0,0,+J58+G59) >I59:/F$@IF(B59=0,0,+I58+F59) >H59:/F$+H58-G59 >G59:/F$+E59-F59 >F59:/F$@INT((+H58*I20/12)+.5)/100 >E59:/FG@IF(B59=0,0,@IF(@COUNT(E33...E59)G60:/F$+E60-F60 >F60:/F$@INT((+H59*I20/12)+.5)/100 >E60:/FG@IF(B60=0,0,@IF(@COUNT(E33...E60)D60:@IF(@COUNT(D33...D60)>N9,0,+D59+1) >C60:/FL@IF(B60=0,0,@IF(B60=1,C59+1,C59)) >B60:@IF(@COUNT(B33.(@INT((H60*I20/12)+.5)/100),I22))) >D61:@IF(@COUNT(D33...D61)>N9,0,+D60+1) >C61:/FL@IF(B61=0,0,@IF(B61=1,C60+1,C60)) >B61:@IF(@COUNT(B33...B61>N9,0,@IF(B60=12,1,B60+1)) >A61:+A60+1 >J60:/F$@IF(B60=0,0,+J59+G60) >I60:/F$@IF(B60=0,0,+I59+F60) >H60:/F$+H59-G662:@IF(@COUNT(B33...B62>N9,0,@IF(B61=12,1,B61+1)) >A62:+A61+1 >J61:/F$@IF(B61=0,0,+J60+G61) >I61:/F$@IF(B61=0,0,+I60+F61) >H61:/F$+H60-G61 >G61:/F$+E61-F61 >F61:/F$@INT((+H60*I20/12)+.5)/100 >E61:/FG@IF(B61=0,0,@IF(@COUNT(E33...E61)H62:/F$+H61-G62 >G62:/F$+E62-F62 >F62:/F$@INT((+H61*I20/12)+.5)/100 >E62:/FG@IF(B62=0,0,@IF(@COUNT(E33...E62)D62:@IF(@COUNT(D33...D62)>N9,0,+D61+1) >C62:/FL@IF(B62=0,0,@IF(B62=1,C61+1,C61)) >B1) >C53:/FL@IF(B53=0,0,@IF(B53=1,C52+1,C52)) >B53:@IF(@COUNT(B33...B53>N9,0,@IF(B52=12,1,B52+1)) >A53:+A52+1 >J52:/F$@IF(B52=0,0,+J51+G52) >I52:/F$@IF(B52=0,0,+I51+F52) >H52:/F$+H51-G52 >G52:/F$+E52-F52 >F52:/F$@INT((+H51*I20/12)+.5)/100 >E52:/FG@IF(B52=0,0,@IF(@COUNT(E33...E52)D52:@IF(@COUNT(D33...D52)>N9,0,+D51+1) >C52:/FL@IF(B52=0,0,@IF(B52=1,C51+1,C51)) >B52:@IF(@COUNT(B33...B52>N9,0,@IF(B51=12,1,B51+1)) >A52:+A51+1 >J51:/F$@IF(B51=0,0,+J50+G5142+1)) >A43:+A42+1 >J42:/F$@IF(B42=0,0,+J41+G42) >I42:/F$@IF(B42=0,0,+I41+F42) >H42:/F$+H41-G42 >G42:/F$+E42-F42 >F42:/F$@INT((+H41*I20/12)+.5)/100 >E42:/FG@IF(B42=0,0,@IF(@COUNT(E33...E42)D42:@IFF$@INT((+H42*I20/12)+.5)/100 >E43:/FG@IF(B43=0,0,@IF(@COUNT(E33...E43)D43:@IF(@COUNT(D33...D43)>N9,0,+D42+1) >C43:/FL@IF(B43=0,0,@IF(B43=1,C42+1,C42)) >B43:@IF(@COUNT(B33...B43>N9,0,@IF(B42=12,1,B0),I22))) >D44:@IF(@COUNT(D33...D44)>N9,0,+D43+1) >C44:/FL@IF(B44=0,0,@IF(B44=1,C43+1,C43)) >B44:@IF(@COUNT(B33...B44>N9,0,@IF(B43=12,1,B43+1)) >A44:+A43+1 >J43:/F$@IF(B43=0,0,+J42+G43) >I43:/F$@IF(B43=0,0,+I42+F43) >H43:/F$+H42-G43 >G43:/F$+E43-F43 >F43:/9,0,@IF(B44=12,1,B44+1)) >A45:+A44+1 >J44:/F$@IF(B44=0,0,+J43+G44) >I44:/F$@IF(B44=0,0,+I43+F44) >H44:/F$+H43-G44 >G44:/F$+E44-F44 >F44:/F$@INT((+H43*I20/12)+.5)/100 >E44:/FG@IF(B44=0,0,@IF(@COUNT(E33...E44)F45:/F$@INT((+H44*I20/12)+.5)/100 >E45:/FG@IF(B45=0,0,@IF(@COUNT(E33...E45)D45:@IF(@COUNT(D33...D45)>N9,0,+D44+1) >C45:/FL@IF(B45=0,0,@IF(B45=1,C44+1,C44)) >B45:@IF(@COUNT(B33...B45>NH45*I20/12)+.5)/100),I22))) >D46:@IF(@COUNT(D33...D46)>N9,0,+D45+1) >C46:/FL@IF(B46=0,0,@IF(B46=1,C45+1,C45)) >B46:@IF(@COUNT(B33...B46>N9,0,@IF(B45=12,1,B45+1)) >A46:+A45+1 >J45:/F$@IF(B45=0,0,+J44+G45) >I45:/F$@IF(B45=0,0,+I44+F45) >H45:/F$+H44-G45 >G45:@COUNT(B33...B47>N9,0,@IF(B46=12,1,B46+1)) >A47:+A46+1 >J46:/F$@IF(B46=0,0,+J45+G46) >I46:/F$@IF(B46=0,0,+I45+F46) >H46:/F$+H45-G46 >G46:/F$+E46-F46 >F46:/F$@INT((+H45*I20/12)+.5)/100 >E46:/FG@IF(B46=0,0,@IF(@COUNT(E33...E46)G47:/F$+E47-F47 >F47:/F$@INT((+H46*I20/12)+.5)/100 >E47:/FG@IF(B47=0,0,@IF(@COUNT(E33...E47)D47:@IF(@COUNT(D33...D47)>N9,0,+D46+1) >C47:/FL@IF(B47=0,0,@IF(B47=1,C46+1,C46)) >B47:@IF(D48=N9,H47+(@INT((H47*I20/12)+.5)/100),I22))) >D48:@IF(@COUNT(D33...D48)>N9,0,+D47+1) >C48:/FL@IF(B48=0,0,@IF(B48=1,C47+1,C47)) >B48:@IF(@COUNT(B33...B48>N9,0,@IF(B47=12,1,B47+1)) >A48:+A47+1 >J47:/F$@IF(B47=0,0,+J46+G47) >I47:/F$@IF(B47=0,0,+I46+F47) >H47+1,C48)) >B49:@IF(@COUNT(B33...B49>N9,0,@IF(B48=12,1,B48+1)) >A49:+A48+1 >J48:/F$@IF(B48=0,0,+J47+G48) >I48:/F$@IF(B48=0,0,+I47+F48) >H48:/F$+H47-G48 >G48:/F$+E48-F48 >F48:/F$@INT((+H47*I20/12)+.5)/100 >E48:/FG@IF(B48=0,0,@IF(@COUNT(E33...E48)H49:/F$+H48-G49 >G49:/F$+E49-F49 >F49:/F$@INT((+H48*I20/12)+.5)/100 >E49:/FG@IF(B49=0,0,@IF(@COUNT(E33...E49)D49:@IF(@COUNT(D33...D49)>N9,0,+D48+1) >C49:/FL@IF(B49=0,0,@IF(B49=1,C48.E50)D50:@IF(@COUNT(D33...D50)>N9,0,+D49+1) >C50:/FL@IF(B50=0,0,@IF(B50=1,C49+1,C49)) >B50:@IF(@COUNT(B33...B50>N9,0,@IF(B49=12,1,B49+1)) >A50:+A49+1 >J49:/F$@IF(B49=0,0,+J48+G49) >I49:/F$@IF(B49==0,0,@IF(B51=1,C50+1,C50)) >B51:@IF(@COUNT(B33...B51>N9,0,@IF(B50=12,1,B50+1)) >A51:+A50+1 >J50:/F$@IF(B50=0,0,+J49+G50) >I50:/F$@IF(B50=0,0,+I49+F50) >H50:/F$+H49-G50 >G50:/F$+E50-F50 >F50:/F$@INT((+H49*I20/12)+.5)/100 >E50:/FG@IF(B50=0,0,@IF(@COUNT(E33..) >I51:/F$@IF(B51=0,0,+I50+F51) >H51:/F$+H50-G51 >G51:/F$+E51-F51 >F51:/F$@INT((+H50*I20/12)+.5)/100 >E51:/FG@IF(B51=0,0,@IF(@COUNT(E33...E51)D51:@IF(@COUNT(D33...D51)>N9,0,+D50+1) >C51:/FL@IF(B51(@COUNT(D33...D42)>N9,0,+D41+1) >C42:/FL@IF(B42=0,0,@IF(B42=1,C41+1,C41)) >B42:@IF(@COUNT(B33...B42>N9,0,@IF(B41=12,1,B41+1)) >A42:+A41+1 >J41:/F$@IF(B41=0,0,+J40+G41) >I41:/F$@IF(B41=0,0,+I40+F41) >H41:/F$+H40-G41 >G41:/F$+E41-F41 >F41:/F$@INT((+H40*I20/12)+.5)/100 >E41:/FG@IF(B41=0,0,@IF(@COUNT(E33...E41)D41:@IF(@COUNT(D33...D41)>N9,0,+D40+1) >C41:/FL@IF(B41=0,0,@IF(B41=1,C40+1,C40)) >B41:@IF(@COUNT(B33...B41>N9,0,@IF(B40=12,1,B40+1)) >A41:+A40+1:" INTEREST >E30:/FG" AMOUNT OF >A30:+A29+1 >N29:"IONS. **** >M29:"RECALCULATI >A29:+A28+1 >F28:/F$@CHOOSE(I24,E33...E93) >E28:"PAYMENT : >D28:" LAST >A28:+A27+1 >N27:"TWO >M27:" REQUIRES >L27:" >A27:+A26+1 >N26:"RAM >M26:" THIS PROGR >L26::"" TO RUN REP >L31:" GOTO "B18" TO >J31:" PRINCIPAL >I31:" INTEREST >H31:" BALANCE >G31:" PAYMENT >F31:" PAYMENT >E31:" PAYMENT >D31:" PAYMENT # >C31:" YEAR >B31:" MONTH >A31:+A30+1 >J30:" ACCUM. >I30:" ACCUM. >H30:" LOAN >G30:" PRINCIPAL >F30:/FL+N20 >B33:+N23 >A33:+A32+1 >N32:"MONTHS. >M32:"ERM IS 60 >L32:" MAXIMUM T >J32:" ========= >I32:" ========= >H32:" ========= >G32:" ========= >F32:" ========= >E32:" ========= >D32:" ========= >C32:" ===== >B32:" ====== >A32:+A31+1 >N31:"EPORT. >M314>N9,0,@IF(B33=12,1,B33+1)) >A34:+A33+1 >J33:/F$+G33 >I33:/F$+F33 >H33:/F$+E20-G33 >G33:/F$+E33-F33 >F33:/FG@INT(+E20*(I20/100)/12+.005*100)/100 >E33:/FG@IF(B33=0,0,@IF(@COUNT(E33...E33)D33:1 >C3334:/F$+E34-F34 >F34:/F$@INT((+H33*I20/12)+.5)/100 >E34:/FG@IF(B34=0,0,@IF(@COUNT(E33...E34)D34:@IF(@COUNT(D33...D34)>N9,0,+D33+1) >C34:/FL@IF(B34=0,0,@IF(B34=1,C33+1,C33)) >B34:@IF(@COUNT(B33...B314,E26,@IF(D35=N9,H34+(@INT((H34*I20/12)+.5)/100),I22))) >D35:@IF(@COUNT(D33...D35)>N9,0,+D34+1) >C35:/FL@IF(B35=0,0,@IF(B35=1,C34+1,C34)) >B35:@IF(@COUNT(B33...B35>N9,0,@IF(B34=12,1,B34+1)) >A35:+A34+1 >J34:/F$+J33+G34 >I34:/F$+I33+F34 >H34:/F$+H33-G34 >GF(B36=1,C35+1,C35)) >B36:@IF(@COUNT(B33...B36>N9,0,@IF(B35=12,1,B35+1)) >A36:+A35+1 >J35:/F$@IF(B35=0,0,+J34+G35) >I35:/F$@IF(B35=0,0,+I34+F35) >H35:/F$+H34-G35 >G35:/F$+E35-F35 >F35:/F$@INT((+H34*I20/12)+.5)/100 >E35:/FG@IF(B35=0,0,@IF(@COUNT(E33...E35)H36:/F$+H35-G36 >G36:/F$+E36-F36 >F36:/F$@INT((+H35*I20/12)+.5)/100 >E36:/FG@IF(B36=0,0,@IF(@COUNT(E33...E36)D36:@IF(@COUNT(D33...D36)>N9,0,+D35+1) >C36:/FL@IF(B36=0,0,@ICOUNT(E33...E37)D37:@IF(@COUNT(D33...D37)>N9,0,+D36+1) >C37:/FL@IF(B37=0,0,@IF(B37=1,C36+1,C36)) >B37:@IF(@COUNT(B33...B37>N9,0,@IF(B36=12,1,B36+1)) >A37:+A36+1 >J36:/F$@IF(B36=0,0,+J35+G36) >I36::/FL@IF(B38=0,0,@IF(B38=1,C37+1,C37)) >B38:@IF(@COUNT(B33...B38>N9,0,@IF(B37=12,1,B37+1)) >A38:+A37+1 >J37:/F$@IF(B37=0,0,+J36+G37) >I37:/F$@IF(B37=0,0,+I36+F37) >H37:/F$+H36-G37 >G37:/F$+E37-F37 >F37:/F$@INT((+H36*I20/12)+.5)/100 >E37:/FG@IF(B37=0,0,@IF(@,0,+J37+G38) >I38:/F$@IF(B38=0,0,+I37+F38) >H38:/F$+H37-G38 >G38:/F$+E38-F38 >F38:/F$@INT((+H37*I20/12)+.5)/100 >E38:/FG@IF(B38=0,0,@IF(@COUNT(E33...E38)D38:@IF(@COUNT(D33...D38)>N9,0,+D37+1) >C38G@IF(B39=0,0,@IF(@COUNT(E33...E39)D39:@IF(@COUNT(D33...D39)>N9,0,+D38+1) >C39:/FL@IF(B39=0,0,@IF(B39=1,C38+1,C38)) >B39:@IF(@COUNT(B33...B39>N9,0,@IF(B38=12,1,B38+1)) >A39:+A38+1 >J38:/F$@IF(B38=0>N9,0,+D39+1) >C40:/FL@IF(B40=0,0,@IF(B40=1,C39+1,C39)) >B40:@IF(@COUNT(B33...B40>N9,0,@IF(B39=12,1,B39+1)) >A40:+A39+1 >J39:/F$@IF(B39=0,0,+J38+G39) >I39:/F$@IF(B39=0,0,+I38+F39) >H39:/F$+H38-G39 >G39:/F$+E39-F39 >F39:/F$@INT((+H38*I20/12)+.5)/100 >E39:/F >J40:/F$@IF(B40=0,0,+J39+G40) >I40:/F$@IF(B40=0,0,+I39+F40) >H40:/F$+H39-G40 >G40:/F$+E40-F40 >F40:/F$@INT((+H39*I20/12)+.5)/100 >E40:/FG@IF(B40=0,0,@IF(@COUNT(E33...E40)D40:@IF(@COUNT(D33...D40)"**** NOTE: >J26:" MONTHS >I26:/FI+N14-1 >H26:"NLY : >G26:"INTEREST ON >E26:/F$@INT(+N6*N17/12+.5)/100 >D26:"NLY PMT. : >C26:"INTEREST ONL >A26:+A25+1 >A25:+A24+1 >J24:" MONTHS >I24:+N9 >H24:" : >G24:"TERM >E24:/F$+E22+E20 >D24:"AYMENTS : >C24:"TOTAL OF P >A24:+A23+1 >N23:" ........ >M23:"TH-1 TO 12 >L23:" WHAT MONTH >A23:+A22+1 >M22:"T MADE IN >L22:"1ST PAYMENT >J22:/F$ >I22:/F$@INT((N6/(1-((1+(N17/100/12))^(-N9+N14-1))/(N17/100/12)))+.005*100)/100 >H22:"YMENT : >G22:"MONTHLY PAY >E22:/F,@NA) >H109:" % >G109:@IF(@AND(G45>H45,H45<>0),H45,G45) >F109:"AYS >E109:" 30 D >A109:+A108+1 >A108:+A107+1 >F107:"EEMENTS >E107:"ASE AGREE >D107:"REPURCHASE >A107:+A106+1 >A106:+A105+1 >N105:" ..... >M105:" ..... >L105:@IF(I42=1,@INT(((1+(G42/K42/100)00+.0005*1000)/1000,@NA) >K109:@IF(I45=1,@INT(((1+(G45/K45/100))^91.25)-1/91.25*J45*100+.0005*1000)/1000,@NA) >J109:@IF(I45=1,@INT(((1+(G45/K45/100))^182)-1/182*J45*100+.0005*1000)/1000,@NA) >I109:@IF(I45=1,@INT((1+(G45/K45/100))^J45-1*100+.0005*1000)/1000IF(I46=1,@INT((1+(G46/K46/100))^J46-1*100+.0005*1000)/1000,@NA) >H110:" % >G110:@IF(@AND(G46>H46,H46<>0),H46,G46) >F110:"AYS >E110:" 60 D >A110:+A109+1 >N109:" ...... >M109:" ..... >L109:@IF(I45=1,@INT(((1+(G45/K45/100))^30.41666667)-1/30.41666667*J45*11,@INT(((1+(G46/K46/100))^30.41666667)-1/30.41666667*J46*100+.0005*1000)/1000,@NA) >K110:@IF(I46=1,@INT(((1+(G46/K46/100))^91.25)-1/91.25*J46*100+.0005*1000)/1000,@NA) >J110:@IF(I46=1,@INT(((1+(G46/K46/100))^182)-1/182*J46*100+.0005*1000)/1000,@NA) >I110:@82*J48*100+.0005*1000)/1000,@NA) >I112:@IF(I48=1,@INT((1+(G48/K48/100))^J48-1*100+.0005*1000)/1000,@NA) >H112:" % >G112:@IF(@AND(G48>H48,H48<>0),H48,G48) >E112:"ERS CD' >D112:"ALL SAV >A112:+A111+1 >A111:+A110+1 >N110:" ...... >M110:" ..... >L110:@IF(I46=kmnopqrstuvwxyz{|}~2:" ...... >M112:" ..... >L112:@IF(I48=1,@INT(((1+(G48/K48/100))^30.41666667)-1/30.41666667*J48*100+.0005*1000)/1000,@NA) >K112:@IF(I48=1,@INT(((1+(G48/K48/100))^91.25)-1/91.25*J48*100+.0005*1000)/1000,@NA) >J112:@IF(I48=1,@INT(((1+(G48/K48/100))^182)-1/1>F117:"CABLE >E117:"T APPLI >D117:"NA = NOT >A117:+A116+1 >L116:" RATE. >K116:"AT SAME >J116:"ENEWED >I116:"ST IS RE >H116:" INTERE >G116:"CIPAL & >F116:"AT PRIN >E116:"UMES THA >D116:"* = ASSU >A116:+A115+1 >A115:+A114+1 >A114:+A113+1 >A113:+A112+1 >N11 >J1:" J >I1:" I >H1:" H >G1:" G >F1:" F >E1:" E >D1:" D >C1:" C >B1:" B /W1 /GOR /GRM /GC10 /X>A1:>A1: 1: "PROCEEDS AMOU >A6:+A5+1 >A5:+A4+1 >N4:"=========== >M4:"=========== >L4:"========== >A4:+A3+1 >M3:"OAN >L3:"TERMS OF LOAN >A3:3 >L2:" >E2:"N >D2:"MORTIZATIO >C2:"NLY LOAN A >B2:"INTEREST O >A2:"MODEL 2 - >N1:" N >M1:" M >L1:" L >K1:" KM14:"AL PAYMENT >L14:" & PRINCIPAL >A14:+A13+1 >M13:"O INTEREST >L13:" CONVERT TO >A13:+A12+1 >M12:"NTH DO YOU >L12:"IN WHAT MON >A12:+A11+1 >A11:+A10+1 >A10:+A9+1 >N9:" ........ >L9:"TERM >A9:+A8+1 >A8:+A7+1 >A7:+A6+1 >N6:/F$" ......... >M6:"MOUNT >L6:18+1 >J18:"MENT >I18:"TEREST PAY >H18:"CIPAL & IN >G18:"TS TO PRIN >F18:"NLY CONVER >E18:"INTEREST O >D18:"IZATION - >C18:"LOAN AMORTIZA >A18:+A17+1 >N17:" ......... >M17:"ATE (APR) >L17:"INTEREST R >A17:+A16+1 >A16:+A15+1 >A15:+A14+1 >N14:" ......... >$+F94 >D22:" : >C22:"INTEREST >A22:+A21+1 >A21:+A20+1 >N20:" ........ >M20:"R >L20:" WHAT YEAR >J20:"% >I20:+N17 >H20:"ATE : >G20:"INTEREST R >E20:/F$+N6 >D20:"MOUNT : >C20:"PROCEEDS A >A20:+A19+1 >M19:"T MADE IN >L19:"1ST PAYMENT >A19:+A)^30.41666667)-1/30.41666667*J42*100+.0005*1000)/1000,@NA) >K105:@IF(I42=1,@INT(((1+(G42/K42/100))^91.25)-1/91.25*J42*100+.0005*1000)/1000,@NA) >J105:@IF(I42=1,@INT(((1+(G42/K42/100))^182)-1/182*J42*100+.0005*1000)/1000,@NA) >I105:@IF(I42=1,@INT((1+(G42/K42/100))^J42-1*100+.0005*1000)/1000,@NA) >H105:" % >G105:@IF(@AND(G42>H42,H42<>0),H42,G42) >F105:" OF DEP >E105:"0 CERT. >D105:"IRA T-3 >A105:+A104+1 >A104:+A103+1 >N103:" ..... >M103:" ..... >L103:@IF(I40=1,@INT(((1+(G40/K40/100))^30.41666667)-1/30.41666/K26/100))^J26-1*100+.0005*1000)/1000,@NA) >H89:" % >G89:@IF(@AND(G26>H26,H26<>0),H26,G26) >F89:"F DEP. >E89:"CERT. OF >D89:"91 DAY >A89:+A88+1 >A88:+A87+1 >L87:@IF(I24=1,@INT(((1+(G24/K24/100))^30.41666667)-1/30.41666667*J24*100+.0005*1000)/1000,@NA) >K26/100))^30.41666667)-1/30.41666667*J26*100+.0005*1000)/1000,@NA) >K89:@IF(I26=1,@INT(((1+(G26/K26/100))^91.25)-1/91.25*J26*100+.0005*1000)/1000,@NA) >J89:@IF(I26=1,@INT(((1+(G26/K26/100))^182)-1/182*J26*100+.0005*1000)/1000,@NA) >I89:@IF(I26=1,@INT((1+(G2 >I91:@INT(10000*(1+(G28/100/2))*(1+(G28/100/2))*(1+(G28/100/365))-10000*10)/1000 >H91:" % >G91:@IF(@AND(G28>H28,H28<>0),H28,G28) >F91:"EPOSIT >E91:"T. OF DEP >D91:"T-6 CERT >A91:+A90+1 >A90:+A89+1 >N89:" ...... >M89:" ..... >L89:@IF(I26=1,@INT(((1+(G26/K=1,@INT((1+(G31/K31/100))^J31-1*100+.0005*1000)/1000,@NA) >H94:" % >G94:@IF(@AND(G31>H31,H31<>0),H31,G31) >F94:"ER >E94:"00 & OV >D94:" $2,500 >A94:+A93+1 >F93:"D'S >E93:" T-36 C >D93:"T-30 TO T >A93:+A92+1 >A92:+A91+1 >N91:" ...... >M91:" ..... >J91:"*INT(((1+(G31/K31/100))^30.41666667)-1/30.41666667*J31*100+.0005*1000)/1000,@NA) >K94:@IF(I31=1,@INT(((1+(G31/K31/100))^91.25)-1/91.25*J31*100+.0005*1000)/1000,@NA) >J94:@IF(I31=1,@INT(((1+(G31/K31/100))^182)-1/182*J31*100+.0005*1000)/1000,@NA) >I94:@IF(I31)^182)-1/182*J32*100+.0005*1000)/1000,@NA) >I95:@IF(I32=1,@INT((1+(G32/K32/100))^J32-1*100+.0005*1000)/1000,@NA) >H95:" % >G95:@IF(@AND(G32>H32,H32<>0),H32,G32) >F95:"00 >E95:"ER $2,500 >D95:" UND >A95:+A94+1 >N94:" ...... >M94:" ..... >L94:@IF(I31=1,@A96:+A95+1 >N95:" ...... >M95:" ..... >L95:@IF(I32=1,@INT(((1+(G32/K32/100))^30.41666667)-1/30.41666667*J32*100+.0005*1000)/1000,@NA) >K95:@IF(I32=1,@INT(((1+(G32/K32/100))^91.25)-1/91.25*J32*100+.0005*1000)/1000,@NA) >J95:@IF(I32=1,@INT(((1+(G32/K32/100)182*J35*100+.0005*1000)/1000,@NA) >I98:@IF(I35=1,@INT((1+(G35/K35/100))^J35-1*100+.0005*1000)/1000,@NA) >H98:" % >G98:@IF(@AND(G35>H35,H35<>0),H35,G35) >F98:"ER >E98:"00 & OV >D98:" $2,500 >A98:+A97+1 >F97:"D'S >E97:" T-60 C >D97:"T-42 TO T >A97:+A96+1 >500 >D99:" UND >A99:+A98+1 >L98:@IF(I35=1,@INT(((1+(G35/K35/100))^30.41666667)-1/30.41666667*J35*100+.0005*1000)/1000,@NA) >K98:@IF(I35=1,@INT(((1+(G35/K35/100))^91.25)-1/91.25*J35*100+.0005*1000)/1000,@NA) >J98:@IF(I35=1,@INT(((1+(G35/K35/100))^182)-1//91.25*J36*100+.0005*1000)/1000,@NA) >J99:@IF(I36=1,@INT(((1+(G36/K36/100))^182)-1/182*J36*100+.0005*1000)/1000,@NA) >I99:@IF(I36=1,@INT((1+(G36/K36/100))^J36-1*100+.0005*1000)/1000,@NA) >H99:" % >G99:@IF(@AND(G36>H36,H36<>0),H36,G36) >F99:"00 >E99:"ER $2, % >G101:@IF(@AND(G38>H38,H38<>0),H38,G38) >F101:"IABLE >E101:"DEN VAR >D101:"IRA GOL >A101:+A100+1 >A100:+A99+1 >L99:@IF(I36=1,@INT(((1+(G36/K36/100))^30.41666667)-1/30.41666667*J36*100+.0005*1000)/1000,@NA) >K99:@IF(I36=1,@INT(((1+(G36/K36/100))^91.25)-1)/1000,@NA) >K101:@IF(I38=1,@INT(((1+(G38/K38/100))^91.25)-1/91.25*J38*100+.0005*1000)/1000,@NA) >J101:@IF(I38=1,@INT(((1+(G38/K38/100))^182)-1/182*J38*100+.0005*1000)/1000,@NA) >I101:@IF(I38=1,@INT((1+(G38/K38/100))^J38-1*100+.0005*1000)/1000,@NA) >H101:"1000)/1000,@NA) >H103:" % >G103:@IF(@AND(G40>H40,H40<>0),H40,G40) >F103:" OF DEP >E103:"8 CERT. >D103:"IRA T-18 >A103:+A102+1 >A102:+A101+1 >N101:" ..... >M101:" ..... >L101:@IF(I38=1,@INT(((1+(G38/K38/100))^30.41666667)-1/30.41666667*J38*100+.0005*10006667*J40*100+.0005*1000)/1000,@NA) >K103:@IF(I40=1,@INT(((1+(G40/K40/100))^91.25)-1/91.25*J40*100+.0005*1000)/1000,@NA) >J103:@IF(I40=1,@INT(((1+(G40/K40/100))^182)-1/182*J40*100+.0005*1000)/1000,@NA) >I103:@IF(I40=1,@INT((1+(G40/K40/100))^J40-1*100+.0005*87:@IF(I24=1,@INT(((1+(G24/K24/100))^91.25)-1/91.25*J24*100+.0005*1000)/1000,@NA) >J87:@IF(I24=1,@INT(((1+(G24/K24/100))^182)-1/182*J24*100+.0005*1000)/1000,@NA) >I87:@IF(I24=1,@INT((1+(G24/K24/100))^J24-1*100+.0005*1000)/1000,@NA) >G87:@IF(@AND(G24>H24,H24<>0),H24,G24) >F87:"CCOUNT >E87:"ARKET AC >D87:"MONEY M >A87:+A86+1 >A86:+A85+1 >A85:+A84+1 >L84:@IF(I21=1,@INT(((1+(G21/K21/100))^30.41666667)-1/30.41666667*J21*100+.0005*1000)/1000,@NA) >K84:@IF(I21=1,@INT(((1+(G21/K21/100))^91.25)-1/91.25*J21*100+.0005:+A56+1 >A56:+A55+1 >A55:+A54+1 >A54:+A53+1 >A53:+A52+1 >A52:+A51+1 >A51:+A50+1 >E50:" ..... >C50:"DS RATE >B50:"FED FUN >A50:+A49+1 >A49:+A48+1 >K48:" ..... >J48:" ..... >I48:" ..... >H48:" ..... >G48:+E48+F48 >F48:" ..... >E48:" ..... >C48:"ERS CD>A65:+A64+1 >J64:"= >I64:"======== >H64:" ======= >A64:+A63+1 >J63:"E >I63:"NDS RATE >H63:" FED FUN >A63:+A62+1 >A62:+A61+1 >A61:+A60+1 >J60:"....... >I60:"....... >H60:"....... >A60:+A59+1 >A59:+A58+1 >J58:"ES >I58:"ENT RATE >H58:"INVESTM >A58:+A57+1 >A57--- >K71:"------- >J71:"------- >I71:" ------- >A71:+A70+1 >L70:"D >K70:" IS PAID >J70:"NTEREST >I70:" IF I >A70:+A69+1 >L69:"DING >K69:"COMPOUN >J69:"CTS OF >I69:" EFFECTS >A69:+A68+1 >A68:+A67+1 >A67:+A66+1 >K66:"% >J66:+E50 >I66:"RATE >A66:+A65+1 == >G74:" ====== >A74:+A73+1 >N73:" THRU >M73:" FROM >L73:" MONTH >K73:" TERLY >J73:" ANNUAL >I73:" ANNUAL >G73:" RATE >A73:+A72+1 >N72:"------- >M72:" ------- >K72:" QUAR- >J72:" SEMI- >G72:" TODAYS >A72:+A71+1 >N71:"DATES >M71:" EFF. DAT >L71:"---- 30- >A79:+A78+1 >F78:"DAYS >E78:"M - IN >D78:" TERM >A78:+A77+1 >A77:+A76+1 >N76:" ...... >M76:" ...... >F76:",000 >E76:"ER $100 >D76:"CD'S OVE >A76:+A75+1 >A75:+A74+1 >N74:" ====== >M74:" ====== >L74:" ====== >K74:" ====== >J74:" ====== >I74:" ====5)-1/91.25*J16*100+.0005*1000)/1000,@NA) >J79:@IF(I16=1,@INT(((1+(G16/K16/100))^182)-1/182*J16*100+.0005*1000)/1000,@NA) >I79:@IF(I16=1,@INT((1+(G16/K16/100))^J16-1*100+.0005*1000)/1000,@NA) >H79:" % >G79:@IF(@AND(G16>H16,H16<>0),H16,G16) >F79:" 59 >E79:" ^J17-1*100+.0005*1000)/1000,@NA) >H80:" % >G80:@IF(@AND(G17>H17,H17<>0),H17,G17) >F80:" 89 >E80:" 60- >A80:+A79+1 >L79:@IF(I16=1,@INT(((1+(G16/K16/100))^30.41666667)-1/30.41666667*J16*100+.0005*1000)/1000,@NA) >K79:@IF(I16=1,@INT(((1+(G16/K16/100))^91.2.41666667)-1/30.41666667*J17*100+.0005*1000)/1000,@NA) >K80:@IF(I17=1,@INT(((1+(G17/K17/100))^91.25)-1/91.25*J17*100+.0005*1000)/1000,@NA) >J80:@IF(I17=1,@INT(((1+(G17/K17/100))^182)-1/182*J17*100+.0005*1000)/1000,@NA) >I80:@IF(I17=1,@INT((1+(G17/K17/100))(((1+(G18/K18/100))^182)-1/182*J18*100+.0005*1000)/1000,@NA) >I81:@IF(I18=1,@INT((1+(G18/K18/100))^J18-1*100+.0005*1000)/1000,@NA) >H81:" % >G81:@IF(@AND(G18>H18,H18<>0),H18,G18) >F81:"100 >E81:" 90- >A81:+A80+1 >L80:@IF(I17=1,@INT(((1+(G17/K17/100))^30H19,H19<>0),H19,G19) >F82:"182 >E82:" 101- >A82:+A81+1 >L81:@IF(I18=1,@INT(((1+(G18/K18/100))^30.41666667)-1/30.41666667*J18*100+.0005*1000)/1000,@NA) >K81:@IF(I18=1,@INT(((1+(G18/K18/100))^91.25)-1/91.25*J18*100+.0005*1000)/1000,@NA) >J81:@IF(I18=1,@INT@IF(I19=1,@INT(((1+(G19/K19/100))^91.25)-1/91.25*J19*100+.0005*1000)/1000,@NA) >J82:@IF(I19=1,@INT(((1+(G19/K19/100))^182)-1/182*J19*100+.0005*1000)/1000,@NA) >I82:@IF(I19=1,@INT((1+(G19/K19/100))^J19-1*100+.0005*1000)/1000,@NA) >H82:" % >G82:@IF(@AND(G19> >I83:@IF(I20=1,@INT((1+(G20/K20/100))^J20-1*100+.0005*1000)/1000,@NA) >H83:" % >G83:@IF(@AND(G20>H20,H20<>0),H20,G20) >F83:"270 >E83:" 183- >A83:+A82+1 >L82:@IF(I19=1,@INT(((1+(G19/K19/100))^30.41666667)-1/30.41666667*J19*100+.0005*1000)/1000,@NA) >K82:3:@IF(I20=1,@INT(((1+(G20/K20/100))^30.41666667)-1/30.41666667*J20*100+.0005*1000)/1000,@NA) >K83:@IF(I20=1,@INT(((1+(G20/K20/100))^91.25)-1/91.25*J20*100+.0005*1000)/1000,@NA) >J83:@IF(I20=1,@INT(((1+(G20/K20/100))^182)-1/182*J20*100+.0005*1000)/1000,@NA)*1000)/1000,@NA) >J84:@IF(I21=1,@INT(((1+(G21/K21/100))^182)-1/182*J21*100+.0005*1000)/1000,@NA) >I84:@IF(I21=1,@INT((1+(G21/K21/100))^J21-1*100+.0005*1000)/1000,@NA) >H84:" % >G84:@IF(@AND(G21>H21,H21<>0),H21,G21) >F84:"& OVER >E84:" 271 >A84:+A83+1 >L8' >B48:"ALL SAV >A48:+A47+1 >A47:+A46+1 >K46:" ..... >J46:" ..... >I46:" ..... >H46:" ..... >G46:+E46+F46 >F46:" ..... >E46:" ..... >D46:"AYS >C46:" 60 D >A46:+A45+1 >K45:" ..... >J45:" ..... >I45:" ..... >H45:" ..... >G45:+E45+F45 >F45:" ..... >E45:" ..... >D45:"AYS >C45:" 30 D >A45:+A44+1 >D44:"EEMENTS >C44:"ASE AGREE >B44:"REPURCHASE >A44:+A43+1 >A43:+A42+1 >K42:" ..... >J42:" ..... >I42:" ..... >H42:" ..... >G42:+E42+F42 >F42:" ..... >E42:" ..... >D42:" OF DEP >C42:"0 CERT. >B42:"I" C >B1:" B >A1:" A /W1 /GOR /GRM /GC7 /X>A1:>A2: 2: 7:+A6+1 >D6:"TION >C6:"TRY SEC >B6:"DATA EN >A6:+A5+1 >A5:+A4+1 >A4:+A3+1 >A3:3 >E2:"RATES >D2:"STMENT >C2:"LY INVE >B2:" - DAI >A2:"MODEL 3 >N1:" N >M1:" M >L1:" L >K1:" K >J1:" J >I1:" I >H1:" H >G1:" G >F1:" F >E1:" E >D1:" D >C1: >F10:" ADJ. >A10:+A9+1 >K9:" RATE >J9:" 365 OR >I9:" COMP- >H9:" CEIL- >G9:"ADJUST- >F9:" POINT >A9:+A8+1 >K8:" FOR >J8:" ON A >I8:" CD >F8:" BASIS >A8:+A7+1 >K7:" BASIS >J7:" BASED >I7:" DOES >E7:"======== >D7:"======== >C7:"======== >B7:"======== >A===== >I12:" ======= >H12:" ======= >G12:" ======= >F12:" ======= >E12:" ======= >A12:+A11+1 >K11:" 360 >J11:" DAY YR >I11:" DAILY >H11:" RATE >G11:" RATE >F11:" IF ANY >E11:" RATE >A11:+A10+1 >K10:" 365 OR >J10:" 360 >I10:" OUNDS >H10:" ING >G10:" ED>H16:" ..... >G16:+E16+F16 >F16:" ..... >E16:" ..... >D16:" 59 >C16:" 30- >A16:+A15+1 >D15:"DAYS >C15:"M - IN >B15:" TERM >A15:+A14+1 >I14:" NO=2 >D14:",000 >C14:"ER $100 >B14:"CD'S OVE >A14:+A13+1 >I13:" YES=1 >A13:+A12+1 >K12:" ======= >J12:" ==. >G18:+E18+F18 >F18:" ..... >E18:" ..... >D18:"100 >C18:" 90- >A18:+A17+1 >K17:" ..... >J17:" ..... >I17:" ..... >H17:" ..... >G17:+E17+F17 >F17:" ..... >E17:" ..... >D17:" 89 >C17:" 60- >A17:+A16+1 >K16:" ..... >J16:" ..... >I16:" ..... F20 >F20:" ..... >E20:" ..... >D20:"270 >C20:" 183- >A20:+A19+1 >K19:" ..... >J19:" ..... >I19:" ..... >H19:" ..... >G19:+E19+F19 >F19:" ..... >E19:" ..... >D19:"182 >C19:" 101- >A19:+A18+1 >K18:" ..... >J18:" ..... >I18:" ..... >H18:" .... AC >B24:"MONEY M >A24:+A23+1 >A23:+A22+1 >A22:+A21+1 >K21:" ..... >J21:" ..... >I21:" ..... >H21:" ..... >G21:+E21+F21 >F21:" ..... >E21:" ..... >D21:"& OVER >C21:" 271 >A21:+A20+1 >K20:" ..... >J20:" ..... >I20:" ..... >H20:" ..... >G20:+E20+26:" ..... >H26:" ..... >G26:+E26+F26 >F26:" ..... >E26:" ..... >D26:"F DEP. >C26:"CERT. OF >B26:"91 DAY >A26:+A25+1 >A25:+A24+1 >K24:" ..... >J24:" ..... >I24:" ..... >H24:" ..... >G24:+E24+F24 >F24:" ..... >E24:" ..... >D24:"CCOUNT >C24:"ARKET:"D'S >C30:" T-36 C >B30:"T-30 TO T >A30:+A29+1 >A29:+A28+1 >K28:" ..... >J28:" ..... >I28:" ..... >H28:" ..... >G28:+E28+F28 >F28:" ..... >E28:" ..... >D28:"EPOSIT >C28:"T. OF DEP >B28:"T-6 CERT >A28:+A27+1 >A27:+A26+1 >K26:" ..... >J26:" ..... >I:" ..... >G32:+E32+F32 >F32:" ..... >E32:" ..... >D32:"00 >C32:"ER $2,500 >B32:" UND >A32:+A31+1 >K31:" ..... >J31:" ..... >I31:" ..... >H31:" ..... >G31:+E31+F31 >F31:" ..... >E31:" ..... >D31:"ER >C31:"00 & OV >B31:" $2,500 >A31:+A30+1 >D305:" ..... >J35:" ..... >I35:" ..... >H35:" ..... >G35:+E35+F35 >F35:" ..... >E35:" ..... >D35:"ER >C35:"00 & OV >B35:" $2,500 >A35:+A34+1 >D34:"D'S >C34:" T-60 C >B34:"T-42 TO T >A34:+A33+1 >A33:+A32+1 >K32:" ..... >J32:" ..... >I32:" ..... >H3238:+E38+F38 >F38:" ..... >E38:" ..... >D38:"IABLE >C38:"DEN VAR >B38:"IRA GOL >A38:+A37+1 >A37:+A36+1 >K36:" ..... >J36:" ..... >I36:" ..... >H36:" ..... >G36:+E36+F36 >F36:" ..... >E36:" ..... >D36:"00 >C36:"ER $2,500 >B36:" UND >A36:+A35+1 >K3RA T-3 >A42:+A41+1 >A41:+A40+1 >K40:" ..... >J40:" ..... >I40:" ..... >H40:" ..... >G40:+E40+F40 >F40:" ..... >E40:" ..... >D40:" OF DEP >C40:"8 CERT. >B40:"IRA T-18 >A40:+A39+1 >A39:+A38+1 >K38:" ..... >J38:" ..... >I38:" ..... >H38:" ..... >G >Q73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),Q72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),Q72/(5-L3),Q72/(4-L3)))) >P73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),P72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),P72/(5-L3),P72/(4-L3)))) >O73:@INT(@IF(@AND(GG51)+@CHOOSE(A72+28,G17...G51) >F72:@CHOOSE(A72,F17...F51)+@CHOOSE(A72+7,F17...F51)+@CHOOSE(A72+14,F17...F51)+@CHOOSE(A72+21,F17...F51)+@CHOOSE(A72+28,F17...F51) >E72:@CHOOSE(A72,E17...E51)+@CHOOSE(A72+7,E17...E51)+@CHOOSE(A72+14,E17...E51)+@CHOOSE(A72+21,CHOOSE(A72+28,I17...I51) >H72:@CHOOSE(A72,H17...H51)+@CHOOSE(A72+7,H17...H51)+@CHOOSE(A72+14,H17...H51)+@CHOOSE(A72+21,H17...H51)+@CHOOSE(A72+28,H17...H51) >G72:@CHOOSE(A72,G17...G51)+@CHOOSE(A72+7,G17...G51)+@CHOOSE(A72+14,G17...G51)+@CHOOSE(A72+21,G17...(A72+28,K17...K51) >J72:@CHOOSE(A72,J17...J51)+@CHOOSE(A72+7,J17...J51)+@CHOOSE(A72+14,J17...J51)+@CHOOSE(A72+21,J17...J51)+@CHOOSE(A72+28,J17...J51) >I72:@CHOOSE(A72,I17...I51)+@CHOOSE(A72+7,I17...I51)+@CHOOSE(A72+14,I17...I51)+@CHOOSE(A72+21,I17...I51)+@8,M17...M51) >L72:@CHOOSE(A72,L17...L51)+@CHOOSE(A72+7,L17...L51)+@CHOOSE(A72+14,L17...L51)+@CHOOSE(A72+21,L17...L51)+@CHOOSE(A72+28,L17...L51) >K72:@CHOOSE(A72,K17...K51)+@CHOOSE(A72+7,K17...K51)+@CHOOSE(A72+14,K17...K51)+@CHOOSE(A72+21,K17...K51)+@CHOOSE..O51) >N72:@CHOOSE(A72,N17...N51)+@CHOOSE(A72+7,N17...N51)+@CHOOSE(A72+14,N17...N51)+@CHOOSE(A72+21,N17...N51)+@CHOOSE(A72+28,N17...N51) >M72:@CHOOSE(A72,M17...M51)+@CHOOSE(A72+7,M17...M51)+@CHOOSE(A72+14,M17...M51)+@CHOOSE(A72+21,M17...M51)+@CHOOSE(A72+2 >P72:@CHOOSE(A72,P17...P51)+@CHOOSE(A72+7,P17...P51)+@CHOOSE(A72+14,P17...P51)+@CHOOSE(A72+21,P17...P51)+@CHOOSE(A72+28,P17...P51) >O72:@CHOOSE(A72,O17...O51)+@CHOOSE(A72+7,O17...O51)+@CHOOSE(A72+14,O17...O51)+@CHOOSE(A72+21,O17...O51)+@CHOOSE(A72+28,O17.73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),D72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),D72/(5-L3),D72/(4-L3)))) >B73:"AVG >Q72:@CHOOSE(A72,Q17...Q51)+@CHOOSE(A72+7,Q17...Q51)+@CHOOSE(A72+14,Q17...Q51)+@CHOOSE(A72+21,Q17...Q51)+@CHOOSE(A72+28,Q17...Q51)L3),G72/(4-L3)))) >F73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),F72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),F72/(5-L3),F72/(4-L3)))) >E73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),E72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),E72/(5-L3),E72/(4-L3)))) >D17=7,C18=7)),I72/(5-L3),I72/(4-L3)))) >H73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),H72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),H72/(5-L3),H72/(4-L3)))) >G73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),G72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),G72/(5-@IF(@AND(G5=30,@OR(C17=7,C18=7)),K72/(5-L3),K72/(4-L3)))) >J73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),J72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),J72/(5-L3),J72/(4-L3)))) >I73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),I72/(5-L3),@IF(@AND(G5=30,@OR(C,C19=7)),M72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),M72/(5-L3),M72/(4-L3)))) >L73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),L72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),L72/(5-L3),L72/(4-L3)))) >K73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),K72/(5-L3),5=31,@OR(C17=7,C18=7,C19=7)),O72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),O72/(5-L3),O72/(4-L3)))) >N73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7,C19=7)),N72/(5-L3),@IF(@AND(G5=30,@OR(C17=7,C18=7)),N72/(5-L3),N72/(4-L3)))) >M73:@INT(@IF(@AND(G5=31,@OR(C17=7,C18=7E17...E51)+@CHOOSE(A72+28,E17...E51) >D72:@CHOOSE(A72,D17...D51)+@CHOOSE(A72+7,D17...D51)+@CHOOSE(A72+14,D17...D51)+@CHOOSE(A72+21,D17...D51)+@CHOOSE(A72+28,D17...D51) >C72:"YS >B72:"SATURDAYS >A72:/FL@IF(15-C17>7,8-C17,15-C17) >Q70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),Q69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),Q69/(5-K3),Q69/(4-K3)))) >P70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),P69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),P69/(5-K3),P69/(4-K3)))) >O70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)ND(G5=30,@OR(C17=5,C18=5)),Q66/(5-J3),Q66/(4-J3)))) >P67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),P66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),P66/(5-J3),P66/(4-J3)))) >O67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),O66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C17...E51) >D69:@CHOOSE(A69,D17...D51)+@CHOOSE(A69+7,D17...D51)+@CHOOSE(A69+14,D17...D51)+@CHOOSE(A69+21,D17...D51)+@CHOOSE(A69+28,D17...D51) >B69:"FRIDAYS >A69:/FL@IF(14-C17>7,7-C17,14-C17) >Q67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),Q66/(5-J3),@IF(@A51) >F69:@CHOOSE(A69,F17...F51)+@CHOOSE(A69+7,F17...F51)+@CHOOSE(A69+14,F17...F51)+@CHOOSE(A69+21,F17...F51)+@CHOOSE(A69+28,F17...F51) >E69:@CHOOSE(A69,E17...E51)+@CHOOSE(A69+7,E17...E51)+@CHOOSE(A69+14,E17...E51)+@CHOOSE(A69+21,E17...E51)+@CHOOSE(A69+28,E69:@CHOOSE(A69,H17...H51)+@CHOOSE(A69+7,H17...H51)+@CHOOSE(A69+14,H17...H51)+@CHOOSE(A69+21,H17...H51)+@CHOOSE(A69+28,H17...H51) >G69:@CHOOSE(A69,G17...G51)+@CHOOSE(A69+7,G17...G51)+@CHOOSE(A69+14,G17...G51)+@CHOOSE(A69+21,G17...G51)+@CHOOSE(A69+28,G17...GOOSE(A69,J17...J51)+@CHOOSE(A69+7,J17...J51)+@CHOOSE(A69+14,J17...J51)+@CHOOSE(A69+21,J17...J51)+@CHOOSE(A69+28,J17...J51) >I69:@CHOOSE(A69,I17...I51)+@CHOOSE(A69+7,I17...I51)+@CHOOSE(A69+14,I17...I51)+@CHOOSE(A69+21,I17...I51)+@CHOOSE(A69+28,I17...I51) >H69,L17...L51)+@CHOOSE(A69+7,L17...L51)+@CHOOSE(A69+14,L17...L51)+@CHOOSE(A69+21,L17...L51)+@CHOOSE(A69+28,L17...L51) >K69:@CHOOSE(A69,K17...K51)+@CHOOSE(A69+7,K17...K51)+@CHOOSE(A69+14,K17...K51)+@CHOOSE(A69+21,K17...K51)+@CHOOSE(A69+28,K17...K51) >J69:@CH...N51)+@CHOOSE(A69+7,N17...N51)+@CHOOSE(A69+14,N17...N51)+@CHOOSE(A69+21,N17...N51)+@CHOOSE(A69+28,N17...N51) >M69:@CHOOSE(A69,M17...M51)+@CHOOSE(A69+7,M17...M51)+@CHOOSE(A69+14,M17...M51)+@CHOOSE(A69+21,M17...M51)+@CHOOSE(A69+28,M17...M51) >L69:@CHOOSE(A)+@CHOOSE(A69+7,P17...P51)+@CHOOSE(A69+14,P17...P51)+@CHOOSE(A69+21,P17...P51)+@CHOOSE(A69+28,P17...P51) >O69:@CHOOSE(A69,O17...O51)+@CHOOSE(A69+7,O17...O51)+@CHOOSE(A69+14,O17...O51)+@CHOOSE(A69+21,O17...O51)+@CHOOSE(A69+28,O17...O51) >N69:@CHOOSE(A69,N17C17=6,C18=6,C19=6)),D69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),D69/(5-K3),D69/(4-K3)))) >B70:"AVG >Q69:@CHOOSE(A69,Q17...Q51)+@CHOOSE(A69+7,Q17...Q51)+@CHOOSE(A69+14,Q17...Q51)+@CHOOSE(A69+21,Q17...Q51)+@CHOOSE(A69+28,Q17...Q51) >P69:@CHOOSE(A69,P17...P51(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),F69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),F69/(5-K3),F69/(4-K3)))) >E70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),E69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),E69/(5-K3),E69/(4-K3)))) >D70:@INT(@IF(@AND(G5=31,@OR(/(4-K3)))) >H70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),H69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),H69/(5-K3),H69/(4-K3)))) >G70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),G69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),G69/(5-K3),G69/(4-K3)))) >F70:@INT8=6)),K69/(5-K3),K69/(4-K3)))) >J70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),J69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),J69/(5-K3),J69/(4-K3)))) >I70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),I69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),I69/(5-K3),I69D(G5=30,@OR(C17=6,C18=6)),M69/(5-K3),M69/(4-K3)))) >L70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),L69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),L69/(5-K3),L69/(4-K3)))) >K70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),K69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C1),O69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),O69/(5-K3),O69/(4-K3)))) >N70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),N69/(5-K3),@IF(@AND(G5=30,@OR(C17=6,C18=6)),N69/(5-K3),N69/(4-K3)))) >M70:@INT(@IF(@AND(G5=31,@OR(C17=6,C18=6,C19=6)),M69/(5-K3),@IF(@AN18=5)),O66/(5-J3),O66/(4-J3)))) >N67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),N66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),N66/(5-J3),N66/(4-J3)))) >M67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),M66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),M66/(5-J3),M66/(4-J3)))) >L67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),L66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),L66/(5-J3),L66/(4-J3)))) >K67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),K66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),K66/(5-J3),K66/(4-J3)))) >J67:@INND(G5=31,@OR(C17=4,C18=4,C19=4)),L63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),L63/(5-I3),L63/(4-I3)))) >K64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),K63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),K63/(5-I3),K63/(4-I3)))) >J64:@INT(@IF(@AND(G5=31,@OR(C17=4,C))) >N64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),N63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),N63/(5-I3),N63/(4-I3)))) >M64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),M63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),M63/(5-I3),M63/(4-I3)))) >L64:@INT(@IF(@A63/(5-I3),Q63/(4-I3)))) >P64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),P63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),P63/(5-I3),P63/(4-I3)))) >O64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),O63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),O63/(5-I3),O63/(4-I3)CHOOSE(A66+7,D17...D51)+@CHOOSE(A66+14,D17...D51)+@CHOOSE(A66+21,D17...D51)+@CHOOSE(A66+28,D17...D51) >C66:"YS >B66:"THURSDAYS >A66:/FL@IF(13-C17>7,6-C17,13-C17) >Q64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),Q63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),Q(A66+7,F17...F51)+@CHOOSE(A66+14,F17...F51)+@CHOOSE(A66+21,F17...F51)+@CHOOSE(A66+28,F17...F51) >E66:@CHOOSE(A66,E17...E51)+@CHOOSE(A66+7,E17...E51)+@CHOOSE(A66+14,E17...E51)+@CHOOSE(A66+21,E17...E51)+@CHOOSE(A66+28,E17...E51) >D66:@CHOOSE(A66,D17...D51)+@,H17...H51)+@CHOOSE(A66+14,H17...H51)+@CHOOSE(A66+21,H17...H51)+@CHOOSE(A66+28,H17...H51) >G66:@CHOOSE(A66,G17...G51)+@CHOOSE(A66+7,G17...G51)+@CHOOSE(A66+14,G17...G51)+@CHOOSE(A66+21,G17...G51)+@CHOOSE(A66+28,G17...G51) >F66:@CHOOSE(A66,F17...F51)+@CHOOSE.J51)+@CHOOSE(A66+14,J17...J51)+@CHOOSE(A66+21,J17...J51)+@CHOOSE(A66+28,J17...J51) >I66:@CHOOSE(A66,I17...I51)+@CHOOSE(A66+7,I17...I51)+@CHOOSE(A66+14,I17...I51)+@CHOOSE(A66+21,I17...I51)+@CHOOSE(A66+28,I17...I51) >H66:@CHOOSE(A66,H17...H51)+@CHOOSE(A66+7@CHOOSE(A66+14,L17...L51)+@CHOOSE(A66+21,L17...L51)+@CHOOSE(A66+28,L17...L51) >K66:@CHOOSE(A66,K17...K51)+@CHOOSE(A66+7,K17...K51)+@CHOOSE(A66+14,K17...K51)+@CHOOSE(A66+21,K17...K51)+@CHOOSE(A66+28,K17...K51) >J66:@CHOOSE(A66,J17...J51)+@CHOOSE(A66+7,J17..E(A66+14,N17...N51)+@CHOOSE(A66+21,N17...N51)+@CHOOSE(A66+28,N17...N51) >M66:@CHOOSE(A66,M17...M51)+@CHOOSE(A66+7,M17...M51)+@CHOOSE(A66+14,M17...M51)+@CHOOSE(A66+21,M17...M51)+@CHOOSE(A66+28,M17...M51) >L66:@CHOOSE(A66,L17...L51)+@CHOOSE(A66+7,L17...L51)+14,P17...P51)+@CHOOSE(A66+21,P17...P51)+@CHOOSE(A66+28,P17...P51) >O66:@CHOOSE(A66,O17...O51)+@CHOOSE(A66+7,O17...O51)+@CHOOSE(A66+14,O17...O51)+@CHOOSE(A66+21,O17...O51)+@CHOOSE(A66+28,O17...O51) >N66:@CHOOSE(A66,N17...N51)+@CHOOSE(A66+7,N17...N51)+@CHOOS(G5=30,@OR(C17=5,C18=5)),D66/(5-J3),D66/(4-J3)))) >B67:"AVG >Q66:@CHOOSE(A66,Q17...Q51)+@CHOOSE(A66+7,Q17...Q51)+@CHOOSE(A66+14,Q17...Q51)+@CHOOSE(A66+21,Q17...Q51)+@CHOOSE(A66+28,Q17...Q51) >P66:@CHOOSE(A66,P17...P51)+@CHOOSE(A66+7,P17...P51)+@CHOOSE(A66+,F66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),F66/(5-J3),F66/(4-J3)))) >E67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),E66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),E66/(5-J3),E66/(4-J3)))) >D67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),D66/(5-J3),@IF(@AND(C17=5,C18=5,C19=5)),H66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),H66/(5-J3),H66/(4-J3)))) >G67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),G66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),G66/(5-J3),G66/(4-J3)))) >F67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5))T(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),J66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),J66/(5-J3),J66/(4-J3)))) >I67:@INT(@IF(@AND(G5=31,@OR(C17=5,C18=5,C19=5)),I66/(5-J3),@IF(@AND(G5=30,@OR(C17=5,C18=5)),I66/(5-J3),I66/(4-J3)))) >H67:@INT(@IF(@AND(G5=31,@OR18=4,C19=4)),J63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),J63/(5-I3),J63/(4-I3)))) >I64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),I63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),I63/(5-I3),I63/(4-I3)))) >H64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),H63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),H63/(5-I3),H63/(4-I3)))) >G64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),G63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),G63/(5-I3),G63/(4-I3)))) >F64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),F63/(5-I3),@IF(@AND(G5=30,@C18=3)),H60/(5-H3),H60/(4-H3)))) >G61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),G60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),G60/(5-H3),G60/(4-H3)))) >F61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),F60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),F60/(5-H3),FAND(G5=30,@OR(C17=3,C18=3)),J60/(5-H3),J60/(4-H3)))) >I61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),I60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),I60/(5-H3),I60/(4-H3)))) >H61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),H60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,3)),L60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),L60/(5-H3),L60/(4-H3)))) >K61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),K60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),K60/(5-H3),K60/(4-H3)))) >J61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),J60/(5-H3),@IF(@@OR(C17=3,C18=3,C19=3)),N60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),N60/(5-H3),N60/(4-H3)))) >M61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),M60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),M60/(5-H3),M60/(4-H3)))) >L61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),P60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),P60/(5-H3),P60/(4-H3)))) >O61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),O60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),O60/(5-H3),O60/(4-H3)))) >N61:@INT(@IF(@AND(G5=31,OSE(A63+14,D17...D51)+@CHOOSE(A63+21,D17...D51)+@CHOOSE(A63+28,D17...D51) >C63:"AYS >B63:"WEDNESD >A63:/FL@IF(12-C17>7,5-C17,12-C17) >Q61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),Q60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),Q60/(5-H3),Q60/(4-H3)))) >P61:3+14,F17...F51)+@CHOOSE(A63+21,F17...F51)+@CHOOSE(A63+28,F17...F51) >E63:@CHOOSE(A63,E17...E51)+@CHOOSE(A63+7,E17...E51)+@CHOOSE(A63+14,E17...E51)+@CHOOSE(A63+21,E17...E51)+@CHOOSE(A63+28,E17...E51) >D63:@CHOOSE(A63,D17...D51)+@CHOOSE(A63+7,D17...D51)+@CHO17...H51)+@CHOOSE(A63+21,H17...H51)+@CHOOSE(A63+28,H17...H51) >G63:@CHOOSE(A63,G17...G51)+@CHOOSE(A63+7,G17...G51)+@CHOOSE(A63+14,G17...G51)+@CHOOSE(A63+21,G17...G51)+@CHOOSE(A63+28,G17...G51) >F63:@CHOOSE(A63,F17...F51)+@CHOOSE(A63+7,F17...F51)+@CHOOSE(A651)+@CHOOSE(A63+21,J17...J51)+@CHOOSE(A63+28,J17...J51) >I63:@CHOOSE(A63,I17...I51)+@CHOOSE(A63+7,I17...I51)+@CHOOSE(A63+14,I17...I51)+@CHOOSE(A63+21,I17...I51)+@CHOOSE(A63+28,I17...I51) >H63:@CHOOSE(A63,H17...H51)+@CHOOSE(A63+7,H17...H51)+@CHOOSE(A63+14,HHOOSE(A63+21,L17...L51)+@CHOOSE(A63+28,L17...L51) >K63:@CHOOSE(A63,K17...K51)+@CHOOSE(A63+7,K17...K51)+@CHOOSE(A63+14,K17...K51)+@CHOOSE(A63+21,K17...K51)+@CHOOSE(A63+28,K17...K51) >J63:@CHOOSE(A63,J17...J51)+@CHOOSE(A63+7,J17...J51)+@CHOOSE(A63+14,J17...JA63+21,N17...N51)+@CHOOSE(A63+28,N17...N51) >M63:@CHOOSE(A63,M17...M51)+@CHOOSE(A63+7,M17...M51)+@CHOOSE(A63+14,M17...M51)+@CHOOSE(A63+21,M17...M51)+@CHOOSE(A63+28,M17...M51) >L63:@CHOOSE(A63,L17...L51)+@CHOOSE(A63+7,L17...L51)+@CHOOSE(A63+14,L17...L51)+@C,P17...P51)+@CHOOSE(A63+28,P17...P51) >O63:@CHOOSE(A63,O17...O51)+@CHOOSE(A63+7,O17...O51)+@CHOOSE(A63+14,O17...O51)+@CHOOSE(A63+21,O17...O51)+@CHOOSE(A63+28,O17...O51) >N63:@CHOOSE(A63,N17...N51)+@CHOOSE(A63+7,N17...N51)+@CHOOSE(A63+14,N17...N51)+@CHOOSE(/(5-I3),D63/(4-I3)))) >B64:"AVG >Q63:@CHOOSE(A63,Q17...Q51)+@CHOOSE(A63+7,Q17...Q51)+@CHOOSE(A63+14,Q17...Q51)+@CHOOSE(A63+21,Q17...Q51)+@CHOOSE(A63+28,Q17...Q51) >P63:@CHOOSE(A63,P17...P51)+@CHOOSE(A63+7,P17...P51)+@CHOOSE(A63+14,P17...P51)+@CHOOSE(A63+21OR(C17=4,C18=4)),F63/(5-I3),F63/(4-I3)))) >E64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),E63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),E63/(5-I3),E63/(4-I3)))) >D64:@INT(@IF(@AND(G5=31,@OR(C17=4,C18=4,C19=4)),D63/(5-I3),@IF(@AND(G5=30,@OR(C17=4,C18=4)),D6360/(4-H3)))) >E61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),E60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),E60/(5-H3),E60/(4-H3)))) >D61:@INT(@IF(@AND(G5=31,@OR(C17=3,C18=3,C19=3)),D60/(5-H3),@IF(@AND(G5=30,@OR(C17=3,C18=3)),D60/(5-H3),D60/(4-H3)))) >B61:"AVG >Q60:@CHOOSE(A60,Q17...Q51)+@CHOOSE(A60+7,Q17...Q51)+@CHOOSE(A60+14,Q17...Q51)+@CHOOSE(A60+21,Q17...Q51)+@CHOOSE(A60+28,Q17...Q51) >P60:@CHOOSE(A60,P17...P51)+@CHOOSE(A60+7,P17...P51)+@CHOOSE(A60+14,P17...P51)+@CHOOSE(A60+21,P17...P51)+@CHOOSE(A60+28,P1+@CHOOSE(A57+7,Q17...Q51)+@CHOOSE(A57+14,Q17...Q51)+@CHOOSE(A57+21,Q17...Q51)+@CHOOSE(A57+28,Q17...Q51) >P57:@CHOOSE(A57,P17...P51)+@CHOOSE(A57+7,P17...P51)+@CHOOSE(A57+14,P17...P51)+@CHOOSE(A57+21,P17...P51)+@CHOOSE(A57+28,P17...P51) >O57:@CHOOSE(A57,O17.D(G5=31,@OR(C17=2,C18=2,C19=2)),E57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),E57/(5-G3),E57/(4-G3)))) >D58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),D57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),D57/(5-G3),D57/(4-G3)))) >B58:"AVG >Q57:@CHOOSE(A57,Q17...Q51))) >G58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),G57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),G57/(5-G3),G57/(4-G3)))) >F58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),F57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),F57/(5-G3),F57/(4-G3)))) >E58:@INT(@IF(@AN7/(5-G3),J57/(4-G3)))) >I58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),I57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),I57/(5-G3),I57/(4-G3)))) >H58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),H57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),H57/(5-G3),H57/(4-G3))@OR(C17=2,C18=2)),L57/(5-G3),L57/(4-G3)))) >K58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),K57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),K57/(5-G3),K57/(4-G3)))) >J58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),J57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),J5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),N57/(5-G3),N57/(4-G3)))) >M58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),M57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),M57/(5-G3),M57/(4-G3)))) >L58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),L57/(5-G3),@IF(@AND(G5=30,C18=2,C19=2)),P57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),P57/(5-G3),P57/(4-G3)))) >O58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),O57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),O57/(5-G3),O57/(4-G3)))) >N58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),N57/(5(A60+21,D17...D51)+@CHOOSE(A60+28,D17...D51) >C60:"S >B60:"TUESDAYS >A60:/FL@IF(11-C17>7,4-C17,11-C17) >Q58:@INT(@IF(@AND(G5=31,@OR(C17=2,C18=2,C19=2)),Q57/(5-G3),@IF(@AND(G5=30,@OR(C17=2,C18=2)),Q57/(5-G3),Q57/(4-G3)))) >P58:@INT(@IF(@AND(G5=31,@OR(C17=2,1,F17...F51)+@CHOOSE(A60+28,F17...F51) >E60:@CHOOSE(A60,E17...E51)+@CHOOSE(A60+7,E17...E51)+@CHOOSE(A60+14,E17...E51)+@CHOOSE(A60+21,E17...E51)+@CHOOSE(A60+28,E17...E51) >D60:@CHOOSE(A60,D17...D51)+@CHOOSE(A60+7,D17...D51)+@CHOOSE(A60+14,D17...D51)+@CHOOSE..H51)+@CHOOSE(A60+28,H17...H51) >G60:@CHOOSE(A60,G17...G51)+@CHOOSE(A60+7,G17...G51)+@CHOOSE(A60+14,G17...G51)+@CHOOSE(A60+21,G17...G51)+@CHOOSE(A60+28,G17...G51) >F60:@CHOOSE(A60,F17...F51)+@CHOOSE(A60+7,F17...F51)+@CHOOSE(A60+14,F17...F51)+@CHOOSE(A60+2+@CHOOSE(A60+28,J17...J51) >I60:@CHOOSE(A60,I17...I51)+@CHOOSE(A60+7,I17...I51)+@CHOOSE(A60+14,I17...I51)+@CHOOSE(A60+21,I17...I51)+@CHOOSE(A60+28,I17...I51) >H60:@CHOOSE(A60,H17...H51)+@CHOOSE(A60+7,H17...H51)+@CHOOSE(A60+14,H17...H51)+@CHOOSE(A60+21,H17.SE(A60+28,L17...L51) >K60:@CHOOSE(A60,K17...K51)+@CHOOSE(A60+7,K17...K51)+@CHOOSE(A60+14,K17...K51)+@CHOOSE(A60+21,K17...K51)+@CHOOSE(A60+28,K17...K51) >J60:@CHOOSE(A60,J17...J51)+@CHOOSE(A60+7,J17...J51)+@CHOOSE(A60+14,J17...J51)+@CHOOSE(A60+21,J17...J51)+28,N17...N51) >M60:@CHOOSE(A60,M17...M51)+@CHOOSE(A60+7,M17...M51)+@CHOOSE(A60+14,M17...M51)+@CHOOSE(A60+21,M17...M51)+@CHOOSE(A60+28,M17...M51) >L60:@CHOOSE(A60,L17...L51)+@CHOOSE(A60+7,L17...L51)+@CHOOSE(A60+14,L17...L51)+@CHOOSE(A60+21,L17...L51)+@CHOO7...P51) >O60:@CHOOSE(A60,O17...O51)+@CHOOSE(A60+7,O17...O51)+@CHOOSE(A60+14,O17...O51)+@CHOOSE(A60+21,O17...O51)+@CHOOSE(A60+28,O17...O51) >N60:@CHOOSE(A60,N17...N51)+@CHOOSE(A60+7,N17...N51)+@CHOOSE(A60+14,N17...N51)+@CHOOSE(A60+21,N17...N51)+@CHOOSE(A60..O51)+@CHOOSE(A57+7,O17...O51)+@CHOOSE(A57+14,O17...O51)+@CHOOSE(A57+21,O17...O51)+@CHOOSE(A57+28,O17...O51) >N57:@CHOOSE(A57,N17...N51)+@CHOOSE(A57+7,N17...N51)+@CHOOSE(A57+14,N17...N51)+@CHOOSE(A57+21,N17...N51)+@CHOOSE(A57+28,N17...N51) >M57:@CHOOSE(A57,M17...M51)+@CHOOSE(A57+7,M17...M51)+@CHOOSE(A57+14,M17...M51)+@CHOOSE(A57+21,M17...M51)+@CHOOSE(A57+28,M17...M51) >L57:@CHOOSE(A57,L17...L51)+@CHOOSE(A57+7,L17...L51)+@CHOOSE(A57+14,L17...L51)+@CHOOSE(A57+21,L17...L51)+@CHOOSE(A57+28,L17...L51) >K57:@CHO) >B45:/FL29 >Q44:@SUM(D44...P44) >P44:" .... >O44:" .... >N44:" .... >M44:" .... >L44:" .... >K44:" .... >J44:" .... >I44:" .... >H44:" .... >G44:" .... >F44:" .... >E44:" .... >D44:" .... >C44:/FL+@IF(C43=7,1,C43+1) >B44:/FL28 >(C45=7,1,C45+1) >B46:/FL30 >Q45:@SUM(D45...P45) >P45:" .... >O45:" .... >N45:" .... >M45:" .... >L45:" .... >K45:" .... >J45:" .... >I45:" .... >H45:" .... >G45:" .... >F45:" .... >E45:" .... >D45:" .... >C45:/FL+@IF(C44=7,1,C44+1. >D47:" .... >C47:/FL+@IF(C46=7,1,C46+1) >B47:/FL31 >Q46:0 >P46:" .... >O46:" .... >N46:" .... >M46:" .... >L46:" .... >K46:" .... >J46:" .... >I46:" .... >H46:" .... >G46:" .... >F46:" .... >E46:" .... >D46:" .... >C46:/FL+@IF31,@OR(C17=1,C18=1,C19=1)),5,@IF(@AND(G5=30,@OR(C17=1,C18=1)),5,4))) >Q47:@SUM(D47...P47) >P47:" .... >O47:" .... >N47:" .... >M47:" .... >L47:" .... >K47:" .... >J47:" .... >I47:" .... >H47:" .... >G47:" .... >F47:" .... >E47:" .....N47) >M52:@SUM(M17...M47) >L52:@SUM(L17...L47) >K52:@SUM(K17...K47) >J52:@SUM(J17...J47) >I52:@SUM(I17...I47) >H52:@SUM(H17...H47) >G52:@SUM(G17...G47) >F52:@SUM(F17...F47) >E52:@SUM(E17...E47) >D52:@SUM(D17...D47) >B52:"TOTALS >A52:/FL@INT(@IF(@AND(G5=F17...F47)) >E53:@IF(@ISERROR(@AVERAGE(E17...E47)),0,@AVERAGE(E17...E47)) >D53:@IF(@ISERROR(@AVERAGE(D17...D47)),0,@AVERAGE(D17...D47)) >B53:"AVG >A53:/FL@IF(9-C17>7,2-C17,9-C17) >Q52:@SUM(Q17...Q47) >P52:@SUM(P17...P47) >O52:@SUM(O17...O47) >N52:@SUM(N17.AVERAGE(J17...J47)) >I53:@IF(@ISERROR(@AVERAGE(I17...I47)),0,@AVERAGE(I17...I47)) >H53:@IF(@ISERROR(@AVERAGE(H17...H47)),0,@AVERAGE(H17...H47)) >G53:@IF(@ISERROR(@AVERAGE(G17...G47)),0,@AVERAGE(G17...G47)) >F53:@IF(@ISERROR(@AVERAGE(F17...F47)),0,@AVERAGE(47)),0,@AVERAGE(N17...N47)) >M53:@IF(@ISERROR(@AVERAGE(M17...M47)),0,@AVERAGE(M17...M47)) >L53:@IF(@ISERROR(@AVERAGE(L17...L47)),0,@AVERAGE(L17...L47)) >K53:@IF(@ISERROR(@AVERAGE(K17...K47)),0,@AVERAGE(K17...K47)) >J53:@IF(@ISERROR(@AVERAGE(J17...J47)),0,@ >E55:"--------- >D55:"--------- >C55:"--------- >B55:"--------- >Q53:+Q52/(G5-@SUM(G3...L3)-A52) >P53:@IF(@ISERROR(@AVERAGE(P17...P47)),0,@AVERAGE(P17...P47)) >O53:@IF(@ISERROR(@AVERAGE(O17...O47)),0,@AVERAGE(O17...O47)) >N53:@IF(@ISERROR(@AVERAGE(N17...N+28,D17...D51) >B57:"MONDAYS >A57:/FL@IF(10-C17>7,3-C17,10-C17) >Q55:"--------- >P55:"--------- >O55:"--------- >N55:"--------- >M55:"--------- >L55:"--------- >K55:"--------- >J55:"--------- >I55:"--------- >H55:"--------- >G55:"--------- >F55:"---------7...F51) >E57:@CHOOSE(A57,E17...E51)+@CHOOSE(A57+7,E17...E51)+@CHOOSE(A57+14,E17...E51)+@CHOOSE(A57+21,E17...E51)+@CHOOSE(A57+28,E17...E51) >D57:@CHOOSE(A57,D17...D51)+@CHOOSE(A57+7,D17...D51)+@CHOOSE(A57+14,D17...D51)+@CHOOSE(A57+21,D17...D51)+@CHOOSE(A571) >G57:@CHOOSE(A57,G17...G51)+@CHOOSE(A57+7,G17...G51)+@CHOOSE(A57+14,G17...G51)+@CHOOSE(A57+21,G17...G51)+@CHOOSE(A57+28,G17...G51) >F57:@CHOOSE(A57,F17...F51)+@CHOOSE(A57+7,F17...F51)+@CHOOSE(A57+14,F17...F51)+@CHOOSE(A57+21,F17...F51)+@CHOOSE(A57+28,F17:@CHOOSE(A57,I17...I51)+@CHOOSE(A57+7,I17...I51)+@CHOOSE(A57+14,I17...I51)+@CHOOSE(A57+21,I17...I51)+@CHOOSE(A57+28,I17...I51) >H57:@CHOOSE(A57,H17...H51)+@CHOOSE(A57+7,H17...H51)+@CHOOSE(A57+14,H17...H51)+@CHOOSE(A57+21,H17...H51)+@CHOOSE(A57+28,H17...H5OSE(A57,K17...K51)+@CHOOSE(A57+7,K17...K51)+@CHOOSE(A57+14,K17...K51)+@CHOOSE(A57+21,K17...K51)+@CHOOSE(A57+28,K17...K51) >J57:@CHOOSE(A57,J17...J51)+@CHOOSE(A57+7,J17...J51)+@CHOOSE(A57+14,J17...J51)+@CHOOSE(A57+21,J17...J51)+@CHOOSE(A57+28,J17...J51) >I5Q43:@SUM(D43...P43) >P43:" .... >O43:" .... >N43:" .... >M43:" .... >L43:" .... >K43:" .... >J43:" .... >I43:" .... >H43:" .... >G43:" .... >F43:" .... >E43:" .... >D43:" .... >C43:/FL+@IF(C42=7,1,C42+1) >B43:/FL27 >Q42:@SUM(D42...P42) >P42:" .... >O42:" .... >N42:" .... >M42:" .... >L42:" .... >K42:" .... >J42:" .... >I42:" .... >H42:" .... >G42:" .... >F42:" .... >E42:" .... >D42:" .... >C42:/FL+@IF(C41=7,1,C41+1) >B42:/FL+B41+1 >Q41:@SUM(D41...P41) >P41 .... >D28:" .... >C28:/FL+@IF(C27=7,1,C27+1) >B28:/FL+B27+1 >Q27:@SUM(D27...P27) >P27:" .... >O27:" .... >N27:" .... >M27:" .... >L27:" .... >K27:" .... >J27:" .... >I27:" .... >H27:" .... >G27:" .... >F27:" .... >E27:" .... >D27. >E29:" .... >D29:" .... >C29:/FL+@IF(C28=7,1,C28+1) >B29:/FL+B28+1 >Q28:@SUM(D28...P28) >P28:" .... >O28:" .... >N28:" .... >M28:" .... >L28:" .... >K28:" .... >J28:" .... >I28:" .... >H28:" .... >G28:" .... >F28:" .... >E28:" 30:" .... >E30:" .... >D30:" .... >C30:/FL+@IF(C29=7,1,C29+1) >B30:/FL+B29+1 >Q29:@SUM(D29...P29) >P29:" .... >O29:" .... >N29:" .... >M29:" .... >L29:" .... >K29:" .... >J29:" .... >I29:" .... >H29:" .... >G29:" .... >F29:" ... .... >F31:" .... >E31:" .... >D31:" .... >C31:/FL+@IF(C30=7,1,C30+1) >B31:/FL+B30+1 >Q30:@SUM(D30...P30) >P30:" .... >O30:" .... >N30:" .... >M30:" .... >L30:" .... >K30:" .... >J30:" .... >I30:" .... >H30:" .... >G30:" .... >F... >G32:" .... >F32:" .... >E32:" .... >D32:" .... >C32:/FL+@IF(C31=7,1,C31+1) >B32:/FL+B31+1 >Q31:@SUM(D31...P31) >P31:" .... >O31:" .... >N31:" .... >M31:" .... >L31:" .... >K31:" .... >J31:" .... >I31:" .... >H31:" .... >G31:">I33:" .... >H33:" .... >G33:" .... >F33:" .... >E33:" .... >D33:" .... >C33:/FL+@IF(C32=7,1,C32+1) >B33:/FL+B32+1 >Q32:0 >P32:" .... >O32:" .... >N32:" .... >M32:" .... >L32:" .... >K32:" .... >J32:" .... >I32:" .... >H32:" .:" .... >I34:" .... >H34:" .... >G34:" .... >F34:" .... >E34:" .... >D34:" .... >C34:/FL+@IF(C33=7,1,C33+1) >B34:/FL+B33+1 >Q33:@SUM(D33...P33) >P33:" .... >O33:" .... >N33:" .... >M33:" .... >L33:" .... >K33:" .... >J33:" .... .... >J35:" .... >I35:" .... >H35:" .... >G35:" .... >F35:" .... >E35:" .... >D35:" .... >C35:/FL+@IF(C34=7,1,C34+1) >B35:/FL+B34+1 >Q34:@SUM(D34...P34) >P34:" .... >O34:" .... >N34:" .... >M34:" .... >L34:" .... >K34:" .... >J34. >K36:" .... >J36:" .... >I36:" .... >H36:" .... >G36:" .... >F36:" .... >E36:" .... >D36:" .... >C36:/FL+@IF(C35=7,1,C35+1) >B36:/FL+B35+1 >Q35:@SUM(D35...P35) >P35:" .... >O35:" .... >N35:" .... >M35:" .... >L35:" .... >K35:" 37:" .... >K37:" .... >J37:" .... >I37:" .... >H37:" .... >G37:" .... >F37:" .... >E37:" .... >D37:" .... >C37:/FL+@IF(C36=7,1,C36+1) >B37:/FL+B36+1 >Q36:@SUM(D36...P36) >P36:" .... >O36:" .... >N36:" .... >M36:" .... >L36:" ... .... >L38:" .... >K38:" .... >J38:" .... >I38:" .... >H38:" .... >G38:" .... >F38:" .... >E38:" .... >D38:" .... >C38:/FL+@IF(C37=7,1,C37+1) >B38:/FL+B37+1 >Q37:@SUM(D37...P37) >P37:" .... >O37:" .... >N37:" .... >M37:" .... >L... >M39:" .... >L39:" .... >K39:" .... >J39:" .... >I39:" .... >H39:" .... >G39:" .... >F39:" .... >E39:" .... >D39:" .... >C39:/FL+@IF(C38=7,1,C38+1) >B39:/FL+B38+1 >Q38:@SUM(D38...P38) >P38:" .... >O38:" .... >N38:" .... >M38:">O40:" .... >N40:" .... >M40:" .... >L40:" .... >K40:" .... >J40:" .... >I40:" .... >H40:" .... >G40:" .... >F40:" .... >E40:" .... >D40:" .... >C40:/FL+@IF(C39=7,1,C39+1) >B40:/FL+B39+1 >Q39:0 >P39:" .... >O39:" .... >N39:" .:" .... >O41:" .... >N41:" .... >M41:" .... >L41:" .... >K41:" .... >J41:" .... >I41:" .... >H41:" .... >G41:" .... >F41:" .... >E41:" .... >D41:" .... >C41:/FL+@IF(C40=7,1,C40+1) >B41:/FL+B40+1 >Q40:@SUM(D40...P40) >P40:" .... :" .... >C27:/FL+@IF(C26=7,1,C26+1) >B27:/FL+B26+1 >Q26:@SUM(D26...P26) >P26:" .... >O26:" .... >N26:" .... >M26:" .... >L26:" .... >K26:" .... >J26:" .... >I26:" .... >H26:" .... >G26:" .... >F26:" .... >E26:" .... >D26:" .... >C26:/FL+@IF(C25=7,1,C25+1) >B26:/FL+B25+1 >Q25:@SUM(D25...P25) >P25:" .... >O25:" .... >N25:" .... >M25:" .... >L25:" .... >K25:" .... >J25:" .... >I25:" .... >H25:" .... >G25:" .... >F25:" .... >E25:" .... >D25:" .... >C25:/FL+@ED O >D3:" BANK C >C3:"WAS THE >B3:"Y DAYS >A3:"HOW MANY >L2:" SAT >K2:" FRI >J2:" THUR >I2:" WED >H2:" TUE >G2:" MON >F1:"COUNTS >E1:"ACTION >D1:"R TRANS >C1:"Y TELLE >B1:" - DAIL >A1:"MODEL 4 /W1 /GOR /GRM /GFI /GC7 /X>A1:>A1: 1: >O5:".) >N5:"O ENTRY >M5:"RE IS NO >L5:" IF THERE >K5:"S BLANK >J5:"VE CELLS >I5:"E : LEAV >H5:" (NOTE >G5:31 >F5:"H ---> >E5:"NT MONT >D5:" CURRENT >C5:" IN THE >B5:"OF DAYS >A5:"NUMBER OF >L3:0 >K3:0 >J3:0 >I3:0 >H3:0 >G3:0 >F3:"N ----> >E3:"LOSANS >G11:"DAILY TELLER TRANSACTIONS BY HOUR >P7:".) >O7:"A # "1". >N7:"DAY IS >M7:" 7. SUND >L7:"OM 1 TO >K7:"MBER FROM >J7:"UT A NUMBER >I7:"E : INPUT >H7:"<--(NOTE >G7:7 >F7:" START-> >E7:"E MONTH >D7:"DOES THE >C7:"E WEEK >B7:"Y OF THE >A7:"WHAT DAY"--------- >J13:"--------- >I13:"--------- >H13:"--------- >G13:"--------- >F13:"--------- >E13:"--------- >D13:"--------- >C13:"--------- >B13:"--------- >I12:"........ >H12:"....... >L11:"UR >K11:"T BY HOUR >J11:"ON COUN >I11:"RANACTION CO >H11:"ELLER TRL14:/FR"3-4 >K14:/FR"2-3 >J14:/FR"1-2 >I14:/FR"12-1 >H14:/FR"11-12 >G14:/FR"10-11 >F14:/FL" 9-10 >E14:/FL" 8-9 >D14:/FL" 7-8 >C14:"DAY >B14:"DATE >Q13:"--------- >P13:"--------- >O13:"--------- >N13:"--------- >M13:"--------- >L13:"--------- >K13::"--------- >L15:"--------- >K15:"--------- >J15:"--------- >I15:"--------- >H15:"--------- >G15:"--------- >F15:"--------- >E15:"--------- >D15:"--------- >C15:"--------- >B15:"--------- >Q14:/FR"TOTAL >P14:/FR"7-8 >O14:/FR"6-7 >N14:/FR"5-6 >M14:/FR"4-5 >17:" .... >N17:" .... >M17:" .... >L17:" .... >K17:" .... >J17:" .... >I17:" .... >H17:" .... >G17:" .... >F17:" .... >E17:" .... >D17:" .... >C17:/FL+G7 >B17:/FL1 >Q15:"--------- >P15:"--------- >O15:"--------- >N15:"--------- >M15 .... >O18:" .... >N18:" .... >M18:" .... >L18:" .... >K18:" .... >J18:" .... >I18:" .... >H18:" .... >G18:" .... >F18:" .... >E18:" .... >D18:" .... >C18:/FL+@IF(C17=7,1,C17+1) >B18:/FL+B17+1 >Q17:@SUM(D17...P17) >P17:" .... >O19) >P19:" .... >O19:" .... >N19:" .... >M19:" .... >L19:" .... >K19:" .... >J19:" .... >I19:" .... >H19:" .... >G19:" .... >F19:" .... >E19:" .... >D19:" .... >C19:/FL+@IF(C18=7,1,C18+1) >B19:/FL+B18+1 >Q18:@SUM(D18...P18) >P18:"UM(D20...P20) >P20:" .... >O20:" .... >N20:" .... >M20:" .... >L20:" .... >K20:" .... >J20:" .... >I20:" .... >H20:" .... >G20:" .... >F20:" .... >E20:" .... >D20:" .... >C20:/FL+@IF(C19=7,1,C19+1) >B20:/FL+B19+1 >Q19:@SUM(D19...P+1 >Q21:@SUM(D21...P21) >P21:" .... >O21:" .... >N21:" .... >M21:" .... >L21:" .... >K21:" .... >J21:" .... >I21:" .... >H21:" .... >G21:" .... >F21:" .... >E21:" .... >D21:" .... >C21:/FL+@IF(C20=7,1,C20+1) >B21:/FL+B20+1 >Q20:@S23:/FL+B22+1 >Q22:@SUM(D22...P22) >P22:" .... >O22:" .... >N22:" .... >M22:" .... >L22:" .... >K22:" .... >J22:" .... >I22:" .... >H22:" .... >G22:" .... >F22:" .... >E22:" .... >D22:" .... >C22:/FL+@IF(C21=7,1,C21+1) >B22:/FL+B21,C23+1) >B24:/FL+B23+1 >Q23:@SUM(D23...P23) >P23:" .... >O23:" .... >N23:" .... >M23:" .... >L23:" .... >K23:" .... >J23:" .... >I23:" .... >H23:" .... >G23:" .... >F23:" .... >E23:" .... >D23:" .... >C23:/FL+@IF(C22=7,1,C22+1) >BIF(C24=7,1,C24+1) >B25:/FL+B24+1 >Q24:@SUM(D24...P24) >P24:" .... >O24:" .... >N24:" .... >M24:" .... >L24:" .... >K24:" .... >J24:" .... >I24:" .... >H24:" .... >G24:" .... >F24:" .... >E24:" .... >D24:" .... >C24:/FL+@IF(C23=7,1 >I160:" ========= >I159:/F$+I156-I157 >H159:".........$ >G159:/-. >F159:".......... >E159:"OR EXCESS >D159:" REQUIRED >C159:"AL BALANCE RE >B159:" ADDITION >I158:" --------- >I157:/F$+I115 >H157:"......... >G157:/-. >F157:".......... >E157:"ES ....... >D ========= >E122:" ========= >D122:"========== >C122:"========== >B122:"========== >I121:" COLL.BAL. >H121:" CASH FEE >G121:" PER UNIT >F121:" PER UNIT >E121:" VOLUME >D121:"N >C121:"DESCRIPTIO >I120:" TOTAL >H120:" TOTAL >G120:" COLL.BAL. >F120:" CASDEPOSITS >I124:/F$+E124*G124 >H124:/F$+E124*F124 >G124:/F$@INT(+F124*D88*100+.5)/100 >F124:/F$5 >E124:1 >C124:"INTENANCE >B124:"ACCOUNT MA >I123:" $ >H123:" $ >G123:" $ >F123:" $ >I122:" ========= >H122:" ========= >G122:" ========= >F122:" >B127:"CHECKS PAI >I126:/F$+E126*G126 >H126:/F$+E126*F126 >G126:/F$@INT(+F126*D88*100+.5)/100 >F126:/F$.1 >E126:+D35 >C126:"OSITED >B126:"CHECKS DEP >I125:/F$+E125*G125 >H125:/F$+E125*F125 >G125:/F$@INT(+F125*D88*100+.5)/100 >F125:/F$.3 >E125:+D32 >B125:":"OVERDRAFTS >I128:/F$+E128*G128 >H128:/F$+E128*F128 >G128:/F$@INT(+F128*D88*100+.5)/100 >F128:/F$10 >E128:+D40 >C128:"RGED BACK >B128:"CHECKS CHAR >I127:/F$+E127*G127 >H127:/F$+E127*F127 >G127:/F$@INT(+F127*D88*100+.5)/100 >F127:/F$.15 >E127:+D37 >C127:"D"NTS >B131:"STOP PAYME >I130:/F$+E130*G130 >H130:/F$+E130*F130 >G130:/F$@INT(+F130*D88*100+.5)/100 >F130:/F$10 >E130:+D44 >C130:"FERS >B130:"WIRE TRANS >I129:/F$+E129*G129 >H129:/F$+E129*F129 >G129:/F$@INT(+F129*D88*100+.5)/100 >F129:/F$10 >E129:+D42 >B129133:"CHECKS FINE >I132:/F$+E132*G132 >H132:/F$+E132*F132 >G132:/F$@INT(+F132*D88*100+.5)/100 >F132:/F$1 >E132:+D49 >C132:"ATEMENTS >B132:"SPECIAL STA >I131:/F$+E131*G131 >H131:/F$+E131*F131 >G131:/F$@INT(+F131*D88*100+.5)/100 >F131:/F$7.5 >E131:+D46 >C131:+E134*G134 >H134:/F$+E134*F134 >G134:/F$@INT(+F134*D88*100+.5)/100 >F134:/F$.05 >E134:+D56 >D134:"TED >C134:"D / DEPOSI >B134:"COIN ISSUE >I133:/F$+E133*G133 >H133:/F$+E133*F133 >G133:/F$@INT(+F133*D88*100+.5)/100 >F133:/F$.02 >E133:+D52 >C133:"E SORTED >BI136) >H137:/F$@SUM(H124...H136) >C137:"TOTALS >B137:" >I136:" --------- >H136:" --------- >I135:/F$+E135*G135 >H135:/F$+E135*F135 >G135:/F$@INT(+F135*D88*100+.5)/100 >F135:/F$1 >E135:+D26/1000 >D135:"POSITED >C135:"SSUED / DE >B135:"CURRENCY I >I134:/F$:"********* >E143:/-* >F142:" * >E142:"* >I141:/-* >H141:/-* >G141:/-* >F141:"SUMMARY ** >E141:"* ACCOUNT >D141:/-* >C141:/-* >B141:/-* >F140:" * >E140:"* >F139:"********* >E139:/-* >I138:" ========== >H138:" ========== >I137:/F$@SUM(I124...>E149:"% ON $ >D149:+D63 >C149:" CREDIT AT >B149:" EARNINGS >H148:/F$+H137 >G148:".........$ >F148:"ED ....... >E148:"ES PERFORM >D148:"FOR SERVICES >C148:" REQUIRED >B148:" CASH FEE >H147:/F$ >D146:"FEE DUE: >C146:"N OF CASH >B146:"COMPUTATIO >F143F COLLECTED >B154:"COMPUTATION >H152:" ========= >H151:/F$@IF(H148-H149<0,@NA,H148-H149) >G151:".........$ >F151:/-. >E151:/-. >D151:/-. >C151:" DUE ..... >B151:" CASH FEE >H150:" --------- >H149:/F$@INT(+D149*F149/12+.5)/100 >G149:"......... >F149:+I115 157:"FOR SERVIC >C157:"AVAILABLE >B157:" BALANCE AV >I156:/F$+I137 >H156:".........$ >G156:"D ........ >F156:"S PERFORME >E156:"OR SERVICES >D156:"REQUIRED F >C156:"D BALANCE R >B156:" COLLECTED >F154:"D: >E154:"CE REQUIRED >D154:"CTED BALANCE >C154:"N OH FEE >G118:"TH >F118:"OR THE MONTH >E118:"ACTIVITY F >I115:/F$+I113-I114 >H115:".........$ >G115:"........... >F115:"........... >E115:" .......... >D115:"R SERVICES >C115:"AILABLE FOR >B115:"BALANCE AVA >I114:/F$+D22 >H114:"......... >G114:"........... >F114:"........... >E114:"........... >D114:"ALANCES ... >C114:"ENSATING BA >B114:"LESS: COMPENSAT >I113:/F$+I111-I112 >H113:".........$ >G113:"........... >F113:"........... >E113:"........... >D113:"ALANCE .... >C113:"OLLECTED B >B113:"ADJUSTED C >I112:/F MENU.MAKER TEXT MODULESEG=0"MENU.MAKER"890&*X=11000: TEXT SLOW-DOWN LOOP ,X.1,180,22:2,280,21:2,2380,23:z:A$="LISTING "+B$(I),16,B)$=01:=0::"80C";A$;::12)>=23:=0::" 1. AVG. >C13:" AMOUNT: >B13:" A. DOLLAR >B11:"========== >C10:": >B10:"DATA ENTRY >C1:"ALYSIS >B1:"ACCOUNT AN >A1:"MODEL 5 - /W1 /GOC /GRM /GC10 /X>A1:>A1: 1: >D22:/F$" ........ >C22:"NCE ....... >B22:" BALA >C21:"ENSATING >B21:" 3. COMPEN >D19:/F$" ........ >C19:"NCE ....... >B19:" BALA >C18:" COLLECTED >B18:" 2. AVG. >D16:/F$" ....... >C16:"NCE ....... >B16:" BALA >C15:" LEDGER >B15:"SITED .... >B35:" DEPOSITED >C34:"KS >B34:" 2. CHEC >D32:" ....... >C32:"SITS MADE. >B32:" 1. DEPO >C30:" OF: >B30:" B. NUMBER >D26:/F$" ....... >C26:"SITED..... >B26:" DEPO >C25:"ED AND/OR >B25:" ISSUE >C24:"ENCY >B24:" 4. CURR 4:" ....... >C44:" TRANSFERS >B44:" 6. WIRE >D42:" ....... >C42:"DRAFTS.... >B42:" 5. OVERD >D40:" ....... >C40:"GED BACK.. >B40:" CHARGE >C39:"KS >B39:" 4. CHECKS >D37:" ....... >C37:"KS PAID... >B37:" 3. CHECK >D35:" ....... >C35:"C54:"S OF COIN >B54:" 10. ROLLS >D52:" ....... >C52:"ED......... >B52:" SORTE >C51:"KS FINE >B51:" 9. CHECK >D49:" ....... >C49:"EMENTS.... >B49:" STATEM >C48:"IAL >B48:" 8. SPEC >D46:" ....... >C46:" PAYMENTS. >B46:" 7. STOP PA >D4QUI >C65:"RVE >B65:" 2. RESERV >D63:" ....... >C63:"IT- ANNUAL >B63:" CREDI >C62:"INGS >B62:" 1. EARN >D60:"E. 10.63) >C60:"TAGES: (I.E. >B60:" C. PERCENT >D56:" ....... >C56:"SITED..... >B56:" DEPOSI >C55:"ED AND/OR >B55:" ISSU >AND ENTER >D74:"TO H100 >C74:"DDRESS. GOT >B74:"NAME AND A >D73:"CUSTOMERS >C73:"101 ENTER >B73:"C100 AND C >D72:"AR . AT >C72:"NTH AND YE >B72:"CURRENT MON >D71:"TER THE >C71:"F97 AND EN >B71:"NEXT GOTO >D66:" ....... >C66:"IREMENT... >B66:" RE--------- >G97:".......... >F97:" ........ >E97:"E MONTH OF >D97:"SIS FOR THE >C97:" ANALY >D88:/FG@INT((12/D63*10000)+.5)/100 >C88:"PLIER >B88:" 1. MULTI >C86:"====== >B86:"========== >C85:"ATA : >B85:"COMPUTED D >D75:"MBER. >C75:"ACCOUNT NUM >B75:">E106:"VERAGE FUNDS >D106:" A >D102:".......... >C102:" ........ >D101:".......... >C101:" ........ >B101:"ADDRESS : >H100:" ........ >G100:"T NUMBER : >F100:" ACCOUNT >D100:".......... >C100:" ........ >B100:"CUSTOMER : >G98:"----- >F98:"-.... >E109:"........... >D109:"CE ........ >C109:"DGER BALANCE >B109:"AVERAGE LED >I107:".......... >H107:".......... >G107:".......... >F107:".......... >E107:".......... >D107:".......... >C107:".......... >B107:".......... >G106:"SIT >F106:"DS ON DEPOS .... >C111:"LLECTED FU >B111:"AVERAGE CO >I110:/F$+D16-D19 >H110:"......... >G110:"........... >F110:"........... >E110:"S ......... >D110:"ECTED FUNDS >C110:"AGE UNCOLL >B110:"LESS: AVERAGE >I109:/F$+D16 >H109:".........$ >G109:"........... >F109:".......$@INT(+I111*D66+.5)/100 >H112:"......... >G112:"........... >F112:"........... >E112:"%......... >D112:/F$+D66 >C112:"RVES AT : >B112:"LESS: RESE >I111:/F$+I109-I110 >H111:".........$ >G111:"........... >F111:"........... >E111:"........... >D111:"NDS ...79C";"PRESS ANY KEY TO HALT LISTING"::202 1020#2,B$(I),16,B)ž#242:::1160Z=1#2;A$:"78A";A$Z=Z+1:Z>1842:::Z=1980*:=23:=0::"79C";"CONTINUE...?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"10 be of use to the home user in some form or another. We've put themMinto the public domain as part of a continuing attempt to make all formerlyOcommercial Apple /// products (that are not still on the market in some form)!available to the /// com used immediately. As the banker gains experience inLVC by using these models, he may wish to use them as a base for developinghis own customized programs.N Note that these models can all be pulled into 3EZ Pieces or Appleworks Mand maysiCalc models written by community bankers or Banking Industry 7Software Houses and contributed to the publication. $ According to the Introduction:EThe purpose of this book is to provide bank personnel with VisicalcJmodels which can be BANKCALC #3INFORMATION ABOUT THIS DISK :K BANKCALC was written by Anthony Powers and published by Micro Book, GInc. of Arlington Heights, Illinois in 1983. It is a collection of 8CViGO=====|====|====|====|====|====|====|====|====|====|====|====|====|====|====|===tG BANKCALC #3 EAD PASCAL TEXT FILES."04=10:"78C";"ANY KEY RETURNS TO THE MENU."!>G$:::".D1/MENU.MAKER",320R",220(204::"79A";""; 2D=1:F=1 <#4;a$ FD=D+1 P#5;a$ZD=60#5;12)dD=60D=1nF=F+1::d$;::Y=1100:Y x13402  CATCH PASCAL TEXT FILES 202 :F*=08:"78C";"SORRY BUT MENU.MAKER CAN'T R".D1/MENU.MAKER",220 d$="" A$="PRINTING "+B$(I),16,B)=01:=0::"80C";A$;:#3,B$(I),16,B)Z=1#3;b$:"78A";b$Z=Z+1:Z=18:1290 1260 #4,B$(I),16,B)#5,".PRINTER"+ž#4#5;12):::".D1/MENU.MAKE30C$="N"C$="n"1160;:=23:=0::"79C";"PRESS ANY KEY TO HALT LISTING": $1020.202 8::Z=1B::=23:=0::"79C";"WOULD YOU LIKE A PRINTED COPY?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"1170*C$="N"C$="n"munity.MNOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS( A VISICALC FILE RATHER THAN DIF.O We've included Menu.Maker on this disk so that (after you've booted intoOBusiness Basic from another disk or off your hard disk) you can look at theseMfiles or print them if you like. This information file is available in both*Text and 3EZP/Appleworks format as well.L While these models should hold for the present, please be aware that Nthey all catware Houses and contributed to the publication. According to the Introduction: The purpose of this book is to provide bank personnel with Visicalc models which can be used immediately. As the banker gains experience in VC by using these models, he BANKCALC #3 INFORMATION ABOUT THIS DISK : BANKCALC was written by Anthony Powers and published by Micro Book, Inc. of Arlington Heights, Illinois in 1983. It is a collection of 8 VisiCalc models written by community bankers or Banking Industry Sof stated municipal yield9 and a series of cost of funds assumptions. A convenient record maintenance system for the Bankers, Acceptances owned by the bank-: Model 8: TEFRAF The calculation of tax equivalent yields for municipal K securites under TEFRA, based upon the-: Model 6: Director's ReportE The preparation of a monthly set of Director's ReportsG including Statement of Condition, Income Statement and a Key Ratio Report!-: Model 7: Bankers AcceptanceE the working hours of tellers!-: Model 5: Account Analysis H The preparation of a bill for services used by commercial? customers on both a fee and excess balance basis SIDE TWO:MANAGEMENT MODELS terest payments over various time periods5-: Model 4: Daily Teller Transaction Count by HourJ The maintenance of teller transaction counts by hour of theJ day and day of the week. The model is useful in scheduling+ The preparation of a daily schedule for the rates offeredF on CDs, IRA's, and Repurchase Agreements. The scheduleJ also includes effective rates resulting from daily interestJ compounding and innterest loan wherein the initial payments are madeD to interest only. At a predetermined point, the loan? reverts to level interest and principal paymentsCUSTOMER SERVICE MODELS'-: Model 3: Daily Investment Rates H interest loan to be repaid monthly with a level payment8 plus a balloon payment in the final month.-: Model 2: Interest Only Loan AmortizationH The creation of a loan amortization schedule for a simpleB iJOn Side One of this disk (III.ZAW.09) you'll find the following Visicalc models:AMORTIZATION MODELS0-: Model 1: Balloon Payment Loan AmortizationH The creation of a loan amortization schedule for a simpleF here is no implied guarantee that any of theseEmodels as presented will return information accurate for the 1990s.LNOTE #2: THE BOOKS THAT ACCOMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE9 WAP OFFICE SHOULD YOU NEED TO REFERENCE THEM.me out in the early 1980s and reflect the situation at that time.NSome of these models may require some changes based on today's realities. AsMthis is a PD offering, buyer beware takes precidence here. You should findLsome of these useful. But tmay wish to use them as a base for developing his own customized programs. Note that these models can all be pulled into 3EZ Pieces or Appleworks and may be of use to the home user in some form or another. We've put them into the public domain as par/ WAP /// SIG MENU.MAKER PROGRAM (v. 6.1) =".D1"210: Coldstart (320: Warmstart &*X=11000: TEXT SLOW-DOWN LOOP ,X.1 CHANGE DISK SUBROUTINE23œ202:2200<RFa$=" YOU MAY SELECT YOUR DISK BY V and a series of cost of funds assumptions. enient record maintenance system for the Bankers Acceptances owned by the bank -: Model 8: TEFRA The calculation of tax equivalent yields for municipal securites under TEFRA, based upon the stated municipal yield DELS -: Model 6: Director's Report The preparation of a monthly set of Director's Reports including Statement of Condition, Income Statement and a Key Ratio Report -: Model 7: Bankers Acceptance A conv is useful in scheduling the working hours of tellers -: Model 5: Account Analysis The preparation of a bill for services used by commercial customers on both a fee and excess balance basis SIDE TWO: MANAGEMENT MOinterest compounding and interest payments over various time periods -: Model 4: Daily Teller Transaction Count by Hour The maintenance of teller transaction counts by hour of the day and day of the week. The model SERVICE MODELS -: Model 3: Daily Investment Rates The preparation of a daily schedule for the rates offered on CDs, IRA's, and Repurchase Agreements. The schedule also includes effective rates resulting from daily reation of a loan amortization schedule for a simple interest loan wherein the initial payments are made to interest only. At a predetermined point, the loan reverts to level interest and principal payments CUSTOMER The creation of a loan amortization schedule for a simple interest loan to be repaid monthly with a level payment plus a balloon payment in the final month -: Model 2: Interest Only Loan Amortization The cMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE WAP OFFICE SHOULD YOU NEED TO REFERENCE THEM. On Side One of this disk (III.ZAW.09) you'll find the following Visicalc models: AMORTIZATION MODELS -: Model 1: Balloon Payment Loan Amortization ies. As this is a PD offering, buyer beware takes precidence here. You should find some of these useful. But there is no implied guarantee that any of these models as presented will return information accurate for the 1990s. NOTE #2: THE BOOKS THAT ACCOnd 3EZP/Appleworks format as well. While these models should hold for the present, please be aware that they all came out in the early 1980s and reflect the situation at that time. Some of these models may require some changes based on today's realitRATHER THAN DIF. We've included Menu.Maker on this disk so that (after you've booted into Business Basic from another disk or off your hard disk) you can look at these files or print them if you like. This information file is available in both Text at of a continuing attempt to make all formerly commercial Apple /// products (that are not still on the market in some form) available to the /// community. NOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS A VISICALC FILE OLUME NAME (/DISKNAME) OR DEVICE NAME (.Dx)"P12);::"80C";a$;:Zb$="CHANGING DISKS"$d=23:=0::"80C";b$;::12).n=12:=20:"MAKE A NEW MENU FOR DISK: ";N$xN$)<2110=N$ :210 I=1L(A$(I),A$))200B$(NOT FOUND.)"X=11000:X:::210Z a$="{,|,~,}; selects; back 1 level; G$:::320H: Error Routine 202:U=11:"79C";"BAD PATH ERROR (NO DISK IN DISK DRIVE OR DESIRED FILE ,2))=0"12";џ,6);:ٟ;$П,2))=>12" PM-":" AM-" 1830WW=1530 =26:=21 1600 &:WW=1:0 :SEG=1;".D1/S EG.F" SEG=1".D1/SEG.G"diskname$=3802  CATCH PASCAL TEXT FILES "JUNE":1750M$="JULY":1750M$="AUGUST":1750M$="SEPTEMBER":1750M$="OCTOBER":1750M$="NOVEMBER":1750M$="DECEMBER":1750826);"-";M$;" ";Ѡ,2));", ";"19";Р,2);" ";/П,2))=>13П,2))-12;џ,6);:1780$~240:=24:=0:"@ ..... "DATE.TIME.LINE" ....JM=Ҡ,4,2))BTM1630,1640,1650,1660,1670,1680,1690,1700,1710,1720,1730,1740^M$="JANUARY":1750hM$="FEBRUARY":1750rM$="MARCH":1750|M$="APRIL":1750M$="MAY":1750M$=B$(I),"CAT 0")1140*B$(I),"FONT 0")18504B$(I),"FOTO 0")1930>B$(I),"PASTXT 0")2070H540R\A$="RUNNING "+B$(I),16,B)f"79C";A$;:=0pB$(I),16,B) z::SEG=1".D1/SEG.T"t=+B$(I),16,B) yCT=CT+1I=1:I=2I>2=-1:I=I-2:IBOTM<30THPOS=44I=IBOTM/2)*2:=+IBOTM/2)-1:0=+IBOTM/2-.5):I=IBOTM:I/2=I/2)I=I-1 œ2120B=B$(I),16)," ")-1 B$(I),"BASIC 0")850B$(I),"TEXT 0")890 81+LCA):::: RebootN=THPOS:B$(I);XA<8A>11540bA-7640,660,690,720l:=THPOS:B$(I);v:520: 500THPOS=4:I/2=I/2)I=I-1I=IBOTM THPOS=44:I/2<>I/2)I=I+1I13000Zha$="{,|,~,}; selects; to new disk; J/2)=4:=+1:ۙ=44B$(J);:J=J+1I:1,180,22:2,280,21:2,2380,23:8A$(1000),B$(1000),C%(511),C$(20),name$(20):=10:=0UCA=128:LCA=UCA+32CT=15 IF PREFIX$= PREFIX$+MID$(B$(I),112405l=ơ):: Routine to back up one directory level.a$=С,l-1) s=a$)a$=a$,s-1)a$,1)="/"5060:s=s-1 5030=a$240( MENU.MAKER 6.10 * Thanks to C.M.Davidson for his help! >V20:"ETS >U20:"RNING ASS >T20:"VERAGE EA >S20:"FTE) TO A >R20:"T INCOME( >Q20:" *INTERES >P20:" **** >N20:"N >M20:" CONDITIO >L20:"TEMENT OF >K20:" STA >H20:" ....... >G20:" ....... >F20:" ....... >E20:" ....... >D20:" ....... >C20:" ..... :"............ >A57:"............ >F56:/FR" .......... >E56:/FR" .......... >D56:" ........... >C56:/F$" ........... >B56:"............ >A56:"............ >F55:/FR" .......... >E55:/FR" .......... >D55:" ........... >C55:/F$" ........... >B55:"....>C61:/F$@SUM(C8...C58 >B61:"RUN BALANCE >F58:/FR" .......... >E58:/FR" .......... >D58:" ........... >C58:/F$" ........... >B58:"............ >A58:"............ >F57:/FR" .......... >E57:/FR" .......... >D57:" ........... >C57:/F$" ........... >B57:"IRECTOR'S >A1:"MODEL 6-D /W1 /GOC /GRM /GFI /GC9 /X>A1:>A1: C92: ..... >D5:" MONTH: >C5:"EET >B5:"ALANCE SH >A5:"AVERAGE B >P4:" **** >P3:" **** >H3:"========= >G3:"========== >F3:"========= >E3:"EA======= >D3:" ENTRY AR >C3:"=====DATA >B3:"========= >A3:"========= >P2:" **** >P1:" **** >C1:" REPORT >B18:" **** >V7:"......... >U7:".......... >T7:/FR"AS OF >P7:" **** >D7:" ...... >C7:" EXPIRED: >B7:"# OF MOS. >V6:"ATIOS >U6:" KEY R >P6:" **** >C6:"---- >B6:/-- >A6:/-- >V5:"'S REPORT >U5:" DIRECTOR >P5:" **** >F5:".......... >E5:"....ME >G10:" INCOME >F10:" INCOME >E10:" INCOME >D10:" BALANCE >C10:" BALANCE >B10:"NDS >A10:"USE OF FU >Y9:/FR"YTD >X9:" YTD >P9:" **** >H9:" LAST YTD >G9:"THIS YTD >F9:" LAST YR >E9:"THIS YEAR >D9:" LAST YR >C9:"THIS YEAR >Y8:/FR" LAST >X8:" THIS >PENCY >A12:"US GOV'T >R11:"--------- >Q11:/-- >P11:" **** >H11:" ------- >G11:" ------- >F11:" ------- >E11:" ------- >D11:" ------- >C11:" ------- >B11:/-- >A11:/-- >Y10:/FR" ------ >X10:" ------ >R10:"LITY: >Q10:"PROFITABI >P10:" **** >H10:" INCOP137/D7)*12)/N54)*100 >X12:/F$(((O137/D7)*12)/M54)*100 >U12:"SETS-ROA >T12:"VERAGE AS >S12:"COME TO A >R12:"RATING IN >Q12:" *NET OPE >P12:" **** >H12:" ....... >G12:" ....... >F12:" ....... >E12:" ....... >D12:" ....... >C12:" ....... >B12:"& AG*100 >X13:/F$(((O137/D7)*12)/M81)*100 >U13:"UITY-ROE >T13:"VERAGE EQ >S13:"COME TO A >R13:"RATING IN >Q13:" *NET OPE >P13:" **** >H13:" ....... >G13:" ....... >F13:" ....... >E13:" ....... >D13:" ....... >C13:" ....... >A13:"MUNICIPAL >Y12:/F$(((.. >F15:" ....... >E15:" ....... >D15:" ....... >C15:" ....... >B15:"URITIES >A15:"OTHER SEC >Y14:/F$ >X14:/F$ >P14:" **** >H14:" ....... >G14:" ....... >F14:" ....... >E14:" ....... >B14:"-TX EQUIV >A14:"MUNICIPAL >Y13:/F$(((P137/D7)*12)/N81):" ....... >E17:" ....... >B17:"RITIES-TE >A17:" TOT.SECU >P16:" **** >H16:" ....... >G16:" ....... >F16:" ....... >E16:" ....... >D16:" ....... >C16:" ....... >B16:"RITIES >A16:" TOT.SECU >X15:/F$ >P15:" **** >H15:" ....... >G15:" ....... >E19:" ....... >D19:" ....... >C19:" ....... >B19:"UNDS SOLD >A19:"FEDERAL F >R18:/-- >Q18:/-- >P18:/-* >O18:/-* >N18:/-* >M18:/-* >L18:/-* >K18:/-* >J18:/-* >I18:/-* >R17:"AGEMENT: >Q17:"ASSET MAN >P17:" **** >H17:" ....... >G17:" ....... >F17.. >B20:"ACCEPT. >A20:"BANKER'S >Y19:/F$((N35+N44)/N54)*100 >X19:/F$((M35+M44)/M54)*100 >U19:"ASSETS >T19:" AVERAGE >S19:"ASSETS TO >R19:" EARNING >Q19:" AVERAGE >P19:" **** >M19:"S REPORT >L19:"DIRECTOR' >H19:" ....... >G19:" ....... >F19:" ............. >A55:"............ >F54:/FR" .......... >E54:/FR" .......... >D54:" ........... >C54:/F$" ........... >B54:"............ >A54:"............ >F53:/FR" .......... >E53:/FR" .......... >D53:" ........... >C53:/F$" ........... >B53:"................. >C26:/F$" ........... >B26:"............ >A26:"............ >F25:/FR" .......... >E25:/FR" .......... >D25:" ........... >C25:/F$" ........... >B25:"............ >A25:"............ >F24:/FR" .......... >E24:/FR" .......... >D24:" .......... ........... >C28:/F$" ........... >B28:"............ >A28:"............ >F27:/FR" .......... >E27:/FR" .......... >D27:" ........... >C27:/F$" ........... >B27:"............ >A27:"............ >F26:/FR" .......... >E26:/FR" .......... >D26:" ....>D30:" ........... >C30:/F$" ........... >B30:"............ >A30:"............ >F29:/FR" .......... >E29:/FR" .......... >D29:" ........... >C29:/F$" ........... >B29:"............ >A29:"............ >F28:/FR" .......... >E28:/FR" .......... >D28:"..... >D32:" ........... >C32:/F$" ........... >B32:"............ >A32:"............ >F31:/FR" .......... >E31:/FR" .......... >D31:" ........... >C31:/F$" ........... >B31:"............ >A31:"............ >F30:/FR" .......... >E30:/FR" .......... .......... >D34:" ........... >C34:/F$" ........... >B34:"............ >A34:"............ >F33:/FR" .......... >E33:/FR" .......... >D33:" ........... >C33:/F$" ........... >B33:"............ >A33:"............ >F32:/FR" .......... >E32:/FR" .....:/FR" .......... >D36:" ........... >C36:/F$" ........... >B36:"............ >A36:"............ >F35:/FR" .......... >E35:/FR" .......... >D35:" ........... >C35:/F$" ........... >B35:"............ >A35:"............ >F34:/FR" .......... >E34:/FR" . >E38:/FR" .......... >D38:" ........... >C38:/F$" ........... >B38:"............ >A38:"............ >F37:/FR" .......... >E37:/FR" .......... >D37:" ........... >C37:/F$" ........... >B37:"............ >A37:"............ >F36:/FR" .......... >E36....... >E40:/FR" .......... >D40:" ........... >C40:/F$" ........... >B40:"............ >A40:"............ >F39:/FR" .......... >E39:/FR" .......... >D39:" ........... >C39:/F$" ........... >B39:"............ >A39:"............ >F38:/FR" ........." .......... >E42:/FR" .......... >D42:" ........... >C42:/F$" ........... >B42:"............ >A42:"............ >F41:/FR" .......... >E41:/FR" .......... >D41:" ........... >C41:/F$" ........... >B41:"............ >A41:"............ >F40:/FR" ...44:/FR" .......... >E44:/FR" .......... >D44:" ........... >C44:/F$" ........... >B44:"............ >A44:"............ >F43:/FR" .......... >E43:/FR" .......... >D43:" ........... >C43:/F$" ........... >B43:"............ >A43:"............ >F42:/FR... >F46:/FR" .......... >E46:/FR" .......... >D46:" ........... >C46:/F$" ........... >B46:"............ >A46:"............ >F45:/FR" .......... >E45:/FR" .......... >D45:" ........... >C45:/F$" ........... >B45:"............ >A45:"............ >F......... >F48:/FR" .......... >E48:/FR" .......... >D48:" ........... >C48:/F$" ........... >B48:"............ >A48:"............ >F47:/FR" .......... >E47:/FR" .......... >D47:" ........... >C47:/F$" ........... >B47:"............ >A47:".........1:"............ >F50:/FR" .......... >E50:/FR" .......... >D50:" ........... >C50:/F$" ........... >B50:"............ >A50:"............ >F49:/FR" .......... >E49:/FR" .......... >D49:" ........... >C49:/F$" ........... >B49:"............ >A49:"..... >A53:"............ >F52:/FR" .......... >E52:/FR" .......... >D52:" ........... >C52:/F$" ........... >B52:"............ >A52:"............ >F51:/FR" .......... >E51:/FR" .......... >D51:" ........... >C51:/F$" ........... >B51:"............ >A5. >C24:/F$" ........... >B24:"............ >A24:"............ >F23:/FR" .......... >E23:/FR" .......... >D23:" ........... >C23:/F$" ........... >B23:"............ >A23:"............ >F22:/FR" .......... >E22:/FR" .......... >D22:" ........... >C22:/F$" ........... >B22:"............ >A22:"............ >F21:/FR" .......... >E21:/FR" .......... >D21:" ........... >C21:/F$" ........... >B21:"............ >A21:"............ >F20:/FR" .......... >E20:/FR" .......... >D20:" ........... >C20:/F$" 0B$(J)=A$(I),1,31)!J/2<>J/2)=4:=+1:ۙ=44B$(J);:J=J+1I:1,180,22:2,280,21:2,2380,23:8A$(1000),B$(1000),C%(511),C$(20),name$(20):=10:=0UCA=128:LCA=UCA+32=+B$(I),16,B)240 #1,  ISK BY VOLUME NAME (/DISKNAME) OR DEVICE NAME (.Dx)"P12);::"80C";a$;:Zb$="CHANGING DISKS"$d=23:=0::"80C";b$;::12).n=12:=20:"MAKE A NEW MENU FOR DISK: ";N$xN$)<2110=N$ :210 I=1L(A$(I),A$))207 WAP /// SIG MENU.MAKER PROGRAM (v. 6.0) =".D1"210: Coldstart (320: Warmstart &*X=11000: TEXT SLOW-DOWN LOOP ,X.1 CHANGE DISK SUBROUTINE23œ202:2200<RFa$=" YOU MAY SELECT YOUR D KER'S ACCEP >A1:"MODEL 7 - BA /W1 /GOC /GRM /GC12 /X>A1:>A1: C61: .. >F7:" --------- >E7:" ---------- >D7:" ---------- >C7:" ---------- >B7:"------------ >A7:"------------ >F6:/FG" TO >E6:/FG" FROM >D6:/FG" RATE >C6:/FR"AMOUNT >B6:"BANK >A6:" NAME OF >C4:"............ >B4:/FR"DATE RUN >C1:"TANCES >B1:"N. >A10:"............ >F9:/FR" .......... >E9:/FR" .......... >D9:" ........... >C9:/F$" ........... >B9:"............ >A9:"............ >F8:/FR" .......... >E8:/FR" .......... >D8:" ........... >C8:/F$" ........... >B8:"............ >A8:"................. >A12:"............ >F11:/FR" .......... >E11:/FR" .......... >D11:" ........... >C11:/F$" ........... >B11:"............ >A11:"............ >F10:/FR" .......... >E10:/FR" .......... >D10:" ........... >C10:/F$" ........... >B10:"..........."............ >A14:"............ >F13:/FR" .......... >E13:/FR" .......... >D13:" ........... >C13:/F$" ........... >B13:"............ >A13:"............ >F12:/FR" .......... >E12:/FR" .......... >D12:" ........... >C12:/F$" ........... >B12:"..... >B16:"............ >A16:"............ >F15:/FR" .......... >E15:/FR" .......... >D15:" ........... >C15:/F$" ........... >B15:"............ >A15:"............ >F14:/FR" .......... >E14:/FR" .......... >D14:" ........... >C14:/F$" ........... >B14:...... >B18:"............ >A18:"............ >F17:/FR" .......... >E17:/FR" .......... >D17:" ........... >C17:/F$" ........... >B17:"............ >A17:"............ >F16:/FR" .......... >E16:/FR" .......... >D16:" ........... >C16:/F$" ........... ........... >B20:"............ >A20:"............ >F19:/FR" .......... >E19:/FR" .......... >D19:" ........... >C19:/F$" ........... >B19:"............ >A19:"............ >F18:/FR" .......... >E18:/FR" .......... >D18:" ........... >C18:/F$" .....d$=""=10:"80C";d$ ž#1300I=0"I=I+1:#1;A$(I):290,#1 6L=I-1@j=1:same=0 J:SEG=0 Tœ2030+^#9,"DISKNAME.DAT":#9;DISKNAME$:#9Zha$="{,|,~,}; selects; to new disk; "Y"C$<>"y"C$<>"N"C$<>"n"1170*C$="N"C$="n"79C";"PRESS ANY KEY TO HALT LISTING"::202 1020#2,B$(I),16,B)ž#242:::1160Z=1#2;A$:"78A";A$Z=Z+1:Z>1842:::Z=1980*:=23:=0::"79C";"CONTINUE...?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"10 MENU.MAKER TEXT MODULESEG=0"MENU.MAKER"890&*X=11000: TEXT SLOW-DOWN LOOP ,X.1,180,22:2,280,21:2,2380,23:z:A$="LISTING "+B$(I),16,B)$=01:=0::"80C";A$;::12)>=23:=0::"RNS TO THE MENU.">G$:::320H: Error Routine 202:U=11:"79C";"BAD PATH ERROR (NO DISK IN DISK DRIVE OR DESIRED FILE NOT FOUND.)"X=11000:X:::210- ...... WAP /// SIG MENU.MAKER (v. 6.0) =1:0 :SEG=1;".D1/SEG.F" SEG=1".D1/SEG.G"diskname$=3602  CATCH PASCAL TEXT FILES 202 :F*=08:"78C";"SORRY BUT MENU.MAKER CAN'T READ PASCAL TEXT FILES."04=10:"78C";"ANY KEY RETU50M$="DECEMBER":1750826);"-";M$;" ";Ѡ,2));", ";"19";Р,2);" ";/П,2))=>13П,2))-12;џ,6);:1780$П,2))=0"12";џ,6);:ٟ;$П,2))=>12" PM-":" AM-" 1830WW=1530 =26:=21 1600 &:WW90,1700,1710,1720,1730,1740^M$="JANUARY":1750hM$="FEBRUARY":1750rM$="MARCH":1750|M$="APRIL":1750M$="MAY":1750M$="JUNE":1750M$="JULY":1750M$="AUGUST":1750M$="SEPTEMBER":1750M$="OCTOBER":1750M$="NOVEMBER":172070H540R\A$="RUNNING "+B$(I),16,B)f"79C";A$;:=0pB$(I),16,B) z::SEG=1".D1/SEG.T"t=+B$(I),16,B)~240:=24:=0:"@ ..... "DATE.TIME.LINE" ....JM=Ҡ,4,2))BTM1630,1640,1650,1660,1670,1680,16+IBOTM/2-.5):I=IBOTM:I/2=I/2)I=I-1 œ2120B=B$(I),16)," ")-1 B$(I),"BASIC 0")850B$(I),"TEXT 0")890 B$(I),"CAT 0")1140*B$(I),"FONT 0")18504B$(I),"FOTO 0")1930>B$(I),"PASTXT 0")v:520: 500THPOS=4:I/2=I/2)I=I-1I=IBOTM THPOS=44:I/2<>I/2)I=I+1I2=-1:I=I-2:IBOTM<30THPOS=44I=IBOTM/2)*2:=+IBOTM/2)-1:0=1410: Control C "aborts" program to Basic(:A=13770: Return Selects a file ,DA=27:50:: Escape to change disks -IA=(81+UCA)A=(81+LCA):::: RebootN=THPOS:B$(I);XA<8A>11540bA-7640,660,690,720l:=THPOS:B$(I);A$="FONT 0":150A$="FOTO 0":150A$(L),"BLOCKS")510*=27:=19:"FREE MEMORY AVAILABLE: ";=7:=20:"80C";A$(L);$:=5:THPOS=4:I=1:IBOTM=J-1:620Q=:=26:=21:1600 =Q:WW=0A=:A=21A=9&oldprefix$=40A=3".D1/MENU.MAKER",220 d$="" A$="PRINTING "+B$(I),16,B)=01:=0::"80C";A$;:#3,B$(I),16,B)Z=1#3;b$:"78A";b$Z=Z+1:Z=18:1290 1260 #4,B$(I),16,B)#5,".PRINTER"+ž#4#5;12):::".D1/MENU.MAKE