{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Timeseddel","T","Setup","Ark3"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":1,"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":"Timeseddel","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[47,8,47,10],[48,8,48,10],[42,6,42,7],[43,6,43,7],[42,8,42,10],[43,8,43,10],[44,8,44,10],[45,8,45,10],[46,8,46,10],[37,8,37,10],[38,8,38,10],[39,8,39,10],[40,8,40,10],[41,8,41,10],[41,6,41,7],[37,6,37,7],[38,6,38,7],[47,6,47,7],[48,6,48,7],[45,6,45,7],[46,6,46,7],[44,6,44,7],[39,6,39,7],[40,6,40,7],[28,8,28,10],[29,8,29,10],[30,8,30,10],[31,8,31,10],[30,6,30,7],[31,6,31,7],[32,8,32,10],[33,8,33,10],[34,8,34,10],[35,8,35,10],[36,8,36,10],[7,0,7,5],[1,0,1,4],[3,1,3,5],[5,1,5,5],[27,8,27,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[14,6,14,7],[16,6,16,7],[21,8,21,10],[22,8,22,10],[11,6,11,7],[12,6,12,7],[13,6,13,7],[23,8,23,10],[17,9,17,10],[19,8,19,10],[20,8,20,10],[18,8,18,10],[18,6,18,7],[19,6,19,7],[20,6,20,7],[9,8,9,10],[16,8,16,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[13,8,13,10],[14,8,14,10],[15,8,15,10],[9,6,9,7],[10,6,10,7],[8,0,8,10],[51,2,51,3],[50,0,50,1],[50,6,50,7],[25,6,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[32,6,32,7],[33,6,33,7],[34,6,34,7],[35,6,35,7],[36,6,36,7]]}
[]
[]
[]
["Cpr-nr. : ",null,null,null,null,null,"År:",2020,"Måned: ","August",{"$f":"IF(J4=\"Januar\",1,IF(J4=\"Februar\",2,IF(J4=\"Marts\",3,IF(J4=\"April\",4,IF(J4=\"Maj\",5,IF(J4=\"Juni\",6,IF(J4=\"Juli\",7,IF(J4=\"August\",8,IF(J4=\"September\",9,IF(J4=\"Oktober\",10,IF(J4=\"November\",11,IF(J4=\"December\",12,\"\"))))))))))))","v":8}]
[]
["Navn : ","Mig selv"]
[]
["Regulering til sidste måned"]
[]
["Dato","Dag","Timer\nRengøring","Ekstra \nRengøring","Timer","Overtid \n3210\nEfter kl. 17","Overtid \n3230\nWeekend",null,"Bemærkninger"]
[null,{"$f":"IF(A11=\"\",\"\",IFERROR(CHOOSE(WEEKDAY(A11,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\"))","v":""}]
[null,{"$f":"IF(A12=\"\",\"\",IFERROR(CHOOSE(WEEKDAY(A12,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\"))","v":""}]
[null,""]
[null,""]
[null,""]
[]
["Dato","Dag","Timer\nRengøring","Ekstra \nRengøring","Timer","Overtid \n3210\nEfter kl. 17","Overtid \n3230\nWeekend",null,"Bemærkninger"]
[]
[{"$f":"DATE(H4,K4,1)","v":"2020-08-01"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A19,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Lø"}]
[{"$f":"A19+1","v":"2020-08-02"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A20,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Sø"}]
[{"$f":"A20+1","v":"2020-08-03"},{"$f":"IFERROR(CHOOSE(WEEKDAY(A21,11),\"Ma\",\"Ti\",\"On\",\"To\",\"Fr\",\"Lø\",\"Sø\"),\"\")","v":"Ma"}]
["2020-08-04","Ti"]
["2020-08-05","On"]
["2020-08-06","To"]
["2020-08-07","Fr"]
[{"$f":"A25+1","v":"2020-08-08"},"Lø"]
["2020-08-09","Sø"]
["2020-08-10","Ma"]
["2020-08-11","Ti"]
["2020-08-12","On"]
["2020-08-13","To"]
["2020-08-14","Fr"]
["2020-08-15","Lø"]
["2020-08-16","Sø"]
["2020-08-17","Ma"]
["2020-08-18","Ti"]
["2020-08-19","On"]
["2020-08-20","To"]
["2020-08-21","Fr"]
["2020-08-22","Lø"]
["2020-08-23","Sø"]
["2020-08-24","Ma"]
["2020-08-25","Ti"]
["2020-08-26","On"]
["2020-08-27","To"]
["2020-08-28","Fr"]
[{"$f":"IF(MONTH(A46+1)>MONTH(A46),\"\",A46+1)","v":"2020-08-29"},"Lø"]
[{"$f":"IF(A47=\"\",\"\",IF(MONTH(A47+1)>MONTH(A47),\"\",A47+1))","v":"2020-08-30"},"Sø"]
[{"$f":"IF(A48=\"\",\"\",IF(MONTH(A48+1)>MONTH(A48),\"\",A48+1))","v":"2020-08-31"},"Ma"]
[]
["Timer i alt : ",null,{"$f":"SUM(C11:C49)","v":0},{"$f":"SUM(D11:D49)","v":0},0,0,0]
[null,null,"Samlet Timer : ",null,{"$f":"SUM(C51:E51)","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","laptop@outlook.dk","B1"]
["Cc",null,"B2"]
["Bcc",null,"B3"]
["Emne linjen",{"$f":"\"Timeseddel - \"&Timeseddel!B6&\" - År : \"&Timeseddel!H4&\" - Måned : \"&Timeseddel!J4","v":"Timeseddel - Mig selv - År : 2020 - Måned : August"},"B4"]
["Lagrings Mappe sti","\\\\DLINK-24CF61\\Volume_1\\Privat\\Mine Dokumenter\\Egne Regneark\\Arbejdsseddel\\Nexø kirke\\peter\\Timesedler","B5"]
["PDF gemme navn",{"$f":"IF(Timeseddel!K4>9,Timeseddel!B6&\" - \"&\"Timeseddel - \"&Timeseddel!H4&\" - \"&Timeseddel!K4&\" - \"&Timeseddel!J4,Timeseddel!B6&\" - \"&\"Timeseddel - \"&Timeseddel!H4&\" - 0\"&Timeseddel!K4&\" - \"&Timeseddel!J4)","v":"Mig selv - Timeseddel - 2020 - 08 - August"},"B6"]
[null,null,"B7"]
[null,null,"B8"]
[]
[]
[]
["Mail tekst","Hej xxxxxxxx xxxxxJens Georg Hansen.\r\n\r\nJeg sender hermed min Timeseddel.\r\n\r\nMed venlig hilsen\r\n\r\nxxxxxxx xxxxxx\r\nTlf: +45 xx xx xx xx\r\n\r\n\r\n","B12"]

{"sheet":"Ark3","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}