{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Validation","Sample Data","Pivot Table Data","Pivot Table","Sample Macro"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Data Validation","index":0,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Name","Address","Phone Number","Contacted?"]

{"sheet":"Sample Data","index":1,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,9]]}
[null,2004,null,null,2003,null,null,2002]
["STATE","Participation Rate 2004","Mean SAT I Verbal","Mean  SAT I Math","Participation Rate 2003","Mean SAT I Verbal","Mean  SAT I Math","Participation Rate 2002","Mean SAT I Verbal","Mean  SAT I Math"]
["New York",0.87,497,510,0.82,496,510,0.79,494,506]
["Connecticut",0.85,515,515,0.84,512,514,0.83,509,509]
["Massachusetts",0.85,518,523,0.82,516,522,0.81,512,516]
["New Jersey",0.83,501,514,0.85,501,515,0.82,498,513]
["New Hampshire",0.8,522,521,0.75,522,521,0.73,519,519]
["D.C.",0.77,489,476,0.77,484,474,0.76,480,473]
["Maine",0.76,505,501,0.7,503,501,0.69,503,502]
["Pennsylvania",0.74,501,502,0.73,500,502,0.72,498,500]
["Delaware",0.73,500,499,0.73,501,501,0.69,502,500]
["Georgia",0.73,494,493,0.66,493,491,0.65,489,491]
["Rhode Island",0.72,503,502,0.74,502,504,0.73,504,503]
["Virginia",0.71,515,509,0.71,514,510,0.68,510,506]
["North Carolina",0.7,499,507,0.68,495,506,0.67,493,505]
["Maryland",0.68,511,515,0.68,509,515,0.67,507,513]
["Florida",0.67,499,499,0.61,498,498,0.56999999999999995,496,499]
["Vermont",0.66,516,512,0.7,515,512,0.69,512,510]
["Indiana",0.64,501,506,0.63,500,504,0.62,498,503]
["South Carolina",0.62,491,495,0.59,493,496,0.59,488,493]
["Hawaii",0.6,487,514,0.54,486,516,0.53,488,520]
["Oregon",0.56000000000000005,527,528,0.56999999999999995,526,527,0.56000000000000005,524,528]
["Alaska",0.53,518,514,0.55000000000000004,518,518,0.52,516,519]
["Texas",0.52,493,499,0.56999999999999995,493,500,0.55000000000000004,491,500]
["Washington",0.52,528,531,0.56000000000000005,530,532,0.54,525,529]
["California",0.49,501,519,0.54,499,519,0.52,496,517]
["Nevada",0.4,507,514,0.36,510,517,0.34,509,518]
["Arizona",0.32,523,524,0.38,524,525,0.36,520,523]
["Montana",0.28999999999999998,537,539,0.26,538,543,0.23,541,547]
["Ohio",0.28000000000000003,538,542,0.28000000000000003,536,541,0.27,533,540]
["Colorado",0.27,554,553,0.27,551,553,0.28000000000000003,543,548]
["Idaho",0.2,540,539,0.18,540,540,0.18,539,541]
["West Virginia",0.19,524,514,0.2,522,510,0.18,525,515]
["Tennessee",0.16,567,557,0.14000000000000001,568,560,0.14000000000000001,562,555]
["New Mexico",0.14000000000000001,554,543,0.14000000000000001,548,540,0.14000000000000001,551,543]
["Kentucky",0.12,559,557,0.13,554,552,0.12,550,552]
["Wyoming",0.12,551,546,0.11,548,549,0.11,531,537]
["Michigan",0.11,563,573,0.11,564,576,0.11,558,572]
["Illinois",0.1,585,597,0.11,583,596,0.11,578,596]
["Minnesota",0.1,587,593,0.1,582,591,0.1,581,591]
["Alabama",0.1,560,553,0.1,559,552,0.09,560,559]
["Kansas",0.09,584,585,0.09,578,582,0.09,578,580]
["Louisiana",0.08,564,561,0.08,563,559,0.08,561,559]
["Missouri",0.08,587,585,0.08,582,583,0.08,574,580]
["Nebraska",0.08,569,576,0.08,573,578,0.08,561,570]
["Oklahoma",7.0000000000000007E-2,569,566,0.08,569,562,0.08,565,562]
["Wisconsin",7.0000000000000007E-2,587,596,7.0000000000000007E-2,585,594,7.0000000000000007E-2,583,599]
["Utah",7.0000000000000007E-2,565,556,7.0000000000000007E-2,566,559,0.06,563,559]
["Arkansas",0.06,569,555,0.06,564,554,0.05,560,556]
["Iowa",0.05,593,602,0.05,586,597,0.05,591,602]
["South Dakota",0.05,594,597,0.04,588,588,0.05,576,586]
["Mississippi",0.05,562,547,0.04,565,551,0.04,559,547]
["North Dakota",0.05,582,601,0.04,602,613,0.04,597,610]
["All Students",0.48,508,518,0.48,507,519,0.46,504,516]

