tablas programacion.xlsx

29
SEMANA 1 OPERARIO OFICIAL PEON OPER. MAQ. TOPO 0 0 88.3907866 0 265.437798 TOTAL 0 0 88.3907866 0 265.437798 DATOS POR MES MES 1 OPERARIO OFICIAL PEON OPER. MAQ. TOPO TOTAL 968.200356 62.0444956 7593.12553 0 1292.17388 OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO 0 50 100 150 200 250 300 SEMANA 1 Axis Title 4000 5000 6000 7000 8000 MES 1

Transcript of tablas programacion.xlsx

Page 1: tablas programacion.xlsx

SEMANA 1 SEMANA2OPERARIO OFICIAL PEON OPER. MAQ. LTOPO

0 0 88.3907866 0 265.437798TOTAL 0 0 88.3907866 0 265.437798 TOTAL

DATOS POR MESMES 1 MES 2

OPERARIO OFICIAL PEON OPER. MAQ. LTOPOTOTAL 968.200356 62.0444956 7593.12553 0 1292.17388 TOTAL

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA 1

0 0 88.3907866071429

0 265.437797619048

25

75

125

175

225

275

SEMANA 1

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA2

0 0 88.3907866071429

0 265.437797619048

25

75

125

175

225

275

SEMANA2

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 1 968.200356369012

62.0444956140351

7593.12552792069

0 1292.17387704335

5001500250035004500550065007500

MES 1

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 2 2994.10973954137

1640.57760854862

8826.41926321052

0 0

500150025003500450055006500750085009500

MES 2

Axis Title

Page 2: tablas programacion.xlsx

GRAFICO GENERAL POR SEMANAS

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 1 968.200356369012

62.0444956140351

7593.12552792069

0 1292.17387704335

5001500250035004500550065007500

MES 1

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 2 2994.10973954137

1640.57760854862

8826.41926321052

0 0

500150025003500450055006500750085009500

MES 2

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

502.

9942

8654

9212

31.0

2224

7807

0176

3675

.836

6049

4437

0

495.

8604

8418

6212

465.

2060

6981

9799

31.0

2224

7807

0176

3740

.507

3497

6204

0

265.

4377

9761

9048

404.

3903

7525

4687

42.4

5376

1170

6081

1441

.073

1084

467

0 0

912.

5911

4974

6659

557.

1999

5211

8545

2577

.031

5015

4808

0 0

881.

5689

0193

9641

526.

1777

0431

1527

2514

.987

0059

3405

0 0

795.

5593

1260

0387

514.

7461

9094

7937

2293

.327

6472

817

0 0710.

1655

6981

1975

514.

7461

9094

7937

2098

.786

3657

9774

0 0

355.

1656

5626

3633

192.

0189

9681

308

812.

1239

6096

687

0 0

1080

.077

5468

1946

900.

5576

5263

3458

2634

.269

1233

2592

203.

4005

4510

2644

0

979.

6199

0759

5141

949.

5421

3263

3458

2573

.597

6379

81

203.

4005

4510

2644

0

1128

.340

3075

9514

1096

.741

7326

3346

2864

.797

6379

81

203.

4005

4510

2644

0

890.

1669

3110

0753

855.

7382

5582

0378

2288

.740

6475

4176

203.

4005

4510

2644

0

785.

9878

9665

9396

796.

3940

2087

369 21

20.5

4069

8074

89

203.

4005

4510

2644

0

1453

.513

6688

7479

311.

2079

9392

2515

2052

.729

5036

5514

203.

4005

4510

2644

0

1395

.772

3033

1615

223.

3526

2886

9203

1881

.729

4531

2201

203.

4005

4510

2644

0

1304

.252

3033

1615

223.

3526

2886

9203

1840

.129

4531

2201

203.

4005

4510

2644

00 0 0 0 0

103.

0874

0740

7407

499.

9385

9002

849

2072

.373

8886

0399

0 0

GRAFICO DEL PERSONAL POR SEMANA

SEMANA 1 SEMANA2 SEMANA 3 SEMANA4 SEMANA5 SEMANA6 SEMANA7 SEMANA8 SEMANA9 SEMANA10SEMANA11 SEMANA12 SEMANA13 SEMANA14 SEMANA15 SEMANA16 SEMANA17 SEMANA18 SEMANA19 SEMANA20

Page 3: tablas programacion.xlsx

GRAFICO GENERAL POR MESES

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

502.

9942

8654

9212

31.0

2224

7807

0176

3675

.836

6049

4437

0

495.

8604

8418

6212

465.

2060

6981

9799

31.0

2224

7807

0176

3740

.507

3497

6204

0

