{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Disclaimer","Inputs, Part 1","Inputs, Part 2","Discount Calculation","Cht--Party Size","Cht--Arrivals","Results","cht-Value by Pty Vol","cht-Value by Party Count","Recommended Table Mix"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":15,"comments":2,"pivot_tables":0},"unopened":[{"sheet":"Cht--Party Size","index":4,"reason":"not_a_worksheet"},{"sheet":"Cht--Arrivals","index":5,"reason":"not_a_worksheet"},{"sheet":"cht-Value by Pty Vol","index":7,"reason":"not_a_worksheet"},{"sheet":"cht-Value by Party Count","index":8,"reason":"not_a_worksheet"}],"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":"Disclaimer","index":0,"n_rows":98,"n_cols":1,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
["CHR TOOLS EVALUATION LICENSE"]
[]
["IMPORTANT --- READ CAREFULLY. This evaluation license agreement (\"Agreement\") is a legal contract between you (either an individual or a single business entity) and The Center for Hospitality Research at Cornell University (\"Licensor\") for the software product identified above, which includes computer software and, as applicable, associated media, printed materials, and \"online\" or electronic documentation (the \"Software Application\")."]
[]
["BY INSTALLING, COPYING, OR OTHERWISE USING THE SOFTWARE APPLICATION, YOU AGREE TO BE BOUND BY THE TERMS OF THIS AGREEMENT. IF YOU DO NOT AGREE TO THE TERMS OF THIS AGREEMENT, DO NOT INSTALL OR USE THE SOFTWARE APPLICATION."]
[]
["License Terms"]
[]
["Following acceptance of this Agreement and on-line registration with the Licensor, you may use, strictly for trial use and evaluation purposes only, one copy of the Software Application."]
[]
["You may not reverse engineer, decompile, disassemble, or otherwise translate the Software Application, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation."]
[]
["The Software Application and related user documentation if any are proprietary products of Licensor protected under U.S. copyright law. All right, title, and interest in and to the Software Application, including associated intellectual property rights, are and shall remain with Licensor. This Agreement does not convey to you an interest in or to the Software Application, but only a limited right of use revocable in accordance with the terms of this Agreement."]
[]
["The Software Application is provided without charge under this evaluation license. The free trial period is of limited duration. Licensor may extend the free trial period, but reserves the right, at any time, to condition access on the payment of charges. Licensor may terminate access to the tool upon 30 days' prior notice."]
[]
["Licensor will not provide you with support services related to the Software Application, and is under no obligation to do so."]
[]
["You may not distribute copies of the Software Application to third parties or transfer any rights under this Agreement."]
[]
["Without prejudice to any other rights, Licensor may terminate this Agreement if you fail to comply with the terms and conditions of this Agreement. In such event, you must destroy all copies of the Software Application and all of its component parts."]
[]
["Governing Law"]
[]
["This Agreement shall be governed by the laws of the State of New York."]
[]
["Proprietary Rights"]
[]
["Copyright. All title and copyrights in and to the Software Application (including, without limitation, any images, photographs, animations, video, audio, music, text, and \"applets\" incorporated into the Software Application), the accompanying media and printed materials, and any copies of the Software Product are owned by Licensor or its suppliers. The Software Application is protected by copyrights laws and international treaty provisions. Therefore, you must treat the software Application like any other copyrighted material, subject to the provisions of this Agreement."]
[]
["U.S. Government Restricted Rights. The Software Application and documentation are provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by the Government is subject to restrictions as set forth in subparagraph (c)(1)(ii) of the Rights in technical Data and Computer Software clause at DFARS 252.227-7013 or subparagraphs (c) (1) and (2) of the Commercial Computer Software -- Restricted Rights at 48 CFR 52.227-19, as applicable. Manufacturer for such purpose is The Center for Hospitality Research, with offices in the School of Hotel Administration at Cornell University, Ithaca, NY 14853."]
[]
["Submissions. Should you decide to transmit to Licensor's website by any means or by any media any materials or other information (including, without limitation, ideas, concepts or techniques for new or improved services and products), whether as information, feedback, data, questions, comments, suggestions or the like, you agree such submissions are unrestricted and shall be deemed non-confidential and you automatically grant Licensor and its assigns a non-exclusive, royalty-free, worldwide, perpetual, irrevocable license, with the right to sublicense, to use, copy, transmit, distribute, create derivative works of, display and perform the same."]
[]
["Disclaimer Of Warranty"]
[]
["THIS SOFTWARE AND THE ACCOMPANYING FILES ARE PROVIDED \"AS IS\". LICENSOR AND ITS SUPPLIERS DO NOT AND CANNOT WARRANT THE PERFORMANCE OR RESULTS YOU MAY OBTAIN BY USING THE SOFTWARE OR SUCH FILES. LICENSOR AND ITS SUPPLIERS MAKE NO WARRANTIES, EXPRESS OR IMPLIED, AS TO TITLE OR INFRINGEMENT OF THIRD-PARTY RIGHTS, MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE."]
[]
["Good data processing procedure dictates that any program be thoroughly tested with non-critical data before relying on it. the user must assume the entire risk of using the Software Application. ANY LIABILITY OF LICENSOR FOR A DEFECTIVE COPY OF THE SOFTWARE APPLICATION WILL BE LIMITED EXCLUSIVELY TO REPLACEMENT OF YOUR COPY OF THE SOFTWARE APPLICATION WITH ANOTHER COPY OR REFUND OF THE INITIAL LICENSE FEE LICENSOR RECEIVED FROM YOU FOR THE DEFECTIVE COPY OF THE PRODUCT (IF ANY). IN NO EVENT WILL LICENSOR OR ITS SUPPLIERS BE LIABLE TO YOU FOR ANY CONSEQUENTIAL, INCIDENTAL OR SPECIAL DAMAGES, INCLUDING ANY LOST PROFITS OR LOST SAVINGS, EVEN IF A LICENSOR REPRESENTATIVE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, OR FOR ANY CLAIM BY ANY THIRD PARTY."]
[]
["Some states or jurisdictions do not allow the exclusion or limitation of incidental, consequential or special damages, or the exclusion of implied warranties or limitations on how long a given warranty may last, so the above limitations may not apply to you."]
[]
["CHR TOOLS END-USER LICENSE"]
[]
["LICENSOR'S PROGRAM IS COPYRIGHTED AND LICENSED (NOT SOLD). LICENSOR DOES NOT SELL OR TRANSFER TITLE TO THE LICENSED PROGRAM TO YOU. YOUR LICENSE OF THE LICENSED PROGRAM WILL NOT COMMENCE UNTIL YOU HAVE REGISTERED WITH LICENSOR, PAID THE LICENSE FEE AND HAVE RECEIVED AN ACTIVATION CODE."]
[]
["IMPORTANT --- READ CAREFULLY. This evaluation license agreement (\"Agreement\") is a legal contract between you (either an individual or a single business entity) and The Center for Hospitality Research at Cornell University (\"Licensor\") for the software product identified above, which includes computer software and, as applicable, associated media, printed materials, and \"online\" or electronic documentation (the \"Software Application\")."]
[]
["BY INSTALLING, COPYING, OR OTHERWISE USING THE SOFTWARE APPLICATION, YOU AGREE TO BE BOUND BY THE TERMS OF THIS AGREEMENT. IF YOU DO NOT AGREE TO THE TERMS OF THIS AGREEMENT, DO NOT INSTALL OR USE THE SOFTWARE APPLICATION. "]
[]
["1. License. In exchange for payment of the license fee, Licensor grants you a nonexclusive license to use the package of computer programs and data in machine-readable form and related materials, including documentation and listings which together constitute the \"Licensed Program\", subject to the following terms and conditions."]
[]
["2. Scope of Rights. You may:"]
["-- Install and execute the Licensed Program on the computer specified in the license registration process, to serve the internal needs of your business;"]
["-- In support of your authorized use of the Licensed Program, store the Licensed Program's machine-readable instructions or data in, transmit it through, and display it on machines associated with the specified computer."]
[]
["3. Support. Licensor shall support the Licensed Program without additional charge, by e-mail and by free upgrades of the Licensed Program as they may be issued, for a period of one year following the beginning of the license term. Licensor is not obligated to issue any upgrades of the Licensed Program."]
[]
["4. Your Responsibilities:"]
[]
["You are responsible for selecting an operator who is qualified to operate the Licensed Program on your own equipment and who is familiar with the information, calculations, and reports that serve as input and output of the Licensed Program; -- You are solely responsible for payment of any taxes (including sales or use taxes, intangible taxes, and property taxes) resulting from your acceptance of this license and your possession and use of the Licensed Program, exclusive of taxes based on Licensor's income. Licensor reserves the right to have you pay any such taxes as they fall due to Licensor for remittance to the appropriate authority. You agree to hold harmless Licensor from all claims and liability arising from your failure to report or pay such taxes;"]
["You are solely responsible for converting your data files for use with the Licensed Program, and Licensor assumes no responsibility for such conversion;"]
["You are responsible for reasonable backup precautions; Licensor shall have no liability for loss of data or documentation."]
[]
["5. Proprietary Protection and Ownership. Licensor is and shall remain the sole and exclusive owner of all right, title and interest in and to the Licensed Program and all modifications and enhancements thereof (including ownership of all trade secrets and copyrights pertaining thereto), subject only to the rights and privileges expressly granted to you herein by Licensor. This Agreement does not provide you with title or ownership of the Licensed Program, but only a right of limited use."]
[]
["6. Restrictions on Use of the Licensed Program. You may not:"]
[]
["Use, copy, modify, or distribute the Licensed Program (electronically or otherwise), or any copy, adaptation, transcription, or merged portion thereof, except as expressly authorized by Licensor;"]
["Reverse assemble, reverse compile, or otherwise translate the Licensed Program;"]
["Transfer, lease, assign, or sublicense the Licensed Program except for a transfer of the Licensed Program in its entirety to (1) a successor in interest of your entire business who assumes the obligations of this Agreement or (2) any other party who is reasonably acceptable to Licensor and who enters into a substitute version of this Agreement, and pays an administrative fee intended to cover attendants costs;"]
["Use the Licensed Program for service bureau work, multiple-user license, or time-sharing arrangement;"]
["Install the Licensed Program in any other computer system or use it at any other location without first de-activating the Licensed Program on the computer from which the Licensed Program is to be transferred as provided by the operating instructions."]
[]
["7. Infringement. If a third party claims that the Licensed Program infringes its patent, copyright, or trade secret, or any similar intellectual property right, Licensor will defend you against that claim at Licensor's expense and pay all damages that a court finally awards, provided that you promptly notify Licensor in writing of the claim, and allow Licensor to control, and cooperate with Licensor in, the defense or any related settlement negotiations. If such a claim is made or appears possible, you agree to permit Licensor to enable you to continue to use the Licensed Programs, or to modify or replace them. If Licensor determines that none of these alternatives is reasonably available, you agree to return the Licensed Program on Licensor's written request, and you will then receive a credit equal to your net book value for the Licensed Program determined in accordance with generally accepted accounting principles. However, Licensor has no obligation for any claim based on your modification of the Licensed Program or its combination, operation, or use with any product, data, or apparatus not specified or provided by Licensor, provided that such claim solely and necessarily is based on such combination, operation, or use and such claim would be avoided by combination, operation, or use with products, data, or apparatus specified or provided by Licensor. THIS PARAGRAPH STATES LICENSOR'S ENTIRE OBLIGATION TO YOU WITH RESPECT TO ANY CLAIM OF INFRINGEMENT."]
[]
["8. Limited Warranty and Limitation of Liability. Licensor warrants, for your benefit alone, that the Licensed Program conforms in all material respects to the specifications for the current version of the Licensed Program."]
[]
["EXCEPT AS EXPRESSLY SET FORTH IN THIS AGREEMENT, LICENSOR DISCLAIMS ANY AND ALL PROMISES, REPRESENTATIONS, AND WARRANTIES WITH RESPECT TO THE LICENSED PROGRAM, INCLUDING ITS CONDITION, ITS CONFORMITY TO ANY REPRESENTATION OR DESCRIPTION, THE EXISTENCE OF ANY LATENT OR PATENT DEFECTS, ANY NEGLIGENCE, AND ITS MERCHANTABILITY OR FITNESS FOR A PARTICULAR USE."]
[]
["The cumulative liability of Licensor to you for all claims relating to the Licensed Program and this Agreement, including any cause of action sounding in contract, tort, or strict liability, shall not exceed the total amount of all license fees paid to Licensor hereunder. This limitation of liability is intended to apply without regard to whether other provisions of this Agreement have been breached or have proven ineffective. This limitation of liability shall not apply to the indemnification provided in Section 7 hereof. In no event shall Licensor be liable for any loss of profits; any incidental, special, exemplary, or consequential damages; or any claims or demands brought against you even if Licensor has been advised of the possibility of such claims or demands. This limitation upon damages and claims is intended to apply without regard to whether other provisions of this Agreement have been breached or have proven ineffective."]
[]
["You may have additional rights under certain laws (e.g., consumer laws) that do not allow the exclusion of implied warranties, or the exclusion or limitation of certain damages. If such laws apply, our exclusions or limitations do not apply to you."]
[]
["9. Submissions. Should you decide to transmit to Licensor's website by any means or by any media any materials or other information (including, without limitation, ideas, concepts or techniques for new or improved services and products), whether as information, feedback, data, questions, comments, suggestions or the like, you agree such submissions are unrestricted and shall be deemed non-confidential and you automatically grant Licensor and its assigns a non-exclusive, royalty-free, worldwide, perpetual, irrevocable license, with the right to sublicense, to use, copy, transmit, distribute, create derivative works of, display and perform the same."]
[]
["10. Term of Agreement; Termination. Your license of the Licensed Program shall become effective upon delivery of the Licensed Program to you and your payment of the license fee therefore, and shall continue in perpetuity unless terminated as provided herein."]
[]
["Upon termination of this Agreement, all rights granted to you will terminate and revert to Licensor. Promptly upon termination of this Agreement for any reason or upon discontinuance or abandonment of your possession or use of the Licensed Program, you must return or destroy, as requested by Licensor, all copies of the Licensed Program in your possession (whether modified or unmodified), and all other materials pertaining to the Licensed Program (including all copies thereof). You agree to certify your compliance with such restriction upon Licensor's request."]
[]
["11. Miscellaneous."]
[]
["This Agreement shall be governed by and construed in accordance with the laws of the State of New York."]
["No modification of this Agreement shall be binding unless it is in writing and is signed by an authorized representative of the party against whom enforcement of the modification is sought."]
["References to your use or benefit include any subsidiaries you may own directly or indirectly by more than fifth percent (50%), provided that, to the extent of their use and benefit, they comply with the restrictions herein."]
["Any notices required or permitted under this Agreement shall be in writing and delivered in person or sent by registered or certified mail, return receipt requested, with proper postage affixed."]
["In the event that any of the terms of this Agreement is or becomes or is declared to be invalid or void by any court or tribunal of competent jurisdiction, such term or terms shall be null and void and shall be deemed severed from this Agreement and all the remaining terms of this Agreement shall remain in full force and effect."]
["THIS AGREEMENT IS THE COMPLETE AND EXCLUSIVE STATEMENT OF LICENSOR'S OBLIGATIONS AND RESPONSIBILITIES TO YOU AND SUPERSEDES ANY OTHER PROPOSAL, REPRESENTATION OR OTHER COMMUNICATION BY OR ON BEHALF OF LICENSOR RELATING TO THE SUBJECT MATTER HEREOF."]

