{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Notes","guitips_fr","guitexts_fr","texts_fr","guitips_en","guitexts_en","texts_en"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Notes","index":0,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Préparer les données",null,"Paramètres du propriétaire et du registre"]
["     ― Les données doivent préférablement avoir ce format :"]
["          ~ une colonne = une variable",null,"Compagnie","Différence"]
["          ~ une ligne (pour toutes les variables) = une observation",null,"Description"]
["          ~ première ligne : nom (titre) de la variable",null,"Code produit","Différence"]
["     ― Les cellules manquantes, contentant le mauvais type de donnée ou contenant",null,"Version","7.06"]
["          des codes d'erreur de Excel, sont exclues lors de l'importation",null,"Mot de passe","zm23wv57"]
["     ― Plus les données ont été préalablement filtrées et \"nettoyées\", plus les analyses sont fiables",null,"Default lang","English"]
[null,null,"Repository","https://www.difference-gcs.com/addin/"]
["Raccourcis clavier : utiliser les touches CTRL + SHIFT + …",null,"CPA slave file","cpa.xlsm","must be inside repository"]
["        U : analyses Univariées"]
["        B : analyses Bivariées"]
["        L : régression simple"]
["        N : analyses Multivariées"]
["        D : plateforme de Distributions statistiques",null,"Français"]
["        R : Ré-intialiser l'outil",null,"Pied de page","Complément statistique, optimisation et simulation par Différence"]
["        S : Solveur (plateforme d'optimisation)",null,"Droits d'auteur","Différence GCS Inc."]
["        X : eXplorateur de classeur",null,"Courriel","licenses@difference-gcs.com"]
["        C : calendar",null,"Documentation","Difference-addin-guide-fr.pdf","must be inside repository"]
["Pré-sélection des données"]
["Consiste à sélectionner des plages de valeurs avant d'ouvrir les modules d'analyse.  Les plages",null,"English"]
["multiples peuvent être définies en maintenant enfoncée la touche CTRL durant la sélection.",null,"Page footer","Statistics, optimization and simulation addin by Différence"]
["",null,"Copyrights","Différence GCS Inc."]
["     ― Analyses univariées : ",null,"Email","licenses@difference-gcs.com"]
["          ~ 1 plage de 1 colonne : X",null,"Documentation","Difference-addin-guide-en.pdf","must be inside repository"]
["          ~ 1 plage de 2 colonnes : col 1 = dates/marques,  col 2 = X"]
["          ~ 2 plages de 1 colonne : plage 1 = dates/marques,  plage 2 = X"]
[""]
["     ― Analyses bivariées : "]
["          ~ 2 plages de 1 colonne : plage 1 = X1,  plage 2 = X2/Y"]
["          ~ 1 plage de 2 colonnes : col 1 = X1,  col 2 = X2/Y"]
["          ~ 1 plage de >=2 colonnes (dans X seulement, laisser Y vide)"]
[""]
["     ― Analyses multivariées : "]
["          ~  2 plages de au moins 1 colonne chacune : plage 1 = bloc X,  plage 2 = bloc Y"]
[""]
["     ― Distributions statistiques : "]
["          ~ 1 plage de 1 colonne : données à comparer/ajuster"]
[""]
["     ― Analyse de système de mesure : "]
["          ~ 1 plage de 3 colonnes : col 1 = testeurs,  col 2 = échantillons,  col 3 = mesures"]
["          ~ 1 plage jusqu'à 5 colonnes : col 1 = testeurs,  col 2 = échantillons,  col 3 = mesures"]
["              optionnel : col4 = exclusion  col5 = données historiques"]
["          ~ 3 plages de 1 colonne : plage 1 = testeurs,  plage 2 = échantillons,  plage 3 = mesures"]
[""]
["     ― Planification d'expériences : "]
["          ~ plage 1 de 1 colonne (si définie) : liste des noms des variables"]
["          ~ plage 2 de 2 colonnes (si définie) : col 1 = bornes inférieures,  col 2 = bornes supérieures"]
[]
["     ― Optimisation de boîtes noires : "]
["          ~ plage 1 dont la cellule (1,1) contient : \"Paramètres de l'optimiseur\""]
["          ou bien, additionnelement et dans l'ordre :"]
["          ~ plage 1 de 1 cellule (si définie) : fonction objectif"]
["          ~ plage 2 de 1 colonne (si définie) : les variables de décision"]
["          ~ plage 3 de 2 colonnes (si définie) : col 1 = bornes inférieures,  col 2 = bornes supérieures"]
["          ~ plage 4 de 2 colonnes (si définie) : col 1 = formules des contraintes,  col 2 = valeurs des constantes"]
[]
["     ― Simulation Monte-Carlo : "]
["          ~ plage 1 dont la cellule (1,1) contient: \"MonteCarlo\""]
[]
["     ― Analyse PERT et Gantt : "]
["          ~ plage 1 dont la cellule (1,1) contient: \"PERT & Gantt\""]

{"sheet":"guitips_fr","index":1,"n_rows":47,"n_cols":22,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Analyses univariées","Tests pour carte ImR","Distributions statistiques","Analyses bivariées","Calculs de puissance et taille d'échantillon","Analyses multivariées","Graphique dynamique","Paramètres biplot","Analyse de système de mesure","Paramètres du plan d'expérience","Optimisation de boîtes noires","Calculateur d'intervalle","Explorateur…","Gestionnaire de la licence","Paramètres avancés","Paramètres CPA","Cartes ImR & EWMA","Simulation Monte-Carlo","Séries chronologiques","Analyses PERT et Gantt","Modifier l'histogramme","Analyse de la stabilité"]
["Choisir la colonne (plage verticale) de données","Pas de signal hors contrôle","Générer des données aléatoirement pour obtenir l'allure de la distribution (cette dernière doit être définie)","Choisir les facteurs (plage verticale) : valeurs continues pour la régression, valeurs catégoriques pour la comparaison de moyennes","Ratio n1/(n1+n2) (lorsque le nombre d'observations n'est pas balancé)","Choisir les données indépendantes (variables=colonnes, observations=lignes)","Sélectionner un graphique avec cadre rouge…","Sélectionner un graphique avec cadre vert…","Ajouter le nombre spécifié","Ajouter le nombre spécifié","Pas de cellule-objectif définie",null,"Rafraîchir la liste","INSTRUCTIONS :","Verrouille la feuille pour prévenir les modifications accidentelles (voir Outils… Protéger la feuille, aucun mot de passe)","Le nombre d'itérations doit être > 0","Approximations valides pour:","Ajouter le nombre spécifié","Graphique des termes d'autocorrélation de délai 1 à \"Nb. termes\"","Ajouter une activité","Pas assez de catégories pour construire un histogramme","Optionel, choisir les données indépendantes (variables=colonnes, observations=lignes)"]
["Étiquettes particulières des observations","Sélectionner un graphique Carte ImR","Ajuster la distribution (paramètres optionnels) sur les données ou comparer la distribution définie aux données","Choisir les réponses (plage verticale) : valeurs toujours continues","Plage verticale des moyennes (si inconnues, mettre autant de valeur que de catégories et les répartir uniformément sur l'étendue désirée)","Choisir les données dépendantes (variables=colonnes, observations=lignes)","Abscisse / Ordonnée :","","Renommer les items sélectionnés","Éditer les sélectionnés (noms, valeurs min et max)","La cellule objectif ne contient pas de formule",null,"Compacter/développer","","Convergence (précision) doit être > 0","Plus court segment doit être > 2","     2 <= K <= 3.5","Supprimer les items sélectionnés","Graphique de détection de cycles (spectre de puissance)","Supprimer l'activité sélectionnée","Charger la configuration d'un histogramme et/ou éditer ses paramètres","Choisir les données dépendantes (1 colonne, observations=lignes)"]
["Si une cellule de cette colonne contient 0, la ligne est exclue","Calculer et appliquer les marqueurs","Choisir la colonne (plage verticale) de données","Si une cellule de cette colonne contient 0, la ligne est exclue","Risque d'erreur de type I (en général, 0.05)","Étiquettes particulières des observations","     - Choisir une classe de variable (liste déroulante de gauche)","Abscisse / Ordonnée","Supprimer les items sélectionnés","Supprimer les sélectionnés","Pas de plage pour les variables de décision",null,"Supprimer les feuilles sélectionnées","- Inscrire le nom de l'instance et le mot de passe; ils seront mémorisés.",null,"Bootstrap : ","     0.05 <= w <= 1","Effacer (ré-initialiser) la propriété selectionnée","Nombre maximal de termes à évaluer","Exporter la configuration","Veuiller sélectionner un graphique histogramme.","Spécifier si la première cellule de la plage est le nom de la variable"]
["Indiquer la valeur cible","Retirer les marqueurs","Spécifier le minimum, le maximum et l'intervalle des barres","Noms de catégorie numériques détectés dans X1; continuer?","Estimé de la variation. Souvent le RMSE de l'analyse ou l'écart-type de l'échantillon","Si une cellule de cette colonne contient 0, la ligne est exclue","     - Choisir la variable désirée (liste déroulante de droite)","     - Choisir la composante désirée (sélection vide = conserver composante actuelle)","Le nombre total d'essais est : (1+ nb. répliques)*(nb. testeurs)*(nb. échant.)","","Plage verticale attendue pour : ",null,"Renommer les feuilles sélectionnées",null,null,"Élimination inverse : ","     Différence <= 4s","Exporter la configuration","Choisir la colonne (plage verticale) de données","Charger une configuration","Instructions d'utilisation :","Si une cellule de cette colonne contient 0, la ligne est exclue"]
["Spécifier le minimum, le maximum et l'intervalle des barres",null,"1- Sélectionner une distribution","Organise les groupes en ordre décroissant de moyennes (sinon, ordre alphabétique)","Spécifier deux des paramètres, laisser un champ vide pour en obtenir la valeur","Construire à partir de la section \"Paramètres du modèle\" d'un rapport de régression","     - Si la liste de droite est vide, la variable courante est conservée","     - Suggestion : mettre en abscisse une composante de rang plus faible qu'en ordonnée","Spécifier la plage verticale (une colonne) contentant les indentifiants des testeurs","","Certaines valeurs de variable sont manquantes",null,"Impossible de renommer la feuille : le nom est déjà utilisé.","- Cliquer sur \"Acquérir\" pour prendre possession d'une licence (si disponible); la licence sera attachée à l'ordinateur jusqu'à sa libération. Aucun autre utilisateur ne peut acquérir une licence acquise.",null,"De","K doit être > 0","Charger une configuration","Étiquettes particulières des observations","Ajouter un prédécesseur","     1) Sélectionner un histogramme et charger sa configuration","Niveau de confiance pour l'élimination inverse du CPA et pour la sélection de variables expliquant le changement"]
["Nouveau percentile (entre 0 et 100) :",null,"     - Ajuster : laisser les paramètres de distribution vide","Permet de déterminer quelles paires de moyennes sont différentes","Nombre total d'observations (somme de tous les groupes)","Mettre tous les X (modèle par défaut)","","","Spécifier la plage verticale (une colonne) contentant les indentifiants des échantillons","","Définir correctement les borne inférieures et suppérieures",null,"Aller à la feuille sélectionnée (double-cliquer)",null,null,"À","w doit être entre 0 et 1","1) Définir les variables réponses (Y)","Si une cellule de cette colonne contient 0, la ligne est exclue","Supprimer un prédécesseur","     2) Modifier les valeurs de l'histogramme (min., max., incrément)","Plus court segment pour le CPA (au moins 6!)"]
["Test basé sur les motifs pour un délai de 1",null,"     - Comparer : spécifier les paramètres de distribution","Au moins 2 groupes contenant des données sont requis","Puissance du test (en général, on désire >= 0.8)","Supprimer les termes sélectionnés","Charger la configuration","Charger la configuration","Choisir la colonne (plage verticale) de données","","Pas de plage verticale pour les fonctions g(x)",null,"Retirer la feuille sélectionnée des catégories de rapports","- Cliquer sur \"Relâcher\" pour libérer et retourner la licence sur le serveur; une licence libérée est à nouveau disponible pour d'autres utilisateurs.",null,"Sommaire des segments","Sigma doit être > 0","2) Définir les variables indépendantes (X)","Spécifier si la première cellule de la plage est le nom de la variable","Sur les rapports, nombre de chiffres après le séparateur des décimales","     3) Cliquer sur \"Appliquer\" pour rendre effective la modification","Coefficient de corrélation indiquant des problèmes potentiels de multicolinéarité (entre 0 et 1)"]
["Effacer (ré-initialiser) la propriété selectionnée",null,"     - Échantillonner : spécifier les paramètres de distribution","Préciser si X1 continent les noms des catégories ou non","1 groupe : |cible - moyenne|     2 groupes : |moyenne1-moyenne2|     k groupes : fixé (écart-type des moyennes)","Pour les termes sélectionnés, générer toutes les paires","Appliquer les changements","Appliquer les changements","Si une cellule de cette colonne contient 0, la ligne est exclue","","Définir correctement les constantes \"a\"",null,"",null,null,"Valeur p critique = ",null,"3) Sélectionner les options de simulation et de rapport","La constante de lissage : ","Valeur entre 0 et 100","","Si la corrélation du X est trop faible, ne pas afficher ce X sur les rapports"]
["Carte pour valeurs individuelles, variabilité basée sur les étendues mobiles.   Voir ses paramètres additionels pour modifier les constantes ImR ou pour définir une carte EWMA",null,null,"Pour la comparaison de deux moyennes, supposer que les variances sont inégales","n1 valeurs de la population 1 et n2 valeurs de la population 2 : fournir n1/(n1+n2)","Pour les X sélectionnées, générer X2","","","Spécifier la moyenne et l'écart-type connus du procédé","","Paramètres de l'optimiseur",null,null,"- En tout temps, il est possible d'utiliser le bouton \"Rafraîchir\" pour vérifier l'état de la licence et pour obtenir une mise à jour de la date d'expiration du serveur.",null,"Niveau de la pile = ",null,null," est obligatoire.","Ajouter des activités","Note : Cette modification est une approximation a posteriori.","Nombre d'itérations pour l'élimination inverse du CPA"]
["Change Point Analysis : détecter les changements probables de moyenne.   Voir les paramètres additionels pour modifier les paramètres CPA",null,"2- Choisir un mode d'analyse","Tracer l'ellipse de densité correspondant au niveau de confiance spécifié","Fournir une plage verticale, une valeur par moyenne (moyennes connues ou valeurs couvrant uniformément la plage des moyennes, tri facultatif)","Au moins 2 variables X numériques valides sont requises","","","Choisir la colonne (plage verticale) de données historiques","","Cellule contentant : ",null,null,null,null,"CP identifiés = ",null,"Réponses et variables","Les constantes de lissage doivent être dans [0, 1].","   (Les étiquettes des activités sont générées automatiquement)","L'analyse doit être effectuée à nouveau pour obtenir l'histogramme","Les X avec plus que cette fraction (entre 0 et 1) de valeurs manquantes seront ignorés"]
["Spécifier si la première cellule de la plage est le nom de la variable",null,"     - Ajuster : déterminer automatiquement les paramètres de distribution","Généer des rapports concis (rapports formels détaillés sinon)"," est requis",null,"","","Indiquer l'incrément (la plus petite graduation de l'instrument, valeur >0)","","Exporter configuration",null,null,null,null,"Taille segment courant = ",null,"   - ajouter/supprimer les variables à l'aide des boutons \"+\" et \"X\"","Le nombre de périodes de prévision doit être >= 1.","   - Donner une description concise","exact correspondant aux paramètres désirés.","Plus court segment pour le CPA trop long (forcé à n/5)"]
["Paramètres avancés…",null,"     - Comparer : comparer les données à la distribution spécifiée",null,"Alpha doit être entre 0 et 1",null,null,null,"Exporter la configuration",null,"Charger configuration",null,null,null,null,null,null,"   - cliquer sur une variable pour afficher ses propriétés","Nombre de valeurs futures à prédire à l'aide du modèle","   - Définir le modèle de la durée (liste déroulante Distribution)","","Attention! Il y a beaucoup de données, ça pourrait être long…\nVoulez-vous vraiment continuer?"]
["Exporter configuration",null,"     - Échantillonner : générer des nombres aléatoires selon la distribution",null,"Sigma doit être > 0",null,null,null,"Charger une configuration",null," : la cellule contient une formule",null,null,null,null,null,null,"   - double-cliquer sur une propriété pour en modifier sa valeur","Durée (nb obs.) d'une période ou saison","   - Ajouter ou modifier la liste des prédécesseurs","Charger la configuration","Plusieurs Xs, aucun Y : CPA séparé sur tous les Xs"]
["Charger configuration",null,null,null,"Delta doit être > 0",null,null,null,"Spécifier le nombre d'itérations pour la simulation",null,"Algorithmes disponibles",null,null,null,null,null,null,null,"La durée d'une période ou saison est obligatoire.","  ==> Cliquer sur Appliquer pour mémoriser les changements","Appliquer les changements","Aucun X, un seul Y : CPA ordinaire sur Y"]
["Clic-clic…",null,"Optionnel : choisir les graphiques à créer",null,"N doit être > 1",null,null,null,"Spécifier au moins un de LSL ou USL",null,"  - Évolutionnaire: heuristique de recherche directe (algorithme génétique)",null,null,"La redistribution, la modification du code source et la revente sans le consentement explicite de [CODE] sont strictement interdites.\n\nCe complément est fourni par [CODE] «tel quel» et «avec tous les défauts». Ce complément est compatible avec Excel 2013 ou plus récent sur un système d'exploitation Windows uniquement; Il a été testé et comparé à d'autres logiciels et est offert avec les meilleures intentions et connaissances. [CODE] ne fait aucune représentation ou garantie d'aucune sorte concernant la sécurité, l'adéquation, les inexactitudes, les erreurs typographiques, ou d'autres composantes nuisibles de ce complément. Il existe des dangers inhérents à l'utilisation de tout logiciel, et l'utilisateur est seul responsable de déterminer si ce complément est compatible avec son équipement et autres logiciels installés. L'utilisateur est également seul responsable de la protection de son équipement et de la sauvegarde de ses données. [CODE] ne sera pas responsable des dommages subis en raison de l'utilisation de ce complément.",null,null,null,"Paramètres des réponses (Y, onlget Réponses)","La durée d'une période ou saison doit être entre 2 et (nb obs.)/2.","","","Plusieurs Xs, un seul Y : CPA sur Y et stabilité des Xs"]
["Spécifier le niveau de confiance",null,null,null,"Puissance doit être entre 0 et 1",null,null,null,"Oups, il faut LSL < USL",null,"  - Fletcher-Reeves: gradients conjugués (variante Polak-Ribeire)",null,null,null,null,null,null,"   - la cellule DOIT contenir une formule liée au cellules des X","Modifier les valeurs des constantes","Paramètres de l'analyse",""]
["Spécifier la proportion couverte de la population (entre 0 et 1)",null,null,null,"Laisser un seul champ vide (delta, n, puissance)",null,null,null,"Oups, il faut LSL <= LAL et LAL < UAL",null,"  - MADS: recherche directe par treillis adaptatifs (motifs aléatoires)",null,null,null,null,null,null,"   - les spécifications et la cible servent à effectuer une analyse de","Nombre d'observations rétrospectives à considérer (= nb max de CP)","   - Choisir un mode d'évaluation du PERT",""]
["L'écart-type supposé doit être > 0",null,null,null,"Problème avec la sélection des moyennes",null,null,null,"Oups, il faut LAL < UAL et UAL <= USL",null,"  - Nelder-Mead: recherche directe par simplexes",null,null,null,null,null,null,"      capabilité classique sur les résultats de simulation","Conserver au moins 80% de R2X et négliger au plus 2% de R2Y","       ~ moyenne : utiliser les moyennes (constantes) des durées",""]
["Ajouter un percentile (entre 0 et 100)",null,null,null,"P doit être entre 0 et 1",null,null,null,null,null,"  - Recuit simulé: heuristique de recherche directe (voisinage variable)",null,null,null,null,null,null,"   - l'écart-type est l'amplitude du bruit blanc aléatoire à ajouter","Prendre toutes les composantes principales","       ~ simulation : utiliser des nombres aléatoires (avec variabilité)",""]
["Effacer le percentile sélectionné",null,null,null,"Il doit y avoir plus d'observations que de nombre de groupes",null,null,null,null,null,"   - VNS : recherche par voisinage variable basé sur des hypercubes latins",null,null,null,null,null,null,"      au valeurs simulées (RMSE, par exemple)","Spécifier le nombre (entre 2 et nb délais)","   - Tolérance : valeur négligeable de marge de temps (0 numérique)",""]
[null,null,null,null,null,null,null,null,"~ Considérations générales",null,null,null,null,null,null,null,null,null,"Le nombre de délais doit être >=2.","",""]
[null,null,null,null,null,null,null,null,"     - Les données doivent être en colonne",null,"Types de variables gérés",null,null,null,null,null,null,"Paramètres des variables (X, onlget Variables)","Le nombre de composantes principales doit être dans [2, nb délais].","Conseil : envisager une sauvegarde de la configuration…",""]
[null,null,null,null,null,null,null,null,"     - Une ligne = une observation testeur-échantillon-mesure",null,"  - Continues: tous les algorithmes",null,null,null,null,null,null,"   - la cellule NE DOIT PAS contenir de formule","Attention : le nombre de délais est inférieur à (nb obs)/2;  continuer quand même?",null,""]
[null,null,null,null,null,null,null,null,"     - Sur l'interface, les zones en gris pâle sont optionnelles",null,"  - Discrètes: évolutionnaire, MADS, recuit simulé, VNS",null,null,null,null,null,null,"   - les spécifications inférieures et supérieures servent à limiter","Appliquer la procédure d'analyse du point de changement",null,""]
[null,null,null,null,null,null,null,null,null,null,"  - Ordonnancement: évolutionnaire, recuit simulé",null,null,null,null,null,null,"      l'étendue des valeurs générées à l'aide des distributions",null,null,""]
[null,null,null,null,null,null,null,null,"~ Onlget EXPERIENCE",null,null,null,null,null,null,null,null,"   - la distribution à utiliser est une propriété obligatoire",null,null,""]
[null,null,null,null,null,null,null,null,"     - Sélectionner les plages des données requises",null,"Gestion des bornes et des contraintes",null,null,null,null,null,null,"Valeurs aléatoires : Monte-Carlo classique"]
[null,null,null,null,null,null,null,null,"     - Astuce : sélectionner les 3 plages avec CTRL avant d'ouvrir le module",null,"  - Bornes sur les variables: tous sauf Fletcher-Reeves",null,null,null,null,null,null,"Hypercube latin : probabilités uniformes randomisées"]
[null,null,null,null,null,null,null,null,null,null,"  - Contraintes relaxables (inégalité): évolutionnaire, MADS, recuit simulé, VNS"]
[null,null,null,null,null,null,null,null,"~ Onglet PROCÉDÉ"]
[null,null,null,null,null,null,null,null,"     - Sert à spécifier les valeurs historiques pour comparer et simuler",null,"Utiliser l'onglet \"Paramètres...\" pour personnaliser les paramètres"]
[null,null,null,null,null,null,null,null,"     - Aucune donnée : comparer seulement avec  la variation expérimentale",null,"Cet algorithme ne supporte pas les contraintes"]
[null,null,null,null,null,null,null,null,"     - Valeurs connues : fournir les paramètres requis",null,"Cet algorithme ne supporte pas les bornes sur les variables"]
[null,null,null,null,null,null,null,null,"     - Données historiques : plage verticale de valeurs à utiliser pour "]
[null,null,null,null,null,null,null,null,"          estimer automatiquement la moyenne et l'écart-type historiques"]
[]
[null,null,null,null,null,null,null,null,"~ Onglet RAPPORT"]
[null,null,null,null,null,null,null,null,"     - Le rapport minimal (aucune option) comporte la décomposition de la"]
[null,null,null,null,null,null,null,null,"          variation, le graphique multivari et le graphique de l'interaction"]
[null,null,null,null,null,null,null,null,"     - Répétabilité et résidus :carte S, diagramme quantile normal, etc."]
[null,null,null,null,null,null,null,null,"     - Comparaison à la variation totale : diagnostic de la qualité des mesures"]
[null,null,null,null,null,null,null,null,"     - Diagnostic de l'incrément : déterminer si l'incrément spécifé est adéquat"]
[null,null,null,null,null,null,null,null,"     - Analyse de risque : calculer les probabilités liées à la prise de décision"]
[null,null,null,null,null,null,null,null,"          en utilisant le système de mesure.  Requiert les limites de spécification"]
[null,null,null,null,null,null,null,null,"          et les limites d'acceptation si différentes des spécifications."]
[null,null,null,null,null,null,null,null,"          Note: il faut que LSL <= LAL < UAL <= USL."]

{"sheet":"guitexts_fr","index":2,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Analyses univariées","Tests pour carte ImR","Distributions statistiques","Analyses bivariées","Calculs de puissance et taille d'échantillon","Analyses multivariées","Graphique dynamique","Paramètres biplot","Analyse de système de mesure","Paramètres du plan d'expérience","Optimisation de boîtes noires","Calculateur d'intervalle","Explorateur…","Gestionnaire de la licence","Paramètres avancés","Paramètres CPA","Cartes ImR & EWMA","Simulation Monte-Carlo","Séries chronologiques","Analyses PERT et Gantt","Modifier l'histogramme","Analyse de la stabilité"]
["Données","Cocher les règles à appliquer :","Distribution","Données","Type de population","Données",null,null,"Planifier une ASM","Conception du plan","Problème","Moyenne","Feuilles du classeur","Statistique, optimisation et simulation",null,"Procédure principale","Paramètres du processus","Réponses","Données","Activités",null,"Données"]
["titre dans première cellule","Le point est en-dehors des limites","Analyse","titre dans première cellule","Moyennes","Termes du modèle","Abscisse : ",null,"Analyser","Factoriel","Solveur","Écart-type","Explorateur de classeur",{"$f":"Notes!D17","v":"Différence GCS Inc."},"Niveau de confiance","Paramètres obligatoires","D'après les données","Variables","titre dans première cellule","Activité sélectionnée",null,"titre dans la première cellule"]
["Date / marque","2 de 3 dans la zone A ou plus loin","Graphiques","Exclure","1 groupe","titre dans première cellule","Ordonnée : ","Composantes :","Testeurs","Remplissage","Paramètres…","Proportion","Mettre en page ou imprimer la feuille active","Réponse du serveur:","Convergence (précision)","Nb. itérations","Constantes imposées","Simulation","Date / marque","Description :","Forcer la délimitation des intervalles","Exclure"]
["Exclure","4 de 5 dans la zone B ou plus loin","Catégories des histogrammes","X1 (ou X)","2 groupes","Date / marque","Titre : ","Afficher :","Échantillons","Autre","Type   (1=Min  2=Max)","Niveau de confiance","Envoyer par courriel la feuille active","Expiration","Langue interface et rapports ","Niv. confiance","Paramètres de la carte","Propriétés :","Exclure","Durée de l'activité","Minimum","Niveau de confiance"]
["Catégories","6 d'affilée augmentant ou diminuant","Distribution (histogramme) ","X2 (ou Y)","K groupes","Exclure","Relier les points","Abscisse : ","Tableau des essais","Nombre de niveaux :","Objectif   (cellule formule)","Nb. Observations","Première feuille","Instance","Nombre entier >=2 requis!","Plus court segment","Lisser à partir de :","Éléments à inclure dans le rapport :","Lancer!","Distribution :","Incrément","Segment le plus court"]
["Poids","9 pts du même côté de la moyenne","Diagramme cumulatif de distribution","Lancer!","Paramètres connus","Liste vide = tous les effets principaux","Droite de tendance","Ordonnée : ","Randomiser les essais","Facteur de réduction :","Variables   (plage verticale)","Calculer","Feuille précédente","Acheter ou renouveler :","Protéger le rapport","Imprimer le sommaire des PC","1re obs","Nombre de points","Détection d'autocorrélation","Prédécesseurs","Maximum","Seuil significatif |r|"]
["Sous-catégories","Taille des marqueurs","Diagramme du quantile","Observations appariées","Niveau de alpha","Expérimenter et simuler",null,"Les deux","Nombre de répliques :","Nombre de points centraux:","Bornes inf.   (plage vert. / valeur)","Fermer","Feuille suivante","Mot de passe","Appliquer","Élimination inverse","Moyenne","Rapport","Détection de signaux périodiques","Avancement (%) :","Échec de la définition des limites pour l'histogramme","Masquer les X avec valeur p élevée"]
["Tester moyenne",null,"Nombre de points : ","Comparaison de moyennes","Écart-type","Lancer!","Classe :","Etiquettes des loadings","Nombre de réponses (Y) :","Hypercube latin : nb. points =","Bornes sup.  (plage vert. / valeur)","Décimales","Dernière feuille","Gestion de la licence","Rapport prêt à imprimer","Activer","Différence à détecter (multiple de sigma)","Analyse de capabilité des réponses","Nb. termes","Appliquer","Nombre de divisions :","Nombre d'itérations"]
["Tester autocorrélation",null,"Imprimer les valeurs générées","Niveau de confiance","Résoudre pour...","Tous X","Variable :","Etiquettes des scores","Générer!","Plan à orthogonaliser :","Effectuer une recherche initiale exploratoire","Ré-initialiser","Inclure les feuilles cachées",{"$f":"Notes!D18","v":"licenses@difference-gcs.com"},"Valeur pour…",null,"ARL approximés","Histogrammes (réponses et variables)","Diagnostics","Paramètres",null,"Profil de XXX"]
["Histogramme",null,"Données :","Variances inégales (2 groupes)","Diff. à détecter","Enlever",null,"Relier les scores","Nombre total d'essais:","Lire...","Nombre points","Cp ou Pp","Liste en ordre alphabétique",{"$f":"Notes!D5","v":"Différence"},"Étiquette pour…",null,null,"Table des essais","Nb. périodes signif.","Durées moyennes seulement",null,"Médiane durant les périodes stables de XXX"]
["Synonymes : graphique mosaïque, Pareto croisé, carte Marimekko",null,"Lancer!","Différence moyenne","Taille échant.","Croiser",null,null,"Rapport","Nombre d'itérations :","Algorithme :","Cpk ou Ppk","Feuilles cachées","Rafraîchir","Plage pour…",null,null,"Lancer!","Lissage exponentiel","Simulation Monte-Carlo",null,"Options"]
["Carte ImR / EWMA",null,"Échantillonner","Diff. moyenne dans ","Puissance","Carré",null,null,"Expérience","Tamisage-remplissage exploratoire","Hypothèse sur les variables :","Intervalle de confiance (moyenne)","Tri alphabétique   ","Acquérir","Valeur numérique requise!",null,null,"Au moins une réponse (Y) est requise","Période ou saison","Nombre d'itérations",null,"<< Retour"]
["Calculer les valeurs des quantiles :",null,"Ajuster","Précision (±) (sur diff. moy.)","Résoudre","Diagnostics",null,null,"Réponse","Central composite","réelles","Intervalle de confiance (écart-type)","Calculatrice Windows","Relâcher","Valeur positive requise!",null,null,"Au moins une variable (X) est requise","Horizon de prévision","Tolérance (marge de temps)",null,"Aucun X significatif à rapporter! Essayez de décocher l'option Masque les X…"]
["Diagramme du quantile normal",null,"Comparer","Régression simple","Fermer","PCA/PLS",null,null,"titre dans première cellule","Nb. répliques :","entières","Intervalle de confiance (proportion)","Insérer une date dans la cellule sélectionnée…","Aide","Nombre entier positif requis!",null,null,"Importance des variables","Constantes connues","Tableau sommaire des activités",null,"Lancer!"]
["Diagramme en boîte",null,"Supposer valeurs positives seulement","Linéaire","Pour un plan balancé, le nombre d'échantillons pour une population est n/k, où n est le nombre total et k, le nombre de groupes.","Régression",null,null,"Exclure","Randomiser le tableau","ordonnancement","Intervalle de confiance (Cp ou Pp)",null,"Problème de connexion au serveur!","Nombre entier requis!",null,null,"MonteCarlo: générer les valeurs","Niveau","Diagramme de Gantt",null,"Variable (cliquer!)"]
["Lancer!",null,"Choisir un mode d'analyse!","Comparer les moyennes",null,"Sommaires univariés",null,null,"Comparaison à la variation totale","Nombre d'essais =","Résoudre","Intervalle de confiance (Cpk ou Ppk)",null,"La licence de l'utilisateur est valide","La valeur doit être dans :",null,null,"évaluation du modèle","Tendance","Statistiques de la durée totale",null,"r (médianes)"]
["Tester un écart-type",null,null,"Noms des groupes dans X1",null,"Valeurs propres de X",null,null,"Court terme","Générer","Journal des itérations","Intervalle de tolérance d'une population",null,"Déni de responsabilité","Le champ est vide!",null,null,"génération du rapport","Saisonnalité","Lancer!",null,"Valeur p de r"]
["Carte des étendues mobiles",null,null,"Si plus de 2 groupes :",null,"Tester la multicolinéarité",null,null,"Long terme","Optimiser le plan","Quantitatives :",null,null,"Pas de licence valide pour l'utilisateur",null,null,null,"Définir une cellule pour ","PLS autorégressif","L'activité ne peut pas être son propre prédécesseur",null,"DY / DX"]
["Analyse de Pareto",null,null,"Trier les moyennes",null,"Détection des données aberrantes",null,null,"Valeurs connues","Options du rapport","Nominales :",null,null,"Licence libérée avec succès",null,null,null," : la cellule doit contenir une formule","Détecter les changements de moyenne","Cette activité est déjà dans la liste",null,"Similitude"]
["Intervalle de tolérance",null,null,"Comparer toutes les paires",null,"Modèles PCA & PLS :",null,null,"Données historiques","Diagnostic du plan","Rayon non-borné",null,null,"Spécifier le groupe, l'instance et le mot de passe!",null,null,null," : revoir les spécifications","Simple","Ce code d'activité n'existe pas  ",null,"Variables corrélées"]
["Graphiques",null,null,"Rapports simplifiés",null,"R2cumul X",null,null,"Delta =","Enveloppe uniforme de Doehlert","Contraintes   (plage vert.  g(x))",null,null,"Groupe",null,null,null," : la cellule ne doit pas contenir de formule","Double","Code d'activité (lettre(s) du menu de gauche)",null,"Filtrer si trop de valeurs manquantes"]
["Analyses",null,null,"Ellipse de densité",null,"R2cumul X et Y",null,null,"Graphiques de la répétabilité et des résidus",null,"Contraintes   (plage vert.  a)",null,null,null,null,null,null,"Définir une disitrbution pour ","Saisonnier","Echec: définir la durée (distribution statistique)",null,"Seuil fraction manquante"]
["Quantiles",null,null,"Non-linéaire",null,"Nombre de CP :",null,null,"Analyser!",null,"(Double-cliquer sur une propriété pour l'éditer)",null,null,null,null,null,null,"Paramètres","Nb. délais","Durée totale"]
["Étude de capabilité",null,null,"Corrélation",null,null,null,null,"Analyse de risque",null,"Bornes   l <= x <= u",null,null,null,null,null,null,"Valeurs aléatoires","Lissage exp.","Courbes de complétion"]
["Spec. inf.",null,null,"Imprimer les résidus",null,null,null,null,"Diagnostic de l'incrément",null,"Contraintes   g(x)<=a",null,null,null,null,null,null,"Hypercube latin","Analyse des résidus","Temps écoulé"]
["Cible",null,null,"Générer les formules",null,"Graphiques de diagnostic du modèle",null,null,"Procédé",null,"Cette propriété n'est pas requise",null,null,null,null,null,null,null,"Niveau de confiance","Complétion (%)"]
["Spec. sup.",null,null,"Analyse des résidus",null,"Distances (DModX/DModY)",null,null,"Total mesure",null,"? = requis, à définir     --- = non requis",null,null,null,null,null,null,"Méthode d'échantillonnage","Stratégie de sélection des CP :","Début hâtif"]
["Table simplifiée (seulement les %)",null,null,"Modèle :",null,"Formules de prédiction",null,null,"Répétabilité",null,"Minimiser",null,null,null,null,null,null," : revoir les paramètres de la distribution","Automatique","Début tardif"]
["Trier les résultats par :",null,null,null,null,"Transformer Y :",null,null,"Reproductibilité",null,"Maximiser",null,null,null,null,null,null,"(sélectionner dans la liste)","Toutes","Marge"]
["Valeurs décroissantes",null,null,null,null,"Sommaire de régression",null,null,"Interaction",null,null,null,null,null,null,null,null,"Percentiles","CP 1 à … ","Nombre de décimales :"]
["Étiquettes alphabétiques",null,null,null,null,"Diagnostics par ligne et graphiques",null,null,"Variation de la mesure",null,null,null,null,null,null,null,null,"Quantiles",null,"Durée"]
[null,null,null,null,null,"Résidus",null,null,"Aucune donnée",null,null,null,null,null,null,null,null,null,null,"Complété"]
[null,null,null,null,null,"Formule",null,null,"Expérience",null,null,null,null,null,null,null,null,null,null,"Restant"]
[null,null,null,null,null,"Distances de Cook",null,null,"Corrélation intra-classe (R2 procédé)"]
[null,null,null,null,null,null,null,null,"Qualité de la mesure"]
[null,null,null,null,null,null,null,null,"I = excellente,   IV = mauvaise"]
[null,null,null,null,null,null,null,null,"Nombre de catégories distinctes"]
[null,null,null,null,null,null,null,null,"Résolution de la mesure"]
[null,null,null,null,null,null,null,null,"Incrément"]
[null,null,null,null,null,null,null,null,"Erreur probable"]
[null,null,null,null,null,null,null,null,"Résolution minimale"]
[null,null,null,null,null,null,null,null,"Résolution maximale"]
[null,null,null,null,null,null,null,null,"\"adéquate\""]
[null,null,null,null,null,null,null,null,"\"inadéquate\""]
[null,null,null,null,null,null,null,null,"Simulation Monte-Carlo :"]
[null,null,null,null,null,null,null,null,"itérations"]
[null,null,null,null,null,null,null,null,"Spécification"]
[null,null,null,null,null,null,null,null,"Acceptation"]
[null,null,null,null,null,null,null,null,"Inférieure"]
[null,null,null,null,null,null,null,null,"Supérieure"]
[null,null,null,null,null,null,null,null,"Limites :"]
[null,null,null,null,null,null,null,null,"(mesure sans erreur)"]

{"sheet":"texts_fr","index":3,"n_rows":107,"n_cols":32,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["Aucune analyse à effectuer.",null,null,"Sommaire descriptif",null,null,null,"Nom","param1","param2","param3",null,null,"Module","Nom","Groupe","Actif",null,null,"Algorithmes","Evolutionnaire",null,"Fletcher-Reeves",null,"MADS",null,"Nelder-Mead",null,"Recuit simulé",null,"VNS"]
["Pas de donnée dans la zone.",null,null,"Nb. obs.",null,null,1,"Constante","Valeur",null,null,null,"M_UNI",1,"Analyses univariées","Plateformes d'analyse",true,null,null,"Évolutionnaire","Taille de la population",-1,"Pas du gradient numérique",6.0559999999999997E-7,"Activer recherche linéaire (0 ou 1)",1,"Taille simplexe initial",0.5,"Nb. points voisinage (-1=auto)",-1,"Itérations de poursuite linéaire (0=aucun, 100=max)",25]
["Données en colonne attendues.",null,null,"Moyenne",null,null,2,"Bernouilli","ProbValeur1","Valeur1","Valeur2",null,"M_IMR",2,"Tests ImR","Autres outils",true,null,null,"Fletcher-Reeves","Probabilité de croisement (0-1)",0.5,"Pas initial de la recherche linéaire",0.1,"Taille treillis initial",0.2,"Taille simplexe final",9.9999999999999995E-7,"Prob. max. échappement (0..1)",0.5,"Taille initiale voisinage",0.5]
["Specifiez la cellule d'ancrage pour les résultats.",null,null,"Écart-type",null,null,3,"Exponentielle","Décalage","Moyenne",null,null,"M_DISTR",3,"Distributions statistiques","",true,null,null,"MADS","Taux de mutation max (0-1)",0.25,"Tolérance sur norme gradient",9.9999999999999995E-7,"Taille treillis final",9.9999999999999995E-7,"Max. évaluations",10000,"Facteur expansion voisinage (2..10)",3,"Taille finale voisinage",9.9999999999999995E-7]
["Pas de données à écrire.",null,null,"Sigma ImR",null,null,4,"Laplace","Mode","Moyenne",null,null,"M_BIV",4,"Analyses bivariées","Régression simple",true,null,null,"Nelder-Mead","Rayon de recherche non-bornée",10,"Max. évaluations",10000,"Max. évaluations",10000,null,null,"Taille initiale voisinage",1,"Facteur expansion voisinage (2..10)",4]
["Pas d'évidence d'autocorrélation",null,null,"Minimum",null,null,5,"Lognormale","Décalage","Moyenne","Écart-type",null,"M_POW",5,"Puissance et taille d'échantillon","",true,null,null,"Recuit simulé","Max. générations sans succès",50,null,null,null,null,null,null,"Taille finale voisinage",9.9999999999999995E-7,"Max. évaluations",10000]
["Autocorrélation négative",null,null,"Médiane",null,null,6,"Normale","Moyenne","Écart-type",null,null,"M_MULTI",6,"Analyses multivariées","",true,null,null,"VNS","Max. évaluations",20000,null,null,null,null,null,null,"Max. évaluations",10000]
["Autocorrélation positive",null,null,"Maximum",null,null,7,"Pareto","Échelle","Forme","Borne (0=aucune)",null,"M_DYN",7,"Graphique dynamique","",true]
["Choisir une distribution!",null,null,"Intervalle de conf. (sur moy.)",null,null,8,"Poisson","Décalage","Moyenne","Amplitude",null,"M_BIP",8,"Paramètres biplot","",true]
["Spécifier les paramètres requis",null,null,"Niveau de confiance",null,null,9,"Triangulaire","Minimum","Mode","Maximum",null,"M_MSA",9,"Analyser une ASM","EOS",true]
["Spécifier le nombre de points",null,null,"Précision (±)",null,null,10,"Uniforme","Minimum","Maximum",null,null,"M_DOE",10,"Planification d'expérience","EXPÉRIMENTER",false]
["La sélection courante n'est pas valide.",null,null,"Index",null,null,11,"Uniforme-D","Minimum","Maximum",null,null,"M_MC",11,"Simulation Monte-Carlo","SIMULER",true]
[{"$f":"Notes!D16","v":"Complément statistique, optimisation et simulation par Différence"},null,null,"Étiquette",null,null,12,"Weibull","Décalage","Échelle","Forme",null,"M_OPTIM",12,"Solveur pour l'optimisation","OPTIMISER",true]
["Spécifier mu",null,null,"Valeur",null,null,null,null,null,null,null,null,"M_PAR",13,"Paramètres avancés","Configuration",true]
["La sélection de plages multiples n'est pas permise.",null,null,"Limite inf.",null,null,null,null,null,null,null,null,"M_HELP",14,"Aide et conseils",null,true]
["Fichier d'aide introuvable!",null,null,"Cible",null,null,null,null,null,null,null,null,"M_XPLOR",15,"Explorateur du classeur","",true]
["Périodes : ",null,null,"Limite sup.",null,null,null,null,null,null,null,null,"M_RESET",16,"Ré-initialiser l'outil","",true]
["Sélection vide!",null,null,"CUSUM",null,null,null,null,null,null,null,null,"M_LIC",17,"Licences","",true]
["Choisir une plage/cellule pour ",null,null,"Intervalle",null,null,null,null,null,null,null,null,"M_HIST",18,"Modifier l'histogramme","",true]
["Spécifier la valeur de ",null,null,"Fréquence",null,null,null,null,null,null,null,null,"M_INTER",19,"Calculateur d'intervalle","",true]
["Forte preuve d'inégalité des variances",null,null,"Test d'autocorrélation",null,null,null,null,null,null,null,null,"M_PARETO",20,"Analyse de Pareto","",true]
["Pas assez de preuves d'inégalité des variances",null,null,"Ratio des motifs",null,null,null,null,null,null,null,null,"M_EMAIL",21,"Envoyer la page par courriel","",true]
["Choisir une hypothèse sur les variances",null,null,"Limites",null,null,null,null,null,null,null,null,"M_PRINT",22,"Imprimer la page","",true]
["Problème de lecture des données.",null,null,"Quantile normal",null,null,null,null,null,null,null,null,"M_TIME",23,"Séries chronologiques","",true]
["La transformation de Y a échoué.",null,null,"Qualité de l'ajustement",null,null,null,null,null,null,null,null,"VIEWSHEET",24,"Voir la feuille…  ","Feuilles du classeur",true]
["Multicolinéarité non négligeable lorsque kappa>5",null,null,"Données",null,null,null,null,null,null,null,null,"M_PERT",25,"Analyses PERT et Gantt",null,false]
["Multicolinéarité non négligeable lorsque VIF > 5",null,null,"Théorique",null,null,null,null,null,null,null,null,"M_STABL",26,"Analyse de la stabilité",null,true]
["Orthogonaliser le plan?",null,null,"Variable :",null,null,null,null,null,null,null,null,"M_CONTING",27,"Analyse de contingence",null,true]
["Au moins 2 composantes sont requises.",null,null,"Tester une moyenne"]
["Trop de niveaux.",null,null,"Score t"]
["Nécessite au moins 2 variables.",null,null,"Valeur p"]
["Résolution du plan : ",null,null,"Evaluations = "]
["Au moins une spécification est requise.",null,null,"Tolérance = "]
["Pas assez de testeur ou d'échantillon dans les listes.",null,null,"Contrainte"]
["Spécifier le nombre de testeurs.",null,null,"Comparer deux moyennes"]
["Spécifier le nombre d'échantillons.",null,null,"Hypothèse variances :",null,"Pour les trasnformations"]
["Spécifier le nombre de variables.",null,null,"égales",null,"Y"]
["Cette version de Excel n'est pas supportée.",null,null,"inégales",null,"1/Y"]
["Tous les changements seront effectifs au prochain démarrage de Excel.",null,null,"bootstrap",null,"ln(Y)"]
["Attention : suppression définitive et permanente. Continuer?",null,null,"moy(X2)-moy(X1)",null,"√Y"]
["Les cellules en vert sont éditables",null,null,"Sommaire univarié",null,"Y²"]
["Les catégories ne possédant pas des lettres similaires ont des moyennes significativement différentes.",null,null,"Paramètres du modèle",null,"exp(Y)"]
["Spécifier sigma",null,null,"Bloc X",null,"Box-Cox"]
["Votre licence Différence expirera dans ### jours. Il est temps de la renouveler!",null,null,"Bloc Y"]
["Votre licence Différence est expirée! Il est temps de la renouveler.",null,null,"Score F",null,"Modèles non-linéaires"]
["Intercepte",null,null,"Transformation Y :",null,"Y = a(X^b)",2]
["Oui",null,null,"Prédictions",null,"Y = a+b^X",2]
["Non",null,null,"Résidus",null,"Y = a+b*exp(c*X)",3]
["Ré-initialiser le formulaire?",null,null,"Rang",null,"Y = a+b*X/(c+X)",3]
["Le télécharger du site web?",null,null,"Tests sur les variances",null,"Y = 1/(a+b*X)",2]
["Niveau de confiance incorrect (doit être entre 0 et 1)",null,null,"Catégories distinctes",null,"Y = 1/(a+b*X+c*X^2)",3]
["Pas de license valide activée",null,null,"Différence",null,"Y = 1/(a+b*X)^c",3]
["Sélection impossible dans un autre classeur!",null,null,"Données influentes",null,"Y = 1/(1+exp(a+b*X))",2]
["Attention! ###% des observations ont été rejetées à cause de valeurs manquantes.",null,null,"Distances de Cook normalisées",null,"Y = a+b/(1+exp(c+d*X))",4]
[null,null,null,"Structure du modèle",null,"Y = a+b*(1-exp(-(X/c)^d))",4]
[null,null,null,"Index de Pratt relatifs",null,"Y = a+b*tanh(c+d*X))",4]
[null,null,null,"Graphique dynamique"]
[null,null,null,"Composantes principales"]
[null,null,null,"Valeurs propres"]
[null,null,null,"Données aberrantes"]
[null,null,null,"Distances normalisées"]
[null,null,null,"Détection de la multicolinéarité"]
[null,null,null,"% de la variance totale"]
[null,null,null,"Facteurs"]
[null,null,null,"Bornes inférieures"]
[null,null,null,"Bornes supérieures"]
[null,null,null,"Pondération :"]
[null,null,null,"Sommation"]
[null,null,null,"Spécifications"]
[null,null,null,"Prob. cumulées"]
[null,null,null,"Rapport"]
[null,null,null,"Histogramme"]
[null,null,null,"Carte ImR"]
[null,null,null,"Carte EWMA"]
[null,null,null,"'% hors spec."]
[null,null,null,"Capabilité"]
[null,null,null,"Total"]
[null,null,null,"Probabilités"]
[null,null,null,"Rejeter un item non-conforme"]
[null,null,null,"Rejeter un item conforme"]
[null,null,null,"Accepter un item non-conforme"]
[null,null,null,"Accepter un item conforme"]
[null,null,null,"Prendre une bonne décision"]
[null,null,null,"Précision moyenne (±, 95% confiance)"]
[null,null,null,"Risque du consommateur"]
[null,null,null,"Risque du producteur"]
[null,null,null,"Terme très influent lorsque "]
[null,null,null,"Plan de tamisage"]
[null,null,null,"Résolution du plan"]
[null,null,null,"Délais signif.:"]
[null,null,null,"nouveau nom"]
[null,null,null,"Moyenne dans "]
[null,null,null,"Cellule"]
[null,null,null,"Cellule contenant : "]
[null,null,null,"Étendues mobiles"]
[null,null,null,"Tester un écart-type"]
[null,null,null,"Score X2"]
[null,null,null,"Diagramme en boîte"]
[null,null,null,"Deg. liberté"]
[null,null,null,"Délai"]
[null,null,null,"Période"]
[null,null,null,"Contrib. à la variation totale (%)"]
[null,null,null,"Intervalle de tolérance"]
[null,null,null,"Comparaison de toutes les paires (Tukey-Kramer HSD)"]
[null,null,null,"Paramètres"]
[null,null,null,"Observations"]
[null,null,null,"Carte S"]

{"sheet":"guitips_en","index":4,"n_rows":47,"n_cols":22,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Univariate analyzes","ImR decision rules","Statistical distributions","Bivariate analyzes","Power and sample size calculations","Multivariate analyzes","Dynamic plot","Biplot settings","Measurement system analysis","Design of experiments","Black box optimization","Interval calculator","Workbook explorer","License manager","Advanced settings","CPA parameters","ImR & EWMA charts","Monte Carlo Simulation","Time series","PERT and Gantt Analyzes","Edit histogram","Stability analysis"]
["Select column data (vertical range)","No out-of-control signal","Generate random data to visualize the distribution (which must be defined in the above section)","Select factors (vertical range): continuous values for regression, categorical values for means comparison","Ratio n1/(n1+n2) (when unbalanced number of observations)","Select independent data (variables=columns, observations=rows)","Select a plot with a red frame","Select a plot with a green frame","Add the specified amount","Add the specified amount","No objective cell (formula) selected",null,"Refresh list","INSTRUCTIONS :","Lock report sheet to prevent accidental modifications (see Tools… Protect sheet, no password)","Number of iterations must be > 0","Approximations valid for:","Add the specified amount","Graph of autocorrelation termes from lag 1 to \"No. terms\"","Add one activity","Not enough categories to build an histogram","Optional, select independent data (variables=columns, observations=rows)"]
["Observation labels","Select an ImR chart","Fit distribution (parameters are optionnal) on the given data, or compare the defined distribution to the given data.","Select repsonse (vertical range): always continuous values","Vertical range for the means (if unknown, put one value for each group, all values should spread the desired means' range)","Select dependent data (variables=columns, observations=rows)","Abscissa / Ordinate :","","Rename selected","Edit selected (names, min and max values)","Objective cell does not have a formula",null,"Collapse/expand","","Convergence (precision) must be > 0","Shortest segment must be > 2","     2 <= K <= 3.5","Remove selected items","Graph for cycles detection (power spectrum)","Delete selected activity","Please load an histogram and/or edit its settings","Select dependent data (1 column, observations=rows)"]
["If a cell in this column contains 0, the row is excluded","Calculate and display markers","Select column data (vertical range)","If a cell in this column contains 0, the row is excluded","Type I error rate (in general, 0.05)","Observation labels","     - Select a variable class (left dropdown list)","Abscissa / Ordinate :","Remove selected","Remove selected","No range for decision variables",null,"Deleted selected sheet(s)","- Type the instance name and its password into the text boxes; these values will be memorized for future use.",null,"Bootstrap : ","     0.05 <= w <= 1","Erase (reset) selected property","Maximal number of lags to evaluate","Export configuration","Please select a histogram chart.","Specify if the first cell of the range is the variable's name"]
["Specify target value","Remove markers","Specify minimum, maximum and bar stepsize","Numerical category name detected in X1; continue?","Estimate of the variability. Generally, it is the RMSE from the analysis or the sample standard deviation","If a cell in this column contains 0, the row is excluded","     - Select a variable (right dropdown list)","     - Select a component (empty selection = keep actual)","Total number of trials is: (1+ no. replicates)*(no. testers)*(no. sambles)","","Vertical range expected for: ",null,"Rename selected sheet(s)",null,null,"Backward elimination: ","     Difference <= 4s","Export configuration","Select column data (vertical range)","Load a configuration","Quick instructions:","If a cell in this column contains 0, the row is excluded"]
["Specify minimum, maximum and bar stepsize",null,"1- Select a distribution","Sort the groups in decreasing order of means (otherwise, alphabetical order)","Specify two paramters and let the third one blank to get its value","Build using regression report section \"Model parameters\"","     - If right list is empty, current variable is kept","     - Tip: put on the abcissa a component with a lower rank than than the ordinate's rank","Select column data (vertical range) that contains testers","","Some variables values are missing",null,"Cannot rename sheet: name already used.","- Click on \"Acquire\" to take ownership of a license (if available); the license will be attached to the computer and made unavailable to other users until it is released.",null,"From","K must be > 0","Load a configuration","Observation labels","Add one predecessor","     1) Select a histogram chart and load its configuration","Confidence level for the CPA backward elimination and significant correlations with change points"]
["New percentile (between 0 and 100) :",null,"     - Fit : leave distribution parameter fields empty","Is used to determine which pairs are different","Total number of observations (sum from all groups)","Include all Xs (default model)","","","Select column data (vertical range) that contains samples","","Problem with bounds definition",null,"Go to selected sheet (or double-click on it)",null,null,"To","w must be between 0 and 1","1) Define model responses (Y)","If a cell in this column contains 0, the row is excluded","Delete selected predecessor","     2) Modify histogram settings (min., max., stepsize)","Shortest segment for the CPA (at least 6!)"]
["Pattern test for lag 1 autocorrelation",null,"     - Compare : specify distribution parameters","At least two groups containing data are required","Power of the test (in general, should be >= 0.8)","Remove selected terms","Load configuration","Load configuration","Select column data (vertical range) that contains responses","","No vertical range for functions g(x)",null,"Remove the selected sheet from report categories","- Click on \"Release\" to free and return the license to the server. This license is now available to other users.",null,"Segments summary","Sigma must be > 0","2) Define independant variables (X)","Specify if the first cell of the range is the variable's name","On reports, number of digits after decimal separator","     3) Click on \"Apply\" to update histogram chart","Correlation coefficient indicating possible multicolinearity issues (between 0 and 1)"]
["Erase (reset) selected property",null,"     - Sample : specify distribution parameters","Precise wether X1 contains category names or not","1 group : |target - average|     2 groups : |average1 - «verage2|     k groups : fixed std. dev. of the means)","Generate pairwise combinations for selected Xs","Apply changes","Apply changes","If a cell in this column contains 0, the row is excluded","","Wrong selection for constants \"a\"",null,"",null,null,"Critical p-value = ",null,"3) Selection simulation and report options","Smoothing constant: ","Value between 0 and 100","","If the correlatio ncoefficient is too low, the X is not reported"]
["Chart for individual values with variability based on the moving range.   See advanced settings to modify ImR constants or to set a EWMA chart.",null,null,"For the two means comparison, assume that variances are unequal","n1 values from population 1 and n2 values from population 2 : provide n1/(n1+n2)","Generate X2 for selected Xs","","","Specify known values for process mean and standard deviation","","Optimizer settings",null,null,"- At anytime it is possible to click on \"Refresh\" to verify the current license state and to update from the server the expiration date.",null,"Stack level = ",null,null," is mandatory.","Add several activities","Note: This modification is a posteriori approximation only.","Number of iterations for the CPA backward elimination"]
["Change Point Analysis: detection of probable changes in the mean.   See advanced settings to modify CPA parameters.",null,"2- Choose an analysis mode","Plot density ellipse for the specified confidence level","Provide vertical range of cells, one value per mean (known means or values covering uniformly possible means range, do not neeed to be sorted)","At least 2 valid numeric variables ar required in X","","","Select column data (vertical range) that contains historical data","","Cell containing: ",null,null,null,null,"CP found = ",null,"Responses and variables","Smoothing constants must be in [0, 1].","   (Activities tags are generated automatically)","To obtain the exact histogram corresponding to desired","Xs having more than this fraction (between 0 and 1) of missing values will be discarded"]
["Specify if the first cell of the range is the variable's name",null,"     - Fit : calculate automatically distribution parameters","Generate concise reports (formal detailed reports otherwise)"," is required",null,"","","Enter the smallest gage increment (value >0)","","Export configuration",null,null,null,null,"Current segment size = ",null,"   - add/remove items using \"+\" and \"X\" buttons","Number of forecast periods must be >= 1.","   - Provide a short description text"," settings, the analysis should be re-done again.","Shortest segment for the CPA too short (forced to n/5)"]
["Advanced settings…",null,"     - Compare : compare data with specified distribution",null,"Alpha must be between 0 and 1",null,null,null,"Export configuration",null,"Load  configuration",null,null,null,null,null,null,"   - click on an item to show its properties","Number of future values to predict with the model","   - Define a duration model (statistical distribution)","","Warning! This is a lot of data, it could take a lot of time.\nAre you sure you want to proceed?"]
["Export configuration",null,"     - Sample : generate random numbers from specified distribution",null,"Sigma must be > 0",null,null,null,"Load a configuration",null,": cell contains a formula",null,null,null,null,null,null,"   - double-click on a property to modify its value","Length (no. obs.) of a period or season","   - Add or modify predecessors list","Load configuration","Several Xs, no Y: separate CPA on all Xs"]
["Load  configuration",null,null,null,"Delta must be > 0",null,null,null,"Specify number of simulation iterations",null,"Available algorithms",null,null,null,null,null,null,null,"Period or season length is mandatory","  ==> Click on Apply changes to memorize the new settings","Apply changes","No X, only one Y: ordinary CPA on Y"]
["Click-click…",null,"Optional : select charts to create on report",null,"N must be > 1",null,null,null,"Specify at least one of LSL or USL",null,"  - Evolutionary: direct search heuristic (genetic algorithm)",null,null,"Redistribution, modification of the source code and reselling without the consentient of [CODE] is strictly prohibited.\n\nThis add-in is provided by [CODE] \"as is\" and \"with all faults.\" This add-in is compatible with Excel 2013 or newer on Windows OS only; It has been tested and benchmarked against other software and is offered with the best intentions and knowledge. [CODE] makes no representations or warranties of any kind concerning the safety, suitability, inaccuracies, typographical errors, or other harmful components of this add-in. There are inherent dangers in the use of any software, and you are solely responsible for determining whether this add-in is compatible with your equipment and other software installed on your equipment. You are also solely responsible for the protection of your equipment and backup of your data, and [CODE] will not be liable for any damages you may suffer in connection with using this add-in.",null,null,null,"Parameters of responses (Y, Responses tab)","Period or season length must be between 2 and (no. obs.)/2.","","","Several Xs, one Y : CPA on Y and stability of the Xs"]
["Specify confidence level",null,null,null,"Power must be between 0 and 1",null,null,null,"Oops, expecting LSL < USL",null,"  - Fletcher-Reeves: conjugated gradients (Polak-Ribeire variant)",null,null,null,null,null,null,"   - cell MUST contain a formula linked to X cells","Edit values of the constants","Analysis parameters",""]
["Specify population coverage proportion (between 0 and 1)",null,null,null,"Leave only one field empty (delta, n, power)",null,null,null,"Oops, expecting LSL <= LAL and LAL < UAL",null,"  - MADS: mesh adapative direct searches (random patterns)",null,null,null,null,null,null,"   - specifications and target are used to perform","Number of retrospective observations to consider (= max no. of CP)","   - Choose a PERT evaluation mode",""]
["Hypothesized standard deviation must be > 0",null,null,null,"Problem with selection of means",null,null,null,"Oops, expecting LAL < UAL and UAL <= USL",null,"  - Nelder-Mead: simplex lattices direct search",null,null,null,null,null,null,"      a classical capacility analysis with simulation results","Keep at least 80% of R2X and neglect at most 2% of R2Y","       ~ average: use duration means (constant)",""]
["Add one percentile (between 0 and 100)",null,null,null,"P must be between 0 and 1",null,null,null,null,null,"  - Simulated annealing: direct search heuristic (variable neighbourhood)",null,null,null,null,null,null,"   - standard deviation is white noise amplitude to be added","Take all principal components","       ~ simulation : use random numbers (with variability)",""]
["Erase selected percentile",null,null,null,"There must be more observations than categories",null,null,null,null,null,"   - VNS : variable neighborhood search using latin hypercubes",null,null,null,null,null,null,"      to simulated values (RMSE, for example)","Precise the number (between 2 and no lags)","   - Tolerance: negligible slack time value (numerical 0)",""]
[null,null,null,null,null,null,null,null,"~ General topics",null,null,null,null,null,null,null,null,null,"Number of lags must be >= 2.","",""]
[null,null,null,null,null,null,null,null,"     - Data must be organized in columns",null,"Managed variable types",null,null,null,null,null,null,"Parameters for variables (X, Variables tab)","Number of principal components must be in [2, no lags].","Hint: why not save the configuration before running the analysis...",""]
[null,null,null,null,null,null,null,null,"     - one row = one observation tester-sample-measurement",null,"  - Continuous: all algorithms",null,null,null,null,null,null,"   - cell MUST NOT contain a formula","Warning: number of lags is less than (no obs)/2;  proceed anyway?"]
[null,null,null,null,null,null,null,null,"     - On graphical user form, grayed zones are optional",null,"  - Discret: evolutionary, MADS, simulated annealing, VNS",null,null,null,null,null,null,"   - lower and upper specifications are used to bound","Apply the Change Point Analysis procedure"]
[null,null,null,null,null,null,null,null,null,null,"  - Ordering: evolutionary, simulated annealing","",null,null,null,null,null,"      the range of generated values from distributions"]
[null,null,null,null,null,null,null,null,"~ Tab EXPERIMENT",null,null,null,null,null,null,null,null,"   - distribution is a mandatory property"]
[null,null,null,null,null,null,null,null,"     - Select all required data ranges",null,"Handling of bounds and constraints",null,null,null,null,null,null,"Random values: classical Monte-Carlo"]
[null,null,null,null,null,null,null,null,"     - Hint: select the three mandatory ranges using CTRL before opening module",null,"  - Bounds on variables : all excepted Fletcher-Reeves",null,null,null,null,null,null,"Latin hypercube: randomized uniform probabilities"]
[null,null,null,null,null,null,null,null,null,null,"  - Relaxable (inequality) constraints: evolutionary, MADS, simulated annealing, VNS"]
[null,null,null,null,null,null,null,null,"~ Tab PROCESS"]
[null,null,null,null,null,null,null,null,"     - May be used to specify historical data for comparison and simulation",null,"Use \"Parameters…\" tab to customize algorithmic settings"]
[null,null,null,null,null,null,null,null,"     - None: compare only to experimental variation",null,"This algorithm does not support constraints"]
[null,null,null,null,null,null,null,null,"     - Known values: specify known process mean and standard deviation",null,"This algortihm does not support bounds"]
[null,null,null,null,null,null,null,null,"     - Historical data: select a vertical range of data and estimate"]
[null,null,null,null,null,null,null,null,"          automatically process mean and standard deviation"]
[]
[null,null,null,null,null,null,null,null,"~ Tab REPORT"]
[null,null,null,null,null,null,null,null,"     - Minimal report (no checked option) contains variance decomposition,"]
[null,null,null,null,null,null,null,null,"          multi-vari chart and interaction plot"]
[null,null,null,null,null,null,null,null,"     - Repeatability and residuals: S control chart, normal quantile plot, etc."]
[null,null,null,null,null,null,null,null,"     - Comparison to total variation: measurement system quality diagnosis"]
[null,null,null,null,null,null,null,null,"     - Increment diagnosis: determine if increment is adequate"]
[null,null,null,null,null,null,null,null,"     - Risk analysis: estimate misclassification probabilities relative to taking a"]
[null,null,null,null,null,null,null,null,"          decision using measurement system.  Requires that specification limits"]
[null,null,null,null,null,null,null,null,"          and acceptance limits (if different of specifications) are defined."]
[null,null,null,null,null,null,null,null,"          Note: it is assumed that LSL <= LAL < UAL <= USL."]

{"sheet":"guitexts_en","index":5,"n_rows":53,"n_cols":22,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Univariate analyzes","ImR decision rules","Statistical distributions","Bivariate analyzes","Power and sample size calculations","Multivariate analyzes","Dynamic plot","Biplot settings","Measurement system analysis","Design of experiments","Black box optimization","Interval calculator","Workbook explorer","License manager","Advanced settings","CPA parameters","ImR & EWMA charts","Monte Carlo Simulation","Time series","PERT and Gantt Analyzes","Edit histogram","Stability analysis"]
["Data","Check the rules to apply:","Distribution","Data","Population type","Data",null,null,"Plan a MSA","Design specification","Problem","Mean","Worksheets utilities","Statistics, optimization and simulation",null,"Main procedure","Process parameters","Responses","Data:","Activities",null,"Data"]
["title in first cell","Point is outside of the control limits","Analysis","title in first cell","Means","Terms in model","Abscissa:",null,"Analyze","Factorial","Solver","Standard deviation","Workbook explorer",{"$f":"Notes!D23","v":"Différence GCS Inc."},"Confidence level","Mandatory settings","From dataset","Variables","title in first cell","Selected activity",null,"title in first cell"]
["Date / label","2 out of 3 in zone A or beyond","Charts","Exclude","1 group","title in first cell","Ordinate:","Components:","Testers","Filling","Settings…","Proportion","Setup or print active sheet","Server response:","Convergence (precision)","No. iterations","Forced values","Simulation","Date / label","Description:","Specify intervals definition","Exclude"]
["Exclude","4 out of 5 in zone B or beyond","Histograms categories","X1 (or X)","2 groups","Date / label","Title:","Display:","Samples","Other","Type (1=Min  2=Max)","Confidence level","Send active sheet by email","Expiration","Prefered language","Confidence level","Chart parameters","Properties:","Exclude","Activity duration","Minimum","Confidence level"]
["Categories","6 points increasing or decreasing","Distribution (histogram) ","X2 (or Y)","K groups","Exclude","Connect points","Abscissa:","Tables of trials","Number of levels","Objective  (formula cell)","no. Observations","First sheet","Instance","Integer value >=2 required!","Shortest segment","Smooth from:","Elements to include in report:","Go!","Distribution:","Stepsize","Shortest segment"]
["Weights","9 pts on the same side of the mean","Cumulative distribution","Go!","Known parameters","Empty list = all main effects","Straight line trend","Ordinate:","Randomize trials","Reduction factor","Variables  (vertical range)","Calculate","Previous sheet","Buy or renew license","Protect report","Print CP summary","1st obs","Number of points","Autocorrelation detection","Predecessors","Maximum","Low |r| threshold"]
["Subcategories","Marker size","Quantile plot","Paired observations","Alpha level","Experiment and simulate",null,"Both","Number of replicates","Number of central points","Lower bounds  (vert. range / value)","Close","Next sheet","Password","Apply","Backward elimination","Mean","Report","Periodic signals detection","Progress (%) :","Definition of histogram limits failed","Hide X with high p-values"]
["Test on a mean",null,"Number of points:","Means comparison","Std. Dev.","Go!","Class:","Label loadings","Number of responses (Y)","Latin hypercube:  no. points =","Upper bounds  (vert. range / value)","Decimals","Last sheet","License details","Printer ready report","Activate","Difference to detect (multiple of sigma)","Capability study of responses","No. terms","Apply changes","Number of divisions:","Number of iterations"]
["Autocorrelation test",null,"Print generated values","Confidence level","Solve for…","All Xs","Variable:","Label scores","Generate!","Design to be optimized","Perform initial exploratory search","Reset","Include hidden sheets",{"$f":"Notes!D24","v":"licenses@difference-gcs.com"},"Value for…",null,"Approximated ARL","Histograms (reponses & variables)","Diagnosis","Parameters",null,"XXX profile"]
["Histogram",null,"Data:","Unequal variances (if 2 groups)","Diff. to detect","Remove",null,"Connect scores","Total number of runs: ","Read…","Number of points","Cp or Pp","List alphabetically sorted",{"$f":"Notes!D5","v":"Différence"},"Label for…",null,null,"Trials values","No. significant periods","Average duration only",null,"Median during XXX stable periods"]
["Synonyms: mosaic plot, crossed Pareto, Marimekko chart",null,"Go!","Average difference","Sample size","Cross",null,null,"Report","Number of iterations","Algorithm:","Cpk or Ppk","Hidden sheets","Refresh","Range for…",null,null,"Go!","Exponential smoothing","Monte-Carlo simulation",null,"Options"]
["ImR / EWMA chart",null,"Sample","Average difference within ","Power","Square",null,null,"Experiment","Exploratory screening-filling","Assumption on variables:","Confidence interval (mean)","Alphabetical sort  ","Acquire","Numeric value needed!",null,null,"At least one response (Y) is required.","Period or season","Number of iterations",null,"<< Back"]
["Determine quantile values:",null,"Fit","Precision (±) (on mean diff.)","Solve","Diagnoses",null,null,"Response","Central composite","real","Confidence interval (standard deviation)","Windows Calculator","Release","Positive value required!",null,null,"At least one variable (X) is required.","Forecast horizon","Tolerance on slack times",null,"No significant X to report! Try to uncheck that option...."]
["Normal quantile plot",null,"Compare","Simple regression","Close","PCA/PLS",null,null,"title in first cell","No. replicates:","integer","Confidence interval (proportion)","Insert a date into selected cell…","Help","Positive integer required!",null,null,"Variables importance","Known constants","Activities summary table",null,"Go!"]
["Box plot",null,"Assume positive values only","Linear","In a balanced plan, the sample size of one population is n/k, where n is the total sample size and k is the number of groups.","Regression",null,null,"Exclude","Randomize table","ordering","Confidence interval (Cp or Pp)",null,"Problem with server connectivity!","Integer value required!",null,null,"MonteCarlo: generating values","Level","Gantt chart",null,"Variable (click on it!)"]
["Go!",null,"Select an analysis mode!","Compare means",null,"Univariate summaries",null,null,"Contribution to total variation","Number of trials =","Solve","Confidence interval (Cpk or Ppk)",null,"User's license is valid","Value should be in: ",null,null,"evaluating model","Trend","Total duration statistics",null,"r (medians)"]
["Test on a std. dev.",null,null,"Group names in X1",null,"Eigenvalues of X",null,null,"Short term","Generate","Enable iterations log","Tolerance interval of a population",null,"Disclaimer","Field is empty!",null,null,"generating report","Seasonality","Go!",null,"p-value of r"]
["Moving range chart",null,null,"If more than 2 groups:",null,"Multicolinearity test",null,null,"Long term","Optimize design","Quantitative:",null,null,"Could not find a valid license",null,null,null,"Please define cell for ","Autoregressive PLS","The activity cannot be its own predecessor",null,"DY / DX"]
["Pareto analysis",null,null,"Sort means",null,"Outliers test",null,null,"Known values","Report options","Nominal:",null,null,"License successfully released",null,null,null,": cell must have a formula","Detect changes in the mean","This activity is already in the list",null,"Similarity"]
["Tolerance interval",null,null,"All pairs comparison",null,"PCA & PLS models:",null,null,"Historical data","Design diagnosis","Unbounded radius",null,null,"Specify group, instance and password!",null,null,null,": please revise specifications","Simple","This activity code does not exist",null,"Correlated variables"]
["Graphs",null,null,"Simplified reports",null,"R2cumul X",null,null,"Delta =","Doehlert uniform shell","Constraints  (vert. range  g(x))",null,null,"Cluster",null,null,null,": cell must not have a formula","Double","Activity code (letter(s) in left pane)",null,"Filter Xs with too many missing values"]
["Analyzes",null,null,"Density ellipse",null,"R2cumul X and Y",null,null,"Repeatability and residuals plots",null,"Constraints  (vert. range  a)",null,null,null,null,null,null,"Please define a distribution for ","Seasonal","Failed: define duration (statistical distribution)",null,"Missing fraction limit"]
["Quantiles",null,null,"Nonlinear",null,"Number of PCs:",null,null,"Analyze!",null,"(Double-click on a property to edit)",null,null,null,null,null,null,"Parameters","No.. Lags","Total duration"]
["Capability study",null,null,"Correlation",null,null,null,null,"Risk analysis",null,"Bounds   l <= x <= u",null,null,null,null,null,null,"Random values","Exp. smoothing","Advancement curves"]
["Lower spec.",null,null,"Print residuals",null,null,null,null,"Increment diagnosis",null,"Constraints   g(x)<=a",null,null,null,null,null,null,"Latin hypercube","Residuals analysis","Time since project start"]
["Target",null,null,"Generate formulas",null,"Model diagnosis charts",null,null,"Process",null,"This property is not requiered",null,null,null,null,null,null,null,"Confidence level","Advancement (%)"]
["Upper spec.",null,null,"Residuals analysis",null,"Distances (DModX/DModY)",null,null,"Total measurement",null,"? = required, to be defined     --- = not required",null,null,null,null,null,null,"Sampling method","PC selection strategy:","Early start"]
["Simplified table (only the %)",null,null,"Model:",null,"Prediction formulas",null,null,"Repeatability",null,"Minimize",null,null,null,null,null,null,": revise distribution parameters","Automatic","Late start"]
["Sort results by:",null,null,null,null,"Y transform:",null,null,"Reproductibility",null,"Maximize",null,null,null,null,null,null,"(pick from list)","All","Slack"]
["Descending values",null,null,null,null,"Regression summary",null,null,"Interaction",null,null,null,null,null,null,null,null,"Percentiles","PC 1 to … ","Number of decimals:"]
["Alphabetical labels",null,null,null,null,"Rows diagnostics and graphs",null,null,"Measurement variation",null,null,null,null,null,null,null,null,"Quantiles",null,"Duration"]
[null,null,null,null,null,"Residuals",null,null,"No data",null,null,null,null,null,null,null,null,null,null,"Completed"]
[null,null,null,null,null,"Formula",null,null,"Experiment",null,null,null,null,null,null,null,null,null,null,"Remaining"]
[null,null,null,null,null,"Cook's distance",null,null,"Intraclass correlation (process R2)"]
[null,null,null,null,null,null,null,null,"Measurement quality"]
[null,null,null,null,null,null,null,null,"I = excellent,   IV = poor"]
[null,null,null,null,null,null,null,null,"Number of distinct categories"]
[null,null,null,null,null,null,null,null,"Measurement increment"]
[null,null,null,null,null,null,null,null,"Increment"]
[null,null,null,null,null,null,null,null,"Probable error"]
[null,null,null,null,null,null,null,null,"Minimal increment"]
[null,null,null,null,null,null,null,null,"Maximal increment"]
[null,null,null,null,null,null,null,null,"\"sufficient\""]
[null,null,null,null,null,null,null,null,"\"not sufficient\""]
[null,null,null,null,null,null,null,null,"Monte-Carlo simulation:"]
[null,null,null,null,null,null,null,null,"iterations"]
[null,null,null,null,null,null,null,null,"Specification"]
[null,null,null,null,null,null,null,null,"Acceptance"]
[null,null,null,null,null,null,null,null,"Lower"]
[null,null,null,null,null,null,null,null,"Upper"]
[null,null,null,null,null,null,null,null,"Limits:"]
[null,null,null,null,null,null,null,null,"(errorless measurement)"]

{"sheet":"texts_en","index":6,"n_rows":107,"n_cols":32,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
["No analysis to perform.",null,null,"Descriptive summary",null,null,null,"Nom","param1","param2","param3",null,null,"Module","Name","Group","Actif",null,null,"Algorithmes","Evolutionary",null,"Fletcher-Reeves",null,"MADS",null,"Nelder-Mead",null,"Simulated Annealing",null,"VNS"]
["No data in this range.",null,null,"No. obs.",null,null,1,"Constant","Value",null,null,null,{"$f":"texts_fr!M2","v":"M_UNI"},{"$f":"texts_fr!N2","v":1},"Univariate analyzes","Analysis modules",{"$f":"texts_fr!Q2","v":true},null,null,"Evolutionary","Population size",-1,"Numeric gradient stepsize",6.0559999999999997E-7,"Activate line searching (0 or 1)",1,"Initial simplexe size",0.5,"No. points neighborhood (-1=auto)",-1,"Line pursuit steps (0=none, 100=max)",25]
["Column data expected.",null,null,"Average",null,null,2,"Bernouilli","ProbValue1","Value1","Value2",null,{"$f":"texts_fr!M3","v":"M_IMR"},{"$f":"texts_fr!N3","v":2},"ImR decision rules","Additional tools",{"$f":"texts_fr!Q3","v":true},null,null,"Fletcher-Reeves","Crossover probability (0-1)",0.5,"Line search initial step size",0.1,"Initial mesh size",0.2,"Final simplexe size",9.9999999999999995E-7,"Max. escape probability (0..1)",0.5,"Init. neighborhood size",0.5]
["Specify upper left cell for printing.",null,null,"Std. dev.",null,null,3,"Exponential","Offset","Mean",null,null,{"$f":"texts_fr!M4","v":"M_DISTR"},{"$f":"texts_fr!N4","v":3},"Statistical distributions","",{"$f":"texts_fr!Q4","v":true},null,null,"MADS","Maximal mutation rate (0-1)",0.25,"Gradient norm tolerance",9.9999999999999995E-7,"Final mesh size",9.9999999999999995E-7,"Max. evaluations",10000,"Neighborhood expansion factor (2..10)",3,"Final neighborhood size",9.9999999999999995E-7]
["No printable data.",null,null,"Sigma ImR",null,null,4,"Laplace","Mode","Mean",null,null,{"$f":"texts_fr!M5","v":"M_BIV"},{"$f":"texts_fr!N5","v":4},"Bivariate analyzes","Simple regression",{"$f":"texts_fr!Q5","v":true},null,null,"Nelder-Mead","Unbounded search radius",10,"Max. evaluations",10000,"Max. evaluations",10000,null,null,"Init. neighborhood size",1,"Neighborhood expansion factor (2..10)",4]
["No evidence of autocorrelation",null,null,"Minimum",null,null,5,"Lognormal","Offset","Mean","Std. dev.",null,{"$f":"texts_fr!M6","v":"M_POW"},{"$f":"texts_fr!N6","v":5},"Power and sample size","",{"$f":"texts_fr!Q6","v":true},null,null,"Simulated Annealing","Max. unsuccessful generations",50,null,null,null,null,null,null,"Final neighborhood size",9.9999999999999995E-7,"Max. evaluations",10000]
["Negative autocorrelation",null,null,"Median",null,null,6,"Normal","Mean","Std. dev.",null,null,{"$f":"texts_fr!M7","v":"M_MULTI"},{"$f":"texts_fr!N7","v":6},"Multivariate analyzes",null,{"$f":"texts_fr!Q7","v":true},null,null,"VNS","Max. evaluations",20000,null,null,null,null,null,null,"Max. evaluations",10000]
["Positive autocorrelation",null,null,"Maximum",null,null,7,"Pareto","Scale","Shape","Bound (0=none)",null,{"$f":"texts_fr!M8","v":"M_DYN"},{"$f":"texts_fr!N8","v":7},"Dynamic plot","",{"$f":"texts_fr!Q8","v":true}]
["Select a distribution!",null,null,"Confidence interval (on mean)",null,null,8,"Poisson","Offset","Mean","Scale",null,{"$f":"texts_fr!M9","v":"M_BIP"},{"$f":"texts_fr!N9","v":8},"Biplot settings","",{"$f":"texts_fr!Q9","v":true}]
["Specify all required parameters",null,null,"Confidence level",null,null,9,"Triangular","Minimum","Mode","Maximum",null,{"$f":"texts_fr!M10","v":"M_MSA"},{"$f":"texts_fr!N10","v":9},"Analyze a MSA",null,{"$f":"texts_fr!Q10","v":true}]
["Specify the number of points",null,null,"Precision (±)",null,null,10,"Uniform","Minimum","Maximum",null,null,{"$f":"texts_fr!M11","v":"M_DOE"},{"$f":"texts_fr!N11","v":10},"Design of Experiment",null,{"$f":"texts_fr!Q11","v":false}]
["Current selection is not valid",null,null,"Index",null,null,11,"Uniform-D","Minimum","Maximum",null,null,{"$f":"texts_fr!M12","v":"M_MC"},{"$f":"texts_fr!N12","v":11},"Monte Carlo Simulation",null,{"$f":"texts_fr!Q12","v":true}]
[{"$f":"Notes!D22","v":"Statistics, optimization and simulation addin by Différence"},null,null,"Label",null,null,12,"Weibull","Offset","Scale","Shape",null,{"$f":"texts_fr!M13","v":"M_OPTIM"},{"$f":"texts_fr!N13","v":12},"Optimization solver",null,{"$f":"texts_fr!Q13","v":true}]
["Specify mu",null,null,"Value",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M14","v":"M_PAR"},{"$f":"texts_fr!N14","v":13},"Advanced settings","Settings",{"$f":"texts_fr!Q14","v":true}]
["Selection of multiple ranges is not permited",null,null,"Lower limit",null,null,null,null,null,null,null,null,"M_HELP",{"$f":"texts_fr!N15","v":14},"Help and tips",null,{"$f":"texts_fr!Q15","v":true}]
["Help file not found!",null,null,"Target",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M16","v":"M_XPLOR"},{"$f":"texts_fr!N16","v":15},"Workbook explorer","",{"$f":"texts_fr!Q16","v":true}]
["Periods: ",null,null,"Upper limit",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M17","v":"M_RESET"},{"$f":"texts_fr!N17","v":16},"Reset","",{"$f":"texts_fr!Q17","v":true}]
["Empty selection!",null,null,"CUSUM",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M18","v":"M_LIC"},{"$f":"texts_fr!N18","v":17},"Licenses","",{"$f":"texts_fr!Q18","v":true}]
["Pick a range/cell for ",null,null,"Interval",null,null,null,null,null,null,null,null,"M_HIST",18,"Edit histogram",null,{"$f":"texts_fr!Q19","v":true}]
["Specify value of ",null,null,"Frequency",null,null,null,null,null,null,null,null,"M_INTER",19,"Interval calculator",null,{"$f":"texts_fr!Q20","v":true}]
["Inequal variances",null,null,"Autocorrelation test",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M21","v":"M_PARETO"},{"$f":"texts_fr!N21","v":20},"Pareto Analysis",null,{"$f":"texts_fr!Q21","v":true}]
["No proof of variance unequality",null,null,"Patterns ratio",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M22","v":"M_EMAIL"},{"$f":"texts_fr!N22","v":21},"Send this sheet by email",null,{"$f":"texts_fr!Q22","v":true}]
["Select a variance assumption",null,null,"Limits",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M23","v":"M_PRINT"},{"$f":"texts_fr!N23","v":22},"Print this sheet",null,{"$f":"texts_fr!Q23","v":true}]
["Data import problem",null,null,"Normal quantile",null,null,null,null,null,null,null,null,{"$f":"texts_fr!M24","v":"M_TIME"},{"$f":"texts_fr!N24","v":23},"Time series",null,{"$f":"texts_fr!Q24","v":true}]
["Y transformation has failed",null,null,"Quality of fit",null,null,null,null,null,null,null,null,"VIEWSHEET",24,"View sheet…      ","Worksheets utilities",{"$f":"texts_fr!Q25","v":true}]
["Non-negligible multicolinearity if kappa>5",null,null,"Data",null,null,null,null,null,null,null,null,"M_PERT",25,"PERT and Gantt Analyzes",null,{"$f":"texts_fr!Q26","v":false}]
["Non-negligible multicolinearity if VIF>5",null,null,"Theoritical",null,null,null,null,null,null,null,null,"M_STABL",26,"Stability Analysis",null,true]
["Orthogonalize design?",null,null,"Variable:",null,null,null,null,null,null,null,null,"M_CONTING",27,"Contingency Analysis",null,true]
["At least 2 components are required",null,null,"Test on a mean"]
["Too many levels",null,null,"T Score"]
["At least 2 variables are required",null,null,"p-value"]
["Design resolution: ",null,null,"Evaluations = "]
["At least one spec is required",null,null,"Tolerance = "]
["Not enough testers or samples",null,null,"Constraint"]
["Specify number of testers",null,null,"Compare two means"]
["Specify number of samples",null,null,"Variances assumption:",null,"Pour les trasnformations"]
["Specify number of variables",null,null,"equal",null,"Y"]
["This version of Excel is not supported.",null,null,"unequal",null,"1/Y"]
["All changes will be effective on next Excel launching",null,null,"bootstrap",null,"ln(Y)"]
["Warning: sheet(s) removal is definitive. Continue?",null,null,"avrg(X2)-avrg(X1)",null,"√Y"]
["Cells with a green background are editable",null,null,"Univariate summary",null,"Y²"]
["Categories not having similar letters have significantly different means.",null,null,"Model parameters",null,"exp(Y)"]
["Specify sigma",null,null,"X-block",null,"Box-Cox"]
["Your Différence license will expire in ### days. You should start renewing it!",null,null,"Y-block"]
["Your Différence license expired recently. You should renew it!",null,null,"F Score",null,"Modèles non-linéaires"]
["Intercept",null,null,"Transformation on Y :",null,"Y = a(X^b)",2]
["Yes",null,null,"Predictions",null,"Y = a+b^X",2]
["No",null,null,"Residuals",null,"Y = a+b*exp(c*X)",3]
["Clear and reset form?",null,null,"Rank",null,"Y = a+b*X/(c+X)",3]
["Download it from the website?",null,null,"Test on variances",null,"Y = 1/(a+b*X)",2]
["Invalid confidence level (must be between 0 and 1)",null,null,"Distinct categories",null,"Y = 1/(a+b*X+c*X^2)",3]
["Unavailable valid licence",null,null,"Difference",null,"Y = 1/(a+b*X)^c",3]
["Selection in another workbook is not allowed!",null,null,"Influential obs.",null,"Y = 1/(1+exp(a+b*X))",2]
["Warning! ###% of the observations were rejected because of missing values.",null,null,"Normalized Cook's distance",null,"Y = a+b/(1+exp(c+d*X))",4]
[null,null,null,"Model structure",null,"Y = a+b*(1-exp(-(X/c)^d))",4]
[null,null,null,"Relative Pratt index",null,"Y = a+b*tanh(c+d*X))",4]
[null,null,null,"Dynamic plot"]
[null,null,null,"Principal components"]
[null,null,null,"Eigenvalues"]
[null,null,null,"Outliers"]
[null,null,null,"Normalized distances"]
[null,null,null,"Multicolinearity detection"]
[null,null,null,"% of total variance"]
[null,null,null,"Factors"]
[null,null,null,"Lower bounds"]
[null,null,null,"Upper bounds"]
[null,null,null,"Weights:"]
[null,null,null,"Summation"]
[null,null,null,"Specifications"]
[null,null,null,"Cumul. prob."]
[null,null,null,"Report"]
[null,null,null,"Histogram"]
[null,null,null,"ImR Chart"]
[null,null,null,"EWMA Chart"]
[null,null,null,"% outside spec."]
[null,null,null,"Capability"]
[null,null,null,"Total"]
[null,null,null,"Probabilities"]
[null,null,null,"Rejecting a bad item"]
[null,null,null,"Rejecting a good item"]
[null,null,null,"Accepting a bad item"]
[null,null,null,"Accepting a good item"]
[null,null,null,"Taking a good decision"]
[null,null,null,"Average precision (±, 95% confidence)"]
[null,null,null,"Consumer risk"]
[null,null,null,"Producer risk"]
[null,null,null,"Term is very influent when "]
[null,null,null,"Screening design"]
[null,null,null,"Design resolution"]
[null,null,null,"Signif. lags:"]
[null,null,null,"new name"]
[null,null,null,"Average within "]
[null,null,null,"Cell"]
[null,null,null,"Cell containing: "]
[null,null,null,"Moving ranges"]
[null,null,null,"Test on a standard deviation"]
[null,null,null,"X2 score"]
[null,null,null,"Box plot"]
[null,null,null,"Deg. freedom"]
[null,null,null,"Lag"]
[null,null,null,"Period"]
[null,null,null,"Contrib. to total variation (%)"]
[null,null,null,"Tolerance interval"]
[null,null,null,"All pairs comparison (Tukey-Kramer HSD)"]
[null,null,null,"Parameters"]
[null,null,null,"Observations"]
[null,null,null,"S chart"]