{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["september2010","Satser","norm","T.","Ark2","Ark3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"september2010","index":0,"n_rows":47,"n_cols":35,"rows_kept":47,"cut":false,"hidden":false,"merged":[[29,11,29,12],[30,11,30,12],[31,11,31,12],[32,11,32,12],[37,11,37,12],[39,11,39,12],[38,11,38,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[35,11,35,12],[36,11,36,12],[25,11,25,12],[26,11,26,12],[27,11,27,12],[33,11,33,12],[34,11,34,12],[21,11,21,12],[28,11,28,12],[19,9,19,10],[20,9,20,10],[21,9,21,10],[8,11,8,12],[9,11,9,12],[10,11,10,12],[11,11,11,12],[12,11,12,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[16,11,16,12],[36,9,36,10],[37,9,37,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[45,0,45,5],[43,0,43,2],[44,0,44,2],[8,9,8,10],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[22,9,22,10],[23,9,23,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[41,0,41,2],[42,0,42,2],[5,11,5,12],[6,11,6,12],[7,11,7,12],[5,9,5,10],[6,9,6,10],[7,9,7,10],[22,11,22,12],[23,11,23,12],[24,11,24,12],[18,9,18,10],[38,9,38,10],[39,9,39,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[0,1,0,7],[1,11,1,12],[2,11,2,12],[3,11,3,12],[4,11,4,12],[1,9,1,10],[2,9,2,10],[3,9,3,10],[4,9,4,10],[1,1,1,2],[2,1,2,2],[0,10,0,11]]}
["Løn",{"$f":"PROPER(TEXT(A4,\"dd mmmm åååå\")) & PROPER(TEXT(A36,\"  -  dd mmmm åååå\"))","v":"01 September 2019  -  03 Oktober 2019"},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":35},"-",null,{"$f":"IF(A25=\"\",\"\",TRUNC((A25-WEEKDAY(A25,2)-DATE(YEAR(A25+4-WEEKDAY(A25,2)),1,-10))/7))","v":38},null,null,null,null,null,null,null,null,"Time beregning:",null,null,null,null,null,null,null,null,null,null,"06:00:00","18:00:00","03:00:00"]
["Lønart",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Betalt pause ved vagt over 5 timer",null,null,null,"00:25:00","minutter","00:00:00","06:00:00","17:00:00","14:00:00"]
["Dato","Dag",null,"Start","Slut","Pause","Arb. Tid","Overtid           1-3 time","Overtid            4 - time","Forskudt tid alle dage\n18-23",null,"Natarbejde 23-06",null,"Lørdag tillæg 15 - 24","Søndag tillæg 00 - 24","Optjent afspadsering","Afholdt afspadsering","Syge Timer","norm"]
["2019-09-01",{"$f":"PROPER(TEXT(A4,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A4,0,0)","v":""},"07:00:00","16:00:00","00:30:00",{"$f":"IF(D4=\"\",\"\",(E4-D4)+(D4>E4)-F4)","v":0.35416666666666663},{"$f":"IF(G4=\"\",0,IF(WEEKDAY(A4,2)=7,0,IF(G4>S4,MIN(G4-S4,$AI$1),0)))","v":"00:00:00"},{"$f":"IF(G4=\"\",\"\",IF(G4>S4+H4,G4-(S4+H4),\"\"))","v":"08:30:00"},{"$f":"ColTime(T.!$J$3,T.!$L$3,D4,E4)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D4,E4)","v":"00:00:00"},null,{"$f":"IF(WEEKDAY(A4,2)=6,ColTime(TIME(T.!J5,0,0),TIME(T.!L5,0,0),D4,E4),\"\")","v":""},{"$f":"IF(OR(C4<>\"\",WEEKDAY(A4,2)=7),ColTime(TIME(0,0,0),TIME(24,0,0),D4,E4),\"\")","v":"09:00:00"},{"$f":"IFERROR(H4+I4,\"\")","v":"08:30:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A4,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,{"$f":"IF(D4=\"\",\"\",HOUR(D4))","v":7},{"$f":"IF(D4=\"\",\"\",MINUTE(D4))","v":0},{"$f":"IF(D4=\"\",\"\",TIME(HOUR(D4),MINUTE(D4),0))","v":"07:00:00"},{"$f":"IF(E4=\"\",\"\",HOUR(E4))","v":16},{"$f":"IF(E4=\"\",\"\",MINUTE(E4))","v":0},"02:00:00","09:30:00","11:30:00",null,null,null,{"$f":"MIN(G4-S4,3)","v":0.35416666666666663}]
[{"$f":"A4+1","v":"2019-09-02"},{"$f":"PROPER(TEXT(A5,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A5,0,0)","v":""},"13:45:00","21:30:00","00:30:00",{"$f":"IF(D5=\"\",\"\",(E5-D5)+(D5>E5)-F5)","v":0.30208333333333343},{"$f":"IF(G5=\"\",0,IF(WEEKDAY(A5,2)=7,0,IF(G5>S5,MIN(G5-S5,$AI$1),0)))","v":"00:00:00"},{"$f":"IF(G5=\"\",\"\",IF(G5>S5+H5,G5-(S5+H5),\"\"))","v":""},{"$f":"ColTime(T.!$J$3,T.!$L$3,D5,E5)","v":"03:30:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D5,E5)","v":"00:00:00"},null,{"$f":"IF(WEEKDAY(A5,2)=6,ColTime(TIME(15,0,0),TIME(24,0,0),D5,E5),\"\")","v":""},"",{"$f":"IFERROR(H5+I5,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A5,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,13,45,"13:45:00",21,30,{"$f":"IF(E5=\"\",\"\",TIME(HOUR(E5),MINUTE(E5),0))","v":"21:30:00"},null,null,null,null,null,null,"Der taste kun i de Gule celler"]
[{"$f":"A5+1","v":"2019-09-03"},{"$f":"PROPER(TEXT(A6,\"ddd\"))","v":"Ti"},"","22:00:00","05:45:00","00:30:00",0.30208333333333343,"00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D6,E6)","v":"01:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D6,E6)","v":"06:45:00"},null,"","",{"$f":"IFERROR(H6+I6,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A6,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,22,0,"22:00:00",5,45,"05:45:00"]
["2019-09-04","On","","05:00:00","16:45:00","00:30:00",0.46874999999999994,"03:00:00","00:45:00",{"$f":"ColTime(T.!$J$3,T.!$L$3,D7,E7)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D7,E7)","v":"01:00:00"},null,"","",{"$f":"IFERROR(H7+I7,\"\")","v":"03:45:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A7,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,5,0,"05:00:00",16,45,"16:45:00"]
["2019-09-05","To","",null,null,null,"",{"$f":"IF(G8=\"\",0,IF(WEEKDAY(A8,2)=7,0,IF(G8>S8,MIN(G8-S8,$AI$1),0)))","v":"00:00:00"},{"$f":"IF(G8=\"\",\"\",IF(G8>S8+H8,G8-(S8+H8),\"\"))","v":""},{"$f":"ColTime(T.!$J$3,T.!$L$3,D8,E8)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D8,E8)","v":"00:00:00"},null,"","",{"$f":"IFERROR(H8+I8,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A8,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-06","Fr","","06:00:00","19:00:00","00:30:00",0.52083333333333326,"03:00:00","02:30:00",{"$f":"ColTime(T.!$J$3,T.!$L$3,D9,E9)","v":"01:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D9,E9)","v":"00:00:00"},null,"",{"$f":"IF(OR(C9<>\"\",WEEKDAY(A9,2)=7),ColTime(TIME(0,0,0),TIME(24,0,0),D9,E9),\"\")","v":""},{"$f":"IFERROR(H9+I9,\"\")","v":"05:30:00"},null,null,{"$f":"CHOOSE(WEEKDAY(A9,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:00:00"},null,null,6,0,"06:00:00",19,0,"19:00:00"]
["2019-09-07","Lø","","07:00:00","19:00:00",null,0.49999999999999994,"03:00:00","09:00:00",{"$f":"ColTime(T.!$J$3,T.!$L$3,D10,E10)","v":"01:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D10,E10)","v":"00:00:00"},null,"04:00:00",{"$f":"IF(OR(C10<>\"\",WEEKDAY(A10,2)=7),ColTime(TIME(0,0,0),TIME(24,0,0),D10,E10),\"\")","v":""},"12:00:00",null,null,{"$f":"CHOOSE(WEEKDAY(A10,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,7,0,"07:00:00",19,0,"19:00:00"]
[{"$f":"A10+1","v":"2019-09-08"},{"$f":"PROPER(TEXT(A11,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A11,0,0)","v":""},null,null,null,{"$f":"IF(D11=\"\",\"\",(E11-D11)+(D11>E11)-F11)","v":""},{"$f":"IF(G11=\"\",0,IF(WEEKDAY(A11,2)=7,0,IF(G11>S11,MIN(G11-S11,$AI$1),0)))","v":"00:00:00"},{"$f":"IF(G11=\"\",\"\",IF(G11>S11+H11,G11-(S11+H11),\"\"))","v":""},{"$f":"ColTime(T.!$J$3,T.!$L$3,D11,E11)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D11,E11)","v":"00:00:00"},null,"","00:00:00","",null,null,{"$f":"CHOOSE(WEEKDAY(A11,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,"","","","","",""]
[{"$f":"A11+1","v":"2019-09-09"},{"$f":"PROPER(TEXT(A12,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A12,0,0)","v":""},null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D12,E12)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D12,E12)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A12,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
[{"$f":"A12+1","v":"2019-09-10"},{"$f":"PROPER(TEXT(A13,\"ddd\"))","v":"Ti"},"",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D13,E13)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D13,E13)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A13,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-11","On","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D14,E14)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D14,E14)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A14,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-12","To","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D15,E15)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D15,E15)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A15,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-13","Fr","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D16,E16)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D16,E16)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A16,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:00:00"},null,null,"","","","","",""]
["2019-09-14","Lø","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D17,E17)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D17,E17)","v":"00:00:00"},null,"00:00:00","","",null,null,{"$f":"CHOOSE(WEEKDAY(A17,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,"","","","","",""]
[{"$f":"A17+1","v":"2019-09-15"},{"$f":"PROPER(TEXT(A18,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A18,0,0)","v":""},null,null,null,{"$f":"IF(D18=\"\",\"\",(E18-D18)+(D18>E18)-F18)","v":""},{"$f":"IF(G18=\"\",0,IF(WEEKDAY(A18,2)=7,0,IF(G18>S18,MIN(G18-S18,$AI$1),0)))","v":"00:00:00"},{"$f":"IF(G18=\"\",\"\",IF(G18>S18+H18,G18-(S18+H18),\"\"))","v":""},{"$f":"ColTime(T.!$J$3,T.!$L$3,D18,E18)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D18,E18)","v":"00:00:00"},null,"",{"$f":"IF(OR(C18<>\"\",WEEKDAY(A18,2)=7),ColTime(TIME(0,0,0),TIME(24,0,0),D18,E18),\"\")","v":"00:00:00"},{"$f":"IFERROR(H18+I18,\"\")","v":""},null,null,{"$f":"CHOOSE(WEEKDAY(A18,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,"","","","","",""]
[{"$f":"A18+1","v":"2019-09-16"},{"$f":"PROPER(TEXT(A19,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A19,0,0)","v":""},null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D19,E19)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D19,E19)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A19,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
[{"$f":"A19+1","v":"2019-09-17"},{"$f":"PROPER(TEXT(A20,\"ddd\"))","v":"Ti"},"",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D20,E20)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D20,E20)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A20,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-18","On","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D21,E21)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D21,E21)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A21,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-19","To","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D22,E22)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D22,E22)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A22,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-20","Fr","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D23,E23)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D23,E23)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A23,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:00:00"},null,null,"","","","","",""]
["2019-09-21","Lø","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D24,E24)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D24,E24)","v":"00:00:00"},null,"00:00:00","","",null,null,{"$f":"CHOOSE(WEEKDAY(A24,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,"","","","","",""]
[{"$f":"A24+1","v":"2019-09-22"},{"$f":"PROPER(TEXT(A25,\"ddd\"))","v":"Sø"},{"$f":"HelligdagsNavn(A25,0,0)","v":""},null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D25,E25)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D25,E25)","v":"00:00:00"},null,"","00:00:00","",null,null,{"$f":"CHOOSE(WEEKDAY(A25,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"},null,null,"","","","","",""]
[{"$f":"A25+1","v":"2019-09-23"},{"$f":"PROPER(TEXT(A26,\"ddd\"))","v":"Ma"},{"$f":"HelligdagsNavn(A26,0,0)","v":""},null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D26,E26)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D26,E26)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A26,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
[{"$f":"A26+1","v":"2019-09-24"},{"$f":"PROPER(TEXT(A27,\"ddd\"))","v":"Ti"},"",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D27,E27)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D27,E27)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A27,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-25","On","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D28,E28)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D28,E28)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A28,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,"","","","","",""]
["2019-09-26","To","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D29,E29)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D29,E29)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A29,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"}]
["2019-09-27","Fr","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D30,E30)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D30,E30)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A30,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:00:00"}]
["2019-09-28","Lø","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D31,E31)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D31,E31)","v":"00:00:00"},null,"00:00:00","","",null,null,{"$f":"CHOOSE(WEEKDAY(A31,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"}]
["2019-09-29","Sø","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D32,E32)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D32,E32)","v":"00:00:00"},null,"","00:00:00","",null,null,{"$f":"CHOOSE(WEEKDAY(A32,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"00:00:00"}]
["2019-09-30","Ma","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D33,E33)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D33,E33)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A33,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"}]
["2019-10-01","Ti","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D34,E34)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D34,E34)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A34,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D34=\"\",\"\",HOUR(D34))","v":""},{"$f":"IF(D34=\"\",\"\",MINUTE(D34))","v":""},{"$f":"IF(D34=\"\",\"\",TIME(HOUR(D34),MINUTE(D34),0))","v":""},{"$f":"IF(E34=\"\",\"\",HOUR(E34))","v":""},{"$f":"IF(E34=\"\",\"\",MINUTE(E34))","v":""},{"$f":"IF(E34=\"\",\"\",TIME(HOUR(E34),MINUTE(E34),0))","v":""}]
["2019-10-02","On","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D35,E35)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D35,E35)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A35,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D35=\"\",\"\",HOUR(D35))","v":""},{"$f":"IF(D35=\"\",\"\",MINUTE(D35))","v":""},{"$f":"IF(D35=\"\",\"\",TIME(HOUR(D35),MINUTE(D35),0))","v":""},{"$f":"IF(E35=\"\",\"\",HOUR(E35))","v":""},{"$f":"IF(E35=\"\",\"\",MINUTE(E35))","v":""},{"$f":"IF(E35=\"\",\"\",TIME(HOUR(E35),MINUTE(E35),0))","v":""}]
["2019-10-03","To","",null,null,null,"","00:00:00","",{"$f":"ColTime(T.!$J$3,T.!$L$3,D36,E36)","v":"00:00:00"},null,{"$f":"ColTime(TIME(T.!$J$4,0,0),TIME(T.!$L$4,0,0),D36,E36)","v":"00:00:00"},null,"","","",null,null,{"$f":"CHOOSE(WEEKDAY(A36,2),norm!C$1,norm!C$2,norm!C$3,norm!C$4,norm!C$5,norm!C$6,norm!C$7)","v":"07:30:00"},null,null,{"$f":"IF(D36=\"\",\"\",HOUR(D36))","v":""},{"$f":"IF(D36=\"\",\"\",MINUTE(D36))","v":""},{"$f":"IF(D36=\"\",\"\",TIME(HOUR(D36),MINUTE(D36),0))","v":""},{"$f":"IF(E36=\"\",\"\",HOUR(E36))","v":""},{"$f":"IF(E36=\"\",\"\",MINUTE(E36))","v":""},{"$f":"IF(E36=\"\",\"\",TIME(HOUR(E36),MINUTE(E36),0))","v":""}]
["Total timer",null,null,null,null,null,{"$f":"IF(SUM(G9:G36)<>\"0\",SUM(G4:G36),\"\")","v":2.4479166666666665},{"$f":"IF(SUM(H4:H36)<>\"0\",SUM(H4:H36),\"\")","v":0.375},{"$f":"IF(SUM(I4:I36)<>\"0\",SUM(I4:I36),\"\")","v":0.86458333333333304},{"$f":"IF(SUM(J4:J36)<>\"0\",SUM(J4:J36),\"\")","v":0.27083333333333337},null,{"$f":"SUM(L4:M36)","v":"07:45:00"},null,{"$f":"IF(SUM(N4:N36)<>\"0\",SUM(N4:N36),\"\")","v":0.16666666666666663},{"$f":"IF(SUM(O4:O36)<>\"0\",SUM(O4:O36),\"\")","v":"09:00:00"},{"$f":"SUM(P4:P36)","v":1.239583333333333},{"$f":"SUM(Q4:Q36)","v":0}]
["Timer 1/100",null,null,null,null,null,{"$f":"IF(G37<>\"\",ROUND(G37*24,2),\"\")","v":58.75},{"$f":"IF(H37<>\"\",ROUND(H37*24,2),\"\")","v":9},20.75,{"$f":"IF(J37<>\"\",ROUND(J37*24,2),\"\")","v":6.5},null,{"$f":"IF(L37<>\"\",ROUND(L37*24,2),\"\")","v":7.75},null,{"$f":"IF(N37<>\"\",ROUND(N37*24,2),\"\")","v":4},9,29.75,0]
["Satser",null,null,null,null,null,{"$f":"Satser!B7","v":107.35},{"$f":"Satser!B9","v":36.35},{"$f":"Satser!B12","v":58.1},{"$f":"Satser!B17","v":25.6},null,{"$f":"Satser!B18","v":34.200000000000003},null,{"$f":"Satser!B19","v":45.1},{"$f":"Satser!B20","v":50.6}]
[null,null,null,null,null,null,{"$f":"IF(G37<>\"\",G38*G39,\"\")","v":6306.8125},{"$f":"IF(H37<>\"\",H38*H39,\"\")","v":327.15000000000003},1205.575,{"$f":"IF(J37<>\"\",J38*J39,\"\")","v":166.4},null,{"$f":"IF(L37<>\"\",L38*L38,\"\")","v":60.0625},null,{"$f":"IF(N37<>\"\",N38*N39,\"\")","v":180.4},455.40000000000003]
[]
["Lønart"]
[3025,null,null,null,null,null,{"$f":"G37","v":2.4479166666666665}]
[3425,null,null,null,null,null,{"$f":"H37","v":0.375}]
[3428,null,null,null,null,null,{"$f":"I37","v":0.86458333333333304}]
["Timer",null,null,null,null,null,{"$f":"SUM(G43:G45)","v":3.6874999999999996},{"$f":"IF(G46<>\"\",ROUND(G46*24,2),\"\")","v":88.5}]
[null,null,null,null,null,null,null,{"$f":"G39*H46","v":9500.4750000000004}]

