Excel sheet to format swimmer data with relevant standards.
- Goto swimrankings.net and lookup the athelete your interested in, taking note of their 6 digit swimmer ID.
- Copy the swimmer data (using your mouse to select the table data)
- Paste it into an empty Excel sheet as plain text.
- In the empty Excel sheet, select, then right click on cell A1.
- Choose "Paste Special ..."
- In the "As:" dialogue, select "Text" then click "OK"
- Add the swimmer's name and 6 digit ID to the swimmer's page.
- Add the distance and event names to the csv .... Ugghh ... just figure it out or use the unix scripts.
- Goto swimrankings.net and lookup the athelete your interested in, taking note of their 6 digit swimmer ID.
- Copy the swimmer data (using your mouse to select the table data)
- In a Bash prompt at the root directory of the this project, run this command: bin/swimmer-cut-n-past | bin/cut-sort > swim-data/{6 digiti swimmer ID}.csv
- Add the swimmer data to the blue "Swimmers" page (be sure to insert a row).