{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Home","Help","Restaurant info","Restaurant list"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,1,2,10],[1,1,1,10],[7,1,9,1],[5,2,5,4],[7,3,7,4],[8,3,8,4],[9,3,9,4]]}
[]
[null,"~Dinner Date for Two~"]
[null,"Do you have a date coming up but you aren't sure where to eat? Or are you stuck in a rut of always eating at the place? Worry no more! The \"Dinner Date for Two\" was created for people just like you! It is here to assist you in deciding which restaurant will best suit your needs and to help you branch out and try new places. Just answer 5 basic questions so that we can find the best match for you and your date! "]
[]
[]
[null,"1) Which location is closest to you?","Provo City Center Temple"]
[]
[null,"2) What types of food do you like? (You may choose three)","Type 1:","Indian"]
[null,null,"Type 2:","Asian"]
[null,null,"Type 3:","Sandwich"]
[]
[null,"3) What is your price range? (For two people)"]
[]
[null,"4) How far are you willing to travel? "]
[null,"5) How accurate do you want the match?","67% match"]
[null,"Restaurant","Type","Price","Distance",null,"Percent Match","Variable","Wilk","Temple","Walmart",null,"n range"]
[null,"Asa Ramen","Asian",12,{"$f":"IF(Location=\"Wilkinson Student Center\",I17,IF(Location=\"Provo City Center Temple\",J17,IF(Location=\"Provo Neighborhood Walmart\",K17)))","v":4},"Miles",{"$f":"H17/3","v":1},3,3.9,4,1.6,null,{"$f":"COUNTA(B17:B107)","v":19}]
[null,"Subway","Sandwich",14,{"$f":"IF(Location=\"Wilkinson Student Center\",I18,IF(Location=\"Provo City Center Temple\",J18,IF(Location=\"Provo Neighborhood Walmart\",K18)))","v":0.8},"Miles",{"$f":"H18/3","v":1},3,1.7,0.8,2.2999999999999998]
[null,"Taco Bell","Mexican",14,{"$f":"IF(Location=\"Wilkinson Student Center\",I19,IF(Location=\"Provo City Center Temple\",J19,IF(Location=\"Provo Neighborhood Walmart\",K19)))","v":1.3},"Miles",{"$f":"H19/3","v":0.66666666666666663},2,0.8,1.3,3]
[null,"Don Chuy's Taco Shop","Mexican",8,{"$f":"IF(Location=\"Wilkinson Student Center\",I20,IF(Location=\"Provo City Center Temple\",J20,IF(Location=\"Provo Neighborhood Walmart\",K20)))","v":1.3},"Miles",{"$f":"H20/3","v":0.66666666666666663},2,0.7,1.3,2.9]
[null,"Wendy's","Burgers",8,{"$f":"IF(Location=\"Wilkinson Student Center\",I21,IF(Location=\"Provo City Center Temple\",J21,IF(Location=\"Provo Neighborhood Walmart\",K21)))","v":2.2999999999999998},"Miles",{"$f":"H21/3","v":0.66666666666666663},2,3.7,2.2999999999999998,3.7]
[null,"McDonald's","Burgers",10,{"$f":"IF(Location=\"Wilkinson Student Center\",I22,IF(Location=\"Provo City Center Temple\",J22,IF(Location=\"Provo Neighborhood Walmart\",K22)))","v":1.1000000000000001},"Miles",{"$f":"H22/3","v":0.66666666666666663},2,2.9,1.1000000000000001,3.7]
[null,"Domino's Pizza","Italian",8,{"$f":"IF(Location=\"Wilkinson Student Center\",I23,IF(Location=\"Provo City Center Temple\",J23,IF(Location=\"Provo Neighborhood Walmart\",K23)))","v":0.2},"Miles",{"$f":"H23/3","v":0.66666666666666663},2,1.9,0.2,2.8]
[null,"Little Caesers Pizza","Italian",6,{"$f":"IF(Location=\"Wilkinson Student Center\",I24,IF(Location=\"Provo City Center Temple\",J24,IF(Location=\"Provo Neighborhood Walmart\",K24)))","v":1.3},"Miles",{"$f":"H24/3","v":0.66666666666666663},2,0.8,1.3,3]
[null,"Slab Pizza","Italian",12.5,{"$f":"IF(Location=\"Wilkinson Student Center\",I25,IF(Location=\"Provo City Center Temple\",J25,IF(Location=\"Provo Neighborhood Walmart\",K25)))","v":1.3},"Miles",{"$f":"H25/3","v":0.66666666666666663},2,0.4,1.3,2.4]
[null,"Two Jack's Pizza","Italian",12.5,{"$f":"IF(Location=\"Wilkinson Student Center\",I26,IF(Location=\"Provo City Center Temple\",J26,IF(Location=\"Provo Neighborhood Walmart\",K26)))","v":0.3},"Miles",{"$f":"H26/3","v":0.66666666666666663},2,1.8,0.3,2.6]
[null,"Bombay House","Indian",33,{"$f":"IF(Location=\"Wilkinson Student Center\",I27,IF(Location=\"Provo City Center Temple\",J27,IF(Location=\"Provo Neighborhood Walmart\",K27)))","v":0.6},"Miles",{"$f":"H27/3","v":0.66666666666666663},2,1.3,0.6,2.1]
[null,"Tandoor","Indian",24,{"$f":"IF(Location=\"Wilkinson Student Center\",I28,IF(Location=\"Provo City Center Temple\",J28,IF(Location=\"Provo Neighborhood Walmart\",K28)))","v":2},"Miles",{"$f":"H28/3","v":0.66666666666666663},2,2,2,1]
[null,"India Palace","Indian",20,{"$f":"IF(Location=\"Wilkinson Student Center\",I29,IF(Location=\"Provo City Center Temple\",J29,IF(Location=\"Provo Neighborhood Walmart\",K29)))","v":0.3},"Miles",{"$f":"H29/3","v":0.66666666666666663},2,1.8,0.3,2.6]
[null,"K's Kitchen","Asian",30,{"$f":"IF(Location=\"Wilkinson Student Center\",I30,IF(Location=\"Provo City Center Temple\",J30,IF(Location=\"Provo Neighborhood Walmart\",K30)))","v":0.6},"Miles",{"$f":"H30/3","v":0.66666666666666663},2,2,0.6,2.5]
[null,"Ahi Muse","Asian",40,{"$f":"IF(Location=\"Wilkinson Student Center\",I31,IF(Location=\"Provo City Center Temple\",J31,IF(Location=\"Provo Neighborhood Walmart\",K31)))","v":3.9},"Miles",{"$f":"H31/3","v":0.66666666666666663},2,3.5,3.9,1.3]
[null,"Saigon Café","Asian",18,{"$f":"IF(Location=\"Wilkinson Student Center\",I32,IF(Location=\"Provo City Center Temple\",J32,IF(Location=\"Provo Neighborhood Walmart\",K32)))","v":0.6},"Miles",{"$f":"H32/3","v":0.66666666666666663},2,2.7,0.6,2.5]
[null,"Umami Japanese Grill","Asian",50,{"$f":"IF(Location=\"Wilkinson Student Center\",I33,IF(Location=\"Provo City Center Temple\",J33,IF(Location=\"Provo Neighborhood Walmart\",K33)))","v":8},"Miles",{"$f":"H33/3","v":0.66666666666666663},2,8.1999999999999993,8,6.4]
[null,"Jersey Mike's Subs","Sandwich",18,{"$f":"IF(Location=\"Wilkinson Student Center\",I34,IF(Location=\"Provo City Center Temple\",J34,IF(Location=\"Provo Neighborhood Walmart\",K34)))","v":5.4},"Miles",{"$f":"H34/3","v":0.66666666666666663},2,5.3,5.4,3]
[null,"Gandolfos","Sandwich",20,{"$f":"IF(Location=\"Wilkinson Student Center\",I35,IF(Location=\"Provo City Center Temple\",J35,IF(Location=\"Provo Neighborhood Walmart\",K35)))","v":1.5},"Miles",{"$f":"H35/3","v":0.66666666666666663},2,1.5,1.5,1.4]

{"sheet":"Help","index":1,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
[]
[null,"~Dinner Date for Two Help Sheet~"]
[null,"Do you have a date coming up but you aren't sure where to eat? Or are you stuck in a rut of always eating at the place? Worry no more! The \"Dinner Date for Two\" was created for people just like you! It is here to assist you in deciding which restaurant will best suit your needs and to help you branch out and try new places. Just answer 5 basic questions so that we can find the best match for you and your date! "]
[]
[]
[null,"Objective: "]
[null,"The object is to help those struggling with indecision decide where to go to eat."]
[]
[null,"To Use:"]
[null,"1. Make sure that the sheet is blank by clicking \"Reset Selection\""]
[null,"2. Answer the 5 questions"]
[null,"    a. if you forget to answer one of the questions, you will be prompted to go back and answer"]
[null,"3. Click \"Find my Restuarants!\""]
[null,"4. Look below to see which resturants will best suit your needs!"]
[null,"5. If you need to do another search, just click \"Reset Selection\" and repeat!"]
[null,"6. Once you have decided on your restaurant, go and enjoy! We wish you the best of luck on your date :)"]

{"sheet":"Restaurant info","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Place list"]
["Restaurant","Cafe Rio","Taco Bell","Don Chuy's","In-N-Out","Wendy's","McDonalds","JCWs","Five Guys",null,"Type List","Price List","Distance","<SELECT>"]
["Average Price",24,14,8,16,8,10,22,24,null,"<SELECT>","*opt","*opt","Wilkinson Student Center"]
["Type","Mexican","Mexican","Mexican","Burgers","Burgers","Burgers","Burgers","Burgers",null,"Mexican",null,null,"Provo City Center Temple"]
["Wilk",2.8,0.8,0.7,3.8,3.7,2.9,2.2999999999999998,3.6,null,"Burgers",null,null,"Provo Neighborhood Walmart"]
["Temple",1,1.3,1.3,3.9,2.2999999999999998,1.1000000000000001,2.7,3.9,null,"Italian"]
["Walmart",3.6,3,2.9,1.6,3.7,3.7,0.4,1.3,null,"Indian"]
[null,null,null,null,null,null,null,null,null,null,"Asian"]
[null,null,null,null,null,null,null,null,null,null,"Sandwich"]
["Restaurant","Brick oven","Olive Garden","Carrabba's","Dominos","Little caesers","Slab Pizza","Two Jack's",null,null,"Buffet"]
["Average Price",34,40,36,8,6,12.5,12.5,null,null,"No Preference"]
["Type","Italian","Italian","Italian","Italian","Italian","Italian","Italian",null,null,null,null,null,"Accuary list"]
["Wilk",0.9,2.4,3.4,1.9,0.8,0.4,1.8,null,null,null,null,null,"100% match"]
["Temple",1.1000000000000001,2.8,3.8,0.2,1.3,1.3,0.3,null,null,null,null,null,"67% match"]
["Walmart",1.9,0.5,1.2,2.8,3,2.4,2.6,null,null,6,"5-15",null,"33% match"]
[null,null,null,null,null,null,null,null,null,null,8,null,null,"Show all"]
[null,null,null,null,null,null,null,null,null,null,8]
["Restaurant","Bombay house","Tandoor","India Palace","K's Kitchen","Ahi Muse","Saigon Cafe","Asa Ramen","Umami",null,8]
["Average Price",33,24,20,30,40,18,12,50,null,10]
["Type","Indian","Indian","Indian","Asian","Asian","Asian","Asian","Asian",null,12]
["Wilk",null,null,null,null,null,null,null,null,null,12.5]
["Temple",null,null,null,null,null,null,null,null,null,12.5]
["Walmart",null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,14]
[]
["Restaurant","Subway","Jersey Mikes","Gandolfos","Golden Corral","Chuck-a-rama","Tucannos","Wild Ginger",null,null,16,"16-25"]
["Average Price",14,18,20,25,32,50,24,null,null,18]
["Type","Sandwich","Sandwich","Sandwich","Buffet","Buffet","Buffet","Buffet",null,null,20]
["Wilk",null,null,null,null,null,null,null,null,null,20]
["Temple",null,null,null,null,null,null,null,null,null,22]
["Walmart",null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,24]
[null,0.9,2.4,3.4,1.9,0.8,0.4,1.8,null,null,24]
[null,1.1000000000000001,2.8,3.8,0.2,1.3,1.3,0.3,null,null,24]
[null,1.9,0.5,1.2,2.8,3,2.4,2.6,null,null,25]
[null,2.8,0.8,0.7,3.8,3.7,2.9,2.2999999999999998]
[null,1,1.3,1.3,3.9,2.2999999999999998,1.1000000000000001,2.7,null,null,30,"26+"]
[null,3.6,3,2.9,1.6,3.7,3.7,0.4,null,null,32]
[null,3.6,3.9,1.3,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,"0-1",null,null,null,null,null,36]
[null,null,null,null,"1.1-2",null,null,null,null,null,40]
[null,null,null,null,"2.1-3",null,null,null,null,null,40]
[null,null,null,null,"3.1+",null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,50]

{"sheet":"Restaurant list","index":3,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Restaurant","Type","Price","Distance",null,"Percent Match","Variable","Wilk","Temple","Walmart",null,"n range"]
[null,"Café Rio Mexican Grill","Mexican",25,{"$f":"IF(Location=\"Wilkinson Student Center\",I3,IF(Location=\"Provo City Center Temple\",J3,IF(Location=\"Provo Neighborhood Walmart\",K3)))","v":1},"Miles",{"$f":"H3/3","v":0},0,2.8,1,3.6,null,{"$f":"COUNTA(B3:B93)","v":30}]
[null,"Taco Bell","Mexican",14,1.3,"Miles",{"$f":"H4/3","v":0},0,0.8,1.3,3]
[null,"Don Chuy's Taco Shop","Mexican",8,1.3,"Miles",0,0,0.7,1.3,2.9]
[null,"In-N-Out Burger","Burgers",16,3.9,"Miles",{"$f":"H6/3","v":0},0,3.8,3.9,1.6]
[null,"Wendy's","Burgers",8,2.2999999999999998,"Miles",0,0,3.7,2.2999999999999998,3.7]
[null,"McDonald's","Burgers",10,1.1000000000000001,"Miles",0,0,2.9,1.1000000000000001,3.7]
[null,"JCWs The Burger Boys","Burgers",22,2.7,"Miles",0,0,2.2999999999999998,2.7,0.4]
[null,"Five Guys","Burgers",24,3.9,"Miles",0,0,3.6,3.9,1.3]
[null,"Brick Oven","Italian",34,1.1000000000000001,"Miles",0,0,0.9,1.1000000000000001,1.9]
[null,"Olive Garden Italian Resteraunt","Italian",40,2.8,"Miles",0,0,2.4,2.8,0.5]
[null,"Carrabba's Italian Grill","Italian",36,3.8,"Miles",0,0,3.4,3.8,1.2]
[null,"Domino's Pizza","Italian",8,0.2,"Miles",0,0,1.9,0.2,2.8]
[null,"Little Caesers Pizza","Italian",6,1.3,"Miles",0,0,0.8,1.3,3]
[null,"Slab Pizza","Italian",12.5,1.3,"Miles",0,0,0.4,1.3,2.4]
[null,"Two Jack's Pizza","Italian",12.5,0.3,"Miles",0,0,1.8,0.3,2.6]
[null,"Bombay House","Indian",33,0.6,"Miles",0,0,1.3,0.6,2.1]
[null,"Tandoor","Indian",24,2,"Miles",0,0,2,2,1]
[null,"India Palace","Indian",20,0.3,"Miles",0,0,1.8,0.3,2.6]
[null,"K's Kitchen","Asian",30,0.6,"Miles",0,0,2,0.6,2.5]
[null,"Ahi Muse","Asian",40,3.9,"Miles",0,0,3.5,3.9,1.3]
[null,"Saigon Café","Asian",18,0.6,"Miles",0,0,2.7,0.6,2.5]
[null,"Asa Ramen","Asian",12,4,"Miles",0,0,3.9,4,1.6]
[null,"Umami Japanese Grill","Asian",50,8,"Miles",0,0,8.1999999999999993,8,6.4]
[null,"Subway","Sandwich",14,0.8,"Miles",0,0,1.7,0.8,2.2999999999999998]
[null,"Jersey Mike's Subs","Sandwich",18,5.4,"Miles",0,0,5.3,5.4,3]
[null,"Gandolfos","Sandwich",20,1.5,"Miles",0,0,1.5,1.5,1.4]
[null,"Golden Corral Buffet & Grill","Buffet",25,7.9,"Miles",0,0,4.5,7.9,2.2000000000000002]
[null,"Chuck-a-rama","Buffet",32,1,"Miles",0,0,3.6,1,3.6]
[null,"Tucanos","Buffet",50,4,"Miles",0,0,3.6,4,1.3]
[null,"Wild Ginger","Buffet",24,0.5,"Miles",0,0,1.7,0.5,2.5]