Excel forecast using number series

[Mr2017]

Hi

Has anyone used functions or formulae to work to generate forecasts based on a number series in Excel?

The number series data below apparently has a predictable pattern.

And I need to use it to generate forecasts for 2015 Q1 up to 2015 Q4 at the end of the table:

Has anyone done something similar?

The specific questions I need to answer are:

1) which letter will sell the most units in Q1 2015? and
2) which letter will sell the most units in all of 2015?

TIA

1​

2​

3​

4​

5

6

7

8

9​

10

11

12

13

14

15

16

Letter

2012 Q1

2012 Q2

2012 Q3

2012 Q4

2013 Q1

2013 Q2

2013 Q3

2013 Q4

2014 Q1

2014 Q2

2014 Q3

2014 Q4

2015 Q1

2015 Q2

2015 Q3

2015 Q4

X

21​

32​

19​

21​

26​

13​

6​

3​

1​

1​

1​

1​

Y

29​

44​

27​

30​

36​

18​

9​

5​

3​

Z

43​

65​

39​

43​

53​

26​

13​

A

58​

87​

52​

57​

69​

B

37​

55​

33​

36​

C

28​

42​

25​

D

22​

33​

E

21​

Total

21​

32​

19​

50​

70​

83​

101​

136​

186​

198​

186​

201​

 

[Fluff]

Duplicate Excel forecast

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).