{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Accueil","Mais","Herbe","Concentré","Valeur aliments","Feuil1"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":19,"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":"Accueil","index":0,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[7,14,8,18],[15,14,16,18],[0,4,0,16],[0,1,1,2]]}
[null,"Cliquez sur les images suivantes",null,null,"Prix des aliments",null,null,null,null,null,null,null,null,null,null,null,null,null,"v180411"]
[]
[]
[]
[]
[]
[]
[null,null,null,"Calculer le prix du mais ensilage sur pied",null,null,null,null,null,null,null,null,null,null,"Calculer la densité d'un silo de mais ensilage (kg MS / M3)"]
[null,null,null,"selon le prix de parité du mais grain"]
[]
[]
[null,null,null,"Grille prix du mais ensilage sur pied (même calcul)"]
[]
[]
[]
[null,null,null,"Prix des fourrages (herbe)",null,null,null,null,null,null,null,null,null,null,"Calculer la densité d'un silo d'ensilage d'herbe (kg MS / M3)"]
[null,null,null,"selon la parité paille blé soja"]
[]
[]
[null,null,null,"Prix de parité aliment fermier - aliments concentrés"]
[]
[]
[null,null,null,"Prix de parité aliments simples et équivalence de poids"]

{"sheet":"Mais","index":1,"n_rows":143,"n_cols":30,"rows_kept":143,"cut":false,"hidden":false,"merged":[[135,3,135,4],[81,22,85,22],[74,1,76,1],[81,23,85,23],[13,1,14,1],[13,2,14,3],[13,4,14,4],[13,5,14,6],[13,7,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,11],[13,12,14,12],[71,1,73,1],[68,1,70,1],[61,4,62,4],[18,5,18,6],[86,2,86,14],[1,1,1,12],[33,1,33,4],[34,1,34,4],[35,1,35,4],[15,2,15,3],[15,5,15,6],[16,5,16,6],[32,1,32,4],[77,1,79,1],[66,3,66,10],[65,1,65,10]]}
[]
[null,"Calculer le prix du mais ensilage sur pied",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rdt grain","Qx de grain / TMS",null,null,null,null,"oui"]
[null,null,null,null,null,"Calcul du prix selon la parité grain",null,null,null,null,null,null,null,null,null,null,null,null,35,4.92,null,null,null,null,"non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,5.08]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,5.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,5.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,5.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65,5.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,5.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,5.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,5.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,5.85]
[null,"rendement en qx du maïs grain","                          Prix grain / T",null,"Coût récolte - transport - broyage paille / ha","Valeur  /ha des tiges et feuilles",null,"Coefficient de conversion quintaux de grains / Tonne Matière Sèche",null,"cout référence     +- 25% pour 80 Qx","rdt référence:","Coût récolte référence:","Valeur (agro + alimentaire) / 2",null,null,null,null,null,90,5.9,null,null,null,null,"Pour récolter 1 ha de maïs à 80 qx:sans MO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,5.95]
[null,100,100,null,{"$f":"((B16-K16)*1.25)+L16","v":185},{"$f":"VLOOKUP(B16/10,VAlimentaire,4)*M16","v":160.00000000000003},null,{"$f":"VLOOKUP(B16,Table5,2,TRUE)","v":6},null,null,80,160,24,null,null,null,null,null,100,6,null,null,null,null,"Battage par ha",90,null,"Un peu plus que tarif mat pour tenir compte du fuel plus cher et de certain qui récolte en eta ( MB et broyeur sous bec )",null,"Un peu plus que tarif mat pour tenir compte du fuel plus cher et de certain qui récolte en eta ( MB et broyeur sous bec )"]
[null,null,null,"Prix T MS sur pied :",null,{"$f":"((B16*C16/10)-E16+F16)/((B16)/H16)","v":58.499999999999993},null,{"$f":"IF(E10=\"francs\",\"F\",\"€\")","v":"€"},"soit :",{"$f":"F17*6.55957","v":383.73484499999995},null,null,null,null,null,null,null,null,105,6.05,null,null,null,null,"remorque grain 1 tour",4.95,null,"Tarif mat 2006",null,"Tarif mat 2006"]
[null,{"$f":"B16*0.85*1.5/10","v":12.75},{"$f":"C16/0.85/1.5","v":78.431372549019613}]
[null,null,null,"Prix TMS mais épi:",null,{"$f":"((B18*C18)+(-E16+(F16*0.6)))/B18","v":71.450980392156865},null,{"$f":"IF(E9=\"francs\",\"F\",\"€\")","v":"€"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,6.1,null,null,null,null,"tracteur grain 120 cv 1 ha",23.8,null,"Tarif mat 2006",null,"Tarif mat 2006"]
[null,null,"         récolte à la charge de l'acheteur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,6.15,null,null,null,null,"broyeur 3,2 m",11.7,null,"Tarif mat 2006",null,"Tarif mat 2006"]
[null,"Exemple: pour un rendement grain de ",null,null,{"$f":"B16","v":100},"et un prix de ",null,{"$f":"C16","v":100},"sec  payé au moment de la récolte, ",null,null,null,null,null,null,null,null,null,120,6.2,null,null,null,null,"tracteur broyeur 120 cv 0,75 ha",17.850000000000001,null,"Tarif mat 2006",null,"Tarif mat 2006"]
[null,"le prix de parité est  de ",{"$f":"F17","v":58.499999999999993},"par tonne de matière seche. Ensuite il faut estimer le rendement en matière sèche.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",148.30000000000001]
[null,"La pésée des remorques et l'analyse d'une matière sèche demeurent la solution la plus juste.  "]
[]
[null,"En silo"]
[null,"           Il faut rajouter 25 € par tonne de matière sèche pour un maïs correctement conservé comprenant :"]
[null,"           le coût de la récolte, la confection du silo et la main d'oeuvre"]
[]
[null,null,"Estimation du rendement fourrage"]
[null,"Équivalence entre le rendement de l'ensilage et le rendement en grains ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,6.25]
[]
[null,"Nombre de grains/m²",null,null,null,1500,2000,2500,3000,3500,4000]
[null,"Rendement plante entière (T de MS/ha)",null,null,null," 7 - 9"," 10 - 11"," 12 - 13"," 14.5 -15.5"," 16 -18"," 18 - 20"]
[null,"Rendement grains (q/ha à 15 % d'humidité)",null,null,null," 35 - 45"," 50 - 60"," 65 - 75"," 80 - 95"," 95 - 110"," 120 -  125"]
[null,"Coefficient de conversion (q de grains/TMS)",null,null,null," 4.4 à 5.6"," 4.8 à 5.7"," 5.2 à 6.0","5.3 à 6.3","5.6 à 6.5","5.9 à 6.8"]
[null,null,null,null,null,null,null,null,null,null,"Source ARVALIS - Institut du végétal"]
[]
[null,"Estimation du rendement fourrage"]
[]
[null,null,"Laisser une bande témoin récoltée en grains, voir le tableau équivalence grains ci-dessus"]
[]
[null,null,"Pesée de(s) remorque(s) et matière sèche (une poignée à chaque remorque dans un seau à l'ombre, "]
[null,null,"puis prélèvement de 500 gr pour analyse de matière sèche)"]
[]
[null,null,null,null,null,null,null,null,"Distance champ silo"]
[null,null,null,null,null,null,null,"% de MS","500 m","1000 m","2000 m"]
[null,null,null,null,null,null,null,0.25,116,121,130]
[null,null,null,null,null,null,null,0.3,118,123,134]
[null,null,null,null,null,null,null,0.35,113,119,131]
[]
[null,null,"Cuber les silos : Densité en kg MS par M3 dans le silo "]
[]
[null,null,null,null,null,null,null,null,"  L"]
[null,null,null,null,null,null,null,null,null,null,null,"H"]
[]
[null,null,null,null,null,null,null,null,null,"l"]
[]
[]
[]
[null,null,"Calculer la densité d'un silo de mais ensilage (kg MS / M3)"]
[null,null,"% MS",33,"Silo couloir"]
[null,null,"amidon",35,null,null,"Teneur en amidon selon % grain"]
[null,null,"hauteur",1.5,"oui",null,"% grains",42,46,51,55]
[null,null,"kg MS/m3",{"$f":"IF(E64=\"oui\",(929-17.5*D62+7.9*D63+44*D64)*D62/100,((929-17.5*D62+7.9*D63+44*D64)*D62/100)*0.9)","v":229.02},null,null,"% amidon",25,30,35,40,null,"Densité sorghosucrier BMR"]
[null,"Densité mais ensilage selon % amidon, hauteur, taux de matière sèche en silo couloir",null,null,null,null,null,null,null,null,null,null,"126 kg MS/ M3"]
[null,"Amidon","Hauteur","Matière sèche - % brut",null,null,null,null,null,null,null,null,"contre 220-230 en mais ensilage"]
[null,"% ","m",29,{"$f":"D68+2","v":31},{"$f":"E68+2","v":33},35,37,39,41,43]
[null,25,1.7,{"$f":"(929-17.5*$D$68+7.9*$B69+44*$C69)*$D$68/100","v":201.20199999999997},{"$f":"(929-17.5*E68+7.9*$B69+44*$C69)*E68/100","v":204.22799999999998},205.85399999999998,206.08,204.90599999999998,202.33199999999997,198.358,192.98400000000001]
[null,null,2.2000000000000002,{"$f":"(929-17.5*D68+7.9*$B69+44*$C$70)*D68/100","v":207.58199999999997},211.048,213.11399999999998,213.78,213.04599999999999,210.91199999999998,207.37799999999999,202.44400000000002]
[null,null,2.7,{"$f":"(929-17.5*D68+7.9*$B69+44*$C$71)*D68/100","v":213.96199999999996},217.86799999999999,220.37399999999997,221.48,221.18599999999998,219.49199999999996,216.398,211.90400000000002]
[null,30,1.7,{"$f":"(929-17.5*D68+7.9*$B72+44*$C72)*D68/100","v":212.65699999999998},216.47299999999998,218.88899999999998,219.905,219.52099999999999,217.73699999999997,214.553,209.96900000000002]
[null,null,2.2000000000000002,{"$f":"(929-17.5*D68+7.9*$B72+44*$C73)*D68/100","v":219.03699999999998},223.29300000000001,226.14899999999997,227.60499999999999,227.66099999999997,226.31699999999998,223.57299999999998,219.429]
[null,null,2.7,{"$f":"(929-17.5*D68+7.9*$B72+44*$C74)*D68/100","v":225.41699999999997},230.113,233.40899999999999,235.30500000000001,235.80099999999999,234.89699999999996,232.59299999999999,228.88899999999998]
[null,35,1.7,{"$f":"(929-17.5*D68+7.9*$B75+44*$C75)*D68/100","v":224.11199999999997},228.71799999999999,231.92399999999998,233.73,234.136,233.14199999999997,230.74799999999999,226.95399999999998]
[null,null,2.2000000000000002,{"$f":"(929-17.5*D68+7.9*$B75+44*$C76)*D68/100","v":230.49199999999996},235.53799999999998,239.18399999999997,241.43,242.27599999999998,241.72199999999998,239.768,236.41399999999999]
[null,null,2.7,{"$f":"(929-17.5*D68+7.9*$B75+44*$C77)*D68/100","v":236.87199999999996},242.358,246.44399999999999,249.13,250.416,250.30199999999996,248.78799999999998,245.87399999999997]
[null,40,1.7,{"$f":"(929-17.5*D68+7.9*$B78+44*$C78)*D68/100","v":235.56699999999998},240.96299999999999,244.95899999999997,247.55500000000001,248.75099999999998,248.54699999999997,246.94299999999998,243.93899999999996]
[null,null,2.2000000000000002,{"$f":"(929-17.5*D68+7.9*$B78+44*$C79)*D68/100","v":241.94699999999997},247.78299999999999,252.21899999999997,255.255,256.89099999999996,257.12699999999995,255.96299999999999,253.39899999999997]
[null,null,2.7,{"$f":"(929-17.5*D68+7.9*$B78+44*$C80)*D68/100","v":248.32699999999997},254.60299999999998,259.47899999999998,262.95499999999998,265.03100000000001,265.70699999999999,264.983,262.85899999999998]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"T grain        ","% T de grain / TMS"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"rdt référence",80]
[null,null,null,null,null,null,null,null,null,null,null,null,"cout référence +- 25%",160,24,null,null,null,null,null,null,null,null,null,"T MS","T Tiges et feuilles","Rafles","grain rafle"]
[null,null,"Grille prix du mais ensilage sur pied (même base de calcul)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,49.2,{"$f":"W87*100/X87","v":7.1138211382113816},{"$f":"Y87-W87","v":3.6138211382113816},{"$f":"AB87-(W87*0.85)","v":1.4875000000000003},{"$f":"(W87*0.85)*1.5","v":4.4625000000000004},{"$f":"AA87/Z87","v":0.41161417322834659}]
[null,"Prix /T (€)",75,{"$f":"C88+5","v":80},{"$f":"D88+5","v":85},90,95,100,105,110,115,120,125,130,135,140,{"$f":"P88+5","v":145},null,null,"coût récolte…","Valeur alimentaire ","coef",4,50,{"$f":"W88*100/X88","v":8},{"$f":"Y88-W88","v":4},{"$f":"AB88-(W88*0.85)","v":1.6999999999999997},{"$f":"(W88*0.85)*1.5","v":5.0999999999999996},{"$f":"AA88/Z88","v":0.42499999999999993}]
[null,"Rdt espéré grain (T)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.5,50.8,8.8582677165354333,4.3582677165354333,1.9125000000000001,5.7374999999999998,0.43882113821138213]
[null,4,{"$f":"(($B90*$C$88)-$T90+$U90)/($B90/$V90*10)","v":35.75},{"$f":"(($B90*D$88)-$T90+$U90)/($B90/$V90*10)","v":38.25},40.75,43.25,45.75,48.25,50.75,53.25,55.75,58.25,60.75,63.25,65.75,68.25,70.75,null,null,{"$f":"((B90*10-$N$85)*1.25)+$N$86","v":110},{"$f":"VLOOKUP(B90,VAlimentaire,4)*$O$86","v":96},{"$f":"(VLOOKUP(B90,VAlimentaire,2))/10","v":5},5.5,52.5,10.476190476190476,4.9761904761904763,2.3374999999999995,7.0124999999999993,0.46973684210526306]
[null,{"$f":"+B90+1","v":5},36.281199999999998,38.821199999999997,41.361199999999997,43.901199999999996,46.441199999999995,48.981199999999994,51.521199999999993,54.061199999999999,56.601199999999999,59.141199999999998,61.681199999999997,64.221199999999996,66.761200000000002,69.301199999999994,71.841200000000001,null,null,122.5,104.5984251968504,5.08,6,53.7,11.173184357541899,5.1731843575418992,2.5499999999999998,7.6499999999999995,0.49292656587472999]
[null,{"$f":"+B91+1","v":6},39.304499999999997,41.9895,44.674500000000002,47.359499999999997,50.044499999999999,52.729500000000002,55.414500000000004,58.099499999999999,60.784500000000001,63.469500000000004,66.154499999999999,68.839500000000001,71.524500000000003,74.209500000000006,76.894500000000008,null,null,135,124.15642458100558,5.37,6.5,54.9,11.839708561020037,5.3397085610200374,2.7625000000000002,8.2874999999999996,0.51735033259423502]
[null,7,40.76,{"$f":"(($B93*$D$88)-$T93+$U93)/($B93/$V93*10)","v":43.56},{"$f":"(($B93*E88)-$T93+$U93)/($B93/$V93*10)","v":46.36},49.16,51.96,54.76,57.56,60.36,63.16,65.959999999999994,68.760000000000005,71.56,74.36,77.16,79.959999999999994,null,null,147.5,132,5.6,7,56,12.5,5.5,2.9750000000000005,8.9250000000000007,0.54090909090909101]
[null,8,41.856000000000002,44.736000000000004,{"$f":"(($B94*E88)-$T94+$U94)/($B94/$V94*10)","v":47.616},50.496000000000002,53.375999999999998,56.256,59.136000000000003,62.015999999999998,64.896000000000001,67.775999999999996,70.656000000000006,73.536000000000001,76.415999999999997,79.295999999999992,82.175999999999988,null,null,160,141.33333333333334,5.76,7.5,56.8,13.204225352112676,5.704225352112676,3.1875,9.5625,0.55879629629629635]
[null,9,42.781666666666673,45.731666666666669,{"$f":"(($B95*E88)-$T95+$U95)/($B95/$V95*10)","v":48.681666666666672},51.631666666666675,54.581666666666671,57.531666666666673,60.481666666666676,63.431666666666672,66.381666666666675,69.331666666666678,72.28166666666668,75.231666666666669,78.181666666666672,81.131666666666675,84.081666666666678,null,null,172.5,150.10169491525426,5.9,8,57.6,13.888888888888889,5.8888888888888893,3.3999999999999995,10.199999999999999,0.57735849056603761]
[null,10,43.5,46.5,{"$f":"(($B96*E88)-$T96+$U96)/($B96/$V96*10)","v":49.5},52.499999999999993,55.499999999999993,58.499999999999993,61.499999999999993,64.5,67.5,70.5,73.5,76.5,79.5,82.5,85.5,null,null,185,160.00000000000003,6,8.5,58.5,14.52991452991453,6.0299145299145298,3.6124999999999989,10.837499999999999,0.59909638554216849]
[null,11,44.157727272727271,47.207727272727276,{"$f":"(($B97*E88)-$T97+$U97)/($B97/$V97*10)","v":50.257727272727273},53.307727272727277,56.357727272727274,59.407727272727278,62.457727272727276,65.50772727272728,68.557727272727277,71.607727272727274,74.657727272727271,77.707727272727269,80.75772727272728,83.807727272727277,86.857727272727274,null,null,197.5,168.78688524590163,6.1,9,59,15.254237288135593,6.2542372881355934,3.8250000000000002,11.475,0.61158536585365852]
[null,12,44.77,47.870000000000005,{"$f":"(($B98*E$88)-$T98+$U98)/($B98/$V98*10)","v":50.970000000000006},{"$f":"(($B98*F88)-$T98+$U98)/($B98/$V98*10)","v":54.070000000000007},57.170000000000009,60.27000000000001,63.370000000000012,66.470000000000013,69.570000000000007,72.670000000000016,75.77000000000001,78.87,81.970000000000013,85.070000000000007,88.170000000000016,null,null,210,176.51612903225808,6.2,9.5,59.5,15.966386554621849,6.4663865546218489,4.0374999999999996,12.112499999999999,0.62438271604938267]
[null,13,45.347307692307695,48.497307692307693,{"$f":"(($B99*E$88)-$T99+$U99)/($B99/$V99*10)","v":51.647307692307685},{"$f":"(($B99*F$88)-$T99+$U99)/($B99/$V99*10)","v":54.797307692307683},57.947307692307689,61.097307692307687,64.247307692307686,67.397307692307692,70.547307692307683,73.697307692307689,76.84730769230768,79.997307692307686,83.147307692307677,86.297307692307683,89.447307692307689,null,null,222.5,183.23809523809527,6.3,10,60,16.666666666666668,6.6666666666666679,4.25,12.75,0.63749999999999984]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.5,60.5,17.355371900826448,6.855371900826448,4.4625000000000004,13.387499999999999,0.65094936708860751]
[null,"Exemple : pour un rendement grain de ",null,null,{"$f":"B94","v":8},"et un prix de ",null,{"$f":"H88","v":100},"sec  payé au moment de la récolte, le prix de parité est  de ",null,null,null,null,null,{"$f":"H94","v":56.256}," par tonne ",null,null,null,null,null,null,11,61,{"$f":"W101*100/X101","v":18.032786885245901},{"$f":"Y101-W101","v":7.0327868852459012},4.6749999999999989,14.024999999999999,0.6647435897435896]
[null,"de matière seche. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.5,61.5,{"$f":"W102*100/X102","v":18.699186991869919},{"$f":"Y102-W102","v":7.1991869918699187},4.8875000000000011,14.662500000000001,0.678896103896104]
[null,"Ensuite il faut estimer le rendement en matière sèche. La pésée des remorques et l'analyse d'une matière sèche demeurent la solution la plus juste.  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,62,{"$f":"W103*100/X103","v":19.35483870967742},{"$f":"Y103-W103","v":7.3548387096774199},5.0999999999999996,15.299999999999999,0.69342105263157883]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.5,62.5,{"$f":"W104*100/X104","v":20},{"$f":"Y104-W104","v":7.5},5.3125,15.9375,0.70833333333333337]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,63,{"$f":"W105*100/X105","v":20.634920634920636},{"$f":"Y105-W105","v":7.6349206349206362},5.5250000000000004,16.574999999999999,0.72364864864864853]
[]
[]
[null,"Prix parité du mais épi"]
[null,null,null,"La variabilité est dans l’appréciation de la part de rendement grain, rafle, tige et feuilles"]
[]
[null,"ensilage épi = 65% du mais ensilage"]
[null,"ou 1.5 fois le rdt grain à 15 % d'eau"]
[null,null,null,null,null,"prix du grain net séchage",null,null,100,130,"cout récolte"]
[]
[null,null,null,null,"rdt","Rdt 100 MS"]
[null,null,"ensilage plante entière",null,10.5,{"$f":"E116","v":10.5},55,72,{"$f":"G116*E116","v":577.5},{"$f":"H116*E116","v":756}]
[null,null,"ensilage épi = 65% ensilage",null,{"$f":"E116*0.65","v":6.8250000000000002},{"$f":"E117","v":6.8250000000000002},{"$f":"G116/0.65","v":84.615384615384613},null,{"$f":"G117*F117","v":577.5}]
[null,null,"ensilage épi = 1.5 fois le grain",null,{"$f":"+E119*1.5","v":8.25},{"$f":"+F119*1.5","v":7.0124999999999993},{"$f":"G119/1.5","v":78.431372549019613},{"$f":"H119/1.5","v":101.96078431372548},{"$f":"G118*F118","v":550},{"$f":"H118*F118","v":714.99999999999989}]
[null,null,"grain",null,5.5,{"$f":"E119*0.85","v":4.6749999999999998},{"$f":"I113/0.85","v":117.64705882352942},{"$f":"J113/0.85","v":152.94117647058823},{"$f":"G119*F119","v":550},{"$f":"H119*F119","v":715}]
[null,null,"Grain/ plante entière",null,{"$f":"E119/E116","v":0.52380952380952384}]
[]
[]
[]
[]
[]
[null,null,null,null,"Prix grain à 15% d'humidité",90,100,110,120,130,140]
[null,null,"Cout récolte- rafle exportée","Rdt grain 15% eau (en T)","Rendement épi (TMS)","Prix /ha selon prix du grain, rendement"]
[null,null,60,5,{"$f":"+D128*1.5*0.85","v":6.375},{"$f":"(F$126*0.85*$E128)-$C128","v":427.6875},{"$f":"(G$126*0.85*$E128)-$C128","v":481.875},536.0625,590.25,644.4375,698.625]
[null,null,65,6,{"$f":"+D129*0.85*1.5","v":7.6499999999999995},{"$f":"(F$126*0.85*$E129)-$C129","v":520.22499999999991},585.25,650.27499999999998,715.3,780.32499999999993,845.34999999999991]
[null,null,70,7,{"$f":"+D130*1.5*0.85","v":8.9249999999999989},612.76249999999993,688.62499999999989,764.48749999999995,840.34999999999991,916.21249999999986,992.07499999999982]
[null,null,75,8,10.199999999999999,705.3,791.99999999999989,878.69999999999993,965.39999999999986,1052.0999999999999,1138.8]
[null,null,80,9,11.475,797.83749999999998,895.375,992.91249999999991,1090.45,1187.9875,1285.5249999999999]
[null,null,90,10,12.75,885.375,993.75,1102.125,1210.5,1318.875,1427.25]
[]
[]
[null,null,null,"Prix grain à 15% d'humidité",null,90,100,110,120,130,140]
[null,null,"Cout récolte- rafle exportée","Rdt grain 15% eau (en T)","Rendement épi (TMS)","Prix /TMS selon prix du grain et le rendement"]
[null,null,60,5,{"$f":"+D138*1.5*0.85","v":6.375},{"$f":"((F$126*0.85*$E138)-$C138)/$E138","v":67.088235294117652},{"$f":"((G$126*0.85*$E138)-$C138)/$E138","v":75.588235294117652},84.088235294117652,92.588235294117652,101.08823529411765,109.58823529411765]
[null,null,65,6,{"$f":"+D139*0.85*1.5","v":7.6499999999999995},68.003267973856197,76.503267973856211,85.003267973856211,93.503267973856211,102.00326797385621,110.50326797385621]
[null,null,70,7,{"$f":"+D140*1.5*0.85","v":8.9249999999999989},68.656862745098039,77.156862745098039,85.656862745098039,94.156862745098039,102.65686274509804,111.15686274509804]
[null,null,75,8,10.199999999999999,69.147058823529406,77.647058823529406,86.147058823529406,94.647058823529406,103.14705882352941,111.64705882352942]
[null,null,80,9,11.475,69.528322440087152,78.028322440087152,86.528322440087138,95.028322440087152,103.52832244008715,112.02832244008714]
[null,null,85,10,12.75,69.833333333333329,78.333333333333329,86.833333333333329,95.333333333333329,103.83333333333333,112.33333333333333]

{"sheet":"Herbe","index":2,"n_rows":90,"n_cols":36,"rows_kept":90,"cut":false,"hidden":false,"merged":[[50,9,50,10],[57,1,59,1],[37,1,37,4],[38,1,38,4],[39,1,39,4],[52,9,52,10],[51,9,51,10],[55,1,55,2],[49,9,49,10],[55,3,55,6],[56,1,56,2],[36,1,36,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[27,1,27,4],[28,1,28,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[5,25,5,29],[1,2,1,8],[14,4,15,4],[14,9,14,10],[16,9,16,10],[15,9,15,10],[11,9,12,10],[11,8,12,8],[11,7,12,7],[11,6,12,6],[13,9,13,10],[52,11,52,12],[51,11,51,12],[50,11,50,12],[49,11,49,12],[0,2,0,8],[17,7,17,8],[14,1,15,2],[14,3,15,3],[46,9,48,12],[17,11,18,11],[17,10,18,10],[19,1,19,4],[20,1,20,4],[17,9,18,9],[25,1,25,4],[26,1,26,4]]}
[null,null,"Prix des fourrages (herbe)",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,"oui"]
[null,null,"selon la parité paille blé soja",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,"non"]
[]
[]
[]
[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,"Valeur récolte"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aliment",null,"Tx MS","UFL","UFV","(UFL+UFV)/2","PDIN","PDIE","Perte récolte","Cout récolte","% MS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C5","v":"Betteraves fourragères"},{"$f":"'Valeur aliments'!B5","v":0},{"$f":"AG8","v":1},{"$f":"'Valeur aliments'!E5","v":1.1499999999999999},{"$f":"'Valeur aliments'!F5","v":1.1599999999999999},{"$f":"(Z8+AA8)/2","v":1.1549999999999998},{"$f":"'Valeur aliments'!H5","v":62},{"$f":"'Valeur aliments'!I5","v":86},{"$f":"'Valeur aliments'!N5/100","v":7.0000000000000007E-2},{"$f":"'Valeur aliments'!O5","v":50},{"$f":"'Valeur aliments'!P5","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C6","v":"choux moelliers"},{"$f":"'Valeur aliments'!B6","v":0},{"$f":"AG9","v":0},{"$f":"'Valeur aliments'!E6","v":1.03},{"$f":"'Valeur aliments'!F6","v":1.01},{"$f":"(Z9+AA9)/2","v":1.02},{"$f":"'Valeur aliments'!H6","v":104},{"$f":"'Valeur aliments'!I6","v":98},{"$f":"'Valeur aliments'!N6/100","v":0},{"$f":"'Valeur aliments'!O6","v":0},{"$f":"'Valeur aliments'!P6","v":0}]
[null,null,null,null,null,null,"Cout récolte en Euros",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C7","v":"enruba dactyle mi-fané début floraison  1èr cycle"},{"$f":"'Valeur aliments'!B7","v":"enru"},1,{"$f":"'Valeur aliments'!E7","v":0.66},{"$f":"'Valeur aliments'!F7","v":0.59},0.625,{"$f":"'Valeur aliments'!H7","v":70},{"$f":"'Valeur aliments'!I7","v":71},{"$f":"'Valeur aliments'!N7/100","v":0.1},{"$f":"'Valeur aliments'!O7","v":54},{"$f":"'Valeur aliments'!P7","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C8","v":"enruba dactyle mi-fané fin épiaison  1èr cycle"},{"$f":"'Valeur aliments'!B8","v":"enru"},1,{"$f":"'Valeur aliments'!E8","v":0.72},{"$f":"'Valeur aliments'!F8","v":0.64},0.67999999999999994,{"$f":"'Valeur aliments'!H8","v":77},{"$f":"'Valeur aliments'!I8","v":74},{"$f":"'Valeur aliments'!N8/100","v":0.1},{"$f":"'Valeur aliments'!O8","v":54},{"$f":"'Valeur aliments'!P8","v":1}]
[null,null,null,null,null,null,null,"Ensilage herbe","Enrubannage","Foin",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C9","v":"enruba fétuque mi-fané début floraison  1èr cycle"},{"$f":"'Valeur aliments'!B9","v":"enru"},1,{"$f":"'Valeur aliments'!E9","v":0.61},{"$f":"'Valeur aliments'!F9","v":0.51},0.56000000000000005,{"$f":"'Valeur aliments'!H9","v":64},{"$f":"'Valeur aliments'!I9","v":64},{"$f":"'Valeur aliments'!N9/100","v":0.1},{"$f":"'Valeur aliments'!O9","v":54},{"$f":"'Valeur aliments'!P9","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C10","v":"enruba fétuque mi-fané fin épiaison  1èr cycle"},{"$f":"'Valeur aliments'!B10","v":"enru"},1,{"$f":"'Valeur aliments'!E10","v":0.67},{"$f":"'Valeur aliments'!F10","v":0.59},0.63,{"$f":"'Valeur aliments'!H10","v":66},{"$f":"'Valeur aliments'!I10","v":68},{"$f":"'Valeur aliments'!N10/100","v":0.1},{"$f":"'Valeur aliments'!O10","v":54},{"$f":"'Valeur aliments'!P10","v":1}]
[null,"Prix des aliments de référence, en euros par tonne brute",null,null,null,null,"Rendement",5,5,5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C11","v":"enruba luzerne mi-fané début floraison  1èr cycle"},{"$f":"'Valeur aliments'!B11","v":"enru"},1,{"$f":"'Valeur aliments'!E11","v":0.67},{"$f":"'Valeur aliments'!F11","v":0.56999999999999995},0.62,{"$f":"'Valeur aliments'!H11","v":105},{"$f":"'Valeur aliments'!I11","v":75},{"$f":"'Valeur aliments'!N11/100","v":0.1},{"$f":"'Valeur aliments'!O11","v":54},{"$f":"'Valeur aliments'!P11","v":1}]
[null,"Tourteau de Soja 48 €/T",null,"Blé €/T","Paille €/T",null,"Cout / T",42,44,40,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C12","v":"enruba luzerne mi-fané fin bourgeonnement 1èr cycle"},{"$f":"'Valeur aliments'!B12","v":"enru"},1,{"$f":"'Valeur aliments'!E12","v":0.71},{"$f":"'Valeur aliments'!F12","v":0.62},0.66500000000000004,{"$f":"'Valeur aliments'!H12","v":113},{"$f":"'Valeur aliments'!I12","v":79},{"$f":"'Valeur aliments'!N12/100","v":0.1},{"$f":"'Valeur aliments'!O12","v":54},{"$f":"'Valeur aliments'!P12","v":1}]
[null,null,null,null,null,null,"Temps travail","3h","3h3","3h3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C13","v":"enruba rga mi-fané début floraison  1èr cycle"},{"$f":"'Valeur aliments'!B13","v":"enru"},1,{"$f":"'Valeur aliments'!E13","v":0.7},{"$f":"'Valeur aliments'!F13","v":0.62},0.65999999999999992,{"$f":"'Valeur aliments'!H13","v":66},{"$f":"'Valeur aliments'!I13","v":71},{"$f":"'Valeur aliments'!N13/100","v":0.1},{"$f":"'Valeur aliments'!O13","v":54},{"$f":"'Valeur aliments'!P13","v":1}]
[null,400,null,150,65,null,"Cout / T (18€/h)",{"$f":"3*18/H14","v":10.8},{"$f":"3.5*18/I14","v":12.6},{"$f":"3.5*18/J14","v":12.6},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C14","v":"enruba rga mi-fané fin épiaison  1èr cycle"},{"$f":"'Valeur aliments'!B14","v":"enru"},1,{"$f":"'Valeur aliments'!E14","v":0.76},{"$f":"'Valeur aliments'!F14","v":0.69},0.72499999999999998,{"$f":"'Valeur aliments'!H14","v":68},{"$f":"'Valeur aliments'!I14","v":74},{"$f":"'Valeur aliments'!N14/100","v":0.1},{"$f":"'Valeur aliments'!O14","v":54},{"$f":"'Valeur aliments'!P14","v":1}]
[null," Récolte à la charge de l'acheteur",null,null,null,null,null,"Valeurs alimentaires du fourrage",null,"Cout récolte","Tx MS","% perte",null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C15","v":"enruba rgi mi-fané début floraison  1èr cycle"},{"$f":"'Valeur aliments'!B15","v":"enru"},1,{"$f":"'Valeur aliments'!E15","v":0.68},{"$f":"'Valeur aliments'!F15","v":0.6},0.64,{"$f":"'Valeur aliments'!H15","v":46},{"$f":"'Valeur aliments'!I15","v":63},{"$f":"'Valeur aliments'!N15/100","v":0.1},{"$f":"'Valeur aliments'!O15","v":54},{"$f":"'Valeur aliments'!P15","v":1}]
[null,"Prix des fourrages (récolte déduite)",null,null,null,"T MS","T brute","UF/kg MS","PDIN/kg MS",null,null,null,null,null,"UF",null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C16","v":"enruba rgi mi-fané fin épiaison  1èr cycle"},{"$f":"'Valeur aliments'!B16","v":"enru"},1,{"$f":"'Valeur aliments'!E16","v":0.72},{"$f":"'Valeur aliments'!F16","v":0.64},0.67999999999999994,{"$f":"'Valeur aliments'!H16","v":52},{"$f":"'Valeur aliments'!I16","v":67},{"$f":"'Valeur aliments'!N16/100","v":0.1},{"$f":"'Valeur aliments'!O16","v":54},{"$f":"'Valeur aliments'!P16","v":1}]
[null,"Ens. RGA dé épiaison coupe fine 35% ms",null,null,null,{"$f":"IF(VLOOKUP(B20,Table6,2)=\"foin\",\"\",(((M20*$B$17/0.88+O20*$D$17/0.85+P20*$E$17/0.88)-J20)*(1-L20)*K20))","v":104.26383943801945},{"$f":"IF(VLOOKUP(B20,Table6,2)=\"foin\",(((M20*$B$17/0.85+O20*$D$17/0.85+P20*$E$17/0.88)-J20)*(1-L20)*K20),\"\")","v":""},{"$f":"VLOOKUP(B20,Table6,6)","v":0.86499999999999999},{"$f":"VLOOKUP(B20,Table6,7)","v":90},{"$f":"VLOOKUP($B20,Table6,10)","v":50},{"$f":"VLOOKUP($B20,Table6,3)","v":1},{"$f":"VLOOKUP($B20,Table6,9)","v":0.1},{"$f":"1-O20-P20","v":0.11100083369724784},null,{"$f":"(1.18-H20-(1.18-0.365)*P20)/(1.18-1.21)","v":0.48465600063519887},{"$f":"(((1.18-H20)*(377-81))-((377-I20)*(1.18-1.21)))/(((1.18-0.365)*(377-81))-((377-22)*(1.18-1.21)))","v":0.40434316566755329},null,null,null,null,null,null,{"$f":"'Valeur aliments'!C17","v":"Ens blé laiteux pateux 35%"},{"$f":"'Valeur aliments'!B17","v":"ensi"},1,{"$f":"'Valeur aliments'!E17","v":0.64},{"$f":"'Valeur aliments'!F17","v":0.55000000000000004},0.59499999999999997,{"$f":"'Valeur aliments'!H17","v":60},{"$f":"'Valeur aliments'!I17","v":60},{"$f":"'Valeur aliments'!N17/100","v":0.1},{"$f":"'Valeur aliments'!O17","v":42},{"$f":"'Valeur aliments'!P17","v":1}]
[null,"Ens. RGA fin épiaison coupe fine 35% ms",null,null,null,81.01553246759326,"",0.74,70,50,1,0.1,{"$f":"1-O21-P21","v":7.3186708483862439E-2},null,0.37319861844455871,0.55361467307157886,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C18","v":"Ens mais 30 % ms (pateux)"},{"$f":"'Valeur aliments'!B18","v":"ensi"},1,{"$f":"'Valeur aliments'!E18","v":0.9},{"$f":"'Valeur aliments'!F18","v":0.8},0.85000000000000009,{"$f":"'Valeur aliments'!H18","v":42},{"$f":"'Valeur aliments'!I18","v":65},{"$f":"'Valeur aliments'!N18/100","v":7.0000000000000007E-2},{"$f":"'Valeur aliments'!O18","v":30},{"$f":"'Valeur aliments'!P18","v":1}]
[null,"Ens. RGI dé épiaison coupe fine 35% ms",null,null,null,91.20939087663065,"",0.8,70,42,1,0.1,{"$f":"1-O22-P22","v":5.9132954861249809E-2},null,0.45775933939417918,0.48310770574457096,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C19","v":"Ens mais 35 % ms (vitreux)"},{"$f":"'Valeur aliments'!B19","v":"ensi"},1,{"$f":"'Valeur aliments'!E19","v":0.91},{"$f":"'Valeur aliments'!F19","v":0.81},0.8600000000000001,{"$f":"'Valeur aliments'!H19","v":42},{"$f":"'Valeur aliments'!I19","v":67},{"$f":"'Valeur aliments'!N19/100","v":7.0000000000000007E-2},{"$f":"'Valeur aliments'!O19","v":30},{"$f":"'Valeur aliments'!P19","v":1}]
[null,"Ens. RGI fin épiaison coupe fine 35% ms",null,null,null,68.211898793781955,"",0.70500000000000007,57,50,1,0.1,{"$f":"1-O23-P23","v":3.7774425344395679E-2},null,0.36593354241931075,0.59629203223629357,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C20","v":"Ens mais 35 % ms (vitreux) % épis >65"},{"$f":"'Valeur aliments'!B20","v":"ensi"},1,{"$f":"'Valeur aliments'!E20","v":0.96},{"$f":"'Valeur aliments'!F20","v":0.87},0.91500000000000004,{"$f":"'Valeur aliments'!H20","v":50},{"$f":"'Valeur aliments'!I20","v":71},{"$f":"'Valeur aliments'!N20/100","v":7.0000000000000007E-2},{"$f":"'Valeur aliments'!O20","v":30},{"$f":"'Valeur aliments'!P20","v":1}]
[null,"Ens. Fétuque dé épiaison c. fine 35 % Ms",null,null,null,96.777866728601268,"",0.69,83,42,1,0.1,0.12850847592202941,null,0.26066933979117868,0.61082218428679191,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C21","v":"Ens orge laiteux pateux 35%"},{"$f":"'Valeur aliments'!B21","v":"ensi"},0,{"$f":"'Valeur aliments'!E21","v":0.69},{"$f":"'Valeur aliments'!F21","v":0.6},0.64500000000000002,{"$f":"'Valeur aliments'!H21","v":50},{"$f":"'Valeur aliments'!I21","v":58},{"$f":"'Valeur aliments'!N21/100","v":0},{"$f":"'Valeur aliments'!O21","v":0},{"$f":"'Valeur aliments'!P21","v":0}]
[null,"Ens. Dactyle dé épiaison c. fine 35 % Ms",null,null,null,131.77691193082958,"",0.8,100,30,1,7.0000000000000007E-2,0.15977212275199465,null,0.36069315971257332,0.47953471753543203,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C22","v":"Ens. Dactyle dé épiaison c. fine 35 % Ms"},{"$f":"'Valeur aliments'!B22","v":"ensi"},1,{"$f":"'Valeur aliments'!E22","v":0.83},{"$f":"'Valeur aliments'!F22","v":0.77},0.8,{"$f":"'Valeur aliments'!H22","v":100},{"$f":"'Valeur aliments'!I22","v":71},{"$f":"'Valeur aliments'!N22/100","v":7.0000000000000007E-2},{"$f":"'Valeur aliments'!O22","v":30},{"$f":"'Valeur aliments'!P22","v":1}]
[null,"Ens. Dactyle fin épiaison c. fine 35 % Ms",null,null,null,106.76926094872563,"",0.69,78,30,1,7.0000000000000007E-2,0.11173528127357424,null,0.27684703640477754,0.61141768232164828,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C23","v":"Ens. Dactyle fin épiaison c. fine 35 % Ms"},{"$f":"'Valeur aliments'!B23","v":"ensi"},1,{"$f":"'Valeur aliments'!E23","v":0.73},{"$f":"'Valeur aliments'!F23","v":0.65},0.69,{"$f":"'Valeur aliments'!H23","v":78},{"$f":"'Valeur aliments'!I23","v":63},{"$f":"'Valeur aliments'!N23/100","v":7.0000000000000007E-2},{"$f":"'Valeur aliments'!O23","v":30},{"$f":"'Valeur aliments'!P23","v":1}]
[null,"Ens. Fétuque fin épiaison c. fine 35 % Ms",null,null,null,74.426748752691779,{"$f":"IF(VLOOKUP(B27,Table6,2)=\"foin\",(((M27*$B$17/0.85+O27*$D$17/0.85+P27*$E$17/0.88)-J27)*(1-L27)*K27),\"\")","v":""},0.625,69,50,1,0.1,9.6768430664179172E-2,null,0.21435944261383899,0.68887212672198184,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C24","v":"Ens. Fétuque dé épiaison c. fine 35 % Ms"},{"$f":"'Valeur aliments'!B24","v":"ensi"},1,{"$f":"'Valeur aliments'!E24","v":0.73},{"$f":"'Valeur aliments'!F24","v":0.65},0.69,{"$f":"'Valeur aliments'!H24","v":83},{"$f":"'Valeur aliments'!I24","v":63},{"$f":"'Valeur aliments'!N24/100","v":0.1},{"$f":"'Valeur aliments'!O24","v":42},{"$f":"'Valeur aliments'!P24","v":1}]
[null,"Foin Dactyle floraison 1 cycle beau tps",null,null,null,"",57.850125438051158,0.55499999999999994,60,50,0.85,0.05,8.2972726190000179E-2,null,0.14482512207710044,0.77220215173289941,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C25","v":"Ens. Fétuque fin épiaison c. fine 35 % Ms"},{"$f":"'Valeur aliments'!B25","v":"ensi"},1,{"$f":"'Valeur aliments'!E25","v":0.67},{"$f":"'Valeur aliments'!F25","v":0.57999999999999996},0.625,{"$f":"'Valeur aliments'!H25","v":69},{"$f":"'Valeur aliments'!I25","v":58},{"$f":"'Valeur aliments'!N25/100","v":0.1},{"$f":"'Valeur aliments'!O25","v":50},{"$f":"'Valeur aliments'!P25","v":1}]
[null,"Foin Rga floraison 1 er cycle beau tps ",null,null,null,{"$f":"IF(VLOOKUP(B29,Table6,2)=\"foin\",\"\",(((M29*$B$17/0.88+O29*$D$17/0.85+P29*$E$17/0.88)-J29)*(1-L29)*K29))","v":""},{"$f":"IF(VLOOKUP(B29,Table6,2)=\"foin\",(((M29*$B$17/0.85+O29*$D$17/0.85+P29*$E$17/0.88)-J29)*(1-L29)*K29),\"\")","v":58.712928217222853},0.59499999999999997,59,50,0.85,0.05,7.0248918178568376E-2,null,0.20443447536623285,0.7253166064551988,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C26","v":"Ens. luzerne Bourgeon 55%"},{"$f":"'Valeur aliments'!B26","v":"ensi"},1,{"$f":"'Valeur aliments'!E26","v":0.71},{"$f":"'Valeur aliments'!F26","v":0.62},0.66500000000000004,{"$f":"'Valeur aliments'!H26","v":113},{"$f":"'Valeur aliments'!I26","v":79},{"$f":"'Valeur aliments'!N26/100","v":0.1},{"$f":"'Valeur aliments'!O26","v":50},{"$f":"'Valeur aliments'!P26","v":1}]
[null,"Foin PP floraison beau tps",null,null,null,{"$f":"IF(VLOOKUP(B30,Table6,2)=\"foin\",\"\",(((M30*$B$17/0.88+O30*$D$17/0.85+P30*$E$17/0.88)-J30)*(1-L30)*K30))","v":""},57.280309383784889,0.58000000000000007,58,50,0.85,0.05,7.0407717654527691E-2,null,0.18652983445155039,0.74306244789392195,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C27","v":"ens. mélange imma triticale pois"},{"$f":"'Valeur aliments'!B27","v":"ensi"},1,{"$f":"'Valeur aliments'!E27","v":0.75},{"$f":"'Valeur aliments'!F27","v":0.75},0.75,{"$f":"'Valeur aliments'!H27","v":65},{"$f":"'Valeur aliments'!I27","v":70},{"$f":"'Valeur aliments'!N27/100","v":0.1},{"$f":"'Valeur aliments'!O27","v":50},{"$f":"'Valeur aliments'!P27","v":1}]
[null,"Foin Fétuque floraison 1 cycle beau tps",null,null,null,"",55.582807836392824,0.52,59,50,0.85,0.05,8.7816110206834663E-2,null,9.8733574179206793E-2,0.81345031561395853,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C28","v":"Ens. RGA dé épiaison coupe fine 35% ms"},{"$f":"'Valeur aliments'!B28","v":"ensi"},1,{"$f":"'Valeur aliments'!E28","v":0.89},{"$f":"'Valeur aliments'!F28","v":0.84},0.86499999999999999,{"$f":"'Valeur aliments'!H28","v":90},{"$f":"'Valeur aliments'!I28","v":73},{"$f":"'Valeur aliments'!N28/100","v":0.1},{"$f":"'Valeur aliments'!O28","v":50},{"$f":"'Valeur aliments'!P28","v":1}]
[null,"Foin Rgi floraison 1 cycle beau tps",null,null,null,"",38.909200647648746,0.56499999999999995,36,50,0.85,0.05,1.1909960696931954E-4,null,0.23657151931398812,0.76330938107904256,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C29","v":"Ens. RGA fin épiaison coupe fine 35% ms"},{"$f":"'Valeur aliments'!B29","v":"ensi"},1,{"$f":"'Valeur aliments'!E29","v":0.78},{"$f":"'Valeur aliments'!F29","v":0.7},0.74,{"$f":"'Valeur aliments'!H29","v":70},{"$f":"'Valeur aliments'!I29","v":64},{"$f":"'Valeur aliments'!N29/100","v":0.1},{"$f":"'Valeur aliments'!O29","v":50},{"$f":"'Valeur aliments'!P29","v":1}]
[null,"Foin Rga 2 em cycle beau tps",null,null,null,"",78.420397138541773,0.7,78,50,0.85,0.05,0.10939298900313654,null,0.2909404898963831,0.59966652110048035,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C30","v":"Ens. RGI dé épiaison coupe fine 35% ms"},{"$f":"'Valeur aliments'!B30","v":"ensi"},1,{"$f":"'Valeur aliments'!E30","v":0.83},{"$f":"'Valeur aliments'!F30","v":0.77},0.8,{"$f":"'Valeur aliments'!H30","v":70},{"$f":"'Valeur aliments'!I30","v":65},{"$f":"'Valeur aliments'!N30/100","v":0.1},{"$f":"'Valeur aliments'!O30","v":42},{"$f":"'Valeur aliments'!P30","v":1}]
[null,"Foin Fétuque 2 em cycle beau tps",null,null,null,"",81.173218761616283,0.64999999999999991,84,50,0.85,0.05,0.14123228393346121,null,0.20105998650204626,0.65770772956449253,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C31","v":"Ens. RGI fin épiaison coupe fine 35% ms"},{"$f":"'Valeur aliments'!B31","v":"ensi"},1,{"$f":"'Valeur aliments'!E31","v":0.74},{"$f":"'Valeur aliments'!F31","v":0.67},0.70500000000000007,{"$f":"'Valeur aliments'!H31","v":57},{"$f":"'Valeur aliments'!I31","v":59},{"$f":"'Valeur aliments'!N31/100","v":0.1},{"$f":"'Valeur aliments'!O31","v":50},{"$f":"'Valeur aliments'!P31","v":1}]
[null,"Foin Dactyle 2 em cycle beau tps",null,null,null,"",83.211775116482386,0.65500000000000003,92,50,0.85,0.1,0.16689824923577457,null,0.18222239866608742,0.65087935209813808,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C32","v":"Ens. trèfle violet Bourgeon 55%"},{"$f":"'Valeur aliments'!B32","v":"ensi"},1,{"$f":"'Valeur aliments'!E32","v":0.77},{"$f":"'Valeur aliments'!F32","v":0.7},0.73499999999999999,{"$f":"'Valeur aliments'!H32","v":104},{"$f":"'Valeur aliments'!I32","v":80},{"$f":"'Valeur aliments'!N32/100","v":0.1},{"$f":"'Valeur aliments'!O32","v":50},{"$f":"'Valeur aliments'!P32","v":1}]
[null,"Foin Rgi 2 em cycle beau tps",null,null,null,"",74.929135395500751,0.65500000000000003,76,50,0.85,0.05,0.11322402636071227,null,0.23399102782960884,0.65278494580967883,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C33","v":"Foin 75% RGA 25% TB"},{"$f":"'Valeur aliments'!B33","v":"foin"},0.85,{"$f":"'Valeur aliments'!E33","v":0.7},{"$f":"'Valeur aliments'!F33","v":0.62},0.65999999999999992,{"$f":"'Valeur aliments'!H33","v":74},{"$f":"'Valeur aliments'!I33","v":76},{"$f":"'Valeur aliments'!N33/100","v":0.1},{"$f":"'Valeur aliments'!O33","v":50},{"$f":"'Valeur aliments'!P33","v":0.85}]
[null,"Foin Luzerne  2 em cycle beau tps",null,null,null,"",104.92560808469715,0.62,115,50,0.85,0.05,0.25225296756520399,null,5.8477907022909802E-2,0.68926912541188623,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C34","v":"foin avoine laiteux pâteux"},{"$f":"'Valeur aliments'!B34","v":"foin"},0.85,{"$f":"'Valeur aliments'!E34","v":0.67},{"$f":"'Valeur aliments'!F34","v":0.57999999999999996},0.625,{"$f":"'Valeur aliments'!H34","v":42},{"$f":"'Valeur aliments'!I34","v":62},{"$f":"'Valeur aliments'!N34/100","v":0.1},{"$f":"'Valeur aliments'!O34","v":50},{"$f":"'Valeur aliments'!P34","v":0.85}]
[null,"foin trèfle floraison",null,null,null,"",83.897936373740833,0.58000000000000007,91,50,0.85,0.05,0.18111080233434829,null,7.9757036801782588E-2,0.73913216086386913,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C35","v":"Foin Dactyle 2 em cycle beau tps"},{"$f":"'Valeur aliments'!B35","v":"foin"},0.85,{"$f":"'Valeur aliments'!E35","v":0.7},{"$f":"'Valeur aliments'!F35","v":0.61},0.65500000000000003,{"$f":"'Valeur aliments'!H35","v":92},{"$f":"'Valeur aliments'!I35","v":89},{"$f":"'Valeur aliments'!N35/100","v":0.1},{"$f":"'Valeur aliments'!O35","v":50},{"$f":"'Valeur aliments'!P35","v":0.85}]
[null,"Foin Luzerne floraison 1 cycle beau tps",null,null,null,"",96.386103105972822,0.57000000000000006,107,50,0.85,0.05,0.23712731747984994,null,1.3894954146653747E-2,0.7489777283734963,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C36","v":"Foin Dactyle épiaison  1 cycle beau tps"},{"$f":"'Valeur aliments'!B36","v":"foin"},0.85,{"$f":"'Valeur aliments'!E36","v":0.76},{"$f":"'Valeur aliments'!F36","v":0.68},0.72,{"$f":"'Valeur aliments'!H36","v":91},{"$f":"'Valeur aliments'!I36","v":89},{"$f":"'Valeur aliments'!N36/100","v":0.05},{"$f":"'Valeur aliments'!O36","v":50},{"$f":"'Valeur aliments'!P36","v":0.85}]
[null,"Foin 75% RGA 25% TB",null,null,null,"",69.654903700749344,0.65999999999999992,74,50,0.85,0.1,0.10534360236611107,null,0.24750883322085135,0.64714756441303756,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C37","v":"Foin Dactyle floraison 1 cycle beau tps"},{"$f":"'Valeur aliments'!B37","v":"foin"},0.85,{"$f":"'Valeur aliments'!E37","v":0.6},{"$f":"'Valeur aliments'!F37","v":0.51},0.55499999999999994,{"$f":"'Valeur aliments'!H37","v":60},{"$f":"'Valeur aliments'!I37","v":71},{"$f":"'Valeur aliments'!N37/100","v":0.05},{"$f":"'Valeur aliments'!O37","v":50},{"$f":"'Valeur aliments'!P37","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C38","v":"Foin Fétuque 2 em cycle beau tps"},{"$f":"'Valeur aliments'!B38","v":"foin"},0.85,{"$f":"'Valeur aliments'!E38","v":0.69},{"$f":"'Valeur aliments'!F38","v":0.61},0.64999999999999991,{"$f":"'Valeur aliments'!H38","v":84},{"$f":"'Valeur aliments'!I38","v":85},{"$f":"'Valeur aliments'!N38/100","v":0.05},{"$f":"'Valeur aliments'!O38","v":50},{"$f":"'Valeur aliments'!P38","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C39","v":"Foin Fétuque épiaison 1 cycle beau tps"},{"$f":"'Valeur aliments'!B39","v":"foin"},0.85,{"$f":"'Valeur aliments'!E39","v":0.66},{"$f":"'Valeur aliments'!F39","v":0.57999999999999996},0.62,{"$f":"'Valeur aliments'!H39","v":69},{"$f":"'Valeur aliments'!I39","v":76},{"$f":"'Valeur aliments'!N39/100","v":0.05},{"$f":"'Valeur aliments'!O39","v":50},{"$f":"'Valeur aliments'!P39","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C40","v":"Foin Fétuque floraison 1 cycle beau tps"},{"$f":"'Valeur aliments'!B40","v":"foin"},0.85,{"$f":"'Valeur aliments'!E40","v":0.56999999999999995},{"$f":"'Valeur aliments'!F40","v":0.47},0.52,{"$f":"'Valeur aliments'!H40","v":59},{"$f":"'Valeur aliments'!I40","v":68},{"$f":"'Valeur aliments'!N40/100","v":0.05},{"$f":"'Valeur aliments'!O40","v":50},{"$f":"'Valeur aliments'!P40","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C41","v":"Foin Luzerne  2 em cycle beau tps"},{"$f":"'Valeur aliments'!B41","v":"foin"},0.85,{"$f":"'Valeur aliments'!E41","v":0.67},{"$f":"'Valeur aliments'!F41","v":0.56999999999999995},0.62,{"$f":"'Valeur aliments'!H41","v":115},{"$f":"'Valeur aliments'!I41","v":90},{"$f":"'Valeur aliments'!N41/100","v":0.05},{"$f":"'Valeur aliments'!O41","v":50},{"$f":"'Valeur aliments'!P41","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C42","v":"Foin Luzerne bougeon 1 cycle beau tps"},{"$f":"'Valeur aliments'!B42","v":"foin"},0.85,{"$f":"'Valeur aliments'!E42","v":0.67},{"$f":"'Valeur aliments'!F42","v":0.57999999999999996},0.625,{"$f":"'Valeur aliments'!H42","v":114},{"$f":"'Valeur aliments'!I42","v":91},{"$f":"'Valeur aliments'!N42/100","v":0.05},{"$f":"'Valeur aliments'!O42","v":50},{"$f":"'Valeur aliments'!P42","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C43","v":"Foin Luzerne floraison 1 cycle beau tps"},{"$f":"'Valeur aliments'!B43","v":"foin"},0.85,{"$f":"'Valeur aliments'!E43","v":0.62},{"$f":"'Valeur aliments'!F43","v":0.52},0.57000000000000006,{"$f":"'Valeur aliments'!H43","v":107},{"$f":"'Valeur aliments'!I43","v":87},{"$f":"'Valeur aliments'!N43/100","v":0.05},{"$f":"'Valeur aliments'!O43","v":50},{"$f":"'Valeur aliments'!P43","v":0.85}]
[null,null,null,null,null,null,null,null,null,"Calculer la densité d'un ensilage d'herbe",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C44","v":"Foin moha"},{"$f":"'Valeur aliments'!B44","v":"foin"},0.85,{"$f":"'Valeur aliments'!E44","v":0.65},{"$f":"'Valeur aliments'!F44","v":0.65},0.65,{"$f":"'Valeur aliments'!H44","v":70},{"$f":"'Valeur aliments'!I44","v":65},{"$f":"'Valeur aliments'!N44/100","v":0.05},{"$f":"'Valeur aliments'!O44","v":50},{"$f":"'Valeur aliments'!P44","v":0.85}]
[null,"Estimation du rendement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C45","v":"Foin PP épiaison beau tps"},{"$f":"'Valeur aliments'!B45","v":"foin"},0.85,{"$f":"'Valeur aliments'!E45","v":0.72},{"$f":"'Valeur aliments'!F45","v":0.63},0.67500000000000004,{"$f":"'Valeur aliments'!H45","v":69},{"$f":"'Valeur aliments'!I45","v":82},{"$f":"'Valeur aliments'!N45/100","v":0.05},{"$f":"'Valeur aliments'!O45","v":50},{"$f":"'Valeur aliments'!P45","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C46","v":"Foin PP floraison beau tps"},{"$f":"'Valeur aliments'!B46","v":"foin"},0.85,{"$f":"'Valeur aliments'!E46","v":0.63},{"$f":"'Valeur aliments'!F46","v":0.53},0.58000000000000007,{"$f":"'Valeur aliments'!H46","v":58},{"$f":"'Valeur aliments'!I46","v":73},{"$f":"'Valeur aliments'!N46/100","v":0.05},{"$f":"'Valeur aliments'!O46","v":50},{"$f":"'Valeur aliments'!P46","v":0.85}]
[null,null,null,null,null,null,null,null,null,"hauteur",null,1.5,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C47","v":"Foin Rga 2 em cycle beau tps"},{"$f":"'Valeur aliments'!B47","v":"foin"},0.85,{"$f":"'Valeur aliments'!E47","v":0.74},{"$f":"'Valeur aliments'!F47","v":0.66},0.7,{"$f":"'Valeur aliments'!H47","v":78},{"$f":"'Valeur aliments'!I47","v":85},{"$f":"'Valeur aliments'!N47/100","v":0.05},{"$f":"'Valeur aliments'!O47","v":50},{"$f":"'Valeur aliments'!P47","v":0.85}]
[null,null,null,null,null,null,null,null,null,"Taux MS",null,0.35,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C48","v":"Foin Rga épiaison 1 er cycle beau tps "},{"$f":"'Valeur aliments'!B48","v":"foin"},0.85,{"$f":"'Valeur aliments'!E48","v":0.81},{"$f":"'Valeur aliments'!F48","v":0.74},0.77500000000000002,{"$f":"'Valeur aliments'!H48","v":75},{"$f":"'Valeur aliments'!I48","v":87},{"$f":"'Valeur aliments'!N48/100","v":0.05},{"$f":"'Valeur aliments'!O48","v":50},{"$f":"'Valeur aliments'!P48","v":0.85}]
[null,null,null,null,null,null,null,null,null,"Silo couloir",null,"non",null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C49","v":"Foin Rga floraison 1 er cycle beau tps "},{"$f":"'Valeur aliments'!B49","v":"foin"},0.85,{"$f":"'Valeur aliments'!E49","v":0.64},{"$f":"'Valeur aliments'!F49","v":0.55000000000000004},0.59499999999999997,{"$f":"'Valeur aliments'!H49","v":59},{"$f":"'Valeur aliments'!I49","v":72},{"$f":"'Valeur aliments'!N49/100","v":0.05},{"$f":"'Valeur aliments'!O49","v":50},{"$f":"'Valeur aliments'!P49","v":0.85}]
[null,null,null,null,null,null,null,null,null,"Kg MS / m3",null,{"$f":"IF(L52=\"oui\",N53,N53*0.9)","v":192.6},null,{"$f":"IF(L51<=0.35,7*L50+3.7*L51*100+74,12*L50+3.7*((0.34-L51)+0.34)*100+78)","v":214},null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C50","v":"Foin Rgi 2 em cycle beau tps"},{"$f":"'Valeur aliments'!B50","v":"foin"},0.85,{"$f":"'Valeur aliments'!E50","v":0.7},{"$f":"'Valeur aliments'!F50","v":0.61},0.65500000000000003,{"$f":"'Valeur aliments'!H50","v":76},{"$f":"'Valeur aliments'!I50","v":82},{"$f":"'Valeur aliments'!N50/100","v":0.05},{"$f":"'Valeur aliments'!O50","v":50},{"$f":"'Valeur aliments'!P50","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C51","v":"Foin Rgi épiaison 1 cycle beau tps"},{"$f":"'Valeur aliments'!B51","v":"foin"},0.85,{"$f":"'Valeur aliments'!E51","v":0.74},{"$f":"'Valeur aliments'!F51","v":0.66},0.7,{"$f":"'Valeur aliments'!H51","v":54},{"$f":"'Valeur aliments'!I51","v":75},{"$f":"'Valeur aliments'!N51/100","v":0.05},{"$f":"'Valeur aliments'!O51","v":50},{"$f":"'Valeur aliments'!P51","v":0.85}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C52","v":"Foin Rgi floraison 1 cycle beau tps"},{"$f":"'Valeur aliments'!B52","v":"foin"},0.85,{"$f":"'Valeur aliments'!E52","v":0.61},{"$f":"'Valeur aliments'!F52","v":0.52},0.56499999999999995,{"$f":"'Valeur aliments'!H52","v":36},{"$f":"'Valeur aliments'!I52","v":61},{"$f":"'Valeur aliments'!N52/100","v":0.05},{"$f":"'Valeur aliments'!O52","v":50},{"$f":"'Valeur aliments'!P52","v":0.85}]
[null,"Ensilage d'herbe Silo couloir",null,"teneur en MS de l'ensilage (%)",null,null,null,null,"L",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C53","v":"foin trèfle bougeon"},{"$f":"'Valeur aliments'!B53","v":"foin"},0.85,{"$f":"'Valeur aliments'!E53","v":0.67},{"$f":"'Valeur aliments'!F53","v":0.57999999999999996},0.625,{"$f":"'Valeur aliments'!H53","v":110},{"$f":"'Valeur aliments'!I53","v":89},{"$f":"'Valeur aliments'!N53/100","v":0.05},{"$f":"'Valeur aliments'!O53","v":50},{"$f":"'Valeur aliments'!P53","v":0.85}]
[null,"Densité en kg MS/M3",null,0.25,0.3,0.35,0.4,null,null,null,null,"H",null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C54","v":"foin trèfle floraison"},{"$f":"'Valeur aliments'!B54","v":"foin"},0.85,{"$f":"'Valeur aliments'!E54","v":0.63},{"$f":"'Valeur aliments'!F54","v":0.53},0.58000000000000007,{"$f":"'Valeur aliments'!H54","v":91},{"$f":"'Valeur aliments'!I54","v":81},{"$f":"'Valeur aliments'!N54/100","v":0.05},{"$f":"'Valeur aliments'!O54","v":50},{"$f":"'Valeur aliments'!P54","v":0.85}]
[null,"Hauteur du silo (m)",1,173.5,192,210.5,194,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C55","v":"foin trèfle repousse"},{"$f":"'Valeur aliments'!B55","v":"foin"},0.85,{"$f":"'Valeur aliments'!E55","v":0.65},{"$f":"'Valeur aliments'!F55","v":0.56000000000000005},0.60499999999999998,{"$f":"'Valeur aliments'!H55","v":116},{"$f":"'Valeur aliments'!I55","v":90},{"$f":"'Valeur aliments'!N55/100","v":0.05},{"$f":"'Valeur aliments'!O55","v":50},{"$f":"'Valeur aliments'!P55","v":0.85}]
[null,null,1.5,177,195.5,214,200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C56","v":"herbe"},{"$f":"'Valeur aliments'!B56","v":0},1,{"$f":"'Valeur aliments'!E56","v":0.94},{"$f":"'Valeur aliments'!F56","v":0.87},0.90500000000000003,{"$f":"'Valeur aliments'!H56","v":145},{"$f":"'Valeur aliments'!I56","v":112},{"$f":"'Valeur aliments'!N56/100","v":0.15},{"$f":"'Valeur aliments'!O56","v":50},{"$f":"'Valeur aliments'!P56","v":1}]
[null,null,2,180.5,199,217.5,206,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C57","v":"Maïs épis complets MS"},{"$f":"'Valeur aliments'!B57","v":0},1,{"$f":"'Valeur aliments'!E57","v":1.08},{"$f":"'Valeur aliments'!F57","v":1.05},1.0649999999999999,{"$f":"'Valeur aliments'!H57","v":61},{"$f":"'Valeur aliments'!I57","v":98},{"$f":"'Valeur aliments'!N57/100","v":0.05},{"$f":"'Valeur aliments'!O57","v":50},{"$f":"'Valeur aliments'!P57","v":1}]
[null,null,null,null,null,null,null,null,null,null,"l",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C58","v":"Maïs sécheresse pauvre en épi"},{"$f":"'Valeur aliments'!B58","v":0},1,{"$f":"'Valeur aliments'!E58","v":0.84},{"$f":"'Valeur aliments'!F58","v":0.73},0.78499999999999992,{"$f":"'Valeur aliments'!H58","v":47},{"$f":"'Valeur aliments'!I58","v":64},{"$f":"'Valeur aliments'!N58/100","v":0.3},{"$f":"'Valeur aliments'!O58","v":0},{"$f":"'Valeur aliments'!P58","v":1}]
[null,"Le cubage d’un silo taupinière  se réalise en multipliant la longueur (L) et la largeur à mi-hauteur du silo (l)  par la hauteur (H). ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C59","v":"paille blé"},{"$f":"'Valeur aliments'!B59","v":0},0.88,{"$f":"'Valeur aliments'!E59","v":0.42},{"$f":"'Valeur aliments'!F59","v":0.31},0.36499999999999999,{"$f":"'Valeur aliments'!H59","v":22},{"$f":"'Valeur aliments'!I59","v":44},{"$f":"'Valeur aliments'!N59/100","v":0.05},{"$f":"'Valeur aliments'!O59","v":25},{"$f":"'Valeur aliments'!P59","v":0.88}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C60","v":"paille cannes de mais"},{"$f":"'Valeur aliments'!B60","v":0},0,{"$f":"'Valeur aliments'!E60","v":0.6},{"$f":"'Valeur aliments'!F60","v":0.51},0.55499999999999994,{"$f":"'Valeur aliments'!H60","v":30},{"$f":"'Valeur aliments'!I60","v":60},{"$f":"'Valeur aliments'!N60/100","v":0},{"$f":"'Valeur aliments'!O60","v":0},{"$f":"'Valeur aliments'!P60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C61","v":"paille luzerne"},{"$f":"'Valeur aliments'!B61","v":"foin"},0.88,{"$f":"'Valeur aliments'!E61","v":0.45},{"$f":"'Valeur aliments'!F61","v":0.4},0.42500000000000004,{"$f":"'Valeur aliments'!H61","v":55},{"$f":"'Valeur aliments'!I61","v":45},{"$f":"'Valeur aliments'!N61/100","v":0.05},{"$f":"'Valeur aliments'!O61","v":30},{"$f":"'Valeur aliments'!P61","v":0.88}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C62","v":"Paille orge"},{"$f":"'Valeur aliments'!B62","v":0},0,{"$f":"'Valeur aliments'!E62","v":0.44},{"$f":"'Valeur aliments'!F62","v":0.33},0.38500000000000001,{"$f":"'Valeur aliments'!H62","v":24},{"$f":"'Valeur aliments'!I62","v":46},{"$f":"'Valeur aliments'!N62/100","v":0},{"$f":"'Valeur aliments'!O62","v":0},{"$f":"'Valeur aliments'!P62","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C63","v":"Paille pois"},{"$f":"'Valeur aliments'!B63","v":0},0,{"$f":"'Valeur aliments'!E63","v":0.53},{"$f":"'Valeur aliments'!F63","v":0.42},0.47499999999999998,{"$f":"'Valeur aliments'!H63","v":42},{"$f":"'Valeur aliments'!I63","v":60},{"$f":"'Valeur aliments'!N63/100","v":0},{"$f":"'Valeur aliments'!O63","v":0},{"$f":"'Valeur aliments'!P63","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C64","v":"Pommes de terre"},{"$f":"'Valeur aliments'!B64","v":0},0,{"$f":"'Valeur aliments'!E64","v":1.2},{"$f":"'Valeur aliments'!F64","v":1.22},1.21,{"$f":"'Valeur aliments'!H64","v":63},{"$f":"'Valeur aliments'!I64","v":103},{"$f":"'Valeur aliments'!N64/100","v":0},{"$f":"'Valeur aliments'!O64","v":0},{"$f":"'Valeur aliments'!P64","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C65","v":"seigle début épiaison"},{"$f":"'Valeur aliments'!B65","v":0},0,{"$f":"'Valeur aliments'!E65","v":0.87},{"$f":"'Valeur aliments'!F65","v":0.81},0.84000000000000008,{"$f":"'Valeur aliments'!H65","v":88},{"$f":"'Valeur aliments'!I65","v":87},{"$f":"'Valeur aliments'!N65/100","v":0},{"$f":"'Valeur aliments'!O65","v":0},{"$f":"'Valeur aliments'!P65","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C66","v":"seigle épiaison"},{"$f":"'Valeur aliments'!B66","v":0},0,{"$f":"'Valeur aliments'!E66","v":0.84},{"$f":"'Valeur aliments'!F66","v":0.78},0.81,{"$f":"'Valeur aliments'!H66","v":84},{"$f":"'Valeur aliments'!I66","v":84},{"$f":"'Valeur aliments'!N66/100","v":0},{"$f":"'Valeur aliments'!O66","v":0},{"$f":"'Valeur aliments'!P66","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C67","v":"sorgho fourrager"},{"$f":"'Valeur aliments'!B67","v":0},1,{"$f":"'Valeur aliments'!F67","v":0.59},{"$f":"'Valeur aliments'!G67","v":0},0.29499999999999998,{"$f":"'Valeur aliments'!I67","v":66},{"$f":"'Valeur aliments'!J67","v":1.27},{"$f":"'Valeur aliments'!N67/100","v":0.05},{"$f":"'Valeur aliments'!O67","v":25},{"$f":"'Valeur aliments'!P67","v":1}]
[null,"1 UGB consomme environ 5000 kg de Matière Sèche (MS) par an soit sans reprise de poids 13.7 kg MS/ j, au printemps avec reprise de poids il consomme 17.2 kgMS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C68","v":0},{"$f":"'Valeur aliments'!B68","v":0},0,{"$f":"'Valeur aliments'!E68","v":0},{"$f":"'Valeur aliments'!F68","v":0},0,{"$f":"'Valeur aliments'!H68","v":0},{"$f":"'Valeur aliments'!I68","v":0},{"$f":"'Valeur aliments'!N68/100","v":0},{"$f":"'Valeur aliments'!O68","v":0},{"$f":"'Valeur aliments'!P68","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C69","v":0},{"$f":"'Valeur aliments'!B69","v":0},0,{"$f":"'Valeur aliments'!E69","v":0},{"$f":"'Valeur aliments'!F69","v":0},0,{"$f":"'Valeur aliments'!H69","v":0},{"$f":"'Valeur aliments'!I69","v":0},{"$f":"'Valeur aliments'!N69/100","v":0},{"$f":"'Valeur aliments'!O69","v":0},{"$f":"'Valeur aliments'!P69","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C70","v":0},{"$f":"'Valeur aliments'!B70","v":0},{"$f":"AG73","v":0},{"$f":"'Valeur aliments'!E70","v":0},{"$f":"'Valeur aliments'!F70","v":0},{"$f":"(Z73+AA73)/2","v":0},{"$f":"'Valeur aliments'!H70","v":0},{"$f":"'Valeur aliments'!I70","v":0},{"$f":"'Valeur aliments'!N70/100","v":0},{"$f":"'Valeur aliments'!O70","v":0},{"$f":"'Valeur aliments'!P70","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C71","v":0},{"$f":"'Valeur aliments'!B71","v":0},0,{"$f":"'Valeur aliments'!E71","v":0},{"$f":"'Valeur aliments'!F71","v":0},0,{"$f":"'Valeur aliments'!H71","v":0},{"$f":"'Valeur aliments'!I71","v":0},{"$f":"'Valeur aliments'!N71/100","v":0},{"$f":"'Valeur aliments'!O71","v":0},{"$f":"'Valeur aliments'!P71","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C72","v":0},{"$f":"'Valeur aliments'!B72","v":0},0,{"$f":"'Valeur aliments'!E72","v":0},{"$f":"'Valeur aliments'!F72","v":0},0,{"$f":"'Valeur aliments'!H72","v":0},{"$f":"'Valeur aliments'!I72","v":0},{"$f":"'Valeur aliments'!N72/100","v":0},{"$f":"'Valeur aliments'!O72","v":0},{"$f":"'Valeur aliments'!P72","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C73","v":0},{"$f":"'Valeur aliments'!B73","v":0},0,{"$f":"'Valeur aliments'!E73","v":0},{"$f":"'Valeur aliments'!F73","v":0},0,{"$f":"'Valeur aliments'!H73","v":0},{"$f":"'Valeur aliments'!I73","v":0},{"$f":"'Valeur aliments'!N73/100","v":0},{"$f":"'Valeur aliments'!O73","v":0},{"$f":"'Valeur aliments'!P73","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C74","v":0},{"$f":"'Valeur aliments'!B74","v":0},0,{"$f":"'Valeur aliments'!E74","v":0},{"$f":"'Valeur aliments'!F74","v":0},0,{"$f":"'Valeur aliments'!H74","v":0},{"$f":"'Valeur aliments'!I74","v":0},{"$f":"'Valeur aliments'!N74/100","v":0},{"$f":"'Valeur aliments'!O74","v":0},{"$f":"'Valeur aliments'!P74","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C75","v":0},{"$f":"'Valeur aliments'!B75","v":0},0,{"$f":"'Valeur aliments'!E75","v":0},{"$f":"'Valeur aliments'!F75","v":0},0,{"$f":"'Valeur aliments'!H75","v":0},{"$f":"'Valeur aliments'!I75","v":0},{"$f":"'Valeur aliments'!N75/100","v":0},{"$f":"'Valeur aliments'!O75","v":0},{"$f":"'Valeur aliments'!P75","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C76","v":0},{"$f":"'Valeur aliments'!B76","v":0},0,{"$f":"'Valeur aliments'!E76","v":0},{"$f":"'Valeur aliments'!F76","v":0},0,{"$f":"'Valeur aliments'!H76","v":0},{"$f":"'Valeur aliments'!I76","v":0},{"$f":"'Valeur aliments'!N76/100","v":0},{"$f":"'Valeur aliments'!O76","v":0},{"$f":"'Valeur aliments'!P76","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C77","v":0},{"$f":"'Valeur aliments'!B77","v":0},0,{"$f":"'Valeur aliments'!E77","v":0},{"$f":"'Valeur aliments'!F77","v":0},0,{"$f":"'Valeur aliments'!H77","v":0},{"$f":"'Valeur aliments'!I77","v":0},{"$f":"'Valeur aliments'!N77/100","v":0},{"$f":"'Valeur aliments'!O77","v":0},{"$f":"'Valeur aliments'!P77","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C81","v":0},{"$f":"'Valeur aliments'!B81","v":0},{"$f":"AG81","v":0},{"$f":"'Valeur aliments'!E81","v":0},{"$f":"'Valeur aliments'!F81","v":0},{"$f":"(Z81+AA81)/2","v":0},{"$f":"'Valeur aliments'!H81","v":0},{"$f":"'Valeur aliments'!I81","v":0},{"$f":"'Valeur aliments'!N81/100","v":0},{"$f":"'Valeur aliments'!O81","v":0},{"$f":"'Valeur aliments'!P81","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C82","v":0},{"$f":"'Valeur aliments'!B82","v":0},0,{"$f":"'Valeur aliments'!E82","v":0},{"$f":"'Valeur aliments'!F82","v":0},0,{"$f":"'Valeur aliments'!H82","v":0},{"$f":"'Valeur aliments'!I82","v":0},{"$f":"'Valeur aliments'!N82/100","v":0},{"$f":"'Valeur aliments'!O82","v":0},{"$f":"'Valeur aliments'!P82","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C83","v":0},{"$f":"'Valeur aliments'!B83","v":0},0,{"$f":"'Valeur aliments'!E83","v":0},{"$f":"'Valeur aliments'!F83","v":0},0,{"$f":"'Valeur aliments'!H83","v":0},{"$f":"'Valeur aliments'!I83","v":0},{"$f":"'Valeur aliments'!N83/100","v":0},{"$f":"'Valeur aliments'!O83","v":0},{"$f":"'Valeur aliments'!P83","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C84","v":0},{"$f":"'Valeur aliments'!B84","v":0},0,{"$f":"'Valeur aliments'!E84","v":0},{"$f":"'Valeur aliments'!F84","v":0},0,{"$f":"'Valeur aliments'!H84","v":0},{"$f":"'Valeur aliments'!I84","v":0},{"$f":"'Valeur aliments'!N84/100","v":0},{"$f":"'Valeur aliments'!O84","v":0},{"$f":"'Valeur aliments'!P84","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C85","v":0},{"$f":"'Valeur aliments'!B85","v":0},0,{"$f":"'Valeur aliments'!E85","v":0},{"$f":"'Valeur aliments'!F85","v":0},0,{"$f":"'Valeur aliments'!H85","v":0},{"$f":"'Valeur aliments'!I85","v":0},{"$f":"'Valeur aliments'!N85/100","v":0},{"$f":"'Valeur aliments'!O85","v":0},{"$f":"'Valeur aliments'!P85","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C86","v":0},{"$f":"'Valeur aliments'!B86","v":0},0,{"$f":"'Valeur aliments'!E86","v":0},{"$f":"'Valeur aliments'!F86","v":0},0,{"$f":"'Valeur aliments'!H86","v":0},{"$f":"'Valeur aliments'!I86","v":0},{"$f":"'Valeur aliments'!N86/100","v":0},{"$f":"'Valeur aliments'!O86","v":0},{"$f":"'Valeur aliments'!P86","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C87","v":0},{"$f":"'Valeur aliments'!B87","v":0},0,{"$f":"'Valeur aliments'!E87","v":0},{"$f":"'Valeur aliments'!F87","v":0},0,{"$f":"'Valeur aliments'!H87","v":0},{"$f":"'Valeur aliments'!I87","v":0},{"$f":"'Valeur aliments'!N87/100","v":0},{"$f":"'Valeur aliments'!O87","v":0},{"$f":"'Valeur aliments'!P87","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C88","v":0},{"$f":"'Valeur aliments'!B88","v":0},0,{"$f":"'Valeur aliments'!E88","v":0},{"$f":"'Valeur aliments'!F88","v":0},0,{"$f":"'Valeur aliments'!H88","v":0},{"$f":"'Valeur aliments'!I88","v":0},{"$f":"'Valeur aliments'!N88/100","v":0},{"$f":"'Valeur aliments'!O88","v":0},{"$f":"'Valeur aliments'!P88","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C89","v":0},{"$f":"'Valeur aliments'!B89","v":0},0,{"$f":"'Valeur aliments'!E89","v":0},{"$f":"'Valeur aliments'!F89","v":0},0,{"$f":"'Valeur aliments'!H89","v":0},{"$f":"'Valeur aliments'!I89","v":0},{"$f":"'Valeur aliments'!N89/100","v":0},{"$f":"'Valeur aliments'!O89","v":0},{"$f":"'Valeur aliments'!P89","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!C90","v":0},{"$f":"'Valeur aliments'!B90","v":0},0,{"$f":"'Valeur aliments'!E90","v":0},{"$f":"'Valeur aliments'!F90","v":0},0,{"$f":"'Valeur aliments'!H90","v":0},{"$f":"'Valeur aliments'!I90","v":0},{"$f":"'Valeur aliments'!N90/100","v":0},{"$f":"'Valeur aliments'!O90","v":0},{"$f":"'Valeur aliments'!P90","v":0}]

{"sheet":"Concentré","index":3,"n_rows":100,"n_cols":24,"rows_kept":100,"cut":false,"hidden":false,"merged":[[24,9,24,10],[26,3,26,4],[32,4,34,4],[32,5,34,5],[32,6,34,7],[33,1,34,3],[30,5,31,6],[0,1,0,9],[21,9,21,10],[22,9,22,10],[23,9,23,10],[20,2,21,3],[20,5,22,5],[20,4,22,4],[20,6,21,7],[20,9,20,10]]}
[null,"Prix de parité d'aliments concentrés"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Parité aliment fermier - aliment du commerce"]
[]
[null,"Valeur et prix des aliments de référence, en euros par tonne brute"]
[null,"Aliments de référence","UF","PDIN","prix marché, euros T brute"]
[null,"blé",1.02,70,115]
[null,"soja 48",1.06,331,330]
[]
[null,null,null,"Cout stockage, aplatissage, travail de la céréale / tonne :",100]
[null,"Apport de minéraux ; quantité / tonne ",null,0.12,"Cout minéraux / tonne",null,600]
[]
[]
[null,null,"Valeurs par kg brut",null,"Prix de l'aliment / T brute","Prix de parité mélange fermier €/T","Quantité équivalente en aliments de référence",null,null,"1 kg brut de"]
[null,null,null,null,null,null,null,null,null,{"$f":"B24","v":"Jbexelor"}]
[null,null,"UF","PDIN",null,null,"blé","soja 48",null,"est l'équivalent de",null,0,null,"aliment fermier"]
[null,"Jbexelor",0.85,85,280,{"$f":"G24*($E$14+$E$17*G24)+H24*$E$15+$G$18*$D$18","v":217.06339373239447},{"$f":"(1-$D$18)*($D$24-331*$C$24/1.02)/(70-331)","v":0.64342273307790543},{"$f":"(1-$D$18)*C24/1.02-G24","v":8.9910600255427853E-2},null,{"$f":"G24","v":0.64342273307790543},null,{"$f":"IF(E24=\"\",\"\",F24-E24)","v":-62.936606267605526},null,{"$f":"IF(E24=\"\",\"\",B24)","v":"Jbexelor"},null,null,null,"Valeurs exprimées par kg brut (données INRA 2002 sauf UNIP pour le lupin)"]
[null,"Jbextra",0.92,110,325,{"$f":"G25*($E$14+$E$17*G25)+H25*$E$15+$G$18*$D$18","v":237.663530473945},{"$f":"(1-$D$18)*($D$25-331*$C$25/1.02)/(70-331)","v":0.63572083239426047},{"$f":"(1-$D$18)*C25/1.02-G25","v":0.15800465780181794},null,{"$f":"H24","v":8.9910600255427853E-2},null,{"$f":"IF(E25=\"\",\"\",F25-E25)","v":-87.336469526054998},null,{"$f":"IF(E25=\"\",\"\",B25)","v":"Jbextra"},null,null,null,"Aliments","Tx MS","ufl","ufv","(Ufl+ Ufv)/2","pdin","pdie"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(L24:L25)","v":-62.936606267605526},null,{"$f":"IF($L$23=L26,$N$23,IF($L$24=L26,$N$24,IF($L$25=L26,$N$25)))","v":"Jbexelor"},null,null,null,{"$f":"'Valeur aliments'!T5","v":"avoine"},{"$f":"'Valeur aliments'!U5","v":88.1},{"$f":"'Valeur aliments'!V5","v":0.88},{"$f":"'Valeur aliments'!W5","v":0.8},{"$f":"'Valeur aliments'!X5","v":0.84000000000000008},{"$f":"'Valeur aliments'!Y5","v":69},{"$f":"'Valeur aliments'!Z5","v":69}]
[null,null,"l'aliment le plus intéressant est:",{"$f":"IF(L26<0,\"l'aliment fermier\",N26)","v":"l'aliment fermier"},null,"ensuite :",{"$f":"N27","v":"Jbexelor"},null,null,null,null,{"$f":"MEDIAN(L23:L25)","v":-62.936606267605526},null,{"$f":"IF($L$23=L27,$N$23,IF($L$24=L27,$N$24,IF($L$25=L27,$N$25)))","v":"Jbexelor"},null,null,null,{"$f":"'Valeur aliments'!T6","v":"blé"},{"$f":"'Valeur aliments'!U6","v":86.8},{"$f":"'Valeur aliments'!V6","v":1.18},{"$f":"'Valeur aliments'!W6","v":1.18},{"$f":"'Valeur aliments'!X6","v":1.18},{"$f":"'Valeur aliments'!Y6","v":81},{"$f":"'Valeur aliments'!Z6","v":102}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T7","v":"féverole à fleures colorées"},{"$f":"'Valeur aliments'!U7","v":86.5},{"$f":"'Valeur aliments'!V7","v":1.2},{"$f":"'Valeur aliments'!W7","v":1.21},{"$f":"'Valeur aliments'!X7","v":1.2050000000000001},{"$f":"'Valeur aliments'!Y7","v":188},{"$f":"'Valeur aliments'!Z7","v":112}]
[null,"Parité aliments concentrés  (fermiers - aliments du commerce)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T8","v":"Gluten feed"},{"$f":"'Valeur aliments'!U8","v":88},{"$f":"'Valeur aliments'!V8","v":1.06},{"$f":"'Valeur aliments'!W8","v":1.03},{"$f":"'Valeur aliments'!X8","v":1.0449999999999999},{"$f":"'Valeur aliments'!Y8","v":144},{"$f":"'Valeur aliments'!Z8","v":115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T9","v":"Lactosérum"},{"$f":"'Valeur aliments'!U9","v":6.2},{"$f":"'Valeur aliments'!V9","v":1.1499999999999999},{"$f":"'Valeur aliments'!W9","v":1.18},{"$f":"'Valeur aliments'!X9","v":1.165},{"$f":"'Valeur aliments'!Y9","v":74},{"$f":"'Valeur aliments'!Z9","v":77}]
[null,"Prix blé / soja (kg brut)",130,330,null,"Pour saisir un aliment absent de la liste déroulante : cliquer sur cette macro",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T10","v":"lin grain"},{"$f":"'Valeur aliments'!U10","v":90.3},{"$f":"'Valeur aliments'!V10","v":1.58},{"$f":"'Valeur aliments'!W10","v":1.56},{"$f":"'Valeur aliments'!X10","v":1.57},{"$f":"'Valeur aliments'!Y10","v":161},{"$f":"'Valeur aliments'!Z10","v":84}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T11","v":"lupin blanc"},{"$f":"'Valeur aliments'!U11","v":88.6},{"$f":"'Valeur aliments'!V11","v":1.33},{"$f":"'Valeur aliments'!W11","v":1.33},{"$f":"'Valeur aliments'!X11","v":1.33},{"$f":"'Valeur aliments'!Y11","v":240},{"$f":"'Valeur aliments'!Z11","v":120}]
[null,null,null,null,"Prix de parité /T brute","Prix de parité /T MS","Quantité équivalente en aliments de référence en kg brut ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T12","v":"luzerne déshydratée 18 % mat"},{"$f":"'Valeur aliments'!U12","v":91},{"$f":"'Valeur aliments'!V12","v":0.7},{"$f":"'Valeur aliments'!W12","v":0.61},{"$f":"'Valeur aliments'!X12","v":0.65500000000000003},{"$f":"'Valeur aliments'!Y12","v":120},{"$f":"'Valeur aliments'!Z12","v":104}]
[null,"Valeurs par kg brut",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T13","v":"maïs"},{"$f":"'Valeur aliments'!U13","v":86.4},{"$f":"'Valeur aliments'!V13","v":1.22},{"$f":"'Valeur aliments'!W13","v":1.23},{"$f":"'Valeur aliments'!X13","v":1.2250000000000001},{"$f":"'Valeur aliments'!Y13","v":74},{"$f":"'Valeur aliments'!Z13","v":97}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T14","v":"mais humide"},{"$f":"'Valeur aliments'!U14","v":64},{"$f":"'Valeur aliments'!V14","v":1.2},{"$f":"'Valeur aliments'!W14","v":1.21},{"$f":"'Valeur aliments'!X14","v":1.2050000000000001},{"$f":"'Valeur aliments'!Y14","v":63},{"$f":"'Valeur aliments'!Z14","v":88}]
[null,null,"UF","PDIN",null,null,"blé","Soja 48",null,"Tx MS",null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T15","v":"mais rafle"},{"$f":"'Valeur aliments'!U15","v":65},{"$f":"'Valeur aliments'!V15","v":1.06},{"$f":"'Valeur aliments'!W15","v":1.06},{"$f":"'Valeur aliments'!X15","v":1.06},{"$f":"'Valeur aliments'!Y15","v":61},{"$f":"'Valeur aliments'!Z15","v":98}]
[null,"orge",{"$f":"(VLOOKUP(B37,table20,5))*J37/100","v":0.94069500000000006},{"$f":"(VLOOKUP(B37,table20,6))*J37/100","v":68.492999999999995},{"$f":"G37*$C$31+H37*$D$31","v":122.90820881226054},{"$f":"E37*100/J37","v":141.76263992186912},{"$f":"(D37-331*C37/1.02)/(70-331)","v":0.9071714559386973},{"$f":"C37/1.02-G37","v":1.5078544061302712E-2},null,{"$f":"VLOOKUP(B37,table20,2)","v":86.7},null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T16","v":"Multitourteaux"},{"$f":"'Valeur aliments'!U16","v":88},{"$f":"'Valeur aliments'!V16","v":0.95},{"$f":"'Valeur aliments'!W16","v":0.95},{"$f":"'Valeur aliments'!X16","v":0.95},{"$f":"'Valeur aliments'!Y16","v":125.19999999999999},{"$f":"'Valeur aliments'!Z16","v":109.2}]
[null,"triticale",{"$f":"(VLOOKUP(B38,table20,5))*J38/100","v":1.017045},{"$f":"(VLOOKUP(B38,table20,6))*J38/100","v":62.855999999999995},{"$f":"G38*$C$31+H38*$D$31","v":124.30445064232589},{"$f":"E38*100/J38","v":142.38768687551649},{"$f":"(D38-331*C38/1.02)/(70-331)","v":1.023697599729547},{"$f":"C38/1.02-G38","v":-2.6594658553076411E-2},null,{"$f":"VLOOKUP(B38,table20,2)","v":87.3},null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T17","v":"Nobia 40"},{"$f":"'Valeur aliments'!U17","v":88},{"$f":"'Valeur aliments'!V17","v":0.85},{"$f":"'Valeur aliments'!W17","v":0.85},{"$f":"'Valeur aliments'!X17","v":0.85},{"$f":"'Valeur aliments'!Y17","v":275},{"$f":"'Valeur aliments'!Z17","v":170}]
[null,"maïs",{"$f":"(VLOOKUP(B39,table20,5))*J39/100","v":1.0584000000000002},{"$f":"(VLOOKUP(B39,table20,6))*J39/100","v":63.936000000000007},{"$f":"G39*$C$31+H39*$D$31","v":128.2279918864098},{"$f":"E39*100/J39","v":148.41202764630762},1.0709776876267749,-3.3330628803245332E-2,null,86.4,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T18","v":"orge"},{"$f":"'Valeur aliments'!U18","v":86.7},{"$f":"'Valeur aliments'!V18","v":1.0900000000000001},{"$f":"'Valeur aliments'!W18","v":1.08},{"$f":"'Valeur aliments'!X18","v":1.085},{"$f":"'Valeur aliments'!Y18","v":79},{"$f":"'Valeur aliments'!Z18","v":101}]
[null,"Pulpe betterave déshydratée",0.87763499999999994,{"$f":"(VLOOKUP(B40,table20,6))*J40/100","v":58.805999999999997},110.76436612576062,124.31466456314325,0.86588184584178496,-5.4553752535497768E-3,null,89.1,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T19","v":"pois"},{"$f":"'Valeur aliments'!U19","v":86.4},{"$f":"'Valeur aliments'!V19","v":1.21},{"$f":"'Valeur aliments'!W19","v":1.22},{"$f":"'Valeur aliments'!X19","v":1.2149999999999999},{"$f":"'Valeur aliments'!Y19","v":150},{"$f":"'Valeur aliments'!Z19","v":120}]
[null,"Son de blé tendre",0.79260999999999981,94.067999999999998,131.41983810382385,150.88385545789191,0.62506404477499788,0.15200458267598227,null,87.1,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T20","v":"Pommes de terre"},{"$f":"'Valeur aliments'!U20","v":20},{"$f":"'Valeur aliments'!V20","v":1.2},{"$f":"'Valeur aliments'!W20","v":1.22},{"$f":"'Valeur aliments'!X20","v":1.21},{"$f":"'Valeur aliments'!Y20","v":63},{"$f":"'Valeur aliments'!Z20","v":103}]
[null,"Nobia 40",0.748,242,241.43805874840359,274.3614303959132,2.8097062579820692E-3,0.73052362707535123,null,88,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T21","v":"Pulpe betterave déshydratée"},{"$f":"'Valeur aliments'!U21","v":89.1},{"$f":"'Valeur aliments'!V21","v":0.99},{"$f":"'Valeur aliments'!W21","v":0.98},{"$f":"'Valeur aliments'!X21","v":0.98499999999999999},{"$f":"'Valeur aliments'!Y21","v":66},{"$f":"'Valeur aliments'!Z21","v":109}]
[null,"tourteau de colza",0.82491000000000003,219.08900000000003,229.6394421906694,258.89452332657203,0.18621602434077064,0.62251926977687644,null,88.7,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T22","v":"Purée de pomme de terre"},{"$f":"'Valeur aliments'!U22","v":40},{"$f":"'Valeur aliments'!V22","v":1.1399999999999999},{"$f":"'Valeur aliments'!W22","v":1.1499999999999999},{"$f":"'Valeur aliments'!X22","v":1.145},{"$f":"'Valeur aliments'!Y22","v":42},{"$f":"'Valeur aliments'!Z22","v":86}]
[null,"tourteau de lin déshuilé",0.8638499999999999,226.81599999999997,238.47567613252198,269.15990534144697,0.20502603110209583,0.64188573360378642,null,88.6,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T23","v":"Soja  tanné"},{"$f":"'Valeur aliments'!U23","v":87.8},{"$f":"'Valeur aliments'!V23","v":1.21},{"$f":"'Valeur aliments'!W23","v":1.2},{"$f":"'Valeur aliments'!X23","v":1.2050000000000001},{"$f":"'Valeur aliments'!Y23","v":443},{"$f":"'Valeur aliments'!Z23","v":426}]
[null,"luzerne déshydratée 18 % mat",{"$f":"(VLOOKUP(B45,table20,5))*J45/100","v":0.59605000000000008},109.2,128.30018969273533,140.98921944256631,0.3226975809480882,0.26166516414995111,null,91,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T24","v":"Soja 48"},{"$f":"'Valeur aliments'!U24","v":87.8},{"$f":"'Valeur aliments'!V24","v":1.21},{"$f":"'Valeur aliments'!W24","v":1.2},{"$f":"'Valeur aliments'!X24","v":1.2050000000000001},{"$f":"'Valeur aliments'!Y24","v":377},{"$f":"'Valeur aliments'!Z24","v":261}]
[null,"Tournesol non décortiqué",0.51002499999999995,178.28700000000001,174.80033900533394,197.06915333183082,-4.8961253850199248E-2,0.54898576365412077,null,88.7,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T25","v":"Soja 50"},{"$f":"'Valeur aliments'!U25","v":87.6},{"$f":"'Valeur aliments'!V25","v":1.21},{"$f":"'Valeur aliments'!W25","v":1.21},{"$f":"'Valeur aliments'!X25","v":1.21},{"$f":"'Valeur aliments'!Y25","v":395},{"$f":"'Valeur aliments'!Z25","v":272}]
[null,"pois",{"$f":"(VLOOKUP(B47,table20,5))*J47/100","v":1.04976},129.6,177.89841784989858,205.90094658553076,0.80864908722109541,0.22052738336713995,null,86.4,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T26","v":"soja graine"},{"$f":"'Valeur aliments'!U26","v":88},{"$f":"'Valeur aliments'!V26","v":1.2272727272727273},{"$f":"'Valeur aliments'!W26","v":1.23},{"$f":"'Valeur aliments'!X26","v":1.2286363636363635},{"$f":"'Valeur aliments'!Y26","v":244.31818181818181},{"$f":"'Valeur aliments'!Z26","v":86.36363636363636}]
[null,"féverole à fleures colorées",1.0423249999999999,162.62,202.64449421531063,234.27109157839379,0.67289149951168192,0.34899575539027872,null,86.5,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T27","v":"soja graine extrudée"},{"$f":"'Valeur aliments'!U27","v":88},{"$f":"'Valeur aliments'!V27","v":1.44},{"$f":"'Valeur aliments'!W27","v":1.44},{"$f":"'Valeur aliments'!X27","v":1.44},{"$f":"'Valeur aliments'!Y27","v":298},{"$f":"'Valeur aliments'!Z27","v":243}]
[null,"Aliments < à 85 % de MS",null,"Valeurs par kg de MS",null,null,"en kg brut ",null,null,null,{"$f":"C31/0.88","v":147.72727272727272},{"$f":"D31/0.88","v":375},null,null,null,null,null,{"$f":"'Valeur aliments'!T28","v":"soja graine toastée"},{"$f":"'Valeur aliments'!U28","v":88},{"$f":"'Valeur aliments'!V28","v":1.47},{"$f":"'Valeur aliments'!W28","v":1.46},{"$f":"'Valeur aliments'!X28","v":1.4649999999999999},{"$f":"'Valeur aliments'!Y28","v":269},{"$f":"'Valeur aliments'!Z28","v":177}]
[null,"Fibre de blé",{"$f":"VLOOKUP(B50,table21,5)","v":0},{"$f":"VLOOKUP(B50,table21,6)","v":0},{"$f":"F50*J50/100","v":0},{"$f":"(K50*$K$49)+(L50*$L$49)","v":0},{"$f":"K50*J50/100","v":0},{"$f":"L50*J50/100","v":0},null,{"$f":"VLOOKUP(B50,table21,2)","v":50},{"$f":"(D50-389*C50/1.2)/(82-389)","v":0},{"$f":"(C50/1.2-K50)","v":0},null,null,null,null,null,{"$f":"'Valeur aliments'!T29","v":"Son de blé tendre"},{"$f":"'Valeur aliments'!U29","v":87.1},{"$f":"'Valeur aliments'!V29","v":0.94},{"$f":"'Valeur aliments'!W29","v":0.88},{"$f":"'Valeur aliments'!X29","v":0.90999999999999992},{"$f":"'Valeur aliments'!Y29","v":108},{"$f":"'Valeur aliments'!Z29","v":91}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T30","v":"Tournesol non décortiqué"},{"$f":"'Valeur aliments'!U30","v":88.7},{"$f":"'Valeur aliments'!V30","v":0.63},{"$f":"'Valeur aliments'!W30","v":0.52},{"$f":"'Valeur aliments'!X30","v":0.57499999999999996},{"$f":"'Valeur aliments'!Y30","v":201},{"$f":"'Valeur aliments'!Z30","v":105}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T31","v":"Tournesol partiellement décortiqué"},{"$f":"'Valeur aliments'!U31","v":89.7},{"$f":"'Valeur aliments'!V31","v":0.73},{"$f":"'Valeur aliments'!W31","v":0.64},{"$f":"'Valeur aliments'!X31","v":0.68500000000000005},{"$f":"'Valeur aliments'!Y31","v":245},{"$f":"'Valeur aliments'!Z31","v":128}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T32","v":"tourteau de colza"},{"$f":"'Valeur aliments'!U32","v":88.7},{"$f":"'Valeur aliments'!V32","v":0.96},{"$f":"'Valeur aliments'!W32","v":0.9},{"$f":"'Valeur aliments'!X32","v":0.92999999999999994},{"$f":"'Valeur aliments'!Y32","v":247},{"$f":"'Valeur aliments'!Z32","v":155}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T33","v":"tourteau de lin déshuilé"},{"$f":"'Valeur aliments'!U33","v":88.6},{"$f":"'Valeur aliments'!V33","v":1},{"$f":"'Valeur aliments'!W33","v":0.95},{"$f":"'Valeur aliments'!X33","v":0.97499999999999998},{"$f":"'Valeur aliments'!Y33","v":256},{"$f":"'Valeur aliments'!Z33","v":202}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T34","v":"tourteau de lin expeller"},{"$f":"'Valeur aliments'!U34","v":90.4},{"$f":"'Valeur aliments'!V34","v":1.07},{"$f":"'Valeur aliments'!W34","v":1.02},{"$f":"'Valeur aliments'!X34","v":1.0449999999999999},{"$f":"'Valeur aliments'!Y34","v":244},{"$f":"'Valeur aliments'!Z34","v":190}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T35","v":"triticale"},{"$f":"'Valeur aliments'!U35","v":87.3},{"$f":"'Valeur aliments'!V35","v":1.1599999999999999},{"$f":"'Valeur aliments'!W35","v":1.17},{"$f":"'Valeur aliments'!X35","v":1.165},{"$f":"'Valeur aliments'!Y35","v":72},{"$f":"'Valeur aliments'!Z35","v":96}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T36","v":"Urée"},{"$f":"'Valeur aliments'!U36","v":98},{"$f":"'Valeur aliments'!V36","v":0},{"$f":"'Valeur aliments'!W36","v":0},{"$f":"'Valeur aliments'!X36","v":0},{"$f":"'Valeur aliments'!Y36","v":1472},{"$f":"'Valeur aliments'!Z36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T37","v":0},{"$f":"'Valeur aliments'!U37","v":0},{"$f":"'Valeur aliments'!V37","v":0},{"$f":"'Valeur aliments'!W37","v":0},{"$f":"'Valeur aliments'!X37","v":0},{"$f":"'Valeur aliments'!Y37","v":0},{"$f":"'Valeur aliments'!Z37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T38","v":0},{"$f":"'Valeur aliments'!U38","v":0},{"$f":"'Valeur aliments'!V38","v":0},{"$f":"'Valeur aliments'!W38","v":0},{"$f":"'Valeur aliments'!X38","v":0},{"$f":"'Valeur aliments'!Y38","v":0},{"$f":"'Valeur aliments'!Z38","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T39","v":0},{"$f":"'Valeur aliments'!U39","v":0},{"$f":"'Valeur aliments'!V39","v":0},{"$f":"'Valeur aliments'!W39","v":0},{"$f":"'Valeur aliments'!X39","v":0},{"$f":"'Valeur aliments'!Y39","v":0},{"$f":"'Valeur aliments'!Z39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T40","v":0},{"$f":"'Valeur aliments'!U40","v":0},{"$f":"'Valeur aliments'!V40","v":0},{"$f":"'Valeur aliments'!W40","v":0},{"$f":"'Valeur aliments'!X40","v":0},{"$f":"'Valeur aliments'!Y40","v":0},{"$f":"'Valeur aliments'!Z40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T41","v":0},{"$f":"'Valeur aliments'!U41","v":0},{"$f":"'Valeur aliments'!V41","v":0},{"$f":"'Valeur aliments'!W41","v":0},{"$f":"'Valeur aliments'!X41","v":0},{"$f":"'Valeur aliments'!Y41","v":0},{"$f":"'Valeur aliments'!Z41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T42","v":0},{"$f":"'Valeur aliments'!U42","v":0},{"$f":"'Valeur aliments'!V42","v":0},{"$f":"'Valeur aliments'!W42","v":0},{"$f":"'Valeur aliments'!X42","v":0},{"$f":"'Valeur aliments'!Y42","v":0},{"$f":"'Valeur aliments'!Z42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T43","v":"ALIMENTS COPRODUITS (riche en eau)"},{"$f":"'Valeur aliments'!U43","v":0},{"$f":"'Valeur aliments'!V43","v":0},{"$f":"'Valeur aliments'!W43","v":0},{"$f":"'Valeur aliments'!X43","v":0},{"$f":"'Valeur aliments'!Y43","v":0},{"$f":"'Valeur aliments'!Z43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T44","v":0},{"$f":"'Valeur aliments'!U44","v":0},{"$f":"'Valeur aliments'!V44","v":0},{"$f":"'Valeur aliments'!W44","v":0},{"$f":"'Valeur aliments'!X44","v":0},{"$f":"'Valeur aliments'!Y44","v":0},{"$f":"'Valeur aliments'!Z44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T45","v":"Aliments"},{"$f":"'Valeur aliments'!U45","v":"% MS"},{"$f":"'Valeur aliments'!V45","v":"ufl"},{"$f":"'Valeur aliments'!W45","v":"ufv"},{"$f":"'Valeur aliments'!X45","v":0},{"$f":"'Valeur aliments'!Y45","v":"pdin"},{"$f":"'Valeur aliments'!Z45","v":"pdie"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T46","v":"Fibre de blé"},{"$f":"'Valeur aliments'!U46","v":50},{"$f":"'Valeur aliments'!V46","v":0},{"$f":"'Valeur aliments'!W46","v":0},{"$f":"'Valeur aliments'!X46","v":0},{"$f":"'Valeur aliments'!Y46","v":0},{"$f":"'Valeur aliments'!Z46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T47","v":"Purée de pomme de terre"},{"$f":"'Valeur aliments'!U47","v":40},{"$f":"'Valeur aliments'!V47","v":1.1399999999999999},{"$f":"'Valeur aliments'!W47","v":1.1499999999999999},{"$f":"'Valeur aliments'!X47","v":1.145},{"$f":"'Valeur aliments'!Y47","v":42},{"$f":"'Valeur aliments'!Z47","v":86}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T48","v":0},{"$f":"'Valeur aliments'!U48","v":0},{"$f":"'Valeur aliments'!V48","v":0},{"$f":"'Valeur aliments'!W48","v":0},{"$f":"'Valeur aliments'!X48","v":0},{"$f":"'Valeur aliments'!Y48","v":0},{"$f":"'Valeur aliments'!Z48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T49","v":0},{"$f":"'Valeur aliments'!U49","v":0},{"$f":"'Valeur aliments'!V49","v":0},{"$f":"'Valeur aliments'!W49","v":0},{"$f":"'Valeur aliments'!X49","v":0},{"$f":"'Valeur aliments'!Y49","v":0},{"$f":"'Valeur aliments'!Z49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T50","v":0},{"$f":"'Valeur aliments'!U50","v":0},{"$f":"'Valeur aliments'!V50","v":0},{"$f":"'Valeur aliments'!W50","v":0},{"$f":"'Valeur aliments'!X50","v":0},{"$f":"'Valeur aliments'!Y50","v":0},{"$f":"'Valeur aliments'!Z50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T51","v":0},{"$f":"'Valeur aliments'!U51","v":0},{"$f":"'Valeur aliments'!V51","v":0},{"$f":"'Valeur aliments'!W51","v":0},{"$f":"'Valeur aliments'!X51","v":0},{"$f":"'Valeur aliments'!Y51","v":0},{"$f":"'Valeur aliments'!Z51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T52","v":0},{"$f":"'Valeur aliments'!U52","v":0},{"$f":"'Valeur aliments'!V52","v":0},{"$f":"'Valeur aliments'!W52","v":0},{"$f":"'Valeur aliments'!X52","v":0},{"$f":"'Valeur aliments'!Y52","v":0},{"$f":"'Valeur aliments'!Z52","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T53","v":0},{"$f":"'Valeur aliments'!U53","v":0},{"$f":"'Valeur aliments'!V53","v":0},{"$f":"'Valeur aliments'!W53","v":0},{"$f":"'Valeur aliments'!X53","v":0},{"$f":"'Valeur aliments'!Y53","v":0},{"$f":"'Valeur aliments'!Z53","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valeur aliments'!T54","v":0},{"$f":"'Valeur aliments'!U54","v":0},{"$f":"'Valeur aliments'!V54","v":0},{"$f":"'Valeur aliments'!W54","v":0},{"$f":"'Valeur aliments'!X54","v":0},{"$f":"'Valeur aliments'!Y54","v":0},{"$f":"'Valeur aliments'!Z54","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1T de produits remplace (blé 130€, soja 330€)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blé","Soja","Prix parité","Marché"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B37","v":"orge"},{"$f":"G37","v":0.9071714559386973},1.5078544061302712E-2,{"$f":"E37","v":122.90820881226054}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":"triticale"},1.023697599729547,-2.6594658553076411E-2,{"$f":"E38","v":124.30445064232589}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B39","v":"maïs"},1.0709776876267749,-3.3330628803245332E-2,{"$f":"E39","v":128.2279918864098},150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B40","v":"Pulpe betterave déshydratée"},{"$f":"G40","v":0.86588184584178496},-5.4553752535497768E-3,{"$f":"E40","v":110.76436612576062},150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Son de blé tendre",{"$f":"G41","v":0.62506404477499788},0.15200458267598227,131.41983810382385,114]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1T de produits remplace (blé 130€, soja 330€)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blé","Soja","Prix parité","Marché"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B42","v":"Nobia 40"},{"$f":"G42","v":2.8097062579820692E-3},0.73052362707535123,{"$f":"E42","v":241.43805874840359}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tourteau de colza",0.18621602434077064,0.62251926977687644,229.6394421906694,210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tourteau de lin déshuilé",0.20502603110209583,0.64188573360378642,238.47567613252198,320]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"luzerne déshydratée 18 % mat",0.3226975809480882,0.26166516414995111,128.30018969273533,170]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tournesol non décortiqué",-4.8961253850199248E-2,0.54898576365412077,174.80033900533394,150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pois",0.80864908722109541,0.22052738336713995,177.89841784989858,180]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"féverole à fleures colorées",0.67289149951168192,0.34899575539027872,202.64449421531063]

{"sheet":"Valeur aliments","index":4,"n_rows":67,"n_cols":32,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,"ALIMENTS FOURRAGES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ALIMENTS CONCENTRES"]
[]
[null,"Code Table INRA","Aliments","% MS","ufl","ufv",null,"pdin","pdie","ueb","p","ca","cb","Perte récolte","Cout récolte TMS","Calcul %MS",null,null,"Code Table INRA","Aliments","% MS","ufl","ufv",null,"pdin","pdie","ueb","p","ca","cb"]
[]
[null,null,"Betteraves fourragères",13,1.1499999999999999,1.1599999999999999,null,62,86,1.2,1.5,2.5,70,7,50,1,null,null,20,"avoine",88.1,0.88,0.8,{"$f":"(V5+W5)/2","v":0.84000000000000008},69,69,null,3.6,1.2,138]
[null,null,"choux moelliers",12.4,1.03,1.01,null,104,98,0.97,3,14.6,175,null,null,null,null,null,50,"blé",86.8,1.18,1.18,1.18,81,102,null,3.7,0.8,26]
[null,"enru","enruba dactyle mi-fané début floraison  1èr cycle",55,0.66,0.59,null,70,71,1.31,2.2999999999999998,2.7,350,10,54,1,null,null,30,"féverole à fleures colorées",86.5,1.2,1.21,1.2050000000000001,188,112,null,5.3,1.6,91]
[null,"enru","enruba dactyle mi-fané fin épiaison  1èr cycle",55,0.72,0.64,null,77,74,1.25,2.2999999999999998,2.7,333,10,54,1,null,null,110,"Gluten feed",88,1.06,1.03,1.0449999999999999,144,115,null,10.1,1.8,85]
[null,"enru","enruba fétuque mi-fané début floraison  1èr cycle",55,0.61,0.51,null,64,64,1.32,2.2999999999999998,3.4,339,10,54,1,null,null,10,"Lactosérum",6.2,1.1499999999999999,1.18,1.165,74,77,null,10,19,0]
[null,"enru","enruba fétuque mi-fané fin épiaison  1èr cycle",55,0.67,0.59,null,66,68,1.26,2.2999999999999998,3.4,325,10,54,1,null,null,50,"lin grain",90.3,1.58,1.56,1.57,161,84,null,6.8,4.2,102]
[null,"enru","enruba luzerne mi-fané début floraison  1èr cycle",55,0.67,0.56999999999999995,null,105,75,1.07,2.6,12.8,346,10,54,1,null,null,60,"lupin blanc",88.6,1.33,1.33,1.33,240,120,null,4.3,3.8,128]
[null,"enru","enruba luzerne mi-fané fin bourgeonnement 1èr cycle",55,0.71,0.62,null,113,79,1.07,2.6,12.8,337,10,54,1,null,null,40,"luzerne déshydratée 18 % mat",91,0.7,0.61,0.65500000000000003,120,104,null,2.7,22.3,283]
[null,"enru","enruba rga mi-fané début floraison  1èr cycle",55,0.7,0.62,null,66,71,1.37,2.2999999999999998,5.8,332,10,54,1,null,null,60,"maïs",86.4,1.22,1.23,1.2250000000000001,74,97,null,3,0.5,25]
[null,"enru","enruba rga mi-fané fin épiaison  1èr cycle",55,0.76,0.69,null,68,74,1.27,2.6,5.8,317,10,54,1,null,null,null,"mais humide",64,1.2,1.21,1.2050000000000001,63,88,null,3,0.5]
[null,"enru","enruba rgi mi-fané début floraison  1èr cycle",55,0.68,0.6,null,46,63,1.3,2.2999999999999998,4.5999999999999996,317,10,54,1,null,null,null,"mais rafle",65,1.06,1.06,1.06,61,98]
[null,"enru","enruba rgi mi-fané fin épiaison  1èr cycle",55,0.72,0.64,null,52,67,1.21,2.2999999999999998,4.5999999999999996,310,10,54,1,null,null,null,"Multitourteaux",88,0.95,0.95,0.95,{"$f":"Y8*0.6+Y13*0.2+Y12*0.2","v":125.19999999999999},{"$f":"Z8*0.6+Z13*0.2+Z12*0.2","v":109.2}]
[null,"ensi","Ens blé laiteux pateux 35%",35,0.64,0.55000000000000004,null,60,60,1.01,2.6,4,267,10,42,1,null,null,null,"Nobia 40",88,0.85,0.85,0.85,275,170,null,12,30]
[null,"ensi","Ens mais 30 % ms (pateux)",30,0.9,0.8,null,42,65,1.1299999999999999,1.8,2,205,7,30,1,null,null,10,"orge",86.7,1.0900000000000001,1.08,1.085,79,101,null,4,0.8,52]
[null,"ensi","Ens mais 35 % ms (vitreux)",35,0.91,0.81,null,42,67,1.05,1.8,2,201,7,30,1,null,null,80,"pois",86.4,1.21,1.22,1.2149999999999999,150,120,null,4.5999999999999996,1.3,60]
[null,"ensi","Ens mais 35 % ms (vitreux) % épis >65",35,0.96,0.87,null,50,71,1,1.8,2,165,7,30,1,null,null,70,"Pommes de terre",20,1.2,1.22,1.21,63,103,0.7,2,0.5,26]
[null,"ensi","Ens orge laiteux pateux 35%",35,0.69,0.6,null,50,58,1.1000000000000001,2.2999999999999998,3.4,200,null,null,null,null,null,170,"Pulpe betterave déshydratée",89.1,0.99,0.98,0.98499999999999999,66,109,null,1,14.8,194]
["dac","ensi","Ens. Dactyle dé épiaison c. fine 35 % Ms",33.5,0.83,0.77,null,100,71,1.05,2.2999999999999998,2.7,270,7,30,1,null,null,null,"Purée de pomme de terre",40,1.1399999999999999,1.1499999999999999,1.145,42,86]
["dac","ensi","Ens. Dactyle fin épiaison c. fine 35 % Ms",33.5,0.73,0.65,null,78,63,1.23,2.2999999999999998,2.7,325,7,30,1,null,null,290,"Soja  tanné",87.8,1.21,1.2,1.2050000000000001,443,426,null,7.1,3.9,68]
["fét","ensi","Ens. Fétuque dé épiaison c. fine 35 % Ms",33.5,0.73,0.65,null,83,63,1.1299999999999999,2.6,3.4,283,10,42,1,null,null,140,"Soja 48",87.8,1.21,1.2,1.2050000000000001,377,261,null,7.1,3.9,68]
["fét","ensi","Ens. Fétuque fin épiaison c. fine 35 % Ms",33.5,0.67,0.57999999999999996,null,69,58,1.23,2.2999999999999998,3.4,315,10,50,1,null,null,150,"Soja 50",87.6,1.21,1.21,1.21,395,272,null,7.1,3.9,44]
["luz","ensi","Ens. luzerne Bourgeon 55%",55,0.71,0.62,null,113,79,1.07,2.6,12.8,337,10,50,1,null,null,null,"soja graine",88,{"$f":"1.08/0.88","v":1.2272727272727273},1.23,1.2286363636363635,{"$f":"215/0.88","v":244.31818181818181},{"$f":"76/0.88","v":86.36363636363636}]
[null,"ensi","ens. mélange imma triticale pois",32,0.75,0.75,null,65,70,null,null,null,null,10,50,1,null,null,null,"soja graine extrudée",88,1.44,1.44,1.44,298,243]
["rga","ensi","Ens. RGA dé épiaison coupe fine 35% ms",33.5,0.89,0.84,null,90,73,1.1399999999999999,2.8,5.8,254,10,50,1,null,null,null,"soja graine toastée",88,1.47,1.46,1.4649999999999999,269,177]
["rga","ensi","Ens. RGA fin épiaison coupe fine 35% ms",33.5,0.78,0.7,null,70,64,1.24,2.6,5.8,305,10,50,1,null,null,60,"Son de blé tendre",87.1,0.94,0.88,0.90999999999999992,108,91,null,11.4,1.6,105]
["rgi","ensi","Ens. RGI dé épiaison coupe fine 35% ms",33.5,0.83,0.77,null,70,65,1.08,2.6,4.5999999999999996,254,10,42,1,null,null,160,"Tournesol non décortiqué",88.7,0.63,0.52,0.57499999999999996,201,105,null,11.3,4.4000000000000004,287]
["rgi","ensi","Ens. RGI fin épiaison coupe fine 35% ms",33.5,0.74,0.67,null,57,59,1.18,2.2999999999999998,4.5999999999999996,297,10,50,1,null,null,170,"Tournesol partiellement décortiqué",89.7,0.73,0.64,0.68500000000000005,245,128,null,12,4.5,236]
[null,"ensi","Ens. trèfle violet Bourgeon 55%",55,0.77,0.7,null,104,80,1.1000000000000001,2.6,11.2,290,10,50,1,null,null,40,"tourteau de colza",88.7,0.96,0.9,0.92999999999999994,247,155,null,12.9,9.4,139]
[null,"foin","Foin 75% RGA 25% TB",85,0.7,0.62,{"$f":"(E33+F33)/2","v":0.65999999999999992},74,76,null,null,null,null,10,50,0.85,null,null,null,"tourteau de lin déshuilé",88.6,1,0.95,0.97499999999999998,256,202]
[null,"foin","foin avoine laiteux pâteux",85,0.67,0.57999999999999996,null,42,62,null,null,null,null,10,50,0.85,null,null,null,"tourteau de lin expeller",90.4,1.07,1.02,1.0449999999999999,244,190]
["dac","foin","Foin Dactyle 2 em cycle beau tps",85,0.7,0.61,null,92,89,1.02,2.4,3.9,323,10,50,0.85,null,null,100,"triticale",87.3,1.1599999999999999,1.17,1.165,72,96,null,4,0.8]
["dac","foin","Foin Dactyle épiaison  1 cycle beau tps",85,0.76,0.68,null,91,89,1.08,2.2000000000000002,2.2999999999999998,307,5,50,0.85,null,null,10,"Urée",98,null,null,0,1472]
["dac","foin","Foin Dactyle floraison 1 cycle beau tps",85,0.6,0.51,null,60,71,1.29,1.9,1.9,357,5,50,0.85,null,null,null,null,null,null,null,0]
["fét","foin","Foin Fétuque 2 em cycle beau tps",85,0.69,0.61,null,84,85,1.06,2.9,3.5,296,5,50,0.85,null,null,null,null,null,null,null,0]
["fét","foin","Foin Fétuque épiaison 1 cycle beau tps",85,0.66,0.57999999999999996,null,69,76,1.1100000000000001,2.4,2.7,316,5,50,0.85]
["fét","foin","Foin Fétuque floraison 1 cycle beau tps",85,0.56999999999999995,0.47,null,59,68,1.27,2.2000000000000002,2.7,348,5,50,0.85]
["luz","foin","Foin Luzerne  2 em cycle beau tps",85,0.67,0.56999999999999995,null,115,90,1.04,2.2000000000000002,11,361,5,50,0.85]
["luz","foin","Foin Luzerne bougeon 1 cycle beau tps",85,0.67,0.57999999999999996,null,114,91,1.04,2.4,12.5,351,5,50,0.85]
["luz","foin","Foin Luzerne floraison 1 cycle beau tps",85,0.62,0.52,null,107,87,1.05,2.2000000000000002,12.5,374,5,50,0.85,null,null,null,"ALIMENTS COPRODUITS (riche en eau)"]
[null,"foin","Foin moha",null,0.65,0.65,null,70,65,null,null,null,null,5,50,0.85]
[null,"foin","Foin PP épiaison beau tps",85,0.72,0.63,null,69,82,1.2,3.1,4.2,333,5,50,0.85,null,null,"Code Table INRA","Aliments","% MS","ufl","ufv",null,"pdin","pdie","ueb","p","ca","cb"]
[null,"foin","Foin PP floraison beau tps",85,0.63,0.53,null,58,73,1.31,3.1,3.9,353,5,50,0.85,null,null,null,"Fibre de blé",50]
["rga","foin","Foin Rga 2 em cycle beau tps",85,0.74,0.66,null,78,85,1.07,2.7,4.3,297,5,50,0.85,null,null,null,"Purée de pomme de terre",40,1.1399999999999999,1.1499999999999999,{"$f":"(V47+W47)/2","v":1.145},42,86,null,null,null,null,105,"bobineau"]
["rga","foin","Foin Rga épiaison 1 er cycle beau tps ",85,0.81,0.74,null,75,87,1.1200000000000001,2.4,4.3,287,5,50,0.85,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1050,"bobineau"]
["rga","foin","Foin Rga floraison 1 er cycle beau tps ",85,0.64,0.55000000000000004,null,59,72,1.28,2.2000000000000002,3.9,335,5,50,0.85]
["rgi","foin","Foin Rgi 2 em cycle beau tps",85,0.7,0.61,null,76,82,1.07,2.4,3.5,310,5,50,0.85]
["rgi","foin","Foin Rgi épiaison 1 cycle beau tps",85,0.74,0.66,null,54,75,1.08,2.2000000000000002,3.5,288,5,50,0.85]
["rgi","foin","Foin Rgi floraison 1 cycle beau tps",85,0.61,0.52,null,36,61,1.26,1.9,3.5,327,5,50,0.85]
[null,"foin","foin trèfle bougeon",85,0.67,0.57999999999999996,null,110,89,1.01,2.4,9.9,280,5,50,0.85]
[null,"foin","foin trèfle floraison",85,0.63,0.53,null,91,81,1.1100000000000001,2.2000000000000002,9.5,337,5,50,0.85]
[null,"foin","foin trèfle repousse",85,0.65,0.56000000000000005,null,116,90,0.96,2.4,10.3,286,5,50,0.85]
[null,null,"herbe",10,0.94,0.87,{"$f":"(E56+F56)/2","v":0.90500000000000003},145,112,null,null,null,null,15,50,1]
[null,null,"Maïs épis complets MS",53,1.08,1.05,null,61,98,0.9,1.8,2,90,5,50,1]
[null,null,"Maïs sécheresse pauvre en épi",32,0.84,0.73,null,47,64,1.1599999999999999,1.8,2,203,30,0,1]
[null,null,"paille blé",88,0.42,0.31,null,22,44,1.8,1,2,420,5,25,0.88]
[null,null,"paille cannes de mais",52.4,0.6,0.51,null,30,60,1.3,1.5,3,310]
[null,"foin","paille luzerne",88,0.45,0.4,null,55,45,null,null,null,null,5,30,0.88]
[null,null,"Paille orge",88,0.44,0.33,null,24,46,1.8,1,3.5,420]
[null,null,"Paille pois",86,0.53,0.42,null,42,60,1.27,1,5,413]
[null,null,"Pommes de terre",20,1.2,1.22,null,63,103,0.7,2,0.5,26]
[null,null,"seigle début épiaison",null,0.87,0.81,null,88,87,null,3.5,4.5]
[null,null,"seigle épiaison",null,0.84,0.78,null,84,84,null,3,4]
[null,null,"sorgho fourrager",25,0.68,0.59,null,55,66,1.27,null,null,null,5,25,1]

{"sheet":"Feuil1","index":5,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Prix","année",null,2009,2011,2014]
[null,null,null,null,null,null,null,null,"blé",null,297,170,438]
[null,null,null,null,null,null,null,null,"Tourteau de soja 48",null,110,310,140]
[]
[null,null,null,null,null,null,null,null,"UF","PDIN"]
[null,null,null,null,null,null,null,"marché graine de soja"]
[null,null,null,null,null,null,null,"soja graine",1.0811999999999999,215,217.47969348659001,255.72490421455936,309.16015325670492]
[null,null,null,null,null,null,null,"soja graine extrudée",1.2671999999999999,262.24,262.23920667117426,305.21739914356544,374.05216137029527]
[null,null,null,null,null,null,null,"soja graine toastée",1.2891999999999999,236.72,245.24557433701443,294.38532041168952,346.2101540079633]
[]
[null,null,null,null,null,null,"différence extrusion graine (cout selon quantité 30 à 50€ /T)",null,null,null,{"$f":"K22-K21","v":44.75951318458425},{"$f":"L22-L21","v":49.492494929006085},64.89200811359035]
[null,null,null,null,null,null,"différence toastage graine cout selon quantité inférieur à l'extrusion, permet de passer des produits plus riche en huile)",null,null,null,{"$f":"K23-K21","v":27.765880850424423},{"$f":"L23-L21","v":38.660416197130161},37.050000751258381]
[]
[null,null,null,null,null,null,"L'extrusion consiste à presser les graines à l'aide d'une visse. Cela à pour effet de déstructurer le produit et de le chauffer 130 à 160 C, cela provoque une augmentation des valeurs PDIA et surtout PDIE facteur moins limitant "]
[null,null,null,null,null,null,"le toastage est une opération de chauffage à haute température, le cout est légèrement inférieur 30€"]
[null,null,null,null,null,null,"Ainsi quand le prix du produit est peu élevé le cout du procès ne permet pas de compenser l'amélioration de la valeur du produit"]
[]
[null,null,null,null,null,null,"Prix cas types",2005,6,7,8,9,10,11,12,13,14,15]
[null,null,null,null,null,null,"Blé:",94,108,174,140,110,160,170,210,160,140,140]
[null,null,null,null,null,null,"soja 48 - 5 10 T",205,200,250,300,297,288,310,437,459,438,402]