{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Indice","Vendimia","Previnificacion","Vinificacion","Actividades y tareas","Resumen","Notas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"comments":4,"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":"Indice","index":0,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[13,3,13,4],[18,3,18,4],[23,3,23,4]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Indice General (I)",null,null,null,null,null,null,null,null,null,"Indice General (y II)"]
[]
[null,"Procesos:",null,null,null,null,null,null,null,null,null,"Configuración Básica: Actividades y tareas principales"]
[null,null,"Vendimia",null,null,null,null,null,null,null,null,null,"Actividades y Tareas Principales de Vendimia"]
[null,null,null,"Valoración de las actividades y tareas. Selección, recolección, transportes, etc",null,null,null,null,null,null,null,null,"Actividades y Tareas Principales de Previnificación"]
[null,null,null,"Valor añadido del proceso e indicadores del proceso de vendimia",null,null,null,null,null,null,null,null,"Actividades y Tareas Principales de Vinificación Complementaria"]
[null,null,null,"Output - Valoración: ",null,"Uva en bodega"]
[null,null,null,null,null,null,null,null,null,null,null,"Configuración Básica: Actividades y tareas auxliares"]
[null,null,"Previnificación",null,null,null,null,null,null,null,null,null,"Auxiliar: Uso de equipo de Depósitos"]
[null,null,null,"Valoración de las actividades y tareas. Prensado, maceración, etc",null,null,null,null,null,null,null,null,"Auxiliar: Uso de equipo de Bombas"]
[null,null,null,"Valor añadido del proceso e indicadores",null,null,null,null,null,null,null,null,"Auxiliar: Uso de equipo de Limpieza"]
[null,null,null,"Output - Valoración: ",null,"Mosto-Vinos",null,null,null,null,null,null,"Auxiliar: Uso de equipo de Frío"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Auxiliar: Uso de equipo de Embotellado"]
[null,null,"Vinificación Complementaria",null,null,null,null,null,null,null,null,null,"Auxiliar: Uso de equipo de Vendimia"]
[null,null,null,"Valoración de las actividades y tareas. Mezclas, crianza, clarificación, etc.",null,null,null,null,null,null,null,null,"Auxiliar: Uso de equipo de Prensa"]
[null,null,null,"Valor añadido del proceso e indicadores",null,null,null,null,null,null,null,null,"Auxiliar: Uso de equipo de Barricas"]
[null,null,null,"Output - Valoración: ",null,"Vinos terminados"]
[null,null,"Resumen",null,null,null,null,null,null,null,null,"Configuración básica: Parámetros  y ajuste contable"]
[null,null,null,"Resumen del proceso industrial y estudio del valor añadido",null,null,null,null,null,null,null,null,"Párametros generales"]
[null,null,null,"Costes e indicadores básicos",null,null,null,null,null,null,null,null,null,"Coste medio de hora de operario de bodega"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Depósito tipo"]
[null,"Pendiente de desarrollo",null,null,null,null,null,null,null,null,null,null,null,"Capacidad Barrica Tipo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Consejos de navegación atraves de"]
[null,"Radiografía del Gasto",null,null,null,null,null,null,null,null,null,null,"Consejos de navegacion atráves de los vínculos del libro"]
[null,"Cuadro de mando y analisis de sensibilidad",null,null,null,null,null,null,null,null,null,null,"Notas generales"]

{"sheet":"Vendimia","index":1,"n_rows":30,"n_cols":20,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,14,5,15],[20,22,20,23],[3,17,3,18],[7,19,7,20],[8,19,8,20],[5,17,6,18],[9,19,9,20],[10,19,10,20],[11,19,11,20],[7,16,7,17],[18,22,18,23],[19,22,19,23],[4,17,4,18],[2,3,2,8],[15,3,16,3],[4,9,6,9],[4,7,5,7],[4,8,5,8],[4,5,5,5],[4,6,5,6],[15,4,16,4],[13,9,14,9],[4,4,5,4],[12,3,12,4],[21,3,22,3],[15,1,22,1],[21,5,22,5],[21,6,22,6],[21,7,22,7],[17,4,18,4],[19,4,20,4],[19,5,20,5],[19,6,20,6],[19,7,20,7],[17,3,18,3],[19,3,20,3],[17,5,18,5],[17,6,18,6],[17,7,18,7],[15,5,16,5],[21,4,22,4],[24,4,25,4],[19,8,20,8],[21,8,22,8],[15,8,16,8],[17,8,18,8],[15,6,16,6],[15,7,16,7]]}
["Estimación del calculo y getión de costes en bodega"]
[]
[null,null,null,"Proceso Vendimia: Actividades y tareas",null,null,null,null,null,null,null,null,"Resumen del proceso, valor añadido e indicadores"]
[null,null,null,null,"Código:","Lb","Ti","Ne","Ln"]
[null,null,"Nota 0",null,"Total","Listán Blanco","Tintilla","Negramoll","Listán Negra",null,null,null,null,null,null,null,null,"Valor añadido"]
[null,"Costes Directos",null,null,null,null,null,null,null,null,null,null,"Coste de la uva",null,{"$f":"E7","v":110000},null,{"$f":"E9","v":144500},{"$f":"Q7/Q6","v":0.10726643598615918}]
[null,null,"Nota 1",null,{"$f":"F7+G7+H7+I7","v":110000},15000,25000,40000,30000,null,null,null,"Coste de proceso: vendimia",null,null,null,{"$f":"E22","v":15500}]
[null,null,null,null,{"$f":"((F7*F8)+(G7*G8)+(H7*H8)+(I7*I8))/E7","v":1.3136363636363637},0.9,1.2,1.7,1.1000000000000001,null,null,null,null,null,null,null,"% s/vendimia",null,"V.añadido","Valores medio para:"]
[null,null,null,null,{"$f":"SUM(F9:I9)","v":144500},{"$f":"F7*F8","v":13500},{"$f":"G7*G8","v":30000},68000,33000,null,null,null,"Valoración de las actividades",null,null,null,null,null,null,100]
[null,null,null,null,"Rechazo:",5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,null,null,null,null,{"$f":"D16","v":"Selección, recolección y transporte"},null,null,{"$f":"E16","v":1500},{"$f":"Q10/$Q$7","v":9.6774193548387094E-2},{"$f":"Q10/$Q$6","v":1.0380622837370242E-2},{"$f":"(Q10/$O$6)*$T$9","v":1.3636363636363635}]
[null,null,null,null,{"$f":"SUM(F11:H11)","v":400},{"$f":"F10*F7","v":75},{"$f":"G10*G7","v":125},{"$f":"H10*H7","v":200},{"$f":"I10*I7","v":150},null,null,null,null,{"$f":"D18","v":"Recepción de uva en bodega"},null,null,{"$f":"E18","v":12500},{"$f":"Q11/$Q$7","v":0.80645161290322576},{"$f":"Q11/$Q$6","v":8.6505190311418678E-2},{"$f":"(Q11/$O$6)*$T$9","v":11.363636363636363}]
[null,null,null,null,null,{"$f":"F7-F11","v":14925},{"$f":"G7-G11","v":24875},{"$f":"H7-H11","v":39800},{"$f":"I7-I11","v":29850},null,null,null,null,{"$f":"D20","v":"Personal de vendimia"},null,null,{"$f":"E20","v":1500},9.6774193548387094E-2,1.0380622837370242E-2,1.3636363636363635]
[null,null,null,"Significación:",null,{"$f":"F12/$E$7","v":0.13568181818181818},{"$f":"G12/$E$7","v":0.22613636363636364},0.36181818181818182,0.27136363636363636]
[null,null,null,null,null,null,null,null,null,"Comprobación (Cheking)"]
[null,"Costes Indirectos: Procesos y actividades"]
[null,"Vendimia","Nota 2","Selección, recolección y transporte",{"$f":"'Actividades y tareas'!D14","v":1500},300,200,300,700,{"$f":"IF(E16-SUM(F16:I16)>0,\"Faltan \"&E16-SUM(F16:I16),IF(E16-SUM(F16:I16)<0,\"Exceso \"&E16-SUM(F16:I16),\"Correcto\"))","v":"Correcto"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(F16:I17)","v":1500}]
[null,null,null,"Recepción de uva en bodega",{"$f":"'Actividades y tareas'!D21","v":12500},1500,6500,3000,1500,{"$f":"IF(E18-SUM(F18:I18)>0,\"Faltan \"&E18-SUM(F18:I18),IF(E18-SUM(F18:I18)<0,\"Exceso \"&E18-SUM(F18:I18),\"Correcto\"))","v":"Correcto"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(F18:I19)","v":12500}]
[null,null,null,"Personal de vendimia",{"$f":"'Actividades y tareas'!D27","v":1500},1500,null,null,null,{"$f":"IF(E20-SUM(F20:I20)>0,\"Faltan \"&E20-SUM(F20:I20),IF(E20-SUM(F20:I20)<0,\"Exceso \"&E20-SUM(F20:I20),\"Correcto\"))","v":"Correcto"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(F20:I21)","v":1500}]
[null,null,null,"Total coste de las actividades",{"$f":"F22+G22+H22+I22","v":15500},{"$f":"F20+F18+F16","v":3300},{"$f":"SUM(G16:G21)","v":6700},3300,2200,{"$f":"IF((E16+E18+E20)-SUM(F22:I22)>0,\"Faltan \"&(E16+E18+E20)-SUM(F22:I22),IF((E16+E18+E20)-SUM(F22:I22)<0,\"Exceso \"&(E16+E18+E20)-SUM(F22:I22),\"Correcto\"))","v":"Correcto"}]
[null,null,null,null,null,null,null,null,null,{"$f":"F22+G22+H22+I22","v":15500}]
[]
[null,null,null,null,{"$f":"E5","v":"Total"},{"$f":"F5","v":"Listán Blanco"},{"$f":"G5","v":"Tintilla"},{"$f":"H5","v":"Negramoll"},{"$f":"I5","v":"Listán Negra"}]
[null,"Output: Uva en bodega",null,null,null,{"$f":"F4","v":"Lb"},{"$f":"G4","v":"Ti"},"Ne","Ln"]
[null,null,null,"Kilos Netos:",{"$f":"SUM(F27:I27)","v":109450},{"$f":"F12","v":14925},{"$f":"G12","v":24875},{"$f":"H12","v":39800},{"$f":"I12","v":29850}]
[null,null,null,"Coste Total:",{"$f":"SUM(F28:I28)","v":160000},{"$f":"F9+F22","v":16800},{"$f":"G9+G22","v":36700},{"$f":"H9+H22","v":71300},{"$f":"I9+I22","v":35200}]
[null,null,null,"Coste Unitario:",{"$f":"E28/E27","v":1.4618547281863865},{"$f":"F28/F27","v":1.1256281407035176},{"$f":"G28/G27","v":1.4753768844221105},{"$f":"H28/H27","v":1.7914572864321607},{"$f":"I28/I27","v":1.1792294807370185}]
[null,null,null,"Valor Añadido:",{"$f":"IFERROR((E28-E9)/E9,0)","v":0.10726643598615918},{"$f":"IFERROR((F28-F9)/F9,0)","v":0.24444444444444444},{"$f":"IFERROR((G28-G9)/G9,0)","v":0.22333333333333333},{"$f":"IFERROR((H28-H9)/H9,0)","v":4.8529411764705883E-2},{"$f":"IFERROR((I28-I9)/I9,0)","v":6.6666666666666666E-2}]

{"sheet":"Previnificacion","index":2,"n_rows":81,"n_cols":21,"rows_kept":81,"cut":false,"hidden":false,"merged":[[18,20,18,21],[19,20,19,21],[12,20,12,21],[15,3,17,3],[24,10,25,10],[13,20,13,21],[14,20,14,21],[15,20,15,21],[16,20,16,21],[17,20,17,21],[2,4,2,9],[6,3,8,3],[6,4,8,4],[9,3,11,3],[12,3,14,3],[9,4,11,4],[12,4,14,4],[3,18,3,19],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,18,4,19],[4,10,5,10],[5,15,5,16],[52,4,52,5],[54,4,54,5],[57,4,57,5],[6,1,20,1],[18,25,18,26],[19,25,19,26],[20,25,20,26],[18,3,20,4],[15,4,17,4],[8,17,8,18],[8,20,8,21],[9,20,9,21],[10,20,10,21],[11,20,11,21],[21,3,21,5],[28,3,30,3],[25,1,43,1],[49,1,68,1],[72,3,72,4],[71,3,71,4],[36,3,38,3],[36,4,36,5],[59,3,63,3],[64,3,68,3],[67,4,67,5],[59,4,59,5],[62,4,62,5],[64,4,64,5],[39,3,43,3],[49,3,53,3],[54,3,58,3],[25,4,25,5],[6,18,6,19],[7,18,7,19],[74,3,76,4],[77,3,77,4],[78,3,78,4],[69,9,70,9],[75,9,76,9],[69,3,70,4],[28,4,28,5],[25,3,27,3],[31,4,31,5],[33,4,33,5],[31,3,35,3],[42,4,42,5],[39,4,39,5],[49,4,49,5],[80,3,80,4],[69,5,70,5],[69,6,70,6],[69,7,70,7],[69,8,70,8],[75,6,76,6],[75,7,76,7],[75,8,76,8],[79,3,79,4],[74,5,76,5]]}
["Estimación del calculo y getión de costes en bodega"]
[]
[null,null,null,null,"Proceso Previnificación: Actividades y tareas",null,null,null,null,null,null,null,null,"Resumen del proceso, valor añadido  e indicadores"]
[null,null,null,null,null,null,"Mosto 1","Mosto 2","Mosto 3","Mosto 4"]
[null,null,"Nota 0",null,null,"Total",{"$f":"IF(G7>0,$E$7,\"\")&IF(G10>0,\"-\"&$E$10,\"\")&IF(G13>0,\"-\"&$E$13,\"\")&IF(G16>0,\"-\"&$E$16,\"\")","v":"Lb-Ti"},{"$f":"IF(H7>0,$E$7,\"\")&IF(H10>0,\"-\"&$E$10,\"\")&IF(H13>0,\"-\"&$E$13,\"\")&IF(H16>0,\"-\"&$E$16,\"\")","v":"-Ti-Ne"},"-Ti-Ne","-Ne-Ln","Comprobación (Cheking)",null,null,null,null,null,null,null,"Valor añadido"]
[null,"Costes Directos",null,null,null,null,null,null,null,null,null,null,null,"Coste de la uva",null,{"$f":"Vendimia!O6","v":110000},null,{"$f":"Vendimia!Q6","v":144500}]
[null,"Consumo de uva","Nota 3",{"$f":"Vendimia!F25","v":"Listán Blanco"},{"$f":"Vendimia!F26","v":"Lb"},{"$f":"Vendimia!F27","v":14925},14925,null,null,null,{"$f":"IF(F7-SUM(G7:J7)>0,\"Faltan \"&F7-SUM(G7:J7),IF(F7-SUM(G7:J7)<0,\"Exceso \"&F7-SUM(G7:J7),\"Correcto\"))","v":"Correcto"},null,null,"Coste de proceso: vendimia",null,null,null,{"$f":"Vendimia!Q7","v":15500},{"$f":"R7/R6","v":0.10726643598615918}]
[null,null,null,null,null,{"$f":"Vendimia!F29","v":1.1256281407035176},{"$f":"IF(G7=\"\",\"\",IF(G7>0,$F$8,\"\"))","v":1.1256281407035176},{"$f":"IF(H7=\"\",\"\",IF(H7>0,$F$8,\"\"))","v":""},"","",{"$f":"SUM(G7:J8)","v":14926.125628140704},null,null,"Coste de proceso: previnificación",null,null,null,{"$f":"F70","v":9300.8894272038578},{"$f":"R8/R6","v":6.4366016797258535E-2}]
[null,null,null,null,null,{"$f":"SUM(G9:J9)","v":16800},{"$f":"IFERROR(G7*G8,\"\")","v":16800},{"$f":"IFERROR(H7*H8,\"\")","v":""},"","",null,null,null,null,null,null,null,"% s/previnificación",null,"V.añadido","Valores medio para:"]
[null,null,null,{"$f":"Vendimia!G25","v":"Tintilla"},{"$f":"Vendimia!G26","v":"Ti"},{"$f":"Vendimia!G27","v":24875},4000,20000,875,0,{"$f":"IF(F10-SUM(G10:J10)>0,\"Faltan \"&F10-SUM(G10:J10),IF(F10-SUM(G10:J10)<0,\"Exceso \"&F10-SUM(G10:J10),\"Correcto\"))","v":"Correcto"},null,null,"Valoración de las actividades",null,null,null,null,null,null,100]
[null,null,null,null,null,{"$f":"Vendimia!G29","v":1.4753768844221105},{"$f":"IF(G10=\"\",\"\",IF(G10>0,$F$11,\"\"))","v":1.4753768844221105},{"$f":"IF(H10=\"\",\"\",IF(H10>0,$F$11,\"\"))","v":1.4753768844221105},1.4753768844221105,"",{"$f":"SUM(G10:J11)","v":24879.426130653272},null,null,null,{"$f":"D26","v":"Despalillado y Estrujado"},null,null,{"$f":"K27+K28","v":598.74976053719001},{"$f":"R11/$R$8","v":6.4375537976607597E-2},{"$f":"R11/$R$6","v":4.1435969587348791E-3},{"$f":"(R11/$P$6)*$U$10","v":0.54431796412471822}]
[null,null,null,null,null,{"$f":"SUM(G12:J12)","v":36699.999999999993},{"$f":"IFERROR(G10*G11,\"\")","v":5901.5075376884415},{"$f":"IFERROR(H10*H11,\"\")","v":29507.537688442208},1290.9547738693466,"",null,null,null,null,{"$f":"D29","v":"Prensado"},null,null,{"$f":"K30+K31","v":1219.9396666666664},{"$f":"R12/$R$8","v":0.13116376409104552},{"$f":"R12/$R$6","v":8.4424890426758915E-3},{"$f":"(R12/$P$6)*$U$10","v":1.1090360606060603}]
[null,null,null,{"$f":"Vendimia!H25","v":"Negramoll"},{"$f":"Vendimia!H26","v":"Ne"},{"$f":"Vendimia!H27","v":39800},null,400,39000,400,{"$f":"IF(F13-SUM(G13:J13)>0,\"Faltan \"&F13-SUM(G13:J13),IF(F13-SUM(G13:J13)<0,\"Exceso \"&F13-SUM(G13:J13),\"Correcto\"))","v":"Correcto"},null,null,null,{"$f":"D32","v":"Desfangado"},null,null,{"$f":"K33+K35+K36","v":771.81111111111113},8.2982505829352932E-2,5.3412533640907348E-3,0.70164646464646463]
[null,null,null,null,null,{"$f":"Vendimia!H29","v":1.7914572864321607},{"$f":"IF(G13=\"\",\"\",IF(G13>0,$F$14,\"\"))","v":""},{"$f":"IF(H13=\"\",\"\",IF(H13>0,$F$14,\"\"))","v":1.7914572864321607},1.7914572864321607,1.7914572864321607,{"$f":"SUM(G13:J14)","v":39805.374371859296},null,null,null,{"$f":"D37","v":"Encubado"},null,null,{"$f":"K38+K39","v":4076.5748611111117},0.43829946512294571,2.8211590734332954E-2,3.7059771464646474]
[null,null,null,null,null,{"$f":"SUM(G15:J15)","v":71300},{"$f":"IFERROR(G13*G14,\"\")","v":""},{"$f":"IFERROR(H13*H14,\"\")","v":716.5829145728643},69866.834170854272,716.5829145728643,null,null,null,null,{"$f":"D40","v":"Maceración Carbónica"},null,null,{"$f":"K41+K42+K44","v":347.02486111111114},3.7310932876603156E-2,2.4015561322568244E-3,0.31547714646464647]
[null,null,null,{"$f":"Vendimia!I25","v":"Listán Negra"},{"$f":"Vendimia!I26","v":"Ln"},{"$f":"Vendimia!I27","v":29850},null,null,null,29850,{"$f":"IF(F16-SUM(G16:J16)>0,\"Faltan \"&F16-SUM(G16:J16),IF(F16-SUM(G16:J16)<0,\"Exceso \"&F16-SUM(G16:J16),\"Correcto\"))","v":"Correcto"},null,null,null,{"$f":"D50","v":"Fermentación Alcohólica"},null,null,{"$f":"K51+K52+K54","v":460.17486111111111},4.9476436066980989E-2,3.1846011149557862E-3,0.41834078282828285]
[null,null,null,null,null,{"$f":"Vendimia!I29","v":1.1792294807370185},{"$f":"IF(G16=\"\",\"\",IF(G16>0,$F$17,\"\"))","v":""},{"$f":"IF(H16=\"\",\"\",IF(H16>0,$F$17,\"\"))","v":""},"",1.1792294807370185,{"$f":"SUM(G16:J17)","v":29851.179229480738},null,null,null,{"$f":"D55","v":"Maceración Pelicular en Frío"},null,null,{"$f":"K56+K57+K59","v":541.22736111111112},5.8190925217118855E-2,3.7455180699730874E-3,0.49202487373737369]
[null,null,null,null,null,{"$f":"SUM(G18:J18)","v":35200},{"$f":"IFERROR(G16*G17,\"\")","v":""},{"$f":"IFERROR(H16*H17,\"\")","v":""},"",35200,null,null,null,null,{"$f":"D60","v":"Fermentación Maloláctica"},null,null,{"$f":"K61+K62+K64","v":563.71736111111113},6.0608973531317688E-2,3.9011582083813921E-3,0.51247032828282824]
[null,null,null,"Subtotal Costes Directos",null,{"$f":"SUM(G19:J19)","v":109450},{"$f":"G16+G13+G10+G7","v":18925},{"$f":"H16+H13+H10+H7","v":20400},39875,30250,null,null,null,null,{"$f":"D65","v":"Descube y Escurrido"},null,null,{"$f":"K66+K67+K69","v":721.66958333333332},7.7591459288027478E-2,4.994253171856978E-3,0.65606325757575756]
[null,null,null,null,null,{"$f":"F21/F19","v":1.4618547281863865},{"$f":"G21/G19","v":1.199551256945228},{"$f":"H21/H19","v":1.4815745393634838},1.7845213528457335,1.1873250550272021,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T11:T19)","v":6.4366016797258521E-2},{"$f":"SUM(U10:V19)","v":108.45535402473077}]
[null,null,null,null,null,{"$f":"SUM(G21:J21)","v":160000},{"$f":"_xlfn.AGGREGATE(9,6,G9,G12,G15,G18)","v":22701.507537688442},{"$f":"_xlfn.AGGREGATE(9,6,H9,H12,H15,H18)","v":30224.120603015072},71157.788944723623,35916.582914572864]
[null,null,null,"Rendimientos",null,null,0.75,0.7,0.7,0.7]
[null,null,null,null,null,{"$f":"SUM(G23:J23)","v":77561.25},{"$f":"G22*G19","v":14193.75},{"$f":"H22*H19","v":14280},{"$f":"I22*I19","v":27912.5},{"$f":"J22*J19","v":21175}]
[]
[null,"Costes Indirectos: Procesos y actividades (I)"]
[null,"Previnificación","Nota 3","Despalillado y Estrujado","nº de veces:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M7","v":40.387933884297524},{"$f":"IFERROR(IF(G26=\"\",\"\",IF(G26>0,$F$27*G26,\"\")),\"\")","v":40.387933884297524},{"$f":"IFERROR(IF(H26=\"\",\"\",IF(H26>0,$F$27*H26,\"\")),\"\")","v":40.387933884297524},40.387933884297524,40.387933884297524,{"$f":"_xlfn.AGGREGATE(9,6,G27,H27,I27,J27)","v":161.5517355371901}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M8","v":3.9944999999999999},{"$f":"IFERROR(IF(G26=\"\",\"\",IF(G26>0,$F$28*(G19/1000)*(G26/G26),\"\")),\"\")","v":75.595912499999997},{"$f":"IFERROR(IF(H26=\"\",\"\",IF(H26>0,$F$28*(H19/1000)*(H26/H26),\"\")),\"\")","v":81.487799999999993},159.2806875,120.833625,{"$f":"_xlfn.AGGREGATE(9,6,G28,H28,I28,J28)","v":437.19802499999997}]
[null,null,null,"Prensado","nº de veces:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M29","v":11.111666666666668},{"$f":"IFERROR(IF(G29=\"\",\"\",IF(G29>0,$F$30*G29,\"\")),\"\")","v":11.111666666666668},{"$f":"IFERROR(IF(H29=\"\",\"\",IF(H29>0,$F$30*H29,\"\")),\"\")","v":11.111666666666668},11.111666666666668,11.111666666666668,{"$f":"_xlfn.AGGREGATE(9,6,G30,H30,I30,J30)","v":44.446666666666673}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M30","v":10.739999999999998},{"$f":"IFERROR(IF(G29=\"\",\"\",IF(G29>0,$F$31*(G19/1000)*(G29/G29),\"\")),\"\")","v":203.25449999999998},{"$f":"IFERROR(IF(H29=\"\",\"\",IF(H29>0,$F$31*(H19/1000)*(H29/H29),\"\")),\"\")","v":219.09599999999995},428.25749999999994,324.88499999999993,{"$f":"_xlfn.AGGREGATE(9,6,G31,H31,I31,J31)","v":1175.4929999999997}]
[null,null,null,"Desfangado","nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M60","v":12.027777777777779},{"$f":"IFERROR(IF(G32=\"\",\"\",IF(G32>0,$F$33*G32,\"\")),\"\")","v":12.027777777777779},{"$f":"IF(H32=\"\",\"\",IF(H32>0,$F$33*H32,\"\"))","v":12.027777777777779},12.027777777777779,12.027777777777779,{"$f":"_xlfn.AGGREGATE(9,6,G33,H33,I33,J33)","v":48.111111111111114}]
[null,null,null,null,"Nº veces",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M59","v":27.695},{"$f":"IFERROR(IF(G34=\"\",\"\",IF(G34>0,$F$35*G34,\"\")),\"\")","v":27.695},{"$f":"IFERROR(IF(H34=\"\",\"\",IF(H34>0,$F$35*H34,\"\")),\"\")","v":27.695},27.695,27.695,{"$f":"_xlfn.AGGREGATE(9,6,G35,H35,I35,J35)","v":110.78}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M61","v":5.6},{"$f":"IFERROR(IF(G34=\"\",\"\",IF(G34>0,$F$36*(G19/1000)*(G34/G34),\"\")),\"\")","v":105.98},{"$f":"IFERROR(IF(H34=\"\",\"\",IF(H34>0,$F$36*(H19/1000)*(H34/H34),\"\")),\"\")","v":114.23999999999998},223.29999999999998,169.39999999999998,{"$f":"_xlfn.AGGREGATE(9,6,G36,H36,I36,J36)","v":612.91999999999996}]
[null,null,null,"Encubado","nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M76","v":960.97277777777788},{"$f":"IFERROR(IF(G37=\"\",\"\",IF(G37>0,$F$38*G37,\"\")),\"\")","v":960.97277777777788},{"$f":"IFERROR(IF(H37=\"\",\"\",IF(H37>0,$F$38*H37,\"\")),\"\")","v":960.97277777777788},960.97277777777788,960.97277777777788,{"$f":"_xlfn.AGGREGATE(9,6,G38,H38,I38,J38)","v":3843.8911111111115}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M77","v":3},{"$f":"IFERROR(IF(G37=\"\",\"\",IF(G37>0,$F$39*(G23/1000)*(G37/G37),\"\")),\"\")","v":42.581249999999997},{"$f":"IFERROR(IF(H37=\"\",\"\",IF(H37>0,$F$39*(H23/1000)*(H37/H37),\"\")),\"\")","v":42.839999999999996},83.737500000000011,63.525000000000006,{"$f":"_xlfn.AGGREGATE(9,6,G39,H39,I39,J39)","v":232.68375}]
[null,null,null,"Maceración Carbónica","Nº veces",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M96","v":12.945},{"$f":"IFERROR(IF(G40=\"\",\"\",IF(G40>0,$F$41*G40,\"\")),\"\")","v":12.945},{"$f":"IFERROR(IF(H40=\"\",\"\",IF(H40>0,$F$41*H40,\"\")),\"\")","v":12.945},12.945,12.945,{"$f":"_xlfn.AGGREGATE(9,6,G41,H41,I41,J41)","v":51.78}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M97","v":3},{"$f":"IFERROR(IF(G40=\"\",\"\",IF(G40>0,$F$42*(G23/1000)*(G40/G40),\"\")),\"\")","v":42.581249999999997},{"$f":"IFERROR(IF(H40=\"\",\"\",IF(H40>0,$F$42*(H23/1000)*(H40/H40),\"\")),\"\")","v":42.839999999999996},83.737500000000011,63.525000000000006,{"$f":"_xlfn.AGGREGATE(9,6,G42,H42,I42,J42)","v":232.68375}]
[null,null,null,null,"nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M98","v":26.477777777777781},{"$f":"IFERROR(IF(G43=\"\",\"\",IF(G43>0,$F$44*G43,\"\")),\"\")","v":26.477777777777781},{"$f":"IF(H43=\"\",\"\",IF(H43>0,$F$33*H43,\"\"))","v":12.027777777777779},12.027777777777779,12.027777777777779,{"$f":"_xlfn.AGGREGATE(9,6,G44,H44,I44,J44)","v":62.561111111111117}]
[]
[]
[]
[]
[null,"Costes Indirectos: Procesos y actividades (y II)"]
[null,"Previnificación","Nota 3","Fermentación Alcohólica","Nº veces",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M114","v":4.4450000000000003},{"$f":"IFERROR(IF(G50=\"\",\"\",IF(G50>0,$F$51*G50,\"\")),\"\")","v":4.4450000000000003},{"$f":"IFERROR(IF(H50=\"\",\"\",IF(H50>0,$F$51*H50,\"\")),\"\")","v":4.4450000000000003},4.4450000000000003,4.4450000000000003,{"$f":"_xlfn.AGGREGATE(9,6,G51,H51,I51,J51)","v":17.78}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M115","v":3},{"$f":"IFERROR(IF(G50=\"\",\"\",IF(G50>0,$F$52*(G23/1000)*(G50/G50),\"\")),\"\")","v":42.581249999999997},{"$f":"IFERROR(IF(H50=\"\",\"\",IF(H50>0,$F$52*(H23/1000)*(H50/H50),\"\")),\"\")","v":42.839999999999996},83.737500000000011,63.525000000000006,{"$f":"_xlfn.AGGREGATE(9,6,G52,H52,I52,J52)","v":232.68375}]
[null,null,null,null,"nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M116","v":52.427777777777784},{"$f":"IFERROR(IF(G53=\"\",\"\",IF(G53>0,$F$54*G53,\"\")),\"\")","v":52.427777777777784},{"$f":"IFERROR(IF(H53=\"\",\"\",IF(H53>0,$F$54*H53,\"\")),\"\")","v":52.427777777777784},52.427777777777784,52.427777777777784,{"$f":"_xlfn.AGGREGATE(9,6,G54,H54,I54,J54)","v":209.71111111111114}]
[null,null,null,"Maceración Pelicular en Frío","Nº veces",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M129","v":4.4450000000000003},{"$f":"IFERROR(IF(G55=\"\",\"\",IF(G55>0,$F$56*G55,\"\")),\"\")","v":4.4450000000000003},{"$f":"IFERROR(IF(H55=\"\",\"\",IF(H55>0,$F$56*H55,\"\")),\"\")","v":4.4450000000000003},4.4450000000000003,4.4450000000000003,{"$f":"_xlfn.AGGREGATE(9,6,G56,H56,I56,J56)","v":17.78}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M130","v":5},{"$f":"IFERROR(IF(G55=\"\",\"\",IF(G55>0,$F$57*(G23/1000)*(G55/G55),\"\")),\"\")","v":70.96875},{"$f":"IFERROR(IF(H55=\"\",\"\",IF(H55>0,$F$57*(H23/1000)*(H55/H55),\"\")),\"\")","v":71.399999999999991},139.5625,105.875,{"$f":"_xlfn.AGGREGATE(9,6,G57,H57,I57,J57)","v":387.80624999999998}]
[null,null,null,null,"nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M131","v":33.910277777777779},{"$f":"IFERROR(IF(G58=\"\",\"\",IF(G58>0,$F$59*G58,\"\")),\"\")","v":33.910277777777779},{"$f":"IFERROR(IF(H58=\"\",\"\",IF(H58>0,$F$59*H58,\"\")),\"\")","v":33.910277777777779},33.910277777777779,33.910277777777779,{"$f":"_xlfn.AGGREGATE(9,6,G59,H59,I59,J59)","v":135.64111111111112}]
[null,null,null,"Fermentación Maloláctica","Nº veces",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M144","v":4.4450000000000003},{"$f":"IFERROR(IF(G60=\"\",\"\",IF(G60>0,$F$61*G60,\"\")),\"\")","v":4.4450000000000003},{"$f":"IFERROR(IF(H60=\"\",\"\",IF(H60>0,$F$61*H60,\"\")),\"\")","v":4.4450000000000003},4.4450000000000003,4.4450000000000003,{"$f":"_xlfn.AGGREGATE(9,6,G61,H61,I61,J61)","v":17.78}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M130","v":5},{"$f":"IFERROR(IF(G60=\"\",\"\",IF(G60>0,$F$62*(G23/1000)*(G60/G60),\"\")),\"\")","v":70.96875},{"$f":"IFERROR(IF(H60=\"\",\"\",IF(H60>0,$F$62*(H23/1000)*(H60/H60),\"\")),\"\")","v":71.399999999999991},139.5625,105.875,{"$f":"_xlfn.AGGREGATE(9,6,G62,H62,I62,J62)","v":387.80624999999998}]
[null,null,null,null,"nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M146","v":39.532777777777781},{"$f":"IFERROR(IF(G63=\"\",\"\",IF(G63>0,$F$64*G63,\"\")),\"\")","v":39.532777777777781},{"$f":"IFERROR(IF(H63=\"\",\"\",IF(H63>0,$F$64*H63,\"\")),\"\")","v":39.532777777777781},39.532777777777781,39.532777777777781,{"$f":"_xlfn.AGGREGATE(9,6,G64,H64,I64,J64)","v":158.13111111111112}]
[null,null,null,"Descube y Escurrido","Nº veces",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M170","v":38.445},{"$f":"IFERROR(IF(G65=\"\",\"\",IF(G65>0,$F$66*G65,\"\")),\"\")","v":38.445},{"$f":"IFERROR(IF(H65=\"\",\"\",IF(H65>0,$F$66*H65,\"\")),\"\")","v":38.445},38.445,38.445,{"$f":"_xlfn.AGGREGATE(9,6,G66,H66,I66,J66)","v":153.78}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!M171","v":5},{"$f":"IFERROR(IF(G65=\"\",\"\",IF(G65>0,$F$67*(G23/1000)*(G65/G65),\"\")),\"\")","v":70.96875},{"$f":"IFERROR(IF(H65=\"\",\"\",IF(H65>0,$F$67*(H23/1000)*(H65/H65),\"\")),\"\")","v":71.399999999999991},139.5625,105.875,{"$f":"_xlfn.AGGREGATE(9,6,G67,H67,I67,J67)","v":387.80624999999998}]
[null,null,null,null,"nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!M172","v":45.020833333333336},{"$f":"IFERROR(IF(G68=\"\",\"\",IF(G68>0,$F$69*G68,\"\")),\"\")","v":45.020833333333336},{"$f":"IFERROR(IF(H68=\"\",\"\",IF(H68>0,$F$69*H68,\"\")),\"\")","v":45.020833333333336},45.020833333333336,45.020833333333336,{"$f":"_xlfn.AGGREGATE(9,6,G69,H69,I69,J69)","v":180.08333333333334}]
[null,null,null,"Subtotal coste de las actividades",null,{"$f":"G70+H70+I70+J70","v":9300.8894272038578},{"$f":"_xlfn.AGGREGATE(9,6,G27,G28,G30,G31,G33,G35,G36,G38,G39,G41,G42,G44,G51,G52,G54,G56,G57,G59,G61,G62,G64,G66,G67,G69)","v":2039.7700130509636},{"$f":"_xlfn.AGGREGATE(9,6,H27,H28,H30,H31,H33,H35,H36,H38,H39,H41,H42,H44,H51,H52,H54,H56,H57,H59,H61,H62,H64,H66,H67,H69)","v":2057.3834005509639},2780.5777880509654,2423.1582255509652]
[]
[null,null,null,"Merma del proceso",null,{"$f":"Notas!G31","v":1.2E-2},{"$f":"$F$72*G23","v":170.32500000000002},{"$f":"$F$72*H23","v":171.36},{"$f":"$F$72*I23","v":334.95},{"$f":"$F$72*J23","v":254.1}]
[null,null,null,"Mostos netos",null,{"$f":"SUM(G73:J73)","v":76630.514999999999},{"$f":"G23-G72","v":14023.424999999999},{"$f":"H23-H72","v":14108.64},{"$f":"I23-I72","v":27577.55},{"$f":"J23-J72","v":20920.900000000001}]
[]
[null,null,null,"Output: Mosto - Vino",null,"TOTAL",{"$f":"G4","v":"Mosto 1"},"Mosto 2","Mosto 3","Mosto 4"]
[null,null,null,null,null,null,"Lb-Ti","-Ti-Ne","-Ti-Ne","-Ne-Ln"]
[]
[null,null,null,"Mosto-Vino (Litros):",null,{"$f":"SUM(G78:J78)","v":76628},{"$f":"INT(G73)","v":14023},{"$f":"INT(H73)","v":14108},{"$f":"INT(I73)","v":27577},{"$f":"INT(J73)","v":20920}]
[null,null,null,"Coste Total:",null,{"$f":"SUM(G79:J79)","v":169300.88942720386},{"$f":"G70+G21","v":24741.277550739404},{"$f":"H70+H21","v":32281.504003566035},{"$f":"I70+I21","v":73938.366732774593},{"$f":"J70+J21","v":38339.741140123828}]
[null,null,null,"Coste Unitario:",null,{"$f":"F79/F78","v":2.2093867702041532},{"$f":"G79/G78","v":1.7643355594907939},{"$f":"H79/H78","v":2.2881701164988684},{"$f":"I79/I78","v":2.6811606314238166},{"$f":"J79/J78","v":1.8326836109045808}]
[null,null,null,"Valor Añadido",null,{"$f":"F70/F21","v":5.8130558920024111E-2},{"$f":"G70/G21","v":8.9851742650332425E-2},{"$f":"H70/H21","v":6.8070910236697674E-2},{"$f":"I70/I21","v":3.9076225235314122E-2},{"$f":"J70/J21","v":6.7466279610017915E-2}]

{"sheet":"Vinificacion","index":3,"n_rows":96,"n_cols":21,"rows_kept":96,"cut":false,"hidden":false,"merged":[[25,1,46,1],[2,3,2,9],[85,8,86,8],[85,9,86,9],[31,4,31,5],[33,3,36,3],[33,4,33,5],[35,4,36,5],[37,4,37,5],[39,4,40,5],[71,8,72,8],[71,9,72,9],[53,1,67,1],[6,1,20,1],[18,3,20,4],[21,3,22,5],[85,6,86,6],[85,7,86,7],[53,3,54,5],[55,3,57,3],[71,6,72,6],[71,7,72,7],[70,4,72,5],[74,4,74,5],[73,4,73,5],[75,4,75,5],[70,3,77,3],[80,3,81,3],[95,3,95,4],[84,3,86,4],[25,4,25,5],[25,3,28,3],[29,3,32,3],[29,4,29,5],[90,3,90,4],[84,5,86,5],[88,5,89,5],[87,3,89,4],[41,4,42,5],[45,4,46,5],[43,4,43,5],[93,3,94,4],[29,2,46,2],[37,3,46,3],[77,4,77,5],[78,3,79,3],[55,2,69,2],[58,3,61,3],[62,3,64,3],[65,3,66,3],[67,3,69,3],[59,4,61,4],[60,5,61,5],[70,2,81,2],[18,20,18,21],[12,3,14,3],[12,4,14,4],[23,20,23,21],[19,20,19,21],[20,20,20,21],[21,20,21,21],[22,20,22,21],[13,20,13,21],[14,20,14,21],[15,20,15,21],[15,3,17,3],[15,4,17,4],[16,20,16,21],[17,20,17,21],[12,20,12,21],[6,3,8,3],[6,4,8,4],[6,18,6,19],[7,18,7,19],[9,17,9,18],[8,18,8,19],[9,20,9,21],[9,3,11,3],[9,4,11,4],[10,20,10,21],[11,20,11,21],[3,18,3,19],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,18,4,19],[5,15,5,16]]}
["Estimación del calculo y getión de costes en bodega"]
[]
[null,null,null,"Proceso Vinificación Complementaria: Actividades y tareas",null,null,null,null,null,null,null,null,null,"Resumen del proceso, valor añadido  e indicadores"]
[null,null,null,null,null,"Código:","Vino 1","Vino 2","Vino 3","Vino 4"]
[null,null,"Nota 0",null,null,"Total","Joven Blanco Semiseco","Tinto Crianza","Tinto Barrica","Tinto Reserva","Comprobación (Cheking)",null,null,null,null,null,null,null,"Valor añadido"]
[null,"Costes Directos",null,null,null,null,null,null,null,null,null,null,null,"Coste de la uva",null,{"$f":"Vendimia!O6","v":110000},null,{"$f":"Vendimia!Q6","v":144500}]
[null,"Consumo de Mostos - Vinos","Nota 4",{"$f":"Previnificacion!G75","v":"Mosto 1"},{"$f":"Previnificacion!G76","v":"Lb-Ti"},{"$f":"Previnificacion!G78","v":14023},14023,null,null,null,{"$f":"IF(F7-SUM(G7:J7)>0,\"Faltan \"&F7-SUM(G7:J7),IF(F7-SUM(G7:J7)<0,\"Exceso \"&F7-SUM(G7:J7),\"Correcto\"))","v":"Correcto"},null,null,"Coste de proceso: vendimia",null,null,null,{"$f":"Vendimia!Q7","v":15500},{"$f":"R7/R6","v":0.10726643598615918}]
[null,null,null,null,null,{"$f":"Previnificacion!G80","v":1.7643355594907939},{"$f":"IF(G7=\"\",\"\",IF(G7>0,$F$8,\"\"))","v":1.7643355594907939},{"$f":"IF(H7=\"\",\"\",IF(H7>0,$F$8,\"\"))","v":""},"","",{"$f":"SUM(G7:J8)","v":14024.76433555949},null,null,"Coste de proceso: previnificación",null,null,null,{"$f":"Previnificacion!R8","v":9300.8894272038578},{"$f":"R8/R6","v":6.4366016797258535E-2}]
[null,null,null,null,null,{"$f":"SUM(G9:J9)","v":24741.277550739404},{"$f":"IFERROR(G7*G8,\"\")","v":24741.277550739404},{"$f":"IFERROR(H7*H8,\"\")","v":""},"","",null,null,null,"Coste de proceso: vinificación",null,null,null,{"$f":"F91+F92","v":72031.509742180002},{"$f":"R9/R6","v":0.49848795669328722}]
[null,null,null,{"$f":"Previnificacion!H4","v":"Mosto 2"},{"$f":"Previnificacion!H5","v":"-Ti-Ne"},{"$f":"Previnificacion!H78","v":14108},null,12108,null,2000,{"$f":"IF(F10-SUM(G10:J10)>0,\"Faltan \"&F10-SUM(G10:J10),IF(F10-SUM(G10:J10)<0,\"Exceso \"&F10-SUM(G10:J10),\"Correcto\"))","v":"Correcto"},null,null,null,null,null,null,"% s/vinificación",null,"V.añadido","Valores medio para:"]
[null,null,null,null,null,{"$f":"Previnificacion!H80","v":2.2881701164988684},{"$f":"IF(G10=\"\",\"\",IF(G10>0,$F$11,\"\"))","v":""},{"$f":"IF(H10=\"\",\"\",IF(H10>0,$F$11,\"\"))","v":2.2881701164988684},"",2.2881701164988684,{"$f":"SUM(G10:J11)","v":14112.576340232998},null,null,"Valoración de las actividades",null,null,null,null,null,null,100]
[null,null,null,null,null,{"$f":"SUM(G12:J12)","v":32281.504003566035},{"$f":"IFERROR(G10*G11,\"\")","v":""},{"$f":"IFERROR(H10*H11,\"\")","v":27705.163770568299},"",4576.3402329977371,null,null,null,null,{"$f":"D26","v":"Selección, Mezcla o Coupage"},null,null,{"$f":"K27+K28+K29","v":329.77511111111113},{"$f":"R12/$R$9","v":4.5782062918223463E-3},{"$f":"R12/$R$6","v":2.282180699730873E-3},{"$f":"(R12/$P$6)*$U$11","v":0.29979555555555554}]
[null,null,null,{"$f":"Previnificacion!I4","v":"Mosto 3"},{"$f":"Previnificacion!I5","v":"-Ti-Ne"},{"$f":"Previnificacion!I78","v":27577},null,17850,5000,4727,{"$f":"IF(F13-SUM(G13:J13)>0,\"Faltan \"&F13-SUM(G13:J13),IF(F13-SUM(G13:J13)<0,\"Exceso \"&F13-SUM(G13:J13),\"Correcto\"))","v":"Correcto"},null,null,null,{"$f":"D30","v":"Trasiegos"},null,null,{"$f":"K31+K33","v":286.75},{"$f":"R13/$R$9","v":3.980896707931776E-3},{"$f":"R13/$R$6","v":1.9844290657439448E-3},{"$f":"(R13/$P$6)*$U$11","v":0.26068181818181818}]
[null,null,null,null,null,{"$f":"Previnificacion!I80","v":2.6811606314238166},{"$f":"IF(G13=\"\",\"\",IF(G13>0,$F$14,\"\"))","v":""},{"$f":"IF(H13=\"\",\"\",IF(H13>0,$F$14,\"\"))","v":2.6811606314238166},2.6811606314238166,2.6811606314238166,{"$f":"SUM(G13:J14)","v":27585.043481894267},null,null,null,{"$f":"D34","v":"Clarificación"},null,null,{"$f":"K35+K37","v":241.96449999999999},3.3591479737972384E-3,1.6744948096885813E-3,0.21996772727272729]
[null,null,null,null,null,{"$f":"SUM(G15:J15)","v":73938.366732774593},{"$f":"IFERROR(G13*G14,\"\")","v":""},{"$f":"IFERROR(H13*H14,\"\")","v":47858.717270915127},13405.803157119082,12673.84630474038,null,null,null,null,{"$f":"D38","v":"Filtrados"},null,null,{"$f":"K39+K41+K43+K45+K47","v":621.11637796666673},8.6228427002267207E-3,4.2983832385236455E-3,0.5646512526969697]
[null,null,null,{"$f":"Previnificacion!J4","v":"Mosto 4"},{"$f":"Previnificacion!J5","v":"-Ne-Ln"},{"$f":"Previnificacion!J78","v":20920},null,950,18000,1970,{"$f":"IF(F16-SUM(G16:J16)>0,\"Faltan \"&F16-SUM(G16:J16),IF(F16-SUM(G16:J16)<0,\"Exceso \"&F16-SUM(G16:J16),\"Correcto\"))","v":"Correcto"},null,null,null,{"$f":"D56","v":"Preparación de la crianza"},null,null,{"$f":"K56+K57+K58","v":502.91149999999999},6.9818264506749123E-3,3.4803564013840831E-3,0.4571922727272727]
[null,null,null,null,null,{"$f":"Previnificacion!J80","v":1.8326836109045808},{"$f":"IF(G16=\"\",\"\",IF(G16>0,$F$17,\"\"))","v":""},{"$f":"IF(H16=\"\",\"\",IF(H16>0,$F$17,\"\"))","v":1.8326836109045808},1.8326836109045808,1.8326836109045808,{"$f":"SUM(G16:J17)","v":20925.498050832713},null,null,null,{"$f":"D59","v":"Crianza"},null,null,{"$f":"K59+K62","v":1902.8472222222219},2.6416872685759606E-2,1.3168492887351018E-2,1.7298611111111108]
[null,null,null,null,null,{"$f":"SUM(G18:J18)","v":38339.741140123828},{"$f":"IFERROR(G16*G17,\"\")","v":""},{"$f":"IFERROR(H16*H17,\"\")","v":1741.0494303593516},32988.304996282452,3610.3867134820239,null,null,null,null,{"$f":"D63","v":"Trasiegos crianza"},null,null,{"$f":"K63+K64+K65","v":158.50150000000002},2.2004467290400991E-3,1.0968961937716265E-3,0.14409227272727274]
[null,null,null,"Subtotal Costes Directos",null,{"$f":"SUM(G19:J19)","v":76628},{"$f":"G16+G13+G10+G7","v":14023},{"$f":"H16+H13+H10+H7","v":30908},23000,8697,null,null,null,null,{"$f":"D66","v":"Clarificación y estabilización"},null,null,{"$f":"K66+K67","v":129.31989999999999},1.7953240250394643E-3,8.9494740484429057E-4,0.11756354545454543]
[null,null,null,null,null,{"$f":"F21/F19","v":2.2093867702041532},{"$f":"IFERROR(G21/G19,\"\")","v":1.7643355594907939},{"$f":"IFERROR(H21/H19,\"\")","v":2.5011301433882096},{"$f":"IFERROR(I21/I19,\"\")","v":2.0171351371044146},2.3985941417983376,null,null,null,null,{"$f":"D68","v":"Filtrado crianzas"},null,null,{"$f":"K68+K69+K70","v":145.81025},2.0242564750050885E-3,1.0090674740484429E-3,0.13255477272727273]
[null,null,null,null,null,{"$f":"SUM(G21:J21)","v":169300.88942720386},{"$f":"_xlfn.AGGREGATE(9,6,G9,G12,G15,G18)","v":24741.277550739404},{"$f":"_xlfn.AGGREGATE(9,6,H9,H12,H15,H18)","v":77304.930471842788},46394.108153401532,20860.573251220143,null,null,null,null,{"$f":"D71","v":"Selección de vestido"},null,null,{"$f":"K78","v":64574.159999999996},0.8964710059684734,0.44688,58.70378181818181]
[null,null,null,"Mermas estimadas en trasiegos, clarificación, filtrados y crianza:",null,null,5.0000000000000001E-3,1.15E-2,1.15E-2,1.0999999999999999E-2,null,null,null,null,{"$f":"D79","v":"Lavado y llenado"},null,null,{"$f":"K80","v":2342.0094828800002},3.2513680349928485E-2,1.6207678082214533E-2,2.129099529890909]
[null,null,null,null,null,null,{"$f":"IFERROR((1-G22)*G19,\"\")","v":13952.885},{"$f":"IFERROR((1-H22)*H19,\"\")","v":30552.558000000001},22735.5,8601.3330000000005,null,null,null,null,{"$f":"D81","v":"Coste de vestir"},null,null,{"$f":"K82","v":796.34389800000008},1.1055493642300813E-2,5.5110304359861596E-3,0.72394899818181824]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T12:T23)","v":0.49848795669328716},{"$f":"SUM(U11:V23)","v":165.48319067470911}]
[null,"Costes Indirectos: Procesos y actividades (I)"]
[null,"Vinificación Complementaria","Nota 4","Selección, Mezcla o Coupage","nº de depósitos:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!W9","v":12.027777777777779},{"$f":"IFERROR(IF(G26=\"\",\"\",IF(G26>0,$F$27*G26,\"\")),\"\")","v":12.027777777777779},{"$f":"IFERROR(IF(H26=\"\",\"\",IF(H26>0,$F$27*H26,\"\")),\"\")","v":12.027777777777779},12.027777777777779,12.027777777777779,{"$f":"_xlfn.AGGREGATE(9,6,G27,H27,I27,J27)","v":48.111111111111114}]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!W7","v":12.945},{"$f":"IFERROR(IF(G26=\"\",\"\",IF(G26>0,$F$28,\"\")),\"\")","v":12.945},{"$f":"IFERROR(IF(H26=\"\",\"\",IF(H26>0,$F$28,\"\")),\"\")","v":12.945},12.945,12.945,{"$f":"_xlfn.AGGREGATE(9,6,G28,H28,I28,J28)","v":51.78}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!W8","v":3},{"$f":"IFERROR(IF(G26=\"\",\"\",IF(G26>0,$F$29*(G19/1000)*(G26/G26),\"\")),\"\")","v":42.069000000000003},{"$f":"IFERROR(IF(H26=\"\",\"\",IF(H26>0,$F$29*(H19/1000)*(H26/H26),\"\")),\"\")","v":92.724000000000004},69,26.090999999999998,229.88400000000001]
[null,null,"Clarificacion y estabilización:","Trasiegos","nº de veces:",null,3,2,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!$W$21","v":25.5},{"$f":"IFERROR(IF(G30=\"\",\"\",IF(G30>0,$F$31*G30,\"\")),\"\")","v":76.5},{"$f":"IFERROR(IF(H30=\"\",\"\",IF(H30>0,$F$31*H30,\"\")),\"\")","v":51},25.5,25.5,178.5]
[null,null,null,null,"nº de depósitos a usar:",null,1,2,2,4]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!W24","v":12.027777777777779},{"$f":"IFERROR(IF(G32=\"\",\"\",IF(G32>0,$F$33*G32,\"\")),\"\")","v":12.027777777777779},{"$f":"IFERROR(IF(H32=\"\",\"\",IF(H32>0,$F$33*H32,\"\")),\"\")","v":24.055555555555557},24.055555555555557,48.111111111111114,108.25]
[null,null,null,"Clarificación","nº de veces:",null,1,1,0,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!W22","v":8.5},{"$f":"IFERROR(IF(G34=\"\",\"\",IF(G34>0,$F$35*G34,\"\")),\"\")","v":8.5},{"$f":"IFERROR(IF(H34=\"\",\"\",IF(H34>0,$F$35*H34,\"\")),\"\")","v":8.5},"",8.5,25.5]
[null,null,null,null,"Tipo Clarificante:",null,"Vegetales (tanino,…)","Orgánicos (albumina, …)","Orgánicos (albumina, …)","Minerales (bentonita, …)"]
[null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",IF(G34>0,IFERROR(VLOOKUP(G36,'Actividades y tareas'!$V$33:$Z$37,5,FALSE)*(G19)/1000,\"\"),\"\"))","v":35.057499999999997},{"$f":"IF(H34>0,IFERROR(VLOOKUP(H36,'Actividades y tareas'!$V$33:$Z$37,5,FALSE)*(H19)/1000,\"\"),\"\")","v":148.35839999999999},{"$f":"IF(I34>0,IFERROR(VLOOKUP(I36,'Actividades y tareas'!$V$33:$Z$37,5,FALSE)*(I19)/1000,\"\"),\"\")","v":""},{"$f":"IF(J34>0,IFERROR(VLOOKUP(J36,'Actividades y tareas'!$V$33:$Z$37,5,FALSE)*(J19)/1000,\"\"),\"\")","v":33.0486},216.46449999999999]
[null,null,null,"Filtrados","nº de veces:",null,1,1,1,1]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!W23","v":17},{"$f":"IF(G35=\"\",\"\",IFERROR(IF(G38=\"\",\"\",IF(G38>0,$F$39*G38,\"\")),\"\"))","v":17},{"$f":"IF(H35=\"\",\"\",IFERROR(IF(H38=\"\",\"\",IF(H38>0,$F$39*H38,\"\")),\"\"))","v":17},"",17,51]
[null,null,null,null,"Tipo Filtrado:",null,"Filtro M (por Membranas)","Filtro P (por Placas)","Filtro M (por Membranas)","Filtro T (por Tierras)"]
[null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",IF(G38=0,\"\",IF(G38=\" \",\" \",IFERROR(VLOOKUP(G40,'Actividades y tareas'!$V$40:$Z$42,5,FALSE)*((G23)/1000)*G38,\"\"))))","v":34.882212500000001},{"$f":"IF(H35=\"\",\"\",IF(H38=0,\"\",IF(H38=\" \",\" \",IFERROR(VLOOKUP(H40,'Actividades y tareas'!$V$40:$Z$42,5,FALSE)*((H23)/1000)*H38,\"\"))))","v":116.0997204},{"$f":"IF(I35=\"\",\"\",IF(I38=0,\"\",IF(I38=\" \",\" \",IFERROR(VLOOKUP(I40,'Actividades y tareas'!$V$40:$Z$42,5,FALSE)*((I23)/1000)*I38,\"\"))))","v":""},{"$f":"IF(J35=\"\",\"\",IF(J38=0,\"\",IF(J38=\" \",\" \",IFERROR(VLOOKUP(J40,'Actividades y tareas'!$V$40:$Z$42,5,FALSE)*((J23)/1000)*J38,\"\"))))","v":41.286398400000003},192.2683313]
[null,null,null,null,"¿Utiliza bomba?:",null,"SI","SI","SI","SI"]
[null,null,null,null,null,null,{"$f":"IF(G35=\"\",\"\",IF(G38>0,IFERROR(IF(G42=\"SI\",'Actividades y tareas'!$W$25+('Actividades y tareas'!$W$27*(Vinificacion!G23/1000))*G38,\"\"),\"\"),\"\"))","v":46.303654999999999},{"$f":"IF(H35=\"\",\"\",IF(H38>0,IFERROR(IF(H42=\"SI\",'Actividades y tareas'!$W$25+('Actividades y tareas'!$W$27*(Vinificacion!H23/1000))*H38,\"\"),\"\"),\"\"))","v":96.102674000000007},{"$f":"IF(I35=\"\",\"\",IF(I38>0,IFERROR(IF(I42=\"SI\",'Actividades y tareas'!$W$25+('Actividades y tareas'!$W$27*(Vinificacion!I23/1000))*I38,\"\"),\"\"),\"\"))","v":""},{"$f":"IF(J35=\"\",\"\",IF(J38>0,IFERROR(IF(J42=\"SI\",'Actividades y tareas'!$W$25+('Actividades y tareas'!$W$27*(Vinificacion!J23/1000))*J38,\"\"),\"\"),\"\"))","v":30.248999000000001},172.655328]
[null,null,null,null,"nº de depósitos a usar:",null,1,1,2,4]
[null,null,null,null,"CF:",{"$f":"'Actividades y tareas'!W24","v":12.027777777777779},{"$f":"IF(G39=\"\",\"\",IFERROR(IF(G44=\"\",\"\",IF(G44>0,$F45*G44,\"\")),\"\"))","v":12.027777777777779},{"$f":"IF(H39=\"\",\"\",IFERROR(IF(H44=\"\",\"\",IF(H44>0,$F45*H44,\"\")),\"\"))","v":12.027777777777779},"",48.111111111111114,72.166666666666671]
[null,null,null,null,"¿Esabiliza con frío?:",null,"SI","SI","SI","SI"]
[null,null,null,null,null,null,{"$f":"IF(G39=\"\",\"\",IFERROR(IF(G23=\"\",\"\",IF(G23>0,IF(G46=\"SI\",'Actividades y tareas'!$Y$48+('Actividades y tareas'!$Z$48*(Vinificacion!G23/1000)),\"\"),\"\")),\"\"))","v":36.843270000000004},{"$f":"IF(H39=\"\",\"\",IFERROR(IF(H23=\"\",\"\",IF(H23>0,IF(H46=\"SI\",'Actividades y tareas'!$Y$48+('Actividades y tareas'!$Z$48*(Vinificacion!H23/1000)),\"\"),\"\")),\"\"))","v":70.04261600000001},{"$f":"IF(I39=\"\",\"\",IFERROR(IF(I23=\"\",\"\",IF(I23>0,IF(I46=\"SI\",'Actividades y tareas'!$Y$48+('Actividades y tareas'!$Z$48*(Vinificacion!I23/1000)),\"\"),\"\")),\"\"))","v":""},{"$f":"IF(J39=\"\",\"\",IFERROR(IF(J23=\"\",\"\",IF(J23>0,IF(J46=\"SI\",'Actividades y tareas'!$Y$48+('Actividades y tareas'!$Z$48*(Vinificacion!J23/1000)),\"\"),\"\")),\"\"))","v":26.140166000000001},133.02605200000002]
[]
[]
[]
[]
[]
[null,"Costes Indirectos: Procesos y actividades (y II)"]
[null,"Vinificación Complementaria","Nota 4","Litros disponibles y barricas estimadas para crianza:",null,null,{"$f":"IF(G35=\"\",G23,\"\")","v":""},{"$f":"IF(H35=\"\",H23,\"\")","v":""},22735.5,""]
[null,null,null,null,null,null,{"$f":"IFERROR(ROUND(G54/Barrica,0),\"\")","v":""},{"$f":"IFERROR(ROUND(H54/Barrica,0),\"\")","v":""},{"$f":"IFERROR(ROUND(I54/Barrica,0),\"\")","v":101},{"$f":"IFERROR(ROUND(J54/Barrica,0),\"\")","v":""}]
[null,null,"Crianza en barricas","Preparación de la crianza","CFact:",{"$f":"'Actividades y tareas'!W59","v":4.4450000000000003},{"$f":"IF(G55=\"\",\"\",$F$56)","v":""},{"$f":"IF(H55=\"\",\"\",$F$56)","v":""},4.4450000000000003,"",{"$f":"_xlfn.AGGREGATE(9,6,G56,H56,I56,J56)","v":4.4450000000000003}]
[null,null,null,null,"CFbarr:",{"$f":"'Actividades y tareas'!W60","v":4.26},{"$f":"IF(G55=\"\",\"\",$F$57*G55)","v":""},{"$f":"IF(H55=\"\",\"\",$F$57*H55)","v":""},430.26,"",{"$f":"_xlfn.AGGREGATE(9,6,G57,H57,I57,J57)","v":430.26}]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!W61","v":3},{"$f":"IF(G54=\"\",\"\",$F$58*(G54/1000))","v":""},{"$f":"IF(H54=\"\",\"\",$F$58*(H54/1000))","v":""},68.206499999999991,"",68.206499999999991]
[null,null,null,"Crianza","CFbarr:",{"$f":"'Actividades y tareas'!W63","v":4.25},{"$f":"IF(G55=\"\",\"\",$F$59*G55)","v":""},"",429.25,"",{"$f":"_xlfn.AGGREGATE(9,6,G59,H59,I59,J59)","v":429.25}]
[null,null,null,null,"CV:","Meses de crianza:",null,null,24]
[null,null,null,null,null,"Tipo Barrica:",null,null,"R.  Fránces:"]
[null,null,null,null,null,null,{"$f":"IF(G59=\"\",\"\",IFERROR(VLOOKUP(G61,'Actividades y tareas'!$V$65:$W$66,2,FALSE)*(G54/1000),\"\"))","v":""},{"$f":"IF(H59=\"\",\"\",IFERROR(VLOOKUP(H61,'Actividades y tareas'!$V$65:$W$66,2,FALSE)*(H54/1000),\"\"))","v":""},{"$f":"IF(I59=\"\",\"\",IFERROR(VLOOKUP(I61,'Actividades y tareas'!$V$65:$W$66,2,FALSE)*(I54/1000),\"\"))","v":1473.5972222222219},{"$f":"IF(J59=\"\",\"\",IFERROR(VLOOKUP(J61,'Actividades y tareas'!$V$65:$W$66,2,FALSE)*(J54/1000),\"\"))","v":""},{"$f":"_xlfn.AGGREGATE(9,6,G62,H62,I62,J62)","v":1473.5972222222219}]
[null,null,null,"Trasiegos crianza","CFact:",{"$f":"'Actividades y tareas'!W68","v":4.4450000000000003},{"$f":"IF(G54=\"\",\"\",$F$63)","v":""},{"$f":"IF(H54=\"\",\"\",$F$63)","v":""},4.4450000000000003,{"$f":"IF(J54=\"\",\"\",$F$63)","v":""},{"$f":"_xlfn.AGGREGATE(9,6,G63,H63,I63,J63)","v":4.4450000000000003}]
[null,null,null,null,"CFbarr:",{"$f":"'Actividades y tareas'!W69","v":0.85000000000000009},{"$f":"IF(G54=\"\",\"\",$F$64*G55)","v":""},{"$f":"IF(H54=\"\",\"\",$F$64*H55)","v":""},85.850000000000009,{"$f":"IF(J54=\"\",\"\",$F$64*J55)","v":""},85.850000000000009]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!W70","v":3},{"$f":"IF(G54=\"\",\"\",$F$65*(G54/1000))","v":""},{"$f":"IF(H54=\"\",\"\",$F$65*(H54/1000))","v":""},68.206499999999991,{"$f":"IF(J54=\"\",\"\",$F$65*(J54/1000))","v":""},68.206499999999991]
[null,null,null,"Clarificación y estabilización","CFbarr:",{"$f":"'Actividades y tareas'!W72","v":0.42500000000000004},{"$f":"IF(G54=\"\",\"\",$F$66*G55)","v":""},{"$f":"IF(H54=\"\",\"\",$F$66*H55)","v":""},42.925000000000004,{"$f":"IF(J54=\"\",\"\",$F$66*J55)","v":""},42.925000000000004]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!W73","v":3.8},{"$f":"IF(G54=\"\",\"\",$F$67*(G54/1000))","v":""},{"$f":"IF(H54=\"\",\"\",$F$67*(H54/1000))","v":""},86.394899999999993,"",86.394899999999993]
[null,null,null,"Filtrado crianzas","CFact:",{"$f":"'Actividades y tareas'!W75","v":4.4450000000000003},{"$f":"IF(G54=\"\",\"\",$F$68)","v":""},{"$f":"IF(H54=\"\",\"\",$F$68)","v":""},4.4450000000000003,"",4.4450000000000003]
[null,null,null,null,"CFbarr:",{"$f":"'Actividades y tareas'!W76","v":0.68},{"$f":"IF(G55=\"\",\"\",$F$69*G60)","v":""},{"$f":"IF(H55=\"\",\"\",$F$69*H60)","v":""},16.32,"",16.32]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!W77","v":5.5},{"$f":"IF(G54=\"\",\"\",$F$70*(G54/1000))","v":""},{"$f":"IF(H54=\"\",\"\",$F$70*(H54/1000))","v":""},125.04525,"",125.04525]
[null,null,"Embotellado","Selección de vestido","Vinos diponibles:",null,{"$f":"G4","v":"Vino 1"},"Vino 2","Vino 3","Vino 4"]
[null,null,null,null,null,null,"Joven Blanco Semiseco","Tinto Crianza","Tinto Barrica","Tinto Reserva"]
[]
[null,null,null,null,{"$f":"SUM(G74:J74)","v":75842.275999999998},null,{"$f":"G23","v":13952.885},{"$f":"H23","v":30552.558000000001},{"$f":"I23","v":22735.5},{"$f":"J23","v":8601.3330000000005}]
[null,null,null,null,"Modelo de vestido:",null,"Bag in Box","Mod. Estándar","Mod. Estándar","Modelo Alto"]
[null,null,null,null,"Unidades necesarias:",null,{"$f":"IFERROR(ROUND(G74/HLOOKUP(G75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),0),\"\")","v":698},{"$f":"IFERROR(ROUND(H74/HLOOKUP(H75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),0),\"\")","v":40737},{"$f":"IFERROR(ROUND(I74/HLOOKUP(I75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),0),\"\")","v":30314},{"$f":"IFERROR(ROUND(J74/HLOOKUP(J75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),0),\"\")","v":11468}]
[null,null,null,null,null,null,{"$f":"IFERROR(HLOOKUP(G75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),\"\")","v":20},{"$f":"IFERROR(HLOOKUP(H75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),\"\")","v":0.75},{"$f":"IFERROR(HLOOKUP(I75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),\"\")","v":0.75},{"$f":"IFERROR(HLOOKUP(J75,'Actividades y tareas'!$W$129:$Z$139,2,FALSE),\"\")","v":0.75}]
[null,null,null,null,"Coste de vestido:",null,{"$f":"IFERROR(HLOOKUP(G75,'Actividades y tareas'!$W$129:$Z$139,9,FALSE)*G76,\"\")","v":1605.4},{"$f":"IFERROR(HLOOKUP(H75,'Actividades y tareas'!$W$129:$Z$139,9,FALSE)*H76,\"\")","v":29330.639999999999},{"$f":"IFERROR(HLOOKUP(I75,'Actividades y tareas'!$W$129:$Z$139,9,FALSE)*I76,\"\")","v":21826.079999999998},{"$f":"IFERROR(HLOOKUP(J75,'Actividades y tareas'!$W$129:$Z$139,9,FALSE)*J76,\"\")","v":11812.04},{"$f":"_xlfn.AGGREGATE(9,6,G78,H78,I78,J78)","v":64574.159999999996}]
[null,null,null,"Lavado y llenado",null,null,"SI","SI","SI","SI"]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!W114","v":30.88},{"$f":"IF(G79=\"SI\",$F$80*(G74/1000),\"\")","v":430.86508879999997},{"$f":"IF(H79=\"SI\",$F$80*(H74/1000),\"\")","v":943.46299104000002},{"$f":"IF(I79=\"SI\",$F$80*(I74/1000),\"\")","v":702.07223999999997},{"$f":"IF(J79=\"SI\",$F$80*(J74/1000),\"\")","v":265.60916304},{"$f":"_xlfn.AGGREGATE(9,6,G80,H80,I80,J80)","v":2342.0094828800002}]
[null,null,null,"Coste de vestir",null,null,"SI","SI","SI","SI"]
[null,null,null,null,"CV:",{"$f":"'Actividades y tareas'!W115","v":10.5},{"$f":"IF(G81=\"SI\",$F$82*(G74/1000),\"\")","v":146.5052925},{"$f":"IF(H81=\"SI\",$F$82*(H74/1000),\"\")","v":320.80185900000004},238.72274999999999,90.313996500000002,{"$f":"_xlfn.AGGREGATE(9,6,G82,H82,I82,J82)","v":796.34389800000008}]
[]
[]
[null,null,null,"Output: Vinos Finales",null,"TOTAL",{"$f":"G71","v":"Vino 1"},{"$f":"H71","v":"Vino 2"},"Vino 3","Vino 4"]
[null,null,null,null,null,null,{"$f":"G72","v":"Joven Blanco Semiseco"},{"$f":"H72","v":"Tinto Crianza"},"Tinto Barrica","Tinto Reserva"]
[]
[null,null,null,"Vinos finales (Litros):",null,{"$f":"SUM(G88:J88)","v":75842.275999999998},{"$f":"G74","v":13952.885},{"$f":"H74","v":30552.558000000001},22735.5,8601.3330000000005]
[null,null,null,null,null,"Unidades:",{"$f":"IF(G75=\"Bag in Box\",\"Bag in Box\",IF(G75=\"\",\"\",\"Bot 3/4\"))","v":"Bag in Box"},{"$f":"IF(H75=\"Bag in Box\",\"Bag in Box\",IF(H75=\"\",\"\",\"Bot 3/4\"))","v":"Bot 3/4"},"Bot 3/4","Bot 3/4"]
[null,null,null,null,null,null,{"$f":"G76","v":698},{"$f":"H76","v":40737},30314,11468]
[null,null,null,"Coste de las actividades:",null,{"$f":"SUM(G91:J91)","v":7457.3497421800002},{"$f":"_xlfn.AGGREGATE(9,6,G27,G28,G29,G31,G33,G35,G37,G39,G41,G43,G45,G47,G56,G57,G58,G59,G62,G63,G64,G65,G66,G67,G68,G69,G70,G80,G82)","v":923.5543521333334},{"$f":"_xlfn.AGGREGATE(9,6,H27,H28,H29,H31,H33,H35,H37,H39,H41,H43,H45,H47,H56,H57,H58,H59,H62,H63,H64,H65,H66,H67,H68,H69,H70,H80,H82)","v":1925.1483715511113},3923.7136955555557,684.93332294000004]
[null,null,null,"Coste del vestido:",null,{"$f":"SUM(G92:J92)","v":64574.159999999996},{"$f":"G78","v":1605.4},{"$f":"H78","v":29330.639999999999},21826.079999999998,11812.04]
[null,null,null,"Coste Total:",null,{"$f":"SUM(G93:J93)","v":241332.39916938386},{"$f":"G92+G91+G21","v":27270.231902872736},{"$f":"H92+H91+H21","v":108560.7188433939},{"$f":"I92+I91+I21","v":72143.901848957088},{"$f":"J92+J91+J21","v":33357.546574160144}]
[null,null,null,"Coste Unitario:",null,null,{"$f":"G93/G90","v":39.069100147382144},{"$f":"H93/H90","v":2.6649168776147949},{"$f":"I93/I90","v":2.37988724183404},{"$f":"J93/J90","v":2.908750137265447}]
[null,null,null,null,null,{"$f":"F93/F88","v":3.1820300220075657},{"$f":"G93/G88","v":1.9544511334303074},{"$f":"H93/H88","v":3.5532448328350736},{"$f":"I93/I88","v":3.1731829891120533},{"$f":"J93/J88","v":3.8781833669455819}]
[null,null,null,"Valor Añadido:",null,{"$f":"(F92+F91)/F21","v":0.4254644496309759},{"$f":"(G92+G91)/G21","v":0.10221599700932803},{"$f":"(H92+H91)/H21","v":0.40431817454302715},{"$f":"(I92+I91)/I21","v":0.55502292684265397},{"$f":"(J92+J91)/J21","v":0.59907142399401936}]

{"sheet":"Actividades y tareas","index":4,"n_rows":180,"n_cols":54,"rows_kept":180,"cut":false,"hidden":false,"merged":[[45,44,45,45],[45,47,45,49],[45,50,45,54],[39,50,39,52],[43,50,43,52],[40,44,40,45],[38,47,38,48],[41,44,41,45],[40,47,40,49],[41,47,41,49],[40,50,40,54],[41,50,41,54],[44,44,44,45],[44,47,44,49],[44,50,44,54],[8,24,9,24],[8,25,9,25],[12,24,13,24],[12,25,13,25],[14,21,14,22],[15,21,15,22],[16,21,16,22],[8,20,8,21],[2,11,2,16],[3,11,3,16],[2,9,3,10],[2,19,3,20],[6,20,6,21],[7,20,7,21],[2,21,2,26],[3,21,3,26],[7,23,7,26],[5,13,5,14],[6,10,6,11],[7,10,7,11],[7,13,7,16],[175,14,176,14],[175,15,176,15],[177,11,177,12],[178,11,178,12],[179,11,179,12],[141,13,141,14],[167,13,167,14],[168,13,168,14],[169,10,169,11],[170,10,170,11],[170,13,170,16],[171,10,171,11],[171,14,172,14],[171,15,172,15],[153,11,153,12],[154,11,154,12],[152,11,152,12],[150,15,151,15],[150,14,151,14],[145,15,146,15],[145,14,146,14],[144,13,144,16],[142,13,142,14],[144,10,144,11],[145,10,145,11],[143,10,143,11],[120,14,121,14],[120,15,121,15],[122,11,122,12],[123,11,123,12],[124,11,124,12],[139,11,139,12],[138,11,138,12],[137,11,137,12],[135,15,136,15],[135,14,136,14],[130,15,131,15],[130,14,131,14],[130,10,130,11],[129,13,129,16],[129,10,129,11],[128,10,128,11],[127,13,127,14],[126,13,126,14],[115,10,115,11],[115,14,116,14],[115,15,116,15],[93,13,93,14],[94,13,94,14],[97,10,97,11],[96,10,96,11],[96,13,96,16],[97,14,98,14],[97,15,98,15],[95,10,95,11],[102,14,103,14],[102,15,103,15],[104,11,104,12],[105,11,105,12],[111,13,111,14],[112,13,112,14],[113,10,113,11],[114,10,114,11],[114,13,114,16],[87,14,88,14],[87,15,88,15],[89,11,89,12],[90,11,90,12],[91,11,91,12],[63,11,64,12],[63,13,64,13],[63,14,64,14],[70,11,70,12],[69,11,69,12],[71,11,71,12],[73,13,73,14],[74,13,74,14],[75,10,75,11],[76,10,76,11],[75,13,76,14],[77,13,77,16],[78,15,79,15],[78,14,79,14],[75,15,76,15],[27,24,28,24],[27,25,28,25],[43,24,44,24],[43,25,44,25],[25,20,25,21],[56,23,56,24],[57,20,57,21],[14,11,14,12],[23,20,23,21],[37,11,37,12],[56,13,56,14],[57,13,57,14],[26,13,26,14],[27,13,27,14],[28,10,28,11],[29,10,29,11],[29,13,29,16],[59,10,59,11],[58,10,58,11],[60,10,60,11],[60,13,60,16],[14,52,14,53],[15,52,16,54],[15,49,16,50],[15,47,16,48],[15,44,15,46],[16,44,16,46],[57,36,57,38],[15,11,15,12],[32,44,32,46],[21,20,21,21],[26,20,26,21],[27,20,27,21],[24,11,24,12],[45,21,45,22],[46,21,46,22],[47,21,47,22],[15,33,15,34],[20,20,20,21],[26,23,26,26],[7,33,7,34],[7,36,7,38],[31,4,31,5],[2,0,3,0],[2,1,2,5],[3,1,3,5],[22,2,22,3],[4,13,4,14],[2,29,3,29],[2,30,2,40],[3,30,3,41],[5,37,5,39],[10,39,10,40],[11,39,11,40],[12,39,12,40],[4,33,4,34],[6,36,6,38],[6,39,6,40],[5,35,5,36],[7,29,7,31],[6,29,6,31],[22,20,22,21],[24,20,24,21],[7,39,7,40],[2,43,3,43],[2,44,2,54],[3,44,3,55],[36,43,37,43],[36,44,36,54],[37,44,37,55],[17,44,17,45],[17,46,17,47],[17,48,17,49],[17,50,17,51],[17,52,17,53],[7,53,7,54],[7,50,7,52],[4,47,4,48],[7,47,7,48],[10,51,10,54],[6,50,6,52],[14,44,14,45],[14,46,14,47],[14,48,14,49],[14,50,14,51],[19,43,20,43],[19,44,19,54],[20,44,20,55],[26,52,26,54],[23,53,23,54],[35,33,36,34],[35,35,36,36],[35,38,35,40],[36,38,36,40],[30,36,30,38],[30,39,30,40],[20,30,20,41],[23,33,23,34],[28,39,28,40],[29,39,29,40],[21,47,21,48],[22,50,22,52],[23,47,23,48],[23,50,23,52],[32,47,33,48],[32,49,33,50],[32,52,33,54],[33,44,33,46],[35,30,35,32],[19,29,20,29],[19,30,19,40],[54,29,55,29],[72,38,72,40],[22,36,22,38],[23,36,23,38],[23,39,23,40],[25,37,25,39],[25,33,25,34],[33,37,33,39],[36,30,36,32],[54,30,54,40],[55,30,55,41],[65,37,65,39],[67,37,67,39],[68,37,68,39],[69,37,69,39],[71,38,71,40],[12,36,12,38],[13,36,13,38],[13,39,13,40],[71,30,71,32],[71,33,72,34],[71,35,72,36],[72,30,72,32],[58,39,58,40],[58,36,58,38],[64,37,64,39],[61,38,61,40],[15,30,15,32],[15,38,15,40],[47,45,48,46],[47,49,47,54],[48,49,48,54],[47,47,47,48],[48,47,48,48],[92,30,92,32],[92,33,93,34],[92,35,93,36],[93,30,93,32],[66,37,66,39],[83,38,83,40],[58,33,58,34],[87,37,87,39],[88,37,88,39],[89,37,89,39],[92,37,92,40],[78,36,78,38],[84,39,84,40],[75,30,75,40],[76,30,76,41],[93,37,93,40],[82,38,82,40],[79,36,79,38],[79,39,79,40],[85,24,85,25],[111,29,112,29],[111,30,111,40],[112,30,112,41],[75,29,76,29],[84,36,84,38],[58,20,58,21],[59,20,59,21],[60,20,60,21],[68,20,68,21],[69,20,69,21],[70,20,70,21],[75,23,75,26],[71,20,71,21],[76,24,77,24],[76,25,77,25],[114,33,114,34],[134,33,134,34],[135,33,135,34],[135,36,135,37],[124,33,124,34],[125,33,125,34],[125,36,125,37],[127,31,127,32],[127,33,127,34],[128,30,129,32],[128,33,129,34],[128,35,129,35],[118,30,119,32],[118,33,119,34],[118,35,119,35],[121,30,121,32],[121,33,122,34],[122,30,122,32],[122,35,122,36],[121,37,122,40],[115,33,115,34],[115,36,115,37],[117,31,117,32],[117,33,117,34],[137,31,137,32],[131,30,131,32],[137,33,137,34],[138,30,139,32],[138,33,139,34],[138,35,139,35],[141,30,141,32],[141,33,142,34],[141,37,142,40],[142,30,142,32],[142,35,142,36],[131,33,132,34],[131,37,132,40],[132,30,132,32],[132,35,132,36],[41,14,41,15],[42,14,42,15],[43,14,43,15],[127,22,127,25],[113,20,113,21],[114,20,114,21],[114,23,114,26],[115,24,116,24],[115,25,116,25],[93,22,93,23],[98,22,98,23],[61,20,61,21],[62,20,62,21],[66,20,66,21],[67,20,67,21],[72,20,72,21],[73,20,73,21],[74,20,74,21],[75,20,75,21],[76,20,76,21],[84,21,85,21],[84,24,84,25]]}
["Procesos y actividades PRINCIPALES",null,null,null,null,null,null,null,"Procesos y actividades PRINCIPALES",null,null,null,null,null,null,null,null,null,"Procesos y actividades PRINCIPALES",null,null,null,null,null,null,null,null,null,null,"Procesos y actividades AUXILIARES",null,null,null,null,null,null,null,null,null,null,null,null,null,"Procesos y actividades AUXILIARES"]
[]
["Nota 2","Proceso Vendimia: Actividades y tareas",null,null,null,null,null,null,null,"Nota 3",null,"Proceso Previnificación: Actividades y tareas",null,null,null,null,null,null,null,"Nota 4",null,"Proceso Vinificación Complementaria: Actividades y tareas",null,null,null,null,null,null,null,"Nota 3","AUXILIAR: Uso de equipo Depósitos",null,null,null,null,null,null,null,null,null,null,null,null,"Nota 3","AUXILIAR: Uso de equipo de Vendimia"]
[null,"(Estimación de consumo de recursos)",null,null,null,null,null,null,null,null,null,"(Estimación de consumo de recursos)",null,null,null,null,null,null,null,null,null,"(Estimación de consumo de recursos)",null,null,null,null,null,null,null,null,"(Estimación de consumo de recursos)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(Estimación de consumo de recursos)"]
["Actividades y tareas",null,null,null,"Acceso a Vendimia",null,null,null,null,"Actividades y tareas",null,null,null,"Acceso a Previnificación",null,null,null,null,null,"Actividades y tareas",null,null,null,"Acceso a Vinificación Complementaria",null,null,null,null,null,"Inventario aproximado:",null,null,null,"Tipo de amortización:",null,"Física/Técnica",null,null,null,null,null,null,null,"Inventario aproximado: ",null,null,null,"Tipo de amortización:",null,"Física/Técnica"]
["Selección, recolección y transporte",null,null,null,"Acceso a Resumen",null,null,null,null,"Despalillado y estrujado",null,null,null,"Acceso a Resumen",null,null,null,null,null,"Selección, Mezcla o Coupage",null,null,null,"Acceso a Resumen",null,null,null,null,null,"Valor estimado de mercado equipo de Depósitos",null,null,null,null,45000,"Valor Residual:",null,14400,null,null,null,null,null,"Tolva de recepción, Despalilladora-Estrujadora, Transportador y Aspirador de Raspones"]
[null,"Consumos estimados:",null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O10,O11,O12,O15,O16,O18,O19,O21,O25)","v":40.387933884297524},null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y11,Y16,Y17)","v":12.945},null,null,null,null,null,null,"Vida media estimada:",null,null,80,"Usos medios al año:",null,45,"Amortización:",null,null,{"$f":"IF(AJ5=\"Funcional\",(AI6-AL6)/(AG7*AJ7),0)","v":0},null,null,null,"Valor estimado de mercado equipo de vendimia:",null,null,null,null,1800,"Valor Residual:",250]
[null,null,"Mano de obra (selección)",null,null,null,null,null,null,null,"Costes variables (€/Tn):",null,{"$f":"_xlfn.AGGREGATE(9,6,P10:P15)","v":3.9944999999999999},"COMPONENTES DEL COSTE",null,null,null,null,null,null,"Costes variables (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z11,Z15,Z16,Z17)","v":3},"COMPONENTES DEL COSTE",null,null,null,null,null,"Depósitos disponibles:",null,null,20,"Capacidad promedio:",null,{"$f":"Notas!N3","v":5000},{"$f":"Notas!O3","v":8200},null,null,{"$f":"Notas!P3","v":8.1999999999999993},null,null,null,null,"Vida media estimada:",null,20,"Usos medios al año:",null,15,"Amortización:",null,null,{"$f":"IF(AX5=\"Funcional\",(AW7-AY7)/(AX8*AU8),0)","v":0}]
[null,null,"Coste de reposición anual cestas para recolección o coste de alquiler",null,null,null,null,null,null,null,"ACTIVIDAD PRINCIPAL. Consumos estimados:",null,null,null,{"$f":"O14","v":"Coste fijo actividad"},{"$f":"P14","v":"Coste variable (€/Tn)"},null,null,null,null,"Costes fijos por depósito:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y15)","v":12.027777777777779},null,"Coste fijo actividad","Coste variable (€/1.000 li)"]
[null,null,"Coste total del servicio de transporte contratado para traslado de uvas a bodega",null,null,null,null,null,null,null,null,"Mano de obra de preparación (hrs por actividad)",null,0.5,{"$f":"N10*Costehora","v":4.25},null,null,null,null,null,"ACTIVIDAD PRINCIPAL. Consumos estimados:",null,null,null,null,null,null,null,null,"Consumos estimados asociados a la disponibilidad del equipo de Depósitos:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumos estimados asociados a la disponibilidad del equipo de Vendimia"]
[null,null,"Transporte con medios propios (coste si se hubiese contratado)",null,null,null,null,null,null,null,null,"Mano de obra estimada por tonelada",null,0.11700000000000001,null,{"$f":"N11*Costehora","v":0.99450000000000005},null,null,null,null,null,"Mano de obra para selección-mezcla (hrs/actividad)",null,1,{"$f":"X11*Costehora","v":8.5},null,null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,null,null,null,null,null,null,150,null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,null,null,null,null,300]
[null,null,"Coste anual del Técnico de Campo contratado",null,null,null,null,null,null,null,null,"Toma y análisis de muestras",null,null,5,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste de reposición anual del equipo complementario y/o accesorios para el uso de depósitos",null,null,null,null,null,null,null,null,200]
[null,null,"Nº de horas que el propietario dedica a labores de Atrias",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,null,"Horas de mano de obra necesarias para que un depósito esté listo para su uso",null,null,null,null,null,0.2,null,null,{"$f":"AK13*Costehora","v":1.7000000000000002},null,null,null,"Consumos estimados asociados al uso del equipo - Vendimia -"]
[null,null,"Subtotal estimado:",1500,{"$f":"IFERROR(D14/$E$32,0)","v":9.6774193548387094E-2},null,null,null,null,null,null,null,"Actividades auxiliares",null,"Coste fijo actividad","Coste variable (€/Tn)",null,null,null,null,null,null,"Actividades auxiliares",null,null,null,null,null,null,null,"Horas de mano de obra necesarias para limpieza de depóstio",null,null,null,null,null,0.3,null,null,{"$f":"AK14*Costehora","v":2.5499999999999998},null,null,null,null,null,null,"Consumo de energía medio estimado",null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,"Uso del grupo de Vendimia:",null,"SI",{"$f":"IF(N15=\"SI\",AV16,\"\")","v":20},{"$f":"IF(N15=\"SI\",$BA$16,\"\")","v":3},null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(X15=\"SI\",$AH$16,\"\")","v":12.027777777777779}]
["Recepción de uva en bodega",null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Limpieza:",null,"SI",{"$f":"IF(N16=\"SI\",$AH$72,\"\")","v":0.24793388429752067},{"$f":"IF(N16=\"SI\",AM73,\"\")","v":3.3231707317073176},null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(X16=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(X16=\"SI\",$AM$36,\"\")","v":3},null,null,null,null,"Costes Fijos por uso de 1 depósito:",null,null,{"$f":"AN7+AN13+AN14+(AN11+AN12)/AJ7","v":12.027777777777779},null,"Costes Variables:",null,null,null,null,null,null,null,null,"Costes Fijos:",null,null,{"$f":"((AZ11/AX8)+BB8)","v":20},null,"Costes Variables:",null,null,{"$f":"AX14","v":3}]
[null,"Consumos estimados:",null,null,null,null,null,null,null,null,"TRATAMIENTO DE RASPONES. Consumos estimados:",null,null,null,"Coste fijo actividad","Coste variable (€/Tn)",null,null,null,null,null,"Uso de equipo de Frío:",null,"NO",{"$f":"IF(X17=\"SI\",$AH$93,\"\")","v":""},{"$f":"IF(X17=\"SI\",$AL$93,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mantenimiento y amortización anual del equipo:"]
[null,null,"Pesado y registro de uvas (coste de ajustes y/o reparación anual de la pesa)",null,null,null,null,null,null,null,null,"Transporte",null,null,5,10]
[null,null,"Toma y análisis de muestras",null,null,null,null,null,null,null,null,"Mano de obra de la actividad",null,null,0,0.5,null,null,null,null,null,null,null,"Acceso a Vinificación Complementaria"]
[null,null,"Descarga en tolva  (coste de ajustes y/o reparación-mantenimiento medio anual de la tolva)",null,null,null,null,null,null,null,"SULFITADO Y BOMBEO. Consumos estimados:",null,null,null,"Coste fijo actividad","Coste variable (€/Tn)",null,null,null,"Clarificación y estabilización",null,null,null,"Acceso a Resumen",null,null,null,null,null,"Nota 3","AUXILIAR: Uso de equipo Bombas",null,null,null,null,null,null,null,null,null,null,null,null,"Nota 3","AUXILIAR: Uso Grupo de Prensa"]
[null,null,"Subtotal estimado:",12500,{"$f":"IFERROR(D21/$E$32,0)","v":0.80645161290322576},null,null,null,null,null,null,"Mano de obra de la actividad (horas preparación)",null,0.17,{"$f":"N21*Costehora","v":1.4450000000000001},null,null,null,null,null,"Costes fijos de la actividad trasiegos:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y30)","v":25.5},null,null,null,null,null,null,null,"(Estimación de consumo de recursos)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(Estimación de consumo de recursos)"]
["Personal de vendimia",null,null,null,null,null,null,null,null,null,null,"Insumos (dióxido de azufre y similares):",null,null,null,0.5,null,null,null,null,"Cos.fijos de la actividad clarificación:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y32)","v":8.5},null,null,null,null,null,null,"Inventario aproximado:",null,null,null,"Tipo de amortización:",null,"Física/Técnica",null,null,null,null,null,null,null,"Inventario aproximado:",null,null,null,"Tipo de amortización:",null,"Física/Técnica"]
[null,null,"Coste por día y persona",null,"Días","Operarios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes fijos de la actividad filtrado:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y39)","v":17},null,null,null,null,null,null,null,"Valor estimado de mercado equipo de Bombas",null,null,null,2300,"Valor Residual:",0,null,null,null,null,null,null,null,"Valor estimado de mercado del grupo de prensa:",null,null,null,18000,"Valor Residual:",0]
[null,null,"Personal propio",null,null,null,null,null,null,null,null,null,"Actividades auxiliares",null,"Coste fijo actividad","Coste variable (€/Tn)",null,null,null,null,"Costes fijo por uso de depósito:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y46)","v":12.027777777777779},null,null,null,null,null,null,null,"Vida media estimada:",null,25,"Usos medios al año:",null,50,"Amortización:",null,null,{"$f":"IF(AJ22=\"Funcional\",(AI23-AK23)/(AJ24*AG24),0)","v":0},null,null,null,null,"Vida media estimada:",null,20,"Usos medios al año:",null,15,"Amortización:",null,null,{"$f":"IF(AX22=\"Funcional\",(AW23-AY23)/(AU24*AX24),0)","v":0}]
[null,null,"Personal adicional",null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N25=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N25=\"SI\",AM37,\"\")","v":5},null,null,null,null,"Costes fijo uso de equipo bombas:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y47)","v":4.4450000000000003}]
[null,null,"Ayuda familiar y similar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes fijo uso de equipo frío:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y48)","v":8.9375},null,null,null,null,null,null,null,"Bombas disponibles:",null,6,"Rendimiento medio:",null,10000,null,15000,null,null,null,null,null,"Consumos estimados asociados a la disponibilidad del Grupo de Prensa"]
[null,null,"Subtotal estimado:",1500,{"$f":"IFERROR(D27/$E$32,0)","v":9.6774193548387094E-2},null,null,null,null,null,null,null,null,"Acceso a Previnificación",null,null,null,null,null,null,"Coste variable uso bombas (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z47)","v":3},"COMPONENTES DEL COSTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,null,null,"Prensado",null,null,null,"Acceso a Resumen",null,null,null,null,null,null,"Coste variable uso frio (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z48)","v":2},null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,"Consumos estimados asociados a la disponibilidad del equipo de Bombas"]
[null,"RESUMEN:",null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O32,O35,O36,O38)","v":11.111666666666668},null,null,null,null,null,null,null,"TRASIEGOS. Consumos estimados:",null,null,null,null,null,null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,null,null,null,null,null,null,50,null,null,null,"Consumos estimados asociados al uso del grupo de - Prensado -"]
[null,null,"Clave propuesta:",null,null,null,null,null,null,null,"Costes variables (€/Tn):",null,{"$f":"_xlfn.AGGREGATE(9,6,P32,P33,P35,P36,P38)","v":10.739999999999998},"COMPONENTES DEL COSTE",null,null,null,null,null,null,null,"Mano Obra para preparar y vigilar el trasiego",null,3,{"$f":"X30*Costehora","v":25.5},null,null,null,null,null,"Coste de reposición anual del equipo complementario y/o accesorios para bombeo",null,null,null,null,null,null,null,null,100,null,null,null,null,null,null,"Consumo de energía medio estimado",null,null,1.47]
[null,null,"Kg de uva recolectado ponderado por el numero de fincas",null,null,null,null,null,null,null,"ACTIVIDAD PRINCIPAL. Consumos estimados:",null,null,null,{"$f":"O9","v":"Coste fijo actividad"},{"$f":"P9","v":"Coste variable (€/Tn)"},null,null,null,null,"CLARIFICACION. Consumos estimados:",null,null,null,null,null,null,null,null,null,"Horas-hombre necesarias para que una bomba esté lista para su uso",null,null,null,null,null,0.17,null,null,{"$f":"AK31*Costehora","v":1.4450000000000001},null,null,null,null,null,null,"Limpieza y desinfección del grupo",null,null,0.05]
[null,null,"Coste total estimado de la actividad",null,{"$f":"D14+D21+D27","v":15500},null,null,null,null,null,null,"Uso del Grupo de Prensa",null,null,{"$f":"AV33","v":6.666666666666667},{"$f":"BA33","v":1.47},null,null,null,null,null,"Mano de obra para preparar y aplicar el clarificante",null,1,{"$f":"X32*Costehora","v":8.5}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra estimada por tonelada",null,0.5,null,{"$f":"N33*Costehora","v":4.25},null,null,null,null,null,"Orgánicos (albumina, …)",null,null,null,4.8,null,null,null,"Consumos estimados asociados al uso del equipo - Bombeo -",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes Fijos:",null,null,{"$f":"(BB24+BA27)/AX24","v":6.666666666666667},null,"Costes Variables:",null,null,{"$f":"AX30","v":1.47}]
[null,null,null,null,null,null,null,null,null,null,"TRATAMIENTO DE ORUJOS. Consumos estimados:",null,null,null,"Coste fijo actividad","Coste variable (€/Tn)",null,null,null,null,null,"Minerales (bentonita, …)",null,null,null,3.8,null,null,null,null,null,null,"Consumo eléctrico",null,null,3,null,{"$f":"5","v":5},null,null,null,null,null,null,"Mantenimiento y amortización anual del equipo:"]
[null,null,null,null,null,null,null,null,null,null,null,"Transporte",null,null,0,0.01,null,null,null,null,null,"Vegetales (tanino,…)",null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra de la actividad",null,null,0,0.01,null,null,null,null,null,"Químicos (anhíd. silíc., …)",null,null,null,5,null,null,null,null,"Costes Fijos:",null,null,{"$f":"((AN29+AN30)/AJ24)+AN31+AN24","v":4.4450000000000003},null,"Costes Variables:",null,null,{"$f":"AJ34","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares",null,"Coste fijo actividad","Coste variable (€/Tn)",null,null,null,null,null,"Otros clarificantes",null,null,null,4.5,null,null,null,null,"Mantenimiento y amortización anual del equipo:",null,null,null,null,null,null,null,{"$f":"AL34","v":5},null,null,null,null,"Nota 3","AUXILIAR: Uso de equipo Barricas"]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N38=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N38=\"SI\",AM37,\"\")","v":5},null,null,null,null,"FILTRADOS. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Estimación de consumo de recursos)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar y aplicar los filtros",null,2,{"$f":"X39*Costehora","v":17},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inventario:",null,null,null,"Tipo de amortización:",null,"Funcional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filtro T (por Tierras)",null,null,null,4.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roble francés ",null,null,"Capacidad:",225,"Vida útil:",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filtro P (por Placas)",null,null,null,3.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor medio barrica:",null,975,"Amortización por crianza al mes:",null,null,{"$f":"IF(AX39=\"Funcional\",(AU41-AU42)/(AY40),0)","v":14.583333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filtro M (por Membranas)",null,null,null,2.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor Residual:",null,100,"Amortizacion  1.000 litros crianza al mes:",null,null,{"$f":"(AY41/AW40)*1000","v":64.81481481481481}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roble americano",null,null,"Capacidad:",225,"Vida útil:",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor medio barrica:",null,483,"Amortización por crianza al mes:",null,null,{"$f":"IF(AX39=\"Funcional\",(AU45-AU46)/(AY44),0)","v":6.7166666666666668}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(X46=\"SI\",$AH$16,\"\")","v":12.027777777777779},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor Residual:",null,80,"Amortizacion  1.000 litros crianza al mes:",null,null,{"$f":"(AY45/AW44)*1000","v":29.851851851851851}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(X47=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(X47=\"SI\",$AM$36,\"\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Frío:",null,"SI",{"$f":"IF(X48=\"SI\",$AH$93,\"\")","v":8.9375},{"$f":"IF(X48=\"SI\",$AL$93,\"\")","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes variables para mes de crianza de 1.000 litros:",null,"R.  Fránces:",null,{"$f":"AY42","v":64.81481481481481}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R. Americano:",null,{"$f":"AY46","v":29.851851851851851}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nota 3","AUXILIAR: Uso de equipo de Limpieza"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Vinificación Complementaria",null,null,null,null,null,null,"(Estimación de consumo de recursos)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Previnificación",null,null,null,null,null,"Crianza en Barricas (Barrica Tipo: 225 li)",null,null,null,"Acceso a Resumen",null,null,null,null,null,"Inventario aproximado:",null,null,null,"Tipo de amortización:",null,"Física/Técnica"]
[null,null,null,null,null,null,null,null,null,"Desfangado",null,null,null,"Acceso a Resumen",null,null,null,null,null,null,"Preparación y llenado de barricas",null,null,null,null,null,null,null,null,null,"Valor estimado de mercado equipo de limpieza:",null,null,null,1900,"Valor Residual:",0]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O64,O66,O71,O72)","v":27.695},null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y82)","v":4.4450000000000003},null,null,null,null,null,null,null,"Vida media estimada:",null,25,"Usos medios al año:",null,121,"Amortización:",null,null,{"$f":"IF(AJ57=\"Funcional\",(AI58-AK58)/(AJ59*AG59),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos por depósito:",null,{"$f":"_xlfn.AGGREGATE(9,6,O70)","v":12.027777777777779},null,null,null,null,null,null,null,"Costes fijos por barrica:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y80,Y81)","v":4.26}]
[null,null,null,null,null,null,null,null,null,null,"Costes variables (€/Tn):",null,{"$f":"_xlfn.AGGREGATE(9,6,P68,P71,P72)","v":5.6},"COMPONENTES DEL COSTE",null,null,null,null,null,null,"Costes variables (1.000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z82)","v":3},null,null,null,null,null,null,"Consumos estimados asociados a la disponibilidad del equipo de limpieza"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O31","v":"Coste fijo actividad"},{"$f":"P31","v":"Coste variable (€/Tn)"},null,null,null,null,"Crianza (por meses de crianza)",null,null,null,null,null,null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,"ACTIVIDAD PRINCIPAL. Consumos estimados:",null,null,null,null,null,null,null,null,null,"Costes fijo barrica/mes:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y84)","v":4.25}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar y realizar el desfangado, en depósito tipo",null,2.5,{"$f":"N64*Costehora","v":21.25},null,null,null,null,null,"Coste 1.000 litro crianza mes:",null,null,null,null,null,null,null,null,"Consumos estimados asociados al uso del equipo - Limpieza Tipo -"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W85","v":"R.  Fránces:"},{"$f":"Y85","v":64.81481481481481},null,null,null,null,null,null,null,null,null,"Tamaño del depósito de referencia",null,null,{"$f":"Deposito1","v":5000},null,{"$f":"Deposito2","v":8.1999999999999993}]
[null,null,null,null,null,null,null,null,null,null,null,"Coste de aplicar filtros o similares (por desfangado)",null,null,2,null,null,null,null,null,null,{"$f":"W86","v":"R. Americano:"},{"$f":"Y86","v":29.851851851851851},null,null,null,null,null,null,null,null,null,"Agua, detergente, desinfectantes",null,null,7,null,10]
[null,null,null,null,null,null,null,null,null,null,"TRATAMIENTO DE ORUJOS. Consumos estimados:",null,null,null,null,null,null,null,null,null,"Trasiegos",null,null,null,null,null,null,null,null,null,null,null,"Consumo de energía medio estimado",null,null,3,null,4.5]
[null,null,null,null,null,null,null,null,null,null,null,"Transporte y tratamiento de 1 Tn de desechos",null,20,null,{"$f":"N68*Notas!E28","v":0.6},null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y90)","v":4.4450000000000003},null,null,null,null,null,null,null,null,null,"Mano de obra:",null,null,1,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares",null,"Coste fijo actividad","Coste variable (€/Tn)",null,null,null,null,"Costes fijos por barrica:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y89)","v":0.85000000000000009},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ68*Costehora","v":8.5},null,{"$f":"AL68*Costehora","v":12.75}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(N70=\"SI\",$AH$16,\"\")","v":12.027777777777779},null,null,null,null,null,"Costes variables (1.000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z90)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((AJ66+AJ69+AJ67)/AJ65)*1000","v":3.7},null,{"$f":"(AL66+AL69+AL67)/AL65","v":3.3231707317073176}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N71=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N71=\"SI\",AM37,\"\")","v":5},null,null,null,null,"Clarificación y estabilización"]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Frío:",null,"NO",{"$f":"IF(N72=\"SI\",$AH$93,\"\")","v":""},{"$f":"IF(N72=\"SI\",AL94,\"\")","v":""},null,null,null,null,"Costes fijos por barrica:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y93)","v":0.42500000000000004},null,null,null,null,null,null,null,"Costes Fijos:",null,null,{"$f":"AN59+(AM62/AJ59)","v":0.24793388429752067},null,"Costes Variables:",null,null,{"$f":"AJ70","v":3.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes variables (1.000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z94)","v":3.8},null,null,null,null,null,null,null,"Mantenimiento y amortización anual del equipo:",null,null,null,null,null,null,null,{"$f":"AL70","v":3.3231707317073176}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Previnificación",null,null,null,null,null,null,"Filtrado"]
[null,null,null,null,null,null,null,null,null,"Encubado Tradicional",null,null,null,"Acceso a Resumen",null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y98)","v":4.4450000000000003}]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos por depósito encubado:",null,{"$f":"_xlfn.AGGREGATE(9,6,O82,O83,O84,O87,O90,O91,O92)","v":960.97277777777788},"Número promedio de días de encubado:",null,6,null,null,null,null,"Costes fijos por barrica:",null,{"$f":"_xlfn.AGGREGATE(9,6,Y97)","v":0.68},"COMPONENTES DEL COSTE",null,null,null,null,null,"Nota 3","AUXILIAR: Uso de equipo de Frío"]
[null,null,null,null,null,null,null,null,null,null,"Costes variables (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,P91,P92)","v":3},null,null,null,null,null,null,null,"Costes variables (1.000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z98,Z99)","v":5.5},null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,null,"(Estimación de consumo de recursos)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPONENTES DEL COSTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inventario aproximado:",null,null,null,"Tipo de amortización:",null,"Física/Técnica"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad por depósito","Coste variable (€/1.000 li)",null,null,null,null,"Preparación de crianza, coste de actividad por barrica. Consumos estimados:",null,null,null,null,null,null,null,null,null,"Valor estimado de mercado equipo de frío:",null,null,null,5500,"Valor Residual:",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mano Obra para limpiar y llenar barrica",null,0.5,{"$f":"X80*Costehora","v":4.25},null,null,null,null,null,"Vida media estimada:",null,30,"Usos medios al año:",null,64,"Amortización:",null,null,{"$f":"IF(AJ78=\"Funcional\",(AI79-AK79)/(AJ80*AG80),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"FERMENTACIÓN. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,"Consumo de agua y otros insumos ",null,null,0.01]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar y realizar el encubado:",null,3,{"$f":"N82*Costehora","v":25.5},null,null,null,null,null,null,"¿Utiliza bombas para llenar barricas?",null,"SI",{"$f":"IF(X82=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(X82=\"SI\",$AM$36,\"\")","v":3},null,null,null,"Consumos estimados asociados a la disponibilidad del equipo de Frío"]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra diaria para atender el encubado:",null,2,{"$f":"N83*P76*Costehora","v":102},null,null,null,null,null,"Crianza. Costes estimados por mes",null,null,null,null,null,null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,null,null,null,null,null,250]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo medio de insumos: levadura, etc ",null,null,1,null,null,null,null,null,null,"Mano Obra (horas) para rellenado barrica",null,0.5,{"$f":"X84*Costehora","v":4.25},null,null,null,null,null,"Coste de reposición anual del equipo complementario y/o accesorios equipo de frío",null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,"REMONTADO. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,"Crianza en:","R.  Fránces:",null,{"$f":"AX48","v":64.81481481481481},null,null,null,null,null,"Horas-hombre para preparar/controlar diariamente el uso de frío",null,null,null,null,null,0.5,null,null,{"$f":"AK85*Costehora","v":4.25}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar y realizar remontado",null,4,null,null,null,null,null,null,null,null,"R. Americano:",null,{"$f":"AX49","v":29.851851851851851}]
[null,null,null,null,null,null,null,null,null,null,null,"Número de remontados medios al día por depósito",null,4,{"$f":"N86*N87*P76*Costehora","v":816},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumos estimados asociados al uso del equipo - Limpieza Tipo -"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,null,"Trasiego. Costes estimados",null,null,null,null,null,null,null,null,null,null,null,"Tamaño del depósito de referencia",null,null,{"$f":"Deposito1","v":5000},null,{"$f":"Deposito2","v":8.1999999999999993}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares",null,null,null,null,null,null,null,null,"Mano Obra (horas) para realizar el trasiego/barrica",null,0.1,{"$f":"X89*Costehora","v":0.85000000000000009},null,null,null,null,null,null,null,"Consumo de energía medio estimado",null,null,10,null,15]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(N90=\"SI\",$AH$16,\"\")","v":12.027777777777779},null,null,null,null,null,null,"¿Utiliza bombas para el trasiego?",null,"SI",{"$f":"IF(X90=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(X90=\"SI\",$AM$36,\"\")","v":3},null,null,null,null,null,null,null,null,null,{"$f":"(AJ89/AJ88)*1000","v":2},null,{"$f":"AL89/AL88","v":1.8292682926829269}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N91=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N91=\"SI\",$AM$36,\"\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Frío:",null,"NO",{"$f":"IF(N92=\"SI\",$AH$93,\"\")","v":""},{"$f":"IF(N92=\"SI\",$AL$93,\"\")","v":""},null,null,null,null,"Clarificación y estabilización. Costes estimados"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mano Obra (horas) para clarificar una barrica",null,0.05,{"$f":"X93*Costehora","v":0.42500000000000004},null,null,null,null,null,"Costes Fijos:",null,null,{"$f":"((AM83+AM84)/AJ80)+AN85+AN80","v":8.9375},null,"Costes Variables:",null,{"$f":"AJ90","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Previnificación",null,null,null,null,null,null,null,"Clarificante usado:","Minerales (bentonita, …)",null,null,{"$f":"IFERROR(VLOOKUP(W94,V33:Z37,5,FALSE),\"\")","v":3.8},null,null,null,null,"Mantenimiento y amortización anual del equipo:",null,null,null,null,null,null,{"$f":"AL90","v":1.8292682926829269}]
[null,null,null,null,null,null,null,null,null,"Maceración Carbónica",null,null,null,"Acceso a Resumen"]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O100,O106)","v":12.945},"Duración media del proceso:",null,10,null,null,null,null,"Filtrado. Costes estimados"]
[null,null,null,null,null,null,null,null,null,null,"Costes variables (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,P106)","v":3},"COMPONENTES DEL COSTE",null,null,null,null,null,null,null,"Mano Obra (horas) para filtrar una barrica",null,0.08,{"$f":"X97*Costehora","v":0.68}]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos por depósito macerado:",null,{"$f":"_xlfn.AGGREGATE(9,6,O101,O102,O105)","v":26.477777777777781},null,"Coste fijo actividad por depósito","Coste variable (€/1.000 li)",null,null,null,null,null,"¿Utiliza bombas para el filtrado?",null,"SI",{"$f":"IF(X98=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(X98=\"SI\",$AM$36,\"\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,"FERMENTACIÓN. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,"Insumos para el filtrado:","Filtro M (por Membranas)",null,null,{"$f":"IFERROR(VLOOKUP(W99,V40:Z42,5,FALSE),\"\")","v":2.5}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar la maceración:",null,1,{"$f":"N100*Costehora","v":8.5}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra dia para atender un depósito, medir temperatura, etc:",null,0.17,{"$f":"N101*P96*Costehora","v":14.450000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo medio de insumos",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares"]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(N105=\"SI\",$AH$16,\"\")","v":12.027777777777779}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N106=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N106=\"SI\",$AM$36,\"\")","v":3}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Previnificación",null,null,null,null,null,"Actividades y tareas",null,null,null,"Acceso a Vinificación Complementaria",null,null,null,null,null,"Nota 3","AUXILIAR: Uso de equipo de Embotellado"]
[null,null,null,null,null,null,null,null,null,"Fermentación Alcohólica",null,null,null,"Acceso a Resumen",null,null,null,null,null,"Coste de Embotellado (sin vestido)",null,null,null,"Acceso a Resumen",null,null,null,null,null,null,"(Estimación de consumo de recursos)"]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O124)","v":4.4450000000000003},"Duración media del proceso:",null,20,null,null,null,null,"Costes Lavado/Llenado (€/mil Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z119,Z120,Z121,Z122,Z124,Z125)","v":30.88},null,null,null,null,null,null,"Inventario y costes de mantenimiento:"]
[null,null,null,null,null,null,null,null,null,null,"Costes variables (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,P123,P124,P125)","v":3},"COMPONENTES DEL COSTE",null,null,null,null,null,null,"Costes de vestir sin elemetos (€/mil Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,Z124,Z125)","v":10.5},"COMPONENTES DEL COSTE",null,null,null,null,null,"Lavadora:",null,null,null,"Tipo de amortización:",null,"Física/Técnica"]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos por depósito:",null,{"$f":"_xlfn.AGGREGATE(9,6,O118,O119,O120,O123,O125)","v":52.427777777777784},null,"Coste fijo actividad por depósito","Coste variable (€/1.000 li)",null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,null,"Valor estimado de mercado del equipo:",null,null,1500,null,"Valor Residual:",0]
[null,null,null,null,null,null,null,null,null,null,"FERMENTACIÓN. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vida media estimada:",null,50,"Usos medios al año:",null,300000]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar la fementación/depósito:",null,1,{"$f":"N118*Costehora","v":8.5},null,null,null,null,null,"Lavado y llenado de botellas. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,"Amortiza./Mil botellas:",null,{"$f":"IF(AJ115=\"Funcional\",(AH116-AK116)/(AG117*AJ117)*1000,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra dia para atender un depósito, medir temperatura, etc:",null,0.17,{"$f":"N119*P114*Costehora","v":28.900000000000002},null,null,null,null,null,null,"Mano de obra para llenado de 1.000 botellas",null,2,null,{"$f":"X119*Costehora","v":17},null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,400,null,{"$f":"(AH119/AJ117)*1000","v":1.3333333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo medio de insumos por depósito",null,null,3,null,null,null,null,null,null,"Insumos para el Lavado (agua y otros para 1.000 botellas)",null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,null,null,"Uso de equipo de Lavado:",null,"SI",null,{"$f":"IF(X121=\"SI\",AL122,\"\")","v":1.3333333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares",null,null,null,null,null,null,null,null,"Uso de equipo de Llenado:",null,"SI",null,{"$f":"IF(X122=\"SI\",AL132,\"\")","v":0.54666666666666663},null,null,null,null,"Costes Fijos:",null,null,null,null,"Costes Variables:",null,{"$f":"AH118+AJ119","v":1.3333333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(N123=\"SI\",$AH$16,\"\")","v":12.027777777777779},null,null,null,null,null,"Vestido de botellas. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Para mil botellas"]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N124=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N124=\"SI\",$AM$36,\"\")","v":3},null,null,null,null,null,"Mano de obra para vestido de 1.000 botellas",null,1,null,{"$f":"X124*Costehora","v":8.5}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Frío:",null,"NO",{"$f":"IF(N125=\"SI\",$AH$93,\"\")","v":""},{"$f":"IF(N125=\"SI\",$AL$93,\"\")","v":""},null,null,null,null,null,"Uso de equipo Etiquetadora-Capsuladora",null,"SI",null,{"$f":"IF(X125=\"SI\",AL142,\"\")","v":2},null,null,null,"Llenadora - Taponadora:",null,null,null,"Tipo de amortización:",null,"Funcional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valor estimado de mercado del equipo:",null,null,3500,null,"Valor Residual:",300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Previnificación",null,null,null,null,null,null,"Modelos de vestido, coste estimado:",null,null,null,null,null,null,null,null,null,"Vida media estimada:",null,50,"Usos medios al año:",null,300000]
[null,null,null,null,null,null,null,null,null,"Maceración Pelicular en Frío",null,null,null,"Acceso a Resumen",null,null,null,null,null,null,null,null,"Modelos",null,null,null,null,null,null,null,null,"Amortiza./Mil botellas:",null,{"$f":"IF(AJ125=\"Funcional\",(AH126-AK126)/(AG127*AJ127)*1000,0)","v":0.21333333333333332}]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O139)","v":4.4450000000000003},"Duración media del proceso:",null,1,null,null,null,null,null,"Componentes","Mod. Base","Mod. Estándar","Modelo Alto","Bag in Box",null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,100,null,{"$f":"(AH129/AJ127)*1000","v":0.33333333333333331}]
[null,null,null,null,null,null,null,null,null,null,"Costes variables (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,P138,P139,P140)","v":5},"COMPONENTES DEL COSTE",null,null,null,null,null,null,null,"Capacidad:   ",0.75,0.75,0.75,20]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos por depósito:",null,{"$f":"_xlfn.AGGREGATE(9,6,O133,O134,O135,O138,O140)","v":33.910277777777779},null,"Coste fijo actividad por depósito","Coste variable (€/1.000 li)",null,null,null,null,null,"Botella o recipiente",0.43,0.43,0.63,2.2000000000000002]
[null,null,null,null,null,null,null,null,null,null,"FERMENTACIÓN. Consumos estimados:",null,null,null,null,null,null,null,null,null,null,"Tapones - corchos",0.05,0.05,0.1,null,null,null,null,null,"Costes Fijos:",null,null,null,null,"Costes Variables:",null,{"$f":"AH128+AJ129","v":0.54666666666666663}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar la maceración/depósito:",null,1,{"$f":"N133*Costehora","v":8.5},null,null,null,null,null,null,"Etiqueta frontal",7.0000000000000007E-2,0.09,0.12,null,null,null,null,null,null,null,null,null,null,"Para mil botellas"]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra dia para atender un depósito, medir temperatura, etc:",null,0.17,{"$f":"N134*P129*Costehora","v":1.4450000000000001},null,null,null,null,null,null,"Contraetiqueta Consejo",0.08,0.08,0.08,0.1]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo medio de insumos por depósito",null,null,3,null,null,null,null,null,null,"Contraetiqueta Leyenda",0.02,0.03,0.05,null,null,null,null,"Etiquetadora - Capsuladora:",null,null,null,"Tipo de amortización:",null,"Funcional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)",null,null,null,null,null,"Cápsula",0.03,0.04,0.05,null,null,null,null,null,"Valor estimado de mercado del equipo:",null,null,7500,null,"Valor Residual:",3500]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares",null,null,null,null,null,null,null,null,"Coste Total:",{"$f":"SUM(W131:W136)","v":0.68},{"$f":"SUM(X131:X136)","v":0.72},1.03,2.3000000000000003,null,null,null,null,"Vida media estimada:",null,20,"Usos medios al año:",null,300000]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(N138=\"SI\",$AH$16,\"\")","v":12.027777777777779},null,null,null,null,null,null,"Coste mil botellas:",{"$f":"W137*1000","v":680},{"$f":"X137*1000","v":720},1030,2300.0000000000005,null,null,null,null,null,"Amortiza./Mil botellas:",null,{"$f":"IF(AJ135=\"Funcional\",(AH136-AK136)/(AG137*AJ137)*1000,0)","v":0.66666666666666663}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N139=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N139=\"SI\",$AM$36,\"\")","v":3},null,null,null,null,null,"Coste mil litros:",{"$f":"(1000*W137)/W130","v":906.66666666666663},{"$f":"(1000*X137)/X130","v":960},1373.3333333333333,115.00000000000003,null,null,null,null,"Mantenimiento y/o conservación anual estimado (Reparaciones y otros)",null,null,400,null,{"$f":"(AH139/AJ137)*1000","v":1.3333333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Frío:",null,"SI",{"$f":"IF(N140=\"SI\",$AH$93,\"\")","v":8.9375},{"$f":"IF(N140=\"SI\",$AL$93,\"\")","v":2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Previnificación",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costes Fijos:",null,null,null,null,"Costes Variables:",null,{"$f":"AH138+AJ139","v":2}]
[null,null,null,null,null,null,null,null,null,"Fermentación Maloláctica",null,null,null,"Acceso a Resumen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Para mil botellas"]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O154)","v":4.4450000000000003},"Duración media del proceso:",null,10]
[null,null,null,null,null,null,null,null,null,null,"Costes variables (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,P153,P154,P155)","v":3},"COMPONENTES DEL COSTE"]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos por depósito:",null,{"$f":"_xlfn.AGGREGATE(9,6,O148,O149,O150,O153,O155)","v":39.532777777777781},null,"Coste fijo actividad por depósito","Coste variable (€/1.000 li)"]
[null,null,null,null,null,null,null,null,null,null,"FERMENTACIÓN. Consumos estimados:"]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para preparar la fermentación/depósito:",null,0.83,{"$f":"N148*Costehora","v":7.0549999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra dia para atender un depósito, medir temperatura, etc:",null,0.17,{"$f":"N149*P144*Costehora","v":14.450000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,"Consumo medio de insumos por depósito",null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coste fijo actividad","Coste variable (€/1.000 li)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares"]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(N153=\"SI\",$AH$16,\"\")","v":12.027777777777779}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N154=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N154=\"SI\",$AM$36,\"\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Frío:",null,"NO",{"$f":"IF(N155=\"SI\",$AH$93,\"\")","v":""},{"$f":"IF(N155=\"SI\",$AL$93,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Acceso a Previnificación"]
[null,null,null,null,null,null,null,null,null,"Descube Escurrido",null,null,null,"Acceso a Resumen"]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos de la actividad:",null,{"$f":"_xlfn.AGGREGATE(9,6,O174,O179)","v":38.445}]
[null,null,null,null,null,null,null,null,null,null,"Costes variables (€/1000 Li):",null,{"$f":"_xlfn.AGGREGATE(9,6,P178,P179,P180)","v":5},"COMPONENTES DEL COSTE"]
[null,null,null,null,null,null,null,null,null,null,"Costes fijos por depósito:",null,{"$f":"_xlfn.AGGREGATE(9,6,O175,O178,O180)","v":45.020833333333336},null,"Coste fijo actividad por depósito","Coste variable (€/1.000 li)"]
[null,null,null,null,null,null,null,null,null,null,"FERMENTACIÓN. Consumos estimados:"]
[null,null,null,null,null,null,null,null,null,null,null,"Mano de obra para realizar descube por vino:",null,4,{"$f":"N174*Costehora","v":34}]
[null,null,null,null,null,null,null,null,null,null,null,"Número de depóstios utilizados en el descube:",null,2,{"$f":"IFERROR(N175*O178,0)","v":24.055555555555557}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Actividades auxiliares"]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Depósitos:",null,"SI",{"$f":"IF(N178=\"SI\",$AH$16,\"\")","v":12.027777777777779}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipos de Bombas:",null,"SI",{"$f":"IF(N179=\"SI\",$AH$36,\"\")","v":4.4450000000000003},{"$f":"IF(N179=\"SI\",$AM$36,\"\")","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,"Uso de equipo de Frío:",null,"SI",{"$f":"IF(N180=\"SI\",$AH$93,\"\")","v":8.9375},{"$f":"IF(N180=\"SI\",$AL$93,\"\")","v":2}]

{"sheet":"Resumen","index":5,"n_rows":38,"n_cols":21,"rows_kept":38,"cut":false,"hidden":false,"merged":[[24,16,25,16],[24,17,25,17],[24,18,25,18],[24,19,25,19],[23,13,23,15],[2,9,2,10],[5,9,5,10],[3,3,3,4],[3,5,3,6],[5,5,5,6],[5,7,5,8],[2,7,3,8],[3,9,3,10],[11,0,11,4],[11,5,11,6],[11,7,11,8],[23,7,23,8],[12,7,12,8],[36,0,36,4],[36,5,36,6],[36,7,36,8],[37,7,37,8],[22,0,22,4],[22,5,22,6],[22,7,22,8],[3,16,3,17],[3,18,3,19],[4,16,5,16],[4,17,5,17],[4,18,5,18],[4,19,5,19],[11,9,11,10],[6,7,6,8],[4,20,6,20],[10,20,12,20],[36,9,36,10],[10,16,11,16],[10,17,11,17],[10,18,11,18],[10,19,11,19],[13,13,14,15],[27,14,27,17],[19,13,19,19],[15,13,15,15],[22,9,22,10],[16,13,16,15],[17,13,17,15]]}
["Resumen del proceso industrial y estudio del valor añadido",null,null,null,null,null,null,null,null,null,null,null,null,"Costes e indicadores básicos "]
[]
[null,null,null,null,null,null,null,"Valor añadido sobre la uva",null,"Valores medio"]
["Coste de la UVA:",null,null,{"$f":"Vendimia!O6","v":110000},null,{"$f":"Vendimia!Q6","v":144500},null,null,null,1000,null,null,null,"Costes Básicos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Materia prima:",null,null,{"$f":"Vendimia!F5","v":"Listán Blanco"},{"$f":"Vendimia!G5","v":"Tintilla"},{"$f":"Vendimia!H5","v":"Negramoll"},{"$f":"Vendimia!I5","v":"Listán Negra"},"TOTAL"]
["Proceso Vendimia:",null,null,null,null,{"$f":"Vendimia!Q7","v":15500},null,{"$f":"Vendimia!$R$6","v":0.10726643598615918},null,{"$f":"(F6/$D$4)*1000","v":140.90909090909091}]
[null,{"$f":"Vendimia!N10","v":"Selección, recolección y transporte"},null,null,{"$f":"Vendimia!Q10","v":1500},{"$f":"Vendimia!R10","v":9.6774193548387094E-2},null,{"$f":"F6/$F$4","v":0.10726643598615918},null,null,null,null,null,null,null,null,{"$f":"Vendimia!F4","v":"Lb"},{"$f":"Vendimia!G4","v":"Ti"},{"$f":"Vendimia!H4","v":"Ne"},{"$f":"Vendimia!I4","v":"Ln"}]
[null,{"$f":"Vendimia!N11","v":"Recepción de uva en bodega"},null,null,{"$f":"Vendimia!Q11","v":12500},{"$f":"Vendimia!R11","v":0.80645161290322576},null,null,null,null,null,null,null,null,null,null,{"$f":"Vendimia!F7","v":15000},{"$f":"Vendimia!G7","v":25000},{"$f":"Vendimia!H7","v":40000},{"$f":"Vendimia!I7","v":30000},{"$f":"SUM(Q8:T8)","v":110000}]
[null,{"$f":"Vendimia!N12","v":"Personal de vendimia"},null,null,{"$f":"Vendimia!Q12","v":1500},{"$f":"Vendimia!R12","v":9.6774193548387094E-2},null,null,null,null,null,null,null,null,null,null,{"$f":"Vendimia!F9","v":13500},{"$f":"Vendimia!G9","v":30000},{"$f":"Vendimia!H9","v":68000},{"$f":"Vendimia!I9","v":33000},{"$f":"SUM(Q9:T9)","v":144500}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Producción final:",null,null,{"$f":"Vinificacion!G86","v":"Joven Blanco Semiseco"},{"$f":"Vinificacion!H86","v":"Tinto Crianza"},{"$f":"Vinificacion!I86","v":"Tinto Barrica"},{"$f":"Vinificacion!J86","v":"Tinto Reserva"},"TOTAL"]
["Proceso Previnificación:",null,null,null,null,{"$f":"Previnificacion!R8","v":9300.8894272038578},null,{"$f":"F12/F4","v":6.4366016797258535E-2},null,{"$f":"(F12/$D$4)*1000","v":84.553540247307794}]
[null,{"$f":"Previnificacion!O11","v":"Despalillado y Estrujado"},null,null,{"$f":"Previnificacion!R11","v":598.74976053719001},{"$f":"Previnificacion!S11","v":6.4375537976607597E-2},null,{"$f":"F12/$F$4","v":6.4366016797258535E-2},null,null,null,null,null,null,null,null,{"$f":"Vinificacion!G85","v":"Vino 1"},{"$f":"Vinificacion!H85","v":"Vino 2"},{"$f":"Vinificacion!I85","v":"Vino 3"},{"$f":"Vinificacion!J85","v":"Vino 4"}]
[null,{"$f":"Previnificacion!O12","v":"Prensado"},null,null,{"$f":"Previnificacion!R12","v":1219.9396666666664},{"$f":"Previnificacion!S12","v":0.13116376409104552},null,null,null,null,null,null,null,"Producción:",null,null,{"$f":"Vinificacion!G89","v":"Bag in Box"},{"$f":"Vinificacion!H89","v":"Bot 3/4"},{"$f":"Vinificacion!I89","v":"Bot 3/4"},{"$f":"Vinificacion!J89","v":"Bot 3/4"}]
[null,{"$f":"Previnificacion!O13","v":"Desfangado"},null,null,{"$f":"Previnificacion!R13","v":771.81111111111113},{"$f":"Previnificacion!S13","v":8.2982505829352932E-2},null,null,null,null,null,null,null,null,null,null,{"$f":"Vinificacion!G90","v":698},{"$f":"Vinificacion!H90","v":40737},{"$f":"Vinificacion!I90","v":30314},{"$f":"Vinificacion!J90","v":11468},{"$f":"SUM(Q15:T15)","v":83217}]
[null,{"$f":"Previnificacion!O14","v":"Encubado"},null,null,{"$f":"Previnificacion!R14","v":4076.5748611111117},{"$f":"Previnificacion!S14","v":0.43829946512294571},null,null,null,null,null,null,null,"Coste total:",null,null,{"$f":"Vinificacion!G93","v":27270.231902872736},{"$f":"Vinificacion!H93","v":108560.7188433939},{"$f":"Vinificacion!I93","v":72143.901848957088},{"$f":"Vinificacion!J93","v":33357.546574160144},{"$f":"SUM(Q16:T16)","v":241332.39916938386}]
[null,{"$f":"Previnificacion!O15","v":"Maceración Carbónica"},null,null,{"$f":"Previnificacion!R15","v":347.02486111111114},{"$f":"Previnificacion!S15","v":3.7310932876603156E-2},null,null,null,null,null,null,null,"Coste unitario:",null,null,{"$f":"Vinificacion!G94","v":39.069100147382144},{"$f":"Vinificacion!H94","v":2.6649168776147949},{"$f":"Vinificacion!I94","v":2.37988724183404},{"$f":"Vinificacion!J94","v":2.908750137265447}]
[null,{"$f":"Previnificacion!O16","v":"Fermentación Alcohólica"},null,null,{"$f":"Previnificacion!R16","v":460.17486111111111},{"$f":"Previnificacion!S16","v":4.9476436066980989E-2},null,null,null,null,null,null,null,"Coste por litro:",null,null,{"$f":"Vinificacion!G95","v":1.9544511334303074},{"$f":"Vinificacion!H95","v":3.5532448328350736},{"$f":"Vinificacion!I95","v":3.1731829891120533},{"$f":"Vinificacion!J95","v":3.8781833669455819},{"$f":"Vinificacion!F95","v":3.1820300220075657}]
[null,{"$f":"Previnificacion!O17","v":"Maceración Pelicular en Frío"},null,null,{"$f":"Previnificacion!R17","v":541.22736111111112},{"$f":"Previnificacion!S17","v":5.8190925217118855E-2}]
[null,{"$f":"Previnificacion!O18","v":"Fermentación Maloláctica"},null,null,{"$f":"Previnificacion!R18","v":563.71736111111113},{"$f":"Previnificacion!S18","v":6.0608973531317688E-2},null,null,null,null,null,null,null,"Hipótesis, variables e indicadores relevantes"]
[null,{"$f":"Previnificacion!O19","v":"Descube y Escurrido"},null,null,{"$f":"Previnificacion!R19","v":721.66958333333332},{"$f":"Previnificacion!S19","v":7.7591459288027478E-2},null,null,null,null,null,null,null,{"$f":"Notas!M2","v":"Coste medio de hora de operario de bodega:"},null,null,null,null,{"$f":"Costehora","v":8.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Notas!M4","v":"Capacidad Barrica Tipo:"},null,null,null,null,{"$f":"Barrica","v":225}]
["Proceso Vinificación Final:",null,null,null,null,{"$f":"Vinificacion!R9","v":72031.509742180002},null,{"$f":"F23/F4","v":0.49848795669328722},null,{"$f":"(F23/$D$4)*1000","v":654.8319067470909},null,null,null,"Rendimiento medio de la uva en mosto:",null,null,null,null,{"$f":"Notas!E29","v":0.7}]
[null,{"$f":"Vinificacion!O12","v":"Selección, Mezcla o Coupage"},null,null,{"$f":"Vinificacion!R12","v":329.77511111111113},{"$f":"Vinificacion!S12","v":4.5782062918223463E-3},null,{"$f":"F23/$F$4","v":0.49848795669328722}]
[null,{"$f":"Vinificacion!O13","v":"Trasiegos"},null,null,{"$f":"Vinificacion!R13","v":286.75},{"$f":"Vinificacion!S13","v":3.980896707931776E-3}]
[null,{"$f":"Vinificacion!O14","v":"Clarificación"},null,null,{"$f":"Vinificacion!R14","v":241.96449999999999},{"$f":"Vinificacion!S14","v":3.3591479737972384E-3}]
[null,{"$f":"Vinificacion!O15","v":"Filtrados"},null,null,{"$f":"Vinificacion!R15","v":621.11637796666673},{"$f":"Vinificacion!S15","v":8.6228427002267207E-3}]
[null,{"$f":"Vinificacion!O16","v":"Preparación de la crianza"},null,null,{"$f":"Vinificacion!R16","v":502.91149999999999},{"$f":"Vinificacion!S16","v":6.9818264506749123E-3}]
[null,{"$f":"Vinificacion!O17","v":"Crianza"},null,null,{"$f":"Vinificacion!R17","v":1902.8472222222219},{"$f":"Vinificacion!S17","v":2.6416872685759606E-2}]
[null,{"$f":"Vinificacion!O18","v":"Trasiegos crianza"},null,null,{"$f":"Vinificacion!R18","v":158.50150000000002},{"$f":"Vinificacion!S18","v":2.2004467290400991E-3}]
[null,{"$f":"Vinificacion!O19","v":"Clarificación y estabilización"},null,null,{"$f":"Vinificacion!R19","v":129.31989999999999},{"$f":"Vinificacion!S19","v":1.7953240250394643E-3}]
[null,{"$f":"Vinificacion!O20","v":"Filtrado crianzas"},null,null,{"$f":"Vinificacion!R20","v":145.81025},{"$f":"Vinificacion!S20","v":2.0242564750050885E-3}]
[null,{"$f":"Vinificacion!O21","v":"Selección de vestido"},null,null,{"$f":"Vinificacion!R21","v":64574.159999999996},{"$f":"Vinificacion!S21","v":0.8964710059684734}]
[null,{"$f":"Vinificacion!O22","v":"Lavado y llenado"},null,null,{"$f":"Vinificacion!R22","v":2342.0094828800002},{"$f":"Vinificacion!S22","v":3.2513680349928485E-2}]
[null,{"$f":"Vinificacion!O23","v":"Coste de vestir"},null,null,{"$f":"Vinificacion!R23","v":796.34389800000008},{"$f":"Vinificacion!S23","v":1.1055493642300813E-2}]
[]
["TOTAL Proceso Industrial Bodega:",null,null,null,null,{"$f":"F6+F12+F23","v":96832.399169383862},null,{"$f":"F37/F4","v":0.67012040947670493},null,{"$f":"(F37/$D$4)*1000","v":880.29453790348964}]
[null,null,null,null,null,null,null,{"$f":"F37/$F$4","v":0.67012040947670493}]

{"sheet":"Notas","index":6,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,1,39,6],[3,1,4,6],[8,1,9,6],[10,1,11,6],[17,0,17,5],[17,6,17,7],[14,1,16,6],[34,1,34,6],[35,1,36,6],[30,0,31,5],[30,6,31,6],[20,1,21,6],[22,1,23,6]]}
["Nota 0: Consideraciones generales",null,null,null,null,null,null,null,null,null,null,null,"Coste estimado de los principales insumos y otros estandar"]
[null,"En azul son datos para introducir y/o modificar",null,null,null,null,null,null,null,null,null,null,"Coste medio de hora de operario de bodega:",null,null,null,8.5]
[null,"En negro son datos calculados o estimados. Estan protegidos",null,null,null,null,null,null,null,null,null,null,"Depósito tipo:",5000,8200,{"$f":"O3/1000","v":8.1999999999999993}]
[null,"Las letras en color rojo intenso contienten hipervinculos a otras celdas o pestañas y que tienen un carácter informativo o aclaratorio",null,null,null,null,null,null,null,null,null,null,"Capacidad Barrica Tipo:",null,225]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Consejos de navegacion atráves de los vínculos del libro"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Volver al vínculo anterior",null,"ALT + ←","ALT+FLECHA IZQUIERDA"]
["Nota 1: Coste de la uva en vendimia",null,null,null,null,null,null,null,null,null,null,null,"Volver al vínculo siguiente",null,"ALT + →","ALT+FLECHA DERECHA"]
[null,"En el caso de mezcla de uva propia y comprada se aconseja considerar el precio medio podenderado de compra y de coste de producción."]
[]
[null,"Se ha estimado una tasa media de rechazo de uva en entrada en bodga del 0,5%"]
[]
[]
["Nota 2: Proceso vendimia",null,null,null,null,null,"(Actividades y tareas)",null,"(Proceso)"]
[null,"A titulo orientativo se proponen evaluar economica y financieramento los siguientes componentes del coste del proceso de vendimia y de sus actividades y tareas."]
[]
[]
[]
["Nota 3: Proceso Previnificación",null,null,null,null,null,"(Actividades y tareas)",null,"(Proceso)"]
["General:"]
[null,"El promedio del sector considera un 70% aunuqe depende de la calidad de la uva y del proceso de vinificiación."]
[]
[null,"Para calcular los rendimientos de la uva se puede tomar en consideración los siguientes conceptos y estimaciones:"]
[]
[null,null,null,null,"Tasa media"]
[null,null,"Raspón",null,0.06]
[null,null,"Orujos",null,0.21]
[null,null,"Fango y Heces",null,0.03]
[null,null,"Mosto final",null,{"$f":"1-SUM(E26:E28)","v":0.7}]
["Mermas en el proceso de previnificación"]
["Sobre el vino potencial, las pérdidas promedio derivadas de la fermentación y mezclas",null,null,null,null,null,1.2E-2]
[]
[]
["Nota 4: Proceso Vinificación Complementaria",null,null,null,null,null,"(Análisis)"]
[null,"En color azul debemos personalizar el nombre y clave de nuestros vinos."]
[null,"Las pérdidas estimadas por mezclas, clarificación y estabilización, trasiegos y similares asciende a 1,75%"]
[]
[null,"Respecto a los trasiegos y al fltrado cuando se pregunta el número de depósitos a usar se hace referencia al número necesario a parte del actualmente usado. "]