{"sheet":"Pivot Table Data","index":2,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Salesperson","Region","Account","Order Amount","Month"]
["Albertson, Kathy","East",29386,925,"January"]
["Albertson, Kathy","East",74830,875,"February"]
["Albertson, Kathy","East",90099,500,"February"]
["Albertson, Kathy","East",74830,350,"March"]
["Brennan, Michael","West",82853,400,"January"]
["Brennan, Michael","West",72949,850,"January"]
["Brennan, Michael","West",90044,1500,"January"]
["Brennan, Michael","West",82853,550,"February"]
["Brennan, Michael","West",72949,400,"March"]
["Davis, William","South",55223,235,"February"]
["Davis, William","South",10354,850,"January"]
["Davis, William","South",50192,600,"March"]
["Davis, William","South",27589,250,"January"]
["Dumlao, Richard","West",67275,400,"January"]
["Dumlao, Richard","West",41828,965,"February"]
["Dumlao, Richard","West",87543,125,"March"]
["Flores, Tia","South",97446,1500,"March"]
["Flores, Tia","South",41400,305,"January"]
["Flores, Tia","South",30974,1350,"January"]
["Flores, Tia","South",41400,435,"February"]
["Flores, Tia","South",30974,550,"February"]
["Flores, Tia","South",30974,425,"March"]
["Post, Melissa","East",78532,765,"January"]
["Post, Melissa","East",78532,150,"February"]
["Post, Melissa","East",65532,425,"February"]
["Post, Melissa","East",78532,350,"March"]
["Thompson, Shannon","North",91987,875,"January"]
["Thompson, Shannon","North",91041,265,"January"]
["Thompson, Shannon","North",91987,375,"February"]
["Thompson, Shannon","North",91041,1345,"February"]
["Thompson, Shannon","North",91987,300,"March"]
["Walters, Chris","South",55667,225,"January"]
["Walters, Chris","South",54393,105,"January"]
["Walters, Chris","South",40028,25,"January"]
["Walters, Chris","South",55667,155,"February"]
["Walters, Chris","South",54393,2600,"February"]
["Walters, Chris","South",54393,225,"March"]
["Walters, Chris","South",55667,785,"March"]
["Walters, Chris","South",27589,255,"March"]

{"sheet":"Pivot Table","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Order Amount","Column Labels"]
["Row Labels","Albertson, Kathy","Brennan, Michael","Davis, William","Dumlao, Richard","Flores, Tia","Post, Melissa","Thompson, Shannon","Walters, Chris","Grand Total"]
["East",2650,null,null,null,null,1690,null,null,4340]
["North",null,null,null,null,null,null,3160,null,3160]
["South",null,null,1935,null,4565,null,null,4375,10875]
["West",null,3700,null,1490,null,null,null,null,5190]
["Grand Total",2650,3700,1935,1490,4565,1690,3160,4375,23565]

{"sheet":"Sample Macro","index":4,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Data","Average","Max"]
[1234,{"$f":"AVERAGE(A2:A7)","v":983.83333333333337},{"$f":"MAX(A2:A7)","v":4564}]
[4564]
[7]
[86]
[4]
[8]
[{"$f":"SUM(A2:A7)","v":5903}]
[]
[]
[1234]
[4564]
[7]
[86]
[4]
[8]
[]
[]
[]
[]
[1234]
[4564]
[7]
[86]
[4]
[8]
[]
[]
[]
[]
[]
[1234]
[4564]
[7]
[86]
[4]
[8]
[]
[]
[1234]
[4564]
[7]
[86]
[4]
[8]
[]
[]
[]
[1234]
[4564]
[7]
[86]
[4]
[8]