The Elite Forum

The Big Three Plus One => Perfect Dark => Topic started by: SamSim on July 02, 2003, 10:22:00 pm

Title: One On One (trust me, you need this)
Post by: SamSim on July 02, 2003, 10:22:00 pm
I'm too tired to explain. Read the page, download the spreadsheet, and enjoy pitting Paragon against ZeroSweden.

www.geocities.com/samdhug...onone.html (http://www.geocities.com/samdhughes/pdge/oneonone.html)
Title: One On One (trust me, you need this)
Post by: Quiet Bol on July 02, 2003, 10:47:00 pm
Wow, that's pretty cool.

Oddly, this computer doesn't have Excel, but I'll try later tonight...
Title: One On One (trust me, you need this)
Post by: vitor on July 02, 2003, 11:23:00 pm
haha nice.. great work. too bad i dont have excel either :\
Title: One On One (trust me, you need this)
Post by: Neo on July 03, 2003, 03:32:00 am
Ohh, very nice Sam, very nice. But what else could we expect from The Elite's Number One...Creator Of Stuff :p
Title: One On One (trust me, you need this)
Post by: Wouter Jansen on July 03, 2003, 07:05:00 am
I suppose it's not the definitive PD spreadsheet anymore, well at least not this version, because I already found an error!:p

Great work though, Sam. thumbs direction sky.
Title: One On One (trust me, you need this)
Post by: SamSim on July 03, 2003, 08:24:00 am
Fixed, and thank you for bringing that to my attention.
Title: One On One (trust me, you need this)
Post by: TreAKAHotdog on July 03, 2003, 09:02:00 am
Its too bad this is only for PD.  Maybe someone could make one for GE?  Id be interested in downloading and using it.  Like, maybe against Woll.

Uh oh, Ive posted twice in the PD forum.  g0 /\/\3!!1
Title: One On One (trust me, you need this)
Post by: KillerSim7 on July 03, 2003, 01:03:00 pm
That's awesome.
Title: One On One (trust me, you need this)
Post by: SamSim on July 03, 2003, 02:25:00 pm
If five people want the GE version, I'll make it.
Title: One On One (trust me, you need this)
Post by: Wabs on July 03, 2003, 03:19:00 pm
wow that's pretty nice
great work sam !

oh and I'd like to see a GE version too :lol
Title: One On One (trust me, you need this)
Post by: Bizichyld on July 03, 2003, 04:42:00 pm
Cool idea, though I haven't been able to use it yet...

I'm not very excel savvy...when I enter the name, it goes to "update values." What do I do then?

Oh, GE version please. :)
Title: One On One (trust me, you need this)
Post by: Boss on July 03, 2003, 05:28:00 pm
A Corel Quattro Pro version would be nice, I can't view Excel. :(
Title: One On One (trust me, you need this)
Post by: Suicide-Eagle on July 03, 2003, 06:16:00 pm
Yeah.   Same here.  I'm on Quattro Pro :(  .  Ah well.  Can't have it all.  This looks like a really good spreadsheet though.
Title: One On One (trust me, you need this)
Post by: Your Eliteness on July 03, 2003, 09:17:00 pm
Great work! But... here is some constructive criticism and some suggestions:

1. Needs colour.
2. Put in average total times/points.
3. Have one page with data, the other with the vs. output.
4. Have one page with Person 1's times, one page with Person 2's times.
5. Merge the cells above the data, call then Defection, etc. like I said. And put a list of links down the left which will take you to that cell.

EDIT: *is doing a data refresh* I noticed it says "stage18_1", is that a typo?
Title: One On One (trust me, you need this)
Post by: SamSim on July 04, 2003, 10:40:00 am
1 Can't be bothered, if I'm gonna be changing it around alot in future.
2. Average of what?
3. Uhhhh, this is exactly what happens. Elaborate on what "data" and "output" you're referring to.
4. This just makes for lots of unnecessary switching of pages.
5. Not sure how you do links in spreadsheets.

