{"id":493,"date":"2017-08-16T17:10:35","date_gmt":"2017-08-16T16:10:35","guid":{"rendered":"http:\/\/www.hilltop-cottage.info\/blogs\/adam\/?p=493"},"modified":"2017-08-16T17:18:29","modified_gmt":"2017-08-16T16:18:29","slug":"spreadsheet-to-assist-melodeon-tuning","status":"publish","type":"post","link":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/spreadsheet-to-assist-melodeon-tuning\/","title":{"rendered":"Spreadsheet to Assist Melodeon Tuning"},"content":{"rendered":"<p>Here is a simple spreadsheet to assist with tuning two voiced melodeons:\u00a0<a href=\"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-content\/\/2017\/08\/Melodeon-Tuning.xlsx\">Melodeon Tuning Spreadsheet<\/a> (Excel).<\/p>\n<p>It has been set up for, and contains working data from, my D\/G Hohner Pokerwork retune. I created it for two main purposes: 1) to plot the existing tuning; 2) to calculate the amount of de-tune for a Viennese tuning with an equal beat all the way up the scale (also known as Dedic tuning from Ian Dedic). I also used it to measure the tuning on a fairly new Serenellini melodeon with drier tuning, to get a better idea of what the tuning of a newish mid-range melodeon is like.<\/p>\n<p>Some notes on using the spreadsheet for those who don&#8217;t want to find out by fiddling:<\/p>\n<ul>\n<li>leave the &#8220;Notes Lookup&#8221; sheet alone; it contains the look-up from the piano key numbers to the note name and frequency.<\/li>\n<li>On the sheets &#8220;G Row&#8221; and &#8220;D Row&#8221;:\n<ul>\n<li>change the entries in the &#8220;Piano Key&#8221; column if your button layout or keys are different; &#8220;Note Name&#8221; and &#8220;Concert Freq&#8221; change automatically.<\/li>\n<li>If you want to find the tuning to achieve a constant beat frequency, alter the values in cells F3 and G3. I have chosen 4Hz (beats per second), which is in the tremolo range, and set this as -2Hz\/+2Hz for Viennese tuning.<\/li>\n<li>Alternatively&#8230; it is common for accordions to be tuning with tapering amounts of reed de-tuning going up the scale, with the beat increasing somewhat. Entering values into row K will compute the beat frequency in row L.<\/li>\n<\/ul>\n<\/li>\n<li>The sheets &#8220;&#8230; Measurements&#8221; should automatically populate the left-most columns. This should be mostly self-explanatory. I made columns to record measurements with the reed in the box and on the reed block on a tuning table, computing the difference (&#8220;delta&#8221;). Since tuning on the table is far easier than in the box, I use this to estimate a correction to my target tuning when using the table.\n<ul>\n<li>The &#8220;block hole number&#8221; is just a reference to my numbering of the holes on the chord block&#8230; its very confusing working out which reed is which!<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>I you are interested in <a href=\"http:\/\/forum.melodeon.net\/index.php\/page,voices_tunings.html\">melodeon tunings<\/a>, or in the practicalities of tuning a melodeon, the <a href=\"http:\/\/forum.melodeon.net\/\">melnet forums<\/a> are essential reading.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is a simple spreadsheet to assist with tuning two voiced melodeons:\u00a0Melodeon Tuning Spreadsheet (Excel). It has been set up&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-493","post","type-post","status-publish","format-standard","hentry","category-melodeon","post-archive"],"_links":{"self":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/posts\/493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/comments?post=493"}],"version-history":[{"count":7,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/posts\/493\/revisions"}],"predecessor-version":[{"id":501,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/posts\/493\/revisions\/501"}],"wp:attachment":[{"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/media?parent=493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/categories?post=493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hilltop-cottage.info\/blogs\/adam\/wp-json\/wp\/v2\/tags?post=493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}