{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DADOS","QCI","CRONO","RRE","Ofício","Listas"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":102,"comments":3,"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":"DADOS","index":0,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[[69,2,69,4],[73,2,73,4],[74,2,74,4],[75,2,75,4],[76,2,76,4],[70,2,70,4],[71,2,71,4],[72,2,72,4],[55,2,55,4],[56,2,56,4],[68,2,68,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[60,2,60,4],[64,2,64,4],[65,2,65,4],[66,2,66,4],[67,2,67,4],[61,2,61,4],[62,2,62,4],[63,2,63,4],[24,7,24,9],[26,5,26,6],[24,5,24,6],[21,4,21,5],[53,2,53,4],[27,5,27,6],[27,0,27,4],[23,0,23,3],[24,0,24,3],[26,0,26,4],[21,2,21,3],[20,4,20,5],[20,6,20,8],[23,5,23,6],[21,6,21,8],[20,2,20,3],[0,1,1,9],[10,0,10,9],[12,0,12,9],[2,0,2,9],[8,0,8,5],[4,0,4,9],[6,0,6,9]]}
[41211,"QCI - Quadro de Composição do Investimento / RRE - Relatório Resumo do Empreendimento"]
["v009"]
["INSTRUÇÕES DE USO E PREENCHIMENTO"]
[]
["1. Este documento somente pode ser utilizado nas versões do Excel 2003 ou superior. Não deve ser utilizado versões do BROffice. O Documento deve ser salvo SOMENTE em extensão habilitada para macros (.xls ou .xlsm). Se o documento for salvo na extensão .xlsx, o arquivo será INUTILIZADO."]
[]
["2. Para funcionamento pleno desse arquivo, a Segurança de Macros do Excel deve ser habilitada."]
["2.1  Na Versão Excel 2003, selecione na Faixa de Opções: Ferramentas --> Macro --> Segurança --> Na aba Nível de Segurança selecione a Opção \"Baixo\" --> Clique em OK --> Feche e abra o Excel novamente para utilizar a Planilha."]
["2.2 Na Versão Excel 2007 ou superior, selecione na Faixa de Opções: Arquivo --> Opções --> Central de Confiabilidade --> Configurações da Central de Confiabilidade --> Configurações de Macro --> Habilitar todas as Macros --> Clique em OK --> Feche e abra o excel novamente para utilizar a Planilha."]
[]
["3. O Preenchimento deve ser feito somente nas células em amarelo. As outras células são de preenchimento Automático."]
[]
["4. Ordem de Preenchimento"]
["4.1. Fase de Análise"]
["4.1.1. Primeiramente, preencha no Quadro abaixo os Dados do TC/CR:"]
[]
[]
[]
[]
[]
["Nº OPERAÇÃO","Nº SICONV","GESTOR",null,"PROGRAMA",null,"AÇÃO / MODALIDADE",null,null,"RECURSO"]
["1.037.474-20/2017","844520/2017","Ministerio das Cidades",null,"Planejamento Urbano",null,"Contrato de repasse",null,null,"OGU não-PAC"]
[]
["PROPONENTE / TOMADOR",null,null,null,"MUNICÍPIO / UF","LOCALIDADE / ENDEREÇO"]
["Município de Bom Jesus",null,null,null,"Bom Jesus / SC","Rua Domingos Michelin",null,"VALORES CONTRATADOS (R$)"]
[]
["OBJETO",null,null,null,null,"APELIDO DO EMPREENDIMENTO",null,{"$f":"IF($J$22=\"FGTS\",\"FINANCIAMENTO\",\"REPASSE\")","v":"REPASSE"},"CONTRAPARTIDA","INVESTIMENTO"]
["Implantação de pavimentação asfaltica em vias urbanas do Município de Bom Jesus SC.",null,null,null,null,null,null,245850,11145.37,{"$f":"H28+I28","v":256995.37}]
[]
[]
[]
[]
[]
["4.1.2. Digite abaixo os valores mínimos de Contrapartida exigidos pelo Programa."]
[]
[null,"% MÍNIMO","VALOR ABSOLUTO (R$)"]
[null,1E-3]
[]
[]
["4.1.3. Clique no botão \"Preencher QCI\" abaixo."]
[]
[]
[]
[]
[]
[]
["4.1.4. Preencha os Campos das Metas na Aba QCI - Quadro de Composição de Investimento."]
["4.1.5. Preencha os Campos das Parcelas de Desembolso na Aba Crono - CFF-CT - Cronograma Físico-Financeiro do Contrato."]
[]
["4.2. Fase de Licitação"]
["4.2.1. Atualize os Dados do QCI e Cronograma Físico-Financeiro."]
["4.2.2. Insira no Quadro abaixo os dados dos CTEFs."]
[]
[null,"CTEF:","Nome do Fornecedor:",null,null,"CNPJ / CPF:"]
[null,"Adm. Direta"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4.3. Fase de Solicitação de Recursos"]
["4.3.1. Preencha os Dados da Medição na Aba RRE - Relatório Resumo do Empreendimento."]
["4.3.2. Preencha os Campos na Aba Ofício, para o Ofício de Solicitação de Recursos e Relação de Fornecedores."]

{"sheet":"QCI","index":1,"n_rows":37,"n_cols":35,"rows_kept":37,"cut":false,"hidden":false,"merged":[[8,34,9,34],[8,16,9,16],[8,11,9,11],[8,12,9,12],[8,21,9,21],[8,23,9,23],[8,33,9,33],[8,24,9,24],[8,18,9,18],[2,1,2,13],[8,13,9,13],[5,10,6,10],[8,1,9,1],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,2,9,3],[8,6,9,6],[8,5,9,5],[5,6,6,9],[8,4,9,4],[13,30,13,31],[14,30,14,31],[8,10,9,10],[8,22,9,22],[8,17,9,17],[8,14,9,14],[9,26,9,28],[8,19,9,19],[13,2,14,3],[31,8,33,9],[36,3,36,5],[36,8,36,11],[35,8,35,11],[34,2,34,5],[35,3,35,5],[27,1,27,3],[28,1,29,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sumvalue1",null,null,null,null,null,null,"sumheight1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grau de Sigilo"]
[null,"QCI - QUADRO DE COMPOSIÇÃO DO INVESTIMENTO",null,null,null,null,null,null,null,null,null,null,null,null,"#PUBLICO"]
[]
[]
[null,null,null,null,null,null,{"$f":"CHOOSE(1+LOG(1+2*(OR(AND($O$15>0,$M$14<$Z$7),$M$15<ROUND($AA$7*$O$15,2)))+4*OR($L$7<0,$M$7<0)+8*(COUNTIF($L$15:$L$35,\"<0\")>0),2),\"\",\"ERRO: CONTRAPARTIDA MENOR QUE A MÍNIMA\",\"ERRO: SALDO NEGATIVO\",\"ERRO: VALORES DE REPASSE NEGATIVOS\")","v":""},null,null,null,"Saldo a Reprogramar",{"$f":"CRONO!$J$11","v":"Repasse (R$)"},"Contrapartida (R$)",null,null,null,null,null,"% Rateio CP Fin:",null,null,null,null,null,null,"% CP Min Prog:","% CP Absoluta:","% CP Max Rep:","% Maior:"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"DADOS!H$28-L$15","v":0},{"$f":"DADOS!I$28-M$15","v":0},null,null,null,null,null,{"$f":"IF(OR($O$15=CalculadoInv,$O$15=0),0,MIN(MAX(0,($AC$7*$O$15-CalculadoCPFin)/($O$15-CalculadoInv)),1))","v":4.3367979742203119E-2},null,null,null,null,null,null,{"$f":"ROUND(DADOS!$B$37,4)","v":1E-3},{"$f":"IF($O$15=0,0,DADOS!$C$37/$O$15)","v":0},{"$f":"IF($O$15=0,0,($O$15-$AC$15-DADOS!$H$28)/$O$15)","v":4.3367979742203119E-2},{"$f":"MAX(Z7:AB7)","v":4.3367979742203119E-2}]
[]
[null,"Etapa","Meta / \nSub-Meta",null,"Item de Investimento","Sub-Item de Investimento","Descrição da Meta / Sub-Meta","Situação","Quantidade","Unid.","Lote de Licitação / nº CTEF",{"$f":"IF(DADOS!$J$22=\"FGTS\",\"Financiamento\",\"Repasse\")","v":"Repasse"},"Contrapartida Financeira","Outros","Investimento",null,"Investimento","Divisão do Investimento","Contrapartida Financeira",{"$f":"N9","v":"Outros"},null,"Nº Meta","Nº Sub-Meta","Altura","Somar Meta",null,null,null,null,null,null,null,null,"Lotes","Total Etapa"]
[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,"Valores Previstos"]
[null,1,"Meta",{"$f":"CONCATENATE($V11,\".\",IF($C11=\"Sub-Meta\",$W11,\"\"))","v":"1."},null,null,null,null,null,{"$f":"VLOOKUP($F11,OFFSET(Listas!$A$2,1,MATCH(QCI!$E11,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF($Y11,ROUND(O11,2)-ROUND(N11,2)-ROUND(M11,2),SUM(OFFSET(L11,1,0,$X11)))","v":0},{"$f":"IF($Y11,AB11-ROUND($AF11,2),SUM(OFFSET(M11,1,0,$X11)))","v":0},{"$f":"IF($Y11,AC11,SUM(OFFSET(N11,1,0,$X11)))","v":0},{"$f":"IF($Y11,ROUND($Q11,2),SUM(OFFSET(O11,1,0,$X11)))","v":0},null,0,"Proporcional",{"$f":"IF($K11=\"Adm. Direta\",0,$O11)","v":0},{"$f":"IF($K11=\"Adm. Direta\",$O11,0)","v":0},null,{"$f":"IF($C11=\"Sub-Meta\",OFFSET(V11,-1,0),OFFSET(V11,-1,0)+1)","v":1},{"$f":"IF($C11=\"Sub-Meta\",OFFSET(W11,-1,0)+1,0)","v":0},{"$f":"IF(Y11,0,COUNTIF(OFFSET($V11,1,0):$V$26,$V11))","v":0},{"$f":"NOT(AND($C11<>\"Sub-Meta\",OFFSET($C11,1,0)=\"Sub-Meta\"))","v":true},null,{"$f":"IF($Y11,$O11-$AB11-$AC11,\"-\")","v":0},{"$f":"IF($Y11,IF($R11=\"Calculado\",ROUND($S11,2),ROUND($S$7*$O11,2)),\"-\")","v":0},{"$f":"IF($Y11,IF($R11=\"Calculado\",ROUND($T11,2),0),\"-\")","v":0},null,{"$f":"AND($Y11,$S$7>0,$S$7<1,O11>0,$R11<>\"Calculado\",OR($AC$7=$AB$7,$AC$7=$AA$7,$AC$7=$Z$7))","v":false},{"$f":"IF(AND($AE11,O11>0,COUNTIF(OFFSET($AE11,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,{"$f":"CONCATENATE(\"Lote \",ROW(A11)-ROW($A$15))","v":"Lote -4"},{"$f":"IF($C11=\"Meta\",$B11,0)","v":1}]
[]
[]
[null,null,"TOTAL",null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(L15/$O15),0,ROUND(L15/$O15,4))","v":0.95660000000000001},{"$f":"IF(ISERROR(M15/$O15),0,ROUND(M15/$O15,4))","v":4.3400000000000001E-2},{"$f":"IF(ISERROR(N15/$O15),0,ROUND(N15/$O15,4))","v":0},{"$f":"IF(ISERROR(O15/$O15),0,ROUND(O15/$O15,4))","v":1},null,null,null,null,null,null,null,null,null,null,null,"Repasse","CP Financeira","CP Fís / Outros",null,"Arred"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUMIF($Y$15:$Y$26,TRUE,L$15:L$26),2)","v":245850},{"$f":"ROUND(SUMIF($Y$15:$Y$26,TRUE,M$15:M$26),2)","v":11145.37},{"$f":"ROUND(SUMIF($Y$15:$Y$26,TRUE,N$15:N$26),2)","v":0},{"$f":"ROUND(SUMIF($Y$16:$Y$26,TRUE,O$16:O$26),2)","v":256995.37},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUMIF($Y$16:$Y$26,TRUE,AA$16:AA$26),2)","v":245850},{"$f":"ROUND(SUMIF($Y$16:$Y$26,TRUE,AB$16:AB$26),2)","v":11145.37},{"$f":"ROUND(SUMIF($Y$16:$Y$26,TRUE,AC$16:AC$26),2)","v":0},null,null,null,null,"Adm. Direta"]
[null,1,"Meta",{"$f":"CONCATENATE($V16,\".\",IF($C16=\"Sub-Meta\",$W16,\"\"))","v":"1."},"Pavimentação","Capeamento de vias","Capeamento asfaltico da Rua Domingos Michelin","Em Análise",4134,{"$f":"VLOOKUP($F16,OFFSET(Listas!$A$2,1,MATCH(QCI!$E16,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":"m²"},"Lote 1",{"$f":"IF($Y16,ROUND(O16,2)-ROUND(N16,2)-ROUND(M16,2),SUM(OFFSET(L16,1,0,$X16)))","v":245850},{"$f":"IF($Y16,AB16-ROUND($AF16,2),SUM(OFFSET(M16,1,0,$X16)))","v":11145.37},{"$f":"IF($Y16,AC16,SUM(OFFSET(N16,1,0,$X16)))","v":0},{"$f":"IF($Y16,ROUND($Q16,2),SUM(OFFSET(O16,1,0,$X16)))","v":256995.37},null,256995.37,"Proporcional",{"$f":"IF($K16=\"Adm. Direta\",0,$O16)","v":256995.37},{"$f":"IF($K16=\"Adm. Direta\",$O16,0)","v":0},null,{"$f":"IF($C16=\"Sub-Meta\",OFFSET(V16,-1,0),OFFSET(V16,-1,0)+1)","v":1},{"$f":"IF($C16=\"Sub-Meta\",OFFSET(W16,-1,0)+1,0)","v":0},{"$f":"IF(Y16,0,COUNTIF(OFFSET($V16,1,0):$V$26,$V16))","v":0},{"$f":"NOT(AND($C16<>\"Sub-Meta\",OFFSET($C16,1,0)=\"Sub-Meta\"))","v":true},null,{"$f":"IF($Y16,$O16-$AB16-$AC16,\"-\")","v":245850},{"$f":"IF($Y16,IF($R16=\"Calculado\",ROUND($S16,2),ROUND($S$7*$O16,2)),\"-\")","v":11145.37},{"$f":"IF($Y16,IF($R16=\"Calculado\",ROUND($T16,2),0),\"-\")","v":0},null,{"$f":"AND($Y16,$S$7>0,$S$7<1,O16>0,$R16<>\"Calculado\",OR($AC$7=$AB$7,$AC$7=$AA$7,$AC$7=$Z$7))","v":true},{"$f":"IF(AND($AE16,O16>0,COUNTIF(OFFSET($AE16,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,{"$f":"CONCATENATE(\"Lote \",ROW(A16)-ROW($A$15))","v":"Lote 1"},{"$f":"IF($C16=\"Meta\",$B16,0)","v":1}]
[null,1,"Meta",{"$f":"CONCATENATE($V17,\".\",IF($C17=\"Sub-Meta\",$W17,\"\"))","v":"2."},null,null,null,null,null,{"$f":"VLOOKUP($F17,OFFSET(Listas!$A$2,1,MATCH(QCI!$E17,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF($Y17,ROUND(O17,2)-ROUND(N17,2)-ROUND(M17,2),SUM(OFFSET(L17,1,0,$X17)))","v":0},{"$f":"IF($Y17,AB17-ROUND($AF17,2),SUM(OFFSET(M17,1,0,$X17)))","v":0},{"$f":"IF($Y17,AC17,SUM(OFFSET(N17,1,0,$X17)))","v":0},{"$f":"IF($Y17,ROUND($Q17,2),SUM(OFFSET(O17,1,0,$X17)))","v":0},null,0,"Proporcional",0,0,null,{"$f":"IF($C17=\"Sub-Meta\",OFFSET(V17,-1,0),OFFSET(V17,-1,0)+1)","v":2},{"$f":"IF($C17=\"Sub-Meta\",OFFSET(W17,-1,0)+1,0)","v":0},{"$f":"IF(Y17,0,COUNTIF(OFFSET($V17,1,0):$V$26,$V17))","v":0},{"$f":"NOT(AND($C17<>\"Sub-Meta\",OFFSET($C17,1,0)=\"Sub-Meta\"))","v":true},null,{"$f":"IF($Y17,$O17-$AB17-$AC17,\"-\")","v":0},{"$f":"IF($Y17,IF($R17=\"Calculado\",ROUND($S17,2),ROUND($S$7*$O17,2)),\"-\")","v":0},{"$f":"IF($Y17,IF($R17=\"Calculado\",ROUND($T17,2),0),\"-\")","v":0},null,{"$f":"AND($Y17,$S$7>0,$S$7<1,O17>0,$R17<>\"Calculado\",OR($AC$7=$AB$7,$AC$7=$AA$7,$AC$7=$Z$7))","v":false},{"$f":"IF(AND($AE17,O17>0,COUNTIF(OFFSET($AE17,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,{"$f":"CONCATENATE(\"Lote \",ROW(A17)-ROW($A$15))","v":"Lote 2"},{"$f":"IF($C17=\"Meta\",$B17,0)","v":1}]
[null,1,"Meta","3.",null,null,null,null,null,{"$f":"VLOOKUP($F18,OFFSET(Listas!$A$2,1,MATCH(QCI!$E18,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,3,0,{"$f":"IF(Y18,0,COUNTIF(OFFSET($V18,1,0):$V$26,$V18))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE18,O18>0,COUNTIF(OFFSET($AE18,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 3",1]
[null,1,"Meta","4.",null,null,null,null,null,{"$f":"VLOOKUP($F19,OFFSET(Listas!$A$2,1,MATCH(QCI!$E19,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,4,0,{"$f":"IF(Y19,0,COUNTIF(OFFSET($V19,1,0):$V$26,$V19))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE19,O19>0,COUNTIF(OFFSET($AE19,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 4",1]
[null,1,"Meta","5.",null,null,null,null,null,{"$f":"VLOOKUP($F20,OFFSET(Listas!$A$2,1,MATCH(QCI!$E20,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,5,0,{"$f":"IF(Y20,0,COUNTIF(OFFSET($V20,1,0):$V$26,$V20))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE20,O20>0,COUNTIF(OFFSET($AE20,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 5",1]
[null,1,"Meta","6.",null,null,null,null,null,{"$f":"VLOOKUP($F21,OFFSET(Listas!$A$2,1,MATCH(QCI!$E21,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,6,0,{"$f":"IF(Y21,0,COUNTIF(OFFSET($V21,1,0):$V$26,$V21))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE21,O21>0,COUNTIF(OFFSET($AE21,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 6",1]
[null,1,"Meta","7.",null,null,null,null,null,{"$f":"VLOOKUP($F22,OFFSET(Listas!$A$2,1,MATCH(QCI!$E22,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,7,0,{"$f":"IF(Y22,0,COUNTIF(OFFSET($V22,1,0):$V$26,$V22))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE22,O22>0,COUNTIF(OFFSET($AE22,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 7",1]
[null,1,"Meta","8.",null,null,null,null,null,{"$f":"VLOOKUP($F23,OFFSET(Listas!$A$2,1,MATCH(QCI!$E23,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,8,0,{"$f":"IF(Y23,0,COUNTIF(OFFSET($V23,1,0):$V$26,$V23))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE23,O23>0,COUNTIF(OFFSET($AE23,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 8",1]
[null,1,"Meta","9.",null,null,null,null,null,{"$f":"VLOOKUP($F24,OFFSET(Listas!$A$2,1,MATCH(QCI!$E24,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,9,0,{"$f":"IF(Y24,0,COUNTIF(OFFSET($V24,1,0):$V$26,$V24))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE24,O24>0,COUNTIF(OFFSET($AE24,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 9",1]
[null,1,"Meta","10.",null,null,null,null,null,{"$f":"VLOOKUP($F25,OFFSET(Listas!$A$2,1,MATCH(QCI!$E25,Listas!$2:$2,0)-1,100,50),2,FALSE)","v":{"$error":"#N/A"}},null,0,0,0,0,null,0,"Proporcional",0,0,null,10,0,{"$f":"IF(Y25,0,COUNTIF(OFFSET($V25,1,0):$V$26,$V25))","v":0},true,null,0,0,0,null,false,{"$f":"IF(AND($AE25,O25>0,COUNTIF(OFFSET($AE25,1,0):$AE$26,TRUE)=0),CHOOSE(1+LOG(1+2*($AC$7=$Z$7)+4*($AC$7=$AA$7)+8*($AC$7=$AB$7),2),0,$AB$15-ROUND(DADOS!$B$37*$O$15,2),$AB$15-DADOS!$C$37,DADOS!$H$28-$AA$15),0)","v":0},null,"Lote 10",1]
[]
[]
[null,"Observações:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL - ETAPA",null,1,{"$f":"SUMIF($AI$15:$AI$26,$K32,L$15:L$26)","v":245850},11145.37,0,256995.37]
[null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(K33,-1,0)+1","v":2},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"OFFSET(K34,-1,0)+1","v":3},0,0,0,0]
[null,null,"Representante Tomador / Agente Promotor"]
[null,null,"Nome:","Rafael Calza",null,null,null,"Local:","Bom Jesus - SC"]
[null,null,"Cargo:","Prefeito Municipal",null,null,null,"Data:",{"$f":"TODAY()","v":"2018-01-25"}]

{"sheet":"CRONO","index":2,"n_rows":79,"n_cols":24,"rows_kept":79,"cut":false,"hidden":false,"merged":[[4,4,5,6],[19,7,20,7],[14,7,18,7],[7,4,8,4],[7,5,8,6],[19,4,20,4],[29,8,33,8],[39,8,43,8],[54,8,58,8],[24,4,25,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[34,5,35,5],[34,6,35,6],[39,6,40,6],[44,5,45,5],[44,6,45,6],[39,5,40,5],[49,4,50,4],[49,5,50,5],[49,6,50,6],[1,10,1,16],[2,10,2,16],[7,8,8,8],[9,7,13,7],[7,7,8,7],[19,8,23,8],[49,7,50,7],[39,7,40,7],[44,4,45,4],[29,4,30,4],[29,5,30,5],[29,6,30,6],[29,7,30,7],[34,4,35,4],[49,8,53,8],[44,8,48,8],[44,7,45,7],[19,5,20,5],[19,6,20,6],[34,8,38,8],[24,8,28,8],[78,13,78,15],[76,4,76,6],[76,7,76,9],[76,12,76,15],[77,4,77,6],[77,13,77,15],[77,7,77,9],[64,7,65,7],[59,7,60,7],[59,8,63,8],[72,4,73,9],[64,4,65,4],[64,5,65,5],[64,6,65,6],[71,4,71,6],[64,8,68,8],[59,4,60,4],[59,5,60,5],[59,6,60,6],[39,4,40,4],[34,7,35,7],[54,4,55,4],[54,5,55,5],[54,6,55,6],[54,7,55,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QCI!$O$2","v":"Grau de Sigilo"}]
[null,null,null,null,null,null,null,null,null,null,"CFF-CT - CRONOGRAMA FÍSICO FINANCEIRO DO CONTRATO",null,null,null,null,null,null,{"$f":"QCI!$O$3","v":"#PUBLICO"}]
[]
[]
[null,"Informação da 1ª Coluna",null,null,{"$f":"CHOOSE(1+LOG(1+2*(OFFSET(S16,0,-1)<>$I$16)+4*(COUNTIF($K$15:$S$15,\">1\")>0)+8*(OFFSET(S19,0,-1)<>$I$19)+16*(ROUND($I$19,2)=0),2),\"\",\"ERRO: DIVISÃO DO INVESTIMENTO NÃO CONFERE\",\"ERRO: PARCELAS MAIORES QUE 100%\",\"ERRO: CRONOGRAMA NÃO FECHA EM 100%\",\"\")","v":""},null,null,null,{"$f":"IF($B$6=2,\"Qtde de Medições realizadas\",\"\")","v":""},{"$f":"IF($B$6=2,\"Reinício Previsto\",\"Início Previsto\")","v":"Início Previsto"}]
[null,1,null,null,null,null,null,null,1,"2017-12-01"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($B$6=2,$I$6>0),$I$6-1,0)","v":0},{"$f":"OFFSET(K7,0,-1)+1","v":1},2,3,4,5,6,7,8,null,null,null,null,null,{"$f":"OFFSET(X7,0,-1)+1","v":1}]
[null,null,null,null,"Etapa","Meta / \nSub-Meta",null,"Descrição da Meta / Sub-Meta","Valores Totais (R$)",null,{"$f":"IF(K7=0,CONCATENATE(\"Parcela \",$I$6),CONCATENATE(\"Parcela \",K7))","v":"Parcela 1"},{"$f":"IF(L7=0,CONCATENATE(\"Parcela \",$I$6),CONCATENATE(\"Parcela \",L7))","v":"Parcela 2"},{"$f":"IF(M7=0,CONCATENATE(\"Parcela \",$I$6),CONCATENATE(\"Parcela \",M7))","v":"Parcela 3"},"Parcela 4","Parcela 5","Parcela 6","Parcela 7","Parcela 8",null,null,null,null,null,{"$f":"IF(X7=0,CONCATENATE(\"Parcela \",$I$6),CONCATENATE(\"Parcela \",X7))","v":"Parcela 1"}]
["Altura","SOMASE","Valores",null,null,null,null,null,null,null,{"$f":"IF(AND($B$6=2,$I$6>0,J8=0),\"Executado\",DATE(YEAR($J$6),MONTH($J$6)+K7-IF(AND($B$6=2,$I$6>0),$I$6,0),1))","v":"2018-01-01"},"2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01",null,null,null,null,null,{"$f":"IF(AND($B$6=2,$I$6>0,W8=0),\"Executado\",DATE(YEAR($J$6),MONTH($J$6)+X7-IF(AND($B$6=2,$I$6>0),$I$6,0),1))","v":"2018-01-01"}]
[null,null,null,null,null,null,null,"Parcela",0,"(%)",{"$f":"IF(COLUMN()-COLUMN($J$8)>1,K15-J15,K15)","v":0.36859999999999998},0.43790000000000001,0.19350000000000001,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(COLUMN()-COLUMN($J$8)>1,X15-W15,X15)","v":1}]
[null,{"$f":"J11","v":"Repasse (R$)"},null,null,null,null,null,null,0,{"$f":"IF(DADOS!$J$22=\"FGTS\",\"Financ. (R$)\",\"Repasse (R$)\")","v":"Repasse (R$)"},{"$f":"IF(COLUMN()-COLUMN($J$8)>1,K16-J16,K16)","v":90619.010000000009},107651.41,47579.579999999987,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(COLUMN()-COLUMN($J$8)>1,X16-W16,X16)","v":245850}]
[null,{"$f":"J12","v":"CP Fin. (R$)"},null,null,null,null,null,null,0,"CP Fin. (R$)",{"$f":"IF(COLUMN()-COLUMN($J$8)>1,K17-J17,K17)","v":4108.12},4880.28,2156.9700000000012,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(COLUMN()-COLUMN($J$8)>1,X17-W17,X17)","v":11145.37}]
[null,"Outros (R$)",null,null,null,null,null,null,0,{"$f":"IF(QCI!$N$9=\"Outros\",\"Outros (R$)\",\"CP Fis. (R$)\")","v":"Outros (R$)"},{"$f":"IF(COLUMN()-COLUMN($J$8)>1,K18-J18,K18)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(COLUMN()-COLUMN($J$8)>1,X18-W18,X18)","v":0}]
[null,"Invest. (R$)",null,null,null,null,null,null,0,"Invest. (R$)",{"$f":"IF(COLUMN()-COLUMN($J$8)>1,K19-J19,K19)","v":94727.13},112531.69,49736.549999999988,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(COLUMN()-COLUMN($J$8)>1,X19-W19,X19)","v":256995.37}]
[null,null,null,null,null,null,null,"Acumulado",0,"(%)",{"$f":"ROUND(K19/$I19,4)","v":0.36859999999999998},0.80649999999999999,1,1,1,1,1,1,null,null,null,null,null,{"$f":"ROUND(X19/$I19,4)","v":1}]
[null,"Repasse (R$)",null,null,null,null,null,null,{"$f":"QCI!$L$15","v":245850},{"$f":"J11","v":"Repasse (R$)"},{"$f":"IF(K19=$I$19,$I$16,ROUND(K19,2)-ROUND(K18,2)-ROUND(K17,2))","v":90619.010000000009},198270.42,245850,245850,245850,245850,245850,245850,null,null,null,null,null,{"$f":"IF(X19=$I$19,$I$16,ROUND(X19,2)-ROUND(X18,2)-ROUND(X17,2))","v":245850}]
[{"$f":"ROW($A$70)-ROW()-1","v":52},"CP Fin. (R$)",null,null,null,null,null,null,{"$f":"QCI!$M$15","v":11145.37},"CP Fin. (R$)",{"$f":"IF(K$14<SumCrono-IF(ISNUMBER(J17),J17,0),K$14+IF(ISNUMBER(J17),J17,0),MAX(SumCrono,IF(ISNUMBER(J17),J17,0)))","v":4108.12},8988.4,11145.37,11145.37,11145.37,11145.37,11145.37,11145.37,null,null,null,null,null,{"$f":"IF(X$14<SumCrono-IF(ISNUMBER(W17),W17,0),X$14+IF(ISNUMBER(W17),W17,0),MAX(SumCrono,IF(ISNUMBER(W17),W17,0)))","v":11145.37}]
[{"$f":"ROW($A$70)-ROW()-1","v":51},"Outros (R$)",null,null,null,null,null,null,{"$f":"QCI!$N$15","v":0},{"$f":"IF(QCI!$N$9=\"Outros\",\"Outros (R$)\",\"CP Fis. (R$)\")","v":"Outros (R$)"},0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(X$14<SumCrono-IF(ISNUMBER(W18),W18,0),X$14+IF(ISNUMBER(W18),W18,0),MAX(SumCrono,IF(ISNUMBER(W18),W18,0)))","v":0}]
[{"$f":"ROW($A$70)-ROW()-1","v":50},"Acum. Inv. (R$)",null,null,null,null,null,null,{"$f":"IF(QCI!$O$15=0,10^-12,QCI!$O$15)","v":256995.37},"Acum. Inv. (R$)",{"$f":"IF(ISNUMBER(J19),IF(J19>SumCrono,J19,SumCrono),SumCrono)","v":94727.13},207258.82,256995.37,256995.37,256995.37,256995.37,256995.37,256995.37,null,null,null,null,null,{"$f":"IF(ISNUMBER(W19),IF(W19>SumCrono,W19,SumCrono),SumCrono)","v":256995.37}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A20)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B20)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E20)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F20)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G20)-ROW(G$20))/numlinhaCrono,0)","v":"1."},{"$f":"OFFSET(QCI!G$16,(ROW(H20)-ROW(H$20))/numlinhaCrono,0)","v":"Capeamento asfaltico da Rua Domingos Michelin"},{"$f":"C21","v":256995.37},"Acumulado (%)",{"$f":"IF($I20=0,0,MIN(1,MAX($K24:K24)/$I20))","v":0.36859469491609909},{"$f":"IF($I20=0,0,MIN(1,MAX($K24:L24)/$I20))","v":0.80646908152469832},{"$f":"IF($I20=0,0,MIN(1,MAX($K24:M24)/$I20))","v":1},{"$f":"IF($I20=0,0,MIN(1,MAX($K24:N24)/$I20))","v":1},{"$f":"IF($I20=0,0,MIN(1,MAX($K24:O24)/$I20))","v":1},{"$f":"IF($I20=0,0,MIN(1,MAX($K24:P24)/$I20))","v":1},{"$f":"IF($I20=0,0,MIN(1,MAX($K24:Q24)/$I20))","v":1},{"$f":"IF($I20=0,0,MIN(1,MAX($K24:R24)/$I20))","v":1},null,null,null,null,null,{"$f":"IF($I20=0,0,MIN(1,MAX($K24:X24)/$I20))","v":1}]
[{"$f":"A20","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":256995.37},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},94727.13,207258.82,256995.37,{"$f":"IF($B20,MAX($J24:M24),N24)","v":256995.37},{"$f":"IF($B20,MAX($J24:N24),O24)","v":256995.37},{"$f":"IF($B20,MAX($J24:O24),P24)","v":256995.37},{"$f":"IF($B20,MAX($J24:P24),Q24)","v":256995.37},{"$f":"IF($B20,MAX($J24:Q24),R24)","v":256995.37},null,null,null,null,null,{"$f":"IF($B20,MAX($J24:W24),X24)","v":256995.37}]
[{"$f":"A21","v":0},{"$f":"IF(AND($B20,$C22>0),$J$17,\"-\")","v":"CP Fin. (R$)"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":11145.37},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B20,ROUND($C22*K20,2),ROUND(SumCrono,2))","v":4108.12},8988.4,11145.37,11145.37,11145.37,11145.37,11145.37,11145.37,null,null,null,null,null,{"$f":"IF($B20,ROUND($C22*X20,2),ROUND(SumCrono,2))","v":11145.37}]
[{"$f":"A22","v":0},{"$f":"IF(AND($B20,$C23>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B20,ROUND($C23*K20,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B20,ROUND($C23*X20,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A23","v":0},{"$f":"IF(AND($B20,$C21>0),$J$19,\"-\")","v":"Acum. Inv. (R$)"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":256995.37},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B20,MIN($C24,MAX($K21:K21)),SumCrono)","v":94727.13},{"$f":"IF($B20,MIN($C24,MAX($K21:L21)),SumCrono)","v":207258.82},{"$f":"IF($B20,MIN($C24,MAX($K21:M21)),SumCrono)","v":256995.37},{"$f":"IF($B20,MIN($C24,MAX($K21:N21)),SumCrono)","v":256995.37},{"$f":"IF($B20,MIN($C24,MAX($K21:O21)),SumCrono)","v":256995.37},{"$f":"IF($B20,MIN($C24,MAX($K21:P21)),SumCrono)","v":256995.37},{"$f":"IF($B20,MIN($C24,MAX($K21:Q21)),SumCrono)","v":256995.37},{"$f":"IF($B20,MIN($C24,MAX($K21:R21)),SumCrono)","v":256995.37},null,null,null,null,null,{"$f":"IF($B20,MIN($C24,MAX($K21:X21)),SumCrono)","v":256995.37}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A25)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B25)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E25)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F25)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G25)-ROW(G$20))/numlinhaCrono,0)","v":"2."},{"$f":"OFFSET(QCI!G$16,(ROW(H25)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C26","v":0},"Acumulado (%)",{"$f":"IF($I25=0,0,MIN(1,MAX($K29:K29)/$I25))","v":0},{"$f":"IF($I25=0,0,MIN(1,MAX($K29:L29)/$I25))","v":0},{"$f":"IF($I25=0,0,MIN(1,MAX($K29:M29)/$I25))","v":0},{"$f":"IF($I25=0,0,MIN(1,MAX($K29:N29)/$I25))","v":0},{"$f":"IF($I25=0,0,MIN(1,MAX($K29:O29)/$I25))","v":0},{"$f":"IF($I25=0,0,MIN(1,MAX($K29:P29)/$I25))","v":0},{"$f":"IF($I25=0,0,MIN(1,MAX($K29:Q29)/$I25))","v":0},{"$f":"IF($I25=0,0,MIN(1,MAX($K29:R29)/$I25))","v":0},null,null,null,null,null,{"$f":"IF($I25=0,0,MIN(1,MAX($K29:X29)/$I25))","v":0}]
[{"$f":"A25","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B25,MAX($J29:J29),K29)","v":0},{"$f":"IF($B25,MAX($J29:K29),L29)","v":0},{"$f":"IF($B25,MAX($J29:L29),M29)","v":0},{"$f":"IF($B25,MAX($J29:M29),N29)","v":0},{"$f":"IF($B25,MAX($J29:N29),O29)","v":0},{"$f":"IF($B25,MAX($J29:O29),P29)","v":0},{"$f":"IF($B25,MAX($J29:P29),Q29)","v":0},{"$f":"IF($B25,MAX($J29:Q29),R29)","v":0},null,null,null,null,null,{"$f":"IF($B25,MAX($J29:W29),X29)","v":0}]
[{"$f":"A26","v":0},{"$f":"IF(AND($B25,$C27>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B25,ROUND($C27*K25,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B25,ROUND($C27*X25,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A27","v":0},{"$f":"IF(AND($B25,$C28>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B25,ROUND($C28*K25,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B25,ROUND($C28*X25,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A28","v":0},{"$f":"IF(AND($B25,$C26>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B25,MIN($C29,MAX($K26:K26)),SumCrono)","v":0},{"$f":"IF($B25,MIN($C29,MAX($K26:L26)),SumCrono)","v":0},{"$f":"IF($B25,MIN($C29,MAX($K26:M26)),SumCrono)","v":0},{"$f":"IF($B25,MIN($C29,MAX($K26:N26)),SumCrono)","v":0},{"$f":"IF($B25,MIN($C29,MAX($K26:O26)),SumCrono)","v":0},{"$f":"IF($B25,MIN($C29,MAX($K26:P26)),SumCrono)","v":0},{"$f":"IF($B25,MIN($C29,MAX($K26:Q26)),SumCrono)","v":0},{"$f":"IF($B25,MIN($C29,MAX($K26:R26)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B25,MIN($C29,MAX($K26:X26)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A30)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B30)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E30)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F30)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G30)-ROW(G$20))/numlinhaCrono,0)","v":"3."},{"$f":"OFFSET(QCI!G$16,(ROW(H30)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C31","v":0},"Acumulado (%)",{"$f":"IF($I30=0,0,MIN(1,MAX($K34:K34)/$I30))","v":0},{"$f":"IF($I30=0,0,MIN(1,MAX($K34:L34)/$I30))","v":0},{"$f":"IF($I30=0,0,MIN(1,MAX($K34:M34)/$I30))","v":0},{"$f":"IF($I30=0,0,MIN(1,MAX($K34:N34)/$I30))","v":0},{"$f":"IF($I30=0,0,MIN(1,MAX($K34:O34)/$I30))","v":0},{"$f":"IF($I30=0,0,MIN(1,MAX($K34:P34)/$I30))","v":0},{"$f":"IF($I30=0,0,MIN(1,MAX($K34:Q34)/$I30))","v":0},{"$f":"IF($I30=0,0,MIN(1,MAX($K34:R34)/$I30))","v":0},null,null,null,null,null,{"$f":"IF($I30=0,0,MIN(1,MAX($K34:X34)/$I30))","v":0}]
[{"$f":"A30","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B30,MAX($J34:J34),K34)","v":0},{"$f":"IF($B30,MAX($J34:K34),L34)","v":0},{"$f":"IF($B30,MAX($J34:L34),M34)","v":0},{"$f":"IF($B30,MAX($J34:M34),N34)","v":0},{"$f":"IF($B30,MAX($J34:N34),O34)","v":0},{"$f":"IF($B30,MAX($J34:O34),P34)","v":0},{"$f":"IF($B30,MAX($J34:P34),Q34)","v":0},{"$f":"IF($B30,MAX($J34:Q34),R34)","v":0},null,null,null,null,null,{"$f":"IF($B30,MAX($J34:W34),X34)","v":0}]
[{"$f":"A31","v":0},{"$f":"IF(AND($B30,$C32>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B30,ROUND($C32*K30,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B30,ROUND($C32*X30,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A32","v":0},{"$f":"IF(AND($B30,$C33>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B30,ROUND($C33*K30,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B30,ROUND($C33*X30,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A33","v":0},{"$f":"IF(AND($B30,$C31>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B30,MIN($C34,MAX($K31:K31)),SumCrono)","v":0},{"$f":"IF($B30,MIN($C34,MAX($K31:L31)),SumCrono)","v":0},{"$f":"IF($B30,MIN($C34,MAX($K31:M31)),SumCrono)","v":0},{"$f":"IF($B30,MIN($C34,MAX($K31:N31)),SumCrono)","v":0},{"$f":"IF($B30,MIN($C34,MAX($K31:O31)),SumCrono)","v":0},{"$f":"IF($B30,MIN($C34,MAX($K31:P31)),SumCrono)","v":0},{"$f":"IF($B30,MIN($C34,MAX($K31:Q31)),SumCrono)","v":0},{"$f":"IF($B30,MIN($C34,MAX($K31:R31)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B30,MIN($C34,MAX($K31:X31)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A35)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B35)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E35)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F35)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G35)-ROW(G$20))/numlinhaCrono,0)","v":"4."},{"$f":"OFFSET(QCI!G$16,(ROW(H35)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C36","v":0},"Acumulado (%)",{"$f":"IF($I35=0,0,MIN(1,MAX($K39:K39)/$I35))","v":0},{"$f":"IF($I35=0,0,MIN(1,MAX($K39:L39)/$I35))","v":0},{"$f":"IF($I35=0,0,MIN(1,MAX($K39:M39)/$I35))","v":0},{"$f":"IF($I35=0,0,MIN(1,MAX($K39:N39)/$I35))","v":0},{"$f":"IF($I35=0,0,MIN(1,MAX($K39:O39)/$I35))","v":0},{"$f":"IF($I35=0,0,MIN(1,MAX($K39:P39)/$I35))","v":0},{"$f":"IF($I35=0,0,MIN(1,MAX($K39:Q39)/$I35))","v":0},{"$f":"IF($I35=0,0,MIN(1,MAX($K39:R39)/$I35))","v":0},null,null,null,null,null,{"$f":"IF($I35=0,0,MIN(1,MAX($K39:X39)/$I35))","v":0}]
[{"$f":"A35","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B35,MAX($J39:J39),K39)","v":0},{"$f":"IF($B35,MAX($J39:K39),L39)","v":0},{"$f":"IF($B35,MAX($J39:L39),M39)","v":0},{"$f":"IF($B35,MAX($J39:M39),N39)","v":0},{"$f":"IF($B35,MAX($J39:N39),O39)","v":0},{"$f":"IF($B35,MAX($J39:O39),P39)","v":0},{"$f":"IF($B35,MAX($J39:P39),Q39)","v":0},{"$f":"IF($B35,MAX($J39:Q39),R39)","v":0},null,null,null,null,null,{"$f":"IF($B35,MAX($J39:W39),X39)","v":0}]
[{"$f":"A36","v":0},{"$f":"IF(AND($B35,$C37>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B35,ROUND($C37*K35,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B35,ROUND($C37*X35,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A37","v":0},{"$f":"IF(AND($B35,$C38>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B35,ROUND($C38*K35,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B35,ROUND($C38*X35,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A38","v":0},{"$f":"IF(AND($B35,$C36>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B35,MIN($C39,MAX($K36:K36)),SumCrono)","v":0},{"$f":"IF($B35,MIN($C39,MAX($K36:L36)),SumCrono)","v":0},{"$f":"IF($B35,MIN($C39,MAX($K36:M36)),SumCrono)","v":0},{"$f":"IF($B35,MIN($C39,MAX($K36:N36)),SumCrono)","v":0},{"$f":"IF($B35,MIN($C39,MAX($K36:O36)),SumCrono)","v":0},{"$f":"IF($B35,MIN($C39,MAX($K36:P36)),SumCrono)","v":0},{"$f":"IF($B35,MIN($C39,MAX($K36:Q36)),SumCrono)","v":0},{"$f":"IF($B35,MIN($C39,MAX($K36:R36)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B35,MIN($C39,MAX($K36:X36)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A40)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B40)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E40)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F40)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G40)-ROW(G$20))/numlinhaCrono,0)","v":"5."},{"$f":"OFFSET(QCI!G$16,(ROW(H40)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C41","v":0},"Acumulado (%)",{"$f":"IF($I40=0,0,MIN(1,MAX($K44:K44)/$I40))","v":0},{"$f":"IF($I40=0,0,MIN(1,MAX($K44:L44)/$I40))","v":0},{"$f":"IF($I40=0,0,MIN(1,MAX($K44:M44)/$I40))","v":0},{"$f":"IF($I40=0,0,MIN(1,MAX($K44:N44)/$I40))","v":0},{"$f":"IF($I40=0,0,MIN(1,MAX($K44:O44)/$I40))","v":0},{"$f":"IF($I40=0,0,MIN(1,MAX($K44:P44)/$I40))","v":0},{"$f":"IF($I40=0,0,MIN(1,MAX($K44:Q44)/$I40))","v":0},{"$f":"IF($I40=0,0,MIN(1,MAX($K44:R44)/$I40))","v":0},null,null,null,null,null,{"$f":"IF($I40=0,0,MIN(1,MAX($K44:X44)/$I40))","v":0}]
[{"$f":"A40","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B40,MAX($J44:J44),K44)","v":0},{"$f":"IF($B40,MAX($J44:K44),L44)","v":0},{"$f":"IF($B40,MAX($J44:L44),M44)","v":0},{"$f":"IF($B40,MAX($J44:M44),N44)","v":0},{"$f":"IF($B40,MAX($J44:N44),O44)","v":0},{"$f":"IF($B40,MAX($J44:O44),P44)","v":0},{"$f":"IF($B40,MAX($J44:P44),Q44)","v":0},{"$f":"IF($B40,MAX($J44:Q44),R44)","v":0},null,null,null,null,null,{"$f":"IF($B40,MAX($J44:W44),X44)","v":0}]
[{"$f":"A41","v":0},{"$f":"IF(AND($B40,$C42>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B40,ROUND($C42*K40,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B40,ROUND($C42*X40,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A42","v":0},{"$f":"IF(AND($B40,$C43>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B40,ROUND($C43*K40,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B40,ROUND($C43*X40,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A43","v":0},{"$f":"IF(AND($B40,$C41>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B40,MIN($C44,MAX($K41:K41)),SumCrono)","v":0},{"$f":"IF($B40,MIN($C44,MAX($K41:L41)),SumCrono)","v":0},{"$f":"IF($B40,MIN($C44,MAX($K41:M41)),SumCrono)","v":0},{"$f":"IF($B40,MIN($C44,MAX($K41:N41)),SumCrono)","v":0},{"$f":"IF($B40,MIN($C44,MAX($K41:O41)),SumCrono)","v":0},{"$f":"IF($B40,MIN($C44,MAX($K41:P41)),SumCrono)","v":0},{"$f":"IF($B40,MIN($C44,MAX($K41:Q41)),SumCrono)","v":0},{"$f":"IF($B40,MIN($C44,MAX($K41:R41)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B40,MIN($C44,MAX($K41:X41)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A45)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B45)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E45)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F45)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G45)-ROW(G$20))/numlinhaCrono,0)","v":"6."},{"$f":"OFFSET(QCI!G$16,(ROW(H45)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C46","v":0},"Acumulado (%)",{"$f":"IF($I45=0,0,MIN(1,MAX($K49:K49)/$I45))","v":0},{"$f":"IF($I45=0,0,MIN(1,MAX($K49:L49)/$I45))","v":0},{"$f":"IF($I45=0,0,MIN(1,MAX($K49:M49)/$I45))","v":0},{"$f":"IF($I45=0,0,MIN(1,MAX($K49:N49)/$I45))","v":0},{"$f":"IF($I45=0,0,MIN(1,MAX($K49:O49)/$I45))","v":0},{"$f":"IF($I45=0,0,MIN(1,MAX($K49:P49)/$I45))","v":0},{"$f":"IF($I45=0,0,MIN(1,MAX($K49:Q49)/$I45))","v":0},{"$f":"IF($I45=0,0,MIN(1,MAX($K49:R49)/$I45))","v":0},null,null,null,null,null,{"$f":"IF($I45=0,0,MIN(1,MAX($K49:X49)/$I45))","v":0}]
[{"$f":"A45","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B45,MAX($J49:J49),K49)","v":0},{"$f":"IF($B45,MAX($J49:K49),L49)","v":0},{"$f":"IF($B45,MAX($J49:L49),M49)","v":0},{"$f":"IF($B45,MAX($J49:M49),N49)","v":0},{"$f":"IF($B45,MAX($J49:N49),O49)","v":0},{"$f":"IF($B45,MAX($J49:O49),P49)","v":0},{"$f":"IF($B45,MAX($J49:P49),Q49)","v":0},{"$f":"IF($B45,MAX($J49:Q49),R49)","v":0},null,null,null,null,null,{"$f":"IF($B45,MAX($J49:W49),X49)","v":0}]
[{"$f":"A46","v":0},{"$f":"IF(AND($B45,$C47>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B45,ROUND($C47*K45,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B45,ROUND($C47*X45,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A47","v":0},{"$f":"IF(AND($B45,$C48>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B45,ROUND($C48*K45,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B45,ROUND($C48*X45,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A48","v":0},{"$f":"IF(AND($B45,$C46>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B45,MIN($C49,MAX($K46:K46)),SumCrono)","v":0},{"$f":"IF($B45,MIN($C49,MAX($K46:L46)),SumCrono)","v":0},{"$f":"IF($B45,MIN($C49,MAX($K46:M46)),SumCrono)","v":0},{"$f":"IF($B45,MIN($C49,MAX($K46:N46)),SumCrono)","v":0},{"$f":"IF($B45,MIN($C49,MAX($K46:O46)),SumCrono)","v":0},{"$f":"IF($B45,MIN($C49,MAX($K46:P46)),SumCrono)","v":0},{"$f":"IF($B45,MIN($C49,MAX($K46:Q46)),SumCrono)","v":0},{"$f":"IF($B45,MIN($C49,MAX($K46:R46)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B45,MIN($C49,MAX($K46:X46)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A50)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B50)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E50)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F50)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G50)-ROW(G$20))/numlinhaCrono,0)","v":"7."},{"$f":"OFFSET(QCI!G$16,(ROW(H50)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C51","v":0},"Acumulado (%)",{"$f":"IF($I50=0,0,MIN(1,MAX($K54:K54)/$I50))","v":0},{"$f":"IF($I50=0,0,MIN(1,MAX($K54:L54)/$I50))","v":0},{"$f":"IF($I50=0,0,MIN(1,MAX($K54:M54)/$I50))","v":0},{"$f":"IF($I50=0,0,MIN(1,MAX($K54:N54)/$I50))","v":0},{"$f":"IF($I50=0,0,MIN(1,MAX($K54:O54)/$I50))","v":0},{"$f":"IF($I50=0,0,MIN(1,MAX($K54:P54)/$I50))","v":0},{"$f":"IF($I50=0,0,MIN(1,MAX($K54:Q54)/$I50))","v":0},{"$f":"IF($I50=0,0,MIN(1,MAX($K54:R54)/$I50))","v":0},null,null,null,null,null,{"$f":"IF($I50=0,0,MIN(1,MAX($K54:X54)/$I50))","v":0}]
[{"$f":"A50","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B50,MAX($J54:J54),K54)","v":0},{"$f":"IF($B50,MAX($J54:K54),L54)","v":0},{"$f":"IF($B50,MAX($J54:L54),M54)","v":0},{"$f":"IF($B50,MAX($J54:M54),N54)","v":0},{"$f":"IF($B50,MAX($J54:N54),O54)","v":0},{"$f":"IF($B50,MAX($J54:O54),P54)","v":0},{"$f":"IF($B50,MAX($J54:P54),Q54)","v":0},{"$f":"IF($B50,MAX($J54:Q54),R54)","v":0},null,null,null,null,null,{"$f":"IF($B50,MAX($J54:W54),X54)","v":0}]
[{"$f":"A51","v":0},{"$f":"IF(AND($B50,$C52>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B50,ROUND($C52*K50,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B50,ROUND($C52*X50,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A52","v":0},{"$f":"IF(AND($B50,$C53>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B50,ROUND($C53*K50,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B50,ROUND($C53*X50,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A53","v":0},{"$f":"IF(AND($B50,$C51>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B50,MIN($C54,MAX($K51:K51)),SumCrono)","v":0},{"$f":"IF($B50,MIN($C54,MAX($K51:L51)),SumCrono)","v":0},{"$f":"IF($B50,MIN($C54,MAX($K51:M51)),SumCrono)","v":0},{"$f":"IF($B50,MIN($C54,MAX($K51:N51)),SumCrono)","v":0},{"$f":"IF($B50,MIN($C54,MAX($K51:O51)),SumCrono)","v":0},{"$f":"IF($B50,MIN($C54,MAX($K51:P51)),SumCrono)","v":0},{"$f":"IF($B50,MIN($C54,MAX($K51:Q51)),SumCrono)","v":0},{"$f":"IF($B50,MIN($C54,MAX($K51:R51)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B50,MIN($C54,MAX($K51:X51)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A55)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B55)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E55)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F55)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G55)-ROW(G$20))/numlinhaCrono,0)","v":"8."},{"$f":"OFFSET(QCI!G$16,(ROW(H55)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C56","v":0},"Acumulado (%)",{"$f":"IF($I55=0,0,MIN(1,MAX($K59:K59)/$I55))","v":0},{"$f":"IF($I55=0,0,MIN(1,MAX($K59:L59)/$I55))","v":0},{"$f":"IF($I55=0,0,MIN(1,MAX($K59:M59)/$I55))","v":0},{"$f":"IF($I55=0,0,MIN(1,MAX($K59:N59)/$I55))","v":0},{"$f":"IF($I55=0,0,MIN(1,MAX($K59:O59)/$I55))","v":0},{"$f":"IF($I55=0,0,MIN(1,MAX($K59:P59)/$I55))","v":0},{"$f":"IF($I55=0,0,MIN(1,MAX($K59:Q59)/$I55))","v":0},{"$f":"IF($I55=0,0,MIN(1,MAX($K59:R59)/$I55))","v":0},null,null,null,null,null,{"$f":"IF($I55=0,0,MIN(1,MAX($K59:X59)/$I55))","v":0}]
[{"$f":"A55","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B55,MAX($J59:J59),K59)","v":0},{"$f":"IF($B55,MAX($J59:K59),L59)","v":0},{"$f":"IF($B55,MAX($J59:L59),M59)","v":0},{"$f":"IF($B55,MAX($J59:M59),N59)","v":0},{"$f":"IF($B55,MAX($J59:N59),O59)","v":0},{"$f":"IF($B55,MAX($J59:O59),P59)","v":0},{"$f":"IF($B55,MAX($J59:P59),Q59)","v":0},{"$f":"IF($B55,MAX($J59:Q59),R59)","v":0},null,null,null,null,null,{"$f":"IF($B55,MAX($J59:W59),X59)","v":0}]
[{"$f":"A56","v":0},{"$f":"IF(AND($B55,$C57>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B55,ROUND($C57*K55,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B55,ROUND($C57*X55,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A57","v":0},{"$f":"IF(AND($B55,$C58>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B55,ROUND($C58*K55,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B55,ROUND($C58*X55,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A58","v":0},{"$f":"IF(AND($B55,$C56>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B55,MIN($C59,MAX($K56:K56)),SumCrono)","v":0},{"$f":"IF($B55,MIN($C59,MAX($K56:L56)),SumCrono)","v":0},{"$f":"IF($B55,MIN($C59,MAX($K56:M56)),SumCrono)","v":0},{"$f":"IF($B55,MIN($C59,MAX($K56:N56)),SumCrono)","v":0},{"$f":"IF($B55,MIN($C59,MAX($K56:O56)),SumCrono)","v":0},{"$f":"IF($B55,MIN($C59,MAX($K56:P56)),SumCrono)","v":0},{"$f":"IF($B55,MIN($C59,MAX($K56:Q56)),SumCrono)","v":0},{"$f":"IF($B55,MIN($C59,MAX($K56:R56)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B55,MIN($C59,MAX($K56:X56)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A60)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B60)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E60)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F60)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G60)-ROW(G$20))/numlinhaCrono,0)","v":"9."},{"$f":"OFFSET(QCI!G$16,(ROW(H60)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C61","v":0},"Acumulado (%)",{"$f":"IF($I60=0,0,MIN(1,MAX($K64:K64)/$I60))","v":0},{"$f":"IF($I60=0,0,MIN(1,MAX($K64:L64)/$I60))","v":0},{"$f":"IF($I60=0,0,MIN(1,MAX($K64:M64)/$I60))","v":0},{"$f":"IF($I60=0,0,MIN(1,MAX($K64:N64)/$I60))","v":0},{"$f":"IF($I60=0,0,MIN(1,MAX($K64:O64)/$I60))","v":0},{"$f":"IF($I60=0,0,MIN(1,MAX($K64:P64)/$I60))","v":0},{"$f":"IF($I60=0,0,MIN(1,MAX($K64:Q64)/$I60))","v":0},{"$f":"IF($I60=0,0,MIN(1,MAX($K64:R64)/$I60))","v":0},null,null,null,null,null,{"$f":"IF($I60=0,0,MIN(1,MAX($K64:X64)/$I60))","v":0}]
[{"$f":"A60","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B60,MAX($J64:J64),K64)","v":0},{"$f":"IF($B60,MAX($J64:K64),L64)","v":0},{"$f":"IF($B60,MAX($J64:L64),M64)","v":0},{"$f":"IF($B60,MAX($J64:M64),N64)","v":0},{"$f":"IF($B60,MAX($J64:N64),O64)","v":0},{"$f":"IF($B60,MAX($J64:O64),P64)","v":0},{"$f":"IF($B60,MAX($J64:P64),Q64)","v":0},{"$f":"IF($B60,MAX($J64:Q64),R64)","v":0},null,null,null,null,null,{"$f":"IF($B60,MAX($J64:W64),X64)","v":0}]
[{"$f":"A61","v":0},{"$f":"IF(AND($B60,$C62>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B60,ROUND($C62*K60,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B60,ROUND($C62*X60,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A62","v":0},{"$f":"IF(AND($B60,$C63>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B60,ROUND($C63*K60,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B60,ROUND($C63*X60,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A63","v":0},{"$f":"IF(AND($B60,$C61>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B60,MIN($C64,MAX($K61:K61)),SumCrono)","v":0},{"$f":"IF($B60,MIN($C64,MAX($K61:L61)),SumCrono)","v":0},{"$f":"IF($B60,MIN($C64,MAX($K61:M61)),SumCrono)","v":0},{"$f":"IF($B60,MIN($C64,MAX($K61:N61)),SumCrono)","v":0},{"$f":"IF($B60,MIN($C64,MAX($K61:O61)),SumCrono)","v":0},{"$f":"IF($B60,MIN($C64,MAX($K61:P61)),SumCrono)","v":0},{"$f":"IF($B60,MIN($C64,MAX($K61:Q61)),SumCrono)","v":0},{"$f":"IF($B60,MIN($C64,MAX($K61:R61)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B60,MIN($C64,MAX($K61:X61)),SumCrono)","v":0}]
[{"$f":"OFFSET(QCI!X$16,(ROW(A65)-ROW(A$20))/numlinhaCrono,0)*numlinhaCrono","v":0},{"$f":"OFFSET(QCI!Y$16,(ROW(B65)-ROW(B$20))/numlinhaCrono,0)","v":true},null,"",{"$f":"OFFSET(QCI!B$16,(ROW(E65)-ROW(E$20))/numlinhaCrono,0)","v":1},{"$f":"OFFSET(QCI!C$16,(ROW(F65)-ROW(F$20))/numlinhaCrono,0)","v":"Meta"},{"$f":"OFFSET(QCI!D$16,(ROW(G65)-ROW(G$20))/numlinhaCrono,0)","v":"10."},{"$f":"OFFSET(QCI!G$16,(ROW(H65)-ROW(H$20))/numlinhaCrono,0)","v":0},{"$f":"C66","v":0},"Acumulado (%)",{"$f":"IF($I65=0,0,MIN(1,MAX($K69:K69)/$I65))","v":0},{"$f":"IF($I65=0,0,MIN(1,MAX($K69:L69)/$I65))","v":0},{"$f":"IF($I65=0,0,MIN(1,MAX($K69:M69)/$I65))","v":0},{"$f":"IF($I65=0,0,MIN(1,MAX($K69:N69)/$I65))","v":0},{"$f":"IF($I65=0,0,MIN(1,MAX($K69:O69)/$I65))","v":0},{"$f":"IF($I65=0,0,MIN(1,MAX($K69:P69)/$I65))","v":0},{"$f":"IF($I65=0,0,MIN(1,MAX($K69:Q69)/$I65))","v":0},{"$f":"IF($I65=0,0,MIN(1,MAX($K69:R69)/$I65))","v":0},null,null,null,null,null,{"$f":"IF($I65=0,0,MIN(1,MAX($K69:X69)/$I65))","v":0}]
[{"$f":"A65","v":0},null,{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B65,MAX($J69:J69),K69)","v":0},{"$f":"IF($B65,MAX($J69:K69),L69)","v":0},{"$f":"IF($B65,MAX($J69:L69),M69)","v":0},{"$f":"IF($B65,MAX($J69:M69),N69)","v":0},{"$f":"IF($B65,MAX($J69:N69),O69)","v":0},{"$f":"IF($B65,MAX($J69:O69),P69)","v":0},{"$f":"IF($B65,MAX($J69:P69),Q69)","v":0},{"$f":"IF($B65,MAX($J69:Q69),R69)","v":0},null,null,null,null,null,{"$f":"IF($B65,MAX($J69:W69),X69)","v":0}]
[{"$f":"A66","v":0},{"$f":"IF(AND($B65,$C67>0),$J$17,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$M$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$17","v":"CP Fin. (R$)"},{"$f":"IF($B65,ROUND($C67*K65,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B65,ROUND($C67*X65,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A67","v":0},{"$f":"IF(AND($B65,$C68>0),$J$18,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$N$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$18","v":"Outros (R$)"},{"$f":"IF($B65,ROUND($C68*K65,2),ROUND(SumCrono,2))","v":0},0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF($B65,ROUND($C68*X65,2),ROUND(SumCrono,2))","v":0}]
[{"$f":"A68","v":0},{"$f":"IF(AND($B65,$C66>0),$J$19,\"-\")","v":"-"},{"$f":"OFFSET(QCI!$O$16,(ROW()-ROW(C$20))/numlinhaCrono,0)","v":0},null,null,null,null,null,null,{"$f":"J$19","v":"Acum. Inv. (R$)"},{"$f":"IF($B65,MIN($C69,MAX($K66:K66)),SumCrono)","v":0},{"$f":"IF($B65,MIN($C69,MAX($K66:L66)),SumCrono)","v":0},{"$f":"IF($B65,MIN($C69,MAX($K66:M66)),SumCrono)","v":0},{"$f":"IF($B65,MIN($C69,MAX($K66:N66)),SumCrono)","v":0},{"$f":"IF($B65,MIN($C69,MAX($K66:O66)),SumCrono)","v":0},{"$f":"IF($B65,MIN($C69,MAX($K66:P66)),SumCrono)","v":0},{"$f":"IF($B65,MIN($C69,MAX($K66:Q66)),SumCrono)","v":0},{"$f":"IF($B65,MIN($C69,MAX($K66:R66)),SumCrono)","v":0},null,null,null,null,null,{"$f":"IF($B65,MIN($C69,MAX($K66:X66)),SumCrono)","v":0}]
[]
[]
[null,null,null,null,"Observações:"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"QCI!H36","v":"Local:"},null,null,{"$f":"QCI!I36","v":"Bom Jesus - SC"},null,null,null,null,"Representante Tomador / Agente Promotor"]
[null,null,null,null,{"$f":"QCI!H37","v":"Data:"},null,null,{"$f":"QCI!I37","v":"2018-01-25"},null,null,null,null,"Nome:",{"$f":"QCI!$D$36","v":"Rafael Calza"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cargo:",{"$f":"QCI!$D$37","v":"Prefeito Municipal"}]

{"sheet":"RRE","index":3,"n_rows":42,"n_cols":52,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,8,41,16],[38,7,38,16],[27,0,27,2],[8,0,9,0],[28,0,29,17],[13,7,13,8],[8,16,9,16],[34,8,34,16],[8,13,9,13],[11,17,14,17],[8,7,9,7],[11,11,14,11],[39,8,39,16],[35,8,35,16],[11,7,11,8],[36,8,36,16],[41,2,41,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[39,2,39,4],[12,7,12,8],[6,7,7,9],[8,1,9,2],[40,2,40,4],[38,0,38,4],[40,8,40,16],[33,7,33,16],[11,10,14,10],[14,7,14,8],[33,0,33,4],[31,1,31,4],[11,1,14,2],[1,16,1,17],[2,16,2,17],[2,0,2,13],[8,8,9,8],[4,4,4,5],[4,13,4,14],[4,8,5,8],[4,7,5,7],[5,13,5,14],[8,3,9,3],[8,5,9,5],[8,6,9,6],[4,9,5,9],[7,12,7,16],[8,4,9,4],[8,19,9,19],[8,20,9,20],[31,9,31,16],[7,17,9,17],[8,14,9,15],[8,12,9,12],[8,10,9,11],[11,15,14,15],[11,14,14,14],[7,25,7,26],[8,39,9,39],[8,31,9,31],[8,32,9,32],[8,29,9,29],[7,34,7,36],[8,26,9,26],[8,34,9,34],[8,25,9,25],[7,31,7,33],[8,28,9,28],[8,33,9,33],[8,37,9,37],[8,35,9,35],[7,28,7,30],[8,30,9,30],[8,36,9,36],[7,37,7,39],[8,38,9,38],[8,49,9,49],[8,40,9,40],[7,49,7,51],[8,50,9,50],[8,51,9,51],[8,42,9,42],[8,45,9,45],[8,43,9,43],[7,43,7,45],[8,44,9,44],[7,46,7,48],[7,40,7,42],[8,41,9,41],[8,48,9,48],[8,47,9,47],[8,46,9,46]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RRET"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QCI!O2","v":"Grau de Sigilo"}]
[{"$f":"CONCATENATE(\"RRE - RELATÓRIO RESUMO DO EMPREENDIMENTO - \",IF(RREMode=\"RRET\",\"TOMADOR\",\"CAIXA\"))","v":"RRE - RELATÓRIO RESUMO DO EMPREENDIMENTO - TOMADOR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"QCI!O3","v":"#PUBLICO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acum. Previsto","Acum. Chegada",null,"Vmax","Vmax",null,"Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax","Vmax"]
[null,null,null,"Situação do TC/CR:","Percentual previsto em:",null,null,"Medição nº:",1,"Saldo a Reprogramar:",null,null,{"$f":"CRONO!$J$11","v":"Repasse (R$)"},"Contrapartida (R$)",null,null,null,null,null,null,null,"Repasse",{"$f":"W8-W7-W6","v":0},{"$f":"X8-X7-X6","v":0}]
[null,null,null,{"$f":"IF(F6=\"-\",\"-\",IF(R12<F6,\"Atrasada\",IF(R12>F6,\"Adiantada\",\"Normal\")))","v":"Atrasada"},{"$f":"DATE(YEAR(J32),MONTH(J32),1)","v":"2018-01-01"},{"$f":"IF($E$6<=DATE(YEAR(CRONO!$J$6),MONTH(CRONO!$J$6),1),\"-\",IF(COUNTIF(CRONO!$K$9:$S$9,RRE!$E$6)=0,1,HLOOKUP(RRE!$E$6,CRONO!$K$9:$S$16,7)))","v":0.36859999999999998},null,null,null,null,null,null,{"$f":"QCI!L7","v":0},{"$f":"QCI!M7","v":0},null,null,null,null,null,null,null,"CP. Financ.",{"$f":"ROUND(SUMIF($V$15:$V$26,TRUE,$O$15:$O$26),2)","v":0},{"$f":"IF(OR($Q$15<$M$15,$M13>$W6),MIN($M13,$J13),MIN($W6,$N$15-$N$14+$M13))","v":0},null,{"$f":"MIN($J$13,$Q$15-Z$14)","v":0},{"$f":"MIN($J$13,$Q$15-AA$14)","v":0},null,{"$f":"MIN($J$13,$Q$15-AC$14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"\"Acumulado Anterior:  \"&TEXT(M15/(J15+10^-12),\"0,00%\")","v":"Acumulado Anterior:  0,00%"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$H$14","v":"Outros"},{"$f":"ROUND(SUMIF($V$15:$V$26,TRUE,$P$15:$P$26),2)","v":0},{"$f":"IF(OR($Q$15<$M$15,$M14>$W7),MIN($M14,$J14),MIN($W7,$N$15+$M14))","v":0},null,{"$f":"MIN($J$14,$Q$15-Z$13)","v":0},{"$f":"MIN($J$14,$Q$15-AA$13)","v":0},null,{"$f":"MIN($J$14,$Q$15-AC$13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RREMode=\"RRET\",\"Valores Medidos (R$)\",\"Valores Aferidos (R$)\")","v":"Valores Medidos (R$)"},null,null,null,null,"Execução Física Acum.",null,null,null,"Investimento",{"$f":"Q15","v":0},{"$f":"W8","v":0},null,"Valores Aferidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)",null,null,"Valores Medidos Acumulados (R$)"]
["Etapa","Meta / \nSub-Meta",null,"Descrição da Meta / Sub-Meta","Situação","Quantidade","Unid.","Lote de Licitação\n / nº CTEF","nº do BM","Valor Total (R$)","Acum. Período Anterior",null,"Acum. Período Anterior","No Período","Acum. Incluindo o Período",null,"Acum. incluindo o Período",null,null,"Altura","Rel. Forn.",null,null,null,null,"Aferição Anterior","Aferição Atual",null,1,{"$f":"OFFSET(AD9,0,-1)+1","v":2},{"$f":"OFFSET(AE9,0,-1)+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,{"$f":"OFFSET(AZ9,0,-1)+1","v":24}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Somar Meta","Medição Ant.","Medição Acum."]
[{"$f":"OFFSET(QCI!B$15,ROW(A11)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B11)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C11)-ROW(C$15),0)","v":"1."},{"$f":"OFFSET(QCI!G$15,ROW(F11)-ROW(F$15),0)","v":0},{"$f":"IF($V11,OFFSET(QCI!H$15,ROW(G11)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B11=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H11)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J11)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J11)-ROW(J$15),0))","v":""},{"$f":"IF($V11,OFFSET(QCI!K$15,ROW(M11)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB11)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M11/($J11+10^-12)*OFFSET(QCI!$M$15,ROW(K11)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M11/($J11+10^-12)*OFFSET(QCI!$N$15,ROW(L11)-ROW(L$15),0),2)","v":0},{"$f":"IF($V11,IF(OR($E11=\"Licitado / em execução\",$E11=\"Concluído\"),IF(RREMode=\"RREV\",ROUND(Z11,2),W11),0),SUM(OFFSET(M11,1,0,$T11)))","v":0},{"$f":"ROUND(Q11,2)-ROUND(M11,2)","v":0},{"$f":"ROUND(Q11/($J11+10^-12)*OFFSET(QCI!$M$15,ROW(O11)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q11/($J11+10^-12)*OFFSET(QCI!$N$15,ROW(P11)-ROW(P$15),0),2)","v":0},{"$f":"IF($V11,IF(OR($E11=\"Licitado / em execução\",$E11=\"Concluído\"),IF(RREMode=\"RREV\",ROUND(AA11,2),X11),0),SUM(OFFSET(Q11,1,0,$T11)))","v":0},{"$f":"Q11/($J11+10^-12)","v":0},null,{"$f":"OFFSET(QCI!X$15,ROW(X11)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H11,$H11)=1,$H11<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H11,$N$9:$N$26)>0,$V11),OFFSET(U11,-1,0)+1,OFFSET(U11,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W11)-ROW(X$15),0)","v":true},{"$f":"IF(AND(COUNTA(OFFSET($AC11,0,0,1,mcol-1))>0,mcol>1),ROUND((INDEX(OFFSET($AC11,0,0,1,mcol-1),MATCH(9.99999999999999E+307,OFFSET($AC11,0,0,1,mcol-1)))),2),0)","v":0},{"$f":"IF(AND(COUNTA(OFFSET($AC11,0,0,1,mcol))>0,mcol>0),ROUND((INDEX(OFFSET($AC11,0,0,1,mcol),MATCH(9.99999999999999E+307,OFFSET($AC11,0,0,1,mcol)))),2),0)","v":0}]
[null,"TOTAL",null,null,null,null,null,{"$f":"QCI!L9","v":"Repasse"},null,{"$f":"QCI!L15","v":245850},{"$f":"QCI!$M$9","v":"Contrapartida Financeira"},{"$f":"QCI!$N$9","v":"Outros"},{"$f":"M15-M14-M13","v":0},0,{"$f":"QCI!$M$9","v":"Contrapartida Financeira"},{"$f":"QCI!$N$9","v":"Outros"},{"$f":"Q15-Q14-Q13","v":0},{"$f":"Q15/(J15+10^-12)","v":0}]
[null,null,null,null,null,null,null,"CP. Financ.",null,{"$f":"QCI!M15","v":11145.37},null,null,{"$f":"IF(AND(RREMode=\"RREV\",Z13<>\"\"),ROUND(Z13,2),IF(W13<>\"\",W13,ROUND(SUMIF($V$15:$V$26,TRUE,K$15:K$26),2)))","v":0},0,null,null,{"$f":"IF(AND(RREMode=\"RREV\",$AA13<>\"\"),ROUND(AA13,2),IF(X13<>\"\",X13,X6))","v":0},null,null,null,null,{"$f":"H13","v":"CP. Financ."},{"$f":"IF(COUNTIF($AC$9:$BA$9,$I$5-1)=0,\"\",IF(INDEX($AC13:$BA13,MATCH($I$5-1,$AC$9:$BA$9,0))=\"\",\"\",INDEX($AC13:$BA13,MATCH($I$5-1,$AC$9:$BA$9,0))))","v":""},{"$f":"IF(COUNTIF($AC$9:$BA$9,$I$5)=0,\"\",IF(INDEX($AC13:$BA13,MATCH($I$5,$AC$9:$BA$9,0))=\"\",\"\",INDEX($AC13:$BA13,MATCH($I$5,$AC$9:$BA$9,0))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(QCI!N9=\"Outros\",\"Outros\",\"CP. Física\")","v":"Outros"},null,{"$f":"QCI!N15","v":0},null,null,{"$f":"IF(AND(RREMode=\"RREV\",Z14<>\"\"),ROUND(Z14,2),IF(W14<>\"\",W14,ROUND(SUMIF($V$15:$V$26,TRUE,L$15:L$26),2)))","v":0},0,null,null,{"$f":"IF(AND(RREMode=\"RREV\",$AA14<>\"\"),ROUND(AA14,2),IF(X14<>\"\",X14,X7))","v":0},null,null,null,null,{"$f":"H14","v":"Outros"},{"$f":"IF(COUNTIF($AC$9:$BA$9,$I$5-1)=0,\"\",IF(INDEX($AC14:$BA14,MATCH($I$5-1,$AC$9:$BA$9,0))=\"\",\"\",INDEX($AC14:$BA14,MATCH($I$5-1,$AC$9:$BA$9,0))))","v":""},{"$f":"IF(COUNTIF($AC$9:$BA$9,$I$5)=0,\"\",IF(INDEX($AC14:$BA14,MATCH($I$5,$AC$9:$BA$9,0))=\"\",\"\",INDEX($AC14:$BA14,MATCH($I$5,$AC$9:$BA$9,0))))","v":""}]
[null,null,null,null,null,null,null,"Investimento",null,{"$f":"QCI!O15","v":256995.37},null,null,{"$f":"ROUND(SUMIF($V$15:$V$26,TRUE,M$15:M$26),2)","v":0},0,null,null,{"$f":"ROUND(SUMIF($V$15:$V$26,TRUE,Q$15:Q$26),2)","v":0}]
[{"$f":"OFFSET(QCI!B$15,ROW(A16)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B16)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C16)-ROW(C$15),0)","v":"1."},{"$f":"OFFSET(QCI!G$15,ROW(F16)-ROW(F$15),0)","v":"Capeamento asfaltico da Rua Domingos Michelin"},{"$f":"IF($V16,OFFSET(QCI!H$15,ROW(G16)-ROW(G$15),0),\"\")","v":"Em Análise"},{"$f":"IF($B16=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H16)-ROW(H$15),0))","v":4134},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J16)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J16)-ROW(J$15),0))","v":"m²"},{"$f":"IF($V16,OFFSET(QCI!K$15,ROW(M16)-ROW(M$15),0),\"\")","v":"Lote 1"},null,{"$f":"OFFSET(QCI!O$15,ROW(AB16)-ROW(AB$15),0)","v":256995.37},{"$f":"ROUND(M16/($J16+10^-12)*OFFSET(QCI!$M$15,ROW(K16)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M16/($J16+10^-12)*OFFSET(QCI!$N$15,ROW(L16)-ROW(L$15),0),2)","v":0},{"$f":"IF($V16,IF(OR($E16=\"Licitado / em execução\",$E16=\"Concluído\"),IF(RREMode=\"RREV\",ROUND(Z16,2),W16),0),SUM(OFFSET(M16,1,0,$T16)))","v":0},0,{"$f":"ROUND(Q16/($J16+10^-12)*OFFSET(QCI!$M$15,ROW(O16)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q16/($J16+10^-12)*OFFSET(QCI!$N$15,ROW(P16)-ROW(P$15),0),2)","v":0},{"$f":"IF($V16,IF(OR($E16=\"Licitado / em execução\",$E16=\"Concluído\"),IF(RREMode=\"RREV\",ROUND(AA16,2),X16),0),SUM(OFFSET(Q16,1,0,$T16)))","v":0},{"$f":"Q16/($J16+10^-12)","v":0},null,{"$f":"OFFSET(QCI!X$15,ROW(X16)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H16,$H16)=1,$H16<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H16,$N$9:$N$26)>0,$V16),OFFSET(U16,-1,0)+1,OFFSET(U16,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W16)-ROW(X$15),0)","v":true},{"$f":"IF(AND(COUNTA(OFFSET($AC16,0,0,1,mcol-1))>0,mcol>1),ROUND((INDEX(OFFSET($AC16,0,0,1,mcol-1),MATCH(9.99999999999999E+307,OFFSET($AC16,0,0,1,mcol-1)))),2),0)","v":0},{"$f":"IF(AND(COUNTA(OFFSET($AC16,0,0,1,mcol))>0,mcol>0),ROUND((INDEX(OFFSET($AC16,0,0,1,mcol),MATCH(9.99999999999999E+307,OFFSET($AC16,0,0,1,mcol)))),2),0)","v":0}]
[{"$f":"OFFSET(QCI!B$15,ROW(A17)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B17)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C17)-ROW(C$15),0)","v":"2."},{"$f":"OFFSET(QCI!G$15,ROW(F17)-ROW(F$15),0)","v":0},{"$f":"IF($V17,OFFSET(QCI!H$15,ROW(G17)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B17=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H17)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J17)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J17)-ROW(J$15),0))","v":""},{"$f":"IF($V17,OFFSET(QCI!K$15,ROW(M17)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB17)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M17/($J17+10^-12)*OFFSET(QCI!$M$15,ROW(K17)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M17/($J17+10^-12)*OFFSET(QCI!$N$15,ROW(L17)-ROW(L$15),0),2)","v":0},0,{"$f":"ROUND(Q17,2)-ROUND(M17,2)","v":0},{"$f":"ROUND(Q17/($J17+10^-12)*OFFSET(QCI!$M$15,ROW(O17)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q17/($J17+10^-12)*OFFSET(QCI!$N$15,ROW(P17)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X17)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H17,$H17)=1,$H17<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H17,$N$9:$N$26)>0,$V17),OFFSET(U17,-1,0)+1,OFFSET(U17,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W17)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A18)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B18)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C18)-ROW(C$15),0)","v":"3."},{"$f":"OFFSET(QCI!G$15,ROW(F18)-ROW(F$15),0)","v":0},{"$f":"IF($V18,OFFSET(QCI!H$15,ROW(G18)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B18=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H18)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J18)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J18)-ROW(J$15),0))","v":""},{"$f":"IF($V18,OFFSET(QCI!K$15,ROW(M18)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB18)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M18/($J18+10^-12)*OFFSET(QCI!$M$15,ROW(K18)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M18/($J18+10^-12)*OFFSET(QCI!$N$15,ROW(L18)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q18/($J18+10^-12)*OFFSET(QCI!$M$15,ROW(O18)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q18/($J18+10^-12)*OFFSET(QCI!$N$15,ROW(P18)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X18)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H18,$H18)=1,$H18<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H18,$N$9:$N$26)>0,$V18),OFFSET(U18,-1,0)+1,OFFSET(U18,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W18)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A19)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B19)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C19)-ROW(C$15),0)","v":"4."},{"$f":"OFFSET(QCI!G$15,ROW(F19)-ROW(F$15),0)","v":0},{"$f":"IF($V19,OFFSET(QCI!H$15,ROW(G19)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B19=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H19)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J19)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J19)-ROW(J$15),0))","v":""},{"$f":"IF($V19,OFFSET(QCI!K$15,ROW(M19)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB19)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M19/($J19+10^-12)*OFFSET(QCI!$M$15,ROW(K19)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M19/($J19+10^-12)*OFFSET(QCI!$N$15,ROW(L19)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q19/($J19+10^-12)*OFFSET(QCI!$M$15,ROW(O19)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q19/($J19+10^-12)*OFFSET(QCI!$N$15,ROW(P19)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X19)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H19,$H19)=1,$H19<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H19,$N$9:$N$26)>0,$V19),OFFSET(U19,-1,0)+1,OFFSET(U19,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W19)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A20)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B20)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C20)-ROW(C$15),0)","v":"5."},{"$f":"OFFSET(QCI!G$15,ROW(F20)-ROW(F$15),0)","v":0},{"$f":"IF($V20,OFFSET(QCI!H$15,ROW(G20)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B20=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H20)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J20)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J20)-ROW(J$15),0))","v":""},{"$f":"IF($V20,OFFSET(QCI!K$15,ROW(M20)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB20)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M20/($J20+10^-12)*OFFSET(QCI!$M$15,ROW(K20)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M20/($J20+10^-12)*OFFSET(QCI!$N$15,ROW(L20)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q20/($J20+10^-12)*OFFSET(QCI!$M$15,ROW(O20)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q20/($J20+10^-12)*OFFSET(QCI!$N$15,ROW(P20)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X20)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H20,$H20)=1,$H20<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H20,$N$9:$N$26)>0,$V20),OFFSET(U20,-1,0)+1,OFFSET(U20,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W20)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A21)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B21)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C21)-ROW(C$15),0)","v":"6."},{"$f":"OFFSET(QCI!G$15,ROW(F21)-ROW(F$15),0)","v":0},{"$f":"IF($V21,OFFSET(QCI!H$15,ROW(G21)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B21=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H21)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J21)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J21)-ROW(J$15),0))","v":""},{"$f":"IF($V21,OFFSET(QCI!K$15,ROW(M21)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB21)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M21/($J21+10^-12)*OFFSET(QCI!$M$15,ROW(K21)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M21/($J21+10^-12)*OFFSET(QCI!$N$15,ROW(L21)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q21/($J21+10^-12)*OFFSET(QCI!$M$15,ROW(O21)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q21/($J21+10^-12)*OFFSET(QCI!$N$15,ROW(P21)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X21)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H21,$H21)=1,$H21<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H21,$N$9:$N$26)>0,$V21),OFFSET(U21,-1,0)+1,OFFSET(U21,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W21)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A22)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B22)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C22)-ROW(C$15),0)","v":"7."},{"$f":"OFFSET(QCI!G$15,ROW(F22)-ROW(F$15),0)","v":0},{"$f":"IF($V22,OFFSET(QCI!H$15,ROW(G22)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B22=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H22)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J22)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J22)-ROW(J$15),0))","v":""},{"$f":"IF($V22,OFFSET(QCI!K$15,ROW(M22)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB22)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M22/($J22+10^-12)*OFFSET(QCI!$M$15,ROW(K22)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M22/($J22+10^-12)*OFFSET(QCI!$N$15,ROW(L22)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q22/($J22+10^-12)*OFFSET(QCI!$M$15,ROW(O22)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q22/($J22+10^-12)*OFFSET(QCI!$N$15,ROW(P22)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X22)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H22,$H22)=1,$H22<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H22,$N$9:$N$26)>0,$V22),OFFSET(U22,-1,0)+1,OFFSET(U22,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W22)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A23)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B23)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C23)-ROW(C$15),0)","v":"8."},{"$f":"OFFSET(QCI!G$15,ROW(F23)-ROW(F$15),0)","v":0},{"$f":"IF($V23,OFFSET(QCI!H$15,ROW(G23)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B23=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H23)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J23)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J23)-ROW(J$15),0))","v":""},{"$f":"IF($V23,OFFSET(QCI!K$15,ROW(M23)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB23)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M23/($J23+10^-12)*OFFSET(QCI!$M$15,ROW(K23)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M23/($J23+10^-12)*OFFSET(QCI!$N$15,ROW(L23)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q23/($J23+10^-12)*OFFSET(QCI!$M$15,ROW(O23)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q23/($J23+10^-12)*OFFSET(QCI!$N$15,ROW(P23)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X23)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H23,$H23)=1,$H23<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H23,$N$9:$N$26)>0,$V23),OFFSET(U23,-1,0)+1,OFFSET(U23,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W23)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A24)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B24)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C24)-ROW(C$15),0)","v":"9."},{"$f":"OFFSET(QCI!G$15,ROW(F24)-ROW(F$15),0)","v":0},{"$f":"IF($V24,OFFSET(QCI!H$15,ROW(G24)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B24=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H24)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J24)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J24)-ROW(J$15),0))","v":""},{"$f":"IF($V24,OFFSET(QCI!K$15,ROW(M24)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB24)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M24/($J24+10^-12)*OFFSET(QCI!$M$15,ROW(K24)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M24/($J24+10^-12)*OFFSET(QCI!$N$15,ROW(L24)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q24/($J24+10^-12)*OFFSET(QCI!$M$15,ROW(O24)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q24/($J24+10^-12)*OFFSET(QCI!$N$15,ROW(P24)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X24)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H24,$H24)=1,$H24<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H24,$N$9:$N$26)>0,$V24),OFFSET(U24,-1,0)+1,OFFSET(U24,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W24)-ROW(X$15),0)","v":true},0,0]
[{"$f":"OFFSET(QCI!B$15,ROW(A25)-ROW(A$15),0)","v":1},{"$f":"OFFSET(QCI!C$15,ROW(B25)-ROW(B$15),0)","v":"Meta"},{"$f":"OFFSET(QCI!D$15,ROW(C25)-ROW(C$15),0)","v":"10."},{"$f":"OFFSET(QCI!G$15,ROW(F25)-ROW(F$15),0)","v":0},{"$f":"IF($V25,OFFSET(QCI!H$15,ROW(G25)-ROW(G$15),0),\"\")","v":0},{"$f":"IF($B25=\"Sub-Meta\",\"\",OFFSET(QCI!I$15,ROW(H25)-ROW(H$15),0))","v":0},{"$f":"IF(ISERROR(OFFSET(QCI!J$15,ROW(J25)-ROW(J$15),0)),\"\",OFFSET(QCI!J$15,ROW(J25)-ROW(J$15),0))","v":""},{"$f":"IF($V25,OFFSET(QCI!K$15,ROW(M25)-ROW(M$15),0),\"\")","v":0},null,{"$f":"OFFSET(QCI!O$15,ROW(AB25)-ROW(AB$15),0)","v":0},{"$f":"ROUND(M25/($J25+10^-12)*OFFSET(QCI!$M$15,ROW(K25)-ROW(K$15),0),2)","v":0},{"$f":"ROUND(M25/($J25+10^-12)*OFFSET(QCI!$N$15,ROW(L25)-ROW(L$15),0),2)","v":0},0,0,{"$f":"ROUND(Q25/($J25+10^-12)*OFFSET(QCI!$M$15,ROW(O25)-ROW(O$15),0),2)","v":0},{"$f":"ROUND(Q25/($J25+10^-12)*OFFSET(QCI!$N$15,ROW(P25)-ROW(P$15),0),2)","v":0},0,0,null,{"$f":"OFFSET(QCI!X$15,ROW(X25)-ROW(W$15),0)","v":0},{"$f":"IF(AND(COUNTIF($H$9:$H25,$H25)=1,$H25<>\"Adm. Direta\",SUMIF($H$9:$H$26,$H25,$N$9:$N$26)>0,$V25),OFFSET(U25,-1,0)+1,OFFSET(U25,-1,0))","v":0},{"$f":"OFFSET(QCI!Y$15,ROW(W25)-ROW(X$15),0)","v":true},0,0]
[]
[]
["Observações:"]
[]
[]
[]
[{"$f":"QCI!H36","v":"Local:"},null,null,null,null,null,null,null,{"$f":"QCI!H37","v":"Data:"},{"$f":"TODAY()","v":"2018-01-25"}]
[]
[{"$f":"IF(RREMode=\"RRET\",\"Responsável Técnico\",\"Profissional Responsável CAIXA\")","v":"Responsável Técnico"},null,null,null,null,null,null,{"$f":"IF(RREMode=\"RREV\",\"Responsável Gerencial CAIXA:\",QCI!$C$35)","v":"Representante Tomador / Agente Promotor"}]
["Nome:",null,null,null,null,null,null,"Nome:"]
[{"$f":"IF(RREMode=\"RREV\",\"Função:\",\"Cargo:\")","v":"Cargo:"},null,null,null,null,null,null,{"$f":"IF(RREMode=\"RREV\",\"Função:\",\"Cargo:\")","v":"Cargo:"}]
[{"$f":"IF(RREMode=\"RREV\",\"Matrícula:\",\"ART/RRT Fiscal.:\")","v":"ART/RRT Fiscal.:"},null,null,null,null,null,null,{"$f":"IF(RREMode=\"RREV\",\"Matrícula:\",\"\")","v":""}]
[]
[{"$f":"IF(RREMode=\"RRET\",\"Responsável Social\",\"Responsável Social CAIXA\")","v":"Responsável Social"},null,null,null,null,null,null,{"$f":"IF(RREMode=\"RREV\",\"Responsável Operacional CAIXA\",\"Responsável Financeiro\")","v":"Responsável Financeiro"}]
["Nome:",null,null,null,null,null,null,"Nome:"]
[{"$f":"IF(RREMode=\"RREV\",\"Função:\",\"Cargo:\")","v":"Cargo:"},null,null,null,null,null,null,{"$f":"IF(RREMode=\"RREV\",\"Função:\",\"Cargo:\")","v":"Cargo:"}]
[{"$f":"IF(RREMode=\"RREV\",\"Matrícula:\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(RREMode=\"RREV\",\"Matrícula:\",\"\")","v":""}]

{"sheet":"Ofício","index":4,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,6,2,9],[6,6,6,9],[12,1,12,5],[5,1,5,2],[6,0,6,5],[8,0,8,2],[9,6,9,7],[0,0,3,1],[9,1,9,2],[13,1,13,5],[35,0,35,5],[36,0,36,5],[32,4,32,5],[26,2,27,2],[15,1,15,5],[31,0,31,1],[22,0,24,5],[16,1,16,5],[28,4,28,5],[53,0,54,5],[15,7,15,9],[17,7,18,9],[17,6,18,6],[16,7,16,9],[53,6,54,9],[20,6,21,9],[52,6,52,9],[17,1,18,5],[17,0,18,0],[26,3,27,3],[26,4,27,5],[29,0,29,1],[29,4,29,5],[28,0,28,1],[26,0,27,1],[52,0,52,5],[30,0,30,1],[30,4,30,5],[31,4,31,5],[32,0,32,1],[37,0,38,5],[40,0,44,5]]}
[null,null,null,null,null,"Grau de Sigilo"]
[null,null,null,null,null,"# PÚBLICO"]
[]
[]
[]
["Ofício n°:",null,null,null,""]
[{"$f":"CONCATENATE(RRE!$B$32,\", \",TEXT(RRE!$J$32,\"dd\"\" de \"\"mmmm\"\" de \"\"aaaa\"))","v":", 25 de janeiro de 2018"},null,null,null,null,null,{"$f":"A7","v":", 25 de janeiro de 2018"}]
["À",null,null,null,null,null,"À"]
["CAIXA ECONÔMICA FEDERAL",null,null,null,null,null,"CAIXA ECONÔMICA FEDERAL"]
["GIGOV",null,null,null,null,null,{"$f":"CONCATENATE(A10,\" \",B10)","v":"GIGOV "}]
[]
[]
["Assunto:",{"$f":"CONCATENATE(\"Solicitação de autorização de \",IF(DADOS!$J$22=\"FGTS\",\"desembolso\",\"desbloqueio\"),\" de recursos  - Medição n° \",RRE!$I$5)","v":"Solicitação de autorização de desbloqueio de recursos  - Medição n° 1"},null,null,null,null,"Assunto:",{"$f":"CONCATENATE(\"Relação de Fornecedores - Medição n° \",RRE!$I$5)","v":"Relação de Fornecedores - Medição n° 1"}]
["REF:",{"$f":"CONCATENATE(IF(DADOS!$J$22=\"FGTS\",\"Contrato de Financiamento\",IF(DADOS!$J$22=\"OGU PAC\",\"Termo de Compromisso\",\"Contrato de Repasse\")),\" - Operação nº: \",DADOS!$A$22,IF(DADOS!$B$22=\"\",\"\",CONCATENATE(\" - SICONV nº: \",DADOS!$B$22)))","v":"Contrato de Repasse - Operação nº: 1.037.474-20/2017 - SICONV nº: 844520/2017"},null,null,null,null,"REF:",{"$f":"B14","v":"Contrato de Repasse - Operação nº: 1.037.474-20/2017 - SICONV nº: 844520/2017"}]
[]
["Programa:",{"$f":"DADOS!$E$22","v":"Planejamento Urbano"},null,null,null,null,"Programa:",{"$f":"B16","v":"Planejamento Urbano"}]
["Objeto:",{"$f":"DADOS!$A$28","v":"Implantação de pavimentação asfaltica em vias urbanas do Município de Bom Jesus SC."},null,null,null,null,"Objeto:",{"$f":"B17","v":"Implantação de pavimentação asfaltica em vias urbanas do Município de Bom Jesus SC."}]
[{"$f":"IF(DADOS!$J$22=\"OGU não-PAC\",\"Proponente / Tomador:\",\"Proponente / Compromissário:\")","v":"Proponente / Tomador:"},{"$f":"DADOS!$A$25","v":"Município de Bom Jesus"},null,null,null,null,{"$f":"A18","v":"Proponente / Tomador:"},{"$f":"B18","v":"Município de Bom Jesus"}]
[]
[]
[{"$f":"IF(A10=\"GIGOV\",\"Senhor Gerente\",\"Senhor Superintendente\")","v":"Senhor Gerente"},null,null,null,null,null,"1. Informamos abaixo a relação de fornecedores para a Solicitação de Recursos referenciada:"]
[null,null,null,null,null,null,null,null,null,null,null,"Rel. Forn.","CTEF"]
[{"$f":"CONCATENATE(\"1. Vimos pelo presente, solicitar à Caixa Econômica Federal autorização para \",IF(DADOS!$J$22=\"FGTS\",\"desembolso\",\"desbloqueio\"),\" da parcela de recursos relativa ao \",IF(DADOS!$J$22=\"FGTS\",\"Contrato de Financiamento\",IF(DADOS!$J$22=\"OGU PAC\",\"Termo de Compromisso\",\"Contrato de Repasse\")),\" em referência, conforme valores abaixo discriminados e, para tanto, anexamos a documentação necessária ao pleito.\")","v":"1. Vimos pelo presente, solicitar à Caixa Econômica Federal autorização para desbloqueio da parcela de recursos relativa ao Contrato de Repasse em referência, conforme valores abaixo discriminados e, para tanto, anexamos a documentação necessária ao pleito."},null,null,null,null,null,"CTEF:","Nome do Fornecedor:","CNPJ / CPF:","Valor (R$):"]
[null,null,null,null,null,null,{"$f":"IF(ISERROR($M24),\"\",$M24)","v":""},{"$f":"IF($G24=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G24)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G24,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G24=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G24)=0),\"\",VLOOKUP(Ofício!$G24,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M24),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G24,RRE!$N$15:$N$26))","v":""},null,{"$f":"OFFSET(L24,-1,0)+1","v":1},{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L24,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G25=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G25)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G25,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G25=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G25)=0),\"\",VLOOKUP(Ofício!$G25,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M25),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G25,RRE!$N$15:$N$26))","v":""},null,{"$f":"OFFSET(L25,-1,0)+1","v":2},{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L25,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G26=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G26)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G26,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G26=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G26)=0),\"\",VLOOKUP(Ofício!$G26,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M26),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G26,RRE!$N$15:$N$26))","v":""},null,3,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L26,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,"Valores Vigentes do TC/CR",{"$f":"CONCATENATE(\"Evolução da \",RRE!$I$5,\"ª Medição\")","v":"Evolução da 1ª Medição"},"Valores Medidos Acumulados",null,"",{"$f":"IF($G27=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G27)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G27,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G27=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G27)=0),\"\",VLOOKUP(Ofício!$G27,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M27),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G27,RRE!$N$15:$N$26))","v":""},null,4,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L27,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G28=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G28)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G28,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G28=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G28)=0),\"\",VLOOKUP(Ofício!$G28,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M28),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G28,RRE!$N$15:$N$26))","v":""},null,5,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L28,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[{"$f":"CONCATENATE(QCI!$L$9,\":\")","v":"Repasse:"},null,{"$f":"RRE!J12","v":245850},{"$f":"RRE!N12","v":0},{"$f":"RRE!Q12","v":0},null,"",{"$f":"IF($G29=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G29)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G29,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G29=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G29)=0),\"\",VLOOKUP(Ofício!$G29,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M29),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G29,RRE!$N$15:$N$26))","v":""},null,6,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L29,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
["Contrapartida Financeira:",null,{"$f":"RRE!J13","v":11145.37},{"$f":"RRE!N13","v":0},{"$f":"RRE!Q13","v":0},null,"",{"$f":"IF($G30=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G30)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G30,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G30=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G30)=0),\"\",VLOOKUP(Ofício!$G30,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M30),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G30,RRE!$N$15:$N$26))","v":""},null,7,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L30,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[{"$f":"CONCATENATE(QCI!$N$9,\":\")","v":"Outros:"},null,{"$f":"RRE!J14","v":0},{"$f":"RRE!N14","v":0},{"$f":"RRE!Q14","v":0},null,"",{"$f":"IF($G31=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G31)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G31,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G31=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G31)=0),\"\",VLOOKUP(Ofício!$G31,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M31),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G31,RRE!$N$15:$N$26))","v":""},null,8,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L31,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
["Investimento:",null,{"$f":"RRE!J15","v":256995.37},{"$f":"RRE!N15","v":0},{"$f":"RRE!Q15","v":0},null,"",{"$f":"IF($G32=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G32)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G32,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G32=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G32)=0),\"\",VLOOKUP(Ofício!$G32,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M32),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G32,RRE!$N$15:$N$26))","v":""},null,9,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L32,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
["Execução Física:",null,"-",{"$f":"RRE!N15/(RRE!J15+10^-12)","v":0},{"$f":"RRE!R12","v":0},null,"",{"$f":"IF($G33=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G33)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G33,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G33=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G33)=0),\"\",VLOOKUP(Ofício!$G33,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M33),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G33,RRE!$N$15:$N$26))","v":""},null,10,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L33,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G34=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G34)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G34,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G34=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G34)=0),\"\",VLOOKUP(Ofício!$G34,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M34),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G34,RRE!$N$15:$N$26))","v":""},null,11,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L34,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G35=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G35)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G35,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G35=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G35)=0),\"\",VLOOKUP(Ofício!$G35,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M35),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G35,RRE!$N$15:$N$26))","v":""},null,12,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L35,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[{"$f":"IF(RRE.NumMedicao>1,\"2. Encaminhamos ainda a documentação relativa à prestação de contas da etapa físico-financeira anterior.\",\"\")","v":""},null,null,null,null,null,"",{"$f":"IF($G36=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G36)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G36,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G36=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G36)=0),\"\",VLOOKUP(Ofício!$G36,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M36),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G36,RRE!$N$15:$N$26))","v":""},null,13,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L36,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G37=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G37)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G37,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G37=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G37)=0),\"\",VLOOKUP(Ofício!$G37,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M37),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G37,RRE!$N$15:$N$26))","v":""},null,14,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L37,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[{"$f":"IF(AND(RRE.NumMedicao>1,NOT(ISBLANK(Import.SICONV))),\"3. Na oportunidade, informamos que a execução financeira da parcela anterior está devidamente comprovada no SICONV.\",\"\")","v":""},null,null,null,null,null,"",{"$f":"IF($G38=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G38)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G38,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G38=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G38)=0),\"\",VLOOKUP(Ofício!$G38,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M38),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G38,RRE!$N$15:$N$26))","v":""},null,15,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L38,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G39=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G39)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G39,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G39=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G39)=0),\"\",VLOOKUP(Ofício!$G39,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M39),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G39,RRE!$N$15:$N$26))","v":""},null,16,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L39,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G40=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G40)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G40,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G40=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G40)=0),\"\",VLOOKUP(Ofício!$G40,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M40),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G40,RRE!$N$15:$N$26))","v":""},null,17,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L40,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[{"$f":"IF($A$23=\"\",0,1)+IF($A$36=\"\",0,1)+IF($A$38=\"\",0,1)+1&\". Informamos também a manutenção da Placa de Obra em local visível e de acordo com padrão estabelecido pela Presidência da República, constante do Manual Visual de Placas e Adesivos de Obra.\"","v":"2. Informamos também a manutenção da Placa de Obra em local visível e de acordo com padrão estabelecido pela Presidência da República, constante do Manual Visual de Placas e Adesivos de Obra."},null,null,null,null,null,"",{"$f":"IF($G41=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G41)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G41,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G41=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G41)=0),\"\",VLOOKUP(Ofício!$G41,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M41),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G41,RRE!$N$15:$N$26))","v":""},null,18,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L41,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G42=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G42)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G42,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G42=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G42)=0),\"\",VLOOKUP(Ofício!$G42,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M42),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G42,RRE!$N$15:$N$26))","v":""},null,19,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L42,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G43=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G43)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G43,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G43=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G43)=0),\"\",VLOOKUP(Ofício!$G43,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M43),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G43,RRE!$N$15:$N$26))","v":""},null,20,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L43,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G44=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G44)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G44,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G44=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G44)=0),\"\",VLOOKUP(Ofício!$G44,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M44),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G44,RRE!$N$15:$N$26))","v":""},null,21,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L44,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"",{"$f":"IF($G45=\"\",\"\",IF(COUNTIF(DADOS!$B$56:$B$77,Ofício!$G45)=0,\"(cadastre na aba Dados)\",VLOOKUP(Ofício!$G45,DADOS!$B$56:$F$77,2,FALSE)))","v":""},{"$f":"IF(OR($G45=\"\",COUNTIF(DADOS!$B$56:$B$77,Ofício!$G45)=0),\"\",VLOOKUP(Ofício!$G45,DADOS!$B$56:$F$77,5,FALSE))","v":""},{"$f":"IF(ISERROR(M45),\"\",SUMIF(RRE!$H$15:$H$26,Ofício!G45,RRE!$N$15:$N$26))","v":""},null,22,{"$f":"INDEX(RRE!$H$15:$H$26,MATCH(Ofício!L45,RRE!$U$15:$U$26,0))","v":{"$error":"#N/A"}}]
[]
[]
["Atenciosamente,",null,null,null,null,null,"Atenciosamente,"]
[]
[]
[]
[]
[{"$f":"RRE!I35","v":0},null,null,null,null,null,{"$f":"A53","v":0}]
[{"$f":"B18","v":"Município de Bom Jesus"},null,null,null,null,null,{"$f":"A54","v":"Município de Bom Jesus"}]