265.

4377

9761

9048

404.

3903

7525

4687

42.4

5376

1170

6081

1441

.073

1084

467

0 0

912.

5911

4974

6659

557.

1999

5211

8545

2577

.031

5015

4808

0 0

881.

5689

0193

9641

526.

1777

0431

1527

2514

.987

0059

3405

0 0

795.

5593

1260

0387

514.

7461

9094

7937

2293

.327

6472

817

0 0710.

1655

6981

1975

514.

7461

9094

7937

2098

.786

3657

9774

0 0

355.

1656

5626

3633

192.

0189

9681

308

812.

1239

6096

687

0 0

1080

.077

5468

1946

900.

5576

5263

3458

2634

.269

1233

2592

203.

4005

4510

2644

0

979.

6199

0759

5141

949.

5421

3263

3458

2573

.597

6379

81

203.

4005

4510

2644

0

1128

.340

3075

9514

1096

.741

7326

3346

2864

.797

6379

81

203.

4005

4510

2644

0

890.

1669

3110

0753

855.

7382

5582

0378

2288

.740

6475

4176

203.

4005

4510

2644

0

785.

9878

9665

9396

796.

3940

2087

369 21

20.5

4069

8074

89

203.

4005

4510

2644

0

1453

.513

6688

7479

311.

2079

9392

2515

2052

.729

5036

5514

203.

4005

4510

2644

0

1395

.772

3033

1615

223.

3526

2886

9203

1881

.729

4531

2201

203.

4005

4510

2644

0

1304

.252

3033

1615

223.

3526

2886

9203

1840

.129

4531

2201

203.

4005

4510

2644

00 0 0 0 0

103.

0874

0740

7407

499.

9385

9002

849

2072

.373

8886

0399

0 0

GRAFICO DEL PERSONAL POR SEMANA

SEMANA 1 SEMANA2 SEMANA 3 SEMANA4 SEMANA5 SEMANA6 SEMANA7 SEMANA8 SEMANA9 SEMANA10SEMANA11 SEMANA12 SEMANA13 SEMANA14 SEMANA15 SEMANA16 SEMANA17 SEMANA18 SEMANA19 SEMANA20

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

968.

2003

5636

9012

62.0

4449

5614

0351

7593

.125

5279

2069

0

1292

.173

8770

4335

2994

.109

7395

4137

1640

.577

6085

4862

8826

.419

2632

1052

0 0

3125

.028

6804

9021

2556

.864

9730

2793

8118

.777

0880

7153

406.

8010

9020

5288

0

4258

.008

8042

3008

3060

.082

0032

5004

9326

.808

4872

5279

813.

6021

8041

0575

0

GRAFICO DEL PERSONAL POR MES

MES 1 MES 2 MES 3 MES 4

Page 4: tablas programacion.xlsx

SEMANA2 SEMANA 3OPERARIO OFICIAL PEON OPER. MAQ. LTOPO OPERARIO

0 0 88.3907866 0 265.437798 00 0 88.3907866 0 265.437798 31.0222478

38.5663.368383376.8075622235.21605850.7233136

7.296722TOTAL 502.994287

MES 2 MES 3OPERARIO OFICIAL PEON OPER. MAQ. LTOPO OPERARIO2994.10974 1640.57761 8826.41926 0 0 TOTAL 3125.02868

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA2

0 0 88.3907866071429

0 265.437797619048

25

75

125

175

225

275

SEMANA2

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA 3

502.994286549212

31.0222478070176

3675.83660494437

0 495.860484186212

250750

125017502250275032503750

SEMANA 3

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 2 2994.10973954137

1640.57760854862

8826.41926321052

0 0

500150025003500450055006500750085009500

MES 2

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 3 3125.02868049021

2556.86497302793

8118.77708807153

406.801090205288

0

50015002500350045005500650075008500

MES 3

Axis Title

Page 5: tablas programacion.xlsx

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 2 2994.10973954137

1640.57760854862

8826.41926321052

0 0

500150025003500450055006500750085009500

MES 2

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 3 3125.02868049021

2556.86497302793

8118.77708807153

406.801090205288

0

50015002500350045005500650075008500

MES 3

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

502.

9942

8654

9212

31.0

2224

7807

0176

3675

.836

6049

4437

0

495.

8604

8418

6212

465.

2060

6981

9799

31.0

2224

7807

0176

3740

.507

3497

6204

0

265.

4377

9761

9048

404.

3903

7525

4687

42.4

5376

1170

6081

1441

.073

1084

467

0 0

912.

5911

4974

6659

557.

1999

5211

8545

2577

.031

5015

4808

0 0

881.

5689

0193

