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