Excel Speedometer Dashboard

  • Uploaded by: Ramesh Radhakrishnaraja
  • 0
  • 0
  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Excel Speedometer Dashboard as PDF for free.

More details

  • Words: 1,443
  • Pages: 16
40

45 50 55

60

35 5.0 4.0

1.0 0.0

AR Acquisition Rate

0.88

65 70

30 25

75

20

80

15

85 90

10 5 0

Visitor Growth (w/w) 95 100

% Returning

46.9%

88.2% Entry Points Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum

Key Observations

Search Keywords Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum

Bounces Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum

70 75

% Returning Visitors

100 75

80 85 90 95

50

46.9%

Bounces Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum Lorum Ipsum

25 0

Data Entry for Dashboard Elements This Week Last Week New Visitors 79 70 Returning Visitors 90 32 Unique Visitors 192 102 Acquisition Index 0.88 2.19 % Returning Visitors 46.9% 31.4% % New Visitors 41.1% 68.6% W/W Visitor Growth 88.2%

Current Lmin Lmax

0.88 0.00 0.00 -1.53 -0.85

Outer Radius Inner Radius 1 Inner Radius 2 Outer Radius 2 Min Angle Max Angle Min Value Used Max Value Used Angle Gap Value Gap Angle Tick Gap Pie Bottom Lower Middle Upper

2 1.65 1.75 1.98 -225 -135 0 5 90 5 -150.80 4.50

270 18 54 18

-135 -139.50 -144.00 -148.50 -153.00 -157.50 -162.00 -166.50 -171.00 -175.50 -180.00 -184.50 -189.00 -193.50 -198.00 -202.50 -207.00 -211.50 -216.00 -220.50 -225.00

0.0 0.3 0.5 0.8 1.0 1.3 1.5 1.8 2.0 2.3 2.5 2.8 3.0 3.3 3.5 3.8 4.0 4.3 4.5 4.8 5.0

Tick Marks -1.24

-1.24

-1.41 -1.52 -1.62 -1.71 -1.78 -1.85 -1.90 -1.94 -1.98 -1.99 -2.00 -1.99 -1.98 -1.94 -1.90 -1.85 -1.78 -1.71 -1.62 -1.52 -1.41

-1.41 -1.30 -1.18 -1.04 -0.91 -0.77 -0.62 -0.47 -0.31 -0.16 0.00 0.16 0.31 0.47 0.62 0.77 0.91 1.04 1.18 1.30 1.41

-1.24 -1.33 -1.42 -1.49 -1.56 -1.62 -1.66 -1.70 -1.73 -1.74 -1.75 -1.74 -1.73 -1.70 -1.66 -1.62 -1.56 -1.49 -1.42 -1.33 -1.24

-1.24 -1.14 -1.03 -0.91 -0.79 -0.67 -0.54 -0.41 -0.27 -0.14 0.00 0.14 0.27 0.41 0.54 0.67 0.79 0.91 1.03 1.14 1.24

-1.41

-1.41

-1.33 -1.50

-1.14 -1.28

-1.42 -1.60

-1.03 -1.16

-1.49 -1.71

-0.91 -1.04

-1.56 -1.76

-0.79 -0.90

-1.62 -1.82

-0.67 -0.76

-1.66 -1.88

-0.54 -0.61

-1.70 -1.92

-0.41 -0.46

-1.73 -1.95

-0.27 -0.31

-1.74 -1.97

-0.14 -0.15

-1.75 -1.98

0.00 0.00

-1.74 -1.97

0.14 0.15

-1.73 -1.98

0.27 0.31

-1.70 -1.92

0.41 0.46

-1.66 -1.88

0.54 0.61

-1.62 -1.85

0.67 0.77

-1.56 -1.78

0.79 0.91

-1.49 -1.71

0.91 1.04

-1.42 -1.62

1.03 1.18

-1.33 -1.52

1.14 1.30

-1.24 -1.41

1.24 1.41

Current Lmin Lmax

88.2 0.00 1.71

Outer Radius Inner Radius 1 Inner Radius 2 Outer Radius 2

2 1.65 1.76 1.98

88.2% 0.00 -0.40

Min Angle -45 Max Angle 225 Min Value Used 0 Max Value Used 100 Angle Gap 270 Value Gap 100 Angle -13.24 Tick Gap 2.70 Pie Bottom Lower Middle Upper

-135 -137.70 -140.40 -143.10 -145.80 -148.50 -151.20 -153.90 -156.60 -159.30 -162.00 -164.70 -167.40 -170.10 -172.80 -175.50 -178.20 -180.90 -183.60 -186.30 -189.00 -191.70 -194.40 -197.10 -199.80