9641

526.

1777

0431

1527

2514

.987

0059

3405

0 0

795.

5593

1260

0387

514.

7461

9094

7937

2293

.327

6472

817

0 0710.

1655

6981

1975

514.

7461

9094

7937

2098

.786

3657

9774

0 0

355.

1656

5626

3633

192.

0189

9681

308

812.

1239

6096

687

0 0

1080

.077

5468

1946

900.

5576

5263

3458

2634

.269

1233

2592

203.

4005

4510

2644

0

979.

6199

0759

5141

949.

5421

3263

3458

2573

.597

6379

81

203.

4005

4510

2644

0

1128

.340

3075

9514

1096

.741

7326

3346

2864

.797

6379

81

203.

4005

4510

2644

0

890.

1669

3110

0753

855.

7382

5582

0378

2288

.740

6475

4176

203.

4005

4510

2644

0

785.

9878

9665

9396

796.

3940

2087

369 21

20.5

4069

8074

89

203.

4005

4510

2644

0

1453

.513

6688

7479

311.

2079

9392

2515

2052

.729

5036

5514

203.

4005

4510

2644

0

1395

.772

3033

1615

223.

3526

2886

9203

1881

.729

4531

2201

203.

4005

4510

2644

0

1304

.252

3033

1615

223.

3526

2886

9203

1840

.129

4531

2201

203.

4005

4510

2644

00 0 0 0 0

103.

0874

0740

7407

499.

9385

9002

849

2072

.373

8886

0399

0 0

GRAFICO DEL PERSONAL POR SEMANA

SEMANA 1 SEMANA2 SEMANA 3 SEMANA4 SEMANA5 SEMANA6 SEMANA7 SEMANA8 SEMANA9 SEMANA10SEMANA11 SEMANA12 SEMANA13 SEMANA14 SEMANA15 SEMANA16 SEMANA17 SEMANA18 SEMANA19 SEMANA20

Page 6: tablas programacion.xlsx

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

502.

9942

8654

9212

31.0

2224

7807

0176

3675

.836

6049

4437

0

495.

8604

8418

6212

465.

2060

6981

9799

31.0

2224

7807

0176

3740

.507

3497

6204

0

265.

4377

9761

9048

404.

3903

7525

4687

42.4

5376

1170

6081

1441

.073

1084

467

0 0

912.

5911

4974

6659

557.

1999

5211

8545

2577

.031

5015

4808

0 0

881.

5689

0193

9641

526.

1777

0431

1527

2514

.987

0059

3405

0 0

795.

5593

1260

0387

514.

7461

9094

7937

2293

.327

6472

817

0 0710.

1655

6981

1975

514.

7461

9094

7937

2098

.786

3657

9774

0 0

355.

1656

5626

3633

192.

0189

9681

308

812.

1239

6096

687

0 0

1080

.077

5468

1946

900.

5576

5263

3458

2634

.269

1233

2592

203.

4005

4510

2644

0

979.

6199

0759

5141

949.

5421

3263

3458

2573

.597

6379

81

203.

4005

4510

2644

0

1128

.340

3075

9514

1096

.741

7326

3346

2864

.797

6379

81

203.

4005

4510

2644

0

890.

1669

3110

0753

855.

7382

5582

0378

2288

.740

6475

4176

203.

4005

4510

2644

0

785.

9878

9665

9396

796.

3940

2087

369 21

20.5

4069

8074

89

203.

4005

4510

2644

0

1453

.513

6688

7479

311.

2079

9392

2515

2052

.729

5036

5514

203.

4005

4510

2644

0

1395

.772

3033

1615

223.

3526

2886

9203

1881

.729

4531

2201

203.

4005

4510

2644

0

1304

.252

3033

1615

223.

3526

2886

9203

1840

.129

4531

2201

203.

4005

4510

2644

00 0 0 0 0

103.

0874

0740

7407

499.

9385

9002

849

2072

.373

8886

0399

0 0

GRAFICO DEL PERSONAL POR SEMANA

SEMANA 1 SEMANA2 SEMANA 3 SEMANA4 SEMANA5 SEMANA6 SEMANA7 SEMANA8 SEMANA9 SEMANA10SEMANA11 SEMANA12 SEMANA13 SEMANA14 SEMANA15 SEMANA16 SEMANA17 SEMANA18 SEMANA19 SEMANA20

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

968.

2003

5636

9012

62.0

4449

5614

0351

7593

.125

5279

2069

0

1292

.173

8770

4335

2994

.109

7395

4137

1640

.577

6085

4862

8826

.419

2632

1052

0 0

3125

.028

6804

9021

2556

.864

9730

2793

