Call for scaling spreadsheets

[Richard Moody]

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/02a5cd4a/attachment.html