Excel Dashboard Widgets

RESUMEN PROYECTO RECAMBIO DE 2.059 LUMINARIAS-TUCAPEL Fecha

11/13/2014 43.00

DATOS DEL PROYECTO MUNICIPALIDAD Q Luminarias Q Luminarias Instaladas % Avance

TRUPAN

TUCAPEL 204 81 39.7%

HUEPIL 587 94 16.0%

961 52 5.4%

POLCURA

TOTAL CONTRATO SIN $ retencion del 5% $ Total según Estado de P $

T O T AL 2,059 227 11.02%

307 0.0%

AVANCE DEL PROYECTO luminarias instaladas vs Periodo de Ejecucion

LUMINARIAS

BRIKA 27w TECEO 55w TECEO 107w Total

INSTALADAS

PROYECTADAS

PENDIENTES

1400 290 54 1744

1576 309 174 2059

176 19 120 315

% 89% 94% 31% 85%

EP N ° 3

SECTORES TUCAPEL HUEPIL TRUPAN POLCURA LA OBRA

BRIKA 27 W 444 745 105 256 26

TECEO 55 W 89 96 73 51 0

TECEO 107 W 54 120 0 0 0

TOTAL

1,576

309

174

BOLETA GARANTIA SAESA

MONTO $ 5,000,000 UF 0,000.00

FECHA VENCIMIENTO 12/31/2012 10/31/2013

ESTADOS DE PAGO EP MONTAJISTA Total Estado de Pago retencion 10% Estado de Pago c/retencion

$ $ $

EP N°1 40,321,168 4,032,117 36,289,051

$ $ $

EP N°2 41,308,685 4,130,869 37,177,817

$

-

ITO GRUPO SAESA

EP N°1

EP N°2

EP N ° 3

Total Estado de Pago Estado de Pago c/retencion

#REF! #REF!

#REF! #REF!

#REF!

Guia 1_ N°17570 Guia 2_ N°17647 Guia 3_ N°XXXX Guia 4_ N°xxxx

BRIKA 27 W 0 0 1200 376

TECEO 55 W 0 309 0 0

TECEO 107 W 63 111 0 -

TOTAL

1576

309

174

LUMINARIAS GD LUMINARIAS

T OT AL 63 420 1200 376

BOLETAS DE GARANTIA BOLETA GARANTIA SINEC

Anticipo: Fiel Cumplimiento: Correcta Ejecucion: Mantenimiento

$

MONTO ECHA VE VENCIMIENTO #REF! NO CONSIDERA! #REF! 7/20/2013 #REF! 14,400,000

Seriedad Oferta Fiel Cumplimiento: Correcta Ejecucion: Mantenimiento

FECHAS IMPORTANTES Acta de Adjudicacion Firma de Contrato Acta de Entrega Terreno Periodo Ejecucion Termino de Obra

7/27/2012 9/13/2012 10/1/2014 100 dias 1/9/2015

Marcha Blanca Tramitacion R. Proviso Recepción Provisoria Periodo Mantenimient Termino de Proyecto

60 dias 90 dias 96 meses 9/20/2021

124,843,180 6,242,159 47,713,404

PROGRAMACIÓN FINAN "Servicio de Mejoramiento para Diversos Sectores del Sistema de

Estados de Pago N°1 N°2 N°3 N°4 N°5 N°6 N°7 Total

Mat eriales

Trupan

Tuc apel

Huepil

Mes 1

Se ptie mbre

07-oct

23-oct

30-oct

30-oct

2

2,9%

8,2%

2,9%

13,8%

1

38,4% $ 47.908.812

H

$ 3.574.036 $ 10.284.114 $ 3.66 3.661.6 1.635 35 $ 17.2 17.260 60.52 .528 8 $

(*) Todos Todos los montos indicados NO incluyen IVA.

EEPP N°1 EEPP N°2 EEPP N°3 EEPP N°4 EEPP N°5 EEPP N°6 TOTAL TOTAL PROYECTO

$ $ $ $ $ $ $ $

$ 47,713,404 47,713,404 124,843,180

% 38.2% 0.0% 0.0% 0.0% 0.0% 0.0% 38.2%

PROGRAMACIÓN FINAN "Servicio de Mejoramiento para Diversos Sectores del Sistema de

Estados de Pago N°1 N°2 N°3 N°4 N°5 N°6 N°7 Total

Mat eriales

Trupan

Tuc apel

Huepil

Mes 1

Se ptie mbre

07-oct

23-oct

30-oct

30-oct

2

2,9%

8,2%

2,9%

13,8%

1

38,4% $ 47.908.812

H

$ 3.574.036 $ 10.284.114 $ 3.66 3.661.6 1.635 35 $ 17.2 17.260 60.52 .528 8 $

