{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["besoin_cultures","login","interface de saisie","caract. MO","type_matière_organique","precaution_epan","canne","précautions ép."],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":82,"comments":3,"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":"besoin_cultures","index":0,"n_rows":128,"n_cols":29,"rows_kept":128,"cut":false,"hidden":false,"merged":[[6,7,7,7],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6]]}
["Besoins des cultures",null,"(kg / ha)"]
["Conseil de fertilisation des cultures (basé sur exportations), en considérant le sol sans déséquilibres (ni carences, ci excès)"]
[]
[]
["Fourrages tempérés",null,"données issues du guide de la fertilisation organique, p.184, pour les fourrages tempérés "]
[]
["Rendement",10,12,15,18,20,22,25]
["(t / ha)"]
["N",300,360,450,540,600,660,750]
["P2O5",{"$f":"60*3","v":180},{"$f":"B10/10*12","v":216},270,324,360,396,450,"(pour 10t/ha, 60'* 3 par rapport au guide de la ferti organique puis règle de trois)"]
["K2O",220,{"$f":"B11/10*12","v":264},330,396,440,484,550,"(valeur minimale du guide retenue pour 10t/ha puis règle de trois)"]
[]
[]
["Légumes",null,"Source: CTIFM"]
[]
[]
[]
[]
[]
[]
["Ail","Rendement (t/ha)","N","P2O5","K2O","Comcombre","Rendement (t/ha)","N","P2O5","K2O","Pastèque","Rendement (t/ha)","N","P2O5","K2O"]
[null,4,80,60,120,null,20,140,90,220,null,30,60,40,120]
[null,6,100,70,140,null,30,160,100,240,null,35,80,50,140]
[null,8,120,80,160,null,40,180,110,260,null,40,100,60,160]
[null,10,140,90,180,null,50,200,120,280,null,45,120,70,180]
[null,12,160,100,200,null,60,220,130,300,null,50,140,80,200]
["Artichaut","Rendement (t/ha)","N","P2O5","K2O","Courgette","Rendement (t/ha)","N","P2O5","K2O","Poireau","Rendement (t/ha)","N","P2O5","K2O"]
[null,18,180,70,300,null,20,80,60,160,null,20,130,50,180]
[null,20,200,80,330,null,25,100,70,200,null,25,160,60,210]
[null,22,220,90,360,null,30,120,80,240,null,30,190,70,240]
[null,24,240,100,390,null,35,140,90,280,null,35,210,80,270]
[null,26,260,110,420,null,40,160,100,320,null,40,240,90,300]
["Aubergine","Rendement (t/ha)","N","P2O5","K2O","Haricot vert","Rendement (t/ha)","N","P2O5","K2O","Poivron","Rendement (t/ha)","N","P2O5","K2O"]
[null,30,150,90,200,null,6,50,60,80,null,20,150,80,250]
[null,40,170,100,240,null,8,75,70,100,null,30,180,90,280]
[null,50,190,110,280,null,10,100,80,120,null,40,210,100,310]
[null,60,210,120,320,null,12,125,90,140,null,50,240,110,340]
[null,70,230,130,360,null,14,150,100,160,null,60,270,120,370]
["Betterave rouge","Rendement (t/ha)","N","P2O5","K2O","Laitue","Rendement (t/ha)","N","P2O5","K2O","Pomme de terre","Rendement (t/ha)","N","P2O5","K2O"]
[null,40,150,80,350,null,40,90,55,180,null,15,75,40,130]
[null,45,180,90,400,null,45,100,60,220,null,20,100,50,180]
[null,50,210,100,450,null,50,120,65,240,null,25,125,60,220]
[null,55,230,110,500,null,55,130,70,260,null,30,150,70,270]
[null,60,250,120,550,null,60,140,75,280,null,35,175,80,310]
["Carotte","Rendement (t/ha)","N","P2O5","K2O","Melon","Rendement (t/ha)","N","P2O5","K2O","Radis","Rendement (t/ha)","N","P2O5","K2O"]
[null,25,70,60,150,null,10,40,50,70,null,15,50,50,80]
[null,30,80,65,180,null,20,80,60,140,null,18,60,55,90]
[null,35,90,70,210,null,30,120,70,210,null,21,70,60,100]
[null,40,100,75,240,null,40,160,80,280,null,24,80,65,110]
[null,45,110,80,270,null,50,200,90,350,null,27,90,70,120]
["Chou-fleur","Rendement (t/ha)","N","P2O5","K2O","Navet","Rendement (t/ha)","N","P2O5","K2O","Tomate","Rendement (t/ha)","N","P2O5","K2O"]
[null,15,100,60,150,null,25,80,30,120,null,20,60,60,120]
[null,20,120,70,180,null,30,100,45,160,null,30,80,70,150]
[null,25,140,80,210,null,35,120,60,200,null,40,100,80,180]
[null,30,160,90,240,null,40,140,75,240,null,50,120,90,210]
[null,35,180,100,270,null,45,160,90,350,null,60,140,100,240]
["Chou pommé","Rendement (t/ha)","N","P2O5","K2O","Oignon","Rendement (t/ha)","N","P2O5","K2O"]
[null,40,120,70,200,null,15,120,60,190]
[null,45,135,80,225,null,20,130,70,210]
[null,50,150,90,250,null,25,140,80,230]
[null,55,165,100,275,null,30,150,90,250]
[null,60,180,110,300,null,35,160,100,270]
[]
[]
[]
[null,null,null,null,null,null,"Légumes"]
["type de culte","Fourrages tempérés",null,null,null,null,"Aïl","i68:i72","Aïl","Artichaut","Aubergine","Betterave rouge","Carotte","Chou-fleur","Chou pommé","Comcombre","Courgette","Haricot vert","Laitue","Melon","Navet","Oignon","Pastèque","Poireau","Poivron","Pomme de terre","Radis","Tomate"]
[null,"Légumes",null,null,null,null,"Artichaut","j68:j72",4,18,30,40,25,15,40,20,20,6,40,10,25,15,30,20,20,15,15,20,1]
[null,"Fruits",null,null,null,null,"Aubergine","k68:k72",6,20,40,45,30,20,45,30,25,8,45,20,30,20,35,25,30,20,18,30,2]
[null,"Canne à sucre",null,null,null,null,"Betterave rouge","l68:l72",8,22,50,50,35,25,50,40,30,10,50,30,35,25,40,30,40,25,21,40,3]
[null,null,null,null,null,null,"Carotte","m68:m72",10,24,60,55,40,30,55,50,35,12,55,40,40,30,45,35,50,30,24,50,4]
[null,null,null,null,null,null,"Chou-fleur","n68:n72",12,26,70,60,45,35,60,60,40,14,60,50,45,35,50,40,60,35,27,60,5]
[null,null,null,null,null,null,"Chou pommé","o68:o72"]
[null,null,null,null,null,null,"Concombre","p68:p72"]
[null,null,null,null,null,null,"Courgette","q68:q72"]
[null,null,null,null,null,null,"Haricot vert","r68:r72"]
[null,null,null,null,null,null,"Laitue","s68:s72"]
[null,null,null,null,null,null,"Melon","t68:t72"]
[null,null,null,null,null,null,"Navet","u68:u72"]
[null,null,null,null,null,null,"Oignon","v68:v72"]
[null,null,null,null,null,null,"Pastèque","w68:w72"]
[null,null,null,null,null,null,"Poireau","x68:x72"]
[null,null,null,null,null,null,"Poivron","y68:y72"]
[null,null,null,null,null,null,"Pomme de terre","z68:z72"]
[null,null,null,null,null,null,"Radis","aa68:aa72"]
[null,null,null,null,null,null,"Tomate","ab68:ab72"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Fruits"]
[null,null,null,null,null,null,"Agrumes à la plantation",null,"Agrumes à la plantation","Ananas à la plantation","Bananier à la plantation","Fraise à la plantation","Fruit de la passion à la plantation","Papayer à la plantation","Agrumes en production","Bananier en production","Fruit de la passion en production","Papayer en production"]
[null,null,null,null,null,null,"Ananas à la plantation",null,null,null,null,null,null,null,20,20,8,25]
[null,null,null,null,null,null,"Bananier à la plantation",null,null,null,null,null,null,null,30,25,12,30]
[null,null,null,null,null,null,"Fraise à la plantation",null,null,null,null,null,null,null,40,30,null,35]
[null,null,null,null,null,null,"Fruit de la passion à la plantation",null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,"Papayer à la plantation",null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,"Agrumes en production","o93:o95"]
[null,null,null,null,null,null,"Bananier en production","p93:p97"]
[null,null,null,null,null,null,"Fruit de la passion en production","q93:q94"]
[null,null,null,null,null,null,"Papayer en production","r93:r95"]
[]
[]
[null,null,null,null,null,null,"Bananier","Rendement (t/ha)","N","P2O5","K2O"]
[null,null,null,null,null,null,"en production",20,240,32,650]
[null,null,null,null,null,null,null,25,270,36,750]
["Ananas","Rendement (t/ha)","N","P","K",null,null,30,310,40,870]
["à la plantation",null,69,25,99,null,null,35,350,44,970]
[null,null,null,null,null,null,null,40,390,48,1060]
[]
["Fraise","Rendement (t/ha)","N","P2O5","K2O"]
["à la plantation",null,90,30,160,null,"Papayer","Rendement (t/ha)","N","P2O5","K2O"]
[null,null,null,null,null,null,"en production",25,161,43,107]
[null,null,null,null,null,null,null,30,194,52,129]
["Bananier","Rendement (t/ha)","N","P2O5","K2O",null,null,35,225,60,150]
["à la plantation",null,250,100,650]
[]
[null,null,null,null,null,null,"Fruit de la passion","Rendement (t/ha)","N","P2O5","K2O"]
["Papayer","Rendement (t/ha)","N","P2O5","K2O",null,"en production",8,121,67,147]
["à la plantation",null,161,43,107,null,null,12,180,100,220,null,"s"]
[]
[]
["Fruit de la passion","Rendement (t/ha)","N","P2O5","K2O",null,"Agrumes","Rendement (t/ha)","N","P2O5","K2O"]
["à la plantation",null,121,67,147,null,"en production",20,300,70,300]
[null,null,null,null,null,null,null,30,450,105,450]
[null,null,null,null,null,null,null,40,600,140,600]
["Agrumes","Rendement (t/ha)","N","P2O5","K2O"]
["à la plantation",null,60,20,60]

{"sheet":"login","index":1,"n_rows":24,"n_cols":11,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,3,0,8]]}
[null,null,null,"Le logiciel FERTI-RUN est téléchargeable sur le site Internet de la MVAD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Mission de valorisation agricole des déchets (MVAD)",null,null,null,null,null,null,"Pierre-François Chabalier"]
[null,null,null,"Virginie van de Kerchove ",null,null,null,null,null,null,"pierre.chabalier@cirad.fr"]
[null,null,null,"mvad1.suad@reunion.chambagri.fr"]

