Call for scaling spreadsheets

[William Benjamin]

Jason,

 

When you find out what a whaddyagot is would you send it to me for my list
of definitions?

 

William

 

 

 

 

William

 

 

 

 

PIANO BOUTIQUE

William Benjamin

Piano Tuner Extraordinaire

www.pianoboutique.biz

The tuner alone,

preserves the tone.

 

  _____  

From: pianotech-bounces at ptg.org [mailto:pianotech-bounces at 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

 

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 <mailto:remoody at midstatesd.net>  Moody 

To: 'Pianotech List' <mailto:pianotech at ptg.org>  

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/778bcfaa/attachment.html