(*) Todos Todos los montos indicados NO incluyen IVA.

EEPP N°1 EEPP N°2 EEPP N°3 EEPP N°4 EEPP N°5 EEPP N°6 TOTAL TOTAL PROYECTO

$ $ $ $ $ $ $ $

$ 47,713,404 47,713,404 124,843,180

% 38.2% 0.0% 0.0% 0.0% 0.0% 0.0% 38.2%

IERA Alumbrado lumbrado Publico de la Comuna de T ucapel" ucapel "

uepil

P olc ura

Planos

Mes 2

-nov

27-nov

28-nov

28-nov

0,6%

4,3%

5,1%

13,8%

13 13.174.879 $ 5.378.574

TOTAL

100,0% $ 47.908.812 $ 3.574.036 $ 10.284.114 $ 20.922.163 $ 13.174.879 $ 6.340.073 $ 11.718.647 $ 17. 17.26 260. 0.52 528 8 $ 17. 17.26 260.5 0.528 28 $ 124.843.180

Press F9 to update widge A) Linear Dial Widget Configuration Da Widget Main Title

Daily Widget Demand

Widget Units

x 1,000,000 Widgets / Day

Actual Value

15.1

Minimum Value

0.0

Maximum Value

100.0

B) Circular Dial Widget Type #1 Config Widget Main Title

Daily Widget Demand

Widget Units


Actual Value

95.0

Total Value

100.0

5

C) Circular Dial Widget Type #2 Config Widget Main Title

Daily Widget Demand

Widget Units


Actual Value

5.0

Total Value

60.0

D) Non-Linear Dial Widget Configuratio Widget Main Title

Sales YTD

Widget Units

x millions USD$

(Target:

Actual Value

4.7

Scale2

ScaleMin

0.0

Scale3

Scale1

0.8

Scale

E) Thermometer Widget Configuration Widget Main Title

Daily Widget Outlook

Widget Units


Actual Value

97.0%

Minimum Value

0%

Maximum Value

100%

F) Equalizer Widget Configuration Dat Sales YTD

(Target:

ScaleMin

0

Scale

Q1 Target

869

Q1 Act

Q2 Target

741

Q2 Act

Q3 Target

804

Q3 Act

Q4 Target

813

Q4 Act

Widget Main Title

G) Traffic Light Widget Configuration Widget Main Title

Weekly Sales

Light #1 Value

23

Light #2 Value

84

Light #3 Value

72

vs T Yel

Gr

Light #4 Value

24

H) Pie Widget Configuration Data Widget Main Title

Daily Widget Production

Slice #1 Value

Blue Widgets

Slice #2 Value

Red Widgets

Slice #3 Value

Green Widgets

I) Trend Widget Configuration Data Widget Main Title


Note: The data for this widget can be found in th Widget Showcase Calcs page.

J) Up/Down Widget Configuration Dat Widget Main Title

Monthly Salary Expenditur

Widget Value

500,311

Previous Value

505,209

Widget Percent

-1.0%

K) Percent Change Widget Configurati Widget Main Title

Daily Visitors

Widget Sub-Title

UNIQUE VISITORS

Widget Value

925

Previous Value

896

L) Funnel Widget Configuration Data Ages 0-20

Male

17

Female

24

20-30

41

40

30-40

32

39

40-50

32

31

50-60

15

16

60-70

15

17

M) Dots Widget Configuration Data Widget Main Title

Staff Retention

Percentage #1

79.6%

Percentage #2

82.7%

Percentage #3

84.6%

N) World Map Widget ad

Select a Destination Brussels

Brussels

O) Gender Breakdown Widget Configu Widget Main Title

Workforce Breakdown

Female Value

62%

Previous Value

43%

Male Value

38%

Previous Value

57%

P) Female Percentage Widget Configu Widget Main Title

Female Percentage

Female Value

62%

Previous Value

43%

Q) Male Percentage Widget Configura Widget Main Title

Male Percentage

Male Value

38%

Previous Value

57%

R) Radar Widget Configuration Data Main Title

Competency Matrix Leadership Skills Listening Skills Decision Making Negotiation Skills Personal Drive Adaptability Vision

Sensitivity

s with random data! LIGHT COLOR SCHEM

ta

Daily Widget Dem

40.0

60.0

20.0

80.0

0.0

10


ration Data

Daily Widget Dem

100

95 x 1,000,000 Widgets / Day

ration Data

Daily Widget Dem

8%


Sales YTD (Ta $7.3m)

Data

7.3m)

2.8

2.8 5.5 ax

5.5

0.8

0.0

7.3

7.

x millions USD$

