{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Leads","1","2","Selecteren"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Leads","index":0,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Nr","Klant","Straat","Nr","PC","Gemeente","Tel","Email","Soort werk","Nr","Lead via","Dat.lead","Vertegenw.","info doorg.","Tel. Contact","opmeting","off. Gestuurd","1e opvolging","2e opvolg.","resultaat"]
[1,"Jansses","jansplein",24,1234,"Antwerpen","012/23.34.45","janses@hotmail.com",null,1," ","2015-10-15"," ","2015-10-15","2015-10-15","2015-10-17","2015-10-17",{"$f":"Q2+5","v":"2015-10-22"}," ",{"$f":"'1'!B44","v":" "}]
[2,"Peeters","markt",47,5678,"Niel","04/22.21.20","peeters@hotmail.be",null,2," ","2015-09-16"," ","2015-09-16"]
[3,null,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,null,5]
[6,null,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,null,10]
[11,null,null,null,null,null,null,null,null,11]
[12,null,null,null,null,null,null,null,null,12]
[13,null,null,null,null,null,null,null,null,13]
[14,null,null,null,null,null,null,null,null,14]
[15,null,null,null,null,null,null,null,null,15]
[16,null,null,null,null,null,null,null,null,16]
[17,null,null,null,null,null,null,null,null,17]
[18,null,null,null,null,null,null,null,null,18]
[19,null,null,null,null,null,null,null,null,19]
[20,null,null,null,null,null,null,null,null,20]
[21,null,null,null,null,null,null,null,null,21]
[22,null,null,null,null,null,null,null,null,22]
[23,null,null,null,null,null,null,null,null,23]
[24,null,null,null,null,null,null,null,null,24]
[25,null,null,null,null,null,null,null,null,25]
[26,null,null,null,null,null,null,null,null,26]
[27,null,null,null,null,null,null,null,null,27]
[28,null,null,null,null,null,null,null,null,28]
[29,null,null,null,null,null,null,null,null,29]
[30,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"1","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,6],[7,1,7,2],[7,5,7,6]]}
[1,"Klantenfiche"]
["Naam :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,2,0)","v":"Jansses"}]
["Straat :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,3,0)&\" \"&VLOOKUP(A1,Leads!$A$2:$T$31,4,0)","v":"jansplein 24"}]
["Adres :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,5,0)&\"  \"& VLOOKUP(A1,Leads!$A$2:$T$31,6,0)","v":"1234  Antwerpen"}]
["Tel :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,7,0)","v":"012/23.34.45"}]
["Email :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,8,0)","v":"janses@hotmail.com"}]
["Werk :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,9,0)","v":0}]
["Lead via :",{"$f":"Leads!K2","v":" "},null,null,null,"Vertegenw.:",null,{"$f":"Leads!M2","v":" "}]
["Datum lead :",{"$f":"Leads!L2","v":"2015-10-15"}]
["Info doorgest.:",{"$f":"Leads!N2","v":"2015-10-15"},null," "]
["Tel.contact :",{"$f":"Leads!O2","v":"2015-10-15"},"Door : "]
["Opmerking telefoongesprek :"]
[" "]
[" "]
[]
[]
["Opmeting : ",{"$f":"Leads!P2","v":"2015-10-17"},null,null,"Offertedat.:",{"$f":"Leads!Q2","v":"2015-10-17"}]
["Opmerkingen opmeting :"]
[]
[]
[]
[]
[]
["1e opvolging : ",{"$f":"Leads!R2","v":"2015-10-22"}]
["Opmerkingen :"]
[]
[]
[]
[]
[]
["2e opvolging : "]
["Opmerkingen : "]
[]
[]
[]
[]
["Nota's : "]
[]
[]
[]
[]
[]
[]
["Resultaat : "," ",null,"Bestelbon : "]

{"sheet":"2","index":2,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,6],[7,1,7,2],[7,5,7,6]]}
[2,"Klantenfiche"]
["Naam :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,2,0)","v":"Peeters"}]
["Straat :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,3,0)&\" \"&VLOOKUP(A1,Leads!$A$2:$T$31,4,0)","v":"markt 47"}]
["Adres :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,5,0)&\"  \"& VLOOKUP(A1,Leads!$A$2:$T$31,6,0)","v":"5678  Niel"}]
["Tel :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,7,0)","v":"04/22.21.20"}]
["Email :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,8,0)","v":"peeters@hotmail.be"}]
["Werk :",{"$f":"VLOOKUP(A1,Leads!$A$2:$T$31,9,0)","v":0}]
["Lead via :",{"$f":"Leads!K2","v":" "},null,null,null,"Vertegenw.:",null,{"$f":"Leads!M2","v":" "}]
["Datum lead :",{"$f":"Leads!L2","v":"2015-10-15"}]
["Info doorgest.:",{"$f":"Leads!N2","v":"2015-10-15"},null," "]
["Tel.contact :",{"$f":"Leads!O2","v":"2015-10-15"},"Door : "]
["Opmerking telefoongesprek :"]
[" "]
[" "]
[]
[]
["Opmeting : ",{"$f":"Leads!P2","v":"2015-10-17"},null,null,"Offertedat.:",{"$f":"Leads!Q2","v":"2015-10-17"}]
["Opmerkingen opmeting :"]
[]
[]
[]
[]
[]
["1e opvolging : ",{"$f":"Leads!R2","v":"2015-10-22"}]
["Opmerkingen :"]
[]
[]
[]
[]
[]
["2e opvolging : "]
["Opmerkingen : "]
[]
[]
[]
[]
["Nota's : "]
[]
[]
[]
[]
[]
[]
["Resultaat : "," ",null,"Bestelbon : "]

{"sheet":"Selecteren","index":3,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Resultaat","Vertegenw","Lead via","Soort Werk"]
[" "," "," "," "]
["besteld"," "," "," "]
["afgewezen"," "," "," "]
["niet beslist"," "," "," "]
[null,null," "," "]
[null,null," "," "]
[null,null,null," "]