{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calcul","Mode d'emploi"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Calcul","index":0,"n_rows":47,"n_cols":31,"rows_kept":47,"cut":false,"hidden":false,"merged":[[44,4,44,5],[43,4,43,5],[43,7,43,8],[43,9,43,10],[43,13,43,14],[44,9,44,10],[44,15,44,16],[42,15,42,16],[44,13,44,14],[44,11,44,12],[43,15,43,16],[38,7,38,8],[38,9,38,10],[39,13,39,14],[35,7,35,8],[42,4,42,5],[33,4,33,5],[35,9,35,10],[35,13,35,14],[31,2,31,3],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,2,33,3],[31,11,31,12],[31,13,31,14],[3,7,3,8],[3,9,3,10],[3,13,3,14],[5,2,17,2],[18,2,30,2],[3,2,3,3],[3,6,4,6],[43,2,44,3],[3,11,3,12],[35,11,35,12],[38,11,38,12],[43,11,43,12],[31,9,31,10],[31,7,31,8],[32,7,32,8],[32,2,32,3],[32,9,32,10],[32,11,32,12],[42,7,42,8],[42,9,42,10],[42,11,42,12],[34,2,34,3],[44,7,44,8],[44,17,44,18],[43,17,43,18],[42,13,42,14],[3,17,3,18],[31,17,31,18],[31,15,31,16],[39,15,39,16],[40,15,40,16],[3,15,3,16],[35,17,35,18],[40,17,40,18],[39,17,39,18],[32,13,32,14],[35,15,35,16],[40,13,40,14],[41,13,41,14],[45,15,45,16],[45,17,45,18],[45,4,45,5],[46,2,46,3],[45,2,45,3],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[32,15,32,16],[32,17,32,18],[41,15,41,16],[41,17,41,18],[42,17,42,18],[33,15,33,16],[33,17,33,18]]}
[null,null,null,null,"BILAN FOURRAGER PREVISIONNEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"oui"]
[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,"BESOINS DES ANIMAUX",null,"Nombre","Période","Quantité MS recommandée","Ens. Maïs",null,"Ens. Herbe",null,"autre fourrage",null,"Foin",null,"Enrubanage",null,"Paille aliment"]
[null,null,null,null,"d' animaux","nb jours",null,"/jour (kg MS)","période","/jour (kg MS)","période","/jour (kg MS)","période","/jour (kg MS)","période","/jour (kg MS)","période","/jour (kg MS)","période",null,null,null,null,null,"Liste autres fourrages",null,null,"Liste d'animaux"]
[null,null,"HIVER - STABULATION","Vaches allaitantes à l’entretien",50,60,{"$f":"IF(D6=\"\",\"\",VLOOKUP(D6,$AB$7:$AC$31,2))","v":10},null,{"$f":"IF(H6<>\"\",E6*F6*H6,\"\")","v":""},null,{"$f":"IF(J6=\"\",\"\",E6*F6*J6)","v":""},null,{"$f":"IF(L6=\"\",\"\",E6*F6*L6)","v":""},11,{"$f":"IF(N6=\"\",\"\",E6*F6*N6)","v":33000},null,{"$f":"IF(P6=\"\",\"\",E6*F6*P6)","v":""},null,{"$f":"IF(R6=\"\",\"\",E6*F6*R6)","v":""},null,{"$f":"R6+P6+N6+L6+J6+H6","v":11}]
[null,null,null,null,null,null,{"$f":"IF(D7=\"\",\"\",VLOOKUP(D7,$AB$7:$AC$31,2))","v":""},null,{"$f":"IF(H7<>\"\",E7*F7*H7,\"\")","v":""},null,{"$f":"IF(J7=\"\",\"\",E7*F7*J7)","v":""},null,{"$f":"IF(L7=\"\",\"\",E7*F7*L7)","v":""},null,{"$f":"IF(N7=\"\",\"\",E7*F7*N7)","v":""},null,{"$f":"IF(P7=\"\",\"\",E7*F7*P7)","v":""},null,{"$f":"IF(R7=\"\",\"\",E7*F7*R7)","v":""},null,{"$f":"R7+P7+N7+L7+J7+H7","v":0},null,null,null,"autre fourrage humide",null,null,"agnelles",0.9,null,"Silo couloir"]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,"betterave",null,null,"béliers",2,null,"Silo taupinière"]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,"ensilage mélange immature",null,null,"brebis",1.7]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,"ensilage sorgho",null,null,"Chèvres",1.7]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,"autre fourrage",null,null,"Génisses allaitantes < 1 an",4]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,"Choux",null,null,"Génisses allaitantes 1-2 ans",6]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,"Génisses allaitantes 2-3 ans",9]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,"Génisses laitières 12-18 mois",6]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,"Taurillons (mais ens. +4 kg concentré)",5.25]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,"Vaches allaitantes à l’entretien",10]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,"Vaches allaitantes en lactation",12]
[null,null,null,"TOTAL HIVER (en TMS)",null,null,null,null,{"$f":"SUM(I6:I17)/1000","v":0},null,{"$f":"SUM(K6:K17)/1000","v":0},null,{"$f":"SUM(M6:M17)/1000","v":0},null,{"$f":"SUM(O6:O17)/1000","v":33},null,{"$f":"SUM(Q6:Q17)/1000","v":0},null,{"$f":"SUM(S6:S17)/1000","v":0},null,null,null,null,null,null,null,null,"Vaches en finition",12]
[null,null,"PRINTEMPS ÉTÉ ","Vaches allaitantes en lactation",45,60,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,$AB$7:$AC$31,2))","v":12},null,{"$f":"IF(H19<>\"\",E19*F19*H19,\"\")","v":""},null,{"$f":"IF(J19=\"\",\"\",E19*F19*J19)","v":""},null,{"$f":"IF(L19=\"\",\"\",E19*F19*L19)","v":""},5,{"$f":"IF(N19=\"\",\"\",E19*F19*N19)","v":13500},null,{"$f":"IF(P19=\"\",\"\",E19*F19*P19)","v":""},null,{"$f":"IF(R19=\"\",\"\",E19*F19*R19)","v":""},null,5,null,null,null,null,null,null,"Vaches lait. taries + génisses  à vêler",15]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,"Vaches laitières ",15]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0,null,null,null,null,null,null,"Veaux 2-6 mois",3]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,null,null,null,"",null,"",null,"",null,"",null,"",null,"",null,"",null,0]
[null,null,null,"TOTAL PRINTEMPS ÉTÉ (en TMS)",null,null,null,null,{"$f":"SUM(I19:I30)/1000","v":0},null,{"$f":"SUM(K19:K30)/1000","v":0},null,{"$f":"SUM(M19:M30)/1000","v":0},null,{"$f":"SUM(O19:O30)/1000","v":13.5},null,{"$f":"SUM(Q19:Q30)/1000","v":0},null,{"$f":"SUM(S19:S30)/1000","v":0}]
[null,null,null,null,null,null,null,{"$f":"H4","v":"Ens. Maïs"},null,{"$f":"J4","v":"Ens. Herbe"},null,{"$f":"L4","v":"autre fourrage"},null,{"$f":"N4","v":"Foin"},null,{"$f":"P4","v":"Enrubanage"},null,{"$f":"R4","v":"Paille aliment"}]
[null,null,"Taux de perte (%)",null,null,null,null,7.0000000000000007E-2,null,0.1,null,0.1,null,0.05,null,0.1,null,0.05]
[null,null,"TOTAL BESOINS",null,{"$f":"SUM(H34:S34)","v":48.947368421052637},null,null,{"$f":"(I31+I18)/(1-H33)","v":0},null,{"$f":"(K31+K18)/(1-J33)","v":0},null,{"$f":"(M31+M18)/(1-L33)","v":0},null,{"$f":"(O31+O18)/(1-N33)","v":48.947368421052637},null,{"$f":"(Q31+Q18)/(1-P33)","v":0},null,{"$f":"(S31+S18)/(1-R33)","v":0}]
[null,null,"ETAT des STOCKS"]
[null,null,"STOCKS ENSILAGE",null,null,null,null,{"$f":"H4","v":"Ens. Maïs"},null,{"$f":"J4","v":"Ens. Herbe"},null,{"$f":"L4","v":"autre fourrage"},null,{"$f":"N4","v":"Foin"},null,{"$f":"P4","v":"Enrubanage"},null,{"$f":"R4","v":"Paille aliment"}]
[null,null,"Teneur amidon      /          hauteur"]
[null,null,"taux de matière sèche      /      densité kg matière sèche /m3",null,null,null,null,null,{"$f":"IF(H40=\"Silo couloir\",I41,0.9*I41)","v":0},null,{"$f":"IF(J40=\"Silo couloir\",K41,0.9*K41)","v":""}]
[null,null,"Volume m3 (largeur x longueur x hauteur)"]
[null,null,"Type de silo     /       Poids moyen des bottes (kg brut)",null,null,null,null,"Silo taupinière",null,"Silo couloir",null,null,null,330]
[null,null,"Nombre de bottes",null,null,null,null,null,{"$f":"(929-17.5*H38*100+7.9*H37*100+44*I37)*H38","v":0},null,{"$f":"IF(K37=\"\",\"\",IF(J38<=0.35,7*K37+3.7*J38*100+74,12*K37+3.7*((0.34-J38)+0.34)*100+78))","v":""},null,null,190]
[null,null,"Teneur estimée en matiere sèche(%)",null,null,null,null,null,null,null,null,null,null,0.85,null,0.66,null,0.9]
[null,null,"Stock (kgs Mat sèche)",null,{"$f":"SUM(H43:S43)","v":{"$error":"#VALUE!"}},null,null,{"$f":"H39*I38/1000","v":0},null,{"$f":"J39*K38/1000","v":{"$error":"#VALUE!"}},null,{"$f":"L39*L38*(1-L33)","v":0},null,{"$f":"N40*N41*N42*(1-N33)/1000","v":50.630249999999997},null,{"$f":"P40*P41*P42*(1-P33)/1000","v":0},null,{"$f":"R40*R41*R42*(1-R33)/1000","v":0}]
[null,null,"BILAN ",null,"Global",null,null,{"$f":"H4","v":"Ens. Maïs"},null,{"$f":"J4","v":"Ens. Herbe"},null,{"$f":"L4","v":"autre fourrage"},null,{"$f":"N4","v":"Foin"},null,{"$f":"P4","v":"Enrubanage"},null,{"$f":"R4","v":"Paille aliment"}]
[null,null,null,null,{"$f":"SUM(H45:R45)","v":{"$error":"#VALUE!"}},null,null,{"$f":"H43-H34","v":0},null,{"$f":"J43-J34","v":{"$error":"#VALUE!"}},null,{"$f":"L43-L34","v":0},null,{"$f":"N43-N34","v":1.6828815789473595},null,{"$f":"P43-P34","v":0},null,{"$f":"R43-R34","v":0}]
[null,null,"Prévision récolte - achat",null,{"$f":"SUM(H46:R46)","v":0}]
[null,null,"Rendement / Surface",null,null,null,null,null,{"$f":"IF(H47>0,H46/H47,\"\")","v":""},null,{"$f":"IF(J47>0,J46/J47,\"\")","v":""},null,{"$f":"IF(L47>0,L46/L47,\"\")","v":""},null,{"$f":"IF(N47>0,N46/N47,\"\")","v":""},null,{"$f":"IF(P47>0,P46/P47,\"\")","v":""},null,{"$f":"IF(R47>0,R46/R47,\"\")","v":""}]

{"sheet":"Mode d'emploi","index":1,"n_rows":135,"n_cols":7,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"cubage d’un silo taupinière   multiplier la longueur (L) "]
[null,"et la largeur à mi-hauteur du silo (l)  par la hauteur (H)"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"A titre indicatif, l’ordre de grandeur du poids (brut) "]
[null,null,null,null,null,null,"de différents types de bottes est le suivant :"]