{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["calc1","calc2","FIM"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"calc1","index":0,"n_rows":38,"n_cols":29,"rows_kept":38,"cut":false,"hidden":false,"merged":[[33,1,33,4],[34,1,34,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[5,1,5,17],[32,1,32,4],[19,1,19,4],[20,1,20,4],[12,15,12,17],[12,1,13,4],[14,1,14,4],[12,7,12,10],[12,11,12,13],[36,1,36,14],[37,1,37,14],[9,1,9,7],[8,1,8,7],[12,5,13,5],[12,6,13,6],[12,14,13,14],[21,1,21,4],[22,1,22,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[35,1,35,4],[27,1,27,4],[28,1,28,4]]}
[]
[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,10]
[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,15]
[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,25]
[]
[null,"TABELA DE TEMPO DE SERVIÇO"]
[]
[]
[null,"NOME: "]
[null,"ESP/NB: "]
[]
[]
[null,"E M P R E S A S",null,null,null,"Admissão","Demissão","PERÍODO COMUM",null,null,null,"PERÍODO ESPECIAL",null,null,"EQ","TOTAL GERAL"]
[null,null,null,null,null,null,null,"ANO","MÊS","DIA","DIA","ANO","MÊS","DIA",null,"ANO","MÊS ","DIA"]
[null,null,null,null,null,null,null,{"$f":"calc2!J9","v":0},{"$f":"calc2!M9","v":0},null,{"$f":"calc2!Q9","v":0},{"$f":"IF(O15=35,0,calc2!X9)","v":0},{"$f":"IF(O15=35,0,calc2!AA9)","v":0},{"$f":"IF(O15=35,0,calc2!AD9)","v":0},null,{"$f":"H15","v":0},{"$f":"I15","v":0},{"$f":"K15","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J10","v":0},{"$f":"calc2!M10","v":0},null,{"$f":"calc2!Q10","v":0},{"$f":"IF(O16=35,0,calc2!X10)","v":0},{"$f":"IF(O16=35,0,calc2!AA10)","v":0},{"$f":"IF(O16=35,0,calc2!AD10)","v":0},null,{"$f":"calc2!AL10","v":0},{"$f":"calc2!AO10","v":0},{"$f":"calc2!AQ10","v":0}]
["Stil Int. Ind",null,null,null,null,null,null,{"$f":"calc2!J11","v":0},{"$f":"calc2!M11","v":0},null,{"$f":"calc2!Q11","v":0},{"$f":"IF(O17=35,0,calc2!X11)","v":0},{"$f":"IF(O17=35,0,calc2!AA11)","v":0},{"$f":"IF(O17=35,0,calc2!AD11)","v":0},null,{"$f":"calc2!AL11","v":0},{"$f":"calc2!AO11","v":0},{"$f":"calc2!AQ11","v":0}]
["Stil Ind",null,null,null,null,null,null,{"$f":"calc2!J12","v":0},{"$f":"calc2!M12","v":0},null,{"$f":"calc2!Q12","v":0},{"$f":"IF(O18=35,0,calc2!X12)","v":0},{"$f":"IF(O18=35,0,calc2!AA12)","v":0},{"$f":"IF(O18=35,0,calc2!AD12)","v":0},null,{"$f":"calc2!AL12","v":0},{"$f":"calc2!AO12","v":0},{"$f":"calc2!AQ12","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J13","v":0},{"$f":"calc2!M13","v":0},null,{"$f":"calc2!Q13","v":0},{"$f":"IF(O19=35,0,calc2!X13)","v":0},{"$f":"IF(O19=35,0,calc2!AA13)","v":0},{"$f":"IF(O19=35,0,calc2!AD13)","v":0},null,{"$f":"calc2!AL13","v":0},{"$f":"calc2!AO13","v":0},{"$f":"calc2!AQ13","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J14","v":0},{"$f":"calc2!M14","v":0},null,{"$f":"calc2!Q14","v":0},{"$f":"IF(O20=35,0,calc2!X14)","v":0},{"$f":"IF(O20=35,0,calc2!AA14)","v":0},{"$f":"IF(O20=35,0,calc2!AD14)","v":0},null,{"$f":"calc2!AL14","v":0},{"$f":"calc2!AO14","v":0},{"$f":"calc2!AQ14","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J15","v":0},{"$f":"calc2!M15","v":0},null,{"$f":"calc2!Q15","v":0},{"$f":"IF(O21=35,0,calc2!X15)","v":0},{"$f":"IF(O21=35,0,calc2!AA15)","v":0},{"$f":"IF(O21=35,0,calc2!AD15)","v":0},null,{"$f":"calc2!AL15","v":0},{"$f":"calc2!AO15","v":0},{"$f":"calc2!AQ15","v":0}]
["CONSTRUTORA QUEIROZ GALVÃO",null,null,null,null,null,null,{"$f":"calc2!J16","v":0},{"$f":"calc2!M16","v":0},null,{"$f":"calc2!Q16","v":0},{"$f":"IF(O22=35,0,calc2!X16)","v":0},{"$f":"IF(O22=35,0,calc2!AA16)","v":0},{"$f":"IF(O22=35,0,calc2!AD16)","v":0},null,{"$f":"calc2!AL16","v":0},{"$f":"calc2!AO16","v":0},{"$f":"calc2!AQ16","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J17","v":0},{"$f":"calc2!M17","v":0},null,{"$f":"calc2!Q17","v":0},{"$f":"IF(O23=35,0,calc2!X17)","v":0},{"$f":"IF(O23=35,0,calc2!AA17)","v":0},{"$f":"IF(O23=35,0,calc2!AD17)","v":0},null,{"$f":"calc2!AL17","v":0},{"$f":"calc2!AO17","v":0},{"$f":"calc2!AQ17","v":0}]
["CAMPOS CONSTRUÇÕES",null,null,null,null,null,null,{"$f":"calc2!J18","v":0},{"$f":"calc2!M18","v":0},null,{"$f":"calc2!Q18","v":0},{"$f":"IF(O24=35,0,calc2!X18)","v":0},{"$f":"IF(O24=35,0,calc2!AA18)","v":0},{"$f":"IF(O24=35,0,calc2!AD18)","v":0},null,{"$f":"calc2!AL18","v":0},{"$f":"calc2!AO18","v":0},{"$f":"calc2!AQ18","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J19","v":0},{"$f":"calc2!M19","v":0},null,{"$f":"calc2!Q19","v":0},{"$f":"IF(O25=35,0,calc2!X19)","v":0},{"$f":"IF(O25=35,0,calc2!AA19)","v":0},{"$f":"IF(O25=35,0,calc2!AD19)","v":0},null,{"$f":"calc2!AL19","v":0},{"$f":"calc2!AO19","v":0},{"$f":"calc2!AQ19","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J20","v":0},{"$f":"calc2!M20","v":0},null,{"$f":"calc2!Q20","v":0},{"$f":"IF(O26=35,0,calc2!X20)","v":0},{"$f":"IF(O26=35,0,calc2!AA20)","v":0},{"$f":"IF(O26=35,0,calc2!AD20)","v":0},null,{"$f":"calc2!AL20","v":0},{"$f":"calc2!AO20","v":0},{"$f":"calc2!AQ20","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J21","v":0},{"$f":"calc2!M21","v":0},null,{"$f":"calc2!Q21","v":0},{"$f":"IF(O27=35,0,calc2!X21)","v":0},{"$f":"IF(O27=35,0,calc2!AA21)","v":0},{"$f":"IF(O27=35,0,calc2!AD21)","v":0},null,{"$f":"calc2!AL21","v":0},{"$f":"calc2!AO21","v":0},{"$f":"calc2!AQ21","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J22","v":0},{"$f":"calc2!M22","v":0},null,{"$f":"calc2!Q22","v":0},{"$f":"IF(O28=35,0,calc2!X22)","v":0},{"$f":"IF(O28=35,0,calc2!AA22)","v":0},{"$f":"IF(O28=35,0,calc2!AD22)","v":0},null,{"$f":"calc2!AL22","v":0},{"$f":"calc2!AO22","v":0},{"$f":"calc2!AQ22","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J23","v":0},{"$f":"calc2!M23","v":0},null,{"$f":"calc2!Q23","v":0},{"$f":"IF(O29=35,0,calc2!X23)","v":0},{"$f":"IF(O29=35,0,calc2!AA23)","v":0},{"$f":"IF(O29=35,0,calc2!AD23)","v":0},null,{"$f":"calc2!AL23","v":0},{"$f":"calc2!AO23","v":0},{"$f":"calc2!AQ23","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J24","v":0},{"$f":"calc2!M24","v":0},null,{"$f":"calc2!Q24","v":0},{"$f":"IF(O30=35,0,calc2!X24)","v":0},{"$f":"IF(O30=35,0,calc2!AA24)","v":0},{"$f":"IF(O30=35,0,calc2!AD24)","v":0},null,{"$f":"calc2!AL24","v":0},{"$f":"calc2!AO24","v":0},{"$f":"calc2!AQ24","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J25","v":0},{"$f":"calc2!M25","v":0},null,{"$f":"calc2!Q25","v":0},{"$f":"IF(O31=35,0,calc2!X25)","v":0},{"$f":"IF(O31=35,0,calc2!AA25)","v":0},{"$f":"IF(O31=35,0,calc2!AD25)","v":0},null,{"$f":"calc2!AL25","v":0},{"$f":"calc2!AO25","v":0},{"$f":"calc2!AQ25","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J26","v":0},{"$f":"calc2!M26","v":0},null,{"$f":"calc2!Q26","v":0},{"$f":"IF(O32=35,0,calc2!X26)","v":0},{"$f":"IF(O32=35,0,calc2!AA26)","v":0},{"$f":"IF(O32=35,0,calc2!AD26)","v":0},null,{"$f":"calc2!AL26","v":0},{"$f":"calc2!AO26","v":0},{"$f":"calc2!AQ26","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J27","v":0},{"$f":"calc2!M27","v":0},null,{"$f":"calc2!Q27","v":0},{"$f":"IF(O33=35,0,calc2!X27)","v":0},{"$f":"IF(O33=35,0,calc2!AA27)","v":0},{"$f":"IF(O33=35,0,calc2!AD27)","v":0},null,{"$f":"calc2!AL27","v":0},{"$f":"calc2!AO27","v":0},{"$f":"calc2!AQ27","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J28","v":0},{"$f":"calc2!M28","v":0},null,{"$f":"calc2!Q28","v":0},{"$f":"IF(O34=35,0,calc2!X28)","v":0},{"$f":"IF(O34=35,0,calc2!AA28)","v":0},{"$f":"IF(O34=35,0,calc2!AD28)","v":0},null,{"$f":"calc2!AL28","v":0},{"$f":"calc2!AO28","v":0},{"$f":"calc2!AQ28","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J29","v":0},{"$f":"calc2!M29","v":0},null,{"$f":"calc2!Q29","v":0},{"$f":"IF(O35=35,0,calc2!X29)","v":0},{"$f":"IF(O35=35,0,calc2!AA29)","v":0},{"$f":"IF(O35=35,0,calc2!AD29)","v":0},null,{"$f":"calc2!AL29","v":0},{"$f":"calc2!AO29","v":0},{"$f":"calc2!AQ29","v":0}]
[null,null,null,null,null,null,null,{"$f":"calc2!J30","v":0},{"$f":"calc2!M30","v":0},null,{"$f":"calc2!Q30","v":0},{"$f":"IF(O36=35,0,calc2!X30)","v":0},{"$f":"IF(O36=35,0,calc2!AA30)","v":0},{"$f":"IF(O36=35,0,calc2!AD30)","v":0},null,{"$f":"calc2!AL30","v":0},{"$f":"calc2!AO30","v":0},{"$f":"calc2!AQ30","v":0}]
[null,"                            S U B T O T A L",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"calc2!AL32","v":0},{"$f":"calc2!AO32","v":0},{"$f":"calc2!AR32","v":0}]
[null,"                             T O T A L",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"calc2!B31","v":0},{"$f":"calc2!C31","v":0},{"$f":"calc2!D31","v":0}]

{"sheet":"calc2","index":1,"n_rows":51,"n_cols":45,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,20,6,24],[6,8,6,11],[28,1,28,3]]}
["cal"]
[]
[]
[]
[]
[null,null,"TABELA  2",null,null,null,null,"TABELA 3"]
[null,null,null,null,null,null,null,null,"PERÍODO COMUM",null,null,null,null,null,null,null,null,null,null,null,"PERÍODO ESPECIAL",null,null,null,null,null,null,null,null,null,null,null,"TOTAL FINAL"]
[null,null,null,null,null,null,null,null,"/360","inteira","retira","*12","inteira","ineira","*30","inteira",">30","acresc.",null,"total","número","total final","/360","inteira","retira","*12","inteira","retira","*30","inteiro",null,null,"anos","meses","dias","TOTAL","/360","inteiro","retira","*12","inteiro","retira","*30","inteiro","retira"]
[null,null,"VALOR","Número",null,null,"diferença:",{"$f":"DAYS360(calc1!F15,calc1!G15,FALSE)","v":0},{"$f":"H9/360","v":0},{"$f":"INT(I9)","v":0},{"$f":"I9-INT(I9)","v":0},{"$f":"K9*12","v":0},{"$f":"INT(L9)","v":0},{"$f":"L9-INT(L9)","v":0},{"$f":"N9*30","v":0},{"$f":"IF(H9=0,0,INT(O9)+1)","v":0},{"$f":"IF(P9>30,P9-30,P9)","v":0},null,null,{"$f":"H9+1","v":1},{"$f":"IF(calc1!O15=0,0,VLOOKUP(calc1!O15,calc2!C10:D13,2))","v":0},{"$f":"U9*T9","v":0},{"$f":"V9/360","v":0},{"$f":"INT(W9)","v":0},{"$f":"W9-INT(W9)","v":0},{"$f":"Y9*12","v":0},{"$f":"INT(Z9)","v":0},{"$f":"Z9-INT(Z9)","v":0},{"$f":"AB9*30","v":0},{"$f":"INT(AC9)","v":0},null,null,{"$f":"IF(calc1!O15=35,J9*360,(J9+X9)*360)","v":0},{"$f":"IF(calc1!O15=35,M9*30,(M9+AA9)*30)","v":0},{"$f":"IF(calc1!O15=35,P9,(P9+AD9))","v":0},{"$f":"AG9+AH9+AI9","v":0},{"$f":"AJ9/360","v":0},{"$f":"calc1!P15","v":0},{"$f":"AK9-INT(AK9)","v":0},{"$f":"AM9*12","v":0},{"$f":"calc1!Q15","v":0},{"$f":"AN9-INT(AN9)","v":0},{"$f":"AP9*30","v":0},{"$f":"calc1!R15","v":0},{"$f":"AQ9-INT(AQ9)","v":0}]
[null,null,15,1.33,null,null,"diferença:",{"$f":"DAYS360(calc1!F16,calc1!G16,FALSE)","v":0},{"$f":"H10/360","v":0},{"$f":"INT(I10)","v":0},{"$f":"I10-INT(I10)","v":0},{"$f":"K10*12","v":0},{"$f":"INT(L10)","v":0},{"$f":"L10-INT(L10)","v":0},{"$f":"N10*30","v":0},{"$f":"IF(H10=0,0,INT(O10)+1)","v":0},{"$f":"IF(P10>30,P10-30,P10)","v":0},null,null,{"$f":"H10+1","v":1},{"$f":"IF(calc1!O16=0,0,VLOOKUP(calc1!O16,calc2!C10:D13,2))","v":0},{"$f":"U10*T10","v":0},{"$f":"V10/360","v":0},{"$f":"INT(W10)","v":0},{"$f":"W10-INT(W10)","v":0},{"$f":"Y10*12","v":0},{"$f":"INT(Z10)","v":0},{"$f":"Z10-INT(Z10)","v":0},{"$f":"AB10*30","v":0},{"$f":"INT(AC10)","v":0},null,null,{"$f":"IF(calc1!O16=35,J10*360,(J10+X10)*360)","v":0},{"$f":"IF(calc1!O16=35,M10*30,(M10+AA10)*30)","v":0},{"$f":"IF(calc1!O16=35,P10,(P10+AD10))","v":0},{"$f":"AG10+AH10+AI10","v":0},{"$f":"AJ10/360","v":0},{"$f":"INT(AK10)","v":0},{"$f":"AK10-INT(AK10)","v":0},{"$f":"AM10*12","v":0},{"$f":"INT(AN10)","v":0},{"$f":"AN10-INT(AN10)","v":0},{"$f":"AP10*30","v":0},{"$f":"INT(AQ10)","v":0},{"$f":"AQ10-INT(AQ10)","v":0}]
[null,null,20,0.75,null,null,"diferença:",{"$f":"DAYS360(calc1!F17,calc1!G17,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O17=0,0,VLOOKUP(calc1!O17,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O17=35,J11*360,(J11+X11)*360)","v":0},{"$f":"IF(calc1!O17=35,M11*30,(M11+AA11)*30)","v":0},{"$f":"IF(calc1!O17=35,P11,(P11+AD11))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,25,0.4,null,null,"diferença:",{"$f":"DAYS360(calc1!F18,calc1!G18,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O18=0,0,VLOOKUP(calc1!O18,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O18=35,J12*360,(J12+X12)*360)","v":0},{"$f":"IF(calc1!O18=35,M12*30,(M12+AA12)*30)","v":0},{"$f":"IF(calc1!O18=35,P12,(P12+AD12))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,35,1,null,null,"diferença:",{"$f":"DAYS360(calc1!F19,calc1!G19,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O19=0,0,VLOOKUP(calc1!O19,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O19=35,J13*360,(J13+X13)*360)","v":0},{"$f":"IF(calc1!O19=35,M13*30,(M13+AA13)*30)","v":0},{"$f":"IF(calc1!O19=35,P13,(P13+AD13))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F20,calc1!G20,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O20=0,0,VLOOKUP(calc1!O20,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O20=35,J14*360,(J14+X14)*360)","v":0},{"$f":"IF(calc1!O20=35,M14*30,(M14+AA14)*30)","v":0},{"$f":"IF(calc1!O20=35,P14,(P14+AD14))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F21,calc1!G21,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O21=0,0,VLOOKUP(calc1!O21,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O21=35,J15*360,(J15+X15)*360)","v":0},{"$f":"IF(calc1!O21=35,M15*30,(M15+AA15)*30)","v":0},{"$f":"IF(calc1!O21=35,P15,(P15+AD15))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F22,calc1!G22,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O22=0,0,VLOOKUP(calc1!O22,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O22=35,J16*360,(J16+X16)*360)","v":0},{"$f":"IF(calc1!O22=35,M16*30,(M16+AA16)*30)","v":0},{"$f":"IF(calc1!O22=35,P16,(P16+AD16))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F23,calc1!G23,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O23=0,0,VLOOKUP(calc1!O23,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O23=35,J17*360,(J17+X17)*360)","v":0},{"$f":"IF(calc1!O23=35,M17*30,(M17+AA17)*30)","v":0},{"$f":"IF(calc1!O23=35,P17,(P17+AD17))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F24,calc1!G24,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O24=0,0,VLOOKUP(calc1!O24,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O24=35,J18*360,(J18+X18)*360)","v":0},{"$f":"IF(calc1!O24=35,M18*30,(M18+AA18)*30)","v":0},{"$f":"IF(calc1!O24=35,P18,(P18+AD18))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F25,calc1!G25,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O25=0,0,VLOOKUP(calc1!O25,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O25=35,J19*360,(J19+X19)*360)","v":0},{"$f":"IF(calc1!O25=35,M19*30,(M19+AA19)*30)","v":0},{"$f":"IF(calc1!O25=35,P19,(P19+AD19))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F26,calc1!G26,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O26=0,0,VLOOKUP(calc1!O26,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O26=35,J20*360,(J20+X20)*360)","v":0},{"$f":"IF(calc1!O26=35,M20*30,(M20+AA20)*30)","v":0},{"$f":"IF(calc1!O26=35,P20,(P20+AD20))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F27,calc1!G27,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O27=0,0,VLOOKUP(calc1!O27,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O27=35,J21*360,(J21+X21)*360)","v":0},{"$f":"IF(calc1!O27=35,M21*30,(M21+AA21)*30)","v":0},{"$f":"IF(calc1!O27=35,P21,(P21+AD21))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F28,calc1!G28,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O28=0,0,VLOOKUP(calc1!O28,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O28=35,J22*360,(J22+X22)*360)","v":0},{"$f":"IF(calc1!O28=35,M22*30,(M22+AA22)*30)","v":0},{"$f":"IF(calc1!O28=35,P22,(P22+AD22))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F29,calc1!G29,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O29=0,0,VLOOKUP(calc1!O29,calc2!C10:D13,2))","v":0},0,{"$f":"V23/360","v":0},0,{"$f":"W23-INT(W23)","v":0},{"$f":"Y23*12","v":0},0,0,0,0,null,null,{"$f":"IF(calc1!O29=35,J23*360,(J23+X23)*360)","v":0},{"$f":"IF(calc1!O29=35,M23*30,(M23+AA23)*30)","v":0},{"$f":"IF(calc1!O29=35,P23,(P23+AD23))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F30,calc1!G30,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O30=0,0,VLOOKUP(calc1!O30,calc2!C10:D13,2))","v":0},0,{"$f":"V24/360","v":0},0,{"$f":"W24-INT(W24)","v":0},{"$f":"Y24*12","v":0},0,0,0,0,null,null,{"$f":"IF(calc1!O30=35,J24*360,(J24+X24)*360)","v":0},{"$f":"IF(calc1!O30=35,M24*30,(M24+AA24)*30)","v":0},{"$f":"IF(calc1!O30=35,P24,(P24+AD24))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"TABELA 04",null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F31,calc1!G31,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O31=0,0,VLOOKUP(calc1!O31,calc2!C11:D14,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O31=35,J25*360,(J25+X25)*360)","v":0},{"$f":"IF(calc1!O31=35,M25*30,(M25+AA25)*30)","v":0},{"$f":"IF(calc1!O31=35,P25,(P25+AD25))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"ANO","MÊS","DIA",null,null,"diferença:",{"$f":"DAYS360(calc1!F32,calc1!G32,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O33=0,0,VLOOKUP(calc1!O33,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O33=35,J26*360,(J26+X26)*360)","v":0},{"$f":"IF(calc1!O33=35,M26*30,(M26+AA26)*30)","v":0},{"$f":"IF(calc1!O33=35,P26,(P26+AD26))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"calc1!P37*360","v":0},{"$f":"calc1!Q37*30","v":0},{"$f":"calc1!R37","v":0},null,null,"diferença:",{"$f":"DAYS360(calc1!F33,calc1!G33,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O34=0,0,VLOOKUP(calc1!O34,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O34=35,J27*360,(J27+X27)*360)","v":0},{"$f":"IF(calc1!O34=35,M27*30,(M27+AA27)*30)","v":0},{"$f":"IF(calc1!O34=35,P27,(P27+AD27))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F34,calc1!G34,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O35=0,0,VLOOKUP(calc1!O35,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O35=35,J28*360,(J28+X28)*360)","v":0},{"$f":"IF(calc1!O35=35,M28*30,(M28+AA28)*30)","v":0},{"$f":"IF(calc1!O35=35,P28,(P28+AD28))","v":0},0,0,0,0,0,0,0,0,0,0]
["Subtotal:",{"$f":"B27+C27+D27","v":0},null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F35,calc1!G35,FALSE)","v":0},0,0,0,0,0,0,0,0,0,null,null,1,{"$f":"IF(calc1!O36=0,0,VLOOKUP(calc1!O36,calc2!C10:D13,2))","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(calc1!O36=35,J29*360,(J29+X29)*360)","v":0},{"$f":"IF(calc1!O36=35,M29*30,(M29+AA29)*30)","v":0},{"$f":"IF(calc1!O36=35,P29,(P29+AD29))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"diferença:",{"$f":"DAYS360(calc1!F36,calc1!G36,FALSE)","v":0},0,0,{"$f":"I30-INT(I30)","v":0},0,0,{"$f":"L30-INT(L30)","v":0},0,{"$f":"IF(H30=0,0,INT(O30)+1)","v":0},0,null,null,1,{"$f":"IF(calc1!O37=0,0,VLOOKUP(calc1!O37,calc2!C11:D14,2))","v":0},{"$f":"U30*T30","v":0},0,0,{"$f":"W30-INT(W30)","v":0},0,0,{"$f":"Z30-INT(Z30)","v":0},0,0,null,null,{"$f":"IF(calc1!O37=35,J30*360,(J30+X30)*360)","v":0},{"$f":"IF(calc1!O37=35,M30*30,(M30+AA30)*30)","v":0},{"$f":"IF(calc1!O37=35,P30,(P30+AD30))","v":0},{"$f":"AG30+AH30+AI30","v":0},0,0,{"$f":"AK30-INT(AK30)","v":0},0,0,{"$f":"AN30-INT(AN30)","v":0},0,0,{"$f":"AQ30-INT(AQ30)","v":0}]
["TOTAL:",{"$f":"D35","v":0},{"$f":"G35","v":0},{"$f":"I35","v":0}]
[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,null,null,null,null,null,null,null,{"$f":"SUM(AL9:AL30)","v":0},null,null,{"$f":"SUM(AO9:AO30)","v":0},null,null,{"$f":"SUM(AR9:AR30)","v":0}]
[]
["Subtotal:","/360","retira","inteiro","*12","retira","inteiro","*30","inteiro"]
[{"$f":"B29","v":0},{"$f":"A35/360","v":0},{"$f":"B35-INT(B35)","v":0},{"$f":"INT(B35)","v":0},{"$f":"C35*12","v":0},{"$f":"E35-INT(E35)","v":0},{"$f":"INT(E35)","v":0},{"$f":"F35*30","v":0},{"$f":"INT(H35)","v":0}]
[]
[]
[null,"TABELA 05"]
[null,"ANO ","MÊS ","DIA"]
["PLAN1",{"$f":"FIM!B23","v":0},{"$f":"FIM!C23","v":0},{"$f":"FIM!D23","v":0}]
["PLAN2",{"$f":"FIM!B24","v":0},{"$f":"FIM!C24","v":0},{"$f":"FIM!D24","v":0}]
["PLAN3",{"$f":"FIM!B25","v":0},{"$f":"FIM!C25","v":0},{"$f":"FIM!D25","v":0}]
["PLAN4",{"$f":"FIM!B26","v":0},{"$f":"FIM!C26","v":0},{"$f":"FIM!D26","v":0}]
["PLAN5",{"$f":"FIM!B27","v":0},{"$f":"FIM!C27","v":0},{"$f":"FIM!D27","v":0}]
[null,null,null,null,null,"TOTAL"]
["Subotal",{"$f":"B40+B41+B42+B43+B44","v":0},{"$f":"C40+C41+C42+C43+C44","v":0},{"$f":"D40+D41+D42+D43+D44","v":0},"=",{"$f":"B46*360+C46*30+D46","v":0}]
[]
["TOTAL:",{"$f":"D51","v":0},{"$f":"G51","v":0},{"$f":"I51","v":0}]
[]
["Subtotal:","/360","retira","inteiro","*12","retira","inteiro","*30","Inteiro"]
[{"$f":"F46","v":0},{"$f":"A51/360","v":0},{"$f":"B51-INT(B51)","v":0},{"$f":"INT(B51)","v":0},{"$f":"C51*12","v":0},{"$f":"E51-INT(E51)","v":0},{"$f":"INT(E51)","v":0},{"$f":"F51*30","v":0},{"$f":"INT(H51)","v":0}]

{"sheet":"FIM","index":2,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[20,1,20,2]]}
[]
[]
[]
[null,"*PARA USO DO PROGRAMA:"]
[]
[]
[null,"CASO A  PLANILHA SEJA MAIS DE UMA FOLHA SEGUIR SEGUINTES PROCEDIMENTOS:"]
[]
[]
[]
[null,"1ª Fazer primeiramente a primeira tabela de tempo de serviço normalmente."]
[null,"2ª Quando  terminada, a primeira parte, salvar-la com outro nome Ex: tempo de serviço-JOÂO SANTOS"]
[null,"3ªAbrir uma nova planilha de tempo de serviço"]
[null,"4ª Digitar os dados que faltam"]
[null,"5ª  Se A planilha não der ainda, continue repetindo os passos acima"]
[null,"6ª Assim que terminar todas, passaremos a usar os procedimentos especiais para calcular o tempo de serviço TOTAL"]
[null,"7ª Primeiramente, vá em cada planilha salva, e anote ou copie o valor que se encontra em TOTAL"]
[null,"8ª Após copiar todos os valores, copie-os neste quadro abaixo"]
[]
[]
[null,"TABELA  05"]
[null,"ANO","MÊS ","DIA"]
["PLAN1"]
["PLAN2"]
["PLAN3"]
["PLAN4"]
["PLAN5"]
[]
["Subtotal:",{"$f":"calc2!B46","v":0},{"$f":"calc2!C46","v":0},{"$f":"calc2!D46","v":0}]
[]
["TOTAL:",{"$f":"calc2!B48","v":0},{"$f":"calc2!C48","v":0},{"$f":"calc2!D48","v":0}]
[]
[]
[null,"9ª Anote o resultado dado acima e copie na ultima tabela feita do beneficiario, nos campos subotal e total"]
[]
[null,"OBS: Não Salve em cima da tabela padrão tempo de serviço, porque haverá erros!!!"]
[null,"SEMPRE SALVE A TABELA COM OUTRO NOME!"]