{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Juni2010","september2010","oktober2010","Tomt","Satser","Timeberegning","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","index":0,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":true,"merged":[[43,0,43,2],[0,1,0,4],[0,14,0,15],[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,"Time beregning:"]
["Lønart",null,null,null,null,3025,3425,3426,3600,3602,3605,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,"Start","Slut","Time SID","Overtid           1-3 time","Overtid            4 - time","Aftenstillæg","Nattillæg     00-06","Søndags tillæg"]
["2010-06-01",{"$f":"PROPER(TEXT(A4,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A4,0,0)","v":""},"00:01:00","13:00:00",{"$f":"IF(D4=\"\",\"\",(E4-D4)+(D4>E4))","v":0.54097222222222219},null,null,{"$f":"IF(D4<>\"\",IF(WEEKDAY(A4,2)<>6,IF(D4>E4,(E4-MAX(D4,(18/24))+(D4>E4))-E4,IF(E4>W$2,(E4-MAX(D4,(18/24))),\"\")),IF(D4>E4,(E4-MAX(D4,(14/24))+(D4>E4))-E4,IF(E4>X$2,(E4-MAX(D4,(14/24))),\"\"))),\"\")","v":""},{"$f":"IF(F4<>\"\",IF(Q4<V$2,(V$2-Q4),IF(T4<V$2,(T4-U$2),\"\")),\"\")","v":"05:59:00"},{"$f":"IF(F4<>0,IF(WEEKDAY(A4,2)=7,F4,\"\"),\"\")","v":""},{"$f":"IF(SUM(G4:H4)=0,\"\",SUM(G4:H4))","v":""},null,null,{"$f":"IF(D4=\"\",\"\",HOUR(D4))","v":0},{"$f":"IF(D4=\"\",\"\",MINUTE(D4))","v":1},{"$f":"IF(D4=\"\",\"\",TIME(HOUR(D4),MINUTE(D4),0))","v":"00:01:00"},{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":13},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":0},{"$f":"TIME(HOUR(E4),MINUTE(E4),0)","v":"13:00:00"}]
["2010-04-02",{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Fr"},{"$f":"HelligdagsNavn(A5,0,0)","v":"Langfredag"},"10:00:00","18:30:00",0.35416666666666669,null,null,"00:30:00","","","",null,null,10,0,"10:00:00",18,30,{"$f":"TIME(HOUR(E5),MINUTE(E5),0)","v":"18:30:00"}]
["2010-04-03",{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"Lø"},"",null,null,"",null,null,"","","","",null,null,"","","","","",{"$f":"TIME(HOUR(E6),MINUTE(E6),0)","v":"00:00:00"}]
["2010-04-04","Sø","Påskedag",null,null,"",null,null,"","","","",null,null,"","","","","",{"$f":"TIME(HOUR(E7),MINUTE(E7),0)","v":"00:00:00"}]
["2010-04-05","Ma","2. Påskedag",null,null,"",null,null,"","","","",null,null,"","","","","",{"$f":"TIME(HOUR(E8),MINUTE(E8),0)","v":"00:00:00"}]
["2010-04-06","Ti","",null,null,"",null,null,"","","","",null,null,"","","","","",{"$f":"IF(E9=\"\",\"\",TIME(HOUR(E9),MINUTE(E9),0))","v":""}]
["2010-04-07","On","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-08","To","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-09","Fr","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-10","Lø","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-11","Sø","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-12","Ma","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-13","Ti","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-14","On","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-15","To","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-16","Fr","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-17","Lø","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-18","Sø","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-19","Ma","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-20","Ti","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-21","On","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-22","To","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-23","Fr","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-24","Lø","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-25","Sø","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-26","Ma","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-27","Ti","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-28","On","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-29",{"$f":"IF(A32=\"\",\"\",PROPER(TEXT(A32,\"ddd\")))","v":"To"},"",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["2010-04-30",{"$f":"IF(A33=\"\",\"\",PROPER(TEXT(A33,\"ddd\")))","v":"Fr"},"Store Bededag",null,null,"",null,null,"","","","",null,null,"","","","","",""]
[null,"","",null,null,"",null,null,"","","","",null,null,"","","","","",""]
["Total timer",null,null,null,null,{"$f":"IF(SUM(F9:F34)<>\"0\",SUM(F4:F34),\"\")","v":0.89513888888888893},{"$f":"IF(SUM(G4:G34)<>\"0\",SUM(G4:G34),\"\")","v":0},0,2.083333333333337E-2,0.24930555555555556,0,{"$f":"SUM(L4:L34)","v":0},{"$f":"SUM(M4:M34)","v":0}]
["Timer 1/100",null,null,null,null,{"$f":"IF(F35<>\"\",ROUND(F35*24,2),\"\")","v":21.48},{"$f":"IF(G35<>\"\",ROUND(G35*24,2),\"\")","v":0},0,0.5,5.98,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},18.8,21.81,28.68]
[null,null,null,null,null,{"$f":"IF(F35<>\"\",F36*F37,\"\")","v":2701.3248000000003},{"$f":"IF(G35<>\"\",G36*G37,\"\")","v":0},0,9.4,130.4238,0]
[]
["Lønart"]
[3025,null,null,null,null,{"$f":"F35","v":0.89513888888888893}]
[3425,null,null,null,null,{"$f":"G35","v":0}]
[3426,null,null,null,null,{"$f":"H35","v":0}]
["Timer",null,null,null,null,{"$f":"SUM(F41:F43)","v":0.89513888888888893},{"$f":"IF(F44<>\"\",ROUND(F44*24,2),\"\")","v":21.48}]
[null,null,null,null,null,null,{"$f":"F37*G44","v":2701.3248000000003}]

{"sheet":"september2010","index":1,"n_rows":53,"n_cols":35,"rows_kept":53,"cut":false,"hidden":false,"merged":[[11,14,11,15],[44,10,44,11],[45,10,45,11],[8,11,8,14],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[43,10,43,11],[34,10,34,11],[35,10,35,11],[36,10,36,11],[37,10,37,11],[38,10,38,11],[29,10,29,11],[30,10,30,11],[33,10,33,11],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[28,10,28,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[31,10,31,11],[32,10,32,11],[42,14,42,15],[43,14,43,15],[44,14,44,15],[45,14,45,15],[9,10,9,11],[10,10,10,11],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[37,14,37,15],[38,14,38,15],[39,14,39,15],[40,14,40,15],[41,14,41,15],[32,14,32,15],[33,14,33,15],[34,14,34,15],[35,14,35,15],[36,14,36,15],[27,14,27,15],[28,14,28,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[22,14,22,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[17,14,17,15],[18,14,18,15],[19,14,19,15],[20,14,20,15],[21,14,21,15],[49,0,49,2],[50,0,50,2],[51,0,51,2],[8,25,8,26],[9,1,9,2],[10,1,10,2],[47,0,47,2],[48,0,48,2],[8,1,8,6],[9,14,9,15],[10,14,10,15],[12,14,12,15],[13,14,13,15],[14,14,14,15],[15,14,15,15],[16,14,16,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faktor:",1,1.5,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aften tillæg","Fra kl.","16:00:00","Til kl.","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nat tillæg","Fra kl.",1,"Til kl.","06:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lørdag","Fra kl.","14:00:00","Til kl.","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundlovsdag","Fra kl.","12:00:00","Til kl.","00:00:00"]
[]
[]
[]
["Løn",{"$f":"PROPER(TEXT(A12,\"dd mmmm åååå\")) & PROPER(TEXT(A42,\"  -  dd mmmm åååå\"))","v":"06 September 2010  -  03 Oktober 2010"},null,null,null,null,null,"Uge :",null,null,{"$f":"IF(A12=\"\",\"\",TRUNC((A12-WEEKDAY(A12,2)-DATE(YEAR(A12+4-WEEKDAY(A12,2)),1,-10))/7))","v":36},"-",null,null,null,{"$f":"IF(A36=\"\",\"\",TRUNC((A36-WEEKDAY(A36,2)-DATE(YEAR(A36+4-WEEKDAY(A36,2)),1,-10))/7))","v":39},null,null,null,null,null,null,null,null,null,"Time beregning:"]
["Lønart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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","Time SID","Pause","Normal Timer  07-16","Optjent","Pause","Aftenstillæg alle dage        16-24",null,"Optjent","Pause","Nattillæg     24-07",null,"Optjent","Lørdag tillæg 06 - 06","Søndag tillæg 06-06","Samlet optjent","normal tid","Optjent afspadsering","Afholdt afspadsering"]
["2010-09-06",{"$f":"PROPER(TEXT(A12,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A12,0,0)","v":""},"22:00:00","07:00:00",{"$f":"IF(D12=\"\",\"\",(E12-D12)+(D12>E12))","v":0.375},null,{"$f":"ColTime(TIME(7,0,0),TIME(16,0,0),D12,E12)-G12","v":"00:00:00"},{"$f":"IF(WEEKDAY(A12,2)<6,H12*$AE$1,IF(WEEKDAY(A12,2)=6,H12*$AF$1,IF(WEEKDAY(A12,2)=7,H12*$AG$1,\"\")))","v":"00:00:00"},"01:00:00",{"$f":"IF(D12=\"\",\"\",(IF(E12-MAX(D12,(16/24))+(E12<D12)<0,0,E12-MAX(D12,(16/24))+(E12<D12)))-(IF((E12-MAX(D12,(24/24))+(E12<D12))<0,0,(E12-MAX(D12,(24/24))+(E12<D12)))))-J12","v":"01:00:00"},null,{"$f":"IF(WEEKDAY(A12,2)<6,K12*24*$AF$1,IF(WEEKDAY(A12,2)>5,K12*24*$AG$1,\"\"))/24","v":"01:30:00"},null,{"$f":"IF(F12=\"\",\"\",IF((E12-MAX(D12,(24/24))+(D12>E12))<0,0,(IF(E12<D12,IF(E12>7/24,7/24,E12),E12)-MAX(D12,(24/24)))+(D12>E12))+(7/24)-MIN(D12,(7/24)))-N12","v":"07:00:00"},null,{"$f":"IF(WEEKDAY(A12,2)<6,O12*24*$AF$1,IF(WEEKDAY(A12,2)>5,O12*24*$AG$1,\"\"))/24","v":"10:30:00"},null,{"$f":"IF(D12=\"\",\"\",IF(D12<6/24,6/24-D12,\"\"))","v":""},{"$f":"I12+M12+Q12","v":"12:00:00"},{"$f":"IF(WEEKDAY(A12,2)<5,Satser!$B$23,IF(WEEKDAY(A12,2)=5,Satser!$B$24,\"\"))","v":"07:45:00"},{"$f":"IF(F12=\"\",\"\",IF(F12<>0,I12+M12+Q12-U12,\"\"))","v":"04:15:00"},null,null,null,{"$f":"IF(D12=\"\",\"\",HOUR(D12))","v":22},{"$f":"IF(D12=\"\",\"\",MINUTE(D12))","v":0},{"$f":"IF(D12=\"\",\"\",TIME(HOUR(D12),MINUTE(D12),0))","v":"22:00:00"},{"$f":"IF(E12=\"\",\"\",HOUR(E12))","v":7},{"$f":"IF(E12=\"\",\"\",MINUTE(E12))","v":0},{"$f":"IF(E12=\"\",\"\",TIME(HOUR(E12),MINUTE(E12),0))","v":"07:00:00"}]
[{"$f":"A12+1","v":"2010-09-07"},{"$f":"PROPER(TEXT(A13,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A13,0,0)","v":""},"07:00:00","16:00:00",0.37499999999999994,"01:00:00",{"$f":"ColTime(TIME(7,0,0),TIME(16,0,0),D13,E13)-G13","v":"08:00:00"},{"$f":"IF(WEEKDAY(A13,2)<6,H13*$AE$1,IF(WEEKDAY(A13,2)=6,H13*$AF$1,IF(WEEKDAY(A13,2)=7,H13*$AG$1,\"\")))","v":"08:00:00"},null,{"$f":"IF(D13=\"\",\"\",(IF(E13-MAX(D13,(16/24))+(E13<D13)<0,0,E13-MAX(D13,(16/24))+(E13<D13)))-(IF((E13-MAX(D13,(24/24))+(E13<D13))<0,0,(E13-MAX(D13,(24/24))+(E13<D13)))))-J13","v":"00:00:00"},null,"00:00:00",null,{"$f":"IF(F13=\"\",\"\",IF((E13-MAX(D13,(24/24))+(D13>E13))<0,0,(IF(E13<D13,IF(E13>7/24,7/24,E13),E13)-MAX(D13,(24/24)))+(D13>E13))+(7/24)-MIN(D13,(7/24)))-N13","v":"00:00:00"},null,"00:00:00",null,null,"08:00:00",{"$f":"IF(WEEKDAY(A13,2)<5,Satser!$B$23,IF(WEEKDAY(A13,2)=5,Satser!$B$24,\"\"))","v":"07:45:00"},"00:15:00",null,null,null,7,0,"07:00:00",16,0,"16:00:00"]
[{"$f":"A13+1","v":"2010-09-08"},{"$f":"PROPER(TEXT(A14,\"ddd\"))","v":"On"},"","15:00:00","07:00:00",0.66666666666666674,null,{"$f":"ColTime(TIME(7,0,0),TIME(16,0,0),D14,E14)","v":"01:00:00"},"01:00:00",null,"08:00:00",null,"12:00:00",null,"07:00:00",null,"10:30:00",null,null,"23:30:00",{"$f":"IF(WEEKDAY(A14,2)<5,Satser!$B$23,IF(WEEKDAY(A14,2)=5,Satser!$B$24,\"\"))","v":"07:45:00"},"15:45:00",null,null,null,15,0,"15:00:00",7,0,"07:00:00"]
["2010-09-09","To","","06:30:00","15:00:00",0.35416666666666669,null,{"$f":"ColTime(TIME(7,0,0),TIME(16,0,0),D15,E15)","v":"08:00:00"},"08:00:00",null,"00:00:00",null,"00:00:00",null,"00:30:00",null,"00:45:00",null,null,"08:45:00",{"$f":"IF(WEEKDAY(A15,2)<5,Satser!$B$23,IF(WEEKDAY(A15,2)=5,Satser!$B$24,\"\"))","v":"07:45:00"},"01:00:00",null,null,null,6,30,"06:30:00",15,0,"15:00:00"]
["2010-09-10","Fr","","22:00:00","11:00:00",0.54166666666666674,null,{"$f":"ColTime(TIME(7,0,0),TIME(16,0,0),D16,E16)","v":"04:00:00"},"04:00:00",null,"02:00:00",null,"03:00:00",null,"07:00:00",null,"10:30:00",{"$f":"IF(E16<D16,IF(E16>6/24,E16-6/24,\"\"),\"\")","v":0.20833333333333331},null,"17:30:00",{"$f":"IF(WEEKDAY(A16,2)<5,Satser!$B$23,IF(WEEKDAY(A16,2)=5,Satser!$B$24,\"\"))","v":"06:00:00"},"11:30:00",null,null,null,22,0,"22:00:00",11,0,"11:00:00",null,null,null,{"$f":"WEEKDAY(A16,2)","v":5}]
["2010-09-11","Lø","","22:00:00","11:00:00",0.54166666666666674,null,{"$f":"ColTime(TIME(7,0,0),TIME(16,0,0),D17,E17)","v":"04:00:00"},"06:00:00",null,"02:00:00",null,"04:00:00",null,"07:00:00",null,"14:00:00",{"$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":0.33333333333333337},{"$f":"IF(E17<D17,IF(E17>6/24,E17-6/24,\"\"),\"\")","v":0.20833333333333331},1.0000000000000004,{"$f":"IF(WEEKDAY(A17,2)<5,Satser!$B$23,IF(WEEKDAY(A17,2)=5,Satser!$B$24,0))","v":"00:00:00"},1.0000000000000004,null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2010-09-12","Sø","","23:59:00","13:00:00",0.54236111111111107,"01:00:00",{"$f":"ColTime(TIME(7,0,0),TIME(16,0,0),D18,E18)","v":"06:00:00"},"12:00:00",null,"00:01:00",null,"00:02:00",null,"07:00:00",null,"14:00:00",{"$f":"IF(D18=\"\",\"\",IF(D18<6/24,IF(E18<6/24,6/24-D18-(6/24-E18),6/24-D18),\"00:00\"))","v":"00:00"},{"$f":"IF(D18=\"\",\"\",IF((E18-MAX(D18,(6/24))+(D18>E18))<0,0,(IF(E18<D18,IF(E18>6/24,6/24,E18),E18)-MAX(D18,(6/24)))+(D18>E18))+(6/24)-MIN(E18,(6/24)))","v":0.25069444444444444},1.0847222222222224,{"$f":"IF(WEEKDAY(A18,2)<5,Satser!$B$23,IF(WEEKDAY(A18,2)=5,Satser!$B$24,0))","v":"00:00:00"},1.0847222222222224,null,null,null,23,59,"23:59:00",13,0,"13:00:00"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F19=\"\",\"\",IF(F19<>0,IF(C19<>\"\",IF(R19+S19=0,Satser!B$23,((R19+S19)*24)*(24/1440)+Satser!B$23),IF(R19+S19=0,\"\",((R19+S19)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A18+1","v":"2010-09-13"},{"$f":"PROPER(TEXT(A20,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A20,0,0)","v":""},null,null,{"$f":"IF(D20=\"\",\"\",(E20-D20)+(D20>E20))","v":""},null,null,null,null,{"$f":"IF(D20=\"\",\"\",(IF(E20-MAX(D20,(17/24))+(E20<D20)<0,0,E20-MAX(D20,(17/24))+(E20<D20)))-(IF((E20-MAX(D20,(23/24))+(E20<D20))<0,0,(E20-MAX(D20,(23/24))+(E20<D20)))))","v":""},null,null,null,{"$f":"IF(F20=\"\",\"\",IF((E20-MAX(D20,(23/24))+(D20>E20))<0,0,(IF(E20<D20,IF(E20>6/24,6/24,E20),E20)-MAX(D20,(23/24)))+(D20>E20))+(6/24)-MIN(D20,(6/24)))","v":""},null,null,null,{"$f":"IF(D20=\"\",\"\",IF(D20<6/24,6/24-D20,\"\"))","v":""},null,null,{"$f":"IF(F20=\"\",\"\",IF(F20<>0,IF(C20<>\"\",IF(R20+S20=0,Satser!B$23,((R20+S20)*24)*(24/1440)+Satser!B$23),IF(R20+S20=0,\"\",((R20+S20)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A20+1","v":"2010-09-14"},{"$f":"PROPER(TEXT(A21,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A21,0,0)","v":""},null,null,{"$f":"IF(D21=\"\",\"\",(E21-D21)+(D21>E21))","v":""},null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,{"$f":"IF(F21=\"\",\"\",IF(F21<>0,IF(C21<>\"\",IF(R21+S21=0,Satser!B$23,((R21+S21)*24)*(24/1440)+Satser!B$23),IF(R21+S21=0,\"\",((R21+S21)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A21+1","v":"2010-09-15"},{"$f":"PROPER(TEXT(A22,\"ddd\"))","v":"On"},"",null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,{"$f":"IF(F22=\"\",\"\",IF(F22<>0,IF(C22<>\"\",IF(R22+S22=0,Satser!B$23,((R22+S22)*24)*(24/1440)+Satser!B$23),IF(R22+S22=0,\"\",((R22+S22)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2010-09-16","To","",null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,{"$f":"IF(F23=\"\",\"\",IF(F23<>0,IF(C23<>\"\",IF(R23+S23=0,Satser!B$23,((R23+S23)*24)*(24/1440)+Satser!B$23),IF(R23+S23=0,\"\",((R23+S23)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2010-09-17","Fr","",null,null,"",null,null,null,null,"",null,null,null,"",null,null,{"$f":"IF(D24=\"\",\"\",IF(E24<D24,IF(E24>6/24,E24-6/24,\"\"),\"\"))","v":""},null,null,null,{"$f":"IF(F24=\"\",\"\",IF(F24<>0,IF(C24<>\"\",IF(R24+S24=0,Satser!B$23,((R24+S24)*24)*(24/1440)+Satser!B$23),IF(R24+S24=0,\"\",((R24+S24)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2010-09-18","Lø","",null,null,"",null,null,null,null,"",null,null,null,"",null,null,{"$f":"IF(D25=\"\",\"\",IF((E25-MAX(D25,(6/24))+(D25>E25))<0,0,(IF(E25<D25,IF(E25>6/24,6/24,E25),E25)-MAX(D25,(6/24)))+(D25>E25))+(6/24)-MIN(E25,(6/24)))","v":""},{"$f":"IF(E25<D25,IF(E25>6/24,E25-6/24,\"\"),\"\")","v":""},null,null,{"$f":"IF(F25=\"\",\"\",IF(F25<>0,IF(C25<>\"\",IF(R25+S25=0,Satser!B$23,((R25+S25)*24)*(24/1440)+Satser!B$23),IF(R25+S25=0,\"\",((R25+S25)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2010-09-19","Sø","",null,null,"",null,null,null,null,"",null,null,null,"",null,null,{"$f":"IF(D26=\"\",\"\",IF(D26<6/24,IF(E26<6/24,6/24-D26-(6/24-E26),6/24-D26),\"00:00\"))","v":""},{"$f":"IF(D26=\"\",\"\",IF((E26-MAX(D26,(6/24))+(D26>E26))<0,0,(IF(E26<D26,IF(E26>6/24,6/24,E26),E26)-MAX(D26,(6/24)))+(D26>E26))+(6/24)-MIN(E26,(6/24)))","v":""},null,null,{"$f":"IF(F26=\"\",\"\",IF(F26<>0,IF(C26<>\"\",IF(R26+S26=0,Satser!B$23,((R26+S26)*24)*(24/1440)+Satser!B$23),IF(R26+S26=0,\"\",((R26+S26)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F27=\"\",\"\",IF(F27<>0,IF(C27<>\"\",IF(R27+S27=0,Satser!B$23,((R27+S27)*24)*(24/1440)+Satser!B$23),IF(R27+S27=0,\"\",((R27+S27)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A26+1","v":"2010-09-20"},{"$f":"PROPER(TEXT(A28,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A28,0,0)","v":""},null,null,"",null,null,null,null,{"$f":"IF(D28=\"\",\"\",(IF(E28-MAX(D28,(17/24))+(E28<D28)<0,0,E28-MAX(D28,(17/24))+(E28<D28)))-(IF((E28-MAX(D28,(23/24))+(E28<D28))<0,0,(E28-MAX(D28,(23/24))+(E28<D28)))))","v":""},null,null,null,{"$f":"IF(F28=\"\",\"\",IF((E28-MAX(D28,(23/24))+(D28>E28))<0,0,(IF(E28<D28,IF(E28>6/24,6/24,E28),E28)-MAX(D28,(23/24)))+(D28>E28))+(6/24)-MIN(D28,(6/24)))","v":""},null,null,null,{"$f":"IF(D28=\"\",\"\",IF(D28<6/24,6/24-D28,\"\"))","v":""},null,null,{"$f":"IF(F28=\"\",\"\",IF(F28<>0,IF(C28<>\"\",IF(R28+S28=0,Satser!B$23,((R28+S28)*24)*(24/1440)+Satser!B$23),IF(R28+S28=0,\"\",((R28+S28)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A28+1","v":"2010-09-21"},{"$f":"PROPER(TEXT(A29,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A29,0,0)","v":""},null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,{"$f":"IF(F29=\"\",\"\",IF(F29<>0,IF(C29<>\"\",IF(R29+S29=0,Satser!B$23,((R29+S29)*24)*(24/1440)+Satser!B$23),IF(R29+S29=0,\"\",((R29+S29)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A29+1","v":"2010-09-22"},{"$f":"PROPER(TEXT(A30,\"ddd\"))","v":"On"},"",null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,{"$f":"IF(F30=\"\",\"\",IF(F30<>0,IF(C30<>\"\",IF(R30+S30=0,Satser!B$23,((R30+S30)*24)*(24/1440)+Satser!B$23),IF(R30+S30=0,\"\",((R30+S30)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2010-09-23","To","",null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,{"$f":"IF(F31=\"\",\"\",IF(F31<>0,IF(C31<>\"\",IF(R31+S31=0,Satser!B$23,((R31+S31)*24)*(24/1440)+Satser!B$23),IF(R31+S31=0,\"\",((R31+S31)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2010-09-24","Fr","","22:00:00","11:00:00",0.54166666666666674,null,null,null,null,"01:00:00",null,null,null,"07:00:00",null,null,{"$f":"IF(E32<D32,IF(E32>6/24,E32-6/24,\"\"),\"\")","v":0.20833333333333331},null,null,null,{"$f":"IF(F32=\"\",\"\",IF(F32<>0,IF(C32<>\"\",IF(R32+S32=0,Satser!B$23,((R32+S32)*24)*(24/1440)+Satser!B$23),IF(R32+S32=0,\"\",((R32+S32)*24)*(24/1440))),\"\"))","v":"02:00:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2010-09-25","Lø","","22:00:00","11:00:00",0.54166666666666674,null,null,null,null,"01:00:00",null,null,null,"07:00:00",null,null,{"$f":"IF(D33=\"\",\"\",IF((E33-MAX(D33,(6/24))+(D33>E33))<0,0,(IF(E33<D33,IF(E33>6/24,6/24,E33),E33)-MAX(D33,(6/24)))+(D33>E33))+(6/24)-MIN(E33,(6/24)))","v":0.33333333333333337},{"$f":"IF(E33<D33,IF(E33>6/24,E33-6/24,\"\"),\"\")","v":0.20833333333333331},null,null,{"$f":"IF(F33=\"\",\"\",IF(F33<>0,IF(C33<>\"\",IF(R33+S33=0,Satser!B$23,((R33+S33)*24)*(24/1440)+Satser!B$23),IF(R33+S33=0,\"\",((R33+S33)*24)*(24/1440))),\"\"))","v":"05:12:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2010-09-26","Sø","","23:59:00","13:00:00",0.54236111111111107,null,null,null,null,"00:00:00",null,null,null,"06:01:00",null,null,{"$f":"IF(D34=\"\",\"\",IF(D34<6/24,IF(E34<6/24,6/24-D34-(6/24-E34),6/24-D34),\"00:00\"))","v":"00:00"},{"$f":"IF(D34=\"\",\"\",IF((E34-MAX(D34,(6/24))+(D34>E34))<0,0,(IF(E34<D34,IF(E34>6/24,6/24,E34),E34)-MAX(D34,(6/24)))+(D34>E34))+(6/24)-MIN(E34,(6/24)))","v":0.25069444444444444},null,null,{"$f":"IF(F34=\"\",\"\",IF(F34<>0,IF(C34<>\"\",IF(R34+S34=0,Satser!B$23,((R34+S34)*24)*(24/1440)+Satser!B$23),IF(R34+S34=0,\"\",((R34+S34)*24)*(24/1440))),\"\"))","v":"02:24:24"},null,null,null,23,59,"23:59:00",13,0,"13:00:00"]
[null,null,"",null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F35=\"\",\"\",IF(F35<>0,IF(C35<>\"\",IF(R35+S35=0,Satser!B$23,((R35+S35)*24)*(24/1440)+Satser!B$23),IF(R35+S35=0,\"\",((R35+S35)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A34+1","v":"2010-09-27"},{"$f":"PROPER(TEXT(A36,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A36,0,0)","v":""},"00:01:00","13:00:00",0.54097222222222219,null,null,null,null,{"$f":"IF(D36=\"\",\"\",(IF(E36-MAX(D36,(17/24))+(E36<D36)<0,0,E36-MAX(D36,(17/24))+(E36<D36)))-(IF((E36-MAX(D36,(23/24))+(E36<D36))<0,0,(E36-MAX(D36,(23/24))+(E36<D36)))))","v":"00:00:00"},null,null,null,{"$f":"IF(F36=\"\",\"\",IF((E36-MAX(D36,(23/24))+(D36>E36))<0,0,(IF(E36<D36,IF(E36>6/24,6/24,E36),E36)-MAX(D36,(23/24)))+(D36>E36))+(6/24)-MIN(D36,(6/24)))","v":"05:59:00"},null,null,null,{"$f":"IF(D36=\"\",\"\",IF(D36<6/24,6/24-D36,\"\"))","v":"05:59:00"},null,null,{"$f":"IF(F36=\"\",\"\",IF(F36<>0,IF(C36<>\"\",IF(R36+S36=0,Satser!B$23,((R36+S36)*24)*(24/1440)+Satser!B$23),IF(R36+S36=0,\"\",((R36+S36)*24)*(24/1440))),\"\"))","v":"02:23:36"},null,null,null,0,1,"00:01:00",13,0,"13:00:00"]
[{"$f":"A36+1","v":"2010-09-28"},{"$f":"PROPER(TEXT(A37,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A37,0,0)","v":""},"23:00:00","05:00:00",0.25,null,null,null,null,"00:00:00",null,null,null,"06:00:00",null,null,null,null,null,null,{"$f":"IF(F37=\"\",\"\",IF(F37<>0,IF(C37<>\"\",IF(R37+S37=0,Satser!B$23,((R37+S37)*24)*(24/1440)+Satser!B$23),IF(R37+S37=0,\"\",((R37+S37)*24)*(24/1440))),\"\"))","v":""},null,null,null,23,0,"23:00:00",5,0,"05:00:00"]
[{"$f":"A37+1","v":"2010-09-29"},{"$f":"PROPER(TEXT(A38,\"ddd\"))","v":"On"},"","15:00:00","07:00:00",0.66666666666666674,null,null,null,null,"06:00:00",null,null,null,"07:00:00",null,null,null,null,null,null,{"$f":"IF(F38=\"\",\"\",IF(F38<>0,IF(C38<>\"\",IF(R38+S38=0,Satser!B$23,((R38+S38)*24)*(24/1440)+Satser!B$23),IF(R38+S38=0,\"\",((R38+S38)*24)*(24/1440))),\"\"))","v":""},null,null,null,15,0,"15:00:00",7,0,"07:00:00"]
["2010-09-30","To","",null,null,"",null,null,null,null,"",null,null,null,"",null,null,null,null,null,null,{"$f":"IF(F39=\"\",\"\",IF(F39<>0,IF(C39<>\"\",IF(R39+S39=0,Satser!B$23,((R39+S39)*24)*(24/1440)+Satser!B$23),IF(R39+S39=0,\"\",((R39+S39)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2010-10-01","Fr","","22:00:00","11:00:00",0.54166666666666674,null,null,null,null,"01:00:00",null,null,null,"07:00:00",null,null,{"$f":"IF(E40<D40,IF(E40>6/24,E40-6/24,\"\"),\"\")","v":0.20833333333333331},null,null,null,{"$f":"IF(F40=\"\",\"\",IF(F40<>0,IF(C40<>\"\",IF(R40+S40=0,Satser!B$23,((R40+S40)*24)*(24/1440)+Satser!B$23),IF(R40+S40=0,\"\",((R40+S40)*24)*(24/1440))),\"\"))","v":"02:00:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2010-10-02","Lø","","22:00:00","11:00:00",0.54166666666666674,null,null,null,null,"01:00:00",null,null,null,"07:00:00",null,null,{"$f":"IF(D41=\"\",\"\",IF((E41-MAX(D41,(6/24))+(D41>E41))<0,0,(IF(E41<D41,IF(E41>6/24,6/24,E41),E41)-MAX(D41,(6/24)))+(D41>E41))+(6/24)-MIN(E41,(6/24)))","v":0.33333333333333337},{"$f":"IF(E41<D41,IF(E41>6/24,E41-6/24,\"\"),\"\")","v":0.20833333333333331},null,null,{"$f":"IF(F41=\"\",\"\",IF(F41<>0,IF(C41<>\"\",IF(R41+S41=0,Satser!B$23,((R41+S41)*24)*(24/1440)+Satser!B$23),IF(R41+S41=0,\"\",((R41+S41)*24)*(24/1440))),\"\"))","v":"05:12:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2010-10-03","Sø","","23:59:00","13:00:00",0.54236111111111107,null,null,null,null,"00:00:00",null,null,null,"06:01:00",null,null,{"$f":"IF(D42=\"\",\"\",IF(D42<6/24,IF(E42<6/24,6/24-D42-(6/24-E42),6/24-D42),\"00:00\"))","v":"00:00"},{"$f":"IF(D42=\"\",\"\",IF((E42-MAX(D42,(6/24))+(D42>E42))<0,0,(IF(E42<D42,IF(E42>6/24,6/24,E42),E42)-MAX(D42,(6/24)))+(D42>E42))+(6/24)-MIN(E42,(6/24)))","v":0.25069444444444444},null,null,{"$f":"IF(F42=\"\",\"\",IF(F42<>0,IF(C42<>\"\",IF(R42+S42=0,Satser!B$23,((R42+S42)*24)*(24/1440)+Satser!B$23),IF(R42+S42=0,\"\",((R42+S42)*24)*(24/1440))),\"\"))","v":"02:24:24"},null,null,null,23,59,"23:59:00",13,0,"13:00:00"]
["Total timer",null,null,null,null,{"$f":"IF(SUM(F17:F42)<>\"0\",SUM(F12:F42),\"\")","v":8.1055555555555578},{"$f":"IF(SUM(G12:G42)<>\"0\",SUM(G12:G42),\"\")","v":8.3333333333333329E-2},{"$f":"IF(SUM(H12:H42)<>\"0\",SUM(H12:H42),\"\")","v":1.2916666666666665},null,null,{"$f":"IF(SUM(K12:K42)<>\"0\",SUM(K12:K42),\"\")","v":0.95902777777777815},null,null,null,{"$f":"IF(SUM(O12:O42)<>\"0\",SUM(O12:O42),\"\")","v":3.9381944444444446},null,null,1.625,1.6263888888888887,null,null,{"$f":"SUM(V12:V42)","v":4.3495833333333351},{"$f":"SUM(W12:W42)","v":0}]
["Timer 1/100",null,null,null,null,{"$f":"IF(F43<>\"\",ROUND(F43*24,2),\"\")","v":194.53},{"$f":"IF(G43<>\"\",ROUND(G43*24,2),\"\")","v":2},31,null,null,{"$f":"IF(K43<>\"\",ROUND(K43*24,2),\"\")","v":23.02},null,null,null,{"$f":"IF(O43<>\"\",ROUND(O43*24,2),\"\")","v":94.52},null,null,39,39.03,null,null,104.39,0]
["Satser",null,null,null,null,{"$f":"Satser!B7","v":125.76},{"$f":"Satser!B9","v":59.81},{"$f":"Satser!B12","v":119.62},null,null,18.8,null,null,null,21.81,null,null,28.68,67]
[null,null,null,null,null,{"$f":"IF(F43<>\"\",F44*F45,\"\")","v":24464.092800000002},{"$f":"IF(G43<>\"\",G44*G45,\"\")","v":119.62},3708.2200000000003,null,null,{"$f":"IF(K43<>\"\",K44*K45,\"\")","v":432.77600000000001},null,null,null,{"$f":"IF(O43<>\"\",O44*O45,\"\")","v":2061.4811999999997},null,null,1118.52,{"$f":"IF(S43<>\"\",S43*S45,\"\")","v":108.96805555555554}]
[]
["Lønart"]
[3025,null,null,null,null,{"$f":"F43","v":8.1055555555555578}]
[3425,null,null,null,null,{"$f":"G43","v":8.3333333333333329E-2}]
[3428,null,null,null,null,{"$f":"H43","v":1.2916666666666665}]
["Timer",null,null,null,null,{"$f":"SUM(F49:F51)","v":9.4805555555555578},{"$f":"IF(F52<>\"\",ROUND(F52*24,2),\"\")","v":227.53}]
[null,null,null,null,null,null,{"$f":"F45*G52","v":28614.1728}]

{"sheet":"oktober2010","index":2,"n_rows":51,"n_cols":28,"rows_kept":51,"cut":false,"hidden":true,"merged":[[45,0,45,2],[46,0,46,2],[47,0,47,2],[48,0,48,2],[49,0,49,2],[41,8,41,9],[41,10,41,11],[42,8,42,9],[42,10,42,11],[43,8,43,9],[43,10,43,11],[38,8,38,9],[38,10,38,11],[39,8,39,9],[39,10,39,11],[40,8,40,9],[40,10,40,11],[35,8,35,9],[35,10,35,11],[36,8,36,9],[36,10,36,11],[37,8,37,9],[37,10,37,11],[32,8,32,9],[32,10,32,11],[33,8,33,9],[33,10,33,11],[34,8,34,9],[34,10,34,11],[29,8,29,9],[29,10,29,11],[30,8,30,9],[30,10,30,11],[31,8,31,9],[31,10,31,11],[26,8,26,9],[26,10,26,11],[27,8,27,9],[27,10,27,11],[28,8,28,9],[28,10,28,11],[23,8,23,9],[23,10,23,11],[24,8,24,9],[24,10,24,11],[25,8,25,9],[25,10,25,11],[20,8,20,9],[20,10,20,11],[21,8,21,9],[21,10,21,11],[22,8,22,9],[22,10,22,11],[17,8,17,9],[17,10,17,11],[18,8,18,9],[18,10,18,11],[19,8,19,9],[19,10,19,11],[14,8,14,9],[14,10,14,11],[15,8,15,9],[15,10,15,11],[16,8,16,9],[16,10,16,11],[11,8,11,9],[11,10,11,11],[12,8,12,9],[12,10,12,11],[13,8,13,9],[13,10,13,11],[10,8,10,9],[10,10,10,11],[6,1,6,6],[6,9,6,10],[6,18,6,19],[7,1,7,2],[7,8,7,9],[7,10,7,11],[8,1,8,2],[8,8,8,9],[8,10,8,11],[9,8,9,9],[9,10,9,11]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aften tillæg","Fra kl.","18:00:00","Til kl.","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nat tillæg","Fra kl.","00:00:00","Til kl.","06:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lørdag","Fra kl.","14:00:00","Til kl.","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundlovsdag","Fra kl.","12:00:00","Til kl.","00:00:00"]
[]
["Løn",{"$f":"PROPER(TEXT(A10,\"dd mmmm åååå\")) & PROPER(TEXT(A40,\"  -  dd mmmm åååå\"))","v":"05 December 2011  -  01 Januar 2012"},null,null,null,null,null,"Uge :",{"$f":"IF(A10=\"\",\"\",TRUNC((A10-WEEKDAY(A10,2)-DATE(YEAR(A10+4-WEEKDAY(A10,2)),1,-10))/7))","v":49},"-",null,{"$f":"IF(A34=\"\",\"\",TRUNC((A34-WEEKDAY(A34,2)-DATE(YEAR(A34+4-WEEKDAY(A34,2)),1,-10))/7))","v":52},null,null,null,null,null,null,"Time beregning:"]
["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","Time SID","Overtid           1-3 time","Overtid            4 - time","Aftenstillæg alle dage        17-23",null,"Nattillæg     23-06",null,"Lørdag tillæg 06 - 06","Søndag tillæg 06-06","Optjent afspadsering","Afholdt afspadsering"]
["2011-12-05",{"$f":"PROPER(TEXT(A10,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A10,0,0)","v":""},"00:01:00","13:00:00",{"$f":"IF(D10=\"\",\"\",(E10-D10)+(D10>E10))","v":0.54097222222222219},null,null,{"$f":"IF(D10=\"\",\"\",(IF(E10-MAX(D10,(17/24))+(E10<D10)<0,0,E10-MAX(D10,(17/24))+(E10<D10)))-(IF((E10-MAX(D10,(23/24))+(E10<D10))<0,0,(E10-MAX(D10,(23/24))+(E10<D10)))))","v":"00:00:00"},null,{"$f":"IF(F10=\"\",\"\",IF((E10-MAX(D10,(23/24))+(D10>E10))<0,0,(IF(E10<D10,IF(E10>6/24,6/24,E10),E10)-MAX(D10,(23/24)))+(D10>E10))+(6/24)-MIN(D10,(6/24)))","v":"05:59:00"},null,null,{"$f":"IF(D10=\"\",\"\",IF(D10<6/24,6/24-D10,\"\"))","v":"05:59:00"},{"$f":"IF(F10=\"\",\"\",IF(F10<>0,IF(C10<>\"\",IF(M10+N10=0,Satser!B$23,((M10+N10)*24)*(24/1440)+Satser!B$23),IF(M10+N10=0,\"\",((M10+N10)*24)*(24/1440))),\"\"))","v":"02:23:36"},null,null,null,{"$f":"IF(D10=\"\",\"\",HOUR(D10))","v":0},{"$f":"IF(D10=\"\",\"\",MINUTE(D10))","v":1},{"$f":"IF(D10=\"\",\"\",TIME(HOUR(D10),MINUTE(D10),0))","v":"00:01:00"},{"$f":"IF(E10=\"\",\"\",HOUR(E10))","v":13},{"$f":"IF(E10=\"\",\"\",MINUTE(E10))","v":0},{"$f":"IF(E10=\"\",\"\",TIME(HOUR(E10),MINUTE(E10),0))","v":"13:00:00"}]
[{"$f":"A10+1","v":"2011-12-06"},{"$f":"PROPER(TEXT(A11,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A11,0,0)","v":""},"23:00:00","05:00:00",0.25,null,null,"00:00:00",null,{"$f":"IF(F11=\"\",\"\",IF((E11-MAX(D11,(23/24))+(D11>E11))<0,0,(IF(E11<D11,IF(E11>6/24,6/24,E11),E11)-MAX(D11,(23/24)))+(D11>E11))+(6/24)-MIN(D11,(6/24)))","v":"06:00:00"},null,null,null,{"$f":"IF(F11=\"\",\"\",IF(F11<>0,IF(C11<>\"\",IF(M11+N11=0,Satser!B$23,((M11+N11)*24)*(24/1440)+Satser!B$23),IF(M11+N11=0,\"\",((M11+N11)*24)*(24/1440))),\"\"))","v":""},null,null,null,23,0,"23:00:00",5,0,"05:00:00"]
[{"$f":"A11+1","v":"2011-12-07"},{"$f":"PROPER(TEXT(A12,\"ddd\"))","v":"On"},"","15:00:00","07:00:00",0.66666666666666674,null,null,"06:00:00",null,{"$f":"IF(F12=\"\",\"\",IF((E12-MAX(D12,(23/24))+(D12>E12))<0,0,(IF(E12<D12,IF(E12>6/24,6/24,E12),E12)-MAX(D12,(23/24)))+(D12>E12))+(6/24)-MIN(D12,(6/24)))","v":"07:00:00"},null,null,null,{"$f":"IF(F12=\"\",\"\",IF(F12<>0,IF(C12<>\"\",IF(M12+N12=0,Satser!B$23,((M12+N12)*24)*(24/1440)+Satser!B$23),IF(M12+N12=0,\"\",((M12+N12)*24)*(24/1440))),\"\"))","v":""},null,null,null,15,0,"15:00:00",7,0,"07:00:00"]
["2011-12-08","To","",null,null,"",null,null,"",null,"",null,null,null,{"$f":"IF(F13=\"\",\"\",IF(F13<>0,IF(C13<>\"\",IF(M13+N13=0,Satser!B$23,((M13+N13)*24)*(24/1440)+Satser!B$23),IF(M13+N13=0,\"\",((M13+N13)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-09","Fr","","22:00:00","11:00:00",0.54166666666666674,null,null,"01:00:00",null,"07:00:00",null,{"$f":"IF(E14<D14,IF(E14>6/24,E14-6/24,\"\"),\"\")","v":0.20833333333333331},null,{"$f":"IF(F14=\"\",\"\",IF(F14<>0,IF(C14<>\"\",IF(M14+N14=0,Satser!B$23,((M14+N14)*24)*(24/1440)+Satser!B$23),IF(M14+N14=0,\"\",((M14+N14)*24)*(24/1440))),\"\"))","v":"02:00:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2011-12-10","Lø","","22:00:00","11:00:00",0.54166666666666674,null,null,"01:00:00",null,"07:00:00",null,{"$f":"IF(D15=\"\",\"\",IF((E15-MAX(D15,(6/24))+(D15>E15))<0,0,(IF(E15<D15,IF(E15>6/24,6/24,E15),E15)-MAX(D15,(6/24)))+(D15>E15))+(6/24)-MIN(E15,(6/24)))","v":0.33333333333333337},{"$f":"IF(E15<D15,IF(E15>6/24,E15-6/24,\"\"),\"\")","v":0.20833333333333331},{"$f":"IF(F15=\"\",\"\",IF(F15<>0,IF(C15<>\"\",IF(M15+N15=0,Satser!B$23,((M15+N15)*24)*(24/1440)+Satser!B$23),IF(M15+N15=0,\"\",((M15+N15)*24)*(24/1440))),\"\"))","v":"05:12:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2011-12-11","Sø","","23:59:00","13:00:00",0.54236111111111107,null,null,"00:00:00",null,"06:01:00",null,{"$f":"IF(D16=\"\",\"\",IF(D16<6/24,IF(E16<6/24,6/24-D16-(6/24-E16),6/24-D16),\"00:00\"))","v":"00:00"},{"$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":0.25069444444444444},{"$f":"IF(F16=\"\",\"\",IF(F16<>0,IF(C16<>\"\",IF(M16+N16=0,Satser!B$23,((M16+N16)*24)*(24/1440)+Satser!B$23),IF(M16+N16=0,\"\",((M16+N16)*24)*(24/1440))),\"\"))","v":"02:24:24"},null,null,null,23,59,"23:59:00",13,0,"13:00:00"]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F17=\"\",\"\",IF(F17<>0,IF(C17<>\"\",IF(M17+N17=0,Satser!B$23,((M17+N17)*24)*(24/1440)+Satser!B$23),IF(M17+N17=0,\"\",((M17+N17)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A16+1","v":"2011-12-12"},{"$f":"PROPER(TEXT(A18,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A18,0,0)","v":""},null,null,{"$f":"IF(D18=\"\",\"\",(E18-D18)+(D18>E18))","v":""},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,"",null,null,{"$f":"IF(D18=\"\",\"\",IF(D18<6/24,6/24-D18,\"\"))","v":""},{"$f":"IF(F18=\"\",\"\",IF(F18<>0,IF(C18<>\"\",IF(M18+N18=0,Satser!B$23,((M18+N18)*24)*(24/1440)+Satser!B$23),IF(M18+N18=0,\"\",((M18+N18)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A18+1","v":"2011-12-13"},{"$f":"PROPER(TEXT(A19,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A19,0,0)","v":""},null,null,{"$f":"IF(D19=\"\",\"\",(E19-D19)+(D19>E19))","v":""},null,null,"",null,"",null,null,null,{"$f":"IF(F19=\"\",\"\",IF(F19<>0,IF(C19<>\"\",IF(M19+N19=0,Satser!B$23,((M19+N19)*24)*(24/1440)+Satser!B$23),IF(M19+N19=0,\"\",((M19+N19)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A19+1","v":"2011-12-14"},{"$f":"PROPER(TEXT(A20,\"ddd\"))","v":"On"},"",null,null,"",null,null,"",null,"",null,null,null,{"$f":"IF(F20=\"\",\"\",IF(F20<>0,IF(C20<>\"\",IF(M20+N20=0,Satser!B$23,((M20+N20)*24)*(24/1440)+Satser!B$23),IF(M20+N20=0,\"\",((M20+N20)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-15","To","",null,null,"",null,null,"",null,"",null,null,null,{"$f":"IF(F21=\"\",\"\",IF(F21<>0,IF(C21<>\"\",IF(M21+N21=0,Satser!B$23,((M21+N21)*24)*(24/1440)+Satser!B$23),IF(M21+N21=0,\"\",((M21+N21)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-16","Fr","",null,null,"",null,null,"",null,"",null,{"$f":"IF(D22=\"\",\"\",IF(E22<D22,IF(E22>6/24,E22-6/24,\"\"),\"\"))","v":""},null,{"$f":"IF(F22=\"\",\"\",IF(F22<>0,IF(C22<>\"\",IF(M22+N22=0,Satser!B$23,((M22+N22)*24)*(24/1440)+Satser!B$23),IF(M22+N22=0,\"\",((M22+N22)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-17","Lø","",null,null,"",null,null,"",null,"",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(M23+N23=0,Satser!B$23,((M23+N23)*24)*(24/1440)+Satser!B$23),IF(M23+N23=0,\"\",((M23+N23)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-18","Sø","",null,null,"",null,null,"",null,"",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(M24+N24=0,Satser!B$23,((M24+N24)*24)*(24/1440)+Satser!B$23),IF(M24+N24=0,\"\",((M24+N24)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F25=\"\",\"\",IF(F25<>0,IF(C25<>\"\",IF(M25+N25=0,Satser!B$23,((M25+N25)*24)*(24/1440)+Satser!B$23),IF(M25+N25=0,\"\",((M25+N25)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A24+1","v":"2011-12-19"},{"$f":"PROPER(TEXT(A26,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A26,0,0)","v":""},null,null,"",null,null,{"$f":"IF(D26=\"\",\"\",(IF(E26-MAX(D26,(17/24))+(E26<D26)<0,0,E26-MAX(D26,(17/24))+(E26<D26)))-(IF((E26-MAX(D26,(23/24))+(E26<D26))<0,0,(E26-MAX(D26,(23/24))+(E26<D26)))))","v":""},null,{"$f":"IF(F26=\"\",\"\",IF((E26-MAX(D26,(23/24))+(D26>E26))<0,0,(IF(E26<D26,IF(E26>6/24,6/24,E26),E26)-MAX(D26,(23/24)))+(D26>E26))+(6/24)-MIN(D26,(6/24)))","v":""},null,null,{"$f":"IF(D26=\"\",\"\",IF(D26<6/24,6/24-D26,\"\"))","v":""},{"$f":"IF(F26=\"\",\"\",IF(F26<>0,IF(C26<>\"\",IF(M26+N26=0,Satser!B$23,((M26+N26)*24)*(24/1440)+Satser!B$23),IF(M26+N26=0,\"\",((M26+N26)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A26+1","v":"2011-12-20"},{"$f":"PROPER(TEXT(A27,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A27,0,0)","v":""},null,null,"",null,null,"",null,"",null,null,null,{"$f":"IF(F27=\"\",\"\",IF(F27<>0,IF(C27<>\"\",IF(M27+N27=0,Satser!B$23,((M27+N27)*24)*(24/1440)+Satser!B$23),IF(M27+N27=0,\"\",((M27+N27)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A27+1","v":"2011-12-21"},{"$f":"PROPER(TEXT(A28,\"ddd\"))","v":"On"},"",null,null,"",null,null,"",null,"",null,null,null,{"$f":"IF(F28=\"\",\"\",IF(F28<>0,IF(C28<>\"\",IF(M28+N28=0,Satser!B$23,((M28+N28)*24)*(24/1440)+Satser!B$23),IF(M28+N28=0,\"\",((M28+N28)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-22","To","",null,null,"",null,null,"",null,"",null,null,null,{"$f":"IF(F29=\"\",\"\",IF(F29<>0,IF(C29<>\"\",IF(M29+N29=0,Satser!B$23,((M29+N29)*24)*(24/1440)+Satser!B$23),IF(M29+N29=0,\"\",((M29+N29)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-23","Fr","","22:00:00","11:00:00",0.54166666666666674,null,null,"01:00:00",null,"07:00:00",null,{"$f":"IF(E30<D30,IF(E30>6/24,E30-6/24,\"\"),\"\")","v":0.20833333333333331},null,{"$f":"IF(F30=\"\",\"\",IF(F30<>0,IF(C30<>\"\",IF(M30+N30=0,Satser!B$23,((M30+N30)*24)*(24/1440)+Satser!B$23),IF(M30+N30=0,\"\",((M30+N30)*24)*(24/1440))),\"\"))","v":"02:00:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2011-12-24","Lø","Julaftensdag","22:00:00","11:00:00",0.54166666666666674,null,null,"01:00:00",null,"07:00:00",null,{"$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":0.33333333333333337},{"$f":"IF(E31<D31,IF(E31>6/24,E31-6/24,\"\"),\"\")","v":0.20833333333333331},{"$f":"IF(F31=\"\",\"\",IF(F31<>0,IF(C31<>\"\",IF(M31+N31=0,Satser!B$23,((M31+N31)*24)*(24/1440)+Satser!B$23),IF(M31+N31=0,\"\",((M31+N31)*24)*(24/1440))),\"\"))","v":"12:57:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2011-12-25","Sø","1. Juledag","23:59:00","13:00:00",0.54236111111111107,null,null,"00:00:00",null,"06:01:00",null,{"$f":"IF(D32=\"\",\"\",IF(D32<6/24,IF(E32<6/24,6/24-D32-(6/24-E32),6/24-D32),\"00:00\"))","v":"00:00"},{"$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":0.25069444444444444},{"$f":"IF(F32=\"\",\"\",IF(F32<>0,IF(C32<>\"\",IF(M32+N32=0,Satser!B$23,((M32+N32)*24)*(24/1440)+Satser!B$23),IF(M32+N32=0,\"\",((M32+N32)*24)*(24/1440))),\"\"))","v":"10:09:24"},null,null,null,23,59,"23:59:00",13,0,"13:00:00"]
[null,null,"",null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(F33=\"\",\"\",IF(F33<>0,IF(C33<>\"\",IF(M33+N33=0,Satser!B$23,((M33+N33)*24)*(24/1440)+Satser!B$23),IF(M33+N33=0,\"\",((M33+N33)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
[{"$f":"A32+1","v":"2011-12-26"},{"$f":"PROPER(TEXT(A34,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A34,0,0)","v":"2. Juledag"},"00:01:00","13:00:00",0.54097222222222219,null,null,{"$f":"IF(D34=\"\",\"\",(IF(E34-MAX(D34,(17/24))+(E34<D34)<0,0,E34-MAX(D34,(17/24))+(E34<D34)))-(IF((E34-MAX(D34,(23/24))+(E34<D34))<0,0,(E34-MAX(D34,(23/24))+(E34<D34)))))","v":"00:00:00"},null,{"$f":"IF(F34=\"\",\"\",IF((E34-MAX(D34,(23/24))+(D34>E34))<0,0,(IF(E34<D34,IF(E34>6/24,6/24,E34),E34)-MAX(D34,(23/24)))+(D34>E34))+(6/24)-MIN(D34,(6/24)))","v":"05:59:00"},null,null,{"$f":"IF(D34=\"\",\"\",IF(D34<6/24,6/24-D34,\"\"))","v":"05:59:00"},{"$f":"IF(F34=\"\",\"\",IF(F34<>0,IF(C34<>\"\",IF(M34+N34=0,Satser!B$23,((M34+N34)*24)*(24/1440)+Satser!B$23),IF(M34+N34=0,\"\",((M34+N34)*24)*(24/1440))),\"\"))","v":"10:08:36"},null,null,null,0,1,"00:01:00",13,0,"13:00:00"]
[{"$f":"A34+1","v":"2011-12-27"},{"$f":"PROPER(TEXT(A35,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A35,0,0)","v":""},"23:00:00","05:00:00",0.25,null,null,"00:00:00",null,"06:00:00",null,null,null,{"$f":"IF(F35=\"\",\"\",IF(F35<>0,IF(C35<>\"\",IF(M35+N35=0,Satser!B$23,((M35+N35)*24)*(24/1440)+Satser!B$23),IF(M35+N35=0,\"\",((M35+N35)*24)*(24/1440))),\"\"))","v":""},null,null,null,23,0,"23:00:00",5,0,"05:00:00"]
[{"$f":"A35+1","v":"2011-12-28"},{"$f":"PROPER(TEXT(A36,\"ddd\"))","v":"On"},"","15:00:00","07:00:00",0.66666666666666674,null,null,"06:00:00",null,"07:00:00",null,null,null,{"$f":"IF(F36=\"\",\"\",IF(F36<>0,IF(C36<>\"\",IF(M36+N36=0,Satser!B$23,((M36+N36)*24)*(24/1440)+Satser!B$23),IF(M36+N36=0,\"\",((M36+N36)*24)*(24/1440))),\"\"))","v":""},null,null,null,15,0,"15:00:00",7,0,"07:00:00"]
["2011-12-29","To","",null,null,"",null,null,"",null,"",null,null,null,{"$f":"IF(F37=\"\",\"\",IF(F37<>0,IF(C37<>\"\",IF(M37+N37=0,Satser!B$23,((M37+N37)*24)*(24/1440)+Satser!B$23),IF(M37+N37=0,\"\",((M37+N37)*24)*(24/1440))),\"\"))","v":""},null,null,null,"","","","","",""]
["2011-12-30","Fr","","22:00:00","11:00:00",0.54166666666666674,null,null,"01:00:00",null,"07:00:00",null,{"$f":"IF(E38<D38,IF(E38>6/24,E38-6/24,\"\"),\"\")","v":0.20833333333333331},null,{"$f":"IF(F38=\"\",\"\",IF(F38<>0,IF(C38<>\"\",IF(M38+N38=0,Satser!B$23,((M38+N38)*24)*(24/1440)+Satser!B$23),IF(M38+N38=0,\"\",((M38+N38)*24)*(24/1440))),\"\"))","v":"02:00:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2011-12-31","Lø","Nytårsaftensdag","22:00:00","11:00:00",0.54166666666666674,null,null,"01:00:00",null,"07:00:00",null,{"$f":"IF(D39=\"\",\"\",IF((E39-MAX(D39,(6/24))+(D39>E39))<0,0,(IF(E39<D39,IF(E39>6/24,6/24,E39),E39)-MAX(D39,(6/24)))+(D39>E39))+(6/24)-MIN(E39,(6/24)))","v":0.33333333333333337},{"$f":"IF(E39<D39,IF(E39>6/24,E39-6/24,\"\"),\"\")","v":0.20833333333333331},{"$f":"IF(F39=\"\",\"\",IF(F39<>0,IF(C39<>\"\",IF(M39+N39=0,Satser!B$23,((M39+N39)*24)*(24/1440)+Satser!B$23),IF(M39+N39=0,\"\",((M39+N39)*24)*(24/1440))),\"\"))","v":"12:57:00"},null,null,null,22,0,"22:00:00",11,0,"11:00:00"]
["2012-01-01","Sø","Nytårsdag","23:59:00","13:00:00",0.54236111111111107,null,null,"00:00:00",null,"06:01:00",null,{"$f":"IF(D40=\"\",\"\",IF(D40<6/24,IF(E40<6/24,6/24-D40-(6/24-E40),6/24-D40),\"00:00\"))","v":"00:00"},{"$f":"IF(D40=\"\",\"\",IF((E40-MAX(D40,(6/24))+(D40>E40))<0,0,(IF(E40<D40,IF(E40>6/24,6/24,E40),E40)-MAX(D40,(6/24)))+(D40>E40))+(6/24)-MIN(E40,(6/24)))","v":0.25069444444444444},{"$f":"IF(F40=\"\",\"\",IF(F40<>0,IF(C40<>\"\",IF(M40+N40=0,Satser!B$23,((M40+N40)*24)*(24/1440)+Satser!B$23),IF(M40+N40=0,\"\",((M40+N40)*24)*(24/1440))),\"\"))","v":"10:09:24"},null,null,null,23,59,"23:59:00",13,0,"13:00:00"]
["Total timer",null,null,null,null,{"$f":"IF(SUM(F15:F40)<>\"0\",SUM(F10:F40),\"\")","v":7.792361111111112},{"$f":"IF(SUM(G10:G40)<>\"0\",SUM(G10:G40),\"\")","v":0},0,{"$f":"IF(SUM(I10:I40)<>\"0\",SUM(I10:I40),\"\")","v":0.75000000000000044},null,{"$f":"IF(SUM(K10:K40)<>\"0\",SUM(K10:K40),\"\")","v":4.0840277777777771},null,1.625,1.8756944444444441,{"$f":"SUM(O10:O40)","v":3.0148611111111112},{"$f":"SUM(P10:P40)","v":0}]
["Timer 1/100",null,null,null,null,{"$f":"IF(F41<>\"\",ROUND(F41*24,2),\"\")","v":187.02},{"$f":"IF(G41<>\"\",ROUND(G41*24,2),\"\")","v":0},0,{"$f":"IF(I41<>\"\",ROUND(I41*24,2),\"\")","v":18},null,{"$f":"IF(K41<>\"\",ROUND(K41*24,2),\"\")","v":98.02},null,39,45.02,72.36,0]
["Satser",null,null,null,null,{"$f":"Satser!B7","v":125.76},{"$f":"Satser!B9","v":59.81},{"$f":"Satser!B12","v":119.62},18.8,null,21.81,null,28.68,67]
[null,null,null,null,null,{"$f":"IF(F41<>\"\",F42*F43,\"\")","v":23519.635200000001},{"$f":"IF(G41<>\"\",G42*G43,\"\")","v":0},0,{"$f":"IF(I41<>\"\",I42*I43,\"\")","v":338.40000000000003},null,{"$f":"IF(K41<>\"\",K42*K43,\"\")","v":2137.8161999999998},null,1118.52,{"$f":"IF(N41<>\"\",N41*N43,\"\")","v":125.67152777777775}]
[]
["Lønart"]
[3025,null,null,null,null,{"$f":"F41","v":7.792361111111112}]
[3425,null,null,null,null,{"$f":"G41","v":0}]
[3428,null,null,null,null,{"$f":"H41","v":0}]
["Timer",null,null,null,null,{"$f":"SUM(F47:F49)","v":7.792361111111112},{"$f":"IF(F50<>\"\",ROUND(F50*24,2),\"\")","v":187.02}]
[null,null,null,null,null,null,{"$f":"F43*G50","v":23519.635200000001}]

{"sheet":"Tomt","index":3,"n_rows":51,"n_cols":26,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,16,6,18],[47,0,47,3],[48,0,48,3],[49,0,49,3],[6,1,6,5],[7,1,7,2],[8,1,8,2],[45,0,45,3],[46,0,46,3]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aften tillæg","Fra kl.","18:00:00","Til kl.","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nat tillæg","Fra kl.","00:00:00","Til kl.","06:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lørdag","Fra kl.","14:00:00","Til kl.","00:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grundlovsdag","Fra kl.","12:00:00","Til kl.","00:00:00"]
[]
["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"]
["2013-04-01",{"$f":"PROPER(TEXT(A10,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A10,0,0)","v":"2. Påskedag"},701,{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D10,Timeberegning!A$4:B$153,2)))","v":"04:36:00"},{"$f":"IF($D10=\"\",\"\",IF(VLOOKUP($D10,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D10,Timeberegning!A$4:C$153,3)))","v":"12:24:00"},{"$f":"IF($D10=\"\",\"\",VLOOKUP($D10,Timeberegning!$A$4:$O$10,13))","v":"06:56:00"},null,null,{"$f":"IF(E10<>\"\",IF(WEEKDAY(A10,2)<>6,IF(E10>F10,(F10-MAX(E10,(18/24))+(E10>F10))-F10,IF(F10>Y$8,(F10-MAX(E10,(18/24))),\"\")),IF(E10>F10,(F10-MAX(E10,(14/24))+(E10>F10))-F10,IF(F10>Z$8,(F10-MAX(E10,(14/24))),\"\"))),\"\")","v":""},{"$f":"IF(G10<>\"\",IF(S10<X$8,(X$8-S10),IF(V10<X$8,(V10-W$8),\"\")),\"\")","v":"01:24:00"},{"$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(SUM(H10:I10)=0,\"\",SUM(H10:I10))","v":""},null,null,{"$f":"IF(E10=\"\",\"\",HOUR(E10))","v":4},{"$f":"IF(E10=\"\",\"\",MINUTE(E10))","v":36},{"$f":"IF(E10=\"\",\"\",TIME(HOUR(E10),MINUTE(E10),0))","v":"04:36:00"},{"$f":"IF(F10=\"\",\"\",HOUR(F10))","v":12},{"$f":"IF(F10=\"\",\"\",MINUTE(F10))","v":24},{"$f":"TIME(HOUR(F10),MINUTE(F10),0)","v":"12:24:00"}]
["2013-04-02",{"$f":"PROPER(TEXT(A11,\"ddd\"))","v":"Ti"},{"$f":"HelligdagsNavn(A11,0,0)","v":""},111,{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D11,Timeberegning!A$4:B$153,2)))","v":"05:54:00"},{"$f":"IF($D11=\"\",\"\",IF(VLOOKUP($D11,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D11,Timeberegning!A$4:C$153,3)))","v":"14:57:00"},{"$f":"IF($D11=\"\",\"\",VLOOKUP($D11,Timeberegning!$A$4:$O$10,13))","v":"08:54:00"},null,null,{"$f":"IF(E11<>\"\",IF(WEEKDAY(A11,2)<>6,IF(E11>F11,(F11-MAX(E11,(18/24))+(E11>F11))-F11,IF(F11>Y$8,(F11-MAX(E11,(18/24))),\"\")),IF(E11>F11,(F11-MAX(E11,(14/24))+(E11>F11))-F11,IF(F11>Z$8,(F11-MAX(E11,(14/24))),\"\"))),\"\")","v":""},"00:06: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(SUM(H11:I11)=0,\"\",SUM(H11:I11))","v":""},null,null,5,54,"05:54:00",14,57,{"$f":"TIME(HOUR(F11),MINUTE(F11),0)","v":"14:57:00"}]
["2013-04-03",{"$f":"PROPER(TEXT(A12,\"ddd\"))","v":"On"},"",112,{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D12,Timeberegning!A$4:B$153,2)))","v":"10:06:00"},{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D12,Timeberegning!A$4:C$153,3)))","v":"16:38:00"},{"$f":"IF($D12=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$O$10,13))","v":"06:11:00"},null,null,{"$f":"IF(E12<>\"\",IF(WEEKDAY(A12,2)<>6,IF(E12>F12,(F12-MAX(E12,(18/24))+(E12>F12))-F12,IF(F12>Y$8,(F12-MAX(E12,(18/24))),\"\")),IF(E12>F12,(F12-MAX(E12,(14/24))+(E12>F12))-F12,IF(F12>Z$8,(F12-MAX(E12,(14/24))),\"\"))),\"\")","v":""},"","",{"$f":"IF($D12=\"\",\"\",IF(VLOOKUP($D12,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D12,Timeberegning!$A$4:$O$101,15)))","v":""},"",null,null,10,6,"10:06:00",16,38,{"$f":"TIME(HOUR(F12),MINUTE(F12),0)","v":"16:38:00"}]
["2013-04-04","To","",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=\"\",\"\",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,"","","","","",{"$f":"TIME(HOUR(F13),MINUTE(F13),0)","v":{"$error":"#VALUE!"}}]
["2013-04-05","Fr","",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=\"\",\"\",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,"","","","","",{"$f":"TIME(HOUR(F14),MINUTE(F14),0)","v":{"$error":"#VALUE!"}}]
["2013-04-06","Lø","",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=\"\",\"\",VLOOKUP($D15,Timeberegning!$A$4:$O$153,13))","v":""},null,null,"","",{"$f":"IF(G15<>0,IF(WEEKDAY(A15,2)=7,G15,\"\"),\"\")","v":""},{"$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,"","","","","",{"$f":"IF(F15=\"\",\"\",TIME(HOUR(F15),MINUTE(F15),0))","v":""}]
["2013-04-07","Sø","",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(G16<>0,IF(WEEKDAY(A16,2)=7,G16,\"\"),\"\")","v":""},{"$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,"","","","","",""]
["2013-04-08","Ma","",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(G17<>0,IF(WEEKDAY(A17,2)=7,G17,\"\"),\"\")","v":""},{"$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,"","","","","",""]
["2013-04-09","Ti","",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,"","","","","",""]
["2013-04-10","On","",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,"","","","","",""]
["2013-04-11","To","",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,"","","","","",""]
["2013-04-12","Fr","",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,"","","","","",""]
["2013-04-13","Lø","",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,"","","","","",""]
["2013-04-14","Sø","",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,"","","","","",""]
["2013-04-15","Ma","",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,"","","","","",""]
["2013-04-16","Ti","",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,"","","","","",""]
["2013-04-17","On","",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,"","","","","",""]
["2013-04-18","To","",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,"","","","","",""]
["2013-04-19","Fr","",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,"","","","","",""]
["2013-04-20","Lø","",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,"","","","","",""]
["2013-04-21","Sø","",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,"","","","","",""]
["2013-04-22","Ma","",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,"","","","","",""]
["2013-04-23","Ti","",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,"","","","","",""]
["2013-04-24","On","",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,"","","","","",""]
["2013-04-25","To","",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,"","","","","",""]
["2013-04-26","Fr","Store Bededag",null,{"$f":"IF($D35=\"\",\"\",IF(VLOOKUP($D35,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D35,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D35=\"\",\"\",IF(VLOOKUP($D35,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D35,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D35=\"\",\"\",IF(VLOOKUP($D35,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D35,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D35=\"\",\"\",IF(VLOOKUP($D35,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D35,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D35=\"\",\"\",IF(VLOOKUP($D35,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D35,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2013-04-27","Lø","",null,{"$f":"IF($D36=\"\",\"\",IF(VLOOKUP($D36,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D36,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D36=\"\",\"\",IF(VLOOKUP($D36,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D36,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D36=\"\",\"\",IF(VLOOKUP($D36,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D36,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D36=\"\",\"\",IF(VLOOKUP($D36,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D36,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D36=\"\",\"\",IF(VLOOKUP($D36,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D36,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2013-04-28","Sø","",null,{"$f":"IF($D37=\"\",\"\",IF(VLOOKUP($D37,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D37,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D37=\"\",\"\",IF(VLOOKUP($D37,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D37,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D37=\"\",\"\",IF(VLOOKUP($D37,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D37,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D37=\"\",\"\",IF(VLOOKUP($D37,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D37,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D37=\"\",\"\",IF(VLOOKUP($D37,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D37,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2013-04-29",{"$f":"IF(A38=\"\",\"\",PROPER(TEXT(A38,\"ddd\")))","v":"Ma"},"",null,{"$f":"IF($D38=\"\",\"\",IF(VLOOKUP($D38,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D38,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D38=\"\",\"\",IF(VLOOKUP($D38,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D38,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D38=\"\",\"\",IF(VLOOKUP($D38,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D38,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D38=\"\",\"\",IF(VLOOKUP($D38,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D38,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D38=\"\",\"\",IF(VLOOKUP($D38,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D38,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["2013-04-30",{"$f":"IF(A39=\"\",\"\",PROPER(TEXT(A39,\"ddd\")))","v":"Ti"},"",null,{"$f":"IF($D39=\"\",\"\",IF(VLOOKUP($D39,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D39,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D39=\"\",\"\",IF(VLOOKUP($D39,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D39,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D39=\"\",\"\",IF(VLOOKUP($D39,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D39,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D39=\"\",\"\",IF(VLOOKUP($D39,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D39,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D39=\"\",\"\",IF(VLOOKUP($D39,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D39,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
[null,"","",null,{"$f":"IF($D40=\"\",\"\",IF(VLOOKUP($D40,Timeberegning!A$4:B$153,2)=0,\"\",VLOOKUP($D40,Timeberegning!A$4:B$153,2)))","v":""},{"$f":"IF($D40=\"\",\"\",IF(VLOOKUP($D40,Timeberegning!A$4:C$153,3)=\"\",\"\",VLOOKUP($D40,Timeberegning!A$4:C$153,3)))","v":""},{"$f":"IF($D40=\"\",\"\",IF(VLOOKUP($D40,Timeberegning!$A$4:$O$153,13)=\"\",\"\",VLOOKUP($D40,Timeberegning!$A$4:$O$153,13)))","v":""},null,null,"","","",{"$f":"IF($D40=\"\",\"\",IF(VLOOKUP($D40,Timeberegning!$A$4:$O$101,15)=\"\",\"\",VLOOKUP($D40,Timeberegning!$A$4:$O$101,15)))","v":""},"",{"$f":"IF($D40=\"\",\"\",IF(VLOOKUP($D40,Timeberegning!$A$4:$P$101,16)=\"\",\"\",VLOOKUP($D40,Timeberegning!$A$4:$P$101,16)))","v":""},null,"","","","","",""]
["Total timer",null,null,null,null,null,{"$f":"IF(SUM(G15:G40)<>\"0\",SUM(G10:G40),\"\")","v":0.91736111111111118},{"$f":"IF(SUM(H10:H40)<>\"0\",SUM(H10:H40),\"\")","v":0},0,0,6.25E-2,0,0,{"$f":"SUM(N10:N40)","v":0},{"$f":"SUM(O10:O40)","v":0}]
["Timer 1/100",null,null,null,null,null,{"$f":"IF(G41<>\"\",ROUND(G41*24,2),\"\")","v":22.02},{"$f":"IF(H41<>\"\",ROUND(H41*24,2),\"\")","v":0},0,0,1.5,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(G41<>\"\",G42*G43,\"\")","v":2769.2352000000001},{"$f":"IF(H41<>\"\",H42*H43,\"\")","v":0},0,0,32.714999999999996,0,{"$f":"IF(M41<>\"\",M41*M43,\"\")","v":0}]
[]
["Lønart"]
[3025,null,null,null,null,null,{"$f":"G41","v":0.91736111111111118}]
[3425,null,null,null,null,null,{"$f":"H41","v":0}]
[3426,null,null,null,null,null,{"$f":"I41","v":0}]
["Timer",null,null,null,null,null,{"$f":"SUM(G47:G49)","v":0.91736111111111118},{"$f":"IF(G50<>\"\",ROUND(G50*24,2),\"\")","v":22.02}]
[null,null,null,null,null,null,null,{"$f":"G43*H50","v":2769.2352000000001}]

{"sheet":"Satser","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"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"]
[]
["norm man-torsdag",0.32291666666666669]
["norm fredag",0.25]

{"sheet":"Timeberegning","index":5,"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":"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":[]}