{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Nov","T"],"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":[[42,2,42,5],[42,10,42,12],[42,15,42,17],[3,3,3,4],[35,3,35,4],[37,2,37,5],[37,15,37,17],[37,10,37,12],[38,2,38,5],[38,10,38,12],[38,15,38,17],[41,2,41,5],[39,2,39,5],[39,10,39,12],[39,15,39,17],[40,2,40,5],[1,10,1,11],[1,12,1,13],[1,16,1,17],[3,5,3,6],[41,10,41,12],[41,15,41,17],[40,10,40,12],[40,15,40,17]]}
[null,null,"Månedsrapport"]
[null,"Navn: ",null,null,null,null,null,null,null,null,"Måned: ",null,{"$f":"CHOOSE(M3,\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"Maj\")","v":"Feb"},null,null,"År :",2021]
[null,null,null,null,null,null,null,null,null,null,null,null,2]
["Uge","Dag","Dato","Planl.\nMøde tid\nFra - Til",null,"Faktisk\nMøde\nTid.\nFra-Til",null,"Plan lagte timer","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"]
[{"$f":"_xlfn.ISOWEEKNUM(C5)","v":7},{"$f":"CHOOSE(WEEKDAY(C5,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"Tirs"},{"$f":"DATE(Q2,M3,16)","v":"2017-02-15"},"07:45:00","16:00:00","07:45:00","12:00:00",{"$f":"E5-D5","v":"08:15:00"},{"$f":"G5-F5","v":"04:15:00"},null,{"$f":"I5-H5","v":-0.16666666666666663},null,{"$f":"ColTime(T!$H$5,T!$H$6,F5,G5)","v":0},null,null,{"$f":"IF(I5-H5<0,\" \",I5-H5)","v":" "},{"$f":"IF(V5-I5<0,\"\",V5-I5)","v":0},null,null,null,null,{"$f":"IF(G5=F5,\" \",IF(G5<F5,(((0-F5))+((G5)))+24,(G5-F5)))","v":0.17708333333333331}]
[{"$f":"IF(WEEKDAY(C6,11)=1,_xlfn.ISOWEEKNUM(C6),\"\")","v":""},{"$f":"CHOOSE(WEEKDAY(C6,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"Ons"},{"$f":"C5+1","v":"2017-02-16"},"07:45:00","16:00:00","07:45:00","18:15:00",{"$f":"E6-D6","v":"08:15:00"},{"$f":"G6-F6","v":"10:30:00"},null,{"$f":"I6-H6","v":"02:15:00"},null,{"$f":"ColTime(T!$H$5,T!$H$6,F6,G6)","v":5.2083333333333259E-2},null,null,{"$f":"IF(I6-H6<0,\" \",I6-H6)","v":9.375E-2},{"$f":"IF(V6-I6<0,\"\",V6-I6)","v":0},null,null,null,null,{"$f":"IF(G6=F6,\" \",IF(G6<F6,(((0-F6))+((G6)))+24,(G6-F6)))","v":0.43749999999999994}]
[{"$f":"IF(WEEKDAY(C7,11)=1,_xlfn.ISOWEEKNUM(C7),\"\")","v":""},{"$f":"CHOOSE(WEEKDAY(C7,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"Tors"},{"$f":"C6+1","v":"2017-02-17"},"07:45:00","18:00:00","07:45:00","20:00:00",{"$f":"E7-D7","v":"10:15:00"},"12:15:00",null,"02:00:00",null,{"$f":"ColTime(T!$H$5,T!$H$6,F7,G7)","v":0.12499999999999867},null,null,{"$f":"IF(I7-H7<0,\" \",I7-H7)","v":8.3333333333332094E-2},0,null,null,null,null,{"$f":"IF(G7=F7,\" \",IF(G7<F7,(((0-F7))+((G7)))+24,(G7-F7)))","v":0.51041666666666541}]
["",{"$f":"CHOOSE(WEEKDAY(C8,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"FRE"},"2017-02-18",null,null,null,null,null,{"$f":"IF(E8=D8,\" \",IF(E8<D8,(((0-D8)*24)+((E8)*24))+24,(E8-D8)*24))","v":" "},null,{"$f":"IF(OR(F8=\"\",G8=\"\"),\"\",IF(V8-I8>0,\" \",V8-I8))","v":""},null,{"$f":"ColTime(T!$H$5,T!$H$6,F8,G8)","v":0},null,null,{"$f":"IF(OR(F8=\"\",G8=\"\"),\"\",IF(V8-I8<0,\"\",V8-I8))","v":""},{"$f":"IF(OR(F8=\"\",G8=\"\"),\"\",IF(V8-I8<0,\"\",V8-I8))","v":""},null,null,null,null,{"$f":"IF(G8=F8,\" \",IF(G8<F8,(((0-F8))+((G8)))+24,(G8-F8)))","v":" "}]
["","Lør","2017-02-19",null,null,null,null,null," ",null,{"$f":"IF(OR(F9=\"\",G9=\"\"),\"\",IF(V9-I9>0,\" \",V9-I9))","v":""},null,{"$f":"ColTime(T!$H$5,T!$H$6,F9,G9)","v":0},null,null,{"$f":"IF(OR(F9=\"\",G9=\"\"),\"\",IF(V9-I9<0,\"\",V9-I9))","v":""},{"$f":"IF(OR(F9=\"\",G9=\"\"),\"\",IF(V9-I9<0,\"\",V9-I9))","v":""},null,null,null,null," "]
["","søn","2017-02-20",null,null,null,null,null," ",null,{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(V10-I10>0,\" \",V10-I10))","v":""},null,{"$f":"ColTime(T!$H$5,T!$H$6,F10,G10)","v":0},null,null,{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(V10-I10<0,\"\",V10-I10))","v":""},{"$f":"IF(OR(F10=\"\",G10=\"\"),\"\",IF(V10-I10<0,\"\",V10-I10))","v":""},null,null,null,null," "]
[8,"man","2017-02-21",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F11,G11)","v":0},null,null,"","",null,null,null,null," "]
["","Tirs","2017-02-22",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F12,G12)","v":0},null,null,"","",null,null,null,null," "]
["","Ons","2017-02-23",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F13,G13)","v":0},null,null,"","",null,null,null,null," "]
["","Tors","2017-02-24",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F14,G14)","v":0},null,null,"","",null,null,null,null," "]
["","FRE","2017-02-25",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F15,G15)","v":0},null,null,"","",null,null,null,null," "]
["","Lør","2017-02-26",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F16,G16)","v":0},null,null,"","",null,null,null,null," "]
["","søn","2017-02-27",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F17,G17)","v":0},null,null,"","",null,null,null,null," "]
[9,"man","2017-02-28",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F18,G18)","v":0},null,null,"","",null,null,null,null," "]
["","Tirs","2017-03-01",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F19,G19)","v":0},null,null,"","",null,null,null,null," "]
["","Ons","2017-03-02",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F20,G20)","v":0},null,null,"","",null,null,null,null," "]
["","Tors","2017-03-03",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F21,G21)","v":0},null,null,"","",null,null,null,null," "]
["","FRE","2017-03-04",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F22,G22)","v":0},null,null,"","",null,null,null,null," "]
["","Lør","2017-03-05",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F23,G23)","v":0},null,null,"","",null,null,null,null," "]
["","søn","2017-03-06",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F24,G24)","v":0},null,null,"","",null,null,null,null," "]
[10,"man","2017-03-07",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F25,G25)","v":0},null,null,"","",null,null,null,null," "]
["","Tirs","2017-03-08",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F26,G26)","v":0},null,null,"","",null,null,null,null," "]
["","Ons","2017-03-09",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F27,G27)","v":0},null,null,"","",null,null,null,null," "]
["","Tors","2017-03-10",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F28,G28)","v":0},null,null,"","",null,null,null,null," "]
["","FRE","2017-03-11",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F29,G29)","v":0},null,null,"","",null,null,null,null," "]
["","Lør","2017-03-12",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F30,G30)","v":0},null,null,"","",null,null,null,null," "]
["","søn","2017-03-13",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F31,G31)","v":0},null,null,"","",null,null,null,null," "]
[11,"man","2017-03-14",null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F32,G32)","v":0},null,null,"","",null,null,null,null," "]
[{"$f":"IFERROR(IF(WEEKDAY(C33,11)=1,_xlfn.ISOWEEKNUM(C33),\"\"),\"\")","v":""},{"$f":"IFERROR(CHOOSE(WEEKDAY(C33,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\"),\"\")","v":""},{"$f":"IF(DAY(C32+1)>15,\"\",C32+1)","v":""},null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F33,G33)","v":0},null,null,"","",null,null,null,null," "]
[{"$f":"IFERROR(IF(WEEKDAY(C34,11)=1,_xlfn.ISOWEEKNUM(C34),\"\"),\"\")","v":""},{"$f":"IFERROR(CHOOSE(WEEKDAY(C34,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\"),\"\")","v":""},{"$f":"IFERROR(C33+1,\"\")","v":""},null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F34,G34)","v":0},null,null,"","",null,null,null,null," "]
["","",{"$f":"IFERROR(IF(DAY(C34+1)>15,\"\",C34+1),\"\")","v":""},null,null,null,null,null," ",null,"",null,{"$f":"ColTime(T!$H$5,T!$H$6,F35,G35)","v":0},null,null,"","",null,null,null,null," "]
[null,null,null,"SUM AF\nTim./till.:",null,null,null,null,{"$f":"SUM(I5:I35)","v":1.1249999999999987},null,{"$f":"SUM(K5:K35)","v":1.0416666666665464E-2},null,{"$f":"SUM(M5:M35)","v":0.17708333333333193},null,null,{"$f":"SUM(P5:P35)","v":0.17708333333333209},{"$f":"SUM(Q5:Q35)","v":0}]
[]
[null,null,"+/- Norm time overført fra \nsidste periode:",null,null,null,null,null,null,null,"+/- Norm time i\nperiode:",null,null,null,null,"+/- Norm time til\noverførsel næste periode:"]
[null,null,"+/- Afsp time overført fra \nsidste periode:",null,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,"Kursus time i periode:",null,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,"Afholdt Ferie (I timer) i\nperiode:",null,null,null,null,null,null,null,"Optj. OA tim. +50%:\nTime + 50%",null,null,null,null,"Saldo Ferie timer til\noverførsel:"]
[null,null,"Afholdt FerieFri time i\nperiode:",null,null,null,null,null,null,null,"Optj. OA tim. +100%:\nTime + 100%",null,null,null,null,"Saldo FerieFri time til\noverførsel:"]
[null,null,"Optjent NY Ferie (dage)",null,null,null,null,null,null,null,"Afholdt NY ferie(dage)",null,null,null,null,"Saldo NY ferie (dage)"]
[null,null,"DATO: ______________________",null,null,null,null,null,null,null,"UNDERSKRIFT: _______________________________ ml 01.09.20"]

{"sheet":"T","index":1,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4]]}
[]
[]
[]
[null,"Rulle Liste",null,"Rulle Liste",null,"Timer",null,"Coltime"]
[null,null,null,"07:45:00","07:45:00",{"$f":"SUM(Nov!I5:I35)","v":1.1249999999999987},null,"17:00:00"]
[null,"07:45:00","16:00:00","08:00:00","08:00:00",null,null,1]
[null,null,"18:00:00","08:15:00","08:15:00","Vagter"]
[null,null,null,"08:30:00","08:30:00",{"$f":"COUNT(Nov!I5:I35)","v":3}]
[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":0}]
[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":0}]
[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"]