DASHBOARD

DASHBOARD EASY
EASY Product Sales Ratio

Product A
Product B
Product C

Daily Sales Shares

350
300
250
200

39 150
100
50
0
ПНД ВТР СРД ЧТВ ПТН СБТ ВСК

Product A Product B Product C

https://exceltable.com/en/templates/simp
 Monthly average sales Septemb
er
140

120

100

80

60

40

20

Product A Product B Product C

Daily Sales Activity

300

250

200

150

100

50

0
Т ВСК ПНД ВТР СРД ЧТВ ПТН СБТ ВСК

Product A Product B Product C

en/templates/simple-dashboard-template-without-macros
 39 ←week number 1
Product Sales Ratio 6
ProductA 398 700.58 10
ProductB 601 497.58 14
ProductC 826 272.58 19
Product B 1098.58 23
Labels Product C 27
Daily Sales Shares Daily Sales Activity 32
№ Product A Product B Product C ProductC ProductB ProductA 36
1 104 158 54 ПНД 54 158 104 41
2 69 105 89 ВТР 89 105 69 45
3 34 52 241 СРД 241 52 34 49
4 86 127 109 ЧТВ 109 127 86
5 72 109 92 ПТН 92 109 72
6 24 36 120 СБТ 120 36 24
7 9 14 121 ВСК 121 14 9
Labels Product C Product B Product A

53 https://exceltable.com/en/templates/simple-dashboard-template-w
Monthly average sales Current Approximation
Week Month Product A Product B Product C month Product A Product B Product C
1 1 1 3 24 9 1 22.28887 34.22092 30.60869
2 1 73 106 37 Days in a 2 37.10632 55.69799 54.58582
3 1 48 74 63 month 3 46.62439 69.74064 74.53198
4 1 24 37 171 30 4 52.13239 78.09925 90.49723
5 1 84 128 109 September 5 54.72279 82.26517 102.6456
6 2 70 104 89 6 55.30575 83.4893 111.239
7 2 23 36 119 7 54.62369 82.80068 116.6212
8 2 8 14 118 8 53.26581 81.02501 119.2016
9 2 81 124 42 9 51.68265 78.80325 119.4394
10 3 54 76 69 10 50.20061 76.61023 117.8272
11 3 27 41 189 11 49.0365 74.77318 114.8752
12 3 93 142 120 12 48.31208 73.49029 111.0947
13 3 78 118 100 13 48.06862 72.84934 106.9827
14 4 25 37 130 14 48.2814 72.84624 103.0052
15 4 10 16 130 15 48.87432 73.40359 99.58121
16 4 87 132 45 16 49.73434 74.38928 97.06698
17 4 58 88 75 17 50.72613 75.63505 95.73963
18 4 28 41 200 18 51.70653 76.95508 95.78115
19 5 68 103 87 19 52.53915 78.16453 97.26229
20 5 56 86 73 20 53.10885 79.09816 100.1265
21 5 18 28 96 21 53.33634 79.62885 104.174
22 5 7 0 87 22 53.19269 79.68623 109.0452
23 6 104 158 54 23 52.71388 79.27521 114.2052
24 6 69 105 89 24 52.01533 78.49457 118.9274
25 6 34 52 241 25 51.30647 77.55553 122.2775
26 6 86 127 109 26 50.90524 76.80034 123.0973
27 7 72 109 92 27 51.25266 76.72084 119.9887
28 7 24 36 120 28 52.92739 77.97701 111.2977
29 7 9 14 121 29 56.66021 81.41559 95.09807
30 7 97 135 47 30 63.34861 88.08864 69.1756
31 7 0 0 0 31 #N/A #N/A #N/A
32 8
33 8
34 8
35 8
36 9
37 9
38 9
39 9
40 9
41 10
42 10
43 10
44 10
45 11
46 11
47 11
48 11
49 12
50 12
51 12
52 12
53 12
 Jan 1 4.4116 0.735849 14 January
