{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Hypothèses","Tables"],"not_rendered":{"charts":0,"images":1,"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":"Hypothèses","index":0,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Instructions\n1. Listez tous les binômes de besoins non satisfaits avec les publics ou clientèles qui les ressentent\n2. Evaluez pour chaque binôme le degré de conscience que le public a sur le besoin\n3. Evaluez ensuite la pertinence, c'est-à-dire l'impact provoqué en satisfaisant le besoin\n4. Evaluez la disponibilité économique des publics\n5. Evaluez enfin la taille du marché concernant ce public\n6. Réordonnez le tableau en ordre descendant de score\n7. Validez en premier les hypothèses des binômes \"besoin x public\" avec le plus haut score en premier"]
["Besoin non satisfait","Public / clientèle","Conscience","Pertinence","Disponibilité économique","Marché","C","P","D","M","Score"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C3,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D3,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E3,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F3,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(OR(C3=\"\",D3=\"\",E3=\"\",F3=\"\"), 0,(G3*H3*I3*J3)/256)","v":0}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C4,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D4,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E4,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F4,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C5,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D5,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E5,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F5,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C6,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D6,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E6,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F6,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C7,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D7,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E7,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F7,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C8,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D8,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E8,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F8,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C9,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D9,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E9,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F9,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C10,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D10,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E10,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F10,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C11,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D11,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E11,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F11,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C12,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D12,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E12,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F12,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C13,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D13,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E13,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F13,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C14,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D14,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E14,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F14,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C15,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D15,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E15,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F15,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C16,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D16,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E16,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F16,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C17,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D17,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E17,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F17,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C18,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D18,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E18,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F18,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C19,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D19,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E19,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F19,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C20,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D20,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E20,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F20,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C21,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D21,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E21,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F21,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C22,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D22,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E22,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F22,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C23,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D23,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E23,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F23,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C24,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D24,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E24,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F24,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C25,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D25,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E25,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F25,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C26,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D26,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E26,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F26,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C27,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D27,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E27,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F27,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C28,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D28,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E28,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F28,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C29,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D29,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E29,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F29,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C30,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D30,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E30,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F30,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C31,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D31,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E31,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F31,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C32,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D32,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E32,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F32,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C33,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D33,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E33,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F33,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C34,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D34,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E34,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F34,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C35,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D35,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E35,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F35,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C36,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D36,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E36,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F36,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C37,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D37,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E37,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F37,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C38,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D38,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E38,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F38,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C39,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D39,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E39,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F39,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C40,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D40,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E40,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F40,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,null,null,null,null,null,{"$f":"VLOOKUP(C41,Tables!$A$2:$B$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(D41,Tables!$C$2:$D$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(E41,Tables!$E$2:$F$5,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F41,Tables!$G$2:$H$5,2,FALSE)","v":{"$error":"#N/A"}},0]

{"sheet":"Tables","index":1,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,7]]}
["Conscience",null,"Pertinence",null,"Disponibilité écon.",null,"Marché"]
["Très faible",1,"Faible",1,"Faible",1,"Très petit",1]
["Faible",2,"Moyenne",2,"Moyenne",2,"Petit",2]
["Moyenne",3,"Forte",3,"Bonne",3,"Moyen",3]
["Forte",4,"Très forte",4,"Très bonne",4,"Grand",4]