{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["juli","augustus"],"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":"juli","index":0,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[23,0,25,7],[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[14,1,14,2],[14,3,14,4],[12,1,12,2],[12,3,12,4],[9,1,9,2],[9,3,9,4],[15,1,15,2],[15,3,15,4],[13,1,13,2],[13,3,13,4],[11,3,11,4],[11,1,11,2],[10,3,10,4],[10,1,10,2]]}
[]
["Dagontvangsten 2020"]
[]
["Maand","BTW nummer"]
["juli"]
[]
["Datum","Omschrijving",null,"Prijs\n (incl btw)",null,"% BTW","BTW","Prijs\n(excl btw)"]
[null,null,null,null,null,0.21,{"$f":"(D8-H8)","v":0},{"$f":"(D8/(F8+100%))","v":0}]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.06,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,{"$f":"(D16-H16)","v":0},{"$f":"(D16/(F16+100%))","v":0}]
[]
[null,null,null,null,null,"Subtotaal excl btw",null,{"$f":"SUM(H8:H15)","v":0}]
[null,null,null,null,null,"btw aan 21 %",{"$f":"SUMIF(F8:F15,\"=21%\",H8:H15)","v":0},{"$f":"SUM(G19)/100*21","v":0}]
[null,null,null,null,null,"btw aan 6 %",{"$f":"SUMIF(F8:F15,\"=6%\",H8:H15)","v":0},{"$f":"SUM(G20)/100*6","v":0}]
[null,null,null,null,null,"Totaal incl btw",null,{"$f":"SUM(H18:H20)","v":0}]

{"sheet":"augustus","index":1,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,3,6,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[11,1,11,2],[11,3,11,4],[22,0,23,7],[12,1,12,2],[12,3,12,4],[13,1,13,2],[13,3,13,4],[14,1,14,2],[14,3,14,4]]}
[]
["Dagontvangsten 2020"]
[]
["Maand","BTW nummer"]
["augustus"]
[]
["Datum","Omschrijving",null,"Prijs\n (incl btw)",null,"% BTW","BTW","Prijs\n(excl btw)"]
[null,"test",null,null,null,0.21,{"$f":"(D8-H8)","v":0},{"$f":"(D8/(F8+100%))","v":0}]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.06,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[null,null,null,null,null,0.21,0,0]
[]
[null,null,null,null,null,"Subtotaal excl btw",null,{"$f":"SUM(H8:H15)","v":0}]
[null,null,null,null,null,"btw aan 21 %",{"$f":"SUMIF(F8:F15,\"=21%\",H8:H15)","v":0},{"$f":"SUM(G18)/100*21","v":0}]
[null,null,null,null,null,"btw aan 6 %",{"$f":"SUMIF(F8:F15,\"=6%\",H8:H15)","v":0},{"$f":"SUM(G19)/100*6","v":0}]
[null,null,null,null,null,"Totaal incl btw",null,{"$f":"SUM(H17:H19)","v":0}]