See, I've never quite got myself motivated (or excited) enough about doing the sort of number crunching that Hyde does. Not so much the statistics processing, I can get that, but all the data input just turns me off big time. A data pull from RCDB would be lovely, but I'd always grumble at the bits of missing data.
For what it's worth, I have set up a "Summary" page at the front of my spreadsheet, which almost entirely self-populates based on Coaster and Park input tabs. Have the data present itself neatly like this gets my Excel boner going big time. As of this morning, this is how it looks:
The grey (totals), green (milestones) and 'dark' blue (manufacturers) tables fully self-populate and update following data input. As do the tables. The 'light' blue (top 20s) and purple (misc stats) cells are a mix of manual and automatic, but I am looking to keep adding more automation to these. The maps are generated from a website (
Link here), with the input for the site generated automatically and then copied in. I have looked to use Excel's inbuilt mapping, but haven't ever been pleased with the result given the time I've put in. A basic macro deals with refreshing and sorting the pivot tables after I've done all the inputs after a trip, but I've tried to do as much of it formula driven as I can as I always think it's a bit more robust.
For reference, the data is inputted like this - only takes a few moments after a trip, really. Country codes are the ISO-3166 alpha-3 codes, obviously.
Plot the whole thing (summary, coasters and parks pages) as a PDF, and happy days.