{"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","Hans","Ommila"]
["Date of Tour","D","2021-02-21","Date"]
[]
["Number of People ","P",1030,"Integer"]
["Number of Hours ","H",100,"Single"]
[]
["Outputs"]
["Number of Small Busses","NS",10,"Integer"]
["Number of Large Busses","NL",15,"Integer"]
["Base Price","BP",14986.5,"Currency"]
["Overtime Hours","OH",24,"Single"]
["Overtime Charge","OC",7336.84,"Currency"]
["Total Price","TP ",22323.34,"Currency"]
[]
[]
["Setup"]
["Per-person Base Rate","PPBR",14.55,"Currency"]
["Extra Hourly Percent","EHP",0.25,"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":77,"n_cols":2,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Davis Schools","2017-01-05"]
[61]
[6]
[]
[]
["Willie Wrestling","2017-01-06"]
[78]
[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]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Jack Mamai","23/09/2022"]
[99]
[15]

{"sheet":"Batch Output","index":2,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Customer","Date","People","Hours","PPBR","EHP","NS","NL","BP","OH","OC","TP"]
["Davis Schools","2017-01-05",61,6,14.55,0.25,1,1,887.55,1,221.89,1109.44]
["Willie Wrestling","2017-01-06",78,4,14.55,0.25,1,1,1134.9000000000001,0,0,1134.9000000000001]
["Dahle Reunion","2017-01-06",55,7,14.55,0.25,0,1,800.25,2,400.13,1200.3800000000001]
["Stanfield Group","2017-01-07",120,10,14.55,0.25,0,2,1746,4,1746,3492]
["Marriott Hotels","2017-01-09",50,6,14.55,0.25,2,0,727.5,1,181.88,909.38]
["Samuel Young","2017-01-09",35,4,14.55,0.25,2,0,509.25,0,0,509.25]
["James Gaskin","2017-01-10",65,8,14.55,0.25,1,1,945.75,3,709.31,1655.06]
["Will Treaty","2017-01-12",115,6,14.55,0.25,0,2,1673.25,1,418.31,2091.56]
["Stardust Socials","2017-01-13",50,6,14.55,0.25,2,0,727.5,1,181.88,909.38]
["Beth Putnam","2017-01-14",120,6,14.55,0.25,0,2,1746,1,436.5,2182.5]
["James Black","2017-01-17",60,10,14.55,0.25,0,1,873,4,873,1746]
["Neman Finder","2017-01-17",100,7,14.55,0.25,0,2,1455,2,727.5,2182.5]
["Mark Keith","2017-01-17",22,5,14.55,0.25,1,0,320.10000000000002,0,0,320.10000000000002]
["Jack Mamai","2022-09-23",99,15,14.55,0.25,0,2,1440.45,4,1440.45,2880.9]