Data 100.0% 90.0% 80.0% 70.0% 60.0% 50.0%

Daily Wi

40.0% 30.0% 20.0% 10.0% 0.0%

Sales Volum (Target vs Actu

7.3m) ax

1000

ual

300

ual

773

1000

0

ual

790

ual

865

ata

x millions USD$

Weekly Sales Targets

rgets low to Red Value

90 en to Yellow Value

NY

CA

FL

70

Daily Widget Production 4397

Blu 4,39

3295

Red 3,29

7605

Gre 7,60

Daily Widget Production 18.00 16.00 14.00 12.00 10.00 8.00 6.00 4.00 2.00 0.00 Jan 02

Jan 12

Jan 22

Feb 01

Feb 11

Monthly Salar Expenditure

on Data Daily Visitors UNIQUE VISITORS

92 +3%

Workforce / Age Breakdow 60-70

50-60 40-50 30-40 20-30 0-20 50

40

30

20

Male

10

0

10

20

Fem

Staff Retenti lllll lllll llllll lllll lllll lllll l lllll lllll l lllll lllll l lllll lllll l lllll lllll l lllll lllll l lllll lllll l lllll lllll l

ration Data Workforce Breakd

FEMALE

62% +19%

ration Data

Female Percenta

62 +19

ion Data Male Percentag

38 -19

Competency Ma alue

6

alue

5

alue

5

alue

8

alue

9

alue

4

alue

10

Sensitivity

Leadersh Skills

10 6 Li 5 10 5 Adaptability 4 9 8 Vision

Personal Drive Negotiati Skills

alue

10

© www.ExcelDashboardWidgets.com DARK COLOR SCHEME

nd

Daily Widget Deman

40.0

60.0

20.0

.0

80.0

0.0

100.0


nd

Daily Widget Deman

95%

9 100

95 x 1,000,000 Widgets / Day

nd

Daily Widget Deman

8%


rget:

Sales YTD (Tar $7.3m)

2.8 5.5

0.8

.3

0.0

7.3

x millions USD$

get

100.0% 90.0% 80.0% 70.0%

60.0% 50.0%

Daily Widg

40.0% 30.0% 20.0%

10.0% 0.0%

Sales Volume (Target vs Actual

al)

Q1 1000

0

Q2

Q3

1000

0

869

300

741

773

804

790

x millions USD$

vs

Weekly Sales Targets

TX

NY

CA

FL

81

Daily Widget Production Widgets (28.7%)

Blue Wi 4,397 (2

Widgets (21.5%)

Red Wi 3,295 (2

n Widgets (49.7%)

Green 7,605 (4

Daily Widget Production 18.00 16.00 14.00 12.00 10.00 8.00 6.00 4.00 2.00 eb 21

Mar 02

0.00 Jan 02

Jan 12

Jan 22

Feb 01

Feb 11

Feb

Monthly Salary Expenditure

Daily Visitors UNIQUE VISITORS

925 +3%

Sex n

Workforce / Age Breakdown 60-70

50-60 40-50 30-40 20-30 0-20 0

40

50

50

40

30

le

10

0

10

Male

20

30

Female

Staff Retention

n llll l lll llll llll llll llll llll llll llll llll

20

2009

2010

2

79.6%

82.7%

8

lllll lllll ll lllll l llllll lllll lllll ll lllll lllll ll lllll lllll ll lllll lllll ll lllll lllll ll lllll lllll ll lllll lllll ll lllll lllll ll

own

MALE

38% -19%

FEMALE

62% +19%

ge

62 +19%

e

38 -19%

rix ip

tening Skills

Decision Making n

Sensitivity

Leadership Skills

10 6 Listen 5 10 5 DeM Adaptability 4 9 8 Vision

Personal Drive Negotiation Skills

d

%

d

et:

et

4 1000

865

vs

TX

0

dgets 8.7%)

gets 1.5%) idgets 9.7%)

1

Mar 02

Sex

40

50

11

lll lll ll ll ll ll ll ll ll ll

4.6%

MALE

8% 19%

ing Skills

cision aking

Widgets Showcase Dashboard Calculations Page Copy each of these blocks of code as many times as you need for each of your new widgets…

A) Linear Dial Widget Min Max Actual Scale1 Scale2 Scale3 Scale4

Value 0.0 100.0 15.1 20.0 40.0 60.0 80.0

Degs 0.0 180.0 27.2

x 5.5 50.9 49.1 5.5 50.0

y 22.9 1.8 -1.8 22.9 0.0

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link dial widget objects to blue cells following this example.

B) Circular Dial Widget Type #1 Actual Max Percent

Value 95 100 95%

x 95.0

y 5.0


C) Circular Dial Widget Type #2 Actual Max Percent

