{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["@","Datos de entrada","Costos y Resultados","Comparación de Resultados","Bibliografía","Listados"],"not_rendered":{"charts":6,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"@","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Datos de entrada","index":1,"n_rows":163,"n_cols":70,"rows_kept":163,"cut":false,"hidden":false,"merged":[[4,60,4,61],[9,65,9,68],[26,1,26,3],[75,2,75,3],[108,1,110,1],[97,1,98,1],[97,2,97,5],[97,6,98,6],[81,2,81,3],[1,1,3,12],[121,5,122,5],[121,6,122,6],[121,7,122,7],[123,5,126,7],[87,2,87,3]]}
[]
[null,"Ayuda para el correcto uso de la herramienta: Completar solamente las celdas que estan en color blanco. Posicionando el mouse sobre la celda de interés encontrará ayuda. Completar deslizando hacia abajo. Seleccione sobre los botones del Menú de Opciones para continuar. Para salir de la visualización de pantalla completa presione Esc"]
[]
[]
[null,"Generación de Estiércol",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tipo de Agua","Estimación Volumen Lavado de Pisos",null,"Destino Lag 1","Destino Lag 2","Destino Lag 3",null,{"$f":"+B109","v":"Seleccione Cirterio de Diseño"},{"$f":"+B147","v":"Seleccione una opción"},null,null,"Parámetro Lavado Pisos","Parámetro Diseño",null,null,null,"Volumen m3","prof"]
[null,"Vacas en Ordeñe","Cabezas promedio","Producción (L/V.O.día)","Días al año","Tiempo sobre pisos (h/día)",null,null,"Producción de  Estiércol (KgMF/día)","Producción de Estiércol (m3/año)","Producción de Estiércol (KgMS/año)","N excretado (Kg/año)","P excretado (Kg/año)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limpia","Estimativo (por cabeza)",null,"Laguna 2","Laguna 3","Aplicación al Suelo","Cargar dimensiones manualmente",1,"Tamiz Estático",null,3,1,"Cargar dimensiones manualmente","Laguna 1",{"$f":"2.28*'Datos de entrada'!$C$14","v":797.99999999999989},{"$f":"+IF('Datos de entrada'!$C$14<250,3,4)","v":4}]
[null,"Rodeo 1",200,23,365,1.5,null,null,{"$f":"+(46.2+D7*0.616)*C7*F7/16","v":1131.9000000000001},{"$f":"+I7*E7/(1000*0.954)","v":433.06446540880512},{"$f":"(5.6+D7*0.0874)*F7/16*C7*E7","v":52082.306250000001},{"$f":"(D7*0.0028+0.346)*C7*E7*F7/16","v":2808.6750000000002},{"$f":"(0.05+0.000781*D7)*C7*E7*F7/16","v":465.12178125000003},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tratada (reutilización)","Medido (caudal y tiempo)",null,"Aplicación al suelo","Aplicación al Suelo","Vuelco","Dimensionar en función de días de almacenamiento",2,"Sin Separación de Sólidos",null,null,2,"Dimensionar en función de días de almacenamiento","Laguna 2",{"$f":"1.44*'Datos de entrada'!$C$14","v":504},1.5]
[null,"Rodeo 2",150,17,365,1.5,null,null,{"$f":"+(46.2+D8*0.616)*C8*F8/16","v":796.95},304.91273584905662,{"$f":"(5.6+D8*0.0874)*F8/16*C8*E8","v":36370.082812500004},{"$f":"(D8*0.0028+0.346)*C8*E8*F8/16","v":2020.2749999999999},{"$f":"(0.05+0.000781*D8)*C8*E8*F8/16","v":324.78897656250001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vuelco","Vuelco",null,"Dimensionar para reutilización (INTA Rafaela)",null,null,null,null,3,"Dimensionar para reutilización (INTA Rafaela)","Laguna 3",{"$f":"1.44*'Datos de entrada'!$C$14","v":504},1.5]
[null,"Rodeo …",null,null,null,null,null,null,0,0,0,0,0]
[null,"Rodeo …",null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,null,null,{"$f":"+VLOOKUP(BN11,BN6:BO8,2,FALSE)","v":"Dimensionar para reutilización (INTA Rafaela)"}]
[null,"Rodeo …",null,null,null,null,null,null,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Rodeo …",null,null,null,null,null,null,0,0,0,0,0]
[null,"Rodeo …",null,null,null,null,null,null,0,0,0,0,0]
[null,"Subtotal",{"$f":"+SUMPRODUCT(C7:C13,E7:E13)/365","v":350},{"$f":"+SUMPRODUCT(D7:D13,C7:C13,E7:E13)/(365*C14)","v":20.428571428571427},null,null,null,null,{"$f":"+SUM(I7:I13)","v":1928.8500000000001},{"$f":"+SUM(J7:J13)","v":737.97720125786168},{"$f":"+SUM(K7:K13)","v":88452.389062500006},{"$f":"+SUM(L7:L13)","v":4828.95},{"$f":"+SUM(M7:M13)","v":789.91075781250004}]
[null,"Vaquillonas Recría","Cabezas promedio","Días al año","Peso Vivo Promedio","Digestibilidad promedio de la dieta","Proteína de la Dieta %MS","Tiempo sobre pisos (h/día)","Producción de Estiércol (KgMF/día)","Producción de Estiércol (m3MF/año)","Producción de Estiércol (KgMS/año)","N excretado (Kg/año)","P excretado (Kg/año)"]
[null,"Recría a Corral",null,365,null,null,null,24,{"$f":"IF(H16<16,(E16*0.0181+17.817)*C16*H16/16,(E16*0.0181+17.817)*C16)","v":0},{"$f":"+I16*D16/(0.954*1000)","v":0},{"$f":"+E16*0.03*(1-F16)*C16*D16*H16/16","v":0},{"$f":"IF(H16<16,(E16*0.03*G16*0.0789+0.0514)*C16*D16*H16/16,(E16*0.03*G16*0.0789+0.0514)*C16*D16)","v":0},{"$f":"+L16*0.17","v":0}]
[null,"Rodeo…",null,365,null,null,null,24,{"$f":"IF(H17<16,(E17*0.018+17.817)*C17*H17/16,(E17*0.018+17.817)*C17)","v":0},0,0,{"$f":"IF(H17<16,(E17*0.03*G17*0.0789+0.0514)*C17*D17*H17/16,(E17*0.03*G17*0.0789+0.0514)*C17*D17)","v":0},{"$f":"+L17*0.17","v":0}]
[null,"Rodeo…",null,365,null,null,null,24,0,0,0,0,0]
[null,"Rodeo…",null,365,null,null,null,24,0,0,0,0,0]
[null,"Rodeo…",null,365,null,null,null,24,0,0,0,0,0]
[null,"Rodeo…",null,365,null,null,null,24,0,0,0,0,0]
[null,"Rodeo…",null,365,null,null,null,24,0,0,0,0,0]
[null,"Subtotal",null,null,null,null,null,null,{"$f":"+SUM(I16:I22)","v":0},{"$f":"+SUM(J16:J22)","v":0},{"$f":"+SUM(K16:K22)","v":0},{"$f":"+SUM(L16:L22)","v":0},0]
[]
[null,"Total",null,null,null,null,null,null,{"$f":"+I14+I23","v":1928.8500000000001},{"$f":"+J14+J23","v":737.97720125786168},{"$f":"+K14+K23","v":88452.389062500006},{"$f":"+L23+L14","v":4828.95},{"$f":"+M23+M14","v":789.91075781250004}]
[]
[null,"Aporte Pluvial"]
[null,"Techo/piso","Superficie en m2 (a)","Proporción (%) del techo que aporta al efluente (b)"]
[null,"Sala de Ordeñe",0,1]
[null,"Corral de Espera con Techo",0,1]
[null,"manga tratamientos",0,1]
[null,"pisos externos",0,1]
[null,"…",0,1]
[null,"…",0,1]
[null,"…",0,1]
[null,"…",0,1]
[null,"…",0,1]
[null,"…",0,1]
[null,"…",0,1]
[null,"…",0,1]
[null,"Total Área Equivalente",{"$f":"+SUMPRODUCT(C29:C40,D29:D40)","v":0}]
[]
[null,"PP anual media (mm)",900]
[null,"pp anual de diseño (mm)",1200]
[null,"Ev anual media (mm)",700]
[null,"Balance Hídrico",{"$f":"+C43-C45/2","v":550}]
[null,"Balance Hídrico Máx",{"$f":"+C44-C45/2","v":850}]
[]
[null,"Aporte Pluvial medio",{"$f":"+C41*C43/1000","v":0},"m3/año"]
[null,"Aporte Pluvial Máx",{"$f":"+C44/1000*C41","v":0},"m3/año"]
[]
[null,"Lavado de Pisos"]
[null,"Elija una opción:"]
[]
[]
[null,null,"L de agua/V.O.día",15]
[null,null,"Días al año",365]
[null,null,"Reutilización",0]
[null,null,"Total L/día",{"$f":"+D56*C14","v":5250}]
[null,null,"Total Agua Limpia L/día",{"$f":"+D59*(1-D58)","v":5250}]
[null,null,"Total Agua tratada m3/año",{"$f":"+D59*D58","v":0}]
[null,null,"Total Agua Limpia m3/año",{"$f":"+D60*D57/1000","v":1916.25}]
[]
[null,null,"Piso","caudal manguera (L/h)","tiempo/lavado\n(minutos)","Lavados/día","Días/año","Tipo de Agua","Total L/día","m3/año","L/cab.día"]
[null,null,"Sala de Ordeñe",3600,20,2,365,"Limpia",{"$f":"+E65/60*D65*F65","v":2400},{"$f":"+D65*E65/60*F65*G65/1000","v":876},{"$f":"+I65/$C$14","v":6.8571428571428568}]
[null,null,"Corral de Espera",15000,7,2,365,"Limpia",{"$f":"+E66/60*D66*F66","v":3500},{"$f":"+D66*E66/60*F66*G66/1000","v":1277.5},{"$f":"+I66/$C$14","v":10}]
[null,null,"…",null,null,null,null,null,0,0,{"$f":"+I67/$C$14","v":0}]
[null,null,"…",null,null,null,null,null,0,0]
[null,null,"…",null,null,null,null,null,0,0]
[null,null,"…",null,null,null,null,null,0,0]
[null,null,"…",null,null,null,null,null,0,0]
[null,null,"…",null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,"Total",{"$f":"+SUM(I65:I72)","v":5900},{"$f":"+SUM(J65:J72)","v":2153.5},{"$f":"+I73/$C$14","v":16.857142857142858}]
[null,null,null,null,null,null,null,"Total Reutilizado",{"$f":"+SUMIF(H65:H72,BC7,I65:I72)","v":0},{"$f":"+SUMIF(H65:H72,BC7,J65:J72)","v":0},{"$f":"+I74/$C$14","v":0}]
[null,null,null,null,null,null,null,"Total Limpia",{"$f":"+I73-I74","v":5900},{"$f":"+J73-J74","v":2153.5},{"$f":"+I75/$C$14","v":16.857142857142858}]
[null,null,"Lavado de Maquina de Ordeño"]
[null,null,"Unidades de Ordeño",10]
[null,null,"Días/año",365]
[null,null,"L/día",{"$f":"27.75*D77+134.4","v":411.9}]
[null,null,"m3/año",{"$f":"+D79*365/1000","v":150.34350000000001}]
[]
[null,null,"Lavado de Equipo de Frío"]
[null,null,"Capacidad del Tanque (L)",11000]
[null,null,"Volumen de cada Lavado (L)",{"$f":"0.045*D83","v":495}]
[null,null,"Tiempo entre lavados (hs)",48]
[null,null,"m3/año",{"$f":"+D84*365*24/(D85*1000)","v":90.337500000000006}]
[]
[null,null,"Refrescado de Leche"]
[null,null,"Caudal (L/h)",1500]
[null,null,"Tiempo por ordeñe (min)",90]
[null,null,"Ordeñes/día",2]
[null,null,"Días/año",365]
[null,null,"% reutilización refrescado",0.5]
[null,null,"L/día",{"$f":"+D89/60*D90*D91*(1-D93)","v":2250}]
[null,null,"m3/año",{"$f":"+D94*D92/1000","v":821.25}]
[null,null,"L.agua / L.leche",{"$f":"(D89/60*D90*D91)/(C14*D14)","v":0.62937062937062949}]
[]
[null,"Volumen Anual de Efluente Líquido Primario","TOTAL",null,null,null,"Valores Objetivo"]
[null,null,"m3/año","m3/año máx","L/día","L/V.O.día"]
[null,"Excretas",{"$f":"+J25","v":737.97720125786168},{"$f":"+C100","v":737.97720125786168},{"$f":"+I25","v":1928.8500000000001},{"$f":"+E100/$C$14","v":5.5110000000000001},{"$f":"+F100","v":5.5110000000000001}]
[null,"Agua de lluvia",{"$f":"+C49","v":0},{"$f":"+C50","v":0},{"$f":"+C101*1000/365","v":0},{"$f":"+E101/$C$14","v":0},0]
[null,"Agua de Lavado de Pisos",{"$f":"+IF(BJ10=2,J75,IF(BJ10=1,D62,\"error\"))","v":2153.5},{"$f":"+C102","v":2153.5},{"$f":"IF(BJ10=2,I75,IF(BJ10=1,D60,\"error\"))","v":5900},{"$f":"+E102/$C$14","v":16.857142857142858},18]
[null,"Lavado de Máquina de Ordeño y Equipo de Frío",{"$f":"+D80+D86","v":240.68100000000001},{"$f":"+C103","v":240.68100000000001},{"$f":"+D103*1000/365","v":659.4},{"$f":"+E103/$C$14","v":1.8839999999999999},{"$f":"+F103","v":1.8839999999999999}]
[null,"Refrescado de Leche",{"$f":"+D95","v":821.25},{"$f":"+C104","v":821.25},{"$f":"+D94","v":2250},{"$f":"+E104/$C$14","v":6.4285714285714288},0]
[null,"Total",{"$f":"+SUM(C100:C104)","v":3953.4082012578615},{"$f":"+SUM(D100:D104)","v":3953.4082012578615},{"$f":"+SUM(E100:E104)","v":10738.25},{"$f":"+SUM(F100:F104)","v":30.680714285714288}]
[]
[]
[null,"Diseño de Lagunas"]
[null,"Seleccione Cirterio de Diseño"]
[]
[]
[]
[null,"Tiempo de Almacenamiento",0,{"$f":"+IF(C113<30, \"Riesgo microbiológico alto. Se recomienda aumentar el tiempo de almacenamiento\",\"\")","v":"Riesgo microbiológico alto. Se recomienda aumentar el tiempo de almacenamiento"}]
[]
[null,null,"Laguna 1"]
[null,"Volumen total Laguna (m3)",{"$f":"+(D105/365)*C113","v":0}]
[null,"ancho (m)",12]
[null,"prof (m)",3]
[null,"largo (m)",{"$f":"+C116/(C117*C118)","v":0}]
[null,"superficie",{"$f":"+C119*C117","v":0}]
[]
[null,null,"Laguna 1","Laguna 2","Laguna 3","Tiempo de Almacenamiento",{"$f":"(1000*(C124*C125*C126+D124*D125*D126+E124*E125*E126))/E105","v":199.66009359066888},"días"]
[null,"Volumen total de Laguna (m3)",{"$f":"+C124*C125*C126","v":660},{"$f":"+D124*D125*D126","v":840},{"$f":"+E124*E125*E126","v":644}]
[null,"ancho (m)",6,8,8,{"$f":"IF(G122>30,\"\",\"Riesgo microbiológico alto. Se recomienda aumentar capacidad de lagunas o reducir consumo de agua\")","v":""}]
[null,"prof (m)",5.5,3.5,3.5]
[null,"largo (m)",20,30,23]
[null,"superficie",{"$f":"+C126*C124","v":120},{"$f":"+D126*D124","v":240},{"$f":"+E126*E124","v":184}]
[]
[]
[null,null,"Laguna 1","Laguna 2","Laguna 3"]
[null,"Volumen total Laguna (m3)",{"$f":"+C132*C133*C134","v":797.99999999999977},{"$f":"+D132*D133*D134","v":504},{"$f":"+E132*E133*E134","v":504}]
[null,"ancho (m)",6,8,8]
[null,"prof (m)",{"$f":"+'Datos de entrada'!BR6","v":4},{"$f":"+'Datos de entrada'!BR7","v":1.5},{"$f":"+'Datos de entrada'!BR8","v":1.5}]
[null,"largo (m)",{"$f":"+'Datos de entrada'!BQ6/('Datos de entrada'!C132*'Datos de entrada'!C133)","v":33.249999999999993},{"$f":"+'Datos de entrada'!BQ7/('Datos de entrada'!D132*'Datos de entrada'!D133)","v":42},{"$f":"+'Datos de entrada'!BQ8/('Datos de entrada'!E132*'Datos de entrada'!E133)","v":42}]
[null,"superficie",{"$f":"+C134*C132","v":199.49999999999994},{"$f":"+D134*D132","v":336},{"$f":"+E134*E132","v":336}]
[]
[]
[]
[]
[null,"Corrección por Balance Hídrico Lagunas (m3)",{"$f":"+IF(BN10=BI6,SUM(C127:E127),IF(BN10=BI7,C120,IF(BN10=BI8,SUM(C135:E135),\"error\")))*C46/1000","v":479.32499999999999},"m3"]
[null,"Aplicación de Líquidos","m3/año","L/V.O.día"]
[null,"Volumen a aplicar",{"$f":"+C140+C105","v":4432.7332012578618},{"$f":"+C142*1000/(365*C14)","v":34.698498639983264}]
[]
[]
[]
[null,"Separación de sólidos"]
[null,"Seleccione una opción"]
[]
[]
[null,"Proporción de retención de sólidos (%)",0.21000000000000002]
[null,"Volumen Anual Sólidos           (Kg MS)",{"$f":"IF(BK10=BJ7,0,K25*C150)","v":0}]
[]
[null,"Aplicación de Sólidos"]
[null,"Contenido MS al momento de aplicar",0.35]
[null,"Volumen Anual Sólidos a aplicar (Kg)",{"$f":"+C151/C154","v":0}]
[]
[]
[null,"Aporte de Nutrientes"]
[null,"Pérdida de Volatilización de Nitrógeno",0.4]
[null,"N aprovechado (Kg/año)",{"$f":"+L25*(1-C159)","v":2897.37},null,"Líquidos Totales",{"$f":"+C105","v":3953.4082012578615}]
[null,"P Aprovechado (Kg/año)",{"$f":"+M25","v":789.91075781250004},null,"Líquidos",{"$f":"+F160-F162","v":3953.4082012578615}]
[null,"Equivalencia MAP (Kg/año)",{"$f":"+C161/(0.436*0.52)","v":3484.080618439044},null,"Sólidos Retenidos (MS)",{"$f":"+C151/1000","v":0}]
[null,"Equivalencia UREA (Kg/año)",{"$f":"+(C160-C162*0.12)/0.46","v":5389.7398386680752},null,"Sólidos Pasantes (MS)",{"$f":"+K25/1000-F162","v":88.452389062500004}]

{"sheet":"Costos y Resultados","index":2,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Ayuda para el correcto uso de la herramienta: Completar solamente las celdas que estan en color blanco. Posicionando el mouse sobre la celda de interés encontrará ayuda. Completar deslizando hacia abajo. Seleccione sobre los botones del Menú de Opciones para continuar. Para salir de la visualización de pantalla completa presione Esc"]
[]
[null,"COSTOS OPERATIVOS","Unidades","Costo Unitario","Total (USD/año)"]
[null,"Energía Eléctrica (kWh)",{"$f":"+IF('Datos de entrada'!BK10='Datos de entrada'!BJ6,'Datos de entrada'!C100+'Datos de entrada'!D62*1000/3000,0)","v":0},0.2,{"$f":"+D5*C5","v":0}]
[null,"Servicio tanque estercolero (m3)",{"$f":"+'Datos de entrada'!C142","v":4432.7332012578618},3,{"$f":"+D6*C6","v":13298.199603773584}]
[null,"Servicio carro esparcidor de sólidos (ton)",{"$f":"+'Datos de entrada'!C155/1000","v":0},12,{"$f":"+D7*C7","v":0}]
[null,"Total",null,null,{"$f":"+SUM(E5:E7)","v":13298.199603773584}]
[]
[]
[null,"AHORRO EN FERTILIZANTES","Unidades","Precio Unitario","Total (USD/año)"]
[null,"Urea",{"$f":"+'Datos de entrada'!C163","v":5389.7398386680752},0.56999999999999995,{"$f":"+D12*C12","v":3072.1517080408025}]
[null,"Fosfato Monoamónico",{"$f":"+'Datos de entrada'!C162","v":3484.080618439044},0.68,{"$f":"+D13*C13","v":2369.1748205385502}]
[null,"Total",null,null,{"$f":"+SUM(E12:E13)","v":5441.3265285793532}]
[]
[]
[null,"Costos Operativos Netos USD/año",null,null,{"$f":"+E8-E14","v":7856.8730751942312}]
[null,"Costos Operativos Netos USD/V.O.año",null,null,{"$f":"+E17/'Datos de entrada'!C14","v":22.44820878626923}]
[]
[]
[null,"INVERSIONES EN LAGUNAS","Costo Unitario (USD)",{"$f":"CONCATENATE('Datos de entrada'!C122,\" (m3)\")","v":"Laguna 1 (m3)"},{"$f":"CONCATENATE('Datos de entrada'!D122,\" (m3)\")","v":"Laguna 2 (m3)"},{"$f":"CONCATENATE('Datos de entrada'!E122,\" (m3)\")","v":"Laguna 3 (m3)"}]
[null,"Movimiento de tierra (m3)",8.24,{"$f":"IF('Datos de entrada'!BN10='Datos de entrada'!BI6,'Datos de entrada'!C124*'Datos de entrada'!C126*('Datos de entrada'!C125-0.7),IF('Datos de entrada'!BN10='Datos de entrada'!BI7,'Datos de entrada'!C117*'Datos de entrada'!C119*('Datos de entrada'!C118-0.7),IF('Datos de entrada'!BN10='Datos de entrada'!BI8,'Datos de entrada'!C132*'Datos de entrada'!C134*'Datos de entrada'!C133-0.7,\"error\")))","v":797.29999999999973},{"$f":"IF('Datos de entrada'!BN10='Datos de entrada'!BI6,'Datos de entrada'!D124*'Datos de entrada'!D126*('Datos de entrada'!D125-0.7),IF('Datos de entrada'!BN10='Datos de entrada'!BI7,0,IF('Datos de entrada'!BN10='Datos de entrada'!BI8,'Datos de entrada'!D132*'Datos de entrada'!D134*('Datos de entrada'!D133-0.7),\"error\")))","v":268.8},{"$f":"IF('Datos de entrada'!BN10='Datos de entrada'!BI6,'Datos de entrada'!E124*'Datos de entrada'!E126*('Datos de entrada'!E125-0.7),IF('Datos de entrada'!BN10='Datos de entrada'!BI7,0,IF('Datos de entrada'!BN10='Datos de entrada'!BI8,'Datos de entrada'!E132*'Datos de entrada'!E134*('Datos de entrada'!E133-0.7),\"error\")))","v":268.8}]
[null,"Impermeabilización (m2)",5.88,{"$f":"+IF('Datos de entrada'!BN10='Datos de entrada'!BI6,'Datos de entrada'!C124*'Datos de entrada'!C126+'Datos de entrada'!C124*'Datos de entrada'!C125*2+'Datos de entrada'!C126*'Datos de entrada'!C125*2,IF('Datos de entrada'!BN10='Datos de entrada'!BI7,'Datos de entrada'!C117*'Datos de entrada'!C119+'Datos de entrada'!C117*'Datos de entrada'!C118*2+'Datos de entrada'!C119*'Datos de entrada'!C118*2,IF('Datos de entrada'!BN10='Datos de entrada'!BI8,'Datos de entrada'!C132*'Datos de entrada'!C133*2+'Datos de entrada'!C134*'Datos de entrada'!C133*2+'Datos de entrada'!C132*'Datos de entrada'!C134,\"error\")))","v":513.49999999999989},{"$f":"IF('Datos de entrada'!BN10='Datos de entrada'!BI6,'Datos de entrada'!D124*'Datos de entrada'!D126+'Datos de entrada'!D124*'Datos de entrada'!D125*2+'Datos de entrada'!D126*'Datos de entrada'!D125*2,IF('Datos de entrada'!BN10='Datos de entrada'!BI7,0,IF('Datos de entrada'!BN10='Datos de entrada'!BI8,'Datos de entrada'!D132*'Datos de entrada'!D133*2+'Datos de entrada'!D134*'Datos de entrada'!D133*2+'Datos de entrada'!D134*'Datos de entrada'!D132,\"error\")))","v":486},{"$f":"IF('Datos de entrada'!BN10='Datos de entrada'!BI6,'Datos de entrada'!E124*'Datos de entrada'!E126+'Datos de entrada'!E124*'Datos de entrada'!E125*2+'Datos de entrada'!E126*'Datos de entrada'!E125*2,IF('Datos de entrada'!BN10='Datos de entrada'!BI7,0,IF('Datos de entrada'!BN10='Datos de entrada'!BI8,'Datos de entrada'!E132*'Datos de entrada'!E133*2+'Datos de entrada'!E134*'Datos de entrada'!E133*2+'Datos de entrada'!E134*'Datos de entrada'!E132,\"error\")))","v":486}]
[null,"Total (USD)",null,{"$f":"+D22*$C$22+D23*$C$23","v":9589.1319999999978},{"$f":"+E22*$C$22+E23*$C$23","v":5072.5920000000006},{"$f":"+F22*$C$22+F23*$C$23","v":5072.5920000000006}]
[]
[]
[null,"INVERSIONES","Costo Unitario","Inversión (USD)","Duración (años)","Amortización (USD/año)"]
[null,"Laguna 1",null,{"$f":"+D24","v":9589.1319999999978},30,{"$f":"+D28/E28","v":319.63773333333324}]
[null,"Laguna 2",null,{"$f":"+E24","v":5072.5920000000006},30,169.08640000000003]
[null,"Laguna 3",null,{"$f":"+F24","v":5072.5920000000006},30,169.08640000000003]
[null,"Sistema de Separación de Sólidos",10000,{"$f":"+IF('Datos de entrada'!BK10='Datos de entrada'!BJ6,C31,0)","v":0},10,0]
[null,"Bomba estercolera",1000,{"$f":"+IF('Datos de entrada'!BK10='Datos de entrada'!BJ6,C32,0)","v":0},5,0]
[null,"Obra Civil (pileta de recepción)",3000,{"$f":"+IF('Datos de entrada'!BK10='Datos de entrada'!BJ6,C33,0)","v":0},20,0]
[null,"Playón depósito de sólidos",1500,{"$f":"+IF('Datos de entrada'!BK10='Datos de entrada'!BJ6,12000/8.3,0)","v":0},20,0]
[null,"Instalación Electrica",1000,{"$f":"+IF('Datos de entrada'!BK10='Datos de entrada'!BJ6,1000,0)","v":0},10,0]
[null,"TOTAL",null,{"$f":"+SUM(D28:D35)","v":19734.315999999999},null,{"$f":"+SUM(F28:F35)","v":657.8105333333333}]
[null,null,null,null,null,{"$f":"+E17+F36","v":8514.6836085275645}]
[]
[null,{"$f":"+IF(F37<0,\"Beneficio Total Anual (USD)\",\"Costo total anual (USD)\")","v":"Costo total anual (USD)"},null,null,{"$f":"+IF(F37<0,-F37,F37)","v":8514.6836085275645}]
[null,{"$f":"+IF(F37<0,\"Beneficio Total Anual (USD/V.O.)\",\"Costo total anual (USD/V.O.)\")","v":"Costo total anual (USD/V.O.)"},null,null,{"$f":"+E39/'Datos de entrada'!C14","v":24.327667452935898}]

{"sheet":"Comparación de Resultados","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,4,3,9],[3,1,3,2],[1,1,1,11]]}
[]
[null,"Ayuda para el correcto uso de la herramienta: Coloque un nombre de Simulación Actual y presione Guardar. Puede guardar hasta 4 simulaciones. Con los botones de Borrar puede limpiar simulaciones no deseadas."]
[]
[null,"Simulación Actual",null,null,"Simulaciones guardadas para comparar"]
[null,"Nombre","Prueba2",null,null,{"$f":"+C5","v":"Prueba2"},"Prueba2","Prueba1"]
[null,"Inversión (USD)",{"$f":"+'Costos y Resultados'!D36","v":19734.315999999999},null,{"$f":"B6","v":"Inversión (USD)"},{"$f":"+C6","v":19734.315999999999},19734.315999999999,19734.315999999999]
[]
[null,"Costo de aplicación de Líquidos",{"$f":"+'Costos y Resultados'!E6","v":13298.199603773584},null,{"$f":"B8","v":"Costo de aplicación de Líquidos"},{"$f":"+C8","v":13298.199603773584},13298.199603773584,13298.199603773584]
[null,"Costo de aplicación de Sólidos",{"$f":"+'Costos y Resultados'!E7","v":0},null,{"$f":"B9","v":"Costo de aplicación de Sólidos"},0,0,0]
[null,"Costo de la Energía",{"$f":"+'Costos y Resultados'!E5","v":0},null,{"$f":"B10","v":"Costo de la Energía"},0,0,0]
[null,"Costos Operativos",{"$f":"+'Costos y Resultados'!E8","v":13298.199603773584},null,{"$f":"B11","v":"Costos Operativos"},13298.199603773584,13298.199603773584,13298.199603773584]
[null,"Ahorro en Fertilizante",{"$f":"+'Costos y Resultados'!E14","v":5441.3265285793532},null,{"$f":"B12","v":"Ahorro en Fertilizante"},5441.3265285793532,5441.3265285793532,5441.3265285793532]
[null,"Costo Operativo Neto",{"$f":"+C11-C12","v":7856.8730751942312},null,{"$f":"+B13","v":"Costo Operativo Neto"},7856.8730751942312,7856.8730751942312,7856.8730751942312]
[null,"Amortización",{"$f":"+'Costos y Resultados'!F36","v":657.8105333333333},null,"Amortización",657.8105333333333,657.8105333333333,657.8105333333333]
[null,"Costo Total",{"$f":"+C14+C13","v":8514.6836085275645},null,"Costo Total",8514.6836085275645,8514.6836085275645,8514.6836085275645]

{"sheet":"Bibliografía","index":4,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Bibliografía de referencia utilizada en el desarrollo de la herramienta"]
[]
[null,"Charlón, V., Taverna, M. A., Panigatti, C., & Gaggiotti, M. D. C. (2000). Cuantificación y caracterización de los efluentes generados en instalaciones de ordeño. Anuario 2000. EEA Rafaela.\n"]
[null,"Chesterton R.N., Pfiffer D.U., Morris R.S., and Tanner C.M. 1989; Environmental and behavioural factors affecting the prevalence of foot lameness in New Zealand dairy herds – a case control study. New Zealand Veterinary Journal 37, 135-142, 1989\n"]
[null,"Chesterton R.N. 2013. Lameness Management in Dairy Herds. Disponible en http://www.lamecow.co.nz/\n"]
[null,"Nennich, T. D.; Harrison, J. H.; VanWieringen, L. M.; Meyer, D. 2005;  Prediction of Manure and Nutrient Excretion from Dairy Cattle\n"]
[null,"Nosetti, L., Herrero, M. A., Pol, M., Maldonado May, V., Iramain, M. S., & Flores, M. (2002). Cuantificacion y caracterizacion de agua y efluentes en establecimientos lecheros. I. Demanda de agua y manejo de efluentes. InVet, 4(1), 37-43\n"]
[null,"Queensland effluent calculator, Version 4.6; 2007\n"]

{"sheet":"Listados","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,"Porcentaje de Retención de Sólidos","Pérdidas por volatilización de nitrógeno","Unidad de medida a graficar","Indirecto de columna E"]
[null,null,0.2,0,"m3/año","Datos de entrada'!C99:C103"]
[null,null,{"$f":"C6+1%","v":0.21000000000000002},0.3,"m3/año max.","Datos de entrada'!D99:D103"]
[null,null,{"$f":"C7+1%","v":0.22000000000000003},0.4,"l/dia","Datos de entrada'!E99:E103"]
[null,null,0.23000000000000004,null,"l/VO.dia","Datos de entrada'!F99:F103"]
[null,null,0.24000000000000005]
[null,null,0.25000000000000006]
[null,null,0.26000000000000006]
[null,null,{"$f":"C12+1%","v":0.27000000000000007}]
[null,null,0.28000000000000008]
[null,null,0.29000000000000009]
[null,null,0.3000000000000001]