{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["BRSPorc","Menu","Elevage","Aliments","Stock_Début","Stock_Fin","Litières","Récapitulatif","Excrétion","Bilan Simplifié","Standard","Gra_N","Gra_P","Gra_K","Données","Cohérence","CheckList","Analyse","Imprimer","Feuil1"],"not_rendered":{"charts":13,"images":3,"macros":1,"external_links":0,"defined_names":42,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BRSPorc","index":0,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,3,4,7]]}
[]
[]
[null,null,null,null,null,"Bilan Réel Simplifié \"Porc\""]
[]
[null,null,null,"D'après le document du RMT Elevage et Environnement"]
[]
[null,null,null,null,null,"Evaluation des rejets d’azote - phosphore - "]
[null,null,null,null,null,"potassium - cuivre et zinc des porcs."]
[null,null,null,null,null,"Influence de l'alimentation, du mode de logement"]
[null,null,null,null,null,"et de la gestion des effluents (2016)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Le bilan simplifié a été développé par le CORPEN "]
[null,null,null,null,null,"à partir du modèle INRA de calcul des rejets (Réalisation J.Y. Dourmad )"]
[null,null,null,null,null,"Cette nouvelle version tient compte des mises-à-jour réalisées par le RMT"]
[null,null,null,null,null,"version 4.01 Avril 2018"]
[]
[]
[null,null,"Composition du groupe de travail"]
[]
[null,null,"   Jean-Yves Dourmad, INRA Agrocampus Ouest, UMR Pegase (animateur)"]
[null,null,"   Pascal Levasseur, IFIP-Institut du Porc (animateur)"]
[null,null,"   Marie-Line Daumer, Irstea, Rennes"]
[null,null,"   Mélynda Hassouna, INRA Agrocampus Ouest, UMR SAS "]
[null,null,"   Brigitte Landrain, Chambres d'Agricultures de Bretagne."]
[null,null,"   Nolwenn Lemaire, Union des Groupements de Producteurs de Viande de Bretagne."]
[null,null,"   Aurore Loussouarn, Chambres d'Agricultures de Bretagne."]
[null,null,"   Yvon Salaün, IFIP-Institut du Porc"]
[null,null,"   Sandrine Espagnol, IFIP-Institut du Porc, Animatrice du RMT Élevages et Environnement"]
[]
[]
[]
[null,null,null,null,null,"L'utilisation de cet outil ou des résultats qu'il produit est faite sous la responsabilité"]
[null,null,null,null,null,"de l'utilisateur, et ne saurait engager celle du RMT ou de l'INRA."]

{"sheet":"Menu","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,3,3,8],[9,3,9,8],[15,3,15,8],[21,3,21,8]]}
[]
[]
[]
[null,null,null,"Saisie des caractéristiques de l'élevage "]
[]
[]
[]
[]
[]
[null,null,null,"Affichage des résultats"]
[]
[]
[]
[]
[]
[null,null,null,"Imprimer un rapport"]
[]
[]
[]
[]
[]
[null,null,null,"Références - Contacts "]
[]
[null,null,null,null,null,"Rapport RMT Elevage et Environnement (2016)"]
[null,null,null,null,null,"Envoyer vos remarques sur cet outil"]

{"sheet":"Elevage","index":2,"n_rows":70,"n_cols":58,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Références","EARL Pemoc'h Gouez"]
[null,"de l'élevage","200 truies naisseur-engraisseur"]
[]
[]
[null,"PERIODE de BILAN"]
[]
[null,"Date début","2017-01-01",null,null,null,null,null,null,null,null,{"$f":"IF(E9>1900,E9-1900,E9)","v":0},{"$f":"C9","v":"2017-01-01"}]
[null,"Date fin",{"$f":"C9+C11-1","v":"2017-12-31"},null,null,null,null,null,null,null,null,{"$f":"IF(E10>1900,E10-1900,E10)","v":0},{"$f":"C10","v":"2017-12-31"}]
[null,"Durée",{"$f":"DATE(YEAR(C9)+1,MONTH(C9),DAY(C9))-DATE(YEAR(C9),MONTH(C9),DAY(C9))","v":365}]
[]
[null,"EFFLUENTS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Zone de calcul"]
[]
[]
[null,{"$f":"+L66","v":"100% LISIER (en % de N excrété)"}]
[]
[]
[null,"ANIMAUX - EFFECTIFS","Effectif","Effectif","PV moyen","PV moyen","%  sur","% raclage","% sur"]
[null,null,{"$f":"C9","v":"2017-01-01"},{"$f":"C10","v":"2017-12-31"},{"$f":"C9","v":"2017-01-01"},{"$f":"C10","v":"2017-12-31"},"litières"," en V","lisier",null,null,null,"TMP","N Deb","N Fin","P Deb","P Fin","K Deb","K Fin","Cu Deb","Cu Fin","Zn Deb","Zn Fin","Pds Deb","Pds Fin"]
[null,"Truies en production1",180,180,210,210,null,null,{"$f":"100-G23","v":100},null,null,"Truies",58,{"$f":"((EXP(-0.9559-0.0145*M23)*(0.96*E23)^(0.7417+0.0044*M23))/6.25*1000)*C23/1000","v":947.0116907784726},{"$f":"((EXP(-0.9559-0.0145*M23)*(0.96*F23)^(0.7417+0.0044*M23))/6.25*1000)*D23/1000","v":947.0116907784726},{"$f":"5.35*E23*C23/1000","v":202.23},{"$f":"(5.35*F23)*D23/1000","v":202.23},{"$f":"(-0.00345*E23^2+2.53338*E23)*C23/1000","v":68.375664},68.375664,{"$f":"(1.006*E23)*C23/1000000","v":3.8026799999999993E-2},{"$f":"(1.006*F23)*D23/1000000","v":3.8026799999999993E-2},{"$f":"21.8*E23*C23/1000000","v":0.82403999999999999},0.82403999999999999,{"$f":"C23*E23","v":37800},37800]
[null,"Jeunes truies2",20,20,130,130,null,null,{"$f":"100-G24","v":100},null,null,"Jeunes truies",58,{"$f":"((EXP(-0.9559-0.0145*M24)*(0.96*E24)^(0.7417+0.0044*M24))/6.25*1000)*C24/1000","v":65.235281973019084},{"$f":"((EXP(-0.9559-0.0145*M24)*(0.96*F24)^(0.7417+0.0044*M24))/6.25*1000)*D24/1000","v":65.235281973019084},{"$f":"5.35*E24*C24/1000","v":13.91},{"$f":"(5.35*F24)*D24/1000","v":13.91},5.4206880000000002,5.4206880000000002,{"$f":"(1.006*E24)*C24/1000000","v":2.6156E-3},{"$f":"(1.006*F24)*D24/1000000","v":2.6156E-3},5.6680000000000001E-2,5.6680000000000001E-2,2600,2600]
[null,"Verrats",2,2,250,250,null,null,{"$f":"100-G25","v":100},null,null,"Verrats",58,{"$f":"((EXP(-0.9559-0.0145*M25)*(0.96*E25)^(0.7417+0.0044*M25))/6.25*1000)*C25/1000","v":12.519840919628466},{"$f":"((EXP(-0.9559-0.0145*M25)*(0.96*F25)^(0.7417+0.0044*M25))/6.25*1000)*D25/1000","v":12.519840919628466},{"$f":"5.35*E25*C25/1000","v":2.6749999999999998},{"$f":"(5.35*F25)*D25/1000","v":2.6749999999999998},0.83544000000000007,0.83544000000000007,0,{"$f":"(1.006*F25)*D25/1000000","v":5.0299999999999997E-4},1.09E-2,1.09E-2,500,500]
[null,"Porcelets en post sevrage",800,800,15,15,null,null,{"$f":"100-G26","v":100},null,null,"Post-sevrés",{"$f":"IF(Y32<>0,Y32,56)","v":60.8},{"$f":"((EXP(-0.9559-0.0145*M26)*(0.96*E26)^(0.7417+0.0044*M26))/6.25*1000)*C26/1000","v":300.77134189042272},{"$f":"((EXP(-0.9559-0.0145*M26)*(0.96*F26)^(0.7417+0.0044*M26))/6.25*1000)*D26/1000","v":300.77134189042272},{"$f":"5.35*E26*C26/1000","v":64.2},{"$f":"(5.35*F26)*D26/1000","v":64.2},29.779560000000004,29.779560000000004,0,{"$f":"(1.006*F26)*D26/1000000","v":1.2071999999999999E-2},0.2616,0.2616,12000,12000]
[null,"Porcs en croissance/finition",1600,1600,73,73,null,null,{"$f":"100-G27-pcrv","v":100},null,null,"Porcs engrais",{"$f":"IF(Y32<>0,Y32,56)","v":60.8},{"$f":"((EXP(-0.9559-0.0145*M27)*(0.96*E27)^(0.7417+0.0044*M27))/6.25*1000)*C27/1000","v":2970.5326179617136},{"$f":"((EXP(-0.9559-0.0145*M27)*(0.96*F27)^(0.7417+0.0044*M27))/6.25*1000)*D27/1000","v":2970.5326179617136},{"$f":"5.35*E27*C27/1000","v":624.87999999999988},{"$f":"(5.35*F27)*D27/1000","v":624.87999999999988},266.48270400000001,266.48270400000001,0,{"$f":"(1.006*F27)*D27/1000000","v":0.1175008},2.5462400000000001,2.5462400000000001,116800,116800]
[null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(N23:N27)","v":4296.0707735232563},4296.0707735232563,907.89499999999987,907.89499999999987,370.89405600000003,370.89405600000003,4.0642399999999995E-2,0.17071819999999999,3.6994600000000002,3.6994600000000002,169700,169700]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(G27+H27)<=100","v":true}]
[null,"SORTIE D'ANIMAUX","Nombre","Poids vif","T.M.P.3","Poids"]
[null,null,null,"moyen, kg",null,"total, kg",null,null,null,null,null,null,"Pds Sorti","N Sorti","P Sorti","K Sorti","Cu Sorti","Zn Sorti","Pds Entré","N Entré","P entré","K entré","Cu entré","Zn entré","TMP"]
[null,"Porcelets sevrés",null,null,null,{"$f":"C32*D32","v":0},null,null,null,null,null,{"$f":"+B32","v":"Porcelets sevrés"},{"$f":"D32*C32","v":0},{"$f":"((EXP(-0.9559-0.0145*Y32)*(0.96*D32)^(0.7417+0.0044*Y32))/6.25*1000)*C32/1000","v":0},{"$f":"5.35*F32/1000","v":0},{"$f":"(-0.00345*D32^2+2.53338*D32)*C32/1000","v":0},{"$f":"(1.006*D32)*C32/1000000","v":0},{"$f":"21.8*D32*C32/1000000","v":0},{"$f":"C41*D41","v":0},{"$f":"((EXP(-0.9559-0.0145*Y32)*(0.96*D41)^(0.7417+0.0044*Y32))/6.25*1000)*C41/1000","v":0},{"$f":"(5.35*D41)*C41/1000","v":0},{"$f":"(-0.00345*D41^2+2.53338*D41)*C41/1000","v":0},{"$f":"(1.006*D41)*C41/1000000","v":0},{"$f":"21.8*D41*C41/1000000","v":0},{"$f":"IF(E32<>0,E32,Y35)","v":60.8}]
[null,"Porcelets \"de 25-35 kg\"",null,null,null,{"$f":"C33*D33","v":0},null,null,null,null,null,"Porcelets \"de 25-35 kg\"",{"$f":"D33*C33","v":0},{"$f":"((EXP(-0.9559-0.0145*Y33)*(0.96*D33)^(0.7417+0.0044*Y33))/6.25*1000)*C33/1000","v":0},{"$f":"5.35*F33/1000","v":0},{"$f":"(-0.00345*D33^2+2.53338*D33)*C33/1000","v":0},{"$f":"(1.006*D33)*C33/1000000","v":0},{"$f":"21.8*D33*C33/1000000","v":0},{"$f":"C42*D42","v":0},{"$f":"((EXP(-0.9559-0.0145*Y33)*(0.96*D42)^(0.7417+0.0044*Y33))/6.25*1000)*C42/1000","v":0},{"$f":"(5.35*D42)*C42/1000","v":0},{"$f":"(-0.00345*D42^2+2.53338*D42)*C42/1000","v":0},{"$f":"(1.006*D42)*C42/1000000","v":0},{"$f":"21.8*D42*C42/1000000","v":0},{"$f":"IF(E33<>0,E33,Y35)","v":60.8}]
[null,"Jeunes Reproducteurs4",null,null,null,{"$f":"C34*D34","v":0},null,null,null,null,null,"Jeunes Reproducteurs4",{"$f":"D34*C34","v":0},{"$f":"((EXP(-0.9559-0.0145*Y34)*(0.96*D34)^(0.7417+0.0044*Y34))/6.25*1000)*C34/1000","v":0},{"$f":"5.35*F34/1000","v":0},{"$f":"(-0.00345*D34^2+2.53338*D34)*C34/1000","v":0},{"$f":"(1.006*D34)*C34/1000000","v":0},{"$f":"21.8*D34*C34/1000000","v":0},{"$f":"C43*D43","v":11000},{"$f":"((EXP(-0.9559-0.0145*Y34)*(0.96*D43)^(0.7417+0.0044*Y34))/6.25*1000)*C43/1000","v":280.81866582975738},{"$f":"(5.35*D43)*C43/1000","v":58.85},{"$f":"(-0.00345*D43^2+2.53338*D43)*C43/1000","v":23.692679999999999},{"$f":"(1.006*D43)*C43/1000000","v":1.1065999999999999E-2},{"$f":"21.8*D43*C43/1000000","v":0.23980000000000001},{"$f":"IF(E34<>0,E34,Y35)","v":60.8}]
[null,"Porcs charcutiers",{"$f":"C23*28.5*0.975*0.97","v":4851.6975000000002},118,60.8,{"$f":"C35*D35","v":572500.30500000005},null,null,null,null,null,"Porcs charcutiers",{"$f":"D35*C35","v":572500.30500000005},{"$f":"((EXP(-0.9559-0.0145*Y35)*(0.96*D35)^(0.7417+0.0044*Y35))/6.25*1000)*C35/1000","v":14624.806223557727},{"$f":"5.35*F35/1000","v":3062.8766317500003},{"$f":"(-0.00345*D35^2+2.53338*D35)*C35/1000","v":1217.2959485154001},{"$f":"(1.006*D35)*C35/1000000","v":0.57593530683000005},{"$f":"21.8*D35*C35/1000000","v":12.480506649000001},"-","-","-","-","-","-",{"$f":"IF(E35<>0,E35,60)","v":60.8}]
[null,"Truies de réforme",100,240,null,{"$f":"C36*D36","v":24000},null,null,null,null,null,"Truies de réforme",{"$f":"D36*C36","v":24000},{"$f":"((EXP(-0.9559-0.0145*Y36)*(0.96*D36)^(0.7417+0.0044*Y36))/6.25*1000)*C36/1000","v":617.11831445339658},{"$f":"5.35*F36/1000","v":128.39999999999998},{"$f":"(-0.00345*D36^2+2.53338*D36)*C36/1000","v":40.929120000000005},{"$f":"(1.006*D36)*C36/1000000","v":2.4143999999999999E-2},{"$f":"21.8*D36*C36/1000000","v":0.5232},"-","-","-","-","-","-",{"$f":"IF(E35<>0,E35,60)","v":60.8}]
[null,"Équarissage et saisies",null,null,null,13854,null,null,null,null,null,"Équarissage et saisies",{"$f":"F37","v":13854},{"$f":"M37*0.16/6.25","v":354.66239999999999},{"$f":"5.35*M37/1000","v":74.118899999999996},{"$f":"(-0.00345*50^2+2.53338*50)*(M37/50)/1000","v":32.70763152},{"$f":"(1.006*50)*(F37/50)/1000000","v":1.3937123999999999E-2},{"$f":"21.8*50*(F37/50)/1000000","v":0.30201719999999999},"-","-","-","-","-","-",{"$f":"IF(E35<>0,E35,60)","v":60.8}]
[null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(M32:M37)","v":610354.30500000005},15596.586938011123,3265.3955317500004,1290.9327000354001,0.61401643083000013,13.305723849,{"$f":"SUM(S32:S34)","v":11000},280.81866582975738,58.85,23.692679999999999,1.1065999999999999E-2,0.23980000000000001]
[null," ACHATS D'ANIMAUX","Nombre","Poids vif"]
[null,null,null,"kg"]
[null,"Porcelets sevrés"]
[null,"Porcelets \"de 25-35 kg\"",null,null,null,null,null,null,null,{"$f":"J43","v":1}]
[null,"Cochettes et verrats",100,110,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,{"$f":"J43","v":1}]
[null,"1Entre la première IA fécondante et la réforme",null,null,null,null,null,null,null,null,{"$f":"J43","v":1},null,"Bâtiment","Reste"]
[null,"2Cochettes jusque la première IA fécondante",null,null,null,null,null,null,null,null,1,"Pas de litière",24,7]
[null,"3Teneur en maigre des pièces. Dans le cas d'une vente en vif donner la teneur prévisible du TMP  vers 115 kg",null,null,null,null,null,null,null,null,2,"LITIERE (paille)",57,0]
[null,"4Dans le cas d'élevages de sélection ou de multiplication",null,null,null,null,null,null,null,{"$f":"J49","v":1},3,"LITIERE (paille) compostée ",57,30]
[null,null,null,null,null,null,null,null,null,1,4,"LITIERE (sciure) accumulée ",72,0]
[null,null,null,null,null,null,null,null,null,{"$f":"J49","v":1},5,"LITIERE (sciure) accumulée compostée ",72,10]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J49","v":1}]
[null,null,null,null,null,null,null,null,null,null,1,"Pas de raclage en V"]
[null,null,null,null,null,null,null,null,null,null,2,"Raclage en V sans compostage",14.5,7]
[null,null,null,null,null,null,null,null,null,null,3,"Raclage en V avec compostage",14.5,{"$f":"(0.3*0.568+0.07*(1-0.568))*100","v":20.064}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"sel_mode","v":1},{"$f":"VLOOKUP(Elevage!K45,mode,2)","v":"Pas de litière"},{"$f":"VLOOKUP(Elevage!K45,mode,3)","v":24},{"$f":"VLOOKUP(Elevage!K45,mode,4)","v":7}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K51","v":1},{"$f":"VLOOKUP(Elevage!$K$51,mode_rac,2)","v":"Pas de raclage en V"},{"$f":"VLOOKUP(Elevage!$K$51,mode_rac,3)","v":0},{"$f":"VLOOKUP(Elevage!$K$51,mode_rac,4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calcul excrétion IED",null,null,null,"Ingestion"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N_Exc","rep_N","% _Lit","%_Racl","%_Lisier","Nlisier","Nlitière","Nraclage","Nraclage_S","NRaclage_L","P-Exc","rep_P","Plisier","Plitière","Praclage","Praclage_S","PRaclage_L","K-Exc","Klisier","Klitière","Kraclage","Kraclage_S","KRaclage_L","Cu_Exc","CuKlisier","Culitière","Curaclage","Curaclage_S","CuRaclage_L","Zn_Exc","ZnKlisier","Znlitière","Znraclage","Znraclage_S","ZnRaclage_L",null,"N_IED_Bip","P2O5-IED_Bip","N_IED","P2O5_IED","N_Ing_Biph","P_Ing_Biph","Alim_Ing_Bip","Alim_Ing_IED"]
[null,null,null,null,null,null,null,null,null,null,null,"Reproducteurs",{"$f":"(M$46*$S60+M$56*$Q60+M$57*$R60)/100","v":24},{"$f":"(N$46*$S60+N$56*$Q60+N$57*$R60)/100","v":7},{"$f":"Standard!C19*Standard!Y19/0.93/0.76","v":3695.1046972269378},{"$f":"+O60/$O$64","v":0.15119013218356084},{"$f":"IF(sel_mode=1,0,IF(((C23+D23)/2+(C25+D25)/2)>0,(G23*(C23+D23)/2+G25*(C25+D25)/2)/((C23+D23)/2+(C25+D25)/2)*0.7,0))","v":0},0,{"$f":"100-pclt-R60","v":100},{"$f":"($O60*(100-$M$46)*(100-$N$46)/100/100)*(S60)/100","v":2611.6999999999998},{"$f":"($O60*(100-$M$56)*(100-$N$56)/100/100)*(pclt)/100","v":0},0,null,null,{"$f":"Standard!C19*4.8","v":873.6},{"$f":"Y60/$Y$64","v":0.1961762176453872},{"$f":"S60*Y60/100","v":873.6},{"$f":"pclt*Y60/100","v":0},null,null,null,{"$f":"Standard!C19*7.73","v":1406.8600000000001},{"$f":"S60*AF60/100","v":1406.86},{"$f":"pclt*AF60/100","v":0},null,null,null,{"$f":"Standard!C19*29.7","v":5405.4},{"$f":"S60*AL60/100","v":5405.4},{"$f":"pclt*AL60/100","v":0},null,null,null,{"$f":"Standard!C19*173","v":31486},{"$f":"S60*AR60/100","v":31486},{"$f":"pclt*AR60/100","v":0},null,null,null,null,{"$f":"IF(O60<>0,O60/Standard!C19*Standard!M19,0)","v":3695.1046972269382},{"$f":"IF(Y60<>0,Y60/Standard!C28*Standard!M28*2.291367,0)","v":2001.7382112000003},{"$f":"AY60/$AY$64*$BA$64","v":3440.0342857524897},{"$f":"AZ60/$AZ$64*$BB$64","v":1818.1929398403413},{"$f":"AY60/0.721","v":5124.9718408140616},{"$f":"AZ60/0.7468117/2.291367","v":1169.7727820814807},{"$f":"BC60/(0.144/6.25)","v":222438.01392422145}]
[null,null,null,null,null,null,null,null,null,null,null,"Jeunes truies",{"$f":"(M$46*$S61+M$56*$Q61+M$57*$R61)/100","v":24},{"$f":"(N$46*$S61+N$56*$Q61+N$57*$R61)/100","v":7},{"$f":"Standard!C20*Standard!Y20/0.93/0.76","v":220.71307300509335},{"$f":"+O61/$O$64","v":9.0307694684058238E-3},{"$f":"IF(sel_mode=1,0,G24)","v":0},0,{"$f":"100-pcljr-R61","v":100},{"$f":"($O61*(100-$M$46)*(100-$N$46)/100/100)*(S61)/100","v":155.99999999999997},{"$f":"($O61*(100-$M$56)*(100-$N$56)/100/100)*(pcljr)/100","v":0},null,null,null,{"$f":"Standard!C20*0.63*3","v":37.799999999999997},{"$f":"Y61/$Y$64","v":8.488394032733099E-3},{"$f":"S61*Y61/100","v":37.799999999999997},{"$f":"pcljr*Y61/100","v":0},null,null,null,{"$f":"Standard!C20*1.32*3","v":79.2},{"$f":"S61*AF61/100","v":79.2},{"$f":"pcljr*AF61/100","v":0},null,null,null,{"$f":"Standard!C20*5.9*3","v":354},{"$f":"S61*AL61/100","v":354},{"$f":"pcljr*AL61/100","v":0},null,null,null,{"$f":"Standard!C20*34.1*3","v":2046},{"$f":"S61*AR61/100","v":2046},{"$f":"pcljr*AR61/100","v":0},null,null,null,null,{"$f":"IF(O61<>0,O61/Standard!C20*Standard!M20,0)","v":220.71307300509335},{"$f":"IF(Y61<>0,Y61/Standard!C29*Standard!M29*2.291367,0)","v":86.613672600000001},{"$f":"AY61/$AY$64*$BA$64","v":205.4774088055245},{"$f":"AZ61/$AZ$64*$BB$64","v":78.67180989693783},{"$f":"AY61/0.62273","v":354.42820003066072},{"$f":"AZ61/0.576767/2.291367","v":65.537730140594022},{"$f":"BC61/(0.155/6.25)","v":14291.459678655674}]
[null,null,null,null,null,null,null,null,null,null,null,"Porcelets produits",{"$f":"(M$46*$S62+M$56*$Q62+M$57*$R62)/100","v":24},7,{"$f":"Standard!C21*Standard!Y21/0.93/0.76","v":2677.0826612903224},{"$f":"+O62/$O$64","v":0.10953640413235216},{"$f":"IF(sel_mode=1,0,G26)","v":0},0,{"$f":"100-pclp-R62","v":100},{"$f":"($O62*(100-$M$46)*(100-$N$46)/100/100)*(S62)/100","v":1892.1620250000001},{"$f":"($O62*(100-$M$56)*(100-$N$56)/100/100)*(pclp)/100","v":0},0,null,null,{"$f":"Standard!C21*0.1","v":485.16975000000002},{"$f":"Y62/$Y$64","v":0.10895005319477805},{"$f":"S62*Y62/100","v":485.16975000000008},{"$f":"pclp*Y62/100","v":0},null,null,null,{"$f":"Standard!C21*0.26","v":1261.4413500000001},{"$f":"S62*AF62/100","v":1261.4413500000001},{"$f":"pclp*AF62/100","v":0},null,null,null,{"$f":"Standard!C21*6.6","v":32021.2035},{"$f":"S62*AL62/100","v":32021.2035},{"$f":"pclp*AL62/100","v":0},null,null,null,{"$f":"Standard!C21*5.3","v":25713.996750000002},{"$f":"S62*AR62/100","v":25713.996750000002},{"$f":"pclp*AR62/100","v":0},null,null,null,null,{"$f":"IF(O62<>0,O62/Standard!C21*Standard!M21,0)","v":2677.0826612903224},{"$f":"IF(Y62<>0,Y62/Standard!C30*Standard!M30*2.291367,0)","v":1111.7019545482501},2492.2855765206032,1009.7667285646787,{"$f":"AY62/0.48668","v":5500.7040792519156},{"$f":"AZ62/0.44981/2.291367","v":1078.6104132856094},{"$f":"BC62/(0.1826/6.25)","v":188277.11114635525}]
[null,null,null,null,null,null,null,null,null,null,null,"Porcs à l'engrais produits",24,7,{"$f":"Standard!C22*(Standard!Y22+($D$35-118)*Standard!Y23)/0.93/0.76","v":17847.217741935485},{"$f":"+O63/$O$64","v":0.73024269421568122},{"$f":"IF(sel_mode=1,0,G27)","v":0},{"$f":"IF(K51=1,0,H27)","v":0},{"$f":"100-pcle-R63","v":100},{"$f":"($O63*(100-$M$46)*(100-$N$46)/100/100)*(S63)/100","v":12614.413500000001},{"$f":"($O63*(100-$M$56)*(100-$N$56)/100/100)*(pcle)/100","v":0},{"$f":"(((O63*(100-M57)/100*(100-N57)/100))*(R63/100))","v":0},{"$f":"IF(K57=2,V63*0.568,V63*0.498)","v":0},{"$f":"V63-W63","v":0},{"$f":"Standard!C22*(0.63+($D$35-118)*0.007)","v":3056.5694250000001},0.68638533512710165,{"$f":"S63*Y63/100","v":3056.5694250000001},{"$f":"pcle*Y63/100","v":0},{"$f":"pcve*Y63/100","v":0},{"$f":"AC63*0.882","v":0},{"$f":"AC63-AD63","v":0},{"$f":"Standard!C22*(1.32+(D35-118)*0.015)","v":6404.2407000000003},{"$f":"S63*AF63/100","v":6404.2407000000003},{"$f":"pcle*AF63/100","v":0},{"$f":"pcve*AF63/100","v":0},{"$f":"AI63*0.469","v":0},{"$f":"AI63-AJ63","v":0},{"$f":"Standard!C22*(5.9+($D$35-118)*0.392)","v":28625.015250000004},{"$f":"S63*AL63/100","v":28625.015250000004},{"$f":"pcle*AL63/100","v":0},{"$f":"pcve*AL63/100","v":0},{"$f":"AO63*0.919","v":0},{"$f":"AO63-AP63","v":0},{"$f":"Standard!C22*(34.1+($D$35-118)*0.068)","v":165442.88475000003},{"$f":"S63*AR63/100","v":165442.88475000003},{"$f":"pcle*AR63/100","v":0},{"$f":"pcve*AR63/100","v":0},{"$f":"AU63*0.925","v":0},{"$f":"AU63-AV63","v":0},null,{"$f":"IF(O63<>0,O63/Standard!C22*Standard!M22,0)","v":17847.217741935485},{"$f":"IF(Y63<>0,Y63/Standard!C31*Standard!M31*2.291367,0)","v":7003.722313653976},16615.237176804025,6361.5303899574765,{"$f":"AY63/0.62273","v":28659.640200304282},{"$f":"AZ63/0.576767/2.291367","v":5299.4873579799123},{"$f":"BC63/(0.154/6.25)","v":1163134.7483889726}]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUM(M60:M63*P60:P63)","v":24.000000000000004},{"$f":"SUM(N60:N63*P60:P63)","v":7},{"$f":"SUM(O60:O63)","v":24440.118173457839},{"$f":"SUM(P60:P63)","v":1},{"$f":"SUM(P60:P63*Q60:Q63)","v":0},{"$f":"SUM(P60:P63*R60:R63)","v":0},{"$f":"SUM(P60:P63*S60:S63)","v":100},{"$f":"SUM(T60:T63)","v":17274.275525000001},{"$f":"SUM(U60:U63)","v":0},{"$f":"SUM(V60:V63)","v":0},{"$f":"SUM(W60:W63)","v":0},0,{"$f":"SUM(Y60:Y63)","v":4453.1391750000003},{"$f":"SUM(Z60:Z63)","v":1},{"$f":"SUM(AA60:AA63)","v":4453.1391750000003},{"$f":"SUM(AB60:AB63)","v":0},0,0,0,{"$f":"SUM(AF60:AF63)","v":9151.7420500000007},{"$f":"SUM(AG60:AG63)","v":9151.7420500000007},{"$f":"SUM(AH60:AH63)","v":0},{"$f":"SUM(AI60:AI63)","v":0},{"$f":"SUM(AJ60:AJ63)","v":0},{"$f":"SUM(AK60:AK63)","v":0},{"$f":"SUM(AL60:AL63)","v":66405.618749999994},{"$f":"SUM(AM60:AM63)","v":66405.618749999994},{"$f":"SUM(AN60:AN63)","v":0},{"$f":"SUM(AO60:AO63)","v":0},{"$f":"SUM(AP60:AP63)","v":0},{"$f":"SUM(AQ60:AQ63)","v":0},{"$f":"SUM(AR60:AR63)","v":224688.88150000002},{"$f":"SUM(AS60:AS63)","v":224688.88150000002},{"$f":"SUM(AT60:AT63)","v":0},{"$f":"SUM(AU60:AU63)","v":0},{"$f":"SUM(AV60:AV63)","v":0},{"$f":"SUM(AW60:AW63)","v":0},null,{"$f":"SUM(AY60:AY63)","v":24440.118173457839},{"$f":"SUM(AZ60:AZ63)","v":10203.776152002227},{"$f":"'Bilan Simplifié'!C28","v":22753.034447882641},{"$f":"'Bilan Simplifié'!E28","v":9268.1618682594344},{"$f":"SUM(BC60:BC63)","v":39639.744320400918},{"$f":"SUM(BD60:BD63)","v":7613.4082834875962},{"$f":"SUM(BE60:BE63)","v":1588141.3331382051},{"$f":"'Bilan Simplifié'!G42","v":1561151.5533000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1-(T64+U64+V64)/O64)*100","v":29.32},null,null,null,null,null,{"$f":"T64/SUM($T$64:$V$64)","v":1},{"$f":"U64/SUM($T$64:$V$64)","v":0},0,0,0,null,null,{"$f":"AA64/SUM($AA$64:$AC$64)","v":1},{"$f":"AB64/SUM($AA$64:$AC$64)","v":0},0,{"$f":"AD64/SUM($AA$64:$AC$64)","v":0},0,null,{"$f":"AG64/SUM($AG$64:$AI$64)","v":1},{"$f":"AH64/SUM($AG$64:$AI$64)","v":0},0,0,0,null,{"$f":"AM64/SUM($AM$64:$AO$64)","v":1},{"$f":"AN64/SUM($AM$64:$AO$64)","v":0},0,0,0,null,{"$f":"AS64/SUM($AS$64:$AU$64)","v":1},{"$f":"AT64/SUM($AS$64:$AU$64)","v":0},0,0,0,null,null,null,{"$f":"BA64/AY64","v":0.93097072143426118},{"$f":"BB64/AZ64","v":0.90830705517200094},null,null,null,{"$f":"BF64/BE64","v":0.98300542950741521}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(L68,L69,L70,\" (en % de N excrété)\")","v":"100% LISIER (en % de N excrété)"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U65,W65:X65)","v":0},null,null,null,null,null,{"$f":"SUM(AB65,AD65:AE65)","v":0},null,null,null,null,null,{"$f":"SUM(AH65,AJ65:AK65)","v":0},null,null,null,null,null,{"$f":"SUM(AN65,AP65:AQ65)","v":0},null,null,null,null,null,{"$f":"SUM(AT65,AV65:AW65)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q64>0,CONCATENATE(FIXED(Q64,0),\"% \",L56,\"; \"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R64>0,CONCATENATE(FIXED(R64,0),\"% \",L57,\"; \"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S64>0,CONCATENATE(FIXED(S64,0),\"% \",\"LISIER\"),\"\")","v":"100% LISIER"}]

{"sheet":"Aliments","index":3,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[[6,5,6,6]]}
[]
[null,null,null,{"$f":"IF(Elevage!C2<>0,Elevage!C2,\"\")","v":""}]
[null,null,"Références",{"$f":"IF(Elevage!C3<>0,Elevage!C3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,null,"de l'élevage",{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,null,{"$f":"IF(Elevage!C5<>0,Elevage!C5,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,"ALIMENTS",{"$f":"Elevage!M9","v":"2017-01-01"},"au",{"$f":"Elevage!M10","v":"2017-12-31"}]
[null,null,"  Aliment complets"]
[null,null,"  Matières premières","Quantité","Protéines","Phosphore","Potassium","Cuivre","Zinc","Azote","Phosphore","Potassium","Cuivre","Zinc"]
[null,null,"  Complémentaires","kg","%","total, %","%","ppm","ppm","kg","P, kg","K, kg","Cu, g","Zn, g"]
[null,null,"Type d'aliment",{"$f":"SUM(D12:D41)","v":1561151.5533000003},{"$f":"IF(D11<>0,J11*6.25/D11*100,\"\")","v":15.240673879320543},{"$f":"IF($D$11<>0,K11/$D$11*100,\"\")","v":0.46448807382053281},{"$f":"IF($D$11<>0,L11/$D$11*100,\"\")","v":0.65519778886831792},{"$f":"IF($D$11<>0,M11/$D$11*1000,\"\")","v":46.611643771664305},{"$f":"IF($D$11<>0,N11/$D$11*1000,\"\")","v":85.197929819079263},{"$f":"SUM(J12:J71)","v":38068.802720064006},{"$f":"SUM(K12:K71)","v":7251.3627793425003},{"$f":"SUM(L12:L71)","v":10228.630458105001},{"$f":"SUM(M12:M71)","v":72767.840076000008},{"$f":"SUM(N12:N71)","v":133006.88047500001}]
[null,1,"Truies lactation ",{"$f":"(Elevage!C23+Elevage!D23)/2*1225*0.26","v":57330},16,0.57999999999999996,0.7,30,100,{"$f":"IF(D12<>0,+E12/100*D12/6.25,\"\")","v":1467.6480000000001},{"$f":"IF(D12<>0,+F12/100*D12,\"\")","v":332.51399999999995},{"$f":"IF(D12<>0,+G12/100*D12,\"\")","v":401.30999999999995},{"$f":"IF(D12<>0,+H12/1000*D12,\"\")","v":1719.8999999999999},{"$f":"IF(D12<>0,+I12/1000*D12,\"\")","v":5733}]
[null,{"$f":"+B12+1","v":2},"Truies gestation",{"$f":"(Elevage!C23+Elevage!D23)/2*1225*0.74","v":163170},14,0.52,0.7,30,100,{"$f":"IF(D13<>0,+E13/100*D13/6.25,\"\")","v":3655.0080000000003},{"$f":"IF(D13<>0,+F13/100*D13,\"\")","v":848.48399999999992},{"$f":"IF(D13<>0,+G13/100*D13,\"\")","v":1142.1899999999998},{"$f":"IF(D13<>0,+H13/1000*D13,\"\")","v":4895.0999999999995},{"$f":"IF(D13<>0,+I13/1000*D13,\"\")","v":16317}]
[null,3,"Post sevrage",{"$f":"Elevage!C35*1.66*(31-8)","v":185237.81054999999},18.3,0.57499999999999996,0.79,170,100,5423.7630929039997,1065.1174106624999,1463.3787033450001,31490.427793500003,18523.781054999999]
[null,4,"Engraissement-Croissance",{"$f":"Elevage!C35*2.7*(Elevage!D35-31)*0.4","v":455865.4971000001},15.5,0.45,0.66,30,80,11305.464328080001,2051.3947369500006,3008.7122808600006,13675.964913000002,36469.239768000007]
[null,5,"Engraissement-Finition",{"$f":"Elevage!C35*2.7*(Elevage!D35-31)*0.6","v":683798.24565000006},14.5,0.42,0.6,30,80,15864.119299079999,2871.9526317300001,4102.7894739000003,20513.947369500002,54703.859652000006]
[null,6,"Jeunes truies",{"$f":"Elevage!C43*(155-Elevage!D43)*3.5","v":15750},14,0.52,0.7,30,80,352.8,81.899999999999991,110.24999999999999,472.5,1260]
[null,7,null,null,null,null,null,null,null,"","","","",""]
[null,8,null,null,null,null,null,null,null,"","","","",""]
[null,9,null,null,null,null,null,null,null,"","","","",""]
[null,10,null,null,null,null,null,null,null,"","","","",""]
[null,11,null,null,null,null,null,null,null,"","","","",""]
[null,12,null,null,null,null,null,null,null,"","","","",""]
[null,13,null,null,null,null,null,null,null,"","","","",""]
[null,14,null,null,null,null,null,null,null,"","","","",""]
[null,15,null,null,null,null,null,null,null,"","","","",""]
[null,16,null,null,null,null,null,null,null,"","","","",""]
[null,17,null,null,null,null,null,null,null,"","","","",""]
[null,18,null,null,null,null,null,null,null,"","","","",""]
[null,19,null,null,null,null,null,null,null,"","","","",""]
[null,20,null,null,null,null,null,null,null,"","","","",""]
[null,21,null,null,null,null,null,null,null,"","","","",""]
[null,22,null,null,null,null,null,null,null,"","","","",""]
[null,23,null,null,null,null,null,null,null,"","","","",""]
[null,24,null,null,null,null,null,null,null,"","","","",""]
[null,25,null,null,null,null,null,null,null,"","","","",""]
[null,26,null,null,null,null,null,null,null,"","","","",""]
[null,27,null,null,null,null,null,null,null,"","","","",""]
[null,28,null,null,null,null,null,null,null,"","","","",""]
[null,29,null,null,null,null,null,null,null,"","","","",""]
[null,30,null,null,null,null,null,null,null,"","","","",""]
[null,31,null,null,null,null,null,null,null,{"$f":"IF(D42<>0,+E42/100*D42/6.25,\"\")","v":""},{"$f":"IF(E42<>0,+F42/100*D42,\"\")","v":""},{"$f":"IF(F42<>0,+G42/100*D42,\"\")","v":""},{"$f":"IF(G42<>0,+H42/1000*D42,\"\")","v":""},{"$f":"IF(H42<>0,+I42/1000*D42,\"\")","v":""}]
[null,32,null,null,null,null,null,null,null,{"$f":"IF(D43<>0,+E43/100*D43/6.25,\"\")","v":""},{"$f":"IF(E43<>0,+F43/100*D43,\"\")","v":""},{"$f":"IF(F43<>0,+G43/100*D43,\"\")","v":""},{"$f":"IF(G43<>0,+H43/1000*D43,\"\")","v":""},{"$f":"IF(H43<>0,+I43/1000*D43,\"\")","v":""}]
[null,33,null,null,null,null,null,null,null,{"$f":"IF(D44<>0,+E44/100*D44/6.25,\"\")","v":""},{"$f":"IF(E44<>0,+F44/100*D44,\"\")","v":""},{"$f":"IF(F44<>0,+G44/100*D44,\"\")","v":""},{"$f":"IF(G44<>0,+H44/1000*D44,\"\")","v":""},{"$f":"IF(H44<>0,+I44/1000*D44,\"\")","v":""}]
[null,{"$f":"+B44+1","v":34},null,null,null,null,null,null,null,"","","","",""]
[null,35,null,null,null,null,null,null,null,"","","","",""]
[null,36,null,null,null,null,null,null,null,"","","","",""]
[null,37,null,null,null,null,null,null,null,"","","","",""]
[null,38,null,null,null,null,null,null,null,"","","","",""]
[null,39,null,null,null,null,null,null,null,"","","","",""]
[null,40,null,null,null,null,null,null,null,"","","","",""]
[null,41,null,null,null,null,null,null,null,"","","","",""]
[null,42,null,null,null,null,null,null,null,"","","","",""]
[null,43,null,null,null,null,null,null,null,"","","","",""]
[null,44,null,null,null,null,null,null,null,"","","","",""]
[null,45,null,null,null,null,null,null,null,"","","","",""]
[null,46,null,null,null,null,null,null,null,"","","","",""]
[null,47,null,null,null,null,null,null,null,"","","","",""]
[null,48,null,null,null,null,null,null,null,"","","","",""]
[null,49,null,null,null,null,null,null,null,"","","","",""]
[null,50,null,null,null,null,null,null,null,"","","","",""]
[null,51,null,null,null,null,null,null,null,"","","","",""]
[null,52,null,null,null,null,null,null,null,"","","","",""]
[null,53,null,null,null,null,null,null,null,"","","","",""]
[null,54,null,null,null,null,null,null,null,"","","","",""]
[null,55,null,null,null,null,null,null,null,"","","","",""]
[null,56,null,null,null,null,null,null,null,"","","","",""]
[null,57,null,null,null,null,null,null,null,"","","","",""]
[null,58,null,null,null,null,null,null,null,"","","","",""]
[null,59,null,null,null,null,null,null,null,"","","","",""]
[null,60,null,null,null,null,null,null,null,"","","","",""]

{"sheet":"Stock_Début","index":4,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[6,3,6,4]]}
[]
[null,null,null,{"$f":"IF(Elevage!C2<>0,Elevage!C2,\"\")","v":""}]
[null,null,"Références",{"$f":"IF(Elevage!C3<>0,Elevage!C3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,null,"de l'élevage",{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,null,{"$f":"IF(Elevage!C5<>0,Elevage!C5,\"\")","v":""}]
[]
[null,null,"ALIMENTS -  STOCKS DEBUT",{"$f":"Elevage!M9","v":"2017-01-01"}]
[]
[null,null,null,"Quantité","Protéines","Phosphore","Potassium","Cuivre","Zinc","Azote","Phosphore","Potassium","Cuivre","Zinc"]
[null,null,null,"kg","%","%","%","ppm","ppm","kg","P, kg","K, kg","Cu, g","Zn, g"]
[null,null,"Type d'aliment",{"$f":"SUM(D12:D41)","v":0},{"$f":"IF(D11<>0,J11*6.25/D11*100,\"\")","v":""},{"$f":"IF($D$11<>0,K11/$D$11*100,\"\")","v":""},{"$f":"IF($D$11<>0,L11/$D$11*100,\"\")","v":""},{"$f":"IF($D$11<>0,M11/$D$11*1000,\"\")","v":""},{"$f":"IF($D$11<>0,N11/$D$11*1000,\"\")","v":""},{"$f":"SUM(J12:J41)","v":0},{"$f":"SUM(K12:K41)","v":0},{"$f":"SUM(L12:L41)","v":0},{"$f":"SUM(M12:M41)","v":0},{"$f":"SUM(N12:N41)","v":0}]
[null,1,"Stock début",null,{"$f":"+Aliments!E11","v":15.240673879320543},{"$f":"+Aliments!F11","v":0.46448807382053281},{"$f":"+Aliments!G11","v":0.65519778886831792},{"$f":"+Aliments!H11","v":46.611643771664305},{"$f":"+Aliments!I11","v":85.197929819079263},{"$f":"IF(D12<>0,+E12/100*D12/6.25,\"\")","v":""},{"$f":"IF(D12<>0,+F12/100*D12,\"\")","v":""},{"$f":"IF(D12<>0,+G12/100*D12,\"\")","v":""},{"$f":"IF(D12<>0,+H12/1000*D12,\"\")","v":""},{"$f":"IF(D12<>0,+I12/1000*D12,\"\")","v":""}]
[null,{"$f":"+B12+1","v":2},null,null,null,null,null,null,null,{"$f":"IF(D13<>0,+E13/100*D13/6.25,\"\")","v":""},{"$f":"IF(D13<>0,+F13/100*D13,\"\")","v":""},{"$f":"IF(D13<>0,+G13/100*D13,\"\")","v":""},{"$f":"IF(D13<>0,+H13/1000*D13,\"\")","v":""},{"$f":"IF(D13<>0,+I13/1000*D13,\"\")","v":""}]
[null,3,null,null,null,null,null,null,null,"","","","",""]
[null,4,null,null,null,null,null,null,null,"","","","",""]
[null,5,null,null,null,null,null,null,null,"","","","",""]
[null,6,null,null,null,null,null,null,null,"","","","",""]
[null,7,null,null,null,null,null,null,null,"","","","",""]
[null,8,null,null,null,null,null,null,null,"","","","",""]
[null,9,null,null,null,null,null,null,null,"","","","",""]
[null,10,null,null,null,null,null,null,null,"","","","",""]
[null,11,null,null,null,null,null,null,null,"","","","",""]
[null,12,null,null,null,null,null,null,null,"","","","",""]
[null,13,null,null,null,null,null,null,null,"","","","",""]
[null,14,null,null,null,null,null,null,null,"","","","",""]
[null,15,null,null,null,null,null,null,null,"","","","",""]
[null,16,null,null,null,null,null,null,null,"","","","",""]
[null,17,null,null,null,null,null,null,null,"","","","",""]
[null,18,null,null,null,null,null,null,null,"","","","",""]
[null,19,null,null,null,null,null,null,null,"","","","",""]
[null,20,null,null,null,null,null,null,null,"","","","",""]
[null,21,null,null,null,null,null,null,null,"","","","",""]
[null,22,null,null,null,null,null,null,null,"","","","",""]
[null,23,null,null,null,null,null,null,null,"","","","",""]
[null,24,null,null,null,null,null,null,null,"","","","",""]
[null,25,null,null,null,null,null,null,null,"","","","",""]
[null,26,null,null,null,null,null,null,null,"","","","",""]
[null,27,null,null,null,null,null,null,null,"","","","",""]
[null,28,null,null,null,null,null,null,null,"","","","",""]
[null,29,null,null,null,null,null,null,null,"","","","",""]
[null,30,null,null,null,null,null,null,null,{"$f":"IF(D41<>0,+E41/100*D41/6.25,\"\")","v":""},{"$f":"IF(D41<>0,+F41/100*D41,\"\")","v":""},{"$f":"IF(D41<>0,+G41/100*D41,\"\")","v":""},{"$f":"IF(D41<>0,+H41/1000*D41,\"\")","v":""},{"$f":"IF(D41<>0,+I41/1000*D41,\"\")","v":""}]

{"sheet":"Stock_Fin","index":5,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[6,3,6,4]]}
[]
[null,null,null,{"$f":"IF(Elevage!C2<>0,Elevage!C2,\"\")","v":""}]
[null,null,"Références",{"$f":"IF(Elevage!C3<>0,Elevage!C3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,null,"de l'élevage",{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,null,{"$f":"IF(Elevage!C5<>0,Elevage!C5,\"\")","v":""}]
[]
[null,null,"ALIMENTS -  STOCKS FIN",{"$f":"Elevage!M10","v":"2017-12-31"}]
[]
[null,null,null,"Quantité","Protéines","Phosphore","Potassium","Cuivre","Zinc","Azote","Phosphore","Potassium","Cuivre","Zinc"]
[null,null,null,"kg","%","%","%","ppm","ppm","kg","P, kg","K, kg","Cu, g","Zn, g"]
[null,null,"Type d'aliment",{"$f":"SUM(D12:D41)","v":0},{"$f":"IF(D11<>0,J11*6.25/D11*100,\"\")","v":""},{"$f":"IF($D$11<>0,K11/$D$11*100,\"\")","v":""},{"$f":"IF($D$11<>0,L11/$D$11*100,\"\")","v":""},{"$f":"IF($D$11<>0,M11/$D$11*1000,\"\")","v":""},{"$f":"IF($D$11<>0,N11/$D$11*1000,\"\")","v":""},{"$f":"SUM(J12:J41)","v":0},{"$f":"SUM(K12:K41)","v":0},{"$f":"SUM(L12:L41)","v":0},{"$f":"SUM(M12:M41)","v":0},{"$f":"SUM(N12:N41)","v":0}]
[null,1,"Stock fin",null,{"$f":"Aliments!E11","v":15.240673879320543},{"$f":"+Aliments!F11","v":0.46448807382053281},{"$f":"+Aliments!G11","v":0.65519778886831792},{"$f":"+Aliments!H11","v":46.611643771664305},{"$f":"+Aliments!I11","v":85.197929819079263},{"$f":"IF(D12<>0,+E12/100*D12/6.25,\"\")","v":""},{"$f":"IF(D12<>0,+F12/100*D12,\"\")","v":""},{"$f":"IF(D12<>0,+G12/100*D12,\"\")","v":""},{"$f":"IF(D12<>0,+H12/1000*D12,\"\")","v":""},{"$f":"IF(D12<>0,+I12/1000*D12,\"\")","v":""}]
[null,{"$f":"+B12+1","v":2},null,null,null,null,null,null,null,{"$f":"IF(D13<>0,+E13/100*D13/6.25,\"\")","v":""},{"$f":"IF(D13<>0,+F13/100*D13,\"\")","v":""},{"$f":"IF(D13<>0,+G13/100*D13,\"\")","v":""},{"$f":"IF(D13<>0,+H13/1000*D13,\"\")","v":""},{"$f":"IF(D13<>0,+I13/1000*D13,\"\")","v":""}]
[null,3,null,null,null,null,null,null,null,"","","","",""]
[null,4,null,null,null,null,null,null,null,"","","","",""]
[null,5,null,null,null,null,null,null,null,"","","","",""]
[null,6,null,null,null,null,null,null,null,"","","","",""]
[null,7,null,null,null,null,null,null,null,"","","","",""]
[null,8,null,null,null,null,null,null,null,"","","","",""]
[null,9,null,null,null,null,null,null,null,"","","","",""]
[null,10,null,null,null,null,null,null,null,"","","","",""]
[null,11,null,null,null,null,null,null,null,"","","","",""]
[null,12,null,null,null,null,null,null,null,"","","","",""]
[null,13,null,null,null,null,null,null,null,"","","","",""]
[null,14,null,null,null,null,null,null,null,"","","","",""]
[null,15,null,null,null,null,null,null,null,"","","","",""]
[null,16,null,null,null,null,null,null,null,"","","","",""]
[null,17,null,null,null,null,null,null,null,"","","","",""]
[null,18,null,null,null,null,null,null,null,"","","","",""]
[null,19,null,null,null,null,null,null,null,"","","","",""]
[null,20,null,null,null,null,null,null,null,"","","","",""]
[null,21,null,null,null,null,null,null,null,"","","","",""]
[null,22,null,null,null,null,null,null,null,"","","","",""]
[null,23,null,null,null,null,null,null,null,"","","","",""]
[null,24,null,null,null,null,null,null,null,"","","","",""]
[null,25,null,null,null,null,null,null,null,"","","","",""]
[null,26,null,null,null,null,null,null,null,"","","","",""]
[null,27,null,null,null,null,null,null,null,"","","","",""]
[null,28,null,null,null,null,null,null,null,"","","","",""]
[null,29,null,null,null,null,null,null,null,"","","","",""]
[null,30,null,null,null,null,null,null,null,"","","","",""]

{"sheet":"Litières","index":6,"n_rows":41,"n_cols":16,"rows_kept":41,"cut":false,"hidden":true,"merged":[[6,6,6,7]]}
[]
[null,null,null,{"$f":"IF(Elevage!C2<>0,Elevage!C2,\"\")","v":""}]
[null,null,"Références",{"$f":"IF(Elevage!C3<>0,Elevage!C3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,null,"de l'élevage",{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,null,{"$f":"IF(Elevage!C5<>0,Elevage!C5,\"\")","v":""}]
[]
[null,null,"Litière Utilisée",{"$f":"Elevage!M9","v":"2017-01-01"},null,"au",{"$f":"Elevage!M10","v":"2017-12-31"}]
[]
[null,null,null,"Quantité","MS","N Total","Phosphore","Potassium","Cuivre","Zinc","MS","Azote","Phosphore","Potassium","Cuivre","Zinc"]
[null,null,null,"kg","%","%","%","%","ppm","ppm","kg","kg","P, kg","K, kg","Cu, g","Zn, g"]
[null,null,"Type de litière",{"$f":"SUM(D12:D41)","v":0},{"$f":"IF(D11<>0,K11/D11*100,\"\")","v":""},{"$f":"IF(D11<>0,L11*6.25/D11*100,\"\")","v":""},{"$f":"IF($D$11<>0,M11/$D$11*100,\"\")","v":""},{"$f":"IF($D$11<>0,N11/$D$11*100,\"\")","v":""},{"$f":"IF($D$11<>0,O11/$D$11*1000,\"\")","v":""},{"$f":"IF($D$11<>0,P11/$D$11*1000,\"\")","v":""},{"$f":"SUM(K12:K41)","v":0},0,0,0,0,0]
[null,1,"Paille",null,88,0.5,0.08,0.94,0,0,{"$f":"IF(E12<>0,+E12/100*D12,\"\")","v":0},{"$f":"IF(E12<>0,+F12/100*D12,\"\")","v":0},{"$f":"IF(E12<>0,+G12/100*D12,\"\")","v":0},{"$f":"IF(E12<>0,+H12/100*D12,\"\")","v":0},{"$f":"IF(E12<>0,+I12/1000*D12,\"\")","v":0},{"$f":"IF(E12<>0,+J12/1000*D12,\"\")","v":0}]
[null,{"$f":"+B12+1","v":2},"Sciure",null,88,0.2,{"$f":"0.01*0.88","v":8.8000000000000005E-3},{"$f":"0.022*0.88","v":1.9359999999999999E-2},0,0,{"$f":"IF(E13<>0,+E13/100*D13,\"\")","v":0},{"$f":"IF(E13<>0,+F13/100*D13,\"\")","v":0},{"$f":"IF(E13<>0,+G13/100*D13,\"\")","v":0},{"$f":"IF(E13<>0,+H13/100*D13,\"\")","v":0},{"$f":"IF(E13<>0,+I13/1000*D13,\"\")","v":0},{"$f":"IF(E13<>0,+J13/1000*D13,\"\")","v":0}]
[null,3,null,null,null,null,null,null,null,null,"",{"$f":"IF(E14<>0,+F14/100*D14,\"\")","v":""},"","","",""]
[null,4,null,null,null,null,null,null,null,null,"","","","","",""]
[null,5,null,null,null,null,null,null,null,null,"","","","","",""]
[null,6,null,null,null,null,null,null,null,null,"","","","","",""]
[null,7,null,null,null,null,null,null,null,null,"","","","","",""]
[null,8,null,null,null,null,null,null,null,null,"","","","","",""]
[null,9,null,null,null,null,null,null,null,null,"","","","","",""]
[null,10,null,null,null,null,null,null,null,null,"","","","","",""]
[null,11,null,null,null,null,null,null,null,null,"","","","","",""]
[null,12,null,null,null,null,null,null,null,null,"","","","","",""]
[null,13,null,null,null,null,null,null,null,null,"","","","","",""]
[null,14,null,null,null,null,null,null,null,null,"","","","","",""]
[null,15,null,null,null,null,null,null,null,null,"","","","","",""]
[null,16,null,null,null,null,null,null,null,null,"","","","","",""]
[null,17,null,null,null,null,null,null,null,null,"","","","","",""]
[null,18,null,null,null,null,null,null,null,null,"","","","","",""]
[null,19,null,null,null,null,null,null,null,null,"","","","","",""]
[null,20,null,null,null,null,null,null,null,null,"","","","","",""]
[null,21,null,null,null,null,null,null,null,null,"","","","","",""]
[null,22,null,null,null,null,null,null,null,null,"","","","","",""]
[null,23,null,null,null,null,null,null,null,null,"","","","","",""]
[null,24,null,null,null,null,null,null,null,null,"","","","","",""]
[null,25,null,null,null,null,null,null,null,null,"","","","","",""]
[null,26,null,null,null,null,null,null,null,null,"","","","","",""]
[null,27,null,null,null,null,null,null,null,null,"","","","","",""]
[null,28,null,null,null,null,null,null,null,null,"","","","","",""]
[null,29,null,null,null,null,null,null,null,null,"","","","","",""]
[null,30,null,null,null,null,null,null,null,null,"","","","","",""]

{"sheet":"Récapitulatif","index":7,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Bilan Réel Simplifié \"Porc\""]
[]
[]
[null,null,null,null,"D'après le document du RMT Elevage&Environnement"]
[]
[null,null,null,null,"Evaluation des rejets d’azote - phosphore - "]
[null,null,null,null,"potassium - cuivre et zinc des porcs."]
[null,null,null,null,"Influence de l'alimentation, du mode de logement"]
[null,null,null,null,"et de la gestation des effluents (2016)"]
[]
[]
[]
[]
[null,null,null,null,"Élevage"]
[null,null,null,null,{"$f":"IF(Elevage!$C$2<>0,Elevage!$C$2,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(Elevage!$C$3<>0,Elevage!$C$3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,null,null,null,{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,null,null,{"$f":"IF(Elevage!C5<>0,Elevage!C5,\"\")","v":""}]
[null,null,"du",{"$f":"Aliments!D7","v":"2017-01-01"},"au",{"$f":"Aliments!F7","v":"2017-12-31"}]
[]
[]
[]
[null,null,null,null,"Effluent épandable"]
[]
[null,null,"Azote",null,null,{"$f":"'Bilan Simplifié'!C30","v":16081.844747763451},"kg"]
[null,null,"Phosphore (P2O5)",null,null,{"$f":"'Bilan Simplifié'!E30","v":9268.1618682594344},"kg"]
[null,null,"Potassium (K2O)",null,null,{"$f":"'Bilan Simplifié'!G30","v":10753.668525683521},"kg"]
[]
[]
[]
[]
[null,null,null,null,"L'utilisation de cet outil ou de ses résultats est faite sous l'entière responsabilité"]
[null,null,null,null,"de l'utilisateur et ne saurait engager celle de l'INRA ou du RMT"]

{"sheet":"Excrétion","index":8,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,6,6,7]]}
[]
[null,null,null,null,null,"Excrétion de N et P2O5"]
[]
[null,null,null,null,null,"Élevage"]
[null,null,null,null,null,{"$f":"IF(Elevage!$C$3<>0,Elevage!$C$3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,null,null,null,null,{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,null,"du",{"$f":"Aliments!D7","v":"2017-01-01"},"au",{"$f":"Aliments!F7","v":"2017-12-31"}]
[]
[]
[null,null,null,null,null,"Nombre de places"]
[]
[null,null,null,"Truies",null,null,210]
[null,null,null,"  dont maternité",null,null,44]
[null,null,null,"  dont gestation",null,null,{"$f":"IF(G12>0,G12-G13,\"\")","v":166}]
[null,null,null,"Porcelets post-sevrage",null,null,850]
[null,null,null,"Porcs à l'engrais et jeunes truies",null,null,1650]
[]
[]
[null,null,null,null,null,"Azote excrété, kg"]
[null,null,null,null,null,"Total","%","Par place",null,null,null,null,"NEffectif","Exc/Animal"]
[null,null,null,"Truies",null,{"$f":"Elevage!BA60","v":3440.0342857524897},{"$f":"F21/$F$27","v":0.15119013218356084},{"$f":"IF(G12>0,F21/G12,\"-\")","v":16.381115646440428},null,null,null,null,{"$f":"Standard!M19","v":182},{"$f":"F21/M21","v":18.901287284354339}]
[null,null,null,{"$f":"D13","v":"  dont maternité"},null,{"$f":"F21*0.28","v":963.20960001069716},{"$f":"F22/$F$27","v":4.2333237011397039E-2},{"$f":"IF(G13>0,F22/G13,\"-\")","v":21.89112727297039}]
[null,null,null,{"$f":"D14","v":"  dont gestation"},null,{"$f":"F21-F22","v":2476.8246857417926},{"$f":"F23/$F$27","v":0.10885689517216381},{"$f":"IF(G14<>\"\",IF(G14>0,F23/G14,\"-\"),\"-\")","v":14.92063063699875}]
[null,null,null,"Porcelets PS",null,{"$f":"Elevage!BA62","v":2492.2855765206032},{"$f":"F24/$F$27","v":0.10953640413235216},2.9321006782595331,null,null,null,null,{"$f":"Standard!M21","v":4851.6975000000002},{"$f":"F24/M24","v":0.51369352201381124}]
[null,null,null,"Porcs à l'engrais"]
[null,null,null,"    et jeunes truies",null,{"$f":"Elevage!BA63+Elevage!BA61","v":16820.714585609549},{"$f":"F26/$F$27","v":0.73927346368408697},{"$f":"IF(G16<>0,F26/G16,\"-\")","v":10.194372476126999},null,null,null,null,{"$f":"Standard!M22+Standard!M20*Standard!A69","v":4851.6975000000002},{"$f":"F26/M26","v":3.4669751330559144}]
[null,null,null,"Total élevage",null,{"$f":"F21+F24+F26","v":22753.034447882641},{"$f":"G21+G24+G26","v":1}]
[]
[]
[null,null,null,null,null,"Phosphore excrété, kg P2O5"]
[null,null,null,null,null,"Total","%","Par place"]
[null,null,null,{"$f":"D21","v":"Truies"},null,{"$f":"Elevage!BB60","v":1818.1929398403413},{"$f":"F32/$F$38","v":0.1961762176453872},{"$f":"IF(G12<>0,F32/G12,\"\")","v":8.6580616182873396}]
[null,null,null,{"$f":"D22","v":"  dont maternité"},null,{"$f":"F32*0.28","v":509.09402315529559},{"$f":"F33/$F$38","v":5.4929340940708421E-2},{"$f":"IF(G13<>0,F33/G13,\"\")","v":11.5703187080749}]
[null,null,null,"  dont gestation",null,{"$f":"F32-F33","v":1309.0989166850457},{"$f":"F34/$F$38","v":0.14124687670467878},{"$f":"IF(G14<>\"\",IF(G14<>0,F34/G14,\"\"),\"-\")","v":7.8861380523195521}]
[null,null,null,"Porcelets PS",null,{"$f":"Elevage!BB62","v":1009.7667285646787},{"$f":"F35/$F$38","v":0.10895005319477803},1.1879608571349161]
[null,null,null,"Porcs à l'engrais"]
[null,null,null,"    et jeunes truies",null,{"$f":"Elevage!BB63+Elevage!BB61","v":6440.2021998544142},{"$f":"F37/$F$38","v":0.6948737291598347},{"$f":"IF(G16<>0,F37/G16,\"\")","v":3.9031528483966147}]
[null,null,null,"Total élevage",null,{"$f":"F32+F36+F37+F35","v":9268.1618682594344},{"$f":"G32+G35+G36+G37","v":1}]
[]
[null,null,null,null,null,"L'utilisation de cet outil ou de ses résultats est faite sous l'entière responsabilité"]
[null,null,null,null,null,"de l'utilisateur et ne saurait engager celle de l'INRA ou du RMT"]

{"sheet":"Bilan Simplifié","index":9,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[[15,7,15,8],[15,6,16,6],[21,3,21,4],[21,5,21,6],[39,6,39,7],[17,7,17,8],[16,7,16,8]]}
[]
[null,null,{"$f":"IF(Elevage!C2<>0,Elevage!C2,\"\")","v":""}]
[null,"Références",{"$f":"IF(Elevage!C3<>0,Elevage!C3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,"de l'élevage",{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,{"$f":"IF(Elevage!C5<>0,Elevage!C5,\"\")","v":""}]
[]
[null,"Effluent",{"$f":"+Elevage!L66","v":"100% LISIER (en % de N excrété)"}]
[]
[]
[null,"ELEVAGE",null,null,"LITIERE"]
[null,null,null,null,null,null,"kg brut","kg MS","%MS"]
[null," Début de période",{"$f":"Elevage!M9","v":"2017-01-01"},null,"Quantité totale utilisée",null,{"$f":"+Litières!D11","v":0},{"$f":"IF(G12<>0,+G12*I12/100,\"\")","v":""},{"$f":"+Litières!E11","v":""}]
[null," Fin de période",{"$f":"Elevage!M10","v":"2017-12-31"}]
[null," Durée",{"$f":"+C13-C12+1","v":365},null,"EMANATIONS GAZEUSES, % N excrété"]
[null," Truies en production",{"$f":"(Elevage!C23+Elevage!D23)/2","v":180}]
[null," Verrats",{"$f":"(Elevage!C25+Elevage!D25)/2","v":2},null,null,null,"Bâtiment","Bâtiment + stockage"]
[null," Porcs produits / truie en prod.",{"$f":"IF(C15<>0,(+SUM(Elevage!D26:D27)-SUM(Elevage!C26:C27)+SUM(Elevage!C32:C35)-SUM(Elevage!C41:C42))/C15,\"\")","v":26.953875},null,null,null,null," et/ou compostage"]
[null," I.C. global,  kg/kg",{"$f":"G42/(G49-Elevage!F37)","v":2.666354807962056},null,"Emanations gazeuses, %",null,{"$f":"Elevage!M64","v":24.000000000000004},{"$f":"+Elevage!N65","v":29.32}]
[]
[]
[]
[null,"REJETS","AZOTE","PHOSPHORE",null,"POTASSIUM",null,"CUIVRE","ZINC"]
[null,null,"kg","P, kg","P2O5,kg","K, kg","K2O,kg","kg","kg"]
[null," Aliment",{"$f":"G43","v":38068.802720064006},{"$f":"G44","v":7251.3627793425003},"-",{"$f":"+G45","v":10228.630458105001},"-",{"$f":"IF(+G46>0,G46,\"-\")","v":72.767840076000013},{"$f":"IF(+G47>0,G47,\"-\")","v":133.006880475}]
[null," Apport par la litière",{"$f":"+G57","v":0},{"$f":"+G58","v":0},null,{"$f":"+G59","v":0},"-","-","-"]
[null," Variation stock animaux",{"$f":"+D50-C50","v":0},{"$f":"+D51-C51","v":0},"-",{"$f":"+D52-C52","v":0},"-",{"$f":"IF(H24<>\"-\",+D53-C53,H24)","v":0.13007579999999999},{"$f":"IF(I24<>\"-\",+D54-C54,I24)","v":0}]
[null," Exporté / sorties porcs & porcelets",{"$f":"+F50-E50","v":15315.768272181365},{"$f":"+F51-E51","v":3206.5455317500005},"-",{"$f":"+F52-E52","v":1267.2400200354},"-",{"$f":"IF(H24<>\"-\",F53-E53,H24)","v":0.60295043083000011},{"$f":"IF(I24<>\"-\",F54-E54,\"-\")","v":13.065923848999999}]
[null," Excrété",{"$f":"C24-C26-C27","v":22753.034447882641},{"$f":"D24-D26-D27","v":4044.8172475924998},{"$f":"(30.97376*2+15.9994*5)/(30.97376*2)*D28","v":9268.1618682594344},{"$f":"F24-F26-F27","v":8961.3904380696003},{"$f":"+F28*1.2","v":10753.668525683521},{"$f":"IF(H24<>\"-\",H24-H26-H27,H24)","v":72.034813845170007},{"$f":"IF(I24<>\"-\",I24-I26-I27,I24)","v":119.940956626}]
[null," Emanations gazeuses",{"$f":"C28*H18/100","v":6671.1897001191901}," -"," -"," -"," -"," -"," -"]
[null," Effluent épandable dont",{"$f":"C28+C25-C29","v":16081.844747763451},{"$f":"D24+D25-D26-D27","v":4044.8172475924998},{"$f":"(30.97376*2+15.9994*5)/(30.97376*2)*D30","v":9268.1618682594344},{"$f":"F24+F25-F26-F27","v":8961.3904380696003},{"$f":"+F30*1.2","v":10753.668525683521},{"$f":"+H28","v":72.034813845170007},{"$f":"+I28","v":119.940956626}]
[null,"   lisier",{"$f":"$C$30*Elevage!T65","v":16081.844747763451},{"$f":"D30*Elevage!AA65","v":4044.8172475924998},{"$f":"(30.97376*2+15.9994*5)/(30.97376*2)*D31","v":9268.1618682594344},{"$f":"F30*Elevage!AG65","v":8961.3904380696003},{"$f":"+F31*1.2","v":10753.668525683521},{"$f":"H30*Elevage!AM65","v":72.034813845170007},{"$f":"I30*Elevage!AS65","v":119.940956626}]
[null,{"$f":"CONCATENATE(\"   fumier\",IF(sel_mode=2,\" composté\",IF(sel_mode=5,\"composté\",\"\")))","v":"   fumier"},{"$f":"$C$30*Elevage!U65","v":0},{"$f":"D30*Elevage!AB65","v":0},0,{"$f":"F30*Elevage!AH65","v":0},{"$f":"+F32*1.2","v":0},{"$f":"H30*Elevage!AN65","v":0},{"$f":"I30*Elevage!AT65","v":0}]
[null,{"$f":"CONCATENATE(\"   raclage-solide\",IF(Elevage!K51=3,\" composté\",\"\"))","v":"   raclage-solide"},{"$f":"$C$30*Elevage!W65","v":0},{"$f":"D30*Elevage!AD65","v":0},0,{"$f":"F30*Elevage!AJ65","v":0},0,{"$f":"H30*Elevage!AP65","v":0},{"$f":"I30*Elevage!AV65","v":0}]
[null,"   raclage-liquide",{"$f":"$C$30*Elevage!X65","v":0},{"$f":"D30*Elevage!AE65","v":0},0,{"$f":"F30*Elevage!AK65","v":0},0,{"$f":"H30*Elevage!AQ65","v":0},{"$f":"I30*Elevage!AW65","v":0}]
[]
[]
[]
[]
[null,"BILAN ENTREES/SORTIES"]
[null,null,"Début","Fin","Achats","Ventes","Bilan"]
[null,"Aliments"]
[null,"     - kg",{"$f":"Stock_Début!D11","v":0},{"$f":"Stock_Fin!D11","v":0},{"$f":"Aliments!D11","v":1561151.5533000003},"-",{"$f":"E42+C42-D42","v":1561151.5533000003}]
[null,"     - Azote, kg",{"$f":"Stock_Début!J11","v":0},{"$f":"Stock_Fin!J11","v":0},{"$f":"Aliments!J11","v":38068.802720064006},"-",38068.802720064006,"(N entré)"]
[null,"     - Phosphore, kg (P)",{"$f":"Stock_Début!K11","v":0},{"$f":"Stock_Fin!K11","v":0},{"$f":"Aliments!K11","v":7251.3627793425003},"-",7251.3627793425003,"(P entré)"]
[null,"     - Potassium, kg (K)",{"$f":"+Stock_Début!L11","v":0},{"$f":"+Stock_Fin!L11","v":0},{"$f":"Aliments!L11","v":10228.630458105001},"-",10228.630458105001,"(K entré)"]
[null,"     - Cuivre, kg",{"$f":"+Stock_Début!M11/1000","v":0},{"$f":"+Stock_Fin!M11/1000","v":0},{"$f":"Aliments!M11/1000","v":72.767840076000013},"-",72.767840076000013,"(Cu entré)"]
[null,"     - Zinc, kg",{"$f":"+Stock_Début!N11/1000","v":0},{"$f":"+Stock_Fin!N11/1000","v":0},{"$f":"Aliments!N11/1000","v":133.006880475},"-",133.006880475,"(Zn entré)"]
[null,"Animaux"]
[null,"     - kg",{"$f":"Elevage!X28","v":169700},{"$f":"Elevage!Y28","v":169700},{"$f":"Elevage!S38","v":11000},{"$f":"Elevage!M38","v":610354.30500000005},{"$f":"-C49+D49+F49-E49","v":599354.30500000005}]
[null,"     - Azote, kg",{"$f":"Elevage!N28","v":4296.0707735232563},{"$f":"Elevage!O28","v":4296.0707735232563},{"$f":"Elevage!T38","v":280.81866582975738},{"$f":"Elevage!N38","v":15596.586938011123},15315.768272181365,"(N retenu)"]
[null,"     - Phosphore, kg (P)",{"$f":"Elevage!P28","v":907.89499999999987},{"$f":"Elevage!Q28","v":907.89499999999987},{"$f":"Elevage!U38","v":58.85},{"$f":"Elevage!O38","v":3265.3955317500004},3206.5455317500005,"(P retenu)"]
[null,"     - Potassium, kg (K)",{"$f":"+Elevage!R28","v":370.89405600000003},{"$f":"+Elevage!S28","v":370.89405600000003},{"$f":"Elevage!V38","v":23.692679999999999},{"$f":"Elevage!P38","v":1290.9327000354001},1267.2400200354,"(K retenu)"]
[null,"     - Cuivre, kg",{"$f":"+Elevage!T28","v":4.0642399999999995E-2},{"$f":"+Elevage!U28","v":0.17071819999999999},{"$f":"Elevage!W38","v":1.1065999999999999E-2},{"$f":"Elevage!Q38","v":0.61401643083000013},0.73302623083000007,"(Cu retenu)"]
[null,"     - Zinc, kg",{"$f":"+Elevage!V28","v":3.6994600000000002},{"$f":"+Elevage!W28","v":3.6994600000000002},{"$f":"Elevage!X38","v":0.23980000000000001},{"$f":"Elevage!R38","v":13.305723849},13.065923848999999,"(Zn retenu)"]
[null,"Litières"]
[null,"     - kg","-","-",{"$f":"Litières!D11","v":0},"-",{"$f":"+E56","v":0}]
[null,"     - Azote, kg","-","-",{"$f":"Litières!L11","v":0},"-",{"$f":"+E57","v":0},"(N entré)"]
[null,"     - Phosphore, kg (P)","-","-",{"$f":"Litières!M11","v":0},"-",{"$f":"+E58","v":0},"(P entré)"]
[null,"     - Potassium, kg (K)","-","-",{"$f":"Litières!N11","v":0},"-",{"$f":"+E59","v":0},"(K entré)"]

{"sheet":"Standard","index":10,"n_rows":42,"n_cols":34,"rows_kept":42,"cut":false,"hidden":true,"merged":[[16,8,16,9],[25,8,25,9],[34,8,34,9],[16,1,16,5],[25,1,25,5],[34,1,34,5]]}
["Feuille de calcul - ne pas supprimer"]
[null,null,{"$f":"IF(Elevage!C2<>0,Elevage!C2,\"\")","v":""}]
[null,"Références",{"$f":"IF(Elevage!C3<>0,Elevage!C3,\"\")","v":"EARL Pemoc'h Gouez"}]
[null,"de l'élevage",{"$f":"IF(Elevage!C4<>0,Elevage!C4,\"\")","v":"200 truies naisseur-engraisseur"}]
[null,null,{"$f":"IF(Elevage!C5<>0,Elevage!C5,\"\")","v":""}]
[]
[null,{"$f":"+'Bilan Simplifié'!B7","v":"Effluent"},{"$f":"+'Bilan Simplifié'!C7","v":"100% LISIER (en % de N excrété)"}]
[]
[]
[null,"BILAN","N","P","K"]
[null,"Ingéré",{"$f":"'Bilan Simplifié'!C24","v":38068.802720064006},{"$f":"'Bilan Simplifié'!D24","v":7251.3627793425003},{"$f":"+'Bilan Simplifié'!F24","v":10228.630458105001}]
[null,"Retenu",{"$f":"+'Bilan Simplifié'!C27+'Bilan Simplifié'!C26","v":15315.768272181365},{"$f":"+'Bilan Simplifié'!D27+'Bilan Simplifié'!D26","v":3206.5455317500005},{"$f":"+'Bilan Simplifié'!F27+'Bilan Simplifié'!F26","v":1267.2400200354},null,null,null,null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(Elevage!$K$51+4,Standard!$N$18:$T$23,5)","v":1.21}]
[null,"Air",{"$f":"+'Bilan Simplifié'!C29","v":6671.1897001191901}]
[null,{"$f":"CONCATENATE(\"Effluent\",\"*\")","v":"Effluent*"},{"$f":"+'Bilan Simplifié'!C30","v":16081.844747763451},{"$f":"+'Bilan Simplifié'!D30","v":4044.8172475924998},{"$f":"+'Bilan Simplifié'!F30","v":8961.3904380696003}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Effectif corrigé","Standard","Standard","Standard","Standard","Standard","Standard","Standard",null,null,null,null,"Biphase","Biphase","Biphase","Biphase","Biphase","Biphase","Biphas"]
[null,{"$f":"+C7","v":"100% LISIER (en % de N excrété)"},null,null,null,null,null,null,"si 100% Lisier",null,null,null,null,"Lisier","P. Accum.","P.Acc.+ C.","S. Accum.","S. Acc.+ C.","RcV","RcV_comp",null,null,null,null,"Lisier","P. Accum.","P.Acc.+ C.","S. Accum.","S. Acc.+ C.","RcV","RcV_comp"]
[null,"AZOTE","Effectifs","Bilan","Standard","Biphase",null,null,{"$f":"+E18","v":"Standard"},{"$f":"+F18","v":"Biphase"},null,"N",null,1,2,3,4,5,6,7,"Lit","RacV","Res",null,{"$f":"+N18","v":1},{"$f":"+O18","v":2},{"$f":"+P18","v":3},{"$f":"+Q18","v":4},{"$f":"+R18","v":5},6,7,"Sel","RacV","Res"]
[null,"Reproducteurs",{"$f":"(+Elevage!C23+Elevage!D23+Elevage!C25+Elevage!D25)/2","v":182},null,{"$f":"C19*W19","v":3166.7999999999997},{"$f":"+C19*AH19","v":2611.6999999999998},null,null,{"$f":"+C19*N19","v":3166.7999999999997},{"$f":"+C19*Y19","v":2611.6999999999998},null,"Truie",{"$f":"C19","v":182},17.399999999999999,14.4,12.1,{"$f":"O19","v":14.4},{"$f":"P19","v":12.1},null,null,{"$f":"HLOOKUP(Elevage!$K$45,Standard!$N$18:$R$22,2)","v":17.399999999999999},null,{"$f":"(U19*pclt+N19*(100-pclt))/100","v":17.399999999999999},null,14.35,12.6,10.7,{"$f":"Z19","v":12.6},{"$f":"AA19","v":10.7},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$18:$AC$22,2)","v":14.35},null,{"$f":"(AF19*pclt+Y19*(100-pclt))/100","v":14.35}]
[null,"Jeunes truies",{"$f":"(Elevage!C24+Elevage!D24)/2","v":20},null,{"$f":"C20*W20","v":190.2},{"$f":"+C20*AH20","v":156},null,null,{"$f":"+C20*N20","v":190.2},{"$f":"+C20*Y20","v":156},null,"JT",{"$f":"C20","v":20},{"$f":"N22*3","v":9.51},{"$f":"O22*3","v":6.6899999999999995},4.8600000000000003,4.0500000000000007,3.63,null,null,{"$f":"HLOOKUP(Elevage!$K$45,Standard!$N$18:$R$22,3)","v":9.51},null,{"$f":"(U20*pcljr+N20*(100-pcljr))/100","v":9.51},null,{"$f":"Y22*3","v":7.8000000000000007},{"$f":"Z22*3","v":5.64},3.99,3.33,2.9699999999999998,null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$18:$AC$22,3)","v":7.8000000000000007},null,{"$f":"(AF20*pcljr+Y20*(100-pcljr))/100","v":7.8000000000000007}]
[null,"Porcelets produits",{"$f":"IF(+Elevage!C34+Elevage!C35+Elevage!C33-Elevage!C42<0,0,+Elevage!C34+Elevage!C35+Elevage!C33-Elevage!C42)","v":4851.6975000000002},null,{"$f":"C21*W21","v":2134.7469000000001},{"$f":"+C21*AH21","v":1892.1620250000001},null,null,{"$f":"+C21*N21","v":2134.7469000000001},{"$f":"+C21*Y21","v":1892.1620250000001},null,"PS",{"$f":"(C21+(Elevage!D26*Elevage!F26-Elevage!C26*Elevage!E26)/(31-8))","v":4851.6975000000002},0.44,0.31,0.22,0.18,0.17,null,null,{"$f":"HLOOKUP(Elevage!$K$45,Standard!$N$18:$R$22,4)","v":0.44},null,{"$f":"(U21*pclp+N21*(100-pclp))/100","v":0.44},null,0.39,0.28999999999999998,0.2,0.17,0.15,null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$18:$AC$22,4)","v":0.39},null,{"$f":"(AF21*pclp+Y21*(100-pclp))/100","v":0.39}]
[null,"Porcs à l'engrais produits",{"$f":"+Elevage!C35+Elevage!C34","v":4851.6975000000002},null,{"$f":"IF(Elevage!D35<118,C22*W22,C22*(W22+W23*(Elevage!D35-118)))","v":15379.881075000001},{"$f":"IF(Elevage!D35<118,C22*AH22,C22*(AH22+AH23*(Elevage!D35-118)))","v":12614.413500000001},null,null,{"$f":"IF(Elevage!D35<118,C22*N22,C22*(N22+N23*(Elevage!D35-118)))","v":15379.881075000001},{"$f":"IF(Elevage!D35<118,C22*Y22,C22*(Y22+Y23*(Elevage!D35-118)))","v":12614.413500000001},null,"Eng",{"$f":"C22+(Elevage!D27*Elevage!F27-Elevage!C27*Elevage!E27)/(Elevage!D35-8)","v":4851.6975000000002},3.17,2.23,1.62,1.35,1.21,3.38,2.9,{"$f":"HLOOKUP(Elevage!$K$45,Standard!$N$18:$R$22,5)","v":3.17},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$N$18:$T$23,5),0)","v":0},{"$f":"(U22*pcle+V22*pcve+N22*(100-pcle-pcve))/100","v":3.17},null,2.6,1.88,1.33,1.1100000000000001,0.99,2.76,2.37,{"$f":"HLOOKUP(Elevage!$K$45,$Y$18:$AC$22,5)","v":2.6},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$Y$18:$AE$23,5),0)","v":0},{"$f":"(AF22*pcle+AG22*pcve+Y22*(100-pcle-pcve))/100","v":2.6}]
[null,"Total",null,{"$f":"'Bilan Simplifié'!C30","v":16081.844747763451},{"$f":"SUM(E19:E22)","v":20871.627975000003},{"$f":"SUM(F19:F22)","v":17274.275525000001},null,{"$f":"+D23","v":16081.844747763451},{"$f":"SUM(I19:I22)","v":20871.627975000003},{"$f":"SUM(J19:J22)","v":17274.275525000001},null,"cEng",null,3.5999999999999997E-2,2.5999999999999999E-2,1.9E-2,1.4999999999999999E-2,1.4E-2,3.9E-2,3.3000000000000002E-2,{"$f":"HLOOKUP(Elevage!$K$45,Standard!$N$18:$R$23,5)","v":3.17},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$N$18:$T$23,6),0)","v":0},{"$f":"(U23*pcle+V23*pcve+N23*(100-pcle-pcve))/100","v":3.5999999999999997E-2},null,0.03,2.1999999999999999E-2,1.4999999999999999E-2,1.2999999999999999E-2,1.0999999999999999E-2,3.2000000000000001E-2,2.7E-2,{"$f":"HLOOKUP(Elevage!$K$45,$Y$18:$AC$23,5)","v":2.6},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$Y$18:$AE$23,6),0)","v":0},{"$f":"(AF23*pcle+AG23*pcve+Y23*(100-pcle-pcve))/100","v":0.03}]
[null,null,null,{"$f":"+D23/E23","v":0.77051223637304456},1,{"$f":"+F23/E23","v":0.82764389752879342},null,null,{"$f":"+I23/$E$23","v":1},{"$f":"+J23/$E$23","v":0.82764389752879342}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N16","v":"Standard"},"Standard","Standard","Standard","Standard","Standard","Standard",null,null,null,null,{"$f":"+Y16","v":"Biphase"},"Biphase","Biphase","Biphase","Biphase"]
[null,{"$f":"+B17","v":"100% LISIER (en % de N excrété)"},null,null,null,null,null,null,{"$f":"+I17","v":"si 100% Lisier"},null,null,null,null,"Lisier","P. Accum.","P.Acc.+ C.","S. Accum.","S. Acc.+ C.","RcV","RcV_comp",null,null,null,null,"Lisier","P. Accum.","P.Acc.+ C.","S. Accum.","S. Acc.+ C."]
[null,"PHOSPHORE - P2O5",{"$f":"+C18","v":"Effectifs"},"Bilan","Standard","Biphase",null,null,{"$f":"+E27","v":"Standard"},{"$f":"+F27","v":"Biphase"},null,"P2O5",null,1,2,3,4,5,6,7,"Sel","RacV","Res",null,1,2,3,4,5,6,7,"Sel","RacV","Res"]
[null,{"$f":"+B19","v":"Reproducteurs"},{"$f":"+C19","v":182},null,{"$f":"C28*W28","v":2566.1999999999998},{"$f":"+C28*AH28","v":2002},null,null,{"$f":"+C28*N28","v":2566.1999999999998},{"$f":"+C28*Y28","v":2002},null,{"$f":"+L19","v":"Truie"},{"$f":"M19","v":182},14.1,14.9,{"$f":"+O28","v":14.9},{"$f":"+O28","v":14.9},{"$f":"+Q28","v":14.9},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$N$27:$R$31,2)","v":14.1},null,{"$f":"(U28*pclt+N28*(100-pclt))/100","v":14.1},null,11,11.8,{"$f":"+Z28","v":11.8},{"$f":"+Z28","v":11.8},{"$f":"+AB28","v":11.8},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$27:$AC$31,2)","v":11},null,{"$f":"(AF28*pclt+Y28*(100-pclt))/100","v":11}]
[null,{"$f":"+B20","v":"Jeunes truies"},{"$f":"C20","v":20},null,{"$f":"C29*W29","v":127.2},{"$f":"+C29*AH29","v":87},null,null,{"$f":"+C29*N29","v":127.2},{"$f":"+C29*Y29","v":87},null,"JT",{"$f":"M20","v":20},{"$f":"N31*3","v":6.36},{"$f":"O31*3","v":6.6899999999999995},6.6899999999999995,6.36,6.36,null,null,{"$f":"HLOOKUP(Elevage!$K$45,$N$27:$R$31,3)","v":6.36},null,{"$f":"(U29*pcljr+N29*(100-pcljr))/100","v":6.36},null,{"$f":"Y31*3","v":4.3499999999999996},{"$f":"Z31*3","v":4.68},4.68,4.3499999999999996,4.3499999999999996,null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$27:$AC$31,3)","v":4.3499999999999996},null,{"$f":"(AF29*pcljr+Y29*(100-pcljr))/100","v":4.3499999999999996}]
[null,{"$f":"+B21","v":"Porcelets produits"},{"$f":"+C21","v":4851.6975000000002},null,{"$f":"C30*W30","v":1504.0262250000001},{"$f":"+C30*AH30","v":1115.8904250000001},null,null,{"$f":"+C30*N30","v":1504.0262250000001},{"$f":"+C30*Y30","v":1115.8904250000001},null,{"$f":"+L21","v":"PS"},4851.6975000000002,0.31,0.32,{"$f":"+O30","v":0.32},0.31,{"$f":"+Q30","v":0.31},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$N$27:$R$31,4)","v":0.31},null,{"$f":"(U30*pclp+N30*(100-pclp))/100","v":0.31},null,0.23,0.24,{"$f":"+Z30","v":0.24},0.23,0.23,null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$27:$AC$31,4)","v":0.23},null,{"$f":"(AF30*pclp+Y30*(100-pclp))/100","v":0.23}]
[null,{"$f":"+B22","v":"Porcs à l'engrais produits"},{"$f":"+C22","v":4851.6975000000002},null,{"$f":"IF(Elevage!D35<118,C31*W31,C31*(W31+W32*(Elevage!D35-118)))","v":10285.5987},{"$f":"IF(Elevage!D35<118,C31*AH31,C31*(AH31+AH32*(Elevage!D35-118)))","v":7034.9613749999999},null,null,{"$f":"IF(Elevage!D35<118,C31*N31,C31*(N31+N32*(Elevage!D35-118)))","v":10285.5987},{"$f":"IF(Elevage!D35<118,C31*Y31,C31*(Y31+Y32*(Elevage!D35-118)))","v":7034.9613749999999},null,{"$f":"+L22","v":"Eng"},4851.6975000000002,2.12,2.23,{"$f":"+O31","v":2.23},2.12,{"$f":"+Q31","v":2.12},2.0099999999999998,{"$f":"S31","v":2.0099999999999998},{"$f":"HLOOKUP(Elevage!$K$45,$N$27:$R$31,5)","v":2.12},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$N$27:$T$32,5),0)","v":0},{"$f":"(U31*pcle+V31*pcve+N31*(100-pcle-pcve))/100","v":2.12},null,1.45,1.56,1.56,1.45,1.45,1.36,{"$f":"AD31","v":1.36},{"$f":"HLOOKUP(Elevage!$K$45,$Y$27:$AC$31,5)","v":1.45},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$Y$27:$AE$32,5),0)","v":0},{"$f":"(AF31*pcle+AG31*pcve+Y31*(100-pcle-pcve))/100","v":1.45}]
[null,"Total",null,{"$f":"+'Bilan Simplifié'!E30","v":9268.1618682594344},{"$f":"SUM(E28:E31)","v":14483.024925},{"$f":"SUM(F28:F31)","v":10239.8518},null,{"$f":"+D32","v":9268.1618682594344},{"$f":"SUM(I28:I31)","v":14483.024925},{"$f":"SUM(J28:J31)","v":10239.8518},null,"cEng",null,2.4E-2,2.5999999999999999E-2,{"$f":"O32","v":2.5999999999999999E-2},2.4E-2,2.4E-2,2.4E-2,{"$f":"S32","v":2.4E-2},{"$f":"HLOOKUP(Elevage!$K$45,$N$27:$R$32,5)","v":2.12},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$N$27:$T$32,6),0)","v":0},{"$f":"(U32*pcle+V32*pcve+N32*(100-pcle-pcve))/100","v":2.4E-2},null,1.7000000000000001E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7000000000000001E-2,{"$f":"AB32","v":1.7000000000000001E-2},1.4999999999999999E-2,{"$f":"AD32","v":1.4999999999999999E-2},{"$f":"HLOOKUP(Elevage!$K$45,$Y$27:$AC$32,5)","v":1.45},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$Y$27:$AE$32,6),0)","v":0},{"$f":"(AF32*pcle+AG32*pcve+Y32*(100-pcle-pcve))/100","v":1.7000000000000001E-2}]
[null,null,null,{"$f":"+D32/E32","v":0.63993274307365966},1,{"$f":"+F32/E32","v":0.7070243856533307},null,null,{"$f":"+I32/$E$32","v":1},{"$f":"+J32/$E$32","v":0.7070243856533307}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+N25","v":"Standard"},"Standard","Standard","Standard","Standard","Standard","Standard",null,null,null,null,{"$f":"+Y25","v":"Biphase"},"Biphase","Biphase","Biphase","Biphase"]
[null,{"$f":"+B26","v":"100% LISIER (en % de N excrété)"},null,null,null,null,null,null,{"$f":"+I26","v":"si 100% Lisier"},null,null,null,null,"Lisier","P. Accum.","P.Acc.+ C.","S. Accum.","S. Acc.+ C.","RcV","RcV_comp",null,null,null,null,"Lisier","P. Accum.","P.Acc.+ C.","S. Accum.","S. Acc.+ C."]
[null,"POTASSIUM - K2O",{"$f":"+C27","v":"Effectifs"},"Bilan","Standard","Biphase",null,null,{"$f":"+E36","v":"Standard"},{"$f":"+F36","v":"Biphase"},null,"K2O",null,1,2,3,4,5,6,7,"Sel",null,"Res",null,{"$f":"+N36","v":1},{"$f":"+O36","v":2},{"$f":"+P36","v":3},{"$f":"+Q36","v":4},{"$f":"+R36","v":5},6,7,"Sel",null,"Res"]
[null,{"$f":"+B28","v":"Reproducteurs"},{"$f":"+C28","v":182},null,{"$f":"C37*W37","v":1692.6000000000001},{"$f":"+C37*AH37","v":1692.6000000000001},null,null,{"$f":"+C37*N37","v":1692.6000000000001},{"$f":"+C37*Y37","v":1692.6000000000001},null,{"$f":"+L28","v":"Truie"},{"$f":"M28","v":182},9.3000000000000007,15,{"$f":"+O37","v":15},{"$f":"N37","v":9.3000000000000007},{"$f":"+Q37","v":9.3000000000000007},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$N$36:$R$40,2)","v":9.3000000000000007},null,{"$f":"(U37*pclt+N37*(100-pclt))/100","v":9.3000000000000007},null,9.3000000000000007,15,{"$f":"+Z37","v":15},{"$f":"Y37","v":9.3000000000000007},{"$f":"+AB37","v":9.3000000000000007},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$36:$AC$40,2)","v":9.3000000000000007},null,{"$f":"(AF37*pclt+Y37*(100-pclt))/100","v":9.3000000000000007}]
[null,{"$f":"+B29","v":"Jeunes truies"},{"$f":"C20","v":20},null,{"$f":"C38*W38","v":113.99999999999999},{"$f":"+C38*AH38","v":95.4},null,null,{"$f":"+C38*N38","v":113.99999999999999},{"$f":"+C38*Y38","v":95.4},null,"JT",{"$f":"M29","v":20},{"$f":"N40*3","v":5.6999999999999993},{"$f":"O40*3","v":7.74},7.74,5.88,5.88,null,null,{"$f":"HLOOKUP(Elevage!$K$45,$N$36:$R$40,3)","v":5.6999999999999993},null,{"$f":"(U38*pcljr+N38*(100-pcljr))/100","v":5.6999999999999993},null,{"$f":"Y40*3","v":4.7700000000000005},{"$f":"Z40*3","v":6.8100000000000005},6.8100000000000005,4.92,4.92,null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$36:$AC$40,3)","v":4.7700000000000005},null,{"$f":"(AF38*pcljr+Y38*(100-pcljr))/100","v":4.7700000000000005}]
[null,{"$f":"+B30","v":"Porcelets produits"},{"$f":"+C30","v":4851.6975000000002},null,{"$f":"C39*W39","v":1649.5771500000003},{"$f":"+C39*AH39","v":1504.0262250000001},null,null,{"$f":"+C39*N39","v":1649.5771500000003},{"$f":"+C39*Y39","v":1504.0262250000001},null,{"$f":"+L30","v":"PS"},4851.6975000000002,0.34,0.46,{"$f":"O39","v":0.46},0.35,{"$f":"+Q39","v":0.35},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$N$36:$R$40,4)","v":0.34},null,{"$f":"(U39*pclp+N39*(100-pclp))/100","v":0.34},null,0.31,0.42,{"$f":"+Z39","v":0.42},0.32,{"$f":"+AB39","v":0.32},null,null,{"$f":"HLOOKUP(Elevage!$K$45,$Y$36:$AC$40,4)","v":0.31},null,{"$f":"(AF39*pclp+Y39*(100-pclp))/100","v":0.31}]
[null,{"$f":"+B31","v":"Porcs à l'engrais produits"},{"$f":"+C31","v":4851.6975000000002},null,{"$f":"IF(Elevage!D35<118,C40*W40,C40*(W40+W41*(Elevage!D35-118)))","v":9218.2252499999995},{"$f":"IF(Elevage!D35<118,C40*AH40,C40*(AH40+AH41*(Elevage!D35-118)))","v":7714.1990250000008},null,null,{"$f":"IF(Elevage!D35<118,C40*N40,C31*(N40+N41*(Elevage!D35-118)))","v":9218.2252499999995},{"$f":"IF(Elevage!D35<118,C31*Y40,C31*(Y40+Y41*(Elevage!D35-118)))","v":7714.1990250000008},null,{"$f":"+L31","v":"Eng"},4851.6975000000002,1.9,2.58,{"$f":"O40","v":2.58},1.96,{"$f":"+Q40","v":1.96},1.82,{"$f":"S40","v":1.82},{"$f":"HLOOKUP(Elevage!$K$45,$N$36:$R$40,5)","v":1.9},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$N$36:$T$41,5),0)","v":0},{"$f":"(U40*pcle+V40*pcve+N40*(100-pcle-pcve))/100","v":1.9},null,1.59,2.27,{"$f":"+Z40","v":2.27},1.64,{"$f":"+AB40","v":1.64},1.53,{"$f":"AD40","v":1.53},{"$f":"HLOOKUP(Elevage!$K$45,$Y$36:$AC$40,5)","v":1.59},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$Y$36:$AE$41,5),0)","v":0},{"$f":"(AF40*pcle+AG40*pcve+Y40*(100-pcle-pcve))/100","v":1.59}]
[null,"Total",null,{"$f":"'Bilan Simplifié'!G30","v":10753.668525683521},{"$f":"SUM(E37:E40)","v":12674.402399999999},{"$f":"SUM(F37:F40)","v":11006.225250000001},null,{"$f":"+D41","v":10753.668525683521},{"$f":"SUM(I37:I40)","v":12674.402399999999},{"$f":"SUM(J37:J40)","v":11006.225250000001},null,"cEng",null,2.1999999999999999E-2,3.1E-2,{"$f":"O41","v":3.1E-2},2.1999999999999999E-2,{"$f":"Q41","v":2.1999999999999999E-2},2.1000000000000001E-2,{"$f":"S41","v":2.1000000000000001E-2},{"$f":"HLOOKUP(Elevage!$K$45,$N$36:$R$41,5)","v":1.9},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$N$36:$T$41,6),0)","v":0},{"$f":"(U41*pcle+V41*pcve+N41*(100-pcle-pcve))/100","v":2.1999999999999999E-2},null,1.7999999999999999E-2,2.5999999999999999E-2,{"$f":"Z41","v":2.5999999999999999E-2},1.9E-2,{"$f":"AB41","v":1.9E-2},1.7999999999999999E-2,{"$f":"AD41","v":1.7999999999999999E-2},{"$f":"HLOOKUP(Elevage!$K$45,$Y$36:$AC$41,5)","v":1.59},{"$f":"IF(Elevage!$K$51>1,HLOOKUP(Elevage!$K$51+4,Standard!$Y$36:$AE$41,6),0)","v":0},{"$f":"(AF41*pcle+AG41*pcve+Y41*(100-pcle-pcve))/100","v":1.7999999999999999E-2}]
[null,null,null,{"$f":"+D41/E41","v":0.84845566570330144},1,{"$f":"+F41/E41","v":0.86838218502514974},null,null,{"$f":"+I41/$E$41","v":1},{"$f":"+J41/$E$41","v":0.86838218502514974}]

