{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Tips Calculator"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Tips Calculator","index":0,"n_rows":294,"n_cols":11,"rows_kept":294,"cut":false,"hidden":false,"merged":[[4,3,5,4],[7,3,8,4],[10,3,11,4],[8,7,11,8],[9,9,11,9],[4,5,5,5],[9,10,11,10],[16,5,16,6],[16,7,16,8],[16,9,16,10],[4,7,7,8],[5,9,7,9],[5,10,7,10],[7,5,8,5],[10,5,11,5]]}
[]
[]
[]
[null,null,null,"*Enter Details into YELLOW boxes ONLY"]
[null,null,null,"Number of Clients",null,2,null,"Total Guideline Amount From Group",null,"From","To"]
[{"$nulls":9},{"$f":"SUM(J19:J23)","v":832},{"$f":"SUM(K19:K23)","v":1440}]
[{"$nulls":5},"*Max 10 Clients"]
[null,null,null,"Number of Days",null,8]
[{"$nulls":7},"Total Guideline Amount Per Person",null,"From","To"]
[{"$nulls":9},{"$f":"J6/F5","v":416},{"$f":"K6/F5","v":720}]
[null,null,null,"Specification",null,"VIP"]
[]
[{"$nulls":5},"*Use drop down menu"]
[]
[]
[]
[null,null,null,"Position","Number","Suggested Daily Tip",null,"Guideline Individual Tip",null,"Guidline Total Tip Per Role"]
[{"$nulls":5},"From","To","From","To","From","To"]
[null,null,null,"Head Guides",{"$f":"INDEX($F$265:$J$294,  MATCH($D$261, $C$265:$C$294, 0), MATCH($D19, $F$264:$J$264, 0))","v":1},20,30,{"$f":"F19*$F$8","v":160},{"$f":"G19*$F$8","v":240},{"$f":"H19*E19","v":160},{"$f":"I19*E19","v":240}]
[null,null,null,"Assistant Guides",{"$f":"INDEX($F$265:$J$294,  MATCH($D$261, $C$265:$C$294, 0), MATCH($D20, $F$264:$J$264, 0))","v":1},10,20,{"$f":"F20*$F$8","v":80},{"$f":"G20*$F$8","v":160},{"$f":"H20*E20","v":80},{"$f":"I20*E20","v":160}]
[null,null,null,"Cooks",1,10,20,80,160,80,160]
[null,null,null,"Camp Crew",1,10,20,80,160,80,160]
[null,null,null,"Porters",18,3,5,24,40,432,720]
{"$rows_empty":223}
[null,null,null,"Position List"]
[null,null,null,"Head Guides"]
[null,null,null,"Assistant Guides"]
[null,null,null,"Camp Crew"]
[null,null,null,"Cooks"]
[null,null,null,"Porters"]
[]
[null,null,null,"Specification List:"]
[null,null,null,"Standard"]
[null,null,null,"Luxury"]
[null,null,null,"VIP"]
[]
[]
[null,null,null,"Live Concat Ref:"]
[null,null,null,{"$f":"F11 & F5","v":"VIP2"}]
[]
[]
[null,null,"Concat Ref","Specification","Clients","Head Guides","Assistant Guides","Camp Crew","Cooks","Porters","Total Crew"]
[null,null,{"$f":"D265 & E265","v":"Standard1"},"Standard",1,1,0,1,1,9,{"$f":"SUM(F265:J265)","v":12}]
[null,null,{"$f":"D266 & E266","v":"Standard2"},"Standard",2,1,1,1,1,14,{"$f":"SUM(F266:J266)","v":18}]
[null,null,"Standard3","Standard",3,1,1,1,1,16,20]
[null,null,"Standard4","Standard",4,1,1,1,1,18,22]
[null,null,"Standard5","Standard",5,1,2,1,1,20,25]
[null,null,"Standard6","Standard",6,1,2,2,2,24,31]
[null,null,"Standard7","Standard",7,1,3,2,2,28,36]
[null,null,"Standard8","Standard",8,1,3,2,2,32,40]
[null,null,"Standard9","Standard",9,1,3,2,2,34,42]
[null,null,"Standard10","Standard",10,1,3,2,2,35,43]
[null,null,"Luxury1","Luxury",1,1,0,1,1,10,13]
[null,null,"Luxury2","Luxury",2,1,1,1,1,15,19]
[null,null,"Luxury3","Luxury",3,1,1,1,1,18,22]
[null,null,"Luxury4","Luxury",4,1,1,1,1,20,24]
[null,null,"Luxury5","Luxury",5,1,2,1,1,25,30]
[null,null,"Luxury6","Luxury",6,1,2,2,2,30,37]
[null,null,"Luxury7","Luxury",7,1,3,2,2,35,43]
[null,null,"Luxury8","Luxury",8,1,3,2,2,40,48]
[null,null,"Luxury9","Luxury",9,1,3,2,2,45,53]
[null,null,"Luxury10","Luxury",10,1,3,2,2,50,58]
[null,null,"VIP1","VIP",1,1,0,1,1,12,15]
[null,null,"VIP2","VIP",2,1,1,1,1,18,22]
[null,null,"VIP3","VIP",3,1,1,1,1,21,25]
[null,null,"VIP4","VIP",4,1,1,1,1,24,28]
[null,null,"VIP5","VIP",5,1,2,1,1,30,35]
[null,null,"VIP6","VIP",6,1,2,2,2,36,43]
[null,null,"VIP7","VIP",7,1,3,2,2,42,50]
[null,null,"VIP8","VIP",8,1,3,2,2,48,56]
[null,null,"VIP9","VIP",9,1,3,2,2,54,62]
[null,null,"VIP10","VIP",10,1,3,2,2,56,64]