{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Januar","Februar","Marts","April","December","Januar (2)","T.","norm","helligdage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":7,"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":"Januar","index":0,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,2,1],[1,2,2,2],[1,4,2,4],[1,5,2,5],[1,6,2,6],[40,8,40,9],[39,4,39,5],[39,8,39,9],[38,7,38,8],[1,9,1,10],[1,7,2,7],[1,8,2,8],[3,0,9,0],[10,0,16,0],[17,0,23,0],[24,0,30,0],[31,0,37,0]]}
[]
[null,"Dag","Dato",null,"Tekst","Komme","Gå","Dagens\n tid","Pause","Effektiv\n arbejdstid"]
[null,null,null,null,null,null,null,null,null,"tt:mm","1/100"]
[null,{"$f":"WEEKDAY(C4)","v":"1900-01-02"},"2018-01-01",{"$f":"HelligdagsNavn(C4,0,0)","v":"Nytårsdag"},null,"07:00:00","15:30:00",{"$f":"IF(OR(F4=\"\",G4=\"\"),\"\",IF(G4<F4,G4+1-F4,G4-F4))","v":"08:30:00"},"00:31:00",{"$f":"IF(E4=\"ferie\",norm!$B$11/24,IF(OR(F4=\"\",G4=\"\"),\"\",H4-I4))","v":"07:59:00"},{"$f":"IFERROR(J4*24,\"\")","v":7.9833333333333343}]
[null,{"$f":"WEEKDAY(C5)","v":"1900-01-03"},{"$f":"C4+1","v":"2018-01-02"},{"$f":"HelligdagsNavn(C5,0,0)","v":""},"ferie",null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF(G5<F5,G5+1-F5,G5-F5))","v":""},null,{"$f":"IF(E5=\"ferie\",norm!$B$11/24,IF(OR(F5=\"\",G5=\"\"),\"\",H5-I5))","v":"07:24:00"},{"$f":"IFERROR(J5*24,\"\")","v":7.4}]
[null,"1900-01-04",{"$f":"C5+1","v":"2018-01-03"},"","afsp.",null,null,{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF(G6<F6,G6+1-F6,G6-F6))","v":""},null,{"$f":"IF(E6=\"ferie\",norm!$B$11/24,IF(OR(F6=\"\",G6=\"\"),\"\",H6-I6))","v":""},{"$f":"IFERROR(J6*24,\"\")","v":""}]
[null,"1900-01-05","2018-01-04","",null,"07:00:00","15:00:00",{"$f":"IF(OR(F7=\"\",G7=\"\"),\"\",IF(G7<F7,G7+1-F7,G7-F7))","v":"08:00:00"},null,{"$f":"IF(E7=\"ferie\",norm!$B$11/24,IF(OR(F7=\"\",G7=\"\"),\"\",H7-I7))","v":"08:00:00"},{"$f":"IFERROR(J7*24,\"\")","v":8}]
[null,"1900-01-06","2018-01-05","","ferie",null,null,{"$f":"IF(OR(F8=\"\",G8=\"\"),\"\",IF(G8<F8,G8+1-F8,G8-F8))","v":""},null,{"$f":"IF(E8=\"ferie\",norm!$B$11/24,IF(OR(F8=\"\",G8=\"\"),\"\",H8-I8))","v":"07:24:00"},{"$f":"IFERROR(J8*24,\"\")","v":7.4}]
[null,"1900-01-07","2018-01-06","",null,null,null,null,null,{"$f":"IF(E9=\"ferie\",norm!$B$11/24,IF(OR(F9=\"\",G9=\"\"),\"\",H9-I9))","v":""}]
[null,"1900-01-01","2018-01-07","",null,null,null,null,null,{"$f":"IF(E10=\"ferie\",norm!$B$11/24,IF(OR(F10=\"\",G10=\"\"),\"\",H10-I10))","v":""}]
[null,"1900-01-02","2018-01-08","",null,"07:00:00","15:30:00",{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF(G11<F11,G11+1-F11,G11-F11))","v":"08:30:00"},"00:31:00",{"$f":"IF(E11=\"ferie\",norm!$B$11/24,IF(OR(F11=\"\",G11=\"\"),\"\",H11-I11))","v":"07:59:00"},{"$f":"IFERROR(J11*24,\"\")","v":7.9833333333333343}]
[null,"1900-01-03","2018-01-09","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",IF(G12<F12,G12+1-F12,G12-F12))","v":"05:00:00"},null,{"$f":"IF(E12=\"ferie\",norm!$B$11/24,IF(OR(F12=\"\",G12=\"\"),\"\",H12-I12))","v":"05:00:00"},{"$f":"IFERROR(J12*24,\"\")","v":5.0000000000000009}]
[null,"1900-01-04","2018-01-10","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",IF(G13<F13,G13+1-F13,G13-F13))","v":"16:00:00"},null,{"$f":"IF(E13=\"ferie\",norm!$B$11/24,IF(OR(F13=\"\",G13=\"\"),\"\",H13-I13))","v":"16:00:00"},{"$f":"IFERROR(J13*24,\"\")","v":16}]
[null,"1900-01-05","2018-01-11","",null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",IF(G14<F14,G14+1-F14,G14-F14))","v":""},null,{"$f":"IF(E14=\"ferie\",norm!$B$11/24,IF(OR(F14=\"\",G14=\"\"),\"\",H14-I14))","v":""},{"$f":"IFERROR(J14*24,\"\")","v":""}]
[null,"1900-01-06","2018-01-12","",null,null,null,{"$f":"IF(OR(F15=\"\",G15=\"\"),\"\",IF(G15<F15,G15+1-F15,G15-F15))","v":""},null,{"$f":"IF(E15=\"ferie\",norm!$B$11/24,IF(OR(F15=\"\",G15=\"\"),\"\",H15-I15))","v":""},{"$f":"IFERROR(J15*24,\"\")","v":""}]
[null,"1900-01-07","2018-01-13","",null,null,null,null,null,{"$f":"IF(E16=\"ferie\",norm!$B$11/24,IF(OR(F16=\"\",G16=\"\"),\"\",H16-I16))","v":""},{"$f":"IFERROR(J16*24,\"\")","v":""}]
[null,"1900-01-01","2018-01-14","",null,null,null,null,null,{"$f":"IF(E17=\"ferie\",norm!$B$11/24,IF(OR(F17=\"\",G17=\"\"),\"\",H17-I17))","v":""},""]
[null,"1900-01-02","2018-01-15","",null,"07:00:00","15:30:00",{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF(G18<F18,G18+1-F18,G18-F18))","v":"08:30:00"},"00:31:00",{"$f":"IF(E18=\"ferie\",norm!$B$11/24,IF(OR(F18=\"\",G18=\"\"),\"\",H18-I18))","v":"07:59:00"},{"$f":"IFERROR(J18*24,\"\")","v":7.9833333333333343}]
[null,"1900-01-03","2018-01-16","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF(G19<F19,G19+1-F19,G19-F19))","v":"05:00:00"},null,{"$f":"IF(E19=\"ferie\",norm!$B$11/24,IF(OR(F19=\"\",G19=\"\"),\"\",H19-I19))","v":"05:00:00"},{"$f":"IFERROR(J19*24,\"\")","v":5.0000000000000009}]
[null,"1900-01-04","2018-01-17","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",IF(G20<F20,G20+1-F20,G20-F20))","v":"16:00:00"},null,{"$f":"IF(E20=\"ferie\",norm!$B$11/24,IF(OR(F20=\"\",G20=\"\"),\"\",H20-I20))","v":"16:00:00"},{"$f":"IFERROR(J20*24,\"\")","v":16}]
[null,"1900-01-05","2018-01-18","",null,null,null,{"$f":"IF(OR(F21=\"\",G21=\"\"),\"\",IF(G21<F21,G21+1-F21,G21-F21))","v":""},null,{"$f":"IF(E21=\"ferie\",norm!$B$11/24,IF(OR(F21=\"\",G21=\"\"),\"\",H21-I21))","v":""},{"$f":"IFERROR(J21*24,\"\")","v":""}]
[null,"1900-01-06","2018-01-19","",null,null,null,{"$f":"IF(OR(F22=\"\",G22=\"\"),\"\",IF(G22<F22,G22+1-F22,G22-F22))","v":""},null,{"$f":"IF(E22=\"ferie\",norm!$B$11/24,IF(OR(F22=\"\",G22=\"\"),\"\",H22-I22))","v":""},{"$f":"IFERROR(J22*24,\"\")","v":""}]
[null,"1900-01-07","2018-01-20","",null,null,null,{"$f":"IF(OR(F23=\"\",G23=\"\"),\"\",IF(G23<F23,G23+1-F23,G23-F23))","v":""},null,{"$f":"IF(E23=\"ferie\",norm!$B$11/24,IF(OR(F23=\"\",G23=\"\"),\"\",H23-I23))","v":""},{"$f":"IFERROR(J23*24,\"\")","v":""}]
[null,"1900-01-01","2018-01-21","",null,null,null,"",null,{"$f":"IF(E24=\"ferie\",norm!$B$11/24,IF(OR(F24=\"\",G24=\"\"),\"\",H24-I24))","v":""},""]
[null,"1900-01-02","2018-01-22","",null,"07:00:00","15:30:00",{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",IF(G25<F25,G25+1-F25,G25-F25))","v":"08:30:00"},"00:31:00",{"$f":"IF(E25=\"ferie\",norm!$B$11/24,IF(OR(F25=\"\",G25=\"\"),\"\",H25-I25))","v":"07:59:00"},{"$f":"IFERROR(J25*24,\"\")","v":7.9833333333333343}]
[null,"1900-01-03","2018-01-23","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",IF(G26<F26,G26+1-F26,G26-F26))","v":"05:00:00"},null,{"$f":"IF(E26=\"ferie\",norm!$B$11/24,IF(OR(F26=\"\",G26=\"\"),\"\",H26-I26))","v":"05:00:00"},{"$f":"IFERROR(J26*24,\"\")","v":5.0000000000000009}]
[null,"1900-01-04","2018-01-24","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",IF(G27<F27,G27+1-F27,G27-F27))","v":"16:00:00"},null,{"$f":"IF(E27=\"ferie\",norm!$B$11/24,IF(OR(F27=\"\",G27=\"\"),\"\",H27-I27))","v":"16:00:00"},{"$f":"IFERROR(J27*24,\"\")","v":16}]
[null,"1900-01-05","2018-01-25","",null,null,null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",IF(G28<F28,G28+1-F28,G28-F28))","v":""},null,{"$f":"IF(E28=\"ferie\",norm!$B$11/24,IF(OR(F28=\"\",G28=\"\"),\"\",H28-I28))","v":""},{"$f":"IFERROR(J28*24,\"\")","v":""}]
[null,"1900-01-06","2018-01-26","",null,null,null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",IF(G29<F29,G29+1-F29,G29-F29))","v":""},null,{"$f":"IF(E29=\"ferie\",norm!$B$11/24,IF(OR(F29=\"\",G29=\"\"),\"\",H29-I29))","v":""},{"$f":"IFERROR(J29*24,\"\")","v":""}]
[null,"1900-01-07","2018-01-27","",null,null,null,{"$f":"IF(OR(F30=\"\",G30=\"\"),\"\",IF(G30<F30,G30+1-F30,G30-F30))","v":""},null,{"$f":"IF(E30=\"ferie\",norm!$B$11/24,IF(OR(F30=\"\",G30=\"\"),\"\",H30-I30))","v":""},{"$f":"IFERROR(J30*24,\"\")","v":""}]
[null,"1900-01-01","2018-01-28","",null,null,null,"",null,{"$f":"IF(E31=\"ferie\",norm!$B$11/24,IF(OR(F31=\"\",G31=\"\"),\"\",H31-I31))","v":""},""]
[null,"1900-01-02",{"$f":"IF(MONTH(C31+1)>MONTH(C31),\"\",C31+1)","v":"2018-01-29"},"",null,"07:00:00","15:30:00",{"$f":"IF(OR(F32=\"\",G32=\"\"),\"\",IF(G32<F32,G32+1-F32,G32-F32))","v":"08:30:00"},"00:31:00",{"$f":"IF(E32=\"ferie\",norm!$B$11/24,IF(OR(F32=\"\",G32=\"\"),\"\",H32-I32))","v":"07:59:00"},{"$f":"IFERROR(J32*24,\"\")","v":7.9833333333333343}]
[null,"1900-01-03","2018-01-30","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F33=\"\",G33=\"\"),\"\",IF(G33<F33,G33+1-F33,G33-F33))","v":"05:00:00"},null,{"$f":"IF(E33=\"ferie\",norm!$B$11/24,IF(OR(F33=\"\",G33=\"\"),\"\",H33-I33))","v":"05:00:00"},{"$f":"IFERROR(J33*24,\"\")","v":5.0000000000000009}]
[null,"1900-01-04","2018-01-31","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F34=\"\",G34=\"\"),\"\",IF(G34<F34,G34+1-F34,G34-F34))","v":"16:00:00"},null,{"$f":"IF(E34=\"ferie\",norm!$B$11/24,IF(OR(F34=\"\",G34=\"\"),\"\",H34-I34))","v":"16:00:00"},{"$f":"IFERROR(J34*24,\"\")","v":16}]
[null,{"$f":"IFERROR(WEEKDAY(C35),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(C34+1)>MONTH(C34),\"\",C34+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F35=\"\",G35=\"\"),\"\",IF(G35<F35,G35+1-F35,G35-F35))","v":""},null,{"$f":"IF(E35=\"ferie\",norm!$B$11/24,IF(OR(F35=\"\",G35=\"\"),\"\",H35-I35))","v":""},{"$f":"IFERROR(J35*24,\"\")","v":""}]
[null,{"$f":"IFERROR(WEEKDAY(C36),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(C35+1)>MONTH(C35),\"\",C35+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F36=\"\",G36=\"\"),\"\",IF(G36<F36,G36+1-F36,G36-F36))","v":""},null,{"$f":"IF(E36=\"ferie\",norm!$B$11/24,IF(OR(F36=\"\",G36=\"\"),\"\",H36-I36))","v":""},{"$f":"IFERROR(J36*24,\"\")","v":""},null,null,{"$f":"IF(C36<>\"\",CHOOSE(WEEKDAY(C36,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,{"$f":"IF(E37=\"ferie\",norm!$B$11/24,IF(OR(F37=\"\",G37=\"\"),\"\",H37-I37))","v":""},null,null,null,{"$f":"IF(C37<>\"\",CHOOSE(WEEKDAY(C37,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,{"$f":"IF(E38=\"ferie\",norm!$B$11/24,IF(OR(F38=\"\",G38=\"\"),\"\",H38-I38))","v":""},null,null,null,{"$f":"IF(C38<>\"\",CHOOSE(WEEKDAY(C38,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,null,null,null,null,null,"Total timer",null,{"$f":"SUM(J4:J38)","v":6.1131944444444448},{"$f":"J39*24","v":146.71666666666667}]
[null,null,{"$f":"NETWORKDAYS(C4,C34,helligdage!B2:B12)","v":22},null,"arbejdsdage",null,null,null,"Måneds norm",null,{"$f":"C40*7.4","v":162.80000000000001}]
[null,null,null,null,null,null,null,null,"Månedens flekstid",null,{"$f":"K39-K40","v":-16.083333333333343}]

{"sheet":"Februar","index":1,"n_rows":41,"n_cols":24,"rows_kept":41,"cut":false,"hidden":false,"merged":[[39,7,39,8],[40,7,40,8],[38,7,38,8],[30,0,36,0],[2,0,8,0],[9,0,15,0],[16,0,22,0],[23,0,29,0],[37,7,37,8]]}
[]
[null,"Dag","Dato",null,"Tekst","Komme","Gå","Dagens\ntid","Pause","Effektiv\n arbejdstid",null,null,null,null,null,null,null,null,null,null,null,"Skudår","uge \nnorm","dags \nnorm"]
[null,{"$f":"WEEKDAY(C3)","v":"1900-01-05"},{"$f":"DATE(YEAR(Januar!$C$4),2,1)","v":"2018-02-01"},null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F3=\"\",G3=\"\"),\"\",IF(G3<F3,G3+1-F3,G3-F3))","v":"08:30:00"},null,{"$f":"IF(E3=\"ferie\",$X$3/24,IF(OR(F3=\"\",G3=\"\"),\"\",H3-I3))","v":"08:30:00"},null,null,null,null,null,null,null,null,null,null,null,null,37,7.4]
[null,{"$f":"WEEKDAY(C4)","v":"1900-01-06"},{"$f":"C3+1","v":"2018-02-02"},null,"ferie",null,null,{"$f":"IF(OR(F4=\"\",G4=\"\"),\"\",IF(G4<F4,G4+1-F4,G4-F4))","v":""},null,"07:24:00"]
[null,"1900-01-07",{"$f":"C4+1","v":"2018-02-03"},null,"afsp.",null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF(G5<F5,G5+1-F5,G5-F5))","v":""},null,""]
[null,"1900-01-01","2018-02-04",null,null,"07:00:00","15:00:00",{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF(G6<F6,G6+1-F6,G6-F6))","v":"08:00:00"},null,"08:00:00"]
[null,"1900-01-02","2018-02-05",null,"ferie",null,null,{"$f":"IF(OR(F7=\"\",G7=\"\"),\"\",IF(G7<F7,G7+1-F7,G7-F7))","v":""},null,"07:24:00"]
[null,"1900-01-03","2018-02-06",null,null,null,null,null,null,""]
[null,"1900-01-04","2018-02-07",null,null,null,null,null,null,""]
[null,"1900-01-05","2018-02-08",null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(G10<F10,G10+1-F10,G10-F10))","v":"08:30:00"},null,"08:30:00"]
[null,"1900-01-06","2018-02-09",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF(G11<F11,G11+1-F11,G11-F11))","v":"05:00:00"},null,"05:00:00"]
[null,"1900-01-07","2018-02-10",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",IF(G12<F12,G12+1-F12,G12-F12))","v":"16:00:00"},null,"16:00:00"]
[null,"1900-01-01","2018-02-11",null,null,null,null,{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",IF(G13<F13,G13+1-F13,G13-F13))","v":""},null,""]
[null,"1900-01-02","2018-02-12",null,null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",IF(G14<F14,G14+1-F14,G14-F14))","v":""},null,""]
[null,"1900-01-03","2018-02-13",null,null,null,null,null,null,""]
[null,"1900-01-04","2018-02-14",null,null,null,null,null,null,""]
[null,"1900-01-05","2018-02-15",null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",IF(G17<F17,G17+1-F17,G17-F17))","v":"08:30:00"},null,"08:30:00"]
[null,"1900-01-06","2018-02-16",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF(G18<F18,G18+1-F18,G18-F18))","v":"05:00:00"},null,"05:00:00"]
[null,"1900-01-07","2018-02-17",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF(G19<F19,G19+1-F19,G19-F19))","v":"16:00:00"},null,"16:00:00"]
[null,"1900-01-01","2018-02-18",null,null,null,null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",IF(G20<F20,G20+1-F20,G20-F20))","v":""},null,""]
[null,"1900-01-02","2018-02-19",null,null,null,null,{"$f":"IF(OR(F21=\"\",G21=\"\"),\"\",IF(G21<F21,G21+1-F21,G21-F21))","v":""},null,""]
[null,"1900-01-03","2018-02-20",null,null,null,null,{"$f":"IF(OR(F22=\"\",G22=\"\"),\"\",IF(G22<F22,G22+1-F22,G22-F22))","v":""},null,""]
[null,"1900-01-04","2018-02-21",null,null,null,null,"",null,""]
[null,"1900-01-05","2018-02-22",null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F24=\"\",G24=\"\"),\"\",IF(G24<F24,G24+1-F24,G24-F24))","v":"08:30:00"},null,"08:30:00"]
[null,"1900-01-06","2018-02-23",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",IF(G25<F25,G25+1-F25,G25-F25))","v":"05:00:00"},null,"05:00:00"]
[null,"1900-01-07","2018-02-24",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",IF(G26<F26,G26+1-F26,G26-F26))","v":"16:00:00"},null,"16:00:00"]
[null,"1900-01-01","2018-02-25",null,null,null,null,{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",IF(G27<F27,G27+1-F27,G27-F27))","v":""},null,""]
[null,"1900-01-02","2018-02-26",null,null,null,null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",IF(G28<F28,G28+1-F28,G28-F28))","v":""},null,""]
[null,"1900-01-03","2018-02-27",null,null,null,null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",IF(G29<F29,G29+1-F29,G29-F29))","v":""},null,""]
[null,"1900-01-04","2018-02-28",null,null,null,null,"",null,""]
[null,{"$f":"IFERROR(WEEKDAY(C31),\"\")","v":""},{"$f":"IF(MONTH(C30+1)>MONTH(C30),\"\",C30+1)","v":""},null,null,null,null,{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",IF(G31<F31,G31+1-F31,G31-F31))","v":""},null,""]
[null,{"$f":"IFERROR(WEEKDAY(C32),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(C31+1)>MONTH(C31),\"\",C31+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F32=\"\",G32=\"\"),\"\",IF(G32<F32,G32+1-F32,G32-F32))","v":""},null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C32,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"",{"$f":"IFERROR(IF(MONTH(C32+1)>MONTH(C32),\"\",C32+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F33=\"\",G33=\"\"),\"\",IF(G33<F33,G33+1-F33,G33-F33))","v":""},null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C33,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,{"$f":"IF(OR(F34=\"\",G34=\"\"),\"\",IF(G34<F34,G34+1-F34,G34-F34))","v":""},null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C34,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,{"$f":"IF(OR(F35=\"\",G35=\"\"),\"\",IF(G35<F35,G35+1-F35,G35-F35))","v":""},null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C35,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C36,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C37,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,null,null,null,null,null,"Total timer ",null,{"$f":"SUM(J3:J37)","v":4.9916666666666671}]
[null,null,null,null,null,null,null,"1/100 dele ",null,{"$f":"J38*24","v":119.80000000000001}]
[null,null,{"$f":"IF(T.!C1>28,NETWORKDAYS(C3,C31,helligdage!B2:B12),NETWORKDAYS(C3,C30,helligdage!B2:B12))","v":20}," arbejdsdage",null,null,null,"Måneds norm",null,{"$f":"C40*7.4","v":148}]
[null,null,null,null,null,null,null,"Månedens flekstid",null,{"$f":"J39-J40","v":-28.199999999999989}]

