{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["00. MENU","01. PC","02. FCL","03. D&A Fiscal","04. NIG","05. CAPEX","06. OPEX","07. (a)TRIBUTOS LREAL","07. (b)TRIBUTOS LPRESUMID","08. RECEITA E DEMANDA","09. SENSIBILIDADE","10. ÍNDICES","11. WACC "],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":4,"defined_names":139,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"00. MENU","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,4],[32,1,32,4],[33,1,33,4],[15,1,15,9],[19,1,19,9],[21,1,21,9],[23,1,23,9],[17,1,17,9],[25,1,25,9],[27,1,27,9],[29,1,29,9],[5,1,5,9],[9,1,9,9],[11,1,11,9],[13,1,13,9],[7,1,7,9]]}
[]
[]
[]
[]
[]
[null,"CONCESSÃO DE TRANSPORTE COLETIVO DE PONTA GROSSA"]
[null,"01. PC"]
[null,"Painel de controle das principais variáveis do modelo. Nesta aba é possível alterar variáveis como prazo do projeto, NIG, WACC, VPL e etc. Além de alterar as premissas, é possível ver os principais outputs do modelo."]
[null,"02. FCL"]
[null,"Apresenta o Fluxo de Caixa Livre do Projeto. O resultado obtido pode ser alterado a depender do que é selecionado no Painel de Controle."]
[null,"03. D&A"]
[null,"Calcula a depreciação e amortização fiscais dos ativos."]
[null,"04. NIG"]
[null,"Calcula a necessidade de investimento no giro."]
[null,"05. CAPEX"]
[null,"Detalhamento dos valores de CAPEX na compra e venda dos veículos da frota."]
[null,"06. OPEX"]
[null,"Aba de entrada dos inputs relacionados à operação. Utilizada para inserir os valores na moeda de referência dos preços."]
[null,"07. (a)TRIBUTOS LREAL"]
[null,"Calcula os tributos do regime fiscal de Lucro Real para cada ano para o FCL do Projeto."]
[null,"07. (b)TRIBUTOS LPRESUMID"]
[null,"Calcula os tributos do regime fiscal de Lucro Presumido para cada ano para o FCL do Projeto."]
[null,"08. RECEITA E DEMANDA"]
[null,"Calcula a previsão de receita com base na tarifa e perspectiva de demanda de passageiros"]
[null,"09. SENSIBILIDADE"]
[null,"Calcula o impacto nos principais indicadores do Projeto, quando da variação da Receita, OPEX, CAPEX e encargos."]
[null,"10. ÍNDICES"]
[null,"Relação de índices econômicos publicados."]
[null,"11. WACC"]
[null,"Cálculo do custo médio ponderado de capital (WACC)."]
[]
[null,"Padrão de formatação utilizado - Legenda"]
[null,"Células com fundo amarelo e fonte azul",null,null,null,"Inputs (Podem ser alteradas)"]
[null,"Células com fonte verde",null,null,null,"Células que têm origem em outra aba (Não alterar)"]
[null,"Células com fonte preta",null,null,null,"Fórmulas (Não alterar)"]