{"sheet":"interface de saisie","index":2,"n_rows":90,"n_cols":7,"rows_kept":90,"cut":false,"hidden":false,"merged":[[5,3,8,3],[1,0,1,1],[60,0,61,2],[47,0,47,1],[26,1,26,3],[31,1,31,3],[57,0,59,0],[52,0,54,0],[1,3,1,6]]}
[null,"Fertilisation organique et minérale"]
["TECHNICIEN",null,null,"AGRICULTEUR"]
["Nom","",null,"Nom ",""]
["Prénom","",null,"prénom",""]
["Organisme","",null,"Commune sur laquelle est située l'exploitation",""]
[null,null,null,"Parcelle à fertiliser","Lieu-dit",""]
[null,null,null,null,"Référence cadastrale",""]
[null,null,null,null,"Coordonnées GPS","",""]
[null,null,null,null,"Altitude",""]
[]
[]
[]
["Liste de vos choix"]
[0]
["Type de culture","Matière organique (MO)","Superficie de la parcelle (ha)","Couverture des besoins de la culture (%)",null,"Calcul sur base de","Type de sol"]
[null,null,null,null,null,{"$f":"ChoixCal","v":0},"Sol fixateur en phosphore"]
[]
[]
["Besoins de la culture par an"]
[null,"N","P2O5","K2O"]
["Besoin de la culture en éléments nutritifs\n(kilos / ha)"]
["Besoin de la culture en éléments nutritifs\n(kilos / parcelle)"]
[]
[]
[]
["Caractéristiques agronomiques de la matière organique"]
[]
[null,"N","P2O5","K2O"]
["Teneur de la MO en éléments nutritifs\n(kilos / tonne de MO)"]
["Coeff. d'équivalence engrais"]
["Apport en éléments nutritifs  par la MO \n(kilos / tonne de MO)"]
[]
[]
["Quantité de matière organique à épandre sur la parcelle par an"]
[]
["Besoins de la culture couverts par la MO",{"$f":"apport_perct","v":0}]
["Rappel de la MO sélectionnée",{"$f":"besoin_culture","v":0}]
["Quantité de MO satisfaisant les besoins de la culture (tonnes)"]
["Quantité de MO maximale à épandre (tonnes)"]
["Apport maximal par épandage "]
["Nombre d'épandages maximum par an"]
["Quantité de MO à épandre (tonnes)"]
[]
["Volume annuel de MO à épandre \n(m3)",null,null,1]
["Volume disponible"]
["Contenance de votre épandeur\n(m3)",null,null,null,null,{"$f":"(volume*'caract. MO'!H8)/choix_sup","v":{"$error":"#DIV/0!"}}]
["Nombre de rotations par épandage"]
[]
["Fertilisation organique et minérale de la culture"]
[]
[]
[null,null,"N","P2O5","K2O"]
["kg/parcelle","Quantité d'éléments nutritifs apportés par la MO "]
[null,"Complément minéral à apporter "]
[null,"Total fertilisation \norganique + minérale",{"$f":"complet_N+apportMO_N","v":0},{"$f":"complet_P+apportMO_P","v":0},{"$f":"complet_K+apportMO_K","v":0}]
[]
[null,null,"N","P2O5","K2O"]
["kg/ha","Quantité d'éléments nutritifs apportés par la MO ",{"$f":"apportMO_N/choix_sup","v":{"$error":"#DIV/0!"}},{"$f":"apportMO_P/choix_sup","v":{"$error":"#DIV/0!"}},{"$f":"apportMO_K/choix_sup","v":{"$error":"#DIV/0!"}}]
[null,"Complément minéral à apporter ",{"$f":"complet_N/choix_sup","v":{"$error":"#DIV/0!"}},{"$f":"complet_P/choix_sup","v":{"$error":"#DIV/0!"}},{"$f":"complet_K/choix_sup","v":{"$error":"#DIV/0!"}}]
[null,"Total fertilisation \norganique + minérale",{"$f":"totalfertiN/choix_sup","v":{"$error":"#DIV/0!"}},{"$f":"PTotal_fertilisation_P/choix_sup","v":{"$error":"#DIV/0!"}},{"$f":"KTotal_fertilisation_P/choix_sup","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,375]

{"sheet":"caract. MO","index":3,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Teneurs en NPK et CEE des matières organiques"]
[]
["valeurs extraites des fiches du guide de la fertilisation organique et de la mise à jour de février 2007*"]
[]
[]
[]
["Matières organiques","Teneur en Azote total (Nt)","CE-N","Teneur en phosphore total (P2O5)","CE-P2O5","Teneur en potassium total (K2Ot)","CE-K2O","Poids volumique des MO"]
["Boue d’épuration liquide",7.4,0.6,2.9,0.6,0.6,1,1,"*"]
["Boue d’épuration pâteuse",10.3,0.45,4.7,0.6,0.8,1]
["Boue d’épuration solide",24.8,0.45,18.8,0.6,2.1,1]
["Boue d’épuration solide-sèche",45.6,0.45,24.8,0.6,2.7,1]
["Compost de déchets verts",9.1,0.1,4.3,0.5,5.8,1]
["Compost de déchets verts et boue d’épuration",14.4,0.15,9.5,0.5,7.9,1,null,"*"]
["Compost de fumier de bovin sur support cellulosique",7.6,0.15,3,1,7.3,1]
["Compost de fumier de poule pondeuse",13.2,0.4,25,0.65,14.7,1,null,"*"]
["Compost de fumier de poulet de chair",24.7,0.4,17.3,0.65,19,1,null,"*"]
["Compost de fumier de poulet de chair et de lisier de porc",7.7,0.15,13.2,0.65,7.9,1]
["Compost de géranium",9.1999999999999993,0.15,1.8,0.5,8.6,1]
["Compost de lisier de porc et de bagasse",4.3,0.15,5,0.85,2.6,1]
["Ecume de sucrerie",7.4,0.1,9.1,1,1.2,1]
["Fiente de poule pondeuse",30.6,0.6,24.5,0.65,21,1]
["Fumier de bovin",6.2,0.25,3.1,1,7.2,1]
["Fumier de caprin",9.1,0.25,3.1,1,13.9,1]
["Fumier de cheval",5.3,0.23,2.6,1,1.6,1]
["Fumier de lapin",4.8,0.2,2.7,1,3.2,1]
["Fumier de mouton",8.6,0.2,4,1,13.3,1]
["Fumier de poule pondeuse",12.4,0.6,20.399999999999999,0.65,10.8,1]
["Fumier de poulet de chair",22.5,0.6,20.100000000000001,0.65,18.8,1]
["Lisier de bovin",3.3,0.38,1.8,1,3.8,1,1]
["Lisier de lapin",6,0.55000000000000004,4.4000000000000004,1,4.9000000000000004,1]
["Lisier de porc",3.5,0.6,2.2999999999999998,0.85,3.4,1,1]
["Lisier de poule pondeuse",10.199999999999999,0.6,4.2,0.65,6.5,1]
["Vinasse de distillerie",2.6,0.2,0.7,1,16,1,1]
[null,null,"soit valeur unique, soit moyenne",null,"soit valeur unique, soit moyenne"]

{"sheet":"type_matière_organique","index":4,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Interdictions épandage"]
[]
[]
["Matières organiques","canne à sucre","légumes et fruits passion"]
["Fumier de bovin","Fumier de bovin","Fumier de bovin"]
["Fumier de caprin","Fumier de caprin","Fumier de caprin"]
["Fumier de cheval","Fumier de cheval","Fumier de cheval"]
["Fumier de lapin","Fumier de lapin","Fumier de lapin"]
["Fumier de mouton","Fumier de mouton","Fumier de mouton"]
["Fumier de poulet de chair","Fumier de poulet de chair","Fumier de poulet de chair"]
["Fumier de poule pondeuse","Fumier de poule pondeuse","Fumier de poule pondeuse"]
["Fiente de poule pondeuse","Fiente de poule pondeuse","Fiente de poule pondeuse",null,null,null,null,null,null,null,"voir p.227 NFU"]
["Lisier de bovin","Lisier de bovin","Compost de fumier de bovin sur support cellulosique"]
["Lisier de lapin","Lisier de lapin","Compost de fumier de poulet de chair"]
["Lisier de porc","Lisier de porc","Compost de fumier de poule pondeuse"]
["Lisier de poule pondeuse","Lisier de poule pondeuse","Compost de fumier de poulet de chair et de lisier de porc"]
["Compost de fumier de bovin sur support cellulosique","Compost de fumier de bovin sur support cellulosique","Compost de lisier de porc et de bagasse"]
["Compost de fumier de poulet de chair","Compost de fumier de poulet de chair","Compost de Géranium"]
["Compost de fumier de poule pondeuse","Compost de fumier de poule pondeuse","Compost de déchets verts"]
["Compost de fumier de poulet de chair et de lisier de porc","Compost de fumier de poulet de chair et de lisier de porc","Compost de déchets verts et boue d’épuration"]
["Compost de lisier de porc et de bagasse","Compost de lisier de porc et de bagasse","Ecume de sucrerie"]
["Compost de Géranium","Compost de Géranium","Vinasse de distillerie"]
["Compost de déchets verts","Compost de déchets verts"]
["Compost de déchets verts et boue d’épuration","Compost de déchets verts et boue d’épuration"]
["Boue d’épuration liquide","Boue d’épuration liquide"]
["Boue d’épuration pâteuse","Boue d’épuration pâteuse"]
["Boue d’épuration solide-sèche","Boue d’épuration solide-sèche"]
["Boue d’épuration solide","Boue d’épuration solide"]
["Ecume de sucrerie","Ecume de sucrerie"]
["Vinasse de distillerie","Vinasse de distillerie"]

{"sheet":"precaution_epan","index":5,"n_rows":30,"n_cols":25,"rows_kept":30,"cut":false,"hidden":false,"merged":[[25,9,28,10],[25,12,28,13],[0,9,0,10],[1,9,1,10],[0,12,0,19],[1,12,1,13],[1,15,1,16],[1,18,1,19],[0,3,0,4],[0,6,1,7],[4,9,7,10],[4,12,7,13],[0,24,0,25],[1,20,2,22],[1,24,3,25],[3,20,3,22]]}
[null,"apport max. par epandage",null,"prairies tempérées",null,null,"canne et fruits à la plantation (agrumes, papayer, bananier)",null,null,"légumes en production",null,null,"fruits en production",null,null,null,null,null,null,null,"fruits à la plantation",null,null,null,"canne à sucre :"]
[null,null,null,null,null,null,null,null,null,"les 20 de la liste",null,null,"fruit de la passion",null,null,"agrumes",null,null,"papayer, bananier ",null,"Fraise, ananas : pas de boues ni de lisiers car fruits au sol",null,null,null,"1 seul épandage /an car impossibilité de pénétrer dans canne après"]
[1,2,null,4,5,null,7,8,null,10,11,null,13,14,12,16,17,15,19,20]
["Matières organiques",null,null,"nbre epandage par an","limite sur l'annee",null,"nbre epandage par an","limite sur l'annee",null,"nbre epandage par an","limite sur l'annee",null,"nbre epandage par an","limite sur l'annee",null,"nbre epandage par an","limite sur l'annee",null,"nbre epandage par an","limite sur l'annee","Agrumes, papayer, bananier : un seul épandage "]
["Boue d’épuration liquide",30,null,{"$f":"E5/B5","v":2},60,null,1,{"$f":"B5*G5","v":30},null,"pas de boues sur légumes au sol",null,null,"pas de boues sur fruits au sol",null,null,3,{"$f":"B5*P5","v":90},null,{"$f":"T5/B5","v":6},180]
["Boue d’épuration pâteuse",25,null,2,50,null,1,{"$f":"B6*G6","v":25},null,null,null,null,null,null,null,4,{"$f":"B6*P6","v":100},null,4,100]
["Boue d’épuration solide",25,null,2,50,null,1,25,null,null,null,null,null,null,null,2,{"$f":"B7*P7","v":50},null,2,50]
["Boue d’épuration solide-sèche",25,null,2,50,null,1,25,null,null,null,null,null,null,null,2,{"$f":"B8*P8","v":50},null,2,50]
["Compost de déchets verts",25,null,2,50,null,1,25,null,1,50,null,{"$f":"N9/B9","v":2},50,null,{"$f":"Q9/B9","v":2},50,null,2,50]
["Compost de déchets verts et boue d’épuration",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Compost de fumier de bovin sur support cellulosique",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Compost de fumier de poule pondeuse",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Compost de fumier de poulet de chair",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Compost de fumier de poulet de chair et de lisier de porc",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Compost de Géranium",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Compost de lisier de porc et de bagasse",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Ecume de sucrerie",25,null,2,50,null,1,25,null,1,50,null,2,50,null,2,50,null,2,50]
["Fiente de poule pondeuse",10,null,2,20,null,1,10,null,1,20,null,2,20,null,2,20,null,2,20]
["Fumier de bovin",25,null,4,100,null,1,25,null,1,100,null,4,100,null,4,100,null,4,100]
["Fumier de caprin",25,null,4,100,null,1,25,null,1,100,null,4,100,null,4,100,null,4,100]
["Fumier de cheval",25,null,4,100,null,1,25,null,1,100,null,4,100,null,4,100,null,4,100]
["Fumier de lapin",25,null,4,100,null,1,25,null,1,100,null,4,100,null,4,100,null,4,100]
["Fumier de mouton",25,null,4,100,null,1,25,null,1,100,null,4,100,null,4,100,null,4,100]
["Fumier de poule pondeuse",25,null,4,100,null,1,25,null,1,100,null,4,100,null,4,100,null,4,100]
["Fumier de poulet de chair",25,null,4,100,null,1,25,null,1,100,null,4,100,null,4,100,null,4,100]
["Lisier de bovin",60,null,2,120,null,1,60,null,"pas de lisiers sur légumes au sol",null,null,"pas de lisiers sur fruits au sol",null,null,2,{"$f":"B26*P26","v":120},null,2,120]
["Lisier de lapin",60,null,2,120,null,1,60,null,null,null,null,null,null,null,2,{"$f":"B27*P27","v":120},null,2,120]
["Lisier de porc",60,null,2,120,null,1,60,null,null,null,null,null,null,null,2,{"$f":"B28*P28","v":120},null,2,120]
["Lisier de poule pondeuse",60,null,2,120,null,1,60,null,null,null,null,null,null,null,2,{"$f":"B29*P29","v":120},null,2,120]
["Vinasse de distillerie",25,null,2,50,null,1,25,null,1,50,null,{"$f":"N30/B30","v":2},50,null,{"$f":"Q30/B30","v":2},50,null,2,50]

{"sheet":"canne","index":6,"n_rows":102,"n_cols":9,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["canne à sucre",null,"Scénarios possibles de récolte"]
[]
["note :"]
[]
[{"$f":"IF(B$21=\"A\",\"X\",\"\")","v":"X"},"A","Coupe et chargement manuels"]
[{"$f":"IF(B$21=\"B\",\"X\",\"\")","v":""},"B","Coupe manuelle et chargement mécanique"]
[{"$f":"IF(B$21=\"B'\",\"X\",\"\")","v":""},"B'","Coupe manuelle et chargement mécanique avec paille"]
[{"$f":"IF(B$21=\"C\",\"X\",\"\")","v":""},"C","Coupe mécanique en vert"]
[{"$f":"IF(B$21=\"C'\",\"X\",\"\")","v":""},"C'","Coupe mécanique et exportation des pailles pour l'élevage"]
[{"$f":"IF(B$21=\"D\",\"X\",\"\")","v":""},"D","Coupe de canne brûlée (manuelle ou mécanique)"]
[{"$f":"IF(B$21=\"D'\",\"X\",\"\")","v":""},"D'","Coupe de canne brûlée et exportation des pailles pour l'élevage"]
[]
[null,null,"Types de sol possibles (pour la fixation de P)"]
[null,null,null,null,null,null,null,"coef multiplicateur"]
[null,1,"Sol peu fixateur (sol ferrallitique, sols bruns, autres)",null,null,null,null,null,"coef  1,2"]
["X",2,"Sol très fixateur (andosol)",null,null,null,null,null,"coef 2"]
[]
[null,null,null,null,"Exportation minérale"]
["Mode de conduite",null,null,null,"ne pas modifier"]
["cases à remplir",null,null,null,"Tige Usinable",null,90,"%"]
["Type de Récolte :","A",null,null,"Feuilles Mortes",null,{"$f":"IF(B$21=\"A\",0,IF(OR(B$21=\"B\",B$21=\"C\"),10,IF(B$21=\"B'\",30,IF(B$21=\"C'\",40,IF(OR(B$21=\"D\",B$21=\"D'\"),100)))))","v":0},"%"]
["Rendement (t/ha) :","100",null,null,"Feuilles Vertes",null,{"$f":"IF(OR(B$21=\"A\",B$21=\"D\"),5,IF(B$21=\"B\",10,IF(B$21=\"B'\",30,IF(B$21=\"C\",20,IF(B$21=\"C'\",60,IF(B$21=\"D'\",70))))))","v":5},"%"]
["Type de Sol :",1,null,null,"Choux",null,{"$f":"IF(OR(B$21=\"A\",B$21=\"D\"),5,IF(B$21=\"B\",10,IF(B$21=\"B'\",40,IF(B$21=\"C\",20,IF(B$21=\"C'\",80,IF(B$21=\"D'\",70))))))","v":5},"%"]
[null,null,null,null,"Combution N",null,{"$f":"IF(OR(B21=\"D\",B21=\"D'\"),50,0)","v":0},"%"]
[]
["tableau 1 : Composition de la canne en matière sèche et teneurs en éléments"]
[null,"ne pas changer sans besoin"]
[null,null,"complément = biomasse résiduelle au champ"]
[null,"Choux","Proportion","N","P2O5","K2O","CaO","MgO"]
["Tige usinable",0,0.55000000000000004,2.3E-3,2.5000000000000001E-3,7.4999999999999997E-3,1.4E-3,1E-3]
["Tige non usinable",1,0.02,2.5000000000000001E-3,2.7000000000000001E-3,8.9999999999999993E-3,1.4E-3,1.1999999999999999E-3]
["Feuilles mortes",0,0.16,2.2000000000000001E-3,2.2000000000000001E-3,6.0000000000000001E-3,5.5999999999999999E-3,2.3999999999999998E-3]
["Limbes verts",0.7,0.06,1.0999999999999999E-2,4.4999999999999997E-3,1.7999999999999999E-2,5.5999999999999999E-3,2E-3]
["Gaines vertes",0.7,7.0000000000000007E-2,4.0000000000000001E-3,3.3E-3,2.3E-2,2.5000000000000001E-3,1.6999999999999999E-3]
["Fouets",1,0.02,7.0000000000000001E-3,5.5999999999999999E-3,2.1000000000000001E-2,1.6999999999999999E-3,1.1000000000000001E-3]
["Choux",null,{"$f":"($B30*C30)+($B31*C31)+($B32*C32)+($B33*C33)+($B34*C34)+($B35*C35)","v":0.13100000000000001},{"$f":"($B30*$C30*D30+$B31*$C31*D31+$B32*$C32*D32+$B33*$C33*D33+$B34*$C34*D34+$B35*$C35*D35)/($B30*$C30+$B31*$C31+$B32*$C32+$B33*$C33+$B34*$C34+$B35*$C35)","v":6.4732824427480903E-3},{"$f":"($B30*$C30*E30+$B31*$C31*E31+$B32*$C32*E32+$B33*$C33*E33+$B34*$C34*E34+$B35*$C35*E35)/($B30*$C30+$B31*$C31+$B32*$C32+$B33*$C33+$B34*$C34+$B35*$C35)","v":3.9442748091603049E-3},{"$f":"($B30*$C30*F30+$B31*$C31*F31+$B32*$C32*F32+$B33*$C33*F33+$B34*$C34*F34+$B35*$C35*F35)/($B30*$C30+$B31*$C31+$B32*$C32+$B33*$C33+$B34*$C34+$B35*$C35)","v":1.8954198473282443E-2},{"$f":"($B30*$C30*G30+$B31*$C31*G31+$B32*$C32*G32+$B33*$C33*G33+$B34*$C34*G34+$B35*$C35*G35)/($B30*$C30+$B31*$C31+$B32*$C32+$B33*$C33+$B34*$C34+$B35*$C35)","v":3.2038167938931291E-3},{"$f":"($B30*$C30*H30+$B31*$C31*H31+$B32*$C32*H32+$B33*$C33*H33+$B34*$C34*H34+$B35*$C35*H35)/($B30*$C30+$B31*$C31+$B32*$C32+$B33*$C33+$B34*$C34+$B35*$C35)","v":1.6282442748091601E-3}]
[]
["tableau 2 : Quantité de matière sèche produite (t/ha)"]
[]
["Rendement",80,100,120,150]
["Total plante en MS",45,52,63,77]
["Tige usinable",{"$f":"B$41*$C30","v":24.750000000000004},{"$f":"C$41*$C30","v":28.6},{"$f":"D$41*$C30","v":34.650000000000006},{"$f":"E$41*$C30","v":42.35}]
["Feuilles mortes",{"$f":"B$41*$C32","v":7.2},{"$f":"C$41*$C32","v":8.32},{"$f":"D$41*$C32","v":10.08},{"$f":"E$41*$C32","v":12.32}]
["Feuilles vertes",{"$f":"B$41*($C33+$C34+$C35)","v":6.75},{"$f":"C$41*($C33+$C34+$C35)","v":7.8},{"$f":"D$41*($C33+$C34+$C35)","v":9.4499999999999993},{"$f":"E$41*($C33+$C34+$C35)","v":11.549999999999999}]
["Choux",{"$f":"B$41*$C36","v":5.8950000000000005},{"$f":"C$41*$C36","v":6.8120000000000003},{"$f":"D$41*$C36","v":8.2530000000000001},{"$f":"E$41*$C36","v":10.087}]
[]
["tableau 3 : Mobilisations totales des éléments (kg/ha)"]
[]
["Rendement",80,100,120,150,"Coeff."]
["N",{"$f":"(($D$30*B$42)+($D$32*B$43)+((((1-$B$33)*$C$33*$D$33)+((1-$B$34)*$C$34*$D$34)+((1-$B$35)*$C$35*$D$35))/($C$33+$C$34+$C$35)*B$44)+($D$36*B$45))*1000","v":123.61500000000001},{"$f":"(($D$30*C$42)+($D$32*C$43)+((((1-$B$33)*$C$33*$D$33)+((1-$B$34)*$C$34*$D$34)+((1-$B$35)*$C$35*$D$35))/($C$33+$C$34+$C$35)*C$44)+($D$36*C$45))*1000","v":142.84399999999999},{"$f":"(($D$30*D$42)+($D$32*D$43)+((((1-$B$33)*$C$33*$D$33)+((1-$B$34)*$C$34*$D$34)+((1-$B$35)*$C$35*$D$35))/($C$33+$C$34+$C$35)*D$44)+($D$36*D$45))*1000","v":173.06100000000001},{"$f":"(($D$30*E$42)+($D$32*E$43)+((((1-$B$33)*$C$33*$D$33)+((1-$B$34)*$C$34*$D$34)+((1-$B$35)*$C$35*$D$35))/($C$33+$C$34+$C$35)*E$44)+($D$36*E$45))*1000","v":211.51900000000001},{"$f":"((B50/B$49)+(C50/C$49)+(D50/D$49)+(E50/E$49))/4","v":1.4564822916666667}]
["P2O5",{"$f":"(($E$30*B$42)+($E$32*B$43)+((((1-$B$33)*$C$33*$E$33)+((1-$B$34)*$C$34*$E$34)+((1-$B$35)*$C$35*$E$35))/($C$33+$C$34+$C$35)*B$44)+($E$36*B$45))*1000","v":107.73},{"$f":"(($E$30*C$42)+($E$32*C$43)+((((1-$B$33)*$C$33*$E$33)+((1-$B$34)*$C$34*$E$34)+((1-$B$35)*$C$35*$E$35))/($C$33+$C$34+$C$35)*C$44)+($E$36*C$45))*1000","v":124.48800000000001},{"$f":"(($E$30*D$42)+($E$32*D$43)+((((1-$B$33)*$C$33*$E$33)+((1-$B$34)*$C$34*$E$34)+((1-$B$35)*$C$35*$E$35))/($C$33+$C$34+$C$35)*D$44)+($E$36*D$45))*1000","v":150.822},{"$f":"(($E$30*E$42)+($E$32*E$43)+((((1-$B$33)*$C$33*$E$33)+((1-$B$34)*$C$34*$E$34)+((1-$B$35)*$C$35*$E$35))/($C$33+$C$34+$C$35)*E$44)+($E$36*E$45))*1000","v":184.33799999999999},{"$f":"((B51/B$49)+(C51/C$49)+(D51/D$49)+(E51/E$49))/4","v":1.2693187500000001}]
["K2O",{"$f":"(($F$30*B$42)+($F$32*B$43)+((((1-$B$33)*$C$33*$F$33)+((1-$B$34)*$C$34*$F$34)+((1-$B$35)*$C$35*$F$35))/($C$33+$C$34+$C$35)*B$44)+($F$36*B$45))*1000","v":376.875},{"$f":"(($F$30*C$42)+($F$32*C$43)+((((1-$B$33)*$C$33*$F$33)+((1-$B$34)*$C$34*$F$34)+((1-$B$35)*$C$35*$F$35))/($C$33+$C$34+$C$35)*C$44)+($F$36*C$45))*1000","v":435.5},{"$f":"(($F$30*D$42)+($F$32*D$43)+((((1-$B$33)*$C$33*$F$33)+((1-$B$34)*$C$34*$F$34)+((1-$B$35)*$C$35*$F$35))/($C$33+$C$34+$C$35)*D$44)+($F$36*D$45))*1000","v":527.625},{"$f":"(($F$30*E$42)+($F$32*E$43)+((((1-$B$33)*$C$33*$F$33)+((1-$B$34)*$C$34*$F$34)+((1-$B$35)*$C$35*$F$35))/($C$33+$C$34+$C$35)*E$44)+($F$36*E$45))*1000","v":644.875},{"$f":"((B52/B$49)+(C52/C$49)+(D52/D$49)+(E52/E$49))/4","v":4.4404947916666666}]
["CaO",{"$f":"(($G$30*B$42)+($G$32*B$43)+((((1-$B$33)*$C$33*$G$33)+((1-$B$34)*$C$34*$G$34)+((1-$B$35)*$C$35*$G$35))/($C$33+$C$34+$C$35)*B$44)+($G$36*B$45))*1000","v":100.75500000000001},{"$f":"(($G$30*C$42)+($G$32*C$43)+((((1-$B$33)*$C$33*$G$33)+((1-$B$34)*$C$34*$G$34)+((1-$B$35)*$C$35*$G$35))/($C$33+$C$34+$C$35)*C$44)+($G$36*C$45))*1000","v":116.428},{"$f":"(($G$30*D$42)+($G$32*D$43)+((((1-$B$33)*$C$33*$G$33)+((1-$B$34)*$C$34*$G$34)+((1-$B$35)*$C$35*$G$35))/($C$33+$C$34+$C$35)*D$44)+($G$36*D$45))*1000","v":141.05699999999999},{"$f":"(($G$30*E$42)+($G$32*E$43)+((((1-$B$33)*$C$33*$G$33)+((1-$B$34)*$C$34*$G$34)+((1-$B$35)*$C$35*$G$35))/($C$33+$C$34+$C$35)*E$44)+($G$36*E$45))*1000","v":172.40300000000002},{"$f":"((B53/B$49)+(C53/C$49)+(D53/D$49)+(E53/E$49))/4","v":1.1871364583333333}]
["MgO",{"$f":"(($H$30*B$42)+($H$32*B$43)+((((1-$B$33)*$C$33*$H$33)+((1-$B$34)*$C$34*$H$34)+((1-$B$35)*$C$35*$H$35))/($C$33+$C$34+$C$35)*B$44)+($H$36*B$45))*1000","v":54.855000000000004},{"$f":"(($H$30*C$42)+($H$32*C$43)+((((1-$B$33)*$C$33*$H$33)+((1-$B$34)*$C$34*$H$34)+((1-$B$35)*$C$35*$H$35))/($C$33+$C$34+$C$35)*C$44)+($H$36*C$45))*1000","v":63.387999999999998},{"$f":"(($H$30*D$42)+($H$32*D$43)+((((1-$B$33)*$C$33*$H$33)+((1-$B$34)*$C$34*$H$34)+((1-$B$35)*$C$35*$H$35))/($C$33+$C$34+$C$35)*D$44)+($H$36*D$45))*1000","v":76.796999999999997},{"$f":"(($H$30*E$42)+($H$32*E$43)+((((1-$B$33)*$C$33*$H$33)+((1-$B$34)*$C$34*$H$34)+((1-$B$35)*$C$35*$H$35))/($C$33+$C$34+$C$35)*E$44)+($H$36*E$45))*1000","v":93.863},{"$f":"((B54/B$49)+(C54/C$49)+(D54/D$49)+(E54/E$49))/4","v":0.64632395833333334}]
[]
[]
[]
[]
[null,null,"RESULTATS DE LA SIMULATION"]
["scénario  de récolte choisi  :",null,null,null,{"$f":"B21","v":"A"}]
[]
["tableau 4 : Exportation des éléments en fonction du rendement (kg/ha)"]
[]
["Rendement",80,100,120,150,"Coeff."]
["N",{"$f":"1000*((0.01*$G$20*$D$30*B$42+0.01*$G$21*$D$32*B$43)+((0.01*$G$22+(100-$G$22)*0.01*0.01*$G$24)*(((1-$B$33)*$C$33*$D$33+(1-$B$34)*$C$34*$D$34+(1-$B$35)*$C$35*$D$35)/($C$33+$C$34+$C$35))*B$44)+((0.01*$G$23+(100-$G$23)*0.01*0.01*$G$24)*$D$36*B$45))","v":53.77500000000002},{"$f":"1000*((0.01*$G$20*$D$30*C$42+0.01*$G$21*$D$32*C$43)+((0.01*$G$22+(100-$G$22)*0.01*0.01*$G$24)*(((1-$B$33)*$C$33*$D$33+(1-$B$34)*$C$34*$D$34+(1-$B$35)*$C$35*$D$35)/($C$33+$C$34+$C$35))*C$44)+((0.01*$G$23+(100-$G$23)*0.01*0.01*$G$24)*$D$36*C$45))","v":62.140000000000015},{"$f":"1000*((0.01*$G$20*$D$30*D$42+0.01*$G$21*$D$32*D$43)+((0.01*$G$22+(100-$G$22)*0.01*0.01*$G$24)*(((1-$B$33)*$C$33*$D$33+(1-$B$34)*$C$34*$D$34+(1-$B$35)*$C$35*$D$35)/($C$33+$C$34+$C$35))*D$44)+((0.01*$G$23+(100-$G$23)*0.01*0.01*$G$24)*$D$36*D$45))","v":75.285000000000025},{"$f":"1000*((0.01*$G$20*$D$30*E$42+0.01*$G$21*$D$32*E$43)+((0.01*$G$22+(100-$G$22)*0.01*0.01*$G$24)*(((1-$B$33)*$C$33*$D$33+(1-$B$34)*$C$34*$D$34+(1-$B$35)*$C$35*$D$35)/($C$33+$C$34+$C$35))*E$44)+((0.01*$G$23+(100-$G$23)*0.01*0.01*$G$24)*$D$36*E$45))","v":92.015000000000001},{"$f":"((B65/B$49)+(C65/C$49)+(D65/D$49)+(E65/E$49))/4","v":0.63359895833333357},null,"  "]
["P2O5",{"$f":"1000*((0.01*$G$20*$E$30*B$42+0.01*$G$21*$E$32*B$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$E$33+(1-$B$34)*$C$34*$E$34+(1-$B$35)*$C$35*$E$35)/($C$33+$C$34+$C$35))*B$44)+((0.01*$G$23)*$E$36*B$45))","v":57.188250000000018},{"$f":"1000*((0.01*$G$20*$E$30*C$42+0.01*$G$21*$E$32*C$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$E$33+(1-$B$34)*$C$34*$E$34+(1-$B$35)*$C$35*$E$35)/($C$33+$C$34+$C$35))*C$44)+((0.01*$G$23)*$E$36*C$45))","v":66.084199999999996},{"$f":"1000*((0.01*$G$20*$E$30*D$42+0.01*$G$21*$E$32*D$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$E$33+(1-$B$34)*$C$34*$E$34+(1-$B$35)*$C$35*$E$35)/($C$33+$C$34+$C$35))*D$44)+((0.01*$G$23)*$E$36*D$45))","v":80.063550000000021},{"$f":"1000*((0.01*$G$20*$E$30*E$42+0.01*$G$21*$E$32*E$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$E$33+(1-$B$34)*$C$34*$E$34+(1-$B$35)*$C$35*$E$35)/($C$33+$C$34+$C$35))*E$44)+((0.01*$G$23)*$E$36*E$45))","v":97.855450000000005},{"$f":"((B66/B$49)+(C66/C$49)+(D66/D$49)+(E66/E$49))/4","v":0.67381526041666673}]
["K2O",{"$f":"1000*((0.01*$G$20*$F$30*B$42+0.01*$G$21*$F$32*B$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$F$33+(1-$B$34)*$C$34*$F$34+(1-$B$35)*$C$35*$F$35)/($C$33+$C$34+$C$35))*B$44)+((0.01*$G$23)*$F$36*B$45))","v":174.46500000000003},{"$f":"1000*((0.01*$G$20*$F$30*C$42+0.01*$G$21*$F$32*C$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$F$33+(1-$B$34)*$C$34*$F$34+(1-$B$35)*$C$35*$F$35)/($C$33+$C$34+$C$35))*C$44)+((0.01*$G$23)*$F$36*C$45))","v":201.60400000000001},{"$f":"1000*((0.01*$G$20*$F$30*D$42+0.01*$G$21*$F$32*D$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$F$33+(1-$B$34)*$C$34*$F$34+(1-$B$35)*$C$35*$F$35)/($C$33+$C$34+$C$35))*D$44)+((0.01*$G$23)*$F$36*D$45))","v":244.25100000000003},{"$f":"1000*((0.01*$G$20*$F$30*E$42+0.01*$G$21*$F$32*E$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$F$33+(1-$B$34)*$C$34*$F$34+(1-$B$35)*$C$35*$F$35)/($C$33+$C$34+$C$35))*E$44)+((0.01*$G$23)*$F$36*E$45))","v":298.52900000000005},{"$f":"((B67/B$49)+(C67/C$49)+(D67/D$49)+(E67/E$49))/4","v":2.0556177083333336}]
["CaO",{"$f":"1000*((0.01*$G$20*$G$30*B$42+0.01*$G$21*$G$32*B$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$G$33+(1-$B$34)*$C$34*$G$34+(1-$B$35)*$C$35*$G$35)/($C$33+$C$34+$C$35))*B$44)+((0.01*$G$23)*$G$36*B$45))","v":32.474250000000012},{"$f":"1000*((0.01*$G$20*$G$30*C$42+0.01*$G$21*$G$32*C$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$G$33+(1-$B$34)*$C$34*$G$34+(1-$B$35)*$C$35*$G$35)/($C$33+$C$34+$C$35))*C$44)+((0.01*$G$23)*$G$36*C$45))","v":37.525800000000004},{"$f":"1000*((0.01*$G$20*$G$30*D$42+0.01*$G$21*$G$32*D$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$G$33+(1-$B$34)*$C$34*$G$34+(1-$B$35)*$C$35*$G$35)/($C$33+$C$34+$C$35))*D$44)+((0.01*$G$23)*$G$36*D$45))","v":45.463950000000011},{"$f":"1000*((0.01*$G$20*$G$30*E$42+0.01*$G$21*$G$32*E$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$G$33+(1-$B$34)*$C$34*$G$34+(1-$B$35)*$C$35*$G$35)/($C$33+$C$34+$C$35))*E$44)+((0.01*$G$23)*$G$36*E$45))","v":55.567050000000009},{"$f":"((B68/B$49)+(C68/C$49)+(D68/D$49)+(E68/E$49))/4","v":0.38262484375000005}]
["MgO",{"$f":"1000*((0.01*$G$20*$H$30*B$42+0.01*$G$21*$H$32*B$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$H$33+(1-$B$34)*$C$34*$H$34+(1-$B$35)*$C$35*$H$35)/($C$33+$C$34+$C$35))*B$44)+((0.01*$G$23)*$H$36*B$45))","v":22.916250000000005},{"$f":"1000*((0.01*$G$20*$H$30*C$42+0.01*$G$21*$H$32*C$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$H$33+(1-$B$34)*$C$34*$H$34+(1-$B$35)*$C$35*$H$35)/($C$33+$C$34+$C$35))*C$44)+((0.01*$G$23)*$H$36*C$45))","v":26.481000000000002},{"$f":"1000*((0.01*$G$20*$H$30*D$42+0.01*$G$21*$H$32*D$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$H$33+(1-$B$34)*$C$34*$H$34+(1-$B$35)*$C$35*$H$35)/($C$33+$C$34+$C$35))*D$44)+((0.01*$G$23)*$H$36*D$45))","v":32.082750000000004},{"$f":"1000*((0.01*$G$20*$H$30*E$42+0.01*$G$21*$H$32*E$43)+((0.01*$G$22)*(((1-$B$33)*$C$33*$H$33+(1-$B$34)*$C$34*$H$34+(1-$B$35)*$C$35*$H$35)/($C$33+$C$34+$C$35))*E$44)+((0.01*$G$23)*$H$36*E$45))","v":39.212250000000004},{"$f":"((B69/B$49)+(C69/C$49)+(D69/D$49)+(E69/E$49))/4","v":0.27000859375000003}]
[]
[]
["rendement choisi :",null,null,null,{"$f":"B22","v":"100"}]
[]
["tableau 5 : Exportations des éléments",null,null,null,"Composition du lisier en éléments"]
[]
["N",{"$f":"B$22*F65","v":63.359895833333354},"kg/ha",null,"N",4,"kg/m3"]
["P2O5",{"$f":"B$22*F66","v":67.381526041666675},"kg/ha",null,"P2O5",3.5,"kg/m3"]
["K2O",{"$f":"B$22*F67","v":205.56177083333336},"kg/ha",null,"K2O",4,"kg/m3"]
["CaO",{"$f":"B$22*F68","v":38.262484375000007},"kg/ha",null,"CaO",1]
["MgO",{"$f":"B$22*F69","v":27.000859375000001},"kg/ha",null,"MgO",1]
[null,null,null,null,"entrer les valeurs"]
["tableau 6 : Besoins en éléments fertilisants",null,null,null,"(fonction des sols 1 ou 2 )"]
[]
["N",{"$f":"B76*2","v":126.71979166666671},"kg/ha",null,"type de sol choisi = ",null,null,{"$f":"B23","v":1}]
["P2O5",{"$f":"IF(B$23=1,B$77*1.2,B$77*2)","v":80.857831250000004},"kg/ha"]
["K2O",{"$f":"B78","v":205.56177083333336},"kg/ha"]
["CaO",{"$f":"B$79*1.2","v":45.914981250000004},"kg/ha"]
["MgO",{"$f":"B$80*1.2","v":32.401031250000003},"kg/ha"]
[]
["tableau 7 : 1 ére hypothèse optimiste   Apport théorique de lisier pour apporter tout l'azote"]
[null,"avec une efficacité de N de 100 %"]
["Dose de lisier théorique (base N)",null,null,{"$f":"B84/F76","v":31.679947916666677},"m3"]
["Apport de P2O5 par le lisier",null,null,{"$f":"D92*F77","v":110.87981770833338},"kg/ha","apport de N     = ",null,{"$f":"B84","v":126.71979166666671}]
["Apport de K2O par le lisier",null,null,{"$f":"D92*F78","v":126.71979166666671},"kg/ha","avec une efficacité de 100 % "]
["Apport de complément de K2O engrais",null,null,{"$f":"IF(B86-D94>=0,B86-D94,0)","v":78.841979166666647},"kg/ha"]
[]
["tableau 8 : 2 ième hypothèse réaliste d'apport optimisé de lisier préconisé pour tout N"]
[null,"avec une efficacité de N de 50 %"]
["Dose de lisier optimisée (base N)",null,null,{"$f":"2*B84/F76","v":63.359895833333354},"m3"]
["Apport de P2O5 par le lisier",null,null,{"$f":"D99*F77","v":221.75963541666675},"kg/ha","apport de N    = ",null,{"$f":"H93*2","v":253.43958333333342}]
["Apport de K2O par le lisier",null,null,{"$f":"D99*F78","v":253.43958333333342},"kg/ha","avec une efficacité de 50 % "]
["Apport de complément de K2O engrais",null,null,{"$f":"IF(B86-D101>=0,B86-D101,0)","v":0},"kg/ha","soit = ",{"$f":"H93","v":126.71979166666671},"N"]

{"sheet":"précautions ép.","index":7,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,1,23,1],[4,1,10,1],[12,2,15,2],[12,3,15,3]]}
["Précautions épandage"]
[]
[]
["Matières organiques"]
["Fumier de bovin"]
["Fumier de caprin"]
["Fumier de cheval"]
["Fumier de lapin"]
["Fumier de mouton"]
["Fumier de poulet de chair"]
["Fumier de poule pondeuse"]
["Fiente de poule pondeuse"]
["Lisier de bovin"]
["Lisier de lapin"]
["Lisier de porc"]
["Lisier de poule pondeuse"]
["Compost de fumier de bovin sur support cellulosique"]
["Compost de fumier de poulet de chair"]
["Compost de fumier de poule pondeuse"]
["Compost de fumier de poulet de chair et de lisier de porc"]
["Compost de lisier de porc et de bagasse"]
["Compost de Géranium"]
["Compost de déchets verts"]
["Compost de déchets verts et boue d’épuration"]
["Boue d’épuration liquide"]
["Boue d’épuration pâteuse"]
["Boue d’épuration solide-sèche"]
["Boue d’épuration solide"]
["Ecume de sucrerie"]
["Vinasse de distillerie"]