{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["LønOgTimeberegning","Januar","Februar","Marts","April","Maj","Juni","Juli","August","September","Oktober","November","December","Hele Året"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"1904"}

{"sheet":"LønOgTimeberegning","index":0,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,2,1,6],[18,18,25,18],[25,12,25,14],[38,18,39,18],[40,18,45,18],[13,9,13,12],[0,8,0,9],[0,13,0,14],[28,18,35,18],[35,12,35,14],[45,12,45,14]]}
["Tids indtasnings formatet er XX:XX","I  rubrikken timeLøn indættes satsen"," "," ",null,null,null,"Indtasnings formatet er i X,XX og hundred-dele format.","Programmet genere automatisk tid i Timebanken, hvis du ikke har fuld tid pr. dag(det bliver så afspadsering).Du skal manuelt fjerne den generet tid( afspadsering) i rubrikken FRI UDEN LØN, Hvis du ikke vil have den regristreret i Timebanken.",null,"I rubrikken indsættes satsen",null,"I rubrikken indsættes satsen","Du skal bruge BACKSPACE hvis du har indtastet forkert tid, til at fjerne den forkerte indtastning. Så ødelægger du ikke formlerne."]
[null,null,"Overført timebank saldo fra året før",null,null,null,null,0,null,{"$f":"H2/24","v":0}]
[2021,"Hverdag 07.00-15.15\n\nTimeløn","Hverdag 15.15 - 17.15\nTimeløn incl. Tillæg \npå 50%","Hverdag 17.15 - 07.00\nTimeløn incl. Tillæg \npå 100%"," "," Lørdag 00.00 - 24.00  Timeløn incl. Tillæg på 100 %",null,"Søndag 00.00 - 24.00 Timeløn incl. Tillæg på 100 %",null,"Time Bank Saldo Total","Syge løns sats",null,"Ferie Sats Efter den nye ferielov"," ",null," ",null,null,null," "," "," "," "," "]
[null,100,{"$f":"B4/2","v":50},{"$f":"B4","v":100}," ",{"$f":"B4","v":100},null,{"$f":"B4","v":100},null,{"$f":"SUM(J19:J25)-SUM(I19:I25)+J2+SUM(L19:L35)","v":-0.26041666666666663},100,null,100," ",null," "]
[]
[null,"Mandag Til","Start:","07:00:00","15:15:00","17:15:00"]
[null,"Torsdag","Slut:","15:15:00","17:15:00","07:00:00"]
[]
[null,"Fredag","Start:","07:00:00","13:55:00","15:55:00"]
[null,null,"Slut:","13:55:00","15:55:00","07:00:00"]
[]
[null,"Lørdag","Start:","00:00:00","00:00:00"," "]
[null,null,"Slut:","00:00:00","00:00:00"," "]
[null,null,null,null,null,null,null,null,null,"Pauser formiddag 15 min  middag 20 min"]
[null,"Søndag","Start:","00:00:00","00:00:00"]
[null,null,"Slut:",1,"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," "]
[1,"Uge dag","Start","Slut","ArbejdsTid  Incl. Pause","Overtid 50%"," Overtid 100%\nMan-lør","Overtid 100%\nSøndag","Tid Sat ind I Timebank (Afspasering= MinusTid)","Tid Indsat I Timebank, OVERTID timer","Indsæt Pause Manuel","Fri uden løn","Timer for sygeløn","Ferie Sats antal enheder","mellem regning for feriepenge","I alt",null,"Løn","I alt",null,null,null,null," "]
[{"$f":"DATE($A$3,1,7*A18-3-WEEKDAY(DATE($A$3,,),3))","v":"2021-01-04"},{"$f":"HelligdagsNavn(A19,1,1,1,1,1,1,1)","v":"Mandag"},0.29166666666666669,0.375,{"$f":"IF(WEEKDAY(A19,2)<6,ColTime($D$6,$D$7,C19,D19),0)","v":8.3333333333333315E-2},{"$f":"IF(WEEKDAY(A19,2)<6,ColTime($E$6,$E$7,C19,D19),0)","v":0},{"$f":"IF(WEEKDAY(A19,2)<6,ColTime($F$6,$F$7,C19,D19),0)","v":0},null,{"$f":"IF(E19=0,0,($D$7-$D$6)-E19)","v":0.26041666666666663},{"$f":"IF(E19=0,0,($D$7-$D$6)-($D$7-$D$6))+F19+G19","v":0},null,null,0,null,null,{"$f":"SUM(E19:G19)-IF(C19>0,D19>0)*K19","v":8.3333333333333315E-2},null,{"$f":"(((IF(E19>0,)+(P19*$B$4))+(F19*$C$4)+(G19*$D$4)+(M19*$K$4)))*24+(N19*$M$4)","v":199.99999999999997},{"$f":"SUM(R19:R25)","v":2616.6666666666661}," ",null," "]
[{"$f":"A19+1","v":"2021-01-05"},"Tirsdag",0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A20,2)<6,ColTime($D$6,$D$7,C20,D20),0)","v":0.34374999999999994},{"$f":"IF(WEEKDAY(A20,2)<6,ColTime($E$6,$E$7,C20,D20),0)","v":0},{"$f":"IF(WEEKDAY(A20,2)<6,ColTime($F$6,$F$7,C20,D20),0)","v":0},null,{"$f":"IF(E20=0,0,($D$7-$D$6)-E20)","v":0},{"$f":"IF(E20=0,0,($D$7-$D$6)-($D$7-$D$6))+F20+G20","v":0},2.4305555555555556E-2,null,0,null,null,{"$f":"SUM(E20:G20)-IF(C20>0,D20>0)*K20","v":0.31944444444444436},null,{"$f":"(((IF(E20>0,)+(P20*$B$4))+(F20*$C$4)+(G20*$D$4)+(M20*$K$4)))*24+(N20*$M$4)","v":766.66666666666652}]
["2021-01-06","Onsdag",0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A21,2)<6,ColTime($D$6,$D$7,C21,D21),0)","v":0.34374999999999994},0,{"$f":"IF(WEEKDAY(A21,2)<6,ColTime($F$6,$F$7,C21,D21),0)","v":0},null,{"$f":"IF(E21=0,0,($D$7-$D$6)-E21)","v":0},0,null,null,0,null,null,0.34374999999999994,null,{"$f":"(((IF(E21>0,)+(P21*$B$4))+(F21*$C$4)+(G21*$D$4)+(M21*$K$4)))*24+(N21*$M$4)","v":824.99999999999977}]
["2021-01-07","Torsdag",0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A22,2)<6,ColTime($D$6,$D$7,C22,D22),0)","v":0.34374999999999994},0,{"$f":"IF(WEEKDAY(A22,2)<6,ColTime($F$6,$F$7,C22,D22),0)","v":0},null,{"$f":"IF(E22=0,0,($D$7-$D$6)-E22)","v":0},{"$f":"IF(E22=0,0,($D$7-$D$6)-($D$7-$D$6))+F22+G22","v":0},null,null,0,null,null,0.34374999999999994,null,824.99999999999977]
["2021-01-08","Fredag",null,null,{"$f":"IF(WEEKDAY(A23,2)<6,ColTime($D$9,$D$10,C23,D23),0)","v":0},{"$f":"IF(WEEKDAY(A23,2)<6,ColTime($E$9,$E$10,C23,D23),0)","v":0},{"$f":"IF(WEEKDAY(A23,2)<6,ColTime($F$9,$F$10,C23,D23),0)","v":0},null,{"$f":"IF(E23=0,0,($D$10-$D$9)-E23)","v":0},{"$f":"IF(E23=0,0,($D$7-$D$6)-($D$7-$D$6))+F23+G23","v":0},null,null,0,null,null,0,null,0]
["2021-01-09","Lørdag",null,null," ","  ",{"$f":"IF(WEEKDAY(A24,2)=6,ColTime($E$12,$E$13,C24,D24),0)","v":0},null," ",{"$f":"G24","v":0},null,null," "," ",null,{"$f":"SUM(G24-K24)","v":0},null,{"$f":"(P24*$F$4)*24","v":0}]
["2021-01-10","Søndag",null,null,null," "," ",{"$f":"IF(WEEKDAY(A25,2)=7,D25-C25+(D25<C25),IF(AND(WEEKDAY(A25,2)=6,D25<C25),ColTime($E$15,$E$16,D16,D25),0))","v":0}," ",{"$f":"H25","v":0},null,null," "," ",null,{"$f":"SUM(H25-K25)","v":0},null,{"$f":"(P25*$H$4)*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uge Timer I alt",null,null,{"$f":"SUM(P19:P25)","v":1.0902777777777777}]
[]
[2,"Uge dag","Start","Slut","ArbejdsTid  Incl. Pause","Overtid 50%"," Overtid 100%\nMan-lør","Overtid 100%\nSøndag","Tid     Fratrukket Timebank (Afspasering)","Tid Indsat I Timebank, OVERTID timer","indsæt Ekstra Pause","Fri uden løn","Timer for sygeløn","Ferie Sats antal enheder","mellem regning for feriepenge","I alt",null,"Løn","I alt"]
[{"$f":"DATE($A$3,1,7*A28-3-WEEKDAY(DATE($A$3,,),3))","v":"2021-01-11"},{"$f":"HelligdagsNavn(A29,1,1,1,1,1,1,1)","v":"Mandag"},0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A29,2)<6,ColTime($D$6,$D$7,C29,D29),0)","v":0.34374999999999994},{"$f":"IF(WEEKDAY(A29,2)<6,ColTime($E$6,$E$7,C29,D29),0)","v":0},{"$f":"IF(WEEKDAY(A29,2)<6,ColTime($F$6,$F$7,C29,D29),0)","v":0},null,{"$f":"IF(E29=0,0,($D$7-$D$6)-E29)","v":0},{"$f":"IF(E29=0,0,($D$7-$D$6)-($D$7-$D$6))+F29+G29","v":0},{"$f":"K15","v":0},null,0,null,null,{"$f":"SUM(E29:G29)-IF(C29>0,D29>0)-K19-K29+I29","v":-0.65625},null,{"$f":"(((IF(E29>0,(E29-$K$15))*$B$4)+(F29*$C$4)+(G29*$D$4)+(M29*$K$4)))*24+(N29*$M$4)","v":824.99999999999977},{"$f":"SUM(R29:R35)","v":3299.9999999999991}]
[{"$f":"A29+1","v":"2021-01-12"},"Tirsdag",0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A30,2)<6,ColTime($D$6,$D$7,C30,D30),0)","v":0.34374999999999994},0,{"$f":"IF(WEEKDAY(A30,2)<6,ColTime($F$6,$F$7,C30,D30),0)","v":0},null,{"$f":"IF(E30=0,0,($D$7-$D$6)-E30)","v":0},{"$f":"IF(E30=0,0,($D$7-$D$6)-($D$7-$D$6))+F30+G30","v":0},null,null,0,null,null,{"$f":"SUM(E30:G30)-IF(C30>0,D30>0,K30>0)*$K$15-K30+I30","v":0.34374999999999994},null,{"$f":"(((IF(E30>0,(E30-$K$15))*$B$4)+(F30*$C$4)+(G30*$D$4)+(M30*$K$4)))*24+(N30*$M$4)","v":824.99999999999977}]
["2021-01-13","Onsdag",0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A31,2)<6,ColTime($D$6,$D$7,C31,D31),0)","v":0.34374999999999994},0,{"$f":"IF(WEEKDAY(A31,2)<6,ColTime($F$6,$F$7,C31,D31),0)","v":0},null,{"$f":"IF(E31=0,0,($D$7-$D$6)-E31)","v":0},0,null,null,0,null,null,{"$f":"SUM(E31:G31)-IF(C31>0,D31>0,K31>0)*$K$15-K31+I31","v":0.34374999999999994},null,824.99999999999977]
["2021-01-14","Torsdag",0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A32,2)<6,ColTime($D$6,$D$7,C32,D32),0)","v":0.34374999999999994},0,{"$f":"IF(WEEKDAY(A32,2)<6,ColTime($F$6,$F$7,C32,D32),0)","v":0},null,{"$f":"IF(E32=0,0,($D$7-$D$6)-E32)","v":0},{"$f":"IF(E32=0,0,($D$7-$D$6)-($D$7-$D$6))+F32+G32","v":0},null,null,0,null,null,{"$f":"SUM(E32:G32)-IF(C32>0,D32>0,K32>0)*$K$15-K32+I32","v":0.34374999999999994},null,824.99999999999977]
["2021-01-15","Fredag",null,null,{"$f":"IF(WEEKDAY(A33,2)<6,ColTime($D$9,$D$10,C33,D33),0)","v":0},{"$f":"IF(WEEKDAY(A33,2)<6,ColTime($E$9,$E$10,C33,D33),0)","v":0},{"$f":"IF(WEEKDAY(A33,2)<6,ColTime($F$9,$F$10,C33,D33),0)","v":0},null,{"$f":"IF(E33=0,0,($D$10-$D$9)-E33)","v":0},{"$f":"IF(E33=0,0,($D$7-$D$6)-($D$7-$D$6))+F33+G33","v":0},null,null,0,null,null,{"$f":"SUM(E33:G33)-IF(C33>0,D33>0,K33>0)*$K$15-K33+I33","v":0},null,0]
["2021-01-16","Lørdag",null,null," ","  ",{"$f":"IF(WEEKDAY(A34,2)=6,ColTime($E$12,$E$13,C34,D34),0)","v":0},null," ",{"$f":"G34","v":0},null,null," "," ",null,{"$f":"SUM(G34-K34)","v":0},null,{"$f":"(P34*$F$4)*24","v":0}]
["2021-01-17","Søndag",null,null,null," "," ",{"$f":"IF(WEEKDAY(A35,2)=7,D35-C35+(D35<C35),IF(AND(WEEKDAY(A35,2)=6,D35<C35),ColTime($E$15,$E$16,#REF!,D35),0))","v":0}," ",{"$f":"H35","v":0},null,null," "," ",null,{"$f":"SUM(H35-K35)","v":0},null,{"$f":"(P35*$H$4)*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uge Timer I alt",null,null,{"$f":"SUM(P29:P35)","v":0.37499999999999983}]
[]
[3,"Uge dag","Start","Slut","ArbejdsTid  Incl. Pause","Overtid 50%"," Overtid 100%\nMan-lør","Overtid 100%\nSøndag","Tid     Fratrukket Timebank (Afspasering)","Tid Indsat I Timebank, OVERTID timer","indsæt Ekstra Pause","Fri uden løn","Timer for sygeløn","Ferie Sats antal enheder","mellem regning for feriepenge","I alt",null,"Løn","I alt","Januar ","Tid "]
[{"$f":"DATE($A$3,1,7*A38-3-WEEKDAY(DATE($A$3,,),3))","v":"2021-01-18"},{"$f":"HelligdagsNavn(A39,1,1,1,1,1,1,1)","v":"Mandag"},0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A39,2)<6,ColTime($D$6,$D$7,C39,D39),0)","v":0.34374999999999994},{"$f":"IF(WEEKDAY(A39,2)<6,ColTime($E$6,$E$7,C39,D39),0)","v":0},{"$f":"IF(WEEKDAY(A39,2)<6,ColTime($F$6,$F$7,C39,D39),0)","v":0},null,{"$f":"IF(E39=0,0,($D$7-$D$6)-E39)","v":0},{"$f":"IF(E39=0,0,($D$7-$D$6)-($D$7-$D$6))+F39+G39","v":0},null,null,0,null,null,{"$f":"SUM(E39:G39)-IF(C39>0,D39>0,K39>0)*$K$15-K39+I39","v":0.34374999999999994},null,{"$f":"(((IF(E39>0,(E39-$K$15))*$B$4)+(F39*$C$4)+(G39*$D$4)+(M39*$K$4)))*24+(N39*$M$4)","v":824.99999999999977},{"$f":"SUM(R39:R40)","v":1649.9999999999995},"Løn","For Perioden"]
[{"$f":"A39+1","v":"2021-01-19"},"Tirsdag",0.29166666666666669,0.63541666666666663,{"$f":"IF(WEEKDAY(A40,2)<6,ColTime($D$6,$D$7,C40,D40),0)","v":0.34374999999999994},0,{"$f":"IF(WEEKDAY(A40,2)<6,ColTime($F$6,$F$7,C40,D40),0)","v":0},null,0,0,null,null,0,null,null,0.34374999999999994,null,824.99999999999977,null,{"$f":"SUM(S19:S40)","v":7566.6666666666642},{"$f":"SUM(P19:P25,P29:P35,P39:P40)","v":2.1527777777777777}]
["2021-01-20","Onsdag",null,null,{"$f":"IF(WEEKDAY(A41,2)<6,ColTime($D$6,$D$7,C41,D41),0)","v":0},0,{"$f":"IF(WEEKDAY(A41,2)<6,ColTime($F$6,$F$7,C41,D41),0)","v":0},null,0,0,null,null,0,null,null,0,null,0,{"$f":"SUM(R41:R45)","v":0}]
["2021-01-21","Torsdag",null,null,{"$f":"IF(WEEKDAY(A42,2)<6,ColTime($D$6,$D$7,C42,D42),0)","v":0},0,{"$f":"IF(WEEKDAY(A42,2)<6,ColTime($F$6,$F$7,C42,D42),0)","v":0},null,0,0,null,null,0,null,null,0,null,0]
["2021-01-22","Fredag",null,null,{"$f":"IF(WEEKDAY(A43,2)<6,ColTime($D$9,$D$10,C43,D43),0)","v":0},{"$f":"IF(WEEKDAY(A43,2)<6,ColTime($E$9,$E$10,C43,D43),0)","v":0},{"$f":"IF(WEEKDAY(A43,2)<6,ColTime($F$9,$F$10,C43,D43),0)","v":0},null,{"$f":"IF(E43=0,0,($D$10-$D$9)-E43)","v":0},0,null,null,0,null,null,0,null,0]
["2021-01-23","Lørdag",null,null," ","  ",{"$f":"IF(WEEKDAY(A44,2)=6,ColTime($E$12,$E$13,C44,D44),0)","v":0},null," ",{"$f":"G44","v":0},null,null," "," ",null,{"$f":"SUM(G44-K44)","v":0},null,{"$f":"(P44*$F$4)*24","v":0}]
["2021-01-24","Søndag",null,null,null," "," ",{"$f":"IF(WEEKDAY(A45,2)=7,D45-C45+(D45<C45),IF(AND(WEEKDAY(A45,2)=6,D45<C45),ColTime($E$15,$E$16,#REF!,D45),0))","v":0}," ",{"$f":"H45","v":0},null,null," "," ",null,{"$f":"SUM(H45-K45)","v":0},null,{"$f":"(P45*$H$4)*24","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Uge Timer I alt",null,null,{"$f":"SUM(P39:P45)","v":0.68749999999999989}]

{"sheet":"Januar","index":1,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!T40","v":7566.6666666666642}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":7566.6666666666642},{"$f":"SUM(B23*D10/100)","v":945.83333333333303}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":7566.6666666666642},{"$f":"SUM(B24*D9/100)","v":699.9166666666664}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":7566.6666666666642},null,{"$f":"SUM(B25*D7/100)","v":302.66666666666657}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":7566.6666666666642},{"$f":"SUM(B26*D11/100)","v":397.24999999999983}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":9212.4166666666624},null,null,{"$f":"SUM(B27*D6/100)","v":368.4966666666665}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":7150.6899999999969},null,{"$f":"SUM(C31*D8/100)","v":572.05519999999979}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":6531.4447999999975}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":6531.4447999999975}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":6531.4447999999975}]
[]
["Skat:","39 % af",{"$f":"+D36","v":6531.4447999999975},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":2547}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":3934.4447999999975}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":6406.8947999999973}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":7150.6899999999969},null,{"$f":"SUM(C49)","v":7150.6899999999969}]
["A-Indkomst",null,{"$f":"+D34","v":6531.4447999999975},null,6531.4447999999975]
["A Skat",null,{"$f":"+E38","v":2547},null,2547]
["AM bidrag",null,{"$f":"+E31","v":572.05519999999979},null,572.05519999999979]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":7566.6666666666642},null,7566.6666666666642]
["FerieOpsparing",null,{"$f":"C23","v":945.83333333333303},null,945.83333333333303]

