Documentation of Racquet work done

lwto

Hall of Fame
Just curious, I realize there are a lot of Racquet techs, Stringers and such, so I was wondering if anybody documents their work. Do you use a database, spreadsheet to keep logs of stringing, work on individual racquets. Is that something that is worthwhile doing or do you all think it is not worth the effort?

Like I said I"m just curious, I'll tell you why. I've been working on a database, access to create a client Db, with their racquets, stringing jobs, holds all the stringing info such as Tie offs, Main skips and that stuff. I imported it all from a site.. I"m almost done with it and at some point I'd like to share it. It's quite simple but I think it might be handy to some.

Anyway, like I said, just wondering how everyone documents their work. There is a wealth of info and knowledge so I'd like to hear from everyone.

Cheers!
 

lwto

Hall of Fame
Yeah, thanks, looked, and not bad at all.
Basically the same thing.. has some good references.
I will continue to use mine, mine is local, a lot faster and more customizable and it is prettier :)
 

Ash_Smith

Legend
We run a simple spreadsheet to document the customer details, racquet details, initial DT, string, tension etc + plus any customisation work done.

Works for us.

Ash
 

GPB

Professional
I'm a home stringer with less than 100 stringjobs to my name, and I keep everything written down in a notebook. So old-fashioned!

When I get to the end of the notebook, I'll move along to a database (stringjob.com or my own) but for now this works for me.
 

dgdawg

Semi-Pro
I was using a recipe box with "flash cards" until the light bulb turned on!! :shock:
The spread sheet works really well. Plus I use an online back up (in addition to other means) for this folder and a bunch of others.
I'm big time paranoid of loosing anything!
 

lwto

Hall of Fame
So this is some screen shots that I've been working on.. mind you, it is rough and there are still things I want to add. For now, I'm just working on making sure it is solid and cohesive.

The nice thing about it is that once you have your players, clients loaded, really not more to do but add the service part.




This screen is the main screen, showing the active players your stringing for, of course these are all fictional and just used for now to test and debug.

They won't allow me to post more than 4 pics at a time so.. I will have to spare you all from seeing the client details of the form. It shows the usual address, phone etc.


Click open on the main menu and the details of the player come up..If you click on "the sticks" his racquet inventory pops up



Selecting open again, will give you the details.




Along with that you can view the stringing details with one click and finally click the Service button will give you the service job form.



Ultimatly this will allow you to keep a historical log of string jobs and technical work for his racquets as well as printing and creating labels.

So anyone have any comments, what else I should add please let me know, I"m really interested in what your feedback is.
 

lwto

Hall of Fame
3/4" label.... 18mm Brother PT-2730. I thought a saw at some point an "export" function. This is a screen shot of my simple log


Send me an email, blabolat@gmail.com, You don't have to export anything, it should be pretty easy to do, I won't take space on the forum to explain.
Side note: you can merge cells.. for instance, find a empty cell somewhere and use the append command.. kinda like this =A1&" "&A2&" "&A3" to combine all the info you want.

If you have Pmate software installed, you have a add-in for excel that you can evoke and pmate will ask you what cell you want to print.. select that cell, edit it and will print, i tried it. it works. A more eloquent way will involve a little more initial work to setup but in the long run will be easier and more automated.
 
Last edited:

mad dog1

G.O.A.T.
i use excel for everything! checkbook register, retirement planning, loan payment calculator, to toast my bagel, make coffee, iron clothes :mrgreen:
 

dgdawg

Semi-Pro
I use an Excel spreadsheet, too. Easy to set up, use and is a solid program.
Hey man-I think we chatted in another thread.
I got some yamaha edrums and used them for a NYE gig, w/acoustic cymbals.
My acoustic yamies are hitting craigslist as soon as I get the onions to sell them!!
 

dgdawg

Semi-Pro
Send me an email, blabolat@gmail.com, You don't have to export anything, it should be pretty easy to do, I won't take space on the forum to explain.
Side note: you can merge cells.. for instance, find a empty cell somewhere and use the append command.. kinda like this =A1&" "&A2&" "&A3" to combine all the info you want.

