<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 11 (filtered medium)">  <style>  </style>  </head> <body bgcolor=white lang=EN-US link=blue vlink=purple> <div class=Section1> Jason,<o:p></o:p> <o:p> </o:p> When you find out what a whaddyagot is would you send it to me for my list of definitions?<o:p></o:p> <o:p> </o:p> William<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> William<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <o:p> </o:p> <div> PIANO BOUTIQUE<o:p></o:p> William Benjamin<o:p></o:p> Piano Tuner Extraordinaire<o:p></o:p> <a href="http://www.pianoboutique.biz">www.pianoboutique.biz</a><o:p></o:p> The tuner alone,<o:p></o:p> preserves the tone.<o:p></o:p>  <o:p></o:p> </div> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center tabindex=-1> </div> From: pianotech-bounces@ptg.org [mailto:pianotech-bounces@ptg.org] On Behalf Of Jason Kanter Sent: Thursday, September 28, 2006 3:12 PM To: Pianotech List; Richard Moody Subject: Re: Call for scaling spreadsheets<o:p></o:p> </div> <o:p> </o:p> <div> Thanks!<o:p></o:p> </div> <div> I can handle MSWorks. <o:p></o:p> </div> <div>  <o:p></o:p> </div> <div> The most pressing formula at the moment is inharmonicity. There seems to be a wide range of methods for looking at this. Some of them use "special sauce." (arcane lookup tables, mysterious constants). Whaddyagot?<o:p></o:p> </div> <div>  <o:p></o:p> </div> <blockquote style='border:none;border-left:solid teal 1.5pt;padding:0in 0in 0in 4.0pt; margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'> <div> ----- Original Message ----- <o:p></o:p> </div> <div style='font-color:black'> From: <a href="mailto:remoody@midstatesd.net" title="remoody@midstatesd.net">Richard Moody</a> <o:p></o:p> </div> <div> To: <a href="mailto:pianotech@ptg.org" title="pianotech@ptg.org">'Pianotech List'</a> <o:p></o:p> </div> <div> Sent: Thursday, September 28, 2006 10:53 AM<o:p></o:p> </div> <div> Subject: RE: Call for scaling spreadsheets<o:p></o:p> </div> <div> <o:p> </o:p> </div> If any of you have and are willing to share your scaling spreadsheets - please send to me<o:p></o:p>  <o:p></o:p>  <o:p></o:p> Glad to see your post Jason.   It turns out all my scaling spreadsheets are in MSWorks or Quattro Pro and getting them over to xcel is easier done by re doing them by hand in excel rather than trying to import or copy.   For any spread sheet, the formulas of course have to be “translated” into computeresse   as in the twelfth root of two, you have to type in  exactly    =2^(1/12)      The  nice thing about this is you can cut and paste from this email into your spread sheet and it operates.  (don’t get spaces before or after the cut)    So if we can share complicated formulas like bass string  tension or inharmonicity it would be easy to do by email or posting to this list.  <o:p></o:p>  <o:p></o:p> I figured out a bass string tension formula that is calculated by the actual weight of the string--- that is if I can dig it up from my W95 MSWorks spread sheets.  I have 3 bass string formulas from (McFerrin and Calculating Technician plus another from a reprint in a Journal).   <o:p></o:p>  <o:p></o:p> =LOG(K11/J11)/LOG(2)*1200   Cut and paste this into any spread sheet in cell J 13. Now  you can see cents difference if you enter the frequencies in K11 and J 11 of your spread sheet…. And wouldn’t you know it,  the beat rate between 440 and 443 is minus 11.8 cents.   -11 cents?   Oic just set up the spread sheet so the higher numbers get entered before the lower numbers.<o:p></o:p>    If you want beat rates send a three dollar bill.  <o:p></o:p>  <o:p></o:p> R Moody<o:p></o:p>  <o:p></o:p>   <o:p></o:p>                     "You can't wait for inspiration. You have to go after it with a club". <o:p></o:p>               Jack London<o:p></o:p>  <o:p></o:p>  <o:p></o:p>  <o:p></o:p> -----Original Message----- From: pianotech-bounces@ptg.org [mailto:pianotech-bounces@ptg.org] On Behalf Of Jason Kanter Sent: Tuesday, September 26, 2006 4:49 PM To: Pianotech List Subject: Call for scaling spreadsheets<o:p></o:p>  <o:p></o:p> <div> List<o:p></o:p> </div> <div> If any of you have and are willing to share your scaling spreadsheets - please send to me. In response to Ric Brekne's recent suggestion, I am offering to use my Excel skills to take a crack at making a nice, user-friendly, efficient graphing spreadsheet that we can all use to improve our study and understanding of this area of the craft. I will compile the best ideas and hopefully come up with something really useful.<o:p></o:p> </div> <div>  <o:p></o:p> </div> <div> I don't presently know much about scaling, but I do know Excel and have access to the "Calculating Technician" Journal series where a lot of this was discussed.<o:p></o:p> </div> <div>  <o:p></o:p> </div> <div> What do you measure, and what formulas do you apply, and what are the dependencies, constraints and limits? The parameters suggested by Ric include:<o:p></o:p> </div> <div>  <o:p></o:p> </div> <blockquote style='margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt'> <div> Inputs:   <o:p></o:p> </div> <div> Diameters <o:p></o:p> </div> <div> lengths <o:p></o:p> </div> <div> type of string material?<o:p></o:p> </div> <div>  <o:p></o:p> </div> <div> Outputs:<o:p></o:p> </div> <div> <div> inharmonicity <o:p></o:p> </div> <div> tension<o:p></o:p> </div> <div> breaking point % <o:p></o:p> </div> <div> frequency.<o:p></o:p> </div> <div>  <o:p></o:p> </div> <div> For bass strings:<o:p></o:p> </div> <div> how do you deal with wrapping?<o:p></o:p> </div> <div>  <o:p></o:p> </div> </div> </blockquote> <div> And since we will no doubt be looking to improve scaling, what kinds of what-ifs would you like to automate?<o:p></o:p> </div> <div>  <o:p></o:p> </div> <div> I am proposing this as a volunteer project, the output to be freely available. Maybe that idea creates difficulties since it might "compete" with commercially available programs. If that's an issue, let me know and we'll think about it.<o:p></o:p> </div> <div>  <o:p></o:p> </div> <div> Jason<o:p></o:p> </div> </blockquote> </div> </body> </html>