{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Estimate Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":58,"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":"Instructions","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Welcome to top dog!"]
["Instructions for using the Estimate Worksheet","2005-02-10"]
["If you have any questions, call us on 510 845 2580"]
["On the \"Estimate Worksheet\" tab of this workbook, fill in the quantities for the items you'd like served at your event.  The sub-totals (by category) and the event total will dynamically update to reflect the cost."]
[]
["The base price for an event is $650.00  This includes the first 60 dogs and a self-serve condiment bar with ketchup, 3 types of mustards, onions, sweet relish, and heated sauerkraut.  Staffing to serve for ninety minutes, set up, and break down of all equipment is also included (there may be a travel surcharge if your event is more than 20 miles from Berkeley, this will be discussed at the time of booking)\n\nA cancellation fee will apply if a booking is cancelled within 72 hours prior to the scheduled start."]
[]
["Beyond the minimum, dogs cost $5.00 each.  You are billed only for what is used (we bring more than your estimate).  The full range of dogs are listed on the Estimate Worksheet tab of this workbook; we recommend choosing 3 or 4 varieties (for descriptions of the sausages, please visit our website at \"www.topdoghotdogs.com\" and click on \"The Menu\"), or click on the link below."]
["If you book your event 3 or more weeks before it takes place, we will give you a 5% discount on the whole order!"]
["www.topdoghotdogs.com/themenu.html"]
[]
["The minimum order for all sides, except the veggie platter, is 20 servings and incur a minimum charge of 75% of the amount ordered."]
["►  Salads are served \"party style\" (self-serve from large bowls which we refill as needed).  Pricing includes plates and plastic utensils, if needed."]
["►  Desserts can be individually wrapped, upon request."]
["►  Chips are individually bagged, in assorted varieties."]
["►  Sodas and bottled water are served ice cold."]
[]
["Contact information is listed at the top of the Estimate Worksheet tab of this workbook; we are always happy to answer any questions you may have."]
[]
["Thank you for considering top dog !"]
[]
["Kimberly Villicaña"]
["top dog Catering Manager"]
["Manager"]
["(510) 845 2580"]

{"sheet":"Estimate Worksheet","index":1,"n_rows":62,"n_cols":9,"rows_kept":62,"cut":false,"hidden":false,"merged":[[6,6,6,7],[5,6,5,7],[4,6,4,7],[12,6,12,7],[11,4,11,5],[11,6,11,7],[9,6,9,7],[8,6,8,7],[7,6,7,7]]}
[null,"top dogTM"]
[null,"Consumption Based WORKSHEET"]
[null,"For more information on catering see the Instruction Tab on the worksheet, or call us on 510 845 2580"]
[]
[null,null,null,null,null,"company:","co. name (if any)"]
[null,"top dog contact:","Jeremy Bower",null,null,"contact:","your name"]
[null,"voice:",5108452580,null,null,"voice:","your phone #"]
[null,"email:","catering@topdoghotdogs.com",null,null,"cell:","your cell #"]
[null,null,null,null,null,"email:","your email"]
[null,"Event Date:",null,null,"Serving Window:","start.. am/pm","end.. am/pm",null,"Standard service Window is 1.5 hours"]
[null,"# attendees:"]
[null,"Postal Address","street address",null,"Event Address:",null,"street address"]
[null,null,"city, zip",null,null,null,"city, zip"]
[null,"Book 3 or more weeks in advance and save 5% !"]
[]
[null,"Item",null,"Qty.","@","Ext."]
[null,"Dogs","top dog",0]
[null,null,"Garlic (German)",0]
[null,null,"Bockwurst",0]
[null,null,"Kielbasa",0]
[null,null,"Calabrese",0]
[null,null,"Hot Link",0]
[null,null,"Bratwurst",0]
[null,null,"Lemon Chicken",0]
[null,null,"Sm. Chicken Apple",0]
[null,null,"Mango Habanero",0]
[null,null,"Linguiça",0]
[null,null,"Veggie",0]
[null,null,"TOTAL",{"$f":"SUM(D17:D28)","v":0},"*",{"$f":"750+IF(Dogs_Ordered>60,6*(Dogs_Ordered-60),0)","v":750}]
[null,null,"SF Potato Salad",0,2.5,{"$f":"D30*E30","v":0}]
[null,null,"Cole Slaw",0,2.5,0]
[null,null,"Garden Salad",0,2.25,0]
[null,null,"Caesar Salad",0,2.25,0]
[null,null,"Fruit Salad",0,2.5,0]
[null,null,"Veggie Platter",0,100,{"$f":"D35*E35","v":0},null,"Each Veggie Platter serves 80"]
[null,null,"Chips",0,1.5,0]
[null,null,"Chili",0,2,{"$f":"D37*E37","v":0}]
[null,null,"Cheese",0,0.75,0]
[null,null,"TOTAL",{"$f":"SUM(D30:D38)","v":0},"TOTAL:",{"$f":"SUM(F30:F38)","v":0}]
[null,"Drinks","Water",0,1.5,{"$f":"D40*E40","v":0}]
[null,null,"Soda",0,1.5,{"$f":"D41*E41","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D40:D41)","v":0},"TOTAL:",{"$f":"SUM(F40:F41)","v":0}]
[null,"Desserts","Cookies",0,3.5,{"$f":"D43*E43","v":0}]
[null,null,"TOTAL",{"$f":"SUM(D43:D43)","v":0},"TOTAL:",{"$f":"SUM(F43:F43)","v":0}]
[]
[null,null,null,null,"Item","Price"]
[null,null,null,null,"Dogs:",{"$f":"Dogs_Total_Ordered","v":750}]
[null,null,null,null,"Sides:",{"$f":"Salad_Total_Ordered","v":0}]
[null,null,null,null,"Drinks:",{"$f":"Drink_Total_Ordered","v":0}]
[null,null,null,null,"Desserts:",{"$f":"Snack_Total_Ordered","v":0}]
[null,null,null,null,"Total:",{"$f":"SUM(F47:F50)","v":750}]
[null,null,null,null,"Tax (10.25%):",{"$f":"F51*0.1025","v":76.875}]
[null,null,null,null,"Travel Surcharge**:",0]
[null,null,null,null,"Labor Surcharge***:",{"$f":"IF(ISERROR(End_Serving-Start_Serving),0,IF((End_Serving-Start_Serving)*24*60>90,20*ROUNDUP(((End_Serving-Start_Serving)*24*60-90)/30,0),0))","v":0}]
[null,null,null,null,"Event Estimate:",{"$f":"SUM(F51:F54)","v":826.875}]
[null,null,null,null,"Down Payment:",0]
[]
[]
[]
[null,null,"** A travel surcharge may apply for events more than 10 miles from Berkeley"]
[]
[null,null,"*** A labor surcharge may apply for a requested service time of more than 1.5 hours"]