{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":1,"macros":0,"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":"Blad1","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,2,4,3],[3,2,3,3],[12,0,12,3]]}
[]
[]
[null,null,null,"Meeruren"]
[null,null,"Vul de blauwe velden"]
[]
[]
[null,null,"Aantal contracturen per week",null,"Gemiddeld aantal uren extra",{"$f":"D10/((_xlfn.DAYS(D9,D8))/7)","v":{"$error":"#DIV/0!"}},"nieuw aantal uren",{"$f":"IF(ISBLANK(D8),D7,IF((D7+F7)>38,38,D7+F7))","v":0}]
[null,null,"Startdatum gewerkte meeruren",null,{"$f":"IF(ISBLANK(D8),\"\",IF(YEAR(D8)<2018,\"LET OP! jaartal moet minimaal 2018 zijn\",\"\"))","v":""}]
[null,null,"Einddatum gewerkte meeruren",null,{"$f":"IF(YEAR(D9)<>YEAR(D8),\"LET OP! jaartal moet hetzelfde zijn als begin periode\",\"\")","v":""}]
[null,null,"Aantal gewerkte meeruren"]
[]
[null,null,null,{"$f":"IF(ISBLANK(D7),\"\",\"Berekening\")","v":""}]
[{"$f":"IF(ISBLANK(D7),\"\",IF(OR(ISBLANK(D8),ISBLANK(D9)),\"Geef onderstaand aantal uren door via het werkgever.pmt.nl\",(CONCATENATE(\"Geef onderstaand aantal uren van \", TEXT( D8,\"d-m-jjjj\"),\" tot en met \",TEXT( D9,\"d-m-jjjj\"),\" door via werkgever.pmt.nl\"))))","v":""}]
[]
[null,null,"Aantal uren inclusief meeruren",{"$f":"IF(ISBLANK(D7),\"\",ROUND(H7,2))","v":""}]