Mechanical Music Digest 
You Are Not Logged In Login/Get New Account
Please Log In. Accounts are free!
Logged In users are granted additional features including a more current version of the Archives and a simplified process for submitting articles.
Home Archives Calendar Gallery Store Links Info
MMD > Tech > drhodes_strng

Mathematics of Stringing
Mathematics of Stringing
by Doug Rhodes (MMDigest 96.07.03)

Preface by Terry Smythe

Some months ago, I posted an appeal for help in dealing with a basket case reproducing grand that someone else had started and I acquired it without treble strings or scaling documentation.  Among those who responded with help and advice was Doug Rhodes from Victoria, BC.    It seems that Doug had previously developed a spreadsheet that would help with my problem, and he kindly shared it with me, after fine tuning it and its formulae.

After receiving the package, I undertook to convert the Excel spreadsheet into the lowest level of Lotus 1-2-3 (.WK1/ALL), and its companion Microsoft Word 6.0 documentation into the lowest level ASCII documentation.  For those among us who do not have Microsoft Word 6.0 or Excel, the other file should be acceptable into most any word processor or spreadsheet.  Doug's introduction to his documentation is below.  Many thanks Doug, very much appreciated.


Terry Smythe
Date: Wed, 3 Jul 1996 19:38:33 CDT

Mathematics of Stringing

The "Calculating Technician" spreadsheets are derived from a series of articles of the same name by Dave Roberts, which originally appeared in The Piano Technicians Journal in the early 1980's.  The spreadsheet adaptation was developed by Douglas K. Rhodes, R.P.T.  No remuneration is expected nor accepted for the use of this adaptation. Treat it as freeware.

Two versions are available from me for the Macintosh on 800K discs.  They are written with Excel 3.0a . They are formatted as "stationery" files - one in English units, and one in metric.  They are identical in all other respects.

All abbreviations for entered and calculated factors are the same as used by Dave Roberts in his articles, and all formulas (except T - tension, which is modified to accommodate the pitch option described below) are adapted for spreadsheet application essentially un-changed.

All cell entry references in this text are in accordance with the Excel designations for rows and columns, and will correspond to the sample calculations and formulas handouts. Enter all appropriate file information at top left of data file, column 2.  Be sure to identify whether data is original or modified. If you modify the data, SAVE the original data as a separate file.

It is highly recommended that you purchase and read The Calculating Technician by Dave Roberts, the book form of his articles, which is available from the PTG. (32 kb) 96-05-01 (22 kb) 96-07-03

30 January 2001

Home    Archives    Calendar    Gallery    Store    Links    Info   

Enter text below to search the MMD Website with Google

CONTACT FORM: Click HERE to write to the editor, or to post a message about Mechanical Musical Instruments to the MMD

Unless otherwise noted, all opinions are those of the individual authors and may not represent those of the editors. Compilation copyright 1995-2024 by Jody Kravitz.

Please read our Republication Policy before copying information from or creating links to this web site.

Click HERE to contact the webmaster regarding problems with the website.

Please support publication of the MMD by donating online

Please Support Publication of the MMD with your Generous Donation

Pay via PayPal

No PayPal account required

Translate This Page