{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Nov"],"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":95,"n_cols":21,"rows_kept":95,"cut":false,"hidden":false,"merged":[[41,2,41,5],[39,2,39,5],[39,9,39,11],[39,14,39,16],[40,2,40,5],[40,9,40,11],[40,14,40,16],[3,5,3,6],[44,5,44,6],[41,9,41,11],[41,14,41,16],[42,2,42,5],[42,9,42,11],[42,14,42,16],[3,3,3,4],[44,3,44,4],[35,3,35,4],[37,2,37,5],[37,14,37,16],[37,9,37,11],[38,2,38,5],[38,9,38,11],[38,14,38,16]]}
[null,null,"Månedsrapport"]
[null,null,"Navn: _______________________________",null,null,null,null,null,null,null,"Måned: ______________",null,null,null,"År ____"]
[]
["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"]
[42,"FRE",16,"07:45:00","16:00:00","07:45:00","12:00:00",{"$f":"IF(E5=D5,\" \",IF(E5<D5,(((0-D5)*24)+((E5)*24))+24,(E5-D5)*24))","v":8.2499999999999982},null,{"$f":"IF(U5-H5>0,\" \",U5-H5)","v":-3.9999999999999982},null,{"$f":"ColTime($L$46,$L$47,F5,G5)","v":0},null,null,{"$f":"IF(U5-H5<0,\" \",U5-H5)","v":" "},{"$f":"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":4.25}]
[null,"LØR",17,"07:45:00","16:00:00","07:45:00","17:00:00",{"$f":"IF(E6=D6,\" \",IF(E6<D6,(((0-D6)*24)+((E6)*24))+24,(E6-D6)*24))","v":8.2499999999999982},null,{"$f":"IF(U6-H6>0,\" \",U6-H6)","v":" "},null,{"$f":"ColTime($L$46,$L$47,F6,G6)","v":0},null,null,{"$f":"T1","v":0},{"$f":"IF(U6-H6<0,\"\",U6-H6)","v":0.9999999999999698},null,null,null,null,9.249999999999968]
[null,"SØN",18,"07:45:00","18:00:00","07:45:00","20:00:00",10.25,null," ",null,0.12499999999999867,null,null,{"$f":"IF(U7-H7<0,\"\",U7-H7)","v":1.9999999999999698},1.9999999999999698,null,null,null,null,12.24999999999997]
[43,"MAN",19,null,null,null,null," ",null,{"$f":"IF(U8-H8>0,\" \",U8-H8)","v":{"$error":"#VALUE!"}},null,0,null,null,{"$error":"#VALUE!"},{"$f":"IF(U8-H8<0,\"\",U8-H8)","v":{"$error":"#VALUE!"}},null,null,null,null," "]
[null,"TIR",20,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"ONS",21,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"TOR",22,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"FRE",23,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"LØR",24,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"SØN",25,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[44,"MAN",26,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"TIR",27,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"ONS",28,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"TOR",29,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"FRE",30,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"LØR",31,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"SØN",1,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[45,"MAN",2,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"TIR",3,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"ONS",4,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"TOR",5,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"FRE",6,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"LØR",7,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"SØN",8,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[46,"MAN",9,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"TIR",10,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"ONS",11,null,null,null,null," ",null,{"$error":"#VALUE!"},null,{"$f":"ColTime($L$46,$L$47,F31,G31)","v":0},null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"TOR",12,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"FRE",13,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,"LØR",14,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,null,15,null,null,null,null," ",null,{"$error":"#VALUE!"},null,0,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null," "]
[null,null,null,"SUM AF\nTim./till.:",null,null,null,{"$f":"SUM(H5:H35)","v":26.749999999999996},null,{"$f":"SUM(J5:J35)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(L5:L35)","v":0.12499999999999867},null,null,{"$f":"SUM(O5:O35)","v":{"$error":"#VALUE!"}},{"$f":"SUM(P5:P35)","v":{"$error":"#VALUE!"}}]
[]
[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"]
[null,null,null,"Rulle Liste",null,"Rulle Liste",null,"Timer",null,null,null,"Coltime"]
[null,null,null,null,null,"07:45:00","07:45:00",{"$f":"SUM(H5:H35)","v":26.749999999999996},null,null,null,"17:00:00"]
[null,null,null,"07:45:00","16:00:00","08:00:00","08:00:00",null,null,null,null,1]
[null,null,null,null,"18:00:00","08:15:00","08:15:00","Vagter"]
[null,null,null,null,null,"08:30:00","08:30:00",{"$f":"COUNT(H5:H35)","v":3}]
[null,null,null,null,null,"08:45:00","08:45:00"]
[null,null,null,null,null,"09:00:00","09:00:00","Vagter (S)"]
[null,null,null,null,null,"09:15:00","09:15:00",{"$f":"COUNTIF(H5:H35, 8.25)","v":2}]
[null,null,null,null,null,"09:30:00","09:30:00"]
[null,null,null,null,null,"09:45:00","09:45:00","Vagter (L)"]
[null,null,null,null,null,"10:00:00","10:00:00",{"$f":"COUNTIF(H5:H35, 10.25)","v":1}]
[null,null,null,null,null,"10:15:00","10:15:00"]
[null,null,null,null,null,"10:30:00","10:30:00"]
[null,null,null,null,null,"10:45:00","10:45:00"]
[null,null,null,null,null,"11:00:00","11:00:00"]
[null,null,null,null,null,"11:15:00","11:15:00"]
[null,null,null,null,null,"11:30:00","11:30:00"]
[null,null,null,null,null,"11:45:00","11:45:00"]
[null,null,null,null,null,"12:00:00","12:00:00"]
[null,null,null,null,null,"12:15:00","12:15:00"]
[null,null,null,null,null,"12:30:00","12:30:00"]
[null,null,null,null,null,"12:45:00","12:45:00"]
[null,null,null,null,null,"13:00:00","13:00:00"]
[null,null,null,null,null,"13:15:00","13:15:00"]
[null,null,null,null,null,"13:30:00","13:30:00"]
[null,null,null,null,null,"13:45:00","13:45:00"]
[null,null,null,null,null,"14:00:00","14:00:00"]
[null,null,null,null,null,"14:15:00","14:15:00"]
[null,null,null,null,null,"14:30:00","14:30:00"]
[null,null,null,null,null,"14:45:00","14:45:00"]
[null,null,null,null,null,"15:00:00","15:00:00"]
[null,null,null,null,null,"15:15:00","15:15:00"]
[null,null,null,null,null,"15:30:00","15:30:00"]
[null,null,null,null,null,"15:45:00","15:45:00"]
[null,null,null,null,null,"16:00:00","16:00:00"]
[null,null,null,null,null,"16:15:00","16:15:00"]
[null,null,null,null,null,null,"16:30:00"]
[null,null,null,null,null,null,"16:45:00"]
[null,null,null,null,null,null,"17:00:00"]
[null,null,null,null,null,null,"17:15:00"]
[null,null,null,null,null,null,"17:30:00"]
[null,null,null,null,null,null,"17:45:00"]
[null,null,null,null,null,null,"18:00:00"]
[null,null,null,null,null,null,"18:15:00"]
[null,null,null,null,null,null,"18:30:00"]
[null,null,null,null,null,null,"18:45:00"]
[null,null,null,null,null,null,"19:00:00"]
[null,null,null,null,null,null,"19:15:00"]
[null,null,null,null,null,null,"19:30:00"]
[null,null,null,null,null,null,"19:45:00"]
[null,null,null,null,null,null,"20:00:00"]