{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Test fonction","Simulation","Synthèse de scénarios","Problème - Ma petite entreprise"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Test fonction","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Prix",100,10,1000]
[null,"Seuil",200,200,30]
[]
[null,"Demande.SI",{"$f":"MaDemande(C2,C3)","v":170},{"$f":"MaDemande(D2,D3)","v":197},{"$f":"MaDemande(E2,E3)","v":0}]
[null,"Demande.SELON",{"$f":"MaDemandeSelon(C2,C3)","v":170},{"$f":"MaDemandeSelon(D2,D3)","v":197},{"$f":"MaDemandeSelon(E2,E3)","v":0}]

{"sheet":"Simulation","index":1,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Prix (P)",60,"P"]
["Quantité (Q)",20,"Q"]
["Couts Fixes",50,"CF"]
["Cout Unitaire",2,"CU"]
["Cout Total",{"$f":"B4*B2+B3","v":90},"CT=CU*Q+CF"]
["Recette",{"$f":"B1*B2","v":1200},"R=P*Q"]
["Bénéfice",{"$f":"B6-B5","v":1110},"B=R-CT"]
[]
[]
[null,null,null,null,null,null,null,"quantité"]
[null,"prix",{"$f":"B7","v":1110},null,null,null,{"$f":"B7","v":1110},5,10,15]
[null,50,910,null,null,"prix",50,190,430,670]
[null,60,1110,null,null,null,60,240,530,820]
[null,70,1310,null,null,null,70,290,630,970]
[null,80,1510,null,null,null,80,340,730,1120]
[null,90,1710,null,null,null,90,390,830,1270]
[null,100,1910,null,null,null,100,440,930,1420]

{"sheet":"Synthèse de scénarios","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Synthèse de scénarios"]
[null,null,null,"Valeurs actuelles :","s1","s2"]
[null,null,null,null,"Créé par ricco le 09/10/2015","Créé par ricco le 09/10/2015"]
[null,"Cellules variables :"]
[null,null,"Prix",60,100,60]
[null,null,"Quantité",20,50,20]
[null,null,"Cout_Unitaire",2,1,20]
[null,"Cellules résultantes :"]
[null,null,"Recette",1200,5000,1200]
[null,null,"Bénéfice",1110,4900,750]
[null,"La colonne Valeurs actuelles affiche les valeurs des cellules variables"]
[null,"au moment de la création du rapport de synthèse. Les cellules variables"]
[null,"de chaque scénario se situent dans les colonnes grisées."]

{"sheet":"Problème - Ma petite entreprise","index":3,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Prix",100]
["Quantité",130]
["CF",{"$f":"MonCoutFixe(B2)","v":8000}," <== FONCTION VBA"]
["CU",25]
["CT",{"$f":"B3+B4*B2","v":11250}]
["CA",{"$f":"B1*B2","v":13000}]
["BB",{"$f":"B6-B5","v":1750}]
["Destination","locale"]
["Zone","défavorisée"]
["Taux de taxe",{"$f":"MonTaux(B2,B8,B9)","v":0.85},{"$f":"MonTauxSelon(B2,B8,B9)","v":0.85}," <== FONCTION VBA"]
["Taxe",{"$f":"IF(B7>0,B10*B7,0)","v":1487.5}]
["Bénef net",{"$f":"B7-B11","v":262.5}]
[]
[]
["Table à 1 entrée",null,null,null,"Table à 2 entrées"]
[null,"Bénéfice",null,null,null,"destination"]
["Q",{"$f":"B12","v":262.5},null,null,{"$f":"B12","v":262.5},"locale","exportation"]
[50,1312.5,null,"Q",50,1312.5,1312.5]
[60,1875,null,null,60,1875,1875]
[70,2437.5,null,null,70,2437.5,2437.5]
[80,1400,null,null,80,1400,1400]
[90,1662.5,null,null,90,1662.5,1662.5]
[100,-500,null,null,100,-500,-500]
[110,37.5,null,null,110,37.5,74.999999999999972]
[120,150,null,null,120,150,299.99999999999989]
[130,262.5,null,null,130,262.5,524.99999999999977]
[140,375,null,null,140,375,749.99999999999977]
[150,-28750,null,null,150,-28750,-28750]