Value 5 60 8%

x 5.0

y 55.0


D) Non-Linear Dial Widget

Min Max Actual Scale1 Scale2

Value 0.000 7.300 4.72 0.782 2.805

Degs 0.0 180.0 116.4

Which Quarter? 3 New Angle 122.0

x 76.5 51.7 48.3 76.5 50.0

y 42.4 -1.1 1.1 42.4 0.0

Scale3

5.500


E) Thermometer Widget

Min Max Actual Scale1 Scale2 Scale3 Scale4

Value 0.0 1.0 1.0 0.2 0.4 0.6 0.8

x 0.0

y 97.0%

97%



Step #1: Link yellow cells to "My Configuration Page" Step #2: Link thermometer widget to blue cells following this example.

F) Equalizer Widget

Min Max Q1 Target Q1 Actual Q2 Target Q2 Actual Q3 Target Q3 Actual Q4 Target Q4 Actual

Value 0 1000 869 300 741 773 804 790 813 865

12 4 10 11 11 11 11 12

Green 10 4 10 10 10 10 10 10

Yellow 2 0 0 1 1 1 1 2

Red 0 0 0 0 0 0 0 0

Green |||||||||| |||| |||||||||| |||||||||| |||||||||| |||||||||| |||||||||| ||||||||||

Yellow ||

| | | | ||

Step #1:Link the yellow cells to your "My Configuration Page" cells Step #2: Link text boxes in Equalizer Widget to blue cells following the Widgets Showcase example.

G) Traffic Light Widget Value #1 23

Value #2 84

Ranges 90 70

Yellow to Red Green to Yellow

Ranges 90 70


l

l

Red

Value #3 72

Ranges 90 70


Value #4 24

Ranges 90 70


l

l

1) Link yellow cells to your "My Configuration Page" cells 2) Link the text boxes on Traffic Light Widget to blue cells.

H) Pie Widget Titles Values Values2 Percents Labels

Blue Widg Red Widge Green Wid 4,397 3,295 7,605 4,397 3,295 7,605 28.7 21.5 49.7 4,397 (28.73,295 (21.57,605 (49.7

1) Link yellow cells to "My Configuration Page" 2) Link the Pie Widget to blue cells.

I) Trend Widget

1/1/12 4.00

2/1/12 4.42

3/1/12 4.89

4/1/12 5.24

5/1/12 5.92

6/1/12 5.78

1/10/14 4.00

6/10/14 30.00

13/10/14 30.00

20/10/14 40.00

27/10/14 60.00

3/11/14 56.00

Date Value Date inarias Instaladas

7/1/12 6.13

8/1/12 6.39

10/11/14 17/11/14 43.00 58.00

Step #1: Enter your trend data here as a date and value.. Step #2: Link the XY Graph on the Trend Widget to the cells following the Widgets Showcase example.

J) Up/Down Widget Value

500,311

Previous Value

505,209

Up / Down Symbol

500,311

q

Step #1: Link the yellow cells to your "My Configuration Page" cells

$ 500,311

Step #2: Link the text boxes in your Up / Down Widget to the blue cells.

K) Percent Change Widget Value

925

Previous Value

896

Difference

29

Label Value

+3%

Bar Chart

Up Down

#N/A 1

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link your text boxes in your Dashboard Widget to the blue cells.

L) Funnel Widget Ages 0-20 20-30 30-40 40-50 50-60 60-70

Total 41 81 71 63 31 32 320

Male 17 41 32 32 15 15 152

Female 24 40 39 31 16 17 168

Ages 0-20 20-30 30-40 40-50 50-60 60-70

Male -17 -41 -32 -32 -15 -15

Female 24 40 39 31 16 17

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link the Funnel Widget to the blue cells following the Widgets Showcase example.

M) Dots Widget Actual1 79.6% 0 5 0 5 5 0 5 0 5 0 5 0 5 0 5 0 5 0 5 0

Block 1 Type 'A' Type 'B' lllll lllll lllll lllll lllll lllll lllll lllll lllll lllll

Actual2 0 1 5 5 5 5 5 5 5 5

82.7% 5 4 0 0 0 0 0 0 0 0

Block 2 Type 'A' Type 'B' lllll l lllll lllll lllll lllll lllll lllll lllll lllll

llll

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link your text boxes in your Dashboard Widget to the blue cells following the Widgets Showcase ex

N) Map Widget Selection Brussels Dot 8.6 Circle 8.6 Temp Text 15°C / 59°F Up/Down q

60.8 60.8

Map Locations and Temperatures Database

