Upload
lucarso
View
251
Download
0
Embed Size (px)
Citation preview
7/26/2019 Planilha controle PCs
1/56
HD - horas disponveis
HT - horas trabalhadas
HM - horas manuteno
HC - horas calendrio
D& - disponibilidade 'sica
D&()HD*HT+,)HD*HT*HM+
P CARR
TURNO DT H. /nicial H. &inal Total Hod.1Turno
1-May0
2Turno 0 03Turno 0 01Turno
2-May0 0
2Turno 0 03Turno 0 01Turno
3-May0 0
2Turno 0 03Turno 0 01Turno
4-May0 0
2Turno 0 03Turno 0 01Turno
5-May0 0
2Turno 0 03Turno 0 01Turno
6-May0 0
2Turno 0 03Turno 0 0
1Turno-May
0 02Turno 0 03Turno 0 01Turno
!-May0 0
2Turno 0 03Turno 0 01Turno
9-May0 0
2Turno 0 03Turno 0 01Turno
10-May163"1 16!" 5"6
2Turno3Turno1Turno
11-May2Turno 16!" 16!6"1 "43Turno 16!6"1 1692"1 61Turno
12-May1692"1 169! 5"9
2Turno 169! 105" "3Turno 105" 112"1 6"41Turno 112"1 115"! 3"
7/26/2019 Planilha controle PCs
2/56
2Turno 13-May 115"! 123"4 "63Turno 123"4 12!"1 4"1Turno
14-May12!"1 130" 2"6
2Turno 130" 13!"3 "63Turno 13!"3 145"2 6"91Turno
15-May
145"2 151"1 5"9
2Turno 151"1 15!"! "3Turno 15!"! 162"2 3"41Turno
16-May162"2 162"4 0"2
2Turno 162"4 164"9 2"53Turno 164"9 12"9 !1Turno
1-May12"9 19"4 6"5
2Turno 19"4 1! "63Turno 1! 190"5 3"51Turno
1!-May190"5 195"5 5
2Turno 195"5 19" 2"23Turno 19" 19" 0
1Turno19-May
19" 19" 02Turno 19" 1!05 "33Turno 01Turno
20-May0 0
2Turno 0 03Turno 0 01Turno
21-May0 0
2Turno 0 03Turno 0 01Turno
22-May
0 0
2Turno 0 03Turno 0 01Turno
23-May0 0
2Turno 0 03Turno 0 01Turno
24-May0 0
2Turno 0 03Turno 0 01Turno
25-May0 0
2Turno 0 03Turno 0 0
1Turno26-May
0 02Turno 0 03Turno 0 01Turno
2-May0 0
2Turno 0 03Turno 0 01Turno
2!-May0 0
2Turno 0 0
7/26/2019 Planilha controle PCs
3/56
3Turno 0 01Turno
29-May0 0
2Turno 0 03Turno 0 01Turno
30-May0 0
2Turno 0 0
3Turno 0 01Turno
31-May1!05 1!0"6 2"6
2Turno 1!0"6 1!09"2 1"63Turno 0
TOTA# 01$.0
CONTRO#E DE A$A%TECIMENTO
DATA &ORIMETRO #ITR
5'1'2012
5'2'2012
5'3'2012
5'4'2012
5'5'2012
5'6'2012
5''2012
5'!'2012
5'9'2012
5'10'201216"! 21
5'11'201216!6"1 150
5'12'2012169!"1 232105" 100120"6 226
7/26/2019 Planilha controle PCs
4/56
5'14'2012130" 1!13!"3 150
5'15'2012151"1 22115!"! 120
5'16'2012164"9 125
5'1'20123909" 25!391"2 15
5'1!'201219" 2101!" 215
5'19'2012190"5 90
5'20'20121!01"9 2201!05 42
5'21'2012
5'22'2012
5'23'2012
5'24'2012
5'25'2012
5'26'2012
5'2'2012
5'2!'2012
5'29'2012
5'30'2012
5'31'2012
TOTA# 296
7/26/2019 Planilha controle PCs
5/56
EMTERPE - Contrato !" #$%%%%$%##
EGADEIRA - 49 TAG - 910
HD HT HM HC D& &ORA I"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00
"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"001"4 5"6 0"0 "0 100"00
1"6 "4 0"0 9"0 100"002"0 6"0 0"0 !"0 100"001"1 5"9 0"0 "0 100"001"3 " 0"0 9"0 100"001"6 6"4 0"0 !"0 100"003"3 3" 0"0 "0 100"00
7/26/2019 Planilha controle PCs
6/56
1"4 "6 0"0 9"0 100"003"3 4" 0"0 !"0 100"004"4 2"6 0"0 "0 100"001"4 "6 0"0 9"0 100"001"1 6"9 0"0 !"0 100"001"1 5"9 0"0 "0 100"00
1"3 " 0"0 9"0 100"004"6 3"4 0"0 !"0 100"006"! 0"2 0"0 "0 100"006"5 2"5 0"0 9"0 100"000"0 !"0 0"0 !"0 100"000"5 6"5 0"0 "0 100"001"4 "6 0"0 9"0 100"004"5 3"5 0"0 !"0 100"002"0 5"0 0"0 "0 100"006"! 2"2 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00
"0 0"0 0"0 "0 100"001" "3 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"00
9"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00
"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00
7/26/2019 Planilha controle PCs
7/56
!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00
!"0 0"0 0"0 !"0 100"004"4 1"5 0"0 "0 100"00"4 1"6 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00
671.8 016 % 9:%.% 0%%.%% %.
% TOTA# DE #T("
0
0
0
0
0
0
0
0
0
21
150
332
7/26/2019 Planilha controle PCs
8/56
32!
341
125
415
425
90
262
0
0
0
0
0
0
0
0
0
0
0
2965
7/26/2019 Planilha controle PCs
9/56
7/26/2019 Planilha controle PCs
10/56
7/26/2019 Planilha controle PCs
11/56
% %.% %.%
7/26/2019 Planilha controle PCs
12/56
7/26/2019 Planilha controle PCs
13/56
HD - horas disponveis
HT - horas trabalhadas
HM - horas manuteno
HC - horas calendrio
D& - disponibilidade 'sica
D&()HD*HT+,)HD*HT*HM+
P C
TURNO DT H. /nicial H. &inal Total Hod.1Turno
1-May!451" !451" 0
2Turno !451" !451" 03Turno !451" !451" 01Turno
2-May!451" !456"2 4"5
2Turno !456"2 !459"4 3"23Turno !459"4 !464" 5"31Turno
3-May!464" !46! 3"3
2Turno !46! !43" 5"3Turno !43" !4!1 "31Turno
4-May!4!1 !4!6"! 5"!
2Turno !4!6"! !493"! 3Turno !493"! !499"1 5"31Turno
5-May!499"1 !502"6 3"5
2Turno !502"6 !504 1"43Turno !504 !504"6 0"61Turno
6-May!504"6 !504"6 0
2Turno !504"6 !504"6 03Turno !504"6 !504"6 0
1Turno-May
!504"6 !50"! 3"22Turno !50"! !511"2 3"43Turno !511"2 !51!"2 1Turno
!-May!51!"2 !522"1 3"9
2Turno !522"1 !524"4 2"33Turno !524"4 !52"4 31Turno
9-May!52"4 !530"6 3"2
2Turno !530"6 !533"9 3"33Turno !533"9 !53!"9 51Turno
10-May!53!"9 !542 3"1
2Turno !542 !543"1 1"13Turno !543"1 !543"1 01Turno
11-May!543"1 !543"5 0"4
2Turno !543"5 !549"1 5"63Turno !549"1 !551"9 2"!1Turno
12-May!551"9 !552"3 0"4
2Turno !552"3 !55"3 53Turno !55"3 !559 1"1Turno !559 !559 0
7/26/2019 Planilha controle PCs
14/56
2Turno 13-May !559 !559 03Turno !559 !559 01Turno
14-May!559 !559 0
2Turno !559 !566"4 "43Turno !566"4 !566"6 0"21Turno
15-May
!566"6 !56!"6 2
2Turno !56!"6 !569 0"43Turno !569 !569"1 0"11Turno
16-May!569"1 !569"1 0
2Turno !569"1 !52"5 3"43Turno !52"5 !52"6 0"11Turno
1-May!52"6 !52"6 0
2Turno !52"6 !52"6 03Turno !52"6 !55"9 3"31Turno
1!-May!55"9 !5!2 6"1
2Turno !5!2 !5!5"1 3"13Turno !5!5"1 !5!9"4 4"3
1Turno19-May
!5!9"4 !592"3 2"92Turno !592"3 !592"3 03Turno !592"3 !592"3 01Turno
20-May!592"3 !592"3 0
2Turno !592"3 !592"3 03Turno !592"3 !592"3 01Turno
21-May!592"3 !596"4 4"1
2Turno !596"4 !605 !"63Turno !605 !613 !1Turno
22-May
!613 !61!" 5"
2Turno !61!" !625"9 "23Turno !625"9 !633"5 "61Turno
23-May!633"5 !639"2 5"
2Turno !639"2 !646"6 "43Turno !646"6 !654"2 "61Turno
24-May!654"2 !660"1 5"9
2Turno !660"1 !66"! "3Turno !66"! !65"! !1Turno
25-May!65"! !6!0"9 5"1
2Turno !6!0"9 !6!3"9 33Turno !6!3"9 !690"! 6"9
1Turno26-May
!690"! !693 2"22Turno !693 !69"3 4"33Turno !69"3 !69"3 01Turno
2-May!69"3 !69"3 0
2Turno !69"3 !69"3 03Turno !69"3 !69"3 01Turno
2!-May!69"3 !69"3 0
2Turno !69"3 !00"9 3"6
7/26/2019 Planilha controle PCs
15/56
3Turno !00"9 !03"5 2"61Turno
29-May!03"5 !09"1 5"6
2Turno !09"1 !11"4 2"33Turno !11"4 !14" 3"31Turno
30-May!14" !19"2 4"5
2Turno !19"2 !23" 4"5
3Turno !23" !31"6 "91Turno
31-May!31"6 !36"4 4"!
2Turno !36"4 !42" 6"33Turno !42" !49"6 6"9
TOTA# :89.8
CONTRO#E DE A$A%TECIMEN
DATA &ORIMETRO #ITR
5'1'2012!45"! 15
!459"4 3
5'2'2012!469"1 11
5'3'2012!45 1!
5'4'2012!4!"9 32
!496 155'5'2012
!4!"9 32
!496 15
5'6'2012
5''2012!509"1 1!
5'!'2012!523" 16
5'9'2012
!531" 11
!534 3
5'10'2012!542"5 10
5'11'2012!549"1 10
5'12'2012!55"3 22
7/26/2019 Planilha controle PCs
16/56
5'14'2012!566"4 1!
5'15'2012!5!6"6
5'16'2012
5'1'2012
5'1!'2012!5!3"1 21!5!5"2 4"
5'19'2012
5'20'2012
5'21'2012!59!"4 23!606"2 19
5'22'2012!619"4 34!626"3 1
5'23'2012!640" 30!646"6 1!
5'24'2012!660"1 30!66"5 1
5'25'2012!6!0"9 31!6!4"3 5
5'26'2012!693"9 24
5'2'2012
5'2!'2012!69!"1 4
5'29'2012!09"6 14
5'30'2012!19"4 9!24" !
5'31'2012!36"5 32!43"1 1!
TOTA# 61!
7/26/2019 Planilha controle PCs
17/56
EMTERPE - Contrato !" #$%%%%$%##
RREGADEIRA - 20 TAG - 930
HD HT HM HC D&"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"002"5 4"5 0"0 "0 100"005"! 3"2 0"0 9"0 100"002" 5"3 0"0 !"0 100"003" 3"3 0"0 "0 100"003"3 5" 0"0 9"0 100"000" "3 0"0 !"0 100"001"2 5"! 0"0 "0 100"002"0 "0 0"0 9"0 100"002" 5"3 0"0 !"0 100"003"5 3"5 0"0 "0 100"00"6 1"4 0"0 9"0 100"00"4 0"6 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00
3"! 3"2 0"0 "0 100"005"6 3"4 0"0 9"0 100"001"0 "0 0"0 !"0 100"003"1 3"9 0"0 "0 100"006" 2"3 0"0 9"0 100"005"0 3"0 0"0 !"0 100"003"! 3"2 0"0 "0 100"005" 3"3 0"0 9"0 100"003"0 5"0 0"0 !"0 100"003"9 3"1 0"0 "0 100"00"9 1"1 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"006"6 0"4 0"0 "0 100"003"4 5"6 0"0 9"0 100"005"2 2"! 0"0 !"0 100"006"6 0"4 0"0 "0 100"004"0 5"0 0"0 9"0 100"006"3 1" 0"0 !"0 100"00"0 0"0 0"0 "0 100"00
7/26/2019 Planilha controle PCs
18/56
9"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"001"6 "4 0"0 9"0 100"00"! 0"2 0"0 !"0 100"005"0 2"0 0"0 "0 100"00
!"6 0"4 0"0 9"0 100"00"9 0"1 0"0 !"0 100"00"0 0"0 0"0 "0 100"005"6 3"4 0"0 9"0 100"00"9 0"1 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"004" 3"3 0"0 !"0 100"000"9 6"1 0"0 "0 100"005"9 3"1 0"0 9"0 100"003" 4"3 0"0 !"0 100"00
4"1 2"9 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"002"9 4"1 0"0 "0 100"000"4 !"6 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"3 5" 0"0 "0 100"00
1"! "2 0"0 9"0 100"000"4 "6 0"0 !"0 100"001"3 5" 0"0 "0 100"001"6 "4 0"0 9"0 100"000"4 "6 0"0 !"0 100"001"1 5"9 0"0 "0 100"001"3 " 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"9 5"1 0"0 "0 100"006"0 3"0 0"0 9"0 100"001"1 6"9 0"0 !"0 100"00
4"! 2"2 0"0 "0 100"004" 4"3 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"009"0 0"0 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"00"0 0"0 0"0 "0 100"005"4 3"6 0"0 9"0 100"00
7/26/2019 Planilha controle PCs
19/56
5"4 2"6 0"0 !"0 100"001"4 5"6 0"0 "0 100"006" 2"3 0"0 9"0 100"004" 3"3 0"0 !"0 100"002"5 4"5 0"0 "0 100"004"5 4"5 0"0 9"0 100"00
0"1 "9 0"0 !"0 100"002"2 4"! 0"0 "0 100"002" 6"3 0"0 9"0 100"001"1 6"9 0"0 !"0 100"00
##$.0 :89.8 % 9##.% 0%%.%%
TO
O% TOTA# DE #T("
51!5
112
01!0
040
00
400
0
61!6
0160
150
0100
10!!
2200
7/26/2019 Planilha controle PCs
20/56
1!66
0
0
0
025"
0
0
!434
60
5155
4903
4!19
32
2242
0
42
0140
1
5511
6
" 61!5"
7/26/2019 Planilha controle PCs
21/56
TURNO% &"In)*)a+
1 Turno 0.30
2 Turno .30
3 Turno 16.30
C2!TR2E DE M!3TE!452
&ORA INICIA# &ORA ,INA# TOTA# DE &ORA%
7/26/2019 Planilha controle PCs
22/56
7/26/2019 Planilha controle PCs
23/56
%.% %.% %.%
7/26/2019 Planilha controle PCs
24/56
7/26/2019 Planilha controle PCs
25/56
&" ,)na+.30
16.30
0.30
7/26/2019 Planilha controle PCs
26/56
7/26/2019 Planilha controle PCs
27/56
7/26/2019 Planilha controle PCs
28/56
7/26/2019 Planilha controle PCs
29/56
HD - horas disponveis
HT - horas trabalhadas
HM - horas manuteno
HC - horas calendrio
D& - disponibilidade 'sica
D&()HD*HT+,)HD*HT*HM+P CA
TURNO DT H. /nicial H. &inal Total Hod.1Turno
1-May3699 304 5
2Turno 304 311"2 "23Turno 311"2 31!"3 "11Turno
2-May31!"3 323"! 5"5
2Turno 323"! 331"4 "63Turno 331"4 339"3 "91Turno
3-May
339"3 344"9 5"6
2Turno 344"9 351"9 3Turno 351"9 359" "!1Turno
4-May359" 365"4 5"
2Turno 365"4 32"3 6"93Turno 32"3 3"2 4"91Turno
5-May3"2 3"4 0"2
2Turno 3"4 3!0"5 3"13Turno 3!0"5 3!!"3 "!1Turno
6-May3!!"3 393"! 5"5
2Turno 393"! 3!01"4 "6
3Turno 3!01"4 3!09"2 "!1Turno-May
3!09"2 3!15 5"!2Turno 3!15 3!22"9 "93Turno 3!22"9 3!30"1 "21Turno
!-May3!30"1 3!36"2 6"1
2Turno 3!36"2 3!44"3 !"13Turno 3!44"3 3!51"1 6"!1Turno
9-May3!51"1 3!5"1 6
2Turno 3!5"1 3!64"9 "!3Turno 3!64"9 3!2"1 "2
1Turno 10-May 3!2"1 3!! 5"92Turno 3!! 3!!5"9 "93Turno 3!!5"9 3!93"3 "41Turno
11-May3!93"3 3!9!"1 4"!
2Turno 3!9!"1 3!9!"1 03Turno 3!9!"1 3!9!"1 01Turno
12-May3!9!"1 3!9!"1 0
2Turno 3!9!"1 3!9!"1 03Turno 3!9!"1 3!9!"1 01Turno
13-May3!9!"1 3!9!"1 0
2Turno 3!9!"1 3!9!"1 0
3Turno 3!9!"1 3!9!"1 01Turno 3!9!"1 3!9!"1 0
7/26/2019 Planilha controle PCs
30/56
3Turno 3!9!"1 3!9!"1 01Turno
15-May3!9!"1 3!9!"1 0
2Turno 3!9!"1 3!9!"1 03Turno 3!9!"1 3903"6 5"51Turno
16-May3903"6 3909" 6"1
2Turno 3909" 391"3 "6
3Turno 391"3 3925"3 !1Turno
1-May3925"3 3930"9 5"6
2Turno 3930"9 393!"6 "3Turno 393!"6 3946"3 "1Turno
1!-May3946"3 3952"4 6"1
2Turno 3952"4 3960"2 "!3Turno 3960"2 396!"2 !1Turno
19-May396!"2 394"5 6"3
2Turno 394"5 39!1"9 "43Turno 39!1"9 39!9"! "9
1Turno20-May
39!9"! 3995"! 62Turno 3995"! 4003 "23Turno 4003 4011"4 !"41Turno
21-May4011"4 401"4 6
2Turno 401"4 4025"5 !"13Turno 4025"5 4033"1 "61Turno
22-May4033"1 403!"! 5"
2Turno 403!"! 4046"6 "!3Turno 4046"6 4054"2 "61Turno
23-May
4054"2 4059"9 5"
2Turno 4059"9 406"9 !3Turno 406"9 405"6 "1Turno
24-May405"6 40!1"5 5"9
2Turno 40!1"5 40!9"2 "3Turno 40!9"2 409"4 !"21Turno
25-May409"4 4102 4"6
2Turno 4102 4110" !"3Turno 4110" 411!"6 "91Turno
26-May411!"6 4124"2 5"6
2Turno 4124"2 4132"2 !3Turno 4132"2 4139"9 "1Turno
2-May4139"9 4145 5"1
2Turno 4145 4152"6 "63Turno 4152"6 4160"6 !1Turno
2!-May4160"6 4166"3 5"
2Turno 4166"3 413"9 "63Turno 413"9 41!1"! "91Turno
29-May41!1"! 41!"4 5"6
2Turno 41!"4 4195 "63Turno 4195 4202"! "!1Turno
30-May4202"! 420!"3 5"5
2Turno 420!"3 421"1 !"!3Turno 421"1 4224" "6
7/26/2019 Planilha controle PCs
31/56
2Turno 31-May 4230"6 423!"5 "93Turno 423!"5 4246"3 "!
TOTA# 6#9.1
CONTRO#E DE A$A%TECIMENT
DATA &ORIMETRO #ITR
5'1'201230!"4 20
5'2'2012323"! 16
331"4 1
5'3'2012 344"9 1353"4 16
5'4'2012366"6 2!
34"5 1
5'5'20123!0"5 12
5'6'201239!"1 24
5''20123!15"3 2
3!22"9 1!
5'!'20123!36"5 1
3!44"2 14
5'9'20123!5"1 21
3!64"! 13
5'10'20123!!"2 23
3!!5"! 15
5'11'20123!9!"3 20
5'12'2012
5'13'2012
5'14'2012
5'15'2012
5'16'2012
5'1'20123930"9 2
393!"6 15'1!'2012
3952"4 243960 9 20
7/26/2019 Planilha controle PCs
32/56
5'19'2012394" 2439!1"9 14
5'20'20124000 24
5'21'2012401"9 254025"5 1!
5'22'2012 403!"! 264046"6 19
5'23'20124059"9 123406"! 19
5'24'201240!1"5 2440!9"2 14
5'25'20124103 2
4110" 1
5'26'20124124"2 244132"2 15
5'2'2012 4149"3 26
5'2!'20124166"2 23413"9 21
5'29'201241!"4 244194"9 1!
5'30'2012420!"5 19421 19
5'31'20124230"6 23423!"4 1
TOTA# 935
7/26/2019 Planilha controle PCs
33/56
EMTERPE - Contrato !" #$%%%%$%##
REGADEIRA - 50 TAG - 940
HD HT HM HC D&
2"0 5"0 0"0 "0 100"001"! "2 0"0 9"0 100"000"9 "1 0"0 !"0 100"001"5 5"5 0"0 "0 100"001"4 "6 0"0 9"0 100"000"1 "9 0"0 !"0 100"001"4 5"6 0"0 "0 100"00
2"0 "0 0"0 9"0 100"000"2 "! 0"0 !"0 100"001"3 5" 0"0 "0 100"002"1 6"9 0"0 9"0 100"003"1 4"9 0"0 !"0 100"006"! 0"2 0"0 "0 100"005"9 3"1 0"0 9"0 100"000"2 "! 0"0 !"0 100"001"5 5"5 0"0 "0 100"001"4 "6 0"0 9"0 100"00
0"2 "! 0"0 !"0 100"001"2 5"! 0"0 "0 100"001"1 "9 0"0 9"0 100"000"! "2 0"0 !"0 100"000"9 6"1 0"0 "0 100"000"9 !"1 0"0 9"0 100"001"2 6"! 0"0 !"0 100"001"0 6"0 0"0 "0 100"001"2 "! 0"0 9"0 100"000"! "2 0"0 !"0 100"00
1"1 5"9 0"0 "0 100"001"1 "9 0"0 9"0 100"000"6 "4 0"0 !"0 100"002"2 4"! 0"0 "0 100"000"0 0"0 9"0 9"0 0"000"0 0"0 !"0 !"0 0"000"0 0"0 "0 "0 0"000"0 0"0 9"0 9"0 0"000"0 0"0 !"0 !"0 0"000"0 0"0 "0 "0 0"000"0 0"0 9"0 9"0 0"00
0"0 0"0 !"0 !"0 0"000"0 0"0 "0 "0 0"00
7/26/2019 Planilha controle PCs
34/56
0"0 0"0 !"0 !"0 0"000"0 0"0 "0 "0 0"000"0 0"0 9"0 9"0 0"002"5 5"5 0"0 !"0 100"000"9 6"1 0"0 "0 100"001"4 "6 0"0 9"0 100"00
0"0 !"0 0"0 !"0 100"001"4 5"6 0"0 "0 100"001"3 " 0"0 9"0 100"000"3 " 0"0 !"0 100"000"9 6"1 0"0 "0 100"001"2 "! 0"0 9"0 100"000"0 !"0 0"0 !"0 100"000" 6"3 0"0 "0 100"001"6 "4 0"0 9"0 100"000"1 "9 0"0 !"0 100"00
1"0 6"0 0"0 "0 100"001"! "2 0"0 9"0 100"00-0"4 !"4 0"0 !"0 100"001"0 6"0 0"0 "0 100"000"9 !"1 0"0 9"0 100"000"4 "6 0"0 !"0 100"001"3 5" 0"0 "0 100"001"2 "! 0"0 9"0 100"000"4 "6 0"0 !"0 100"001"3 5" 0"0 "0 100"00
1"0 !"0 0"0 9"0 100"000"3 " 0"0 !"0 100"001"1 5"9 0"0 "0 100"001"3 " 0"0 9"0 100"00-0"2 !"2 0"0 !"0 100"002"4 4"6 0"0 "0 100"000"3 !" 0"0 9"0 100"000"1 "9 0"0 !"0 100"001"4 5"6 0"0 "0 100"001"0 !"0 0"0 9"0 100"000"3 " 0"0 !"0 100"001"9 5"1 0"0 "0 100"001"4 "6 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"3 5" 0"0 "0 100"001"4 "6 0"0 9"0 100"000"1 "9 0"0 !"0 100"001"4 5"6 0"0 "0 100"001"4 "6 0"0 9"0 100"000"2 "! 0"0 !"0 100"001"5 5"5 0"0 "0 100"000"2 !"! 0"0 9"0 100"000"4 "6 0"0 !"0 100"00
7/26/2019 Planilha controle PCs
35/56
1"1 "9 0"0 9"0 100"000"2 "! 0"0 !"0 100"00
80.9 6#9.1 0%6 9##.% 76.78
O% TOTA# DE #T("
!20!
4343
9
9 3390
0450
0
1200
2400
1451
0
321
4
0340
0
43!9
5
9209
0
0
0
0
0
544
25
442
7/26/2019 Planilha controle PCs
36/56
4390
65
245
441
4
4 4639"5
319"563
3!630
44663
39!5
26
454
3
42!5
3969!
419
"5 9354"5
7/26/2019 Planilha controle PCs
37/56
TURNO% &"In)*)a+
1 Turno 0.30
2 Turno .30
3 Turno 16.30
C2!TR2E DE M!3TE!452
&ORA INICIA# &ORA ,INA# TOTA# DE &ORA%
7/26/2019 Planilha controle PCs
38/56
7/26/2019 Planilha controle PCs
39/56
%.% %.% %.%
7/26/2019 Planilha controle PCs
40/56
7/26/2019 Planilha controle PCs
41/56
&" ,)na+.30
16.30
0.30
7/26/2019 Planilha controle PCs
42/56
7/26/2019 Planilha controle PCs
43/56
7/26/2019 Planilha controle PCs
44/56
7/26/2019 Planilha controle PCs
45/56
HD - horas disponveis
HT - horas trabalhadas
HM - horas manuteno
HC - horas calendrio
D& - disponibilidade 'sica
D&()HD*HT+,)HD*HT*HM+
P C
TURNO DT H. /nicial H. &inal Total Hod.1Turno
1-May3259"3 3264"6 5"3
2Turno 3264"6 320"3 5"3Turno 320"3 32" "41Turno
2-May32" 32!2"6 4"9
2Turno 32!2"6 3290"! !"23Turno 3290"! 329!"! !1Turno
3-May329!"! 3304"3 5"5
2Turno 3304"3 3312"4 !"13Turno 3312"4 3320 "61Turno
4-May3320 3325 5
2Turno 3325 3333 !3Turno 3333 3340" "1Turno
5-May3340" 3346"6 5"9
2Turno 3346"6 3354"! !"23Turno 3354"! 3362"6 "!1Turno
6-May3362"6 336!"4 5"!
2Turno 336!"4 336 "63Turno 336 33!3"5 "5
1Turno-May
33!3"5 33!9"5 62Turno 33!9"5 339"1 "63Turno 339"1 3404"6 "51Turno
!-May3404"6 3410"6 6
2Turno 3410"6 341!"! !"23Turno 341!"! 3426"3 "51Turno
9-May3426"3 3432"3 6
2Turno 3432"3 3440"5 !"23Turno 3440"5 344! "51Turno
10-May344! 3454 6
2Turno 3454 3462"2 !"23Turno 3462"2 3469"5 "31Turno
11-May3469"5 345"5 6
2Turno 345"5 34!3"2 "3Turno 34!3"2 3490"4 "21Turno
12-May3490"4 3496"4 6
2Turno 3496"4 3504"1 "3Turno 3504"1 3511"2 "11Turno 3511"2 3515"3 4"1
7/26/2019 Planilha controle PCs
46/56
2Turno 13-May 3515"3 3523 "3Turno 3523 3530"4 "41Turno
14-May3530"4 3535"5 5"1
2Turno 3535"5 3543 "53Turno 3543 3550"5 "51Turno
15-May
3550"5 3556"4 5"9
2Turno 3556"4 3564"5 !"13Turno 3564"5 352"5 !1Turno
16-May352"5 35! 5"5
2Turno 35! 35!6 !3Turno 35!6 3594 !1Turno
1-May3594 3600"2 6"2
2Turno 3600"2 360!"5 !"33Turno 360!"5 3616"5 !1Turno
1!-May3616"5 3622"5 6
2Turno 3622"5 3629"6 "13Turno 3629"6 363"6 !
1Turno19-May
363"6 3643"1 5"52Turno 3643"1 3650"4 "33Turno 3650"4 3650"4 01Turno
20-May3650"4 3654"! 4"4
2Turno 3654"! 3662"4 "63Turno 3662"4 360"4 !1Turno
21-May360"4 365"9 5"5
2Turno 365"9 36!4 !"13Turno 36!4 3692 !1Turno
22-May
3692 369" 5"
2Turno 369" 305"6 "93Turno 305"6 313"3 "1Turno
23-May313"3 31!"9 5"6
2Turno 31!"9 32"4 !"53Turno 32"4 335 "61Turno
24-May335 340"5 5"5
2Turno 340"5 349 !"53Turno 349 35 !1Turno
25-May35 362"6 5"6
2Turno 362"6 30"3 "3Turno 30"3 3!"2 "9
1Turno26-May
3!"2 3!4 5"!2Turno 3!4 391"! "!3Turno 391"! 399"6 "!1Turno
2-May399"6 3!05"3 5"
2Turno 3!05"3 3!13"! !"53Turno 3!13"! 3!21"3 "51Turno
2!-May3!21"3 3!2"2 5"9
2Turno 3!2"2 3!35"3 !"1
7/26/2019 Planilha controle PCs
47/56
3Turno 3!35"3 3!43"1 "!1Turno
29-May3!43"1 3!4!" 5"6
2Turno 3!4!" 3!56"9 !"23Turno 3!56"9 3!64"6 "1Turno
30-May3!64"6 3!0"1 5"5
2Turno 3!0"1 3!"3 "2
3Turno 3!"3 3!!5"3 !1Turno
31-May3!!5"3 3!91"3 6
2Turno 3!91"3 3!99"3 !3Turno 3!99"3 390"3 !
TOTA# $#7
CONTRO#E DE A$A%TECIMENT
DATA &ORIMETRO #ITR
5'1'2012326"5 24
5'2'201232!2"6 16
3290"6 1!
5'3'20123304"3 16
3312"1 19
5'4'20123325 1!
3333"3 235'5'2012
3346"6 23
3354"! 1!
5'6'2012332" 24
5''201233!9" 19
339"1 14
5'!'20123411"1 16
341!"! 12
5'9'2012
3432"6 21
3440"5 14
5'10'20123454"1 1
3461"2 13
5'11'2012345" 19
3504"1 15
5'12'20123496"5 193504"1 153519"6 22
7/26/2019 Planilha controle PCs
48/56
5'14'20123535"5 153543 15
5'15'20123556"4 123564 14
5'16'201235! 30
35!6"5 165'1'2012
3601"2 2360! 12
5'1!'20123622"4 263629 12
5'19'20123643"4 2!3650"4 10
5'20'2012365!" 14
5'21'2012366"6 2!36!4 10
5'22'2012369 22305"6 14
5'23'201231"1 2432"3 1!
5'24'2012340"9 26349"6 22
5'25'2012362"6 1930"1 15
5'26'20123!4 19
391" 16
5'2'2012 3!09"6 23
5'2!'20123!2"2 233!35"2 19
5'29'20123!4!" 233!56"9 15
5'30'20123!0"1 1!3!"3 13
5'31'20123!91"4 293!99"3 15
TOTA# 10
7/26/2019 Planilha controle PCs
49/56
EMTERPE - Contrato !" #$%%%%$%##
RREGADEIRA - TAG - 950
HD HT HM HC D& &ORA 1" 5"3 0"0 "0 100"003"3 5" 0"0 9"0 100"000"6 "4 0"0 !"0 100"002"1 4"9 0"0 "0 100"000"! !"2 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"5 5"5 0"0 "0 100"000"9 !"1 0"0 9"0 100"000"4 "6 0"0 !"0 100"002"0 5"0 0"0 "0 100"001"0 !"0 0"0 9"0 100"000"3 " 0"0 !"0 100"001"1 5"9 0"0 "0 100"000"! !"2 0"0 9"0 100"000"2 "! 0"0 !"0 100"001"2 5"! 0"0 "0 100"001"4 "6 0"0 9"0 100"000"5 "5 0"0 !"0 100"00
1"0 6"0 0"0 "0 100"001"4 "6 0"0 9"0 100"000"5 "5 0"0 !"0 100"001"0 6"0 0"0 "0 100"000"! !"2 0"0 9"0 100"000"5 "5 0"0 !"0 100"001"0 6"0 0"0 "0 100"000"! !"2 0"0 9"0 100"000"5 "5 0"0 !"0 100"001"0 6"0 0"0 "0 100"000"! !"2 0"0 9"0 100"000" "3 0"0 !"0 100"001"0 6"0 0"0 "0 100"001"3 " 0"0 9"0 100"000"! "2 0"0 !"0 100"001"0 6"0 0"0 "0 100"001"3 " 0"0 9"0 100"000"9 "1 0"0 !"0 100"002"9 4"1 0"0 "0 100"00
7/26/2019 Planilha controle PCs
50/56
1"3 " 0"0 9"0 100"000"6 "4 0"0 !"0 100"001"9 5"1 0"0 "0 100"001"5 "5 0"0 9"0 100"000"5 "5 0"0 !"0 100"001"1 5"9 0"0 "0 100"00
0"9 !"1 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"5 5"5 0"0 "0 100"001"0 !"0 0"0 9"0 100"000"0 !"0 0"0 !"0 100"000"! 6"2 0"0 "0 100"000" !"3 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"0 6"0 0"0 "0 100"001"9 "1 0"0 9"0 100"000"0 !"0 0"0 !"0 100"00
1"5 5"5 0"0 "0 100"001" "3 0"0 9"0 100"00!"0 0"0 0"0 !"0 100"002"6 4"4 0"0 "0 100"001"4 "6 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"5 5"5 0"0 "0 100"000"9 !"1 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"3 5" 0"0 "0 100"00
1"1 "9 0"0 9"0 100"000"3 " 0"0 !"0 100"001"4 5"6 0"0 "0 100"000"5 !"5 0"0 9"0 100"000"4 "6 0"0 !"0 100"001"5 5"5 0"0 "0 100"000"5 !"5 0"0 9"0 100"000"0 !"0 0"0 !"0 100"001"4 5"6 0"0 "0 100"001"3 " 0"0 9"0 100"000"1 "9 0"0 !"0 100"00
1"2 5"! 0"0 "0 100"001"2 "! 0"0 9"0 100"000"2 "! 0"0 !"0 100"001"3 5" 0"0 "0 100"000"5 !"5 0"0 9"0 100"000"5 "5 0"0 !"0 100"001"1 5"9 0"0 "0 100"000"9 !"1 0"0 9"0 100"00
7/26/2019 Planilha controle PCs
51/56
0"2 "! 0"0 !"0 100"001"4 5"6 0"0 "0 100"000"! !"2 0"0 9"0 100"000"3 " 0"0 !"0 100"001"5 5"5 0"0 "0 100"001"! "2 0"0 9"0 100"00
0"0 !"0 0"0 !"0 100"001"0 6"0 0"0 "0 100"001"0 !"0 0"0 9"0 100"000"0 !"0 0"0 !"0 100"00
8$ $#7 % 9##.% 0%%.%% %
O
O% TOTA# DE #T("
244
0346
6
635!
2
2413
10
4100
2400
6339
3
12!6
5
6
3560
2311
9
0343
3
3506
7/26/2019 Planilha controle PCs
52/56
!30!
05
23!!
46916
4026
3!!
3!622
142
3!40
3060
42!!0
4!003
351!5
3616
9 239
943!
96
3!600
31
4440
!6 10!6
7/26/2019 Planilha controle PCs
53/56
TURNO% &"In)*)a+ &" ,)na+
1 Turno 0.30 .30
2 Turno .30 16.30
3 Turno 16.30 0.30
C2!TR2E DE M!3TE!452
NICIA# &ORA ,INA# TOTA# DE &ORA%
7/26/2019 Planilha controle PCs
54/56
7/26/2019 Planilha controle PCs
55/56
% %.% %.%
7/26/2019 Planilha controle PCs
56/56