{"sheet":"Gra_N","index":11,"n_rows":30,"n_cols":17,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,7,15,11],[4,5,7,7],[10,2,11,10]]}
[]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E17","v":"EARL Pemoc'h Gouez"}]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E18","v":"200 truies naisseur-engraisseur"}]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E19","v":""}]
[null,null,null,null,null,"Bilan d'azote"]
[]
[]
[]
[null,null,null,null,"du",{"$f":"Elevage!C9","v":"2017-01-01"},"au",{"$f":"Elevage!C10","v":"2017-12-31"}]
[]
[null,null,{"$f":"Elevage!L66","v":"100% LISIER (en % de N excrété)"}]
[]
[]
[]
[]
[null,null,null,"          Devenir de l'azote utilisé",null,null,null,"Bilan d'azote de l'élevage ",null,null,null,null,null,null,null,null,"Azote rejeté sela la référence utilisée"]
[null,null,"BILAN"]
[null,null,"Ingéré",{"$f":"K20","v":1},null,null,null,null,null,null,"%","%"]
[null,null,"Retenu",{"$f":"K23","v":4.023180971780143E-2},null,null,null,null,null,"kg","intrants","excrété"]
[null,null,"Air",{"$f":"K25","v":1.7524033390740622E-2},null,null,null,"Aliment",null,{"$f":"+'Bilan Simplifié'!C24*10","v":380688.02720064006},{"$f":"J20/($J$20+$J$21)","v":1}]
[null,null,{"$f":"CONCATENATE(\"Effluent\",\"*\")","v":"Effluent*"},{"$f":"K26","v":4.2244156891457954E-2},null,null,null,"Apport par la litière",null,{"$f":"+'Bilan Simplifié'!C25","v":0},{"$f":"J21/($J$20+$J$21)","v":0}]
[null,null,null,null,null,null,null,"Variation stock animaux",null,{"$f":"+'Bilan Simplifié'!C26","v":0},{"$f":"J22/($J$20+$J$21)","v":0},{"$f":"J22/($J$20+$J$21)","v":0}]
[null,null,null,null,null,null,null,"Exporté / sorties porcs ",null,{"$f":"+'Bilan Simplifié'!C27","v":15315.768272181365},{"$f":"J23/($J$20+$J$21)","v":4.023180971780143E-2}]
[null,null,null,null,null,null,null,"Excrété",null,{"$f":"+'Bilan Simplifié'!C28","v":22753.034447882641},{"$f":"J24/($J$20+$J$21)","v":5.9768190282198569E-2},1]
[null,null,null,null,null,null,null,"Volatilisation",null,{"$f":"'Bilan Simplifié'!C29","v":6671.1897001191901},{"$f":"+J25/(J20+J21)","v":1.7524033390740622E-2},{"$f":"+J25/J24","v":0.29320000000000002}]
[null,null,null,null,null,null,null,"Effluent épandable",null,{"$f":"+'Bilan Simplifié'!C30","v":16081.844747763451},{"$f":"J26/($J$20+$J$21)","v":4.2244156891457954E-2},{"$f":"+J26/J24","v":0.70679999999999998}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B31","v":"   lisier"},null,{"$f":"'Bilan Simplifié'!C31","v":16081.844747763451}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B32","v":"   fumier"},null,{"$f":"'Bilan Simplifié'!C32","v":0}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B33","v":"   raclage-solide"},null,{"$f":"'Bilan Simplifié'!C33","v":0}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B34","v":"   raclage-liquide"},null,{"$f":"'Bilan Simplifié'!C34","v":0}]

