{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data HR","Pivot HR","Booked invoices Wk39-44","Pivot Booked invoices"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"Data HR","index":0,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Afdeling/cost center","Naam, Voornaam","Weekprestatie","Weeknummer"]
["000001","Persoon1",26,40]
["000002","Persoon2",39,40]
["000003","Persoon3",39,40]
["000004","Persoon4",39,40]
["000005","Persoon5",24,40]
["000001","Persoon1",26,41]
["000002","Persoon2",39,41]
["000003","Persoon3",39,41]
["000004","Persoon4",39,41]
["000005","Persoon5",24,41]
["000001","Persoon1",26,42]
["000002","Persoon2",39,42]
["000003","Persoon3",39,42]
["000004","Persoon4",39,42]
["000005","Persoon5",24,42]
["000001","Persoon1",26,43]
["000002","Persoon2",39,43]
["000003","Persoon3",39,43]
["000004","Persoon4",39,43]
["000005","Persoon5",24,43]
["000001","Persoon1",26,44]
["000002","Persoon2",39,44]
["000003","Persoon3",39,44]
["000004","Persoon4",39,44]
["000005","Persoon5",24,44]

{"sheet":"Pivot HR","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Weekprestatie","Column Labels"]
["Row Labels",40,41,42,43,44,"Grand Total"]
["000001"]
["Persoon1",26,26,26,26,26,130]
["000002"]
["Persoon2",39,39,39,39,39,195]
["000003"]
["Persoon3",39,39,39,39,39,195]
["000004"]
["Persoon4",39,39,39,39,39,195]
["000005"]
["Persoon5",24,24,24,24,24,120]
["Grand Total",167,167,167,167,167,835]

{"sheet":"Booked invoices Wk39-44","index":2,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Weeknummer","Document Type","Document Date","Posting Date","Posting Key","Amount in local currency","Local Currency","Tax code","Clearing Document","Text","Cost Center"]
[40,"INV","2018-09-03","2018-10-05","40",1099.8,"EUR","3B","","Persoon1","000001"]
[40,"SN","2018-09-03","2018-10-05","40",17.38,"EUR","3B","","Persoon1","000001"]
[40,"SN","2018-09-03","2018-10-05","40",70,"EUR","3B","","Persoon1","000001"]
[40,"SN","2018-09-03","2018-10-05","40",12.5,"EUR","3B","","Persoon1","000001"]
[40,"SN","2018-09-03","2018-10-05","40",11.62,"EUR","3B","","Persoon1","000001"]
[40,"SN","2018-09-03","2018-10-05","40",1099.8,"EUR","3B","","Persoon2","000002"]
[40,"SN","2018-09-03","2018-10-05","40",17.38,"EUR","3B","","Persoon2","000002"]
[40,"SN","2018-09-03","2018-10-05","40",60,"EUR","3B","","Persoon2","000002"]
[40,"SN","2018-09-03","2018-10-05","40",7,"EUR","3B","","Persoon2","000002"]
[40,"SN","2018-09-03","2018-10-05","40",11.62,"EUR","3B","","Persoon2","000002"]
[40,"SN","2018-09-03","2018-10-05","40",1099.8,"EUR","3B","","Persoon3","000003"]
[40,"SN","2018-09-03","2018-10-05","40",17.38,"EUR","3B","","Persoon3","000003"]
[40,"SN","2018-09-03","2018-10-05","40",60,"EUR","3B","","Persoon3","000003"]
[40,"SN","2018-09-03","2018-10-05","40",60,"EUR","3B",null,"Persoon3","000003"]
[40,"SN","2018-09-03","2018-10-05","40",7,"EUR","3B",null,"Persoon3","000003"]
[40,"SN","2018-09-03","2018-10-05","40",11.62,"EUR","3B",null,"Persoon3","000003"]

{"sheet":"Pivot Booked invoices","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Amount in local currency",null,"Weeknummer"]
["Cost Center","Text",40]
["000001","Persoon1",1211.3]
["000002","Persoon2",1195.8]
["000003","Persoon3",1255.8]
["Grand Total",null,3662.8999999999996]