{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/818aa77b5fb041db85602b31ecd048d4\" frameborder=\"0\" width=\"1728\" height=\"1296\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1296,"width":1728,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1296,"thumbnail_width":1728,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/818aa77b5fb041db85602b31ecd048d4-27ea6441fe28a68d.gif","duration":356.7883,"title":"Estimating Future Quarter Bookings Using Excel's Forecast ETS Formula","description":"In this video, I discussed how to achieve forecast accuracy within plus or minus five percent by day 15 of the quarter, focusing on estimating the business that will be created and closed. I presented a made-up dataset of quarterly bookings and demonstrated how to use Excel's forecast dot ETS formula to predict the unknown future quarter, specifically for 2025 Q3. I explained the necessary inputs for the formula, including target dates, historical values, and seasonality parameters. I encourage you to apply this method to your own forecasting efforts to improve accuracy. Please review the steps and try implementing the forecast in your upcoming projects."}