{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["EXO.0 - Valeur cible et Solveur","EXO.1 - Utilité","EXO.2 - Optim.Prod","EXO.3 - Nirvana"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":113,"comments":2,"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":"EXO.0 - Valeur cible et Solveur","index":0,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["X",2.5]
["Y",{"$f":"B1^2-3*B1+2","v":0.75}]
[]
["Contrainte",{"$f":"2*B1-5","v":0}]
[]
[]
[null,null,{"$f":"B2","v":0.75}]
[null,0,2]
[null,0.1,1.71]
[null,0.2,1.44]
[null,0.3,1.19]
[null,0.4,0.96]
[null,0.5,0.75]
[null,0.6,0.56000000000000005]
[null,0.7,0.39000000000000035]
[null,0.8,0.23999999999999977]
[null,0.9,0.10999999999999988]
[null,1,0]
[null,1.1000000000000001,-8.9999999999999858E-2]
[null,1.2,-0.1599999999999997]
[null,1.3,-0.20999999999999996]
[null,1.4,-0.23999999999999932]
[null,1.5,-0.25]
[null,1.6,-0.24000000000000021]
[null,1.7,-0.20999999999999996]
[null,1.8,-0.16000000000000014]
[null,1.9,-8.9999999999999414E-2]
[null,2,0]
[null,2.1,0.10999999999999943]
[null,2.2000000000000002,0.24000000000000021]
[null,2.2999999999999998,0.38999999999999968]
[null,2.4,0.5600000000000005]
[null,2.5,0.75]
[null,2.6,0.96]
[null,2.7,1.1899999999999995]
[null,2.8,1.4400000000000004]
[null,2.9,1.7100000000000009]
[null,3,2]

{"sheet":"EXO.1 - Utilité","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["X1",24.999999999999996]
["X2",12.499999999999996]
[]
["Utilité",{"$f":"B1*B2","v":312.49999999999989}]
[]
["Contrainte de budget",{"$f":"2*B1+4*B2","v":99.999999999999972}]

{"sheet":"EXO.2 - Optim.Prod","index":2,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["X",10]
["Y",20]
[]
["Utilisation de A",{"$f":"4*B1+2*B2","v":80}]
["Utilisation de B",{"$f":"1*B1+3*B2","v":70}]
[]
["C.U - A",5]
["C.U - B",12]
[]
["Cout total",{"$f":"B7*B4+B8*B5","v":1240}]
[]
["Rec.U.X",250]
["Rec.U.Y",150]
[]
["Recette totale",{"$f":"B12*B1+B13*B2","v":5500}]
[]
["Bénéfice",{"$f":"B15-B10","v":4260}]

{"sheet":"EXO.3 - Nirvana","index":3,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[null,"MP.A","MP.B","MP.C","Prix Lessive","Qtté produite","Recette"]
["ALPHA",0.15,7.4999999999999997E-2,2.5000000000000001E-2,25,10,{"$f":"E2*F2","v":250}]
["TATRA",7.4999999999999997E-2,0.125,0.05,35,10,{"$f":"E3*F3","v":350}]
["PUMA",5.5E-2,6.5000000000000002E-2,0.13,55,10,{"$f":"E4*F4","v":550}]
["Utilisation MP",{"$f":"B$2*$F$2+B$3*$F$3+B$4*$F$4","v":2.8},{"$f":"C$2*$F$2+C$3*$F$3+C$4*$F$4","v":2.65},{"$f":"D$2*$F$2+D$3*$F$3+D$4*$F$4","v":2.0499999999999998},null,"CA",{"$f":"SUM(G2:G4)","v":1150}]
["Coût unitaire MP",120,{"$f":"MonCout(C5)","v":150},250,"COUT TOT MP"]
["Coût MP",{"$f":"B6*B5","v":336},{"$f":"C6*C5","v":397.5},{"$f":"D6*D5","v":512.5},{"$f":"SUM(B7:D7)","v":1246},"Benefice",{"$f":"G5-E7","v":-96}]
[]
[]
[]
[]
[null,"Table à 2 entrées"]
[null,{"$f":"G7","v":-96},250,260,270,280,290,300,310,320,330,340,350,360,370,380,390,400]
[null,90,-12,-32.5,-53,-73.5,-94,-114.5,-135,-155.5,-176,-196.5,-217,-237.5,-258,-278.5,-299,-319.5]
[null,95,-26,-46.5,-67,-87.5,-108,-128.5,-149,-169.5,-190,-210.5,-231,-251.5,-272,-292.5,-313,-333.5]
[null,100,-40,-60.5,-81,-101.5,-122,-142.5,-163,-183.5,-204,-224.5,-245,-265.5,-286,-306.5,-327,-347.5]
[null,105,-54,-74.5,-95,-115.5,-136,-156.5,-177,-197.5,-218,-238.5,-259,-279.5,-300,-320.5,-341,-361.5]
[null,110,-68,-88.5,-109,-129.5,-150,-170.5,-191,-211.5,-232,-252.5,-273,-293.5,-314,-334.5,-355,-375.5]
[null,115,-82,-102.5,-123,-143.5,-164,-184.5,-205,-225.5,-246,-266.5,-287,-307.5,-328,-348.5,-369,-389.5]
[null,120,-96,-116.5,-137,-157.5,-178,-198.5,-219,-239.5,-260,-280.5,-301,-321.5,-342,-362.5,-383,-403.5]
[null,125,-110,-130.5,-151,-171.5,-192,-212.5,-233,-253.5,-274,-294.5,-315,-335.5,-356,-376.5,-397,-417.5]
[null,130,-124,-144.5,-165,-185.5,-206,-226.5,-247,-267.5,-288,-308.5,-329,-349.5,-370,-390.5,-411,-431.5]
[null,135,-138,-158.5,-179,-199.5,-220,-240.5,-261,-281.5,-302,-322.5,-343,-363.5,-384,-404.5,-425,-445.5]
[null,140,-152,-172.5,-193,-213.5,-234,-254.5,-275,-295.5,-316,-336.5,-357,-377.5,-398,-418.5,-439,-459.5]
[null,145,-166,-186.5,-207,-227.5,-248,-268.5,-289,-309.5,-330,-350.5,-371,-391.5,-412,-432.5,-453,-473.5]
[null,150,-180,-200.5,-221,-241.5,-262,-282.5,-303,-323.5,-344,-364.5,-385,-405.5,-426,-446.5,-467,-487.5]
[null,155,-194,-214.5,-235,-255.5,-276,-296.5,-317,-337.5,-358,-378.5,-399,-419.5,-440,-460.5,-481,-501.5]
[null,160,-208,-228.5,-249,-269.5,-290,-310.5,-331,-351.5,-372,-392.5,-413,-433.5,-454,-474.5,-495,-515.5]
[null,165,-222,-242.5,-263,-283.5,-304,-324.5,-345,-365.5,-386,-406.5,-427,-447.5,-468,-488.5,-509,-529.5]
[null,170,-236,-256.5,-277,-297.5,-318,-338.5,-359,-379.5,-400,-420.5,-441,-461.5,-482,-502.5,-523,-543.5]
[null,175,-250,-270.5,-291,-311.5,-332,-352.5,-373,-393.5,-414,-434.5,-455,-475.5,-496,-516.5,-537,-557.5]
[null,180,-264,-284.5,-305,-325.5,-346,-366.5,-387,-407.5,-428,-448.5,-469,-489.5,-510,-530.5,-551,-571.5]