{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet1","Sheet2","Sheet3","Sheet4","Sheet5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Sheet1","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Date 1","2016-01-26",{"$f":"TEXT(B1,\"ddd\")","v":"Tue"},{"$f":"getformula(C1)","v":"<--  =TEXT(B1,\"ddd\")"},null,null,null,null,{"$f":"TODAY()","v":"2016-01-28"}]
["Date 2","2016-01-27",{"$f":"TEXT(B2,\"ddd\")","v":"Wed"},null,null,null,null,null,{"$f":"I1+3","v":"2016-01-31"}]
["Date 3","2016-01-28","Thu",null,null,{"$f":"TODAY()","v":"2016-01-28"},{"$f":"getformula(F3)","v":"<--  =TODAY()"},null,{"$f":"I2+3","v":"2016-02-03"}]
["Date 4","2016-01-29","Fri",null,null,"1983-08-20",null,null,"2016-02-06"]
["Date 5","2016-01-30","Sat",null,null,null,null,null,"2016-02-09"]
["Date 6","2016-01-31","Sun",null,"Days old",{"$f":"F3-F4","v":11849},{"$f":"getformula(F6)","v":"<--  =F3-F4"},null,"2016-02-12"]
["Date 7","2016-02-01","Mon",null,null,null,null,null,"2016-02-15"]
["Date 8","2016-02-02","Tue",null,null,null,null,null,"2016-02-18"]
["Date 9","2016-02-03","Wed",null,null,null,null,null,"2016-02-21"]
["Date 10","2016-02-04","Thu"]
[]
["No. of days",{"$f":"B10-B1","v":9},{"$f":"getformula(B12)","v":"<--  =B10-B1"}]

