{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":120,"n_cols":10,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
["TRANSACTION DATE","ACCOUNT NAME","DEBIT ENTRIES","CREDIT ENTRIES","TRANSACTION DETAILS","BALANCE",null,null,"ACCOUNT NAME","BALANCE"]
["2013-07-04","ABUGAH BENJAMIN",null,1000,"Deposit for FPI investment on 04-Jul-13",{"$f":"SUM(-$C2,$D2)+SUM(F1)","v":1000},null,null,"ABUGAH BENJAMIN",3007.23]
["2013-07-08","ABUGAH BENJAMIN",1000,null,"Purchase of 1,000.00 FPI  at 24.00%",{"$f":"SUM(-$C3,$D3)+SUM(F2)","v":0},null,null,"AGYEI AMA HATHIA",0]
["2013-07-15","ABUGAH BENJAMIN",3007.23,null,"Purchase of 3,007.23 FPI  at 24.50%",-3007.23,null,null,"AGYEMFRA JOANA AMOABEA",0]
["2013-05-03","AGYEI AMA HATHIA",null,2000,"Deposit for FPI investment on 03-May-13",{"$f":"SUM(-$C5,$D5)+SUM(F4)","v":-1007.23},null,null,"AMOO ALEXANDRA BERNICE"]
["2013-05-03","AGYEI AMA HATHIA",2000,null,"Purchase of 1,000.00 FPI  at 23.5%",null,null,null,"AMPADU DAVID NANA KWADWO"]
["2013-04-19","AGYEMFRA JOANA AMOABEA",null,16800,"Deposit for FPI investment on 19-Apr-13",null,null,null,"ANAMAN ARETHA FOSUA"]
["2013-04-19","AGYEMFRA JOANA AMOABEA",16800,null,"Purchase of 16,800.00 FPI  at 24.50%",null,null,null,"ANANG BISMARK"]
["2013-05-14","AMOO ALEXANDRA BERNICE",null,25000,"Deposit for FPI investment on 14-May-13",null,null,null,"APENTENG FELIX"]
["2013-05-14","AMOO ALEXANDRA BERNICE",25000,null,"Purchase of 25,000.00 FPI  at 26.00%",null,null,null,"ARTHUR ELIZABETH RAHEEMA"]
["2013-07-24","AMPADU DAVID NANA KWADWO",null,5000,"Deposit for FPI investment on 24-Jul-13",null,null,null,"ASARE MARY"]
["2013-07-24","AMPADU DAVID NANA KWADWO",5000,null,"Purchase of 1,000.00 FPI  at 25.00%",null,null,null,"ASIEDU OWUSU MARTHA"]
["2013-05-29","ANAMAN ARETHA FOSUA",null,1900,"Deposit for FPI investment on 29-May-13",null,null,null,"ATTRAMS KWAME ASIEDU"]
["2013-05-29","ANAMAN ARETHA FOSUA",1900,null,"Purchase of 2,000.00 FPI  at 24.50%",null,null,null,"AWUNI MATILDA"]
["2013-06-27","ANANG BISMARK",1000,null,"Purchase of 1,000.00 FPI  at 25.00%",null,null,null,"BIYIRA GIFTY ADISHETU"]
["2013-06-18","APENTENG FELIX",null,8000,"Deposit for FPI investment on 18-Jun-13",null,null,null,"COLEMAN EVELYN OFOSUA"]
["2013-06-18","APENTENG FELIX",8000,null,"Purchase of 75,000.00 FPI  at 27.00%",null,null,null,"COURT-YARD CHAPEL INTERNATIONAL"]
["2013-06-18","APENTENG FELIX",8000,null,"Purchase of 75,000.00 FPI  at 27.00%",null,null,null,"CUDJOE LINDA NYEAKUA"]
["2013-05-03","ARTHUR ELIZABETH RAHEEMA",null,1000,"Deposit for FPI investment on 03-May-13",null,null,null,"DEKPORTOR KOFI STEPHEN"]
["2013-05-03","ARTHUR ELIZABETH RAHEEMA",1000,null,"Purchase of 1,000.00 FPI  at 23.5%",null,null,null,"DOUGLAS PATRICK"]
["2013-05-24","ARTHUR ELIZABETH RAHEEMA",null,2000,"Deposit for FPI investment on 24-May-13",null,null,null,"DZASE DAVID HARRISON"]
["2013-05-24","ARTHUR ELIZABETH RAHEEMA",2000,null,"Purchase of 2,000.00 FPI  at 24.50%",null,null,null,"DZOTSI GIFTY MAWUSI"]
["2013-06-19","ARTHUR ELIZABETH RAHEEMA",null,2000,"Deposit for FPI investment on 19-Jun-13",null,null,null,"EMALOVE INVESTMENTS"]
["2013-06-19","ARTHUR ELIZABETH RAHEEMA",2000,null,"Purchase of 2,000.00 FPI  at 24.50%",null,null,null,"HARUN-BIEG ELIZABETH"]
["2013-04-11","ASARE MARY",null,2000,"Deposit for FPI investment on 11-Apr-13",null,null,null,"HAYIBOR CHARLES"]
["2013-04-11","ASARE MARY",2000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"JOSEPH SEBASTIAN MENSAH"]
["2013-07-12","ASARE MARY",2119.67,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"KESSE ANITA"]
["2013-07-12","ASARE MARY",null,2119.6712328767121,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"LARBI ENYONAM FAUSTINA"]
["2013-06-07","ASIEDU OWUSU MARTHA",null,8000,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"LARBI EUNICE OPAREBEA"]
["2013-06-07","ASIEDU OWUSU MARTHA",8000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"LARBI VICTOR CHUBBY"]
["2013-06-07","ASIEDU OWUSU MARTHA",8000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"LARYEA NII ODAI"]
["2013-04-16","ATTRAMS KWAME ASIEDU",null,1500,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"LIVINGSTONE BARBARA"]
["2013-04-16","ATTRAMS KWAME ASIEDU",1500,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"MENSAH ANDY"]
["2013-06-11","ATTRAMS KWAME ASIEDU",1557.53,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"MENSAH ELIZABETH OPHELIA AYORKOR"]
["2013-06-11","ATTRAMS KWAME ASIEDU",null,1557.53,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"MENSAH WILHEMINA"]
["2013-03-26","AWUNI MATILDA",null,72000,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"MIREKU FOSTER"]
["2013-03-26","AWUNI MATILDA",72000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"NURUDEEN RUHIYA"]
["2013-04-23","BIYIRA GIFTY ADISHETU",null,50000,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"OBIRI YEBOAH KWAKU"]
["2013-04-23","BIYIRA GIFTY ADISHETU",50000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"OCLOO WILLIAM  DENNIS SENYO "]
["2013-07-04","BIYIRA GIFTY ADISHETU",null,52742,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"OCLOO WILLIAM DENNIS SENYO"]
["2013-07-04","BIYIRA GIFTY ADISHETU",52742,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"OFORI JEMIMA AKYEABEA"]
["2013-06-24","COLEMAN EVELYN OFOSUA",2000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"OFOSU AMPADU CECILIA"]
["2013-05-08","COURT-YARD CHAPEL INTERNATIONAL",null,10586,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"OTOO ELIZABETH BAABA"]
["2013-05-08","COURT-YARD CHAPEL INTERNATIONAL",10586,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"OWUSU - AGYEMANG ROBERTA"]
["2013-07-02","COURT-YARD CHAPEL INTERNATIONAL",null,16800,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"PENIN SANDRA"]
["2013-07-02","COURT-YARD CHAPEL INTERNATIONAL",16800,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"SEGLAH SELORM PETER"]
["2013-07-09","COURT-YARD CHAPEL INTERNATIONAL",20000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"SMART-ABBEY GIFTY CAROLINE"]
["2013-07-10","CUDJOE LINDA NYEAKUA",null,20000,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"TETTEH MARGARET"]
["2013-07-10","CUDJOE LINDA NYEAKUA",20000,null,"Purchase of 1,000.00 FPI  at 23.00%",null,null,null,"TWENEBOA VICTOR"]
["2013-05-31","DEKPORTOR KOFI STEPHEN",null,25400,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-31","DEKPORTOR KOFI STEPHEN",25400,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-27","DEKPORTOR KOFI STEPHEN",10100,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-29","DOUGLAS PATRICK",null,40000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-29","DOUGLAS PATRICK",40000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-16","DZASE DAVID HARRISON",null,5000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-16","DZASE DAVID HARRISON",5000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-26","DZOTSI GIFTY MAWUSI",5000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-27","EMALOVE INVESTMENTS",40000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-16","HARUN-BIEG ELIZABETH",null,3000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-16","HARUN-BIEG ELIZABETH",3000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-29","HARUN-BIEG ELIZABETH",null,15000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-29","HARUN-BIEG ELIZABETH",15000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-03-14","HAYIBOR CHARLES",null,160000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-03-14","HAYIBOR CHARLES",160000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-13","HAYIBOR CHARLES",null,50000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-13","HAYIBOR CHARLES",50000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-23","JOSEPH SEBASTIAN MENSAH",null,30000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-23","JOSEPH SEBASTIAN MENSAH",30000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-19","KESSE ANITA",null,5000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-19","KESSE ANITA",5000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-03-27","LARBI ENYONAM FAUSTINA",null,20000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-03-27","LARBI ENYONAM FAUSTINA",20000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-10","LARBI ENYONAM FAUSTINA",null,80000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-10","LARBI ENYONAM FAUSTINA",80000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-27","LARBI EUNICE OPAREBEA",1000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-27","LARBI EUNICE OPAREBEA",2000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-27","LARBI EUNICE OPAREBEA",null,3000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-26","LARBI VICTOR CHUBBY",550000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-26","LARBI VICTOR CHUBBY",null,550000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-27","LARYEA NII ODAI",2000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-19","LIVINGSTONE BARBARA",null,2000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-19","LIVINGSTONE BARBARA",2000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-28","LIVINGSTONE BARBARA",1000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-12","MENSAH ANDY",null,10000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-12","MENSAH ANDY",10000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-12","MENSAH ANDY",623.29,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-12","MENSAH ANDY",null,10623.287671232876,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-12","MENSAH ANDY",10000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-29","MENSAH ELIZABETH OPHELIA AYORKOR",null,4500,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-29","MENSAH ELIZABETH OPHELIA AYORKOR",4500,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-23","MENSAH WILHEMINA",null,1000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-23","MENSAH WILHEMINA",1000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-20","MIREKU FOSTER",null,3500,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-20","MIREKU FOSTER",3500,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-25","NURUDEEN RUHIYA",null,6286,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-25","NURUDEEN RUHIYA",6286,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-10","OBIRI YEBOAH KWAKU",null,10000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-10","OBIRI YEBOAH KWAKU",10000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-10","OCLOO WILLIAM  DENNIS SENYO ",null,4000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-10","OCLOO WILLIAM DENNIS SENYO",4000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-05","OFORI JEMIMA AKYEABEA",null,1000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-04-05","OFORI JEMIMA AKYEABEA",1000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-12","OFOSU AMPADU CECILIA",null,75000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-12","OFOSU AMPADU CECILIA",75000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-12","OFOSU AMPADU CECILIA",75000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-12","OTOO ELIZABETH BAABA",null,11000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-12","OTOO ELIZABETH BAABA",11000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-12","OTOO ELIZABETH BAABA",11000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-18","OWUSU - AGYEMANG ROBERTA",null,1188,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-18","OWUSU - AGYEMANG ROBERTA",1188,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-04","PENIN SANDRA",null,1000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-04","PENIN SANDRA",1000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-28","SEGLAH SELORM PETER",2000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-07","SMART-ABBEY GIFTY CAROLINE",null,60000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-07","SMART-ABBEY GIFTY CAROLINE",60000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-06-07","SMART-ABBEY GIFTY CAROLINE",60000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-09","TETTEH MARGARET",null,2000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-05-09","TETTEH MARGARET",2000,null,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-10","TWENEBOA VICTOR",null,125000,"Purchase of 1,000.00 FPI  at 23.00%"]
["2013-07-10","TWENEBOA VICTOR",125000,null,"Purchase of 1,000.00 FPI  at 23.00%"]

{"sheet":"Sheet2","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Hello Experts,"]
[]
["i need a little assistance to extract balances from the sheet attached. i have extracted a unique list of names from the transactions. i want a in column J net balances from transctions. for instance the first person will have a balance of 3007.23, the next two will have a zero balance.  i have posted a formula for the balance in column f, kindly assist with a vba solution. thanks "]