{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Juni2010 (2)","september2010","Data","Satser","Ark3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Juni2010 (2)","index":0,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":true,"merged":[[43,0,43,3],[0,1,0,5],[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!"},{"$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!"},{"$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!"},{"$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,{"$f":"IF(A34=\"\",\"\",PROPER(TEXT(A34,\"ddd\")))","v":""},"",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":125.76},{"$f":"Satser!B9","v":59.81},{"$f":"Satser!B12","v":119.62},18.8,21.81,28.68,67]
[null,null,null,null,null,null,{"$f":"IF(G35<>\"\",G36*G37,\"\")","v":{"$error":"#REF!"}},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":25,"n_cols":18,"rows_kept":25,"cut":false,"hidden":false,"merged":[[14,7,14,8],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[4,7,4,8],[4,9,4,10],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[16,9,16,10],[23,0,23,4],[24,0,24,4],[29,0,29,2],[30,0,30,2],[22,7,22,8],[23,7,23,8],[2,1,2,5],[2,8,2,9],[3,7,3,8],[5,7,5,8],[5,9,5,10],[3,9,3,10],[6,9,6,10],[7,9,7,10],[31,0,31,2],[3,1,3,2],[5,1,5,2],[27,0,27,2],[28,0,28,2],[20,0,20,4],[21,0,21,4],[22,0,22,4]]}
[null,null,null,null,null,"05:00:00"]
[]
["Løn",{"$f":"PROPER(TEXT(A7,\"dd mmmm åååå\")) & PROPER(TEXT(A20,\"  -  dd mmmm åååå\"))","v":"03 April 2023  -  16 April 2023"},null,null,null,null,"Uge :",{"$f":"IF(A7=\"\",\"\",TRUNC((A7-WEEKDAY(A7,2)-DATE(YEAR(A7+4-WEEKDAY(A7,2)),1,-10))/7))","v":14},"-",null,{"$f":"IF(A14=\"\",\"\",TRUNC((A14-WEEKDAY(A14,2)-DATE(YEAR(A14+4-WEEKDAY(A14,2)),1,-10))/7))","v":15}]
["Lønart",null,null,null,null,null,"6-18","18-21",null,"21-06"]
[]
["Dato","Dag",null,"Start","Slut","Arb. Tid","Dag\n06-18","Aftenstillæg\n18-21",null,"NatTimer\n21-06"]
["2023-04-03",{"$f":"PROPER(TEXT(A7,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A7,0,0)","v":""},"14:00:00","00:45:00",{"$f":"IF(D7=\"\",\"\",(E7-D7)+(D7>E7))","v":"10:45:00"},{"$f":"IF(AND(D7<>\"\",E7<>\"\"),ColTime(D7,E7,Data!$J$3,Data!$L$3),\"\")","v":"04:00:00"},{"$f":"IF(AND($D$7<>\"\",$E$7<>\"\"),ColTime($D$7,$E$7,Data!$J$4,Data!$L$4),\"\")","v":"03:00:00"},null,{"$f":"IF(AND($D$7<>\"\",$E$7<>\"\"),ColTime($D$7,$E$7,Data!$J$5,Data!$L$5),\"\")","v":"03:45:00"}]
[{"$f":"A7+1","v":"2023-04-04"},"Ti",{"$f":"HelligdagsNavn(A8,0,0)","v":""},null,null,"",{"$f":"IF(AND(D8<>\"\",E8<>\"\"),ColTime(D8,E8,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D8<>\"\",E8<>\"\"),ColTime(D8,E8,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D8<>\"\",E8<>\"\"),ColTime(D8,E8,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-05","On","",null,null,"",{"$f":"IF(AND(D9<>\"\",E9<>\"\"),ColTime(D9,E9,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D9<>\"\",E9<>\"\"),ColTime(D9,E9,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D9<>\"\",E9<>\"\"),ColTime(D9,E9,Data!$J$5,Data!$L$5),\"\")","v":""},null,null,null,null,null,null,null,"indtast kun i de grønne celler"]
["2023-04-06","To","Skærtorsdag",null,null,"",{"$f":"IF(AND(D10<>\"\",E10<>\"\"),ColTime(D10,E10,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D10<>\"\",E10<>\"\"),ColTime(D10,E10,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D10<>\"\",E10<>\"\"),ColTime(D10,E10,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-07","Fr","Langfredag",null,null,"",{"$f":"IF(AND(D11<>\"\",E11<>\"\"),ColTime(D11,E11,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D11<>\"\",E11<>\"\"),ColTime(D11,E11,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D11<>\"\",E11<>\"\"),ColTime(D11,E11,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-08","Lø","",null,null,"",{"$f":"IF(AND(D12<>\"\",E12<>\"\"),ColTime(D12,E12,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D12<>\"\",E12<>\"\"),ColTime(D12,E12,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D12<>\"\",E12<>\"\"),ColTime(D12,E12,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-09","Sø","Påskedag",null,null,"",{"$f":"IF(AND(D13<>\"\",E13<>\"\"),ColTime(D13,E13,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D13<>\"\",E13<>\"\"),ColTime(D13,E13,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D13<>\"\",E13<>\"\"),ColTime(D13,E13,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-10","Ma",{"$f":"HelligdagsNavn(A14,0,0)","v":"2. Påskedag"},null,null,"",{"$f":"IF(AND(D14<>\"\",E14<>\"\"),ColTime(D14,E14,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D14<>\"\",E14<>\"\"),ColTime(D14,E14,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D14<>\"\",E14<>\"\"),ColTime(D14,E14,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-11","Ti",{"$f":"HelligdagsNavn(A15,0,0)","v":""},"14:00:00","00:45:00",{"$f":"IF(D15=\"\",\"\",(E15-D15)+(D15>E15))","v":"10:45:00"},{"$f":"IF(AND(D15<>\"\",E15<>\"\"),ColTime(D15,E15,Data!$J$3,Data!$L$3),\"\")","v":"04:00:00"},{"$f":"IF(AND(D15<>\"\",E15<>\"\"),ColTime(D15,E15,Data!$J$4,Data!$L$4),\"\")","v":"03:00:00"},null,{"$f":"IF(AND(D15<>\"\",E15<>\"\"),ColTime(D15,E15,Data!$J$5,Data!$L$5),\"\")","v":"03:45:00"}]
["2023-04-12","On","",null,null,"",{"$f":"IF(AND(D16<>\"\",E16<>\"\"),ColTime(D16,E16,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D16<>\"\",E16<>\"\"),ColTime(D16,E16,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D16<>\"\",E16<>\"\"),ColTime(D16,E16,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-13","To","",null,null,"",{"$f":"IF(AND(D17<>\"\",E17<>\"\"),ColTime(D17,E17,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D17<>\"\",E17<>\"\"),ColTime(D17,E17,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D17<>\"\",E17<>\"\"),ColTime(D17,E17,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-14","Fr","",null,null,"",{"$f":"IF(AND(D18<>\"\",E18<>\"\"),ColTime(D18,E18,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D18<>\"\",E18<>\"\"),ColTime(D18,E18,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D18<>\"\",E18<>\"\"),ColTime(D18,E18,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-15","Lø","",null,null,"",{"$f":"IF(AND(D19<>\"\",E19<>\"\"),ColTime(D19,E19,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D19<>\"\",E19<>\"\"),ColTime(D19,E19,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D19<>\"\",E19<>\"\"),ColTime(D19,E19,Data!$J$5,Data!$L$5),\"\")","v":""}]
["2023-04-16","Sø","",null,null,"",{"$f":"IF(AND(D20<>\"\",E20<>\"\"),ColTime(D20,E20,Data!$J$3,Data!$L$3),\"\")","v":""},{"$f":"IF(AND(D20<>\"\",E20<>\"\"),ColTime(D20,E20,Data!$J$4,Data!$L$4),\"\")","v":""},null,{"$f":"IF(AND(D20<>\"\",E20<>\"\"),ColTime(D20,E20,Data!$J$5,Data!$L$5),\"\")","v":""}]
["Total timer",null,null,null,null,{"$f":"IF(SUM(F12:F20)<>\"0\",SUM(F7:F20),\"\")","v":0.89583333333333326},{"$f":"IF(SUM(G7:G20)<>\"0\",SUM(G7:G20),\"\")","v":0.33333333333333326},{"$f":"IF(SUM(H7:H20)<>\"0\",SUM(H7:H20),\"\")","v":0.25},null,{"$f":"IF(SUM(J7:J20)<>\"0\",SUM(J7:J20),\"\")","v":0.3125}]
["Timer 1/100",null,null,null,null,{"$f":"IF(F21<>\"\",ROUND(F21*24,2),\"\")","v":21.5},{"$f":"IF(G21<>\"\",ROUND(G21*24,2),\"\")","v":8},6,null,7.5]
["Satser",null,null,null,null,{"$f":"Data!B14","v":125},{"$f":"Data!B19","v":125},{"$f":"Data!B16","v":27.5},null,{"$f":"Data!B18","v":90}]
[null,null,null,null,null,{"$f":"IF(F21<>\"\",F22*F23,\"\")","v":2687.5},{"$f":"IF(G21<>\"\",G22*G23,\"\")","v":1000},165,null,675]
["Løn",null,null,null,null,{"$f":"SUM(F24:P24)","v":4527.5}]

{"sheet":"Data","index":2,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Timeløn","Tillæg",null,"Start","Slut"]
["Normal løn",null,null,null,"06:00:00","18:00:00",null,"Dagtimer","Fra kl.","06:00:00","Til kl.","18:00:00"]
["Hverdagstillæg",null,null,null,"18:00:00","06:00:00",null,"AftenTimer","Fra kl.","18:00:00","Til kl.","21:00:00"]
["Lørdag",null,null,null,"00:00:00","14:59:00",null,"NatTimer","Fra kl.","21:00:00","Til kl.","06:00:00"]
["Lørdagstillæg",null,null,null,"15:00:00",1,null,"Morgentimer","Fra kl.","04:00:00","Til kl.","06:00:00"]
["Søn- og helligdage",null,null,null,"00:00:00","23:59:00",null,"Grundlovsdag","Fra kl.","12:00:00","Til kl.","00:00:00"]
[]
[]
[]
[]
[]
[]
["Grundløn",125]
[0,{"$f":"$B$14*A15","v":0}]
[0.22,27.5]
[0.5,62.5]
[0.72,90]
[1,125]
[1.22,152.5]

{"sheet":"Satser","index":3,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Timeløn",119.62]
["specielt tillæg",1.19]
["Chauffør tillæg",4.95]
[]
["Samlet timeløn",{"$f":"SUM(B3:B5)","v":125.76}]
[]
["overtidstillæg 50%",59.81]
["pr. time",{"$f":"B7+B9","v":185.57}]
[]
["overtidstillæg 100%",119.62]
["pr. time",{"$f":"B12+B7","v":245.38}]
[]
["Aftentillæg",18.8,null,"Arbejde mellem 18:00 og 24:00, lørdag dog fra kl 14:00"]
["Nattillæg",21.81,null,"Arbejde mellem 24:00 og 06:00"]
["Søndagstillæg",28.68]
[]
["Ledbus",3]
["Trafiftælling",5]
["Delt tjeneste",67,null,"pr. arbejdsdag"]
[]
[null,"07:24:00"]

{"sheet":"Ark3","index":4,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["https://petlibrary.tripod.com/index.htm"]
[]
["https://commodore.bombjack.org/commodore/books-comal.htm"]