{"sheet":"Gra_P","index":12,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,4,7,8],[17,9,17,10],[15,7,15,11],[10,2,11,10]]}
[]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E17","v":"EARL Pemoc'h Gouez"}]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E18","v":"200 truies naisseur-engraisseur"}]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E19","v":""}]
[null,null,null,null,"Bilan de phosphore"]
[]
[]
[]
[null,null,null,null,"du",{"$f":"Elevage!C9","v":"2017-01-01"},"au",{"$f":"Elevage!C10","v":"2017-12-31"}]
[]
[null,null,{"$f":"Elevage!L66","v":"100% LISIER (en % de N excrété)"}]
[]
[]
[]
[]
[null,null,null,"Devenir du phosphore utilisé",null,null,null,"Bilan de phosphore de l'élevage ",null,null,null,null,null,null,null,null,"Phosphore rejeté sela la référence utilisée"]
[null,null,"BILAN"]
[null,null,"Ingéré",{"$f":"L20","v":1},null,null,null,null,null,"Phosphore",null,"P, %"]
[null,null,"Retenu",{"$f":"L23","v":0.44219902235269853},null,null,null,null,null,"P, kg","P2O5, kg","intrants"]
[null,null,"Air",null,null,null,null,"Aliment",null,{"$f":"+'Bilan Simplifié'!D24","v":7251.3627793425003},null,{"$f":"J20/($J$20+$J$21)","v":1}]
[null,null,{"$f":"CONCATENATE(\"Effluent\",\"*\")","v":"Effluent*"},{"$f":"L24","v":0.55780097764730141},null,null,null,"Apport par la litière",null,{"$f":"+'Bilan Simplifié'!D25","v":0},null,{"$f":"J21/($J$20+$J$21)","v":0}]
[null,null,null,null,null,null,null,"Variation stock animaux",null,{"$f":"+'Bilan Simplifié'!D26","v":0},null,0]
[null,null,null,null,null,null,null,"Exporté / sorties porcs ",null,{"$f":"+'Bilan Simplifié'!D27","v":3206.5455317500005},null,0.44219902235269853]
[null,null,null,null,null,null,null,"Excrété",null,{"$f":"+'Bilan Simplifié'!D28","v":4044.8172475924998},null,0.55780097764730141]
[null,null,null,null,null,null,null,"Effluent épandable",null,{"$f":"+'Bilan Simplifié'!D30","v":4044.8172475924998},{"$f":"+J25*2.29","v":9262.6314969868254},0.55780097764730141]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B31","v":"   lisier"},null,{"$f":"'Bilan Simplifié'!D31","v":4044.8172475924998},{"$f":"'Bilan Simplifié'!E31","v":9268.1618682594344}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B32","v":"   fumier"},null,{"$f":"'Bilan Simplifié'!D32","v":0},{"$f":"'Bilan Simplifié'!E32","v":0}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B33","v":"   raclage-solide"},null,{"$f":"'Bilan Simplifié'!D33","v":0},{"$f":"'Bilan Simplifié'!E33","v":0}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B34","v":"   raclage-liquide"},null,{"$f":"'Bilan Simplifié'!D34","v":0},{"$f":"'Bilan Simplifié'!E34","v":0}]

