{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Warm up example","Pivot Table","Derek Stats","Summary","User defined function example"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Warm up example","index":0,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[1]
[]
["Jan"]
["Feb"]
["Mar"]
["Apr"]
["May"]
["Jun"]
["Jul"]
["Aug"]
["Sep"]
["Oct"]
["Nov"]

{"sheet":"Pivot Table","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Row Labels","Sum of Number of Awards"]
["1990's",21]
["2000's",25]
["2010's",5]
["Grand Total",51]

{"sheet":"Derek Stats","index":2,"n_rows":30,"n_cols":33,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Year","Decade","Age","Tm","Lg","G","PA","AB","R","H","Greater Than 200","2B","3B","HR","RBI","SB","CS","BB","SO","BA","OBP","SLG","OPS","OPS+","TB","GDP","HBP","SH","SF","IBB","Pos","Number of Awards","Awards"]
[1992,"1990's",18,"NYY-min","Rk,A",58,244,210,23,44,{"$f":"IF(J2>=200,\"200 plus hits\",IF(O2>=70,\"70 plus RBIs\",\"trade\"))","v":"trade"},10,0,4,29,2,3,26,52,0.21,0.311,0.314,0.626,null,66,4,6,0,2,0,null,3,"YNK,GBO · GULF,SALL"]
[1993,"1990's",19,"NYY-min","A",128,590,515,85,152,{"$f":"IF(J3>=200,\"200 plus hits\",IF(O3>=70,\"70 plus RBIs\",\"trade\"))","v":"70 plus RBIs"},14,11,5,71,18,9,58,95,0.29499999999999998,0.376,0.39400000000000002,0.77,null,203,9,11,2,4,1,null,1,"GBO · SALL"]
[1994,"1990's",20,"NYY-min","A+,AAA,AA",138,617,540,103,186,"trade",27,11,5,68,50,8,58,61,0.34399999999999997,0.41,0.46300000000000002,0.873,null,250,13,5,9,5,3,null,5,"TAM,CLB,ALC · FLOR,IL,EL"]
[1995,"1990's",21,"NYY-min","AAA",123,558,486,96,154,"trade",27,9,2,45,20,12,61,56,0.317,0.39400000000000002,0.42199999999999999,0.81599999999999995,null,205,9,4,2,5,1,null,2,"CLB · IL"]
[1995,"1990's",21,"NYY","AL",15,51,48,5,12,"trade",4,1,0,7,0,0,3,11,0.25,0.29399999999999998,0.375,0.66900000000000004,74,18,0,0,0,0,0,6,0]
[1996,"1990's",22,"NYY","AL",157,654,582,104,183,"70 plus RBIs",25,6,10,78,14,7,48,102,0.314,0.37,0.43,0.8,101,250,13,9,6,9,1,"*6",1,"RoY-1"]
[1997,"1990's",23,"NYY","AL",159,748,654,116,190,"70 plus RBIs",31,7,10,70,23,12,74,125,0.29099999999999998,0.37,0.40500000000000003,0.77500000000000002,103,265,14,10,8,2,0,"*6",1,"MVP-24"]
[1998,"1990's",24,"NYY-min","AAA",1,5,5,2,2,"trade",2,0,0,0,0,0,0,2,0.4,0.4,0.8,1.2,null,4,0,0,0,0,0,null,1,"CLB · IL"]
[1998,"1990's",24,"NYY","AL",149,694,626,127,203,"200 plus hits",25,8,19,84,30,6,57,119,0.32400000000000001,0.38400000000000001,0.48099999999999998,0.86399999999999999,127,301,13,5,3,3,1,"*6",2,"AS,MVP-3"]
[1999,"1990's",25,"NYY","AL",158,739,627,134,219,"200 plus hits",37,9,24,102,19,8,91,116,0.34899999999999998,0.438,0.55200000000000005,0.98899999999999999,153,346,12,12,3,6,5,"*6",2,"AS,MVP-6"]
[2000,"1990's",26,"NYY-min","A+",1,3,3,2,2,"trade",1,0,0,0,0,0,0,0,0.66700000000000004,0.66700000000000004,1,1.667,null,3,0,0,0,0,0,null,1,"TAM · FLOR"]
[2000,"1990's",26,"NYY","AL",148,679,593,119,201,"200 plus hits",31,4,15,73,22,4,68,99,0.33900000000000002,0.41599999999999998,0.48099999999999998,0.89600000000000002,128,285,14,12,3,3,4,"*6",2,"AS,MVP-10"]
[2001,"2000's",27,"NYY","AL",150,686,614,110,191,"70 plus RBIs",35,3,21,74,27,3,56,99,0.311,0.377,0.48,0.85799999999999998,124,295,13,10,5,1,3,"*6",2,"AS,MVP-10"]
[2002,"2000's",28,"NYY","AL",157,730,644,124,191,"70 plus RBIs",26,0,18,75,32,3,73,114,0.29699999999999999,0.373,0.42099999999999999,0.79400000000000004,111,271,14,7,3,3,2,"*6/D",1,"AS"]
[2003,"2000's",29,"NYY-min","AA",5,22,18,2,8,"trade",1,1,0,5,0,0,3,0,0.44400000000000001,0.54500000000000004,0.61099999999999999,1.157,null,11,0,1,0,0,0,null,1,"TRE · EL"]
[2003,"2000's",29,"NYY","AL",119,542,482,87,156,"trade",25,3,10,52,11,5,43,88,0.32400000000000001,0.39300000000000002,0.45,0.84399999999999997,125,217,10,13,3,1,2,"*6",1,"MVP-21"]
[2004,"2000's",30,"NYY","AL",154,721,643,111,188,"70 plus RBIs",44,1,23,78,23,4,46,99,0.29199999999999998,0.35199999999999998,0.47099999999999997,0.82299999999999995,114,303,19,14,16,2,1,"*6",3,"AS,MVP-13,GG"]
[2005,"2000's",31,"NYY","AL",159,752,654,122,202,"200 plus hits",25,5,19,70,14,5,77,117,0.309,0.38900000000000001,0.45,0.83899999999999997,125,294,15,11,7,3,3,"*6/D",2,"MVP-10,GG"]
[2006,"2000's",32,"NYY","AL",154,715,623,118,214,"200 plus hits",39,3,14,97,34,5,69,102,0.34300000000000003,0.41699999999999998,0.48299999999999998,0.9,132,301,13,12,7,4,4,"*6/D",4,"AS,MVP-2,GG,SS"]
[2007,"2000's",33,"NYY","AL",156,714,639,102,206,"200 plus hits",39,4,12,73,15,8,56,100,0.32200000000000001,0.38800000000000001,0.45200000000000001,0.84,121,289,21,14,3,2,3,"*6",3,"AS,MVP-11,SS"]
[2008,"2000's",34,"NYY","AL",150,668,596,88,179,"trade",25,3,11,69,11,5,52,85,0.3,0.36299999999999999,0.40799999999999997,0.77100000000000002,102,243,24,9,7,4,0,"*6/D",2,"AS,SS"]
[2009,"2000's",35,"NYY","AL",153,716,634,107,212,"200 plus hits",27,1,18,66,30,5,72,90,0.33400000000000002,0.40600000000000003,0.46500000000000002,0.871,125,295,18,5,4,1,4,"*6/D",4,"AS,MVP-3,GG,SS"]
[2010,"2000's",36,"NYY","AL",157,739,663,111,179,"trade",30,3,10,67,18,5,63,106,0.27,0.34,0.37,0.71,90,245,22,9,1,3,4,"*6/D",2,"AS,GG"]
[2011,"2010's",37,"NYY-min","AA",2,6,4,1,2,"trade",0,0,0,0,0,0,2,1,0.5,0.66700000000000004,0.5,1.167,null,2,0,0,0,0,0,null,1,"TRE · EL"]
[2011,"2010's",37,"NYY","AL",131,607,546,84,162,"trade",24,4,6,61,16,6,46,81,0.29699999999999999,0.35499999999999998,0.38800000000000001,0.74299999999999999,100,212,10,6,4,5,0,"*6D",1,"AS"]
[2012,"2010's",38,"NYY","AL",159,740,683,99,216,"200 plus hits",32,0,15,58,9,4,45,90,0.316,0.36199999999999999,0.42899999999999999,0.79100000000000004,114,293,24,5,6,1,1,"*6D",3,"AS,MVP-7,SS"]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J2:J29)","v":3854},null,null,null,null,{"$f":"SUM(O2:O29)","v":1472}]

{"sheet":"Summary","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Career Hits",{"$f":"'Derek Stats'!J30","v":3854}]
["Career RBIs",{"$f":"'Derek Stats'!O30","v":1472}]

{"sheet":"User defined function example","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["N Steps","SumOfSquares"]
[0,{"$f":"SumofSquares(A2)","v":0}]
[1,1]
[2,5]
[3,14]
[4,30]
[5,55]
[6,91]
[7,140]
[8,204]