{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Sheet1","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Goalseek: in this example, goalseek",null,null,null,null,"Sample Results"]
[null,"is used to find the square root of the input value."]
[null,"The input is random, and at each iteration goalseek",null,null,null,null,"There are two ways to retrieve results from the simulation, when run in VBA.  The first is to have VBA copy"]
[null,"is run on the new input value.",null,null,null,null,"the value at each iteration into a new cell (this is what happens in the green columns).  The second is to "]
[null,null,null,null,null,null,"use the RiskAMP functions to retrieve the value at a particular iteration - that's used in the yellow columns."]
[null,"The goalseek VBA code was generated by"]
[null,"recording a macro; we started recording, and then",null,null,null,null,null,"Using VBA to store values:",null,null,null,"Using the RiskAMP functions to retrieve values:"]
[null,"ran goalseek from the menu, setting the values as"]
[null,"\"Set cell D16 to 0 by changing cell C16\".  ",null,null,null,null,"Trial","Random Value","Goalseek Solution","(Check)",null,"Random Value","Goalseek Solution","(Check)"]
[null,null,null,null,null,null,1,96.258806766624673,9.8111574898626053,{"$f":"I11*I11","v":96.258811290887095},null,{"$f":"SimulationValue($B$16,G11)","v":96.258806766624673},{"$f":"SimulationValue($C$16,G11)","v":9.8111574898626053},{"$f":"M11*M11","v":96.258811290887095}]
[null,"That formula will set C16 to the square root of B16.",null,null,null,null,{"$f":"G11+1","v":2},95.69363184537778,9.7823125568013722,{"$f":"I12*I12","v":95.693638958953798},null,{"$f":"SimulationValue($B$16,G12)","v":95.69363184537778},{"$f":"SimulationValue($C$16,G12)","v":9.7823125568013722},{"$f":"M12*M12","v":95.693638958953798}]
[null,null,null,null,null,null,{"$f":"G12+1","v":3},87.839575228246801,9.3722769878122687,87.839575936275409,null,{"$f":"SimulationValue($B$16,G13)","v":87.839575228246801},{"$f":"SimulationValue($C$16,G13)","v":9.3722769878122687},87.839575936275409]
[null,null,null,null,null,null,4,99.457302714675208,9.9728278797481718,99.457295919082412,null,{"$f":"SimulationValue($B$16,G14)","v":99.457302714675208},{"$f":"SimulationValue($C$16,G14)","v":9.9728278797481718},99.457295919082412]
[null,"Random Value","Goal","Error",null,null,5,90.400675752635266,9.5079270679879553,90.400677130178039,null,{"$f":"SimulationValue($B$16,G15)","v":90.400675752635266},{"$f":"SimulationValue($C$16,G15)","v":9.5079270679879553},90.400677130178039]
[null,{"$f":"NormalValue(100,10)","v":96.16603934462708},9.6033165170548074,{"$f":"B16-(C16*C16)","v":3.94235121788941},null,null,6,98.885969922475795,9.9441424399078375,98.885968865176196,null,{"$f":"SimulationValue($B$16,G16)","v":98.885969922475795},{"$f":"SimulationValue($C$16,G16)","v":9.9441424399078375},98.885968865176196]
[null,null,null,null,null,null,7,106.50152274458321,10.319957479480287,106.50152237828112,null,{"$f":"SimulationValue($B$16,G17)","v":106.50152274458321},{"$f":"SimulationValue($C$16,G17)","v":10.319957479480287},106.50152237828112]
[null,null,null,null,null,null,8,92.70296031192872,9.6282382573767649,92.702971940813555,null,{"$f":"SimulationValue($B$16,G18)","v":92.70296031192872},{"$f":"SimulationValue($C$16,G18)","v":9.6282382573767649},92.702971940813555]
[null,null,null,null,null,null,9,110.80532609315749,10.526408287824989,110.80527144199061,null,{"$f":"SimulationValue($B$16,G19)","v":110.80532609315749},{"$f":"SimulationValue($C$16,G19)","v":10.526408287824989},110.80527144199061]
[null,null,null,null,null,null,10,107.16059927796894,10.351842307996765,107.16063916963179,null,{"$f":"SimulationValue($B$16,G20)","v":107.16059927796894},{"$f":"SimulationValue($C$16,G20)","v":10.351842307996765},107.16063916963179]
[null,null,null,null,null,null,11,103.10010233271552,10.153826262899488,103.10018777714737,null,{"$f":"SimulationValue($B$16,G21)","v":103.10010233271552},{"$f":"SimulationValue($C$16,G21)","v":10.153826262899488},103.10018777714737]
[null,null,null,null,null,null,12,102.10037336303536,10.104473268402712,102.10038003186499,null,{"$f":"SimulationValue($B$16,G22)","v":102.10037336303536},{"$f":"SimulationValue($C$16,G22)","v":10.104473268402712},102.10038003186499]
[null,null,null,null,null,null,13,98.107865201159527,9.9049462881449557,98.107960971036533,null,{"$f":"SimulationValue($B$16,G23)","v":98.107865201159527},{"$f":"SimulationValue($C$16,G23)","v":9.9049462881449557},98.107960971036533]
[null,null,null,null,null,null,14,119.39394053486619,10.926748925436831,119.39384207953495,null,{"$f":"SimulationValue($B$16,G24)","v":119.39394053486619},{"$f":"SimulationValue($C$16,G24)","v":10.926748925436831},119.39384207953495]
[null,null,null,null,null,null,15,104.53143797337553,10.224062222302647,104.53144832551615,null,{"$f":"SimulationValue($B$16,G25)","v":104.53143797337553},{"$f":"SimulationValue($C$16,G25)","v":10.224062222302647},104.53144832551615]
[null,null,null,null,null,null,16,110.19329888362438,10.49728093179829,110.19290696109597,null,{"$f":"SimulationValue($B$16,G26)","v":110.19329888362438},{"$f":"SimulationValue($C$16,G26)","v":10.49728093179829},110.19290696109597]
[null,null,null,null,null,null,17,103.32403243320226,10.164883008664507,103.3248465798364,null,{"$f":"SimulationValue($B$16,G27)","v":103.32403243320226},{"$f":"SimulationValue($C$16,G27)","v":10.164883008664507},103.3248465798364]
[null,null,null,null,null,null,18,93.891385632396918,9.6897568125363911,93.891387086095406,null,{"$f":"SimulationValue($B$16,G28)","v":93.891385632396918},{"$f":"SimulationValue($C$16,G28)","v":9.6897568125363911},93.891387086095406]
[null,null,null,null,null,null,19,102.66472115339818,10.132360045075695,102.66472008304633,null,{"$f":"SimulationValue($B$16,G29)","v":102.66472115339818},{"$f":"SimulationValue($C$16,G29)","v":10.132360045075695},102.66472008304633]
[null,null,null,null,null,null,{"$f":"G29+1","v":20},107.25298359988334,10.356293608336557,107.25281730207263,null,{"$f":"SimulationValue($B$16,G30)","v":107.25298359988334},{"$f":"SimulationValue($C$16,G30)","v":10.356293608336557},107.25281730207263]