{"sheet":"Gra_K","index":13,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[4,4,7,8],[10,2,11,10],[15,7,15,11],[17,9,17,10]]}
[]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E17","v":"EARL Pemoc'h Gouez"}]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E18","v":"200 truies naisseur-engraisseur"}]
[null,null,null,null,null,null,{"$f":"Récapitulatif!E19","v":""}]
[null,null,null,null,"Bilan de potassium"]
[]
[]
[]
[null,null,null,null,"du",{"$f":"Elevage!C9","v":"2017-01-01"},"au",{"$f":"Elevage!C10","v":"2017-12-31"}]
[]
[null,null,{"$f":"Elevage!L66","v":"100% LISIER (en % de N excrété)"}]
[]
[]
[]
[]
[null,null,null,"    Devenir du potassium utilisé",null,null,null,"Bilan de potassium de l'élevage ",null,null,null,null,null,null,null,null,"Potassium (K2O) rejeté sela la référence utilisée"]
[]
[null,null,null,null,null,null,null,null,null,"Potassium",null,"K, %"]
[null,null,"Retenu",{"$f":"L23","v":0.12389146574664446},null,null,null,null,null,"K, kg","K2O, kg","intrants"]
[null,null,"Effluent*",{"$f":"L24","v":0.87610853425335544},null,null,null,"Aliment",null,{"$f":"+'Bilan Simplifié'!F24","v":10228.630458105001},null,{"$f":"J20/($J$20+$J$21)","v":1}]
[null,null,null,null,null,null,null,"Apport par la litière",null,{"$f":"+'Bilan Simplifié'!F25","v":0},null,{"$f":"J21/($J$20+$J$21)","v":0}]
[null,null,null,null,null,null,null,"Variation stock animaux",null,{"$f":"+'Bilan Simplifié'!F26","v":0},null,0]
[null,null,null,null,null,null,null,"Exporté / sorties porcs ",null,{"$f":"+'Bilan Simplifié'!F27","v":1267.2400200354},null,0.12389146574664446]
[null,null,null,null,null,null,null,"Excrété",null,{"$f":"+'Bilan Simplifié'!F28","v":8961.3904380696003},{"$f":"+J24*1.2","v":10753.668525683521},0.87610853425335544]
[null,null,null,null,null,null,null,"Effluent épandable",null,{"$f":"+'Bilan Simplifié'!F30","v":8961.3904380696003},{"$f":"+J25*1.2","v":10753.668525683521},0.87610853425335544]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B31","v":"   lisier"},null,{"$f":"'Bilan Simplifié'!F31","v":8961.3904380696003},{"$f":"J26*1.2","v":10753.668525683521}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B32","v":"   fumier"},null,{"$f":"'Bilan Simplifié'!F32","v":0},{"$f":"'Bilan Simplifié'!E32*1.2","v":0}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B33","v":"   raclage-solide"},null,{"$f":"'Bilan Simplifié'!F33","v":0},{"$f":"'Bilan Simplifié'!E33*1.2","v":0}]
[null,null,null,null,null,null,null,{"$f":"'Bilan Simplifié'!B34","v":"   raclage-liquide"},null,{"$f":"'Bilan Simplifié'!F34","v":0},{"$f":"'Bilan Simplifié'!E34*1.2","v":0}]

