Skip to main content

While I was watching returns on Tuesday I started an Excel 2010 workbook of the 113th Senate, as I was creating this workbook it occurred to me to add tables for the Senate elections of 2014, 2016 and 2018 of Republican seats to be re-elected and arrange the tables by age.  Maybe someone with demographic knowledge and skills might be interested in projecting vulnerability of Republican seats based upon demographic trends.  

For example, in 2015, 71 year-old Saxby Chambliss’ term expires and his seat will be on the ballot in 2014.  In 2012 Obama lost Georgia by 8 points.  Likewise, 76 year-old Thad Cochran’s term expires in 2015.  Obama lost Mississippi by 12 points while he lost Alabama by 22 points.  Mississippi has no virulent anti-immigrant measures like Alabama.  Mitch McConnell will be 72 in 2014 when he will be on the ballot in Kentucky.   Obama lost Kentucky by 22 but all state officials are Democrats and 2 of Kentucky’s House members are Democrats.  

The average age of current Republican Senators whose terms expire in 2015 is 67.54 while the average age of the Democrats is 63.15.  Interestingly, the difference between average age of all Democratic and Republican senators in the 113th Congress is less than 7 months, Democrats 61.70 and Republicans 61.07.

I’m uploading this workbook hoping another liberal will do some demographic work to identify winnable Senate seats in 2014, 2016 and 2018 currently held by Republicans.

Notes: The worksheet named “Senate 113th Congress” has some hidden cells that are identified on the worksheet named “Columns - Senate 113th Congress.”   In calculating the age of each Senator I used Excel’s TODAY() function so that the age column will always be current.  The Years of Service is calculated based upon a user entered “Years of Service End Date:”  I entered 2013-Apr-03.  That is why each Senator-elect has .25 Years of Service.  You may change Years of Service date.

I have created a table named “Rank by Seniority” where I have deleted the Senators who are not returning and assigned the currently returning Senators their new Rank by Seniority.  Next, I calculated the Rank by Seniority for the freshmen class of 2015 using the factor stated below.

Former Senator (descending by years of service; State Population *)
Former U.S. representative (descending by years of service; State Population *)
Former governor (descending by years of service; State Population *)
No factor    *State Population in descending order based upon the 2010 Census

No cells are locked and the workbook has no password protection.

I have never posted before and do know know how to upload a file. Or, even if, a user can upload a file.  If you reply could you include instructions for uploading files.  If files cannot be uploaded, I will e-Mail you the workbook upon request.

Mon Nov 12, 2012 at 6:07 AM PT: Click on the link below to access the workbook (spreadsheet) Note: The functions COUNTIFS and SUMIFS do not seem to be supoorted but I believe they are downloadable.

Your Email has been sent.
You must add at least one tag to this diary before publishing it.

Add keywords that describe this diary. Separate multiple keywords with commas.
Tagging tips - Search For Tags - Browse For Tags


More Tagging tips:

A tag is a way to search for this diary. If someone is searching for "Barack Obama," is this a diary they'd be trying to find?

Use a person's full name, without any title. Senator Obama may become President Obama, and Michelle Obama might run for office.

If your diary covers an election or elected official, use election tags, which are generally the state abbreviation followed by the office. CA-01 is the first district House seat. CA-Sen covers both senate races. NY-GOV covers the New York governor's race.

Tags do not compound: that is, "education reform" is a completely different tag from "education". A tag like "reform" alone is probably not meaningful.

Consider if one or more of these tags fits your diary: Civil Rights, Community, Congress, Culture, Economy, Education, Elections, Energy, Environment, Health Care, International, Labor, Law, Media, Meta, National Security, Science, Transportation, or White House. If your diary is specific to a state, consider adding the state (California, Texas, etc). Keep in mind, though, that there are many wonderful and important diaries that don't fit in any of these tags. Don't worry if yours doesn't.

You can add a private note to this diary when hotlisting it:
Are you sure you want to remove this diary from your hotlist?
Are you sure you want to remove your recommendation? You can only recommend a diary once, so you will not be able to re-recommend it afterwards.
Rescue this diary, and add a note:
Are you sure you want to remove this diary from Rescue?
Choose where to republish this diary. The diary will be added to the queue for that group. Publish it from the queue to make it appear.

You must be a member of a group to use this feature.

Add a quick update to your diary without changing the diary itself:
Are you sure you want to remove this diary?
(The diary will be removed from the site and returned to your drafts for further editing.)
(The diary will be removed.)
Are you sure you want to save these changes to the published diary?

Comment Preferences

Subscribe or Donate to support Daily Kos.

Click here for the mobile view of the site