{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Simulation_sheet","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Simulation_sheet","index":0,"n_rows":24,"n_cols":804,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Random coefficient generation"]
["Row 1","Normal distribution ( x = 0; s = 1; 800 cells)",null,null,0.85294686869019642,9.9036014944431372E-2,-0.13709268387174234,-1.3245880836620927,-1.2660029824473895,-0.19862682165694423,0.40280156099470332,-0.72190687205875292,-4.7638195610488765E-2,0.45192109610070474,-1.883945515146479,0.96561052487231791,2.7951318770647049,-1.1601719052123372,-0.27241640054853633,-1.0224061952612828,0.1115745362767484,-0.34634012990863994,1.5619934856658801,0.47937419367372058,1.3405724530457519,-1.1473707672848832,1.4860279407002963,-0.57865463531925343,-0.92377831606427208,-0.26005182007793337,-2.2280073608271778,1.9991239241790026,-7.1012209446053021E-2,1.548660293337889,-0.37056906876387075,6.7407199821900576E-2,1.7913043848238885,1.4402939996216446,5.1774122766801156E-2,0.28824956643802579,-1.0287476470693946,1.5375871953438036,-2.15153704630211,0.58146042647422291,-2.1281266526784748,0.17705815480439924,0.63540710470988415,-0.65822860051412135,1.0578833098406903,-1.59223418449983,-2.6586803869577125E-2,5.3153144108364359E-2,1.6291824067593552,-0.92989012046018615,-7.2085413194145076E-2,-0.37007680475653615,0.7051335160213057,1.0230519364995416,0.20627794583560899,-1.1889915185747668,0.13207454685471021,-0.46509285311913118,-3.78690856450703E-3,1.549165062897373,-1.8803530110744759,-0.28036311050527729,0.83763779912260361,-1.0631174518493935,0.98754753707908094,1.1518159226397984,0.96159510576399043,-0.72528678174421657,-1.2218947631481569,-0.34155164030380547,-1.0554754226177465,-0.27281316761218477,-4.0746499507804401E-2,-0.62998765315569472,1.4161105355015025,0.4002322384621948,0.81866573964362033,0.58399791669216938,-1.102575879485812,-1.1167367119924165,0.29983198146510404,0.57747911341721192,-1.2570194485306274,-1.6721969586797059,-1.7393540474586189,2.3494794731959701,-0.95204313765862025,-0.81301095633534715,-0.43832187657244503,-0.41136217987514101,-0.51198526307416614,-0.11835140867333394,-0.36557480598276015,-1.7966567611438222,-0.79399569585802965,0.41703060560394078,-0.54843667385284789,-1.7638285498833284,0.34983486330020241,-1.8385526345809922,-0.82005726653733291,0.25451640794926789,0.1702244389889529,-0.13114913599565625,1.0080611900775693,-1.0818803275469691,0.20182596927043051,1.2393502402119339,-0.58526893553789705,0.7284756975423079,-0.47946059567038901,1.8675109458854422,-0.37516088013944682,-1.375190095131984,-9.8305008577881381E-3,-0.34390495784464292,0.18172386262449436,1.510898073320277E-2,-1.6414151104982011,-9.3425569502869621E-2,1.5203568182187155,-0.45998376663192175,0.55583200264663901,0.22012955014361069,-0.1824230366764823,-0.44980424718232825,-0.20143602341704536,0.20042079995619133,-1.7978118194150738,1.7733282220433466,0.63045376919035334,0.38247549127845559,0.7880339580879081,-0.40770146370050497,-0.55940631682460662,-0.6827485776739195,0.16184799278562423,0.27328951546223834,2.4754626792855561,0.1175044417323079,-4.7102730604819953E-2,-1.7256297724088654,-0.27710257199942134,1.2210875866003335,-0.84625298768514767,1.8055652617476881,2.565066097304225,0.15758587323944084,1.3947510524303652,-0.58844989325734787,-0.99945282272528857,-1.7638285498833284,0.97627435025060549,-2.2118365450296551,0.1188129772344837,-0.82789938460336998,1.2037003216391895,0.77185632108012214,-0.25846929929684848,-0.18833816284313798,-1.2183522812847514,-0.35016000765608624,-0.94377128334599547,-0.87348780652973801,-1.0868393474083859,1.236221578437835,-0.20963966562703717,-0.26519842322159093,-0.58263822211301886,-9.6268877314287238E-2,-0.57161514632753097,-0.11373003871995024,-1.1811175681941677,1.5748173609608784,-0.85757847045897506,-0.52326868171803653,2.6845373213291168,-5.4149040806805715E-2,0.22561948753718752,-1.4063789421925321,1.6286048776237294,0.70248688643914647,-0.85415877038030885,1.2446434993762523,-0.74210788625350688,0.83644408732652664,-1.0308281161997002,-1.3203680282458663,0.62179879023460671,-0.22169842850416899,-0.23119469005905557,0.1908301783259958,-0.43134377847309224,-0.40953182178782299,-0.45768956624669954,0.15712203094153665,0.59409785535535775,0.98729969977284782,-0.5506603883986827,-0.16657850210322067,0.13168914847483393,0.33296828405582346,-1.5071236703079194,-0.52467271416389849,-8.1062125900643878E-2,1.2459713616408408,-0.62747062656853814,-0.74634613156376872,0.44262151277507655,1.4146530702419113,1.1223187357245479,-1.003872966975905,-0.31434638003702275,-0.52423388297029305,0.77991899161133915,-6.0201728047104552E-2,1.268908818019554,-7.7302502177190036E-2,-0.75425305112730712,-2.6395719032734632,0.63120069171418436,-0.64150412981689442,-4.1665089156595059E-2,0.67744622356258333,-9.6961230156011879E-2,-0.44633679863181897,0.62421349866781384,-0.19605295165092684,-1.5128625818761066,0.96220219347742386,-0.95373025033040904,0.79305209510494024,-0.1175044417323079,-0.42212604967062362,0.5080642040411476,-0.38807797864137683,0.12243503988429438,1.2287000572541729,2.3994653020054102,-0.2424451395199867,-0.69623411036445759,1.4387842384167016,0.33733840609784238,0.34991671782336198,-1.1888369044754654,0.34666527426452376,0.47440380512853153,0.12744635569106322,-0.13902308637625538,0.37532458918576594,-1.239513949258253,0.45107299229130149,0.28832914722443093,1.256175892194733,-0.53400071919895709,-0.35195057535020169,-0.13068643056612927,-0.89840568762156181,0.25127746994257905,1.1497377272462472,1.1031397662009113,0.87427224571001716,1.0478947842784692,1.3060548553767148,-0.14636498235631734,-0.40114400690072216,-0.52616542234318331,-0.23732809495413676,-1.5881732906564139,-0.70376017902162857,1.5930527297314256,-0.96903022495098412,-1.5179284673649818,0.33329115467495285,0.4940147846355103,-0.21308210307324771,-0.69136831370997243,-0.52125187721685506,1.3266117093735375,-0.87517037172801793,1.5504383554798551,0.2313515778951114,-0.11596284821280278,-0.70739133661845699,-0.99768840300384909,0.82714450400089845,1.1482575246191118,-6.6257825892535038E-2,-1.1556858225958422,-8.5515239334199578E-2,0.79085339166340418,0.30391447580768727,1.3260591913422104,0.79977553468779661,1.8727860151557252,-5.1007873480557464E-2,-1.1763677321141586,1.1546399036888033,-0.46347395254997537,0.39774704418960027,-0.21777964320790488,1.7369256966048852,0.33766127671697177,-0.53726807891507633,-1.0226631275145337,1.6183184925466776,1.0321309673599899,0.46279183152364567,0.60031652537873015,-1.0368330549681559,1.1524093679327052,-1.3675503396370914,1.2283771866350435,1.0325220500817522,-1.1852762327180244,0.92730033429688774,0.23268739823834039,-0.74988747655879706,1.3323506209417246,-0.86489421846636105,-1.8393802747596055,0.17542674868309405,3.1472882255911827,-0.4304195044824155,-0.44861963033326901,2.1281266526784748,0.31241825126926415,0.12274313121451996,-0.40786858335195575,-0.89726199803408235,-0.64837877289392054,0.77639924711547792,0.47337607611552812,0.9819586921366863,-1.1809652278316207,1.1963129509240389,-6.6938810050487518E-3,-0.85195551946526393,3.0565843189833686E-2,-1.0585517884464934,1.3657972885994241,-6.6718257585307583E-2,-2.7107307687401772,-1.2164264262537472,-0.72717966759228148,1.4777697288081981,-1.8242280930280685,-0.59464582591317594,2.9341435947571881E-2,0.44870375859318301,0.61938749240653124,0.62384287957684137,1.3833096090820618,-0.62346998674911447,-0.21292521523719188,0.28976501198485494,-0.3387958713574335,1.4531451597576961,-1.6104331734823063,-0.8635606718598865,-0.51696360969799571,1.9792150851571932,-0.82768337961169891,1.5688783605583012E-3,-0.18919422473118175,-4.4747139327228069E-3,-0.12166424312454183,-3.9674432628089562E-2,1.0363100955146365,3.9138967622420751E-2,0.45709498408541549,-1.380328740197001,1.1498877938720398,1.3494582162820734,1.2157852324889973,-3.4010554372798651E-2,0.29655211619683541,0.39394080886268057,1.846487975853961,-6.1045284382998943E-2,0.61818354879505932,-0.14605575415771455,1.0043800102721434,-0.63953166318242438,1.2541590876935516,1.560183591209352,-0.11973725122516043,0.39575979826622643,0.90679804998217151,-0.4922003427054733,-0.46142986320774071,1.0097164704347961,0.94472625278285705,-1.300154508498963,-0.50363041737000458,-0.64998516791092698,0.26028828870039433,0.76527840064954944,1.0173880582442507,0.87080252342275344,-0.66041366153513081,2.5671397452242672,-0.52300492825452238,0.1983926267712377,4.0363374864682555E-2,0.64573896452202462,1.1778956832131371,-0.85879491962259635,1.3092926565150265,-0.14713805285282433,1.264811544388067,0.31362333174911328,0.5075435183243826,0.75049683800898492,-0.90092953541898169,7.3619048635009676E-2,-3.9368615034618415E-2,1.5617342796758749,-0.62989329308038577,0.21652567738783546,2.3004213289823383,-1.2835880625061691,-6.1584159993799403E-3,-0.36042706597072538,-0.30688056540384423,-0.88701199274510145,-0.69204816099954769,-2.1794585336465389,-0.16890453480300494,0.66537040765979327,-0.68419694798649289,0.85019792095408775,2.0899460650980473,1.0780422599054873,0.25949702830985188,0.55520786190754734,9.4731831268290989E-2,-0.50954440666828305,-4.2431338442838751E-2,-1.0440612641104963,-1.7725915313349105,1.7633965398999862E-2,-1.1981933312199544,1.0138001016457565,-0.43142676986462902,-1.06002744360012,-0.58744944908539765,-0.4958303634339245,-0.26789393814397044,2.0099651010241359,1.450073341402458,0.98829559647128917,2.3371740098809823E-2,0.76692003858624958,-0.26947986953018699,0.261080685959314,-0.63615743783884682,0.14195961739460472,0.83038003140245564,0.75618572736857459,-1.1048268788727,0.37516088013944682,-0.10826511243067216,0.91154106485191733,-7.4232957558706403E-2,0.42689748624979984,-1.4955548977013677,0.496090706292307,1.7428374121664092,-0.6135599051049212,1.8086984709952958,-2.3191569198388606,5.0874859880423173E-3,-0.51766164688160643,-8.8432443590136245E-2,-0.45964497985551134,1.0329131328035146,0.68884446591255255,0.29008333513047546,-1.6001649782992899,0.32674847716407385,1.233433977176901,-0.73357114160899073,-0.59784497352666222,-0.30896671887603588,1.9306207832414657,-2.647138899192214,-0.69088287091290113,1.6237254385487176,0.55877990234876052,-1.6449575923616067,0.41136217987514101,-1.1534507393662352,-1.9321032596053556,1.3763747119810432,1.6367266653105617,0.23198026610771194,0.67062956077279523,-0.16246758605120704,-0.13632075024361257,0.37614540815411601,0.57540091802366078,-2.3482789401896298,0.13060912351647858,-0.69916268330416642,-0.2644856067490764,-0.22860263015900273,-1.0095891411765479,-6.8404233388719149E-2,-0.60959337133681402,-0.39435462895198725,-0.89760533228400163,-1.0639269021339715,-0.14095462574914563,1.3460430636769161,-0.39435462895198725,0.238428583543282,0.3100092271779431,1.1454517334641423,0.48762899496068712,0.7184371497714892,2.4485416361130774,1.2071814126102254,-1.7674619812169112,0.42254441723343916,-1.0143116924155038,0.35569655665312894,-0.33725655157468282,0.25009398996189702,-0.47286221160902642,-1.2731970855384134,-1.5338628145400435E-2,-0.92295749709592201,0.50675907914410345,-0.74019453677465208,0.18592459127830807,-1.4673651094199158,1.0113717507920228,-5.7366378314327449E-2,1.1087786333519034,-0.48625111048750114,0.66881057136924937,2.3667598725296557,-0.24938344722613692,1.9486924429656938,-0.88418119048583321,0.32521597859158646,0.69039742811582983,0.9619589036446996,-0.25696635930216871,-0.86934960563667119,-1.7362344806315377,-1.5666728359065019,-0.40620648178446572,-0.5972037797619123,-0.3692571226565633,-0.56325689001823775,7.6228161560720764E-2,-7.1855765781947412E-2,-0.66355823946651071,0.44498392526293173,-0.20003085410280619,-0.83774693848681636,-0.35749053495237604,-0.25799408831517212,1.718217390589416,0.77350705396384001,-0.29543343771365471,-0.66613438320928253,0.76671540227835067,-1.4759461919311434,-0.14768033906875644,-0.29255829758767504,1.1624229045992251,0.81631696957629174,-0.36336814446258359,-0.96268877314287238,0.15007799447630532,1.0074245437863283,-0.52397126637515612,-1.4885699783917516,0.51713755055970978,-0.78594780461571645,0.73647697718115523,0.74301510721852537,-0.17364072846248746,-0.91525635070865974,-1.2889813660876825E-2,-2.0712923287646845,0.4882326720689889,-0.99216777016408741,0.85206693256623112,2.8905924409627914,0.40271970647154376,-9.3425569502869621E-2,-0.56379576562903821,-0.54399606597144157,5.0318931243964471E-2,-0.81067128121503629,0.20042079995619133,-0.52977156883571297,-0.62458639149554074,-0.21284677131916396,-0.74543777373037301,-0.82973201642744243,0.60059164752601646,1.4964916772441939,4.5340584620134905E-2,1.4869510778225958,2.0539664546959102,2.0235120246070437E-2,-0.42430201574461535,-2.2391395759768784,2.0305742509663105,0.41844941733870655,0.80876020547293592,-0.70935584517428651,8.5974534158594906E-2,-0.20088918972760439,-0.20221705199219286,-0.24551809474360198,-1.1308338798698969,2.3191569198388606,0.26361476557212882,-1.6288913684547879,-3.6689016269519925E-2,0.25799408831517212,-0.75771367846755311,0.64216237660730258,7.1778458732296713E-2,0.45794422476319596,-0.91467427409952506,1.1283714229648467,0.33604237614781596,-0.70023588705225848,1.4660190572612919,1.16755018098047,-0.5617334863927681,-0.85217607193044387,0.83948634710395709,-0.88576598500367254,0.27567239158088341,0.35545212995202746,-1.164830791822169,1.5695513866376132,-0.62337676354218274,-0.53364829000202008,0.57666511565912515,-0.61374521465040743,1.063388026523171,1.3953604138805531,-1.3617272998089902,-4.120579433219973E-2,1.1178781278431416,0.98704958872986026,2.0019524527015164,-0.87192120190593414,0.2860974745999556,0.34910272006527521,0.92424670583568513,-0.48935362428892404,0.39923747863213066,-2.0913103071507066,1.4709667084389366,1.0798225957842078,0.74958506957045756,-0.18646915123099461,1.1445672498666681,8.9892182586481795E-2,-1.4624401956098154,0.54648126024403609,1.2411646821419708,0.17371803551213816,1.9600520317908376,0.62588810578745324,0.63493871493847109,1.1774363883887418,-0.5118977242091205,0.21261257643345743,1.0896042113017756,-1.0846315490198322,-1.8012906366493553,-3.4086724554072134E-2,-1.6856620277394541,-0.49565755944058765,-0.32392563298344612,0.29136117518646643,-0.16588046491960995,-1.7792535800253972,-0.31113359000300989,-0.47791672841412947,-0.4673950115829939,0.85294686869019642,1.4035049389349297,1.200862698169658,0.67149130700272508,0.62579488258052152,0.77330014391918667,-0.43377895053708926,0.18600189832795877,0.36852043194812723,0.45319211494643241,1.7115598893724382,0.65130848270200659,0.36827486837864853,2.2335370886139572,-0.15572823031106964,1.1231804819544777,0.35243829188402742,-8.0831341620068997E-2,-1.5822615750948898,-1.4154011296341196E-3,0.73337105277460068,-1.2692498785327189,-0.15696741684223525,0.8316783350892365,-2.6845373213291168,0.10472604117239825,-1.6639205568935722E-2,-1.1513066056068055E-2,0.65130848270200659,-2.6203679226455279E-2,-0.50128733164456207,-0.39468545764975715,-0.86189629655564204,-0.54426209317171015,1.0824305718415417,1.4472334441961721,5.7060560720856301E-2,-0.64837877289392054,-1.219959813170135,-0.83525037553044967,2.2083077055867761,-1.6286048776237294,-0.60168986237840727,-0.53983285397407599,-1.1661904864013195,0.2083891104120994,-0.28291083253861871,-1.1586735126911663,-0.42296278479625471,1.0959979590552393,-0.86444970293086953,-1.5267050912370905,-0.49834056881081779,-0.38329858398356009,-3.2632669899612665E-2,0.22970198187977076,-0.58245632317266427,0.79378651207662188,-1.5208388504106551,-0.87337639342877083,-0.2568879153841408,-1.0889129953284282,-2.0739207684528083,-1.3319800018507522,0.37007680475653615,-2.5820554583333433E-2,-1.1657380127871875,-1.2661757864407264,0.29120087674527895,1.2544956007332075,-1.9543404050637037,-2.076549208140932,-0.39410679164575413,-0.30607907319790684,-0.15239947970258072,-1.4472334441961721,1.2207647159812041,0.37220729609543923,0.83405893747112714,1.0496205504750833,-1.9590152078308165,-0.26646603146218695,0.53488292905967683,-0.90645244199549779,0.44768853513232898,-0.53118014875508379,-0.44127091314294375,-0.10611074685584754,1.1451584214228205,-0.64526830101385713,-1.0867006494663656,0.69117504608584568,-0.15448904377990402,-1.710895958240144,-0.36377628021000419,-1.5286695997929201,-0.24425730771326926,1.3012231647735462,-0.43596514842647593,-0.80082827480509877,2.0660991140175611,0.44287389755481854,1.241496647708118,0.496090706292307,-1.9189155864296481,1.2973077900824137,0.53029907576274127,0.14080001164984424]
["Row 2","Retrieved coefficient from distribution (30 cells)",null,{"$f":"(OFFSET($B$2,0,RANDBETWEEN(1,800)))","v":-0.53364829000202008},{"$f":"(OFFSET($B$2,0,RANDBETWEEN(1,800)))","v":-0.95204313765862025},{"$f":"(OFFSET($B$2,0,RANDBETWEEN(1,800)))","v":-0.81067128121503629},0.30391447580768727,1.4035049389349297,-0.87517037172801793,-1.2218947631481569,-2.7107307687401772,0.261080685959314,-0.3692571226565633,-1.8393802747596055,-1.3203680282458663,-1.4673651094199158,-1.7393540474586189,2.4754626792855561,0.67062956077279523,-0.92295749709592201,-1.7256297724088654,-0.14713805285282433,0.65130848270200659,0.25127746994257905,0.69039742811582983,0.29120087674527895,0.98754753707908094,1.16755018098047,1.1778956832131371,1.241496647708118,-1.7638285498833284,-0.63953166318242438,0.1983926267712377,-1.1586735126911663]
[]
[null,"Input of values and known/assumed variation for model parameters of interest (enter values)"]
[null,"Labels for model parameters ",null,null,"Parameter 1","Parameter 2","etc."]
["Row 3","Original values for model parameters that should vary in the simulation (30 cells available)"]
["Row 4","Known/assumed standard deviation for each varying model parameter (30 cells available)"]
[]
[null,"Calculation of parameter value to be used in the simulation (expand formulas to the right as required)"]
["Row 5","Random coefficients are multiplied with the known/assumed parameter standard deviations (30 cells available)",null,{"$f":"D3*D8","v":0},{"$f":"E3*E8","v":0},{"$f":"F3*F8","v":0},0,0]
["Row 6","Results are added to the original values  and checked for non-negativety = New parameter value (30 cells available)",null,{"$f":"IF((D7+D11)>0,(D7+D11),0)","v":0},{"$f":"IF((E7+E11)>0,(E7+E11),0)","v":0},{"$f":"IF((F7+F11)>0,(F7+F11),0)","v":0},0,0]
[]
[null,"Input in model of parameters with simulated variation and retrieval of simulation results (expand formulas to the right as required and link to your model. Also link outdata of interest from your model to the same row)"]
[null,"Insert labels for variable model parameters and outdata variables of interest",null,null,"Parameter 1","Parameter 2","etc."]
["Row 7","Parameter values to be used are linked from Row 6 and then further linked to the formulas in the model.",null,{"$f":"D12","v":0}]
["Row 7","Outdata cells of interest from the model are also linked to Row 7, to the right of your varying parameters"]
["Row 7","The row is after each recalculation copied to the outdatarange/database below (50 cells)"]
[]
[null,"Requested number of simulations:",100]
[null,"Performed number of simulations:"]
[]
[null,null,"Outdatarange below. Cell contents may be deleted but do not remove rows or cells!"]
[null,null,null,null,{"$f":"E15","v":"Parameter 1"},{"$f":"F15","v":"Parameter 2"},"etc.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Instructions","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}