{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["10.1","10.2"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"10.1","index":0,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[8,2,8,3],[8,4,8,5],[8,7,8,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"AIP1",null,"AIP2",null,null,"Allocation"]
[null,null,"DF Allocation","Bidding","DF Allocation","Bidding",null,null,"AIP1",null,"AIP2"]
[null,"Member A",150,null,200,null,null,{"$f":"B11&\" (\"&D37&\")\"","v":"Member A (WINNER)"},{"$f":"TRANSPOSE(AIP_Allocation(C37:C40,C11:C14,D16))","v":0},{"$f":"B11&\" (\"&F37&\")\"","v":"Member A (LOSING)"},{"$f":"TRANSPOSE(AIP_Allocation(E37:E40,E11:E14,F16))","v":44.444444444444443}]
[null,"Member B",200,null,250,null,null,{"$f":"B12&\" (\"&D38&\")\"","v":"Member B (LOSING)"},133.33333333333334,{"$f":"B12&\" (\"&F38&\")\"","v":"Member B (LOSING)"},55.555555555555557]
[null,"Member C",250,null,350,null,null,{"$f":"B13&\" (\"&D39&\")\"","v":"Member C (LOSING)"},166.66666666666666,"Member C (WINNER)",0]
[null,"Member D",0,null,400,null,null,{"$f":"B14&\" (\"&D40&\")\"","v":"Member D (NO BID)"},0,"Member D (NO BID)",400]
[null,"Total",{"$f":"SUM(C11:C14)","v":600},{"$f":"IF(COUNTIF(C37:C40,\"=1\")<1,\"Must have one winning bidder\",\"\")","v":""},{"$f":"SUM(E11:E14)","v":1200},{"$f":"IF(COUNTIF(E37:E40,\"=1\")<1,\"Must have one winning bidder\",\"\")","v":""},null,"Total",{"$f":"SUM(I11:I14)","v":300},null,{"$f":"SUM(K11:K14)","v":500}]
[null,"Actual Loss",300,{"$f":"IF(AND(AIP2Loss>AIP2DF,AIP1Loss<AIP1DF),AIP1Loss+AIP2Loss-AIP2DF,AIP1Loss)","v":300},500,{"$f":"IF(AND(AIP1Loss>AIP1DF,AIP2Loss<AIP2DF),AIP2Loss+AIP1Loss-AIP1DF,AIP2Loss)","v":500}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WINNING",1,{"$f":"IF(C37=1,\"WINNER\",IF(C37=2,\"LOSING\",\"NO BID\"))","v":"WINNER"},2,{"$f":"IF(E37=1,\"WINNER\",IF(E37=2,\"LOSING\",\"NO BID\"))","v":"LOSING"}]
[null,"NON-WINNING",2,{"$f":"IF(C38=1,\"WINNER\",IF(C38=2,\"LOSING\",\"NO BID\"))","v":"LOSING"},2,"LOSING"]
[null,"NO BID",2,"LOSING",1,"WINNER"]
[null,null,3,"NO BID",3,"NO BID"]

{"sheet":"10.2","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,1,8,2],[20,1,20,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Inputs"]
[null,"CCP resources",10]
[null,"Auction cost",0]
[null,"MTM change ",0.05]
[]
[null,null,"Notional","Default?","MTM","Payment","VM Haircut","Tear-up"]
[null,"Member A",-100,false,{"$f":"C15*$C$12","v":-5},{"$f":"IF(D15=TRUE,0,E15)","v":-5},{"$f":"IF(E15<0,0,F15*VMGHPercentage)","v":0},{"$f":"IF(E15<0,0,C15*TearUpPercentage)","v":0}]
[null,"Member B",240,false,{"$f":"C16*$C$12","v":12},{"$f":"IF(D16=TRUE,0,E16)","v":12},{"$f":"IF(E16<0,0,F16*VMGHPercentage)","v":3},{"$f":"IF(E16<0,0,C16*TearUpPercentage)","v":0}]
[null,"Member C",160,false,{"$f":"C17*$C$12","v":8},8,{"$f":"IF(E17<0,0,F17*VMGHPercentage)","v":2},{"$f":"IF(E17<0,0,C17*TearUpPercentage)","v":0}]
[null,"Member D",-300,true,{"$f":"C18*$C$12","v":-15},0,{"$f":"IF(E18<0,0,F18*VMGHPercentage)","v":0},{"$f":"IF(E18<0,0,C18*TearUpPercentage)","v":0}]
[null,null,{"$f":"IF(SUM(C15:C18)<>0,\"ERROR: CCP does not have matched book\",\"\")","v":""}]
[]
[null,"Calculations"]
[null,"MTM loss",{"$f":"-SUMIF(D15:D18,TRUE,E15:E18)","v":15}]
[null,"VM out",{"$f":"SUMIF(E15:E18,\">0\")","v":20}]
[null,"VM in",{"$f":"-SUMIF(F15:F18,\"<0\")","v":5}]
[null,"Net resources",{"$f":"CCPResources+VMIn-AuctionCost","v":15}]
[null,"VMGH %",{"$f":"1-MAX(0, MIN(NetResources/VMOut,1))","v":0.25},null,{"$f":"\"VMGH \"&IF(NetResources>=VMOut,\"unnecessary\",IF(NetResources<0, \"fails\",\"works with a haircut of \"&TEXT(VMGHPercentage,\"0%\")))","v":"VMGH works with a haircut of 25%"}]
[null,"Tear-up %",{"$f":"IF(AuctionCost=0,0,1-MAX((CCPResources+VMIn-VMOut)/AuctionCost,0))","v":0},null,{"$f":"IF(AuctionCost=0,\"Tear-up unnecessary\",\"Tear-up \"& TEXT(TearUpPercentage,\"0%\")& \" and pay \"&TEXT((CCPResources+VMIn-(1-TearUpPercentage)*AuctionCost)/VMOut,\"0%\")&\" of MTM\")","v":"Tear-up unnecessary"}]