{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Índice","Tablero","modelo","coeficientes","precios","ANR"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":39,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Índice","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,2,3,4],[0,0,0,4],[1,0,1,4],[15,0,15,4]]}
["Modelo Económico Forestal"]
["Algarrobo en Chaco"]
[]
[null,null,"Nivel de intervención"]
[null,null,"Básico","Avanzado","Experto"]
["Tablero","Tablero de comando","Editar celdas indicadas para simular diferentes escenarios de precios y variables de interés. Calcular sensibilidades y series de forma manual.","Agregar variantes de características del modelo al tablero de comando, tanto en ingresos de datos como en resultados. Automatizar variaciones sistemáticas con macros. Calcular sensibilidades y series complejas.","Reformular a la medida de las necesidades del caso."]
["modelo","Estructura temporal de ingresos y egresos económicos, basada en el modelo técnico.","Solo lectura","Modificar parámetros o estructura temporal del modelo sin alterar las celdas relacionadas con el tablero de comando.","Reformular el modelo en aspectos más estructurales; agregar otros indicadores de interés al tablero de comando; automatizar variantes del modelo."]
["coeficientes","Coeficientes técnicos del modelo técnico forestal, que cuantifican los rendimientos y requerimientos de cada tarea productiva.","Solo lectura","Solo lectura","Modificar coeficientes para representar modelos con diferentes determinantes técnicas."]
["precios","Conjunto de precios y otras variables de contexto que hacen a las condiciones económicas del modelo forestal.","Solo lectura","Modificar precios específicos que no dependan del tablero de comando, o modificar la relación entre este y determinados precios","Crear o modificar relaciones de dependencia entre precios."]
["ANR","Parámetros para computar el efecto del ANR que prevé la Ley N° 25.080 y modificatorias sobre el modelo.","Seleccionar incluir o no incluir los aportes en el cálculo del modelo.","Actualizar o modificar los montos.","Incorporar otros instrumentos de apoyo o gravámenes; modificar su inserción en la estructura temporal del modelo."]
[]
["Esta planilla de cálculo fue elaborada como actividad del Proyecto Estructural INTA - I016: Desarrollo de una silvicultura sostenible de bosques implantados de alta productividad."]
["Revisión:","noviembre 2021"]
[]
["Equipo técnico:"]
["Demián Olemberg1, Lorena Pernochi1, Marcos Atanasio1, Lucas Vera2, Walter Acosta3, Javier Aguirre4, Walter Lezcano5"]
["1  Instituto Nacional de Tecnología Agropecuaria (INTA)"]
["2 Dirección Nacional de Desarrollo Foresto Industrial - Ministerio de Agricultura Ganadería y Pesca de la Nación (DNDFI-MAGYP)"]
["3 Instituto de Investigación Forestal y Agropecuaria (IIFA)"]
["4 Asociación de Productores Forestales del Chaco"]
["5 Consejo Profesional de Ciencias Forestales del Chaco (CPCFCh)."]
[]
["Agradecimientos: "]
["Mesa de Bosques Cultivados del Chaco."]
[]
["Documento del modelo técnico-económico:"]
["(pendiente de publicación)"]
[]
["Contacto/consultas:"]
["olemberg.demian@inta.gob.ar"]

