| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Year-Month | Month | Period Number | Revenue | MA | MA2 | S+I | S | Deseasoned Revenue | Trend Forecast | Forecast | ME |
2 | 2017-Oct | 10 | 1 | $31,453 | 1.03 | $4,218.36 | ||||||
3 | 2017-Nov | 11 | 2 | $78,629 | 1.79 | |||||||
4 | 2017-Dec | 12 | 3 | $69,546 | 1.93 | |||||||
5 | 2018-Jan | 1 | 4 | $18,174 | 0.66 | |||||||
6 | 2018-Feb | 2 | 5 | $11,951 | 0.48 | |||||||
7 | 2018-Mar | 3 | 6 | $38,726 | 1.19 | |||||||
8 | 2018-Apr | 4 | 7 | $34,195 | 0.81 | |||||||
9 | 2018-May | 5 | 8 | $30,132 | 1.33 | |||||||
10 | 2018-Jun | 6 | 9 | $24,797 | 0.91 | |||||||
11 | 2018-Jul | 7 | 10 | $28,765 | 0.86 | |||||||
12 | 2018-Aug | 8 | 11 | $36,898 | 0.68 | |||||||
13 | 2018-Sep | 9 | 12 | $64,596 | $38,989 | 1.60 | ||||||
14 | 2018-Oct | 10 | 13 | $31,405 | $38,985 | $38,987 | 0.81 | 1.03 | $30,444 | $37,360.56 | $38,539.64 | $7,134.72 |
15 | 2018-Nov | 11 | 14 | $75,973 | $38,763 | $38,874 | 1.95 | 1.79 | $42,417 | $38,230.68 | $68,474.32 | $7,498.24 |
16 | 2018-Dec | 12 | 15 | $74,920 | $39,211 | $38,987 | 1.92 | 1.93 | $38,742 | $39,100.79 | $75,612.65 | $693.13 |
17 | 2019-Jan | 1 | 16 | $18,542 | $39,242 | $39,226 | 0.47 | 0.66 | $28,071 | $39,970.90 | $26,403.50 | $7,861.00 |
18 | 2019-Feb | 2 | 17 | $22,979 | $40,161 | $39,701 | 0.58 | 0.48 | $47,700 | $40,841.01 | $19,674.54 | $3,304.28 |
19 | 2019-Mar | 3 | 18 | $51,716 | $41,243 | $40,702 | 1.27 | 1.19 | $43,418 | $41,711.13 | $49,682.37 | $2,033.50 |
20 | 2019-Apr | 4 | 19 | $38,750 | $41,623 | $41,433 | 0.94 | 0.81 | $47,775 | $42,581.24 | $34,537.08 | $4,212.96 |
21 | 2019-May | 5 | 20 | $56,988 | $43,861 | $42,742 | 1.33 | 1.33 | $42,742 | $43,451.35 | $57,933.87 | $946.14 |
22 | 2019-Jun | 6 | 21 | $40,345 | $45,156 | $44,509 | 0.91 | 0.91 | $44,509 | $44,321.46 | $40,174.96 | $169.57 |
23 | 2019-Jul | 7 | 22 | $39,262 | $46,031 | $45,594 | 0.86 | 0.86 | $45,594 | $45,191.58 | $38,915.69 | $346.28 |
24 | 2019-Aug | 8 | 23 | $31,115 | $45,549 | $45,790 | 0.68 | 0.68 | $45,790 | $46,061.69 | $31,299.92 | $184.55 |
25 | 2019-Sep | 9 | 24 | $73,410 | $46,284 | $45,916 | 1.60 | 1.60 | $45,916 | $46,931.80 | $75,033.43 | $1,623.40 |
26 | 2019-Oct | 10 | 25 | $59,688 | $48,641 | $47,462 | 1.26 | 1.03 | $57,862 | $47,801.92 | $49,310.52 | $10,377.23 |
27 | 2019-Nov | 11 | 26 | $79,412 | $48,927 | $48,784 | 1.63 | 1.79 | $44,337 | $48,672.03 | $87,175.66 | $7,763.69 |
28 | 2019-Dec | 12 | 27 | $96,999 | $50,767 | $49,847 | 1.95 | 1.93 | $50,160 | $49,542.14 | $95,804.02 | $1,195.02 |
29 | 2020-Jan | 1 | 28 | $43,971 | $52,886 | $51,827 | 0.85 | 0.66 | $66,566 | $50,412.25 | $33,300.72 | $10,670.66 |
30 | 2020-Feb | 2 | 29 | $20,301 | $52,663 | $52,775 | 0.38 | 0.48 | $42,142 | $51,282.37 | $24,704.50 | $4,403.37 |
31 | 2020-Mar | 3 | 30 | $58,872 | $53,259 | $52,961 | 1.11 | 1.19 | $49,427 | $52,152.48 | $62,119.13 | $3,246.77 |
32 | 2020-Apr | 4 | 31 | $36,522 | $53,074 | $53,167 | 0.69 | 0.81 | $45,028 | $53,022.59 | $43,005.92 | $6,484.38 |
33 | 2020-May | 5 | 32 | 1.33 | $53,892.70 | $71,855.36 | ||||||
34 | 2020-Jun | 6 | 33 | 0.91 | $54,762.82 | $49,639.47 | ||||||
35 | 2020-Jul | 7 | 34 | 0.86 | $55,632.93 | $47,907.02 | ||||||
36 | 2020-Aug | 8 | 35 | 0.68 | $56,503.04 | $38,395.05 | ||||||
37 | 2020-Sep | 9 | 36 | 1.60 | $57,373.15 | $91,726.81 | ||||||
38 | 2020-Oct | 10 | 37 | 1.03 | $58,243.27 | $60,081.39 | ||||||
39 | 2020-Nov | 11 | 38 | 1.79 | $59,113.38 | $105,876.99 | ||||||
40 | 2020-Dec | 12 | 39 | 1.93 | $59,983.49 | $115,995.39 | ||||||
41 | ||||||||||||
42 | ||||||||||||
43 | ||||||||||||
44 | ||||||||||||
45 | ||||||||||||
46 | ||||||||||||
47 | ||||||||||||
48 | ||||||||||||
49 | ||||||||||||
50 | ||||||||||||
51 | ||||||||||||
52 | ||||||||||||
53 | ||||||||||||
54 | ||||||||||||
55 | ||||||||||||
56 | ||||||||||||
57 | ||||||||||||
58 | ||||||||||||
59 | ||||||||||||
60 | ||||||||||||
61 | ||||||||||||
62 | ||||||||||||
63 | ||||||||||||
64 | ||||||||||||
65 | ||||||||||||
66 | ||||||||||||
67 | ||||||||||||
68 | ||||||||||||
69 | ||||||||||||
70 | ||||||||||||
71 | ||||||||||||
72 | ||||||||||||
73 | ||||||||||||
74 | ||||||||||||
75 | ||||||||||||
76 | ||||||||||||
77 | ||||||||||||
78 | ||||||||||||
79 | ||||||||||||
80 | ||||||||||||
81 | ||||||||||||
82 | ||||||||||||
83 | ||||||||||||
84 | ||||||||||||
85 | ||||||||||||
86 | ||||||||||||
87 | ||||||||||||
88 | ||||||||||||
89 | ||||||||||||
90 | ||||||||||||
91 | ||||||||||||
92 | ||||||||||||
93 | ||||||||||||
94 | ||||||||||||
95 | ||||||||||||
96 | ||||||||||||
97 | ||||||||||||
98 | ||||||||||||
99 | ||||||||||||
100 |