{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Jan","Feb","March","Summary","Error Checking","Shortcut key","Go to Special","Jan (2)","Feb (2)","March (2)","Chart","Pivot Table","pivot","Sheet9","ErrorList"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":4,"defined_names":3,"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":"Jan","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Sales Records of January"]
[]
[null,"Product","SalesPerson","Sales"]
[null,"Apple","Michael",1288]
[null,"Broccoli","Jonas",1216]
[null,"Tomato","Nick",1651]
[null,"Banana","Shelly",1070]
[null,"Strawberry","Emily",1300]
[null,"Lemon","Leonard",1242]
[null,"Blackberry","Jackson",1047]
[null,"Kiwi","Tony",1917]

{"sheet":"Feb","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Sales Records of February"]
[]
[null,"Product","SalesPerson","Sales"]
[null,"Apple","Michael",2996]
[null,"Broccoli","Jonas",2759]
[null,"Tomato","Nick",2860]
[null,"Banana","Shelly",2790]
[null,"Strawberry","Emily",2770]
[null,"Lemon","Leonard",2082]
[null,"Blackberry","Jackson",2381]
[null,"Kiwi","Tony",2441]

{"sheet":"March","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Sales Records of March"]
[]
[null,"Product","SalesPerson","Sales"]
[null,"Apple","Michael",3707]
[null,"Broccoli","Jonas",3538]
[null,"Tomato","Nick",3824]
[null,"Banana","Shelly",3520]
[null,"Strawberry","Emily",3396]
[null,"Lemon","Leonard",3656]
[null,"Blackberry","Jackson",3955]
[null,"Kiwi","Tony",3594]

{"sheet":"Summary","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Summary of Sales"]
[]
[null,"Product","SalesPerson","Sales"]
[null,"Apple","Michael",{"$f":"Jan!D4+Feb!D4+March!D4+[1]April!$D$4","v":12943}]
[null,"Broccoli","Jonas",{"$f":"Jan!D5+Feb!D5+March!D5+[4]April!$D$4","v":{"$error":"#REF!"}}]
[null,"Tomato","Nick",{"$f":"Jan!D6+Feb!D6+March!D6+[2]April!$D$4","v":8335}]
[null,"Banana","Shelly",{"$f":"Jan!D7+Feb!D7+March!D7+[1]April!$D$4","v":12332}]
[null,"Strawberry","Emily",{"$f":"Jan!D8+Feb!D8+March!D8+[3]April!$D$4","v":7466}]
[null,"Lemon","Leonard",{"$f":"Jan!D9+Feb!D9+March!D9+[3]April!$D$4","v":6980}]
[null,"Blackberry","Jackson",{"$f":"Jan!D10+Feb!D10+March!D10+[3]April!$D$4","v":{"$error":"#REF!"}}]
[null,"Kiwi","Tony",{"$f":"Jan!D11+Feb!D11+March!D11+[1]April!$D$4","v":12904}]