If it works, it ain't no typo.
Title: One On One (trust me, you need this)
Post by: youseinthehouse on July 04, 2003, 01:48:00 pm
Amazing.

Sign me up for GE.
Title: One On One (trust me, you need this)
Post by: bcks on July 04, 2003, 05:17:00 pm
i'll take a GE one aswell


Title: One On One (trust me, you need this)
Post by: SamSim on July 04, 2003, 09:58:00 pm
Counting Wouter's AIM vote, that's five.

*sigh*

This may take a while. I've coloured the PD one in and am now uploading it. It's now much more user friendly etc.
Hope you like the new format.
Title: One On One (trust me, you need this)
Post by: Your Eliteness on July 04, 2003, 10:20:00 pm
1. You said you can't be bothered, then you went and changed it :b
2. Average of the player's points and times.
3/4. Ignore this, you basically did it anyway in your new one (the older version had to scroll a lot).
5. To put in links, go Insert > Hyperlink. Though I'm not sure how to link to other cells, only files and webpages.

The new one looks better, IMO.
Title: One On One (trust me, you need this)
Post by: Not-so-Perfect-Dark on July 05, 2003, 04:43:00 am
Damn man, you have to be a genius.  I have to say, a fine piece of work, and it works like a charm for me.  I give it a 10/10.

Now let's see one for TS2, chump :x
Haha, just kidding about the chump part, but a TS2 one would be cool.  Too bad I can't make it myself because I am a flaming gay homosexual queer fag dork.
Title: One On One (trust me, you need this)
Post by: SamSim on July 05, 2003, 08:36:00 am
Version 3 is now online.

www.geocities.com/samdhug...onone.html (http://www.geocities.com/samdhughes/pdge/oneonone.html)
Title: One On One (trust me, you need this)
Post by: ShadowZero64 on July 05, 2003, 06:08:00 pm
Great job Sam!

Btw:

ShadowZero - 50, SamSim - 8 :p     (time)
ShadowZero - 49, SamSim - 9 :x     (points)

Edit: Heh, I have five 0-pointers and one 6-pointer :D  
All on PA of course :rollin  

ShadowZero - 4, Dark Avenger - 46 (both time and points) :o  
                               (13 tied)

ShadowZero - 30, Wabs - 26 (both time and points) :evil
                                (7 tied)

Cool, I always knew that I deserved to be ahead of Wabs ;)
Title: One On One (trust me, you need this)
Post by: TreAKAHotdog on July 05, 2003, 08:11:00 pm
Thanks Sam.

Karl 63, Trent 0.

Had to put something else.

EDIT - Oh gay, I was in GE mode.
Title: One On One (trust me, you need this)
Post by: bcks on July 06, 2003, 09:29:00 am
so you tied karl on 3 levels or not

Title: One On One (trust me, you need this)
Post by: Ngamer on July 06, 2003, 03:36:00 pm
Ngamer - 28, SamSim - 31
(4 tied)

NOOOOOOOOOOOOOOOOO!!!  Something must be done about this.  Passing me in the point ranks without even touching PD was one thing, but this is just going too far.

On the other hand, I can't be all THAT bad.  Check these stats!

Ngamer - 50, Shade - 11
(2 tied)

There's the confidence boost I was looking for.
Title: One On One (trust me, you need this)
Post by: SamSim on July 07, 2003, 09:51:00 am
HeE heeeE
Title: One On One (trust me, you need this)
Post by: captZEEbo on July 18, 2003, 05:19:00 am
these are totally sweet, kinda makes me wish I was playing GE/PD still so I could use these things nonstop :) .  Man I would be so much lower ranked if I had these, b/c I'd be using these nonstop to compare with everyone in the elite :)   But seriously sam, this is some really impressive work!  I always wished snap had done something like this.  It probably would have been easier to have it done with the program that updates the pages....but it's way more fun to do it externally :-D
Title: One On One (trust me, you need this)
Post by: SamSim on July 18, 2003, 11:03:00 am
Connecting it to the updater? Tricky, and I can't see any possible advantage of doing it that way.