{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","Sheet2","Sheet4","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Staff Status","McOttler","Subsidiary","Date of Joining",null,null,"McOttler","br",null,"Staff Status","McOttler","Subsidiary","Date of Joining"]
["Active","Abdul Rauf Alhassan","McOttley Capital","2013-04-02",null,"Type Her to Search",{"$f":"+\"*\"&H1&\"*\"","v":"*br*"},null,null,"Inactive","Bright Quaye","McOttley Capital","2013-12-02"]
["Active","Agyei Samuel Djang","McOttley Holdings","2014-09-01"]
["Active","Alexander Boakye Essandoh","McOttley Capital","2014-03-19"]
["Inactive","Ametepey Dussey Wisdom","McOttley Money Lending","2014-04-28"]
["Active","Ameworlor Seraphine","McOttley Money Lending","2014-01-20"]
["Active","Bernice Otubea Larbi","McOttley Capital","2014-03-19"]
["Inactive","Blankson Ellen Kusowa","McOttley Capital","2013-04-01"]
["Inactive","Bright Quaye","McOttley Capital","2013-12-02"]
["Active","Charity Bekoe","McOttley Holdings","2013-11-04"]

{"sheet":"Sheet2","index":1,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["DATE","NAME","RESPONSE","BCOC","detail","O_PROGRAM","BILL AMT","type","TYPE","PGM"]
["2016-10-01","WEST   116 STREET","YES",6183109,"FUEL2","AOPFUEL",869.02,"HLD","FUEL","AOP",null,null,"RESPONSE","NO",null,"NO","FUEL2"]
["2016-10-01","AMSTERDAM AVENUE","NO",6183109,"ELEC","AOPFUEL",993.48,"HLD","UTIL","EAP",null,null,"detail","FUEL2","2015-08-07",{"$f":"SUMIFS(Sheet2!G:G,Sheet2!E:E,Sheet2!$Q$2,Sheet2!C:C,P$2,Sheet2!A:A,Sheet2!$O3)","v":1252.0999999999999}]
["2016-10-01","AMSTERDAM   AVENUE","NO",6183109,"FUEL2","AOPFUEL",1234.42,"HLD","FUEL","AOP",null,null,null,null,"2016-08-27",{"$f":"SUMIFS(Sheet2!G:G,Sheet2!E:E,Sheet2!$Q$2,Sheet2!C:C,P$2,Sheet2!A:A,Sheet2!$O4)","v":2629.27}]
["2016-10-01","AMSTERDAM   AVENUE","YES",6183109,"FUEL2","AOPFUEL",551.97,"HLD","FUEL","AOP",null,null,"Row Labels","Sum of BILL AMT","2016-10-01",{"$f":"SUMIFS(Sheet2!G:G,Sheet2!E:E,Sheet2!$Q$2,Sheet2!C:C,P$2,Sheet2!A:A,Sheet2!$O5)","v":1234.42}]
["2016-08-26","AMSTERDAM   AVENUE","YES",6280423,"ELEC","EOP   UTILITY",167.1,"HLD","UTIL","EAP",null,null,"2015-08-07",1252.0999999999999,"Grand Total",{"$f":"SUM(P3:P5)","v":5115.79}]
["2016-08-27","AMSTERDAM   AVENUE","NO",6280109,"FUEL2","EOP   UTILITY",2629.27,"HLD","FUEL","EAP",null,null,"2016-08-27",2629.27]
["2015-08-08","AMSTERDAM   AVENUE","YES",6280109,"FUEL2","EOP   UTILITY",1400.68,"HLD","FUEL","EAP",null,null,"2016-10-01",1234.42]
["2016-10-01","MANHATTAN   AVENUE","YES",6280109,"FUEL2","EOP   UTILITY",351.85,"HLD","FUEL","EAP",null,null,"Grand Total",5115.79]
["2016-10-01","MANHATTAN   AVENUE","YES",6280109,"FUEL2","EOP   UTILITY",488.41,"HLD","FUEL","EAP"]
["2015-08-07","OLD   BROADWAY","YES","S002423","ELEC","EOP   UTILITY",86.56,"HLD","UTIL","AOP"]
["2015-08-07","WEST   116 STREET","NO",6280109,"FUEL2","EOP   UTILITY",1252.0999999999999,"HLD","FUEL","EAP"]
["2016-08-25","WEST   116 STREET","YES",6280109,"FUEL2","EOP   UTILITY",2274.9499999999998,"HLD","FUEL","EAP"]
["2016-10-01","WEST   116 STREET","YES",6280109,"FUEL2","EOP   UTILITY",1535.8,"HLD","FUEL","EAP"]
["2016-10-02","WEST   119 STREET","NO",6280423,"ELEC","EOP   UTILITY",694.28,"APR","UTIL","EAP"]
["2016-09-20","WEST   119 STREET","YES",6183109,"FUEL2","AOPFUEL",245.58,"HLD","FUEL","AOP"]

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

{"sheet":"Sheet3","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Worksheet(results)"]
["result","2015-08-07","2016-10-01","2016-09-20"]
["AMSTERDAM AVENUE",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B2,Sheet2!$F:$F,Sheet3!A3)","v":0}]
["RESPONSE(YES)",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B3,Sheet2!$F:$F,Sheet3!A4)","v":0}]
["RESPONSE(NO)",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B4,Sheet2!$F:$F,Sheet3!A5)","v":0}]
["ELEC",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B5,Sheet2!$F:$F,Sheet3!A6)","v":0}]
["FUEL2",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B6,Sheet2!$F:$F,Sheet3!A7)","v":0}]
["EOP UTILITY",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B7,Sheet2!$F:$F,Sheet3!A8)","v":0}]
["AOPFUEL",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B8,Sheet2!$F:$F,Sheet3!A9)","v":0}]
["AOP",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B9,Sheet2!$F:$F,Sheet3!A10)","v":0}]
["EAP",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B10,Sheet2!$F:$F,Sheet3!A11)","v":0}]
["SUM_BILL_AMT",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B11,Sheet2!$F:$F,Sheet3!A12)","v":0}]
["AVERAGE_BILL_AMT",{"$f":"+SUMIFS(Sheet2!$G:$G,Sheet2!$A:$A,Sheet3!B12,Sheet2!$F:$F,Sheet3!A13)","v":0}]