Melodeon.net Forums

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the new melodeon.net forum

Pages: [1]   Go Down

Author Topic: Tuning Spreadsheets  (Read 1521 times)

0 Members and 1 Guest are viewing this topic.

Peadar

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2039
Tuning Spreadsheets
« on: July 15, 2021, 09:54:13 PM »

I know a couple (at least) of members use tables/spreadsheets for logging pitch frequencies before tuning boxes.

I am trying to work out how best to lay out a table for collecting pitch data from a number of boxes.

Object is to sample existing pitches/tuning of  pre 1930 boxes, from  Scottish sources, that have not been (so far as one can tell) retuned.

I am looking for ideas on how best to tabulate the information for later plotting/reporting
Logged

Rob2Hook

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2278
  • Castagnaris, Hohners & Baffetti
Re: Tuning Spreadsheets
« Reply #1 on: July 15, 2021, 10:56:12 PM »

I don't think there's a quick way.  Don't skimp on detail, it's a case of rubbish in rubbish out.  I did a spreadsheet for a Pokerwork and then couldn't get the hand of the actual tuning.

For my purposes, I recorded every reed individually, then a second set of readings outside the box to establish an offset to allow closer tuning on the blocks in the hope the offset would hold good and give better initial tuning when refitted in the box.

From these tables of frequencies graphs can be created to characterize the tuning, in particular the tremolo offset across the range of the instrument.  As it was a Hohner I was dealing with, the graph will have discrepancies but will indicate the intended character of the instrument.  I presume you intend to recreate the original character of the instruments you are refurbishing and although you may choose to pitch to A=440Hz you can recreate the profile of the original tremolo.

Rob.
Logged

Peadar

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2039
Re: Tuning Spreadsheets
« Reply #2 on: July 16, 2021, 12:12:41 AM »

I don't think there's a quick way.  Don't skimp on detail, it's a case of rubbish in rubbish out.  I did a spreadsheet for a Pokerwork and then couldn't get the hand of the actual tuning.

For my purposes, I recorded every reed individually, then a second set of readings outside the box to establish an offset to allow closer tuning on the blocks in the hope the offset would hold good and give better initial tuning when refitted in the box.

From these tables of frequencies graphs can be created to characterize the tuning, in particular the tremolo offset across the range of the instrument.  As it was a Hohner I was dealing with, the graph will have discrepancies but will indicate the intended character of the instrument.  I presume you intend to recreate the original character of the instruments you are refurbishing and although you may choose to pitch to A=440Hz you can recreate the profile of the original tremolo.

Rob.
I am aiming to retain the original tuning characteristics and original pitchings. But I am actually trying to esablish what tunings/pitching was typical  in the Scottish domestic market 1900-1920
Logged

Roger Hare

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 949
  • Urmston, Lancashire, U.K. éééé
Re: Tuning Spreadsheets
« Reply #3 on: July 16, 2021, 11:40:03 AM »

...But I am actually trying to esablish what tunings/pitching was typical  in the Scottish domestic market 1900-1920...
I've attached a short edited version of an article I found on concertina.net a while ago (I can't find the original now!).
It contains an abbreviated table of pitches for different tunings. It may be useful?

You may already have relevant software, but the 'Tuning and Temperament Aid' on this website:

http://www.concertinas.org.uk/soft.htm

may also be useful? You can select any of 6 'standard' tunings and listen to the whole range.

It's all a bit 'concertina-oriented' of course, and doesn't address your original query directly, but it
may be useful...

« Last Edit: July 16, 2021, 12:22:45 PM by Roger Hare »
Logged
My ABC tune collections can be found here (GoogleDrive) & here (Dropbox).

For more about Manchester Morris, The Beech Band Folk Club or anything else,  please use the private messaging facility.

Chris Ryall

  • "doc 3-row"
  • French Interpreter
  • Hero Member
  • *****
  • Offline Offline
  • Posts: 11153
  • Wirral UK
    • Chris Ryall
Re: Tuning Spreadsheets
« Reply #4 on: July 16, 2021, 04:05:58 PM »

