Hi, ok so I have created a forecasting workbook which takes (I work in a hotel) our rooms occupied divided by the actual guests we got for breakfast, lunch and dinner and gives me a percentage (we call that capture ratio). I break down these and average them throughout the month by the day of...