Feb 6 4.4116 February
Mar 10 4.4116 September week №39 March
Apr 14 4.4116 April
May 19 4.4116 May
Jun 23 4.4116 June
Jul 27 4.4116 July
Aug 32 4.4116 August
Sep 36 4.4116 September
Oct 41 4.4116 October
Nov 45 4.4116 November
Dec 49 4.4116 December

hboard-template-without-macros

y = (c3 * x^3) + (c2 * x^2) + (c1 * x^1) + b

b 0.67137047 3.281415 2.68060124
c1 25.573511 36.41983 29.8411547
c2 -4.25330933 -5.880182 -1.8691517
c3 0.30719941 0.412817 -0.0505446
c4 -0.01001922 -0.013115 0.00675996
c5 0.00012118 0.000155 -0.000134
R 2
0.04566411 0.040413 0.17574465
 Date Sales by Product Category Week Day of Month Day of https://exceltable
number the week Number month
A B C
1/1/2024 74 112 38 1 1 1 1
1/2/2024 49 64 60 1 2 1 2
1/3/2024 24 37 171 1 3 1 3
1/4/2024 59 90 76 1 4 1 4
1/5/2024 49 75 64 1 5 1 5
1/6/2024 16 13 79 1 6 1 6
1/7/2024 6 9 81 1 7 1 7
1/8/2024 77 117 40 2 1 1 8
1/9/2024 51 78 66 2 2 1 9
1/10/2024 25 26 175 2 3 1 10
1/11/2024 85 129 110 2 4 1 11
1/12/2024 71 108 91 2 5 1 12
1/13/2024 23 36 119 2 6 1 13
1/14/2024 8 7 116 2 7 1 14
1/15/2024 67 102 35 3 1 1 15
1/16/2024 44 68 58 3 2 1 16
1/17/2024 22 34 156 3 3 1 17
1/18/2024 74 98 92 3 4 1 18
1/19/2024 61 94 80 3 5 1 19
1/20/2024 20 31 105 3 6 1 20
1/21/2024 8 12 104 3 7 1 21
1/22/2024 77 104 37 4 1 1 22
1/23/2024 51 78 66 4 2 1 23
1/24/2024 25 39 178 4 3 1 24
1/25/2024 76 115 96 4 4 1 25
1/26/2024 63 80 77 4 5 1 26
1/27/2024 20 32 106 4 6 1 27
1/28/2024 8 12 104 4 7 1 28
1/29/2024 79 120 41 5 1 1 29
1/30/2024 52 67 65 5 2 1 30
1/31/2024 26 40 184 5 3 1 31
2/1/2024 60 92 77 5 4 2 1
2/2/2024 50 76 64 5 5 2 2
2/3/2024 16 24 85 5 6 2 3
2/4/2024 6 10 84 5 7 2 4
2/5/2024 86 131 44 6 1 2 5
2/6/2024 57 87 74 6 2 2 6
2/7/2024 28 36 195 6 3 2 7
2/8/2024 88 133 112 6 4 2 8
2/9/2024 72 111 94 6 5 2 9
2/10/2024 24 36 122 6 6 2 10
2/11/2024 9 10 120 6 7 2 11
2/12/2024 94 143 48 7 1 2 12
2/13/2024 62 95 80 7 2 2 13
2/14/2024 31 47 217 7 3 2 14
2/15/2024 65 91 82 7 4 2 15
2/16/2024 54 83 70 7 5 2 16
2/17/2024 18 28 92 7 6 2 17
2/18/2024 7 11 90 7 7 2 18
2/19/2024 86 116 41 8 1 2 19
2/20/2024 57 87 74 8 2 2 20
2/21/2024 28 44 200 8 3 2 21
2/22/2024 85 130 110 8 4 2 22
2/23/2024 71 93 88 8 5 2 23
2/24/2024 24 36 120 8 6 2 24
2/25/2024 8 14 118 8 7 2 25
2/26/2024 77 118 41 9 1 2 26
2/27/2024 52 72 65 9 2 2 27
2/28/2024 25 39 178 9 3 2 28
2/29/2024 88 134 113 9 4 2 29
3/1/2024 73 112 94 9 5 3 1
3/2/2024 24 31 120 9 6 3 2
3/3/2024 9 14 121 9 7 3 3
3/4/2024 22 34 12 10 1 3 4
3/5/2024 14 22 19 10 2 3 5
3/6/2024 7 1 47 10 3 3 6
3/7/2024 18 28 24 10 4 3 7
3/8/2024 15 23 20 10 5 3 8
3/9/2024 4 8 26 10 6 3 9
3/10/2024 1 57 20 10 7 3 10
3/11/2024 18 28 9 11 1 3 11
3/12/2024 12 18 15 11 2 3 12
3/13/2024 5 8 39 11 3 3 13
3/14/2024 24 31 31 11 4 3 14
3/15/2024 20 31 27 11 5 3 15
3/16/2024 6 10 34 11 6 3 16
3/17/2024 2 4 30 11 7 3 17
3/18/2024 16 20 8 12 1 3 18
3/19/2024 10 16 13 12 2 3 19
3/20/2024 4 8 35 12 3 3 20
3/21/2024 30 46 39 12 4 3 21
3/22/2024 25 25 30 12 5 3 22
3/23/2024 8 12 42 12 6 3 23
3/24/2024 3 4 41 12 7 3 24
3/25/2024 29 45 16 13 1 3 25
3/26/2024 20 22 24 13 2 3 26
3/27/2024 9 15 68 13 3 3 27
3/28/2024 34 52 44 13 4 3 28
3/29/2024 28 43 36 13 5 3 29
3/30/2024 8 11 47 13 6 3 30
3/31/2024 3 5 44 13 7 3 31
4/1/2024 30 46 16 14 1 4 1
4/2/2024 20 30 26 14 2 4 2
4/3/2024 9 57 64 14 3 4 3
4/4/2024 20 30 25 14 4 4 4
4/5/2024 16 24 21 14 5 4 5
4/6/2024 4 8 26 14 6 4 6
4/7/2024 1 57 20 14 7 4 7
4/8/2024 35 53 18 15 1 4 8
4/9/2024 23 35 30 15 2 4 9
4/10/2024 11 17 79 15 3 4 10
4/11/2024 32 40 40 15 4 4 11
4/12/2024 27 41 35 15 5 4 12
4/13/2024 8 13 45 15 6 4 13
4/14/2024 3 5 44 15 7 4 14
4/15/2024 31 40 15 16 1 4 15
4/16/2024 20 31 27 16 2 4 16
4/17/2024 10 16 71 16 3 4 17
4/18/2024 20 31 27 16 4 4 18
4/19/2024 16 24 22 16 5 4 19
4/20/2024 5 8 29 16 6 4 20
4/21/2024 1 3 24 16 7 4 21
4/22/2024 30 46 16 17 1 4 22
4/23/2024 20 24 25 17 2 4 23
4/24/2024 9 15 68 17 3 4 24
4/25/2024 30 46 39 17 4 4 25
4/26/2024 25 38 33 17 5 4 26
4/27/2024 8 0 38 17 6 4 27
4/28/2024 3 4 41 17 7 4 28
4/29/2024 38 58 20 18 1 4 29
4/30/2024 25 39 33 18 2 4 30
5/1/2024 12 12 88 18 3 5 1
5/2/2024 23 35 30 18 4 5 2
5/3/2024 19 29 25 18 5 5 3
5/4/2024 6 9 33 18 6 5 4
5/5/2024 2 57 27 18 7 5 5
5/6/2024 21 33 12 19 1 5 6
5/7/2024 14 22 19 19 2 5 7
5/8/2024 7 11 49 19 3 5 8
5/9/2024 23 20 27 19 4 5 9
5/10/2024 19 29 25 19 5 5 10
5/11/2024 6 9 33 19 6 5 11
5/12/2024 2 4 30 19 7 5 12
5/13/2024 26 36 13 20 1 5 13
5/14/2024 17 27 23 20 2 5 14
5/15/2024 8 13 61 20 3 5 15
5/16/2024 17 27 23 20 4 5 16
5/17/2024 14 14 17 20 5 5 17
5/18/2024 4 7 25 20 6 5 18
5/19/2024 1 3 24 20 7 5 19
5/20/2024 14 22 8 21 1 5 20
5/21/2024 9 12 12 21 2 5 21
5/22/2024 4 7 34 21 3 5 22
5/23/2024 18 28 24 21 4 5 23
5/24/2024 15 23 20 21 5 5 24
5/25/2024 4 57 24 21 6 5 25
5/26/2024 1 3 24 21 7 5 26
5/27/2024 20 30 10 22 1 5 27
5/28/2024 12 20 17 22 2 5 28
5/29/2024 6 57 43 22 3 5 29
5/30/2024 20 31 26 22 4 5 30
5/31/2024 16 25 23 22 5 5 31
6/1/2024 5 8 29 22 6 6 1
6/2/2024 1 57 23 22 7 6 2
6/3/2024 32 50 18 23 1 6 3
6/4/2024 21 33 29 23 2 6 4
6/5/2024 10 16 76 23 3 6 5
6/6/2024 13 17 18 23 4 6 6
6/7/2024 11 17 15 23 5 6 7
6/8/2024 3 5 18 23 6 6 8
6/9/2024 0 2 18 23 7 6 9
6/10/2024 19 14 6 24 1 6 10
6/11/2024 12 19 16 24 2 6 11
6/12/2024 5 9 43 24 3 6 12
6/13/2024 20 30 25 24 4 6 13
6/14/2024 16 15 18 24 5 6 14
6/15/2024 4 8 26 24 6 6 15
6/16/2024 1 3 24 24 7 6 16
6/17/2024 20 32 11 25 1 6 17
6/18/2024 13 5 15 25 2 6 18
6/19/2024 6 10 46 25 3 6 19
6/20/2024 24 37 33 25 4 6 20
6/21/2024 20 32 27 25 5 6 21
6/22/2024 6 57 31 25 6 6 22
6/23/2024 2 4 30 25 7 6 23
6/24/2024 20 30 10 26 1 6 24
6/25/2024 12 20 17 26 2 6 25
6/26/2024 6 57 42 26 3 6 26
6/27/2024 32 50 43 26 4 6 27
6/28/2024 27 41 35 26 5 6 28
6/29/2024 8 13 45 26 6 6 29
6/30/2024 3 57 40 26 7 6 30
7/1/2024 18 28 9 27 1 7 1
7/2/2024 12 18 15 27 2 7 2
7/3/2024 5 8 39 27 3 7 3
7/4/2024 30 30 35 27 4 7 4
7/5/2024 25 39 33 27 5 7 5
7/6/2024 8 12 42 27 6 7 6
7/7/2024 3 4 41 27 7 7 7
7/8/2024 16 12 5 28 1 7 8
7/9/2024 10 16 13 28 2 7 9
7/10/2024 4 8 35 28 3 7 10
7/11/2024 34 52 44 28 4 7 11
7/12/2024 28 27 32 28 5 7 12
7/13/2024 8 14 48 28 6 7 13
7/14/2024 3 5 44 28 7 7 14
7/15/2024 28 44 15 29 1 7 15
7/16/2024 19 15 21 29 2 7 16
7/17/2024 9 14 67 29 3 7 17
7/18/2024 28 42 36 29 4 7 18
7/19/2024 23 35 30 29 5 7 19
7/20/2024 7 57 36 29 6 7 20
7/21/2024 2 4 38 29 7 7 21
7/22/2024 28 43 14 30 1 7 22
7/23/2024 19 28 25 30 2 7 23
7/24/2024 8 1 62 30 3 7 24
7/25/2024 24 37 32 30 4 7 25
7/26/2024 20 31 26 30 5 7 26
7/27/2024 6 10 34 30 6 7 27
7/28/2024 2 1 30 30 7 7 28
7/29/2024 36 56 19 31 1 7 29
7/30/2024 24 37 32 31 2 7 30
7/31/2024 12 18 82 31 3 7 31
8/1/2024 23 24 28 31 4 8 1
8/2/2024 19 29 25 31 5 8 2
8/3/2024 6 9 33 31 6 8 3
8/4/2024 2 4 30 31 7 8 4
8/5/2024 33 36 14 32 1 8 5
8/6/2024 22 33 29 32 2 8 6
8/7/2024 11 16 78 32 3 8 7
8/8/2024 19 29 25 32 4 8 8
8/9/2024 16 9 17 32 5 8 9
8/10/2024 4 8 26 32 6 8 10
8/11/2024 1 3 24 32 7 8 11
8/12/2024 26 40 14 33 1 8 12
8/13/2024 17 22 22 33 2 8 13
8/14/2024 8 12 57 33 3 8 14
8/15/2024 28 44 37 33 4 8 15
8/16/2024 24 36 31 33 5 8 16
8/17/2024 8 8 39 33 6 8 17
8/18/2024 2 4 38 33 7 8 18
8/19/2024 27 41 14 34 1 8 19
8/20/2024 17 27 23 34 2 8 20
8/21/2024 8 57 57 34 3 8 21
8/22/2024 24 36 31 34 4 8 22
8/23/2024 20 30 26 34 5 8 23
8/24/2024 6 10 34 34 6 8 24
8/25/2024 2 57 27 34 7 8 25
8/26/2024 15 24 8 35 1 8 26
8/27/2024 10 16 13 35 2 8 27
8/28/2024 4 8 35 35 3 8 28
8/29/2024 20 16 23 35 4 8 29
8/30/2024 16 25 22 35 5 8 30
8/31/2024 4 8 26 35 6 8 31
9/1/2024 1 3 24 35 7 9 1
9/2/2024 73 106 37 36 1 9 2
9/3/2024 48 74 63 36 2 9 3
9/4/2024 24 37 171 36 3 9 4
9/5/2024 84 128 109 36 4 9 5
9/6/2024 70 104 89 36 5 9 6
9/7/2024 23 36 119 36 6 9 7
9/8/2024 8 14 118 36 7 9 8
9/9/2024 81 124 42 37 1 9 9
9/10/2024 54 76 69 37 2 9 10
9/11/2024 27 41 189 37 3 9 11
9/12/2024 93 142 120 37 4 9 12
9/13/2024 78 118 100 37 5 9 13
9/14/2024 25 37 130 37 6 9 14
9/15/2024 10 16 130 37 7 9 15
9/16/2024 87 132 45 38 1 9 16
9/17/2024 58 88 75 38 2 9 17
9/18/2024 28 41 200 38 3 9 18
9/19/2024 68 103 87 38 4 9 19
9/20/2024 56 86 73 38 5 9 20
9/21/2024 18 28 96 38 6 9 21
9/22/2024 7 0 87 38 7 9 22
9/23/2024 104 158 54 39 1 9 23
9/24/2024 69 105 89 39 2 9 24
 9/25/2024 34 52 241 39 3 9 25