{"sheet":"01. PC","index":1,"n_rows":71,"n_cols":27,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","não"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","não"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","não"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sim","não"]
[]
[null,"Premissas","Valor"]
[]
[null,"WACC - % a.a.",{"$f":"'11. WACC '!C27","v":8.4113117668753401E-2}]
[]
[null,"TIR de Projeto - Real",{"$f":"'02. FCL'!C41","v":8.4107545582134957E-2}]
[]
[null,"VPL - R$ Milhões",{"$f":"'02. FCL'!C42","v":0}]
[]
[null,"NIG - meses",0]
[]
[null,"Prazo - em anos",10]
[]
[null,"Tarifa remuneração",4.1426403511977989]
[]
[null,"Passageiros Equivalentes por ano",200000]
[]
[null,"Tipo de Ônibus","Padron Diesel"]
[]
[null,"Idade",15]
[]
[null,"Correção OPEX",null,null,null,"Regra para correção OPEX "]
[]
[null,"Combustível","IPCA",null,null,"IGP-M"]
[null,"Lubrificante Diesel","IPCA",null,null,"IGP-M"]
[null,"Arla 32","IPCA",null,null,"IGP-M"]
[null,"Rodagem","IPCA",null,null,"IGP-M"]
[null,"Peças e Materiais de Manutenção","IPCA",null,null,"IPCA"]
[null,"Motoristas - Direção","IPCA",null,null,"IPCA"]
[null,"Motoristas - Cobrança","IPCA",null,null,"IPCA"]
[null,"Cobradores","IPCA",null,null,"IPCA"]
[null,"Benefícios Trabalhistas","IPCA",null,null,"IPCA"]
[null,"Operação da Frota Auxiliar (Serviços)","IPCA",null,null,"IPCA"]
[null,"Operac. e Manut. Infra Garagem","IPCA",null,null,"IPCA"]
[null,"Operação de ITS","IPCA",null,null,"IPCA"]
[null,"Operação de Bilhetagem","IPCA",null,null,"IPCA"]
[null,"Fiscalização","IPCA",null,null,"IPCA"]
[null,"Mão de Obra Manutenção, Adm. e Diretoria","IPCA",null,null,"IPCA"]
[null,"Despesas Administrativas Gerais","IPCA",null,null,"IPCA"]
[null,"Locação de Infraestrutura Garagem","IPCA",null,null,"INCC-M"]
[null,"Manutenção de Infraestrutura","IPCA",null,null,"INCC-M"]
[null,"Despesas Ambientais","IPCA",null,null,"IPCA"]
[null,"Garantias Contratuais","IPCA",null,null,"IPCA"]
[null,"Manutenção Infra Elétrica","IPCA",null,null,"IPCA"]
[null,"Seguro e Licenciamento","IPCA",null,null,"IPCA"]
[null,"Reposição de Baterias","IPCA"]
[null,"Operação ITS/SBE Embarcado","IPCA"]
[]
[null,"Correção CAPEX"]
[]
[null,"Frota","IPCA"]
[]
[null,"Correção Contrato (Receita)"]
[]
[null,"Receita","IPCA"]
[]
[null,"Premissas Marcoeconômicas",1,{"$f":"C63+1","v":2},{"$f":"D63+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[]
[null,"Projeção de Inflação anual ",0.05,{"$f":"$C$65","v":0.05},{"$f":"$C$65","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Fonte: BACEN"]
[]
[]
[null,"Idosos <65"]
[]
[null,"% de perda"]

{"sheet":"02. FCL","index":2,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Fluxo de Caixa Livre (R$ Milhões)"]
[]
[null,"PRAZO",{"$f":"IF(C10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(D10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(E10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(F10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(G10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(H10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(I10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(J10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(K10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(L10<=('01. PC'!$C$18),1,0)","v":1}]
[]
[null,"ANO",1,{"$f":"C10+1","v":2},{"$f":"D10+1","v":3},4,5,6,7,8,9,10,null,"TOTAL",null,"VPL"]
[]
[null,"Receitas",{"$f":"(C14)*C$8","v":0.82852807023955977},{"$f":"(D14)*D$8","v":0.82852807023955977},0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,null,{"$f":"SUM(C12:L12)","v":8.2852807023955961},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D12:L12)+'02. FCL'!C12","v":5.9168824332402981}]
[]
[null,"Receita Tarifária",{"$f":"('08. RECEITA E DEMANDA'!C14)*C8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!D14)*D8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!E14)*E8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!F14)*F8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!G14)*G8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!H14)*H8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!I14)*I8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!J14)*J8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!K14)*K8","v":0.82852807023955977},{"$f":"('08. RECEITA E DEMANDA'!L14)*L8","v":0.82852807023955977},null,{"$f":"SUM(C14:L14)","v":8.2852807023955961},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D14:L14)+'02. FCL'!C14","v":5.9168824332402981}]
[]
[null,"Opex",{"$f":"-(C18+C19)*C$8","v":-0.66821132759180957},{"$f":"-(D18+D19)*D$8","v":-0.66821132759180957},-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,null,{"$f":"SUM(C16:L16)","v":-6.6821132759180948},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D16:L16)+'02. FCL'!C16","v":-4.7719902414132811}]
[]
[null,"Custos Variaveis",{"$f":"('06. OPEX'!C10)*C$8","v":0.52264604905468004},{"$f":"('06. OPEX'!D10)*D$8","v":0.52264604905468004},{"$f":"('06. OPEX'!E10)*E$8","v":0.52264604905468004},{"$f":"('06. OPEX'!F10)*F$8","v":0.52264604905468004},{"$f":"('06. OPEX'!G10)*G$8","v":0.52264604905468004},{"$f":"('06. OPEX'!H10)*H$8","v":0.52264604905468004},{"$f":"('06. OPEX'!I10)*I$8","v":0.52264604905468004},{"$f":"('06. OPEX'!J10)*J$8","v":0.52264604905468004},{"$f":"('06. OPEX'!K10)*K$8","v":0.52264604905468004},{"$f":"('06. OPEX'!L10)*L$8","v":0.52264604905468004},null,{"$f":"SUM(C18:L18)","v":5.2264604905468017},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D18:L18)+'02. FCL'!C18","v":3.7324447264169818}]
[null,"Custos Fixos",{"$f":"('06. OPEX'!C68)*C$8","v":0.14556527853712958},{"$f":"('06. OPEX'!D68)*D$8","v":0.14556527853712958},{"$f":"('06. OPEX'!E68)*E$8","v":0.14556527853712958},{"$f":"('06. OPEX'!F68)*F$8","v":0.14556527853712958},{"$f":"('06. OPEX'!G68)*G$8","v":0.14556527853712958},{"$f":"('06. OPEX'!H68)*H$8","v":0.14556527853712958},{"$f":"('06. OPEX'!I68)*I$8","v":0.14556527853712958},{"$f":"('06. OPEX'!J68)*J$8","v":0.14556527853712958},{"$f":"('06. OPEX'!K68)*K$8","v":0.14556527853712958},{"$f":"('06. OPEX'!L68)*L$8","v":0.14556527853712958},null,{"$f":"SUM(C19:L19)","v":1.4556527853712955},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D19:L19)+'02. FCL'!C19","v":1.0395455149962993}]
[]
[null,"Capex",{"$f":"-(C23+C24)*C$8","v":-0.83813000000000004},{"$f":"-(D23+D24)*D$8","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C21:L21)","v":-0.83813000000000004},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D21:L21)+'02. FCL'!C21","v":-0.83813000000000004}]
[]
[null,"Compra de Frota",{"$f":"('05. CAPEX'!D87)*C8","v":0.83813000000000004},{"$f":"('05. CAPEX'!E87)*D8","v":0},{"$f":"('05. CAPEX'!F87)*E8","v":0},{"$f":"('05. CAPEX'!G87)*F8","v":0},{"$f":"('05. CAPEX'!H87)*G8","v":0},{"$f":"('05. CAPEX'!I87)*H8","v":0},{"$f":"('05. CAPEX'!J87)*I8","v":0},{"$f":"('05. CAPEX'!K87)*J8","v":0},{"$f":"('05. CAPEX'!L87)*K8","v":0},{"$f":"('05. CAPEX'!M87)*L8","v":0},null,{"$f":"SUM(C23:L23)","v":0.83813000000000004},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D23:L23)+'02. FCL'!C23","v":0.83813000000000004}]
[null,"Carregadores e Placas",{"$f":"'05. CAPEX'!AF25/10^6","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,"Tributos",{"$f":"-(C28+C29+C30+C31)*C$8","v":-2.4855842107186794E-2},{"$f":"-(D28+D29+D30+D31)*D$8","v":-2.4855842107186794E-2},-2.4855842107186794E-2,-2.4855842107186794E-2,-5.7095536435840866E-2,-5.7095536435840866E-2,-5.7095536435840866E-2,-5.7095536435840866E-2,-7.057601487360303E-2,-7.0912548290978331E-2,null,{"$f":"SUM(C26:L26)","v":-0.46929407733669198},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D26:L26)+'02. FCL'!C26","v":-0.30677696990824332}]
[]
[null,"ISS",{"$f":"'07. (a)TRIBUTOS LREAL'!C16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!D16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!E16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!F16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!G16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!H16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!I16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!J16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!K16","v":2.4855842107186794E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!L16","v":2.4855842107186794E-2},null,{"$f":"SUM(C28:L28)","v":0.24855842107186799},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D28:L28)+'02. FCL'!C28","v":0.17750647299720898}]
[null,"INSS",{"$f":"'07. (a)TRIBUTOS LREAL'!C21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!D21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!E21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!F21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!G21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!H21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!I21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!J21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!K21","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!L21","v":0},null,{"$f":"SUM(C29:L29)","v":0},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D29:L29)+'02. FCL'!C29","v":0}]
[null,"RESEGE",{"$f":"'07. (a)TRIBUTOS LREAL'!C26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!D26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!E26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!F26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!G26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!H26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!I26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!J26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!K26","v":0},{"$f":"'07. (a)TRIBUTOS LREAL'!L26","v":0},null,{"$f":"SUM(C30:L30)","v":0},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D30:L30)+'02. FCL'!C30","v":0}]
[null,"IRPJ/CSLL",{"$f":"IF('07. (a)TRIBUTOS LREAL'!C125=\"Real\",'07. (a)TRIBUTOS LREAL'!C76,'07. (b)TRIBUTOS LPRESUMID'!C34)","v":0},{"$f":"IF('07. (a)TRIBUTOS LREAL'!D125=\"Real\",'07. (a)TRIBUTOS LREAL'!D76,'07. (b)TRIBUTOS LPRESUMID'!D34)","v":0},{"$f":"IF('07. (a)TRIBUTOS LREAL'!E125=\"Real\",'07. (a)TRIBUTOS LREAL'!E76,'07. (b)TRIBUTOS LPRESUMID'!E34)","v":0},{"$f":"IF('07. (a)TRIBUTOS LREAL'!F125=\"Real\",'07. (a)TRIBUTOS LREAL'!F76,'07. (b)TRIBUTOS LPRESUMID'!F34)","v":0},{"$f":"IF('07. (a)TRIBUTOS LREAL'!G125=\"Real\",'07. (a)TRIBUTOS LREAL'!G76,'07. (b)TRIBUTOS LPRESUMID'!G34)","v":3.2239694328654075E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!H125=\"Real\",'07. (a)TRIBUTOS LREAL'!H76,'07. (b)TRIBUTOS LPRESUMID'!H34)","v":3.2239694328654075E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!I125=\"Real\",'07. (a)TRIBUTOS LREAL'!I76,'07. (b)TRIBUTOS LPRESUMID'!I34)","v":3.2239694328654075E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!J125=\"Real\",'07. (a)TRIBUTOS LREAL'!J76,'07. (b)TRIBUTOS LPRESUMID'!J34)","v":3.2239694328654075E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!K125=\"Real\",'07. (a)TRIBUTOS LREAL'!K76,'07. (b)TRIBUTOS LPRESUMID'!K34)","v":4.5720172766416239E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!L125=\"Real\",'07. (a)TRIBUTOS LREAL'!L76,'07. (b)TRIBUTOS LPRESUMID'!L34)","v":4.605670618379154E-2},null,{"$f":"SUM(C31:L31)","v":0.22073565626482408},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D31:L31)+'02. FCL'!C31","v":0.12927049691103443}]
[]
[null,"Outorga Inicial",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C33:L33)","v":0},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D33:L33)+'02. FCL'!C33","v":0}]
[]
[null,"NIG",{"$f":"'04. NIG'!C20","v":0},{"$f":"'04. NIG'!D20","v":0},{"$f":"'04. NIG'!E20","v":0},{"$f":"'04. NIG'!F20","v":0},{"$f":"'04. NIG'!G20","v":0},{"$f":"'04. NIG'!H20","v":0},{"$f":"'04. NIG'!I20","v":0},{"$f":"'04. NIG'!J20","v":0},{"$f":"'04. NIG'!K20","v":0},{"$f":"'04. NIG'!L20","v":0},null,{"$f":"SUM(C35:L35)","v":0},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D35:L35)+'02. FCL'!C35","v":0}]
[]
[null,"FCL",{"$f":"C12+C16+C21+C26+C33+C35","v":-0.70266909945943667},0.13546090054056339,0.13546090054056339,0.13546090054056339,0.10322120621190933,0.10322120621190933,0.10322120621190933,0.10322120621190933,8.9740727774147169E-2,8.9404194356771868E-2,null,{"$f":"SUM(C37:L37)","v":0.2957433491408098},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D37:L37)+'02. FCL'!C37","v":-1.4778081225741424E-5}]
[]
[null,"FCL Acumulado",{"$f":"C37","v":-0.70266909945943667},{"$f":"(C39+D37)*D8","v":-0.56720819891887331},-0.43174729837830994,-0.29628639783774657,-0.19306519162583724,-8.9843985413927907E-2,1.3377220797981426E-2,0.11659842700989076,0.20633915478403791,0.2957433491408098]
[]
[null,"TIR de Projeto (% ao ano)",{"$f":"IRR(C37:L37)","v":8.4107545582134957E-2}]
[null,"VPL (em R$ Milhões)",{"$f":"ROUND(NPV('01. PC'!$C$10,'02. FCL'!D37:L37)+'02. FCL'!C37,4)","v":0}]

{"sheet":"03. D&A Fiscal","index":3,"n_rows":109,"n_cols":30,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"VIDA ÚTIL","ANOS"]
[null,{"$f":"'01. PC'!C24","v":"Padron Diesel"},{"$f":"'01. PC'!C26","v":15}]
[]
[null,"D&A (R$ Milhões)"]
[]
[null,"PRAZO",{"$f":"IF(C13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(D13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(E13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(F13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(G13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(H13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(I13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(J13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(K13<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(L13<=('01. PC'!$C$18),1,0)","v":1}]
[]
[null,"ANO",1,{"$f":"C13+1","v":2},{"$f":"D13+1","v":3},4,5,6,7,8,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
[]
[null,"Capex",{"$f":"C17+C18","v":0.83813000000000004},{"$f":"D17+D18","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:AA15)","v":0.83813000000000004}]
[]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"('05. CAPEX'!D86)*C$11","v":0.83813000000000004},{"$f":"('05. CAPEX'!E86)*D$11","v":0},{"$f":"('05. CAPEX'!F86)*E$11","v":0},{"$f":"('05. CAPEX'!G86)*F$11","v":0},{"$f":"('05. CAPEX'!H86)*G$11","v":0},{"$f":"('05. CAPEX'!I86)*H$11","v":0},{"$f":"('05. CAPEX'!J86)*I$11","v":0},{"$f":"('05. CAPEX'!K86)*J$11","v":0},{"$f":"('05. CAPEX'!L86)*K$11","v":0},{"$f":"('05. CAPEX'!M86)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C17:AA17)","v":0.83813000000000004}]
[null,"Carregadores e Placas",{"$f":"'05. CAPEX'!AF25/10^6","v":0},{"$f":"-'02. FCL'!D33","v":0},{"$f":"-'02. FCL'!E33","v":0},{"$f":"-'02. FCL'!F33","v":0},{"$f":"-'02. FCL'!G33","v":0},{"$f":"-'02. FCL'!H33","v":0},{"$f":"-'02. FCL'!I33","v":0},{"$f":"-'02. FCL'!J33","v":0},{"$f":"-'02. FCL'!K33","v":0},{"$f":"-'02. FCL'!L33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Cronograma",{"$f":"C22+C35","v":0.83813000000000004},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C20:AA20)","v":0.83813000000000004}]
[]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"SUM(C23:C32)","v":0.83813000000000004},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C22:AA22)","v":0.83813000000000004}]
[null,1,{"$f":"C$17","v":0.83813000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C23:AA23)","v":0.83813000000000004}]
[null,{"$f":"B23+1","v":2},null,{"$f":"D$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C24:AA24)","v":0}]
[null,{"$f":"B24+1","v":3},null,null,{"$f":"E$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,{"$f":"F$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,5,null,null,null,null,{"$f":"G$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,{"$f":"H$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,{"$f":"I$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,{"$f":"J$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B30+1","v":9},null,null,null,null,null,null,null,null,{"$f":"K$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"L$17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,"Carregadores e Placas",{"$f":"SUM(C36:C45)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C35:AA35)","v":0}]
[null,1,{"$f":"C$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C36:AA36)","v":0}]
[null,{"$f":"B36+1","v":2},null,{"$f":"D$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"B37+1","v":3},null,null,{"$f":"E$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,{"$f":"F$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,5,null,null,null,null,{"$f":"G$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,{"$f":"H$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,{"$f":"I$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,{"$f":"J$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,{"$f":"K$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"L$18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Dep. sem perdas reais",{"$f":"C49+C61","v":0.20953250000000001},0.20953250000000001,0.20953250000000001,0.20953250000000001,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C47:AA47)","v":0.83813000000000004}]
[]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"SUM(C50:C59)","v":0.20953250000000001},0.20953250000000001,0.20953250000000001,0.20953250000000001,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C49:AA49)","v":0.83813000000000004}]
[null,1,{"$f":"$AC50*(1/$AD50)*C$11","v":0.20953250000000001},{"$f":"IFERROR(IF(SUM($C50:C50)<$AC50,$AC50*(1/$AD50),0),0)*D$11","v":0.20953250000000001},{"$f":"IFERROR(IF(SUM($C50:D50)<$AC50,$AC50*(1/$AD50),0),0)*E$11","v":0.20953250000000001},{"$f":"IFERROR(IF(SUM($C50:E50)<$AC50,$AC50*(1/$AD50),0),0)*F$11","v":0.20953250000000001},{"$f":"IFERROR(IF(SUM($C50:F50)<$AC50,$AC50*(1/$AD50),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C50:G50)<$AC50,$AC50*(1/$AD50),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C50:H50)<$AC50,$AC50*(1/$AD50),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C50:I50)<$AC50,$AC50*(1/$AD50),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C50:J50)<$AC50,$AC50*(1/$AD50),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C50:K50)<$AC50,$AC50*(1/$AD50),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC23","v":0.83813000000000004},4]
[null,{"$f":"B50+1","v":2},null,{"$f":"IFERROR(IF(SUM($C51:C51)<$AC51,$AC51*(1/$AD51),0),0)*D$11","v":0},{"$f":"IFERROR(IF(SUM($C51:D51)<$AC51,$AC51*(1/$AD51),0),0)*E$11","v":0},{"$f":"IFERROR(IF(SUM($C51:E51)<$AC51,$AC51*(1/$AD51),0),0)*F$11","v":0},{"$f":"IFERROR(IF(SUM($C51:F51)<$AC51,$AC51*(1/$AD51),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C51:G51)<$AC51,$AC51*(1/$AD51),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C51:H51)<$AC51,$AC51*(1/$AD51),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C51:I51)<$AC51,$AC51*(1/$AD51),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C51:J51)<$AC51,$AC51*(1/$AD51),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C51:K51)<$AC51,$AC51*(1/$AD51),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AD50","v":4}]
[null,{"$f":"B51+1","v":3},null,null,{"$f":"IFERROR(IF(SUM($C52:D52)<$AC52,$AC52*(1/$AD52),0),0)*E$11","v":0},{"$f":"IFERROR(IF(SUM($C52:E52)<$AC52,$AC52*(1/$AD52),0),0)*F$11","v":0},{"$f":"IFERROR(IF(SUM($C52:F52)<$AC52,$AC52*(1/$AD52),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C52:G52)<$AC52,$AC52*(1/$AD52),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C52:H52)<$AC52,$AC52*(1/$AD52),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C52:I52)<$AC52,$AC52*(1/$AD52),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C52:J52)<$AC52,$AC52*(1/$AD52),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C52:K52)<$AC52,$AC52*(1/$AD52),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AD51","v":4}]
[null,4,null,null,null,{"$f":"IFERROR(IF(SUM($C53:E53)<$AC53,$AC53*(1/$AD53),0),0)*F$11","v":0},{"$f":"IFERROR(IF(SUM($C53:F53)<$AC53,$AC53*(1/$AD53),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C53:G53)<$AC53,$AC53*(1/$AD53),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C53:H53)<$AC53,$AC53*(1/$AD53),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C53:I53)<$AC53,$AC53*(1/$AD53),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C53:J53)<$AC53,$AC53*(1/$AD53),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C53:K53)<$AC53,$AC53*(1/$AD53),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4]
[null,5,null,null,null,null,{"$f":"IFERROR(IF(SUM($C54:F54)<$AC54,$AC54*(1/$AD54),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C54:G54)<$AC54,$AC54*(1/$AD54),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C54:H54)<$AC54,$AC54*(1/$AD54),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C54:I54)<$AC54,$AC54*(1/$AD54),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C54:J54)<$AC54,$AC54*(1/$AD54),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C54:K54)<$AC54,$AC54*(1/$AD54),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4]
[null,6,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C55:G55)<$AC55,$AC55*(1/$AD55),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C55:H55)<$AC55,$AC55*(1/$AD55),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C55:I55)<$AC55,$AC55*(1/$AD55),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C55:J55)<$AC55,$AC55*(1/$AD55),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C55:K55)<$AC55,$AC55*(1/$AD55),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4]
[null,7,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C56:H56)<$AC56,$AC56*(1/$AD56),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C56:I56)<$AC56,$AC56*(1/$AD56),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C56:J56)<$AC56,$AC56*(1/$AD56),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C56:K56)<$AC56,$AC56*(1/$AD56),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4]
[null,8,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C57:I57)<$AC57,$AC57*(1/$AD57),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C57:J57)<$AC57,$AC57*(1/$AD57),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C57:K57)<$AC57,$AC57*(1/$AD57),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4]
[null,9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C58:J58)<$AC58,$AC58*(1/$AD58),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C58:K58)<$AC58,$AC58*(1/$AD58),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C59:K59)<$AC59,$AC59*(1/$AD59),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,4]
[]
[null,"Carregadores e Placas",{"$f":"SUM(C62:C71)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C61:AA61)","v":0}]
[null,1,{"$f":"$AC62*(1/$AD62)*C$11","v":0},{"$f":"IFERROR(IF(SUM($C62:C62)<$AC62,$AC62*(1/$AD62),0),0)*D$11","v":0},{"$f":"IFERROR(IF(SUM($C62:D62)<$AC62,$AC62*(1/$AD62),0),0)*E$11","v":0},{"$f":"IFERROR(IF(SUM($C62:E62)<$AC62,$AC62*(1/$AD62),0),0)*F$11","v":0},{"$f":"IFERROR(IF(SUM($C62:F62)<$AC62,$AC62*(1/$AD62),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C62:G62)<$AC62,$AC62*(1/$AD62),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C62:H62)<$AC62,$AC62*(1/$AD62),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C62:I62)<$AC62,$AC62*(1/$AD62),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C62:J62)<$AC62,$AC62*(1/$AD62),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C62:K62)<$AC62,$AC62*(1/$AD62),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC36","v":0},15]
[null,{"$f":"B62+1","v":2},null,{"$f":"IFERROR(IF(SUM($C63:C63)<$AC63,$AC63*(1/$AD63),0),0)*D$11","v":0},{"$f":"IFERROR(IF(SUM($C63:D63)<$AC63,$AC63*(1/$AD63),0),0)*E$11","v":0},{"$f":"IFERROR(IF(SUM($C63:E63)<$AC63,$AC63*(1/$AD63),0),0)*F$11","v":0},{"$f":"IFERROR(IF(SUM($C63:F63)<$AC63,$AC63*(1/$AD63),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C63:G63)<$AC63,$AC63*(1/$AD63),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C63:H63)<$AC63,$AC63*(1/$AD63),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C63:I63)<$AC63,$AC63*(1/$AD63),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C63:J63)<$AC63,$AC63*(1/$AD63),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C63:K63)<$AC63,$AC63*(1/$AD63),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AD62-1","v":14}]
[null,{"$f":"B63+1","v":3},null,null,{"$f":"IFERROR(IF(SUM($C64:D64)<$AC64,$AC64*(1/$AD64),0),0)*E$11","v":0},{"$f":"IFERROR(IF(SUM($C64:E64)<$AC64,$AC64*(1/$AD64),0),0)*F$11","v":0},{"$f":"IFERROR(IF(SUM($C64:F64)<$AC64,$AC64*(1/$AD64),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C64:G64)<$AC64,$AC64*(1/$AD64),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C64:H64)<$AC64,$AC64*(1/$AD64),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C64:I64)<$AC64,$AC64*(1/$AD64),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C64:J64)<$AC64,$AC64*(1/$AD64),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C64:K64)<$AC64,$AC64*(1/$AD64),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"AD63-1","v":13}]
[null,4,null,null,null,{"$f":"IFERROR(IF(SUM($C65:E65)<$AC65,$AC65*(1/$AD65),0),0)*F$11","v":0},{"$f":"IFERROR(IF(SUM($C65:F65)<$AC65,$AC65*(1/$AD65),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C65:G65)<$AC65,$AC65*(1/$AD65),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C65:H65)<$AC65,$AC65*(1/$AD65),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C65:I65)<$AC65,$AC65*(1/$AD65),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C65:J65)<$AC65,$AC65*(1/$AD65),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C65:K65)<$AC65,$AC65*(1/$AD65),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,12]
[null,5,null,null,null,null,{"$f":"IFERROR(IF(SUM($C66:F66)<$AC66,$AC66*(1/$AD66),0),0)*G$11","v":0},{"$f":"IFERROR(IF(SUM($C66:G66)<$AC66,$AC66*(1/$AD66),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C66:H66)<$AC66,$AC66*(1/$AD66),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C66:I66)<$AC66,$AC66*(1/$AD66),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C66:J66)<$AC66,$AC66*(1/$AD66),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C66:K66)<$AC66,$AC66*(1/$AD66),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,11]
[null,6,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C67:G67)<$AC67,$AC67*(1/$AD67),0),0)*H$11","v":0},{"$f":"IFERROR(IF(SUM($C67:H67)<$AC67,$AC67*(1/$AD67),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C67:I67)<$AC67,$AC67*(1/$AD67),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C67:J67)<$AC67,$AC67*(1/$AD67),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C67:K67)<$AC67,$AC67*(1/$AD67),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,10]
[null,7,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C68:H68)<$AC68,$AC68*(1/$AD68),0),0)*I$11","v":0},{"$f":"IFERROR(IF(SUM($C68:I68)<$AC68,$AC68*(1/$AD68),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C68:J68)<$AC68,$AC68*(1/$AD68),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C68:K68)<$AC68,$AC68*(1/$AD68),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,9]
[null,8,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C69:I69)<$AC69,$AC69*(1/$AD69),0),0)*J$11","v":0},{"$f":"IFERROR(IF(SUM($C69:J69)<$AC69,$AC69*(1/$AD69),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C69:K69)<$AC69,$AC69*(1/$AD69),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,8]
[null,9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C70:J70)<$AC70,$AC70*(1/$AD70),0),0)*K$11","v":0},{"$f":"IFERROR(IF(SUM($C70:K70)<$AC70,$AC70*(1/$AD70),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,7]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(SUM($C71:K71)<$AC71,$AC71*(1/$AD71),0),0)*L$11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,6]
[]
[null,"Dep. com perdas reais",{"$f":"SUM(C75:C84)","v":0.1995547619047619},0.19005215419501134,0.1810020516142965,0.17238290629932998,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C73:AA73)","v":0.74299187401339972}]
[]
[null,1,{"$f":"(C50+C62)/C98","v":0.1995547619047619},0.19005215419501134,0.1810020516142965,0.17238290629932998,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C75:AA75)","v":0.74299187401339972}]
[null,{"$f":"B75+1","v":2},null,{"$f":"(D51+D63)/D99","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C76:AA76)","v":0}]
[null,{"$f":"B76+1","v":3},null,null,{"$f":"(E52+E64)/E100","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,{"$f":"(F53+F65)/F101","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,5,null,null,null,null,{"$f":"(G54+G66)/G102","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,{"$f":"(H55+H67)/H103","v":0},{"$f":"(I55+I67)/I103","v":0},{"$f":"(J55+J67)/J103","v":0},{"$f":"(K55+K67)/K103","v":0},{"$f":"(L55+L67)/L103","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,{"$f":"(I56+I68)/I104","v":0},{"$f":"(J56+J68)/J104","v":0},{"$f":"(K56+K68)/K104","v":0},{"$f":"(L56+L68)/L104","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,{"$f":"(J57+J69)/J105","v":0},{"$f":"(K57+K69)/K105","v":0},{"$f":"(L57+L69)/L105","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,{"$f":"(K58+K70)/K106","v":0},{"$f":"(L58+L70)/L106","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"(L59+L71)/L107","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Inflação",{"$f":"'01. PC'!C65","v":0.05},{"$f":"'01. PC'!D65","v":0.05},{"$f":"'01. PC'!E65","v":0.05},{"$f":"'01. PC'!F65","v":0.05},{"$f":"'01. PC'!G65","v":0.05},{"$f":"'01. PC'!H65","v":0.05},{"$f":"'01. PC'!I65","v":0.05},{"$f":"'01. PC'!J65","v":0.05},{"$f":"'01. PC'!K65","v":0.05},{"$f":"'01. PC'!L65","v":0.05}]
[null,1,{"$f":"C85","v":0.05},{"$f":"D85","v":0.05},{"$f":"E85","v":0.05},{"$f":"F85","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05]
[null,{"$f":"B86+1","v":2},null,{"$f":"D86","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,{"$f":"B87+1","v":3},null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,4,null,null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,5,null,null,null,null,0.05,0.05,0.05,0.05,0.05,0.05]
[null,6,null,null,null,null,null,0.05,0.05,0.05,0.05,0.05]
[null,7,null,null,null,null,null,null,0.05,0.05,0.05,0.05]
[null,8,null,null,null,null,null,null,null,0.05,0.05,0.05]
[null,9,null,null,null,null,null,null,null,null,0.05,0.05]
[null,10,null,null,null,null,null,null,null,null,null,0.05]
[]
[null,"Inflação acumulada",{"$f":"C98","v":1.05},{"$f":"D98","v":1.1025},1.1576250000000001,1.2155062500000002,1.2762815625000004,1.3400956406250004,1.4071004226562505,1.477455443789063,1.5513282159785162,1.628894626777442]
[null,1,{"$f":"C86+1","v":1.05},{"$f":"C98*(1+D86)","v":1.1025},1.1576250000000001,1.2155062500000002,1.2762815625000004,1.3400956406250004,1.4071004226562505,1.477455443789063,1.5513282159785162,1.628894626777442]
[null,{"$f":"B98+1","v":2},null,{"$f":"D87+1","v":1.05},{"$f":"D99*(1+E87)","v":1.1025},1.1576250000000001,1.2155062500000002,1.2762815625000004,1.3400956406250004,1.4071004226562505,1.477455443789063,1.5513282159785162]
[null,{"$f":"B99+1","v":3},null,null,{"$f":"E88+1","v":1.05},{"$f":"E100*(1+F88)","v":1.1025},1.1576250000000001,1.2155062500000002,1.2762815625000004,1.3400956406250004,1.4071004226562505,1.477455443789063]
[null,4,null,null,null,{"$f":"F89+1","v":1.05},{"$f":"F101*(1+G89)","v":1.1025},1.1576250000000001,1.2155062500000002,1.2762815625000004,1.3400956406250004,1.4071004226562505]
[null,5,null,null,null,null,{"$f":"G90+1","v":1.05},{"$f":"G102*(1+H90)","v":1.1025},{"$f":"H102*(1+I90)","v":1.1576250000000001},{"$f":"I102*(1+J90)","v":1.2155062500000002},{"$f":"J102*(1+K90)","v":1.2762815625000004},{"$f":"K102*(1+L90)","v":1.3400956406250004}]
[null,6,null,null,null,null,null,{"$f":"H91+1","v":1.05},{"$f":"H103*(1+I91)","v":1.1025},{"$f":"I103*(1+J91)","v":1.1576250000000001},{"$f":"J103*(1+K91)","v":1.2155062500000002},{"$f":"K103*(1+L91)","v":1.2762815625000004}]
[null,7,null,null,null,null,null,null,{"$f":"I92+1","v":1.05},{"$f":"I104*(1+J92)","v":1.1025},{"$f":"J104*(1+K92)","v":1.1576250000000001},{"$f":"K104*(1+L92)","v":1.2155062500000002}]
[null,8,null,null,null,null,null,null,null,{"$f":"J93+1","v":1.05},{"$f":"J105*(1+K93)","v":1.1025},{"$f":"K105*(1+L93)","v":1.1576250000000001}]
[null,9,null,null,null,null,null,null,null,null,{"$f":"K94+1","v":1.05},{"$f":"K106*(1+L94)","v":1.1025}]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"L95+1","v":1.05}]
[]
[null,"Diferenças",{"$f":"C73-C47","v":-9.977738095238109E-3},-1.9480345804988669E-2,-2.8530448385703511E-2,-3.7149593700670031E-2,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C109:AA109)","v":-9.5138125986600319E-2}]

{"sheet":"04. NIG","index":4,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"NIG (R$ Milhões)"]
[]
[null,"PRAZO",{"$f":"IF(C10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(D10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(E10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(F10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(G10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(H10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(I10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(J10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(K10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(L10<=('01. PC'!$C$18),1,0)","v":1}]
[]
[null,"ANO",1,{"$f":"C10+1","v":2},{"$f":"D10+1","v":3},4,5,6,7,8,9,10,null,"TOTAL"]
[]
[null,"OPEX TOTAL ",{"$f":"-(C13+C14)*C$8","v":-0.66821132759180957},{"$f":"-(D13+D14)*D$8","v":-0.66821132759180957},-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,-0.66821132759180957,null,{"$f":"SUM(C12:L12)","v":-6.6821132759180948}]
[null,"Custos Variaveis",{"$f":"'06. OPEX'!C10","v":0.52264604905468004},{"$f":"'06. OPEX'!D10","v":0.52264604905468004},{"$f":"'06. OPEX'!E10","v":0.52264604905468004},{"$f":"'06. OPEX'!F10","v":0.52264604905468004},{"$f":"'06. OPEX'!G10","v":0.52264604905468004},{"$f":"'06. OPEX'!H10","v":0.52264604905468004},{"$f":"'06. OPEX'!I10","v":0.52264604905468004},{"$f":"'06. OPEX'!J10","v":0.52264604905468004},{"$f":"'06. OPEX'!K10","v":0.52264604905468004},{"$f":"'06. OPEX'!L10","v":0.52264604905468004},null,{"$f":"SUM(C13:L13)","v":5.2264604905468017}]
[null,"Custos Fixos",{"$f":"'06. OPEX'!C68","v":0.14556527853712958},{"$f":"'06. OPEX'!D68","v":0.14556527853712958},{"$f":"'06. OPEX'!E68","v":0.14556527853712958},{"$f":"'06. OPEX'!F68","v":0.14556527853712958},{"$f":"'06. OPEX'!G68","v":0.14556527853712958},{"$f":"'06. OPEX'!H68","v":0.14556527853712958},{"$f":"'06. OPEX'!I68","v":0.14556527853712958},{"$f":"'06. OPEX'!J68","v":0.14556527853712958},{"$f":"'06. OPEX'!K68","v":0.14556527853712958},{"$f":"'06. OPEX'!L68","v":0.14556527853712958},null,{"$f":"SUM(C14:L14)","v":1.4556527853712955}]
[]
[null,"NIG - Real ",{"$f":"IF(D$8=1,(C12/12)*'01. PC'!$C$16-SUM(B16:$B16),IF(C$8=1,-SUM(B16:$C16),0))","v":0},{"$f":"IF(E$8=1,(D12/12)*'01. PC'!$C$16-SUM($C16:C16),IF(D$8=1,-SUM($C16:C16),0))","v":0},{"$f":"IF(F$8=1,(E12/10)*'01. PC'!$C$16-SUM($C16:D16),IF(E$8=1,-SUM($C16:D16),0))","v":0},{"$f":"IF(G$8=1,(F12/10)*'01. PC'!$C$16-SUM($C16:E16),IF(F$8=1,-SUM($C16:E16),0))","v":0},{"$f":"IF(H$8=1,(G12/10)*'01. PC'!$C$16-SUM($C16:F16),IF(G$8=1,-SUM($C16:F16),0))","v":0},{"$f":"IF(I$8=1,(H12/10)*'01. PC'!$C$16-SUM($C16:G16),IF(H$8=1,-SUM($C16:G16),0))","v":0},{"$f":"IF(J$8=1,(I12/10)*'01. PC'!$C$16-SUM($C16:H16),IF(I$8=1,-SUM($C16:H16),0))","v":0},{"$f":"IF(K$8=1,(J12/10)*'01. PC'!$C$16-SUM($C16:I16),IF(J$8=1,-SUM($C16:I16),0))","v":0},{"$f":"IF(L$8=1,(K12/10)*'01. PC'!$C$16-SUM($C16:J16),IF(K$8=1,-SUM($C16:J16),0))","v":0},{"$f":"IF(M8=1,(L12/10)*'01. PC'!$C$16-SUM($C16:K16),IF(L$8=1,-SUM($C16:K16),0))","v":0},null,{"$f":"SUM(C16:L16)","v":0}]
[]
[null,"Perda inflacionária",null,{"$f":"(C12*('01. PC'!D65/(1+'01. PC'!D65)))*D8*('01. PC'!$C$16/12)","v":0},{"$f":"(D12*('01. PC'!E65/(1+'01. PC'!E65)))*E8*('01. PC'!$C$16/12)","v":0},{"$f":"(E12*('01. PC'!F65/(1+'01. PC'!F65)))*F8*('01. PC'!$C$16/12)","v":0},{"$f":"(F12*('01. PC'!G65/(1+'01. PC'!G65)))*G8*('01. PC'!$C$16/12)","v":0},{"$f":"(G12*('01. PC'!H65/(1+'01. PC'!H65)))*H8*('01. PC'!$C$16/12)","v":0},{"$f":"(H12*('01. PC'!I65/(1+'01. PC'!I65)))*I8*('01. PC'!$C$16/12)","v":0},{"$f":"(I12*('01. PC'!J65/(1+'01. PC'!J65)))*J8*('01. PC'!$C$16/12)","v":0},{"$f":"(J12*('01. PC'!K65/(1+'01. PC'!K65)))*K8*('01. PC'!$C$16/12)","v":0},{"$f":"(K12*('01. PC'!L65/(1+'01. PC'!L65)))*L8*('01. PC'!$C$16/12)","v":0},null,{"$f":"SUM(C18:L18)","v":0}]
[]
[null,"NIG Real com Perda inflacionária",{"$f":"C16+C18","v":0},{"$f":"D16+D18","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C20:L20)","v":0}]

{"sheet":"05. CAPEX","index":5,"n_rows":108,"n_cols":33,"rows_kept":108,"cut":false,"hidden":false,"merged":[[20,30,20,31],[13,1,13,2],[21,1,21,2],[98,1,98,27],[101,1,101,2],[78,1,78,2],[80,1,80,27],[83,1,83,2],[85,1,85,2],[24,1,24,27],[19,1,19,27],[22,1,22,2],[14,1,14,2],[15,1,15,27],[17,1,17,2],[107,1,107,2],[27,30,27,32],[55,30,55,32],[86,1,86,2],[88,1,88,27],[45,1,45,2],[47,1,47,27],[50,1,50,2],[52,1,52,27],[73,1,73,2],[75,1,75,27],[91,1,91,2],[93,1,93,27],[96,1,96,2],[103,1,103,27],[106,1,106,2],[6,1,6,27],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,27]]}
[]
[]
[]
[]
[]
[]
[null,"FROTA  - TOTAL"]
[null,"TIPO",null,1,{"$f":"D8+1","v":2},{"$f":"E8+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},null,1,1,1,1,1,1,1,1,1,1,{"$f":"N15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",null,{"$f":"SUM(D9:D9)","v":1},1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"IDADE - BÁSICO"]
[null,"TIPO","QUANT.",1,{"$f":"D13+1","v":2},{"$f":"E13+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,0,{"$f":"IF(D14+1>'01. PC'!$C$26,0,D14+1)","v":1},{"$f":"IF(E14+1>'01. PC'!$C$26,0,E14+1)","v":2},{"$f":"IF(F14+1>'01. PC'!$C$26,0,F14+1)","v":3},{"$f":"IF(G14+1>'01. PC'!$C$26,0,G14+1)","v":4},{"$f":"IF(H14+1>'01. PC'!$C$26,0,H14+1)","v":5},{"$f":"IF(I14+1>'01. PC'!$C$26,0,I14+1)","v":6},{"$f":"IF(J14+1>'01. PC'!$C$26,0,J14+1)","v":7},{"$f":"IF(K14+1>'01. PC'!$C$26,0,K14+1)","v":8},9,{"$f":"IF(M14+1>'01. PC'!$C$26,0,M14+1)","v":10},{"$f":"IF(N14+1>'01. PC'!$C$26,0,N14+1)","v":11},{"$f":"IF(O14+1>'01. PC'!$C$26,0,O14+1)","v":12},{"$f":"IF(P14+1>'01. PC'!$C$26,0,P14+1)","v":13},{"$f":"IF(Q14+1>'01. PC'!$C$26,0,Q14+1)","v":14},{"$f":"IF(R14+1>'01. PC'!$C$26,0,R14+1)","v":15},{"$f":"IF(S14+1>'01. PC'!$C$26,0,S14+1)","v":0},{"$f":"IF(T14+1>'01. PC'!$C$26,0,T14+1)","v":1},{"$f":"IF(U14+1>'01. PC'!$C$26,0,U14+1)","v":2},{"$f":"IF(V14+1>'01. PC'!$C$26,0,V14+1)","v":3},{"$f":"IF(W14+1>'01. PC'!$C$26,0,W14+1)","v":4},{"$f":"IF(X14+1>'01. PC'!$C$26,0,X14+1)","v":5},{"$f":"IF(Y14+1>'01. PC'!$C$26,0,Y14+1)","v":6},{"$f":"IF(Z14+1>'01. PC'!$C$26,0,Z14+1)","v":7},{"$f":"IF(AA14+1>'01. PC'!$C$26,0,AA14+1)","v":8}]
[null,"TOTAL",null,{"$f":"SUM(D14:D14)","v":0},1,2,3,4,5,6,7,8,9]
[]
[]
[null,"QUANTIDADE",null,{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0}]
[]
[null,"FROTA - PREÇO "]
[null,"TIPO","QUANT.",1,{"$f":"D21+1","v":2},{"$f":"E21+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA21+1","v":25},null,null,"PREÇO"]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,{"$f":"IF(Prazo<D$21,0,IF(D14=\"\",0,$AF$22))","v":838130},838130,838130,838130,838130,838130,838130,838130,838130,838130,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"'01. PC'!C24","v":"Padron Diesel"},838130]
[null,"TOTAL",null,{"$f":"SUM(D22:D22)","v":838130},838130,838130,838130,838130,838130,838130,838130,838130,838130,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"BÁSICO SEM ITS",476000]
[]
[null,"FROTA - VALOR JUSTO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carregadores e Placas",0]
[null,"TIPO","QUANT.",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,{"$f":"IF($B27='01. PC'!$C$24,IFERROR(D22*(1-VLOOKUP(D14,$AE$30:$AG$45,3,0)),0))","v":838130},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(E22*(1-VLOOKUP(E14,$AE$30:$AG$45,3,0)),0))","v":722048.995},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(F22*(1-VLOOKUP(F14,$AE$30:$AG$45,3,0)),0))","v":615690.29800000007},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(G22*(1-VLOOKUP(G14,$AE$30:$AG$45,3,0)),0))","v":518970.09599999996},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(H22*(1-VLOOKUP(H14,$AE$30:$AG$45,3,0)),0))","v":431972.20199999999},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(I22*(1-VLOOKUP(I14,$AE$30:$AG$45,3,0)),0))","v":354612.80300000001},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(J22*(1-VLOOKUP(J14,$AE$30:$AG$45,3,0)),0))","v":286891.89900000003},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(K22*(1-VLOOKUP(K14,$AE$30:$AG$45,3,0)),0))","v":228893.3030000001},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(L22*(1-VLOOKUP(L14,$AE$30:$AG$45,3,0)),0))","v":180533.20200000014},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(M22*(1-VLOOKUP(M14,$AE$30:$AG$45,3,0)),0))","v":141811.59600000011},{"$f":"IF($B27=\"BÁSICO\",IFERROR(N22*(1-VLOOKUP(N14,$AE$30:$AG$45,3,0)),0))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEPRECIAÇÃO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANO","ANUAL","ACUM."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AF30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.13849999999999996,{"$f":"AG30+AF31","v":0.13849999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.12690000000000001,{"$f":"AG31+AF32","v":0.26539999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.11540000000000006,0.38080000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.1038,0.48460000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,9.2299999999999993E-2,0.57689999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,8.0799999999999983E-2,0.65769999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,6.9199999999999984E-2,0.72689999999999988]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,5.7700000000000001E-2,0.78459999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,4.6200000000000019E-2,0.83079999999999987]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,3.4599999999999992E-2,0.86539999999999984]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE40+1","v":11},2.3099999999999996E-2,0.88849999999999985]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE41+1","v":12},1.1499999999999996E-2,0.8999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE42+1","v":13},0,0.8999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE43+1","v":14},0,0.8999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE44+1","v":15},0,0.8999999999999998]
[null,"TOTAL",null,{"$f":"SUM(D27:D45)","v":838130},722048.995,615690.29800000007,518970.09599999996,431972.20199999999,354612.80300000001,286891.89900000003,228893.3030000001,180533.20200000014,141811.59600000011,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Auxiliar de depreciação contábil"]
[null,"TIPO","QUANT.",1,{"$f":"D49+1","v":2},{"$f":"E49+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA49+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,{"$f":"IF(D78=1,1,0)","v":1},{"$f":"IF(E78=1,1,D50+1)","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[null,"TOTAL",null,{"$f":"SUM(D50:D50)","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
[]
[null,"FROTA - VALOR CONTÁBIL"]
[null,"TIPO","QUANT.",1,{"$f":"D54+1","v":2},{"$f":"E54+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA54+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,{"$f":"IFERROR(D27*(1-VLOOKUP((D50),$AE$56:$AG$73,3,0)),0)","v":628597.5},361024.4975,153922.57450000002,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VENDA - BÁSICO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANO","ANUAL","ACUM."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"AF58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.25,{"$f":"AG58+AF59","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.25,{"$f":"AG59+AF60","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.25,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.25,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE68+1","v":11},0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE69+1","v":12},0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE70+1","v":13},0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE71+1","v":14},0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE72+1","v":15},0,1]
[null,"TOTAL",null,{"$f":"SUM(D55:D73)","v":628597.5},361024.4975,153922.57450000002,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"REFERÊNCIA DE COMPRA"]
[null,"TIPO","QUANT.",1,{"$f":"D77+1","v":2},{"$f":"E77+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA77+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,{"$f":"IF(D14<>\"\",1,0)","v":1},{"$f":"IF(Prazo<E$77,0,IF(OR(E14=\"\",E14<>0),0,1))","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,"TOTAL",null,{"$f":"SUM(D78:D78)","v":1},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,"FROTA VALOR COMPRA"]
[null,"TIPO","QUANT.",1,{"$f":"D82+1","v":2},{"$f":"E82+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA82+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,{"$f":"IF(D78=1,D27,0)","v":838130},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,"TOTAL",null,{"$f":"SUM(D83:D83)","v":838130},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,"RISCO"]
[]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},null,{"$f":"SUM(D83:D83)/10^6*(1+$AE$86)","v":0.83813000000000004},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,{"$f":"'09. SENSIBILIDADE'!$C$10","v":0}]
[null,"TOTAL",null,{"$f":"SUM(D86:D86)","v":0.83813000000000004},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,"REFERÊNCIA DE VENDA"]
[null,"TIPO","QUANT.",1,{"$f":"D90+1","v":2},{"$f":"E90+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA90+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,0,{"$f":"IF(Prazo<E$90,0,IF(E14<D14,1,0))","v":0},{"$f":"IF(Prazo=F$90,IF(F14<>E14,1,0),IF(F14<E14,1,0))","v":0},0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0]
[null,"TOTAL",null,{"$f":"SUM(D91:D91)","v":0},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0]
[]
[null,"VALOR BRUTO DE VENDA"]
[null,"TIPO","QUANT.",1,{"$f":"D95+1","v":2},{"$f":"E95+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA95+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,{"$f":"IF(D91=1,C27,0)","v":0},0,0,0,0,0,0,0,0,180533.20200000014,0,0,0,0,0,0,false,0,0,0,0,0,0,0,0]
[null,"TOTAL",null,{"$f":"SUM(D96:D96)","v":0},0,0,0,0,0,0,0,0,180533.20200000014,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"IR SOBRE A VENDA"]
[null,"TIPO","QUANT.",1,{"$f":"D100+1","v":2},{"$f":"E100+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA100+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,0,{"$f":"IF(E96-D55>0,0.34*(E96-D55),0)","v":0},0,0,0,0,0,0,0,61381.288680000049,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",null,{"$f":"SUM(D101:D101)","v":0},0,0,0,0,0,0,0,0,61381.288680000049,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"VALOR DE VENDA LÍQUIDO"]
[null,"TIPO","QUANT.",1,{"$f":"D105+1","v":2},{"$f":"E105+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,{"$f":"AA105+1","v":25}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},1,0,{"$f":"E96-E101","v":0},0,0,0,0,0,0,0,119151.91332000008,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL",null,{"$f":"SUM(D106:D106)","v":0},0,0,0,0,0,0,0,0,119151.91332000008,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"TOTAL - FCL",null,{"$f":"D107/10^6","v":0},{"$f":"E107/10^6","v":0},0,0,0,0,0,0,0,0.11915191332000008,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"06. OPEX","index":6,"n_rows":211,"n_cols":16,"rows_kept":211,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Opex (R$ Milhões)"]
[]
[null,"Opex ",1,{"$f":"C8+1","v":2},3,4,5,6,7,8,9,10,null,"TOTAL",null,"RISCO"]
[]
[null,"Custo Variável",{"$f":"(C19+C25+C30+C41+C35+C46+C52+C57+C63)*'03. D&A Fiscal'!C11","v":0.52264604905468004},{"$f":"(D19+D25+D30+D41+D35+D46+D52+D57+D63)*'03. D&A Fiscal'!D11","v":0.52264604905468004},{"$f":"(E19+E25+E30+E41+E35+E46+E52+E57+E63)*'03. D&A Fiscal'!E11","v":0.52264604905468004},{"$f":"(F19+F25+F30+F41+F35+F46+F52+F57+F63)*'03. D&A Fiscal'!F11","v":0.52264604905468004},{"$f":"(G19+G25+G30+G41+G35+G46+G52+G57+G63)*'03. D&A Fiscal'!G11","v":0.52264604905468004},{"$f":"(H19+H25+H30+H41+H35+H46+H52+H57+H63)*'03. D&A Fiscal'!H11","v":0.52264604905468004},{"$f":"(I19+I25+I30+I41+I35+I46+I52+I57+I63)*'03. D&A Fiscal'!I11","v":0.52264604905468004},{"$f":"(J19+J25+J30+J41+J35+J46+J52+J57+J63)*'03. D&A Fiscal'!J11","v":0.52264604905468004},{"$f":"(K19+K25+K30+K41+K35+K46+K52+K57+K63)*'03. D&A Fiscal'!K11","v":0.52264604905468004},{"$f":"(L19+L25+L30+L41+L35+L46+L52+L57+L63)*'03. D&A Fiscal'!L11","v":0.52264604905468004},null,{"$f":"SUM(C10:L10)","v":5.2264604905468017}]
[]
[null,"Frota Patrimonial",{"$f":"SUM(C13:C13)","v":1},1,1,1,1,1,1,1,1,1,null,{"$f":"SUM(C12:L12)","v":10}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"'05. CAPEX'!D9","v":1},{"$f":"'05. CAPEX'!E9","v":1},{"$f":"'05. CAPEX'!F9","v":1},{"$f":"'05. CAPEX'!G9","v":1},{"$f":"'05. CAPEX'!H9","v":1},{"$f":"'05. CAPEX'!I9","v":1},{"$f":"'05. CAPEX'!J9","v":1},{"$f":"'05. CAPEX'!K9","v":1},{"$f":"'05. CAPEX'!L9","v":1},{"$f":"'05. CAPEX'!M9","v":1}]
[]
[null,"Frota Operacional",{"$f":"C16","v":1},{"$f":"D16","v":1},1,1,1,1,1,1,1,1,null,{"$f":"SUM(C15:L15)","v":10}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"ROUND((C17*C13),0)","v":1},1,1,1,1,1,1,1,1,1]
[null,"Percentual",0.93877551020408168,0.94736842105263153,0.93103448275862066,0.93103448275862066,0.93103448275862066,0.93103448275862066,0.93103448275862066,0.93103448275862066,0.93103448275862066,0.93103448275862066]
[]
[null,"Combustível",{"$f":"(C20)*(1+VLOOKUP($B19,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$19)","v":0.17253463500000005},0.17253463500000005,0.17253463500000005,0.17253463500000005,0.17253463500000005,0.17253463500000005,0.17253463500000005,0.17253463500000005,0.17253463500000005,0.17253463500000005,null,{"$f":"SUM(C19:L19)","v":1.7253463500000008},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C16*C21*C22*C23","v":172534.63500000004},172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,null,{"$f":"SUM(C20:L20)","v":1725346.3500000003}]
[null,"Quantidade KM",78247,{"$f":"C21","v":78247},{"$f":"D21","v":78247},78247,78247,78247,78247,78247,78247,78247]
[null,"Preço do diesel",4.9000000000000004,{"$f":"C22","v":4.9000000000000004},{"$f":"D22","v":4.9000000000000004},4.9000000000000004,4.9000000000000004,4.9000000000000004,4.9000000000000004,4.9000000000000004,4.9000000000000004,4.9000000000000004]
[null,"Consumo",0.45,{"$f":"C23","v":0.45},0.45,0.45,0.45,0.45,0.45,0.45,0.45,0.45]
[]
[null,"Lubrificante Diesel",{"$f":"(C26)*(1+VLOOKUP($B25,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$25)","v":1.1214751275000002E-2},1.1214751275000002E-2,1.1214751275000002E-2,1.1214751275000002E-2,1.1214751275000002E-2,1.1214751275000002E-2,1.1214751275000002E-2,1.1214751275000002E-2,1.1214751275000002E-2,1.1214751275000002E-2,null,{"$f":"SUM(C25:L25)","v":0.11214751275000003},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C27*C28","v":11214.751275000002},{"$f":"D27*D28","v":11214.751275000002},11214.751275000002,11214.751275000002,11214.751275000002,11214.751275000002,11214.751275000002,11214.751275000002,11214.751275000002,11214.751275000002,null,{"$f":"SUM(C26:L26)","v":112147.51275000002}]
[null,"Combustível",{"$f":"C20","v":172534.63500000004},{"$f":"D20","v":172534.63500000004},172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004]
[null,"Percentual",6.5000000000000002E-2,{"$f":"C28","v":6.5000000000000002E-2},{"$f":"D28","v":6.5000000000000002E-2},6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2]
[]
[null,"Arla 32",{"$f":"(C31)*(1+VLOOKUP($B30,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$30)","v":3.4506927000000011E-3},3.4506927000000011E-3,3.4506927000000011E-3,3.4506927000000011E-3,3.4506927000000011E-3,3.4506927000000011E-3,3.4506927000000011E-3,3.4506927000000011E-3,3.4506927000000011E-3,3.4506927000000011E-3,null,{"$f":"SUM(C30:L30)","v":3.4506927000000014E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C32*C33","v":3450.692700000001},{"$f":"D32*D33","v":3450.692700000001},3450.692700000001,3450.692700000001,3450.692700000001,3450.692700000001,3450.692700000001,3450.692700000001,3450.692700000001,3450.692700000001,null,{"$f":"SUM(C31:L31)","v":34506.927000000003}]
[null,"Combustível",{"$f":"C20","v":172534.63500000004},{"$f":"D20","v":172534.63500000004},172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004,172534.63500000004]
[null,"Percentual",0.02,{"$f":"C33","v":0.02},{"$f":"D33","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
[null,"Rodagem",{"$f":"(C36)*(1+VLOOKUP($B35,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$35)","v":2.2535135999999997E-2},2.2535135999999997E-2,2.2535135999999997E-2,2.2535135999999997E-2,2.2535135999999997E-2,2.2535135999999997E-2,2.2535135999999997E-2,2.2535135999999997E-2,2.2535135999999997E-2,2.2535135999999997E-2,null,{"$f":"SUM(C35:L35)","v":0.22535136},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C37*C38/C39","v":22535.135999999999},{"$f":"D37*D38/D39","v":22535.135999999999},22535.135999999999,22535.135999999999,22535.135999999999,22535.135999999999,22535.135999999999,22535.135999999999,22535.135999999999,22535.135999999999,null,{"$f":"SUM(C36:L36)","v":225351.36}]
[null,"Quantidade Km total",{"$f":"C16*C21","v":78247},78247,78247,78247,78247,78247,78247,78247,78247,78247]
[null,"Preço Jogo e Recaps",36000,{"$f":"C38","v":36000},{"$f":"D38","v":36000},36000,36000,36000,36000,36000,36000,36000]
[null,"Km Duração jogo Pneus e Recaps",125000,{"$f":"C39","v":125000},{"$f":"D39","v":125000},125000,125000,125000,125000,125000,125000,125000]
[]
[null,"Peças e Materiais de Manutenção",{"$f":"(C42)*(1+VLOOKUP($B41,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$41)","v":6.7050399999999996E-2},6.7050399999999996E-2,6.7050399999999996E-2,6.7050399999999996E-2,6.7050399999999996E-2,6.7050399999999996E-2,6.7050399999999996E-2,6.7050399999999996E-2,6.7050399999999996E-2,6.7050399999999996E-2,null,{"$f":"SUM(C41:L41)","v":0.67050399999999988},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C13*C43*C44","v":67050.399999999994},67050.399999999994,67050.399999999994,67050.399999999994,67050.399999999994,67050.399999999994,67050.399999999994,67050.399999999994,67050.399999999994,67050.399999999994,null,{"$f":"SUM(C42:L42)","v":670504.00000000012}]
[null,"Preço Unitário",{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130},{"$f":"'05. CAPEX'!$AF$22","v":838130}]
[null,"Porcent. Do Preço Ônibus Novo",0.08,{"$f":"C44","v":0.08},{"$f":"D44","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,"Motoristas - Direção",{"$f":"(C47)*(1+VLOOKUP($B46,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$46)","v":0.12223628296320002},0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,null,{"$f":"SUM(C46:L46)","v":1.2223628296320002},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C16*C48*C49*(1+C50)","v":122236.28296320002},122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,null,{"$f":"SUM(C47:L47)","v":1222362.8296320003}]
[null,"Salário Anual",{"$f":"1964.2*12","v":23570.400000000001},{"$f":"C48","v":23570.400000000001},{"$f":"D48","v":23570.400000000001},23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001]
[null,"Empregados Equiv/ Carro",3.1621999999999999,{"$f":"C49","v":3.1621999999999999},3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999]
[null,"Encargos Sociais",0.64,{"$f":"C50","v":0.64},{"$f":"D50","v":0.64},{"$f":"E50","v":0.64},{"$f":"F50","v":0.64},{"$f":"G50","v":0.64},{"$f":"H50","v":0.64},{"$f":"I50","v":0.64},{"$f":"J50","v":0.64},{"$f":"K50","v":0.64}]
[]
[null,"Motoristas - Cobrança",{"$f":"(C53)*(1+VLOOKUP($B52,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$52)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C52:L52)","v":0},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C16*C54*C55","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C53:L53)","v":0}]
[null,"Fator de Utilização",0,{"$f":"C54","v":0},{"$f":"D54","v":0},0,0,0,0,0,0,0]
[null,"Salários e Encargos",0,{"$f":"C55","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Cobradores",{"$f":"(C58)*(1+VLOOKUP($B57,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$57)","v":7.3224151116480021E-2},7.3224151116480021E-2,7.3224151116480021E-2,7.3224151116480021E-2,7.3224151116480021E-2,7.3224151116480021E-2,7.3224151116480021E-2,7.3224151116480021E-2,7.3224151116480021E-2,7.3224151116480021E-2,null,{"$f":"SUM(C57:L57)","v":0.7322415111648003},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C16*C59*C60*(1+C61)","v":73224.151116480018},73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,null,{"$f":"SUM(C58:L58)","v":732241.51116480015}]
[null,"Fator de Utilização (equivalente)",{"$f":"C49","v":3.1621999999999999},{"$f":"C59","v":3.1621999999999999},{"$f":"D59","v":3.1621999999999999},3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999,3.1621999999999999]
[null,"Salário Anual",{"$f":"1176.63*12","v":14119.560000000001},{"$f":"C60","v":14119.560000000001},14119.560000000001,14119.560000000001,14119.560000000001,14119.560000000001,14119.560000000001,14119.560000000001,14119.560000000001,14119.560000000001]
[null,"Encargos Sociais",0.64,{"$f":"C61","v":0.64},0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64]
[]
[null,"Benefícios Trabalhistas",{"$f":"(C64)*(1+VLOOKUP($B63,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$63)","v":5.04E-2},5.04E-2,5.04E-2,5.04E-2,5.04E-2,5.04E-2,5.04E-2,5.04E-2,5.04E-2,5.04E-2,null,{"$f":"SUM(C63:L63)","v":0.504},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Padron Diesel"},{"$f":"C16*C65*C66","v":50400},50400,50400,50400,50400,50400,50400,50400,50400,50400,null,{"$f":"SUM(C64:L64)","v":504000}]
[null,"Fator de Utilização",6,{"$f":"C65","v":6},{"$f":"D65","v":6},6,6,6,6,6,6,6]
[null,"Benefício Anual",8400,{"$f":"C66","v":8400},8400,8400,8400,8400,8400,8400,8400,8400]
[]
[null,"Custo Fixo",{"$f":"(C70+C74+C78+C83+C87+C92+C96+C101+C106+C111+C116+C124+C120)*'03. D&A Fiscal'!C11","v":0.14556527853712958},{"$f":"(D70+D74+D78+D83+D87+D92+D96+D101+D106+D111+D116+D124+D120)*'03. D&A Fiscal'!D11","v":0.14556527853712958},{"$f":"(E70+E74+E78+E83+E87+E92+E96+E101+E106+E111+E116+E124+E120)*'03. D&A Fiscal'!E11","v":0.14556527853712958},{"$f":"(F70+F74+F78+F83+F87+F92+F96+F101+F106+F111+F116+F124+F120)*'03. D&A Fiscal'!F11","v":0.14556527853712958},{"$f":"(G70+G74+G78+G83+G87+G92+G96+G101+G106+G111+G116+G124+G120)*'03. D&A Fiscal'!G11","v":0.14556527853712958},{"$f":"(H70+H74+H78+H83+H87+H92+H96+H101+H106+H111+H116+H124+H120)*'03. D&A Fiscal'!H11","v":0.14556527853712958},{"$f":"(I70+I74+I78+I83+I87+I92+I96+I101+I106+I111+I116+I124+I120)*'03. D&A Fiscal'!I11","v":0.14556527853712958},{"$f":"(J70+J74+J78+J83+J87+J92+J96+J101+J106+J111+J116+J124+J120)*'03. D&A Fiscal'!J11","v":0.14556527853712958},{"$f":"(K70+K74+K78+K83+K87+K92+K96+K101+K106+K111+K116+K124+K120)*'03. D&A Fiscal'!K11","v":0.14556527853712958},{"$f":"(L70+L74+L78+L83+L87+L92+L96+L101+L106+L111+L116+L124+L120)*'03. D&A Fiscal'!L11","v":0.14556527853712958},null,{"$f":"SUM(C68:L68)","v":1.4556527853712955}]
[]
[null,"Operação da Frota Auxiliar (Serviços)",{"$f":"(C71*C72)*(1+VLOOKUP($B70,$B$158:$L$179,1+C$8,0))*(1+$P$70)","v":8.8712493058424862E-3},8.8712493058424862E-3,8.8712493058424862E-3,8.8712493058424862E-3,8.8712493058424862E-3,8.8712493058424862E-3,8.8712493058424862E-3,8.8712493058424862E-3,8.8712493058424862E-3,8.8712493058424862E-3,null,{"$f":"SUM(C70:L70)","v":8.8712493058424866E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem",1.4999999999999999E-2,{"$f":"C71","v":1.4999999999999999E-2},{"$f":"D71","v":1.4999999999999999E-2},1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[null,"Custos Específicos",{"$f":"SUM(C87,C92,C63,C57,C52,C46,C41,C35,C30,C25,C19)","v":0.59141662038949905},{"$f":"D10+D87+D92","v":0.59141662038949905},0.59141662038949905,0.59141662038949905,0.59141662038949905,0.59141662038949905,0.59141662038949905,0.59141662038949905,0.59141662038949905,0.59141662038949905]
[]
[null,"Operac. e Manut. Infra Garagem",{"$f":"(C75*C76*C12)*(1+VLOOKUP($B74,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$74)","v":2.0468000000000001E-3},2.0468000000000001E-3,2.0468000000000001E-3,2.0468000000000001E-3,2.0468000000000001E-3,2.0468000000000001E-3,2.0468000000000001E-3,2.0468000000000001E-3,2.0468000000000001E-3,2.0468000000000001E-3,null,{"$f":"SUM(C74:L74)","v":2.0468000000000004E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem",4.3E-3,{"$f":"C75","v":4.3E-3},{"$f":"D75","v":4.3E-3},4.3E-3,4.3E-3,4.3E-3,4.3E-3,4.3E-3,4.3E-3,4.3E-3]
[null,"Preço do Ônibus Básico S/ ITS",{"$f":"'05. CAPEX'!$AF$23","v":476000},{"$f":"C76","v":476000},476000,476000,476000,476000,476000,476000,476000,476000]
[]
[null,"Operação de ITS",{"$f":"(C79*C80*C81)*(1+VLOOKUP($B78,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$78)","v":6.1879999999999999E-3},6.1879999999999999E-3,6.1879999999999999E-3,6.1879999999999999E-3,6.1879999999999999E-3,6.1879999999999999E-3,6.1879999999999999E-3,6.1879999999999999E-3,6.1879999999999999E-3,6.1879999999999999E-3,null,{"$f":"SUM(C78:L78)","v":6.1879999999999998E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem anual",1.2999999999999999E-2,{"$f":"C79","v":1.2999999999999999E-2},{"$f":"D79","v":1.2999999999999999E-2},1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[null,"Preço do Ônibus Básico S/ ITS",{"$f":"'05. CAPEX'!$AF$23","v":476000},{"$f":"C80","v":476000},476000,476000,476000,476000,476000,476000,476000,476000]
[null,"Número Ônibus",{"$f":"C12","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,"Operação de Bilhetagem",{"$f":"(C84*C85)*(1+VLOOKUP($B83,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$83)","v":2.0713201755988994E-2},2.0713201755988994E-2,2.0713201755988994E-2,2.0713201755988994E-2,2.0713201755988994E-2,2.0713201755988994E-2,2.0713201755988994E-2,2.0713201755988994E-2,2.0713201755988994E-2,2.0713201755988994E-2,null,{"$f":"SUM(C83:L83)","v":0.20713201755988997},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem",2.5000000000000001E-2,{"$f":"C84","v":2.5000000000000001E-2},{"$f":"D84","v":2.5000000000000001E-2},2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[null,"Receita Eletrônica Aprox",{"$f":"'08. RECEITA E DEMANDA'!C14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!D14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!E14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!F14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!G14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!H14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!I14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!J14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!K14*10^6","v":828528.07023955975},{"$f":"'08. RECEITA E DEMANDA'!L14*10^6","v":828528.07023955975}]
[]
[null,"Fiscalização",{"$f":"(C88*C89*C16)*(1+C90)/10^6","v":7.7310912000000016E-3},7.7310912000000016E-3,7.7310912000000016E-3,7.7310912000000016E-3,7.7310912000000016E-3,7.7310912000000016E-3,7.7310912000000016E-3,7.7310912000000016E-3,7.7310912000000016E-3,7.7310912000000016E-3,null,{"$f":"SUM(C87:L87)","v":7.7310911999999996E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Salário Anual",{"$f":"1964.2*12","v":23570.400000000001},{"$f":"C88","v":23570.400000000001},{"$f":"D88","v":23570.400000000001},23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001]
[null,"Empregados por ônibus",0.2,{"$f":"C89","v":0.2},0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[null,"Benefícios Sociais",0.64,{"$f":"C90","v":0.64},0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64]
[]
[null,"Mão de Obra Manutenção, Adm. e Diretoria",{"$f":"(C93*C94)*(1+VLOOKUP($B92,$B$158:$L$179,1+C$8,0))*(1+$P$92)","v":6.1039480134818982E-2},6.1039480134818982E-2,6.1039480134818982E-2,6.1039480134818982E-2,6.1039480134818982E-2,6.1039480134818982E-2,6.1039480134818982E-2,6.1039480134818982E-2,6.1039480134818982E-2,6.1039480134818982E-2,null,{"$f":"SUM(C92:L92)","v":0.6103948013481898},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem",0.2407,0.2407,0.2407,0.2407,0.2407,0.2407,0.2407,0.2407,0.2407,0.2407]
[null,"Base Anual",{"$f":"C46+C52+C57+C63+C87","v":0.25359152527968004},0.25359152527968004,0.25359152527968004,0.25359152527968004,0.25359152527968004,0.25359152527968004,0.25359152527968004,0.25359152527968004,0.25359152527968004,0.25359152527968004]
[]
[null,"Despesas Administrativas Gerais",{"$f":"(C97*C98*C99)*(1+VLOOKUP($B96,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$96)","v":1.9040000000000001E-2},1.9040000000000001E-2,1.9040000000000001E-2,1.9040000000000001E-2,1.9040000000000001E-2,1.9040000000000001E-2,1.9040000000000001E-2,1.9040000000000001E-2,1.9040000000000001E-2,1.9040000000000001E-2,null,{"$f":"SUM(C96:L96)","v":0.19040000000000001},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0.04,{"$f":"C97","v":0.04},{"$f":"D97","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,"Preço do Ônibus Básico S/ ITS",{"$f":"'05. CAPEX'!$AF$23","v":476000},{"$f":"C98","v":476000},476000,476000,476000,476000,476000,476000,476000,476000]
[null,"Número Ônibus",{"$f":"C12","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,"Locação de Infraestrutura Garagem",{"$f":"(C102*C103*C104)*(1+VLOOKUP($B101,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$101)","v":9.5200000000000007E-3},9.5200000000000007E-3,9.5200000000000007E-3,9.5200000000000007E-3,9.5200000000000007E-3,9.5200000000000007E-3,9.5200000000000007E-3,9.5200000000000007E-3,9.5200000000000007E-3,9.5200000000000007E-3,null,{"$f":"SUM(C101:L101)","v":9.5200000000000007E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0.02,{"$f":"C102","v":0.02},{"$f":"D102","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"Preço do Ônibus Básico S/ ITS",{"$f":"'05. CAPEX'!$AF$23","v":476000},{"$f":"C103","v":476000},476000,476000,476000,476000,476000,476000,476000,476000]
[null,"Número Ônibus",{"$f":"C12","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,"Manutenção de Infraestrutura",{"$f":"(C107*C108*C109)*(1+VLOOKUP($B106,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$106)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C106:L106)","v":0},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0,{"$f":"C107","v":0},{"$f":"D107","v":0},0,0,0,0,0,0,0]
[null,"Valor ônibus básico",{"$f":"C43","v":838130},{"$f":"C108","v":838130},838130,838130,838130,838130,838130,838130,838130,838130]
[null,"Número Ônibus",{"$f":"C12","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,"Despesas Ambientais",{"$f":"(C112*C113*C114)*(1+VLOOKUP($B111,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$111)","v":4.7600000000000003E-3},4.7600000000000003E-3,4.7600000000000003E-3,4.7600000000000003E-3,4.7600000000000003E-3,4.7600000000000003E-3,4.7600000000000003E-3,4.7600000000000003E-3,4.7600000000000003E-3,4.7600000000000003E-3,null,{"$f":"SUM(C111:L111)","v":4.7600000000000003E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentual Preço ônibus",0.01,{"$f":"C112","v":0.01},{"$f":"D112","v":0.01},0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"Preço do Ônibus Básico S/ ITS",{"$f":"'05. CAPEX'!$AF$23","v":476000},{"$f":"C113","v":476000},476000,476000,476000,476000,476000,476000,476000,476000]
[null,"Número Ônibus",{"$f":"C12","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,"Garantias Contratuais",{"$f":"(C117*C118)*(1+VLOOKUP($B116,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$116)","v":1.6570561404791195E-3},1.6570561404791195E-3,1.6570561404791195E-3,1.6570561404791195E-3,1.6570561404791195E-3,1.6570561404791195E-3,1.6570561404791195E-3,1.6570561404791195E-3,1.6570561404791195E-3,1.6570561404791195E-3,null,{"$f":"SUM(C116:L116)","v":1.6570561404791198E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Valor Unitário (R$)",2E-3,{"$f":"C117","v":2E-3},{"$f":"D117","v":2E-3},2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3]
[null,"Receita Eletrônica Aprox",{"$f":"C85","v":828528.07023955975},{"$f":"D85","v":828528.07023955975},828528.07023955975,828528.07023955975,828528.07023955975,828528.07023955975,828528.07023955975,828528.07023955975,828528.07023955975,828528.07023955975]
[]
[null,"Manutenção Infra Elétrica",{"$f":"(C121*C122)*(1+VLOOKUP($B120,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$120)*'02. FCL'!C8","v":0},{"$f":"(D121*D122)*(1+VLOOKUP($B120,$B$158:$L$179,1+D$8,0))/10^6*(1+$P$120)*'02. FCL'!D8","v":0},{"$f":"(E121*E122)*(1+VLOOKUP($B120,$B$158:$L$179,1+E$8,0))/10^6*(1+$P$120)*'02. FCL'!E8","v":0},{"$f":"(F121*F122)*(1+VLOOKUP($B120,$B$158:$L$179,1+F$8,0))/10^6*(1+$P$120)*'02. FCL'!F8","v":0},{"$f":"(G121*G122)*(1+VLOOKUP($B120,$B$158:$L$179,1+G$8,0))/10^6*(1+$P$120)*'02. FCL'!G8","v":0},{"$f":"(H121*H122)*(1+VLOOKUP($B120,$B$158:$L$179,1+H$8,0))/10^6*(1+$P$120)*'02. FCL'!H8","v":0},{"$f":"(I121*I122)*(1+VLOOKUP($B120,$B$158:$L$179,1+I$8,0))/10^6*(1+$P$120)*'02. FCL'!I8","v":0},{"$f":"(J121*J122)*(1+VLOOKUP($B120,$B$158:$L$179,1+J$8,0))/10^6*(1+$P$120)*'02. FCL'!J8","v":0},{"$f":"(K121*K122)*(1+VLOOKUP($B120,$B$158:$L$179,1+K$8,0))/10^6*(1+$P$120)*'02. FCL'!K8","v":0},{"$f":"(L121*L122)*(1+VLOOKUP($B120,$B$158:$L$179,1+L$8,0))/10^6*(1+$P$120)*'02. FCL'!L8","v":0},null,{"$f":"SUM(C120:L120)","v":0},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0.01,{"$f":"C121","v":0.01},{"$f":"D121","v":0.01},0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"Carregadores e placas",{"$f":"'03. D&A Fiscal'!$C$18*10^6","v":0},{"$f":"C122","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Seguro e Licenciamento",{"$f":"(C125*C126*C127)*(1+VLOOKUP($B124,$B$158:$L$179,1+C$8,0))/10^6*(1+$P$124)","v":3.9984E-3},3.9984E-3,3.9984E-3,3.9984E-3,3.9984E-3,3.9984E-3,3.9984E-3,3.9984E-3,3.9984E-3,3.9984E-3,null,{"$f":"SUM(C124:L124)","v":3.9983999999999999E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentual ônibus básico",8.3999999999999995E-3,{"$f":"C125","v":8.3999999999999995E-3},{"$f":"D125","v":8.3999999999999995E-3},8.3999999999999995E-3,8.3999999999999995E-3,8.3999999999999995E-3,8.3999999999999995E-3,8.3999999999999995E-3,8.3999999999999995E-3,8.3999999999999995E-3]
[null,"Preço do Ônibus Básico S/ ITS",{"$f":"'05. CAPEX'!$AF$23","v":476000},{"$f":"C126","v":476000},476000,476000,476000,476000,476000,476000,476000,476000]
[null,"Número Ônibus",{"$f":"C12","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,"Custo Total",{"$f":"C10+C68","v":0.66821132759180957},0.66821132759180957,0.66821132759180957,0.66821132759180957,0.66821132759180957,0.66821132759180957,0.66821132759180957,0.66821132759180957,0.66821132759180957,0.66821132759180957,null,{"$f":"SUM(C129:L129)","v":6.6821132759180948}]
[]
[null,"Índices anuais"]
[null,"Combustível",null,{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C30,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Lubrificante Diesel",null,{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C31,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Arla 32",null,{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C32,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Rodagem",null,{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C33,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Peças e Materiais de Manutenção",null,{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C34,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Motoristas - Direção",null,{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C35,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Motoristas - Cobrança",null,{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C36,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Cobradores",null,{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C37,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Benefícios Trabalhistas",null,{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C38,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Operação da Frota Auxiliar (Serviços)",null,{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C39,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Operac. e Manut. Infra Garagem",null,{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C40,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Operação de ITS",null,{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C41,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Operação de Bilhetagem",null,{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C42,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Fiscalização",null,{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C43,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Mão de Obra Manutenção, Adm. e Diretoria",null,{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C44,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Despesas Administrativas Gerais",null,{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C45,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Locação de Infraestrutura Garagem",null,{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C46,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Manutenção de Infraestrutura",null,{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C47,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Despesas Ambientais",null,{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C48,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Garantias Contratuais",null,{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C49,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Manutenção Infra Elétrica",null,{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Seguro e Licenciamento",null,{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C51,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Reposição de Baterias",null,{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C52,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Operação ITS/SBE Embarcado",null,{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C53,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[]
[null,"Índices diferenças"]
[null,"Combustível",{"$f":"C184/C$211-1","v":0},{"$f":"D184/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Lubrificante Diesel",0,{"$f":"D185/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Arla 32",0,{"$f":"D186/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Rodagem",0,{"$f":"D187/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Peças e Materiais de Manutenção",0,{"$f":"D188/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Motoristas - Direção",0,{"$f":"D189/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Motoristas - Cobrança",0,{"$f":"D190/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Cobradores",0,{"$f":"D191/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Benefícios Trabalhistas",0,{"$f":"D192/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Operação da Frota Auxiliar (Serviços)",0,{"$f":"D193/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Operac. e Manut. Infra Garagem",0,{"$f":"D194/D$211-1","v":0},0,0,0,0,0,0,0,0]
[null,"Operação de ITS",0,{"$f":"D195/D$211-1","v":0},0,0,0,{"$f":"H195/H$211-1","v":0},0,0,0,0]
[null,"Operação de Bilhetagem",0,0,0,0,0,{"$f":"H196/H$211-1","v":0},0,0,0,0]
[null,"Fiscalização",0,0,0,0,0,{"$f":"H197/H$211-1","v":0},0,0,0,0]
[null,"Mão de Obra Manutenção, Adm. e Diretoria",0,0,0,0,0,{"$f":"H198/H$211-1","v":0},0,0,0,0]
[null,"Despesas Administrativas Gerais",0,0,0,0,0,{"$f":"H199/H$211-1","v":0},0,0,0,0]
[null,"Locação de Infraestrutura Garagem",0,0,0,0,0,{"$f":"H200/H$211-1","v":0},0,0,0,0]
[null,"Manutenção de Infraestrutura",0,0,0,0,0,{"$f":"H201/H$211-1","v":0},0,0,0,0]
[null,"Despesas Ambientais",0,0,0,0,0,{"$f":"H202/H$211-1","v":0},0,0,0,0]
[null,"Garantias Contratuais",0,0,0,0,0,{"$f":"H203/H$211-1","v":0},0,0,0,0]
[null,"Manutenção Infra Elétrica",0,0,0,0,0,{"$f":"H204/H$211-1","v":0},0,0,0,0]
[null,"Seguro e Licenciamento",0,0,0,0,0,{"$f":"H205/H$211-1","v":0},0,0,0,0]
[null,"Reposição de baterias",0,0,0,0,0,{"$f":"H206/H$211-1","v":0},0,0,0,0]
[null,"Operação ITS/SBE Embarcado",0,{"$f":"D207/D$211-1","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Índices acumulados"]
[null,"Combustível",1,{"$f":"(C184)*(1+D132)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Lubrificante Diesel",1,{"$f":"(C185)*(1+D133)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Arla 32",1,{"$f":"(C186)*(1+D134)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Rodagem",1,{"$f":"(C187)*(1+D135)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Peças e Materiais de Manutenção",1,{"$f":"(C188)*(1+D136)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Motoristas - Direção",1,{"$f":"(C189)*(1+D137)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Motoristas - Cobrança",1,{"$f":"(C190)*(1+D138)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Cobradores",1,{"$f":"(C191)*(1+D139)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Benefícios Trabalhistas",1,{"$f":"(C192)*(1+D140)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Operação da Frota Auxiliar (Serviços)",1,{"$f":"(C193)*(1+D141)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Operac. e Manut. Infra Garagem",1,{"$f":"(C194)*(1+D142)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Operação de ITS",1,{"$f":"(C195)*(1+D143)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Operação de Bilhetagem",1,{"$f":"(C196)*(1+D144)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Fiscalização",1,{"$f":"(C197)*(1+D145)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Mão de Obra Manutenção, Adm. e Diretoria",1,{"$f":"(C198)*(1+D146)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Despesas Administrativas Gerais",1,{"$f":"(C199)*(1+D147)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Locação de Infraestrutura Garagem",1,{"$f":"(C200)*(1+D148)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Manutenção de Infraestrutura",1,{"$f":"(C201)*(1+D149)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Despesas Ambientais",1,{"$f":"(C202)*(1+D150)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Garantias Contratuais",1,{"$f":"(C203)*(1+D151)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Manutenção Infra Elétrica",1,{"$f":"(C204)*(1+D152)","v":1.0392000000000001},{"$f":"(D204)*(1+E152)","v":1.0729740000000001},{"$f":"(E204)*(1+F152)","v":1.1062361940000001},{"$f":"(F204)*(1+G152)","v":1.1395339034394001},{"$f":"(G204)*(1+H152)","v":1.1737199205425821},{"$f":"(H204)*(1+I152)","v":1.2089315181588596},{"$f":"(I204)*(1+J152)","v":1.2451994637036254},{"$f":"(J204)*(1+K152)","v":1.2825554476147343},{"$f":"(K204)*(1+L152)","v":1.3210321110431764}]
[null,"Seguro e Licenciamento",1,{"$f":"(C205)*(1+D153)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Reposição de baterias",1,{"$f":"(C206)*(1+D154)","v":1.0392000000000001},{"$f":"(D206)*(1+E154)","v":1.0729740000000001},{"$f":"(E206)*(1+F154)","v":1.1062361940000001},{"$f":"(F206)*(1+G154)","v":1.1395339034394001},{"$f":"(G206)*(1+H154)","v":1.1737199205425821},{"$f":"(H206)*(1+I154)","v":1.2089315181588596},{"$f":"(I206)*(1+J154)","v":1.2451994637036254},{"$f":"(J206)*(1+K154)","v":1.2825554476147343},{"$f":"(K206)*(1+L154)","v":1.3210321110431764}]
[null,"Operação ITS/SBE Embarcado",1,{"$f":"(C207)*(1+D155)","v":1.0392000000000001},{"$f":"(D207)*(1+E155)","v":1.0729740000000001},{"$f":"(E207)*(1+F155)","v":1.1062361940000001},{"$f":"(F207)*(1+G155)","v":1.1395339034394001},{"$f":"(G207)*(1+H155)","v":1.1737199205425821},{"$f":"(H207)*(1+I155)","v":1.2089315181588596},{"$f":"(I207)*(1+J155)","v":1.2451994637036254},{"$f":"(J207)*(1+K155)","v":1.2825554476147343},{"$f":"(K207)*(1+L155)","v":1.3210321110431764}]
[]
[null,"Índice acumulado - Receita"]
[null,{"$f":"'01. PC'!C61","v":"IPCA"},null,{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+D$8,0)","v":3.9200000000000013E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+E$8,0)","v":3.2499999999999973E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+F$8,0)","v":3.0999999999999965E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+G$8,0)","v":3.009999999999996E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+H$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+I$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+J$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+K$8,0)","v":2.9999999999999961E-2},{"$f":"HLOOKUP('01. PC'!$C61,'10. ÍNDICES'!$C$9:$M$900,21+L$8,0)","v":2.9999999999999961E-2}]
[null,"Acumulado",1,{"$f":"(C211)*(1+D210)","v":1.0392000000000001},{"$f":"(D211)*(1+E210)","v":1.0729740000000001},1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]

{"sheet":"07. (a)TRIBUTOS LREAL","index":7,"n_rows":131,"n_cols":22,"rows_kept":131,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIME","PIS","COFINS","IR","CS","ISS","INSS","RESEGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REAL",null,null,0.25,0.09,0.03,null,0]
[]
[]
[]
[null,"Tributos (R$ Milhões)"]
[]
[null,"PRAZO",{"$f":"IF(C10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(D10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(E10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(F10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(G10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(H10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(I10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(J10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(K10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(L10<=('01. PC'!$C$18),1,0)","v":1}]
[]
[null,"ANO",1,2,3,4,5,6,7,8,9,10,null,"Total"]
[]
[null,"Receitas",{"$f":"C14","v":0.82852807023955977},{"$f":"D14","v":0.82852807023955977},0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,null,{"$f":"SUM(C12:L12)","v":8.2852807023955961}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C14:L14)","v":8.2852807023955961}]
[]
[null,"ISS",{"$f":"(C19)*$T$2","v":2.4855842107186794E-2},{"$f":"(D19)*$T$2","v":2.4855842107186794E-2},2.4855842107186794E-2,2.4855842107186794E-2,2.4855842107186794E-2,2.4855842107186794E-2,2.4855842107186794E-2,2.4855842107186794E-2,2.4855842107186794E-2,2.4855842107186794E-2,null,{"$f":"SUM(C16:L16)","v":0.24855842107186799}]
[]
[null,"Base de Incidência"]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C19:L19)","v":8.2852807023955961}]
[]
[null,"INSS",{"$f":"(C24)*$U$2","v":0},{"$f":"(D24)*$U$2","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C21:L21)","v":0}]
[]
[null,"Base de Incidência"]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C24:L24)","v":8.2852807023955961}]
[]
[null,"RESEGE",{"$f":"(C29)*$V$2","v":0},{"$f":"(D29)*$V$2","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C26:L26)","v":0}]
[]
[null,"Base de Incidência"]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C29:L29)","v":8.2852807023955961}]
[]
[null,"PIS E COFINS - DEVIDO",{"$f":"(C34)*($P$2+$Q$2)","v":0},{"$f":"(D34)*($P$2+$Q$2)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C31:L31)","v":0}]
[]
[null,"Base de Incidência"]
[null,"Receita Tarifária",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C34:L34)","v":0}]
[]
[null,"PIS E COFINS - CRÉDITO",{"$f":"SUM(C38:C43)*($P$2+$Q$2)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C36:L36)","v":0}]
[]
[null,"Combustível",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C38:L38)","v":0}]
[null,"Lubrificantes",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Arla 32",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Rodagem",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Peças ",null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Depreciação",null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"Direito de Uso Crédito Tributário ",{"$f":"IF((C14)>0,(C31),0)","v":0},{"$f":"IF((D14)>0,(D31),0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C45:L45)","v":0}]
[]
[null,"Uso Crédito Tributário Real ",{"$f":"IF(C45>0,IF(C45<C53,C45,C53),0)","v":0},{"$f":"IF(D45>0,IF(C51/((1+D103)^1)+D53>0,IF(D45-(C51/((1+D103)^1)+D53)>0,C51/((1+D103)^1)+D53,D45),0),0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C47:L47)","v":0}]
[]
[null,"Despesas Tributária ",{"$f":"C31","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C49:L49)","v":0}]
[]
[null,"Estoque de Crédito Tributário ",{"$f":"C53-C47","v":0},{"$f":"C51/(1+D103)^1+D53-D47","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C51:L51)","v":0}]
[]
[null,"Criação de Crédito Tributário Nominal ",{"$f":"SUM(C55:C64)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C53:L53)","v":0}]
[]
[null,1,{"$f":"C$36","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C55:L55)","v":0}]
[null,2,null,{"$f":"D$36","v":0},null,null,null,null,null,null,null,null,null,0]
[null,3,null,null,{"$f":"E$36","v":0},null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,{"$f":"F$36","v":0},null,null,null,null,null,null,null,0]
[null,5,null,null,null,null,{"$f":"G$36","v":0},null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,{"$f":"H$36","v":0},null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,{"$f":"I$36","v":0},null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,{"$f":"J$36","v":0},null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,{"$f":"K$36","v":0},null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"L$36","v":0},null,0]
[]
[null,"Pis e Cofins Líquido",{"$f":"C49-C47","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C66:L66)","v":0}]
[]
[null,"Opex ",{"$f":"-'02. FCL'!C16","v":0.66821132759180957},{"$f":"-'02. FCL'!D16","v":0.66821132759180957},{"$f":"-'02. FCL'!E16","v":0.66821132759180957},{"$f":"-'02. FCL'!F16","v":0.66821132759180957},{"$f":"-'02. FCL'!G16","v":0.66821132759180957},{"$f":"-'02. FCL'!H16","v":0.66821132759180957},{"$f":"-'02. FCL'!I16","v":0.66821132759180957},{"$f":"-'02. FCL'!J16","v":0.66821132759180957},{"$f":"-'02. FCL'!K16","v":0.66821132759180957},{"$f":"-'02. FCL'!L16","v":0.66821132759180957},null,{"$f":"SUM(C68:L68)","v":6.6821132759180948}]
[]
[null,"Depreciação Real",{"$f":"'03. D&A Fiscal'!C73","v":0.1995547619047619},{"$f":"'03. D&A Fiscal'!D73","v":0.19005215419501134},{"$f":"'03. D&A Fiscal'!E73","v":0.1810020516142965},{"$f":"'03. D&A Fiscal'!F73","v":0.17238290629932998},{"$f":"'03. D&A Fiscal'!G73","v":0},{"$f":"'03. D&A Fiscal'!H73","v":0},{"$f":"'03. D&A Fiscal'!I73","v":0},{"$f":"'03. D&A Fiscal'!J73","v":0},{"$f":"'03. D&A Fiscal'!K73","v":0},{"$f":"'03. D&A Fiscal'!L73","v":0},null,{"$f":"SUM(C70:L70)","v":0.74299187401339972}]
[]
[null,"LAIR",{"$f":"C12-C16-C21-C26-C66-C68-C70","v":-6.4093861364198534E-2},-5.4591253654447974E-2,-4.5541151073733133E-2,-3.6922005758766613E-2,0.13546090054056337,0.13546090054056337,0.13546090054056337,0.13546090054056337,0.13546090054056337,0.13546090054056337,null,{"$f":"SUM(C72:L72)","v":0.61161713139223395}]
[]
[null,"ANO",1,2,3,4,5,6,7,8,9,10,null,"Total"]
[]
[null,"IRPJ/CSLL",{"$f":"IF(C72>0,C101-C99,0)","v":0},0,0,0,3.2239694328654075E-2,3.2239694328654075E-2,3.2239694328654075E-2,3.2239694328654075E-2,4.5720172766416239E-2,4.605670618379154E-2,null,{"$f":"SUM(C76:L76)","v":0.22073565626482408}]
[]
[null,"Alíquotas Efetivas (%)",{"$f":"IFERROR(IF(C72<0,0,C76/C72),0)","v":0},{"$f":"IFERROR(IF(D72<0,0,D76/D72),0)","v":0},0,0,0.23799999999999996,0.23799999999999996,0.23799999999999996,0.23799999999999996,0.33751564166462533,0.33999999999999997,null,{"$f":"SUM(C78:L78)","v":1.629515641664625}]
[]
[null,"Criação de Crédito Tributário ",{"$f":"IF(C72<0,-C72*($R$2+$S$2),0)","v":2.1791912863827499E-2},1.856102624251231E-2,1.5483991365069264E-2,1.2553481957980648E-2,0,0,0,0,0,0,null,{"$f":"SUM(C80:L80)","v":6.8390412429389716E-2}]
[]
[null,"Estoque de Crédito Tributário ",{"$f":"C84","v":2.1791912863827499E-2},{"$f":"C82/(1+D103)^1+D84-D99","v":3.9315228969967073E-2},5.2927066574561712E-2,6.2960212028991797E-2,4.6145094839140435E-2,3.0130697515472472E-2,1.4878890540550607E-2,3.5336008824406878E-4,0,0,null,{"$f":"SUM(C82:L82)","v":0.26850246342075562}]
[]
[null,"Crédito Tributário ",{"$f":"SUM(C86:C95)","v":2.1791912863827499E-2},1.856102624251231E-2,1.5483991365069264E-2,1.2553481957980648E-2,0,0,0,0,0,0,null,{"$f":"SUM(C84:L84)","v":6.8390412429389716E-2}]
[]
[null,1,{"$f":"C$80","v":2.1791912863827499E-2},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C86:L86)","v":2.1791912863827499E-2}]
[null,2,null,{"$f":"D$80","v":1.856102624251231E-2},null,null,null,null,null,null,null,null,null,1.856102624251231E-2]
[null,3,null,null,{"$f":"E$80","v":1.5483991365069264E-2},null,null,null,null,null,null,null,null,1.5483991365069264E-2]
[null,4,null,null,null,{"$f":"F$80","v":1.2553481957980648E-2},null,null,null,null,null,null,null,1.2553481957980648E-2]
[null,5,null,null,null,null,{"$f":"G$80","v":0},null,null,null,null,null,null,0]
[null,6,null,null,null,null,null,{"$f":"H$80","v":0},null,null,null,null,null,0]
[null,7,null,null,null,null,null,null,{"$f":"I$80","v":0},null,null,null,null,0]
[null,8,null,null,null,null,null,null,null,{"$f":"J$80","v":0},null,null,null,0]
[null,9,null,null,null,null,null,null,null,null,{"$f":"K$80","v":0},null,null,0]
[null,10,null,null,null,null,null,null,null,null,null,{"$f":"L$80","v":0},null,0]
[]
[null,"Direito de Uso de Crédito Tributário ",{"$f":"IF(C72>0,C72*($R$2+$S$2)*0.3,0)","v":0},0,0,0,1.3817011855137461E-2,1.3817011855137461E-2,1.3817011855137461E-2,1.3817011855137461E-2,1.3817011855137461E-2,1.3817011855137461E-2,null,{"$f":"SUM(C97:L97)","v":8.2902071130824775E-2}]
[]
[null,"Uso de Crédito Tributário Real ",{"$f":"IF(C72>0,0,C97)","v":0},{"$f":"IF(D97>0,IF(C82/((1+D103)^1)>0,IF(D97-C82/((1+D103)^1)>0,C82/((1+D103)^1),D97),0),0)","v":0},0,0,1.3817011855137461E-2,1.3817011855137461E-2,1.3817011855137461E-2,1.3817011855137461E-2,3.3653341737530356E-4,0,null,{"$f":"SUM(C99:L99)","v":5.5604580837925147E-2}]
[]
[null,"Despesas Tributárias ",{"$f":"IF(C72>0,C72*($R$2+$S$2),0)","v":0},0,0,0,4.605670618379154E-2,4.605670618379154E-2,4.605670618379154E-2,4.605670618379154E-2,4.605670618379154E-2,4.605670618379154E-2,null,{"$f":"SUM(C101:L101)","v":0.27634023710274924}]
[]
[null,"Inflação Anual ",{"$f":"'01. PC'!C65","v":0.05},{"$f":"'01. PC'!D65","v":0.05},{"$f":"'01. PC'!E65","v":0.05},{"$f":"'01. PC'!F65","v":0.05},{"$f":"'01. PC'!G65","v":0.05},{"$f":"'01. PC'!H65","v":0.05},{"$f":"'01. PC'!I65","v":0.05},{"$f":"'01. PC'!J65","v":0.05},{"$f":"'01. PC'!K65","v":0.05},{"$f":"'01. PC'!L65","v":0.05}]
[]
[null,"Inflação Acumulada",{"$f":"C103","v":0.05},{"$f":"(1+D103)*(1+C105)-1","v":0.10250000000000004},{"$f":"(1+E103)*(1+D105)-1","v":0.15762500000000013},0.21550625000000023,0.27628156250000035,0.34009564062500042,0.40710042265625046,0.47745544378906302,0.55132821597851622,0.62889462677744201]
[]
[null,"Simulação VPL - Regime Lucro Real - R$ Milhões"]
[]
[null,"Receita ",{"$f":"'02. FCL'!C12","v":0.82852807023955977},{"$f":"'02. FCL'!D12","v":0.82852807023955977},{"$f":"'02. FCL'!E12","v":0.82852807023955977},{"$f":"'02. FCL'!F12","v":0.82852807023955977},{"$f":"'02. FCL'!G12","v":0.82852807023955977},{"$f":"'02. FCL'!H12","v":0.82852807023955977},{"$f":"'02. FCL'!I12","v":0.82852807023955977},{"$f":"'02. FCL'!J12","v":0.82852807023955977},{"$f":"'02. FCL'!K12","v":0.82852807023955977},{"$f":"'02. FCL'!L12","v":0.82852807023955977},null,{"$f":"SUM(C109:L109)","v":8.2852807023955961}]
[]
[null,"Opex ",{"$f":"'02. FCL'!C16","v":-0.66821132759180957},{"$f":"'02. FCL'!D16","v":-0.66821132759180957},{"$f":"'02. FCL'!E16","v":-0.66821132759180957},{"$f":"'02. FCL'!F16","v":-0.66821132759180957},{"$f":"'02. FCL'!G16","v":-0.66821132759180957},{"$f":"'02. FCL'!H16","v":-0.66821132759180957},{"$f":"'02. FCL'!I16","v":-0.66821132759180957},{"$f":"'02. FCL'!J16","v":-0.66821132759180957},{"$f":"'02. FCL'!K16","v":-0.66821132759180957},{"$f":"'02. FCL'!L16","v":-0.66821132759180957},null,{"$f":"SUM(C111:L111)","v":-6.6821132759180948}]
[]
[null,"CAPEX",{"$f":"'02. FCL'!C21","v":-0.83813000000000004},{"$f":"'02. FCL'!D21","v":0},{"$f":"'02. FCL'!E21","v":0},{"$f":"'02. FCL'!F21","v":0},{"$f":"'02. FCL'!G21","v":0},{"$f":"'02. FCL'!H21","v":0},{"$f":"'02. FCL'!I21","v":0},{"$f":"'02. FCL'!J21","v":0},{"$f":"'02. FCL'!K21","v":0},{"$f":"'02. FCL'!L21","v":0},null,{"$f":"SUM(C113:L113)","v":-0.83813000000000004}]
[]
[null,"Impostos Total ",{"$f":"-(C16+C21+C26+C66+C76)","v":-2.4855842107186794E-2},-2.4855842107186794E-2,-2.4855842107186794E-2,-2.4855842107186794E-2,-5.7095536435840866E-2,-5.7095536435840866E-2,-5.7095536435840866E-2,-5.7095536435840866E-2,-7.057601487360303E-2,-7.0912548290978331E-2,null,{"$f":"SUM(C115:L115)","v":-0.46929407733669198}]
[]
[null,"NIG ",{"$f":"'02. FCL'!C35","v":0},{"$f":"'02. FCL'!D35","v":0},{"$f":"'02. FCL'!E35","v":0},{"$f":"'02. FCL'!F35","v":0},{"$f":"'02. FCL'!G35","v":0},{"$f":"'02. FCL'!H35","v":0},{"$f":"'02. FCL'!I35","v":0},{"$f":"'02. FCL'!J35","v":0},{"$f":"'02. FCL'!K35","v":0},{"$f":"'02. FCL'!L35","v":0},null,{"$f":"SUM(C117:L117)","v":0}]
[]
[null,"Saldo Caixa",{"$f":"C109+C111+C113+C115+C117","v":-0.70266909945943667},{"$f":"D109+D111+D113+D115+D117","v":0.13546090054056339},0.13546090054056339,0.13546090054056339,0.10322120621190933,0.10322120621190933,0.10322120621190933,0.10322120621190933,8.9740727774147169E-2,8.9404194356771868E-2,null,{"$f":"SUM(C119:L119)","v":0.2957433491408098}]
[]
[null,"VPL - Ano 0 - Real ",{"$f":"C119","v":-0.70266909945943667},{"$f":"D119/((1+D127)*(1+C131))","v":0.11525632285459378},0.10631392700278157,9.8065345091844378E-2,6.8928040572623736E-2,6.358011857733506E-2,5.8647125969710598E-2,5.4096869610639663E-2,4.3382861349326646E-2,3.9866847993113907E-2,null,{"$f":"SUM(C121:L121)","v":-5.4531640437467332E-2}]
[]
[null,"VPL - Ano 0 - Presumido ",{"$f":"'07. (b)TRIBUTOS LPRESUMID'!C56","v":-0.79281295350150072},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!D56","v":3.8557813518179301E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!E56","v":3.5566227259654373E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!F56","v":3.2806749295806882E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!G56","v":3.0261371033267821E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!H56","v":2.7913481111953551E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!I56","v":2.5747756997884064E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!J56","v":2.3750064986992614E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!K56","v":2.1907367967342831E-2},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!L56","v":2.0207640337801491E-2},null,{"$f":"SUM(C123:L123)","v":-0.53609448099261769}]
[]
[null,"Regime escolhido",{"$f":"IF(C123>C121,\"Pres.\",\"Real\")","v":"Real"},{"$f":"IF(D123>D121,\"Pres.\",\"Real\")","v":"Real"},"Real","Real","Real","Real","Real","Real","Real","Real"]
[]
[null,"WACC real",{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2}]
[]
[null,"WACC Escohido",{"$f":"IF(C125=\"Real\",C127,'07. (b)TRIBUTOS LPRESUMID'!C60)","v":8.4113117668753401E-2},{"$f":"IF(D125=\"Real\",D127,'07. (b)TRIBUTOS LPRESUMID'!D60)","v":8.4113117668753401E-2},{"$f":"IF(E125=\"Real\",E127,'07. (b)TRIBUTOS LPRESUMID'!E60)","v":8.4113117668753401E-2},{"$f":"IF(F125=\"Real\",F127,'07. (b)TRIBUTOS LPRESUMID'!F60)","v":8.4113117668753401E-2},{"$f":"IF(G125=\"Real\",G127,'07. (b)TRIBUTOS LPRESUMID'!G60)","v":8.4113117668753401E-2},{"$f":"IF(H125=\"Real\",H127,'07. (b)TRIBUTOS LPRESUMID'!H60)","v":8.4113117668753401E-2},{"$f":"IF(I125=\"Real\",I127,'07. (b)TRIBUTOS LPRESUMID'!I60)","v":8.4113117668753401E-2},{"$f":"IF(J125=\"Real\",J127,'07. (b)TRIBUTOS LPRESUMID'!J60)","v":8.4113117668753401E-2},{"$f":"IF(K125=\"Real\",K127,'07. (b)TRIBUTOS LPRESUMID'!K60)","v":8.4113117668753401E-2},{"$f":"IF(L125=\"Real\",L127,'07. (b)TRIBUTOS LPRESUMID'!L60)","v":8.4113117668753401E-2}]
[]
[null,"WACC Acumulado",{"$f":"IF(C125=\"Real\",C127,'07. (b)TRIBUTOS LPRESUMID'!C64)","v":8.4113117668753401E-2},{"$f":"(1+C131)*(1+D129)-1","v":0.17530125190146406},0.27415950439888492,0.3813330327211486,0.4975212606421584,0.62348244265001207,0.76003861238178749,0.90808094728660604,1.0685755845272307,1.2425699260752796]

{"sheet":"07. (b)TRIBUTOS LPRESUMID","index":8,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"REGIME","PIS","COFINS","IR","CS","ISS","INSS","RESEGE","PRESUNÇÃO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRESUMIDO",null,null,0.25,0.09,0.03,null,0,0.32]
[]
[]
[]
[]
[]
[null,"Tributos (R$ Milhões)"]
[]
[null,"ANO",1,2,3,4,5,6,7,8,9,10,null,"Total"]
[]
[null,"Receitas",{"$f":"C14","v":0.82852807023955977},{"$f":"D14","v":0.82852807023955977},0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,null,{"$f":"SUM(C12:L12)","v":8.2852807023955961}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C14:L14)","v":8.2852807023955961}]
[]
[null,"ISS sobre Receitas",{"$f":"-(C18)*$T$2","v":-2.4855842107186794E-2},{"$f":"-(D18)*$T$2","v":-2.4855842107186794E-2},-2.4855842107186794E-2,-2.4855842107186794E-2,-2.4855842107186794E-2,-2.4855842107186794E-2,-2.4855842107186794E-2,-2.4855842107186794E-2,-2.4855842107186794E-2,-2.4855842107186794E-2,null,{"$f":"SUM(C16:L16)","v":-0.24855842107186799}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C18:L18)","v":8.2852807023955961}]
[]
[null,"PIS e Cofins",{"$f":"-(C22)*($P$2+$Q$2)","v":0},{"$f":"-(D22)*($P$2+$Q$2)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C20:L20)","v":0}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C22:L22)","v":8.2852807023955961}]
[]
[null,"INSS",{"$f":"-(C26)*($U$2)","v":0},{"$f":"-(D26)*($U$2)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C24:L24)","v":0}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C26:L26)","v":8.2852807023955961}]
[]
[null,"RESEGE",{"$f":"-(C30)*($V$2)","v":0},{"$f":"-(D30)*($V$2)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C28:L28)","v":0}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.82852807023955977},{"$f":"'02. FCL'!D14","v":0.82852807023955977},{"$f":"'02. FCL'!E14","v":0.82852807023955977},{"$f":"'02. FCL'!F14","v":0.82852807023955977},{"$f":"'02. FCL'!G14","v":0.82852807023955977},{"$f":"'02. FCL'!H14","v":0.82852807023955977},{"$f":"'02. FCL'!I14","v":0.82852807023955977},{"$f":"'02. FCL'!J14","v":0.82852807023955977},{"$f":"'02. FCL'!K14","v":0.82852807023955977},{"$f":"'02. FCL'!L14","v":0.82852807023955977},null,{"$f":"SUM(C30:L30)","v":8.2852807023955961}]
[]
[null,"LAIR Presumido",{"$f":"C12*$W$2","v":0.26512898247665911},0.26512898247665911,0.26512898247665911,0.26512898247665911,0.26512898247665911,0.26512898247665911,0.26512898247665911,0.26512898247665911,0.26512898247665911,0.26512898247665911,null,{"$f":"SUM(C32:L32)","v":2.6512898247665908}]
[]
[null,"IRPJ/CSLL",{"$f":"-IF(C32<=0,C32*0%,C32*($R$2+$S$2))","v":-9.0143854042064084E-2},-9.0143854042064084E-2,-9.0143854042064084E-2,-9.0143854042064084E-2,-9.0143854042064084E-2,-9.0143854042064084E-2,-9.0143854042064084E-2,-9.0143854042064084E-2,-9.0143854042064084E-2,-9.0143854042064084E-2,null,{"$f":"SUM(C34:L34)","v":-0.90143854042064064}]
[]
[null,"Total de Impostos (R$ Mil)",{"$f":"C16+C20+C24+C28+C34","v":-0.11499969614925087},-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,null,{"$f":"SUM(C36:L36)","v":-1.1499969614925085}]
[]
[]
[null,"Simulação VPL - Regime Lucro Presumido - R$ Milhões"]
[]
[]
[null,"Receita ",{"$f":"'02. FCL'!C12","v":0.82852807023955977},{"$f":"'02. FCL'!D12","v":0.82852807023955977},{"$f":"'02. FCL'!E12","v":0.82852807023955977},{"$f":"'02. FCL'!F12","v":0.82852807023955977},{"$f":"'02. FCL'!G12","v":0.82852807023955977},{"$f":"'02. FCL'!H12","v":0.82852807023955977},{"$f":"'02. FCL'!I12","v":0.82852807023955977},{"$f":"'02. FCL'!J12","v":0.82852807023955977},{"$f":"'02. FCL'!K12","v":0.82852807023955977},{"$f":"'02. FCL'!L12","v":0.82852807023955977},null,{"$f":"SUM(C42:L42)","v":8.2852807023955961}]
[]
[null,"Opex ",{"$f":"'02. FCL'!C16","v":-0.66821132759180957},{"$f":"'02. FCL'!D16","v":-0.66821132759180957},{"$f":"'02. FCL'!E16","v":-0.66821132759180957},{"$f":"'02. FCL'!F16","v":-0.66821132759180957},{"$f":"'02. FCL'!G16","v":-0.66821132759180957},{"$f":"'02. FCL'!H16","v":-0.66821132759180957},{"$f":"'02. FCL'!I16","v":-0.66821132759180957},{"$f":"'02. FCL'!J16","v":-0.66821132759180957},{"$f":"'02. FCL'!K16","v":-0.66821132759180957},{"$f":"'02. FCL'!L16","v":-0.66821132759180957},null,{"$f":"SUM(C44:L44)","v":-6.6821132759180948}]
[]
[null,"CAPEX",{"$f":"'02. FCL'!C21","v":-0.83813000000000004},{"$f":"'02. FCL'!D21","v":0},{"$f":"'02. FCL'!E21","v":0},{"$f":"'02. FCL'!F21","v":0},{"$f":"'02. FCL'!G21","v":0},{"$f":"'02. FCL'!H21","v":0},{"$f":"'02. FCL'!I21","v":0},{"$f":"'02. FCL'!J21","v":0},{"$f":"'02. FCL'!K21","v":0},{"$f":"'02. FCL'!L21","v":0},null,{"$f":"SUM(C46:L46)","v":-0.83813000000000004}]
[]
[null,"Impostos Total ",{"$f":"C36","v":-0.11499969614925087},-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,-0.11499969614925087,null,{"$f":"SUM(C48:L48)","v":-1.1499969614925085}]
[]
[null,"NIG ",{"$f":"'02. FCL'!C35","v":0},{"$f":"'02. FCL'!D35","v":0},{"$f":"'02. FCL'!E35","v":0},{"$f":"'02. FCL'!F35","v":0},{"$f":"'02. FCL'!G35","v":0},{"$f":"'02. FCL'!H35","v":0},{"$f":"'02. FCL'!I35","v":0},{"$f":"'02. FCL'!J35","v":0},{"$f":"'02. FCL'!K35","v":0},{"$f":"'02. FCL'!L35","v":0},null,{"$f":"SUM(C50:L50)","v":0}]
[]
[null,"Saldo Caixa",{"$f":"C42+C44+C46+C48+C50","v":-0.79281295350150072},{"$f":"D42+D44+D46+D48+D50","v":4.5317046498499325E-2},4.5317046498499325E-2,4.5317046498499325E-2,4.5317046498499325E-2,4.5317046498499325E-2,4.5317046498499325E-2,4.5317046498499325E-2,4.5317046498499325E-2,4.5317046498499325E-2,null,{"$f":"SUM(C52:L52)","v":-0.38495953501500679}]
[]
[null,"VPL - Ano 0 - Real ",{"$f":"'07. (a)TRIBUTOS LREAL'!C121","v":-0.70266909945943667},{"$f":"'07. (a)TRIBUTOS LREAL'!D121","v":0.11525632285459378},{"$f":"'07. (a)TRIBUTOS LREAL'!E121","v":0.10631392700278157},{"$f":"'07. (a)TRIBUTOS LREAL'!F121","v":9.8065345091844378E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!G121","v":6.8928040572623736E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!H121","v":6.358011857733506E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!I121","v":5.8647125969710598E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!J121","v":5.4096869610639663E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!K121","v":4.3382861349326646E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!L121","v":3.9866847993113907E-2},null,{"$f":"SUM(C54:L54)","v":-5.4531640437467332E-2}]
[]
[null,"VPL - Ano 0 - Presumido ",{"$f":"C52","v":-0.79281295350150072},{"$f":"D52/((1+D60)*(1+C64))","v":3.8557813518179301E-2},{"$f":"E52/((1+E60)*(1+D64))","v":3.5566227259654373E-2},3.2806749295806882E-2,3.0261371033267821E-2,2.7913481111953551E-2,2.5747756997884064E-2,2.3750064986992614E-2,2.1907367967342831E-2,2.0207640337801491E-2,null,{"$f":"SUM(C56:L56)","v":-0.53609448099261769}]
[]
[null,"Regime escolhido",{"$f":"IF(C56>C54,\"Pres.\",\"Real\")","v":"Real"},{"$f":"IF(D56>D54,\"Pres.\",\"Real\")","v":"Real"},"Real","Real","Real","Real","Real","Real","Real","Real"]
[]
[null,"WACC presumido",{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2},{"$f":"'01. PC'!$C$10","v":8.4113117668753401E-2}]
[]
[null,"WACC escolhido",{"$f":"IF(C58=\"real\",'07. (a)TRIBUTOS LREAL'!C129,'07. (b)TRIBUTOS LPRESUMID'!C60)","v":8.4113117668753401E-2},{"$f":"IF(D58=\"real\",'07. (a)TRIBUTOS LREAL'!D129,'07. (b)TRIBUTOS LPRESUMID'!D60)","v":8.4113117668753401E-2},{"$f":"IF(E58=\"real\",'07. (a)TRIBUTOS LREAL'!E129,'07. (b)TRIBUTOS LPRESUMID'!E60)","v":8.4113117668753401E-2},{"$f":"IF(F58=\"real\",'07. (a)TRIBUTOS LREAL'!F129,'07. (b)TRIBUTOS LPRESUMID'!F60)","v":8.4113117668753401E-2},{"$f":"IF(G58=\"real\",'07. (a)TRIBUTOS LREAL'!G129,'07. (b)TRIBUTOS LPRESUMID'!G60)","v":8.4113117668753401E-2},{"$f":"IF(H58=\"real\",'07. (a)TRIBUTOS LREAL'!H129,'07. (b)TRIBUTOS LPRESUMID'!H60)","v":8.4113117668753401E-2},{"$f":"IF(I58=\"real\",'07. (a)TRIBUTOS LREAL'!I129,'07. (b)TRIBUTOS LPRESUMID'!I60)","v":8.4113117668753401E-2},{"$f":"IF(J58=\"real\",'07. (a)TRIBUTOS LREAL'!J129,'07. (b)TRIBUTOS LPRESUMID'!J60)","v":8.4113117668753401E-2},{"$f":"IF(K58=\"real\",'07. (a)TRIBUTOS LREAL'!K129,'07. (b)TRIBUTOS LPRESUMID'!K60)","v":8.4113117668753401E-2},{"$f":"IF(L58=\"real\",'07. (a)TRIBUTOS LREAL'!L129,'07. (b)TRIBUTOS LPRESUMID'!L60)","v":8.4113117668753401E-2}]
[]
[null,"WACC Acumulado",{"$f":"C62","v":8.4113117668753401E-2},{"$f":"(1+D62)*(1+C64)-1","v":0.17530125190146406},{"$f":"(1+E62)*(1+D64)-1","v":0.27415950439888492},0.3813330327211486,0.4975212606421584,0.62348244265001207,0.76003861238178749,0.90808094728660604,1.0685755845272307,1.2425699260752796]

{"sheet":"08. RECEITA E DEMANDA","index":9,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Receita (R$ Milhões)"]
[]
[null,"PRAZO",{"$f":"IF(C10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(D10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(E10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(F10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(G10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(H10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(I10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(J10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(K10<=('01. PC'!$C$18),1,0)","v":1},{"$f":"IF(L10<=('01. PC'!$C$18),1,0)","v":1}]
[]
[null,"Receita",1,{"$f":"C10+1","v":2},{"$f":"D10+1","v":3},{"$f":"E10+1","v":4},{"$f":"F10+1","v":5},{"$f":"G10+1","v":6},{"$f":"H10+1","v":7},{"$f":"I10+1","v":8},{"$f":"J10+1","v":9},{"$f":"K10+1","v":10},null,"TOTAL",null,"RISCO"]
[]
[null,"Total Receita - R$ Milhões",{"$f":"C14","v":0.82852807023955977},{"$f":"D14","v":0.82852807023955977},0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,null,{"$f":"SUM(C12:L12)","v":8.2852807023955961}]
[]
[null,"Receita Tarifária",{"$f":"(C16*C17)/10^6*C$8","v":0.82852807023955977},{"$f":"(D16*D17)/10^6*D$8","v":0.82852807023955977},0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,0.82852807023955977,null,{"$f":"SUM(C14:L14)","v":8.2852807023955961}]
[]
[null,"Passageiros Equivalente",{"$f":"'01. PC'!$C$22*(1+$P$16)","v":200000},{"$f":"C16","v":200000},{"$f":"D16","v":200000},200000,200000,200000,200000,200000,200000,200000,null,null,null,{"$f":"'09. SENSIBILIDADE'!$C$12","v":0}]
[null,"Tarifa",{"$f":"'01. PC'!$C$20*(1+$P$17)","v":4.1426403511977989},{"$f":"C17","v":4.1426403511977989},{"$f":"D17","v":4.1426403511977989},4.1426403511977989,4.1426403511977989,4.1426403511977989,4.1426403511977989,4.1426403511977989,4.1426403511977989,4.1426403511977989,null,null,null,{"$f":"'09. SENSIBILIDADE'!$C$14","v":0}]

{"sheet":"09. SENSIBILIDADE","index":10,"n_rows":26,"n_cols":20,"rows_kept":26,"cut":false,"hidden":false,"merged":[[19,11,25,11],[19,1,25,1],[17,3,17,9],[17,13,17,19]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Opex",0]
[]
[null,"Capex",0]
[]
[null,"Demanda",0]
[]
[null,"Tarifa ",0]
[]
[]
[null,null,null,"Sensibilidade a TIR do Projeto",null,null,null,null,null,null,null,null,null,null,"Sensibilidade a TIR do Projeto"]
[null,null,null,"Capex (Milhões)",null,null,null,null,null,null,null,null,null,"Demanda"]
[null,null,{"$f":"'01. PC'!$C$12","v":8.4107545582134957E-2},-0.15,-0.1,-0.05,0,0.05,0.1,0.15,null,null,{"$f":"'01. PC'!$C$12","v":8.4107545582134957E-2},-0.15,-0.1,-0.05,0,0.05,0.1,0.15]
[null,"Opex (Milhões)",-0.15000000000000002,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,"Tarifa",-0.15000000000000002,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,-0.1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,-0.05,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,-0.05,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,0,4.2724495518736028E-2,5.3118679145522485E-2,6.48737681954481E-2,7.845316106774658E-2,9.4632456461487546E-2,0.11642436603095252,0.14811963741565792,null,null,0,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},7.845316106774658E-2,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,0.05,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.05,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,0.1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,0.15000000000000002,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.15000000000000002,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]

{"sheet":"10. ÍNDICES","index":11,"n_rows":90,"n_cols":13,"rows_kept":90,"cut":false,"hidden":false,"merged":[[7,2,7,12]]}
[]
[]
[]
[]
[]
[]
[null,null,"Ano",2001,"Indice","IPCA"]
[null,null,"Projeções Consolidadas"]
[null,null,"IPCA","IGP-M","IPCA15","IPA-M","IPC-M","INCC-M","IGP-DI","IPA-DI","IPC-DI","INCC-DI","IPC Fipe"]
[null,2001,7.6732630151519876E-2,0.10372331562315451,7.512713849918895E-2,0.11880323900761902,7.7378873954026872E-2,9.0429906216449307E-2,8.9724159747041954E-2,0.11883663550250856,8.0473556057061302E-2,8.8452990044712188E-2,7.1255249933856568E-2]
[null,2002,0.12530337079575027,0.25303857698389676,0.11986812186452256,0.33644437024596896,0.11867462340523027,0.12454032344962185,0.26411847884794071,0.35413637251954921,0.12151319863831045,0.12867551193966054,9.9198852631231293E-2]
[null,2003,9.2999493292351465E-2,8.6913680148965611E-2,9.8612182476555121E-2,7.6447205488488157E-2,9.3345694446429928E-2,0.14746183165786975,7.6630288197010898E-2,6.273472340939823E-2,8.9203566563483383E-2,0.14416651483773024,8.1667078415079697E-2]
[null,2004,7.6006441380604528E-2,0.12419987276349853,7.535458582588328E-2,0.15082837848501773,6.2062567597722218E-2,0.10942758272711584,0.12130330302024417,0.14683795737802963,6.2784147152017411E-2,0.11043412828422627,6.5653973932572995E-2]
[null,2005,5.6897333458586496E-2,1.2007603039307924E-2,5.8785530241364903E-2,-9.3563942270000755E-3,4.970564463756455E-2,6.8488298290575012E-2,1.2321269216679198E-2,-9.6272998667710219E-3,4.9290612265379563E-2,6.8284440141210379E-2,4.5254296739354105E-2]
[null,2006,3.1417749683044338E-2,3.84762599579207E-2,2.9570212925763117E-2,4.386682558873134E-2,1.8820633830364697E-2,5.0451604607503864E-2,3.7972627243065382E-2,4.3156801592808325E-2,2.0644276184596633E-2,5.0358517586654994E-2,2.5420881236833504E-2]
[null,2007,4.4573304332378161E-2,7.7462737333542142E-2,4.363711614973198E-2,9.1997223757986024E-2,4.6332538405617019E-2,6.0323788125189459E-2,7.8984050237231651E-2,9.4312721949537881E-2,4.6130506897717583E-2,6.2691509521382693E-2,4.3722640377938049E-2]
[null,2008,5.9023134175254954E-2,9.8054312797284382E-2,6.1018676060480725E-2,0.10841126356647823,6.0669922505927731E-2,0.11967367703693155,9.1073050445837689E-2,9.7963191934844263E-2,6.0663610626817022E-2,0.11860159862803643,6.1729054756951784E-2]
[null,2009,4.3120283296899986E-2,-1.7122753570905758E-2,4.1868066772809742E-2,-4.4127988341593705E-2,3.9680904891772117E-2,3.2061792038274861E-2,-1.4364020064340011E-2,-4.085817756837129E-2,3.9261184012222561E-2,3.2474257580620058E-2,3.6489614469896958E-2]
[null,2010,5.9090683472662331E-2,0.11322017324473954,5.7925137167165852E-2,0.13912448179247905,6.0919833242710109E-2,7.5683341343950605E-2,0.11305793223314975,0.13833556087317,6.2281226311552418E-2,7.7717348828594934E-2,6.4129405799535188E-2]
[null,2011,6.5031090406288516E-2,5.0977446141180049E-2,6.5556262326476489E-2,4.3593980567640189E-2,6.1593737456748787E-2,7.584156842240497E-2,5.0125359217805698E-2,4.1154264356699999E-2,6.3594943658929148E-2,7.4817651554371922E-2,5.8043991885818214E-2]
[null,2012,5.8385689976391486E-2,7.8119280443993855E-2,5.776087713678546E-2,8.6520720748908486E-2,5.7851995838871906E-2,7.2621864696475802E-2,8.1120657805823004E-2,9.1371841860026004E-2,5.7332426727830121E-2,7.1197401843283492E-2,5.1116069354199878E-2]
[null,2013,5.9108180800137911E-2,5.5256584209615101E-2,5.8481146285689345E-2,5.1233007886267501E-2,5.5097121139702221E-2,8.0694309277285381E-2,5.5277579940174792E-2,5.0642894806943284E-2,5.6354359645876873E-2,8.0874935545907523E-2,3.8909438593769385E-2]
[null,2014,6.4076165963919518E-2,3.6748825080479719E-2,6.4610484040459104E-2,2.1346573288872017E-2,6.7670436113434818E-2,6.7400447196423352E-2,3.7799970910904479E-2,2.1662804682900383E-2,6.8626188027644641E-2,6.9449297187176739E-2,5.2063967274121437E-2]
[null,2015,0.10673497995621717,0.10544294612942617,0.10706507096466478,0.11191850116934954,0.10233586037997244,7.2169964106145956E-2,0.10678607417563946,0.11318841001979263,0.10537756768660467,7.4938904537515727E-2,0.11080037782489849]
[null,2016,6.2880550542244951E-2,7.1907075096276696E-2,6.5833254214220371E-2,7.6270003427727273E-2,6.2633460600982849E-2,6.3374453315894419E-2,7.1533189768492766E-2,7.7333994211231216E-2,6.1880808601060266E-2,6.112220744888619E-2,6.5490087072287873E-2]
[null,2017,2.9473499083459087E-2,-5.3258903662349866E-3,2.9370935389996244E-2,-2.5447742908859539E-2,3.1317009144559149E-2,4.025352747463562E-2,-4.2307110572900042E-3,-2.5173943958269329E-2,3.2227418097748872E-2,4.2462365784813771E-2,2.2806082706782194E-2]
[null,2018,3.7454821218273926E-2,7.5521356336592183E-2,3.8605448074135129E-2,9.4176352547488351E-2,4.1211777352023971E-2,3.9681012062025234E-2,7.1020623903502056E-2,8.7306283647307081E-2,4.3374435506575715E-2,3.8323933408558775E-2,2.9935805407808047E-2]
[null,2019,4.3060399841131858E-2,7.3179082806147377E-2,3.9132127594363686E-2,9.0917353828604996E-2,3.7892129418848786E-2,4.1329977111107308E-2,7.6775885413978839E-2,9.6047110841510852E-2,4.1212989943000711E-2,4.1432422562298621E-2,4.3808249723044534E-2]
[null,2020,4.5173415005098638E-2,0.23139054040480334,4.2274590986961291E-2,0.31644282853470918,4.8219338860369998E-2,8.6843946198617905E-2,0.23074334480721959,0.31730417197811045,5.1663287721144924E-2,8.8129077780450427E-2,5.6361132572430916E-2]
[null,2021,7.1800000000000044E-2,0.19800000000000001,6.884860043697813E-2,0.25405793728696158,7.0514355484389418E-2,0.10816492320922701,0.19310012723877679,0.2495689536167558,7.2952890667581621E-2,0.11058333978029589,6.9651460417732819E-2]
[null,2022,3.9200000000000013E-2,4.9899999999999993E-2,3.9685976702689064E-2,4.5904387428903022E-2,3.671631122462804E-2,7.084962443254457E-2,4.4234860961854923E-2,3.8745733270475612E-2,3.6772917819774903E-2,7.2387095089838538E-2,3.6430096035226331E-2]
[null,2023,3.2499999999999973E-2,3.9999999999999994E-2,3.1799884180747154E-2,4.006907496983042E-2,3.1851368436738255E-2,5.3271466618834806E-2,3.9187798561079769E-2,3.8630870791675875E-2,3.3142856257664312E-2,5.3902960650870801E-2,3.0675984213873891E-2]
[null,2024,3.0999999999999965E-2,3.9999999999999994E-2,2.9937826584196119E-2,4.0722042551437222E-2,3.0636586741878424E-2,4.6646848116603155E-2,3.9272090069665463E-2,3.8988381393912447E-2,3.1987496123645702E-2,4.6717332927306787E-2,2.949375262742961E-2]
[null,2025,3.009999999999996E-2,3.6199999999999996E-2,2.9010638677356933E-2,3.5326835752401697E-2,2.9798823269144643E-2,4.3205002709978374E-2,3.5411206656568134E-2,3.3462587257640418E-2,3.114205133852662E-2,4.2937296740586946E-2,2.8593537089925059E-2]
[null,2026,2.9999999999999961E-2,3.4999999999999996E-2,2.8887314342193347E-2,3.3750037264542135E-2,2.9737265174485345E-2,4.1728595565963242E-2,3.4341454880815914E-2,3.2027781580199102E-2,3.1095845303003414E-2,4.1274012093122002E-2,2.8456630721197789E-2]
[null,2027,2.9999999999999961E-2,3.4999999999999996E-2,2.8881730963181272E-2,3.3801733501093244E-2,2.9740415385508475E-2,4.1222350051705353E-2,3.437938749845644E-2,3.2117656660525525E-2,3.1099780144999017E-2,4.0679223840081144E-2,2.845687332831412E-2]
[null,2028,2.9999999999999961E-2,3.4999999999999996E-2,2.8881478181593995E-2,3.3800038610532324E-2,2.9740254174711662E-2,4.1048763435205207E-2,3.4378042435504755E-2,3.2112026957360366E-2,3.109944505930393E-2,4.0466528396463239E-2,2.8456872898398308E-2]
[null,2029,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466737174632E-2,3.3800094178484751E-2,2.9740262424610104E-2,4.0989242288687708E-2,3.4378090130455868E-2,3.211237959746497E-2,3.1099473594737675E-2,4.039046880465972E-2,2.8456872899160147E-2]
[null,2030,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466219040634E-2,3.3800092356657777E-2,2.9740262002424831E-2,4.0968833071927876E-2,3.4378088439227697E-2,3.2112357508370798E-2,3.1099471164699653E-2,4.0363270001493486E-2,2.8456872899158797E-2]
[null,2031,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466195582666E-2,3.3800092416387414E-2,2.9740262024029993E-2,4.0961834951879439E-2,3.4378088499197414E-2,3.2112358892013998E-2,3.1099471371638324E-2,4.0353543747695196E-2,2.8456872899158797E-2]
[null,2032,2.9999999999999961E-2,3.4999999999999996E-2,2.888146619452063E-2,3.3800092414429148E-2,2.9740262022924357E-2,4.095943536522266E-2,3.4378088497070927E-2,3.2112358805343688E-2,3.1099471354015716E-2,4.0350065653002185E-2,2.8456872899158797E-2]
[null,2033,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194472547E-2,3.3800092414493346E-2,2.9740262022980937E-2,4.0958612570517292E-2,3.4378088497146332E-2,3.2112358810772651E-2,3.1099471355516432E-2,4.0348821891226641E-2,2.8456872899158797E-2]
[null,2034,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470372E-2,3.3800092414491244E-2,2.9740262022978043E-2,4.0958330442291052E-2,3.4378088497143661E-2,3.211235881043259E-2,3.1099471355388635E-2,4.0348377123763171E-2,2.8456872899158797E-2]
[null,2035,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470271E-2,3.3800092414491313E-2,2.9740262022978192E-2,4.0958233703292213E-2,3.4378088497143758E-2,3.2112358810453885E-2,3.1099471355399515E-2,4.0348218075543132E-2,2.8456872899158797E-2]
[null,2036,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958200532439301E-2,3.4378088497143751E-2,3.2112358810452553E-2,3.1099471355398589E-2,4.0348161200123106E-2,2.8456872899158797E-2]
[null,2037,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958189158479513E-2,3.4378088497143751E-2,3.2112358810452636E-2,3.1099471355398669E-2,4.0348140861552813E-2,2.8456872899158797E-2]
[null,2038,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958185258460372E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348133588508653E-2,2.8456872899158797E-2]
[null,2039,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183921182098E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348130987678275E-2,2.8456872899158797E-2]
[null,2040,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183462642503E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348130057624991E-2,2.8456872899158797E-2]
[null,2041,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183305413787E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.034812972503924E-2,2.8456872899158797E-2]
[null,2042,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183251501606E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129606107043E-2,2.8456872899158797E-2]
[null,2043,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183233015644E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129563577056E-2,2.8456872899158797E-2]
[null,2044,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183226676992E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129548368396E-2,2.8456872899158797E-2]
[null,2045,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183224503522E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129542929802E-2,2.8456872899158797E-2]
[null,2046,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223758271E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129540984962E-2,2.8456872899158797E-2]
[null,2047,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223502725E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.034812954028949E-2,2.8456872899158797E-2]
[null,2048,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223415101E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129540040793E-2,2.8456872899158797E-2]
[null,2049,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223385056E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539951857E-2,2.8456872899158797E-2]
[null,2050,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223374758E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539920057E-2,2.8456872899158797E-2]
[null,2051,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.095818322337122E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539908684E-2,2.8456872899158797E-2]
[null,2052,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223370012E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539904617E-2,2.8456872899158797E-2]
[null,2053,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369596E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.034812953990316E-2,2.8456872899158797E-2]
[null,2054,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369457E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.034812953990264E-2,2.8456872899158797E-2]
[null,2055,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369402E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902453E-2,2.8456872899158797E-2]
[null,2056,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.034812953990239E-2,2.8456872899158797E-2]
[null,2057,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902369E-2,2.8456872899158797E-2]
[null,2058,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902362E-2,2.8456872899158797E-2]
[null,2059,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2060,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2061,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2062,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2063,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2064,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2065,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2066,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2067,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2068,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2069,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2070,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2071,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2072,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2073,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2074,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2075,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2076,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2077,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2078,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2079,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2080,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978182E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]
[null,2081,2.9999999999999961E-2,3.4999999999999996E-2,2.8881466194470268E-2,3.3800092414491306E-2,2.9740262022978185E-2,4.0958183223369388E-2,3.4378088497143751E-2,3.2112358810452629E-2,3.1099471355398662E-2,4.0348129539902355E-2,2.8456872899158797E-2]

{"sheet":"11. WACC ","index":12,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Lucro Real",null,null,null,"Lucro Presumido"]
[null,"Variáveis",null,"Premissas",null,"Variáveis",null,"Premissas"]
[]
[null,"Custo de Capital Próprio (Ke) - Real",null,{"$f":"B9","v":"Custo de Capital Próprio (Ke) - Real"},null,{"$f":"B9","v":"Custo de Capital Próprio (Ke) - Real"},null,{"$f":"F9","v":"Custo de Capital Próprio (Ke) - Real"}]
[null,"Taxa Livre de Risco (Rf)",5.7868181818181832E-2,"TESOURO NTNB 2035 (07/2022)",null,{"$f":"B10","v":"Taxa Livre de Risco (Rf)"},{"$f":"C10","v":5.7868181818181832E-2},{"$f":"D10","v":"TESOURO NTNB 2035 (07/2022)"}]
[null,"Prêmio de Risco de Mercado (Rm - Rf)",5.315144710489348E-2,"Shiler",null,{"$f":"B11","v":"Prêmio de Risco de Mercado (Rm - Rf)"},5.315144710489348E-2,{"$f":"D11","v":"Shiler"}]
[null,"Beta Alavancado",1.3100565721589881,"Setor de transportes",null,"Beta Alavancado",1.3100565721589881,{"$f":"D12","v":"Setor de transportes"}]
[null,"Ke (BRL Real)",{"$f":"C12*C11+C10","v":0.12749958441770837},"Ke (BRL Real) = Rf + B(Rm - Rf) + CRP",null,"Ke (BRL Real)",{"$f":"G12*G11+G10","v":0.12749958441770837},{"$f":"D13","v":"Ke (BRL Real) = Rf + B(Rm - Rf) + CRP"}]
[]
[null,"Custo da Dívida (Kd) - Real",null,{"$f":"B15","v":"Custo da Dívida (Kd) - Real"},null,{"$f":"B15","v":"Custo da Dívida (Kd) - Real"},null,{"$f":"F15","v":"Custo da Dívida (Kd) - Real"}]
[null,"Alíquota do Imposto de Renda e Contribuição Social Efetivos (t)",0.34,"Alíquota de IRPJ e CSLL sobre o Lucro Líquido vigente no Brasil",null,{"$f":"B16","v":"Alíquota do Imposto de Renda e Contribuição Social Efetivos (t)"},null,{"$f":"D16","v":"Alíquota de IRPJ e CSLL sobre o Lucro Líquido vigente no Brasil"}]
[null,"Inflação  Brasil",4.444E-2,"Média expectativa focus para próximos 5 anos",null,{"$f":"B17","v":"Inflação  Brasil"},4.444E-2,{"$f":"D17","v":"Média expectativa focus para próximos 5 anos"}]
[null,"Taxa de Juros Nominal",0.13308666666666669,"Demonstrações Financeiras Empresas do setor 1T2022",null,"Taxa de Juros Nominal",{"$f":"C18","v":0.13308666666666669},{"$f":"D18","v":"Demonstrações Financeiras Empresas do setor 1T2022"}]
[null,"Kd nominal com benefício fiscal",8.7837200000000004E-2,"Kd - Alíquota de imposto",null,"Kd nominal com benefício fiscal",{"$f":"G18*(1-G16)","v":0.13308666666666669},{"$f":"D19","v":"Kd - Alíquota de imposto"}]
[]
[null,"Kd real com benefício fiscal",{"$f":"(1+C19)/(1+C17) -1","v":4.1550687449733781E-2},{"$f":"B21","v":"Kd real com benefício fiscal"},null,{"$f":"B21","v":"Kd real com benefício fiscal"},{"$f":"(1+G19)/(1+G17) -1","v":8.4874829254592665E-2},{"$f":"D21","v":"Kd real com benefício fiscal"}]
[]
[null,"Estrutura de Capital",null,{"$f":"B23","v":"Estrutura de Capital"},null,"Estrutura de Capital",null,{"$f":"F23","v":"Estrutura de Capital"}]
[null,"Dívida Bruta / Capital Total (D)",0.50479375861125009,"Média do setor: Transportes 2015-2T2022",null,"Dívida Bruta / Capital Total (D)",{"$f":"C24","v":0.50479375861125009},{"$f":"D24","v":"Média do setor: Transportes 2015-2T2022"}]
[null,"Equity / Capital Total (E)",0.49520624138874991,"Média do setor: Transportes 2015-2T2022",null,"Equity / Capital Total (E)",0.49520624138874991,{"$f":"D25","v":"Média do setor: Transportes 2015-2T2022"}]
[]
[null,"WACC Real",{"$f":"C24*C21+C25*C13","v":8.4113117668753401E-2},"Kd x Wd + Ke x We",null,{"$f":"B27","v":"WACC Real"},{"$f":"G24*G21+G25*G13","v":0.10598287404903489},{"$f":"D27","v":"Kd x Wd + Ke x We"}]