{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["4cntrptys","5cntrptys","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":99,"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":"4cntrptys","index":0,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"TRANSPOSE(B3:B6)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4",null,"Net",null,null,null,{"$f":"TRANSPOSE(K3:K6)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4",null,"Net"]
[null,"Cntrpty 1",0,35,15,-40,null,{"$f":"SUM(C3:F3)","v":10},null,null,"Cntrpty 1",0,10,0,0,null,{"$f":"SUM(L3:O3)","v":10}]
[null,"Cntrpty 2",{"$f":"-D3","v":-35},0,60,-15,null,{"$f":"SUM(C4:F4)","v":10},null,null,"Cntrpty 2",{"$f":"-M3","v":-10},0,0,20,null,{"$f":"SUM(L4:O4)","v":10}]
[null,"Cntrpty 3",{"$f":"-E3","v":-15},{"$f":"-E4","v":-60},0,65,null,{"$f":"SUM(C5:F5)","v":-10},null,null,"Cntrpty 3",{"$f":"-N3","v":0},{"$f":"-N4","v":0},0,-10,null,{"$f":"SUM(L5:O5)","v":-10}]
[null,"Cntrpty 4",{"$f":"-F3","v":40},{"$f":"-F4","v":15},{"$f":"-F5","v":-65},0,null,{"$f":"SUM(C6:F6)","v":-10},null,null,"Cntrpty 4",{"$f":"-O3","v":0},{"$f":"-O4","v":-20},{"$f":"-O5","v":10},0,null,{"$f":"SUM(L6:O6)","v":-10}]
[]
[null,null,{"$f":"SUMPRODUCT(C3:F6,C3:F6)","v":22200}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(L3:O6,L3:O6)","v":1200}]
[null,null,{"$f":"TRANSPOSE(B11:B14)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4",null,"Net"]
[null,"Cntrpty 1",0,0,5,5,null,{"$f":"SUM(C11:F11)","v":10}]
[null,"Cntrpty 2",{"$f":"-D11","v":0},0,5,5,null,{"$f":"SUM(C12:F12)","v":10}]
[null,"Cntrpty 3",{"$f":"-E11","v":-5},{"$f":"-E12","v":-5},0,0,null,{"$f":"SUM(C13:F13)","v":-10}]
[null,"Cntrpty 4",{"$f":"-F11","v":-5},{"$f":"-F12","v":-5},{"$f":"-F13","v":0},0,null,{"$f":"SUM(C14:F14)","v":-10}]
[]
[]
[null,null,{"$f":"SUMPRODUCT(C11:F14,C11:F14)","v":200}]

{"sheet":"5cntrptys","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"TRANSPOSE(B3:B7)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Net"]
[null,"Cntrpty 1",0,95,0,-105,20,{"$f":"SUM(C3:G3)","v":10}]
[null,"Cntrpty 2",{"$f":"-D3","v":-95},0,85,-60,95,{"$f":"SUM(C4:G4)","v":25}]
[null,"Cntrpty 3",{"$f":"-E3","v":0},{"$f":"-E4","v":-85},0,70,-20,-35]
[null,"Cntrpty 4",{"$f":"-F3","v":105},{"$f":"-F4","v":60},{"$f":"-F5","v":-70},0,-75,20]
[null,"Cntrpty 5",{"$f":"-G3","v":-20},{"$f":"-G4","v":-95},{"$f":"-G5","v":20},{"$f":"-G6","v":75},0,-20]
[null,null,{"$f":"SUMIF(C3:G7,\">0\")-SUMIF(C3:G7,\"<0\")","v":1250},{"$f":"SUMPRODUCT(C3:G7,C3:G7)","v":102450},null,null,null,{"$f":"SUM(H3:H7)","v":0}]
[]
[null,null,{"$f":"TRANSPOSE(B11:B15)","v":"Cntrpty 1"},"Cntrpty 2","Cntrpty 3","Cntrpty 4","Cntrpty 5","Net"]
[null,"Cntrpty 1",0,95,0,-105,20,{"$f":"SUM(C11:G11)","v":10}]
[null,"Cntrpty 2",{"$f":"-D11","v":-95},0,85,-60,95,{"$f":"SUM(C12:G12)","v":25}]
[null,"Cntrpty 3",{"$f":"-E11","v":0},{"$f":"-E12","v":-85},0,70,-20,-35]
[null,"Cntrpty 4",{"$f":"-F11","v":105},{"$f":"-F12","v":60},{"$f":"-F13","v":-70},0,-75,20]
[null,"Cntrpty 5",{"$f":"-G11","v":-20},{"$f":"-G12","v":-95},{"$f":"-G13","v":20},{"$f":"-G14","v":75},0,-20]
[null,null,{"$f":"SUMIF(C11:G15,\">0\")-SUMIF(C11:G15,\"<0\")","v":1250},{"$f":"SUMPRODUCT(C11:G15,C11:G15)","v":102450},null,null,null,{"$f":"SUM(H11:H15)","v":0}]

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