Archive | tools

Exporting from R to Excel with Conditional Formatting

It’s often the case that I want to share preliminary results with colleagues and have them provide feedback. This is pretty easy to do as a pdf using RStudio and a bit of LaTeX or markdown. And it’s now easy to turn my notes and results into a webpage via RStudio and tools like RPubs.
But sometimes I need others to comb through pages of results like factor loadings, and these output formats don’t cut it. In these cases, I export to Excel using the xlsx package so everyone can sort, make notes, highlight cells, etc.
This works really well, but I had a case recently where I needed a team of people to review 20+ sheets of factor loadings and comment on possible structures and interpretations. It’s common to start with some cutoff for factor loadings (x), often abs(x)>=0.30, so conditional formatting in Excel is a nice way to visualize patterns.


Continue Reading →

Reproducible Research with Word?

Kieran Healy’s post describing his manuscript preparation workflow inspired me to write up some notes about how I approach some of the same challenges. Namely, other people.
Healy’s summary is required reading for what follows. But I warn you, if you are still reading my words, his site will consume your attention for a few hours. Don’t blame me when you are fiddling with his templates rather than doing your actual work.

Continue Reading →