Stevo985 Posted May 23, 2016 VT Supporter Share Posted May 23, 2016 Disappointing lack of automation on that spreadsheet. Can tell you're not an accountant Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 I need to do the automation. Or you can do it for me TP = tracks played Link to comment Share on other sites More sharing options...
Stevo985 Posted May 23, 2016 VT Supporter Share Posted May 23, 2016 Don't tempt me... Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 I know what automation I want to do, but my excel skills aren't there. The idea formula would be that if you fill in the box next to the track with someone's name, it automatically adds the points for that to the total column and also adds to the b/e/m/h/x column. But I have no idea how to do that Especially with the different point values. Link to comment Share on other sites More sharing options...
Stevo985 Posted May 23, 2016 VT Supporter Share Posted May 23, 2016 32 minutes ago, StefanAVFC said: I know what automation I want to do, but my excel skills aren't there. The idea formula would be that if you fill in the box next to the track with someone's name, it automatically adds the points for that to the total column and also adds to the b/e/m/h/x column. But I have no idea how to do that Especially with the different point values. Piece of piss I'll do it #excelgeek Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 I'm doing my next excel qualification in June but I'll still be shit Link to comment Share on other sites More sharing options...
Stevo985 Posted May 23, 2016 VT Supporter Share Posted May 23, 2016 Still can't edit that doc by the way. I'll do it in excel and can paste it over if I can edit Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 Ok, i'll sort that. Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 (edited) Done it. Is it also possible to auto-populate the tracks played field by how many fields are filled in on the track listings? Edited May 23, 2016 by StefanAVFC Link to comment Share on other sites More sharing options...
Stevo985 Posted May 23, 2016 VT Supporter Share Posted May 23, 2016 Done. I haven't included the DLC yet. if you highlight which ones are easy/hard etc then I can add them in. The name you put next to the track has to be exactly what's entered as the name in the league table. I.e. if I put Stevo985 instead of Stevo, it won't work. 1 Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 1 minute ago, Stevo985 said: Done. I haven't included the DLC yet. if you highlight which ones are easy/hard etc then I can add them in. The name you put next to the track has to be exactly what's entered as the name in the league table. I.e. if I put Stevo985 instead of Stevo, it won't work. I'm just copying and pasting from the table, so the colour formatting is correct too. Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 One last question, is it possible to automatically sort the Points column using the data input to the track list? Link to comment Share on other sites More sharing options...
Stevo985 Posted May 23, 2016 VT Supporter Share Posted May 23, 2016 I'll chat you in the sheet to save clogging this thread with really exciting Excel chat Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 23, 2016 Share Posted May 23, 2016 Non-excel message: Is everyone happy with the scoring? Should points be weighted against the difficulty? If you haven't seen the spreadsheet yet, it's 1 point for beginner/easy, 2 for medium, 3 for hard and 4 for extreme. Link to comment Share on other sites More sharing options...
Stevo985 Posted May 25, 2016 VT Supporter Share Posted May 25, 2016 Took a couple of times last night. Blimp My Ride and Mind the Gap Unless you beat them again after I'd done them? There was plenty left in the tank on Mind the Gap. Tricky to put a perfect run together on that but if you do there's probably 5 seconds to take off my time Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 25, 2016 Share Posted May 25, 2016 (edited) I took 4 seconds off mind the gap before bed I also beat Jono's time on Expedition right after he went to bed Edited May 25, 2016 by StefanAVFC Link to comment Share on other sites More sharing options...
Stevo985 Posted May 25, 2016 VT Supporter Share Posted May 25, 2016 Balls. You can change the google doc back then Yeah I knew there was a good few seconds to shave off there. But the gf was getting annoyed at me playing it Link to comment Share on other sites More sharing options...
StefanAVFC Posted May 25, 2016 Share Posted May 25, 2016 Yeah the perfect line for it is ridiculously smooth. You could probably take another 4-5 seconds off my time as well. Link to comment Share on other sites More sharing options...
villarule123 Posted May 25, 2016 VT Supporter Share Posted May 25, 2016 My 4 year old daughter was getting annoyed at me the other day Even she was saying how bad I am Link to comment Share on other sites More sharing options...
Stevo985 Posted May 25, 2016 VT Supporter Share Posted May 25, 2016 Just now, StefanAVFC said: Yeah the perfect line for it is ridiculously smooth. You could probably take another 4-5 seconds off my time as well. The hardest bit is the the part after the double bunny hop over that pit, about half way. You go up a long slope and then jump onto a steeper slope that leads into the rest of the track. If you nail that bit it basically sets you up for the rest of the track. If you miss it, you lose all your momentum completely. And it's quite tricky to nail it. Link to comment Share on other sites More sharing options...
Recommended Posts