Re: OT: Spreadsheet Fun!
 

That would leave you with only 3/4ths of your bills paid.

Why not make a row in which you fill in the number of days (or weeks) that month the person was present.

The the divide by 4 becomes:
divide by sum(Presence row), times presence cell for that person.

If the person was there for 2 weeks, while the other three were there for 4 weeks, then the 2-weeker pays 2/14ths of the bill.

If you don't want to measure weeks, and only months, that works too. As long as you ALL don't leave, resulting in a division by zero-people-to-pay-up

Re: OT: Spreadsheet Fun!
 

Happy birthday.

Now, what are you doing doing math on your birthday when you don't have to? http://forum.shrapnelgames.com/images/smilies/laugh.gif

Re: OT: Spreadsheet Fun!
 

I was trying to avoid math. That's why I made the spreadsheet. http://forum.shrapnelgames.com/image...ies/tongue.gif

Re: OT: Spreadsheet Fun!
 

Happy birthday AgentZero....

Re: OT: Spreadsheet Fun!
 

Happy Birthday!! http://forum.shrapnelgames.com/images/smilies/happy.gif

Re: OT: Spreadsheet Fun!
 

Happy birthday!!!! [img]/threads/images/Graemlins/Cake.gif[/img] [img]/threads/images/Graemlins/Cake.gif[/img] [img]/threads/images/Graemlins/Cake.gif[/img]

Re: OT: Spreadsheet Fun!
 

Have another row by the bills. If someone should not pay that bill put a "1" in it. Multiply the amount owed by (1-value). If they owe it, then they owe the amount. If the box has a "1" in it then it will be multiplied by "0" and be "0" owed by him.

Then you will need to figure that everyone else must pay more for this bill. With one "don't pay" row for each person, divide the total by (4-1val-2val-3val-4val) If all four people should not pay that bill then you have problems, but otherwise it will be OK.

Expand on this idea and add it to all the bill and recept rows and you will be good to go until the next revision is needed. http://forum.shrapnelgames.com/images/smilies/happy.gif