{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Données démo. concurrents","Analyse des concurrents"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Données démo. concurrents","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"merged":[[2,1,2,2]]}
[]
[null,"NOM DE L’ENTREPRISE | DONNÉES DÉMOGRAPHIQUES DES CONCURRENTS"]
[null,"Analyse des concurrents"]
[null,"NOM DU CONCURRENT","TAILLE DE L’ENTREPRISE","ANNÉES D’ACTIVITÉ","EMPLOYÉS","USINES","POINTS DE VENTE","PROPRIÉTÉ","GOUVERNANCE D’ENTREPRISE","STRUCTURE","NOTES"]
[null,"Concurrent 1","Petite",10,100,1,19,"Privée","Oui","Propriété exclusive","Mes notes"]
[null,"Concurrent 2","Grande",15,2050,5,30,"Publique",null,"Corporation C"]
[null,"Concurrent 3","Petite",7,455,2,10,"Privée",null,"Compagnie à responsabilité limitée"]
[null,"Concurrent 4","Moyenne",10,807,2,14,"Privée",null,"Corporation S"]
[null,"Concurrent 5","Grande",18,1202,4,28,"Publique",null,"Corporation C"]

{"sheet":"Analyse des concurrents","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"merged":[[2,1,2,2],[3,1,3,2]]}
[]
[null,{"$f":"LEFT('Données démo. concurrents'!B2,FIND(\"|\",'Données démo. concurrents'!B2))&\" ANALYSE DES CONCURRENTS\"","v":"NOM DE L’ENTREPRISE | ANALYSE DES CONCURRENTS"}]
[null,"Données démographiques des concurrents"]
[null,"     Utilisez cette échelle pour évaluer chaque concurrent :     ",null,"0  Aucune pertinence ","1  Pertinence minimale","2  Faible pertinence","3  Pertinence modérée","4  Pertinence maximale"]
[null,"NOM DU CONCURRENT","POINTS DE VENTE","CHIFFRE D’AFFAIRES ANNUEL","COMPARATIF DES PRODUITS","PRIX DES PRODUITS","MARKETING","COÛT DE PRODUCTION","TAUX D’EXPANSION","LEADERSHIP","DISTRIBUTION","FOURNISSEURS","CAPITAL-RISQUE","BESOINS DU MARCHÉ","TOTAUX"]
[null,"Concurrent 1",2,3,1,2,3,1,0,3,3,3,0,2,{"$f":"SUM(Analyse[[#This Row],[POINTS DE VENTE]:[BESOINS DU MARCHÉ]])","v":23}]
[null,"Concurrent 2",1,4,3,3,2,0,3,1,0,0,4,1,{"$f":"SUM(Analyse[[#This Row],[POINTS DE VENTE]:[BESOINS DU MARCHÉ]])","v":22}]
[null,"Concurrent 3",2,3,2,1,4,4,3,2,2,1,1,2,{"$f":"SUM(Analyse[[#This Row],[POINTS DE VENTE]:[BESOINS DU MARCHÉ]])","v":27}]
[null,"Concurrent 4",2,4,4,0,1,1,2,1,4,4,3,4,{"$f":"SUM(Analyse[[#This Row],[POINTS DE VENTE]:[BESOINS DU MARCHÉ]])","v":30}]
[null,"Concurrent 5",4,0,4,2,4,2,1,3,4,4,2,3,{"$f":"SUM(Analyse[[#This Row],[POINTS DE VENTE]:[BESOINS DU MARCHÉ]])","v":33}]
[null,"MOYENNES",{"$f":"IFERROR(SUBTOTAL(101,Analyse[POINTS DE VENTE]),\"\")","v":2.2},{"$f":"IFERROR(SUBTOTAL(101,Analyse[CHIFFRE D’AFFAIRES ANNUEL]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analyse[COMPARATIF DES PRODUITS]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analyse[PRIX DES PRODUITS]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,Analyse[MARKETING]),\"\")","v":2.8},{"$f":"IFERROR(SUBTOTAL(101,Analyse[COÛT DE PRODUCTION]),\"\")","v":1.6},{"$f":"IFERROR(SUBTOTAL(101,Analyse[TAUX D’EXPANSION]),\"\")","v":1.8},{"$f":"IFERROR(SUBTOTAL(101,Analyse[LEADERSHIP]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,Analyse[DISTRIBUTION]),\"\")","v":2.6},{"$f":"IFERROR(SUBTOTAL(101,Analyse[FOURNISSEURS]),\"\")","v":2.4},{"$f":"IFERROR(SUBTOTAL(101,Analyse[CAPITAL-RISQUE]),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IFERROR(SUBTOTAL(101,Analyse[BESOINS DU MARCHÉ]),\"\")","v":2.4},{"$f":"SUBTOTAL(101,Analyse[TOTAUX])","v":{"v":27,"d":"27.0"}}]