227 replies to this topic

[ced]

thank you,Sabbat moon !

You make of very good work!!

I'm not to press. I wrote a word to put the topic at the top of the page

Just not to lose it.

[RipleYYY]

Xenon(UW): 1,578,860 / bolt

btw, that score is from me
... not for long i suppose

[bolt]

Oh yes Sabbat moon, that is a mistake. My score was only 1.489.150, RipleYYY is the real Champ on this table(for this moment )

[Sabbat]

ack! sorry for the mix up

[Sabbat]

It's coming....

[Sabbat]

Ok the highscore sheet is done... but how do I rename the columns from A/B/C etc to Table, Highscore, Player, Various Score etc

[Sabbat]

New front page

[ANDROID]

REALLYNice look for the front page!!!! thanks,
I see you got to manually edit the necessary cells, You are only a step away from having all scores posted,not just high scores, but everyones only once..... and sorted by columns or rows. I made a sample spreadsheet using excel also
a unsorted and a sorted view. most of the scores I copied and pasted and are in different orders. You can link two columns when sorting, but I felt the need to add either the individual names with the scores or better yet the three alpha letters that you would input into the grand champion score... for example 23,567 GAG at the beginning of the spreadsheet you could have a legend that relates the 3letter alpha signature to a player's handle/alias/name GAG = ANDROID etc. It is real important for sorting to make sure the numbers line up vertically in each cell though. I started with 100billion and hit space bar once to get to 10 billion. hit the space bar again to hit 1 billion and four times altogether to list a typicall 100 million game etc.

When a new game comes up you can enter it at your leasure and place them in alphabetic order simply by adding a column by clicking on the letter and adding a cell it will bump all the other letters up one place. Everytime someone posts a score you can scroll to the right alphabetically and enter the score at the first available open cell vertically down. you then highlight the column letter "C" by left clicking on it, then....click Data/Sort/ it will show the column "c" click on descending, the next two options you can leave blank, then check HEADER ROW and click oK and it will sort that column automatically. After awhile it will automatically list the options in sort you want, that is the initial setup for each column. and keep entering the scores per table with the numericalpha numbers. Here is a sample of unsorted

and a sample of sorted all by using three clicks after entering!

You really shouldnt change the letters(columns) or rows(numbers) because they are usefull when you need to sort and if you check out what I did with first box for game and place you will understand. OF COURSE there are a hundred ways to 'skin a cat' or so they say, and the whole deal works horizontally as well, but numbers are usually listed verically by columns, so that is the way I learned.

I am not saying you Have to change what you have done, by listing all scores, I only wanted to help you understand excel a little bit. you can write little programs that will sort columns or multiply columns by, example 100 points x column 1 75 x column two to see who amasses the most points per place for example places 1 through 25 or 15 would get decreasing numbers from 100

Place
1st = 100points
2nd= 65 points
3rd= 50 points
4th= 40 points
5th= 37
6th= 34
etc etc etc.

I once listed my entire music cd collection, 1,200+ on excel by artist, album etc. and about three months later lost it in a crash, so dont forget to backup your list with a duplicate...leaderboard1 or leaderboarda and keep a backup handy just in case you wipe something out!!

I have used excel a few times, but I am not an expert, my wife is REAL good though so, any problems occurring could be solved pretty quickly. drop me a message if you would like any tips, or I can call you back I have free long distance within the USA

Attached Files

•  Leaderboardunsorted.gif   67.44KB   15 downloads
•  Leaderboardsorted.gif   67.22KB   4 downloads

Edited by ANDROID, 30 October 2010 - 08:10 AM.

[RipleYYY]

...

cool SM, and with Android help, all will go OK, just a question of time to understand and play with "excell" (i dont know it, was more addict to "works")

[bolt]

You makes a fantastic job here Sabbat Moon,
thank you so much for your hard work.

[Crazy DarnFool Duck]

Thumbs way up, Sabbat.

[Sabbat]

you were right about B&A Riple. It is set to 5ball...the FS mod by iceman must be set to 3.

You hold the current highscore for bow and arrow then

[bolt]

Your Leaderboard lokks great Sabbat Moon,
but it is possible for you to makes a version with bigger fonts?

[RipleYYY]

i think its not the fonts, but simply the fact that pictures are automaticaly lowered by the forum options, else in 100% its just perfect to read...

[Sabbat]

Is it hard for you to read after you click on one of the pics bolt? I was resizing my screenshot by 75%... i can stop doing that

[bolt]

My resolution is 1680x1050, when I open the file, it is a bit small for me.

[Sabbat]

k the next update the pictures will be larger.... It may not happen anytime soon but I was talking with Noah Fentz yesterday in the chat and eventually there will be an embedded window for you guys to scroll through on your own in my post

Edited by Sabbat Moon, 31 October 2010 - 03:38 PM.

[bolt]

Thanks Sabbat Moon, for the very interesting news.

[Crazy DarnFool Duck]

I increased my RaB score. Update please.

[Crazy DarnFool Duck]

I hate double posting.

I got my RaB score up again. Please keep up to date.

Edited by Crazy DarnFool Duck, 31 October 2010 - 07:45 PM.