{"sheet":"Listas","index":5,"n_rows":19,"n_cols":36,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,3,0,35]]}
[null,null,null,"Sub-Itens de Investimento"]
[null,"Itens de Investimento","Unidades habitacionais",{"$f":"COUNTA(C:C)-1","v":3},"Equipamentos comunitários",{"$f":"COUNTA(E:E)-1","v":6},"Pavimentação",{"$f":"COUNTA(G:G)-1","v":6},"Drenagem ",{"$f":"COUNTA(I:I)-1","v":6},"Abastecimento de água",{"$f":"COUNTA(K:K)-1","v":11},"Esgotamento sanitário",{"$f":"COUNTA(M:M)-1","v":8},"Energia elétrica e iluminação pública",{"$f":"COUNTA(O:O)-1","v":4},"Coleta e tratamento de resíduos sólidos",{"$f":"COUNTA(Q:Q)-1","v":6},"Contenção e estabilização de encostas ",{"$f":"COUNTA(S:S)-1","v":2},"Regularização fundiária",{"$f":"COUNTA(U:U)-1","v":2},"Aquisição de terreno",{"$f":"COUNTA(W:W)-1","v":2},"Aquisição de equipamentos e insumos",{"$f":"COUNTA(Y:Y)-1","v":1},"Elaboração de estudos e projetos",{"$f":"COUNTA(AA:AA)-1","v":1},"Instrumentos e ações em planejamento e gestão pública",{"$f":"COUNTA(AC:AC)-1","v":1},"Ações complementares às obras",{"$f":"COUNTA(AE:AE)-1","v":3},"Gerenciamento",{"$f":"COUNTA(AG:AG)-1","v":1},"Trabalho social",{"$f":"COUNTA(AI:AI)-1","v":4}]
[null,"Unidades habitacionais","Aquisição","un","Convivência comunitária, assistência social e/ou comunitária","m²","Capeamento de vias","m²","Obras de microdrenagem ","m","Captação subterrânea","m³/s","Ligações domiciliares e/ou intradomiciliares","un","Iluminação pública - luminárias","un","Acondicionamento ","un","Estabilização de taludes","m²","Desapropriacões/Indenizações","m²","Aquisição de terreno","m²","Aquisição de equipamentos e insumos","un","Elaboração de estudos e projetos","un","Instrumentos e ações em planejamento e gestão pública","un","Avaliação pós intervenção","un","Gerenciamento","%CT","Projeto de Trabalho Social Preliminar","nº fam"]
[null,"Equipamentos comunitários","Construção","un","Educação e cultura","m²","Recapeamento de vias","m²","Desassoreamento de cursos de água","m","Captação superficial","m³/s","Rede coletora e/ou condominial","m","Ligações domiciliares","un","Aterro sanitário e/ou disposição final","m³","Obras complementares a ações de redução de risco e/ou contenções","m²","Projeto de Regularização Fundiária","m²","Benfeitorias","m²",null,null,null,null,null,null,"Demolições","un",null,null,"Projeto de Trabalho Social","nº fam"]
[null,"Pavimentação","Reforma e/ou melhoria","un","Esportes","m²","Obras de artes especiais","m","Canalização de cursos de água","m","Estação de bombeamento de água bruta","m³/s","Coletor tronco e/ou interceptores","m","Linhas de distribuição - baixa tensão ","m","Erradicação de lixões","m³",null,null,null,null,null,null,null,null,null,null,null,null,"Plano de Reassentamento e medidas compensatórias","un",null,null,"Plano de Desenvolvimento Socioterritorial","nº fam"]
[null,"Drenagem ",null,null,"Lazer e turismo","m²","Pavimentação de calçadas","m²","Recomposição de vegetação ciliar, renaturalização de cursos de água ou restauração de margens","m²","Adução","m","Emissário","m","Linhas de transmissão - alta tensão ","m","Sistema de coleta seletiva tradicional, transporte e/ou equipamentos","un",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plano de Gestão Condominial","nº fam"]
[null,"Abastecimento de água",null,null,"Saúde","m²","Pavimentação de vias","m²","Reservatório de amortecimento de cheias","m³","Estação de Tratamento de Água (ETA)","m³/s","Estação Elevatória","m³/s",null,null,"Tratamento local ","un"]
[null,"Esgotamento sanitário",null,null,"Segurança pública","m²","Sinalização","m²","Estação de Bombeamento","m³/s","Estação de bombeamento de água tratada","m³/s","Estação de Tratamento de Esgoto (ETE)","m³/s",null,null,"Usinas de reciclagem ","m²"]
[null,"Energia elétrica e iluminação pública",null,null,null,null,null,null,null,null,"Linha de recalque","m","Sistema simplificado de tratamento","m³/s"]
[null,"Coleta e tratamento de resíduos sólidos",null,null,null,null,null,null,null,null,"Reservação","m³","Unidades sanitárias","un"]
[null,"Contenção e estabilização de encostas ",null,null,null,null,null,null,null,null,"Rede de distribuição","m"]
[null,"Regularização fundiária",null,null,null,null,null,null,null,null,"Ligações domiciliares e/ou intradomiciliares","un"]
[null,"Aquisição de terreno",null,null,null,null,null,null,null,null,"Sistema simplificado de abastecimento","m"]
[null,"Aquisição de equipamentos e insumos"]
[null,"Elaboração de estudos e projetos"]
[null,"Instrumentos e ações em planejamento e gestão pública"]
[null,"Ações complementares às obras"]
[null,"Gerenciamento"]
[null,"Trabalho social"]