{"sheet":"Februar","index":2,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"Marts","index":3,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"April","index":4,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"Maj","index":5,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"Juni","index":6,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"Juli","index":7,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"August","index":8,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"September","index":9,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"Oktober","index":10,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"November","index":11,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"December","index":12,"n_rows":54,"n_cols":5,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Lønseddel"]
[]
[]
[null,null,"Trækprocent: ",39]
[null,null,"M.fradrag:",0]
[null,null,"Indu. Pension",4]
[null,null,"Pen. Fritvalg",4]
[null,null,"AM Bidrag",8]
[null,null,"fritvalg",9.25]
[null,null,"Ferieopsparing",12.5]
[null,null,"Fritvalg timeløn",5.25]
[]
[]
["LØN",null,null,null,{"$f":"LønOgTimeberegning!#REF!","v":{"$error":"#REF!"}}]
[]
["Sygeløn"]
[" overtid"," ",null," "," "]
["Feriefridag"]
[]
[]
[null,null,null," "," "]
["Arbejderskiver sundhedfor.",null,47.19," "," "]
["Ferie penge 12.5%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B23*D10/100)","v":{"$error":"#REF!"}}," "," "]
["Fritvalg 9,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B24*D9/100)","v":{"$error":"#REF!"}}]
["pension betaling Fritvalg 4 %",{"$f":"E14","v":{"$error":"#REF!"}},null,{"$f":"SUM(B25*D7/100)","v":{"$error":"#REF!"}}]
["Fritvalg konto timeløn 5,25%",{"$f":"E14","v":{"$error":"#REF!"}},{"$f":"SUM(B26*D11/100)","v":{"$error":"#REF!"}}]
["Industriens pension 4%",{"$f":"SUM(E14,C23,C24)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(B27*D6/100)","v":{"$error":"#REF!"}}]
["Atp bidrag ",{"$f":"D14","v":0},null,null,94.67]
[]
["Ferieberettiget indkomst"]
["Arbejdsmarkedsbidrag:",null,{"$f":"E14-E27-E28+C22","v":{"$error":"#REF!"}},null,{"$f":"SUM(C31*D8/100)","v":{"$error":"#REF!"}}]
["Nettoløn:",null,null,null,{"$f":"E14-SUM(E17:E31)","v":{"$error":"#REF!"}}]
[]
["A-skattepligtig indkomst",null,null,{"$f":"+E32","v":{"$error":"#REF!"}}]
["Månedligt fradrag:",null,null,{"$f":"D5","v":0}]
["Skattegrundlag:",null,null,{"$f":"+D34-D35","v":{"$error":"#REF!"}}]
[]
["Skat:","39 % af",{"$f":"+D36","v":{"$error":"#REF!"}},null,{"$f":"ROUND(+(C38/100)*D4,0)","v":{"$error":"#REF!"}}]
[]
[null,"Personale foreningen",50,null,{"$f":"C40","v":50}]
["Løn til udbetaling:",null,null,null,{"$f":"+E32-SUM(E38:E40)","v":{"$error":"#REF!"}}]
[]
["Industrien pension udbetaling",2740,-0.47,{"$f":"SUM(B43*47/100)","v":1287.8},{"$f":"SUM(B43-D43)","v":1452.2}]
["Atp udbetaling ",1925,-0.47,{"$f":"SUM(B44*47/100)","v":904.75},{"$f":"SUM(B44-D44)","v":1020.25}]
[]
["Løn udbetaling total",null,null,null,{"$f":"SUM(E41:E44)","v":{"$error":"#REF!"}}]
[]
["Saldi:",null,"Perioden",null,"År til dato"]
["AM indkomst",null,{"$f":"+C31","v":{"$error":"#REF!"}},null,{"$f":"SUM(C49)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,{"$f":"+D34","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["A Skat",null,{"$f":"+E38","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["AM bidrag",null,{"$f":"+E31","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["Ferieberettiget indkomst",null,{"$f":"SUM(E14)","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]
["FerieOpsparing",null,{"$f":"C23","v":{"$error":"#REF!"}},null,{"$error":"#REF!"}]

{"sheet":"Hele Året","index":13,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
["Saldi:",null,null,"År til dato"]
["AM indkomst",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["A-Indkomst",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["A Skat",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["AM bidrag",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["Ferieberettiget indkomst",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
["FerieOpsparing",null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]