All Images

Introduction


Formatting Data Tables in Spreadsheets


Figure 1

Data not following tidy data principles, as multiple variables (lifestock number and types) are stored in the same cell

Figure 2

Data following tidy data principles, as there is one column for each type of lifestock owned, each representing the number of animals of each type

Figure 3

Screenshot of a spreadsheet with multiple tables of data next to each other

Figure 4

Table of data with empty values for lifestock for multiple observations

Figure 5

Table showing a cell highlighted in yellow to convey information about the data, which is a bad practice

Figure 6

Table with a new column to convey the information previously recorded via highligted cells

Figure 7

Table where one column has no standarization and includes comments about the value recorded

Metadata


Dates as Data


Figure 1

Many formats, many ambiguities

Figure 2

dates exercise 1

Quality Assurance


Figure 1

Load CSV in Excel

Figure 2

Load CSV in Calc

Figure 3

Image of data validation tab in Excel

Figure 4

Image of data validation tab for number rules in Excel

Figure 5

Image of data validation tab in LibreOffice

Figure 6

Image of data validation tab in LibreOffice

Figure 7

Image of error message for inputing invalid data in Excel

Figure 8

Image of error message for inputing invalid data in LibreOffice

Figure 9

Image of Error Alert tab in Excel

Figure 10

Image of Error Alert tab in LibreOffice

Figure 11

Image of Input Message tab in Excel

Figure 12

Image of Input Message tab in LibreOffice

Figure 13

Image of selecting a range of values to allow in Excel

Figure 14

Image of selecting a range of values to allow in LibreOffice

Figure 15

Image of filled in range of values to allow in LibreOffice

Exporting Data


Figure 1

Saving an Excel file to CSV