Amsterdam Athens Bangkok Beijing Berlin Brasilia Brussels Buenos Aire Cairo Canberra Cape Town Copenhagen Dublin Islamabad Jakarta Jerusalem Kampala Kathmandu Khartoum Kinshasa Kuala Lumpu Lima Lisbon London Lusaka Madrid Mexico City Minsk Moscow Nairobi New Delhi

x 8 26 118.1 116 13 -47 8.6 -48.5 35.8 149 22.6 12 -1.8 76.4 117.8 41.6 37.3 96 32 22.9 119.9 -76.2 -1.8 4.1 34.3 1.7 -100 27 39.9 44.3 85.2

y 62 48 13 47.6 58.7 -15 60.8 -43.5 36.5 -48 -37 66.6 67.2 40.7 -6 38.9 0 41 15 -4 0 -12 51.8 64.3 -15 51.5 32.2 58.4 68 -1 41.6

Temp C 7 22 31 22 14 21 15 25 27 28 23 17 13 23 27 28 24 18 29 28 27 24 24 14 27 22 26 16 17 27 28

Temp F 45 72 88 72 58 70 59 77 81 83 74 63 56 74 81 83 76 65 85 83 81 76 76 58 81 72 79 61 63 81 83

Up/Down p p p p q q q p p q q q p p p p p q q q q q p q p q p p p q q

Oslo Ottawa Paris Prague Rome Santiago Santo Domin Seoul Singapore Tehran Tokyo Washington, Wellington

15.8 -62 8 14 21.5 -67.1 -76.7 128.3 115.8 54.9 136.1 -67.4 162.1

72.3 62 59 60.9 52.7 -35.3 29.6 49.3 4.6 35 49.3 53.8 -58.8

11 15 19 18 26 28 25 23 25 28 24 17 24

52 59 67 65 79 83 77 74 77 83 76 63 76

q p p q q q q p p p q p q

O) Gender Breakdown Widget Calculations

FEMALE

MALE

Value

62%

Value

38%

Previous Value

43%

Previous Value

57%

Difference %

19

Difference %

-19

Label Value

+19%

Label Value

-19%

#N/A 1

Bar Chart

Bar Chart

Up Down

Up Down

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link gender widget objects to blue cells following this example.

P) Female Percentage Breakdown Widget Calculations Value

62%

Previous Value

43%

Difference %

19

Main Value

62%

% Change Value

+19%

Bar Chart

Up

#N/A

1 #N/A

Down

1

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link text boxes and charts in Female % Widget to the blue cells.

Q) Male Percentage Breakdown Widget Calculations Value

38%

Previous Value

57%

Difference %

-19

Main Value

38%

% Change Value

-19%

Bar Chart

1 #N/A

Up Down

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link text boxes and charts in Male % Widget to the blue cells.

R) Radar Widget Calculations

Leadership Skills Listening Skills Decision Making Negotiation Skills Personal Drive Adaptability Vision Sensitivity

Item 1 2 3 4 5 6 7 8

Value 6 5 5 8 9 4 10 10

1 2 3 4 5 6 7 8 9 10

Step #1: Link the yellow cells to your "My Configuration Page" cells Step #2: Link text boxes and charts in Radar Widget to the blue cells.

1 10 10 10 10 10 0 0 0 0 0

1 0 0 0 0 0 10 10 10 10 10

2 10 10 10 10 10 0 0 0 0 0

9/1/12 7.02

10/1/12 6.90

11/1/12 7.51

12/1/12 7.75

13/1/12 8.01

14/1/12 8.23

15/1/12 8.84

24/11/14 55.00

1/12/14 44.00

8/12/14 40.00

15/12/14 22/12/14 29/12/14 52.00 51.00 56.00

9/1/15 10.00

16/1/12 8.88

17/1/12 8.83

Actual3 0 2 5 5 5 5 5 5 5 5

84.6% 5 3 0 0 0 0 0 0 0 0

Block 3 Type 'A' Type 'B' lllll ll lllll lllll lllll lllll lllll lllll lllll lllll

lll

mple.

2 0 0 0 0 0 10 10 10 10 10

3 10 10 10 10 0 0 0 0 0 0

3 0 0 0 0 10 10 10 10 10 10

4 10 10 10 10 10 10 10 0 0 0

4 0 0 0 0 0 0 0 10 10 10

5 10 10 10 10 10 10 10 10 0 0

5 0 0 0 0 0 0 0 0 10 10

6 10 10 10 10 0 0 0 0 0 0

6 0 0 0 0 10 10 10 10 10 10

18/1/12 9.03

19/1/12 8.98

20/1/12 8.98

21/1/12 9.08

22/1/12 8.79

23/1/12 9.00

24/1/12 9.36

25/1/12 9.27

7 10 10 10 10 10 10 10 10 10 0

7 0 0 0 0 0 0 0 0 0 10