270 18 54 18

0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

-1.41 -1.48 -1.54 -1.60 -1.65 -1.71 -1.75 -1.80 -1.84 -1.87 -1.90 -1.93 -1.95 -1.97 -1.98 -1.99 -2.00 -2.00 -2.00 -1.99 -1.98 -1.96 -1.94 -1.91 -1.88

-1.41 -1.35 -1.27 -1.20 -1.12 -1.04 -0.96 -0.88 -0.79 -0.71 -0.62 -0.53 -0.44 -0.34 -0.25 -0.16 -0.06 0.03 0.13 0.22 0.31 0.41 0.50 0.59 0.68

-1.24 -1.30 -1.36 -1.41 -1.46 -1.50 -1.54 -1.58 -1.62 -1.65 -1.67 -1.70 -1.72 -1.73 -1.75 -1.75 -1.76 -1.76 -1.76 -1.75 -1.74 -1.72 -1.70 -1.68 -1.66

-1.24 -1.18 -1.12 -1.06 -0.99 -0.92 -0.85 -0.77 -0.70 -0.62 -0.54 -0.46 -0.38 -0.30 -0.22 -0.14 -0.06 0.03 0.11 0.19 0.28 0.36 0.44 0.52 0.60

-202.50 -205.20 -207.90 -210.60 -213.30 -216.00 -218.70 -221.40 -224.10 -226.80 -229.50 -232.20 -234.90 -237.60 -240.30 -243.00 -245.70 -248.40 -251.10 -253.80 -256.50 -259.20 -261.90 -264.60 -267.30 -270.00 -272.70 -275.40 -278.10 -280.80 -283.50 -286.20 -288.90 -291.60 -294.30 -297.00 -299.70 -302.40 -305.10 -307.80 -310.50 -313.20 -315.90 -318.60 -321.30 -324.00 -326.70 -329.40 -332.10 -334.80 -337.50 -340.20

25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 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

-1.85 -1.81 -1.77 -1.72 -1.67 -1.62 -1.56 -1.50 -1.44 -1.37 -1.30 -1.23 -1.15 -1.07 -0.99 -0.91 -0.82 -0.74 -0.65 -0.56 -0.47 -0.37 -0.28 -0.19 -0.09 0.00 0.09 0.19 0.28 0.37 0.47 0.56 0.65 0.74 0.82 0.91 0.99 1.07 1.15 1.23 1.30 1.37 1.44 1.50 1.56 1.62 1.67 1.72 1.77 1.81 1.85 1.88

0.77 0.85 0.94 1.02 1.10 1.18 1.25 1.32 1.39 1.46 1.52 1.58 1.64 1.69 1.74 1.78 1.82 1.86 1.89 1.92 1.94 1.96 1.98 1.99 2.00 2.00 2.00 1.99 1.98 1.96 1.94 1.92 1.89 1.86 1.82 1.78 1.74 1.69 1.64 1.58 1.52 1.46 1.39 1.32 1.25 1.18 1.10 1.02 0.94 0.85 0.77 0.68

-1.63 -1.59 -1.56 -1.51 -1.47 -1.42 -1.37 -1.32 -1.26 -1.20 -1.14 -1.08 -1.01 -0.94 -0.87 -0.80 -0.72 -0.65 -0.57 -0.49 -0.41 -0.33 -0.25 -0.17 -0.08 0.00 0.08 0.17 0.25 0.33 0.41 0.49 0.57 0.65 0.72 0.80 0.87 0.94 1.01 1.08 1.14 1.20 1.26 1.32 1.37 1.42 1.47 1.51 1.56 1.59 1.63 1.66

0.67 0.75 0.82 0.90 0.97 1.03 1.10 1.16 1.22 1.28 1.34 1.39 1.44 1.49 1.53 1.57 1.60 1.64 1.67 1.69 1.71 1.73 1.74 1.75 1.76 1.76 1.76 1.75 1.74 1.73 1.71 1.69 1.67 1.64 1.60 1.57 1.53 1.49 1.44 1.39 1.34 1.28 1.22 1.16 1.10 1.03 0.97 0.90 0.82 0.75 0.67 0.60

-342.90 -345.60 -348.30 -351.00 -353.70 -356.40 -359.10 -361.80 -364.50 -367.20 -369.90 -372.60 -375.30 -378.00 -380.70 -383.40 -386.10 -388.80 -391.50 -394.20 -396.90 -399.60 -402.30 -405.00

77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100

1.91 1.94 1.96 1.98 1.99 2.00 2.00 2.00 1.99 1.98 1.97 1.95 1.93 1.90 1.87 1.84 1.80 1.75 1.71 1.65 1.60 1.54 1.48 1.41

