{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Timer","Overenskomst","Medarbejder","Helligdage","Timeseddel","Setup","job"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Timer","index":0,"n_rows":44,"n_cols":19,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,5,1,8],[3,2,3,3],[4,2,4,3],[5,2,5,3],[9,10,10,10],[8,7,8,13],[5,9,7,15],[9,15,10,15],[9,0,10,0],[9,13,10,13],[9,7,10,7],[9,6,10,6],[9,12,10,12],[9,5,10,5],[9,4,10,4],[9,3,10,3],[9,2,10,2],[9,11,10,11],[9,16,10,16],[9,17,10,17],[9,18,10,18],[9,1,10,1],[9,14,10,14]]}
[]
["Vælg år + måned >>>",2025,"April",null,null,"Timeregistrering"]
[null,"Medarbejder nr:",1]
[null,"Cpr nr:",{"$f":"IF(C3=0,\"\",VLOOKUP(C3,Medarbejder!A:F,3))","v":"????"}]
[null,"Navn",{"$f":"IF(C3=0,\"\",VLOOKUP(C3,Medarbejder!A:F,2))","v":"????"}]
[null,"Adresse",{"$f":"IF(C3=0,\"\",VLOOKUP(C3,Medarbejder!A:F,4))","v":"????"}]
[null,"By",{"$f":"IF(C3=0,\"\",VLOOKUP(C3,Medarbejder!A:F,5))","v":"????"}]
[null,"Postnr:",{"$f":"IF(C3=0,\"\",VLOOKUP(C3,Medarbejder!A:F,6))","v":"????"}]
[]
["Helligdage","Ugenr","Ugedag","Dato","Starttid","Sluttid","Pause","Normaltimer","Overtid 50%","Overtid 100%","Aftentimer","Nattimer","søndag","Helligdags timer","Sygetimer","Barsel","Feriefridag","Ferie","Barn syg"]
[null,null,null,null,null,null,null,null,"1-3 timer","Over 3 timer"]
[{"$f":"IF(NOT(ISERROR(MATCH(D12,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D12,Helligdage!A$3:A$12,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(D12),WEEKNUM(D12,2),\"\")","v":14},{"$f":"PROPER(TEXT(D12,\"dddd\"))","v":"Tirsdag"},{"$f":"DATEVALUE(\"1/\"&C2&\"/\"&B2)","v":"2025-04-01"},null,null,null,{"$f":"IF(OR(E12=0,F12=0),0,IF(F12<E12,((F12+1)-E12)*24-G12,(F12-E12)*24-G12))","v":0},{"$f":"IF(OR(AND(OR(C12=\"mandag\",C12=\"tirsdag\",C12=\"onsdag\",C12=\"torsdag\"),H12>Setup!$F$4),AND(C12=\"fredag\",H12>Setup!$F$5)),MIN(H12-IF(C12=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C12=\"mandag\",C12=\"tirsdag\",C12=\"onsdag\",C12=\"torsdag\"),H12>Setup!$F$4),AND(C12=\"fredag\",H12>Setup!$F$5)),H12-IF(C12=\"fredag\",Setup!$F$5,Setup!$F$4)-I12,0)","v":0},{"$f":"IF(OR(E12=0,F12=0),0,MAX(0,MIN(IF(F12<E12,F12+1,F12),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E12,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E12=0,F12=0),0,MAX(0,MIN(IF(F12<E12,F12+1,F12),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E12,Setup!$F$3))*24)","v":0},{"$f":"IF(C12=\"søndag\",H12,\"\")","v":""},{"$f":"IF(OR(A12=\"Skærtorsdag\",A12=\"Langfredag\",A12=\"Påskedag\",A12=\"2.Påskedag\",A12=\"Kr.Himmelfartsdag\",A12=\"Pinsedag\",A12=\"2. Pinsedag\",A12=\"Juledag\",A12=\"2 Juledag\",A12=\"Nytårsdag\"),H12-IF(ISNUMBER(M12),M12,0),\"\")","v":""}]
[{"$f":"IF(NOT(ISERROR(MATCH(D13,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D13,Helligdage!A$3:A$12,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(D13),WEEKNUM(D13,2),\"\")","v":14},{"$f":"PROPER(TEXT(D13,\"dddd\"))","v":"Onsdag"},{"$f":"IFERROR(IF(AND(D12<>\"\",D12+1<=DATE(YEAR(D12),MONTH(D12)+1,0)),D12+1,\"\"),\"\")","v":"2025-04-02"},null,null,null,{"$f":"IF(OR(E13=0,F13=0),0,IF(F13<E13,((F13+1)-E13)*24-G13,(F13-E13)*24-G13))","v":0},{"$f":"IF(OR(AND(OR(C13=\"mandag\",C13=\"tirsdag\",C13=\"onsdag\",C13=\"torsdag\"),H13>Setup!$F$4),AND(C13=\"fredag\",H13>Setup!$F$5)),MIN(H13-IF(C13=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C13=\"mandag\",C13=\"tirsdag\",C13=\"onsdag\",C13=\"torsdag\"),H13>Setup!$F$4),AND(C13=\"fredag\",H13>Setup!$F$5)),H13-IF(C13=\"fredag\",Setup!$F$5,Setup!$F$4)-I13,0)","v":0},{"$f":"IF(OR(E13=0,F13=0),0,MAX(0,MIN(IF(F13<E13,F13+1,F13),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E13,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E13=0,F13=0),0,MAX(0,MIN(IF(F13<E13,F13+1,F13),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E13,Setup!$F$3))*24)","v":0},{"$f":"IF(C13=\"søndag\",H13,\"\")","v":""},{"$f":"IF(OR(A13=\"Skærtorsdag\",A13=\"Langfredag\",A13=\"Påskedag\",A13=\"2.Påskedag\",A13=\"Kr.Himmelfartsdag\",A13=\"Pinsedag\",A13=\"2. Pinsedag\",A13=\"Juledag\",A13=\"2 Juledag\",A13=\"Nytårsdag\"),H13-IF(ISNUMBER(M13),M13,0),\"\")","v":""}]
[{"$f":"IF(NOT(ISERROR(MATCH(D14,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D14,Helligdage!A$3:A$12,0)),\"\")","v":""},14,"Torsdag",{"$f":"IFERROR(IF(AND(D13<>\"\",D13+1<=DATE(YEAR(D13),MONTH(D13)+1,0)),D13+1,\"\"),\"\")","v":"2025-04-03"},null,null,null,0,{"$f":"IF(OR(AND(OR(C14=\"mandag\",C14=\"tirsdag\",C14=\"onsdag\",C14=\"torsdag\"),H14>Setup!$F$4),AND(C14=\"fredag\",H14>Setup!$F$5)),MIN(H14-IF(C14=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C14=\"mandag\",C14=\"tirsdag\",C14=\"onsdag\",C14=\"torsdag\"),H14>Setup!$F$4),AND(C14=\"fredag\",H14>Setup!$F$5)),H14-IF(C14=\"fredag\",Setup!$F$5,Setup!$F$4)-I14,0)","v":0},{"$f":"IF(OR(E14=0,F14=0),0,MAX(0,MIN(IF(F14<E14,F14+1,F14),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E14,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E14=0,F14=0),0,MAX(0,MIN(IF(F14<E14,F14+1,F14),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E14,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D15,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D15,Helligdage!A$3:A$12,0)),\"\")","v":""},14,"Fredag","2025-04-04",null,null,null,0,{"$f":"IF(OR(AND(OR(C15=\"mandag\",C15=\"tirsdag\",C15=\"onsdag\",C15=\"torsdag\"),H15>Setup!$F$4),AND(C15=\"fredag\",H15>Setup!$F$5)),MIN(H15-IF(C15=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C15=\"mandag\",C15=\"tirsdag\",C15=\"onsdag\",C15=\"torsdag\"),H15>Setup!$F$4),AND(C15=\"fredag\",H15>Setup!$F$5)),H15-IF(C15=\"fredag\",Setup!$F$5,Setup!$F$4)-I15,0)","v":0},{"$f":"IF(OR(E15=0,F15=0),0,MAX(0,MIN(IF(F15<E15,F15+1,F15),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E15,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E15=0,F15=0),0,MAX(0,MIN(IF(F15<E15,F15+1,F15),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E15,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D16,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D16,Helligdage!A$3:A$12,0)),\"\")","v":""},14,"Lørdag","2025-04-05",null,null,null,0,{"$f":"IF(OR(AND(OR(C16=\"mandag\",C16=\"tirsdag\",C16=\"onsdag\",C16=\"torsdag\"),H16>Setup!$F$4),AND(C16=\"fredag\",H16>Setup!$F$5)),MIN(H16-IF(C16=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C16=\"mandag\",C16=\"tirsdag\",C16=\"onsdag\",C16=\"torsdag\"),H16>Setup!$F$4),AND(C16=\"fredag\",H16>Setup!$F$5)),H16-IF(C16=\"fredag\",Setup!$F$5,Setup!$F$4)-I16,0)","v":0},{"$f":"IF(OR(E16=0,F16=0),0,MAX(0,MIN(IF(F16<E16,F16+1,F16),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E16,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E16=0,F16=0),0,MAX(0,MIN(IF(F16<E16,F16+1,F16),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E16,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D17,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D17,Helligdage!A$3:A$12,0)),\"\")","v":""},14,"Søndag","2025-04-06",null,null,null,0,{"$f":"IF(OR(AND(OR(C17=\"mandag\",C17=\"tirsdag\",C17=\"onsdag\",C17=\"torsdag\"),H17>Setup!$F$4),AND(C17=\"fredag\",H17>Setup!$F$5)),MIN(H17-IF(C17=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C17=\"mandag\",C17=\"tirsdag\",C17=\"onsdag\",C17=\"torsdag\"),H17>Setup!$F$4),AND(C17=\"fredag\",H17>Setup!$F$5)),H17-IF(C17=\"fredag\",Setup!$F$5,Setup!$F$4)-I17,0)","v":0},{"$f":"IF(OR(E17=0,F17=0),0,MAX(0,MIN(IF(F17<E17,F17+1,F17),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E17,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E17=0,F17=0),0,MAX(0,MIN(IF(F17<E17,F17+1,F17),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E17,Setup!$F$3))*24)","v":0},0,""]
[{"$f":"IF(NOT(ISERROR(MATCH(D18,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D18,Helligdage!A$3:A$12,0)),\"\")","v":""},15,"Mandag","2025-04-07",null,null,null,0,{"$f":"IF(OR(AND(OR(C18=\"mandag\",C18=\"tirsdag\",C18=\"onsdag\",C18=\"torsdag\"),H18>Setup!$F$4),AND(C18=\"fredag\",H18>Setup!$F$5)),MIN(H18-IF(C18=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C18=\"mandag\",C18=\"tirsdag\",C18=\"onsdag\",C18=\"torsdag\"),H18>Setup!$F$4),AND(C18=\"fredag\",H18>Setup!$F$5)),H18-IF(C18=\"fredag\",Setup!$F$5,Setup!$F$4)-I18,0)","v":0},{"$f":"IF(OR(E18=0,F18=0),0,MAX(0,MIN(IF(F18<E18,F18+1,F18),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E18,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E18=0,F18=0),0,MAX(0,MIN(IF(F18<E18,F18+1,F18),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E18,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D19,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D19,Helligdage!A$3:A$12,0)),\"\")","v":""},15,"Tirsdag","2025-04-08",null,null,null,0,{"$f":"IF(OR(AND(OR(C19=\"mandag\",C19=\"tirsdag\",C19=\"onsdag\",C19=\"torsdag\"),H19>Setup!$F$4),AND(C19=\"fredag\",H19>Setup!$F$5)),MIN(H19-IF(C19=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C19=\"mandag\",C19=\"tirsdag\",C19=\"onsdag\",C19=\"torsdag\"),H19>Setup!$F$4),AND(C19=\"fredag\",H19>Setup!$F$5)),H19-IF(C19=\"fredag\",Setup!$F$5,Setup!$F$4)-I19,0)","v":0},{"$f":"IF(OR(E19=0,F19=0),0,MAX(0,MIN(IF(F19<E19,F19+1,F19),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E19,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E19=0,F19=0),0,MAX(0,MIN(IF(F19<E19,F19+1,F19),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E19,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D20,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D20,Helligdage!A$3:A$12,0)),\"\")","v":""},15,"Onsdag","2025-04-09",null,null,null,0,{"$f":"IF(OR(AND(OR(C20=\"mandag\",C20=\"tirsdag\",C20=\"onsdag\",C20=\"torsdag\"),H20>Setup!$F$4),AND(C20=\"fredag\",H20>Setup!$F$5)),MIN(H20-IF(C20=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C20=\"mandag\",C20=\"tirsdag\",C20=\"onsdag\",C20=\"torsdag\"),H20>Setup!$F$4),AND(C20=\"fredag\",H20>Setup!$F$5)),H20-IF(C20=\"fredag\",Setup!$F$5,Setup!$F$4)-I20,0)","v":0},{"$f":"IF(OR(E20=0,F20=0),0,MAX(0,MIN(IF(F20<E20,F20+1,F20),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E20,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E20=0,F20=0),0,MAX(0,MIN(IF(F20<E20,F20+1,F20),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E20,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D21,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D21,Helligdage!A$3:A$12,0)),\"\")","v":""},15,"Torsdag","2025-04-10",null,null,null,0,{"$f":"IF(OR(AND(OR(C21=\"mandag\",C21=\"tirsdag\",C21=\"onsdag\",C21=\"torsdag\"),H21>Setup!$F$4),AND(C21=\"fredag\",H21>Setup!$F$5)),MIN(H21-IF(C21=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C21=\"mandag\",C21=\"tirsdag\",C21=\"onsdag\",C21=\"torsdag\"),H21>Setup!$F$4),AND(C21=\"fredag\",H21>Setup!$F$5)),H21-IF(C21=\"fredag\",Setup!$F$5,Setup!$F$4)-I21,0)","v":0},{"$f":"IF(OR(E21=0,F21=0),0,MAX(0,MIN(IF(F21<E21,F21+1,F21),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E21,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E21=0,F21=0),0,MAX(0,MIN(IF(F21<E21,F21+1,F21),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E21,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D22,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D22,Helligdage!A$3:A$12,0)),\"\")","v":""},15,"Fredag","2025-04-11",null,null,null,0,{"$f":"IF(OR(AND(OR(C22=\"mandag\",C22=\"tirsdag\",C22=\"onsdag\",C22=\"torsdag\"),H22>Setup!$F$4),AND(C22=\"fredag\",H22>Setup!$F$5)),MIN(H22-IF(C22=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C22=\"mandag\",C22=\"tirsdag\",C22=\"onsdag\",C22=\"torsdag\"),H22>Setup!$F$4),AND(C22=\"fredag\",H22>Setup!$F$5)),H22-IF(C22=\"fredag\",Setup!$F$5,Setup!$F$4)-I22,0)","v":0},{"$f":"IF(OR(E22=0,F22=0),0,MAX(0,MIN(IF(F22<E22,F22+1,F22),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E22,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E22=0,F22=0),0,MAX(0,MIN(IF(F22<E22,F22+1,F22),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E22,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D23,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D23,Helligdage!A$3:A$12,0)),\"\")","v":""},15,"Lørdag","2025-04-12",null,null,null,0,{"$f":"IF(OR(AND(OR(C23=\"mandag\",C23=\"tirsdag\",C23=\"onsdag\",C23=\"torsdag\"),H23>Setup!$F$4),AND(C23=\"fredag\",H23>Setup!$F$5)),MIN(H23-IF(C23=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C23=\"mandag\",C23=\"tirsdag\",C23=\"onsdag\",C23=\"torsdag\"),H23>Setup!$F$4),AND(C23=\"fredag\",H23>Setup!$F$5)),H23-IF(C23=\"fredag\",Setup!$F$5,Setup!$F$4)-I23,0)","v":0},{"$f":"IF(OR(E23=0,F23=0),0,MAX(0,MIN(IF(F23<E23,F23+1,F23),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E23,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E23=0,F23=0),0,MAX(0,MIN(IF(F23<E23,F23+1,F23),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E23,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D24,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D24,Helligdage!A$3:A$12,0)),\"\")","v":""},15,"Søndag","2025-04-13",null,null,null,0,{"$f":"IF(OR(AND(OR(C24=\"mandag\",C24=\"tirsdag\",C24=\"onsdag\",C24=\"torsdag\"),H24>Setup!$F$4),AND(C24=\"fredag\",H24>Setup!$F$5)),MIN(H24-IF(C24=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C24=\"mandag\",C24=\"tirsdag\",C24=\"onsdag\",C24=\"torsdag\"),H24>Setup!$F$4),AND(C24=\"fredag\",H24>Setup!$F$5)),H24-IF(C24=\"fredag\",Setup!$F$5,Setup!$F$4)-I24,0)","v":0},{"$f":"IF(OR(E24=0,F24=0),0,MAX(0,MIN(IF(F24<E24,F24+1,F24),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E24,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E24=0,F24=0),0,MAX(0,MIN(IF(F24<E24,F24+1,F24),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E24,Setup!$F$3))*24)","v":0},0,""]
[{"$f":"IF(NOT(ISERROR(MATCH(D25,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D25,Helligdage!A$3:A$12,0)),\"\")","v":""},16,"Mandag","2025-04-14",null,null,null,0,{"$f":"IF(OR(AND(OR(C25=\"mandag\",C25=\"tirsdag\",C25=\"onsdag\",C25=\"torsdag\"),H25>Setup!$F$4),AND(C25=\"fredag\",H25>Setup!$F$5)),MIN(H25-IF(C25=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C25=\"mandag\",C25=\"tirsdag\",C25=\"onsdag\",C25=\"torsdag\"),H25>Setup!$F$4),AND(C25=\"fredag\",H25>Setup!$F$5)),H25-IF(C25=\"fredag\",Setup!$F$5,Setup!$F$4)-I25,0)","v":0},{"$f":"IF(OR(E25=0,F25=0),0,MAX(0,MIN(IF(F25<E25,F25+1,F25),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E25,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E25=0,F25=0),0,MAX(0,MIN(IF(F25<E25,F25+1,F25),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E25,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D26,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D26,Helligdage!A$3:A$12,0)),\"\")","v":""},16,"Tirsdag","2025-04-15",null,null,null,0,{"$f":"IF(OR(AND(OR(C26=\"mandag\",C26=\"tirsdag\",C26=\"onsdag\",C26=\"torsdag\"),H26>Setup!$F$4),AND(C26=\"fredag\",H26>Setup!$F$5)),MIN(H26-IF(C26=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C26=\"mandag\",C26=\"tirsdag\",C26=\"onsdag\",C26=\"torsdag\"),H26>Setup!$F$4),AND(C26=\"fredag\",H26>Setup!$F$5)),H26-IF(C26=\"fredag\",Setup!$F$5,Setup!$F$4)-I26,0)","v":0},{"$f":"IF(OR(E26=0,F26=0),0,MAX(0,MIN(IF(F26<E26,F26+1,F26),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E26,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E26=0,F26=0),0,MAX(0,MIN(IF(F26<E26,F26+1,F26),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E26,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D27,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D27,Helligdage!A$3:A$12,0)),\"\")","v":""},16,"Onsdag","2025-04-16",null,null,null,0,{"$f":"IF(OR(AND(OR(C27=\"mandag\",C27=\"tirsdag\",C27=\"onsdag\",C27=\"torsdag\"),H27>Setup!$F$4),AND(C27=\"fredag\",H27>Setup!$F$5)),MIN(H27-IF(C27=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C27=\"mandag\",C27=\"tirsdag\",C27=\"onsdag\",C27=\"torsdag\"),H27>Setup!$F$4),AND(C27=\"fredag\",H27>Setup!$F$5)),H27-IF(C27=\"fredag\",Setup!$F$5,Setup!$F$4)-I27,0)","v":0},{"$f":"IF(OR(E27=0,F27=0),0,MAX(0,MIN(IF(F27<E27,F27+1,F27),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E27,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E27=0,F27=0),0,MAX(0,MIN(IF(F27<E27,F27+1,F27),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E27,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D28,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D28,Helligdage!A$3:A$12,0)),\"\")","v":"Skærtorsdag"},16,"Torsdag","2025-04-17",null,null,null,0,{"$f":"IF(OR(AND(OR(C28=\"mandag\",C28=\"tirsdag\",C28=\"onsdag\",C28=\"torsdag\"),H28>Setup!$F$4),AND(C28=\"fredag\",H28>Setup!$F$5)),MIN(H28-IF(C28=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C28=\"mandag\",C28=\"tirsdag\",C28=\"onsdag\",C28=\"torsdag\"),H28>Setup!$F$4),AND(C28=\"fredag\",H28>Setup!$F$5)),H28-IF(C28=\"fredag\",Setup!$F$5,Setup!$F$4)-I28,0)","v":0},{"$f":"IF(OR(E28=0,F28=0),0,MAX(0,MIN(IF(F28<E28,F28+1,F28),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E28,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E28=0,F28=0),0,MAX(0,MIN(IF(F28<E28,F28+1,F28),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E28,Setup!$F$3))*24)","v":0},"",0]
[{"$f":"IF(NOT(ISERROR(MATCH(D29,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D29,Helligdage!A$3:A$12,0)),\"\")","v":"Langfredag"},16,"Fredag","2025-04-18",null,null,null,0,{"$f":"IF(OR(AND(OR(C29=\"mandag\",C29=\"tirsdag\",C29=\"onsdag\",C29=\"torsdag\"),H29>Setup!$F$4),AND(C29=\"fredag\",H29>Setup!$F$5)),MIN(H29-IF(C29=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C29=\"mandag\",C29=\"tirsdag\",C29=\"onsdag\",C29=\"torsdag\"),H29>Setup!$F$4),AND(C29=\"fredag\",H29>Setup!$F$5)),H29-IF(C29=\"fredag\",Setup!$F$5,Setup!$F$4)-I29,0)","v":0},{"$f":"IF(OR(E29=0,F29=0),0,MAX(0,MIN(IF(F29<E29,F29+1,F29),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E29,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E29=0,F29=0),0,MAX(0,MIN(IF(F29<E29,F29+1,F29),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E29,Setup!$F$3))*24)","v":0},"",0]
[{"$f":"IF(NOT(ISERROR(MATCH(D30,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D30,Helligdage!A$3:A$12,0)),\"\")","v":""},16,"Lørdag","2025-04-19",null,null,null,0,{"$f":"IF(OR(AND(OR(C30=\"mandag\",C30=\"tirsdag\",C30=\"onsdag\",C30=\"torsdag\"),H30>Setup!$F$4),AND(C30=\"fredag\",H30>Setup!$F$5)),MIN(H30-IF(C30=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C30=\"mandag\",C30=\"tirsdag\",C30=\"onsdag\",C30=\"torsdag\"),H30>Setup!$F$4),AND(C30=\"fredag\",H30>Setup!$F$5)),H30-IF(C30=\"fredag\",Setup!$F$5,Setup!$F$4)-I30,0)","v":0},{"$f":"IF(OR(E30=0,F30=0),0,MAX(0,MIN(IF(F30<E30,F30+1,F30),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E30,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E30=0,F30=0),0,MAX(0,MIN(IF(F30<E30,F30+1,F30),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E30,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D31,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D31,Helligdage!A$3:A$12,0)),\"\")","v":"Påskedag"},16,"Søndag","2025-04-20",null,null,null,0,{"$f":"IF(OR(AND(OR(C31=\"mandag\",C31=\"tirsdag\",C31=\"onsdag\",C31=\"torsdag\"),H31>Setup!$F$4),AND(C31=\"fredag\",H31>Setup!$F$5)),MIN(H31-IF(C31=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C31=\"mandag\",C31=\"tirsdag\",C31=\"onsdag\",C31=\"torsdag\"),H31>Setup!$F$4),AND(C31=\"fredag\",H31>Setup!$F$5)),H31-IF(C31=\"fredag\",Setup!$F$5,Setup!$F$4)-I31,0)","v":0},{"$f":"IF(OR(E31=0,F31=0),0,MAX(0,MIN(IF(F31<E31,F31+1,F31),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E31,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E31=0,F31=0),0,MAX(0,MIN(IF(F31<E31,F31+1,F31),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E31,Setup!$F$3))*24)","v":0},0,0]
[{"$f":"IF(NOT(ISERROR(MATCH(D32,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D32,Helligdage!A$3:A$12,0)),\"\")","v":"2.Påskedag"},17,"Mandag","2025-04-21",null,null,null,0,{"$f":"IF(OR(AND(OR(C32=\"mandag\",C32=\"tirsdag\",C32=\"onsdag\",C32=\"torsdag\"),H32>Setup!$F$4),AND(C32=\"fredag\",H32>Setup!$F$5)),MIN(H32-IF(C32=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C32=\"mandag\",C32=\"tirsdag\",C32=\"onsdag\",C32=\"torsdag\"),H32>Setup!$F$4),AND(C32=\"fredag\",H32>Setup!$F$5)),H32-IF(C32=\"fredag\",Setup!$F$5,Setup!$F$4)-I32,0)","v":0},{"$f":"IF(OR(E32=0,F32=0),0,MAX(0,MIN(IF(F32<E32,F32+1,F32),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E32,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E32=0,F32=0),0,MAX(0,MIN(IF(F32<E32,F32+1,F32),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E32,Setup!$F$3))*24)","v":0},"",0]
[{"$f":"IF(NOT(ISERROR(MATCH(D33,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D33,Helligdage!A$3:A$12,0)),\"\")","v":""},17,"Tirsdag","2025-04-22",null,null,null,0,{"$f":"IF(OR(AND(OR(C33=\"mandag\",C33=\"tirsdag\",C33=\"onsdag\",C33=\"torsdag\"),H33>Setup!$F$4),AND(C33=\"fredag\",H33>Setup!$F$5)),MIN(H33-IF(C33=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C33=\"mandag\",C33=\"tirsdag\",C33=\"onsdag\",C33=\"torsdag\"),H33>Setup!$F$4),AND(C33=\"fredag\",H33>Setup!$F$5)),H33-IF(C33=\"fredag\",Setup!$F$5,Setup!$F$4)-I33,0)","v":0},{"$f":"IF(OR(E33=0,F33=0),0,MAX(0,MIN(IF(F33<E33,F33+1,F33),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E33,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E33=0,F33=0),0,MAX(0,MIN(IF(F33<E33,F33+1,F33),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E33,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D34,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D34,Helligdage!A$3:A$12,0)),\"\")","v":""},17,"Onsdag","2025-04-23",null,null,null,0,{"$f":"IF(OR(AND(OR(C34=\"mandag\",C34=\"tirsdag\",C34=\"onsdag\",C34=\"torsdag\"),H34>Setup!$F$4),AND(C34=\"fredag\",H34>Setup!$F$5)),MIN(H34-IF(C34=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C34=\"mandag\",C34=\"tirsdag\",C34=\"onsdag\",C34=\"torsdag\"),H34>Setup!$F$4),AND(C34=\"fredag\",H34>Setup!$F$5)),H34-IF(C34=\"fredag\",Setup!$F$5,Setup!$F$4)-I34,0)","v":0},{"$f":"IF(OR(E34=0,F34=0),0,MAX(0,MIN(IF(F34<E34,F34+1,F34),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E34,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E34=0,F34=0),0,MAX(0,MIN(IF(F34<E34,F34+1,F34),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E34,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D35,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D35,Helligdage!A$3:A$12,0)),\"\")","v":""},17,"Torsdag","2025-04-24",null,null,null,0,{"$f":"IF(OR(AND(OR(C35=\"mandag\",C35=\"tirsdag\",C35=\"onsdag\",C35=\"torsdag\"),H35>Setup!$F$4),AND(C35=\"fredag\",H35>Setup!$F$5)),MIN(H35-IF(C35=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C35=\"mandag\",C35=\"tirsdag\",C35=\"onsdag\",C35=\"torsdag\"),H35>Setup!$F$4),AND(C35=\"fredag\",H35>Setup!$F$5)),H35-IF(C35=\"fredag\",Setup!$F$5,Setup!$F$4)-I35,0)","v":0},{"$f":"IF(OR(E35=0,F35=0),0,MAX(0,MIN(IF(F35<E35,F35+1,F35),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E35,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E35=0,F35=0),0,MAX(0,MIN(IF(F35<E35,F35+1,F35),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E35,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D36,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D36,Helligdage!A$3:A$12,0)),\"\")","v":""},17,"Fredag","2025-04-25",null,null,null,0,{"$f":"IF(OR(AND(OR(C36=\"mandag\",C36=\"tirsdag\",C36=\"onsdag\",C36=\"torsdag\"),H36>Setup!$F$4),AND(C36=\"fredag\",H36>Setup!$F$5)),MIN(H36-IF(C36=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C36=\"mandag\",C36=\"tirsdag\",C36=\"onsdag\",C36=\"torsdag\"),H36>Setup!$F$4),AND(C36=\"fredag\",H36>Setup!$F$5)),H36-IF(C36=\"fredag\",Setup!$F$5,Setup!$F$4)-I36,0)","v":0},{"$f":"IF(OR(E36=0,F36=0),0,MAX(0,MIN(IF(F36<E36,F36+1,F36),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E36,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E36=0,F36=0),0,MAX(0,MIN(IF(F36<E36,F36+1,F36),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E36,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D37,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D37,Helligdage!A$3:A$12,0)),\"\")","v":""},17,"Lørdag","2025-04-26",null,null,null,0,{"$f":"IF(OR(AND(OR(C37=\"mandag\",C37=\"tirsdag\",C37=\"onsdag\",C37=\"torsdag\"),H37>Setup!$F$4),AND(C37=\"fredag\",H37>Setup!$F$5)),MIN(H37-IF(C37=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C37=\"mandag\",C37=\"tirsdag\",C37=\"onsdag\",C37=\"torsdag\"),H37>Setup!$F$4),AND(C37=\"fredag\",H37>Setup!$F$5)),H37-IF(C37=\"fredag\",Setup!$F$5,Setup!$F$4)-I37,0)","v":0},{"$f":"IF(OR(E37=0,F37=0),0,MAX(0,MIN(IF(F37<E37,F37+1,F37),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E37,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E37=0,F37=0),0,MAX(0,MIN(IF(F37<E37,F37+1,F37),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E37,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D38,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D38,Helligdage!A$3:A$12,0)),\"\")","v":""},17,"Søndag","2025-04-27",null,null,null,0,{"$f":"IF(OR(AND(OR(C38=\"mandag\",C38=\"tirsdag\",C38=\"onsdag\",C38=\"torsdag\"),H38>Setup!$F$4),AND(C38=\"fredag\",H38>Setup!$F$5)),MIN(H38-IF(C38=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C38=\"mandag\",C38=\"tirsdag\",C38=\"onsdag\",C38=\"torsdag\"),H38>Setup!$F$4),AND(C38=\"fredag\",H38>Setup!$F$5)),H38-IF(C38=\"fredag\",Setup!$F$5,Setup!$F$4)-I38,0)","v":0},{"$f":"IF(OR(E38=0,F38=0),0,MAX(0,MIN(IF(F38<E38,F38+1,F38),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E38,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E38=0,F38=0),0,MAX(0,MIN(IF(F38<E38,F38+1,F38),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E38,Setup!$F$3))*24)","v":0},0,""]
[{"$f":"IF(NOT(ISERROR(MATCH(D39,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D39,Helligdage!A$3:A$12,0)),\"\")","v":""},18,"Mandag","2025-04-28",null,null,null,0,{"$f":"IF(OR(AND(OR(C39=\"mandag\",C39=\"tirsdag\",C39=\"onsdag\",C39=\"torsdag\"),H39>Setup!$F$4),AND(C39=\"fredag\",H39>Setup!$F$5)),MIN(H39-IF(C39=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C39=\"mandag\",C39=\"tirsdag\",C39=\"onsdag\",C39=\"torsdag\"),H39>Setup!$F$4),AND(C39=\"fredag\",H39>Setup!$F$5)),H39-IF(C39=\"fredag\",Setup!$F$5,Setup!$F$4)-I39,0)","v":0},{"$f":"IF(OR(E39=0,F39=0),0,MAX(0,MIN(IF(F39<E39,F39+1,F39),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E39,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E39=0,F39=0),0,MAX(0,MIN(IF(F39<E39,F39+1,F39),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E39,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D40,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D40,Helligdage!A$3:A$12,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(D40),WEEKNUM(D40,2),\"\")","v":18},{"$f":"PROPER(TEXT(D40,\"dddd\"))","v":"Tirsdag"},"2025-04-29",null,null,null,0,{"$f":"IF(OR(AND(OR(C40=\"mandag\",C40=\"tirsdag\",C40=\"onsdag\",C40=\"torsdag\"),H40>Setup!$F$4),AND(C40=\"fredag\",H40>Setup!$F$5)),MIN(H40-IF(C40=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C40=\"mandag\",C40=\"tirsdag\",C40=\"onsdag\",C40=\"torsdag\"),H40>Setup!$F$4),AND(C40=\"fredag\",H40>Setup!$F$5)),H40-IF(C40=\"fredag\",Setup!$F$5,Setup!$F$4)-I40,0)","v":0},{"$f":"IF(OR(E40=0,F40=0),0,MAX(0,MIN(IF(F40<E40,F40+1,F40),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E40,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E40=0,F40=0),0,MAX(0,MIN(IF(F40<E40,F40+1,F40),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E40,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D41,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D41,Helligdage!A$3:A$12,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(D41),WEEKNUM(D41,2),\"\")","v":18},{"$f":"PROPER(TEXT(D41,\"dddd\"))","v":"Onsdag"},"2025-04-30",null,null,null,0,{"$f":"IF(OR(AND(OR(C41=\"mandag\",C41=\"tirsdag\",C41=\"onsdag\",C41=\"torsdag\"),H41>Setup!$F$4),AND(C41=\"fredag\",H41>Setup!$F$5)),MIN(H41-IF(C41=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C41=\"mandag\",C41=\"tirsdag\",C41=\"onsdag\",C41=\"torsdag\"),H41>Setup!$F$4),AND(C41=\"fredag\",H41>Setup!$F$5)),H41-IF(C41=\"fredag\",Setup!$F$5,Setup!$F$4)-I41,0)","v":0},{"$f":"IF(OR(E41=0,F41=0),0,MAX(0,MIN(IF(F41<E41,F41+1,F41),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E41,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E41=0,F41=0),0,MAX(0,MIN(IF(F41<E41,F41+1,F41),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E41,Setup!$F$3))*24)","v":0},"",""]
[{"$f":"IF(NOT(ISERROR(MATCH(D42,Helligdage!A$3:A$12,0))),INDEX(Helligdage!B$3:B$12,MATCH(D42,Helligdage!A$3:A$12,0)),\"\")","v":""},{"$f":"IF(ISNUMBER(D42),WEEKNUM(D42,2),\"\")","v":""},{"$f":"PROPER(TEXT(D42,\"dddd\"))","v":""},"",null,null,null,0,{"$f":"IF(OR(AND(OR(C42=\"mandag\",C42=\"tirsdag\",C42=\"onsdag\",C42=\"torsdag\"),H42>Setup!$F$4),AND(C42=\"fredag\",H42>Setup!$F$5)),MIN(H42-IF(C42=\"fredag\",Setup!$F$5,Setup!$F$4),3),0)","v":0},{"$f":"IF(OR(AND(OR(C42=\"mandag\",C42=\"tirsdag\",C42=\"onsdag\",C42=\"torsdag\"),H42>Setup!$F$4),AND(C42=\"fredag\",H42>Setup!$F$5)),H42-IF(C42=\"fredag\",Setup!$F$5,Setup!$F$4)-I42,0)","v":0},{"$f":"IF(OR(E42=0,F42=0),0,MAX(0,MIN(IF(F42<E42,F42+1,F42),IF(Setup!$G$2<Setup!$F$2,Setup!$G$2+1,Setup!$G$2))-MAX(E42,Setup!$F$2))*24)","v":0},{"$f":"IF(OR(E42=0,F42=0),0,MAX(0,MIN(IF(F42<E42,F42+1,F42),IF(Setup!$G$3<Setup!$F$3,Setup!$G$3+1,Setup!$G$3))-MAX(E42,Setup!$F$3))*24)","v":0},"",""]
[null,null,null,null,null,null,{"$f":"SUM(G12:G42)","v":0},{"$f":"SUM(H12:H42)","v":0},0,0,0,0,0,0,{"$f":"SUM(O12:O42)","v":"00:00:00"},{"$f":"SUM(P12:P42)","v":"00:00:00"},{"$f":"SUM(Q12:Q42)","v":0},{"$f":"SUM(R12:R42)","v":0},{"$f":"SUM(S12:S42)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(Setup!A6=\"vis\",H43*Overenskomst!C7,\"-\")","v":"-"},{"$f":"IF(Setup!A6=\"vis\",I43*Overenskomst!C20,\"-\")","v":"-"},{"$f":"IF(Setup!A6=\"vis\",J43*Overenskomst!C21,\"-\")","v":"-"},{"$f":"IF(Setup!A6=\"vis\",K43*Overenskomst!C14,\"-\")","v":"-"},{"$f":"IF(Setup!A6=\"vis\",L43*Overenskomst!C15,\"-\")","v":"-"},{"$f":"IF(Setup!A6=\"vis\",M43*Overenskomst!C16,\"-\")","v":"-"},{"$f":"IF(Setup!A6=\"vis\",N43*Overenskomst!C16,\"-\")","v":"-"}]

