{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Monday","Wensday","Friday","Statistics","Calculation","Updates"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"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"}

{"sheet":"Home","index":0,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,4,28,6],[20,8,28,10],[20,12,28,14]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(Monday!G21+Monday!P21=60,\"Sorry, full.\",\"Monday still has seats\")","v":"Monday still has seats"},null,null,null,{"$f":"IF(Wensday!F20+Wensday!P20=60, \"Sorry, Full.\", \"Wensday still have seats\")","v":"Wensday still have seats"},null,null,null,{"$f":"IF(Friday!F20+Friday!P20=60, \"Sorry, Full.\", \"Friday still have seats\")","v":"Friday still have seats"}]

{"sheet":"Monday","index":1,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,4,14,6],[18,13,18,14],[20,4,20,5],[20,13,20,14],[19,13,19,14],[19,4,19,5],[22,4,22,5],[21,4,21,5],[21,13,21,14],[22,13,22,14],[1,8,1,11],[17,4,17,5],[18,4,18,5],[9,12,9,14],[0,0,1,7],[14,13,14,15],[15,13,15,14],[16,13,16,14],[9,2,9,4],[15,4,15,5],[16,4,16,5],[17,13,17,14]]}
["Monday Sessions"]
[]
[]
[null,null,"Free","Free","Free","Free","Free","Free",null,null,null,null,"Adult","Adult","Adult","Adult","Adult","Adult"]
[null,null,"Free","Special","Special","Special","Special","Free",null,null,null,null,"Adult","Adult","Adult","Adult","Adult","Adult"]
[null,null,"Free","Special","Special","Special","Special","Free",null,null,null,null,"Adult","Adult","Adult","Adult","Adult","Adult"]
[null,null,"Free","Special","Special","Special","Special","Free",null,null,null,null,"Adult","Adult","Adult","Adult","Adult","Adult"]
[null,null,"Free","Free","Free","Free","Free","Free",null,null,null,null,"Adult","Adult","Adult","Adult","Adult","Adult"]
[]
[null,null,"Morning Class",null,null,null,null,null,null,null,null,null,"Evening Class"]
[]
[]
[]
[]
[null,null,null,null,"Morning Class",null,null,null,null,null,null,null,null,"Evening Class"]
[null,null,null,null,"Amount of total seats",null,30,null,null,null,null,null,null,"Amount of total seats",null,30]
[null,null,null,null,"Free",null,{"$f":"COUNTIF(monday_morn,\"Free\")","v":18},null,null,null,null,null,null,"Free",null,{"$f":"COUNTIF(Mon_even,\"Free\")","v":0}]
[null,null,null,null,"Student",null,{"$f":"COUNTIF(monday_morn,\"Student\")","v":0},null,null,null,null,null,null,"Student",null,{"$f":"COUNTIF(Mon_even,\"Student\")","v":0}]
[null,null,null,null,"Adults",null,{"$f":"COUNTIF(monday_morn,\"Adult\")","v":0},null,null,null,null,null,null,"Adults",null,{"$f":"COUNTIF(Mon_even,\"Adult\")","v":30}]
[null,null,null,null,"Discount",null,{"$f":"COUNTIF(monday_morn,\"Special\")","v":12},null,null,null,null,null,null,"Discount",null,{"$f":"COUNTIF(Mon_even,\"Special\")","v":0}]
[null,null,null,null,"Total Attending",null,{"$f":"SUM(G18:G20)","v":12},null,null,null,null,null,null,"Total Attending",null,{"$f":"SUM(P18:P20)","v":30}]
[null,null,null,null,"Percentage ",null,{"$f":"G21/30","v":0.4},null,null,null,null,null,null,"Percentage",null,{"$f":"P21/30","v":1}]
[null,null,null,null,"Class Complete?",null,{"$f":"IF(G22>=60%,\"Class Complete\",\"Class Denied\")","v":"Class Denied"},null,null,null,null,null,null,"Class Complete?",null,{"$f":"IF(P22>=60%,\"Class Complete\",\"Class Denied\")","v":"Class Complete"}]

