{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["CR"]
[null,"CR",19255]
[null,"Task",19]
[null,"User","mariskal"]
[]
["Payroll"]
[null,"New Paysys_id",15123]
[null,"Contact_person","finansies@britsoord.co.za"]
[null,"Long name","Brits rusoord"]
[null,"Short name","BR"]
[null,"Empl Flag","N"]
[null,"Active","Y"]
[null,"Comms Mthd","Q"]
[null,"Curr Period",201605]
[null,"Sector","02"]
[null,"Format ID",5016]
[null,"Instit_id",363]
[null,"Membership Fee",77]
[null,"Percentage",0]
[null,"Dept Code","BR"]
[null,"Union_id",15]
[]
["Telephone"]
[null,"Tel No","(012) 252 7043 / 5435"]
[null,"Tel Type","Business",{"$f":"VLOOKUP(C25,Sheet2!A1:B4, 2, FALSE)","v":2}]
[null,"Province ID","Free State",{"$f":"VLOOKUP(C26,Sheet2!$A$6:$B$14,2, FALSE)","v":4}]
[]
["Address"]
[null,"Addr Type","POSTAL ADDRESS",{"$f":"VLOOKUP(C29,Sheet2!A16:B21,2, FALSE)","v":10}]
[null,"Addr 1","Kerkstr 62 A"]
[null,"Addr 2","Posbus 2323"]
[null,"Addr 3"]
[null,"City","Brits"]
[null,"Postal Code","0250"]
[null,"Province ID","Gauteng",{"$f":"VLOOKUP(C35,Sheet2!$A$6:$B$14,2, FALSE)","v":2}]

{"sheet":"Sheet2","index":1,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Home",1]
["Business",2]
["Fax",3]
["Cell",4]
[]
["Gauteng",2]
["North West",3]
["Free State",4]
["KZN",5]
["Western Cape",6]
["Estern Cape",7]
["Mpumalanga",8]
["Northen Cape",9]
["Limpopo",13]
[]
["POSTAL ADDRESS",10]
["PHYSICAL ADDRESS",20]
["BUSINESS ADDRESS",30]
["PAYROLL ADDRESS",40]
["ADDRESS",50]
["EMAIL ADDRESS",60]