Hotel Split Cost Spreadsheet.

Started by Sijy, May 22, 2012, 05:57:54 PM

0 Members and 1 Guest are viewing this topic.

Sijy

I decided it would be easier for myself to create a spreadsheet that will automatically calculate what each person staying in my hotel room will owe (depending on how many nights each person is staying and how full the room is each night). So I did, and I made it a bit nicer so I could share it:
https://docs.google.com/open?id=0BwEno0W1Vtf2Rmx1aFl0S1pQRGM
(download to edit for yourself)

Basically to use it you fill in the orange cells (names, total cost, first day, and yes/no for what nights each person stayed), and it will calculate how much % and $ each person owes.

The formulas assume each night will cost the same amount, and that you will evenly split the room each night between each person staying. (you could download a copy for each night if they are different amounts I guess). And make sure you put in the total hotel cost-including taxes etc. No one should be breaking anything, so there's shouldn't be any extra charges.


(if you must edit anything, the password to unlock the sheet is "fanime")

feedback please!