8118

.777

0880

7153

406.

8010

9020

5288

0

4258

.008

8042

3008

3060

.082

0032

5004

9326

.808

4872

5279

813.

6021

8041

0575

0

GRAFICO DEL PERSONAL POR MES

MES 1 MES 2 MES 3 MES 4

Page 7: tablas programacion.xlsx

SEMANA 3 SEMANA4OFICIAL PEON OPER. MAQ. LTOPO OPERARIO OFICIAL

0 88.3907866 0 265.437798 0 031.0222478 62.0444956 0 0 31.0222478 31.0222478

0 128.533333 0 0 39.0193455 00 241.403433 0 0 38.56 00 76.8075622 0 230.422687 63.3683833 00 2351.89599 0 0 235.216058 00 507.347292 0 0 50.7233136 00 219.413711 0 0 7.296722 0

31.0222478 3675.8366 0 495.860484 TOTAL 465.20607 31.0222478

MES 3 MES 4OFICIAL PEON OPER. MAQ. LTOPO OPERARIO OFICIAL2556.86497 8118.77709 406.80109 0 TOTAL 4258.0088 3060.082

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA 3

502.994286549212

31.0222478070176

3675.83660494437

0 495.860484186212

250750

125017502250275032503750

SEMANA 3

Axis TitleOPERARIO OFICIAL PEON OPER.

MAQ. LIV.TOPO

SEM-ANA4

465.206069819799

31.0222478070176

3740.50734976204

0 265.437797619048

250750

125017502250275032503750

SEMANA4

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 3 3125.02868049021

2556.86497302793

8118.77708807153

406.801090205288

0

50015002500350045005500650075008500

MES 3

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 4 4258.00880423008

3060.08200325004

9326.80848725279

813.602180410575

0

500150025003500450055006500750085009500

MES 4

Axis Title

Page 8: tablas programacion.xlsx

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 3 3125.02868049021

2556.86497302793

8118.77708807153

406.801090205288

0

50015002500350045005500650075008500

MES 3

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 4 4258.00880423008

3060.08200325004

9326.80848725279

813.602180410575

0

500150025003500450055006500750085009500

MES 4

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

502.

9942

8654

9212

31.0

2224

7807

0176

3675

.836

6049

4437

0

495.

8604

8418

6212

465.

2060

6981

9799

31.0

2224

7807

0176

3740

.507

3497

6204

0

265.

4377

9761

9048

404.

3903

7525

4687

42.4

5376

1170

6081

1441

.073

1084

467

0 0

912.

5911

4974

6659

557.

1999

5211

8545

2577

.031

5015

4808

0 0

881.

5689

0193

9641

526.

1777

0431

1527

2514

.987

0059

3405

0 0

795.

5593

1260

0387

514.

7461

9094

7937

2293

.327

6472

817

0 0710.

1655

6981

1975

514.

7461

9094

7937

2098

.786

3657

9774

0 0

355.

1656

5626

3633

192.

0189

9681

308

812.

1239

6096

687

0 0

1080

.077

5468

1946

900.

5576

5263

3458

2634

.269

1233

2592

203.

4005

4510

2644

0

979.

6199

0759

5141

949.

5421

3263

3458

2573

.597

6379

81

203.

4005

4510

2644

0

1128

.340

3075

9514

1096

.741

7326

3346

2864

.797

6379

81

203.

4005

4510

2644

0

890.

1669

3110

0753

855.

7382

5582

0378

2288

.740

6475

4176

203.

4005

4510

2644

0

785.

9878

9665

9396

796.

3940

2087

369 21

20.5

4069

8074

89

203.

4005

4510

2644

0

1453

.513

6688

7479

311.

2079

9392

2515

2052

.729

5036

5514

203.

4005

4510

2644

0

1395

.772

3033

1615

223.

3526

2886

9203

1881

.729

4531

2201

203.

4005

4510

2644

0

1304

.252

3033

1615

223.

3526

2886

9203

1840

.129

4531

2201

203.

4005

4510

2644

00 0 0 0 0

103.

0874

0740

7407

499.

9385

9002

849

2072

.373

8886

0399

0 0

GRAFICO DEL PERSONAL POR SEMANA

SEMANA 1 SEMANA2 SEMANA 3 SEMANA4 SEMANA5 SEMANA6 SEMANA7 SEMANA8 SEMANA9 SEMANA10SEMANA11 SEMANA12 SEMANA13 SEMANA14 SEMANA15 SEMANA16 SEMANA17 SEMANA18 SEMANA19 SEMANA20

Page 9: tablas programacion.xlsx

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

0 0

88.3

9078

6607

1429

0

265.

