The Elite Forum

The Big Three Plus One => Perfect Dark => Topic started by: SamSim on September 23, 2002, 04:28:00 am

Title: The Totaliser: it adds up your times automatically!
Post by: SamSim on September 23, 2002, 04:28:00 am

www.geocities.com/samdhug...aliser.xls (http://www.geocities.com/samdhughes/adders/totaliser.xls)

Now with new features! **IN COLOUR**

Enjoy.

Title: The Totaliser: it adds up your times automatically!
Post by: Fal2002 on September 23, 2002, 04:45:00 am

Thats cool Sam...Thanks. I just installed Windows 98 and Excel came with it, so i might aswell use it. Cheers

Title: The Totaliser: it adds up your times automatically!
Post by: GoldenGreg007 on September 23, 2002, 03:39:00 pm

little known fact:  the elite adds them up automatically too.   and hey, that's where it counts.

Title: The Totaliser: it adds up your times automatically!
Post by: SamSim on September 24, 2002, 06:37:00 am

But what if you can't wait until the next update?

Title: The Totaliser: it adds up your times automatically!
Post by: Quiet Bol on September 24, 2002, 11:28:00 am

Hah, I was thinking the same thing as GoldenGreg but didn't want to be rude. And if you want to know your totals in between, it's not hard to subtract whatever seconds you knocked off. It's not a long wait anyway.

Title: The Totaliser: it adds up your times automatically!
Post by: Not-so-Perfect-Dark on October 06, 2002, 04:03:00 pm

but there are people like me who arent in the elite, patiently waiting...ive waited almost 1 1/2 months to know my total times for each/all difficulties, and nothing yet.  ah i think i even added my Agent times wrong, who knows.

Title: The Totaliser: it adds up your times automatically!
Post by: Bizichyld on October 06, 2002, 05:34:00 pm

All you have to do, really, is convert all your times to seconds by multiplying every minute by 60, then add on the remaining seconds for each time. Add those totals up, then you should have a number somewhere around 2,000 if you're decent (total #1). Divide this number by 60 and you will get the total number of minutes. Take that number (ignore the decimal if ther is one) and multiply it by 60. Finally, take this number and subtract it from total #1. This will give you the remaining seconds (it will be under 60). The number you multiplied by 60 and dropped the decimal is your total number of minutes.

This is probably, more or less, what Sam's spreadsheet does.

Title: The Totaliser: it adds up your times automatically!
Post by: Not-so-Perfect-Dark on October 06, 2002, 09:45:00 pm

ohh yea, i forgot about my computer programming class...i just make me a little proggie that does that, so i just put my times in, and i can multiply by 60 and get my seconds  then i can make it change back to minutes...i think thats how i got my agent total time, but i might have added them up manually...
really only takes 2 minutes to make,

Title: The Totaliser: it adds up your times automatically!
Post by: SamSim on October 07, 2002, 04:00:00 pm

Yeah. Total seconds = seconds + minutes*60

Hours = total seconds / 3600 - decimal
minutes = (total seconds / 60 - decimal) mod 60
seconds = total seconds mod 60

Dead easy. Just adding up takes the time, really.

Title: The Totaliser: it adds up your times automatically!
Post by: simplebutperfect on October 20, 2002, 11:30:00 am

I'm working on a proggy for the computer now that will save all of the times u enter, allow u to edit each one indivually and show u different stats such as averare, grand total, skill totals etc etc.  It should be done in about a week.  Only prob i sthat it will be a dos prog but no big deal, right?  I'm also working on a ti-83 version ofr those who own the calculator.

Title: The Totaliser: it adds up your times automatically!
Post by: Fal2002 on October 20, 2002, 06:58:00 pm

You might aswell get the auto-updater and put yourself on it, that automatically updates it for you! :P

Title: The Totaliser: it adds up your times automatically!
Post by: simplebutperfect on October 20, 2002, 07:59:00 pm

what is the auto-updater and how to retrieve this beautiful sounding piece of equipment?