There is an astonishing amount of data involved in producing a master plan. And TEN master plans? Spreadsheet city! We’ve been mining the US Census, ESRI business reports, MDOT traffic counts, and any other data trove we can get our hands on to paint the fullest picture possible of the Lakes to Land region and each of its unique communities. After assembling standardized datasets for each community, one handy tool we used to get a handle on it all was a VERY LONG spreadsheet containing each benchmark we looked at, with all communities compiled and sorted in order of decreasing value. It helped illuminate areas of special interest for each community (that’s why the top three, bottom three, and median values are highlighted) and also to identify areas of similarity or common interest between communities. It has been such a fun and informative tool that we thought you might enjoy it too!
For ease of presentation, we broke the chart up into four categories: People, Housing, Work, and Income. (It’s a working tool, so formatting is…hasty in a couple of places.) Clicking on any of the images below will bring up a larger size, or you can click here for a .pdf with all four pages. Think nothing beats the real thing, in all its spreadsheety glory? Us too! Click here to download it.