Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Posting-Version: version B 2.10.2 (Tek) 9/28/84 based on 9/17/84; site zeus.UUCP Path: utzoo!watmath!clyde!burl!ulysses!allegra!bellcore!decvax!tektronix!teklds!zeus!brianr From: brianr@zeus.UUCP (Brian Ross) Newsgroups: net.sources.mac Subject: Updated Tax Spreadsheets Message-ID: <491@zeus.UUCP> Date: Mon, 11-Mar-85 16:01:32 EST Article-I.D.: zeus.491 Posted: Mon Mar 11 16:01:32 1985 Date-Received: Thu, 14-Mar-85 04:02:01 EST Organization: Tektronix, Beaverton OR Lines: 509 Here is an update of the Multiplan tax sheets I posted earlier. There are two files in this message, you will need to seperate them manually. The first is the Mutiplan spreadsheet of the IRS 1040, the second is a Multiplan spreadsheet of Schedule A. The two files contain links to each other so when put on the mac they must have certain names; specifically, "IRS 1040" and "Schedule A". The files are currently saved in an "unprotected mode" as far as Multiplan is concerned. To use them you should open each file with Multiplan, and choose "Protect Document" from the Options menu and give each file the password of your choice. Then choose "save" from the File menu. This will keep you from destroying the formulas or text on the sheets and allow you to use the "enter" key to fill out the forms ( Enter takes you to the next cell expecting input). I have checked out the bugs noted on the net and found that the exemptions section is correct and put a fix in for the dividends section. 1) To use these two forms first fill out page one of "IRS 1040" then save it. 2) Next fill out "Schedule A" then save it. 3) Then fill out page two of "IRS 1040", This will allow all the links to work as needed. ( You must lookup the tax from the table.) Save copies of the sheets in files with other names. I also would suggest making and keeping copies of blank sheets in "master" files. ----------------(Cut Here)------------------------- (This file must be converted with BinHex.Hex) #MPBNPLAN$0000 ***COMPRESSED ***DATA FORK (!&K 3Z " HP & . J0"L@ .:I P . ( "] >,O#P (%5X9T0->&=UA8&!>%I 9V!@8(]? ^AZ (#!A8& 37P/H>Y 9V!@8(\6A6=@8&"/%FV%86!@$UX0 ('N0 &=@8&"/$WHQ%&K7%FZ%%'=@%F^%9V!@8) 9V!@ (&"0 &=@8&"/$WHQ%&K7%G"%%'=@%G&%9V!@8) 9V!@ (&"/$WHQ%&K7%G*%%'=@%G.%9V!@8(\Q9V!@8(\4>Q9L (!2%%!-Z,11JUQ9TA11W8!9L$H5@W0 .$6PF*A+!8!%L ("*%L,!G$6P@K'JM$541$\\#L0$%$54-$54,T*$151 1 (%4/T(EA$5@161%5#1%7V!%5$'K6D !G8&!@CRT0N641 (%4-%H4151 6;85A$5H16Q"0 &@-8F"0 U7=Q@6;X4- (*86;H458\\.#59W)!9PA0U6=S 6<845:L\'#5=W*A9R ((4-5W<.N1L-I\@79V!@8(\L81%<$5T/;9 8&!@8(\6 (&Z%9]UG$6P@K'JM>6\150X1;""%9Q%L&JQZK7E79Q%L ("*L>JT151$3T4P4$541:-5Z*PY6$6P6A0Y8$6P@.- Z #LP/& ]D ( ^P#_P02!"4$. 1+!%X$<02$!) #[ ( '; / C_Y/_PP90 @ "M@ ( " #8'U ( !6> #X 1 !* % 5@!< &( !H ( !X "T , 5MA7&!P0(#@;\ ( ,P5NA7,!P@(% < (&@ %:( U@#< ( #B .@ [@#T /H $ $,"%( ( 5I@$8"(H !6J 20(P@ !8$ ( 2H(\ !8( !, D< 5T@$V ( E4 5K@%""8P =H 4X)P@ ( >D 5H)^@ !Z@!9@HR ( %;(!<@IN '; %^"J8 =P ( &*"N( '# 9(+$ !Q !F@L< ( !ZP!I@M6 '% &R"XH ( !Q@ &Z"Q8 << <(+M <@ ( ( Q. 'B@'J ? !]@'\ @("" (. "% ( C(,K@ >P "/@R" ( >T "2@T& ![@ )6#-H '+ ( )B#3( ', FX-8 \ ">@VZ '= *&#>X ( %5@ I( *F L8.(@ ( 5J M(.6 %8P"VA48 54 +B ( Z0 %>@+N#L8 6F OH._@ ( 7: P8/- %9H#$A54 ( !\ #'@]V %[@1Z!( $A@2,!)($F 2> ( !2( RH/K@ ?$ #-@_: ( @ ( ! (3. =0 $#A-D !U0 0: (!.0 !U@ 0F$[P '7 !#(3Z@ ( '8 !#X4%@ !I8$^ 3^!00%"@40 ( 46!1P$2A1* &K 16%( ;, ( 1B%+8 '9 !&X4Y !MP$ 0 ("\O&&( +2T(" ! #_____"E-C:&5D=6QE($$@ (%0! , I&DE24R @(" @1D]232 @(" Q,#0P(" Q.3@T ( # *1(@(" @($9)3$E.1R!35$%455, P"D#,2TU P# (&D" P&D" P&D" P&D" P&D" P&D" ( ,!I @ , I"T5814U05$E/3E,Z7P# *3=%;G1E ('(@82 B,2(@9F]R(&5A8V@@8V%T86=O4 ZCTH&CU0&A)$ 0"L ( ! *P 0"L $ K ! *P 0"L $ K ! *P 0"L ( ! *P 0"L $ K ! *P 0"L $ K ! *P 0"L ( ! *P 0"L $ K ! *P 0"L $ K ! *P 0"L ( ! *P 0"L $ K ! *P 0"L "L H" (!($(20%(2H%+9$*P"@( 2!"$+!B$@!BV1 ( ! *P 0"L $ K ! *P 0"L $ K ! *P 0"L ( ! *P 0"L $ K ! *P 0"L , I-C$]&%B;&4@86UO=6YT("@@9G)O;2!W;W)K ('-H965T("DN+BXN+BXN+BXN+BXN+BXN+@# *3%/=&AE ('(@:6YC;VUE("XN+BXN+BXN+BXN+BXN+BXN+BXN+BXN ("XN+BXN+BXN+BXN+BYB , I,%1/5$%,($E.0T]-13T] (#T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T] (#T^ , I)T5M<&QO>65E(&)U'!E;G-E (" H1F]R;2 S.3 S(&]R(#,Y,#-&*2 N+C(T , I*%!A ('EM96YT2!W:71H9')A=VP@;V8@&5M<'1I;VYS(&9R;VT@ ($QI;F4@-BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN90# ("DQ5&%X:6)L92!I;F-O;64N+BXN+BXN+BXN+BXN+BXN ("XN+BXN+BXN+BXN+BXN+BXN+BYB , I,51A>" N+BXN ("XN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN+BXN ("XN+BXN+BXN+F( P"@(0C P"DT5&]T86P@ (%1A>"!R97-P;VYS:6)I;&ET>2 ]/3T]/3T]/3T]/3T] (#T]/3T]/3T]/3T]/3T^ , I*$1E<&5N9&5N="!#87)E ("!%>'!E;G-E2 H ($9O65R("@T,3,W*2XN , I,51A>"!O;B!) (%)!("A&;W)M(#4S,CDI+BXN+BXN+BXN+BXN+BXN+BXN ("XN+BXN+BXN+F( P"DP5$]404P@5$%8/3T]/3T]/3T] (#T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/@# ("DH1F5D97)A;"!);F-O;64@=&%X(%=I=&AH96QD+BXN ("XN+BXN+BXN-3< P"DI,3DX-"!E"!P86ED (" F(&%M;W5N="!F"!A;F0@4E)402!W:71H:&5L9"XN+BXN-C$ P"DJ ($-R961I="!T87@@;VX@"XN ("XV-P P"DP04U/54Y4(%E/52!/5T4@/3T]/3T]/3T] (#T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/@# *31!;&QO ('=A8FQE(&-H87)I=&%B;&4@8V]N=')I8G5T:6]N&5S*$9O&%B;&4@86UO=6YT("@@ (&9R;VT@=V]R:W-H965T("DN+BXN+BXN+BXN+BXN+BXN &"X! D# @*-C4@;W(@3W9E<@#__P ***END OF DATA ***CRC:FBE8 ----------------(Cut Here)------------------------- (This file must be converted with BinHex.Hex) #MPBNPLAN$0000 ***COMPRESSED ***DATA FORK (!&K 3Z " HP & . J0"L@ .A%D P . ( "] >,O#P (%5X9T0->&=UA8&!>%I 9V!@8(]? ^AZ (#!A8& 37P/H>Y 9V!@8(\6A6=@8&"/%FV%86!@$UX0 ('N0 &=@8&"/$WHQ%&K7%FZ%%'=@%F^%9V!@8) 9V!@ (&"0 &=@8&"/$WHQ%&K7%G"%%'=@%G&%9V!@8) 9V!@ (&"/$WHQ%&K7%G*%%'=@%G.%9V!@8(\Q9V!@8(\4>Q9L (!2%%!-Z,11JUQ9TA11W8!9L$H5@W0 .$6PF*A+!8!%L ("*%L,!G$6P@K'JM$541$\\#L0$%$54-$54,T*$151 1 (%4/T(EA$5@161%5#1%7V!%5$'K6D !G8&!@CRT0N641 (%4-%H4151 6;85A$5H16Q"0 &@-8F"0 U7=Q@6;X4- (*86;H458\\.#59W)!9PA0U6=S 6<845:L\'#5=W*A9R ((4-5W<.N1L-I\@79V!@8(\L81%<$5T/;9 8&!@8(\6 (&Z%9]UG$6P@K'JM>6\150X1;""%9Q%L&JQZK7E79Q%L ("*L>JT151$3T4P4$541:-5Z*PY6$6P6A0Y8$6P $ " &%2&(W0 N H ?_\ 1 & ( 'R 0X ( 0 " @<' ( ( : "$ ,@!# %, ( &, :@![ (P GP"R ,4 V #K /X!$0$D 3@*- J ( K,"Q@+9 NP"_P,2 R4#. -+ UX#<0.$ Y<#J@.] ] ( ^,#]@0)!!P$+P1"!%4$: 1[!(X?_\ 0 " ( $@ 4 "\ * _]S_[ +T I0! @4H _P 0 ( !( % O "@ !0 " "@ R !@ 0$! 2A%\ #_ ( 'C / C_Y/_PP90 ( ( +F@ T #H 0 !& $P 4@!8 &H J\ %X < ( \ )V JJ )H H ( JP Q@ #\#!8 "K8! @$( ( $T#!H !.@%" 7 ,'@ %V ( &" ; &\ <@ !] Q4 ( #$8 ( @P GH N@ D8"3 )2 ( )8 EX"9 )J G K" JP"N +D#"( ( K, O "_ ,H#"8 "M0#- ,Z ( -H!'( #;@-T Z $=@ .F ( .R ^ $>@ /L _0 ( 1< +I@0L!#($. 0^!$0$2@10!%8 K0%Z@7P!?8%_ 8"!@@&#@ ( KX!A0&*@ 8:![X "OX&(@8P ( 9>!\( "P0&9@9R !I@'Q@ :D ( :P !MP*I@ ;H!O0 ( /" >$\0# * A!8 # *2=3=&%T92!A;F0@ ($QO8V%L($EN8V]M92!487AE&5S+BXN+BXN+BXN+BXN+BXN+BXN+BXN ("X@ , H"$%P , I CAA , I*4=E;F5R86P@ (%-A;&5S(%1A>" H"!T86)L97,I+BXN+BXN ("YL , I CAA , I CAB , I*$=E;F5R86P@4V%L97,@ (%1A>"!O;B!M;W1O"EX , H"$&0 ( # *0,Q,"!? , I,U1/5$%,(%1!6$53(#T] (#T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T]/3T] (#T]/C$P/0# :0( # :0( # :0( # :0( # (&D" P&D" P&D" P&D" *P"@( ( $@0A"P"!P