Computerized Stringing Records

I have created a Microsoft Excel workbook containing different spreadsheets to keep track of various aspects of my stringing business. It features:

An invoice template to generate and print a final invoice.
An order form. This is set to print “two up” on a letter-size piece of paper. After printing, I cut each sheet down the middle lengthwise, producing two order forms. Each customer fills out a form when dropping off a racquet, which I attach around the grip of the racquet with a rubber band.
An invoice record log.
A logbook to record stringing information. This worksheet is set up so I can easily generate reports on any column. For example, I can quickly look at all jobs for a particular customer, jobs for a single racquet frame, jobs by string type, etc.
Racquet IDs. I give each frame a number, which I track. In the logbook I can pull up any ID and know how many times I have strung the corresponding racquet, when I have strung it, and with what string.
String Inventory. I keep track of my string inventory to make certain I have sufficient supplies of the strings I list on my order form. And by keeping costs up to date, I also know how much money I have tied up in working capital. I do about 350 racquets a year, and try to keep my string inventory below $2,000.
Maintenance and calibration. This is where I keep some simple notes about maintenance and adjustments to my stringing machine.

5 sets of Wilson Reaction 16 & a Wilson Tournament Bag to:

Dan McManus, Auburn, WA

**Editor’s note:** USRSA members who are interested in obtaining a copy of Dan’s spreadsheet can find it on-line here: McManus Logbook

RSI magazine search