Data Organization in Spreadsheets

Karl Broman (github.com/kbroman, @kwbroman) and Kara Woo (github.com/karawoo, @kara_woo)

This is a paper on how to organize data within spreadsheets, based on the tutorial at https://kbroman.org/dataorg.

Now available at PeerJ Preprints and as a formal article in The American Statistician:

Broman KW, Woo KH (2018) Data organization in spreadsheets. Am Stat 72:2-10

• manuscript.Rmd - the source file
• manuscript.md - viewable on GitHub
• manuscript.html - web version with references and figure legends, viewable online
• manuscript.pdf - PDF version with references and figure legends, viewable online
• Makefile - GNU Make file, to compile PDF and html versions (and the .md file)
• references.bib - BibTeX references

Note that the manuscript.md file is produced from the manuscript.Rmd file.

Also note that the manuscript.md file does not include the references or figure legends. And so it is best to view the manuscript.html or manuscript.pdf file.

Compiling the .html or .pdf files requires the R/broman package. Install it with install.packages("broman").

You'll also need the rmarkdown package and Pandoc. And for the .pdf file, you'll need LaTeX.

---

License

This manuscript is licensed under CC BY.