This file is a spreadsheet for OS/2's Spreadsheet Applet. Although most people think this applet is pretty useless, I've found it to be prefect for calculating the grocery bill, or any other shared expense. My roommate and I go grocery shopping together, but not everything we buy is for both our use. So some of it is shared, some of it is for me, and the rest is for him. This spreadsheet takes the total amount, the total tax, and the portions for each roommate (before tax), and calculates how much each person's share is. It supports up to three people (with minor changes), but it's currently configured for two. More can be added provided you make space for the fields. Field B1 is the total tax. Field B2 is the total bill, including tax. From this information, the computer calculates the tax rate, assuming that each item is taxed the same (even for groceries, where not all items are taxed the same or at all, this assumption works well enough). Then fields B4 through B6 contain the total cost of personal items _before tax_. This system works great for recepits from Giant or Safeway. If you want to use three people, you will have to modify fields B11 and B12 and put a formular in field B13. The result i: B11: F8/3+F4 B12: F8/3+F5 B13: F8/3+F6 A linefeed character (ASCII 12) is placed in field A15 so that you can print multiple sheets, each on one page. Field E1 is for the date. The information is verified via the "Error" fields that calculate the margin of error. You might need to hit Recalculate (^R) to synchronize everything. Timur Tabi January 5, 1994 timur@seas.gwu.edu Timur Tabi @ 1:109/347