{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Timeseddel","T","Setup"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":1,"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":"Timeseddel","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,1],[46,6,46,8],[47,6,47,8],[41,4,41,5],[42,4,42,5],[41,6,41,8],[42,6,42,8],[43,6,43,8],[44,6,44,8],[45,6,45,8],[43,4,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[49,4,49,5],[36,6,36,8],[37,6,37,8],[38,6,38,8],[39,6,39,8],[40,6,40,8],[31,6,31,8],[32,6,32,8],[33,6,33,8],[34,6,34,8],[35,6,35,8],[27,6,27,8],[28,6,28,8],[29,6,29,8],[30,6,30,8],[29,4,29,5],[30,4,30,5],[7,0,7,3],[1,0,1,2],[3,1,3,3],[5,1,5,3],[26,6,26,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[13,4,13,5],[15,4,15,5],[20,6,20,8],[21,6,21,8],[22,6,22,8],[16,7,16,8],[18,6,18,8],[19,6,19,8],[17,6,17,8],[17,4,17,5],[18,4,18,5],[19,4,19,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[8,6,8,8],[15,6,15,8],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[2,12,2,21],[4,12,5,12],[4,13,4,14],[4,16,4,17],[4,20,4,21]]}
[]
["Timeseddel"]
[]
["Cpr-nr. : ",null,null,null,"År:",2022,"Måned: ","Januar",{"$f":"IF(H4=\"Januar\",1,IF(H4=\"Februar\",2,IF(H4=\"Marts\",3,IF(H4=\"April\",4,IF(H4=\"Maj\",5,IF(H4=\"Juni\",6,IF(H4=\"Juli\",7,IF(H4=\"August\",8,IF(H4=\"September\",9,IF(H4=\"Oktober\",10,IF(H4=\"November\",11,IF(H4=\"December\",12,\"\"))))))))))))","v":1}]
[]
["Navn : ","Dit navn"]
[]
["Regulering til sidste måned"]
["Dato","Dag","Timer","Overtid\n3210\nEfter kl. 17","Overtid\n3230\nWeekend",null,"Bemærkninger"]
[null,{"$f":"IF(A10=\"\",\"\",IFERROR(CHOOSE(WEEKDAY(A10,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\"))","v":""}]
[null,{"$f":"IF(A11=\"\",\"\",IFERROR(CHOOSE(WEEKDAY(A11,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\"))","v":""}]
[null,""]
[null,""]
[null,""]
[]
["Dato","Dag","Timer","Overtid\n3210\nEfter kl. 17","Overtid\n3230\nWeekend",null,"Bemærkninger"]
[]
[{"$f":"DATE(F4,I4,1)","v":"2022-01-01"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A18,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Lø"}]
[{"$f":"A18+1","v":"2022-01-02"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A19,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Sø"}]
[{"$f":"A19+1","v":"2022-01-03"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A20,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Ma"}]
["2022-01-04","Ti"]
["2022-01-05","On"]
["2022-01-06","To"]
["2022-01-07","Fr"]
[{"$f":"A24+1","v":"2022-01-08"},"Lø"]
["2022-01-09","Sø"]
["2022-01-10","Ma"]
["2022-01-11","Ti"]
["2022-01-12","On"]
["2022-01-13","To"]
["2022-01-14","Fr"]
["2022-01-15","Lø"]
["2022-01-16","Sø"]
["2022-01-17","Ma"]
["2022-01-18","Ti"]
["2022-01-19","On"]
["2022-01-20","To"]
["2022-01-21","Fr"]
["2022-01-22","Lø"]
["2022-01-23","Sø"]
["2022-01-24","Ma"]
["2022-01-25","Ti"]
["2022-01-26","On"]
["2022-01-27","To"]
["2022-01-28","Fr"]
[{"$f":"IF(MONTH(A45+1)>MONTH(A45),\"\",A45+1)","v":"2022-01-29"},"Lø"]
[{"$f":"IF(A46=\"\",\"\",IF(MONTH(A46+1)>MONTH(A46),\"\",A46+1))","v":"2022-01-30"},"Sø"]
[{"$f":"IF(A47=\"\",\"\",IF(MONTH(A47+1)>MONTH(A47),\"\",A47+1))","v":"2022-01-31"},"Ma"]
[]
["Timer i alt : ",null,{"$f":"SUM(C10:C48)","v":0},{"$f":"SUM(D10:D48)","v":0},{"$f":"SUM(F10:F48)","v":0}]

{"sheet":"T","index":1,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,0,0,1]]}
[null,null,null,"Norm"]
["Januar",1,null,"Mandag",7]
["Februar",2,null,"Tirsdag",8]
["Marts",3,null,"Onsdag",8]
["April",4,null,"Torsdag",8]
["Maj",5,null,"Fredag",6]
["Juni",6,null,"Lørdag",0]
["Juli",7,null,"Søndag",0]
["August",8,null,null,{"$f":"SUM(E2:E8)","v":37}]
["September",9]
["Oktober",10]
["November",11]
["December",12]

{"sheet":"Setup","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,3,0,4],[8,0,9,0]]}
["Til","modtagerens mail adresse","B1"]
["Cc",null,"B2"]
["Bcc",null,"B3"]
["Emne linjen",{"$f":"\"Timeseddel - \"&Timeseddel!B6&\" - År : \"&Timeseddel!F4&\" - Måned : \"&Timeseddel!H4","v":"Timeseddel - Dit navn - År : 2022 - Måned : Januar"},"B4"]
["Lagrings Mappe sti","E:\\Egne Regneark\\Arbejdsseddel\\PDF timeseddel","B5"]
["PDF gemme navn",{"$f":"IF(Timeseddel!I4>9,Timeseddel!B6&\" - \"&\"Timeseddel - \"&Timeseddel!F4&\" - \"&Timeseddel!I4&\" - \"&Timeseddel!H4,Timeseddel!B6&\" - \"&\"Timeseddel - \"&Timeseddel!F4&\" - 0\"&Timeseddel!I4&\" - \"&Timeseddel!H4)","v":"Dit navn - Timeseddel - 2022 - 01 - Januar"},"B6"]
[null,null,"B7"]
[null,null,"B8"]
[]
[]
[]
["Mail tekst","Hej Regnskabsfører.\r\n\r\nJeg sender hermed min Timeseddel for september.\r\n\r\nMed venlig hilsen\r\n\r\nxxxxxxxx\r\n\r\n\r\n\r\n","B12"]