Just did one this afternoon! My samples run A-A over 5 octaves with Melodeon Explorer layout paradigm now in C.  It was ...either rename 61 file names, or make a lookup table.   I've pasted the [ code ] grid below, but SMF still sort of mangles the tabs with in it.  Screenshot from Ecxel also attached

The range works quite well, both for G/C and D/G ... bit I did sample from a real G/C accordion.  The mp3ss and ogg files are kept at eg. https://chrisryall.net/chords/sound/27.mp3 (middle C).   The range runs from 0.mp3 to 60.mp3  (:)

Code: [Select]

C C# D Eb E F F# G Ab A Bb B
C0 C#0 D0 Eb0 E0 F0 F#0 G0 Ab0 A0 Bb0 B0
C1 C#1 D1 Eb1 E1 F1 F#1 G1 Ab1 A1 Bb1 B1
C2 C#2 D2 Eb2 E2 F2 F#2 G2 Ab2 A2 Bb2 B2 <= lowest sample
C3 C#3 D3 Eb3 E3 F3 F#3 G3 Ab3 A3 Bb3 B3 <=12
C4 C#4 D4 Eb4 E4 F4 F#4 G4 Ab4 A4 Bb4 B4 <=24
C5 C#5 D5 Eb5 E5 F5 F#5 G5 Ab5 A5 Bb5 B5 <=36
C6 C#6 D6 Eb6 E6 F6 F#6 G6 Ab6 A6 Bb6 B6 <=48
C7 C#7 D7 Eb7 E7 F7 F#7 G7 Ab7 A7 <=60

0 1 2
3 4 5 6 7 8 9 10 11 12 13 14
15 16 17 18 19 20 21 22 23 24 25 26
27 28 29 30 31 32 33 34 35 36 37 38
39 40 41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56 57 58 59 60

A2:0, Bb2:1, B2:2,
C3:3, C#3:4, D3:5, Eb3:6, E3:7, F3:8, F#3:9, G3:10, Ab3:11, A3:12, Bb3:13, B3:14,
C4:15, C#4:16, D4:17, Eb4:18, E4:19, F4:20, F#4:21, G4:22, Ab4:23, A4:24, Bb4:25, B4:26,
C5:27, C#5:28, D5:29, Eb5:30, E5:31, F5:32, F#5:33, G5:34, Ab5:35, A5:36, Bb5:37, B5:38,
C6:39, C#6:40, D6:41, Eb6:42, E6:43, F6:44, F#6:45, G6:46, Ab6:47, A6:48, Bb6:49, B6:50,
C7:51, C#7:52, D7:53, Eb7:54, E7:55, F7:56, F#7:57, G7:58, Ab7:59, A7:60, ]
« Last Edit: July 16, 2021, 04:10:46 PM by Chris Ryall »
Logged
  _       _    _      _ 

Rob2Hook

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2278
  • Castagnaris, Hohners & Baffetti
Re: Tuning Spreadsheets
« Reply #5 on: July 16, 2021, 05:53:19 PM »

Ah yes, I think I understand.  It depends just how much detail you are hoping to identify.  I'd map the frequency of every reed and use the data to establish the best fit for pitch across the range.  I'd also look for any discrepancies that repeat across the octaves as that would suggest something other than equal temperament tuning.  As I said earlier, you should be able to, either mathematically or graphically, characterize the profile of the tremolo applied.

All the characteristics you identify can then be used to create a tuning chart for the pitch it is in.  I have my suspicions that the bass tuning may be the best indicator of original pitch, as they will have been tuned to absolute pitch and probably often more carefully than the melody reeds where the tremolo hides poor tuning.

Of course, if the box has drifted way out of tune, it may be difficult to say with any certainty what pitch it was originally.  I believe a Wiki search should give you details of the common pitches used over the last century, so the best bet might be the closest pitch above where it is now...

Rob.
Logged

Quebecois

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 1206
  • Accordez-vous donc, c'est si beau, l'accordéon!
Re: Tuning Spreadsheets
« Reply #6 on: July 16, 2021, 07:58:57 PM »