8 10 10 10 10 10 10 10 10 10 0

8 0 0 0 0 0 0 0 0 0 10

26/1/12 9.08

27/1/12 9.45

28/1/12 9.93

29/1/12 10.56

30/1/12 10.42

31/1/12 10.90

1/2/12 11.16

2/2/12 10.92

3/2/12 11.46

4/2/12 11.47

5/2/12 12.01

6/2/12 11.77

7/2/12 12.13

8/2/12 12.18

9/2/12 12.13

10/2/12 12.03

11/2/12 12.17

12/2/12 12.12

13/2/12 12.55

14/2/12 12.77

15/2/12 13.35

16/2/12 13.39

17/2/12 14.06

18/2/12 13.89

19/2/12 13.91

20/2/12 13.83

21/2/12 14.35

22/2/12 14.39

23/2/12 14.92

24/2/12 15.15

25/2/12 15.33

26/2/12 15.04

27/2/12 14.87

28/2/12 14.62

29/2/12 14.63

1/3/12 15.09

2/3/12 15.45

3/3/12 15.20

4/3/12 15.67

Executive Dashboard

July 15th 2011

Northern Region Daily Widget Demand


100.0% 90.0% 80.0%


70.0% 60.0% 50.0% 40.0% 4.0

20.0

6.0

2.0

30.0

10.0

8.0

30.0% 40.0

20.0% 10.0% 0.0%

0.0

10.0

0.0


50.0


Southern Region Daily Widget Demand

Daily Widget Demand

100.0% 90.0% 80.0%

Daily Widget Demand

70.0% 60.0% 50.0% 40.0% 4.0

6.0

2.0

20.0

30.0

10.0

8.0

30.0% 40.0

20.0% 10.0% 0.0%

0.0

10.0

0.0


50.0


Eastern Region Daily Widget Demand

Daily Widget Demand

100.0% 90.0% 80.0%

Daily Widget Demand

70.0% 60.0% 50.0% 40.0% 4.0

6.0

2.0

20.0 8.0

30.0

10.0

30.0% 40.0

20.0% 10.0% 0.0%

0.0

10.0

0.0


50.0


Western Region Daily Widget Demand

Daily Widget Demand

100.0% 90.0% 80.0% 70.0% 60.0% 50.0% 40.0%

4.0 2.0

6.0

20.0 8.0

10.0

30.0

30.0% 20.0% 40.0

10.0% 0.0%

0.0

10.0


0.0

50.0


Daily Widget Demand

1st Dashboard Dial Configuration

2nd Dashboard Dial Configuration

1st Dashboard Themometer Configuration

Dial Main Title

Daily Widget Demand

Dial Main Title


Dial Main Title


Dial Units


Dial Units


Dial Units


Actual Value

9.0

Actual Value

Minimum Value

0.0

Minimum Value

22.0 0.0

Actual Value Minimum Value

86.0% 0.0

Maximum Value

10.0

Maximum Value

50.0

Maximum Value

100.0

3rd Dashboard Dial Configuration

4th Dashboard Dial Configuration

2nd Dashboard Themometer Configuration

Dial Main Title

Daily Widget Demand

Dial Main Title


Dial Main Title


Dial Units


Dial Units


Dial Units


Actual Value

8.0

Actual Value

Minimum Value

0.0

Minimum Value

34.0 0.0

Actual Value Minimum Value

74.5% 0.0

Maximum Value

10.0

Maximum Value

50.0

Maximum Value

100.0



3rd Dashboard Themometer Configuration

Dial Main Title

Daily Widget Demand

Dial Main Title


Dial Main Title


Dial Units


Dial Units


Dial Units


Actual Value

7.7

Actual Value

7.8

Actual Value

78.8%

Minimum Value

0.0

Minimum Value

0.0

Minimum Value

0.0

Maximum Value

10.0

Maximum Value

50.0

Maximum Value

100.0



4th Dashboard Themometer Configuration

Microsoft Excel Dashboard Calculations Page 1st Dial Calculations Min Max Actual Scale1 Scale2 Scale3 Scale4

Value 0.0 10.0 2.7 2.0 4.0 6.0 8.0

2nd Dial Calculations Degs 0.0 180.0 48.2

x 16.7 51.5 48.5 16.7 50.0

y 37.3 1.3 -1.3 37.3 0.0

3rd Dial Calculations Min Max Actual Scale1 Scale2

Value 0.0 10.0 5.2 2.0 40


Value 0.0 50.0 20.6 10.0 20.0 30.0 40.0

Degs 0.0 180.0 74.0

4th Dial Calculations Degs 0.0 180.0 93.4

x 53.0 52.0 48.0 53.0 50 0