0.59 0.50 0.41 0.31 0.22 0.13 0.03 -0.06 -0.16 -0.25 -0.34 -0.44 -0.53 -0.62 -0.71 -0.79 -0.88 -0.96 -1.04 -1.12 -1.20 -1.27 -1.35 -1.41

1.68 1.70 1.72 1.74 1.75 1.76 1.76 1.76 1.75 1.75 1.73 1.72 1.70 1.67 1.65 1.62 1.58 1.54 1.50 1.46 1.41 1.36 1.30 1.24

0.52 0.44 0.36 0.28 0.19 0.11 0.03 -0.06 -0.14 -0.22 -0.30 -0.38 -0.46 -0.54 -0.62 -0.70 -0.77 -0.85 -0.92 -0.99 -1.06 -1.12 -1.18 -1.24

Tick Marks -1.24 -1.24 -1.41 -1.41 -1.50 -1.68

-0.92 -1.03

-1.67 -1.88

-0.54 -0.61

-1.75 -1.99

-0.14 -0.16

-1.74 -1.98

0.28 0.31

-1.63 -1.85

0.67 0.77

-1.42 -1.62

1.03 1.18

-1.14 -1.30

1.34 1.52

-0.80 -0.91

1.57 1.78

-0.41 -0.47

1.71 1.94

0.00 0.00

1.76 2.00

0.41 0.47

1.71 1.94

0.80 0.91

1.57 1.78

1.14 1.30

1.34 1.52

1.42 1.62

1.03 1.18

1.63 1.85

0.67 0.77

1.74 1.98

0.28 0.31

1.75

-0.14

1.99

-0.16

1.67 1.90

-0.54 -0.62

1.50 1.71

-0.92 -1.04

1.24 1.41

-1.24 -1.41

Current Lmin Lmax

53.13 46.9% 0.00 0.00 1.75 -0.09

Outer Radius Inner Radius 1 Inner Radius 2 Outer Radius 2 Min Angle Max Angle Min Value Used Max Value Used Angle Gap Value Gap Angle Tick Gap Pie Bottom Lower Middle Upper

2 1.65 1.75 1.98 45 135 0 100 90 100 -2.81 4.50

270 18 54 18

45 40.50 36.00 31.50 27.00 22.50 18.00 13.50 9.00 4.50 0.00 -4.50 -9.00 -13.50 -18.00 -22.50 -27.00 -31.50 -36.00 -40.50 -45.00

0 5 10 15 20 25 30 35 40 45 50 55 60 65 70 75 80 85 90 95 100

1.24

1.24

Tick Marks

1.41 1.52 1.62 1.71 1.78 1.85 1.90 1.94 1.98 1.99 2.00 1.99 1.98 1.94 1.90 1.85 1.78 1.71 1.62 1.52 1.41

1.41 1.30 1.18 1.04 0.91 0.77 0.62 0.47 0.31 0.16 0.00 -0.16 -0.31 -0.47 -0.62 -0.77 -0.91 -1.04 -1.18 -1.30 -1.41

1.24 1.33 1.42 1.49 1.56 1.62 1.66 1.70 1.73 1.74 1.75 1.74 1.73 1.70 1.66 1.62 1.56 1.49 1.42 1.33 1.24

1.24 1.14 1.03 0.91 0.79 0.67 0.54 0.41 0.27 0.14 0.00 -0.14 -0.27 -0.41 -0.54 -0.67 -0.79 -0.91 -1.03 -1.14 -1.24

1.41

1.41

1.33 1.50

1.14 1.28

1.42 1.60

1.03 1.16

1.49 1.71

0.91 1.04

1.56 1.76

0.79 0.90

1.62 1.82

0.67 0.76

1.66 1.88

0.54 0.61

1.70 1.92

0.41 0.46

1.73 1.95

0.27 0.31

1.74 1.97

0.14 0.15

1.75 1.98

0.00 0.00

1.74 1.97

-0.14 -0.15

1.73 1.98

-0.27 -0.31

1.70 1.92

-0.41 -0.46

1.66 1.88

-0.54 -0.61

1.62 1.85

-0.67 -0.77

1.56 1.78

-0.79 -0.91

1.49 1.71

-0.91 -1.04

1.42 1.62

-1.03 -1.18

1.33 1.52

-1.14 -1.30

1.24 1.41

-1.24 -1.41

Related Documents

Excel Speedometer Dashboard
November 2019 6
Speedometer
November 2019 2
Dashboard Excel Hotel
October 2019 13
Dashboard
May 2020 23
Dashboard
November 2019 23
2q Dashboard
May 2020 15

More Documents from "Japhy"