# Forecasting FUN

#### Millenniumchef

##### New Member
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
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.

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.

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:

#### AliGW

##### Banned
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.

Replies
2
Views
262
Replies
2
Views
244
Replies
0
Views
1K
Replies
1
Views
404
Replies
19
Views
641

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.

### Which adblocker are you using?

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

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