{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calculadora"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Calculadora","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,3,1,5],[0,3,0,5],[7,0,7,3],[13,0,13,3],[14,0,14,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[8,0,8,3],[9,0,9,3],[17,0,17,3],[18,0,18,3],[19,0,19,3],[10,0,10,3],[11,0,11,3],[15,0,15,3]]}
[" ",null,null,"CALCULADORA DE REBAÑO LECHERO "]
[null,null,null,"Estimación de nacimientos de terneros(as) y necesidad de reemplazos "]
[null,null,null,null,{"$f":"IF(OR(E5=\"\",E6=\"\",E7=\"\",E8=\"\",E9=\"\",E10=\"\",E11=\"\",E12=\"\"),\"VALORES SON NECESARIOS\",\"\")","v":"VALORES SON NECESARIOS"}]
[null,null,null,null,"Promedio anual de su rebaño","Metas"]
["TAMAÑO DEL REBAÑO LECHERO",null,null,null,null,"-"]
["EDAD AL PRIMER PARTO EN MESES",null,null,null,25,"23 - 25"]
["% TASA DE REEMPLAZO DEL REBAÑO LECHERO",null,null,null,0.25,"-"]
["% TASA DE ELIMINACIÓN DE TERNERAS",null,null,null,0.06,"< 5%"]
["% TASA DE ELIMINACIÓN DE VAQUILLAS",null,null,null,0.1,"< 5%"]
["INTERVALO DE PARTO EN MESES (LIP)",null,null,null,12,"≤ 13"]
["% ENCASTE PARA CARNE",null,null,null,0.1,"-"]
["% DE TERNERAS NACIDAS",null,null,null,0.5,"-"]
[]
["VAQUILLAS NECESARIAS PARA MANTENER EL REBAÑO",null,null,null,{"$f":"IFERROR(ROUND(E5*(E6/24)*E7*(1+(E9+E8)),0),\"\")","v":0}]
["PRODUCCION ANUAL DE VAQUILLAS DE LECHE PARA REEMPLAZO ",null,null,null,{"$f":"IFERROR(ROUND(1*E5*(12/E10)*((1-E11)*E12)*(1-E8)*(24/E6),0),\"\")","v":0}]
["DIFERENCIA",null,null,null,{"$f":"IFERROR(E15-E14,\"\")","v":0}]
[]
["MACHOS LECHE NACIDOS",null,null,null,{"$f":"IFERROR(ROUND(E21-E19,0),\"\")*(12/E10)","v":0}]
["MACHOS CARNE NACIDOS",null,null,null,{"$f":"IFERROR(ROUND(((E5-E5*E12)*E11),0),\"\")*(12/E10)","v":0}]
["HEMBRAS CARNE NACIDAS",null,null,null,{"$f":"IFERROR(ROUND(E21*E11,0),\"\")*(12/E10)","v":0}]
[null,null,null,null,{"$f":"(E5-E5*E12)","v":0}]