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.

GlasgowComa Scale download link 1

GlasgowComa Scale download link 2

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 rectherapycenter.com

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.

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 MGHelmets.com 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 MGhelmets.com 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?

-Nick
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...

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.

2012-2013 NFL Helmet Schedule spreadsheet.xls 

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?

-Nick
Not Starting Michael Vick

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

Best Apartment Search Spreadsheet

Looking for spreadsheets for apartments? Introducing the best apartment hunt spreadsheet!

I’ve created a new and improved version of my Apartment Search Spreadsheet template. I spent countless hours maximizing the design until I was certain I had created the ultimate apartment comparison worksheet tool. Like any other product, apartments also have certain attributes (rents, utilities, community/neighborhood, etc.) that need to be identified and prioritized/rated based on their relevance or importance. The importance of these attributes varies from one person to another. The number of parameters involved (easily in excess of 20 parameters) creates a need for a framework that measures and normalizes the results to arrive at a numerical “score” to simplify the decision making process. An excel-based product was created to organize apartment data, assign weights and finally compute scores automatically for the user to evaluate in order to easily figure out which apartment best fits his needs. So, how does it work?

Understanding Bubble chart and Slider:

I use the Apartment Search Spreadsheet to compare features of different apartments using a bubble chart in Excel. A bubble chart is a variation of a scatter plot where each of the data point in the series is represented by a bubble that can vary in size or color depending on the area of the apartment being considered. Larger bubbles represent larger apartment scores.

The bubble chart in the scoring model uses three values per data point:

• X- Axis value : X axis represents the total scores
• Y-Axis value : Y axis represents the total monthly cost
• Bubble Size : Bubble size is proportional to the total area (in square feet)

The apartment search bubble chart is created by an embedded macro which runs through the score data and adds the bubble series, adjusts the colors and fills effects. The chart needs to be updated every time data is modified in the apartment sheet. Once updated, adjustments to the slider updates the chart automatically. The bubbles can also be replaced with apartment pictures, if available and desired. It is advisable to update the chart manually using the command button provided on top right corner of the chart.

To create Bubble charts in Microsoft Excel:

1.      Select data series

2.      Click Insert, Select the Charts

3.      Select the chart type as Bubble

The sliders are added as:

1.      Select Developer

2.      Click Insert

3.      Select the combo box in the form control box

4.      Use Format Control to Cell Link

Excel Sheet with Weighted Rankings

Weights are assigned for each of these categories based on relative importance/relevance. The slider assigns a number ranging from 1 to 100 for each category. The weight for that category is then calculated as “the assigned number divided by the sum of all the assigned numbers for all the categories”. With this weighting logic, an adjustment to the weight of a category automatically changes the weights of the other categories while keeping the total percentage at 100. The horizontal bars, next to the slider, graphically represent the values set by the slider.

Watch the video embedded below to learn how to use the slider and bubble chart features for apartment rent comparison: 

I have invested a significant amount of time and effort into perfecting the comparison spreadsheet as well as researching the best methods to find an apartment. Included in the download is a free pdf copy of my Apartment Search Guide which contains many tips on searching for a new apartment as well as how to use the new spreadsheet and an apartment hunting checklist.

Thanks, and please let me know if you have any questions or comments

.

P.S. YOU can earn 75% commission for every friend you refer. Visit our affiliate page for details.

An Excel Macro to Delete Pictures

How to delete pictures and textboxes based on a range

I recently created an Excelpicture  macro where I deleted a range of rows from my spreadsheet. However, I had a few pictures and textboxes residing inside the area that I wanted to delete. These objects aren’t tied to any individual cell or row so they were originally not being deleted like I wanted. What to do? Time to edit our Excel vba picture macro.

I added a few lines of code which essentially check if the top left corner of the object intersected with any of the cells contained within the range I wanted to delete. If so, and the object was a picture, then it was deleted. Same for the textboxes.

‘Delete pictures

Dim Sh As Shape

   For Each Sh In ActiveWorkbook.Worksheets(I).Shapes

       If Not Application.Intersect(Sh.TopLeftCell, Range("A40:AA120")) Is Nothing Then

         If Sh.Type = msoPicture Then Sh.Delete

             End If

    Next Sh

