Stringing logbook

***kwun*** · 05-15-2012, 03:07 PM

Originally Posted by kwun

i added a new column to my logbook: income. now i know i am 1/7th of the way through to have the machine pay for itself. (not including rackets done for me and janet)

well it certainly was hardwork but with that record saved in the logbook, purely from clients alone i have already paid for both my machines and more. and that's not counting the money saved from not having to pay labor for my and my wife's stringing.

nowadays i don't even ask my frequent clients what string they need, i just ask them if they want the same string/tension as before and they usually just say, "OK". then i look it up from the log.

**CanucksDynasty** · 05-15-2012, 03:21 PM

Kudos.

Now you can trade up to buy an ECP (Victor C-7030)

.

**Optiblue** · 05-15-2012, 04:47 PM

I too have had a log book for a few years now in a spreadsheet

**zombie0517** · 05-15-2012, 09:27 PM

Kwun, thanks for the post. Here's mine:

Client's Name
String type
Client's own string
Tension (incl main and cross)
Pattern (incl knots)
Racquet
Grommet replacement
Price
Dates (Collection, strung, return)
Note/Comments

All on excel spreadsheet. Very similar to yours

Just curious how you manage to get all the serial numbers of clients' racquets since for me, most of my customers wrap their handles rather high

***kwun*** · 05-15-2012, 10:18 PM

in those cases, i don't. usually i can see the shaft serial which is sufficient. if i cannot, then i just don't record it...

**Mark A** · 05-16-2012, 02:51 AM

Date
Name
Racket/String@Tension
Price

All I need for recall and tax purposes.

**Udonming** · 05-16-2012, 01:40 PM

1) On small hand written notebook
a) date
b) customer name
c) racket (* denote a fake)
d) string
e) tension
f) $
2) Easy Note on my Android phone with individual customer name , and each note will show all racket that particular customer has strung.
a) racket
b) string and tension
c) label (yymmdd-#)stick on the cap.
3) An excel sheet stored in my phone, showing the # of different string that I've strung on my phone. I update every month.

***kwun*** · 05-16-2012, 01:51 PM

i still think Google Doc Spreadsheet is the best way to go.

i can access it from any computer/phone as long as i am online.

**ckyew** · 05-16-2012, 04:02 PM

Mine is kept on a spreadsheet on excel but left in Dropbox so that I can access it anywhere whenever I'm online.

**Jonster** · 05-16-2012, 07:04 PM

I record the Name, Racquet, String, Tension as well as the transactions.

It also helps to say you remember your customer's tension or have it recorded. It is one of those small things that a customer may remember you for.

**kakinami** · 05-17-2012, 02:10 AM

Logged in 2013 rackets in 2011 not including tournaments maybe another 600. maybe did at least 1500 of the 2000. Jr Nationals, Adult Nationals, US Open, Pan American Games, World Championships, and a couple of Local tournaments. Good to keep a log, refer back to customers tensions and when they last strung their racket. Also interesting to compare serial numbers too, if a customer loses a racket and same serial number pops up under another name red flag. It did happen to me.

**BlueTornado** · 05-17-2012, 02:39 AM

Originally Posted by kakinami

Logged in 2013 rackets in 2011 not including tournaments maybe another 600. maybe did at least 1500 of the 2000. Jr Nationals, Adult Nationals, US Open, Pan American Games, World Championships, and a couple of Local tournaments. Good to keep a log, refer back to customers tensions and when they last strung their racket. Also interesting to compare serial numbers too, if a customer loses a racket and same serial number pops up under another name red flag. It did happen to me.

Recording the serials, nice. What did you end up doing when you found the racket in the wrong hands though?

**kakinami** · 05-17-2012, 04:12 AM

Originally Posted by BlueTornado

Recording the serials, nice. What did you end up doing when you found the racket in the wrong hands though?

Got it back to the right owner. It was a kid who misplaced it and another teammate found it, couldnt find the owner. Looked up serial #'s and saw same # and different people. It was a player I knew so I mentioned it to him and he got it back.

**BlueTornado** · 05-17-2012, 05:48 PM

Originally Posted by kakinami

Got it back to the right owner. It was a kid who misplaced it and another teammate found it, couldnt find the owner. Looked up serial #'s and saw same # and different people. It was a player I knew so I mentioned it to him and he got it back.

Oh, glad to hear it got back to the rightful owner. At first it sounded like it had been stolen.

**aqua26** · 10-20-2012, 11:52 AM

Here is the log book I hope everyone can use it.
https://dl.dropbox.com/u/12549920/Gutting%20Log.xlsm

**Fidget** · 10-20-2012, 01:37 PM

Originally Posted by aqua26

Here is the log book I hope everyone can use it.https://dl.dropbox.com/u/12549920/Gutting%20Log.xlsm

Very nice. I see the 'price charged' column, but where is the even more important PAID column? :-/

**aqua26** · 10-21-2012, 12:05 AM

Originally Posted by Fidget

Very nice. I see the 'price charged' column, but where is the even more important PAID column? :-/

Ohh Thanks a lot.
Well I have made Changes to the same file you can re-download it from same spot.
I take all the amount upfront as a advance so never thought about it. (It reduces the losses in case you break the racket

)