{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Quelle decision (2)","Quelle decision","criteres","importance"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Quelle decision (2)","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"hidden":true,"merged":[[0,1,0,11],[2,1,2,2]]}
[null,"MAIS QUE CHOISIR ?"]
[]
[null,"Est-ce que cet item a de l'importance ?"]
[]
[null,null,"Notez son importance",null,null,"Comparez vos projets => ","Administratif Seine et marne","Dev Montpellier","Projet3","Projet4","Projet5","Projet6"]
[null,"Lieu [transport, culture, intérêt…]",{"v":0.75,"d":"75%"},{"$f":"C6/$C$19","v":{"v":0.10080645161290325,"d":"10%"}},null," 10 : idéal ….... 0 : mal localisé =>",3,10]
[null,"Climat : [canicule / inondation}",{"v":0.75,"d":"75%"},{"v":0.10080645161290325,"d":"10%"},null,"10 : idéal ….... 0 : trop risqué =>",7,4]
[null,"Surface habitable",{"v":0.6,"d":"60%"},{"v":0.08064516129032259,"d":"8%"},null," 10 : idéale …..... 0 : trop petite =>",7,6]
[null,"Jardin",{"v":0.5,"d":"50%"},{"v":0.06720430107526883,"d":"7%"},null," 10 : idéal …..... 0 : inexistant =>",7,4]
[null,"Prix [endettement}",{"v":0.75,"d":"75%"},{"v":0.10080645161290325,"d":"10%"},null,"10 : sans endettement …. Fort endettement =>",8,2]
[null,"Temps libre pour projet personnel",{"v":0.7,"d":"70%"},{"v":0.09408602150537636,"d":"9%"},null,"10 : temps lible ….... 0 : pas de temps libre =>",5,7]
[null,"Epanouissement personnel",{"v":0.99,"d":"99%"},{"v":0.13306451612903228,"d":"13%"},null,"10 : fort ….... 0 : faible =>",6,8]
[null,"Epanouissement professionnel",{"v":0.6,"d":"60%"},{"v":0.08064516129032259,"d":"8%"},null,"10 : fort ….... 0 : faible =>",3,7]
[null,"Intérêt du travail",{"v":0.6,"d":"60%"},{"v":0.08064516129032259,"d":"8%"},null,"10 : fort ….... 0 : faible =>",3,7]
[null,"Salaire",{"v":0.6,"d":"60%"},{"v":0.08064516129032259,"d":"8%"},null,"10 : fort ….... 0 : faible =>",7,5]
[null,"Avantages en nature",{"v":0.3,"d":"30%"},{"v":0.040322580645161296,"d":"4%"},null,"10 : très intéressant….... 0 : inexistant =>",5,4]
[null,"Avantages en nature",{"v":0.3,"d":"30%"},{"v":0.040322580645161296,"d":"4%"},null,"10 : très intéressant….... 0 : inexistant =>",5,4]
[{"$nulls":5},"Visualisez les notes =>",{"$f":"G6*$D6+G7*$D7+G8*$D8+G9*$D9+G10*$D10+G11*$D11+G12*$D12+G13*$D13+G14*$D14+G15*$D15+G17*$D17","v":{"v":5.368279569892474,"d":"5.37"}},{"v":5.78225806451613,"d":"5.78"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,{"$f":"SUM(C6:C18)","v":7.439999999999999},{"$f":"SUM(D6:D18)","v":{"v":1.0000000000000002,"d":"100%"}}]

{"sheet":"Quelle decision","index":1,"n_rows":21,"n_cols":13,"rows_kept":21,"merged":[[0,2,0,12],[2,1,3,12],[5,2,5,3]]}
[null,null,"UN PEU D'AIDE POUR CHOISIR ?"]
[]
[null,"Tout d'abord, choisissez les critères qui vont vous permettre de faire votre choix entre différents projets. Par exemple s'il s'agit de choisir entre deux jobs, vous pouvez sélectionner des critères purement professionnels comme : l'intérêt du poste,  le salaire, le temps de travail, mais également des critères environnementaux ou de localisation.... Si vous pensez déménager alors les critères de localisation ou de surface habitable risquent plus certainement de faire la différence! "]
[]
[]
[null,"Famille de critère","Quelle est l'importance de ce critère dans votre choix ?"]
[]
[{"$nulls":3},"Evaluer son importance",{"$nulls":3},"\nNommez vos projets =>\n\npuis notez son poids en fonction de l'échelle associée ci-dessous ","Travail1 : Assistante de direction Paris 8","Secretaire à Monbeau Village sur Seine","Projet3","Projet4","Projet5"]
[null,"Dev_professionnel","Epanouissement professionnel","important",{"$f":"IF(ISERROR(VLOOKUP(D9,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D9,importance!$A$2:$B$8,2,FALSE))","v":{"v":0.75,"d":"75%"}},{"$f":"IF(E9=0,0,E9/$E$21)","v":{"v":0.19230769230769232,"d":"19%"}},null,{"$f":"IF(ISERROR(VLOOKUP(C9,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C9,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":"0-inexistant … => 10-parfait"},10,6]
[null,"Dev_professionnel","Rémunération","moyennement important",{"$f":"IF(ISERROR(VLOOKUP(D10,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D10,importance!$A$2:$B$8,2,FALSE))","v":{"v":0.5,"d":"50%"}},{"v":0.12820512820512822,"d":"13%"},null,{"$f":"IF(ISERROR(VLOOKUP(C10,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C10,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":"0-faible…=>10-forte"},10,4]
[null,"Lien familial","Prise en compte des personnes à charge","primordiale",{"$f":"IF(ISERROR(VLOOKUP(D11,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D11,importance!$A$2:$B$8,2,FALSE))","v":{"v":1,"d":"100%"}},{"v":0.25641025641025644,"d":"26%"},null,{"$f":"IF(ISERROR(VLOOKUP(C11,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C11,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":"0-nulle…=>10-forte"},2,8]
[null,"Dev_personnel","Epanouissement personnel","très important",{"$f":"IF(ISERROR(VLOOKUP(D12,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D12,importance!$A$2:$B$8,2,FALSE))","v":{"v":0.9,"d":"90%"}},{"v":0.23076923076923078,"d":"23%"},null,{"$f":"IF(ISERROR(VLOOKUP(C12,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C12,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":"0-faible…=>10-fort"},7,8]
[null,"Dev_personnel","Temps libre pour des projets personnels","important",{"$f":"IF(ISERROR(VLOOKUP(D13,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D13,importance!$A$2:$B$8,2,FALSE))","v":{"v":0.75,"d":"75%"}},{"v":0.19230769230769232,"d":"19%"},null,{"$f":"IF(ISERROR(VLOOKUP(C13,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C13,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":"0-faible…=>10-fort"},3,7]
[{"$nulls":4},{"$f":"IF(ISERROR(VLOOKUP(D14,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D14,importance!$A$2:$B$8,2,FALSE))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},null,{"$f":"IF(ISERROR(VLOOKUP(C14,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C14,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(ISERROR(VLOOKUP(D15,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D15,importance!$A$2:$B$8,2,FALSE))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},null,{"$f":"IF(ISERROR(VLOOKUP(C15,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C15,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(ISERROR(VLOOKUP(D16,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D16,importance!$A$2:$B$8,2,FALSE))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},null,{"$f":"IF(ISERROR(VLOOKUP(C16,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C16,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(ISERROR(VLOOKUP(D17,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D17,importance!$A$2:$B$8,2,FALSE))","v":{"v":0,"d":"0%"}},{"$f":"IF(E17=0,0,E17/$E$21)","v":{"v":0,"d":"0%"}},null,{"$f":"IF(ISERROR(VLOOKUP(C17,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C17,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(ISERROR(VLOOKUP(D18,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D18,importance!$A$2:$B$8,2,FALSE))","v":{"v":0,"d":"0%"}},{"v":0,"d":"0%"},null,{"$f":"IF(ISERROR(VLOOKUP(C18,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C18,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":""}]
[{"$nulls":4},{"$f":"IF(ISERROR(VLOOKUP(D19,importance!$A$2:$B$8,2,FALSE)),0,VLOOKUP(D19,importance!$A$2:$B$8,2,FALSE))","v":{"v":0,"d":"0%"}},{"$f":"IF(E19=0,0,E19/$E$21)","v":{"v":0,"d":"0%"}},null,{"$f":"IF(ISERROR(VLOOKUP(C19,Tableau5[[#All],[Criteres]:[notation]],2,FALSE)),\"\",VLOOKUP(C19,Tableau5[[#All],[Criteres]:[notation]],2,FALSE))","v":""}]
[{"$nulls":7},"Visualisez les notes =>",{"$f":"(I9*$F9+I10*$F10+I11*$F11+I12*$F12+I13*$F13+I14*$F14+I15*$F15+I16*$F16+I17*$F17+I18*$F18+I19*$F19)","v":{"v":5.910256410256411,"d":"5.91"}},{"$f":"(J9*$F9+J10*$F10+J11*$F11+J12*$F12+J13*$F13+J14*$F14+J15*$F15+J16*$F16+J17*$F17+J18*$F18+J19*$F19)","v":{"v":6.910256410256411,"d":"6.91"}},{"$f":"(K9*$F9+K10*$F10+K11*$F11+K12*$F12+K13*$F13+K14*$F14+K15*$F15+K16*$F16+K17*$F17+K18*$F18+K19*$F19)","v":{"v":0,"d":"0.00"}},{"$f":"(L9*$F9+L10*$F10+L11*$F11+L12*$F12+L13*$F13+L14*$F14+L15*$F15+L16*$F16+L17*$F17+L18*$F18+L19*$F19)","v":{"v":0,"d":"0.00"}},{"$f":"(M9*$F9+M10*$F10+M11*$F11+M12*$F12+M13*$F13+M14*$F14+M15*$F15+M16*$F16+M17*$F17+M18*$F18+M19*$F19)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"SUM(E9:E20)","v":{"v":3.9,"d":"390%"}}]

{"sheet":"criteres","index":2,"n_rows":32,"n_cols":29,"rows_kept":32,"hidden":true}
["Famille","Criteres","notation",null,"preparation listes dependantes",null,"B9",null,"B10",null,"B11",null,"B12",null,"B13",null,"B14",null,"B15",null,"B16",null,"B17",null,"B18",null,"B19",null,"B20"]
["Dev_personnel","Accessibilité ces centres d'intérêt","0-inexistant … => 10-parfait",{"$nulls":3},{"$f":"INDIRECT(\"'Quelle decision'!\"&G1)","v":"Dev_professionnel"},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&I1)","v":"Dev_professionnel"},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&K1)","v":"Lien familial"},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&M1)","v":"Dev_personnel"},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&O1)","v":"Dev_personnel"},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&Q1)","v":0},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&S1)","v":0},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&U1)","v":0},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&W1)","v":0},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&Y1)","v":0},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&AA1)","v":0},null,{"$f":"INDIRECT(\"'Quelle decision'!\"&AC1)","v":0}]
["Dev_personnel","Communion avec son environnement","0-nulle… => 10-parfaite",null,{"$f":"_xlfn.UNIQUE(Tableau5[[#Headers],[Famille]])","v":"Famille"},null,"critere1",null,"critere2",null,"critere3",null,"critere4",null,"critere5",null,"critere6",null,"critere7",null,"critere8",null,"critere9",null,"critere10",null,"critere11",null,"critere12"]
["Dev_personnel","Epanouissement personnel","0-faible…=>10-fort",null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(Tableau5[Famille]))","v":"Autre"},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&G1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&G1)))","v":"Avantages en nature"},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&I1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&I1)))","v":"Avantages en nature"},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&K1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&K1)))","v":"Prise en compte des personnes à charge"},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&M1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&M1)))","v":"Accessibilité ces centres d'intérêt"},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&O1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&O1)))","v":"Accessibilité ces centres d'intérêt"},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&Q1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&Q1)))","v":""},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&S1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&S1)))","v":""},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&U1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&U1)))","v":""},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&W1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&W1)))","v":""},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&Y1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&Y1)))","v":""},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&AA1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&AA1)))","v":""},null,{"$f":"IF(ISERROR(_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&AC1))),\"\",_xlfn._xlws.FILTER(Tableau5[Criteres],Tableau5[Famille]=INDIRECT(\"'Quelle decision'!\"&AC1)))","v":""}]
["Dev_personnel","Facilité d'adaptation","0-faible…=>10-forte",null,"Dev_personnel",null,"Epanouissement professionnel",null,"Epanouissement professionnel",null,"Prise en compte des proches",null,"Communion avec son environnement",null,"Communion avec son environnement"]
["Dev_personnel","Importance du changement… de vie recherché","0-faible…=>10-forte",null,"Dev_professionnel",null,"Intérêt du travail",null,"Intérêt du travail",{"$nulls":3},"Epanouissement personnel",null,"Epanouissement personnel"]
["Dev_personnel","Temps libre pour des projets personnels","0-faible…=>10-fort",null,"Environnement",null,"Pénibilité",null,"Pénibilité",{"$nulls":3},"Facilité d'adaptation",null,"Facilité d'adaptation"]
["Dev_personnel","Autre dev perso","0-faible…=>10-fort",null,"Lien familial",null,"Perspective d'évolution",null,"Perspective d'évolution",{"$nulls":3},"Importance du changement… de vie recherché",null,"Importance du changement… de vie recherché"]
["Dev_professionnel","Avantages en nature","0-inexistants … => 10-parfaits",null,"Localisation",null,"Rémunération",null,"Rémunération",{"$nulls":3},"Temps libre pour des projets personnels",null,"Temps libre pour des projets personnels"]
["Dev_professionnel","Epanouissement professionnel","0-inexistant … => 10-parfait",null,"Logement",null,"Autre Develop Pro",null,"Autre Develop Pro",{"$nulls":3},"Autre dev perso",null,"Autre dev perso"]
["Dev_professionnel","Intérêt du travail","0-faible…=>10-fort"]
["Dev_professionnel","Pénibilité","0-très penible…=> 10:pas pénible"]
["Dev_professionnel","Perspective d'évolution","0-faible…=>10-forte"]
["Dev_professionnel","Rémunération","0-faible…=>10-forte"]
["Dev_professionnel","Autre Develop Pro","0-faible…=>10-fort"]
["Environnement","Climat : [canicule / inondation}","0-trop risqué…=> 10-idéal"]
["Environnement","Environnement recherché : [ville / campagne...]","0-inadapté…=> 10-idéal"]
["Environnement","Jardin","0-inexistant … => 10-parfait"]
["Environnement","Autre Environnement","0-faible…=>10-fort"]
["Lien familial","Prise en compte des personnes à charge","0-nulle…=>10-forte"]
["Lien familial","Prise en compte des proches","0-nulle…=>10-forte"]
["Localisation","Localisation régionale","0-nulle… => 10-parfaite"]
["Localisation","Proximité des établissements socio-éducatifs","0-trop éloigné…=> 10-idéal"]
["Localisation","Proximité des lieux culturels","0-trop éloigné…=> 10-idéal"]
["Localisation","Proximité des lieux de cultes","0-trop éloigné…=> 10-idéal"]
["Localisation","Proximité des transports","0-trop éloigné…=> 10-idéal"]
["Localisation","Proximité des lieux gastronomiques","0-trop éloigné…=> 10-idéal"]
["Localisation","Proximité des commerces","0-trop éloigné…=> 10-idéal"]
["Logement","Prix [endettement}","0-fort endettement…=> sans endettement"]
["Logement","Surface habitable","0-trop petite…=>10-idéale"]
["Logement","Travaux","0-trop de travaux…=> 10-ce qu'il faut"]
["Autre","(Préciser)","0-faible…  => 10-fort"]

{"sheet":"importance","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"hidden":true}
["importance de l'item  dans le choix"]
["aucune importance",0]
["très faible importance",0.1]
["peu important",0.25]
["moyennement important",0.5]
["important",0.75]
["très important",0.9]
["primordiale",1]