Page 1 of 4

### Triplet Calculator

Posted: 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!

### Re: Triplet Calculator

Posted: 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.

### Re: Triplet Calculator

Posted: Sat Aug 08, 2015 7:14 pm
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
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
These are the contents of the entire spreadsheet that change with the single speed variable:

Code: Select all

`B3 = 3 (Speed)B4 = B3B5 = B4 * 4B6 = B5 * 4B10 = B5 / 3B11 = B10 * 2B12 = B11 * 2D3 = 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
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
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
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
HertzDevil wrote:These are the contents of the entire spreadsheet that change with the single speed variable:

Code: Select all

`B3 = 3 (Speed)B4 = B3B5 = B4 * 4B6 = B5 * 4B10 = B5 / 3B11 = B10 * 2B12 = B11 * 2D3 = 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
Nice triple post you got there.