{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Presentación","Guía","E.Datos","E.Datos2","Metano","RESULTADOS PRTR","Result. N","Calculos","F.EE.","F.Dist."],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"Guía","index":1,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[[14,16,15,16],[28,16,29,16],[32,16,33,16],[34,16,35,16],[30,16,31,16],[18,16,19,16],[20,16,21,16],[22,16,23,16],[24,16,25,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FASE 1: ALOJAMIENTO DE ANIMALES Y EVACUACIÓN DEL ESTIÉRCOL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaulas no acondicionadas,  SIN SECADO estiércol "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaulas no acondicionadas, con SECADO estiércol "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaulas no acondicionadas, estiércol evacuado inmediatamente con cinta a almacén cerrado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaulas acondicionadas con cinta y retirada de estiércol 2 veces a la semana"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ulas acondicionadas con cinta, SECADO y retirada de estiércol 2 veces a la semana"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaulas acondicionadas con cinta, SECADO y retirada de estiércol más de 2 veces a la semana"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaulas con sistemas de depuración de aire"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cría en suelo con yacija profunda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cría en suelo con ventilación natural y sistema de bebederos sin pérdidas de agua, en suelos con yacija profunda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sistemas sin jaulas con aviarios con perchas y retirada de estiércol en cinta, sin secado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aviarios con perchas y retirada de estiércol en cinta, sin secado"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aviarios con perchas y retirada de estiércol en cinta, con secado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sistemas sin jaulas con yacija, emparrillado parcial y cintas de evacuación"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cría en suelo con yacija, emparrillado parcial y cintas de evacuación"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cria en suelo, con yacija con secado forzado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adición de sulfato de aluminio a la yacija"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cría en suelo con sistemas depuración de aire"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FASE 2:  ALMACENAMIENTO DEL ESTIÉRCOL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Almacén abierto, sin cubrir"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Almacén cubierto con materiales rígidos o flexibles"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FASE 3:  APLICACIÓN DEL ESTIÉRCOL AL CAMPO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Esparcido, sin enterrado"]
[null,null,null,null,null,null,null,null,"A almacenamiento",null,null,null,null,null,null,null,"Esparcido y enterrado de forma inmediata"]
[null,null,null,null,null,null,null,null,"Al campo o terreno agrícola",null,null,null,null,null,null,null,"Incorporación al suelo con discos, de forma inmediata"]
[null,null,null,null,null,null,null,null,"A otros usos no agrarios",null,null,null,null,null,null,null,"Enterrado en menos de 4 horas desde el esparcido"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enterrado en más de 4 horas desde el esparcido"]

{"sheet":"E.Datos","index":2,"n_rows":49,"n_cols":28,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,1,4,3],[5,1,6,3],[7,1,8,3],[9,1,10,3],[48,13,48,15],[29,13,29,15],[25,13,25,15],[27,13,27,15],[24,13,24,15],[26,13,26,15],[28,13,28,15],[30,13,30,15],[31,13,31,15],[32,13,32,15],[33,13,33,15],[34,13,34,15],[28,21,28,23],[26,21,26,23],[21,17,21,19],[21,9,22,9],[11,1,12,3],[13,1,14,3],[21,1,49,1],[21,2,22,3],[21,4,22,4],[21,7,22,7],[28,2,28,3],[16,2,16,3],[17,11,17,21],[21,13,21,15],[23,13,23,15],[49,13,49,15],[21,27,22,27],[24,2,24,3],[26,2,26,3],[21,25,22,25],[3,4,4,9],[3,11,3,21],[4,11,6,21],[8,11,8,21],[15,1,15,3],[18,23,18,27],[14,23,15,27],[21,21,22,23],[23,21,23,23],[24,21,24,23],[14,11,14,21],[15,11,15,21],[0,0,2,28],[40,21,40,23],[42,21,42,23],[44,21,44,23],[46,21,46,23],[30,21,30,23],[32,21,32,23],[34,21,34,23],[36,21,36,23],[38,21,38,23],[12,23,13,27],[7,23,8,27],[9,23,10,27],[12,11,13,21],[10,11,10,21],[4,23,6,27],[40,13,40,15],[41,13,41,15],[42,13,42,15],[35,13,35,15],[36,13,36,15],[37,13,37,15],[38,13,38,15],[39,13,39,15]]}
["GANADO AVIAR: AVES DE PUESTA"]
[]
[]
[null,null,null,null,"IDENTIFICACION DE LA EXPLOTACION",null,null,null,null,null,null,"Fase 1. Alojamiento de animales y Evacuación del estiércol",null,null,null,null,null,null,null,null,null,null,null,"Proteína bruta: "]
[null,null,null,null,null,null,null,null,null,null,null,"Si se aplica un mismo sistema de alojamiento para todos los animales, marcar la misma opción en todas las categorías. En caso contrario, diferenciar por categoría.",null,null,null,null,null,null,null,null,null,null,null,"Marcar si la proteina bruta que se suministra habitualmente en la ración está o no dentro de los rangos indicados, en unidades de Kg de P.B. por animal y año."]
[]
[null,"EXPLOTACIÓN",null,null,"NOMBRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aportación de paja, serrín, virutas u otros materiales para cama:"]
[null,null,null,null,"Nº REGISTRO REGA",null,null,null,null,null,null,"Fase 2. Almacenamiento del estiércol en la granja"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indicar la cantidad total de estos materiales, expresada en kg, que se utiliza por término medio por plaza y año."]
[null,null,null,null,"RESPONSABLE",null,null,null,null,null,null,"Elegir el sistema empleado, ya sea dentro o fuera de la explotación, diferenciando si procede por categoría animal."]
[]
[null,null,null,null,"MODULO/NAVE",null,null,null,null,null,null,"Fase 3. Aplicación de purines al campo",null,null,null,null,null,null,null,null,null,null,null,"Destino del estiércol:"]
[]
[null,null,null,null,"AÑO DE CONSTRUCCIÓN",null,null,null,null,null,null,"Elegir el sistema empleado en la explotación, diferenciando si procede por categoría animal.",null,null,null,null,null,null,null,null,null,null,null,"Indicar el destino del estiércol procedente de la explotación: el que se recoge en la nave de alojamiento y el que se saca del almacén de estiércol. "]
[null,null,null,null,"AÑO DE ÚLTIMA REFORMA",null,null,null,null,null,null,"Si el estiércol se saca fuera de la explotación, marque el sistema que cree se aplica en el lugar de destino."]
[]
[null,null,null,null,"LOCALIZACION",null,null,null,null,null,null,"De haber varios sistemas, elegir por categoría animal el que corresponda o el más parecido.",null,null,null,null,null,null,null,null,null,null,null,"En el caso de haber varios destinos posibles, indique el mayoritario."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sólo si procede, diferenciar por categoría animal."]
[]
[]
[null,"A N I M A L E S","CATEGORIAS PRODUCTIVAS",null,"NUMERO DE PLAZAS (ocupacion anual)",null,"PROTEINA BRUTA ALIMENTARIA","SÍ / NO",null,"ALOJAMIENTO DE ANIMALES Y EVACUACION DEL ESTIERCOL",null,"APORTACION DE PAJA, SERRIN, VIRUTAS,…",null,"SALIDA A PATIO",null,null,null,"DESTINO DEL ESTIERCOL",null,null,null,"ALMACENAMIENTO DEL ESTIERCOL",null,null,null,"DESTINO DEL ESTIERCOL TRAS ALMACENAMIENTO",null,"APLICACIÓN DEL ESTIERCOL AL CAMPO"]
[null,null,null,null,null,null,"(% en pienso)",null,null,null,null,"(kg/año)",null,"SÍ",null,"NO",null,"A LA SALIDA DE LA NAVE",null,"A LA SALIDA DEL PATIO"]
[]
[null,null,"Pollitas blancas en jaula",null,null,null,"18,0-18,1","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas blancas en jaula - 1er ciclo",null,null,null,"17,8-18,0","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas blancas en jaula - 1er ciclo (muda)",null,null,null,"18,0-18,2","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas blancas en jaula - muda",null,null,null,"17,6-17,8","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas blancas en jaula - 2º ciclo",null,null,null,"17,6-17,8","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Pollitas rubias en jaula",null,null,null,"18,0-18,2","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas rubias en jaula - 1er ciclo",null,null,null,"17,7-17,9","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas rubias en jaula - 1er ciclo (muda)",null,null,null,"17,7-17,9","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas rubias en jaula - muda",null,null,null,"17,3-17,5","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas rubias en jaula - 2º ciclo",null,null,null,"17,3-17,5","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,null,null,"A almacenamiento",null,null,null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Pollitas camperas",null,null,null,"17,9-18,1","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,"NO",null,"A almacenamiento",null,"A almacenamiento",null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"Gallinas camperas",null,null,null,"16,8-17,0","SÍ",null,"Cría en suelo con yacija profunda",null,0,null,null,null,"NO",null,"A almacenamiento",null,"A almacenamiento",null,"Almacén abierto, sin cubrir",null,null,null,"Al campo o terreno agrícola",null,"Esparcido, sin enterrado"]
[]
[null,null,"TOTAL ANIMALES EN GRANJA",null,{"$f":"IF(SUM(E25:E47)>0,SUM(E25:E47),\"\")","v":""}]

{"sheet":"E.Datos2","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,1,22,3],[22,4,22,6],[23,4,23,6],[17,0,22,0],[17,1,17,6],[19,1,19,3],[19,4,19,6],[20,1,20,3],[20,4,20,6],[21,1,21,3],[21,4,21,6],[10,1,12,2],[10,3,12,6],[1,1,1,6],[3,1,3,2],[3,3,3,6],[5,1,5,6],[6,1,6,2],[6,3,6,6],[7,1,7,2],[7,3,7,6],[8,1,8,2],[8,3,8,6],[9,3,9,6]]}
[]
[null,"                                    IDENTIFICACIÓN PROVINCIA"]
[]
[null,"Provincia de ubicación"]
[]
[null,"                                    Persona que realiza la declaración"]
[null,"Nombre y apellidos"]
[null,"Teléfono"]
[null,"Correo electrónico"]
[]
[null,"Observaciones"]
[]
[]
[]
[]
[]
[]
["ANIMALES","REGISTRO DE ANIMALES"]
[]
[null,"AVES DE CORRAL",null,null,"Nº de Plazas"]
[null,"Gallinas (Bateria con cintas sin presecado)"]
[null,"Gallinas (Bateria con cintas de presecado)"]
[null,"Gallinas (Batería con foso profundo)"]
[null,null,null,"Total",{"$f":"IF(SUM(E21:G23)=0,\"\",SUM(E21:G23))","v":""}]

{"sheet":"Metano","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[[1,1,2,9],[3,1,4,9],[10,1,10,2]]}
[]
[null,"CÁLCULO SOBRE LAS EMISIÓNES EN AVES DE CORRAL"]
[]
[null,"EMISIÓN DE METANO POR GESTIÓN DE ESTIÉRCOL"]
[]
[]
[null,"Provincia","Factor de\n Conversión*",null,"Provincia",{"$f":"E.Datos2!D4","v":0}]
[null,"Valencia",0.10344,null,"Factor de emisión",{"$f":"IF(F7=\"Provincia\",0,VLOOKUP(F7,$B$8:$C$10,2,0))","v":{"$error":"#N/A"}}]
[null,"Alicante",0.10378,null,"nº de plazas",{"$f":"E.Datos2!E24","v":""}]
[null,"Castellón de la Plana",9.9320000000000006E-2,null,"Emisión de CH4",{"$f":"F8*F9","v":{"$error":"#N/A"}}]
[null,"* El factor de conversión para el contaminante CH4. Cambia dependiendo de la provincia de ubicación de la instalación"]

{"sheet":"RESULTADOS PRTR","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"EMISIONES A NOTIFICAR EN PRTR-ESPAÑA"]
[null,"Sustancia","kg/año"]
[null,"Amoniaco (NH3)",{"$f":"IF(Calculos!BK16=0,\"\",Calculos!BK16)","v":""}]
[null,"Óxido nitroso (N2O)",{"$f":"IF(Calculos!AO16=0,\"\",Calculos!AO16)","v":""}]
[null,"Óxidos de nitrógeno (NOx)",{"$f":"IF(Calculos!AQ16=0,\"\",Calculos!AQ16)","v":""}]
[null,"Metano (CH4)",{"$f":"IFERROR(IF(Metano!F10=0,\"\",Metano!F10),\"\")","v":""}]
[]
[]
[]
[]
[null,"Estas emisiones deben notificarse en la plataforma PRTR- España con:"]
[]
[null,"* Método de otención del dato: \"Calculado\"."]
[null,"* Origen del método: \"SSC\"."]
[null,"* Método de cálculo: \"Otros\". Estimador de emisiones de amoniaco y de nitrógeno en explotaciones avícolas de puesta-MAPA."]
[null,"* Fuentes o referencias: \"Otros\". Estimador de emisiones de amoniaco y de nitrógeno en explotaciones avícolas de puesta-MAPA."]
[]
[null,"En CH4 tanto en método de cálculo como fuentes / referencias debe indicar: "]
[]
[null,"* Cuadro de cálculo de emisiones de gases de sector ganadero en relación con la directiva IPPC."]

{"sheet":"Result. N","index":6,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":true,"merged":[[31,8,31,9],[31,6,31,7],[30,6,30,7],[0,2,2,11],[3,5,3,11],[19,3,19,10],[28,3,28,10],[30,8,30,10],[22,6,22,10],[21,4,21,5],[21,6,21,11],[36,3,36,10],[37,3,37,10],[32,6,32,7],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[33,6,33,7],[34,6,34,7],[35,6,35,7],[33,3,33,5],[34,3,34,5],[35,3,35,5]]}
[null,null,"GANADO AVIAR: AVES DE PUESTA"]
[]
[]
[null,null,null,null,null,"IDENTIFICACION DE LA EXPLOTACION"]
[null,null,null,null,null,"NOMBRE"]
[]
[null,null,null,null,null,"Nº REGISTRO REGA"]
[]
[null,null,null,null,null,"RESPONSABLE"]
[]
[null,null,null,null,null,"MODULO/NAVE"]
[]
[null,null,null,null,null,"AÑO DE CONSTRUCCIÓN"]
[null,null,null,null,null,"AÑO ÚLTIMA REFORMA"]
[]
[null,null,null,null,null,"LOCALIZACION"]
[]
[]
[]
[null,null,null,"RESULTADOS DE EXPLOTACIÓN"]
[]
[null,null,null,null,"Emisiones en NAVE",null,"Emisiones TOTALES de Nitrógeno (kg N / año)"]
[null,null,null,null,null,"Referencia*","Explotación",null,null,null,null,"Referencia*"]
[null,null,null,null,"N - NH3","N - NH3","N - NH3","N - NOx","N - N2O","N - N2","N-TOTAL","N"]
[null,"Total granja",null,null,{"$f":"Calculos!AA16","v":0},{"$f":"Calculos!AA40","v":0},{"$f":"Calculos!BF16","v":0},{"$f":"Calculos!BI16","v":0},{"$f":"Calculos!BG16","v":0},{"$f":"Calculos!BH16","v":0},{"$f":"Calculos!BJ16","v":0},{"$f":"Calculos!BJ40","v":0}]
[null,"Media/plaza*año",null,null,{"$f":"Calculos!AA16/Calculos!C16","v":{"$error":"#DIV/0!"}},{"$f":"Calculos!AA40/Calculos!C40","v":{"$error":"#DIV/0!"}},{"$f":"G25/Calculos!C16","v":{"$error":"#DIV/0!"}},{"$f":"H25/Calculos!C16","v":{"$error":"#DIV/0!"}},{"$f":"I25/Calculos!C16","v":{"$error":"#DIV/0!"}},{"$f":"J25/Calculos!C16","v":{"$error":"#DIV/0!"}},{"$f":"K25/Calculos!C16","v":{"$error":"#DIV/0!"}},{"$f":"L25/Calculos!C16","v":{"$error":"#DIV/0!"}}]
[null,"% N emitido sobre N excretado",null,null,{"$f":"E25*100/G34","v":{"$error":"#DIV/0!"}},{"$f":"F25*100/G34","v":{"$error":"#DIV/0!"}},{"$f":"G25/G34*100","v":{"$error":"#DIV/0!"}},{"$f":"H25/G34*100","v":{"$error":"#DIV/0!"}},{"$f":"I25/G34*100","v":{"$error":"#DIV/0!"}},{"$f":"J25/G34*100","v":{"$error":"#DIV/0!"}},{"$f":"K25*100/G34","v":{"$error":"#DIV/0!"}},{"$f":"L25*100/G34","v":{"$error":"#DIV/0!"}}]
[null,"% N respecto a situación de referencia",null,null,{"$f":"E25*100/F25","v":{"$error":"#DIV/0!"}},null,{"$f":"G25/Calculos!BF40*100","v":{"$error":"#DIV/0!"}},{"$f":"H25/Calculos!BI40*100","v":{"$error":"#DIV/0!"}},{"$f":"I25/Calculos!BG40*100","v":{"$error":"#DIV/0!"}},{"$f":"J25/Calculos!BH40*100","v":{"$error":"#DIV/0!"}},{"$f":"K25*100/Calculos!BJ40","v":{"$error":"#DIV/0!"}},""]
[null,null,null,"* La situación de referencia corresponden al empleo de las técnicas menos eficientes o más contaminantes."]
[]
[null,null,null,null,null,null,"Nitrógeno excretado",null,"N retenido en estiércol"]
[null,null,null,null,null,null,"Explotación",null,"Explotación",null,"Referencia*"]
[null,null,null,null,null,null,"(kg N / año)",null,"(kg N / año)",null,"N"]
[null,null,null,"Total granja",null,null,{"$f":"Calculos!F16+(Calculos!C16*Calculos!K16*Calculos!AB16)","v":0},null,{"$f":"Calculos!BB16","v":0},null,{"$f":"Calculos!BB40","v":0}]
[null,null,null,"Media por animal",null,null,{"$f":"G34/Calculos!C16","v":{"$error":"#DIV/0!"}},null,{"$f":"I34/Calculos!C16","v":{"$error":"#DIV/0!"}},null,{"$f":"K34/Calculos!C16","v":{"$error":"#DIV/0!"}}]
[null,null,null,"% N sobre N excretado",null,null,{"$f":"G34/G34*100","v":{"$error":"#DIV/0!"}},null,{"$f":"I34/G34*100","v":{"$error":"#DIV/0!"}},null,{"$f":"K34/G34*100","v":{"$error":"#DIV/0!"}}]
[null,null,null,"* La situación de referencia corresponden al empleo de las técnicas menos eficientes o más contaminantes.",null,null,null,null,null,null,null,3]

{"sheet":"Calculos","index":7,"n_rows":40,"n_cols":64,"rows_kept":40,"cut":false,"hidden":true,"merged":[[25,62,26,62],[24,34,24,36],[24,37,24,45],[24,46,24,47],[24,48,24,52],[24,53,24,54],[0,0,2,0],[0,1,2,1],[0,2,1,2],[24,55,24,56],[25,61,26,61],[24,11,24,16],[24,17,24,22],[24,23,24,26],[24,27,24,30],[24,31,24,33],[24,0,26,0],[24,1,26,1],[24,2,25,2],[24,3,24,7],[24,8,24,10],[1,61,2,61],[1,62,2,62],[0,3,0,7],[0,8,0,10],[0,31,0,33],[0,34,0,36],[0,55,0,56],[0,53,0,54],[0,46,0,47],[0,48,0,52],[0,11,0,16],[0,17,0,22],[0,23,0,26],[0,27,0,30],[0,37,0,45]]}
["SPECIE","CAT_AA","N_AA","N excreted",null,null,null,null,"N Distribution",null,null,"GRAZING",null,null,null,null,null,"YARD_solid",null,null,null,null,null,"BUILD",null,null,null,"STRAW_exBUILD_solid  (kgN)",null,null,null,"DISTRIBUTION_exBUILD_solid",null,null,"DISTRIBUCION_YARD_solid",null,null,"STORE_solid (kg N)",null,null,null,null,null,null,null,null,"DISTRIBUCION_STORE_solid",null,"FIELD_solid",null,null,null,null,"FIELD TOTAL",null,"OTHERS",null,"EE N-NH3 TOTAL","EE N-N2O","EE N-N2","EE N-NOx","EE N-TOTAL","EE-NH3"]
[null,null,null,"Nex_T / AA","Nex_Urine","Nex_T","x_TAN-T","TAN-T","x_GRAZ","x_YARD","x_BUILD","N_GRAZ","TAN_GRAZ","EE_GRAZ","N_ret_GRAZ","TAN_GRAZING_solid","CHECK-1","N_YARD_solid","TAN_YARD_solid","EE_YARD_solid","N_ret_YARD","TAN_YARD_solid","CHECK-2","N_BUILD_solid","TAN_BUILD_solid","CHECK-3","EE_BUILD_solid","N_STRAW","N_exBUILD_solid ","TAN_exBUILD_solid","CHECK-4","x_exBUILD_solid-to-STORE_solid","x_exBUILD_solid-to-FIELD_solid","x_exBUILD_solid-to-OTHER","x_YARD-to-STORE_solid","x_YARD-to-FIELD_solid","x_YARD-to-OTHERS","N_STORE_solid","TAN_STORE_solid","EE_NH3_STORE_solid","EE_N2O_STORE_solid","EE_N2_STORE_solid","EE_NOx_STORE_solid","N_ex_STORE_solid","TAN_ex_STORE_solid","CHECK-5","x_STORE_solid-to-FIELD_solid","x_STORE_slurry-to-OTHERS","N_FIELD_solid","TAN_FIELD_solid","EE_FIELD_solid","N_ex_FIELD_solid","TAN_ex_FIELD_solid","N_ex_SFIELD_total","TAN_ex_FIELD_total","N_OTHERS_solid","TAN_total","(PM=17)","(PM=44,03)","(PM=28,01)","(PM=30,01)","kg N","kg NH3","CHECK"]
[null,null,"nº plazas","kg N/AA","kg N-NH3/AA","kg N","kg N-TAN/AA","kg N-TAN",null,null,null,"Kg N","Kg N-NH3","kg  N-NH3","Kg N","kg  N-NH3",null,"Kg N","Kg N-NH3","kg  N-NH3","Kg N","kg  N-NH3",null,"Kg N","kg  N-NH3",null,"kg  N-NH3","kg N / AA","N_ret_BUILD_solid","TAN_ret_BUILD_solid",null,null,null,null,null,null,null,null,null,"kg  N-NH3","kg  N2O","kg  N2","kg  NOx","N_ret_STORE_solid","TAN_ret_STORE_solid",null,null,null,"kg N ","kg","kg N-NH3","N_ret_FIELD_solid","TAN_ret_FIELD_solid","N_ret_FIELD_total","TAN_ret_FIELD_total","kg N ","kg","kg N","kg N","kg N","kg N"]
["AVES PUESTA","Pollitas blancas en jaula",{"$f":"E.Datos!$E$25","v":0},0.28299999999999997,0.22800000000000001,{"$f":"C4*D4","v":0},{"$f":"E4/D4","v":0.80565371024734989},{"$f":"F4*G4","v":0},{"$f":"'F.Dist.'!$E$4","v":0},{"$f":"'F.Dist.'!$F$4","v":0},{"$f":"'F.Dist.'!$G$4","v":1},{"$f":"F4*I4","v":0},{"$f":"H4*I4","v":0},{"$f":"M4*'F.EE.'!E3","v":0},{"$f":"L4-N4","v":0},{"$f":"M4-N4","v":0},{"$f":"(I4*H4)-(N4+P4)","v":0},{"$f":"F4*J4","v":0},{"$f":"H4*J4","v":0},{"$f":"S4*'F.EE.'!H3","v":0},{"$f":"R4-T4","v":0},{"$f":"S4-T4","v":0},{"$f":"U4+T4+O4+N4-(F4*I4+F4*J4)","v":0},{"$f":"F4*K4","v":0},{"$f":"H4*K4","v":0},{"$f":"(Y4)-H4*K4","v":0},{"$f":"Y4*'F.EE.'!K3","v":0},{"$f":"'F.Dist.'!$J$4","v":0},{"$f":"(C4*AB4*K4)+X4-AA4","v":0},{"$f":"(Y4-AA4)*(1-0.0067)","v":0},{"$f":"(AC4+U4+O4)+(N4+T4+AA4)-(F4+AB4*C4*K4)","v":0},{"$f":"'F.Dist.'!K4","v":1},{"$f":"'F.Dist.'!L4","v":0},{"$f":"'F.Dist.'!M4","v":0},{"$f":"'F.Dist.'!O4","v":0},{"$f":"'F.Dist.'!P4","v":0},{"$f":"'F.Dist.'!Q4","v":0},{"$f":"AC4*AF4+U4*AI4","v":0},{"$f":"AD4*AF4+V4*AI4","v":0},{"$f":"AM4*'F.EE.'!N3","v":0},{"$f":"AM4*'F.EE.'!S3","v":0},{"$f":"AM4*'F.EE.'!T3","v":0},{"$f":"AM4*'F.EE.'!U3","v":0},{"$f":"AL4-AN4-AO4*(28/44)-AP4-AQ4*(14/46)","v":0},{"$f":"AM4-AN4-AO4*(28/44)-AP4-AQ4*(14/46)","v":0},{"$f":"(AR4+AN4+AP4+AO4*28/44+AQ4*14/46)-AL4","v":0},{"$f":"'F.Dist.'!S4","v":1},{"$f":"'F.Dist.'!T4","v":0},{"$f":"AR4*AU4+AC4*AG4+U4*AJ4","v":0},{"$f":"AS4*AU4+AD4*AG4+V4*AJ4","v":0},{"$f":"AX4*'F.EE.'!Q3","v":0},{"$f":"AW4-AY4","v":0},{"$f":"AX4-AY4","v":0},{"$f":"AZ4+O4","v":0},{"$f":"BA4+P4","v":0},{"$f":"U4*AK4+AR4*AV4+AC4*AH4","v":0},{"$f":"V4*AK4+AS4*AV4+AD4*AH4","v":0},{"$f":"AY4+AN4+AA4+T4+N4","v":0},{"$f":"AO4*28/44","v":0},{"$f":"AP4","v":0},{"$f":"AQ4*14/46","v":0},{"$f":"SUM(BF4:BI4)","v":0},{"$f":"BF4*17/14","v":0},{"$f":"F4+(AB4*C4*K4)-(BB4+BD4+BJ4)","v":0}]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo",{"$f":"E.Datos!$E$27","v":0},0.57299999999999995,0.44,0,{"$f":"E5/D5","v":0.76788830715532297},{"$f":"F5*G5","v":0},{"$f":"'F.Dist.'!$E$5","v":0},{"$f":"'F.Dist.'!$F$5","v":0},{"$f":"'F.Dist.'!$G$5","v":1},{"$f":"F5*I5","v":0},{"$f":"H5*I5","v":0},{"$f":"M5*'F.EE.'!E4","v":0},{"$f":"L5-N5","v":0},{"$f":"M5-N5","v":0},{"$f":"(I5*H5)-(N5+P5)","v":0},{"$f":"F5*J5","v":0},{"$f":"H5*J5","v":0},{"$f":"S5*'F.EE.'!H4","v":0},{"$f":"R5-T5","v":0},{"$f":"S5-T5","v":0},{"$f":"U5+T5+O5+N5-(F5*I5+F5*J5)","v":0},{"$f":"F5*K5","v":0},{"$f":"H5*K5","v":0},{"$f":"(Y5)-H5*K5","v":0},{"$f":"Y5*'F.EE.'!K4","v":0},{"$f":"'F.Dist.'!$J$5","v":0},{"$f":"(C5*AB5*K5)+X5-AA5","v":0},{"$f":"(Y5-AA5)*(1-0.0067)","v":0},0,{"$f":"'F.Dist.'!K5","v":1},{"$f":"'F.Dist.'!L5","v":0},{"$f":"'F.Dist.'!M5","v":0},{"$f":"'F.Dist.'!O5","v":0},{"$f":"'F.Dist.'!P5","v":0},{"$f":"'F.Dist.'!Q5","v":0},{"$f":"AC5*AF5+U5*AI5","v":0},{"$f":"AD5*AF5+V5*AI5","v":0},{"$f":"AM5*'F.EE.'!N4","v":0},{"$f":"AM5*'F.EE.'!S4","v":0},{"$f":"AM5*'F.EE.'!T4","v":0},{"$f":"AM5*'F.EE.'!U4","v":0},{"$f":"AL5-AN5-AO5*(28/44)-AP5-AQ5*(14/46)","v":0},{"$f":"AM5-AN5-AO5*(28/44)-AP5-AQ5*(14/46)","v":0},{"$f":"(AR5+AN5+AP5+AO5*28/44+AQ5*14/46)-AL5","v":0},{"$f":"'F.Dist.'!S5","v":1},{"$f":"'F.Dist.'!T5","v":0},{"$f":"AR5*AU5+AC5*AG5+U5*AJ5","v":0},{"$f":"AS5*AU5+AD5*AG5+V5*AJ5","v":0},{"$f":"AX5*'F.EE.'!Q4","v":0},{"$f":"AW5-AY5","v":0},{"$f":"AX5-AY5","v":0},{"$f":"AZ5+O5","v":0},{"$f":"BA5+P5","v":0},{"$f":"U5*AK5+AR5*AV5+AC5*AH5","v":0},{"$f":"V5*AK5+AS5*AV5+AD5*AH5","v":0},{"$f":"AY5+AN5+AA5+T5+N5","v":0},{"$f":"AO5*28/44","v":0},{"$f":"AP5","v":0},{"$f":"AQ5*14/46","v":0},{"$f":"SUM(BF5:BI5)","v":0},{"$f":"BF5*17/14","v":0},0]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo (muda)",{"$f":"E.Datos!$E$29","v":0},0.56999999999999995,0.43099999999999999,0,0.756140350877193,0,{"$f":"'F.Dist.'!E46","v":0},{"$f":"'F.Dist.'!$F$6","v":0},{"$f":"'F.Dist.'!$G$6","v":1},0,0,{"$f":"M6*'F.EE.'!E5","v":0},0,0,0,0,0,{"$f":"S6*'F.EE.'!H5","v":0},0,0,0,0,0,0,{"$f":"Y6*'F.EE.'!K5","v":0},{"$f":"'F.Dist.'!$J$6","v":0},0,0,0,{"$f":"'F.Dist.'!K6","v":1},{"$f":"'F.Dist.'!L6","v":0},{"$f":"'F.Dist.'!M6","v":0},{"$f":"'F.Dist.'!O6","v":0},{"$f":"'F.Dist.'!P6","v":0},{"$f":"'F.Dist.'!Q6","v":0},0,0,{"$f":"AM6*'F.EE.'!N5","v":0},{"$f":"AM6*'F.EE.'!S5","v":0},{"$f":"AM6*'F.EE.'!T5","v":0},{"$f":"AM6*'F.EE.'!U5","v":0},0,0,0,{"$f":"'F.Dist.'!S6","v":1},{"$f":"'F.Dist.'!T6","v":0},0,0,{"$f":"AX6*'F.EE.'!Q5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas blancas en jaula - muda",{"$f":"E.Datos!$E$31","v":0},0.621,0.53300000000000003,0,0.85829307568438007,0,{"$f":"'F.Dist.'!$E$7","v":0},{"$f":"'F.Dist.'!$F$7","v":0},{"$f":"'F.Dist.'!$G$7","v":1},0,0,{"$f":"M7*'F.EE.'!E6","v":0},0,0,0,{"$f":"F7*J7","v":0},0,{"$f":"S7*'F.EE.'!H6","v":0},0,0,0,0,0,0,{"$f":"Y7*'F.EE.'!K6","v":0},{"$f":"'F.Dist.'!$J$7","v":0},0,0,0,{"$f":"'F.Dist.'!K7","v":1},{"$f":"'F.Dist.'!L7","v":0},{"$f":"'F.Dist.'!M7","v":0},{"$f":"'F.Dist.'!O7","v":0},{"$f":"'F.Dist.'!P7","v":0},{"$f":"'F.Dist.'!Q7","v":0},0,0,{"$f":"AM7*'F.EE.'!N6","v":0},{"$f":"AM7*'F.EE.'!S6","v":0},{"$f":"AM7*'F.EE.'!T6","v":0},{"$f":"AM7*'F.EE.'!U6","v":0},0,0,0,{"$f":"'F.Dist.'!S7","v":1},{"$f":"'F.Dist.'!T7","v":0},0,0,{"$f":"AX7*'F.EE.'!Q6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas blancas en jaula - 2º ciclo",{"$f":"E.Datos!$E$33","v":0},0.60199999999999998,0.46200000000000002,0,0.76744186046511631,0,{"$f":"'F.Dist.'!$E$8","v":0},{"$f":"'F.Dist.'!$F$8","v":0},{"$f":"'F.Dist.'!$G$8","v":1},0,0,{"$f":"M8*'F.EE.'!E7","v":0},0,0,0,0,0,{"$f":"S8*'F.EE.'!H7","v":0},0,0,0,0,0,0,{"$f":"Y8*'F.EE.'!K7","v":0},{"$f":"'F.Dist.'!$J$8","v":0},0,0,0,{"$f":"'F.Dist.'!K8","v":1},{"$f":"'F.Dist.'!L8","v":0},{"$f":"'F.Dist.'!M8","v":0},{"$f":"'F.Dist.'!O8","v":0},{"$f":"'F.Dist.'!P8","v":0},{"$f":"'F.Dist.'!Q8","v":0},0,0,{"$f":"AM8*'F.EE.'!N7","v":0},{"$f":"AM8*'F.EE.'!S7","v":0},{"$f":"AM8*'F.EE.'!T7","v":0},{"$f":"AM8*'F.EE.'!U7","v":0},0,0,0,{"$f":"'F.Dist.'!S8","v":1},{"$f":"'F.Dist.'!T8","v":0},0,0,{"$f":"AX8*'F.EE.'!Q7","v":0},0,0,0,0,0,0,{"$f":"AY8+AN8+AA8+T8+N8","v":0},0,0,0,0,0,0]
["AVES PUESTA","Pollitas rubias en jaula",{"$f":"E.Datos!$E$35","v":0},0.31,0.249,0,0.8032258064516129,0,{"$f":"'F.Dist.'!$E$9","v":0},{"$f":"'F.Dist.'!$F$9","v":0},{"$f":"'F.Dist.'!$G$9","v":1},0,0,{"$f":"M9*'F.EE.'!E8","v":0},0,0,0,0,0,{"$f":"S9*'F.EE.'!H8","v":0},0,0,0,0,0,0,{"$f":"Y9*'F.EE.'!K8","v":0},{"$f":"'F.Dist.'!$J$9","v":0},0,0,0,{"$f":"'F.Dist.'!K9","v":1},{"$f":"'F.Dist.'!L9","v":0},{"$f":"'F.Dist.'!M9","v":0},{"$f":"'F.Dist.'!O9","v":0},{"$f":"'F.Dist.'!P9","v":0},{"$f":"'F.Dist.'!Q9","v":0},0,0,{"$f":"AM9*'F.EE.'!N8","v":0},{"$f":"AM9*'F.EE.'!S8","v":0},{"$f":"AM9*'F.EE.'!T8","v":0},{"$f":"AM9*'F.EE.'!U8","v":0},0,0,0,{"$f":"'F.Dist.'!S9","v":1},{"$f":"'F.Dist.'!T9","v":0},0,0,{"$f":"AX9*'F.EE.'!Q8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo",{"$f":"E.Datos!$E$37","v":0},0.64100000000000001,0.49399999999999999,0,0.77067082683307331,0,{"$f":"'F.Dist.'!$E$10","v":0},{"$f":"'F.Dist.'!$F$10","v":0},{"$f":"'F.Dist.'!$G$10","v":1},0,0,{"$f":"M10*'F.EE.'!E9","v":0},0,0,0,0,0,{"$f":"S10*'F.EE.'!H9","v":0},0,0,0,0,0,0,{"$f":"Y10*'F.EE.'!K9","v":0},{"$f":"'F.Dist.'!$J$10","v":0},0,0,0,{"$f":"'F.Dist.'!K10","v":1},{"$f":"'F.Dist.'!L10","v":0},{"$f":"'F.Dist.'!M10","v":0},{"$f":"'F.Dist.'!O10","v":0},{"$f":"'F.Dist.'!P10","v":0},{"$f":"'F.Dist.'!Q10","v":0},0,0,{"$f":"AM10*'F.EE.'!N9","v":0},{"$f":"AM10*'F.EE.'!S9","v":0},{"$f":"AM10*'F.EE.'!T9","v":0},{"$f":"AM10*'F.EE.'!U9","v":0},0,0,0,{"$f":"'F.Dist.'!S10","v":1},{"$f":"'F.Dist.'!T10","v":0},0,0,{"$f":"AX10*'F.EE.'!Q9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo (muda)",{"$f":"E.Datos!$E$39","v":0},0.61499999999999999,0.47,0,{"$f":"E11/D11","v":0.7642276422764227},0,{"$f":"'F.Dist.'!$E$11","v":0},{"$f":"'F.Dist.'!$F$11","v":0},{"$f":"'F.Dist.'!$G$11","v":1},0,0,{"$f":"M11*'F.EE.'!E10","v":0},0,0,0,0,0,{"$f":"S11*'F.EE.'!H10","v":0},0,0,0,0,0,0,{"$f":"Y11*'F.EE.'!K10","v":0},{"$f":"'F.Dist.'!$J$11","v":0},0,0,0,{"$f":"'F.Dist.'!K11","v":1},{"$f":"'F.Dist.'!L11","v":0},{"$f":"'F.Dist.'!M11","v":0},{"$f":"'F.Dist.'!O11","v":0},{"$f":"'F.Dist.'!P11","v":0},{"$f":"'F.Dist.'!Q11","v":0},0,0,{"$f":"AM11*'F.EE.'!N10","v":0},{"$f":"AM11*'F.EE.'!S10","v":0},{"$f":"AM11*'F.EE.'!T10","v":0},{"$f":"AM11*'F.EE.'!U10","v":0},0,0,0,{"$f":"'F.Dist.'!S11","v":1},{"$f":"'F.Dist.'!T11","v":0},0,0,{"$f":"AX11*'F.EE.'!Q10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias en jaula - muda",{"$f":"E.Datos!$E$41","v":0},0.66300000000000003,0.56799999999999995,0,0.85671191553544479,{"$f":"F12*G12","v":0},{"$f":"'F.Dist.'!$E$12","v":0},{"$f":"'F.Dist.'!$F$12","v":0},{"$f":"'F.Dist.'!$G$12","v":1},0,0,{"$f":"M12*'F.EE.'!E11","v":0},0,0,0,0,0,{"$f":"S12*'F.EE.'!H11","v":0},0,0,0,0,0,0,{"$f":"Y12*'F.EE.'!K11","v":0},{"$f":"'F.Dist.'!$J$12","v":0},0,0,0,{"$f":"'F.Dist.'!K12","v":1},{"$f":"'F.Dist.'!L12","v":0},{"$f":"'F.Dist.'!M12","v":0},{"$f":"'F.Dist.'!O12","v":0},{"$f":"'F.Dist.'!P12","v":0},{"$f":"'F.Dist.'!Q12","v":0},0,0,{"$f":"AM12*'F.EE.'!N11","v":0},{"$f":"AM12*'F.EE.'!S11","v":0},{"$f":"AM12*'F.EE.'!T11","v":0},{"$f":"AM12*'F.EE.'!U11","v":0},0,0,0,{"$f":"'F.Dist.'!S12","v":1},{"$f":"'F.Dist.'!T12","v":0},0,0,{"$f":"AX12*'F.EE.'!Q11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias\nen jaula - 2º ciclo",{"$f":"E.Datos!$E$43","v":0},0.66600000000000004,0.51600000000000001,0,0.77477477477477474,0,{"$f":"'F.Dist.'!$E$13","v":0},{"$f":"'F.Dist.'!$F$13","v":0},{"$f":"'F.Dist.'!$G$13","v":1},0,0,{"$f":"M13*'F.EE.'!E12","v":0},0,0,0,0,0,{"$f":"S13*'F.EE.'!H12","v":0},0,0,0,0,0,0,{"$f":"Y13*'F.EE.'!K12","v":0},{"$f":"'F.Dist.'!$J$13","v":0},0,0,0,{"$f":"'F.Dist.'!K13","v":1},{"$f":"'F.Dist.'!L13","v":0},{"$f":"'F.Dist.'!M13","v":0},{"$f":"'F.Dist.'!O13","v":0},{"$f":"'F.Dist.'!P13","v":0},{"$f":"'F.Dist.'!Q13","v":0},0,0,{"$f":"AM13*'F.EE.'!N12","v":0},{"$f":"AM13*'F.EE.'!S12","v":0},{"$f":"AM13*'F.EE.'!T12","v":0},{"$f":"AM13*'F.EE.'!U12","v":0},0,0,0,{"$f":"'F.Dist.'!S13","v":1},{"$f":"'F.Dist.'!T13","v":0},0,0,{"$f":"AX13*'F.EE.'!Q12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Pollitas camperas",{"$f":"E.Datos!$E$45","v":0},0.34599999999999997,0.27900000000000003,0,0.8063583815028903,0,{"$f":"'F.Dist.'!$E$14","v":0},{"$f":"'F.Dist.'!$F$14","v":0},{"$f":"'F.Dist.'!$G$14","v":1},0,0,{"$f":"M14*'F.EE.'!E13","v":0},0,0,0,0,0,{"$f":"S14*'F.EE.'!H13","v":0},0,0,0,0,0,0,{"$f":"Y14*'F.EE.'!K13","v":0},{"$f":"'F.Dist.'!$J$14","v":0},0,0,0,{"$f":"'F.Dist.'!K14","v":1},{"$f":"'F.Dist.'!L14","v":0},{"$f":"'F.Dist.'!M14","v":0},{"$f":"'F.Dist.'!O14","v":1},{"$f":"'F.Dist.'!P14","v":0},{"$f":"'F.Dist.'!Q14","v":0},0,0,{"$f":"AM14*'F.EE.'!N13","v":0},{"$f":"AM14*'F.EE.'!S13","v":0},{"$f":"AM14*'F.EE.'!T13","v":0},{"$f":"AM14*'F.EE.'!U13","v":0},0,0,0,{"$f":"'F.Dist.'!S14","v":1},{"$f":"'F.Dist.'!T14","v":0},0,0,{"$f":"AX14*'F.EE.'!Q13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas camperas",{"$f":"E.Datos!$E$47","v":0},0.64300000000000002,0.495,0,0.76982892690513216,0,{"$f":"'F.Dist.'!$E$15","v":0},{"$f":"'F.Dist.'!$F$15","v":0},{"$f":"'F.Dist.'!$G$15","v":1},0,0,{"$f":"M15*'F.EE.'!E14","v":0},0,0,0,0,0,{"$f":"S15*'F.EE.'!H14","v":0},0,0,0,0,0,0,{"$f":"Y15*'F.EE.'!K14","v":0},{"$f":"'F.Dist.'!$J$15","v":0},0,{"$f":"(Y15-AA15)*(1-0.0067)","v":0},0,{"$f":"'F.Dist.'!K15","v":1},{"$f":"'F.Dist.'!L15","v":0},{"$f":"'F.Dist.'!M15","v":0},{"$f":"'F.Dist.'!O15","v":1},{"$f":"'F.Dist.'!P15","v":0},{"$f":"'F.Dist.'!Q15","v":0},{"$f":"AC15*AF15+U15*AI15","v":0},{"$f":"AD15*AF15+V15*AI15","v":0},{"$f":"AM15*'F.EE.'!N14","v":0},{"$f":"AM15*'F.EE.'!S14","v":0},{"$f":"AM15*'F.EE.'!T14","v":0},{"$f":"AM15*'F.EE.'!U14","v":0},0,0,0,{"$f":"'F.Dist.'!S15","v":1},{"$f":"'F.Dist.'!T15","v":0},0,0,{"$f":"AX15*'F.EE.'!Q14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTALS",null,{"$f":"SUM(C4:C15)","v":0},null,null,{"$f":"SUM(F4:F15)","v":0},null,{"$f":"SUM(H4:H15)","v":0},null,null,{"$f":"K15","v":1},{"$f":"SUM(L4:L15)","v":0},{"$f":"SUM(M4:M15)","v":0},{"$f":"SUM(N4:N15)","v":0},{"$f":"SUM(O4:O15)","v":0},{"$f":"SUM(P4:P15)","v":0},null,{"$f":"SUM(R4:R15)","v":0},{"$f":"SUM(S4:S15)","v":0},{"$f":"SUM(T4:T15)","v":0},{"$f":"SUM(U4:U15)","v":0},{"$f":"SUM(V4:V15)","v":0},null,{"$f":"SUM(X4:X15)","v":0},{"$f":"SUM(Y4:Y15)","v":0},null,{"$f":"SUM(AA4:AA15)","v":0},null,{"$f":"SUM(AC4:AC15)","v":0},{"$f":"SUM(AD4:AD15)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AL4:AL15)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(AT4:AT15)","v":0},null,null,{"$f":"SUM(AW4:AW15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF16:BI16)","v":0},{"$f":"BF16*17/14","v":0},{"$f":"SUM(BL4:BL15)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["SPECIE","CAT_AA","N_AA","N excreted",null,null,null,null,"N Distribution",null,null,"GRAZING",null,null,null,null,null,"YARD_solid",null,null,null,null,null,"BUILD",null,null,null,"STRAW_exBUILD_solid  (kgN)",null,null,null,"DISTRIBUTION_exBUILD_solid",null,null,"DISTRIBUCION_YARD_solid",null,null,"STORE_solid (kg N)",null,null,null,null,null,null,null,null,"DISTRIBUCION_STORE_solid",null,"FIELD_solid",null,null,null,null,"FIELD TOTAL",null,"OTHERS",null,"EE N-NH3 TOTAL","EE N-N2O","EE N-N2","EE N-NOx","EE N-TOTAL","EE-NH3"]
[null,null,null,"Nex_T / AA","Nex_Urine","Nex_T","x_TAN-T","TAN-T","x_GRAZ","x_YARD","x_BUILD","N_GRAZ","TAN_GRAZ","EE_GRAZ","N_ret_GRAZ","TAN_GRAZING_solid","CHECK-1","N_YARD_solid","TAN_YARD_solid","EE_YARD_solid","N_ret_YARD","TAN_YARD_solid","CHECK-2","N_BUILD_solid","TAN_BUILD_solid","CHECK-3","EE_BUILD_solid","N_STRAW","N_exBUILD_solid ","TAN_exBUILD_solid","CHECK-4","x_exBUILD_solid-to-STORE_solid","x_exBUILD_solid-to-FIELD_solid","x_exBUILD_solid-to-OTHER","x_YARD-to-STORE_solid","x_YARD-to-FIELD_solid","x_YARD-to-OTHERS","N_STORE_solid","TAN_STORE_solid","EE_NH3_STORE_solid","EE_N2O_STORE_solid","EE_N2_STORE_solid","EE_NOx_STORE_solid","N_ex_STORE_solid","TAN_ex_STORE_solid","CHECK-5","x_STORE_solid-to-FIELD_solid","x_STORE_slurry-to-OTHERS","N_FIELD_solid","TAN_FIELD_solid","EE_FIELD_solid","N_ex_FIELD_solid","TAN_ex_FIELD_solid","N_ex_SFIELD_total","TAN_ex_FIELD_total","N_OTHERS_solid","TAN_total","(PM=17)","(PM=44,03)","(PM=28,01)","(PM=30,01)","kg N","kg NH3","CHECK"]
[null,null,"nº plazas","kg N/AA","kg N-NH3/AA","kg N","kg N-TAN/AA","kg N-TAN",null,null,null,"Kg N","Kg N-NH3","kg  N-NH3","Kg N","kg  N-NH3",null,"Kg N","Kg N-NH3","kg  N-NH3","Kg N","kg  N-NH3",null,"Kg N","kg  N-NH3",null,"kg  N-NH3","kg N / AA","N_ret_BUILD_solid","TAN_ret_BUILD_solid",null,null,null,null,null,null,null,null,null,"kg  N-NH3","kg  N2O","kg  N2","kg  NOx","N_ret_STORE_solid","TAN_ret_STORE_solid",null,null,null,"kg N ","kg","kg N-NH3","N_ret_FIELD_solid","TAN_ret_FIELD_solid","N_ret_FIELD_total","TAN_ret_FIELD_total","kg N ","kg","kg N","kg N","kg N","kg N"]
["AVES PUESTA","Pollitas blancas en jaula",{"$f":"E.Datos!$E$25","v":0},0.28299999999999997,0.22800000000000001,{"$f":"C28*D28","v":0},{"$f":"E28/D28","v":0.80565371024734989},{"$f":"F28*G28","v":0},{"$f":"'F.Dist.'!$E$4","v":0},{"$f":"'F.Dist.'!$F$4","v":0},{"$f":"'F.Dist.'!$G$4","v":1},{"$f":"F28*I28","v":0},{"$f":"H28*I28","v":0},{"$f":"M28*'F.EE.'!C3","v":0},{"$f":"L28-N28","v":0},{"$f":"M28-N28","v":0},{"$f":"(I28*H28)-(N28+P28)","v":0},{"$f":"F28*J28","v":0},{"$f":"H28*J28","v":0},{"$f":"S28*'F.EE.'!F3","v":0},{"$f":"R28-T28","v":0},{"$f":"S28-T28","v":0},{"$f":"U28+T28+O28+N28-(F28*I28+F28*J28)","v":0},{"$f":"F28*K28","v":0},{"$f":"H28*K28","v":0},{"$f":"(Y28)-H28*K28","v":0},{"$f":"Y28*'F.EE.'!I3","v":0},{"$f":"'F.Dist.'!$J$4","v":0},{"$f":"(C28*AB28*K28)+X28-AA28","v":0},{"$f":"(Y28-AA28)*(1-0.0067)","v":0},{"$f":"(AC28+U28+O28)+(N28+T28+AA28)-(F28+AB28*C28*K28)","v":0},{"$f":"'F.Dist.'!K4","v":1},{"$f":"'F.Dist.'!L4","v":0},{"$f":"'F.Dist.'!M4","v":0},{"$f":"'F.Dist.'!O4","v":0},{"$f":"'F.Dist.'!P4","v":0},{"$f":"'F.Dist.'!Q4","v":0},{"$f":"AC28*AF28+U28*AI28","v":0},{"$f":"AD28*AF28+V28*AI28","v":0},{"$f":"AM28*'F.EE.'!L3","v":0},{"$f":"AM28*'F.EE.'!S3","v":0},{"$f":"AM28*'F.EE.'!T3","v":0},{"$f":"AM28*'F.EE.'!U3","v":0},{"$f":"AL28-AN28-AO28*(28/44)-AP28-AQ28*(14/46)","v":0},{"$f":"AM28-AN28-AO28*(28/44)-AP28-AQ28*(14/46)","v":0},{"$f":"(AR28+AN28+AP28+AO28*28/44+AQ28*14/46)-AL28","v":0},{"$f":"'F.Dist.'!S4","v":1},{"$f":"'F.Dist.'!T4","v":0},{"$f":"AR28*AU28+AC28*AG28+U28*AJ28","v":0},{"$f":"AS28*AU28+AD28*AG28+V28*AJ28","v":0},{"$f":"AX28*'F.EE.'!O3","v":0},{"$f":"AW28-AY28","v":0},{"$f":"AX28-AY28","v":0},{"$f":"AZ28+O28","v":0},{"$f":"BA28+P28","v":0},{"$f":"U28*AK28+AR28*AV28+AC28*AH28","v":0},{"$f":"V28*AK28+AS28*AV28+AD28*AH28","v":0},{"$f":"AY28+AN28+AA28+T28+N28","v":0},{"$f":"AO28*28/44","v":0},{"$f":"AP28","v":0},{"$f":"AQ28*14/46","v":0},{"$f":"SUM(BF28:BI28)","v":0},{"$f":"BF28*17/14","v":0},{"$f":"F28+(AB28*C28*K28)-(BB28+BD28+BJ28)","v":0}]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo",{"$f":"E.Datos!$E$27","v":0},0.57299999999999995,0.44,0,{"$f":"E29/D29","v":0.76788830715532297},{"$f":"F29*G29","v":0},{"$f":"'F.Dist.'!$E$5","v":0},{"$f":"'F.Dist.'!$F$5","v":0},{"$f":"'F.Dist.'!$G$5","v":1},{"$f":"F29*I29","v":0},{"$f":"H29*I29","v":0},{"$f":"M29*'F.EE.'!C4","v":0},{"$f":"L29-N29","v":0},{"$f":"M29-N29","v":0},{"$f":"(I29*H29)-(N29+P29)","v":0},{"$f":"F29*J29","v":0},{"$f":"H29*J29","v":0},{"$f":"S29*'F.EE.'!F4","v":0},{"$f":"R29-T29","v":0},{"$f":"S29-T29","v":0},{"$f":"U29+T29+O29+N29-(F29*I29+F29*J29)","v":0},{"$f":"F29*K29","v":0},{"$f":"H29*K29","v":0},{"$f":"(Y29)-H29*K29","v":0},{"$f":"Y29*'F.EE.'!I4","v":0},{"$f":"'F.Dist.'!$J$5","v":0},{"$f":"(C29*AB29*K29)+X29-AA29","v":0},{"$f":"(Y29-AA29)*(1-0.0067)","v":0},0,{"$f":"'F.Dist.'!K5","v":1},{"$f":"'F.Dist.'!L5","v":0},{"$f":"'F.Dist.'!M5","v":0},{"$f":"'F.Dist.'!O5","v":0},{"$f":"'F.Dist.'!P5","v":0},{"$f":"'F.Dist.'!Q5","v":0},{"$f":"AC29*AF29+U29*AI29","v":0},{"$f":"AD29*AF29+V29*AI29","v":0},{"$f":"AM29*'F.EE.'!L4","v":0},{"$f":"AM29*'F.EE.'!S4","v":0},{"$f":"AM29*'F.EE.'!T4","v":0},{"$f":"AM29*'F.EE.'!U4","v":0},{"$f":"AL29-AN29-AO29*(28/44)-AP29-AQ29*(14/46)","v":0},{"$f":"AM29-AN29-AO29*(28/44)-AP29-AQ29*(14/46)","v":0},{"$f":"(AR29+AN29+AP29+AO29*28/44+AQ29*14/46)-AL29","v":0},{"$f":"'F.Dist.'!S5","v":1},{"$f":"'F.Dist.'!T5","v":0},{"$f":"AR29*AU29+AC29*AG29+U29*AJ29","v":0},{"$f":"AS29*AU29+AD29*AG29+V29*AJ29","v":0},{"$f":"AX29*'F.EE.'!O4","v":0},{"$f":"AW29-AY29","v":0},{"$f":"AX29-AY29","v":0},{"$f":"AZ29+O29","v":0},{"$f":"BA29+P29","v":0},{"$f":"U29*AK29+AR29*AV29+AC29*AH29","v":0},{"$f":"V29*AK29+AS29*AV29+AD29*AH29","v":0},{"$f":"AY29+AN29+AA29+T29+N29","v":0},{"$f":"AO29*28/44","v":0},{"$f":"AP29","v":0},{"$f":"AQ29*14/46","v":0},{"$f":"SUM(BF29:BI29)","v":0},{"$f":"BF29*17/14","v":0},0]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo (muda)",{"$f":"E.Datos!$E$29","v":0},0.56999999999999995,0.43099999999999999,0,0.756140350877193,0,{"$f":"'F.Dist.'!E70","v":0},{"$f":"'F.Dist.'!$F$6","v":0},{"$f":"'F.Dist.'!$G$6","v":1},0,0,{"$f":"M30*'F.EE.'!C5","v":0},0,0,0,0,0,{"$f":"S30*'F.EE.'!F5","v":0},0,0,0,0,0,0,{"$f":"Y30*'F.EE.'!I5","v":0},{"$f":"'F.Dist.'!$J$6","v":0},0,0,0,{"$f":"'F.Dist.'!K6","v":1},{"$f":"'F.Dist.'!L6","v":0},{"$f":"'F.Dist.'!M6","v":0},{"$f":"'F.Dist.'!O6","v":0},{"$f":"'F.Dist.'!P6","v":0},{"$f":"'F.Dist.'!Q6","v":0},0,0,{"$f":"AM30*'F.EE.'!L5","v":0},{"$f":"AM30*'F.EE.'!S5","v":0},{"$f":"AM30*'F.EE.'!T5","v":0},{"$f":"AM30*'F.EE.'!U5","v":0},0,0,0,{"$f":"'F.Dist.'!S6","v":1},{"$f":"'F.Dist.'!T6","v":0},0,0,{"$f":"AX30*'F.EE.'!O5","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas blancas en jaula - muda",{"$f":"E.Datos!$E$31","v":0},0.621,0.53300000000000003,0,0.85829307568438007,0,{"$f":"'F.Dist.'!$E$7","v":0},{"$f":"'F.Dist.'!$F$7","v":0},{"$f":"'F.Dist.'!$G$7","v":1},0,0,{"$f":"M31*'F.EE.'!C6","v":0},0,0,0,{"$f":"F31*J31","v":0},0,{"$f":"S31*'F.EE.'!F6","v":0},0,0,0,0,0,0,{"$f":"Y31*'F.EE.'!I6","v":0},{"$f":"'F.Dist.'!$J$7","v":0},0,0,0,{"$f":"'F.Dist.'!K7","v":1},{"$f":"'F.Dist.'!L7","v":0},{"$f":"'F.Dist.'!M7","v":0},{"$f":"'F.Dist.'!O7","v":0},{"$f":"'F.Dist.'!P7","v":0},{"$f":"'F.Dist.'!Q7","v":0},0,0,{"$f":"AM31*'F.EE.'!L6","v":0},{"$f":"AM31*'F.EE.'!S6","v":0},{"$f":"AM31*'F.EE.'!T6","v":0},{"$f":"AM31*'F.EE.'!U6","v":0},0,0,0,{"$f":"'F.Dist.'!S7","v":1},{"$f":"'F.Dist.'!T7","v":0},0,0,{"$f":"AX31*'F.EE.'!O6","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas blancas en jaula - 2º ciclo",{"$f":"E.Datos!$E$33","v":0},0.60199999999999998,0.46200000000000002,0,0.76744186046511631,0,{"$f":"'F.Dist.'!$E$8","v":0},{"$f":"'F.Dist.'!$F$8","v":0},{"$f":"'F.Dist.'!$G$8","v":1},0,0,{"$f":"M32*'F.EE.'!C7","v":0},0,0,0,{"$f":"F32*J32","v":0},0,{"$f":"S32*'F.EE.'!F7","v":0},0,0,0,0,0,0,{"$f":"Y32*'F.EE.'!I7","v":0},{"$f":"'F.Dist.'!$J$8","v":0},0,0,0,{"$f":"'F.Dist.'!K8","v":1},{"$f":"'F.Dist.'!L8","v":0},{"$f":"'F.Dist.'!M8","v":0},{"$f":"'F.Dist.'!O8","v":0},{"$f":"'F.Dist.'!P8","v":0},{"$f":"'F.Dist.'!Q8","v":0},0,0,{"$f":"AM32*'F.EE.'!L7","v":0},{"$f":"AM32*'F.EE.'!S7","v":0},{"$f":"AM32*'F.EE.'!T7","v":0},{"$f":"AM32*'F.EE.'!U7","v":0},0,0,0,{"$f":"'F.Dist.'!S8","v":1},{"$f":"'F.Dist.'!T8","v":0},0,0,{"$f":"AX32*'F.EE.'!O7","v":0},0,0,0,0,0,0,{"$f":"AY32+AN32+AA32+T32+N32","v":0},0,0,0,0,0,0]
["AVES PUESTA","Pollitas rubias en jaula",{"$f":"E.Datos!$E$35","v":0},0.31,0.249,0,0.8032258064516129,0,{"$f":"'F.Dist.'!$E$9","v":0},{"$f":"'F.Dist.'!$F$9","v":0},{"$f":"'F.Dist.'!$G$9","v":1},0,0,{"$f":"M33*'F.EE.'!C8","v":0},0,0,0,0,0,{"$f":"S33*'F.EE.'!F8","v":0},0,0,0,0,0,0,{"$f":"Y33*'F.EE.'!I8","v":0},{"$f":"'F.Dist.'!$J$9","v":0},0,0,0,{"$f":"'F.Dist.'!K9","v":1},{"$f":"'F.Dist.'!L9","v":0},{"$f":"'F.Dist.'!M9","v":0},{"$f":"'F.Dist.'!O9","v":0},{"$f":"'F.Dist.'!P9","v":0},{"$f":"'F.Dist.'!Q9","v":0},0,0,{"$f":"AM33*'F.EE.'!L8","v":0},{"$f":"AM33*'F.EE.'!S8","v":0},{"$f":"AM33*'F.EE.'!T8","v":0},{"$f":"AM33*'F.EE.'!U8","v":0},0,0,0,{"$f":"'F.Dist.'!S9","v":1},{"$f":"'F.Dist.'!T9","v":0},0,0,{"$f":"AX33*'F.EE.'!O8","v":0},0,0,0,0,0,0,{"$f":"AY33+AN33+AA33+T33+N33","v":0},0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo",{"$f":"E.Datos!$E$37","v":0},0.64100000000000001,0.49399999999999999,0,0.77067082683307331,0,{"$f":"'F.Dist.'!$E$10","v":0},{"$f":"'F.Dist.'!$F$10","v":0},{"$f":"'F.Dist.'!$G$10","v":1},0,0,{"$f":"M34*'F.EE.'!C9","v":0},0,0,0,0,0,{"$f":"S34*'F.EE.'!F9","v":0},0,0,0,0,0,0,{"$f":"Y34*'F.EE.'!I9","v":0},{"$f":"'F.Dist.'!$J$10","v":0},0,0,0,{"$f":"'F.Dist.'!K10","v":1},{"$f":"'F.Dist.'!L10","v":0},{"$f":"'F.Dist.'!M10","v":0},{"$f":"'F.Dist.'!O10","v":0},{"$f":"'F.Dist.'!P10","v":0},{"$f":"'F.Dist.'!Q10","v":0},0,0,{"$f":"AM34*'F.EE.'!L9","v":0},{"$f":"AM34*'F.EE.'!S9","v":0},{"$f":"AM34*'F.EE.'!T9","v":0},{"$f":"AM34*'F.EE.'!U9","v":0},0,0,0,{"$f":"'F.Dist.'!S10","v":1},{"$f":"'F.Dist.'!T10","v":0},0,0,{"$f":"AX34*'F.EE.'!O9","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo (muda)",{"$f":"E.Datos!$E$39","v":0},0.61499999999999999,0.47,0,{"$f":"E35/D35","v":0.7642276422764227},0,{"$f":"'F.Dist.'!$E$11","v":0},{"$f":"'F.Dist.'!$F$11","v":0},{"$f":"'F.Dist.'!$G$11","v":1},0,0,{"$f":"M35*'F.EE.'!C10","v":0},0,0,0,0,0,{"$f":"S35*'F.EE.'!F10","v":0},0,0,0,0,0,0,{"$f":"Y35*'F.EE.'!I10","v":0},{"$f":"'F.Dist.'!$J$11","v":0},0,0,0,{"$f":"'F.Dist.'!K11","v":1},{"$f":"'F.Dist.'!L11","v":0},{"$f":"'F.Dist.'!M11","v":0},{"$f":"'F.Dist.'!O11","v":0},{"$f":"'F.Dist.'!P11","v":0},{"$f":"'F.Dist.'!Q11","v":0},0,0,{"$f":"AM35*'F.EE.'!L10","v":0},{"$f":"AM35*'F.EE.'!S10","v":0},{"$f":"AM35*'F.EE.'!T10","v":0},{"$f":"AM35*'F.EE.'!U10","v":0},0,0,0,{"$f":"'F.Dist.'!S11","v":1},{"$f":"'F.Dist.'!T11","v":0},0,0,{"$f":"AX35*'F.EE.'!O10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias en jaula - muda",{"$f":"E.Datos!$E$41","v":0},0.66300000000000003,0.56799999999999995,0,{"$f":"E36/D36","v":0.85671191553544479},{"$f":"F36*G36","v":0},{"$f":"'F.Dist.'!$E$12","v":0},{"$f":"'F.Dist.'!$F$12","v":0},{"$f":"'F.Dist.'!$G$12","v":1},0,0,{"$f":"M36*'F.EE.'!C11","v":0},0,0,0,0,0,{"$f":"S36*'F.EE.'!F11","v":0},0,0,0,0,0,0,{"$f":"Y36*'F.EE.'!I11","v":0},{"$f":"'F.Dist.'!$J$12","v":0},0,0,0,{"$f":"'F.Dist.'!K12","v":1},{"$f":"'F.Dist.'!L12","v":0},{"$f":"'F.Dist.'!M12","v":0},{"$f":"'F.Dist.'!O12","v":0},{"$f":"'F.Dist.'!P12","v":0},{"$f":"'F.Dist.'!Q12","v":0},0,0,{"$f":"AM36*'F.EE.'!L11","v":0},{"$f":"AM36*'F.EE.'!S11","v":0},{"$f":"AM36*'F.EE.'!T11","v":0},{"$f":"AM36*'F.EE.'!U11","v":0},0,0,0,{"$f":"'F.Dist.'!S12","v":1},{"$f":"'F.Dist.'!T12","v":0},0,0,{"$f":"AX36*'F.EE.'!O11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas rubias\nen jaula - 2º ciclo",{"$f":"E.Datos!$E$43","v":0},0.66600000000000004,0.51600000000000001,0,0.77477477477477474,{"$f":"F37*G37","v":0},{"$f":"'F.Dist.'!$E$13","v":0},{"$f":"'F.Dist.'!$F$13","v":0},{"$f":"'F.Dist.'!$G$13","v":1},0,0,{"$f":"M37*'F.EE.'!C12","v":0},0,0,0,0,0,{"$f":"S37*'F.EE.'!F12","v":0},0,0,0,0,0,0,{"$f":"Y37*'F.EE.'!I12","v":0},{"$f":"'F.Dist.'!$J$13","v":0},0,0,0,{"$f":"'F.Dist.'!K13","v":1},{"$f":"'F.Dist.'!L13","v":0},{"$f":"'F.Dist.'!M13","v":0},{"$f":"'F.Dist.'!O13","v":0},{"$f":"'F.Dist.'!P13","v":0},{"$f":"'F.Dist.'!Q13","v":0},0,0,{"$f":"AM37*'F.EE.'!L12","v":0},{"$f":"AM37*'F.EE.'!S12","v":0},{"$f":"AM37*'F.EE.'!T12","v":0},{"$f":"AM37*'F.EE.'!U12","v":0},0,0,0,{"$f":"'F.Dist.'!S13","v":1},{"$f":"'F.Dist.'!T13","v":0},0,0,{"$f":"AX37*'F.EE.'!O12","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Pollitas camperas",{"$f":"E.Datos!$E$45","v":0},0.34599999999999997,0.27900000000000003,0,0.8063583815028903,0,{"$f":"'F.Dist.'!$E$14","v":0},{"$f":"'F.Dist.'!$F$14","v":0},{"$f":"'F.Dist.'!$G$14","v":1},0,0,{"$f":"M38*'F.EE.'!C13","v":0},0,0,0,0,0,{"$f":"S38*'F.EE.'!F13","v":0},0,0,0,0,0,0,{"$f":"Y38*'F.EE.'!I13","v":0},{"$f":"'F.Dist.'!$J$14","v":0},0,0,0,{"$f":"'F.Dist.'!K14","v":1},{"$f":"'F.Dist.'!L14","v":0},{"$f":"'F.Dist.'!M14","v":0},{"$f":"'F.Dist.'!O14","v":1},{"$f":"'F.Dist.'!P14","v":0},{"$f":"'F.Dist.'!Q14","v":0},0,0,{"$f":"AM38*'F.EE.'!L13","v":0},{"$f":"AM38*'F.EE.'!S13","v":0},{"$f":"AM38*'F.EE.'!T13","v":0},{"$f":"AM38*'F.EE.'!U13","v":0},0,0,0,{"$f":"'F.Dist.'!S14","v":1},{"$f":"'F.Dist.'!T14","v":0},0,0,{"$f":"AX38*'F.EE.'!O13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["AVES PUESTA","Gallinas camperas",{"$f":"E.Datos!$E$47","v":0},0.64300000000000002,0.495,0,0.76982892690513216,0,{"$f":"'F.Dist.'!$E$15","v":0},{"$f":"'F.Dist.'!$F$15","v":0},{"$f":"'F.Dist.'!$G$15","v":1},0,0,{"$f":"M39*'F.EE.'!C14","v":0},0,0,0,0,0,{"$f":"S39*'F.EE.'!F14","v":0},0,0,0,0,0,0,{"$f":"Y39*'F.EE.'!I14","v":0},{"$f":"'F.Dist.'!$J$15","v":0},0,0,0,{"$f":"'F.Dist.'!K15","v":1},{"$f":"'F.Dist.'!L15","v":0},{"$f":"'F.Dist.'!M15","v":0},{"$f":"'F.Dist.'!O15","v":1},{"$f":"'F.Dist.'!P15","v":0},{"$f":"'F.Dist.'!Q15","v":0},0,0,{"$f":"AM39*'F.EE.'!L14","v":0},{"$f":"AM39*'F.EE.'!S14","v":0},{"$f":"AM39*'F.EE.'!T14","v":0},{"$f":"AM39*'F.EE.'!U14","v":0},0,0,0,{"$f":"'F.Dist.'!S15","v":1},{"$f":"'F.Dist.'!T15","v":0},0,0,{"$f":"AX39*'F.EE.'!O14","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTALS",null,{"$f":"SUM(C28:C39)","v":0},null,null,{"$f":"SUM(F28:F39)","v":0},null,{"$f":"SUM(H28:H39)","v":0},null,null,{"$f":"K39","v":1},{"$f":"SUM(L28:L39)","v":0},{"$f":"SUM(M28:M39)","v":0},{"$f":"SUM(N28:N39)","v":0},{"$f":"SUM(O28:O39)","v":0},{"$f":"SUM(P28:P39)","v":0},null,{"$f":"SUM(R28:R39)","v":0},{"$f":"SUM(S28:S39)","v":0},{"$f":"SUM(T28:T39)","v":0},{"$f":"SUM(U28:U39)","v":0},{"$f":"SUM(V28:V39)","v":0},null,{"$f":"SUM(X28:X39)","v":0},{"$f":"SUM(Y28:Y39)","v":0},null,{"$f":"SUM(AA28:AA39)","v":0},null,{"$f":"SUM(AC28:AC39)","v":0},{"$f":"SUM(AD28:AD39)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(AL28:AL39)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(AT28:AT39)","v":0},null,null,{"$f":"SUM(AW28:AW39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BF40:BI40)","v":0},{"$f":"BF40*17/14","v":0},{"$f":"SUM(BL28:BL39)","v":0}]

{"sheet":"F.EE.","index":8,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,0,1,0],[0,14,0,16],[0,2,0,4],[0,18,0,20],[0,5,0,7],[0,8,0,10],[0,11,0,13]]}
["SPECIE","CAT_AA","GRAZING",null,null,"YARD_solid",null,null,"BUILD-solid",null,null,"STORAGE_solid",null,null,"APPLIED_ solid",null,null,null,"STORAGE_solid"]
[null,null,"FE_GRAZING\nEFTIER I","FR_GRAZING","Fec_GRAZING","FE_YARD_solid","FR_YARD_solid","Fec_YARD_solid","FE_BUILD_solid","FR_BUILD_solid","FEc_BUILD_solid","FE_STORAGE_solid","FR_STORAGE_solid","FEc_STORAGE_solid","FE_APPLIED_solid","FR_APPLIED_solid","FEc_APPLIED_solid",null,"kg N2O","kg N2","kg NO"]
["AVES PUESTA","Pollitas blancas en jaula",0.32,1,{"$f":"C3*D3","v":0.32},{"$f":"I3","v":0.28000000000000003},1,{"$f":"F3*G3","v":0.28000000000000003},0.28000000000000003,{"$f":"VLOOKUP(E.Datos!J25,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},{"$f":"I3*J3","v":0.28000000000000003},0.17,{"$f":"VLOOKUP(E.Datos!V25,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},{"$f":"L3*M3","v":0.17},0.66,{"$f":"VLOOKUP(E.Datos!AB25,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},{"$f":"O3*P3","v":0.66},null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo",0.32,1,{"$f":"C4*D4","v":0.32},{"$f":"I4","v":0.41},1,{"$f":"F4*G4","v":0.41},0.41,{"$f":"VLOOKUP(E.Datos!J27,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},{"$f":"I4*J4","v":0.41},0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V27,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},{"$f":"L4*M4","v":0.14000000000000001},0.69,{"$f":"VLOOKUP(E.Datos!AB27,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},{"$f":"O4*P4","v":0.69},null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo (muda)",0.32,1,0.32,0.41,1,0.41,0.41,{"$f":"VLOOKUP(E.Datos!J29,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.41,0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V29,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.14000000000000001,0.69,{"$f":"VLOOKUP(E.Datos!AB29,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.69,null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas blancas en jaula - muda",0.32,1,0.32,0.41,1,0.41,0.41,{"$f":"VLOOKUP(E.Datos!J31,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.41,0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V31,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.14000000000000001,0.69,{"$f":"VLOOKUP(E.Datos!AB31,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.69,null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas blancas en jaula - 2º ciclo",0.32,1,0.32,0.41,1,0.41,0.41,{"$f":"VLOOKUP(E.Datos!J33,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.41,0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V33,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.14000000000000001,0.69,{"$f":"VLOOKUP(E.Datos!AB33,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.69,null,2E-3,0.3,0.01]
["AVES PUESTA","Pollitas rubias en jaula",0.32,1,0.32,0.28000000000000003,1,0.28000000000000003,0.28000000000000003,{"$f":"VLOOKUP(E.Datos!J35,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.28000000000000003,0.17,{"$f":"VLOOKUP(E.Datos!V35,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.17,0.66,{"$f":"VLOOKUP(E.Datos!AB35,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.66,null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo",0.32,1,0.32,0.41,1,0.41,0.41,{"$f":"VLOOKUP(E.Datos!J37,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.41,0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V37,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.14000000000000001,0.69,{"$f":"VLOOKUP(E.Datos!AB37,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.69,null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo (muda)",0.32,1,0.32,0.41,1,0.41,0.41,{"$f":"VLOOKUP(E.Datos!J39,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.41,0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V39,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.14000000000000001,0.69,{"$f":"VLOOKUP(E.Datos!AB39,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.69,null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas rubias en jaula - muda",0.32,1,0.32,0.41,1,0.41,0.41,{"$f":"VLOOKUP(E.Datos!J41,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.41,0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V41,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.14000000000000001,0.69,{"$f":"VLOOKUP(E.Datos!AB41,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.69,null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas rubias\nen jaula - 2º ciclo",0.32,1,0.32,0.41,1,0.41,0.41,{"$f":"VLOOKUP(E.Datos!J43,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},{"$f":"I12*J12","v":0.41},0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V43,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.14000000000000001,0.69,{"$f":"VLOOKUP(E.Datos!AB43,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.69,null,2E-3,0.3,0.01]
["AVES PUESTA","Pollitas camperas",0.32,1,0.32,0.28000000000000003,1,0.28000000000000003,0.28000000000000003,{"$f":"VLOOKUP(E.Datos!J45,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},0.28000000000000003,0.17,{"$f":"VLOOKUP(E.Datos!V45,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},0.17,0.66,{"$f":"VLOOKUP(E.Datos!AB45,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},0.66,null,2E-3,0.3,0.01]
["AVES PUESTA","Gallinas camperas",0.32,1,0.32,{"$f":"I14","v":0.41},1,{"$f":"F14*G14","v":0.41},0.41,{"$f":"VLOOKUP(E.Datos!J47,'F.EE.'!$B$20:$H$34,7,FALSE)","v":1},{"$f":"I14*J14","v":0.41},0.14000000000000001,{"$f":"VLOOKUP(E.Datos!V47,'F.EE.'!$K$20:$O$21,5,FALSE)","v":1},{"$f":"L14*M14","v":0.14000000000000001},0.69,{"$f":"VLOOKUP(E.Datos!AB47,'F.EE.'!$K$29:$O$33,5,FALSE)","v":1},{"$f":"O14*P14","v":0.69},null,2E-3,0.3,0.01]
[]
[]
["NH3 REDUCTIONS AND EMISSION FACTORS ACCORDING TO MANAGEMENT TECHNIQUES",null,null,null,null,null,null,null,null,"NH3 REDUCTIONS AND EMISSION FACTORS ACCORDING TO MANAGEMENT TECHNIQUES"]
[]
["FASE 1: ALOJAMIENTO DE ANIMALES + EVACUACIÓN Y ALMACENAMIENTO DEL ESTIÉRCOL EN LA GRANJA",null,null,null,null,null,"Coef. Reducción","F.R.",null,"FASE 2. ALMACENAMIENTO DE PURINES",null,null,null,"Coef. Reducción","F.R."]
["Opción 0","Jaulas no acondicionadas,  SIN SECADO estiércol ",null,null,null,null,0,{"$f":"1-G20","v":1},null,"Opción 0","Almacén abierto, sin cubrir",null,null,0,{"$f":"1-N20","v":1}]
["Opción A","Jaulas no acondicionadas, CON SECADO estiércol ",null,null,null,null,0.3,0.7,null,"Opción A","Almacén cubierto con materiales rígidos o flexibles",null,null,0.4,{"$f":"1-N21","v":0.6}]
["Opción B","Jaulas no acondicionadas, estiércol evacuado inmediatamente con cinta a almacén cerrado",null,null,null,null,0.65,0.35]
["Opción C","Jaulas acondicionadas con cinta y retirada de estiércol 2 veces a la semana",null,null,null,null,0.5,0.5]
["Opción D","Jaulas acondicionadas con cinta, SECADO, y retirada de estiércol 2 veces a la semana",null,null,null,null,0.85,0.15000000000000002]
["Opción E","Jaulas acondicionadas con cinta, SECADO y retirada de estiércol más de 2 veces a la semana",null,null,null,null,0.9,9.9999999999999978E-2]
["Opción F","Jaulas con sistemas de depuración de aire",null,null,null,null,0.8,0.19999999999999996,null,"NH3 REDUCTIONS AND EMISSION FACTORS ACCORDING TO MANAGEMENT TECHNIQUES"]
["Opción G","Cría en suelo con yacija profunda",null,null,null,null,0,1]
["Opción H","Cría en suelo con ventilación natural y sistema de bebederos sin pérdidas de agua, en suelos con yacija profunda",null,null,null,null,0.25,0.75,null,"FASE 3:  APLICACIÓN DEL ESTIERCOL AL CAMPO",null,null,null,"Coef. Reducción","F.R."]
["Opción I","Aviarios con perchas y retirada de estiércol en cinta, sin secado",null,null,null,null,0.77499999999999991,0.22500000000000009,null,"Opción 0","Esparcido, sin enterrado",null,null,0,{"$f":"1-N29","v":1}]
["Opción J","Aviarios con perchas y retirada de estiércol en cinta, con secado",null,null,null,null,0.875,0.125,null,"Opción A","Esparcido y enterrado de forma inmediata",null,null,0.9,9.9999999999999978E-2]
["Opción K","Cría en suelo con yacija, emparrillado parcial y cintas de evacuación",null,null,null,null,0.75,0.25,null,"Opción B","Incorporación al suelo con discos, de forma inmediata",null,null,0.7,0.30000000000000004]
["Opción L","Cria en suelo, con yacija con secado forzado",null,null,null,null,0.5,0.5,null,"Opción C","Enterrado en menos de 4 horas desde el esparcido",null,null,0.55000000000000004,0.44999999999999996]
["Opción M","Adición de sulfato de aluminio a la yacija",null,null,null,null,0.7,0.30000000000000004,null,"Opción D","Enterrado en más de 4 horas desde el esparcido",null,null,0.2,0.8]
["Opción N","Cría en suelo con sistemas depuración de aire",null,null,null,null,0.8,0.19999999999999996,null,null,null,null,null,0.3,0.7]
[]
[null,null,null,null,null,null,null,null,"BUILD-solid"]
[null,null,null,null,null,null,null,null,"FE_BUILD_solid","FR_BUILD_solid","FEc_BUILD_solid"]
[null,null,null,null,null,null,null,null,0.28000000000000003,{"$f":"VLOOKUP(E.Datos!J25,'F.EE.'!B20:H34,7,FALSE)","v":1},{"$f":"I38*J38","v":0.28000000000000003}]
[null,null,null,null,null,null,null,null,0.41,null,{"$f":"I39*J39","v":0}]
[null,null,null,null,null,null,null,null,0.41,null,0]
[null,null,null,null,null,null,null,null,0.41,null,0]
[null,null,null,null,null,null,null,null,0.41,null,0]
[null,null,null,null,null,null,null,null,0.28000000000000003,null,0]
[null,null,null,null,null,null,null,null,0.41,null,0]
[null,null,null,null,null,null,null,null,0.41,null,0]
[null,null,null,null,null,null,null,null,0.41,null,0]
[null,null,null,null,null,null,null,null,0.41,null,0]
[null,null,null,null,null,null,null,null,0.28000000000000003,null,0]
[null,null,null,null,null,null,null,null,0.41,null,0]

{"sheet":"F.Dist.","index":9,"n_rows":33,"n_cols":20,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,18,0,19],[1,17,2,17],[0,9,1,9],[1,13,2,13],[0,7,0,8],[1,7,2,7],[1,8,2,8],[0,10,0,12],[0,14,0,17],[19,11,19,13],[0,0,2,0],[0,1,2,1],[0,2,1,2],[0,4,0,6],[1,4,2,4],[1,5,2,5],[1,6,2,6]]}
["SPECIE","CAT_AA","x_TAN-T","GROSS PROTEIN","DISTRIBUTION_Excrete",null,null,"DISTRIBUTION_BUILD",null,"N_Straw","DISTRIBUTION_exBUILD_solid",null,null,null,"DISTRIBUTION_YARD_solid",null,null,null,"DISTRIBUTION_STORE_solid"]
[null,null,null,"SÍ","x_GRAZ","x_YARD","x_BUILD","X_BUILD_solid","X_BUILD_slurry",null,"x_exBUILD_solid-to-STORE_solid","x_exBUILD_solid-to-FIELD_solid","x_exBUILD_solid-to-OTHERS","CHECK","x_YARD-to-STORE_solid","x_YARD-to-FIELD_solid","x_YARD-to-OTHERS","CHECK","x_STORE_solid-to-FIELD_solid","x_STORE_solid-to-OTHERS"]
[null,null,"kg N-TAN/AA","NO",null,null,null,null,null,"kg N / AA"]
["AVES PUESTA","Pollitas blancas en jaula",{"$f":"Calculos!G4","v":0.80565371024734989},{"$f":"E.Datos!H25","v":"SÍ"},0,0,{"$f":"1-E4-F4","v":1},1,{"$f":"1-H4","v":0},{"$f":"IF(E.Datos!E25=0,0,(E.Datos!L25/E.Datos!E25)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R25=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R25=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R25=Guía!I49,1,0)","v":0},{"$f":"SUM(K4:M4)","v":1},{"$f":"IF(E.Datos!T25=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T25=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T25=Guía!I49,1,0)","v":0},{"$f":"SUM(O4:Q4)","v":0},{"$f":"IF(E.Datos!Z25=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z25=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo",{"$f":"Calculos!G5","v":0.76788830715532297},{"$f":"E.Datos!H27","v":"SÍ"},0,0,{"$f":"1-E5-F5","v":1},1,0,{"$f":"IF(E.Datos!E27=0,0,(E.Datos!L27/E.Datos!E27)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R27=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R27=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R27=Guía!I49,1,0)","v":0},{"$f":"SUM(K5:M5)","v":1},{"$f":"IF(E.Datos!T27=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T27=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T27=Guía!I49,1,0)","v":0},{"$f":"SUM(O5:Q5)","v":0},{"$f":"IF(E.Datos!Z27=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z27=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas blancas en jaula - 1er ciclo (muda)",{"$f":"Calculos!G6","v":0.756140350877193},{"$f":"E.Datos!H29","v":"SÍ"},0,0,{"$f":"1-E6-F6","v":1},1,0,{"$f":"IF(E.Datos!E29=0,0,(E.Datos!L29/E.Datos!E29)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R29=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R29=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R29=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T29=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T29=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T29=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z29=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z29=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas blancas en jaula - muda",{"$f":"Calculos!G7","v":0.85829307568438007},{"$f":"E.Datos!H31","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E31=0,0,(E.Datos!L31/E.Datos!E31)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R31=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R31=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R31=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T31=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T31=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T31=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z31=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z31=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas blancas en jaula - 2º ciclo",{"$f":"Calculos!G8","v":0.76744186046511631},{"$f":"E.Datos!H33","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E33=0,0,(E.Datos!L33/E.Datos!E33)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R33=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R33=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R33=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T33=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T33=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T33=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z33=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z33=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Pollitas rubias en jaula",{"$f":"Calculos!G9","v":0.8032258064516129},{"$f":"E.Datos!H35","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E35=0,0,(E.Datos!L35/E.Datos!E35)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R35=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R35=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R35=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T35=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T35=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T35=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z35=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z35=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo",{"$f":"Calculos!G10","v":0.77067082683307331},{"$f":"E.Datos!H37","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E37=0,0,(E.Datos!L37/E.Datos!E37)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R37=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R37=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R37=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T37=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T37=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T37=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z37=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z37=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas rubias en jaula - 1er ciclo (muda)",{"$f":"Calculos!G11","v":0.7642276422764227},{"$f":"E.Datos!H39","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E39=0,0,(E.Datos!L39/E.Datos!E39)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R39=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R39=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R39=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T39=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T39=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T39=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z39=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z39=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas rubias en jaula - muda",{"$f":"Calculos!G12","v":0.85671191553544479},{"$f":"E.Datos!H41","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E41=0,0,(E.Datos!L41/E.Datos!E41)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R41=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R41=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R41=Guía!I49,1,0)","v":0},{"$f":"SUM(K12:M12)","v":1},{"$f":"IF(E.Datos!T41=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T41=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T41=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z41=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z41=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas rubias\nen jaula - 2º ciclo",{"$f":"Calculos!G13","v":0.77477477477477474},{"$f":"E.Datos!H43","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E43=0,0,(E.Datos!L43/E.Datos!E43)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R43=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R43=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R43=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T43=Guía!I47,1,0)","v":0},{"$f":"IF(E.Datos!T43=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T43=Guía!I49,1,0)","v":0},0,{"$f":"IF(E.Datos!Z43=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z43=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Pollitas camperas",{"$f":"Calculos!G14","v":0.8063583815028903},{"$f":"E.Datos!H45","v":"SÍ"},0,{"$f":"IF(E.Datos!N45=\"SÍ\",0.3333,0)","v":0},{"$f":"1-E14-F14","v":1},1,0,{"$f":"IF(E.Datos!E45=0,0,(E.Datos!L45/E.Datos!E45)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R45=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R45=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R45=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!T45=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!T45=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T45=Guía!I49,1,0)","v":0},1,{"$f":"IF(E.Datos!Z45=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z45=Guía!I49,1,0)","v":0}]
["AVES PUESTA","Gallinas camperas",{"$f":"Calculos!G15","v":0.76982892690513216},{"$f":"E.Datos!H47","v":"SÍ"},0,{"$f":"IF(E.Datos!N47=\"SÍ\",0.3333,0)","v":0},{"$f":"1-E15-F15","v":1},1,0,{"$f":"IF(E.Datos!E47=0,0,(E.Datos!L47/E.Datos!E47)*'F.Dist.'!J28)","v":0},{"$f":"IF(E.Datos!R47=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!R47=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!R47=Guía!I49,1,0)","v":0},{"$f":"SUM(K15:M15)","v":1},{"$f":"IF(E.Datos!T47=Guía!I47,1,0)","v":1},{"$f":"IF(E.Datos!T47=Guía!I48,1,0)","v":0},{"$f":"IF(E.Datos!T47=Guía!I49,1,0)","v":0},{"$f":"SUM(O15:Q15)","v":1},{"$f":"IF(E.Datos!Z47=Guía!I48,1,0)","v":1},{"$f":"IF(E.Datos!Z47=Guía!I49,1,0)","v":0}]
[]
[]
[]
[null,null,null,"Datos obtenidos por Com. Pers. MAPAMA:",null,null,null,"Min","Max","Media"]
[null,null,null,"Densidad (kg pollo/m2)",null,null,null,33,42,{"$f":"AVERAGE(33,42)","v":37.5}]
[null,null,null,"Densidad (pollo/m2)",null,null,null,{"$f":"H20/2.3","v":14.347826086956523},{"$f":"I20/2.3","v":18.260869565217394},{"$f":"AVERAGE(H21:I21)","v":16.304347826086961}]
[null,null,null,"Superficie (m2/pollo)",null,null,null,{"$f":"H21^-1","v":6.9696969696969688E-2},{"$f":"I21^-1","v":5.4761904761904755E-2},{"$f":"AVERAGE(H22:I22)","v":6.2229437229437218E-2}]
[null,null,null,"Superficie (cm2/pollo)",null,null,null,{"$f":"H22*10000","v":696.96969696969688},{"$f":"I22*10000","v":547.61904761904759},{"$f":"AVERAGE(H23:I23)","v":622.29437229437224}]
[null,null,null,"Volumen (cm3/pollo)",null,null,null,{"$f":"4*H23","v":2787.8787878787875},{"$f":"4*I23","v":2190.4761904761904},2489.177489177489]
[null,null,null,"Datos de consulta bibliográfica:"]
[null,null,null,"Densidad paja cereal (kg/m3)",null,null,null,125,165,145]
[null,null,null,"Densidad paja cereal (kg/cm3)",null,null,null,{"$f":"H26/1000000","v":1.25E-4},{"$f":"I26/1000000","v":1.65E-4},1.45E-4]
[null,null,null,"Contenido N en paja cereal (kg/kg)",null,null,null,{"$f":"0.3/100","v":3.0000000000000001E-3},{"$f":"1.1/100","v":1.1000000000000001E-2},7.000000000000001E-3]
[]
[null,null,null,null,"La Directiva 1999/74/CE establece unos mínimos de"]
[null,null,null,null,null,"250 cm2 de yacija por gallina"]
[null,null,null,null,null,"550 cm2 de jaula no acondicionada por gallina"]
[null,null,null,null,null,"750 cm2 de jaula acondicionada por gallina"]