{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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":"Sheet1","index":0,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["valuation date","Payment\nDate","Contributors","Contribution","Last NAV","Total Value","Redemptions","NAV after Redemptions","distributable returns","Gain per member","Gross NAV","Mgt Fee","Current NAV"]
["2016-05-31","2016-05-27","Adom Gideon",25,null,{"$f":"+SUM($D2:$E2)","v":25},null,{"$f":"SUM($F2,-$G2)","v":25},{"$f":"SUMIF([1]InterestSharing!$K:$K,$A2,[1]InterestSharing!$I:$I)","v":2.2849315068493152},null,{"$f":"+SUM($H2,$J2)","v":25},{"$f":"+$K2*2.5/100*0.0833333333333333","v":5.2083333333333315E-2},{"$f":"SUM($K2,-$L2)","v":24.947916666666668}]
[null,"2016-05-27","Borsuwie Mahamah Kushiatu",18.75,null,18.75,null,18.75,null,null,18.75,3.9062499999999986E-2,18.7109375]
[null,"2016-05-27","Charity Appiah Kubi",37.5,null,37.5,null,37.5,null,null,37.5,7.8124999999999972E-2,37.421875]
[null,"2016-05-27","Isaiah Brobbey",56.25,null,56.25,null,56.25,null,null,56.25,0.11718749999999996,56.1328125]
[null,"2016-05-27","Lambert Kofi Osei",320,null,320,null,320,null,null,320,0.66666666666666641,319.33333333333331]
[null,"2016-05-27","Patricia Asare",25,null,25,null,25,null,null,25,5.2083333333333315E-2,24.947916666666668]
[null,"2016-05-27","Stephen Banenjo",150,null,150,null,150,null,null,150,0.31249999999999989,149.6875]
[null,"2016-05-27","Wilhemina Osei Akomeah",37.5,null,37.5,null,37.5,null,null,37.5,7.8124999999999972E-2,37.421875]
[null,"2016-05-27","Yaw Asiedu",25,null,25,null,25,null,null,25,5.2083333333333315E-2,24.947916666666668]
[null,null,null,{"$f":"SUM(D2:D10)","v":695},{"$f":"SUM(E2:E10)","v":0},{"$f":"SUM(F2:F10)","v":695},{"$f":"SUM(G2:G10)","v":0},{"$f":"SUM(H2:H10)","v":695},null,null,{"$f":"SUM(K2:K10)","v":695},{"$f":"SUM(L2:L10)","v":1.4479166666666659},{"$f":"SUM(M2:M10)","v":693.55208333333337}]
[]
["2016-06-30","2016-06-15","Adom Gideon",25,null,{"$f":"+SUM($D13:$E13)","v":25},null,{"$f":"SUM($F13,-$G13)","v":25},{"$f":"SUMIF([1]InterestSharing!$K:$K,$A13,[1]InterestSharing!$I:$I)","v":29.723589041095892},null,{"$f":"+SUM($H13,$J13)","v":25},{"$f":"+$K13*2.5/100*0.0833333333333333","v":5.2083333333333315E-2},{"$f":"SUM($K13,-$L13)","v":24.947916666666668}]
[null,"2016-06-15","Borsuwie Mahamah Kushiatu",18.75,null,18.75,null,18.75,null,null,18.75,3.9062499999999986E-2,18.7109375]
[null,"2016-06-15","Charity Appiah Kubi",37.5,null,37.5,null,37.5,null,null,37.5,7.8124999999999972E-2,37.421875]
[null,"2016-06-15","Isaac Bannor",43.75,null,43.75,null,43.75,null,null,43.75,9.1145833333333301E-2,43.658854166666664]
[null,"2016-06-15","Isaiah Brobbey",56.25,null,56.25,null,56.25,null,null,56.25,0.11718749999999996,56.1328125]
[null,"2016-06-15","Judith Danso",75,null,75,null,75,null,null,75,0.15624999999999994,74.84375]
[null,"2016-06-15","Lambert Kofi Osei",320,null,320,null,320,null,null,320,0.66666666666666641,319.33333333333331]
[null,"2016-06-15","Patricia Asare",25,null,25,null,25,null,null,25,5.2083333333333315E-2,24.947916666666668]
[null,"2016-06-15","Richard Ofori",21.88,null,21.88,null,21.88,null,null,21.88,4.5583333333333309E-2,21.834416666666666]
[null,"2016-06-15","Stephen Banenjo",150,null,150,null,150,null,null,150,0.31249999999999989,149.6875]
[null,"2016-06-15","Wilhemina Osei Akomeah",37.5,null,37.5,null,37.5,null,null,37.5,7.8124999999999972E-2,37.421875]
[null,"2016-06-15","Yaw Asiedu",25,null,25,null,25,null,null,25,5.2083333333333315E-2,24.947916666666668]
[null,null,null,{"$f":"SUM(D13:D24)","v":835.63},null,{"$f":"SUM(F13:F24)","v":835.63},{"$f":"SUM(G13:G24)","v":0},{"$f":"SUM(H13:H24)","v":835.63},null,null,{"$f":"SUM(K13:K24)","v":835.63},{"$f":"SUM(L13:L24)","v":1.7408958333333329},{"$f":"SUM(M13:M24)","v":833.88910416666658}]
[]
["2016-07-31","2016-07-14","Adom Gideon",27.5,null,{"$f":"+SUM($D27:$E27)","v":27.5},null,{"$f":"SUM($F27,-$G27)","v":27.5},{"$f":"SUMIF([1]InterestSharing!$K:$K,$A27,[1]InterestSharing!$I:$I)","v":80.397156164383574},null,{"$f":"+SUM($H27,$J27)","v":27.5},{"$f":"+$K27*2.5/100*0.0833333333333333","v":5.7291666666666644E-2},{"$f":"SUM($K27,-$L27)","v":27.442708333333332}]
[null,"2016-07-14","Charity Appiah Kubi",37.5,null,37.5,null,37.5,null,null,37.5,7.8124999999999972E-2,37.421875]
[null,"2016-07-14","Isaac Bannor",43.75,null,43.75,null,43.75,null,null,43.75,9.1145833333333301E-2,43.658854166666664]
[null,"2016-07-14","Isaiah Brobbey",68.75,null,68.75,null,68.75,null,null,68.75,0.1432291666666666,68.606770833333329]
[null,"2016-07-14","Judith Danso",75,null,75,null,75,null,null,75,0.15624999999999994,74.84375]
[null,"2016-07-14","Lambert Kofi Osei",320,null,320,null,320,null,null,320,0.66666666666666641,319.33333333333331]
[null,"2016-07-14","Patricia Asare",25,null,25,null,25,null,null,25,5.2083333333333315E-2,24.947916666666668]
[null,"2016-07-14","Richard Ofori",43.75,null,43.75,null,43.75,null,null,43.75,9.1145833333333301E-2,43.658854166666664]
[null,"2016-07-14","Stephen Banenjo",150,null,150,null,150,null,null,150,0.31249999999999989,149.6875]
[null,"2016-07-14","Wilhemina Osei Akomeah",37.5,null,37.5,null,37.5,null,null,37.5,7.8124999999999972E-2,37.421875]
[null,"2016-07-14","Yaw Asiedu",25,null,25,null,25,null,null,25,5.2083333333333315E-2,24.947916666666668]
[null,null,null,{"$f":"SUM(D27:D37)","v":853.75},{"$f":"SUM(E27:E37)","v":0},{"$f":"SUM(F27:F37)","v":853.75},{"$f":"SUM(G27:G37)","v":0},{"$f":"SUM(H27:H37)","v":853.75},null,null,{"$f":"SUM(K27:K37)","v":853.75},{"$f":"SUM(L27:L37)","v":1.7786458333333328},{"$f":"SUM(M27:M37)","v":851.97135416666652}]