A code/formula to predict future outcomes of arrangement?

**a1b2c3d4e5f6g7** · 04-30-2014, 12:44 PM

Helly,

In the attachment i wrote down an example of combinations of arrangements.

I used three different dates. In which the outcomes were available. The first three sheets.

Is there a possiblity to use excel to calculate a future outcome of the next month(Sheet 4). The figures are in a way linear, because the previous months are in it.

So it's possible for the future outcome to go up or stay the same. It can't be less then previous months.

See attachments.

**Jack7774** · 04-30-2014, 02:53 PM

FORECAST is an excel formula that you might be able to use however I see your example I just can't wrap my brain around a real life situation to fit the variables you have setup. Can you give me an example of what the numbers might be?

**a1b2c3d4e5f6g7** · 05-02-2014, 07:49 AM

Hello,

You are willing to think about the real life situations.
But it's a statistic example.

It's about a holiday (combinations) of arrangements. So it'll be influenced by the date (because of holliday plannings), finance etc etc. But the last factors/variables we will use and test in SPSS and other programs.

The question is more: Is there a program/formula in excel which will predict the outcome in the last sheet with maybe a factor of outliners (this coincendence of a better salary in some parts/or the date that people will book a holiday). And how the formula would be formulated in the last sheet?

Thanks

**Jack7774** · 05-02-2014, 09:35 AM

Well the easiest way i know how to explain it is Forecast will predict whatever value you ask of it if you give it x and y cordinates however in your case you have 3 criterias. Take a look at what I put together. It is not pretty by any means. However it may give you an idea on how to use forecast to get what you desire and you can create your own way of moving data around to fit your preference so it looks better.