{"sheet":"Overenskomst","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Overenskomst satser afdeling","Rengøring"]
[]
[null,"Tekst  fra overenskomst","2023-03-15","Bemærkning"]
[null,"Kludevask",139.53,"aftalt fast timepris uden tillæg"]
[null,"Transporttid timesats",136.11000000000001,"køretid fra hjem til arbejdsplads i egen bil u/ tillæg"]
[null,"Præstationsløn (normaltimer)",164.86,"udgangspunkt i løn med tillæg"]
[null,"Servicetillæg",3.65,"NB! Kun ansatte før 1. sep 2017"]
[null,"Anciennitesttillæg",4.6500000000000004,"NB! Efter 1 års ansættelse (ansatte før 1.sep 2017)"]
[null,"Brancheanciennitetstillæg efter 36 md.",9.3000000000000007,"Træder i kraft d. 15 nevember 2023 kr.9,30"]
[null,"Brancheanciennitetstillæg 12 - 18 md.",5.54,"Model 2: Intet servicetillæg og anciennitetstillæg"]
[null,"Brancheanciennitetstillæg Eft. 18 md.",8.3000000000000007,"Model 2: Intet servicetillæg og anciennitetstillæg"]
[null,"Serviceassistent tillæg",4,"uddannet/ tillæg som præstationsløn"]
[null,"Aftentillæg - se setup fane",16.989999999999998,"tillæg mellem kl. 18 - 22"]
[null,"Nattillæg - se setup fane      ",22.12,"tillæg mellem kl. 22 - 05"]
[null,"Søn-helligdag  ",24.55,"tillæg mellem kl. 00,00 - 24,00"]
[null,"Hovedrengøring",7.13,"tillæg for ekstra rengøring"]
[null,"Genetillæg",4.71,"ved specielle gene rengøringer"]
[null,"Skurtillæg",3.11]
[null,"Overtid 50% 1-3 timer",43.59]
[null,"Overtid 100% over 3 timer",87.18]
[null,"Kørsel indtil 30 km",4]
[null,"Kørsel over 30 km ",6]
[null,"Kørsel over 30 km",null,"datoer:"]
[null,"Udbetaling sh beløb 1 dag",950,"datoer:"]
[null,"Fritvalgsbetaling beløb",null,"udbetales juni og december"]
[null,"Pension",null,"M:2% - V:10,15 = 12,15%"]
[null,"Pension 10 års Anciennitet/Barsel",null,"M: 0,2% - V:0,4% = 0,6% 10 år /Barsel"]
[]
[]
[null,"1 Maj 12:00 - 24:00",23.72,"1 Maj tillæg pr time"]
[null,"Antal ansættelses dage inden pension"]
[]
[null,null,"07:50:00"]

