{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Notice","Strat 1","Strat 2","strat 3","comparateur","chronos","nbr tours","ajust éco","circuits","voitures","Transmissions","grille","grille2","PIT"],"not_rendered":{"charts":1,"images":177,"macros":1,"external_links":2,"defined_names":43,"comments":6,"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":"Notice","index":0,"n_rows":328,"n_cols":32,"rows_kept":328,"cut":false,"hidden":false,"merged":[[1,0,2,0],[327,5,328,7],[24,2,24,8],[166,6,166,13],[169,5,174,8],[175,5,178,8],[284,7,284,13],[28,0,29,13],[259,2,259,8],[260,2,260,8],[261,2,261,8],[0,12,1,13],[0,3,2,10],[111,1,111,3],[115,8,115,13],[114,8,114,13],[4,31,5,39],[14,2,14,7],[18,2,18,8],[63,10,63,11],[1,21,2,23],[2,12,2,13],[1,16,2,20],[4,29,5,29],[4,30,5,30],[0,1,2,1],[56,1,57,6],[58,1,60,6],[65,7,65,12],[103,10,103,13],[21,2,21,8],[32,9,34,12],[52,1,52,5],[271,6,271,11],[274,10,278,13],[279,10,282,13],[236,2,236,12],[119,8,119,13],[120,8,120,13],[200,10,205,13],[192,10,195,13],[196,10,199,13],[145,1,145,9],[188,1,189,2],[125,1,125,7],[140,1,141,13],[143,1,144,13],[146,1,149,1]]}
[null,"by",null,"Comparateur de stratégies",null,null,null,null,null,null,null,null,"version"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signalez un problèmes, un bug, des questions ?",null,null,null,null,"bigbang.contact@orange.fr"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AD7:AD40)","v":6.1}]
[]
[null,null,"Vous devez vous assurer que les macros et le mode protégé sont activés.",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,"Versions","Date","Mises à jour"]
[null,null,"A l'ouverture d'Excel si les messages ci-dessous apparaissent, cliquez sur \"activer le contenu\" et \"activer la modification\"."]
[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,1.1000000000000001,"2021-04-25","Amélioration calcul gestion fuel/autonomie (compte tour, éco fuel)"]
[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,2,"2021-05-15","Amélioration précision calcul temps moyen au tour"]
[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,2.1,"2021-05-19","Correction bug \"erreur d'exécution 1004\" des macros"]
[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,3,"2021-05-22","Amélioration visuelle du comparateur"]
[null,null,"Une notice d'utilisation ci dessous et un tutoriel sur You Tube sont à votre disposition.",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,4,"2021-05-25","Ajout listing des circuits et pistes avec menu déroulant dans strat 1"]
[null,null,"pour une prise en main simple et rapide !",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,4,"2021-05-29","Ajout listing des voitures, catégories, marques, modèles"]
[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,4.0999999999999996,"2021-06-05","Correction de la prise en compte des valeurs d'ajustement conduite strat 2 et 3"]
[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,5,"2021-06-18","Menus déroulants des catégories véh. associées à un listing des voitures correspondantes (strat 1)"]
[null,null,"Accédez à l'application en cliquant sur le bouton si contre",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,5.0999999999999996,null,"Saisie automatique de la longueur et nombres de virage en fonction du circuit sélectionné"]
[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,5.2,null,"Conduite éco : possibilité d'affiner les temps et la conso fuel séparément entre chaque pit"]
[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,5.3,null,"Rajout des pneus super tendre parmi les choix de pneumatiques"]
[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,5.4,null,"Rajout alerte en cas de dépassement du temps de course ou du nombre de tours"]
[null,null,"Images et liste de l'ensemble des circuits et des pistes GTS",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,5.6,"2021-07-24","Confirmation oui/non des commandes supprimer / RAZ"]
[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,5.7,"2021-07-30","Message d'erreur si saisie des temps non conformes"]
[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,5.8,null,"Amélioration saisies niveau carburant, autonomie, arrêt au stand"]
[null,null,"Liste des voitures par catégories, par marques et par modèles",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,5.9,"2021-08-02","Message informatif sur les saisies strat 1"]
[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,5.91,"2021-08-02","Correction bug niveau refuel strat 2 et 3"]
[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,5.92,"2021-08-07","Correction erreur du cumul temps pit STRAT 2"]
[null,null,"Les types de transmission sur GT Sport",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,6,"2021-09-02","Ajout choix durée de vie des pneus et prise en compte des temps pour chaque stratégie"]
[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,6.1,"2021-10-30","Correction bug conduite éco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adopter une stratégie de course ne vous fera pas gagner de temps, elle évitera de vous en faire perdre ! "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Une bonne stratégie vous permettra de prévoir des impondérables comme éviter une panne d'essence… "]
["NOTICE  D'UTILISATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ou de devoir rouler avec des gommes trop usées et perdre des secondes précieuses…"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L'objectif de cette application est d'établir des valeurs de référence en matière de choix des pneus de leurs usures"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"et de la consommation d'essence afin de vous aider à mettre en place une stratégie de course sur mesure."]
[null,null,null,null,null,null,null,null,null,"Big-Bang CB - YouTube",null,null,null,null,null,null,"vous aurez la possibilité d'élaborer des scénarios, de visualiser des indicateurs pour limiter et optimiser les arrêts "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aux stands au strict nécessaire et de rester concentré sur votre course, votre conduite et les points de freinages…"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pendant la course restez fidèle à votre stratégie et ne vous faites pas influencer par celle des autres pilotes."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Une stratégie se bâtie en fonction de votre style de conduite et de vos temps chronos…"]
[null,"Application pour l'élaboration et le choix de stratégie de course d'endurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bon jeux !"]
[null,"Utilisable pour des courses dont la durée est définie par une limite de temps où un nombre de tours,"]
[null,"cet outil vous permet d'établir et comparer trois stratégies de courses différentes avec 5 possibilités de pits en tenant compte :"]
[null,"§","de 6 types de pneumatiques différents : super soft, soft, médium, hard, intermédiaire et pluie,"]
[null,"§","d'évaluer la durée de vie des pneus et la dégradation des temps chronos en analysant jusqu’à 3 essais chronos différents,"]
[null,"§","de comparer à l'aide d'un graphique l'incidences sur les temps des différents types de gommes par rapport à leur durée d'utilisation,"]
[null,"§","de modifier le niveau de fuel embarqué au départ de la course,"]
[null,"§","de calculer au plus juste le besoin de fuel à embarquer entre chaque PIT pour limiter les temps d'arrêt,"]
[null,"§","de calculer la dégradation des temps au tour du à la perte de puissance et le gain en tour en cas d'utilisation de l'éco fuel,"]
[null,"§","de prendre en compte les temps moyens au tour en fonction de la durée de vie des gommes sur chacune des stratégies,"]
[null,"§","de calculer très facilement les temps stops pits réels,"]
[null,"§","de la prise en compte précise des temps d'arrêts au stand en fonction des actions (échange pneumatiques et/ou refuel),"]
[null,"§","d'alertes si un type de pneu obligatoire n'est pas utilisé dans votre stratégie ou si le nombre de tours sélectionné dépasse l'autonomie,"]
[]
[null,"En préalable (valable pour l'ensemble de l'outil) :"]
[null,"Les renseignements à indiquer dans les cellules fonds blancs",null,null,null,null,"facultatif","sont à titre informatifs (pas d'obligation de saisie)."]
[]
[null,"Les renseignements à indiquer dans les cellules fonds jaunes",null,null,null,null,"obligatoire","doivent être obligatoirement complétés."]
[null,"DONNEES COURSE : excepté la durée de vie des pneus, la saisie des données sur les interfaces stratégies 2 et 3 se fera automatiquement."]
[null,"Cliquez sur les boutons de commandes                                                   pour effacer vos données saisies, (course, chronos etc..)"]
[]
[null,"une confirmation vous sera demandée. ATTENTION si vous cliquer sur \"oui\" la suppression est irréversible."]
[]
[]
[]
[]
[null,"Pour accéder à l'application et aux données course cliquez sur le bouton de commande ",null,null,null,null,null,null,null,null,"ci-dessus."]
[]
[null,"Pour revenir à la notice cliquez sur le bouton de commande ",null,null,null,null,null,"disponible dans toutes les interfaces de l'outil."]
[]
[null,"En cliquant sur les cellules de saisie ou nominative"]
[null,"vous pouvez obtenir des informations ou des explications"]
[null,"complémentaires."]
[]
[]
[]
[]
[]
[]
[null,"ATTENTION si vous déverrouillez la protection des feuilles vous risquez de perdre des formules de calcul et d'altérer les résultats."]
[null,"1) Saisie des données de la course :"]
[null,"Saisie des données du comparateur sur l'interface \"Strat 1\" uniquement, section \"Données course\" :"]
[]
[]
[]
[]
[]
[]
[null,"Les données, longueur circuit et nbr de virages s'incrémenteront automatiquement en fonction du circuit sélectionné dans le menu déroulant"]
[]
[null,"Exemple :"]
[]
[]
[]
[]
[]
[null,"Un préfiltre des modèles de voitures est réalisé en sélectionnant dans le menu déroulant la catégorie des véhicules."]
[]
[null,"Exemple :"]
[]
[]
[]
[]
[]
[]
[null,"2) Saisie tours chronos :"]
[null,"Pour noter vos chronos, une fenêtre de saisie s'ouvre lorsque vous cliquez sur le bouton ",null,null,null,null,null,null,null,null,"(strat1 uniquement)"]
[null,"Commencer par indiquer dans la colonne \"pneumatique\" les types de gomme autorisée pour votre course (3 possibilités)."]
[null,"vous pouvez commencer vos essais pour recueillir les temps. 3 essais libres peuvent être renseignés"]
[null,"vous devez saisir au minimum le meilleur temps ET un moins bon temps réalisés en condition de course en fonction des types de pneus *"]
[null,"IMPORTANT","il est indispensable de respecter la forme de saisie d'Excel pour entrer vos temps."]
[null,"Exemple : un temps d'1 minute 39 secondes et 5 dixièmes doit être saisie dans la cellule :",null,null,null,null,null,null,null,"min : sec, dixième",null,"00:01:39.600"]
[null,"Si le format de saisie n'est pas correct un message vous avertira.",null,null,null,null,null,null,null,"les dixièmes séparés par une virgule"]
[null,null,null,null,null,null,null,null,null,"si vous avez 0 dixième taper tout de même ,0"]
[null,"Fenêtre saisie des tours chronos :"]
[]
[null,null,null,null,null,null,null,null,"Les trois saisies entourées sont obligatoires"]
[null,null,null,null,null,null,null,null,"Indiquer le nombre de tours réalisé avec le même train de pneus"]
[null,null,null,null,null,null,null,null,"Détermine la durée de vie des gommes"]
[null,null,null,null,null,null,null,null,null,"voir chap. 3, saisie des données pneus"]
[]
[null,null,null,null,null,null,null,null,"ex :"]
[null,null,null,null,null,null,null,null,"1ère colonne : meilleur temps en fonction du type de pneus"]
[null,null,null,null,null,null,null,null,"2ème colonne : moins bon temps réalisé au bout de 10 tours"]
[]
[null,null,null,null,null,null,null,null,"vous avez la possibilité d'indiquer pour mémoire la"]
[null,null,null,null,null,null,null,null,"répartition des freins pour chacun des essais libres"]
[]
[null,"(*) saisir obligatoirement au moins les trois données entourées en rouge"]
[]
[null,"Cliquez sur le bouton                               pour accéder à de nombreux tours chronos de référence suivant les circuits et catégories de véhicules."]
[null,"Toutes les données renseignées, revenez ensuite sur la fenêtre STRAT 1"]
[null,"3) Saisie des données pneumatiques :"]
[null,"La gestion des pneumatiques est cruciale. Comprendre la façon dont votre style de pilotage affecte la durée de vie des pneus et tout aussi important "]
[null,"que d'engranger des tours rapides."]
[null,"Cette partie de l'application vous permet de comparer et de choisir la meilleure option parmi trois essais libres de durée de vie des pneus et cela pour"]
[null,"chacun des types de pneus que vous utiliserez."]
[]
[]
[]
[]
[]
[null,"Dans la partie des données course réservée aux pneumatiques :"]
[null,"1) Choisir à l'aide du menu déroulant \"durée de vie\" le seuil d'usure en nombre de tours. Le temps indiqué à gauche correspond au tour chronos moyen qui sera pris en compte dans votre stratégie. NB : Vous pouvez indiquer une durée de vie différente pour chacune des 3 stratégies."]
[]
[]
[null,"Une alerte dans la partie \"tableau de bord\", cellules \"nombre de pits / tour\" se déclenchera si vous saisissez un nombre de tours supérieur au seuil que vous aurez défini. (ce qui ne vous empêche pas de passer outre et de conserver le nbr de tours voulu)"]
[]
[null,"Exemple pour une usure max de 11 tours avec des S soft :"]
[null,"Dans le\ntableau\nde bord :","11 tours, OK"]
[null,null,"12 tours, la cellule"]
[null,null,"passe en \"alerte"]
[null,null,"orange\""]
[]
[]
[null,"2) Renseigner si la monte des types de pneus est libre ou obligatoire"]
[null,"Si obligatoire (ex : pneus 3), une case apparait en dessous de \"obligatoire\", renseigner le nombre de tours imposé."]
[null,"Si vous omettez d'utiliser une gomme obligatoire dans votre stratégie un message d'alerte vous avertira"]
[null,"La cellule \"temps\" vous indique le temps moyen au tour qui sera pris en compte dans le calcul de votre stratégie"]
[]
[null,"4) Carburant / Autonomie :"]
[null,"Dans la partie données course réservée au carburant :"]
[null,"Les autonomies sont renseignées en nombre de tours et en %."]
[null,"l'autonomie indiquée dans le jeu réservoir plein peut augmenter fortement au fur et à mesure que le réservoir se vide et que la voiture gagne en poids. "]
[null,"Le calculateur ne prend pas en compte ce facteur puisqu'il dépend également de votre conduite."]
[null,"Il est donc nécessaire de faire des essais pour vérifier l'autonomie réelle de votre voiture."]
[null,"Si vous indiquez dans le tableau de bord un nombre de tours supérieur à l'autonomie maxi que vous avez renseigné, un message d'alerte \"dépasse\""]
[null,"s'affiche dans la cellule autonomie du tableau de bord. Exemple ci-dessous (*)"]
[]
[null,null,null,null,null,null,"par défaut le réservoir indique 100 litres (identique à GT), modifier si nécessaire"]
[]
[]
[null,null,null,null,null,"(*) Vous avez alors la possibilité, soit d'utiliser l'éco fuel (utilisation chapitre 7.1 ), pour rajouter de l'autonomie (exemple PIT 1)\n\nSoit de saisir un nombre de tours </= à l'autonomie max"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Les valeurs gains au tour peuvent êtres modifiées et ajustées à vos essais en cliquant sur la commande \"Ajustement\""]
[]
[]
[]
[null,"5) Calcul des temps d'arrêt au stand :"]
[null,"Des temps sont indiqués par défaut mais en fonction des circuits et des mises à jour de Gran Turismo il est nécessaire de les réajuster."]
[null,"Dans tous les cas il sera judicieux de les vérifier. Le temps d'arrêt au stand est un facteur important dans une stratégie de course !"]
[null,"Cliquez sur la commande \"calcul tps arrêts\" pour entrée les données nécessaires aux calculs des temps d'arrêts."]
[]
[]
[]
[]
[null,"Vous pouvez retrouver les infos, vitesse de ravitaillement dans le règlement des courses sur Gran Turismo et sur le site KUDOSPRIME (évents)"]
[null,"Sur Gran Turismo\ndans le mode sport\ncliquer sur"]
[]
[]
[null,"Mode de calcul utilisé pour l'application :"]
[null,null,null,null,null,null,null,null,null,null,"Pour obtenir le temps t2 :\nfaire un arrêt au stand avec changement de pneus et relever le temps d'arrêt affiché sur l'écran à la sortie du stand."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Pour obtenir le temps t1 :\nchronométrer à l'aide d'une rediffusion le temps de passage entre l'entrée et la sortie des stands en condition course."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Pour obtenir le tems de refuel  par tour :\nfaire un arrêt au stand avec changement de pneu et refuel complet. Relever le temps d'arrêt affiché sur l'écran à la sortie du stand et soustrayez ce temps à t1"]
[]
[]
[]
[]
[]
[]
[null,"6) Elaboration stratégie de course :"]
[null,"A vous de jouer !   Avec l'aide d'une ou des trois interfaces, Strat 1, Strat 2 et Strat 3 :"]
[null,null,"choisissez le nombre de tours entre chaque pit (le besoin en fuel se calculera automatiquement), et si vous dépassez la capacité"]
[null,null,"maxi du réservoir un message d'alerte \"dépasse\" apparaitra."]
[null,null,"choisissez le ou les types de pneumatiques (dont vous aurez préalablement saisie les temps au tour)."]
[null,"Saisie du tableau de bord - 2 à 3 informations à complèter à chaque pit :"]
[null,"obligatoire","1)","le nombre de tours entre chaque pit (ex: 5; 7; 10)"]
[null,"obligatoire","2)","le type de pneumatique (menu déroulant) soft, médium, hard"]
[null,"si besoin","3)","le niveau d'économiseur de fuel (ex : 2 si utilisation)"]
[null,"Exemple tableau de bord :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Interprétation du tableau de bord ci-dessus pour une autonomie de 15 tours :"]
[null,"1ère colonne, départ : pneus hard, absence de conduite éco, 15 tours à faire       (utilisation conduite éco voir chapitre 7.1)"]
[null,"1er PIT à 15 tours : chausse de pneus médium, ravitaillement niveau jauge 100% (ou 15 tours). Utilisation éco fuel niv 2 pour faire 18 tours"]
[null,null,"L'utilisation de la conduite éco fera perdre 8,3 sec en moyenne sur les 18 tours"]
[null,"2éme PIT au tour n°33 : chausse de pneus soft, ravitaillement niveau jauge 47% (ou 7 tours) absence de conduite éco"]
[null,"Arrivée au tour 40 après 1h40 de course."]
[null,"IMPORTANT :","Les types de pneus sélectionnés dans votre stratégie devront impérativement êtres associés à un temps chrono"]
[null,null,"Auquel cas les données indiquées seront erronées."]
[]
[null,"Informations complémentaires du tableau de bord :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"7.1) Conduite économique :"]
[null,"Comme dans le jeu GTS vous avez deux possibilités :"]
[null,"1)","utilisez le compte tour comme indicateur de conduite économe en réalisant votre course ou une partie de votre course"]
[null,null,"en limitant plus ou moins les tours moteur."]
[null,null,"trois choix simulés en terme de gain d'autonomie et de perte de temps sont proposés."]
[null,"Si vous adopter un mode de conduite qui consiste à changer les rapports de vitesses sans monter à fond dans les tours moteur : "]
[null,"sélectionnez dans le menu déroulant \"Conduite éco\" :"]
[]
[null,"tr/mn 2/3","correspond à changer les rapports à  2/3 des leds du compte tour"]
[null,"tr/mn1/2","correspond à changer les rapports à la moitié des leds du compte tour"]
[null,"tr/mn 1/3","correspond à changer les rapports dès l'appariation 1ère led du compte tour"]
[null,"Le calculateur simulera le gain d'autonomie et la perte de temps au km"]
[]
[null,"2)","utiliser l'économie de fuel disponible dans la fonction du jeu GTS :"]
[null,"Les choix 2; 3; 4; 5 et 6 du menu déroulant correspondent au mode éco du jeux"]
[null,"GTS qui consiste à la réduction plus ou moins importante de la puissance du véhicule."]
[null,"Le simulateur calculera le gain d'autonomie et la perte de temps au km"]
[null,"suivant le niveau de réduction de la puissance moteur sélectionné (1 seul choix par PIT possible)"]
[]
[null,"7.2) Ajustement autonomie et perte de temps en cas de conduite éco :"]
[null,"Vous avez la possibilité en cliquant sur le bouton   ",null,null,null,null,"d'affiner l'autonomie et la perte de temps en fonction"]
[null,"de vos essais en modifiant les valeurs par défaut du calculateur."]
[]
[null,null,null,null,null,null,null,null,null,null,"La modification des valeurs \"gain autonomie\" agit sur la distance supplémentaire parcourue en fonction du niveau d'éco utilisé"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"La modification des valeurs \"réduction vitesse\" agit sur la dégradation des temps en fonction de la vitesse"]
[]
[]
[]
[]
[]
[]
[]
[null,"8) Comparateur de stratégie :"]
[]
[null,"Cliquez sur le bouton                              pour avoir accès au comparateur de stratégie."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"La meilleur stratégie sera en principe celle ou la majorité des indicateurs seront verts avec le temps moyen / tour le plus faible et l'indice de risque"]
[null,"le moins élevé."]
[null,"Dans l'exemple ci-dessus, la stratégie 3 s'avère la mieux adaptée. Malgré un nombre de pits supérieur, le temps moyen/tour et l'indice de risque sont"]
[null,"les plus faibles."]
[null,"Le fil conducteur pendant la course est d'être au plus près des temps de références moyens au tour en fonction des types de pneus."]
[]
[null,"Imprimer le tableau de bord ou afficher le sur l'écran d'un ordinateur pour suivre votre stratégie pendant la course…"]
[null,"Vous pourrez vous concentrer sur votre conduite et vos points de freinage sans perdre le fil de votre stratégie !"]
[]
[null,null,null,null,null,"Bon jeux !"]

{"sheet":"Strat 1","index":1,"n_rows":87,"n_cols":24,"rows_kept":87,"cut":false,"hidden":false,"merged":[[13,4,13,5],[49,20,49,21],[42,1,42,2],[11,6,12,6],[11,10,12,10],[11,14,12,14],[23,8,23,9],[23,11,23,13],[28,19,29,19],[17,14,17,15],[42,16,43,16],[27,1,28,6],[27,7,28,7],[34,1,34,2],[31,1,31,2],[40,1,40,2],[36,16,36,17],[44,1,44,2],[56,20,57,20],[63,16,63,19],[64,16,64,19],[41,1,41,2],[19,14,20,14],[21,11,21,13],[21,8,21,9],[27,15,28,17],[27,12,28,14],[2,23,2,24],[6,16,6,17],[4,16,4,17],[28,23,28,24],[0,0,1,1],[2,0,24,1],[2,4,2,7],[2,8,2,9],[2,13,2,15],[6,4,6,7],[6,8,6,9],[4,8,4,9],[4,14,4,15],[23,5,23,6],[21,5,21,6],[17,5,17,7],[4,2,4,4],[4,26,4,28],[4,29,4,31],[4,23,4,25],[6,12,6,13],[44,23,44,24],[42,23,43,24],[69,8,69,9],[69,10,69,11],[9,11,9,12],[9,15,9,16],[67,16,67,17],[67,13,67,14],[16,23,24,25],[27,8,28,10],[25,1,25,18],[38,1,38,2],[36,1,36,2],[30,1,30,2],[20,2,21,4],[19,17,20,17],[36,29,36,30],[38,23,38,24],[38,26,38,27],[38,29,38,30],[36,23,36,24],[36,26,36,27],[71,13,71,15],[49,1,49,2],[69,16,69,17],[70,13,70,14],[69,13,69,15],[67,1,67,2],[67,6,71,7],[67,8,67,9],[67,10,67,11],[69,1,69,2],[71,1,71,2],[71,4,71,5],[71,8,71,9],[71,10,71,11],[69,4,69,5]]}
[]
[]
["DONNEES COURSE",null,"Circuit / Piste :",null,null,null,null,null,"Longueur circuit :",null,{"$f":"VLOOKUP(E3,grille!K19:L102,2,FALSE)","v":{"$error":"#N/A"}},"corners :",{"$f":"VLOOKUP(E3,grille!K19:M102,3,FALSE)","v":{"$error":"#N/A"}},"Condition météo, horaire : ",null,null,null,"0h0",null,null,null,null,null,"Menus"]
[]
[null,null,"Catégorie du  véhicule : ",null,null,null,null,null,"Durée de la course :",null,"00:00:00","hr     où",0,{"$f":"K5+K68+K7","v":{"$error":"#DIV/0!"}},"Host salon : "]
[]
[null,null,"Modèle :",null,null,null,null,null,"Temps au tours : ",null,"00:00:40",null,null,null,null,"Cast : "]
[]
[]
[null,null,null,null,"condition usure",null,"pneus 1",null,null,null,"pneus 2",null,null,null,"pneus 3"]
[null,null,"Pneumatique :",null,{"$f":"chronos!G7","v":"X1"},null,{"$f":"chronos!C18","v":0},"Monte : ",null,null,{"$f":"chronos!C19","v":0},"Monte : ",null,null,{"$f":"chronos!C20","v":0},"Monte : "]
[null,null,null,null,null,null,"durée de vie","nbr tours",1,null,"durée de vie","nbr tours",1,null,"durée de vie","nbr tours",1]
[]
[null,null,null,null,"Trains de pneus : ",null,null,"temps : ",{"$f":"'nbr tours'!H10","v":{"$error":"#DIV/0!"}},null,null,"temps : ",{"$f":"'nbr tours'!H11","v":{"$error":"#DIV/0!"}},null,null,"temps : ",{"$f":"'nbr tours'!H12","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,"condition fuel",null,null,null,"réservoir",null,"volume",null,"consommation","taux/vol",null,null,"volume",null,null,null,null,null,null,"S1"]
[null,null,null,null,{"$f":"chronos!K7","v":"X1"},"Fourchette autonomie max :",null,null,0,"pour",100,"soit",{"$f":"'ajust éco'!D9*'Strat 1'!K3","v":{"$error":"#N/A"}},{"$f":"(M18*1)/K18","v":{"$error":"#N/A"}},"Jauge initiale : ",null,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M18","v":{"$error":"#N/A"}},{"$f":"K3","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Litre/Sec",null,null,"1 tour",null,null,{"$f":"K18/V22","v":{"$error":"#N/A"}}]
[null,null,"Temps d'arrêt au stand :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L/KM"]
[null,null,null,null,null,"ENTREE / SORTIE : ",null,{"$f":"PIT!S9-PIT!S7","v":1.0999999999999996},"ECHANGE PNEUS :  ",null,{"$f":"PIT!S7","v":4.5},"REFUEL vitesse de ravitaillement : ",null,null,{"$f":"PIT!S17","v":5.7471264367816097},null,1,{"$f":"PIT!S13","v":{"$error":"#DIV/0!"}},null,null,{"$f":"I18","v":0},{"$f":"K3*I18","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 plein"]
[null,null,null,null,null,"Echange pneumatiques : ",null,{"$f":"H22+K22","v":5.6},"Temps pneus + fuel : ",null,{"$f":"H24+(I18*R22)","v":{"$error":"#DIV/0!"}},"Nbr de tours total de refuel : ",null,null,{"$f":"U42","v":{"$error":"#N/A"}},{"$f":"O24*R22","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Tableau de bord stratégie de course ",null,null,null,null,null,1,"Indiquez la durée de vie des trains de pneus dans les données course",null,null,null,"Au moins un type de gomme obligatoire n'est pas utilisé",null,null,"Vous dépassez la durée de\ncourse de plus d'un tour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total nbr de tours"]
[]
[null,"Nbr de tours / pit",null,null,"Départ",null,"Pit 1",null,"Pit 2",null,"Pit 3",null,"Pit 4",null,"Pit 5",null,null,null,null,{"$f":"R31+P31+N31+L31+J31+H31+F31","v":0}]
[null,"Pertes de temps total : purge pénalité...",null,null,null,{"$f":"VLOOKUP(E39,'nbr tours'!$D$10:$E$12,2,FALSE)","v":0},null,{"$f":"VLOOKUP(G39,'nbr tours'!$D$10:$E$12,2,FALSE)","v":0},null,{"$f":"VLOOKUP(I39,'nbr tours'!$D$10:$E$12,2,FALSE)","v":0},null,{"$f":"VLOOKUP(K39,'nbr tours'!$D$10:$E$12,2,FALSE)","v":0},null,{"$f":"VLOOKUP(M39,'nbr tours'!$D$10:$E$12,2,FALSE)","v":0},null,{"$f":"VLOOKUP(O39,'nbr tours'!$D$10:$E$12,2,FALSE)","v":0},7,{"$f":"Q32*R33","v":0}]
[null,null,"00:00:00",null,null,{"$f":"F31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F32<F31)=\"VRAI\",\"\",F32<F31)","v":false},{"$f":"H31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(H32<H31)=\"VRAI\",\"\",H32<H31)","v":false},{"$f":"J31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(J32<J31)=\"VRAI\",\"\",J32<J31)","v":false},{"$f":"L31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(L32<L31)=\"VRAI\",\"\",L32<L31)","v":false},{"$f":"N31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(N32<N31)=\"VRAI\",\"\",N32<N31)","v":false},{"$f":"P31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(P32<P31)=\"VRAI\",\"\",P32<P31)","v":false},{"$f":"COUNTIF(G33:Q33,\"VRAI\")","v":0}]
[]
[null,"Tours & Temps",null,null,null,{"$f":"F31","v":0},{"$f":"F31*E72","v":{"$error":"#N/A"}},{"$f":"F35+H31","v":0},{"$f":"(E72*H31)+G35","v":{"$error":"#N/A"}},{"$f":"H35+J31","v":0},{"$f":"(J31*E72)+I35","v":{"$error":"#N/A"}},{"$f":"J35+L31","v":0},{"$f":"L31*E72+K35","v":{"$error":"#N/A"}},{"$f":"L35+N31","v":0},{"$f":"(N31*E72)+M35","v":{"$error":"#N/A"}},{"$f":"N35+P31","v":0},{"$f":"(P31*E72)+O35","v":{"$error":"#N/A"}},{"$f":"P35+R31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"F31","v":0},null,{"$f":"H31+F31","v":0},null,{"$f":"J31+H31+F31","v":0},null,{"$f":"L31+J31+H31+F31","v":0},null,{"$f":"N31+L31+J31+H31+F31","v":0},null,"Dépassement nbr de tours"]
[]
[null,"Type pneus"]
[]
[null,null,null,null,{"$f":"Q18","v":100},null,{"$f":"G43*100","v":{"$error":"#N/A"}},null,{"$f":"I43*100","v":{"$error":"#N/A"}},null,{"$f":"K43*100","v":{"$error":"#N/A"}},null,{"$f":"M43*100","v":{"$error":"#N/A"}},null,{"$f":"O43*100","v":{"$error":"#N/A"}},null,null,null,null,"refuel en litres","refuel en tours"]
[null,"E42 conso L/km /  F42 besoin",null,null,{"$f":"VLOOKUP(E45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(F33*E42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(H33*G42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(I45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(J33*I42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(L33*K42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(N33*M42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(P33*O42)","v":{"$error":"#N/A"}},null,null,null,{"$f":"G41+I41+K41+M41+O41","v":{"$error":"#N/A"}},{"$f":"T42/$M$18","v":{"$error":"#N/A"}}]
[null,"Jauge fuel",null,null,{"$f":"Q18/100","v":1},{"$f":"(E43*$I$18)/1","v":0},{"$f":"MIN(100%,(SUM(H31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(G43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(J31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(I43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(L31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(K43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(N31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(M43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(P31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(O43*$I$18)/1","v":{"$error":"#N/A"}},"cumul perte de temps conduite éco"]
[]
[null,"Eco fuel ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52","v":"00:00:00"},null,null,null,null,null,""]
[]
[null,null,"conso L/tour avec éco",null,{"$f":"E42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"G42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"I42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"K42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"M42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"O42*$K$3","v":{"$error":"#N/A"}}]
[null,null,"calcul perte temps",null,{"$f":"VLOOKUP(E45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(G45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(I45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(K45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(M45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(O45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0}]
[null,null,null,null,{"$f":"E41/E47","v":{"$error":"#N/A"}},null,{"$f":"G41/G47","v":{"$error":"#N/A"}},null,{"$f":"I41/I47","v":{"$error":"#N/A"}},null,{"$f":"K41/K47","v":{"$error":"#N/A"}},null,{"$f":"M41/M47","v":{"$error":"#N/A"}},null,{"$f":"O41/O47","v":{"$error":"#N/A"}}]
[null,"Autonomie",null,null,{"$f":"IF(F42>E41+1,\"dépasse\",E49)","v":{"$error":"#N/A"}},null,{"$f":"IF(H42>G41+1,\"dépasse\",G49)","v":{"$error":"#N/A"}},null,{"$f":"IF(J42>I41+1,\"dépasse\",I49)","v":{"$error":"#N/A"}},null,{"$f":"IF(L42>K41+1,\"dépasse\",K49)","v":{"$error":"#N/A"}},null,{"$f":"IF(N42>M41+1,\"dépasse\",M49)","v":{"$error":"#N/A"}},null,{"$f":"IF(P42>O41+1,\"dépasse\",O49)","v":{"$error":"#N/A"}},null,null,null,null,null,"somme perte de tps utilisation éco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hr/mn/sec","1/100 hr"]
[null,null,"Calcul augmentation tps/tour en fonction de la conduite",null,{"$f":"E48*F31","v":0},null,{"$f":"G48*H31","v":0},null,{"$f":"I48*J31","v":0},null,{"$f":"K48*L31","v":0},null,{"$f":"M48*N31","v":0},null,{"$f":"O48*P31","v":0},null,"nbr tours /type pneus","chronos",null,"tps total / type pneu",{"$f":"V52/86400","v":"00:00:00"},{"$f":"E52+G52+I52+K52+M52+O52","v":0}]
[null,null,"S soft",null,{"$f":"SUMIF(E39,\"S soft\",F31)","v":0},null,{"$f":"SUMIF(G39,\"S soft\",H31)","v":0},{"$f":"IF(G53>0,1,0)","v":0},{"$f":"SUMIF(I39,\"S soft\",J31)","v":0},{"$f":"IF(I53>0,1,0)","v":0},{"$f":"SUMIF(K39,\"S soft\",L31)","v":0},{"$f":"IF(K53>0,1,0)","v":0},{"$f":"SUMIF(M39,\"S soft\",N31)","v":0},{"$f":"IF(M53>0,1,0)","v":0},{"$f":"SUMIF(O39,\"S soft\",P31)","v":0},{"$f":"IF(O53>0,1,0)","v":0},{"$f":"E53+G53+I53+K53+M53+O53","v":0},{"$f":"VLOOKUP(C53,'nbr tours'!$D$10:$H$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q53)*R53,0)","v":0}]
[null,null,"soft",null,{"$f":"SUMIF(E39,\"soft\",F31)","v":0},null,{"$f":"SUMIF(G39,\"soft\",H31)","v":0},{"$f":"IF(G54>0,1,0)","v":0},{"$f":"SUMIF(I39,\"soft\",J31)","v":0},{"$f":"IF(I54>0,1,0)","v":0},{"$f":"SUMIF(K39,\"soft\",L31)","v":0},{"$f":"IF(K54>0,1,0)","v":0},{"$f":"SUMIF(M39,\"soft\",N31)","v":0},{"$f":"IF(M54>0,1,0)","v":0},{"$f":"SUMIF(O39,\"soft\",P31)","v":0},{"$f":"IF(O54>0,1,0)","v":0},0,{"$f":"VLOOKUP(C54,'nbr tours'!$D$10:$H$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q54)*R54,0)","v":0}]
[null,null,"médium",null,{"$f":"SUMIF(E39,\"médium\",F31)","v":0},null,{"$f":"SUMIF(G39,\"médium\",H31)","v":0},{"$f":"IF(G55>0,1,0)","v":0},{"$f":"SUMIF(I39,\"médium\",J31)","v":0},{"$f":"IF(I55>0,1,0)","v":0},{"$f":"SUMIF(K39,\"médium\",L31)","v":0},{"$f":"IF(K55>0,1,0)","v":0},{"$f":"SUMIF(M39,\"médium\",N31)","v":0},{"$f":"IF(M55>0,1,0)","v":0},{"$f":"SUMIF(O39,\"médium\",P31)","v":0},{"$f":"IF(O55>0,1,0)","v":0},0,{"$f":"VLOOKUP(C55,'nbr tours'!$D$10:$H$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q55)*R55,0)","v":0}]
[null,null,"hard",null,{"$f":"SUMIF(E39,\"hard\",F31)","v":0},null,{"$f":"SUMIF(G39,\"hard\",H31)","v":0},{"$f":"IF(G56>0,1,0)","v":0},{"$f":"SUMIF(I39,\"hard\",J31)","v":0},{"$f":"IF(I56>0,1,0)","v":0},{"$f":"SUMIF(K39,\"hard\",L31)","v":0},{"$f":"IF(K56>0,1,0)","v":0},{"$f":"SUMIF(M39,\"hard\",N31)","v":0},{"$f":"IF(M56>0,1,0)","v":0},{"$f":"SUMIF(O39,\"hard\",P31)","v":0},{"$f":"IF(O56>0,1,0)","v":0},0,{"$f":"VLOOKUP(C56,'nbr tours'!$D$10:$H$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q56*R56,0)","v":0}]
[null,null,"(sans) changement de pneus",null,{"$f":"SUMIF(E39,\"sans\",F31)","v":0},null,{"$f":"SUMIF(G39,\"sans\",H31)","v":0},null,{"$f":"SUMIF(I39,\"sans\",J31)","v":0},null,{"$f":"SUMIF(K39,\"sans\",L31)","v":0},null,{"$f":"SUMIF(M39,\"sans\",N31)","v":0},null,{"$f":"SUMIF(O39,\"sans\",P31)","v":0},null,0,{"$f":"chronos!N18","v":{"$error":"#DIV/0!"}},null,{"$f":"IFERROR(Q57*R57,0)","v":0},"cumul pertes de temps"]
[null,null,"inter",null,{"$f":"SUMIF(E39,\"inter\",F31)","v":0},null,{"$f":"SUMIF(G39,\"inter\",H31)","v":0},{"$f":"IF(G58>0,1,0)","v":0},{"$f":"SUMIF(I39,\"inter\",J31)","v":0},{"$f":"IF(I58>0,1,0)","v":0},{"$f":"SUMIF(K39,\"inter\",L31)","v":0},{"$f":"IF(K58>0,1,0)","v":0},{"$f":"SUMIF(M39,\"inter\",N31)","v":0},{"$f":"IF(M58>0,1,0)","v":0},{"$f":"SUMIF(O39,\"inter\",P31)","v":0},{"$f":"IF(O58>0,1,0)","v":0},0,{"$f":"VLOOKUP(C58,'nbr tours'!$D$10:$H$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q58*R58,0)","v":0}]
[null,null,"pluie",null,{"$f":"SUMIF(E39,\"pluie\",F31)","v":0},null,{"$f":"SUMIF(G39,\"pluie\",H31)","v":0},{"$f":"IF(G59>0,1,0)","v":0},{"$f":"SUMIF(I39,\"pluie\",J31)","v":0},{"$f":"IF(I59>0,1,0)","v":0},{"$f":"SUMIF(K39,\"pluie\",L31)","v":0},{"$f":"IF(K59>0,1,0)","v":0},{"$f":"SUMIF(M39,\"pluie\",N31)","v":0},{"$f":"IF(M59>0,1,0)","v":0},{"$f":"SUMIF(O39,\"pluie\",P31)","v":0},{"$f":"IF(O59>0,1,0)","v":0},0,{"$f":"VLOOKUP(C59,'nbr tours'!$D$10:$H$12,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q59*R59,0)","v":0},{"$f":"U65+V52+C33","v":{"$error":"#N/A"}},{"$f":"U59/86400","v":{"$error":"#N/A"}}]
[null,null,"Nbr de changements de pneu",null,null,null,null,{"$f":"SUM(H53:H59)","v":0},null,{"$f":"SUM(J53:J59)","v":0},null,{"$f":"SUM(L53:L59)","v":0},null,{"$f":"SUM(N53:N59)","v":0},null,{"$f":"SUM(P53:P59)","v":0},{"$f":"P60+N60+L60+J60+H60+F60","v":0},null,null,{"$f":"SUM(T53:T59)","v":0},{"$f":"U59/N68","v":{"$error":"#N/A"}},{"$f":"U60/86400","v":{"$error":"#N/A"}}]
[null,null,"Nbr de refuels",null,null,{"$f":"IF(H42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(J42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(L42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(N42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(P42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(Q42>0,1,0)","v":0},{"$f":"P61+N61+L61+J61+H61+F61","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tps échange pneu :",{"$f":"Q60*K22","v":0},{"$f":"U62/86400","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tps refuel :",{"$f":"$U$42*$R$22","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"somme max refuel ou échange pneus :",null,null,null,{"$f":"MAX(Q60:Q61)","v":{"$error":"#N/A"}},{"$f":"H22/86400","v":"00:00:01.100"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps total arrêt au stand : ",null,null,null,{"$f":"(U64*H22)+U62+U63","v":{"$error":"#N/A"}},{"$f":"U65/86400","v":{"$error":"#N/A"}}]
[]
[]
[null,"Nombre de pits",null,null,{"$f":"U64","v":{"$error":"#N/A"}},null,"Temps\nmoyen\n au tour",null,{"$f":"G11","v":0},null,{"$f":"VLOOKUP(I68,'nbr tours'!$D$10:$H$15,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"T31","v":0},null,"en",{"$f":"T60+V59","v":{"$error":"#N/A"}}]
[]
[null,"Cumul tps pit(s)",null,null,{"$f":"V65","v":{"$error":"#N/A"}},null,null,null,{"$f":"K11","v":0},null,{"$f":"VLOOKUP(I70,'nbr tours'!$D$10:$H$15,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,"Distance totale : ",null,null,{"$f":"N68*K3","v":{"$error":"#N/A"}}]
[]
[null,"Tps moyen avec pit",null,null,{"$f":"(T60+V59)/T31","v":{"$error":"#N/A"}},null,null,null,{"$f":"O11","v":0},null,{"$f":"VLOOKUP(I72,'nbr tours'!$D$10:$H$15,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,"Info consommation : ",null,null,1,{"$f":"N18*Q72","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Utilisation",null,{"$f":"G11","v":0},{"$f":"K11","v":0},{"$f":"O11","v":0}]
[null,null,null,null,{"$f":"I11","v":0},{"$f":"M11","v":0},{"$f":"Q11","v":0}]
[null,null,"Obligatoire(s)",null,{"$f":"IF(E84=\"obligatoire\",E83,\"libre\")","v":"libre"},{"$f":"IF(F84=\"obligatoire\",F83,\"libre\")","v":"libre"},{"$f":"IF(G84=\"obligatoire\",G83,\"libre\")","v":"libre"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Utilisés",null,{"$f":"E39","v":0},{"$f":"G39","v":0},{"$f":"I39","v":0},{"$f":"K39","v":0},{"$f":"M39","v":0},{"$f":"O39","v":0},"libre",{"$f":"ISNUMBER(MATCH(E85,$E$87:$K$87,0))","v":true},{"$f":"ISNUMBER(MATCH(F85,$E$87:$K$87,0))","v":true},true,null,{"$f":"COUNTIF(L87:N87,\"FAUX\")","v":0}]

{"sheet":"Strat 2","index":2,"n_rows":87,"n_cols":24,"rows_kept":87,"cut":false,"hidden":false,"merged":[[27,8,28,10],[25,2,25,18],[44,23,44,24],[42,16,43,16],[42,23,43,24],[38,23,38,24],[30,1,30,2],[27,1,28,6],[27,7,28,7],[27,12,28,14],[31,1,31,2],[40,1,40,2],[41,1,41,2],[34,1,34,2],[42,1,42,2],[44,1,44,2],[56,20,57,20],[49,20,49,21],[71,1,71,2],[71,4,71,5],[71,8,71,9],[71,10,71,11],[69,4,69,5],[69,8,69,9],[69,10,69,11],[67,1,67,2],[67,6,71,7],[67,8,67,9],[67,10,67,11],[49,1,49,2],[69,1,69,2],[38,26,38,27],[38,29,38,30],[36,1,36,2],[36,23,36,24],[36,26,36,27],[36,29,36,30],[38,1,38,2],[36,16,36,17],[4,29,4,31],[6,4,6,7],[6,8,6,9],[6,13,6,14],[6,16,6,17],[4,2,4,4],[4,8,4,9],[4,26,4,28],[4,23,4,25],[0,0,1,1],[2,0,24,1],[2,4,2,7],[20,2,21,4],[21,5,21,6],[11,6,12,6],[13,4,13,5],[23,5,23,6],[17,5,17,7],[2,23,2,24],[4,14,4,15],[4,16,4,17],[17,14,17,15],[28,19,29,19],[2,13,2,15],[16,23,24,25],[19,14,20,14],[19,17,20,17],[9,15,9,16],[29,23,30,24],[9,11,9,12],[2,8,2,9],[27,15,28,17],[71,13,71,15],[63,16,63,19],[64,16,64,19],[67,16,67,17],[69,13,69,15],[69,16,69,17],[21,8,21,9],[21,11,21,13],[11,10,12,10],[11,14,12,14],[23,8,23,9],[23,11,23,13],[67,13,67,14]]}
[]
[]
["DONNEES COURSE",null,"Circuit / Piste :",null,{"$f":"'Strat 1'!E3:H3","v":0},null,null,null,"Longueur circuit :",null,{"$f":"'Strat 1'!K3","v":{"$error":"#N/A"}},"corners :",{"$f":"'Strat 1'!M3","v":{"$error":"#N/A"}},"Condition météo, horaire : ",null,null,{"$f":"'Strat 1'!Q3","v":0},{"$f":"'Strat 1'!R3","v":"0h0"},"hr",null,null,null,null,"Menus"]
[]
[null,null,"Catégorie du  véhicule : ",null,null,{"$f":"'Strat 1'!F5","v":0},null,null,"Durée de la course :",null,{"$f":"'Strat 1'!K5","v":"00:00:00"},"hr     où",{"$f":"'Strat 1'!M5","v":0},{"$f":"'Strat 1'!N5","v":{"$error":"#DIV/0!"}},"Host salon : ",null,{"$f":"'Strat 1'!Q5:R5","v":0}]
[]
[null,null,"Modèle :",null,{"$f":"'Strat 1'!E7:H7","v":0},null,null,null,null,null,null,null,null,null,null,"Cast : ",{"$f":"'Strat 1'!Q7:R7","v":0}]
[]
[]
[null,null,null,null,"condition usure",null,"pneus 1",null,null,null,"pneus 2",null,null,null,"pneus 3"]
[null,null,"Pneumatique :",null,{"$f":"chronos!G7","v":"X1"},null,{"$f":"'Strat 1'!G11","v":0},"Monte : ",{"$f":"'Strat 1'!I11","v":0},null,{"$f":"'Strat 1'!K11","v":0},"Monte : ",{"$f":"'Strat 1'!M11","v":0},null,{"$f":"'Strat 1'!O11","v":0},"Monte : ",{"$f":"'Strat 1'!Q11","v":0}]
[null,null,null,null,null,null,"durée de vie","nbr tours",{"$f":"'Strat 1'!I12","v":1},null,"durée de vie","nbr tours",{"$f":"'Strat 1'!M12","v":1},null,"durée de vie","nbr tours",{"$f":"'Strat 1'!Q12","v":1}]
[]
[null,null,null,null,"Trains de pneus : ",null,null,"tps moyen",{"$f":"'nbr tours'!H106","v":{"$error":"#DIV/0!"}},null,null,"tps moyen",{"$f":"'nbr tours'!H107","v":{"$error":"#DIV/0!"}},null,null,"tps moyen",{"$f":"'nbr tours'!H108","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,"condition fuel",null,null,null,"réservoir",null,"volume",null,"consommation","taux/vol",null,null,"volume",null,null,null,null,null,null,"S2"]
[null,null,"Carburant :",null,{"$f":"'Strat 1'!E18","v":"X1"},"Fourchette autonomie max :",null,null,{"$f":"'Strat 1'!I18","v":0},"pour",{"$f":"'Strat 1'!K18","v":100},"soit",{"$f":"'Strat 1'!M18","v":{"$error":"#N/A"}},{"$f":"'Strat 1'!N18","v":{"$error":"#N/A"}},"Jauge initiale : ",null,{"$f":"'Strat 1'!Q18","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Litre/Sec",null,null,"1 tour"]
[null,null,"Temps d'arrêt au stand :"]
[null,null,null,null,null,"ENTREE / SORTIE : ",null,{"$f":"'Strat 1'!H22","v":1.0999999999999996},"ECHANGE PNEUS :  ",null,{"$f":"'Strat 1'!K22","v":4.5},"REFUEL vitesse de ravitaillement : ",null,null,{"$f":"'Strat 1'!O22","v":5.7471264367816097},null,1,{"$f":"'Strat 1'!R22","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Echange pneumatiques : ",null,{"$f":"'Strat 1'!H24","v":5.6},"Temps pneus + fuel : ",null,{"$f":"H24+(I18*R22)","v":{"$error":"#DIV/0!"}},"Nbr de tours total de refuel : ",null,null,{"$f":"U42","v":{"$error":"#N/A"}},{"$f":"O24*R22","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Tableau de bord stratégie de course ",null,null,null,null,null,2,"Indiquez la durée de vie des trains de pneus dans les données course",null,null,null,"Au moins un type de gomme obligatoire n'est pas utilisé",null,null,"Vous dépassez la durée de\ncourse de plus d'un tour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total nbr de tours"]
[]
[null,"Nbr de tours / pit",null,null,"Départ",null,"Pit 1",null,"Pit 2",null,"Pit 3",null,"Pit 4",null,"Pit 5",null,null,null,null,{"$f":"R31+P31+N31+L31+J31+H31+F31","v":0}]
[null,"Pertes de temps total : purge pénalité...",null,null,null,{"$f":"VLOOKUP(E39,'nbr tours'!$D$106:$E$111,2,FALSE)","v":0},null,{"$f":"VLOOKUP(G39,'nbr tours'!$D$106:$E$111,2,FALSE)","v":0},null,{"$f":"VLOOKUP(I39,'nbr tours'!$D$106:$E$111,2,FALSE)","v":0},null,{"$f":"VLOOKUP(K39,'nbr tours'!$D$106:$E$111,2,FALSE)","v":0},null,{"$f":"VLOOKUP(M39,'nbr tours'!$D$106:$E$111,2,FALSE)","v":0},null,{"$f":"VLOOKUP(O39,'nbr tours'!$D$106:$E$111,2,FALSE)","v":0},{"$f":"'Strat 1'!Q32","v":7},{"$f":"Q32*R33","v":0}]
[null,null,"00:00:00",null,null,{"$f":"F31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F32<F31)=\"VRAI\",\"\",F32<F31)","v":false},{"$f":"H31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(H32<H31)=\"VRAI\",\"\",H32<H31)","v":false},{"$f":"J31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(J32<J31)=\"VRAI\",\"\",J32<J31)","v":false},{"$f":"L31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(L32<L31)=\"VRAI\",\"\",L32<L31)","v":false},{"$f":"N31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(N32<N31)=\"VRAI\",\"\",N32<N31)","v":false},{"$f":"P31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(P32<P31)=\"VRAI\",\"\",P32<P31)","v":false},{"$f":"COUNTIF(G33:Q33,\"VRAI\")","v":0}]
[]
[null,"Tours & Temps",null,null,null,{"$f":"F31","v":0},{"$f":"F31*E72","v":{"$error":"#N/A"}},{"$f":"F35+H31","v":0},{"$f":"(E72*H31)+G35","v":{"$error":"#N/A"}},{"$f":"H35+J31","v":0},{"$f":"(J31*E72)+I35","v":{"$error":"#N/A"}},{"$f":"J35+L31","v":0},{"$f":"L31*E72+K35","v":{"$error":"#N/A"}},{"$f":"L35+N31","v":0},{"$f":"(N31*E72)+M35","v":{"$error":"#N/A"}},{"$f":"N35+P31","v":0},{"$f":"(P31*E72)+O35","v":{"$error":"#N/A"}},{"$f":"P35+R31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"F31","v":0},null,{"$f":"H31+F31","v":0},null,{"$f":"J31+H31+F31","v":0},null,{"$f":"L31+J31+H31+F31","v":0},null,{"$f":"N31+L31+J31+H31+F31","v":0},null,"Dépassement nbr de tours"]
[]
[null,"Type pneus"]
[]
[null,"litres restant E40 / besoin hors éco F40",null,null,{"$f":"Q18","v":100},null,{"$f":"G43*100","v":{"$error":"#N/A"}},null,{"$f":"I43*100","v":{"$error":"#N/A"}},null,{"$f":"K43*100","v":{"$error":"#N/A"}},null,{"$f":"M43*100","v":{"$error":"#N/A"}},null,{"$f":"O43*100","v":{"$error":"#N/A"}},null,null,null,null,"refuel en litres","refuel en tours"]
[null,"ajust conso E41 / conso réelle F41",null,null,{"$f":"VLOOKUP(E45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(F33*E42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(H33*G42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(I45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(J33*I42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(L33*K42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(N33*M42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(P33*O42)","v":{"$error":"#N/A"}},null,null,null,{"$f":"G41+I41+K41+M41+O41","v":{"$error":"#N/A"}},{"$f":"T42/$M$18","v":{"$error":"#N/A"}}]
[null,"Jauge fuel",null,null,{"$f":"Q18/100","v":1},{"$f":"(E43*$I$18)/1","v":0},{"$f":"MIN(100%,(SUM(H31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(G43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(J31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(I43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(L31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(K43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(N31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(M43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(P31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(O43*$I$18)/1","v":{"$error":"#N/A"}},"cumul perte de temps conduite éco"]
[]
[null,"Eco fuel ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52","v":"00:00:00"},null,null,null,null,null,""]
[]
[null,null,null,null,{"$f":"E42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"G42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"I42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"K42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"M42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"O42*$K$3","v":{"$error":"#N/A"}}]
[null,null,"calcul perte temps",null,{"$f":"VLOOKUP(E45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(G45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(I45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(K45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(M45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(O45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0}]
[null,null,null,null,{"$f":"E41/E47","v":{"$error":"#N/A"}},null,{"$f":"G41/G47","v":{"$error":"#N/A"}},null,{"$f":"I41/I47","v":{"$error":"#N/A"}},null,{"$f":"K41/K47","v":{"$error":"#N/A"}},null,{"$f":"M41/M47","v":{"$error":"#N/A"}},null,{"$f":"O41/O47","v":{"$error":"#N/A"}}]
[null,"Autonomie",null,null,{"$f":"IF(F42>E41+1,\"dépasse\",E49)","v":{"$error":"#N/A"}},null,{"$f":"IF(H42>G41+1,\"dépasse\",G49)","v":{"$error":"#N/A"}},null,{"$f":"IF(J42>I41+1,\"dépasse\",I49)","v":{"$error":"#N/A"}},null,{"$f":"IF(L42>K41+1,\"dépasse\",K49)","v":{"$error":"#N/A"}},null,{"$f":"IF(N42>M41+1,\"dépasse\",M49)","v":{"$error":"#N/A"}},null,{"$f":"IF(P42>O41+1,\"dépasse\",O49)","v":{"$error":"#N/A"}},null,null,null,null,null,"somme perte de tps utilisation éco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hr/mn/sec","1/100 hr"]
[null,null,"Calcul augmentation tps/tour en fonction de la conduite",null,{"$f":"E48*F31","v":0},null,{"$f":"G48*H31","v":0},null,{"$f":"I48*J31","v":0},null,{"$f":"K48*L31","v":0},null,{"$f":"M48*N31","v":0},null,{"$f":"O48*P31","v":0},null,"nbr tours /type pneus","chronos",null,"tps total / type pneu",{"$f":"V52/86400","v":"00:00:00"},{"$f":"E52+G52+I52+K52+M52+O52","v":0}]
[null,null,"S soft",null,{"$f":"SUMIF(E39,\"S soft\",F31)","v":0},null,{"$f":"SUMIF(G39,\"S soft\",H31)","v":0},{"$f":"IF(G53>0,1,0)","v":0},{"$f":"SUMIF(I39,\"S soft\",J31)","v":0},{"$f":"IF(I53>0,1,0)","v":0},{"$f":"SUMIF(K39,\"S soft\",L31)","v":0},{"$f":"IF(K53>0,1,0)","v":0},{"$f":"SUMIF(M39,\"S soft\",N31)","v":0},{"$f":"IF(M53>0,1,0)","v":0},{"$f":"SUMIF(O39,\"S soft\",P31)","v":0},{"$f":"IF(O53>0,1,0)","v":0},{"$f":"E53+G53+I53+K53+M53+O53","v":0},{"$f":"VLOOKUP(C53,'nbr tours'!$D$106:$H$108,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q53)*R53,0)","v":0}]
[null,null,"soft",null,{"$f":"SUMIF(E39,\"soft\",F31)","v":0},null,{"$f":"SUMIF(G39,\"soft\",H31)","v":0},{"$f":"IF(G54>0,1,0)","v":0},{"$f":"SUMIF(I39,\"soft\",J31)","v":0},{"$f":"IF(I54>0,1,0)","v":0},{"$f":"SUMIF(K39,\"soft\",L31)","v":0},{"$f":"IF(K54>0,1,0)","v":0},{"$f":"SUMIF(M39,\"soft\",N31)","v":0},{"$f":"IF(M54>0,1,0)","v":0},{"$f":"SUMIF(O39,\"soft\",P31)","v":0},{"$f":"IF(O54>0,1,0)","v":0},0,{"$f":"VLOOKUP(C54,'nbr tours'!$D$106:$H$108,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q54)*R54,0)","v":0}]
[null,null,"médium",null,{"$f":"SUMIF(E39,\"médium\",F31)","v":0},null,{"$f":"SUMIF(G39,\"médium\",H31)","v":0},{"$f":"IF(G55>0,1,0)","v":0},{"$f":"SUMIF(I39,\"médium\",J31)","v":0},{"$f":"IF(I55>0,1,0)","v":0},{"$f":"SUMIF(K39,\"médium\",L31)","v":0},{"$f":"IF(K55>0,1,0)","v":0},{"$f":"SUMIF(M39,\"médium\",N31)","v":0},{"$f":"IF(M55>0,1,0)","v":0},{"$f":"SUMIF(O39,\"médium\",P31)","v":0},{"$f":"IF(O55>0,1,0)","v":0},0,{"$f":"VLOOKUP(C55,'nbr tours'!$D$106:$H$108,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q55)*R55,0)","v":0}]
[null,null,"hard",null,{"$f":"SUMIF(E39,\"hard\",F31)","v":0},null,{"$f":"SUMIF(G39,\"hard\",H31)","v":0},{"$f":"IF(G56>0,1,0)","v":0},{"$f":"SUMIF(I39,\"hard\",J31)","v":0},{"$f":"IF(I56>0,1,0)","v":0},{"$f":"SUMIF(K39,\"hard\",L31)","v":0},{"$f":"IF(K56>0,1,0)","v":0},{"$f":"SUMIF(M39,\"hard\",N31)","v":0},{"$f":"IF(M56>0,1,0)","v":0},{"$f":"SUMIF(O39,\"hard\",P31)","v":0},{"$f":"IF(O56>0,1,0)","v":0},0,{"$f":"VLOOKUP(C56,'nbr tours'!$D$106:$H$108,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q56*R56,0)","v":0}]
[null,null,"(sans) changement de pneus",null,{"$f":"SUMIF(E39,\"sans\",F31)","v":0},null,{"$f":"SUMIF(G39,\"sans\",H31)","v":0},null,{"$f":"SUMIF(I39,\"sans\",J31)","v":0},null,{"$f":"SUMIF(K39,\"sans\",L31)","v":0},null,{"$f":"SUMIF(M39,\"sans\",N31)","v":0},null,{"$f":"SUMIF(O39,\"sans\",P31)","v":0},null,0,{"$f":"chronos!N18","v":{"$error":"#DIV/0!"}},null,{"$f":"IFERROR(Q57*R57,0)","v":0},"cumul pertes de temps"]
[null,null,"inter",null,{"$f":"SUMIF(E39,\"inter\",F31)","v":0},null,{"$f":"SUMIF(G39,\"inter\",H31)","v":0},{"$f":"IF(G58>0,1,0)","v":0},{"$f":"SUMIF(I39,\"inter\",J31)","v":0},{"$f":"IF(I58>0,1,0)","v":0},{"$f":"SUMIF(K39,\"inter\",L31)","v":0},{"$f":"IF(K58>0,1,0)","v":0},{"$f":"SUMIF(M39,\"inter\",N31)","v":0},{"$f":"IF(M58>0,1,0)","v":0},{"$f":"SUMIF(O39,\"inter\",P31)","v":0},{"$f":"IF(O58>0,1,0)","v":0},0,{"$f":"VLOOKUP(C58,'nbr tours'!$D$106:$H$108,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q58*R58,0)","v":0}]
[null,null,"pluie",null,{"$f":"SUMIF(E39,\"pluie\",F31)","v":0},null,{"$f":"SUMIF(G39,\"pluie\",H31)","v":0},{"$f":"IF(G59>0,1,0)","v":0},{"$f":"SUMIF(I39,\"pluie\",J31)","v":0},{"$f":"IF(I59>0,1,0)","v":0},{"$f":"SUMIF(K39,\"pluie\",L31)","v":0},{"$f":"IF(K59>0,1,0)","v":0},{"$f":"SUMIF(M39,\"pluie\",N31)","v":0},{"$f":"IF(M59>0,1,0)","v":0},{"$f":"SUMIF(O39,\"pluie\",P31)","v":0},{"$f":"IF(O59>0,1,0)","v":0},0,{"$f":"VLOOKUP(C59,'nbr tours'!$D$106:$H$108,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q59*R59,0)","v":0},{"$f":"U65+V52+C33","v":{"$error":"#N/A"}},{"$f":"U59/86400","v":{"$error":"#N/A"}}]
[null,null,"Nbr de changements de pneu",null,null,null,null,{"$f":"SUM(H53:H59)","v":0},null,{"$f":"SUM(J53:J59)","v":0},null,{"$f":"SUM(L53:L59)","v":0},null,{"$f":"SUM(N53:N59)","v":0},null,{"$f":"SUM(P53:P59)","v":0},{"$f":"P60+N60+L60+J60+H60+F60","v":0},null,null,{"$f":"SUM(T53:T59)","v":0},{"$f":"U59/N68","v":{"$error":"#N/A"}},{"$f":"U60/86400","v":{"$error":"#N/A"}}]
[null,null,"Nbr de refuels",null,null,{"$f":"IF(H42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(J42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(L42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(N42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(P42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(Q42>0,1,0)","v":0},{"$f":"P61+N61+L61+J61+H61+F61","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tps échange pneu :",{"$f":"Q60*K22","v":0},{"$f":"U62/86400","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tps refuel :",{"$f":"$U$42*$R$22","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"somme max refuel ou échange pneus :",null,null,null,{"$f":"MAX(Q60:Q61)","v":{"$error":"#N/A"}},{"$f":"H22/86400","v":"00:00:01.100"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps total arrêt au stand : ",null,null,null,{"$f":"(U64*H22)+U62+U63","v":{"$error":"#N/A"}},{"$f":"U65/86400","v":{"$error":"#N/A"}}]
[]
[]
[null,"Nombre de pits",null,null,{"$f":"U64","v":{"$error":"#N/A"}},null,"Temps\nmoyen\n au tour",null,{"$f":"G11","v":0},null,{"$f":"VLOOKUP(I68,'nbr tours'!$D$106:$H$111,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"T31","v":0},null,"en",{"$f":"T60+V59","v":{"$error":"#N/A"}}]
[]
[null,"Cumul tps pit(s)",null,null,{"$f":"V65","v":{"$error":"#N/A"}},null,null,null,{"$f":"K11","v":0},null,{"$f":"VLOOKUP(I70,'nbr tours'!$D$106:$H$111,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,"Distance totale : ",null,null,{"$f":"N68*K3","v":{"$error":"#N/A"}}]
[]
[null,"Tps moyen avec pit",null,null,{"$f":"(T60+V59)/T31","v":{"$error":"#N/A"}},null,null,null,{"$f":"O11","v":0},null,{"$f":"VLOOKUP(I72,'nbr tours'!$D$106:$H$111,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,"Info consommation : ",null,null,1,{"$f":"'Strat 1'!R72","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Utilisation",null,{"$f":"G11","v":0},{"$f":"K11","v":0},{"$f":"O11","v":0}]
[null,null,null,null,{"$f":"I11","v":0},{"$f":"M11","v":0},{"$f":"Q11","v":0}]
[null,null,"Obligatoire(s)",null,{"$f":"IF(E84=\"obligatoire\",E83,\"libre\")","v":"libre"},{"$f":"IF(F84=\"obligatoire\",F83,\"libre\")","v":"libre"},{"$f":"IF(G84=\"obligatoire\",G83,\"libre\")","v":"libre"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Utilisés",null,{"$f":"E39","v":0},{"$f":"G39","v":0},{"$f":"I39","v":0},{"$f":"K39","v":0},{"$f":"M39","v":0},{"$f":"O39","v":0},"libre",{"$f":"ISNUMBER(MATCH(E85,$E$87:$K$87,0))","v":true},{"$f":"ISNUMBER(MATCH(F85,$E$87:$K$87,0))","v":true},true,null,{"$f":"COUNTIF(L87:N87,\"FAUX\")","v":0}]

{"sheet":"strat 3","index":3,"n_rows":87,"n_cols":24,"rows_kept":87,"cut":false,"hidden":false,"merged":[[25,2,25,18],[27,8,28,10],[13,4,13,5],[69,1,69,2],[69,8,69,9],[69,10,69,11],[69,13,69,15],[67,1,67,2],[67,6,71,7],[67,8,67,9],[67,10,67,11],[71,1,71,2],[71,4,71,5],[71,8,71,9],[71,10,71,11],[69,4,69,5],[71,13,71,15],[67,13,67,14],[44,1,44,2],[49,1,49,2],[42,1,42,2],[40,1,40,2],[41,1,41,2],[44,23,44,24],[42,16,43,16],[49,20,49,21],[45,23,45,24],[46,23,46,24],[47,23,47,24],[48,23,48,24],[42,23,43,24],[56,20,57,20],[64,16,64,19],[67,16,67,17],[69,16,69,17],[63,16,63,19],[36,26,36,27],[36,29,36,30],[38,1,38,2],[38,23,38,24],[38,26,38,27],[38,29,38,30],[36,16,36,17],[4,26,4,28],[4,29,4,31],[6,4,6,7],[6,8,6,9],[6,13,6,14],[6,16,6,17],[4,2,4,4],[0,0,1,1],[2,0,24,1],[2,4,2,7],[2,8,2,9],[2,13,2,15],[17,5,17,7],[9,11,9,12],[9,15,9,16],[23,5,23,6],[19,14,20,14],[20,2,21,4],[21,5,21,6],[21,8,21,9],[11,6,12,6],[11,10,12,10],[11,14,12,14],[16,23,24,25],[17,14,17,15],[2,23,2,24],[4,8,4,9],[4,14,4,15],[4,16,4,17],[4,23,4,25],[21,11,21,13],[19,17,20,17],[23,8,23,9],[23,11,23,13],[29,23,30,24],[30,1,30,2],[34,1,34,2],[36,1,36,2],[36,23,36,24],[28,19,29,19],[27,1,28,6],[27,7,28,7],[27,15,28,17],[27,12,28,14],[31,1,31,2]]}
[]
[]
["DONNEES COURSE",null,"Circuit / Piste :",null,{"$f":"'Strat 1'!E3:H3","v":0},null,null,null,"Longueur circuit :",null,{"$f":"'Strat 1'!K3","v":{"$error":"#N/A"}},"corners :",{"$f":"'Strat 1'!M3","v":{"$error":"#N/A"}},"Condition météo, horaire : ",null,null,{"$f":"'Strat 1'!Q3","v":0},{"$f":"'Strat 1'!R3","v":"0h0"},"hr",null,null,null,null,"Menus"]
[]
[null,null,"Catégorie du  véhicule : ",null,null,{"$f":"'Strat 1'!F5","v":0},null,null,"Durée de la course :",null,{"$f":"'Strat 1'!K5","v":"00:00:00"},"hr     où",{"$f":"'Strat 1'!M5","v":0},{"$f":"'Strat 1'!N5","v":{"$error":"#DIV/0!"}},"Host salon : ",null,{"$f":"'Strat 1'!Q5:R5","v":0}]
[]
[null,null,"Modèle :",null,{"$f":"'Strat 1'!E7:H7","v":0},null,null,null,null,null,null,null,null,null,null,"Cast : ",{"$f":"'Strat 1'!Q7:R7","v":0}]
[]
[]
[null,null,null,null,"condition usure",null,"pneus 1",null,null,null,"pneus 2",null,null,null,"pneus 3"]
[null,null,"Pneumatique :",null,{"$f":"chronos!G7","v":"X1"},null,{"$f":"'Strat 1'!G11","v":0},"Monte : ",{"$f":"'Strat 1'!I11","v":0},null,{"$f":"'Strat 1'!K11","v":0},"Monte : ",{"$f":"'Strat 1'!M11","v":0},null,{"$f":"'Strat 1'!O11","v":0},"Monte : ",{"$f":"'Strat 1'!Q11","v":0}]
[null,null,null,null,null,null,"durée de vie","nbr tours",{"$f":"'Strat 1'!I12","v":1},null,"durée de vie","nbr tours",{"$f":"'Strat 1'!M12","v":1},null,"durée de vie","nbr tours",{"$f":"'Strat 1'!Q12","v":1}]
[]
[null,null,null,null,"Trains de pneus : ",null,null,"temps : ",{"$f":"'nbr tours'!H206","v":{"$error":"#DIV/0!"}},null,null,"temps : ",{"$f":"'nbr tours'!H207","v":{"$error":"#DIV/0!"}},null,null,"temps : ",{"$f":"'nbr tours'!H208","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,"condition fuel",null,null,null,"réservoir",null,"volume",null,"consommation","taux/vol",null,null,"volume",null,null,null,null,null,null,"S3"]
[null,null,"Carburant :",null,{"$f":"'Strat 1'!E18","v":"X1"},"Fourchette autonomie max :",null,null,{"$f":"'Strat 1'!I18","v":0},"pour",{"$f":"'Strat 1'!K18","v":100},"soit",{"$f":"'Strat 1'!M18","v":{"$error":"#N/A"}},{"$f":"'Strat 1'!N18","v":{"$error":"#N/A"}},"Jauge initiale : ",null,{"$f":"'Strat 1'!Q18","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Litre/Sec",null,null,"1 tour"]
[null,null,"Temps d'arrêt au stand :"]
[null,null,null,null,null,"ENTREE / SORTIE : ",null,{"$f":"'Strat 1'!H22","v":1.0999999999999996},"ECHANGE PNEUS :  ",null,{"$f":"'Strat 1'!K22","v":4.5},"REFUEL vitesse de ravitaillement : ",null,null,{"$f":"'Strat 1'!O22","v":5.7471264367816097},null,1,{"$f":"'Strat 1'!R22","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Echange pneumatiques : ",null,{"$f":"'Strat 1'!H24","v":5.6},"Temps pneus + fuel : ",null,{"$f":"H24+(I18*R22)","v":{"$error":"#DIV/0!"}},"Nbr de tours total de refuel : ",null,null,{"$f":"U42","v":{"$error":"#N/A"}},{"$f":"O24*R22","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Tableau de bord stratégie de course ",null,null,null,null,null,3,"Indiquez la durée de vie des trains de pneus dans les données course",null,null,null,"Au moins un type de gomme obligatoire n'est pas utilisé",null,null,"Vous dépassez la durée de\ncourse de plus d'un tour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total nbr de tours"]
[]
[null,"Nbr de tours / pit",null,null,"Départ",null,"Pit 1",null,"Pit 2",null,"Pit 3",null,"Pit 4",null,"Pit 5",null,null,null,null,{"$f":"R31+P31+N31+L31+J31+H31+F31","v":0}]
[null,"Pertes de temps total : purge pénalité...",null,null,null,{"$f":"VLOOKUP(E39,'nbr tours'!$D$206:'nbr tours'!$E$211,2,FALSE)","v":0},null,{"$f":"VLOOKUP(G39,'nbr tours'!$D$206:'nbr tours'!$E$211,2,FALSE)","v":0},null,{"$f":"VLOOKUP(I39,'nbr tours'!$D$206:'nbr tours'!$E$211,2,FALSE)","v":0},null,{"$f":"VLOOKUP(K39,'nbr tours'!$D$206:'nbr tours'!$E$211,2,FALSE)","v":0},null,{"$f":"VLOOKUP(M39,'nbr tours'!$D$206:'nbr tours'!$E$211,2,FALSE)","v":0},null,{"$f":"VLOOKUP(O39,'nbr tours'!$D$206:'nbr tours'!$E$211,2,FALSE)","v":0},{"$f":"'Strat 1'!Q32","v":7},{"$f":"Q32*R33","v":0}]
[null,null,"00:00:00",null,null,{"$f":"F31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F32<F31)=\"VRAI\",\"\",F32<F31)","v":false},{"$f":"H31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(H32<H31)=\"VRAI\",\"\",H32<H31)","v":false},{"$f":"J31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(J32<J31)=\"VRAI\",\"\",J32<J31)","v":false},{"$f":"L31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(L32<L31)=\"VRAI\",\"\",L32<L31)","v":false},{"$f":"N31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(N32<N31)=\"VRAI\",\"\",N32<N31)","v":false},{"$f":"P31*$K$3","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(P32<P31)=\"VRAI\",\"\",P32<P31)","v":false},{"$f":"COUNTIF(G33:Q33,\"VRAI\")","v":0}]
[]
[null,"Tours & Temps",null,null,null,{"$f":"F31","v":0},{"$f":"F31*E72","v":{"$error":"#N/A"}},{"$f":"F35+H31","v":0},{"$f":"(E72*H31)+G35","v":{"$error":"#N/A"}},{"$f":"H35+J31","v":0},{"$f":"(J31*E72)+I35","v":{"$error":"#N/A"}},{"$f":"J35+L31","v":0},{"$f":"L31*E72+K35","v":{"$error":"#N/A"}},{"$f":"L35+N31","v":0},{"$f":"(N31*E72)+M35","v":{"$error":"#N/A"}},{"$f":"N35+P31","v":0},{"$f":"(P31*E72)+O35","v":{"$error":"#N/A"}},{"$f":"P35+R31","v":0}]
[]
[null,null,null,null,null,null,{"$f":"F31","v":0},null,{"$f":"H31+F31","v":0},null,{"$f":"J31+H31+F31","v":0},null,{"$f":"L31+J31+H31+F31","v":0},null,{"$f":"N31+L31+J31+H31+F31","v":0},null,"Dépassement nbr de tours"]
[]
[null,"Type pneus"]
[]
[null,"litres restant E40 / besoin hors éco F40",null,null,{"$f":"Q18","v":100},null,{"$f":"G43*100","v":{"$error":"#N/A"}},null,{"$f":"I43*100","v":{"$error":"#N/A"}},null,{"$f":"K43*100","v":{"$error":"#N/A"}},null,{"$f":"M43*100","v":{"$error":"#N/A"}},null,{"$f":"O43*100","v":{"$error":"#N/A"}},null,null,null,null,"refuel en litres","refuel en tours"]
[null,"ajust conso E41 / conso réelle F41",null,null,{"$f":"VLOOKUP(E45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(F33*E42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(H33*G42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(I45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(J33*I42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(L33*K42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(M45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(N33*M42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(O45,'ajust éco'!$B$9:$G$17,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"(P33*O42)","v":{"$error":"#N/A"}},null,null,null,{"$f":"G41+I41+K41+M41+O41","v":{"$error":"#N/A"}},{"$f":"T42/$M$18","v":{"$error":"#N/A"}}]
[null,"Jauge fuel",null,null,{"$f":"Q18/100","v":1},{"$f":"(E43*$I$18)/1","v":0},{"$f":"MIN(100%,(SUM(H31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(G43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(J31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(I43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(L31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(K43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(N31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(M43*$I$18)/1","v":{"$error":"#N/A"}},{"$f":"MIN(100%,(SUM(P31*$N$18)))","v":{"$error":"#N/A"}},{"$f":"(O43*$I$18)/1","v":{"$error":"#N/A"}},"cumul perte de temps conduite éco"]
[]
[null,"Eco fuel ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U52","v":"00:00:00"},null,null,null,null,null,""]
[]
[null,null,null,null,{"$f":"E42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"G42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"I42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"K42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"M42*$K$3","v":{"$error":"#N/A"}},null,{"$f":"O42*$K$3","v":{"$error":"#N/A"}}]
[null,null,"calcul perte temps",null,{"$f":"VLOOKUP(E45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(G45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(I45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(K45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(M45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0},null,{"$f":"VLOOKUP(O45,'ajust éco'!$B$9:$L$17,11,\"faux\")","v":0}]
[null,null,null,null,{"$f":"E41/E47","v":{"$error":"#N/A"}},null,{"$f":"G41/G47","v":{"$error":"#N/A"}},null,{"$f":"I41/I47","v":{"$error":"#N/A"}},null,{"$f":"K41/K47","v":{"$error":"#N/A"}},null,{"$f":"M41/M47","v":{"$error":"#N/A"}},null,{"$f":"O41/O47","v":{"$error":"#N/A"}}]
[null,"Autonomie",null,null,{"$f":"IF(F42>E41+1,\"dépasse\",E49)","v":{"$error":"#N/A"}},null,{"$f":"IF(H42>G41+1,\"dépasse\",G49)","v":{"$error":"#N/A"}},null,{"$f":"IF(J42>I41+1,\"dépasse\",I49)","v":{"$error":"#N/A"}},null,{"$f":"IF(L42>K41+1,\"dépasse\",K49)","v":{"$error":"#N/A"}},null,{"$f":"IF(N42>M41+1,\"dépasse\",M49)","v":{"$error":"#N/A"}},null,{"$f":"IF(P42>O41+1,\"dépasse\",O49)","v":{"$error":"#N/A"}},null,null,null,null,null,"somme perte de tps utilisation éco"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hr/mn/sec","1/100 hr"]
[null,null,"Calcul augmentation tps/tour en fonction de la conduite",null,{"$f":"E48*F31","v":0},null,{"$f":"G48*H31","v":0},null,{"$f":"I48*J31","v":0},null,{"$f":"K48*L31","v":0},null,{"$f":"M48*N31","v":0},null,{"$f":"O48*P31","v":0},null,"nbr tours /type pneus","chronos",null,"tps total / type pneu",{"$f":"V52/86400","v":"00:00:00"},{"$f":"E52+G52+I52+K52+M52+O52","v":0}]
[null,null,"S soft",null,{"$f":"SUMIF(E39,\"S soft\",F31)","v":0},null,{"$f":"SUMIF(G39,\"S soft\",H31)","v":0},{"$f":"IF(G53>0,1,0)","v":0},{"$f":"SUMIF(I39,\"S soft\",J31)","v":0},{"$f":"IF(I53>0,1,0)","v":0},{"$f":"SUMIF(K39,\"S soft\",L31)","v":0},{"$f":"IF(K53>0,1,0)","v":0},{"$f":"SUMIF(M39,\"S soft\",N31)","v":0},{"$f":"IF(M53>0,1,0)","v":0},{"$f":"SUMIF(O39,\"S soft\",P31)","v":0},{"$f":"IF(O53>0,1,0)","v":0},{"$f":"E53+G53+I53+K53+M53+O53","v":0},{"$f":"VLOOKUP(C53,'nbr tours'!$D$206:$H$208,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q53)*R53,0)","v":0}]
[null,null,"soft",null,{"$f":"SUMIF(E39,\"soft\",F31)","v":0},null,{"$f":"SUMIF(G39,\"soft\",H31)","v":0},{"$f":"IF(G54>0,1,0)","v":0},{"$f":"SUMIF(I39,\"soft\",J31)","v":0},{"$f":"IF(I54>0,1,0)","v":0},{"$f":"SUMIF(K39,\"soft\",L31)","v":0},{"$f":"IF(K54>0,1,0)","v":0},{"$f":"SUMIF(M39,\"soft\",N31)","v":0},{"$f":"IF(M54>0,1,0)","v":0},{"$f":"SUMIF(O39,\"soft\",P31)","v":0},{"$f":"IF(O54>0,1,0)","v":0},0,{"$f":"VLOOKUP(C54,'nbr tours'!$D$206:$H$208,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q54)*R54,0)","v":0}]
[null,null,"médium",null,{"$f":"SUMIF(E39,\"médium\",F31)","v":0},null,{"$f":"SUMIF(G39,\"médium\",H31)","v":0},{"$f":"IF(G55>0,1,0)","v":0},{"$f":"SUMIF(I39,\"médium\",J31)","v":0},{"$f":"IF(I55>0,1,0)","v":0},{"$f":"SUMIF(K39,\"médium\",L31)","v":0},{"$f":"IF(K55>0,1,0)","v":0},{"$f":"SUMIF(M39,\"médium\",N31)","v":0},{"$f":"IF(M55>0,1,0)","v":0},{"$f":"SUMIF(O39,\"médium\",P31)","v":0},{"$f":"IF(O55>0,1,0)","v":0},0,{"$f":"VLOOKUP(C55,'nbr tours'!$D$206:$H$208,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR((Q55)*R55,0)","v":0}]
[null,null,"hard",null,{"$f":"SUMIF(E39,\"hard\",F31)","v":0},null,{"$f":"SUMIF(G39,\"hard\",H31)","v":0},{"$f":"IF(G56>0,1,0)","v":0},{"$f":"SUMIF(I39,\"hard\",J31)","v":0},{"$f":"IF(I56>0,1,0)","v":0},{"$f":"SUMIF(K39,\"hard\",L31)","v":0},{"$f":"IF(K56>0,1,0)","v":0},{"$f":"SUMIF(M39,\"hard\",N31)","v":0},{"$f":"IF(M56>0,1,0)","v":0},{"$f":"SUMIF(O39,\"hard\",P31)","v":0},{"$f":"IF(O56>0,1,0)","v":0},0,{"$f":"VLOOKUP(C56,'nbr tours'!$D$206:$H$208,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q56*R56,0)","v":0}]
[null,null,"(sans) changement de pneus",null,{"$f":"SUMIF(E39,\"sans\",F31)","v":0},null,{"$f":"SUMIF(G39,\"sans\",H31)","v":0},null,{"$f":"SUMIF(I39,\"sans\",J31)","v":0},null,{"$f":"SUMIF(K39,\"sans\",L31)","v":0},null,{"$f":"SUMIF(M39,\"sans\",N31)","v":0},null,{"$f":"SUMIF(O39,\"sans\",P31)","v":0},null,0,{"$f":"chronos!N18","v":{"$error":"#DIV/0!"}},null,{"$f":"IFERROR(Q57*R57,0)","v":0},"cumul pertes de temps"]
[null,null,"inter",null,{"$f":"SUMIF(E39,\"inter\",F31)","v":0},null,{"$f":"SUMIF(G39,\"inter\",H31)","v":0},{"$f":"IF(G58>0,1,0)","v":0},{"$f":"SUMIF(I39,\"inter\",J31)","v":0},{"$f":"IF(I58>0,1,0)","v":0},{"$f":"SUMIF(K39,\"inter\",L31)","v":0},{"$f":"IF(K58>0,1,0)","v":0},{"$f":"SUMIF(M39,\"inter\",N31)","v":0},{"$f":"IF(M58>0,1,0)","v":0},{"$f":"SUMIF(O39,\"inter\",P31)","v":0},{"$f":"IF(O58>0,1,0)","v":0},0,{"$f":"VLOOKUP(C58,'nbr tours'!$D$206:$H$208,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q58*R58,0)","v":0}]
[null,null,"pluie",null,{"$f":"SUMIF(E39,\"pluie\",F31)","v":0},null,{"$f":"SUMIF(G39,\"pluie\",H31)","v":0},{"$f":"IF(G59>0,1,0)","v":0},{"$f":"SUMIF(I39,\"pluie\",J31)","v":0},{"$f":"IF(I59>0,1,0)","v":0},{"$f":"SUMIF(K39,\"pluie\",L31)","v":0},{"$f":"IF(K59>0,1,0)","v":0},{"$f":"SUMIF(M39,\"pluie\",N31)","v":0},{"$f":"IF(M59>0,1,0)","v":0},{"$f":"SUMIF(O39,\"pluie\",P31)","v":0},{"$f":"IF(O59>0,1,0)","v":0},0,{"$f":"VLOOKUP(C59,'nbr tours'!$D$206:$H$208,5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(Q59*R59,0)","v":0},{"$f":"U65+V52+C33","v":{"$error":"#N/A"}},{"$f":"U59/86400","v":{"$error":"#N/A"}}]
[null,null,"Nbr de changements de pneu",null,null,null,null,{"$f":"SUM(H53:H59)","v":0},null,{"$f":"SUM(J53:J59)","v":0},null,{"$f":"SUM(L53:L59)","v":0},null,{"$f":"SUM(N53:N59)","v":0},null,{"$f":"SUM(P53:P59)","v":0},{"$f":"P60+N60+L60+J60+H60+F60","v":0},null,null,{"$f":"SUM(T53:T59)","v":0},{"$f":"U59/N68","v":{"$error":"#N/A"}},{"$f":"U60/86400","v":{"$error":"#N/A"}}]
[null,null,"Nbr de refuels",null,null,{"$f":"IF(H42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(J42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(L42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(N42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(P42>0,1,0)","v":{"$error":"#N/A"}},null,{"$f":"IF(Q42>0,1,0)","v":0},{"$f":"P61+N61+L61+J61+H61+F61","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tps échange pneu :",{"$f":"Q60*K22","v":0},{"$f":"U62/86400","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tps refuel :",{"$f":"$U$42*$R$22","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"somme max refuel ou échange pneus :",null,null,null,{"$f":"MAX(Q60:Q61)","v":{"$error":"#N/A"}},{"$f":"H22/86400","v":"00:00:01.100"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps total arrêt au stand : ",null,null,null,{"$f":"(U64*H22)+U62+U63","v":{"$error":"#N/A"}},{"$f":"U65/86400","v":{"$error":"#N/A"}}]
[]
[]
[null,"Nombre de pits",null,null,{"$f":"U64","v":{"$error":"#N/A"}},null,"Temps\nmoyen\n au tour",null,{"$f":"G11","v":0},null,{"$f":"VLOOKUP(I68,'nbr tours'!$D$206:$H$211,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"T31","v":0},null,"en",{"$f":"T60+V59","v":{"$error":"#N/A"}}]
[]
[null,"Cumul tps pit(s)",null,null,{"$f":"V65","v":{"$error":"#N/A"}},null,null,null,{"$f":"K11","v":0},null,{"$f":"VLOOKUP(I70,'nbr tours'!$D$206:$H$211,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,"Distance totale : ",null,null,{"$f":"N68*K3","v":{"$error":"#N/A"}}]
[]
[null,"Tps moyen avec pit",null,null,{"$f":"(T60+V59)/T31","v":{"$error":"#N/A"}},null,null,null,{"$f":"O11","v":0},null,{"$f":"VLOOKUP(I72,'nbr tours'!$D$206:$H$211,5,FALSE)","v":{"$error":"#DIV/0!"}},null,null,"Info consommation : ",null,null,1,{"$f":"'Strat 1'!R72","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Utilisation",null,{"$f":"G11","v":0},{"$f":"K11","v":0},{"$f":"O11","v":0}]
[null,null,null,null,{"$f":"I11","v":0},{"$f":"M11","v":0},{"$f":"Q11","v":0}]
[null,null,"Obligatoire(s)",null,{"$f":"IF(E84=\"obligatoire\",E83,\"libre\")","v":"libre"},{"$f":"IF(F84=\"obligatoire\",F83,\"libre\")","v":"libre"},{"$f":"IF(G84=\"obligatoire\",G83,\"libre\")","v":"libre"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Utilisés",null,{"$f":"E39","v":0},{"$f":"G39","v":0},{"$f":"I39","v":0},{"$f":"K39","v":0},{"$f":"M39","v":0},{"$f":"O39","v":0},"libre",{"$f":"ISNUMBER(MATCH(E85,$E$87:$K$87,0))","v":true},{"$f":"ISNUMBER(MATCH(F85,$E$87:$K$87,0))","v":true},true,null,{"$f":"COUNTIF(L87:N87,\"FAUX\")","v":0}]

{"sheet":"comparateur","index":4,"n_rows":87,"n_cols":37,"rows_kept":87,"cut":false,"hidden":false,"merged":[[7,2,46,2],[31,20,31,22],[3,2,3,3],[3,4,3,8],[3,16,3,22],[35,14,35,16],[21,14,21,16],[7,14,7,16],[11,4,12,4],[11,6,12,6],[11,8,12,8],[14,4,15,4],[14,6,15,6],[14,8,15,8],[28,11,29,12],[28,13,29,13],[28,14,29,16],[28,17,29,17],[37,14,37,16],[3,36,3,38],[7,11,7,12],[17,29,17,31],[17,20,17,22],[3,27,3,29],[3,31,3,32],[17,23,17,25],[11,13,12,13],[14,17,15,17],[14,13,15,13],[14,11,15,12],[11,27,12,27],[11,29,12,29],[49,23,49,29],[36,36,47,38],[27,36,28,37],[7,4,7,8],[45,14,45,16],[17,26,17,28],[23,14,23,16],[31,14,31,16],[35,11,35,12],[45,29,45,31],[31,29,31,31],[31,26,31,28],[45,26,45,28],[31,23,31,25],[45,20,45,22],[45,23,45,25],[11,31,12,31],[17,14,17,16],[11,14,12,16],[11,17,12,17],[14,14,15,16],[11,20,12,20],[11,21,12,21],[11,23,12,23],[11,25,12,25],[9,14,9,16],[11,11,12,12],[25,20,26,20],[25,21,26,21],[25,23,26,23],[21,11,21,12],[25,27,26,27],[25,29,26,29],[25,31,26,31],[25,11,26,12],[25,13,26,13],[25,14,26,16],[25,17,26,17],[25,25,26,25],[25,4,26,4],[25,6,26,6],[25,8,26,8],[28,4,29,4],[28,6,29,6],[28,8,29,8],[39,17,40,17],[39,14,40,16],[39,13,40,13],[39,11,40,12],[42,17,43,17],[42,14,43,16],[42,13,43,13],[42,11,43,12],[39,4,40,4],[39,6,40,6],[39,8,40,8],[42,4,43,4],[42,6,43,6],[42,8,43,8],[39,31,40,31],[39,20,40,20],[39,21,40,21],[39,23,40,23],[39,25,40,25],[39,27,40,27],[39,29,40,29]]}
[]
[]
[]
[null,null,"Circuit :",null,{"$f":"'Strat 1'!E3","v":0},null,null,null,null,null,null,{"$f":"'Strat 1'!N68","v":0},null,"Catégorie :",{"$f":"'Strat 1'!F5","v":0},"Voiture :",{"$f":"'Strat 1'!E7","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"'Strat 1'!Q3","v":0},null,null,null,{"$f":"'Strat 1'!R3","v":"0h0"},null,null,null,null,"Accès menus"]
[]
[]
[]
[null,null,"COMPARATEUR  STRAT",null,null,null,null,null,null,null,null,"Stratégie 1",null,null,"Indice de risque :",null,null,{"$f":"T69","v":0},null,null,"Type pneus :",{"$f":"'Strat 1'!E39","v":0},null,{"$f":"'Strat 1'!G39","v":0},null,{"$f":"'Strat 1'!I39","v":0},null,{"$f":"'Strat 1'!K39","v":0},null,{"$f":"'Strat 1'!M39","v":0},null,{"$f":"'Strat 1'!O39","v":0}]
[null,null,null,null,"type",null,"tps moyen",null,"durée",null,null,null,null,null,null,null,null,null,null,null,"Pit","Dép.",null,"P1",null,"P2",null,"P3",null,"P3",null,"P3"]
[null,null,null,null,{"$f":"'Strat 1'!I68","v":0},null,{"$f":"'Strat 1'!K68","v":{"$error":"#DIV/0!"}},null,{"$f":"'Strat 1'!G14","v":0},null,null,null,null,"STOP PIT","Durée : ",null,null,{"$f":"'Strat 1'!Q68","v":{"$error":"#N/A"}},{"$f":"R10*24","v":{"$error":"#N/A"}},null,"Nbr de tours :",{"$f":"'Strat 1'!F31","v":0},null,{"$f":"'Strat 1'!H31","v":0},null,{"$f":"'Strat 1'!J31","v":0},null,{"$f":"'Strat 1'!L31","v":0},null,{"$f":"'Strat 1'!N31","v":0},null,{"$f":"'Strat 1'!P31","v":0}]
[]
[null,null,null,null,{"$f":"'Strat 1'!I70","v":0},null,{"$f":"'Strat 1'!K70","v":{"$error":"#DIV/0!"}},null,{"$f":"'Strat 1'!K14","v":0},null,null,"Nombre : ",null,{"$f":"'Strat 1'!E68","v":{"$error":"#N/A"}},"Distance : ",null,null,{"$f":"IF('Strat 1'!Q70=0,\"\",'Strat 1'!Q70)","v":{"$error":"#N/A"}},null,null,"Conduite éco :",{"$f":"'Strat 1'!E45","v":0},null,{"$f":"'Strat 1'!G45","v":0},null,{"$f":"'Strat 1'!I45","v":0},null,{"$f":"'Strat 1'!K45","v":0},null,{"$f":"'Strat 1'!M45","v":0},null,{"$f":"'Strat 1'!O45","v":0}]
[]
[]
[null,null,null,null,{"$f":"'Strat 1'!I72","v":0},null,{"$f":"'Strat 1'!K72","v":{"$error":"#DIV/0!"}},null,{"$f":"'Strat 1'!O14","v":0},null,null,"Cumul temps : ",null,{"$f":"'Strat 1'!E70","v":{"$error":"#N/A"}},"Vitesse moyenne : ",null,null,{"$f":"R12/S10","v":{"$error":"#N/A"}},null,null,"Usures pneus : "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps moyen : ",null,null,{"$f":"'Strat 1'!E72","v":{"$error":"#N/A"}},null,null,"Cumul perte de temps :",null,null,{"$f":"IF('Strat 1'!V59=0,\"\",'Strat 1'!V59)","v":{"$error":"#N/A"}},null,null,"par tour :",null,null,{"$f":"'Strat 1'!V60","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Stratégie 2",null,null,"Indice de risque :",null,null,{"$f":"T78","v":0},null,null,"Type pneus :",{"$f":"'Strat 2'!E39","v":0},null,{"$f":"'Strat 2'!G39","v":0},null,{"$f":"'Strat 2'!I39","v":0},null,{"$f":"'Strat 2'!K39","v":0},null,{"$f":"'Strat 2'!M39","v":0},null,{"$f":"'Strat 2'!O39","v":0}]
[null,null,null,null,"type",null,"tps moyen",null,"durée",null,null,null,null,null,null,null,null,null,null,null,"Pit","Dép.",null,"P1",null,"P2",null,"P3",null,"P3",null,"P3"]
[null,null,null,null,{"$f":"'Strat 2'!I68","v":0},null,{"$f":"'Strat 2'!K68","v":{"$error":"#DIV/0!"}},null,{"$f":"'Strat 2'!G14","v":0},null,null,null,null,"STOP PIT","Durée : ",null,null,{"$f":"'Strat 2'!Q68","v":{"$error":"#N/A"}},{"$f":"R24*24","v":{"$error":"#N/A"}},0,"Nbr de tours :",{"$f":"'Strat 2'!F31","v":0},null,{"$f":"'Strat 2'!H31","v":0},null,{"$f":"'Strat 2'!J31","v":0},null,{"$f":"'Strat 2'!L31","v":0},null,{"$f":"'Strat 2'!N31","v":0},null,{"$f":"'Strat 2'!P31","v":0}]
[]
[null,null,null,null,{"$f":"'Strat 2'!I70","v":0},null,{"$f":"'Strat 2'!K70","v":{"$error":"#DIV/0!"}},null,{"$f":"'Strat 2'!K14","v":0},null,null,"Nombre : ",null,{"$f":"'Strat 2'!E68","v":{"$error":"#N/A"}},"Distance : ",null,null,{"$f":"IF('Strat 2'!Q70=0,\"\",'Strat 2'!Q70)","v":{"$error":"#N/A"}},null,null,"Conduite éco :",{"$f":"'Strat 2'!E45","v":0},null,{"$f":"'Strat 2'!G45","v":0},null,{"$f":"'Strat 2'!I45","v":0},null,{"$f":"'Strat 2'!K45","v":0},null,{"$f":"'Strat 2'!M45","v":0},null,{"$f":"'Strat 2'!O45","v":0}]
[]
[]
[null,null,null,null,{"$f":"'Strat 2'!I72","v":0},null,{"$f":"'Strat 2'!K72","v":{"$error":"#DIV/0!"}},null,{"$f":"'Strat 2'!O14","v":0},null,null,"Cumul temps : ",null,{"$f":"'Strat 2'!E70","v":{"$error":"#N/A"}},"Vitesse moyenne : ",null,null,{"$f":"R26/S24","v":{"$error":"#N/A"}},null,null,"Usures pneus : "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps moyen : ",null,null,{"$f":"'Strat 2'!E72","v":{"$error":"#N/A"}},null,null,"Cumul perte de temps :",null,null,{"$f":"IF('Strat 2'!V59=0,\"\",'Strat 2'!V59)","v":{"$error":"#N/A"}},null,null,"par tour :",null,null,{"$f":"'Strat 2'!V60","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Stratégie 3",null,null,"Indice de risque :",null,null,{"$f":"T87","v":0},null,null,"Type pneus :",{"$f":"'strat 3'!E39","v":0},null,{"$f":"'strat 3'!G39","v":0},null,{"$f":"'strat 3'!I39","v":0},null,{"$f":"'strat 3'!K39","v":0},null,{"$f":"'strat 3'!M39","v":0},null,{"$f":"'strat 3'!O39","v":0}]
[null,null,null,null,"type",null,"tps moyen",null,"durée",null,null,null,null,null,null,null,null,null,null,null,"Pit","Dép.",null,"P1",null,"P2",null,"P3",null,"P3",null,"P3",null,null,null,null,"La meilleur stratégie est en principe celle ou la majorité des indicateurs sont verts avec le temps moyen / tour le plus bas et l'indice de risque le plus faible."]
[null,null,null,null,{"$f":"'strat 3'!I68","v":0},null,{"$f":"'strat 3'!K68","v":{"$error":"#DIV/0!"}},null,{"$f":"'strat 3'!G14","v":0},null,null,null,null,"STOP PIT","Durée : ",null,null,{"$f":"'strat 3'!Q68","v":{"$error":"#N/A"}},{"$f":"R38*24","v":{"$error":"#N/A"}},null,"Nbr de tours :",{"$f":"'strat 3'!F31","v":0},null,{"$f":"'strat 3'!H31","v":0},null,{"$f":"'strat 3'!J31","v":0},null,{"$f":"'strat 3'!L31","v":0},null,{"$f":"'strat 3'!N31","v":0},null,{"$f":"'strat 3'!P31","v":0}]
[]
[null,null,null,null,{"$f":"'strat 3'!I70","v":0},null,{"$f":"'strat 3'!K70","v":{"$error":"#DIV/0!"}},null,{"$f":"'strat 3'!K14","v":0},null,null,"Nombre : ",null,{"$f":"'strat 3'!E68","v":{"$error":"#N/A"}},"Distance : ",null,null,{"$f":"IF('strat 3'!Q70=0,\"\",'strat 3'!Q70)","v":{"$error":"#N/A"}},null,null,"Conduite éco :",{"$f":"'strat 3'!E45","v":0},null,{"$f":"'strat 3'!G45","v":0},null,{"$f":"'strat 3'!I45","v":0},null,{"$f":"'strat 3'!K45","v":0},null,{"$f":"'strat 3'!M45","v":0},null,{"$f":"'strat 3'!O45","v":0}]
[]
[]
[null,null,null,null,{"$f":"'strat 3'!I72","v":0},null,{"$f":"'strat 3'!K72","v":{"$error":"#DIV/0!"}},null,{"$f":"'strat 3'!O14","v":0},null,null,"Cumul temps : ",null,{"$f":"'strat 3'!E70","v":{"$error":"#N/A"}},"Vitesse moyenne : ",null,null,{"$f":"R40/S38","v":{"$error":"#N/A"}},null,null,"Usures pneus : "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps moyen : ",null,null,{"$f":"'strat 3'!E72","v":{"$error":"#N/A"}},null,null,"Cumul perte de temps :",null,null,{"$f":"IF('strat 3'!V59=0,\"\",'strat 3'!V59)","v":{"$error":"#N/A"}},null,null,"par tour :",null,null,{"$f":"'strat 3'!V60","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ajuster valeur max indice risque",null,null,null,null,null,null,null,200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"strat 1","nb tours",null,"Coeff.","points",null,null,"dépasse"]
[null,null,null,null,null,null,null,null,null,null,null,null,"S soft",{"$f":"'Strat 1'!$Q$53","v":0},null,1,{"$f":"P63*N63","v":0},null,null,"nbr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"soft",{"$f":"'Strat 1'!$Q$54","v":0},null,1.5,{"$f":"P64*N64","v":0},null,null,"tours"]
[null,null,null,null,null,null,null,null,null,null,null,null,"médium",{"$f":"'Strat 1'!$Q$55","v":0},null,2,0,null,null,{"$f":"T69-(Q69+R69)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"hard",{"$f":"'Strat 1'!$Q$56","v":0},null,3,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"inter",{"$f":"'Strat 1'!$Q$58","v":0},null,4,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"pluie",{"$f":"'Strat 1'!$Q$59","v":0},null,6,0,"usure pneus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q63:Q68)","v":0},{"$f":"V15+X15+Z15+AB15+AD15+AF15","v":0},null,{"$f":"Q69+R69+'Strat 1'!R32","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"strat 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,"S soft",{"$f":"'Strat 2'!$Q$53","v":0},null,{"$f":"P63","v":1},{"$f":"P72*N72","v":0},null,null,"dépasse"]
[null,null,null,null,null,null,null,null,null,null,null,null,"soft",{"$f":"'Strat 2'!$Q$54","v":0},null,{"$f":"P64","v":1.5},{"$f":"P73*N73","v":0},null,null,"nbr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"médium",{"$f":"'Strat 2'!$Q$55","v":0},null,2,0,null,null,"tours"]
[null,null,null,null,null,null,null,null,null,null,null,null,"hard",{"$f":"'Strat 2'!$Q$56","v":0},null,3,0,null,null,{"$f":"T78-(Q78+R78)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"inter",{"$f":"'Strat 2'!$Q$58","v":0},null,4,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"pluie",{"$f":"'Strat 2'!$Q$59","v":0},null,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q72:Q77)","v":0},{"$f":"V29+X29+Z29+AB29+AD29+AF29","v":0},null,{"$f":"Q78+R78+'Strat 2'!R32","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"strat 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"S soft",{"$f":"'strat 3'!$Q$53","v":0},null,{"$f":"P63","v":1},{"$f":"P81*N81","v":0},null,null,"dépasse"]
[null,null,null,null,null,null,null,null,null,null,null,null,"soft",{"$f":"'strat 3'!$Q$54","v":0},null,{"$f":"P64","v":1.5},{"$f":"P82*N82","v":0},null,null,"nbr"]
[null,null,null,null,null,null,null,null,null,null,null,null,"médium",{"$f":"'strat 3'!$Q$55","v":0},null,2,0,null,null,"tours"]
[null,null,null,null,null,null,null,null,null,null,null,null,"hard",{"$f":"'strat 3'!$Q$56","v":0},null,3,0,null,null,{"$f":"T87-(Q87+R87)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"inter",{"$f":"'strat 3'!$Q$58","v":0},null,4,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"pluie",{"$f":"'strat 3'!$Q$59","v":0},null,6,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q81:Q86)","v":0},{"$f":"V43+X43+Z43+AB43+AD43+AF43","v":0},null,{"$f":"Q87+R87+'strat 3'!R32","v":0}]

{"sheet":"chronos","index":5,"n_rows":96,"n_cols":34,"rows_kept":96,"cut":false,"hidden":false,"merged":[[12,1,15,1],[1,1,1,6],[21,2,21,4],[29,15,29,19],[28,6,28,8],[11,15,11,19],[9,14,10,22],[12,21,15,21],[13,19,15,19],[13,6,15,6],[13,7,15,7],[9,2,11,4],[25,11,25,14],[6,2,6,5],[13,18,15,18],[13,15,15,15],[30,21,33,21],[45,21,48,21],[46,15,48,15],[46,16,48,16],[46,17,48,17],[46,18,48,18],[46,19,48,19],[13,16,15,16],[13,17,15,17],[44,15,44,19],[4,2,4,5],[13,9,15,9],[13,10,15,10],[13,12,15,12],[13,13,15,13],[9,6,9,7],[9,9,9,10],[9,12,9,13],[13,4,15,4],[6,7,6,9],[4,8,4,9]]}
[]
[null,"Tableau des temps :"]
[]
[]
[null,null,"Equilibre des performances : ",null,null,null,null,null,"Météo circuit : ",null,{"$f":"'Strat 1'!Q3","v":0},null,{"$f":"'Strat 1'!R3","v":"0h0"}]
[]
[null,null,"Usure des pneumatiques : ",null,null,null,"X1","Consommation fuel : ",null,null,"X1","niv",100,{"$f":"'Strat 1'!Q18","v":100}]
[]
[]
[null,null,"Utilisation d'un même train de pneus    pour :",null,null,null,"Essais libres 1",null,null,"Essais libres 2",null,null,"Essais libre 3"]
[]
[]
[null,"gommes"]
[null,null,null,null,"Meilleur temps",null,"Moins bon temps","Temps moyen",null,"Moins bon temps","Temps moyen",null,"Moins bon temps","Temps moyen"]
[]
[null,null,"Pneumatiques"]
[]
[null,1,null,null,null,null,null,{"$f":"AVERAGEIF(E18:G18,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"E18","v":"00:00:00"},{"$f":"G18","v":"00:00:00"},{"$f":"AVERAGEIF(I18:J18,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"E18","v":"00:00:00"},{"$f":"J18","v":"00:00:00"},{"$f":"AVERAGEIF(L18:M18,\"<>0\")","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,{"$error":"#DIV/0!"},{"$f":"E19","v":"00:00:00"},{"$f":"G19","v":"00:00:00"},{"$f":"AVERAGEIF(I19:J19,\"<>0\")","v":{"$error":"#DIV/0!"}},{"$f":"E19","v":"00:00:00"},{"$f":"J19","v":"00:00:00"},{"$f":"AVERAGEIF(L19:M19,\"<>0\")","v":{"$error":"#DIV/0!"}}]
[null,3,null,null,null,null,null,{"$error":"#DIV/0!"},"00:00:00",{"$f":"G20","v":"00:00:00"},{"$error":"#DIV/0!"},"00:00:00",{"$f":"J20","v":"00:00:00"},{"$error":"#DIV/0!"}]
[]
[null,null,"Répartition freins : ",null,null,"AV",0,"AR","AV",0,"AR","AV",0,"AR"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Ajuster l'échelles du graphique : "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"meilleur tour",{"$f":"G12","v":0},{"$f":"J12","v":0},{"$f":"M12","v":0},null,null,null,null,null,null,null,"temps",{"$f":"P18","v":0},{"$f":"P19","v":0},{"$f":"P20","v":0},{"$f":"P21","v":0},{"$f":"P22","v":0},{"$f":"P24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":0},{"$f":"E18","v":"00:00:00"},{"$f":"H18","v":{"$error":"#DIV/0!"}},{"$f":"K18","v":{"$error":"#DIV/0!"}},{"$f":"N18","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"G12","v":0},{"$f":"G18","v":"00:00:00"},{"$f":"G19","v":"00:00:00"},{"$f":"G20","v":"00:00:00"},{"$f":"G21","v":"00:00:00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G24","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C19","v":0},{"$f":"E19","v":"00:00:00"},{"$f":"H19","v":{"$error":"#DIV/0!"}},{"$f":"K19","v":{"$error":"#DIV/0!"}},{"$f":"N19","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"J12","v":0},{"$f":"J18","v":"00:00:00"},{"$f":"J19","v":"00:00:00"},{"$f":"J20","v":"00:00:00"},{"$f":"J21","v":"00:00:00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"J24","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C20","v":0},{"$f":"E20","v":"00:00:00"},{"$f":"H20","v":{"$error":"#DIV/0!"}},{"$f":"K20","v":{"$error":"#DIV/0!"}},{"$f":"N20","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,{"$f":"M12","v":0},{"$f":"M18","v":"00:00:00"},{"$f":"M19","v":"00:00:00"},{"$f":"M20","v":"00:00:00"},{"$f":"M21","v":"00:00:00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"M24","v":"00:00:00"}]
[]
[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,"moyenne",{"$f":"P18","v":0},{"$f":"P19","v":0},{"$f":"P20","v":0},{"$f":"P21","v":0},{"$f":"P22","v":0},{"$f":"P24","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,{"$f":"G12","v":0},{"$f":"H18","v":{"$error":"#DIV/0!"}},{"$f":"H19","v":{"$error":"#DIV/0!"}},{"$f":"H20","v":{"$error":"#DIV/0!"}},{"$f":"H21","v":"00:00:00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"H24","v":"00:00:00"}]
[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":"J12","v":0},{"$f":"K18","v":{"$error":"#DIV/0!"}},{"$f":"K19","v":{"$error":"#DIV/0!"}},{"$f":"K20","v":{"$error":"#DIV/0!"}},{"$f":"K21","v":"00:00:00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"K24","v":"00:00:00"}]
[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":"M12","v":0},{"$f":"N18","v":{"$error":"#DIV/0!"}},{"$f":"N19","v":{"$error":"#DIV/0!"}},{"$f":"N20","v":{"$error":"#DIV/0!"}},{"$f":"N21","v":"00:00:00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"N24","v":"00:00:00"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,86400,null,null,"meilleur tour",{"$f":"R78","v":0},{"$f":"S78","v":0},{"$f":"T78","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C18","v":0},{"$f":"(Q79*$N$90)","v":0},{"$f":"(R79*$N$90)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C19","v":0},{"$f":"(Q80*$N$90)","v":0},{"$error":"#DIV/0!"},{"$f":"(S80*$N$90)","v":{"$error":"#DIV/0!"}},{"$f":"(T80*$N$90)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C20","v":0},0,{"$error":"#DIV/0!"},{"$f":"(S81*$N$90)","v":{"$error":"#DIV/0!"}},{"$f":"(T81*$N$90)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"(S82*$N$90)","v":0},{"$f":"(T82*$N$90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"(S83*$N$90)","v":0},{"$f":"(T83*$N$90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$f":"(S84*$N$90)","v":0},{"$f":"(T84*$N$90)","v":0}]

{"sheet":"nbr tours","index":6,"n_rows":208,"n_cols":15,"rows_kept":208,"cut":false,"hidden":false,"merged":[[3,14,3,15],[99,14,99,15],[199,14,199,15],[200,9,203,9],[100,9,103,9],[4,9,7,9],[101,11,103,11],[5,11,7,11],[201,3,203,3],[201,4,203,4],[201,5,203,5],[197,5,197,12],[201,6,203,6],[201,7,203,7],[201,11,203,11],[199,4,199,7],[1,5,1,12],[97,5,97,12],[101,3,103,3],[101,4,103,4],[101,5,103,5],[3,4,3,7],[99,4,99,7],[101,6,103,6],[101,7,103,7],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,7,7,7]]}
[]
[null,null,"STRAT 1"]
[]
[null,null,null,null,"Nombre de tours par train de pneus",null,null,null,null,null,null,null,null,null,"menu"]
[]
[null,null,null,"Type de\npneus","Durée de vie\nou pic performance","Meilleur temps chrono","Moins bon temps","Temps moyen de réf. strat",null,null,null,"Ecart\nMT/MBT"]
[]
[]
[]
[null,null,null,{"$f":"chronos!$C$18","v":0},{"$f":"'Strat 1'!G14","v":0},{"$f":"chronos!E18","v":"00:00:00"},{"$f":"VLOOKUP('Strat 1'!G14,chronos!$AB$79:$AH$81,2,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('Strat 1'!G14,chronos!$AB$84:$AH$86,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(H10,0)","v":"00:00:00"},null,null,{"$f":"G10-F10","v":"00:00:00"}]
[null,null,null,{"$f":"chronos!$C$19","v":0},{"$f":"'Strat 1'!K14","v":0},{"$f":"chronos!E19","v":"00:00:00"},{"$f":"VLOOKUP('Strat 1'!K14,chronos!$AB$79:$AH$81,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('Strat 1'!K14,chronos!$AB$84:$AH$86,3,FALSE)","v":{"$error":"#DIV/0!"}},"00:00:00",null,null,"00:00:00"]
[null,null,null,{"$f":"chronos!$C$20","v":0},{"$f":"'Strat 1'!O14","v":0},{"$f":"chronos!E20","v":"00:00:00"},{"$f":"VLOOKUP('Strat 1'!O14,chronos!$AB$79:$AH$81,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('Strat 1'!O14,chronos!$AB$84:$AH$86,4,FALSE)","v":{"$error":"#DIV/0!"}},"00:00:00",{"$f":"AVERAGEIF(I10:I15,\"<>0\")","v":{"$error":"#DIV/0!"}},null,"00:00:00"]
[]
[null,null,null,null,null,null,null,null,"00:00:00"]
[null,null,null,null,null,null,null,null,"00:00:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STRAT 2"]
[]
[null,null,null,null,"Nombre de tours par train de pneus",null,null,null,null,null,null,null,null,null,"menu"]
[]
[null,null,null,"Type de\npneus","Durée de vie\nou pic performance","Meilleur temps chrono","Moins bon temps","Temps moyen de réf. strat",null,null,null,"Ecart\nMT/MBT"]
[]
[]
[]
[null,null,null,{"$f":"chronos!$C$18","v":0},{"$f":"'Strat 2'!G14","v":0},{"$f":"chronos!E18","v":"00:00:00"},{"$f":"VLOOKUP('Strat 2'!G14,chronos!$AB$79:$AH$81,2,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('Strat 2'!G14,chronos!$AB$84:$AH$86,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(H106,0)","v":"00:00:00"},null,null,{"$f":"G106-F106","v":"00:00:00"}]
[null,null,null,{"$f":"chronos!$C$19","v":0},{"$f":"'Strat 2'!K14","v":0},{"$f":"chronos!E19","v":"00:00:00"},{"$f":"VLOOKUP('Strat 2'!K14,chronos!$AB$79:$AH$81,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('Strat 2'!K14,chronos!$AB$84:$AH$86,3,FALSE)","v":{"$error":"#DIV/0!"}},"00:00:00",null,null,"00:00:00"]
[null,null,null,{"$f":"chronos!$C$20","v":0},{"$f":"'Strat 2'!O14","v":0},{"$f":"chronos!E20","v":"00:00:00"},{"$f":"VLOOKUP('Strat 2'!O14,chronos!$AB$79:$AH$81,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('Strat 2'!O14,chronos!$AB$84:$AH$86,4,FALSE)","v":{"$error":"#DIV/0!"}},"00:00:00",{"$f":"AVERAGEIF(I106:I111,\"<>0\")","v":{"$error":"#DIV/0!"}},null,"00:00:00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STRAT 3"]
[]
[null,null,null,null,"Nombre de tours par train de pneus",null,null,null,null,null,null,null,null,null,"menu"]
[]
[null,null,null,"Type de\npneus","Durée de vie\nou pic performance","Meilleur temps chrono","Moins bon temps","Temps moyen de réf. strat",null,null,null,"Ecart\nMT / MBT"]
[]
[]
[]
[null,null,null,{"$f":"chronos!$C$18","v":0},{"$f":"'strat 3'!G14","v":0},{"$f":"chronos!E18","v":"00:00:00"},{"$f":"VLOOKUP('strat 3'!G14,chronos!$AB$79:$AH$81,2,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('strat 3'!G14,chronos!$AB$84:$AH$86,2,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(H206,0)","v":"00:00:00"},null,null,{"$f":"G206-F206","v":"00:00:00"}]
[null,null,null,{"$f":"chronos!$C$19","v":0},{"$f":"'strat 3'!K14","v":0},{"$f":"chronos!E19","v":"00:00:00"},{"$f":"VLOOKUP('strat 3'!K14,chronos!$AB$79:$AH$81,3,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('strat 3'!K14,chronos!$AB$84:$AH$86,3,FALSE)","v":{"$error":"#DIV/0!"}},"00:00:00",null,null,"00:00:00"]
[null,null,null,{"$f":"chronos!$C$20","v":0},{"$f":"'strat 3'!O14","v":0},{"$f":"chronos!E20","v":"00:00:00"},{"$f":"VLOOKUP('strat 3'!O14,chronos!$AB$79:$AH$81,4,FALSE)","v":"00:00:00"},{"$f":"VLOOKUP('strat 3'!O14,chronos!$AB$84:$AH$86,4,FALSE)","v":{"$error":"#DIV/0!"}},"00:00:00",{"$f":"AVERAGEIF(I206:I211,\"<>0\")","v":{"$error":"#DIV/0!"}},null,"00:00:00"]

{"sheet":"ajust éco","index":7,"n_rows":66,"n_cols":16,"rows_kept":66,"cut":false,"hidden":false,"merged":[[50,1,50,2],[3,15,4,15],[12,14,12,16],[5,1,6,1],[5,8,5,11],[30,1,30,7],[5,2,5,6],[1,2,3,11]]}
[]
[null,null,"Ajustements autonomie et temps conduite éco"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Menu"]
[]
[null,"Réglages\nconduite éco","Gain autonomie",null,null,null,null,null,"Dégradation temps"]
[null,null,"Coeff.",{"$f":"'Strat 1'!M18","v":{"$error":"#N/A"}},{"$f":"'Strat 1'!I18*'Strat 1'!K3","v":{"$error":"#N/A"}},"Gain nbr tours","L/100","réservoir","Sec/Km","pas à pas","Sec/Km","Sec/tour"]
[]
[null,0,0,{"$f":"(1*G9)/$E$7","v":{"$error":"#N/A"}},"écart conso",0,{"$f":"'Strat 1'!K18","v":100},100,0,0,0,0]
[null,"tr/mn 2/3",4,{"$f":"(1*G10)/$E$7","v":{"$error":"#N/A"}},{"$f":"C10+$B$65","v":4},{"$f":"(H10*$A$11)/$H$9-$A$11","v":0},{"$f":"$G$9-E10","v":96},{"$f":"$H$9+E10","v":104},{"$f":"J10+($B$66/50)","v":0.01},{"$f":"K10","v":0.01},0.01,{"$f":"I10*$D$46","v":{"$error":"#N/A"}}]
[{"$f":"'Strat 1'!I18","v":0},"tr/mn 1/2",8,{"$error":"#N/A"},8,0,{"$f":"$G$9-E11","v":92},{"$f":"$H$9+E11","v":108},{"$f":"J11+($B$66/50)","v":3.5000000000000003E-2},{"$f":"K11+K10","v":3.5000000000000003E-2},2.5000000000000001E-2,{"$error":"#N/A"}]
[null,"tr/mn 1/3",16,{"$error":"#N/A"},16,0,84,116,0.1,{"$f":"K12+K11","v":0.1},7.4999999999999997E-2,{"$error":"#N/A"}]
[null,2,20,{"$error":"#N/A"},20,0,80,120,0.17499999999999999,{"$f":"K13+K12","v":0.17499999999999999},0.1,{"$error":"#N/A"},null,null,"Réinitialiser :"]
[null,3,30,{"$error":"#N/A"},30,0,70,130,0.25,{"$f":"K13+K14","v":0.25},0.15,{"$error":"#N/A"}]
[null,4,45,{"$error":"#N/A"},45,0,55,145,0.35,0.35,0.2,{"$error":"#N/A"}]
[null,5,60,{"$error":"#N/A"},60,0,40,160,0.45,0.45,0.25,{"$error":"#N/A"}]
[null,6,75,{"$error":"#N/A"},75,0,25,175,0.55000000000000004,0.55000000000000004,0.3,{"$error":"#N/A"}]
[null,null,null,"litre au km","éco nbr litres"]
[null,null,null,"formule strat 1"]
[null,null,null,"E42"]
[]
[]
[]
[]
[null,"Pour augmenter l'autonomie : jouer sur le curseur ou saisir un chiffre supérieur à celui existant dans la colonne \"Coeff gain autonomie\""]
[null,"Pour réduire l'autonomie : saisir un chiffre inferieur à celui existant dans la colonne \"Coeff gain autonomie\""]
[]
[null,"Pour accroitre la perte de temps du à la réduction de la vitesse :  jouer sur le curseur ou saisir un temps supérieur à celui existant dans la colonne \"Coeff réduction de vitesse\""]
[null,"Pour réduire la perte de temps du à la réduction de la vitesse : saisir un chiffre inferieur à celui existant, voir négatif ci nécessaire, dans la colonne \"Coeff réduction de vitesse\""]
[]
[null,"NB) les ajustements réalisés sont communs aux 3 stratégies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"long circuit"]
[null,null,null,{"$f":"'Strat 1'!K3","v":{"$error":"#N/A"}}]
[null,null,null,"conso 100 km"]
[null,null,null,{"$f":"'Strat 1'!K18","v":100}]
[null,null,null,null,1]
[]
[]
[]
[null,null,"Valeurs par défaut"]
[null,0,0,null,null,null,null,null,0]
[null,"tr/mn 2/3",4,null,null,null,null,null,0,null,0.01]
[null,"tr/mn 1/2",8,null,null,null,null,null,0.05,null,2.5000000000000001E-2]
[null,"tr/mn 1/3",16,null,null,null,null,null,0.1,null,7.4999999999999997E-2]
[null,2,20,null,null,null,null,null,0.3,null,0.1]
[null,3,30,null,null,null,null,null,0.5,null,0.15]
[null,4,45,null,null,null,null,null,0.65,null,0.2]
[null,5,60,null,null,null,null,null,0.85,null,0.25]
[null,6,75,null,null,null,null,null,1,null,0.3]
[]
[]
[null,0]
[null,0]

{"sheet":"circuits","index":8,"n_rows":263,"n_cols":10,"rows_kept":263,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"29 circuits, 85 pistes"]
[null,null,null,null,null,null,null,null,"Circuits - Pistes","Long (km)"]
[null,null,null,null,null,null,null,null,"Alsace - Village",{"$f":"grille!L19","v":5.423}]
[null,null,null,null,null,null,null,null,"Alsace - Village II",{"$f":"grille!L20","v":5.423}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - GP",{"$f":"grille!L21","v":5.8090000000000002}]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - GP II",{"$f":"grille!L22","v":5.8090000000000002}]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Centre",{"$f":"grille!L23","v":1.706}]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Centre II",{"$f":"grille!L24","v":1.706}]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Est",{"$f":"grille!L25","v":3.6429999999999998}]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Est II",{"$f":"grille!L26","v":3.6429999999999998}]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Ouest",{"$f":"grille!L27","v":4.1680000000000001}]
[null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Ouest II",{"$f":"grille!L28","v":4.1680000000000001}]
[]
[null,null,null,null,null,null,null,null,"Autódromo De Interlagos",{"$f":"grille!L29","v":4.3090000000000002}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Autodromo Nazionale Monza",{"$f":"grille!L30","v":5.7930000000000001}]
[null,null,null,null,null,null,null,null,"Autodromo Nazionale Monza - sans chicane",{"$f":"grille!L31","v":5.7549999999999999}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Autopolis International Racing Course",{"$f":"grille!L32","v":4.67}]
[null,null,null,null,null,null,null,null,"Autopolis International Racing Course - Court",{"$f":"grille!L33","v":3.02}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway",{"$f":"grille!L34","v":3.2}]
[null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway II",{"$f":"grille!L35","v":3.2}]
[null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central A",{"$f":"grille!L36","v":3.35}]
[null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central A II",{"$f":"grille!L37","v":3.35}]
[null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central B",{"$f":"grille!L38","v":2.86}]
[null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central B II",{"$f":"grille!L39","v":2.86}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Brands Hatch Grand Prix Circuit",{"$f":"grille!L40","v":3.9460000000000002}]
[null,null,null,null,null,null,null,null,"Brands Hatch Indy Circuit",{"$f":"grille!L41","v":1.929}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"BB Raceway",{"$f":"grille!L42","v":1.665}]
[null,null,null,null,null,null,null,null,"BB Raceway II",{"$f":"grille!L43","v":1.665}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Circuit de Barcelona-Catalunya version GP",{"$f":"grille!L44","v":4.6550000000000002}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Circuit de la Sarthe",{"$f":"grille!L45","v":13.625999999999999}]
[null,null,null,null,null,null,null,null,"Circuit de la Sarthe (Sans chicane)",{"$f":"grille!L46","v":13.625999999999999}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - A",{"$f":"grille!L47","v":9.4770000000000003}]
[null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - A II",{"$f":"grille!L48","v":9.4770000000000003}]
[null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - B",{"$f":"grille!L49","v":7.0620000000000003}]
[null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - B II",{"$f":"grille!L50","v":7.0620000000000003}]
[null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - C",{"$f":"grille!L51","v":10.824999999999999}]
[null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - C II",{"$f":"grille!L52","v":10.824999999999999}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Circuit de Spa-Francorchamps",{"$f":"grille!L53","v":7.0039999999999996}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Colorado Springs - Lac",{"$f":"grille!L54","v":2.99}]
[null,null,null,null,null,null,null,null,"Colorado Springs - Lac II",{"$f":"grille!L55","v":2.99}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Dragon Trail - Littoral",{"$f":"grille!L56","v":5.2089999999999996}]
[null,null,null,null,null,null,null,null,"Dragon Trail - Littoral II",{"$f":"grille!L57","v":5.2089999999999996}]
[null,null,null,null,null,null,null,null,"Dragon Trail - Jardins",{"$f":"grille!L58","v":4.3520000000000003}]
[null,null,null,null,null,null,null,null,"Dragon Trail - Jardins II",{"$f":"grille!L59","v":4.3520000000000003}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Fishermans Ranch",{"$f":"grille!L60","v":6.8929999999999998}]
[null,null,null,null,null,null,null,null,"Fishermans Ranch II",{"$f":"grille!L61","v":6.8929999999999998}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Fuji International Speedway",{"$f":"grille!L62","v":4.5629999999999997}]
[null,null,null,null,null,null,null,null,"Fuji International Speedway - Court",{"$f":"grille!L63","v":4.5259999999999998}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Goodwood Motor Circuit",{"$f":"grille!L64","v":3.8090000000000002}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Kyoto Driving Park - Miyabi",{"$f":"grille!L65","v":1.9530000000000001}]
[null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa",{"$f":"grille!L66","v":4.9119999999999999}]
[null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa II",{"$f":"grille!L67","v":4.9119999999999999}]
[null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa+Miyabi",{"$f":"grille!L68","v":6.8460000000000001}]
[null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa+Miyabi II",{"$f":"grille!L69","v":6.8460000000000001}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Mount Panorama Motor Racing Circuit",{"$f":"grille!L70","v":6.2130000000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Northern Isle Speedway",{"$f":"grille!L71","v":0.9}]
[null,null,null,null,null,null,null,null,"Northern Isle Speedway – Infield",{"$f":"grille!L72","v":0.9}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"24 Heures du Nürburgring",{"$f":"grille!L73","v":25.378}]
[null,null,null,null,null,null,null,null,"Nürburgring GP",{"$f":"grille!L74","v":5.1479999999999997}]
[null,null,null,null,null,null,null,null,"Nürburgring Nordschleife",{"$f":"grille!L75","v":20.832000000000001}]
[null,null,null,null,null,null,null,null,"Nürburgring Nordschleife - Tracé visiteurs",{"$f":"grille!L76","v":20.832000000000001}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Red Bull Ring",{"$f":"grille!L77","v":4.3179999999999996}]
[null,null,null,null,null,null,null,null,"Red Bull Ring - Court",{"$f":"grille!L78","v":2.3359999999999999}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Sardegna - Éoliennes",{"$f":"grille!L79","v":3.31}]
[null,null,null,null,null,null,null,null,"Sardegna - Éoliennes II",{"$f":"grille!L80","v":3.31}]
[null,null,null,null,null,null,null,null,"Sardegna - Piste A",{"$f":"grille!L81","v":5.1130000000000004}]
[null,null,null,null,null,null,null,null,"Sardegna - Piste A II",{"$f":"grille!L82","v":5.1130000000000004}]
[null,null,null,null,null,null,null,null,"Sardegna - Piste B",{"$f":"grille!L83","v":3.8929999999999998}]
[null,null,null,null,null,null,null,null,"Sardegna - Piste B II",{"$f":"grille!L84","v":3.8929999999999998}]
[null,null,null,null,null,null,null,null,"Sardegna - Piste C",{"$f":"grille!L85","v":2.661}]
[null,null,null,null,null,null,null,null,"Sardegna - Piste C II",{"$f":"grille!L86","v":2.661}]
[]
[null,null,null,null,null,null,null,null,"Special Stage Route X",{"$f":"grille!L87","v":30.283000000000001}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Suzuka Circuit",{"$f":"grille!L88","v":5.8079999999999998}]
[null,null,null,null,null,null,null,null,"Suzuka Circuit - Course Est",{"$f":"grille!L89","v":2.2429999999999999}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle intérieure centrale",{"$f":"grille!L90","v":4.3689999999999998}]
[null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle extérieure centrale",{"$f":"grille!L91","v":4.4050000000000002}]
[null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle intérieure Est",{"$f":"grille!L92","v":7.1920000000000002}]
[null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle extérieure Est",{"$f":"grille!L93","v":7.3010000000000002}]
[null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle extérieure Sud",{"$f":"grille!L94","v":6.56}]
[null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle intérieure Sud",{"$f":"grille!L95","v":5.2009999999999996}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Tsukuba Circuit",{"$f":"grille!L96","v":2.0449999999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"WeatherTech Raceway Laguna Seca",{"$f":"grille!L97","v":3.6}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Willow Springs - Big Willow",{"$f":"grille!L98","v":3.9510000000000001}]
[null,null,null,null,null,null,null,null,"Willow Springs - Horse Thief Mile",{"$f":"grille!L99","v":1.6240000000000001}]
[null,null,null,null,null,null,null,null,"Willow Springs - Horse Thief Mile II",{"$f":"grille!L100","v":1.6240000000000001}]
[null,null,null,null,null,null,null,null,"Willow Springs - Streets of Willow Springs",{"$f":"grille!L101","v":2.6749999999999998}]
[null,null,null,null,null,null,null,null,"Willow Springs- Streets of Willow Springs II",{"$f":"grille!L102","v":2.6749999999999998}]

{"sheet":"voitures","index":9,"n_rows":345,"n_cols":5,"rows_kept":345,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
["N°","Catégories","Marques","Modèles"]
[1,"N 300","Ford","FOCUS ST 2015"]
[2,"N 400","Ford","MUSTANG GT PREMIUM FASTBACK 2015"]
[3,"Gr.4","Ford","MUSTANG GR.4"]
[4,"Gr.3","Ford","MUSTANG GR.3"]
[5,"Gr.B","Ford","MUSTANG GR.B RALLY CAR"]
[6,"Gr.B","Ford","FOCUS GR.B RALLY CAR"]
[7,"N 500","Chevrolet","CAMARO SS 2016"]
[8,"N 500","Chevrolet","CORVETTE STINGRAY 2014"]
[9,"Gr.4","Chevrolet","CORVETTE C7 GR.4"]
[10,"Gr.3","Chevrolet","CORVETTE C7 GR.3"]
[11,"N 700","Dodge","DODGE CHARGER SRT HELLCAT 2015"]
[12,"N 600","Dodge","VIPER GTS 2013"]
[13,"Gr.4","Dodge","VIPER GR.4"]
[14,"Gr.3","Dodge","VIPER SRT GT3-R 2015"]
[15,"Gr.1","Dodge","SRT TOMAHAWK VISION GRAN TURISMO GR.1"]
[16,"Gr.X","Dodge","SRT TOMAHAWK VISION GRAN TURISMO TECHNOLOGY"]
[17,"Gr.X","Dodge","SRT TOMAHAWK VISION GRAN TURISMO RACING"]
[18,"Gr.X","Dodge","SRT TOMAHAWK VISION GRAN TURISMO STREET"]
[19,"Gr.X","Infiniti","INFINITI CONCEPT VISION GRAN TURISMO"]
[20,"Gr.X","Chaparral","CHEVROLET CHAPARRAL 2X VISION GRAN TURISMO"]
[21,"Gr.X","Fittipaldi Motors","FITTIPALDI EF7 VISION GRAN TURISMO BY PININFARINA"]
[22,"N 600","Jaguar","F-TYPE R COUPE 2014"]
[23,"Gr.4","Jaguar","F-TYPE GR.4"]
[24,"Gr.3","Jaguar","F-TYPE GR.3"]
[25,"N 400","Aston Martin","V8 VANTAGE S 2015"]
[26,"Gr.4","Aston Martin","VANTAGE GR.4"]
[27,"Gr.3","Aston Martin","VI2 VANTAGE GT3 2012"]
[28,"N 800","Aston Martin","ONE-77 2011"]
[29,"N 800","Aston Martin","ASTON MARTIN VULCAN 2016"]
[30,"Gr.X","Aston Martin","ASTON MARTIN DP-100 VISION GRAN TURISMO"]
[31,"N 600","McLaren","MP4-12C 2010"]
[32,"N 700","McLaren","650S COUPE 2014"]
[33,"Gr.4","McLaren","650S GR.4"]
[34,"Gr.3","McLaren","650S GT3 2015"]
[35,"Gr.1","McLaren","MCLAREN ULTIMATE VISION GRAN TURISMO GR.1"]
[36,"Gr.X","McLaren","MCLAREN ULTIMATE VISION GRAN TURISMO"]
[37,"N 200","Volkswagen","GOLF VII GTI 2014"]
[38,"Gr.4","Volkswagen","SCIROCCO GR.4"]
[39,"Gr.3","Volkswagen","GTI VISION GRAN TURISMO GR.3"]
[40,"Gr.3","Volkswagen","BEETLE GR.3"]
[41,"Gr.X","Volkswagen","GTI ROADSTER VISION GRAN TURISMO"]
[42,"Gr.X","Volkswagen","GTI SUPERSPORT VISION GRAN TURISMO"]
[43,"N 400","Mercedes-Benz","A 45 AMG 4MATIC 2013"]
[44,"N 500","Mercedes-Benz","MERCEDES-AMG GTS 2015"]
[45,"N 600","Mercedes-Benz","SLS AMG 2010"]
[46,"Gr.4","Mercedes-Benz","SLS AMG GR.4"]
[47,"Gr.3","Mercedes-Benz","SLS AMG GT3 2011"]
[48,"Gr.3","Mercedes-Benz","MERCEDES-AMG GT3 AMG-TEAM HTP-MOTORSPORT 2016"]
[49,"Gr.X","Mercedes-Benz","AMG VISION GRAN TURISMO"]
[50,"Gr.X","Mercedes-Benz","AMG VISION GRAN TURISMO RACING SERIES"]
[51,"Gr.X","BMW","i3 2015"]
[52,"N 400","BMW","BMW M4 COUPE 2014"]
[53,"Gr.4","BMW","BMW M4 GR.4"]
[54,"Gr.3","BMW","BMW Z4 GT3 2011"]
[55,"Gr.3","BMW","BMW M6 GT3 WALKENHORST MOTORSPORT 2016"]
[56,"Gr.3","BMW","BMW M6 GT3 M POWER LIVERY 2016"]
[57,"Gr.X","BMW","BMW VISION GRAN TURISMO"]
[58,"N 300","Audi","TTS COUPE 2014"]
[59,"Gr.4","Audi","TT CUP 2016"]
[60,"Gr.B","Audi","AUDI SPORT QUATTRO S1 PIKES PEAK 1987"]
[61,"Gr.3","Audi","R8 LMS AUDI SPORT TEAM WRT 2015"]
[62,"Gr.1","Audi","AUDI R18 TDI AUDI SPORT TEAM JOEST 2011"]
[63,"Gr.X","MINI","MINI CLUBMAN VISION GRAN TURISMO"]
[64,"N 500","Porsche","911 GT3 RS 2016"]
[65,"Gr.4","Porsche","CAYMAN GT4 CLUBSPORT 2016"]
[66,"Gr.3","Porsche","911 RSR 2017"]
[67,"Gr.1","Porsche","PORSCHE 919 HYBRID PORSCHE TEAM 2016"]
[68,"N 200","Renault Sport","CLIO R.S. 220 EDC TROPHY 2015"]
[69,"N 300","Renault Sport","MEGANE R.S. TROPHY 2011"]
[70,"Gr.4","Renault Sport","MEGANE GR.4"]
[71,"Gr.3","Renault Sport","R.S.01 GT3 2016"]
[72,"Gr.X","Renault Sport","R.S.01 2016"]
[73,"N 200","Peugeot","208 GTI BY PEUGEOT SPORT 2014"]
[74,"N 200","Peugeot","RCZ GT LINE 2015"]
[75,"Gr.4","Peugeot","RCZ GR.4"]
[76,"Gr.3","Peugeot","PEUGEOT VISION GRAN TURISMO GR.3"]
[77,"Gr.3","Peugeot","RCZ GR.3"]
[78,"Gr.B","Peugeot","RCZ GR.B RALLY CAR"]
[79,"Gr.1","Peugeot","PEUGEOT 908 HDI FAP TEAM PEUGEOT TOTAL 2010"]
[80,"Gr.1","Peugeot","PEUGEOT L750R HYBRID VISION GRAN TURISMO 2017"]
[81,"Gr.X","Peugeot","PEUGEOT VISION GRAN TURISMO"]
[82,"Gr.X","Peugeot","PEUGEOT L500R HYBRID VISION GRAN TURISMO 2017"]
[83,"N 200","Citroen","DS3 RACING 2011"]
[84,"N 500","Citroen","GT BY CITROEN ROAD CAR"]
[85,"Gr.4","Citroen","GT BY CITROEN GR.4"]
[86,"Gr.3","Citroen","GT BY CITROEN RACE CAR GR.3"]
[87,"Gr.1","Alpine","ALPINE VISION GRAN TURISMO 2017"]
[88,"Gr.X","Alpine","ALPINE VISION GRAN TURISMO"]
[89,"Gr.X","Alpine","ALPINE VISION GRAN TURISMO RACE MODE"]
[90,"Gr.4","Bugatti","VEYRON GR.4"]
[91,"Gr.1","Bugatti","BUGATTI VISION GRAN TURISMO GR.1"]
[92,"N1000","Bugatti","VEYRON 16.4 2013"]
[93,"Gr.X","Bugatti","BUGATTI VISION GRAN TURISMO"]
[94,"N 200","Alfa Romeo","MITO 1.4 T SPORT 2009"]
[95,"N 200","Alfa Romeo","4C LAUNCH EDITION 2014"]
[96,"Gr.4","Alfa Romeo","4C GR.4"]
[97,"Gr.3","Alfa Romeo","4C GR.3"]
[98,"N 600","Ferrari","458 ITALIA 2009"]
[99,"Gr.4","Ferrari","458 ITALIA GR.4"]
[100,"Gr.3","Ferrari","458 ITALIA GT3 2013"]
[101,"N1000","Ferrari","LA FERRARI 2013"]
[102,"N 600","Lamborghini","HURACAN LP 610-4 2015"]
[103,"Gr.4","Lamborghini","HURACAN GR.4"]
[104,"Gr.3","Lamborghini","HURACAN GT3 2015"]
[105,"N 800","Lamborghini","VENENO 2014"]
[106,"N 200","Toyota","86 GT 2015"]
[107,"N 100","Toyota","S-FR 2015"]
[108,"N 200","Toyota","86 GRMN 2016"]
[109,"N 400","Toyota","S-FR RACING CONCEPT 2016"]
[110,"Gr.4","Toyota","86 GR.4"]
[111,"Gr.3","Toyota","FT-1 VISION GRAN TURISMO GR.3"]
[112,"Gr.B","Toyota","86 GR.B RALLY CAR"]
[113,"Gr.1","Toyota","TS030 HYBRID 2012"]
[114,"Gr.1","Toyota","TS050 HYBRID TOYOTA GAZOO RACING 2016"]
[115,"Gr.X","Toyota","FT-1 VISION GRAN TURISMO"]
[116,"N 600","Nissan","GT-R PREMIUM EDITION 2017"]
[117,"Gr.4","Nissan","GT-R GR.4"]
[118,"Gr.3","Nissan","GT-R NISMO GT3 N24 SCHULZE MOTORSPORT 2013"]
[119,"Gr.B","Nissan","GT-R GR.B RALLY CAR"]
[120,"Gr.1","Nissan","GT-R LM NISMO 2015"]
[121,"Gr.X","Nissan","NISSAN CONCEPT 2020 VISION GRAN TURISMO"]
[122,"N 300","Honda","CIVIC TYPER 2015"]
[123,"Gr.X","Honda","HONDA PROJECT 2&4 POWERED BY RC213V"]
[124,"N 600","Honda","NSX 2017"]
[125,"Gr.4","Honda","NSX GR.4"]
[126,"Gr.3","Honda","NSX GR.3"]
[127,"Gr.B","Honda","NSX GR.B RALLY CAR"]
[128,"Gr.X","Honda","HONDA SPORTS VISION GRAN TURISMO"]
[129,"N 100","Mazda","ROADSTER S 2015"]
[130,"N 200","Mazda","ATENZA SEDAN XD L PACKAGE 2015"]
[131,"Gr.4","Mazda","ATENZA GR.4"]
[132,"Gr.3","Mazda","ATENZA GR.3"]
[133,"Gr.1","Mazda","LM55 VISION GRAN TURISMO GR.1"]
[134,"Gr.X","Mazda","LM55 VISION GRAN TURISMO"]
[135,"N 300","Subaru","WRX STI TYPES 2014"]
[136,"Gr.4","Subaru","WRX GR.4"]
[137,"Gr.3","Subaru","WRX GR.3"]
[138,"Gr.B","Subaru","WRX GR.B RALLY CAR"]
[139,"Gr.X","Subaru","VIZIV GT VISION GRAN TURISMO"]
[140,"N 300","Mitsubishi","LANCER EVOLUTION FINAL EDITION 2015"]
[141,"Gr.4","Mitsubishi","LANCER EVOLUTION FINAL EDITION GR.4"]
[142,"Gr.3","Mitsubishi","LANCER EVOLUTION FINAL EDITION GR.3"]
[143,"Gr.B","Mitsubishi","LANCER EVOLUTION FINAL EDITION GR.B RALLY CAR"]
[144,"Gr.X","Mitsubishi","CONCEPT XR-PHEV EVOLUTION VISION GRAN TURISMO"]
[145,"Gr.X","Daihatsu","DAIHATSU COPEN RJ VISION GRAN TURISMO"]
[146,"N 500","Lexus","RCF 2014"]
[147,"N 500","Lexus","LC500 2017"]
[148,"Gr.4","Lexus","RCF GR.4"]
[149,"Gr.3","Lexus","RCF GT3 PROTOTYPE EMIL FREY RACING 2016"]
[150,"Gr.X","Lexus","LF-LC GT VISION GRAN TURISMO"]
[151,"N 300","Hyundai","GENESIS COUPE 3.8 TRACK 2013"]
[152,"Gr.4","Hyundai","GENESIS GR.4"]
[153,"Gr.3","Hyundai","GENESIS GR.3"]
[154,"Gr.B","Hyundai","GENESIS GR.B RALLY CAR"]
[155,"Gr.1","Hyundai","HYUNDAI N 2025 VISION GRAN TURISMO GR.1"]
[156,"Gr.X","Hyundai","HYUNDAI N 2025 VISION GRAN TURISMO"]
[157,"N 500","Alfa Romeo","4C Gr.3 Road Car"]
[158,"Gr.X","BMW","BMW M4 Safety Car"]
[159,"N 500","Chevrolet","CORVETTE C7 Gr.3 ROAD CAR"]
[160,"N 500","Ford","MUSTANG Gr.3 ROAD CAR"]
[161,"Gr.X","Gran Turismo","Gran Turismo Racing Kart 125 Shifter"]
[162,"N 500","Mazda","ATENZA Gr.3 ROAD CAR"]
[163,"Gr.X","Mercedes-Benz","MERCEDES-AMG GT SAFETY CAR"]
[164,"N 500","Mitsubishi","LANCER EVOLUTION FINAL EDITION GR.B ROAD CAR"]
[165,"Gr.X","Nissan","GT-R SAFETY CAR"]
[166,"N 500","Subaru","WRX GR.B ROAD CAR"]
[167,"N 500","Peugeot","RCZ Gr.3 Road Car (N500)"]
[168,"Gr.1","Audi","R18 TDI Le Mans 2011"]
[169,"Gr.X","Zagato","IsoRivolta Zagato Vision Gran Turismo"]
[170,"Gr.1","Audi","R18 Audi Sport Team Joest 2016"]
[171,"N 500","Shelby","Cobra 427 1966"]
[172,"N 400","Ford","F-150 SVT RAPTOR 2011"]
[173,"N 300","Chevrolet","CORVETTE STINGRAY CONVERTIBLE 1969"]
[174,"N 300","KTM","X-BOW R 2012"]
[175,"N 400","Lamborghini","COUNTACH LP400 1974"]
[176,"N 500","Ferrari","F40 1992"]
[177,"N 700","Ferrari","ENZO FERRARI 2002"]
[178,"N 100","Volkswagen","SAMBABUS TYP2 1962"]
[179,"N 300","Mazda","RX-7 SPIRIT R TYPE A 2002"]
[180,"N 300","Nissan","SKYLINE GT-R V-SPEC II 1994"]
[181,"N 300","Nissan","SKYLINE GT-R V-SPEC II NUR 2002"]
[182,"N 100","Suzuki","SWIFT SPORT 2007"]
[183,"N 700","Gran Turismo","CHRIS HOLSTROM CONCEPTS 1967 CHEVY NOVA"]
[184,"N 500","Dodge","VIPER GTS 2002"]
[185,"Gr.X","Ferrari","330 P4 1967"]
[186,"N 400","Ferrari","512 BB 1976"]
[187,"N 600","Ford","FORD GT 2006"]
[188,"Gr.X","Jaguar","XJ13 1966"]
[189,"N 600","Lamborghini","DIABLO GT 2000"]
[190,"N 600","McLaren","MCLAREN F1 1994"]
[191,"N 200","Toyota","2000GT 1967"]
[192,"Gr.X","Toyota","FT-1 2014"]
[193,"N 300","Toyota","SUPRA RZ 1997"]
[194,"N 300","Alpine","A110 PREMIERE EDITION 2017"]
[195,"N 100","Alpine","A110 1600S 1972"]
[196,"N 400","Audi","R8 4.2 FSI R TRONIC 2007"]
[197,"N 300","De Tomaso","PANTERA 1971"]
[198,"N 400","Dodge","CHALLENGER R/T 1970"]
[199,"N 300","Ford","MUSTANG MACH 1 1971"]
[200,"Gr.X","Gran Turismo","F1500T-A"]
[201,"N 700","Lamborghini","AVENTADOR LP 700-4 2011"]
[202,"Gr.X","Subaru","WRX STI ISLE OF MAN TIME ATTACK CAR 2016"]
[203,"Gr.X","Subaru","FALKEN TIRE/ TURN 14 DISTRIBUTION BRZ 2017"]
[204,"N 300","Toyota","SUPRA 3.0GT TURBO A 1988"]
[205,"N 200","Toyota","MR2 GT-S 1997"]
[206,"N 400","Ford","GT40 MARK I 1966"]
[207,"N 600","Aston Martin","DB11 2016"]
[208,"N 200","BMW","BMW M3 SPORT EVOLUTION 1989"]
[209,"N 800","Gran Turismo","ECKERTS ROD & CUSTOM MACH FORTY"]
[210,"Gr.X","Gran Turismo","GRAN TURISMO RED BULL X2014 JUNIOR 2014"]
[211,"Gr.X","Gran Turismo","GRAN TURISMO RED BULL X2014 STANDARD 2014"]
[212,"Gr.2","Honda","RAYBRIG NSX CONCEPT-GT 2016"]
[213,"Gr.2","Lexus","AU TOM'S RCF 2016"]
[214,"Gr.3","Lexus","RC F GT3 EMIL FREY RACING 2017"]
[215,"N 200","Mazda","RX-7 GT-X 1990"]
[216,"N 600","Nissan","GT-R NISMO 2017"]
[217,"N 300","Nissan","SKYLINE GT-R V-SPEC 1997"]
[218,"Gr.2","Nissan","M0TUL AUTECH GT-R 2016"]
[219,"Gr.1","Audi","AUDI VISION GRAN TURISMO"]
[220,"Gr.X","Audi","AUDI E-TRON VISION GRAN TURISM0"]
[221,"Gr.3","Toyota","GR Supra Racing Concept 2018"]
[222,"Gr.1","Jaguar","XJR-9 1988"]
[223,"N 200","Renault Sport","CLIO R.S. 220 EDC TROPHY 2016"]
[224,"Gr.4","Renault Sport","MEGANE TROPHY 2011"]
[225,"N 400","Lamborghini","MIURA P400 BERTONE PROTOTYPE CN.0706 1967"]
[226,"N 100","Fiat","500 F 1968"]
[227,"Gr.1","Mercedes-Benz","SAUBER MERCEDES C9 1989"]
[228,"Gr.1","Nissan","R92CP 1992"]
[229,"N 200","Subaru","BRZS 2015"]
[230,"N 300","Mitsubishi","LANCER EVOLUTION IV GSR 1996"]
[231,"Gr.3","Ford","FORD GT LM SPEC II TEST CAR"]
[232,"N 100","Daihatsu","COPEN ACTIVE TOP 2002"]
[233,"N 100","Honda","BEAT 1991"]
[234,"N 100","Honda","S660 2015"]
[235,"Gr.1","Mazda","MAZDA 787B 1991"]
[236,"Gr.X","Ferrari","250 GTO CN.3729GT 1962"]
[237,"Gr.X","Mercedes-Benz","MERCEDES-AMG F1 W08 EQ POWER+ 2017"]
[238,"Gr.X","Mercedes-Benz","MERCEDES-AMG F1 W08 EQ POWER+ COLOR VARIATION 2017"]
[239,"Gr.X","Ford","MARK IV RACE CAR 1967"]
[240,"Gr.X","Shelby","COBRA DAYTONA COUPE 1964"]
[241,"N 100","Volkswagen","VOLKSWAGEN 1200 1966"]
[242,"N 100","MINI","MINI-COOPER'S' 1965"]
[243,"N 100","Abarth","500 2009"]
[244,"N 100","Abarth","1500 BIPOSTO BERTONE B.A.T 1 1952"]
[245,"N 200","Lancia","DELTA HF INTEGRALE EVOLUZIONE 1991"]
[246,"N 600","Gran Turismo","AMUSE S2000 GT1 TURBO Car Concept by GRAN TURISMO"]
[247,"Gr.X","Alfa Romeo","Giulia TZ2 Carrozzata da Zagato CN.AR750106 1965"]
[248,"Gr.3","BMW","M3 GT BMW Motorsport 2011"]
[249,"N 500","Dodge","Viper SRT10 Coupe 2006"]
[251,"N 300","Honda","NSX Type R 1992"]
[252,"N 300","Mazda","RX500 1970"]
[253,"N 300","Nissan","Fairlady Z 300ZX Twin Turbo 2 Seater 1989"]
[254,"N 300","Plymouth","XNR Ghia Roadster 1960"]
[255,"N 400","Porsche","911 GT3 (997) 2009"]
[256,"N 400","Porsche","911 GT3 (996) 2001"]
[257,"N 400","Ferrari","GTO 1984"]
[258,"N 400","Maserati","Gran Turismo S 2008"]
[259,"Gr.X","Pagani","Zonda R 2009"]
[260,"Gr.2","Honda","EPSON NSX 2008"]
[261,"Gr.2","Lexus","PETRONAS TOM'S SC430 2008"]
[262,"Gr.2","Nissan","XANAVI NISMO GT-R 2008"]
[263,"N 300","Jaguar","E-type Coupé 1961"]
[264,"N 200","MINI","Mini Cooper S 2005"]
[265,"N 300","Subaru","Impreza 22B-STi Version 1998"]
[266,"N 400","Chevrolet","Corvette Sting Ray Sport Coupe 1963"]
[267,"N 200","Pontiac","Firebird Trans Am 1978"]
[268,"Gr.X","Tesla Motors","Model S Signature Performance 2012"]
[269,"N 400","BMW","M3 Coupe 2007"]
[270,"N 500","Ferrari","F50 1995"]
[271,"Gr.X","McLaren","P1 GTR 2016"]
[272,"N 300","Gran Turismo","Greddy Fugu Z 2015"]
[273,"N 300","Shelby","G.T.350 1965"]
[274,"Gr.X","Aston Martin","DB3S CN.1 1953"]
[275,"N 400","BMW","BMW Z8 2001"]
[276,"N 200","Ferrari","Dino 246 GT 1971"]
[277,"N 100","Porsche","356 A/1500 GS GT Carrera Speedster 1956"]
[278,"N 400","TVR","Tuscan Speed 6 2000"]
[279,"N 200","Honda","Integra Type R (DC2) 1998"]
[280,"N 300","Nissan","Fairlady Z Version S (Z33) 2007"]
[281,"N 100","Mazda","Mazda Eunos Roadster (NA Special Package) 1989"]
[282,"N 300","Toyota","GR Supra RZ 2019"]
[283,"Gr.3","McLaren","F1 GTR - BMW (Kokusai Kaihatsu UK Racing) 1995"]
[284,"N 700","Pagani","Huayra 2013"]
[285,"N 600","Mercedes-Benz","SLR McLaren 2009"]
[286,"N 300","Ferrari","250 GT BERLINETTA PASSO CORTO CN.2521 1961"]
[287,"N 500","Lamborghini","COUNTACH 25TH ANNIVERSARY 1988"]
[288,"N 200","Lancia","STRATOS 1973"]
[289,"Gr.X","Super Formula","DALLARA SF19 SUPER FORMULA/TOYOTA 2019"]
[290,"Gr.X","Super Formula","DALLARA SF19 SUPER FORMULA/HONDA 2019"]
[291,"N 200","Audi","TT COUPE 3.2 QUATTRO 2003"]
[292,"N 100","Honda","FIT HYBRID 2014"]
[293,"Gr.1","Porsche","962 C 1988"]
[294,"Gr.X","Renault","R8 GORDINI 1966"]
[295,"N 100","Toyota","SPRINTER TRUENO 3DOOR 1600GT APEX (AE86) 1983"]
[296,"Gr.X","Gran Turismo","RED BULL X2019 COMPETITION"]
[297,"N 200","Renault Sport","CLIO V6 24V 2000"]
[298,"N 300","Chevrolet","CAMARO Z28 1969"]
[299,"N 400","Toyota","TUNDRA TRD PRO 2019"]
[300,"N 100","Toyota","SPORTS 800 1965"]
[301,"N 100","Honda","S800 1966"]
[302,"N 200","Honda","CIVIC TYPE R 1998"]
[303,"Gr.X","Jaguar","D-TYPE 1954"]
[304,"N 200","Mazda","ROADSTER TOURING CAR"]
[305,"N 300","Porsche","911 TURBO 1981"]
[306,"N 300","Subaru","IMPREZA COUPE WRX TYPE R STI VERSION VI 1999"]
[307,"N 300","Mitsubishi","GTO TWIN TURBO 1991"]
[308,"N 100","Toyota","COROLLA LEVIN 3DOOR 1600GT APEX (AE86) 1983"]
[309,"N 200","Nissan","SILVIA K'S DIA SELECTION (S13) 1990"]
[310,"N 200","Honda","S2000 1999"]
[311,"Gr.X","Chevrolet","CORVETTE STINGRAY RACER CONCEPT 1959"]
[312,"N 700","Chevrolet","CAMARO ZL1 1LE PACKAGE 2018"]
[313,"N 300","Dodge","SUPER BEE 1970"]
[314,"N 400","Ferrari","365 GTB4 1971"]
[315,"Gr.X","Porsche","TAYCAN TURBO S 2019"]
[316,"Gr.X","Mercedes-Benz","300 SEL 6.8 AMG 1971"]
[317,"N 100","Mazda","DEMIO XD TOURING 2015"]
[318,"N 800","Lamborghini","AVENTADOR LP-750 SUPERVELOCE 2015"]
[319,"Gr.X","Jaguar","VISION GRAN TURISMO COUPE"]
[320,"N 200","Toyota","86 GT LIMITED 2016"]
[321,"N 400","RE Amemiya","FD3S RX-7"]
[322,"N 300","BMW","M3 COUPE 2003"]
[323,"N 700","RUF","CTR3 2007"]
[324,"Gr.X","Mercedes-Benz","AMG Vision Gran Turismo LH Edition"]
[325,"Gr.4","Toyota","GR SUPRA (Nürburgring '19 Livery)"]
[326,"Gr.X","Dodge","CHARGER SRT HELLCAT SAFETY CAR"]
[327,"N 700","Ford","GT 2017"]
[328,"N 300","Porsche","911 CARRERA RS CLUB SPORT 1995"]
[329,"Gr.X","Renault","MEGANE RS TROPHY SAFETY CAR"]
[330,"N 300","Toyota","CROWN ATHLETE G 2013"]
[331,"Gr.X","Toyota","CROWN ATHLETE G SAFETY CAR"]
[332,"N 100","Volkswagen","GOLF I GTI 1983"]
[333,"N 200","Nissan","180SX TYPE X 1996"]
[334,"N 100","Fiat","500 1.2 8V LOUNGE SS 2008"]
[335,"Gr.3","Aston Martin","DBR9 GT1 2010"]
[336,"N 400","Toyota","GR SUPRA RZ 2020"]
[337,"Gr.3","Mazda","RX VISION GT3"]
[338,"N 300","Toyota","GR YARIS 1ST EDITION RZ HIGH PERFORMANCE 2020"]
[339,"N 200","Toyota","GR 86 '21","2021-07-08"]

{"sheet":"Transmissions","index":10,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[34,1,35,8],[36,1,37,2],[36,5,37,6],[36,9,37,10],[36,13,44,18],[38,11,40,12],[44,11,44,12],[46,11,46,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[5,13,7,18],[8,13,13,18],[14,13,18,18],[20,1,21,8],[22,1,23,2],[22,13,27,18],[24,7,25,8],[24,11,25,12],[26,7,32,8],[26,11,32,12],[16,1,16,2],[17,1,17,2],[16,5,16,6],[16,9,16,10],[1,1,1,12],[3,1,4,8],[5,1,6,2],[5,5,6,6],[5,9,6,10]]}
[]
[null,"Les différents types de transmission "]
[]
[null,"  PROPULSION"]
[]
[null,"RR",null,null,null,"FR",null,null,null,"MR",null,null,null,"RR : Très rares dans GTS, ces voitures ont à la fois un moteur et des roues motrices à l'arrière. Leur conduite n'est pas des plus évidentes et demande un temps d'adaptation."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"FR : Le moteur de ces voitures, appelées des propulsions, est situé à l'avant et ce sont les roues de derrière qui sont motrices.\nCes voitures ont généralement une très bonne accélération et une vitesse de pointe très élevée…"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"MR : Le moteur est au centre de la voiture et les roues arrière sont motrices. La plupart des F1 de GTS sont équipées ainsi. L'emplacement du moteur permet une excellente répartition de poids dans la voiture. De plus, le fait de ne pas avoir de moteur devant permet de modeler un profil aérodynamique à la voiture."]
[]
[null,"Moteur à l'arrière",null,null,null,"Moteur à l'avant",null,null,null,"Moteur central"]
[null,"(conduite difficile)",null,null,null,null,null,null,null,"Bonne répartition du poids"]
[]
[]
[null,"  TRACTION"]
[]
[null,"FF",null,null,null,null,null,null,null,null,null,null,null,"FF : Moteur et roues motrices à l'avant. Ces voitures sont sans doute les plus lentes. Ce sont aussi les plus courantes dans la vie de tous les jours.\nLe poids étant concentré au dessus des roues motrices, cela accentue la traction.\nCe type de transmission est utilisé pour les rallyes car il est très stable."]
[]
[null,null,null,"Moteur à l'avant"]
[null,null,null,"(véh. Léger)"]
[null,null,null,"Bonne motricitée"]
[null,null,null,"Usure rapide des pneus AV"]
[]
[]
[]
[]
[]
[]
[null,"  4 ROUES MOTRICES"]
[]
[null,"4WD",null,null,null,"4RM",null,null,null,"AWD",null,null,null,"4WD; 4RM; AWD : Habituellement, le moteur de ce type de voiture est monté vers l'avant, mais il se peut aussi que dans de rares cas, il soit monté au centre, voire à l'arrière de la voiture.\nComme le nom l'indique, les roues de ces voitures sont motrices. Il en résulte une meilleure tenue de route et une bonne traction (la plupart des voitures de Rallye sont d'ailleurs équipées de la sorte).\nCependant, ces voitures sont plus lourdes à cause justement du poids de l'équipement supplémentaire. Elles demandent aussi une conduite plus technique."]
[]
[]
[null,null,null,"Moteur à l'avant"]
[null,null,null,null,null,null,null,"Moteur central"]
[null,null,null,null,null,null,null,null,null,null,null,"Moteur à l'arrière"]

{"sheet":"grille","index":11,"n_rows":102,"n_cols":14,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[]
["nbrtours","pneu","pneu1","usure","conso","météo","fuel","éco2","pneu2","frein",null,null,null,"pneu3"]
[{"$f":"chronos!G12","v":0},"S soft","S soft","X1","X1","beau temps",0,0,"libre",5,null,null,null,{"$f":"'Strat 1'!G11","v":0}]
[{"$f":"chronos!J12","v":0},"soft","soft","X2","X2","ensoleillé",0.5,"tr/mn 2/3","obligatoire",4,null,null,null,{"$f":"'Strat 1'!K11","v":0}]
[{"$f":"chronos!M12","v":0},"médium","médium","X3","X3","nuageux",1,"tr/mn 1/2",null,3,null,null,null,{"$f":"'Strat 1'!O11","v":0}]
[null,"hard","hard","X4","X4","tombé nuit",1.5,"tr/mn 1/3",null,2]
[null,"sans","inter","X5","X5","nuit",2,2,null,1]
[null,"inter","pluie","X6","X6","levé du jour",3,3,null,0]
[null,"pluie",null,"X7","X7","humide",4,4,null,-1]
[null,null,null,"X8","X8","pluvieux",5,5,null,-2]
[null,null,null,"X9","X9","pluie",6,6,null,-3]
[null,null,null,"X10","X10","x",null,null,null,-4]
[null,null,null,"X11","X11",null,null,null,null,-5]
[null,null,null,"X12","X12"]
[null,null,null,"X13","X13"]
[null,null,null,"X14","X14"]
[null,null,null,null,null,null,null,null,null,null,"circuits","distance","corner"]
[null,null,null,null,null,null,null,null,null,null,"Alsace - Village",5.423,17]
[null,null,null,null,null,null,null,null,null,null,"Alsace - Village II",5.423,17]
[null,null,null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - GP",5.8090000000000002,17]
[null,null,null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - GP II",5.8090000000000002,17]
[null,null,null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Centre",1.706,9]
[null,null,null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Centre II",1.706,9]
[null,null,null,null,null,null,null,null,null,null,"Autodrome Lago Maggiore - Est",3.6429999999999998,13]
["edp","dépaart","dégat","pénalité",null,null,null,null,null,null,"Autodrome Lago Maggiore - Est II",3.6429999999999998,13]
["EDP sans","départ grille","dégât sans","sans",null,null,null,null,null,null,"Autodrome Lago Maggiore - Ouest",4.1680000000000001,13]
["EDP avec","départ lancé","dégât faible","faible",null,null,null,null,null,null,"Autodrome Lago Maggiore - Ouest II",4.1680000000000001,13]
[null,null,"dégât fort","forte",null,null,null,null,null,null,"Autódromo De Interlagos",4.3090000000000002,15]
[null,null,null,null,null,null,null,null,null,null,"Autodromo Nazionale Monza",5.7930000000000001,11]
[null,null,null,null,null,null,null,null,null,null,"Autodromo Nazionale Monza - sans chicane",5.7549999999999999,9]
[null,null,null,null,null,null,null,null,null,null,"Autopolis International Racing Course",4.67,19]
[null,null,null,null,null,null,null,null,null,null,"Autopolis International Racing Course - Court",3.02,12]
[null,null,null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway",3.2,3]
[null,null,null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway II",3.2,3]
[null,null,null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central A",3.35,10]
[null,null,null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central A II",3.35,10]
[null,null,null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central B",2.86,7]
[null,null,null,null,null,null,null,null,null,null,"Blue Moon Bay Speedway - Central B II",2.86,7]
[null,null,null,null,null,null,null,null,null,null,"Brands Hatch Grand Prix Circuit",3.9460000000000002,9]
[null,null,null,null,null,null,null,null,null,null,"Brands Hatch Indy Circuit",1.929,6]
[null,null,null,null,null,null,null,null,null,null,"BB Raceway",1.665,4]
[null,null,null,null,null,null,null,null,null,null,"BB Raceway II",1.665,4]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Barcelona-Catalunya version GP",4.6550000000000002,13]
[null,null,null,null,null,null,null,null,null,null,"Circuit de la Sarthe",13.625999999999999,38]
[null,null,null,null,null,null,null,null,null,null,"Circuit de la Sarthe (Sans chicane)",13.625999999999999,36]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - A",9.4770000000000003,20]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - A II",9.4770000000000003,20]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - B",7.0620000000000003,16]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - B II",7.0620000000000003,16]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - C",10.824999999999999,23]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Sainte-Croix - C II",10.824999999999999,26]
[null,null,null,null,null,null,null,null,null,null,"Circuit de Spa-Francorchamps",7.0039999999999996,20]
[null,null,null,null,null,null,null,null,null,null,"Colorado Springs - Lac",2.99,15]
[null,null,null,null,null,null,null,null,null,null,"Colorado Springs - Lac II",2.99,15]
[null,null,null,null,null,null,null,null,null,null,"Dragon Trail - Littoral",5.2089999999999996,17]
[null,null,null,null,null,null,null,null,null,null,"Dragon Trail - Littoral II",5.2089999999999996,17]
[null,null,null,null,null,null,null,null,null,null,"Dragon Trail - Jardins",4.3520000000000003,16]
[null,null,null,null,null,null,null,null,null,null,"Dragon Trail - Jardins II",4.3520000000000003,16]
[null,null,null,null,null,null,null,null,null,null,"Fishermans Ranch",6.8929999999999998,40]
[null,null,null,null,null,null,null,null,null,null,"Fishermans Ranch II",6.8929999999999998,40]
[null,null,null,null,null,null,null,null,null,null,"Fuji International Speedway",4.5629999999999997,16]
[null,null,null,null,null,null,null,null,null,null,"Fuji International Speedway - Court",4.5259999999999998,15]
[null,null,null,null,null,null,null,null,null,null,"Goodwood Motor Circuit",3.8090000000000002,7]
[null,null,null,null,null,null,null,null,null,null,"Kyoto Driving Park - Miyabi",1.9530000000000001,7]
[null,null,null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa",4.9119999999999999,15]
[null,null,null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa II",4.9119999999999999,15]
[null,null,null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa+Miyabi",6.8460000000000001,20]
[null,null,null,null,null,null,null,null,null,null,"Kyoto Driving Park - Yamagiwa+Miyabi II",6.8460000000000001,20]
[null,null,null,null,null,null,null,null,null,null,"Mount Panorama Motor Racing Circuit",6.2130000000000001,22]
[null,null,null,null,null,null,null,null,null,null,"Northern Isle Speedway",0.9,2]
[null,null,null,null,null,null,null,null,null,null,"Northern Isle Speedway – Infield",0.9,2]
[null,null,null,null,null,null,null,null,null,null,"Nürburgring 24 Heures",25.378,170]
[null,null,null,null,null,null,null,null,null,null,"Nürburgring GP",5.1479999999999997,16]
[null,null,null,null,null,null,null,null,null,null,"Nürburgring Nordschleife",20.832000000000001,154]
[null,null,null,null,null,null,null,null,null,null,"Nürburgring Nordschleife - Tracé visiteurs",20.832000000000001,154]
[null,null,null,null,null,null,null,null,null,null,"Red Bull Ring",4.3179999999999996,10]
[null,null,null,null,null,null,null,null,null,null,"Red Bull Ring - Court",2.3359999999999999,6]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Éoliennes",3.31,14]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Éoliennes II",3.31,14]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Piste A",5.1130000000000004,15]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Piste A II",5.1130000000000004,15]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Piste B",3.8929999999999998,15]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Piste B II",3.8929999999999998,15]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Piste C",2.661,15]
[null,null,null,null,null,null,null,null,null,null,"Sardegna - Piste C II",2.661,15]
[null,null,null,null,null,null,null,null,null,null,"Special Stage Route X",30.283000000000001,4]
[null,null,null,null,null,null,null,null,null,null,"Suzuka Circuit",5.8079999999999998,17]
[null,null,null,null,null,null,null,null,null,null,"Suzuka Circuit - Course Est",2.2429999999999999,6]
[null,null,null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle intérieure centrale",4.3689999999999998,12]
[null,null,null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle extérieure centrale",4.4050000000000002,12]
[null,null,null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle intérieure Est",7.1920000000000002,12]
[null,null,null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle extérieure Est",7.3010000000000002,12]
[null,null,null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle extérieure Sud",6.56,16]
[null,null,null,null,null,null,null,null,null,null,"Tokyo Expressway - Boucle intérieure Sud",5.2009999999999996,17]
[null,null,null,null,null,null,null,null,null,null,"Tsukuba Circuit",2.0449999999999999,14]
[null,null,null,null,null,null,null,null,null,null,"WeatherTech Raceway Laguna Seca",3.6,12]
[null,null,null,null,null,null,null,null,null,null,"Willow Springs - Big Willow",3.9510000000000001,9]
[null,null,null,null,null,null,null,null,null,null,"Willow Springs - Horse Thief Mile",1.6240000000000001,12]
[null,null,null,null,null,null,null,null,null,null,"Willow Springs - Horse Thief Mile II",1.6240000000000001,12]
[null,null,null,null,null,null,null,null,null,null,"Willow Springs - Streets of Willow Springs",2.6749999999999998,14]
[null,null,null,null,null,null,null,null,null,null,"Willow Springs - Streets of Willow Springs II",2.6749999999999998,14]

{"sheet":"grille2","index":12,"n_rows":371,"n_cols":5,"rows_kept":371,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"catégories",null,"Voitures"]
[null,"GR1_",null,"GR1"]
[null,"GR2_",null,"Alpine VGT 2017"]
[null,"GR3_",null,"Audi Audi VGT"]
[null,"GR4_",null,"Audi R18 (Audi Sport Team Joest) '16"]
[null,"GRB",null,"Audi R18 TDI (Audi Sport Team Joest) '11"]
[null,"GRX",null,"Audi R18 TDI (Le Mans 2011)"]
[null,"N1000_",null,"Bugatti VGT (Gr.1)"]
[null,"N100_",null,"Dodge SRT Tomahawk VGT (Gr.1)"]
[null,"N200_",null,"Hyundai HYUNDAI N 2025 VGT (Gr.1)"]
[null,"N300_",null,"Jaguar XJR-9 '88"]
[null,"N400_",null,"Mazda 787B '91"]
[null,"N500_",null,"Mazda LM55 VGT (Gr.1)"]
[null,"N600_",null,"McLaren Ultimate VGT (Gr.1)"]
[null,"N700_",null,"Mercedes-Benz Sauber Mercedes C9 '89"]
[null,"N800_",null,"Nissan GT-R LM NISMO '15"]
[null,null,null,"Nissan R92CP '92"]
[null,null,null,"Peugeot 908 HDi FAP - Team Peugeot Total '10"]
[null,null,null,"Peugeot L750R HYbrid VGT 2017"]
[null,null,null,"Porsche 919 Hybrid (Porsche Team) '16"]
[null,null,null,"Porsche 962 C '88"]
[null,null,null,"Toyota TS030 Hybrid '12"]
[null,null,null,"Toyota TS050 - Hybrid (Toyota Gazoo Racing) '16"]
[]
[null,null,null,"GR2"]
[null,null,null,"Honda ESPON NSX '08"]
[null,null,null,"Honda RAYBRIG NSX CONCEPT-GT '16"]
[null,null,null,"Lexus au TOM'S RC F '16"]
[null,null,null,"Lexus PETRONAS TOM'S SC430 '08"]
[null,null,null,"Nissan MOTUL AUTECH GT-R '16"]
[null,null,null,"Nissan XANAVI NISMO GT-R '08"]
[]
[null,null,null,"GR3"]
[null,null,null,"Alfa Romeo 4C Gr.3"]
[null,null,null,"Aston Martin DBR9 GT1 '10"]
[null,null,null,"Aston Martin V12 Vantage GT3 '12"]
[null,null,null,"Audi R8 LMS (Audi Sport Team WRT) '15"]
[null,null,null,"BMW M3 GT (BMW Motorsport) '11"]
[null,null,null,"BMW M6 GT3 (Walkenhorst Motorsport) '16"]
[null,null,null,"BMW M6 GT3 M Power Livery '16"]
[null,null,null,"BMW Z4 GT3 '11"]
[null,null,null,"Chevrolet Corvette C7 Gr.3"]
[null,null,null,"Citroën GT by Citroën Race Car (Gr.3)"]
[null,null,null,"Dodge Viper SRT GT3-R '15"]
[null,null,null,"Ferrari 458 Italia GT3 '13"]
[null,null,null,"Ford GT LM Spec II Test Car"]
[null,null,null,"Ford Mustang Gr.3"]
[null,null,null,"Honda NSX Gr.3"]
[null,null,null,"Hyundai Genesis Gr.3"]
[null,null,null,"Jaguar F-type Gr.3"]
[null,null,null,"Lamborghini Huracàn GT3 '15"]
[null,null,null,"Lexus RC F GT3 (Emil Frey Racing) '17"]
[null,null,null,"Lexus RC F GT3 prototype (Emil Frey Racing) '16"]
[null,null,null,"Mazda Atenza Gr.3"]
[null,null,null,"Mazda RX-VISION GT3 CONCEPT"]
[null,null,null,"McLaren 650S GT3 '15"]
[null,null,null,"McLaren F1 GTR - BMW '95"]
[null,null,null,"Mercedes-Benz -AMG GT GT3 '16"]
[null,null,null,"Mercedes-Benz SLS AMG GT3 '11"]
[null,null,null,"Mitsubishi Lancer Evolution Final Edition Gr.3"]
[null,null,null,"Nissan GT-R NISMO GT3 N24 Schulze Motorsport '13"]
[null,null,null,"Peugeot VGT (Gr.3)"]
[null,null,null,"Peugeot RCZ Gr.3"]
[null,null,null,"Porsche 911 RSR (991) '17"]
[null,null,null,"Renault Sport R.S.01 GT3 '16"]
[null,null,null,"Subaru WRX Gr.3"]
[null,null,null,"Toyota FT-1 VGT (Gr.3)"]
[null,null,null,"Toyota GR Supra Racing Concept '18"]
[null,null,null,"Volkswagen Beetle Gr.3"]
[null,null,null,"Volkswagen GTI VGT (Gr.3)"]
[]
[null,null,null,"GR4"]
[null,null,null,"Alfa Romeo 4C Gr.4"]
[null,null,null,"Aston Martin Vantage Gr.4"]
[null,null,null,"Audi TT Cup '16"]
[null,null,null,"BMW M4 Gr.4"]
[null,null,null,"Bugatti Veyron Gr.4"]
[null,null,null,"Chevrolet Corvette C7 Gr.4"]
[null,null,null,"Citroën GT by Citroën Gr.4"]
[null,null,null,"Dodge Viper Gr.4"]
[null,null,null,"Ferrari 458 Italia Gr.4"]
[null,null,null,"Ford Mustang Gr.4"]
[null,null,null,"Honda NSX Gr.4"]
[null,null,null,"Hyundai Genesis Gr.4"]
[null,null,null,"Jaguar F-type Gr.4"]
[null,null,null,"Lamborghini Huracàn Gr.4"]
[null,null,null,"Lexus RC F Gr.4"]
[null,null,null,"Mazda Atenza Gr.4"]
[null,null,null,"McLaren 650S Gr.4"]
[null,null,null,"Mercedes-Benz SLS AMG Gr.4"]
[null,null,null,"Mitsubishi Lancer Evolution Final Edition Gr.4"]
[null,null,null,"Nissan GT-R Gr.4"]
[null,null,null,"Peugeot RCZ Gr.4"]
[null,null,null,"Porsche Cayman GT4 Clubsport '16"]
[null,null,null,"Renault Sport Mégane Gr.4"]
[null,null,null,"Renault Sport Mégane Trophy '11"]
[null,null,null,"Subaru WRX Gr.4"]
[null,null,null,"Toyota 86 Gr.4"]
[null,null,null,"Toyota GR Supra (Nürburgring '19 Livery)"]
[null,null,null,"Volkswagen Scirocco Gr.4"]
[]
[null,null,null,"GRB"]
[null,null,null,"Audi Sport quattro S1 Pikes Peak '87"]
[null,null,null,"Ford Focus Gr.B Rally Car"]
[null,null,null,"Ford Mustang Gr.B Rally Car"]
[null,null,null,"Honda NSX Gr.B Rally Car"]
[null,null,null,"Hyundai Genesis Gr.B Rally Car"]
[null,null,null,"Mitsubishi Lancer Evolution Final Edition Gr.B Rally Car"]
[null,null,null,"Nissan GT-R Gr.B Rally Car"]
[null,null,null,"Peugeot RCZ Gr.B Rally Car"]
[null,null,null,"Subaru WRX Gr.B Rally Car"]
[null,null,null,"Toyota 86 Gr.B Rally Car"]
[]
[null,null,null,"GRX"]
[null,null,null,"Alfa Romeo GIULIA TZ2 CN.AR750106 '65"]
[null,null,null,"Alpine VGT"]
[null,null,null,"Alpine VGT Race Mode"]
[null,null,null,"Aston Martin DP-100 VGT"]
[null,null,null,"Aston Martin DB3S CN.1 '53"]
[null,null,null,"Audi e-tron VGT"]
[null,null,null,"BMW VGT"]
[null,null,null,"BMW i3 '15"]
[null,null,null,"BMW M4 Safety Car"]
[null,null,null,"Bugatti Bugatti VGT"]
[null,null,null,"Chaparral Chevrolet Chaparral 2X VGT"]
[null,null,null,"Chevrolet Corvette StingRay Racer Concept '59"]
[null,null,null,"Daihatsu DAIHATSU COPEN RJ VGT"]
[null,null,null,"Dodge Charger SRT Hellcat Safety Car"]
[null,null,null,"Dodge SRT Tomahawk GTS-R VGT"]
[null,null,null,"Dodge SRT Tomahawk S VGT"]
[null,null,null,"Dodge SRT Tomahawk X VGT"]
[null,null,null,"Ferrari 250 GTO CN.3729GT '62"]
[null,null,null,"Ferrari 330 P4 '67"]
[null,null,null,"Fittipaldi Motors Fittipaldi EF7 VGT"]
[null,null,null,"Ford Mark IV Race Car '67"]
[null,null,null,"Gran Turismo F1500T-A"]
[null,null,null,"Gran Turismo Racing Kart 125 Shifter"]
[null,null,null,"Gran Turismo Red Bull X2014 Junior"]
[null,null,null,"Gran Turismo Red Bull X2014 Standard"]
[null,null,null,"Gran Turismo Red Bull X2019 Competition"]
[null,null,null,"Honda Sports VGT"]
[null,null,null,"Honda Project 2&4 powered by RC213V"]
[null,null,null,"Hyundai HYUNDAI N 2025 VGT"]
[null,null,null,"Infiniti INFINITI CONCEPT VGT"]
[null,null,null,"Jaguar D-type '54"]
[null,null,null,"Jaguar VGT Coupé"]
[null,null,null,"Jaguar XJ13"]
[null,null,null,"Lexus LF-LC GT VGT"]
[null,null,null,"Mazda LM55 VGT"]
[null,null,null,"McLaren P1 GTR '16"]
[null,null,null,"McLaren Ultimate VGT"]
[null,null,null,"Mercedes-Benz 300 SEL 6.8 AMG '71"]
[null,null,null,"Mercedes-Benz AMG VGT LH Edition"]
[null,null,null,"Mercedes-Benz F1 W08 EQ Power+ (Color Variation) 2017"]
[null,null,null,"Mercedes-Benz F1 W08 EQ Power+ 2017"]
[null,null,null,"Mercedes-Benz-AMG GT Safety Car"]
[null,null,null,"Mercedes-Benz -Benz AMG VGT"]
[null,null,null,"Mercedes-Benz-Benz AMG VGT Racing Series"]
[null,null,null,"Mini MINI Clubman VGT"]
[null,null,null,"Mitsubishi Concept XR-PHEV EVOLUTION VGT"]
[null,null,null,"Nissan GT-R Safety Car"]
[null,null,null,"Nissan CONCEPT 2020 VGT"]
[null,null,null,"Pagani Zonda R '09"]
[null,null,null,"Peugeot L500R HYbrid VGT 2017"]
[null,null,null,"Peugeot VGT"]
[null,null,null,"Porsche Taycan Turbo S '19"]
[null,null,null,"Renault R8 Gordini '66"]
[null,null,null,"Renault Sport Mégane R.S. Trophy Safety Car"]
[null,null,null,"Renault Sport R.S.01 '16"]
[null,null,null,"Shelby Cobra Daytona Coupé '64"]
[null,null,null,"Subaru Falken Tire / Turn 14 Distribution BRZ '17"]
[null,null,null,"Subaru VIZIV GT VGT"]
[null,null,null,"Subaru WRX STI Isle Of Man Time Attack Car '16"]
[null,null,null,"Super Formula SF19 / Honda '19"]
[null,null,null,"Super Formula SF19 / Toyota '19"]
[null,null,null,"Tesla Motors Model S Signature Performance '12"]
[null,null,null,"Toyota Crown Athlete G Safety Car"]
[null,null,null,"Toyota FT-1"]
[null,null,null,"Toyota FT-1 VGT"]
[null,null,null,"Volkswagen GTI Roadster VGT"]
[null,null,null,"Volkswagen GTI Supersport VGT"]
[null,null,null,"Zagato IsoRivolta Zagato VGT"]
[]
[null,null,null,"N1000"]
[null,null,null,"Bugatti Veyron 16.4 '13"]
[null,null,null,"Ferrari LaFerrari '13"]
[]
[null,null,null,"N100"]
[null,null,null,"Abarth 1500 Biposto Bertone B.A.T 1 '52"]
[null,null,null,"Abarth 500 '09"]
[null,null,null,"Alpine A110 1600S '72"]
[null,null,null,"Daihatsu Copen '02"]
[null,null,null,"Fiat 500 1.2 8V Lounge SS '08"]
[null,null,null,"Fiat 500 F '68"]
[null,null,null,"Honda Beat '91"]
[null,null,null,"Honda Fit Hybrid '14"]
[null,null,null,"Honda S660 '15"]
[null,null,null,"Honda S800 '66"]
[null,null,null,"Mazda Demio XD Touring '15"]
[null,null,null,"Mazda Eunos Roadster (NA) '89"]
[null,null,null,"Mazda Roadster S (ND) '15"]
[null,null,null,"Mini Mini-Cooper 'S' '65"]
[null,null,null,"Porsche 356 A/1500 GS GT Carrera Speedster '56"]
[null,null,null,"Suzuki SWIFT Sport '07"]
[null,null,null,"Toyota Corolla Levin 1600GT APEX (AE86) '83"]
[null,null,null,"Toyota S-FR '15"]
[null,null,null,"Toyota Sports 800 '65"]
[null,null,null,"Toyota Sprinter Trueno 1600GT APEX (AE86) '83"]
[null,null,null,"Volkswagen Golf I GTI '83"]
[null,null,null,"Volkswagen Sambabus Typ 2 (T1) '62"]
[null,null,null,"Volkswagen 1200 '66"]
[]
[null,null,null,"N200"]
[null,null,null,"Alfa Romeo 4C Launch Edition '14"]
[null,null,null,"Alfa Romeo MiTo 1.4 T Sport '09"]
[null,null,null,"Audi TT Coupé 3.2 quattro '03"]
[null,null,null,"BMW M3 Sport Evolution '89"]
[null,null,null,"Citroën DS3 Racing '11"]
[null,null,null,"Ferrari Dino 246 GT '71"]
[null,null,null,"Honda Civic Type R (EK) '98"]
[null,null,null,"Honda Integra Type R (DC2) '98"]
[null,null,null,"Honda S2000 '99"]
[null,null,null,"Lancia DELTA HF Integrale Evoluzione '91"]
[null,null,null,"Lancia Stratos '73"]
[null,null,null,"Mazda Atenza Sedan XD L package '15"]
[null,null,null,"Mazda Roadster Touring Car"]
[null,null,null,"Mazda RX-7 GT-X (FC) '90"]
[null,null,null,"Mini MINI Cooper S '05"]
[null,null,null,"Nissan 180SX Type X '96"]
[null,null,null,"Nissan Silvia K's Dia Selection (S13) '90"]
[null,null,null,"Peugeot 208 GTi by Peugeot Sport '14"]
[null,null,null,"Peugeot RCZ GT Line '15"]
[null,null,null,"Pontiac Firebird Trans Am '78"]
[null,null,null,"Renault Sport Clio R.S. 220 EDC Trophy '15"]
[null,null,null,"Renault Sport Clio R.S. 220 EDC Trophy '16"]
[null,null,null,"Renault Sport Clio V6 24V '00"]
[null,null,null,"Subaru BRZ S '15"]
[null,null,null,"Toyota 2000GT '67"]
[null,null,null,"Toyota 86 GRMN '16"]
[null,null,null,"Toyota 86 GT \"LIMITED\" '16"]
[null,null,null,"Toyota 86 GT '15"]
[null,null,null,"Toyota MR2 GT-S '97"]
[null,null,null,"Toyota GR 86 '21","2021-07-08"]
[null,null,null,"Volkswagen Golf VII GTI '14"]
[]
[null,null,null,"N300"]
[null,null,null,"Alpine A110 Première Édition '17"]
[null,null,null,"Audi TTS Coupé '14"]
[null,null,null,"BMW M3 '03"]
[null,null,null,"Chevrolet Camaro Z28 '69"]
[null,null,null,"Chevrolet Corvette Stingray Convertible (C3) '69"]
[null,null,null,"De Tomaso Pantera '71"]
[null,null,null,"Dodge Super Bee '70"]
[null,null,null,"Ferrari 250 GT Berlinetta Passo Corto CN.2521 '61"]
[null,null,null,"Ford Focus ST '15"]
[null,null,null,"Ford Mustang Mach 1 '71"]
[null,null,null,"Gran Turismo Greddy FuGu Z"]
[null,null,null,"Honda Civic Type R (FK2) '15"]
[null,null,null,"Honda NSX Type R '92"]
[null,null,null,"Hyundai Genesis Coupe 3.8 Track '13"]
[null,null,null,"Jaguar E-type Coupé '61"]
[null,null,null,"KTM X-BOW R '12"]
[null,null,null,"Mazda RX-7 Spirit R Type A (FD) '02"]
[null,null,null,"Mazda RX500 '70"]
[null,null,null,"Mitsubishi GTO Twin Turbo '91"]
[null,null,null,"Mitsubishi Lancer Evolution Final Edition '15"]
[null,null,null,"Mitsubishi Lancer Evolution IV GSR '96"]
[null,null,null,"Nissan Fairlady Z 300ZX TT 2seater '89"]
[null,null,null,"Nissan Fairlady Z Version S (Z33) '07"]
[null,null,null,"Nissan SKYLINE GT-R V • Spec (R33) '97"]
[null,null,null,"Nissan Skyline GT-R V • spec II (R32) '94"]
[null,null,null,"Nissan Skyline GT-R V • spec II Nür (R34) '02"]
[null,null,null,"Plymouth XNR Ghia Roadster '60"]
[null,null,null,"Porsche 911 Carrera RS CS (993) '95"]
[null,null,null,"Porsche 911 Turbo (930) '81"]
[null,null,null,"Renault Sport Mégane R.S. Trophy '11"]
[null,null,null,"Shelby G.T.350 '65"]
[null,null,null,"Subaru IMPREZA 22B-STi '98"]
[null,null,null,"Subaru Impreza Coupe WRX Type R STi Version VI '99"]
[null,null,null,"Subaru WRX STI Type S '14"]
[null,null,null,"Toyota Crown Athlete G '13"]
[null,null,null,"Toyota GR Supra RZ '19"]
[null,null,null,"Toyota GR Yaris RZ \"High Performance\" '20"]
[null,null,null,"Toyota SUPRA 3.0GT Turbo A '88"]
[null,null,null,"Toyota SUPRA RZ '97"]
[]
[null,null,null,"N400"]
[null,null,null,"Aston Martin V8 Vantage S '15"]
[null,null,null,"Audi R8 4.2 FSI R tronic '07"]
[null,null,null,"BMW M3 '07"]
[null,null,null,"BMW M4 Coupé '14"]
[null,null,null,"BMW Z8 '01"]
[null,null,null,"Chevrolet Corvette C2 '63"]
[null,null,null,"Dodge Challenger R/T '70"]
[null,null,null,"Ferrari 365 GTB4 '71"]
[null,null,null,"Ferrari 512 BB '76"]
[null,null,null,"Ferrari GTO '84"]
[null,null,null,"Ford F-150 SVT Raptor '11"]
[null,null,null,"Ford GT40 Mark I '66"]
[null,null,null,"Ford Mustang GT Premium Fastback '15"]
[null,null,null,"Lamborghini Countach LP400 '74"]
[null,null,null,"Lamborghini Miura P400 Bertone Prototype CN.0706 '67"]
[null,null,null,"Maserati GranTurismo S '08"]
[null,null,null,"Mercedes-Benz A 45 AMG 4MATIC '13"]
[null,null,null,"Porsche 911 GT3 (996) '01"]
[null,null,null,"Porsche 911 GT3 (997) '08"]
[null,null,null,"Re Amemiya RE Amemiya FD3S RX-7"]
[null,null,null,"Toyota GR Supra RZ '20"]
[null,null,null,"Toyota S-FR Racing Concept '16"]
[null,null,null,"Toyota Tundra TRD Pro '19"]
[null,null,null,"TVR Tuscan Speed 6 '00"]
[]
[null,null,null,"N500"]
[null,null,null,"Alfa Romeo 4C Gr.3 Road Car"]
[null,null,null,"Chevrolet Camaro SS '16"]
[null,null,null,"Chevrolet Corvette C7 Gr.3 Road Car"]
[null,null,null,"Chevrolet Corvette Stingray (C7) '14"]
[null,null,null,"Citroën GT by Citroën Road Car"]
[null,null,null,"Dodge Viper GTS '02"]
[null,null,null,"Dodge Viper SRT10 Coupé '06"]
[null,null,null,"Ferrari F40 '92"]
[null,null,null,"Ferrari F50 '95"]
[null,null,null,"Ford Mustang Gr.3 Road Car"]
[null,null,null,"Lamborghini Countach 25th Anniversary '88"]
[null,null,null,"Lexus LC500 '17"]
[null,null,null,"Lexus RC F '14"]
[null,null,null,"Mazda Atenza Gr.3 Road Car"]
[null,null,null,"Mercedes-Benz -AMG GT S '15"]
[null,null,null,"Mitsubishi Lancer Final Edition Gr.B Road Car"]
[null,null,null,"Peugeot RCZ Gr.3 Road Car"]
[null,null,null,"Porsche 911 GT3 RS (991) '16"]
[null,null,null,"Shelby Cobra 427 '66"]
[null,null,null,"Subaru WRX Gr.B Road Car"]
[]
[null,null,null,"N600"]
[null,null,null,"Aston Martin DB11 '16"]
[null,null,null,"Dodge Viper GTS '13"]
[null,null,null,"Ferrari 458 Italia '09"]
[null,null,null,"Ford Ford GT '06"]
[null,null,null,"Gran Turismo Amuse S2000 GT1 Turbo"]
[null,null,null,"Honda NSX '17"]
[null,null,null,"Jaguar F-type R Coupé '14"]
[null,null,null,"Lamborghini Diablo GT '00"]
[null,null,null,"Lamborghini Huracàn LP 610-4 '15"]
[null,null,null,"McLaren F1 '94"]
[null,null,null,"McLaren MP4-12C '10"]
[null,null,null,"Mercedes-Benz SLR McLaren '09"]
[null,null,null,"Mercedes-Benz SLS AMG '10"]
[null,null,null,"Nissan GT-R NISMO '17"]
[null,null,null,"Nissan GT-R Premium edition '17"]
[]
[null,null,null,"N700"]
[null,null,null,"Chevrolet Camaro ZL1 1LE Package '18"]
[null,null,null,"Dodge Charger SRT Hellcat '15"]
[null,null,null,"Ferrari Enzo Ferrari '02"]
[null,null,null,"Ford GT '17"]
[null,null,null,"Gran Turismo 1967 Chevy Nova"]
[null,null,null,"Lamborghini Aventador LP 700-4 '11"]
[null,null,null,"McLaren 650 S Coupe '14"]
[null,null,null,"Pagani Huayra '13"]
[null,null,null,"RUF CTR3 '07"]
[]
[null,null,null,"N800"]
[null,null,null,"Aston Martin One-77 '11"]
[null,null,null,"Aston Martin Vulcan '16"]
[null,null,null,"Gran Turismo Mach Forty"]
[null,null,null,"Lamborghini Aventador LP 750-4 SV '15"]
[null,null,null,"Lamborghini Veneno '14"]

{"sheet":"PIT","index":13,"n_rows":26,"n_cols":33,"rows_kept":26,"cut":false,"hidden":false,"merged":[[14,16,14,17],[3,12,4,14],[24,12,24,14],[22,12,22,14],[20,12,20,14],[12,16,12,17],[16,16,16,17],[10,32,10,33],[6,16,6,17],[8,19,8,20],[3,16,4,18],[6,19,6,22],[8,16,8,17],[10,16,10,17]]}
[]
[null,null,"Aide au calcul des temps d'arrêts réels aux stands :"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Modifier les temps",null,null,null,"Détail des temps d'arrêt et de ravitaillement"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"t3",30,null,null,"Temps démontes et montes des pneus : ",null,4.5," (ce temps ne varie pas sur GT)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps réel changement pneus = (t2 - t1)",null,{"$f":"N11-N17","v":5.6},"(temps sec)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"S9+S11","v":23}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"t2",12.6,null,null,"Temps de remplissage max du réservoir : ",null,{"$f":"N7-N11","v":17.399999999999999},null,{"$f":"S11/U15","v":0.17399999999999999},"/ litre",null,null,null,null,null,null,null,"Consommation : ",null,{"$f":"U15/S15","v":{"$error":"#DIV/0!"}},"litres/tour"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Temps de remplissage pour 1 tour : ",null,{"$f":"AF11*U11","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacité max réservoir : ",null,{"$f":"'Strat 1'!I18","v":0},null,{"$f":"'Strat 1'!K18","v":100}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"t1",7,null,null,"Vitesse de ravitaillement : ",null,{"$f":"(1*U15)/S11","v":5.7471264367816097},"litres/seconde"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"vous pouvez vérifier l'exactitude avec les infos course sur Gran Turismo"]
[]
[]
[null,"t1 = temps de parcours voiture sur la piste entre l'entrée et la sortie des stands",null,null,null,null,null,null,null,null,null,null,"Pour obtenir t1 :",null,null,"relever le temps de passage de votre voiture entre l'entrée et la sortie des stands (en condition course)"]
[]
[null,"t2 = temps d'entrée au stand + temps PIT (changement pneus) + temps de sortie des stands",null,null,null,null,null,null,null,null,null,null,"Pour obtenir t2 :",null,null,"faire un arrêt avec seulement un changement de pneus et relever le temps indiqué sur l'écran en sortie de stand."]
[]
[null,"t3 = temps d'entrée au stand + changement pneus + refuel complet + temps de sortie des stands",null,null,null,null,null,null,null,null,null,null,"Pour obtenir t3 :",null,null,"faire un arrêt avec changement de pneu et refuel complet. Relever le temps d'arrêt indiqué sur l'écran à la sortie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," du stand."]