{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Modélisation 1","Modélisation 2"],"not_rendered":{"charts":2,"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Modélisation 1","index":0,"n_rows":57,"n_cols":23,"rows_kept":57,"merged":[[2,1,2,5],[2,7,2,12],[4,4,4,5],[4,7,4,8],[4,11,4,12],[7,4,7,5],[7,7,7,8],[7,11,7,12],[10,4,10,5],[10,7,10,8],[10,11,10,12]]}
[]
[]
[null,"Offre",{"$nulls":5},"Demande"]
[]
[null,"Courbe",null,0,10,null,null,"Courbe",null,null,46,{"$f":"(K5/100)","v":0.46}]
[]
[]
[null,"Pente",null,150,0,null,null,"Pente",null,null,0,123]
[]
[]
[null,"Max.",null,null,0,null,null,"Max.",null,null,{"v":6000,"d":"6,000"},{"$f":"400-(400-K11)","v":{"v":6000,"d":"6,000"}}]
[]
[null,"ax2+bx+c",{"$nulls":6},"(c/bX)-ax"]
[]
[]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[null,"Quantité",0,100,200,300,400,500,600,700,800,900,1000,1100,1200,1300,1400,1500,1600,1700,1800,1900,2000]
[null,"Offre",{"$f":"(($E$5*(C17^2))+($E$8*C17)+$E$11)","v":10},{"$f":"(($E$5*(D17^2))+($E$8*D17)+$E$11)","v":40},90,160,250,360,490,640,810,1000,1210,1440,1690,1960,2250,2560,2890,3240,3610,4000,4410]
[null,"Demande",{"$f":"($L$11/(C17^$L$5))-(C17*$L$8)","v":5877},{"v":4115.917551960932,"d":"4116"},{"v":3250.7241324950037,"d":"3251"},{"v":2679.0541216841407,"d":"2679"},{"v":2246.706226125143,"d":"2247"},{"v":1893.4897044644194,"d":"1893"},{"v":1590.3546758413631,"d":"1590"},{"v":1321.3127719320187,"d":"1321"},{"v":1076.7337992277849,"d":"1077"},{"v":850.42110271519,"d":"850"},{"v":638.1804299245971,"d":"638"},{"v":437.0568549513057,"d":"437"},{"v":244.89976226002545,"d":"245"},{"v":60.10116443899028,"d":"60"},{"v":-118.56881886393603,"d":"119"},{"v":-292.06929289167033,"d":"292"},{"v":-461.1608467494359,"d":"461"},{"v":-626.455535389666,"d":"626"},{"v":-788.4522770026251,"d":"788"},{"v":-947.5624460994493,"d":"948"},{"v":-1104.1287204254252,"d":"1104"}]
{"$rows_empty":36}
[null,"© Y. Péguiron - HEP Lausanne 2007"]

{"sheet":"Modélisation 2","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"merged":[[3,2,3,4],[3,5,3,7]]}
[]
[null,"SAISIR LES DONNEES DES OFFREURS ET DES DEMANDEURS"]
[]
[null,null,"NOMBRE D'OFFREURS",null,null,"NOMBRE DE DEMANDEURS"]
[null,"PRIX","prêts à vendre à ce prix",null,"CUMULES","prêts à acheter à ce prix",null,"CUMULES"]
[null,{"v":10,"d":"10.-"},2,{"$f":"IF(C6=\"\",0,C6)","v":2},{"$f":"D6","v":2},80,{"$f":"IF(F6=\"\",0,F6)","v":80},{"$f":"F6+H7","v":216}]
[null,{"v":15,"d":"15.-"},6,6,{"$f":"D7+E6","v":8},60,60,136]
[null,{"v":20,"d":"20.-"},12,12,20,40,40,76]
[null,{"v":25,"d":"25.-"},20,20,40,20,20,36]
[null,{"v":30,"d":"30.-"},35,35,75,10,10,16]
[null,{"v":35,"d":"35.-"},50,50,125,5,5,6]
[null,{"v":40,"d":"40.-"},55,55,180,1,1,1]
[{"$nulls":3},0,180,null,0,0]
[{"$nulls":3},0,180,null,0,0]
[{"$nulls":3},0,180,null,0,{"$f":"F15","v":0}]
[]
[null,"Remplir les cases vertes et jaunes"]
{"$rows_empty":7}
[{"$nulls":4},0]