{"sheet":"Satser","index":1,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Timeløn",114.42]
["specielt tillæg"]
["Chauffør tillæg"]
[]
["Samlet timeløn",107.35,null,108.7]
[]
["overtidstillæg 50%",36.35,null,36.5]
["pr. time",{"$f":"B7+B9","v":143.69999999999999}]
[]
["overtidstillæg 100%",58.1,null,58.9]
["pr. time",{"$f":"B12+B7","v":165.45}]
[]
[null,108.65,null,110.15]
[]
["Aftentillæg",25.6,null,null,null,"Arbejde mellem 18:00 og 23:00"]
["Nattillæg",34.200000000000003,null,null,null,"Arbejde mellem 23:00 og 06:00"]
["Lørdags tillæg",45.1,null,null,null,"Lørdag mellem 15:00 og 24:00"]
["Søndags tillæg",50.6,null,null,null,"Søndagstillæg"]
[]
[]
[]
[]
[]
[null,"07:24:00"]

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

{"sheet":"T.","index":3,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Timeløn",null,null,"Start","Slut"]
["Normal løn",114.42,null,null,"06:00:00","18:00:00",null,"Aften tillæg","Fra kl.","18:00:00","Til kl.","23:00:00"]
["Aftentillæg",25.6,null,null,"18:00:00","23:00:00",null,"Nat tillæg","Fra kl.",23,"Til kl.",6]
["Nattillæg",34.200000000000003,null,null,"23:00:00","06:00:00",null,"Lørdags tillæg","Fra kl.",15,"Til kl.",24]
["Lørdagstillæg",45.1,null,null,"15:00:00",1,null,"Søn og helligdags tillæg","Fra kl.",0,"Til kl.",24]
["Søn- og helligdage",50.6,null,null,"00:00:00","23:59:00"]

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

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