{"sheet":"Medarbejder","index":2,"n_rows":3,"n_cols":12,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,11]]}
["Medarbejder",null,null,null,null,null,null,"Firma Oplysninger"]
["Medarbejder nummer","Navn","Cpr nummer","Vejnavn","By","Postnummer",null,"Firma","Adresse","By","Postnummer","Kontaktperson"]
[1,"????","????","????","????","????",null,"???","???","???","???","???"]

{"sheet":"Helligdage","index":3,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":true,"merged":[[1,0,1,1]]}
[{"$f":"Timer!B2","v":2025},null,"Palmesøndag",null,"Hvis disse  tekster og koder ændres vil det have fatal indflydelse på opsætningen af arket \"Timer\""]
["Helligdage til timeregistrering",null,{"$f":"PalmSunday(A1)","v":"2025-04-13"}]
[{"$f":"C2+4","v":"2025-04-17"},"Skærtorsdag"]
[{"$f":"C2+5","v":"2025-04-18"},"Langfredag"]
[{"$f":"C2+7","v":"2025-04-20"},"Påskedag"]
[{"$f":"C2+8","v":"2025-04-21"},"2.Påskedag"]
[{"$f":"C2+46","v":"2025-05-29"},"Kr.Himmelfartsdag"]
[{"$f":"C2+56","v":"2025-06-08"},"Pinsedag"]
[{"$f":"C2+57","v":"2025-06-09"},"2. Pinsedag"]
[{"$f":"DATE(A1,12,25)","v":"2025-12-25"},"Juledag"]
[{"$f":"DATE(A1,12,26)","v":"2025-12-26"},"2 Juledag"]
[{"$f":"DATE(A1,1,1)","v":"2025-01-01"},"Nytårsdag"]
[]
["Måneder","Hvis i Kolonne A "]
["Januar","Syg"]
["Februar","Barn syg"]
["Marts","Ferie"]
["April","Feriefridag"]
["Maj","Barsel"]
["Juni"]
["Juli"]
["August"]
["September"]
["Oktober"]
["November"]
["December"]

{"sheet":"Timeseddel","index":4,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[[9,0,10,0],[7,5,7,6],[9,1,10,1],[9,5,10,5],[2,5,2,7],[3,5,3,7],[4,5,4,7],[5,5,5,7],[6,5,6,7],[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[9,6,10,6],[9,2,10,2],[1,4,1,7],[0,12,0,13],[9,9,10,9],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,13,10,13],[9,8,10,8],[9,7,10,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-04-07"}]
["Start Dato",{"$f":"Timer!B2","v":2025},{"$f":"Timer!C2","v":"April"},null,"Firma Oplysninger"]
["Medarbejder",{"$f":"Timer!C3","v":1},null,null,"Firma",{"$f":"IF(Setup!A8=\"vis\",Medarbejder!H3,\"-\")","v":"-"}]
["Cpr nr:",{"$f":"Timer!C4","v":"????"},null,null,"Adresse",{"$f":"IF(Setup!A8=\"vis\",Medarbejder!I3,\"-\")","v":"-"}]
["Navn",{"$f":"Timer!C5","v":"????"},null,null,"By",{"$f":"IF(Setup!A8=\"vis\",Medarbejder!J3,\"-\")","v":"-"}]
["Adresse",{"$f":"Timer!C6","v":"????"},null,null,"Postnummer",{"$f":"IF(Setup!A8=\"vis\",Medarbejder!K3,\"-\")","v":"-"}]
["By",{"$f":"Timer!C7","v":"????"},null,null,"Kontaktperson",{"$f":"IF(Setup!A8=\"vis\",Medarbejder!L3,\"-\")","v":"-"}]
["Postnr:",{"$f":"Timer!C8","v":"????"}]
[]
["Dato","Normaltimer","Pause","Overtid 50%","Overtid 100%","Aftentimer","nat timer","Søndage","Helligdage","Sygetimer","Barsel","Feriefridag","Ferie","Barn syg"]
[null,null,null,"1-3 timer","Over 3 timer"]
[{"$f":"Timer!D12","v":"2025-04-01"},{"$f":"Timer!H12","v":0},{"$f":"Timer!G12","v":0},{"$f":"Timer!I12","v":0},{"$f":"Timer!J12","v":0},{"$f":"Timer!K12","v":0},{"$f":"Timer!L12","v":0},{"$f":"Timer!M12","v":""},{"$f":"Timer!N12","v":""},{"$f":"Timer!O12","v":"00:00:00"},{"$f":"Timer!P12","v":"00:00:00"},{"$f":"Timer!Q12","v":0},{"$f":"Timer!R12","v":0},{"$f":"Timer!S12","v":0}]
[{"$f":"Timer!D13","v":"2025-04-02"},{"$f":"Timer!H13","v":0},{"$f":"Timer!G13","v":0},{"$f":"Timer!I13","v":0},{"$f":"Timer!J13","v":0},{"$f":"Timer!K13","v":0},{"$f":"Timer!L13","v":0},{"$f":"Timer!M13","v":""},{"$f":"Timer!N13","v":""},{"$f":"Timer!O13","v":"00:00:00"},{"$f":"Timer!P13","v":"00:00:00"},{"$f":"Timer!Q13","v":0},{"$f":"Timer!R13","v":0},{"$f":"Timer!S13","v":0}]
[{"$f":"Timer!D14","v":"2025-04-03"},{"$f":"Timer!H14","v":0},{"$f":"Timer!G14","v":0},{"$f":"Timer!I14","v":0},{"$f":"Timer!J14","v":0},{"$f":"Timer!K14","v":0},{"$f":"Timer!L14","v":0},{"$f":"Timer!M14","v":""},{"$f":"Timer!N14","v":""},{"$f":"Timer!O14","v":"00:00:00"},{"$f":"Timer!P14","v":"00:00:00"},{"$f":"Timer!Q14","v":0},{"$f":"Timer!R14","v":0},{"$f":"Timer!S14","v":0}]
[{"$f":"Timer!D15","v":"2025-04-04"},{"$f":"Timer!H15","v":0},{"$f":"Timer!G15","v":0},{"$f":"Timer!I15","v":0},{"$f":"Timer!J15","v":0},{"$f":"Timer!K15","v":0},{"$f":"Timer!L15","v":0},{"$f":"Timer!M15","v":""},{"$f":"Timer!N15","v":""},{"$f":"Timer!O15","v":"00:00:00"},{"$f":"Timer!P15","v":"00:00:00"},{"$f":"Timer!Q15","v":0},{"$f":"Timer!R15","v":0},{"$f":"Timer!S15","v":0}]
[{"$f":"Timer!D16","v":"2025-04-05"},{"$f":"Timer!H16","v":0},{"$f":"Timer!G16","v":0},{"$f":"Timer!I16","v":0},{"$f":"Timer!J16","v":0},{"$f":"Timer!K16","v":0},{"$f":"Timer!L16","v":0},{"$f":"Timer!M16","v":""},{"$f":"Timer!N16","v":""},{"$f":"Timer!O16","v":"00:00:00"},{"$f":"Timer!P16","v":"00:00:00"},{"$f":"Timer!Q16","v":0},{"$f":"Timer!R16","v":0},{"$f":"Timer!S16","v":0}]
[{"$f":"Timer!D17","v":"2025-04-06"},{"$f":"Timer!H17","v":0},{"$f":"Timer!G17","v":0},{"$f":"Timer!I17","v":0},{"$f":"Timer!J17","v":0},{"$f":"Timer!K17","v":0},{"$f":"Timer!L17","v":0},{"$f":"Timer!M17","v":0},{"$f":"Timer!N17","v":""},{"$f":"Timer!O17","v":"00:00:00"},{"$f":"Timer!P17","v":"00:00:00"},{"$f":"Timer!Q17","v":0},{"$f":"Timer!R17","v":0},{"$f":"Timer!S17","v":0}]
[{"$f":"Timer!D18","v":"2025-04-07"},{"$f":"Timer!H18","v":0},{"$f":"Timer!G18","v":0},{"$f":"Timer!I18","v":0},{"$f":"Timer!J18","v":0},{"$f":"Timer!K18","v":0},{"$f":"Timer!L18","v":0},{"$f":"Timer!M18","v":""},{"$f":"Timer!N18","v":""},{"$f":"Timer!O18","v":"00:00:00"},{"$f":"Timer!P18","v":"00:00:00"},{"$f":"Timer!Q18","v":0},{"$f":"Timer!R18","v":0},{"$f":"Timer!S18","v":0}]
[{"$f":"Timer!D19","v":"2025-04-08"},{"$f":"Timer!H19","v":0},{"$f":"Timer!G19","v":0},{"$f":"Timer!I19","v":0},{"$f":"Timer!J19","v":0},{"$f":"Timer!K19","v":0},{"$f":"Timer!L19","v":0},{"$f":"Timer!M19","v":""},{"$f":"Timer!N19","v":""},{"$f":"Timer!O19","v":"00:00:00"},{"$f":"Timer!P19","v":"00:00:00"},{"$f":"Timer!Q19","v":0},{"$f":"Timer!R19","v":0},{"$f":"Timer!S19","v":0}]
[{"$f":"Timer!D20","v":"2025-04-09"},{"$f":"Timer!H20","v":0},{"$f":"Timer!G20","v":0},{"$f":"Timer!I20","v":0},{"$f":"Timer!J20","v":0},{"$f":"Timer!K20","v":0},{"$f":"Timer!L20","v":0},{"$f":"Timer!M20","v":""},{"$f":"Timer!N20","v":""},{"$f":"Timer!O20","v":"00:00:00"},{"$f":"Timer!P20","v":"00:00:00"},{"$f":"Timer!Q20","v":0},{"$f":"Timer!R20","v":0},{"$f":"Timer!S20","v":0}]
[{"$f":"Timer!D21","v":"2025-04-10"},{"$f":"Timer!H21","v":0},{"$f":"Timer!G21","v":0},{"$f":"Timer!I21","v":0},{"$f":"Timer!J21","v":0},{"$f":"Timer!K21","v":0},{"$f":"Timer!L21","v":0},{"$f":"Timer!M21","v":""},{"$f":"Timer!N21","v":""},{"$f":"Timer!O21","v":"00:00:00"},{"$f":"Timer!P21","v":"00:00:00"},{"$f":"Timer!Q21","v":0},{"$f":"Timer!R21","v":0},{"$f":"Timer!S21","v":0}]
[{"$f":"Timer!D22","v":"2025-04-11"},{"$f":"Timer!H22","v":0},{"$f":"Timer!G22","v":0},{"$f":"Timer!I22","v":0},{"$f":"Timer!J22","v":0},{"$f":"Timer!K22","v":0},{"$f":"Timer!L22","v":0},{"$f":"Timer!M22","v":""},{"$f":"Timer!N22","v":""},{"$f":"Timer!O22","v":"00:00:00"},{"$f":"Timer!P22","v":"00:00:00"},{"$f":"Timer!Q22","v":0},{"$f":"Timer!R22","v":0},{"$f":"Timer!S22","v":0}]
[{"$f":"Timer!D23","v":"2025-04-12"},{"$f":"Timer!H23","v":0},{"$f":"Timer!G23","v":0},{"$f":"Timer!I23","v":0},{"$f":"Timer!J23","v":0},{"$f":"Timer!K23","v":0},{"$f":"Timer!L23","v":0},{"$f":"Timer!M23","v":""},{"$f":"Timer!N23","v":""},{"$f":"Timer!O23","v":"00:00:00"},{"$f":"Timer!P23","v":"00:00:00"},{"$f":"Timer!Q23","v":0},{"$f":"Timer!R23","v":0},{"$f":"Timer!S23","v":0}]
[{"$f":"Timer!D24","v":"2025-04-13"},{"$f":"Timer!H24","v":0},{"$f":"Timer!G24","v":0},{"$f":"Timer!I24","v":0},{"$f":"Timer!J24","v":0},{"$f":"Timer!K24","v":0},{"$f":"Timer!L24","v":0},{"$f":"Timer!M24","v":0},{"$f":"Timer!N24","v":""},{"$f":"Timer!O24","v":"00:00:00"},{"$f":"Timer!P24","v":"00:00:00"},{"$f":"Timer!Q24","v":0},{"$f":"Timer!R24","v":0},{"$f":"Timer!S24","v":0}]
[{"$f":"Timer!D25","v":"2025-04-14"},{"$f":"Timer!H25","v":0},{"$f":"Timer!G25","v":0},{"$f":"Timer!I25","v":0},{"$f":"Timer!J25","v":0},{"$f":"Timer!K25","v":0},{"$f":"Timer!L25","v":0},{"$f":"Timer!M25","v":""},{"$f":"Timer!N25","v":""},{"$f":"Timer!O25","v":"00:00:00"},{"$f":"Timer!P25","v":"00:00:00"},{"$f":"Timer!Q25","v":0},{"$f":"Timer!R25","v":0},{"$f":"Timer!S25","v":0}]
[{"$f":"Timer!D26","v":"2025-04-15"},{"$f":"Timer!H26","v":0},{"$f":"Timer!G26","v":0},{"$f":"Timer!I26","v":0},{"$f":"Timer!J26","v":0},{"$f":"Timer!K26","v":0},{"$f":"Timer!L26","v":0},{"$f":"Timer!M26","v":""},{"$f":"Timer!N26","v":""},{"$f":"Timer!O26","v":"00:00:00"},{"$f":"Timer!P26","v":"00:00:00"},{"$f":"Timer!Q26","v":0},{"$f":"Timer!R26","v":0},{"$f":"Timer!S26","v":0}]
[{"$f":"Timer!D27","v":"2025-04-16"},{"$f":"Timer!H27","v":0},{"$f":"Timer!G27","v":0},{"$f":"Timer!I27","v":0},{"$f":"Timer!J27","v":0},{"$f":"Timer!K27","v":0},{"$f":"Timer!L27","v":0},{"$f":"Timer!M27","v":""},{"$f":"Timer!N27","v":""},{"$f":"Timer!O27","v":"00:00:00"},{"$f":"Timer!P27","v":"00:00:00"},{"$f":"Timer!Q27","v":0},{"$f":"Timer!R27","v":0},{"$f":"Timer!S27","v":0}]
[{"$f":"Timer!D28","v":"2025-04-17"},{"$f":"Timer!H28","v":0},{"$f":"Timer!G28","v":0},{"$f":"Timer!I28","v":0},{"$f":"Timer!J28","v":0},{"$f":"Timer!K28","v":0},{"$f":"Timer!L28","v":0},{"$f":"Timer!M28","v":""},{"$f":"Timer!N28","v":0},{"$f":"Timer!O28","v":"00:00:00"},{"$f":"Timer!P28","v":"00:00:00"},{"$f":"Timer!Q28","v":0},{"$f":"Timer!R28","v":0},{"$f":"Timer!S28","v":0}]
[{"$f":"Timer!D29","v":"2025-04-18"},{"$f":"Timer!H29","v":0},{"$f":"Timer!G29","v":0},{"$f":"Timer!I29","v":0},{"$f":"Timer!J29","v":0},{"$f":"Timer!K29","v":0},{"$f":"Timer!L29","v":0},{"$f":"Timer!M29","v":""},{"$f":"Timer!N29","v":0},{"$f":"Timer!O29","v":"00:00:00"},{"$f":"Timer!P29","v":"00:00:00"},{"$f":"Timer!Q29","v":0},{"$f":"Timer!R29","v":0},{"$f":"Timer!S29","v":0}]
[{"$f":"Timer!D30","v":"2025-04-19"},{"$f":"Timer!H30","v":0},{"$f":"Timer!G30","v":0},{"$f":"Timer!I30","v":0},{"$f":"Timer!J30","v":0},{"$f":"Timer!K30","v":0},{"$f":"Timer!L30","v":0},{"$f":"Timer!M30","v":""},{"$f":"Timer!N30","v":""},{"$f":"Timer!O30","v":"00:00:00"},{"$f":"Timer!P30","v":"00:00:00"},{"$f":"Timer!Q30","v":0},{"$f":"Timer!R30","v":0},{"$f":"Timer!S30","v":0}]
[{"$f":"Timer!D31","v":"2025-04-20"},{"$f":"Timer!H31","v":0},{"$f":"Timer!G31","v":0},{"$f":"Timer!I31","v":0},{"$f":"Timer!J31","v":0},{"$f":"Timer!K31","v":0},{"$f":"Timer!L31","v":0},{"$f":"Timer!M31","v":0},{"$f":"Timer!N31","v":0},{"$f":"Timer!O31","v":"00:00:00"},{"$f":"Timer!P31","v":"00:00:00"},{"$f":"Timer!Q31","v":0},{"$f":"Timer!R31","v":0},{"$f":"Timer!S31","v":0}]
[{"$f":"Timer!D32","v":"2025-04-21"},{"$f":"Timer!H32","v":0},{"$f":"Timer!G32","v":0},{"$f":"Timer!I32","v":0},{"$f":"Timer!J32","v":0},{"$f":"Timer!K32","v":0},{"$f":"Timer!L32","v":0},{"$f":"Timer!M32","v":""},{"$f":"Timer!N32","v":0},{"$f":"Timer!O32","v":"00:00:00"},{"$f":"Timer!P32","v":"00:00:00"},{"$f":"Timer!Q32","v":0},{"$f":"Timer!R32","v":0},{"$f":"Timer!S32","v":0}]
[{"$f":"Timer!D33","v":"2025-04-22"},{"$f":"Timer!H33","v":0},{"$f":"Timer!G33","v":0},{"$f":"Timer!I33","v":0},{"$f":"Timer!J33","v":0},{"$f":"Timer!K33","v":0},{"$f":"Timer!L33","v":0},{"$f":"Timer!M33","v":""},{"$f":"Timer!N33","v":""},{"$f":"Timer!O33","v":"00:00:00"},{"$f":"Timer!P33","v":"00:00:00"},{"$f":"Timer!Q33","v":0},{"$f":"Timer!R33","v":0},{"$f":"Timer!S33","v":0}]
[{"$f":"Timer!D34","v":"2025-04-23"},{"$f":"Timer!H34","v":0},{"$f":"Timer!G34","v":0},{"$f":"Timer!I34","v":0},{"$f":"Timer!J34","v":0},{"$f":"Timer!K34","v":0},{"$f":"Timer!L34","v":0},{"$f":"Timer!M34","v":""},{"$f":"Timer!N34","v":""},{"$f":"Timer!O34","v":"00:00:00"},{"$f":"Timer!P34","v":"00:00:00"},{"$f":"Timer!Q34","v":0},{"$f":"Timer!R34","v":0},{"$f":"Timer!S34","v":0}]
[{"$f":"Timer!D35","v":"2025-04-24"},{"$f":"Timer!H35","v":0},{"$f":"Timer!G35","v":0},{"$f":"Timer!I35","v":0},{"$f":"Timer!J35","v":0},{"$f":"Timer!K35","v":0},{"$f":"Timer!L35","v":0},{"$f":"Timer!M35","v":""},{"$f":"Timer!N35","v":""},{"$f":"Timer!O35","v":"00:00:00"},{"$f":"Timer!P35","v":"00:00:00"},{"$f":"Timer!Q35","v":0},{"$f":"Timer!R35","v":0},{"$f":"Timer!S35","v":0}]
[{"$f":"Timer!D36","v":"2025-04-25"},{"$f":"Timer!H36","v":0},{"$f":"Timer!G36","v":0},{"$f":"Timer!I36","v":0},{"$f":"Timer!J36","v":0},{"$f":"Timer!K36","v":0},{"$f":"Timer!L36","v":0},{"$f":"Timer!M36","v":""},{"$f":"Timer!N36","v":""},{"$f":"Timer!O36","v":"00:00:00"},{"$f":"Timer!P36","v":"00:00:00"},{"$f":"Timer!Q36","v":0},{"$f":"Timer!R36","v":0},{"$f":"Timer!S36","v":0}]
[{"$f":"Timer!D37","v":"2025-04-26"},{"$f":"Timer!H37","v":0},{"$f":"Timer!G37","v":0},{"$f":"Timer!I37","v":0},{"$f":"Timer!J37","v":0},{"$f":"Timer!K37","v":0},{"$f":"Timer!L37","v":0},{"$f":"Timer!M37","v":""},{"$f":"Timer!N37","v":""},{"$f":"Timer!O37","v":"00:00:00"},{"$f":"Timer!P37","v":"00:00:00"},{"$f":"Timer!Q37","v":0},{"$f":"Timer!R37","v":0},{"$f":"Timer!S37","v":0}]
[{"$f":"Timer!D38","v":"2025-04-27"},{"$f":"Timer!H38","v":0},{"$f":"Timer!G38","v":0},{"$f":"Timer!I38","v":0},{"$f":"Timer!J38","v":0},{"$f":"Timer!K38","v":0},{"$f":"Timer!L38","v":0},{"$f":"Timer!M38","v":0},{"$f":"Timer!N38","v":""},{"$f":"Timer!O38","v":"00:00:00"},{"$f":"Timer!P38","v":"00:00:00"},{"$f":"Timer!Q38","v":0},{"$f":"Timer!R38","v":0},{"$f":"Timer!S38","v":0}]
[{"$f":"Timer!D39","v":"2025-04-28"},{"$f":"Timer!H39","v":0},{"$f":"Timer!G39","v":0},{"$f":"Timer!I39","v":0},{"$f":"Timer!J39","v":0},{"$f":"Timer!K39","v":0},{"$f":"Timer!L39","v":0},{"$f":"Timer!M39","v":""},{"$f":"Timer!N39","v":""},{"$f":"Timer!O39","v":"00:00:00"},{"$f":"Timer!P39","v":"00:00:00"},{"$f":"Timer!Q39","v":0},{"$f":"Timer!R39","v":0},{"$f":"Timer!S39","v":0}]
[{"$f":"Timer!D40","v":"2025-04-29"},{"$f":"Timer!H40","v":0},{"$f":"Timer!G40","v":0},{"$f":"Timer!I40","v":0},{"$f":"Timer!J40","v":0},{"$f":"Timer!K40","v":0},{"$f":"Timer!L40","v":0},{"$f":"Timer!M40","v":""},{"$f":"Timer!N40","v":""},{"$f":"Timer!O40","v":"00:00:00"},{"$f":"Timer!P40","v":"00:00:00"},{"$f":"Timer!Q40","v":0},{"$f":"Timer!R40","v":0},{"$f":"Timer!S40","v":0}]
[{"$f":"Timer!D41","v":"2025-04-30"},{"$f":"Timer!H41","v":0},{"$f":"Timer!G41","v":0},{"$f":"Timer!I41","v":0},{"$f":"Timer!J41","v":0},{"$f":"Timer!K41","v":0},{"$f":"Timer!L41","v":0},{"$f":"Timer!M41","v":""},{"$f":"Timer!N41","v":""},{"$f":"Timer!O41","v":"00:00:00"},{"$f":"Timer!P41","v":"00:00:00"},{"$f":"Timer!Q41","v":0},{"$f":"Timer!R41","v":0},{"$f":"Timer!S41","v":0}]
[{"$f":"Timer!D42","v":""},{"$f":"Timer!H42","v":0},{"$f":"Timer!G42","v":0},{"$f":"Timer!I42","v":0},{"$f":"Timer!J42","v":0},{"$f":"Timer!K42","v":0},{"$f":"Timer!L42","v":0},{"$f":"Timer!M42","v":""},{"$f":"Timer!N42","v":""},{"$f":"Timer!O42","v":"00:00:00"},{"$f":"Timer!P42","v":"00:00:00"},{"$f":"Timer!Q42","v":0},{"$f":"Timer!R42","v":0},{"$f":"Timer!S42","v":0}]
["Total ",{"$f":"SUM(B12:B42)","v":0},{"$f":"SUM(C12:C42)","v":0},0,0,0,0,0,0,{"$f":"SUM(J12:J42)","v":"00:00:00"},{"$f":"SUM(K12:K42)","v":"00:00:00"},{"$f":"SUM(L12:L42)","v":0},{"$f":"SUM(M12:M42)","v":0},{"$f":"SUM(N12:N42)","v":0}]

{"sheet":"Setup","index":5,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Opsætning af mailadresse, sender timeseddel som mail",null,"Måned",null,null,"Start","Slut"]
["Mailadresse",null,null,null,"aftenarbejde","18:00:00","22:00:00","Ændre start og slut tid for aftenarbejde"]
["Meddelelse","            ",{"$f":"Timer!C2","v":"April"},null,"Natarbejde","22:00:00","05:00:00","Ændre start og slut tid for for natarbejde"]
["Afsender",null,null,null,"Overarbejde man,tir,ons,torsdag",7.5,null,"Ændre timerne fra hvornår overarbejde begynder",{"$f":"Overenskomst!B20","v":"Overtid 50% 1-3 timer"},{"$f":"Overenskomst!B21","v":"Overtid 100% over 3 timer"}]
[null,null,null,null,"overarbejde Fredag efter ",7,null,"Ændre timerne fra hvornår overarbejde begynder",{"$f":"Overenskomst!B20","v":"Overtid 50% 1-3 timer"},{"$f":"Overenskomst!B21","v":"Overtid 100% over 3 timer"}]
["Vis ikke","Vælg \"Vis\" hvis du se beløbet under timer, regner efter arket overenskomst."]
[]
["Vis ikke","Her kan du vælge om du vil vise firmanavn på timesedlen"]

{"sheet":"job","index":6,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,1,9,6],[5,1,5,2]]}
[null,null,null,"Arbejdsseddel"]
[null,"Dato","2025-04-11"]
[null,"Arbejdssted"]
[null,"Firma","Adresse","By","Postnr.","Kontaktperson","Tlfnr."]
[null,"Arbejdsgiver","Vejnavn","byen","posnr","personen"]
[null,"Arbejdsbeskrivelse"]
[null,"Dette felt bruges til at beskrive opgaven"]
[]
[]
[]
[]
[null,"Mødetid","07:00:00"]
[null,"Sluttid","23:00:00"]
[null,"Pause ",0.25]