{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Voorblad","Vb1","Vb2","Vb3","Vb4","Vb5","Docu"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":21,"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":"Voorblad","index":0,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Voorbeeld materiaal -  Formules en Namen"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"© 2018, G-Info/G. Verbruggen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ginfo.nl"]

{"sheet":"Vb1","index":1,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Korting1",0.05]
[]
[]
[]
[null,"Artikel","Bedrag","Netto"]
[null,"Vijf",130,{"$f":"C7*(1-Korting1)","v":123.5}]
[null,"Twee",162,153.9]
[null,"Vier",130,123.5]
[null,"Twee",165,156.75]
[null,"Twee",149,141.54999999999998]
[null,"Een",159,151.04999999999998]
[null,"Een",179,170.04999999999998]
[null,"Vijf",115,109.25]
[null,"Twee",128,121.6]
[null,"Een",129,122.55]
[null,"Vier",124,117.8]
[null,"Vijf",146,138.69999999999999]
[null,"Een",187,177.65]
[null,"Een",163,154.85]
[null,"Drie",166,157.69999999999999]
[null,"Drie",108,102.6]
[null,"Drie",143,135.85]
[null,"Drie",186,176.7]
[null,"Vijf",169,160.54999999999998]
[null,"Een",169,160.54999999999998]
[null,"Een",179,170.04999999999998]
[null,"Een",186,176.7]
[null,"Vier",123,116.85]
[null,"Drie",121,114.94999999999999]
[null,"Vijf",107,101.64999999999999]
[null,"Vier",112,106.39999999999999]
[null,"Een",159,151.04999999999998]
[null,"Vijf",148,140.6]
[null,"Twee",179,170.04999999999998]
[null,"Twee",165,156.75]
[null,"Twee",155,147.25]
[null,"Drie",122,115.89999999999999]
[null,"Vier",129,122.55]
[null,"Twee",100,95]

{"sheet":"Vb2","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Korting2",0.05]
[]
[]
[]
[null,"Artikel","Bedrag","Netto_a","Netto_b"]
[null,"Vijf",130,{"$f":"C7*Kort2a","v":123.5},{"$f":"C7*Kort2b","v":123.5}]
[null,"Twee",162,153.9,153.9]
[null,"Vier",130,123.5,123.5]
[null,"Twee",165,156.75,156.75]
[null,"Twee",149,141.54999999999998,141.54999999999998]
[null,"Een",159,151.04999999999998,151.04999999999998]
[null,"Een",179,170.04999999999998,170.04999999999998]
[null,"Vijf",115,109.25,109.25]
[null,"Twee",128,121.6,121.6]
[null,"Een",129,122.55,122.55]
[null,"Vier",124,117.8,117.8]
[null,"Vijf",146,138.69999999999999,138.69999999999999]
[null,"Een",187,177.65,177.65]
[null,"Een",163,154.85,154.85]
[null,"Drie",166,157.69999999999999,157.69999999999999]
[null,"Drie",108,102.6,102.6]
[null,"Drie",143,135.85,135.85]
[null,"Drie",186,176.7,176.7]
[null,"Vijf",169,160.54999999999998,160.54999999999998]
[null,"Een",169,160.54999999999998,160.54999999999998]
[null,"Een",179,170.04999999999998,170.04999999999998]
[null,"Een",186,176.7,176.7]
[null,"Vier",123,116.85,116.85]
[null,"Drie",121,114.94999999999999,114.94999999999999]
[null,"Vijf",107,101.64999999999999,101.64999999999999]
[null,"Vier",112,106.39999999999999,106.39999999999999]
[null,"Een",159,151.04999999999998,151.04999999999998]
[null,"Vijf",148,140.6,140.6]
[null,"Twee",179,170.04999999999998,170.04999999999998]
[null,"Twee",165,156.75,156.75]
[null,"Twee",155,147.25,147.25]
[null,"Drie",122,115.89999999999999,115.89999999999999]
[null,"Vier",129,122.55,122.55]
[null,"Twee",100,95,95]

{"sheet":"Vb3","index":3,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Korting3",0.05]
[]
[]
[]
[null,"Artikel","Bedrag","Netto_a","Netto_b","Netto_c"]
[null,"Vijf",130,{"$f":"Netto3a","v":123.5},{"$f":"Netto3b","v":123.5},{"$f":"Netto3c","v":123.5},null,{"$f":"SUM(Netto3c)+0*NOW()","v":4742.3999999999996}]
[null,"Twee",162,153.9,153.9,153.9,null,{"$f":"SUM(Netto3c)+0*NOW()","v":4618.9000000000005}]
[null,"Vier",130,123.5,123.5,123.5]
[null,"Twee",165,156.75,156.75,156.75]
[null,"Twee",149,141.54999999999998,141.54999999999998,141.54999999999998]
[null,"Een",159,151.04999999999998,151.04999999999998,151.04999999999998]
[null,"Een",179,170.04999999999998,170.04999999999998,170.04999999999998]
[null,"Vijf",115,109.25,109.25,109.25]
[null,"Twee",128,121.6,121.6,121.6]
[null,"Een",129,122.55,122.55,122.55]
[null,"Vier",124,117.8,117.8,117.8]
[null,"Vijf",146,138.69999999999999,138.69999999999999,138.69999999999999]
[null,"Een",187,177.65,177.65,177.65]
[null,"Een",163,154.85,154.85,154.85]
[null,"Drie",166,157.69999999999999,157.69999999999999,157.69999999999999,null,{"$f":"Netto3a","v":0}]
[null,"Drie",108,102.6,102.6,102.6]
[null,"Drie",143,135.85,135.85,135.85,null,{"$f":"Netto3b","v":135.85}]
[null,"Drie",186,176.7,176.7,176.7]
[null,"Vijf",169,160.54999999999998,160.54999999999998,160.54999999999998]
[null,"Een",169,160.54999999999998,160.54999999999998,160.54999999999998]
[null,"Een",179,170.04999999999998,170.04999999999998,170.04999999999998]
[null,"Een",186,176.7,176.7,176.7]
[null,"Vier",123,116.85,116.85,116.85]
[null,"Drie",121,114.94999999999999,114.94999999999999,114.94999999999999]
[null,"Vijf",107,101.64999999999999,101.64999999999999,101.64999999999999]
[null,"Vier",112,106.39999999999999,106.39999999999999,106.39999999999999]
[null,"Een",159,151.04999999999998,151.04999999999998,151.04999999999998]
[null,"Vijf",148,140.6,140.6,140.6]
[null,"Twee",179,170.04999999999998,170.04999999999998,170.04999999999998]
[null,"Twee",165,156.75,156.75,156.75]
[null,"Twee",155,147.25,147.25,147.25]
[null,"Drie",122,115.89999999999999,115.89999999999999,115.89999999999999]
[null,"Vier",129,122.55,122.55,122.55]
[null,"Twee",100,95,95,95]

{"sheet":"Vb4","index":4,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Korting4",0.1]
[]
[]
[]
[null,"Artikel","Bedrag","Netto_a","Netto_b","Netto_c"]
[null,"Vijf",130,{"$f":"Netto4a","v":117},{"$f":"Netto4b","v":117},{"$f":"Netto4c","v":117},null,{"$f":"SUM(Netto4a)+0*NOW()","v":4492.8}]
[null,"Twee",162,117,145.80000000000001,145.80000000000001,null,{"$f":"SUM(Netto4a)+0*NOW()","v":4492.8}]
[null,"Vier",130,117,117,117]
[null,"Twee",165,117,148.5,148.5]
[null,"Twee",149,117,134.1,134.1]
[null,"Een",159,117,143.1,143.1]
[null,"Een",179,117,161.1,161.1]
[null,"Vijf",115,117,103.5,103.5]
[null,"Twee",128,117,115.2,115.2]
[null,"Een",129,117,116.10000000000001,116.10000000000001]
[null,"Vier",124,117,111.60000000000001,111.60000000000001]
[null,"Vijf",146,117,131.4,131.4]
[null,"Een",187,117,168.3,168.3]
[null,"Een",163,117,146.70000000000002,146.70000000000002]
[null,"Drie",166,117,149.4,149.4]
[null,"Drie",108,117,97.2,97.2]
[null,"Drie",143,117,128.70000000000002,128.70000000000002]
[null,"Drie",186,117,167.4,167.4]
[null,"Vijf",169,117,152.1,152.1]
[null,"Een",169,117,152.1,152.1]
[null,"Een",179,117,161.1,161.1]
[null,"Een",186,117,167.4,167.4]
[null,"Vier",123,117,110.7,110.7]
[null,"Drie",121,117,108.9,108.9]
[null,"Vijf",107,117,96.3,96.3]
[null,"Vier",112,117,100.8,100.8]
[null,"Een",159,117,143.1,143.1]
[null,"Vijf",148,117,133.20000000000002,133.20000000000002]
[null,"Twee",179,117,161.1,161.1]
[null,"Twee",165,117,148.5,148.5]
[null,"Twee",155,117,139.5,139.5]
[null,"Drie",122,117,109.8,109.8]
[null,"Vier",129,117,116.10000000000001,116.10000000000001]
[null,"Twee",100,117,90,90]

{"sheet":"Vb5","index":5,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Korting5",0.01]
[]
[]
[]
[null,"Artikel","Bedrag","Netto"]
[null,"Vijf",130,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":128.69999999999999}]
[null,"Twee",162,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":160.38}]
[null,"Vier",130,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":128.69999999999999}]
[null,"Twee",165,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":163.35}]
[null,"Twee",149,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":147.51}]
[null,"Een",159,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":157.41},null,{"$f":"BerekenNetto(C7,Korting5)","v":128.69999999999999}]
[null,"Een",179,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":177.21},null,160.38]
[null,"Vijf",115,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":113.85},null,128.69999999999999]
[null,"Twee",128,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":126.72},null,163.35]
[null,"Een",129,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":127.71},null,147.51]
[null,"Vier",124,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":122.76},null,157.41]
[null,"Vijf",146,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":144.54},null,177.21]
[null,"Een",187,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":185.13},null,113.85]
[null,"Een",163,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":161.37},null,126.72]
[null,"Drie",166,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":164.34},null,127.71]
[null,"Drie",108,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":106.92},null,122.76]
[null,"Drie",143,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":141.57},null,144.54]
[null,"Drie",186,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":184.14},null,185.13]
[null,"Vijf",169,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":167.31},null,161.37]
[null,"Een",169,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":167.31},null,164.34]
[null,"Een",179,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":177.21},null,106.92]
[null,"Een",186,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":184.14},null,141.57]
[null,"Vier",123,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":121.77},null,184.14]
[null,"Drie",121,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":119.78999999999999},null,167.31]
[null,"Vijf",107,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":105.92999999999999},null,167.31]
[null,"Vier",112,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":110.88},null,177.21]
[null,"Een",159,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":157.41},null,184.14]
[null,"Vijf",148,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":146.52000000000001},null,121.77]
[null,"Twee",179,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":177.21},null,119.78999999999999]
[null,"Twee",165,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":163.35},null,105.92999999999999]
[null,"Twee",155,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":153.44999999999999},null,110.88]
[null,"Drie",122,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":120.78},null,157.41]
[null,"Vier",129,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":127.71},null,146.52000000000001]
[null,"Twee",100,{"$f":"BerekenNetto(tblNetto2[[#This Row],[Bedrag]],Korting5)","v":99},null,177.21]
[null,{"$f":"SUBTOTAL(103,tblNetto2[Artikel])","v":34},{"$f":"SUBTOTAL(109,tblNetto2[Bedrag])","v":4992},{"$f":"SUBTOTAL(109,tblNetto2[Netto])","v":4942.08},null,163.35]
[null,null,null,null,null,153.44999999999999]
[null,null,null,null,null,120.78]
[null,null,null,null,null,127.71]
[null,null,null,null,null,99]
[null,null,null,null,null,4942.08]

{"sheet":"Docu","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tabblad","Naam","Verwijzing"]
[null,"Vb1","Korting1","='Vb1'!$C$2"]
[null,"Vb2","Kort2a","=1-'Vb2'!$C$2"]
[null,"Vb2","Kort2b","=1-'Vb2'!Korting2"]
[null,"Vb2","Korting2","='Vb2'!$C$2"]
[null,"Vb3","Korting3","='Vb3'!$C$2"]
[null,"Vb3","Netto3a","='Vb3'!I9*(1-'Vb3'!Korting3)"]
[null,"Vb3","Netto3b","='Vb3'!$C10*(1-!Korting3)"]
[null,"Vb3","Netto3c","='Vb3'!$C11:$C44*(1-!Korting3)"]
[null,"Vb4","Korting4","='Vb4'!$C$2"]
[null,"Vb4","Netto4a","=tblNetto[Bedrag]*(1-!Korting4)"]
[null,"Vb4","Netto4b","='Vb4'!$C9*(1-!Korting4)"]
[null,"Vb4","Netto4c","=tblNetto[@Bedrag]*(1-!Korting4)"]
[null,"Werkmap","Docu","=Docu!$A$1"]