Introduction

Formatting data tables in Spreadsheets

Figure 1

spreadsheet setup

Figure 2

multiple-info example

Figure 3

single-info example

Formatting problems

Figure 1

multiple tabs

Figure 2

formatting

Figure 3

good formatting

Dates as data

Figure 1

{alt=‘dates, exersize 1’ .output}

Figure 2

Many formats, many ambiguities

Figure 3

So, so ambiguous, it's even confusing Excel

Figure 4

Kill that ambiguity before it bites you!

Quality control

Figure 1

Image of Data Validation button on Data tab

Figure 2

Image of Data Validation window

Figure 3

Image of Data Validation window for validating plot values

Figure 4

Image of error when trying to enter invalid data

Figure 5

Image of Input Message tab

Figure 6

Image of Error Alert tab

Figure 7

Image of drop-down menu

Figure 8

{alt=‘quality_control0, exercise1’ .output}

Figure 9

{alt=‘quality_control1, exercise1’ .output}

Figure 10

{alt=‘quality_control2, exercise1’ .output}

Figure 11

{alt=‘quality_control3, exercise1’ .output}

Figure 12

Cells that contain non-numerical values are not colored. This includes both the cells where the letter “g” was included and the empty cells. {alt=‘quality_control4, exercise2’ .output}

Exporting data

Figure 1

Saving an Excel file to CSV

Figure 2

screen shot 2017-03-31 at 7 15 07 pm

Figure 3

screen shot 2017-03-31 at 7 26 42 pm