If you have Pmate software installed, you have a add-in for excel that you can evoke and pmate will ask you what cell you want to print.. select that cell, edit it and will print, i tried it. it works. A more eloquent way will involve a little more initial work to setup but in the long run will be easier and more automated.
Thanks man-I'll look into it. I'm not much of an excel guy but it'll be worth a shot if I can get if I can get it kickin
 
I've created database applications for work, for myself and for friends from old DOS based Paradox thru to Access today. One of the things that appeals to me with stringing is NOT having to stare at a computer screen or type away on a keyboard. I don't even listen to music.

I created a basic form, that I write down information to track each individuals racquet, string, tension, notes.....you name it. When I need more pages I copy the original. Very "old school", but it's portable, easily updated, convenient in any setting and I like it!
 

StanW

Rookie
I train my brain enough so that I'm able to recall a friend's info from my memory.

It's ancient really.
 

rufusbgood

Semi-Pro
I don't use Excel for much of anything. I kind of hate it. I am curious how those of you who use it do your data inputting. For instance, I see in dgdawg's spreadsheet that one of the racquets was strung with Genesis Typhoon. Did you have to type in the name in that cell or do you have a drop down list of string names to choose from? The beauty of doing this with a database is that names of strings, names of racquets, names of grips once stored in a table are available for selection with the click of a mouse.
 

beernutz

Hall of Fame
I don't use Excel for much of anything. I kind of hate it. I am curious how those of you who use it do your data inputting. For instance, I see in dgdawg's spreadsheet that one of the racquets was strung with Genesis Typhoon. Did you have to type in the name in that cell or do you have a drop down list of string names to choose from? The beauty of doing this with a database is that names of strings, names of racquets, names of grips once stored in a table are available for selection with the click of a mouse.
Copy and paste is your friend. Once you've entered in the data for someone's racquet it is pretty easy to repeat it on their next stringing. I may have to edit a cell or two but I rarely type in the entire contents of a cell. YMMV.
 

mad dog1

G.O.A.T.
Copy and paste is your friend. Once you've entered in the data for someone's racquet it is pretty easy to repeat it on their next stringing. I may have to edit a cell or two but I rarely type in the entire contents of a cell. YMMV.
in addition to copy and paste, auto fill and auto complete is also helpful. w/ auto complete, if the name exists above, i just type the first few letters and the rest of the name automatically appears.
 

lwto

Hall of Fame
Of course.. If you use a Identification number for each racquet.. say 3 digests.. once you had the racquet.. you enter the number into excel.. if you used the hlookup function, excel would automatically enter all the static data needed.. That would automate it a lot.
 

dgdawg

Semi-Pro
I don't use Excel for much of anything. I kind of hate it. I am curious how those of you who use it do your data inputting. For instance, I see in dgdawg's spreadsheet that one of the racquets was strung with Genesis Typhoon. Did you have to type in the name in that cell or do you have a drop down list of string names to choose from? The beauty of doing this with a database is that names of strings, names of racquets, names of grips once stored in a table are available for selection with the click of a mouse.
Yeah....just once tho. Everything auto fills as long as it's been entered once.
I don't have a list of string or grips, or anything.
I'd love to be able to figure out how to print a label from my spread sheet, but I'm an excel moron.
It's been explained, but I didn't understand it. I'm fairly "tech suave", but I just don't get excel.
 

drummerdan

Semi-Pro
Hey man-I think we chatted in another thread.
I got some yamaha edrums and used them for a NYE gig, w/acoustic cymbals.
My acoustic yamies are hitting craigslist as soon as I get the onions to sell them!!
Yep. That's me.

Sell those acoustic tubs - you'll never look back!!
 

Lakers4Life

Hall of Fame
Date, Name, Racket, String, Tension, Previous String, Price, Cost and Remarks. I try to keep it simple as possible. I hate having to scroll to the right to find data. I guess you can create Worksheets by month or year. I just do it by year for now.
 

dgdawg

Semi-Pro
What items do you all keep in your spreadsheets? Name, phone number, address, racquet info, etc...?
This is another screen shot of my simple log sheet.
I know nothing about excel. Like someone else said, once something is already there, a cell will "auto fill"
Cool thing is, you can email this off to your customer if you needed.
I mailed this one to this guy.

 
Top