A pitch is a pitch! What makes the sound typical of a box is the tremolo between the reed sets and the acoustic properties of the instrument. I would think that after 75 or 80 years, some of the reeds would have developed variations from their original tuning. Not sure what we would achieve in copying "wrong" pitches to get a nice sound! I recently re-tuned a few boxes using an old Peterson strobe tuner, putting one set of reeds "spot on", and the others at 10 cents lower for the middle-range reeds and about 5 for the lower and upper ranges, but the final tuning is with the ear! Copying an old accordion's reed pitches does not guarantee that the copy will sound anywhere like the original without substantial tweaking.
« Last Edit: July 16, 2021, 08:01:04 PM by Québécois »
Logged
Hohner Morgane D/G, pre-Erica Hohner in C/F and G/C,
Hohner Erica A/D, Roland FR-18

Peadar

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2039
Re: Tuning Spreadsheets
« Reply #7 on: July 16, 2021, 08:48:57 PM »

The methodology I am going for is isolate a reed. Sound it and measure the frequency. Take 3rd note push as "Doh" and see where that takes me.

When you do an experiment you don't know the outcome beforehand.

Logged

Tone Dumb Greg

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 4955
    • Dartmoor Border Morris
Re: Tuning Spreadsheets
« Reply #8 on: July 16, 2021, 08:56:11 PM »

The number one man I know for this sort of thing is Mike Rowbotham. Maybe a PM?
Logged
Greg Smith
DG/GC Pokerwork, DG 2.4 Saltarelle, pre-war CF Hohner, Hohner 1040 Vienna style, old  BbEb Hohner that needs a lot of work.

ACCORDION, n. An instrument in harmony with the sentiments of an assassin. Ambrose Bierce

Peadar

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2039
Re: Tuning Spreadsheets
« Reply #9 on: July 19, 2021, 12:04:54 PM »

All, Thanks for the suggestions - On further thinking I realised that  tabulation of data is a key part of the design of any study - so I've got to design it myself to meet my own aims and objectives.
Logged

Theo

  • Administrator
  • Hero Member
  • *****
  • Offline Offline
  • Posts: 14475
  • Hohner Club Too
    • The Box Place
Re: Tuning Spreadsheets
« Reply #10 on: July 19, 2021, 12:36:54 PM »

Rather than measuring the frequency, (or as well as) it’s possible to measure the pitches as offsets from ET.  That makes it easier to interpret the figures before you start plotting graphs.
Logged
Theo Gibb - Gateshead UK

Proprietor of The Box Place for melodeon and concertina sales and service.
See my YouTube channel  for videos on repair and tuning

Winston Smith

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 4066
  • AKA Edward Jennings
    • "Our Luxor B&B" Luxor life, slice by slice.
Re: Tuning Spreadsheets
« Reply #11 on: July 19, 2021, 07:13:21 PM »

"I've got to design it myself to meet my own aims and objectives"

Of course! Then you're sure that you're not incorporating anyone else's mistakes.
Logged
At last, broken and resigned to accept conformity.
Oh, how I LOVE Big Brother!

Peadar

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2039
Re: Tuning Spreadsheets
« Reply #12 on: July 19, 2021, 11:00:22 PM »

Rather than measuring the frequency, (or as well as) it’s possible to measure the pitches as offsets from ET.  That makes it easier to interpret the figures before you start plotting graphs.

That's a very good point - plotted offsets may also be easier to interpret than two very close lines on a graph.


(Edit: To correct typo)
« Last Edit: July 20, 2021, 03:20:31 PM by Peadar »
Logged

Tone Dumb Greg

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 4955
    • Dartmoor Border Morris
Re: Tuning Spreadsheets
« Reply #13 on: July 20, 2021, 12:06:44 AM »

"I've got to design it myself to meet my own aims and objectives"

Of course! Then you're sure that you're not incorporating anyone else's mistakes.

Just reinventing the wheel.

I'm not sure analysing old boxes is really going to be that much help, though. I find it hard to believe they would still reflect the original setup with any degree of accuracy.

Old cylinder recordings might, if you've got a good ear, though they would need calibrating.
Logged
Greg Smith
DG/GC Pokerwork, DG 2.4 Saltarelle, pre-war CF Hohner, Hohner 1040 Vienna style, old  BbEb Hohner that needs a lot of work.

