Re: New CHL-100
Posted: Wed Oct 12, 2011 8:54 pm
Just checked the website and the CHL100 form is still not posted...hmmmmm..... 
Not required to use it until January.
Use your old ones up.
The focal point for Texas firearms information and discussions
https://mail.texaschlforum.com/
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.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.
Yes. Mine is set up assuming the same instructor will be teaching both the classroom and range portion of the class.Leatherneck Arms wrote: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.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 can do that. I'll try to get it done in the next day or two.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?
Sorry it took longer to get to than I anticipated, but I've changed the spreadsheet to allow for different instructors for the classroom and range portions of the CHL class. I also moved the spreadsheet to the Instructors Corner. viewtopic.php?f=18&t=48919" onclick="window.open(this.href);return false;Charles L. Cotton wrote:I can do that. I'll try to get it done in the next day or two.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?
Chas.