{"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":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,11,1,12],[1,15,1,16],[42,2,42,6],[41,2,41,6],[3,3,3,4],[3,5,3,6],[1,9,1,10],[41,9,41,11],[41,14,41,16],[40,9,40,11],[40,14,40,16],[42,9,42,11],[42,14,42,16],[35,3,35,4],[37,14,37,16],[40,2,40,6],[39,2,39,6],[38,2,38,6],[38,9,38,11],[38,14,38,16],[39,9,39,11],[39,14,39,16],[37,9,37,11],[37,2,37,6]]}
[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,"Navn: ",null,null,null,null,null,null,null,"Måned: ",null,{"$f":"CHOOSE(U2,\"Jan\",\"Feb\",\"Mar\",\"Apr\",\"Maj\",\"Jun\",\"Jul\",\"Aug\",\"Sep\",\"Okt\",\"Nov\",\"Dec\")","v":"Jan"},null,null,"År :",2021,null,null,null,null,1]
[]
["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"]
[{"$f":"_xlfn.ISOWEEKNUM(C5)","v":2},{"$f":"CHOOSE(WEEKDAY(C5,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"Lør"},{"$f":"DATE(P2,U2,16)","v":"2017-01-15"},null,null,null,null,{"$f":"IF(E5=D5,\" \",IF(E5<D5,(((0-D5)*24)+((E5)*24))+24,(E5-D5)*24))","v":" "},null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF(((U5-H5)*-1)<=0.25,\"\", IF((U5-H5)*-1<0,\"\",(U5-H5)*-1)))","v":""},null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F5,G5)*24","v":0},null,null,{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF((U5-H5)<=0.25,\"\",IF(U5-H5<0,\"\",U5-H5)))","v":""},{"$f":"IF(OR(F5=\"\",G5=\"\"),\"\",IF((U5-H5)<=0.25,\"\",IF(U5-H5<0,\"\",U5-H5)))","v":""},null,null,null,null,{"$f":"IF(G5=F5,\" \",IF(G5<F5,(((0-F5)*24)+((G5)*24))+24,(G5-F5)*24))","v":" "}]
[{"$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":"søn"},{"$f":"C5+1","v":"2017-01-16"},null,null,null,null,{"$f":"IF(E6=D6,\" \",IF(E6<D6,(((0-D6)*24)+((E6)*24))+24,(E6-D6)*24))","v":" "},null,{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF(((U6-H6)*-1)<=0.25,\"\", IF((U6-H6)*-1<0,\"\",(U6-H6)*-1)))","v":""},null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F6,G6)*24","v":0},null,null,{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF((U6-H6)<=0.25,\"\",IF(U6-H6<0,\"\",U6-H6)))","v":""},{"$f":"IF(OR(F6=\"\",G6=\"\"),\"\",IF((U6-H6)<=0.25,\"\",IF(U6-H6<0,\"\",U6-H6)))","v":""},null,null,null,null,{"$f":"IF(G6=F6,\" \",IF(G6<F6,(((0-F6)*24)+((G6)*24))+24,(G6-F6)*24))","v":" "}]
[{"$f":"IF(WEEKDAY(C7,11)=1,_xlfn.ISOWEEKNUM(C7),\"\")","v":3},{"$f":"CHOOSE(WEEKDAY(C7,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"man"},{"$f":"C6+1","v":"2017-01-17"},"07:45:00","16:00:00","07:45:00","15:00:00",8.2499999999999982,null,1.0000000000000231,null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F7,G7)*24","v":0},null,null,"","",null,null,null,null,7.2499999999999751]
["",{"$f":"CHOOSE(WEEKDAY(C8,11),\"man\", \"Tirs\",\"Ons\",\"Tors\",\"FRE\",\"Lør\",\"søn\")","v":"Tirs"},"2017-01-18",null,null,null,null,{"$f":"IF(E8=D8,\" \",IF(E8<D8,(((0-D8)*24)+((E8)*24))+24,(E8-D8)*24))","v":" "},null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F8,G8)*24","v":0},null,null,"","",null,null,null,null," "]
["","Ons","2017-01-19","07:45:00","18:00:00","07:45:00","18:00:00",10.249999999999991,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F9,G9)*24","v":0.99999999999997513},null,null,"","",null,null,null,null,10.249999999999968]
["","Tors","2017-01-20","07:45:00","16:00:00","07:45:00","17:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F10,G10)*24","v":0},null,null,0.9999999999999698,0.9999999999999698,null,null,null,null,{"$f":"IF(G10=F10,\" \",IF(G10<F10,(((0-F10)*24)+((G10)*24))+24,(G10-F10)*24))","v":9.2499999999999609}]
["","FRE","2017-01-21","07:45:00","16:00:00","07:45:00","16:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F11,G11)*24","v":0},null,null,"",{"$f":"IF(OR(F11=\"\",G11=\"\"),\"\",IF((U11-H11)<=0.25,\"\",IF(U11-H11<0,\"\",U11-H11)))","v":""},null,null,null,null,8.2499999999999751]
["","Lør","2017-01-22",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F12,G12)*24","v":0},null,null,"","",null,null,null,null," "]
["","søn","2017-01-23",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F13,G13)*24","v":0},null,null,"","",null,null,null,null," "]
[4,"man","2017-01-24","07:45:00","16:00:00","07:45:00","16:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F14,G14)*24","v":0},null,null,"","",null,null,null,null,8.2499999999999751]
["","Tirs","2017-01-25",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F15,G15)*24","v":0},null,null,"","",null,null,null,null," "]
["","Ons","2017-01-26","07:45:00","16:00:00","07:45:00","15:45:00",8.2499999999999911,null,0.25000000000002309,null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F16,G16)*24","v":0},null,null,"","",null,null,null,null,7.999999999999968]
["","Tors","2017-01-27","07:45:00","16:00:00","07:45:00","18:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F17,G17)*24","v":0.99999999999997513},null,null,1.9999999999999769,1.9999999999999769,null,null,null,null,10.249999999999968]
["","FRE","2017-01-28","07:45:00","16:00:00","07:45:00","15:30:00",8.2499999999999911,null,0.50000000000000711,null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F18,G18)*24","v":0},null,null,"","",null,null,null,null,7.749999999999984]
["","Lør","2017-01-29",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F19,G19)*24","v":0},null,null,"","",null,null,null,null," "]
["","søn","2017-01-30",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F20,G20)*24","v":0},null,null,"","",null,null,null,null," "]
[5,"man","2017-01-31","07:45:00","16:00:00","07:45:00","19:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F21,G21)*24","v":2.0000000000000062},null,null,3.0000000000000071,3.0000000000000071,null,null,null,null,11.249999999999998]
["","Tirs","2017-02-01","07:45:00","16:00:00","07:45:00","16:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F22,G22)*24","v":0},null,null,"","",null,null,null,null,8.2499999999999751]
["","Ons","2017-02-02","07:45:00","18:00:00","07:45:00","18:00:00",10.249999999999991,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F23,G23)*24","v":0.99999999999997513},null,null,"","",null,null,null,null,10.249999999999968]
["","Tors","2017-02-03",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F24,G24)*24","v":0},null,null,"","",null,null,null,null," "]
["","FRE","2017-02-04","07:45:00","16:00:00","07:45:00","16:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F25,G25)*24","v":0},null,null,"","",null,null,null,null,8.2499999999999751]
["","Lør","2017-02-05",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F26,G26)*24","v":0},null,null,"","",null,null,null,null," "]
["","søn","2017-02-06",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F27,G27)*24","v":0},null,null,"","",null,null,null,null," "]
[6,"man","2017-02-07","07:45:00","16:00:00","07:45:00","16:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F28,G28)*24","v":0},null,null,"","",null,null,null,null,8.2499999999999751]
["","Tirs","2017-02-08","07:45:00","16:00:00","07:45:00","16:45:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F29,G29)*24","v":0},null,null,0.74999999999998401,0.74999999999998401,null,null,null,null,8.9999999999999751]
["","Ons","2017-02-09","07:45:00","18:00:00","07:45:00","18:45:00",10.249999999999991,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F30,G30)*24","v":1.7499999999999751},null,null,0.74999999999997691,0.74999999999997691,null,null,null,null,10.999999999999968]
["","Tors","2017-02-10","07:45:00","16:00:00","07:45:00","16:00:00",8.2499999999999911,null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F31,G31)*24","v":0},null,null,"","",null,null,null,null,8.2499999999999751]
["","FRE","2017-02-11",null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F32,G32)*24","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":"Lør"},{"$f":"IF(DAY(C32+1)>15,\"\",C32+1)","v":"2017-02-12"},null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F33,G33)*24","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":"søn"},{"$f":"IFERROR(C33+1,\"\")","v":"2017-02-13"},null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F34,G34)*24","v":0},null,null,"","",null,null,null,null," "]
[7,"man",{"$f":"IFERROR(IF(DAY(C34+1)>15,\"\",C34+1),\"\")","v":"2017-02-14"},null,null,null,null," ",null,"",null,{"$f":"ColTime(Data!$H$3,Data!$H$4,F35,G35)*24","v":0},null,null,"","",null,null,null,null," "]
[null,null,null,"SUM AF\nTim./till.:",null,null,null,{"$f":"SUM(H5:H35)","v":137.99999999999986},null,{"$f":"SUM(J5:J35)","v":1.7500000000000533},null,{"$f":"SUM(L5:L35)","v":6.7499999999999067},null,null,{"$f":"SUM(O5:O35)*1.5","v":11.249999999999872},{"$f":"SUM(P5:P35)*2","v":14.999999999999829}]
[]
[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,"+/- 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,"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,"Afholdt Ferie (I timer) i\nperiode:",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,"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,"Afholdt NY ferie(dage)",null,null,null,null,"Saldo NY ferie (dage)"]
[null,null,"DATO: ______________________",null,null,null,null,null,null,"UNDERSKRIFT: _______________________________ ml 01.09.20"]

{"sheet":"Data","index":1,"n_rows":52,"n_cols":8,"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,"07:45:00","07:45:00",{"$f":"SUM(Nov!H5:H35)","v":137.99999999999986},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!H5:H35)","v":16}]
[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!H5:H35, 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!H5:H35, 10.25)","v":3}]
[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"]