4377

9761

9048

502.

9942

8654

9212

31.0

2224

7807

0176

3675

.836

6049

4437

0

495.

8604

8418

6212

465.

2060

6981

9799

31.0

2224

7807

0176

3740

.507

3497

6204

0

265.

4377

9761

9048

404.

3903

7525

4687

42.4

5376

1170

6081

1441

.073

1084

467

0 0

912.

5911

4974

6659

557.

1999

5211

8545

2577

.031

5015

4808

0 0

881.

5689

0193

9641

526.

1777

0431

1527

2514

.987

0059

3405

0 0

795.

5593

1260

0387

514.

7461

9094

7937

2293

.327

6472

817

0 0710.

1655

6981

1975

514.

7461

9094

7937

2098

.786

3657

9774

0 0

355.

1656

5626

3633

192.

0189

9681

308

812.

1239

6096

687

0 0

1080

.077

5468

1946

900.

5576

5263

3458

2634

.269

1233

2592

203.

4005

4510

2644

0

979.

6199

0759

5141

949.

5421

3263

3458

2573

.597

6379

81

203.

4005

4510

2644

0

1128

.340

3075

9514

1096

.741

7326

3346

2864

.797

6379

81

203.

4005

4510

2644

0

890.

1669

3110

0753

855.

7382

5582

0378

2288

.740

6475

4176

203.

4005

4510

2644

0

785.

9878

9665

9396

796.

3940

2087

369 21

20.5

4069

8074

89

203.

4005

4510

2644

0

1453

.513

6688

7479

311.

2079

9392

2515

2052

.729

5036

5514

203.

4005

4510

2644

0

1395

.772

3033

1615

223.

3526

2886

9203

1881

.729

4531

2201

203.

4005

4510

2644

0

1304

.252

3033

1615

223.

3526

2886

9203

1840

.129

4531

2201

203.

4005

4510

2644

00 0 0 0 0

103.

0874

0740

7407

499.

9385

9002

849

2072

.373

8886

0399

0 0

GRAFICO DEL PERSONAL POR SEMANA

SEMANA 1 SEMANA2 SEMANA 3 SEMANA4 SEMANA5 SEMANA6 SEMANA7 SEMANA8 SEMANA9 SEMANA10SEMANA11 SEMANA12 SEMANA13 SEMANA14 SEMANA15 SEMANA16 SEMANA17 SEMANA18 SEMANA19 SEMANA20

OPERARIO OFICIAL PEON OPER. MAQ. LIV. TOPO

968.

2003

5636

9012

62.0

4449

5614

0351

7593

.125

5279

2069

0

1292

.173

8770

4335

2994

.109

7395

4137

1640

.577

6085

4862

8826

.419

2632

1052

0 0

3125

.028

6804

9021

2556

.864

9730

2793

8118

.777

0880

7153

406.

8010

9020

5288

0

4258

.008

8042

3008

3060

.082

0032

5004

9326

.808

4872

5279

813.

6021

8041

0575

0

GRAFICO DEL PERSONAL POR MES

MES 1 MES 2 MES 3 MES 4

Page 10: tablas programacion.xlsx

SEMANA4 SEMANA5PEON OPER. MAQ. LTOPO OPERARIO OFICIAL PEON88.3907866 0 265.437798 31.0222478 31.0222478 62.044495662.0444956 0 0 1.18257035 11.4315134 34.3733781141.478307 0 0 45.8076735 0 45.8076735128.533333 0 0 39.0193455 0 141.478307241.403433 0 0 127.410119 0 60.67148532351.89599 0 0 38.56 0 128.533333507.347292 0 0 63.3683833 0 241.403433219.413711 0 0 50.7233136 0 507.3472923740.50735 0 265.437798 7.296722 0 219.413711

TOTAL 404.390375 42.4537612 1441.07311

MES 4 MES 5PEON OPER. MAQ. LTOPO OPERARIO OFICIAL PEON9326.80849 813.60218 0 TOTAL 2803.11201 946.643848 5794.23279

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA4

465.206069819799

31.0222478070176

3740.50734976204

0 265.437797619048

250750

125017502250275032503750

SEMANA4

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA5

404.390375254687

42.4537611706081

1441.0731084467

0 0

100300500700900

110013001500

SEMANA5

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 4 4258.00880423008

3060.08200325004

9326.80848725279

813.602180410575

0

500150025003500450055006500750085009500

MES 4

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 5 2803.1120140397

946.643847766896

5794.23279484801

406.801090205288

0

500150025003500450055006500

MES 5

Axis Title

Page 11: tablas programacion.xlsx

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 4 4258.00880423008

3060.08200325004

