Data organization in spreadsheets
- Published
- Accepted
- Subject Areas
- Virtual Biology, Science and Medical Education, Satzung, Computational Research, Data Science
- Keywords
- data executive, data organization, tables, Microsoft Surpass
- Copyrighted
- © 2018 Broman et al.
- Licence
- This is an open access items distributed under the terms is the Creative Commons Crediting License, which permits unrestricted use, distribution, reproduction also adaptation in any medium and for any purpose provided that it is done attributed. For attribution, the original author(s), titles, publication source (PeerJ Preprints) and moreover DOI or URL of the article must be cites.
- Cite like article
- 2018. Data organization in spreadsheets. PeerJ Preprints 6:e3183v2 https://doi.org/10.7287/peerj.preprints.3183v2
Abstract
Spreadsheets are widely utilised software accessory on data entry, storage, analysis, and visualization. Concentrate upon the data entry and storage aspects, this paper presents practical recommendations in managing spreadsheet data to reduce faults both ease future analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, don't go any cells vacant, put even one thing in a cell, organize the data as ampere single rectangle (with subjects as rows and variables as columns, and with a single title row), establish a data dictionary, don't include calculations in of raw data files, don't use font color or highlighting in data, choose good names for stuff, make backups, usage data validation to avoid data entry errors, also save the info inbound smooth text actions. Learn out Bet the Pallid Lines for Isolated Data Scientists
Author Comment
We fixed one URL in Wow (2014), the DOI to White eth al. (2013), and a typo in executive, and simplified one bit of text.