{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["User Form","Batch Input","Batch Output"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":60,"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":"User Form","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[20,0,20,2],[2,0,2,4]]}
["Student Name:",null,null,null,"Section:"]
[]
["Olympus Tours"]
[]
["Inputs"]
["Customer Name","N"]
["Date of Tour","D",null,"Date"]
[]
["Number of People ","P",null,"Integer"]
["Number of Hours ","H",null,"Single"]
[]
["Outputs"]
["Number of Small Busses","NS",null,"Integer"]
["Number of Large Busses","NL",null,"Integer"]
["Base Price","BP",null,"Currency"]
["Overtime Hours","OH",null,"Single"]
["Overtime Charge","OC",null,"Currency"]
["Total Price","TP ",null,"Currency"]
[]
[]
["Setup"]
["Per-person Base Rate","PPBR",null,"Currency"]
["Extra Hourly Percent","EHP",null,"Single"]
[]
[]
["Reminders"]
["Do NOT add any columns or rows to the spreadsheet. "]
["Do not use any cells outside of the cells already specified."]
["Use VBA to do all calculations."]

{"sheet":"Batch Input","index":1,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Davis Schools","2017-01-05"]
[61]
[6]
[]
[]
["Willie Wrestling","2017-01-06"]
[20]
[4]
[]
["Dahle Reunion","2017-01-06"]
[55]
[7]
[]
[]
[]
["Stanfield Group","2017-01-07"]
[120]
[10]
[]
["Marriott Hotels","2017-01-09"]
[50]
[6]
[]
["Samuel Young","2017-01-09"]
[35]
[4]
[]
["James Gaskin","2017-01-10"]
[65]
[8]
[]
["Will Treaty","2017-01-12"]
[115]
[6]
[]
["Stardust Socials","2017-01-13"]
[50]
[6]
[]
[]
[]
["Beth Putnam","2017-01-14"]
[120]
[6]
[]
["James Black","2017-01-17"]
[60]
[10]
[]
["Neman Finder","2017-01-17"]
[100]
[7]
[]
["Mark Keith","2017-01-17"]
[22]
[5]

{"sheet":"Batch Output","index":2,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Customer","Date","People","Hours","PPBR","EHP","NS","NL","BP","OH","OC","TP"]