electricity-lambs

FanimeCon 2018 Forums

Advanced search  

News:

Pages: [1]

Author Topic: Hotel Split Cost Spreadsheet.  (Read 1773 times)

0 Members and 1 Guest are viewing this topic.

Sijy

  • Full Metal Post
  • Posts: 8
    • View Profile
Hotel Split Cost Spreadsheet.
« on: May 22, 2012, 05:57:54 PM »

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!
Logged
Pages: [1]
 

Page created in 0.161 seconds with 24 queries.