{"sheet":"Tablero","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,0,14,1]]}
["Tablero de comando"]
[null,null,null,"Año base 2020",null,"Escenarios alternativos:"]
["Tasa (%)",0.05]
["Tipo de cambio ($/USD)",63,null,63]
["JEQ ($/jornal)",1759,null,1759]
["GO ($/l)",62,null,62]
["HMEQ ($/h)",100,null,100]
["PLANT ($/plantín)",34.284891533883666,null,34.284891533883666]
["ANR","NO"]
["Precio Madera ($/t)",4050.3589133841579,null,2300]
["Rendimiento (t/ha)",60,null,60]
["VAN ($)",{"$f":"modelo!$M$5+NPV(tasa,modelo!$M$6:$M$30)","v":0}]
["TIR",{"$f":"IRR(modelo!$M$5:$M$30)","v":5.0000000000006706E-2}]
[]
["Otros indicadores y cálculos"]
["Costo total bruto ($/ha)",{"$f":"SUM(modelo!$O$5:$O$30)","v":107833.14673465172}]
["Costo total actualizado ($/ha)",{"$f":"-NPV(tasa,modelo!$M$5:$M$29)","v":67780.731048795438}]
["Costo bruto implantación ($/ha)",{"$f":"-modelo!$N$7","v":52158.237075471967}]
["Otros..."]

{"sheet":"modelo","index":2,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["Modelo: Estructura temporal de ingresos y egresos económicos"]
[]
["VALORES ($) EXPRESADOS EN PESOS, PARA 1 HA"]
["Año","JEQ","GO","HMEQ","PLANT","AGROQ","AMORT","IMP","Subtotal","Admin","Egresos","Ingresos","FF","FF acum.","Costo"]
[0,{"$f":"coeficientes!$B$5+coeficientes!$B$6+coeficientes!$B$7+coeficientes!$B$8+coeficientes!$B$9+coeficientes!$B$15","v":6.18},{"$f":"coeficientes!$F$6+coeficientes!$F$8+coeficientes!$F$15","v":22},{"$f":"coeficientes!$E$6+coeficientes!$E$8+coeficientes!$E$15","v":7.34},550,{"$f":"coeficientes!$D$10","v":73.999799999999993},{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B5*precios!$B$3+C5*precios!$B$4+D5*precios!$B$5+E5*precios!$B$6+F5+G5+H5","v":33063.423126202484},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},{"$f":"I5+J5","v":33261.85078758133},{"$f":"E5*precios!$B$10","v":8250},{"$f":"L5-K5","v":-25011.85078758133},{"$f":"M5","v":-25011.85078758133},{"$f":"IF(M6<0,0,-N5)","v":0}]
[1,{"$f":"coeficientes!$B$12+coeficientes!$B$13+coeficientes!$B$14+coeficientes!$B$15+coeficientes!$B$9","v":5.3},{"$f":"coeficientes!$F$14+coeficientes!$F$15","v":35},{"$f":"coeficientes!$E$14+coeficientes!$E$15","v":11.67},null,{"$f":"coeficientes!$D$11","v":421.15499999999997},{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B6*precios!$B$3+C6*precios!$B$4+D6*precios!$B$5+E6*precios!$B$6+F6+G6+H6","v":14244.967982566472},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},{"$f":"I6+J6","v":14443.395643945318},0,{"$f":"L6-K6","v":-14443.395643945318},{"$f":"N5+M6","v":-39455.246431526648},{"$f":"IF(M7<0,0,IF(N6<0,IF(-N6>SUM($O$5:O5),-N6-SUM($O$5:O5),0),0))","v":0}]
[2,{"$f":"coeficientes!$B$13+coeficientes!$B$14+coeficientes!$B$15","v":4.55},{"$f":"coeficientes!$F$14+coeficientes!$F$15","v":35},{"$f":"coeficientes!$E$14+coeficientes!$E$15","v":11.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B7*precios!$B$3+C7*precios!$B$4+D7*precios!$B$5+E7*precios!$B$6+F7+G7+H7","v":12504.562982566473},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},12702.990643945319,0,-12702.990643945319,{"$f":"N6+M7","v":-52158.237075471967},{"$f":"IF(M8<0,0,IF(N7<0,IF(-N7>SUM($O$5:O6),-N7-SUM($O$5:O6),0),0))","v":0}]
[3,{"$f":"coeficientes!$B$13+coeficientes!$B$14+coeficientes!$B$15","v":4.55},{"$f":"coeficientes!$F$14+coeficientes!$F$15","v":35},{"$f":"coeficientes!$E$14+coeficientes!$E$15","v":11.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B8*precios!$B$3+C8*precios!$B$4+D8*precios!$B$5+E8*precios!$B$6+F8+G8+H8","v":12504.562982566473},{"$f":"coeficientes!$B$23*modelo!$I$31/26+precios!$B$17","v":442.42766137884655},12946.990643945319,{"$f":"ANR!B4","v":0},-12946.990643945319,-65105.227719417286,{"$f":"IF(M9<0,0,IF(N8<0,IF(-N8>SUM($O$5:O7),-N8-SUM($O$5:O7),0),0))","v":0}]
[4,{"$f":"coeficientes!$B$15+coeficientes!$B$16+coeficientes!$B$17","v":2.35},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B9*precios!$B$3+C9*precios!$B$4+D9*precios!$B$5+E9*precios!$B$6+F9+G9+H9","v":5774.7629825664717},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},5973.1906439453178,0,-5973.1906439453178,-71078.418363362609,{"$f":"IF(M10<0,0,IF(N9<0,IF(-N9>SUM($O$5:O8),-N9-SUM($O$5:O8),0),0))","v":0}]
[5,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B10*precios!$B$3+C10*precios!$B$4+D10*precios!$B$5+E10*precios!$B$6+F10+G10+H10","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26+precios!$B$18","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-73093.859007307925,{"$f":"IF(M11<0,0,IF(N10<0,IF(-N10>SUM($O$5:O9),-N10-SUM($O$5:O9),0),0))","v":0}]
[6,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B11*precios!$B$3+C11*precios!$B$4+D11*precios!$B$5+E11*precios!$B$6+F11+G11+H11","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-75109.299651253241,{"$f":"IF(M12<0,0,IF(N11<0,IF(-N11>SUM($O$5:O10),-N11-SUM($O$5:O10),0),0))","v":0}]
[7,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B12*precios!$B$3+C12*precios!$B$4+D12*precios!$B$5+E12*precios!$B$6+F12+G12+H12","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-77124.740295198557,{"$f":"IF(M13<0,0,IF(N12<0,IF(-N12>SUM($O$5:O11),-N12-SUM($O$5:O11),0),0))","v":0}]
[8,{"$f":"coeficientes!$B$15+coeficientes!$B$17+coeficientes!$B$18","v":3.35},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B13*precios!$B$3+C13*precios!$B$4+D13*precios!$B$5+E13*precios!$B$6+F13+G13+H13","v":7533.7629825664717},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},7732.1906439453178,0,-7732.1906439453178,-84856.930939143873,{"$f":"IF(M14<0,0,IF(N13<0,IF(-N13>SUM($O$5:O12),-N13-SUM($O$5:O12),0),0))","v":0}]
[9,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B14*precios!$B$3+C14*precios!$B$4+D14*precios!$B$5+E14*precios!$B$6+F14+G14+H14","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26+precios!$B$19","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-86872.371583089189,{"$f":"IF(M15<0,0,IF(N14<0,IF(-N14>SUM($O$5:O13),-N14-SUM($O$5:O13),0),0))","v":0}]
[10,{"$f":"coeficientes!$B$15+coeficientes!$B$19","v":2.85},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B15*precios!$B$3+C15*precios!$B$4+D15*precios!$B$5+E15*precios!$B$6+F15+G15+H15","v":6654.2629825664717},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},6852.6906439453178,0,-6852.6906439453178,-93725.062227034505,{"$f":"IF(M16<0,0,IF(N15<0,IF(-N15>SUM($O$5:O14),-N15-SUM($O$5:O14),0),0))","v":0}]
[11,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B16*precios!$B$3+C16*precios!$B$4+D16*precios!$B$5+E16*precios!$B$6+F16+G16+H16","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26+precios!$B$20","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-95740.502870979821,{"$f":"IF(M17<0,0,IF(N16<0,IF(-N16>SUM($O$5:O15),-N16-SUM($O$5:O15),0),0))","v":0}]
[12,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B17*precios!$B$3+C17*precios!$B$4+D17*precios!$B$5+E17*precios!$B$6+F17+G17+H17","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-97755.943514925137,{"$f":"IF(M18<0,0,IF(N17<0,IF(-N17>SUM($O$5:O16),-N17-SUM($O$5:O16),0),0))","v":0}]
[13,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B18*precios!$B$3+C18*precios!$B$4+D18*precios!$B$5+E18*precios!$B$6+F18+G18+H18","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-99771.384158870453,{"$f":"IF(M19<0,0,IF(N18<0,IF(-N18>SUM($O$5:O17),-N18-SUM($O$5:O17),0),0))","v":0}]
[14,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B19*precios!$B$3+C19*precios!$B$4+D19*precios!$B$5+E19*precios!$B$6+F19+G19+H19","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-101786.82480281577,{"$f":"IF(M20<0,0,IF(N19<0,IF(-N19>SUM($O$5:O18),-N19-SUM($O$5:O18),0),0))","v":0}]
[15,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B20*precios!$B$3+C20*precios!$B$4+D20*precios!$B$5+E20*precios!$B$6+F20+G20+H20","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-103802.26544676108,{"$f":"IF(M21<0,0,IF(N20<0,IF(-N20>SUM($O$5:O19),-N20-SUM($O$5:O19),0),0))","v":0}]
[16,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B21*precios!$B$3+C21*precios!$B$4+D21*precios!$B$5+E21*precios!$B$6+F21+G21+H21","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-105817.7060907064,{"$f":"IF(M22<0,0,IF(N21<0,IF(-N21>SUM($O$5:O20),-N21-SUM($O$5:O20),0),0))","v":0}]
[17,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B22*precios!$B$3+C22*precios!$B$4+D22*precios!$B$5+E22*precios!$B$6+F22+G22+H22","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-107833.14673465172,{"$f":"IF(M23<0,0,IF(N22<0,IF(-N22>SUM($O$5:O21),-N22-SUM($O$5:O21),0),0))","v":107833.14673465172}]
[18,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B23*precios!$B$3+C23*precios!$B$4+D23*precios!$B$5+E23*precios!$B$6+F23+G23+H23","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,{"$f":"coeficientes!$B$20*precios!$B$13","v":54679.845330686134},52664.404686740818,-55168.742047910899,{"$f":"IF(M24<0,0,IF(N23<0,IF(-N23>SUM($O$5:O22),-N23-SUM($O$5:O22),0),0))","v":0}]
[19,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B24*precios!$B$3+C24*precios!$B$4+D24*precios!$B$5+E24*precios!$B$6+F24+G24+H24","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-57184.182691856215,{"$f":"IF(M25<0,0,IF(N24<0,IF(-N24>SUM($O$5:O23),-N24-SUM($O$5:O23),0),0))","v":0}]
[20,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B25*precios!$B$3+C25*precios!$B$4+D25*precios!$B$5+E25*precios!$B$6+F25+G25+H25","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-59199.623335801531,{"$f":"IF(M26<0,0,IF(N25<0,IF(-N25>SUM($O$5:O24),-N25-SUM($O$5:O24),0),0))","v":0}]
[21,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B26*precios!$B$3+C26*precios!$B$4+D26*precios!$B$5+E26*precios!$B$6+F26+G26+H26","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-61215.063979746847,{"$f":"IF(M27<0,0,IF(N26<0,IF(-N26>SUM($O$5:O25),-N26-SUM($O$5:O25),0),0))","v":0}]
[22,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B27*precios!$B$3+C27*precios!$B$4+D27*precios!$B$5+E27*precios!$B$6+F27+G27+H27","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-63230.504623692163,{"$f":"IF(M28<0,0,IF(N27<0,IF(-N27>SUM($O$5:O26),-N27-SUM($O$5:O26),0),0))","v":0}]
[23,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B28*precios!$B$3+C28*precios!$B$4+D28*precios!$B$5+E28*precios!$B$6+F28+G28+H28","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-65245.945267637479,{"$f":"IF(M29<0,0,IF(N28<0,IF(-N28>SUM($O$5:O27),-N28-SUM($O$5:O27),0),0))","v":0}]
[24,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B29*precios!$B$3+C29*precios!$B$4+D29*precios!$B$5+E29*precios!$B$6+F29+G29+H29","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,0,-2015.4406439453178,-67261.385911582795,{"$f":"IF(M30<0,0,IF(N29<0,IF(-N29>SUM($O$5:O28),-N29-SUM($O$5:O28),0),0))","v":0}]
[25,{"$f":"coeficientes!$B$15","v":0.1},{"$f":"coeficientes!$F$15","v":5},{"$f":"coeficientes!$E$15","v":1.67},null,null,{"$f":"coeficientes!$B$22","v":1164.1129825664714},{"$f":"precios!$B$7","v":0},{"$f":"B30*precios!$B$3+C30*precios!$B$4+D30*precios!$B$5+E30*precios!$B$6+F30+G30+H30","v":1817.0129825664712},{"$f":"coeficientes!$B$23*modelo!$I$31/26","v":198.42766137884652},2015.4406439453178,{"$f":"coeficientes!$B$21*precios!$B$15","v":243021.53480304946},241006.09415910413,173744.70824752134]
[null,null,null,null,null,null,null,null,{"$f":"SUM($I$5:$I$17)","v":103182.38391700019},{"$f":"SUM(J5:J30)","v":5403.1191958500076}]
[]
["Referencias:"]
["JEQ","Jornal equivalente: cantidad de jornales (categoría testigo peón gral. s/res. CNTA)"]
["GO","Litros de gasoil equivalente: cantidad de litros de gasoil tipo 2 precio final en comercializadora seleccionada"]
["HMEQ","Horas máquina equivalente: cantidad de horas de uso de tractor tipo chico con implementos"]
["PLANT","Material de plantación: cantidad de plantines"]
["AGROQ","Agroquímicos: gasto en $ en productos químicos varios"]
["AMORT","Amortizaciones: amortizaciones de bienes durables en $"]
["IMP","Impuestos específicos en $"]
["Subtotal","Suma de todos los egresos sustantivos del año ($), exceptuando gastos de administración"]
["Admin","Gastos de administración en $, incluye asistencia técnica profesional"]
["Egresos","Suma de todos los egresos del año ($), incluyendo gastos de administración"]
["Ingresos","Suma de todos los ingresos del año ($)"]
["FF","Flujo de fondos neto del año ($)"]
["FF acum.","Flujo de fondos neto acumulado hasta el año ($)"]

{"sheet":"coeficientes","index":3,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Coeficientes técnicos"]
[]
["Tareas","JEQ","PLANT","AGROQ","HMEQ","GO"]
["Flete plantines / unidad",null,null,null,null,7.0000000000000007E-2]
["Manipulación plantines / unidad",0.25]
["Preparación suelo",0.33,null,null,3.67,11]
["Plantación",5]
["Riego asiento",0.25,null,null,2,6]
["Control hormiga",0.25]
["Control hormiga año 0",null,null,{"$f":"0.01*precios!B11","v":73.999799999999993}]
["Control hormiga año 1",null,null,{"$f":"0.5*precios!B12","v":421.15499999999997}]
["Reposición",0.5]
["Desmalezado manual",4]
["Desmalezado tractor",0.45,null,null,10,30]
["Elaboración calles",0.1,null,null,1.67,5]
["Poda 1",2]
["Control rebrotes",0.25]
["Poda 2",3]
["Raleo 1",2.75]
["Rendim. raleo 2 total en pie",18,"t","(8m3 leña + 10m3 rollo)"]
["Rendim. corta final total en pie",{"$f":"RENDIMIENTO","v":60},"t","(25m3 leña + 35m3 rollo)"]
["Amortizaciones",{"$f":"-PMT(tasa,5,precios!$B$8)/100","v":1164.1129825664714}]
["Administración",0.05,"% subtotal"]
[]
["Observaciones"]
["Amortizaciones","Amortización anual prorrateado por ha de un tractor chico a media vida útil cada 100 ha, a la tasa de interés indicada, con vida útil remanente de 30 años, más amortizaciones menores: implementos, motosierras, etc. El precio de la maquinaria se actualiza proporcionalmente con el tipo de cambio, y asimismo las amortizaciones."]
["Administración","Se aplica una tasa fija sobre el subtotal de toda la serie, y se prorratea en anualidades iguales."]
["HMEQ","Hora Máquina Equivalente: incluye mantenimiento y reparaciones ordinarias. Las amortizaciones se computan independientemente, según se indica arriba."]
["AGROQ","Gasto en agroquímicos y otros: Valores en $ resultantes de aplicar las cantidades técnicamente especificadas por el precio vigente, que se actualiza proporcionalmente con el tipo de cambio."]
["JEQ","Jornal equivalente"]
["GO","Litros de gasoil equivalente: Todos los consumos de diferentes combustibles y lubricantes se expresan como litros de gasoil equivalentes, según la relación de precios vigente al año base, 2020."]

{"sheet":"precios","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Precios"]
[null,null,"Unidad","Fuente","Fecha","Observaciones"]
["JEQ",{"$f":"PJEQ","v":1759},"$/día","Mesa Forestal Chaco","2020-08-01","vigente CNTA 2021"]
["GO",{"$f":"PGO","v":62},"$/l","Mesa Forestal Chaco","2020-11-01"]
["HMEQ",{"$f":"PHMEQ","v":100},"$/h","Mesa Forestal Chaco","2020-11-01","incluye mantenimiento y reparaciones ordinarias"]
["PLANT",{"$f":"PPLANT","v":34.284891533883666},"$/plantín","Mesa Forestal Chaco","2020-08-01","Incluye flete. Con subsidio provincial, el flete no cuenta (IIFA)."]
["Impuestos específicos netos de subsidios",0,"$/ha/año","Mesa Forestal Chaco","2020-11-01"]
["Tractor media vida útil (más motosierra, implementos, etc.)",{"$f":"8000*TCN","v":504000},"$","Mesa Forestal Chaco","2020-11-01"]
["Plantín algarrobo Chaco",30,"$/plantín puesto en vivero","Mesa Forestal Chaco","2020-08-01","Con subsidio provincial pasa a $20, y hay precios diferenciales hasta $39"]
["Subsidio provincial al plantín",15,"$/plantín","Mesa Forestal Chaco","2020-08-01"]
["Fipronil",{"$f":"117.46*TCN","v":7399.98},"$/l","Mesa Forestal Chaco","2020-11-01"]
["Cebo Formidor bayer Mirex",{"$f":"13.37*TCN","v":842.31},"$/kg","Mesa Forestal Chaco","2020-11-01"]
["Madera en pie (raleo 2)",{"$f":"0.75*$B$15","v":3037.7691850381184},"$/t","Mesa Forestal Chaco","2020-08-01"]
["Madera en campo (raleo 2)",3220,"$/t","Mesa Forestal Chaco","2020-08-01"]
["Madera en pie (final)",{"$f":"PMAD","v":4050.3589133841579},"$/t","Mesa Forestal Chaco","2020-08-01"]
["Leña",1380,"$/t","Mesa Forestal Chaco","2020-11-01"]
["Asistencia técnica plan forestal",{"$f":"244+0.12*ANR!$B$4","v":244},"$/ha","Consejo Prof. Cs. For. Chaco + res. costos Ley 25080 año 2020","2020-07-01","12% monto del proyecto presentado + $244/ha"]
["Asistencia técnica poda 1",{"$f":"0.12*ANR!$B$6","v":0},"$/ha","Consejo Prof. Cs. For. Chaco + res. costos Ley 25080 año 2020","2020-07-01","12% monto de poda 1"]
["Asistencia técnica poda 2",{"$f":"0.12*ANR!$B$7","v":0},"$/ha","Consejo Prof. Cs. For. Chaco + res. costos Ley 25080 año 2020","2020-07-01","12% monto de poda 2"]
["Asistencia técnica raleo",{"$f":"0.12*ANR!$B$5","v":0},"$/ha","Consejo Prof. Cs. For. Chaco + res. costos Ley 25080 año 2020","2020-07-01","12% monto de raleo"]

{"sheet":"ANR","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Instrumentos de apoyo específicos sectoriales"]
[]
[null,"AENR a imputar","monto AENR","Normativa","Observaciones"]
["Implantación, cobro al año 3",{"$f":"IF(Tablero!$B$9=\"SÍ\",ANR!C4,0)","v":0},75589,"Res. 116/20","plantando hasta 20 ha/año"]
["Raleo del año 10, cobro al año 11",{"$f":"IF(Tablero!$B$9=\"SÍ\",ANR!C5,0)","v":0},6677,"Res. 116/20"]
["Poda del año 4, cobro al año 5",{"$f":"IF(Tablero!$B$9=\"SÍ\",ANR!C6,0)","v":0},6210,"Res. 116/20"]
["Poda del año 8, cobro al año 9",{"$f":"IF(Tablero!$B$9=\"SÍ\",ANR!C7,0)","v":0},8372,"Res. 116/20"]
[]
[]
["Referencias:"]
["AENR","Apoyo económico no reintegrable"]