{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["5cntrptys","10cntrptys"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":100,"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":"5cntrptys","index":0,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,1,6,7],[14,1,14,7],[22,1,22,7]]}
[]
[]
[]
[]
[]
[]
[null,"Starting Point"]
[null,null,{"$f":"TRANSPOSE(B9:B13)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Total"]
[null,"Cntrpty 1",null,95,0,-105,20,{"$f":"SUM(C9:G9)","v":10},null,"Total Notional",{"$f":"SUMIF(C9:G13,\">0\")-SUMIF(C9:G13,\"<0\")","v":1250}]
[null,"Cntrpty 2",{"$f":"-D9","v":-95},null,85,-60,95,{"$f":"SUM(C10:G10)","v":25},null,"Total Notional^2",{"$f":"SUMPRODUCT(C9:G13,C9:G13)","v":102450}]
[null,"Cntrpty 3",{"$f":"-E9","v":0},{"$f":"-E10","v":-85},null,70,-20,{"$f":"SUM(C11:G11)","v":-35},null,"Zeros",{"$f":"COUNTIF(C9:H13,\"=0\")","v":2}]
[null,"Cntrpty 4",{"$f":"-F9","v":105},{"$f":"-F10","v":60},{"$f":"-F11","v":-70},null,-75,{"$f":"SUM(C12:G12)","v":20}]
[null,"Cntrpty 5",{"$f":"-G9","v":-20},{"$f":"-G10","v":-95},{"$f":"-G11","v":20},{"$f":"-G12","v":75},null,{"$f":"SUM(C13:G13)","v":-20}]
[]
[null,"Solver"]
[null,null,{"$f":"TRANSPOSE(B17:B21)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Total"]
[null,"Cntrpty 1",null,9.9999999999999911,0,0,0,{"$f":"SUM(C17:G17)","v":9.9999999999999911},{"$f":"IF(ABS(H9-H17)>0.0001,\"FAIL\",\"\")","v":""},"Total Notional",{"$f":"SUMIF(C17:G21,\">0\")-SUMIF(C17:G21,\"<0\")","v":130}]
[null,"Cntrpty 2",{"$f":"-D17","v":-9.9999999999999911},null,35,0,0,{"$f":"SUM(C18:G18)","v":25.000000000000007},{"$f":"IF(ABS(H10-H18)>0.0001,\"FAIL\",\"\")","v":""},"Total Notional^2",{"$f":"SUMPRODUCT(C17:G21,C17:G21)","v":3449.9999999999995}]
[null,"Cntrpty 3",{"$f":"-E17","v":0},{"$f":"-E18","v":-35},null,0,0,{"$f":"SUM(C19:G19)","v":-35},{"$f":"IF(ABS(H11-H19)>0.0001,\"FAIL\",\"\")","v":""},"Zeros",{"$f":"COUNTIF(C17:H21,\"=0\")","v":14}]
[null,"Cntrpty 4",{"$f":"-F17","v":0},{"$f":"-F18","v":0},{"$f":"-F19","v":0},null,20.000000000000004,{"$f":"SUM(C20:G20)","v":20.000000000000004},{"$f":"IF(ABS(H12-H20)>0.0001,\"FAIL\",\"\")","v":""}]
[null,"Cntrpty 5",{"$f":"-G17","v":0},{"$f":"-G18","v":0},{"$f":"-G19","v":0},{"$f":"-G20","v":-20.000000000000004},null,{"$f":"SUM(C21:G21)","v":-20.000000000000004},{"$f":"IF(ABS(H13-H21)>0.0001,\"FAIL\",\"\")","v":""}]
[]
[null,"Tri Compression Algorithm"]
[null,null,{"$f":"TRANSPOSE(B25:B29)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Total"]
[null,"Cntrpty 1",{"$f":"TriCompress(C9:G13)","v":0},0,0,10,0,{"$f":"SUM(C25:G25)","v":10},{"$f":"IF(ABS(H9-H25)>0.0001,\"FAIL\",\"\")","v":""},"Total Notional",{"$f":"SUMIF(C25:G29,\">0\")-SUMIF(C25:G29,\"<0\")","v":140}]
[null,"Cntrpty 2",0,0,0,0,25,{"$f":"SUM(C26:G26)","v":25},{"$f":"IF(ABS(H10-H26)>0.0001,\"FAIL\",\"\")","v":""},"Total Notional^2",{"$f":"SUMPRODUCT(C25:G29,C25:G29)","v":3300}]
[null,"Cntrpty 3",0,0,0,-30,-5,-35,{"$f":"IF(ABS(H11-H27)>0.0001,\"FAIL\",\"\")","v":""},"Zeros",{"$f":"COUNTIF(C25:H29,\"=0\")","v":12}]
[null,"Cntrpty 4",-10,0,30,0,0,20,{"$f":"IF(ABS(H12-H28)>0.0001,\"FAIL\",\"\")","v":""}]
[null,"Cntrpty 5",0,-25,5,0,0,-20,{"$f":"IF(ABS(H13-H29)>0.0001,\"FAIL\",\"\")","v":""}]

{"sheet":"10cntrptys","index":1,"n_rows":44,"n_cols":16,"rows_kept":44,"cut":false,"hidden":false,"merged":[[6,1,6,12],[19,1,19,12],[32,1,32,12]]}
[]
[]
[]
[]
[]
[]
[null,"Starting Point"]
[null,null,"Cntrpty 1","Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Cntrpty 6","Cntrpty 7","Cntrpty 8","Cntrpty 9","Cntrpty 10","Total"]
[null,"Cntrpty 1",null,50,30,20,-40,-50,30,-40,50,-50,{"$f":"SUM(C9:L9)","v":0},null,"Total Notional",{"$f":"SUMIF(C9:L18,\">0\")-SUMIF(C9:L18,\"<0\")","v":2840}]
[null,"Cntrpty 2",{"$f":"-TRANSPOSE(D9:L9)","v":-50},null,50,-20,40,-20,-30,30,-20,40,20,null,"Total Notional^2",{"$f":"SUMPRODUCT(C9:L18,C9:L18)","v":108800}]
[null,"Cntrpty 3",-30,{"$f":"-TRANSPOSE(E10:L10)","v":-50},null,40,60,-30,40,-10,30,0,50,null,"Connections",{"$f":"(COUNTIF(C9:L18,\">0.00001\")+COUNTIF(C9:L18,\"<-0.00001\"))/2","v":43}]
[null,"Cntrpty 4",-20,20,{"$f":"-TRANSPOSE(F11:L11)","v":-40},null,20,-50,-50,-20,40,40,-60]
[null,"Cntrpty 5",40,-40,-60,{"$f":"-TRANSPOSE(G12:L12)","v":-20},null,-20,0,20,10,-20,-90]
[null,"Cntrpty 6",50,20,30,50,{"$f":"-TRANSPOSE(H13:L13)","v":20},null,-50,20,-50,20,110]
[null,"Cntrpty 7",-30,30,-40,50,0,{"$f":"-TRANSPOSE(I14:L14)","v":50},null,-50,20,20,50]
[null,"Cntrpty 8",40,-30,10,20,-20,-20,{"$f":"-TRANSPOSE(J15:L15)","v":50},null,20,30,100]
[null,"Cntrpty 9",-50,20,-30,-40,-10,50,-20,{"$f":"-TRANSPOSE(K16:L16)","v":-20},null,30,-70]
[null,"Cntrpty 10",50,-40,0,-40,20,-20,-20,-30,{"$f":"-TRANSPOSE(L17)","v":-30},null,-110]
[]
[null,"Solution"]
[null,null,"Cntrpty 1","Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Cntrpty 6","Cntrpty 7","Cntrpty 8","Cntrpty 9","Cntrpty 10","Total"]
[null,"Cntrpty 1",{"$f":"TriCompress(C9:L18)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(C22:L22)","v":0},{"$f":"IF(ABS(M9-M22)>0.0001,\"FAIL\",\"\")","v":""},"Total Notional",{"$f":"SUMIF(C22:L31,\">0\")-SUMIF(C22:L31,\"<0\")","v":840}]
[null,"Cntrpty 2",0,0,0,0,0,0,0,0,0,20,20,"","Total Notional^2",{"$f":"SUMPRODUCT(C22:L31,C22:L31)","v":46800}]
[null,"Cntrpty 3",0,0,0,0,0,40,0,10,0,0,50,"","Connections",{"$f":"(COUNTIF(C22:L31,\">0.00001\")+COUNTIF(C22:L31,\"<-0.00001\"))/2","v":12}]
[null,"Cntrpty 4",0,0,0,0,0,0,0,-60,0,0,-60,""]
[null,"Cntrpty 5",0,0,0,0,0,-110,0,20,0,0,-90,""]
[null,"Cntrpty 6",0,0,-40,0,110,0,0,0,30,10,110,""]
[null,"Cntrpty 7",0,0,0,0,0,0,0,0,20,30,50,""]
[null,"Cntrpty 8",0,0,-10,60,-20,0,0,0,20,50,100,""]
[null,"Cntrpty 9",0,0,0,0,0,-30,-20,-20,0,0,-70,""]
[null,"Cntrpty 10",0,-20,0,0,0,-10,-30,-50,0,0,-110,""]
[]
[null,"Solution",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ABS(M22-M33)>0.0001,\"FAIL\",\"\")","v":""}]
[null,null,"Cntrpty 1","Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Cntrpty 6","Cntrpty 7","Cntrpty 8","Cntrpty 9","Cntrpty 10","Total"]
[null,"Cntrpty 1",null,50,30,20,-40,-50,30,-40,50,-50,{"$f":"SUM(C35:L35)","v":0},"","Total Notional",{"$f":"SUMIF(C35:L44,\">0\")-SUMIF(C35:L44,\"<0\")","v":2840}]
[null,"Cntrpty 2",{"$f":"-TRANSPOSE(D35:L35)","v":-50},null,50,-20,40,-20,-30,30,-20,40,20,"","Total Notional^2",{"$f":"SUMPRODUCT(C35:L44,C35:L44)","v":108800}]
[null,"Cntrpty 3",-30,{"$f":"-TRANSPOSE(E36:L36)","v":-50},null,40,60,-30,40,-10,30,0,50,"","Connections",{"$f":"(COUNTIF(C35:L44,\">0.00001\")+COUNTIF(C35:L44,\"<-0.00001\"))/2","v":43}]
[null,"Cntrpty 4",-20,20,{"$f":"-TRANSPOSE(F37:L37)","v":-40},null,20,-50,-50,-20,40,40,-60,""]
[null,"Cntrpty 5",40,-40,-60,{"$f":"-TRANSPOSE(G38:L38)","v":-20},null,-20,0,20,10,-20,-90,""]
[null,"Cntrpty 6",50,20,30,50,{"$f":"-TRANSPOSE(H39:L39)","v":20},null,-50,20,-50,20,110,""]
[null,"Cntrpty 7",-30,30,-40,50,0,{"$f":"-TRANSPOSE(I40:L40)","v":50},null,-50,20,20,50,""]
[null,"Cntrpty 8",40,-30,10,20,-20,-20,{"$f":"-TRANSPOSE(J41:L41)","v":50},null,20,30,100,""]
[null,"Cntrpty 9",-50,20,-30,-40,-10,50,-20,{"$f":"-TRANSPOSE(K42:L42)","v":-20},null,30,-70,""]
[null,"Cntrpty 10",50,-40,0,-40,20,-20,-20,-30,{"$f":"-TRANSPOSE(L43)","v":-30},null,-110,""]