{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Start Sheet","Task_1","Task_2","Task_3","Task_4","Task_5","Task_6","Task_7","Task_8","Task_9","Task_10","Task_11","Task_12","Task_13","Task_14","Task_15","Times","End"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":34,"comments":0,"pivot_tables":1},"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":"Start Sheet","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Task_1","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,87.564800000000005]

{"sheet":"Task_2","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,20]
[null,null,null,null,null,19]
[null,null,null,null,null,17]
[null,null,null,null,null,21]
[null,null,null,null,null,15]

{"sheet":"Task_3","index":3,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,19]
[null,null,null,null,null,18]
[null,null,null,null,null,16]
[null,null,null,null,null,19]
[null,null,null,null,null,17]

{"sheet":"Task_4","index":4,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Name","Age","Sex"]
[null,null,null,null,null,"Sally",35,"F"]
[null,null,null,null,null,"Jim",45,"M"]
[null,null,null,null,null,"Sue",21,"F"]
[null,null,null,null,null,"Shannon",37,"F"]
[null,null,null,null,null,"Dion",28,"M"]
[null,null,null,null,null,"Mike",60,"M"]
[]
[null,null,null,null,null,null,"Males"]

{"sheet":"Task_5","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Subject Code","Prefix"]
[null,null,null,"FUN101"]

{"sheet":"Task_6","index":6,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Discount",0.1]
[null,null,null,null,null,null,"Amount","Discount Amount"]
[null,null,null,null,null,null,5.5]
[null,null,null,null,null,null,10]
[null,null,null,null,null,null,15]
[null,null,null,null,null,null,20]

{"sheet":"Task_7","index":7,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Month","Salesperson","Region","Product","# Customers","Net Sales",null,"Sum of # Customers","Column Labels"]
["Jan","Jo","North","Widget",13,1726,null,"Row Labels","Jan","March","Feb","May","Grand Total"]
["Jan","Sam","North","Gizmo",5,1645,null,"North",18,9,null,null,27]
["Feb","fred","West","Widget",7,1732,null,"South",null,null,null,2,2]
["March","Jo","North","Phiget",9,1261,null,"West",null,null,7,null,7]
["May","Fred","South","Thingy",2,1601,null,"Grand Total",18,9,7,2,36]

{"sheet":"Task_8","index":8,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[null,null,null,null,null,"Amount","Discount Rate"]
[null,null,null,null,null,500]
[null,null,null,null,null,100]
[null,null,null,null,null,1500]
[null,null,null,null,null,200]

{"sheet":"Task_9","index":9,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[]
[null,null,null,null,null,"GST amount",0.15]

{"sheet":"Task_10","index":10,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[null,null,null,null,null,"Month","Sales"]
[null,null,null,null,null,"Jan",10000]
[null,null,null,null,null,"Feb",8200]
[null,null,null,null,null,"Mar",15000]

{"sheet":"Task_11","index":11,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[]
[null,null,"Product","Code","Quantity"]
[null,null,"Widget",101,10000]
[null,null,"Gizmo",201,8700]
[null,null,"Phiget",301,4600]

{"sheet":"Task_12","index":12,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[]
[null,null,null,null,"Last_Name","First_Name","Height (Cms)","Weight(Kgs)"]
[null,null,null,null,"Smith","Anna",176,86]
[null,null,null,null,"Anderson","Arty",186,80]
[null,null,null,null,"Philla","Polly",169,63]
[null,null,null,null,"Anderson","Pandy",186,76]
[null,null,null,null,"Smith","Harriet",174,50]
[null,null,null,null,"O'Dore","Patty",197,55]

{"sheet":"Task_13","index":13,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Name","Age","AgeGroup",null,null,null,"Lowest Age in each group","Age Groups"]
[null,null,null,"Sally",35,null,null,null,null,20,"Junior"]
[null,null,null,"Jim",45,null,null,null,null,30,"Intermediate"]
[null,null,null,"Harry",47,null,null,null,null,40,"Mature"]
[null,null,null,"Sue",21,null,null,null,null,45,"Masters"]
[null,null,null,"Shannon",37,null,null,null,null,50,"Senior"]
[null,null,null,"Dion",20]
[null,null,null,"Mike",60]

{"sheet":"Task_14","index":14,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
[null,null,null,null,"LastName","First_Name","Sex","Age"]
[null,null,null,null,"Jones","Harvey","M",80]
[null,null,null,null,"O'Dore","Patty","F",55]
[null,null,null,null,"Philla","Polly","F",22]
[null,null,null,null,"Smith","Harriet","F",26]
[null,null,null,null,"Smith","Harry","M",86]

{"sheet":"Task_15","index":15,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[" "]

{"sheet":"Times","index":16,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,"Task_1","Task_2","Task_3","Task_4","Task_5","Task_6","Task_7","Task_8","Task_9","Task_10","Task_11","Task_12","Task_13","Task_14","Task_15","Total"]
["Start"]
["Stop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,41118.744050925925]
["Total",{"$f":"IF(ISBLANK(B2),\"Skipped\",B3-B2)","v":"Skipped"},{"$f":"IF(ISBLANK(C2),\"Skipped\",C3-C2)","v":"Skipped"},"Skipped","Skipped","Skipped","Skipped","Skipped","Skipped","Skipped","Skipped","Skipped","Skipped","Skipped","Skipped","Skipped",{"$f":"SUM(B4:P4)","v":0}]
["Time allowed",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Results",{"$f":"GetFormat(Task1)","v":"General"},{"$f":"GetFormula(Task2)","v":""},{"$f":"GetFormula(Task3)","v":""},{"$f":"GetFormula(Task4)","v":""},{"$f":"GetFormula(Task5)","v":""},{"$f":"GetFormula(Task6)","v":""},null,{"$f":"GetFormula(Task8)","v":""},{"$f":"IFERROR(NameExists(\"GST\"),\"False\")","v":"False"},{"$f":"IF(CountChart(Task10)> 0,\"Chart Created\",\"NO Chart\")","v":"NO Chart"},{"$f":"IF(CountChart(Task11)>0,\"Chart Created\",\"No Chart\")","v":"No Chart"},{"$f":"IF(AND(T12_1=\"Anderson\",T12_2= \"Pandy\",T12_3=186,T12_4=76),\"CORRECT\",\"INCORRECT\")","v":"INCORRECT"},{"$f":"GetFormula(Task13)","v":""},{"$f":"IsFiltered(Task14)","v":false},{"$f":"HasValidation(T_15)","v":true}]
[null,null,null,null,null,null,{"$f":"GetFormula(Task6)","v":""},null,null,null,{"$f":"CountChart(Task10)","v":0},{"$f":"CountChart(Task11)","v":0},0]
[]
[]
[]
[]
[]
[null,{"$f":"#REF!+C5+#REF!+E5+F5+G5+H5+I5+J5+K5+L5+M5+N5+O5+P5+#REF!+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},null,{"$f":"Findcolor(Task3)","v":-4142}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Expert Avg","00:00:15.700","00:00:20.800","00:00:26.300","00:00:46.800","00:01:03.900","00:01:01.800","00:01:05.600","00:01:02.900","00:00:24.900","00:00:54.600","00:02:42.900","00:01:03.100","00:01:41.200","00:01:05.600","00:01:06.500"]
[]
["Total Time",{"$f":"SUM(B4:P4)","v":0}]

{"sheet":"End","index":17,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}