{"sheet":"Wensday","index":2,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,12,15,14],[16,12,16,14],[17,12,17,14],[18,12,18,14],[9,2,9,4],[9,12,9,14],[0,0,1,7],[14,2,14,4],[13,12,13,15],[14,12,14,14],[15,2,15,4],[16,2,16,4],[17,2,17,4],[13,2,13,5],[18,2,18,4],[20,2,20,4],[21,2,21,4],[20,12,20,14],[21,12,21,14],[19,2,19,4],[19,12,19,14]]}
["Wednesday Sessions"]
[]
[]
[null,null,"Adult","Free","Free","Adult","Adult","Adult",null,null,null,null,"Free","Free","Free","Free","Adult","Adult"]
[null,null,"Adult","Free","Free","Adult","Adult","Adult",null,null,null,null,"Free","Free","Free","Free","Adult","Adult"]
[null,null,"Adult","Free","Free","Adult","Adult","Adult",null,null,null,null,"Free","Free","Free","Free","Adult","Adult"]
[null,null,"Adult","Free","Free","Adult","Adult","Adult",null,null,null,null,"Free","Free","Free","Free","Adult","Adult"]
[null,null,"Adult","Free","Free","Adult","Adult","Adult",null,null,null,null,"Free","Free","Free","Free","Adult","Adult"]
[]
[null,null,"Morning Class",null,null,null,null,null,null,null,null,null,"Evening Class"]
[]
[]
[]
[null,null,"Morning Class",null,null,null,null,null,null,null,null,null,"Evening Class"]
[null,null,"Total Seats",null,null,30,null,null,null,null,null,null,"Total Seats",null,null,30]
[null,null,"Seats Free",null,null,{"$f":"COUNTIF(C4:H8,\"Free\")","v":10},null,null,null,null,null,null,"Seats Free",null,null,{"$f":"COUNTIF(M4:R8,\"Free\")","v":20}]
[null,null,"Adults",null,null,{"$f":"COUNTIF(C4:H8,\"Adult\")","v":20},null,null,null,null,null,null,"Adults",null,null,{"$f":"COUNTIF(M4:R8,\"Adult\")","v":10}]
[null,null,"Student",null,null,{"$f":"COUNTIF(C4:H8,\"Student\")","v":0},null,null,null,null,null,null,"Student",null,null,{"$f":"COUNTIF(M4:R8,\"Student\")","v":0}]
[null,null,"Discount",null,null,{"$f":"COUNTIF(C4:H8,\"Special\")","v":0},null,null,null,null,null,null,"Discount",null,null,{"$f":"COUNTIF(M4:R8,\"Special\")","v":0}]
[null,null,"Total Attending",null,null,{"$f":"SUM(F17:F19)","v":20},null,null,null,null,null,null,"Total Attending",null,null,{"$f":"SUM(P17:P19)","v":10}]
[null,null,"Percentage",null,null,{"$f":"F20/F15","v":0.66666666666666663},null,null,null,null,null,null,"Percentage",null,null,{"$f":"P20/P15","v":0.33333333333333331}]
[null,null,"Class? :3",null,null,{"$f":"IF(F21>=60%,\"Yes\",\"No\")","v":"Yes"},null,null,null,null,null,null,"Class? :3",null,null,{"$f":"IF(P21>=60%,\"Yes\",\"No\")","v":"No"}]

