The Musician's Workbook

Press "Shift" and click on this link to download the Musician's Workbook (Excel 97) Now

General

This article is about an Excel spreadsheet that provides a variety of solutions for the engineer as well as musician. I hope you will find it useful.

Content

Speaker Enclosure Design

This spreadsheet allows you to design vented speaker enclosures based on the Thiele-Small parameters. By entering the free air resonance (fr), Q (resonance magnification), and compliance (Vas) of the speaker, the optimum box volume is calculated. You may enter a custom box volume and see the plotted frequency response. It also calculates the vent dimensions based on the box tuning frequency. A section for designing closed or acoustic suspension boxes is also included.

Instrument Frequencies

This spreadsheet graphs the audible frequency range of various instruments including their harmonics.

Note Frequencies

A table of musical note frequencies are calculated based on the equal tempered scale or 12th root of 2.

Fret Spacing

Design your own fretboard based on a specific scale length.

String Tension

This spreadsheet tabulates string tensions of various standard and non-standard string gauges. For more details on custom string gauge design refer to Vol. 2 - Custom String Gauge Design.

Harmonics

Graph the voltage waveform based on the Fourier Series with specific even and odd-harmonic amplitudes.

Fret Spacing

Design your own fretboard based on a specific scale length.

Speaker Cable Loss

Design your speaker gauge for negligible loss and power handling capability.

Sound Pressure Levels

Comparison of sound pressure level of real life sources.

Velocity of Sound

Derive preset delay nodes in long hall systems based on distance and temperature.

Nady Wireless Frequencies

Don't let other systems interfere. Know your wireless frequencies.

Jeff Newman Universal Tuning Chart

Contains Jeff's tempered tuning and setup.

Terry Downs Universal Tuning Chart

Contains my tempered tuning and setup.

Nut String Spacing Calculator

Calculates centerline locations of string spacing for a specific string gauge and nut width to give equal spacing between the strings.

About the Musician's Workbook

I developed this workbook to help in my everday solutions with music and live performance. Use and distribute as you wish. Please retain the entire workbook with this copyright sheet intact. I will provide updates as I get new requests for ideas.

©1999-2006 Terry Downs Music™