Project (Construction) Management Spreadsheet?

[Collin Borns]

I have recently been put in charge of managing around 10-20 construction projects (give or take) at a time.  My firm does both gut rehab and light value add work to multi-family properties in Chicago.  A lot of the management has been left to memory, but the business has grown to the size that more organization needs to be put in place.  Does anyone have any solid Excel spreadsheet templates or anything they use to manage 2 dozen or so projects at a time?  I am mostly concerned with making sure each of our trades are staying within our contracted time frames in order to make sure jobs get completed on time.

Thanks!