{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Voorblad","Geg","Draai"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":3,"defined_names":40,"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":"Voorblad","index":0,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  G-Info/Tellen met voorwaarden"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2014, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"mail: Vraag/opmerking over G-Info/Tellen met voorwaarden"]

{"sheet":"Geg","index":1,"n_rows":202,"n_cols":9,"rows_kept":202,"cut":false,"hidden":false,"merged":[[1,6,1,8]]}
[]
[null,"Maand","Regio","Agent","Omzet",null,"Samenvatting"]
[null,"feb","West","Westra",9600,null,null,{"$f":"COUNTIF(E3:E202,7500)","v":4},{"$f":"[1]!ToonFormule(H3,\"In de cel hiernaast staat de formule: \")","v":"In de cel hiernaast staat de formule:  =AANTAL.ALS(E3:E202;7500)"}]
[null,"feb","Oost","Quadvlieg",6200,null,null,{"$f":"COUNTIF(B3:B202,\"jan\")","v":22},{"$f":"[1]!ToonFormule(H4)","v":"<<--   =AANTAL.ALS(B3:B202;\"jan\")"}]
[null,"jan","Zuid","Westra",9900]
[null,"nov","West","Martens",7800,null,"jan",{"$f":"COUNTIF($B$3:$B$202,G6)","v":22},{"$f":"[1]!ToonFormule(H6)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G6)"}]
[null,"mei","Oost","Jansen",9800,null,"feb",14,{"$f":"[1]!ToonFormule(H7)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G7)"}]
[null,"feb","West","Quadvlieg",12800,null,"mrt",21,{"$f":"[1]!ToonFormule(H8)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G8)"}]
[null,"feb","Noord","Jansen",10800,null,"apr",21,{"$f":"[1]!ToonFormule(H9)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G9)"}]
[null,"mrt","West","Quadvlieg",9400,null,"mei",13,{"$f":"[1]!ToonFormule(H10)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G10)"}]
[null,"sept","Zuid","Vd Berg",11400,null,"jun",14,{"$f":"[1]!ToonFormule(H11)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G11)"}]
[null,"feb","Zuid","Jansen",12900,null,"jul",17,{"$f":"[1]!ToonFormule(H12)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G12)"}]
[null,"mrt","West","Martens",6500,null,"aug",17,{"$f":"[1]!ToonFormule(H13)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G13)"}]
[null,"jun","Noord","Westra",6300,null,"sept",18,{"$f":"[1]!ToonFormule(H14)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G14)"}]
[null,"apr","Noord","Vd Berg",10800,null,"okt",5,{"$f":"[1]!ToonFormule(H15)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G15)"}]
[null,"mei","Noord","Jansen",8400,null,"nov",20,{"$f":"[1]!ToonFormule(H16)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G16)"}]
[null,"sept","Noord","Quadvlieg",8800,null,"dec",18,{"$f":"[1]!ToonFormule(H17)","v":"<<--   =AANTAL.ALS($B$3:$B$202;G17)"}]
[null,"mei","Zuid","Martens",14900,null,null,{"$f":"SUM(H6:H17)","v":200},{"$f":"[1]!ToonFormule(H18)","v":"<<--   =SOM(H6:H17)"}]
[null,"mei","Oost","Martens",7500]
[null,"dec","West","Vd Berg",6300,null,null,{"$f":"COUNTIF(B3:B202,\"j*\")","v":53},{"$f":"[1]!ToonFormule(H20)","v":"<<--   =AANTAL.ALS(B3:B202;\"j*\")"}]
[null,"jul","West","Vd Berg",10600,null,"*d",{"$f":"COUNTIF(C3:C202,G21)","v":109},{"$f":"[1]!ToonFormule(H21)","v":"<<--   =AANTAL.ALS(C3:C202;G21)"}]
[null,"sept","Oost","Vd Berg",5000,null,"*t",{"$f":"COUNTIF(C3:C202,G22)","v":91},{"$f":"[1]!ToonFormule(H22)","v":"<<--   =AANTAL.ALS(C3:C202;G22)"}]
[null,"mrt","Oost","Westra",5800]
[null,"feb","Noord","Quadvlieg",9800,null,"?a*",{"$f":"COUNTIF(D3:D202,G24)","v":90},{"$f":"[1]!ToonFormule(H24)","v":"<<--   =AANTAL.ALS(D3:D202;G24)"}]
[null,"nov","Zuid","Martens",11500]
[null,"jun","Zuid","Jansen",5300,null,"<7500",{"$f":"COUNTIF(E3:E202,G26)","v":61},{"$f":"[1]!ToonFormule(H26)","v":"<<--   =AANTAL.ALS(E3:E202;G26)"}]
[null,"jan","West","Vd Berg",14100,null,">=10.000",{"$f":"COUNTIF(E3:E202,G27)","v":93},{"$f":"[1]!ToonFormule(H27)","v":"<<--   =AANTAL.ALS(E3:E202;G27)"}]
[null,"jul","West","Jansen",12600]
[null,"jun","Zuid","Vd Berg",5200,null,7500,{"$f":"SUMIF(E3:E202,G29)","v":30000},{"$f":"[1]!ToonFormule(H29)","v":"<<--   =SOM.ALS(E3:E202;G29)"}]
[null,"feb","West","Jansen",6300,null,"jan",{"$f":"SUMIF(B3:B202,G30,E3:E202)","v":219900},{"$f":"[1]!ToonFormule(H30)","v":"<<--   =SOM.ALS(B3:B202;G30;E3:E202)"}]
[null,"mrt","Zuid","Westra",14700,null,"Noord",{"$f":"SUMIF(C3:C202,G31,E3:E202)","v":469100},{"$f":"[1]!ToonFormule(H31)","v":"<<--   =SOM.ALS(C3:C202;G31;E3:E202)"}]
[null,"jun","Zuid","Martens",6200]
[null,"sept","Oost","Jansen",12300,null,"jan",{"$f":"SUMIFS(E3:E202,B3:B202,G33,C3:C202,G34)","v":36900},{"$f":"[1]!ToonFormule(H33)","v":"<<--   =SOMMEN.ALS(E3:E202;B3:B202;G33;C3:C202;G34)"}]
[null,"dec","Oost","Westra",12100,null,"Noord"]
[null,"mei","West","Martens",10000]
[null,"jan","Oost","Quadvlieg",10100]
[null,"aug","Oost","Martens",11900]
[null,"dec","West","Jansen",12600]
[null,"nov","Noord","Martens",12500]
[null,"jul","Zuid","Jansen",14700]
[null,"jan","West","Quadvlieg",11400]
[null,"dec","Zuid","Westra",12600]
[null,"feb","Zuid","Jansen",5200]
[null,"apr","Noord","Quadvlieg",12200]
[null,"aug","Oost","Vd Berg",5300]
[null,"feb","Oost","Vd Berg",10000]
[null,"mrt","Zuid","Martens",6000]
[null,"mrt","Noord","Jansen",11100]
[null,"mei","Zuid","Westra",10600]
[null,"okt","Zuid","Quadvlieg",13700]
[null,"aug","Noord","Jansen",9200]
[null,"mei","Noord","Martens",14700]
[null,"jul","Noord","Quadvlieg",11600]
[null,"jul","Zuid","Vd Berg",6000]
[null,"mei","Noord","Westra",11000]
[null,"nov","Zuid","Vd Berg",13400]
[null,"jun","West","Jansen",12800]
[null,"mei","West","Martens",8900]
[null,"sept","Noord","Vd Berg",12800]
[null,"apr","Noord","Vd Berg",10200]
[null,"mei","West","Quadvlieg",6600]
[null,"jul","Zuid","Martens",9800]
[null,"dec","Noord","Quadvlieg",13900]
[null,"feb","Noord","Quadvlieg",9200]
[null,"jul","Oost","Westra",14300]
[null,"jul","Zuid","Vd Berg",6700]
[null,"feb","Zuid","Martens",8300]
[null,"nov","Oost","Vd Berg",8400]
[null,"feb","Zuid","Martens",9900]
[null,"apr","Oost","Martens",6500]
[null,"dec","Oost","Vd Berg",10300]
[null,"nov","Zuid","Martens",14200]
[null,"apr","Oost","Martens",14500]
[null,"jul","Noord","Jansen",5100]
[null,"mrt","Oost","Martens",13100]
[null,"sept","West","Quadvlieg",5900]
[null,"sept","Noord","Vd Berg",12400]
[null,"jan","Oost","Westra",7700]
[null,"mei","Zuid","Quadvlieg",6100]
[null,"jul","West","Quadvlieg",10900]
[null,"jan","Zuid","Martens",13500]
[null,"nov","Zuid","Jansen",7100]
[null,"dec","Zuid","Quadvlieg",11700]
[null,"mrt","Zuid","Westra",5800]
[null,"okt","West","Martens",6600]
[null,"jan","West","Vd Berg",13000]
[null,"jan","Zuid","Westra",10200]
[null,"mei","Zuid","Martens",11700]
[null,"sept","Zuid","Westra",9100]
[null,"mrt","Noord","Jansen",12000]
[null,"mrt","Oost","Westra",6200]
[null,"jun","Zuid","Quadvlieg",5900]
[null,"jun","West","Martens",5200]
[null,"jul","Oost","Martens",10100]
[null,"nov","Noord","Martens",8200]
[null,"sept","Zuid","Jansen",10800]
[null,"dec","Noord","Martens",7500]
[null,"nov","Zuid","Martens",13400]
[null,"nov","Zuid","Westra",11800]
[null,"dec","West","Martens",14700]
[null,"aug","Noord","Quadvlieg",12200]
[null,"dec","Oost","Martens",9600]
[null,"jul","Zuid","Martens",11200]
[null,"apr","Noord","Martens",9000]
[null,"mrt","Oost","Quadvlieg",14600]
[null,"jun","Noord","Quadvlieg",5700]
[null,"dec","Oost","Westra",14100]
[null,"mrt","Oost","Jansen",8900]
[null,"jan","Oost","Martens",5500]
[null,"mrt","West","Jansen",10700]
[null,"nov","Noord","Vd Berg",7700]
[null,"apr","Zuid","Jansen",13000]
[null,"feb","Zuid","Vd Berg",10600]
[null,"mrt","Zuid","Vd Berg",11500]
[null,"jun","Zuid","Jansen",14100]
[null,"mrt","Zuid","Jansen",14000]
[null,"apr","Noord","Jansen",12400]
[null,"jan","Noord","Martens",6100]
[null,"apr","Oost","Jansen",7100]
[null,"dec","West","Jansen",8300]
[null,"mrt","Zuid","Westra",10200]
[null,"jan","Oost","Quadvlieg",5300]
[null,"aug","Noord","Westra",14400]
[null,"apr","Noord","Jansen",10300]
[null,"aug","Noord","Westra",11600]
[null,"nov","Zuid","Quadvlieg",14300]
[null,"jan","Oost","Quadvlieg",12000]
[null,"nov","Zuid","Vd Berg",7900]
[null,"sept","Oost","Vd Berg",6400]
[null,"aug","Noord","Westra",5300]
[null,"aug","West","Vd Berg",9800]
[null,"jan","Oost","Jansen",5900]
[null,"aug","Zuid","Quadvlieg",5600]
[null,"dec","Noord","Quadvlieg",13700]
[null,"nov","West","Vd Berg",6400]
[null,"nov","Oost","Quadvlieg",11700]
[null,"apr","Noord","Westra",7100]
[null,"mrt","Oost","Jansen",9300]
[null,"nov","Oost","Martens",7700]
[null,"dec","Oost","Westra",9300]
[null,"sept","West","Quadvlieg",11500]
[null,"mrt","West","Vd Berg",7400]
[null,"sept","Zuid","Quadvlieg",9700]
[null,"apr","Oost","Westra",5300]
[null,"jun","Noord","Vd Berg",14300]
[null,"nov","West","Vd Berg",14100]
[null,"jan","Zuid","Jansen",15000]
[null,"jan","Zuid","Martens",10800]
[null,"mrt","Oost","Jansen",10700]
[null,"jan","West","Jansen",9300]
[null,"sept","Oost","Martens",8100]
[null,"jan","Noord","Quadvlieg",11900]
[null,"jan","Oost","Westra",9200]
[null,"apr","Oost","Quadvlieg",12300]
[null,"aug","Noord","Westra",7500]
[null,"okt","Noord","Vd Berg",7200]
[null,"apr","West","Quadvlieg",5200]
[null,"aug","Noord","Martens",5900]
[null,"jul","Zuid","Vd Berg",5700]
[null,"jul","West","Vd Berg",6000]
[null,"aug","Zuid","Vd Berg",13800]
[null,"nov","Noord","Jansen",5700]
[null,"jan","Noord","Martens",5100]
[null,"dec","Noord","Vd Berg",5200]
[null,"apr","Noord","Vd Berg",5600]
[null,"jun","Zuid","Martens",8600]
[null,"mrt","Oost","Martens",5600]
[null,"aug","West","Quadvlieg",13600]
[null,"dec","Zuid","Vd Berg",7600]
[null,"apr","Oost","Jansen",10200]
[null,"sept","Zuid","Jansen",7700]
[null,"apr","Noord","Quadvlieg",8200]
[null,"dec","West","Quadvlieg",6300]
[null,"jan","West","Jansen",6200]
[null,"jul","West","Martens",7700]
[null,"jan","Noord","Westra",13800]
[null,"mei","Noord","Vd Berg",9700]
[null,"jan","West","Vd Berg",13900]
[null,"feb","Zuid","Martens",15000]
[null,"jul","Oost","Martens",10900]
[null,"nov","West","Jansen",12600]
[null,"sept","West","Martens",7000]
[null,"aug","West","Quadvlieg",11700]
[null,"okt","Zuid","Jansen",7600]
[null,"okt","West","Jansen",14400]
[null,"jun","Noord","Vd Berg",5500]
[null,"sept","Zuid","Quadvlieg",10000]
[null,"aug","Zuid","Quadvlieg",8300]
[null,"mrt","West","Jansen",6600]
[null,"sept","Oost","Martens",5900]
[null,"nov","Zuid","Quadvlieg",8400]
[null,"aug","West","Jansen",12500]
[null,"apr","Zuid","Vd Berg",7200]
[null,"jun","Zuid","Martens",14900]
[null,"apr","West","Quadvlieg",6400]
[null,"apr","West","Martens",5500]
[null,"dec","West","Martens",6600]
[null,"jul","Noord","Martens",12000]
[null,"sept","Oost","Quadvlieg",9100]
[null,"jun","Noord","Westra",7500]
[null,"apr","Zuid","Westra",5100]
[null,"aug","West","Vd Berg",6700]

{"sheet":"Draai","index":2,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Regio"]
[null,"Maand","Values","Noord","Oost","West","Zuid","Eindtotaal"]
[null,"jan","Aantal",4,7,6,5,22]
[null,null," Omzet",36900,55700,67900,59400,219900]
[null,"feb","Aantal",3,2,3,6,14]
[null,null," Omzet",29800,16200,28700,61900,136600]
[null,"mrt","Aantal",2,8,5,6,21]
[null,null," Omzet",23100,74200,40600,62200,200100]
[null,"apr","Aantal",9,6,3,3,21]
[null,null," Omzet",85800,55900,17100,25300,184100]
[null,"mei","Aantal",4,2,3,4,13]
[null,null," Omzet",43800,17300,25500,43300,129900]
[null,"jun","Aantal",5,null,2,7,14]
[null,null," Omzet",39300,null,18000,60200,117500]
[null,"jul","Aantal",3,3,5,6,17]
[null,null," Omzet",28700,35300,47800,54100,165900]
[null,"aug","Aantal",7,2,5,3,17]
[null,null," Omzet",66100,17200,54300,27700,165300]
[null,"okt","Aantal",1,null,2,2,5]
[null,null," Omzet",7200,null,21000,21300,49500]
[null,"nov","Aantal",4,3,4,9,20]
[null,null," Omzet",34100,27800,40900,102000,204800]
[null,"dec","Aantal",4,5,6,3,18]
[null,null," Omzet",40300,55400,54800,31900,182400]
[null,"sept","Aantal",3,6,3,6,18]
[null,null," Omzet",34000,46800,24400,58700,163900]
[null,"Totaal Aantal",null,49,44,47,60,200]
[null,"Totaal  Omzet",null,469100,401800,441000,608000,1919900]