rooms

Good morning, I have a download table. For each date the right hand column represents the number of rooms available and the left hand number represents take up. On a separate tab I need to be able to show how many rooms are still has left on each date for each room type. Can anybody help me...

This is somewhat what I have. A The following people will be in Rm 5 B John Smith C Michael Townsend D The following people will be in Rm 6 E Jennifer Tucker F Samuel Rodriguez G The following people will be in Rm 7 H Allison Taylor J Jonathan Thompson This goes on for about 25 rooms. If I...

Hi All, I'm looking for a way (if possible) to allow my filters in a pivot table be based off of an "if" statement or something similar. The data that i'm pulling from is a little complicated to write out... but here goes nothing. I work at a hotel and every night there is a snap shot of what...

Good day all, I have a SS project to book rooms. Rooms are allocated by rows and dates by columns. I have a VB which counts available or booked rooms by the cell colours. I would like to run the count color formula by the date entered in the first cell in each column, thus being able to jump...

I work in a church and I'm trying to determine how to monitor if our rooms with kids/teacher ratios go over the state requirements. For instance, we can have 4 infants with 1 teacher. So, one of our rooms had 5 kids to one teacher and I would like column C to show YES if it is greater than 1:4...

Hello, I am trying to come up with a formula that i can drag to sum just the weekdays from the data set up below: <tbody> Weekdays 2019 Rooms Revenue Casino Formula Formula Events Formula Formula </tbody> Data looks like this: <tbody> Casino Casino Events Events 2019 2019...

My formula is on google sheets but I think that this is more of a formula question and doesn't really matter if it is Sheets or Excel. Hope this is the correct place to post. I have a sheet that ALMOST does exactly what I need. In the sheets "SS", "Sci", "ELA", "Math" I have data about...

Hi, I manage housekeepers in a hotel and I am trying to create a spreadsheet that helps me make room cleaning assignments based on certain criteria. The sample sheet shows the 3 columns of criteria for each room. Room Type, Room Condition, Stay-C/O (Stay over vs. Check out). I also want to...

A little background... I work in a very busy surgical services department. We have a lot of rooms doing cases in a give day. We want to figure out how many cases are occupying rooms in a given time range. These ranges are: 0600-1500, 1500-1900, and 1900-2100 I already maintain a spreadsheet...

HI, I hope I formulated the topic correctly. What I want to do is to multiply Rooms by ADR for each date and sum them together to get total revenue for all days in a given segment (for example in row 5 and the result will be in cell S5). I thought of going with SUMPRODUCT but cannot figure out...

Hello everyone, I would first like to thank you all for the help that I found on this forum, reading various threads as I was discovering Excel, working (and being stuck) on my project. Before we get to the good stuff, let me introduce myself and tell you why I am writing this post. My name...

My professor asked us to make a room utilization workbook where in in the first sheet, the rooms along with it's vacancy be shown. (if the room was vacant or in use of a class and who's the professor in charge). It will stand as the summary of each sheet that follows. The following sheets will...