Here's 1712's 1st iteration of an excel sheet for 2016, along with an explanation. I have no idea whether this will work for your sheets in particular, but feel free to PM me if you have any questions about modifying it.
http://www.chiefdelphi.com/media/papers/3225
Edit: Oh, hey, I notice you already downloaded it. Never mind.