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

{"sheet":"rat","index":0,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,3,0,7]]}
[null,null,null,"Valeurs aliments par kg MB"]
[null,null,null,null,"Densité"]
[null,null,null,"MS (%)","kg/l",null,"MADC(g/kg)",null,"UFC (/kg)","MADC/UFC","P (g/kg)","Ca (g/kg)","Tarif TTC"]
[null,"FOURRAGES"]
[null,null,null,0,null,null,0,null,0,null,0,0,"90 e/tonne"]
[null,"FOIN prairie 1er cyc fin mai",null,85,null,null,55,null,0.5,null,2.7,3.9,"90 e/tonne"]
[null,"FOIN prairie 1er cyc mi-juin",null,85,null,null,41,null,0.45,null,2.6,3.6,"90 e/tonne"]
[null,"FOIN prairie 1er cyc fin juin",null,85,null,null,31,null,0.39,null,2.6,3.3,"90 e/tonne"]
[null,"FOIN prairie 2eme cyc",null,85,null,null,68,null,0.5,null,2.7,4.8,"90 e/tonne"]
[null,"FOIN enrubanné",null,55,null,null,29,null,0.26,null,1.7,2.86,"120e/tonne"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LITIERES"]
[]
[null,"Paille de blé",null,88,null,null,0,null,0.26,{"$f":"G23","v":0},0.88,1.7,"70 e/tonne"]
[null,"Paille d'orge",null,88,null,null,0,null,0.28000000000000003,{"$f":"G24","v":0},0.88,1.7,"70 e/tonne"]
[null,"Paille d'avoine",null,88,null,null,0,null,0.31,0,0.88,1.7,"70 e/tonne"]
[]
[]
[]
[]
[null,"CONCENTRES"]
[]
[null,"Orge",null,86.7,{"$f":"1/1.74","v":0.57471264367816088},null,71,null,0.99,{"$f":"G32","v":71},3.5,0.7,0.24]
[null,"Orge aplatie",null,86.7,{"$f":"1/2.75","v":0.36363636363636365},null,71,null,0.99,71,3.5,0.7,0.25]
[null,"Avoine ",null,88,{"$f":"1/1.625","v":0.61538461538461542},null,69,null,0.87,69,3.2,1.1000000000000001,0.22]
[null,"Mais conc",null,86.4,{"$f":"1/1.6","v":0.625},null,57,null,1.1200000000000001,57,2.6,0.4,0.32]
[null,"Triticale",null,87.3,{"$f":"1/1.625","v":0.61538461538461542},null,67,null,1.06,67,3.5,0.7]
[null,"Tourteau soja 48",null,87.8,{"$f":"1/1.64","v":0.6097560975609756},null,383,null,0.83,383,6.2,3.4,0.65]
[null,"Pulpe de bettrave deshydraté ",null,89,null,null,26,null,0.76,26,0.9,13,0.4]
[null,"Son de blé",null,86.6,null,null,122,null,0.86,122,9.6,1.4]
[null,"Luzerne dehy 17",null,90.6,0.67500000000000004,null,94,null,0.54,94,2.2999999999999998,19.7,0.35]
[null,"Blé dur",null,87.6,{"$f":"1/1.625","v":0.61538461538461542},null,102,null,1.06,102,3.4,0.8,0.22]
[null,"Huile",null,100,1,null,0,null,2.96,0,0,0,1.5]
[null,"Granulé HN",null,88,{"$f":"1/1.625","v":0.61538461538461542},null,80,null,0.75,80,4.8,8.8000000000000007,0.38]
[null,"Bouchons Evolution",null,88,0.7,null,103,null,0.81,103,6,12,0.438]
[null,"Equida Mash",null,88,{"$f":"1/2.5","v":0.4},null,79.81,null,1.03,79.81,3.2,0.7,0.82499999999999996]
[null,"Equida Elevage Plus",null,88,{"$f":"1/2.78","v":0.35971223021582738},null,110.07,null,0.84,110.07,5,14.1,0.91]
[null,"Granulé adult",null,88,0.625,null,73,null,0.95,73,5,10,0.78]
[null,"Floconné Adult",null,88,0.55000000000000004,null,82,null,0.97,82,4.5,8.5,0.57999999999999996]
[]
[]
[null,"MINERAUX "]
[]
[null,"Carb calcium 385-0",null,100,null,null,0,null,0,null,0,385]
[null,"Lithotamne 340-35",null,100,null,null,0,null,0,null,35,340]
[null,"Mineral perf 200-20",null,100,null,null,0,null,0,null,20,200,3.75]
[null,"Minboost 210-70",null,96,null,null,null,null,null,null,70,210,2.08]
[null,"Yearly mineral 150-50",null,96,null,null,null,null,null,null,50,150,4.5]
[null,"Mineral élevage  180-30",null,96,null,null,null,null,null,null,30,180,5]

{"sheet":"Feuil1","index":1,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[26,3,26,4],[5,11,5,14],[13,7,13,9],[14,7,14,9],[10,7,10,9],[11,7,11,9],[12,7,12,9],[5,3,5,6],[5,7,5,10],[15,7,15,9],[16,7,16,9],[17,7,17,9],[18,7,18,9],[19,7,19,9],[25,10,25,11],[27,10,27,11],[28,10,28,11],[1,5,1,6],[6,7,6,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[26,7,26,9],[27,6,27,8],[28,6,28,8]]}
[null,null,null,"Type cheval :",null,"adulte",null,null,null,null,"Nom cheval :"]
[null,null,null,"Niveau :",null,"travail_intense",null,null,null,null,"Date :"]
[null,null,null,"Poids :",null,600,"Kg"]
[]
[]
[null,null,null,"valeur nutritive des aliments par kg MB",null,null,null,"quantités distribuées",null,null,null,"apports nutritifs par aliment par jour",null,null,null,"prix /kg","prix/ jour"]
[null,null,"% MS","UFC","MADC (g)","Ca (g)","P (g)","en kg MB",null,null,"en litres","UFC","MADC (g)","Ca (g)","P (g)",null,null,"calcul MS"]
["Fourrages","FOIN prairie 1er cyc fin juin",{"$f":"IF(B8=0,0,VLOOKUP(B8,rat!$B$5:$D$16,3,0))","v":85},{"$f":"IF(B8=0,0,VLOOKUP(B8,rat!$B$5:$I$16,8,0))","v":0.39},{"$f":"IF(B8=0,0,VLOOKUP(B8,rat!$B$5:$I$16,6,0))","v":31},{"$f":"IF(B8=0,0,VLOOKUP(B8,rat!$B$5:$M$17,11,0))","v":3.3},{"$f":"IF(B8=0,0,VLOOKUP(B8,rat!$B$5:$M$17,10,0))","v":2.6},6,null,null,"/",{"$f":"H8*D8","v":2.34},{"$f":"H8*E8","v":186},{"$f":"H8*F8","v":19.799999999999997},{"$f":"H8*G8","v":15.600000000000001},0.15,{"$f":"H8*P8","v":0.89999999999999991},{"$f":"H8*C8","v":510}]
[null,null,{"$f":"IF(B9=0,0,VLOOKUP(B9,rat!$B$5:$D$16,3,0))","v":0},{"$f":"IF(B9=0,0,VLOOKUP(B9,rat!$B$5:$I$16,8,0))","v":0},{"$f":"IF(B9=0,0,VLOOKUP(B9,rat!$B$5:$I$16,6,0))","v":0},{"$f":"IF(B9=0,0,VLOOKUP(B9,rat!$B$5:$M$17,11,0))","v":0},{"$f":"IF(B9=0,0,VLOOKUP(B9,rat!$B$5:$M$17,10,0))","v":0},null,null,null,"/",{"$f":"H9*D9","v":0},{"$f":"H9*E9","v":0},{"$f":"H9*F9","v":0},{"$f":"H9*G9","v":0},null,0,{"$f":"H9*C9","v":0}]
[null,null,{"$f":"IF(B10=0,0,VLOOKUP(B10,rat!$B$5:$D$16,3,0))","v":0},{"$f":"IF(B10=0,0,VLOOKUP(B10,rat!$B$5:$I$16,8,0))","v":0},{"$f":"IF(B10=0,0,VLOOKUP(B10,rat!$B$5:$I$16,6,0))","v":0},{"$f":"IF(B10=0,0,VLOOKUP(B10,rat!$B$5:$M$17,11,0))","v":0},{"$f":"IF(B10=0,0,VLOOKUP(B10,rat!$B$5:$M$17,10,0))","v":0},null,null,null,"/",0,0,0,0,null,0,0]
["Concentrés","Floconné Adult",{"$f":"IF(B11=0,0,VLOOKUP(B11,rat!$B$32:$M$50,3,0))","v":88},{"$f":"IF(B11=0,0,VLOOKUP(B11,rat!$B$32:$M$50,8,0))","v":0.97},{"$f":"IF(B11=0,0,VLOOKUP(B11,rat!$B$32:$M$50,6,0))","v":82},{"$f":"IF(B11=0,0,VLOOKUP(B11,rat!$B$32:$M$50,11,0))","v":8.5},{"$f":"IF(B11=0,0,VLOOKUP(B11,rat!$B$32:$M$50,10,0))","v":4.5},4.5,null,null,null,4.3650000000000002,369,38.25,20.25,null,0,396]
[null,"Huile",{"$f":"IF(B12=0,0,VLOOKUP(B12,rat!$B$32:$M$50,3,0))","v":100},{"$f":"IF(B12=0,0,VLOOKUP(B12,rat!$B$32:$M$50,8,0))","v":2.96},{"$f":"IF(B12=0,0,VLOOKUP(B12,rat!$B$32:$M$50,6,0))","v":0},{"$f":"IF(B12=0,0,VLOOKUP(B12,rat!$B$32:$M$50,11,0))","v":0},{"$f":"IF(B12=0,0,VLOOKUP(B12,rat!$B$32:$M$50,10,0))","v":0},0.5,{"$f":"IF(#REF!=0,0,VLOOKUP(#REF!,rat!$B$30:$M$50,4,0))","v":{"$error":"#REF!"}},{"$f":"IF(A12=0,0,VLOOKUP(A12,rat!$B$30:$M$50,4,0))","v":0},null,1.48,0,0,0,null,0,50]
[null,null,{"$f":"IF(B13=0,0,VLOOKUP(B13,rat!$B$32:$M$50,3,0))","v":0},{"$f":"IF(B13=0,0,VLOOKUP(B13,rat!$B$32:$M$50,8,0))","v":0},{"$f":"IF(B13=0,0,VLOOKUP(B13,rat!$B$32:$M$50,6,0))","v":0},{"$f":"IF(B13=0,0,VLOOKUP(B13,rat!$B$32:$M$50,11,0))","v":0},{"$f":"IF(B13=0,0,VLOOKUP(B13,rat!$B$32:$M$50,10,0))","v":0},{"$f":"IF(B13=0,0,VLOOKUP(B13,rat!$B$30:$M$50,4,0))*K13","v":0},{"$f":"IF(#REF!=0,0,VLOOKUP(#REF!,rat!$B$30:$M$50,4,0))","v":{"$error":"#REF!"}},{"$f":"IF(A13=0,0,VLOOKUP(A13,rat!$B$30:$M$50,4,0))","v":0},null,0,0,0,0,null,0,0]
[null,null,{"$f":"IF(B14=0,0,VLOOKUP(B14,rat!$B$32:$M$50,3,0))","v":0},{"$f":"IF(B14=0,0,VLOOKUP(B14,rat!$B$31:$M$50,8,0))","v":0},{"$f":"IF(B14=0,0,VLOOKUP(B14,rat!$B$31:$M$50,6,0))","v":0},{"$f":"IF(B14=0,0,VLOOKUP(B14,rat!$B$32:$M$50,11,0))","v":0},{"$f":"IF(B14=0,0,VLOOKUP(B14,rat!$B$32:$M$50,10,0))","v":0},{"$f":"IF(B14=0,0,VLOOKUP(B14,rat!$B$30:$M$50,4,0))*K14","v":0},{"$f":"IF(#REF!=0,0,VLOOKUP(#REF!,rat!$B$30:$M$50,4,0))","v":{"$error":"#REF!"}},{"$f":"IF(A14=0,0,VLOOKUP(A14,rat!$B$30:$M$50,4,0))","v":0},null,0,0,0,0,null,0,0]
[null,null,{"$f":"IF(B15=0,0,VLOOKUP(B15,rat!$B$32:$M$50,3,0))","v":0},{"$f":"IF(B15=0,0,VLOOKUP(B15,rat!$B$45:$M$50,8,0))","v":0},{"$f":"IF(B15=0,0,VLOOKUP(B15,rat!$B$45:$M$50,6,0))","v":0},{"$f":"IF(B15=0,0,VLOOKUP(B15,rat!$B$32:$M$50,11,0))","v":0},{"$f":"IF(B15=0,0,VLOOKUP(B15,rat!$B$32:$M$50,10,0))","v":0},{"$f":"IF(B15=0,0,VLOOKUP(B15,rat!$B$30:$M$50,4,0))*K15","v":0},{"$f":"IF(#REF!=0,0,VLOOKUP(#REF!,rat!$B$30:$M$50,4,0))","v":{"$error":"#REF!"}},{"$f":"IF(A15=0,0,VLOOKUP(A15,rat!$B$30:$M$50,4,0))","v":0},null,0,0,0,0,null,0,0]
[null,null,{"$f":"IF(B16=0,0,VLOOKUP(B16,rat!$B$32:$M$50,3,0))","v":0},{"$f":"IF(B16=0,0,VLOOKUP(B16,rat!$B$45:$M$50,8,0))","v":0},{"$f":"IF(B16=0,0,VLOOKUP(B16,rat!$B$45:$M$50,6,0))","v":0},{"$f":"IF(B16=0,0,VLOOKUP(B16,rat!$B$32:$M$50,11,0))","v":0},{"$f":"IF(B16=0,0,VLOOKUP(B16,rat!$B$32:$M$50,10,0))","v":0},{"$f":"IF(B16=0,0,VLOOKUP(B16,rat!$B$30:$M$50,4,0))*K16","v":0},{"$f":"IF(#REF!=0,0,VLOOKUP(#REF!,rat!$B$30:$M$50,4,0))","v":{"$error":"#REF!"}},{"$f":"IF(A16=0,0,VLOOKUP(A16,rat!$B$30:$M$50,4,0))","v":0},null,0,0,0,0,null,0,0]
["Litière","Paille de blé",{"$f":"IF(B17=0,0,VLOOKUP(B17,rat!$B$22:$M$26,3,0))","v":88},{"$f":"IF(B17=0,0,VLOOKUP(B17,rat!$B$22:$M$26,8,0))","v":0.26},{"$f":"IF(B17=0,0,VLOOKUP(B17,rat!$B$22:$M$26,6,0))","v":0},{"$f":"IF(B17=0,0,VLOOKUP(B17,rat!$B$22:$M$26,11,0))","v":1.7},{"$f":"IF(B17=0,0,VLOOKUP(B17,rat!$B$22:$M$26,10,0))","v":0.88},2,null,null,"/",0.52,0,3.4,1.76,0.06,0.12,176]
[null,null,null,null,null,null,null,null,null,null,"/",0,0,0,0,null,0,0]
["CMV",null,null,null,null,{"$f":"IF(B19=0,0,VLOOKUP(B19,rat!$B$52:$M$59,11,0))","v":0},{"$f":"IF(B19=0,0,VLOOKUP(B19,rat!$B$52:$M$59,10,0))","v":0},0.115,null,null,"/",0,0,0,0,null,0,0]
[null,null,null,null,null,{"$f":"IF(B20=0,0,VLOOKUP(B20,rat!$B$52:$M$59,11,0))","v":0},{"$f":"IF(B20=0,0,VLOOKUP(B20,rat!$B$52:$M$59,10,0))","v":0},{"$f":"IF(B20=0,0,(G30*SUM(O9:O19)-SUM(N9:N19))/(F20-G30*G20))","v":0},{"$f":"(1.7*39.2-35.9)/(200-1.7*20)","v":0.18518072289156629},0.18518072289156629,"/",0,0,0,0,null,0,0]
[]
[null,null,null,null,null,null,"apports journaliers calculés ",null,null,null,null,{"$f":"SUM(L8:L20)","v":8.7050000000000001},{"$f":"SUM(M8:M20)","v":555},61.449999999999996,37.61,"Total",{"$f":"SUM(Q8:Q20)","v":1.02},{"$f":"SUM(R8:R20)","v":1132}]
[null,null,null,null,null,null,"apports journaliers recommandés ",null,null,null,null,{"$f":"INDEX(ufc,MATCH(1,(type=F1)*(niveau=F2)*(poids=F3),0))","v":8.6},{"$f":"INDEX(madc,MATCH(1,(type=F1)*(niveau=F2)*(poids=F3),0))","v":621},{"$f":"INDEX(Ca,MATCH(1,(type=F1)*(niveau=F2)*(poids=F3),0))","v":48},{"$f":"INDEX(p,MATCH(1,(type=F1)*(niveau=F2)*(poids=F3),0))","v":35}]
[null,null,null,null,null,null,"différence ",null,null,null,null,{"$f":"L22-L23","v":0.10500000000000043},{"$f":"M22-M23","v":-66},{"$f":"N22-N23","v":13.449999999999996},{"$f":"O22-O23","v":2.6099999999999994}]
[]
[null,null,null,"Apports calculés",null,null,"      Recommandations",null,null,null,"Différence"]
[null,"Conso de matière sèche",null,{"$f":"R22/100","v":11.32},null,null,{"$f":"INDEX(msbasse,MATCH(1,(type=F1)*(niveau=F2)*(poids=F3),0))","v":11.5},{"$f":"INDEX(mshaute,MATCH(1,(type=F1)*(niveau=F2)*(poids=F3),0))","v":14.5}]
[null,"MADC/UF",null,{"$f":"M22/L22","v":63.756461803561173},null,null,{"$f":"M23/L23","v":72.209302325581405},null,null,null,{"$f":"G28-D28","v":8.4528405220202316}]
[null,"Ca/P",null,{"$f":"N22/O22","v":1.6338739696889124},null,null,{"$f":"N23/O23","v":1.3714285714285714},null,null,null,{"$f":"G29-D29","v":-0.26244539826034097}]

{"sheet":"chev","index":2,"n_rows":279,"n_cols":12,"rows_kept":279,"cut":false,"hidden":false,"merged":[]}
["Races et stade physiologiques"]
[]
["Type","Poids","Niveau","UFC","MADC","Ca","P","MS basse","MS haute"]
["pouliniere",450,"non_gestante",3.8,274,18,13,6.5,8.5]
["pouliniere",450,"debut_gestation",3.8,274,18,13,6.5,8.5]
["pouliniere",450,"gestante_0-5_mois",3.8,274,18,13,6.5,8.5]
["pouliniere",450,"gestante_6_mois",4.0999999999999996,330,22,17,6.5,9]
["pouliniere",450,"gestante_7_mois",4.3,333,24,18,6.5,9]
["pouliniere",450,"gestante_8_mois",4.5,351,26,19,6.5,9]
["pouliniere",450,"gestante_9_mois",4.7,382,30,23,7,9.5]
["pouliniere",450,"gestante_10_mois",5,453,34,26,7,10.5]
["pouliniere",450,"gestante_11_mois",5.0999999999999996,485,37,29,7.5,11]
["pouliniere",450,"allaitante_1_mois",7.8,868,50,44,10.5,13.5]
["pouliniere",450,"allaitante_2_mois",7.9,838,45,38,11.5,14.5]
["pouliniere",450,"allaitante_3_mois",7.4,792,44,37,11.5,14.5]
["pouliniere",450,"allaitante_4_mois",7,653,36,31,10.5,13.5]
["pouliniere",450,"allaitante_5_mois",6.1,492,32,27,9.5,11.5]
["pouliniere",450,"allaitante_6_mois",5.9,472,31,26,7.5,9.5]
["pouliniere",500,"non_gestante",4.0999999999999996,296,20,14,7,9]
["pouliniere",500,"debut_gestation",4.0999999999999996,296,20,14,7,9]
["pouliniere",500,"gestante_0-5_mois",4.0999999999999996,296,20,14,7,9]
["pouliniere",500,"gestante_6_mois",4.4000000000000004,359,25,18,7,9.5]
["pouliniere",500,"gestante_7_mois",4.7,361,27,20,7,9.5]
["pouliniere",500,"gestante_8_mois",4.9000000000000004,381,29,21,7,9.5]
["pouliniere",500,"gestante_9_mois",5.0999999999999996,416,34,25,7.5,10]
["pouliniere",500,"gestante_10_mois",5.4,495,38,28,7.5,11]
["pouliniere",500,"gestante_11_mois",5.5,530,41,32,8,11.5]
["pouliniere",500,"allaitante_1_mois",8.5,956,56,49,11.5,15]
["pouliniere",500,"allaitante_2_mois",8.6999999999999993,923,50,42,12.5,16]
["pouliniere",500,"allaitante_3_mois",8.1999999999999993,872,49,41,12.5,16]
["pouliniere",500,"allaitante_4_mois",7.7,717,41,35,11.5,15]
["pouliniere",500,"allaitante_5_mois",6.7,538,36,30,10.5,13]
["pouliniere",500,"allaitante_6_mois",6.5,516,34,28,8.5,11]
["pouliniere",550,"non_gestante",4.4000000000000004,318,22,16,7.5,9.5]
["pouliniere",550,"debut_gestation",4.4000000000000004,318,22,16,7.5,9.5]
["pouliniere",550,"gestante_0-5_mois",4.4000000000000004,318,22,16,7.5,9.5]
["pouliniere",550,"gestante_6_mois",4.8,387,28,20,7.5,10]
["pouliniere",550,"gestante_7_mois",5.0999999999999996,390,30,22,7.5,10]
["pouliniere",550,"gestante_8_mois",5.3,412,32,24,7.5,10]
["pouliniere",550,"gestante_9_mois",5.5,450,37,28,8,10.5]
["pouliniere",550,"gestante_10_mois",5.8,537,42,31,8,11.5]
["pouliniere",550,"gestante_11_mois",6,576,46,35,8,12]
["pouliniere",550,"allaitante_1_mois",9.3000000000000007,1044,61,54,12.5,16.5]
["pouliniere",550,"allaitante_2_mois",9.5,1008,55,47,14,17.5]
["pouliniere",550,"allaitante_3_mois",8.9,952,54,46,14,17.5]
["pouliniere",550,"allaitante_4_mois",8.4,781,44,38,12.5,16.5]
["pouliniere",550,"allaitante_5_mois",7.4,544,40,33,11.5,14]
["pouliniere",550,"allaitante_6_mois",7.1,560,38,31,9.5,12]
["pouliniere",600,"non_gestante",4.8,339,24,17,8,10]
["pouliniere",600,"debut_gestation",4.8,339,24,17,8,10]
["pouliniere",600,"gestante_0-5_mois",4.8,339,24,17,8,10]
["pouliniere",600,"gestante_6_mois",5.2,414,30,22,8,10.5]
["pouliniere",600,"gestante_7_mois",5.5,417,33,24,8,10.5]
["pouliniere",600,"gestante_8_mois",5.7,441,35,26,8.5,10.5]
["pouliniere",600,"gestante_9_mois",6,482,40,30,9,11]
["pouliniere",600,"gestante_10_mois",6.3,578,46,34,9,12]
["pouliniere",600,"gestante_11_mois",6.5,620,50,38,9.5,12.5]
["pouliniere",600,"allaitante_1_mois",10.1,1131,67,58,13.5,18]
["pouliniere",600,"allaitante_2_mois",10.3,1091,60,51,15,19]
["pouliniere",600,"allaitante_3_mois",9.6,1030,59,50,15,19]
["pouliniere",600,"allaitante_4_mois",9.1,844,48,41,13.5,18]
["pouliniere",600,"allaitante_5_mois",7.9,629,43,36,12.5,15]
["pouliniere",600,"allaitante_6_mois",7.6,603,41,34,10.5,13]
["adulte",450,"entretien",3.8,247,18,13,7,8.5]
["adulte",450,"travail_tres_leger",5,360,27,17,8.5,9.5]
["adulte ",450,"travail_leger",6.6,475,27,17,9.5,11.5]
["adulte",450,"travail_modéré",7.2,518,32,19,10.5,12.5]
["adulte",450,"travail_intense",6.8,492,36,26,10,11.5]
["adulte",450,"travail_tres_intense",7.6,547,41,28,10,11]
["adulte",500,"entretien",4.0999999999999996,267,20,14,7.5,9.5]
["adulte ",500,"travail_tres_leger",5.3,382,30,19,9,10.5]
["adulte",500,"travail_leger",7.1,511,30,19,10,12.5]
["adulte",500,"travail_modéré",7.8,562,35,21,11,13.5]
["adulte",500,"travail_intense",7.3,526,40,29,10,12.5]
["adulte",500,"travail_tres_intense",8.3000000000000007,594,45,31,10,12.5]
["adulte",550,"entretien",4.5,293,22,16,8.5,10.5]
["adulte ",550,"travail_tres_leger",5.9,424,33,21,9.5,11.5]
["adulte",550,"travail_leger",7.8,565,33,21,10.5,13.5]
["adulte",550,"travail_modéré",8.6,620,39,23,11.5,15.5]
["adulte",550,"travail_intense",8.1,580,44,32,11,13.5]
["adulte",550,"travail_tres_intense",9.1,656,50,34,11,13.5]
["adulte",600,"entretien",4.8,312,24,17,9,11.5]
["adulte ",600,"travail_tres_leger",6.3,450,36,23,10.5,12.5]
["adulte",600,"travail_leger",8.4,603,36,23,11.5,14.5]
["adulte",600,"travail_modéré",9.1999999999999993,664,42,25,13,16]
["adulte",600,"travail_intense",8.6,621,48,35,11.5,14.5]
["adulte",600,"travail_tres_intense",9.8000000000000007,703,54,37,11.5,14.5]
["trait",700,"entretien..",5.0999999999999996,357,28,20,9.5,10.5]
["trait",700,"travail_leger..",7.7,539,42,27,12,13.5]
["trait",700,"travail_modéré..",8.6,602,49,29,13,15.5]
["trait",700,"travail_intense..",10,700,56,41,14,16.5]
["trait",800,"entretien..",5.6,392,32,22,10.5,11.5]
["trait",800,"travail_leger..",7.8,546,48,30,13,14.5]
["trait",800,"travail_modéré..",8.8000000000000007,616,56,34,14,16.5]
["trait",800,"travail_intense..",10.5,735,64,46,15,17.5]
["poney",200,"entretien.",1.7,122,8,6,3,3.8]
["poney",200,"travail_leger.",2.8,199,12,8,4,5]
["poney",200,"travail_modéré. ",3,219,14,9,4.4000000000000004,5.7]
["poney",200,"travail_intense.",2.8,205,16,12,4,5]
["poney",200,"étalon.",3.1,223,14,9,4.4000000000000004,5.7]
["poney",300,"entretien.",2.4,173,12,8,4.5,5.7]
["poney",300,"travail_leger.",4,286,18,11,6,7.5]
["poney",300,"travail_modéré.",4.5,324,21,13,6.6,8.1]
["poney",300,"travail_intense.",4.2,302,24,17,6,7.5]
["poney",300,"étalon.",4.5,324,21,13,6.6,8.1]
["poney",400,"entretien.",3.2,230,16,11,6,7.6]
["poney",400,"travail_leger.",5.4,389,24,15,8,10]
["poney",400,"travail_modéré.",6,432,28,17,8.8000000000000007,10.8]
["poney",400,"travail_intense.",5.6,403,32,23,8,10]
["poney",400,"étalon.",5.8,418,28,17,8.8000000000000007,10.8]
["poney_elevage",200,"croissance__6_12_mois_p",1.9,217,13,9,2.5,3.5]
["poney_elevage",200,"croissance_18_24_mois_p",2.2999999999999998,133,15,10,3.5,4]
["poney_elevage",200,"croissance_30_36_mois_p",2.5,125,16,11,4,5]
["poney_elevage",300,"croissance__6_12_mois_p",2.7,304,19,13,4,5]
["poney_elevage",300,"croissance_18_24_mois_p",3.4,203,22,15,5,6]
["poney_elevage",300,"croissance_30_36_mois_p",3.7,192,24,16,5.5,6.5]
["poney_elevage",400,"croissance__6_12_mois_p",3.6,388,25,18,5,6.5]
["poney_elevage",400,"croissance_18_24_mois_p",4.5,265,29,20,6.5,7.5]
["poney_elevage",400,"croissance_30_36_mois_p",4.9000000000000004,255,32,21,7,8]
["cheval_sport_elevage",450,"croissance_3_6_mois",3.6,372,25,17,4,6]
["cheval_sport_elevage",450,"croissance_6_12_mois",3.9,378,26,18,5.5,7.5]
["cheval_sport_elevage",450,"croissance_18_24_mois",5.3,310,35,24,7.5,9.5]
["cheval_sport_elevage",450,"croissance_30_36_mois",5.7,288,35,24,8,10]
["cheval_sport_elevage",450,"croissance_36_42_mois",5.8,292,36,24,9,11]
["cheval_sport_elevage",500,"croissance_3_6_mois",4,415,29,19,4.5,6.5]
["cheval_sport_elevage",500,"croissance_6_12_mois",4.3,425,29,20,6,8]
["cheval_sport_elevage",500,"croissance_18_24_mois",5.9,344,40,27,8,10.5]
["cheval_sport_elevage",500,"croissance_30_36_mois",6.2,308,39,26,8.5,11]
["cheval_sport_elevage",500,"croissance_36_42_mois",6.3,315,40,27,9.5,12]
["cheval_sport_elevage",550,"croissance_3_6_mois",4.4000000000000004,456,31,21,5,7]
["cheval_sport_elevage",550,"croissance_6_12_mois",4.4000000000000004,461,32,22,6.5,8.5]
["cheval_sport_elevage",550,"croissance_18_24_mois",6.4,369,45,30,8.5,11]
["cheval_sport_elevage",550,"croissance_30_36_mois",6.6,329,42,29,9.5,12]
["cheval_sport_elevage",550,"croissance_36_42_mois",6.5,337,43,29,11,13.5]
["cheval_sport_elevage",600,"croissance_3_6_mois",4.8,497,35,23,5.5,7.5]
["cheval_sport_elevage",600,"croissance_6_12_mois",5,496,35,24,7.5,9.5]
["cheval_sport_elevage",600,"croissance_18_24_mois",6.9,394,47,32,9.5,12]
["cheval_sport_elevage",600,"croissance_30_36_mois",7,350,45,31,10,12.5]
["cheval_sport_elevage",600,"croissance_36_42_mois",7.2,358,47,32,12,14.5]
["cheval_course_elevage",450,"croissance_3_6_mois.",4.5,486,32,22,4.5,6.5]
["cheval_course_elevage",450,"croissance_6_12_mois.",4.5999999999999996,501,33,22,6,8]
["cheval_course_elevage",450,"croissance_18_24_mois.",5.6,300,33,24,8,10]
["cheval_course_elevage",450,"croissance_30_36_mois.",5.8,301,38,25,9,11]
["cheval_course_elevage",500,"croissance_3_6_mois.",5,541,36,24,5,7]
["cheval_course_elevage",500,"croissance_6_12_mois.",5.0999999999999996,567,37,25,6.5,8.5]
["cheval_course_elevage",500,"croissance_18_24_mois.",6.1,331,38,27,8.5,11]
["cheval_course_elevage",500,"croissance_30_36_mois.",6.4,335,44,29,9.5,12]
["cheval_course_elevage",550,"croissance_3_6_mois.",5.5,595,40,27,5.5,7.5]
["cheval_course_elevage",550,"croissance_6_12_mois.",5.5,591,39,27,7,9]
["cheval_course_elevage",550,"croissance_18_24_mois.",6.6,360,44,30,9,11.5]
["cheval_course_elevage",550,"croissance_30_36_mois.",7,371,51,32,11,13.5]
["cheval_course_elevage",600,"croissance_3_6_mois.",6,647,44,29,6,8]
["cheval_course_elevage",600,"croissance_6_12_mois.",6,661,43,30,8,10]
["cheval_course_elevage",600,"croissance_18_24_mois.",7.1,388,48,33,10,12.5]
["cheval_course_elevage",600,"croissance_30_36_mois.",7.5,406,57,36,12,14.5]
["poney_poulinière.",200,"non_gestante.",1.7,122,8,6,3.2,4.2]
["poney_poulinière.",200,"debut_gestation.",1.7,122,8,6,3.2,4.2]
["poney_poulinière.",200,"gestante_0-5_mois.",1.7,122,8,6,3.2,4.2]
["poney_poulinière.",200,"gestante_6_mois.",1.8,147,10,8,3.2,4.5]
["poney_poulinière.",200,"gestante_7_mois.",1.9,148,11,8,3.2,4.5]
["poney_poulinière.",200,"gestante_8_mois.",2,156,12,9,3.2,4.5]
["poney_poulinière.",200,"gestante_9_mois.",2.1,170,14,10,3.5,4.8]
["poney_poulinière.",200,"gestante_10_mois.",2.2000000000000002,202,15,12,3.5,5]
["poney_poulinière.",200,"gestante_11_mois.",2.2999999999999998,216,17,13,3.8,5.2]
["poney_poulinière.",200,"allaitante_1_mois.",3.5,386,22,20,5,6.6]
["poney_poulinière.",200,"allaitante_2_mois.",3.6,373,20,17,5.3,6.9]
["poney_poulinière.",200,"allaitante_3_mois.",3.3,352,20,17,5.3,6.9]
["poney_poulinière.",200,"allaitante_4_mois.",3.1,290,16,14,5,6.6]
["poney_poulinière.",200,"allaitante_5_mois.",2.7,219,14,12,4.5,6]
["poney_poulinière.",200,"allaitante_6_mois.",2.6,210,14,12,3.8,5]
["poney_poulinière.",300,"non_gestante.",2.4,173,15,12,4.8,6.3]
["poney_poulinière.",300,"debut_gestation.",2.4,173,15,12,4.8,6.3]
["poney_poulinière.",300,"gestante_0-5_mois.",2.4,173,15,12,4.8,6.3]
["poney_poulinière.",300,"gestante_6_mois.",2.6,211,15,12,5.0999999999999996,6.5]
["poney_poulinière.",300,"gestante_7_mois.",2.7,212,16,12,5.0999999999999996,6.5]
["poney_poulinière.",300,"gestante_8_mois.",2.9,224,18,12,5.0999999999999996,6.5]
["poney_poulinière.",300,"gestante_9_mois.",3,245,20,15,5.4,6.8]
["poney_poulinière.",300,"gestante_10_mois.",3.2,292,22,17,5.4,7.3]
["poney_poulinière.",300,"gestante_11_mois.",3.3,313,25,19,5.7,7.8]
["poney_poulinière.",300,"allaitante_1_mois.",5,497,34,29,7.2,9.6]
["poney_poulinière.",300,"allaitante_2_mois.",5.0999999999999996,549,30,25,7.5,9.9]
["poney_poulinière.",300,"allaitante_3_mois.",4.8,519,29,24,7.5,9.9]
["poney_poulinière.",300,"allaitante_4_mois.",4.5,425,24,20,7.2,8.9]
["poney_poulinière.",300,"allaitante_5_mois.",3.9,318,21,17,6.7,7.9]
["poney_poulinière.",300,"allaitante_6_mois.",3.8,305,20,16,5.7,7.2]
["poney_poulinière.",400,"non_gestante.",3.2,230,16,11,6,8]
["poney_poulinière.",400,"debut_gestation.",3.2,230,16,11,6,8]
["poney_poulinière.",400,"gestante_0-5_mois.",3.2,230,16,11,6,8]
["poney_poulinière.",400,"gestante_6_mois.",3.4,280,20,14,6,8.5]
["poney_poulinière.",400,"gestante_7_mois.",3.6,282,22,16,6,8.5]
["poney_poulinière.",400,"gestante_8_mois.",3.8,298,23,17,6,8.5]
["poney_poulinière.",400,"gestante_9_mois.",4,326,27,20,6.5,9]
["poney_poulinière.",400,"gestante_10_mois.",4.2,389,31,22,7,9.5]
["poney_poulinière.",400,"gestante_11_mois.",4.3,417,33,25,7.5,10]
["poney_poulinière.",400,"allaitante_1_mois.",6.7,758,45,39,9.5,12.5]
["poney_poulinière.",400,"allaitante_2_mois.",6.8,732,40,33,10.5,13.5]
["poney_poulinière.",400,"allaitante_3_mois.",6.4,691,39,33,10.5,13.5]
["poney_poulinière.",400,"allaitante_4_mois.",6,566,32,27,9.5,12.5]
["poney_poulinière.",400,"allaitante_5_mois.",5.2,424,28,23,8,10.5]
["poney_poulinière.",400,"allaitante_6_mois.",5.0999999999999996,406,27,22,7,9]
[]
[]
[]
[null,null,null,null,"pouliniere","adulte","poney","poney_poulinière.","cheval_sport_elevage","trait","cheval_course_elevage","poney_elevage"]
["pouliniere","adulte",null,"type","non_gestante","entretien","entretien.","non_gestante.","croissance_3_6_mois","entretien..","croissance_3_6_mois.","croissance__6_12_mois_p"]
["non_gestante","entretien",null,"adulte",450,450,200,200,450,700,450,200]
["debut_gestation","travail_tres_leger",null,"poney",500,500,300,300,500,800,500,300]
["gestante_0-5_mois","travail_leger",null,"pouliniere",550,550,400,400,550,null,550,400]
["gestante_6_mois","travail_modéré",null,"poney_poulinière.",600,600,null,null,600,"travail_leger..",600,"croissance_18_24_mois_p"]
["gestante_7_mois","travail_intense",null,"cheval_sport_elevage","debut_gestation","travail_tres_leger","travail_leger.","debut_gestation.","croissance_6_12_mois",700,"croissance_6_12_mois.",200]
["gestante_8_mois","travail_tres_intense",null,"cheval_course_elevage",450,450,200,200,450,800,450,300]
["gestante_9_mois",null,null,"poney_elevage",500,500,300,300,500,null,500,400]
["gestante_10_mois","poney",null,"trait",550,550,400,400,550,"travail_modéré..",550,"croissance_30_36_mois_p"]
["gestante_11_mois","entretien.",null,null,600,600,null,null,600,700,600,200]
["allaitante_1_mois","travail_leger.",null,null,"gestante_0-5_mois","travail_leger","travail_modéré.","gestante_0-5_mois.","croissance_18_24_mois",800,"croissance_18_24_mois.",300]
["allaitante_2_mois","travail_modéré.",null,null,450,450,200,200,450,null,450,400]
["allaitante_3_mois","travail_intense.",null,null,500,500,300,300,500,"travail_intense..",500]
["allaitante_4_mois","étalon.",null,null,550,550,400,400,550,700,550]
["allaitante_5_mois",null,null,null,600,600,null,null,600,800,600]
["allaitante_6_mois","poney_poulinière.",null,null,"gestante_6_mois","travail_modéré","travail_intense.","gestante_6_mois.","croissance_30_36_mois",null,"croissance_30_36_mois."]
[null,"non_gestante.",null,null,450,450,200,200,450,null,450]
["trait","debut_gestation.",null,null,500,500,300,300,500,null,500]
["entretien..","gestante_0-5_mois.",null,null,550,550,400,400,550,null,550]
["travail_leger..","gestante_6_mois.",null,null,600,600,null,null,600,null,600]
["travail_modéré..","gestante_7_mois.",null,null,"gestante_7_mois","travail_intense","étalon.","gestante_7_mois.","croissance_36_42_mois"]
["travail_intense..","gestante_8_mois.",null,null,450,450,200,200,450]
[null,"gestante_9_mois.",null,null,500,500,300,300,500]
["cheval_sport_elevage","gestante_10_mois.",null,null,550,550,400,400,550]
["croissance_3_6_mois","gestante_11_mois.",null,null,600,600,null,null,600]
["croissance_6_12_mois","allaitante_1_mois.",null,null,"gestante_8_mois","travail_tres_intense",null,"gestante_8_mois."]
["croissance_18_24_mois","allaitante_2_mois.",null,null,450,450,null,200]
["croissance_30_36_mois","allaitante_3_mois.",null,null,500,500,null,300]
["croissance_36_42_mois","allaitante_4_mois.",null,null,550,550,null,400]
[null,"allaitante_5_mois.",null,null,600,600]
["cheval_course_elevage","allaitante_6_mois.",null,null,"gestante_9_mois",null,null,"gestante_9_mois."]
["croissance_3_6_mois.",null,null,null,450,null,null,200]
["croissance_6_12_mois.","poney_elevage",null,null,500,null,null,300]
["croissance_18_24_mois.","croissance_6_12_mois_p",null,null,550,null,null,400]
["croissance_30_36_mois.","croissance_18_24_mois_p",null,null,600]
[null,"croissance_30_36_mois_p",null,null,"gestante_10_mois",null,null,"gestante_10_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]
[null,null,null,null,"gestante_11_mois",null,null,"gestante_11_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]
[null,null,null,null,"allaitante_1_mois",null,null,"allaitante_1_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]
[null,null,null,null,"allaitante_2_mois",null,null,"allaitante_2_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]
[null,null,null,null,"allaitante_3_mois",null,null,"allaitante_3_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]
[null,null,null,null,"allaitante_4_mois",null,null,"allaitante_4_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]
[null,null,null,null,"allaitante_5_mois",null,null,"allaitante_5_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]
[null,null,null,null,"allaitante_6_mois",null,null,"allaitante_6_mois."]
[null,null,null,null,450,null,null,200]
[null,null,null,null,500,null,null,300]
[null,null,null,null,550,null,null,400]
[null,null,null,null,600]

{"sheet":"calculette UFC MADC","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Saisie valeurs analytiques de l'aliment",null,null,null,null,"Valeurs calculées"]
[]
[]
["Humidité ",11.5,null,null,null,"UFC/kg de produit brut",{"$f":"(132.6-0.1937*B8/(1-B7/100)/((100-B9/(1-B7/100))/100)*10-0.0135*B10/(1-B7/100)/((100-B9/(1-B7/100))/100)*10)*((100-B9/(1-B7/100))/100)*(1-B7/100)/100+(IF((B11/(1-B7/100)/((100-B9/(1-B7/100))/100))>3.5,((B11/(1-B7/100)/((100-B9/(1-B7/100))/100))-3.5)*0.02,0))*((100-B9/(1-B7/100))/100)*(1-B7/100)","v":0.76500499999999994}]
["Cellulose brute",15]
["Cendre brute",8,null,null,null,"MADC/kg de produit brut",{"$f":"((-4.94+(0.9133*B13))*0.85)*((100-B7)/100)","v":86.066204744318185}]
["Matière protéique",11.5]
["Matière grasse",3]
[]
["MAT",{"$f":"B10/((100-12)/100)*10","v":130.68181818181819}]

{"sheet":"Sheet2","index":4,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Si rapport MADC/UFC >100"]
[null,"MADC/UFC","UFC",null,"MADC/UFC du mélange recherché :",null,null,null,{"$f":"Feuil1!M24/Feuil1!L24","v":-628.57142857142605}]
["Choisir la céréale :"]
["Orge aplatie",{"$f":"IF(A6=0,0,VLOOKUP(A6,rat!$B$32:$M$50,9,0))","v":71},{"$f":"IF(A6=0,0,VLOOKUP(A6,rat!$B$32:$M$50,8,0))","v":0.99},null,"Proportion mélange calculé :"]
[]
[null,null,null,null,{"$f":"A6","v":"Orge aplatie"},null,{"$f":"A14/A16","v":0.49191361125062777},{"$f":"A11","v":"Luzerne dehy 17"},null,{"$f":"A15/A16","v":0.50808638874937218}]
[]
["Choisir l'aliment azoté :",null,null,null,"Pour équilibrer la ration il faudra donc apporter en complément du foin :"]
["Luzerne dehy 17",{"$f":"IF(A11=0,0,VLOOKUP(A11,rat!$B$32:$M$50,9,0))","v":94},{"$f":"IF(A11=0,0,VLOOKUP(A11,rat!$B$32:$M$50,8,0))","v":0.54}]
[null,null,null,null,{"$f":"A6","v":"Orge aplatie"},null,{"$f":"A18*G8","v":6.7840250153377538E-2},{"$f":"A11","v":"Luzerne dehy 17"},null,{"$f":"A18*J8","v":7.0070652496586408E-2}]
[]
[{"$f":"B6-I4","v":699.57142857142605}]
[{"$f":"B11-I4","v":722.57142857142605}]
[{"$f":"A14+A15","v":1422.1428571428521}]
[{"$f":"(C6*G8)+(C11*J8)","v":0.76136112506278253}]
[{"$f":"Feuil1!L24/Sheet2!A17","v":0.13791090264996395}]