{"sheet":"Données","index":14,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":true,"merged":[[1,0,1,5]]}
["Feuille de calcul - ne pas supprimer"]
["BRSPorc : Analyses de la cohérence des données"]
[]
["Fichier"]
[]
[]
["Elevage",{"$f":"CONCATENATE(Elevage!$C$2)","v":""}]
[null,{"$f":"CONCATENATE(Elevage!$C$3)","v":"EARL Pemoc'h Gouez"},null,"du",{"$f":"Elevage!$C$9","v":"2017-01-01"}]
[null,{"$f":"CONCATENATE(Elevage!$C$4)","v":"200 truies naisseur-engraisseur"},null,"au ",{"$f":"Elevage!$C$10","v":"2017-12-31"}]
[null,{"$f":"CONCATENATE(Elevage!$C$5)","v":""}]
[]
["Performances"]
[null,"IC global, kg/kg",{"$f":"'Bilan Simplifié'!$C$18","v":2.666354807962056},null,"dans la feuille bilan simplifié"]
[null,"MAT aliment, %",{"$f":"Aliments!$E$11","v":15.240673879320543},null,"dans le feuille aliment"]
[null,"P aliment, %",{"$f":"Aliments!$F$11","v":0.46448807382053281},null,"dans le feuille aliment"]
[]
["Sorties d'animaux",null,"Nombre",null,"dans la feuille élevage"]
[null,"Porcelets sevrés",{"$f":"Elevage!$C$32","v":0}]
[null,"Porcelets \"de 25-30 kg\"",{"$f":"Elevage!$C$33","v":0}]
[null,"Jeunes Reproducteurs**",{"$f":"Elevage!$C$34","v":0}]
[null,"Porcs charcutiers",{"$f":"Elevage!$C$35","v":4851.6975000000002}]
[null,"Truies de réforme",{"$f":"Elevage!$C$36","v":100}]
[null,"Équarissage"]
[]
["Achats d'animaux",null,"Nombre",null,"dans la feuille élevage"]
[null,"Porcelets sevrés",{"$f":"Elevage!$C$41","v":0}]
[null,"Porcelets \"de 25-30 kg\"",{"$f":"Elevage!$C$42","v":0}]
[null,"Cochettes et verrats",{"$f":"Elevage!$C$43","v":100}]
[]
["Azote",null,"Bilan, kg N",null,"dans la feuille bilan simplifié"]
[null,"N ingéré",{"$f":"'Bilan Simplifié'!$C$24","v":38068.802720064006}]
[null,"N litière",{"$f":"'Bilan Simplifié'!$C$25","v":0}]
[null,"N Excrété",{"$f":"'Bilan Simplifié'!$C$28","v":22753.034447882641}]
[null,"N Effluent",{"$f":"'Bilan Simplifié'!$C$30","v":16081.844747763451}]
[]
["Phosphore",null,"Bilan, kg P",null,"dans la feuille bilan simplifié"]
[null,"P ingéré",{"$f":"'Bilan Simplifié'!$D$24","v":7251.3627793425003}]
[null,"P litière",{"$f":"'Bilan Simplifié'!$D$25","v":0}]
[null,"P Excrété",{"$f":"'Bilan Simplifié'!$D$28","v":4044.8172475924998}]
[null,"P Effluent",{"$f":"'Bilan Simplifié'!$D$30","v":4044.8172475924998}]

{"sheet":"Cohérence","index":15,"n_rows":43,"n_cols":26,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,20,0,28],[33,15,36,19],[37,15,41,19],[33,24,36,28],[37,24,40,28],[42,15,44,19],[37,6,46,9],[0,2,0,9],[0,11,0,19],[13,6,22,9],[15,16,24,19],[25,6,34,9],[31,13,31,15],[30,13,30,15],[29,13,29,15],[15,25,24,28],[29,22,29,24],[30,22,30,24],[31,22,31,24],[42,24,44,28]]}
[null,null,"BRSPorc : Analyses de la cohérence des données (1/2)",null,null,null,null,null,null,null,null,"BRSPorc : Analyses de la cohérence des données (2/2)",null,null,null,null,null,null,null,null,"BRSPorc : Analyses de la cohérence des données (3/3)"]
[]
[null,null,{"$f":"Données!A4","v":"Fichier"},{"$f":"MID(CELL(\"nomfichier\",A2),SEARCH(\"[\",CELL(\"nomfichier\",A2))+1,SEARCH(\"]\",CELL(\"nomfichier\",A2))-SEARCH(\"[\",CELL(\"nomfichier\",A2))-1)","v":"BrsPorc_2016_v4_01.xlsm"},null,null,null,null,null,null,null,"Caractéristiques de l'élevage"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Analyse!B159","v":"Compte tenu de ses ventes cet élevage peut être considéré à :"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Analyse!C6<>0,Analyse!C6,\"\")","v":1},{"$f":"IF(M5<>\"\",Analyse!B6,\"\")","v":"Naisseur engraisseur"}]
[null,null,{"$f":"Données!A7","v":"Elevage"},{"$f":"Données!B7","v":""},null,null,null,null,null,null,null,null,{"$f":"Analyse!C4","v":0},{"$f":"IF(M6<>\"\",Analyse!B4,\"\")","v":"Naisseur vente au sevrage"}]
[null,null,null,{"$f":"Données!B8","v":"EARL Pemoc'h Gouez"},null,null,{"$f":"Données!D8","v":"du"},{"$f":"Données!E8","v":"2017-01-01"},null,null,null,null,{"$f":"Analyse!C5","v":0},{"$f":"IF(M7<>\"\",Analyse!B5,\"\")","v":"Naisseur vente à 30 kg"}]
[null,null,null,{"$f":"Données!B9","v":"200 truies naisseur-engraisseur"},null,null,{"$f":"Données!D9","v":"au "},{"$f":"Données!E9","v":"2017-12-31"},null,null,null,null,{"$f":"Analyse!C7","v":0},{"$f":"IF(M8<>\"\",Analyse!B7,\"\")","v":"Post-sevreur"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Analyse!C8","v":0},{"$f":"IF(M9<>\"\",Analyse!B8,\"\")","v":"Post sevreur-engraisseur"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Analyse!C9","v":0},{"$f":"IF(M10<>\"\",Analyse!B9,\"\")","v":"Engraisseur"}]
[]
[]
[null,null,"Indice de consommation",null,null,null,null,null,null,null,null,null,"Quantité d'azote épandable",null,null,null,null,null,null,null,null,"Quantité de P2O5 épandable"]
[null,null,null,null,null,null,{"$f":"Analyse!K121","v":" - L'indice de consommation global (kg porc sorti / kg aliment entré) estimé par le BRS s'élève à 2.67 kg/kg. Ceci place l'élevage dans les 27% des  meilleurs compte tenu de la variablité des élevages suivis en Gestion Technico-Economique en 2014."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Teneur en protéines des aliments"]
[null,null,null,null,null,null,{"$f":"Analyse!$K$126","v":"-  La teneur moyenne en protéines de l'aliment est de 15.2 % . Elle est inférieure de 0.5 point(s) à la valeur de  15.8 % qu'aurait cet élevage avec une alimentation biphase. Cet écart est facile à atteindre techniquement."}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BRS (Réel) / Biphase Corpen : ",null,null,{"$f":"Analyse!$F$86/Analyse!$D$86","v":0.93097072143426118},null,null,null,null,null,"BRS (Réel) / Biphase Corpen : ",null,null,{"$f":"Analyse!$F$104/Analyse!$D$104","v":0.90510703175015039}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BRS (Réel) / BRS (Biph. Moy.) :",null,null,{"$f":"Analyse!$F$86/Analyse!$E$86","v":0.93097072143426118},null,null,null,null,null,"BRS (Réel) / BRS (Biphase) :",null,null,{"$f":"Analyse!$F$104/Analyse!$E$104","v":0.90833361501693466}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BRS (Réel) / Standard Corpen :",null,null,{"$f":"Analyse!F86/Analyse!C86","v":0.77051223637304456},null,null,null,null,null,"BRS (Réel) / Standard Corpen :",null,null,{"$f":"Analyse!F104/Analyse!C104","v":0.63993274307365966}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Analyse!K136","v":"- La réduction de la quantité d'azote épandable (BRS Réel) par rapport à la valeur calculée avec les références \"Biphase Corpen\" est estimée à 6.9%"},null,null,null,null,null,null,null,null,{"$f":"Analyse!K148","v":"- La réduction de la quantité de phosphore épandable (BRS Réel) par rapport à la valeur calculée avec les références \"Biphase Corpen\" est estimée à 9.5% "}]
[]
[]
[null,null,"Teneur en phosphore des aliments"]
[null,null,null,null,null,null,{"$f":"Analyse!$K$131","v":"-  La teneur moyenne en phosphore de l'aliment est de 0.46 % . Elle est inférieure de 0.03 point(s) à la valeur de  0.49 % qu'aurait cet élevage avec une alimentation biphase.Cet écart nécessite un assez bon niveau technique."},null,null,null,null,null,null,null,null,{"$f":"Analyse!K142","v":"- La réduction de la quantité d'azote épandable (BRS Réel) par rapport à celle du même élevage alimenté en biphase avec des performances moyennes (BRS Biph. Moy.) est estimée à 6.9%"},null,null,null,null,null,null,null,null,{"$f":"Analyse!K153","v":"- La réduction de la quantité de phosphore épandable (BRS Réel) par rapport à celle du même élevage alimenté en biphase avec des performances moyennes (BRS Biph. Moy.) est estimée à 9.2% "}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Analyse!K147","v":"- 46 % de cette réduction provient des performances et 54 %  de cette réduction provient de l'alimentation."},null,null,null,null,null,null,null,null,{"$f":"Analyse!K158","v":"- 42 % de cette réduction provient des performances et 58 %  de cette réduction provient de l'alimentation."}]

{"sheet":"CheckList","index":16,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
[]
["Check-list des justificatifs"]
[]
[null,"Vérification de l'IC global"]
[null,null,"- Quantités d'aliments utilisées : Bilan Comptable ou Bilan de GTE",true,{"$f":"NOT(D5)","v":false}]
[null,null,"- Entrées et Sorties d'animaux : Bilan comptable ou Bilan de GTE",true,{"$f":"NOT(D6)","v":false}]
[]
[null,"Vérification de la composition des aliments en achat extérieur",null,{"$f":"IF($F$8=1,TRUE,FALSE)","v":true},{"$f":"NOT(D8)","v":false},1]
[null,null,"- Récapitulatif des livraisons avec teneur en protéines des aliments",true,{"$f":"NOT(D9)","v":false}]
[null,null,"- Récapitulatif des livraisons avec  teneur moyenne en phosphore des aliments",true,false]
[null,null,"- Récapitulatif des livraisons avec teneur en potassium des aliments",true,{"$f":"NOT(D11)","v":false}]
[]
[]
[null,"Vérification de la composition des aliments en FAF (option 1)",null,{"$f":"IF($F$8=2,TRUE,FALSE)","v":false},{"$f":"NOT(D14)","v":true}]
[null,null,"- Liste des formules utilisées avec calcul de la teneur moyenne pondérée en protéines",false,true]
[null,null,"- Liste des formules utilisées avec calcul de la teneur moyenne pondérée en phosphore",false,true]
[]
[]
[null,"Vérification de la composition des aliments en FAF (option2)",null,{"$f":"IF($F$8=3,TRUE,FALSE)","v":false},{"$f":"NOT(D19)","v":true}]
[null,null,"- Listing des livraisons de complémentaire et des quantités de Matières premières utilisées avec calcul de la teneur moyenne pondérée en protéines",false,true]
[null,null,"- Listing des livraisons de complémentaire et des quantités de Matières premières utilisées avec calcul de la teneur moyenne pondéré en phosphore",false,true]

{"sheet":"Analyse","index":17,"n_rows":163,"n_cols":11,"rows_kept":163,"cut":false,"hidden":true,"merged":[[152,10,156,18],[157,10,157,18],[120,10,123,18],[125,10,128,18],[130,10,134,18],[135,10,140,18],[147,10,151,18],[141,10,145,18],[146,10,146,18]]}
[]
["Détermination des carcatéristiques de l'élevage"]
[]
[null,"Naisseur vente au sevrage",{"$f":"D4/$D$10","v":0},{"$f":"MAX(Données!C18-Données!C26,0)","v":0}]
[null,"Naisseur vente à 30 kg",0,{"$f":"MAX(Données!C19-D7,0)","v":0}]
[null,"Naisseur engraisseur",1,{"$f":"MAX((C13)-(D4+D5+D7+D8+D9),0)","v":4851.6975000000002}]
[null,"Post-sevreur",0,{"$f":"MIN(MAX((Données!C26-Données!C18),0),Données!C19)","v":0},{"$f":"MAX((Données!C26-Données!C18),0)","v":0}]
[null,"Post sevreur-engraisseur",0,{"$f":"IF(Données!C21<>0,MAX(Données!C26-Données!C18-D7,0),0)","v":0}]
[null,"Engraisseur",0,{"$f":"IF(Données!C21<>0,E9-D8-D7,0)","v":0},{"$f":"MAX(Données!C26-Données!C18,0)+MAX(Données!C27-Données!C19,0)","v":0}]
[null,"total ",1,{"$f":"SUM(D4:D9)","v":4851.6975000000002}]
[]
[null,null,"Total","NE_Sev","NE_PS","NE_E","PS","PS-E","E"]
[null,"Effectif vendu",{"$f":"SUM(Données!C18:C21)","v":4851.6975000000002},{"$f":"D4","v":0},{"$f":"D5","v":0},{"$f":"D6","v":4851.6975000000002},{"$f":"D7","v":0},{"$f":"D8","v":0},{"$f":"D9","v":0},null,{"$f":"SUM(D13:I13)","v":4851.6975000000002}]
[null,"Pourcentage de ventes",{"$f":"SUM(D14:I14)","v":1},{"$f":"D13/$C$13","v":0},0,1,0,0,0]
[null,null,"Elevage","N_sev","N_PS","NE_E","PS","PS-E","E"]
[null,"porc/truie",null,null,22.6,null,{"$f":"22.6/(1-0.037)","v":23.468328141225339},{"$f":"I16","v":22.6},22.6]
[null,"Gain kg vif",{"$f":"SUM(D17:I17*D14:I14)","v":2697.7535769312958},280,{"$f":"D17+G17","v":796.3032191069575},{"$f":"F18/F19","v":2697.7535769312958},{"$f":"(30-8)*G16","v":516.3032191069575},{"$f":"(117-8)*H16","v":2463.4},{"$f":"(117-30)*I16","v":1966.2}]
[null,"Aliment",{"$f":"SUM(D18:I18*D14:I14)","v":7472.7774080996896},1218,{"$f":"D18+G18","v":2085.3894080996888},{"$f":"E18+I18","v":7472.7774080996896},{"$f":"G17*G19","v":867.38940809968858},{"$f":"H17*H19","v":6109.232},{"$f":"I17*I19","v":5387.3880000000008}]
[null,"IC global",{"$f":"C18/C17","v":2.77},{"$f":"D18/D17","v":4.3499999999999996},{"$f":"E18/E17","v":2.6188383495905274},2.77,1.68,2.48,2.74]
[null,"CV",{"$f":"SUM(D18:I18*D20:I20*D14:I14)/SUM(D14:I14*D18:I18)","v":6.1371841155234662E-2},{"$f":"D21/D19","v":0.22068965517241379},{"$f":"G20","v":0.11904761904761905},{"$f":"F21/F19","v":6.1371841155234662E-2},{"$f":"G21/G19","v":0.11904761904761905},{"$f":"H21/H19","v":6.4516129032258063E-2},{"$f":"I21/I19","v":6.5693430656934296E-2}]
[null,"Ecartype",{"$f":"C19*C20","v":0.17},0.96,{"$f":"E19*E20","v":0.3117664701893485},0.17,0.2,0.16,0.18]
[]
[null,"MAT Standard",{"$f":"SUM(D23:I23*D18:I18*D14:I14)/C18","v":17.569154852068689},{"$f":"16.5*0.26+16.5*0.74","v":16.5},{"$f":"(19.5*($E$18-$D$18)+$D$23*$D$18)/$E$18","v":17.747809264875041},{"$f":"((17.5*0.6+17.5*0.4)*($F$18-$E$18)+($E$23*$E$18))/$F$18","v":17.569154852068689},19.5,{"$f":"((17.5*0.6+17.5*0.4)*($H$18-$G$18)+($G$23*$G$18))/$H$18","v":17.783960212380109},{"$f":"(17.5*0.4+17.5*0.6)","v":17.5}]
[null,"MAT Biphase",{"$f":"SUM(D24:I24*D18:I18*D14:I14)/C18","v":15.758555693173051},{"$f":"16.5*0.26+14*0.74","v":14.649999999999999},{"$f":"(18.3*($E$18-$D$18)+$D$24*$D$18)/$E$18","v":16.168167938931298},{"$f":"((16*0.6+15*0.4)*($F$18-$E$18)+($E$24*$E$18))/$F$18","v":15.758555693173051},18.260000000000002,{"$f":"((16*0.6+15*0.4)*($H$18-$G$18)+($G$24*$G$18))/$H$18","v":15.977667082465549},{"$f":"(16*0.4+15*0.6)","v":15.4}]
[null,"P standard",{"$f":"SUM(D25:I25*D18:I18*D14:I14)/C18","v":0.60301673546753043},{"$f":"0.65*0.35+0.65*0.65","v":0.65},{"$f":"(0.68*($E$18-$D$18)+$D$25*$D$18)/$E$18","v":0.66247809264875046},{"$f":"((0.58*0.6+0.58*0.4)*($F$18-$E$18)+($E$25*$E$18))/$F$18","v":0.60301673546753043},0.68,{"$f":"((0.58*0.6+0.58*0.4)*($H$18-$G$18)+($G$25*$G$18))/$H$18","v":0.59419801061900557},{"$f":"(0.58*0.4+0.58*0.6)","v":0.57999999999999996}]
[null,"P biphase",{"$f":"SUM(D26:I26*D18:I18*D14:I14)/C18","v":0.4899164930152532},{"$f":"0.6*0.35+0.5*0.65","v":0.53500000000000003},{"$f":"(0.6*($E$18-$D$18)+$D$26*$D$18)/$E$18","v":0.56203586740562594},{"$f":"((0.47*0.6+0.45*0.4)*($F$18-$E$18)+($E$26*$E$18))/$F$18","v":0.4899164930152532},0.57199999999999995,{"$f":"((0.47*0.6+0.45*0.4)*($H$18-$G$18)+($G$26*$G$18))/$H$18","v":0.47761781168090611},{"$f":"(0.47*0.4+0.45*0.6)","v":0.45800000000000002}]
[]
[]
[]
[]
[]
[]
["Feuille de calcul - ne pas supprimer"]
[]
["Analyse - Indice de consommation"]
[null,{"$f":"C$19-C$21*3","v":2.2599999999999998},{"$f":"_xlfn.NORM.DIST($B36,$C$19,$C$21,TRUE)","v":1.3498980316300876E-3},{"$f":"_xlfn.NORM.DIST($B36,$C$19,$C$21,FALSE)","v":2.6069696540811708E-2}]
[null,{"$f":"B36+C$21*3*2/15","v":2.3279999999999998},4.6611880237187337E-3,7.9899819021679905E-2]
[null,2.3959999999999999,1.3903447513498582E-2,0.20867407556606701]
[null,2.464,3.5930319112925754E-2,0.46441269588761247]
[null,2.532,8.0756659233771053E-2,0.88074979785732266]
[null,2.6,0.1586552539314571,1.4233572030537849]
[null,2.6680000000000001,0.27425311775007383,1.9601447228929401]
[null,2.7360000000000002,0.4207402905608974,2.3002511410320938]
[null,2.8040000000000003,0.57925970943910365,2.3002511410320925]
[null,2.8720000000000003,0.72574688224992712,1.9601447228929367]
[null,2.9400000000000004,0.84134474606854348,1.4233572030537813]
[null,3.0080000000000005,0.91924334076622927,0.88074979785731966]
[null,3.0760000000000005,0.96406968088707445,0.46441269588761053]
[null,3.1440000000000006,0.98609655248650152,0.20867407556606576]
[null,3.2120000000000006,0.99533881197628127,7.9899819021679322E-2]
[null,3.2800000000000007,0.9986501019683699,2.6069696540811527E-2]
[]
[null,{"$f":"Données!C13","v":2.666354807962056},null,0]
[null,{"$f":"B53","v":2.666354807962056},{"$f":"_xlfn.NORM.DIST($B54,$C$19,$C$21,TRUE)","v":0.27103769782104215},{"$f":"_xlfn.NORM.DIST($B54,$C$19,$C$21,FALSE)","v":1.948704749050612}]
[]
["Analyse - Teneur en protéines des aliments"]
[null,null,"MAT",3.0000000000000001E-3]
[null,"Standard",{"$f":"C23/100","v":0.17569154852068689}]
[null,"Biphase",{"$f":"C24/100","v":0.15758555693173051}]
[null,"Elevage",{"$f":"Données!C14/100","v":0.15240673879320543},{"$f":"C59-C60","v":5.178818138525082E-3}]
[null,null,null,{"$f":"-D60*100","v":-0.5178818138525082},null,{"$f":"VLOOKUP(1,ComProt,2,FALSE)","v":"est facile à atteindre techniquement."}]
[null,null,0,{"$f":"C62+$D$57","v":3.0000000000000001E-3},{"$f":"IF($D$60<$D62,IF($D$60>$C62,1,0),0)","v":0},"est très facile à atteindre techniquement."]
[null,null,{"$f":"D62","v":3.0000000000000001E-3},{"$f":"+D62+$D$57","v":6.0000000000000001E-3},{"$f":"IF($D$60<$D63,IF($D$60>$C63,1,0),0)","v":1},"est facile à atteindre techniquement."]
[null,null,{"$f":"D63","v":6.0000000000000001E-3},{"$f":"+D63+$D$57","v":9.0000000000000011E-3},0,"nécessite un assez bon niveau technique."]
[null,null,{"$f":"D64","v":9.0000000000000011E-3},1.2E-2,0,"nécessite un bon niveau technique."]
[null,null,{"$f":"D65","v":1.2E-2},{"$f":"+D65+$D$57*2","v":1.8000000000000002E-2},0,"nécessite un très bon niveau technique."]
[null,null,{"$f":"D66","v":1.8000000000000002E-2},1,0,"peut être difficile à atteindre."]
["Analyse - Teneur en phosphore des aliments"]
[null,null,"P"]
[null,"Standard",{"$f":"C25/100","v":6.0301673546753042E-3}]
[null,"Biphase",{"$f":"C26/100","v":4.8991649301525324E-3}]
[null,"Elevage",{"$f":"Données!C15/100","v":4.6448807382053281E-3},{"$f":"C71-C72","v":2.5428419194720425E-4}]
[null,null,null,{"$f":"-D72*100","v":-2.5428419194720425E-2},null,{"$f":"VLOOKUP(1,ComP,2,FALSE)","v":"nécessite un assez bon niveau technique."}]
[null,null,0,1.25E-4,{"$f":"IF($D$72<$D74,IF($D$72>$C74,1,0),0)","v":0},"est très facile à atteindre techniquement."]
[null,null,{"$f":"D74","v":1.25E-4},{"$f":"D74+0.000125","v":2.5000000000000001E-4},0,"est facile à atteindre techniquement."]
[null,null,{"$f":"D75","v":2.5000000000000001E-4},{"$f":"D75+0.000125","v":3.7500000000000001E-4},1,"nécessite un assez bon niveau technique."]
[null,null,3.7500000000000001E-4,5.0000000000000001E-4,0,"nécessite un bon niveau technique."]
[null,null,5.0000000000000001E-4,6.2500000000000001E-4,0,"nécessite un très bon niveau technique."]
[null,null,6.2500000000000001E-4,1,0,"peut être difficile à atteindre."]
[]
[]
["Analyse - Rejets d'azote"]
[]
[null,null,"Standard Corpen","Biphase Corpen","BRS (Biph. Moy.)","BRS (Réel)"]
[null,null,{"$f":"Standard!E23/Standard!$F$23","v":1.208249106875352},{"$f":"Standard!F23/Standard!$F$23","v":1},{"$f":"(C94+G96)/Standard!$F$23","v":1},{"$f":"C94/Standard!$F$23","v":0.93097072143426118}]
[null,null,{"$f":"Standard!E23","v":20871.627975000003},{"$f":"Standard!F23","v":17274.275525000001},{"$f":"C94+G96","v":17274.275525000001},{"$f":"C94","v":16081.844747763451}]
[]
[null,null,"Elevage",null,"Perf.","Alim.","Biph"]
[null,"N ingéré",{"$f":"Données!C31","v":38068.802720064006},null,{"$f":"Elevage!BE64*('Bilan Simplifié'!G43/'Bilan Simplifié'!G42)","v":38726.95061220599},{"$f":"F91+F92","v":38981.596428258934},{"$f":"Elevage!BC64","v":39639.744320400918}]
[null,"Litière",{"$f":"Données!C32","v":0},null,{"$f":"C90","v":0},{"$f":"E90","v":0},0]
[null,"N Fixé",{"$f":"C89-C92","v":15315.768272181365},null,{"$f":"G91","v":15199.626146943079},{"$f":"C91","v":15315.768272181365},{"$f":"G89-G92","v":15199.626146943079}]
[null,"N Excrété",{"$f":"Données!C33","v":22753.034447882641},null,{"$f":"E89-E91","v":23527.324465262911},{"$f":"G92-(E92-C92)","v":23665.828156077569},{"$f":"Elevage!AY64","v":24440.118173457839}]
[null,"Gaz",{"$f":"C92-C94","v":6671.1897001191901},null,{"$f":"C93/C92*E92","v":6898.2115332150861},{"$f":"C93/C92*F92","v":6938.8208153619435},{"$f":"C93/C92*G92","v":7165.8426484578385}]
[null,"Effluent",{"$f":"Données!C34","v":16081.844747763451},null,{"$f":"E92-E93+E90","v":16629.112932047825},{"$f":"F92-F93+F90","v":16727.007340715623},{"$f":"G92-G93+G90","v":17274.275525000001}]
[]
[null,"Gain BRS(réel) / (BRS (biph)",{"$f":"G96/(C94+G96)","v":6.9029278565738872E-2},null,{"$f":"E94-C94","v":547.268184284374},{"$f":"(F94-C94)","v":645.16259295217242},{"$f":"(G94-C94)","v":1192.4307772365501}]
[null,"Gain BRS(réel) / (Biphase Corpen)",{"$f":"-(F86-D86)/D86","v":6.9029278565738872E-2},null,{"$f":"MIN(MAX(IF(-$C$96<0,E96/SUM(E96:F96),0),0),1)","v":0.45895174355753032},{"$f":"MIN(MAX(IF(-$C$96<0,F96/SUM(E96:F96),0),0),1)","v":0.54104825644246968}]
[null,null,{"$f":"IF(C96<0,CONCATENATE(\" Azote :  +  \",FIXED(-C96*100,1,TRUE),\"%\"),CONCATENATE(\"   Azote  :   - \",FIXED(C96*100,1,TRUE),\"%\"))","v":"   Azote  :   - 6.9%"}]
[]
["Analyse - Rejets de Phoshore"]
[]
[null,null,{"$f":"C84","v":"Standard Corpen"},{"$f":"D84","v":"Biphase Corpen"},{"$f":"E84","v":"BRS (Biph. Moy.)"},{"$f":"F84","v":"BRS (Réel)"}]
[null,null,{"$f":"(Standard!E32/2.29)/(Standard!$F$32/2.29)","v":1.414378372644026},{"$f":"(Standard!F32/2.29)/(Standard!$F$32/2.29)","v":1},{"$f":"(C112+G114)/(Standard!$F$32/2.29)","v":0.99588245122356178},{"$f":"C112/(Standard!$F$32/2.29)","v":0.90456694861412201}]
[null,null,{"$f":"Standard!E32","v":14483.024925},{"$f":"Standard!F32","v":10239.8518},{"$f":"(C112+G114)*2.2913","v":10203.477791677502},{"$f":"C112*'Bilan Simplifié'!E30/'Bilan Simplifié'!D30","v":9268.1618682594344}]
[]
[null,null,"Elevage","Biph","Perf.","Alim."]
[null,"P ingéré",{"$f":"Données!C37","v":7251.3627793425003},null,{"$f":"Elevage!BE64*('Bilan Simplifié'!G44/'Bilan Simplifié'!G42)","v":7376.7270878413801},{"$f":"C107/Données!C13*C19","v":7533.2340762747299},{"$f":"Elevage!BD64","v":7613.4082834875962}]
[null,"P Litière",{"$f":"Données!C38","v":0},null,{"$f":"C108","v":0},{"$f":"E108","v":0},{"$f":"F108","v":0}]
[null,"P Fixé",{"$f":"C107-C110","v":3206.5455317500005},null,{"$f":"G109","v":3160.269108487596},{"$f":"C109","v":3206.5455317500005},{"$f":"G107-G110","v":3160.269108487596}]
[null,"P Excrété",{"$f":"Données!C39","v":4044.8172475924998},null,{"$f":"E107-E109","v":4216.4579793537841},{"$f":"G110-(E110-C110)","v":4281.4984432387155},{"$f":"Elevage!AZ64/2.291367","v":4453.1391750000003}]
[null,null,0,null,{"$f":"C111/C110*E110","v":0},{"$f":"C111/C110*F110","v":0},{"$f":"E111/E110*G110","v":0}]
[null,"P Effluent",{"$f":"Données!C40","v":4044.8172475924998},null,{"$f":"E110-E111+E108","v":4216.4579793537841},{"$f":"F110-F111+F108","v":4281.4984432387155},{"$f":"G110-G111+G108","v":4453.1391750000003}]
[]
[null,"Gain BRS(réel) / (BRS (biph)",{"$f":"G114/(C112+G114)","v":9.1693053228568897E-2},null,{"$f":"(E112-C112)","v":171.64073176128431},{"$f":"(F112-C112)","v":236.68119564621566},{"$f":"(G112-C112)","v":408.32192740750043}]
[null,"Gain BRS(réel) / (Biphase Corpen)",{"$f":"-(F104-D104)/D104","v":9.4892968249849663E-2},null,{"$f":"MIN(MAX(IF(-$C$114<0,E114/SUM(E114:F114),0),0),1)","v":0.42035639097576333},{"$f":"MIN(MAX(IF(-$C$114<0,F114/SUM(E114:F114),0),0),1)","v":0.57964360902423662}]
[null,null,{"$f":"IF(C114<0,CONCATENATE(\"  Phosphore : +  \",FIXED(-C114*100,1,TRUE),\"%\"),CONCATENATE(\"Phosphore :  - \",FIXED(C114*100,1,TRUE),\"%\"))","v":"Phosphore :  - 9.2%"}]
[]
[]
[]
["Préparation des messages",null,null,null,null,null,null,null,null,null,"Commentaires"]
["message 1"," - L'indice de consommation global (kg porc sorti / kg aliment entré) estimé par le BRS s'élève à ",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(B121,FIXED(Données!C13,2,TRUE), B122,B123,B124,FIXED(C54*100,0,TRUE),B125)","v":" - L'indice de consommation global (kg porc sorti / kg aliment entré) estimé par le BRS s'élève à 2.67 kg/kg. Ceci place l'élevage dans les 27% des  meilleurs compte tenu de la variablité des élevages suivis en Gestion Technico-Economique en 2014."}]
[null," kg/kg. "]
[]
[null,"Ceci place l'élevage dans les "]
[null,"% des  meilleurs compte tenu de la variablité des élevages suivis en Gestion Technico-Economique en 2014."]
["message 2","-  La teneur moyenne en protéines de l'aliment est de ",null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(F61),CONCATENATE(B126,FIXED(C60*100,1,TRUE), \"% Elle est supérieure à celle qu'aurait cet élevage avec une alimentation bipphase\"),CONCATENATE(B126,FIXED(C60*100,1,TRUE), B127,FIXED(D60*100,1,TRUE),B128,FIXED(C59*100,1,TRUE),B129,B130,F61))","v":"-  La teneur moyenne en protéines de l'aliment est de 15.2 % . Elle est inférieure de 0.5 point(s) à la valeur de  15.8 % qu'aurait cet élevage avec une alimentation biphase. Cet écart est facile à atteindre techniquement."}]
[null," % . Elle est inférieure de "]
[null," point(s) à la valeur de  "]
[null," % qu'aurait cet élevage avec une alimentation biphase. "]
[null,"Cet écart "]
["message 3","-  La teneur moyenne en phosphore de l'aliment est de ",null,null,null,null,null,null,null,null,{"$f":"IF(ISNA(F73),CONCATENATE(B131,FIXED(C72*100,2,TRUE), \"% Elle est supérieure à celle qu'aurait cet élevage avec une alimentation bipphase\"),CONCATENATE(B131,FIXED(C72*100,2,TRUE), B132,FIXED(D72*100,2,TRUE),B133,FIXED(C71*100,2,TRUE),B134,B135,F73))","v":"-  La teneur moyenne en phosphore de l'aliment est de 0.46 % . Elle est inférieure de 0.03 point(s) à la valeur de  0.49 % qu'aurait cet élevage avec une alimentation biphase.Cet écart nécessite un assez bon niveau technique."}]
[null," % . Elle est inférieure de "]
[null," point(s) à la valeur de  "]
[null," % qu'aurait cet élevage avec une alimentation biphase."]
[null,"Cet écart "]
["message 4","- La réduction de la quantité d'azote épandable (BRS Réel) par rapport à la valeur calculée avec les références \"Biphase Corpen\" est estimée à ",null,null,null,null,null,null,null,null,{"$f":"IF($C$97<0,CONCATENATE(\"- La quantité d'azote épandable est supérieure de \",FIXED(-$C$97*100,1,TRUE),\"% à celle qu'aurait cet élevage avec les références Biphase Corpen\"),CONCATENATE($B$136,FIXED($C$97*100,1,TRUE),$B$137))","v":"- La réduction de la quantité d'azote épandable (BRS Réel) par rapport à la valeur calculée avec les références \"Biphase Corpen\" est estimée à 6.9%"}]
[null,"%"]
[null," : "]
[null," % de cette réduction provient des performances et "]
[null," %  de cette réduction provient de l'alimentation."]
[]
["message 4b","- La réduction de la quantité d'azote épandable (BRS Réel) par rapport à celle du même élevage alimenté en biphase avec des performances moyennes (BRS Biph. Moy.) est estimée à ",null,null,null,null,null,null,null,null,{"$f":"IF($C$96<0,CONCATENATE(\"- La quantité d'azote épandable est supérieure de \",FIXED(-$C$96*100,1,TRUE), \"% à celle qu'aurait cet élevage avec une alimentation biphase avec des performances  moyennes\"),CONCATENATE($B$142,FIXED($C$96*100,1,TRUE), $B$137))","v":"- La réduction de la quantité d'azote épandable (BRS Réel) par rapport à celle du même élevage alimenté en biphase avec des performances moyennes (BRS Biph. Moy.) est estimée à 6.9%"}]
[]
[]
[]
[]
["message 4c",null,null,null,null,null,null,null,null,null,{"$f":"IF($C$97<0,\" \",CONCATENATE(\"- \",IF($E$97<>0,(CONCATENATE(FIXED($E$97*100,0,TRUE),$B$139)),\"\"),IF($F$97<>0,(CONCATENATE(FIXED($F$97*100,0,TRUE),$B$140)),\"\")))","v":"- 46 % de cette réduction provient des performances et 54 %  de cette réduction provient de l'alimentation."}]
["message 5","- La réduction de la quantité de phosphore épandable (BRS Réel) par rapport à la valeur calculée avec les références \"Biphase Corpen\" est estimée à ",null,null,null,null,null,null,null,null,{"$f":"IF($C$115<0,CONCATENATE(\"- La quantité de phosphore épandable est supérieure de \",FIXED(-$C$115*100,1,TRUE),\"% à celle qu'aurait cet élevage avec les référence Biphase Corpen\"),CONCATENATE($B$148,FIXED($C$115*100,1,TRUE),$B$149))","v":"- La réduction de la quantité de phosphore épandable (BRS Réel) par rapport à la valeur calculée avec les références \"Biphase Corpen\" est estimée à 9.5% "}]
[null,"% "]
[null," : "]
[null," % de cette réduction provient des performances et "]
[null," %  de l'alimentation."]
["message 5b","- La réduction de la quantité de phosphore épandable (BRS Réel) par rapport à celle du même élevage alimenté en biphase avec des performances moyennes (BRS Biph. Moy.) est estimée à ",null,null,null,null,null,null,null,null,{"$f":"IF($C$114<0,CONCATENATE(\"- La quantité de phosphore épandable est supérieure de \",FIXED(-$C$114*100,1,TRUE),\"% à celle qu'aurait cet élevage avec une alimentation biphase avec des performances  moyennes\"),CONCATENATE($B$153,FIXED($C$114*100,1,TRUE),$B$149))","v":"- La réduction de la quantité de phosphore épandable (BRS Réel) par rapport à celle du même élevage alimenté en biphase avec des performances moyennes (BRS Biph. Moy.) est estimée à 9.2% "}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($C$115<0,\" \",CONCATENATE(\"- \",IF($E$115<>0,(CONCATENATE(FIXED($E$115*100,0,TRUE),$B$139)),\"\"),IF($F$115<>0,(CONCATENATE(FIXED($F$115*100,0,TRUE),$B$140)),\"\")))","v":"- 42 % de cette réduction provient des performances et 58 %  de cette réduction provient de l'alimentation."}]
["Message 0","Compte tenu de ses ventes cet élevage peut être considéré à :"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"FIXED(-D116*100,5,TRUE)","v":"0.00000"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"D116","v":0}]

{"sheet":"Imprimer","index":18,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Résultats des Calculs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Références du bilan simplifé"]
[]
[null,null,"Document du CORPEN de référence"]
[]
[null,null,"Description du Bilan Simplifé"]
[]
[]
[]
[]
[]
[null,null,"Envoyez nous vos commentaires"]

{"sheet":"Feuil1","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}