{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Plan2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Plan2","index":0,"n_rows":28,"n_cols":69,"rows_kept":28,"cut":false,"hidden":false,"merged":[[3,58,6,58],[6,55,6,57],[3,55,5,57],[22,32,22,34],[3,20,4,22],[3,23,4,23],[3,26,4,28],[3,29,4,29],[3,32,4,34],[3,35,4,35],[3,38,4,40],[3,41,4,41],[22,20,22,22],[22,26,22,28],[1,55,2,68],[1,50,2,53],[1,45,2,48],[1,20,2,23],[1,26,2,29],[1,32,2,35],[1,38,2,41],[1,24,2,24],[1,30,2,30],[1,36,2,36],[1,42,2,42],[0,1,0,10],[14,4,14,5],[3,15,4,15],[5,12,6,12],[5,15,6,15],[5,9,6,9],[7,9,9,9],[10,9,13,9],[24,16,25,16],[3,9,4,9],[4,4,4,5],[11,2,11,3],[10,10,13,10],[10,4,10,5],[12,4,12,5],[13,4,13,5],[24,12,25,12],[24,15,25,15],[24,1,25,1],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[15,2,15,3],[0,50,0,53],[0,45,0,48],[3,45,3,47],[10,45,11,47],[10,48,11,48],[4,45,4,47],[5,45,5,47],[6,45,6,47],[4,2,4,3],[6,2,6,3],[8,2,8,3],[9,2,9,3],[3,50,4,52],[3,53,4,53],[9,45,9,48],[7,45,7,47],[3,12,4,12],[3,10,4,10],[5,10,6,10],[7,10,9,10],[3,2,3,5],[6,4,6,5],[8,4,8,5],[9,4,9,5],[26,7,27,7],[26,8,27,8],[26,9,27,9],[26,10,27,10],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[19,9,23,9],[19,7,20,7],[23,4,23,5],[19,10,23,10],[20,4,20,5],[21,4,21,5],[22,4,22,5],[19,4,19,5],[24,9,25,9],[24,10,25,10],[19,8,20,8],[24,3,25,3],[24,4,25,5],[24,7,25,7],[24,8,25,8],[0,17,0,18],[0,12,0,15],[7,17,9,18],[10,17,13,18],[19,17,23,18],[24,17,25,18],[26,17,27,17],[26,18,27,18],[3,18,4,18],[5,17,6,17],[5,18,6,18],[20,15,23,15],[26,12,27,12],[26,15,27,15],[26,16,27,16],[24,13,25,13],[24,14,25,14],[26,13,27,13],[26,14,27,14],[5,16,6,16],[3,17,4,17],[24,20,24,22],[1,1,2,5],[1,7,2,8],[1,9,2,9],[1,10,2,10],[8,15,9,15],[1,17,1,18],[11,15,13,15],[3,13,4,13],[3,14,4,14],[1,13,1,14],[5,13,6,13],[5,14,6,14],[1,12,2,12],[1,15,2,15],[1,16,2,16],[3,16,4,16],[16,2,16,3],[17,2,17,3],[18,2,18,3],[11,4,11,5],[12,2,12,3],[13,2,13,3],[14,10,18,10]]}
[null,"PLAM-CNEN                                                                                                         PLANO DE CUSTEIO EM VIGOR",null,null,null,null,null,null,null,null,null,false,"NOVA PROPOSTA DE PLANO DE CUSTEIO",null,null,null,"ASSINALE PARA DEFINIR COBERTURA MATERDEI",{"$f":"IF(L1=FALSE,\"SEM ATENDIMENTO MATERDEI\",\"COM ATENDIMENTO MATERDEI\")","v":"SEM ATENDIMENTO MATERDEI"},null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23]
[null,"PARÂMETROS PARA SIMULAÇÃO",null,null,null,null,null,"CONTRIBUIÇÃO DO SERVIDOR",null,"PARTICIPAÇÃO DA UNIÃO","TOTAL",null,"NOVA TABELA","VARIAÇÃO",null,"PARTICIPAÇÃO DA UNIÃO","CONTRIBUIÇÃO DO SERVIDOR","VARIAÇÃO",null,null,"TITULARES E CÔNJUGES",null,null,null,"ATENDIMENTO MATERDEI",null,"FILHOS < 21 ANOS",null,null,null,"ATENDIMENTO MATERDEI",null,"PAIS, MÃES E IRMÃOS",null,null,null,"ATENDIMENTO MATERDEI",null,"FILHOS > 21 ANOS E NETOS",null,null,null,"ATENDIMENTO MATERDEI",null,null,"CONTRIBUIÇÕES VARIÁVEIS",null,null,null,null,"CONTRIBUIÇÃO FIXA                                             NETOS E FILHOS >21 ANOS",null,null,null,null,"CONTRIBUIÇÃO DA UNIÃO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"R$","%",null,null,"R$","%"]
[null,"REMUNERAÇÃO DO TITULAR:",null,null,null,null,null,{"$f":"IF(C4=\"\",\"\",\"VARIÁVEL\")","v":""},{"$f":"$C$4*AW4","v":0},{"$f":"IF(C4=\"\",\"\",IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=1,HLOOKUP(C5,$BH$5:$BQ$15,4),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=2,HLOOKUP(C5,$BH$5:$BQ$15,5),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=3,HLOOKUP(C5,$BH$5:$BQ$15,6),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=4,HLOOKUP(C5,$BH$5:$BQ$15,7),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=5,HLOOKUP(C5,$BH$5:$BQ$15,8),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=6,HLOOKUP(C5,$BH$5:$BQ$15,9),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=7,HLOOKUP(C5,$BH$5:$BQ$15,10),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=8,HLOOKUP(C5,$BH$5:$BQ$15,11))))))))))","v":""},{"$f":"SUM(I4:J5)","v":0},null,{"$f":"IF(C5=\"\",\"\",IF($L$1=FALSE,(IF($C$4>$X$25,VLOOKUP(C5,$U$6:$AQ$21,X1),VLOOKUP(C5,$U$6:$AP$21,X1)-($X$23-$C$4*$X$24))),(IF($C$4>$X$25,VLOOKUP(C5,$U$6:$AQ$21,Y1),VLOOKUP(C5,$U$6:$AP$21,Y1)-($X$23-$C$4*$X$24)))))","v":""},{"$f":"IF(M4=\"\",\"\",M4-K4)","v":""},{"$f":"IF(M4=\"\",\"\",N4/K4)","v":""},{"$f":"J4","v":""},{"$f":"IF(M4=\"\",\"\",M4-P4)","v":""},{"$f":"IF(M4=\"\",\"\",Q4-I4-I5)","v":""},{"$f":"IF(M4=\"\",\"\",R4/(I4+I5))","v":""},null,"DISTRIBUIÇÃO ETÁRIA",null,null,"CONTRI BUIÇÃO","ACRÉSCIMO DE",null,"DISTRIBUIÇÃO ETÁRIA",null,null,"CONTRI BUIÇÃO","ACRÉSCIMO DE",null,"DISTRIBUIÇÃO ETÁRIA",null,null,"CONTRI BUIÇÃO","ACRÉSCIMO DE",null,"DISTRIBUIÇÃO ETÁRIA",null,null,"CONTRI BUIÇÃO","ACRÉSCIMO DE",null,null,"TITULAR",null,null,0.02,null,"FAIXA ETÁRIA",null,null,"CONTRI BUIÇÃO",null,"FAIXAS DE RENDA E IDADE",null,null,"IDADE","FAIXA 01","FAIXA 02","FAIXA 03","FAIXA 04","FAIXA 05","FAIXA 06","FAIXA 07","FAIXA 08","FAIXA 09","FAIXA 10"]
[null,{"$f":"IF(C4=\"\",\"\",\"IDADE DO TITULAR:\")","v":""},null,null,{"$f":"IF(B5=\"\",\"\",\"ANOS\")","v":""},null,null,{"$f":"IF(C4=\"\",\"\",\"FIXA\")","v":""},{"$f":"IF(C4=\"\",\"\",VLOOKUP(C5,$AT$13:$AW$28,4))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,null,null,null,{"$f":"$Y$5","v":0.4},null,null,null,null,null,{"$f":"$Y$5","v":0.4},null,null,null,null,null,{"$f":"$Y$5","v":0.4},null,null,"CÔNJUGE",null,null,0.02,null,null,null,null,null,null,null,null,null,null,0,19,24,29,34,39,44,49,54,59]
[null,"POSSUI CÔNJUGE?",null,"SIM",null,"NÃO",2,{"$f":"IF(G6=2,\"\",\"VARIÁVEL\")","v":""},{"$f":"IF(B7=\"\",0,$C$4*AW5)","v":0},{"$f":"IF(B7=\"\",0,IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=1,HLOOKUP(C7,$BH$5:$BQ$15,4),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=2,HLOOKUP(C7,$BH$5:$BQ$15,5),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=3,HLOOKUP(C7,$BH$5:$BQ$15,6),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=4,HLOOKUP(C7,$BH$5:$BQ$15,7),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=5,HLOOKUP(C7,$BH$5:$BQ$15,8),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=6,HLOOKUP(C7,$BH$5:$BQ$15,9),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=7,HLOOKUP(C7,$BH$5:$BQ$15,10),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=8,HLOOKUP(C7,$BH$5:$BQ$15,11))))))))))","v":0},{"$f":"SUM(I6:J7)","v":0},null,{"$f":"IF(C7=\"\",\"\",IF($L$1=FALSE,(IF($C$4>$X$25,VLOOKUP(C7,$U$6:$AQ$21,X1),VLOOKUP(C7,$U$6:$AP$21,X1)-($X$23-$C$4*$X$24))),(IF($C$4>$X$25,VLOOKUP(C7,$U$6:$AQ$21,Y1),VLOOKUP(C7,$U$6:$AP$21,Y1)-($X$23-$C$4*$X$24)))))","v":""},{"$f":"IF(M6=\"\",\"\",M6-K6)","v":""},{"$f":"IF(M6=\"\",\"\",N6/K6)","v":""},{"$f":"J6","v":0},{"$f":"IF(M6=\"\",\"\",M6-P6)","v":""},{"$f":"IF(M6=\"\",\"\",Q6-I6-I7)","v":""},{"$f":"IF(M6=\"\",\"\",R6/(I6+I7))","v":""},null,0,"a",18,200,{"$f":"X6*$Y$5+X6","v":280},null,0,"a",18,{"$f":"X6","v":200},{"$f":"AD6*$AE$5+AD6","v":280},null,0,"a",18,{"$f":"X6","v":200},{"$f":"AJ6*$AK$5+AJ6","v":280},null,0,"a",18,{"$f":"X6","v":200},{"$f":"AP6*$AQ$5+AP6","v":280},null,null,"FILHO <21 ANOS",null,null,4.0000000000000001E-3,null,0,"a",18,127,null,null,null,null,null,"a","a","a","a","a","a","a","a","a","a"]
[null,{"$f":"IF(G6=1,\"IDADE DO CÔNJUGE:\",\"\")","v":""},null,null,{"$f":"IF(B7=\"\",\"\",\"ANOS\")","v":""},null,null,{"$f":"IF(G6=2,\"\",\"FIXA\")","v":""},{"$f":"IF(B7=\"\",0,VLOOKUP(C7,$AT$13:$AW$28,4))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"W6+1","v":19},"a",{"$f":"W6+5","v":23},250,350,null,{"$f":"AC6+1","v":19},"a",{"$f":"AC6+5","v":23},{"$f":"X7","v":250},350,null,{"$f":"AI6+1","v":19},"a",{"$f":"AI6+5","v":23},{"$f":"X7","v":250},350,null,{"$f":"AO6+1","v":19},"a",{"$f":"AO6+5","v":23},{"$f":"X7","v":250},350,null,null,"PAIS",null,null,0.03,null,21,"a",{"$f":"BA6+5","v":23},158,null,"RENDA",null,null,null,18,23,28,33,38,43,48,53,58]
[null,"POSSUI PAI E MÃE?",null,"PAI",null,"MÃE",false,{"$f":"IF(G8=TRUE,\"VARIÁVEL\",IF(G9=TRUE,\"VARIÁVEL\",\"\"))","v":""},{"$f":"IF(B9=\"\",0,$C$4*AW7)+IF(B10=\"\",0,$C$4*AW7)","v":0},"NÃO HÁ",{"$f":"SUM(I8:J10)","v":0},null,"PAIS E MÃES",null,null,null,null,null,null,null,{"$f":"W7+1","v":24},"a",{"$f":"W7+5","v":28},250,350,null,{"$f":"AC7+1","v":24},"a",{"$f":"AC7+5","v":28},{"$f":"X8","v":250},350,null,{"$f":"AI7+1","v":24},"a",{"$f":"AI7+5","v":28},250,350,null,{"$f":"AO7+1","v":24},"a",{"$f":"AO7+5","v":28},250,350,null,null,"IRMÃOS",null,null,0.03,null,{"$f":"BA7+1","v":24},"a",28,174,null,0,"a",1499,1,149.51999899199998,156.57051559199999,158.69180145599998,165.04339727999999,169.97262801599999,175.61304129600001,190.03288046399999,193.049275392,196.06567032000001,205.62984935999998]
[null,{"$f":"IF(G8=FALSE,\"\",\"IDADE DO PAI:\")","v":""},null,null,{"$f":"IF(B9=\"\",\"\",\"ANOS\")","v":""},null,false,{"$f":"IF(B9=\"\",\"\",\"FIXA - PAI\")","v":""},{"$f":"IF(B9=\"\",0,VLOOKUP(C9,$AT$13:$AW$28,4))","v":0},null,null,null,{"$f":"IF(C9=\"\",\"\",IF($L$1=FALSE,(IF($C$4>$X$25,VLOOKUP(C9,$U$6:$AQ$21,AJ1),VLOOKUP(C9,$U$6:$AP$21,AJ1)-($X$23-$C$4*$X$24))),(IF($C$4>$X$25,VLOOKUP(C9,$U$6:$AQ$21,AK1),VLOOKUP(C9,$U$6:$AP$21,AK1)-($X$23-$C$4*$X$24)))))","v":""},{"$f":"IF(M9=\"\",\"\",M9-(I8/(COUNTA(C9:D10))+I9))","v":""},{"$f":"IF(M9=\"\",\"\",N9/((I8/(COUNTA(C9:D10))+I9)))","v":""},{"$f":"J8","v":"NÃO HÁ"},{"$f":"M9","v":""},null,null,null,29,"a",33,300,420,null,29,"a",33,300,420,null,29,"a",33,300,420,null,29,"a",33,300,420,null,null,null,null,null,null,null,29,"a",33,206,null,{"$f":"BF8+1","v":1500},"a",1999,2,142.469482392,149.51999899199998,151.641284856,156.57051559199999,161.51200809599999,167.15242137599998,180.76298385599998,183.63223756799999,186.50149127999998,196.06567032000001]
[null,{"$f":"IF(G9=FALSE,\"\",\"IDADE DA MÃE:\")","v":""},null,null,{"$f":"IF(B10=\"\",\"\",\"ANOS\")","v":""},null,null,{"$f":"IF(B10=\"\",\"\",\"FIXA - MÃE\")","v":""},{"$f":"IF(B10=\"\",0,VLOOKUP(C10,$AT$13:$AW$28,4))","v":0},null,null,null,{"$f":"IF(C10=\"\",\"\",IF($L$1=FALSE,(IF($C$4>$X$25,VLOOKUP(C10,$U$6:$AQ$21,AJ1),VLOOKUP(C10,$U$6:$AP$21,AJ1)-($X$23-$C$4*$X$24))),(IF($C$4>$X$25,VLOOKUP(C10,$U$6:$AQ$21,AK1),VLOOKUP(C10,$U$6:$AP$21,AK1)-($X$23-$C$4*$X$24)))))","v":""},{"$f":"IF(M10=\"\",\"\",M10-(I8/(COUNTA(C9:D10))+I10))","v":""},{"$f":"IF(M10=\"\",\"\",N10/((I8/(COUNTA(C9:D10))+I10)))","v":""},null,{"$f":"M10","v":""},null,null,null,34,"a",38,300,420,null,34,"a",38,300,420,null,34,"a",38,300,420,null,34,"a",38,300,420,null,null,"CONTRIBUÇÃO FIXA",null,null,null,null,34,"a",38,238,null,2000,"a",2499,3,135.41896579199999,142.469482392,144.59076825599999,149.51999899199998,154.46149149599998,160.101904776,171.49308724800002,174.21519974400002,176.93731224000001,186.50149127999998]
[null,"POSSUI IRMÃOS?",null,"SIM",null,null,false,{"$f":"IF(G11=TRUE,\"VARIÁVEL\",IF(G12=TRUE,\"VARIÁVEL\",\"\"))","v":""},{"$f":"C4*E11*AW7","v":0},"NÃO HÁ",{"$f":"SUM(I11:J14)","v":0},null,"IRMÃOS",null,null,null,null,null,null,null,39,"a",43,350,490,null,39,"a",43,350,490,null,39,"a",43,350,490,null,39,"a",43,350,490,null,null,"FAIXA ETÁRIA",null,null,"CONTRI BUIÇÃO",null,39,"a",43,270,null,2500,"a",2999,4,129.778552512,135.41896579199999,137.52798988799998,142.469482392,147.410974896,153.05138817599999,163.768173408,166.367668224,168.96716304,176.93731224000001]
[null,{"$f":"IF(E11=0,\"\",\"1o. IRMÃO - IDADE:\")","v":""},null,null,{"$f":"IF(B12=\"\",\"\",\"ANOS\")","v":""},null,null,{"$f":"B12","v":""},{"$f":"IF(B12=\"\",0,VLOOKUP(C12,$AT$13:$AW$28,4))","v":0},null,null,null,{"$f":"IF(C12=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C12,$U$6:$AQ$21,AJ1),(VLOOKUP(C12,$U$6:$AQ$21,AK1))))","v":""},{"$f":"IF(M12=\"\",\"\",M12-(I11/E11+I12))","v":""},{"$f":"IF(M12=\"\",\"\",N12/(I11/E11+I12))","v":""},{"$f":"J11","v":"NÃO HÁ"},{"$f":"M12","v":""},null,null,null,44,"a",48,350,490,null,44,"a",48,350,490,null,44,"a",48,350,490,null,44,"a",48,350,490,null,null,null,null,null,null,null,44,"a",48,302,null,3000,"a",3999,5,122.71577414399999,129.778552512,131.88757660799999,135.41896579199999,140.34819652799999,146.00087157599998,156.043259568,158.52013670400001,160.99701383999999,168.96716304]
[null,{"$f":"IF(E11>1,\"2o. IRMÃO - IDADE:\",\"\")","v":""},null,null,{"$f":"IF(B13=\"\",\"\",\"ANOS\")","v":""},null,null,{"$f":"B13","v":""},{"$f":"IF(B13=\"\",0,VLOOKUP(C13,$AT$13:$AW$28,4))","v":0},null,null,null,{"$f":"IF(C13=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C13,$U$6:$AQ$21,AJ1),(VLOOKUP(C13,$U$6:$AQ$21,AK1))))","v":""},{"$f":"IF(M13=\"\",\"\",M13-(I11/E11+I13))","v":""},{"$f":"IF(M13=\"\",\"\",N13/(I11/E11+I13))","v":""},null,"",null,null,null,49,"a",53,400,560,null,49,"a",53,400,560,null,49,"a",53,400,560,null,49,"a",53,400,560,null,null,0,"a",18,34,null,null,null,null,null,null,4000,"a",5499,6,111.43494758399999,114.25515422400001,116.376440088,117.075360864,122.016853368,127.65726664799999,129.778552512,131.83852953599998,133.89850655999999,137.08656624]
[null,{"$f":"IF(E11>2,\"3o. IRMÃO - IDADE:\",\"\")","v":""},null,null,{"$f":"IF(B14=\"\",\"\",\"ANOS\")","v":""},null,null,{"$f":"B14","v":""},{"$f":"IF(B14=\"\",0,VLOOKUP(C14,$AT$13:$AW$28,4))","v":0},null,null,null,{"$f":"IF(C14=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C14,$U$6:$AQ$21,AJ1),(VLOOKUP(C14,$U$6:$AQ$21,AK1))))","v":""},{"$f":"IF(M14=\"\",\"\",M14-(I11/E11+I14))","v":""},{"$f":"IF(M14=\"\",\"\",N14/(I11/E11+I14))","v":""},null,"",null,null,null,54,"a",58,500,700,null,54,"a",58,500,700,null,54,"a",58,500,700,null,54,"a",58,500,700,null,null,19,"a",23,34,null,null,null,null,null,null,5500,"a",7499,7,107.204637624,108.61474094399999,110.73602680800001,111.43494758399999,116.376440088,122.016853368,123.59862143999999,125.56050432000001,127.5223872,130.71044687999998]
[null,"POSSUI FILHOS <24 ANOS?",null,"SIM",null,null,false,{"$f":"IF(G15=TRUE,\"VARIÁVEL\",IF(G16=TRUE,\"VARIÁVEL\",\"\"))","v":""},{"$f":"C4*E15*AW6","v":0},null,{"$f":"SUM(I15:J19)","v":0},null,"FILHOS < 24 ANOS",null,null,null,null,null,null,null,59,"a",63,700,980,null,59,"a",63,700,980,null,59,"a",63,700,980,null,59,"a",63,700,980,null,null,{"$f":"AV14+1","v":24},"a",{"$f":"AV14+5","v":28},34,null,null,null,null,null,null,7500,"a",null,8,101.564224344,102.974327664,105.08335176,105.794534304,110.73602680800001,116.376440088,117.418690368,119.282479104,121.14626783999999,124.33432752]
[null,{"$f":"IF(E15=0,\"\",\"1o. FILHO - IDADE:\")","v":""},null,null,{"$f":"IF(B16=\"\",\"\",\"ANOS\")","v":""},null,null,{"$f":"IF(B16=\"\",\"\",\"FIXA\")","v":""},{"$f":"IF(B16=\"\",0,VLOOKUP(C16,$AT$13:$AW$28,4))","v":0},{"$f":"IF(B16=\"\",0,IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=1,HLOOKUP(C16,$BH$5:$BQ$15,4),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=2,HLOOKUP(C16,$BH$5:$BQ$15,5),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=3,HLOOKUP(C16,$BH$5:$BQ$15,6),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=4,HLOOKUP(C16,$BH$5:$BQ$15,7),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=5,HLOOKUP(C16,$BH$5:$BQ$15,8),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=6,HLOOKUP(C16,$BH$5:$BQ$15,9),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=7,HLOOKUP(C16,$BH$5:$BQ$15,10),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=8,HLOOKUP(C16,$BH$5:$BQ$15,11))))))))))","v":0},null,null,{"$f":"IF(C16=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C16,$U$6:$AQ$21,AD1),(VLOOKUP(C16,$U$6:$AQ$21,AE1))))","v":""},{"$f":"IF(M16=\"\",\"\",M16-(I15/E15+I16+J16))","v":""},{"$f":"IF(M16=\"\",\"\",N16/(I15/E15+I16+J16))","v":""},{"$f":"J16","v":0},{"$f":"IF(M16=\"\",\"\",M16-P16)","v":""},{"$f":"IF(M16=\"\",\"\",Q16-(I15/E15+I16))","v":""},{"$f":"IF(M16=\"\",\"\",R16/(I15/E15+I16))","v":""},null,64,"a",68,700,980,null,64,"a",68,700,980,null,64,"a",68,700,980,null,64,"a",68,700,980,null,null,{"$f":"AV15+1","v":29},"a",{"$f":"AV15+5","v":33},68]
[null,{"$f":"IF(E15>1,\"2o. FILHO - IDADE:\",\"\")","v":""},null,null,"",null,null,"",{"$f":"IF(B17=\"\",0,VLOOKUP(C17,$AT$13:$AW$28,4))","v":0},{"$f":"IF(B17=\"\",0,IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=1,HLOOKUP(C17,$BH$5:$BQ$15,4),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=2,HLOOKUP(C17,$BH$5:$BQ$15,5),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=3,HLOOKUP(C17,$BH$5:$BQ$15,6),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=4,HLOOKUP(C17,$BH$5:$BQ$15,7),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=5,HLOOKUP(C17,$BH$5:$BQ$15,8),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=6,HLOOKUP(C17,$BH$5:$BQ$15,9),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=7,HLOOKUP(C17,$BH$5:$BQ$15,10),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=8,HLOOKUP(C17,$BH$5:$BQ$15,11))))))))))","v":0},null,null,{"$f":"IF(C17=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C17,$U$6:$AQ$21,AD1),(VLOOKUP(C17,$U$6:$AQ$21,AE1))))","v":""},{"$f":"IF(M17=\"\",\"\",M17-(I15/E15+I17+J17))","v":""},{"$f":"IF(M17=\"\",\"\",N17/(I15/E15+I17+J17))","v":""},{"$f":"J17","v":0},{"$f":"IF(M17=\"\",\"\",M17-P17)","v":""},{"$f":"IF(M17=\"\",\"\",Q17-(I15/E15+I17))","v":""},{"$f":"IF(M17=\"\",\"\",R17/(I15/E15+I17))","v":""},null,69,"a",73,700,980,null,69,"a",73,700,980,null,69,"a",73,700,980,null,69,"a",73,700,980,null,null,34,"a",38,68]
[null,{"$f":"IF(E15>2,\"3o. FILHO - IDADE:\",\"\")","v":""},null,null,"",null,null,"",{"$f":"IF(B18=\"\",0,VLOOKUP(C18,$AT$13:$AW$28,4))","v":0},{"$f":"IF(B18=\"\",0,IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=1,HLOOKUP(C18,$BH$5:$BQ$15,4),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=2,HLOOKUP(C18,$BH$5:$BQ$15,5),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=3,HLOOKUP(C18,$BH$5:$BQ$15,6),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=4,HLOOKUP(C18,$BH$5:$BQ$15,7),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=5,HLOOKUP(C18,$BH$5:$BQ$15,8),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=6,HLOOKUP(C18,$BH$5:$BQ$15,9),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=7,HLOOKUP(C18,$BH$5:$BQ$15,10),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=8,HLOOKUP(C18,$BH$5:$BQ$15,11))))))))))","v":0},null,null,{"$f":"IF(C18=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C18,$U$6:$AQ$21,AD1),(VLOOKUP(C18,$U$6:$AQ$21,AE1))))","v":""},{"$f":"IF(M18=\"\",\"\",M18-(I15/E15+I18+J18))","v":""},{"$f":"IF(M18=\"\",\"\",N18/(I15/E15+I18+J18))","v":""},0,{"$f":"IF(M18=\"\",\"\",M18-P18)","v":""},{"$f":"IF(M18=\"\",\"\",Q18-(I15/E15+I18))","v":""},{"$f":"IF(M18=\"\",\"\",R18/(I15/E15+I18))","v":""},null,74,"a",78,700,980,null,74,"a",78,700,980,null,74,"a",78,700,980,null,74,"a",78,700,980,null,null,39,"a",43,102]
[null,{"$f":"IF(E15>3,\"4o. FILHO - IDADE:\",\"\")","v":""},null,null,"",null,null,"",{"$f":"IF(B19=\"\",0,VLOOKUP(C19,$AT$13:$AW$28,4))","v":0},{"$f":"IF(B19=\"\",0,IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=1,HLOOKUP(C19,$BH$5:$BQ$15,4),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=2,HLOOKUP(C19,$BH$5:$BQ$15,5),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=3,HLOOKUP(C19,$BH$5:$BQ$15,6),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=4,HLOOKUP(C19,$BH$5:$BQ$15,7),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=5,HLOOKUP(C19,$BH$5:$BQ$15,8),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=6,HLOOKUP(C19,$BH$5:$BQ$15,9),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=7,HLOOKUP(C19,$BH$5:$BQ$15,10),IF(VLOOKUP($C$4,$BD$8:$BG$15,4)=8,HLOOKUP(C19,$BH$5:$BQ$15,11))))))))))","v":0},null,null,{"$f":"IF(C19=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C19,$U$6:$AQ$21,AD1),(VLOOKUP(C19,$U$6:$AQ$21,AE1))))","v":""},{"$f":"IF(M19=\"\",\"\",M19-(I15/E15+I19+J19))","v":""},{"$f":"IF(M19=\"\",\"\",N19/(I15/E15+I19+J19))","v":""},0,{"$f":"IF(M19=\"\",\"\",M19-P19)","v":""},{"$f":"IF(M19=\"\",\"\",Q19-(I15/E15+I19))","v":""},{"$f":"IF(M19=\"\",\"\",R19/(I15/E15+I19))","v":""},null,79,"a",83,700,980,null,79,"a",83,700,980,null,79,"a",83,700,980,null,79,"a",83,700,980,null,null,44,"a",48,102]
[null,"POSSUI FILHOS >=24 ANOS?",null,"SIM",null,null,false,{"$f":"IF(B21=\"\",\"\",\"FIXA\")","v":""},{"$f":"IF(B21=\"\",0,VLOOKUP(C21,$AY$6:$BB$12,4))","v":0},"NÃO HÁ",{"$f":"SUM(I20:J24)","v":0},null,"FILHOS > =24 ANOS",null,null,null,null,null,null,null,84,"a",88,700,980,null,84,"a",88,700,980,null,84,"a",88,700,980,null,84,"a",88,700,980,null,null,49,"a",53,136]
[null,{"$f":"IF(E20=0,\"\",\"1o. FILHO - IDADE:\")","v":""},null,null,{"$f":"IF(B21=\"\",\"\",\"ANOS\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(C21=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C21,$U$6:$AQ$21,AP1),(VLOOKUP(C21,$U$6:$AQ$21,AQ1))))","v":""},{"$f":"IF(M21=\"\",\"\",M21-I20)","v":""},{"$f":"IF(M21=\"\",\"\",N21/I20)","v":""},{"$f":"J20","v":"NÃO HÁ"},{"$f":"M21","v":""},null,null,null,89,"a","...",700,980,null,89,"a","...",700,980,null,89,"a","...",700,980,null,89,"a","...",700,980,null,null,{"$f":"AV20+1","v":54},"a",{"$f":"AV20+5","v":58},136]
[null,{"$f":"IF(E20>1,\"2o. FILHO - IDADE:\",\"\")","v":""},null,null,"",null,null,{"$f":"IF(B22=\"\",\"\",\"FIXA\")","v":""},{"$f":"IF(B22=\"\",0,VLOOKUP(C22,$AY$6:$BB$12,4))","v":0},null,null,null,{"$f":"IF(C22=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C22,$U$6:$AQ$21,AP1),(VLOOKUP(C22,$U$6:$AQ$21,AQ1))))","v":""},{"$f":"IF(M22=\"\",\"\",M22-I22)","v":""},{"$f":"IF(M22=\"\",\"\",N22/I22)","v":""},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":"AV21+1","v":59},"a",{"$f":"AV21+5","v":63},170]
[null,{"$f":"IF(E20>2,\"3o. FILHO - IDADE:\",\"\")","v":""},null,null,"",null,null,{"$f":"IF(B23=\"\",\"\",\"FIXA\")","v":""},{"$f":"IF(B23=\"\",0,VLOOKUP(C23,$AY$6:$BB$12,4))","v":0},null,null,null,{"$f":"IF(C23=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C23,$U$6:$AQ$21,AP1),(VLOOKUP(C23,$U$6:$AQ$21,AQ1))))","v":""},{"$f":"IF(M23=\"\",\"\",M23-I23)","v":""},{"$f":"IF(M23=\"\",\"\",N23/I23)","v":""},null,"",null,null,null,"TITULAR",null,null,250,null,null,"CÔNJUGE",null,null,250,null,null,"PAIS E MÃES",null,null,250,null,null,null,null,null,null,null,null,null,64,"a",68,170]
[null,{"$f":"IF(E20>3,\"4o. FILHO - IDADE:\",\"\")","v":""},null,null,"",null,null,{"$f":"IF(B24=\"\",\"\",\"FIXA\")","v":""},{"$f":"IF(B24=\"\",0,VLOOKUP(C24,$AY$6:$BB$12,4))","v":0},null,null,null,{"$f":"IF(C24=\"\",\"\",IF($L$1=FALSE,VLOOKUP(C24,$U$6:$AQ$21,AP1),(VLOOKUP(C24,$U$6:$AQ$21,AQ1))))","v":""},{"$f":"IF(M24=\"\",\"\",M24-I24)","v":""},{"$f":"IF(M24=\"\",\"\",N24/I24)","v":""},null,"",null,null,null,"REDUTOR",null,null,0.02,null,null,"REDUTOR",null,null,0.02,null,null,"REDUTOR",null,null,0.02,null,null,null,null,null,null,null,null,null,69,"a",73,204]
[null,"POSSUI NETOS (<20 ANOS)?",null,"SIM",null,null,false,{"$f":"IF(E25<1,\"\",\"FIXA\")","v":""},{"$f":"E25*BB6","v":0},"NÃO HÁ",{"$f":"SUM(I25:J26)","v":0},null,{"$f":"IF(E25=\"\",\"\",IF($L$1=FALSE,AP6*E25,AQ6*E25))","v":""},{"$f":"IF(M25=\"\",\"\",M25-K25)","v":""},{"$f":"IF(M25=\"\",\"\",N25/K25)","v":""},{"$f":"J25","v":"NÃO HÁ"},{"$f":"M25","v":""},null,null,null,"TETO:",null,null,{"$f":"X23/X24","v":12500},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,"a",78,204]
[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,null,null,null,null,null,null,null,null,79,"a",83,238]
[null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(I4:I26)","v":0},{"$f":"SUM(J4:J26)","v":0},0,null,{"$f":"IF(C5=\"\",\"\",SUM(M4:M26))","v":""},{"$f":"IF(M27=\"\",\"\",M27-K27)","v":""},{"$f":"IF(M27=\"\",\"\",N27/K27)","v":""},{"$f":"IF(M27=\"\",\"\",SUM(P4:P26))","v":""},{"$f":"IF(M27=\"\",\"\",SUM(Q4:Q26))","v":""},{"$f":"IF(M27=\"\",\"\",Q27-I27)","v":""},{"$f":"IF(M27=\"\",\"\",R27/I27)","v":""},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,84,"a",88,238]
[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,null,null,null,null,null,null,null,null,89,"a",null,272]