In the 25th session of Chandoo.org podcast, let’s learn how to avoid SSUP syndrome.
What is in this session?
Most of us suffer from Sexy on the Spreadsheet, Ugly on Printout syndrome. I used to suffer from it too. This happens because we spend all our attention creating that perfect workbook, report or model. And then, we forget about making the proper print settings.
In this podcast, let’s understand how to create awesome workbooks that look great and print great.
In this podcast, you will learn,
- Frozen & Cars, where my free time goes
- Primer on print settings
- Width & height of printouts
- Page breaks
- Row & column repetitions on every page
- Size & orientation of paper
- Dealing with unprintables
- Proofing your print settings
- Printing what’s not on screen
- Closing thoughts
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to listen if the player is not showing up.
Links & Resources for printing awesome workbooks:
Advanced Printing scenarios
Transcript of this session:
Download this podcast transcript [PDF].
How do you stay away from SSUP?
In the podcast, I revealed all my favorite ways format print outs.
What about you? How do you ensure that your spreadsheets look as beautiful on print as they are on screen? What tips you follow?
Please share your thoughts in the comments area.
3 Responses to “CP049: Don’t do data dumps!!!”
Your title got me nervous because I'm all about data dumps, but not for attaching graphics to data dumps. My reason for using data dumps is when someone is trying to do analysis and their starting point is a report that's formatted in a way for a human to read. I instruct them to stop with the report and go get a data dump: just rows and columns and rows and columns.
Agreed, nearly all of my reports start with 100+ lines of simple table data.
That way you can build your functionality around pulling information from that tabled information.
Yes yes!