Posted: 2/7/2014 8:10 PM
Post subject: How to transform frame numbers into actual time
Quote
THC98
He/Him
Experienced player (920)
Joined: 8/7/2012
Posts: 279
Location: Brazil
First edition TAS of 2020 Nintendo 3D TAS of 2020 Nintendo 3D TAS of 2015 Nintendo 3D TASer of 2013 Speedy TAS of 2013
Hello everyone. Some time ago, I made an Excel (also works with Google Drive) spreadsheet that transforms frame numbers into minutes, seconds and centiseconds, given the FPS of the game. I tested the accuracy of this using some submissions of TASVideos and it gave the same result as the submission. It makes the work of doing weird maths to get an accurate time very easier, so it's very useful for me. You can download the file here. If it doesn't work, create a Google Drive (or Excel) spreadsheet and paste the following in B3: 
=IF(B1<((B2*B2)-1);"";(ROUNDDOWN(B1/B2/B2;0))&"'")&(ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))&"''"&IF(ROUND((ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2)-ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))*100;0)<10;"0"&ROUND((ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2)-ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))*100;0);ROUND((ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2)-ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))*100;0))
After doing it, put the frame number in B1 and the FPS in B2. I hope it gets useful for someone! :D
• Youtube Channel | Twitch Channel • Finished projects: GC Sonic Adventure DX - Sonic | GC Sonic Adventure DX - Tails | GC Sonic Adventure 2: Battle - Hero Story | GC Sonic Heroes - Team Sonic • Current projects: GC Sonic Adventure 2: Battle - Dark Story - 1st WIP • Paused projects: GC Sonic Adventure DX - Knuckles - 1st WIP • Individual levels records: Sonic Adventure DX | Sonic Adventure 2: Battle • My Discord: Tales98#0408
Posted: 2/7/2014 8:21 PM
Quote
Patashu
He/Him
Joined: 10/2/2005
Posts: 4043
Here are some FPS numbers you can use. 50.006978: PAL NES 59.56: 60Hz modded PAL SNES 59.72750056960583276373: GB/GBC 59.824: Wii VC 59.9228: Genesis/Atari 2600/SMS/MSX 59.94006: NTSC TV (60*1000/1001) 60.0022223045297973999: GC/Wii (1620000 / 26999) 60.09881387708959: NTSC NES/SNES and Super Game Boy 2 (21477272.72 / ((262*341*2-1)*2)) 61.17045102596282958984: Super Game Boy 1 I don't know for N64/PS1/DS/anything else not listed.
My Chiptune music, made in Famitracker: http://soundcloud.com/patashu My twitch. I stream mostly shmups & rhythm games http://twitch.tv/patashu My youtube, again shmups and rhythm games and misc stuff: http://youtube.com/user/patashu
Posted: 2/7/2014 8:26 PM
Quote
CoolKirby
Editor, Experienced player (570)
Joined: 11/8/2010
Posts: 4036
Exotic platforms TASer of 2014 NES TAS of 2013
All of the platform frame rates we use on this site can be found here. It would be cool if you could implement something that lets you type, for example, "Coleco" in the FPS field and have the program know to calculate the time using 59.9227510135505. Just an idea.
Posted: 2/7/2014 8:32 PM
Quote
Ilari
Emulator Coder, Skilled player (1113)
Joined: 5/1/2010
Posts: 1217
Rookie of 2010 New systems TASer of 2010 New systems TAS of 2010
For Dolphin(GC) frame counter, the fps used in calculations is 60 even if the video framerate isn't quite 60.
Posted: 2/7/2014 8:34 PM
Quote
THC98
He/Him
Experienced player (920)
Joined: 8/7/2012
Posts: 279
Location: Brazil
First edition TAS of 2020 Nintendo 3D TAS of 2020 Nintendo 3D TAS of 2015 Nintendo 3D TASer of 2013 Speedy TAS of 2013
I tested the framerate numbers listed here as well, and the spreadsheet file could calculate the time normally. I can try CoolKirby's idea as well, but it would take some time to do that :P
• Youtube Channel | Twitch Channel • Finished projects: GC Sonic Adventure DX - Sonic | GC Sonic Adventure DX - Tails | GC Sonic Adventure 2: Battle - Hero Story | GC Sonic Heroes - Team Sonic • Current projects: GC Sonic Adventure 2: Battle - Dark Story - 1st WIP • Paused projects: GC Sonic Adventure DX - Knuckles - 1st WIP • Individual levels records: Sonic Adventure DX | Sonic Adventure 2: Battle • My Discord: Tales98#0408
Posted: 2/7/2014 9:06 PM
Quote
Patashu
He/Him
Joined: 10/2/2005
Posts: 4043
CoolKirby wrote:
All of the platform frame rates we use on this site can be found here.
Oh, sweet! I was looking for this page before, but my google-fu was too weak.
My Chiptune music, made in Famitracker: http://soundcloud.com/patashu My twitch. I stream mostly shmups & rhythm games http://twitch.tv/patashu My youtube, again shmups and rhythm games and misc stuff: http://youtube.com/user/patashu
Posted: 2/8/2014 7:43 AM
Quote
Bisqwit
Editor, Active player (297)
Joined: 3/8/2004
Posts: 7469
Location: Arzareth
Patashu wrote:
Oh, sweet! I was looking for this page before, but my google-fu was too weak.
To be fair, that page is not really well integrated to the wiki structure yet.
Posted: 2/8/2014 8:32 AM
Quote
CoolKirby
Editor, Experienced player (570)
Joined: 11/8/2010
Posts: 4036
Exotic platforms TASer of 2014 NES TAS of 2013
Yeah, that's where I found it, through the Articles Index. I definitely wouldn't have found it otherwise.
Posted: 2/8/2014 8:35 AM
Quote
feos
Site Admin, Skilled player (1254)
Joined: 4/17/2010
Posts: 11478
Location: Lake Char­gogg­a­gogg­man­chaugg­a­gogg­chau­bun­a­gung­a­maugg
NES TAS of 2011
I track EVERYTHING from http://tasvideos.org/FullRecentChanges.html.
Warning: When making decisions, I try to collect as much data as possible before actually deciding. I try to abstract away and see the principles behind real world events and people's opinions. I try to generalize them and turn into something clear and reusable. I hate depending on unpredictable and having to make lottery guesses. Any problem can be solved by systems thinking and acting.
Posted: 2/8/2014 8:52 AM
Quote
CoolKirby
Editor, Experienced player (570)
Joined: 11/8/2010
Posts: 4036
Exotic platforms TASer of 2014 NES TAS of 2013
Uh, are you saying you were watching that page when someone last edited it, and that's how you knew about it...?
Posted: 2/8/2014 9:23 AM
Quote
feos
Site Admin, Skilled player (1254)
Joined: 4/17/2010
Posts: 11478
Location: Lake Char­gogg­a­gogg­man­chaugg­a­gogg­chau­bun­a­gung­a­maugg
NES TAS of 2011
I saw the birth of it... I check recent changes every day, as I check email.
Warning: When making decisions, I try to collect as much data as possible before actually deciding. I try to abstract away and see the principles behind real world events and people's opinions. I try to generalize them and turn into something clear and reusable. I hate depending on unpredictable and having to make lottery guesses. Any problem can be solved by systems thinking and acting.
Posted: 2/8/2014 9:26 AM
Quote
CoolKirby
Editor, Experienced player (570)
Joined: 11/8/2010
Posts: 4036
Exotic platforms TASer of 2014 NES TAS of 2013
Ah, okay. Well, you and I were probably the only ones who knew about that page, but I'm not sure where else we should link to it from.
Posted: 2/8/2014 9:44 AM
Quote
Noxxa
They/Them
Moderator, Expert player (4125)
Joined: 8/14/2009
Posts: 4090
Location: The Netherlands
Exotic platforms TASer of 2018 Exotic platforms TAS of 2018 Exotic platforms TASer of 2017 Exotic platforms TAS of 2017 Exotic platforms TAS of 2017 Exotic platforms TASer of 2016 Exotic platforms TAS of 2016 Gameboy TASer of 2013
I created that page a few weeks ago (with some help from Ilari). Couldn't really think of much to link it from, either.
http://www.youtube.com/Noxxa <dwangoAC> This is a TAS (...). Not suitable for all audiences. May cause undesirable side-effects. May contain emulator abuse. Emulator may be abusive. This product contains glitches known to the state of California to cause egg defects. <Masterjun> I'm just a guy arranging bits in a sequence which could potentially amuse other people looking at these bits <adelikat> In Oregon Trail, I sacrificed my own family to save time. In Star trek, I killed helpless comrades in escape pods to save time. Here, I kill my allies to save time. I think I need help.
Posted: 2/8/2014 9:45 AM
Quote
feos
Site Admin, Skilled player (1254)
Joined: 4/17/2010
Posts: 11478
Location: Lake Char­gogg­a­gogg­man­chaugg­a­gogg­chau­bun­a­gung­a­maugg
NES TAS of 2011
Emulator Resources? I'd make your page a subpage of that.
Warning: When making decisions, I try to collect as much data as possible before actually deciding. I try to abstract away and see the principles behind real world events and people's opinions. I try to generalize them and turn into something clear and reusable. I hate depending on unpredictable and having to make lottery guesses. Any problem can be solved by systems thinking and acting.
Posted: 2/8/2014 9:50 AM
Quote
Noxxa
They/Them
Moderator, Expert player (4125)
Joined: 8/14/2009
Posts: 4090
Location: The Netherlands
Exotic platforms TASer of 2018 Exotic platforms TAS of 2018 Exotic platforms TASer of 2017 Exotic platforms TAS of 2017 Exotic platforms TAS of 2017 Exotic platforms TASer of 2016 Exotic platforms TAS of 2016 Gameboy TASer of 2013
I thought about it at first, but I didn't think it would fit as framerates are actually not dependent on emulator, but based on the consoles themselves. Might still be workable though.
http://www.youtube.com/Noxxa <dwangoAC> This is a TAS (...). Not suitable for all audiences. May cause undesirable side-effects. May contain emulator abuse. Emulator may be abusive. This product contains glitches known to the state of California to cause egg defects. <Masterjun> I'm just a guy arranging bits in a sequence which could potentially amuse other people looking at these bits <adelikat> In Oregon Trail, I sacrificed my own family to save time. In Star trek, I killed helpless comrades in escape pods to save time. Here, I kill my allies to save time. I think I need help.
Posted: 2/8/2014 9:52 AM
Quote
feos
Site Admin, Skilled player (1254)
Joined: 4/17/2010
Posts: 11478
Location: Lake Char­gogg­a­gogg­man­chaugg­a­gogg­chau­bun­a­gung­a­maugg
NES TAS of 2011
If emulator breaks the original hardware framerate it sucks, no? It's an emulator resource after all.
Warning: When making decisions, I try to collect as much data as possible before actually deciding. I try to abstract away and see the principles behind real world events and people's opinions. I try to generalize them and turn into something clear and reusable. I hate depending on unpredictable and having to make lottery guesses. Any problem can be solved by systems thinking and acting.
Posted: 2/9/2014 7:18 AM
Quote
MUGG
Editor, Expert player (2330)
Joined: 5/15/2007
Posts: 3933
Location: Germany
Gameboy TASer of 2015 NES TAS of 2013 Gameboy TASer of 2011 Gameboy TASer of 2010
http://tasvideos.org/forum/viewtopic.php?p=212033#212033
Youtube • Livestream • Progress 11th TASer of the Decade 2010-2019 !