{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,"EXTRACT WORD"]
["ADMIN","71.210.6",{"$f":"MID(D2,1,(FIND(\"*\",SUBSTITUTE(D2,\" \",\"*\",1),1)))","v":"SEWAGE "},"SEWAGE WATER REMOVAL",22996]
["ADMIN",null,{"$f":"MID(D3,1,(FIND(\"*\",SUBSTITUTE(D3,\" \",\"*\",1),1)))","v":"SEWAGE "},"SEWAGE WATER REMOVAL",18992]
["CAMP","15.217.6","GARBAGE ","GARBAGE COLLECTION",14625,null,null,"Hi! Everybody,"]
["ADMIN",null,"GARBAGE ","GARBAGE COLLECTION",13500,null,null,"Dear Group, "]
["ADMIN","71.210.6","SWEET ","SWEET WATER SUPPLY",21917]
["ADMIN",null,"SWEET ","SWEET WATER SUPPLY",37107,null,null,"I want to extract a word from the sentence in cell beside."]
["PMV",null,"SUPPLY ","SUPPLY OF POTABLE WATER",9653.7000000000007]
["PMV",null,"SUPPLY ","SUPPLY OF SWEET WATER FOR THE PERIOD FROM 01-04-2012 TO 30-04-2012",35840]
["ADMIN",null,"SWEET ","SWEET WATER SUPPLY",19040]
["ADMIN",null,"SEWAGE ","SEWAGE WATER REMOVAL",20500]
["ADMIN",null,"GARBAGE ","GARBAGE COLLECTION",11925]
["CAMP",null,"GARBAGE ","GARBAGE COLLECTION",12150]
["ADMIN","71.210.6","GARBAGE ","GARBAGE COLLECTION",12600]
["ADMIN",null,"SWEET ","SWEET WATER SUPPLY for Construction Utilities for CP95",31248]
["ADMIN",null,"SEWAGE ","SEWAGE WATER REMOVAL FOR CP 95",21399.5]
["PMV",null,"SUPPLY ","SUPPLY OF POTABLE WATER",15682.8]
["ADMIN","71.210.6","SWEET ","SWEET WATER SUPPLY",19530]
["ADMIN",null,"SEWAGE ","SEWAGE WATER REMOVAL",18652.5]
["ADMIN",null,"SEWAGE ","SEWAGE WATER REMOVAL",17200,null,"15.217.6",{"$f":"SUMPRODUCT(($B$2:$B$113=G20)*($E$2:$E$113))","v":14625}]
["CAMP",null,"GARBAGE ","GARBAGE COLLECTION",41175]
["ADMIN",null,"FOR ","FOR SITE - ONLY FOR ONE DAY ON (7-MAY-12)",52]
["ADMIN",null,"6,13,22,29,30 ","6,13,22,29,30 -MAY-2012 WATER BOTTLES FOR SITE",680,null,"71.210.6",{"$f":"SUMPRODUCT(($B$2:$B$113=G23)*($E$2:$E$113))","v":83531}]
["ADMIN","71.210.6","1,2,5,6,7,8,10,12,13,14,16,17,19,20,22,23,24,26,27,29,30 ","1,2,5,6,7,8,10,12,13,14,16,17,19,20,22,23,24,26,27,29,30 & 31 MAY,12",6488]
["PMV",null,"SUPPLY ","SUPPLY OF SWEET WATER FOR THE PERIOD FROM 01-05-2012 TO 31-05-2012",45248]
["PMV",null,"GARBAGE ","GARBAGE REMOVAL from 30-Apr-2012  to 31-May-2012",65800]
["ADMIN",null,"SWEET ","SWEET WATER SUPPLY FOR NDAB(CP 93), MAY-2012",11420.5]
["ADMIN",null,"SEWAGE ","SEWAGE REMOVAL FOR NDAB(CP 93),MAY-2012",13500]
["ADMIN",null,null,"REMOVAL OF SKIP GARBAGE FOR NDAB(CP 93) -MAY-2012",13050]
["CAMP",null,null,"GARBAGE COLLECTION",6975]
["ADMIN",null,null,"GARBAGE COLLECTION",12600,null,null,null,null,"Dept",null,null,null,"A Now Amt"]
["ADMIN",null,null,"SUPPLY OF SWEET WATER FOR CCIC",31752,null,null,null,null,"camp"]
["CAMP",null,null,"SKIP LOADER FOR CCIC",38475]
["ADMIN",null,null,"REMOVAL OF SEWAGE WATER FOR CCIC",15600]
["ADMIN",null,null,"SEWAGE WATER MANAGEMENT",15294]
["ADMIN",null,null,"SWEET WATER SUPPLY for Construction Utilities for CP95",29575]
[null,null,null,null,{"$f":"SUM(E2:E36)","v":722243}]

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

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