Season 5 - Leaderboard

[alone_withmyaxe]

WOW 

That looks massively complicated!

Massive thanks to the work you are doing Ray.

The competition is amazing despite me getting creamed this round!

[Pil]

Now initially the plan was to copy the final line of each individual's score onto a leaderboard spreed sheet.  But it didn't work!   

I discovered that when I used the spreed sheet to automatically add/subtract numbers, it refused to be copied.

When you copy the line like that it copies the calculations, not the outcomes. There is a trick to make your life easier in the following rounds:

1) copy the line you want to put in the leader board
2) right-click where you want to paste the line in the leader board
3) choose "Paste special"
4) choose "Values"

Then it should paste the outcomes of the calculations rather than the calculations themselves. That way, you won't have to do the calculations by hand or type out all the outcomes of the calculations. I hope this helps!

As far as the scoring goes, I plan to pick up all the bonus points that are possible so in the end that will give me quite a lot of points. In the LPL 3 I had 6 wins and 4 losses and this LPL seems to be going no different. My vote difference is even negative which means my wins are close but my losses aren't, hehehe. I'm doing alright though at 18th place after this round I'll likely drop a little again

[Ray Rivers]

There is a trick to make your life easier in the following rounds:

1) copy the line you want to put in the leader board
2) right-click where you want to paste the line in the leader board
3) choose "Paste special"
4) choose "Values"

 

Thanks for the tip.  Works great. You are a star!  

[Andy0476]

@Ray
Even with the tip from Pil your workload is not to be underestimated! Thanks for putting in the time and effort!
Now to figure out a way to rise in the rankings ... maybe bribes? 

[gamer Mac]

I don't know if that's fate is karma, but I'm equal with brother!!

I shouldn't have let you use my camera for the last round

[Pil]

Thanks for the tip.  Works great. You are a star!  

Glad to help! 

[Ray Rivers]

Now to figure out a way to rise in the rankings ... maybe bribes? 

I would never take a crappy bribe.   

Now a good bribe, OTOH....   

[Andy0476]

Now a good bribe, OTOH....   

Can I tempt you with my missus for a weekend? 
Gives me extra time to paint also

[Ray Rivers]

Leaderboard after 4 rounds:

[Captain Blood]

Well, still a spread of just 30 points separating the top 25 placed participants... All still to play for 

[gamer Mac]

WOW I am in the top half.

[stevedaccs]

Ray - I use spreadsheets a lot and I think that I could help to design a more streamlined method for the posting and calculation of the results each week (eg you are using 20 rows for each entrant but I think you only need 11) - could probably make it so that you only have to post the votes and the bonus points each week and carry out one simple process at the end to give the leaderboard.

It is too late to do it for this season -  changing would probably bugger it up (tech speak) but if you email me a copy of the spreadsheet I can tinker around with it and see what I can do for the future if you think that would be helpful

[Ray Rivers]

Steve,

The Prof. has an excel spreedsheet but it can only handle 40 entries.  Perhaps Alex could be persuaded to PM you a copy of the doc. and you could take a look at it.

I know this would really help out the LPL and folks would appreciate any assistance that you could provide.

[stevedaccs]

OK Ray - over to you Prof...

[answer_is_42]

I'm sinking fast...