{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet5","Sheet4","Sheet3","Sheet2","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet5","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Cross Tabulation of Cars Owned by Customer Age"]
[]
[null,"Name","Age","Car"]
[null,"Julia",34,"Volkswagen"]
[null,"Janice",44,"Toyota"]
[null,"Bobby",64,"BMW"]
[null,"Gary",54,"Cadillac"]
[null,"Parker",48,"Toyota"]
[null,"Matthew",54,"Cadillac"]
[null,"Ryan",57,"Cadillac"]
[null,"Timothy",35,"Volkswagen"]
[null,"Jane",38,"BMW"]
[null,"Wanda",29,"Toyota"]
[null,"Scott",25,"BMW"]

{"sheet":"Sheet4","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Cross Tabulation of Player Positions by Teams"]
[]
[null,"Name","Team","Position"]
[null,"Michale Jordan","Bulls","SG"]
[null,"Scotty Pippen","Bulls","SF"]
[null,"Kobe Bryant","Lakers","SG"]
[null,"Lebron James","Lakers","SG"]
[null,"Derrick Rose","Bulls","PG"]
[null,"Kareem Abdul-Jabbar","Lakers","Center"]
[null,"Shaquille O'Neal","Lakers","Center"]
[null,"Magic Johnson","Lakers","PG"]
[null,"Joakim Noah","Bulls","Center"]

{"sheet":"Sheet3","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,2],[3,4,3,5],[9,1,9,2],[9,4,9,5]]}
[]
[null,"Balance Sheet"]
[]
[null,"Non-Current Assets",null,null,"Liabilities"]
[null,"Land and Buildings",500000,null,"Creditors control",5500]
[null,"Equipment",45000,null,"Income received in advance ",500]
[null,"Depreciation: Equipment",-8000,null,"Accrued expense",2000]
[null,"Total",{"$f":"SUM(C5:C7)","v":537000},null,"Total",{"$f":"SUM(F5:F7)","v":8000}]
[]
[null,"Current Assets",null,null,"Equity"]
[null,"Inventory",2100,null,"Capital",554000]
[null,"Bank",8500,null,"Retained earnings",8600]
[null,"Debtors Control",13000,null,"Drawings",-4000]
[null,"Prepaid expense",6000,null,"Total",{"$f":"SUM(F11:F13)","v":558600}]
[null,"Total",{"$f":"SUM(C11:C14)","v":29600},null,"Total Equity and Liabilities",{"$f":"SUM(F8,F14)","v":566600}]
[null,"Total Assets",{"$f":"SUM(C8,C15)","v":566600}]

{"sheet":"Sheet2","index":3,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Trial Balance"]
[]
[null,"Accounts","Debit","Credit"]
[null,"Capital",null,554000]
[null,"Drawings",4000]
[null,"Land and Buildings",500000]
[null,"Equipment",45000]
[null,"Depreciation: Equipment",null,8000]
[null,"Inventory",2100]
[null,"Bank",8500]
[null,"Debtors control",13000]
[null,"Creditors control",null,5500]
[null,"Income received in advance",null,500]
[null,"Prepaid expense",6000]
[null,"Accrued expense",null,2000]
[null,"Sales",null,18500]
[null,"Advertisement",500]
[null,"Rent",2500]
[null,"Telephone",2500]
[null,"Cost of Sales",3400]
[null,"Depreciation",1000]
[null,"Total",{"$f":"SUM(C5:C22)","v":588500},{"$f":"SUM(D5:D22)","v":588500}]

{"sheet":"Sheet1","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Calculating Average Excluding Outliers"]
[]
[null,"Name","Age"]
[null,"Evan",21]
[null,"Jason",24]
[null,"Franklin",8]
[null,"Grant",22]
[null,"Faye",24]
[null,"Jeffrey",65]
[null,"Allen",23]
[null,"Simmons",25]
[null,"Elena",22]
[null,"Carlton",25]