@Article{Broman2017,
  author    = {Karl W. Broman and Kara H. Woo},
  title     = {Data Organization in Spreadsheets},
  journal   = {The American Statistician},
  year      = {2017},
  volume    = {72},
  number    = {1},
  month     = {sep},
  pages     = {2--10},
  doi       = {10.1080/00031305.2017.1375989},
  comment   = {Do not have mixed info in fields
If numbers, just numbers
If factors, consistent labels
Column names, simple, no spaces (can have a separate spread sheet with more details on each variable if needed)
Be consistent in what is an NA
Do not use 0 for NA, do not use “-“ for NA, do not use a blank for NA… so… actually… just use NA for NA
Do not color code fields (or, if relevant, store said information in some other way and/or use conditional formatting to do it)
Do not have multiple formats in a single worksheet 
1 row per observation, 1 column per variable
No plots in data worksheet
No comments in cells “around” the data


See also:
https://datacarpentry.org/2015-05-03-NDIC/excel-ecology/02-common-mistakes.html

https://analyticsdemystified.com/excel-tips/10-things-you-should-always-do-or-not-do-in-excel/




},
  file      = {:Data Organization in Spreadsheets.pdf:PDF},
  keywords  = {excel, worksheet},
  publisher = {Informa {UK} Limited},
}

{"_id":"2ZSz7DNszwkHrJ6BZ","bibbaseid":"broman-woo-dataorganizationinspreadsheets-2017","authorIDs":[],"author_short":["Broman, K. W.","Woo, K. H."],"bibdata":{"bibtype":"article","type":"article","author":[{"firstnames":["Karl","W."],"propositions":[],"lastnames":["Broman"],"suffixes":[]},{"firstnames":["Kara","H."],"propositions":[],"lastnames":["Woo"],"suffixes":[]}],"title":"Data Organization in Spreadsheets","journal":"The American Statistician","year":"2017","volume":"72","number":"1","month":"sep","pages":"2–10","doi":"10.1080/00031305.2017.1375989","comment":"Do not have mixed info in fields If numbers, just numbers If factors, consistent labels Column names, simple, no spaces (can have a separate spread sheet with more details on each variable if needed) Be consistent in what is an NA Do not use 0 for NA, do not use “-“ for NA, do not use a blank for NA… so… actually… just use NA for NA Do not color code fields (or, if relevant, store said information in some other way and/or use conditional formatting to do it) Do not have multiple formats in a single worksheet 1 row per observation, 1 column per variable No plots in data worksheet No comments in cells “around” the data See also: https://datacarpentry.org/2015-05-03-NDIC/excel-ecology/02-common-mistakes.html https://analyticsdemystified.com/excel-tips/10-things-you-should-always-do-or-not-do-in-excel/ ","file":":Data Organization in Spreadsheets.pdf:PDF","keywords":"excel, worksheet","publisher":"Informa UK Limited","bibtex":"@Article{Broman2017,\r\n author = {Karl W. Broman and Kara H. Woo},\r\n title = {Data Organization in Spreadsheets},\r\n journal = {The American Statistician},\r\n year = {2017},\r\n volume = {72},\r\n number = {1},\r\n month = {sep},\r\n pages = {2--10},\r\n doi = {10.1080/00031305.2017.1375989},\r\n comment = {Do not have mixed info in fields\r\nIf numbers, just numbers\r\nIf factors, consistent labels\r\nColumn names, simple, no spaces (can have a separate spread sheet with more details on each variable if needed)\r\nBe consistent in what is an NA\r\nDo not use 0 for NA, do not use “-“ for NA, do not use a blank for NA… so… actually… just use NA for NA\r\nDo not color code fields (or, if relevant, store said information in some other way and/or use conditional formatting to do it)\r\nDo not have multiple formats in a single worksheet \r\n1 row per observation, 1 column per variable\r\nNo plots in data worksheet\r\nNo comments in cells “around” the data\r\n\r\n\r\nSee also:\r\nhttps://datacarpentry.org/2015-05-03-NDIC/excel-ecology/02-common-mistakes.html\r\n\r\nhttps://analyticsdemystified.com/excel-tips/10-things-you-should-always-do-or-not-do-in-excel/\r\n\r\n\r\n\r\n\r\n},\r\n file = {:Data Organization in Spreadsheets.pdf:PDF},\r\n keywords = {excel, worksheet},\r\n publisher = {Informa {UK} Limited},\r\n}\r\n\r\n","author_short":["Broman, K. W.","Woo, K. H."],"key":"Broman2017","id":"Broman2017","bibbaseid":"broman-woo-dataorganizationinspreadsheets-2017","role":"author","urls":{},"keyword":["excel","worksheet"],"downloads":0,"html":""},"bibtype":"article","biburl":"http://distancelive.xyz/MainBibFile.bib","creationDate":"2020-06-16T14:23:41.034Z","downloads":0,"keywords":["excel","worksheet"],"search_terms":["data","organization","spreadsheets","broman","woo"],"title":"Data Organization in Spreadsheets","year":2017,"dataSources":["RjvoQBP8rG4o3b4Wi"]}