Page 1 of 4

Triplet Calculator

Posted: Sat Aug 08, 2015 6:05 pm
by Scomo
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!

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 6:24 pm
by Xyz
imo shortcuts like these can make a user dependent on them and weaken their understanding of how the tracker actually works.

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 7:14 pm
by MiniMacro
I can't open it because it says it is corrupt. Is it possible to fix this?

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 8:16 pm
by ollaxe
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.

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 8:40 pm
by HertzDevil
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.

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 9:23 pm
by Mojitone
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

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 9:41 pm
by Scomo
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.

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 9:50 pm
by Scomo
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.

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 9:51 pm
by Scomo
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?

Re: Triplet Calculator

Posted: Sat Aug 08, 2015 9:55 pm
by retrodpc
Nice triple post you got there.