{"sheet":"Inputs, Part 1","index":1,"n_rows":32,"n_cols":34,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,6,1,7],[1,8,2,8],[24,26,25,26],[28,10,28,12],[0,19,0,20],[1,19,2,19],[1,20,2,20],[27,10,27,12],[7,22,9,22],[10,22,12,22],[13,22,17,22],[18,22,22,22],[25,10,25,12],[1,15,2,15],[23,22,25,22],[24,24,25,25],[3,22,6,22],[1,24,2,24],[23,24,23,25],[25,0,25,5],[0,0,0,8],[1,10,2,10],[1,11,2,11],[1,12,2,12],[1,0,2,0],[24,10,24,12],[23,10,23,12],[1,1,2,1],[1,2,2,2],[1,3,2,3],[24,4,24,5],[1,4,1,5],[1,25,2,25],[1,26,2,26],[0,24,0,26],[0,10,0,13],[0,16,0,18],[1,17,1,18],[1,16,2,16],[1,13,2,13],[1,22,2,22]]}
["Party-Related Data",null,null,null,null,null,null,null,null,null,"Table-Related Data",null,null,null,null,null,"Expected Number of Party Arrivals, by Period",null,null,"With a Target Net Value of the Special",null,null,"Instructions",null,"Party-Size Related Calculations",null,null,null,null,100,"Number Days",200,100,100]
["Party Size","Probability","Cumulative Probability","Party Value","Service Duration w/o Special (minutes)",null,"Service Duration w Special (minutes)",null,"Max Tolerable Wait",null,"# Seats","Space Required","Valid to Use?","Number",null,"15-Minute Interval","Without Special (Status Quo)","Estimated Arrivals With Special In Effect",null,"Parties Lost to the Special","Proportion of Total Parties Wanting the Special who want it in the Period",null,"1) Specify the data in the light blue colored cells on this sheet.",null,"Available Seats","Seated in Table","Captured $",null,null,30,"Maximum Number of Parties Waiting:",30,30,30]
[null,null,null,null,"Mean","Standard Deviation","Mean","Standard Deviation",null,null,null,null,null,null,null,null,null,"Existing + Wants Special","New + Wants Special",null,null,null,null,null,null,null,null,null,null,null,null,20]
[1,0.08,{"$f":"B4","v":0.08},10,60,12,{"$f":"E4","v":60},{"$f":"F4","v":12},30,null,1,1.625,false,0,null,"18:00:00",1,0.25,2,0.25,0.25,null,"2) If customers will be picking their own tables, specify the data in the light blue colored cells on the 'Inputs, Part 2' sheet.",null,{"$f":"IF(M4,K4,\"-\")","v":"-"},{"$f":"IF(MIN(Y4:$Y$23)=0,\"n/a\",MIN(Y4:$Y$23))","v":2},{"$f":"IF(Z4<1000,D4,\"\")","v":10},null,null,null,"Update Performance Graphs (minutes)",15]
[2,0.25,{"$f":"C4+B5","v":0.33},20,65,13,{"$f":"E5","v":65},{"$f":"F5","v":13},35,null,2,3.25,true,4,null,{"$f":"P4+15/1440","v":"18:15:00"},1,0.25,2,0.25,0.35,null,null,null,{"$f":"IF(M5,K5,\"-\")","v":2},{"$f":"IF(MIN(Y5:$Y$23)=0,\"n/a\",MIN(Y5:$Y$23))","v":2},20,null,null,null,"Start Collecting Statistics at Minute:",1000]
[3,0.11,0.44,30,70,14,70,14,40,null,3,4.875,false,0,null,{"$f":"P5+15/1440","v":"18:30:00"},1.5,0.25,2,0.25,0.4,null,null,null,"-",{"$f":"IF(MIN(Y6:$Y$23)=0,\"n/a\",MIN(Y6:$Y$23))","v":4},30,null,null,1,"Wait rule",1,1,1]
[4,0.19,0.63,40,75,15,75,15,45,null,4,6.5,true,3,null,"18:45:00",2,null,null,null,null,null,null,null,4,{"$f":"IF(MIN(Y7:$Y$23)=0,\"n/a\",MIN(Y7:$Y$23))","v":4},40,null,null,false,"create history",false,false,false]
[5,0.16,0.79,50,80,16,80,16,50,null,5,8.125,false,0,null,"19:00:00",2,null,null,null,null,null,"3) If desired, enter the existing table mix in the dark blue colored cells.",null,"-",{"$f":"IF(MIN(Y8:$Y$23)=0,\"n/a\",MIN(Y8:$Y$23))","v":6},50,null,null,null,"use history"]
[6,0.11,0.9,60,85,17,85,17,60,null,6,9.75,true,2,null,"19:15:00",2,null,null,null,null,null,null,null,6,{"$f":"IF(MIN(Y9:$Y$23)=0,\"n/a\",MIN(Y9:$Y$23))","v":6},60,null,null,true,"optimize table mix",true,true,false]
[7,0.06,0.96,70,90,18,90,18,65,null,7,11.375,false,0,null,"19:30:00",2.5,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y10:$Y$23)=0,\"n/a\",MIN(Y10:$Y$23))","v":8},70,null,null,null,null,0,15,15]
[8,0.02,0.98,80,95,19,95,19,75,null,8,13,true,1,null,"19:45:00",3,null,null,null,null,null,"4) The estimated value of special will be calculated in the columns to the right.",null,8,{"$f":"IF(MIN(Y11:$Y$23)=0,\"n/a\",MIN(Y11:$Y$23))","v":8},80]
[9,0.01,0.99,90,100,20,100,20,75,null,9,14.625,false,0,null,"20:00:00",3,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y12:$Y$23)=0,\"n/a\",MIN(Y12:$Y$23))","v":10},90]
[10,0.01,1,100,105,21,105,21,80,null,10,16.25,true,1,null,"20:15:00",3,null,null,null,null,null,null,null,10,{"$f":"IF(MIN(Y13:$Y$23)=0,\"n/a\",MIN(Y13:$Y$23))","v":10},100]
[11,0,{"$f":"C13+B14","v":1},null,null,null,null,null,null,null,11,17.875,false,0,null,"20:30:00",3,null,null,null,null,null,"5) Click the \"Evaluate the Special\" button to bring up the simulator interface form, where you specify additional parameters.",null,"-",{"$f":"IF(MIN(Y14:$Y$23)=0,\"n/a\",MIN(Y14:$Y$23))","v":"n/a"},""]
[12,0,1,null,null,null,null,null,null,null,12,19.5,false,0,null,"20:45:00",2.5,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y15:$Y$23)=0,\"n/a\",MIN(Y15:$Y$23))","v":"n/a"},""]
[13,0,1,null,null,null,null,null,null,null,13,21.125,false,0,null,"21:00:00",2,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y16:$Y$23)=0,\"n/a\",MIN(Y16:$Y$23))","v":"n/a"},""]
[14,0,1,null,null,null,null,null,null,null,14,22.75,false,0,null,"21:15:00",2,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y17:$Y$23)=0,\"n/a\",MIN(Y17:$Y$23))","v":"n/a"},""]
[15,0,1,null,null,null,null,null,null,null,15,24.375,false,0,null,"21:30:00",2,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y18:$Y$23)=0,\"n/a\",MIN(Y18:$Y$23))","v":"n/a"},""]
[16,0,1,null,null,null,null,null,null,null,16,26,false,0,null,"21:45:00",1,null,null,null,null,null,"6) After running the simulation, review the results on the Results sheet for a more accurate estimate of the value of the special.  ",null,"-",{"$f":"IF(MIN(Y19:$Y$23)=0,\"n/a\",MIN(Y19:$Y$23))","v":"n/a"},""]
[17,0,1,null,null,null,null,null,null,null,17,27.625,false,0,null,"22:00:00",1,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y20:$Y$23)=0,\"n/a\",MIN(Y20:$Y$23))","v":"n/a"},""]
[18,0,1,null,null,null,null,null,null,null,18,29.25,false,0,null,"22:15:00",1,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y21:$Y$23)=0,\"n/a\",MIN(Y21:$Y$23))","v":"n/a"},""]
[19,0,1,null,null,null,null,null,null,null,19,30.875,false,0,null,"22:30:00",1,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y22:$Y$23)=0,\"n/a\",MIN(Y22:$Y$23))","v":"n/a"},""]
[20,0,1,null,null,null,null,null,null,null,20,32.5,false,0,null,"22:45:00",1,null,null,null,null,null,null,null,"-",{"$f":"IF(MIN(Y23:$Y$23)=0,\"n/a\",MIN(Y23:$Y$23))","v":"n/a"},""]
[null,null,null,null,null,null,null,null,null,null,"Total Seats:",null,null,{"$f":"SUMPRODUCT(K4:K23,N4:N23)","v":50},null,"23:00:00",0,null,null,null,null,null,"7) See the instruction manual for additional information.",null,"Avg Value Per Party",null,{"$f":"SUMPRODUCT(AA4:AA23,B4:B23)/SUMIF(Z4:Z23,\">0\",B4:B23)","v":39}]
["KEY:","Labels","Inputs","Outputs","Decisions",null,null,null,null,null,"Total Space Used:",null,null,{"$f":"SUMPRODUCT(N4:N23,L4:L23)","v":81.25},null,"23:15:00",0,null,null,null,null,null,null,null,"Simple Estimate of Daily Net $ of Special",null,{"$f":"AA24*(SUM(S4:S31)*(100-DiscountPercent)/100-SUM(R4:R31)*DiscountPercent/100)","v":168.1875}]
["Tool Assumptions (shown in the comment)",null,null,null,null,null,null,null,null,null,"Total Space Available:",null,null,81.25,null,"23:30:00",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23:45:00",0]
[null,null,null,null,null,null,null,null,null,null,"Net Discount Percentage",null,null,25,null,0.99999999999999911,0]
[null,null,null,null,null,null,null,null,null,null,"Target Net Value of Special",null,null,100,null,1.0104166666666659,0]
["Unprotected Cells (use the cells below for your notes):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0208333333333326,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0312499999999993,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals:",{"$f":"SUM(Q4:Q31)","v":37.5},{"$f":"SUM(R4:R31)","v":0.75},{"$f":"SUM(S4:S31)","v":6},0.75,1]

{"sheet":"Inputs, Part 2","index":2,"n_rows":22,"n_cols":23,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,20],[0,0,1,0]]}
["Party Size","Probability of the Party Self-Selecting a Table of the Specified Number of Seats"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"Total"]
[1,null,0.76,null,0.15,null,0.05,null,0.03,null,0.01,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B3:U3)","v":1},{"$f":"IF(AND(V3<>1,'Inputs, Part 1'!B4>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[2,null,0.64,null,0.2,null,0.1,null,0.05,null,0.01,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B4:U4)","v":1},{"$f":"IF(AND(V4<>1,'Inputs, Part 1'!B5>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[3,null,null,null,0.77,null,0.15,null,0.05,null,0.03,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(V5<>1,'Inputs, Part 1'!B6>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[4,null,null,null,0.65,null,0.2,null,0.1,null,0.05,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(V6<>1,'Inputs, Part 1'!B7>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[5,null,null,null,null,null,0.8,null,0.15,null,0.05,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(V7<>1,'Inputs, Part 1'!B8>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[6,null,null,null,null,null,0.7,null,0.2,null,0.1,null,null,null,null,null,null,null,null,null,null,0.99999999999999989,{"$f":"IF(AND(V8<>1,'Inputs, Part 1'!B9>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[7,null,null,null,null,null,null,null,0.85,null,0.15,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(V9<>1,'Inputs, Part 1'!B10>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[8,null,null,null,null,null,null,null,0.8,null,0.2,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(V10<>1,'Inputs, Part 1'!B11>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[9,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(V11<>1,'Inputs, Part 1'!B12>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[10,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(AND(V12<>1,'Inputs, Part 1'!B13>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V13<>1,'Inputs, Part 1'!B14>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V14<>1,'Inputs, Part 1'!B15>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V15<>1,'Inputs, Part 1'!B16>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V16<>1,'Inputs, Part 1'!B17>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V17<>1,'Inputs, Part 1'!B18>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V18<>1,'Inputs, Part 1'!B19>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V19<>1,'Inputs, Part 1'!B20>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V20<>1,'Inputs, Part 1'!B21>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V21<>1,'Inputs, Part 1'!B22>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(AND(V22<>1,'Inputs, Part 1'!B23>0,'Inputs, Part 1'!$AE$6=3),\"WARNING: The probabilities for a party size of X should sum to 1.0\",\"\")","v":""}]

{"sheet":"Discount Calculation","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,2],[1,3,1,4],[7,0,7,1],[8,0,8,3]]}
["To calculate the Net Discount Percentage, provide the revenue (and cost) information for a typical party."]
[null,"Full-Fare (Original)",null,"With the Special"]
[null,"Revenue","Variable Cost","Revenue","Variable Cost"]
["Food",50,33.33,37.5,33.33]
["Beverage",50,16.670000000000002,50,16.670000000000002]
["Other"]
["Total",{"$f":"SUM(B4:B6)","v":100},{"$f":"SUM(C4:C6)","v":50},{"$f":"SUM(D4:D6)","v":87.5},{"$f":"SUM(E4:E6)","v":50}]
["Contribution",null,{"$f":"B7-C7","v":50},null,{"$f":"D7-E7","v":37.5}]
["Net Discount Percentage",null,null,null,{"$f":"100-E8/C8*100","v":25}]

{"sheet":"Results","index":6,"n_rows":25,"n_cols":255,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,1,0,6],[23,10,23,13],[24,10,24,13],[0,24,0,26],[0,28,0,30],[0,15,0,22],[23,18,23,21],[24,18,24,21],[0,7,0,14]]}
[null,"Status Quo",null,null,null,null,null,"With Special",null,null,null,null,null,null,null,"With Special and Adjusted Demand Levels",null,null,null,null,null,null,null,null,"With Estimated Demand",null,null,null,"For a Target Net Value"]
["Party Size","Number Parties Served","Number Parties Lost","Avg Wait (min)","Avg Daily Longest Wait","Daily Value Lost","Daily Value Served","Number Full-Fare Parties Served","Number Discount Parties Served","Number Full-Fare Parties Lost","Number Discount Parties Lost","Avg Wait (min)","Avg Daily Longest Wait","Daily Value Lost","Daily Value Served","Number Full-Fare Parties Served","Number Discount Parties Served","Number Full-Fare Parties Lost","Number Discount Parties Lost","Avg Wait (min)","Avg Daily Longest Wait","Daily Value Lost","Daily Value Served",null,"Customer Volume Level","Estimated Value","Actual Value",null,"Number of Parties Wanting the Special","Target Value","Actual Value"]
["All",34.65,4.41,12.410618782043457,"NA",{"$f":"SUMPRODUCT(C4:C23,'Inputs, Part 1'!D4:D23)","v":232.8},{"$f":"SUMPRODUCT(B4:B23,'Inputs, Part 1'!D4:D23)","v":1290.8999999999999},32.546999999999997,6.2190000000000003,5.9829999999999997,0.375,16.537513732910156,"NA",{"$f":"SUM(N4:N23)","v":327.62750000000005},{"$f":"SUM(O4:O23)","v":1374.1575},29.321000000000002,13.342000000000001,9.6010000000000009,7.0330000000000004,26.443986892700195,"NA",{"$f":"SUM(V4:V23)","v":682.15250000000003},{"$f":"SUM(W4:W23)","v":1437.6425000000004},null,1,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},115.23750305175781,null,7,{"$f":"TargetNetValue","v":100},83.257499694824219,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[1,3.05,0.16,3.1670474193135245,16.509985351562499,{"$f":"C4*'Inputs, Part 1'!D4","v":1.6},{"$f":"B4*'Inputs, Part 1'!D4","v":30.5},2.9279999999999999,0.5,0.129,1.4E-2,3.7920845740479852,15.321632631363407,{"$f":"'Inputs, Part 1'!$D4*(J4+K4*(100-DiscountPercent)/100)","v":1.395},{"$f":"'Inputs, Part 1'!$D4*(Results!H4+Results!I4*(100-DiscountPercent)/100)","v":33.03},2.5710000000000002,1.1519999999999999,0.439,0.52600000000000002,8.2805814858031894,19.347142640039625,{"$f":"'Inputs, Part 1'!$D4*(R4+S4*(100-DiscountPercent)/100)","v":8.3350000000000009},{"$f":"'Inputs, Part 1'!$D4*(Results!P4+Results!Q4*(100-DiscountPercent)/100)","v":34.35},null,1.1000000000000001,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},115.22250366210937,null,7.699999988079071,100,91.735000610351563]
[2,9.7799999999999994,0.17,3.6844237781984917,20.965409536210316,{"$f":"C5*'Inputs, Part 1'!D5","v":3.4000000000000004},{"$f":"B5*'Inputs, Part 1'!D5","v":195.6},9.3670000000000009,1.6279999999999999,0.20599999999999999,1.9E-2,4.5920998418650578,20.159045876564559,{"$f":"'Inputs, Part 1'!D5*(J5+K5*(100-DiscountPercent)/100)","v":4.4050000000000002},{"$f":"'Inputs, Part 1'!$D5*(Results!H5+Results!I5*(100-DiscountPercent)/100)","v":211.76000000000002},8.9939999999999998,3.931,0.63600000000000001,1.1120000000000001,11.684999200856126,28.805504334886127,{"$f":"'Inputs, Part 1'!$D5*(R5+S5*(100-DiscountPercent)/100)","v":29.400000000000006},{"$f":"'Inputs, Part 1'!$D5*(Results!P5+Results!Q5*(100-DiscountPercent)/100)","v":238.845},null,1.2,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},133.08250427246094,null,8.3999999761581421,100,98.792503356933594]
[3,3.77,0.4,9.1021938981681032,24.398051201542721,{"$f":"C6*'Inputs, Part 1'!D6","v":12},{"$f":"B6*'Inputs, Part 1'!D6","v":113.1},3.609,0.67200000000000004,0.65800000000000003,4.2999999999999997E-2,13.278829835134387,27.831115794716649,{"$f":"'Inputs, Part 1'!D6*(J6+K6*(100-DiscountPercent)/100)","v":20.7075},{"$f":"'Inputs, Part 1'!$D6*(Results!H6+Results!I6*(100-DiscountPercent)/100)","v":123.38999999999999},3.0369999999999999,1.2909999999999999,1.3089999999999999,1,20.204024067747778,31.06224086828399,{"$f":"'Inputs, Part 1'!$D6*(R6+S6*(100-DiscountPercent)/100)","v":61.77},{"$f":"'Inputs, Part 1'!$D6*(Results!P6+Results!Q6*(100-DiscountPercent)/100)","v":120.1575},null,1.3,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},133.63250732421875,null,9.0999999642372131,100,100.17749786376953]
[4,6.67,0.56000000000000005,10.77829249437781,32.159426700367646,{"$f":"C7*'Inputs, Part 1'!D7","v":22.400000000000002},{"$f":"B7*'Inputs, Part 1'!D7","v":266.8},6.46,1.246,0.77400000000000002,3.3000000000000002E-2,15.58429639125387,34.138935194400212,{"$f":"'Inputs, Part 1'!D7*(J7+K7*(100-DiscountPercent)/100)","v":31.950000000000003},{"$f":"'Inputs, Part 1'!$D7*(Results!H7+Results!I7*(100-DiscountPercent)/100)","v":295.77999999999997},5.9960000000000004,2.601,1.538,1.2150000000000001,27.775063584056038,40.367530084425404,{"$f":"'Inputs, Part 1'!$D7*(R7+S7*(100-DiscountPercent)/100)","v":97.97},{"$f":"'Inputs, Part 1'!$D7*(Results!P7+Results!Q7*(100-DiscountPercent)/100)","v":317.87},null,1.4,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},132.9375,null,9.7999999523162842,100,109.72499847412109]
[5,4.55,1.42,19.483935010302197,40.12472601996528,{"$f":"C8*'Inputs, Part 1'!D8","v":71},{"$f":"B8*'Inputs, Part 1'!D8","v":227.5},4.1559999999999997,0.91300000000000003,2.052,0.13100000000000001,27.167329613811358,44.001578075813221,{"$f":"'Inputs, Part 1'!D8*(J8+K8*(100-DiscountPercent)/100)","v":107.51250000000002},{"$f":"'Inputs, Part 1'!$D8*(Results!H8+Results!I8*(100-DiscountPercent)/100)","v":242.03749999999999},3.42,1.573,2.75,1.6539999999999999,36.420917854532163,46.132660723415135,{"$f":"'Inputs, Part 1'!$D8*(R8+S8*(100-DiscountPercent)/100)","v":199.52500000000001},{"$f":"'Inputs, Part 1'!$D8*(Results!P8+Results!Q8*(100-DiscountPercent)/100)","v":229.98750000000001},null,1.5,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},139.04750061035156,null,10.499999940395355,100,112.34750366210937]
[6,3.86,0.66,23.493118523316063,44.295189642137096,{"$f":"C9*'Inputs, Part 1'!D9","v":39.6},{"$f":"B9*'Inputs, Part 1'!D9","v":231.6},3.4780000000000002,0.71699999999999997,0.81399999999999995,0.04,31.973925388154111,47.611565806878303,{"$f":"'Inputs, Part 1'!D9*(J9+K9*(100-DiscountPercent)/100)","v":50.64},{"$f":"'Inputs, Part 1'!$D9*(Results!H9+Results!I9*(100-DiscountPercent)/100)","v":240.94500000000005},3.1269999999999998,1.5489999999999999,1.206,0.64600000000000002,49.311520626798846,53.098139089412363,{"$f":"'Inputs, Part 1'!$D9*(R9+S9*(100-DiscountPercent)/100)","v":101.43},{"$f":"'Inputs, Part 1'!$D9*(Results!P9+Results!Q9*(100-DiscountPercent)/100)","v":257.32500000000005},null,1.6,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},143.35749816894531,null,11.199999928474426,100,122.85250091552734]
[7,1.89,0.54,31.308702256944443,55.305878906250001,{"$f":"C10*'Inputs, Part 1'!D10","v":37.800000000000004},{"$f":"B10*'Inputs, Part 1'!D10","v":132.29999999999998},1.538,0.32200000000000001,0.81799999999999995,5.2999999999999999E-2,40.117852501624434,52.604609272068508,{"$f":"'Inputs, Part 1'!D10*(J10+K10*(100-DiscountPercent)/100)","v":60.04249999999999},{"$f":"'Inputs, Part 1'!$D10*(Results!H10+Results!I10*(100-DiscountPercent)/100)","v":124.56500000000001},1.29,0.71599999999999997,1.0640000000000001,0.57099999999999995,58.315552325581393,55.915474043287325,{"$f":"'Inputs, Part 1'!$D10*(R10+S10*(100-DiscountPercent)/100)","v":104.45750000000001},{"$f":"'Inputs, Part 1'!$D10*(Results!P10+Results!Q10*(100-DiscountPercent)/100)","v":127.89},null,1.7,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},156.21000671386719,null,11.899999916553497,100,116.97750091552734]
[8,0.6,0.16,35.347896321614584,51.764544318704047,{"$f":"C11*'Inputs, Part 1'!D11","v":12.8},{"$f":"B11*'Inputs, Part 1'!D11","v":48},0.54200000000000004,9.8000000000000004E-2,0.16800000000000001,7.0000000000000001E-3,45.787120185654985,53.477724485759495,{"$f":"'Inputs, Part 1'!D11*(J11+K11*(100-DiscountPercent)/100)","v":13.860000000000001},{"$f":"'Inputs, Part 1'!$D11*(Results!H11+Results!I11*(100-DiscountPercent)/100)","v":49.24},0.499,0.308,0.25,0.128,72.477392284569135,57.99014325557809,{"$f":"'Inputs, Part 1'!$D11*(R11+S11*(100-DiscountPercent)/100)","v":27.68},{"$f":"'Inputs, Part 1'!$D11*(Results!P11+Results!Q11*(100-DiscountPercent)/100)","v":58.4},null,1.8,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},149.1824951171875,null,12.599999904632568,100,121.26000213623047]
[9,0.25,0.18,30.80744140625,51.207127162388396,{"$f":"C12*'Inputs, Part 1'!D12","v":16.2},{"$f":"B12*'Inputs, Part 1'!D12","v":22.5},0.222,6.6000000000000003E-2,0.17599999999999999,0.02,51.183168967208523,59.799378453038671,{"$f":"'Inputs, Part 1'!D12*(J12+K12*(100-DiscountPercent)/100)","v":17.190000000000001},{"$f":"'Inputs, Part 1'!$D12*(Results!H12+Results!I12*(100-DiscountPercent)/100)","v":24.435000000000002},0.17,0.10100000000000001,0.214,0.1,74.281843932748544,62.488794700386599,{"$f":"'Inputs, Part 1'!$D12*(R12+S12*(100-DiscountPercent)/100)","v":26.009999999999998},{"$f":"'Inputs, Part 1'!$D12*(Results!P12+Results!Q12*(100-DiscountPercent)/100)","v":22.117500000000003},null,1.9,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},147.58500671386719,null,13.299999892711639,100,125.49500274658203]
[10,0.23,0.16,46.560254967730977,56.362413908305918,{"$f":"C13*'Inputs, Part 1'!D13","v":16},{"$f":"B13*'Inputs, Part 1'!D13","v":23},0.247,5.7000000000000002E-2,0.188,1.4999999999999999E-2,54.573633603238868,60.818687981338861,{"$f":"'Inputs, Part 1'!D13*(J13+K13*(100-DiscountPercent)/100)","v":19.925000000000001},{"$f":"'Inputs, Part 1'!$D13*(Results!H13+Results!I13*(100-DiscountPercent)/100)","v":28.975000000000001},0.217,0.12,0.19500000000000001,8.1000000000000003E-2,83.860978712729363,67.443822957198449,{"$f":"'Inputs, Part 1'!$D13*(R13+S13*(100-DiscountPercent)/100)","v":25.575000000000003},{"$f":"'Inputs, Part 1'!$D13*(Results!P13+Results!Q13*(100-DiscountPercent)/100)","v":30.7},null,2,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},151.48249816894531,null,13.99999988079071,100,135.47250366210937]
[11,null,null,null,null,{"$f":"C14*'Inputs, Part 1'!D14","v":0},{"$f":"B14*'Inputs, Part 1'!D14","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D14*(J14+K14*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D14*(Results!H14+Results!I14*(100-DiscountPercent)/100)","v":0},0,0,9.1999999999999998E-2,0.13200000000000001,"NA","NA",{"$f":"'Inputs, Part 1'!$D14*(R14+S14*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D14*(Results!P14+Results!Q14*(100-DiscountPercent)/100)","v":0},null,2.1,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},160.77250671386719,null,14.699999868869781,100,132.58000183105469]
[12,null,null,null,null,{"$f":"C15*'Inputs, Part 1'!D15","v":0},{"$f":"B15*'Inputs, Part 1'!D15","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D15*(J15+K15*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D15*(Results!H15+Results!I15*(100-DiscountPercent)/100)","v":0},0,0,0.17699999999999999,0.13200000000000001,"NA","NA",{"$f":"'Inputs, Part 1'!$D15*(R15+S15*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D15*(Results!P15+Results!Q15*(100-DiscountPercent)/100)","v":0},null,2.2000000000000002,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},154.14750671386719,null,15.399999856948853,100,135.55000305175781]
[13,null,null,null,null,{"$f":"C16*'Inputs, Part 1'!D16","v":0},{"$f":"B16*'Inputs, Part 1'!D16","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D16*(J16+K16*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D16*(Results!H16+Results!I16*(100-DiscountPercent)/100)","v":0},0,0,0.13400000000000001,6.6000000000000003E-2,"NA","NA",{"$f":"'Inputs, Part 1'!$D16*(R16+S16*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D16*(Results!P16+Results!Q16*(100-DiscountPercent)/100)","v":0},null,2.2999999999999998,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},163.60249328613281,null,16.099999845027924,100,131.03500366210937]
[14,null,null,null,null,{"$f":"C17*'Inputs, Part 1'!D17","v":0},{"$f":"B17*'Inputs, Part 1'!D17","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D17*(J17+K17*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D17*(Results!H17+Results!I17*(100-DiscountPercent)/100)","v":0},0,0,2.5000000000000001E-2,1.4E-2,"NA","NA",{"$f":"'Inputs, Part 1'!$D17*(R17+S17*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D17*(Results!P17+Results!Q17*(100-DiscountPercent)/100)","v":0},null,2.4,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},164.20750427246094,null,16.799999833106995,100,140.36000061035156]
[15,null,null,null,null,{"$f":"C18*'Inputs, Part 1'!D18","v":0},{"$f":"B18*'Inputs, Part 1'!D18","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D18*(J18+K18*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D18*(Results!H18+Results!I18*(100-DiscountPercent)/100)","v":0},0,0,2.8000000000000001E-2,1.9E-2,"NA","NA",{"$f":"'Inputs, Part 1'!$D18*(R18+S18*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D18*(Results!P18+Results!Q18*(100-DiscountPercent)/100)","v":0},null,2.5,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},167.92500305175781,null,17.499999821186066,100,141.45750427246094]
[16,null,null,null,null,{"$f":"C19*'Inputs, Part 1'!D19","v":0},{"$f":"B19*'Inputs, Part 1'!D19","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D19*(J19+K19*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D19*(Results!H19+Results!I19*(100-DiscountPercent)/100)","v":0},0,0,1.0999999999999999E-2,5.0000000000000001E-3,"NA","NA",{"$f":"'Inputs, Part 1'!$D19*(R19+S19*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D19*(Results!P19+Results!Q19*(100-DiscountPercent)/100)","v":0},null,2.6,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},169.45750427246094,null,18.199999809265137,100,143.35000610351562]
[17,null,null,null,null,{"$f":"C20*'Inputs, Part 1'!D20","v":0},{"$f":"B20*'Inputs, Part 1'!D20","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D20*(J20+K20*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D20*(Results!H20+Results!I20*(100-DiscountPercent)/100)","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!$D20*(R20+S20*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D20*(Results!P20+Results!Q20*(100-DiscountPercent)/100)","v":0},null,2.7,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},171.32000732421875,null,18.899999797344208,100,137.56500244140625]
[18,null,null,null,null,{"$f":"C21*'Inputs, Part 1'!D21","v":0},{"$f":"B21*'Inputs, Part 1'!D21","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D21*(J21+K21*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D21*(Results!H21+Results!I21*(100-DiscountPercent)/100)","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!$D21*(R21+S21*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D21*(Results!P21+Results!Q21*(100-DiscountPercent)/100)","v":0},null,2.8,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},167.19000244140625,null,19.599999785423279,100,140.52749633789062]
[19,null,null,null,null,{"$f":"C22*'Inputs, Part 1'!D22","v":0},{"$f":"B22*'Inputs, Part 1'!D22","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D22*(J22+K22*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D22*(Results!H22+Results!I22*(100-DiscountPercent)/100)","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!$D22*(R22+S22*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D22*(Results!P22+Results!Q22*(100-DiscountPercent)/100)","v":0},null,2.9,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},175.73750305175781,null,20.29999977350235,100,145.30999755859375]
[20,null,null,null,null,{"$f":"C23*'Inputs, Part 1'!D23","v":0},{"$f":"B23*'Inputs, Part 1'!D23","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!D23*(J23+K23*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D23*(Results!H23+Results!I23*(100-DiscountPercent)/100)","v":0},null,null,null,null,null,null,{"$f":"'Inputs, Part 1'!$D23*(R23+S23*(100-DiscountPercent)/100)","v":0},{"$f":"'Inputs, Part 1'!$D23*(Results!P23+Results!Q23*(100-DiscountPercent)/100)","v":0},null,3,{"$f":"'Inputs, Part 1'!$AA$25","v":168.1875},174.58000183105469,null,20.999999761581421,100,146.74249267578125]
[null,null,null,null,null,null,null,null,null,null,"Net Daily Value of the Special",null,null,null,{"$f":"O3-$G3","v":83.257500000000164},null,null,null,"Net Daily Value of the Special",null,null,null,{"$f":"W3-$G3","v":146.74250000000052}]
[null,null,null,null,null,null,null,null,null,null,"% of Simple Estimate",null,null,null,{"$f":"IF('Inputs, Part 1'!$AA25>0,O24/'Inputs, Part 1'!$AA25,\"n/a\")","v":0.49502787068004556},null,null,null,"% of Simple Estimate",null,null,null,{"$f":"W24/'Inputs, Part 1'!$AA25","v":0.87249349684132604}]

{"sheet":"Recommended Table Mix","index":9,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Table Size (Seats)","Recommended Number of Tables"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]