{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":46,"n_cols":14,"rows_kept":46,"merged":[[11,12,11,13],[24,3,24,6]]}
["Zones Modifiables :",{"$nulls":3},"Données","f1","f2","f3","f4","f5","f6"]
["Les autres pas toucher",{"$nulls":3},"a1",80,90,600,5.4,8,5]
[{"$nulls":4},"a2",65,58,200,9.7,1,1]
[{"$nulls":4},"a3",83,60,400,7.2,4,7]
[{"$nulls":4},"a4",40,80,1000,7.5,7,10]
[{"$nulls":4},"a5",52,72,600,2,3,8]
["Pour \"jouer\" avec le cas  modifier a1, a2",{"$nulls":3},"a6",94,96,700,3.6,5,6]
["par les alternatives souhaitées",null,null,{"$f":"7/8","v":0.875}]
[{"$nulls":6},{"$f":"\"π (\"&G10&\",\"&G11&\")\"","v":"π (a1,a2)"},{"$f":"\"π (\"&H10&\",\"&H11&\")\"","v":"π (a2,a1)"}]
["Par ex. saisir a3 au lieu de a1",{"$nulls":4},"Param1","a1",{"$f":"G11","v":"a2"}]
[{"$nulls":6},"a2",{"$f":"G10","v":"a1"}]
[null,"Type \nfonction","param1","param2","Optimum","Poids","     P(a,b)\nCritéres",{"$f":"\"Pj(\"&G10& \",\" &G11&\")\"","v":"Pj(a1,a2)"},{"$f":"\"Pj(\"&H10& \",\" &H11&\")\"","v":"Pj(a2,a1)"},null,null,"Traduction \nmin/max => param","Correspondance Tableau \ncriteres"]
[null,"II",10,null,"min",1,"f1",{"$f":"preferenceF($B13,VLOOKUP($G$10,Data,VLOOKUP($G13,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($G$11,Data,VLOOKUP($G13,_xlnm.Criteria,2,FALSE),FALSE),$C13,$D13,$L13)","v":{"v":0,"d":"0.000"}},{"$f":"preferenceF($B13,VLOOKUP($H$10,Data,VLOOKUP($G13,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($H$11,Data,VLOOKUP($G13,_xlnm.Criteria,2,FALSE),FALSE),$C13,$D13,$L13)","v":{"v":1,"d":"1.000"}},null,null,{"$f":"IF(E13=\"min\",-1,1)","v":-1},"f1",2]
[null,"III",30,null,"max",1,"f2",{"$f":"preferenceF($B14,VLOOKUP($G$10,Data,VLOOKUP($G14,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($G$11,Data,VLOOKUP($G14,_xlnm.Criteria,2,FALSE),FALSE),$C14,$D14,$L14)","v":{"v":1,"d":"1.000"}},{"$f":"preferenceF($B14,VLOOKUP($H$10,Data,VLOOKUP($G14,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($H$11,Data,VLOOKUP($G14,_xlnm.Criteria,2,FALSE),FALSE),$C14,$D14,$L14)","v":{"v":0,"d":"0.000"}},null,null,{"$f":"IF(E14=\"min\",-1,1)","v":1},"f2",3]
[null,"V",50,500,"min",1,"f3",{"$f":"preferenceF($B15,VLOOKUP($G$10,Data,VLOOKUP($G15,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($G$11,Data,VLOOKUP($G15,_xlnm.Criteria,2,FALSE),FALSE),$C15,$D15,$L15)","v":{"v":0,"d":"0.000"}},{"$f":"preferenceF($B15,VLOOKUP($H$10,Data,VLOOKUP($G15,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($H$11,Data,VLOOKUP($G15,_xlnm.Criteria,2,FALSE),FALSE),$C15,$D15,$L15)","v":{"v":0.7777777777777778,"d":"0.778"}},null,null,-1,"f3",4]
[null,"IV",1,6,"min",1,"f4",{"$f":"preferenceF($B16,VLOOKUP($G$10,Data,VLOOKUP($G16,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($G$11,Data,VLOOKUP($G16,_xlnm.Criteria,2,FALSE),FALSE),$C16,$D16,$L16)","v":{"v":0.5,"d":"0.500"}},{"$f":"preferenceF($B16,VLOOKUP($H$10,Data,VLOOKUP($G16,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($H$11,Data,VLOOKUP($G16,_xlnm.Criteria,2,FALSE),FALSE),$C16,$D16,$L16)","v":{"v":0,"d":"0.000"}},null,null,-1,"f4",5]
[null,"I",null,null,"min",1,"f5",{"$f":"preferenceF($B17,VLOOKUP($G$10,Data,VLOOKUP($G17,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($G$11,Data,VLOOKUP($G17,_xlnm.Criteria,2,FALSE),FALSE),$C17,$D17,$L17)","v":{"v":0,"d":"0.000"}},{"$f":"preferenceF($B17,VLOOKUP($H$10,Data,VLOOKUP($G17,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($H$11,Data,VLOOKUP($G17,_xlnm.Criteria,2,FALSE),FALSE),$C17,$D17,$L17)","v":{"v":1,"d":"1.000"}},null,null,-1,"f5",6]
[null,"VI",5,null,"max",1,"f6",{"$f":"preferenceF($B18,VLOOKUP($G$10,Data,VLOOKUP($G18,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($G$11,Data,VLOOKUP($G18,_xlnm.Criteria,2,FALSE),FALSE),$C18,$D18,$L18)","v":{"v":0.27385096292630906,"d":"0.274"}},{"$f":"preferenceF($B18,VLOOKUP($H$10,Data,VLOOKUP($G18,_xlnm.Criteria,2,FALSE),FALSE),VLOOKUP($H$11,Data,VLOOKUP($G18,_xlnm.Criteria,2,FALSE),FALSE),$C18,$D18,$L18)","v":{"v":0,"d":"0.000"}},null,null,1,"f6",7]
[]
[{"$nulls":6},"Somme",{"$f":"H13*$F$13+H14*$F$14+H15*$F$15+H16*$F$16+H17*$F$17+H18*$F$18","v":{"v":1.773850962926309,"d":"1.774"}},{"$f":"I13*$F$13+I14*$F$14+I15*$F$15+I16*$F$16+I17*$F$17+I18*$F$18","v":{"v":2.7777777777777777,"d":"2.778"}}]
[{"$nulls":5},"/6","π (a,b)",{"$f":"H20/SUM(F13:F18)","v":{"v":0.29564182715438486,"d":"0.296"}},{"$f":"I20/6","v":{"v":0.46296296296296297,"d":"0.463"}}]
[]
[{"$nulls":6},"Cible",{"$f":"VLOOKUP(G10,DataCheck,VALUE(MID(G11,2,1))+1,FALSE)","v":0.3},{"$f":"VLOOKUP(H10,DataCheck,VALUE(MID(H11,2,1))+1,FALSE)","v":0.46},null,0.296,0.462]
[{"$nulls":6},"Delta",{"$f":"H23-H21","v":4.358172845615127E-3},{"$f":"I23-I21","v":-2.962962962962945E-3}]
[{"$nulls":3},{"$f":"\"Si <précision (\"&H26& \") on dit que c'est bon\"","v":"Si <précision (0,01) on dit que c'est bon"},{"$nulls":3},{"$f":"IF(ABS(H24)<$H$26,\"Yeah\",\"OhOh\")","v":"Yeah"},{"$f":"IF(ABS(I24)<$H$26,\"Yeah\",\"OhOh\")","v":"Yeah"}]
[{"$nulls":6},"Précision",0.01]
[]
[{"$nulls":4},"Check","a1","a2","a3","a4","a5","a6"]
[{"$nulls":4},"a1",null,0.3,0.25,0.27,0.1,0.19]
[{"$nulls":4},"a2",0.46,null,0.39,0.33,0.3,0.5]
[{"$nulls":4},"a3",0.24,0.18,null,0.333,0.06,0.43]
[{"$nulls":4},"a4",0.4,0.51,0.31,0,0.22,0.21]
[{"$nulls":4},"a5",0.44,0.52,0.49,0.38,null,0.45]
[{"$nulls":4},"a6",0.29,0.4,0.25,0.43,0.13]
{"$rows_empty":11}
[null,"II"]