{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Autoria","FC_Florestal","FC_Financeiro"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":45,"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":"Autoria","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FC_Florestal","index":1,"n_rows":211,"n_cols":29,"rows_kept":211,"cut":false,"hidden":false,"merged":[[66,0,79,0],[98,0,111,0],[27,0,27,2],[55,0,55,2],[15,13,15,17],[64,0,65,2],[4,0,4,16],[1,4,1,6],[2,4,2,6],[5,0,5,2],[12,0,12,2]]}
[]
[]
[]
[]
["Premissas"]
["Preços "]
["Produtos","Preço (R$/m3)"]
["CEL",90]
["BIO",0]
["XX1",0]
["XX2",0]
[]
["Produtividades"]
["Intervenções","Idade","Produtividade (m3/ha)",{"$f":"CONCATENATE(\"% Vol  \",A8)","v":"% Vol  CEL"},{"$f":"A8","v":"CEL"},{"$f":"CONCATENATE(\"% Vol  \",A9)","v":"% Vol  BIO"},{"$f":"A9","v":"BIO"},{"$f":"CONCATENATE(\"% Vol  \",A10)","v":"% Vol  XX1"},{"$f":"A10","v":"XX1"},{"$f":"CONCATENATE(\"% Vol  \",A11)","v":"% Vol  XX2"},{"$f":"A11","v":"XX2"}]
["CR5",5,203.7,1,{"$f":"D15*$C15","v":203.7},0,{"$f":"F15*$C15","v":0},0,{"$f":"H15*$C15","v":0},0,{"$f":"J15*$C15","v":0}]
["CR6",6,241.04499999999999,1,{"$f":"D16*$C16","v":241.04499999999999},0,{"$f":"F16*$C16","v":0},0,0,0,0]
["CR7",7,269.65999999999997,1,269.65999999999997,0,0,0,0,0,0]
["CR8",8,291.96999999999997,1,291.96999999999997,0,0,0,0,0,0]
["CC5",5,203.7,1,203.7,0,0,0,0,0,0]
["CC6",6,241.04499999999999,1,241.04499999999999,0,0,0,0,0,0]
["CC7",7,269.65999999999997,1,269.65999999999997,0,{"$f":"F21*$C21","v":0},0,0,0,0]
["CC8",8,291.96999999999997,1,291.96999999999997,0,0,0,0,0,0]
["CF5",5,203.7,1,203.7,0,0,0,0,0,0]
["CF6",6,241.04499999999999,1,241.04499999999999,0,0,0,0,0,0]
["CF7",7,269.65999999999997,1,269.65999999999997,0,0,0,0,0,0]
["CF8",8,291.96999999999997,1,291.96999999999997,0,0,0,0,0,0]
[]
["Despesas e Preços de Terra"]
["Intervenção","% da Área para custo","Despesas (R$/ha)",null,null,null,null,null,null,null,"Sigla","Descrição"]
["X",0,0,null,"Gestão Florestal (R$/ha)",null,null,100,null,null,{"$f":"A30","v":"X"},"Nada"]
["CMP",1,0,null,"Investimento Máquinas Flo",null,null,0.03,"s/ desp operacionais",null,"CMP","Compra da terra"]
["IAR",1,0,null,"Colheita (R$/m3)",null,null,25,null,null,"IAR","Início do Contrato de arrendamento"]
["IMP",1,-4000,null,null,null,null,null,null,null,"IMP","Implantação"]
["MN1",1,-500,null,"Regiões","Prc Terra","Pco Arr","%Região","Frete",null,"MN1","Manutenção no ano 1"]
["MN2",1,-150,null,null,"(R$/ha)","(*)",null," (R$/m3)",null,"MN2","Manutenção no ano 2"]
["MN3",1,-150,null,"50KM",5000,445.74,0.5,10,null,"MN3","Manutenção no ano 3"]
["MN4",1,-150,null,"150KM",4000,407.1,0.5,20,null,"MN4","Manutenção no ano 4"]
["MN5",1,-150,null,"XX",0,0,0,0,null,"MN5","Manutenção no ano 5"]
["MN6",1,-150,null,null,null,"(*) R$/ha.ano",null,null,null,"MN6","Manutenção no ano 6"]
["MN7",1,-150,null,null,null,null,null,null,null,"MN7","Manutenção no ano 7"]
[{"$f":"A15","v":"CR5"},1,-4000,null,null,null,null,null,null,null,"CR5","Corte seguido de reforma na idade 5 anos"]
[{"$f":"A16","v":"CR6"},1,-4000,null,null,null,null,null,null,null,"CR6","Corte seguido de reforma na idade 6 anos"]
["CR7",1,-4000,null,null,null,null,null,null,null,"CR7","Corte seguido de reforma na idade 7 anos"]
["CR8",1,-4000,null,null,null,null,null,null,null,"CR8","Corte seguido de reforma na idade 8 anos"]
["CC5",1,-2000,null,null,null,null,null,null,null,"CC5","Corte seguido de condução da brotação na idade 5 anos"]
["CC6",1,-2000,null,null,null,null,null,null,null,"CC6","Corte seguido de condução da brotação na idade 6 anos"]
["CC7",1,-2000,null,null,null,null,null,null,null,"CC7","Corte seguido de condução da brotação na idade 7 anos"]
["CC8",1,-2000,null,null,null,null,null,null,null,"CC8","Corte seguido de condução da brotação na idade 8 anos"]
["CF5",1,0,null,null,null,null,null,null,null,"CF5","Corte aos 5 anos"]
["CF6",1,0,null,null,null,null,null,null,null,"CF6","Corte aos 6 anos"]
["CF7",1,0,null,null,null,null,null,null,null,"CF7","Corte aos 7 anos"]
["CF8",1,0,null,null,null,null,null,null,null,"CF8","Corte aos 8 anos"]
["LAR",1,0,null,null,null,null,null,null,null,"LAR","Liberação do contrato de arrendamento"]
["VND",1,0,null,null,null,null,null,null,null,"VND","Venda da terra"]
[]
["Cálculo da Área Necessária"]
["Demanda mensal",40000,"m3/mês"]
["Meses",12,"meses"]
["Demanda Anual",{"$f":"B57*B58","v":480000},"m3/ano"]
["IMA (6 anos)",{"$f":"241/6","v":40.166666666666664},"m3/ha.ano"]
["Área necessária",{"$f":"B59/B60","v":11950.207468879669},"ha"]
["Aproveitamento",0.6]
["Área Total",{"$f":"B61/B62","v":19917.012448132784},"ha"]
[]
["Fluxo de Caixa Florestal",null,null,{"$f":"D66-$D$66+1","v":1},{"$f":"E66-$D$66+1","v":2},3,4,5,6,7,8,{"$f":"L66-$D$66+1","v":9},10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26]
[null,null,null,{"$f":"FC_Financeiro!D14","v":2015},{"$f":"D66+1","v":2016},{"$f":"E66+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
["Planejamento",1000,"Tlh01","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X","X"]
[null,1000,"Tlh02","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X"]
[null,1000,"Tlh03","x","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X"]
[null,1000,"Tlh04","x","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X"]
[null,1000,"Tlh05","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X"]
[null,1000,"Tlh06","X","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CF6","VND"]
[null,1000,"Tlh07","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X","X"]
[null,1000,"Tlh08","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X","X"]
[null,1000,"Tlh09","x","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X","X"]
[null,1000,"Tlh10","x","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X","X"]
[null,1000,"Tlh11","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND","X"]
[null,1000,"Tlh12","X","X","X","X","X","CMP","IMP","MN1","MN2","MN3","MN4","MN5","CC6","MN1","MN2","MN3","MN4","MN5","CR6","MN1","MN2","MN3","MN4","MN5","CF6","VND"]
[null,0,"Tlh13","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
[null,0,"Tlh14","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X","X"]
["Total Planejamento (ha)",{"$f":"SUM(B67:B80)","v":12000},"Ganho de Produt.>>",1,1,1,1,1,1,1,1,1,1,1,1.06,1.06,1.06,1.06,1.06,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001,1.1200000000000001]
["Área de Implantação (ha)","IMP",{"$f":"SUM(D82:AC82)","v":12000},{"$f":"SUMIF(D$67:D$80,$B82,$B$67:$B$80)","v":0},2000,2000,2000,2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Área Compra (ha)","CMP",{"$f":"SUM(D84:AC84)","v":12000},{"$f":"SUMIF(D$67:D$80,$B84,$B$67:$B$80)","v":2000},{"$f":"SUMIF(E$67:E$80,$B84,$B$67:$B$80)","v":2000},{"$f":"SUMIF(F$67:F$80,$B84,$B$67:$B$80)","v":2000},2000,2000,2000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total",20000,{"$f":"D84/$B$62","v":3333.3333333333335},3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Área Arrendamento (ha)","IAR",0,{"$f":"SUMIF(D$67:D$80,$B86,$B$67:$B$80)","v":0},{"$f":"SUMIF(E$67:E$80,$B86,$B$67:$B$80)","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,0]
[null,"Total",0,{"$f":"D86/$B$62","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,0,0]
["Área venda (ha)","VND",12000,{"$f":"SUMIF(D$67:D$80,$B88,$B$67:$B$80)","v":0},{"$f":"SUMIF(E$67:E$80,$B88,$B$67:$B$80)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,2000,2000,2000,2000,2000]
[null,"Total",20000,{"$f":"D88/$B$62","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335,3333.3333333333335]
["Área Lib Arrend (ha)","LAR",0,{"$f":"SUMIF(D$67:D$80,$B90,$B$67:$B$80)","v":0},{"$f":"SUMIF(E$67:E$80,$B90,$B$67:$B$80)","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,0]
[null,"Total",0,{"$f":"D90/$B$62","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,0,0]
["Área Própria(ha)",null,{"$f":"MAX(D92:AC92)","v":12000},{"$f":"D84-D88","v":2000},{"$f":"D92+E84-E88","v":4000},{"$f":"E92+F84-F88","v":6000},8000,10000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,10000,8000,6000,4000,2000,0]
[null,"Total",20000,{"$f":"D85-D89","v":3333.3333333333335},{"$f":"D93+E85-E89","v":6666.666666666667},10000,13333.333333333334,16666.666666666668,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,16666.666666666668,13333.333333333334,10000,6666.6666666666661,3333.3333333333326,0]
["Área arrendada(ha)",null,0,{"$f":"D86-D90","v":0},{"$f":"D94+E86-E90","v":0},{"$f":"E94+F86-F90","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",0,{"$f":"D87-D91","v":0},{"$f":"D95+E87-E91","v":0},{"$f":"E95+F87-F91","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]
["Área de Gestão(ha)",null,12000,{"$f":"D92+D94","v":2000},{"$f":"E92+E94","v":4000},6000,8000,10000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,12000,10000,8000,6000,4000,2000,0]
[null,"Total",20000,{"$f":"D93+D95","v":3333.3333333333335},{"$f":"E93+E95","v":6666.666666666667},10000,13333.333333333334,16666.666666666668,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,16666.666666666668,13333.333333333334,10000,6666.6666666666661,3333.3333333333326,0]
[null,"Soma","Valor Presente"]
["Despesas Operacionais: Plantio, Reforma, Condução e Manutenção (mil R$)",null,{"$f":"C67","v":"Tlh01"},{"$f":"VLOOKUP(D67,$A$29:$C$54,3,0)*VLOOKUP(D67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E67,$A$29:$C$54,3,0)*VLOOKUP(E67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!E$16/1000","v":-4452.1000000000004},{"$f":"VLOOKUP(F67,$A$29:$C$54,3,0)*VLOOKUP(F67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!F$16/1000","v":-578.77300000000002},{"$f":"VLOOKUP(G67,$A$29:$C$54,3,0)*VLOOKUP(G67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!G$16/1000","v":-180.57717600000001},{"$f":"VLOOKUP(H67,$A$29:$C$54,3,0)*VLOOKUP(H67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!H$16/1000","v":-187.80026304000003},{"$f":"VLOOKUP(I67,$A$29:$C$54,3,0)*VLOOKUP(I67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!I$16/1000","v":-195.31227356160002},{"$f":"VLOOKUP(J67,$A$29:$C$54,3,0)*VLOOKUP(J67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K67,$A$29:$C$54,3,0)*VLOOKUP(K67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!K$16/1000","v":-5633.3268022460425},{"$f":"VLOOKUP(L67,$A$29:$C$54,3,0)*VLOOKUP(L67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!L$16/1000","v":-732.33248429198557},{"$f":"VLOOKUP(M67,$A$29:$C$54,3,0)*VLOOKUP(M67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N67,$A$29:$C$54,3,0)*VLOOKUP(N67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O67,$A$29:$C$54,3,0)*VLOOKUP(O67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P67,$A$29:$C$54,3,0)*VLOOKUP(P67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q67,$A$29:$C$54,3,0)*VLOOKUP(Q67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!Q$16/1000","v":-3563.9777701425869},{"$f":"VLOOKUP(R67,$A$29:$C$54,3,0)*VLOOKUP(R67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!R$16/1000","v":-926.63422023707267},{"$f":"VLOOKUP(S67,$A$29:$C$54,3,0)*VLOOKUP(S67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T67,$A$29:$C$54,3,0)*VLOOKUP(T67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U67,$A$29:$C$54,3,0)*VLOOKUP(U67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V67,$A$29:$C$54,3,0)*VLOOKUP(V67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W67,$A$29:$C$54,3,0)*VLOOKUP(W67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!W$16/1000","v":0},{"$f":"VLOOKUP(X67,$A$29:$C$54,3,0)*VLOOKUP(X67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!X$16/1000","v":0},{"$f":"VLOOKUP(Y67,$A$29:$C$54,3,0)*VLOOKUP(Y67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z67,$A$29:$C$54,3,0)*VLOOKUP(Z67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA67,$A$29:$C$54,3,0)*VLOOKUP(AA67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB67,$A$29:$C$54,3,0)*VLOOKUP(AB67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC67,$A$29:$C$54,3,0)*VLOOKUP(AC67,$A$29:$C$54,2,0)*$B67*FC_Financeiro!AC$16/1000","v":0}]
[null,null,{"$f":"C68","v":"Tlh02"},{"$f":"VLOOKUP(D68,$A$29:$C$54,3,0)*VLOOKUP(D68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E68,$A$29:$C$54,3,0)*VLOOKUP(E68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F68,$A$29:$C$54,3,0)*VLOOKUP(F68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!F$16/1000","v":-4630.1840000000002},{"$f":"VLOOKUP(G68,$A$29:$C$54,3,0)*VLOOKUP(G68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!G$16/1000","v":-601.92392000000007},{"$f":"VLOOKUP(H68,$A$29:$C$54,3,0)*VLOOKUP(H68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!H$16/1000","v":-187.80026304000003},{"$f":"VLOOKUP(I68,$A$29:$C$54,3,0)*VLOOKUP(I68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!I$16/1000","v":-195.31227356160002},{"$f":"VLOOKUP(J68,$A$29:$C$54,3,0)*VLOOKUP(J68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K68,$A$29:$C$54,3,0)*VLOOKUP(K68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L68,$A$29:$C$54,3,0)*VLOOKUP(L68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!L$16/1000","v":-5858.6598743358845},{"$f":"VLOOKUP(M68,$A$29:$C$54,3,0)*VLOOKUP(M68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!M$16/1000","v":-761.62578366366495},{"$f":"VLOOKUP(N68,$A$29:$C$54,3,0)*VLOOKUP(N68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O68,$A$29:$C$54,3,0)*VLOOKUP(O68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P68,$A$29:$C$54,3,0)*VLOOKUP(P68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q68,$A$29:$C$54,3,0)*VLOOKUP(Q68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R68,$A$29:$C$54,3,0)*VLOOKUP(R68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!R$16/1000","v":-3706.5368809482907},{"$f":"VLOOKUP(S68,$A$29:$C$54,3,0)*VLOOKUP(S68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!S$16/1000","v":-963.69958904655562},{"$f":"VLOOKUP(T68,$A$29:$C$54,3,0)*VLOOKUP(T68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U68,$A$29:$C$54,3,0)*VLOOKUP(U68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V68,$A$29:$C$54,3,0)*VLOOKUP(V68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W68,$A$29:$C$54,3,0)*VLOOKUP(W68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X68,$A$29:$C$54,3,0)*VLOOKUP(X68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!X$16/1000","v":0},{"$f":"VLOOKUP(Y68,$A$29:$C$54,3,0)*VLOOKUP(Y68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z68,$A$29:$C$54,3,0)*VLOOKUP(Z68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA68,$A$29:$C$54,3,0)*VLOOKUP(AA68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB68,$A$29:$C$54,3,0)*VLOOKUP(AB68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC68,$A$29:$C$54,3,0)*VLOOKUP(AC68,$A$29:$C$54,2,0)*$B68*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh03",{"$f":"VLOOKUP(D69,$A$29:$C$54,3,0)*VLOOKUP(D69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E69,$A$29:$C$54,3,0)*VLOOKUP(E69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F69,$A$29:$C$54,3,0)*VLOOKUP(F69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G69,$A$29:$C$54,3,0)*VLOOKUP(G69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!G$16/1000","v":-4815.3913600000005},{"$f":"VLOOKUP(H69,$A$29:$C$54,3,0)*VLOOKUP(H69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!H$16/1000","v":-626.00087680000013},{"$f":"VLOOKUP(I69,$A$29:$C$54,3,0)*VLOOKUP(I69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!I$16/1000","v":-195.31227356160002},{"$f":"VLOOKUP(J69,$A$29:$C$54,3,0)*VLOOKUP(J69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K69,$A$29:$C$54,3,0)*VLOOKUP(K69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L69,$A$29:$C$54,3,0)*VLOOKUP(L69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M69,$A$29:$C$54,3,0)*VLOOKUP(M69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!M$16/1000","v":-6093.0062693093196},{"$f":"VLOOKUP(N69,$A$29:$C$54,3,0)*VLOOKUP(N69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!N$16/1000","v":-792.09081501021171},{"$f":"VLOOKUP(O69,$A$29:$C$54,3,0)*VLOOKUP(O69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P69,$A$29:$C$54,3,0)*VLOOKUP(P69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q69,$A$29:$C$54,3,0)*VLOOKUP(Q69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R69,$A$29:$C$54,3,0)*VLOOKUP(R69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S69,$A$29:$C$54,3,0)*VLOOKUP(S69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!S$16/1000","v":-3854.7983561862225},{"$f":"VLOOKUP(T69,$A$29:$C$54,3,0)*VLOOKUP(T69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!T$16/1000","v":-1002.247572608418},{"$f":"VLOOKUP(U69,$A$29:$C$54,3,0)*VLOOKUP(U69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V69,$A$29:$C$54,3,0)*VLOOKUP(V69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W69,$A$29:$C$54,3,0)*VLOOKUP(W69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X69,$A$29:$C$54,3,0)*VLOOKUP(X69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y69,$A$29:$C$54,3,0)*VLOOKUP(Y69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z69,$A$29:$C$54,3,0)*VLOOKUP(Z69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA69,$A$29:$C$54,3,0)*VLOOKUP(AA69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB69,$A$29:$C$54,3,0)*VLOOKUP(AB69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC69,$A$29:$C$54,3,0)*VLOOKUP(AC69,$A$29:$C$54,2,0)*$B69*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh04",{"$f":"VLOOKUP(D70,$A$29:$C$54,3,0)*VLOOKUP(D70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E70,$A$29:$C$54,3,0)*VLOOKUP(E70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F70,$A$29:$C$54,3,0)*VLOOKUP(F70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G70,$A$29:$C$54,3,0)*VLOOKUP(G70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H70,$A$29:$C$54,3,0)*VLOOKUP(H70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!H$16/1000","v":-5008.007014400001},{"$f":"VLOOKUP(I70,$A$29:$C$54,3,0)*VLOOKUP(I70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!I$16/1000","v":-651.04091187200004},{"$f":"VLOOKUP(J70,$A$29:$C$54,3,0)*VLOOKUP(J70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K70,$A$29:$C$54,3,0)*VLOOKUP(K70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L70,$A$29:$C$54,3,0)*VLOOKUP(L70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M70,$A$29:$C$54,3,0)*VLOOKUP(M70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N70,$A$29:$C$54,3,0)*VLOOKUP(N70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!N$16/1000","v":-6336.7265200816937},{"$f":"VLOOKUP(O70,$A$29:$C$54,3,0)*VLOOKUP(O70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!O$16/1000","v":-823.7744476106202},{"$f":"VLOOKUP(P70,$A$29:$C$54,3,0)*VLOOKUP(P70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q70,$A$29:$C$54,3,0)*VLOOKUP(Q70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R70,$A$29:$C$54,3,0)*VLOOKUP(R70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S70,$A$29:$C$54,3,0)*VLOOKUP(S70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T70,$A$29:$C$54,3,0)*VLOOKUP(T70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!T$16/1000","v":-4008.9902904336718},{"$f":"VLOOKUP(U70,$A$29:$C$54,3,0)*VLOOKUP(U70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!U$16/1000","v":-1042.3374755127545},{"$f":"VLOOKUP(V70,$A$29:$C$54,3,0)*VLOOKUP(V70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W70,$A$29:$C$54,3,0)*VLOOKUP(W70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X70,$A$29:$C$54,3,0)*VLOOKUP(X70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y70,$A$29:$C$54,3,0)*VLOOKUP(Y70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!Y$16/1000","v":-365.81622544121598},{"$f":"VLOOKUP(Z70,$A$29:$C$54,3,0)*VLOOKUP(Z70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA70,$A$29:$C$54,3,0)*VLOOKUP(AA70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB70,$A$29:$C$54,3,0)*VLOOKUP(AB70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC70,$A$29:$C$54,3,0)*VLOOKUP(AC70,$A$29:$C$54,2,0)*$B70*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh05",{"$f":"VLOOKUP(D71,$A$29:$C$54,3,0)*VLOOKUP(D71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E71,$A$29:$C$54,3,0)*VLOOKUP(E71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F71,$A$29:$C$54,3,0)*VLOOKUP(F71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G71,$A$29:$C$54,3,0)*VLOOKUP(G71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H71,$A$29:$C$54,3,0)*VLOOKUP(H71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!H$16/1000","v":0},{"$f":"VLOOKUP(I71,$A$29:$C$54,3,0)*VLOOKUP(I71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!I$16/1000","v":-5208.3272949760003},{"$f":"VLOOKUP(J71,$A$29:$C$54,3,0)*VLOOKUP(J71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!J$16/1000","v":-677.08254834688012},{"$f":"VLOOKUP(K71,$A$29:$C$54,3,0)*VLOOKUP(K71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L71,$A$29:$C$54,3,0)*VLOOKUP(L71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M71,$A$29:$C$54,3,0)*VLOOKUP(M71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N71,$A$29:$C$54,3,0)*VLOOKUP(N71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O71,$A$29:$C$54,3,0)*VLOOKUP(O71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!O$16/1000","v":-6590.1955808849616},{"$f":"VLOOKUP(P71,$A$29:$C$54,3,0)*VLOOKUP(P71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!P$16/1000","v":-856.72542551504489},{"$f":"VLOOKUP(Q71,$A$29:$C$54,3,0)*VLOOKUP(Q71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R71,$A$29:$C$54,3,0)*VLOOKUP(R71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S71,$A$29:$C$54,3,0)*VLOOKUP(S71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T71,$A$29:$C$54,3,0)*VLOOKUP(T71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U71,$A$29:$C$54,3,0)*VLOOKUP(U71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!U$16/1000","v":-4169.349902051018},{"$f":"VLOOKUP(V71,$A$29:$C$54,3,0)*VLOOKUP(V71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!V$16/1000","v":-1084.0309745332647},{"$f":"VLOOKUP(W71,$A$29:$C$54,3,0)*VLOOKUP(W71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X71,$A$29:$C$54,3,0)*VLOOKUP(X71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y71,$A$29:$C$54,3,0)*VLOOKUP(Y71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!Y$16/1000","v":-365.81622544121598},{"$f":"VLOOKUP(Z71,$A$29:$C$54,3,0)*VLOOKUP(Z71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!Z$16/1000","v":-380.44887445886457},{"$f":"VLOOKUP(AA71,$A$29:$C$54,3,0)*VLOOKUP(AA71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB71,$A$29:$C$54,3,0)*VLOOKUP(AB71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC71,$A$29:$C$54,3,0)*VLOOKUP(AC71,$A$29:$C$54,2,0)*$B71*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh06",{"$f":"VLOOKUP(D72,$A$29:$C$54,3,0)*VLOOKUP(D72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E72,$A$29:$C$54,3,0)*VLOOKUP(E72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F72,$A$29:$C$54,3,0)*VLOOKUP(F72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G72,$A$29:$C$54,3,0)*VLOOKUP(G72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H72,$A$29:$C$54,3,0)*VLOOKUP(H72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!H$16/1000","v":0},{"$f":"VLOOKUP(I72,$A$29:$C$54,3,0)*VLOOKUP(I72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!I$16/1000","v":0},{"$f":"VLOOKUP(J72,$A$29:$C$54,3,0)*VLOOKUP(J72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!J$16/1000","v":-5416.6603867750409},{"$f":"VLOOKUP(K72,$A$29:$C$54,3,0)*VLOOKUP(K72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!K$16/1000","v":-704.16585028075531},{"$f":"VLOOKUP(L72,$A$29:$C$54,3,0)*VLOOKUP(L72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M72,$A$29:$C$54,3,0)*VLOOKUP(M72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N72,$A$29:$C$54,3,0)*VLOOKUP(N72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O72,$A$29:$C$54,3,0)*VLOOKUP(O72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P72,$A$29:$C$54,3,0)*VLOOKUP(P72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!P$16/1000","v":-6853.8034041203591},{"$f":"VLOOKUP(Q72,$A$29:$C$54,3,0)*VLOOKUP(Q72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!Q$16/1000","v":-890.99444253564673},{"$f":"VLOOKUP(R72,$A$29:$C$54,3,0)*VLOOKUP(R72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S72,$A$29:$C$54,3,0)*VLOOKUP(S72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T72,$A$29:$C$54,3,0)*VLOOKUP(T72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U72,$A$29:$C$54,3,0)*VLOOKUP(U72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V72,$A$29:$C$54,3,0)*VLOOKUP(V72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!V$16/1000","v":-4336.1238981330589},{"$f":"VLOOKUP(W72,$A$29:$C$54,3,0)*VLOOKUP(W72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!W$16/1000","v":-1127.3922135145956},{"$f":"VLOOKUP(X72,$A$29:$C$54,3,0)*VLOOKUP(X72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y72,$A$29:$C$54,3,0)*VLOOKUP(Y72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!Y$16/1000","v":-365.81622544121598},{"$f":"VLOOKUP(Z72,$A$29:$C$54,3,0)*VLOOKUP(Z72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!Z$16/1000","v":-380.44887445886457},{"$f":"VLOOKUP(AA72,$A$29:$C$54,3,0)*VLOOKUP(AA72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!AA$16/1000","v":-395.66682943721912},{"$f":"VLOOKUP(AB72,$A$29:$C$54,3,0)*VLOOKUP(AB72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC72,$A$29:$C$54,3,0)*VLOOKUP(AC72,$A$29:$C$54,2,0)*$B72*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh07",{"$f":"VLOOKUP(D73,$A$29:$C$54,3,0)*VLOOKUP(D73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E73,$A$29:$C$54,3,0)*VLOOKUP(E73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!E$16/1000","v":-4452.1000000000004},{"$f":"VLOOKUP(F73,$A$29:$C$54,3,0)*VLOOKUP(F73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!F$16/1000","v":-578.77300000000002},{"$f":"VLOOKUP(G73,$A$29:$C$54,3,0)*VLOOKUP(G73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!G$16/1000","v":-180.57717600000001},{"$f":"VLOOKUP(H73,$A$29:$C$54,3,0)*VLOOKUP(H73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!H$16/1000","v":-187.80026304000003},{"$f":"VLOOKUP(I73,$A$29:$C$54,3,0)*VLOOKUP(I73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!I$16/1000","v":-195.31227356160002},{"$f":"VLOOKUP(J73,$A$29:$C$54,3,0)*VLOOKUP(J73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K73,$A$29:$C$54,3,0)*VLOOKUP(K73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!K$16/1000","v":-2816.6634011230212},{"$f":"VLOOKUP(L73,$A$29:$C$54,3,0)*VLOOKUP(L73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!L$16/1000","v":-732.33248429198557},{"$f":"VLOOKUP(M73,$A$29:$C$54,3,0)*VLOOKUP(M73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N73,$A$29:$C$54,3,0)*VLOOKUP(N73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O73,$A$29:$C$54,3,0)*VLOOKUP(O73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P73,$A$29:$C$54,3,0)*VLOOKUP(P73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q73,$A$29:$C$54,3,0)*VLOOKUP(Q73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!Q$16/1000","v":-7127.9555402851738},{"$f":"VLOOKUP(R73,$A$29:$C$54,3,0)*VLOOKUP(R73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!R$16/1000","v":-926.63422023707267},{"$f":"VLOOKUP(S73,$A$29:$C$54,3,0)*VLOOKUP(S73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T73,$A$29:$C$54,3,0)*VLOOKUP(T73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U73,$A$29:$C$54,3,0)*VLOOKUP(U73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V73,$A$29:$C$54,3,0)*VLOOKUP(V73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W73,$A$29:$C$54,3,0)*VLOOKUP(W73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!W$16/1000","v":0},{"$f":"VLOOKUP(X73,$A$29:$C$54,3,0)*VLOOKUP(X73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!X$16/1000","v":0},{"$f":"VLOOKUP(Y73,$A$29:$C$54,3,0)*VLOOKUP(Y73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z73,$A$29:$C$54,3,0)*VLOOKUP(Z73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA73,$A$29:$C$54,3,0)*VLOOKUP(AA73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB73,$A$29:$C$54,3,0)*VLOOKUP(AB73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC73,$A$29:$C$54,3,0)*VLOOKUP(AC73,$A$29:$C$54,2,0)*$B73*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh08",{"$f":"VLOOKUP(D74,$A$29:$C$54,3,0)*VLOOKUP(D74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E74,$A$29:$C$54,3,0)*VLOOKUP(E74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F74,$A$29:$C$54,3,0)*VLOOKUP(F74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!F$16/1000","v":-4630.1840000000002},{"$f":"VLOOKUP(G74,$A$29:$C$54,3,0)*VLOOKUP(G74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!G$16/1000","v":-601.92392000000007},{"$f":"VLOOKUP(H74,$A$29:$C$54,3,0)*VLOOKUP(H74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!H$16/1000","v":-187.80026304000003},{"$f":"VLOOKUP(I74,$A$29:$C$54,3,0)*VLOOKUP(I74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!I$16/1000","v":-195.31227356160002},{"$f":"VLOOKUP(J74,$A$29:$C$54,3,0)*VLOOKUP(J74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K74,$A$29:$C$54,3,0)*VLOOKUP(K74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L74,$A$29:$C$54,3,0)*VLOOKUP(L74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!L$16/1000","v":-2929.3299371679423},{"$f":"VLOOKUP(M74,$A$29:$C$54,3,0)*VLOOKUP(M74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!M$16/1000","v":-761.62578366366495},{"$f":"VLOOKUP(N74,$A$29:$C$54,3,0)*VLOOKUP(N74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O74,$A$29:$C$54,3,0)*VLOOKUP(O74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P74,$A$29:$C$54,3,0)*VLOOKUP(P74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q74,$A$29:$C$54,3,0)*VLOOKUP(Q74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R74,$A$29:$C$54,3,0)*VLOOKUP(R74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!R$16/1000","v":-7413.0737618965813},{"$f":"VLOOKUP(S74,$A$29:$C$54,3,0)*VLOOKUP(S74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!S$16/1000","v":-963.69958904655562},{"$f":"VLOOKUP(T74,$A$29:$C$54,3,0)*VLOOKUP(T74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U74,$A$29:$C$54,3,0)*VLOOKUP(U74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V74,$A$29:$C$54,3,0)*VLOOKUP(V74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W74,$A$29:$C$54,3,0)*VLOOKUP(W74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X74,$A$29:$C$54,3,0)*VLOOKUP(X74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!X$16/1000","v":0},{"$f":"VLOOKUP(Y74,$A$29:$C$54,3,0)*VLOOKUP(Y74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z74,$A$29:$C$54,3,0)*VLOOKUP(Z74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA74,$A$29:$C$54,3,0)*VLOOKUP(AA74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB74,$A$29:$C$54,3,0)*VLOOKUP(AB74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC74,$A$29:$C$54,3,0)*VLOOKUP(AC74,$A$29:$C$54,2,0)*$B74*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh09",{"$f":"VLOOKUP(D75,$A$29:$C$54,3,0)*VLOOKUP(D75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E75,$A$29:$C$54,3,0)*VLOOKUP(E75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F75,$A$29:$C$54,3,0)*VLOOKUP(F75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G75,$A$29:$C$54,3,0)*VLOOKUP(G75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!G$16/1000","v":-4815.3913600000005},{"$f":"VLOOKUP(H75,$A$29:$C$54,3,0)*VLOOKUP(H75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!H$16/1000","v":-626.00087680000013},{"$f":"VLOOKUP(I75,$A$29:$C$54,3,0)*VLOOKUP(I75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!I$16/1000","v":-195.31227356160002},{"$f":"VLOOKUP(J75,$A$29:$C$54,3,0)*VLOOKUP(J75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K75,$A$29:$C$54,3,0)*VLOOKUP(K75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L75,$A$29:$C$54,3,0)*VLOOKUP(L75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M75,$A$29:$C$54,3,0)*VLOOKUP(M75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!M$16/1000","v":-3046.5031346546598},{"$f":"VLOOKUP(N75,$A$29:$C$54,3,0)*VLOOKUP(N75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!N$16/1000","v":-792.09081501021171},{"$f":"VLOOKUP(O75,$A$29:$C$54,3,0)*VLOOKUP(O75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P75,$A$29:$C$54,3,0)*VLOOKUP(P75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q75,$A$29:$C$54,3,0)*VLOOKUP(Q75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R75,$A$29:$C$54,3,0)*VLOOKUP(R75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S75,$A$29:$C$54,3,0)*VLOOKUP(S75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!S$16/1000","v":-7709.5967123724449},{"$f":"VLOOKUP(T75,$A$29:$C$54,3,0)*VLOOKUP(T75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!T$16/1000","v":-1002.247572608418},{"$f":"VLOOKUP(U75,$A$29:$C$54,3,0)*VLOOKUP(U75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V75,$A$29:$C$54,3,0)*VLOOKUP(V75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W75,$A$29:$C$54,3,0)*VLOOKUP(W75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X75,$A$29:$C$54,3,0)*VLOOKUP(X75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y75,$A$29:$C$54,3,0)*VLOOKUP(Y75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z75,$A$29:$C$54,3,0)*VLOOKUP(Z75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA75,$A$29:$C$54,3,0)*VLOOKUP(AA75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB75,$A$29:$C$54,3,0)*VLOOKUP(AB75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC75,$A$29:$C$54,3,0)*VLOOKUP(AC75,$A$29:$C$54,2,0)*$B75*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh10",{"$f":"VLOOKUP(D76,$A$29:$C$54,3,0)*VLOOKUP(D76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E76,$A$29:$C$54,3,0)*VLOOKUP(E76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F76,$A$29:$C$54,3,0)*VLOOKUP(F76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G76,$A$29:$C$54,3,0)*VLOOKUP(G76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H76,$A$29:$C$54,3,0)*VLOOKUP(H76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!H$16/1000","v":-5008.007014400001},{"$f":"VLOOKUP(I76,$A$29:$C$54,3,0)*VLOOKUP(I76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!I$16/1000","v":-651.04091187200004},{"$f":"VLOOKUP(J76,$A$29:$C$54,3,0)*VLOOKUP(J76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!J$16/1000","v":-203.12476450406402},{"$f":"VLOOKUP(K76,$A$29:$C$54,3,0)*VLOOKUP(K76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L76,$A$29:$C$54,3,0)*VLOOKUP(L76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M76,$A$29:$C$54,3,0)*VLOOKUP(M76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N76,$A$29:$C$54,3,0)*VLOOKUP(N76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!N$16/1000","v":-3168.3632600408469},{"$f":"VLOOKUP(O76,$A$29:$C$54,3,0)*VLOOKUP(O76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!O$16/1000","v":-823.7744476106202},{"$f":"VLOOKUP(P76,$A$29:$C$54,3,0)*VLOOKUP(P76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!P$16/1000","v":-257.01762765451349},{"$f":"VLOOKUP(Q76,$A$29:$C$54,3,0)*VLOOKUP(Q76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R76,$A$29:$C$54,3,0)*VLOOKUP(R76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S76,$A$29:$C$54,3,0)*VLOOKUP(S76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T76,$A$29:$C$54,3,0)*VLOOKUP(T76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!T$16/1000","v":-8017.9805808673436},{"$f":"VLOOKUP(U76,$A$29:$C$54,3,0)*VLOOKUP(U76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!U$16/1000","v":-1042.3374755127545},{"$f":"VLOOKUP(V76,$A$29:$C$54,3,0)*VLOOKUP(V76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!V$16/1000","v":-325.20929235997943},{"$f":"VLOOKUP(W76,$A$29:$C$54,3,0)*VLOOKUP(W76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X76,$A$29:$C$54,3,0)*VLOOKUP(X76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y76,$A$29:$C$54,3,0)*VLOOKUP(Y76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!Y$16/1000","v":-365.81622544121598},{"$f":"VLOOKUP(Z76,$A$29:$C$54,3,0)*VLOOKUP(Z76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA76,$A$29:$C$54,3,0)*VLOOKUP(AA76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB76,$A$29:$C$54,3,0)*VLOOKUP(AB76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC76,$A$29:$C$54,3,0)*VLOOKUP(AC76,$A$29:$C$54,2,0)*$B76*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh11",{"$f":"VLOOKUP(D77,$A$29:$C$54,3,0)*VLOOKUP(D77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E77,$A$29:$C$54,3,0)*VLOOKUP(E77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F77,$A$29:$C$54,3,0)*VLOOKUP(F77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G77,$A$29:$C$54,3,0)*VLOOKUP(G77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H77,$A$29:$C$54,3,0)*VLOOKUP(H77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!H$16/1000","v":0},{"$f":"VLOOKUP(I77,$A$29:$C$54,3,0)*VLOOKUP(I77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!I$16/1000","v":-5208.3272949760003},{"$f":"VLOOKUP(J77,$A$29:$C$54,3,0)*VLOOKUP(J77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!J$16/1000","v":-677.08254834688012},{"$f":"VLOOKUP(K77,$A$29:$C$54,3,0)*VLOOKUP(K77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!K$16/1000","v":-211.24975508422656},{"$f":"VLOOKUP(L77,$A$29:$C$54,3,0)*VLOOKUP(L77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M77,$A$29:$C$54,3,0)*VLOOKUP(M77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N77,$A$29:$C$54,3,0)*VLOOKUP(N77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O77,$A$29:$C$54,3,0)*VLOOKUP(O77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!O$16/1000","v":-3295.0977904424808},{"$f":"VLOOKUP(P77,$A$29:$C$54,3,0)*VLOOKUP(P77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!P$16/1000","v":-856.72542551504489},{"$f":"VLOOKUP(Q77,$A$29:$C$54,3,0)*VLOOKUP(Q77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!Q$16/1000","v":-267.29833276069405},{"$f":"VLOOKUP(R77,$A$29:$C$54,3,0)*VLOOKUP(R77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S77,$A$29:$C$54,3,0)*VLOOKUP(S77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T77,$A$29:$C$54,3,0)*VLOOKUP(T77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U77,$A$29:$C$54,3,0)*VLOOKUP(U77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!U$16/1000","v":-8338.6998041020361},{"$f":"VLOOKUP(V77,$A$29:$C$54,3,0)*VLOOKUP(V77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!V$16/1000","v":-1084.0309745332647},{"$f":"VLOOKUP(W77,$A$29:$C$54,3,0)*VLOOKUP(W77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!W$16/1000","v":-338.21766405437864},{"$f":"VLOOKUP(X77,$A$29:$C$54,3,0)*VLOOKUP(X77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y77,$A$29:$C$54,3,0)*VLOOKUP(Y77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!Y$16/1000","v":-365.81622544121598},{"$f":"VLOOKUP(Z77,$A$29:$C$54,3,0)*VLOOKUP(Z77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!Z$16/1000","v":-380.44887445886457},{"$f":"VLOOKUP(AA77,$A$29:$C$54,3,0)*VLOOKUP(AA77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB77,$A$29:$C$54,3,0)*VLOOKUP(AB77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC77,$A$29:$C$54,3,0)*VLOOKUP(AC77,$A$29:$C$54,2,0)*$B77*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh12",{"$f":"VLOOKUP(D78,$A$29:$C$54,3,0)*VLOOKUP(D78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E78,$A$29:$C$54,3,0)*VLOOKUP(E78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F78,$A$29:$C$54,3,0)*VLOOKUP(F78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G78,$A$29:$C$54,3,0)*VLOOKUP(G78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H78,$A$29:$C$54,3,0)*VLOOKUP(H78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!H$16/1000","v":0},{"$f":"VLOOKUP(I78,$A$29:$C$54,3,0)*VLOOKUP(I78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!I$16/1000","v":0},{"$f":"VLOOKUP(J78,$A$29:$C$54,3,0)*VLOOKUP(J78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!J$16/1000","v":-5416.6603867750409},{"$f":"VLOOKUP(K78,$A$29:$C$54,3,0)*VLOOKUP(K78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!K$16/1000","v":-704.16585028075531},{"$f":"VLOOKUP(L78,$A$29:$C$54,3,0)*VLOOKUP(L78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!L$16/1000","v":-219.69974528759565},{"$f":"VLOOKUP(M78,$A$29:$C$54,3,0)*VLOOKUP(M78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!M$16/1000","v":-228.4877350990995},{"$f":"VLOOKUP(N78,$A$29:$C$54,3,0)*VLOOKUP(N78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!N$16/1000","v":-237.62724450306348},{"$f":"VLOOKUP(O78,$A$29:$C$54,3,0)*VLOOKUP(O78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!O$16/1000","v":-247.13233428318603},{"$f":"VLOOKUP(P78,$A$29:$C$54,3,0)*VLOOKUP(P78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!P$16/1000","v":-3426.9017020601796},{"$f":"VLOOKUP(Q78,$A$29:$C$54,3,0)*VLOOKUP(Q78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!Q$16/1000","v":-890.99444253564673},{"$f":"VLOOKUP(R78,$A$29:$C$54,3,0)*VLOOKUP(R78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!R$16/1000","v":-277.99026607112177},{"$f":"VLOOKUP(S78,$A$29:$C$54,3,0)*VLOOKUP(S78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!S$16/1000","v":-289.10987671396668},{"$f":"VLOOKUP(T78,$A$29:$C$54,3,0)*VLOOKUP(T78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!T$16/1000","v":-300.67427178252535},{"$f":"VLOOKUP(U78,$A$29:$C$54,3,0)*VLOOKUP(U78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!U$16/1000","v":-312.70124265382634},{"$f":"VLOOKUP(V78,$A$29:$C$54,3,0)*VLOOKUP(V78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!V$16/1000","v":-8672.2477962661178},{"$f":"VLOOKUP(W78,$A$29:$C$54,3,0)*VLOOKUP(W78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!W$16/1000","v":-1127.3922135145956},{"$f":"VLOOKUP(X78,$A$29:$C$54,3,0)*VLOOKUP(X78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!X$16/1000","v":-351.74637061655375},{"$f":"VLOOKUP(Y78,$A$29:$C$54,3,0)*VLOOKUP(Y78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!Y$16/1000","v":-365.81622544121598},{"$f":"VLOOKUP(Z78,$A$29:$C$54,3,0)*VLOOKUP(Z78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!Z$16/1000","v":-380.44887445886457},{"$f":"VLOOKUP(AA78,$A$29:$C$54,3,0)*VLOOKUP(AA78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!AA$16/1000","v":-395.66682943721912},{"$f":"VLOOKUP(AB78,$A$29:$C$54,3,0)*VLOOKUP(AB78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC78,$A$29:$C$54,3,0)*VLOOKUP(AC78,$A$29:$C$54,2,0)*$B78*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh13",{"$f":"VLOOKUP(D79,$A$29:$C$54,3,0)*VLOOKUP(D79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E79,$A$29:$C$54,3,0)*VLOOKUP(E79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F79,$A$29:$C$54,3,0)*VLOOKUP(F79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G79,$A$29:$C$54,3,0)*VLOOKUP(G79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H79,$A$29:$C$54,3,0)*VLOOKUP(H79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!H$16/1000","v":0},{"$f":"VLOOKUP(I79,$A$29:$C$54,3,0)*VLOOKUP(I79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!I$16/1000","v":0},{"$f":"VLOOKUP(J79,$A$29:$C$54,3,0)*VLOOKUP(J79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!J$16/1000","v":0},{"$f":"VLOOKUP(K79,$A$29:$C$54,3,0)*VLOOKUP(K79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!K$16/1000","v":0},{"$f":"VLOOKUP(L79,$A$29:$C$54,3,0)*VLOOKUP(L79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!L$16/1000","v":0},{"$f":"VLOOKUP(M79,$A$29:$C$54,3,0)*VLOOKUP(M79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!M$16/1000","v":0},{"$f":"VLOOKUP(N79,$A$29:$C$54,3,0)*VLOOKUP(N79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!N$16/1000","v":0},{"$f":"VLOOKUP(O79,$A$29:$C$54,3,0)*VLOOKUP(O79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!O$16/1000","v":0},{"$f":"VLOOKUP(P79,$A$29:$C$54,3,0)*VLOOKUP(P79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!P$16/1000","v":0},{"$f":"VLOOKUP(Q79,$A$29:$C$54,3,0)*VLOOKUP(Q79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!Q$16/1000","v":0},{"$f":"VLOOKUP(R79,$A$29:$C$54,3,0)*VLOOKUP(R79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!R$16/1000","v":0},{"$f":"VLOOKUP(S79,$A$29:$C$54,3,0)*VLOOKUP(S79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!S$16/1000","v":0},{"$f":"VLOOKUP(T79,$A$29:$C$54,3,0)*VLOOKUP(T79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!T$16/1000","v":0},{"$f":"VLOOKUP(U79,$A$29:$C$54,3,0)*VLOOKUP(U79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!U$16/1000","v":0},{"$f":"VLOOKUP(V79,$A$29:$C$54,3,0)*VLOOKUP(V79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!V$16/1000","v":0},{"$f":"VLOOKUP(W79,$A$29:$C$54,3,0)*VLOOKUP(W79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!W$16/1000","v":0},{"$f":"VLOOKUP(X79,$A$29:$C$54,3,0)*VLOOKUP(X79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!X$16/1000","v":0},{"$f":"VLOOKUP(Y79,$A$29:$C$54,3,0)*VLOOKUP(Y79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z79,$A$29:$C$54,3,0)*VLOOKUP(Z79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA79,$A$29:$C$54,3,0)*VLOOKUP(AA79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB79,$A$29:$C$54,3,0)*VLOOKUP(AB79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC79,$A$29:$C$54,3,0)*VLOOKUP(AC79,$A$29:$C$54,2,0)*$B79*FC_Financeiro!AC$16/1000","v":0}]
[null,null,"Tlh14",{"$f":"VLOOKUP(D80,$A$29:$C$54,3,0)*VLOOKUP(D80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!D$16/1000","v":0},{"$f":"VLOOKUP(E80,$A$29:$C$54,3,0)*VLOOKUP(E80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!E$16/1000","v":0},{"$f":"VLOOKUP(F80,$A$29:$C$54,3,0)*VLOOKUP(F80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!F$16/1000","v":0},{"$f":"VLOOKUP(G80,$A$29:$C$54,3,0)*VLOOKUP(G80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!G$16/1000","v":0},{"$f":"VLOOKUP(H80,$A$29:$C$54,3,0)*VLOOKUP(H80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!H$16/1000","v":0},{"$f":"VLOOKUP(I80,$A$29:$C$54,3,0)*VLOOKUP(I80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!I$16/1000","v":0},{"$f":"VLOOKUP(J80,$A$29:$C$54,3,0)*VLOOKUP(J80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!J$16/1000","v":0},{"$f":"VLOOKUP(K80,$A$29:$C$54,3,0)*VLOOKUP(K80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!K$16/1000","v":0},{"$f":"VLOOKUP(L80,$A$29:$C$54,3,0)*VLOOKUP(L80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!L$16/1000","v":0},{"$f":"VLOOKUP(M80,$A$29:$C$54,3,0)*VLOOKUP(M80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!M$16/1000","v":0},{"$f":"VLOOKUP(N80,$A$29:$C$54,3,0)*VLOOKUP(N80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!N$16/1000","v":0},{"$f":"VLOOKUP(O80,$A$29:$C$54,3,0)*VLOOKUP(O80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!O$16/1000","v":0},{"$f":"VLOOKUP(P80,$A$29:$C$54,3,0)*VLOOKUP(P80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!P$16/1000","v":0},{"$f":"VLOOKUP(Q80,$A$29:$C$54,3,0)*VLOOKUP(Q80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!Q$16/1000","v":0},{"$f":"VLOOKUP(R80,$A$29:$C$54,3,0)*VLOOKUP(R80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!R$16/1000","v":0},{"$f":"VLOOKUP(S80,$A$29:$C$54,3,0)*VLOOKUP(S80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!S$16/1000","v":0},{"$f":"VLOOKUP(T80,$A$29:$C$54,3,0)*VLOOKUP(T80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!T$16/1000","v":0},{"$f":"VLOOKUP(U80,$A$29:$C$54,3,0)*VLOOKUP(U80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!U$16/1000","v":0},{"$f":"VLOOKUP(V80,$A$29:$C$54,3,0)*VLOOKUP(V80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!V$16/1000","v":0},{"$f":"VLOOKUP(W80,$A$29:$C$54,3,0)*VLOOKUP(W80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!W$16/1000","v":0},{"$f":"VLOOKUP(X80,$A$29:$C$54,3,0)*VLOOKUP(X80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!X$16/1000","v":0},{"$f":"VLOOKUP(Y80,$A$29:$C$54,3,0)*VLOOKUP(Y80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!Y$16/1000","v":0},{"$f":"VLOOKUP(Z80,$A$29:$C$54,3,0)*VLOOKUP(Z80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!Z$16/1000","v":0},{"$f":"VLOOKUP(AA80,$A$29:$C$54,3,0)*VLOOKUP(AA80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!AA$16/1000","v":0},{"$f":"VLOOKUP(AB80,$A$29:$C$54,3,0)*VLOOKUP(AB80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!AB$16/1000","v":0},{"$f":"VLOOKUP(AC80,$A$29:$C$54,3,0)*VLOOKUP(AC80,$A$29:$C$54,2,0)*$B80*FC_Financeiro!AC$16/1000","v":0}]
["Até a Colheita (mil R$)",{"$f":"SUM(D113:AC113)","v":-255045.54192753014},{"$f":"NPV(B46,D113:AC113)","v":-5006.9027042437974},{"$f":"SUM(D99:D112)","v":0},{"$f":"SUM(E99:E112)","v":-8904.2000000000007},-10417.914000000001,-11195.784912000001,-12019.21683456,-12890.610055065601,-13812.483986276355,-11548.319944604387,-12010.25274238856,-12490.662852084102,-12990.28936616747,-13509.900940814168,-14050.296978446739,-14612.308857584609,-15196.801211887989,-15804.67326036351,-16436.860190778054,-17094.334598409179,-17778.107982345544,-4960.5257394642194,-2813.9709649324295,-2194.897352647296,-1521.7954978354583,-791.33365887443824,0,0]
["Colheita (mil R$)",{"$f":"SUM(D114:AC114)","v":-472427.0691866792},{"$f":"NPV(B47,D114:AC114)","v":-138.75905305929686},{"$f":"SUM(D132,D147,D162,D177)*$H$32*FC_Financeiro!D$16/-1000","v":0},{"$f":"SUM(E132,E147,E162,E177)*$H$32*FC_Financeiro!E$16/-1000","v":0},{"$f":"SUM(F132,F147,F162,F177)*$H$32*FC_Financeiro!F$16/-1000","v":0},{"$f":"SUM(G132,G147,G162,G177)*$H$32*FC_Financeiro!G$16/-1000","v":0},{"$f":"SUM(H132,H147,H162,H177)*$H$32*FC_Financeiro!H$16/-1000","v":0},{"$f":"SUM(I132,I147,I162,I177)*$H$32*FC_Financeiro!I$16/-1000","v":0},{"$f":"SUM(J132,J147,J162,J177)*$H$32*FC_Financeiro!J$16/-1000","v":0},{"$f":"SUM(K132,K147,K162,K177)*$H$32*FC_Financeiro!K$16/-1000","v":-16973.565738092468},{"$f":"SUM(L132,L147,L162,L177)*$H$32*FC_Financeiro!L$16/-1000","v":-17652.508367616167},{"$f":"SUM(M132,M147,M162,M177)*$H$32*FC_Financeiro!M$16/-1000","v":-18358.608702320809},{"$f":"SUM(N132,N147,N162,N177)*$H$32*FC_Financeiro!N$16/-1000","v":-19092.953050413646},{"$f":"SUM(O132,O147,O162,O177)*$H$32*FC_Financeiro!O$16/-1000","v":-21048.071442776007},{"$f":"SUM(P132,P147,P162,P177)*$H$32*FC_Financeiro!P$16/-1000","v":-21889.994300487044},{"$f":"SUM(Q132,Q147,Q162,Q177)*$H$32*FC_Financeiro!Q$16/-1000","v":-22765.594072506527},{"$f":"SUM(R132,R147,R162,R177)*$H$32*FC_Financeiro!R$16/-1000","v":-23676.217835406787},{"$f":"SUM(S132,S147,S162,S177)*$H$32*FC_Financeiro!S$16/-1000","v":-24623.266548823063},{"$f":"SUM(T132,T147,T162,T177)*$H$32*FC_Financeiro!T$16/-1000","v":-27057.717807612367},{"$f":"SUM(U132,U147,U162,U177)*$H$32*FC_Financeiro!U$16/-1000","v":-28140.026519916857},{"$f":"SUM(V132,V147,V162,V177)*$H$32*FC_Financeiro!V$16/-1000","v":-29265.627580713535},{"$f":"SUM(W132,W147,W162,W177)*$H$32*FC_Financeiro!W$16/-1000","v":-30436.252683942079},{"$f":"SUM(X132,X147,X162,X177)*$H$32*FC_Financeiro!X$16/-1000","v":-31653.702791299762},{"$f":"SUM(Y132,Y147,Y162,Y177)*$H$32*FC_Financeiro!Y$16/-1000","v":-32919.850902951752},{"$f":"SUM(Z132,Z147,Z162,Z177)*$H$32*FC_Financeiro!Z$16/-1000","v":-34236.644939069825},{"$f":"SUM(AA132,AA147,AA162,AA177)*$H$32*FC_Financeiro!AA$16/-1000","v":-35606.110736632618},{"$f":"SUM(AB132,AB147,AB162,AB177)*$H$32*FC_Financeiro!AB$16/-1000","v":-37030.355166097914},{"$f":"SUM(AC132,AC147,AC162,AC177)*$H$32*FC_Financeiro!AC$16/-1000","v":0}]
["Frete (mil R$)",{"$f":"SUM(D115:AC115)","v":-283456.24151200755},{"$f":"NPV(B48,D115:AC115)","v":-83.255431835578094},{"$f":"SUM(D$132,D$147,D162,D177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!D$16/-1000","v":0},{"$f":"SUM(E$132,E$147,E162,E177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!E$16/-1000","v":0},{"$f":"SUM(F$132,F$147,F162,F177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!F$16/-1000","v":0},{"$f":"SUM(G$132,G$147,G162,G177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!G$16/-1000","v":0},{"$f":"SUM(H$132,H$147,H162,H177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!H$16/-1000","v":0},{"$f":"SUM(I$132,I$147,I162,I177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!I$16/-1000","v":0},{"$f":"SUM(J$132,J$147,J162,J177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!J$16/-1000","v":0},{"$f":"SUM(K$132,K$147,K162,K177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!K$16/-1000","v":-10184.13944285548},{"$f":"SUM(L$132,L$147,L162,L177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!L$16/-1000","v":-10591.505020569699},{"$f":"SUM(M$132,M$147,M162,M177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!M$16/-1000","v":-11015.165221392486},{"$f":"SUM(N$132,N$147,N162,N177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!N$16/-1000","v":-11455.771830248188},{"$f":"SUM(O$132,O$147,O162,O177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!O$16/-1000","v":-12628.842865665603},{"$f":"SUM(P$132,P$147,P162,P177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!P$16/-1000","v":-13133.996580292227},{"$f":"SUM(Q$132,Q$147,Q162,Q177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!Q$16/-1000","v":-13659.356443503917},{"$f":"SUM(R$132,R$147,R162,R177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!R$16/-1000","v":-14205.730701244072},{"$f":"SUM(S$132,S$147,S162,S177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!S$16/-1000","v":-14773.959929293838},{"$f":"SUM(T$132,T$147,T162,T177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!T$16/-1000","v":-16234.630684567419},{"$f":"SUM(U$132,U$147,U162,U177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!U$16/-1000","v":-16884.015911950115},{"$f":"SUM(V$132,V$147,V162,V177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!V$16/-1000","v":-17559.376548428121},{"$f":"SUM(W$132,W$147,W162,W177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!W$16/-1000","v":-18261.751610365249},{"$f":"SUM(X$132,X$147,X162,X177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!X$16/-1000","v":-18992.221674779856},{"$f":"SUM(Y$132,Y$147,Y162,Y177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!Y$16/-1000","v":-19751.910541771049},{"$f":"SUM(Z$132,Z$147,Z162,Z177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!Z$16/-1000","v":-20541.986963441894},{"$f":"SUM(AA$132,AA$147,AA162,AA177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!AA$16/-1000","v":-21363.666441979567},{"$f":"SUM(AB$132,AB$147,AB162,AB177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!AB$16/-1000","v":-22218.213099658751},{"$f":"SUM(AC$132,AC$147,AC162,AC177)*SUMPRODUCT($H$36:$H$38,$I$36:$I$38)*FC_Financeiro!AC$16/-1000","v":0}]
["Total Despesas Operacionais (mil R$)",{"$f":"SUM(D116:AC116)","v":-1010928.8526262168},{"$f":"NPV(FC_Financeiro!$D$2,D116:AC116)","v":-251712.60294122502},{"$f":"SUM(D113:D115)","v":0},{"$f":"SUM(E113:E115)","v":-8904.2000000000007},-10417.914000000001,-11195.784912000001,-12019.21683456,-12890.610055065601,-13812.483986276355,-38706.025125552333,-40254.266130574426,-41864.436775797396,-43539.014246829305,-47186.815249255778,-49074.287859226009,-51037.25937359505,-53078.749748538845,-55201.89973848041,-59729.20868295784,-62118.377030276155,-64603.112111487193,-53658.530033771545,-53459.895431012046,-54866.658797370095,-56300.42740034718,-57761.110837486616,-59248.568265756665,0]
["Volume Colhido (m3)"]
[{"$f":"CONCATENATE(\"Volume Colhido \",$A$8)","v":"Volume Colhido CEL"},{"$f":"$A$8","v":"CEL"},"Tlh01",{"$f":"IFERROR(VLOOKUP(D67,$A$15:$K$26,3+MATCH($B118,$D$14:$K$14,0),0)*$B67*D$81,0)","v":0},0,0,0,0,0,0,241045,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0,0]
[null,{"$f":"B118","v":"CEL"},"Tlh02",{"$f":"IFERROR(VLOOKUP(D68,$A$15:$K$26,3+MATCH($B119,$D$14:$K$14,0),0)*$B68*D$81,0)","v":0},0,0,0,0,0,0,0,241045,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0]
[null,{"$f":"B119","v":"CEL"},"Tlh03",{"$f":"IFERROR(VLOOKUP(D69,$A$15:$K$26,3+MATCH($B120,$D$14:$K$14,0),0)*$B69*D$81,0)","v":0},0,0,0,0,0,0,0,0,241045,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0]
[null,"CEL","Tlh04",{"$f":"IFERROR(VLOOKUP(D70,$A$15:$K$26,3+MATCH($B121,$D$14:$K$14,0),0)*$B70*D$81,0)","v":0},0,0,0,0,0,0,0,0,0,241045,0,0,0,0,0,269970.40000000002,0,0,0,0,0,269970.40000000002,0,0,0]
[null,"CEL","Tlh05",{"$f":"IFERROR(VLOOKUP(D71,$A$15:$K$26,3+MATCH($B122,$D$14:$K$14,0),0)*$B71*D$81,0)","v":0},0,0,0,0,0,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0,269970.40000000002,0,0]
[null,"CEL","Tlh06",{"$f":"IFERROR(VLOOKUP(D72,$A$15:$K$26,3+MATCH($B123,$D$14:$K$14,0),0)*$B72*D$81,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0,269970.40000000002,0]
[null,"CEL","Tlh07",{"$f":"IFERROR(VLOOKUP(D73,$A$15:$K$26,3+MATCH($B124,$D$14:$K$14,0),0)*$B73*D$81,0)","v":0},0,0,0,0,0,0,241045,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0,0]
[null,"CEL","Tlh08",{"$f":"IFERROR(VLOOKUP(D74,$A$15:$K$26,3+MATCH($B125,$D$14:$K$14,0),0)*$B74*D$81,0)","v":0},0,0,0,0,0,0,0,241045,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0]
[null,"CEL","Tlh09",{"$f":"IFERROR(VLOOKUP(D75,$A$15:$K$26,3+MATCH($B126,$D$14:$K$14,0),0)*$B75*D$81,0)","v":0},0,0,0,0,0,0,0,0,241045,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0]
[null,"CEL","Tlh10",{"$f":"IFERROR(VLOOKUP(D76,$A$15:$K$26,3+MATCH($B127,$D$14:$K$14,0),0)*$B76*D$81,0)","v":0},0,0,0,0,0,0,0,0,0,241045,0,0,0,0,0,269970.40000000002,0,0,0,0,0,269970.40000000002,0,0,0]
[null,"CEL","Tlh11",{"$f":"IFERROR(VLOOKUP(D77,$A$15:$K$26,3+MATCH($B128,$D$14:$K$14,0),0)*$B77*D$81,0)","v":0},0,0,0,0,0,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0,269970.40000000002,0,0]
[null,"CEL","Tlh12",{"$f":"IFERROR(VLOOKUP(D78,$A$15:$K$26,3+MATCH($B129,$D$14:$K$14,0),0)*$B78*D$81,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,255507.7,0,0,0,0,0,269970.40000000002,0,0,0,0,0,269970.40000000002,0]
[null,"CEL","Tlh13",{"$f":"IFERROR(VLOOKUP(D79,$A$15:$K$26,3+MATCH($B130,$D$14:$K$14,0),0)*$B79*D$81,0)","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,0,0]
[null,"CEL","Tlh14",{"$f":"IFERROR(VLOOKUP(D80,$A$15:$K$26,3+MATCH($B131,$D$14:$K$14,0),0)*$B80*D$81,0)","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,0,0]
[{"$f":"B131","v":"CEL"},{"$f":"SUM(D132:AC132)","v":9342904.1999999993},{"$f":"NPV(FC_Financeiro!$D$2,D132:AC132)","v":2139872.0816976205},{"$f":"SUM(D118:D131)","v":0},{"$f":"SUM(E118:E131)","v":0},0,0,0,0,0,482090,482090,482090,482090,{"$f":"SUM(O118:O131)","v":511015.4},511015.4,511015.4,511015.4,511015.4,539940.80000000005,539940.80000000005,539940.80000000005,539940.80000000005,539940.80000000005,539940.80000000005,539940.80000000005,539940.80000000005,539940.80000000005,0]
[{"$f":"CONCATENATE(\"Volume Colhido \",$A$9)","v":"Volume Colhido BIO"},{"$f":"$A$9","v":"BIO"},{"$f":"C118","v":"Tlh01"},{"$f":"IFERROR(VLOOKUP(D67,$A$15:$K$26,3+MATCH($B133,$D$14:$K$14,0),0)*$B67*D$81,0)","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,0,0]
[null,{"$f":"B133","v":"BIO"},{"$f":"C119","v":"Tlh02"},{"$f":"IFERROR(VLOOKUP(D68,$A$15:$K$26,3+MATCH($B134,$D$14:$K$14,0),0)*$B68*D$81,0)","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,0,0]
[null,{"$f":"B134","v":"BIO"},{"$f":"C120","v":"Tlh03"},{"$f":"IFERROR(VLOOKUP(D69,$A$15:$K$26,3+MATCH($B135,$D$14:$K$14,0),0)*$B69*D$81,0)","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,0,0]
[null,"BIO","Tlh04",{"$f":"IFERROR(VLOOKUP(D70,$A$15:$K$26,3+MATCH($B136,$D$14:$K$14,0),0)*$B70*D$81,0)","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,0,0]
[null,"BIO","Tlh05",{"$f":"IFERROR(VLOOKUP(D71,$A$15:$K$26,3+MATCH($B137,$D$14:$K$14,0),0)*$B71*D$81,0)","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,0,0]
[null,"BIO","Tlh06",{"$f":"IFERROR(VLOOKUP(D72,$A$15:$K$26,3+MATCH($B138,$D$14:$K$14,0),0)*$B72*D$81,0)","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,0,0]
[null,"BIO","Tlh07",{"$f":"IFERROR(VLOOKUP(D73,$A$15:$K$26,3+MATCH($B139,$D$14:$K$14,0),0)*$B73*D$81,0)","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,0,0]
[null,"BIO","Tlh08",{"$f":"IFERROR(VLOOKUP(D74,$A$15:$K$26,3+MATCH($B140,$D$14:$K$14,0),0)*$B74*D$81,0)","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,0,0]
[null,"BIO","Tlh09",{"$f":"IFERROR(VLOOKUP(D75,$A$15:$K$26,3+MATCH($B141,$D$14:$K$14,0),0)*$B75*D$81,0)","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,0,0]
[null,"BIO","Tlh10",{"$f":"IFERROR(VLOOKUP(D76,$A$15:$K$26,3+MATCH($B142,$D$14:$K$14,0),0)*$B76*D$81,0)","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,0,0]
[null,"BIO","Tlh11",{"$f":"IFERROR(VLOOKUP(D77,$A$15:$K$26,3+MATCH($B143,$D$14:$K$14,0),0)*$B77*D$81,0)","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,0,0]
[null,"BIO","Tlh12",{"$f":"IFERROR(VLOOKUP(D78,$A$15:$K$26,3+MATCH($B144,$D$14:$K$14,0),0)*$B78*D$81,0)","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,0,0]
[null,"BIO","Tlh13",{"$f":"IFERROR(VLOOKUP(D79,$A$15:$K$26,3+MATCH($B145,$D$14:$K$14,0),0)*$B79*D$81,0)","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,0,0]
[null,"BIO","Tlh14",{"$f":"IFERROR(VLOOKUP(D80,$A$15:$K$26,3+MATCH($B146,$D$14:$K$14,0),0)*$B80*D$81,0)","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,0,0]
[{"$f":"B146","v":"BIO"},{"$f":"SUM(D147:AC147)","v":0},{"$f":"NPV(FC_Financeiro!$D$2,D147:AC147)","v":0},{"$f":"SUM(D133:D146)","v":0},{"$f":"SUM(E133:E146)","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,{"$f":"SUM(AC133:AC146)","v":0}]
[{"$f":"CONCATENATE(\"Volume Colhido \",$A$10)","v":"Volume Colhido XX1"},{"$f":"$A$10","v":"XX1"},{"$f":"C133","v":"Tlh01"},{"$f":"IFERROR(VLOOKUP(D67,$A$15:$K$26,3+MATCH($B148,$D$14:$K$14,0),0)*$B67*D$81,0)","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,0,0]
[null,{"$f":"B148","v":"XX1"},{"$f":"C134","v":"Tlh02"},{"$f":"IFERROR(VLOOKUP(D68,$A$15:$K$26,3+MATCH($B149,$D$14:$K$14,0),0)*$B68*D$81,0)","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,0,0]
[null,{"$f":"B149","v":"XX1"},{"$f":"C135","v":"Tlh03"},{"$f":"IFERROR(VLOOKUP(D69,$A$15:$K$26,3+MATCH($B150,$D$14:$K$14,0),0)*$B69*D$81,0)","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,0,0]
[null,"XX1","Tlh04",{"$f":"IFERROR(VLOOKUP(D70,$A$15:$K$26,3+MATCH($B151,$D$14:$K$14,0),0)*$B70*D$81,0)","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,0,0]
[null,"XX1","Tlh05",{"$f":"IFERROR(VLOOKUP(D71,$A$15:$K$26,3+MATCH($B152,$D$14:$K$14,0),0)*$B71*D$81,0)","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,0,0]
[null,"XX1","Tlh06",{"$f":"IFERROR(VLOOKUP(D72,$A$15:$K$26,3+MATCH($B153,$D$14:$K$14,0),0)*$B72*D$81,0)","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,0,0]
[null,"XX1","Tlh07",{"$f":"IFERROR(VLOOKUP(D73,$A$15:$K$26,3+MATCH($B154,$D$14:$K$14,0),0)*$B73*D$81,0)","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,0,0]
[null,"XX1","Tlh08",{"$f":"IFERROR(VLOOKUP(D74,$A$15:$K$26,3+MATCH($B155,$D$14:$K$14,0),0)*$B74*D$81,0)","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,0,0]
[null,"XX1","Tlh09",{"$f":"IFERROR(VLOOKUP(D75,$A$15:$K$26,3+MATCH($B156,$D$14:$K$14,0),0)*$B75*D$81,0)","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,0,0]
[null,"XX1","Tlh10",{"$f":"IFERROR(VLOOKUP(D76,$A$15:$K$26,3+MATCH($B157,$D$14:$K$14,0),0)*$B76*D$81,0)","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,0,0]
[null,"XX1","Tlh11",{"$f":"IFERROR(VLOOKUP(D77,$A$15:$K$26,3+MATCH($B158,$D$14:$K$14,0),0)*$B77*D$81,0)","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,0,0]
[null,"XX1","Tlh12",{"$f":"IFERROR(VLOOKUP(D78,$A$15:$K$26,3+MATCH($B159,$D$14:$K$14,0),0)*$B78*D$81,0)","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,0,0]
[null,"XX1","Tlh13",{"$f":"IFERROR(VLOOKUP(D79,$A$15:$K$26,3+MATCH($B160,$D$14:$K$14,0),0)*$B79*D$81,0)","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,0,0]
[null,"XX1","Tlh14",{"$f":"IFERROR(VLOOKUP(D80,$A$15:$K$26,3+MATCH($B161,$D$14:$K$14,0),0)*$B80*D$81,0)","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,0,0]
["XX1",{"$f":"SUM(D162:AC162)","v":0},{"$f":"NPV(FC_Financeiro!$D$2,D162:AC162)","v":0},{"$f":"SUM(D148:D161)","v":0},{"$f":"SUM(E148:E161)","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,0]
[{"$f":"CONCATENATE(\"Volume Colhido \",$A$11)","v":"Volume Colhido XX2"},{"$f":"$A$11","v":"XX2"},{"$f":"C148","v":"Tlh01"},{"$f":"IFERROR(VLOOKUP(D67,$A$15:$K$26,3+MATCH($B163,$D$14:$K$14,0),0)*$B67*D$81,0)","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,0,0]
[null,{"$f":"B163","v":"XX2"},{"$f":"C149","v":"Tlh02"},{"$f":"IFERROR(VLOOKUP(D68,$A$15:$K$26,3+MATCH($B164,$D$14:$K$14,0),0)*$B68*D$81,0)","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,0,0]
[null,"XX2","Tlh03",{"$f":"IFERROR(VLOOKUP(D69,$A$15:$K$26,3+MATCH($B165,$D$14:$K$14,0),0)*$B69*D$81,0)","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,0,0]
[null,"XX2","Tlh04",{"$f":"IFERROR(VLOOKUP(D70,$A$15:$K$26,3+MATCH($B166,$D$14:$K$14,0),0)*$B70*D$81,0)","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,0,0]
[null,"XX2","Tlh05",{"$f":"IFERROR(VLOOKUP(D71,$A$15:$K$26,3+MATCH($B167,$D$14:$K$14,0),0)*$B71*D$81,0)","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,0,0]
[null,"XX2","Tlh06",{"$f":"IFERROR(VLOOKUP(D72,$A$15:$K$26,3+MATCH($B168,$D$14:$K$14,0),0)*$B72*D$81,0)","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,0,0]
[null,"XX2","Tlh07",{"$f":"IFERROR(VLOOKUP(D73,$A$15:$K$26,3+MATCH($B169,$D$14:$K$14,0),0)*$B73*D$81,0)","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,0,0]
[null,"XX2","Tlh08",{"$f":"IFERROR(VLOOKUP(D74,$A$15:$K$26,3+MATCH($B170,$D$14:$K$14,0),0)*$B74*D$81,0)","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,0,0]
[null,"XX2","Tlh09",{"$f":"IFERROR(VLOOKUP(D75,$A$15:$K$26,3+MATCH($B171,$D$14:$K$14,0),0)*$B75*D$81,0)","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,0,0]
[null,"XX2","Tlh10",{"$f":"IFERROR(VLOOKUP(D76,$A$15:$K$26,3+MATCH($B172,$D$14:$K$14,0),0)*$B76*D$81,0)","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,0,0]
[null,"XX2","Tlh11",{"$f":"IFERROR(VLOOKUP(D77,$A$15:$K$26,3+MATCH($B173,$D$14:$K$14,0),0)*$B77*D$81,0)","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,0,0]
[null,"XX2","Tlh12",{"$f":"IFERROR(VLOOKUP(D78,$A$15:$K$26,3+MATCH($B174,$D$14:$K$14,0),0)*$B78*D$81,0)","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,0,0]
[null,"XX2","Tlh13",{"$f":"IFERROR(VLOOKUP(D79,$A$15:$K$26,3+MATCH($B175,$D$14:$K$14,0),0)*$B79*D$81,0)","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,0,0]
[null,"XX2","Tlh14",{"$f":"IFERROR(VLOOKUP(D80,$A$15:$K$26,3+MATCH($B176,$D$14:$K$14,0),0)*$B80*D$81,0)","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,0,0]
[{"$f":"B176","v":"XX2"},{"$f":"SUM(D177:AC177)","v":0},{"$f":"NPV(FC_Financeiro!$D$2,D177:AC177)","v":0},{"$f":"SUM(D163:D176)","v":0},{"$f":"SUM(E163:E176)","v":0},{"$f":"SUM(F163:F176)","v":0},{"$f":"SUM(G163:G176)","v":0},{"$f":"SUM(H163:H176)","v":0},{"$f":"SUM(I163:I176)","v":0},{"$f":"SUM(J163:J176)","v":0},{"$f":"SUM(K163:K176)","v":0},{"$f":"SUM(L163:L176)","v":0},{"$f":"SUM(M163:M176)","v":0},{"$f":"SUM(N163:N176)","v":0},{"$f":"SUM(O163:O176)","v":0},{"$f":"SUM(P163:P176)","v":0},{"$f":"SUM(Q163:Q176)","v":0},{"$f":"SUM(R163:R176)","v":0},{"$f":"SUM(S163:S176)","v":0},{"$f":"SUM(T163:T176)","v":0},{"$f":"SUM(U163:U176)","v":0},{"$f":"SUM(V163:V176)","v":0},{"$f":"SUM(W163:W176)","v":0},{"$f":"SUM(X163:X176)","v":0},{"$f":"SUM(Y163:Y176)","v":0},{"$f":"SUM(Z163:Z176)","v":0},{"$f":"SUM(AA163:AA176)","v":0},{"$f":"SUM(AB163:AB176)","v":0},{"$f":"SUM(AC163:AC176)","v":0}]
["Área Colhida",{"$f":"A15","v":"CR5"},{"$f":"SUM(D178:AC178)","v":0},{"$f":"SUMIF(D$67:D$80,$B178,$B$67:$B$80)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF(N$67:N$80,$B178,$B$67:$B$80)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUMIF(X$67:X$80,$B178,$B$67:$B$80)","v":0},0,0,0,0,0]
[null,"CR6",12000,0,0,0,0,0,0,0,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,0,0,0,0,0,0,0]
[null,"CR7",0,0,0,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,"CR8",0]
[null,"CC5",0,0,0,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,"CC6",12000,0,0,0,0,0,0,0,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,0,0,0,0,0,0,0]
[null,"CC7",0,0,0,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,"CC8",0,0,0,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,"CF5",0,0,0,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,"CF6",12000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2000,2000,2000,2000,2000,2000,0]
[null,"CF7",0,0,0,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,"CF8",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Área Colhida (ha)",{"$f":"SUM(D190:AC190)","v":36000},null,{"$f":"SUM(D178:D188)","v":0},{"$f":"SUM(E178:E188)","v":0},0,0,0,0,0,{"$f":"SUM(K178:K188)","v":2000},2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,0]
["Produtividade média (m3/ha)",{"$f":"SUM(B132,B147,B162,B177)/B190","v":259.52511666666663},null,{"$f":"IF(D190>0,SUM(D132,D147,D162,D177)/D190,0)","v":0},{"$f":"IF(E190>0,SUM(E132,E147,E162,E177)/E190,0)","v":0},0,0,0,0,0,241.04499999999999,241.04499999999999,241.04499999999999,241.04499999999999,255.5077,255.5077,255.5077,255.5077,255.5077,269.97040000000004,269.97040000000004,269.97040000000004,269.97040000000004,269.97040000000004,269.97040000000004,269.97040000000004,269.97040000000004,269.97040000000004,0]
["Preço (R$/m3)",{"$f":"A132","v":"CEL"},{"$f":"VLOOKUP(B192,$A$8:$B$11,2,0)","v":90},{"$f":"$C192*FC_Financeiro!D16","v":94.949999999999989},{"$f":"$C192*FC_Financeiro!E16","v":100.17224999999999},{"$f":"$C192*FC_Financeiro!F16","v":104.17913999999999},{"$f":"$C192*FC_Financeiro!G16","v":108.34630560000001},{"$f":"$C192*FC_Financeiro!H16","v":112.68015782400001},{"$f":"$C192*FC_Financeiro!I16","v":117.18736413696001},{"$f":"$C192*FC_Financeiro!J16","v":121.87485870243842},{"$f":"$C192*FC_Financeiro!K16","v":126.74985305053595},{"$f":"$C192*FC_Financeiro!L16","v":131.81984717255739},{"$f":"$C192*FC_Financeiro!M16","v":137.09264105945968},{"$f":"$C192*FC_Financeiro!N16","v":142.57634670183808},{"$f":"$C192*FC_Financeiro!O16","v":148.27940056991162},{"$f":"$C192*FC_Financeiro!P16","v":154.21057659270809},{"$f":"$C192*FC_Financeiro!Q16","v":160.37899965641643},{"$f":"$C192*FC_Financeiro!R16","v":166.79415964267307},{"$f":"$C192*FC_Financeiro!S16","v":173.46592602838001},{"$f":"$C192*FC_Financeiro!T16","v":180.40456306951523},{"$f":"$C192*FC_Financeiro!U16","v":187.62074559229583},{"$f":"$C192*FC_Financeiro!V16","v":195.12557541598767},{"$f":"$C192*FC_Financeiro!W16","v":202.93059843262719},{"$f":"$C192*FC_Financeiro!X16","v":211.04782236993228},{"$f":"$C192*FC_Financeiro!Y16","v":219.48973526472957},{"$f":"$C192*FC_Financeiro!Z16","v":228.26932467531876},{"$f":"$C192*FC_Financeiro!AA16","v":237.40009766233149},{"$f":"$C192*FC_Financeiro!AB16","v":246.89610156882475},{"$f":"$C192*FC_Financeiro!AC16","v":256.77194563157775}]
[null,{"$f":"A147","v":"BIO"},{"$f":"VLOOKUP(B193,$A$8:$B$11,2,0)","v":0},{"$f":"$C193*FC_Financeiro!D16","v":0},{"$f":"$C193*FC_Financeiro!E16","v":0},{"$f":"$C193*FC_Financeiro!F16","v":0},{"$f":"$C193*FC_Financeiro!G16","v":0},{"$f":"$C193*FC_Financeiro!H16","v":0},{"$f":"$C193*FC_Financeiro!I16","v":0},{"$f":"$C193*FC_Financeiro!J16","v":0},{"$f":"$C193*FC_Financeiro!K16","v":0},{"$f":"$C193*FC_Financeiro!L16","v":0},{"$f":"$C193*FC_Financeiro!M16","v":0},{"$f":"$C193*FC_Financeiro!N16","v":0},{"$f":"$C193*FC_Financeiro!O16","v":0},{"$f":"$C193*FC_Financeiro!P16","v":0},{"$f":"$C193*FC_Financeiro!Q16","v":0},{"$f":"$C193*FC_Financeiro!R16","v":0},{"$f":"$C193*FC_Financeiro!S16","v":0},{"$f":"$C193*FC_Financeiro!T16","v":0},{"$f":"$C193*FC_Financeiro!U16","v":0},{"$f":"$C193*FC_Financeiro!V16","v":0},{"$f":"$C193*FC_Financeiro!W16","v":0},{"$f":"$C193*FC_Financeiro!X16","v":0},{"$f":"$C193*FC_Financeiro!Y16","v":0},{"$f":"$C193*FC_Financeiro!Z16","v":0},{"$f":"$C193*FC_Financeiro!AA16","v":0},{"$f":"$C193*FC_Financeiro!AB16","v":0},{"$f":"$C193*FC_Financeiro!AC16","v":0}]
[null,{"$f":"A162","v":"XX1"},0,{"$f":"$C194*FC_Financeiro!D17","v":0},{"$f":"$C194*FC_Financeiro!E17","v":0},{"$f":"$C194*FC_Financeiro!F17","v":0},{"$f":"$C194*FC_Financeiro!G17","v":0},{"$f":"$C194*FC_Financeiro!H17","v":0},{"$f":"$C194*FC_Financeiro!I17","v":0},{"$f":"$C194*FC_Financeiro!J17","v":0},{"$f":"$C194*FC_Financeiro!K17","v":0},{"$f":"$C194*FC_Financeiro!L17","v":0},{"$f":"$C194*FC_Financeiro!M17","v":0},{"$f":"$C194*FC_Financeiro!N17","v":0},{"$f":"$C194*FC_Financeiro!O17","v":0},{"$f":"$C194*FC_Financeiro!P17","v":0},{"$f":"$C194*FC_Financeiro!Q17","v":0},{"$f":"$C194*FC_Financeiro!R17","v":0},{"$f":"$C194*FC_Financeiro!S17","v":0},{"$f":"$C194*FC_Financeiro!T17","v":0},{"$f":"$C194*FC_Financeiro!U17","v":0},{"$f":"$C194*FC_Financeiro!V17","v":0},{"$f":"$C194*FC_Financeiro!W17","v":0},{"$f":"$C194*FC_Financeiro!X17","v":0},{"$f":"$C194*FC_Financeiro!Y17","v":0},{"$f":"$C194*FC_Financeiro!Z17","v":0},{"$f":"$C194*FC_Financeiro!AA17","v":0},{"$f":"$C194*FC_Financeiro!AB17","v":0},{"$f":"$C194*FC_Financeiro!AC17","v":0}]
[null,{"$f":"A177","v":"XX2"},0,{"$f":"$C195*FC_Financeiro!D18","v":0},{"$f":"$C195*FC_Financeiro!E18","v":0},{"$f":"$C195*FC_Financeiro!F18","v":0},{"$f":"$C195*FC_Financeiro!G18","v":0},{"$f":"$C195*FC_Financeiro!H18","v":0},{"$f":"$C195*FC_Financeiro!I18","v":0},{"$f":"$C195*FC_Financeiro!J18","v":0},{"$f":"$C195*FC_Financeiro!K18","v":0},{"$f":"$C195*FC_Financeiro!L18","v":0},{"$f":"$C195*FC_Financeiro!M18","v":0},{"$f":"$C195*FC_Financeiro!N18","v":0},{"$f":"$C195*FC_Financeiro!O18","v":0},{"$f":"$C195*FC_Financeiro!P18","v":0},{"$f":"$C195*FC_Financeiro!Q18","v":0},{"$f":"$C195*FC_Financeiro!R18","v":0},{"$f":"$C195*FC_Financeiro!S18","v":0},{"$f":"$C195*FC_Financeiro!T18","v":0},{"$f":"$C195*FC_Financeiro!U18","v":0},{"$f":"$C195*FC_Financeiro!V18","v":0},{"$f":"$C195*FC_Financeiro!W18","v":0},{"$f":"$C195*FC_Financeiro!X18","v":0},{"$f":"$C195*FC_Financeiro!Y18","v":0},{"$f":"$C195*FC_Financeiro!Z18","v":0},{"$f":"$C195*FC_Financeiro!AA18","v":0},{"$f":"$C195*FC_Financeiro!AB18","v":0},{"$f":"$C195*FC_Financeiro!AC18","v":0}]
["Receitas (mil R$)",{"$f":"B192","v":"CEL"},null,{"$f":"D192*D$132/1000","v":0},{"$f":"E192*E$132/1000","v":0},0,0,0,0,0,61104.836657132873,63549.03012341819,66090.99132835491,{"$f":"N192*N$132/1000","v":68734.630981489128},75773.05719399362,78803.979481753369,81956.138661023506,85234.384207464434,88643.759575763033,97407.784107404514,101304.0954717007,105356.25929056872,109570.50966219149,113953.33004867914,118511.46325062632,123251.92178065136,128181.99865187741,133309.27859795251,0]
[null,{"$f":"B193","v":"BIO"},null,{"$f":"D193*D$147/1000","v":0},{"$f":"E193*E$147/1000","v":0},0,0,0,0,0,0,0,0,{"$f":"N193*N$147/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B194","v":"XX1"},null,{"$f":"D194*D$162/1000","v":0},{"$f":"E194*E$162/1000","v":0},0,0,0,0,0,0,0,0,{"$f":"N194*N$162/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B195","v":"XX2"},null,{"$f":"D195*D$177/1000","v":0},{"$f":"E195*E$177/1000","v":0},0,0,0,0,0,0,0,0,{"$f":"N195*N$177/1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Receita (mil R$)",{"$f":"SUM(D200:AC200)","v":1700737.4490720455},{"$f":"NPV(FC_Financeiro!$D$2,D200:AC200)","v":353321.74551590823},{"$f":"SUM(D196:D199)","v":0},{"$f":"SUM(E196:E199)","v":0},0,0,0,0,0,61104.836657132873,63549.03012341819,66090.99132835491,68734.630981489128,75773.05719399362,78803.979481753369,81956.138661023506,85234.384207464434,88643.759575763033,97407.784107404514,101304.0954717007,105356.25929056872,109570.50966219149,113953.33004867914,118511.46325062632,123251.92178065136,128181.99865187741,133309.27859795251,0]
["Compra da Terra (mil R$)",{"$f":"SUM(D201:AC201)","v":-114213.57932640382},{"$f":"NPV(FC_Financeiro!$D$2,D201:AC201)","v":-81513.791412516774},{"$f":"D$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!D$16*FC_Financeiro!D$17/-1000","v":-16141.499999999998},{"$f":"E$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!E$16*FC_Financeiro!E$17/-1000","v":-17369.868149999998},{"$f":"F$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!F$16*FC_Financeiro!F$17/-1000","v":-18425.956133520001},{"$f":"G$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!G$16*FC_Financeiro!G$17/-1000","v":-19546.25426643802},{"$f":"H$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!H$16*FC_Financeiro!H$17/-1000","v":-20734.666525837449},{"$f":"I$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!I$16*FC_Financeiro!I$17/-1000","v":-21995.334250608368},{"$f":"J$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!J$16*FC_Financeiro!J$17/-1000","v":0},{"$f":"K$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!K$16*FC_Financeiro!K$17/-1000","v":0},{"$f":"L$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!L$16*FC_Financeiro!L$17/-1000","v":0},{"$f":"M$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!M$16*FC_Financeiro!M$17/-1000","v":0},{"$f":"N$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!N$16*FC_Financeiro!N$17/-1000","v":0},{"$f":"O$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!O$16*FC_Financeiro!O$17/-1000","v":0},{"$f":"P$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!P$16*FC_Financeiro!P$17/-1000","v":0},{"$f":"Q$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Q$16*FC_Financeiro!Q$17/-1000","v":0},{"$f":"R$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!R$16*FC_Financeiro!R$17/-1000","v":0},{"$f":"S$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!S$16*FC_Financeiro!S$17/-1000","v":0},{"$f":"T$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!T$16*FC_Financeiro!T$17/-1000","v":0},{"$f":"U$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!U$16*FC_Financeiro!U$17/-1000","v":0},{"$f":"V$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!V$16*FC_Financeiro!V$17/-1000","v":0},{"$f":"W$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!W$16*FC_Financeiro!W$17/-1000","v":0},{"$f":"X$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!X$16*FC_Financeiro!X$17/-1000","v":0},{"$f":"Y$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Y$16*FC_Financeiro!Y$17/-1000","v":0},{"$f":"Z$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Z$16*FC_Financeiro!Z$17/-1000","v":0},{"$f":"AA$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AA$16*FC_Financeiro!AA$17/-1000","v":0},{"$f":"AB$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AB$16*FC_Financeiro!AB$17/-1000","v":0},{"$f":"AC$85*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AC$16*FC_Financeiro!AC$17/-1000","v":0}]
["Venda Da Terra (mil R$)",{"$f":"SUM(D202:AC202)","v":372625.28158850491},{"$f":"NPV(FC_Financeiro!$D$2,D202:AC202)","v":39552.484527126224},{"$f":"D$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!D$16*FC_Financeiro!D$17/1000","v":0},{"$f":"E$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!E$16*FC_Financeiro!E$17/1000","v":0},{"$f":"F$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!F$16*FC_Financeiro!F$17/1000","v":0},{"$f":"G$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!G$16*FC_Financeiro!G$17/1000","v":0},{"$f":"H$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!H$16*FC_Financeiro!H$17/1000","v":0},{"$f":"I$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!I$16*FC_Financeiro!I$17/1000","v":0},{"$f":"J$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!J$16*FC_Financeiro!J$17/1000","v":0},{"$f":"K$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!K$16*FC_Financeiro!K$17/1000","v":0},{"$f":"L$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!L$16*FC_Financeiro!L$17/1000","v":0},{"$f":"M$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!M$16*FC_Financeiro!M$17/1000","v":0},{"$f":"N$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!N$16*FC_Financeiro!N$17/1000","v":0},{"$f":"O$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!O$16*FC_Financeiro!O$17/1000","v":0},{"$f":"P$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!P$16*FC_Financeiro!P$17/1000","v":0},{"$f":"Q$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Q$16*FC_Financeiro!Q$17/1000","v":0},{"$f":"R$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!R$16*FC_Financeiro!R$17/1000","v":0},{"$f":"S$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!S$16*FC_Financeiro!S$17/1000","v":0},{"$f":"T$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!T$16*FC_Financeiro!T$17/1000","v":0},{"$f":"U$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!U$16*FC_Financeiro!U$17/1000","v":0},{"$f":"V$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!V$16*FC_Financeiro!V$17/1000","v":0},{"$f":"W$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!W$16*FC_Financeiro!W$17/1000","v":0},{"$f":"X$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!X$16*FC_Financeiro!X$17/1000","v":53313.013553175559},{"$f":"Y$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Y$16*FC_Financeiro!Y$17/1000","v":56554.444777208635},{"$f":"Z$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Z$16*FC_Financeiro!Z$17/1000","v":59992.955019662906},{"$f":"AA$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AA$16*FC_Financeiro!AA$17/1000","v":63640.526684858422},{"$f":"AB$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AB$16*FC_Financeiro!AB$17/1000","v":67509.870707297814},{"$f":"AC$89*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AC$16*FC_Financeiro!AC$17/1000","v":71614.470846301512}]
["Valor da Terra (mil R$)",null,null,{"$f":"D$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!D$16*FC_Financeiro!D$17/1000","v":16141.499999999998},{"$f":"E$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!E$16*FC_Financeiro!E$17/1000","v":34739.736299999997},{"$f":"F$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!F$16*FC_Financeiro!F$17/1000","v":55277.868400560001},{"$f":"G$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!G$16*FC_Financeiro!G$17/1000","v":78185.017065752079},{"$f":"H$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!H$16*FC_Financeiro!H$17/1000","v":103673.33262918725},{"$f":"I$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!I$16*FC_Financeiro!I$17/1000","v":131972.0055036502},{"$f":"J$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!J$16*FC_Financeiro!J$17/1000","v":139995.90343827216},{"$f":"K$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!K$16*FC_Financeiro!K$17/1000","v":148507.65436731908},{"$f":"L$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!L$16*FC_Financeiro!L$17/1000","v":157536.91975285209},{"$f":"M$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!M$16*FC_Financeiro!M$17/1000","v":167115.16447382551},{"$f":"N$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!N$16*FC_Financeiro!N$17/1000","v":177275.76647383411},{"$f":"O$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!O$16*FC_Financeiro!O$17/1000","v":188054.13307544327},{"$f":"P$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!P$16*FC_Financeiro!P$17/1000","v":199487.82436643017},{"$f":"Q$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Q$16*FC_Financeiro!Q$17/1000","v":211616.68408790918},{"$f":"R$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!R$16*FC_Financeiro!R$17/1000","v":224482.97848045407},{"$f":"S$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!S$16*FC_Financeiro!S$17/1000","v":238131.54357206568},{"$f":"T$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!T$16*FC_Financeiro!T$17/1000","v":252609.94142124729},{"$f":"U$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!U$16*FC_Financeiro!U$17/1000","v":267968.62585965911},{"$f":"V$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!V$16*FC_Financeiro!V$17/1000","v":284261.11831192643},{"$f":"W$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!W$16*FC_Financeiro!W$17/1000","v":301544.19430529157},{"$f":"X$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!X$16*FC_Financeiro!X$17/1000","v":266565.06776587776},{"$f":"Y$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Y$16*FC_Financeiro!Y$17/1000","v":226217.77910883454},{"$f":"Z$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!Z$16*FC_Financeiro!Z$17/1000","v":179978.86505898874},{"$f":"AA$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AA$16*FC_Financeiro!AA$17/1000","v":127281.05336971681},{"$f":"AB$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AB$16*FC_Financeiro!AB$17/1000","v":67509.870707297785},{"$f":"AC$93*(SUMPRODUCT($F$36:$F$38,$H$36:$H$38))*FC_Financeiro!AC$16*FC_Financeiro!AC$17/1000","v":0}]
["Investim. Máquinas (mil R$)",null,null,{"$f":"D113*$H$31","v":0},-267.12600000000003,-312.53742,-335.87354736000003,-360.57650503679997,-386.71830165196803,-414.37451958829064,-346.44959833813158,-360.30758227165677,-374.71988556252307,-389.7086809850241,-405.29702822442505,-421.50890935340215,-438.36926572753822,-455.90403635663966,-474.14019781090531,-493.10580572334158,-512.83003795227535,-533.34323947036626,-148.81577218392658,-84.419128947972879,-65.846920579418878,-45.653864935063744,-23.740009766233147,0,0]
["Arrendamento (mil R$)",{"$f":"SUM(D205:AC205)","v":0},{"$f":"NPV(FC_Financeiro!$D$2,D205:AC205)","v":0},{"$f":"D95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!D$16*FC_Financeiro!D$17/-1000","v":0},{"$f":"E95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!E$16*FC_Financeiro!E$17/-1000","v":0},{"$f":"F95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!F$16*FC_Financeiro!F$17/-1000","v":0},{"$f":"G95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!G$16*FC_Financeiro!G$17/-1000","v":0},{"$f":"H95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!H$16*FC_Financeiro!H$17/-1000","v":0},{"$f":"I95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!I$16*FC_Financeiro!I$17/-1000","v":0},{"$f":"J95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!J$16*FC_Financeiro!J$17/-1000","v":0},{"$f":"K95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!K$16*FC_Financeiro!K$17/-1000","v":0},{"$f":"L95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!L$16*FC_Financeiro!L$17/-1000","v":0},{"$f":"M95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!M$16*FC_Financeiro!M$17/-1000","v":0},{"$f":"N95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!N$16*FC_Financeiro!N$17/-1000","v":0},{"$f":"O95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!O$16*FC_Financeiro!O$17/-1000","v":0},{"$f":"P95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!P$16*FC_Financeiro!P$17/-1000","v":0},{"$f":"Q95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!Q$16*FC_Financeiro!Q$17/-1000","v":0},{"$f":"R95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!R$16*FC_Financeiro!R$17/-1000","v":0},{"$f":"S95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!S$16*FC_Financeiro!S$17/-1000","v":0},{"$f":"T95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!T$16*FC_Financeiro!T$17/-1000","v":0},{"$f":"U95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!U$16*FC_Financeiro!U$17/-1000","v":0},{"$f":"V95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!V$16*FC_Financeiro!V$17/-1000","v":0},{"$f":"W95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!W$16*FC_Financeiro!W$17/-1000","v":0},{"$f":"X95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!X$16*FC_Financeiro!X$17/-1000","v":0},{"$f":"Y95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!Y$16*FC_Financeiro!Y$17/-1000","v":0},{"$f":"Z95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!Z$16*FC_Financeiro!Z$17/-1000","v":0},{"$f":"AA95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!AA$16*FC_Financeiro!AA$17/-1000","v":0},{"$f":"AB95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!AB$16*FC_Financeiro!AB$17/-1000","v":0},{"$f":"AC95*SUMPRODUCT($G$36:$G$38,$H$36:$H$38)*FC_Financeiro!AC$16*FC_Financeiro!AC$17/-1000","v":0}]
["Gestão Florestal(mil R$)",{"$f":"SUM(D206:AC206)","v":-42274.197756208559},{"$f":"NPV(FC_Financeiro!$D$2,D206:AC206)","v":-12599.516292230517},{"$f":"D$96*$H$30*FC_Financeiro!D$16/-1000","v":-211},{"$f":"E$96*$H$30*FC_Financeiro!E$16/-1000","v":-445.21},{"$f":"F$96*$H$30*FC_Financeiro!F$16/-1000","v":-694.52760000000001},{"$f":"G$96*$H$30*FC_Financeiro!G$16/-1000","v":-963.07827200000008},{"$f":"H$96*$H$30*FC_Financeiro!H$16/-1000","v":-1252.0017536000003},{"$f":"I$96*$H$30*FC_Financeiro!I$16/-1000","v":-1562.4981884928002},{"$f":"J$96*$H$30*FC_Financeiro!J$16/-1000","v":-1624.9981160325121},{"$f":"K$96*$H$30*FC_Financeiro!K$16/-1000","v":-1689.9980406738125},{"$f":"L$96*$H$30*FC_Financeiro!L$16/-1000","v":-1757.5979623007652},{"$f":"M$96*$H$30*FC_Financeiro!M$16/-1000","v":-1827.901880792796},{"$f":"N$96*$H$30*FC_Financeiro!N$16/-1000","v":-1901.0179560245078},{"$f":"O$96*$H$30*FC_Financeiro!O$16/-1000","v":-1977.0586742654882},{"$f":"P$96*$H$30*FC_Financeiro!P$16/-1000","v":-2056.1410212361079},{"$f":"Q$96*$H$30*FC_Financeiro!Q$16/-1000","v":-2138.3866620855524},{"$f":"R$96*$H$30*FC_Financeiro!R$16/-1000","v":-2223.9221285689741},{"$f":"S$96*$H$30*FC_Financeiro!S$16/-1000","v":-2312.8790137117335},{"$f":"T$96*$H$30*FC_Financeiro!T$16/-1000","v":-2405.3941742602028},{"$f":"U$96*$H$30*FC_Financeiro!U$16/-1000","v":-2501.6099412306107},{"$f":"V$96*$H$30*FC_Financeiro!V$16/-1000","v":-2601.6743388798354},{"$f":"W$96*$H$30*FC_Financeiro!W$16/-1000","v":-2705.7413124350292},{"$f":"X$96*$H$30*FC_Financeiro!X$16/-1000","v":-2344.9758041103587},{"$f":"Y$96*$H$30*FC_Financeiro!Y$16/-1000","v":-1951.0198690198185},{"$f":"Z$96*$H$30*FC_Financeiro!Z$16/-1000","v":-1521.7954978354583},{"$f":"AA$96*$H$30*FC_Financeiro!AA$16/-1000","v":-1055.1115451659175},{"$f":"AB$96*$H$30*FC_Financeiro!AB$16/-1000","v":-548.65800348627715},{"$f":"AC$96*$H$30*FC_Financeiro!AC$16/-1000","v":0}]
["Exaustão (mil R$)",{"$f":"SUM(D207:AC207)","v":-255045.54192753014},{"$f":"B113/B200","v":-0.14996173693163975},{"$f":"$C$207*D200","v":0},{"$f":"$C$207*E200","v":0},0,0,0,0,0,-9163.3874400277764,-9529.9229376288877,-9911.1198551340422,-10307.564649339409,-11363.059269431764,-11817.581640209035,-12290.284905817398,-12781.896302050091,-13293.172154132099,-14607.440495408555,-15191.738115224898,-15799.407639833893,-16431.383945427249,-17088.639303244341,-17772.184875374114,-18483.072270389079,-19222.39516120464,-19991.290967652825,0]
["Impostos Federais (mil R$)",{"$f":"SUM(D208:AC208)","v":-114459.63032254865},{"$f":"NPV(FC_Financeiro!$D$2,D208:AC208)","v":-23778.553473220625},{"$f":"-D200*FC_Financeiro!$D$10","v":0},{"$f":"-E200*FC_Financeiro!$D$10","v":0},{"$f":"-F200*FC_Financeiro!$D$10","v":0},{"$f":"-G200*FC_Financeiro!$D$10","v":0},{"$f":"-H200*FC_Financeiro!$D$10","v":0},{"$f":"-I200*FC_Financeiro!$D$10","v":0},{"$f":"-J200*FC_Financeiro!$D$10","v":0},{"$f":"-K200*FC_Financeiro!$D$10","v":-4112.3555070250422},{"$f":"-L200*FC_Financeiro!$D$10","v":-4276.8497273060439},{"$f":"-M200*FC_Financeiro!$D$10","v":-4447.9237163982853},{"$f":"-N200*FC_Financeiro!$D$10","v":-4625.8406650542183},{"$f":"-O200*FC_Financeiro!$D$10","v":-5099.5267491557706},{"$f":"-P200*FC_Financeiro!$D$10","v":-5303.5078191220018},{"$f":"-Q200*FC_Financeiro!$D$10","v":-5515.6481318868819},{"$f":"-R200*FC_Financeiro!$D$10","v":-5736.2740571623563},{"$f":"-S200*FC_Financeiro!$D$10","v":-5965.7250194488524},{"$f":"-T200*FC_Financeiro!$D$10","v":-6555.5438704283233},{"$f":"-U200*FC_Financeiro!$D$10","v":-6817.7656252454572},{"$f":"-V200*FC_Financeiro!$D$10","v":-7090.4762502552749},{"$f":"-W200*FC_Financeiro!$D$10","v":-7374.0953002654869},{"$f":"-X200*FC_Financeiro!$D$10","v":-7669.0591122761061},{"$f":"-Y200*FC_Financeiro!$D$10","v":-7975.8214767671507},{"$f":"-Z200*FC_Financeiro!$D$10","v":-8294.8543358378374},{"$f":"-AA200*FC_Financeiro!$D$10","v":-8626.6485092713501},{"$f":"-AB200*FC_Financeiro!$D$10","v":-8971.7144496422043},{"$f":"-AC200*FC_Financeiro!$D$10","v":0}]
[]
["Fluxo de Caixa Final (mil R$)",{"$f":"SUM(D210:AC210)","v":783835.10437134642},{"$f":"NPV(FC_Financeiro!$D$2,D210:AC210)","v":20429.344442483492},{"$f":"D116+D200+D201+D202+D204+D205+D206+D208","v":-16352.499999999998},{"$f":"E116+E200+E201+E202+E204+E205+E206+E208","v":-26986.404149999998},-29850.935153520004,-32040.990997798017,-34366.461619034249,-36835.160795818738,-15851.856621897157,{"$f":"K116+K200+K201+K202+K204+K205+K206+K208","v":16250.008385543553},16900.008720965299,17576.009069803906,18279.049432596075,21104.359493092157,21948.533872815849,22826.475227728482,23739.534236837622,24689.115606311134,28224.531574034809,29353.512836996193,30527.653350476052,45683.327243535503,103707.99412550821,110206.56096409848,117082.14570135874,124355.91443504571,132050.20858636519,71614.470846301512]
["TIR%",{"$f":"IRR(D210:AC210)","v":0.11124550594749327}]

{"sheet":"FC_Financeiro","index":2,"n_rows":70,"n_cols":29,"rows_kept":70,"cut":false,"hidden":false,"merged":[[56,2,56,6],[65,2,65,6],[10,2,11,2],[28,2,28,6],[34,2,34,6],[39,2,39,6],[44,2,44,6],[47,2,47,6],[51,2,51,6]]}
[null,null,"Premissas"]
[null,null,"Taxa de atratividade",0.1,"a.a."]
[null,null,"Selic",0.105,"a.a."]
[null,null,"Ano Zero",2014]
[null,null,"Variação real do preço de Terra",0.02,"a.a."]
[null,null,"PIS",6.4999999999999997E-3,"sobre o faturamento"]
[null,null,"Cofins",0.03,"sobre o faturamento"]
[null,null,"IRPJ",0.02,"(8% sobre faturamento = Lucro presumido) * (alíquota 25%)"]
[null,null,"CSLL",1.0800000000000001E-2,"(12% sobre faturamento = base de cálculo) * (alíquota de 9%)"]
[null,null,"Impostos sobre Faturamento",{"$f":"SUM(D6:D9)","v":6.7299999999999999E-2},"Lucro Presumido de empresa Rural (Pis, Cofins, IR, CSLL)"]
[null,null,"Pagamento ao capitalista",0.9,"do saldo acumulado do ano anterior"]
[null,null,null,10000,"quando o saldo acum anterior ultrapassa esse valor"]
[]
[null,null,null,{"$f":"D4+1","v":2015},{"$f":"D14+1","v":2016},{"$f":"E14+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,null,"Inflação",5.5E-2,5.5E-2,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,"Índice IPCA",{"$f":"(1+$D$15)","v":1.0549999999999999},{"$f":"(1+E15)*D16","v":1.1130249999999999},{"$f":"(1+F15)*E16","v":1.157546},1.2038478400000001,1.2520017536000001,1.3020818237440002,1.3541650966937602,1.4083317005615106,1.464664968583971,1.5232515673273299,1.5841816300204232,1.6475488952212403,1.7134508510300899,1.7819888850712935,1.8532684404741453,1.9273991780931112,2.0044951452168358,2.0846749510255091,2.1680619490665296,2.254784427029191,2.3449758041103586,2.438774836274773,2.5363258297257638,2.6377788629147942,2.7432900174313861,2.8530216181286416]
[null,null,"Índice Preço de Terra",{"$f":"(1+$D$5)","v":1.02},{"$f":"(1+$D$5)*D17","v":1.0404},{"$f":"(1+$D$5)*E17","v":1.0612079999999999},1.08243216,1.1040808032,1.1261624192640001,1.14868566764928,1.1716593810022657,1.1950925686223111,1.2189944199947573,1.2433743083946525,1.2682417945625455,1.2936066304537963,1.3194787630628724,1.3458683383241299,1.3727857050906125,1.4002414191924248,1.4282462475762734,1.4568111725277988,1.4859473959783549,1.5156663438979221,1.5459796707758806,1.5768992641913981,1.6084372494752261,1.6406059944647307,1.6734181143540252]
[]
[null,null,"Fluxo de Caixa",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,26]
[null,"TIR","Ano",{"$f":"D14","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040]
[null,null,"Receitas (mil R$)",{"$f":"FC_Florestal!D200","v":0},{"$f":"FC_Florestal!E200","v":0},{"$f":"FC_Florestal!F200","v":0},{"$f":"FC_Florestal!G200","v":0},{"$f":"FC_Florestal!H200","v":0},{"$f":"FC_Florestal!I200","v":0},{"$f":"FC_Florestal!J200","v":0},{"$f":"FC_Florestal!K200","v":61104.836657132873},{"$f":"FC_Florestal!L200","v":63549.03012341819},{"$f":"FC_Florestal!M200","v":66090.99132835491},{"$f":"FC_Florestal!N200","v":68734.630981489128},{"$f":"FC_Florestal!O200","v":75773.05719399362},{"$f":"FC_Florestal!P200","v":78803.979481753369},{"$f":"FC_Florestal!Q200","v":81956.138661023506},{"$f":"FC_Florestal!R200","v":85234.384207464434},{"$f":"FC_Florestal!S200","v":88643.759575763033},{"$f":"FC_Florestal!T200","v":97407.784107404514},{"$f":"FC_Florestal!U200","v":101304.0954717007},{"$f":"FC_Florestal!V200","v":105356.25929056872},{"$f":"FC_Florestal!W200","v":109570.50966219149},{"$f":"FC_Florestal!X200","v":113953.33004867914},{"$f":"FC_Florestal!Y200","v":118511.46325062632},{"$f":"FC_Florestal!Z200","v":123251.92178065136},{"$f":"FC_Florestal!AA200","v":128181.99865187741},{"$f":"FC_Florestal!AB200","v":133309.27859795251},{"$f":"FC_Florestal!AC200","v":0}]
[null,null,"Deduções da Receita (Ex comissões)",0,0,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,"PIS & Cofins (mil R$)",{"$f":"-($D$6+$D$7)*D21","v":0},{"$f":"-($D$6+$D$7)*E21","v":0},0,0,0,0,0,-2230.3265379853497,-2319.5395995047638,-2412.321183484954,-2508.8140308243528,-2765.7165875807668,-2876.3452510839979,-2991.399061127358,-3111.0550235724518,-3235.4972245153504,-3555.3841199202643,-3697.599484717075,-3845.5034641057582,-3999.3236026699888,-4159.2965467767881,-4325.6684086478599,-4498.6951449937742,-4678.6429507935254,-4865.7886688252665,0]
[]
[null,null,"Despesas Operacionais (mil R$)",{"$f":"FC_Florestal!D116","v":0},{"$f":"FC_Florestal!E116","v":-8904.2000000000007},{"$f":"FC_Florestal!F116","v":-10417.914000000001},{"$f":"FC_Florestal!G116","v":-11195.784912000001},{"$f":"FC_Florestal!H116","v":-12019.21683456},{"$f":"FC_Florestal!I116","v":-12890.610055065601},{"$f":"FC_Florestal!J116","v":-13812.483986276355},{"$f":"FC_Florestal!K116","v":-38706.025125552333},{"$f":"FC_Florestal!L116","v":-40254.266130574426},{"$f":"FC_Florestal!M116","v":-41864.436775797396},{"$f":"FC_Florestal!N116","v":-43539.014246829305},{"$f":"FC_Florestal!O116","v":-47186.815249255778},{"$f":"FC_Florestal!P116","v":-49074.287859226009},{"$f":"FC_Florestal!Q116","v":-51037.25937359505},{"$f":"FC_Florestal!R116","v":-53078.749748538845},{"$f":"FC_Florestal!S116","v":-55201.89973848041},{"$f":"FC_Florestal!T116","v":-59729.20868295784},{"$f":"FC_Florestal!U116","v":-62118.377030276155},{"$f":"FC_Florestal!V116","v":-64603.112111487193},{"$f":"FC_Florestal!W116","v":-53658.530033771545},{"$f":"FC_Florestal!X116","v":-53459.895431012046},{"$f":"FC_Florestal!Y116","v":-54866.658797370095},{"$f":"FC_Florestal!Z116","v":-56300.42740034718},{"$f":"FC_Florestal!AA116","v":-57761.110837486616},{"$f":"FC_Florestal!AB116","v":-59248.568265756665},{"$f":"FC_Florestal!AC116","v":0}]
[null,null,"Arrendamento (mil R$)",{"$f":"FC_Florestal!D205","v":0},{"$f":"FC_Florestal!E205","v":0},{"$f":"FC_Florestal!F205","v":0},{"$f":"FC_Florestal!G205","v":0},{"$f":"FC_Florestal!H205","v":0},{"$f":"FC_Florestal!I205","v":0},{"$f":"FC_Florestal!J205","v":0},{"$f":"FC_Florestal!K205","v":0},{"$f":"FC_Florestal!L205","v":0},{"$f":"FC_Florestal!M205","v":0},{"$f":"FC_Florestal!N205","v":0},{"$f":"FC_Florestal!O205","v":0},{"$f":"FC_Florestal!P205","v":0},{"$f":"FC_Florestal!Q205","v":0},{"$f":"FC_Florestal!R205","v":0},{"$f":"FC_Florestal!S205","v":0},{"$f":"FC_Florestal!T205","v":0},{"$f":"FC_Florestal!U205","v":0},{"$f":"FC_Florestal!V205","v":0},{"$f":"FC_Florestal!W205","v":0},{"$f":"FC_Florestal!X205","v":0},{"$f":"FC_Florestal!Y205","v":0},{"$f":"FC_Florestal!Z205","v":0},{"$f":"FC_Florestal!AA205","v":0},{"$f":"FC_Florestal!AB205","v":0},{"$f":"FC_Florestal!AC205","v":0}]
[null,null,"Gestão Florestal (mil R$)",{"$f":"FC_Florestal!D206","v":-211},{"$f":"FC_Florestal!E206","v":-445.21},{"$f":"FC_Florestal!F206","v":-694.52760000000001},{"$f":"FC_Florestal!G206","v":-963.07827200000008},{"$f":"FC_Florestal!H206","v":-1252.0017536000003},{"$f":"FC_Florestal!I206","v":-1562.4981884928002},{"$f":"FC_Florestal!J206","v":-1624.9981160325121},{"$f":"FC_Florestal!K206","v":-1689.9980406738125},{"$f":"FC_Florestal!L206","v":-1757.5979623007652},{"$f":"FC_Florestal!M206","v":-1827.901880792796},{"$f":"FC_Florestal!N206","v":-1901.0179560245078},{"$f":"FC_Florestal!O206","v":-1977.0586742654882},{"$f":"FC_Florestal!P206","v":-2056.1410212361079},{"$f":"FC_Florestal!Q206","v":-2138.3866620855524},{"$f":"FC_Florestal!R206","v":-2223.9221285689741},{"$f":"FC_Florestal!S206","v":-2312.8790137117335},{"$f":"FC_Florestal!T206","v":-2405.3941742602028},{"$f":"FC_Florestal!U206","v":-2501.6099412306107},{"$f":"FC_Florestal!V206","v":-2601.6743388798354},{"$f":"FC_Florestal!W206","v":-2705.7413124350292},{"$f":"FC_Florestal!X206","v":-2344.9758041103587},{"$f":"FC_Florestal!Y206","v":-1951.0198690198185},{"$f":"FC_Florestal!Z206","v":-1521.7954978354583},{"$f":"FC_Florestal!AA206","v":-1055.1115451659175},{"$f":"FC_Florestal!AB206","v":-548.65800348627715},{"$f":"FC_Florestal!AC206","v":0}]
[]
[null,null,"Earnings Before Interest, Taxes, Depreciation and Amortization - EBITDA"]
[null,{"$f":"IRR(D30:AC30)","v":0.202022646955478},"EBITDA (mil R$)",{"$f":"SUM(D21:D27)","v":-211},{"$f":"SUM(E21:E27)","v":-9349.41},-11112.4416,-12158.863184000002,-13271.21858816,-14453.108243558401,-15437.482102308866,18478.486952921379,19217.626431038232,19986.33148827976,20785.784747810954,23843.466682891583,24797.205350207252,25789.093564215542,26820.657306784164,27893.483599055544,31717.797130266212,32986.509015476848,34305.969376095934,49206.914713314924,53989.162266779946,57368.116175588541,60931.003737474945,64687.133318431348,68646.263659884309,0]
[]
[null,null,"Exaustão (mil R$)",{"$f":"FC_Florestal!D207","v":0},{"$f":"FC_Florestal!E207","v":0},{"$f":"FC_Florestal!F207","v":0},{"$f":"FC_Florestal!G207","v":0},{"$f":"FC_Florestal!H207","v":0},{"$f":"FC_Florestal!I207","v":0},{"$f":"FC_Florestal!J207","v":0},{"$f":"FC_Florestal!K207","v":-9163.3874400277764},{"$f":"FC_Florestal!L207","v":-9529.9229376288877},{"$f":"FC_Florestal!M207","v":-9911.1198551340422},{"$f":"FC_Florestal!N207","v":-10307.564649339409},{"$f":"FC_Florestal!O207","v":-11363.059269431764},{"$f":"FC_Florestal!P207","v":-11817.581640209035},{"$f":"FC_Florestal!Q207","v":-12290.284905817398},{"$f":"FC_Florestal!R207","v":-12781.896302050091},{"$f":"FC_Florestal!S207","v":-13293.172154132099},{"$f":"FC_Florestal!T207","v":-14607.440495408555},{"$f":"FC_Florestal!U207","v":-15191.738115224898},{"$f":"FC_Florestal!V207","v":-15799.407639833893},{"$f":"FC_Florestal!W207","v":-16431.383945427249},{"$f":"FC_Florestal!X207","v":-17088.639303244341},{"$f":"FC_Florestal!Y207","v":-17772.184875374114},{"$f":"FC_Florestal!Z207","v":-18483.072270389079},{"$f":"FC_Florestal!AA207","v":-19222.39516120464},{"$f":"FC_Florestal!AB207","v":-19991.290967652825},{"$f":"FC_Florestal!AC207","v":0}]
[null,null,"Depreciação (mil R$)",0,0,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,"Earnings Before Interest & Tax - EBIT"]
[null,{"$f":"IRR(D36:AC36)","v":0.13633159997696565},"EBIT (mil R$)",{"$f":"SUM(D30:D33)","v":-211},{"$f":"SUM(E30:E33)","v":-9349.41},-11112.4416,-12158.863184000002,-13271.21858816,-14453.108243558401,-15437.482102308866,9315.0995128936029,9687.7034934093444,10075.211633145718,10478.220098471545,12480.40741345982,12979.623709998217,13498.808658398144,14038.761004734073,14600.311444923445,17110.356634857657,17794.770900251948,18506.56173626204,32775.530767887671,36900.522963535608,39595.931300214426,42447.931467085866,45464.738157226704,48654.972692231488,0]
[]
[null,null,"Despesas Financeiras (mil R$)",0,0,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,"Earnings Before Tax - EBT"]
[null,{"$f":"IRR(D41:AC41)","v":0.13633159997696565},"EBT",{"$f":"SUM(D36:D38)","v":-211},{"$f":"SUM(E36:E38)","v":-9349.41},-11112.4416,-12158.863184000002,-13271.21858816,-14453.108243558401,-15437.482102308866,9315.0995128936029,9687.7034934093444,10075.211633145718,10478.220098471545,12480.40741345982,12979.623709998217,13498.808658398144,14038.761004734073,14600.311444923445,17110.356634857657,17794.770900251948,18506.56173626204,32775.530767887671,36900.522963535608,39595.931300214426,42447.931467085866,45464.738157226704,48654.972692231488,0]
[]
[null,null,"IRPJ, CSLL",{"$f":"-($D$8+$D$9)*D21","v":0},{"$f":"-($D$8+$D$9)*E21","v":0},0,0,0,0,0,-1882.0289690396926,-1957.3101278012803,-2035.6025329133313,-2117.0266342298651,-2333.8101615750033,-2427.1625680380039,-2524.2490707595239,-2625.2190335899045,-2730.2277949335016,-3000.159750508059,-3120.1661405283817,-3244.9727861495167,-3374.7716975954977,-3509.7625654993176,-3650.1530681192908,-3796.1591908440619,-3948.0055584778243,-4105.9257808169377,0]
[]
[null,null,"Lucro Líquido"]
[null,{"$f":"IRR(D46:AC46)","v":0.12001952294806628},"Lucro Líquido",{"$f":"SUM(D41:D43)","v":-211},{"$f":"SUM(E41:E43)","v":-9349.41},-11112.4416,-12158.863184000002,-13271.21858816,-14453.108243558401,-15437.482102308866,7433.0705438539098,7730.3933656080644,8039.6091002323865,8361.19346424168,10146.597251884816,10552.461141960213,10974.55958763862,11413.541971144168,11870.083649989943,14110.196884349598,14674.604759723567,15261.588950112524,29400.759070292173,33390.760398036291,35945.778232095137,38651.772276241805,41516.73259874888,44549.046911414553,0]
[]
[null,null,"Investimentos"]
[null,null,"Compra de Terra",{"$f":"SUM(FC_Florestal!D201:D202)","v":-16141.499999999998},{"$f":"SUM(FC_Florestal!E201:E202)","v":-17369.868149999998},{"$f":"SUM(FC_Florestal!F201:F202)","v":-18425.956133520001},{"$f":"SUM(FC_Florestal!G201:G202)","v":-19546.25426643802},{"$f":"SUM(FC_Florestal!H201:H202)","v":-20734.666525837449},{"$f":"SUM(FC_Florestal!I201:I202)","v":-21995.334250608368},{"$f":"SUM(FC_Florestal!J201:J202)","v":0},{"$f":"SUM(FC_Florestal!K201:K202)","v":0},{"$f":"SUM(FC_Florestal!L201:L202)","v":0},{"$f":"SUM(FC_Florestal!M201:M202)","v":0},{"$f":"SUM(FC_Florestal!N201:N202)","v":0},{"$f":"SUM(FC_Florestal!O201:O202)","v":0},{"$f":"SUM(FC_Florestal!P201:P202)","v":0},{"$f":"SUM(FC_Florestal!Q201:Q202)","v":0},{"$f":"SUM(FC_Florestal!R201:R202)","v":0},{"$f":"SUM(FC_Florestal!S201:S202)","v":0},{"$f":"SUM(FC_Florestal!T201:T202)","v":0},{"$f":"SUM(FC_Florestal!U201:U202)","v":0},{"$f":"SUM(FC_Florestal!V201:V202)","v":0},{"$f":"SUM(FC_Florestal!W201:W202)","v":0},{"$f":"SUM(FC_Florestal!X201:X202)","v":53313.013553175559},{"$f":"SUM(FC_Florestal!Y201:Y202)","v":56554.444777208635},{"$f":"SUM(FC_Florestal!Z201:Z202)","v":59992.955019662906},{"$f":"SUM(FC_Florestal!AA201:AA202)","v":63640.526684858422},{"$f":"SUM(FC_Florestal!AB201:AB202)","v":67509.870707297814},{"$f":"SUM(FC_Florestal!AC201:AC202)","v":71614.470846301512}]
[null,null,"Equipamentos",{"$f":"FC_Florestal!D204","v":0},{"$f":"FC_Florestal!E204","v":-267.12600000000003},{"$f":"FC_Florestal!F204","v":-312.53742},{"$f":"FC_Florestal!G204","v":-335.87354736000003},{"$f":"FC_Florestal!H204","v":-360.57650503679997},{"$f":"FC_Florestal!I204","v":-386.71830165196803},{"$f":"FC_Florestal!J204","v":-414.37451958829064},{"$f":"FC_Florestal!K204","v":-346.44959833813158},{"$f":"FC_Florestal!L204","v":-360.30758227165677},{"$f":"FC_Florestal!M204","v":-374.71988556252307},{"$f":"FC_Florestal!N204","v":-389.7086809850241},{"$f":"FC_Florestal!O204","v":-405.29702822442505},{"$f":"FC_Florestal!P204","v":-421.50890935340215},{"$f":"FC_Florestal!Q204","v":-438.36926572753822},{"$f":"FC_Florestal!R204","v":-455.90403635663966},{"$f":"FC_Florestal!S204","v":-474.14019781090531},{"$f":"FC_Florestal!T204","v":-493.10580572334158},{"$f":"FC_Florestal!U204","v":-512.83003795227535},{"$f":"FC_Florestal!V204","v":-533.34323947036626},{"$f":"FC_Florestal!W204","v":-148.81577218392658},{"$f":"FC_Florestal!X204","v":-84.419128947972879},{"$f":"FC_Florestal!Y204","v":-65.846920579418878},{"$f":"FC_Florestal!Z204","v":-45.653864935063744},{"$f":"FC_Florestal!AA204","v":-23.740009766233147},{"$f":"FC_Florestal!AB204","v":0},{"$f":"FC_Florestal!AC204","v":0}]
[]
[null,null,"Fluxo de Caixa do Empreendimento Florestal"]
[null,{"$f":"IRR(D53:AC53)","v":0.11124550594749327},"Saldo Florestal",{"$f":"D30+D38+D43+D49+D50","v":-16352.499999999998},{"$f":"E30+E38+E43+E49+E50","v":-26986.404149999998},-29850.935153520004,-32040.990997798021,-34366.461619034249,-36835.160795818738,-15851.856621897157,16250.008385543555,16900.008720965296,17576.009069803906,18279.049432596068,21104.359493092157,21948.533872815849,22826.475227728479,23739.534236837622,24689.115606311138,28224.531574034812,29353.512836996189,30527.653350476052,45683.327243535503,103707.99412550821,110206.56096409846,117082.14570135872,124355.91443504572,132050.20858636519,71614.470846301512]
[null,null,"Acumulado",{"$f":"D53","v":-16352.499999999998},{"$f":"SUM($D$53:E53)","v":-43338.904149999995},{"$f":"SUM($D$53:F53)","v":-73189.839303519999},{"$f":"SUM($D$53:G53)","v":-105230.83030131803},{"$f":"SUM($D$53:H53)","v":-139597.29192035226},{"$f":"SUM($D$53:I53)","v":-176432.45271617098},{"$f":"SUM($D$53:J53)","v":-192284.30933806815},{"$f":"SUM($D$53:K53)","v":-176034.30095252459},{"$f":"SUM($D$53:L53)","v":-159134.29223155929},{"$f":"SUM($D$53:M53)","v":-141558.28316175539},{"$f":"SUM($D$53:N53)","v":-123279.23372915931},{"$f":"SUM($D$53:O53)","v":-102174.87423606716},{"$f":"SUM($D$53:P53)","v":-80226.340363251307},{"$f":"SUM($D$53:Q53)","v":-57399.865135522828},{"$f":"SUM($D$53:R53)","v":-33660.330898685206},{"$f":"SUM($D$53:S53)","v":-8971.2152923740687},{"$f":"SUM($D$53:T53)","v":19253.316281660744},{"$f":"SUM($D$53:U53)","v":48606.829118656933},{"$f":"SUM($D$53:V53)","v":79134.482469132985},{"$f":"SUM($D$53:W53)","v":124817.80971266849},{"$f":"SUM($D$53:X53)","v":228525.80383817671},{"$f":"SUM($D$53:Y53)","v":338732.3648022752},{"$f":"SUM($D$53:Z53)","v":455814.51050363394},{"$f":"SUM($D$53:AA53)","v":580170.42493867967},{"$f":"SUM($D$53:AB53)","v":712220.63352504489},{"$f":"SUM($D$53:AC53)","v":783835.10437134642}]
[]
[null,null,"Cálculo do Capital"]
[null,null,"Capital Necessário"]
[null,null,"Aporte de Capital",{"$f":"IF(D53<0,-D53,0)","v":16352.499999999998},{"$f":"IF(E53<0,IF(D58>0,-E53,0),0)","v":26986.404149999998},{"$f":"IF(F53<0,IF(E58>0,-F53,0),0)","v":29850.935153520004},32040.990997798021,34366.461619034249,36835.160795818738,15851.856621897157,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Saldo Após aporte",{"$f":"D53+D58","v":0},{"$f":"E53+E58","v":0},0,0,0,0,0,16250.008385543555,16900.008720965296,17576.009069803906,18279.049432596068,21104.359493092157,21948.533872815849,22826.475227728479,23739.534236837622,24689.115606311138,28224.531574034812,29353.512836996189,30527.653350476052,45683.327243535503,103707.99412550821,110206.56096409846,117082.14570135872,124355.91443504572,132050.20858636519,71614.470846301512]
[null,null,"Saldo Acumulado após aporte",{"$f":"D59","v":0},{"$f":"E59+D60","v":0},{"$f":"F59+E60","v":0},0,0,0,0,16250.008385543555,33150.017106508851,50726.026176312756,69005.075608908825,90109.435102000978,112057.96897481683,134884.4442025453,158623.97843938292,183313.09404569404,211537.62561972885,240891.13845672505,271418.79180720111,317102.1190507366,420810.11317624478,531016.67414034321,648098.81984170189,772454.73427674756,904504.94286311278,976119.41370941431]
[]
[null,null,"Pagamentos ao Capitalista",{"$f":"IF(D60>$D$12,-150000,0)","v":0},{"$f":"IF(D64>$D$12,-$D$11*D64,0)","v":0},0,0,0,0,0,0,-14625.0075469892,-16672.508603567687,-17485.659023180284,-18199.710391654487,-20813.894582948393,-21835.069943829101,-22727.334699338542,-23638.314283087715,-24584.035473988795,-27860.481964030212,-29204.209749699588,-30395.308990398407,-44154.52541822179,-97752.647254779571,-108961.16959316656,-116270.04809053951,-123547.3278005951,{"$f":"IF(AB64>$D$12,-AB64-AC59,0)","v":-217392.16029939952}]
[null,null,"Saldo Após pagamento ao Capitalista",{"$f":"D59+D62","v":0},{"$f":"E59+E62","v":0},0,0,0,0,0,16250.008385543555,2275.0011739760957,903.50046623621893,793.39040941578423,2904.6491014376697,1134.6392898674567,991.40528389937754,1012.1995374990802,1050.8013232234225,3640.4961000460171,1493.0308729659773,1323.4436007764634,15288.018253137096,59553.468707286418,12453.913709318891,8120.9761081921606,8085.866344506212,8502.8807857700886,-145777.68945309799]
[null,null,"Saldo Acumulado após pagamento",{"$f":"D63","v":0},{"$f":"E63+D64","v":0},{"$f":"F63+E64","v":0},0,0,0,0,16250.008385543555,18525.009559519651,19428.51002575587,20221.900435171654,23126.549536609324,24261.18882647678,25252.594110376158,26264.793647875238,27315.594971098661,30956.091071144678,32449.121944110655,33772.565544887118,49060.583798024214,108614.05250531062,121067.96621462952,129188.94232282168,137274.80866732789,145777.68945309799,0]
[]
[null,null,"Fluxo de caixa do sócio capitalista"]
[null,null,"Aporte",{"$f":"-D58","v":-16352.499999999998},{"$f":"-E58","v":-26986.404149999998},-29850.935153520004,-32040.990997798021,-34366.461619034249,-36835.160795818738,-15851.856621897157,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Recebimentos",{"$f":"-D62","v":0},{"$f":"-E62","v":0},0,0,0,0,0,0,14625.0075469892,16672.508603567687,17485.659023180284,18199.710391654487,20813.894582948393,21835.069943829101,22727.334699338542,23638.314283087715,24584.035473988795,27860.481964030212,29204.209749699588,30395.308990398407,44154.52541822179,97752.647254779571,108961.16959316656,116270.04809053951,123547.3278005951,217392.16029939952]
[null,{"$f":"IRR(D69:AC69)","v":0.10315971524844758},"Valor Líquido",{"$f":"D68+D67","v":-16352.499999999998},{"$f":"E68+E67","v":-26986.404149999998},-29850.935153520004,-32040.990997798021,-34366.461619034249,-36835.160795818738,-15851.856621897157,0,14625.0075469892,16672.508603567687,17485.659023180284,18199.710391654487,20813.894582948393,21835.069943829101,22727.334699338542,23638.314283087715,24584.035473988795,27860.481964030212,29204.209749699588,30395.308990398407,44154.52541822179,97752.647254779571,108961.16959316656,116270.04809053951,123547.3278005951,217392.16029939952]
[null,null,"TIR",{"$f":"IRR(D69:AC69)","v":0.10315971524844758}]