2010-08-07, 00:35 | Link #4061 |
Senior Member
Join Date: May 2009
|
In House, season 3 episode 22, "Resignation", when the patient starts whining about her head hurting, the camera pans to the top of her head and we see something bloody, nasty and throbbing. Is that her brain? how did the top of her head fall off? A pic can be provided.
|
2010-08-07, 01:39 | Link #4062 | |
Komrades of Kitamura Kou
Join Date: Jul 2004
Age: 39
|
Quote:
__________________
|
|
2010-08-07, 01:50 | Link #4063 | |
Senior Member
Join Date: May 2009
|
Quote:
Spoiler for spoiler, cause of sickness:
I like your explanation, but the doctors seemed to wave it off for some reason, so I kinda thought it was just what the machine she was in saw, not actually her brain exposed (she was in the tumor searching machine). And do external tumors throb and bloody? Another question, on the episode with the bratty chess prodigy kid, Spoiler for spoiler:
|
|
2010-08-07, 02:16 | Link #4064 | |
Komrades of Kitamura Kou
Join Date: Jul 2004
Age: 39
|
Quote:
I obviously need to have seen the chart of this patient, but throbbing of an artery secondary to septicemia was probably due to the vasoconstriction of the arteries as a response to the hypovolemia that occurs in septicemia patients. As for the annoying chess prodigy kid, hemochromatosis can present with various systemic organ effects secondary to iron deposition in various tissues. Central and peripheral neuropathies can present when the iron deposits in neurons and ganglions, which accounts for the way the kid had issues holding his chest pieces due to the nerve involvement, but as to the seizures... well I can't explain why they're episodic rather than sustained.
__________________
|
|
2010-08-07, 02:31 | Link #4065 |
Komrades of Kitamura Kou
Join Date: Jul 2004
Age: 39
|
Additionally, watching House and other Western medical dramas tend to highlight the fact that in many Western medical practices, more attention is given to the battery of tests you can subject to before you do a proper medical history, which is a gigantic problem for even the simplest of cases because glossing over a proper patient interview can easily allow you to overlook facts and information about the patient that could have allowed you to make an accurate diagnosis before you even send the patient to a machine.
The suicidal patient you mentioned first is a case in point. If the doctors properly interviewed the patient and her family even while she was run on all the scans, you would have figured out that the patient suffers from depression. You would then follow up with questions about depression such as Anhedonia, depressed mood, sleep changes and most important of all suicidal tendencies. After that if you listened in class you'd remember that for female suicidal patients the most common method of suicide is overdose ingestion of chemicals and drugs, so your next question is to address the method of the suicide attempt. From there if you manage to confirm toxin ingestion you'd have her go an endoscopy/colonoscopy/abdominal CT, would have seen the bleeding ulceration wherever it is and did something about it. Makes me glad I study in a third world nation where laboratory and machine tests are practically a last resort because few can afford them, if at all. I should also mention that you could EASILY drive down medical care costs if doctors did their thinking jobs and interviews first rather than having expensive machines do all the heavy lifting. I certainly didn't enter and suffer through medical school to have a machine do my work. Translation: If you go see a doctor and upon stating your problem his first reaction is to drop you in the MRI, go find a different hospital and a different doctor. Expect to pay out of your ass in medical fees.
__________________
|
2010-08-07, 02:36 | Link #4066 |
Senior Member
Join Date: May 2009
|
+1 to you. Thanks.
What's up with those multi-sided dice? Are they nerdy? What are their origins? My three year old girl substitutes Ds and Ts for numerous consonants, including C, F, G, J, K, P, S, Ds for Ts, V, and Z. She's gotten so deep into the habit of substitution that when you ask her to say a word that includes one of the problem letters, and you say it correctly, she replaces the letters, doesn't even try to repeat what you said. I have no clue if she even has the capability to pronounce the problem letters. Speech therapy, or will she just grow out of it? Last edited by Kudryavka; 2010-08-07 at 04:12. |
2010-08-07, 04:54 | Link #4067 |
Senior Member
Join Date: Dec 2004
Location: Portugal
Age: 44
|
Crap. I am bugged with an excel problem. (using excel 2007)
I have like column P and Q, one with name and other with values from the following formula: = TRUNC((COUNTIF(C5:G2000,"1")/COUNT(A5:A2000))*100,2) What I am doing is to count the number of times that the number 1 appears in the cells range C5:G2000, etc. My problem is I wanna sort the P and Q. Example of P and Q N01 10.32 N02 8.55 ... N40 9.43 I wanna get the top 5 so I just select the 2 columns and use excel sort. The problem here is that the sort changes the values in the 2 ranges (C5:G2000 and A5:A2000) and I dunno why. I can't figure it out why it changes the formula. I couldn't find any solution in google.
__________________
|
2010-08-07, 05:05 | Link #4068 | |
NYAAAAHAAANNNNN~
Join Date: Nov 2007
Age: 35
|
Quote:
__________________
|
|
2010-08-07, 08:04 | Link #4069 |
Senior Member
Join Date: Dec 2004
Location: Portugal
Age: 44
|
No no. I see everything... some of them has even an error msg saying some adjacent cells are missing and the functions are altered. This happens also if I just copy and paste them to another cell. Damn ranges get changed.
__________________
|
2010-08-07, 11:09 | Link #4071 | |
Asuki-tan Kairin ↓
Join Date: Feb 2004
Location: Fürth (GER)
Age: 43
|
Quote:
edit: Since you are using relative addressing... the sorting will affect the other cells too, messing up your input data set. Use the calculated row as another input set for another formula that gives you a sorted list of what is in your current result list...
__________________
|
|
2010-08-07, 11:27 | Link #4072 | |
Senior Member
Join Date: Dec 2004
Location: Portugal
Age: 44
|
Quote:
"= TRUNC((COUNTIF(C5:G2000,"1")/COUNT(A5:A2000))*100,2)" this formula gives de values in Q cells (this line is just for N01. P Q N01 10.32 N02 8.55 ... N40 9.43 I do sort the C5:G2000 and from A5:A2000 changes to other values like for example: "= TRUNC((COUNTIF(C3:G1998,"4") /COUNT(A3:A1998)) * 100,2)" -> this one was N04 formula after the sort. The N04 was the 2nd with the high value so moved 2 places up and so seems like the ranges values got a -2. If the N0X goes down it's +Y position to the range. BTW, when do sort I select P and Q cells.
__________________
|
|
2010-08-07, 15:08 | Link #4073 |
Asuki-tan Kairin ↓
Join Date: Feb 2004
Location: Fürth (GER)
Age: 43
|
Are you familiar with VBA? I made you a simple sorter in VBA you just need to tweak some values...
source code: Code:
Sub Sort() Dim inputColumn01 As Range Dim inputColumn02 As Range Dim sortedIndexColumn01() As Integer Dim loopIndex As Long Set inputColumn01 = Worksheets("Tabelle1").Range("C3:C13") 'containing the numbers Set inputColumn02 = Worksheets("Tabelle1").Range("B3:B13") 'containing the leading Texts sortedIndexColumn01 = SortIndices(inputColumn01) For loopIndex = 1 To inputColumn01.Rows.Count Worksheets("Tabelle1").Cells(loopIndex + 2, 6) = inputColumn01(sortedIndexColumn01(loopIndex - 1) + 1, 1) Worksheets("Tabelle1").Cells(loopIndex + 2, 5) = inputColumn02(sortedIndexColumn01(loopIndex - 1) + 1, 1) Next loopIndex End Sub Function SortIndices(ByVal InputArray As Range) As Integer() 'this is a very inefficient sorting algorithm if you feel like implementing QuickSort instead of this in VBA then HAVE FUN Dim sortedIdx() As Integer Dim origIdx() As Integer Dim origIdx2() As Integer Dim loopIndex As Integer Dim loopIndex2 As Integer Dim tempIdx As Integer Dim workerA2Counter As Integer Dim workerArray1() As Single Dim workerArray2() As Single ReDim workerArray1(0 To InputArray.Rows.Count - 1) ReDim sortedIdx(0 To InputArray.Rows.Count - 1) ReDim origIdx(0 To InputArray.Rows.Count - 1) For loopIndex = 1 To InputArray.Rows.Count workerArray1(loopIndex - 1) = InputArray(loopIndex, 1) origIdx(loopIndex - 1) = loopIndex - 1 Next loopIndex For loopIndex = 0 To InputArray.Rows.Count - 1 tempIdx = FindMinimum(workerArray1) sortedIdx(loopIndex) = origIdx(tempIdx) If UBound(workerArray1) > 1 Then ReDim workerArray2(0 To UBound(workerArray1) - 1) ReDim origIdx2(0 To UBound(workerArray1) - 1) workerA2Counter = 0 For loopIndex2 = 0 To UBound(workerArray1) If loopIndex2 <> tempIdx Then workerArray2(workerA2Counter) = workerArray1(loopIndex2) origIdx2(workerA2Counter) = origIdx(loopIndex2) workerA2Counter = workerA2Counter + 1 End If Next loopIndex2 workerArray1 = workerArray2 origIdx = origIdx2 Else loopIndex = loopIndex + 1 If tempIdx = 1 Then sortedIdx(loopIndex) = origIdx(0) Else sortedIdx(loopIndex) = origIdx(1) End If End If Next loopIndex SortIndices = sortedIdx End Function Function FindMinimum(InputArray() As Single) As Integer Dim loopIndex As Integer Dim localMinimumIdx As Integer localMinimumIdx = 0 For loopIndex = 0 To UBound(InputArray) If InputArray(loopIndex) < InputArray(localMinimumIdx) Then localMinimumIdx = loopIndex End If Next loopIndex FindMinimum = localMinimumIdx End Function http://www.digital-soul-drift.de/Sorting.rar As I said you need tweak some things in sort() to make it work for your xml sheet. If you have questions, don't hesitate to ask. But you should know something, I am not a VBA guru... actually I hate this atrocity of a failed try of a programming language. So, don't ask too much about VBA itself. Ah, the macro has one disadvantage, you have to run it manually each time you want to update your sheet.
__________________
|
2010-08-07, 17:40 | Link #4075 | |
Senior Member
Join Date: Dec 2004
Location: Portugal
Age: 44
|
Quote:
__________________
|
|
2010-08-08, 03:02 | Link #4078 | |
Junior Member
Join Date: Dec 2005
|
Quote:
The sentence structure caused me to assume that felix was giving an actual reason. But alright, I think I get the idea now. |
|
2010-08-08, 03:24 | Link #4079 |
sleepyhead
Author
Join Date: Dec 2005
Location: event horizon
|
TWTF = True WTF
Example: someone comes to you and shows you a picture how two white people have a black child; someone might say "the TWTF there is how the two white people are brother and sister."
__________________
|
Tags |
problem, q&a, serious |
|
|