{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Simulation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Simulation","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,2,8],[0,1,0,8],[21,3,21,7],[3,9,3,15]]}
[null,"KSim (Kellogg Simulation) Documentation"]
[]
[null,"Use the \"Window\" command to switch back to your spreadsheet."]
[null,null,null,null,null,null,null,null,null,"This is just a snapshot of the \"simulation\" dialog-box."]
[null,"Load this speadsheet into Excel to add the \"Simulation\" option to the main Excel menu"]
[null,"(or the Add-Ins submenu). Simulations can then be run in any open workbook."]
[]
[null,"In order to maximize speed, the \"Simulation\" command requires that the cell(s) being"]
[null,"monitored, the 6-rows-by-(cells monitored + 1)-columns output range, and all relevant formulas"]
[null,"be on the same workbook tab."]
[]
[null,"Pressing \"Esc\" will stop a running simulation."]
[]
[null,"In order to continue a simulation, select Simulation / Continue, point to the upper-lefthand"]
[null,"corner of the previous results (i.e., the displayed address of the (first) monitored cell), and"]
[null,"enter the desired total number of simulation runs."]
[]
[null,"example input",null,{"$f":"RAND()","v":0.7960938979618144},{"$f":"showformula(D18)","v":"=RAND()"},null,null,"uniformly random between 0 and 1"]
[null,null,null,{"$f":"IF(RAND()<0.75,1,0)","v":1},{"$f":"showformula(D19)","v":"=IF(RAND()<0.75,1,0)"},null,null,"Pr(X=1) = 0.75, Pr(X=0) = 0.25"]
[null,null,null,{"$f":"NORMINV(RAND(),100,10)","v":90.738086825121144},{"$f":"showformula(D20)","v":"=NORMINV(RAND(),100,10)"},null,null,"normally distributed, with mean 100 and standard deviation 10"]
[]
[null,null,null,"example output"]
[null,null,null,{"$f":"ADDRESS(ROW($D$18),COLUMN($D$18))","v":"$D$18"},{"$f":"ADDRESS(ROW($D$19),COLUMN($D$19))","v":"$D$19"},{"$f":"ADDRESS(ROW($D$20),COLUMN($D$20))","v":"$D$20"},"monitored cell"]
[null,null,null,0.50153068500900388,0.75049999999999994,99.985549264202916,"mean"]
[null,null,null,0.28933785700556724,0.43272580523493759,9.9919723201288893,"sample standard deviation"]
[null,null,null,2.262386840268249E-5,0,52.937570492944985,"minimum"]
[null,null,null,0.99997772307868482,1,145.27039806999653,"maximum"]
[null,null,null,100000,100000,100000,"number of simulation runs"]
[]
[null,null,null,{"$f":"1.96*D25/SQRT(D28)","v":1.7933346172414085E-3},{"$f":"1.96*E25/SQRT(E28)","v":2.6820623278707195E-3},{"$f":"1.96*F25/SQRT(F28)","v":6.1930886063970209E-2},"margin of error (95% confidence)"]