TexasCHLforum.com

Charles L. Cotton wrote:

Crossfire wrote:Charles - I have tried to use your spreadsheet, but unfortunately, we always have one instructor for classroom and the other for range. Have you considered a modification that would allow for that?

I can do that. I'll try to get it done in the next day or two.

Chas.

Crossfire wrote:Charles - I have tried to use your spreadsheet, but unfortunately, we always have one instructor for classroom and the other for range. Have you considered a modification that would allow for that?

Leatherneck Arms wrote:

Charles L. Cotton wrote:I have been working on an Excel spreadsheet that has both the CHL-100 and the CHL-8 Certificate of Class Completion. I was having trouble with the time input in a form that would add a range of cells in hours and minutes (instead of decimal hours), so Sgt. Bamsch helped with that part. (Now I know how to do that.) I have a little more to finish, then I'll make it available to all instructors. Hopefully, I can publish it by the end of this week, but my Granddaughter is coming in Wednesday and being Grandpa comes first!

With the spreadsheet, you will have a data entry page where you will enter everything related to the class. Much of the information will be the same for all students, such as the date, range location, instructor, etc., while some will be student-specific. When the data is entered, all CHL-100's and the CHL-8 will be automatically filled in and all you have to do is print and sign the forms.

DPS has approved the forms for use by instructors.

Chas.

I'm new to the Forum so forgive any redundancy but was the above described spreadsheet ever made available? If so, where? I just finished the instructor course and Sgt Bamsch mentioned it as a good resource.