How to predict future reservations when data for the current day is incomplete? I'm trying to build a model to predict reservations up to 15 days in advance.
So, if I want to predict how many reservations there will be tomorrow, I use historical data of how many total reservations there were on two days prior since when using the model to forecast for tomorrow, today won't be finished... Does that make sense?
I think it is an OK and unbiased model, however, it does not use all of the available data, namely, how many reservations for tomorrow have been made today.   So, if I want my model to be more 'realtime' and account for current reervations as well, how do I do that?  Do I look at reservation data over the course of the day, and just set up a proportion or something?  For example, if I use my model at 13:00, find that I have 20 additional reservations, and I know that historically 40% of additional reservations are made by 13:00, do I just take 20+ 20*(60/40) = 50.  So now I should 'expect' 50 more on top of what yesterdays total told me?  This is all I can think of.  
Edit:
" For example if it takes 1 hour to complete three innings at a baseball game you can rest assured that the next 6 innings is going to take a lot longer than 2 hours to complete."  Well, what if you knew that historically the first 3 innings accounted for 25% of the time?  Sticking with the ballgame example, that's good illustration of my problem which I think you understand Dave, but I'm not sure I've made it clear for the others...
If you wanted to predict the duration of a ball game, you might have some formula based on the current teams, the pitchers, etc..  But, consider a game where you predicted a 2.5 hour game, and  you're in the 4th inning, and it's already taken 3 hours, now what do you do?
Dave, I've tried different techniques, involving the seasonal arima methods, etc.  I'm not familiar with 'level shifts', although I've seen you mention them in many of your posts.  I will do some further web surfing to understand this concept.   I'd be very interested in a chat session. Please let me know when you're available, I'm +11 hours EST.  
 A: Ratio estimates just don't work. For example if it takes 1 hour to complete three innings at a baseball game you can rest assured that the next 6 innings is going to take a lot longer than 2 hours to complete.In order to predict tomorrow given partial information for today and full information for the past NOB days, I suggest the following approach which we implemented for Proctor & Gamble as they had been unable to detect the economic downturn in a timely fashion. Their problem was if we have say 15 days in the current month history and 16 days remain with say 1 holiday and 2 Saturdays ( for example ) we want to compute the probability of achieving total sales of X. We implemented a daily forecasting model that included day-of-the-week;week-of-the-year;month-of-the year effects AND the lead/contemporaneous and lag effects around known events AND any Level Shifts/Time Trends that proved to be statistically significant. The model/approach also included an ARIMA component and validation tests/remedies for constancy of the parameters and variance over time. Furthermore Pulses and Seasonal Pulses ( i.e. significant changes in the day-of-the-week component ) were also entertained in order to develop a robust data generating function (DGF). What you want to do is to also include an hour-of-the-day forecasting model which would in conjunction with the daily forecast/model produce an estimate of the current day's total and the total for the next 15 days. It is imperative that the hourly forecasts and the daily forecasts not only reconcile but be fully integrated where expectations regarding daily totals actually drive the hourly estimates. 
If you wished to post your hourly data going back at least 2-3 years , I would be glad to share the results with the list. If for some reason you don't wish to share your data with the list then perhaps we can do a chat room session.
We have also had some experience with a major hotel chain to improve their 60 day forecast for occupancy.
