{"text_format":"1","workbook":"xls","n_sheets":1,"sheets":["Tips Calculator"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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","formulas":"cached_only"}

{"sheet":"Tips Calculator","index":0,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":false,"merged":[[13,1,13,2],[22,4,22,5],[22,1,22,2],[0,1,0,4],[1,1,1,5],[20,1,20,11],[11,1,11,8],[2,1,2,5],[4,4,4,5],[13,7,13,8],[27,1,27,2],[41,10,41,11],[41,7,41,8],[41,4,41,5],[41,1,41,2],[55,1,55,2],[55,4,55,5],[55,10,55,11],[55,7,55,8],[27,10,27,11],[27,7,27,8],[27,4,27,5],[13,4,13,5]],"flags":["formulas_cached_only"]}
[null,"Tips Calculator"]
[null,"This workbook calculates tips based on meal cost before tax."]
[null,"One Person Paying"]
[]
[null,"Enter the following amounts",null,null,"Total"]
[null,"Meal cost before tax",16.27,null,"Meal",16.27]
[null,"Tip percentage",0.18,null,"Tax",1.43]
[null,"Tax on the meal",1.43,null,"Subtotal",17.7]
[null,null,null,null,"Tip",2.9286]
[null,null,null,null,"Total",20.6286]
[]
[null,"Splitting the Bill Evenly"]
[]
[null,"Enter the following amounts",null,null,"Total Before Splitting",null,null,"Total Per Person"]
[null,"Number of people",5,null,"Meal",67.29,null,"Meal",13.458000000000002]
[null,"Meal cost before tax",67.29,null,"Tax",5.92,null,"Tax",1.184]
[null,"Tip percentage",0.18,null,"Subtotal",73.21000000000001,null,"Subtotal",14.642000000000001]
[null,"Tax on the meal",5.92,null,"Tip",12.112200000000001,null,"Tip",2.4224400000000004]
[null,null,null,null,"Total",79.40220000000001,null,"Total",17.06444]
[]
[null,"Splitting the Bill by Person"]
[]
[null,"Enter the following amounts",null,null,"Total Before Splitting"]
[null,"Meal cost before tax",136.81,null,"Meal",136.81]
[null,"Tip percentage",0.15,null,"Tax",12.04]
[null,"Tax on the meal",12.04,null,"Subtotal w/o tip",148.85]
[]
[null,"Name",null,null,"Name",null,null,"Name",null,null,"Name"]
[null,"Tip %",0.15,null,"Tip %",0.15,null,"Tip %",0.15,null,"Tip %",0.15]
[null,"Item 1",14.3,null,"Item 1",null,null,"Item 1",null,null,"Item 1"]
[null,"Item 2",6.45,null,"Item 2",null,null,"Item 2",null,null,"Item 2"]
[null,"Item 3",2.85,null,"Item 3",null,null,"Item 3",null,null,"Item 3"]
[null,"Item 4",5.25,null,"Item 4",null,null,"Item 4",null,null,"Item 4"]
[null,"Item 5",0,null,"Item 5",null,null,"Item 5",null,null,"Item 5"]
[null,"Item 6",0,null,"Item 6",null,null,"Item 6",null,null,"Item 6"]
[null,"Item 7",0,null,"Item 7",null,null,"Item 7",null,null,"Item 7"]
[null,"Subtotal",28.85,null,"Subtotal",0,null,"Subtotal",0,null,"Subtotal",0]
[null,"Tax",2.5389518310065053,null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax"]
[null,"Tip",4.3275,null,"Tip",0,null,"Tip",0,null,"Tip",0]
[null,"Total",35.71645183100651,null,"Total",0,null,"Total",0,null,"Total",0]
[]
[null,"Name",null,null,"Name",null,null,"Name",null,null,"Name"]
[null,"Tip %",0.15,null,"Tip %",0.15,null,"Tip %",0.15,null,"Tip %",0.15]
[null,"Item 1",null,null,"Item 1",null,null,"Item 1",null,null,"Item 1"]
[null,"Item 2",null,null,"Item 2",null,null,"Item 2",null,null,"Item 2"]
[null,"Item 3",null,null,"Item 3",null,null,"Item 3",null,null,"Item 3"]
[null,"Item 4",null,null,"Item 4",null,null,"Item 4",null,null,"Item 4"]
[null,"Item 5",null,null,"Item 5",null,null,"Item 5",null,null,"Item 5"]
[null,"Item 6",null,null,"Item 6",null,null,"Item 6",null,null,"Item 6"]
[null,"Item 7",null,null,"Item 7",null,null,"Item 7",null,null,"Item 7"]
[null,"Subtotal",0,null,"Subtotal",0,null,"Subtotal",0,null,"Subtotal",0]
[null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax"]
[null,"Tip",0,null,"Tip",0,null,"Tip",0,null,"Tip",0]
[null,"Total",0,null,"Total",0,null,"Total",0,null,"Total",0]
[]
[null,"Name",null,null,"Name",null,null,"Name",null,null,"Name"]
[null,"Tip %",0.15,null,"Tip %",0.15,null,"Tip %",0.15,null,"Tip %",0.15]
[null,"Item 1",null,null,"Item 1",null,null,"Item 1",null,null,"Item 1"]
[null,"Item 2",null,null,"Item 2",null,null,"Item 2",null,null,"Item 2"]
[null,"Item 3",null,null,"Item 3",null,null,"Item 3",null,null,"Item 3"]
[null,"Item 4",null,null,"Item 4",null,null,"Item 4",null,null,"Item 4"]
[null,"Item 5",null,null,"Item 5",null,null,"Item 5",null,null,"Item 5"]
[null,"Item 6",null,null,"Item 6",null,null,"Item 6",null,null,"Item 6"]
[null,"Item 7",null,null,"Item 7",null,null,"Item 7",null,null,"Item 7"]
[null,"Subtotal",0,null,"Subtotal",0,null,"Subtotal",0,null,"Subtotal",0]
[null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax",null,"Tax","No subtotal to tax"]
[null,"Tip",0,null,"Tip",0,null,"Tip",0,null,"Tip",0]
[null,"Total",0,null,"Total",0,null,"Total",0,null,"Total",0]