nannerdw Posted June 28, 2009 Share Posted June 28, 2009 Ever since I started riding coasters, I have been using sites like Coaster Counter to keep track of what I have ridden, but I like to keep a more in-depth list in my own Excel spreadsheet. Right now it's organized as sort of a chronological diary of my theme park visits. In this newest version, which I'm calling Coaster Checklist 2.0, I have added a few formulas to make it more streamlined and user-friendly. Here's what I have included in the spreadsheet: -Date of park visit -Park name -Automatic running total of visits to park -Coasters ridden during visit -Column for rides that have been renamed or relocated, if you don't want to count them as new credits -Times ridden during visit -Whether the ride is new to your count. If a ride is being listed for the first time, a "Y" is automatically placed in this column. Otherwise, it shows a running total of the number of times ridden. -First experiences/Records: A space to list any new ride experiences (First coaster with a loop, etc.) -Count: shows a running total next to each new addition. Cells next to duplicate rides remain blank. -Current # of unique coasters ridden, total times ridden, # of wooden and steel, unique inversions, total inversions, distance travelled on unique coaster track, total distance travelled on track, and total # of parks and park visits (All automatic from data entry) -Top and Bottom 10 lists All of this is probably a lot more detail than most people want to include, but I have attached the spreadsheet as a guide for anyone to use. Please feel free to suggest any changes or improvements that could be made. Coaster Checklist 2.0.xls Coaster Checklist 2.01.xls Added "year ridden" sort filter, total rides per visit, and new rides per year. Link to comment Share on other sites More sharing options...
macca_boy69 Posted June 28, 2009 Share Posted June 28, 2009 So....what do we do with it? Link to comment Share on other sites More sharing options...
Nosferatu Posted June 28, 2009 Share Posted June 28, 2009 So....what do we do with it? You register your park visits I use a spreadsheet too in order to keep some more information besides what coasterfanatics has. I like to know how many times I rode a certain coaster on each visit etc! Link to comment Share on other sites More sharing options...
monsterfan99 Posted June 28, 2009 Share Posted June 28, 2009 I use spread sheets to but kind of split the one you do into 2 different ones. The first is my Coaster Count one. Has all the info on the coasters you would find on RCDB along with when I first rode, types of rides (I like to try out all coasters in front, back, day and night) and what merchandise I have bought (I collect pins, postcards and pressed pennies.) There is also a list of the order of my coaster count and my rankings. The second one I have is my ride count of each ride (coaster or not) at each park for the year. Some will roll their eyes that I take this much time to do this, but I personally enjoy using spreadsheets for list of this nature. Link to comment Share on other sites More sharing options...
TheRapidsNerd Posted June 28, 2009 Share Posted June 28, 2009 This is good idea! Isn't the flexibility to have as much or as little info you want plus a few ways to sort it all, great? I do something similar with my photo archive on my blog. I'll put the year and the attraction for the title, link it to the corresponding Facebook album, and it goes into a number list kind of like a bullet list. Thanks for putting up an example of your organization and giving other folks an example to base theirs off. Link to comment Share on other sites More sharing options...
Speeddeamon128 Posted June 28, 2009 Share Posted June 28, 2009 Could you add a way to maybe keep track of home many times you rode a coaster that day & the total number of coaster rides you got that day? I have a binder that I keep track of the theme parks I visited that year with the dates, the coasters I rode that year (new & old) in the order I rode them that year & how many times I rode them, & the flat rides, dark rides, & long flumes I rode in the order I rode them & how many times I rode them that year. This is an awesome idea! Link to comment Share on other sites More sharing options...
nannerdw Posted June 28, 2009 Author Share Posted June 28, 2009 Could you add a way to maybe keep track of home many times you rode a coaster that day & the total number of coaster rides you got that day? The "X" column is where I put how many times I rode a certain ride during that visit. I'll try to work on a formula that shows total rides per visit and total rides per year. I was also thinking about making a bar graph that shows parks per year and new rides per year. I think it would be pretty cool to make it link to a Google Earth map that places a "number of visits" marker on each park. Link to comment Share on other sites More sharing options...
nannerdw Posted June 29, 2009 Author Share Posted June 29, 2009 Changes: -Added a cell in the gray area between each park to show the total number of times ridden per visit. -Added an expandable column for year ridden, which has a sort filter to show all coasters ridden in a specific year. When sorted, the number of new rides for that year appears at the top of the next column. -Moved the Top and Bottom 10 to a new sheet. Coaster Checklist 2.01.xls Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now