ESF|HCL> i like the automation you put in the sheet
6:02 PM <Audio> Awesome, cheers
6:02 PM <Audio> Aye I've been meaning to write up a cheatsheet for that
6:02 PM <Audio> ie a way to describe how to use it
6:02 PM <Audio> or, at least, how I do it quickly
6:03 PM <ESF|HCL> the only thing i couldn't figure out how to do quickly was paste in the raw data
6:04 PM <Audio> it's easy, really. C+P the final tables into ms notepad, delete everything except the lines for the teams, and do lots of find>replace thiings
6:04 PM <Audio> ctrl+h
6:04 PM <Audio> put a double space in the 'find' field and put ";" in the 'replace field
6:04 PM <Audio> then ";;" and ";" and click 'replace all' a few times
6:05 PM <Audio> then "; " and ";" and finally " ;" and ";" and you should be left with each team's name, games played, wins, losses etc separated only by a ';' symbol
6:05 PM <Audio> copy and paste to the sheet and it should put it in individual rows
6:06 PM <Audio> then use the function =split(A1,";") (assuming the data is in A1) and drag down
6:06 PM <Audio> that should separate everything properly. All you need to do then is copy it all and go 'paste data only'
6:06 PM <ESF|HCL> i was on the right track, i just didn't realize the depth of find + replace that was needed
6:06 PM <Audio> so that it stops being lots of forumlas and becomes just the numbers
6:07 PM <Audio> delete the goal difference field
6:07 PM <Audio> replace it with the pts field
6:07 PM <Audio> s
6:07 PM <Audio> and you're away
6:07 PM <Audio> there may be more find+replace things, for example to delete the " Q" at the end of the qualified teams scores
6:08 PM <Audio> and you may need to delete the table positions, ie you might be left with something like " 1 Audioslavia;12;8;2;2;26;9;+15;26" in which case you'd need to delete the " 1 " at the start
6:08 PM <ESF|HCL> that's a lot of work xD
6:08 PM <Audio> that can be time consuming even with find and replace
6:09 PM <Audio> after some practice you can do it all in ten minutes
6:09 PM <ESF|HCL> it didn't take me a long time to manually input the raw data
6:09 PM <Audio> after that the fiddly bit is adding new nations to the sheet
6:09 PM <ESF|HCL> yeah, that was the first thing i noticed
6:10 PM <Audio> I use a couple of lookup functions to search out the nations spelled incorrectly (or differently to how they should be on the sheet) and find the new nations
6:10 PM <Audio> iferror with vlookup is what I use
6:10 PM <Audio> "if there's an error when you look this shit up on the main sheet, leave a blank cell here, so I can figure out who's missing"
6:10 PM <ESF|HCL> lol
6:11 PM <Audio> I'll write a wee checklist at some point too
6:11 PM <Audio> because I need one for myself if anything