{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Menu","Calculatrice","Tableaux","Fiche technique","tarifs2024"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"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":"Menu","index":0,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Ceci est une calculatrice d'aide aux décisions d'affaire à la ferme qui comporte 4 feuilles de travail. Certains champs doivent être remplis par l'utilisateur. Elle peut avoir 24 colonnes de largeur et 55 rangées."]
["Menu - Calculateur des tarifs des travaux agricoles à forfait"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Le tableur Excel Calculateur des tarifs des travaux agricoles à forfait vous permet de calculer les coûts qu’il faut comptabiliser pour les travaux agricoles à forfait. Il comprend des tableaux permettant de comptabiliser les coûts relatifs au matériel qui sont requis dans le calcul ainsi qu’une fiche technique contenant les résultats de l’enquête sur les tarifs perçus en 2024 pour les travaux agricoles à forfait en Ontario et un guide de rédaction de contrat de travail agricole à forfait.\n\nLe tableur Excel Calculateur des tarifs de location d'équipement à court terme, que vous trouverez sous l’onglet « Calculatrice », vous permet de calculer les coûts qu’il faut comptabiliser pour la location d’équipement à court terme."]
["Plusieurs cellules comportent un triangle rouge dans leur coin supérieur droit. En plaçant le curseur de votre souris sur ce triangle, vous affichez une courte description des données à saisir dans la cellule en question."]
[]
["Conçu par John Molenhuis"]
["chargé de programme, analyse des activités commerciales et des coûts de production"]
["MAAAO, Brighton"]
["Courriel: john.molenhuis@ontario.ca"]
["Révisé le june 2025"]
["fin de la feuille de calcul"]

{"sheet":"Calculatrice","index":1,"n_rows":109,"n_cols":44,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Calculateur des tarifs des travaux agricoles à forfait "]
[null,"Les nombres et le texte en bleu dans les cellules dont l’arrière-plan est jaune peuvent être modifiés pour chaque producteur."]
[null,"PARAMÈTRES GÉNÉRAUX"]
[null,"Taux d'intérêt***",0.05,"Coût du carburant/litre",1.35]
[null,"Tarif assurance et remisage (% du prix d'achat)",0.01,"Consommation de carburant - litres/CV-h du moteur",0.192,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tracteurs 2RM","2WD tractors",null,null,"2WD tractors"]
[null,null,null,"Rémunération de conducteur (entrepreneur ou salarié)",27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tracteurs avec assistance roues avant","FWA tractors",null,null,"FWA tractors"]
[null,null,null,"Allocation de travail pour le déplacement des machines et temps morts",0.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tracteurs 4RM","4WD tractors",null,null,"4WD tractors"]
[null,"UNITÉ MOTRICE (TRACTEUR OU MACHINE AUTOMOTRICE)",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,"Tracteurs à chenilles","Self Propelled combines",null,null,"Self Propelled combines"]
[null,"Puissance nominale du moteur en CV",375,"Moissonneuses-batteuses automotrices",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuses-batteuses automotrices","Self propelled high clearance sprayer",null,null,"Self propelled high clearance sprayer"]
[null,"Vie utile (années)",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,3,FALSE),0)","v":12},"Prix d'achat",740000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andainage automotrices","Self propelled forage harvesters",null,null,"Self propelled forage harvesters"]
[null,"Acres par année",{"$f":"C15*E12","v":2550},"Heures par année",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,2,FALSE),0)","v":250},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Récolteuses-hacheuses automotrices","Depreciation"]
[null,null,null,"Consommation moyenne de carburant (L/h)",{"$f":"C10*E6","v":72},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Récolteuses-hacheuses automotrices - Têtes","Trade in value"]
[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,"Faucheuse-conditionneuse automotrices","Repairs",{"$f":"VLOOKUP(D10,DeprRep,4)","v":{"$error":"#N/A"}}]
[null,"Taux de travail: acres/heure (voir tableau 5)",{"$f":"C16*C17*(C18*100)/825","v":10.199999999999999},"Taux d’amortissement annuel (% du prix d’achat) Tableau 3",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,4,FALSE),0)","v":5.6000000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transporteur automoteur de petites balles carrées"]
[null,"Vitesse moyenne (miles par heure)",3.3,"Pourcentage à allouer pour les réparations annuelles (% du prix d’achat) Tableau 3",{"$f":"IF(D10<>\"\",VLOOKUP(D10,DeprRep,5,FALSE),0)","v":2.63},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulvérisateurs enjambeurs automoteurs",null,{"$f":"VLOOKUP(D10,Tableaux!#REF!,5)","v":{"$error":"#REF!"}}]
[null,"Largeur du matériel (pieds)",30]
[null,"Efficacité du champ (%)",0.85,"Valeur de reprise**",{"$f":"IF(E15=0,0,E11-(E11*E15/100*C11))","v":242719.99999999988}]
[]
[null,"Coûts fixes annuels",null,null,"Totaux annuel $","$/heure","$/acre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charrue à 4 socs 18 pouces","Têtes à rigide"]
[null,"Recouvrement des investissements*",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,"Charrue à 6 socs 18 pouces","Têtes à ramasseur"]
[null,"prix d’achat – valeur de reprise",null,{"$f":"E11-E18","v":497280.00000000012},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charrue à 8 socs 18 pouces","Têtes à flexible"]
[null,"facteur lié au recouvrement des investissements Tableau 4","x",{"$f":"IFERROR((C5*(1+C5)^C11)/((1+C5)^C11-1),0)","v":0.11282541002081541},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cultivateur de 24 pieds","Têtes à tapis"]
[null,null,null,{"$f":"D22*D23","v":56105.8198951511},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cultivateur de 31 pieds","Têtes à maïs"]
[null,"valeur de reprise x taux d’intérêt**","+",{"$f":"E18*C5","v":12135.999999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cultivateur de 44 pieds","Andainage automotrices"]
[null,"Recouvrement des investissements*",null,null,{"$f":"D24+D25","v":68241.8198951511},{"$f":"IFERROR(E26/$E$12,0)","v":272.96727958060438},{"$f":"IFERROR(F26/$C$15,0)","v":26.76149799809847},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charrue chisel de 16 pieds","Remorques à grain"]
[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,"Charrue chisel de 21 pieds","Tarières - (puissance)"]
[null,"Assurance et remisage",null,{"$f":"\"purchase price x \"&$C$6*100&\" %\"","v":"purchase price x 1 %"},{"$f":"E11*C6","v":7400},{"$f":"IFERROR(E28/$E$12,0)","v":29.6},{"$f":"IFERROR(F28/$C$15,0)","v":2.9019607843137258},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulvériseur tandem de 24 pieds","Tarières - (prise de force)"]
[null,"Coûts fixes totaux",null,null,{"$f":"SUM(E26:E28)","v":75641.8198951511},302.56727958060441,29.663458782412199,"(A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulvériseur tandem de 30 pieds","Aspirateur à grains"]
[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,"Pulvériseur déporté de 10 pieds","Faucheuse-conditionneuse (faucille) traîné"]
[null,"Coûts d’utilisation annuels",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,"Pulvériseur déporté de 16 pieds","Faucheuse-conditionneuse (disque) traîné"]
[null,"Carburant et lubrifiants (Tableau 5)",null,"(litres/hour x hours/year x fuel cost/litre)",{"$f":"E13*E12*E5","v":24300},{"$f":"IFERROR(E32/$E$12,0)","v":97.2},{"$f":"IFERROR(F32/$C$15,0)","v":9.529411764705884},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machine de labour vertical de 21 pieds","Râteau à foin (roue)"]
[null,"Réparations",null,"annual repair rate x purchase price",{"$f":"E11*E16/100","v":19462},77.847999999999999,7.6321568627450986,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machine de labour vertical de 30 pieds","Presses à balles rondes"]
[null,"Coûts d’utilisation totaux",null,null,{"$f":"SUM(E32:E33)","v":43762},175.048,17.161568627450983,"(B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machine de labour vertical de 43 pieds","Presses à grosses balles carrées"]
[null,"Totaux",null,null,{"$f":"SUM(E34,E29)","v":119403.8198951511},477.61527958060441,46.825027409863182,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Machine de labour en bandes à 12 rangs","Presses à petites balles carrées"]
[null,"+ MATÉRIEL 1 (INSTRUMENT ARATOIRE, MACHINE MUE PAR",null,"Têtes à maïs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir en ligne à 6 rangs de 30 pouces","Transporteur  de balles rondes - traîné"]
[null," PRISE DE FORCE, AUTRE)",null,"Moissonneuse-batteuse à maïs, 12 becs cueilleurs–30 po",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir en ligne à 12 rangs de 30 pouces","Transporteur  de grosses balles carrées - traîné"]
[null,"Vie utile (années)",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,3,FALSE),0)","v":15},"Prix d'achat",170000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir en ligne à 16 rangs de 30 pouces","Foreuse pneumatique (ouvreurs indépendants)"]
[null,"Acres par année",{"$f":"E39*C15","v":1019.9999999999999},"Heures par année",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,2,FALSE),0)","v":100},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir-distributeur à 6 rangs de 30 pouces","Foreuse pneumatique (houe)"]
[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,"Semoir-distributeur à 12 rangs de 30 pouces","Foreuse pneumatique (disque)"]
[null,"Valeur de reprise**",{"$f":"IF(E41=\"\",\"\",E38-(E38*E41/100*C38))","v":57799.999999999985},"Taux d’amortissement annuel (% du prix d’achat) Tableau 3",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,4,FALSE),0)","v":4.4000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir-distributeur à 16 rangs de 30 pouces","Semoir pneumatique"]
[null,null,null,"Pourcentage à allouer pour les réparations annuelles (% du prix d’achat) Tableau 3",{"$f":"IF(D36<>\"\",VLOOKUP(D36,DeprRep,5,FALSE),0)","v":2.94},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir à céréales de 25 pieds","Semoir pour cultures en rangs"]
[null,"Coûts fixes annuels",null,null,"Totaux annuel $","$/heure","$/acre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir à céréales de 35 pieds","Charrues"]
[null,"Recouvrement des investissements*",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,"Semoir à roues plombeuses, 12 pieds","Disques"]
[null,"prix d’achat – valeur de reprise",null,{"$f":"E38-C41","v":112200.00000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir à roues plombeuses, 20 pieds","Cultivateurs"]
[null,"facteur lié au recouvrement des investissements Tableau 4","x",{"$f":"IFERROR((C5*(1+C5)^C38)/((1+C5)^C38-1),0)","v":9.6342287609244348E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir (semis direct), 15 pieds","Herses standards"]
[null,null,null,{"$f":"D45*D46","v":10809.604669757216},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir (semis direct), 20 pieds","Herses lourdes"]
[null,"valeur de reprise x taux d’intérêt**","+",{"$f":"(C41*C5)","v":2889.9999999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulvérisateur de 90 pieds, tracté","Herses de tasseurs",null,null,null,null,null,null,null,null,null,"per hour","implement1","implement2",null,"power + return+operator"]
[null,"Recouvrement des investissements*",null,null,{"$f":"D47+D48","v":13699.604669757216},{"$f":"IFERROR(E49/$E$39,0)","v":136.99604669757215},{"$f":"IFERROR(F49/($C$15),0)","v":13.430984970350211},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulvérisateur de 90 pieds, automoteur","Machines de labour vertical",null,null,null,null,null,null,null,null,null,"trade in",{"$f":"E38-C41","v":112200.00000000001},{"$f":"E60-C63","v":0},{"$f":"SUM(AN49:AO49)","v":112200.00000000001}]
[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,"Faucheuse-conditionneuse de 9 pieds","Rouleau",null,null,null,null,null,null,null,null,null,"cap recovery rate",{"$f":"D68","v":0}]
[null,"Assurance et remisage",null,{"$f":"\"prix d’achat x \"&$C$6*100&\" %\"","v":"prix d’achat x 1 %"},{"$f":"E38*C6","v":1700},{"$f":"IFERROR(E51/$E$39,0)","v":17},{"$f":"IFERROR(F51/($C$15),0)","v":1.6666666666666667},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faucheuse-conditionneuse rotative de 13 pieds","Décapeuses",null,null,null,null,null,null,null,null,null,null,{"$f":"AN49*AN50","v":0},{"$f":"AO49*AN50","v":0},{"$f":"SUM(AN51:AO51)","v":0}]
[null,"Coûts fixes totaux",null,null,{"$f":"SUM(E45:E51)","v":15399.604669757216},153.99604669757215,{"$f":"IFERROR(F52/($C$15),0)","v":15.097651637016879},"(C)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à balles carrées","Enfonce-pieux ",null,null,null,null,null,null,null,null,null,"interest",{"$f":"C41*C39","v":58955999.999999978},{"$f":"C63*C61","v":0}]
[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,"Presse à balles rondes de 1000 lb","Mélangeur d'aliments vertical",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN51:AN52)","v":58955999.999999978},{"$f":"SUM(AO51:AO52)","v":0},{"$f":"SUM(AN53:AO53)","v":58955999.999999978}]
[null,"Coûts d’utilisation annuels",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,"Presse à balles rondes de 1500 lb","Mélangeur-broyeur et mélangeur d'aliments",null,null,null,null,null,null,null,null,null,"insurance",{"$f":"E38*0.01","v":1700},{"$f":"E60*0.01","v":0},{"$f":"SUM(AN54:AO54)","v":1700}]
[null,"Réparations",null,"pourcentage à allouer pour les réparations annuelles x prix d’achat",{"$f":"(E38*E42/100)","v":4998},{"$f":"IFERROR(E55/$E$39,0)","v":49.98},{"$f":"IFERROR(F55/($C$15),0)","v":4.9000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à grosses balles carrées","Broyeur de balles",null,null,null,null,null,null,null,null,null,"repairs",{"$f":"E38*E42/100","v":4998},{"$f":"E60*E64/100","v":0},{"$f":"SUM(AN55:AO55)","v":4998}]
[null,"Coûts d’utilisation totaux",null,null,{"$f":"SUM(E54:E55)","v":4998},49.98,{"$f":"IFERROR(F56/($C$15),0)","v":4.9000000000000004},"(D)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à balles rondes de 1000 lb/enrubanneuse","Épandeurs de fumier",null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(AN53,AN54,AN55)","v":58962697.999999978},{"$f":"SUM(AO53,AO54,AO55)","v":0},{"$f":"SUM(AN56:AO56)","v":58962697.999999978},{"$f":"E35+(E35*C81)+E85","v":145076.89287942377},{"$f":"SUM(AP56:AQ56,AN57:AO57)","v":67952179.5928794}]
[null,"Coûts totaux",null,null,{"$f":"SUM(E56,E52)","v":20397.604669757216},{"$f":"SUM(F56,F52)","v":203.97604669757214},19.99765163701688,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Récolteuse-hacheuse à 2 rangs",null,null,null,null,null,null,null,null,null,null,"profit",{"$f":"AN56*C81","v":8844404.6999999955},{"$f":"AO56*C81","v":0}]
[null,"+ MATÉRIEL 2 (INSTRUMENT ARATOIRE, MACHINE MUE PAR ",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,"Récolteuse-hacheuse automotrice à 6 rangs de 15 pieds",null,null,null,null,null,null,null,null,null,null,"per hour",{"$f":"IFERROR(AN56/E39,\"\")","v":589626.97999999975},{"$f":"IFERROR(AO56/E61,\"\")","v":""},null,{"$f":"IFERROR(AQ56/E12,\"\")","v":580.30757151769512},{"$f":"SUM(AN58:AQ58)","v":590207.2875715174}]
[null,"PRISE DE FORCE, AUTRE)",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,"Grosse souffleuse à fourrage"]
[null,"Vie utile (années)",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,3,FALSE),0)","v":0},"Prix d'achat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuse-batteuse à maïs, 6 becs cueilleurs–30 po",null,null,null,null,null,null,null,null,null,null,"ST rental","implement1","implement2",null,"power"]
[null,"Acres par année",{"$f":"E61*C15","v":0},"Heures par année",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuse-batteuse à maïs, 12 becs cueilleurs–30 po",null,null,null,null,null,null,null,null,null,null,"machine costs",{"$f":"AN56","v":58962697.999999978},{"$f":"AO56","v":0},null,{"$f":"E35-E32","v":95103.8198951511},{"$f":"SUM(AN61:AQ61)","v":59057801.819895126}]
[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,"Moissonneuse-batteuse à céréales, 25 pieds",null,null,null,null,null,null,null,null,null,null,"profit",{"$f":"AN61*E101","v":8844404.6999999955},{"$f":"AO61*E101","v":0},null,{"$f":"AQ61*E101","v":14265.572984272665},{"$f":"SUM(AN62:AQ62)","v":8858670.2729842681}]
[null,"Valeur de reprise**",{"$f":"IF(E63=\"\",\"\",E60-(E60*E63/100*C60))","v":0},"Taux d’amortissement annuel (% du prix d’achat) Tableau 3",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,4,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuse-batteuse à céréales, 35 pieds",null,null,null,null,null,null,null,null,null,null,"total",{"$f":"SUM(AN61:AN62)","v":67807102.699999973},{"$f":"SUM(AO61:AO62)","v":0},null,{"$f":"SUM(AQ61:AQ62)","v":109369.39287942377},{"$f":"SUM(AR61:AR62)","v":67916472.0928794}]
[null,null,null,"Pourcentage à allouer pour les réparations annuelles (% du prix d’achat) Tableau 3",{"$f":"IF(D58<>\"\",VLOOKUP(D58,DeprRep,5,FALSE),0)","v":0},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,null,"per hour",{"$f":"IFERROR(AN63/E39,\"\")","v":678071.02699999977},{"$f":"IFERROR(AO63/E61,\"\")","v":""},null,{"$f":"IFERROR(AQ63/E12,\"\")","v":437.47757151769508},{"$f":"SUM(AN64:AQ64)","v":678508.50457151746}]
[null,"Coûts fixes annuels",null,null,"Totaux annuel $","$/heure","$/acre"]
[null,"Recouvrement des investissements*"]
[null,"prix d’achat – valeur de reprise",null,{"$f":"(E60-C63)","v":0}]
[null,"facteur lié au recouvrement des investissements Tableau 4","x",{"$f":"IFERROR((C5*(1+C5)^C60)/((1+C5)^C60-1),0)","v":0}]
[null,null,null,{"$f":"IFERROR(D67*D68,0)","v":0}]
[null,"valeur de reprise x taux d’intérêt**","+",{"$f":"(C63*C5)","v":0}]
[null,"Recouvrement des investissements*",null,null,{"$f":"D69+D70","v":0},{"$f":"IFERROR(E71/$E$61,0)","v":0},{"$f":"IFERROR(E71/($E$61*$C$15),0)","v":0}]
[]
[null,"Assurance et remisage",null,{"$f":"\"prix d’achat x \"&$C$6*100&\" %\"","v":"prix d’achat x 1 %"},{"$f":"E60*C6","v":0},{"$f":"IFERROR(E73/$E$61,0)","v":0},{"$f":"IFERROR(E73/($E$61*$C$15),0)","v":0}]
[null,"Coûts fixes totaux",null,null,{"$f":"SUM(E67:E73)","v":0},0,{"$f":"IFERROR(E74/($E$61*$C$15),0)","v":0},"(C)"]
[]
[null,"Coûts d’utilisation annuels"]
[null,"Réparations",null,"pourcentage à allouer pour les réparations annuelles x prix d’achat",{"$f":"(E60*E64/100)","v":0},{"$f":"IFERROR(E77/$E$61,0)","v":0},{"$f":"IFERROR(E77/($E$61*$C$15),0)","v":0}]
[null,"Coûts d’utilisation totaux",null,null,{"$f":"SUM(E76:E77)","v":0},0,{"$f":"IFERROR(E78/($E$61*$C$15),0)","v":0},"(D)"]
[null,"Coûts totaux",null,null,{"$f":"SUM(E78,E74)","v":0},0,{"$f":"IFERROR(E79/($E$61*$C$15),0)","v":0}]
[null,"= COÛTS ANNUELS DU MATÉRIEL (A + B + C + D)",null,null,{"$f":"SUM(E79,E35,E57)","v":139801.42456490832},{"$f":"F79+F57+F35","v":681.59132627817655},{"$f":"G79+G57+G35","v":66.822679046880069},"(E)"]
[null,"Rémunération de la gestion, frais d'administration",{"$f":"E8","v":0.15},"Rémunération de conducteur (entrepreneur ou salarié)",{"$f":"E7","v":27}]
[null,null,null,"Allocation de travail pour le déplacement des machines et temps morts",0.15]
[null,null,null,null,"Totaux annuel $","$/heure","$/acre"]
[null," + Marge bénéficiaire (rémunération de la gestion, frais d'administration)",null,null,{"$f":"E80*C81","v":20970.213684736245},{"$f":"E84/E12","v":83.880854738944976},{"$f":"IFERROR(E84/C12,0)","v":8.2236132097004884},"(F)"]
[null," + Rémunération du conducteur (entrepreneur ou salarié)",null,null,{"$f":"E12*E81*(1+E82)","v":7762.4999999999991},{"$f":"E85/E12","v":31.049999999999997},{"$f":"IFERROR(E85/C12,0)","v":3.0441176470588234},"(G)"]
[null,"=    Coûts totaux   (E+F+G)",null,null,{"$f":"E80+E84+E85","v":168534.13824964457},null,null,"(H)"]
[null," = Tarif",null,"$/heure",null,{"$f":"F79+F57+F35+F84+F85","v":796.52218101712151}]
[null,null,null,"$/acre",null,null,{"$f":"IFERROR(G79+G57+G35+G84+G85,0)","v":78.090409903639383}]
[null,"* La méthode de recouvrement des investissements estime les coûts annuels d’amortissement et d’intérêt. Elle regroupe"]
[null,"tous ces coûts en un seul calcul. Pour calculer les coûts de recouvrement des investissements, le facteur lié au"]
[null,"recouvrement des investissements est multiplié par la dépréciation totale et l’on ajoute à ce résultat la valeur de reprise"]
[null,"multipliée par le taux d’intérêt. Le tableau 5 présente les facteurs liés au recouvrement des investissements pour des"]
[null,"combinaisons choisies d’années et de taux d’intérêt."]
[null,"** Valeur de reprise = prix d’achat – (prix d’achat x taux d’amortissement annuel [voir le tableau 3] x nombre d’années depropriété)."]
[null,"*** Intérêt : L’intérêt annuel moyen qu’aurait rapporté le placement de l’argent (le vôtre et/ou celui du prêteur) qui est immobilisé dans la machine."]
[]
[]
[null,"Calculateur des tarifs de location d'équipement à court terme",null,null,"Totaux annuel $","$/heure","$/acre"]
[null," + Coûts du matériel (voir Calcul des tarifs des travaux agricoles à forfait, ci-dessus)",null,null,{"$f":"E80","v":139801.42456490832},{"$f":"F80","v":681.59132627817655},{"$f":"G80","v":66.822679046880069},"(E)"]
[null," –   Coût total du carburant et des lubrifiants (le cas échéant) (voir Calcul des tarifs des travaux agricoles à forfait, ci-dessus)",null,null,{"$f":"E32","v":24300},{"$f":"F32","v":97.2},{"$f":"G32","v":9.529411764705884},"(J)"]
[null,"Rémunération de la gestion",null,null,{"$f":"C81","v":0.15}]
[null," + Marge bénéficiaire (rémunération de la gestion, frais d'administration) on suggère de majorer de 15 % les coûts du matériel ( E – J) x 0,15 ",null,null,{"$f":"(E99-E100)*E101","v":17325.213684736245},{"$f":"(F99-F100)*E101","v":87.65869894172647},{"$f":"(G99-G100)*E101","v":8.593990092326127},"(K)"]
[null,"=    Coûts totaux   (E–J+K)",null,null,{"$f":"E99-E100+E102","v":132826.63824964457},null,null,"(L)"]
[null," = Tarif de location                     ",null,"$/heure",null,{"$f":"F99-F100+F102","v":672.05002521990298}]
[null,null,null,"$/acre",null,null,{"$f":"G99-G100+G102","v":65.887257374500308}]
[null,"Remarque : Les loueurs peuvent appliquer des tarifs journaliers ou hebdomadaires minimums."]
[]
[]
[null,"fin de la feuille de calcul"]

{"sheet":"Tableaux","index":2,"n_rows":76,"n_cols":28,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,"Tableaux 4 et 5  voir la droite"]
[]
[null,"Tableau 3, Heures d’utilisation annuelles, vie utile optimale, amortissement et pourcentage à allouer pour\nles réparations",null,null,null,null,null,"Tableau 4. Facteurs liés au recouvrement des investissements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLEAU 5. Besoins relatifs au rendement, à la puissance motrice et au carburant pour certaines machines agricoles"]
[null,"Machine","Utilisation annuelle (heures)","Vie utile optimale (années)","Taux d’amortissement annuel (% du prix d’achat)","Pourcentage à allouer pour les réparations annuelles (% du prix d’achat)",null,null,"Taux d’intérêt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Puissance nominale du moteur en CV(1,2)","Acres/heure(2)","Litres/acre","Litres/heure(3)"]
[null,"Tracteurs 2RM",300,20,3.3000000000000003,2.31,null,"Année",0.02,0.03,0.04,0.05,0.06,7.0000000000000007E-2,0.08,0.09,0.1,0.11,0.12,0.13,0.14000000000000001,0.15,null,"Charrue à 4 socs 18 pouces",85,2.8,5.8285714285714292,16.32]
[null,"Tracteurs avec assistance roues avant",450,15,4.4000000000000004,2.73,null,1,1.02,1.03,1.04,1.05,1.06,1.07,1.08,1.0900000000000001,1.1000000000000001,1.1100000000000001,1.1200000000000001,1.1299999999999999,1.1399999999999999,1.1499999999999999,null,"Charrue à 6 socs 18 pouces",160,3,10.24,30.72]
[null,"Tracteurs 4RM",450,15,4.4000000000000004,2.63,null,2,0.51500000000000001,0.52300000000000002,0.53,0.53800000000000003,0.54500000000000004,0.55300000000000005,0.56100000000000005,0.56799999999999995,0.57599999999999996,0.58399999999999996,0.59199999999999997,0.59899999999999998,0.60699999999999998,0.61499999999999999,null,"Charrue à 8 socs 18 pouces",285,5.6,9.7714285714285722,54.72]
[null,"Tracteurs à chenilles",450,15,4.4000000000000004,3.36,null,3,0.34699999999999998,0.35399999999999998,0.36,0.36699999999999999,0.374,0.38100000000000001,0.38800000000000001,0.39500000000000002,0.40200000000000002,0.40899999999999997,0.41599999999999998,0.42399999999999999,0.43099999999999999,0.438,null,"Cultivateur de 24 pieds",160,9,3.4133333333333331,30.72]
[null,"Moissonneuses-batteuses automotrices",250,12,5.6000000000000005,2.63,null,4,0.26300000000000001,0.26900000000000002,0.27500000000000002,0.28199999999999997,0.28899999999999998,0.29499999999999998,0.30199999999999999,0.309,0.315,0.32200000000000001,0.32900000000000001,0.33600000000000002,0.34300000000000003,0.35,null,"Cultivateur de 31 pieds",255,20.6,2.3766990291262133,48.96]
[null,"Têtes à rigide",250,20,3.3000000000000003,2.1,null,5,0.21199999999999999,0.218,0.22500000000000001,0.23100000000000001,0.23699999999999999,0.24399999999999999,0.25,0.25700000000000001,0.26400000000000001,0.27100000000000002,0.27700000000000002,0.28399999999999997,0.29099999999999998,0.29799999999999999,null,"Cultivateur de 44 pieds",305,29.1,2.0123711340206185,58.56]
[null,"Têtes à ramasseur",250,20,3.3000000000000003,1.58,null,6,0.17899999999999999,0.185,0.191,0.19700000000000001,0.20300000000000001,0.21,0.216,0.223,0.23,0.23599999999999999,0.24299999999999999,0.25,0.25700000000000001,0.26400000000000001,null,"Charrue chisel de 16 pieds",175,9,3.7333333333333334,33.6]
[null,"Têtes à flexible",250,15,4.4000000000000004,2.63,null,7,0.155,0.161,0.16700000000000001,0.17299999999999999,0.17899999999999999,0.186,0.192,0.19900000000000001,0.20499999999999999,0.21199999999999999,0.219,0.22600000000000001,0.23300000000000001,0.24,null,"Charrue chisel de 21 pieds",275,12.6,4.1904761904761907,52.800000000000004]
[null,"Têtes à tapis",250,15,4.4000000000000004,2.94,null,8,0.13700000000000001,0.14199999999999999,0.14899999999999999,0.155,0.161,0.16700000000000001,0.17399999999999999,0.18099999999999999,0.187,0.19400000000000001,0.20100000000000001,0.20799999999999999,0.216,0.223,null,"Pulvériseur tandem de 24 pieds",170,15.1,2.16158940397351,32.64]
[null,"Têtes à maïs",100,15,4.4000000000000004,2.94,null,9,0.123,0.128,0.13400000000000001,0.14099999999999999,0.14699999999999999,0.153,0.16,0.16700000000000001,0.17399999999999999,0.18099999999999999,0.188,0.19500000000000001,0.20200000000000001,0.21,null,"Pulvériseur tandem de 30 pieds",255,15.3,3.1999999999999997,48.96]
[null,"Andainage automotrices",200,15,4.4000000000000004,2.1,null,10,0.111,0.11700000000000001,0.123,0.13,0.13600000000000001,0.14199999999999999,0.14899999999999999,0.156,0.16300000000000001,0.17,0.17699999999999999,0.184,0.192,0.19900000000000001,null,"Pulvériseur déporté de 10 pieds",125,6,4,24]
[null,"Remorques à grain",250,20,3.3000000000000003,2.1,null,11,0.10199999999999999,0.108,0.114,0.12,0.127,0.13300000000000001,0.14000000000000001,0.14699999999999999,0.154,0.161,0.16800000000000001,0.17599999999999999,0.183,0.191,null,"Pulvériseur déporté de 16 pieds",175,9.6,3.5000000000000004,33.6]
[null,"Tarières - (puissance)",100,20,3.3000000000000003,1.58,null,12,9.5000000000000001E-2,0.1,0.107,0.113,0.11899999999999999,0.126,0.13300000000000001,0.14000000000000001,0.14699999999999999,0.154,0.161,0.16900000000000001,0.17699999999999999,0.184,null,"Machine de labour vertical de 21 pieds",215,19.600000000000001,2.1061224489795918,41.28]
[null,"Tarières - (prise de force)",100,20,3.3000000000000003,1.58,null,13,8.7999999999999995E-2,9.4E-2,0.1,0.106,0.113,0.12,0.127,0.13400000000000001,0.14099999999999999,0.14799999999999999,0.156,0.16300000000000001,0.17100000000000001,0.17899999999999999,null,"Machine de labour vertical de 30 pieds",305,27.2,2.1529411764705886,58.56]
[null,"Aspirateur à grains",50,15,4.4000000000000004,2.1,null,14,8.3000000000000004E-2,8.8999999999999996E-2,9.5000000000000001E-2,0.10100000000000001,0.108,0.114,0.121,0.128,0.13600000000000001,0.14299999999999999,0.151,0.159,0.16700000000000001,0.17499999999999999,null,"Machine de labour vertical de 43 pieds",420,39.200000000000003,2.0571428571428569,80.64]
[null,"Récolteuses-hacheuses automotrices",400,10,6.7,8.4,null,15,7.8E-2,8.4000000000000005E-2,0.09,9.6000000000000002E-2,0.10299999999999999,0.11,0.11700000000000001,0.124,0.13100000000000001,0.13900000000000001,0.14699999999999999,0.155,0.16300000000000001,0.17100000000000001,null,"Machine de labour en bandes à 12 rangs",330,17.5,3.6205714285714286,63.36]
[null,"Récolteuses-hacheuses automotrices - Têtes",400,10,6.7,8.4,null,16,7.3999999999999996E-2,0.08,8.5999999999999993E-2,9.1999999999999998E-2,9.9000000000000005E-2,0.106,0.113,0.12,0.128,0.13600000000000001,0.14299999999999999,0.151,0.16,0.16800000000000001,null,"Semoir en ligne à 6 rangs de 30 pouces",110,7.6,2.7789473684210528,21.12]
[null,"Faucheuse-conditionneuse automotrices",150,15,4.4000000000000004,3.36,null,17,7.0000000000000007E-2,7.5999999999999998E-2,8.2000000000000003E-2,8.8999999999999996E-2,9.5000000000000001E-2,0.10199999999999999,0.11,0.11700000000000001,0.125,0.13200000000000001,0.14000000000000001,0.14899999999999999,0.157,0.16500000000000001,null,"Semoir en ligne à 12 rangs de 30 pouces",160,15.3,2.0078431372549019,30.72]
[null,"Faucheuse-conditionneuse (faucille) traîné",150,15,4.4000000000000004,2.1,null,18,6.7000000000000004E-2,7.2999999999999995E-2,7.9000000000000001E-2,8.5999999999999993E-2,9.1999999999999998E-2,9.9000000000000005E-2,0.107,0.114,0.122,0.13,0.13800000000000001,0.14599999999999999,0.155,0.16300000000000001,null,"Semoir en ligne à 16 rangs de 30 pouces",175,20.399999999999999,1.6470588235294119,33.6]
[null,"Faucheuse-conditionneuse (disque) traîné",150,15,4.4000000000000004,2.63,null,19,6.4000000000000001E-2,7.0000000000000007E-2,7.5999999999999998E-2,8.3000000000000004E-2,0.09,9.7000000000000003E-2,0.104,0.112,0.12,0.128,0.13600000000000001,0.14399999999999999,0.153,0.161,null,"Semoir-distributeur à 6 rangs de 30 pouces",85,6.4,2.5499999999999998,16.32]
[null,"Râteau à foin (roue)",50,20,3.3000000000000003,2,null,20,6.0999999999999999E-2,6.7000000000000004E-2,7.3999999999999996E-2,0.08,8.6999999999999994E-2,9.4E-2,0.10199999999999999,0.11,0.11700000000000001,0.126,0.13400000000000001,0.14199999999999999,0.151,0.16,null,"Semoir-distributeur à 12 rangs de 30 pouces",175,15.3,2.1960784313725492,33.6]
[null,"Presses à balles rondes",100,15,4.4000000000000004,1.58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir-distributeur à 16 rangs de 30 pouces",255,20.399999999999999,2.4000000000000004,48.96]
[null,"Presses à grosses balles carrées",150,15,4.4000000000000004,1.79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir à céréales de 25 pieds",160,11.7,2.6256410256410256,30.72]
[null,"Presses à petites balles carrées",100,20,3.3000000000000003,1.05,null,"Tracteur exemple, Tableau 3 et 4:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir à céréales de 35 pieds",255,16.3,3.003680981595092,48.96]
[null,"Transporteur  de balles rondes - traîné",100,15,4.4000000000000004,2.63,null,null,"Tracteur à 4 roues motrices de 310 chevauxvapeur (CV)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir à roues plombeuses, 12 pieds",85,5.0999999999999996,3.2,16.32]
[null,"Transporteur  de grosses balles carrées - traîné",200,20,3.3000000000000003,2.1,null,"Prix d’achat","470 000$",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir à roues plombeuses, 20 pieds",160,8.5,3.6141176470588232,30.72]
[null,"Transporteur automoteur de petites balles carrées",150,15,4.4000000000000004,2.63,null,"Utilisation prévue","450 h par an pendant 5 ans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir (semis direct), 15 pieds",160,7,4.3885714285714288,30.72]
[null,"Foreuse pneumatique (ouvreurs indépendants)",200,15,4.4000000000000004,3.68,null,"Amortissement","Amortissement total estimatif sur 5 ans",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Semoir (semis direct), 20 pieds",200,9.3000000000000007,4.129032258064516,38.4]
[null,"Foreuse pneumatique (houe)",200,15,4.4000000000000004,3.15,null,null,"= taux d’amortissement annuel de 4,4 % (tableau 3,tracteurs à 4 roues motrices) x 5 ans x 470 000$ = 103 400$ amortissement total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulvérisateur de 90 pieds, tracté",110,49.6,0.42580645161290326,21.12]
[null,"Foreuse pneumatique (disque)",200,15,4.4000000000000004,3.15,null,"Valeur de reprise","= 470 000 $ (prix d’achat) – 103 400 $ (amortissement total) = 366 600 $",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pulvérisateur de 90 pieds, automoteur",95,72.5,0.25158620689655176,16.3]
[null,"Semoir pneumatique",200,15,4.4000000000000004,3.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faucheuse-conditionneuse de 9 pieds",45,4.4000000000000004,1.9636363636363636,8.64]
[null,"Semoir pour cultures en rangs",100,10,6.7,4.2,null,"Recouvrement du capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faucheuse-conditionneuse rotative de 13 pieds",85,9.6999999999999993,1.682474226804124,16.32]
[null,"Charrues",100,20,3.3000000000000003,3.68,null,null,"= (amortissement total x facteur de recouvrement du capital) + (valeur de reprise x taux d’intérêt)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à balles carrées",45,4.4000000000000004,1.9636363636363636,8.64]
[null,"Disques",100,20,3.3000000000000003,1.58,null,null,"= (103 400 $ x 0,218 (du tableau 4, 3 % d’intérêt sur 5 ans)) + (366 600 $ x 3 %)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à balles rondes de 1000 lb",70,3,4.4799999999999995,13.44]
[null,"Cultivateurs",200,20,3.3000000000000003,1.58,null,null,"= 22 541 $ + 10 998 $",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à balles rondes de 1500 lb",70,4,3.36,13.44]
[null,"Herses standards",75,25,2.7,1.26,null,null,"= recouvrement du capital de 33 539 $ par an (amortissement et frais d’intérêt).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à grosses balles carrées",160,16.3,1.8846625766871163,30.72]
[null,"Herses lourdes",100,20,3.3000000000000003,1.58,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Presse à balles rondes de 1000 lb/enrubanneuse",70,3,4.4799999999999995,13.44]
[null,"Herses de tasseurs",200,25,2.7,0.53,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Récolteuse-hacheuse à 2 rangs",160,1.4,21.942857142857143,30.72]
[null,"Machines de labour vertical",100,20,3.3000000000000003,3.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Récolteuse-hacheuse automotrice à 6 rangs de 15 pieds",625,5.0999999999999996,20.6,105]
[null,"Rouleau",75,20,3.3000000000000003,1.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grosse souffleuse à fourrage",70,"—","—",13.44]
[null,"Décapeuses",80,10,6.7,2.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuse-batteuse à maïs, 6 becs cueilleurs–30 po",275,5.0999999999999996,11.858823529411767,52.8]
[null,"Pulvérisateurs enjambeurs automoteurs",175,8,8.3000000000000007,3.68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuse-batteuse à maïs, 12 becs cueilleurs–30 po",375,10.199999999999999,8.0000000000000018,72]
[null,"Enfonce-pieux ",40,20,3.3000000000000003,2.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuse-batteuse à céréales, 25 pieds",375,7.4,11.027027027027028,72]
[null,"Mélangeur d'aliments vertical",200,15,4.4000000000000004,2.63,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moissonneuse-batteuse à céréales, 35 pieds",375,10.4,7.8461538461538467,72]
[null,"Mélangeur-broyeur et mélangeur d'aliments",200,15,4.4000000000000004,3.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Multipliez le nombre de CV du moteur par 0,88 pour obtenir la prise de force (PTO) en CV."]
[null,"Broyeur de balles",200,15,4.4000000000000004,3.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Illinois Machinery Cost Estimates for 2023, Université de l’Illinois, Département de l’économie de l’agriculture et de la consommation, 2023."]
[null,"Épandeurs de fumier",100,10,6.7,4.62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Nebraska Tractor Test Laboratory. Tractor fuel consumption results, 2018–2024."]
[null,"Source : Farm Machinery Custom and Rental Rate Guide, ministère de l’Agriculture de la Saskatchewan, 2024-2025."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fin de la feuille de calcul"]
[]
[]
[null,"EXEMPLE ","CALCUL DES COÛTS DE RÉPARATION ANNUELS"]
[null,"Coût d’une moissonneuse-batteuse 375 HP neuve ","820 000$ = 740 000$ (moissonneuse-batteuse) + 170 000$ ( tête à maïs)"]
[null,"Pourcentages estimatifs à allouer pour les réparations*","2.63% moissonneuse-batteuse"]
[null,null,"2.94%  tête à maïs"]
[]
[null,"Coûts de réparation annuels","Moissonneuse-batteuse: 740 000$ x 2.63%soit une moyenne de 19 462$ par année"]
[null,null,"Tête à maïs: 170 000$ x 2.94% soit une moyenne de 4 998$ par année"]
[]
[null,null,"Total des coûts de réparation annuels = 19 462$ + 4 998$ = 24 460$ par année"]
[null,"Machine d’occasion","Pour calculer l’amortissement d’une machine d’occasion, on soustrait"]
[null,null,"du prix réellement payé pour acheter la machine la valeur prévue"]
[null,null,"de reprise ou de récupération et on divise le résultat par la vie"]
[null,null,"utile prévue dans l’exploitation. Le pourcentage à allouer pour les"]
[null,null,"réparations doit être augmenté en fonction de l’âge de la machine"]
[null,null,"ou du nombre d’heures qu’elle a déjà effectué. Il faut s’attendre"]
[null,null,"à dépenser plus que la normale pendant l’année qui suit l’achat"]
[null,null,"d’une machine d’occasion à cause des réparations supplémentaires"]
[null,null,"nécessaires pour remettre celle-ci en parfait état de marche."]
[]
[null,"fin de la feuille de calcul"]

{"sheet":"Fiche technique","index":3,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["GUIDE DES TRAVAUX AGRICOLES A FORFAIT ET DE LA LOCATION DE MATÉRIEL "]
["par John Molenhuis"]
["chargé de programme, analyse des activités commerciales et des coûts de production"]
[]
["Ministère de l’Agriculture, de l’Alimentation et de l’Agroentreprise"]
[]
["Cette fiche technique contient les tarifs perçus en 2024 pour les travaux agricoles à forfait et un guide pour vous aider à calculer des contrats de travail à forfait."]
[]
["https://www.ontario.ca/fr/page/cout-de-production-des-cultures-et-du-betail"]
[]
["fin de la feuille de calcul"]

{"sheet":"tarifs2024","index":4,"n_rows":180,"n_cols":17,"rows_kept":180,"cut":false,"hidden":false,"merged":[]}
["Enquête sur les tarifs perçus en 2024 pour les "]
["travaux agricoles à forfait"]
["J. Molenhuis - MAAAO - Analyse des activités commerciales et des coûts de production "]
["Ficheinfo",null,null,null,null,null,null,null,null,null,null,null,null,"mars 2025"]
["Détails de l'enquête"]
["Résultats de l'enquête sur les tarifs perçus en 2024 pour les travaux agricoles à forfait résume les résultats d'une étude effectuée"]
["en Ontario auprès de 200 entrepreneurs en travaux agricoles. Les résultats ont été synthétisés à l'échelle provinciale et également"]
["à l'échelle de régions. En raison du nombre insuffisant de réponses reçues de la région 6, les résultats pour cette région ne sont pas publiés. "]
["Ils ont été assortis, chaque fois que possible, du tarif provincial moyen qui avait été observé lors de l'enquête de 2021, "]
["la dernière à avoir été faite avant celle de 2024."]
["Tarifs moyens"]
["Un tarif moyen est fourni chaque fois qu'au moins trois entrepreneurs ont répondu à l'enquête. Plus le nombre d'entrepreneurs"]
["ayant indiqué un tarif est élevé, plus le sommaire traduit fidèlement les tarifs du marché."]
["La colonne Nbre indique le nombre de réponses reçues pour l'opération."]
["Qu'est-ce que les percentiles et à quoi servent-ils?"]
["Les percentiles servent à montrer l'étendue de la fourchette à l'intérieur de laquelle varient la plupart des tarifs. Par exemple, dans"]
["le sommaire provincial, le 15e percentile pour le moissonnage-battage du maïs est de 54 $/acre et le"]
["85e percentile, de 75 $/acre. Cela signifie que 15 % des entrepreneurs ayant répondu demandaient 54 $/acre ou moins et que 15 %"]
["demandaient plus de 75 $. Soixante-dix pour cent (85e - 15e percentiles) des répondants demandaient entre 54 $ et 75 $/acre. Le"]
["tarif moyen était donc de 65 $/acre."]
[]
["Régions"]
["Région 1"]
["Chatham-Kent, Elgin, Essex, Lambton, Middlesex"]
["Région 2"]
["Brant, Haldimand, Hamilton, Niagara, Norfolk, Oxford"]
["Région 3"]
["Bruce, Dufferin, Grey, Halton, Huron, Peel, Perth, Simcoe, Waterloo, Wellington"]
["Région 4"]
["Durham, Haliburton, Hastings, Kawartha Lakes, Muskoka, Northumberland, Parry Sound, Peterborough, Prince Edward, York"]
["Région 5"]
["Frontenac, Lanark, Leeds-Grenville, Lennox-Addington, Ottawa, Prescott-Russell, Renfrew, Stormont-Dundas-Glengarry"]
["Région 6"]
["Algoma, Cochrane, Kenora, Manitoulin, Nipissing, Rainy River, Sudbury, Thunder Bay, Timiskaming"]
[null,"Unité","Nombre de réponses","Provincialmoyenne 2024 ($/unité)","Provincial 2024 percentile 15e ($/unité)","Provincial2024 percentile85e ($/unité)"," Provincialmoyenne 2021 ($/unité)","Région 1 nombre de réponses","Région 1 2024 moyenne ($/unité)","Région 2 nombre de réponses","Région 2 2024 moyenne ($/unité)","Région 3 nombre de réponses","Région 3 2024 moyenne ($/unité)","Région 4 nombre de réponses","Région 4 2024 moyenne ($/unité)","Région 5 nombre de réponses","Région 5 2024 moyenne ($/unité)"]
["TRAVAIL DU SOL"]
["Charrue à socs – sillon fixe","acre",14,37.571428571428569,29.75,44.3,36.694444444444443,5,40.200000000000003,"","",7,33.285714285714285,"","","",""]
["Charrue à socs – roulante","acre",4,39.5,"","",38.25,"","","","","","","","","",""]
["Charrue à socs – roulante","heure",4,136.25,"","","","","","","",3,123.33333333333333,"","","",""]
["Charrue à socs – largeur variable","acre",7,40.428571428571431,"","",33.694444444444443,"","","","",5,40.6,"","","",""]
["Charrue à socs – largeur variable","heure",3,203.33333333333334,"","",91.666666666666671,"","","","",3,203.33333333333334,"","","",""]
["Charrue chisel/déchaumeuse","acre",48,33.78125,25,41.899999999999991,28.681034482758619,10,39,12,34,19,29.973684210526315,"","",7,36.285714285714285]
["Charrue chisel/déchaumeuse","heure",4,225,"","",230.5,"","","","",3,233.33333333333334,"","","",""]
["Charrue Fauchage à disques - labourage","acre",40,27.962499999999999,22.549999999999997,35,24.46875,10,25.3,7,28,14,27.642857142857142,"","",7,30.071428571428573]
["Charrue Fauchage à disques - travail supplémentaire du sol","acre",25,27.24,19.2,35,22.75,4,23.75,6,24.75,8,27.5,"","",5,28.7]
["Disc - grande vitesse","acre",54,30.00925925925926,25,35,23.940789473684209,13,28.46153846153846,8,31.4375,22,29.727272727272727,3,30.333333333333332,7,32.714285714285715]
["Travail du sol - vertical","acre",47,27.957446808510639,23.799999999999997,35,23.614035087719298,15,26.4,9,28.333333333333332,15,27.533333333333335,3,33.333333333333336,5,30]
["Travail du sol en bandes","acre",9,39.333333333333336,30,43.6,29.4,"","","","",6,34.166666666666664,"","","",""]
["Labour avec disque en V","acre",10,37.35,30.449999999999996,42.599999999999994,37.571428571428569,6,36.833333333333336,"","","","","","","",""]
["Cultivateur","acre",86,23.255813953488371,16.5,30,18.144186046511628,18,24.194444444444443,21,22.714285714285715,33,20.787878787878789,3,25,11,29.681818181818183]
["Cultivateur","heure",5,182,"","",265.88888888888891,"","","","",4,190,"","","",""]
["Hersage","acre",5,17,"","",12.6,"","","","",4,15,"","","",""]
["Travail profond/sous-soleuse","acre",18,39.962962962962962,35,50,30.25,8,40.916666666666664,"","",6,35.333333333333336,"","",3,48.333333333333336]
["Herse de finition","acre",3,29.333333333333332,"","",21.142857142857142,3,29.333333333333332,"","","","","","","",""]
["Rouleau","acre",56,10.696428571428571,6.25,14,9.0809090909090902,6,10.5,10,11.125,29,9.9913793103448274,3,12,8,12.375]
["Rouleau","heure",3,150,"","",193.33333333333334,"","","","","","","","","",""]
["Récolte en tiges","acre",3,24.666666666666668,"","",27,3,24.666666666666668,"","","","","","","",""]
["SEMIS - SOYA"]
["Semoir en lignes standard -15/20 pouce","acre",47,32.106382978723403,28,37,26.745238095238093,19,31,14,32.142857142857146,12,33.75,"","","",""]
["Semoir en lignes standard - 30 pouce","acre",25,33.24,28,40,26.378947368421052,6,30.166666666666668,"","",10,31.8,"","",6,36.166666666666664]
["Travail minimum/semis direct - 15/20 pouce","acre",54,32.018518518518519,26.9,37,27.871794871794872,15,31.4,12,31.25,21,31.80952380952381,"","",6,36.166666666666664]
["Travail minimum/semis direct - 30 pouce","acre",10,34.799999999999997,32.35,36.65,28.071428571428573,"","","","",6,34.333333333333336,3,36.666666666666664,3,35]
["Semoir pour travail en bandes – 30 pouce","acre",3,35,"","","","","","","","","","","","",""]
["Semoir de précision standard","acre",14,31.142857142857142,24.85,37.049999999999997,22.8,"","",3,28.333333333333332,9,31,"","","",""]
["Semis direct","acre",54,32.537037037037038,27.95,36.024999999999999,27.532608695652176,9,30.444444444444443,9,32.611111111111114,22,31.65909090909091,"","","",""]
["Semoir pneumatique","acre",56,32.896428571428572,28,36.875,26.340425531914892,6,30.833333333333332,11,33.409090909090907,28,31.775000000000002,9,35.555555555555557,5,34.6]
["SEMIS - MAÏS "]
["Semoir en lignes standard - 15/20 pouce","acre",6,34.25,"","",30.125,"","","","","","","","","",""]
["Semoir en lignes standard - 30 pouce","acre",92,32.747282608695649,28,39.349999999999994,26.602409638554217,18,31.666666666666668,19,32.263157894736842,39,32.121794871794869,5,41,11,33.81818181818182]
["Travail minimum/semis direct - 15/20 pouce","acre",4,32.75,"","",29.25,"","","","","","","","","",""]
["Travail minimum/semis direct - 30 pouce","acre",50,34.14,28,40,28.407894736842106,8,30.125,9,33.666666666666664,22,32.75,6,40.75,4,40.75]
["Semoir pour travail en bandes – 30 pouce","acre",7,41.714285714285715,"","",26.676923076923078,3,46,"","","","","","","",""]
["Semis direct","acre",4,32.5,"","",33.333333333333336,"","","","","","","","","",""]
["Semoir pneumatique","acre",4,32.75,"","","","","","","","","","","","",""]
["SEMIS - CÉRÉALES (AVOINE, ORGE, BLÉ)"]
["Semoir de précision standard","acre",23,32.304347826086953,25,37.4,22.431818181818183,4,30.75,7,31.714285714285715,10,31,"","","",""]
["Semis direct","acre",44,32.159090909090907,25.9,36.549999999999997,26.990384615384617,9,29.333333333333332,6,29.833333333333332,20,31.574999999999999,7,38.071428571428569,"",""]
["Semoir pneumatique","acre",54,33.220370370370375,29.9,36.024999999999999,26.439024390243901,7,31.571428571428573,12,34.179166666666667,26,33.028846153846153,"","",6,34.166666666666664]
["SEMIS - CULTURES FOURRAGÈRES"]
["Semoir – un réservoir","acre",11,29.545454545454547,23.5,35,24.2,"","",4,30.5,3,28.333333333333332,"","","",""]
["Semoir – Plusieurs produits","acre",10,34.700000000000003,30.449999999999996,38,27.57,"","",3,34.333333333333336,4,34,"","","",""]
["Épandage centrifuge/VTT","acre",10,9.5,6.1749999999999998,10,5.8166666666666664,"","",3,8.1666666666666661,5,11.2,"","","",""]
["Ensemencement en sol gelé","acre",4,12.5,"","","","","","","",3,13.333333333333334,"","","",""]
["Ensemencement de cultures de couverture","acre",21,30.547619047619047,20,40,23.153846153846153,3,30.333333333333332,5,32.200000000000003,7,28.142857142857142,3,27.833333333333332,3,36.333333333333336]
["LUTTE CONTRE LES MAUVAISES HERBES (coût de l'herbicide non inclus)"]
["Pulvérisateur traîné","acre",17,13.235294117647058,10,15,10.952380952380953,3,14,3,13,6,11.833333333333334,"","","",""]
["Automoteur","acre",70,13.595000000000001,12,15,10.96326530612245,16,13.903124999999999,16,13.15625,24,13.09375,4,16.125,9,14.438888888888888]
["Pulvérisateur enjambeur automoteur","acre",58,14.322413793103449,12,16,10.90625,16,13.496874999999999,10,16.649999999999999,26,14.028846153846153,3,15.166666666666666,"",""]
["Pulvérisation du maïs au stade panicule (grand volume d’eau)","acre",32,16.443750000000001,14,18.699999999999996,13.685416666666667,8,15.99375,5,17.2,15,16.283333333333335,"","","",""]
["ÉPANDAGE D'ENGRAIS"]
["Épandage d’engrais sec","acre",44,13.254545454545456,10.612500000000001,15,10.407999999999999,10,13.094999999999999,10,13.55,15,13.85,4,13,4,12.25]
["Épandage d’engrais sec - pulvérisateur enjambeur","acre",8,15.21875,11.762499999999999,16.95,11.25,"","","","",4,16.4375,"","","",""]
["Location d’un semoir à engrais sec en vrac","tonne",8,18.1875,15,20.95,14,4,16.375,"","",4,20,"","","",""]
["Épandage d’engrais sec en bandes latérales","acre",4,22.375,"","",14.375,"","","","","","","","","",""]
["Épandage d’engrais anhydre","acre",4,13.25,"","",20,"","","","","","","","","",""]
["Épandage d’engrais Liquidee – au sol/en couverture","acre",16,15.590624999999999,13.237500000000001,19.5,11.083333333333334,6,16.158333333333335,3,15.166666666666666,3,17,"","",4,14]
["Épandage d’engrais Liquidee - bandes latérales","acre",25,17.48,14,22,14.952380952380953,13,18.076923076923077,5,18.8,4,16.5,"","",3,14]
["Épandage d’engrais Liquidee, enjambeur/application tardive","acre",14,18.071428571428573,14.95,18.349999999999994,15.328571428571427,"","","","",8,17.5,"","","",""]
["SOL ET CARTOGRAPHIE"]
["Service de cartes de prescription","acre",3,4.666666666666667,"","",3.69,"","","","","","","","","",""]
["Cartographie de l’élévation","acre",3,11,"","","","","","","","","","","","",""]
["Échantillonnage en grille","acre",4,8.75,"","",5.3125,"","","","","","","","","",""]
["MOISSONNAGE-BATTAGE "]
["Maïs","acre",87,65,53.8,75,50.617924528301884,21,63.238095238095241,12,67.083333333333329,35,66.257142857142853,6,57.333333333333336,12,67.833333333333329]
["Maïs avec becs cueilleurs à maïs","acre",49,72.83163265306122,60.4,85,55.089285714285715,5,64.400000000000006,15,71.933333333333337,17,76.57352941176471,"","",10,71.099999999999994]
["Soya","acre",133,64.46616541353383,52,75,50.024822695035461,33,57.909090909090907,24,67.25,50,66.14,7,64.285714285714292,18,69.555555555555557]
["Céréales avec hacheuses","acre",30,66.266666666666666,52.7,83.25,50.521739130434781,8,57.875,6,71.166666666666671,12,69.833333333333329,"","","",""]
["Céréales sans hacheuse","acre",93,65.053763440860209,53.599999999999994,75,49.525641025641029,22,58,21,68.333333333333329,34,66.235294117647058,5,69,11,67.454545454545453]
["Canola","acre",10,68.3,50,91.499999999999986,51,4,58.25,"","",4,86.25,"","","",""]
["Benne à grain seulement","acre",8,6.875,5,7.95,7.5714285714285712,"","","","",4,6.25,"","","",""]
["Benne à grain seulement","heure",7,131.42857142857142,"","",120.2,"","","","",3,140,"","",3,133.33333333333334]
["Transport du champ au silo","tonne",33,9.2181818181818187,6.92,10.199999999999999,8.415909090909091,5,8.1,8,8.4124999999999996,13,9.1230769230769226,3,12.733333333333334,3,9.8666666666666671]
["Transport du champ au silo","tonne impériale",33,8.3801652892561975,6.290909090909091,9.2727272727272716,7.6508264462809903,5,7.3636363636363624,8,7.6477272727272716,13,8.2937062937062933,3,11.575757575757576,3,8.9696969696969688]
["Transport du champ au silo","heure",8,151.875,85.75,246.5,105,"","",3,120,3,211.66666666666666,"","","",""]
["AUTRES TRAVAUX DE RÉCOLTE"]
["Andainage","acre",3,22.333333333333332,"","",22.333333333333332,"","","","","","","","","",""]
["MAÏS GRAIN HUMIDE"]
["Moissonnage-battage et transport jusqu’au silo","acre",11,66.63636363636364,55,79,50,3,54,3,71,"","","","","",""]
["HARICOTS COMESTIBLES"]
["Arrachage des haricots et andainage","acre",3,48.833333333333336,"","",48,"","","","","","","","","",""]
["Récolte avec moissonneuse-batteuse à céréales standard","acre",48,67.6875,55.25,80,54.75,8,58.75,10,72,24,69.833333333333329,4,62.5,"",""]
["Récolte avec moissonneuse-batteuse de type Bob/Lilliston","acre",4,85.75,"","",67.5,"","","","","","","","","",""]
["TRANSPORT"]
["Céréales et oléagineux - local","boisseau",4,0.26,"","",0.13999999999999999,4,0.26,"","","","","","","",""]
["Céréales et oléagineux - local","tonne",60,10.704000000000001,8,13.149999999999999,9.5830882352941149,9,9.1666666666666661,10,9.6739999999999995,26,9.865384615384615,6,14.5,8,13.6875]
["Céréales et oléagineux - local","tonne impériale",60,9.7309090909090905,7.2727272727272725,11.954545454545451,8.711898395721926,9,8.3333333333333339,10,8.7945454545454531,26,8.9685314685314683,6,13.18181818181818,8,12.443181818181817]
["RÉCOLTE DES FOURRAGES - FOIN"]
["Fauchage","acre",8,22.25,20,25,18.90909090909091,"","","","",3,21.666666666666668,"","","",""]
["Fauchage à disques","acre",10,23.2,19.350000000000001,30,19.600000000000001,"","","","",5,19.8,3,26.333333333333332,"",""]
["Fauchage à disques avec conditionneur","acre",16,23.4375,20,25.75,19.685185185185187,3,26.666666666666668,"","",10,22.6,"","","",""]
["Fauchage à disques avec conditionneur","heure",6,177.5,"","",146.4,"","","","","","","","","",""]
["Râtelage","acre",21,13.976190476190476,10,18,12.404761904761905,4,14.5,"","",10,14.3,3,14,"",""]
["Râtelage","heure",3,128.33333333333334,"","",95,"","","","",3,128.33333333333334,"","","",""]
["Fanage","acre",10,15.25,12,21.899999999999991,12.153846153846153,"","","","",5,15.8,"","","",""]
["Regroupement des andains","acre",10,19.600000000000001,15.7,23.949999999999996,15.833333333333334,"","","","",4,19.25,"","",3,20]
["Confection de balles carrées et ramassage","balle",6,1.5166666666666666,"","",1.0166666666666666,"","","","","","","","","",""]
["Confection de grosses balles carrées","pied",17,1.8205882352941176,1.38,2.15,1.5579365079365077,"","",4,2,7,1.6785714285714286,"","",4,2.0499999999999998]
["Confection de grosses balles carrées haute densité","pied",5,2.39,"","",1.7277777777777779,"","","","",3,2.3333333333333335,"","","",""]
["Confection de grosses balles rondes de moins de 1000 lb","balle",11,10,9,11,9.7142857142857135,"","","","",4,9.5,"","","",""]
["Confection de grosses balles rondes de plus de 1000 lb","balle",14,11.321428571428571,9.9499999999999993,14.049999999999999,9.5500000000000007,"","","","",6,10.75,"","","",""]
["Mise en balles des tiges de maïs","balle",6,15.583333333333334,"","",12.375,"","","","",5,15.3,"","","",""]
["ENRUBANNAGE"]
["Individuel - avec plastique","balle",5,13.5,"","",7.25,"","","","","","","","","",""]
["Boudin","balle",11,9.0681818181818183,5.875,11,7.5909090909090908,"","","","",6,8.8333333333333339,4,9.1875,"",""]
["PAILLE ",null,null,null,null,null,null,"","","","","","","","","",""]
["Confection de grosses balles carrées","pied",9,2.1222222222222218,1.83,2.4700000000000002,"","","","","",4,2.0375000000000001,"","","",""]
["Confection de grosses balles rondes","balle",9,11.055555555555555,8.4,12.8,10,"","","","",6,9.9166666666666661,"","","",""]
["ENSILAGE"]
["Récolteuse automotrice/ramassage/soufflage ou compactage","heure",8,804.375,556.25,998.5,606.66666666666663,"","","","","","","","","",""]
["Récolteuse automotrice seulement","heure",9,655,510,700,455.625,"","",3,615,3,616.66666666666663,"","","",""]
["Ramassage seulement – camions","heure",4,126.25,"","",141.66666666666666,"","","","","","","","","",""]
["Ramassage seulement - remorques","heure",7,138.57142857142858,"","",149.28571428571428,"","","","","","","","",3,138.33333333333334]
["Compactage seulement","heure",5,169.5,"","",162.85714285714286,"","",3,174.16666666666666,"","","","","",""]
["Soufflage seulement","heure",3,111.66666666666667,"","","","","","","","","","","","",""]
["ENSILAGE DE MAÏS"]
["Récolteuse automotrice/ramassage/soufflage ou compactage","heure",4,996.25,"","",670,"","","","","","","","","",""]
["Récolteuse automotrice seulement","heure",6,685.83333333333337,"","",529,"","","","","","","","","",""]
["Récolteuse automotrice avec conditionneur de grains seulement","heure",8,634.375,500,769,477,"","","","","","","","","",""]
["Ramassage seulement – camions","heure",4,141.25,"","","","","","","","","","","","",""]
["Ramassage seulement - remorques","heure",6,134.16666666666666,"","",155.83333333333334,"","","","","","","","",3,138.33333333333334]
["Compactage seulement","heure",6,163.33333333333334,"","",155,"","","","",3,180,"","","",""]
["Soufflage seulement","heure",3,81.666666666666671,"","",75,"","","","","","","","","",""]
["MANUTENTION DES FUMIERS - FUMIER COMPLET (SOLIDE) "]
["Chargement seulement","heure",12,113.33333333333333,75,158.75,113.07692307692308,"","","","",7,118.57142857142857,"","","",""]
["Épandage seulement","heure",13,135.57692307692307,62,221,138.88888888888889,"","",4,173.75,5,142,"","","",""]
["Chargement et épandage","heure",10,237.5,157.25,303.99999999999989,220,"","","","",6,239.16666666666666,"","","",""]
["MANUTENTION DES FUMIERS - LISIER (FUMIER LIQUIDE)      "]
["Aspersion par canon      "," 1 000 gallons impériale",12,15,14,16.5,12.744545454545456,"","","","",5,14.6,"","",3,14]
["Camion-citerne – application en surface seulement"," 1 000 gallons impériale",5,13,"","",12.25,"","","","","","","","","",""]
["Tonne - épandage seulement","heure",11,311.36363636363637,237.5,400,243.125,"","","","","","","","","",""]
["Transport par camion","heure",5,213,"","",160,"","","","",3,208.33333333333334,"","","",""]
["Frais additionnel pour sable"," 1 000 gallons impériale",7,1.9214285714285713,"","",2.8875000000000002,"","","","",4,2.25,"","","",""]
["Agitation de pompe en fosse","heure",9,177.77777777777777,146,196,73.020833333333329,"","","","",6,191.66666666666666,"","","",""]
["Agitation de pompe en fosse","jour",4,300,"","",null,"","","","","","","","","",""]
["Remorque à fumier","heure",5,401,"","",357,"","","","",3,418.33333333333331,"","","",""]
["DIVERS"]
["Déneigement - chasse-neige","heure",12,190,141.25,277.25,142.18181818181819,"","","","",9,206.66666666666666,"","","",""]
["Déneigement - souffleuse","heure",16,156.5625,90,231.25,139.57142857142858,3,125,"","",8,190.625,"","","",""]
["Location de tracteurs","heure",10,98.9,51.4,141.24999999999997,116,"","","","",6,83.166666666666671,"","","",""]
["Location de tracteurs","puissance.heure",5,0.41799999999999998,"","",0.39833333333333337,"","","","",3,0.43,"","","",""]