<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.5700.6" name=GENERATOR>
<STYLE>@font-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.Style1 {
FONT-SIZE: 14pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
LI.Style1 {
FONT-SIZE: 14pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
DIV.Style1 {
FONT-SIZE: 14pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
P.style10 {
FONT-SIZE: 14pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
LI.style10 {
FONT-SIZE: 14pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
DIV.style10 {
FONT-SIZE: 14pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
SPAN.emailstyle19 {
FONT-WEIGHT: normal; COLOR: windowtext; FONT-STYLE: normal; FONT-FAMILY: Arial; TEXT-DECORATION: none
}
SPAN.EmailStyle21 {
FONT-WEIGHT: bold; COLOR: teal
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue bgColor=white>
<DIV><STRONG><FONT color=#008080 size=2>Thanks!</FONT></STRONG></DIV>
<DIV><STRONG><FONT color=#008080 size=2>I can handle MSWorks.
</FONT></STRONG></DIV>
<DIV><STRONG><FONT color=#008080 size=2></FONT></STRONG> </DIV>
<DIV><STRONG><FONT color=#008080 size=2>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?</FONT></STRONG></DIV>
<DIV><STRONG><FONT color=#008080 size=2></FONT></STRONG> </DIV>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #008080 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=remoody@midstatesd.net href="mailto:remoody@midstatesd.net">Richard
Moody</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=pianotech@ptg.org
href="mailto:pianotech@ptg.org">'Pianotech List'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, September 28, 2006 10:53
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: Call for scaling
spreadsheets</DIV>
<DIV><BR></DIV>
<DIV class=Section1>
<P class=MsoNormal><STRONG><B><FONT face="Times New Roman" color=teal
size=2><SPAN style="FONT-SIZE: 10pt; COLOR: teal">If any of you have and are
willing to share your scaling spreadsheets - please send to
me</SPAN></FONT></B></STRONG></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial">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. </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial">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). </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial">=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.</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"> If you want beat
rates send a three dollar bill. </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial">R Moody</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"> </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial">
</SPAN></FONT><FONT face="Courier New" size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: 'Courier New'">"You can't wait for
inspiration. You have to go after it with a club". </SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: 'Courier New'">
Jack London</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=4><SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original
Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B>
pianotech-bounces@ptg.org [mailto:pianotech-bounces@ptg.org] <B><SPAN
style="FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Jason Kanter<BR><B><SPAN
style="FONT-WEIGHT: bold">Sent:</SPAN></B> Tuesday, September 26, 2006 4:49
PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Pianotech
List<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Call for
scaling spreadsheets</SPAN></FONT></P>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">List</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">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.</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">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.</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">What do you measure, and what formulas do
you apply, and what are the dependencies, constraints and limits? The
parameters suggested by Ric include:</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<BLOCKQUOTE style="MARGIN-TOP: 5pt; MARGIN-BOTTOM: 5pt; MARGIN-RIGHT: 0in">
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Inputs: </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">Diameters </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">lengths </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">type of string
material?</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">Outputs:</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">inharmonicity </SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">tension</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">breaking point %
</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt">frequency.</SPAN></FONT></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">For bass
strings:</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">how do you deal with
wrapping?</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></DIV></BLOCKQUOTE>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">And since we will no doubt be looking to
improve scaling, what kinds of what-ifs would you like to
automate?</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">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.</SPAN></FONT></B></STRONG></P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"
size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<DIV>
<P class=MsoNormal style="MARGIN-LEFT: 0.5in"><STRONG><B><FONT
face="Times New Roman" color=teal size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: teal">Jason</SPAN></FONT></B></STRONG></P></DIV></DIV></BLOCKQUOTE></BODY></HTML>