'delete text boxes

 For Each Sh In ActiveWorkbook.Worksheets(I).Shapes

       If Not Application.Intersect(Sh.TopLeftCell, Range("A40:AA120")) Is Nothing Then

                  If Sh.Type = msoTextBox Then Sh.Delete

               End If

    Next Sh

By using macros in Excel, this process was repeated inside code which looped through all the sheets in my open workbook. To loop through all worksheets:

Dim WS_CountAs Integer

 Dim I As Integer

' SetWS_Count equal to the number of worksheets in the active workbook.

WS_Count = ActiveWorkbook.Worksheets.Count

' Begin the loop through all worksheets.

   For I = 1 ToWS_Count

'active sheet i

ActiveWorkbook.Worksheets(I).Activate

‘insert delete pictures and textboxes here

Next I

As with most computer programs, there are multiple ways to go about the same task and it’s up to you to pick the best one. Another option is this:

Dim shpAs Shape

    For Each shpInActiveSheet.Shapes

        'Debug.Printshp.Name, shp.TopLeftCell.Row, shp.BottomRightCell.Row

        If shp.TopLeftCell.Row>= 5 Andshp.BottomRightCell.Row<= 39 Then

shp.Delete

        End If

    Next

Take Advanced Excel Training to learn how to write VBA macros in Excel.

2012 NBA Mock Draft Spreadsheet

The NBA Finals are over and LeBron James finally won his (first) title. For us fans of lesser teams (Cleveland) it’s time to turn our attention to the promises of next season. The 2012 NBA Draft will air on ESPN on June 28, starting at 7:00pm. During the draft lottery selection on May 30, amid some conspiracy theories, the New Orleans Hornets were selected to pick first in this year’s draft (while my Cavs will be picking 4^th). Anthony Davis from the NCAA defending national champion Kentucky Wildcats is projected by many fans and experts alike to be the number one overall pick. All players must be at least 19 years old and one year removed from high school.

Now you can make your own NBA draft results with our 2012 NBA Mock DraftCreator xls. Similar to our NFL mock draft and NHL mock draft creators. this Excel spreadsheet lists all sixty picks of the two rounds of the draft. The player data database includes information on each NBA 2012 draft prospects.

How it works

The list of players is a named range called “players.” In the draft tab, next to each team’s selection you click the drop down list and it will list all the player names. Next, I used the VLOOKUP function to pull in the player’s position, school, and age from the data table located on the second sheet.

The spreadsheet can also be easily converted and used for your nba fantasy mock draft 2012.

NBA 2012 Mock Draft Creator.xls 

Download link 1

Download link 2

Feel free to leave a comment and share your latest mock draft results below!

Z-Code Winning Sports Predictions - a proven system that takes the emotion out of predicting winnters and losers to rake in profits all year long.

How to find the best score based on condition

In this example, I have a workbook with two worksheets. On Sheet1, in column A, there is a list of more than 2000 individual’s names (some of them repeated) and column B lists each person's average test score percentage. In the second worksheet, called Sheet2, column A contains a list of each person's name exactly once and in columns b, c, d I want to list their first, second, and third best score or percentage.

How to use the LARGE function in Excel

The first, second, or third best score can be obtained using the Excel large function. The LARGE function allows you to return the nth largest value in a unique data set, like the second best score. The syntax for the large function excel is: =LARGE(array,k) where an array is a range of data and k is the position from the largest value in the array. So, for the first best score k=1, second best k=2, etc.

The LARGE function excel will get the best score from the list but we need to make it so the function only applies to the individual listed in sheet 2 column A. This is where the excel array function is used.

Using arrays in Excel

An array is a range of data, like items in a table. Often times you may see array formulas referred to as "CSE formulas," because you press CTRL+SHIFT+ENTER to transform the function into an excel array formula. We need to use our LARGE function in an array in order to return the best score based on the condition of the person’s name. So we’ll use the Excel large if.

To return the 2nd largest score for Joe, the name listed in Sheet2 column A, use this excel large formula:

{=LARGE(IF(Sheet1!$A$1:$A$2000=$A2,Sheet1!$B$1:$B$2000,-1),2)}

Remember, to enter this array formula into the cell, then instead of hitting the Enter key, hit Ctrl-Shift-Ente

Download the large and array examplespreadsheet from Google docs or join our email newsletter to receive it as an .xls attachment.