{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Portada","Presentación","Instrucciones","E.Datos","E.Datos2","Metano","Resultados PRTR","Result. N","Calculos","F.EE.","F.Dist."],"not_rendered":{"charts":0,"images":9,"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":"Portada","index":0,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":true,"merged":[[0,5,4,17],[6,0,8,2],[6,3,8,17],[52,0,52,6]]}
[null,null,null,null,null,"ESTIMADOR DE EMISIONES DE AMONIACO Y DE NITRÓGENO RETENIDO EN EXPLOTACIONES GANADERAS"]
[]
[]
[]
[]
[]
[2018,null,null,"GANADO AVIAR: AVES DE CARNE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["© Ministerio de Agricultura y Pesca, Alimentación y Medio Ambiente"]

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

{"sheet":"Instrucciones","index":2,"n_rows":50,"n_cols":17,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,16,11,16],[24,16,25,16],[28,16,29,16],[30,16,31,16],[26,16,27,16],[14,16,15,16],[16,16,17,16],[18,16,19,16],[20,16,21,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, estiércol no ventilado debajo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jaulas no acondicionadas, estiércol debajo y secado"]
[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,"Jaulas acondicionadas con cinta de 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 de 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,"Suelo con yacija profunda"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suelo con yacija profunda, ventilación natural y sistema de bebederos sin pérdidas de agua."]
[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,"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,"Suelo con yacija con secado forzado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suelo con 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,"Suelo con yacija y 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,null,null,null,null,null,null,null,null,"Esparcido y enterrado de forma inmediata"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incorporación al suelo con discos, de forma inmediata"]
[null,null,null,null,null,null,null,null,null,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"]
[]
[null,null,null,null,null,null,null,null,"A almacenamiento"]
[null,null,null,null,null,null,null,null,"Al campo o terreno agrícola"]
[null,null,null,null,null,null,null,null,"A otros usos no agrarios"]

{"sheet":"E.Datos","index":3,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,2,24],[9,19,10,23],[4,19,6,23],[3,4,4,9],[3,11,3,17],[4,11,6,17],[7,19,8,23],[10,11,10,17],[8,11,8,17],[6,7,6,9],[8,7,8,9],[9,7,10,9],[12,7,12,9],[14,7,15,9],[3,1,4,3],[5,1,6,3],[7,1,8,3],[9,1,10,3],[11,1,12,3],[13,1,14,3],[21,6,22,6],[21,7,22,7],[28,2,28,3],[16,2,16,3],[24,2,24,3],[26,2,26,3],[21,1,31,1],[21,2,22,3],[21,4,22,4],[15,1,15,3],[12,19,13,23],[21,23,22,23],[12,11,13,17],[21,21,22,21],[18,19,18,23],[14,19,15,23],[21,17,22,19],[14,11,14,17],[15,11,15,17],[17,7,18,9],[28,17,28,19],[26,17,26,19],[21,13,21,15],[17,11,17,17],[23,17,23,19],[24,17,24,19],[21,9,22,9]]}
["GANADO AVIAR: AVES DE CARNE"]
[]
[]
[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,"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,"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,"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,"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,"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,"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,"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,"Sólo si procede, diferenciar por categoría animal."]
[]
[]
[null,"A N I M A L E S","CATEGORIAS PRODUCTIVAS",null,"Nº PLAZAS ",null,"PROTEINA BRUTA ALIMENTARIA\n% PB ración","SÍ / NO",null,"ALOJAMIENTO DE ANIMALES Y EVACUACION DEL ESTIERCOL",null,"APORTACION DE PAJA, SERRIN, VIRUTAS,…",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,null,null,null,null,null,"(kg totales/año)",null,"A LA SALIDA DE LA NAVE",null,"A LA SALIDA DEL PATIO"]
[]
[null,null,"Broilers",null,null,null,"21,65-21,80","SÍ",null,"Suelo con yacija profunda",null,0,null,"A otros usos no agrarios",null,"A otros usos no agrarios",null,"Almacén abierto, sin cubrir",null,null,null,"A otros usos no agrarios",null,"Esparcido, sin enterrado"]
[]
[null,null,"Pollitas de recría carne",null,null,null,"16,75-16,85","SÍ",null,"Suelo con yacija profunda",null,0,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 reproductoras carne",null,null,null,"15,87-16,00","SÍ",null,"Suelo con yacija profunda",null,0,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:E30)>0,SUM(E25:E30),\"\")","v":""}]

{"sheet":"E.Datos2","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[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],[17,0,20,0],[19,4,19,6],[19,1,19,3],[17,1,17,6],[20,4,20,6],[20,1,20,3]]}
[]
[null,"                                    IDENTIFICACIÓN PROVINCIA"]
[]
[null,"Provincia de ubicación",null,"Provincia"]
[]
[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,"Pollos de carne (Cría en suelo con yacija)"]
[null,null,null,"Total",{"$f":"IF(E21=0,\"\",E21)","v":""}]

{"sheet":"Metano","index":5,"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":"Provincia"}]
[null,"Valencia",0.10344,null,"Factor de emisión",{"$f":"IF(F7=\"Provincia\",0,VLOOKUP(F7,$B$8:$C$10,2,0))","v":0}]
[null,"Alicante",0.10378,null,"nº de plazas",{"$f":"E.Datos2!E22","v":""}]
[null,"Castellón de la Plana",9.9320000000000006E-2,null,"Emisión de CH4",{"$f":"F8*F9","v":{"$error":"#VALUE!"}}]
[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":6,"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!BM7=0,\"\",Calculos!BM7)","v":""}]
[null,"Óxido nitroso (N2O)",{"$f":"IF(Calculos!AQ7=0,\"\",Calculos!AQ7)","v":""}]
[null,"Óxidos de nitrógeno (NOx)",{"$f":"IF(Calculos!AS7=0,\"\",Calculos!AS7)","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 carne-MAPA."]
[null,"* Fuentes o referencias: \"Otros\". Estimador de emisiones de amoniaco y de nitrógeno en explotaciones avícolas de carne-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":7,"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,12],[3,5,3,12],[19,3,19,10],[28,3,28,10],[22,6,22,9],[30,8,30,10],[21,6,21,11],[21,4,21,5],[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 CARNE"]
[]
[]
[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,"N-TOTAL ","Referencia*"]
[null,null,null,null,"N - NH3","N - NH3","N - NH3","N - NOx","N - N2O","N - N2","Emitido","N-TOTAL"]
[null,null,"Total granja",null,{"$f":"Calculos!AC7","v":0},{"$f":"Calculos!AC21","v":0},{"$f":"Calculos!BH7","v":0},{"$f":"Calculos!BK7","v":0},{"$f":"Calculos!BI7","v":0},{"$f":"Calculos!BJ7","v":0},{"$f":"SUM(G25:J25)","v":0},{"$f":"Calculos!BL21","v":0}]
[null,null,"Promedio/plaza *año",null,{"$f":"Calculos!AC7/Calculos!C7","v":{"$error":"#DIV/0!"}},{"$f":"Calculos!AC21/Calculos!C21","v":{"$error":"#DIV/0!"}},{"$f":"G25/Calculos!C7","v":{"$error":"#DIV/0!"}},{"$f":"H25/Calculos!C7","v":{"$error":"#DIV/0!"}},{"$f":"I25/Calculos!C7","v":{"$error":"#DIV/0!"}},{"$f":"J25/Calculos!C7","v":{"$error":"#DIV/0!"}},{"$f":"K25/Calculos!$C$7","v":{"$error":"#DIV/0!"}},{"$f":"L25/Calculos!$C$7","v":{"$error":"#DIV/0!"}}]
[null,null,"% N emitido sobre N excretado",null,null,null,{"$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,null,"% N respecto a situación de referencia",null,null,null,{"$f":"G25*100/Calculos!BH21","v":{"$error":"#DIV/0!"}},{"$f":"H25*100/Calculos!BK21","v":{"$error":"#DIV/0!"}},{"$f":"I25*100/Calculos!BI21","v":{"$error":"#DIV/0!"}},{"$f":"J25*100/Calculos!BJ21","v":{"$error":"#DIV/0!"}},{"$f":"K25*100/L25","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,"N excretado",null,"N permanece en suelo"]
[null,null,null,null,null,null,"Explotación",null,null,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!H7+(Calculos!E7*Calculos!M7*Calculos!AD7)","v":{"$error":"#DIV/0!"}},null,{"$f":"Calculos!BD7","v":0},null,{"$f":"Calculos!BD21","v":0}]
[null,null,null,"kg N excretado/plaza*año",null,null,{"$f":"G34/Calculos!C7","v":{"$error":"#DIV/0!"}},null,{"$f":"I34/Calculos!C7","v":{"$error":"#DIV/0!"}},null,{"$f":"K34/Calculos!C7","v":{"$error":"#DIV/0!"}}]
[null,null,null,"% N sobre N excretado",null,null,null,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."]

{"sheet":"Calculos","index":8,"n_rows":21,"n_cols":66,"rows_kept":21,"cut":false,"hidden":true,"merged":[[14,50,14,54],[14,55,14,56],[14,57,14,58],[15,63,16,63],[15,64,16,64],[14,29,14,32],[14,33,14,35],[14,36,14,38],[14,39,14,47],[14,48,14,49],[14,5,14,9],[14,10,14,12],[14,13,14,18],[14,19,14,24],[14,25,14,28],[14,0,16,0],[14,1,16,1],[14,2,15,2],[14,3,15,3],[14,4,15,4],[0,0,2,0],[0,1,2,1],[0,4,1,4],[0,2,1,2],[0,3,1,3],[1,63,2,63],[1,64,2,64],[0,5,0,9],[0,10,0,12],[0,33,0,35],[0,36,0,38],[0,57,0,58],[0,55,0,56],[0,48,0,49],[0,50,0,54],[0,13,0,18],[0,19,0,24],[0,25,0,28],[0,29,0,32],[0,39,0,47]]}
["SPECIE","CAT_AA","N_PP","AA / PP","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,null,null,"Nex_T / PP","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","nº an. / PP","nº animals","kg N/PP","kg N-NH3/PP","kg N","kg N-TAN/PP","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 / PP","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 CARNE","Broilers",{"$f":"E.Datos!E25","v":0},5.79,{"$f":"C4*D4","v":0},0.44,{"$f":"0.110667","v":0.110667},{"$f":"C4*F4","v":0},null,{"$f":"G4*C4","v":0},{"$f":"'F.Dist.'!E4","v":0},{"$f":"'F.Dist.'!F4","v":0},{"$f":"'F.Dist.'!G4","v":1},{"$f":"H4*K4","v":0},{"$f":"J4*K4","v":0},{"$f":"O4*'F.EE.'!E3","v":0},{"$f":"N4-P4","v":0},{"$f":"O4-P4","v":0},{"$f":"(K4*J4)-(P4+R4)","v":0},{"$f":"H4*L4","v":0},{"$f":"J4*L4","v":0},{"$f":"U4*'F.EE.'!H3","v":0},{"$f":"T4-V4","v":0},{"$f":"U4-V4","v":0},{"$f":"W4+V4+Q4+P4-(H4*K4+H4*L4)","v":0},{"$f":"H4*M4","v":0},{"$f":"J4*M4","v":0},{"$f":"(AA4)-J4*M4","v":0},{"$f":"AA4*'F.EE.'!K3","v":0},{"$f":"'F.Dist.'!J4","v":0},{"$f":"(C4*AD4*M4)+Z4-AC4","v":0},{"$f":"(AA4-AC4)*(1-0.0067)","v":0},{"$f":"(AE4+W4+Q4)+(P4+V4+AC4)-(H4+AD4*C4*M4)","v":0},{"$f":"'F.Dist.'!K4","v":0},{"$f":"'F.Dist.'!L4","v":0},{"$f":"'F.Dist.'!M4","v":1},{"$f":"'F.Dist.'!O4","v":0},{"$f":"'F.Dist.'!P4","v":0},{"$f":"'F.Dist.'!Q4","v":1},{"$f":"AE4*AH4+W4*AK4","v":0},{"$f":"AF4*AH4+X4*AK4","v":0},{"$f":"AO4*'F.EE.'!N3","v":0},{"$f":"AO4*'F.EE.'!S3","v":0},{"$f":"AO4*'F.EE.'!T3","v":0},{"$f":"AO4*'F.EE.'!U3","v":0},{"$f":"AN4-AP4-AQ4*(28/44)-AR4-AS4*(14/46)","v":0},{"$f":"AO4-AP4-AQ4*(28/44)-AR4-AS4*(14/46)","v":0},{"$f":"(AT4+AP4+AR4+AQ4*28/44+AS4*14/46)-AN4","v":0},{"$f":"'F.Dist.'!S4","v":0},{"$f":"'F.Dist.'!T4","v":1},{"$f":"AT4*AW4+AE4*AI4+W4*AL4","v":0},{"$f":"AU4*AW4+AF4*AI4+X4*AL4","v":0},{"$f":"AZ4*'F.EE.'!Q3","v":0},{"$f":"AY4-BA4","v":0},{"$f":"AZ4-BA4","v":0},{"$f":"BB4+Q4","v":0},{"$f":"BC4+R4","v":0},{"$f":"W4*AM4+AT4*AX4+AE4*AJ4","v":0},{"$f":"X4*AM4+AU4*AX4+AF4*AJ4","v":0},{"$f":"BA4+AP4+AC4+V4+P4","v":0},{"$f":"AQ4*28/44","v":0},{"$f":"AR4","v":0},{"$f":"AS4*14/46","v":0},{"$f":"SUM(BH4:BK4)","v":0},{"$f":"BH4*17/14","v":0},{"$f":"H4+(AD4*C4*M4)-(BF4+BL4+BD4)","v":0}]
["AVES CARNE","Pollitas de recría carne",{"$f":"E.Datos!E27","v":0},2,{"$f":"C5*D5","v":0},0.30599999999999999,{"$f":"0.064583","v":6.4583000000000002E-2},{"$f":"C5*F5","v":0},null,{"$f":"G5*C5","v":0},{"$f":"'F.Dist.'!E5","v":0},{"$f":"'F.Dist.'!F5","v":0},{"$f":"'F.Dist.'!G5","v":1},{"$f":"H5*K5","v":0},{"$f":"J5*K5","v":0},{"$f":"O5*'F.EE.'!E4","v":0},{"$f":"N5-P5","v":0},{"$f":"O5-P5","v":0},{"$f":"(K5*J5)-(P5+R5)","v":0},{"$f":"H5*L5","v":0},{"$f":"J5*L5","v":0},{"$f":"U5*'F.EE.'!H4","v":0},{"$f":"T5-V5","v":0},{"$f":"U5-V5","v":0},{"$f":"W5+V5+Q5+P5-(H5*K5+H5*L5)","v":0},{"$f":"H5*M5","v":0},{"$f":"J5*M5","v":0},{"$f":"(AA5)-J5*M5","v":0},{"$f":"AA5*'F.EE.'!K4","v":0},{"$f":"'F.Dist.'!J5","v":0},{"$f":"(C5*AD5*M5)+Z5-AC5","v":0},{"$f":"(AA5-AC5)*(1-0.0067)","v":0},{"$f":"(AE5+W5+Q5)+(P5+V5+AC5)-(H5+AD5*C5*M5)","v":0},{"$f":"'F.Dist.'!K5","v":1},{"$f":"'F.Dist.'!L5","v":0},{"$f":"'F.Dist.'!M5","v":0},{"$f":"'F.Dist.'!O5","v":1},{"$f":"'F.Dist.'!P5","v":0},{"$f":"'F.Dist.'!Q5","v":0},{"$f":"AE5*AH5+W5*AK5","v":0},{"$f":"AF5*AH5+X5*AK5","v":0},{"$f":"AO5*'F.EE.'!N4","v":0},{"$f":"AO5*'F.EE.'!S4","v":0},{"$f":"AO5*'F.EE.'!T4","v":0},{"$f":"AO5*'F.EE.'!U4","v":0},{"$f":"AN5-AP5-AQ5*(28/44)-AR5-AS5*(14/46)","v":0},{"$f":"AO5-AP5-AQ5*(28/44)-AR5-AS5*(14/46)","v":0},{"$f":"(AT5+AP5+AR5+AQ5*28/44+AS5*14/46)-AN5","v":0},{"$f":"'F.Dist.'!S5","v":1},{"$f":"'F.Dist.'!T5","v":0},{"$f":"AT5*AW5+AE5*AI5+W5*AL5","v":0},{"$f":"AU5*AW5+AF5*AI5+X5*AL5","v":0},{"$f":"AZ5*'F.EE.'!Q4","v":0},{"$f":"AY5-BA5","v":0},{"$f":"AZ5-BA5","v":0},{"$f":"BB5+Q5","v":0},{"$f":"BC5+R5","v":0},{"$f":"W5*AM5+AT5*AX5+AE5*AJ5","v":0},{"$f":"X5*AM5+AU5*AX5+AF5*AJ5","v":0},{"$f":"BA5+AP5+AC5+V5+P5","v":0},{"$f":"AQ5*28/44","v":0},{"$f":"AR5","v":0},{"$f":"AS5*14/46","v":0},{"$f":"SUM(BH5:BK5)","v":0},{"$f":"BH5*17/14","v":0},{"$f":"H5+(AD5*C5*M5)-(BF5+BL5+BD5)","v":0}]
["AVES CARNE","Gallinas reproductoras carne",{"$f":"E.Datos!E29","v":0},1,{"$f":"C6*D6","v":0},0.747,{"$f":"0.148411","v":0.14841099999999999},{"$f":"C6*F6","v":0},null,0,{"$f":"'F.Dist.'!E6","v":0},{"$f":"'F.Dist.'!F6","v":0},{"$f":"'F.Dist.'!G6","v":1},{"$f":"H6*K6","v":0},{"$f":"J6*K6","v":0},{"$f":"O6*'F.EE.'!E5","v":0},{"$f":"N6-P6","v":0},{"$f":"O6-P6","v":0},{"$f":"(K6*J6)-(P6+R6)","v":0},{"$f":"H6*L6","v":0},{"$f":"J6*L6","v":0},{"$f":"U6*'F.EE.'!H5","v":0},{"$f":"T6-V6","v":0},{"$f":"U6-V6","v":0},{"$f":"W6+V6+Q6+P6-(H6*K6+H6*L6)","v":0},{"$f":"H6*M6","v":0},{"$f":"J6*M6","v":0},0,{"$f":"AA6*'F.EE.'!K5","v":0},{"$f":"'F.Dist.'!J6","v":0},{"$f":"(C6*AD6*M6)+Z6-AC6","v":0},{"$f":"(AA6-AC6)*(1-0.0067)","v":0},{"$f":"(AE6+W6+Q6)+(P6+V6+AC6)-(H6+AD6*C6*M6)","v":0},{"$f":"'F.Dist.'!K6","v":1},{"$f":"'F.Dist.'!L6","v":0},{"$f":"'F.Dist.'!M6","v":0},{"$f":"'F.Dist.'!O6","v":1},{"$f":"'F.Dist.'!P6","v":0},{"$f":"'F.Dist.'!Q6","v":0},{"$f":"AE6*AH6+W6*AK6","v":0},0,{"$f":"AO6*'F.EE.'!N5","v":0},{"$f":"AO6*'F.EE.'!S5","v":0},{"$f":"AO6*'F.EE.'!T5","v":0},{"$f":"AO6*'F.EE.'!U5","v":0},{"$f":"AN6-AP6-AQ6*(28/44)-AR6-AS6*(14/46)","v":0},{"$f":"AO6-AP6-AQ6*(28/44)-AR6-AS6*(14/46)","v":0},{"$f":"(AT6+AP6+AR6+AQ6*28/44+AS6*14/46)-AN6","v":0},{"$f":"'F.Dist.'!S6","v":1},{"$f":"'F.Dist.'!T6","v":0},{"$f":"AT6*AW6+AE6*AI6+W6*AL6","v":0},0,{"$f":"AZ6*'F.EE.'!Q5","v":0},{"$f":"AY6-BA6","v":0},{"$f":"AZ6-BA6","v":0},{"$f":"BB6+Q6","v":0},0,0,0,0,0,0,0,{"$f":"SUM(BH6:BK6)","v":0},{"$f":"BH6*17/14","v":0},{"$f":"H6+(AD6*C6*M6)-(BF6+BL6+BD6)","v":0}]
["TOTALS",null,{"$f":"SUM(C4:C6)","v":0},null,{"$f":"SUM(E4:E6)","v":0},null,null,{"$f":"SUM(H4:H6)","v":0},null,{"$f":"SUM(J4:J6)","v":0},null,null,null,{"$f":"SUM(N4:N6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AC4:AC6)","v":0},{"$f":"(C4*AD4+C5*AD5+C6*AD6)/C7","v":{"$error":"#DIV/0!"}},0,0,{"$f":"SUM(AG4:AG6)","v":0},null,null,null,null,null,null,{"$f":"SUM(AN4:AN6)","v":0},0,0,0,0,0,0,0,null,null,null,{"$f":"SUM(AY4:AY6)","v":0},0,0,0,0,{"$f":"SUM(BD4:BD6)","v":0},{"$f":"SUM(BE4:BE6)","v":0},0,0,{"$f":"SUM(BH4:BH6)","v":0},0,0,0,{"$f":"SUM(BH7:BK7)","v":0},{"$f":"BH7*17/14","v":0},{"$f":"SUM(BN4:BN6)","v":0}]
[]
[]
[]
[]
[]
[]
[]
["SPECIE","CAT_AA","N_PP","AA / PP","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,null,null,"Nex_T / PP","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","nº an. / PP","nº animals","kg N/PP","kg N-NH3/PP","kg N","kg N-TAN/PP","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 / PP","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 CARNE","Broilers",{"$f":"E.Datos!E25","v":0},5.79,{"$f":"C18*D18","v":0},0.44,{"$f":"0.110667","v":0.110667},{"$f":"C18*F18","v":0},null,{"$f":"G18*C18","v":0},{"$f":"'F.Dist.'!E4","v":0},{"$f":"'F.Dist.'!F4","v":0},{"$f":"'F.Dist.'!G4","v":1},{"$f":"H18*K18","v":0},{"$f":"J18*K18","v":0},{"$f":"O18*'F.EE.'!C3","v":0},{"$f":"N18-P18","v":0},{"$f":"O18-P18","v":0},{"$f":"(K18*J18)-(P18+R18)","v":0},{"$f":"H18*L18","v":0},{"$f":"J18*L18","v":0},{"$f":"U18*'F.EE.'!F3","v":0},{"$f":"T18-V18","v":0},{"$f":"U18-V18","v":0},{"$f":"W18+V18+Q18+P18-(H18*K18+H18*L18)","v":0},{"$f":"H18*M18","v":0},{"$f":"J18*M18","v":0},{"$f":"(AA18)-J18*M18","v":0},{"$f":"AA18*'F.EE.'!I3","v":0},{"$f":"'F.Dist.'!J4","v":0},{"$f":"(C18*AD18*M18)+Z18-AC18","v":0},{"$f":"(AA18-AC18)*(1-0.0067)","v":0},{"$f":"(AE18+W18+Q18)+(P18+V18+AC18)-(H18+AD18*C18*M18)","v":0},{"$f":"'F.Dist.'!K4","v":0},{"$f":"'F.Dist.'!L4","v":0},{"$f":"'F.Dist.'!M4","v":1},{"$f":"'F.Dist.'!O4","v":0},{"$f":"'F.Dist.'!P4","v":0},{"$f":"'F.Dist.'!Q4","v":1},{"$f":"AE18*AH18+W18*AK18","v":0},{"$f":"AF18*AH18+X18*AK18","v":0},{"$f":"AO18*'F.EE.'!L3","v":0},{"$f":"AO18*'F.EE.'!S3","v":0},{"$f":"AO18*'F.EE.'!T3","v":0},{"$f":"AO18*'F.EE.'!U3","v":0},{"$f":"AN18-AP18-AQ18*(28/44)-AR18-AS18*(14/46)","v":0},{"$f":"AO18-AP18-AQ18*(28/44)-AR18-AS18*(14/46)","v":0},{"$f":"(AT18+AP18+AR18+AQ18*28/44+AS18*14/46)-AN18","v":0},{"$f":"'F.Dist.'!S4","v":0},{"$f":"'F.Dist.'!T4","v":1},{"$f":"AT18*AW18+AE18*AI18+W18*AL18","v":0},{"$f":"AU18*AW18+AF18*AI18+X18*AL18","v":0},{"$f":"AZ18*'F.EE.'!O3","v":0},{"$f":"AY18-BA18","v":0},{"$f":"AZ18-BA18","v":0},{"$f":"BB18+Q18","v":0},{"$f":"BC18+R18","v":0},{"$f":"W18*AM18+AT18*AX18+AE18*AJ18","v":0},{"$f":"X18*AM18+AU18*AX18+AF18*AJ18","v":0},{"$f":"BA18+AP18+AC18+V18+P18","v":0},{"$f":"AQ18*28/44","v":0},{"$f":"AR18","v":0},{"$f":"AS18*14/46","v":0},{"$f":"SUM(BH18:BK18)","v":0},{"$f":"BH18*17/14","v":0},{"$f":"H18+(AD18*C18*M18)-(BF18+BL18+BD18)","v":0}]
["AVES CARNE","Pollitas de recría carne",{"$f":"E.Datos!E27","v":0},2,{"$f":"C19*D19","v":0},0.30599999999999999,{"$f":"0.064583","v":6.4583000000000002E-2},{"$f":"C19*F19","v":0},null,{"$f":"G19*C19","v":0},{"$f":"'F.Dist.'!E5","v":0},{"$f":"'F.Dist.'!F5","v":0},{"$f":"'F.Dist.'!G5","v":1},{"$f":"H19*K19","v":0},{"$f":"J19*K19","v":0},{"$f":"O19*'F.EE.'!C4","v":0},{"$f":"N19-P19","v":0},{"$f":"O19-P19","v":0},{"$f":"(K19*J19)-(P19+R19)","v":0},{"$f":"H19*L19","v":0},{"$f":"J19*L19","v":0},{"$f":"U19*'F.EE.'!F4","v":0},{"$f":"T19-V19","v":0},{"$f":"U19-V19","v":0},{"$f":"W19+V19+Q19+P19-(H19*K19+H19*L19)","v":0},{"$f":"H19*M19","v":0},{"$f":"J19*M19","v":0},{"$f":"(AA19)-J19*M19","v":0},{"$f":"AA19*'F.EE.'!I4","v":0},{"$f":"'F.Dist.'!J5","v":0},{"$f":"(C19*AD19*M19)+Z19-AC19","v":0},{"$f":"(AA19-AC19)*(1-0.0067)","v":0},{"$f":"(AE19+W19+Q19)+(P19+V19+AC19)-(H19+AD19*C19*M19)","v":0},{"$f":"'F.Dist.'!K5","v":1},{"$f":"'F.Dist.'!L5","v":0},{"$f":"'F.Dist.'!M5","v":0},{"$f":"'F.Dist.'!O5","v":1},{"$f":"'F.Dist.'!P5","v":0},{"$f":"'F.Dist.'!Q5","v":0},{"$f":"AE19*AH19+W19*AK19","v":0},{"$f":"AF19*AH19+X19*AK19","v":0},{"$f":"AO19*'F.EE.'!L4","v":0},{"$f":"AO19*'F.EE.'!S4","v":0},{"$f":"AO19*'F.EE.'!T4","v":0},{"$f":"AO19*'F.EE.'!U4","v":0},{"$f":"AN19-AP19-AQ19*(28/44)-AR19-AS19*(14/46)","v":0},{"$f":"AO19-AP19-AQ19*(28/44)-AR19-AS19*(14/46)","v":0},{"$f":"(AT19+AP19+AR19+AQ19*28/44+AS19*14/46)-AN19","v":0},{"$f":"'F.Dist.'!S5","v":1},{"$f":"'F.Dist.'!T5","v":0},{"$f":"AT19*AW19+AE19*AI19+W19*AL19","v":0},{"$f":"AU19*AW19+AF19*AI19+X19*AL19","v":0},{"$f":"AZ19*'F.EE.'!O4","v":0},{"$f":"AY19-BA19","v":0},{"$f":"AZ19-BA19","v":0},{"$f":"BB19+Q19","v":0},{"$f":"BC19+R19","v":0},{"$f":"W19*AM19+AT19*AX19+AE19*AJ19","v":0},{"$f":"X19*AM19+AU19*AX19+AF19*AJ19","v":0},{"$f":"BA19+AP19+AC19+V19+P19","v":0},{"$f":"AQ19*28/44","v":0},{"$f":"AR19","v":0},{"$f":"AS19*14/46","v":0},{"$f":"SUM(BH19:BK19)","v":0},{"$f":"BH19*17/14","v":0},{"$f":"H19+(AD19*C19*M19)-(BF19+BL19+BD19)","v":0}]
["AVES CARNE","Gallinas reproductoras carne",{"$f":"E.Datos!E29","v":0},1,{"$f":"C20*D20","v":0},0.747,{"$f":"0.148411","v":0.14841099999999999},{"$f":"C20*F20","v":0},null,0,{"$f":"'F.Dist.'!E6","v":0},{"$f":"'F.Dist.'!F6","v":0},{"$f":"'F.Dist.'!G6","v":1},{"$f":"H20*K20","v":0},{"$f":"J20*K20","v":0},{"$f":"O20*'F.EE.'!C5","v":0},{"$f":"N20-P20","v":0},{"$f":"O20-P20","v":0},{"$f":"(K20*J20)-(P20+R20)","v":0},{"$f":"H20*L20","v":0},{"$f":"J20*L20","v":0},{"$f":"U20*'F.EE.'!F5","v":0},{"$f":"T20-V20","v":0},{"$f":"U20-V20","v":0},{"$f":"W20+V20+Q20+P20-(H20*K20+H20*L20)","v":0},{"$f":"H20*M20","v":0},{"$f":"J20*M20","v":0},0,{"$f":"AA20*'F.EE.'!I5","v":0},{"$f":"'F.Dist.'!J6","v":0},{"$f":"(C20*AD20*M20)+Z20-AC20","v":0},{"$f":"(AA20-AC20)*(1-0.0067)","v":0},{"$f":"(AE20+W20+Q20)+(P20+V20+AC20)-(H20+AD20*C20*M20)","v":0},{"$f":"'F.Dist.'!K6","v":1},{"$f":"'F.Dist.'!L6","v":0},{"$f":"'F.Dist.'!M6","v":0},{"$f":"'F.Dist.'!O6","v":1},{"$f":"'F.Dist.'!P6","v":0},{"$f":"'F.Dist.'!Q6","v":0},{"$f":"AE20*AH20+W20*AK20","v":0},0,{"$f":"AO20*'F.EE.'!L5","v":0},{"$f":"AO20*'F.EE.'!S5","v":0},{"$f":"AO20*'F.EE.'!T5","v":0},{"$f":"AO20*'F.EE.'!U5","v":0},{"$f":"AN20-AP20-AQ20*(28/44)-AR20-AS20*(14/46)","v":0},{"$f":"AO20-AP20-AQ20*(28/44)-AR20-AS20*(14/46)","v":0},{"$f":"(AT20+AP20+AR20+AQ20*28/44+AS20*14/46)-AN20","v":0},{"$f":"'F.Dist.'!S6","v":1},{"$f":"'F.Dist.'!T6","v":0},{"$f":"AT20*AW20+AE20*AI20+W20*AL20","v":0},0,{"$f":"AZ20*'F.EE.'!O5","v":0},{"$f":"AY20-BA20","v":0},{"$f":"AZ20-BA20","v":0},{"$f":"BB20+Q20","v":0},0,0,0,0,0,0,0,{"$f":"SUM(BH20:BK20)","v":0},{"$f":"BH20*17/14","v":0},{"$f":"H20+(AD20*C20*M20)-(BF20+BL20+BD20)","v":0}]
["TOTALS",null,{"$f":"SUM(C18:C20)","v":0},null,{"$f":"SUM(E18:E20)","v":0},null,null,{"$f":"SUM(H18:H20)","v":0},null,{"$f":"SUM(J18:J20)","v":0},null,null,null,{"$f":"SUM(N18:N20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AC18:AC20)","v":0},{"$f":"(C18*AD18+C19*AD19+C20*AD20)/C21","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AE18:AE20)","v":0},0,{"$f":"SUM(AG18:AG20)","v":0},null,null,null,null,null,null,{"$f":"SUM(AN18:AN20)","v":0},0,0,0,0,0,0,0,null,null,null,{"$f":"SUM(AY18:AY20)","v":0},0,0,0,0,{"$f":"SUM(BD18:BD20)","v":0},{"$f":"SUM(BE18:BE20)","v":0},0,0,{"$f":"SUM(BH18:BH20)","v":0},{"$f":"SUM(BI18:BI20)","v":0},0,0,{"$f":"SUM(BH21:BK21)","v":0},{"$f":"BH21*17/14","v":0},{"$f":"SUM(BN18:BN20)","v":0}]

{"sheet":"F.EE.","index":9,"n_rows":25,"n_cols":21,"rows_kept":25,"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","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 CARNE","Broilers",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$11:$H$25,7,FALSE)","v":1},{"$f":"I3*J3","v":0.28000000000000003},0.17,{"$f":"VLOOKUP(E.Datos!R25,'F.EE.'!$K$11:$O$12,5,FALSE)","v":1},{"$f":"L3*M3","v":0.17},0.66,{"$f":"VLOOKUP(E.Datos!X25,'F.EE.'!$K$20:$O$24,5,FALSE)","v":1},{"$f":"O3*P3","v":0.66},null,2E-3,0.3,0.01]
["AVES CARNE","Pollitas de recría carne",0.32,1,{"$f":"C4*D4","v":0.32},{"$f":"I4","v":0.28000000000000003},1,{"$f":"F4*G4","v":0.28000000000000003},0.28000000000000003,{"$f":"VLOOKUP(E.Datos!J27,'F.EE.'!$B$11:$H$25,7,FALSE)","v":1},{"$f":"I4*J4","v":0.28000000000000003},0.17,{"$f":"VLOOKUP(E.Datos!R27,'F.EE.'!$K$11:$O$12,5,FALSE)","v":1},{"$f":"L4*M4","v":0.17},0.66,{"$f":"VLOOKUP(E.Datos!X27,'F.EE.'!$K$20:$O$24,5,FALSE)","v":1},{"$f":"O4*P4","v":0.66},null,2E-3,0.3,0.01]
["AVES CARNE","Gallinas reproductoras carne",0.32,1,0.32,{"$f":"I5","v":0.28000000000000003},1,0.28000000000000003,0.28000000000000003,{"$f":"VLOOKUP(E.Datos!J29,'F.EE.'!$B$11:$H$25,7,FALSE)","v":1},{"$f":"I5*J5","v":0.28000000000000003},0.17,{"$f":"VLOOKUP(E.Datos!R29,'F.EE.'!$K$11:$O$12,5,FALSE)","v":1},0.17,0.66,{"$f":"VLOOKUP(E.Datos!X29,'F.EE.'!$K$20:$O$24,5,FALSE)","v":1},0.66,null,2E-3,0.3,0.01]
[]
[]
["NH3 REDUCTIONS AND EMISSION FACTORS ACCORDING TO MANAGEMENT TECHNIQUES",null,null,null,null,"BUILD",null,null,null,"NH3 REDUCTIONS AND EMISSION FACTORS ACCORDING TO MANAGEMENT TECHNIQUES",null,null,null,null,"STORE"]
[]
["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","Sistema de jaulas no acondicionadas, estiércol no ventilado debajo",null,null,null,null,0,{"$f":"1-G11","v":1},null,"Opción 0","Almacén abierto, sin cubrir",null,null,0,{"$f":"1-N11","v":1}]
["Opción A","Sistema de jaulas no acondicionadas, estiércol debajo y secado",null,null,null,null,0.3,0.7,null,"Opción A","Almacén cubierto con materiales rígidos o flexibles",null,null,0.8,{"$f":"1-N12","v":0.19999999999999996}]
["Opción B","Sistema de jaulas no acondicionadas, estiércol evacuado inmediatamente con cinta a almacén cerrado",null,null,null,null,0.65,0.35]
["Opción C","Sistema de 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","Sistema de jaulas acondicionadas con cinta de secado y retirada de estiércol 2 veces a la semana",null,null,null,null,0.85,0.15000000000000002]
["Opción E","Sistema de jaulas acondicionadas con cinta de 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","Sistema de 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",null,null,null,null,"APPLIED"]
["Opción G","Suelo con yacija profunda",null,null,null,null,0,1]
["Opción H","Suelo con yacija profunda, ventilación natural y sistema de bebederos sin pérdidas de agua.",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-N20","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,{"$f":"1-N21","v":9.9999999999999978E-2}]
["Opción K","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,{"$f":"1-N22","v":0.30000000000000004}]
["Opción L","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,{"$f":"1-N23","v":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,{"$f":"1-N24","v":1}]
["Opción N","Sistemas depuración de aire",null,null,null,null,0.8,0.19999999999999996]

{"sheet":"F.Dist.","index":10,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,7,0,8],[1,7,2,7],[1,8,2,8],[0,10,0,12],[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],[0,14,0,17],[0,18,0,19],[1,17,2,17],[0,9,1,9],[1,13,2,13]]}
["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/PP","NO",null,null,null,null,null,"kg N / PP"]
["AVES CARNE","Broilers",{"$f":"Calculos!I4","v":0},{"$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/Calculos!E4)*J19)","v":0},{"$f":"IF(E.Datos!N25=Instrucciones!I48,1,0)","v":0},{"$f":"IF(E.Datos!N25=Instrucciones!I49,1,0)","v":0},{"$f":"IF(E.Datos!N25=Instrucciones!I50,1,0)","v":1},{"$f":"SUM(K4:M4)","v":1},{"$f":"IF(E.Datos!P25=Instrucciones!I48,1,0)","v":0},{"$f":"IF(E.Datos!P25=Instrucciones!I49,1,0)","v":0},{"$f":"IF(E.Datos!P25=Instrucciones!I50,1,0)","v":1},{"$f":"SUM(O4:Q4)","v":1},{"$f":"IF(E.Datos!V25=Instrucciones!I49,1,0)","v":0},{"$f":"IF(E.Datos!V25=Instrucciones!I50,1,0)","v":1}]
["AVES CARNE","Pollitas de recría carne",{"$f":"Calculos!I5","v":0},{"$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/Calculos!E5)*J19)","v":0},{"$f":"IF(E.Datos!N27=Instrucciones!I48,1,0)","v":1},{"$f":"IF(E.Datos!N27=Instrucciones!I49,1,0)","v":0},{"$f":"IF(E.Datos!N27=Instrucciones!I50,1,0)","v":0},{"$f":"SUM(K5:M5)","v":1},{"$f":"IF(E.Datos!P27=Instrucciones!I48,1,0)","v":1},{"$f":"IF(E.Datos!P27=Instrucciones!I49,1,0)","v":0},{"$f":"IF(E.Datos!P27=Instrucciones!I50,1,0)","v":0},{"$f":"SUM(O5:Q5)","v":1},{"$f":"IF(E.Datos!V27=Instrucciones!I49,1,0)","v":1},{"$f":"IF(E.Datos!V27=Instrucciones!I50,1,0)","v":0}]
["AVES CARNE","Gallinas reproductoras carne",{"$f":"Calculos!I6","v":0},{"$f":"E.Datos!H29","v":"SÍ"},0,0,1,1,0,{"$f":"IF(E.Datos!E29=0,0,(E.Datos!L29/Calculos!E6)*J19)","v":0},{"$f":"IF(E.Datos!N29=Instrucciones!I48,1,0)","v":1},{"$f":"IF(E.Datos!N29=Instrucciones!I49,1,0)","v":0},{"$f":"IF(E.Datos!N29=Instrucciones!I50,1,0)","v":0},{"$f":"SUM(K6:M6)","v":1},{"$f":"IF(E.Datos!P29=Instrucciones!I48,1,0)","v":1},{"$f":"IF(E.Datos!P29=Instrucciones!I49,1,0)","v":0},{"$f":"IF(E.Datos!P29=Instrucciones!I50,1,0)","v":0},{"$f":"SUM(O6:Q6)","v":1},{"$f":"IF(E.Datos!V29=Instrucciones!I49,1,0)","v":1},{"$f":"IF(E.Datos!V29=Instrucciones!I50,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":"H11/2.3","v":14.347826086956523},{"$f":"I11/2.3","v":18.260869565217394},{"$f":"AVERAGE(H12:I12)","v":16.304347826086961}]
[null,null,null,"Superficie (m2/pollo)",null,null,null,{"$f":"H12^-1","v":6.9696969696969688E-2},{"$f":"I12^-1","v":5.4761904761904755E-2},{"$f":"AVERAGE(H13:I13)","v":6.2229437229437218E-2}]
[null,null,null,"Superficie (cm2/pollo)",null,null,null,{"$f":"H13*10000","v":696.96969696969688},{"$f":"I13*10000","v":547.61904761904759},{"$f":"AVERAGE(H14:I14)","v":622.29437229437224}]
[null,null,null,"Volumen (cm3/pollo)",null,null,null,{"$f":"4*H14","v":2787.8787878787875},{"$f":"4*I14","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":"H17/1000000","v":1.25E-4},{"$f":"I17/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"]