{"sheet":"Friday","index":3,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,2,9,4],[9,12,9,14],[0,0,1,7],[14,2,14,4],[13,2,13,5],[13,12,13,15],[14,12,14,14],[20,2,20,4],[21,2,21,4],[20,12,20,14],[21,12,21,14],[15,12,15,14],[16,12,16,14],[18,2,18,4],[18,12,18,14],[19,12,19,14],[19,2,19,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[17,12,17,14]]}
["Friday Sessions"]
[]
[]
[null,null,"Adult","Free","Free","Free","Free","Free",null,null,null,null,"Free","Free","Free","Free","Free","Free"]
[null,null,"Adult","Free","Free","Free","Free","Free",null,null,null,null,"Free","Free","Free","Free","Free","Free"]
[null,null,"Adult","Free","Free","Free","Free","Free",null,null,null,null,"Free","Free","Free","Adult","Free","Free"]
[null,null,"Adult","Student","Free","Free","Free","Free",null,null,null,null,"Free","Free","Free","Free","Free","Free"]
[null,null,"Adult","Free","Free","Free","Free","Free",null,null,null,null,"Free","Free","Free","Free","Free","Free"]
[]
[null,null,"Morning Class",null,null,null,null,null,null,null,null,null,"Evening Class"]
[]
[]
[]
[null,null,"Morning Class",null,null,null,null,null,null,null,null,null,"Evening Class"]
[null,null,"Total Seats",null,null,30,null,null,null,null,null,null,"Total Seats",null,null,30]
[null,null,"Seats Free",null,null,{"$f":"COUNTIF(C4:H8,\"Free\")","v":24},null,null,null,null,null,null,"Seats Free",null,null,{"$f":"COUNTIF(M4:R8,\"Free\")","v":29}]
[null,null,"Adult",null,null,{"$f":"COUNTIF(C4:H8,\"Adult\")","v":5},null,null,null,null,null,null,"Adult",null,null,{"$f":"COUNTIF(M4:R8,\"Adult\")","v":1}]
[null,null,"Student",null,null,{"$f":"COUNTIF(C4:H8,\"Student\")","v":1},null,null,null,null,null,null,"Student",null,null,{"$f":"COUNTIF(M4:R8,\"Student\")","v":0}]
[null,null,"Discount",null,null,{"$f":"COUNTIF(C4:H8,\"Special\")","v":0},null,null,null,null,null,null,"Discount",null,null,{"$f":"COUNTIF(M4:R8,\"Special\")","v":0}]
[null,null,"Total Attending",null,null,{"$f":"SUM(F17:F19)","v":6},null,null,null,null,null,null,"Total Attending",null,null,{"$f":"SUM(P17:P19)","v":1}]
[null,null,"Percentage",null,null,{"$f":"F20/F15","v":0.2},null,null,null,null,null,null,"Percentage",null,null,{"$f":"P20/P15","v":3.3333333333333333E-2}]
[null,null,"Class? :3",null,null,{"$f":"IF(F21>=60%,\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,"Class? :3",null,null,{"$f":"IF(P21>=60%,\"Yes\",\"No\")","v":"No"}]

{"sheet":"Statistics","index":4,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,18,7,20],[8,18,8,20],[9,18,9,20],[10,18,10,20],[7,12,7,14],[8,12,8,14],[9,12,9,14],[10,12,10,14],[5,15,5,17],[6,15,6,17],[7,15,7,17],[8,15,8,17],[9,15,9,17],[10,15,10,17],[4,12,4,14],[4,15,4,17],[4,18,4,20],[5,12,5,14],[6,12,6,14],[5,18,5,20],[6,18,6,20],[0,1,2,11],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[4,9,4,11],[15,1,15,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[8,1,8,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[9,6,9,8],[10,6,10,8],[5,9,5,11],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[10,9,10,11],[4,6,4,8],[5,6,5,8],[6,6,6,8],[7,6,7,8],[8,6,8,8]]}
["Student","UNSC Authorized Personels only"]
["Adult"]
["Special"]
["Free"]
[null,"Amount of People attending",null,null,null,null,null,null,null,"Total"]
[null,"Monday",null,null,{"$f":"Monday!G21+Monday!P21","v":42},null,"Wen Mor",null,null,{"$f":"Wensday!F20","v":20}]
[null,"Wensday",null,null,{"$f":"Wensday!F20+Wensday!P20","v":30},null,"Wen Even",null,null,{"$f":"Wensday!P20","v":10}]
[null,"Friday",null,null,{"$f":"Friday!F20+Friday!P20","v":7},null,"Monday Morning",null,null,{"$f":"Monday!G21","v":12}]
[null,"All",null,null,{"$f":"SUM(E6:E8)","v":79},null,"Monday Evening",null,null,{"$f":"Monday!P21","v":30}]
[null,null,null,null,null,null,"Fri Even",null,null,{"$f":"Friday!P20","v":1}]
[null,null,null,null,null,null,"Fir Morn",null,null,{"$f":"Friday!F20","v":6}]
[null,"Type people"]
[null,"Adult",null,null,{"$f":"Monday!G19+Monday!P19+Wensday!F17+Wensday!P17+Friday!F17+Friday!P17","v":66}]
[null,"Student",null,null,{"$f":"Monday!G18+Monday!P18+Wensday!F18+Wensday!P18+Friday!F18+Friday!P18","v":1}]
[null,"Special",null,null,{"$f":"Monday!G20+Monday!P20+Wensday!F19+Wensday!P19+Friday!F19+Friday!P19","v":12}]
[null,"Total",null,null,{"$f":"SUM(E13:E15)","v":79}]
[]
[]
[null,"Type Booking"]
[null,"Morning",null,null,{"$f":"Monday!G21+Wensday!F20+Friday!F20","v":38}]
[null,"Evening",null,null,{"$f":"Monday!P21+Wensday!P20+Friday!P20","v":41}]

{"sheet":"Calculation","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"Name of Service","Fixed Price",null,"Outputs","Output per Week"]
[null,"Hire Classroom (Per Week, must paid)",2400,null,"Always Paid",2400]
[null,"Cost teaching Material (Per Person)",20,null,"Others",{"$f":"C8+C5+(C4*3)","v":2240}]
[null,"Transport for Tutorb (Per Day)",60]
[null,"Advertising (Per Week)",480]
[]
[null,"Amount of person attending",{"$f":"Statistics!E9","v":79},null,"Total output",{"$f":"SUM(F2:F6)","v":4640}]
[null,"Amount of Cash needed for material",{"$f":"C7*C3","v":1580}]
[]
[null,"Ticket Price","Price",null,"Ticket Income","Input Per Week"]
[null,"Adult",180,null,"Adult",{"$f":"C11*Statistics!E13","v":11880}]
[null,"Student",120,null,"Student",{"$f":"C12*Statistics!E14","v":120}]
[null,"Special",100,null,"Special",{"$f":"C13*Statistics!E15","v":1200}]
[]
[null,null,null,null,"Total Income",{"$f":"SUM(F11:F14)","v":13200}]
[]
[]
[null,null,null,null,"Income before Ouput",{"$f":"F15","v":13200}]
[null,null,null,null,"Total Profit",{"$f":"F15-F7","v":8560}]

{"sheet":"Updates","index":6,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Today's Date"]
[{"$f":"TODAY()","v":"2008-11-27"},null,"Date","2008-11-25","2008-11-25","2008-11-25","2008-11-25"]
[null,null,"Amount Output",6660,6660,6660,3060]
[null,null,"Seats Booked",180,180,180,0]
[null,null,"Amount of Student",0,60,60,0]
[null,null,"Amount of Adult",180,60,60,0]
[null,null,"Amount of Special",0,60,60,0]
[null,null,"Amount Input",32400,24000,24000,0]
[null,null,"Profit",25740,17340,17340,-3060]