Is there some way to "jump" to a specific record, or do I have to use the arrow buttons? Example: File opens at ID 1, but I want to look at ID 25 out of 50.

Also, once I've entered the records, is there a way to re-organize them so that all the records from each customer are consecutive? Otherwise, as I add new records for a new ball, the records alternate from one customer to another, and back and so on. Or should I use a separate database for each customer?

But overall, I'm really liking this.

At the moment you have to use the Arrow Buttons,BUT you can use the Filter options in the bottom left to return fewer records to have to move through(The ID isn't an option here as it is only row identifier, so it could change if records are deleted or re-sorted)Am also considering changing the arrows to a slider (like the sensitivity bar), which will allow you to jump through more than 1 record at a time.

It is intended that you only have the one database, so will look at allowing the Data Table to be sorted.In theory there is an option when protecting worksheets to allow sorting, but I must of done something to prevent it working.

Is there some way to "jump" to a specific record, or do I have to use the arrow buttons? Example: File opens at ID 1, but I want to look at ID 25 out of 50.

Also, once I've entered the records, is there a way to re-organize them so that all the records from each customer are consecutive? Otherwise, as I add new records for a new ball, the records alternate from one customer to another, and back and so on. Or should I use a separate database for each customer?

But overall, I'm really liking this.

I don't think you really want to try and remember specific record ID's because there is no need to do so that I can think of. I think it's best to go straight to the customers name to look up their history. Besides, on the main page he's already designed in the drop down list of all your previous customers under "Bowler"

What's important is to find a specific customer provided he/she has already beenentered into the database at least once. Over time then when you filter by name (using the Bowler (Name) drop down box) you instantly jump to that customers history and you'll be able to see at a glance all the previous work/drilling's you've done in the past. It does not get any better than this.

You could also (for example) filter all the 60 x 4 x 40 layouts you've done in the past for all your customers in this same way. Or, maybe, find all the bowlers with the same PAP coordinates. Find all the bowlers with the same rev rate... no problem. The possibilities are endless since you can combine filters and ask... show me all my customers who throw 15 lb balls at 16 mph. I think it's perfect the way it's designed now. When you become more experienced in how Excel filters work and how to combine them you'll quickly realize the power behind this wonderful spread sheet.

The database was created for my local Pro Shop, and is written in Excel 2010 and VBA.It holds Grip Measurements and also Dual Angle Layout with a graphical layout.

It's available for anyone to use for Free

Attachment:

Drill Sheet Database v3-0-1.zip

Edit: Original Zip File Corrupted. New Zip File Uploaded 26 Feb'14Macros need to be enabled within Excel.Sheets are protected to prevent any inadvertent changes to formulae etc.Password’s available upon request to unprotect sheets.

This new version 3-0-1, - addresses a couple of typos in non-essential formulae- adds in a conversion of "track diameter" to tilt angle

Also, in the zip file there is a second spreadsheet that queries the database, so it can be used to create your own "reports" without affecting the database. The initial pivot table it creates is based on a request, but you can then tailor it to your individual needs.

Please send any feedback or suggestions for improvements.

Cheers

Kris(Excel4Bowling)

Improvements Currently Requested- Ovals for Thumb & Fingers(I believe that there are several methods for oval-ing holes, and would like to include the most common ones, so any help in understanding how people mark-up their paper drill sheets will be most useful)- Ability to Sort Data TableImproves ability to keep a bowlers records consecutively

Kris,Awesome work with the spread sheet. Even as is, with some bugs, there are many that will just use it to see what a layout is going to look like. That being said once you get it to a point your happy with Please get with MegaMav and get it put into the Wiki.

Kris,Awesome work with the spread sheet. Even as is, with some bugs, there are many that will just use it to see what a layout is going to look like. That being said once you get it to a point your happy with Please get with MegaMav and get it put into the Wiki.

EricDo you have any examples of the bugs?I'll see if I can't squish them before I post another release.(With work and currently taking my builder to Small Claims Court, it will probably be a couple of months before it will be ready)I will include some code to import data from the current version into future ones, so no-one will need to re-enter any records that they put into this current version.

Full roller and over rolled full roller layouts won't work due to limits for pin distances,PAP, drilling and VAL angles. I'm thinking that might be a daunting task to be able to incorporate into the layouts. I still think it is Wiki worthy with out that functionality.

Drill Sheet Database version 5 now availableThere are several big changes:- Layouts can be entered by either Dual Angle or VLS systems- Fields have been increased to capture, what I hope, is the vast majority of useful information- Improved user interfaceStill a great tool for keeping your own records, discussing layout ideas, and for Pro Shops to keep their customer's layouts.

To save hijacking a forum, etc.I've started a Facebook page to help manage any modification requests and technical issues that anyone may have.www.facebook.com/excel4bowlingFor those of you not on Facebook, you can still contact me through the PM on this forum.Just realised that if you're not on Facebook that you cant see the Notes and Screenshots.They're now attached to Post #1 of this thread

Thanks for your patience& I look forward to your enlightening queriesThey have been most useful to me while developing this tool& a planned update that I hope to roll out soon (-ish)

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum