{"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":[[5,1,5,9],[9,1,9,9],[11,1,11,9],[13,1,13,9],[7,1,7,9],[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]]}
[]
[]
[]
[]
[]
[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,null,null,null," "]
[null,"TIR de Projeto - Real",{"$f":"'02. FCL'!C41","v":8.4101733169426263E-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",3.5272164812431481]
[]
[null,"Passageiros Equivalentes por ano",200000]
[]
[null,"Tipo de Ônibus","Básico"]
[]
[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.70544329624862956},{"$f":"(D14)*D$8","v":0.70544329624862956},0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,null,{"$f":"SUM(C12:L12)","v":7.0544329624862971},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D12:L12)+'02. FCL'!C12","v":5.0378800636335406}]
[]
[null,"Receita Tarifária",{"$f":"('08. RECEITA E DEMANDA'!C14)*C8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!D14)*D8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!E14)*E8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!F14)*F8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!G14)*G8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!H14)*H8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!I14)*I8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!J14)*J8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!K14)*K8","v":0.70544329624862956},{"$f":"('08. RECEITA E DEMANDA'!L14)*L8","v":0.70544329624862956},null,{"$f":"SUM(C14:L14)","v":7.0544329624862971},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D14:L14)+'02. FCL'!C14","v":5.0378800636335406}]
[]
[null,"Opex",{"$f":"-(C18+C19)*C$8","v":-0.60211737048100444},{"$f":"-(D18+D19)*D$8","v":-0.60211737048100444},-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,null,{"$f":"SUM(C16:L16)","v":-6.0211737048100451},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D16:L16)+'02. FCL'!C16","v":-4.2999842975963283}]
[]
[null,"Custos Variaveis",{"$f":"('06. OPEX'!C10)*C$8","v":0.46080302618468},{"$f":"('06. OPEX'!D10)*D$8","v":0.46080302618468},{"$f":"('06. OPEX'!E10)*E$8","v":0.46080302618468},{"$f":"('06. OPEX'!F10)*F$8","v":0.46080302618468},{"$f":"('06. OPEX'!G10)*G$8","v":0.46080302618468},{"$f":"('06. OPEX'!H10)*H$8","v":0.46080302618468},{"$f":"('06. OPEX'!I10)*I$8","v":0.46080302618468},{"$f":"('06. OPEX'!J10)*J$8","v":0.46080302618468},{"$f":"('06. OPEX'!K10)*K$8","v":0.46080302618468},{"$f":"('06. OPEX'!L10)*L$8","v":0.46080302618468},null,{"$f":"SUM(C18:L18)","v":4.6080302618467996},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D18:L18)+'02. FCL'!C18","v":3.2907965689415444}]
[null,"Custos Fixos",{"$f":"('06. OPEX'!C67)*C$8","v":0.14131434429632447},{"$f":"('06. OPEX'!D67)*D$8","v":0.14131434429632447},{"$f":"('06. OPEX'!E67)*E$8","v":0.14131434429632447},{"$f":"('06. OPEX'!F67)*F$8","v":0.14131434429632447},{"$f":"('06. OPEX'!G67)*G$8","v":0.14131434429632447},{"$f":"('06. OPEX'!H67)*H$8","v":0.14131434429632447},{"$f":"('06. OPEX'!I67)*I$8","v":0.14131434429632447},{"$f":"('06. OPEX'!J67)*J$8","v":0.14131434429632447},{"$f":"('06. OPEX'!K67)*K$8","v":0.14131434429632447},{"$f":"('06. OPEX'!L67)*L$8","v":0.14131434429632447},null,{"$f":"SUM(C19:L19)","v":1.4131434429632448},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D19:L19)+'02. FCL'!C19","v":1.0091877286547852}]
[]
[null,"Capex",{"$f":"-(C23+C24)*C$8","v":-0.50837100000000002},{"$f":"-(D23+D24)*D$8","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C21:L21)","v":-0.50837100000000002},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D21:L21)+'02. FCL'!C21","v":-0.50837100000000002}]
[]
[null,"Compra de Frota",{"$f":"('05. CAPEX'!D87)*C8","v":0.50837100000000002},{"$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.50837100000000002},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D23:L23)+'02. FCL'!C23","v":0.50837100000000002}]
[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.1163298887458885E-2},{"$f":"-(D28+D29+D30+D31)*D$8","v":-2.1163298887458885E-2},-2.1163298887458885E-2,-2.1163298887458885E-2,-4.0718004084938433E-2,-4.0718004084938433E-2,-4.0718004084938433E-2,-4.0718004084938433E-2,-4.8892155351092148E-2,-4.9098592026715383E-2,null,{"$f":"SUM(C26:L26)","v":-0.34551595926739681},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D26:L26)+'02. FCL'!C26","v":-0.2295430800976449}]
[]
[null,"ISS",{"$f":"'07. (a)TRIBUTOS LREAL'!C16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!D16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!E16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!F16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!G16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!H16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!I16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!J16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!K16","v":2.1163298887458885E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!L16","v":2.1163298887458885E-2},null,{"$f":"SUM(C28:L28)","v":0.21163298887458884},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D28:L28)+'02. FCL'!C28","v":0.15113640190900623}]
[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":1.9554705197479549E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!H125=\"Real\",'07. (a)TRIBUTOS LREAL'!H76,'07. (b)TRIBUTOS LPRESUMID'!H34)","v":1.9554705197479549E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!I125=\"Real\",'07. (a)TRIBUTOS LREAL'!I76,'07. (b)TRIBUTOS LPRESUMID'!I34)","v":1.9554705197479549E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!J125=\"Real\",'07. (a)TRIBUTOS LREAL'!J76,'07. (b)TRIBUTOS LPRESUMID'!J34)","v":1.9554705197479549E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!K125=\"Real\",'07. (a)TRIBUTOS LREAL'!K76,'07. (b)TRIBUTOS LPRESUMID'!K34)","v":2.7728856463633263E-2},{"$f":"IF('07. (a)TRIBUTOS LREAL'!L125=\"Real\",'07. (a)TRIBUTOS LREAL'!L76,'07. (b)TRIBUTOS LPRESUMID'!L34)","v":2.7935293139256499E-2},null,{"$f":"SUM(C31:L31)","v":0.13388297039280797},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D31:L31)+'02. FCL'!C31","v":7.8406678188638682E-2}]
[]
[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.42620837311983378},8.2162626880166234E-2,8.2162626880166234E-2,8.2162626880166234E-2,6.2607921682686682E-2,6.2607921682686682E-2,6.2607921682686682E-2,6.2607921682686682E-2,5.4433770416532967E-2,5.4227333740909732E-2,null,{"$f":"SUM(C37:L37)","v":0.17937229840885435},null,{"$f":"NPV('01. PC'!$C$10,'02. FCL'!D37:L37)+'02. FCL'!C37","v":-1.8314060433843871E-5}]
[]
[null,"FCL Acumulado",{"$f":"C37","v":-0.42620837311983378},{"$f":"(C39+D37)*D8","v":-0.34404574623966755},-0.26188311935950132,-0.17972049247933508,-0.1171125707966484,-5.4504649113961717E-2,8.1032725687249646E-3,7.0711194251411646E-2,0.12514496466794461,0.17937229840885435]
[]
[null,"TIR de Projeto (% ao ano)",{"$f":"IRR(C37:L37)","v":8.4101733169426263E-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":"Básico"},{"$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.50837100000000002},{"$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.50837100000000002}]
[]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"('05. CAPEX'!D86)*C$11","v":0.50837100000000002},{"$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.50837100000000002}]
[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.50837100000000002},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.50837100000000002}]
[]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"SUM(C23:C32)","v":0.50837100000000002},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.50837100000000002}]
[null,1,{"$f":"C$17","v":0.50837100000000002},null,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.50837100000000002}]
[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.12709275},0.12709275,0.12709275,0.12709275,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.50837100000000002}]
[]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"SUM(C50:C59)","v":0.12709275},0.12709275,0.12709275,0.12709275,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.50837100000000002}]
[null,1,{"$f":"$AC50*(1/$AD50)*C$11","v":0.12709275},{"$f":"IFERROR(IF(SUM($C50:C50)<$AC50,$AC50*(1/$AD50),0),0)*D$11","v":0.12709275},{"$f":"IFERROR(IF(SUM($C50:D50)<$AC50,$AC50*(1/$AD50),0),0)*E$11","v":0.12709275},{"$f":"IFERROR(IF(SUM($C50:E50)<$AC50,$AC50*(1/$AD50),0),0)*F$11","v":0.12709275},{"$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.50837100000000002},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.12104071428571428},0.11527687074829931,0.10978749595076125,0.10455951995310594,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.45066460093788074}]
[]
[null,1,{"$f":"(C50+C62)/C98","v":0.12104071428571428},0.11527687074829931,0.10978749595076125,0.10455951995310594,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.45066460093788074}]
[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":-6.0520357142857251E-3},-1.1815879251700689E-2,-1.7305254049238758E-2,-2.2533230046894059E-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":-5.7706399062119232E-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.60211737048100444},{"$f":"-(D13+D14)*D$8","v":-0.60211737048100444},-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,-0.60211737048100444,null,{"$f":"SUM(C12:L12)","v":-6.0211737048100451}]
[null,"Custos Variaveis",{"$f":"'06. OPEX'!C10","v":0.46080302618468},{"$f":"'06. OPEX'!D10","v":0.46080302618468},{"$f":"'06. OPEX'!E10","v":0.46080302618468},{"$f":"'06. OPEX'!F10","v":0.46080302618468},{"$f":"'06. OPEX'!G10","v":0.46080302618468},{"$f":"'06. OPEX'!H10","v":0.46080302618468},{"$f":"'06. OPEX'!I10","v":0.46080302618468},{"$f":"'06. OPEX'!J10","v":0.46080302618468},{"$f":"'06. OPEX'!K10","v":0.46080302618468},{"$f":"'06. OPEX'!L10","v":0.46080302618468},null,{"$f":"SUM(C13:L13)","v":4.6080302618467996}]
[null,"Custos Fixos",{"$f":"'06. OPEX'!C67","v":0.14131434429632447},{"$f":"'06. OPEX'!D67","v":0.14131434429632447},{"$f":"'06. OPEX'!E67","v":0.14131434429632447},{"$f":"'06. OPEX'!F67","v":0.14131434429632447},{"$f":"'06. OPEX'!G67","v":0.14131434429632447},{"$f":"'06. OPEX'!H67","v":0.14131434429632447},{"$f":"'06. OPEX'!I67","v":0.14131434429632447},{"$f":"'06. OPEX'!J67","v":0.14131434429632447},{"$f":"'06. OPEX'!K67","v":0.14131434429632447},{"$f":"'06. OPEX'!L67","v":0.14131434429632447},null,{"$f":"SUM(C14:L14)","v":1.4131434429632448}]
[]
[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":[[6,1,6,27],[7,1,7,2],[8,1,8,2],[9,1,9,2],[11,1,11,27],[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],[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]]}
[]
[]
[]
[]
[]
[]
[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":"Básico"},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":"Básico"},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":"Básico"},1,{"$f":"IF(Prazo<D$21,0,IF(D14=\"\",0,$AF$22))","v":508371},508371,508371,508371,508371,508371,508371,508371,508371,508371,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"'01. PC'!C24","v":"Básico"},508371]
[null,"TOTAL",null,{"$f":"SUM(D22:D22)","v":508371},508371,508371,508371,508371,508371,508371,508371,508371,508371,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":"Básico"},1,{"$f":"IF($B27='01. PC'!$C$24,IFERROR(D22*(1-VLOOKUP(D14,$AE$30:$AG$45,3,0)),0))","v":508371},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(E22*(1-VLOOKUP(E14,$AE$30:$AG$45,3,0)),0))","v":437961.6165},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(F22*(1-VLOOKUP(F14,$AE$30:$AG$45,3,0)),0))","v":373449.33660000004},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(G22*(1-VLOOKUP(G14,$AE$30:$AG$45,3,0)),0))","v":314783.32319999998},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(H22*(1-VLOOKUP(H14,$AE$30:$AG$45,3,0)),0))","v":262014.41339999999},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(I22*(1-VLOOKUP(I14,$AE$30:$AG$45,3,0)),0))","v":215091.77010000002},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(J22*(1-VLOOKUP(J14,$AE$30:$AG$45,3,0)),0))","v":174015.39330000003},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(K22*(1-VLOOKUP(K14,$AE$30:$AG$45,3,0)),0))","v":138836.12010000006},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(L22*(1-VLOOKUP(L14,$AE$30:$AG$45,3,0)),0))","v":109503.11340000007},{"$f":"IF($B27='01. PC'!$C$24,IFERROR(M22*(1-VLOOKUP(M14,$AE$30:$AG$45,3,0)),0))","v":86016.37320000006},{"$f":"IF($B27=\"BÁSICO\",IFERROR(N22*(1-VLOOKUP(N14,$AE$30:$AG$45,3,0)),0))","v":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,"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":508371},437961.6165,373449.33660000004,314783.32319999998,262014.41339999999,215091.77010000002,174015.39330000003,138836.12010000006,109503.11340000007,86016.37320000006,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":"Básico"},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":"Básico"},1,{"$f":"IFERROR(D27*(1-VLOOKUP((D50),$AE$56:$AG$73,3,0)),0)","v":381278.25},218980.80825,93362.33415000001,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":381278.25},218980.80825,93362.33415000001,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":"Básico"},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":"Básico"},1,{"$f":"IF(D78=1,D27,0)","v":508371},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":508371},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":"Básico"},null,{"$f":"SUM(D83:D83)/10^6*(1+$AE$86)","v":0.50837100000000002},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.50837100000000002},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":"Básico"},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":"Básico"},1,{"$f":"IF(D91=1,C27,0)","v":0},0,0,0,0,0,0,0,0,109503.11340000007,0,0,0,0,0,0,0,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,109503.11340000007,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":"Básico"},1,0,{"$f":"IF(E96-D55>0,0.34*(E96-D55),0)","v":0},0,0,0,0,0,0,0,37231.058556000025,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,37231.058556000025,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":"Básico"},1,0,{"$f":"E96-E101","v":0},0,0,0,0,0,0,0,72272.054844000057,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,72272.054844000057,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,7.2272054844000053E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"06. OPEX","index":6,"n_rows":210,"n_cols":16,"rows_kept":210,"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+C29+C40+C34+C45+C51+C56+C62)*'03. D&A Fiscal'!C11","v":0.46080302618468},{"$f":"(D19+D25+D29+D40+D34+D45+D51+D56+D62)*'03. D&A Fiscal'!D11","v":0.46080302618468},{"$f":"(E19+E25+E29+E40+E34+E45+E51+E56+E62)*'03. D&A Fiscal'!E11","v":0.46080302618468},{"$f":"(F19+F25+F29+F40+F34+F45+F51+F56+F62)*'03. D&A Fiscal'!F11","v":0.46080302618468},{"$f":"(G19+G25+G29+G40+G34+G45+G51+G56+G62)*'03. D&A Fiscal'!G11","v":0.46080302618468},{"$f":"(H19+H25+H29+H40+H34+H45+H51+H56+H62)*'03. D&A Fiscal'!H11","v":0.46080302618468},{"$f":"(I19+I25+I29+I40+I34+I45+I51+I56+I62)*'03. D&A Fiscal'!I11","v":0.46080302618468},{"$f":"(J19+J25+J29+J40+J34+J45+J51+J56+J62)*'03. D&A Fiscal'!J11","v":0.46080302618468},{"$f":"(K19+K25+K29+K40+K34+K45+K51+K56+K62)*'03. D&A Fiscal'!K11","v":0.46080302618468},{"$f":"(L19+L25+L29+L40+L34+L45+L51+L56+L62)*'03. D&A Fiscal'!L11","v":0.46080302618468},null,{"$f":"SUM(C10:L10)","v":4.6080302618467996}]
[]
[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":"Básico"},{"$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":"Básico"},{"$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$157:$L$178,1+C$8,0))/10^6*(1+$P$19)","v":0.14953001700000002},0.14953001700000002,0.14953001700000002,0.14953001700000002,0.14953001700000002,0.14953001700000002,0.14953001700000002,0.14953001700000002,0.14953001700000002,0.14953001700000002,null,{"$f":"SUM(C19:L19)","v":1.4953001700000002},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C16*C21*C22*C23","v":149530.01700000002},149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,null,{"$f":"SUM(C20:L20)","v":1495300.1700000002}]
[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.39,{"$f":"C23","v":0.39},0.39,0.39,0.39,0.39,0.39,0.39,0.39,0.39]
[]
[null,"Lubrificante Diesel",{"$f":"(C26)*(1+VLOOKUP($B25,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$25)","v":9.7194511050000022E-3},9.7194511050000022E-3,9.7194511050000022E-3,9.7194511050000022E-3,9.7194511050000022E-3,9.7194511050000022E-3,9.7194511050000022E-3,9.7194511050000022E-3,9.7194511050000022E-3,9.7194511050000022E-3,null,{"$f":"SUM(C25:L25)","v":9.7194511050000001E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C20*C27","v":9719.4511050000019},9719.4511050000019,9719.4511050000019,9719.4511050000019,9719.4511050000019,9719.4511050000019,9719.4511050000019,9719.4511050000019,9719.4511050000019,9719.4511050000019,null,{"$f":"SUM(C26:L26)","v":97194.511050000016}]
[null,"Percentual",6.5000000000000002E-2,{"$f":"C27","v":6.5000000000000002E-2},{"$f":"D27","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":"(C32)*(1+VLOOKUP($B29,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$29)","v":2E-8},2E-8,2E-8,2E-8,2E-8,2E-8,2E-8,2E-8,2E-8,2E-8,null,{"$f":"SUM(C29:L29)","v":1.9999999999999996E-7},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C31*C32","v":2990.6003400000004},{"$f":"D31*D32","v":2990.6003400000004},2990.6003400000004,2990.6003400000004,2990.6003400000004,2990.6003400000004,2990.6003400000004,2990.6003400000004,2990.6003400000004,2990.6003400000004,null,{"$f":"SUM(C30:L30)","v":29906.003400000005}]
[null,"Combustível",{"$f":"C20","v":149530.01700000002},{"$f":"D20","v":149530.01700000002},149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002,149530.01700000002]
[null,"Percentual",0.02,{"$f":"C32","v":0.02},{"$f":"D32","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
[null,"Rodagem",{"$f":"(C35)*(1+VLOOKUP($B34,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$34)","v":1.5023424E-2},1.5023424E-2,1.5023424E-2,1.5023424E-2,1.5023424E-2,1.5023424E-2,1.5023424E-2,1.5023424E-2,1.5023424E-2,1.5023424E-2,null,{"$f":"SUM(C34:L34)","v":0.15023424000000005},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C36*C37/C38","v":15023.424000000001},{"$f":"D36*D37/D38","v":15023.424000000001},15023.424000000001,15023.424000000001,15023.424000000001,15023.424000000001,15023.424000000001,15023.424000000001,15023.424000000001,15023.424000000001,null,{"$f":"SUM(C35:L35)","v":150234.24000000002}]
[null,"Quantidade Km total",{"$f":"C16*C21","v":78247},78247,78247,78247,78247,78247,78247,78247,78247,78247]
[null,"Preço Jogo e Recaps",24000,{"$f":"C37","v":24000},{"$f":"D37","v":24000},24000,24000,24000,24000,24000,24000,24000]
[null,"Km Duração jogo Pneus e Recaps",125000,{"$f":"C38","v":125000},{"$f":"D38","v":125000},125000,125000,125000,125000,125000,125000,125000]
[]
[null,"Peças e Materiais de Manutenção",{"$f":"(C41)*(1+VLOOKUP($B40,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$40)","v":4.066968E-2},4.066968E-2,4.066968E-2,4.066968E-2,4.066968E-2,4.066968E-2,4.066968E-2,4.066968E-2,4.066968E-2,4.066968E-2,null,{"$f":"SUM(C40:L40)","v":0.40669679999999991},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C13*C42*C43","v":40669.68},40669.68,40669.68,40669.68,40669.68,40669.68,40669.68,40669.68,40669.68,40669.68,null,{"$f":"SUM(C41:L41)","v":406696.8}]
[null,"Preço Unitário",{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371},{"$f":"'05. CAPEX'!$AF$22","v":508371}]
[null,"Porcent. Do Preço Ônibus Novo",0.08,{"$f":"C43","v":0.08},{"$f":"D43","v":0.08},0.08,0.08,0.08,0.08,0.08,0.08,0.08]
[]
[null,"Motoristas - Direção",{"$f":"(C46)*(1+VLOOKUP($B45,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$45)","v":0.12223628296320002},0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,0.12223628296320002,null,{"$f":"SUM(C45:L45)","v":1.2223628296320002},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C16*C47*C48*(1+C49)","v":122236.28296320002},122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,122236.28296320002,null,{"$f":"SUM(C46:L46)","v":1222362.8296320003}]
[null,"Salário anual",{"$f":"1964.2*12","v":23570.400000000001},{"$f":"C47","v":23570.400000000001},{"$f":"D47","v":23570.400000000001},23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001]
[null,"Empregados Equiv/ Carro",3.1621999999999999,{"$f":"C48","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":"C49","v":0.64},{"$f":"D49","v":0.64},{"$f":"E49","v":0.64},{"$f":"F49","v":0.64},{"$f":"G49","v":0.64},{"$f":"H49","v":0.64},{"$f":"I49","v":0.64},{"$f":"J49","v":0.64},{"$f":"K49","v":0.64}]
[]
[null,"Motoristas - Cobrança",{"$f":"(C52)*(1+VLOOKUP($B51,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$51)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C51:L51)","v":0},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C16*C53*C54","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C52:L52)","v":0}]
[null,"Fator de Utilização",0,{"$f":"C53","v":0},{"$f":"D53","v":0},0,0,0,0,0,0,0]
[null,"Salários e Encargos",0,{"$f":"C54","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Cobradores",{"$f":"(C57)*(1+VLOOKUP($B56,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$56)","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(C56:L56)","v":0.7322415111648003},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C16*C58*C59*(1+C60)","v":73224.151116480018},73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,73224.151116480018,null,{"$f":"SUM(C57:L57)","v":732241.51116480015}]
[null,"Fator de Utilização (equivalente)",{"$f":"C48","v":3.1621999999999999},{"$f":"C58","v":3.1621999999999999},{"$f":"D58","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":"C59","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":"C60","v":0.64},0.64,0.64,0.64,0.64,0.64,0.64,0.64,0.64]
[]
[null,"Benefícios Trabalhistas",{"$f":"(C63)*(1+VLOOKUP($B62,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$62)","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(C62:L62)","v":0.504},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,{"$f":"'01. PC'!$C$24","v":"Básico"},{"$f":"C16*C64*C65","v":50400},50400,50400,50400,50400,50400,50400,50400,50400,50400,null,{"$f":"SUM(C63:L63)","v":504000}]
[null,"Fator de Utilização",6,{"$f":"C64","v":6},{"$f":"D64","v":6},6,6,6,6,6,6,6]
[null,"Benefício Anual",8400,{"$f":"C65","v":8400},8400,8400,8400,8400,8400,8400,8400,8400]
[]
[null,"Custo Fixo",{"$f":"(C69+C73+C77+C82+C86+C91+C95+C100+C105+C110+C115+C123+C119)*'03. D&A Fiscal'!C11","v":0.14131434429632447},{"$f":"(D69+D73+D77+D82+D86+D91+D95+D100+D105+D110+D115+D123+D119)*'03. D&A Fiscal'!D11","v":0.14131434429632447},{"$f":"(E69+E73+E77+E82+E86+E91+E95+E100+E105+E110+E115+E123+E119)*'03. D&A Fiscal'!E11","v":0.14131434429632447},{"$f":"(F69+F73+F77+F82+F86+F91+F95+F100+F105+F110+F115+F123+F119)*'03. D&A Fiscal'!F11","v":0.14131434429632447},{"$f":"(G69+G73+G77+G82+G86+G91+G95+G100+G105+G110+G115+G123+G119)*'03. D&A Fiscal'!G11","v":0.14131434429632447},{"$f":"(H69+H73+H77+H82+H86+H91+H95+H100+H105+H110+H115+H123+H119)*'03. D&A Fiscal'!H11","v":0.14131434429632447},{"$f":"(I69+I73+I77+I82+I86+I91+I95+I100+I105+I110+I115+I123+I119)*'03. D&A Fiscal'!I11","v":0.14131434429632447},{"$f":"(J69+J73+J77+J82+J86+J91+J95+J100+J105+J110+J115+J123+J119)*'03. D&A Fiscal'!J11","v":0.14131434429632447},{"$f":"(K69+K73+K77+K82+K86+K91+K95+K100+K105+K110+K115+K123+K119)*'03. D&A Fiscal'!K11","v":0.14131434429632447},{"$f":"(L69+L73+L77+L82+L86+L91+L95+L100+L105+L110+L115+L123+L119)*'03. D&A Fiscal'!L11","v":0.14131434429632447},null,{"$f":"SUM(C67:L67)","v":1.4131434429632448}]
[]
[null,"Operação da Frota Auxiliar (Serviços)",{"$f":"(C70*C71)*(1+VLOOKUP($B69,$B$157:$L$178,1+C$8,0))*(1+$P$69)","v":7.9436039627924851E-3},7.9436039627924834E-3,7.9436039627924834E-3,7.9436039627924834E-3,7.9436039627924834E-3,7.9436039627924834E-3,7.9436039627924834E-3,7.9436039627924834E-3,7.9436039627924834E-3,7.9436039627924834E-3,null,{"$f":"SUM(C69:L69)","v":7.9436039627924837E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem",1.4999999999999999E-2,{"$f":"C70","v":1.4999999999999999E-2},{"$f":"D70","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(C86,C91,C62,C56,C51,C45,C40,C34,C29,C25,C19)","v":0.52957359751949906},{"$f":"D10+D86+D91","v":0.52957359751949895},0.52957359751949895,0.52957359751949895,0.52957359751949895,0.52957359751949895,0.52957359751949895,0.52957359751949895,0.52957359751949895,0.52957359751949895]
[]
[null,"Operac. e Manut. Infra Garagem",{"$f":"(C74*C75*C12)*(1+VLOOKUP($B73,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$73)","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(C73:L73)","v":2.0468000000000004E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem",4.3E-3,{"$f":"C74","v":4.3E-3},{"$f":"D74","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":"C75","v":476000},476000,476000,476000,476000,476000,476000,476000,476000]
[]
[null,"Operação de ITS",{"$f":"(C78*C79*C80)*(1+VLOOKUP($B77,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$77)","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(C77:L77)","v":6.1879999999999998E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem anual",1.2999999999999999E-2,{"$f":"C78","v":1.2999999999999999E-2},{"$f":"D78","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":"C79","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":"(C83*C84)*(1+VLOOKUP($B82,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$82)","v":1.7636082406215742E-2},1.7636082406215742E-2,1.7636082406215742E-2,1.7636082406215742E-2,1.7636082406215742E-2,1.7636082406215742E-2,1.7636082406215742E-2,1.7636082406215742E-2,1.7636082406215742E-2,1.7636082406215742E-2,null,{"$f":"SUM(C82:L82)","v":0.17636082406215745},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentagem",2.5000000000000001E-2,{"$f":"C83","v":2.5000000000000001E-2},{"$f":"D83","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":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!D14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!E14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!F14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!G14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!H14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!I14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!J14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!K14*10^6","v":705443.29624862957},{"$f":"'08. RECEITA E DEMANDA'!L14*10^6","v":705443.29624862957}]
[]
[null,"Fiscalização",{"$f":"(C87*C88*C16)*(1+C89)/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(C86:L86)","v":7.7310911999999996E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Salário Anual",{"$f":"1964.2*12","v":23570.400000000001},{"$f":"C87","v":23570.400000000001},{"$f":"D87","v":23570.400000000001},23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001,23570.400000000001]
[null,"Empregados por ônibus",0.2,{"$f":"C88","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":"C89","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":"(C92*C93)*(1+VLOOKUP($B91,$B$157:$L$178,1+C$8,0))*(1+$P$91)","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(C91:L91)","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":"C45+C51+C56+C62+C86","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":"(C96*C97*C98)*(1+VLOOKUP($B95,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$95)","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(C95:L95)","v":0.19040000000000001},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0.04,{"$f":"C96","v":0.04},{"$f":"D96","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":"C97","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":"(C101*C102*C103)*(1+VLOOKUP($B100,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$100)","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(C100:L100)","v":9.5200000000000007E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0.02,{"$f":"C101","v":0.02},{"$f":"D101","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":"C102","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":"(C106*C107*C108)*(1+VLOOKUP($B105,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$105)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C105:L105)","v":0},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0,{"$f":"C106","v":0},{"$f":"D106","v":0},0,0,0,0,0,0,0]
[null,"Valor ônibus básico",{"$f":"C42","v":508371},{"$f":"C107","v":508371},508371,508371,508371,508371,508371,508371,508371,508371]
[null,"Número Ônibus",{"$f":"C12","v":1},1,1,1,1,1,1,1,1,1]
[]
[null,"Despesas Ambientais",{"$f":"(C111*C112*C113)*(1+VLOOKUP($B110,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$110)","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(C110:L110)","v":4.7600000000000003E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentual Preço ônibus",0.01,{"$f":"C111","v":0.01},{"$f":"D111","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":"C112","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":"(C116*C117)*(1+VLOOKUP($B115,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$115)","v":1.4108865924972592E-3},1.4108865924972592E-3,1.4108865924972592E-3,1.4108865924972592E-3,1.4108865924972592E-3,1.4108865924972592E-3,1.4108865924972592E-3,1.4108865924972592E-3,1.4108865924972592E-3,1.4108865924972592E-3,null,{"$f":"SUM(C115:L115)","v":1.4108865924972595E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Valor Unitário (R$)",2E-3,{"$f":"C116","v":2E-3},{"$f":"D116","v":2E-3},2E-3,2E-3,2E-3,2E-3,2E-3,2E-3,2E-3]
[null,"Receita Eletrônica Aprox",{"$f":"C84","v":705443.29624862957},{"$f":"D84","v":705443.29624862957},705443.29624862957,705443.29624862957,705443.29624862957,705443.29624862957,705443.29624862957,705443.29624862957,705443.29624862957,705443.29624862957]
[]
[null,"Manutenção Infra Elétrica",{"$f":"(C120*C121)*(1+VLOOKUP($B119,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$119)*'02. FCL'!C8","v":0},{"$f":"(D120*D121)*(1+VLOOKUP($B119,$B$157:$L$178,1+D$8,0))/10^6*(1+$P$119)*'02. FCL'!D8","v":0},{"$f":"(E120*E121)*(1+VLOOKUP($B119,$B$157:$L$178,1+E$8,0))/10^6*(1+$P$119)*'02. FCL'!E8","v":0},{"$f":"(F120*F121)*(1+VLOOKUP($B119,$B$157:$L$178,1+F$8,0))/10^6*(1+$P$119)*'02. FCL'!F8","v":0},{"$f":"(G120*G121)*(1+VLOOKUP($B119,$B$157:$L$178,1+G$8,0))/10^6*(1+$P$119)*'02. FCL'!G8","v":0},{"$f":"(H120*H121)*(1+VLOOKUP($B119,$B$157:$L$178,1+H$8,0))/10^6*(1+$P$119)*'02. FCL'!H8","v":0},{"$f":"(I120*I121)*(1+VLOOKUP($B119,$B$157:$L$178,1+I$8,0))/10^6*(1+$P$119)*'02. FCL'!I8","v":0},{"$f":"(J120*J121)*(1+VLOOKUP($B119,$B$157:$L$178,1+J$8,0))/10^6*(1+$P$119)*'02. FCL'!J8","v":0},{"$f":"(K120*K121)*(1+VLOOKUP($B119,$B$157:$L$178,1+K$8,0))/10^6*(1+$P$119)*'02. FCL'!K8","v":0},{"$f":"(L120*L121)*(1+VLOOKUP($B119,$B$157:$L$178,1+L$8,0))/10^6*(1+$P$119)*'02. FCL'!L8","v":0},null,{"$f":"SUM(C119:L119)","v":0},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Percentual",0.01,{"$f":"C120","v":0.01},{"$f":"D120","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":"C121","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Seguro e Licenciamento",{"$f":"(C124*C125*C126)*(1+VLOOKUP($B123,$B$157:$L$178,1+C$8,0))/10^6*(1+$P$123)","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(C123:L123)","v":3.9983999999999999E-2},null,{"$f":"'09. SENSIBILIDADE'!$C$8","v":0}]
[null,"Porcentual ônibus básico",8.3999999999999995E-3,{"$f":"C124","v":8.3999999999999995E-3},{"$f":"D124","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":"C125","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+C67","v":0.60211737048100444},0.60211737048100444,0.60211737048100444,0.60211737048100444,0.60211737048100444,0.60211737048100444,0.60211737048100444,0.60211737048100444,0.60211737048100444,0.60211737048100444,null,{"$f":"SUM(C128:L128)","v":6.0211737048100451}]
[]
[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":"C183/C$210-1","v":0},{"$f":"D183/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Lubrificante Diesel",0,{"$f":"D184/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Arla 32",0,{"$f":"D185/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Rodagem",0,{"$f":"D186/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Peças e Materiais de Manutenção",0,{"$f":"D187/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Motoristas - Direção",0,{"$f":"D188/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Motoristas - Cobrança",0,{"$f":"D189/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Cobradores",0,{"$f":"D190/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Benefícios Trabalhistas",0,{"$f":"D191/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Operação da Frota Auxiliar (Serviços)",0,{"$f":"D192/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Operac. e Manut. Infra Garagem",0,{"$f":"D193/D$210-1","v":0},0,0,0,0,0,0,0,0]
[null,"Operação de ITS",0,{"$f":"D194/D$210-1","v":0},0,0,0,{"$f":"H194/H$210-1","v":0},0,0,0,0]
[null,"Operação de Bilhetagem",0,0,0,0,0,{"$f":"H195/H$210-1","v":0},0,0,0,0]
[null,"Fiscalização",0,0,0,0,0,{"$f":"H196/H$210-1","v":0},0,0,0,0]
[null,"Mão de Obra Manutenção, Adm. e Diretoria",0,0,0,0,0,{"$f":"H197/H$210-1","v":0},0,0,0,0]
[null,"Despesas Administrativas Gerais",0,0,0,0,0,{"$f":"H198/H$210-1","v":0},0,0,0,0]
[null,"Locação de Infraestrutura Garagem",0,0,0,0,0,{"$f":"H199/H$210-1","v":0},0,0,0,0]
[null,"Manutenção de Infraestrutura",0,0,0,0,0,{"$f":"H200/H$210-1","v":0},0,0,0,0]
[null,"Despesas Ambientais",0,0,0,0,0,{"$f":"H201/H$210-1","v":0},0,0,0,0]
[null,"Garantias Contratuais",0,0,0,0,0,{"$f":"H202/H$210-1","v":0},0,0,0,0]
[null,"Manutenção Infra Elétrica",0,0,0,0,0,{"$f":"H203/H$210-1","v":0},0,0,0,0]
[null,"Seguro e Licenciamento",0,0,0,0,0,{"$f":"H204/H$210-1","v":0},0,0,0,0]
[null,"Reposição de baterias",0,0,0,0,0,{"$f":"H205/H$210-1","v":0},0,0,0,0]
[null,"Operação ITS/SBE Embarcado",0,{"$f":"D206/D$210-1","v":0},0,0,0,0,0,0,0,0]
[]
[null,"Índices acumulados"]
[null,"Combustível",1,{"$f":"(C183)*(1+D131)","v":1.0392000000000001},1.0729740000000001,1.1062361940000001,1.1395339034394001,1.1737199205425821,1.2089315181588596,1.2451994637036254,1.2825554476147343,1.3210321110431764]
[null,"Lubrificante Diesel",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,"Arla 32",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,"Rodagem",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,"Peças e Materiais de Manutenção",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,"Motoristas - Direçã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 - Cobrança",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,"Cobradores",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,"Benefícios Trabalhistas",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,"Operação da Frota Auxiliar (Serviços)",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,"Operac. e Manut. Infra Garagem",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,"Operação de ITS",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 Bilhetagem",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,"Fiscalização",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,"Mão de Obra Manutenção, Adm. e Diretoria",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,"Despesas Administrativas Gerais",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,"Locação de Infraestrutura Garagem",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,"Manutenção de Infraestrutura",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,"Despesas Ambientais",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,"Garantias Contratuais",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,"Manutenção Infra Elétrica",1,{"$f":"(C203)*(1+D151)","v":1.0392000000000001},{"$f":"(D203)*(1+E151)","v":1.0729740000000001},{"$f":"(E203)*(1+F151)","v":1.1062361940000001},{"$f":"(F203)*(1+G151)","v":1.1395339034394001},{"$f":"(G203)*(1+H151)","v":1.1737199205425821},{"$f":"(H203)*(1+I151)","v":1.2089315181588596},{"$f":"(I203)*(1+J151)","v":1.2451994637036254},{"$f":"(J203)*(1+K151)","v":1.2825554476147343},{"$f":"(K203)*(1+L151)","v":1.3210321110431764}]
[null,"Seguro e Licenciamento",1,{"$f":"(C204)*(1+D152)","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":"(C205)*(1+D153)","v":1.0392000000000001},{"$f":"(D205)*(1+E153)","v":1.0729740000000001},{"$f":"(E205)*(1+F153)","v":1.1062361940000001},{"$f":"(F205)*(1+G153)","v":1.1395339034394001},{"$f":"(G205)*(1+H153)","v":1.1737199205425821},{"$f":"(H205)*(1+I153)","v":1.2089315181588596},{"$f":"(I205)*(1+J153)","v":1.2451994637036254},{"$f":"(J205)*(1+K153)","v":1.2825554476147343},{"$f":"(K205)*(1+L153)","v":1.3210321110431764}]
[null,"Operação ITS/SBE Embarcado",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,"Í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":"(C210)*(1+D209)","v":1.0392000000000001},{"$f":"(D210)*(1+E209)","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.70544329624862956},{"$f":"D14","v":0.70544329624862956},0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,null,{"$f":"SUM(C12:L12)","v":7.0544329624862971}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C14:L14)","v":7.0544329624862971}]
[]
[null,"ISS",{"$f":"(C19)*$T$2","v":2.1163298887458885E-2},{"$f":"(D19)*$T$2","v":2.1163298887458885E-2},2.1163298887458885E-2,2.1163298887458885E-2,2.1163298887458885E-2,2.1163298887458885E-2,2.1163298887458885E-2,2.1163298887458885E-2,2.1163298887458885E-2,2.1163298887458885E-2,null,{"$f":"SUM(C16:L16)","v":0.21163298887458884}]
[]
[null,"Base de Incidência"]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C19:L19)","v":7.0544329624862971}]
[]
[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.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C24:L24)","v":7.0544329624862971}]
[]
[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.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C29:L29)","v":7.0544329624862971}]
[]
[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.60211737048100444},{"$f":"-'02. FCL'!D16","v":0.60211737048100444},{"$f":"-'02. FCL'!E16","v":0.60211737048100444},{"$f":"-'02. FCL'!F16","v":0.60211737048100444},{"$f":"-'02. FCL'!G16","v":0.60211737048100444},{"$f":"-'02. FCL'!H16","v":0.60211737048100444},{"$f":"-'02. FCL'!I16","v":0.60211737048100444},{"$f":"-'02. FCL'!J16","v":0.60211737048100444},{"$f":"-'02. FCL'!K16","v":0.60211737048100444},{"$f":"-'02. FCL'!L16","v":0.60211737048100444},null,{"$f":"SUM(C68:L68)","v":6.0211737048100451}]
[]
[null,"Depreciação Real",{"$f":"'03. D&A Fiscal'!C73","v":0.12104071428571428},{"$f":"'03. D&A Fiscal'!D73","v":0.11527687074829931},{"$f":"'03. D&A Fiscal'!E73","v":0.10978749595076125},{"$f":"'03. D&A Fiscal'!F73","v":0.10455951995310594},{"$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.45066460093788074}]
[]
[null,"LAIR",{"$f":"C12-C16-C21-C26-C66-C68-C70","v":-3.8878087405548101E-2},-3.3114243868133136E-2,-2.7624869070595068E-2,-2.2396893072939766E-2,8.2162626880166179E-2,8.2162626880166179E-2,8.2162626880166179E-2,8.2162626880166179E-2,8.2162626880166179E-2,8.2162626880166179E-2,null,{"$f":"SUM(C72:L72)","v":0.37096166786378099}]
[]
[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,1.9554705197479549E-2,1.9554705197479549E-2,1.9554705197479549E-2,1.9554705197479549E-2,2.7728856463633263E-2,2.7935293139256499E-2,null,{"$f":"SUM(C76:L76)","v":0.13388297039280797}]
[]
[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.23799999999999999,0.23799999999999999,0.23799999999999999,0.23799999999999999,0.33748746256708267,0.33999999999999997,null,{"$f":"SUM(C78:L78)","v":1.6294874625670825}]
[]
[null,"Criação de Crédito Tributário ",{"$f":"IF(C72<0,-C72*($R$2+$S$2),0)","v":1.3218549717886352E-2},1.1258842915165265E-2,9.3924554840023218E-3,7.6149436447995201E-3,0,0,0,0,0,0,null,{"$f":"SUM(C80:L80)","v":4.1484791761853462E-2}]
[]
[null,"Estoque de Crédito Tributário ",{"$f":"C84","v":1.3218549717886352E-2},{"$f":"C82/(1+D103)^1+D84-D99","v":2.3847937884580839E-2},3.2104777278841215E-2,3.8190922005600675E-2,2.7991718730223693E-2,1.8278191801293232E-2,9.0272137737404147E-3,2.1675850940439632E-4,0,0,null,{"$f":"SUM(C82:L82)","v":0.16287606970157079}]
[]
[null,"Crédito Tributário ",{"$f":"SUM(C86:C95)","v":1.3218549717886352E-2},1.1258842915165265E-2,9.3924554840023218E-3,7.6149436447995201E-3,0,0,0,0,0,0,null,{"$f":"SUM(C84:L84)","v":4.1484791761853462E-2}]
[]
[null,1,{"$f":"C$80","v":1.3218549717886352E-2},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C86:L86)","v":1.3218549717886352E-2}]
[null,2,null,{"$f":"D$80","v":1.1258842915165265E-2},null,null,null,null,null,null,null,null,null,1.1258842915165265E-2]
[null,3,null,null,{"$f":"E$80","v":9.3924554840023218E-3},null,null,null,null,null,null,null,null,9.3924554840023218E-3]
[null,4,null,null,null,{"$f":"F$80","v":7.6149436447995201E-3},null,null,null,null,null,null,null,7.6149436447995201E-3]
[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,8.3805879417769499E-3,8.3805879417769499E-3,8.3805879417769499E-3,8.3805879417769499E-3,8.3805879417769499E-3,8.3805879417769499E-3,null,{"$f":"SUM(C97:L97)","v":5.02835276506617E-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,8.3805879417769499E-3,8.3805879417769499E-3,8.3805879417769499E-3,8.3805879417769499E-3,2.0643667562323458E-4,0,null,{"$f":"SUM(C99:L99)","v":3.3728788442731035E-2}]
[]
[null,"Despesas Tributárias ",{"$f":"IF(C72>0,C72*($R$2+$S$2),0)","v":0},0,0,0,2.7935293139256499E-2,2.7935293139256499E-2,2.7935293139256499E-2,2.7935293139256499E-2,2.7935293139256499E-2,2.7935293139256499E-2,null,{"$f":"SUM(C101:L101)","v":0.167611758835539}]
[]
[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.70544329624862956},{"$f":"'02. FCL'!D12","v":0.70544329624862956},{"$f":"'02. FCL'!E12","v":0.70544329624862956},{"$f":"'02. FCL'!F12","v":0.70544329624862956},{"$f":"'02. FCL'!G12","v":0.70544329624862956},{"$f":"'02. FCL'!H12","v":0.70544329624862956},{"$f":"'02. FCL'!I12","v":0.70544329624862956},{"$f":"'02. FCL'!J12","v":0.70544329624862956},{"$f":"'02. FCL'!K12","v":0.70544329624862956},{"$f":"'02. FCL'!L12","v":0.70544329624862956},null,{"$f":"SUM(C109:L109)","v":7.0544329624862971}]
[]
[null,"Opex ",{"$f":"'02. FCL'!C16","v":-0.60211737048100444},{"$f":"'02. FCL'!D16","v":-0.60211737048100444},{"$f":"'02. FCL'!E16","v":-0.60211737048100444},{"$f":"'02. FCL'!F16","v":-0.60211737048100444},{"$f":"'02. FCL'!G16","v":-0.60211737048100444},{"$f":"'02. FCL'!H16","v":-0.60211737048100444},{"$f":"'02. FCL'!I16","v":-0.60211737048100444},{"$f":"'02. FCL'!J16","v":-0.60211737048100444},{"$f":"'02. FCL'!K16","v":-0.60211737048100444},{"$f":"'02. FCL'!L16","v":-0.60211737048100444},null,{"$f":"SUM(C111:L111)","v":-6.0211737048100451}]
[]
[null,"CAPEX",{"$f":"'02. FCL'!C21","v":-0.50837100000000002},{"$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.50837100000000002}]
[]
[null,"Impostos Total ",{"$f":"-(C16+C21+C26+C66+C76)","v":-2.1163298887458885E-2},-2.1163298887458885E-2,-2.1163298887458885E-2,-2.1163298887458885E-2,-4.0718004084938433E-2,-4.0718004084938433E-2,-4.0718004084938433E-2,-4.0718004084938433E-2,-4.8892155351092148E-2,-4.9098592026715383E-2,null,{"$f":"SUM(C115:L115)","v":-0.34551595926739681}]
[]
[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.42620837311983378},{"$f":"D109+D111+D113+D115+D117","v":8.2162626880166234E-2},8.2162626880166234E-2,8.2162626880166234E-2,6.2607921682686682E-2,6.2607921682686682E-2,6.2607921682686682E-2,6.2607921682686682E-2,5.4433770416532967E-2,5.4227333740909732E-2,null,{"$f":"SUM(C119:L119)","v":0.17937229840885435}]
[]
[null,"VPL - Ano 0 - Real ",{"$f":"C119","v":-0.42620837311983378},{"$f":"D119/((1+D127)*(1+C131))","v":6.9907716636257486E-2},6.4483784484210563E-2,5.9480679122188559E-2,4.1807701385047122E-2,3.8563965977046054E-2,3.5571902367506569E-2,3.2811984088892306E-2,2.6314615150489513E-2,2.418088868060982E-2,null,{"$f":"SUM(C121:L121)","v":-3.3085135227585771E-2}]
[]
[null,"VPL - Ano 0 - Presumido ",{"$f":"'07. (b)TRIBUTOS LPRESUMID'!C56","v":-0.50296060375168472},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!D56","v":4.6034123077484303E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!E56","v":4.2462472160169785E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!F56","v":3.9167935031982556E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!G56","v":3.6129011256877137E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!H56","v":3.332586855379811E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!I56","v":3.0740213369487802E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!J56","v":2.8355171493165492E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!K56","v":2.6155177933959205E-3},{"$f":"'07. (b)TRIBUTOS LPRESUMID'!L56","v":2.4125875342420515E-3},null,{"$f":"SUM(C123:L123)","v":-0.47231101892975025}]
[]
[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.70544329624862956},{"$f":"D14","v":0.70544329624862956},0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,null,{"$f":"SUM(C12:L12)","v":7.0544329624862971}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C14:L14)","v":7.0544329624862971}]
[]
[null,"ISS sobre Receitas",{"$f":"-(C18)*$T$2","v":-2.1163298887458885E-2},{"$f":"-(D18)*$T$2","v":-2.1163298887458885E-2},-2.1163298887458885E-2,-2.1163298887458885E-2,-2.1163298887458885E-2,-2.1163298887458885E-2,-2.1163298887458885E-2,-2.1163298887458885E-2,-2.1163298887458885E-2,-2.1163298887458885E-2,null,{"$f":"SUM(C16:L16)","v":-0.21163298887458884}]
[]
[null,"Receita Tarifária",{"$f":"'02. FCL'!C14","v":0.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C18:L18)","v":7.0544329624862971}]
[]
[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.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C22:L22)","v":7.0544329624862971}]
[]
[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.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C26:L26)","v":7.0544329624862971}]
[]
[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.70544329624862956},{"$f":"'02. FCL'!D14","v":0.70544329624862956},{"$f":"'02. FCL'!E14","v":0.70544329624862956},{"$f":"'02. FCL'!F14","v":0.70544329624862956},{"$f":"'02. FCL'!G14","v":0.70544329624862956},{"$f":"'02. FCL'!H14","v":0.70544329624862956},{"$f":"'02. FCL'!I14","v":0.70544329624862956},{"$f":"'02. FCL'!J14","v":0.70544329624862956},{"$f":"'02. FCL'!K14","v":0.70544329624862956},{"$f":"'02. FCL'!L14","v":0.70544329624862956},null,{"$f":"SUM(C30:L30)","v":7.0544329624862971}]
[]
[null,"LAIR Presumido",{"$f":"C12*$W$2","v":0.22574185479956146},0.22574185479956146,0.22574185479956146,0.22574185479956146,0.22574185479956146,0.22574185479956146,0.22574185479956146,0.22574185479956146,0.22574185479956146,0.22574185479956146,null,{"$f":"SUM(C32:L32)","v":2.257418547995615}]
[]
[null,"IRPJ/CSLL",{"$f":"-IF(C32<=0,C32*0%,C32*($R$2+$S$2))","v":-7.6752230631850896E-2},-7.6752230631850896E-2,-7.6752230631850896E-2,-7.6752230631850896E-2,-7.6752230631850896E-2,-7.6752230631850896E-2,-7.6752230631850896E-2,-7.6752230631850896E-2,-7.6752230631850896E-2,-7.6752230631850896E-2,null,{"$f":"SUM(C34:L34)","v":-0.76752230631850893}]
[]
[null,"Total de Impostos (R$ Mil)",{"$f":"C16+C20+C24+C28+C34","v":-9.7915529519309777E-2},-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,null,{"$f":"SUM(C36:L36)","v":-0.97915529519309796}]
[]
[]
[null,"Simulação VPL - Regime Lucro Presumido - R$ Milhões"]
[]
[]
[null,"Receita ",{"$f":"'02. FCL'!C12","v":0.70544329624862956},{"$f":"'02. FCL'!D12","v":0.70544329624862956},{"$f":"'02. FCL'!E12","v":0.70544329624862956},{"$f":"'02. FCL'!F12","v":0.70544329624862956},{"$f":"'02. FCL'!G12","v":0.70544329624862956},{"$f":"'02. FCL'!H12","v":0.70544329624862956},{"$f":"'02. FCL'!I12","v":0.70544329624862956},{"$f":"'02. FCL'!J12","v":0.70544329624862956},{"$f":"'02. FCL'!K12","v":0.70544329624862956},{"$f":"'02. FCL'!L12","v":0.70544329624862956},null,{"$f":"SUM(C42:L42)","v":7.0544329624862971}]
[]
[null,"Opex ",{"$f":"'02. FCL'!C16","v":-0.60211737048100444},{"$f":"'02. FCL'!D16","v":-0.60211737048100444},{"$f":"'02. FCL'!E16","v":-0.60211737048100444},{"$f":"'02. FCL'!F16","v":-0.60211737048100444},{"$f":"'02. FCL'!G16","v":-0.60211737048100444},{"$f":"'02. FCL'!H16","v":-0.60211737048100444},{"$f":"'02. FCL'!I16","v":-0.60211737048100444},{"$f":"'02. FCL'!J16","v":-0.60211737048100444},{"$f":"'02. FCL'!K16","v":-0.60211737048100444},{"$f":"'02. FCL'!L16","v":-0.60211737048100444},null,{"$f":"SUM(C44:L44)","v":-6.0211737048100451}]
[]
[null,"CAPEX",{"$f":"'02. FCL'!C21","v":-0.50837100000000002},{"$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.50837100000000002}]
[]
[null,"Impostos Total ",{"$f":"C36","v":-9.7915529519309777E-2},-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,-9.7915529519309777E-2,null,{"$f":"SUM(C48:L48)","v":-0.97915529519309796}]
[]
[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.50296060375168472},{"$f":"D42+D44+D46+D48+D50","v":5.4103962483153384E-3},5.4103962483153384E-3,5.4103962483153384E-3,5.4103962483153384E-3,5.4103962483153384E-3,5.4103962483153384E-3,5.4103962483153384E-3,5.4103962483153384E-3,5.4103962483153384E-3,null,{"$f":"SUM(C52:L52)","v":-0.45426703751684655}]
[]
[null,"VPL - Ano 0 - Real ",{"$f":"'07. (a)TRIBUTOS LREAL'!C121","v":-0.42620837311983378},{"$f":"'07. (a)TRIBUTOS LREAL'!D121","v":6.9907716636257486E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!E121","v":6.4483784484210563E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!F121","v":5.9480679122188559E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!G121","v":4.1807701385047122E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!H121","v":3.8563965977046054E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!I121","v":3.5571902367506569E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!J121","v":3.2811984088892306E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!K121","v":2.6314615150489513E-2},{"$f":"'07. (a)TRIBUTOS LREAL'!L121","v":2.418088868060982E-2},null,{"$f":"SUM(C54:L54)","v":-3.3085135227585771E-2}]
[]
[null,"VPL - Ano 0 - Presumido ",{"$f":"C52","v":-0.50296060375168472},{"$f":"D52/((1+D60)*(1+C64))","v":4.6034123077484303E-3},{"$f":"E52/((1+E60)*(1+D64))","v":4.2462472160169785E-3},3.9167935031982556E-3,3.6129011256877137E-3,3.332586855379811E-3,3.0740213369487802E-3,2.8355171493165492E-3,2.6155177933959205E-3,2.4125875342420515E-3,null,{"$f":"SUM(C56:L56)","v":-0.47231101892975025}]
[]
[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.70544329624862956},{"$f":"D14","v":0.70544329624862956},0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,null,{"$f":"SUM(C12:L12)","v":7.0544329624862971}]
[]
[null,"Receita Tarifária",{"$f":"(C16*C17)/10^6*C$8","v":0.70544329624862956},{"$f":"(D16*D17)/10^6*D$8","v":0.70544329624862956},0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,0.70544329624862956,null,{"$f":"SUM(C14:L14)","v":7.0544329624862971}]
[]
[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":3.5272164812431481},{"$f":"C17","v":3.5272164812431481},{"$f":"D17","v":3.5272164812431481},3.5272164812431481,3.5272164812431481,3.5272164812431481,3.5272164812431481,3.5272164812431481,3.5272164812431481,3.5272164812431481,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.4101733169426263E-2},-0.15,-0.1,-0.05,0,0.05,0.1,0.15,null,null,{"$f":"'01. PC'!$C$12","v":8.4101733169426263E-2},-0.15,-0.1,-0.05,0,0.05,0.1,0.15]
[null,"Opex (Milhões)",-0.15000000000000002,0.44718142361960367,0.41145168437085089,0.38023073758841197,0.35265449666523052,0.32807045513570765,0.3059763008832721,0.28597876162291569,null,"Tarifa",-0.15000000000000002,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.22121026308258174,-7.4975931879982638E-2,3.2171873083446156E-2]
[null,null,-0.1,0.34020452004048951,0.31241040888599803,0.28782628377475183,0.26587760199659294,0.24612268210743848,0.22821603672730295,0.21187151201437038,null,null,-0.1,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},-0.18866117096021495,-4.80923995777639E-2,5.9621727586199214E-2,0.15086846135125431]
[null,null,-0.05,0.23774232716309651,0.21633812817187947,0.19651538562500726,0.17757674289529857,0.16034389922613856,0.14441005202615842,0.12991153659330923,null,null,-0.05,{"$error":"#NUM!"},{"$error":"#NUM!"},-0.17881602014940923,-3.5147468285975814E-2,7.4875021951886556E-2,0.17078334694074249,0.25898470224069525]
[null,null,0,0.12811453957475916,0.11030397443547013,9.4334925287608673E-2,7.9974327580542459E-2,6.6970682075448984E-2,5.5117876649137809E-2,4.3889960759854629E-2,null,null,0,{"$error":"#NUM!"},-0.18866117096021495,-3.5147468285975814E-2,7.9974327580542459E-2,0.18067943002274944,0.27250297912872212,0.36444172670614683]
[null,null,0.05,4.9628804348240685E-3,-8.6772938256501897E-3,-2.1084620531080067E-2,-3.2442871738107448E-2,-4.2899262910168101E-2,-5.2573315507118745E-2,-6.1563229458027724E-2,null,null,0.05,-0.22121026308258174,-4.8092399577763123E-2,7.4875021951886556E-2,0.18067943002274944,0.27701982251395307,0.37387867517122753,0.47685200248247783]
[null,null,0.1,-0.15870435797313087,-0.16719179631234948,-0.17503717797927609,-0.18232355573376291,-0.18911933931872738,-0.19548148848163482,-0.20145789004708725,null,null,0.1,-7.4975931879982638E-2,5.9621727586199214E-2,0.17078334694074249,0.27250297912872212,0.37387867517122753,0.48196260251927625,0.60045962332578795]
[null,null,0.15000000000000002,{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},null,null,0.15000000000000002,3.21718730834466E-2,0.15086846135125431,0.25898470224069525,0.36444172670614683,0.47685200248247783,0.60045962332578795,0.8465263555942053]

{"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"}]