This is only a Preview!

You must Publish this diary to make this visible to the public,
or click 'Edit Diary' to make further changes first.

Posting a Diary Entry

Daily Kos welcomes blog articles from readers, known as diaries. The Intro section to a diary should be about three paragraphs long, and is required. The body section is optional, as is the poll, which can have 1 to 15 choices. Descriptive tags are also required to help others find your diary by subject; please don't use "cute" tags.

When you're ready, scroll down below the tags and click Save & Preview. You can edit your diary after it's published by clicking Edit Diary. Polls cannot be edited once they are published.

If this is your first time creating a Diary since the Ajax upgrade, before you enter any text below, please press Ctrl-F5 and then hold down the Shift Key and press your browser's Reload button to refresh its cache with the new script files.


  1. One diary daily maximum.
  2. Substantive diaries only. If you don't have at least three solid, original paragraphs, you should probably post a comment in an Open Thread.
  3. No repetitive diaries. Take a moment to ensure your topic hasn't been blogged (you can search for Stories and Diaries that already cover this topic), though fresh original analysis is always welcome.
  4. Use the "Body" textbox if your diary entry is longer than three paragraphs.
  5. Any images in your posts must be hosted by an approved image hosting service (one of: imageshack.us, photobucket.com, flickr.com, smugmug.com, allyoucanupload.com, picturetrail.com, mac.com, webshots.com, editgrid.com).
  6. Copying and pasting entire copyrighted works is prohibited. If you do quote something, keep it brief, always provide a link to the original source, and use the <blockquote> tags to clearly identify the quoted material. Violating this rule is grounds for immediate banning.
  7. Be civil. Do not "call out" other users by name in diary titles. Do not use profanity in diary titles. Don't write diaries whose main purpose is to deliberately inflame.
For the complete list of DailyKos diary guidelines, please click here.

Please begin with an informative title:

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.


You must enter an Intro for your Diary Entry between 300 and 1150 characters long (that's approximately 50-175 words without any html or formatting markup).

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.


Extended (Optional)

Your Email has been sent.