README90.FED File: LDW Power Tax Form Templates January 11, 1991 ....................MODIFIED FOR LOTUS 1-2-3..................... This file describes two spreadsheet templates developed for the LDW Power Spreadsheet program for the Atari ST line of computers. I have used the LDW Convert Program to turn them into Lotus .wk1 files and made minimal modifications, testing them with success on an IBM with Lotus Ver. 2.2. ______________________________________________________________________ FD90TX10.WK1 - This spreadsheet template is for use in preparing Federal IRS Form 1040 & Schedules A & B. The template closely resembles the actual forms but is not complete enough to actually use for submitting to the IRS. The template automatically computes your tax, including adjusting for tax table roundoff if appropriate. The following is the help screen used to describe macros available for use with the spreadsheet. TEMPLATES FOR 1990 TAX FORM 1040 & SCHEDULES A & B - LDW POWER Version 1.1 (Lotus Version) HELP WITH MACROS: (Hold down ALT key and press other key to execute) {alt}H - HELP with macros (returns to this screen) {alt}I - INITIALIZE filing status. (Should begin with this macro) {alt}F - FORMS menu. (move between forms by menu selection) {alt}P - PRINT menu. (print individual forms or all) {alt}O - page ONE of Form 1040 (move directly to top of form w/o menu) {alt}T - page TWO of Form 1040 ( " ) {alt}A - schedule A (move directly to top of sched. w/o menu) {alt}B - schedule B ( " ) {alt}W - view WINDOW with summary data. {alt}R - REMOVE window with summary data from view. ***FOR MORE ABOUT THIS TEMPLATE (Page Down)*** Spreadsheet for completing IRS Form 1040 & Schedules A & B using LDW Power on the Atari ST. Some of the macros have steps to correct errors in VIP Professional, which I used initially. I've tested fairly completely but can offer no guarantees. Forms are for use in preparing forms but are not suitable for submitting to IRS. Bold fields are unprotected for data entry. Comments are welcome. Charles R. Stirrat, 13318 Hunt Ridge, Ellicott City, MD 21043 Note: This is a version of the spreadsheet modified to be compatible with Lotus 123 on IBM compatible machines. The window macros & format information is all that has been changed after using the LDW conversion program to obtain a .wk1 formatted file. The changes & checkout have been done on an IBM AT with Lotus Ver. 2.2. Unprotected fields are not bolded. Information below can be viewed as a summary data window at any time by entering {alt}W. To remove it use {alt}R. Adj. Gross Income Deduct'n Tax.Income Tax Refund (+) $0.00 $3,250 $0 $0.00 $0.00 ____________________________________________________________________ WKSH9010.WK1 - Template is for use in collecting records on income, interest, withholding, and deductions and performing totals for entry in federal and state tax spreadsheets. Columns are provided for husband and wife separately. This is especially useful for preparing state tax forms in states allowing combined separate filing even if the couple filed jointly on federal return. The following is the help screen used to describe the macros available for use in this spreadsheet template. TAX PREPARATION WORKSHEET 1990 - LDW POWER Version 1.0 (Lotus) HELP WITH MACROS: (Hold Alt key and press other key) {alt}H - HELP with macros (this screen) {alt}F - FORMS menu. (Move to top of each page by menu selection) {alt}P - PRINT form menu. {alt}O or {alt}A - page ONE top. (A) {alt}T or {alt}B - page TWO top. (B) {alt}C - page three top. (C) {alt}L or {alt}D - page LAST (four) top. (D) Charles R. Stirrat, 13318 Hunt Ridge, Ellicott City, MD 21043 ***MORE INFORMATION ON THIS SPREADSHEET (Page Down)*** Template is for LDW Power Spreadsheet Program on the Atari ST. Template is for use in collecting records on income, interest, withholding, and deductions and performing totals for entry in federal and state tax spreadsheets. Columns are provided for husband and wife separately, especially useful for states allowing combined separate filing even if file jointly on federal. I cannot guarantee the accuracy of this template or related tax form templates, but I have tested them extensively. Any comments or suggestions are welcome. Note this Lotus version was obtained simply by using the LDW Convert Program to obtain a .wk1 formated file. It has been tested on an IBM with Lotus 2.2. ______________________________________________________________________ A number of the macros in these spreadsheets contain steps used to correct for errors that were present in the spreadsheet program VIP Professional which I used to develop earlier templates. Since I started with these for I did not remove them. These steps cause no problems with LDW Power but might look very unusual to those familiar with Power or Lotus 1-2-3 Ver. 1A macros. I have tested fairly completely but can not guarantee the accuracy of the spreadsheet in anyway. The spreadsheet should be useful in comparing various filing options by calculating the tax and doing form arithmetic as you add additional information. The most effort has been spent on the most frequent and widely used parts of form, so if you are doing something unusual you might be more skeptical. I recommend that you check the tax calculation and arithmetic for the final results you transfer to the official IRS forms. I welcome corrections and comments. If anyone is interested I also have a similar spreadsheet for preparing Form 502 for Maryland State Income Tax filing. Charles R. Stirrat, 13318 Hunt Ridge, Ellicott City, MD 21043