{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Nov","Data"],"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":"Nov","index":0,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[[37,18,37,19],[41,15,41,17],[40,10,40,12],[40,15,40,17],[42,10,42,12],[42,15,42,17],[40,13,40,14],[41,13,41,14],[38,15,38,17],[39,15,39,17],[42,3,42,7],[41,3,41,7],[3,4,3,5],[3,6,3,7],[1,10,1,11],[41,10,41,12],[35,4,35,5],[40,3,40,7],[42,8,42,9],[39,10,39,12],[1,12,1,13],[39,3,39,7],[1,16,1,17],[37,15,37,17],[37,10,37,12],[37,3,37,7],[38,3,38,7],[38,10,38,12],[1,3,1,9]]}
[null,null,null,"Månedsrapport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indtast mdr 1-12"]
[null,null,"Navn: ",null,null,null,null,null,null,null,"Måned: ",null,{"$f":"CHOOSE(V2,\"Jan-Feb\",\"Feb-Mar\",\"Mar-Apr\",\"Apr-Maj\",\"Maj-Jun\",\"Jun-Jul\",\"Jul-Aug\",\"Aug-Sep\",\"Sep_Okt\",\"Okt-Nov\",\"Nov-Dec\",\"Dec-Jan\")","v":"Jan-Feb"},null,null,"År :",2021,null,null,null,null,1]
[]
["Vagttype","Uge","Dag","Dato","Planl.\nMøde tid\nFra - Til",null,"Faktisk\nMøde\nTid.\nFra-Til",null,"Udf.\nTim.\nDag","Udf.\nTim.\nA/N","Afsp.\nTim.","Ku.\nTim.","Till.\nA/N","Till\nWeek-\nEnd","Extra\nTim.","Timer\n50%\nTillæg","Timer\n100%\nTillæg","Syg /\nBarn\nS/\nBarsel","Ferie\nTimer","Ferie\nFri\nTimer"]
[1,{"$f":"_xlfn.ISOWEEKNUM(D5)","v":2},{"$f":"CHOOSE(WEEKDAY(D5,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"Lør"},{"$f":"DATE(Q2,V2,16)","v":"2017-01-15"},{"$f":"IF(A5<>\"\",VLOOKUP(A5,Data!$N$3:$O$5,2,0),\"\")","v":"07:45:00"},{"$f":"IF(A5<>\"\",VLOOKUP(A5,Data!$P$3:$Q$5,2,0),\"\")","v":"16:00:00"},{"$f":"+E5","v":"07:45:00"},{"$f":"+F5","v":"16:00:00"},{"$f":"IF(F5=E5,\" \",IF(E5=\"\",0,(+F5-E5)*24))","v":8.2499999999999982},null,{"$f":"IF(OR(G5=\"\",H5=\"\"),\"\",IF(((V5-I5)*-1)<=0.2,\"\", IF((V5-I5)*-1<0,\"\",(V5-I5)*-1)))","v":""},null,{"$f":"IF(OR(G5=\"\",H5=\"\"),\"\",IF(H5<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G5,H5)*24))","v":""},null,null,{"$f":"IF(OR(G5=\"\",H5=\"\"),\"\",IF((V5-I5)<=0.25,\"\",IF(V5-I5<0,\"\",V5-I5)))","v":""},{"$f":"IF(OR(G5=\"\",H5=\"\"),\"\",IF((V5-I5)<=0.25,\"\",IF(V5-I5<0,\"\",V5-I5)))","v":""},null,null,null,null,{"$f":"IF(G5=F5,\" \",IF(G5=\"\",0,(+H5-G5)*24))","v":8.2499999999999982}]
[2,{"$f":"IF(WEEKDAY(D6,11)=1,_xlfn.ISOWEEKNUM(D6),\"\")","v":""},{"$f":"CHOOSE(WEEKDAY(D6,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"søn"},{"$f":"D5+1","v":"2017-01-16"},{"$f":"IF(A6<>\"\",VLOOKUP(A6,Data!$N$3:$O$5,2,0),\"\")","v":"07:45:00"},{"$f":"IF(A6<>\"\",VLOOKUP(A6,Data!$P$3:$Q$5,2,0),\"\")","v":"18:00:00"},{"$f":"+E6","v":"07:45:00"},{"$f":"+F6","v":"18:00:00"},{"$f":"IF(F6=E6,\" \",IF(E6=\"\",0,(+F6-E6)*24))","v":10.25},null,"",null,{"$f":"IF(OR(G6=\"\",H6=\"\"),\"\",IF(H6<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G6,H6)*24))","v":0.99999999999999911},null,null,{"$f":"IF(OR(G6=\"\",H6=\"\"),\"\",IF((V6-I6)<=0.25,\"\",IF(V6-I6<0,\"\",V6-I6)))","v":""},{"$f":"IF(OR(G6=\"\",H6=\"\"),\"\",IF((V6-I6)<=0.25,\"\",IF(V6-I6<0,\"\",V6-I6)))","v":""},null,null,null,null,{"$f":"IF(G6=F6,\" \",IF(G6=\"\",0,(+H6-G6)*24))","v":10.25}]
[3,{"$f":"IF(WEEKDAY(D7,11)=1,_xlfn.ISOWEEKNUM(D7),\"\")","v":3},{"$f":"CHOOSE(WEEKDAY(D7,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"man"},{"$f":"D6+1","v":"2017-01-17"},{"$f":"IF(A7<>\"\",VLOOKUP(A7,Data!$N$3:$O$5,2,0),\"\")","v":"07:45:00"},{"$f":"IF(A7<>\"\",VLOOKUP(A7,Data!$P$3:$Q$5,2,0),\"\")","v":"20:00:00"},"07:45:00","20:00:00",12.250000000000002,null,"",null,{"$f":"IF(OR(G7=\"\",H7=\"\"),\"\",IF(H7<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G7,H7)*24))","v":3},null,null,"","",null,null,null,null,12.250000000000002]
[null,"",{"$f":"CHOOSE(WEEKDAY(D8,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"Tirs"},"2017-01-18",{"$f":"IF(A8<>\"\",VLOOKUP(A8,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A8<>\"\",VLOOKUP(A8,Data!$P$3:$Q$5,2,0),\"\")","v":""},"12:00:00","16:00:00"," ",null,{"$f":"IF(OR(G8=\"\",H8=\"\"),\"\",IF(B8=\"\",V8,IF(((V8-I8)*-1)<=0.2,\"\", IF((V8-I8)*-1<0,\"\",(V8-I8)*-1))))","v":0.16666666666666663},null,{"$f":"IF(OR(G8=\"\",H8=\"\"),\"\",IF(H8<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G8,H8)*24))","v":""},null,null,{"$f":"IF(OR(G8=\"\",H8=\"\"),\"\",IF(A8=\"\",IF(V8>Data!U3,Data!U3,IF(Nov!V8<Data!U3,Nov!V8,IF((V8-I8)<=0.25,\"\",IF(V8-I8<0,\"\",V8-I8))))))","v":0.125},{"$f":"IF(OR(G8=\"\",H8=\"\"),\"\",IF(AND(A8=\"\",V8>Data!U3),Nov!V8-Data!U3,IF((V8-I8)<=0.25,\"\",IF(V8-I8<0,\"\",V8-I8))))","v":4.166666666666663E-2},null,null,null,null,{"$f":"IF(G8=F8,\" \",IF(G8=\"\",0,(+H8-G8)))","v":0.16666666666666663}]
[null,"","Ons","2017-01-19",{"$f":"IF(A9<>\"\",VLOOKUP(A9,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A9<>\"\",VLOOKUP(A9,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G9=\"\",H9=\"\"),\"\",IF(H9<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G9,H9)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Tors","2017-01-20",{"$f":"IF(A10<>\"\",VLOOKUP(A10,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A10<>\"\",VLOOKUP(A10,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G10=\"\",H10=\"\"),\"\",IF(H10<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G10,H10)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","FRE","2017-01-21",{"$f":"IF(A11<>\"\",VLOOKUP(A11,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A11<>\"\",VLOOKUP(A11,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G11=\"\",H11=\"\"),\"\",IF(H11<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G11,H11)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Lør","2017-01-22",{"$f":"IF(A12<>\"\",VLOOKUP(A12,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A12<>\"\",VLOOKUP(A12,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G12=\"\",H12=\"\"),\"\",IF(H12<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G12,H12)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","søn","2017-01-23",{"$f":"IF(A13<>\"\",VLOOKUP(A13,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A13<>\"\",VLOOKUP(A13,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G13=\"\",H13=\"\"),\"\",IF(H13<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G13,H13)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,4,"man","2017-01-24",{"$f":"IF(A14<>\"\",VLOOKUP(A14,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A14<>\"\",VLOOKUP(A14,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G14=\"\",H14=\"\"),\"\",IF(H14<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G14,H14)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Tirs","2017-01-25",{"$f":"IF(A15<>\"\",VLOOKUP(A15,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A15<>\"\",VLOOKUP(A15,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G15=\"\",H15=\"\"),\"\",IF(H15<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G15,H15)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Ons","2017-01-26",{"$f":"IF(A16<>\"\",VLOOKUP(A16,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A16<>\"\",VLOOKUP(A16,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,{"$f":"IF(OR(G16=\"\",H16=\"\"),\"\",IF(((V16-I16)*-1)<=0.2,\"\", IF((V16-I16)*-1<0,\"\",(V16-I16)*-1)))","v":""},null,{"$f":"IF(OR(G16=\"\",H16=\"\"),\"\",IF(H16<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G16,H16)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Tors","2017-01-27",{"$f":"IF(A17<>\"\",VLOOKUP(A17,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A17<>\"\",VLOOKUP(A17,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,{"$f":"IF(OR(G17=\"\",H17=\"\"),\"\",IF(((V17-I17)*-1)<=0.2,\"\", IF((V17-I17)*-1<0,\"\",(V17-I17)*-1)))","v":""},null,{"$f":"IF(OR(G17=\"\",H17=\"\"),\"\",IF(H17<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G17,H17)*24))","v":""},null,null,{"$f":"IF(OR(G17=\"\",H17=\"\"),\"\",IF((V17-I17)<=0.25,\"\",IF(V17-I17<0,\"\",V17-I17)))","v":""},{"$f":"IF(OR(G17=\"\",H17=\"\"),\"\",IF((V17-I17)<=0.25,\"\",IF(V17-I17<0,\"\",V17-I17)))","v":""},null,null,null,null," "]
[null,"","FRE","2017-01-28",{"$f":"IF(A18<>\"\",VLOOKUP(A18,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A18<>\"\",VLOOKUP(A18,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G18=\"\",H18=\"\"),\"\",IF(H18<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G18,H18)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Lør","2017-01-29",{"$f":"IF(A19<>\"\",VLOOKUP(A19,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A19<>\"\",VLOOKUP(A19,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G19=\"\",H19=\"\"),\"\",IF(H19<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G19,H19)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","søn","2017-01-30",{"$f":"IF(A20<>\"\",VLOOKUP(A20,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A20<>\"\",VLOOKUP(A20,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G20=\"\",H20=\"\"),\"\",IF(H20<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G20,H20)*24))","v":""},null,null,{"$f":"IF(OR(G20=\"\",H20=\"\"),\"\",IF((V20-I20)<=0.25,\"\",IF(V20-I20<0,\"\",V20-I20)))","v":""},{"$f":"IF(OR(G20=\"\",H20=\"\"),\"\",IF((V20-I20)<=0.25,\"\",IF(V20-I20<0,\"\",V20-I20)))","v":""},null,null,null,null," "]
[null,5,"man","2017-01-31",{"$f":"IF(A21<>\"\",VLOOKUP(A21,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A21<>\"\",VLOOKUP(A21,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G21=\"\",H21=\"\"),\"\",IF(H21<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G21,H21)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Tirs","2017-02-01",{"$f":"IF(A22<>\"\",VLOOKUP(A22,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A22<>\"\",VLOOKUP(A22,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G22=\"\",H22=\"\"),\"\",IF(H22<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G22,H22)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Ons","2017-02-02",{"$f":"IF(A23<>\"\",VLOOKUP(A23,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A23<>\"\",VLOOKUP(A23,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G23=\"\",H23=\"\"),\"\",IF(H23<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G23,H23)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Tors","2017-02-03",{"$f":"IF(A24<>\"\",VLOOKUP(A24,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A24<>\"\",VLOOKUP(A24,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G24=\"\",H24=\"\"),\"\",IF(H24<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G24,H24)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","FRE","2017-02-04",{"$f":"IF(A25<>\"\",VLOOKUP(A25,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A25<>\"\",VLOOKUP(A25,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G25=\"\",H25=\"\"),\"\",IF(H25<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G25,H25)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Lør","2017-02-05",{"$f":"IF(A26<>\"\",VLOOKUP(A26,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A26<>\"\",VLOOKUP(A26,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G26=\"\",H26=\"\"),\"\",IF(H26<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G26,H26)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","søn","2017-02-06",{"$f":"IF(A27<>\"\",VLOOKUP(A27,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A27<>\"\",VLOOKUP(A27,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G27=\"\",H27=\"\"),\"\",IF(H27<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G27,H27)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,6,"man","2017-02-07",{"$f":"IF(A28<>\"\",VLOOKUP(A28,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A28<>\"\",VLOOKUP(A28,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G28=\"\",H28=\"\"),\"\",IF(H28<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G28,H28)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Tirs","2017-02-08",{"$f":"IF(A29<>\"\",VLOOKUP(A29,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A29<>\"\",VLOOKUP(A29,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G29=\"\",H29=\"\"),\"\",IF(H29<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G29,H29)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Ons","2017-02-09",{"$f":"IF(A30<>\"\",VLOOKUP(A30,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A30<>\"\",VLOOKUP(A30,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G30=\"\",H30=\"\"),\"\",IF(H30<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G30,H30)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","Tors","2017-02-10",{"$f":"IF(A31<>\"\",VLOOKUP(A31,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A31<>\"\",VLOOKUP(A31,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G31=\"\",H31=\"\"),\"\",IF(H31<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G31,H31)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,"","FRE","2017-02-11",{"$f":"IF(A32<>\"\",VLOOKUP(A32,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A32<>\"\",VLOOKUP(A32,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G32=\"\",H32=\"\"),\"\",IF(H32<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G32,H32)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,{"$f":"IFERROR(IF(WEEKDAY(D33,11)=1,_xlfn.ISOWEEKNUM(D33),\"\"),\"\")","v":""},{"$f":"IFERROR(CHOOSE(WEEKDAY(D33,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\"),\"\")","v":"Lør"},{"$f":"IF(DAY(D32+1)>15,\"\",D32+1)","v":"2017-02-12"},{"$f":"IF(A33<>\"\",VLOOKUP(A33,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A33<>\"\",VLOOKUP(A33,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G33=\"\",H33=\"\"),\"\",IF(H33<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G33,H33)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,{"$f":"IFERROR(IF(WEEKDAY(D34,11)=1,_xlfn.ISOWEEKNUM(D34),\"\"),\"\")","v":""},{"$f":"IFERROR(CHOOSE(WEEKDAY(D34,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\"),\"\")","v":"søn"},{"$f":"IFERROR(D33+1,\"\")","v":"2017-02-13"},{"$f":"IF(A34<>\"\",VLOOKUP(A34,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A34<>\"\",VLOOKUP(A34,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G34=\"\",H34=\"\"),\"\",IF(H34<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G34,H34)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,7,"man",{"$f":"IFERROR(IF(DAY(D34+1)>15,\"\",D34+1),\"\")","v":"2017-02-14"},{"$f":"IF(A35<>\"\",VLOOKUP(A35,Data!$N$3:$O$5,2,0),\"\")","v":""},{"$f":"IF(A35<>\"\",VLOOKUP(A35,Data!$P$3:$Q$5,2,0),\"\")","v":""},"",""," ",null,"",null,{"$f":"IF(OR(G35=\"\",H35=\"\"),\"\",IF(H35<=Data!$H$3,\"\",ColTime(Data!$H$3,Data!$H$4,G35,H35)*24))","v":""},null,null,"","",null,null,null,null," "]
[null,null,null,null,"SUM AF\nTim./till.:",null,null,null,{"$f":"SUM(I5:I35)","v":30.75},null,{"$f":"SUM(K5:K35)","v":0.16666666666666663},null,{"$f":"SUM(M5:M35)","v":3.9999999999999991},null,null,{"$f":"SUM(P5:P35)","v":0.125},{"$f":"SUM(Q5:Q35)","v":4.166666666666663E-2}]
[]
[null,null,null,"+/- Norm time overført fra \nsidste periode:",null,null,null,null,null,null,"+/- Norm time i\nperiode:",null,null,null,null,"+/- Norm time til\noverførsel næste periode:",null,null,{"$f":"I36-151.66","v":-120.91}]
[null,null,null,"+/- Afsp time overført fra \nsidste periode:",null,null,null,null,null,null,"Afsp. time i\nperiode:",null,null,null,null,"+/- Afsp. Time i alt til overførsel:\n+/- afsp. tim.+ekstra tim.+OA tim."]
[null,null,null,"Kursus time i periode:",null,null,null,null,null,null,"Ekstra tim. I\nperiode:",null,null,null,null,"Timer til udbetaling:\nA/N till. + evt. øverige timer",null,null,{"$f":"M36","v":3.9999999999999991}]
[null,null,null,"Afholdt Ferie (I timer) i\nperiode:",null,null,null,null,null,null,"Optj. OA tim. +50%:\nTime + 50%",null,null,{"$f":"P36*1.5","v":0.1875},null,"Saldo Ferie timer til\noverførsel:"]
[null,null,null,"Afholdt FerieFri time i\nperiode:",null,null,null,null,null,null,"Optj. OA tim. +100%:\nTime + 100%",null,null,{"$f":"Q36*2","v":8.3333333333333259E-2},null,"Saldo FerieFri time til\noverførsel:"]
[null,null,null,"Optjent NY Ferie (dage)",null,null,null,null,2.08,null,"Afholdt NY ferie(dage)",null,null,null,null,"Saldo NY ferie (dage)"]
[null,null,null,"DATO: ______________________",null,null,null,null,null,null,"UNDERSKRIFT: _______________________________ ml 01.09.20"]

{"sheet":"Data","index":1,"n_rows":52,"n_cols":21,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4]]}
[]
[null,"Rulle Liste",null,"Rulle Liste",null,"Timer",null,"Coltime",null,null,null,null,null,"Vagttype","start","Vagttype","slut","Vagttype","antal timer"]
[null,null,null,"07:45:00","07:45:00",{"$f":"SUM(Nov!I5:I35)","v":30.75},null,"17:00:00",null,0,null,null,null,1,"07:45:00",1,"16:00:00",1,8.25,null,"03:00:00"]
[null,"07:45:00","16:00:00","08:00:00","08:00:00",null,null,1,null,1,"07:45:00","16:00:00",null,2,"07:45:00",2,"18:00:00",2,10.25]
[null,"07:45:00","18:00:00","08:15:00","08:15:00","Vagter",null,null,null,2,"07:45:00","18:00:00",null,3,"07:45:00",3,"20:00:00",3,12.25]
[null,null,null,"08:30:00","08:30:00",{"$f":"COUNT(Nov!I5:I35)","v":3},null,null,null,3,"07:45:00","20:00:00"]
[null,null,null,"08:45:00","08:45:00"]
[null,null,null,"09:00:00","09:00:00","Vagter (S)"]
[null,null,null,"09:15:00","09:15:00",{"$f":"COUNTIF(Nov!I5:I35, 8.25)","v":1}]
[null,null,null,"09:30:00","09:30:00"]
[null,null,null,"09:45:00","09:45:00","Vagter (L)"]
[null,null,null,"10:00:00","10:00:00",{"$f":"COUNTIF(Nov!I5:I35, 10.25)","v":1}]
[null,null,null,"10:15:00","10:15:00"]
[null,null,null,"10:30:00","10:30:00"]
[null,null,null,"10:45:00","10:45:00"]
[null,null,null,"11:00:00","11:00:00"]
[null,null,null,"11:15:00","11:15:00"]
[null,null,null,"11:30:00","11:30:00"]
[null,null,null,"11:45:00","11:45:00"]
[null,null,null,"12:00:00","12:00:00"]
[null,null,null,"12:15:00","12:15:00"]
[null,null,null,"12:30:00","12:30:00"]
[null,null,null,"12:45:00","12:45:00"]
[null,null,null,"13:00:00","13:00:00"]
[null,null,null,"13:15:00","13:15:00"]
[null,null,null,"13:30:00","13:30:00"]
[null,null,null,"13:45:00","13:45:00"]
[null,null,null,"14:00:00","14:00:00"]
[null,null,null,"14:15:00","14:15:00"]
[null,null,null,"14:30:00","14:30:00"]
[null,null,null,"14:45:00","14:45:00"]
[null,null,null,"15:00:00","15:00:00"]
[null,null,null,"15:15:00","15:15:00"]
[null,null,null,"15:30:00","15:30:00"]
[null,null,null,"15:45:00","15:45:00"]
[null,null,null,"16:00:00","16:00:00"]
[null,null,null,"16:15:00","16:15:00"]
[null,null,null,null,"16:30:00"]
[null,null,null,null,"16:45:00"]
[null,null,null,null,"17:00:00"]
[null,null,null,null,"17:15:00"]
[null,null,null,null,"17:30:00"]
[null,null,null,null,"17:45:00"]
[null,null,null,null,"18:00:00"]
[null,null,null,null,"18:15:00"]
[null,null,null,null,"18:30:00"]
[null,null,null,null,"18:45:00"]
[null,null,null,null,"19:00:00"]
[null,null,null,null,"19:15:00"]
[null,null,null,null,"19:30:00"]
[null,null,null,null,"19:45:00"]
[null,null,null,null,"20:00:00"]