Nobody Listens to Paula Poundstone is your comedy field guide to life. The podcast features Paula, her cohost Adam (who is on every show), Toni, and the redoubtable Bonnie Burns.
Paula's assistant Wendell noticed the more Bonnie is on the show, the more merch they sell, but the lower their sponsorship revenue is. Sponsors are nervous about Bonnie, who might, for example, use "alternative facts" about her age to get a better deal, or lure Toni into a life of breakfast crime.
Bonnie also drives some people to despair. The show has had to pay for psychiatric care for Adam and Vic, the show's sound editor.
Some of Bonnie's antics pose legal risks, such as a threatened lawsuit by the estate of Zero Mostel. The show seeks legal advice before releasing a Bonnie-ridden episode.
Write a VBA program to estimate the revenue effect of each minute Bonnie is talking on the show. You can download a start worksheet. It looks like this:
The user fills in values in the input part, above the Run button. They click the button, and get the output.
- Add in the effect of merch and sponsor changes.
- Adam needs two hours of psychiatric care for each minute Bonnie talks.
- Vic needs three hours per minute, since he has to listen to Bonnie speak more than once while he's editing the show.
- The show needs one hour of legal advice for each minute Bonnie talks.
Here's some sample output:
Use the IPO pattern. Add a comment identifying each of the three parts of the program.
Upload your workbook with the VBA code here. The usual standards (variable naming, indentation, secluded cells, explicit variables) apply.