{"sheet":"Sheet2","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"NOW()","v":"2016-01-28T12:47:30.250"},{"$f":"getformula(A1)","v":"<--  =NOW()"},null,null,null,"date 1","1983-08-20"]
[{"$f":"WEEKDAY(A1)","v":5},{"$f":"getformula(A2)","v":"<--  =WEEKDAY(A1)"},null,null,null,"date 2",{"$f":"TODAY()","v":"2016-01-28"}]
[{"$f":"MONTH(A1)","v":1},"<--  =MONTH(A1)"]
[{"$f":"MONTH(NOW())","v":1},"<--  =MONTH(NOW())",null,null,null,null,{"$f":"DATEDIF(G1,G2,\"y\")","v":32},{"$f":"getformula(G4)","v":"<--  =DATEDIF(G1,G2,\"y\")"}]
[{"$f":"WEEKNUM(NOW())","v":5},"<--  =WEEKNUM(NOW())",null,null,null,null,{"$f":"DATEDIF(G1,G2,\"m\")","v":389},{"$f":"getformula(G5)","v":"<--  =DATEDIF(G1,G2,\"m\")"}]
[{"$f":"DAY(NOW())","v":28},"<--  =DAY(NOW())",null,null,null,null,{"$f":"DATEDIF(G1,G2,\"d\")","v":11849},"<--  =DATEDIF(G1,G2,\"d\")"]
[null,null,null,null,null,null,{"$f":"DATEDIF(G1,G2,\"ym\")","v":5},"<--  =DATEDIF(G1,G2,\"ym\")"]
[null,null,null,null,null,null,{"$f":"DATEDIF(G1,G2,\"md\")","v":8},"<--  =DATEDIF(G1,G2,\"md\")"]
[null,null,null,null,null,null,{"$f":"DATEDIF(G1,G2,\"yd\")","v":161},"<--  =DATEDIF(G1,G2,\"yd\")"]

{"sheet":"Sheet3","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[5]
[4,null,"Mean",{"$f":"AVERAGE(A1:A11)","v":4.2727272727272725},{"$f":"getformula(D2)","v":"<--  =AVERAGE(A1:A11)"}]
[2,null,"Median",{"$f":"MEDIAN(A1:A11)","v":4},{"$f":"getformula(D3)","v":"<--  =MEDIAN(A1:A11)"}]
[8,null,"Mode",{"$f":"MODE(A1:A11)","v":2},"<--  =MODE(A1:A11)"]
[7,null,"Max",{"$f":"MAX(A1:A11)","v":8},"<--  =MAX(A1:A11)"]
[4,null,"Min",{"$f":"MIN(A1:A11)","v":2},"<--  =MIN(A1:A11)"]
[6,null,"Var",{"$f":"_xlfn.VAR.S(A1:A11)","v":4.6181818181818191},"<--  =VAR.S(A1:A11)"]
[2,null,"St Dev",{"$f":"_xlfn.STDEV.S(A1:A11)","v":2.1489955370316194},"<--  =STDEV.S(A1:A11)"]
[2,null,"St Dev",{"$f":"SQRT(D7)","v":2.1489955370316194},"<--  =SQRT(D7)"]
[5]
[2]

{"sheet":"Sheet4","index":3,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[7,5,12,5],[5,7,5,10]]}
["X",6,null,null,"Row input cell (Data Table)",null,-5,{"$f":"G1+1","v":-4},{"$f":"H1+1","v":-3},-2,-1,0,1,2,3]
["Y",7,null,null,null,{"$f":"B4","v":13},2,3,4,5,6,7,8,9,10]
[]
["Z = (X+Y)",{"$f":"B1+B2","v":13},{"$f":"getformula(B4)","v":"<--  =B1+B2"}]
[null,null,null,null,null,null,null,{"$f":"getformula(G7)","v":"<--  =B4"}]
[null,null,null,null,"Column input cell (Data Table)",null,null,"Y"]
[null,"X",{"$f":"B4","v":13},{"$f":"getformula(C7)","v":"<--  =B4"},null,null,{"$f":"B4","v":13},3,{"$f":"H7+3","v":6},{"$f":"I7+3","v":9},12]
[null,-5,2,null,null,"X",-5,-2,1,4,7]
[null,{"$f":"B8+1","v":-4},3,null,null,null,{"$f":"G8+2","v":-3},0,3,6,9]
[null,{"$f":"B9+1","v":-3},4,null,null,null,{"$f":"G9+2","v":-1},2,5,8,11]
[null,-2,5,null,null,null,1,4,7,10,13]
[null,-1,6,null,null,null,3,6,9,12,15]
[null,0,7,null,null,null,5,8,11,14,17]
[null,1,8]
[null,2,9]
[null,3,10]
[null,4,11]
[null,5,12]
[null,6,13]
[null,7,14]
[null,8,15]
[null,9,16]
[null,10,17]
[null,11,18]
[null,12,19]
[null,13,20]
[null,14,21]
[null,15,22]
[null,16,23]
[null,17,24]
[null,18,25]
[null,19,26]
[null,20,27]
[null,21,28]
[null,22,29]
[null,23,30]

{"sheet":"Sheet5","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["X",3]
[null,null,null,null,"Name","Total points","Grade"]
["Y","Z (X+Y)",null,null,"Sara",70,{"$f":"LOOKUP(F3,$G$10:$G$14,$F$10:$F$14)","v":"C"},{"$f":"getformula(G3)","v":"<--  =LOOKUP(F3,$G$10:$G$14,$F$10:$F$14)"}]
[2,{"$f":"A4+$B$1","v":5},{"$f":"getformula(B4)","v":"<--  =A4+$B$1"},null,"Marko",82,{"$f":"LOOKUP(F4,$G$10:$G$14,$F$10:$F$14)","v":"B"}]
[4,{"$f":"A5+$B$1","v":7},null,null,"Abdulrahman",67,"D"]
[5,8,null,null,"Luis",95,"A"]
[6,9]
[3,6]
[2,5,null,null,null,"Grade breakdown:"]
[5,8,null,null,null,"F",0]
[8,11,null,null,null,"D",60]
[6,9,null,null,null,"C",70]
[null,null,null,null,null,"B",80]
[null,null,null,null,null,"A",90]