 SagittalJI.xls
 Sagittal JI notation for factored ratio
 (181.5 KiB) Downloaded 181 times
JI Notation Spreadsheet
 George Secor
 Site Admin
 Posts: 31
 Joined: Tue Sep 01, 2015 11:36 pm
 Location: Godfrey, Illinois, US
JI Notation Spreadsheet
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 "SagittalJI.xls". Enter a (signed) integer corresponding to a prime factor into each of the cyancolored cells below each prime number. The mixed Sagittal notation appears in the colored cells from A9 thru E15.
 Dave Keenan
 Site Admin
 Posts: 268
 Joined: Tue Sep 01, 2015 2:59 pm
 Location: Brisbane, Queensland, Australia
 Contact:
Re: JI Notation Spreadsheet
Thanks George. How hard would it be to add a onesymbolperprime notation to that? Or should that be the subject of a separate spreadsheet?
Re: JI Notation Spreadsheet
And would it be possible to make a version, possibly an online calculator on this forum, with actual Sagittal accidentals rather than the extremelyunpleasanttoread and offputting 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.
 Dave Keenan
 Site Admin
 Posts: 268
 Joined: Tue Sep 01, 2015 2:59 pm
 Location: Brisbane, Queensland, Australia
 Contact:
Re: JI Notation Spreadsheet
Hi Juhani,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 extremelyunpleasanttoread and offputting 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.
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 sidebyside, 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 multiSagittal, 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.
 George Secor
 Site Admin
 Posts: 31
 Joined: Tue Sep 01, 2015 11:36 pm
 Location: Godfrey, Illinois, US
Re: JI Notation Spreadsheet
I have made a minor update to the Sagittal JI spreadsheet that resolves a problem associated with the onesymbolperprime 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 809EDA (magrathean) rather than 233EDA (olympian) values, the lower boundary for is increased slightly so that 41C is now notated by without affecting any of the olympianlevel symbol definitions.
 Attachments

 SagittalJI.xls
 Sagittal JI notation for factored ratio
 (107.5 KiB) Downloaded 144 times