CasualDabbler
New Member
- Joined
- Oct 29, 2018
- Messages
- 19
- Office Version
- 2016
- Platform
- Windows
I'm trying to calculate a number of sales forecast patterns.
Limited snapshot below (Full sheet attached for reference)
There are 127 possible patterns
There are a batch of known average daily profile percentages. I need to forecast what the unknown patterns would look like based on trends from known patters
i.e.
_T_T_S_ (Tue, Thu, Sat) is Typically 36%, 29%, 35%
_T_TF__ (Tue, Thu, Fri) is unknown.
Example File
Limited snapshot below (Full sheet attached for reference)
There are 127 possible patterns
There are a batch of known average daily profile percentages. I need to forecast what the unknown patterns would look like based on trends from known patters
i.e.
_T_T_S_ (Tue, Thu, Sat) is Typically 36%, 29%, 35%
_T_TF__ (Tue, Thu, Fri) is unknown.
Forecasts.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Index | Pattern | Freq | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Known | ||
10 | 20 | __W_F__ | 2 | 55% | 45% | Known | |||||||
13 | 27 | __WT_SS | 4 | 38% | 16% | 23% | 23% | Known | |||||
19 | 40 | _T_T___ | 2 | 52% | 48% | Known | |||||||
20 | 41 | _T_T__S | 3 | 27% | 36% | 37% | Known | ||||||
21 | 42 | _T_T_S_ | 3 | 36% | 29% | 35% | Known | ||||||
24 | 47 | _T_TFSS | 5 | 21% | 24% | 16% | 19% | 20% | Known | ||||
44 | 84 | M_W_F__ | 3 | 41% | 24% | 35% | Known | ||||||
53 | 95 | M_WTFSS | 6 | 24% | 20% | 13% | 13% | 16% | 14% | Known | |||
54 | 100 | MT__F__ | 3 | 36% | 23% | 41% | Known | ||||||
55 | 101 | MT__F_S | 4 | 17% | 26% | 36% | 21% | Known | |||||
61 | 110 | MT_TFS_ | 5 | 25% | 20% | 20% | 15% | 20% | Known | ||||
71 | 127 | MTWTFSS | 7 | 16% | 12% | 12% | 14% | 16% | 17% | 13% | Known | ||
72 | |||||||||||||
94 | 39 | _T__FSS | 4 | Unknown | |||||||||
95 | 44 | _T_TF__ | 3 | Unknown | |||||||||
96 | 46 | _T_TFS_ | 4 | Unknown | |||||||||
97 | 48 | _TW____ | 2 | Unknown | |||||||||
98 | 49 | _TW___S | 3 | Unknown | |||||||||
111 | 78 | M__TFS_ | 4 | Unknown | |||||||||
112 | 79 | M__TFSS | 5 | Unknown | |||||||||
113 | 83 | M_W__SS | 4 | Unknown | |||||||||
114 | 88 | M_WT___ | 3 | Unknown | |||||||||
115 | 92 | M_WTF__ | 4 | Unknown | |||||||||
Sheet1 |
Example File