OT: Spreadsheet Fun!

[AgentZero]

Hiya folkeses! Got another wee problem I could use a hand with. I live in a shared house with 3 others so when the bills come due, we always have great fun. I'm trying to convert our system into a spreadsheet to cut down on errors, since when I went to pay the bills today, everyone had chipped in what was calculated they owed, but I ended up 40eur short and had to leave, get the extra money, then re-queue for another 15mins to get the bills paid. All of which did not leave me a particularily happy camper.

So, the way our system works is we take the value of the electrical, gas, and cable and divide by four. The phone bill's a bit different because we split the line rental by 4, then everyone adds on the value of the calls they made. So far so good? Good, coz here comes the fun part.

Whenever anyone buys something for the house (washing up liquid, light bulbs, cleaning supplies, etc.) they stick their name on the reciept, then as the final step of calculating what everyone owes, we add the total value of all the reciepts, then divide by 4 to figure out what, all things being equal, each of us should have paid, then add them up again according to who actually paid what. Then, the difference between what you did pay and should have paid is either added or subtracted from what you owe for the bills. Still with me?

Now, what I want to do is make a spreadsheet or something similar where we can just plug in the values and it'll tell us what each of us owe.

I've done a mockup of what I'd like it to look like, see the attachment for that. Now, does anyone know how to get the spreadsheet to do all the calculations for me so I can just plug in the values into collumn 'B' and it'll fill in the rest for me?