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.