{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["6 - Allinge by Bjarne","T.","Ark1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"6 - Allinge by Bjarne","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,1],[35,7,35,9],[36,7,36,9],[37,7,37,9],[38,7,38,9],[0,8,0,10],[4,1,4,2],[4,4,4,5],[3,1,3,9],[2,4,2,9],[2,1,2,2],[2,16,2,17],[2,19,2,22],[3,16,3,22],[39,7,39,9],[34,7,34,9]]}
[null,null,null,null,null,null,null,null,"Arbejds-/timeseddel"]
[]
[" Medarb nr. ",9130,null,"Navn.:"]
[" Adresse"]
[" Fra dato",{"$f":"MIN(A9:A29)","v":"2018-08-27"},null," Til dato",{"$f":"MAX(A9:A29)","v":"2018-09-02"},null,"Årstal :",2018,"Ugenr.:",35]
[]
[]
["Dato","Arb. Kode","mask. nr","Afdeling:","Start tidspunkt","Slut tidspunkt","Pause","Timer","Heraf ovt 1.","Heraf ovt 2.","Div oplysninger"]
[{"$f":"FDIW(J5,H5)","v":"2018-08-27"},null,null,6,"07:15:00","14:30:00","00:30:00",{"$f":"IF(E9=\"\",\"\",((F9-E9)-G9)*24)","v":6.75},{"$f":"IF(H9=\"\",\"\",IF(WEEKDAY(A9,2)=7,0,IF(H9>T.!B2,MIN(H9-T.!B2,3),\"\")))","v":""},{"$f":"IF(I9=\"\",\"\",IF(H9>T.!B2+I9,H9-(T.!B2+I9),\"\"))","v":""}]
[{"$f":"A9+1","v":"2018-08-28"},null,null,null,"06:00:00","14:00:00","00:30:00",{"$f":"IF(E10=\"\",\"\",((F10-E10)-G10)*24)","v":7.5000000000000018},{"$f":"IF(H10=\"\",\"\",IF(WEEKDAY(A10,2)=7,0,IF(H10>T.!B3,MIN(H10-T.!B3,3),\"\")))","v":""},{"$f":"IF(I10=\"\",\"\",IF(H10>T.!B3+I10,H10-(T.!B3+I10),\"\"))","v":""}]
[{"$f":"A10+1","v":"2018-08-29"},null,null,null,"05:30:00","14:00:00","00:30:00",8.0000000000000018,{"$f":"IF(H11=\"\",\"\",IF(WEEKDAY(A11,2)=7,0,IF(H11>T.!B4,MIN(H11-T.!B4,3),\"\")))","v":0.50000000000000178},{"$f":"IF(I11=\"\",\"\",IF(H11>T.!B4+I11,H11-(T.!B4+I11),\"\"))","v":""}]
["2018-08-30",null,null,null,"06:00:00","14:00:00","00:30:00",7.5000000000000018,{"$f":"IF(H12=\"\",\"\",IF(WEEKDAY(A12,2)=7,0,IF(H12>T.!B5,MIN(H12-T.!B5,3),\"\")))","v":""},{"$f":"IF(I12=\"\",\"\",IF(H12>T.!B5+I12,H12-(T.!B5+I12),\"\"))","v":""}]
["2018-08-31",null,null,null,"06:00:00","16:00:00","00:30:00",9.5,{"$f":"IF(H13=\"\",\"\",IF(WEEKDAY(A13,2)=7,0,IF(H13>T.!B6,MIN(H13-T.!B6,3),\"\")))","v":2.5},{"$f":"IF(I13=\"\",\"\",IF(H13>T.!B6+I13,H13-(T.!B6+I13),\"\"))","v":""}]
["2018-09-01",null,null,null,null,null,null,{"$f":"IF(E14=\"\",\"\",((F14-E14)-G14)*24)","v":""},{"$f":"IF(H14=\"\",\"\",IF(WEEKDAY(A14,2)=7,0,IF(H14>T.!B7,MIN(H14-T.!B7,3),\"\")))","v":""},{"$f":"IF(I14=\"\",\"\",IF(H14>T.!B7+I14,H14-(T.!B7+I14),\"\"))","v":""}]
["2018-09-02",null,null,null,null,null,null,{"$f":"IF(E15=\"\",\"\",((F15-E15)-G15)*24)","v":""},{"$f":"IF(H15=\"\",\"\",IF(WEEKDAY(A15,2)=7,0,IF(H15>T.!B8,MIN(H15-T.!B8,3),\"\")))","v":""},{"$f":"IF(I15=\"\",\"\",IF(H15>T.!B8+I15,H15-(T.!B8+I15),\"\"))","v":""}]
[null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null," "]
[]
[null," "," "]
[null,null,null,null,null,null,null," "," "]
[]
[null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[null,3000,null,null,null,null,null,{"$f":"SUM(H9:H18)","v":39.250000000000007}]
[null,3300,null,null,null,null,null,null,{"$f":"SUM(I9:I18)","v":3.0000000000000018}]
[null,3310,null,null,null,null,null,null,null,{"$f":"SUM(J9:J18)","v":0}]
["Timer 1/100"]
[]
[null,null,null,null,null,null,null,"Ugens samlede antal timer:",null,null,{"$f":"H30","v":39.250000000000007}]
[null,null,null,null,null,null,3701,"Heraf ønskes ovf. t/afsp.:",null,null,{"$f":"MAX(0,K35-37)","v":2.2500000000000071}]
[null,null,null,null,null,null,3700,"Afsp timer ønskes udbetalt.: "]
[null,null,null,null,null,null,3400,"Sygetimer.:"]
[null,null,null,null,null,null,3411,"Betalte fritimer"]

{"sheet":"T.","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Afd. Koder","norm"]
[null,7.5]
[1,7.5]
[2,7.5]
[3,7.5]
[4,7]
[5,0]
[6,0]
[7]
[8]

{"sheet":"Ark1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}