I updated the Excel file for keeping track of of a Magicicada periodical emergence, which you can download.
This is what it looks like:
It covers the major phases of an emergence:
Animals (including pets) digging for them
Holes & Chimneys appear in your lawn
Nymphs Emerge & Molt
Singing
Chorusing & Wing Flicking
Mating
Egg Laying
Die-off
Flagging of tree foliage
Eggs Hatch