G H 1 L M N o P Q S C D F 1 EXCEL-LENT PARK ROLLER COASTERS Roller Coaster Special Features Riders 150+ ft Cork 3 Name Level Drop Suspend Loop Screw 4 Top Thrill Dragster 5 TRUE FALSE FALSE TRUE 5 Millenium Force 5 TRUE FALSE TRUE TRUE 6 Maverick 5 FALSE FALSE FALSE TRUE 7 Blue Streak 4 TRUE FALSE TRUE FALSE 8 Wildcat 4 FALSE FALSE FALSE FALSE 9 Jr. Gemini 2 FALSE FALSE FALSE FALSE 10 Mean Streak 5 TRUE FALSE FALSE FALSE 11 Raptor 5 FALSE TRUE FALSE TRUE 12 Faceoff 5 FALSE TRUE TRUE FALSE 13 Bizarro 5 TRUE FALSE TRUE FALSE 14 El Toro S TRUE FALSE TRUE FALSE 15 Diamondback 4 TRUE FALSE FALSE TRUE 16 Tatsu 5 TRUE TRUE TRUE FALSE 17 Goliath 5 TRUE FALSE TRUE FALSE 18 Only Level 57 (TX) FALSE TRUE FALSE FALSE 19 Name of fastest coaster Top Thrill Dragster 193888ASSER 282 mph Feet 120 5,000 95 15,000 70 8,000 3,500 4,000 1,500 65 10,000 7,000 5,000 5.400 4,400 5,200 3,600 4,500 Ride Length in Riders per Cool Seconds Hour Rating 28 2,534 FALSE 108 1.427 TRUE 78 1,109 FALSE 60 805 TRUE 55 704 FALSE 41 1.408 FALSE 105 686 FALSE RO 905 TRUE 62 697 48 1,305 TRUE 43 1,344 TRUE 44 1,408 FALSE 41 1,760 TRUE 44 1,314 TRUE 150 Speed ft Sus Cork Based drop Pend Loop Screw Level Name 1 0 0 1 S Top Thrill Dragster 1 0 1 1 5 Millenium Force 0 O o 1 4 Maverick 1 0 1 0 2 Blue Streak 0 0 0 0 2 Wildcat 0 0 o 0 1 Ir. Gemini 1 0 0 O 3 Mean Streak 0 1 o 1 3 Raptor 0 1 1 0 2 Faceoff 0 1 0 Bizarro 1 0 1 0 4 El Toro 1 0 0 1 5 Diamondback 1 1 1 3 Tatsu 0 1 0 4 Goliath Yearly Insurance Percentage Rate 23% 25% 25% 17% 20% 10% 25% 23% 23% 23% 23% 17% 25% 23% FALSE 1 4 RIDES A B H D E F 150+ ft Drop Suspend Loop 1 Level Rides Rank 2 1 0.0% 4 3 2 7.1% 3 4 3 0.0% 4 5 4 21.4% 2 6 5 71.4% 1 LEVELS 0 OOON OOolor G Cork Screw 0 0 0 1 4 OOOH Rating Below Below Below Above Best B 1 Units 2 5,280 Feet/Mile 3 60 Minutes/Hour 4 60 Seconds/minute 5 40 Seconds actual Ride Time per Minute UNITS 2 7 3 6 A A B C D E F 1 Levels 2 Speed (mph) 0 40 60 70 80 3 Level 1 2 | 3 4 5 SPEED 2 3 4 5 6 Level 1 2 3 4 5 Insurance % Insurance % 2 or less Special 3 or more Special Features Features 3% 5% 7% 10% 13% 15% 17% 20% 23% 25% INSURANCE RATES N O D EXCEL-LENT PARK ROLLER COASTERS Comerciales Riders AN 16 C De Spend Loep som Tee The 1 TRUE FALSE TRU 3 TRU TALS THUB 6 M BALM HALU FALS THUE 4 TRUE FALSE THUR FALSE Wildcat 4 HALL FALSE FALSE Com 2 FALS FALS BAN FALS 3 TH FALH BALE 5 FALS TRUE FALSE TRUE 5 FALSE TE FALSE TRUE FALSE HT 5 TRUE FALSE TRUE HALS IS 4 TRUE FALSE FALSE THUR 16 5 TRUE TRUE FALSE THU TRUE FALSE Only IM FALSE THUE FALSE FALME 120 3.000 19 18.000 R. 40 SO 4.00 25 1.300 18.000 LO 7. 53 1,000 5400 70 DO 200 10 100 TO 4500 ER 2 = = a R Ride 150. Mely Speed Length in ders per Cool Ru Cork Seconds New Rating Pendo ser lave 20 251 FALSE . 1 5 100 To The LAIT TRUE 1 1 5 70 1109 FALSE . o 1 . Me TRUE 1 . 2 Blue 35 704 FALS . 2 W 1.000 FALSE . . 1 M. 103 468 FALS 1 . . 3 Meno 905 TRUK . 3 3 2 UNT FALSE 0 . 2 Face 27 1103 TRUE 1 o 0 4 215 1344 TRUE 1 1 1.200 FALSE 1 1 5 41 L750 TRUE 1 . 1 . 3 T 25 44 1114 TRUK 1 o 1 . 4 Goliath 2 Thu BEE 24 RIDES 3 150. Drop Level Rides Rank DON 4 7.IN 3 0.0 4 214 2 714 1 LEVELS 0 0 Suspend Loop 0 o 0 o O 0 1 3 Cork Screw Rating Below 0 Below 0 Below 1 Above 4 Best A B 1 Units 2 5,280 Feet/Mile 3 60 Minutes/Hour 4 60 Seconds/minute 5 40 Seconds actual Ride Time per Minute UNITS 7 A B C D E F Levels Speed (mph) 40 60 70 80 Level 23 5 SPEED 1 2 3 4 5 5 Level 1 2 3 4 5 Insurance Insurance 2 or less Special or more Special Features Features 3% SN 10% 15% 17 zon 23 25% ARE INSURANCE RATES 1 Levels 2 Speed (mph) o 40 60 70 80 3 Level 1 2 3 4 S SPEED Insurance Insurance 2 or less Special or more Special 1 Level Features Featured 2 1 5 2 2x 10% 4 3 13N 15% 3 4 17% 20% 5 5 21% 29% INSURANCE RATES Write an Excel formula in cell RIDES!Q4, which can be copied down to RIDES!Q17, to determine a level for each coaster based on Its average MPH. O =VLOOKUP(G4, Speed!B$2:F$3,2,FALSE) O =HLOOKUP(G4 Speed!B$2:F$3,2, TRUE) O =HLOOKUP(G4,Speed!B$2:F$3,2,FALSE) O =VLOOKUP(G4,Speed!B$2:F$3,2,TRUE) co