9326.80848725279

813.602180410575

0

500150025003500450055006500750085009500

MES 4

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 5 2803.1120140397

946.643847766896

5794.23279484801

406.801090205288

0

500150025003500450055006500

MES 5

Axis Title

Page 12: tablas programacion.xlsx

SEMANA5 SEMANA6OPER. MAQ. LTOPO OPERARIO OFICIAL PEON OPER. MAQ. L

0 0 31.0222478 31.0222478 62.0444956 00 0 1.18257035 11.4315134 34.3733781 00 0 45.8076735 0 45.8076735 00 0 39.0193455 0 141.478307 00 0 127.410119 0 60.6714853 00 0 38.56 0 128.533333 00 0 63.3683833 0 241.403433 00 0 237.445111 215.859191 431.718383 00 0 117.554803 106.868003 854.944022 00 0 211.220896 192.018997 576.05699 0

TOTAL 912.59115 557.199952 2577.0315 0

MES 5OPER. MAQ. LTOPO

406.80109 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA5

404.390375254687

42.4537611706081

1441.0731084467

0 0

100300500700900

110013001500

SEMANA5

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA6

912.591149746659

557.199952118545

2577.03150154808

0 0

250

750

1250

1750

2250

2750

SEMANA6

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 5 2803.1120140397

946.643847766896

5794.23279484801

406.801090205288

0

500150025003500450055006500

MES 5

Axis Title

Page 13: tablas programacion.xlsx

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

MES 5 2803.1120140397

946.643847766896

5794.23279484801

406.801090205288

0

500150025003500450055006500

MES 5

Axis Title

Page 14: tablas programacion.xlsx

SEMANA6 SEMANA7TOPO OPERARIO OFICIAL PEON OPER. MAQ. LTOPO

0 1.18257035 11.4315134 34.3733781 0 00 45.8076735 0 45.8076735 0 00 39.0193455 0 141.478307 0 00 127.410119 0 60.6714853 0 00 38.56 0 128.533333 0 00 63.3683833 0 241.403433 0 00 237.445111 215.859191 431.718383 0 00 117.554803 106.868003 854.944022 0 00 211.220896 192.018997 576.05699 0 00 TOTAL 881.568902 526.177704 2514.98701 0 00

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA6

912.591149746659

557.199952118545

2577.03150154808

0 0

250

750

1250

1750

2250

2750

SEMANA6

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA7

881.568901939641

526.177704311527

2514.98700593405

0 0

250

750

1250

1750

2250

2750

SEMANA7

Axis Title

Page 15: tablas programacion.xlsx

SEMANA8OPERARIO OFICIAL PEON OPER. MAQ. LTOPO127.410119 0 60.6714853 0 0

38.56 0 128.533333 0 063.3683833 0 241.403433 0 0237.445111 215.859191 431.718383 0 0117.554803 106.868003 854.944022 0 0211.220896 192.018997 576.05699 0 0

TOTAL 795.559313 514.746191 2293.32765 0 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA7

881.568901939641

526.177704311527

2514.98700593405

0 0

250

750

1250

1750

2250

2750

SEMANA7

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA8

795.559312600387

514.746190947937

2293.3276472817

0 0

250

750

1250

1750

2250

SEMANA8

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA9

710.165569811975

514.746190947937

2098.78636579774

0 0

250

750

1250

1750

2250

SEMANA9

Axis Title

Page 16: tablas programacion.xlsx

SEMANA9 SEMANA10OPERARIO OFICIAL PEON OPER. MAQ. LTOPO127.410119 0 60.6714853 0 010.4342857 0 104.342857 0 05.09451429 0 50.9384571 0 01.00584054 0 20.1141709 0 0237.445111 215.859191 431.718383 0 0117.554803 106.868003 854.944022 0 0 TOTAL211.220896 192.018997 576.05699 0 0

TOTAL 710.16557 514.746191 2098.78637 0 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA9

710.165569811975

514.746190947937

2098.78636579774

0 0

250

750

1250

1750

2250

SEMANA9

Axis TitleOPERARIO OFICIAL PEON OPER.

MAQ. LIV.TOPO

SEM-ANA10

355.165656263633

192.01899681308

812.12396096687

0 0

50150250350450550650750850

SEMANA10

Axis Title

Page 17: tablas programacion.xlsx

SEMANA10 SEMANA11OPERARIO OFICIAL PEON OPER. MAQ. LTOPO OPERARIO127.410119 0 60.6714853 0 0 127.41011910.4342857 0 104.342857 0 0 277.9878645.09451429 0 50.9384571 0 0 89.12620571.00584054 0 20.1141709 0 0 20.0272153211.220896 192.018997 576.05699 0 0 16.7218481355.165656 192.018997 812.123961 0 0 10.4342857

