{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Juni2010 (2)","september2010","Tomt","Satser","norm","Ark2","Ark3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Juni2010 (2)","index":0,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":false,"merged":[[43,0,43,3],[0,1,0,5],[0,16,0,17],[39,0,39,3],[40,0,40,3],[41,0,41,3],[42,0,42,3],[2,1,2,2],[1,1,1,2]]}
["Løn","1 juni 2010 - 30 juni 2010",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time beregning:"]
["Lønart",null,null,null,null,null,3025,3425,3426,3600,3602,3605,3610,9091,9092,null,"Betalt pause ved vagt over 5 timer",null,null,null,"00:25:00","minutter","00:00:00","06:00:00","18:00:00","14:00:00"]
["Dato","Dag",null,"Vagt","Start","Slut","Time SID","Overtid           1-3 time","Overtid            4 - time","Aftenstillæg","Nattillæg     00-06","Søndags tillæg","Delt tjenste"]
["2010-04-01",{"$f":"PROPER(TEXT(A4,\"ddd\"))","v":"To"},{"$f":"HelligdagsNavn(A4,0,0)","v":"Skærtorsdag"},111,{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,#REF!,2)=0,\"\",VLOOKUP($D4,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,#REF!,3)=\"\",\"\",VLOOKUP($D4,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D4=\"\",\"\",VLOOKUP($D4,#REF!,13))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(E4<>\"\",IF(WEEKDAY(A4,2)<>6,IF(E4>F4,(F4-MAX(E4,(18/24))+(E4>F4))-F4,IF(F4>Y$2,(F4-MAX(E4,(18/24))),\"\")),IF(E4>F4,(F4-MAX(E4,(14/24))+(E4>F4))-F4,IF(F4>Z$2,(F4-MAX(E4,(14/24))),\"\"))),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(G4<>\"\",IF(S4<X$2,(X$2-S4),IF(V4<X$2,(V4-W$2),\"\")),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(G4<>0,IF(WEEKDAY(A4,2)=7,G4,\"\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,#REF!,15)=\"\",\"\",VLOOKUP($D4,#REF!,15)))","v":{"$error":"#REF!"}},{"$f":"IF(SUM(H4:I4)=0,\"\",SUM(H4:I4))","v":""},null,null,{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":{"$error":"#REF!"}},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":{"$error":"#REF!"}},{"$f":"IF(E4=\"\",\"\",TIME(HOUR(E4),MINUTE(E4),0))","v":{"$error":"#REF!"}},{"$f":"IF(F4=\"\",\"\",HOUR(F4))","v":{"$error":"#REF!"}},{"$f":"IF(F4=\"\",\"\",MINUTE(F4))","v":{"$error":"#REF!"}},{"$f":"TIME(HOUR(F4),MINUTE(F4),0)","v":{"$error":"#REF!"}}]
["2010-04-02",{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Fr"},{"$f":"HelligdagsNavn(A5,0,0)","v":"Langfredag"},134,{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,#REF!,2)=0,\"\",VLOOKUP($D5,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,#REF!,3)=\"\",\"\",VLOOKUP($D5,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D5=\"\",\"\",VLOOKUP($D5,#REF!,13))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(E5<>\"\",IF(WEEKDAY(A5,2)<>6,IF(E5>F5,(F5-MAX(E5,(18/24))+(E5>F5))-F5,IF(F5>Y$2,(F5-MAX(E5,(18/24))),\"\")),IF(E5>F5,(F5-MAX(E5,(14/24))+(E5>F5))-F5,IF(F5>Z$2,(F5-MAX(E5,(14/24))),\"\"))),\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(G5<>0,IF(WEEKDAY(A5,2)=7,G5,\"\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,#REF!,15)=\"\",\"\",VLOOKUP($D5,#REF!,15)))","v":{"$error":"#REF!"}},{"$f":"IF(SUM(H5:I5)=0,\"\",SUM(H5:I5))","v":""},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"TIME(HOUR(F5),MINUTE(F5),0)","v":{"$error":"#REF!"}}]
["2010-04-03",{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"Lø"},"",612,{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,#REF!,2)=0,\"\",VLOOKUP($D6,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,#REF!,3)=\"\",\"\",VLOOKUP($D6,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D6=\"\",\"\",VLOOKUP($D6,#REF!,13))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(E6<>\"\",IF(WEEKDAY(A6,2)<>6,IF(E6>F6,(F6-MAX(E6,(18/24))+(E6>F6))-F6,IF(F6>Y$2,(F6-MAX(E6,(18/24))),\"\")),IF(E6>F6,(F6-MAX(E6,(14/24))+(E6>F6))-F6,IF(F6>Z$2,(F6-MAX(E6,(14/24))),\"\"))),\"\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,#REF!,15)=\"\",\"\",VLOOKUP($D6,#REF!,15)))","v":{"$error":"#REF!"}},"",null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"TIME(HOUR(F6),MINUTE(F6),0)","v":{"$error":"#REF!"}}]
["2010-04-04","Sø","Påskedag",711,{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,2)=0,\"\",VLOOKUP($D7,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,3)=\"\",\"\",VLOOKUP($D7,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,#REF!,13))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,15)=\"\",\"\",VLOOKUP($D7,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,16)=\"\",\"\",VLOOKUP($D7,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"TIME(HOUR(F7),MINUTE(F7),0)","v":{"$error":"#REF!"}}]
["2010-04-05","Ma","2. Påskedag",122,{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,2)=0,\"\",VLOOKUP($D8,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,3)=\"\",\"\",VLOOKUP($D8,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D8=\"\",\"\",VLOOKUP($D8,#REF!,13))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,15)=\"\",\"\",VLOOKUP($D8,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,16)=\"\",\"\",VLOOKUP($D8,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"TIME(HOUR(F8),MINUTE(F8),0)","v":{"$error":"#REF!"}}]
["2010-04-06","Ti","",124,{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,2)=0,\"\",VLOOKUP($D9,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,3)=\"\",\"\",VLOOKUP($D9,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,#REF!,13))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(G9<>0,IF(WEEKDAY(A9,2)=7,G9,\"\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,15)=\"\",\"\",VLOOKUP($D9,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,16)=\"\",\"\",VLOOKUP($D9,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(F9=\"\",\"\",TIME(HOUR(F9),MINUTE(F9),0))","v":{"$error":"#REF!"}}]
["2010-04-07","On","",606,{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,2)=0,\"\",VLOOKUP($D10,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,3)=\"\",\"\",VLOOKUP($D10,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,13)=\"\",\"\",VLOOKUP($D10,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(G10<>0,IF(WEEKDAY(A10,2)=7,G10,\"\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,15)=\"\",\"\",VLOOKUP($D10,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,16)=\"\",\"\",VLOOKUP($D10,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-08","To","",122,{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,2)=0,\"\",VLOOKUP($D11,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,3)=\"\",\"\",VLOOKUP($D11,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,13)=\"\",\"\",VLOOKUP($D11,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(G11<>0,IF(WEEKDAY(A11,2)=7,G11,\"\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,15)=\"\",\"\",VLOOKUP($D11,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,16)=\"\",\"\",VLOOKUP($D11,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-09","Fr","","afsp.",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,2)=0,\"\",VLOOKUP($D12,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,3)=\"\",\"\",VLOOKUP($D12,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,13)=\"\",\"\",VLOOKUP($D12,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,15)=\"\",\"\",VLOOKUP($D12,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,16)=\"\",\"\",VLOOKUP($D12,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-10","Lø","",121,{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,2)=0,\"\",VLOOKUP($D13,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,3)=\"\",\"\",VLOOKUP($D13,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,13)=\"\",\"\",VLOOKUP($D13,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,15)=\"\",\"\",VLOOKUP($D13,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,16)=\"\",\"\",VLOOKUP($D13,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-11","Sø","",606,{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,2)=0,\"\",VLOOKUP($D14,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,3)=\"\",\"\",VLOOKUP($D14,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,13)=\"\",\"\",VLOOKUP($D14,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,15)=\"\",\"\",VLOOKUP($D14,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,16)=\"\",\"\",VLOOKUP($D14,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-12","Ma","",606,{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,2)=0,\"\",VLOOKUP($D15,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,3)=\"\",\"\",VLOOKUP($D15,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,13)=\"\",\"\",VLOOKUP($D15,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,15)=\"\",\"\",VLOOKUP($D15,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,16)=\"\",\"\",VLOOKUP($D15,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-13","Ti","",127,{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,2)=0,\"\",VLOOKUP($D16,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,3)=\"\",\"\",VLOOKUP($D16,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,13)=\"\",\"\",VLOOKUP($D16,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,15)=\"\",\"\",VLOOKUP($D16,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,16)=\"\",\"\",VLOOKUP($D16,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-14","On","","x",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,2)=0,\"\",VLOOKUP($D17,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,3)=\"\",\"\",VLOOKUP($D17,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,13)=\"\",\"\",VLOOKUP($D17,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,15)=\"\",\"\",VLOOKUP($D17,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,16)=\"\",\"\",VLOOKUP($D17,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-15","To","","x",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,2)=0,\"\",VLOOKUP($D18,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,3)=\"\",\"\",VLOOKUP($D18,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,13)=\"\",\"\",VLOOKUP($D18,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,15)=\"\",\"\",VLOOKUP($D18,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,16)=\"\",\"\",VLOOKUP($D18,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-16","Fr","",142,{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,2)=0,\"\",VLOOKUP($D19,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,3)=\"\",\"\",VLOOKUP($D19,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,13)=\"\",\"\",VLOOKUP($D19,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,15)=\"\",\"\",VLOOKUP($D19,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,16)=\"\",\"\",VLOOKUP($D19,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-17","Lø","","143f",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,2)=0,\"\",VLOOKUP($D20,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,3)=\"\",\"\",VLOOKUP($D20,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,13)=\"\",\"\",VLOOKUP($D20,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,15)=\"\",\"\",VLOOKUP($D20,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,16)=\"\",\"\",VLOOKUP($D20,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-18","Sø","",147,{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,2)=0,\"\",VLOOKUP($D21,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,3)=\"\",\"\",VLOOKUP($D21,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,13)=\"\",\"\",VLOOKUP($D21,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,15)=\"\",\"\",VLOOKUP($D21,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,16)=\"\",\"\",VLOOKUP($D21,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-19","Ma","",146,{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,2)=0,\"\",VLOOKUP($D22,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,3)=\"\",\"\",VLOOKUP($D22,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,13)=\"\",\"\",VLOOKUP($D22,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,15)=\"\",\"\",VLOOKUP($D22,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,16)=\"\",\"\",VLOOKUP($D22,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-20","Ti","",145,{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,2)=0,\"\",VLOOKUP($D23,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,3)=\"\",\"\",VLOOKUP($D23,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,13)=\"\",\"\",VLOOKUP($D23,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,15)=\"\",\"\",VLOOKUP($D23,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,16)=\"\",\"\",VLOOKUP($D23,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-21","On","","afsp.",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,2)=0,\"\",VLOOKUP($D24,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,3)=\"\",\"\",VLOOKUP($D24,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,13)=\"\",\"\",VLOOKUP($D24,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,15)=\"\",\"\",VLOOKUP($D24,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,16)=\"\",\"\",VLOOKUP($D24,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-22","To","",715,{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,2)=0,\"\",VLOOKUP($D25,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,3)=\"\",\"\",VLOOKUP($D25,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,13)=\"\",\"\",VLOOKUP($D25,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,15)=\"\",\"\",VLOOKUP($D25,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,16)=\"\",\"\",VLOOKUP($D25,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-23","Fr","",null,{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,2)=0,\"\",VLOOKUP($D26,#REF!,2)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,3)=\"\",\"\",VLOOKUP($D26,#REF!,3)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,13)=\"\",\"\",VLOOKUP($D26,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,15)=\"\",\"\",VLOOKUP($D26,#REF!,15)))","v":""},"",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,16)=\"\",\"\",VLOOKUP($D26,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-24","Lø","",612,{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,2)=0,\"\",VLOOKUP($D27,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,3)=\"\",\"\",VLOOKUP($D27,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,13)=\"\",\"\",VLOOKUP($D27,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,15)=\"\",\"\",VLOOKUP($D27,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,16)=\"\",\"\",VLOOKUP($D27,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-25","Sø","",null,{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,2)=0,\"\",VLOOKUP($D28,#REF!,2)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,3)=\"\",\"\",VLOOKUP($D28,#REF!,3)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,13)=\"\",\"\",VLOOKUP($D28,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,15)=\"\",\"\",VLOOKUP($D28,#REF!,15)))","v":""},"",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,16)=\"\",\"\",VLOOKUP($D28,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-26","Ma","",null,{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,2)=0,\"\",VLOOKUP($D29,#REF!,2)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,3)=\"\",\"\",VLOOKUP($D29,#REF!,3)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,13)=\"\",\"\",VLOOKUP($D29,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,15)=\"\",\"\",VLOOKUP($D29,#REF!,15)))","v":""},"",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,16)=\"\",\"\",VLOOKUP($D29,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-27","Ti","",null,{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,2)=0,\"\",VLOOKUP($D30,#REF!,2)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,3)=\"\",\"\",VLOOKUP($D30,#REF!,3)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,13)=\"\",\"\",VLOOKUP($D30,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,15)=\"\",\"\",VLOOKUP($D30,#REF!,15)))","v":""},"",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,16)=\"\",\"\",VLOOKUP($D30,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-28","On","","afsp.",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,2)=0,\"\",VLOOKUP($D31,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,3)=\"\",\"\",VLOOKUP($D31,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,13)=\"\",\"\",VLOOKUP($D31,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,15)=\"\",\"\",VLOOKUP($D31,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,16)=\"\",\"\",VLOOKUP($D31,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-29",{"$f":"IF(A32=\"\",\"\",PROPER(TEXT(A32,\"ddd\")))","v":"To"},"","afsp.",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,2)=0,\"\",VLOOKUP($D32,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,3)=\"\",\"\",VLOOKUP($D32,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,13)=\"\",\"\",VLOOKUP($D32,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,15)=\"\",\"\",VLOOKUP($D32,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,16)=\"\",\"\",VLOOKUP($D32,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["2010-04-30",{"$f":"IF(A33=\"\",\"\",PROPER(TEXT(A33,\"ddd\")))","v":"Fr"},"Store Bededag","x",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,2)=0,\"\",VLOOKUP($D33,#REF!,2)))","v":{"$error":"#REF!"}},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,3)=\"\",\"\",VLOOKUP($D33,#REF!,3)))","v":{"$error":"#REF!"}},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,13)=\"\",\"\",VLOOKUP($D33,#REF!,13)))","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,15)=\"\",\"\",VLOOKUP($D33,#REF!,15)))","v":{"$error":"#REF!"}},"",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,16)=\"\",\"\",VLOOKUP($D33,#REF!,16)))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"","1. Juledag",null,{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,2)=0,\"\",VLOOKUP($D34,#REF!,2)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,3)=\"\",\"\",VLOOKUP($D34,#REF!,3)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,13)=\"\",\"\",VLOOKUP($D34,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,15)=\"\",\"\",VLOOKUP($D34,#REF!,15)))","v":""},"",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,16)=\"\",\"\",VLOOKUP($D34,#REF!,16)))","v":""},null,"","","","","",""]
["Total timer",null,null,null,null,null,{"$f":"IF(SUM(G9:G34)<>\"0\",SUM(G4:G34),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(SUM(H4:H34)<>\"0\",SUM(H4:H34),\"\")","v":0},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(N4:N34)","v":0},{"$f":"SUM(O4:O34)","v":{"$error":"#REF!"}}]
["Timer 1/100",null,null,null,null,null,{"$f":"IF(G35<>\"\",ROUND(G35*24,2),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(H35<>\"\",ROUND(H35*24,2),\"\")","v":0},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,0,{"$error":"#REF!"}]
["Satser",null,null,null,null,null,{"$f":"Satser!B7","v":107.35},{"$f":"Satser!B9","v":36.35},{"$f":"Satser!B12","v":58.1},18.8,21.81,28.68,67]
[null,null,null,null,null,null,{"$f":"IF(G35<>\"\",G36*G37,\"\")","v":{"$error":"#REF!"}},{"$f":"IF(H35<>\"\",H36*H37,\"\")","v":0},0,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(M35<>\"\",M35*M37,\"\")","v":{"$error":"#REF!"}}]
[]
["Lønart"]
[3025,null,null,null,null,null,{"$f":"G35","v":{"$error":"#REF!"}}]
[3425,null,null,null,null,null,{"$f":"H35","v":0}]
[3426,null,null,null,null,null,{"$f":"I35","v":0}]
["Timer",null,null,null,null,null,{"$f":"SUM(G41:G43)","v":{"$error":"#REF!"}},{"$f":"IF(G44<>\"\",ROUND(G44*24,2),\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"G37*H44","v":{"$error":"#REF!"}}]

{"sheet":"september2010","index":1,"n_rows":47,"n_cols":35,"rows_kept":47,"cut":false,"hidden":false,"merged":[[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[37,12,37,13],[39,12,39,13],[38,12,38,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[35,12,35,13],[36,12,36,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[33,12,33,13],[34,12,34,13],[21,12,21,13],[19,10,19,11],[20,10,20,11],[21,10,21,11],[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[37,10,37,11],[45,0,45,5],[43,0,43,2],[44,0,44,2],[8,10,8,11],[9,10,9,11],[10,10,10,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[22,10,22,11],[23,10,23,11],[15,10,15,11],[16,10,16,11],[41,0,41,2],[42,0,42,2],[5,12,5,13],[6,12,6,13],[7,12,7,13],[5,10,5,11],[6,10,6,11],[7,10,7,11],[22,12,22,13],[23,12,23,13],[24,12,24,13],[17,10,17,11],[18,10,18,11],[38,10,38,11],[39,10,39,11],[0,1,0,7],[1,12,1,13],[2,12,2,13],[3,12,3,13],[4,12,4,13],[1,10,1,11],[2,10,2,11],[3,10,3,11],[4,10,4,11],[1,1,1,2],[2,1,2,2],[0,11,0,12]]}
["Løn",{"$f":"PROPER(TEXT(A4,\"dd mmmm åååå\")) & PROPER(TEXT(A36,\"  -  dd mmmm åååå\"))","v":"15 December 2001  -  16 Januar 2002"},null,null,null,null,null,null,null,"Uge :",{"$f":"IF(A4=\"\",\"\",TRUNC((A4-WEEKDAY(A4,2)-DATE(YEAR(A4+4-WEEKDAY(A4,2)),1,-10))/7))","v":50},"-",null,{"$f":"IF(A25=\"\",\"\",TRUNC((A25-WEEKDAY(A25,2)-DATE(YEAR(A25+4-WEEKDAY(A25,2)),1,-10))/7))","v":1},null,null,null,null,null,null,null,null,"Time beregning:",null,null,null,null,null,null,null,null,null,null,"06:00:00","18:00:00"]
["Lønart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betalt pause ved vagt over 5 timer",null,null,null,"00:25:00","minutter","00:00:00","06:00:00","17:00:00","14:00:00"]
["Dato","Dag",null,"Start","Slut","Pause","Arb. Tid","Overtid           1-2 time","Overtid           3-4 time","Overtid            5 - time","Forskudt tid alle dage        18-22",null,"Natarbejde 22-06",null,"Lørdag tillæg 15 - 24","Søndag tillæg 00 - 24","Optjent afspadsering","Afholdt afspadsering","Syge Timer","norm"]
["2001-12-15",{"$f":"PROPER(TEXT(A4,\"ddd\"))","v":"Lø"},{"$f":"HelligdagsNavn(A4,0,0)","v":""},"07:00:00","16:00:00","00:15:00",{"$f":"IF(D4=\"\",\"\",(E4-D4)+(D4>E4)-F4+H4+I4+J4)","v":0.47916666666666657},"02:00:00","00:45:00",null,{"$f":"ColTime(TIME(18,0,0),TIME(23,0,0),D4,E4)","v":"00:00:00"},null,{"$f":"ColTime(TIME(23,0,0),TIME(6,0,0),D4,E4)","v":"00:00:00"},null,{"$f":"IF(WEEKDAY(A4,2)=6,ColTime(TIME(15,0,0),TIME(24,0,0),D4,E4),\"\")","v":"01:00:00"},{"$f":"IF(D4=\"\",\"\",IF(D4<6/24,6/24-D4,\"\"))","v":""},{"$f":"H4+I4+J4","v":"02:45:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A4,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D4=\"\",\"\",HOUR(D4))","v":7},{"$f":"IF(D4=\"\",\"\",MINUTE(D4))","v":0},{"$f":"IF(D4=\"\",\"\",TIME(HOUR(D4),MINUTE(D4),0))","v":"07:00:00"},{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":16},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":0},"02:00:00","09:30:00","11:30:00",null,null,{"$f":"WEEKDAY(A4,2)","v":6}]
[{"$f":"A4+1","v":"2001-12-16"},{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A5,0,0)","v":""},"13:45:00","21:30:00","00:15:00",0.31250000000000006,null,null,null,{"$f":"ColTime(TIME(18,0,0),TIME(23,0,0),D5,E5)","v":"03:30:00"},null,{"$f":"ColTime(TIME(23,0,0),TIME(6,0,0),D5,E5)","v":"00:00:00"},null,{"$f":"IF(WEEKDAY(A5,2)=6,ColTime(TIME(15,0,0),TIME(24,0,0),D5,E5),\"\")","v":""},null,{"$f":"H5+I5+J5","v":"00:00:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A5,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D5=\"\",\"\",HOUR(D5))","v":13},{"$f":"IF(D5=\"\",\"\",MINUTE(D5))","v":45},{"$f":"IF(D5=\"\",\"\",TIME(HOUR(D5),MINUTE(D5),0))","v":"13:45:00"},{"$f":"IF(E5=\"\",\"\",HOUR(E5))","v":21},{"$f":"IF(E5=\"\",\"\",MINUTE(E5))","v":30},{"$f":"IF(E5=\"\",\"\",TIME(HOUR(E5),MINUTE(E5),0))","v":"21:30:00"}]
[{"$f":"A5+1","v":"2001-12-17"},{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"Ma"},"","22:00:00","05:45:00","00:15:00",0.31250000000000006,null,null,null,{"$f":"ColTime(TIME(18,0,0),TIME(23,0,0),D6,E6)","v":"01:00:00"},null,{"$f":"ColTime(TIME(23,0,0),TIME(6,0,0),D6,E6)","v":"06:45:00"},null,"",null,{"$f":"H6+I6+J6","v":"00:00:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A6,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D6=\"\",\"\",HOUR(D6))","v":22},{"$f":"IF(D6=\"\",\"\",MINUTE(D6))","v":0},{"$f":"IF(D6=\"\",\"\",TIME(HOUR(D6),MINUTE(D6),0))","v":"22:00:00"},{"$f":"IF(E6=\"\",\"\",HOUR(E6))","v":5},{"$f":"IF(E6=\"\",\"\",MINUTE(E6))","v":45},{"$f":"IF(E6=\"\",\"\",TIME(HOUR(E6),MINUTE(E6),0))","v":"05:45:00"}]
["2001-12-18","Ti","","05:00:00","12:45:00","00:15:00",0.48958333333333326,"02:00:00","02:00:00","00:15:00","00:00:00",null,"01:00:00",null,"",null,{"$f":"H7+I7+J7","v":"04:15:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A7,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D7=\"\",\"\",HOUR(D7))","v":5},{"$f":"IF(D7=\"\",\"\",MINUTE(D7))","v":0},{"$f":"IF(D7=\"\",\"\",TIME(HOUR(D7),MINUTE(D7),0))","v":"05:00:00"},{"$f":"IF(E7=\"\",\"\",HOUR(E7))","v":12},{"$f":"IF(E7=\"\",\"\",MINUTE(E7))","v":45},{"$f":"IF(E7=\"\",\"\",TIME(HOUR(E7),MINUTE(E7),0))","v":"12:45:00"}]
["2001-12-19","On","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"",null,{"$f":"H8+I8+J8","v":"00:00:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A8,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D8=\"\",\"\",HOUR(D8))","v":""},{"$f":"IF(D8=\"\",\"\",MINUTE(D8))","v":""},{"$f":"IF(D8=\"\",\"\",TIME(HOUR(D8),MINUTE(D8),0))","v":""},{"$f":"IF(E8=\"\",\"\",HOUR(E8))","v":""},{"$f":"IF(E8=\"\",\"\",MINUTE(E8))","v":""},{"$f":"IF(E8=\"\",\"\",TIME(HOUR(E8),MINUTE(E8),0))","v":""}]
["2001-12-20","To","","06:00:00","19:00:00",null,0.54166666666666663,null,null,null,"01:00:00",null,"00:00:00",null,"",null,{"$f":"H9+I9+J9","v":"00:00:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A9,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D9=\"\",\"\",HOUR(D9))","v":6},{"$f":"IF(D9=\"\",\"\",MINUTE(D9))","v":0},{"$f":"IF(D9=\"\",\"\",TIME(HOUR(D9),MINUTE(D9),0))","v":"06:00:00"},{"$f":"IF(E9=\"\",\"\",HOUR(E9))","v":19},{"$f":"IF(E9=\"\",\"\",MINUTE(E9))","v":0},{"$f":"IF(E9=\"\",\"\",TIME(HOUR(E9),MINUTE(E9),0))","v":"19:00:00"}]
["2001-12-21","Fr","","07:00:00","19:00:00",null,0.49999999999999994,null,null,null,"01:00:00",null,"00:00:00",null,"",{"$f":"ColTime(TIME(6,0,0),TIME(12,0,0),D10,E10)","v":"05:00:00"},{"$f":"H10+I10+J10","v":"00:00:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A10,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:00:00"},null,null,{"$f":"IF(D10=\"\",\"\",HOUR(D10))","v":7},{"$f":"IF(D10=\"\",\"\",MINUTE(D10))","v":0},{"$f":"IF(D10=\"\",\"\",TIME(HOUR(D10),MINUTE(D10),0))","v":"07:00:00"},{"$f":"IF(E10=\"\",\"\",HOUR(E10))","v":19},{"$f":"IF(E10=\"\",\"\",MINUTE(E10))","v":0},{"$f":"IF(E10=\"\",\"\",TIME(HOUR(E10),MINUTE(E10),0))","v":"19:00:00"}]
[{"$f":"A10+1","v":"2001-12-22"},{"$f":"PROPER(TEXT(A11,\"ddd\"))","v":"Lø"},{"$f":"HelligdagsNavn(A11,0,0)","v":""},null,null,null,{"$f":"IF(D11=\"\",\"\",(E11-D11)+(D11>E11)-F11+H11+I11)","v":""},null,null,null,"00:00:00",null,"00:00:00",null,"00:00:00",{"$f":"ColTime(TIME(6,0,0),TIME(12,0,0),D11,E11)","v":"00:00:00"},{"$f":"H11+I11+J11","v":"00:00:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A11,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D11=\"\",\"\",HOUR(D11))","v":""},{"$f":"IF(D11=\"\",\"\",MINUTE(D11))","v":""},{"$f":"IF(D11=\"\",\"\",TIME(HOUR(D11),MINUTE(D11),0))","v":""},{"$f":"IF(E11=\"\",\"\",HOUR(E11))","v":""},{"$f":"IF(E11=\"\",\"\",MINUTE(E11))","v":""},{"$f":"IF(E11=\"\",\"\",TIME(HOUR(E11),MINUTE(E11),0))","v":""}]
[{"$f":"A11+1","v":"2001-12-23"},{"$f":"PROPER(TEXT(A12,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A12,0,0)","v":""},null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A12,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D12=\"\",\"\",HOUR(D12))","v":""},{"$f":"IF(D12=\"\",\"\",MINUTE(D12))","v":""},{"$f":"IF(D12=\"\",\"\",TIME(HOUR(D12),MINUTE(D12),0))","v":""},{"$f":"IF(E12=\"\",\"\",HOUR(E12))","v":""},{"$f":"IF(E12=\"\",\"\",MINUTE(E12))","v":""},{"$f":"IF(E12=\"\",\"\",TIME(HOUR(E12),MINUTE(E12),0))","v":""}]
[{"$f":"A12+1","v":"2001-12-24"},{"$f":"PROPER(TEXT(A13,\"ddd\"))","v":"Ma"},"Julaftensdag",null,null,null,{"$f":"IF(D13=\"\",\"\",(E13-D13)+(D13>E13)-F13+H13+I13)","v":""},null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A13,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D13=\"\",\"\",HOUR(D13))","v":""},{"$f":"IF(D13=\"\",\"\",MINUTE(D13))","v":""},{"$f":"IF(D13=\"\",\"\",TIME(HOUR(D13),MINUTE(D13),0))","v":""},{"$f":"IF(E13=\"\",\"\",HOUR(E13))","v":""},{"$f":"IF(E13=\"\",\"\",MINUTE(E13))","v":""},{"$f":"IF(E13=\"\",\"\",TIME(HOUR(E13),MINUTE(E13),0))","v":""}]
["2001-12-25","Ti","1. Juledag",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A14,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D14=\"\",\"\",HOUR(D14))","v":""},{"$f":"IF(D14=\"\",\"\",MINUTE(D14))","v":""},{"$f":"IF(D14=\"\",\"\",TIME(HOUR(D14),MINUTE(D14),0))","v":""},{"$f":"IF(E14=\"\",\"\",HOUR(E14))","v":""},{"$f":"IF(E14=\"\",\"\",MINUTE(E14))","v":""},{"$f":"IF(E14=\"\",\"\",TIME(HOUR(E14),MINUTE(E14),0))","v":""}]
["2001-12-26","On","2. Juledag",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A15,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D15=\"\",\"\",HOUR(D15))","v":""},{"$f":"IF(D15=\"\",\"\",MINUTE(D15))","v":""},{"$f":"IF(D15=\"\",\"\",TIME(HOUR(D15),MINUTE(D15),0))","v":""},{"$f":"IF(E15=\"\",\"\",HOUR(E15))","v":""},{"$f":"IF(E15=\"\",\"\",MINUTE(E15))","v":""},{"$f":"IF(E15=\"\",\"\",TIME(HOUR(E15),MINUTE(E15),0))","v":""}]
["2001-12-27","To","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A16,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D16=\"\",\"\",HOUR(D16))","v":""},{"$f":"IF(D16=\"\",\"\",MINUTE(D16))","v":""},{"$f":"IF(D16=\"\",\"\",TIME(HOUR(D16),MINUTE(D16),0))","v":""},{"$f":"IF(E16=\"\",\"\",HOUR(E16))","v":""},{"$f":"IF(E16=\"\",\"\",MINUTE(E16))","v":""},{"$f":"IF(E16=\"\",\"\",TIME(HOUR(E16),MINUTE(E16),0))","v":""}]
["2001-12-28","Fr","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A17,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:00:00"},null,null,{"$f":"IF(D17=\"\",\"\",HOUR(D17))","v":""},{"$f":"IF(D17=\"\",\"\",MINUTE(D17))","v":""},{"$f":"IF(D17=\"\",\"\",TIME(HOUR(D17),MINUTE(D17),0))","v":""},{"$f":"IF(E17=\"\",\"\",HOUR(E17))","v":""},{"$f":"IF(E17=\"\",\"\",MINUTE(E17))","v":""},{"$f":"IF(E17=\"\",\"\",TIME(HOUR(E17),MINUTE(E17),0))","v":""}]
[{"$f":"A17+1","v":"2001-12-29"},{"$f":"PROPER(TEXT(A18,\"ddd\"))","v":"Lø"},{"$f":"HelligdagsNavn(A18,0,0)","v":""},null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"00:00:00","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A18,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D18=\"\",\"\",HOUR(D18))","v":""},{"$f":"IF(D18=\"\",\"\",MINUTE(D18))","v":""},{"$f":"IF(D18=\"\",\"\",TIME(HOUR(D18),MINUTE(D18),0))","v":""},{"$f":"IF(E18=\"\",\"\",HOUR(E18))","v":""},{"$f":"IF(E18=\"\",\"\",MINUTE(E18))","v":""},{"$f":"IF(E18=\"\",\"\",TIME(HOUR(E18),MINUTE(E18),0))","v":""}]
[{"$f":"A18+1","v":"2001-12-30"},{"$f":"PROPER(TEXT(A19,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A19,0,0)","v":""},null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A19,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D19=\"\",\"\",HOUR(D19))","v":""},{"$f":"IF(D19=\"\",\"\",MINUTE(D19))","v":""},{"$f":"IF(D19=\"\",\"\",TIME(HOUR(D19),MINUTE(D19),0))","v":""},{"$f":"IF(E19=\"\",\"\",HOUR(E19))","v":""},{"$f":"IF(E19=\"\",\"\",MINUTE(E19))","v":""},{"$f":"IF(E19=\"\",\"\",TIME(HOUR(E19),MINUTE(E19),0))","v":""}]
[{"$f":"A19+1","v":"2001-12-31"},{"$f":"PROPER(TEXT(A20,\"ddd\"))","v":"Ma"},"Nytårsaftensdag",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A20,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D20=\"\",\"\",HOUR(D20))","v":""},{"$f":"IF(D20=\"\",\"\",MINUTE(D20))","v":""},{"$f":"IF(D20=\"\",\"\",TIME(HOUR(D20),MINUTE(D20),0))","v":""},{"$f":"IF(E20=\"\",\"\",HOUR(E20))","v":""},{"$f":"IF(E20=\"\",\"\",MINUTE(E20))","v":""},{"$f":"IF(E20=\"\",\"\",TIME(HOUR(E20),MINUTE(E20),0))","v":""}]
["2002-01-01","Ti","Nytårsdag",null,null,null,"",null,null,null,{"$f":"ColTime(TIME(18,0,0),TIME(23,0,0),D21,E21)","v":"00:00:00"},null,{"$f":"ColTime(TIME(23,0,0),TIME(6,0,0),D21,E21)","v":"00:00:00"},null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A21,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D21=\"\",\"\",HOUR(D21))","v":""},{"$f":"IF(D21=\"\",\"\",MINUTE(D21))","v":""},{"$f":"IF(D21=\"\",\"\",TIME(HOUR(D21),MINUTE(D21),0))","v":""},{"$f":"IF(E21=\"\",\"\",HOUR(E21))","v":""},{"$f":"IF(E21=\"\",\"\",MINUTE(E21))","v":""},{"$f":"IF(E21=\"\",\"\",TIME(HOUR(E21),MINUTE(E21),0))","v":""}]
["2002-01-02","On","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A22,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D22=\"\",\"\",HOUR(D22))","v":""},{"$f":"IF(D22=\"\",\"\",MINUTE(D22))","v":""},{"$f":"IF(D22=\"\",\"\",TIME(HOUR(D22),MINUTE(D22),0))","v":""},{"$f":"IF(E22=\"\",\"\",HOUR(E22))","v":""},{"$f":"IF(E22=\"\",\"\",MINUTE(E22))","v":""},{"$f":"IF(E22=\"\",\"\",TIME(HOUR(E22),MINUTE(E22),0))","v":""}]
["2002-01-03","To","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A23,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D23=\"\",\"\",HOUR(D23))","v":""},{"$f":"IF(D23=\"\",\"\",MINUTE(D23))","v":""},{"$f":"IF(D23=\"\",\"\",TIME(HOUR(D23),MINUTE(D23),0))","v":""},{"$f":"IF(E23=\"\",\"\",HOUR(E23))","v":""},{"$f":"IF(E23=\"\",\"\",MINUTE(E23))","v":""},{"$f":"IF(E23=\"\",\"\",TIME(HOUR(E23),MINUTE(E23),0))","v":""}]
["2002-01-04","Fr","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A24,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:00:00"},null,null,{"$f":"IF(D24=\"\",\"\",HOUR(D24))","v":""},{"$f":"IF(D24=\"\",\"\",MINUTE(D24))","v":""},{"$f":"IF(D24=\"\",\"\",TIME(HOUR(D24),MINUTE(D24),0))","v":""},{"$f":"IF(E24=\"\",\"\",HOUR(E24))","v":""},{"$f":"IF(E24=\"\",\"\",MINUTE(E24))","v":""},{"$f":"IF(E24=\"\",\"\",TIME(HOUR(E24),MINUTE(E24),0))","v":""}]
[{"$f":"A24+1","v":"2002-01-05"},{"$f":"PROPER(TEXT(A25,\"ddd\"))","v":"Lø"},{"$f":"HelligdagsNavn(A25,0,0)","v":""},null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"00:00:00","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A25,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D25=\"\",\"\",HOUR(D25))","v":""},{"$f":"IF(D25=\"\",\"\",MINUTE(D25))","v":""},{"$f":"IF(D25=\"\",\"\",TIME(HOUR(D25),MINUTE(D25),0))","v":""},{"$f":"IF(E25=\"\",\"\",HOUR(E25))","v":""},{"$f":"IF(E25=\"\",\"\",MINUTE(E25))","v":""},{"$f":"IF(E25=\"\",\"\",TIME(HOUR(E25),MINUTE(E25),0))","v":""}]
[{"$f":"A25+1","v":"2002-01-06"},{"$f":"PROPER(TEXT(A26,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A26,0,0)","v":""},null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A26,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D26=\"\",\"\",HOUR(D26))","v":""},{"$f":"IF(D26=\"\",\"\",MINUTE(D26))","v":""},{"$f":"IF(D26=\"\",\"\",TIME(HOUR(D26),MINUTE(D26),0))","v":""},{"$f":"IF(E26=\"\",\"\",HOUR(E26))","v":""},{"$f":"IF(E26=\"\",\"\",MINUTE(E26))","v":""},{"$f":"IF(E26=\"\",\"\",TIME(HOUR(E26),MINUTE(E26),0))","v":""}]
[{"$f":"A26+1","v":"2002-01-07"},{"$f":"PROPER(TEXT(A27,\"ddd\"))","v":"Ma"},"",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A27,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D27=\"\",\"\",HOUR(D27))","v":""},{"$f":"IF(D27=\"\",\"\",MINUTE(D27))","v":""},{"$f":"IF(D27=\"\",\"\",TIME(HOUR(D27),MINUTE(D27),0))","v":""},{"$f":"IF(E27=\"\",\"\",HOUR(E27))","v":""},{"$f":"IF(E27=\"\",\"\",MINUTE(E27))","v":""},{"$f":"IF(E27=\"\",\"\",TIME(HOUR(E27),MINUTE(E27),0))","v":""}]
["2002-01-08","Ti","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A28,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D28=\"\",\"\",HOUR(D28))","v":""},{"$f":"IF(D28=\"\",\"\",MINUTE(D28))","v":""},{"$f":"IF(D28=\"\",\"\",TIME(HOUR(D28),MINUTE(D28),0))","v":""},{"$f":"IF(E28=\"\",\"\",HOUR(E28))","v":""},{"$f":"IF(E28=\"\",\"\",MINUTE(E28))","v":""},{"$f":"IF(E28=\"\",\"\",TIME(HOUR(E28),MINUTE(E28),0))","v":""}]
["2002-01-09","On","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00"]
["2002-01-10","To","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00"]
["2002-01-11","Fr","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00"]
["2002-01-12","Lø","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"00:00:00","00:00:00","00:00:00"]
["2002-01-13","Sø","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00"]
["2002-01-14","Ma","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A34,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D34=\"\",\"\",HOUR(D34))","v":""},{"$f":"IF(D34=\"\",\"\",MINUTE(D34))","v":""},{"$f":"IF(D34=\"\",\"\",TIME(HOUR(D34),MINUTE(D34),0))","v":""},{"$f":"IF(E34=\"\",\"\",HOUR(E34))","v":""},{"$f":"IF(E34=\"\",\"\",MINUTE(E34))","v":""},{"$f":"IF(E34=\"\",\"\",TIME(HOUR(E34),MINUTE(E34),0))","v":""}]
["2002-01-15","Ti","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A35,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D35=\"\",\"\",HOUR(D35))","v":""},{"$f":"IF(D35=\"\",\"\",MINUTE(D35))","v":""},{"$f":"IF(D35=\"\",\"\",TIME(HOUR(D35),MINUTE(D35),0))","v":""},{"$f":"IF(E35=\"\",\"\",HOUR(E35))","v":""},{"$f":"IF(E35=\"\",\"\",MINUTE(E35))","v":""},{"$f":"IF(E35=\"\",\"\",TIME(HOUR(E35),MINUTE(E35),0))","v":""}]
["2002-01-16","On","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,"","00:00:00","00:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A36,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D36=\"\",\"\",HOUR(D36))","v":""},{"$f":"IF(D36=\"\",\"\",MINUTE(D36))","v":""},{"$f":"IF(D36=\"\",\"\",TIME(HOUR(D36),MINUTE(D36),0))","v":""},{"$f":"IF(E36=\"\",\"\",HOUR(E36))","v":""},{"$f":"IF(E36=\"\",\"\",MINUTE(E36))","v":""},{"$f":"IF(E36=\"\",\"\",TIME(HOUR(E36),MINUTE(E36),0))","v":""}]
["Total timer",null,null,null,null,null,{"$f":"IF(SUM(G9:G36)<>\"0\",SUM(G4:G36),\"\")","v":2.6354166666666665},{"$f":"IF(SUM(H4:H36)<>\"0\",SUM(H4:H36),\"\")","v":0.16666666666666666},{"$f":"IF(SUM(I4:I36)<>\"0\",SUM(I4:I36),\"\")","v":0.11458333333333333},{"$f":"IF(SUM(J4:J36)<>\"0\",SUM(J4:J36),\"\")","v":1.0416666666666666E-2},{"$f":"IF(SUM(K4:K36)<>\"0\",SUM(K4:K36),\"\")","v":0.27083333333333337},null,{"$f":"SUM(M4:N36)","v":"07:45:00"},null,{"$f":"IF(SUM(O4:O36)<>\"0\",SUM(O4:O36),\"\")","v":4.166666666666663E-2},{"$f":"IF(SUM(P4:P36)<>\"0\",SUM(P4:P36),\"\")","v":"05:00:00"},{"$f":"SUM(Q4:Q36)","v":0.29166666666666663},{"$f":"SUM(R4:R36)","v":0}]
["Timer 1/100",null,null,null,null,null,{"$f":"IF(G37<>\"\",ROUND(G37*24,2),\"\")","v":63.25},{"$f":"IF(H37<>\"\",ROUND(H37*24,2),\"\")","v":4},2.75,0.25,{"$f":"IF(K37<>\"\",ROUND(K37*24,2),\"\")","v":6.5},null,{"$f":"IF(M37<>\"\",ROUND(M37*24,2),\"\")","v":7.75},null,{"$f":"IF(O37<>\"\",ROUND(O37*24,2),\"\")","v":1},5,7,0]
["Satser",null,null,null,null,null,{"$f":"Satser!B7","v":107.35},{"$f":"Satser!B9","v":36.35},{"$f":"Satser!B12","v":58.1},{"$f":"Satser!B15","v":108.65},{"$f":"Satser!B17","v":25.6},null,{"$f":"Satser!B19","v":46.95},null,null,67]
[null,null,null,null,null,null,{"$f":"IF(G37<>\"\",G38*G39,\"\")","v":6789.8874999999998},{"$f":"IF(H37<>\"\",H38*H39,\"\")","v":145.4},159.77500000000001,27.162500000000001,{"$f":"IF(K37<>\"\",K38*K39,\"\")","v":166.4},null,{"$f":"IF(M37<>\"\",M38*M38,\"\")","v":60.0625}]
[]
["Lønart"]
[3025,null,null,null,null,null,{"$f":"G37","v":2.6354166666666665}]
[3425,null,null,null,null,null,{"$f":"H37","v":0.16666666666666666}]
[3428,null,null,null,null,null,{"$f":"J37","v":1.0416666666666666E-2}]
["Timer",null,null,null,null,null,{"$f":"SUM(G43:G45)","v":2.8124999999999996},{"$f":"IF(G46<>\"\",ROUND(G46*24,2),\"\")","v":67.5}]
[null,null,null,null,null,null,null,{"$f":"G39*H46","v":7246.125}]

