The day-to-day operations of the CPC are pretty much a one woman band. All emails for new podcasters, sponsors, old podcasters, questions, press inquiries, finance questions, and I don't know. Zookeeping questions related to the CPC. All of those go to me. I do all of the invoicing and budgeting, I do all of the sponsor assignments, I'm the only point of contact for all of the shows. I manage the Slack channel. I project managed the website. I plan events and help design the materials for those events. I pay the podcasters. I show high schoolers around our studio when their gifted and talented program wants to stop by.
The biggest share of the work on the CPC is balancing show schedules and sponsor assignments. It can be hard to brag about excel formulas, but look at that picture above. Look at that nonsense. Look at it. I took a day in 2015 and automated how all sponsorship assignments were going to go out for the entirety of 2016. All of that is auto-updated to a show-specific Google Spreadsheet that each show has access to. It cut the time I spent on the CPC to a fourth of what I spent before, while making the process easier for podcasters. That's what I'm really proud of, even though literally no one looks at this but me.