I just finished making two big changes to the spreadsheet.
Change #1: opening date score (historical value score):
Previously, the opening date I had been using for each roller coaster was the opening date in the park where it is currently located. The opening date I now use is the date it opened in its original location (the score for Wild One at SFA increased significantly due to this change as the difference between the time it opened originally and the time it opened at SFA is about 70 years). This effected every roller coaster on my spreadsheet known to have been relocated, which account for about 10% of the total number of roller coasters. I made this change to create better results in the 2nd change below.
Change #2: ride comfort score (how-likely-that-you-will-not-slip-a-disk-in-your-spinal-cord-due-to-the-roughness-of-the-ride score):
Previously, I gave a lower score to old tech wood roller coasters that were beyond a certain top speed and gave all of the other roller coasters the maximum score. I decided that that scoring method was not good enough, so I added a second component to the ride comfort score based on its original opening date, the idea being that roller coasters of any kind will get rougher as they age. Now, if a roller coaster is an old tech wood roller coaster, its ride comfort score is determined by how fast it goes and how old it is, while all the others are only judged by how old they are (the roller coaster with the lowest ride comfort score turned out to be the Coney Island Cyclone).
Attached is a revised snapshot of the spreadsheet of the top 50 wood roller coasters with only old tech ones shown. To clarify, an "old tech" wood roller coaster is one that does not use Intamin prefab track, Rocky Mountain Construction Topper Track, GCI Millennium Flyer trains, Gravity Group Timberliner trains, or has an unconventional configuration like a boblsled (Flying Turns) or a virginia reel (Tyrolean Tubtwist).
Last edited by Jackdude101
on Mon Nov 25, 2013 8:26 pm.