5.094514291.00584054

13.2243.32011564.5286422211.220896

TOTAL 1080.07755

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA10

355.165656263633

192.01899681308

812.12396096687

0 0

50150250350450550650750850

SEMANA10

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA11

1080.07754681946

900.557652633458

2634.26912332592

203.400545102644

0

250

750

1250

1750

2250

2750

SEMANA11

Axis Title

Page 18: tablas programacion.xlsx

SEMANA11 SEMANA12OFICIAL PEON OPER. MAQ. LTOPO OPERARIO OFICIAL

0 60.6714853 0 0 277.987864 67.800181767.8001817 881.449825 203.400545 0 89.1262057 81.031557881.0315578 162.050961 0 0 20.0272153 0

0 18.2065594 0 0 16.7218481 00 15.2016801 0 0 10.4342857 00 104.342857 0 0 5.09451429 00 50.9384571 0 0 1.00584054 00 20.1141709 0 0 13.2 00 48 0 0 243.320115 442.382112

442.382112 110.612117 0 0 64.5286422 117.324804117.324804 586.62402 0 0 26.95248 48.98448192.018997 576.05699 0 0 211.220896 192.018997900.557653 2634.26912 203.400545 0 TOTAL 979.619908 949.542133

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA11

1080.07754681946

900.557652633458

2634.26912332592

203.400545102644

0

250

750

1250

1750

2250

2750

SEMANA11

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA12

979.619907595141

949.542132633458

2573.597637981

203.400545102644

0

250

750

1250

1750

2250

2750

SEMANA12

Axis Title

Page 19: tablas programacion.xlsx

SEMANA12 SEMANA13PEON OPER. MAQ. LTOPO OPERARIO OFICIAL PEON881.449825 203.400545 0 277.987864 67.8001817 881.449825162.050961 0 0 89.1262057 81.0315578 162.05096118.2065594 0 0 20.0272153 0 18.206559415.2016801 0 0 16.7218481 0 15.2016801104.342857 0 0 10.4342857 0 104.34285750.9384571 0 0 5.09451429 0 50.938457120.1141709 0 0 1.00584054 0 20.1141709

48 0 0 243.320115 442.382112 110.612117110.612117 0 0 64.5286422 117.324804 586.62402

586.62402 0 0 7.0404 6.3996 57.60 0 0 26.95248 48.98448 0

576.05699 0 0 154.88 140.8 281.62573.59764 203.400545 0 211.220896 192.018997 576.05699

TOTAL 1128.34031 1096.74173 2864.79764

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA12

979.619907595141

949.542132633458

2573.597637981

203.400545102644

0

250

750

1250

1750

2250

2750

SEMANA12

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA13

1128.34030759514

1096.74173263346

2864.797637981

203.400545102644

0

250750

12501750225027503250

SEMANA13

Axis Title

Page 20: tablas programacion.xlsx

SEMANA13 SEMANA14OPER. MAQ. LTOPO OPERARIO OFICIAL PEON OPER. MAQ. L203.400545 0 277.987864 67.8001817 881.449825 203.400545

0 0 89.1262057 81.0315578 162.050961 00 0 20.0272153 0 18.2065594 00 0 16.7218481 0 15.2016801 00 0 10.4342857 0 104.342857 00 0 5.09451429 0 50.9384571 00 0 1.00584054 0 20.1141709 00 0 243.320115 442.382112 110.612117 00 0 64.5286422 117.324804 586.62402 00 0 7.0404 6.3996 57.6 00 0 154.88 140.8 281.6 00 0 TOTAL 890.166931 855.738256 2288.74065 203.4005450 0

203.400545 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA13

1128.34030759514

1096.74173263346

2864.797637981

203.400545102644

0

250750

12501750225027503250

SEMANA13

Axis TitleOPERARIO OFICIAL PEON OPER.

MAQ. LIV.TOPO

SEM-ANA14

890.166931100753

855.738255820378

2288.74064754176

203.400545102644

0

250

750

1250

1750

2250

SEMANA14

Axis Title

Page 21: tablas programacion.xlsx

SEMANA14 SEMANA15TOPO OPERARIO OFICIAL PEON OPER. MAQ. LTOPO

0 277.987864 67.8001817 881.449825 203.400545 00 89.1262057 81.0315578 162.050961 0 00 20.0272153 0 18.2065594 0 00 16.7218481 0 15.2016801 0 00 10.4342857 0 104.342857 0 00 5.09451429 0 50.9384571 0 00 1.00584054 0 20.1141709 0 00 243.320115 442.382112 110.612117 0 00 64.5286422 117.324804 586.62402 0 00 18.8100056 17.1000051 171.000051 0 00 38.93136 70.75536 0 0 00 TOTAL 785.987897 796.394021 2120.5407 203.400545 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA14

