{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Spreadsheet4.1"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":0,"defined_names":27,"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":"Spreadsheet4.1","index":0,"n_rows":113,"n_cols":6,"rows_kept":113,"cut":false,"hidden":false,"merged":[[8,1,8,2],[8,4,8,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Parameters",null,null,"Overall Exposure"]
[null,"Mean",2,null,"No Netting",{"$f":"SUMIF(B14:B113,\">0\")","v":587.52494267770885}]
[null,"Standard deviation",10,null,"With Netting",{"$f":"MAX(0, SUM(B14:B113))","v":310.0210959387453}]
[null,null,null,null,"Netting factor",{"$f":"F11/F10","v":0.52767307976030842}]
[null,"MtM Values"]
[null,{"$f":"MeanMtM+NORMSINV(RAND())*StdDevMtM","v":22.80533691719549}]
[null,31.751956896318475]
[null,-1.5758358241358703]
[null,21.234551955519695]
[null,11.866333088306522]
[null,6.586484212528271]
[null,-10.586165619611844]
[null,-0.23792509505316328]
[null,18.347440254374948]
[null,0.20716206470642451]
[null,-6.2553648803951134]
[null,-1.3896793135245868]
[null,8.9028943414555215]
[null,-14.18048456154736]
[null,11.064532869642322]
[null,0.48768569946731444]
[null,-5.9947396786089602]
[null,-3.0300705786623459]
[null,7.872096820236802]
[null,-13.643724153850652]
[null,-6.9312018235643329]
[null,10.202441523592714]
[null,-10.181435655510167]
[null,26.873590226547321]
[null,4.2495964773519708]
[null,2.2636136279885815]
[null,-1.5781588781914886]
[null,3.6183007469077815]
[null,-6.826119705590532]
[null,3.014268105991996]
[null,8.6260025218070382]
[null,13.64963396616127]
[null,{"$f":"MeanMtM+NORMSINV(RAND())*StdDevMtM","v":-0.94353770530621395}]
[null,11.423479771201727]
[null,7.0544832600651199]
[null,22.369386947993526]
[null,0.65405032985419242]
[null,10.685418634929141]
[null,-7.2384993302656717]
[null,2.6002836189300993E-2]
[null,4.9410898253130338]
[null,-13.300397954630085]
[null,13.994707363589679]
[null,-6.5286748246570117]
[null,-17.115686329815272]
[null,3.6615166106800237]
[null,2.2356137867976704]
[null,7.3410157372470923]
[null,2.073660253408649]
[null,2.253926218320208]
[null,6.1497800792000348]
[null,20.283760264987102]
[null,3.5460352813543601]
[null,-0.64934426519438171]
[null,-27.959282138437274]
[null,-3.0335255523857807]
[null,25.377989809798791]
[null,7.548610351434073]
[null,9.5584791554189117]
[null,8.6969530152042402]
[null,-9.10073150896649]
[null,-8.7216520629160943]
[null,19.522216746539311]
[null,7.1125831948201483]
[null,{"$f":"MeanMtM+NORMSINV(RAND())*StdDevMtM","v":-7.6589005841256839}]
[null,-16.236906296922971]
[null,-6.4121614155985664]
[null,4.9110833331668768]
[null,5.1125109377440445]
[null,-0.21329630765954199]
[null,10.558193295686404]
[null,-2.2915672935014477]
[null,-1.0702460120385204]
[null,9.8118034038618251]
[null,-3.3909005232693925]
[null,-4.2731796764975281]
[null,2.2239235093882979]
[null,-1.387529362566168]
[null,6.3325030650329408]
[null,18.494082650649752]
[null,13.164199151936254]
[null,14.168399634475488]
[null,-16.360693038918633]
[null,7.7574924221945007]
[null,-5.214798872156023]
[null,14.318396576752221]
[null,-5.557457612378049]
[null,0.7695334817058912]
[null,-9.4123954014874389E-2]
[null,1.9817192550661302]
[null,-3.7250004518008932]
[null,-22.275003476641835]
[null,10.278856187602395]
[null,0.17618096555774265]
[null,13.512022683586638]
[null,15.369294807580257]
[null,6.6459466298983578]
[null,10.869522593289469]
[null,10.934596302086613]
[null,-4.339844420052632]