Sunday, July 22, 2012

Glasgow Coma Scale Chart

The Glasgow Coma Scale (or GCS) aims to give a reliable way of recording the conscious state or a person for assessment. Many of my recent posts have centered on sports (especially football spreadsheets) so today I thought I would go in a completely different direction. One area I have never touched on in this blog is the medical profession and how Excel is used in hospitals and rehabilitation centers. The Glasgow scale is used in the field of therapeutic recreation, among others.

The GCS scale is broken down into three main behaviors or activities: Eye Opening (E), Motor Responses (M), and Verbal Responses (V). Each of these behaviors can be rated based on some predefined criteria. Each criterion is given a point value from one to six. To obtain the final GCS coma score simply add the results from the three previous behaviors (Summed Glasgow Coma Scale Score= E+M+V). The final score should fall between 3 and 15 points where a score of 8 is the midpoint. Any Glasgow Coma score below the midpoint shows serious damage.

I have made a blank template of the GCS scale which you can download and print out for free.

On a related note, you can also read about and download a template for the Ranchos Los Amigos Scale which is also known as the Level of Cognitive Functioning Scale or LCFS. LCFS is a medical scale used to assess individuals after a closed head injury.

For more information on how to pass the NCTRC exam to become a CTRS visit

Is this information helpful to you? Would you like to see more health and human services related Excel templates and forms? Please feel free to comment below or Tweet me and let me know your thoughts. Your feedback will only help make this blog better.

Saturday, July 14, 2012

2012 NCAA Football Helmet Schedule

Doug Woodworth is the creator of the 2012 NCAA college football helmet schedule spreadsheet. I recently had the opportunity to ask him about the origins of the helmet schedule and how he creates this wonderful college football spreadsheet every fall season. Thanks to Doug for taking the time to fill us in on the details!

I have been creating football helmet schedule spreadsheets for since the 2007 season. I created only the FBS schedule in 2007 and asked MG for permission to share it with my friends. MG happened to like the schedule and asked for my permission to post it on his website. The following year I added the FCS, and the NFL. In subsequent years I have created numerous special requests to include high school, NCAA Div. II, Div. III, and NAIA conferences, plus the annual bowl games schedule.

As I became more familiar with Excel, I tried to add a new feature or detail annually.

In 2007 I locked the schedule with a password because I did not want users to accidentally move or delete the helmets or text, like I had done many times while creating it. I was informed that many users wished to edit or color-code the schedules to keep track of wins-losses and other statistics, which could not be done if the schedules were locked. The overall design was unimpressive as there was very little color and I had chosen Arial font throughout.

In 2008 I unlocked the schedules and added a 'Place in This Document' hyperlink to the helmets, which allowed users to click their way through the different conferences or sheets. Adding the hyperlinks somewhat locked the helmets to the cells as they could only be moved with a right-click. ScreenTips were added to the helmets to display conference affiliation. The header was changed to display MG's official header. I added some color to the dates and conference/division rows, which gave a better look. Non-formal game indicators were changed to a letter code rather than the MM/DD format, which created less clutter at the top of the cells.

In 2009 the helmets were hyperlinked using 'Existing File or Web Page' which automatically opens the file or workbook of the selected helmet. With many FBS vs. FCS games being played regularly, this feature made it easy for users to click back and forth between the two schedules. This feature was especially helpful when I created schedules for every team of the Ohio High School Athletic Association. 722 teams were divided among 70 conferences, which were divided among 6 separate regions or files, yet they were all interconnected. To accomplish this feature, the hyperlink address must be typed to include the file name, followed by #, followed by the sheet name, followed by !, followed by the cell reference.

For example: example.xls#example_sheet!A4

In 2010 MG updated his helmet template, which displayed very sharp in the schedules. I added new or changed color to several details. The font was changed to Calibri. Comments were added to cells to easily hover and display the venue and location of neutral-site games. I realized that by dragging the helmets into the sheet rather than copying and pasting, the helmet backgrounds showed transparent rather than a white box. When users color-coded their printable football schedules, the entire cell would now be colored. I was finally pleased with the overall design, information, and color scheme.

The design has remained the same since 2010. My method for creating the football schedules has also remained the same.

1. drag the helmets from into the home cells in column A for each conference
2. select all helmets and resize
3. select all helmets and center within the home cells
4. type the hyperlink address for the first helmet
5. copy the hyperlink address from the first helmet minus its cell reference
6. paste the hyperlink address to the corresponding helmets adding the correct cell reference
7. type the team name into the home cell after horizontal and vertical alignment are set properly

With the helmets and text in place I begin to copy and paste until the schedules are complete, referencing several websites along the way. I then go back to notate the non-formal and neutral-site games. I also edit the ScreenTip of the helmets in the home cells to display the team nicknames. The 'Freeze Panes' feature is utilized so that the header, dates, and conference/division rows remain at the top when scrolling down.

The schedules have become rather popular. In fact, shortly after the BCS National Championship Game and Super Bowl, I receive many emails from fans asking when the schedules will be complete for the next season. The schedules are usually released in early summer.

I would like to thank the many fans who email with their kind comments and suggestions. I would also like thank MG for allowing me to display my work and creating these awesome helmets. Without him, these schedules would not exist.

Thanks again to Doug for the very informative description. As I said earlier, this is probably the best NCAA football spreadsheet out there and is very helpful for my office football pools. About the only thing it is missing is the NCAA football television schedule.Maybe an addition for next year?

To download the NCAA 2012 helmet schedule spreadsheet visit MGHelmets. Then visit our downloads page for more sports Excel templates. 

You can also download the 2012 NFL helmet schedule here. Which teams are you cheering for?

Let's Go Buckeyes! 

Tags: 2012 ncaa football schedules, ncaa football 2012, football schedules ncaa, ncaa football scores ncaa football scores, ncaa football 12 spreadsheet

If you found this blog to be useful at all please use the share buttons below to help spread the word...

Thursday, July 12, 2012

Printable 2012 NFL Schedule Spreadsheet

I’ve put together a printable 2012 NFL football spreadsheet complete with the full schedule and team helmets. The Excel spreadsheet has two main sheets, one for the AFC team’s schedules and one for the NFC. Then, within each sheet I break each league down by divisions. I’ve also done the extra work on this NFL spreadsheet to indicate which games are featured on Monday night football as well as oddball days like Wednesday and Thursday night games.

This is a great tool for fantasy football players who can add on to this spreadsheet to help keep track of your stats. It can also be used in office football pools. If you want you can copy your favorite team’s schedule onto a new sheet and print it out to hang on the fridge or office cubicle. The 2012 NFL season is just around the corner (the Cleveland Browns first preseason game is August 10th) so download this printable football schedule today.

Please keep in mind these schedules are subject to change at any time – you never know when some team’s stadium roof is going to collapse forcing them to change the day and site of the game. Another side note: a popular search term on Google is for “nfl football football.” Really? It must be a simple mistake. I tried to make the best NFL printable schedule so please let me know in the comments below if you have any ideas for improvement.

Visit our downloads page for more football and other sport Excel template downloads. 
Download the NCAA 2012 college football helmet schedule here.

Dominate your fantasy football league by using the best draft guide. What are your fantasy strategies this year?

Not Starting Michael Vick

If you found my blog helpful at all please use the share tools below to help spread the word...