890.166931100753

855.738255820378

2288.74064754176

203.400545102644

0

250

750

1250

1750

2250

SEMANA14

Axis TitleOPERARIO OFICIAL PEON OPER.

MAQ. LIV.TOPO

SEM-ANA15

785.987896659396

796.39402087369

2120.54069807489

203.400545102644

0

250

750

1250

1750

2250

SEMANA15

Axis Title

Page 22: tablas programacion.xlsx

SEMANA16OPERARIO OFICIAL PEON OPER. MAQ. LTOPO277.987864 67.8001817 881.449825 203.400545 089.1262057 81.0315578 162.050961 0 020.0272153 0 18.2065594 0 016.7218481 0 15.2016801 0 018.8100056 17.1000051 171.000051 0 0

38.93136 70.75536 0 0 0520.109333 0 236.413333 0 0

91.52 0 41.6 0 040.9868152 74.5208894 372.591406 0 0339.293021 0 154.215688 0 0

TOTAL 1453.51367 311.207994 2052.7295 203.400545 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA16

1453.51366887479

311.207993922515

2052.72950365514

203.400545102644

0

250

750

1250

1750

2250

SEMANA16

Axis TitleOPERARIO OFICIAL PEON OPER.

MAQ. LIV.TOPO

SEM-ANA17

1395.77230331615

223.352628869203

1881.72945312201

203.400545102644

0

100300500700900

11001300150017001900

SEMANA17

Axis Title

Page 23: tablas programacion.xlsx

SEMANA17 SEMANA18OPERARIO OFICIAL PEON OPER. MAQ. LTOPO277.987864 67.8001817 881.449825 203.400545 089.1262057 81.0315578 162.050961 0 020.0272153 0 18.2065594 0 016.7218481 0 15.2016801 0 0520.109333 0 236.413333 0 0

91.52 0 41.6 0 040.9868152 74.5208894 372.591406 0 0339.293021 0 154.215688 0 0 TOTAL

TOTAL 1395.7723 223.352629 1881.72945 203.400545 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA17

1395.77230331615

223.352628869203

1881.72945312201

203.400545102644

0

100300500700900

11001300150017001900

SEMANA17

Axis TitleOPERARIO OFICIAL PEON OPER.

MAQ. LIV.TOPO

SEM-ANA18

1304.25230331615

223.352628869203

1840.12945312201

203.400545102644

0

100300500700900

11001300150017001900

SEMANA18

Axis Title

Page 24: tablas programacion.xlsx

SEMANA18 SEMANA19OPERARIO OFICIAL PEON OPER. MAQ. LTOPO OPERARIO277.987864 67.8001817 881.449825 203.400545 089.1262057 81.0315578 162.050961 0 0 TOTAL 020.0272153 0 18.2065594 0 016.7218481 0 15.2016801 0 0520.109333 0 236.413333 0 040.9868152 74.5208894 372.591406 0 0339.293021 0 154.215688 0 0

1304.2523 223.352629 1840.12945 203.400545 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA18

1304.25230331615

223.352628869203

1840.12945312201

203.400545102644

0

100300500700900

11001300150017001900

SEMANA18

Axis Title

OPER-ARIO

OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEMANA19 0 0 0 0 0

0.050.150.250.350.450.550.650.750.850.95

SEMANA19

Axis Title

Page 25: tablas programacion.xlsx

SEMANA19 SEMANA20OFICIAL PEON OPER. MAQ. LTOPO OPERARIO OFICIAL

0 337.2643870 0 0 0 0 0 138.674203

2.2 00.8 24

100.087407 0TOTAL 103.087407 499.93859

OPER-ARIO

OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEMANA19 0 0 0 0 0

0.050.150.250.350.450.550.650.750.850.95

SEMANA19

Axis Title

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA20

103.087407407407

499.93859002849

2072.37388860399

0 0

250

750

1250

1750

2250

SEMANA20

Axis Title

Page 26: tablas programacion.xlsx

SEMANA20PEON OPER. MAQ. LTOPO919.811966 0 0126.187849 0 0

1.5 0 024 0 0

1000.87407 0 02072.37389 0 0

OPERARIO OFICIAL PEON OPER. MAQ. LIV.

TOPO

SEM-ANA20

103.087407407407

499.93859002849

2072.37388860399

0 0

250

750

1250

1750

2250

SEMANA20

Axis Title