{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ORIENTAÇÕES","LOG MODIFICAÇÕES","CAPA","PREMISSAS","Geciara"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"ORIENTAÇÕES","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,1,1,16]]}
[]
[null,"Planilha - Cálculo Cartão de Ponto"]
[]
[null,"1º - Preencher o nome da empresa e o período inicial do cartão de ponto na planilha \"CAPA\";"]
[null,"2º - Preencher os feriados;"]
[null,"3º - Preencher os dados solicitados na planilha \"Premissas\";"]
[null,"4º - Criar uma planilha para cada funcionário, fazendo uma cópia a partir da planilha \"MODELO\";"]
[null,"5º - Preencher o nome do funcionário e a carga horária nos dias da semana. Caso não houver carga horária em algum dia, deixe com o valor zero;"]
[null,"6º - Preencher os horários de entrada e saída dos funcionários. Observe que não é necessário digitar os dois pontos \":\" da hora, ex: para 12:45, digite apenas 1245;"]
[null,"7º - Caso tenha algum conhecimento de fórmulas e queira editar algumas, desbloqueie a planilha na aba \"Revisão\" >> \"Desproteger Planilha\". Não há senha."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Verifique atualizações da planilha em: ",null,null,null,"http://sourceforge.net/projects/pccp"]
[null,"Planilha criada por Renan Araujo. Dúvidas ou sugestões, mande um e-mail para vba.renan@gmail.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Versão:",{"$f":"'LOG MODIFICAÇÕES'!Q18","v":"2.1.1"}]

{"sheet":"LOG MODIFICAÇÕES","index":1,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":true,"merged":[[8,2,8,16],[7,2,7,16],[1,1,1,16],[3,2,3,16],[4,2,4,16],[5,2,5,16],[6,2,6,16]]}
[]
[null,"Planilha - Cálculo Cartão de Ponto"]
[]
[null,"Versão 1.1","Realizado ajuste para funcionários da jornada noturna. Para o horário da meia noite, utilizar a notação de 24 horas, por exemplo, o funcionário saiu para intervalo meia noite e meia, utilizar a notação 24:30. Para uma hora da manhã utilizar a notação normal, 01:00"]
[null,"Versão 1.2","Realizado ajuste para funcionários da jornada noturna. Cálculo estava sendo feito incorretamente quando o intervalo dava-se após a meia noite."]
[null,"Versão 1.3","Realizado ajuste para funcionários com carga horária diferenciada no sábado. Preencher a carga horária no campo \"Sábado\" que o sistema realizará o cálculo."]
[null,"Versão 2.0","Incuída planilha de premissas, onde pode ser ajustado a porcentagem de horas extras para cada dia da semana. Funcionalidade de carga horária diferenciada por dia da semana."]
[null,"Versão 2.1","Corrigido erro de cálculo no total de Horas Diárias."]
[null,"Versão 2.1.1","Corrigido erro no mês de fevereiro, onde aparecia erro de fórmula nos cálculos."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Planilha criada por Renan Araujo. Dúvidas ou sugestões, mande um e-mail para vba.renan@gmail.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Versão atual:","2.1.1"]

{"sheet":"CAPA","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[[22,3,22,7],[23,3,23,7],[19,3,19,7],[20,3,20,7],[14,3,14,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[21,3,21,7],[13,3,13,7],[2,2,2,7],[1,1,1,7],[5,1,5,7],[6,3,6,7],[7,3,7,7],[8,3,8,7],[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7]]}
[]
[null,"APONTAMENTO DE CARTÕES"]
[null,"EMPRESA:","Contr.H.Extras Goldenpark-ADM GOLDEN"]
[2,"PERÍODO","2016-05-15","À",{"$f":"DATE(YEAR($C$4),MONTH($C$4)+1,DAY($C$4)-1)","v":"2016-06-14"},null,null,null,2]
[3,null,null,null,null,null,null,null,3]
[4,"FERIADOS",null,null,null,null,null,null,4]
[5,"2016-01-01",{"$f":"IF(B7=\"\",\"\",IF(WEEKDAY(B7,1)=1,\"Domingo\",IF(WEEKDAY(B7,1)=2,\"Segunda\",IF(WEEKDAY(B7,1)=3,\"Terça\",IF(WEEKDAY(B7,1)=4,\"Quarta\",IF(WEEKDAY(B7,1)=5,\"Quinta\",IF(WEEKDAY(B7,1)=6,\"Sexta\",IF(WEEKDAY(B7,1)=7,\"Sábado\"))))))))","v":"Sexta"},"Ano novo",null,null,null,null,5]
[6,"2016-02-09","Terça","Carnaval",null,null,null,null,6]
[7,"2016-03-25","Sexta","Paixão de Cristo",null,null,null,null,7]
[1,"2016-03-27","Domingo","Pascoa",null,null,null,null,1]
["F","2016-04-21","Quinta","Tiradentes",null,null,null,null,"F"]
[null,"2016-05-01","Domingo","Dia do Trabalho"]
[null,"2016-05-26","Quinta","Corpus cristi"]
[null,"2016-09-07","Quarta","Independência do Brasil"]
[null,"2016-10-12","Quarta","Nossa Senhora Aparecida"]
[null,"2016-11-02","Quarta","Finados"]
[null,"2016-11-15","Terça","Proclamação da republuca"]
[null,"2016-12-25","Domingo","Natal"]
[null,"2016-06-13","Segunda","Aniversário de Guaratingueta"]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"PREMISSAS","index":3,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,2,2,7],[1,1,1,7],[12,1,12,4]]}
[]
[null,"HORA EXTRA"]
[null,"DIA DA SEMANA","CÁLCULO"]
[2,"SEGUNDA-FEIRA","AS","04:00:00","PRIMEIRAS HORAS SERÃO",0.65,"AS DEMAIS SERÃO",0.65,2]
[3,"TERÇA-FEIRA","AS","04:00:00","PRIMEIRAS HORAS SERÃO",0.65,"AS DEMAIS SERÃO",0.65,3]
[4,"QUARTA-FEIRA","AS","04:00:00","PRIMEIRAS HORAS SERÃO",0.65,"AS DEMAIS SERÃO",0.65,4]
[5,"QUINTA-FEIRA","AS","04:00:00","PRIMEIRAS HORAS SERÃO",0.65,"AS DEMAIS SERÃO",0.65,5]
[6,"SEXTA-FEIRA","AS","09:00:00","PRIMEIRAS HORAS SERÃO",0.65,"AS DEMAIS SERÃO",0.65,6]
[7,"SÁBADO","AS","04:00:00","PRIMEIRAS HORAS SERÃO",0.65,"AS DEMAIS SERÃO",0.65,7]
[1,"DOMINGO","AS","00:00:00","PRIMEIRAS HORAS SERÃO",0,"AS DEMAIS SERÃO",1,1]
["F","FERIADOS","AS","00:00:00","PRIMEIRAS HORAS SERÃO",0,"AS DEMAIS SERÃO",1,"F"]
[]
[null,"ADICIONAL NOTURNO"]
[{"$f":"MOD($D$14-$C$14,1)","v":0.29166666666666674},"INTERVALO A.N.","22:00:00","05:00:00",{"$f":"\"TOTAL: \" & TEXT(MOD(D14-C14,1),\"[hh]:mm\")","v":"TOTAL: 07:00"},null,null,null,{"$f":"MOD($D$14-$C$14,1)","v":0.29166666666666674}]

{"sheet":"Geciara","index":4,"n_rows":45,"n_cols":28,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,10,1,12],[1,14,1,16],[1,1,1,8],[40,1,44,18],[3,24,3,27],[38,1,38,3],[3,20,3,21],[3,1,3,2],[3,3,3,6],[38,4,38,5],[3,8,3,14],[3,16,3,18]]}
[]
[null,{"$f":"CAPA!$C$3","v":"Contr.H.Extras Goldenpark-ADM GOLDEN"},null,null,null,null,null,null,null,null,"Período de apuração ",null,null,null,"15/05/2016 a 14/06/2016",null,null,null,"Hor. Trab.",null,"Seg.a Sex. 08:00 as 17:48 C/ 1h. Interva-lo.","Compet.  05/2016"]
[]
[null,"Funcionário",null,"Geciara dos Santos",null,null,null,null,"H.E. / Atrasos / A.N",null,null,null,null,null,null,null,"Distrib. H.E. p/ Faixa",null,null,null,"CARGA HORÁRIA",null,null,null,"ESPELHO"]
[]
[null,"Data","Dia Semana","Entrada","Saída","Entrada","Saída",null,"H. Diária",null,"Atrasos",null,"Horas Extras",null,"Adic. Not.",null,"Hora 65%",null,"Hora 100%",2,"Segunda",0.3666666666666667,2,null,"Entrada","Saída","Entrada","Saída"]
[{"$f":"IF(NOT(ISERROR(VLOOKUP(B7,rngFeriados,1,FALSE))),\"F\",IF(B7=\"\",\"\",WEEKDAY($B7,1)))","v":1},{"$f":"CAPA!$C$4","v":"2016-05-15"},{"$f":"IF(B7=\"\",\"\",IF(WEEKDAY(B7,1)=1,\"Domingo\",IF(WEEKDAY(B7,1)=2,\"Segunda\",IF(WEEKDAY(B7,1)=3,\"Terça\",IF(WEEKDAY(B7,1)=4,\"Quarta\",IF(WEEKDAY(B7,1)=5,\"Quinta\",IF(WEEKDAY(B7,1)=6,\"Sexta\",IF(WEEKDAY(B7,1)=7,\"Sábado\"))))))))","v":"Domingo"},null,null,null,null,null,{"$f":"IF(ISERROR(IF(OR($Z7=\"\",$Z7=0),0,(IF(TEXT($Z7,\"[hh]:mm:ss\")<TEXT($Y7,\"[hh]:mm:ss\"),(1-$Y7+$Z7),$Z7-$Y7))+IF(OR($AB7=\"\",$AB7=0),0,(IF(TEXT($AB7,\"[hh]:mm:ss\")<TEXT($AA7,\"[hh]:mm:ss\"),(1-$AA7+$AB7),$AB7-$AA7))))),0,IF(OR($Z7=\"\",$Z7=0),0,(IF(TEXT($Z7,\"[hh]:mm:ss\")<TEXT($Y7,\"[hh]:mm:ss\"),(1-$Y7+$Z7),$Z7-$Y7))+IF(OR($AB7=\"\",$AB7=0),0,(IF(TEXT($AB7,\"[hh]:mm:ss\")<TEXT($AA7,\"[hh]:mm:ss\"),(1-$AA7+$AB7),$AB7-$AA7)))))","v":0},null,{"$f":"IF($A7=\"\",0,IF(OR((VLOOKUP($A7,$T$6:$V$13,3,FALSE)-$I7)<0,$Y7=\"\"),0,(VLOOKUP($A7,$T$6:$V$13,3,FALSE)-$I7)))","v":0},null,{"$f":"IF($A7=\"\",0,IF(($I7-VLOOKUP($A7,$T$6:$V$13,3,FALSE))<0,0,($I7-VLOOKUP($A7,$T$6:$V$13,3,FALSE))))","v":0},null,0,null,{"$f":"IF($A7=\"\",0,IF($M7<=VLOOKUP($A7,PREMISSAS!$A$4:$H$11,4,FALSE),$M7,VLOOKUP($A7,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A7=\"\",0,IF($M7>VLOOKUP($A7,PREMISSAS!$A$4:$H$11,4,FALSE),$M7-VLOOKUP($A7,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},3,"Terça",0.3666666666666667,3,null,{"$f":"IF(OR(D7=\"\",D7=0,D7=\"FALTA\",D7=\"SUSPENSO\",D7=\"SUSPENSÃO\"),\"\",TEXT(D7,\"##\"\":\"\"##\"))","v":""},{"$f":"IF(OR(E7=\"\",E7=0,E7=\"FALTA\",E7=\"SUSPENSO\",E7=\"SUSPENSÃO\"),\"\",TEXT(E7,\"##\"\":\"\"##\"))","v":""},{"$f":"IF(OR(F7=\"\",F7=0,F7=\"FALTA\",F7=\"SUSPENSO\",F7=\"SUSPENSÃO\"),\"\",TEXT(F7,\"##\"\":\"\"##\"))","v":""},{"$f":"IF(OR(G7=\"\",G7=0,G7=\"FALTA\",G7=\"SUSPENSO\",G7=\"SUSPENSÃO\"),\"\",TEXT(G7,\"##\"\":\"\"##\"))","v":""}]
[2,{"$f":"IF(B7=\"\",\"\",IF((B7+1)>CAPA!$E$4,\"\",B7+1))","v":"2016-05-16"},{"$f":"IF(B8=\"\",\"\",IF(WEEKDAY(B8,1)=1,\"Domingo\",IF(WEEKDAY(B8,1)=2,\"Segunda\",IF(WEEKDAY(B8,1)=3,\"Terça\",IF(WEEKDAY(B8,1)=4,\"Quarta\",IF(WEEKDAY(B8,1)=5,\"Quinta\",IF(WEEKDAY(B8,1)=6,\"Sexta\",IF(WEEKDAY(B8,1)=7,\"Sábado\"))))))))","v":"Segunda"},null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A8=\"\",0,IF($M8<=VLOOKUP($A8,PREMISSAS!$A$4:$H$11,4,FALSE),$M8,VLOOKUP($A8,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A8=\"\",0,IF($M8>VLOOKUP($A8,PREMISSAS!$A$4:$H$11,4,FALSE),$M8-VLOOKUP($A8,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},4,"Quarta",0.3666666666666667,4,null,"","","",""]
[3,{"$f":"IF(B8=\"\",\"\",IF((B8+1)>CAPA!$E$4,\"\",B8+1))","v":"2016-05-17"},"Terça",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A9=\"\",0,IF($M9<=VLOOKUP($A9,PREMISSAS!$A$4:$H$11,4,FALSE),$M9,VLOOKUP($A9,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A9=\"\",0,IF($M9>VLOOKUP($A9,PREMISSAS!$A$4:$H$11,4,FALSE),$M9-VLOOKUP($A9,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},5,"Quinta",0.3666666666666667,5,null,"","","",""]
[4,{"$f":"IF(B9=\"\",\"\",IF((B9+1)>CAPA!$E$4,\"\",B9+1))","v":"2016-05-18"},"Quarta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A10=\"\",0,IF($M10<=VLOOKUP($A10,PREMISSAS!$A$4:$H$11,4,FALSE),$M10,VLOOKUP($A10,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A10=\"\",0,IF($M10>VLOOKUP($A10,PREMISSAS!$A$4:$H$11,4,FALSE),$M10-VLOOKUP($A10,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},6,"Sexta",0.3666666666666667,6,null,"","","",""]
[5,{"$f":"IF(B10=\"\",\"\",IF((B10+1)>CAPA!$E$4,\"\",B10+1))","v":"2016-05-19"},"Quinta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A11=\"\",0,IF($M11<=VLOOKUP($A11,PREMISSAS!$A$4:$H$11,4,FALSE),$M11,VLOOKUP($A11,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A11=\"\",0,IF($M11>VLOOKUP($A11,PREMISSAS!$A$4:$H$11,4,FALSE),$M11-VLOOKUP($A11,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},7,"Sábado",0,7,null,"","","",""]
[6,{"$f":"IF(B11=\"\",\"\",IF((B11+1)>CAPA!$E$4,\"\",B11+1))","v":"2016-05-20"},"Sexta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A12=\"\",0,IF($M12<=VLOOKUP($A12,PREMISSAS!$A$4:$H$11,4,FALSE),$M12,VLOOKUP($A12,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A12=\"\",0,IF($M12>VLOOKUP($A12,PREMISSAS!$A$4:$H$11,4,FALSE),$M12-VLOOKUP($A12,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},1,"Domingo",0,1,null,"","","",""]
[7,{"$f":"IF(B12=\"\",\"\",IF((B12+1)>CAPA!$E$4,\"\",B12+1))","v":"2016-05-21"},"Sábado",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A13=\"\",0,IF($M13<=VLOOKUP($A13,PREMISSAS!$A$4:$H$11,4,FALSE),$M13,VLOOKUP($A13,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A13=\"\",0,IF($M13>VLOOKUP($A13,PREMISSAS!$A$4:$H$11,4,FALSE),$M13-VLOOKUP($A13,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},"F","Feriados",0,"F",null,"","","",""]
[1,{"$f":"IF(B13=\"\",\"\",IF((B13+1)>CAPA!$E$4,\"\",B13+1))","v":"2016-05-22"},"Domingo",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A14=\"\",0,IF($M14<=VLOOKUP($A14,PREMISSAS!$A$4:$H$11,4,FALSE),$M14,VLOOKUP($A14,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A14=\"\",0,IF($M14>VLOOKUP($A14,PREMISSAS!$A$4:$H$11,4,FALSE),$M14-VLOOKUP($A14,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Total Horas semanais",{"$f":"SUM(V6:V13)","v":1.8333333333333335},null,null,"","","",""]
[2,{"$f":"IF(B14=\"\",\"\",IF((B14+1)>CAPA!$E$4,\"\",B14+1))","v":"2016-05-23"},"Segunda",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A15=\"\",0,IF($M15<=VLOOKUP($A15,PREMISSAS!$A$4:$H$11,4,FALSE),$M15,VLOOKUP($A15,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A15=\"\",0,IF($M15>VLOOKUP($A15,PREMISSAS!$A$4:$H$11,4,FALSE),$M15-VLOOKUP($A15,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,null,null,null,null,"","","",""]
[3,{"$f":"IF(B15=\"\",\"\",IF((B15+1)>CAPA!$E$4,\"\",B15+1))","v":"2016-05-24"},"Terça",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A16=\"\",0,IF($M16<=VLOOKUP($A16,PREMISSAS!$A$4:$H$11,4,FALSE),$M16,VLOOKUP($A16,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A16=\"\",0,IF($M16>VLOOKUP($A16,PREMISSAS!$A$4:$H$11,4,FALSE),$M16-VLOOKUP($A16,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Salário",1520.29,null,null,"","","",""]
[4,{"$f":"IF(B16=\"\",\"\",IF((B16+1)>CAPA!$E$4,\"\",B16+1))","v":"2016-05-25"},"Quarta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A17=\"\",0,IF($M17<=VLOOKUP($A17,PREMISSAS!$A$4:$H$11,4,FALSE),$M17,VLOOKUP($A17,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A17=\"\",0,IF($M17>VLOOKUP($A17,PREMISSAS!$A$4:$H$11,4,FALSE),$M17-VLOOKUP($A17,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"H. normal",{"$f":"V16/220","v":6.9104090909090905},null,null,"","","",""]
["F",{"$f":"IF(B17=\"\",\"\",IF((B17+1)>CAPA!$E$4,\"\",B17+1))","v":"2016-05-26"},"Quinta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A18=\"\",0,IF($M18<=VLOOKUP($A18,PREMISSAS!$A$4:$H$11,4,FALSE),$M18,VLOOKUP($A18,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A18=\"\",0,IF($M18>VLOOKUP($A18,PREMISSAS!$A$4:$H$11,4,FALSE),$M18-VLOOKUP($A18,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Hora com 65%",{"$f":"V17*165%","v":11.402174999999998},null,null,"","","",""]
[6,{"$f":"IF(B18=\"\",\"\",IF((B18+1)>CAPA!$E$4,\"\",B18+1))","v":"2016-05-27"},"Sexta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A19=\"\",0,IF($M19<=VLOOKUP($A19,PREMISSAS!$A$4:$H$11,4,FALSE),$M19,VLOOKUP($A19,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A19=\"\",0,IF($M19>VLOOKUP($A19,PREMISSAS!$A$4:$H$11,4,FALSE),$M19-VLOOKUP($A19,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Hora",{"$f":"HOUR(Q39)","v":0},null,null,"","","",""]
[7,{"$f":"IF(B19=\"\",\"\",IF((B19+1)>CAPA!$E$4,\"\",B19+1))","v":"2016-05-28"},"Sábado",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A20=\"\",0,IF($M20<=VLOOKUP($A20,PREMISSAS!$A$4:$H$11,4,FALSE),$M20,VLOOKUP($A20,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A20=\"\",0,IF($M20>VLOOKUP($A20,PREMISSAS!$A$4:$H$11,4,FALSE),$M20-VLOOKUP($A20,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Minuto",{"$f":"MINUTE(Q39)","v":0},null,null,"","","",""]
[1,{"$f":"IF(B20=\"\",\"\",IF((B20+1)>CAPA!$E$4,\"\",B20+1))","v":"2016-05-29"},"Domingo",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A21=\"\",0,IF($M21<=VLOOKUP($A21,PREMISSAS!$A$4:$H$11,4,FALSE),$M21,VLOOKUP($A21,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A21=\"\",0,IF($M21>VLOOKUP($A21,PREMISSAS!$A$4:$H$11,4,FALSE),$M21-VLOOKUP($A21,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Decimal",{"$f":"V20/60","v":0},null,null,"","","",""]
[2,{"$f":"IF(B21=\"\",\"\",IF((B21+1)>CAPA!$E$4,\"\",B21+1))","v":"2016-05-30"},"Segunda",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A22=\"\",0,IF($M22<=VLOOKUP($A22,PREMISSAS!$A$4:$H$11,4,FALSE),$M22,VLOOKUP($A22,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A22=\"\",0,IF($M22>VLOOKUP($A22,PREMISSAS!$A$4:$H$11,4,FALSE),$M22-VLOOKUP($A22,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Hora decimal",{"$f":"V19+V21","v":0},null,null,"","","",""]
[3,{"$f":"IF(B22=\"\",\"\",IF((B22+1)>CAPA!$E$4,\"\",B22+1))","v":"2016-05-31"},"Terça",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A23=\"\",0,IF($M23<=VLOOKUP($A23,PREMISSAS!$A$4:$H$11,4,FALSE),$M23,VLOOKUP($A23,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A23=\"\",0,IF($M23>VLOOKUP($A23,PREMISSAS!$A$4:$H$11,4,FALSE),$M23-VLOOKUP($A23,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Total Horas 65%",{"$f":"V22*V18","v":0},null,null,"","","",""]
[4,{"$f":"IF(B23=\"\",\"\",IF((B23+1)>CAPA!$E$4,\"\",B23+1))","v":"2016-06-01"},"Quarta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A24=\"\",0,IF($M24<=VLOOKUP($A24,PREMISSAS!$A$4:$H$11,4,FALSE),$M24,VLOOKUP($A24,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A24=\"\",0,IF($M24>VLOOKUP($A24,PREMISSAS!$A$4:$H$11,4,FALSE),$M24-VLOOKUP($A24,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,null,null,null,null,"","","",""]
[5,{"$f":"IF(B24=\"\",\"\",IF((B24+1)>CAPA!$E$4,\"\",B24+1))","v":"2016-06-02"},"Quinta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A25=\"\",0,IF($M25<=VLOOKUP($A25,PREMISSAS!$A$4:$H$11,4,FALSE),$M25,VLOOKUP($A25,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A25=\"\",0,IF($M25>VLOOKUP($A25,PREMISSAS!$A$4:$H$11,4,FALSE),$M25-VLOOKUP($A25,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,null,null,null,null,"","","",""]
[6,{"$f":"IF(B25=\"\",\"\",IF((B25+1)>CAPA!$E$4,\"\",B25+1))","v":"2016-06-03"},"Sexta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A26=\"\",0,IF($M26<=VLOOKUP($A26,PREMISSAS!$A$4:$H$11,4,FALSE),$M26,VLOOKUP($A26,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A26=\"\",0,IF($M26>VLOOKUP($A26,PREMISSAS!$A$4:$H$11,4,FALSE),$M26-VLOOKUP($A26,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Salário",{"$f":"V16","v":1520.29},null,null,"","","",""]
[7,{"$f":"IF(B26=\"\",\"\",IF((B26+1)>CAPA!$E$4,\"\",B26+1))","v":"2016-06-04"},"Sábado",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A27=\"\",0,IF($M27<=VLOOKUP($A27,PREMISSAS!$A$4:$H$11,4,FALSE),$M27,VLOOKUP($A27,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A27=\"\",0,IF($M27>VLOOKUP($A27,PREMISSAS!$A$4:$H$11,4,FALSE),$M27-VLOOKUP($A27,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"H. normal",{"$f":"V26/220","v":6.9104090909090905},null,null,"","","",""]
[1,{"$f":"IF(B27=\"\",\"\",IF((B27+1)>CAPA!$E$4,\"\",B27+1))","v":"2016-06-05"},"Domingo",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A28=\"\",0,IF($M28<=VLOOKUP($A28,PREMISSAS!$A$4:$H$11,4,FALSE),$M28,VLOOKUP($A28,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A28=\"\",0,IF($M28>VLOOKUP($A28,PREMISSAS!$A$4:$H$11,4,FALSE),$M28-VLOOKUP($A28,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Hora com 100%",{"$f":"V27*2","v":13.820818181818181},null,null,"","","",""]
[2,{"$f":"IF(B28=\"\",\"\",IF((B28+1)>CAPA!$E$4,\"\",B28+1))","v":"2016-06-06"},"Segunda",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A29=\"\",0,IF($M29<=VLOOKUP($A29,PREMISSAS!$A$4:$H$11,4,FALSE),$M29,VLOOKUP($A29,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A29=\"\",0,IF($M29>VLOOKUP($A29,PREMISSAS!$A$4:$H$11,4,FALSE),$M29-VLOOKUP($A29,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Hora",{"$f":"HOUR(S39)","v":0},null,null,"","","",""]
[3,{"$f":"IF(B29=\"\",\"\",IF((B29+1)>CAPA!$E$4,\"\",B29+1))","v":"2016-06-07"},"Terça",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A30=\"\",0,IF($M30<=VLOOKUP($A30,PREMISSAS!$A$4:$H$11,4,FALSE),$M30,VLOOKUP($A30,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A30=\"\",0,IF($M30>VLOOKUP($A30,PREMISSAS!$A$4:$H$11,4,FALSE),$M30-VLOOKUP($A30,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Minuto",{"$f":"MINUTE(S39)","v":0},null,null,"","","",""]
[4,{"$f":"IF(B30=\"\",\"\",IF((B30+1)>CAPA!$E$4,\"\",B30+1))","v":"2016-06-08"},"Quarta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A31=\"\",0,IF($M31<=VLOOKUP($A31,PREMISSAS!$A$4:$H$11,4,FALSE),$M31,VLOOKUP($A31,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A31=\"\",0,IF($M31>VLOOKUP($A31,PREMISSAS!$A$4:$H$11,4,FALSE),$M31-VLOOKUP($A31,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Decimal",{"$f":"V30/60","v":0},null,null,"","","",""]
[5,{"$f":"IF(B31=\"\",\"\",IF((B31+1)>CAPA!$E$4,\"\",B31+1))","v":"2016-06-09"},"Quinta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A32=\"\",0,IF($M32<=VLOOKUP($A32,PREMISSAS!$A$4:$H$11,4,FALSE),$M32,VLOOKUP($A32,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A32=\"\",0,IF($M32>VLOOKUP($A32,PREMISSAS!$A$4:$H$11,4,FALSE),$M32-VLOOKUP($A32,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Hora decimal",{"$f":"V29+V31","v":0},null,null,"","","",""]
[6,{"$f":"IF(B32=\"\",\"\",IF((B32+1)>CAPA!$E$4,\"\",B32+1))","v":"2016-06-10"},"Sexta",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A33=\"\",0,IF($M33<=VLOOKUP($A33,PREMISSAS!$A$4:$H$11,4,FALSE),$M33,VLOOKUP($A33,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A33=\"\",0,IF($M33>VLOOKUP($A33,PREMISSAS!$A$4:$H$11,4,FALSE),$M33-VLOOKUP($A33,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Total Horas 100%",{"$f":"V32*V28","v":0},null,null,"","","",""]
[7,{"$f":"IF(B33=\"\",\"\",IF((B33+1)>CAPA!$E$4,\"\",B33+1))","v":"2016-06-11"},"Sábado",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A34=\"\",0,IF($M34<=VLOOKUP($A34,PREMISSAS!$A$4:$H$11,4,FALSE),$M34,VLOOKUP($A34,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A34=\"\",0,IF($M34>VLOOKUP($A34,PREMISSAS!$A$4:$H$11,4,FALSE),$M34-VLOOKUP($A34,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,null,null,null,null,"","","",""]
[1,{"$f":"IF(B34=\"\",\"\",IF((B34+1)>CAPA!$E$4,\"\",B34+1))","v":"2016-06-12"},"Domingo",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A35=\"\",0,IF($M35<=VLOOKUP($A35,PREMISSAS!$A$4:$H$11,4,FALSE),$M35,VLOOKUP($A35,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A35=\"\",0,IF($M35>VLOOKUP($A35,PREMISSAS!$A$4:$H$11,4,FALSE),$M35-VLOOKUP($A35,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Total Horas 65%+100%",{"$f":"V23+V33","v":0},null,null,"","","",""]
["F",{"$f":"IF(B35=\"\",\"\",IF((B35+1)>CAPA!$E$4,\"\",B35+1))","v":"2016-06-13"},"Segunda",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A36=\"\",0,IF($M36<=VLOOKUP($A36,PREMISSAS!$A$4:$H$11,4,FALSE),$M36,VLOOKUP($A36,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A36=\"\",0,IF($M36>VLOOKUP($A36,PREMISSAS!$A$4:$H$11,4,FALSE),$M36-VLOOKUP($A36,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,null,null,null,null,"","","",""]
[3,{"$f":"IF(B36=\"\",\"\",IF((B36+1)>CAPA!$E$4,\"\",B36+1))","v":"2016-06-14"},"Terça",null,null,null,null,null,0,null,0,null,0,null,0,null,{"$f":"IF($A37=\"\",0,IF($M37<=VLOOKUP($A37,PREMISSAS!$A$4:$H$11,4,FALSE),$M37,VLOOKUP($A37,PREMISSAS!$A$4:$H$11,4,FALSE)))","v":0},null,{"$f":"IF($A37=\"\",0,IF($M37>VLOOKUP($A37,PREMISSAS!$A$4:$H$11,4,FALSE),$M37-VLOOKUP($A37,PREMISSAS!$A$4:$H$11,4,FALSE),0))","v":0},null,"Adic. Not.20% H.normal",{"$f":"V16/220*20%","v":1.3820818181818182},null,null,"","","",""]
[]
[null,"TOTAIS",null,null,"Faltas / Suspensão",null,0,null,{"$f":"SUM($I$7:$I$37)","v":0},null,{"$f":"SUM($K$7:$K$37)","v":0},null,{"$f":"SUM(M$7:M$37)","v":0},null,{"$f":"SUM(O7:O38)","v":0},null,{"$f":"SUM(Q$7:Q$37)","v":0},null,{"$f":"SUM(S$7:S$37)","v":0},null,"Valor da Hora noturna",{"$f":"V37","v":1.3820818181818182}]
[]
[null,"OBSERVAÇÕES:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hora",{"$f":"HOUR(O39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minuto",{"$f":"MINUTE(O39)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Decimal",{"$f":"V42/60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hora decimal",{"$f":"V41+V43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total H. Noturna",{"$f":"V44*V39","v":0}]