{"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":45,"n_cols":37,"rows_kept":45,"cut":false,"hidden":false,"merged":[[35,12,35,13],[37,12,37,13],[36,12,36,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[33,12,33,13],[34,12,34,13],[28,12,28,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[23,12,23,13],[21,10,21,11],[22,10,22,11],[23,10,23,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],[17,12,17,13],[26,10,26,11],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[33,10,33,11],[34,10,34,11],[35,10,35,11],[43,0,43,5],[41,0,41,2],[42,0,42,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],[15,10,15,11],[24,10,24,11],[25,10,25,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[39,0,39,2],[40,0,40,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],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[19,10,19,11],[20,10,20,11],[36,10,36,11],[37,10,37,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(A34,\"  -  dd mmmm åååå\"))","v":"05 December 2011  -  01 Januar 2012"},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":49},"-",null,{"$f":"IF(A28=\"\",\"\",TRUNC((A28-WEEKDAY(A28,2)-DATE(YEAR(A28+4-WEEKDAY(A28,2)),1,-10))/7))","v":52},null,null,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,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 06 - 18","Lørdag tillæg 18 - 06","Søndag tillæg 06 - 12","Søndag tillæg 12 - 06","Optjent afspadsering","Afholdt afspadsering","Syge Timer","norm"]
["2011-12-05",{"$f":"PROPER(TEXT(A4,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A4,0,0)","v":""},"07:00:00","14:45:00","00:15:00",{"$f":"IF(D4=\"\",\"\",(E4-D4)+(D4>E4)-F4+H4+I4+J4)","v":0.42708333333333331},"02:00:00","00:45:00",null,{"$f":"ColTime(TIME(18,0,0),TIME(22,0,0),D4,E4)","v":"00:00:00"},null,{"$f":"ColTime(TIME(22,0,0),TIME(6,0,0),D4,E4)","v":"00:00:00"},null,null,null,{"$f":"IF(D4=\"\",\"\",IF(D4<6/24,6/24-D4,\"\"))","v":""},null,{"$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":"07:30: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":14},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":45},"02:00:00","09:30:00","11:30:00"]
[{"$f":"A4+1","v":"2011-12-06"},{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Ti"},{"$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(22,0,0),D5,E5)","v":"03:30:00"},null,{"$f":"ColTime(TIME(22,0,0),TIME(6,0,0),D5,E5)","v":"00:00:00"},null,null,null,null,null,"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":"07:30:00"},null,null,13,45,"13:45:00",21,30,{"$f":"IF(E5=\"\",\"\",TIME(HOUR(E5),MINUTE(E5),0))","v":"21:30:00"}]
[{"$f":"A5+1","v":"2011-12-07"},{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"On"},"","22:00:00","05:45:00","00:15:00",0.31250000000000006,null,null,null,"00:00:00",null,"07:45:00",null,{"$f":"ColTime(TIME(6,0,0),TIME(18,0,0),D6,E6)","v":"00:00:00"},null,null,null,"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,22,0,"22:00:00",5,45,{"$f":"IF(E6=\"\",\"\",TIME(HOUR(E6),MINUTE(E6),0))","v":"05:45:00"}]
["2011-12-08","To","","05:00:00","12:45:00","00:15:00",0.48958333333333326,"02:00:00","02:00:00","00:15:00","00:00:00",null,{"$f":"ColTime(TIME(22,0,0),TIME(6,0,0),D7,E7)","v":"01:00:00"},null,null,null,null,null,"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,5,0,"05:00:00",12,45,"12:45:00"]
["2011-12-09","Fr","",null,null,null,"",null,null,null,"00:00:00",null,"00:00:00",null,null,null,null,null,"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:00:00"},null,null,"","","","","",""]
["2011-12-10","Lø","","06:00:00","19:00:00",null,0.54166666666666663,null,null,null,"01:00:00",null,"00:00:00",null,"12:00:00",{"$f":"ColTime(TIME(18,0,0),TIME(6,0,0),D9,E9)","v":"01:00:00"},null,null,"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":"00:00:00"},null,null,6,0,"06:00:00",19,0,"19:00:00"]
["2011-12-11","Sø","","07:00:00","19:00:00",null,0.49999999999999994,null,null,null,"01:00:00",null,"00:00:00",null,null,{"$f":"IF(D10<AJ1,ColTime(TIME(18,0,0),TIME(6,0,0),D10,AK1),0)","v":"00:00:00"},{"$f":"ColTime(TIME(6,0,0),TIME(12,0,0),D10,E10)","v":"05:00:00"},{"$f":"IF(D10<AJ1,ColTime(TIME(12,0,0),TIME(6,0,0),AJ1,E10),ColTime(TIME(12,0,0),TIME(6,0,0),D10,E10))","v":"07:00:00"},"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":"00:00:00"},null,null,7,0,"07:00:00",19,0,"19:00:00"]
[null,null,null,null,null,null,{"$f":"IF(D11=\"\",\"\",(E11-D11)+(D11>E11)-F11+H11+I11)","v":""},null,null,null,null,null,{"$f":"IF(G11=\"\",\"\",IF((E11-MAX(D11,(22/24))+(D11>E11))<0,0,(IF(E11<D11,IF(E11>6/24,6/24,E11),E11)-MAX(D11,(22/24)))+(D11>E11))+(6/24)-MIN(D11,(6/24)))","v":""},null,null,null,null,null,{"$f":"IF(G11=\"\",\"\",IF(G11<>0,IF(C11<>\"\",IF(O11+Q11=0,Satser!B$26,((O11+Q11)*24)*(24/1440)+Satser!B$26),IF(O11+Q11=0,\"\",((O11+Q11)*24)*(24/1440))),\"\"))","v":""},null,null,null,null,null,"","","","","",""]
[{"$f":"A10+1","v":"2011-12-12"},{"$f":"PROPER(TEXT(A12,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A12,0,0)","v":""},null,null,null,"",null,null,null,{"$f":"IF(D12=\"\",\"\",(IF(E12-MAX(D12,(17/24))+(E12<D12)<0,0,E12-MAX(D12,(17/24))+(E12<D12)))-(IF((E12-MAX(D12,(23/24))+(E12<D12))<0,0,(E12-MAX(D12,(23/24))+(E12<D12)))))","v":""},null,"",null,null,null,{"$f":"IF(D12=\"\",\"\",IF(D12<6/24,6/24-D12,\"\"))","v":""},null,{"$f":"IF(G12=\"\",\"\",IF(G12<>0,IF(C12<>\"\",IF(O12+Q12=0,Satser!B$26,((O12+Q12)*24)*(24/1440)+Satser!B$26),IF(O12+Q12=0,\"\",((O12+Q12)*24)*(24/1440))),\"\"))","v":""},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":"07:30:00"},null,null,"","","","","",""]
[{"$f":"A12+1","v":"2011-12-13"},{"$f":"PROPER(TEXT(A13,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A13,0,0)","v":""},null,null,null,"",null,null,null,{"$f":"IF(D13=\"\",\"\",(IF(E13-MAX(D13,(17/24))+(E13<D13)<0,0,E13-MAX(D13,(17/24))+(E13<D13)))-(IF((E13-MAX(D13,(23/24))+(E13<D13))<0,0,(E13-MAX(D13,(23/24))+(E13<D13)))))","v":""},null,"",null,null,null,null,null,{"$f":"IF(G13=\"\",\"\",IF(G13<>0,IF(C13<>\"\",IF(O13+Q13=0,Satser!B$26,((O13+Q13)*24)*(24/1440)+Satser!B$26),IF(O13+Q13=0,\"\",((O13+Q13)*24)*(24/1440))),\"\"))","v":""},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":"A13+1","v":"2011-12-14"},{"$f":"PROPER(TEXT(A14,\"ddd\"))","v":"On"},"",null,null,null,{"$f":"IF(D14=\"\",\"\",(E14-D14)+(D14>E14)-F14+H14+I14)","v":""},null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G14=\"\",\"\",IF(G14<>0,IF(C14<>\"\",IF(O14+Q14=0,Satser!B$26,((O14+Q14)*24)*(24/1440)+Satser!B$26),IF(O14+Q14=0,\"\",((O14+Q14)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
["2011-12-15","To","",null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G15=\"\",\"\",IF(G15<>0,IF(C15<>\"\",IF(O15+Q15=0,Satser!B$26,((O15+Q15)*24)*(24/1440)+Satser!B$26),IF(O15+Q15=0,\"\",((O15+Q15)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
["2011-12-16","Fr","",null,null,null,"",null,null,null,{"$f":"IF(D16=\"\",\"\",(IF(E16-MAX(D16,(17/24))+(E16<D16)<0,0,E16-MAX(D16,(17/24))+(E16<D16)))-(IF((E16-MAX(D16,(23/24))+(E16<D16))<0,0,(E16-MAX(D16,(23/24))+(E16<D16)))))","v":""},null,"",null,{"$f":"IF(D16=\"\",\"\",IF(E16<D16,IF(E16>6/24,E16-6/24,\"\"),\"\"))","v":""},null,null,null,{"$f":"IF(G16=\"\",\"\",IF(G16<>0,IF(C16<>\"\",IF(O16+Q16=0,Satser!B$26,((O16+Q16)*24)*(24/1440)+Satser!B$26),IF(O16+Q16=0,\"\",((O16+Q16)*24)*(24/1440))),\"\"))","v":""},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:00:00"},null,null,"","","","","",""]
["2011-12-17","Lø","",null,null,null,"",null,null,null,"",null,"",null,{"$f":"IF(D17=\"\",\"\",IF((E17-MAX(D17,(6/24))+(D17>E17))<0,0,(IF(E17<D17,IF(E17>6/24,6/24,E17),E17)-MAX(D17,(6/24)))+(D17>E17))+(6/24)-MIN(E17,(6/24)))","v":""},null,{"$f":"IF(E17<D17,IF(E17>6/24,E17-6/24,\"\"),\"\")","v":""},null,{"$f":"IF(G17=\"\",\"\",IF(G17<>0,IF(C17<>\"\",IF(O17+Q17=0,Satser!B$26,((O17+Q17)*24)*(24/1440)+Satser!B$26),IF(O17+Q17=0,\"\",((O17+Q17)*24)*(24/1440))),\"\"))","v":""},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":"00:00:00"},null,null,"","","","","",""]
["2011-12-18","Sø","",null,null,null,"",null,null,null,"",null,"",null,{"$f":"IF(D18=\"\",\"\",IF(D18<6/24,IF(E18<6/24,6/24-D18-(6/24-E18),6/24-D18),\"00:00\"))","v":""},null,{"$f":"IF(D18=\"\",\"\",IF((E18-MAX(D18,(6/24))+(D18>E18))<0,0,(IF(E18<D18,IF(E18>6/24,6/24,E18),E18)-MAX(D18,(6/24)))+(D18>E18))+(6/24)-MIN(E18,(6/24)))","v":""},null,{"$f":"IF(G18=\"\",\"\",IF(G18<>0,IF(C18<>\"\",IF(O18+Q18=0,Satser!B$26,((O18+Q18)*24)*(24/1440)+Satser!B$26),IF(O18+Q18=0,\"\",((O18+Q18)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
[null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,{"$f":"IF(G19=\"\",\"\",IF(G19<>0,IF(C19<>\"\",IF(O19+Q19=0,Satser!B$26,((O19+Q19)*24)*(24/1440)+Satser!B$26),IF(O19+Q19=0,\"\",((O19+Q19)*24)*(24/1440))),\"\"))","v":""},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":"A18+1","v":"2011-12-19"},{"$f":"PROPER(TEXT(A20,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A20,0,0)","v":""},null,null,null,"",null,null,null,{"$f":"IF(D20=\"\",\"\",(IF(E20-MAX(D20,(17/24))+(E20<D20)<0,0,E20-MAX(D20,(17/24))+(E20<D20)))-(IF((E20-MAX(D20,(23/24))+(E20<D20))<0,0,(E20-MAX(D20,(23/24))+(E20<D20)))))","v":""},null,"",null,null,null,{"$f":"IF(D20=\"\",\"\",IF(D20<6/24,6/24-D20,\"\"))","v":""},null,{"$f":"IF(G20=\"\",\"\",IF(G20<>0,IF(C20<>\"\",IF(O20+Q20=0,Satser!B$26,((O20+Q20)*24)*(24/1440)+Satser!B$26),IF(O20+Q20=0,\"\",((O20+Q20)*24)*(24/1440))),\"\"))","v":""},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":"A20+1","v":"2011-12-20"},{"$f":"PROPER(TEXT(A21,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A21,0,0)","v":""},null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G21=\"\",\"\",IF(G21<>0,IF(C21<>\"\",IF(O21+Q21=0,Satser!B$26,((O21+Q21)*24)*(24/1440)+Satser!B$26),IF(O21+Q21=0,\"\",((O21+Q21)*24)*(24/1440))),\"\"))","v":""},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":"A21+1","v":"2011-12-21"},{"$f":"PROPER(TEXT(A22,\"ddd\"))","v":"On"},"",null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G22=\"\",\"\",IF(G22<>0,IF(C22<>\"\",IF(O22+Q22=0,Satser!B$26,((O22+Q22)*24)*(24/1440)+Satser!B$26),IF(O22+Q22=0,\"\",((O22+Q22)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
["2011-12-22","To","",null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G23=\"\",\"\",IF(G23<>0,IF(C23<>\"\",IF(O23+Q23=0,Satser!B$26,((O23+Q23)*24)*(24/1440)+Satser!B$26),IF(O23+Q23=0,\"\",((O23+Q23)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
["2011-12-23","Fr","",null,null,null,"",null,null,null,"",null,"",null,{"$f":"IF(E24<D24,IF(E24>6/24,E24-6/24,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(G24=\"\",\"\",IF(G24<>0,IF(C24<>\"\",IF(O24+Q24=0,Satser!B$26,((O24+Q24)*24)*(24/1440)+Satser!B$26),IF(O24+Q24=0,\"\",((O24+Q24)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
["2011-12-24","Lø","Julaftensdag",null,null,null,"",null,null,null,"",null,"",null,{"$f":"IF(D25=\"\",\"\",IF((E25-MAX(D25,(6/24))+(D25>E25))<0,0,(IF(E25<D25,IF(E25>6/24,6/24,E25),E25)-MAX(D25,(6/24)))+(D25>E25))+(6/24)-MIN(E25,(6/24)))","v":""},null,{"$f":"IF(E25<D25,IF(E25>6/24,E25-6/24,\"\"),\"\")","v":""},null,{"$f":"IF(G25=\"\",\"\",IF(G25<>0,IF(C25<>\"\",IF(O25+Q25=0,Satser!B$26,((O25+Q25)*24)*(24/1440)+Satser!B$26),IF(O25+Q25=0,\"\",((O25+Q25)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
["2011-12-25","Sø","1. Juledag",null,null,null,"",null,null,null,"",null,"",null,{"$f":"IF(D26=\"\",\"\",IF(D26<6/24,IF(E26<6/24,6/24-D26-(6/24-E26),6/24-D26),\"00:00\"))","v":""},null,{"$f":"IF(D26=\"\",\"\",IF((E26-MAX(D26,(6/24))+(D26>E26))<0,0,(IF(E26<D26,IF(E26>6/24,6/24,E26),E26)-MAX(D26,(6/24)))+(D26>E26))+(6/24)-MIN(E26,(6/24)))","v":""},null,{"$f":"IF(G26=\"\",\"\",IF(G26<>0,IF(C26<>\"\",IF(O26+Q26=0,Satser!B$26,((O26+Q26)*24)*(24/1440)+Satser!B$26),IF(O26+Q26=0,\"\",((O26+Q26)*24)*(24/1440))),\"\"))","v":""},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,"","","","","",""]
[null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,{"$f":"IF(G27=\"\",\"\",IF(G27<>0,IF(C27<>\"\",IF(O27+Q27=0,Satser!B$26,((O27+Q27)*24)*(24/1440)+Satser!B$26),IF(O27+Q27=0,\"\",((O27+Q27)*24)*(24/1440))),\"\"))","v":""},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":"00:00:00"},null,null,"","","","","",""]
[{"$f":"A26+1","v":"2011-12-26"},{"$f":"PROPER(TEXT(A28,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A28,0,0)","v":"2. Juledag"},null,null,null,"",null,null,null,{"$f":"IF(D28=\"\",\"\",(IF(E28-MAX(D28,(17/24))+(E28<D28)<0,0,E28-MAX(D28,(17/24))+(E28<D28)))-(IF((E28-MAX(D28,(23/24))+(E28<D28))<0,0,(E28-MAX(D28,(23/24))+(E28<D28)))))","v":""},null,"",null,null,null,{"$f":"IF(D28=\"\",\"\",IF(D28<6/24,6/24-D28,\"\"))","v":""},null,{"$f":"IF(G28=\"\",\"\",IF(G28<>0,IF(C28<>\"\",IF(O28+Q28=0,Satser!B$26,((O28+Q28)*24)*(24/1440)+Satser!B$26),IF(O28+Q28=0,\"\",((O28+Q28)*24)*(24/1440))),\"\"))","v":""},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":"A28+1","v":"2011-12-27"},{"$f":"PROPER(TEXT(A29,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A29,0,0)","v":""},null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G29=\"\",\"\",IF(G29<>0,IF(C29<>\"\",IF(O29+Q29=0,Satser!B$26,((O29+Q29)*24)*(24/1440)+Satser!B$26),IF(O29+Q29=0,\"\",((O29+Q29)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A29,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":"A29+1","v":"2011-12-28"},{"$f":"PROPER(TEXT(A30,\"ddd\"))","v":"On"},"",null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G30=\"\",\"\",IF(G30<>0,IF(C30<>\"\",IF(O30+Q30=0,Satser!B$26,((O30+Q30)*24)*(24/1440)+Satser!B$26),IF(O30+Q30=0,\"\",((O30+Q30)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A30,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,"","","","","",""]
["2011-12-29","To","",null,null,null,"",null,null,null,"",null,"",null,null,null,null,null,{"$f":"IF(G31=\"\",\"\",IF(G31<>0,IF(C31<>\"\",IF(O31+Q31=0,Satser!B$26,((O31+Q31)*24)*(24/1440)+Satser!B$26),IF(O31+Q31=0,\"\",((O31+Q31)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A31,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,"","","","","",""]
["2011-12-30","Fr",null,null,null,null,"",null,null,null,"",null,"",null,{"$f":"IF(E32<D32,IF(E32>6/24,E32-6/24,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(G32=\"\",\"\",IF(G32<>0,IF(C32<>\"\",IF(O32+Q32=0,Satser!B$26,((O32+Q32)*24)*(24/1440)+Satser!B$26),IF(O32+Q32=0,\"\",((O32+Q32)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A32,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,"","","","","",""]
["2011-12-31","Lø","Nytårsaftensdag",null,null,null,"",null,null,null,"",null,"",null,{"$f":"IF(D33=\"\",\"\",IF((E33-MAX(D33,(6/24))+(D33>E33))<0,0,(IF(E33<D33,IF(E33>6/24,6/24,E33),E33)-MAX(D33,(6/24)))+(D33>E33))+(6/24)-MIN(E33,(6/24)))","v":""},null,{"$f":"IF(E33<D33,IF(E33>6/24,E33-6/24,\"\"),\"\")","v":""},null,{"$f":"IF(G33=\"\",\"\",IF(G33<>0,IF(C33<>\"\",IF(O33+Q33=0,Satser!B$26,((O33+Q33)*24)*(24/1440)+Satser!B$26),IF(O33+Q33=0,\"\",((O33+Q33)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A33,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,"","","","","",""]
["2012-01-01","Sø","Nytårsdag",null,null,null,"",null,null,null,{"$f":"IF(D34=\"\",\"\",(IF(E34-MAX(D34,(17/24))+(E34<D34)<0,0,E34-MAX(D34,(17/24))+(E34<D34)))-(IF((E34-MAX(D34,(23/24))+(E34<D34))<0,0,(E34-MAX(D34,(23/24))+(E34<D34)))))","v":""},null,{"$f":"IF(G34=\"\",\"\",IF((E34-MAX(D34,(22/24))+(D34>E34))<0,0,(IF(E34<D34,IF(E34>6/24,6/24,E34),E34)-MAX(D34,(22/24)))+(D34>E34))+(6/24)-MIN(D34,(6/24)))","v":""},null,{"$f":"IF(D34=\"\",\"\",IF(D34<6/24,IF(E34<6/24,6/24-D34-(6/24-E34),6/24-D34),\"00:00\"))","v":""},null,{"$f":"IF(D34=\"\",\"\",IF((E34-MAX(D34,(6/24))+(D34>E34))<0,0,(IF(E34<D34,IF(E34>6/24,6/24,E34),E34)-MAX(D34,(6/24)))+(D34>E34))+(6/24)-MIN(E34,(6/24)))","v":""},null,{"$f":"IF(G34=\"\",\"\",IF(G34<>0,IF(C34<>\"\",IF(O34+Q34=0,Satser!B$26,((O34+Q34)*24)*(24/1440)+Satser!B$26),IF(O34+Q34=0,\"\",((O34+Q34)*24)*(24/1440))),\"\"))","v":""},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":"00:00:00"},null,null,"","","","","",""]
["Total timer",null,null,null,null,null,{"$f":"IF(SUM(G9:G34)<>\"0\",SUM(G4:G34),\"\")","v":2.5833333333333335},{"$f":"IF(SUM(H4:H34)<>\"0\",SUM(H4:H34),\"\")","v":0.16666666666666666},0.11458333333333333,1.0416666666666666E-2,{"$f":"IF(SUM(K4:K34)<>\"0\",SUM(K4:K34),\"\")","v":0.22916666666666663},null,{"$f":"SUM(M4:N34)","v":"08:45:00"},null,{"$f":"IF(SUM(O4:O34)<>\"0\",SUM(O4:O34),\"\")","v":0.5},{"$f":"IF(SUM(P4:P34)<>\"0\",SUM(P4:P34),\"\")","v":4.166666666666663E-2},{"$f":"IF(SUM(Q4:Q34)<>\"0\",SUM(Q4:Q34),\"\")","v":"05:00:00"},{"$f":"IF(SUM(R4:R34)<>\"0\",SUM(R4:R34),\"\")","v":"07:00:00"},{"$f":"SUM(S4:S34)","v":0.29166666666666663},{"$f":"SUM(T4:T34)","v":0}]
["Timer 1/100",null,null,null,null,null,{"$f":"IF(G35<>\"\",ROUND(G35*24,2),\"\")","v":62},{"$f":"IF(H35<>\"\",ROUND(H35*24,2),\"\")","v":4},2.75,0.25,{"$f":"IF(K35<>\"\",ROUND(K35*24,2),\"\")","v":5.5},null,{"$f":"IF(M35<>\"\",ROUND(M35*24,2),\"\")","v":8.75},null,{"$f":"IF(O35<>\"\",ROUND(O35*24,2),\"\")","v":12},1,5,7,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":24.4},null,{"$f":"Satser!B19","v":46.95},null,28.68,null,67]
[null,null,null,null,null,null,{"$f":"IF(G35<>\"\",G36*G37,\"\")","v":6655.7},{"$f":"IF(H35<>\"\",H36*H37,\"\")","v":145.4},159.77500000000001,27.162500000000001,{"$f":"IF(K35<>\"\",K36*K37,\"\")","v":134.19999999999999},null,{"$f":"IF(M35<>\"\",M36*M36,\"\")","v":76.5625},null,{"$f":"IF(N35<>\"\",M36*M37,\"\")","v":""},null,null,{"$f":"IF(Q35<>\"\",Q35*Q37,\"\")","v":13.958333333333332}]
[]
["Lønart"]
[3025,null,null,null,null,null,{"$f":"G35","v":2.5833333333333335}]
[3425,null,null,null,null,null,{"$f":"H35","v":0.16666666666666666}]
[3428,null,null,null,null,null,{"$f":"J35","v":1.0416666666666666E-2}]
["Timer",null,null,null,null,null,{"$f":"SUM(G41:G43)","v":2.7604166666666665},{"$f":"IF(G44<>\"\",ROUND(G44*24,2),\"\")","v":66.25}]
[null,null,null,null,null,null,null,{"$f":"G37*H44","v":7111.9375}]

{"sheet":"Tomt","index":2,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":true,"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",119.62]
["specielt tillæg",1.19]
["Chauffør tillæg",4.95]
[]
["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",24.4,null,null,null,"Arbejde mellem 18:00 og 22:00, lørdag dog fra kl 14:00"]
["Nattillæg",39.75,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":[]}