{"sheet":"Marts","index":2,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,8,38,9],[39,8,39,9],[37,7,37,8],[2,0,8,0],[9,0,15,0],[16,0,22,0],[23,0,29,0],[30,0,36,0]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Kun for\ntest",null,null,"uge norm",37]
[null,null,null,null,"Tekst","Komme","Gå","Dagens tid","Pause","Eff. arbejdstid",null,"TT:MM","1/100","norm",null,null,"dags norm",7.4,null,"Flex konto"]
[null,{"$f":"WEEKDAY(C3)","v":"1900-01-05"},{"$f":"DATE(YEAR(Januar!$C$4),3,1)","v":"2018-03-01"},null,null,null,null,{"$f":"IF(OR(F3=\"\",G3=\"\"),\"\",IF(G3<F3,G3+1-F3,G3-F3))","v":""},"00:31:00",{"$f":"IF(E3=\"ferie\",$R$2/24,IF(OR(F3=\"\",G3=\"\"),\"\",H3-I3))","v":""},{"$f":"IFERROR(J3*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C3,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 1",{"$f":"M9-R1","v":-37}]
[null,{"$f":"WEEKDAY(C4)","v":"1900-01-06"},{"$f":"C3+1","v":"2018-03-02"},null,"ferie",null,null,{"$f":"IF(OR(F4=\"\",G4=\"\"),\"\",IF(G4<F4,G4+1-F4,G4-F4))","v":""},null,{"$f":"IF(E4=\"ferie\",$R$2/24,IF(OR(F4=\"\",G4=\"\"),\"\",H4-I4))","v":"07:24:00"},{"$f":"IFERROR(J4*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C4,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 2",{"$f":"M16-R1","v":-37},null,{"$f":"SUM(R3:R7)","v":-99.199999999999989}]
[null,"1900-01-07",{"$f":"C4+1","v":"2018-03-03"},null,"afsp.",null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF(G5<F5,G5+1-F5,G5-F5))","v":""},null,"",{"$f":"IFERROR(J5*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C5,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0},null,null,"Uge 3",{"$f":"M23-R1","v":-37}]
[null,"1900-01-01","2018-03-04",null,null,"07:00:00","15:00:00",{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF(G6<F6,G6+1-F6,G6-F6))","v":"08:00:00"},null,"08:00:00",{"$f":"IFERROR(J6*24,\"\")","v":8},null,null,{"$f":"CHOOSE(WEEKDAY(C6,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0},null,null,"Uge 4",{"$f":"M30-R1","v":-37}]
[null,"1900-01-02","2018-03-05",null,"ferie",null,null,{"$f":"IF(OR(F7=\"\",G7=\"\"),\"\",IF(G7<F7,G7+1-F7,G7-F7))","v":""},null,"07:24:00",{"$f":"IFERROR(J7*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C7,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 5",{"$f":"K38-R1","v":48.800000000000011}]
[null,"1900-01-03","2018-03-06",null,null,null,null,null,null,"",null,null,null,{"$f":"CHOOSE(WEEKDAY(C8,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,null,null,null,{"$f":"K38-K39","v":-62.199999999999989}]
[null,"1900-01-04","2018-03-07",null,null,null,null,null,null,"",null,null,null,{"$f":"CHOOSE(WEEKDAY(C9,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-03-08",null,null,null,null,{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(G10<F10,G10+1-F10,G10-F10))","v":""},"00:31:00","",{"$f":"IFERROR(J10*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C10,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-03-09",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF(G11<F11,G11+1-F11,G11-F11))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J11*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C11,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-03-10",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",IF(G12<F12,G12+1-F12,G12-F12))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J12*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C12,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-03-11",null,null,null,null,{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",IF(G13<F13,G13+1-F13,G13-F13))","v":""},null,"",{"$f":"IFERROR(J13*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C13,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-03-12",null,null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",IF(G14<F14,G14+1-F14,G14-F14))","v":""},null,"",{"$f":"IFERROR(J14*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C14,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-03-13",null,null,null,null,null,null,"",{"$f":"IFERROR(J15*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C15,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-03-14",null,null,null,null,null,null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C16,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-03-15",null,null,null,null,{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",IF(G17<F17,G17+1-F17,G17-F17))","v":""},"00:31:00","",{"$f":"IFERROR(J17*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C17,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-03-16",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF(G18<F18,G18+1-F18,G18-F18))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J18*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C18,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-03-17",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF(G19<F19,G19+1-F19,G19-F19))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J19*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C19,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-03-18",null,null,null,null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",IF(G20<F20,G20+1-F20,G20-F20))","v":""},null,"",{"$f":"IFERROR(J20*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C20,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-03-19",null,null,null,null,{"$f":"IF(OR(F21=\"\",G21=\"\"),\"\",IF(G21<F21,G21+1-F21,G21-F21))","v":""},null,"",{"$f":"IFERROR(J21*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C21,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-03-20",null,null,null,null,{"$f":"IF(OR(F22=\"\",G22=\"\"),\"\",IF(G22<F22,G22+1-F22,G22-F22))","v":""},null,"",{"$f":"IFERROR(J22*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C22,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-03-21",null,null,null,null,"",null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C23,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-03-22",null,null,null,null,{"$f":"IF(OR(F24=\"\",G24=\"\"),\"\",IF(G24<F24,G24+1-F24,G24-F24))","v":""},"00:31:00","",{"$f":"IFERROR(J24*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C24,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-03-23",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",IF(G25<F25,G25+1-F25,G25-F25))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J25*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C25,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-03-24",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",IF(G26<F26,G26+1-F26,G26-F26))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J26*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C26,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-03-25",null,null,null,null,{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",IF(G27<F27,G27+1-F27,G27-F27))","v":""},null,"",{"$f":"IFERROR(J27*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C27,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-03-26",null,null,null,null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",IF(G28<F28,G28+1-F28,G28-F28))","v":""},null,"",{"$f":"IFERROR(J28*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C28,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-03-27",null,null,null,null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",IF(G29<F29,G29+1-F29,G29-F29))","v":""},null,"",{"$f":"IFERROR(J29*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C29,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-03-28",null,null,null,null,"",null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C30,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,{"$f":"IFERROR(WEEKDAY(C31),\"\")","v":"1900-01-05"},{"$f":"IF(MONTH(C30+1)>MONTH(C30),\"\",C30+1)","v":"2018-03-29"},null,null,null,null,{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",IF(G31<F31,G31+1-F31,G31-F31))","v":""},null,"",{"$f":"IFERROR(J31*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C31,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":7.4}]
[null,{"$f":"IFERROR(WEEKDAY(C32),\"\")","v":"1900-01-06"},{"$f":"IFERROR(IF(MONTH(C31+1)>MONTH(C31),\"\",C31+1),\"\")","v":"2018-03-30"},null,null,null,null,{"$f":"IF(OR(F32=\"\",G32=\"\"),\"\",IF(G32<F32,G32+1-F32,G32-F32))","v":""},null,"",{"$f":"IFERROR(J32*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C32,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":7.4}]
[null,"1900-01-07",{"$f":"IFERROR(IF(MONTH(C32+1)>MONTH(C32),\"\",C32+1),\"\")","v":"2018-03-31"},null,null,null,null,{"$f":"IF(OR(F33=\"\",G33=\"\"),\"\",IF(G33<F33,G33+1-F33,G33-F33))","v":""},null,"",{"$f":"IFERROR(J33*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C33,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":0}]
[null,"","",null,null,null,null,{"$f":"IF(OR(F34=\"\",G34=\"\"),\"\",IF(G34<F34,G34+1-F34,G34-F34))","v":""},null,"",{"$f":"IFERROR(J34*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C34,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,{"$f":"IF(OR(F35=\"\",G35=\"\"),\"\",IF(G35<F35,G35+1-F35,G35-F35))","v":""},null,"",{"$f":"IFERROR(J35*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C35,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C36,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C37,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,null,null,null,null,null,"Total timer",null,{"$f":"SUM(J3:J33)","v":3.5750000000000002},{"$f":"J38*24","v":85.800000000000011}]
[null,null,{"$f":"NETWORKDAYS(C3,C33,helligdage!B2:B12)","v":20},"arbejdsdage",null,null,null,null,"Måneds norm",null,{"$f":"C39*R2","v":148}]
[null,null,null,null,null,null,null,null,"Månedens flekstid"]

{"sheet":"April","index":3,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[30,0,36,0],[0,11,0,12],[2,0,8,0],[9,0,15,0],[16,0,22,0],[23,0,29,0]]}
[null,null,null,null,null,null,null,null,null,null,null,"Total timer\nmåned",null,"Kun for\ntest",null,null,"uge norm",37]
[null,"Ugedag","Dato","Dag","Tekst","Komme","Gå","Dagens tid","Pause","Effektiv arbejdstid",null,"TT:MM","1/100","norm",null,null,"dags norm",7.4,null,"Flex konto"]
[null,{"$f":"WEEKDAY(C3)","v":"1900-01-01"},{"$f":"DATE(YEAR(Januar!$C$4),4,1)","v":"2018-04-01"},{"$f":"HelligdagsNavn(C3,0,0)","v":"Påskedag"},null,null,null,{"$f":"IF(OR(F3=\"\",G3=\"\"),\"\",IF(G3<F3,G3+1-F3,G3-F3))","v":""},null,{"$f":"IF(E3=\"ferie\",$R$2/24,IF(OR(F3=\"\",G3=\"\"),\"\",H3-I3))","v":""},{"$f":"IFERROR(J3*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C3,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0},null,null,"Uge 1",{"$f":"M9-R1","v":-37}]
[null,{"$f":"WEEKDAY(C4)","v":"1900-01-02"},{"$f":"C3+1","v":"2018-04-02"},{"$f":"HelligdagsNavn(C4,0,0)","v":"2. Påskedag"},"ferie",null,null,{"$f":"IF(OR(F4=\"\",G4=\"\"),\"\",IF(G4<F4,G4+1-F4,G4-F4))","v":""},null,{"$f":"IF(E4=\"ferie\",$R$2/24,IF(OR(F4=\"\",G4=\"\"),\"\",H4-I4))","v":"07:24:00"},{"$f":"IFERROR(J4*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C4,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 2",{"$f":"M16-R1","v":-37},null,{"$f":"SUM(R3:R7)","v":-99.199999999999989}]
[null,"1900-01-03",{"$f":"C4+1","v":"2018-04-03"},"","afsp.",null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF(G5<F5,G5+1-F5,G5-F5))","v":""},null,"",{"$f":"IFERROR(J5*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C5,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 3",{"$f":"M23-R1","v":-37}]
[null,"1900-01-04","2018-04-04","",null,"07:00:00","15:00:00",{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF(G6<F6,G6+1-F6,G6-F6))","v":"08:00:00"},null,"08:00:00",{"$f":"IFERROR(J6*24,\"\")","v":8},null,null,{"$f":"CHOOSE(WEEKDAY(C6,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 4",{"$f":"M30-R1","v":-37}]
[null,"1900-01-05","2018-04-05","","ferie",null,null,{"$f":"IF(OR(F7=\"\",G7=\"\"),\"\",IF(G7<F7,G7+1-F7,G7-F7))","v":""},null,"07:24:00",{"$f":"IFERROR(J7*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C7,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 5",{"$f":"M38-R1","v":48.800000000000011}]
[null,"1900-01-06","2018-04-06","",null,null,null,null,null,"",null,null,null,{"$f":"CHOOSE(WEEKDAY(C8,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,null,null,null,{"$f":"M38-M39","v":-54.799999999999983}]
[null,"1900-01-07","2018-04-07","",null,null,null,null,null,"",null,null,null,{"$f":"CHOOSE(WEEKDAY(C9,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-04-08","",null,null,null,{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(G10<F10,G10+1-F10,G10-F10))","v":""},null,"",{"$f":"IFERROR(J10*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C10,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-04-09","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF(G11<F11,G11+1-F11,G11-F11))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J11*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C11,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-04-10","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",IF(G12<F12,G12+1-F12,G12-F12))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J12*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C12,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-04-11","",null,null,null,{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",IF(G13<F13,G13+1-F13,G13-F13))","v":""},null,"",{"$f":"IFERROR(J13*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C13,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-04-12","",null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",IF(G14<F14,G14+1-F14,G14-F14))","v":""},null,"",{"$f":"IFERROR(J14*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C14,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-04-13","",null,null,null,null,null,"",{"$f":"IFERROR(J15*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C15,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-04-14","",null,null,null,null,null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C16,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-04-15","",null,null,null,{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",IF(G17<F17,G17+1-F17,G17-F17))","v":""},null,"",{"$f":"IFERROR(J17*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C17,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-04-16","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF(G18<F18,G18+1-F18,G18-F18))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J18*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C18,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-04-17","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF(G19<F19,G19+1-F19,G19-F19))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J19*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C19,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-04-18","",null,null,null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",IF(G20<F20,G20+1-F20,G20-F20))","v":""},null,"",{"$f":"IFERROR(J20*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C20,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-04-19","",null,null,null,{"$f":"IF(OR(F21=\"\",G21=\"\"),\"\",IF(G21<F21,G21+1-F21,G21-F21))","v":""},null,"",{"$f":"IFERROR(J21*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C21,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-04-20","",null,null,null,{"$f":"IF(OR(F22=\"\",G22=\"\"),\"\",IF(G22<F22,G22+1-F22,G22-F22))","v":""},null,"",{"$f":"IFERROR(J22*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C22,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-04-21","",null,null,null,"",null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C23,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-04-22","",null,null,null,{"$f":"IF(OR(F24=\"\",G24=\"\"),\"\",IF(G24<F24,G24+1-F24,G24-F24))","v":""},null,"",{"$f":"IFERROR(J24*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C24,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-04-23","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",IF(G25<F25,G25+1-F25,G25-F25))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J25*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C25,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-04-24","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",IF(G26<F26,G26+1-F26,G26-F26))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J26*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C26,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-04-25","",null,null,null,{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",IF(G27<F27,G27+1-F27,G27-F27))","v":""},null,"",{"$f":"IFERROR(J27*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C27,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-04-26","",null,null,null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",IF(G28<F28,G28+1-F28,G28-F28))","v":""},null,"",{"$f":"IFERROR(J28*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C28,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-04-27","Store Bededag",null,null,null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",IF(G29<F29,G29+1-F29,G29-F29))","v":""},null,"",{"$f":"IFERROR(J29*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C29,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-04-28","",null,null,null,"",null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C30,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,{"$f":"IFERROR(WEEKDAY(C31),\"\")","v":"1900-01-01"},{"$f":"IF(MONTH(C30+1)>MONTH(C30),\"\",C30+1)","v":"2018-04-29"},"",null,null,null,{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",IF(G31<F31,G31+1-F31,G31-F31))","v":""},null,"",{"$f":"IFERROR(J31*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C31,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":0}]
[null,{"$f":"IFERROR(WEEKDAY(C32),\"\")","v":"1900-01-02"},{"$f":"IFERROR(IF(MONTH(C31+1)>MONTH(C31),\"\",C31+1),\"\")","v":"2018-04-30"},"",null,null,null,{"$f":"IF(OR(F32=\"\",G32=\"\"),\"\",IF(G32<F32,G32+1-F32,G32-F32))","v":""},null,"",{"$f":"IFERROR(J32*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C32,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":7.4}]
[null,"",{"$f":"IFERROR(IF(MONTH(C32+1)>MONTH(C32),\"\",C32+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F33=\"\",G33=\"\"),\"\",IF(G33<F33,G33+1-F33,G33-F33))","v":""},null,"",{"$f":"IFERROR(J33*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C33,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,{"$f":"IF(OR(F34=\"\",G34=\"\"),\"\",IF(G34<F34,G34+1-F34,G34-F34))","v":""},null,"",{"$f":"IFERROR(J34*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C34,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,{"$f":"IF(OR(F35=\"\",G35=\"\"),\"\",IF(G35<F35,G35+1-F35,G35-F35))","v":""},null,"",{"$f":"IFERROR(J35*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C35,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C36,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C37,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J3:J33)","v":3.5750000000000002},{"$f":"L38*24","v":85.800000000000011}]
[null,null,{"$f":"NETWORKDAYS(C3,C32,helligdage!B2:B12)","v":19},"arbejdsdage",null,null,null,null,null,null,"Måneds norm",null,{"$f":"C39*R2","v":140.6}]
[null,null,null,null,null,null,null,null,null,null,"Månedens flekstid",null,{"$f":"M38-M39","v":-54.799999999999983}]

{"sheet":"December","index":4,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[30,0,36,0],[0,11,0,12],[2,0,8,0],[9,0,15,0],[16,0,22,0],[23,0,29,0],[38,4,38,5],[0,9,0,10],[37,7,37,8],[38,8,38,9],[39,8,39,9]]}
[null,null,null,null,null,null,null,null,null,"Effektiv\narbejdstid",null,"Total timer\nmåned",null,"Kun for\ntest",null,null,"uge norm",37]
[null,"Ugedag","Dato","Dag","Tekst","Komme","Gå","Dagens tid","Pause","TT:MM","1/100",null,null,"norm",null,null,"dags norm",7.4,null,"Flex konto"]
[null,{"$f":"WEEKDAY(C3)","v":"1900-01-07"},{"$f":"DATE(YEAR(Januar!$C$4),12,1)","v":"2018-12-01"},{"$f":"HelligdagsNavn(C3,0,0)","v":""},null,null,null,{"$f":"IF(OR(F3=\"\",G3=\"\"),\"\",IF(G3<F3,G3+1-F3,G3-F3))","v":""},null,{"$f":"IF(E3=\"ferie\",$R$2/24,IF(OR(F3=\"\",G3=\"\"),\"\",H3-I3))","v":""},{"$f":"IFERROR(J3*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C3,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0},null,null,"Uge 1",{"$f":"M9-R1","v":-37}]
[null,{"$f":"WEEKDAY(C4)","v":"1900-01-01"},{"$f":"C3+1","v":"2018-12-02"},{"$f":"HelligdagsNavn(C4,0,0)","v":""},"ferie",null,null,{"$f":"IF(OR(F4=\"\",G4=\"\"),\"\",IF(G4<F4,G4+1-F4,G4-F4))","v":""},null,{"$f":"IF(E4=\"ferie\",$R$2/24,IF(OR(F4=\"\",G4=\"\"),\"\",H4-I4))","v":"07:24:00"},{"$f":"IFERROR(J4*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C4,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0},null,null,"Uge 2",{"$f":"M16-R1","v":-37},null,{"$f":"SUM(R3:R7)","v":-99.199999999999989}]
[null,"1900-01-02",{"$f":"C4+1","v":"2018-12-03"},"","afsp.",null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF(G5<F5,G5+1-F5,G5-F5))","v":""},null,"",{"$f":"IFERROR(J5*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C5,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 3",{"$f":"M23-R1","v":-37}]
[null,"1900-01-03","2018-12-04","",null,"07:00:00","15:00:00",{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF(G6<F6,G6+1-F6,G6-F6))","v":"08:00:00"},null,"08:00:00",{"$f":"IFERROR(J6*24,\"\")","v":8},null,null,{"$f":"CHOOSE(WEEKDAY(C6,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 4",{"$f":"M30-R1","v":-37}]
[null,"1900-01-04","2018-12-05","","ferie",null,null,{"$f":"IF(OR(F7=\"\",G7=\"\"),\"\",IF(G7<F7,G7+1-F7,G7-F7))","v":""},null,"07:24:00",{"$f":"IFERROR(J7*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C7,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 5",{"$f":"K38-R1","v":48.800000000000011}]
[null,"1900-01-05","2018-12-06","",null,null,null,null,null,"",null,null,null,{"$f":"CHOOSE(WEEKDAY(C8,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,null,null,null,{"$f":"K38-K39","v":-54.799999999999983}]
[null,"1900-01-06","2018-12-07","",null,null,null,null,null,"",null,null,null,{"$f":"CHOOSE(WEEKDAY(C9,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-12-08","",null,null,null,{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(G10<F10,G10+1-F10,G10-F10))","v":""},null,"",{"$f":"IFERROR(J10*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C10,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-12-09","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF(G11<F11,G11+1-F11,G11-F11))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J11*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C11,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-12-10","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",IF(G12<F12,G12+1-F12,G12-F12))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J12*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C12,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-12-11","",null,null,null,{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",IF(G13<F13,G13+1-F13,G13-F13))","v":""},null,"",{"$f":"IFERROR(J13*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C13,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-12-12","",null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",IF(G14<F14,G14+1-F14,G14-F14))","v":""},null,"",{"$f":"IFERROR(J14*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C14,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-12-13","",null,null,null,null,null,"",{"$f":"IFERROR(J15*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C15,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-12-14","",null,null,null,null,null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C16,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-12-15","",null,null,null,{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",IF(G17<F17,G17+1-F17,G17-F17))","v":""},null,"",{"$f":"IFERROR(J17*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C17,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-12-16","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF(G18<F18,G18+1-F18,G18-F18))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J18*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C18,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-12-17","",null,"07:00:00","23:00:00",{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF(G19<F19,G19+1-F19,G19-F19))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J19*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C19,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-12-18","",null,null,null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",IF(G20<F20,G20+1-F20,G20-F20))","v":""},null,"",{"$f":"IFERROR(J20*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C20,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-12-19","",null,null,null,{"$f":"IF(OR(F21=\"\",G21=\"\"),\"\",IF(G21<F21,G21+1-F21,G21-F21))","v":""},null,"",{"$f":"IFERROR(J21*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C21,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-12-20","",null,null,null,{"$f":"IF(OR(F22=\"\",G22=\"\"),\"\",IF(G22<F22,G22+1-F22,G22-F22))","v":""},null,"",{"$f":"IFERROR(J22*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C22,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-12-21","",null,null,null,"",null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C23,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-12-22","",null,null,null,{"$f":"IF(OR(F24=\"\",G24=\"\"),\"\",IF(G24<F24,G24+1-F24,G24-F24))","v":""},null,"",{"$f":"IFERROR(J24*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C24,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-12-23","",null,"20:00:00","01:00:00",{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",IF(G25<F25,G25+1-F25,G25-F25))","v":"05:00:00"},null,"05:00:00",{"$f":"IFERROR(J25*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C25,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-02","2018-12-24","Julaftensdag",null,"07:00:00","23:00:00",{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",IF(G26<F26,G26+1-F26,G26-F26))","v":"16:00:00"},null,"16:00:00",{"$f":"IFERROR(J26*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C26,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-12-25","1. Juledag",null,null,null,{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",IF(G27<F27,G27+1-F27,G27-F27))","v":""},null,"",{"$f":"IFERROR(J27*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C27,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-12-26","2. Juledag",null,null,null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",IF(G28<F28,G28+1-F28,G28-F28))","v":""},null,"",{"$f":"IFERROR(J28*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C28,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-12-27","",null,null,null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",IF(G29<F29,G29+1-F29,G29-F29))","v":""},null,"",{"$f":"IFERROR(J29*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C29,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-12-28","",null,null,null,"",null,"","",null,null,{"$f":"CHOOSE(WEEKDAY(C30,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,{"$f":"IFERROR(WEEKDAY(C31),\"\")","v":"1900-01-07"},{"$f":"IF(MONTH(C30+1)>MONTH(C30),\"\",C30+1)","v":"2018-12-29"},"",null,null,null,{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",IF(G31<F31,G31+1-F31,G31-F31))","v":""},null,"",{"$f":"IFERROR(J31*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C31,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":0}]
[null,{"$f":"IFERROR(WEEKDAY(C32),\"\")","v":"1900-01-01"},{"$f":"IFERROR(IF(MONTH(C31+1)>MONTH(C31),\"\",C31+1),\"\")","v":"2018-12-30"},"",null,null,null,{"$f":"IF(OR(F32=\"\",G32=\"\"),\"\",IF(G32<F32,G32+1-F32,G32-F32))","v":""},null,"",{"$f":"IFERROR(J32*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C32,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":0}]
[null,"1900-01-02",{"$f":"IFERROR(IF(MONTH(C32+1)>MONTH(C32),\"\",C32+1),\"\")","v":"2018-12-31"},null,null,null,null,{"$f":"IF(OR(F33=\"\",G33=\"\"),\"\",IF(G33<F33,G33+1-F33,G33-F33))","v":""},null,"",{"$f":"IFERROR(J33*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C33,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":7.4}]
[null,null,{"$f":"IFERROR(IF(OR(YEAR(C33+1)>YEAR(C33),MONTH(C33+1)>MONTH(C33)),\"\",C33+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F34=\"\",G34=\"\"),\"\",IF(G34<F34,G34+1-F34,G34-F34))","v":""},null,"",{"$f":"IFERROR(J34*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C34,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,{"$f":"IFERROR(IF(OR(YEAR(C34+1)>YEAR(C34),MONTH(C34+1)>MONTH(C34)),\"\",C34+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F35=\"\",G35=\"\"),\"\",IF(G35<F35,G35+1-F35,G35-F35))","v":""},null,"",{"$f":"IFERROR(J35*24,\"\")","v":""},null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C35,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,"",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C36,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,"",null,null,null,null,null,null,"",null,null,null,{"$f":"IFERROR(CHOOSE(WEEKDAY(C37,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,null,null,null,null,null,"Total timer",null,{"$f":"SUM(J3:J33)","v":3.5750000000000002},{"$f":"J38*24","v":85.800000000000011}]
[null,null,{"$f":"NETWORKDAYS(C3,C33,helligdage!B2:B12)","v":19},null,"arbejdsdage",null,null,null,"Måneds norm",null,{"$f":"C39*R2","v":140.6}]
[null,null,null,null,null,null,null,null,"Månedens flekstid",null,{"$f":"K38-K39","v":-54.799999999999983}]

{"sheet":"Januar (2)","index":5,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[30,0,36,0],[0,11,0,12],[2,0,8,0],[9,0,15,0],[16,0,22,0],[23,0,29,0]]}
[null,null,null,null,null,null,null,null,null,null,null,"Total timer uge",null,"Kun for\ntest",null,null,"uge norm",37]
[null,"Dag","Dato",null,"Tekst","Komme","Gå","Dagens\ntid","Pause","Effektiv\narbejdstid",null,"TT:MM","1/100","norm",null,null,"dags norm",7.4,null,"Flex konto"]
["Uge 1",{"$f":"WEEKDAY(C3)","v":"1900-01-02"},"2018-01-01",null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F3=\"\",G3=\"\"),\"\",IF(G3<F3,G3+1-F3,G3-F3))","v":"08:30:00"},"00:31:00",{"$f":"IF(E3=\"ferie\",N3/24,IF(OR(F3=\"\",G3=\"\"),\"\",H3-I3))","v":"07:59:00"},{"$f":"IFERROR(J3*24,\"\")","v":7.9833333333333343},null,null,{"$f":"CHOOSE(WEEKDAY(C3,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 1",{"$f":"M9-R1","v":-6.2166666666666686}]
[null,{"$f":"WEEKDAY(C4)","v":"1900-01-03"},{"$f":"C3+1","v":"2018-01-02"},null,"ferie",null,null,{"$f":"IF(OR(F4=\"\",G4=\"\"),\"\",IF(G4<F4,G4+1-F4,G4-F4))","v":""},null,"07:24:00",{"$f":"IFERROR(J4*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C4,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 2",{"$f":"M16-R1","v":-8.0166666666666657},null,{"$f":"SUM(R3:R7)","v":-38.283333333333331}]
[null,"1900-01-04",{"$f":"C4+1","v":"2018-01-03"},null,"afsp.",null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF(G5<F5,G5+1-F5,G5-F5))","v":""},null,"",{"$f":"IFERROR(J5*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C5,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 3",{"$f":"M23-R1","v":-8.0166666666666657}]
[null,"1900-01-05","2018-01-04",null,null,"07:00:00","15:00:00",{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF(G6<F6,G6+1-F6,G6-F6))","v":"08:00:00"},null,"08:00:00",{"$f":"IFERROR(J6*24,\"\")","v":8},null,null,{"$f":"CHOOSE(WEEKDAY(C6,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 4",{"$f":"M30-R1","v":-8.0166666666666657}]
[null,"1900-01-06","2018-01-05",null,"ferie",null,null,{"$f":"IF(OR(F7=\"\",G7=\"\"),\"\",IF(G7<F7,G7+1-F7,G7-F7))","v":""},null,{"$f":"IF(E7=\"ferie\",N7/24,IF(OR(F7=\"\",G7=\"\"),\"\",H7-I7))","v":"07:24:00"},{"$f":"IFERROR(J7*24,\"\")","v":7.4},null,null,{"$f":"CHOOSE(WEEKDAY(C7,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,"Uge 5",{"$f":"M37-R1","v":-8.0166666666666657}]
[null,"1900-01-07","2018-01-06",null,null,null,null,null,null,{"$f":"IF(E8=\"ferie\",N8/24,IF(OR(F8=\"\",G8=\"\"),\"\",H8-I8))","v":""},null,null,null,{"$f":"CHOOSE(WEEKDAY(C8,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-01-07",null,null,null,null,null,null,"",null,{"$f":"SUM(J3:J7)","v":1.2826388888888889},{"$f":"L9*24","v":30.783333333333331},{"$f":"CHOOSE(WEEKDAY(C9,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
["Uge 2","1900-01-02","2018-01-08",null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(G10<F10,G10+1-F10,G10-F10))","v":"08:30:00"},"00:31:00",{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",H10-I10)","v":"07:59:00"},{"$f":"IFERROR(J10*24,\"\")","v":7.9833333333333343},null,null,{"$f":"CHOOSE(WEEKDAY(C10,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4},null,null,null,{"$f":"M38-M39","v":-16.083333333333343}]
[null,"1900-01-03","2018-01-09",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF(G11<F11,G11+1-F11,G11-F11))","v":"05:00:00"},null,{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",H11-I11)","v":"05:00:00"},{"$f":"IFERROR(J11*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C11,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-01-10",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",IF(G12<F12,G12+1-F12,G12-F12))","v":"16:00:00"},null,{"$f":"IF(OR(F12=\"\",G12=\"\"),\"\",H12-I12)","v":"16:00:00"},{"$f":"IFERROR(J12*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C12,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-01-11",null,null,null,null,{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",IF(G13<F13,G13+1-F13,G13-F13))","v":""},null,{"$f":"IF(OR(F13=\"\",G13=\"\"),\"\",H13-I13)","v":""},{"$f":"IFERROR(J13*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C13,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-01-12",null,null,null,null,{"$f":"IF(OR(F14=\"\",G14=\"\"),\"\",IF(G14<F14,G14+1-F14,G14-F14))","v":""},null,"",{"$f":"IFERROR(J14*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C14,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-01-13",null,null,null,null,null,null,"",{"$f":"IFERROR(J15*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C15,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-01-14",null,null,null,null,null,null,"","",{"$f":"SUM(J10:J14)","v":1.2076388888888889},{"$f":"L16*24","v":28.983333333333334},{"$f":"CHOOSE(WEEKDAY(C16,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
["Uge 3","1900-01-02","2018-01-15",null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",IF(G17<F17,G17+1-F17,G17-F17))","v":"08:30:00"},"00:31:00",{"$f":"IF(OR(F17=\"\",G17=\"\"),\"\",H17-I17)","v":"07:59:00"},{"$f":"IFERROR(J17*24,\"\")","v":7.9833333333333343},null,null,{"$f":"CHOOSE(WEEKDAY(C17,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-01-16",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",IF(G18<F18,G18+1-F18,G18-F18))","v":"05:00:00"},null,{"$f":"IF(OR(F18=\"\",G18=\"\"),\"\",H18-I18)","v":"05:00:00"},{"$f":"IFERROR(J18*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C18,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-01-17",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",IF(G19<F19,G19+1-F19,G19-F19))","v":"16:00:00"},null,{"$f":"IF(OR(F19=\"\",G19=\"\"),\"\",H19-I19)","v":"16:00:00"},{"$f":"IFERROR(J19*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C19,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-01-18",null,null,null,null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",IF(G20<F20,G20+1-F20,G20-F20))","v":""},null,{"$f":"IF(OR(F20=\"\",G20=\"\"),\"\",H20-I20)","v":""},{"$f":"IFERROR(J20*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C20,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-01-19",null,null,null,null,{"$f":"IF(OR(F21=\"\",G21=\"\"),\"\",IF(G21<F21,G21+1-F21,G21-F21))","v":""},null,"",{"$f":"IFERROR(J21*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C21,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-01-20",null,null,null,null,{"$f":"IF(OR(F22=\"\",G22=\"\"),\"\",IF(G22<F22,G22+1-F22,G22-F22))","v":""},null,"",{"$f":"IFERROR(J22*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C22,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-01-21",null,null,null,null,"",null,"","",{"$f":"SUM(J17:J21)","v":1.2076388888888889},{"$f":"L23*24","v":28.983333333333334},{"$f":"CHOOSE(WEEKDAY(C23,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
["Uge 4","1900-01-02","2018-01-22",null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F24=\"\",G24=\"\"),\"\",IF(G24<F24,G24+1-F24,G24-F24))","v":"08:30:00"},"00:31:00",{"$f":"IF(OR(F24=\"\",G24=\"\"),\"\",H24-I24)","v":"07:59:00"},{"$f":"IFERROR(J24*24,\"\")","v":7.9833333333333343},null,null,{"$f":"CHOOSE(WEEKDAY(C24,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-01-23",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",IF(G25<F25,G25+1-F25,G25-F25))","v":"05:00:00"},null,{"$f":"IF(OR(F25=\"\",G25=\"\"),\"\",H25-I25)","v":"05:00:00"},{"$f":"IFERROR(J25*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C25,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-01-24",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",IF(G26<F26,G26+1-F26,G26-F26))","v":"16:00:00"},null,{"$f":"IF(OR(F26=\"\",G26=\"\"),\"\",H26-I26)","v":"16:00:00"},{"$f":"IFERROR(J26*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C26,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-05","2018-01-25",null,null,null,null,{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",IF(G27<F27,G27+1-F27,G27-F27))","v":""},null,{"$f":"IF(OR(F27=\"\",G27=\"\"),\"\",H27-I27)","v":""},{"$f":"IFERROR(J27*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C27,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-06","2018-01-26",null,null,null,null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",IF(G28<F28,G28+1-F28,G28-F28))","v":""},null,{"$f":"IF(OR(F28=\"\",G28=\"\"),\"\",H28-I28)","v":""},{"$f":"IFERROR(J28*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C28,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-07","2018-01-27",null,null,null,null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",IF(G29<F29,G29+1-F29,G29-F29))","v":""},null,{"$f":"IF(OR(F29=\"\",G29=\"\"),\"\",H29-I29)","v":""},{"$f":"IFERROR(J29*24,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(C29,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
[null,"1900-01-01","2018-01-28",null,null,null,null,"",null,"","",{"$f":"SUM(J24:J28)","v":1.2076388888888889},{"$f":"L30*24","v":28.983333333333334},{"$f":"CHOOSE(WEEKDAY(C30,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":0}]
["Uge 5","1900-01-02",{"$f":"IF(MONTH(C30+1)>MONTH(C30),\"\",C30+1)","v":"2018-01-29"},null,null,"07:00:00","15:30:00",{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",IF(G31<F31,G31+1-F31,G31-F31))","v":"08:30:00"},"00:31:00",{"$f":"IF(OR(F31=\"\",G31=\"\"),\"\",H31-I31)","v":"07:59:00"},{"$f":"IFERROR(J31*24,\"\")","v":7.9833333333333343},null,null,{"$f":"CHOOSE(WEEKDAY(C31,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-03","2018-01-30",null,null,"20:00:00","01:00:00",{"$f":"IF(OR(F32=\"\",G32=\"\"),\"\",IF(G32<F32,G32+1-F32,G32-F32))","v":"05:00:00"},null,{"$f":"IF(OR(F32=\"\",G32=\"\"),\"\",H32-I32)","v":"05:00:00"},{"$f":"IFERROR(J32*24,\"\")","v":5.0000000000000009},null,null,{"$f":"CHOOSE(WEEKDAY(C32,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,"1900-01-04","2018-01-31",null,null,"07:00:00","23:00:00",{"$f":"IF(OR(F33=\"\",G33=\"\"),\"\",IF(G33<F33,G33+1-F33,G33-F33))","v":"16:00:00"},null,{"$f":"IF(OR(F33=\"\",G33=\"\"),\"\",H33-I33)","v":"16:00:00"},{"$f":"IFERROR(J33*24,\"\")","v":16},null,null,{"$f":"CHOOSE(WEEKDAY(C33,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7)","v":7.4}]
[null,{"$f":"IFERROR(WEEKDAY(C34),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(C33+1)>MONTH(C33),\"\",C33+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F34=\"\",G34=\"\"),\"\",IF(G34<F34,G34+1-F34,G34-F34))","v":""},null,{"$f":"IF(OR(F34=\"\",G34=\"\"),\"\",H34-I34)","v":""},{"$f":"IFERROR(J34*24,\"\")","v":""},null,null,{"$f":"IF(C34<>\"\",CHOOSE(WEEKDAY(C34,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,{"$f":"IFERROR(WEEKDAY(C35),\"\")","v":""},{"$f":"IFERROR(IF(MONTH(C34+1)>MONTH(C34),\"\",C34+1),\"\")","v":""},null,null,null,null,{"$f":"IF(OR(F35=\"\",G35=\"\"),\"\",IF(G35<F35,G35+1-F35,G35-F35))","v":""},null,"",{"$f":"IFERROR(J35*24,\"\")","v":""},null,null,{"$f":"IF(C35<>\"\",CHOOSE(WEEKDAY(C35,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,null,null,{"$f":"IF(C36<>\"\",CHOOSE(WEEKDAY(C36,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,"","",null,null,null,null,null,null,"",null,{"$f":"SUM(J31:J35)","v":1.2076388888888889},{"$f":"L37*24","v":28.983333333333334},{"$f":"IF(C37<>\"\",CHOOSE(WEEKDAY(C37,2),norm!B$1,norm!B$2,norm!B$3,norm!B$4,norm!B$5,norm!B$6,norm!B$7),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M9:M37)","v":146.71666666666667}]
[null,null,{"$f":"NETWORKDAYS(C3,C33,C3)","v":22},null,null,null,null,null,null,null,null,null,{"$f":"C39*7.4","v":162.80000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N3:N39)","v":170.20000000000007}]

{"sheet":"T.","index":6,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"IF(C2=365,28,29)","v":28}]
["Salt og snerydning",null,{"$f":"364+DATE($C$3,3,1)-DATE($C$3,2,28)","v":365}]
[null,null,{"$f":"YEAR(Februar!C3)","v":2018}]
["Arrangementer","afsp."]
["Høstfest","ferie"]
["Dimissionsfest","syg"]
["juleklip"]

{"sheet":"norm","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["mandag",7.4]
["tirsdag",7.4]
["onsdag",7.4]
["torsdag",7.4]
["fredag",7.4]
["lørdag",0]
["søndag",0]
[]
["Uge Norm",1.5416666666666667]
[]
["Dags norm",7.4]

{"sheet":"helligdage","index":8,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Årstal",{"$f":"YEAR(Januar!C4)","v":2018},"Type",null,null,null,"X","Årstal",{"$f":"B1","v":2018}]
["Nytårsdag",{"$f":"DATE(B1,1,1)","v":"2018-01-01"},"Fast",null,null,null,"A","Rest",{"$f":"MOD(I1,19)","v":4}]
["Skærtorsdag",{"$f":"B5-3","v":"2018-03-29"},"Beregnet",null,null,null,"B","Heltal",{"$f":"INT(I1/100)","v":20}]
["Langfredag",{"$f":"B5-2","v":"2018-03-30"},"Beregnet",null,null,null,"C","Rest",{"$f":"MOD(I1,100)","v":18},{"$f":"MOD(I1,100)","v":18}]
["Påskedag",{"$f":"FLOOR(DAY(MINUTE(B1/38)/2+56)&\"/5/\"&B1,7)-34","v":"2018-04-01"},"Beregnet",null,null,null,"D","Heltal",{"$f":"INT(I3/4)","v":5}]
["2. påskedag",{"$f":"$B$5+1","v":"2018-04-02"},"Beregnet",null,null,null,"E","Rest",{"$f":"MOD(I3,4)","v":0}]
["Store Bededag",{"$f":"$B$5+26","v":"2018-04-27"},"Beregnet",null,null,null,"F","Heltal",{"$f":"INT((I3+8)/25)","v":1}]
["Kristi Himmelfart",{"$f":"$B$5+39","v":"2018-05-10"},"Beregnet",null,null,null,"G","Heltal",{"$f":"INT((I3-I7+1)/3)","v":6}]
["Pinsedag",{"$f":"$B$5+49","v":"2018-05-20"},"Beregnet",null,null,null,"H","Heltal",{"$f":"MOD(19*I2+I3-I5-I8+15,30)","v":10}]
["2. pinsedag",{"$f":"$B$5+50","v":"2018-05-21"},"Beregnet",null,null,null,"J","Heltal",{"$f":"INT(I4/4)","v":4}]
["1. juledag",{"$f":"DATE(B1,12,25)","v":"2018-12-25"},"Fast",null,null,null,"K","Rest",{"$f":"MOD(I4,4)","v":2}]
["2. juledag",{"$f":"DATE(B1,12,26)","v":"2018-12-26"},"Fast",null,null,null,"L","Rest",{"$f":"MOD(32+2*I6+2*I10-I9-I11,7)","v":0}]
[null,null,null,null,null,null,"M","Heltal",{"$f":"INT((I2+11*I9+22*I12)/451)","v":0}]
[null,null,null,null,null,null,"N","Heltal",{"$f":"INT((I9+I12-7*I13+114)/31)","v":4}]
["Nytårsaftens dag",{"$f":"DATE(B1,12,31)","v":"2018-12-31"},"Fast",null,null,null,"P","Rest",{"$f":"MOD(I9+I12-7*I13+114,31)","v":0}]
[null,null,null,null,null,null,"Q","Formel",{"$f":"(I14-3)*31+I15-20","v":11}]
[]
[null,null,null,null,null,null,null,"Dag",{"$f":"I15+1","v":1}]
[null,null,null,null,null,null,null,"Måned",{"$f":"I14","v":4}]
[]
[null,null,null,null,null,null,null,null,null,"Mellemregning",null,"Diff ift Påskesøndag"]
[null,{"$f":"på","v":{"$error":"#NAME?"}},null,null,null,null,null,"Skærtorsdag",null,{"$f":"J24-3","v":"2018-03-29"},{"$f":"K24-3","v":"2018-03-29"},-3]
[null,null,null,null,null,null,null,"Langfredag",null,{"$f":"J24-2","v":"2018-03-30"},{"$f":"K24-2","v":"2018-03-30"},-2]
[null,null,null,null,null,null,null,"Påskedag",null,{"$f":"DATE(I1,I19,I18)","v":"2018-04-01"},{"$f":"DATE(I1,I19,I18)","v":"2018-04-01"}]
[null,null,null,null,null,null,null,"2. påskedag",null,{"$f":"J24+1","v":"2018-04-02"},{"$f":"K24+1","v":"2018-04-02"},1]
[null,null,null,null,null,null,null,"1. s.e. påske",null,{"$f":"J24+7","v":"2018-04-08"}]
[null,null,null,null,null,null,null,"2. s.e. påske",null,{"$f":"J26+7","v":"2018-04-15"}]
[null,null,null,null,null,null,null,"3. s.e. påske",null,{"$f":"J27+7","v":"2018-04-22"}]
[null,null,null,null,null,null,null,"Store Bededag",null,{"$f":"J28+5","v":"2018-04-27"},{"$f":"K24+26","v":"2018-04-27"},26]
[null,null,null,null,null,null,null,"4. s.e. påske",null,{"$f":"J28+7","v":"2018-04-29"}]
[null,null,null,null,null,null,null,"5. s.e. påske",null,{"$f":"J30+7","v":"2018-05-06"}]
[null,null,null,null,null,null,null,"Kristi Himmelfart",null,{"$f":"J31+4","v":"2018-05-10"},{"$f":"K24+39","v":"2018-05-10"},39]
[null,null,null,null,null,null,null,"6.s.e. påske",null,{"$f":"J31+7","v":"2018-05-13"}]
[null,null,null,null,null,null,null,"Pinsedag",null,{"$f":"J33+7","v":"2018-05-20"},{"$f":"K24+49","v":"2018-05-20"},49]
[null,null,null,null,null,null,null,"2. pinsedag",null,{"$f":"J34+1","v":"2018-05-21"},{"$f":"K24+50","v":"2018-05-21"},50]