Notices
Page 47 of 78 « First 374546 47 484957 Last »
Reply
Thread Tools
xBloopBloopx is offline xBloopBloopx
2010-12-24 , 18:43
Posts: 22 | Thanked: 1 time | Joined on Dec 2010
#461
To get the feather achievements I have to buy the Mighty Eagle?!?
 
JayAce is offline JayAce
2010-12-24 , 23:10
Posts: 12 | Thanked: 0 times | Joined on Dec 2010
#462
Originally Posted by sullypad View Post
League Table now available for viewing.

The ‘League Table’ worksheet has now been completed for all worlds, episodes & total AB standings.
Are the leagues auto-updating??
 
nubb3r is offline nubb3r
2010-12-24 , 23:25
Posts: 18 | Thanked: 2 times | Joined on Dec 2010
#463
Originally Posted by xBloopBloopx View Post
To get the feather achievements I have to buy the Mighty Eagle?!?
Yes, by using the Mighty Eagle and getting 100% total destruction on level, you get a feather.
 
xBloopBloopx is offline xBloopBloopx
2010-12-25 , 00:13
Posts: 22 | Thanked: 1 time | Joined on Dec 2010
#464
Wooooow! That is just plain DUMB
 
diggidoyo is offline diggidoyo
2010-12-25 , 02:25
Posts: 43 | Thanked: 2 times | Joined on Nov 2010
#465
Originally Posted by JayAce View Post
Are the leagues auto-updating??
Of course not. It's up to you to update your own scores. However, it's only practical to update your score when you've made enough improvements to the individual levels to advance upwards. Keep the main sheet current with your highest scores, then update the league table every now and then.
 
JayAce is offline JayAce
2010-12-25 , 03:25
Posts: 12 | Thanked: 0 times | Joined on Dec 2010
#466
Is googledocs anywhere near as advanced as excel??

An autoupdating league in excel is easy to make but I've never used the google one :-S
 
diggidoyo is offline diggidoyo
2010-12-25 , 03:44
Posts: 43 | Thanked: 2 times | Joined on Nov 2010
#467
Can Excel pull values from a one spreadsheet's cells to calculate numbers in a different one? AFAIK, this isn't possible. It's easily done on the same spreadsheet which is why your totals and the averages autoupdate in the main spreadsheet (when configured properly), but the league spreadsheet is seperate, only stored at the same url. If the league scores were at the bottom of the main spreadsheet, it could autoupdate, but its a lot easier to access as it is.
 
nubb3r is offline nubb3r
2010-12-25 , 08:33
Posts: 18 | Thanked: 2 times | Joined on Dec 2010
#468
Originally Posted by diggidoyo View Post
Can Excel pull values from a one spreadsheet's cells to calculate numbers in a different one? AFAIK, this isn't possible. It's easily done on the same spreadsheet which is why your totals and the averages autoupdate in the main spreadsheet (when configured properly), but the league spreadsheet is seperate, only stored at the same url. If the league scores were at the bottom of the main spreadsheet, it could autoupdate, but its a lot easier to access as it is.
It is possible for Excel and Googledocs to use values for one spreadsheet in another. You will see I have done this for Episode 1 for giggs and aayano at the moment. If they their update scores in High Scores sheet it will update in the League Table Leaderboards sheet. It will not sort the position however or if new people add scores.

Edit: All of Episode 1 now done (not the worlds)
Last edited by nubb3r; 2010-12-25 at 09:11.
 
diggidoyo is offline diggidoyo
2010-12-25 , 09:40
Posts: 43 | Thanked: 2 times | Joined on Nov 2010
#469
I went through the spreadsheet and found several scores higher than the current record that had been entered into players columns. I assumed these people just didn't realize they were a record so I updated the record column accordingly. These are the changed records:

1-2 62080 Bob (+180)
1-19 41240 Bob (+170)
3-1 64050 Remyoman (+40)
4-2 65910 eMiL (+120)
5-2 53,250 SteTurner (+600)
5-20 115290 Brick (+7910)
8-6 117070 SteTurner (+1310)
8-5 109640 SteTurner (+1390)
9-5 42170 SteTurner (+470)
11-10 110270 FujiToast (+1500)

ABH
1-3 79650 diggidoyo (+1730) <==== oops lol xD
1-13 105790 SteTurner (+340)
2-4 97190 SteTurner (+600)
2-5 106280 SteTurner (+1150)
2-11 80420 SteTurner (+510)
 
Petrel is offline Petrel
2010-12-25 , 09:59
Posts: 92 | Thanked: 7 times | Joined on Dec 2010
#470
Originally Posted by diggidoyo View Post
Done. Only up to 5 columns can be locked so I had to delete the filler columns but it still looks neat. Now to work on becoming above average

Another spreadsheet for seasons isn't necessary, seeing as there's only 1 day left (not including today). But perhaps we should make one for the new "Ham 'Em High" episode, and then transfer the results to the main spreadsheet once a newer episode is released.
Well done, this was the idea yes, to come above average in all levels...
Thanx !
 
Reply
Page 47 of 78 « First 374546 47 484957 Last »

Tags
bada blows, bada rox

« Previous Thread | Next Thread »
Thread Tools

 
Forum Jump


All times are GMT. The time now is 15:44.

Contact Us - Home - Archive - Top