{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ark1"],"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":"1900"}

{"sheet":"Ark1","index":0,"n_rows":36,"n_cols":27,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Flekstids regnskab 2018"]
[]
["Ugedag",{"$f":"WEEKDAY(B4,1)","v":"1900-01-02"},{"$f":"WEEKDAY(C4,1)","v":"1900-01-03"},"1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-01",{"$f":"WEEKDAY(I4,1)","v":"1900-01-02"},{"$f":"WEEKDAY(J4,1)","v":"1900-01-03"},"Onsdag","Torsdag","Fredag","Lørdag","Søndag","Mandag","Tirsdag","Onsdag","Torsdag","Fredag","Lørdag","Søndag"]
["Dato","2018-01-01","2018-01-02","2018-01-03","2018-01-04","2018-01-05","2018-01-06","2018-01-07","2018-01-08","2018-01-09","2018-01-10","2018-01-11","2018-01-12","2018-01-13","2018-01-14","2018-01-15","2018-01-16","2018-01-17","2018-01-18","2018-01-19","2018-01-20","2018-01-21"]
["Gå hjem tid","15:54:00","15:00:00","21:00:00",null,null,null,null,"12:00:00"]
["Mødetid","08:00:00","07:30:00","09:30:00",null,null,null,null,"07:30:00"]
["Timer",{"$f":"B5-B6","v":"07:54:00"},{"$f":"C5-C6","v":"07:30:00"},"11:30:00","00:00:00","00:00:00","00:00:00","00:00:00","04:30:00","00:00:00",{"$f":"K5-K6","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["Frokost","00:30:00","00:30:00","00:30:00"]
["Arbejdstimer",{"$f":"B7-B8","v":"07:24:00"},{"$f":"C7-C8","v":"07:00:00"},"11:00:00","00:00:00","00:00:00","00:00:00","00:00:00","04:30:00","00:00:00",{"$f":"K7-K8","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00"]
["1/100 dele",{"$f":"B9*24","v":7.4},{"$f":"C9*24","v":7},{"$f":"D9*24","v":11},{"$f":"E9*24","v":0},{"$f":"F9*24","v":0},0,0,4.5,0,{"$f":"K9*24","v":0},{"$f":"L9*24","v":0},{"$f":"M9*24","v":0},{"$f":"N9*24","v":0},{"$f":"O9*24","v":0},{"$f":"P9*24","v":0},{"$f":"Q9*24","v":0},{"$f":"R9*24","v":0},{"$f":"S9*24","v":0},{"$f":"T9*24","v":0},{"$f":"U9*24","v":0},{"$f":"V9*24","v":0}]
["Normtid",7.4,7.4,7.4,7.4,7.4,null,null,7.4,7.4,7.4,7.4,7.4,null,null,7.4,7.4,7.4,7.4,7.4]
["+/- timer",{"$f":"IF(B10=0,0,(B10-B11))","v":0},-0.40000000000000036,3.5999999999999996,0,{"$f":"IF(F10=0,0,(F10-F11))","v":0},{"$f":"IF(G10=0,0,(G10-G11))","v":0},0,-2.9000000000000004,{"$f":"IF(J10=0,0,(J10-J11))","v":0},{"$f":"IF(K10=0,0,(K10-K11))","v":0},{"$f":"IF(L10=0,0,(L10-L11))","v":0},{"$f":"IF(M10=0,0,(M10-M11))","v":0},{"$f":"IF(N10=0,0,(N10-N11))","v":0},{"$f":"IF(O10=0,0,(O10-O11))","v":0},{"$f":"IF(P10=0,0,(P10-P11))","v":0},{"$f":"IF(Q10=0,0,(Q10-Q11))","v":0},{"$f":"IF(R10=0,0,(R10-R11))","v":0},{"$f":"IF(S10=0,0,(S10-S11))","v":0},{"$f":"IF(T10=0,0,(T10-T11))","v":0},{"$f":"U9-U11","v":0},0]
["Akumuleret fleks",{"$f":"B12+B16","v":11},{"$f":"C12+B13","v":10.6},{"$f":"D12+C13","v":14.2},14.2,14.2,14.2,14.2,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,{"$f":"R12+Q13","v":11.299999999999999},{"$f":"S12+R13","v":11.299999999999999},{"$f":"T12+S13","v":11.299999999999999},{"$f":"U12+T13","v":11.299999999999999},{"$f":"V12+U13","v":11.299999999999999}]
["Ugens timetal",null,null,null,null,null,null,{"$f":"SUM(B10:H10)","v":25.4},null,null,null,null,null,null,{"$f":"I9:O9","v":0},null,null,null,null,null,null,{"$f":"P9:V9","v":0}]
[]
["Overført fleks",11]
[]
["Ugedag",{"$f":"WEEKDAY(B19,1)","v":"1900-01-02"},{"$f":"WEEKDAY(C19,1)","v":"1900-01-03"},"1900-01-04","1900-01-05",{"$f":"WEEKDAY(F19,1)","v":"1900-01-06"},"Lørdag","Søndag","Mandag","Tirsdag","Onsdag","Torsdag","Fredag","Lørdag","Søndag","dec",null,"min","dec",null,"min","dec",null,"min","dec",null,"min"]
["Dato","2018-01-22","2018-01-23","2018-01-24","2018-01-25","2018-01-26","2018-01-27","2018-01-28","2018-01-29","2018-01-30","2018-01-31","2018-02-01","2018-02-02","2018-02-03","2018-02-04",2,"=",1,27,"=",16,52,"=",31,77,"=",46]
["Gå hjem tid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"=",2,28,"=",17,53,"=",32,78,"=",47]
["Mødetid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"=",3,30,"=",18,55,"=",33,80,"=",48]
["Timer",{"$f":"B20-B21","v":0},{"$f":"C20-C21","v":0},0,0,0,0,0,0,0,0,0,0,0,0,7,"=",4,32,"=",19,57,"=",34,82,"=",49]
["Frokost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"=",5,33,"=",20,58,"=",35,83,"=",50]
["Arbejdstimer",{"$f":"B22-B23","v":0},{"$f":"C22-C23","v":0},0,0,0,0,0,0,0,0,0,0,0,0,10,"=",6,35,"=",21,60,"=",36,85,"=",51]
["Normtid",null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"=",7,37,"=",22,62,"=",37,87,"=",52]
["+/- timer",{"$f":"B24-B25","v":0},{"$f":"C24-C25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,13,"=",8,38,"=",23,63,"=",38,88,"=",53]
["Akumuleret fleks",{"$f":"B26+V13","v":11.299999999999999},{"$f":"C26+B27","v":11.299999999999999},{"$f":"D26+C27","v":11.299999999999999},11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,11.299999999999999,15,"=",9,40,"=",24,65,"=",39,90,"=",54]
["Ugens timetal",null,null,null,null,null,null,{"$f":"B24:H24","v":0},null,null,null,null,null,null,{"$f":"I24:O24","v":0},17,"=",10,42,"=",25,67,"=",40,92,"=",55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"=",11,43,"=",26,68,"=",41,93,"=",56]
["Forklaring:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"=",12,45,"=",27,70,"=",42,95,"=",57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"=",13,47,"=",28,72,"=",43,97,"=",58]
["Hvis jeg møder 7.45 går jeg ind i skemaet til højre og ser at i dicimal er det 775 og det taster jeg ind i mødetid,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"=",14,48,"=",29,73,"=",44,98,"=",59]
["og samme procedure ved gå tid.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"=",15,50,"=",30,75,"=",45,100,"=",60]
["Disse to tal trækkes fra hinanden og giver arbejdstiden i decimal, f.eks 1135 som så igen ved hjælp af tabellen kan oversættes til 11 timer og 21 min."]
[]
["Besværligt, derfor kom jeg til at se på den løsning som beskrevet i den artikkel der henvises til."]