ACCORDION, n. An instrument in harmony with the sentiments of an assassin. Ambrose Bierce

Theo

  • Administrator
  • Hero Member
  • *****
  • Offline Offline
  • Posts: 14475
  • Hohner Club Too
    • The Box Place
Re: Tuning Spreadsheets
« Reply #14 on: July 20, 2021, 08:21:54 AM »

It can produce useful results Greg,  but you are quite right to say they are imperfect.  It makes sense to make notes about the condition of the reeds, and any steel reeds with significant rust or signs of heavy filing won’t provide meaningful measurements. 

I’ve learned a great deal from recording the pitches of reeds in old instruments.  The most important thing I’ve learned is that many old German instruments are not tuned to ET,  nor to any of the historical temperaments.  There is evidence that the scales used were designed specifically for diatonic instruments where only three push notes can be played together and only four pull notes. It’s a similar principle to Cajun tuning, though not identical.
Logged
Theo Gibb - Gateshead UK

Proprietor of The Box Place for melodeon and concertina sales and service.
See my YouTube channel  for videos on repair and tuning

Tone Dumb Greg

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 4955
    • Dartmoor Border Morris
Re: Tuning Spreadsheets
« Reply #15 on: July 20, 2021, 12:45:04 PM »

...There is evidence that the scales used were designed specifically for diatonic instruments where only three push notes can be played together and only four pull notes...

Is the practice of having a push and a pull fifth, giving 5 pull notes a more recent development?
Would the push and pull fifths be tuned the same?
Or, where they just not that fussy?
Logged
Greg Smith
DG/GC Pokerwork, DG 2.4 Saltarelle, pre-war CF Hohner, Hohner 1040 Vienna style, old  BbEb Hohner that needs a lot of work.

ACCORDION, n. An instrument in harmony with the sentiments of an assassin. Ambrose Bierce

rees

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 5055
  • Windjammer
    • Wesson Accordions
Re: Tuning Spreadsheets
« Reply #16 on: July 20, 2021, 01:28:53 PM »

Push and pull fifth goes right back to the first Club system instruments - 1920s/1930s?
Push and pull are tuned the same.
Logged
Rees Wesson (accordion builder and mechanic)
Gungrog, Welshpool, Wales, UK
www.melodeons.com

Rob2Hook

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 2278
  • Castagnaris, Hohners & Baffetti
Re: Tuning Spreadsheets
« Reply #17 on: July 20, 2021, 02:21:54 PM »

I like the idea of rearranging the data , introducing an offset from ET so as to emphasize deviations and allow them to be more obvious in a graphical depiction, especially if the range is matched correctly.  This can demonstrate tuning to a different temperament as the same basic pattern of deviations from ET should appear in each octave.  In the case of the tremolo reeds, a best fit curve can be established to define the profile and allow the tuning to be done to that original profile.

Just to reiterate, most older instruments have a lower beat rate on low notes increasing progressively to a faster beat rate on the higher notes.  The chosen range and variance of the tremolo could often denote the manufacturer and the market it was produced for.  As a contrast, the old Viennese tuning, championed in recent times by Ian Dedic, has the two rows set an equal (usually) amount above and below pitch and set to produce the same beat rate throughout the range.

Rob.
Logged

Mike Hirst

  • Hero Member
  • *****
  • Offline Offline
  • Posts: 1433
  • Black Dot B/C, Bastardo C#/D, Corona II GCF
Re: Tuning Spreadsheets
« Reply #18 on: July 20, 2021, 03:23:53 PM »

In my experience most useful for working with historical temperaments is the cross platform tool Scala.
The Scala sequence file format is widely recognised as standard for documenting, altering and defining microtonal tunings when working with MIDI. This could be a useful starting point for documenting historical melodeon tunings.
Logged
Semper idem, sed non eodem modo
Pages: [1]   Go Up
 


Melodeon.net - (c) Theo Gibb; Clive Williams 2010. The access and use of this website and forum featuring these terms and conditions constitutes your acceptance of these terms and conditions.
SimplePortal 2.3.5 © 2008-2012, SimplePortal