{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Informations","Saisie des poids","schéma tracteur","Calcul tracteur caravane","Résultat_H","Rapport_tracteur","bilan des opérations","Compilation des données","avertisement","Batteuse Chenille","Batteuse Roue","Résumé batteuse","Poids-puissance","Références","Charge","Balancement","Feuil1","tableau résumé","calcul des réservoirs","% glissement","résumé tracteur","résumé machinerie","Impression"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":1,"defined_names":18,"comments":2,"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":"Informations","index":0,"n_rows":48,"n_cols":25,"rows_kept":48,"cut":false,"hidden":false,"merged":[[57,14,58,14],[54,2,55,2],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6]]}
["Bonjour ","Vous êtes le seul responsable des ajustements, donnez-vous une sécurité."]
[]
["Ce fichier est un outil pour vous aider à faire le balancement du tracteur et choisir la bonne pression des pneus."]
["Vous entrez les données dans l'onglet Saisie des poids,  la puissance, les poids et l'empattement déportance avant et arrière. "]
["Validez le tout dans schéma de tracteur et complétez les données manquantes"]
["Visualisez les différents calculs dans l'onglet Calcul tracteur caravane.",null,null,null,null,null,null,null,null,"Date:","2024-01-30"]
["L'onglet Rapport de tracteur est conçu pour avoir un rapport détaillé des différentes simulations."]
[null,null,null,null,null,null,"Identifiez votre club pour que le nom et l'adresse soient sur le rapport"]
[null,null,null,null,null,null,null,null,null,"Nom du Club","Votre club"]
["EXPLICATION DES ONGLETS",null,null,null,"Données physiques",null,null,null,null,"Adresse"]
["Dans l'onglet schéma de tracteur",null,null,null,"Données calculées",null,null,null,null,"Ville"]
["Les calculs se font sous l'onglet calcul tracteur caravane",null,null,null,"Données des chartes",null,null,null,null,"Code postal"]
[null,null,null,null,"Objectif",null,null,null,null,"Nom du conseiller","Bruno Garon, ing"]
[null,null,null,null,null,null,null,null,null,"No de téléphone","450-779-2669"]
["Une fois les différentes données entrées vous pouvez mettre les simulations en rapport",null,null,null,null,null,null,null,null,"Nom de l'entreprise"]
["Cliquez sur rapport tracteur et cliquer sur la disquette",null,null,null,null,null,null,null,null,"Nom du producteur"]
["Revenez sur schéma tracteur et faites une nouvelle simulation et recommencez.",null,null,null,null,null,null,null,null,"Ville"]
["À la fin d'une simulation, cliquez sur la disquette et vous pouvez faire imprimer le rapport en faisant la mise en page qui sera différente selon vos simulations."]
["Vous avez sur l'onglet Charge les Kg/ Hp ou Lb/Hp pour un poids idéal selon la puissance du tracteur"]
["Assurez-vous de valider le rayon sous charge, voir les chartes de pneus"]
[]
["Conception Bruno Garon ing. MAPAQ Montérégie-Est"]
["Version",{"$f":"K6","v":"2024-01-30"}]
["Onglet","Voir plus bas"]
["Saisie des poids","Pour faire la saisie et diminuer le risque d'erreur un nouvel onglet et le tout se place dans schéma tracteur Merci François Cadrin"]
["Schéma de tracteur","Le reste des infos à entrer pour la simulation"]
["Calcul tracteur caravane","Tous les calculs expliqués"]
["Rapport tracteur","Résume les simulations ou l'ensemble des équipements poour ce tracteur"]
["Bilan des opérations","Cette page donne les recommandations pour un tracteur et quelques équipements"]
["Poids puissance","Calcul de la charge idéale selon l'opération sert plus avec les équipements trainés"]
["Références","Ce sont plusieurs références qui ont servi à la conception de ce fichier et les chartes de plusieurs compagnies de pneus."]
["Charges","Vous donnez de l'information sur la charge à mettre sur un tracteur"]
["Balancement","Vous donnez la réparation idéale du tracteur, il y a quelques variations que l'on retrouve dans les manuels d'opérateurs"]
[null,"Les autres Onglets sont pour mon besoin personnel."]
["Résultat-H","Donne le résultat en format horizontale"]
["Compilation des données","Compile toutes les données, remplissez l'onglet Schéma de tracteur et information "]
["Batteuse roue","Calcul  la charge pour une batteuse à roues en conception"]
["Batteuse à chenille","Calcul  la charge pour une batteuse à chenille en conception"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W42*1.2","v":0},null,0.2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,"894 mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,"894 mm"]

