String log book suggestions

shadow01

Rookie
Hey all. What do you use to log your string jobs and what columns do you make to record what data? Also how do you organize the data?

TIA
 

jim e

Legend
I do it the old fashioned way. I write down in a log book. Players name and phone number, date racquet and serial number, string and tension, and what was received with racquet ( like damper, case etc. ). As well as fee for job.
 

shadow01

Rookie
I do it the old fashioned way. I write down in a log book. Players name and phone number, date racquet and serial number, string and tension, and what was received with racquet ( like damper, case etc. ). As well as fee for job.
What about things like #knots, pre stretch, stringing machine settings (speed of pull, cp, etc etc...)?
 

jim e

Legend
I only pre stretch for players that ask for that. No one ever has to date. All natural gut just gets a light manual pre stretch to rid of some coil memory is alI ( no need to record that as all are the same) . I typically string most jobs as 2 piece, or occasionally a one piece if racquet is a natural one piece to string. I only have a CP machine so no need to comment on that.
I typically use medium speed, regular string, except for poly strings, I then switch to poly setting, but no need to record that as I have string type recorded. Same goes for kevelar setting as if I use that string I set machine for that type of string.Although I haven't used kevlar in a while.
No sense writing a book on each string job.
I will record if I find a small fracture on racquet, that I had a discussion with player on this before I start job along with that being players gamble to have it strung not mine, as well as any grommet issues and if anyone was tubed or replaced. Multiple grommets bad in a racquet, I will tube that one time with multiple tubes, and let them know it's time for a new racquet next if grommets no longer available.
I also record if player supplies string, as no guarantees with those jobs, and they are told that up front.
 
Last edited:

Rabbit

G.O.A.T.
I use an Excel spreadsheet. I have the columns:

StringStringTensionTension
UserMainsCrossesMainsCrossesStrungAmountPaidRacquetNotes

I have summary columns above that have totals for Paid and A/R. The column Paid, if empty, signals that that amount charged needs to be added to the A/R total. That way, I can see if someone owes me money.

I like this better than a log book because if I need to anything about a player's stringing, I can easily subset the spreadsheet by User and get just his/her stringing history.
 

shadow01

Rookie
I use an Excel spreadsheet. I have the columns:

StringStringTensionTension
UserMainsCrossesMainsCrossesStrungAmountPaidRacquetNotes

I have summary columns above that have totals for Paid and A/R. The column Paid, if empty, signals that that amount charged needs to be added to the A/R total. That way, I can see if someone owes me money.

I like this better than a log book because if I need to anything about a player's stringing, I can easily subset the spreadsheet by User and get just his/her stringing history.
This is great. Do you also keep track of the tie-off, skip, shared holes?
 

jim e

Legend
No reason to keep track of racquet patterns like skips etc. as if I get an unfamiliar pattern, I just look it up on the USRSA Digest as they have most patterns listed for each racquet
 

LOBALOT

Professional
I have basically the same but I break out mains from crosses with make, gauge, tension, and length so I know how much to cut off the reel next time.

I also have a field for material cost and charge so I can be consistent with my customer as to what I charge them.

I have a box where I indicate how I string it and a comment box for anything unique about how I string the racquet.

I also have a box for RT reading so I can check my consistency from one racquet to the next. I suppose I could just look in RT but I write down in the log as well.
 

shadow01

Rookie
I have basically the same but I break out mains from crosses with make, gauge, tension, and length so I know how much to cut off the reel next time.

I also have a field for material cost and charge so I can be consistent with my customer as to what I charge them.

I have a box where I indicate how I string it and a comment box for anything unique about how I string the racquet.

I also have a box for RT reading so I can check my consistency from one racquet to the next. I suppose I could just look in RT but I write down in the log as well.
String length and RT - great ideas.
Anyone use google sheets to manage this so it’s in the “cloud”? Would be interesting to maybe even make a user interface (Form) to populate data. And make a search feature or something.
 

LOBALOT

Professional
String length and RT - great ideas.
Anyone use google sheets to manage this so it’s in the “cloud”? Would be interesting to maybe even make a user interface (Form) to populate data. And make a search feature or something.
Someone out here has an app and it looks pretty neat too. I can't remember where I saw it but have not checked it out.

It would be great if your google doc idea is customer facing with a login where they can specify the main string and tension and cross string and tension. The string can be a drop down from the inventory one has on hand. Then as you use the string it can deduct the amount used and let you know when it is time to order more when there is 200 feet left.

Heck you can print out a PDF of the log sheet when it is complete and attach it to the payment request in Venmo that you send your customer so they have the history!
 

Rabbit