{"sheet":"Error Checking","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Error Checking"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",1288,{"$f":"D4*0.05","v":64.400000000000006}]
[null,"Broccoli","Jonas",1216,{"$f":"D5*0.05","v":60.800000000000004}]
[null,"Tomato","Nick",1651,{"$f":"D6*0.05","v":82.550000000000011}]
[null,"Banana","Shelly",1070,53.5]
[null,"Strawberry","Emily",1300,{"$f":"C8*B8","v":{"$error":"#VALUE!"}}]
[null,"Lemon","Leonard",1242,62.1]
[null,"Blackberry","Jackson",1047,52.35]
[null,"Kiwi","Tony",1917,{"$f":"su(C11,D11)","v":{"$error":"#NAME?"}}]

{"sheet":"Shortcut key","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Shortcut Key to Check Formula"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",1288,{"$f":"D4*0.05","v":64.400000000000006}]
[null,"Broccoli","Jonas",1216,{"$f":"D5*0.05","v":60.800000000000004}]
[null,"Tomato","Nick",1651,{"$f":"D6*0.05","v":82.550000000000011}]
[null,"Banana","Shelly",1070,53.5]
[null,"Strawberry","Emily",1300,{"$f":"D8*0.05","v":65}]
[null,"Lemon","Leonard",1242,62.1]
[null,"Blackberry","Jackson",1047,52.35]
[null,"Kiwi","Tony",1917,{"$f":"D11*0.05","v":95.850000000000009}]

{"sheet":"Go to Special","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Go To Special"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",1288,{"$f":"D4*0.05","v":64.400000000000006}]
[null,"Broccoli","Jonas",1216,{"$f":"C5*D5","v":{"$error":"#VALUE!"}}]
[null,"Tomato","Nick",1651,{"$f":"D6*0.05","v":82.550000000000011}]
[null,"Banana","Shelly",1070,53.5]
[null,"Strawberry","Emily",1300,{"$f":"D8*0.05","v":65}]
[null,"Lemon","Leonard",1242,62.1]
[null,"Blackberry","Jackson",1047,{"$f":"D10*C10","v":{"$error":"#VALUE!"}}]
[null,"Kiwi","Tony",1917,{"$f":"D11*0.05","v":95.850000000000009}]

{"sheet":"Jan (2)","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Sales Records of January"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",1288,{"$f":"D4*0.05","v":64.400000000000006}]
[null,"Broccoli","Jonas",1216,{"$f":"C5*D5","v":{"$error":"#VALUE!"}}]
[null,"Tomato","Nick",1651,{"$f":"D6*0.05","v":82.550000000000011}]
[null,"Banana","Shelly",1070,53.5]
[null,"Strawberry","Emily",1300,{"$f":"D8*0.05","v":65}]
[null,"Lemon","Leonard",1242,62.1]
[null,"Blackberry","Jackson",1047,52.35]
[null,"Kiwi","Tony",1917,{"$f":"su(C11:D11)","v":{"$error":"#NAME?"}}]

{"sheet":"Feb (2)","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Sales Records of February"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",2996,{"$f":"D4*0.05","v":149.80000000000001}]
[null,"Broccoli","Jonas",2759,{"$f":"D5*0.05","v":137.95000000000002}]
[null,"Tomato","Nick",2860,{"$f":"C6*D6","v":{"$error":"#VALUE!"}}]
[null,"Banana","Shelly",2790,{"$f":"D7*0.05","v":139.5}]
[null,"Strawberry","Emily",2770,{"$f":"D8*0.05","v":138.5}]
[null,"Lemon","Leonard",2082,{"$f":"C9*B9","v":{"$error":"#VALUE!"}}]
[null,"Blackberry","Jackson",2381,119.05000000000001]
[null,"Kiwi","Tony",2441,{"$f":"D11*0.05","v":122.05000000000001}]

{"sheet":"March (2)","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Sales Records of March"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",3707,{"$f":"D4*0.05","v":185.35000000000002}]
[null,"Broccoli","Jonas",3538,{"$f":"D5*0.05","v":176.9}]
[null,"Tomato","Nick",3824,{"$f":"D6*0.05","v":191.20000000000002}]
[null,"Banana","Shelly",3520,176]
[null,"Strawberry","Emily",3396,{"$f":"D8*0.05","v":169.8}]
[null,"Lemon","Leonard",3656,182.8]
[null,"Blackberry","Jackson",3955,197.75]
[null,"Kiwi","Tony",3594,{"$f":"D11*0.05","v":179.70000000000002}]

{"sheet":"Chart","index":10,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Checking Charts"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",1288,{"$f":"D4*0.05","v":64.400000000000006}]
[null,"Broccoli","Jonas",1216,{"$f":"D5*0.05","v":60.800000000000004}]
[null,"Tomato","Nick",1651,{"$f":"D6*0.05","v":82.550000000000011}]
[null,"Banana","Shelly",1070,53.5]
[null,"Strawberry","Emily",1300,{"$f":"C8*B8","v":{"$error":"#VALUE!"}}]
[null,"Lemon","Leonard",1242,62.1]
[null,"Blackberry","Jackson",1047,52.35]
[null,"Kiwi","Tony",1917,{"$f":"su(C11,D11)","v":{"$error":"#NAME?"}}]

{"sheet":"Pivot Table","index":11,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Checking Pivot Table"]
[]
[null,"Product","SalesPerson","Sales","Commission"]
[null,"Apple","Michael",1288,{"$f":"D4*0.05","v":64.400000000000006}]
[null,"Broccoli","Jonas",1216,{"$f":"D5*0.05","v":60.800000000000004}]
[null,"Tomato","Nick",1651,{"$f":"D6*0.05","v":82.550000000000011}]
[null,"Banana","Shelly",1070,53.5]
[null,"Strawberry","Emily",1300,{"$f":"C8*B8","v":{"$error":"#VALUE!"}}]
[null,"Lemon","Leonard",1242,62.1]
[null,"Blackberry","Jackson",1047,52.35]
[null,"Kiwi","Tony",1917,{"$f":"su(C11,D11)","v":{"$error":"#NAME?"}}]

{"sheet":"pivot","index":12,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Sales","Column Labels"]
["Row Labels","Emily","Jackson","Jonas","Leonard","Michael","Nick","Shelly","Tony","Grand Total"]
["Apple",null,null,null,null,1288,null,null,null,1288]
[64.400000000000006,null,null,null,null,1288,null,null,null,1288]
["Banana",null,null,null,null,null,null,1070,null,1070]
[53.5,null,null,null,null,null,null,1070,null,1070]
["Blackberry",null,1047,null,null,null,null,null,null,1047]
[52.35,null,1047,null,null,null,null,null,null,1047]
["Broccoli",null,null,1216,null,null,null,null,null,1216]
[60.800000000000004,null,null,1216,null,null,null,null,null,1216]
["Kiwi",null,null,null,null,null,null,null,1917,1917]
["#NAME?",null,null,null,null,null,null,null,1917,1917]
["Lemon",null,null,null,1242,null,null,null,null,1242]
[62.1,null,null,null,1242,null,null,null,null,1242]
["Strawberry",1300,null,null,null,null,null,null,null,1300]
["#VALUE!",1300,null,null,null,null,null,null,null,1300]
["Tomato",null,null,null,null,null,1651,null,null,1651]
[82.550000000000011,null,null,null,null,null,1651,null,null,1651]
["Grand Total",1300,1047,1216,1242,1288,1651,1070,1917,10731]

{"sheet":"Sheet9","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ErrorList","index":14,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sheet Name","Cell Ref","Error Type","Formula"]
[null,"Summary","$D$5",{"$error":"#REF!"},"=Jan!D5+Feb!D5+March!D5+'[April Sals.xlsx]April'!$D$4"]
[null,"Summary","$D$10",{"$error":"#REF!"},"=Jan!D10+Feb!D10+March!D10+'[Aril Sales.xlsx]April'!$D$4"]
[null,"Error Checking","$E$8",{"$error":"#VALUE!"},"=C8*B8"]
[null,"Error Checking","$E$11",{"$error":"#NAME?"},"=su(C11,D11)"]
[null,"Go to Special","$E$5",{"$error":"#VALUE!"},"=C5*D5"]
[null,"Go to Special","$E$10",{"$error":"#VALUE!"},"=D10*C10"]
[null,"Jan (2)","$E$5",{"$error":"#VALUE!"},"=C5*D5"]
[null,"Jan (2)","$E$11",{"$error":"#NAME?"},"=su(C11:D11)"]
[null,"Feb (2)","$E$6",{"$error":"#VALUE!"},"=C6*D6"]
[null,"Feb (2)","$E$9",{"$error":"#VALUE!"},"=C9*B9"]
[null,"Chart","$E$8",{"$error":"#VALUE!"},"=C8*B8"]
[null,"Chart","$E$11",{"$error":"#NAME?"},"=su(C11,D11)"]
[null,"Pivot Table","$E$8",{"$error":"#VALUE!"},"=C8*B8"]
[null,"Pivot Table","$E$11",{"$error":"#NAME?"},"=su(C11,D11)"]
[null,"pivot","$E$8",{"$error":"#VALUE!"},"=C8*B8"]
[null,"pivot","$E$11",{"$error":"#NAME?"},"=su(C11,D11)"]
[null,"Sheet9","$E$8",{"$error":"#VALUE!"},"=C8*B8"]
[null,"Sheet9","$E$11",{"$error":"#NAME?"},"=su(C11,D11)"]