{"sheet":"Saisie des poids","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[63,14,64,14],[60,2,61,2],[1,1,1,2]]}
["Complétez les cellules selon le poids des balances."]
["Tracteur :",null,null,"Modèle"]
["Puissance",null,"HP","Avant",null,null,"Total"]
[]
["Vide, bas",null,null,null,null,null,{"$f":"SUM(B5:F5)","v":0},2365]
["Plein, haut",null,null,null,null,null,{"$f":"SUM(B6:F6)","v":0}]
[]
[null,null,null,null,null,null,"À valider"]
[null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,"Déportance avant"]
[]
[null,null,null,null,null,null,null,"m"]
[null,null,null,null,null,null,"Empattement"]
[]
[]
[null,null,null,null,null,null,"À valider"]
[null,null,null,null,null,null,"Déportance arrière"]
[null,null,null,null,null,null,null,"m"]
["Vide, bas ",null,null,null,null,null,{"$f":"SUM(B19:F19)","v":0},3235]
["Plein, haut",null,null,null,null,null,{"$f":"SUM(B20:F20)","v":0}]
[null,null,null,"Arrière",null,null,null,";"]

{"sheet":"schéma tracteur","index":2,"n_rows":87,"n_cols":39,"rows_kept":87,"cut":false,"hidden":false,"merged":[[69,1,70,2],[69,4,70,4],[69,6,70,6],[60,9,61,9],[60,10,61,10],[62,9,63,9],[62,10,63,10],[64,9,65,9],[64,10,65,10],[66,9,67,9],[66,10,67,10],[69,9,70,9],[69,10,70,10],[64,1,65,2],[66,1,67,2],[64,4,65,4],[66,4,67,4],[60,6,61,6],[62,6,63,6],[64,6,65,6],[31,0,32,0],[62,12,63,12],[64,12,65,12],[66,12,67,12],[66,6,67,6],[62,4,63,4],[62,1,63,2],[62,3,63,3],[39,1,40,1],[39,9,40,10],[49,12,49,14],[48,12,48,14],[36,10,37,12],[30,8,31,8],[58,14,59,14],[66,14,67,14],[60,12,61,12],[33,9,34,10],[60,1,61,2],[60,4,61,4],[52,12,52,14],[57,2,58,2],[39,6,40,7],[53,4,53,6],[16,1,17,2],[19,1,20,2],[44,4,44,6],[31,1,32,1],[49,4,49,6],[33,1,34,1],[36,4,37,4],[43,17,43,19],[36,13,37,13],[36,14,37,14],[33,18,34,18],[19,3,20,3],[16,4,17,4],[43,4,43,6],[16,3,17,3],[36,5,37,5],[19,4,20,4],[30,6,31,7],[36,6,37,6],[24,4,25,4],[33,6,34,7],[27,2,27,4],[27,5,27,6],[28,2,28,4],[2,35,3,35],[20,8,20,9],[13,22,13,24],[17,9,18,9],[7,22,7,24],[10,22,10,24],[16,24,17,25],[16,23,17,23],[16,21,17,22],[17,8,18,8],[7,2,7,4],[9,2,9,4],[11,2,11,4],[30,9,31,10],[8,22,8,24],[9,22,9,24],[24,19,25,19],[21,9,22,9],[25,11,26,11],[25,15,26,15],[21,19,22,19],[30,21,31,22],[27,11,28,11],[27,12,28,12],[27,15,28,15],[27,16,28,16],[11,22,11,24],[25,12,26,12],[25,16,26,16],[28,5,28,6],[20,24,21,24],[18,24,19,25],[21,18,22,18],[8,2,8,4],[27,25,27,26],[48,22,48,24],[33,21,34,22],[33,19,34,19],[39,19,40,19],[36,20,37,20],[36,21,37,21],[28,25,28,26],[69,12,70,12],[39,21,40,22],[30,18,31,18],[52,22,52,24],[53,12,53,14],[53,22,53,24],[27,22,27,24],[66,16,67,16],[66,17,67,17],[66,19,67,19],[67,21,68,21],[60,19,61,19],[60,21,61,21],[62,14,63,14],[62,16,63,16],[62,17,63,17],[54,4,54,6],[54,12,54,14],[54,22,54,24],[45,17,45,19],[50,22,50,24],[50,12,50,14],[33,8,34,8],[28,22,28,24],[49,22,49,24],[30,19,31,19],[36,19,37,19],[50,4,50,6],[62,21,63,21],[64,14,65,14],[64,16,65,16],[64,17,65,17],[64,19,65,19],[64,21,65,21],[60,16,61,16],[60,17,61,17],[60,14,61,14]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"Tracteur"]
[null,null,"Puissance","P",{"$f":"'Saisie des poids'!B3","v":0},null,"Hp","Validez le HP PDF",null,null,null,null,null,null,null,null,null,{"$f":"'Saisie des poids'!B2","v":0},null,null,null,"données physiques","ext",null,"Herse"]
[null,null,null,null,{"$f":"IF(E2=0,\"\",E2*0.746)","v":""},null,"KW",null,null,null,null,null,null,null,null,null,null,null,null,"Pression avant gauche",null,null,null,null,null,null,null,null,null,null,"typeatt",null,null,null,null,"Tracteurs","    Trainé","   Semi-porté","      Porté"]
[null,null,null,null,null,null,null,null,null,"Maximum",null,null,null,null,null,null,null,null,null,"Pression avant droit",null,null,null,null,null,null,null,null,null,null,"2 roues",1,null,null,null,null,"Avant/arrière","Avant/arrière","Avant/arrière"]
[null,null,null,null,"Rapport",null,{"$f":"IF(E2=0,\"\",'Calcul tracteur caravane'!H29)","v":""},"Kg/HP",null,72.5,null,null,null,null,null,null,null,null,null,"Pression arrière gauche",null,null,null,null,null,null,null,null,null,null,"2 + 2",2,null,null,null,"2 roues","25 / 75 %","30 / 70 %","35 / 65%"]
[null,null,null,null,"Charge/puissance ",null,{"$f":"IF(E2=0,\"\",'Calcul tracteur caravane'!H30)","v":""},"Lb/HP",null,145,null,null,null,null,null,null,null,null,null,"Pression arrière droit",null,null,null,null,null,null,null,null,null,null,"4 roues",3,null,null,null,"2 + 2 ","35 / 65 %","35 / 65 %","40 / 60 %"]
[null,null,null,null,"Plein",null,{"$f":"IF(V40=\"\",\"\",'Calcul tracteur caravane'!J30)","v":""},"Lb/Hp",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"typeatt",null,1,2,3,"4 roues","55 / 45 %","55 / 45 %","60 / 40 %"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom de l'entreprise",null,{"$f":"IF(E2=0,\"\",Informations!K15)","v":""},null,null,"Données physiques",null,null,null,null,null,null,null,"aucun",1,"n/a","n/a","n/a"]
[null,"Type de tracteur","2 + 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom du producteur",null,{"$f":"IF(E2=0,\"\",Informations!K16)","v":""},null,null,null,null,null,null,null,null,null,null,"Portée",2,65,60,40]
[null,"Type équipement","Trainé",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ville",null,{"$f":"Informations!K17","v":0},null,null,"Données calculées",null,null,null,null,null,null,null,"semi portée",3,70,65,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Essai no :",null,1,null,null,null,null,null,null,null,null,null,null,"Trainé",4,75,65,45]
[null,"Description équipement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tracteur no :",null,{"$f":"'Saisie des poids'!B2","v":0},null,null,"Choix dans les chartes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"remarque",null,{"$f":"'Saisie des poids'!E2","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(C9,type,2,FALSE)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"remarque",null,null,null,null,"Objectif",null,null,null,null,null,null,null,{"$f":"VLOOKUP(C10,typeatt,2,FALSE)","v":4}]
[null,null,null,-2500]
[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,{"$f":"INDEX(typeatt,AE14,AE13+2)","v":65}]
[null,"Poids équipement plein",null,"e",null,null,null,null,null,null,null,null,null,null,null,null,"Les poids sont en Kg",null,null,null,null,"Poids équipement",null,1250,null,null,45]
[null,null,null,null,null,null,null,null,"c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,",",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Description de l'équipement"]
[null,"Poids équipement à vide",null,"e1",null,null,null,null,null,"Poids ajouté"]
[null,null,null,null,null,null,null,null,"Objectif",null,null,null,null,null,null,null,null,null,null,null,null,null,"Type de roues",null,"Simple"]
[null,null,null,null,",",null,null,null,null,{"$f":"AE16","v":65},null,null,null,null,null,null,null,null,"i",null,null,null,null,null,null,null,null,null,null,null,null,"Simple"]
[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,"Double"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Répartition",null,null,null,"Répartition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Triple"]
[null,null,"Type de roues",null,"Simple",null,null,null,null,null,null,null,"Arrière",null,null,null,"Avant",null,null,{"$f":"100-J22","v":35}]
[null,null,null,null,null,null,null,null,null,null,"Vide","x",{"$f":"IF(P1=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!H27))","v":""},null,null,"y",{"$f":"IF(P1=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!H28))","v":""}]
[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,22]
[null,"Type de pneu",null,null,null,null,null,null,null,null,"Plein","x",{"$f":"IF(M34=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!J27))","v":""},null,null,"y",{"$f":"IF(Q34=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!J28))","v":""},null,null,null,null,"Type de pneu",null,null,null,null,null,null,null,null,null,45]
[null," arrière",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"avant",null,null,null,null,null,null,null,null,null,{"$f":"AF27*AF28","v":990}]
[null,null,null,null,null,null,null,{"$f":"G31/4","v":{"$error":"#VALUE!"}},null,"Poids Essieu",null,null,"Int",null,"ext",null,"int","ext",null,"Poids Essieu"]
[null,null,null,null,null,null,{"$f":"IF(P1=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!H24))","v":""},null,"b",{"$f":"IF(P1=0,\"\",IF(M31=0,\"\",M31+M32+O31+O32))","v":""},null,"G",{"$f":"'Saisie des poids'!C19","v":0},null,{"$f":"'Saisie des poids'!B19","v":0},null,{"$f":"'Saisie des poids'!C5","v":0},{"$f":"'Saisie des poids'!B5","v":0},null,{"$f":"IF(P1=0,\"\",IF(Q31=0,\"\",Q31+Q32+R31+R32))","v":""},null,{"$f":"IF(P1=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!H25))","v":""}]
["W",{"$f":"IF(P1=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!H26))","v":""},null,null,"Vide, bas",null,null,null,null,null,null,"D",{"$f":"'Saisie des poids'!E19","v":0},null,{"$f":"'Saisie des poids'!F19","v":0},null,{"$f":"'Saisie des poids'!E5","v":0},{"$f":"'Saisie des poids'!F5","v":0}]
[null,null,null,null,null,null,null,null,null,"Poids essieu",null,null,null,null,null,null,null,null,null,"Poids essieu"]
[null,{"$f":"IF(M34=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!J26))","v":""},null,null,"Plein Haut",null,{"$f":"IF(M34=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!J24))","v":""},null,"b",{"$f":"IF(P1=0,\"\",IF(M34=0,\"\",M34+M35+O34+O35))","v":""},null,null,{"$f":"'Saisie des poids'!C20","v":0},null,{"$f":"'Saisie des poids'!B20","v":0},null,{"$f":"'Saisie des poids'!C6","v":0},{"$f":"'Saisie des poids'!B6","v":0},null,{"$f":"IF(P1=0,\"\",IF(Q34=0,\"\",Q34+Q35+R34+R35))","v":""},null,{"$f":"IF(P1=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!J25))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Saisie des poids'!E20","v":0},null,{"$f":"'Saisie des poids'!F20","v":0},null,{"$f":"'Saisie des poids'!E6","v":0},{"$f":"'Saisie des poids'!F6","v":0}]
[null,"Poids total"]
[null,null,null,null,"Distance en m","f",{"$f":"'Saisie des poids'!G18","v":0},null,null,null,null,null,null,"a",{"$f":"'Saisie des poids'!G12","v":0},null,null,null,null,null,"l",{"$f":"'Saisie des poids'!G9","v":0}]
[]
[]
[null,{"$f":"IF(J40=\"\",\"\",B34-B32)","v":""},{"$f":"IF(B40=\"\",\"\",G40-T40)","v":""},null,null,null,{"$f":"IF(G34=\"\",\"\",G34-G31)","v":""},null,null,{"$f":"IF(J34=\"\",\"\",J34-J31)","v":""},null,null,"poids de plus en arrière",null,null,null,null,"poids en moins",null,{"$f":"IF(V40=\"\",\"\",T31-T34)","v":""},null,{"$f":"IF(V34=\"\",\"\",V31-V34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"en avant",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC41-AB41","v":0},{"$f":"AC40-AB41","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,{"$f":"AB42-AC42","v":0},{"$f":"AB42-(AD42/AD41*AE41)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,"kg","lb",null,0.34,null,null,null,null,null,null,null,null,null,"kg",null,"lb",null,null,null,null,{"$f":"AB43-AC43","v":0},{"$f":"AB43-(AD43/AD41*AE41)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Poids pneu arrière vide, bas",null,null,"Par",null,{"$f":"IF(P1=0,\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!H35))","v":""},{"$f":"IF(J31=\"\",\"\",J44*2.2)","v":""},null,{"$f":"J44/(1+M43)","v":{"$error":"#VALUE!"}},null,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        ",null,null,"Vide, bas             Poids pneu avant",null,null,null,"Pav",{"$f":"IF(E2=0,\"\",'Calcul tracteur caravane'!H36)","v":""},null,null,0.34,null,null,null,null,{"$f":"AE43-AE42","v":{"$error":"#DIV/0!"}},{"$f":"AA44/AE44*AE45+AA42","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Poids pneu arrière plein, Haut",null,null,"Par",null,{"$f":"IF(J40=\"\",\"\",IF(E2=0,\"\",'Calcul tracteur caravane'!J35))","v":""},{"$f":"IF(J34=\"\",\"\",J45*2.2)","v":""},null,{"$f":"IF(J45=\"\",\"\",J45/1.34)","v":""},null,null,null,null,null,null,"À  vide",null,"Pav",{"$f":"IF(E2=0,\"\",'Calcul tracteur caravane'!I36)","v":""},null,{"$f":"IF(T31=\"\",\"\",W45*2.2)","v":""},{"$f":"W45/(1+Z44)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"AC44-AE42","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plein, haut            Poids pneu avant",null,null,null,"Pav",{"$f":"IF(V40=\"\",\"\",'Calcul tracteur caravane'!J36)","v":""},null,null,null,null,null,null,null,null,{"$f":"AF44*14.5","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"À  vide",null,"Pav",{"$f":"IF(V40=\"\",\"\",'Calcul tracteur caravane'!K36)","v":""},null,{"$f":"IF(T34=\"\",\"\",W47*2.2)","v":""}]
[null,null,null,null,"Pas équilibré",null,null,null,null,null,null,null,"sans sécurité",null,null,null,null,null,null,null,null,null,"sans sécurité",null,null,null,null,31.1]
[null,null,null,null,"Vitesse",null,"km/h",10,null,"km/h",30,null,"Rayon minimum",null,null,null,null,"Pas équilibré",null,10,null,30,"Rayon minimum",null,null,null,null,25.4]
[null,null,null,null,"Pression en PSI arrière int",null,null,null,null,null,null,null,null,null,null,null,null,"pression avant Psi int",null,null,null,null,null,null,null,null,null,{"$f":"AB48*AB49","v":789.93999999999994}]
[null,null,null,null,"Pression en PSI arrière ext",null,null,null,null,null,null,null,null,null,null,null,null,"pression avant Psi ext"]
[null,null,null,null,"Équilibré",null,null,null,null,null,null,null,"sans sécurité",null,null,null,null,null,null,null,null,null,"sans sécurité"]
[null,null,null,null,"Vitesse",null,"km/h",{"$f":"H49","v":10},null,"km/h",{"$f":"K49","v":30},null,"Rayon minimum",null,null,null,null,"Équilibré",null,{"$f":"T49","v":10},null,{"$f":"V49","v":30},"Rayon minimum"]
[null,null,null,null,"Pression en PSI arrière int",null,null,null,null,null,null,null,null,null,null,null,null,"pression avant Psi int"]
[null,null,null,null,"Pression en PSI arrière ext",null,null,null,null,null,null,null,null,null,null,null,null,"pression avant Psi ext"]
[]
[]
[null,null,"Catégorie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Compagnie"]
[null,null,null,null,"Vide G",null,"Vide D",null,null,"Plein G","Plein D",null,"Essieu",null,null,null,"Pneu","Indice de charge",null,"Rayon sous charge",null,"Psi"]
[null,"Réservoir essieu 1",null,null,null,null,null,null,null,null,null,null,{"$f":"J61+K61","v":0}]
[]
[null,"Réservoir essieu 2",null,null,null,null,null,null,null,null,null,null,{"$f":"J63+K63","v":0}]
[]
[null,"Réservoir essieu 3",null,null,null,null,null,null,null,null,null,null,{"$f":"J65+K65","v":0}]
[]
[null,"Réservoir essieu 4",null,null,null,null,null,null,null,null,null,null,{"$f":"J67+K67","v":0}]
[]
[]
[null,"Réservoir essieu total",null,null,{"$f":"+SUM(E61:E68)","v":0},null,{"$f":"+SUM(G61:G68)","v":0},null,null,{"$f":"+SUM(J61:J68)","v":0},{"$f":"+SUM(K61:K68)","v":0},null,{"$f":"+SUM(M61:M68)","v":0}]
[]
[null,"Total",{"$f":"IF(E61=0,\"\",M72-G72)","v":""},null,null,null,{"$f":"+G70+E70","v":0},null,null,null,null,null,{"$f":"M70","v":0}]
[null,null,"Différence"]
[null,"Liquide pour réservoir",null,null,"Liquide tracteur",null,null,"Liquide sur réservoir"]
[null,null,null,null,{"$f":"B40","v":""},"kg",null,{"$f":"IF(E61=0,\"\",M72-G72)","v":""},null,{"$f":"IF(E75=\"\",\"\",H75+E75)","v":""}]
[null,null,"Volume",null,5250,null,{"$f":"IF(E76=0,\"\",E76*10/2.2)","v":23863.63636363636},null,null,{"$f":"IF(E75=\"\",\"\",G76-J75)","v":""}]
[null,null,null,null,"gallon",null,"kg de liquide ",null,null,null,null,null,null,null,"Source agri réseau"]
[null,"Transbordeur","Poids Kg/m3",null,null,null,null,null,null,null,null,null,"A_Choisir",null,"kg/m3",2000]
[null,"Maïs:",{"$f":"VLOOKUP(B79,Choisir,3)","v":800},null,"Poids du grain",null,null,null,null,null,null,null,"Avoine:",{"$f":"P76*0.5","v":0},500]
[null,null,"Total",null,"Transbordeur",null,"Sur barre",null,null,"m3",null,null,"Blé:",{"$f":"P75*0.84","v":0},840]
[null,null,{"$f":"IF(B85=0,\"\",E81+G81)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B85=0,\"\",M72-E712)","v":0},null,{"$f":"B40","v":""},null,null,{"$f":"IF(B85=0,\"\",C81/C79)","v":{"$error":"#VALUE!"}},"m3",null,"Canola:",{"$f":"P73*0.8","v":0},800]
[null,"Donc pas plein",null,null,null,null,null,null,null,{"$f":"IF(B85=0,\"\",J81*35.3)","v":{"$error":"#VALUE!"}},"pi3",null,"Maïs:",{"$f":"P73*0.8","v":0},800]
[null,"si",null,null,null,null,null,null,null,{"$f":"IF(B85=0,\"\",J82/1.25)","v":{"$error":"#VALUE!"}},"bo",null,"Orge:",{"$f":"P79*0.65","v":0},650]
[null,"nb bo","kg",null,null,null,null,null,null,null,null,null,"Pois:",{"$f":"P78*0.82","v":1640},820]
[null,3000,{"$f":"IF(B85=0,\"\",B85*1.25/35.3*C79)","v":84985.835694050998},null,null,null,null,null,null,null,null,null,"Sarrasin:",{"$f":"P75*0.67","v":0},670]
[null,56,null,null,null,null,null,null,null,null,null,null,"Soya:",{"$f":"P79*0.78","v":0},780]
[null,{"$f":"B85*B86","v":168000},{"$f":"B87/2.2","v":76363.636363636353}]

{"sheet":"Calcul tracteur caravane","index":3,"n_rows":62,"n_cols":25,"rows_kept":62,"cut":false,"hidden":false,"merged":[[60,14,61,14],[57,2,58,2],[0,0,0,1],[0,4,0,7],[38,5,38,7],[39,5,39,7],[40,5,40,7],[22,4,22,6],[33,4,33,6],[41,5,41,7],[37,9,37,12],[37,4,37,6],[17,4,17,6],[30,0,30,2],[36,5,36,7]]}
["Données physiques",null,null,{"$f":"IF('schéma tracteur'!F1=\"\",\"\",+'schéma tracteur'!F1)","v":""},"Données calculées "]
["Puissance HP","P",{"$f":"IF('schéma tracteur'!E2=\"\",\"\",+'schéma tracteur'!E2)","v":0},null,null,null,"kW",{"$f":"IF(C2=\"\",\"\",+C2*0.746)","v":0}]
["Données arrière",null,"Vide","Plein"]
["Empattement  (m)","a",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!O37)","v":0}]
["Poids arrière (kg)","b",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!J31)","v":""},{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!J34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,3000,{"$f":"H14","v":{"$error":"#VALUE!"}},{"$f":"R5/R7*100","v":{"$error":"#VALUE!"}}]
["Poids roues (kg)","c",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!J18)","v":0},{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!J18)","v":0},null,null,null,"Vide",null,"Plein",null,null,null,null,null,null,null,{"$f":"H7","v":{"$error":"#VALUE!"}},{"$f":"R6/R7*100","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Poids arrière (kg)","d","=  b + c",{"$f":"IF(C2=\"\",\"\",+C5+C6)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D5=\"\",\"\",D5+D6)","v":""},null,null,null,null,null,null,null,{"$f":"R5+R6","v":{"$error":"#VALUE!"}}]
["Poids déporté (kg)","e",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!E17)","v":0}]
["déportance (m)","f",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!G37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
["Poids déporté à vide","e1",{"$f":"IF(C2=\"\",\"\",'schéma tracteur'!E20)","v":0},null,"Rapport arrière","g","= f / a",{"$f":"IF(C2=\"\",\"\",+C9/C4)","v":{"$error":"#DIV/0!"}},null,{"$f":"H10","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,65]
["Données avant",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5+Q5","v":{"$error":"#VALUE!"}},{"$f":"R11/R13*100","v":{"$error":"#VALUE!"}}]
["Poids avant (kg)","h",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!T31)","v":""},{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!T34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R6","v":{"$error":"#VALUE!"}},{"$f":"R12/R13*100","v":{"$error":"#VALUE!"}}]
["Poids roues (kg)","i",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!T22)","v":0},{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!T22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R11+R12","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Poids avant (kg)","j "," = i +h",{"$f":"IF(C2=\"\",\"\",+C12+C13)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(D12=\"\",\"\",D12+D13)","v":""}]
["Poids déporté (kg)","k",{"$f":"IF(C2=\"\",\"\",'schéma tracteur'!Y17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5","v":{"$error":"#VALUE!"}},1,1]
["déportance (m)","l",{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!V37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,"rapport avant","m","= l / a",{"$f":"IF(C2=\"\",\"\",+C16/C4)","v":{"$error":"#DIV/0!"}},{"$f":"H20-H21","v":{"$error":"#DIV/0!"}},{"$f":"H17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Calcul du poids de transfert avant et arrière",null,null,null,"à vide",null,"à vide"]
[null,null,null,null,"Poids en moins sur les roues arrière (kg)","q","= k * m",{"$f":"IF(C2=\"\",\"\",+C15*H17)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C2=\"\",\"\",+C15*J17)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Poids en plus sur les roues arrière (kg)","r","= e + ( e * g )",{"$f":"IF(C2=\"\",\"\",+C8+(C8*H10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C2=\"\",\"\",+C10+(C10*H10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C2=\"\",\"\",+C8+(C8*J10))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C2=\"\",\"\",+C10+(C10*H10))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Poids en moins sur les roues avant (kg)","s","= e * g",{"$f":"IF(C2=\"\",\"\",+C8*H10)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C2=\"\",\"\",+C10*H10)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C2=\"\",\"\",+C8*J10)","v":{"$error":"#DIV/0!"}},{"$f":"IF(C2=\"\",\"\",+C10*H10)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Poids en plus sur les roues avant (kg)","t","= k + ( k * m )",{"$f":"IF(C2=\"\",\"\",+C15+(C15*H17))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(C2=\"\",\"\",+C15+(C15*J17))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Calcul du poids et de la répartition"]
[null,null,null,null,"Poids total arrière (kg)","u","= d + r - q",{"$f":"IF(C2=\"\",\"\",+H7+H20-H19)","v":{"$error":"#VALUE!"}},{"$f":"IF(C2=\"\",\"\",+H7+I20-H19)","v":{"$error":"#VALUE!"}},{"$f":"IF(J7=\"\",\"\",+J7+J20-J19)","v":""},{"$f":"IF(J7=\"\",\"\",+J7+K20-J19)","v":""}]
[null,null,null,null,"Poids total avant (kg)","v","= j + t - s",{"$f":"IF(C2=\"\",\"\",+H14+H22-H21)","v":{"$error":"#VALUE!"}},{"$f":"IF(C2=\"\",\"\",+H14+H22-I21)","v":{"$error":"#VALUE!"}},{"$f":"IF(J14=\"\",\"\",+J14+J22-J21)","v":""},{"$f":"IF(J14=\"\",\"\",+J14+J22-K21)","v":""}]
[null,null,null,null,"Poids total (kg)","w","= u + v",{"$f":"IF(C2=\"\",\"\",+H24+H25)","v":{"$error":"#VALUE!"}},{"$f":"IF(C2=\"\",\"\",I24+I25)","v":{"$error":"#VALUE!"}},{"$f":"IF(J24=\"\",\"\",+J24+J25)","v":""},{"$f":"IF(J24=\"\",\"\",K24+K25)","v":""}]
[null,null,null,null,"Répartition arrière","x","= u / w * 100",{"$f":"IF(C2=\"\",\"\",+H24/H26*100)","v":{"$error":"#VALUE!"}},{"$f":"IF(C2=\"\",\"\",+I24/I26*100)","v":{"$error":"#VALUE!"}},{"$f":"IF(J24=\"\",\"\",+J24/J26*100)","v":""},{"$f":"IF(J24=\"\",\"\",+K24/K26*100)","v":""}]
[null,null,null,null,"Répartition avant","y","= v / w * 100",{"$f":"IF(C2=\"\",\"\",+H25/H26*100)","v":{"$error":"#VALUE!"}},{"$f":"IF(C2=\"\",\"\",+I25/I26*100)","v":{"$error":"#VALUE!"}},{"$f":"IF(J24=\"\",\"\",+J25/J26*100)","v":""},{"$f":"IF(J24=\"\",\"\",+K25/K26*100)","v":""}]
[null,null,null,null,"Charge/puissance (kg/HP)","z ","= w / p",{"$f":"IF(C2=\"\",\"\",+H26/C2)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(J24=\"\",\"\",+J26/C2)","v":""}]
[null,null,null,null,"Charge/puissance  (lb/HP)","z1","= z * 2,2",{"$f":"IF(C2=\"\",\"\",+H29*2.2)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(J24=\"\",\"\",+J29*2.2)","v":""}]
["Constante R pour calculer la charge par pneu"]
["1) Si roue simple",null,"2"]
["2) Si roue double",null,"4 / 0,88"]
["3) Si roue triple",null,"6 / 0,82",null,"Calcul du poids par pneu",null,null,null,null,null,null,null,1]
["Choix avant",{"$f":"IF(A44=\"simple\",1,IF(A44=\"double\",2,3))","v":1},null,null,"Poids par pneu arrière (kg)","Poids arr","=  u / R ",{"$f":"IF(C2=\"\",\"\",IF(B36=1,H24/2,IF(B36=2,H24/4/0.88,H24/6/0.82)))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(J24=\"\",\"\",IF(B36=1,J24/2,IF(B36=2,J24/4/0.88,J24/6/0.82)))","v":""},null,null,2]
["Choix arrière",{"$f":"IF(A45=\"simple\",1,IF(A45=\"double\",2,3))","v":1},null,null,"Poids par pneu avant (kg)","Poids avant","=  v / R ",{"$f":"IF(C2=\"\",\"\",IF(B35=1,H25/2,IF(B35=2,H25/4/0.88,H25/6/0.82)))","v":{"$error":"#VALUE!"}},{"$f":"IF(C2=\"\",\"\",IF(B35=1,I25/2,IF(B35=2,I25/4/0.88,I25/6/0.82)))","v":{"$error":"#VALUE!"}},{"$f":"IF(J24=\"\",\"\",IF(B35=1,J25/2,IF(B35=2,J25/4/0.88,J25/6/0.82)))","v":""},{"$f":"IF(J24=\"\",\"\",IF(B35=1,K25/2,IF(B35=2,K25/4/0.88,K25/6/0.82)))","v":""},null,3]
[null,null,null,null,null,"Aller dans une charte avec ce poids et la vitesse d'opération pour trouver la pression du pneu"]
[null,null,null,null,"Vérification dans les chartes de compagnies de la pression et du rayon minimum chargé"]
[null,null,null,null,"Pression arrière psi ou kPa",{"$f":"'schéma tracteur'!K50","v":0}]
[null,null,null,null,"Pression avant psi ou kPa",{"$f":"'schéma tracteur'!V50","v":0}]
["Page",null,null,null,"Rayon minimum chargé arrière",{"$f":"'schéma tracteur'!M50","v":0}]
[{"$f":"'schéma tracteur'!B51+1","v":1},null,null,null,"Rayon minimum chargé avant",{"$f":"'schéma tracteur'!W50","v":0}]
[]
[{"$f":"'schéma tracteur'!Y21","v":"Simple"},"av"]
[{"$f":"'schéma tracteur'!E25","v":"Simple"},"ar"]
[null,null,null,null,null,null,null,null,null,{"$f":"J45*1.2","v":0},0.2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W45*1.2","v":0},null,0.2]
[]
[null,null,null,0,null,null,null,10,null,null,null,null,"894 mm",null,null,null,null,null,null,10,null,null,"894 mm"]
[null,null,null,null,null,null,null,9,null,null,null,null,"894 mm",null,null,null,null,"pression avant Psi ext",null,9,null,null,"894 mm"]
[]
[]
[null,null,null,null,"Pression en PSI arrière int"]
[null,null,null,null,"Pression en PSI arrière ext",null,null,null,null,null,null,null,null,null,null,null,null,"pression avant Psi ext"]
[]
[]
[null,null,"Catégorie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Catégorie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réservoir"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E61:K62)","v":0},null,null,"Citerne"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vide"]

{"sheet":"Résultat_H","index":4,"n_rows":138,"n_cols":47,"rows_kept":138,"cut":false,"hidden":false,"merged":[[60,28,60,29],[60,17,60,18],[94,0,94,12],[99,1,99,3],[0,0,0,9],[47,0,47,12],[52,1,52,3],[13,30,13,31],[13,41,13,42]]}
["Tracteur en roue simple",null,null,null,null,null,null,null,null,null,null,null,null,"Ajustement vitesse  km /h",null,{"$f":"'schéma tracteur'!H49","v":10},null,null,null,null,null,"Ajustement vitesse km/h",null,{"$f":"'schéma tracteur'!K49","v":30},null,null,null,null,null,null,null,"Ajustement vitesse 10 km /h",null,null,null,null,null,null,null,null,null,null,"Ajustement vitesse 30 km/h"]
["Entreprise :",{"$f":"IF(Informations!$K$15=0,\"\",Informations!$K$15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=1,\"Poids avant:\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""}]
["Producteur :",{"$f":"IF(Informations!$K$16=0,\"\",Informations!$K$16)","v":""}]
["Ville :",{"$f":"Informations!$K$17","v":0},null,null,{"$f":"IF(P2=1,\"Poids avant:\",\"\")","v":""},null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$T$50","v":0},null,{"$f":"N4","v":0},null,null,null,null,null,{"$f":"'schéma tracteur'!$V$50","v":0},null,{"$f":"'schéma tracteur'!$V$50","v":0},null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!$T$50","v":0},null,{"$f":"'schéma tracteur'!$T$50","v":0},null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!BJ21=0,\"\",'schéma tracteur'!BJ21)","v":""},{"$f":"'schéma tracteur'!$V$50","v":0},null,{"$f":"'schéma tracteur'!$V$50","v":0},{"$f":"IF('schéma tracteur'!BJ22=0,\"\",'schéma tracteur'!BJ22)","v":""}]
[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,"Répartition",null,null,null,null,null,null,null,null,null,null,"Répartition"]
["Tracteur :",{"$f":"'Saisie des poids'!$B$2","v":0},null,null,{"$f":"IF('schéma tracteur'!$W$3=0,\"\",'schéma tracteur'!$W$3)","v":""},{"$f":"IF('schéma tracteur'!$V$3=0,\"\",'schéma tracteur'!$V$3)","v":""},null,{"$f":"IF('schéma tracteur'!$V$4=0,\"\",'schéma tracteur'!$V$4)","v":""},{"$f":"IF('schéma tracteur'!$W$4=0,\"\",'schéma tracteur'!$W$4)","v":""},"déportance"]
["Hp:",{"$f":"'Saisie des poids'!$B$3","v":0},null,null,"Répartition",null,null,null,null,{"$f":"'Saisie des poids'!$G$9","v":0},null,null,null,null,null,null,"RSC",null,null,null,null,null,null,null,"Rsc",null,null,null,null,null,null,null,null,null,"RSC",null,null,null,null,{"$f":"IF(#REF!=1,\"Poids dans la roue\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,"RSC"]
["Pneu avant",null,null,"Vide/bas",{"$f":"ROUND('Calcul tracteur caravane'!$I$28,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$50=0,\"\",'schéma tracteur'!$W$50)","v":""},null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$50=0,\"\",'schéma tracteur'!$W$50)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$50=0,\"\",'schéma tracteur'!$W$50)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$50=0,\"\",'schéma tracteur'!$W$50)","v":""}]
[{"$f":"'schéma tracteur'!$W$28","v":0},null,null,"Plein/Haut",{"$f":"'Calcul tracteur caravane'!$J$28","v":""},null,null,null,"RSC"]
[{"$f":"'schéma tracteur'!Z28","v":0},{"$f":"'schéma tracteur'!$AB$28","v":0},null,null,{"$f":"IF('schéma tracteur'!$T$22=0,\"\",'schéma tracteur'!$T$22)","v":""},null,null,null,{"$f":"'schéma tracteur'!$V$26","v":0},null,null,null,null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,null,null,null,{"$f":"IF('Saisie des poids'!$B$73=0,\"\",'Saisie des poids'!$B$73)","v":""},{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""},null,null,null,null,null,null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""},null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!AO23=0,\"\",'Saisie des poids'!AO23)","v":""},{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!$B$74=0,\"\",'Saisie des poids'!$B$74)","v":""},{"$f":"IF('Saisie des poids'!$C$74=0,\"\",'Saisie des poids'!$C$74)","v":""},null,null,{"$f":"IF('Saisie des poids'!$F$6=0,\"\",'Saisie des poids'!$F$6)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!AD$6=0,\"\",'Saisie des poids'!AD$6)","v":""},null,null,null,null,null,null,{"$f":"IF(#REF!=0,\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,\"\",#REF!)","v":{"$error":"#REF!"}},null,null,{"$f":"IF('Saisie des poids'!AS$6=0,\"\",'Saisie des poids'!AS$6)","v":""}]
[{"$f":"IF('schéma tracteur'!$W$29=0,\"\",'schéma tracteur'!$W$29)","v":""},null,null,null,{"$f":"IF('Saisie des poids'!$B$5=0,\"\",'Saisie des poids'!$B$5)","v":""},{"$f":"'Saisie des poids'!$C$5","v":0},null,{"$f":"'Saisie des poids'!$E$5","v":0},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""}]
[{"$f":"IF('schéma tracteur'!$Y$29=0,\"\",'schéma tracteur'!$Y$29)","v":""},{"$f":"IF('schéma tracteur'!$AB$29=0,\"\",'schéma tracteur'!$AB$29)","v":""},null,null,{"$f":"IF('Saisie des poids'!$B$6=0,\"\",'Saisie des poids'!$B$6)","v":""},{"$f":"IF('Saisie des poids'!$C$6=0,\"\",'Saisie des poids'!$C$6)","v":""},null,{"$f":"IF('Saisie des poids'!$E$6=0,\"\",'Saisie des poids'!$E$6)","v":""},{"$f":"IF('Saisie des poids'!$F$6=0,\"\",'Saisie des poids'!$F$6)","v":""},null,null,null,null,{"$f":"'schéma tracteur'!$H$50","v":0},null,{"$f":"'schéma tracteur'!$H$50","v":0},null,null,null,null,null,{"$f":"'schéma tracteur'!$K$50","v":0},null,{"$f":"'schéma tracteur'!$K$50","v":0},null,null,null,null,null,null,9,9.5,null,9.5,9,null,null,null,null,null,null,9,9.5,null,9.5,9]
[null,null,null,null,null,null,null,null,null,"Empattement"]
[null,null,null,null,{"$f":"IF('schéma tracteur'!$W$6=0,\"\",'schéma tracteur'!$W$6)","v":""},{"$f":"IF('schéma tracteur'!$V$6=0,\"\",'schéma tracteur'!$V$6)","v":""},null,{"$f":"IF('schéma tracteur'!$V$6=0,\"\",'schéma tracteur'!$V$6)","v":""},{"$f":"IF('schéma tracteur'!$W$6=0,\"\",'schéma tracteur'!$W$6)","v":""},{"$f":"'Saisie des poids'!$G$12","v":0}]
["Pneu arrière",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RSC",null,null,null,null,null,null,null,"Rsc",null,null,null,null,null,null,null,null,null,null,"RSC",null,null,null,null,null,null,null,null,null,null,"RSC"]
[{"$f":"'schéma tracteur'!$C$28","v":0},null,null,"Vide/bas",{"$f":"ROUND('Calcul tracteur caravane'!$I$27,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$M$50=0,\"\",'schéma tracteur'!$M$50)","v":""},null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$M$50=0,\"\",'schéma tracteur'!$M$50)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$M$50=0,\"\",'schéma tracteur'!$M$50)","v":""},null,null,null,{"$f":"IF(#REF!=1,\"Poids dans la roue\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$M$50=0,\"\",'schéma tracteur'!$M$50)","v":""}]
[{"$f":"'schéma tracteur'!$F$28","v":0},{"$f":"'schéma tracteur'!$H$28","v":0},null,"Plein/Haut",{"$f":"'Calcul tracteur caravane'!$J$27","v":""},null,null,null,"RSC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""}]
[null,null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""},null,null,null,{"$f":"'schéma tracteur'!$G$26","v":0},"déportance"]
[{"$f":"IF('schéma tracteur'!C29=0,\"\",'schéma tracteur'!C29)","v":""},null,null,null,null,null,null,null,null,{"$f":"'Saisie des poids'!$G$18","v":0},null,null,null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"ROUND(('schéma tracteur'!$J$44/2/0.88),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(('schéma tracteur'!$J$44/2/0.88),0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(('schéma tracteur'!$J$44/2/0.88),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(('schéma tracteur'!$J$44/2/0.88),0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"ROUND(('schéma tracteur'!$J$45/2/0.88),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(('schéma tracteur'!$J$45/2/0.88),0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND(('schéma tracteur'!$J$45/2/0.88),0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(('schéma tracteur'!$J$45/2/0.88),0)","v":{"$error":"#VALUE!"}}]
[{"$f":"IF('schéma tracteur'!$F$29=0,\"\",'schéma tracteur'!$F$29)","v":""},{"$f":"IF('schéma tracteur'!$H$29=0,\"\",'schéma tracteur'!$H$29)","v":""}]
[null,null,null,null,{"$f":"IF('Saisie des poids'!$B$19=0,\"\",'Saisie des poids'!$B$19)","v":""},{"$f":"'Saisie des poids'!$C$19","v":0},null,{"$f":"'Saisie des poids'!$E$19","v":0},{"$f":"IF('Saisie des poids'!$F$19=0,\"\",'Saisie des poids'!$F$19)","v":""}]
[null,null,null,null,{"$f":"IF('Saisie des poids'!$B$20=0,\"\",'Saisie des poids'!$B$20)","v":""},{"$f":"IF('Saisie des poids'!$C$20=0,\"\",'Saisie des poids'!$C$20)","v":""},null,{"$f":"IF('Saisie des poids'!$E$20=0,\"\",'Saisie des poids'!E$20)","v":""},{"$f":"IF('Saisie des poids'!$F$20=0,\"\",'Saisie des poids'!$F$20)","v":""},null,null,null,null,null,{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""},null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=1,\"Poids arrière\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""}]
[]
[null,null,null,null,null,{"$f":"IF(P2=1,\"Poids arrière\",\"\")","v":""},"Semoir",null,null,null,null,null,null,null,{"$f":"G25","v":"Semoir"},null,null,null,null,null,null,null,{"$f":"O25","v":"Semoir"}]
[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,"Voici donc les ajustements non balancés de votre tracteur, cela dans le but de ",null,null,null,null,null,null,null,null,null,null,"Sur la roue à 30km/h, allez voir la charte du pneu"]
[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,"protéger la surface en culture"]
["Pneu",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,"Au remisage monter la pression de l'ensemble de vos pneux à plus de 20 psi."]
[{"$f":"'schéma tracteur'!$O$61","v":0},null,null,null,null,null,null,null,null,null,null,"Au remisage monter la pression de l'ensemble de vos pneux à plus de 20 psi."]
[{"$f":"'schéma tracteur'!$Q$61","v":0},{"$f":"'schéma tracteur'!$R$61","v":0}]
[{"$f":"'schéma tracteur'!$R$61","v":0}]
[null,null,null,null,null,{"$f":"'schéma tracteur'!$Y$3","v":0},null,{"$f":"'schéma tracteur'!$Y$4","v":0}]
["Le poids arrière chargé sert à ajuster la pression arrire."]
["Le poids avant à l'arrêt donc la machine en bas sert à ajuster la pression avant."]
["Nous n'avons par le rayon sous charge réel, il faudrait vérifier le rayon sous charge."]
["Il pourrait y ajouter de poids en avant pour mieux balancer le tracteur aves des roues doubles."]
[null,null,null,null,null,{"$f":"'schéma tracteur'!$G$61","v":0},null,{"$f":"'schéma tracteur'!$G$61","v":0}]
[null,null,null,null,null,{"$f":"'schéma tracteur'!$J$61","v":0},null,{"$f":"'schéma tracteur'!$K$61","v":0}]
[]
[]
["Réalisé par: ","Bruno Garon Ing. Conseiller Santé des sols, MAPAQ, Montérégie"]
[]
[]
["Date :",{"$f":"Informations!$K$6","v":45321}]
[]
[]
[]
["Tracteur en roue simple avant et roue double arrière",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ajustement vitesse km /h",null,{"$f":"'schéma tracteur'!H49","v":10},null,null,null,null,null,null,null,null,"Ajustement vitesse km/h",null,{"$f":"'schéma tracteur'!K49","v":30}]
["Entreprise :",{"$f":"IF(Informations!$K$15=0,\"\",Informations!$K$15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK47=1,\"Poids avant:\",\"\")","v":""},null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""}]
["Producteur :",{"$f":"IF(Informations!$K$16=0,\"\",Informations!$K$16)","v":""}]
["Ville :",{"$f":"Informations!$K$17","v":0},null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!AH34=0,\"\",'schéma tracteur'!AH34)","v":""},{"$f":"'schéma tracteur'!$T$50","v":0},null,{"$f":"'schéma tracteur'!$T$50","v":0},{"$f":"IF('schéma tracteur'!AH35=0,\"\",'schéma tracteur'!AH35)","v":""},null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!AW66=0,\"\",'schéma tracteur'!AW66)","v":""},{"$f":"'schéma tracteur'!$V$50","v":0},null,{"$f":"'schéma tracteur'!$V$50","v":0},{"$f":"IF('schéma tracteur'!#REF!=0,\"\",'schéma tracteur'!#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Répartition",null,null,null,null,null,null,null,null,null,null,"Répartition"]
["Tracteur :",{"$f":"'Saisie des poids'!$B$2","v":0},null,null,null,null,{"$f":"IF('schéma tracteur'!$W$3=0,\"\",'schéma tracteur'!$W$3)","v":""},{"$f":"IF('schéma tracteur'!$V$3=0,\"\",'schéma tracteur'!$V$3)","v":""},null,{"$f":"IF('schéma tracteur'!$V$4=0,\"\",'schéma tracteur'!$V$4)","v":""},{"$f":"IF('schéma tracteur'!$W$4=0,\"\",'schéma tracteur'!$W$4)","v":""},null,"déportance"]
["Hp:",{"$f":"'Saisie des poids'!$B$3","v":0},null,null,"Répartition",null,null,null,null,null,null,null,{"$f":"'Saisie des poids'!$G$9","v":0},null,null,{"$f":"IF(AK47=1,\"Poids dans la roue\",\"\")","v":""},null,null,null,null,null,"RSC",null,null,null,null,null,null,null,null,null,null,"RSC"]
["Pneu avant",null,null,"Vide/bas",{"$f":"ROUND('Calcul tracteur caravane'!$I$28,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$50=0,\"\",'schéma tracteur'!$W$50)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$50=0,\"\",'schéma tracteur'!$W$50)","v":""}]
[{"$f":"'schéma tracteur'!$W$28","v":0},null,null,"Plein/Haut",{"$f":"'Calcul tracteur caravane'!$J$28","v":""},null,null,null,null,null,"RSC"]
[{"$f":"'schéma tracteur'!Z28","v":0},{"$f":"'schéma tracteur'!$AB$28","v":0},null,null,null,null,{"$f":"IF('schéma tracteur'!$T$22=0,\"\",'schéma tracteur'!$T$22)","v":""},null,null,null,{"$f":"'schéma tracteur'!$V$26","v":0},null,null,null,null,null,null,null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""},null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!AB73=0,\"\",'Saisie des poids'!AB73)","v":""},{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!Q$6=0,\"\",'Saisie des poids'!Q$6)","v":""},null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!AB74=0,\"\",'Saisie des poids'!AB74)","v":""},{"$f":"IF('Saisie des poids'!AC74=0,\"\",'Saisie des poids'!AC74)","v":""},null,null,{"$f":"IF('Saisie des poids'!AF$6=0,\"\",'Saisie des poids'!AF$6)","v":""}]
[{"$f":"IF('schéma tracteur'!$W$29=0,\"\",'schéma tracteur'!$W$29)","v":""},null,null,null,null,null,{"$f":"IF('Saisie des poids'!$B$5=0,\"\",'Saisie des poids'!$B$5)","v":""},{"$f":"'Saisie des poids'!$C$5","v":0},null,{"$f":"'Saisie des poids'!$E$5","v":0},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""}]
[{"$f":"IF('schéma tracteur'!$Z$29=0,\"\",'schéma tracteur'!$Z$29)","v":""},{"$f":"IF('schéma tracteur'!$AB$29=0,\"\",'schéma tracteur'!$AB$29)","v":""},null,null,null,null,{"$f":"IF('Saisie des poids'!$B$6=0,\"\",'Saisie des poids'!$B$6)","v":""},{"$f":"IF('Saisie des poids'!$C$6=0,\"\",'Saisie des poids'!$C$6)","v":""},null,{"$f":"IF('Saisie des poids'!$E$6=0,\"\",'Saisie des poids'!$E$6)","v":""},{"$f":"IF('Saisie des poids'!$F$6=0,\"\",'Saisie des poids'!$F$6)","v":""},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$H$50","v":0},{"$f":"'schéma tracteur'!$H$50+1","v":1},null,{"$f":"'schéma tracteur'!$H$50+1","v":1},{"$f":"'schéma tracteur'!$H$50","v":0},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$K$51","v":0},{"$f":"'schéma tracteur'!$K$50+1","v":1},null,{"$f":"'schéma tracteur'!$K$50+1","v":1},{"$f":"'schéma tracteur'!$K$51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empattement"]
[null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$5=0,\"\",'schéma tracteur'!$W$5)","v":""},{"$f":"IF('schéma tracteur'!$V$5=0,\"\",'schéma tracteur'!$V$5)","v":""},null,{"$f":"IF('schéma tracteur'!$V$6=0,\"\",'schéma tracteur'!$V$6)","v":""},{"$f":"IF('schéma tracteur'!$W$6=0,\"\",'schéma tracteur'!$W$6)","v":""},null,{"$f":"'Saisie des poids'!$G$12","v":0}]
["Pneu arrière",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RSC",null,null,null,null,null,null,null,null,null,null,"RSC"]
[{"$f":"'schéma tracteur'!$C$28","v":0},null,null,"Vide/bas",{"$f":"ROUND('Calcul tracteur caravane'!$I$27,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK47=1,\"Poids dans la roue\",\"\")","v":""},null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$M$50=0,\"\",'schéma tracteur'!$M$50)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$M$50=0,\"\",'schéma tracteur'!$M$50)","v":""}]
[{"$f":"'schéma tracteur'!$F$28","v":0},{"$f":"'schéma tracteur'!$H$28","v":0},null,"Plein/Haut",{"$f":"'Calcul tracteur caravane'!$J$27","v":""},null,null,null,null,null,null,"RSC",null,null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""}]
[null,null,null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""},null,null,null,null,null,{"$f":"'schéma tracteur'!$G$26","v":0},"déportance"]
[{"$f":"IF('schéma tracteur'!$C$29=0,\"\",'schéma tracteur'!$C$29)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Saisie des poids'!$G$18","v":0},null,null,null,null,{"$f":"ROUND('schéma tracteur'!$J$45,0)","v":{"$error":"#VALUE!"}},{"$f":"'schéma tracteur'!$J$45","v":""},null,{"$f":"'schéma tracteur'!$J$45","v":""},{"$f":"'schéma tracteur'!$J$45","v":""},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$J$45","v":""},{"$f":"'schéma tracteur'!$J$45","v":""},null,{"$f":"'schéma tracteur'!$J$45","v":""},{"$f":"'schéma tracteur'!$J$45","v":""}]
[{"$f":"IF('schéma tracteur'!$F$29=0,\"\",'schéma tracteur'!$F$29)","v":""},{"$f":"'schéma tracteur'!$H$28","v":0}]
[null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!$B$19=0,\"\",'Saisie des poids'!$B$19)","v":""},{"$f":"'Saisie des poids'!$C$19","v":0},null,{"$f":"'Saisie des poids'!$E$19","v":0},{"$f":"IF('Saisie des poids'!$F$19=0,\"\",'Saisie des poids'!$F$19)","v":""}]
[null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!$B$20=0,\"\",'Saisie des poids'!$B$20)","v":""},{"$f":"IF('Saisie des poids'!$C$20=0,\"\",'Saisie des poids'!$C$20)","v":""},null,{"$f":"IF('Saisie des poids'!$E$20=0,\"\",'Saisie des poids'!$E$20)","v":""},{"$f":"IF('Saisie des poids'!$F$20=0,\"\",'Saisie des poids'!$F$20)","v":""},null,null,null,null,null,null,null,{"$f":"IF(AK47=1,\"Poids arrière\",\"\")","v":""},{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=1,\"Poids arrière\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I73","v":"Semoir"},null,null,null,null,null,null,null,null,null,null,{"$f":"T71","v":"Semoir"}]
[null,null,null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""}]
[null,null,null,null,null,null,null,null,"Semoir",null,null,null,null,null,"Voici donc les ajustements non balancés de votre tracteur, cela dans le but de ",null,null,null,null,null,null,null,null,null,null,"Sur la roue à 50km/h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"protéger la surface en culture"]
["Pneu",null,null,null,null,null,null,null,null,null,null,null,null,null,"Au remisage monter la pression de l'ensemble de vos pneux à plus de 20 psi."]
[{"$f":"'schéma tracteur'!$O$61","v":0}]
[{"$f":"'schéma tracteur'!$Q$61","v":0},{"$f":"'schéma tracteur'!$R$61","v":0}]
["Le poids arrière chargé sert à ajuster la pression arrière"]
["Le poids avant à l'arrêt donc la machine en bas sert à ajuster la pression avant."]
["Il faudrait ajouter du poids en avant, il serait préféreble de mettre des roues double en avant."]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!$G$61","v":0},null,{"$f":"'schéma tracteur'!$G$61","v":0}]
[null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!$J$61","v":0},null,{"$f":"'schéma tracteur'!$K$61","v":0}]
[]
[{"$f":"$A$41","v":"Réalisé par: "},{"$f":"$B$41","v":"Bruno Garon Ing. Conseiller Santé des sols, MAPAQ, Montérégie"}]
[null,{"$f":"IF($B$42=0,\"\",$B$42)","v":""}]
[null,{"$f":"IF($B$42=0,\"\",$B$42)","v":""}]
[{"$f":"$A$44","v":"Date :"},{"$f":"Informations!$K$6","v":45321}]
[]
[]
[]
[]
["Tracteur en roue double avant et arrière",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ajustement à km/h",null,{"$f":"'schéma tracteur'!H49","v":10},null,null,null,null,null,null,null,null,"Ajustement à km/h",null,{"$f":"'schéma tracteur'!K49","v":30}]
["Entreprise :",{"$f":"IF(Informations!$K$15=0,\"\",Informations!$K$15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK94=1,\"Poids avant:\",\"\")","v":""},null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AK131=1,\"Poids avant:\",\"\")","v":""},null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""}]
["Producteur :",{"$f":"IF(Informations!$K$16=0,\"\",Informations!$K$16)","v":""}]
["Ville :",{"$f":"Informations!$K$17","v":0},null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$Y$17=0,\"\",'schéma tracteur'!$Y$17)","v":""},null,null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!$T$51","v":0},{"$f":"'schéma tracteur'!$T$50","v":0},null,{"$f":"'schéma tracteur'!$T$50","v":0},{"$f":"'schéma tracteur'!$T$51","v":0},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$V$51","v":0},{"$f":"'schéma tracteur'!$V$50","v":0},null,{"$f":"'schéma tracteur'!$V$50","v":0},{"$f":"'schéma tracteur'!$V$51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Répartition",null,null,null,null,null,null,null,null,null,null,"Répartition"]
["Tracteur :",{"$f":"'Saisie des poids'!$B$2","v":0},null,null,null,null,{"$f":"IF('schéma tracteur'!$W$3=0,\"\",'schéma tracteur'!$W$3)","v":""},{"$f":"IF('schéma tracteur'!$V$3=0,\"\",'schéma tracteur'!$V$3)","v":""},null,{"$f":"IF('schéma tracteur'!$V$4=0,\"\",'schéma tracteur'!$V$4)","v":""},{"$f":"IF('schéma tracteur'!$W$4=0,\"\",'schéma tracteur'!$W$4)","v":""},null,"déportance"]
["Hp:",{"$f":"'Saisie des poids'!$B$3","v":0},null,null,"Répartition",null,null,null,null,null,null,null,{"$f":"'Saisie des poids'!$G$9","v":0},null,null,{"$f":"IF(AK94=1,\"Poids dans la roue\",\"\")","v":""},null,null,null,null,null,null,"RSC",null,null,null,{"$f":"IF(AK131=1,\"Poids dans la roue\",\"\")","v":""},null,null,null,null,null,null,"RSC"]
["Pneu avant",null,null,"Vide/bas",{"$f":"ROUND('Calcul tracteur caravane'!$I$28,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!$W$50","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"$W$102","v":0}]
[{"$f":"'schéma tracteur'!$W$28","v":0},null,null,"Plein/Haut",{"$f":"'Calcul tracteur caravane'!$J$28","v":""},null,null,null,null,null,null,"RSC"]
[{"$f":"'schéma tracteur'!Z28","v":0},{"$f":"'schéma tracteur'!$AB$28","v":0},null,null,null,{"$f":"IF('schéma tracteur'!$T$22=0,\"\",'schéma tracteur'!$T$22)","v":""},null,null,null,null,null,{"$f":"'schéma tracteur'!$V$26","v":0},null,null,null,null,null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$W$45,0)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!J87=0,\"\",'Saisie des poids'!J87)","v":""},{"$f":"IF('Saisie des poids'!K87=0,\"\",'Saisie des poids'!K87)","v":""},null,null,{"$f":"IF('Saisie des poids'!N$6=0,\"\",'Saisie des poids'!N$6)","v":""},null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!J124=0,\"\",'Saisie des poids'!J124)","v":""},{"$f":"IF('Saisie des poids'!K124=0,\"\",'Saisie des poids'!K124)","v":""},null,null,{"$f":"IF('Saisie des poids'!N$6=0,\"\",'Saisie des poids'!N$6)","v":""}]
[{"$f":"IF('schéma tracteur'!$W$29=0,\"\",'schéma tracteur'!$W$29)","v":""},null,null,null,null,null,{"$f":"IF('Saisie des poids'!$B$5=0,\"\",'Saisie des poids'!$B$5)","v":""},{"$f":"'Saisie des poids'!$C$5","v":0},null,{"$f":"'Saisie des poids'!$E$5","v":0},{"$f":"IF('Saisie des poids'!$F$5=0,\"\",'Saisie des poids'!$F$5)","v":""}]
[{"$f":"IF('schéma tracteur'!$Z$29=0,\"\",'schéma tracteur'!$Z$29)","v":""},{"$f":"IF('schéma tracteur'!$AB$29=0,\"\",'schéma tracteur'!$AB$29)","v":""},null,null,null,null,{"$f":"IF('Saisie des poids'!$B$6=0,\"\",'Saisie des poids'!$B$6)","v":""},{"$f":"IF('Saisie des poids'!$C$6=0,\"\",'Saisie des poids'!$C$6)","v":""},null,{"$f":"IF('Saisie des poids'!$E$6=0,\"\",'Saisie des poids'!$E$6)","v":""},{"$f":"IF('Saisie des poids'!$F$6=0,\"\",'Saisie des poids'!$F$6)","v":""},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$H$51","v":0},{"$f":"'schéma tracteur'!$H$50","v":0},null,{"$f":"'schéma tracteur'!$H$50","v":0},{"$f":"'schéma tracteur'!$H$51","v":0},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$K$51","v":0},{"$f":"'schéma tracteur'!$K$50","v":0},null,{"$f":"'schéma tracteur'!$K$50","v":0},{"$f":"'schéma tracteur'!$K$51","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Empattement"]
[null,null,null,null,null,null,{"$f":"IF('schéma tracteur'!$W$5=0,\"\",'schéma tracteur'!$W$5)","v":""},{"$f":"IF('schéma tracteur'!$V$5=0,\"\",'schéma tracteur'!$V$5)","v":""},null,{"$f":"IF('schéma tracteur'!$V$6=0,\"\",'schéma tracteur'!$V$6)","v":""},{"$f":"IF('schéma tracteur'!$W$6=0,\"\",'schéma tracteur'!$W$6)","v":""},null,{"$f":"'Saisie des poids'!$G$12","v":0}]
["Pneu arrière"]
[{"$f":"'schéma tracteur'!$C$28","v":0},null,null,"Vide/bas",{"$f":"ROUND('Calcul tracteur caravane'!$I$27,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK94=1,\"Poids dans la roue\",\"\")","v":""},null,null,null,null,null,null,"RSC",null,null,null,{"$f":"IF(AK131=1,\"Poids dans la roue\",\"\")","v":""},null,null,null,null,null,null,"RSC"]
[{"$f":"'schéma tracteur'!$F$28","v":0},{"$f":"'schéma tracteur'!$H$28","v":0},null,"Plein/Haut",{"$f":"'Calcul tracteur caravane'!$J$27","v":""},null,null,null,null,null,null,"RSC",null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""},null,null,null,null,null,null,{"$f":"'schéma tracteur'!$M$50","v":0},null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""},null,null,null,null,null,null,{"$f":"$W$112","v":0}]
[null,null,null,null,null,{"$f":"IF('schéma tracteur'!$T$18=0,\"\",'schéma tracteur'!$T$18)","v":""},null,null,null,null,null,{"$f":"'schéma tracteur'!$G$26","v":0},"déportance"]
[{"$f":"IF('schéma tracteur'!$C$29=0,\"\",'schéma tracteur'!$C$29)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Saisie des poids'!$G$18","v":0},null,null,null,null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},null,{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$J$44,0)","v":{"$error":"#VALUE!"}}]
[{"$f":"IF('schéma tracteur'!$F$29=0,\"\",'schéma tracteur'!$F$29)","v":""},{"$f":"'schéma tracteur'!$H$28","v":0}]
[null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!$B$19=0,\"\",'Saisie des poids'!$B$19)","v":""},{"$f":"'Saisie des poids'!$C$19","v":0},null,{"$f":"'Saisie des poids'!$E$19","v":0},{"$f":"IF('Saisie des poids'!$F$19=0,\"\",'Saisie des poids'!$F$19)","v":""}]
[null,null,null,null,null,null,{"$f":"IF('Saisie des poids'!$B$20=0,\"\",'Saisie des poids'!$B$20)","v":""},{"$f":"IF('Saisie des poids'!$C$20=0,\"\",'Saisie des poids'!$C$20)","v":""},null,{"$f":"IF('Saisie des poids'!$E$20=0,\"\",'Saisie des poids'!$E$20)","v":""},{"$f":"IF('Saisie des poids'!$F$20=0,\"\",'Saisie des poids'!$F$20)","v":""},null,null,null,null,null,null,null,{"$f":"IF(AK94=1,\"Poids arrière\",\"\")","v":""},{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(AK131=1,\"Poids arrière\",\"\")","v":""},{"$f":"IF('schéma tracteur'!$E$17=0,\"\",'schéma tracteur'!$E$17)","v":""}]
[]
[null,null,null,null,null,null,null,null,"semoir",null,null,null,null,null,null,null,null,null,null,{"$f":"I119","v":"semoir"}]
[]
[]
["Pneu"]
[{"$f":"'schéma tracteur'!$O$61","v":0}]
[{"$f":"'schéma tracteur'!$Q$61","v":0},{"$f":"'schéma tracteur'!$R$61","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!$G$61","v":0},null,{"$f":"'schéma tracteur'!$G$61","v":0}]
[null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!$J$61","v":0},null,{"$f":"'schéma tracteur'!$K$61","v":0}]
[]
[]
[{"$f":"$A$41","v":"Réalisé par: "},{"$f":"$B$41","v":"Bruno Garon Ing. Conseiller Santé des sols, MAPAQ, Montérégie"}]
[null,{"$f":"IF($B$42=0,\"\",$B$42)","v":""}]
[null,{"$f":"IF($B$42=0,\"\",$B$42)","v":""}]
[{"$f":"$A$44","v":"Date :"},{"$f":"Informations!$K$6","v":45321}]

{"sheet":"Rapport_tracteur","index":5,"n_rows":84,"n_cols":24,"rows_kept":84,"cut":false,"hidden":false,"merged":[[5,9,5,11],[83,0,83,12],[6,10,8,12]]}
["Nom du Club",{"$f":"Informations!K9","v":"Votre club"},null,null,null,null,null,"Nom de l'entreprise",{"$f":"'schéma tracteur'!T8","v":""}]
["Adresse",{"$f":"Informations!K10","v":0},null,null,null,null,null,"Nom du producteur",{"$f":"'schéma tracteur'!T9","v":""}]
["Ville",{"$f":"Informations!K11","v":0},null,null,null,null,null,"Ville",{"$f":"'schéma tracteur'!T10","v":0}]
["Code Postal",{"$f":"Informations!K12","v":0}]
["Nom du conseiller",{"$f":"Informations!K13","v":"Bruno Garon, ing"}]
["No de téléphone",{"$f":"Informations!K14","v":"450-779-2669"},null,null,null,null,null,null,null,"Cliquez sur la disquette pour placer les données dans le tableau"]
[null,null,null,null,null,null,null,{"$f":"'schéma tracteur'!R2","v":0},"Type",{"$f":"'schéma tracteur'!C9","v":"2 + 2"},"si vous avez une erreur ou voulez effacer un essai, allez à la ligne 20 de l'essai, sélectionne le reste de la colonne jusqu'en bas, faites supprimer"]
[null,null,null,null,null,null,"Puissance PDF    ","Hp",{"$f":"'schéma tracteur'!$E$2","v":0}]
[null,null,null,null,null,null,"Puissance PDF    ","KW",{"$f":"I8*0.746","v":0}]
[null,null,null,null,null,null,null,null,"Ext","Int","Int","Ext"]
[null,null,null,null,null,null,"Avant","Psi",{"$f":"'schéma tracteur'!$W$3","v":0},{"$f":"'schéma tracteur'!$V$3","v":0},{"$f":"'schéma tracteur'!$V$4","v":0},{"$f":"'schéma tracteur'!$W$4","v":0}]
[null,null,null,null,null,null,"Arrière","Psi",{"$f":"'schéma tracteur'!$W$5","v":0},{"$f":"'schéma tracteur'!$V$5","v":0},{"$f":"'schéma tracteur'!$V$6","v":0},{"$f":"'schéma tracteur'!$W$6","v":0}]
[null,null,null,null,null,null,"Pneu",null,"Compagnie, grandeur","indice de charge","Rayon sous charge"]
[null,null,null,null,null,null,"Avant","Int",{"$f":"'schéma tracteur'!$W$28","v":0},{"$f":"'schéma tracteur'!$AB$28","v":0},{"$f":"'schéma tracteur'!$W$50","v":0}]
[null,null,null,null,null,null,"Avant","Ext",{"$f":"'schéma tracteur'!W29","v":0},{"$f":"'schéma tracteur'!$AB$29","v":0},{"$f":"'schéma tracteur'!$W$51","v":0}]
[null,null,null,null,null,null,"Arrière","Int",{"$f":"'schéma tracteur'!$C$28","v":0},{"$f":"'schéma tracteur'!$H$28","v":0},{"$f":"'schéma tracteur'!$M$50","v":0}]
[null,null,null,null,null,null,"Arrière","Ext",{"$f":"'schéma tracteur'!$C$29","v":0},{"$f":"'schéma tracteur'!$H$29","v":0},{"$f":"'schéma tracteur'!$M$51","v":0}]
[]
[null,null,null,"Vide","a",null,"b",1,{"$f":"H19+1","v":2},{"$f":"I19+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17]
["Essai no :",null,{"$f":"'schéma tracteur'!$T$11","v":1},"xxx",2,"xxx","Essai no :"]
["Tracteur no :",null,{"$f":"'schéma tracteur'!$T$12","v":0},"xxx",{"$f":"E20+1","v":3},"xxx","Tracteur no :"]
["Remarque",null,{"$f":"'schéma tracteur'!$T$13","v":0},"xxx",{"$f":"E21+1","v":4},"xxx","Remarque"]
["Remarque",null,{"$f":"'schéma tracteur'!$T$14","v":0},"xxx",5,"xxx","Remarque"]
["Type de roues avant",null,{"$f":"'schéma tracteur'!$Y$21","v":"Simple"},"xxx",6,null,"Type de roues avant"]
["Type de roues arrière",null,{"$f":"'schéma tracteur'!$E$25","v":"Simple"},"xxx",7,null,"Type de roues arrière"]
["Catégorie de l'équipement",null,{"$f":"'schéma tracteur'!$C$10","v":"Trainé"},"xxx",8,null,"Catégorie de l'équipement"]
["Empattement","m",{"$f":"'schéma tracteur'!$O$37","v":0},"xxx",9,"m","Empattement"]
["déportance avant","m",{"$f":"'schéma tracteur'!$V$37","v":0},"xxx",10,"m","déportance avant"]
["déportance arrière","m",{"$f":"'schéma tracteur'!$G$37","v":0},"xxx",11,"m","déportance arrière"]
["Équipement arrière","m",{"$f":"'schéma tracteur'!$C$12","v":0},"xxx",12,"m","Équipement arrière"]
["Poids équipement","kg",{"$f":"'schéma tracteur'!$E$17","v":0},"xxx",13,"kg","Poids équipement"]
["Poids équipement à vide","kg",{"$f":"'schéma tracteur'!$E$20","v":0},"xxx",14,"kg","Poids équipement à vide"]
["poids roues arrière","kg",{"$f":"'schéma tracteur'!$J$18","v":0},"xxx",15,"kg","poids roues arrière"]
["Poids essieu arrière vide ","kg",{"$f":"'schéma tracteur'!$J$31","v":""},"xxx",16,"kg","Poids essieu arrière vide "]
["Poids total arrière vide","kg",{"$f":"'schéma tracteur'!$G$31","v":""},"xxx",17,"kg","Poids total arrière vide"]
["Poids essieu arrière plein","kg",{"$f":"'schéma tracteur'!$J$34","v":""},"xxx",18,"kg","Poids essieu arrière plein"]
["Poids total arrière plein","kg",{"$f":"'schéma tracteur'!$G$34","v":""},"xxx",19,"kg","Poids total arrière plein"]
["Répartition arrière vide","%",{"$f":"ROUND('schéma tracteur'!$M$26:$M$26,1)","v":{"$error":"#VALUE!"}},"xxx",20,"%","Répartition arrière vide"]
["Répartition arrière plein","%",{"$f":"'schéma tracteur'!$M$28","v":""},"xxx",21,"%","Répartition arrière plein"]
["Équipement avant",null,{"$f":"'schéma tracteur'!$Y$19","v":0},"xxx",22,null,"Équipement avant"]
["Poids équipement","Kg",{"$f":"'schéma tracteur'!$Y$17","v":0},"xxx",23,"Kg","Poids équipement"]
["Poids Roue avant","kg",{"$f":"'schéma tracteur'!$T$22","v":0},"xxx",24,"kg","Poids Roue avant"]
["Poids essieu avant vide","kg",{"$f":"'schéma tracteur'!$T$31","v":""},"xxx",25,"kg","Poids essieu avant vide"]
["Poids total avant vide","kg",{"$f":"'schéma tracteur'!$V$31","v":""},"xxx",26,"kg","Poids total avant vide"]
["Poids essieu avant plein","kg",{"$f":"'schéma tracteur'!$T$34","v":""},"xxx",27,"kg","Poids essieu avant plein"]
["Poids total avant plein","kg",{"$f":"'schéma tracteur'!$V$34","v":""},"xxx",28,"kg","Poids total avant plein"]
["Répartition avant vide","%",{"$f":"ROUND('schéma tracteur'!$Q$26,1)","v":{"$error":"#VALUE!"}},"xxx",29,"%","Répartition avant vide"]
["Répartition avant plein",null,{"$f":"'schéma tracteur'!$Q$28","v":""},"xxx",30,null,"Répartition avant plein"]
["Poids total vide","kg",{"$f":"'schéma tracteur'!$B$32","v":""},"xxx",31,"kg","Poids total vide"]
["Poids total plein","kg",{"$f":"'schéma tracteur'!$B$34","v":""},null,32,"kg","Poids total plein"]
["Pneu arrière","xxx","xxxxxxxxxxxxxxx","xxx",33,"xxx","Pneu arrière"]
["Vitesse","Km/h",{"$f":"'schéma tracteur'!$H$49","v":10},"xxx",34,"Km/h","Vitesse"]
["Poids Pneu arrière vide","Kg",{"$f":"'schéma tracteur'!$J$44","v":""},"xxx",35,"Kg","Poids Pneu arrière vide"]
["Pression arrière int. Vide","Psi",{"$f":"'schéma tracteur'!$H$50","v":0},"xxx",36,"PSI","Pression arrière int. Vide"]
["Pression arrière ext.vide","Psi",{"$f":"'schéma tracteur'!$H$51","v":0},"xxx",37,"Psi","Pression arrière ext.vide"]
["Vitesse","Km/h",{"$f":"'schéma tracteur'!$K$49","v":30},"xxx",38,"Km/h","Vitesse"]
["Pression arrière int. vide","Psi",{"$f":"'schéma tracteur'!$K$50","v":0},"xxx",39,"Psi","Pression arrière int. vide"]
["Pression arrière ext. Vide","Psi",{"$f":"'schéma tracteur'!$K$51","v":0},"xxx",40,"Psi","Pression arrière ext. Vide"]
["Poids Pneu arrière plein","kg",{"$f":"'schéma tracteur'!$J$45","v":""},"xxx",41,"kg","Poids Pneu arrière plein"]
["Vitesse plein","Km/h",{"$f":"'schéma tracteur'!$H$53","v":10},"xxx",42,"Km/h","Vitesse plein"]
["Pression arrière int. Plein","Psi",{"$f":"'schéma tracteur'!$H$54","v":0},"xxx",43,"Psi","Pression arrière int. Plein"]
["Pression arrière ext.plein","Psi",{"$f":"'schéma tracteur'!$H$55","v":0},"xxx",44,"Psi","Pression arrière ext.plein"]
["Vitesse","Km/h",{"$f":"'schéma tracteur'!$K$53","v":30},"xxx",45,"Km/h","Vitesse"]
["Pression arrière int.plein","PSI",{"$f":"'schéma tracteur'!$K$54","v":0},"xxx",46,"PSI","Pression arrière int.plein"]
["Pression arrière ext. Plein","Psi",{"$f":"'schéma tracteur'!$K$55","v":0},"xxx",47,"Psi","Pression arrière ext. Plein"]
["Pneu avant",null,"xxxxxxxxxxxxxxx","xxx",48,null,"Pneu avant"]
["Poids Pneu avant","Kg",{"$f":"'schéma tracteur'!$W$44","v":""},"xxx",49,"Kg","Poids Pneu avant"]
["poids pneu équipement vide","Kg",{"$f":"'schéma tracteur'!$W$45","v":""},null,50,"Kg","poids pneu équipement vide"]
["Vitesse vide","Km/h",{"$f":"'schéma tracteur'!$T$49","v":10},"xxx",51,"Km/h","Vitesse vide"]
["Pression avant int. Vide","Psi",{"$f":"'schéma tracteur'!$T$50","v":0},"xxx",52,"Psi","Pression avant int. Vide"]
["Pression avant ext. Vide","Psi",{"$f":"'schéma tracteur'!$T$51","v":0},"xxx",53,"Psi","Pression avant ext. Vide"]
["Vitesse","Km/h",{"$f":"'schéma tracteur'!$V$49","v":30},"xxx",54,"Km/h","Vitesse"]
["Pression avant int. Vide","Psi",{"$f":"'schéma tracteur'!$V$50","v":0},"xxx",55,"Psi","Pression avant int. Vide"]
["Pression avant ext. Vide","Psi",{"$f":"'schéma tracteur'!$V$51","v":0},"xxx",56,"Psi","Pression avant ext. Vide"]
["Vitesse plein","Km/h",{"$f":"'schéma tracteur'!$T$53","v":10},"xxx",57,"Km/h","Vitesse plein"]
["Pression avant int. Plein","Psi",{"$f":"'schéma tracteur'!$T$54","v":0},null,58,"Psi","Pression avant int. Plein"]
["Pression avant ext. Plein","Psi",{"$f":"'schéma tracteur'!$T$55","v":0},"xxx",59,"Psi","Pression avant ext. Plein"]
["Vitesse","Km/h",{"$f":"'schéma tracteur'!$V$53","v":30},"xxx",60,"Km/h","Vitesse"]
["Pression avant int. plein","Psi",{"$f":"'schéma tracteur'!$V$54","v":0},"xxx",61,"Psi","Pression avant int. plein"]
["Pression avant ext. plein","Psi",{"$f":"'schéma tracteur'!$V$55","v":0},"xxx",62,"Psi","Pression avant ext. plein"]
["Rapport de charge","Lb/Hp",{"$f":"ROUND('schéma tracteur'!$G$6,1)","v":{"$error":"#VALUE!"}},"xxx",63,"Lb/Hp","Rapport de charge"]
["Rapport de charge","Kg/HP",{"$f":"ROUND('schéma tracteur'!$G$5,1)","v":{"$error":"#VALUE!"}},"xxx",64,"Kg/HP","Rapport de charge"]
["Conception Bruno Garon ing. Montérégie Est"]
["ne pas oublier qu'au remisage pour l'hiver de remonter les pressions en haut de 20 psi et enlevez toute charge inutile"]

{"sheet":"bilan des opérations","index":6,"n_rows":64,"n_cols":6,"rows_kept":64,"cut":false,"hidden":false,"merged":[[63,0,64,5],[59,0,60,5]]}
["Fiche d'ajustement des pressions par tracteur et machine"]
["Tracteur",{"$f":"'schéma tracteur'!R2","v":0},{"$f":"'schéma tracteur'!E2","v":0},{"$f":"ROUND('schéma tracteur'!E3,1)","v":{"$error":"#VALUE!"}}]
["Pneu",null,"Compagnie, grandeur","indice de charge","Rayon sous charge"]
["Avant","Int",{"$f":"Rapport_tracteur!I14","v":0},{"$f":"Rapport_tracteur!J14","v":0},{"$f":"Rapport_tracteur!K14","v":0}]
["Avant","Ext",{"$f":"Rapport_tracteur!I15","v":0},{"$f":"Rapport_tracteur!J15","v":0},{"$f":"Rapport_tracteur!K15","v":0}]
["Arrière","Int",{"$f":"Rapport_tracteur!I16","v":0},{"$f":"Rapport_tracteur!J16","v":0},{"$f":"Rapport_tracteur!K16","v":0}]
["Arrière","Ext",{"$f":"Rapport_tracteur!I17","v":0},{"$f":"Rapport_tracteur!J17","v":0},{"$f":"Rapport_tracteur!K17","v":0}]
["Équipement ",1]
["Remarque",{"$f":"INDEX(tabdon,4,3+B8)","v":0},"Remarque",{"$f":"INDEX(tabdon,5,3+B8)","v":0},"Poids puissance",{"$f":"INDEX(tabdon,63,3+B8)","v":0}]
["Type de roue avant","g","Type de roue arrière",{"$f":"INDEX(tabdon,7,3+B8)","v":0},"Poids puissance ",{"$f":"INDEX(tabdon,64,3+B8)","v":0}]
["Poids  ajouté av:",{"$f":"Rapport_tracteur!H41","v":0},"Kg"]
["Vitesse km/h vide",{"$f":"INDEX(tabdon,34,3+B8)","v":0},{"$f":"INDEX(tabdon,38,3+B8)","v":0},"Vitesse km/h vide",{"$f":"INDEX(tabdon,51,3+B8)","v":0},{"$f":"INDEX(tabdon,54,3+B8)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,36,3+B8)","v":0},{"$f":"INDEX(tabdon,39,3+B8)","v":0},"Pression av int",{"$f":"INDEX(tabdon,52,3+B8)","v":0},{"$f":"INDEX(tabdon,55,3+B8)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,37,3+B8)","v":0},{"$f":"INDEX(tabdon,40,3+B8)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,53,3+B8)","v":0},{"$f":"INDEX(tabdon,56,3+B8)","v":0}]
["Vitesse plein",{"$f":"INDEX(tabdon,42,3+B8)","v":0},{"$f":"INDEX(tabdon,45,3+B8)","v":0},"Vitesse plein",{"$f":"INDEX(tabdon,57,3+B8)","v":0},{"$f":"INDEX(tabdon,60,3+B8)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,43,3+B8)","v":0},{"$f":"INDEX(tabdon,46,3+B8)","v":0},"Pression av int",{"$f":"INDEX(tabdon,58,3+B8)","v":0},{"$f":"INDEX(tabdon,61,3+B8)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,44,3+B8)","v":0},{"$f":"INDEX(tabdon,47,3+B8)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,59,3+B8)","v":0},{"$f":"INDEX(tabdon,62,3+B8)","v":0}]
["Équipement ",2]
["Remarque",{"$f":"INDEX(tabdon,4,3+B18)","v":0},"Remarque",{"$f":"INDEX(tabdon,5,3+B18)","v":0},"Poids puissance",{"$f":"INDEX(tabdon,63,3+B18)","v":0}]
["Type de roue avant",{"$f":"INDEX(tabdon,6,3+B18)","v":0},"Type de roue arrière",{"$f":"INDEX(tabdon,7,3+B18)","v":0},"Poids puissance ",{"$f":"INDEX(tabdon,64,3+B18)","v":0}]
["Poids  ajouté av:",{"$f":"Rapport_tracteur!I41","v":0},"kg"]
["Vitesse km/h vide",{"$f":"INDEX(tabdon,34,3+B18)","v":0},{"$f":"INDEX(tabdon,38,3+B18)","v":0},"Vitesse km/h vide",{"$f":"INDEX(tabdon,51,3+B18)","v":0},{"$f":"INDEX(tabdon,54,3+B18)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,36,3+B18)","v":0},{"$f":"INDEX(tabdon,39,3+B18)","v":0},"Pression av int",{"$f":"INDEX(tabdon,52,3+B18)","v":0},{"$f":"INDEX(tabdon,55,3+B18)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,37,3+B18)","v":0},{"$f":"INDEX(tabdon,40,3+B18)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,53,3+B18)","v":0},{"$f":"INDEX(tabdon,56,3+B18)","v":0}]
["Vitesse plein",{"$f":"INDEX(tabdon,42,3+B18)","v":0},{"$f":"INDEX(tabdon,45,3+B18)","v":0},"Vitesse plein",{"$f":"INDEX(tabdon,57,3+B18)","v":0},{"$f":"INDEX(tabdon,60,3+B18)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,43,3+B18)","v":0},{"$f":"INDEX(tabdon,46,3+B18)","v":0},"Pression av int",{"$f":"INDEX(tabdon,58,3+B18)","v":0},{"$f":"INDEX(tabdon,61,3+B18)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,44,3+B18)","v":0},{"$f":"INDEX(tabdon,47,3+B18)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,59,3+B18)","v":0},{"$f":"INDEX(tabdon,62,3+B18)","v":0}]
["Équipement ",3]
["Remarque",{"$f":"INDEX(tabdon,4,3+B28)","v":0},"Remarque",{"$f":"INDEX(tabdon,5,3+B28)","v":0},"Poids puissance",{"$f":"INDEX(tabdon,63,3+B28)","v":0}]
["Type de roue avant",{"$f":"INDEX(tabdon,6,3+B28)","v":0},"Type de roue arrière",{"$f":"INDEX(tabdon,7,3+B28)","v":0},"Poids puissance ",{"$f":"INDEX(tabdon,64,3+B28)","v":0}]
["Poids  ajouté av:",{"$f":"Rapport_tracteur!J41","v":0},"Kg"]
["Vitesse km/h vide",{"$f":"INDEX(tabdon,34,3+B28)","v":0},{"$f":"INDEX(tabdon,38,3+B28)","v":0},"Vitesse km/h vide",{"$f":"INDEX(tabdon,51,3+B28)","v":0},{"$f":"INDEX(tabdon,54,3+B28)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,36,3+B28)","v":0},{"$f":"INDEX(tabdon,39,3+B28)","v":0},"Pression av int",{"$f":"INDEX(tabdon,52,3+B28)","v":0},{"$f":"INDEX(tabdon,55,3+B28)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,37,3+B28)","v":0},{"$f":"INDEX(tabdon,40,3+B28)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,53,3+B28)","v":0},{"$f":"INDEX(tabdon,56,3+B28)","v":0}]
["Vitesse plein",{"$f":"INDEX(tabdon,42,3+B28)","v":0},{"$f":"INDEX(tabdon,45,3+B28)","v":0},"Vitesse plein",{"$f":"INDEX(tabdon,57,3+B28)","v":0},{"$f":"INDEX(tabdon,60,3+B28)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,43,3+B28)","v":0},{"$f":"INDEX(tabdon,46,3+B28)","v":0},"Pression av int",{"$f":"INDEX(tabdon,58,3+B28)","v":0},{"$f":"INDEX(tabdon,61,3+B28)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,44,3+B28)","v":0},{"$f":"INDEX(tabdon,47,3+B28)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,59,3+B28)","v":0},{"$f":"INDEX(tabdon,62,3+B28)","v":0}]
["Équipement ",4]
["Remarque",{"$f":"INDEX(tabdon,4,3+B38)","v":0},"Remarque",{"$f":"INDEX(tabdon,5,3+B38)","v":0},"Poids puissance",{"$f":"INDEX(tabdon,63,3+B38)","v":0}]
["Type de roue avant",{"$f":"INDEX(tabdon,6,3+B38)","v":0},"Type de roue arrière",{"$f":"INDEX(tabdon,7,3+B38)","v":0},"Poids puissance ",{"$f":"INDEX(tabdon,64,3+B38)","v":0}]
["Poids  ajouté av:",{"$f":"Rapport_tracteur!K41","v":0},"Kg"]
["Vitesse km/h vide",{"$f":"INDEX(tabdon,34,3+B38)","v":0},{"$f":"INDEX(tabdon,38,3+B38)","v":0},"Vitesse km/h vide",{"$f":"INDEX(tabdon,51,3+B38)","v":0},{"$f":"INDEX(tabdon,54,3+B38)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,36,3+B38)","v":0},{"$f":"INDEX(tabdon,39,3+B38)","v":0},"Pression av int",{"$f":"INDEX(tabdon,52,3+B38)","v":0},{"$f":"INDEX(tabdon,55,3+B38)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,37,3+B38)","v":0},{"$f":"INDEX(tabdon,40,3+B38)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,53,3+B38)","v":0},{"$f":"INDEX(tabdon,56,3+B38)","v":0}]
["Vitesse plein",{"$f":"INDEX(tabdon,42,3+B38)","v":0},{"$f":"INDEX(tabdon,45,3+B38)","v":0},"Vitesse plein",{"$f":"INDEX(tabdon,57,3+B38)","v":0},{"$f":"INDEX(tabdon,60,3+B38)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,43,3+B38)","v":0},{"$f":"INDEX(tabdon,46,3+B38)","v":0},"Pression av int",{"$f":"INDEX(tabdon,58,3+B38)","v":0},{"$f":"INDEX(tabdon,61,3+B38)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,44,3+B38)","v":0},{"$f":"INDEX(tabdon,47,3+B38)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,59,3+B38)","v":0},{"$f":"INDEX(tabdon,62,3+B38)","v":0}]
["Équipement",5]
["Remarque",{"$f":"INDEX(tabdon,4,3+B48)","v":0},"Remarque",{"$f":"INDEX(tabdon,5,3+B48)","v":0},"Poids puissance",{"$f":"INDEX(tabdon,63,3+B48)","v":0}]
["Type de roue avant",{"$f":"INDEX(tabdon,6,3+B48)","v":0},"Type de roue arrière",{"$f":"INDEX(tabdon,7,3+B48)","v":0},"Poids puissance ",{"$f":"INDEX(tabdon,64,3+B48)","v":0}]
["Poids  ajouté av:",{"$f":"Rapport_tracteur!L41","v":0},"Kg"]
["Vitesse km/h vide",{"$f":"INDEX(tabdon,34,3+B48)","v":0},{"$f":"INDEX(tabdon,38,3+B48)","v":0},"Vitesse km/h vide",{"$f":"INDEX(tabdon,51,3+B48)","v":0},{"$f":"INDEX(tabdon,54,3+B48)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,36,3+B48)","v":0},{"$f":"INDEX(tabdon,39,3+B48)","v":0},"Pression av int",{"$f":"INDEX(tabdon,52,3+B48)","v":0},{"$f":"INDEX(tabdon,55,3+B48)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,37,3+B48)","v":0},{"$f":"INDEX(tabdon,40,3+B48)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,53,3+B48)","v":0},{"$f":"INDEX(tabdon,56,3+B48)","v":0}]
["Vitesse plein",{"$f":"INDEX(tabdon,42,3+B48)","v":0},{"$f":"INDEX(tabdon,45,3+B48)","v":0},"Vitesse plein",{"$f":"INDEX(tabdon,57,3+B48)","v":0},{"$f":"INDEX(tabdon,60,3+B48)","v":0}]
["Pression arr int",{"$f":"INDEX(tabdon,43,3+B48)","v":0},{"$f":"INDEX(tabdon,46,3+B48)","v":0},"Pression av int",{"$f":"INDEX(tabdon,58,3+B48)","v":0},{"$f":"INDEX(tabdon,61,3+B48)","v":0}]
["Pression arr ext",{"$f":"INDEX(tabdon,44,3+B48)","v":0},{"$f":"INDEX(tabdon,47,3+B48)","v":0},"Pression av ext",{"$f":"INDEX(tabdon,59,3+B48)","v":0},{"$f":"INDEX(tabdon,62,3+B48)","v":0}]
[]
[]
["Prenez le temps lors du remisage de remonter la pression de vos pneus à la pression maximale du pneu pour diminuer les fendillements. Pensez à changer les liquides des pneus radiaux pour les poids que vous pourriez enlever au besoin."]
[]
["Conception Bruno Garon ing.","2021-06-01"]
[]
["Pour les roues doubles et triples, prenez la charge par essieu divisé par le nombre de roues et le facteur 0,88 ou 0,82."]

{"sheet":"Compilation des données","index":7,"n_rows":7,"n_cols":98,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Nom du Club","Adresse","Ville","Code postal","Nom du conseiller","No de téléphone","Nom de l'entreprise","Nom du producteur","Ville","Essai no :","Tracteur no :","Remarque","Remarque","Type de roues avant","Type de roues arrière","Catégorie de l'équipement","Empattement","déportance avant","déportance arrière","Équipement arrière","Poids équipement","Poids équipement à vide","poids roues arrière","Poids essieu arrière vide ","Poids total arrière vide","Poids essieu arrière plein","Poids total arrière plein","Répartition arrière vide","Répartition arrière plein","Équipement avant","Poids équipement","Poids Roue avant","Poids essieu avant vide","Poids total avant vide","Poids essieu avant plein","Poids total avant plein","Répartition avant vide","Répartition avant plein","Poids total vide","Poids total plein","Pneu arrière","Vitesse","Poids Pneu arrière vide","Pression arrière int. Vide","Pression arrière ext.vide","Vitesse","Pression arrière int. vide","Pression arrière ext. Vide","Poids Pneu arrière plein","Vitesse plein","Pression arrière int. Plein","Pression arrière ext.plein","Vitesse","Pression arrière int.plein","Pression arrière ext. Plein","Pneu avant","Poids Pneu avant","poids pneu équipement vide","Vitesse vide","Pression avant int. Vide","Pression avant ext. Vide","Vitesse","Pression avant int. Vide","Pression avant ext. Vide","Vitesse plein","Pression avant int. Plein","Pression avant ext. Plein","Vitesse","Pression avant int. plein","Pression avant ext. plein","Rapport de charge","Rapport de charge","Puissance PDF    ","Puissance PDF    ","Ext G Av","Int G Av","Int D Av","Ext D Av","Ext G Ar","Int G Ar","Int D Ar","Ext D Ar",null,"Compagnie, grandeur","indice de charge","Rayon sous charge",null,"Compagnie, grandeur",null,null,null,"Compagnie, grandeur",null,null,null,"Compagnie, grandeur"]
["XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","m","m","m","m","kg","kg","kg","kg","kg","kg","kg","%","%",null,"kg","kg","kg","kg","kg","kg","%","XXXXXXX","kg","kg","xxx","Km/h","Kg","Psi","Psi","Km/h","Psi","Psi","kg","Km/h","Psi","Psi","Km/h","Psi","Psi","XXXXXXX","Kg","Kg","Km/h","Psi","Psi","Km/h","Psi","Psi","Km/h","Psi","Psi","Km/h","Psi","Psi","Lb/Hp","Kg/HP","Hp","KW","Psi","Psi","Psi","Psi","Psi","Psi","Psi","Psi","Pneu","Avant",null,null,"Avant",null,null,null,"Arrière",null,null,null,"Arrière"]
[{"$f":"Informations!K9","v":"Votre club"},{"$f":"Informations!K10","v":0},{"$f":"Informations!K11","v":0},{"$f":"Informations!K12","v":0},{"$f":"Informations!K13","v":"Bruno Garon, ing"},{"$f":"Informations!K14","v":"450-779-2669"},{"$f":"Informations!K15","v":0},{"$f":"Informations!K16","v":0},{"$f":"Informations!K17","v":0},{"$f":"'schéma tracteur'!$T$11","v":1},{"$f":"'schéma tracteur'!$T$12","v":0},{"$f":"'schéma tracteur'!$T$13","v":0},{"$f":"'schéma tracteur'!$T$14","v":0},{"$f":"'schéma tracteur'!$Y$21","v":"Simple"},{"$f":"'schéma tracteur'!$E$25","v":"Simple"},{"$f":"'schéma tracteur'!$C$10","v":"Trainé"},{"$f":"'schéma tracteur'!$O$37","v":0},{"$f":"'schéma tracteur'!$V$37","v":0},{"$f":"'schéma tracteur'!$G$37","v":0},{"$f":"'schéma tracteur'!$C$12","v":0},{"$f":"'schéma tracteur'!$E$17","v":0},{"$f":"'schéma tracteur'!$E$20","v":0},{"$f":"'schéma tracteur'!$J$18","v":0},{"$f":"'schéma tracteur'!$J$31","v":""},{"$f":"'schéma tracteur'!$G$31","v":""},{"$f":"'schéma tracteur'!$J$34","v":""},{"$f":"'schéma tracteur'!$G$34","v":""},{"$f":"ROUND('schéma tracteur'!$M$26:$M$26,1)","v":{"$error":"#VALUE!"}},{"$f":"'schéma tracteur'!$M$28","v":""},{"$f":"'schéma tracteur'!$Y$19","v":0},{"$f":"'schéma tracteur'!$Y$17","v":0},{"$f":"'schéma tracteur'!$T$22","v":0},{"$f":"'schéma tracteur'!$T$31","v":""},{"$f":"'schéma tracteur'!$V$31","v":""},{"$f":"'schéma tracteur'!$T$34","v":""},{"$f":"'schéma tracteur'!$V$34","v":""},{"$f":"ROUND('schéma tracteur'!$Q$26,1)","v":{"$error":"#VALUE!"}},{"$f":"'schéma tracteur'!$Q$28","v":""},{"$f":"'schéma tracteur'!$B$32","v":""},{"$f":"'schéma tracteur'!$B$34","v":""},"xxxxxxxxxxxxxxx",{"$f":"'schéma tracteur'!$H$49","v":10},{"$f":"'schéma tracteur'!$J$44","v":""},{"$f":"'schéma tracteur'!$H$50","v":0},{"$f":"'schéma tracteur'!$H$51","v":0},{"$f":"'schéma tracteur'!$K$49","v":30},{"$f":"'schéma tracteur'!$K$50","v":0},{"$f":"'schéma tracteur'!$K$51","v":0},{"$f":"'schéma tracteur'!$J$45","v":""},{"$f":"'schéma tracteur'!$H$53","v":10},{"$f":"'schéma tracteur'!$H$54","v":0},{"$f":"'schéma tracteur'!$H$55","v":0},{"$f":"'schéma tracteur'!$K$53","v":30},{"$f":"'schéma tracteur'!$K$54","v":0},{"$f":"'schéma tracteur'!$K$55","v":0},"xxxxxxxxxxxxxxx",{"$f":"'schéma tracteur'!$W$44","v":""},{"$f":"'schéma tracteur'!$W$45","v":""},{"$f":"'schéma tracteur'!$T$49","v":10},{"$f":"'schéma tracteur'!$T$50","v":0},{"$f":"'schéma tracteur'!$T$51","v":0},{"$f":"'schéma tracteur'!$V$49","v":30},{"$f":"'schéma tracteur'!$V$50","v":0},{"$f":"'schéma tracteur'!$V$51","v":0},{"$f":"'schéma tracteur'!$T$53","v":10},{"$f":"'schéma tracteur'!$T$54","v":0},{"$f":"'schéma tracteur'!$T$55","v":0},{"$f":"'schéma tracteur'!$V$53","v":30},{"$f":"'schéma tracteur'!$V$54","v":0},{"$f":"'schéma tracteur'!$V$55","v":0},{"$f":"ROUND('schéma tracteur'!$G$6,1)","v":{"$error":"#VALUE!"}},{"$f":"ROUND('schéma tracteur'!$G$5,1)","v":{"$error":"#VALUE!"}},{"$f":"'schéma tracteur'!$E$2","v":0},{"$f":"BU3*0.746","v":0},{"$f":"'schéma tracteur'!$W$3","v":0},{"$f":"'schéma tracteur'!$V$3","v":0},{"$f":"'schéma tracteur'!$V$4","v":0},{"$f":"'schéma tracteur'!$W$4","v":0},{"$f":"'schéma tracteur'!$W$5","v":0},{"$f":"'schéma tracteur'!$V$5","v":0},{"$f":"'schéma tracteur'!$V$6","v":0},{"$f":"'schéma tracteur'!$W$6","v":0},"Int",{"$f":"'schéma tracteur'!$W$28","v":0},{"$f":"'schéma tracteur'!$AB$28","v":0},{"$f":"'schéma tracteur'!$W$50","v":0},"Ext",{"$f":"'schéma tracteur'!CU17","v":0},{"$f":"'schéma tracteur'!$AB$29","v":0},{"$f":"'schéma tracteur'!$W$51","v":0},"Int",{"$f":"'schéma tracteur'!$C$28","v":0},{"$f":"'schéma tracteur'!$H$28","v":0},{"$f":"'schéma tracteur'!$M$50","v":0},"Ext",{"$f":"'schéma tracteur'!$C$29","v":0},{"$f":"'schéma tracteur'!$H$29","v":0},{"$f":"'schéma tracteur'!$M$51","v":0}]
[]
["Nom du Club","Adresse","Ville","Code postal","Nom du conseiller","No de téléphone","Nom de l'entreprise","Nom du producteur","Ville","Essai no :","Tracteur no :","Remarque","Remarque","Type de roues avant","Type de roues arrière","Catégorie de l'équipement","Empattement","déportance avant","déportance arrière","Équipement arrière","Poids équipement","Poids équipement à vide","poids roues arrière","Poids essieu arrière vide ","Poids total arrière vide","Poids essieu arrière plein","Poids total arrière plein","Répartition arrière vide","Répartition arrière plein","Équipement avant","Poids équipement","Poids Roue avant","Poids essieu avant vide","Poids total avant vide","Poids essieu avant plein","Poids total avant plein","Répartition avant vide","Répartition avant plein","Poids total vide","Poids total plein","Pneu arrière","Vitesse","Poids Pneu arrière vide","Pression arrière int. Vide","Pression arrière ext.vide","Vitesse","Pression arrière int. vide","Pression arrière ext. Vide","Poids Pneu arrière plein","Vitesse plein","Pression arrière int. Plein","Pression arrière ext.plein","Vitesse","Pression arrière int.plein","Pression arrière ext. Plein","Pneu avant","Poids Pneu avant","poids pneu équipement vide","Vitesse vide","Pression avant int. Vide","Pression avant ext. Vide","Vitesse","Pression avant int. Vide","Pression avant ext. Vide","Vitesse plein","Pression avant int. Plein","Pression avant ext. Plein","Vitesse","Pression avant int. plein","Pression avant ext. plein","Rapport de charge","Rapport de charge","Puissance PDF    ","Puissance PDF    ","Ext G Av","Int G Av","Int D Av","Ext D Av","Ext G Ar","Int G Ar","Int D Ar","Ext D Ar",null,"Compagnie, grandeur","indice de charge","Rayon sous charge",null,"Compagnie, grandeur",null,null,null,"Compagnie, grandeur",null,null,null,"Compagnie, grandeur"]
["XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","XXXXXXX","m","m","m","m","kg","kg","kg","kg","kg","kg","kg","%","%"]
["aa","ss","dd","ff","Bruno Garon, ing","asw","dh","dh","dhsa",1,"Jonh Derre",6130,0,"Double","Double","semi portée",3,1.2,1,0,1000,0,250,10000,11383.333333333334,10400,11783.333333333334,63.8,72.512820512820525,0,500,100,6000,6466.666666666667,4000,4466.666666666667,36.200000000000003,27.487179487179493,17850,16250,"xxxxxxxxxxxxxxx",10,3233.9015151515155,10,9,30,12,11,3347.537878787879,10,10.5,9.5,30,11.5,10.5,"xxxxxxxxxxxxxxx",1837.1212121212122,1931.8181818181818,10,14,13,30,16,15,10,13,12,30,14,13,392.7,178.5,100,74.599999999999994,0,12,13,0,0,14,14,0,"Int","michelin","143D",666,"Ext",0,"143D",666,"Int","michelin","158A8",555,"Ext","michelin","158A8",555]

{"sheet":"avertisement","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Batteuse Chenille","index":9,"n_rows":113,"n_cols":25,"rows_kept":113,"cut":false,"hidden":false,"merged":[[15,3,15,6],[2,3,2,6],[22,3,22,6],[37,3,37,6],[0,4,0,6],[95,3,95,6],[109,0,109,1],[51,0,51,1],[58,4,58,6],[60,3,60,6],[73,3,73,6],[80,3,80,6]]}
["Moisonneuse batteuse à chenille",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colonne1","Colonne2","Colonne3","Colonne4"]
["Sans nez",null,null,null,null,null,null,null,"Volume du réservoir carburant",null,null,"% de répartition",null,null,null,null,null,null,null,null,null,"A_Choisir","Vide","kg/m3","Source agri réseau"]
["Total","Poids","Pression","Poids chenille",null,null,null,"Peak",null,0.83499999999999996,{"$f":"I3*J3","v":0},0.8,null,null,null,null,null,null,null,null,null,"Blé:",1,840]
[{"$f":"+B4+E5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canola:",2,800]
["Pneu",{"$f":"B4+K3*L3/2","v":0},null,null,{"$f":"SUM(D4:G4)","v":0},{"$f":"ROUND(E5+K3*(1-L3)/2,0)","v":0},null,{"$f":"H4/E5","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Maïs:",3,800]
[null,null,null,null,"Dimension",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orge:",4,650]
["Vf 750/65R26",null,null,null,null,{"$f":"E5/F6/G6","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pois:",5,820]
["180 A8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sarrasin:",6,670]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soya:",7,780]
["Total balance"]
[{"$f":"A4+A17","v":0}]
["Total Carburant"]
[{"$f":"A11+K3","v":0}]
[]
[]
["Total","Poids","Pression","Poids chenille",null,null,null,"Peak"]
[{"$f":"+B17+E18","v":0}]
[null,{"$f":"B17+K3*L3/2","v":0},null,null,{"$f":"SUM(D17:G17)","v":0},{"$f":"ROUND(E18+K3*(1-L3)/2,0)","v":0},null,{"$f":"H17/E18","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"E18/F6/G6","v":{"$error":"#DIV/0!"}}]
[]
["Moisonneuse batteuse à chenille",null,null,null,{"$f":"E1","v":0}]
["Avec le nez à maïs 12 rangs",null,null,null,null,null,null,null,"Volume du réservoir carburant",null,null,"% de répartition"]
["Total",null,null,null,null,null,null,null,null,{"$f":"J3","v":0.83499999999999996},0,0.8]
[{"$f":"+B24+E25","v":0},null,null,null,null,null,null,null,null,null,"% répartition",0.65]
[null,null,null,null,{"$f":"SUM(D24:G24)","v":0},null,null,{"$f":"H24/E25","v":{"$error":"#DIV/0!"}},"Volume de grains",null,"Masse vol","Poids"]
[null,null,null,null,{"$f":"E6","v":"Dimension"},null,null,null,null,"Maïs:",{"$f":"VLOOKUP(J26,tab_grains,3)","v":800},{"$f":"I26*1.25/35.3*K26/(1-I28)","v":0}]
[null,null,null,null,null,{"$f":"F25/F26/G26","v":{"$error":"#DIV/0!"}},null,null,"Taux d'humidité",null,{"$f":"I26*1.25/35.38*1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poids total"]
[null,null,null,null,null,null,null,null,null,null,"Arrière /2","Avant /2"]
["Total balance",null,null,null,null,null,null,null,null,null,{"$f":"K23*L23/2","v":0},{"$f":"K23*(1-L23)/2","v":0},"Poids essence",null,{"$f":"(K30+L30)*2","v":0}]
[{"$f":"A24+A39","v":0},null,null,null,null,null,null,null,"Poids du nez avant",null,{"$f":"L26*(1-L24)/2","v":0},{"$f":"L26*L24/2","v":0},"Poids grains",null,{"$f":"(K31+L31)*2","v":0}]
["Total ",null,null,null,null,null,null,null,null,null,{"$f":"-I32*J37/J36/2","v":{"$error":"#DIV/0!"}},{"$f":"(I32+I32*J37/J36)/2","v":{"$error":"#DIV/0!"}},"poids nez ",null,{"$f":"(K32+L32)*2","v":{"$error":"#DIV/0!"}}]
[{"$f":"ROUND(A31+L26+I32+K23,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"B4","v":0},{"$f":"E5","v":0}]
["Différence",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K30:K33)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L30:L33)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A33-A13","v":0},null,null,null,null,null,null,null,null,null,{"$f":"B17","v":0},{"$f":"E18","v":0}]
[null,null,null,null,null,null,null,null,"Emp",null,{"$f":"+K30+K31+K32+K35","v":{"$error":"#DIV/0!"}},{"$f":"L30+L31+L32+L35","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"déportance "]
["Total"]
[{"$f":"+B39+E40","v":0}]
[null,{"$f":"IF(B39=0,B17+K23*L23/2+L26*(1-L24)/2,B39+K23*L23/2+L26*(1-L24)/2)-I32*J37/J36/2","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(D39:G39)","v":0},{"$f":"IF(D39=0,ROUND(E18+K23*(1-L23)/2+L26*L24/2,0),+ROUND(E40+K23*(1-L23)/2+L26*L24/2,0))+ROUND(I32+I32*J37/J36,0)/2","v":{"$error":"#DIV/0!"}},null,{"$f":"H39/E40","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"F40/F26/G26","v":{"$error":"#DIV/0!"}}]
[]
[]
["Poids batteuse sans le nez ni grain"]
["Résumé",null,"Poids essieu/chenille","Poids à la roue ou chenille","Nb roue","Poids avec essence","Poids à la roue/Chenille"]
["Essieu avant",null,{"$f":"D4+E4+D17+E17","v":0},{"$f":"C46/E46","v":0},4,{"$f":"ROUND(F5+F18,0)","v":0},{"$f":"F46/E46","v":0}]
["Essieu arrière",null,{"$f":"B4+B17","v":0},{"$f":"C47/E47","v":0},2,{"$f":"ROUND(B5+B18,0)","v":0},{"$f":"F47/E47","v":0}]
["Pneu essieu avant",null,{"$f":"E19","v":0},{"$error":"#DIV/0!"},0]
[null,null,0,0,0]
["Pneu essieu arriàre",null,{"$f":"A6","v":0},{"$f":"A7","v":"Vf 750/65R26"},{"$f":"A8","v":"180 A8"}]
[]
["Poids de la batteuse en charge avec le grain",null,"Poids essieu/Chenille","Poids à la roue/chenille","Nb roue","Poids total","Poids à la roue/chenille"]
["Essieu avant",null,{"$f":"E25+E40","v":0},{"$f":"C53/E53","v":0},4,{"$f":"ROUND(+F25+F40,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F53/E53,0)","v":{"$error":"#DIV/0!"}}]
["Essieu arrière",null,{"$f":"B24+B39","v":0},{"$f":"C54/E54","v":0},2,{"$f":"ROUND(B25+B40,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F54/E54,0)","v":{"$error":"#DIV/0!"}}]
["Grain",{"$f":"ROUND(I26,0)","v":0},{"$f":"K26","v":800},{"$f":"I28","v":0},{"$f":"L24","v":0.65},{"$f":"ROUND(L26,0)","v":0}]
[]
[]
[]
["Moisonneuse batteuse à chenille",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colonne1","Colonne2","Colonne3","Colonne4"]
["Sans nez",null,null,null,null,null,null,null,"Volume du réservoir carburant",null,null,"% de répartition",null,null,null,null,null,null,null,null,null,"A_Choisir","Vide","kg/m3","Source agri réseau"]
["Total","Poids","Pression","Poids chenille",null,null,null,"Peak",null,0.83499999999999996,{"$f":"I61*J61","v":0},0.8,null,null,null,null,null,null,null,null,null,"Blé:",1,840]
[{"$f":"+B62+E63","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canola:",2,800]
["Pneu",{"$f":"B62+K61*L61/2","v":0},null,null,{"$f":"SUM(D62:G62)","v":0},{"$f":"ROUND(E63+K61*(1-L61)/2,0)","v":0},null,{"$f":"H62/E63","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Maïs:",3,800]
[null,null,null,null,"Dimension",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orge:",4,650]
[null,null,null,null,null,{"$f":"E63/F64/G64","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pois:",5,820]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sarrasin:",6,670]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soya:",7,780]
["Total balance"]
[{"$f":"A62+A75","v":0}]
["Total Carburant"]
[{"$f":"A69+K61","v":0}]
[]
[]
["Total","Poids","Pression","Poids chenille",null,null,null,"Peak"]
[{"$f":"+B75+E76","v":0}]
[null,{"$f":"B75+K61*L61/2","v":0},null,null,{"$f":"SUM(D75:G75)","v":0},{"$f":"ROUND(E76+K61*(1-L61)/2,0)","v":0},null,{"$f":"H75/E76","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"E76/F64/G64","v":{"$error":"#DIV/0!"}}]
[]
["Moisonneuse batteuse à chenille"]
["Avec le nez à maïs 12 rangs",null,null,null,null,null,null,null,"Volume du réservoir carburant",null,null,"% de répartition"]
["Total","Poids","Pression","Poids chenille",null,null,null,"Peak",null,{"$f":"J61","v":0.83499999999999996},0,0.8]
[{"$f":"+B82+E83","v":0},null,null,null,null,null,null,null,null,null,"% répartition",0.65]
[null,{"$f":"IF(B82=0,B62+K81*L81/2+L84*(1-L82)/2,B82+K81*L81/2+L84*(1-L82)/2)-I90*J95/J94/2","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(D82:G82)","v":0},{"$f":"IF(D82=0,ROUND(E63+K81*(1-L81)/2+L84*L82/2,0),+ROUND(E83+K81*(1-L81)/2+L84*L82/2,0))+ROUND(I90+I90*J95/J94,0)/2","v":{"$error":"#DIV/0!"}},null,{"$f":"H82/E83","v":{"$error":"#DIV/0!"}},"Volume de grains",null,"Masse vol","Poids"]
[null,null,null,null,{"$f":"E64","v":"Dimension"},null,null,null,null,"Maïs:",{"$f":"VLOOKUP(J84,tab_grains,3)","v":800},{"$f":"I84*1.25/35.3*K84/(1-I86)","v":0}]
[null,null,null,null,null,{"$f":"F83/F84/G84","v":{"$error":"#DIV/0!"}},null,null,"Taux d'humidité",null,{"$f":"I84*1.25/35.38*1000","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poids total"]
[null,null,null,null,null,null,null,null,null,null,"Arrière /2","Avant /2"]
["Total balance",null,null,null,null,null,null,null,null,null,{"$f":"K81*L81/2","v":0},{"$f":"K81*(1-L81)/2","v":0},"Poids essence",null,{"$f":"(K88+L88)*2","v":0}]
[{"$f":"A82+A97","v":0},null,null,null,null,null,null,null,"Poids du nez avant",null,{"$f":"L84*(1-L82)/2","v":0},{"$f":"L84*L82/2","v":0},"Poids grains",null,{"$f":"(K89+L89)*2","v":0}]
["Total ",null,null,null,null,null,null,null,null,null,{"$f":"-I90*J95/J94/2","v":{"$error":"#DIV/0!"}},{"$f":"(I90+I90*J95/J94)/2","v":{"$error":"#DIV/0!"}},"poids nez ",null,{"$f":"(K90+L90)*2","v":{"$error":"#DIV/0!"}}]
[{"$f":"ROUND(A89+L84+I90+K81,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"B62","v":0},{"$f":"E63","v":0}]
["Différence",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K88:K91)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L88:L91)","v":{"$error":"#DIV/0!"}}]
[{"$f":"A91-A71","v":0},null,null,null,null,null,null,null,null,null,{"$f":"B75","v":0},{"$f":"E76","v":0}]
[null,null,null,null,null,null,null,null,"Emp",null,{"$f":"+K88+K89+K90+K93","v":{"$error":"#DIV/0!"}},{"$f":"L88+L89+L90+L93","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"déportance "]
["Total","Poids","Pression","Poids chenille",null,null,null,"Peak"]
[{"$f":"+B97+E98","v":0}]
[null,{"$f":"IF(B97=0,B75+K81*L81/2+L84*(1-L82)/2,B97+K81*L81/2+L84*(1-L82)/2)-I90*J95/J94/2","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(D97:G97)","v":0},{"$f":"IF(D97=0,ROUND(E76+K81*(1-L81)/2+L84*L82/2,0),+ROUND(E98+K81*(1-L81)/2+L84*L82/2,0))+ROUND(I90+I90*J95/J94,0)/2","v":{"$error":"#DIV/0!"}},null,{"$f":"H97/E98","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"F98/F84/G84","v":{"$error":"#DIV/0!"}}]
[]
[]
["Poids batteuse sans le nez ni grain"]
["Résumé",null,"Poids essieu/chenille","Poids à la roue ou chenille","Nb roue","Poids avec essence","Poids à la roue/Chenille"]
["Essieu avant",null,{"$f":"D62+E62+D75+E75","v":0},{"$f":"C104/E104","v":0},4,{"$f":"ROUND(F63+F76,0)","v":0},{"$f":"F104/E104","v":0}]
["Essieu arrière",null,{"$f":"B62+B75","v":0},{"$f":"C105/E105","v":0},2,{"$f":"ROUND(B63+B76,0)","v":0},{"$f":"F105/E105","v":0}]
["Pneu essieu avant",null,{"$f":"E77","v":0},{"$f":"F77","v":{"$error":"#DIV/0!"}},{"$f":"G77","v":0}]
[null,null,0,0,0]
["Pneu essieu arriàre",null,{"$f":"A64","v":0},{"$f":"A65","v":0},{"$f":"A66","v":0}]
[]
["Poids de la batteuse en charge avec le grain",null,"Poids essieu/Chenille","Poids à la roue/chenille","Nb roue","Poids total","Poids à la roue/chenille"]
["Essieu avant",null,{"$f":"E83+E98","v":0},{"$f":"C111/E111","v":0},4,{"$f":"ROUND(+F83+F98,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F111/E111,0)","v":{"$error":"#DIV/0!"}}]
["Essieu arrière",null,{"$f":"B82+B97","v":0},{"$f":"C112/E112","v":0},2,{"$f":"ROUND(B83+B98,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F112/E112,0)","v":{"$error":"#DIV/0!"}}]
["Grain",{"$f":"ROUND(I84,0)","v":0},{"$f":"K84","v":800},{"$f":"I86","v":0},{"$f":"L82","v":0.65},{"$f":"ROUND(L84,0)","v":0}]

{"sheet":"Batteuse Roue","index":10,"n_rows":55,"n_cols":25,"rows_kept":55,"cut":false,"hidden":false,"merged":[[51,0,51,1],[22,5,22,6],[0,4,0,6],[2,3,2,4],[2,5,2,6],[15,3,15,4],[15,5,15,6],[22,3,22,4],[37,3,37,4],[37,5,37,6]]}
[null,null,null,"Batteuse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Colonne1","Colonne2","Colonne3","Colonne4"]
["Sans nez",null,null,null,null,null,null,null,"Volume du réservoir carburant",null,null,"% de répartition",null,null,null,null,null,null,null,null,null,"A_Choisir","Vide","kg/m3","Source agri réseau"]
["Total","Poids","Pression","Poids roue",null,"Pression",null,null,null,0.83499999999999996,{"$f":"I3*J3","v":0},0.7,null,null,null,null,null,null,null,null,null,"Blé:",1,840]
[{"$f":"+B4+E5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Canola:",2,800]
["Pneu",{"$f":"B4+K3*L3/2","v":0},null,null,{"$f":"SUM(D4:E4)","v":0},{"$f":"ROUND(E5+K3*(1-L3)/2,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maïs:",3,800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orge:",4,650]
["Vf 750/65R26",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pois:",5,820]
["180A8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sarrasin:",6,670]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soya:",7,780]
["Total balance"]
[{"$f":"A4+A17","v":0}]
[]
["Total  carburant"]
[{"$f":"ROUND(B5+F5+F18+B18,0)","v":0}]
[]
["Total","Poids","Pression","Poids roue",null,"Pression"]
[{"$f":"+B17+E18","v":0}]
[null,{"$f":"B17+K3*L3/2","v":0},null,null,{"$f":"SUM(D17:E17)","v":0},{"$f":"ROUND(E18+K3*(1-L3)/2,0)","v":0}]
[null,null,"Pneu intérieur","Michelin "]
[null,null,"Pneu extérieur","Michelin "]
[null,null,null,null,{"$f":"E1","v":0}]
["Avec le nez à maïs 12 rangs",null,null,null,null,null,null,null,"Volume du réservoir carburant",null,null,"% répartition"]
["Total","Poids","Pression","Poids roue",null,"Pression",null,null,400,{"$f":"J3","v":0.83499999999999996},0,0.8]
[{"$f":"+B24+E25","v":0},null,null,null,null,null,null,null,null,null,"% répartition",0.6]
[null,{"$f":"IF(B24=0,B4+$K$23*$L$23/2+$L$26*(1-$L$24)/2,B24+$K$23*$L$23/2+$L$26*(1-$L$24)/2)-$I$32*$J$37/$J$36/2","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(D24:E24)","v":0},{"$f":"IF(D24=0,ROUND(E5+$K$23*(1-$L$23)/2+$L$26*$L$24/2,0),+ROUND(E25+$K$23*(1-$L$23)/2+$L$26*$L$24/2,0))+ROUND($I$32+$I$32*$J$37/$J$36,0)/2","v":{"$error":"#DIV/0!"}},null,null,"Volume de grains",null,"Masse vol","Poids"]
[null,null,null,null,"Roue",{"$f":"F25/2","v":{"$error":"#DIV/0!"}},null,null,null,"Maïs:",{"$f":"VLOOKUP(J26,tab_grains,3)","v":800},{"$f":"ROUND(I26*1.25/35.3*K26/(1-I28),0)","v":0}]
[null,null,null,null,null,null,null,null,"Taux d'humidité",null,{"$f":"I26*1.25/35.38*1000","v":0}]
[null,null,null,null,null,null,null,null,0.24,null,null,null,null,null,"Poids total"]
[null,null,null,null,null,null,null,null,null,null,"Arrière /2","Avant /2"]
["Total balance",null,null,null,null,null,null,null,null,null,{"$f":"K23*L23/2","v":0},{"$f":"K23*(1-L23)/2","v":0},"Poids essence",null,{"$f":"(K30+L30)*2","v":0}]
[{"$f":"A24+A39","v":0},null,null,null,null,null,null,null,"Poids du nez avant",null,{"$f":"L26*(1-L24)/2","v":0},{"$f":"L26*L24/2","v":0},"Poids grains",null,{"$f":"(K31+L31)*2","v":0}]
[null,null,null,null,null,null,null,null,0,null,{"$f":"-I32*J37/J36/2","v":{"$error":"#DIV/0!"}},{"$f":"(I32+I32*J37/J36)/2","v":{"$error":"#DIV/0!"}},"poids nez ",null,{"$f":"(K32+L32)*2","v":{"$error":"#DIV/0!"}}]
["Total  ",null,null,null,null,null,null,null,null,null,{"$f":"B4","v":0},{"$f":"E5","v":0}]
[{"$f":"ROUND(A31+L26+I32+K23,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(K30:K33)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L30:L33)","v":{"$error":"#DIV/0!"}}]
["Différence",null,null,null,null,null,null,null,null,null,{"$f":"B17","v":0},{"$f":"E18","v":0}]
[{"$f":"A34-A14","v":0},null,null,null,null,null,null,null,"Emp",null,{"$f":"K30+K31+K32+K35","v":{"$error":"#DIV/0!"}},{"$f":"L30+L31+L32+L35","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"déportance "]
["Total","Poids","Pression","Poids roue",null,"Pression"]
[{"$f":"+B39+E40","v":0}]
[null,{"$f":"IF(B39=0,B17+$K$23*$L$23/2+$L$26*(1-$L$24)/2,B39+$K$23*$L$23/2+$L$26*(1-$L$24)/2)-$I$32*$J$37/$J$36/2","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(D39:E39)","v":0},{"$f":"IF(D39=0,ROUND(E18+$K$23*(1-$L$23)/2+$L$26*$L$24/2,0),+ROUND(E40+$K$23*(1-$L$23)/2+$L$26*$L$24/2,0))+ROUND($I$32+$I$32*$J$37/$J$36,0)/2","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Roue",{"$f":"F40/2","v":{"$error":"#DIV/0!"}}]
[]
[]
["Poids batteuse sans le nez ni grain"]
["Résumé",null,"Poids essieu/chenille","Poids à la roue ou chenille","Nb roue","Poids avec essence","Poids à la roue/Chenille"]
["Essieu avant",null,{"$f":"D4+E4+D17+E17","v":0},{"$f":"C46/E46","v":0},4,{"$f":"ROUND(F5+F18,0)","v":0},{"$f":"F46/E46","v":0}]
["Essieu arrière",null,{"$f":"B4+B17","v":0},{"$f":"C47/E47","v":0},2,{"$f":"ROUND(B5+B18,0)","v":0},{"$f":"F47/E47","v":0}]
["Pneu essieu avant",null,{"$f":"E19","v":0},0,0]
[null,null,0,0,0]
["Pneu essieu arriàre",null,{"$f":"A6","v":0},{"$f":"A7","v":"Vf 750/65R26"},{"$f":"A8","v":"180A8"}]
[]
["Poids de la batteuse en charge avec le grain",null,"Poids essieu/Chenille","Poids à la roue/chenille","Nb roue","Poids total","Poids à la roue/chenille"]
["Essieu avant",null,{"$f":"E25+E40","v":0},{"$f":"C53/E53","v":0},4,{"$f":"ROUND(+F25+F40,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F53/E53,0)","v":{"$error":"#DIV/0!"}}]
["Essieu arrière",null,{"$f":"B24+B39","v":0},{"$f":"C54/E54","v":0},2,{"$f":"ROUND(B25+B40,0)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(F54/E54,0)","v":{"$error":"#DIV/0!"}}]
["Grain",{"$f":"I26","v":0},{"$f":"K26","v":800},{"$f":"I28","v":0.24},{"$f":"L24","v":0.6},{"$f":"L26","v":0}]

{"sheet":"Résumé batteuse","index":11,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Poids batteuse sans le nez ni grain","Batteuse 1",null,null,"Poids batteuse sans le nez ni grain","Batteuse 1"]
["Résumé","Poids avec essence","Poids à la roue/Chenille",null,"Résumé","Poids avec essence","Poids à la roue/Chenille"]
["Essieu avant",17588,4397,"/4","Essieu avant",17588,4397]
["Essieu arrière",9428,4714,"/2","Essieu arrière",9428,4714]
["Pneu essieu avant",null,null,null,"Pneu essieu avant"]
[]
["Pneu essieu arriàre",null,null,null,"Pneu essieu arriàre"]
[null,"Poids estimé avec essence et grain +nez",null,null,null,"Poids estimé avec essence et grain +nez"]
["Poids de la batteuse en charge avec le grain","Poids total","Poids à la roue/chenille",null,"Poids de la batteuse en charge avec le grain","Poids total","Poids à la roue/chenille"]
["Essieu avant",33630,8408,"/4","Essieu avant",33630,8408]
["Essieu arrière",10913,5457,"2","Essieu arrière",10913,5457]
[]
[null,"Batteuse 2",null,null,null,"Batteuse 2"]
["Poids batteuse sans le nez ni grain","Poids avec essence","Poids à la roue/Chenille",null,"Poids batteuse sans le nez ni grain","Poids avec essence","Poids à la roue/Chenille"]
["Résumé",21230,5307.5,"/4","Résumé",21230,5307.5]
["Essieu avant",8242,4121,"/2","Essieu avant",8242,4121]
["Essieu arrière",null,null,null,"Essieu arrière"]
["Pneu essieu avant",null,null,null,"Pneu essieu avant"]
[]
["Pneu essieu arriàre",null,null,null,"Pneu essieu arriàre"]
[null,"Poids estimé avec essence et grain +nez",null,null,null,"Poids estimé avec essence et grain +nez"]
["Poids de la batteuse en charge avec le grain","Poids total","Poids à la roue/chenille",null,"Poids de la batteuse en charge avec le grain","Poids total","Poids à la roue/chenille"]
["Essieu avant",37240,9310,"/4","Essieu avant",32530,8133]
["Essieu arrière",9593,4797,"/2","Essieu arrière",12013,6007]
[]
["Poids batteuse sans le nez ni grain","Batteuse 3",null,null,"Poids batteuse sans le nez ni grain","Batteuse 3"]
["Résumé","Poids avec essence","Poids à la roue/Chenille",null,"Résumé","Poids avec essence","Poids à la roue/Chenille"]
["Essieu avant",14514,3628.5,"/4","Essieu avant",14514,3628.5]
["Essieu arrière",12876,6438,"/2","Essieu arrière",12876,6438]
["Pneu essieu avant",null,null,null,"Pneu essieu avant"]
[]
["Pneu essieu arriàre",null,null,null,"Pneu essieu arriàre"]
[null,"Poids estimé avec essence et grain +nez",null,null,null,"Poids estimé avec essence et grain +nez"]
["Poids de la batteuse en charge avec le grain","Poids total","Poids à la roue/chenille",null,"Poids de la batteuse en charge avec le grain","Poids total","Poids à la roue/chenille"]
["Essieu avant",34458,8615,"/4","Essieu avant",37263,9316]
["Essieu arrière",13676,6838,"/2","Essieu arrière",12324,6162]

{"sheet":"Poids-puissance","index":12,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[31,0,32,0]]}
[]
["Équilibrage du tracteur avec le rapport poids/HP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Puissance du tracteur à la prise de force",null,"HP",200]
[null,null,null,"x",null,625,6,{"$f":"F27/G27","v":104.16666666666667},null,null,null,"Liste","Avant/arrière"]
["Sélection du rapport de poids / puissance",null,"Lb/Hp",95,null,22,null,null,null,null,null,90,"25/75",25]
[null,null,null,"-------",null,45,null,null,null,null,null,95,"30/70",30]
["Total de poids désiré",null,"Lbs",{"$f":"D26*D28","v":19000},null,{"$f":"F28*F29","v":990},null,null,null,null,null,100,"35/65",35]
[null,null,null,null,null,null,null,null,null,null,null,105,"40/60",40]
["Sélectionner la répartition du poids avant arrière",null,"Avant ",40,"40/60",null,null,null,null,null,null,110,"55/45",55]
[null,null,"Arrière ",{"$f":"100-D32","v":60},null,null,null,null,null,null,null,115]
[null,"Kg",null,null,null,null,null,null,null,null,null,120]
["Poids désiré",{"$f":"D35/2.2","v":3454.545454545454},"Avant ",{"$f":"D30*D32/100","v":7600},"lbs",null,3450,3400,3030,3680,null,125]
[null,{"$f":"D36/2.2","v":5181.8181818181811},"Arrière ",{"$f":"D30*D33/100","v":11400},"lbs",null,2550,2590,2190,2760,null,130]
[null,null,null,null,null,null,"kg","lb",null,{"$f":"J36*0.4","v":1104},null,135]
["Poids initial",{"$f":"D38/2.2","v":2727.272727272727},"Avant ",6000,"lbs",{"$f":"D38/D40","v":0.375},{"$f":"SUM(G35:J35)","v":13560},{"$f":"G38*2.2","v":29832.000000000004},null,{"$f":"J36*0.6","v":1656},{"$f":"D38*2.2","v":13200.000000000002},140]
[null,{"$f":"D39/2.2","v":4545.454545454545},"Arrière ",10000,"lbs",{"$f":"D39/D40","v":0.625},{"$f":"SUM(G36:J36)","v":10090},{"$f":"G39*2.2","v":22198},null,null,{"$f":"D39*2.2","v":22000},145]
[null,{"$f":"D40/2.2","v":7272.7272727272721},"Total",{"$f":"D38+D39","v":16000},"lbs"]
[]
["Ajout de poids",{"$f":"D42/2.2","v":545.45454545454538},"Avant ",1200,"lbs"]
[null,{"$f":"D43/2.2","v":0},"Arrière ",null,"lbs"]
[null,{"$f":"D44/2.2","v":545.45454545454538},"Total",{"$f":"D42+D43","v":1200},"lbs"]
[]
["Poids ajouté",{"$f":"D46/2.2","v":0},"Avant ",null,"lbs"]
[null,{"$f":"D47/2.2","v":909.09090909090901},"Arrière ",2000,"lbs"]
[null,{"$f":"D48/2.2","v":909.09090909090901},"Total",{"$f":"D46+D47","v":2000},"lbs"]
[null,null,null,null,null,"Pourcentage"]
["Poids final",{"$f":"D50/2.2","v":2727.272727272727},"Avant ",{"$f":"D38+D46","v":6000},"lbs",{"$f":"D50/D52","v":0.33333333333333331}]
[null,{"$f":"D51/2.2","v":5454.545454545454},"Arrière ",{"$f":"D39+D47","v":12000},"lbs",{"$f":"D51/D52","v":0.66666666666666663}]
[null,{"$f":"D52/2.2","v":8181.8181818181811},"Total",{"$f":"D50+D51","v":18000},"lbs",{"$f":"D52/D26","v":90},"lb/HP"]
[]
["Nombre de pneus",null,"Avant ",2,"Avant ",{"$f":"IF(D54=2,D50/2,IF(D54=4,D50/4/0.88,D50/6/0.82))","v":3000},"lbs",null,null,null,null,2]
["Poids par pneu",null,"Arrière ",2,"Arrière ",{"$f":"IF(D55=2,D51/2,IF(D55=4,D51/4/0.88,D51/6/0.82))","v":6000},"lbs",null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,6]

{"sheet":"Références","index":13,"n_rows":39,"n_cols":1,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Conférence Nicolas Dubuc"]
["http://www.mapaq.gouv.qc.ca/SiteCollectionDocuments/Regions/Monteregie-Est/AV2011_2012/Conference_Nicolas_Dubuc.pdf"]
["Texte sur la compaction en anglais"]
["http://pubs.cas.psu.edu/freepubs/pdfs/uc186.pdf"]
["Conférence Roger Rivest"]
["http://www.mapaq.gouv.qc.ca/SiteCollectionDocuments/Regions/Monteregie-Est/AV2011_2012/Conference_Roger_Rivest.pdf"]
["Conférence sur la compaction"]
["http://www.agrireseau.qc.ca/agroenvironnement/documents/Tsague_La%20compaction%20des%20sols.pdf"]
[]
[]
["CPVQ CRAAQ, Problème de compaction"]
["http://www.agrireseau.qc.ca/agroenvironnement/documents/Feuillet7A.pdf"]
["Test Nébaska"]
["http://tractortestlab.unl.edu/testreports"]
[" Ballasting tractors for fuel efficiency "]
["http://www.extension.iastate.edu/Publications/PM2089g.pdf"]
[]
["Alliance (incluant Galaxy, version 2012):"]
["Pneus agricoles :"]
["http://www.atgtire.com/products-agriculture.aspx#"]
["Pneus de flottaison (épandeurs) :"]
["http://www.atgtire.com/images/brochures/ALLIANCE-Flotation-English-2012.pdf"]
["BKT (version 2008):"]
["http://www.american-omni.com/assets/pdf-tires/BKT-tires.pdf "]
["Continental (incluant Mitas, version 2011):"]
["http://www.cgs.eu/soubor.php?fid=919"]
[]
[]
["Firestone (version 2011):"]
["Dimensions impériales : "]
["http://www.firestoneag.com/webres/File/Inflation-Tables/TireInfo-LoadInflation-A.pdf"]
["Technologie IF :"]
["http://www.firestoneag.com/webres/File/Inflation-Tables/TireInfo-LoadInflation-C.pdf"]
["Michelin (version 2009): "]
["http://www.michelinag.com/content/download/2232/27690/version/1/file/Michelin_AG_DataBook.pdf"]
["Nokian (version 2012):"]
["http://www.nokianheavytyres.us/files/nht/technical_manual/NokianHeavyTyres_Technical_manual_04_Agricultural_20120403.pdf"]
["Titan (incluant Goodyear, version 2011):"]
["http://titan-intl.com/files/Agriculture/Ag_DatabookWeb.pdf"]

{"sheet":"Charge","index":14,"n_rows":74,"n_cols":30,"rows_kept":74,"cut":false,"hidden":false,"merged":[[63,21,63,22],[63,23,63,24],[63,25,63,26],[63,27,63,28],[63,18,70,18]]}
[]
[]
[null,null,null,null,null,null,"Rapport de puissance",null,null,null,"Rapport poids puissance"]
[]
[null,null,null,null,null,null,"Vitesse",7,"Milles/heure",null,"Vitesse",{"$f":"H5*1.6","v":11.200000000000001},"km/h"]
[]
[null,null,null,null,null,null,"Rapport",{"$f":"MIN(625/H5,146)","v":89.285714285714292},"Lb/HP",null,"Rapport",{"$f":"H7/2.20462/0.7457","v":54.310536293276662},"kg/kW"]
[]
[null,null,null,null,null,null,null,"Max"]
[null,null,null,null,null,null,"Articulé",105,"Lb/HP"]
[null,null,null,null,null,null,"AUTRES",145,"Lb/HP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hp= CKw",null,"1 km/h= C m/h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74569987199999999,null,0.62137119223732995]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse",null,"Sols cohésifs",null,"Sols non cofésifs",null,"Sols cohésifs",null,"Sols non cofésifs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 roues motrices ou 4 roeus motrice",null,null,null,"2 roues motrices ou 4 roeus motrice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,2,4,2,4,2,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mille/h","Km/h","kg/KW","kg/KW","kg/KW","kg/KW","Lb/Hp","Lb/Hp","Lb/Hp","Lb/Hp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U68*$V$61,1)","v":7.5},12,55,49,61,55,{"$f":"ROUND(V68*2.2*$T$61,1)","v":90.2},80.400000000000006,100.1,90.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U69*$V$61,1)","v":6.2},10,61,55,73,67,100.1,90.2,119.8,109.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U70*$V$61,1)","v":5},8,73,67,85,79,119.8,109.9,139.4,129.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(U71*$V$61,1)","v":4.3},7,91,79,104,97,149.30000000000001,129.6,170.6,159.1,"Max 145 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"attention",{"$f":"ROUND(U72*$V$61,1)","v":3.1},5,122,110,140,134,200.1,180.5,229.7,219.8]
[]
[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,5]

{"sheet":"Balancement","index":15,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,1,6,1],[0,1,0,4]]}
[null,"La réparation du poids du tracteur"]
[]
[]
[]
[]
[null,"Tracteurs","    Trainé","   Semi-porté","      Porté"]
[null,null,"Avant/arrière","Avant/arrière","Avant/arrière"]
[null,"2 roues","25 / 75 %","30 / 70 %","35 / 65%"]
[null,"2 + 2 ","35 / 65 %","35 / 65 %","40 / 60 %"]
[null,"4 roues","55 / 45 %","55 / 45 %","60 / 40 %"]

{"sheet":"Feuil1","index":16,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"RSC"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RSC"]

{"sheet":"tableau résumé","index":17,"n_rows":62,"n_cols":34,"rows_kept":62,"cut":false,"hidden":false,"merged":[[2,9,2,10],[2,13,2,14],[0,3,0,8],[3,0,11,0],[0,9,0,10],[0,13,0,14],[13,0,21,0],[23,0,31,0],[33,0,41,0],[43,0,51,0],[53,0,61,0]]}
[null,"Tracteur",null,"poids tracteur",null,null,null,null,null,"pneu avant",null,"pression",null,"pneu arrière",null,"pression",null,null,"Équipement",null,null,"si porté","si semi porté",null,null,"Trainé"]
[null,"marque","Modèle","avant","arrière","ajout avant","ajout roue avant","ajout roue arrière","ajout arrière","intérieur","extérieur","intérieur","extérieur","intérieur","extérieur",null,null,null,"type","description","largeur","Poids","poids sur essieu tracteur","pneu","pression","Poids","Pneu","pression","Poids","Pneu","pression","Poids","Pneu","pression"]
[null,null,null,"kg","kg","kg","kg","kg","kg","marge et cote de charge",null,"Psi","Psi","marge et cote de charge",null,"Psi",null,"no",null,null,null,"kg",null,"marque et côte","Psi","kg","marque et côte","Psi","kg","marque et côte","Psi","kg","marque et côte","Psi"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"à vide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"à vide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"à vide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"à vide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"à vide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"à vide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]

{"sheet":"calcul des réservoirs","index":18,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[null,"Réservoir","Dm",null,6200,null,"À vide",null,null,null,null,null,"Réservoir",null,{"$f":"C1","v":"Dm"},null,{"$f":"E1","v":6200},"Plein"]
[null,"Essieu",1,null,2,null,3,null,null,4,null,null,"Essieu",null,1,null,2,3,null,4]
[null,{"$f":"SUM(C3:J3)","v":9780},{"$f":"C5+C6","v":2260},null,{"$f":"E5+E6","v":2580},null,{"$f":"G5+G6","v":2460},null,null,{"$f":"J5+J6","v":2480},null,null,{"$f":"SUM(O3:U3)","v":36157.071204657412},null,{"$f":"O5+O6","v":9039.2678011643529},null,{"$f":"Q5+Q6","v":9039.2678011643529},{"$f":"R5+R6","v":9039.2678011643529},null,{"$f":"T5+T6","v":9039.2678011643529}]
[null,"Total"]
[null,"Gauche",1190,null,1290,null,1280,null,null,1170,null,null,"Gauche",null,{"$f":"V26/2","v":4519.6339005821765},null,{"$f":"O5","v":4519.6339005821765},{"$f":"Q5","v":4519.6339005821765},null,{"$f":"R5","v":4519.6339005821765}]
[null,"Droit",1070,null,1290,null,1180,null,null,1310,null,null,"Droit",null,{"$f":"O5","v":4519.6339005821765},null,{"$f":"O6","v":4519.6339005821765},{"$f":"Q6","v":4519.6339005821765},null,{"$f":"R6","v":4519.6339005821765}]
[null,"Poids sur le timon",null,null,560,null,null,null,null,null,null,null,"Poids sur le timon",null,null,null,{"$f":"V28","v":2092.9986986428703}]
[null,"Poids total réservoir",null,null,{"$f":"B3+E7","v":10340},null,null,null,null,null,null,null,"Poids total",null,null,null,{"$f":"M3+Q7","v":38250.069903300282},null,null,{"$f":"Q8-E8","v":27910.069903300282},null,{"$f":"T8-J10","v":1137.34263057301}]
[]
[null,null,null,null,null,null,"Poids du liquide",null,null,{"$f":"J11/2.2","v":26772.727272727272},"kg",null,null,"Poids du tracteur à vide",null,null,null,11690,"kg"]
[null,null,null,null,{"$f":"E1*10","v":62000},"lb",null,null,null,{"$f":"E12","v":58900},"lb",null,null,"Poids du tracteur plein",null,null,null,{"$f":"'schéma tracteur'!B32","v":""},"kg"]
[null,null,null,null,{"$f":"E11*G12","v":58900},null,0.95,null,null,null,null,null,null,"Poids du liquide sur le timon",null,null,null,{"$f":"R11-R10","v":{"$error":"#VALUE!"}},"kg"]
[null,null,null,null,null,null,"% de remplissage",null,null,null,null,null,null,"Poids du liquide total Réservoir + timon",null,null,null,{"$f":"M3-B3+R12","v":{"$error":"#VALUE!"}},"kg"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Différence poids tracteur seul et à vide",null,null,null,null,560]
[null,"ESTIMATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poids du réservoir vide",null,null,null,null,9780]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% timon",null,null,null,null,{"$f":"V16/V17","v":5.7259713701431493E-2}]
[null,"Évaluation d'un réservoir "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poids sur le timon à vide",null,null,null,null,560,"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volume du réservoir",null,null,null,null,6200,"gal can"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poids à 95% ",null,null,null,null,{"$f":"V21*10*0.95","v":58900},"lb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V22/2.2","v":26772.727272727272},"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poids à chaque essieu + 6% au timon",null,null,null,null,{"$f":"V23/4.06","v":6594.2678011643529},"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Poids réservoir seul / essieu",null,null,null,null,{"$f":"B3/4","v":2445}]
[null,null,null,null,null,null,null,null,null,null,2.14,null,1.7,null,null,null,"Poids total plein / essieu",null,null,null,null,{"$f":"V24+V25","v":9039.2678011643529},"kg"]
[null,null,null,null,null,null,null,null,null,3.92]
[null,null,null,null,null,null,null,5.75,null,null,null,null,null,null,null,null,"Poids timon plein",null,null,null,null,{"$f":"V16+V23*V18","v":2092.9986986428703},"kg"]
[null,null,null,null,null,null,7.5]
[]
[null,null,null,null,8.42]
[null,null,null,null,null,null,null,{"$f":"E31+M26","v":10.119999999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,2,2,2,2,3,3,3,3,4,4,4]
[null,"Gal U.s.",4000,4500,5000,5700,5600,6200,6600,7400,8500,9600,10200]
[null,"Gal Imp.",3300,3800,4200,4800,4600,5200,5500,6200,7100,8000,8500]
[null,"Litres",15100,17200,18900,21500,21200,23600,25000,28000,32200,36300,38600]
[null,"Vide lb",14000,14250,15270,15550,19330,19650,20890,21130,27250,27720,28580]
[null,"Plein lb",47000,52250,57270,65330,65330,81650,75900,82700,88250,107550,113100]
[null,"Poids sur le timon (kg)",{"$f":"C58*9/100/2.2","v":1922.7272727272725},{"$f":"D58*9/100/2.2","v":2137.5},2342.863636363636,2672.590909090909,2672.590909090909,3340.2272727272725,3104.9999999999995,3383.181818181818,3610.2272727272725,4399.772727272727,4626.8181818181811]
[null,"Poids (kg)",{"$f":"C58/2.2-C59","v":19440.909090909088},{"$f":"D58/2.2-D59","v":21612.499999999996},23688.954545454544,27022.863636363636,27022.863636363636,33773.409090909088,31395,34207.727272727272,36503.409090909088,44486.590909090904,46782.272727272721]
[null,"Poids approx. à la roue (kg)",{"$f":"C60/C53/2","v":4860.2272727272721},{"$f":"D60/D53/2","v":5403.1249999999991},5922.238636363636,6755.715909090909,4503.810606060606,5628.901515151515,5232.5,5701.287878787879,4562.926136363636,5560.8238636363631,5847.7840909090901]

{"sheet":"% glissement","index":19,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"L"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Nombre de tours",null,10]
["Rayon statique chargé",null,800,"mm",null,null,null,null,null,750,"mm"]
["Circonférence pour 1 tour",null,{"$f":"C35*2*3.1416/1000","v":5.0265599999999999},"m ",null,null,null,null,null,{"$f":"J35*2*3.1416/1000","v":4.7123999999999997},"m "]
["Distance pour x tours",null,{"$f":"C36*H34","v":50.265599999999999},"m",null,null,null,null,null,{"$f":"J36*H34","v":47.123999999999995},"m"]
["Distance pour x tours au champ",null,40,"m",null,null,null,null,null,46,"m"]
["% de glissement",null,{"$f":"(C37-C38)/C38*100","v":25.663999999999998},"%",null,null,null,null,null,{"$f":"(J37-J38)/J38*100","v":2.4434782608695547},"%"]

{"sheet":"résumé tracteur","index":20,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[3,0,11,0],[0,3,0,8],[0,9,0,10],[0,13,0,14],[2,9,2,10],[2,13,2,14],[3,1,11,2],[13,0,21,0],[23,0,31,0],[33,0,41,0],[43,0,51,0],[53,0,61,0],[13,1,21,2],[23,1,31,2],[33,1,41,2],[43,1,51,2],[53,1,61,2]]}
[null,"Tracteur",null,"poids tracteur",null,null,null,null,null,"pneu avant",null,"pression","pression","pneu arrière",null,"pression","pression"]
[null,"marque","Modèle","avant","arrière","ajout avant","ajout roue avant","ajout roue arrière","ajout arrière","intérieur","extérieur","intérieur","extérieur","intérieur","extérieur"]
[null,null,null,"kg","kg","kg","kg","kg","kg","marque et indice de charge",null,"Psi","Psi","marrque et indice de charge",null,"Psi","Psi"]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[6]

{"sheet":"résumé machinerie","index":21,"n_rows":62,"n_cols":20,"rows_kept":62,"cut":false,"hidden":false,"merged":[[53,0,61,0],[3,0,11,0],[13,0,21,0],[23,0,31,0],[33,0,41,0],[43,0,51,0],[53,1,61,2],[3,1,11,2],[13,1,21,2],[23,1,31,2],[33,1,41,2],[43,1,51,2]]}
[null,"Tracteur",null,null,"Équipement",null,null,"si porté","si semi porté",null,null,"Trainé"]
[null,"marque","Modèle",null,"type","description","largeur","Poids","poids sur essieu tracteur","pneu","pression","Poids","Pneu","pression","Poids","Pneu","pression","Poids","Pneu","pression"]
[null,null,null,"no",null,null,null,"kg",null,"marque et côte","Psi","kg","marque et côte","Psi","kg","marque et côte","Psi","kg","marque et côte","Psi"]
[1,null,null,1,"à vide"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[]
[2,null,null,1,"à vide"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[]
[3,null,null,1,"à vide"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[]
[4,null,null,1,"à vide"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[]
[5,null,null,1,"à vide"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[]
[6,null,null,1,"à vide"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]

{"sheet":"Impression","index":22,"n_rows":86,"n_cols":20,"rows_kept":86,"cut":false,"hidden":false,"merged":[[81,4,81,6],[82,5,82,7],[83,5,83,7],[84,5,84,7],[85,5,85,7],[80,5,80,7],[36,5,36,7],[37,4,37,6],[37,9,37,12],[38,5,38,7],[39,5,39,7],[40,5,40,7],[41,5,41,7],[59,4,59,7],[64,4,64,6],[69,4,69,6],[77,4,77,6],[33,4,33,6],[0,0,0,1],[0,4,0,7],[17,4,17,6],[22,4,22,6],[30,0,30,2]]}
["Données physiques",null,null,{"$f":"IF('schéma tracteur'!F1=\"\",\"\",+'schéma tracteur'!F1)","v":""},"Données calculées "]
["Puissance Hp","P",null,null,null,null,null,{"$f":"IF(C2=\"\",\"\",+C2*0.746)","v":""}]
["Données arrière",null,null,"Plein"]
["Empattement  (m)","a"]
["Poids arrière (kg)","b",null,{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!J34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,3000,{"$f":"H14","v":""},{"$f":"R5/R7*100","v":{"$error":"#VALUE!"}}]
["Poids roues (kg)","c",null,{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!J18)","v":""},null,null,null,"Vide",null,"Plein",null,null,null,null,null,null,null,{"$f":"H7","v":""},{"$f":"R6/R7*100","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Poids arrière (kg)","d","=  b + c",{"$f":"IF(C2=\"\",\"\",+C5+C6)","v":""},null,{"$f":"IF(D5=\"\",\"\",D5+D6)","v":""},null,null,null,null,null,null,null,{"$f":"R5+R6","v":{"$error":"#VALUE!"}}]
["Poids déporté (kg)","e"]
["déportance (m)","f",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
["Poids déporté à vide","e1",null,null,null,null,null,null,null,{"$f":"H11","v":""},null,null,null,null,null,null,null,null,65]
["Données avant",null,null,null,"Rapport arrière","g","= f / a",{"$f":"IF(C2=\"\",\"\",+C9/C4)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"R5+Q5","v":{"$error":"#VALUE!"}},{"$f":"R11/R13*100","v":{"$error":"#VALUE!"}}]
["Poids avant (kg)","h",null,{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!T34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R6","v":""},{"$f":"R12/R13*100","v":{"$error":"#VALUE!"}}]
["Poids roues (kg)","i",null,{"$f":"IF(C2=\"\",\"\",+'schéma tracteur'!T22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R11+R12","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Poids avant (kg)","j "," = i +h",{"$f":"IF(C2=\"\",\"\",+C12+C13)","v":""},null,{"$f":"IF(D12=\"\",\"\",D12+D13)","v":""}]
["Poids déporté (kg)","k",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R5","v":""},1,1]
["déportance (m)","l",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,"rapport avant","m","= l / a",{"$f":"IF(C2=\"\",\"\",+C16/C4)","v":""},{"$f":"H20-H21","v":{"$error":"#VALUE!"}},{"$f":"H17","v":""}]
[null,null,null,null,"Calcul du poids de transfert avant et arrière",null,null,null,"à vide",null,"à vide"]
[null,null,null,null,"Poids en moins sur les roues arrière (kg)","q","= k * m",{"$f":"IF(C2=\"\",\"\",+C15*H17)","v":""},null,{"$f":"IF(C2=\"\",\"\",+C15*J17)","v":""}]
[null,null,null,null,"Poids en plus sur les roues arrière (kg)","r","= e + ( e * g )",{"$f":"IF(C2=\"\",\"\",+C8+(C8*H11))","v":""},{"$f":"IF(C2=\"\",\"\",+C10+(C10*H11))","v":""},{"$f":"IF(C2=\"\",\"\",+C8+(C8*J10))","v":""},{"$f":"IF(C2=\"\",\"\",+C10+(C10*H11))","v":""}]
[null,null,null,null,"Poids en moins sur les roues avant (kg)","s","= e * g",{"$f":"IF(C2=\"\",\"\",+C8*H11)","v":""},{"$f":"IF(C2=\"\",\"\",+C10*H11)","v":""},{"$f":"IF(C2=\"\",\"\",+C8*J10)","v":""},{"$f":"IF(C2=\"\",\"\",+C10*H11)","v":""}]
[null,null,null,null,"Poids en plus sur les roues avant (kg)","t","= k + ( k * m )",{"$f":"IF(C2=\"\",\"\",+C15+(C15*H17))","v":""},null,{"$f":"IF(C2=\"\",\"\",+C15+(C15*J17))","v":""}]
[null,null,null,null,"Calcul du poids et de la répartition"]
[null,null,null,null,"Poids total arrière (kg)","u","= d + r - q",{"$f":"IF(C2=\"\",\"\",+H7+H20-H19)","v":""},{"$f":"IF(C2=\"\",\"\",+H7+I20-H19)","v":""},{"$f":"IF(J7=\"\",\"\",+J7+J20-J19)","v":""},{"$f":"IF(J7=\"\",\"\",+J7+K20-J19)","v":""}]
[null,null,null,null,"Poids total avant (kg)","v","= j + t - s",{"$f":"IF(C2=\"\",\"\",+H14+H22-H21)","v":""},{"$f":"IF(C2=\"\",\"\",+H14+H22-I21)","v":""},{"$f":"IF(J14=\"\",\"\",+J14+J22-J21)","v":""},{"$f":"IF(J14=\"\",\"\",+J14+J22-K21)","v":""}]
[null,null,null,null,"Poids total (kg)","w","= u + v",{"$f":"IF(C2=\"\",\"\",+H24+H25)","v":""},{"$f":"IF(C2=\"\",\"\",I24+I25)","v":""},{"$f":"IF(J24=\"\",\"\",+J24+J25)","v":""},{"$f":"IF(J24=\"\",\"\",K24+K25)","v":""}]
[null,null,null,null,"Répartition arrière","x","= u / w * 100",{"$f":"IF(C2=\"\",\"\",+H24/H26*100)","v":""},{"$f":"IF(C2=\"\",\"\",+I24/I26*100)","v":""},{"$f":"IF(J24=\"\",\"\",+J24/J26*100)","v":""},{"$f":"IF(J24=\"\",\"\",+K24/K26*100)","v":""}]
[null,null,null,null,"Répartition avant","y","= v / w * 100",{"$f":"IF(C2=\"\",\"\",+H25/H26*100)","v":""},{"$f":"IF(C2=\"\",\"\",+I25/I26*100)","v":""},{"$f":"IF(J24=\"\",\"\",+J25/J26*100)","v":""},{"$f":"IF(J24=\"\",\"\",+K25/K26*100)","v":""}]
[null,null,null,null,"Charge/puissance (kg/Hp)","z ","= w / p",{"$f":"IF(C2=\"\",\"\",+H26/C2)","v":""},null,{"$f":"IF(J24=\"\",\"\",+J26/C2)","v":""}]
[null,null,null,null,"Charge/puissance  (lb/Hp)","z1","= z * 2,2",{"$f":"IF(C2=\"\",\"\",+H29*2.2)","v":""},null,{"$f":"IF(J24=\"\",\"\",+J29*2.2)","v":""}]
["Constante R pour calculer la charge par pneu"]
["1) Si roue simple",null,"2"]
["2) Si roue double",null,"4 / 0,88"]
["3) Si roue triple",null,"6 / 0,82",null,"Calcul du poids par pneu",null,null,null,null,null,null,null,1]
["Choix avant",{"$f":"IF(A44=\"simple\",1,IF(A44=\"double\",2,3))","v":1},null,null,"Poids par pneu arrière (kg)","Poids arr","=  u / R ",{"$f":"IF(C2=\"\",\"\",IF(B36=1,H24/2,IF(B36=2,H24/4/0.88,H24/6/0.82)))","v":""},null,{"$f":"IF(J24=\"\",\"\",IF(B36=1,J24/2,IF(B36=2,J24/4/0.88,J24/6/0.82)))","v":""},null,null,2]
["Choix arrière",{"$f":"IF(A45=\"simple\",1,IF(A45=\"double\",2,3))","v":1},null,null,"Poids par pneu avant (kg)","Poids avant","=  v / R ",{"$f":"IF(C2=\"\",\"\",IF(B35=1,H25/2,IF(B35=2,H25/4/0.88,H25/6/0.82)))","v":""},{"$f":"IF(C2=\"\",\"\",IF(B35=1,I25/2,IF(B35=2,I25/4/0.88,I25/6/0.82)))","v":""},{"$f":"IF(J24=\"\",\"\",IF(B35=1,J25/2,IF(B35=2,J25/4/0.88,J25/6/0.82)))","v":""},{"$f":"IF(J24=\"\",\"\",IF(B35=1,K25/2,IF(B35=2,K25/4/0.88,K25/6/0.82)))","v":""},null,3]
[null,null,null,null,null,"Aller dans une charte avec ce poids et la vitesse d'opération pour trouver la pression du pneu"]
[null,null,null,null,"Vérification dans les chartes de compagnies de la pression et du rayon mimimum chargé"]
[null,null,null,null,"Pression arrière psi ou kPa",{"$f":"'schéma tracteur'!K50","v":0}]
[null,null,null,null,"Pression avant psi ou kPa",{"$f":"'schéma tracteur'!V50","v":0}]
[null,null,null,null,"Rayon minimum chargé arrière",{"$f":"'schéma tracteur'!M50","v":0}]
[null,null,null,null,"Rayon minimum chargé avant",{"$f":"'schéma tracteur'!W50","v":0}]
[]
[{"$f":"'schéma tracteur'!Y21","v":"Simple"},"av"]
[{"$f":"'schéma tracteur'!E25","v":"Simple"},"ar"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Données calculées "]
[null,null,null,null,"Poids arrière (kg)","d","=  b + c"]
[null,null,null,null,"Rapport arrière","g","= f / a"]
[null,null,null,null,"Poids avant (kg)","j "," = i +h"]
[null,null,null,null,"Rapport avant","m","= l / a"]
[null,null,null,null,"Calcul du poids de transfert avant et arrière"]
[null,null,null,null,"Poids en moins sur les roues arrière (kg)","q","= k * m"]
[null,null,null,null,"Poids en plus sur les roues arrière (kg)","r","= e + ( e * g )"]
[null,null,null,null,"Poids en moins sur les roues avant (kg)","s","= e * g"]
[null,null,null,null,"Poids en plus sur les roues avant (kg)","t","= k + ( k * m )"]
[null,null,null,null,"Calcul du poids et de la répartition"]
[null,null,null,null,"Poids total arrière (kg)","u","= d + r - q"]
[null,null,null,null,"Poids total avant (kg)","v","= j + t - s"]
[null,null,null,null,"Poids total (kg)","w","= u + v"]
[null,null,null,null,"Répartition arrière","x","= u / w * 100"]
[null,null,null,null,"Répartition avant","y","= v / w * 100"]
[null,null,null,null,"Charge/puissance (kg/Hp)","z ","= w / p"]
[null,null,null,null,"Charge/puissance  (lb/Hp)","z1","= z * 2,2"]
[null,null,null,null,"Calcul du poids par pneu"]
[null,null,null,null,"Poids par pneu arrière (kg)","Poids arr","=  u / R "]
[null,null,null,null,"Poids par pneu avant (kg)","Poids avant","=  v / R "]
[null,null,null,null,null,"Aller dans une charte avec ce poids et la vitesse d'opération pour trouver la pression du pneu"]
[null,null,null,null,"Vérification dans les chartes de compagnies de la pression et du rayon mimimum chargé"]
[null,null,null,null,"Pression arrière psi ou kPa"]
[null,null,null,null,"Pression avant psi ou kPa"]
[null,null,null,null,"Rayon minimum chargé arrière"]
[null,null,null,null,"Rayon minimum chargé avant"]