{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Customers","Branch"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Main","index":0,"n_rows":10,"n_cols":21,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,2,2,3],[3,2,3,3]]}
[]
[]
[null,"Customer:","Cust1",null,null,"Branch Details:","Branch:",{"$f":"IF(C4=\"\",\"\",_xlfn._xlws.FILTER(Branch!$B$4:$B$11,(Branch!$B$4:$B$11=C4),\" \"))","v":""},null,null,null,"Branch:",{"$f":"IF(\nISBLANK(Select_Site),\nTRANSPOSE(_xlfn._xlws.FILTER(CustomerSite[[Site]:[Postcode]],(CustomerSite[Customer]=Select_Customer)*(ISNUMBER(FIND(\"Head\",CustomerSite[Site]))))),\nTRANSPOSE(_xlfn._xlws.FILTER(CustomerSite[[Site]:[Postcode]],CustomerSite[Site]=Select_Site,\"\"))\n)","v":"Cust1 Head Office"}]
[null,"Branch:",null,null,null,null,"Branch No:",{"$f":"IF(C4=\"\",\"\",_xlfn._xlws.FILTER(Branch!$C$4:$C$11,(Branch!$B$4:$B$11=C4),\" \"))","v":""},null,null,null,"Branch No:","A01"]
[null,null,null,null,null,null,null,null,null,null,null,"Tel No:","A02"]
[null,null,null,null,null,null,"Address:",{"$f":"IF(C4=\"\",\"\",_xlfn._xlws.FILTER(Branch!$E$4:$E$11,(Branch!$B$4:$B$11=C4),\" \"))","v":""},null,null,null,"Address:","A03"]
[null,null,null,null,null,null,null,{"$f":"IF(C4=\"\",\"\",_xlfn._xlws.FILTER(Branch!$F$4:$F$11,(Branch!$B$4:$B$11=C4),\" \"))","v":""},null,null,null,null,"A04"]
[null,null,null,null,null,null,null,{"$f":"IF(C4=\"\",\"\",_xlfn._xlws.FILTER(Branch!$G$4:$G$11,(Branch!$B$4:$B$11=C4),\" \"))","v":""},null,null,null,null,"PCA0",null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,"Tel No:",{"$f":"IF(C4=\"\",\"\",_xlfn._xlws.FILTER(Branch!$D$4:$D$11,(Branch!$B$4:$B$11=C4),\" \"))","v":""}]

{"sheet":"Customers","index":1,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Branch Lookup List"]
["CustomerDetails",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn._xlws.FILTER(Branch!$B$3:$B$11,Branch!$A$3:$A$11=Main!C3)","v":"Cust1 Head Office"}]
["Customer","Business Type","Components/Applications","HWContract","HardwareSupport","HWContact","ServerSupport","SrvContact","Hours of Service","Hours of Service - Additional","P1","P2","Customer Support Contract","Customer Comments",null,"Cust1 S1"]
["Cust1","Red","asdfadsf","STL","uygi","yuio","iuyouyio","dsaf","09:00 to 17:00",null,"PPPPP","QQQQQ",null,null,null,"Cust1 S2"]
["Cust2","Blue","gfdhfdgh","Site","poi[7ty","oiupytfr","yuioiuyo","adsf","09:00 to 17:00",null,"RRRRR","RRRRRR"]
["Cust3","Green",";l';lk'pk;'lk;'","STL","yuioiuyo","tuyi7ytriu","yiuo","adsf","09:00 to 17:00",null,"PPPPP","QQQQQ"]

{"sheet":"Branch","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Customer Branch details",null,"Branch Number"]
["Customer","Site","Branch","Telephone","Address3","Address4","Postcode"]
["Cust1","Cust1 Head Office","A01","A02","A03","A04","PCA0"]
["Cust1","Cust1 S1","A11","A12","A13","A14","PCA1"]
["Cust1","Cust1 S2","A21","A22","A23","A24","PCA2"]
["Cust2","Cust2 Head Office","B01","B02","B03","B04","PCB0"]
["Cust2","Cust2 S1","B11","B12","B13","B14","PCB1"]
["Cust2","Cust2 S2","B21","B22","B23","B24","PCB2"]
["Cust3","Cust3 Head Office","C01","C02","C03","C04","PCC0"]
["Cust3","Cust3 S1","C11","C12","C13","C14","PCC1"]
["Cust3","Cust3 S2","C21","C22","C23","C24","PCC2"]
[]
[]
[]
[null,{"$f":"IF(ISNUMBER(SEARCH(\"Head\",B17,1)),\"Found\",\"Not Found\")","v":"Found"}]
[]
[null,"Head Office"]