{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Timesedel","T.","Lønsedel","Ark1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Timesedel","index":0,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[[8,8,8,10],[8,0,8,1],[38,0,38,1],[39,0,39,1],[8,2,8,6],[7,0,7,1],[0,0,0,11],[1,0,1,9],[6,0,6,1],[6,2,6,6],[7,2,7,6],[6,8,6,10],[7,8,7,10]]}
["BTK Transport"]
["Herringvej 25 4690 Haslev",null,null,null,null,null,null,null,null,null,"Timesedel for 2 uger"]
[]
[]
[]
[]
["Medarbejder:",null,null,null,null,null,null,null,"Telefonnummer, medarbejder:"]
["E-mail, medarbejder:",null,null,null,null,null,null,null,"Startdato:",null,null,"2019-11-04"]
["Leder:",null,null,null,null,null,null,null,"Slutdato:",null,null,{"$f":"IF($L$8=\"\",\"\",$L$8+13)","v":"2019-11-17"}]
[]
[]
["Dag","Dato","Start KL","Slut KL.","ArbejdsTid","Norm ","fra 1 til 5 overtime","Fra 6 overtime ","21 - 05","Syg","Ferie/fridag/sh","I alt"]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Mandag"},{"$f":"L8","v":"2019-11-04"},"07:00:00","15:00:00",{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"0:0\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D13))","v":"08:00:00"},null,null,null,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F13:K13)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":0.33333333333333331}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Tirsdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+1)","v":"2019-11-05"},"06:00:00","18:30:00",{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"0:0\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D14))","v":"12:30:00"},null,null,null,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F14:K14)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":0.52083333333333337}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Onsdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+2)","v":"2019-11-06"},"06:00:00","13:24:00",{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"0:0\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D15))","v":"07:24:00"},null,null,null,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F15:K15)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":0.30833333333333335}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Torsdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+3)","v":"2019-11-07"},"06:00:00","18:00:00",{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"0:0\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D16))","v":"12:00:00"},null,null,null,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F16:K16)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":0.5}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Fredag"},{"$f":"IF($L$8=\"\",\"\",$L$8+4)","v":"2019-11-08"},"06:00:00","12:00:00",{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"0:0\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D17))","v":"06:00:00"},null,null,null,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F17:K17)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":0.25}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Lørdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+5)","v":"2019-11-09"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"0:0\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D18))","v":"0:0"},null,null,null,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F18:K18)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Søndag"},{"$f":"IF($L$8=\"\",\"\",$L$8+6)","v":"2019-11-10"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"0:0\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D19))","v":"0:0"},null,null,null,null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F19:K19)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
["Timer total (TT:MM)",null,null,null,{"$f":"SUM(E13:E19)","v":1.9125000000000001},1.5416666666666667,{"$f":"IF(SUM(E14:E20)<=T.!F10,\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$F$10,T.!$C$1,IF(Table1[[#This Row],[ArbejdsTid]]>T.!$F$9,Table1[[#This Row],[ArbejdsTid]]-T.!$F$9,\"\")))","v":0.20833333333333334},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]>T.!F10,Timesedel!E20-T.!F10,\"\")","v":0.16250000000000009}]
[]
[]
["Dag","Dato","Start KL","Slut KL.","Arbejdstid","Norm",null,null,null,"Syg","Ferie/fridag/sh","I alt"]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Mandag"},{"$f":"IF($L$8=\"\",\"\",$L$8+7)","v":"2019-11-11"},"07:15:00","15:45:00",{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D24))","v":"08:30:00"},{"$f":"CHOOSE(WEEKDAY(Table1[[#This Row],[Dato]],2),T.!$F$2,T.!$F$3,T.!$F$4,T.!$F$5,T.!$F$6,T.!$F$7,T.!$F$8)","v":0.30833333333333335},{"$f":"IF(Table1[[#This Row],[Start KL]]=\"\",\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$B$1,T.!$C$1,Timesedel!E24-F24))","v":4.5833333333333337E-2},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]<>\"\",IF(Table1[[#This Row],[ArbejdsTid]]>T.!$B$1,Table1[[#This Row],[ArbejdsTid]]-T.!$B$1,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F24:K24)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":0.35416666666666669}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Tirsdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+8)","v":"2019-11-12"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D25))","v":""},{"$f":"CHOOSE(WEEKDAY(Table1[[#This Row],[Dato]],2),T.!$F$2,T.!$F$3,T.!$F$4,T.!$F$5,T.!$F$6,T.!$F$7,T.!$F$8)","v":0.30833333333333335},{"$f":"IF(Table1[[#This Row],[Start KL]]=\"\",\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$B$1,T.!$C$1,Timesedel!E25-F25))","v":""},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]<>\"\",IF(Table1[[#This Row],[ArbejdsTid]]>T.!$B$1,Table1[[#This Row],[ArbejdsTid]]-T.!$B$1,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F25:K25)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Onsdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+9)","v":"2019-11-13"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D26))","v":""},{"$f":"CHOOSE(WEEKDAY(Table1[[#This Row],[Dato]],2),T.!$F$2,T.!$F$3,T.!$F$4,T.!$F$5,T.!$F$6,T.!$F$7,T.!$F$8)","v":0.30833333333333335},{"$f":"IF(Table1[[#This Row],[Start KL]]=\"\",\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$B$1,T.!$C$1,Timesedel!E26-F26))","v":""},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]<>\"\",IF(Table1[[#This Row],[ArbejdsTid]]>T.!$B$1,Table1[[#This Row],[ArbejdsTid]]-T.!$B$1,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F26:K26)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Torsdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+10)","v":"2019-11-14"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D27))","v":""},{"$f":"CHOOSE(WEEKDAY(Table1[[#This Row],[Dato]],2),T.!$F$2,T.!$F$3,T.!$F$4,T.!$F$5,T.!$F$6,T.!$F$7,T.!$F$8)","v":0.30833333333333335},{"$f":"IF(Table1[[#This Row],[Start KL]]=\"\",\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$B$1,T.!$C$1,Timesedel!E27-F27))","v":""},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]<>\"\",IF(Table1[[#This Row],[ArbejdsTid]]>T.!$B$1,Table1[[#This Row],[ArbejdsTid]]-T.!$B$1,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F27:K27)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Fredag"},{"$f":"IF($L$8=\"\",\"\",$L$8+11)","v":"2019-11-15"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D28))","v":""},{"$f":"CHOOSE(WEEKDAY(Table1[[#This Row],[Dato]],2),T.!$F$2,T.!$F$3,T.!$F$4,T.!$F$5,T.!$F$6,T.!$F$7,T.!$F$8)","v":0.30833333333333335},{"$f":"IF(Table1[[#This Row],[Start KL]]=\"\",\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$B$1,T.!$C$1,Timesedel!E28-F28))","v":""},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]<>\"\",IF(Table1[[#This Row],[ArbejdsTid]]>T.!$B$1,Table1[[#This Row],[ArbejdsTid]]-T.!$B$1,\"\"),\"\")","v":""},null,null,",",{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F28:K28)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Lørdag"},{"$f":"IF($L$8=\"\",\"\",$L$8+12)","v":"2019-11-16"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D29))","v":""},{"$f":"CHOOSE(WEEKDAY(Table1[[#This Row],[Dato]],2),T.!$F$2,T.!$F$3,T.!$F$4,T.!$F$5,T.!$F$6,T.!$F$7,T.!$F$8)","v":0},{"$f":"IF(Table1[[#This Row],[Start KL]]=\"\",\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$B$1,T.!$C$1,Timesedel!E29-F29))","v":""},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]<>\"\",IF(Table1[[#This Row],[ArbejdsTid]]>T.!$B$1,Table1[[#This Row],[ArbejdsTid]]-T.!$B$1,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F29:K29)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
[{"$f":"PROPER(TEXT(WEEKDAY(Table1[[#This Row],[Dato]],1),\"DDDD\"))","v":"Søndag"},{"$f":"IF($L$8=\"\",\"\",$L$8+13)","v":"2019-11-17"},null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",Table1[[#This Row],[Slut KL.]]-Table1[[#This Row],[Start KL]]+(Table1[[#This Row],[Start KL]]>D30))","v":""},{"$f":"CHOOSE(WEEKDAY(Table1[[#This Row],[Dato]],2),T.!$F$2,T.!$F$3,T.!$F$4,T.!$F$5,T.!$F$6,T.!$F$7,T.!$F$8)","v":0},{"$f":"IF(Table1[[#This Row],[Start KL]]=\"\",\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$B$1,T.!$C$1,Timesedel!E30-F30))","v":""},{"$f":"IF(Table1[[#This Row],[ArbejdsTid]]<>\"\",IF(Table1[[#This Row],[ArbejdsTid]]>T.!$B$1,Table1[[#This Row],[ArbejdsTid]]-T.!$B$1,\"\"),\"\")","v":""},null,null,null,{"$f":"IF(OR(Table1[[#This Row],[Start KL]]=\"\",Table1[[#This Row],[Slut KL.]]=\"\"),\"\",IF(SUM(F30:K30)>24,\"Du har indtastet over 24 timer.\",Table1[[#This Row],[ArbejdsTid]]))","v":""}]
["Timer total (TT:MM)","I alt",null,null,{"$f":"SUM(E24:E30)","v":0.35416666666666669},null,{"$f":"SUBTOTAL(109,Table1[fra 1 til 5 overtime])","v":0.25416666666666665},{"$f":"SUBTOTAL(109,Table1[[Fra 6 overtime ]])","v":0.16250000000000009},null,{"$f":"SUBTOTAL(109,Table1[Syg])","v":0},{"$f":"SUBTOTAL(109,Table1[Ferie/fridag/sh])","v":0},{"$f":"SUBTOTAL(109,Table1[I alt])","v":2.2666666666666666}]
["Timer total (1/100)",null,null,null,{"$f":"Table1[[#Totals],[ArbejdsTid]]*24","v":8.5},null,{"$f":"Table1[[#Totals],[fra 1 til 5 overtime]]*24","v":6.1},{"$f":"Table1[[#Totals],[Fra 6 overtime ]]*24","v":3.9000000000000021},null,{"$f":"Table1[[#Totals],[Syg]]*24","v":0},{"$f":"Table1[[#Totals],[Ferie/fridag/sh]]*24","v":0},{"$f":"Table1[[#Totals],[I alt]]*24","v":54.4}]
[null,"Timesats",null,null,{"$f":"T.!A2","v":155.25},null,{"$f":"T.!A3","v":37.550000000000011},{"$f":"T.!A4","v":92.22999999999999},null,155.25,155.25]
[null,"Løn i alt",null,null,{"$f":"E32*E33","v":1319.625},null,{"$f":"G32*G33","v":229.05500000000006},359.69700000000017,null,0,0,{"$f":"SUM(E34:K34)","v":1908.3770000000002}]

{"sheet":"T.","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["Timeløn","12:24:00","05:00:00",null,"Norm"]
[155.25,null,"06:00:00",null,"Mandag",0.30833333333333335]
[{"$f":"B3-A2","v":37.550000000000011},192.8,"18:00:00",null,"Tirsdag",0.30833333333333335]
[{"$f":"B4-A2","v":92.22999999999999},247.48,"21:00:00",null,"Onsdag",0.30833333333333335]
[null,null,null,null,"Torsdag",0.30833333333333335]
[null,null,null,null,"Fredag",0.30833333333333335]
[null,null,null,null,"Lørdag",0]
[null,null,null,null,"Søndag",0]
[null,null,null,null,null,1.5416666666666667]
[null,null,null,null,null,1.75]

{"sheet":"Lønsedel","index":2,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Lønseddel"]
[]
["Jan Madsen",null,"CPR-nr.","010856-0495"]
["Fyrvej 3",null,"Trækprocent: ",38]
["4600 Køge",null,"14 dages",2482]
[null,null,"SE-nr.:","82 36 37 18"]
[null,null,"Firma","BTK"]
[null,null,null,"Heeringvej 25"]
[null,null,null,"4690 Haslev"]
[]
[]
["Lønperiode:","17.03.2014 – 30.03.2014"]
[]
["Gage:"]
["Ferieberettiget indkomst",null,null,null,12470]
["Atp:",null,null,null,47.4]
["AM-pension medarbejder","4 % af",{"$f":"+E15","v":12470},null,{"$f":"+(C17/100)*4","v":498.8}]
["Arbejdsmarkedsbidrag:","8 % af",{"$f":"+E15-E16-E17","v":11923.800000000001},null,{"$f":"ROUND(+(C18/100)*8,0)","v":954}]
["Nettoløn:",null,null,null,{"$f":"+E15-E16-E18-E17","v":10969.800000000001}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E19","v":10969.800000000001}]
["14 dags fradrag",null,null,{"$f":"+D5","v":2482}]
["Skattegrundlag:",null,null,{"$f":"+D21-D22","v":8487.8000000000011}]
[]
["Skat:","38 % af",{"$f":"+D23","v":8487.8000000000011},null,{"$f":"ROUND(+(C25/100)*D4,0)","v":3225}]
[]
["Løn til udbetaling:",null,null,null,{"$f":"+E19-E25","v":7744.8000000000011}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C18","v":11923.800000000001},null,{"$f":"SUM(C30)","v":11923.800000000001}]
["A-Indkomst",null,{"$f":"+D21","v":10969.800000000001},null,10969.800000000001]
["A Skat",null,{"$f":"+E25","v":3225},null,3225]
["AM bidrag",null,{"$f":"+E18","v":954},null,954]
["ATP bidrag medarbejder",null,{"$f":"+E16","v":47.4},null,47.4]
["ATP bidrag arbejdsgiver",null,180,null,180]
["Pension medarbejder",0.04,{"$f":"+E17","v":498.8},null,498.8]
["Pension arbejdsgiver",0.08,{"$f":"+(C17/100)*6","v":748.2},null,748.2]
["Ferieberettiget indkomst",null,{"$f":"SUM(C15:C15)","v":0},null,0]
["Rest ferie"]

{"sheet":"Ark1","index":3,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,0,30,1],[31,0,31,1],[8,0,8,1],[8,9,8,14],[19,0,19,1],[28,0,28,1],[8,2,8,6],[7,0,7,1],[7,9,7,14],[0,0,0,15],[1,0,1,13],[6,0,6,1],[6,9,6,14],[6,2,6,6],[7,2,7,6]]}
["BTK Transport"]
["Herringvej 25 4690 Haslev",null,null,null,null,null,null,null,null,null,null,null,null,null,"Timeseddel for 2 uger"]
[]
[]
[]
[]
["Medarbejder:",null,null,null,null,null,null,null,null,"Telefonnummer, medarbejder:"]
["E-mail, medarbejder:",null,null,null,null,null,null,null,null,"Startdato:",null,null,null,null,null,"2018-12-31"]
["Leder:",null,null,null,null,null,null,null,null,"Slutdato:",null,null,null,null,null,{"$f":"IF($P$8=\"\",\"\",$P$8+13)","v":"2019-01-13"}]
[]
[]
["Dag","Dato",null,"Start KL","Slut KL.","ArbejdsTid","Norm ","fra 1 til 5 overtime","Fra 6 overtime ","05 - 06","18 - 21","21 - 05","Søn- og helligdage","Syg","Ferie/fridag/sh","I alt"]
[{"$f":"PROPER(TEXT(WEEKDAY(B13,1),\"DDDD\"))","v":"Mandag"},{"$f":"P8","v":"2018-12-31"},{"$f":"HelligdagsNavn(B13,0,0)","v":""},"08:00:00","16:30:00",{"$f":"IF(OR(D13=\"\",E13=\"\"),\"0:0\",E13-D13+(D13>E13))","v":0.35416666666666669},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D13,E13)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D13,'Ark1'!E13)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D13,'Ark1'!E13)","v":0},{"$f":"IF(D13=\"\",\"\",IF(OR(WEEKDAY(B13,2)=7,C13<>\"\"),E13-D13,\"\"))","v":""},null,null,{"$f":"F13","v":0.35416666666666669}]
[{"$f":"PROPER(TEXT(WEEKDAY(B14,1),\"DDDD\"))","v":"Tirsdag"},{"$f":"B13+1","v":"2019-01-01"},{"$f":"HelligdagsNavn(B14,0,0)","v":"Nytårsdag"},"07:00:00","13:00:00",{"$f":"IF(OR(D14=\"\",E14=\"\"),\"0:0\",E14-D14+(D14>E14))","v":0.24999999999999994},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D14,E14)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D14,'Ark1'!E14)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D14,'Ark1'!E14)","v":0},0.24999999999999994,null,null,{"$f":"F14","v":0.24999999999999994}]
["Onsdag",{"$f":"B14+1","v":"2019-01-02"},"","07:00:00","15:00:00",{"$f":"IF(OR(D15=\"\",E15=\"\"),\"0:0\",E15-D15+(D15>E15))","v":0.33333333333333331},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D15,E15)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D15,'Ark1'!E15)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D15,'Ark1'!E15)","v":0},"",null,null,0.33333333333333331]
["Torsdag","2019-01-03","","08:00:00","22:00:00",{"$f":"IF(OR(D16=\"\",E16=\"\"),\"0:0\",E16-D16+(D16>E16))","v":0.58333333333333326},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D16,E16)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D16,'Ark1'!E16)","v":0.125},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D16,'Ark1'!E16)","v":4.166666666666663E-2},"",null,null,0.58333333333333326]
["Fredag","2019-01-04","","05:00:00","14:30:00",0.39583333333333326,null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D17,E17)","v":4.1666666666666657E-2},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D17,'Ark1'!E17)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D17,'Ark1'!E17)","v":0},"",null,null,0.39583333333333326]
["Lørdag","2019-01-05","",null,null,{"$f":"IF(OR(D18=\"\",E18=\"\"),\"00:00\",E18-D18+(D18>E18))","v":"00:00"},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D18,E18)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D18,'Ark1'!E18)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D18,'Ark1'!E18)","v":0},"",null,null,"00:00"]
["Søndag","2019-01-06","",null,null,{"$f":"IF(OR(D19=\"\",E19=\"\"),\"00:00\",E19-D19+(D19>E19))","v":"00:00"},null,null,null,null,{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D19,'Ark1'!E19)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D19,'Ark1'!E19)","v":0},{"$f":"IF(D19=\"\",\"\",IF(OR(WEEKDAY(B19,2)=7,C19<>\"\"),E19-D19,\"\"))","v":""},null,null,"00:00"]
["Timer total (TT:MM)",null,null,null,null,{"$f":"SUM(F13:F19)","v":1.9166666666666665},1.5416666666666667,{"$f":"IF(SUM(F14:F20)<=T.!$F$8,\"\",IF(Table1[[#This Row],[ArbejdsTid]]>=T.!$F$10,T.!$C$1,IF(Table1[[#This Row],[ArbejdsTid]]>T.!$F$9,Table1[[#This Row],[ArbejdsTid]]-T.!$F$9,\"\")))","v":0.20833333333333334},{"$f":"IF(F20>T.!$F$10,F20-T.!$F$10,\"0:0\")","v":0.16666666666666652},{"$f":"SUM(J13:J19)","v":4.1666666666666657E-2},{"$f":"SUM(K13:K19)","v":0.125},4.166666666666663E-2,0.24999999999999994,null,null,{"$f":"SUM(P13:P19)","v":1.9166666666666665}]
[]
[{"$f":"PROPER(TEXT(WEEKDAY(B22,1),\"DDDD\"))","v":"Mandag"},{"$f":"B19+1","v":"2019-01-07"},{"$f":"HelligdagsNavn(B22,0,0)","v":""},"07:00:00","15:00:00",{"$f":"IF(OR(D22=\"\",E22=\"\"),\"0:0\",E22-D22+(D22>E22))","v":0.33333333333333331},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D22,E22)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D22,'Ark1'!E22)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D22,'Ark1'!E22)","v":0},{"$f":"IF(D22=\"\",\"\",IF(OR(WEEKDAY(B22,2)=7,C22<>\"\"),E22-D22,\"\"))","v":""},null,null,{"$f":"F22","v":0.33333333333333331}]
[{"$f":"PROPER(TEXT(WEEKDAY(B23,1),\"DDDD\"))","v":"Tirsdag"},{"$f":"B22+1","v":"2019-01-08"},"","06:00:00","18:30:00",{"$f":"IF(OR(D23=\"\",E23=\"\"),\"0:0\",E23-D23+(D23>E23))","v":0.52083333333333337},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D23,E23)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D23,'Ark1'!E23)","v":2.083333333333337E-2},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D23,'Ark1'!E23)","v":0},"",null,null,{"$f":"F23","v":0.52083333333333337}]
["Onsdag",{"$f":"B23+1","v":"2019-01-09"},"","06:00:00","13:24:00",{"$f":"IF(OR(D24=\"\",E24=\"\"),\"0:0\",E24-D24+(D24>E24))","v":0.30833333333333335},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D24,E24)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D24,'Ark1'!E24)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D24,'Ark1'!E24)","v":0},"",null,null,0.30833333333333335]
["Torsdag","2019-01-10","","06:00:00","18:00:00",0.5,null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D25,E25)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D25,'Ark1'!E25)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D25,'Ark1'!E25)","v":0},"",null,null,0.5]
["Fredag","2019-01-11","","06:00:00","12:00:00",{"$f":"IF(OR(D26=\"\",E26=\"\"),\"00:00\",E26-D26+(D26>E26))","v":0.25},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D26,E26)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D26,'Ark1'!E26)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D26,'Ark1'!E26)","v":0},"",null,null,0.25]
["Lørdag","2019-01-12","",null,null,{"$f":"IF(OR(D27=\"\",E27=\"\"),\"00:00\",E27-D27+(D27>E27))","v":"00:00"},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D27,E27)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D27,'Ark1'!E27)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D27,'Ark1'!E27)","v":0},"",null,null,"00:00"]
["Søndag","2019-01-13","",null,null,{"$f":"IF(OR(D28=\"\",E28=\"\"),\"00:00\",E28-D28+(D28>E28))","v":"00:00"},null,null,null,{"$f":"ColTime(T.!$C$1,T.!$C$2,D28,E28)","v":0},{"$f":"ColTime(T.!$C$3,T.!$C$4,'Ark1'!D28,'Ark1'!E28)","v":0},{"$f":"ColTime(T.!$C$4,T.!$C$1,'Ark1'!D28,'Ark1'!E28)","v":0},"",null,null,"00:00"]
["Timer total (TT:MM)",null,null,null,null,{"$f":"SUM(F22:F28)","v":1.9125000000000001},{"$f":"T.!F9","v":1.5416666666666667},{"$f":"IF(SUM(F23:F29)<=T.!F8,\"\",IF(F29>=T.!$F$10,T.!$C$1,IF(F29>T.!$F$9,F29-T.!$F$9,\"\")))","v":0.20833333333333334},{"$f":"IF(F29>T.!$F$10,F29-T.!$F$10,\"0\")","v":0.16250000000000009},{"$f":"SUM(J22:J28)","v":0},{"$f":"SUM(K22:K28)","v":2.083333333333337E-2},0,0,null,null,{"$f":"SUM(P22:P28)","v":1.9125000000000001}]
[]
["Timer total (TT:MM)",null,null,null,null,{"$f":"F20+F29","v":3.8291666666666666},null,{"$f":"H20+H29","v":0.41666666666666669},{"$f":"I20+I29","v":0.32916666666666661},4.1666666666666657E-2,0.14583333333333337,4.166666666666663E-2,0.24999999999999994,0,0]
["Timer total (1/100)",null,null,null,null,{"$f":"F31*24","v":91.9},null,{"$f":"H31*24","v":10},{"$f":"I31*24","v":7.8999999999999986},{"$f":"J31*24","v":0.99999999999999978},3.5000000000000009,0.99999999999999911,5.9999999999999982,{"$f":"N31*24","v":0},{"$f":"O31*24","v":0}]
[null,"Timesats",null,null,null,{"$f":"T.!A2","v":155.25},null,{"$f":"T.!A3","v":37.550000000000011},{"$f":"T.!A4","v":92.22999999999999},{"$f":"T.!A3","v":37.550000000000011},{"$f":"T.!A3","v":37.550000000000011},{"$f":"T.!A4","v":92.22999999999999},{"$f":"T.!A4","v":92.22999999999999},155.25,155.25]
[null,"Løn i alt",null,null,null,{"$f":"F32*F33","v":14267.475},null,{"$f":"H32*H33","v":375.50000000000011},728.61699999999973,37.550000000000004,131.42500000000007,92.229999999999905,553.37999999999977,0,0,{"$f":"SUM(F34:O34)","v":16186.176999999998}]