{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Vejledning","Lønseddel","Løn inkl. alle tillæg"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Vejledning","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Tab name","Description"]
["Wage known","Use this field if you know the gross amount and want to check the correctness of holiday pay, SH, FF and pension amounts.The fields known the hours and the pay and provide guidance regarding earnings."]
["Pension contribution known","Used for 'reverse' calculation based on a gross pension amount."]
["Holiday pay known","Used for 'reverse' calculation based on a gross holiday pay amount."]
["SH and FH amounts known","Used for 'reverse' calculation based on gross SH and FF amounts."]
["Holiday pay , SH and FF anmounts known","Used for 'reverse' calculation based on gross holiday pay, SH and FF amounts."]
["Net amount known","Used for 'reverse' calculation based on a net amount, requiring knowledge of tax rate and standard wage-earner allowance."]
["Working day calculator","Used to calculate the number of working days in a specific period between two dates, followed by deduction of days of leave and discretionary holidays. And on the basis of the hourly rate obtained to calculate wages, holiday pay, pay for work on weekday holidays and discretionary holiday as well as pension in the period specified."]

{"sheet":"Lønseddel","index":1,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,"Units",null,"Rate","Total"]
["Wage",66.5,null,275,{"$f":"SUM(B2*D2)","v":18287.5}]
[]
["Piecework surplus",1,null,9500,{"$f":"SUM(B4*D4)","v":9500}]
[]
["Overtime with 50% allowance",8,0.5,{"$f":"SUM($D$2*C6)","v":137.5},{"$f":"SUM(B6*D6)","v":1100}]
["Overtime with 100% allowance",12,1,{"$f":"SUM($D$2*C7)","v":275},{"$f":"SUM(B7*D7)","v":3300}]
[]
["Sick pay ",7.5,null,133,{"$f":"SUM(B9*D9)","v":997.5}]
[]
["Shelter money",3,null,57.5,{"$f":"SUM(B11*D11)","v":172.5}]
["Shelter money",2,null,90,{"$f":"SUM(B12*D12)","v":180}]
[]
["Transport time",225,null,0.75,{"$f":"SUM(B14*D14)","v":168.75}]
[]
["Taxable mileage allowance *",100,null,2.1,{"$f":"SUM(B16*D16)","v":210}]
[]
[null,"Rate"]
["Wages with holiday entitlement",null,{"$f":"SUM(E2:E14)","v":33706.25},null,{"$f":"SUM(E2:E16)","v":33916.25}]
[]
["Holiday allowance",0.125,{"$f":"SUM(C19*B21)","v":4213.28125}]
[]
["Pay for work on weekly holidays and discretionary holidays",6.9000000000000006E-2,{"$f":"SUM(C19*B23)","v":2325.7312500000003}]
[]
["Pension basis ",null,{"$f":"SUM(C19:C23)+E16","v":40455.262499999997}]
[]
["Pension - employer ",8.1500000000000003E-2,{"$f":"SUM(C25*B27)","v":3297.1038937499998}]
[]
["Pension - employee",0.04,{"$f":"SUM(C25*B29)","v":1618.2104999999999},null,{"$f":"-SUM(C29)","v":-1618.2104999999999}]
[]
["ATP contributions - employee",null,null,null,-90]
[null,null,"Rate"]
["Compulsory labour market contribution ",{"$f":"SUM(E19:E31)","v":32208.039499999999},0.08,null,{"$f":"-SUM(B33*C33)","v":-2576.6431600000001}]
[]
["G-days",3,null,788,{"$f":"SUM(B35*D35)","v":2364}]
[]
["Tax deduction ",-7500,null,{"$f":"SUM(B33,E33,E35)","v":31995.396339999999}]
[]
["A-tax",null,0.42,{"$f":"SUM(B37:D37)","v":24495.396339999999},{"$f":"-SUM(D39*C39)","v":-10288.066462799999}]
[]
[null,"Units",null,"Rate"]
["Tax exempt mileage allowance",100,null,2.1,{"$f":"SUM(B42*D42)","v":210}]
[]
["Tax exempt subsistence allowance",3,null,275,{"$f":"SUM(B44*D44)","v":825}]
[]
["Net pay",null,null,null,{"$f":"SUM(E19:E42)","v":21917.329877199998}]
[]
["* Taxable mileage allowence include pension entitlements, but not entitlements to payment for work on weekday holidays or discretionary holidays."]

{"sheet":"Løn inkl. alle tillæg","index":2,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,3,4],[17,0,18,4]]}
[]
["Wages include all supplements set out in collective agreements"]
["Insert the average wage in DKK from the national website www.workplacedenmark.dk for the job in quistion in the region in question (or the wage agreed; see clause 2"]
[null,null,null,null,null,295]
[null,null,null,"Pension",0.10150000000000001]
[null,null,null,"Wage excl. Pension",null,{"$f":"F4/(1+SUM(E5))","v":267.81661370857921}]
[null,null,null,"Work on week holidays",0.14699999999999999]
[null,null,null,"Holiday pay",0.125]
["Basic hourly rate excl. of holiday pay, pay for word on weekhlidays",null,null,"weekholidays",{"$f":"F6/(1+SUM(E7,E8))","v":210.54765228661887}]
[]
["The wage amounts is the worker's basic hourly rate payable at the end of each pay periode."]
[]
["If overtime pay or other variable supplements have been accrued, they must be addede to the basic hourly rate."]
[]
[]
["Gross pay inclusive of variable supplements"]
[]
["The total gross wage earned by the worker in the pay period, incl. of variable work supplements (for example, staggered hours and overtime wor), to be insertede here, DKK"]
[null,null,null,null,null,28000]
[]
[]
["Of the gross pay for the period, holiday pay amounts",null,null,"to DKK",{"$f":"SUM($E$8)","v":0.125},{"$f":"SUM(F19*E22)","v":3500}]
["Of the gross pay for the period, payment for work on weekday holidays amounts to",null,"ment for work on weekday holidays amunts to DKK","weekday holidays amounnt to DKK",{"$f":"SUM($E$7)","v":0.14699999999999999},{"$f":"SUM(F19*E23)","v":4116}]
["Of the gross pay for the period, pension contributions amount to DKK",null,null,null,{"$f":"SUM($E$5)","v":0.10150000000000001},{"$f":"SUM(E25*E24)","v":3615.0240000000003}]
[null,null,null,null,{"$f":"SUM(F19+F22+F23)","v":35616}]
[null,"Deferred pay to be paid to the 3F Holiday Fund",null,null,{"$f":"SUM(F22+F23+F24)","v":11231.024000000001},"DKK"]