JI Notation Spreadsheet

User avatar
George Secor
Site Admin
Posts: 19
Joined: Tue Sep 01, 2015 11:36 pm
Location: Godfrey, Illinois, US

JI Notation Spreadsheet

Postby George Secor » Fri Apr 22, 2016 10:59 am

Sagittal-JI.xls
Sagittal JI notation for factored ratio
(181.5 KiB) Downloaded 30 times
Eight years ago I created a spreadsheet that computes Sagittal notation for any factored JI ratio (up to the 61 prime limit) at 4 different levels of precision. See attachment "Sagittal-JI.xls". Enter a (signed) integer corresponding to a prime factor into each of the cyan-colored cells below each prime number. The mixed Sagittal notation appears in the colored cells from A9 thru E15.

User avatar
Dave Keenan
Site Admin
Posts: 221
Joined: Tue Sep 01, 2015 2:59 pm
Location: Brisbane, Queensland, Australia
Contact:

Re: JI Notation Spreadsheet

Postby Dave Keenan » Fri Apr 22, 2016 12:33 pm

Thanks George. How hard would it be to add a one-symbol-per-prime notation to that? Or should that be the subject of a separate spreadsheet?

Juhani
Posts: 31
Joined: Sun Sep 06, 2015 12:14 am

Re: JI Notation Spreadsheet

Postby Juhani » Fri Apr 29, 2016 1:33 am

And would it be possible to make a version, possibly an online calculator on this forum, with actual Sagittal accidentals rather than the extremely-unpleasant-to-read and off-putting ASCII symbols? - I now got the Spreadsheet working, though, I don't know what the problem was previously: it didn't calculate anything. It's an excellent tool! It would be great if there were a Sagittal notation calculator with staff notation, the actual accidentals (and perhaps, the Sagispeak names), as well as playback. Such a program already exists for the Sabat JI notation system.

User avatar
Dave Keenan
Site Admin
Posts: 221
Joined: Tue Sep 01, 2015 2:59 pm
Location: Brisbane, Queensland, Australia
Contact:

Re: JI Notation Spreadsheet

Postby Dave Keenan » Fri Apr 29, 2016 2:51 pm

Juhani wrote:And would it be possible to make a version, possibly an online calculator on this forum, with actual Sagittal accidentals rather than the extremely-unpleasant-to-read and off-putting ASCII symbols? - I now got the Spreadsheet working, though, I don't know what the problem was previously: it didn't calculate anything. It's an excellent tool! It would be great if there were a Sagittal notation calculator with staff notation, the actual accidentals (and perhaps, the Sagispeak names), as well as playback. Such a program already exists for the Sabat JI notation system.

Hi Juhani,

Glad to hear you got it working. It would be fairly straightforward for anyone with a little familiarity with Excel, to make George's spreadsheet display the accidentals as the proper strings of symbols from the Bravura font. It would require that the user install the Bravura font on their computer prior to using the spreadsheet. The conversion would only require laboriously working through the lookup tables where the ASCII symbols appear, in columns V W AA AB AF AG AK AL and replacing them with the corresponding Bravura characters. It might make sense to have two copies of the spreadsheet open side-by-side, to read one and modify the other.

For many years now it has been possible to use Manuel Op de Coul's Scala program to display Sagittal notation on the staff, mixed or pure, for any of the four JI precision levels (as well as for EDOs). Unfortunately it doesn't do multi-Sagittal, although I'm guessing that might be fairly easy for Manuel to implement, if enough people asked him nicely. We clearly underestimated the interest in that.

Yes, an online notation calculator that didn't require the full complexity of Scala would be nice. But I'm afraid it's outside my skillset. I hope someone reading this will volunteer. I'm sorry I still haven't got onto an Apple Mac to try the SvS JI calculator.

User avatar
George Secor
Site Admin
Posts: 19
Joined: Tue Sep 01, 2015 11:36 pm
Location: Godfrey, Illinois, US

Re: JI Notation Spreadsheet

Postby George Secor » Tue May 24, 2016 12:39 pm

I have made a minor update to the Sagittal JI spreadsheet that resolves a problem associated with the one-symbol-per-prime notation. Previously there was no way to distinguish 41C (81:82) from 5C (80:81), which were represented by the same symbol :/|: at the olympian (or extreme precision) level. By defining the symbol boundaries using 809-EDA (magrathean) rather than 233-EDA (olympian) values, the lower boundary for :/|: is increased slightly so that 41C is now notated by :/|: :.: without affecting any of the olympian-level symbol definitions.
Attachments
Sagittal-JI.xls
Sagittal JI notation for factored ratio
(107.5 KiB) Downloaded 28 times


Return to “Just Intonation notations”

Who is online

Users browsing this forum: No registered users and 1 guest

cron