9/26/2024 86 127 109 39 4 9 26
9/27/2024 72 109 92 39 5 9 27
9/28/2024 24 36 120 39 6 9 28
9/29/2024 9 14 121 39 7 9 29
9/30/2024 97 135 47 40 1 9 30
10/1/2024 64 98 83 40 2 10 1
10/2/2024 32 48 222 40 3 10 2
10/3/2024 91 138 116 40 4 10 3
10/4/2024 76 104 95 40 5 10 4
10/5/2024 24 38 128 40 6 10 5
10/6/2024 9 15 124 40 7 10 6
10/7/2024 96 147 50 41 1 10 7
10/8/2024 64 90 80 41 2 10 8
10/9/2024 32 48 222 41 3 10 9
10/10/2024 87 132 112 41 4 10 10
10/11/2024 72 111 94 41 5 10 11
10/12/2024 24 28 119 41 6 10 12
10/13/2024 9 14 121 41 7 10 13
10/14/2024 87 132 45 42 1 10 14
10/15/2024 57 88 74 42 2 10 15
10/16/2024 28 42 200 42 3 10 16
10/17/2024 62 95 80 42 4 10 17
10/18/2024 52 79 66 42 5 10 18
10/19/2024 16 26 88 42 6 10 19
10/20/2024 6 1 82 42 7 10 20
10/21/2024 93 142 49 43 1 10 21
10/22/2024 62 95 80 43 2 10 22
10/23/2024 31 47 217 43 3 10 23
10/24/2024 80 112 100 43 4 10 24
10/25/2024 66 101 86 43 5 10 25
10/26/2024 22 33 113 43 6 10 26
10/27/2024 8 13 111 43 7 10 27
10/28/2024 91 135 46 44 1 10 28
10/29/2024 60 92 79 44 2 10 29
10/30/2024 30 46 211 44 3 10 30
10/31/2024 80 122 104 44 4 10 31
11/1/2024 67 100 85 44 5 11 1
11/2/2024 22 33 113 44 6 11 2
11/3/2024 8 13 111 44 7 11 3
11/4/2024 94 143 48 45 1 11 4
11/5/2024 62 89 79 45 2 11 5
11/6/2024 31 47 217 45 3 11 6
11/7/2024 64 99 84 45 4 11 7
11/8/2024 54 82 70 45 5 11 8
 11/9/2024 17 16 87 45 6 11 9
