July 2012 Weather Summary

My usual site for gathering data has disappeared. I am now pulling data from Weather Underground. I also ran into problems with tables and had to redo my approach to posting. I am now generating HTML for tables in Excel then pasting them into the blog. July wasn't too surprising for the score. We are having a milder than usual summer, but most days were still warm and uncomfortable. The good news is that we are still sixth for year-to-date weather. The bad news is that early August isn't going to help.

July Summary
Date	High	Low	Rain	Score
7/1	68˚	54˚	Trace	59.11%
7/2	66˚	53˚	0.08"	78.85%
7/3	65˚	51˚	0.23"	86.81%
7/4	69˚	49˚	0"	53.49%
7/5	76˚	51˚	0"	45.64%
7/6	77˚	52˚	0"	43.62%
7/7	80˚	55˚	0"	37.58%
7/8	83˚	58˚	Trace	42.65%
7/9	77˚	55˚	0.06"	63.70%
7/10	75˚	52˚	0"	45.15%
7/11	82˚	56˚	0"	34.80%
7/12	78˚	56˚	0"	37.86%
7/13	74˚	57˚	0.02"	55.01%
7/14	77˚	59˚	Trace	45.98%
7/15	66˚	56˚	Trace	58.14%
7/16	79˚	56˚	0.01"	50.32%
7/17	71˚	59˚	0"	39.45%
7/18	70˚	58˚	0"	41.47%
7/19	77˚	58˚	0"	36.12%
7/20	67˚	57˚	0.6"	76.11%
7/21	75˚	57˚	0"	38.90%
7/22	69˚	54˚	0.04"	66.83%
7/23	66˚	52˚	Trace	63.14%
7/24	74˚	54˚	0"	43.41%
7/25	80˚	55˚	0"	37.58%
7/26	78˚	55˚	0"	39.11%
7/27	66˚	57˚	0"	45.78%
7/28	72˚	56˚	Trace	53.55%
7/29	73˚	59˚	0"	37.93%
7/30	67˚	56˚	0"	46.26%
7/31	73˚	57˚	0"	40.43%
Average/Final Score				49.83%

For more information on how scores have been generated, visit my blog post at:

http://maritimeorca0.blogspot.com/2012/03/follow-up-weather-index-in-excel.html

The Month of July Over the Years
Rank	Year	Score		Rank	Year	Score		Rank	Year	Score		Rank	Year	Score
1	1955	64.28%		17	1962	50.19%		33	2000	46.20%		49	1961	42.25%
2	1993	58.74%		18	1981	50.12%		34	1956	46.13%		50	1996	42.09%
3	1954	58.27%		19	2011	50.07%		35	1971	46.12%		51	1998	42.08%
4	1949	55.57%		20	2012	49.83%		36	1959	46.01%		52	1975	41.57%
5	1957	55.45%		21	1980	49.70%		37	1988	45.89%		53	1965	41.48%
6	1963	55.39%		22	1987	49.00%		38	2008	45.83%		54	1991	41.16%
7	1983	55.26%		23	1952	48.64%		39	1972	45.83%		55	1967	40.84%
8	1986	54.59%		24	1989	47.99%		40	1973	45.39%		56	1960	40.78%
9	1982	54.50%		25	1997	47.96%		41	1992	45.29%		57	1994	40.39%
10	1966	53.77%		26	1976	47.15%		42	2002	45.05%		58	1990	40.36%
11	1953	52.85%		27	1969	46.78%		43	1978	44.60%		59	2006	39.92%
12	1964	52.58%		28	1977	46.66%		44	1984	43.50%		60	2004	38.66%
13	1999	52.52%		29	2005	46.59%		45	1968	42.94%		61	2003	37.76%
14	1974	52.19%		30	2010	46.57%		46	2007	42.81%		62	1985	37.09%
15	2001	51.04%		31	1970	46.57%		47	1995	42.70%		63	1958	36.48%
16	1950	50.95%		32	1951	46.57%		48	1979	42.46%		64	2009	35.37%

Keep in mind that scores are based off of averages. These values are likely to shift a little over time.

Year to Date (Through July) Over the Years
Rank	Year	Score		Rank	Year	Score		Rank	Year	Score		Rank	Year	Score
1	2010	71.40%		17	1954	66.28%		33	2008	64.55%		49	1967	63.51%
2	1953	70.01%		18	1998	66.13%		34	1962	64.44%		50	1995	63.39%
3	1999	69.13%		19	2000	66.11%		35	1970	64.39%		51	2005	63.32%
4	1984	68.73%		20	1978	66.11%		36	1988	64.39%		52	1975	63.32%
5	1983	68.49%		21	1993	65.96%		37	1976	64.37%		53	1950	63.26%
6	2012	68.20%		22	1997	65.94%		38	1994	64.32%		54	1977	63.24%
7	2011	68.18%		23	1990	65.58%		39	1987	64.30%		55	1956	63.13%
8	1986	67.30%		24	1968	65.45%		40	1952	64.29%		56	2004	63.00%
9	1981	67.20%		25	1960	65.17%		41	2003	64.26%		57	1992	62.70%
10	1961	67.20%		26	2001	65.11%		42	1982	64.15%		58	1965	62.40%
11	1971	67.13%		27	2007	65.06%		43	1957	63.87%		59	1969	62.25%
12	1959	67.10%		28	1980	65.05%		44	1958	63.86%		60	1949	61.28%
13	1964	67.02%		29	2006	65.04%		45	2002	63.76%		61	1979	61.12%
14	1974	66.89%		30	1996	64.88%		46	1973	63.66%		62	1951	60.63%
15	1955	66.78%		31	1972	64.87%		47	1989	63.58%		63	2009	59.11%
16	1966	66.55%		32	1991	64.66%		48	1963	63.55%		64	1985	59.01%