y 49.9 -0.1 0.1 49.9 00

Min Max Actual Scale1 Scale2

Value 0.0 50.0 9.1 10.0 20 0

Degs 0.0 180.0 32.7

Microsoft Excel Dashboard Calculations Page 1st Dial Calculations Min Max Actual Scale1 Scale2 Scale3 Scale4

Value 0.0 10.0 2.7 2.0 4.0 6.0 8.0

2nd Dial Calculations Degs 0.0 180.0 48.2

x 16.7 51.5 48.5 16.7 50.0

y 37.3 1.3 -1.3 37.3 0.0

3rd Dial Calculations Min Max Actual Scale1 Scale2 Scale3 Scale4

Value 0.0 10.0 5.2 2.0 4.0 6.0 8.0


Degs 0.0 180.0 93.4

x 53.0 52.0 48.0 53.0 50.0

y 49.9 -0.1 0.1 49.9 0.0

Value 0.0 10.0 8.2 2.0 4.0 6.0 8.0

Degs 0.0 180.0 74.0


Value 0.0 50.0 9.1 10.0 20.0 30.0 40.0

Degs 0.0 180.0 32.7


x 3.1 50.7 49.3 3.1 50.0

y 17.4 1.9 -1.9 17.4 0.0

7th Dial Calculations Min Max Actual Scale1 Scale2 Scale3 Scale4

Value 0.0 50.0 20.6 10.0 20.0 30.0 40.0

4th Dial Calculations

5th Dial Calculations Value 0.0 10.0 1.1 2.0 4.0 6.0 8.0



Value 0.0 50.0 26.4 10.0 20.0 30.0 40.0

Degs 0.0 180.0 94.9


x 92.6 51.0 49.0 92.6 50.0

y 26.2 -1.7 1.7 26.2 0.0


Value 0.0 50.0 18.4 10.0 20.0 30.0 40.0

Degs 0.0 180.0 66.4

Key Code Calculations Enter Registered Email Address Here… Name: KeyCode: 0 AuthCode: 27F83EB AltCode: 17CB1FD Correct? 0 Multiplier: 12345

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

E n t e r R e g i s t e r e d E m a i l A d d r e s s H e r e …

851805 1357950 1432020 1246845 1407330 395040 1012290 1246845 1271535 1296225 1419675 1432020 1246845 1407330 1246845 1234500 395040 851805 1345605 1197465 1296225 1333260 395040 802425 1234500 1234500 1407330 1246845 1419675 1419675 395040 888840 1246845 1407330 1246845 1641885

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 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96

97 98 99 100

1st Thermometer Calculations x 36.2 51.9 48.1 36.2 50.0

y 48.1 0.6 -0.6 48.1 0.0


Value 0.0 0.0 0.6 0.0 0.0 0.0 0.0

x 0.0

y 19.9%

20%



2nd Thermometer Calculations x 7.9 51.1 48.9 7.9 50.0

y 27.0 1.7 -1.7 27.0 0.0


Value 0.0 100.0 0.7 0.0 0.0 0.0 0.0

x 0.0

y 16.8%

17%



3rd Thermometer Calculations x 54.3 52.0 48.0 54.3 50.0

y 49.8 -0.2 0.2 49.8 0.0


Value 0.0 100.0 0.8 0.0 0.0 0.0 0.0

x 0.0

y 93.6%

94%



4th Thermometer Calculations x 30.0 51.8 48.2 30.0 50.0

y 45.8 0.8 -0.8 45.8 0.0


Value 0.0 100.0 1.0 0.0 0.0 0.0 0.0

x 0.0

y 91.1% 

91%

How to Design an Excel Based Dashboard Using the Dashboard Widget We recommend that before you jump straight into designing your dashboard in Excel you t you want to show and how you want to show it. The following steps should help you prepar 1. Make a list of the key metrics you want to show on your dashboard. Remember the key simplicity’. Try where possible to group the metrics into thematic areas. For example a Hu following metrics..

Recruitment Metrics

Workforce Metrics

2. Decide the most meaningful increment of time each of the dashboard metrics will displa quarterly or annually). You may want to design your dashboard to give you an instantaneo want to update your dashboard once a month for the monthly management meeting. You same metric over different time increments (for example the current number of open positi

3. Decide which dashboard widgets you want to use to display each of your metrics. The f know if you would like us to design more). Try to stick to three or four styles per dashboard - Linear Dial Widget - Non-Linear Dial Widget - Thermometer Widget - Equalizer Widget - Traffic Light Widget - Pie Widget - Trend Widget - Up/Down Widget - Funnel Widget - Dots Widget 4. Choose a layout for you widgets. Generally it is good practice that a dashboard should fi sheet of paper (either landscape, portrait). Users should not have to scroll, turn pages, drill information. The following are example layouts that fit onto a single A4 sheet of paper.

