Trouble logging in?We were forced to invalidate all account passwords. You will have to reset your password to login. If you have trouble resetting your password, please send us a message with as much helpful information as possible, such as your username and any email addresses you may have used to register. Whatever you do, please do not create a new account. That is not the right solution, and it is against our forum rules to own multiple accounts.

As I recall you can change your username to anything (minimum 1 letter I think) but when you register the minimum is 4 letters or more.

And regarding addressing its either @O_O or you don't. Typically people don't. Its just so troublesome unless I can quote the person or really have something to say I might never ever talk to them. In games, when they do this, its simpler since you can ask them for their real life name.

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.

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.

I don't remember this episode. Assuming her cranium was intact and there would be no increased ICP that would force a cerebral herniation outside the confines of the skull the only nasty bloody throbbing anywhere near the top of head are either inflamed blood vessel more commonly a vasculitis (probably giant cell arteritis) or even a tumor (most likely a carcinoma or a melanoma), however these diseases don't really "pop" unless you're really really sick.

I don't remember this episode. Assuming her cranium was intact and there would be no increased ICP that would force a cerebral herniation outside the confines of the skull the only nasty bloody throbbing anywhere near the top of head are either inflamed blood vessel more commonly a vasculitis (probably giant cell arteritis) or even a tumor (most likely a carcinoma or a melanoma), however these diseases don't really "pop" unless you're really really sick.

It's the episode where the karate girl coughs up blood because

Spoiler for spoiler, cause of sickness:

the scar that she got from drain cleaner burning a hole in her intestines allows bacteria to get to her lungs.

if that helps you remember.

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:

why did he beat the other kid over the head in the beginning of the episode? They explained his sickness, yet when the kid almost had House in a checkmate, he started having a seizure, so did the sickness cause rage? And if so, why does the boy get nervous when he wins?

the scar that she got from drain cleaner burning a hole in her intestines allows bacteria to get to her lungs.

if that helps you remember.

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:

why did he beat the other kid over the head in the beginning of the episode? They explained his sickness, yet when the kid almost had House in a checkmate, he started having a seizure, so did the sickness cause rage? And if so, why does the boy get nervous when he wins?

Bacteria in the bloodstream at causes septicemia, which is literally a systemic blood infection. For this episode this happened because the GI bleed caused an opening of the GI contents to spill into the systemic circulation which is itself fairly common in many untreated GI ulcerations. The bacteria in question are most likely normal GI tract flora such as E. coli. Treatment for these cases focus on antibiotics active against gram negative bacteria.

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.

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.

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?

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.

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.

You have to scroll all the way up to see the top 5. The sort function moves only values, but they don't care about your functions.

__________________

When three puppygirls named after pastries are on top of each other, it is called Eclair a'la menthe et Biscotti aux fraises avec beaucoup de Ricotta sur le dessus.
Most of all, you have to be disciplined and you have to save, even if you hate our current financial system. Because if you don't save, then you're guaranteed to end up with nothing.

You have to scroll all the way up to see the top 5. The sort function moves only values, but they don't care about your functions.

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.

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.

Try posting in the tech support forum. I am sure you will get alot more help than here.

__________________

When three puppygirls named after pastries are on top of each other, it is called Eclair a'la menthe et Biscotti aux fraises avec beaucoup de Ricotta sur le dessus.
Most of all, you have to be disciplined and you have to save, even if you hate our current financial system. Because if you don't save, then you're guaranteed to end up with nothing.

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.

Does it change the formula (I doubt it) or does it change the sorting of the values that the formula uses as input?

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

Does it change the formula (I doubt it) or does it change the sorting of the values that the formula uses as input?
What I don't understand... is how this function can give you different results, when it always uses the same range... from C5 to G2000 and from A5 to A2000 as inputs. There is a flaw in your explanation. I assume you missed out on some details. Currently I cannot identify the cause of your problem, but I have a vague idea what it could be (absolute vs. relative addressing). Anyway, first I want more details.

C5 to G2000 and from A5 to A2000 are where my raw data is.

"= 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.