{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Beregning af Dubletter"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"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":"Beregning af Dubletter","index":0,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
["Fornavn","Efternavn","Fødselsdato","Køn",2020,null,"Herre","Dame","Antal kursister med Dubletter","Antal kursister uden Dubletter","Antal Dubletter fjernet","Antal Herrer","Antal Damer"]
["Anders","Dahlmann","1973-01-07","Herre",{"$f":"IF($C2=\"\",\"\",DatoUDDMM(C2))","v":1973},{"$f":"IF($E2=\"\",\"\",$E$1-$E2)","v":47},{"$f":"IF(AND($D2=\"Herre\",$F2<100),$F2,\"\")","v":47},{"$f":"IF(AND($D2=\"Dame\",$F2<100),$F2,\"\")","v":""},59,56,3,29,27]
["poul","Lindgaard","1900-01-01","Herre",{"$f":"IF($C3=\"\",\"\",DatoUDDMM(C3))","v":1899},121,"",""]
["steen","jensen","1967-04-24","Herre",{"$f":"IF($C4=\"\",\"\",DatoUDDMM(C4))","v":1967},53,53,"","Samlet GNS alder Kursister","Gns alder Damer","Gns alder Herrer","Fordeling M/K på Holdet"]
["Arne","JørgensenT","1900-01-01","Herre",{"$f":"IF($C5=\"\",\"\",DatoUDDMM(C5))","v":1899},121,"","",59.836734693877553,58.695652173913047,60.846153846153847,0.93103448275862066]
["Bente D G","Andersen","1965-09-10","Dame",{"$f":"IF($C6=\"\",\"\",DatoUDDMM(C6))","v":1965},55,"",55]
["Bjarne","lomholdt","1949-12-09","Herre",{"$f":"IF($C7=\"\",\"\",DatoUDDMM(C7))","v":1949},71,71,""]
["Bjarne","Pedersen","1959-07-09","Herre",{"$f":"IF($C8=\"\",\"\",DatoUDDMM(C8))","v":1959},61,61,""]
["Dorrit ","Christensen","1949-08-09","Dame",{"$f":"IF($C9=\"\",\"\",DatoUDDMM(C9))","v":1949},71,"",71]
["Ellen","Thomsen","1900-01-01","Dame",{"$f":"IF($C10=\"\",\"\",DatoUDDMM(C10))","v":1899},121,"",""]
["Else","Vestergaard","1952-04-04","Dame",{"$f":"IF($C11=\"\",\"\",DatoUDDMM(C11))","v":1952},68,"",68]
["Erik bernth","Nielsen","1964-06-08","Herre",{"$f":"IF($C12=\"\",\"\",DatoUDDMM(C12))","v":1964},56,56,""]
["Hanne","Kjær","1971-05-17","Dame",{"$f":"IF($C13=\"\",\"\",DatoUDDMM(C13))","v":1971},49,"",49]
["Hanne","Laigaard","1962-07-31","Dame",{"$f":"IF($C14=\"\",\"\",DatoUDDMM(C14))","v":1962},58,"",58]
["Hanne","Old","1966-07-13","Dame",{"$f":"IF($C15=\"\",\"\",DatoUDDMM(C15))","v":1966},54,"",54,null,null,null,"Ved tryk på \"Til Hovedsiden\" bliver sheetet veryHidden"]
["Hans","Christiansen","1961-11-01","Herre",{"$f":"IF($C16=\"\",\"\",DatoUDDMM(C16))","v":1961},59,59,""]
["Heidi","Jensen","1966-09-01","Dame",{"$f":"IF($C17=\"\",\"\",DatoUDDMM(C17))","v":1966},54,"",54]
["Herdis","Dahl Sørensen","1900-01-01","Dame",{"$f":"IF($C18=\"\",\"\",DatoUDDMM(C18))","v":1899},121,"",""]
["JOHN","MELDGAARD","1955-01-20","Herre",{"$f":"IF($C19=\"\",\"\",DatoUDDMM(C19))","v":1955},65,65,""]
["Jacob","Dalgaard","1962-04-02","Herre",{"$f":"IF($C20=\"\",\"\",DatoUDDMM(C20))","v":1962},58,58,"",null,"Cellerne \"A2:D200\" kopieres ind fra andet sheet. "]
["Jan","Daasbjerg","1961-06-11","Herre",{"$f":"IF($C21=\"\",\"\",DatoUDDMM(C21))","v":1961},59,59,"",null,"\"Vis Dubletter og beregn\" skal fjerne alle single værdier og kun beholder Dubletterne, baseret på cellerne \"A:C\""]
["Janne","Skriver","1959-12-11","Herre",{"$f":"IF($C22=\"\",\"\",DatoUDDMM(C22))","v":1959},61,61,"",null,"Dubletterne skal efter sletningen af single værdierne flyttes op til A2:D og gå nedefter."]
["Jens ","Rode","1966-09-07","Herre",{"$f":"IF($C23=\"\",\"\",DatoUDDMM(C23))","v":1966},54,54,"",null,"Jeg kunne godt tænke mig at koden selv finder den sidste række som skal beregnes."]
["Jens","Pedersen","1952-08-21","Herre",{"$f":"IF($C24=\"\",\"\",DatoUDDMM(C24))","v":1952},68,68,"",null,"Koden skal også gerne beregne Alder på kursisterne, men ikke medtage kursister med "]
["Jeppe","Tougaard","1900-01-01","Herre",{"$f":"IF($C25=\"\",\"\",DatoUDDMM(C25))","v":1899},121,"","",null,"Fødselsdato 01-01-1900 i beregningen."]
["Johan","Jakobsen","1961-10-25","Herre",{"$f":"IF($C26=\"\",\"\",DatoUDDMM(C26))","v":1961},59,59,"",null,"Celle \"E1\" skal forblive variabel via en inputbox eller kunne beregnes direkte fra inputboksen."]
["Jytte","Lang","1950-09-18","Dame",{"$f":"IF($C27=\"\",\"\",DatoUDDMM(C27))","v":1950},70,"",70,null,"Beregningerne i cellerne \"E2:H\" skal ikke vises."]
["Kaj","Guldager","1960-07-15","Herre",{"$f":"IF($C28=\"\",\"\",DatoUDDMM(C28))","v":1960},60,60,""]
["Karen","Møller","1966-08-21","Dame",{"$f":"IF($C29=\"\",\"\",DatoUDDMM(C29))","v":1966},54,"",54]
["Kirsten","Holst","1969-04-20","Dame",{"$f":"IF($C30=\"\",\"\",DatoUDDMM(C30))","v":1969},51,"",51]
["Lene","Kohls","1959-03-03","Dame",{"$f":"IF($C31=\"\",\"\",DatoUDDMM(C31))","v":1959},61,"",61]
["Lene","Daasbjerg","1964-08-29","Dame",{"$f":"IF($C32=\"\",\"\",DatoUDDMM(C32))","v":1964},56,"",56]
["Lene","Andersen","1965-11-27","Dame",{"$f":"IF($C33=\"\",\"\",DatoUDDMM(C33))","v":1965},55,"",55]
["Lene","Hvid","1953-09-05","Dame",{"$f":"IF($C34=\"\",\"\",DatoUDDMM(C34))","v":1953},{"$f":"IF($E34=\"\",\"\",$E$1-$E34)","v":67},{"$f":"IF(AND($D34=\"Herre\",$F34<100),$F34,\"\")","v":""},{"$f":"IF(AND($D34=\"Dame\",$F34<100),$F34,\"\")","v":67}]
["Lene ","Larsen","1963-02-15","Dame",{"$f":"IF($C35=\"\",\"\",DatoUDDMM(C35))","v":1963},57,"",57]
["Leo","Frandsen","1962-05-18","Herre",{"$f":"IF($C36=\"\",\"\",DatoUDDMM(C36))","v":1962},58,58,""]
["Lisbeth","Balle","1959-11-12","Dame",{"$f":"IF($C37=\"\",\"\",DatoUDDMM(C37))","v":1959},61,"",61]
["Louise","Skov","1957-05-16","Dame",{"$f":"IF($C38=\"\",\"\",DatoUDDMM(C38))","v":1957},63,"",63]
["Michael","Nielsen","1961-02-07","Herre",{"$f":"IF($C39=\"\",\"\",DatoUDDMM(C39))","v":1961},59,59,""]
["Niels Ole","Petersen","1950-06-15","Herre",{"$f":"IF($C40=\"\",\"\",DatoUDDMM(C40))","v":1950},70,70,""]
["Ole ","Gyldenløv","1970-10-28","Herre",{"$f":"IF($C41=\"\",\"\",DatoUDDMM(C41))","v":1970},50,50,""]
["Olevina","Skriver","1965-06-27","Dame",{"$f":"IF($C42=\"\",\"\",DatoUDDMM(C42))","v":1965},55,"",55]
["Per","Nielsen","1959-01-22","Herre",{"$f":"IF($C43=\"\",\"\",DatoUDDMM(C43))","v":1959},61,61,""]
["Pia","Jacobsen","1962-08-07","Dame",{"$f":"IF($C44=\"\",\"\",DatoUDDMM(C44))","v":1962},58,"",58]
["Pia","Jensen","1970-07-28","Dame",{"$f":"IF($C45=\"\",\"\",DatoUDDMM(C45))","v":1970},50,"",50]
["Pia","Holm","1968-01-03","Dame",{"$f":"IF($C46=\"\",\"\",DatoUDDMM(C46))","v":1968},52,"",52]
["Poul Erik","Jakobsen","1956-05-02","Herre",{"$f":"IF($C47=\"\",\"\",DatoUDDMM(C47))","v":1956},64,64,""]
["Poul-Erik","Laugesen","1952-06-24","Herre",{"$f":"IF($C48=\"\",\"\",DatoUDDMM(C48))","v":1952},68,68,""]
["Sofus","Eriksen","1947-05-01","Herre",{"$f":"IF($C49=\"\",\"\",DatoUDDMM(C49))","v":1947},73,73,""]
["Steen","frederiksen","1959-02-06","Herre",{"$f":"IF($C50=\"\",\"\",DatoUDDMM(C50))","v":1959},61,61,""]
["Susanne","Jeppesen","1900-01-01","Dame",{"$f":"IF($C51=\"\",\"\",DatoUDDMM(C51))","v":1899},121,"",""]
["Susanne","Johansen","1954-05-23","Dame",{"$f":"IF($C52=\"\",\"\",DatoUDDMM(C52))","v":1954},66,"",66]
["Sussi Merete","Nielsen","1955-01-11","Dame",{"$f":"IF($C53=\"\",\"\",DatoUDDMM(C53))","v":1955},65,"",65]
["Svend","Nielsen","1950-02-04","Herre",{"$f":"IF($C54=\"\",\"\",DatoUDDMM(C54))","v":1950},70,70,""]
["Søren","Dohrn","1962-07-12","Herre",{"$f":"IF($C55=\"\",\"\",DatoUDDMM(C55))","v":1962},58,58,""]
["Tage","Rostom","1961-12-09","Herre",{"$f":"IF($C56=\"\",\"\",DatoUDDMM(C56))","v":1961},59,59,""]
["Tamara","Klemensen","1900-01-01","Dame",{"$f":"IF($C57=\"\",\"\",DatoUDDMM(C57))","v":1899},121,"",""]
[null,null,null,null,{"$f":"IF($C58=\"\",\"\",DatoUDDMM(C58))","v":""},"","",""]