Triplet Calculator

General discussion about tracking, help and support.
User avatar
Scomo
Posts: 21
Joined: Wed Aug 05, 2015 5:12 am
Location: Austin, TX
Contact:

Triplet Calculator

Postby Scomo » Sat Aug 08, 2015 6:05 pm

I've put together a sheet that lets you pick a speed and will tell you where to place notes, and with what Gxx delay for perfect triplets.

There's also a visual guide for "standard" triplet speeds 3, 6, and 9

It's attached. Hope it helps!
Attachments
Triplet Calc.xlsx
For triplet fans!
(21.38 KiB) Downloaded 122 times
There will forever be a special place in my heart for that 8-bit sound.

User avatar
Xyz
Posts: 297
Joined: Tue Apr 21, 2015 4:36 pm

Re: Triplet Calculator

Postby Xyz » Sat Aug 08, 2015 6:24 pm

imo shortcuts like these can make a user dependent on them and weaken their understanding of how the tracker actually works.
>:( Fuck you hentai boy i hate you squid anus

User avatar
MiniMacro
Posts: 932
Joined: Mon Apr 20, 2015 8:47 pm
Location: Trapped in a 2A03

Re: Triplet Calculator

Postby MiniMacro » Sat Aug 08, 2015 7:14 pm

I can't open it because it says it is corrupt. Is it possible to fix this?
wow this is total BS
mmsound.bandcamp.com
you can see my beautiful music there~

User avatar
ollaxe
Posts: 736
Joined: Mon Apr 20, 2015 7:07 pm
Location: Sweden
Contact:

Re: Triplet Calculator

Postby ollaxe » Sat Aug 08, 2015 8:16 pm

Thanks but no thanks, I can do math in my head whenever I'd need it. I even have an A in math... So yah.
Hi! I'm not really active here anymore but I still make music. Nowadays I mostly make dubstep with emphasis on good melodies and chord progressions.
SoundCloud: soundcloud.com/ollaxe
Twitter: twitter.com/ollaxe
Discord server: dis.gd/tK7uRnc
I'm also on Spotify. Search "OllAxe" and you'll find me.

User avatar
HertzDevil
Posts: 475
Joined: Thu Apr 23, 2015 7:39 pm
Location: Hong Kong SAR
Contact:

Re: Triplet Calculator

Postby HertzDevil » Sat Aug 08, 2015 8:40 pm

These are the contents of the entire spreadsheet that change with the single speed variable:

Code: Select all

B3 = 3 (Speed)
B4 = B3
B5 = B4 * 4
B6 = B5 * 4
B10 = B5 / 3
B11 = B10 * 2
B12 = B11 * 2

D3 = IF(OR(B3=3,B3=6,B3=9),"Even triplets OK!",IF(OR(B3=1,B3=2,B3=4,B3=5,B3=7,B3=8),"WARNING! Speed not evenly divisible by 3!","WARNING! Not a valid Famitracker Speed!"))
D4 = IF(OR(B3=3,B3=6,B3=9),"Use the table below to determine the note placement and Gxx delay setting to use for even triplets.",IF(OR(B3<1,B3>9),"Please choose a whole number speed between 1 and 9.","Even triplets not possible using four (4) rows per beat."))

G10 = IF(B3=3,"G01",IF(B3=6,"G02",IF(B3=9,"G03","Irregular")))
G11 = IF(B3=3,"G02",IF(B3=6,"G04",IF(B3=9,"G06","Irregular")))
G12 = IF(B3=3,"G01",IF(B3=6,"G02",IF(B3=9,"G03","Irregular")))
I10 = IF(B3=3,"G02",IF(B3=6,"G04",IF(B3=9,"G06","Irregular")))
I11 = IF(B3=3,"G01",IF(B3=6,"G02",IF(B3=9,"G03","Irregular")))
I12 = IF(B3=3,"G02",IF(B3=6,"G04",IF(B3=9,"G06","Irregular")))

There is no calculation involved in displaying these Gxx strings. A spreadsheet consisting only of switch statements on the single variable is called a lookup table. This is not a calculator.
refactoring 0cc-famitracker

User avatar
Mojitone
Posts: 87
Joined: Tue May 12, 2015 10:15 pm

Re: Triplet Calculator

Postby Mojitone » Sat Aug 08, 2015 9:23 pm

The speed value represents the number of frames within a row. Depending on the spacing of the triplet in your project, all you have to do is divide the total number of frames to be taken up by the triplet by 3 and place your notes accordingly. This last part is where the Gxx command comes into play.
In the event the speed value is not divisible by 3 it is possible to round the note position to the nearest integer.

tl,dr basic math skill is all it takes to successfully translate tuplets into tracker values.
It's possible I haven't worded my post adequately so let me know if I did
Formerly Macromaniac
Soundcloud

User avatar
Scomo
Posts: 21
Joined: Wed Aug 05, 2015 5:12 am
Location: Austin, TX
Contact:

Re: Triplet Calculator

Postby Scomo » Sat Aug 08, 2015 9:41 pm

Xyz wrote:imo shortcuts like these can make a user dependent on them and weaken their understanding of how the tracker actually works.



In my opinion, shortcuts like "imo" make a person dependent on them and weaken their understanding of how the English language actually works.
There will forever be a special place in my heart for that 8-bit sound.

User avatar
Scomo
Posts: 21
Joined: Wed Aug 05, 2015 5:12 am
Location: Austin, TX
Contact:

Re: Triplet Calculator

Postby Scomo » Sat Aug 08, 2015 9:50 pm

ollaxe wrote:Thanks but no thanks, I can do math in my head whenever I'd need it. I even have an A in math... So yah.


And I have a double-Masters in Applied Mathematics and Statistics from UC Berkeley but if you decide put a tool up that isn't helpful to ME I'll just keep my mouth shut.
There will forever be a special place in my heart for that 8-bit sound.

User avatar
Scomo
Posts: 21
Joined: Wed Aug 05, 2015 5:12 am
Location: Austin, TX
Contact:

Re: Triplet Calculator

Postby Scomo » Sat Aug 08, 2015 9:51 pm

HertzDevil wrote:These are the contents of the entire spreadsheet that change with the single speed variable:

Code: Select all

B3 = 3 (Speed)
B4 = B3
B5 = B4 * 4
B6 = B5 * 4
B10 = B5 / 3
B11 = B10 * 2
B12 = B11 * 2

D3 = IF(OR(B3=3,B3=6,B3=9),"Even triplets OK!",IF(OR(B3=1,B3=2,B3=4,B3=5,B3=7,B3=8),"WARNING! Speed not evenly divisible by 3!","WARNING! Not a valid Famitracker Speed!"))
D4 = IF(OR(B3=3,B3=6,B3=9),"Use the table below to determine the note placement and Gxx delay setting to use for even triplets.",IF(OR(B3<1,B3>9),"Please choose a whole number speed between 1 and 9.","Even triplets not possible using four (4) rows per beat."))

G10 = IF(B3=3,"G01",IF(B3=6,"G02",IF(B3=9,"G03","Irregular")))
G11 = IF(B3=3,"G02",IF(B3=6,"G04",IF(B3=9,"G06","Irregular")))
G12 = IF(B3=3,"G01",IF(B3=6,"G02",IF(B3=9,"G03","Irregular")))
I10 = IF(B3=3,"G02",IF(B3=6,"G04",IF(B3=9,"G06","Irregular")))
I11 = IF(B3=3,"G01",IF(B3=6,"G02",IF(B3=9,"G03","Irregular")))
I12 = IF(B3=3,"G02",IF(B3=6,"G04",IF(B3=9,"G06","Irregular")))

There is no calculation involved in displaying these Gxx strings. A spreadsheet consisting only of switch statements on the single variable is called a lookup table. This is not a calculator.



Feel better now that you got that out of your system?
There will forever be a special place in my heart for that 8-bit sound.

User avatar
retrodpc
Posts: 194
Joined: Tue Apr 21, 2015 12:05 am
Location: !wow
Contact:

Re: Triplet Calculator

Postby retrodpc » Sat Aug 08, 2015 9:55 pm

Nice triple post you got there.
Don't copypasta Quotes

my sondclop


Return to “General Talk”

Who is online

Users browsing this forum: No registered users and 2 guests