Call for scaling spreadsheets

[Jason Kanter]

Thanks!
I can handle MSWorks. 

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?

  ----- Original Message ----- 
  From: Richard Moody 
  To: 'Pianotech List' 
  Sent: Thursday, September 28, 2006 10:53 AM
  Subject: RE: Call for scaling spreadsheets


  If any of you have and are willing to share your scaling spreadsheets - please send to me





  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.  



  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).   



  =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.

     If you want beat rates send a three dollar bill.  



  R Moody



    

                      "You can't wait for inspiration. You have to go after it with a club". 

                Jack London







  -----Original Message-----
  From: pianotech-bounces at ptg.org [mailto:pianotech-bounces at ptg.org] On Behalf Of Jason Kanter
  Sent: Tuesday, September 26, 2006 4:49 PM
  To: Pianotech List
  Subject: Call for scaling spreadsheets



  List

  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.



  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.



  What do you measure, and what formulas do you apply, and what are the dependencies, constraints and limits? The parameters suggested by Ric include:



    Inputs:   

    Diameters 

    lengths 

    type of string material?



    Outputs:

    inharmonicity 

    tension

    breaking point % 

    frequency.



    For bass strings:

    how do you deal with wrapping?



  And since we will no doubt be looking to improve scaling, what kinds of what-ifs would you like to automate?



  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.



  Jason
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://www.moypiano.com/ptg/pianotech.php/attachments/20060928/04400c85/attachment-0001.html