Spotted Ratings, Monday 2/14/11

So I had a lot of stuff typed up over the weekend and it got eaten by Blogger. Quick version: I've spent much of the last couple weeks working on a spreadsheet that gives me a lot of numbers just by entering the ratings. I'm gonna try posting it every day for a little while and see how it goes. Will say more later this week. Any feedback is welcome, as this is all pretty up in the air and experimental. Sorry if it seems a little overwhelming at the moment!

	A18-49	Share	Lead	Last	LeLa	Comp	HUT	bcShr	Avg	Rank
The Bachelor	2.9	8	n/a	-9%	n/a	8.5	35	25	-2%	3/7
Castle	2.2	7	-24%	-12%	-9%	4.5	34	33	-13%	13/15
How I Met Your Mother	3.7	11	n/a	-3%	n/a	8.7	34	30	3%	5/16
Mad Love	3.0	8	-19%	n/a	n/a	8.7	35	26	n/a	1/1
Two and a Half Men	4.2	12	40%	-5%	-6%	6.8	35	38	-7%	14/16
Mike & Molly	3.8	10	-10%	9%	-5%	6.8	37	36	4%	4/16
Hawaii Five-0	2.8	8	-26%	0%	9%	3.9	34	42	-13%	12/17
Chuck	1.7	5	n/a	0%	n/a	10.4	35	14	-10%	12/15
The Cape	1.2	3	-29%	-8%	0%	9.6	36	11	-37%	6/6
Harry's Law	1.7	5	42%	0%	-8%	5.0	34	25	-16%	4/5
House	3.4	10	n/a	-21%	n/a	8.7	35	28	-11%	11/12
The Chicago Code	2.0	6	-41%	-17%	-21%	8.8	36	19	-17%	2/2
90210	0.7	2	n/a	-22%	n/a	11.4	35	6	-25%	15/15
Gossip Girl	0.7	2	0%	-13%	-22%	10.1	36	6	-26%	15/15

KEY
A18-49 - From Nielsen. Adults 18-49 rating. Percentage of US TV-owning adults 18-49 watching the program.
Share - From Nielsen. Adults 18-49 share. Percentage of US TV-watching adults 18-49 watching the program.
Lead - Calculation. Percent difference from lead-in program.
Last - Calculation. Percent difference from previous original episode.
LeLa - Caclculation. Percent difference between the show's lead-in and its lead-in for the previous original episode.
Comp - Calculation. Competition. Total rating of all broadcast programs airing against it.
HUT - Calculation. Phrase commonly known as "Households Using TV," but in this case it's actually "Adults 18-49 Using TV." Percentage of US TV-owning adults 18-49 who are watching any TV in that timeslot. A rough approximation based on all ratings/shares in the timeslot. More on this later.
bcShr - Calculation. Broadcast share. Percentage of US national big-5 broadcast TV-watching adults 18-49 watching the program.
Avg - Calculation. Percent difference from the show's average demo for previous original episodes this season.
Rank - Calculation. The rating's rank among the show's original episodes that have aired so far this season.

Will probably develop more disclaimers if this develops further, but the one that jumps out for now is that the stats in blue will be less accurate because for now I'm counting every program as if it maintains that same rating throughout each half-hour of the broadcast. That is almost always not the case in reality.

More Monday Spotted Ratings.