2009 Stimulus Package in Excel Spreadsheet Format

Too bad neither the White House nor Congress provide a simple downloadable spreadsheet of the proposed Stimulus bill.  They do provide a downloadable 700 page PDF file of their work but no spreadsheet.

I have searched the Internet for a simple downloadable spreadsheet of the proposed 2009 Stimulus package, and I couldn't find any from any source until today.

But courtesy of Anderson Coope's blog at http://ac360.blogs.cnn.com/2009/02/10/the-stimulus-bills-house-vs-senate/ and Michael Grabell's article at http://www.propublica.org/special/the-stimulus-bills-house-vs.-senate I think I finally have an easy spreadsheet to understand that depicts the Stimulus plan of 2009 as of February 10, 2009.

Michael Grabell is part of www.propublica.org and their article at http://www.propublica.org/special/the-stimulus-bills-house-vs.-senate helped  me to create a spreadsheet.

I copied the data from www.propublica.org and processed the data into my own spreadsheet.  There's the QC problem.  If we trust ProPublica that their original work is correct, than my spreadsheet is correct.  I'm hoping their data is correct.

Here's my downloadable spreadsheet in Excel 2003 format:  Download Stimulus Bill Spreadsheet

The spreadsheet has 5 worksheets.  Each worksheet has a yellow cell with brief comments.

1)  ProPublica.org - This is the data I downloaded from ProPublica.org on Feb 10, 2009.

2)  Stimulus Data - The first worksheet embedded totals so that when you added things up, the Stimulus looked twice as large as it should be. In this worksheet, I deleted the total lines to avoid double counting.

3)  Stimulus Data in Billions - Reading numbers with lots of zeroes can be confusing.  In this worksheet, I converted all numbers into billions.  For example, a number of 30.3 would mean 30.3 billion dollars.

4)  Senate Stimulus Pivot Table - If you know what pivot tables are, you'll be excited to use this worksheet.  If you don't understand pivot tables, just use worksheet #3.

5)  House Stimulus Pivot Table - If you know what pivot tables are, you'll be excited to use this worksheet.  If you don't understand pivot tables, just use worksheet #3.

I describe myself politically as an Independent.  So I don't think I have a political axe to grind in the Stimulus conversation.  My only complaint about the Stimulus bill is that neither the White House nor Congress has made it easy for people to understand the Stimulus with a downloadable spreadsheet.

Hopefully my 2009 Stimulus spreadsheet will help many Americans voice their support or dissent regarding the Stimulus package in Congress.  Download Stimulus Bill Spreadsheet

Comments

[Bill]

I was looking for this resource myself just tonight and I am very appreciative of your passion to care enough to do this. I am an excel freak and would like to modify a bit and send you my version!!

I hope you don't mind my url tag. This is my company but I won't pitch it here.

You're a great American and thanks again!!

[Kathy]

Hi, Richard --

I'd like to use your spreadsheet (with credit) as the basis for one that includes data on the bill as passed by Congress.

Are you OK with that?

maito:uspolitics.guide@about.com
http://uspolitics.about.com/