5. Sketch your dashboard out on paper. It is significantly easier to first design a dashboard

5. Now it’s time to create your dashboard in Excel. Open up a new Excel Dashboard Widg follows.. Tab #1 – rename as ‘My Dashboard’ Tab #2 – rename as ‘My Configuration Page’ Tab #3 – rename as ‘My Calculations Page’

6. Copy and paste the widgets you want to use from the Excel Dashboard Widgets ‘Widget them into your required dashboard layout. It is good practice to group the widgets into the on the upper left hand side. Use the cell lines to help you line the widgets up neatly. 7. Copy and paste the configuration tables from the ‘Widgets Showcase’ onto Tab #2 and dashboard layout. 8. Copy and paste the relevant widget calculations tables from the ‘Widget Showcase Calc 9. Now comes the difficult part – you need to link these three tabs together in exactly the s the ‘Widgets Showcase’. More information on duplicating widgets can be found here.. http://www.exceldashboardwidgets.com/phpBB3/viewtopic.php?f=7&t=65

10. You may like to configure your own color scheme. More information on duplicating wid http://www.exceldashboardwidgets.com/phpBB3/viewtopic.php?f=7&t=67

If any of this doesn’t make sense – post a message in the forum and we would be delighte

Grab a coffee, take a deep breath and good luck with your dashboard. DashboardWidgets

Spreadsheet ake a bit of time thinking about what information e your Excel dashboard… dashboarding principle of ‘eloquence through an Resources dashboard might show the

Retention Metrics

(current, hourly, daily, weekly, monthly s snapshot of the current situation. You may ay even decide to display and compare the ns compared to the trend over the last year).

llowing widgets are available (feel free to let us .

t on a single landscape screen or single printed -down or recalculate to find the necessary

on paper than to build it straight in Excel.

ts spreadsheet and set up three new tabs as

s Showcase’ Tab onto Tab #1 and arrange atic areas and put the most important metrics

rrange them in a similar layout to the

s’ tab into Tab #3. me way as the widgets are linked together on

ets can be found here..

d to help you with your dashboard project.

HOW TO CUSTOMIZE THE STYLE AND COLORS OF THE WIDGETS The shapes used to make up the dashboard widgets can be easily customized using the standard Excel co Here is an step-by-step guide of how to reverse the colors and customize the colored markers used in the di Step #1 Right-click the curved edge of the dashboard widget you want to customize and select ‘group’ followed by ‘u

You should now see lots of small boxes showing the sub-components that make up the widget.

Step #2 Here comes the tricky part – the components are arranged as layers on top of each other (the circle is on

top of the dial needle, which is on top of the colored dial markers, which are on top of the backgrounds). To edit the colored dial markers we need to move the needle one layer backwards. To do this, click the needle once then right-click the rectangular edge and choose ‘send to back’ followed by ‘send backward’.

Step #3 Now you'll find that the five colored dial markers are grouped together so we’ll need to ungroup them to change their colors. To do this right-click on the group and choose ‘group’ followed by ‘ungroup’. You

should now see five small boxes representing the sub-components of the colored scale.

Step #4 normal Excel suite of customization options including fill colors, transparencies, reflections, gradients, 3d bevels, etc. etc.

, using RGB numbers) but to use the format painter to copy the formats from one dial to another dial. To do this, ungroup the components in two separate widgets that are side-by-side (following the steps 1-3 above). Next, select one of the scale marker blocks with the desired color. Then click the ‘format painter’ (in the ‘home’ section of the top ribbon). You’ll notice the mouse arrow has changed into a small paintbrush. Then

paint this format onto the target dial marker. You should end up with something like this with the second

Step #5 You now finally need to reverse steps 1-4 to tidy up your work... 5a) Right-click on one of the colored markers and select ‘group’ followed by ‘group’ in the second menu - to

group the markers together into a single component. 5b) Send the markers back one layer (to bring the dial needle forward) by right-clicking and selecting ‘send to back’ followed by ‘send backwards’.

5c) Finally right-click the curved edge of the dashboard widget and re-group all of the sub-components into a single component (this makes it easier to move the dial around as a single widget). I hope this makes sense and as always, please feel free to ask for clarification on our website forum if you n Good luck with your Excel Dashboard project. ExcelDashboard Widgets UPDATE - THERE IS A CLEARER TUTORIAL EXPLAINING HOW TO CHANGE COLOURS ON OUR YO https://www.youtube.com/watch?v=7JA9VMOl3UQ

mands for Excel shapes. als..

ngroup’.

Excel Dashboard Widgets

Recommend Documents