Subject: FEC Day Helpful Tips
From: "Miller, Lindsey" <[email-masked]>
To: "Bauer, Nick" <[email-masked]>, "Bennett, Eric" <[email-masked]>, "Berns, Jeremy" <[email-masked]>, "Brinster, Jeremy" <[email-masked]>, Corinne Matti <[email-masked]>, "Crystal, Andy" <[email-masked]>, Dieter, Austin <[email-masked]>, "Dillon, Lauren" <[email-masked]>, Graham, Caroline <[email-masked]>, "Hancock, Kayla" <[email-masked]>, Kane, Michael <[email-masked]>, "Kauffman, Nathan" <[email-masked]>, Kim, Alice <[email-masked]>, "Lykins, Tyler" <[email-masked]>, "Miller, Lindsey" <[email-masked]>, "Oslund, Joseph" <[email-masked]>, "Roberts, Kelly" <[email-masked]>, "Sa
Cc: "Haxo, Chris" <[email-masked]>, "Kasnetz, Joel" <[email-masked]>, "Yoxall, Collin" <[email-masked]>
Date: Tue, 19 Apr 2016 13:24:01 -0700

I've sent this around before but here is a refresher on searching for and downloading reports. Let me know if you have questions. I attached Kasich's report from last month if you want to play around with it.

FEC FORM SEARCH
Full list of campaigns/PACs here<https://docs.google.com/spreadsheets/d/16HyPV-lC9Kdw_jHq-mElO3I3larEzInvCJ22NGen1jA/edit?usp=sharing>
Search for campaign/PAC reports here<http://www.fec.gov/finance/disclosure/candcmte_info.shtml>
Spotify playlist here<https://open.spotify.com/user/lindseylikewhoa/playlist/0UJcAMoHZhaLSlD5lpGy3E>
-Most effective way to search is by ID number
-Most effective way to look at top lines is by looking at the PDF for the most recent report
-Most effective way to play with numbers is to download the file called FEC-NUMBERS, then select CSV file to download. To make it readable, select all of column A, then go to Data tab. Under Data tab is Text to Columns. Click that and selected the 'Delimited' option. Say next. A comma is separating the data, so select that option, then click next. Say finish. You now have a workable spreadsheet!

-To separate by contributions from expenditure for candidates, control+f for 'sb2.' Everything coded as sb23 is an expenditure. Cut anything coded as that and move it to the next page.
-Anything coded 'sb28' is a contribution refund.
-Sometimes there will be an 'sd12' section below 'sb.' That represents campaign debt and should also be moved into its own spreadsheet.
-To make it so you can sift through data more easily, I typically add a new row to the top. For contributions, I name columns 'PAC' 'Last name,' 'city,' 'state,' 'occupation,' 'employer,' 'amount' and 'date.' Select the whole row, then go to the home tab. Click on the 'sort and filter' button on the far right and select the filter option.   For contributions I typically label 'business,' 'last,' 'state,' 'date,' 'amount,' and 'reason.'
-I will be saving the formatted campaign finance reports Under 2016 - 2016 All-Stars - FEC Days - April 2016. Please save any work that you do to there as well.