{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil2","Feuil1"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil2","index":0,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,18,30,19],[8,1,8,20],[21,17,21,20],[22,17,22,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Outil d'aide à la décision sur l'opportunité d'engraisser les brebis de réforme"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," fabrice.ranoux@educagri.fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les sites expérimentaux"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Cliquez sur l'image"]

{"sheet":"Feuil1","index":1,"n_rows":155,"n_cols":28,"rows_kept":155,"cut":false,"hidden":false,"merged":[[13,2,13,5],[13,6,13,8],[16,7,16,8],[18,5,18,6],[17,2,17,6],[1,1,1,22],[6,2,6,7],[2,2,2,21],[16,11,17,12],[16,15,17,21],[18,17,18,18],[14,5,14,8],[5,15,6,21],[7,18,8,19],[7,20,8,21],[8,2,8,3],[9,2,9,12],[5,8,6,10],[61,16,62,16],[64,11,65,11],[64,16,65,16],[61,11,62,11],[43,11,46,11],[47,11,49,11]]}
[]
[null,"FAUT-IL ENGRAISSER LES BREBIS DE REFORME?"]
[null,null,"Outil d'aide à la décision sur l'opportunité d'engraisser les brebis de réforme"]
[]
[]
[null,null,null,null,null,null,null,null,"Cliquez sur la loupe",null,null,null,null,null,null,{"$f":"IF(G14=\"\",\"\",IF(Q25>0,\"VENDEZ VOS BREBIS - NE LES ENGRAISSEZ-PAS !\",\"VOUS POUVEZ ENGRAISSER VOS BREBIS\"))","v":""},null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Cliquez pour voir les NEC"]
[null,null,null,null,null,null,null,20,null,null,null,100,null,null,null,null,null,null,{"$f":"IF(I9>2,\"\",\"à 50 jours\")","v":""},null,{"$f":"IF(U10=\"\",\"\",\"à 100 jours\")","v":""}]
[null,null,"Poids vif",null,null,null,"kg","NEC",{"$f":"IF(F9=\"\",\"\",H8/10)","v":""},null,"GMQ",{"$f":"IF(F9=\"\",\"\",L8)","v":""},"g"]
[null,null,"Cliquez sur les flèches pour faire varier le poids vif, la NEC et le GMQ",null,null,null,null,null,null,null,null,null,null,null,null,"Poids théorique",null,null,{"$f":"IF(I9>2,\"\",F9+(50*(L9/1000)))","v":""},{"$f":"IF(S10=\"\",\"\",\"kg\")","v":""},{"$f":"IF(S10>75,\"\",F9+(100*(L9/1000)))","v":""},{"$f":"IF(U10=\"\",\"\",\"kg\")","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(I9,\"  \",F9)","v":"  "}]
[null,null,"Valeur actuelle estimée",null,null,null,{"$f":"IF(F9=\"\",\"\",VLOOKUP(I11,E74:I155,4))","v":""},{"$f":"IF(G12=\"\",\"\",\"€\")","v":""},null,null,null,null,null,null,null,"Valeur espérée",null,null,{"$f":"IF(S10=\"\",\"\",VLOOKUP(K13,E74:H155,4))","v":""},{"$f":"IF(S12=\"\",\"\",\"€\")","v":""},{"$f":"IF(U10=\"\",\"\",VLOOKUP(L13,E74:H155,4))","v":""},{"$f":"IF(U12=\"\",\"\",\"€\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(L29+I9,\"  \",S10)","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(L31+I9,\"  \",U10)","v":{"$error":"#VALUE!"}}]
[null,null,"Ration envisagée",null,null,null,null,null,null,null,null,null,null,null,null,null,"    Plus-value ",null,{"$f":"IF(I9>2,\"\",S12-G12)","v":""},{"$f":"IF(S14=\"\",\"\",\"€\")","v":""},{"$f":"IF(U10=\"\",\"\",U12-G12)","v":""},{"$f":"IF(U14=\"\",\"\",\"€\")","v":""}]
[null,null,null,null,null,"      (Cliquez dans la case et choisissez dans la liste)"]
[]
[null,null,"Prix des             concentrés",null,160,"€ / t",null,"Besoins alimentaires",null,null,null,"Coût de la ration",null,null,null,{"$f":"IF(G14=\"\",\"\",IF(I9>2,\"\",IF(L19>0.2,\"La ration coûte trop cher       N'engraissez-pas vos brebis\",CONCATENATE(\"Vous pouvez espérer une marge sur coût d'alimentation de :\"))))","v":""}]
[null,null,"Cliquez sur les flèches pour faire varier le prix",null,null,null,null,"UFL","PDI"]
[null,null,"Quantité distribuée",null,{"$f":"IF(G14=\"\",\"\",VLOOKUP(G14,G62:K66,5))","v":""},{"$f":"IF(E19=\"\",\"\",\"g / jour\")","v":""},null,{"$f":"IF(F9=\"\",\"\",I43)","v":""},{"$f":"IF(F9=\"\",\"\",CONCATENATE(ROUND(K43,0),\" g\"))","v":""},null,null,{"$f":"IF(I9>2,\"\",IF(G14=\"\",\"\",VLOOKUP(G14,G53:K58,5)))","v":""},{"$f":"IF(L19=\"\",\"\",\"€ /j\")","v":""},null,null,null,{"$f":"IF(R19=\"\",\"\",\"par brebis\")","v":""},{"$f":"IF(G14=\"\",\"\",IF(P17=\"\",\"\",IF(P17=\"La ration coûte trop cher       N'engraissez-pas vos brebis\",\"\",U23)))","v":""},null,{"$f":"IF(R19=\"\",\"\",\"€\")","v":""},{"$f":"IF(G14=\"\",\"\",IF(P17=\"\",\"\",IF(P17=\"La ration coûte trop cher       N'engraissez-pas vos brebis\",\"\",U24)))","v":""},{"$f":"IF(U19=\"\",\"\",\"€\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,true,{"$f":"IF(H23=FALSE,0,E19*(E17/1000000))","v":{"$error":"#VALUE!"}},null,{"$f":"VLOOKUP(G14,G62:I69,3)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(L19>0.21,1,0)","v":1},null,null,null,{"$f":"S14-(L19*50)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"L43/K23","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(I9>2,1,0)","v":1},null,null,null,{"$f":"IF(U10=\"\",0,U14-(L19*100))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K24*VLOOKUP(G14,G62:I66,2)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"Q23+Q24","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(U23,U24)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"L9/1000","v":{"$error":"#VALUE!"}},null," "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K27*50","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K28/F9","v":{"$error":"#VALUE!"}},{"$f":"IF(K29<0.1,0.5,IF(K29>0.16,1.5,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K27*100","v":{"$error":"#VALUE!"}}]
[null,null,null,null,0.5,null,null,null,null,null,{"$f":"K30/F9","v":{"$error":"#VALUE!"}},{"$f":"IF(K31<0.1,0.5,IF(K31>0.16,1.5,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,1]
[null,null,null,null,null,null,null,null,"NEC < 2"]
[null,null,null,null,null,null,null,null,"NEC 2"]
[null,null,null,null,null,null,null,null,"NEC > 3"]
[]
[]
[null,null,null,null,null,null,null,"Poids vif","Bes UF",null,"Bes PDI","CI"]
[null,null,null,null,null,null,null,{"$f":"F9","v":0},{"$f":"0.033*POWER(H39,0.75)","v":0},null,{"$f":"2.5*POWER(H39,0.75)","v":0},{"$f":"0.089*POWER(H39,0.75)","v":0}]
[null,null,null,null,null,null,null,"GMQ"]
[null,null,null,null,null,null,null,{"$f":"L9","v":""},{"$f":"IF(H41=50,0.28,IF(H41=100,0.56,IF(H41=50,0.84,1.12)))","v":1.1200000000000001},null,{"$f":"IF(H41=50,11,IF(H41=100,22,IF(H41=150,33,44)))","v":44}]
[]
[null,null,null,null,null,null,null,null,{"$f":"I41+I39","v":1.1200000000000001},null,{"$f":"K41+K39","v":44},{"$f":"L41+L39","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Enrubannage + pulpe",0.06,{"$f":"0.0007*$E$17","v":0.112},null,{"$f":"(H53*$K$24)+I53","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Ensilage de maïs",0.1,null,null,{"$f":"(H54*$K$24)+I54","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Foin + céréales",5.5E-2,{"$f":"0.0007*$E$17","v":0.112},null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Herbe de printemps",0.02,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,"Pâturage dérobés",0.01,null,null,{"$error":"#N/A"}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Enrubannage + pulpe",0.1,1.5,null,800]
[null,null,null,null,null,null,"Ensilage de maïs",0.2,1.3,null,0]
[null,null,null,null,null,null,"Foin + céréales",0.08,1.7,null,700]
[null,null,null,null,null,null,"Herbe de printemps",0.05,1,null,0]
[null,null,null,null,null,null,"Pâturage dérobés",7.0000000000000007E-2,0.95,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"NEC","Poids","Prix",null,null,"NEC fin"]
[null,null,null,null,{"$f":"CONCATENATE(F75,\"  \",G75)","v":"0,5  45"},0.5,45,7,{"$f":"H75/G75","v":0.15555555555555556},null,{"$f":"L29+I9","v":{"$error":"#VALUE!"}},{"$f":"S10","v":""}]
[null,null,null,null,{"$f":"CONCATENATE(F76,\"  \",G76)","v":"0,5  50"},0.5,50,7,0.14000000000000001,null,"NEC fin"]
[null,null,null,null,"0,5  55",0.5,55,7,0.12727272727272726,null,{"$f":"L31+I9","v":{"$error":"#VALUE!"}},{"$f":"U10","v":""}]
[null,null,null,null,"0,5  60",0.5,60,7,0.11666666666666667,null,"NEC début"]
[null,null,null,null,"0,5  65",0.5,65,7,0.1076923076923077,null,{"$f":"I9","v":""},{"$f":"F9","v":0}]
[null,null,null,null,"0,5  70",0.5,70,7,0.1,null,{"$f":"IF(K75<1.5,7,IF(K75<2,L75*K96,IF(K75<2.5,L75*K106,IF(K75<3,L75*K114,L75*K129))))","v":{"$error":"#VALUE!"}},"prix 50 j"]
[null,null,null,null,"0,5  75",0.5,75,7,9.3333333333333338E-2]
[null,null,null,null,"0,5  80",0.5,80,7,8.7499999999999994E-2,null,{"$f":"IF(K77<1.5,7,IF(K77<2,L77*K96,IF(K77<2.5,L77*K106,IF(K77<3,L77*K114,L77*K129))))","v":{"$error":"#VALUE!"}},"prix 100 j"]
[null,null,null,null,"0,5  85",0.5,85,7,8.2352941176470587E-2]
[null,null,null,null,"1  45",1,45,7,0.15555555555555556,null,{"$f":"IF(K79<1.5,7,IF(K79<2,L79*K96,IF(K79<2.5,L79*K106,IF(K79<3,L79*K114,L79*K129))))","v":0},"prix début"]
[null,null,null,null,"1  50",1,50,7,0.14000000000000001]
[null,null,null,null,"1  55",1,55,7,0.12727272727272726]
[null,null,null,null,"1  60",1,60,7,0.11666666666666667]
[null,null,null,null,"1  65",1,65,7,0.1076923076923077]
[null,null,null,null,"1  70",1,70,7,0.1]
[null,null,null,null,"1  75",1,75,7,9.3333333333333338E-2]
[null,null,null,null,"1  80",1,80,7,8.7499999999999994E-2,null,{"$f":"AVERAGE(I75:I92)","v":0.11226372574411791}]
[null,null,null,null,"1  85",1,85,7,8.2352941176470587E-2]
[null,null,null,null,"1,5  45",1.5,45,16,0.35555555555555557]
[null,null,null,null,"1,5  50",1.5,50,16,0.32]
[null,null,null,null,"1,5  55",1.5,55,16,0.29090909090909089]
[null,null,null,null,"1,5  60",1.5,60,16,0.26666666666666666,null,{"$f":"AVERAGE(I93:I101)","v":0.25660280170084093}]
[null,null,null,null,"1,5  65",1.5,65,16,0.24615384615384617]
[null,null,null,null,"1,5  70",1.5,70,16,0.22857142857142856]
[null,null,null,null,"1,5  75",1.5,75,16,0.21333333333333335]
[null,null,null,null,"1,5  80",1.5,80,16,0.2]
[null,null,null,null,"1,5  85",1.5,85,16,0.18823529411764706]
[null,null,null,null,"2  45",2,45,30,0.66666666666666663]
[null,null,null,null,"2  50",2,50,35,0.7]
[null,null,null,null,"2  55",2,55,40,0.72727272727272729]
[null,null,null,null,"2  60",2,60,40,0.66666666666666663]
[null,null,null,null,"2  65",2,65,40,0.61538461538461542,null,{"$f":"AVERAGE(I102:I110)","v":0.64007272683743255}]
[null,null,null,null,"2  70",2,70,40,{"$f":"H107/G107","v":0.5714285714285714}]
[null,null,null,null,"2  75",2,75,45,0.6]
[null,null,null,null,"2  80",2,80,50,0.625]
[null,null,null,null,"2  85",2,85,50,0.58823529411764708]
[null,null,null,null,"2,5  45",2.5,45,40,0.88888888888888884]
[null,null,null,null,"2,5  50",2.5,50,40,0.8]
[null,null,null,null,"2,5  55",2.5,55,45,0.81818181818181823]
[null,null,null,null,"2,5  60",2.5,60,45,0.75,null,{"$f":"AVERAGE(I110:I119)","v":0.7240519855961034}]
[null,null,null,null,"2,5  65",2.5,65,45,0.69230769230769229]
[null,null,null,null,"2,5  70",2.5,70,45,0.6428571428571429]
[null,null,null,null,"2,5  75",2.5,75,50,0.66666666666666663]
[null,null,null,null,"2,5  80",2.5,80,55,0.6875]
[null,null,null,null,"2,5  85",2.5,85,60,0.70588235294117652]
[null,null,null,null,"3  45",3,45,60,1.3333333333333333]
[null,null,null,null,"3  50",3,50,60,1.2]
[null,null,null,null,"3  55",3,55,65,1.1818181818181819]
[null,null,null,null,"3  60",3,60,65,1.0833333333333333]
[null,null,null,null,"3  65",3,65,65,1]
[null,null,null,null,"3  70",3,70,65,0.9285714285714286]
[null,null,null,null,"3  75",3,75,75,1]
[null,null,null,null,"3  80",3,80,75,0.9375]
[null,null,null,null,"3  85",3,85,80,0.94117647058823528]
[null,null,null,null,"3,5  45",3.5,45,60,1.3333333333333333,null,{"$f":"AVERAGE(I120:I155)","v":1.0938869001369005}]
[null,null,null,null,"3,5  50",3.5,50,60,1.2]
[null,null,null,null,"3,5  55",3.5,55,65,1.1818181818181819]
[null,null,null,null,"3,5  60",3.5,60,65,1.0833333333333333]
[null,null,null,null,"3,5  65",3.5,65,65,1]
[null,null,null,null,"3,5  70",3.5,70,65,0.9285714285714286]
[null,null,null,null,"3,5  75",3.5,75,75,1]
[null,null,null,null,"3,5  80",3.5,80,75,0.9375]
[null,null,null,null,"3,5  85",3.5,85,80,0.94117647058823528]
[null,null,null,null,"4  45",4,45,60,1.3333333333333333]
[null,null,null,null,"4  50",4,50,60,{"$f":"H139/G139","v":1.2}]
[null,null,null,null,{"$f":"CONCATENATE(F140,\"  \",G140)","v":"4  55"},4,55,65,1.1818181818181819]
[null,null,null,null,"4  60",4,60,70,1.1666666666666667]
[null,null,null,null,"4  65",4,65,70,1.0769230769230769]
[null,null,null,null,"4  70",4,70,70,1]
[null,null,null,null,"4  75",4,75,80,1.0666666666666667]
[null,null,null,null,"4  80",4,80,80,1]
[null,null,null,null,"4  85",4,85,90,1.0588235294117647]
[null,null,null,null,"4,5  45",4.5,45,60,1.3333333333333333]
[null,null,null,null,"4,5  50",4.5,50,60,1.2]
[null,null,null,null,"4,5  55",4.5,55,65,1.1818181818181819]
[null,null,null,null,"4,5  60",4.5,60,70,1.1666666666666667]
[null,null,null,null,"4,5  65",4.5,65,70,1.0769230769230769]
[null,null,null,null,"4,5  70",4.5,70,70,1]
[null,null,null,null,"4,5  75",4.5,75,80,1.0666666666666667]
[null,null,null,null,"4,5  80",4.5,80,80,1]
[null,null,null,null,"4,5  85",4.5,85,90,1.0588235294117647]