{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Juni2010 (2)","september2010","Tomt","Satser","Timeberegning","Ark1","Ark2","Ark3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":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,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D4,Timeberegning!A$4:B$153,2)))","v":"05:54:00"},{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D4,Timeberegning!A$4:C$153,3)))","v":"14:57:00"},{"$f":"IF($D4=\"\",\"\",VLOOKUP($D4,Timeberegning!$A$4:$O$10,13))","v":"08:54:00"},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":"00:06:00"},{"$f":"IF(G4<>0,IF(WEEKDAY(A4,2)=7,G4,\"\"),\"\")","v":""},{"$f":"IF($D4=\"\",\"\",IF(VLOOKUP($D4,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D4,Timeberegning!$A$4:$O$101,15)))","v":""},{"$f":"IF(SUM(H4:I4)=0,\"\",SUM(H4:I4))","v":""},null,null,{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":5},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":54},{"$f":"IF(E4=\"\",\"\",TIME(HOUR(E4),MINUTE(E4),0))","v":"05:54:00"},{"$f":"IF(F4=\"\",\"\",HOUR(F4))","v":14},{"$f":"IF(F4=\"\",\"\",MINUTE(F4))","v":57},{"$f":"TIME(HOUR(F4),MINUTE(F4),0)","v":"14:57:00"}]
["2010-04-02",{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Fr"},{"$f":"HelligdagsNavn(A5,0,0)","v":"Langfredag"},134,{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D5,Timeberegning!A$4:B$153,2)))","v":"07:07:00"},{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D5,Timeberegning!A$4:C$153,3)))","v":"16:16:00"},{"$f":"IF($D5=\"\",\"\",VLOOKUP($D5,Timeberegning!$A$4:$O$153,13))","v":"08:34:00"},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,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D5,Timeberegning!$A$4:$O$101,15)))","v":""},{"$f":"IF(SUM(H5:I5)=0,\"\",SUM(H5:I5))","v":""},null,null,7,7,"07:07:00",16,16,{"$f":"TIME(HOUR(F5),MINUTE(F5),0)","v":"16:16:00"}]
["2010-04-03",{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"Lø"},"",612,{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D6,Timeberegning!A$4:B$153,2)))","v":"14:55:00"},{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D6,Timeberegning!A$4:C$153,3)))","v":"00:22:00"},{"$f":"IF($D6=\"\",\"\",VLOOKUP($D6,Timeberegning!$A$4:$O$153,13))","v":"08:46:00"},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":"09:05:00"},"00:22:00","",{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D6,Timeberegning!$A$4:$O$101,15)))","v":""},"",null,null,14,55,"14:55:00",0,22,{"$f":"TIME(HOUR(F6),MINUTE(F6),0)","v":"00:22:00"}]
["2010-04-04","Sø","Påskedag",711,{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D7,Timeberegning!A$4:B$153,2)))","v":"13:55:00"},{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D7,Timeberegning!A$4:C$153,3)))","v":"22:22:00"},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,Timeberegning!$A$4:$O$153,13))","v":"08:24:00"},null,null,"04:22:00","","08:24:00",{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D7,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D7,Timeberegning!$A$4:$P$101,16)))","v":""},null,13,55,"13:55:00",22,22,{"$f":"TIME(HOUR(F7),MINUTE(F7),0)","v":"22:22:00"}]
["2010-04-05","Ma","2. Påskedag",122,{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D8,Timeberegning!A$4:B$153,2)))","v":"04:36:00"},{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D8,Timeberegning!A$4:C$153,3)))","v":"11:58:00"},{"$f":"IF($D8=\"\",\"\",VLOOKUP($D8,Timeberegning!$A$4:$O$153,13))","v":"06:47:00"},null,null,"","01:24:00","",{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D8,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D8,Timeberegning!$A$4:$P$101,16)))","v":""},null,4,36,"04:36:00",11,58,{"$f":"TIME(HOUR(F8),MINUTE(F8),0)","v":"11:58:00"}]
["2010-04-06","Ti","",124,{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D9,Timeberegning!A$4:B$153,2)))","v":"05:20:00"},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D9,Timeberegning!A$4:C$153,3)))","v":"12:53:00"},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,Timeberegning!$A$4:$O$153,13))","v":"07:29:00"},null,null,"","00:40:00",{"$f":"IF(G9<>0,IF(WEEKDAY(A9,2)=7,G9,\"\"),\"\")","v":""},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D9,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D9,Timeberegning!$A$4:$P$101,16)))","v":""},null,5,20,"05:20:00",12,53,{"$f":"IF(F9=\"\",\"\",TIME(HOUR(F9),MINUTE(F9),0))","v":"12:53:00"}]
["2010-04-07","On","",606,{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D10,Timeberegning!A$4:B$153,2)))","v":"06:07:00"},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D10,Timeberegning!A$4:C$153,3)))","v":"15:15:00"},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D10,Timeberegning!$A$4:$O$153,13)))","v":"08:46:00"},null,null,"","",{"$f":"IF(G10<>0,IF(WEEKDAY(A10,2)=7,G10,\"\"),\"\")","v":""},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D10,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D10,Timeberegning!$A$4:$P$101,16)))","v":""},null,6,7,"06:07:00",15,15,"15:15:00"]
["2010-04-08","To","",122,{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D11,Timeberegning!A$4:B$153,2)))","v":"04:36:00"},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D11,Timeberegning!A$4:C$153,3)))","v":"11:58:00"},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D11,Timeberegning!$A$4:$O$153,13)))","v":"06:47:00"},null,null,"","01:24:00",{"$f":"IF(G11<>0,IF(WEEKDAY(A11,2)=7,G11,\"\"),\"\")","v":""},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D11,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D11,Timeberegning!$A$4:$P$101,16)))","v":""},null,4,36,"04:36:00",11,58,"11:58:00"]
["2010-04-09","Fr","","afsp.",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D12,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D12,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$P$101,16)))","v":"07:24:00"},null,"","","","","",""]
["2010-04-10","Lø","",121,{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D13,Timeberegning!A$4:B$153,2)))","v":"04:36:00"},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D13,Timeberegning!A$4:C$153,3)))","v":"11:24:00"},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D13,Timeberegning!$A$4:$O$153,13)))","v":"06:45:00"},null,null,"","01:24:00","",{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D13,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D13,Timeberegning!$A$4:$P$101,16)))","v":""},null,4,36,"04:36:00",11,24,"11:24:00"]
["2010-04-11","Sø","",606,{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D14,Timeberegning!A$4:B$153,2)))","v":"06:07:00"},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D14,Timeberegning!A$4:C$153,3)))","v":"15:15:00"},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D14,Timeberegning!$A$4:$O$153,13)))","v":"08:46:00"},null,null,"","","08:46:00",{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D14,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D14,Timeberegning!$A$4:$P$101,16)))","v":""},null,6,7,"06:07:00",15,15,"15:15:00"]
["2010-04-12","Ma","",606,{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D15,Timeberegning!A$4:B$153,2)))","v":"06:07:00"},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D15,Timeberegning!A$4:C$153,3)))","v":"15:15:00"},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D15,Timeberegning!$A$4:$O$153,13)))","v":"08:46:00"},null,null,"","","",{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D15,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D15,Timeberegning!$A$4:$P$101,16)))","v":""},null,6,7,"06:07:00",15,15,"15:15:00"]
["2010-04-13","Ti","",127,{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D16,Timeberegning!A$4:B$153,2)))","v":"05:55:00"},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D16,Timeberegning!A$4:C$153,3)))","v":"16:04:00"},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D16,Timeberegning!$A$4:$O$153,13)))","v":"06:29:00"},null,null,"","00:05:00","",{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D16,Timeberegning!$A$4:$O$101,15)))","v":1},"",{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D16,Timeberegning!$A$4:$P$101,16)))","v":""},null,5,55,"05:55:00",16,4,"16:04:00"]
["2010-04-14","On","","x",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D17,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D17,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D17,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D17,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D17,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-15","To","","x",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D18,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D18,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D18,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D18,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D18,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-16","Fr","",142,{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D19,Timeberegning!A$4:B$153,2)))","v":"15:05:00"},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D19,Timeberegning!A$4:C$153,3)))","v":"00:22:00"},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D19,Timeberegning!$A$4:$O$153,13)))","v":"08:31:00"},null,null,"06:00:00","00:22:00","",{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D19,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D19,Timeberegning!$A$4:$P$101,16)))","v":""},null,15,5,"15:05:00",0,22,"00:22:00"]
["2010-04-17","Lø","","143f",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D20,Timeberegning!A$4:B$153,2)))","v":"16:05:00"},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D20,Timeberegning!A$4:C$153,3)))","v":"01:47:00"},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D20,Timeberegning!$A$4:$O$153,13)))","v":"08:56:00"},null,null,"07:55:00","01:47:00","",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D20,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D20,Timeberegning!$A$4:$P$101,16)))","v":""},null,16,5,"16:05:00",1,47,"01:47:00"]
["2010-04-18","Sø","",147,{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D21,Timeberegning!A$4:B$153,2)))","v":"17:25:00"},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D21,Timeberegning!A$4:C$153,3)))","v":"01:26:00"},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D21,Timeberegning!$A$4:$O$153,13)))","v":"07:22:00"},null,null,"06:00:00","01:26:00","07:22:00",{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D21,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D21,Timeberegning!$A$4:$P$101,16)))","v":""},null,17,25,"17:25:00",1,26,"01:26:00"]
["2010-04-19","Ma","",146,{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D22,Timeberegning!A$4:B$153,2)))","v":"17:05:00"},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D22,Timeberegning!A$4:C$153,3)))","v":"01:10:00"},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D22,Timeberegning!$A$4:$O$153,13)))","v":"07:24:00"},null,null,"06:00:00","01:10:00","",{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D22,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D22,Timeberegning!$A$4:$P$101,16)))","v":""},null,17,5,"17:05:00",1,10,"01:10:00"]
["2010-04-20","Ti","",145,{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D23,Timeberegning!A$4:B$153,2)))","v":"16:58:00"},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D23,Timeberegning!A$4:C$153,3)))","v":"00:42:00"},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D23,Timeberegning!$A$4:$O$153,13)))","v":"07:18:00"},null,null,"06:00:00","00:42:00","",{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D23,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D23,Timeberegning!$A$4:$P$101,16)))","v":""},null,16,58,"16:58:00",0,42,"00:42:00"]
["2010-04-21","On","","afsp.",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D24,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D24,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D24,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D24,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D24,Timeberegning!$A$4:$P$101,16)))","v":"07:24:00"},null,"","","","","",""]
["2010-04-22","To","",715,{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D25,Timeberegning!A$4:B$153,2)))","v":"16:48:00"},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D25,Timeberegning!A$4:C$153,3)))","v":"01:47:00"},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D25,Timeberegning!$A$4:$O$153,13)))","v":"08:17:00"},null,null,"06:00:00","01:47:00","",{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D25,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D25,Timeberegning!$A$4:$P$101,16)))","v":""},null,16,48,"16:48:00",1,47,"01:47:00"]
["2010-04-23","Fr","",null,{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D26,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D26,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D26,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D26,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D26,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-24","Lø","",612,{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D27,Timeberegning!A$4:B$153,2)))","v":"14:55:00"},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D27,Timeberegning!A$4:C$153,3)))","v":"00:22:00"},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D27,Timeberegning!$A$4:$O$153,13)))","v":"08:46:00"},null,null,"09:05:00","00:22:00","",{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D27,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D27,Timeberegning!$A$4:$P$101,16)))","v":""},null,14,55,"14:55:00",0,22,"00:22:00"]
["2010-04-25","Sø","",null,{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D28,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D28,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D28,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D28,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D28,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-26","Ma","",null,{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D29,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D29,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D29,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D29,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D29,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-27","Ti","",null,{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D30,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D30,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D30,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D30,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D30,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-28","On","","afsp.",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D31,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D31,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D31,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D31,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D31,Timeberegning!$A$4:$P$101,16)))","v":"07:24:00"},null,"","","","","",""]
["2010-04-29",{"$f":"IF(A32=\"\",\"\",PROPER(TEXT(A32,\"ddd\")))","v":"To"},"","afsp.",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D32,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D32,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D32,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D32,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D32,Timeberegning!$A$4:$P$101,16)))","v":"07:24:00"},null,"","","","","",""]
["2010-04-30",{"$f":"IF(A33=\"\",\"\",PROPER(TEXT(A33,\"ddd\")))","v":"Fr"},"Store Bededag","x",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D33,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D33,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D33,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D33,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D33,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
[null,"","",null,{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D34,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D34,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D34,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D34,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D34,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["Total timer",null,null,null,null,null,{"$f":"IF(SUM(G9:G34)<>\"0\",SUM(G4:G34),\"\")","v":6.324305555555557},{"$f":"IF(SUM(H4:H34)<>\"0\",SUM(H4:H34),\"\")","v":0},0,2.5187499999999998,0.54236111111111107,1.0222222222222221,1,{"$f":"SUM(N4:N34)","v":0},{"$f":"SUM(O4:O34)","v":1.2333333333333334}]
["Timer 1/100",null,null,null,null,null,{"$f":"IF(G35<>\"\",ROUND(G35*24,2),\"\")","v":151.78},{"$f":"IF(H35<>\"\",ROUND(H35*24,2),\"\")","v":0},0,60.45,13.02,24.53,null,0,29.6]
["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":19087.852800000001},{"$f":"IF(H35<>\"\",H36*H37,\"\")","v":0},0,1136.46,283.96619999999996,703.5204,{"$f":"IF(M35<>\"\",M35*M37,\"\")","v":67}]
[]
["Lønart"]
[3025,null,null,null,null,null,{"$f":"G35","v":6.324305555555557}]
[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":6.324305555555557},{"$f":"IF(G44<>\"\",ROUND(G44*24,2),\"\")","v":151.78}]
[null,null,null,null,null,null,null,{"$f":"G37*H44","v":19087.852800000001}]

{"sheet":"september2010","index":1,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[[10,9,10,10],[17,9,17,10],[24,9,24,10],[25,9,25,10],[10,11,10,12],[11,11,11,12],[12,11,12,12],[17,11,17,12],[24,11,24,12],[25,11,25,12],[31,9,31,10],[31,11,31,12],[32,9,32,10],[32,11,32,12],[33,9,33,10],[33,11,33,12],[41,0,41,2],[42,0,42,2],[43,0,43,2],[1,1,1,2],[2,1,2,2],[39,0,39,2],[40,0,40,2],[0,1,0,6],[1,11,1,12],[2,11,2,12],[3,11,3,12],[4,11,4,12],[5,11,5,12],[6,11,6,12],[7,11,7,12],[8,11,8,12],[9,11,9,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[30,11,30,12],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[1,9,1,10],[2,9,2,10],[3,9,3,10],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[9,9,9,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[22,9,22,10],[23,9,23,10],[16,9,16,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[36,9,36,10],[37,9,37,10],[0,10,0,11],[28,9,28,10],[29,9,29,10],[30,9,30,10],[34,9,34,10],[35,9,35,10],[26,9,26,10],[27,9,27,10],[21,9,21,10]]}
["Løn",{"$f":"PROPER(TEXT(A4,\"dd mmmm åååå\")) & PROPER(TEXT(AC1,\"  -  dd mmmm åååå\"))","v":"01 December 2015  -  31 December 2015"},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(A25=\"\",\"\",TRUNC((A25-WEEKDAY(A25,2)-DATE(YEAR(A25+4-WEEKDAY(A25,2)),1,-10))/7))","v":52},null,null,null,null,null,"Time beregning:",null,null,null,null,null,null,null,null,null,{"$f":"IF(A32=\"\",A31,IF(A33=\"\",A32,IF(A34=\"\",A33,A34)))","v":"2015-12-31"}]
["Lønart",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","Arb. Tid","Overtid           1-2 time","Overtid           3-4 time",null,"Aftenstillæg alle dage        17-23",null,"Nattillæg     20-08",null,"Lørdag tillæg 06 - 06","Søndag tillæg 06-06","Optjent afspadsering","Afholdt afspadsering"]
["2015-12-01",{"$f":"PROPER(TEXT(A4,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A4,0,0)","v":""},"14:00:00","02:00:00",{"$f":"IF(D4=\"\",\"\",(E4-D4)+(D4>E4))","v":0.5},null,null,null,{"$f":"IF(D4=\"\",\"\",(IF(E4-MAX(D4,(17/24))+(E4<D4)<0,0,E4-MAX(D4,(17/24))+(E4<D4)))-(IF((E4-MAX(D4,(23/24))+(E4<D4))<0,0,(E4-MAX(D4,(23/24))+(E4<D4)))))","v":"06:00:00"},null,{"$f":"IF(F4=\"\",\"\",IF((E4-MAX(D4,(20/24))+(D4>E4))<0,0,(IF(E4<D4,IF(E4>8/24,8/24,E4),E4)-MAX(D4,(20/24)))+(D4>E4))+(8/24)-MIN(D4,(8/24)))","v":"06:00:00"},null,null,{"$f":"IF(D4=\"\",\"\",IF(D4<6/24,6/24-D4,\"\"))","v":""},{"$f":"IF(F4=\"\",\"\",IF(F4<>0,IF(C4<>\"\",IF(G4+H4=0,Satser!B$23,((G4+H4)*24)*(24/1440)+Satser!B$23),IF(G4+H4=0,\"\",((G4+H4)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D4=\"\",\"\",HOUR(D4))","v":14},{"$f":"IF(D4=\"\",\"\",MINUTE(D4))","v":0},{"$f":"IF(D4=\"\",\"\",TIME(HOUR(D4),MINUTE(D4),0))","v":"14:00:00"},{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":2},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":0},{"$f":"IF(E4=\"\",\"\",TIME(HOUR(E4),MINUTE(E4),0))","v":"02:00:00"}]
[{"$f":"A4+1","v":"2015-12-02"},{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"On"},{"$f":"HelligdagsNavn(A5,0,0)","v":""},"08:00:00","22:00:00",0.58333333333333326,null,null,null,{"$f":"IF(D5=\"\",\"\",(IF(E5-MAX(D5,(17/24))+(E5<D5)<0,0,E5-MAX(D5,(17/24))+(E5<D5)))-(IF((E5-MAX(D5,(23/24))+(E5<D5))<0,0,(E5-MAX(D5,(23/24))+(E5<D5)))))","v":"05:00:00"},null,{"$f":"IF(F5=\"\",\"\",IF((E5-MAX(D5,(20/24))+(D5>E5))<0,0,(IF(E5<D5,IF(E5>8/24,8/24,E5),E5)-MAX(D5,(20/24)))+(D5>E5))+(8/24)-MIN(D5,(8/24)))","v":"02:00:00"},null,null,null,{"$f":"IF(F5=\"\",\"\",IF(F5<>0,IF(C5<>\"\",IF(G5+H5=0,Satser!B$23,((G5+H5)*24)*(24/1440)+Satser!B$23),IF(G5+H5=0,\"\",((G5+H5)*24)*(24/1440))),\"\"))","v":""},null,null,8,0,"08:00:00",22,0,"22:00:00"]
[{"$f":"A5+1","v":"2015-12-03"},{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"To"},"","22:00:00","05:00:00",0.29166666666666674,null,null,null,"01:00:00",null,"07:00:00",null,null,null,{"$f":"IF(F6=\"\",\"\",IF(F6<>0,IF(C6<>\"\",IF(G6+H6=0,Satser!B$23,((G6+H6)*24)*(24/1440)+Satser!B$23),IF(G6+H6=0,\"\",((G6+H6)*24)*(24/1440))),\"\"))","v":""},null,null,22,0,"22:00:00",5,0,{"$f":"IF(E6=\"\",\"\",TIME(HOUR(E6),MINUTE(E6),0))","v":"05:00:00"}]
["2015-12-04","Fr","","17:45:00",1,0.26041666666666663,null,null,null,"05:15:00",null,"04:00:00",null,null,null,{"$f":"IF(F7=\"\",\"\",IF(F7<>0,IF(C7<>\"\",IF(G7+H7=0,Satser!B$23,((G7+H7)*24)*(24/1440)+Satser!B$23),IF(G7+H7=0,\"\",((G7+H7)*24)*(24/1440))),\"\"))","v":""},null,null,17,45,"17:45:00",0,0,"00:00:00"]
["2015-12-05","Lø","",null,null,"",null,null,null,"",null,"",null,{"$f":"IF(E8<D8,IF(E8>6/24,E8-6/24,\"\"),\"\")","v":""},null,{"$f":"IF(F8=\"\",\"\",IF(F8<>0,IF(C8<>\"\",IF(G8+H8=0,Satser!B$23,((G8+H8)*24)*(24/1440)+Satser!B$23),IF(G8+H8=0,\"\",((G8+H8)*24)*(24/1440))),\"\"))","v":""},null,null,"","","","","",""]
["2015-12-06","Sø","","17:45:00",1,0.26041666666666663,null,null,null,"05:15:00",null,"04:00:00",null,{"$f":"IF(D9=\"\",\"\",IF((E9-MAX(D9,(6/24))+(D9>E9))<0,0,(IF(E9<D9,IF(E9>6/24,6/24,E9),E9)-MAX(D9,(6/24)))+(D9>E9))+(6/24)-MIN(E9,(6/24)))","v":0.26041666666666663},{"$f":"IF(E9<D9,IF(E9>6/24,E9-6/24,\"\"),\"\")","v":""},{"$f":"IF(F9=\"\",\"\",IF(F9<>0,IF(C9<>\"\",IF(G9+H9=0,Satser!B$23,((G9+H9)*24)*(24/1440)+Satser!B$23),IF(G9+H9=0,\"\",((G9+H9)*24)*(24/1440))),\"\"))","v":""},null,null,17,45,"17:45:00",0,0,"00:00:00"]
["2015-12-07","Ma","",null,null,"",null,null,null,"",null,{"$f":"IF(F10=\"\",\"\",IF((E10-MAX(D10,(18/24))+(D10>E10))<0,0,(IF(E10<D10,IF(E10>2/24,2/24,E10),E10)-MAX(D10,(18/24)))+(D10>E10))+(2/24)-MIN(D10,(2/24)))","v":""},null,{"$f":"IF(D10=\"\",\"\",IF(D10<6/24,IF(E10<6/24,6/24-D10-(6/24-E10),6/24-D10),\"00:00\"))","v":""},{"$f":"IF(D10=\"\",\"\",IF((E10-MAX(D10,(6/24))+(D10>E10))<0,0,(IF(E10<D10,IF(E10>6/24,6/24,E10),E10)-MAX(D10,(6/24)))+(D10>E10))+(6/24)-MIN(E10,(6/24)))","v":""},{"$f":"IF(F10=\"\",\"\",IF(F10<>0,IF(C10<>\"\",IF(G10+H10=0,Satser!B$23,((G10+H10)*24)*(24/1440)+Satser!B$23),IF(G10+H10=0,\"\",((G10+H10)*24)*(24/1440))),\"\"))","v":""},null,null,"","","","","",""]
[{"$f":"A10+1","v":"2015-12-08"},{"$f":"PROPER(TEXT(A11,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A11,0,0)","v":""},null,null,{"$f":"IF(D11=\"\",\"\",(E11-D11)+(D11>E11))","v":""},null,null,null,{"$f":"IF(D11=\"\",\"\",(IF(E11-MAX(D11,(17/24))+(E11<D11)<0,0,E11-MAX(D11,(17/24))+(E11<D11)))-(IF((E11-MAX(D11,(23/24))+(E11<D11))<0,0,(E11-MAX(D11,(23/24))+(E11<D11)))))","v":""},null,{"$f":"IF(F11=\"\",\"\",IF((E11-MAX(D11,(18/24))+(D11>E11))<0,0,(IF(E11<D11,IF(E11>2/24,2/24,E11),E11)-MAX(D11,(18/24)))+(D11>E11))+(2/24)-MIN(D11,(2/24)))","v":""},null,null,{"$f":"IF(D11=\"\",\"\",IF(D11<6/24,6/24-D11,\"\"))","v":""},{"$f":"IF(F11=\"\",\"\",IF(F11<>0,IF(C11<>\"\",IF(G11+H11=0,Satser!B$23,((G11+H11)*24)*(24/1440)+Satser!B$23),IF(G11+H11=0,\"\",((G11+H11)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D11=\"\",\"\",HOUR(D11))","v":""},{"$f":"IF(D11=\"\",\"\",MINUTE(D11))","v":""},{"$f":"IF(D11=\"\",\"\",TIME(HOUR(D11),MINUTE(D11),0))","v":""},{"$f":"IF(E11=\"\",\"\",HOUR(E11))","v":""},{"$f":"IF(E11=\"\",\"\",MINUTE(E11))","v":""},{"$f":"IF(E11=\"\",\"\",TIME(HOUR(E11),MINUTE(E11),0))","v":""}]
[{"$f":"A11+1","v":"2015-12-09"},{"$f":"PROPER(TEXT(A12,\"ddd\"))","v":"On"},{"$f":"HelligdagsNavn(A12,0,0)","v":""},null,null,{"$f":"IF(D12=\"\",\"\",(E12-D12)+(D12>E12))","v":""},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(F12=\"\",\"\",IF(F12<>0,IF(C12<>\"\",IF(G12+H12=0,Satser!B$23,((G12+H12)*24)*(24/1440)+Satser!B$23),IF(G12+H12=0,\"\",((G12+H12)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D12=\"\",\"\",HOUR(D12))","v":""},{"$f":"IF(D12=\"\",\"\",MINUTE(D12))","v":""},{"$f":"IF(D12=\"\",\"\",TIME(HOUR(D12),MINUTE(D12),0))","v":""},{"$f":"IF(E12=\"\",\"\",HOUR(E12))","v":""},{"$f":"IF(E12=\"\",\"\",MINUTE(E12))","v":""},{"$f":"IF(E12=\"\",\"\",TIME(HOUR(E12),MINUTE(E12),0))","v":""}]
[{"$f":"A12+1","v":"2015-12-10"},{"$f":"PROPER(TEXT(A13,\"ddd\"))","v":"To"},"",null,null,{"$f":"IF(D13=\"\",\"\",(E13-D13)+(D13>E13))","v":""},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,{"$f":"IF(F13=\"\",\"\",IF(F13<>0,IF(C13<>\"\",IF(G13+H13=0,Satser!B$23,((G13+H13)*24)*(24/1440)+Satser!B$23),IF(G13+H13=0,\"\",((G13+H13)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D13=\"\",\"\",HOUR(D13))","v":""},{"$f":"IF(D13=\"\",\"\",MINUTE(D13))","v":""},{"$f":"IF(D13=\"\",\"\",TIME(HOUR(D13),MINUTE(D13),0))","v":""},{"$f":"IF(E13=\"\",\"\",HOUR(E13))","v":""},{"$f":"IF(E13=\"\",\"\",MINUTE(E13))","v":""},{"$f":"IF(E13=\"\",\"\",TIME(HOUR(E13),MINUTE(E13),0))","v":""}]
["2015-12-11","Fr","",null,null,{"$f":"IF(D14=\"\",\"\",(E14-D14)+(D14>E14))","v":""},null,null,null,"",null,"",null,null,null,{"$f":"IF(F14=\"\",\"\",IF(F14<>0,IF(C14<>\"\",IF(G14+H14=0,Satser!B$23,((G14+H14)*24)*(24/1440)+Satser!B$23),IF(G14+H14=0,\"\",((G14+H14)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D14=\"\",\"\",HOUR(D14))","v":""},{"$f":"IF(D14=\"\",\"\",MINUTE(D14))","v":""},{"$f":"IF(D14=\"\",\"\",TIME(HOUR(D14),MINUTE(D14),0))","v":""},{"$f":"IF(E14=\"\",\"\",HOUR(E14))","v":""},{"$f":"IF(E14=\"\",\"\",MINUTE(E14))","v":""},{"$f":"IF(E14=\"\",\"\",TIME(HOUR(E14),MINUTE(E14),0))","v":""}]
["2015-12-12","Lø","",null,null,{"$f":"IF(D15=\"\",\"\",(E15-D15)+(D15>E15))","v":""},null,null,null,"",null,"",null,{"$f":"IF(D15=\"\",\"\",IF(E15<D15,IF(E15>6/24,E15-6/24,\"\"),\"\"))","v":""},null,{"$f":"IF(F15=\"\",\"\",IF(F15<>0,IF(C15<>\"\",IF(G15+H15=0,Satser!B$23,((G15+H15)*24)*(24/1440)+Satser!B$23),IF(G15+H15=0,\"\",((G15+H15)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D15=\"\",\"\",HOUR(D15))","v":""},{"$f":"IF(D15=\"\",\"\",MINUTE(D15))","v":""},{"$f":"IF(D15=\"\",\"\",TIME(HOUR(D15),MINUTE(D15),0))","v":""},{"$f":"IF(E15=\"\",\"\",HOUR(E15))","v":""},{"$f":"IF(E15=\"\",\"\",MINUTE(E15))","v":""},{"$f":"IF(E15=\"\",\"\",TIME(HOUR(E15),MINUTE(E15),0))","v":""}]
["2015-12-13","Sø","",null,null,{"$f":"IF(D16=\"\",\"\",(E16-D16)+(D16>E16))","v":""},null,null,null,"",null,"",null,{"$f":"IF(D16=\"\",\"\",IF((E16-MAX(D16,(6/24))+(D16>E16))<0,0,(IF(E16<D16,IF(E16>6/24,6/24,E16),E16)-MAX(D16,(6/24)))+(D16>E16))+(6/24)-MIN(E16,(6/24)))","v":""},{"$f":"IF(E16<D16,IF(E16>6/24,E16-6/24,\"\"),\"\")","v":""},{"$f":"IF(F16=\"\",\"\",IF(F16<>0,IF(C16<>\"\",IF(G16+H16=0,Satser!B$23,((G16+H16)*24)*(24/1440)+Satser!B$23),IF(G16+H16=0,\"\",((G16+H16)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D16=\"\",\"\",HOUR(D16))","v":""},{"$f":"IF(D16=\"\",\"\",MINUTE(D16))","v":""},{"$f":"IF(D16=\"\",\"\",TIME(HOUR(D16),MINUTE(D16),0))","v":""},{"$f":"IF(E16=\"\",\"\",HOUR(E16))","v":""},{"$f":"IF(E16=\"\",\"\",MINUTE(E16))","v":""},{"$f":"IF(E16=\"\",\"\",TIME(HOUR(E16),MINUTE(E16),0))","v":""}]
["2015-12-14","Ma","",null,null,{"$f":"IF(D17=\"\",\"\",(E17-D17)+(D17>E17))","v":""},null,null,null,{"$f":"IF(D17=\"\",\"\",(IF(E17-MAX(D17,(17/24))+(E17<D17)<0,0,E17-MAX(D17,(17/24))+(E17<D17)))-(IF((E17-MAX(D17,(23/24))+(E17<D17))<0,0,(E17-MAX(D17,(23/24))+(E17<D17)))))","v":""},null,{"$f":"IF(F17=\"\",\"\",IF((E17-MAX(D17,(18/24))+(D17>E17))<0,0,(IF(E17<D17,IF(E17>2/24,2/24,E17),E17)-MAX(D17,(18/24)))+(D17>E17))+(2/24)-MIN(D17,(2/24)))","v":""},null,{"$f":"IF(D17=\"\",\"\",IF(D17<6/24,IF(E17<6/24,6/24-D17-(6/24-E17),6/24-D17),\"00:00\"))","v":""},{"$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":""},{"$f":"IF(F17=\"\",\"\",IF(F17<>0,IF(C17<>\"\",IF(G17+H17=0,Satser!B$23,((G17+H17)*24)*(24/1440)+Satser!B$23),IF(G17+H17=0,\"\",((G17+H17)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D17=\"\",\"\",HOUR(D17))","v":""},{"$f":"IF(D17=\"\",\"\",MINUTE(D17))","v":""},{"$f":"IF(D17=\"\",\"\",TIME(HOUR(D17),MINUTE(D17),0))","v":""},{"$f":"IF(E17=\"\",\"\",HOUR(E17))","v":""},{"$f":"IF(E17=\"\",\"\",MINUTE(E17))","v":""},{"$f":"IF(E17=\"\",\"\",TIME(HOUR(E17),MINUTE(E17),0))","v":""}]
[{"$f":"A17+1","v":"2015-12-15"},{"$f":"PROPER(TEXT(A18,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A18,0,0)","v":""},null,null,{"$f":"IF(D18=\"\",\"\",(E18-D18)+(D18>E18))","v":""},null,null,null,{"$f":"IF(D18=\"\",\"\",(IF(E18-MAX(D18,(17/24))+(E18<D18)<0,0,E18-MAX(D18,(17/24))+(E18<D18)))-(IF((E18-MAX(D18,(23/24))+(E18<D18))<0,0,(E18-MAX(D18,(23/24))+(E18<D18)))))","v":""},null,{"$f":"IF(F18=\"\",\"\",IF((E18-MAX(D18,(18/24))+(D18>E18))<0,0,(IF(E18<D18,IF(E18>2/24,2/24,E18),E18)-MAX(D18,(18/24)))+(D18>E18))+(2/24)-MIN(D18,(2/24)))","v":""},null,null,{"$f":"IF(D18=\"\",\"\",IF(D18<6/24,6/24-D18,\"\"))","v":""},{"$f":"IF(F18=\"\",\"\",IF(F18<>0,IF(C18<>\"\",IF(G18+H18=0,Satser!B$23,((G18+H18)*24)*(24/1440)+Satser!B$23),IF(G18+H18=0,\"\",((G18+H18)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D18=\"\",\"\",HOUR(D18))","v":""},{"$f":"IF(D18=\"\",\"\",MINUTE(D18))","v":""},{"$f":"IF(D18=\"\",\"\",TIME(HOUR(D18),MINUTE(D18),0))","v":""},{"$f":"IF(E18=\"\",\"\",HOUR(E18))","v":""},{"$f":"IF(E18=\"\",\"\",MINUTE(E18))","v":""},{"$f":"IF(E18=\"\",\"\",TIME(HOUR(E18),MINUTE(E18),0))","v":""}]
[{"$f":"A18+1","v":"2015-12-16"},{"$f":"PROPER(TEXT(A19,\"ddd\"))","v":"On"},{"$f":"HelligdagsNavn(A19,0,0)","v":""},null,null,{"$f":"IF(D19=\"\",\"\",(E19-D19)+(D19>E19))","v":""},null,null,null,"",null,"",null,null,null,{"$f":"IF(F19=\"\",\"\",IF(F19<>0,IF(C19<>\"\",IF(G19+H19=0,Satser!B$23,((G19+H19)*24)*(24/1440)+Satser!B$23),IF(G19+H19=0,\"\",((G19+H19)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D19=\"\",\"\",HOUR(D19))","v":""},{"$f":"IF(D19=\"\",\"\",MINUTE(D19))","v":""},{"$f":"IF(D19=\"\",\"\",TIME(HOUR(D19),MINUTE(D19),0))","v":""},{"$f":"IF(E19=\"\",\"\",HOUR(E19))","v":""},{"$f":"IF(E19=\"\",\"\",MINUTE(E19))","v":""},{"$f":"IF(E19=\"\",\"\",TIME(HOUR(E19),MINUTE(E19),0))","v":""}]
[{"$f":"A19+1","v":"2015-12-17"},{"$f":"PROPER(TEXT(A20,\"ddd\"))","v":"To"},"",null,null,{"$f":"IF(D20=\"\",\"\",(E20-D20)+(D20>E20))","v":""},null,null,null,"",null,"",null,null,null,{"$f":"IF(F20=\"\",\"\",IF(F20<>0,IF(C20<>\"\",IF(G20+H20=0,Satser!B$23,((G20+H20)*24)*(24/1440)+Satser!B$23),IF(G20+H20=0,\"\",((G20+H20)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D20=\"\",\"\",HOUR(D20))","v":""},{"$f":"IF(D20=\"\",\"\",MINUTE(D20))","v":""},{"$f":"IF(D20=\"\",\"\",TIME(HOUR(D20),MINUTE(D20),0))","v":""},{"$f":"IF(E20=\"\",\"\",HOUR(E20))","v":""},{"$f":"IF(E20=\"\",\"\",MINUTE(E20))","v":""},{"$f":"IF(E20=\"\",\"\",TIME(HOUR(E20),MINUTE(E20),0))","v":""}]
["2015-12-18","Fr","",null,null,{"$f":"IF(D21=\"\",\"\",(E21-D21)+(D21>E21))","v":""},null,null,null,"",null,"",null,null,null,{"$f":"IF(F21=\"\",\"\",IF(F21<>0,IF(C21<>\"\",IF(G21+H21=0,Satser!B$23,((G21+H21)*24)*(24/1440)+Satser!B$23),IF(G21+H21=0,\"\",((G21+H21)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D21=\"\",\"\",HOUR(D21))","v":""},{"$f":"IF(D21=\"\",\"\",MINUTE(D21))","v":""},{"$f":"IF(D21=\"\",\"\",TIME(HOUR(D21),MINUTE(D21),0))","v":""},{"$f":"IF(E21=\"\",\"\",HOUR(E21))","v":""},{"$f":"IF(E21=\"\",\"\",MINUTE(E21))","v":""},{"$f":"IF(E21=\"\",\"\",TIME(HOUR(E21),MINUTE(E21),0))","v":""}]
["2015-12-19","Lø","",null,null,{"$f":"IF(D22=\"\",\"\",(E22-D22)+(D22>E22))","v":""},null,null,null,"",null,"",null,{"$f":"IF(E22<D22,IF(E22>6/24,E22-6/24,\"\"),\"\")","v":""},null,{"$f":"IF(F22=\"\",\"\",IF(F22<>0,IF(C22<>\"\",IF(G22+H22=0,Satser!B$23,((G22+H22)*24)*(24/1440)+Satser!B$23),IF(G22+H22=0,\"\",((G22+H22)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D22=\"\",\"\",HOUR(D22))","v":""},{"$f":"IF(D22=\"\",\"\",MINUTE(D22))","v":""},{"$f":"IF(D22=\"\",\"\",TIME(HOUR(D22),MINUTE(D22),0))","v":""},{"$f":"IF(E22=\"\",\"\",HOUR(E22))","v":""},{"$f":"IF(E22=\"\",\"\",MINUTE(E22))","v":""},{"$f":"IF(E22=\"\",\"\",TIME(HOUR(E22),MINUTE(E22),0))","v":""}]
["2015-12-20","Sø","",null,null,{"$f":"IF(D23=\"\",\"\",(E23-D23)+(D23>E23))","v":""},null,null,null,{"$f":"IF(D23=\"\",\"\",(IF(E23-MAX(D23,(17/24))+(E23<D23)<0,0,E23-MAX(D23,(17/24))+(E23<D23)))-(IF((E23-MAX(D23,(23/24))+(E23<D23))<0,0,(E23-MAX(D23,(23/24))+(E23<D23)))))","v":""},null,{"$f":"IF(F23=\"\",\"\",IF((E23-MAX(D23,(18/24))+(D23>E23))<0,0,(IF(E23<D23,IF(E23>2/24,2/24,E23),E23)-MAX(D23,(18/24)))+(D23>E23))+(2/24)-MIN(D23,(2/24)))","v":""},null,{"$f":"IF(D23=\"\",\"\",IF((E23-MAX(D23,(6/24))+(D23>E23))<0,0,(IF(E23<D23,IF(E23>6/24,6/24,E23),E23)-MAX(D23,(6/24)))+(D23>E23))+(6/24)-MIN(E23,(6/24)))","v":""},{"$f":"IF(E23<D23,IF(E23>6/24,E23-6/24,\"\"),\"\")","v":""},{"$f":"IF(F23=\"\",\"\",IF(F23<>0,IF(C23<>\"\",IF(G23+H23=0,Satser!B$23,((G23+H23)*24)*(24/1440)+Satser!B$23),IF(G23+H23=0,\"\",((G23+H23)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D23=\"\",\"\",HOUR(D23))","v":""},{"$f":"IF(D23=\"\",\"\",MINUTE(D23))","v":""},{"$f":"IF(D23=\"\",\"\",TIME(HOUR(D23),MINUTE(D23),0))","v":""},{"$f":"IF(E23=\"\",\"\",HOUR(E23))","v":""},{"$f":"IF(E23=\"\",\"\",MINUTE(E23))","v":""},{"$f":"IF(E23=\"\",\"\",TIME(HOUR(E23),MINUTE(E23),0))","v":""}]
["2015-12-21","Ma","",null,null,{"$f":"IF(D24=\"\",\"\",(E24-D24)+(D24>E24))","v":""},null,null,null,"",null,{"$f":"IF(F24=\"\",\"\",IF((E24-MAX(D24,(18/24))+(D24>E24))<0,0,(IF(E24<D24,IF(E24>2/24,2/24,E24),E24)-MAX(D24,(18/24)))+(D24>E24))+(2/24)-MIN(D24,(2/24)))","v":""},null,{"$f":"IF(D24=\"\",\"\",IF(D24<6/24,IF(E24<6/24,6/24-D24-(6/24-E24),6/24-D24),\"00:00\"))","v":""},{"$f":"IF(D24=\"\",\"\",IF((E24-MAX(D24,(6/24))+(D24>E24))<0,0,(IF(E24<D24,IF(E24>6/24,6/24,E24),E24)-MAX(D24,(6/24)))+(D24>E24))+(6/24)-MIN(E24,(6/24)))","v":""},{"$f":"IF(F24=\"\",\"\",IF(F24<>0,IF(C24<>\"\",IF(G24+H24=0,Satser!B$23,((G24+H24)*24)*(24/1440)+Satser!B$23),IF(G24+H24=0,\"\",((G24+H24)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D24=\"\",\"\",HOUR(D24))","v":""},{"$f":"IF(D24=\"\",\"\",MINUTE(D24))","v":""},{"$f":"IF(D24=\"\",\"\",TIME(HOUR(D24),MINUTE(D24),0))","v":""},{"$f":"IF(E24=\"\",\"\",HOUR(E24))","v":""},{"$f":"IF(E24=\"\",\"\",MINUTE(E24))","v":""},{"$f":"IF(E24=\"\",\"\",TIME(HOUR(E24),MINUTE(E24),0))","v":""}]
[{"$f":"A24+1","v":"2015-12-22"},{"$f":"PROPER(TEXT(A25,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A25,0,0)","v":""},null,null,{"$f":"IF(D25=\"\",\"\",(E25-D25)+(D25>E25))","v":""},null,null,null,{"$f":"IF(D25=\"\",\"\",(IF(E25-MAX(D25,(17/24))+(E25<D25)<0,0,E25-MAX(D25,(17/24))+(E25<D25)))-(IF((E25-MAX(D25,(23/24))+(E25<D25))<0,0,(E25-MAX(D25,(23/24))+(E25<D25)))))","v":""},null,{"$f":"IF(F25=\"\",\"\",IF((E25-MAX(D25,(18/24))+(D25>E25))<0,0,(IF(E25<D25,IF(E25>2/24,2/24,E25),E25)-MAX(D25,(18/24)))+(D25>E25))+(2/24)-MIN(D25,(2/24)))","v":""},null,null,{"$f":"IF(D25=\"\",\"\",IF(D25<6/24,6/24-D25,\"\"))","v":""},{"$f":"IF(F25=\"\",\"\",IF(F25<>0,IF(C25<>\"\",IF(G25+H25=0,Satser!B$23,((G25+H25)*24)*(24/1440)+Satser!B$23),IF(G25+H25=0,\"\",((G25+H25)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D25=\"\",\"\",HOUR(D25))","v":""},{"$f":"IF(D25=\"\",\"\",MINUTE(D25))","v":""},{"$f":"IF(D25=\"\",\"\",TIME(HOUR(D25),MINUTE(D25),0))","v":""},{"$f":"IF(E25=\"\",\"\",HOUR(E25))","v":""},{"$f":"IF(E25=\"\",\"\",MINUTE(E25))","v":""},{"$f":"IF(E25=\"\",\"\",TIME(HOUR(E25),MINUTE(E25),0))","v":""}]
[{"$f":"A25+1","v":"2015-12-23"},{"$f":"PROPER(TEXT(A26,\"ddd\"))","v":"On"},{"$f":"HelligdagsNavn(A26,0,0)","v":""},null,null,{"$f":"IF(D26=\"\",\"\",(E26-D26)+(D26>E26))","v":""},null,null,null,"",null,"",null,null,null,{"$f":"IF(F26=\"\",\"\",IF(F26<>0,IF(C26<>\"\",IF(G26+H26=0,Satser!B$23,((G26+H26)*24)*(24/1440)+Satser!B$23),IF(G26+H26=0,\"\",((G26+H26)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D26=\"\",\"\",HOUR(D26))","v":""},{"$f":"IF(D26=\"\",\"\",MINUTE(D26))","v":""},{"$f":"IF(D26=\"\",\"\",TIME(HOUR(D26),MINUTE(D26),0))","v":""},{"$f":"IF(E26=\"\",\"\",HOUR(E26))","v":""},{"$f":"IF(E26=\"\",\"\",MINUTE(E26))","v":""},{"$f":"IF(E26=\"\",\"\",TIME(HOUR(E26),MINUTE(E26),0))","v":""}]
[{"$f":"A26+1","v":"2015-12-24"},{"$f":"PROPER(TEXT(A27,\"ddd\"))","v":"To"},"Julaftensdag",null,null,{"$f":"IF(D27=\"\",\"\",(E27-D27)+(D27>E27))","v":""},null,null,null,"",null,"",null,null,null,{"$f":"IF(F27=\"\",\"\",IF(F27<>0,IF(C27<>\"\",IF(G27+H27=0,Satser!B$23,((G27+H27)*24)*(24/1440)+Satser!B$23),IF(G27+H27=0,\"\",((G27+H27)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D27=\"\",\"\",HOUR(D27))","v":""},{"$f":"IF(D27=\"\",\"\",MINUTE(D27))","v":""},{"$f":"IF(D27=\"\",\"\",TIME(HOUR(D27),MINUTE(D27),0))","v":""},{"$f":"IF(E27=\"\",\"\",HOUR(E27))","v":""},{"$f":"IF(E27=\"\",\"\",MINUTE(E27))","v":""},{"$f":"IF(E27=\"\",\"\",TIME(HOUR(E27),MINUTE(E27),0))","v":""}]
["2015-12-25","Fr","1. Juledag",null,null,{"$f":"IF(D28=\"\",\"\",(E28-D28)+(D28>E28))","v":""},null,null,null,"",null,"",null,null,null,{"$f":"IF(F28=\"\",\"\",IF(F28<>0,IF(C28<>\"\",IF(G28+H28=0,Satser!B$23,((G28+H28)*24)*(24/1440)+Satser!B$23),IF(G28+H28=0,\"\",((G28+H28)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D28=\"\",\"\",HOUR(D28))","v":""},{"$f":"IF(D28=\"\",\"\",MINUTE(D28))","v":""},{"$f":"IF(D28=\"\",\"\",TIME(HOUR(D28),MINUTE(D28),0))","v":""},{"$f":"IF(E28=\"\",\"\",HOUR(E28))","v":""},{"$f":"IF(E28=\"\",\"\",MINUTE(E28))","v":""},{"$f":"IF(E28=\"\",\"\",TIME(HOUR(E28),MINUTE(E28),0))","v":""}]
["2015-12-26","Lø",null,null,null,{"$f":"IF(D29=\"\",\"\",(E29-D29)+(D29>E29))","v":""},null,null,null,{"$f":"IF(D29=\"\",\"\",(IF(E29-MAX(D29,(17/24))+(E29<D29)<0,0,E29-MAX(D29,(17/24))+(E29<D29)))-(IF((E29-MAX(D29,(23/24))+(E29<D29))<0,0,(E29-MAX(D29,(23/24))+(E29<D29)))))","v":""},null,{"$f":"IF(F29=\"\",\"\",IF((E29-MAX(D29,(18/24))+(D29>E29))<0,0,(IF(E29<D29,IF(E29>2/24,2/24,E29),E29)-MAX(D29,(18/24)))+(D29>E29))+(2/24)-MIN(D29,(2/24)))","v":""},null,{"$f":"IF(E29<D29,IF(E29>6/24,E29-6/24,\"\"),\"\")","v":""},null,{"$f":"IF(F29=\"\",\"\",IF(F29<>0,IF(C29<>\"\",IF(G29+H29=0,Satser!B$23,((G29+H29)*24)*(24/1440)+Satser!B$23),IF(G29+H29=0,\"\",((G29+H29)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D29=\"\",\"\",HOUR(D29))","v":""},{"$f":"IF(D29=\"\",\"\",MINUTE(D29))","v":""},{"$f":"IF(D29=\"\",\"\",TIME(HOUR(D29),MINUTE(D29),0))","v":""},{"$f":"IF(E29=\"\",\"\",HOUR(E29))","v":""},{"$f":"IF(E29=\"\",\"\",MINUTE(E29))","v":""},{"$f":"IF(E29=\"\",\"\",TIME(HOUR(E29),MINUTE(E29),0))","v":""}]
["2015-12-27","Sø","",null,null,{"$f":"IF(D30=\"\",\"\",(E30-D30)+(D30>E30))","v":""},null,null,null,"",null,{"$f":"IF(F30=\"\",\"\",IF((E30-MAX(D30,(18/24))+(D30>E30))<0,0,(IF(E30<D30,IF(E30>2/24,2/24,E30),E30)-MAX(D30,(18/24)))+(D30>E30))+(2/24)-MIN(D30,(2/24)))","v":""},null,{"$f":"IF(D30=\"\",\"\",IF((E30-MAX(D30,(6/24))+(D30>E30))<0,0,(IF(E30<D30,IF(E30>6/24,6/24,E30),E30)-MAX(D30,(6/24)))+(D30>E30))+(6/24)-MIN(E30,(6/24)))","v":""},{"$f":"IF(E30<D30,IF(E30>6/24,E30-6/24,\"\"),\"\")","v":""},{"$f":"IF(F30=\"\",\"\",IF(F30<>0,IF(C30<>\"\",IF(G30+H30=0,Satser!B$23,((G30+H30)*24)*(24/1440)+Satser!B$23),IF(G30+H30=0,\"\",((G30+H30)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D30=\"\",\"\",HOUR(D30))","v":""},{"$f":"IF(D30=\"\",\"\",MINUTE(D30))","v":""},{"$f":"IF(D30=\"\",\"\",TIME(HOUR(D30),MINUTE(D30),0))","v":""},{"$f":"IF(E30=\"\",\"\",HOUR(E30))","v":""},{"$f":"IF(E30=\"\",\"\",MINUTE(E30))","v":""},{"$f":"IF(E30=\"\",\"\",TIME(HOUR(E30),MINUTE(E30),0))","v":""}]
["2015-12-28","Ma","",null,null,{"$f":"IF(D31=\"\",\"\",(E31-D31)+(D31>E31))","v":""},null,null,null,{"$f":"IF(D31=\"\",\"\",(IF(E31-MAX(D31,(17/24))+(E31<D31)<0,0,E31-MAX(D31,(17/24))+(E31<D31)))-(IF((E31-MAX(D31,(23/24))+(E31<D31))<0,0,(E31-MAX(D31,(23/24))+(E31<D31)))))","v":""},null,{"$f":"IF(F31=\"\",\"\",IF((E31-MAX(D31,(18/24))+(D31>E31))<0,0,(IF(E31<D31,IF(E31>2/24,2/24,E31),E31)-MAX(D31,(18/24)))+(D31>E31))+(2/24)-MIN(D31,(2/24)))","v":""},null,{"$f":"IF(D31=\"\",\"\",IF(D31<6/24,IF(E31<6/24,6/24-D31-(6/24-E31),6/24-D31),\"00:00\"))","v":""},{"$f":"IF(D31=\"\",\"\",IF((E31-MAX(D31,(6/24))+(D31>E31))<0,0,(IF(E31<D31,IF(E31>6/24,6/24,E31),E31)-MAX(D31,(6/24)))+(D31>E31))+(6/24)-MIN(E31,(6/24)))","v":""},{"$f":"IF(F31=\"\",\"\",IF(F31<>0,IF(C31<>\"\",IF(G31+H31=0,Satser!B$23,((G31+H31)*24)*(24/1440)+Satser!B$23),IF(G31+H31=0,\"\",((G31+H31)*24)*(24/1440))),\"\"))","v":""},null,null,{"$f":"IF(D31=\"\",\"\",HOUR(D31))","v":""},{"$f":"IF(D31=\"\",\"\",MINUTE(D31))","v":""},{"$f":"IF(D31=\"\",\"\",TIME(HOUR(D31),MINUTE(D31),0))","v":""},{"$f":"IF(E31=\"\",\"\",HOUR(E31))","v":""},{"$f":"IF(E31=\"\",\"\",MINUTE(E31))","v":""},{"$f":"IF(E31=\"\",\"\",TIME(HOUR(E31),MINUTE(E31),0))","v":""}]
[{"$f":"IF(MONTH(A31+1)>MONTH($A$4),\"\",A31+1)","v":"2015-12-29"},{"$f":"PROPER(TEXT(A32,\"ddd\"))","v":"Ti"},{"$f":"IFERROR(HelligdagsNavn(A32,0,0),\"\")","v":""},null,null,{"$f":"IF(D32=\"\",\"\",(E32-D32)+(D32>E32))","v":""},null,null,null,{"$f":"IF(D32=\"\",\"\",(IF(E32-MAX(D32,(17/24))+(E32<D32)<0,0,E32-MAX(D32,(17/24))+(E32<D32)))-(IF((E32-MAX(D32,(23/24))+(E32<D32))<0,0,(E32-MAX(D32,(23/24))+(E32<D32)))))","v":""},null,{"$f":"IF(F32=\"\",\"\",IF((E32-MAX(D32,(18/24))+(D32>E32))<0,0,(IF(E32<D32,IF(E32>2/24,2/24,E32),E32)-MAX(D32,(18/24)))+(D32>E32))+(2/24)-MIN(D32,(2/24)))","v":""},null,{"$f":"IF(D32=\"\",\"\",IF(D32<6/24,IF(E32<6/24,6/24-D32-(6/24-E32),6/24-D32),\"00:00\"))","v":""},{"$f":"IF(D32=\"\",\"\",IF((E32-MAX(D32,(6/24))+(D32>E32))<0,0,(IF(E32<D32,IF(E32>6/24,6/24,E32),E32)-MAX(D32,(6/24)))+(D32>E32))+(6/24)-MIN(E32,(6/24)))","v":""},{"$f":"IF(F32=\"\",\"\",IF(F32<>0,IF(C32<>\"\",IF(G32+H32=0,Satser!B$23,((G32+H32)*24)*(24/1440)+Satser!B$23),IF(G32+H32=0,\"\",((G32+H32)*24)*(24/1440))),\"\"))","v":""}]
[{"$f":"IFERROR(IF(MONTH(A32+1)>MONTH($A$4),\"\",A32+1),\"\")","v":"2015-12-30"},"On",{"$f":"IFERROR(HelligdagsNavn(A33,0,0),\"\")","v":""},null,null,"",null,null,null,"",null,"",null,"","",{"$f":"IF(F33=\"\",\"\",IF(F33<>0,IF(C33<>\"\",IF(G33+H33=0,Satser!B$23,((G33+H33)*24)*(24/1440)+Satser!B$23),IF(G33+H33=0,\"\",((G33+H33)*24)*(24/1440))),\"\"))","v":""}]
[{"$f":"IFERROR(IF(MONTH(A33+1)>MONTH($A$4),\"\",A33+1),\"\")","v":"2015-12-31"},"To","Nytårsaftensdag",null,null,"",null,null,null,"",null,"",null,"","",{"$f":"IF(F34=\"\",\"\",IF(F34<>0,IF(C34<>\"\",IF(G34+H34=0,Satser!B$23,((G34+H34)*24)*(24/1440)+Satser!B$23),IF(G34+H34=0,\"\",((G34+H34)*24)*(24/1440))),\"\"))","v":""}]
["Total timer",null,null,null,null,{"$f":"IF(SUM(F9:F31)<>\"0\",SUM(F4:F31),\"\")","v":1.895833333333333},{"$f":"IF(SUM(G4:G31)<>\"0\",SUM(G4:G31),\"\")","v":0},{"$f":"IF(SUM(H4:H31)<>\"0\",SUM(H4:H31),\"\")","v":0},{"$f":"IF(SUM(I4:I31)<>\"0\",SUM(I4:I31),\"\")","v":0},{"$f":"IF(SUM(J4:J31)<>\"0\",SUM(J4:J31),\"\")","v":0.9375},null,{"$f":"IF(SUM(L4:L31)<>\"0\",SUM(L4:L31),\"\")","v":0.95833333333333315},null,{"$f":"IF(SUM(N4:N31)<>\"0\",SUM(N4:N31),\"\")","v":0.26041666666666663},{"$f":"IF(SUM(O4:O31)<>\"0\",SUM(O4:O31),\"\")","v":"00:00:00"},{"$f":"SUM(P4:P31)","v":0},{"$f":"SUM(Q4:Q31)","v":0}]
["Timer 1/100",null,null,null,null,{"$f":"IF(F35<>\"\",ROUND(F35*24,2),\"\")","v":45.5},{"$f":"IF(G35<>\"\",ROUND(G35*24,2),\"\")","v":0},{"$f":"IF(H35<>\"\",ROUND(H35*24,2),\"\")","v":0},0,{"$f":"IF(J35<>\"\",ROUND(J35*24,2),\"\")","v":22.5},null,{"$f":"IF(L35<>\"\",ROUND(L35*24,2),\"\")","v":23},null,6.25,0,0,0]
["Satser",null,null,null,null,{"$f":"Satser!B7","v":125.76},{"$f":"Satser!B9","v":59.81},{"$f":"Satser!B12","v":119.62},{"$f":"Satser!C12","v":0},18.8,null,21.81,null,28.68,67]
[null,null,null,null,null,{"$f":"IF(F35<>\"\",F36*F37,\"\")","v":5722.08},{"$f":"IF(G35<>\"\",G36*G37,\"\")","v":0},{"$f":"IF(G35<>\"\",G36*G37,\"\")","v":0},{"$f":"IF(H35<>\"\",H36*H37,\"\")","v":0},{"$f":"IF(J35<>\"\",J36*J37,\"\")","v":423},null,{"$f":"IF(L35<>\"\",L36*L37,\"\")","v":501.63},null,179.25,{"$f":"IF(O35<>\"\",O35*O37,\"\")","v":0}]
[]
["Lønart"]
[3025,null,null,null,null,{"$f":"F35","v":1.895833333333333}]
[3425,null,null,null,null,{"$f":"G35","v":0}]
[3428,null,null,null,null,{"$f":"H35","v":0}]
["Timer",null,null,null,null,{"$f":"SUM(F41:F43)","v":1.895833333333333},{"$f":"IF(F44<>\"\",ROUND(F44*24,2),\"\")","v":45.5}]
[null,null,null,null,null,null,{"$f":"F37*G44","v":5722.08}]

{"sheet":"Tomt","index":2,"n_rows":45,"n_cols":26,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,16,0,19],[41,0,41,3],[42,0,42,3],[43,0,43,3],[0,1,0,5],[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,"08:00:00","20:00:00",{"$f":"IF($D4=\"\",\"\",VLOOKUP($D4,Timeberegning!$A$4:$O$10,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":"02:00:00"},{"$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,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D4,Timeberegning!$A$4:$O$101,15)))","v":""},{"$f":"IF(SUM(H4:I4)=0,\"\",SUM(H4:I4))","v":""},null,null,{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":8},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":0},{"$f":"IF(E4=\"\",\"\",TIME(HOUR(E4),MINUTE(E4),0))","v":"08:00:00"},{"$f":"IF(F4=\"\",\"\",HOUR(F4))","v":20},{"$f":"IF(F4=\"\",\"\",MINUTE(F4))","v":0},{"$f":"TIME(HOUR(F4),MINUTE(F4),0)","v":"20:00:00"}]
["2010-04-02",{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Fr"},{"$f":"HelligdagsNavn(A5,0,0)","v":"Langfredag"},null,"17:45:00",1,{"$f":"IF($D5=\"\",\"\",VLOOKUP($D5,Timeberegning!$A$4:$O$10,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":"06:00:00"},"",{"$f":"IF(G5<>0,IF(WEEKDAY(A5,2)=7,G5,\"\"),\"\")","v":""},{"$f":"IF($D5=\"\",\"\",IF(VLOOKUP($D5,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D5,Timeberegning!$A$4:$O$101,15)))","v":""},{"$f":"IF(SUM(H5:I5)=0,\"\",SUM(H5:I5))","v":""},null,null,17,45,"17:45:00",0,0,{"$f":"TIME(HOUR(F5),MINUTE(F5),0)","v":"00:00:00"}]
["2010-04-03",{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"Lø"},"",null,{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D6,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D6=\"\",\"\",IF(VLOOKUP($D6,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D6,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D6=\"\",\"\",VLOOKUP($D6,Timeberegning!$A$4:$O$10,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,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D6,Timeberegning!$A$4:$O$101,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,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D7,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D7,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D7=\"\",\"\",VLOOKUP($D7,Timeberegning!$A$4:$O$153,13))","v":""},null,null,"","","",{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D7,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D7=\"\",\"\",IF(VLOOKUP($D7,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D7,Timeberegning!$A$4:$P$101,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,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D8,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D8,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D8=\"\",\"\",VLOOKUP($D8,Timeberegning!$A$4:$O$153,13))","v":""},null,null,"","","",{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D8,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D8=\"\",\"\",IF(VLOOKUP($D8,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D8,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",{"$f":"TIME(HOUR(F8),MINUTE(F8),0)","v":{"$error":"#VALUE!"}}]
["2010-04-06","Ti","",null,{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D9,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D9,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D9=\"\",\"\",VLOOKUP($D9,Timeberegning!$A$4:$O$153,13))","v":""},null,null,"","",{"$f":"IF(G9<>0,IF(WEEKDAY(A9,2)=7,G9,\"\"),\"\")","v":""},{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D9,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D9=\"\",\"\",IF(VLOOKUP($D9,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D9,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",{"$f":"IF(F9=\"\",\"\",TIME(HOUR(F9),MINUTE(F9),0))","v":""}]
["2010-04-07","On","",null,{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D10,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D10,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D10,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","",{"$f":"IF(G10<>0,IF(WEEKDAY(A10,2)=7,G10,\"\"),\"\")","v":""},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D10,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D10,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-08","To","",null,{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D11,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D11,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D11,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","",{"$f":"IF(G11<>0,IF(WEEKDAY(A11,2)=7,G11,\"\"),\"\")","v":""},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D11,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D11,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-09","Fr","",null,{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D12,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D12,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-10","Lø","",null,{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D13,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D13,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D13,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D13,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D13=\"\",\"\",IF(VLOOKUP($D13,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D13,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-11","Sø","",null,{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D14,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D14,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D14,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D14,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D14=\"\",\"\",IF(VLOOKUP($D14,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D14,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-12","Ma","",null,{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D15,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D15,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D15,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D15,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D15=\"\",\"\",IF(VLOOKUP($D15,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D15,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-13","Ti","",null,{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D16,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D16,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D16,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D16,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D16=\"\",\"\",IF(VLOOKUP($D16,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D16,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-14","On","",null,{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D17,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D17,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D17,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D17,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D17=\"\",\"\",IF(VLOOKUP($D17,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D17,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-15","To","",null,{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D18,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D18,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D18,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D18,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D18=\"\",\"\",IF(VLOOKUP($D18,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D18,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-16","Fr","",null,{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D19,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D19,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D19,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D19,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D19=\"\",\"\",IF(VLOOKUP($D19,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D19,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-17","Lø","",null,{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D20,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D20,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D20,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D20,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D20=\"\",\"\",IF(VLOOKUP($D20,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D20,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-18","Sø","",null,{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D21,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D21,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D21,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D21,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D21=\"\",\"\",IF(VLOOKUP($D21,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D21,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-19","Ma","",null,{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D22,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D22,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D22,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D22,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D22=\"\",\"\",IF(VLOOKUP($D22,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D22,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-20","Ti","",null,{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D23,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D23,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D23,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D23,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D23=\"\",\"\",IF(VLOOKUP($D23,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D23,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-21","On","",null,{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D24,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D24,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D24,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D24,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D24=\"\",\"\",IF(VLOOKUP($D24,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D24,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-22","To","",null,{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D25,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D25,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D25,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D25,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D25=\"\",\"\",IF(VLOOKUP($D25,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D25,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-23","Fr","",null,{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D26,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D26,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D26,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D26,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D26=\"\",\"\",IF(VLOOKUP($D26,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D26,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-24","Lø","",null,{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D27,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D27,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D27,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D27,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D27=\"\",\"\",IF(VLOOKUP($D27,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D27,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-25","Sø","",null,{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D28,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D28,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D28,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D28,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D28=\"\",\"\",IF(VLOOKUP($D28,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D28,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-26","Ma","",null,{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D29,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D29,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D29,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D29,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D29=\"\",\"\",IF(VLOOKUP($D29,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D29,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-27","Ti","",null,{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D30,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D30,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D30,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D30,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D30=\"\",\"\",IF(VLOOKUP($D30,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D30,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-28","On","",null,{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D31,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D31,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D31,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D31,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D31=\"\",\"\",IF(VLOOKUP($D31,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D31,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-29",{"$f":"IF(A32=\"\",\"\",PROPER(TEXT(A32,\"ddd\")))","v":"To"},"",null,{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D32,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D32,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D32,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D32,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D32=\"\",\"\",IF(VLOOKUP($D32,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D32,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2010-04-30",{"$f":"IF(A33=\"\",\"\",PROPER(TEXT(A33,\"ddd\")))","v":"Fr"},"Store Bededag",null,{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D33,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D33,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D33,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D33,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D33=\"\",\"\",IF(VLOOKUP($D33,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D33,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
[null,"","",null,{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D34,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D34,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D34,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D34,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D34=\"\",\"\",IF(VLOOKUP($D34,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D34,Timeberegning!$A$4:$P$101,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.33333333333333337,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,8,0,0,null,0,0]
["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":0},{"$f":"IF(H35<>\"\",H36*H37,\"\")","v":0},0,150.4,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":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"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":"Timeberegning","index":4,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,6]]}
["Time beregning:"]
["Betalt pause ved vagt over 5 timer",null,null,null,null,null,null,"00:25:00","minutter","00:00:00","06:00:00","18:00:00","14:00:00"]
["vagt","start","slut","Tid","Pause 1 start","Pause 1 start","Tid","Pause 2 start","Pause 2 slut","Tid","Samlet pause","Selv betalt pause","Beregnet arbejdstid","1/100","Delevagt","Afholdt afspadsering"]
[111,"05:54:00","14:57:00",{"$f":"C4-B4+(B4>C4)","v":"09:03:00"},"10:34:00","11:08:00",{"$f":"TEXT(F4-E4,\"t:mm\")","v":"0:34"},null,null,{"$f":"I4-H4","v":"00:00:00"},{"$f":"G4+J4","v":"00:34:00"},{"$f":"IF(K4>H$2,K4-H$2,0)","v":"00:09:00"},{"$f":"D4-L4","v":"08:54:00"},{"$f":"24*M4","v":8.9}]
[112,"10:06:00","16:38:00",{"$f":"C5-B5+(B5>C5)","v":"06:32:00"},"14:00:00","14:46:00","0:46",null,null,{"$f":"I5-H5","v":"00:00:00"},{"$f":"G5+J5","v":"00:46:00"},{"$f":"IF(K5>H$2,K5-H$2,0)","v":"00:21:00"},{"$f":"D5-L5","v":"06:11:00"},{"$f":"24*M5","v":6.1833333333333327}]
[113,"07:55:00","16:19:00",{"$f":"C6-B6+(B6>C6)","v":"08:24:00"},null,null,"0:00",null,null,"00:00:00","00:00:00","00:00:00","08:24:00",8.4]
[114,"09:48:00","17:55:00",{"$f":"C7-B7+(B7>C7)","v":"08:07:00"},"12:34:00","12:58:00","0:24","15:04:00","16:01:00","00:57:00","01:21:00","00:56:00","07:11:00",7.1833333333333336]
[121,"04:36:00","11:24:00",{"$f":"C8-B8+(B8>C8)","v":"06:48:00"},"08:30:00","08:58:00","0:28",null,null,"00:00:00","00:28:00","00:03:00","06:45:00",6.7500000000000018]
[122,"04:36:00","11:58:00","07:22:00","08:32:00","08:51:00","0:19","09:22:00","10:03:00","00:41:00","01:00:00","00:35:00","06:47:00",6.7833333333333332]
[123,"04:48:00","12:24:00","07:36:00","06:32:00","06:58:00","0:26","09:04:00","09:43:00","00:39:00","01:05:00","00:40:00","06:56:00",6.9333333333333353]
[124,"05:20:00","12:53:00","07:33:00","06:32:00","07:01:00","0:29",null,null,"00:00:00","00:29:00","00:04:00","07:29:00",7.4833333333333334]
[125,"05:44:00","14:53:00","09:09:00","09:52:00","10:58:00","1:06",null,null,"00:00:00","01:06:00","00:41:00","08:28:00",8.466666666666665]
[126,"05:56:00","09:55:00","03:59:00",null,null,"0:00",null,null,"00:00:00",{"$f":"IF(G13=\"\",\"\",G13+J13)","v":"00:00:00"},{"$f":"IF(K13=\"\",\"\",IF(K13>H$2,K13-H$2,0))","v":"00:00:00"},{"$f":"D13-L13","v":"03:59:00"},{"$f":"24*M13","v":3.9833333333333325}]
[127,"05:55:00","16:04:00","10:09:00","07:56:00","08:56:00","1:00","11:02:00","14:07:00","03:05:00",{"$f":"IF(G14=\"\",\"\",G14+J14)","v":"04:05:00"},{"$f":"IF(K14=\"\",\"\",IF(K14>H$2,K14-H$2,0))","v":"03:40:00"},"06:29:00",6.4833333333333316,1]
[128,"05:58:00","17:54:00","11:56:00","09:53:00","13:07:00",{"$f":"TEXT(F15-E15,\"t:mm\")","v":"3:14"},"15:02:00","15:58:00","00:56:00","04:10:00","03:45:00","08:11:00",8.18333333333333,1]
[129,"05:59:00","16:55:00","10:56:00","10:04:00","13:43:00","3:39","14:17:00","15:01:00","00:44:00","04:23:00","03:58:00","06:58:00",6.9666666666666686,1]
[130,"06:00:00","17:06:00","11:06:00","10:02:00","11:58:00","1:56","13:53:00","14:58:00","01:05:00","03:01:00","02:36:00","08:30:00",8.5,1]
[131,"06:55:00","14:06:00","07:11:00","08:52:00","09:58:00","1:06",null,null,"00:00:00","01:06:00","00:41:00","06:30:00",6.5]
[132,"06:55:00","15:55:00","09:00:00","08:51:00","09:58:00","1:07",null,null,"00:00:00","01:07:00","00:42:00","08:18:00",8.2999999999999989]
[133,"07:05:00","16:00:00","08:55:00","09:00:00","10:01:00","1:01",null,null,"00:00:00","01:01:00","00:36:00","08:19:00",8.3166666666666664]
[134,"07:07:00","16:16:00","09:09:00","10:52:00","11:52:00","1:00",null,null,"00:00:00","01:00:00","00:35:00","08:34:00",8.5666666666666664]
[135,"10:55:00","16:06:00","05:11:00","13:04:00","13:58:00","0:54",null,null,"00:00:00","00:54:00","00:29:00","04:42:00",4.700000000000002]
[136,"10:58:00","18:06:00","07:08:00","12:53:00","13:58:00","1:05",null,null,"00:00:00","01:05:00","00:40:00","06:28:00",6.4666666666666686]
[137,"11:07:00","20:32:00","09:25:00","14:52:00","15:58:00","1:06",null,null,"00:00:00","01:06:00","00:41:00","08:44:00",8.7333333333333343]
[138,"11:55:00","20:55:00","09:00:00","15:52:00","16:58:00","1:06",null,null,"00:00:00","01:06:00","00:41:00","08:19:00",8.3166666666666682]
["138X","11:55:00","15:54:00","03:59:00",null,null,"0:00",null,null,"00:00:00","00:00:00","00:00:00","03:59:00",3.9833333333333338]
["138Y","16:55:00","20:55:00","04:00:00",null,null,"0:00",null,null,"00:00:00","00:00:00","00:00:00","04:00:00",3.9999999999999991]
[139,"13:05:00","19:55:00","06:50:00","17:02:00","18:01:00","0:59",null,null,"00:00:00","00:59:00","00:34:00","06:16:00",6.2666666666666657]
[140,"14:55:00","22:22:00","07:27:00","17:22:00","17:58:00","0:36",null,null,"00:00:00","00:36:00","00:11:00","07:16:00",7.2666666666666675]
[141,"14:55:00","21:23:00","06:28:00","18:51:00","19:28:00","0:37",null,null,"00:00:00","00:37:00","00:12:00","06:16:00",6.2666666666666639]
[142,"15:05:00","00:22:00","09:17:00","19:02:00","20:13:00","1:11",null,null,"00:00:00","01:11:00","00:46:00","08:31:00",8.5166666666666657]
[143,"16:05:00","23:12:00","07:07:00","18:00:00","18:28:00","0:28","20:52:00","21:16:00","00:24:00","00:52:00","00:27:00","06:40:00",6.6666666666666696]
["143F","16:05:00","01:47:00","09:42:00","18:00:00","18:28:00","0:28","23:10:00","23:53:00","00:43:00",{"$f":"G33+J33","v":"01:11:00"},{"$f":"IF(K33>H$2,K33-H$2,0)","v":"00:46:00"},{"$f":"D33-L33","v":"08:56:00"},{"$f":"24*M33","v":8.9333333333333336}]
[144,"16:07:00","23:23:00","07:16:00","18:02:00","19:16:00","1:14",null,null,"00:00:00","01:14:00","00:49:00","06:27:00",6.4499999999999984]
["144F","16:07:00","01:47:00","09:40:00","18:02:00","19:16:00","1:14","23:21:00","23:53:00",{"$f":"I35-H35","v":"00:32:00"},{"$f":"G35+J35","v":"01:46:00"},{"$f":"IF(K35>H$2,K35-H$2,0)","v":"01:21:00"},{"$f":"D35-L35","v":"08:19:00"},{"$f":"24*M35","v":8.3166666666666664}]
[145,"16:58:00","00:42:00","07:44:00","19:22:00","20:13:00","0:51",null,null,"00:00:00","00:51:00","00:26:00","07:18:00",7.3000000000000025]
[146,"17:05:00","01:10:00","08:05:00","19:00:00","19:28:00","0:28","22:22:00","23:00:00","00:38:00","01:06:00","00:41:00","07:24:00",7.400000000000003]
[147,"17:25:00","01:26:00","08:01:00","19:22:00","19:51:00","0:29","22:20:00","22:55:00","00:35:00","01:04:00","00:39:00","07:22:00",7.3666666666666618]
[148,"06:25:00","17:25:00","11:00:00","08:25:00","13:55:00","5:30",null,null,"00:00:00","05:30:00","05:05:00","05:55:00",5.9166666666666687,1]
[601,"04:36:00","12:24:00","07:48:00","06:32:00","07:08:00","0:36","09:36:00","10:01:00","00:25:00","01:01:00","00:36:00","07:12:00",7.2000000000000011]
[602,"04:36:00","12:53:00","08:17:00","06:32:00","06:58:00","0:26","09:58:00","10:33:00","00:35:00","01:01:00","00:36:00","07:41:00",7.6833333333333327]
[603,"04:48:00","12:02:00","07:14:00","06:32:00","06:58:00","0:26","09:33:00","10:08:00","00:35:00","01:01:00","00:36:00","06:38:00",6.6333333333333346]
[604,"05:20:00","14:06:00","08:46:00","06:32:00","07:01:00","0:29","10:51:00","11:26:00","00:35:00","01:04:00","00:39:00","08:07:00",8.1166666666666671]
[605,"05:58:00","12:54:00","06:56:00","06:32:00","06:58:00","0:26","10:22:00","10:58:00","00:36:00","01:02:00","00:37:00","06:19:00",6.3166666666666664]
[606,"06:07:00","15:15:00","09:08:00","12:04:00","12:51:00","0:47",null,null,"00:00:00","00:47:00","00:22:00","08:46:00",8.7666666666666657]
[607,"07:55:00","15:24:00","07:29:00","12:02:00","12:27:00","0:25",null,null,"00:00:00","00:25:00","00:00:00","07:29:00",7.4833333333333343]
[608,"08:07:00","16:04:00","07:57:00","11:22:00","12:08:00","0:46",null,null,"00:00:00","00:46:00","00:21:00","07:36:00",7.5999999999999979]
[609,"08:55:00","17:05:00","08:10:00","11:26:00","11:51:00","0:25","14:51:00","15:11:00","00:20:00","00:45:00","00:20:00","07:50:00",7.8333333333333339]
[610,"12:07:00","18:44:00","06:37:00","16:00:00","16:25:00","0:25",null,null,"00:00:00","00:25:00","00:00:00","06:37:00",6.6166666666666671]
[611,"13:55:00","22:22:00","08:27:00","18:00:00","18:28:00","0:28",null,null,"00:00:00","00:28:00","00:03:00","08:24:00",8.4000000000000021]
[612,"14:55:00","00:22:00","09:27:00","18:52:00","19:28:00","0:36","21:21:00","21:51:00","00:30:00","01:06:00","00:41:00","08:46:00",8.7666666666666657]
[613,"14:55:00","00:42:00","09:47:00","19:22:00","20:13:00","0:51",null,null,"00:00:00","00:51:00","00:26:00","09:21:00",9.35]
[614,"15:55:00","01:10:00","09:15:00","18:04:00","18:31:00","0:27","22:20:00","22:55:00","00:35:00","01:02:00","00:37:00","08:38:00",8.6333333333333329]
[615,"16:48:00","01:47:00","08:59:00","20:52:00","21:16:00","0:24","23:10:00","23:53:00","00:43:00","01:07:00","00:42:00","08:17:00",8.2833333333333314]
[616,"16:55:00","01:47:00","08:52:00","18:51:00","19:26:00","0:35","23:21:00","23:53:00","00:32:00","01:07:00","00:42:00","08:10:00",8.1666666666666679]
[617,"18:35:00","01:26:00","06:51:00","22:20:00","22:45:00","0:25",null,null,"00:00:00","00:25:00","00:00:00","06:51:00",6.8500000000000023]
[701,"04:36:00","12:24:00","07:48:00","06:32:00","07:08:00","0:36","09:36:00","10:01:00","00:25:00","01:01:00","00:36:00","07:12:00",7.2000000000000011]
[702,"04:36:00","12:53:00","08:17:00","06:32:00","06:58:00","0:26","09:58:00","10:33:00","00:35:00","01:01:00","00:36:00","07:41:00",7.6833333333333327]
[703,"04:48:00","12:02:00","07:14:00","06:32:00","06:58:00","0:26","09:33:00","10:08:00","00:35:00","01:01:00","00:36:00","06:38:00",6.6333333333333346]
[704,"05:20:00","14:06:00","08:46:00","06:32:00","07:01:00","0:29","10:51:00","11:26:00","00:35:00","01:04:00","00:39:00","08:07:00",8.1166666666666671]
[705,"05:58:00","12:54:00","06:56:00","06:32:00","06:58:00","0:26","10:22:00","10:58:00","00:36:00","01:02:00","00:37:00","06:19:00",6.3166666666666664]
[706,"06:07:00","15:15:00","09:08:00","12:04:00","12:51:00","0:47",null,null,"00:00:00","00:47:00","00:22:00","08:46:00",8.7666666666666657]
[707,"07:55:00","15:24:00","07:29:00","12:02:00","12:27:00","0:25",null,null,"00:00:00","00:25:00","00:00:00","07:29:00",7.4833333333333343]
[708,"08:07:00","16:04:00","07:57:00","11:22:00","12:08:00","0:46",null,null,"00:00:00","00:46:00","00:21:00","07:36:00",7.5999999999999979]
[709,"08:55:00","17:05:00","08:10:00","11:26:00","11:51:00","0:25","14:51:00","15:11:00","00:20:00","00:45:00","00:20:00","07:50:00",7.8333333333333339]
[710,"12:07:00","18:44:00","06:37:00","16:00:00","16:25:00","0:25",null,null,"00:00:00","00:25:00","00:00:00","06:37:00",6.6166666666666671]
[711,"13:55:00","22:22:00","08:27:00","18:00:00","18:28:00","0:28",null,null,"00:00:00","00:28:00","00:03:00","08:24:00",8.4000000000000021]
[712,"14:55:00","00:22:00","09:27:00","18:52:00","19:28:00","0:36","21:21:00","21:51:00","00:30:00","01:06:00","00:41:00","08:46:00",8.7666666666666657]
[713,"14:55:00","00:42:00","09:47:00","19:22:00","20:13:00","0:51",null,null,"00:00:00","00:51:00","00:26:00","09:21:00",9.35]
[714,"15:55:00","01:10:00","09:15:00","18:04:00","18:31:00","0:27","22:20:00","22:55:00","00:35:00","01:02:00","00:37:00","08:38:00",8.6333333333333329]
[715,"16:48:00","01:47:00","08:59:00","20:52:00","21:16:00","0:24","23:10:00","23:53:00","00:43:00","01:07:00","00:42:00","08:17:00",8.2833333333333314]
[716,"16:55:00","01:47:00","08:52:00","18:51:00","19:26:00","0:35","23:21:00","23:53:00",{"$f":"I72-H72","v":"00:32:00"},{"$f":"G72+J72","v":"01:07:00"},{"$f":"IF(K72>H$2,K72-H$2,0)","v":"00:42:00"},"08:10:00",8.1666666666666679]
[717,"18:35:00","01:26:00","06:51:00","22:20:00","22:45:00","0:25",null,null,"00:00:00","00:25:00","00:00:00","06:51:00",6.8500000000000023]
[]
["afsp.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:24:00"]
["x"]
["Fri"]
["ferie"]

{"sheet":"Ark1","index":5,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,3,26,4],[0,0,0,1],[1,0,3,0],[1,1,3,1],[1,3,1,5],[2,3,2,5],[24,3,24,4]]}
["Koder"]
["Dataløn","BusPlan","Nr.","Navn:",null,null,"Anc."]
[null,null,1807,"Bjarne Hansen",null,null,3]
[null,null,null,"TAST HER"]
[null,"001","Køretid",null,{"$f":"Satser!B3","v":119.62},{"$f":"D5*E5","v":0}]
[null,3025,"Timer",{"$f":"'Juni2010 (2)'!G36","v":151.78},{"$f":"Satser!B3","v":119.62},{"$f":"D6*E6","v":18155.923600000002}]
[null,3210,"Delt vagt",{"$f":"'Juni2010 (2)'!M35","v":1},{"$f":"Satser!B21","v":67},{"$f":"D7*E7","v":67}]
[null,3405,"Overarb. 50%",{"$f":"'Juni2010 (2)'!H36","v":0},{"$f":"Satser!B10","v":185.57},{"$f":"D8*E8","v":0}]
[null,3410,"Overarb. 100%",{"$f":"'Juni2010 (2)'!I36","v":0},{"$f":"Satser!B13","v":245.38},{"$f":"D9*E9","v":0}]
[null,3600,"Forskudt 18-24",{"$f":"'Juni2010 (2)'!J36","v":60.45},{"$f":"Satser!B15","v":18.8},{"$f":"D10*E10","v":1136.46}]
[null,3602,"Nattid 24-06",{"$f":"'Juni2010 (2)'!K36","v":13.02},{"$f":"Satser!B16","v":21.81},283.96619999999996]
[null,3605,"Week-end",{"$f":"'Juni2010 (2)'!L36","v":24.53},{"$f":"Satser!B17","v":28.68},703.5204]
[null,3024,"Till.pr.arb.Dag",null,5,0]
[null,3211,"Tælling",null,5,0]
[null,3997,"Sygedagpenge",null,667,0]
[null,null,"Uniformspenge",null,10.5,0]
[null,null,"½ G-dag",null,334,0]
[null,null,"G-dag",null,667,0]
[null,null,"Diverse tillæg",null,null,0]
[null,null,"Regulering timer -",null,{"$f":"Satser!B3","v":119.62},0]
[null,null,"Regulering 18-24 -",null,{"$f":"Satser!B15","v":18.8},0]
[null,null,"Regulering 24-06 -",null,{"$f":"Satser!B16","v":21.81},0]
[null,null,"Regulering Søn -",null,{"$f":"Satser!B17","v":28.68},0]
[null,null,"Regulering Delt vagt",null,{"$f":"Satser!B21","v":67},0]
[null,null,null,"Sum",null,{"$f":"SUM(F5:F24)","v":20346.870200000001}]
[null,null,"Anc.Tillæg",{"$f":"D6","v":151.78},{"$f":"IF(G3=0,\"0\",IF(G3=1,\"4,26\",IF(G3=3,\"5,34\",\"4,80\")))","v":"5,34"},{"$f":"D26*E26","v":810.50519999999995}]
[null,null,null,"Bruttoløn",null,{"$f":"F25+F26","v":21157.375400000001}]
[null,null,"Km-penge",null,3.3,{"$f":"D28*E28","v":0}]
[]
[null,null,null,"14 dg","time"]
[null,1,"Anc.Tillæg",315.14999999999998,{"$f":"D31/74","v":4.2587837837837839}]
[null,2,"Anc.Tillæg",355.2,{"$f":"D32/74","v":4.8}]
[null,3,"Anc.Tillæg",395.16,{"$f":"D33/74","v":5.3400000000000007}]

{"sheet":"Ark2","index":6,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["start","slut",null,"tid","pause start","pause slut","tid"]
["13:55:00","22:11:00",null,{"$f":"B2-A2","v":0.34444444444444455},"19:52:00","20:17:00",{"$f":"TEXT(F2-E2,\"t:mm\")","v":"0:25"},null,{"$f":"TEXT(D2-G2,\"t:mm\")","v":"7:51"}]
["14:10:00",1,null,{"$f":"B3-A3","v":"09:50:00"}]
["00:00:00","00:11:00",null,{"$f":"B4-A4","v":"00:11:00"}]
["2010-06-10T14:10:00","2010-06-11T00:11:00",null,{"$f":"B5-A5","v":"10:01:00"}]
[null,null,null,{"$f":"SUM(D2:D5)","v":1.179166666666505},{"$f":"D6*24","v":28.299999999996121}]

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