{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Plan1","Plan2","Plan3","Formulário"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Plan1","index":0,"n_rows":24,"n_cols":153,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,5,2,7],[3,0,4,0],[5,0,6,0],[7,0,8,0],[9,0,10,0],[2,2,2,4],[2,8,2,10],[2,11,2,13],[2,14,2,16],[2,17,2,19],[2,20,2,22],[2,56,2,59],[2,60,2,63],[2,64,2,67],[2,68,2,71],[2,23,2,25],[2,26,2,28],[2,29,2,31],[2,32,2,35],[2,36,2,39],[2,40,2,43],[2,44,2,47],[2,48,2,51],[2,52,2,55],[2,116,2,119],[2,72,2,75],[2,76,2,79],[2,80,2,83],[2,84,2,87],[2,88,2,91],[2,92,2,95],[2,96,2,99],[2,100,2,103],[2,104,2,107],[2,108,2,111],[2,112,2,115],[2,144,2,147],[2,148,2,151],[2,152,2,155],[2,120,2,123],[2,124,2,127],[2,128,2,131],[2,132,2,135],[2,136,2,139],[2,140,2,143]]}
["CONTROLE DE HORAS DISPONÍVEIS USINAGEM"]
[]
["DIA -------->",null,1,null,null,2,null,null,3,null,null,4,null,null,5,null,null,6,null,null,7,null,null,8,null,null,9,null,null,10,null,null,1,null,null,null,2,null,null,null,3,null,null,null,4,null,null,null,5,null,null,null,6,null,null,null,7,null,null,null,8,null,null,null,9,null,null,null,10,null,null,null,11,null,null,null,12,null,null,null,13,null,null,null,14,null,null,null,15,null,null,null,16,null,null,null,17,null,null,null,18,null,null,null,19,null,null,null,20,null,null,null,21,null,null,null,22,null,null,null,23,null,null,null,24,null,null,null,25,null,null,null,26,null,null,null,27,null,null,null,28,null,null,null,29,null,null,null,30,null,null,null,31]
["VCN2",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",8.8000000000000007,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
["VCN3",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",5,"M",3.8,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
["VCN4",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",8.8000000000000007,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,"A",6.8,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
["VCN5",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",5,"O",3.8,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R",null,null,null,"R"]
[]
[]
["LEGENDA"]
["M = Manutenção"]
["RD = RD RETRABALHO"]
["S = SETUP"]
["O = OUTRAS PARADAS"]
["A = ABSENTEISMO"]
["R = DISPONIBILIDADE REAL"]
[]
["CONTROLDE DE OUTRAS PARADAS"]
["MQ.","DIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOTIVO"]
["VCN4",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FALTA DE PROGRAMAÇÃO"]

{"sheet":"Plan2","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[23,0,23,1],[0,3,0,6],[8,3,8,6],[0,0,1,1],[17,7,17,8],[2,0,2,1],[9,0,9,1],[16,0,16,1]]}
["CONTROLE DE PARADAS POR EQUIPAMENTO",null,null,"DISPONIBILIDADE"]
[null,null,null,"MÁQ.","DISP. NECESS.","DISP. REAL","%"]
["VCN2",null,null,"VCN2",{"$f":"$I$19*$I$20","v":8.8000000000000007},{"$f":"SUMIF(Plan1!AG4:AG5,\"R\",Plan1!AH4:AH5)","v":8.8000000000000007},{"$f":"(F3/E3)","v":1}]
["Manutenção (M).........................",null,null,"VCN3",{"$f":"$I$19*$I$20","v":8.8000000000000007},{"$f":"SUMIF(Plan1!AG5:AG6,\"R\",Plan1!AH5:AH6)","v":5},{"$f":"(F4/E4)","v":0.56818181818181812}]
["RD RETRABALHO (RD)..................",null,null,"VCN4",8.8000000000000007,{"$f":"SUMIF(Plan1!AG6:AG7,\"R\",Plan1!AH6:AH7)","v":5},0.56818181818181812]
["SETUP (S)....................................",null,null,"VCN5",8.8000000000000007,{"$f":"SUMIF(Plan1!AG7:AG8,\"R\",Plan1!AH7:AH8)","v":8.8000000000000007},1]
["ABSENTEISMO (A)......................."]
["OUTRAS PARADAS (O)................."]
[null,null,null,"EFICIÊNCIA"]
["VCN3",null,null,"MÁQ.","DISP. REAL","HRS. APONTADAS","%"]
["Manutenção (M).........................",null,null,"VCN2",{"$f":"F3","v":8.8000000000000007},null,{"$f":"(F11/E11)*100","v":0}]
["RD RETRABALHO (RD)..................",null,null,"VCN3",{"$f":"F4","v":5},null,{"$f":"(F12/E12)*100","v":0}]
["SETUP (S)....................................",null,null,"VCN4",{"$f":"F5","v":5},null,0]
["ABSENTEISMO (A).......................",null,null,"VCN5",{"$f":"F6","v":8.8000000000000007},null,0]
["OUTRAS PARADAS (O)................."]
[]
["VCN4"]
["Manutenção (M).........................",null,null,null,null,null,null,"DISP. NECESSÁRIA"]
["RD RETRABALHO (RD)..................",null,null,null,null,null,null,"HR.  DIA",8.8000000000000007]
["SETUP (S)....................................",null,null,null,null,null,null,"QTDE DIA PROD. MÊS",1]
["ABSENTEISMO (A)......................."]
["OUTRAS PARADAS (O)................."]
[]
["VCN5"]
["Manutenção (M)........................."]
["RD RETRABALHO (RD).................."]
["SETUP (S)...................................."]
["ABSENTEISMO (A)......................."]
["OUTRAS PARADAS (O)................."]

{"sheet":"Plan3","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["MÁQUINA",null,"VCN2"]
[]
["MQ.","TURNO","DATA","PARADA","TEMPO PARADO(HR)","HR APONTADAS NO PERIODO","TOTAL HRS TURNOS"]
["VCN2",1,"2016-03-11","Manutenção",1.8]
["VCN2",1,"2016-03-11","Outras paradas",2]
["VCN2",1,"2016-03-11","Setup",1]
["VCN2",1,"2016-03-11","Absenteísmo",3]
["VCN2",1,"2016-03-11","Rd Retrabalho",1]
["VCN2",1,"2016-03-12","Rd Retrabalho",1]
["VCN4",1,"2016-03-11","Rd Retrabalho",3]
["VCN4",1,"2016-03-11","Absenteísmo",6]
[]
[]
[]
[null,null,null,"TOTAL",{"$f":"SUBTOTAL(9,E4:E14)","v":9.8000000000000007},4,{"$f":"SUBTOTAL(9,G4:G14)","v":0}]
[]
[null,null,null,"HR. DISPONÍVEL",{"$f":"G15","v":0}]
[null,null,null,"HR. DISPONÍVEL (-) PARADA",{"$f":"E17-E15","v":-9.8000000000000007}]
[]
[]
[null,null,null,"DISPONIBILIDADE",{"$f":"E18/E17","v":{"$error":"#DIV/0!"}}]
[null,null,null,"EFICIÊNCIA",{"$f":"F15/E18","v":-0.4081632653061224}]
[]
[]
[null,null,null,"Manutenção",{"$f":"SUMPRODUCT(($A$4:$A$14=$C$1)*($D$4:$D$14=D25)*($E$4:$E$14))","v":1.8}]
[null,null,null,"Rd Retrabalho",{"$f":"SUMPRODUCT(($A$4:$A$14=$C$1)*($D$4:$D$14=D26)*($E$4:$E$14))","v":2}]
[null,null,null,"SETUP",{"$f":"SUMPRODUCT(($A$4:$A$14=$C$1)*($D$4:$D$14=D27)*($E$4:$E$14))","v":1}]
[null,null,null,"ABSENTEíSMO",{"$f":"SUMPRODUCT(($A$4:$A$14=$C$1)*($D$4:$D$14=D28)*($E$4:$E$14))","v":3}]
[null,null,null,"OUTRAS PARADAS",{"$f":"SUMPRODUCT(($A$4:$A$14=$C$1)*($D$4:$D$14=D29)*($E$4:$E$14))","v":2}]

{"sheet":"Formulário","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["LEGENDA",null,null,"____/____/____"]
["M = Manutenção"]
["RD = RD RETRABALHO",null,null,"VCN2"]
["S = SETUP",null,null,"VCN3"]
["O = OUTRAS PARADAS",null,null,"VCN4"]
["A = ABSENTEISMO",null,null,"VCN5"]
["R = DISPONIBILIDADE REAL"]
[]
["MQ.","TURNO","PARADA","TEMPO PARADO(HR)"]