{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Mode d'emploi","Calcul P170","Complément vaches laitières"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":2,"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":"Mode d'emploi","index":0,"n_rows":127,"n_cols":2,"rows_kept":127,"cut":false,"hidden":false,"merged":[[1,1,1,10],[2,1,2,10]]}
[]
[null,"Calcul de la pression en azote d'origine animale"]
[null,"Respect du plafond des 170 kgN/ha de SAU"]
[]
[]
[]
[null,"Mode d'emploi"]
[]
[null,"Le fichier contient des macro devant être activées pour bénéficier de certaines fonctionnalités (mais non indispensable)"]
[null,"Seules les cases jaunes sont modifiables et à compléter"]
[null,"Référentiel conforme aux arrêtés du 19 décembre 2011 / 11 octobre 2016 / 27 avril 2017"]
[]
[null,"Descriptif du cheptel de l'exploitation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Complément vaches laitières"]
[]
[null,"Pour les vaches laitières, la référence unitaire (kgN produit par vache) est fonction du niveau de production et de la durée de pâturage."]
[null,"Il est nécessaire de renseigner ces informations dans l'onglet \"Complément vaches laitières\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Importation et/ou exportation de produits organiques d'origine animale"]
[]
[null,"Les produits organiques d'origine animale épandus sur l'exploitation (effluents d'élevage ou produits normalisés contenant des effluents d'élevages) ou exportés chez des tiers doivent être saisis."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pression en azote d'origine animale sur la SAU de l'exploitation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mise en page pour impression"]
[]
[null,"Fonctionnalité disponible uniquement si les macros sont activées"]

{"sheet":"Calcul P170","index":1,"n_rows":239,"n_cols":12,"rows_kept":239,"cut":false,"hidden":false,"merged":[[238,1,238,10],[1,1,1,10],[2,1,2,10],[213,1,213,7],[214,1,214,7],[215,1,215,7],[216,1,216,7],[217,1,217,7],[218,1,218,9],[223,1,223,7],[224,1,224,7],[225,1,225,7],[226,1,226,7],[227,1,227,7],[228,1,228,9],[206,1,206,6],[207,1,207,6],[208,1,208,6],[209,1,209,9],[193,1,193,6],[194,1,194,6],[195,1,195,6],[196,1,196,6],[197,1,197,6],[205,1,205,9],[186,1,186,6],[187,1,187,6],[188,1,188,6],[189,1,189,6],[190,1,190,6],[192,1,192,6],[178,1,178,6],[180,1,180,6],[182,1,182,6],[183,1,183,6],[184,1,184,6],[185,1,185,6],[191,1,191,9],[198,1,198,6],[199,1,199,6],[200,1,200,9],[201,1,201,6],[202,1,202,6],[203,1,203,6],[204,1,204,6],[171,1,171,6],[173,1,173,6],[174,1,174,6],[175,1,175,6],[176,1,176,6],[177,1,177,6],[172,1,172,9],[179,1,179,9],[181,1,181,9],[166,1,166,9],[170,1,170,9],[165,1,165,6],[167,1,167,6],[168,1,168,6],[169,1,169,6],[148,1,148,6],[149,1,149,6],[150,1,150,6],[151,1,151,6],[152,1,152,6],[153,1,153,6],[159,1,159,6],[160,1,160,6],[161,1,161,6],[162,1,162,6],[163,1,163,6],[164,1,164,6],[155,1,155,6],[156,1,156,6],[157,1,157,6],[158,1,158,9],[140,1,140,6],[141,1,141,6],[143,1,143,6],[145,1,145,6],[146,1,146,6],[147,1,147,6],[133,1,133,6],[134,1,134,6],[135,1,135,6],[136,1,136,6],[138,1,138,6],[139,1,139,6],[125,1,125,6],[127,1,127,6],[128,1,128,6],[129,1,129,6],[130,1,130,6],[131,1,131,6],[154,1,154,9],[111,1,111,6],[112,1,112,6],[113,1,113,6],[114,1,114,6],[115,1,115,6],[117,1,117,6],[118,1,118,6],[119,1,119,6],[120,1,120,6],[116,1,116,9],[126,1,126,9],[132,1,132,9],[137,1,137,9],[142,1,142,9],[144,1,144,9],[121,1,121,6],[122,1,122,6],[123,1,123,6],[124,1,124,6],[107,1,107,6],[108,1,108,6],[109,1,109,9],[110,1,110,9],[103,1,103,6],[104,1,104,6],[105,1,105,6],[106,1,106,6],[100,1,100,6],[101,1,101,6],[93,1,93,6],[94,1,94,6],[95,1,95,9],[102,1,102,9],[96,1,96,6],[97,1,97,6],[98,1,98,6],[99,1,99,6],[85,1,85,6],[86,1,86,6],[87,1,87,6],[88,1,88,6],[89,1,89,6],[90,1,90,6],[91,1,91,6],[92,1,92,6],[82,1,82,6],[83,1,83,6],[84,1,84,9],[76,1,76,6],[77,1,77,6],[78,1,78,6],[79,1,79,6],[80,1,80,6],[81,1,81,6],[69,1,69,6],[70,1,70,6],[71,1,71,6],[72,1,72,6],[74,1,74,6],[75,1,75,6],[73,1,73,9],[60,1,60,6],[61,1,61,6],[62,1,62,6],[63,1,63,6],[65,1,65,6],[66,1,66,6],[67,1,67,6],[68,1,68,6],[54,1,54,6],[55,1,55,9],[64,1,64,9],[56,1,56,6],[57,1,57,6],[58,1,58,6],[59,1,59,6],[48,1,48,6],[49,1,49,6],[50,1,50,6],[51,1,51,6],[52,1,52,6],[53,1,53,6],[42,1,42,6],[43,1,43,9],[44,1,44,9],[45,1,45,6],[46,1,46,6],[47,1,47,6],[36,1,36,6],[37,1,37,6],[38,1,38,9],[39,1,39,6],[40,1,40,6],[41,1,41,6],[30,1,30,6],[31,1,31,6],[32,1,32,9],[33,1,33,6],[34,1,34,6],[35,1,35,6],[24,1,24,6],[25,1,25,9],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[16,1,16,6],[17,1,17,6],[8,1,8,6],[9,1,9,9],[10,1,10,6],[11,1,11,6]]}
[]
[null,"Calcul de la pression en azote d'origine animale"]
[null,"Respect du plafond des 170 kgN/ha de SAU"]
[]
[]
[]
[null,"Descriptif du cheptel de l'exploitation"]
[]
[null,"Catégorie d'animaux",null,null,null,null,null,"Nombre d'animaux","Production de référence (kgN/ animal présent ou produit)","Durée de présence sur l'exploitation (en mois) /\nPV sup. pour les porcs charcutiers\n(en kg)","Quantité d'azote produit annuellement"]
[null,"BOVINS",null,null,null,null,null,null,null,null,{"$f":"SUM(K11:K25)","v":0}]
[null,"Vache laitière",null,null,null,null,null,null,{"$f":"'Complément vaches laitières'!$M$28","v":0},12,{"$f":"H11*I11*J11/12","v":0},{"$f":"IF(H11=\"\",\"\",\"=> remplir la feuille \"\"Complément vaches laitières\"\"\")","v":""}]
[null,"Vache allaitante sans son veau",null,null,null,null,null,null,68,12,{"$f":"H12*I12*J12/12","v":0}]
[null,"Vache de réforme",null,null,null,null,null,null,40.5,12,0]
[null,"Femelle > 2 ans",null,null,null,null,null,null,54,12,0]
[null,"Femelle 1-2 ans / croissance",null,null,null,null,null,null,42.5,12,0]
[null,"Femelle 1-2 ans / engraissement",null,null,null,null,null,null,40.5,12,0]
[null,"Femelle < 1 an",null,null,null,null,null,null,25,12,0]
[null,"Mâle > 2 ans / engraissement",null,null,null,null,null,null,73,12,0]
[null,"Mâle 1-2 ans / engraissement",null,null,null,null,null,null,40.5,12,0]
[null,"Mâle 0-1 an / engraissement",null,null,null,null,null,null,20,12,0]
[null,"Broutard < 1 an / engraissement",null,null,null,null,null,null,27,12,0]
[null,"Mâle > 2 ans / croissance (taureau > 2 ans)",null,null,null,null,null,null,73,12,0]
[null,"Mâle 1-2 ans / croissance (taureau 1-2 ans)",null,null,null,null,null,null,42.5,12,0]
[null,"Mâle 0-1 an / croissance (taureau 0-1 an)",null,null,null,null,null,null,25,12,0]
[null,"Place veau de boucherie",null,null,null,null,null,null,6.3,null,{"$f":"H25*I25","v":0}]
[null,"EQUINS",null,null,null,null,null,null,null,null,{"$f":"SUM(K27:K32)","v":0}]
[null,"Jument de trait suitée",null,null,null,null,null,null,66.5,12,{"$f":"H27*I27*J27/12","v":0}]
[null,"Poulain de trait",null,null,null,null,null,null,50,12,0]
[null,"Jument sport et loisir suitée",null,null,null,null,null,null,45,12,0]
[null,"Cheval sport et loisir au travail",null,null,null,null,null,null,39,12,0]
[null,"Poney AB (200kg)",null,null,null,null,null,null,23,12,0]
[null,"Poney CD (400kg)",null,null,null,null,null,null,35,12,0]
[null,"OVINS",null,null,null,null,null,null,null,null,{"$f":"SUM(K34:K38)","v":0}]
[null,"Brebis viande",null,null,null,null,null,null,11,12,{"$f":"H34*I34*J34/12","v":0}]
[null,"Brebis laitière",null,null,null,null,null,null,12,12,0]
[null,"Bélier",null,null,null,null,null,null,11,12,0]
[null,"Agnelle",null,null,null,null,null,null,6,12,0]
[null,"Agneau engraissé produit",null,null,null,null,null,null,0.8,null,{"$f":"H38*I38","v":0}]
[null,"CAPRINS",null,null,null,null,null,null,null,null,{"$f":"SUM(K40:K43)","v":0}]
[null,"Chèvre",null,null,null,null,null,null,11,12,{"$f":"H40*I40*J40/12","v":0}]
[null,"Bouc",null,null,null,null,null,null,11,12,0]
[null,"Chevrette",null,null,null,null,null,null,5,12,0]
[null,"Chevreau engraissé produit",null,null,null,null,null,null,7.0000000000000007E-2,null,{"$f":"H43*I43","v":0}]
[null,"PORCINS",null,null,null,null,null,null,null,null,{"$f":"K45+K56+K65+K74+K85+K96+K103","v":0}]
[null,"PORCINS sur caillebotis seul (lisier standard)",null,null,null,null,null,null,null,null,{"$f":"SUM(K46:K55)","v":0}]
[null,"Truie reproductrice/ Alimentation standard",null,null,null,null,null,null,17.399999999999999,null,{"$f":"H46*I46","v":0}]
[null,"Truie non productive / Alimentation standard",null,null,null,null,null,null,9.5,null,{"$f":"H47*I47","v":0}]
[null,"Porcelet en post-sevrage produit / Alimentation standard",null,null,null,null,null,null,0.44,null,0]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation standard",null,null,null,null,null,null,3.17,null,0]
[null,"Truie reproductrice/ Alimentation biphase",null,null,null,null,null,null,14.3,null,0,"Teneur maximale de l'aliment en protéine: Gestation 14%; Lactation: 16,5%"]
[null,"Truie non productive / Alimentation biphase",null,null,null,null,null,null,7.8,null,0,"Teneur maximale de l'aliment en protéine: Gestation 14%; Lactation: 16,5%"]
[null,"Porcelet en post-sevrage produit / Alimentation biphase",null,null,null,null,null,null,0.39,null,0,"Teneur maximale de l'aliment en protéine: 1er âge: 20%; 2ème âge: 18%"]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation biphase",null,null,null,null,null,null,2.6,null,0,"Teneur maximale de l'aliment en protéine: Croissance 16%; Finition 15% (60% d'aliment de finition)"]
[null,"Porc charcutier produit / Alimentation standard - correction si poids > 118 kg",null,null,null,null,null,null,3.5999999999999997E-2,null,{"$f":"H54*I54*J54","v":0}]
[null,"Porc charcutier produit / Alimentation biphase - correction si poids > 118 kg",null,null,null,null,null,null,0.03,null,{"$f":"H55*I55*J55","v":0}]
[null,"PORCINS sur caillebotis et raclage en V, SANS compostage de la phase solide",null,null,null,null,null,null,null,null,{"$f":"K57+K60+K63+K64","v":0}]
[null,"Porc à l'engraisssement produit / Alimentation standard",null,null,null,null,null,null,3.38,null,{"$f":"H57*I57","v":0}]
[null,"dont phase solide",null,null,null,null,null,null,1.92,null,0]
[null,"dont phase liquide",null,null,null,null,null,null,1.46,null,0]
[null,"Porc à l'engraisssement produit / Alimentation biphase",null,null,null,null,null,null,2.76,null,0,"Teneur maximale de l'aliment en protéine: Croissance 16%; Finition 15% (60% d'aliment de finition)"]
[null,"dont phase solide",null,null,null,null,null,null,1.57,null,0]
[null,"dont phase liquide",null,null,null,null,null,null,1.19,null,0]
[null,"Porc charcutier produit / Alimentation standard - correction si poids > 118 kg",null,null,null,null,null,null,3.9E-2,null,{"$f":"H63*I63*J63","v":0}]
[null,"Porc charcutier produit / Alimentation biphase - correction si poids > 118 kg",null,null,null,null,null,null,3.2000000000000001E-2,null,{"$f":"H64*I64*J64","v":0}]
[null,"PORCINS sur caillebotis et raclage en V, AVEC compostage de la phase solide",null,null,null,null,null,null,null,null,{"$f":"K66+K69+K72+K73","v":0}]
[null,"Porc à l'engraisssement produit / Alimentation standard",null,null,null,null,null,null,2.9,null,{"$f":"H66*I66","v":0}]
[null,"dont phase solide",null,null,null,null,null,null,1.44,null,0]
[null,"dont phase liquide",null,null,null,null,null,null,1.46,null,0]
[null,"Porc à l'engraisssement produit / Alimentation biphase",null,null,null,null,null,null,2.37,null,0,"Teneur maximale de l'aliment en protéine: Croissance 16%; Finition 15% (60% d'aliment de finition)"]
[null,"dont phase solide",null,null,null,null,null,null,1.18,null,0]
[null,"dont phase liquide",null,null,null,null,null,null,1.19,null,0]
[null,"Porc charcutier produit / Alimentation standard - correction si poids > 118 kg",null,null,null,null,null,null,3.3000000000000002E-2,null,{"$f":"H72*I72*J72","v":0}]
[null,"Porc charcutier produit / Alimentation biphase - correction si poids > 118 kg",null,null,null,null,null,null,2.7E-2,null,{"$f":"H73*I73*J73","v":0}]
[null,"PORCINS sur litière de paille accumulée, SANS compostage de la phase solide",null,null,null,null,null,null,null,null,{"$f":"SUM(K75:K84)","v":0}]
[null,"Truie reproductrice/ Alimentation standard",null,null,null,null,null,null,14.4,null,{"$f":"H75*I75","v":0}]
[null,"Truie non productive / Alimentation standard",null,null,null,null,null,null,6.7,null,0]
[null,"Porcelet en post-sevrage produit / Alimentation standard",null,null,null,null,null,null,0.31,null,0]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation standard",null,null,null,null,null,null,2.23,null,0]
[null,"Truie reproductrice/ Alimentation biphase",null,null,null,null,null,null,12.6,null,0,"Teneur maximale de l'aliment en protéine: Gestation 14%; Lactation: 16,5%"]
[null,"Truie non productive / Alimentation biphase",null,null,null,null,null,null,5.6,null,0,"Teneur maximale de l'aliment en protéine: Gestation 14%; Lactation: 16,5%"]
[null,"Porcelet en post-sevrage produit / Alimentation biphase",null,null,null,null,null,null,0.28999999999999998,null,0,"Teneur maximale de l'aliment en protéine: 1er âge: 20%; 2ème âge: 18%"]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation biphase",null,null,null,null,null,null,1.88,null,0,"Teneur maximale de l'aliment en protéine: Croissance 16%; Finition 15% (60% d'aliment de finition)"]
[null,"Porc charcutier produit / Alimentation standard - correction si poids > 118 kg",null,null,null,null,null,null,2.5999999999999999E-2,null,{"$f":"H83*I83*J83","v":0}]
[null,"Porc charcutier produit / Alimentation biphase - correction si poids > 118 kg",null,null,null,null,null,null,2.1999999999999999E-2,null,{"$f":"H84*I84*J84","v":0}]
[null,"PORCINS sur litière de paille accumulée, AVEC compostage de la phase solide",null,null,null,null,null,null,null,null,{"$f":"SUM(K86:K95)","v":0}]
[null,"Truie reproductrice/ Alimentation standard",null,null,null,null,null,null,12.1,null,{"$f":"H86*I86","v":0}]
[null,"Truie non productive / Alimentation standard",null,null,null,null,null,null,4.9000000000000004,null,0]
[null,"Porcelet en post-sevrage produit / Alimentation standard",null,null,null,null,null,null,0.22,null,0]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation standard",null,null,null,null,null,null,1.62,null,0]
[null,"Truie reproductrice/ Alimentation biphase",null,null,null,null,null,null,10.7,null,0,"Teneur maximale de l'aliment en protéine: Gestation 14%; Lactation: 16,5%"]
[null,"Truie non productive / Alimentation biphase",null,null,null,null,null,null,4,null,0,"Teneur maximale de l'aliment en protéine: Gestation 14%; Lactation: 16,5%"]
[null,"Porcelet en post-sevrage produit / Alimentation biphase",null,null,null,null,null,null,0.2,null,0,"Teneur maximale de l'aliment en protéine: 1er âge: 20%; 2ème âge: 18%"]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation biphase",null,null,null,null,null,null,1.33,null,0,"Teneur maximale de l'aliment en protéine: Croissance 16%; Finition 15% (60% d'aliment de finition)"]
[null,"Porc charcutier produit / Alimentation standard - correction si poids > 118 kg",null,null,null,null,null,null,1.9E-2,null,{"$f":"H94*I94*J94","v":0}]
[null,"Porc charcutier produit / Alimentation biphase - correction si poids > 118 kg",null,null,null,null,null,null,1.4999999999999999E-2,null,{"$f":"H95*I95*J95","v":0}]
[null,"PORCINS sur litière de sciure accumulée SANS compostage de la phase solide",null,null,null,null,null,null,null,null,{"$f":"SUM(K97:K102)","v":0}]
[null,"Porcelet en post-sevrage produit / Alimentation standard",null,null,null,null,null,null,0.18,null,{"$f":"H97*I97","v":0}]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation standard",null,null,null,null,null,null,1.35,null,0]
[null,"Porcelet en post-sevrage produit / Alimentation biphase",null,null,null,null,null,null,0.17,null,0,"Teneur maximale de l'aliment en protéine: 1er âge: 20%; 2ème âge: 18%"]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation biphase",null,null,null,null,null,null,1.1100000000000001,null,0,"Teneur maximale de l'aliment en protéine: Croissance 16%; Finition 15% (60% d'aliment de finition)"]
[null,"Porc charcutier produit / Alimentation standard - correction si poids > 118 kg",null,null,null,null,null,null,1.4999999999999999E-2,null,{"$f":"H101*I101*J101","v":0}]
[null,"Porc charcutier produit / Alimentation biphase - correction si poids > 118 kg",null,null,null,null,null,null,1.2999999999999999E-2,null,{"$f":"H102*I102*J102","v":0}]
[null,"PORCINS sur litière de sciure accumulée AVEC compostage de la phase solide",null,null,null,null,null,null,null,null,{"$f":"SUM(K104:K109)","v":0}]
[null,"Porcelet en post-sevrage produit / Alimentation standard",null,null,null,null,null,null,0.17,null,{"$f":"H104*I104","v":0}]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation standard",null,null,null,null,null,null,1.21,null,0]
[null,"Porcelet en post-sevrage produit / Alimentation biphase",null,null,null,null,null,null,0.15,null,0,"Teneur maximale de l'aliment en protéine: 1er âge: 20%; 2ème âge: 18%"]
[null,"Porc à l'engraissement produit (31-118 kg) / Alimentation biphase",null,null,null,null,null,null,0.99,null,0,"Teneur maximale de l'aliment en protéine: Croissance 16%; Finition 15% (60% d'aliment de finition)"]
[null,"Porc charcutier produit / Alimentation standard - correction si poids > 118 kg",null,null,null,null,null,null,1.4E-2,null,{"$f":"H108*I108*J108","v":0}]
[null,"Porc charcutier produit / Alimentation biphase - correction si poids > 118 kg",null,null,null,null,null,null,1.0999999999999999E-2,null,{"$f":"H109*I109*J109","v":0}]
[null,"VOLAILLES (par animal produit)",null,null,null,null,null,null,null,null,{"$f":"K111+K117+K127+K133+K138+K143+K145+K155+K159+K167+K171+K173+K180+K182+K192+K201","v":0}]
[null,"CAILLE",null,null,null,null,null,null,null,null,{"$f":"SUM(K112:K116)","v":0}]
[null,"Caille future reproductrice (œufs et chair)",null,null,null,null,null,null,1.2E-2,null,{"$f":"H112*I112","v":0}]
[null,"Caille label",null,null,null,null,null,null,0.01,null,0]
[null,"Caille pondeuse (Total mâle et femelle)",null,null,null,null,null,null,7.0000000000000007E-2,null,0]
[null,"Caille pondeuse reproduction (Total mâle et femelle)",null,null,null,null,null,null,4.7E-2,null,0]
[null,"Caille standard",null,null,null,null,null,null,8.0000000000000002E-3,null,0]
[null,"CANARD",null,null,null,null,null,null,null,null,{"$f":"SUM(K118:K126)","v":0}]
[null,"Canard colvert (pour lâchage)",null,null,null,null,null,null,5.1999999999999998E-2,null,{"$f":"H118*I118","v":0}]
[null,"Canard colvert (pour tir)",null,null,null,null,null,null,0.11,null,0]
[null,"Canard colvert reproducteur (Total mâle et femelle)",null,null,null,null,null,null,0.47,null,0]
[null,"Canard de Barbarie (mixte)",null,null,null,null,null,null,9.4E-2,null,0]
[null,"Canard de Barbarie mâle",null,null,null,null,null,null,0.13200000000000001,null,0]
[null,"Canard Mulard gras",null,null,null,null,null,null,6.0999999999999999E-2,null,0]
[null,"Canard Mulard prêt à gaver (extérieur)",null,null,null,null,null,null,0.113,null,0]
[null,"Canard Mulard prêt à gaver (intérieur)",null,null,null,null,null,null,0.129,null,0]
[null,"Canard Pékin",null,null,null,null,null,null,0.06,null,0]
[null,"CANE",null,null,null,null,null,null,null,null,{"$f":"SUM(K128:K132)","v":0}]
[null,"Cane de Barbarie future reproductrice",null,null,null,null,null,null,0.17399999999999999,null,{"$f":"H128*I128","v":0}]
[null,"Cane de Barbarie reproductrice (Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.56399999999999995,null,0]
[null,"Cane Pékin future reproductrice",null,null,null,null,null,null,0.20699999999999999,null,0]
[null,"Cane Pékin (ponte; Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.56100000000000005,null,0]
[null,"Cane reproductrice (gras; Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.53300000000000003,null,0]
[null,"CANETTE",null,null,null,null,null,null,null,null,{"$f":"SUM(K134:K137)","v":0}]
[null,"Canette de Barbarie label  ",null,null,null,null,null,null,6.0999999999999999E-2,null,{"$f":"H134*I134","v":0}]
[null,"Canette de Barbarie standard",null,null,null,null,null,null,5.2999999999999999E-2,null,0]
[null,"Canette Mulard à rotir",null,null,null,null,null,null,0.108,null,0]
[null,"Canette Pékin",null,null,null,null,null,null,4.7E-2,null,0]
[null,"CHAPON",null,null,null,null,null,null,null,null,{"$f":"SUM(K139:K142)","v":0}]
[null,"Chapon de pintade label",null,null,null,null,null,null,0.123,null,{"$f":"H139*I139","v":0}]
[null,"Chapon label",null,null,null,null,null,null,0.193,null,0]
[null,"Chapon standard",null,null,null,null,null,null,0.20300000000000001,null,0]
[null,"Chapon mini label",null,null,null,null,null,null,0.14799999999999999,null,0]
[null,"COQUELET",null,null,null,null,null,null,null,null,{"$f":"SUM(K144)","v":0}]
[null,"Coquelet standard",null,null,null,null,null,null,1.2E-2,null,{"$f":"H144*I144","v":0}]
[null,"DINDE",null,null,null,null,null,null,null,null,{"$f":"SUM(K146:K154)","v":0}]
[null,"Dinde à rôtir biologique",null,null,null,null,null,null,9.0999999999999998E-2,null,{"$f":"H146*I146","v":0}]
[null,"Dinde à rôtir label",null,null,null,null,null,null,0.23899999999999999,null,0]
[null,"Dinde à rôtir standard",null,null,null,null,null,null,0.10299999999999999,null,0]
[null,"Dinde de découpe label femelle",null,null,null,null,null,null,0.193,null,0]
[null,"Dinde de découpe label mâle",null,null,null,null,null,null,0.33900000000000002,null,0]
[null,"Dinde lourde",null,null,null,null,null,null,0.28499999999999998,null,0]
[null,"Dinde médium",null,null,null,null,null,null,0.23699999999999999,null,0]
[null,"Dinde future reproductrice",null,null,null,null,null,null,0.47199999999999998,null,0]
[null,"Dinde reproductrice (Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.58399999999999996,null,0]
[null,"FAISAN",null,null,null,null,null,null,null,null,{"$f":"SUM(K156:K158)","v":0}]
[null,"Faisan (22 semaines)",null,null,null,null,null,null,6.2E-2,null,{"$f":"H156*I156","v":0}]
[null,"Faisan reproducteur (32 semaines)",null,null,null,null,null,null,8.7999999999999995E-2,null,0]
[null,"Faisan reproducteur (Total mâle et femelle)",null,null,null,null,null,null,0.13700000000000001,null,0]
[null,"OIE",null,null,null,null,null,null,null,null,{"$f":"SUM(K160:K166)","v":0}]
[null,"Oie à rôtir",null,null,null,null,null,null,0.45500000000000002,null,{"$f":"H160*I160","v":0}]
[null,"Oie grasse",null,null,null,null,null,null,0.112,null,0]
[null,"Oie prête à gaver",null,null,null,null,null,null,0.155,null,0]
[null,"Oie future reproductrice (chair)",null,null,null,null,null,null,0.56699999999999995,null,0]
[null,"Oie reproductrice (chair), par cycle de ponte (Total mâle et femelle)",null,null,null,null,null,null,0.625,null,0]
[null,"Oie future reproductrice (gras)",null,null,null,null,null,null,1.032,null,0]
[null,"Oie reproductrice (grasse; Total mâle et femelle)",null,null,null,null,null,null,0.77200000000000002,null,0]
[null,"PERDRIX",null,null,null,null,null,null,null,null,{"$f":"SUM(K168:K170)","v":0}]
[null,"Perdrix (15 semaines)",null,null,null,null,null,null,2.9000000000000001E-2,null,{"$f":"H168*I168","v":0}]
[null,"Perdrix future reproductrice (23 semaines)",null,null,null,null,null,null,3.5999999999999997E-2,null,0]
[null,"Perdrix reproductrice (Total mâle et femelle)",null,null,null,null,null,null,0.111,null,0]
[null,"PIGEON",null,null,null,null,null,null,null,null,{"$f":"SUM(K172)","v":0}]
[null,"Par couple",null,null,null,null,null,null,0.312,null,{"$f":"H172*I172","v":0}]
[null,"PINTADE",null,null,null,null,null,null,null,null,{"$f":"SUM(K174:K179)","v":0}]
[null,"Pintade biologique (bâtiments fixes)",null,null,null,null,null,null,6.8000000000000005E-2,null,{"$f":"H174*I174","v":0}]
[null,"Pintade biologique (cabanes mobiles)",null,null,null,null,null,null,5.6000000000000001E-2,null,0]
[null,"Pintade future reproductrice",null,null,null,null,null,null,5.0999999999999997E-2,null,0]
[null,"Pintade reproductrice (Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.20799999999999999,null,0]
[null,"Pintade label",null,null,null,null,null,null,6.8000000000000005E-2,null,0]
[null,"Pintade standard",null,null,null,null,null,null,4.2000000000000003E-2,null,0]
[null,"POULARDE",null,null,null,null,null,null,null,null,{"$f":"SUM(K181)","v":0}]
[null,"Poularde label",null,null,null,null,null,null,0.15,null,{"$f":"H181*I181","v":0}]
[null,"POULE",null,null,null,null,null,null,null,null,{"$f":"SUM(K183:K191)","v":0}]
[null,"Poule pondeuse (reproductrice chair; standard; Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.36199999999999999,null,{"$f":"H183*I183","v":0}]
[null,"Poule pondeuse (reproductrice chair, label; Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.50700000000000001,null,0]
[null,"Poule pondeuse (reproductrice ponte; Femelle, car mâle inclus dans la réf. femelle)",null,null,null,null,null,null,0.32400000000000001,null,0]
[null,"Poule pondeuse biologique (œufs)",null,null,null,null,null,null,0.36499999999999999,null,0]
[null,"Poule pondeuse label (œufs)",null,null,null,null,null,null,0.373,null,0]
[null,"Poule pondeuse plein air (œufs)",null,null,null,null,null,null,0.36499999999999999,null,0]
[null,"Poule pondeuse sol (œufs)",null,null,null,null,null,null,0.41299999999999998,null,0]
[null,"Poule pondeuse standard (œufs) - Cage, pré-séchage, hangar",null,null,null,null,null,null,0.436,null,0]
[null,"Poule pondeuse standard (œufs) - Cage, séchoir",null,null,null,null,null,null,0.46700000000000003,null,0]
[null,"POULET",null,null,null,null,null,null,null,null,{"$f":"SUM(K193:K200)","v":0}]
[null,"Poulet biologique (bâtiments fixes)",null,null,null,null,null,null,8.2000000000000003E-2,null,{"$f":"H193*I193","v":0}]
[null,"Poulet biologique (cabanes mobiles)",null,null,null,null,null,null,8.2000000000000003E-2,null,0]
[null,"Poulet label (bâtiments fixes)",null,null,null,null,null,null,6.6000000000000003E-2,null,0]
[null,"Poulet label (cabanes mobiles)",null,null,null,null,null,null,7.3999999999999996E-2,null,0]
[null,"Poulet standard",null,null,null,null,null,null,2.8000000000000001E-2,null,0]
[null,"Poulet standard certifié",null,null,null,null,null,null,4.4999999999999998E-2,null,0]
[null,"Poulet standard léger (export)",null,null,null,null,null,null,2.1000000000000001E-2,null,0]
[null,"Poulet standard lourd",null,null,null,null,null,null,3.9E-2,null,0]
[null,"POULETTE",null,null,null,null,null,null,null,null,{"$f":"SUM(K202:K205)","v":0}]
[null,"Future reproductrice (ponte)",null,null,null,null,null,null,9.1999999999999998E-2,null,{"$f":"H202*I202","v":0}]
[null,"Oeufs – label, bio et plein air",null,null,null,null,null,null,7.9000000000000001E-2,null,{"$f":"H203*I203","v":0}]
[null,"Oeufs – standard sol",null,null,null,null,null,null,8.2000000000000003E-2,null,0]
[null,"Oeufs – standard cage",null,null,null,null,null,null,7.6999999999999999E-2,null,0]
[null,"LAPINS",null,null,null,null,null,null,null,null,{"$f":"SUM(K207:K209)","v":0}]
[null,"Lapine et sa suite / élevage naisseur-engraisseur ",null,null,null,null,null,null,3.46,12,{"$f":"H207*I207*J207/12","v":0}]
[null,"Lapine et sa suite / élevage naisseur",null,null,null,null,null,null,1.04,12,0]
[null,"Lapin produit  / élevage engraisseur",null,null,null,null,null,null,4.8000000000000001E-2,null,{"$f":"H209*I209","v":0}]
[null,"TOTAL",null,null,null,null,null,null,null,null,{"$f":"K10+K26+K33+K39+K44+K110+K206","v":0}]
[]
[null,"Quantité d'azote d'origine animale importés sur l'exploitation (effluents d'élevage et produits normalisés)"]
[]
[null,"Produits organiques d'origine animale importés",null,null,null,null,null,null,"Teneur en azote du produit\n(kg/t ou m³)","Quantité épandue\n(t ou m³)","Quantité d'azote totale importée (kg)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I215*J215","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I216*J216","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I217*J217","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I218*J218","v":0}]
[null,"TOTAL",null,null,null,null,null,null,null,null,{"$f":"SUM(K215:K218)","v":0}]
[]
[]
[null,"Quantité d'azote d'origine animale exportée hors de l'exploitation"]
[]
[null,"Effluents d'élevages exportés (épandus ou transférés chez des tiers)",null,null,null,null,null,null,"Teneur en azote du produit\n(kg/t ou m³)","Quantité exportée\n(t ou m³)","quantité d'azote totale importée (kg)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I225*J225","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I226*J226","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I227*J227","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I228*J228","v":0}]
[null,"TOTAL",null,null,null,null,null,null,null,null,{"$f":"SUM(K225:K228)","v":0}]
[]
[]
[null,"Pression en azote d'origine animale sur la SAU de l'exploitation"]
[]
[null,"Quantité d'azote d'origine animale à gérer sur l'exploitation : ",null,null,null,null,{"$f":"K210+K219-K229","v":0},"kg"]
[null,"SAU de l'exploitation :",null,null,null,null,null,"ha"]
[]
[null,"Pression en azote d'origine animale sur la SAU de l'exploitation :",null,null,null,null,{"$f":"IF(G235=\"\",\"\",G234/G235)","v":""},"kgN/ha"]
[]
[null,{"$f":"IF(OR(G237<170,G237=\"\"),\"La quantité d'azote d'origine animale épandue annuellement sur l'exploitation est conforme au plafond de la Directive nitrates\",\"La quantité d'azote d'origine animale épandue annuellement sur l'exploitation dépasse le plafond de la Directive nitrates\")","v":"La quantité d'azote d'origine animale épandue annuellement sur l'exploitation est conforme au plafond de la Directive nitrates"}]

{"sheet":"Complément vaches laitières","index":2,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,2,35,4],[30,9,30,26],[30,2,31,8],[25,12,25,16],[1,2,1,26],[5,2,5,26],[2,2,2,26],[31,9,31,14],[31,21,31,26],[8,12,8,16],[9,12,9,16],[10,12,10,16],[16,11,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[36,9,36,14],[33,9,33,14],[34,9,34,14],[35,9,35,14],[33,5,33,8],[34,5,34,8],[35,5,35,8],[36,21,36,26],[33,21,33,26],[34,21,34,26],[35,21,35,26],[31,15,31,20],[36,15,36,20],[33,15,33,20],[34,15,34,20],[35,15,35,20],[16,30,20,30],[24,12,24,16],[27,12,27,16],[12,2,15,26],[17,1,20,1],[17,28,20,28],[22,3,22,26],[24,22,24,25],[16,19,16,20],[16,21,16,22],[16,23,16,24],[16,25,16,26],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10]]}
[]
[null,null,"Calcul de la pression en azote d'origine animale"]
[null,null,"Respect du plafond des 170 kgN/ha de SAU"]
[]
[]
[null,null,"Production unitaire d'azote des vaches laitières"]
[]
[]
[null,null,"Lait livré (y compris vente directe) :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"l/an"]
[null,null,"Nombre de vaches présentes dans l'année :",null,null,null,null,null,null,null,null,null,{"$f":"'Calcul P170'!H11","v":0},null,null,null,null,"VL"]
[null,null,"Production laitière de référence :",null,null,null,null,null,null,null,null,null,{"$f":"IF(M10=0,0,(M9/M10)/0.92)","v":0},null,null,null,null,"kg/VL"]
[]
[null,null,"Temps passé à l'exterieur des bâtiments : nombre de mois pendant lesquels les animaux sont dehors jour et nuit (traite non décomptée) + temps cumulé (en mois) passé à l'exterieur des bâtiments pendant les périodes où les animaux passent une partie du temps en bâtiment et une autre dehors (traite décomptée)"]
[]
[]
[]
[null,null,"nb h/j","J",null,"F",null,"M",null,"A",null,"M",null,"J",null,"J",null,"A",null,"S",null,"O",null,"N",null,"D"]
[null,"saisissez le nb d'heures par jour si <24h",24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cliquez pour cocher / décocher"]
[]
[]
[]
[null,null,null,{"$f":"IF(D18=\"x\",0.5,IF(D19=\"x\",($C$19/24)*0.5,IF(D20=\"x\",($C$20/24)*0.5,IF(D21=\"x\",($C$21/24)*0.5,0))))","v":0},{"$f":"IF(E18=\"x\",0.5,IF(E19=\"x\",($C$19/24)*0.5,IF(E20=\"x\",($C$20/24)*0.5,IF(E21=\"x\",($C$21/24)*0.5,0))))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"x = période passée à l'extérieur"]
[null,null,"Temps passé à l'exterieur des bâtiments"]
[null,null,"calendrier :",null,null,null,null,null,null,null,null,null,{"$f":"SUM(D22:AA22)","v":0},null,null,null,null,"mois/an"]
[null,null,"saisie libre :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mois/an"]
[]
[null,null,"Quantité d'azote produit par vache laitière :",null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M10=\"\",M9=\"\"),0,INDEX('Complément vaches laitières'!$J$34:$AA$36,MATCH(IF(M26=\"\",'Complément vaches laitières'!$M$25:$Q$25,M26),'Complément vaches laitières'!$AB$34:$AB$36,1),MATCH('Complément vaches laitières'!$M$11:$Q$11,'Complément vaches laitières'!$J$37:$AA$37,1)))","v":0},null,null,null,null,"kgN/an"]
[]
[]
[null,null,"Quantité d'azote produit par les vaches laitières",null,null,null,null,null,null,"Production laitière (kg lait / vache / an)"]
[null,null,null,null,null,null,null,null,null,"< 6 000",null,null,null,null,null,"6 000 à 8 000",null,null,null,null,null,"> 8 000"]
[]
[null,null,"Temps passé à l’extérieur",null,null,"< 4 mois",null,null,null,75,null,null,null,null,null,83,null,null,null,null,null,91,null,null,null,null,null,0]
[null,null,null,null,null,"4 à 7 mois",null,null,null,92,null,null,null,null,null,101,null,null,null,null,null,111,null,null,null,null,null,4]
[null,null,null,null,null,"> 7 mois",null,null,null,104,null,null,null,null,null,115,null,null,null,null,null,126,null,null,null,null,null,7.0000099999999996]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,6000,null,null,null,null,null,8001]