View Full Version : Is there a more user friendly DOJ list somewhere?

Single Six
07-15-2010, 10:12 AM
IE I want to search by barrel length AND caliber, 1911s only etc...?

07-15-2010, 10:33 AM
I recall impact gun let's you pick make of gun and it's up to date as of the day you search IIRC

07-15-2010, 6:07 PM
But, no, not from the state. It is what it is - foolish in concept and primitive in implementation.

Single Six
07-15-2010, 6:15 PM
curses. cursed state full of idiot politicians. sorry. mad.

07-15-2010, 6:35 PM

Single Six
07-15-2010, 6:47 PM
do. but somehow it's not working like it's supposed to. we get freedoms trampled and things rammed down our throats regardless of how we vote.

07-15-2010, 7:41 PM
You don't have the list memorized by now. It isn't that long, and only gets smaller... :(

07-15-2010, 8:29 PM
To make a custom list.

1. Go to the DOJ Website and open the latest Roster
2. Highlight the entire list, right click and select COPY
3. Open Excel, start a new workbook, select a cell and PASTE; the entire list is now in a workbook
4. Start one Row and one Cell above the list, press the Left mouse key and drag to the Right and down until the entire list is highlighted (including the first row above the list).
5. From the Tool Bar, select DATA, then FILTER, followed by, AUTO FILTER.
6. Now the upper Row has several “down arrows”. Using these “filters” you can select on any options you like.

1. The list is a little inconsistent with naming (.45 caliber appears as .45, .45 ACP and 45 Auto), so you will need to make a few changes to fix the list.
2. Use EDIT-REPLACE to fix mistakes or the change (and eliminate) extra text. For example to fix the .45 variations select the Column and use: Find what: .45 along with Replace with .45 ACP.

Extra Points
1. If you are really clever, you can use TRIM function to remove extra spaces in the text, delete characters like ( ) / “,”with EDIT-REPLACE by finding them and replacing with nothing. Change finishes to single words (reason to follow), with the goal of have the TITLE only containing the model name, number and finish as single words. (Make sure to make a duplicate copy before starting, just in case)
2. Now the big switch. Highlight the entire TITLE column and replace the “spaces” with “commas”. Copy the entire TITLE and PASTE into WORD. Save the WORD file as TEXT (i.e filename.txt). In this TEXT file will be rows of characters, separated by commas, with a paragraph mark at the end of each row. Open the TEXT file in EXCEL (excel works very well with comma delimited files, like what was just created). Follow the instructions and you create a new Workbook with the TITLE broken into multiple ROWS. With a little work, copy and paste the expanded TITLE back into the original file and just about any part or piece can be individually searched!

07-15-2010, 10:03 PM
IE I want to search by barrel length AND caliber, 1911s only etc...?

Another problem is there are very few 1911's that are listed as the model being "1911"....nope...just not advertising savvy....they pretty much have to use names like "Raptor", "Champion", "Stinger", "CQB"...etc., etc. to try to make their product stand out.

Unless you know what is what, it's going to be difficult to distinguish what is and is not a 1911 from just the DOJ list....