{"sheet":"Tomt","index":2,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":false,"merged":[[41,0,41,3],[42,0,42,3],[43,0,43,3],[0,1,0,5],[0,16,0,17],[1,1,1,2],[2,1,2,2],[39,0,39,3],[40,0,40,3]]}
["Løn","1 juni 2010 - 30 juni 2010",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time beregning:"]
["Lønart",null,null,null,null,null,3025,3425,3426,3600,3602,3605,3610,9091,9092,null,"Betalt pause ved vagt over 5 timer",null,null,null,"00:25:00","minutter","00:00:00","06:00:00","18:00:00","14:00:00"]
["Dato","Dag",null,"Vagt","Start","Slut","Time SID","Overtid           1-3 time","Overtid            4 - time","Forskudttid alle dage","Nattillæg     00-06","Weekend tillæg","Delt tjenste"]
["2010-04-01",{"$f":"PROPER(TEXT(A4,\"ddd\"))","v":"To"},{"$f":"HelligdagsNavn(A4,0,0)","v":"Skærtorsdag"},null,{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,#REF!,2)=0,\"\",VLOOKUP($D4,#REF!,2)))","v":""},{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,#REF!,3)=\"\",\"\",VLOOKUP($D4,#REF!,3)))","v":""},{"$f":"IF($D4=\"\",\"\",VLOOKUP($D4,#REF!,13))","v":""},null,null,{"$f":"IF(E4<>\"\",IF(WEEKDAY(A4,2)<>6,IF(E4>F4,(F4-MAX(E4,(18/24))+(E4>F4))-F4,IF(F4>Y$2,(F4-MAX(E4,(18/24))),\"\")),IF(E4>F4,(F4-MAX(E4,(14/24))+(E4>F4))-F4,IF(F4>Z$2,(F4-MAX(E4,(14/24))),\"\"))),\"\")","v":""},{"$f":"IF(G4<>\"\",IF(S4<X$2,(X$2-S4),IF(V4<X$2,(V4-W$2),\"\")),\"\")","v":""},{"$f":"IF(G4<>0,IF(WEEKDAY(A4,2)=7,G4,\"\"),\"\")","v":""},{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,#REF!,15)=\"\",\"\",VLOOKUP($D4,#REF!,15)))","v":""},{"$f":"IF(SUM(H4:I4)=0,\"\",SUM(H4:I4))","v":""},null,null,{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":""},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":""},{"$f":"IF(E4=\"\",\"\",TIME(HOUR(E4),MINUTE(E4),0))","v":""},{"$f":"IF(F4=\"\",\"\",HOUR(F4))","v":""},{"$f":"IF(F4=\"\",\"\",MINUTE(F4))","v":""},{"$f":"TIME(HOUR(F4),MINUTE(F4),0)","v":{"$error":"#VALUE!"}}]
["2010-04-02",{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Fr"},{"$f":"HelligdagsNavn(A5,0,0)","v":"Langfredag"},null,{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,#REF!,2)=0,\"\",VLOOKUP($D5,#REF!,2)))","v":""},{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,#REF!,3)=\"\",\"\",VLOOKUP($D5,#REF!,3)))","v":""},{"$f":"IF($D5=\"\",\"\",VLOOKUP($D5,#REF!,13))","v":""},null,null,{"$f":"IF(E5<>\"\",IF(WEEKDAY(A5,2)<>6,IF(E5>F5,(F5-MAX(E5,(18/24))+(E5>F5))-F5,IF(F5>Y$2,(F5-MAX(E5,(18/24))),\"\")),IF(E5>F5,(F5-MAX(E5,(14/24))+(E5>F5))-F5,IF(F5>Z$2,(F5-MAX(E5,(14/24))),\"\"))),\"\")","v":""},"",{"$f":"IF(G5<>0,IF(WEEKDAY(A5,2)=7,G5,\"\"),\"\")","v":""},{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,#REF!,15)=\"\",\"\",VLOOKUP($D5,#REF!,15)))","v":""},{"$f":"IF(SUM(H5:I5)=0,\"\",SUM(H5:I5))","v":""},null,null,"","","","","",{"$f":"TIME(HOUR(F5),MINUTE(F5),0)","v":{"$error":"#VALUE!"}}]
["2010-04-03",{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"Lø"},"",null,{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,#REF!,2)=0,\"\",VLOOKUP($D6,#REF!,2)))","v":""},{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,#REF!,3)=\"\",\"\",VLOOKUP($D6,#REF!,3)))","v":""},{"$f":"IF($D6=\"\",\"\",VLOOKUP($D6,#REF!,13))","v":""},null,null,{"$f":"IF(E6<>\"\",IF(WEEKDAY(A6,2)<>6,IF(E6>F6,(F6-MAX(E6,(18/24))+(E6>F6))-F6,IF(F6>Y$2,(F6-MAX(E6,(18/24))),\"\")),IF(E6>F6,(F6-MAX(E6,(14/24))+(E6>F6))-F6,IF(F6>Z$2,(F6-MAX(E6,(14/24))),\"\"))),\"\")","v":""},"","",{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,#REF!,15)=\"\",\"\",VLOOKUP($D6,#REF!,15)))","v":""},"",null,null,"","","","","",{"$f":"TIME(HOUR(F6),MINUTE(F6),0)","v":{"$error":"#VALUE!"}}]
["2010-04-04","Sø","Påskedag",null,{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,2)=0,\"\",VLOOKUP($D7,#REF!,2)))","v":""},{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,3)=\"\",\"\",VLOOKUP($D7,#REF!,3)))","v":""},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,#REF!,13))","v":""},null,null,"","","",{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,15)=\"\",\"\",VLOOKUP($D7,#REF!,15)))","v":""},"",{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,#REF!,16)=\"\",\"\",VLOOKUP($D7,#REF!,16)))","v":""},null,"","","","","",{"$f":"TIME(HOUR(F7),MINUTE(F7),0)","v":{"$error":"#VALUE!"}}]
["2010-04-05","Ma","2. Påskedag",null,{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,2)=0,\"\",VLOOKUP($D8,#REF!,2)))","v":""},{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,3)=\"\",\"\",VLOOKUP($D8,#REF!,3)))","v":""},{"$f":"IF($D8=\"\",\"\",VLOOKUP($D8,#REF!,13))","v":""},null,null,"","","",{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,15)=\"\",\"\",VLOOKUP($D8,#REF!,15)))","v":""},"",{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,#REF!,16)=\"\",\"\",VLOOKUP($D8,#REF!,16)))","v":""},null,"","","","","",{"$f":"TIME(HOUR(F8),MINUTE(F8),0)","v":{"$error":"#VALUE!"}}]
["2010-04-06","Ti","",null,{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,2)=0,\"\",VLOOKUP($D9,#REF!,2)))","v":""},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,3)=\"\",\"\",VLOOKUP($D9,#REF!,3)))","v":""},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,#REF!,13))","v":""},null,null,"","",{"$f":"IF(G9<>0,IF(WEEKDAY(A9,2)=7,G9,\"\"),\"\")","v":""},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,15)=\"\",\"\",VLOOKUP($D9,#REF!,15)))","v":""},"",{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,#REF!,16)=\"\",\"\",VLOOKUP($D9,#REF!,16)))","v":""},null,"","","","","",{"$f":"IF(F9=\"\",\"\",TIME(HOUR(F9),MINUTE(F9),0))","v":""}]
["2010-04-07","On","",null,{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,2)=0,\"\",VLOOKUP($D10,#REF!,2)))","v":""},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,3)=\"\",\"\",VLOOKUP($D10,#REF!,3)))","v":""},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,13)=\"\",\"\",VLOOKUP($D10,#REF!,13)))","v":""},null,null,"","",{"$f":"IF(G10<>0,IF(WEEKDAY(A10,2)=7,G10,\"\"),\"\")","v":""},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,15)=\"\",\"\",VLOOKUP($D10,#REF!,15)))","v":""},"",{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,#REF!,16)=\"\",\"\",VLOOKUP($D10,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-08","To","",null,{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,2)=0,\"\",VLOOKUP($D11,#REF!,2)))","v":""},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,3)=\"\",\"\",VLOOKUP($D11,#REF!,3)))","v":""},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,13)=\"\",\"\",VLOOKUP($D11,#REF!,13)))","v":""},null,null,"","",{"$f":"IF(G11<>0,IF(WEEKDAY(A11,2)=7,G11,\"\"),\"\")","v":""},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,15)=\"\",\"\",VLOOKUP($D11,#REF!,15)))","v":""},"",{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,#REF!,16)=\"\",\"\",VLOOKUP($D11,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-09","Fr","",null,{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,2)=0,\"\",VLOOKUP($D12,#REF!,2)))","v":""},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,3)=\"\",\"\",VLOOKUP($D12,#REF!,3)))","v":""},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,13)=\"\",\"\",VLOOKUP($D12,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,15)=\"\",\"\",VLOOKUP($D12,#REF!,15)))","v":""},"",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,#REF!,16)=\"\",\"\",VLOOKUP($D12,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-10","Lø","",null,{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,2)=0,\"\",VLOOKUP($D13,#REF!,2)))","v":""},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,3)=\"\",\"\",VLOOKUP($D13,#REF!,3)))","v":""},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,13)=\"\",\"\",VLOOKUP($D13,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,15)=\"\",\"\",VLOOKUP($D13,#REF!,15)))","v":""},"",{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,#REF!,16)=\"\",\"\",VLOOKUP($D13,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-11","Sø","",null,{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,2)=0,\"\",VLOOKUP($D14,#REF!,2)))","v":""},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,3)=\"\",\"\",VLOOKUP($D14,#REF!,3)))","v":""},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,13)=\"\",\"\",VLOOKUP($D14,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,15)=\"\",\"\",VLOOKUP($D14,#REF!,15)))","v":""},"",{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,#REF!,16)=\"\",\"\",VLOOKUP($D14,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-12","Ma","",null,{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,2)=0,\"\",VLOOKUP($D15,#REF!,2)))","v":""},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,3)=\"\",\"\",VLOOKUP($D15,#REF!,3)))","v":""},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,13)=\"\",\"\",VLOOKUP($D15,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,15)=\"\",\"\",VLOOKUP($D15,#REF!,15)))","v":""},"",{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,#REF!,16)=\"\",\"\",VLOOKUP($D15,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-13","Ti","",null,{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,2)=0,\"\",VLOOKUP($D16,#REF!,2)))","v":""},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,3)=\"\",\"\",VLOOKUP($D16,#REF!,3)))","v":""},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,13)=\"\",\"\",VLOOKUP($D16,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,15)=\"\",\"\",VLOOKUP($D16,#REF!,15)))","v":""},"",{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,#REF!,16)=\"\",\"\",VLOOKUP($D16,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-14","On","",null,{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,2)=0,\"\",VLOOKUP($D17,#REF!,2)))","v":""},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,3)=\"\",\"\",VLOOKUP($D17,#REF!,3)))","v":""},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,13)=\"\",\"\",VLOOKUP($D17,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,15)=\"\",\"\",VLOOKUP($D17,#REF!,15)))","v":""},"",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,#REF!,16)=\"\",\"\",VLOOKUP($D17,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-15","To","",null,{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,2)=0,\"\",VLOOKUP($D18,#REF!,2)))","v":""},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,3)=\"\",\"\",VLOOKUP($D18,#REF!,3)))","v":""},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,13)=\"\",\"\",VLOOKUP($D18,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,15)=\"\",\"\",VLOOKUP($D18,#REF!,15)))","v":""},"",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,#REF!,16)=\"\",\"\",VLOOKUP($D18,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-16","Fr","",null,{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,2)=0,\"\",VLOOKUP($D19,#REF!,2)))","v":""},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,3)=\"\",\"\",VLOOKUP($D19,#REF!,3)))","v":""},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,13)=\"\",\"\",VLOOKUP($D19,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,15)=\"\",\"\",VLOOKUP($D19,#REF!,15)))","v":""},"",{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,#REF!,16)=\"\",\"\",VLOOKUP($D19,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-17","Lø","",null,{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,2)=0,\"\",VLOOKUP($D20,#REF!,2)))","v":""},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,3)=\"\",\"\",VLOOKUP($D20,#REF!,3)))","v":""},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,13)=\"\",\"\",VLOOKUP($D20,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,15)=\"\",\"\",VLOOKUP($D20,#REF!,15)))","v":""},"",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,#REF!,16)=\"\",\"\",VLOOKUP($D20,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-18","Sø","",null,{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,2)=0,\"\",VLOOKUP($D21,#REF!,2)))","v":""},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,3)=\"\",\"\",VLOOKUP($D21,#REF!,3)))","v":""},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,13)=\"\",\"\",VLOOKUP($D21,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,15)=\"\",\"\",VLOOKUP($D21,#REF!,15)))","v":""},"",{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,#REF!,16)=\"\",\"\",VLOOKUP($D21,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-19","Ma","",null,{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,2)=0,\"\",VLOOKUP($D22,#REF!,2)))","v":""},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,3)=\"\",\"\",VLOOKUP($D22,#REF!,3)))","v":""},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,13)=\"\",\"\",VLOOKUP($D22,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,15)=\"\",\"\",VLOOKUP($D22,#REF!,15)))","v":""},"",{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,#REF!,16)=\"\",\"\",VLOOKUP($D22,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-20","Ti","",null,{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,2)=0,\"\",VLOOKUP($D23,#REF!,2)))","v":""},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,3)=\"\",\"\",VLOOKUP($D23,#REF!,3)))","v":""},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,13)=\"\",\"\",VLOOKUP($D23,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,15)=\"\",\"\",VLOOKUP($D23,#REF!,15)))","v":""},"",{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,#REF!,16)=\"\",\"\",VLOOKUP($D23,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-21","On","",null,{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,2)=0,\"\",VLOOKUP($D24,#REF!,2)))","v":""},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,3)=\"\",\"\",VLOOKUP($D24,#REF!,3)))","v":""},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,13)=\"\",\"\",VLOOKUP($D24,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,15)=\"\",\"\",VLOOKUP($D24,#REF!,15)))","v":""},"",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,#REF!,16)=\"\",\"\",VLOOKUP($D24,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-22","To","",null,{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,2)=0,\"\",VLOOKUP($D25,#REF!,2)))","v":""},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,3)=\"\",\"\",VLOOKUP($D25,#REF!,3)))","v":""},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,13)=\"\",\"\",VLOOKUP($D25,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,15)=\"\",\"\",VLOOKUP($D25,#REF!,15)))","v":""},"",{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,#REF!,16)=\"\",\"\",VLOOKUP($D25,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-23","Fr","",null,{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,2)=0,\"\",VLOOKUP($D26,#REF!,2)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,3)=\"\",\"\",VLOOKUP($D26,#REF!,3)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,13)=\"\",\"\",VLOOKUP($D26,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,15)=\"\",\"\",VLOOKUP($D26,#REF!,15)))","v":""},"",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,#REF!,16)=\"\",\"\",VLOOKUP($D26,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-24","Lø","",null,{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,2)=0,\"\",VLOOKUP($D27,#REF!,2)))","v":""},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,3)=\"\",\"\",VLOOKUP($D27,#REF!,3)))","v":""},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,13)=\"\",\"\",VLOOKUP($D27,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,15)=\"\",\"\",VLOOKUP($D27,#REF!,15)))","v":""},"",{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,#REF!,16)=\"\",\"\",VLOOKUP($D27,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-25","Sø","",null,{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,2)=0,\"\",VLOOKUP($D28,#REF!,2)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,3)=\"\",\"\",VLOOKUP($D28,#REF!,3)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,13)=\"\",\"\",VLOOKUP($D28,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,15)=\"\",\"\",VLOOKUP($D28,#REF!,15)))","v":""},"",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,#REF!,16)=\"\",\"\",VLOOKUP($D28,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-26","Ma","",null,{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,2)=0,\"\",VLOOKUP($D29,#REF!,2)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,3)=\"\",\"\",VLOOKUP($D29,#REF!,3)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,13)=\"\",\"\",VLOOKUP($D29,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,15)=\"\",\"\",VLOOKUP($D29,#REF!,15)))","v":""},"",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,#REF!,16)=\"\",\"\",VLOOKUP($D29,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-27","Ti","",null,{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,2)=0,\"\",VLOOKUP($D30,#REF!,2)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,3)=\"\",\"\",VLOOKUP($D30,#REF!,3)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,13)=\"\",\"\",VLOOKUP($D30,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,15)=\"\",\"\",VLOOKUP($D30,#REF!,15)))","v":""},"",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,#REF!,16)=\"\",\"\",VLOOKUP($D30,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-28","On","",null,{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,2)=0,\"\",VLOOKUP($D31,#REF!,2)))","v":""},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,3)=\"\",\"\",VLOOKUP($D31,#REF!,3)))","v":""},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,13)=\"\",\"\",VLOOKUP($D31,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,15)=\"\",\"\",VLOOKUP($D31,#REF!,15)))","v":""},"",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,#REF!,16)=\"\",\"\",VLOOKUP($D31,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-29",{"$f":"IF(A32=\"\",\"\",PROPER(TEXT(A32,\"ddd\")))","v":"To"},"",null,{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,2)=0,\"\",VLOOKUP($D32,#REF!,2)))","v":""},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,3)=\"\",\"\",VLOOKUP($D32,#REF!,3)))","v":""},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,13)=\"\",\"\",VLOOKUP($D32,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,15)=\"\",\"\",VLOOKUP($D32,#REF!,15)))","v":""},"",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,#REF!,16)=\"\",\"\",VLOOKUP($D32,#REF!,16)))","v":""},null,"","","","","",""]
["2010-04-30",{"$f":"IF(A33=\"\",\"\",PROPER(TEXT(A33,\"ddd\")))","v":"Fr"},"Store Bededag",null,{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,2)=0,\"\",VLOOKUP($D33,#REF!,2)))","v":""},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,3)=\"\",\"\",VLOOKUP($D33,#REF!,3)))","v":""},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,13)=\"\",\"\",VLOOKUP($D33,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,15)=\"\",\"\",VLOOKUP($D33,#REF!,15)))","v":""},"",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,#REF!,16)=\"\",\"\",VLOOKUP($D33,#REF!,16)))","v":""},null,"","","","","",""]
[null,"","1. Juledag",null,{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,2)=0,\"\",VLOOKUP($D34,#REF!,2)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,3)=\"\",\"\",VLOOKUP($D34,#REF!,3)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,13)=\"\",\"\",VLOOKUP($D34,#REF!,13)))","v":""},null,null,"","","",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,15)=\"\",\"\",VLOOKUP($D34,#REF!,15)))","v":""},"",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,#REF!,16)=\"\",\"\",VLOOKUP($D34,#REF!,16)))","v":""},null,"","","","","",""]
["Total timer",null,null,null,null,null,{"$f":"IF(SUM(G9:G34)<>\"0\",SUM(G4:G34),\"\")","v":0},{"$f":"IF(SUM(H4:H34)<>\"0\",SUM(H4:H34),\"\")","v":0},0,0,0,0,0,{"$f":"SUM(N4:N34)","v":0},{"$f":"SUM(O4:O34)","v":0}]
["Timer 1/100",null,null,null,null,null,{"$f":"IF(G35<>\"\",ROUND(G35*24,2),\"\")","v":0},{"$f":"IF(H35<>\"\",ROUND(H35*24,2),\"\")","v":0},0,0,0,0,null,0,0]
["Satser",null,null,null,null,null,{"$f":"Satser!B7","v":107.35},{"$f":"Satser!B9","v":36.35},{"$f":"Satser!B12","v":58.1},18.8,21.81,28.68,67]
[null,null,null,null,null,null,{"$f":"IF(G35<>\"\",G36*G37,\"\")","v":0},{"$f":"IF(H35<>\"\",H36*H37,\"\")","v":0},0,0,0,0,{"$f":"IF(M35<>\"\",M35*M37,\"\")","v":0}]
[]
["Lønart"]
[3025,null,null,null,null,null,{"$f":"G35","v":0}]
[3425,null,null,null,null,null,{"$f":"H35","v":0}]
[3426,null,null,null,null,null,{"$f":"I35","v":0}]
["Timer",null,null,null,null,null,{"$f":"SUM(G41:G43)","v":0},{"$f":"IF(G44<>\"\",ROUND(G44*24,2),\"\")","v":0}]
[null,null,null,null,null,null,null,{"$f":"G37*H44","v":0}]

{"sheet":"Satser","index":3,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Timeløn",114.42]
["specielt tillæg"]
["Chauffør tillæg"]
[]
["Samlet timeløn",107.35,null,108.7]
[]
["overtidstillæg 50%",36.35,null,36.5]
["pr. time",{"$f":"B7+B9","v":143.69999999999999}]
[]
["overtidstillæg 100%",58.1,null,58.9]
["pr. time",{"$f":"B12+B7","v":165.45}]
[]
[null,108.65,null,110.15]
[]
["Aftentillæg",25.6,null,null,null,"Arbejde mellem 18:00 og 22:00, lørdag dog fra kl 14:00"]
["Nattillæg",34.200000000000003,null,null,null,"Arbejde mellem 22:00 og 06:00"]
[null,46.95]
["Søndagstillæg",28.68]
[]
["Ledbus",3]
["Trafiftælling",5]
["Delt tjeneste",67,null,"pr. arbejdsdag"]
[]
[null,"07:24:00"]

{"sheet":"norm","index":4,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["mandag",7.5,"07:30:00"]
["tirsdag",7.5,"07:30:00"]
["onsdag",7.5,"07:30:00"]
["torsdag",7.5,"07:30:00"]
["fredag",7,"07:00:00"]
["lørdag",0,"00:00:00"]
["søndag",0,"00:00:00"]

{"sheet":"Ark2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Ark3","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}