Jump to content


cobalt_27

Member Since 11 Apr 2003
Offline Last Active Yesterday, 08:33 PM
**---

Topics I've Started

Hamza Abdullah Tantrum

31 October 2013 - 08:50 AM

@Deadspin: Former player Hamza Abdullah is currently destroying the NFL on Twitter. http://deadsp.in/um1qwDZ

Obviously has CTE.

League of Denial (To be released October 8)

02 October 2013 - 08:41 PM

Ok, let's do this. The issue of "denial" is going to focus on the long-term impact of concussions and the proposed theory that they cause a distinct neurodegenerative disorder called chronic traumatic encephalopathy (CTE). And #### is going to hit the fan.

Rather than provide my own preliminary commentary, let me offer an excerpt from a recent editorial by Kevin Guskiewicz, Ph.D., who is an immensely well-renowned concussion researcher, who has been a voice of reason, and eloquently expresses in this editorial the opinion currently shared by the majority of the neuroscience community:

http://www.natajourn...62-6050-48.4.14


Kevin M. Guskiewicz , PhD, ATC, FNATA, FACSM
Pick up a newspaper or watch the evening news or Sports Center, and you're bound to read or hear something about sport concussion. The media are obsessed with this topic, particularly with the negative news that makes headlines and ultimately sells newspapers. Even so, there is good news to report, and progress is being made.

Although the neuroscience community has learned much about concussion in the last 2 decades, admittedly, we have much more to investigate and to understand. The tests for detecting concussion and tracking recovery are becoming more sensitive, especially when used in combination with other tools to create a multimodal approach to concussion assessment.

Despite all that has been accomplished, caring for athletes at risk for sustaining cerebral concussion has always been a challenging task and never more so than in today's litigious society. Concussion is different from other athletic injuries in that we still rely heavily on an athlete's subjective reporting of symptoms for decision making, and we lack the neuroimaging protocols that might allow us to see the damage and understand its severity. The cause-and-effect relationships, or lack of same, between repetitive head trauma and neurodegenerative diseases such as Alzheimer and chronic traumatic encephalopathy (CTE) are the subject of significant debate. Several published case reports have described τ protein deposits in the brains of deceased contact-sport athletes, but most of the neuroscience community does not believe that controlled experimental research has yet identified a causal relationship linking repetitive head trauma in sports and CTE.


Why Did the 'Start 1QB/2RB' Model Become the 'Standard

03 August 2013 - 08:11 AM

Curious if there are any fantasy historians here who can explain this. I suspect it arises from early attempts in the 1980s to model a traditional real-life offensive formation. Any other reasons?

How Would You Start an NFL Franchise

02 August 2013 - 01:03 AM

Vote and describe why you voted the way you did.

Excel Macro Help

23 May 2013 - 08:24 AM

I'm trying to slog through a macro and need some help.  I've done this before a long time ago, but can't translate my prior model into this one.

 

I have a folder with a 1000+ excel sheets all formatted exactly the same from which I am trying to extract data and compile the same variables into a single database.  Steps are as follows:

 

1.  Open an individual Excel Workbook (the first of 1000+ I want to pull data from) from TARGET_FOLDER

2.  Copy worksheet

3.  Paste Special (values) into a separate Excel sheet called DATABASE (Sheet 1)

4.  Then go to Sheet 2 of DATABASE where I've defined the exact few sets of datapoints (i.e., "=Sheet1B1!", "=Sheet1C1!", etc.) and I want to compile into a database and copy Row 2.

5.  Then I go to another Excel Workbook called FINAL where I have columns set up for the variables and want to have Row 2 filled with the data from the first workbook and then have 1000+ rows of data compiled for all subsequent workbooks from the TARGET_FOLDER.

 

So far, what's below is executing the first Excel Workbook just fine.  After that, it's all wonkiness, and I don't know how to instruct the macro to follow up and take the next target file, wash, rinse, and repeat to get all files into sequential rows on the FINAL Excel Workbook.

 

Please help.  I know this should be an easy fix, but I can't figure it out.

 

 

 

Sub Macro8() ' ' Macro8 Macro ' Dim i As Long For i = 2 To 1000 '     Application.WindowState = xlMinimized     Workbooks.Open Filename:= _         "svr-fileusersDesktopTARGET_FOLDERTARGET_DATA_SHEET.xls"     Range("A16:D30").Select     Selection.Copy     Windows("DATABASE.xlsm").Activate     Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _         :=False, Transpose:=False     Sheets("Sheet2").Select     Rows("2:2").Select     Application.CutCopyMode = False     Selection.Copy     Windows("FINAL.xlsx").Activate     Range("A2" & i).Select     Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _         :=False, Transpose:=False     Windows("DATABASE.xlsm").Activate     Sheets("Sheet1").Select     Range("A1" & i).Select          Next      End Sub