11/10/2024 7 11 90 45 7 11 10
11/11/2024 95 144 49 46 1 11 11
11/12/2024 63 96 80 46 2 11 12
11/13/2024 31 45 218 46 3 11 13
11/14/2024 80 122 103 46 4 11 14
11/15/2024 67 101 86 46 5 11 15
11/16/2024 22 33 113 46 6 11 16
11/17/2024 8 10 110 46 7 11 17
11/18/2024 76 115 38 47 1 11 18
11/19/2024 50 76 65 47 2 11 19
11/20/2024 24 38 175 47 3 11 20
11/21/2024 64 94 81 47 4 11 21
11/22/2024 53 81 69 47 5 11 22
11/23/2024 17 27 90 47 6 11 23
11/24/2024 6 10 84 47 7 11 24
11/25/2024 96 133 47 48 1 11 25
11/26/2024 64 96 82 48 2 11 26
11/27/2024 32 48 222 48 3 11 27
11/28/2024 82 124 106 48 4 11 28
11/29/2024 68 100 87 48 5 11 29
11/30/2024 22 34 114 48 6 11 30
12/1/2024 8 13 111 48 7 12 1
12/2/2024 88 135 46 49 1 12 2
12/3/2024 59 85 75 49 2 12 3
12/4/2024 29 44 207 49 3 12 4
12/5/2024 84 128 109 49 4 12 5
12/6/2024 70 107 90 49 5 12 6
12/7/2024 23 24 117 49 6 12 7
12/8/2024 8 14 118 49 7 12 8
12/9/2024 94 143 49 50 1 12 9
12/10/2024 62 95 80 50 2 12 10
12/11/2024 31 40 217 50 3 12 11
12/12/2024 73 112 94 50 4 12 12
12/13/2024 61 93 79 50 5 12 13
12/14/2024 20 31 103 50 6 12 14
12/15/2024 8 4 98 50 7 12 15
12/16/2024 76 115 38 51 1 12 16
12/17/2024 50 76 65 51 2 12 17
12/18/2024 24 38 175 51 3 12 18
12/19/2024 88 124 112 51 4 12 19
12/20/2024 74 112 95 51 5 12 20
12/21/2024 24 37 125 51 6 12 21
12/22/2024 9 15 124 51 7 12 22
12/23/2024 94 142 48 52 1 12 23
12/24/2024 62 95 80 52 2 12 24
12/25/2024 31 47 217 52 3 12 25
12/26/2024 84 128 109 52 4 12 26
12/27/2024 70 94 87 52 5 12 27
12/28/2024 23 36 119 52 6 12 28
12/29/2024 8 14 118 52 7 12 29
12/30/2024 123 187 63 1 1 12 30
12/31/2024 81 123 105 1 2 12 31
https://exceltable.com/en/templates/simple-dashboard-template-without-macros
te-without-macros