G.O.A.T.
No reason to keep track of racquet patterns like skips etc. as if I get an unfamiliar pattern, I just look it up on the USRSA Digest as they have most patterns listed for each racquet
As @jim e said, I don't keep stringing specifics like skips and such. The notes column is for stuff like if I used a pre-stretch, replaced the grip, etc etc. One thing I do that folks seem to like is I replace their overgrip every time I restring. For this, I charge an extra $5. If they need a new one in between stringings, it's on me. They don't have to worry about anything on their racket.

One key item I didn't specifically mention. If you develop a spreadsheet for your use, you want to make sure and add filters to the columns so you can subset the data. Just in case you aren't that familiar with Excel, if you want an A/R total at the top, make sure you freeze that row and the formula I use is =SUMIF(I3:I3000,"",H3:H3000) where column I has "pd" in it if they've pd and column H has the amount I charged them in it. The total I've billed for stringing is simply a SUM of column H.

One thing, as your spreadsheet grows, you'll need to extend the formulas. Initially, I think it was I3:I500 but as time goes by.... :)

If you send me your email in a PM, I'd be happy to send you my spreadsheet. I'll dummy up the first couple of rows and you can play with it.
 

g4driver

Hall of Fame
Venmo.

Date / Amount / All services provided to each client. If someone asked any info about when their frame was last strung, it's on my phone. I send them a screenshot if I get a request for info. No need to type info twice.

String/Gauge/Tension/ (Grommets if replaced). Labor for each service. For the none Venmo users, I use the Notes portion of my phone.
 

badmice2

Semi-Pro
on top of what's been mentioned above, i have racket in date, racket out date, prestretch, comments, service type/charges

Comments is used for me to make specific notes on a particular job - i.e. they had elbow pain, they switched strings because of shoulder issues, grommet change etc.

I have a separate table with lists to reference a drop down cell for service types and assign cost - i.e. labor only, std string, premium string, string+grommet changes. In the main job tracking sheet, i will use vlookup to reference service type to cost.

I also create a pivot table to get an overall view of all the jobs i've done; it's much easier look at than having to run column filter.
 

socallefty

Professional
@Rabbit Good to see that you are still helping players a lot with your knowledge. I posted on these boards a lot in 2000 when I was out of work for a few months and I remember you from those days. At that time, this board was still relatively new and the focus was more on helping each other with racquet selection, string selection etc. whereas now it seems to be just like any other social media forum with a wide variety of topics.

Took a break from posting here for twenty years although I periodically would come on here to learn about new equipment. With the virus going around, I find myself with a lot of time on my hands again this year and it‘s been entertaining to post regularly again.
 
Last edited:

socallefty

Professional
@socallefty - Hey, man, I remember you very well! Great to see you. Yeah, I still post -- sad ain't it? Things are pretty much the same, you have a few larry hall, nobadmojo types who are grandstanding know-it-alls but that's life :)
See that you are still a Volkl connoisseur - although there seem to be less fans of the brand than there used to be. Maybe because they are making stiff players racquets these days - demo’d the V-Feel 10 (320) and it played well, but was so harsh on my aging elbow. I’ve stuck with Babolat for 20 years moving from the Pure Control (I was a new convert to Babolat in 2000) to the AeroStorm Tour to the Pure Strike Tour (Gen 1 and 3).
 

Brand77

New User
Since I am a bit of a nerd, I created a database with the Memento app. So I have linked tables for people, brands, rackets, strings, etc. Then I have a master table String jobs which combines al the data.
Of course it takes more time to set up, but I actually enjoy that...yeah I know8-B.

This setup allows me to store a lot of details without getting too much clutter. example; from Stringjob, I can tap the racket model field and go to the Rackets table where I have details about string pattern, required length, etc.

So it basically does the same as a big Excel sheet, but with a bit of a geek factor.
 

shadow01

Rookie
Since I am a bit of a nerd, I created a database with the Memento app. So I have linked tables for people, brands, rackets, strings, etc. Then I have a master table String jobs which combines al the data.
Of course it takes more time to set up, but I actually enjoy that...yeah I know8-B.

This setup allows me to store a lot of details without getting too much clutter. example; from Stringjob, I can tap the racket model field and go to the Rackets table where I have details about string pattern, required length, etc.

So it basically does the same as a big Excel sheet, but with a bit of a geek factor.
Nice. I haven’t heard of that app before. Googled it - looks like only available for Android. Otherwise I might have asked you to share your setup - lol!
 
This thread finally made me transfer my notebook to a spreadsheet ;)

Mine has all the obvious fields. Plus columns for the length used and 1 for comments on the length of string used. Just to make sure I learn and waste as little as possible.
 
Top