Forecasting FUN

Millenniumchef

New Member
Joined
Dec 11, 2016
Messages
1
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 the week. From there I do a weighted average over the last 3 months (50%, 30%,20%) Now, what I am looking for assistance here is figuring out exactly how to quantify weather, I understand that I need to get comparable numbers from nice weather to in climate weather so I can compare apples to apples but what is going to be the best way to do this???

This is my first post so I will have to figure out how to link my workbook on here for reference.

Thanks
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
Millenniumchef,

Welcome to the MrExcel forum.

This is my first post so I will have to figure out how to link my workbook on here for reference.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com
 
Last edited:
Upvote 0

AliGW

Banned
Joined
Mar 9, 2014
Messages
3,628
By "in climate" do you mean "inclement"? If you want to share your workbook, you will have to use a file-sharing site, but not everybody can or will access it, so it would be better to use the ForumTools (link in my signature line) add-in to share some sample data.
 
Upvote 0

Forum statistics

Threads
1,190,737
Messages
5,982,661
Members
439,790
Latest member
jonaust

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top