{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Upload","SailArena","Instruktioner"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Upload","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"SailArena","index":1,"n_rows":15,"n_cols":15,"rows_kept":15}
[{"$nulls":4},1]
[null,"Item","Table","Column","Example Data"]
[null,"First Name","Förnamn",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":2},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":"Arnav"}]
[null,"Last Name","Efternamn",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":3},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":"Jain"}]
[null,"Email","E-post",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":5},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":"segling@arnav.jain.se"}]
[null,"Telephone","Telefon",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":6},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":701234567}]
[null,"Club","Klubb",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":12},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":0}]
[null,"Nationality","Nationsbeteckning",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":8},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":0}]
[null,"Sailnumber","Segelnummer",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":9},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":0}]
[null,"Crew","Roll",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":13},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":0}]
[null,"Class","Tävling/klass",{"$f":"MATCH(TableMetadata[[#This Row],[Table]],TableSource[#Headers],0)","v":10},{"$f":"INDEX(TableSource[],_ExampleRowNumber,TableMetadata[[#This Row],[Column]])","v":"Z Funktionär"}]
[]
[]
[null,"Anmälan","Förnamn","Efternamn","Sailarena ID","E-post","Telefon","Adress","Nationsbeteckning","Segelnummer","Tävling/klass","Status","Klubb","Roll","Anmäld"]
[null,null,"Arnav","Jain",null,"segling@arnav.jain.se",701234567,{"$nulls":3},"Z Funktionär"]

{"sheet":"Instruktioner","index":2,"n_rows":28,"n_cols":4,"rows_kept":28,"merged":[[1,2,1,10]]}
[]
[null,null,"Denna mall är skapad av Arnav Jain, och är avsedd som ett verktyg för att konvertera deltagarlista som expoerteras från SailArena till verktyget RacingRulesofSailing.org"]
[null,null,"Kontakta mig på epost (segling@arnav.jain.se) om du finner något fel i denna fil"]
[null,null,"Version:","2022-02-06"]
[]
[null,{"$f":"IF(COUNTA(C6)>0,ROW()-ROW(FirstRow)+1,\"\")","v":1},"Exportera deltagarlista från Sail Arena"]
[null,2,"Öppna deltagarlista i Excel (detta görs enklast genom att dra filen från filhanteraren till denna excel fönster)"]
[null,3,"Ett nytt fönster skall öppnas"]
[null,4,{"$f":"\"Om alla information visas i kolumner, hoppa vidare till steg x, annars gå till nästa steg \"&B17","v":"Om alla information visas i kolumner, hoppa vidare till steg x, annars gå till nästa steg 12"}]
[null,5,"Stäng deltagarlistan"]
[null,6,"Öppna deltagarlista i Notepad/Anteckningar"]
[null,7,"Skapa en ny rad överst i filen"]
[null,8,"Lägg till följande text: sep=;"]
[null,9,"Spara filen"]
[null,10,"Öppna deltagar listan i Excel på nytt"]
[null,11,"Nu bör alla kolumner visas korrekt"]
[null,12,"Kopiera all data (CTRL+A), inklusive kolumnrubrikerna"]
[null,13,"Markera cell A1 i fliken SailArena"]
[null,14,"Klistra in det kopierade data"]
[null,15,"Infoga nya rader för funktionärer, förslagsvis överst i listan"]
[null,16,"Ange följande: Förnamn, Efternamn, E-post, Telefon"]
[null,17,"I kolumnen tävling, ange \"Funktionär\" eller en annan passande benämning för alla funktionärer"]
[null,18,"Gå till fliken Upload"]
[null,19,"Högerklicka någonstans i den gröna tabellen och välj Uppdatera/Refresh"]
[null,20,"Spara filen"]
[null,""]
[null,""]
[null,""]