Digitize, import, clean, and process

Enter the sheets, read them into R, clean them, and reshape them for analysis.