{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Hour Registration","Holidays"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":"Hour Registration","index":0,"n_rows":38,"n_cols":29,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Mon-Thu",null,"Mon-Thu",null,"Friday",null,"Weekdays",null,"Saturday",null,"Saturday",null,"Sunday",null,"Holiday"]
[null,"Day","Date","From time","To time","B","Hours","B","16-18 (20%)","B","18-21 (40%)","B","16-21 (40%) ","B","21-07 (100%)","B","-15:30 (100%)","B","15:30 - 24:00 (130%)","B","-24:00 (130%)","B","-24:00 (140 %)","Wage"]
[null,{"$f":"IF(C3<>\"\",PROPER(TEXT(C3,\"dddd\")),\"\")","v":"Lørdag"},"2021-05-01","06:00:00","14:00:00","x",{"$f":"HoursInInterval($D3,$E3)-IF(F3=\"x\",Lunch,0)","v":7.5},null,{"$f":"HoursInInterval($D3,$E3,16,18,$C3,MonThu)-IF(H3=\"x\",Lunch,0)","v":0},null,{"$f":"HoursInInterval($D3,$E3,18,21,$C3,MonThu)-IF(J3=\"x\",Lunch,0)","v":0},null,{"$f":"HoursInInterval($D3,$E3,16,21,$C3,Fri)-IF(L3=\"x\",Lunch,0)","v":0},null,{"$f":"HoursInInterval($D3,$E3,21,20,$C3,Weekday)-IF(N3=\"x\",Lunch,0)","v":0},null,{"$f":"HoursInInterval($D3,$E3,0,15.5,$C3,Sat)-IF(P3=\"x\",Lunch,0)","v":8},null,{"$f":"HoursInInterval($D3,$E3,15.5,7,$C3,Sat)-IF(R3=\"x\",Lunch,0)","v":0},null,{"$f":"HoursInInterval($D3,$E3,0,0,$C3,Sun)-IF(T3=\"x\",Lunch,0)","v":0},null,{"$f":"HoursInInterval($D3,$E3,0,0,$C3,Holiday)-IF(V3=\"x\",Lunch,0)","v":0},{"$f":"G3*$AA$4+I3*$AA$5+K3*$AA$6+O3*$AA$7+M3*$AA$9+Q3*$AA$7+S3*$AA$11+U3*$AA$11+W3*$AA$13","v":310},null,"Description","Amount","Percentage"]
[null,{"$f":"IF(C4<>\"\",PROPER(TEXT(C4,\"dddd\")),\"\")","v":"Søndag"},"2021-05-02","02:00:00","03:00:00",null,{"$f":"HoursInInterval($D4,$E4)-IF(F4=\"x\",Lunch,0)","v":1},null,0,null,0,null,0,null,0,null,0,null,0,null,1,null,0,{"$f":"G4*$AA$4+I4*$AA$5+K4*$AA$6+O4*$AA$7+M4*$AA$9+Q4*$AA$7+S4*$AA$11+U4*$AA$11+W4*$AA$13","v":46},null,"Hourly wage",20,null,3]
[null,"Mandag","2021-05-03","09:00:00","12:00:00",null,{"$f":"HoursInInterval($D5,$E5)-IF(F5=\"x\",Lunch,0)","v":3},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,60,null,"Weekdays 16-18",{"$f":"$AA$4*AB5","v":4},0.2,4]
[null,"Tirsdag","2021-05-04","20:00:00","06:00:00",null,{"$f":"HoursInInterval($D6,$E6)-IF(F6=\"x\",Lunch,0)","v":10},null,0,null,1,null,0,null,9,null,0,null,0,null,0,null,0,385,null,"Monday -Thursday 18-21",{"$f":"$AA$4*AB6","v":5},0.25,5]
[null,"Onsdag","2021-05-05","12:00:00","19:00:00",null,{"$f":"HoursInInterval($D7,$E7)-IF(F7=\"x\",Lunch,0)","v":7},null,2,null,1,null,0,null,0,null,0,null,0,null,0,null,0,153,null,"Weekdays 21-00",{"$f":"$AA$4*AB7","v":20},1,6]
[null,"Torsdag","2021-05-06","15:00:00","23:00:00",null,8,null,2,null,3,null,0,null,2,null,0,null,0,null,0,null,0,223,null,null,null,null,7]
[null,"Fredag","2021-05-07","22:00:00","04:30:00",null,6.5,null,0,null,0,null,0,null,6.5,null,0,null,0,null,0,null,0,260,null,"Friday 16-21",{"$f":"$AA$4*AB9","v":8},0.4,8]
[null,"Lørdag","2021-05-08","12:00:00","02:00:00",null,14,null,0,null,0,null,0,null,0,null,3.5,null,10.5,null,0,null,0,623,null,"Saturday to 1530",{"$f":"$AA$4*AB10","v":20},1,9]
[null,"Søndag","2021-05-09","12:30:00","18:00:00",null,5.5,null,0,null,0,null,0,null,0,null,0,null,0,null,5.5,null,0,253,null,"Saturday from 1530 and Sunday",{"$f":"$AA$4*AB11","v":26},1.3,10]
[null,"Mandag","2021-05-10","22:00:00","08:00:00","x",9.5,null,0,null,0,null,0,"x",9.5,null,0,null,0,null,0,null,0,380,null,null,null,null,11]
[null,"Tirsdag","2021-05-11","08:00:00","16:00:00","x",7.5,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,150,null,"Holiday",{"$f":"$AA$4*AB13","v":28},1.4,12]
[null,"Onsdag","2021-05-12","20:00:00","06:00:00",null,10,null,0,null,1,null,0,null,9,null,0,null,0,null,0,null,0,385]
[null,"Torsdag","2021-05-13","12:00:00","22:00:00",null,10,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,10,480,null,"Tax percentage",0.36]
[null,"Fredag","2021-05-14","12:00:00","15:00:00",null,3,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,60]
[null,"Lørdag","2021-05-15","22:00:00","04:30:00",null,6.5,null,0,null,0,null,0,null,0,null,0,null,6.5,null,0,null,0,299,null,"Lunch (hours)",0.5]
[null,"Søndag","2021-05-16","12:00:00","02:00:00",null,14,null,0,null,0,null,0,null,0,null,0,null,0,null,14,null,0,644]
[null,"Mandag","2021-05-17","06:00:00","18:00:00",null,12,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,12,576]
[null,"Tirsdag","2021-05-18","20:00:00","07:00:00",null,11,null,0,null,1,null,0,null,10,null,0,null,0,null,0,null,0,425]
[null,"Onsdag","2021-05-19","08:00:00","16:00:00",null,8,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,160]
[null,"Torsdag","2021-05-20",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Fredag","2021-05-21","05:00:00","06:00:00",null,1,null,5,null,0,null,0,null,0,null,0,null,0,null,0,null,0,40]
[null,"Lørdag","2021-05-22","05:00:00","07:00:00",null,2,null,0,null,0,null,0,null,0,null,2,null,0,null,0,null,0,80]
[null,"Søndag","2021-05-23","00:00:00",null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Mandag","2021-05-24",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Tirsdag","2021-05-25",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Onsdag","2021-05-26",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Torsdag","2021-05-27",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Fredag","2021-05-28",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Lørdag","2021-05-29",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Søndag","2021-05-30",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"Mandag","2021-05-31",null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,"",null,null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,0]
[null,null,null,null,"Sum",null,{"$f":"SUM(G3:G33)","v":157},null,9,null,7,null,0,null,46,null,13.5,null,17,null,20.5,null,22,{"$f":"SUM(X3:X35)","v":5992}]
[null,null,null,null,"Tax",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X36*AA15","v":2157.12}]
[null,null,null,null,"Net",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X36-X37","v":3834.88}]

{"sheet":"Holidays","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Date","Description",null,"Year",null,"Day (Interval)","Code"]
[{"$f":"DATE(ThisYear,1,1)","v":"2021-01-01"},"1st New Year's Day",null,{"$f":"YEAR(NOW())","v":2021},null,"Monday",1]
[{"$f":"A5-3","v":"2021-04-01"},"Maundy Thursday",null,null,null,"Tuesday",2]
[{"$f":"A5-2","v":"2021-04-02"},"Good Friday",null,null,null,"Wednesday",3]
[{"$f":"EasterDate(ThisYear)","v":"2021-04-04"},"1st day of Easter",null,null,null,"Thursday",4]
[{"$f":"A5+1","v":"2021-04-05"},"2nd day of Easter",null,null,null,"Friday",5]
[{"$f":"DATE(ThisYear,5,13)","v":"2021-05-13"},"Ascension",null,null,null,"Saturday",6]
[{"$f":"A5+49","v":"2021-05-23"},"1st day of Pentecost",null,null,null,"Sunday",7]
[{"$f":"A8+1","v":"2021-05-24"},"2. Pentecost",null,null,null,"Weekday",8]
[{"$f":"DATE(ThisYear,12,25)","v":"2021-12-25"},"1st of Christmas",null,null,null,"Weekend",9]
[{"$f":"DATE(ThisYear,12,26)","v":"2021-12-26"},"2nd Christmas Day",null,null,null,"Holiday",10]
[{"$f":"DATE(ThisYear,5,17)","v":"2021-05-17"},"17th of May",null,null,null,"ManThu",11]