{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","Dataset","SortTwoColumns","ByCompany_Portion_Of_Range","ByRegionPortuonOfRange","ByItemPortionOfRange","ByCompany","ByRegion","ByItem"],"not_rendered":{"charts":0,"images":6,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Sub Total \n& \nGrand Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Dataset","index":1,"n_rows":151,"n_cols":7,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[1,"Apple","North",140,54,"B"]
[2,"Banana","South",35,95,"A"]
[3,"Grapes","East",142,48,"E"," "]
[4,"Orange","West",324,87,"D"]
[5,"Mango","North",22,24,"C"]
[6,"Apple","South",65,36,"B"]
[7,"Banana","East",98,77,"A"]
[8,"Grapes","West",45,94,"E"]
[9,"Orange","North",652,17,"D"]
[10,"Mango","South",63,33,"C"]
[11,"Apple","East",87,57,"B"]
[12,"Banana","West",321,99,"A"]
[13,"Grapes","North",6,14,"E"]
[14,"Orange","South",98,33,"D"]
[15,"Mango","East",45,17,"C"]
[16,"Apple","West",4,88,"B"]
[17,"Banana","North",26,95,"B"]
[18,"Grapes","South",88,65,"A"]
[19,"Orange","East",99,45,"E"]
[20,"Mango","West",140,72,"D"]
[21,"Apple","North",35,95,"C"]
[22,"Banana","South",142,17,"B"]
[23,"Grapes","East",324,35,"A"]
[24,"Orange","West",22,44,"E"]
[25,"Mango","North",65,54,"D"]
[26,"Apple","South",98,95,"C"]
[27,"Banana","East",45,48,"B"]
[28,"Grapes","West",652,87,"A"]
[29,"Orange","North",63,24,"E"]
[30,"Mango","South",87,36,"D"]
[31,"Apple","East",321,77,"C"]
[32,"Banana","West",6,94,"B"]
[33,"Grapes","North",98,17,"A"]
[34,"Orange","South",45,33,"B"]
[35,"Mango","East",4,57,"A"]
[36,"Apple","West",26,99,"E"]
[37,"Banana","North",88,14,"D"]
[38,"Grapes","South",99,33,"C"]
[39,"Orange","East",140,17,"B"]
[40,"Mango","West",35,88,"A"]
[41,"Apple","North",142,95,"E"]
[42,"Banana","South",324,65,"D"]
[43,"Grapes","East",22,45,"C"]
[44,"Orange","West",65,72,"B"]
[45,"Mango","North",98,95,"A"]
[46,"Apple","South",45,17,"E"]
[47,"Banana","East",652,35,"D"]
[48,"Grapes","West",63,44,"C"]
[49,"Orange","North",87,54,"B"]
[50,"Mango","South",321,95,"C"]
[51,"Apple","East",6,48,"B"]
[52,"Banana","West",98,87,"A"]
[53,"Grapes","North",45,24,"E"]
[54,"Orange","South",4,36,"D"]
[55,"Mango","East",26,77,"C"]
[56,"Apple","West",88,94,"B"]
[57,"Banana","North",99,17,"A"]
[58,"Grapes","South",24,33,"E"]
[59,"Orange","East",85,57,"D"]
[60,"Mango","West",36,99,"C"]
[61,"Apple","North",77,14,"B"]
[62,"Banana","South",9,33,"A"]
[63,"Grapes","East",37,17,"E"]
[64,"Orange","West",48,88,"D"]
[65,"Mango","North",88,95,"C"]
[66,"Apple","South",140,65,"C"]
[67,"Banana","East",35,45,"D"]
[68,"Grapes","West",142,72,"C"]
[69,"Orange","North",324,95,"B"]
[70,"Mango","South",22,17,"A"]
[71,"Apple","East",65,35,"E"]
[72,"Banana","West",98,44,"D"]
[73,"Grapes","North",45,54,"C"]
[74,"Orange","South",652,95,"B"]
[75,"Mango","East",63,48,"A"]
[76,"Apple","West",87,87,"E"]
[77,"Banana","North",321,24,"D"]
[78,"Grapes","South",6,36,"C"]
[79,"Orange","East",98,77,"B"]
[80,"Mango","West",45,94,"A"]
[81,"Apple","North",4,17,"E"]
[82,"Banana","South",26,33,"D"]
[83,"Grapes","East",88,57,"D"]
[84,"Orange","West",99,99,"C"]
[85,"Mango","North",140,14,"B"]
[86,"Apple","South",35,33,"A"]
[87,"Banana","East",142,17,"E"]
[88,"Grapes","West",324,88,"D"]
[89,"Orange","North",22,95,"C"]
[90,"Mango","South",65,65,"B"]
[91,"Apple","East",98,45,"A"]
[92,"Banana","West",45,72,"E"]
[93,"Grapes","North",652,95,"D"]
[94,"Orange","South",63,17,"C"]
[95,"Mango","East",87,35,"B"]
[96,"Apple","West",321,44,"A"]
[97,"Banana","North",6,54,"E"]
[98,"Grapes","South",98,95,"D"]
[99,"Orange","East",45,48,"C"]
[100,"Mango","West",4,87,"D"]
[101,"Apple","North",26,24,"C"]
[102,"Banana","South",88,36,"B"]
[103,"Grapes","East",99,77,"A"]
[104,"Orange","West",140,94,"E"]
[105,"Mango","North",35,17,"D"]
[106,"Apple","South",142,33,"C"]
[107,"Banana","East",324,57,"B"]
[108,"Grapes","West",22,99,"A"]
[109,"Orange","North",65,14,"E"]
[110,"Mango","South",98,33,"D"]
[111,"Apple","East",45,17,"C"]
[112,"Banana","West",652,88,"B"]
[113,"Grapes","North",63,95,"A"]
[114,"Orange","South",87,65,"E"]
[115,"Mango","East",321,45,"D"]
[116,"Apple","West",6,72,"D"]
[117,"Banana","North",98,95,"E"]
[118,"Grapes","South",45,17,"D"]
[119,"Orange","East",4,35,"C"]
[120,"Mango","West",26,44,"B"]
[121,"Apple","North",88,54,"A"]
[122,"Banana","South",99,95,"E"]
[123,"Grapes","East",24,48,"D"]
[124,"Orange","West",85,87,"C"]
[125,"Mango","North",36,24,"B"]
[126,"Apple","South",77,36,"A"]
[127,"Banana","East",9,77,"E"]
[128,"Grapes","West",37,94,"D"]
[129,"Orange","North",48,17,"C"]
[130,"Mango","South",88,33,"B"]
[131,"Apple","East",22,57,"A"]
[132,"Banana","West",65,99,"E"]
[133,"Grapes","North",98,14,"E"]
[134,"Orange","South",45,33,"A"]
[135,"Mango","East",652,17,"E"]
[136,"Apple","West",63,88,"D"]
[137,"Banana","North",87,95,"C"]
[138,"Grapes","South",321,65,"B"]
[139,"Orange","East",6,45,"A"]
[140,"Mango","West",98,72,"E"]
[141,"Apple","North",45,95,"D"]
[142,"Banana","South",4,17,"C"]
[143,"Grapes","East",26,35,"B"]
[144,"Orange","West",88,44,"A"]
[145,"Mango","North",99,54,"E"]
[146,"Apple","South",24,95,"D"]
[147,"Banana","East",85,48,"C"]
[148,"Grapes","West",36,87,"B"]
[149,"Orange","North",77,24,"A"]
[150,"Mango","South",9,36,"A"]

{"sheet":"SortTwoColumns","index":2,"n_rows":172,"n_cols":7,"rows_kept":172,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[19,"Orange","East",99,45,"E"]
[39,"Orange","East",140,17,"B"]
[59,"Orange","East",85,57,"D"]
[79,"Orange","East",98,77,"B"]
[99,"Orange","East",45,48,"C"]
[119,"Orange","East",4,35,"C"]
[139,"Orange","East",6,45,"A"]
[null,null,"East Total",{"$f":"SUBTOTAL(9,D2:D8)","v":477},{"$f":"SUBTOTAL(9,E2:E8)","v":324}]
[9,"Orange","North",652,17,"D"]
[29,"Orange","North",63,24,"E"]
[49,"Orange","North",87,54,"B"]
[69,"Orange","North",324,95,"B"]
[89,"Orange","North",22,95,"C"]
[109,"Orange","North",65,14,"E"]
[129,"Orange","North",48,17,"C"]
[149,"Orange","North",77,24,"A"]
[null,null,"North Total",{"$f":"SUBTOTAL(9,D10:D17)","v":1338},{"$f":"SUBTOTAL(9,E10:E17)","v":340}]
[14,"Orange","South",98,33,"D"]
[34,"Orange","South",45,33,"B"]
[54,"Orange","South",4,36,"D"]
[74,"Orange","South",652,95,"B"]
[94,"Orange","South",63,17,"C"]
[114,"Orange","South",87,65,"E"]
[134,"Orange","South",45,33,"A"]
[null,null,"South Total",{"$f":"SUBTOTAL(9,D19:D25)","v":994},{"$f":"SUBTOTAL(9,E19:E25)","v":312}]
[4,"Orange","West",324,87,"D"]
[24,"Orange","West",22,44,"E"]
[44,"Orange","West",65,72,"B"]
[64,"Orange","West",48,88,"D"]
[84,"Orange","West",99,99,"C"]
[104,"Orange","West",140,94,"E"]
[124,"Orange","West",85,87,"C"]
[144,"Orange","West",88,44,"A"]
[null,null,"West Total",{"$f":"SUBTOTAL(9,D27:D34)","v":871},{"$f":"SUBTOTAL(9,E27:E34)","v":615}]
[15,"Mango","East",45,17,"C"]
[35,"Mango","East",4,57,"A"]
[55,"Mango","East",26,77,"C"]
[75,"Mango","East",63,48,"A"]
[95,"Mango","East",87,35,"B"]
[115,"Mango","East",321,45,"D"]
[135,"Mango","East",652,17,"E"]
[null,null,"East Total",{"$f":"SUBTOTAL(9,D36:D42)","v":1198},{"$f":"SUBTOTAL(9,E36:E42)","v":296}]
[5,"Mango","North",22,24,"C"]
[25,"Mango","North",65,54,"D"]
[45,"Mango","North",98,95,"A"]
[65,"Mango","North",88,95,"C"]
[85,"Mango","North",140,14,"B"]
[105,"Mango","North",35,17,"D"]
[125,"Mango","North",36,24,"B"]
[145,"Mango","North",99,54,"E"]
[null,null,"North Total",{"$f":"SUBTOTAL(9,D44:D51)","v":583},{"$f":"SUBTOTAL(9,E44:E51)","v":377}]
[10,"Mango","South",63,33,"C"]
[30,"Mango","South",87,36,"D"]
[50,"Mango","South",321,95,"C"]
[70,"Mango","South",22,17,"A"]
[90,"Mango","South",65,65,"B"]
[110,"Mango","South",98,33,"D"]
[130,"Mango","South",88,33,"B"]
[150,"Mango","South",9,36,"A"]
[null,null,"South Total",{"$f":"SUBTOTAL(9,D53:D60)","v":753},{"$f":"SUBTOTAL(9,E53:E60)","v":348}]
[20,"Mango","West",140,72,"D"]
[40,"Mango","West",35,88,"A"]
[60,"Mango","West",36,99,"C"]
[80,"Mango","West",45,94,"A"]
[100,"Mango","West",4,87,"D"]
[120,"Mango","West",26,44,"B"]
[140,"Mango","West",98,72,"E"]
[null,null,"West Total",{"$f":"SUBTOTAL(9,D62:D68)","v":384},{"$f":"SUBTOTAL(9,E62:E68)","v":556}]
[3,"Grapes","East",142,48,"E"," "]
[23,"Grapes","East",324,35,"A"]
[43,"Grapes","East",22,45,"C"]
[63,"Grapes","East",37,17,"E"]
[83,"Grapes","East",88,57,"D"]
[103,"Grapes","East",99,77,"A"]
[123,"Grapes","East",24,48,"D"]
[143,"Grapes","East",26,35,"B"]
[null,null,"East Total",{"$f":"SUBTOTAL(9,D70:D77)","v":762},{"$f":"SUBTOTAL(9,E70:E77)","v":362}]
[13,"Grapes","North",6,14,"E"]
[33,"Grapes","North",98,17,"A"]
[53,"Grapes","North",45,24,"E"]
[73,"Grapes","North",45,54,"C"]
[93,"Grapes","North",652,95,"D"]
[113,"Grapes","North",63,95,"A"]
[133,"Grapes","North",98,14,"E"]
[null,null,"North Total",{"$f":"SUBTOTAL(9,D79:D85)","v":1007},{"$f":"SUBTOTAL(9,E79:E85)","v":313}]
[18,"Grapes","South",88,65,"A"]
[38,"Grapes","South",99,33,"C"]
[58,"Grapes","South",24,33,"E"]
[78,"Grapes","South",6,36,"C"]
[98,"Grapes","South",98,95,"D"]
[118,"Grapes","South",45,17,"D"]
[138,"Grapes","South",321,65,"B"]
[null,null,"South Total",{"$f":"SUBTOTAL(9,D87:D93)","v":681},{"$f":"SUBTOTAL(9,E87:E93)","v":344}]
[8,"Grapes","West",45,94,"E"]
[28,"Grapes","West",652,87,"A"]
[48,"Grapes","West",63,44,"C"]
[68,"Grapes","West",142,72,"C"]
[88,"Grapes","West",324,88,"D"]
[108,"Grapes","West",22,99,"A"]
[128,"Grapes","West",37,94,"D"]
[148,"Grapes","West",36,87,"B"]
[null,null,"West Total",{"$f":"SUBTOTAL(9,D95:D102)","v":1321},{"$f":"SUBTOTAL(9,E95:E102)","v":665}]
[7,"Banana","East",98,77,"A"]
[27,"Banana","East",45,48,"B"]
[47,"Banana","East",652,35,"D"]
[67,"Banana","East",35,45,"D"]
[87,"Banana","East",142,17,"E"]
[107,"Banana","East",324,57,"B"]
[127,"Banana","East",9,77,"E"]
[147,"Banana","East",85,48,"C"]
[null,null,"East Total",{"$f":"SUBTOTAL(9,D104:D111)","v":1390},{"$f":"SUBTOTAL(9,E104:E111)","v":404}]
[17,"Banana","North",26,95,"B"]
[37,"Banana","North",88,14,"D"]
[57,"Banana","North",99,17,"A"]
[77,"Banana","North",321,24,"D"]
[97,"Banana","North",6,54,"E"]
[117,"Banana","North",98,95,"E"]
[137,"Banana","North",87,95,"C"]
[null,null,"North Total",{"$f":"SUBTOTAL(9,D113:D119)","v":725},{"$f":"SUBTOTAL(9,E113:E119)","v":394}]
[2,"Banana","South",35,95,"A"]
[22,"Banana","South",142,17,"B"]
[42,"Banana","South",324,65,"D"]
[62,"Banana","South",9,33,"A"]
[82,"Banana","South",26,33,"D"]
[102,"Banana","South",88,36,"B"]
[122,"Banana","South",99,95,"E"]
[142,"Banana","South",4,17,"C"]
[null,null,"South Total",{"$f":"SUBTOTAL(9,D121:D128)","v":727},{"$f":"SUBTOTAL(9,E121:E128)","v":391}]
[12,"Banana","West",321,99,"A"]
[32,"Banana","West",6,94,"B"]
[52,"Banana","West",98,87,"A"]
[72,"Banana","West",98,44,"D"]
[92,"Banana","West",45,72,"E"]
[112,"Banana","West",652,88,"B"]
[132,"Banana","West",65,99,"E"]
[null,null,"West Total",{"$f":"SUBTOTAL(9,D130:D136)","v":1285},{"$f":"SUBTOTAL(9,E130:E136)","v":583}]
[11,"Apple","East",87,57,"B"]
[31,"Apple","East",321,77,"C"]
[51,"Apple","East",6,48,"B"]
[71,"Apple","East",65,35,"E"]
[91,"Apple","East",98,45,"A"]
[111,"Apple","East",45,17,"C"]
[131,"Apple","East",22,57,"A"]
[null,null,"East Total",{"$f":"SUBTOTAL(9,D138:D144)","v":644},{"$f":"SUBTOTAL(9,E138:E144)","v":336}]
[1,"Apple","North",140,54,"B"]
[21,"Apple","North",35,95,"C"]
[41,"Apple","North",142,95,"E"]
[61,"Apple","North",77,14,"B"]
[81,"Apple","North",4,17,"E"]
[101,"Apple","North",26,24,"C"]
[121,"Apple","North",88,54,"A"]
[141,"Apple","North",45,95,"D"]
[null,null,"North Total",{"$f":"SUBTOTAL(9,D146:D153)","v":557},{"$f":"SUBTOTAL(9,E146:E153)","v":448}]
[6,"Apple","South",65,36,"B"]
[26,"Apple","South",98,95,"C"]
[46,"Apple","South",45,17,"E"]
[66,"Apple","South",140,65,"C"]
[86,"Apple","South",35,33,"A"]
[106,"Apple","South",142,33,"C"]
[126,"Apple","South",77,36,"A"]
[146,"Apple","South",24,95,"D"]
[null,null,"South Total",{"$f":"SUBTOTAL(9,D155:D162)","v":626},{"$f":"SUBTOTAL(9,E155:E162)","v":410}]
[16,"Apple","West",4,88,"B"]
[36,"Apple","West",26,99,"E"]
[56,"Apple","West",88,94,"B"]
[76,"Apple","West",87,87,"E"]
[96,"Apple","West",321,44,"A"]
[116,"Apple","West",6,72,"D"]
[136,"Apple","West",63,88,"D"]
[null,null,"West Total",{"$f":"SUBTOTAL(9,D164:D170)","v":595},{"$f":"SUBTOTAL(9,E164:E170)","v":572}]
[null,null,"Grand Total",{"$f":"SUBTOTAL(9,D2:D170)","v":16918},{"$f":"SUBTOTAL(9,E2:E170)","v":8390}]

{"sheet":"ByCompany_Portion_Of_Range","index":3,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[3,"Grapes","East",142,48,"E"]
[8,"Grapes","West",45,94,"E"]
[13,"Grapes","North",6,14,"E"]
[null,null,null,{"$f":"SUBTOTAL(9,D2:D4)","v":193},{"$f":"SUBTOTAL(9,E2:E4)","v":156},"E Total"]
[4,"Orange","West",324,87,"D"]
[9,"Orange","North",652,17,"D"]
[14,"Orange","South",98,33,"D"]
[null,null,null,{"$f":"SUBTOTAL(9,D6:D8)","v":1074},{"$f":"SUBTOTAL(9,E6:E8)","v":137},"D Total"]
[5,"Mango","North",22,24,"C"]
[10,"Mango","South",63,33,"C"]
[15,"Mango","East",45,17,"C"]
[null,null,null,{"$f":"SUBTOTAL(9,D10:D12)","v":130},{"$f":"SUBTOTAL(9,E10:E12)","v":74},"C Total"]
[6,"Apple","South",65,36,"B"]
[11,"Apple","East",87,57,"B"]
[16,"Apple","West",4,88,"B"]
[17,"Banana","North",26,95,"B"]
[null,null,null,{"$f":"SUBTOTAL(9,D14:D17)","v":182},{"$f":"SUBTOTAL(9,E14:E17)","v":276},"B Total"]
[7,"Banana","East",98,77,"A"]
[12,"Banana","West",321,99,"A"]
[null,null,null,{"$f":"SUBTOTAL(9,D19:D20)","v":419},{"$f":"SUBTOTAL(9,E19:E20)","v":176},"A Total"]
[null,null,null,{"$f":"SUBTOTAL(9,D2:D20)","v":1998},{"$f":"SUBTOTAL(9,E2:E20)","v":819},"Grand Total"]

{"sheet":"ByRegionPortuonOfRange","index":4,"n_rows":91,"n_cols":6,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[24,"Orange","West",22,44,"E"]
[28,"Grapes","West",652,87,"A"]
[32,"Banana","West",6,94,"B"]
[36,"Apple","West",26,99,"E"]
[40,"Mango","West",35,88,"A"]
[44,"Orange","West",65,72,"B"]
[48,"Grapes","West",63,44,"C"]
[52,"Banana","West",98,87,"A"]
[56,"Apple","West",88,94,"B"]
[60,"Mango","West",36,99,"C"]
[64,"Orange","West",48,88,"D"]
[68,"Grapes","West",142,72,"C"]
[72,"Banana","West",98,44,"D"]
[76,"Apple","West",87,87,"E"]
[80,"Mango","West",45,94,"A"]
[84,"Orange","West",99,99,"C"]
[88,"Grapes","West",324,88,"D"]
[92,"Banana","West",45,72,"E"]
[96,"Apple","West",321,44,"A"]
[100,"Mango","West",4,87,"D"]
[104,"Orange","West",140,94,"E"]
[null,null,"West Total",{"$f":"SUBTOTAL(9,D2:D22)","v":2444},{"$f":"SUBTOTAL(9,E2:E22)","v":1677}]
[22,"Banana","South",142,17,"B"]
[26,"Apple","South",98,95,"C"]
[30,"Mango","South",87,36,"D"]
[34,"Orange","South",45,33,"B"]
[38,"Grapes","South",99,33,"C"]
[42,"Banana","South",324,65,"D"]
[46,"Apple","South",45,17,"E"]
[50,"Mango","South",321,95,"C"]
[54,"Orange","South",4,36,"D"]
[58,"Grapes","South",24,33,"E"]
[62,"Banana","South",9,33,"A"]
[66,"Apple","South",140,65,"C"]
[70,"Mango","South",22,17,"A"]
[74,"Orange","South",652,95,"B"]
[78,"Grapes","South",6,36,"C"]
[82,"Banana","South",26,33,"D"]
[86,"Apple","South",35,33,"A"]
[90,"Mango","South",65,65,"B"]
[94,"Orange","South",63,17,"C"]
[98,"Grapes","South",98,95,"D"]
[102,"Banana","South",88,36,"B"]
[null,null,"South Total",{"$f":"SUBTOTAL(9,D24:D44)","v":2393},{"$f":"SUBTOTAL(9,E24:E44)","v":985}]
[21,"Apple","North",35,95,"C"]
[25,"Mango","North",65,54,"D"]
[29,"Orange","North",63,24,"E"]
[33,"Grapes","North",98,17,"A"]
[37,"Banana","North",88,14,"D"]
[41,"Apple","North",142,95,"E"]
[45,"Mango","North",98,95,"A"]
[49,"Orange","North",87,54,"B"]
[53,"Grapes","North",45,24,"E"]
[57,"Banana","North",99,17,"A"]
[61,"Apple","North",77,14,"B"]
[65,"Mango","North",88,95,"C"]
[69,"Orange","North",324,95,"B"]
[73,"Grapes","North",45,54,"C"]
[77,"Banana","North",321,24,"D"]
[81,"Apple","North",4,17,"E"]
[85,"Mango","North",140,14,"B"]
[89,"Orange","North",22,95,"C"]
[93,"Grapes","North",652,95,"D"]
[97,"Banana","North",6,54,"E"]
[101,"Apple","North",26,24,"C"]
[105,"Mango","North",35,17,"D"]
[null,null,"North Total",{"$f":"SUBTOTAL(9,D46:D67)","v":2560},{"$f":"SUBTOTAL(9,E46:E67)","v":1087}]
[23,"Grapes","East",324,35,"A"]
[27,"Banana","East",45,48,"B"]
[31,"Apple","East",321,77,"C"]
[35,"Mango","East",4,57,"A"]
[39,"Orange","East",140,17,"B"]
[43,"Grapes","East",22,45,"C"]
[47,"Banana","East",652,35,"D"]
[51,"Apple","East",6,48,"B"]
[55,"Mango","East",26,77,"C"]
[59,"Orange","East",85,57,"D"]
[63,"Grapes","East",37,17,"E"]
[67,"Banana","East",35,45,"D"]
[71,"Apple","East",65,35,"E"]
[75,"Mango","East",63,48,"A"]
[79,"Orange","East",98,77,"B"]
[83,"Grapes","East",88,57,"D"]
[87,"Banana","East",142,17,"E"]
[91,"Apple","East",98,45,"A"]
[95,"Mango","East",87,35,"B"]
[99,"Orange","East",45,48,"C"]
[103,"Grapes","East",99,77,"A"]
[null,null,"East Total",{"$f":"SUBTOTAL(9,D69:D89)","v":2482},{"$f":"SUBTOTAL(9,E69:E89)","v":997}]
[null,null,"Grand Total",{"$f":"SUBTOTAL(9,D2:D89)","v":9879},{"$f":"SUBTOTAL(9,E2:E89)","v":4746}]

{"sheet":"ByItemPortionOfRange","index":5,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[4,"Orange","West",324,87,"D"]
[9,"Orange","North",652,17,"D"]
[14,"Orange","South",98,33,"D"]
[19,"Orange","East",99,45,"E"]
[null,"Orange Total",null,{"$f":"SUBTOTAL(9,D2:D5)","v":1173},{"$f":"SUBTOTAL(9,E2:E5)","v":182}]
[5,"Mango","North",22,24,"C"]
[10,"Mango","South",63,33,"C"]
[15,"Mango","East",45,17,"C"]
[20,"Mango","West",140,72,"D"]
[null,"Mango Total",null,{"$f":"SUBTOTAL(9,D7:D10)","v":270},{"$f":"SUBTOTAL(9,E7:E10)","v":146}]
[3,"Grapes","East",142,48,"E"]
[8,"Grapes","West",45,94,"E"]
[13,"Grapes","North",6,14,"E"]
[18,"Grapes","South",88,65,"A"]
[null,"Grapes Total",null,{"$f":"SUBTOTAL(9,D12:D15)","v":281},{"$f":"SUBTOTAL(9,E12:E15)","v":221}]
[2,"Banana","South",35,95,"A"]
[7,"Banana","East",98,77,"A"]
[12,"Banana","West",321,99,"A"]
[17,"Banana","North",26,95,"B"]
[null,"Banana Total",null,{"$f":"SUBTOTAL(9,D17:D20)","v":480},{"$f":"SUBTOTAL(9,E17:E20)","v":366}]
[6,"Apple","South",65,36,"B"]
[11,"Apple","East",87,57,"B"]
[16,"Apple","West",4,88,"B"]
[null,"Apple Total",null,{"$f":"SUBTOTAL(9,D22:D24)","v":156},{"$f":"SUBTOTAL(9,E22:E24)","v":181}]
[null,"Grand Total",null,{"$f":"SUBTOTAL(9,D2:D24)","v":2360},{"$f":"SUBTOTAL(9,E2:E24)","v":1096}]

{"sheet":"ByCompany","index":6,"n_rows":157,"n_cols":7,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[3,"Grapes","East",142,48,"E"," "]
[8,"Grapes","West",45,94,"E"]
[13,"Grapes","North",6,14,"E"]
[19,"Orange","East",99,45,"E"]
[24,"Orange","West",22,44,"E"]
[29,"Orange","North",63,24,"E"]
[36,"Apple","West",26,99,"E"]
[41,"Apple","North",142,95,"E"]
[46,"Apple","South",45,17,"E"]
[53,"Grapes","North",45,24,"E"]
[58,"Grapes","South",24,33,"E"]
[63,"Grapes","East",37,17,"E"]
[71,"Apple","East",65,35,"E"]
[76,"Apple","West",87,87,"E"]
[81,"Apple","North",4,17,"E"]
[87,"Banana","East",142,17,"E"]
[92,"Banana","West",45,72,"E"]
[97,"Banana","North",6,54,"E"]
[104,"Orange","West",140,94,"E"]
[109,"Orange","North",65,14,"E"]
[114,"Orange","South",87,65,"E"]
[117,"Banana","North",98,95,"E"]
[122,"Banana","South",99,95,"E"]
[127,"Banana","East",9,77,"E"]
[132,"Banana","West",65,99,"E"]
[133,"Grapes","North",98,14,"E"]
[135,"Mango","East",652,17,"E"]
[140,"Mango","West",98,72,"E"]
[145,"Mango","North",99,54,"E"]
[null,null,null,{"$f":"SUBTOTAL(9,D2:D30)","v":2555},{"$f":"SUBTOTAL(9,E2:E30)","v":1532},"E Total"]
[4,"Orange","West",324,87,"D"]
[9,"Orange","North",652,17,"D"]
[14,"Orange","South",98,33,"D"]
[20,"Mango","West",140,72,"D"]
[25,"Mango","North",65,54,"D"]
[30,"Mango","South",87,36,"D"]
[37,"Banana","North",88,14,"D"]
[42,"Banana","South",324,65,"D"]
[47,"Banana","East",652,35,"D"]
[54,"Orange","South",4,36,"D"]
[59,"Orange","East",85,57,"D"]
[64,"Orange","West",48,88,"D"]
[67,"Banana","East",35,45,"D"]
[72,"Banana","West",98,44,"D"]
[77,"Banana","North",321,24,"D"]
[82,"Banana","South",26,33,"D"]
[83,"Grapes","East",88,57,"D"]
[88,"Grapes","West",324,88,"D"]
[93,"Grapes","North",652,95,"D"]
[98,"Grapes","South",98,95,"D"]
[100,"Mango","West",4,87,"D"]
[105,"Mango","North",35,17,"D"]
[110,"Mango","South",98,33,"D"]
[115,"Mango","East",321,45,"D"]
[116,"Apple","West",6,72,"D"]
[118,"Grapes","South",45,17,"D"]
[123,"Grapes","East",24,48,"D"]
[128,"Grapes","West",37,94,"D"]
[136,"Apple","West",63,88,"D"]
[141,"Apple","North",45,95,"D"]
[146,"Apple","South",24,95,"D"]
[null,null,null,{"$f":"SUBTOTAL(9,D32:D62)","v":4911},{"$f":"SUBTOTAL(9,E32:E62)","v":1766},"D Total"]
[5,"Mango","North",22,24,"C"]
[10,"Mango","South",63,33,"C"]
[15,"Mango","East",45,17,"C"]
[21,"Apple","North",35,95,"C"]
[26,"Apple","South",98,95,"C"]
[31,"Apple","East",321,77,"C"]
[38,"Grapes","South",99,33,"C"]
[43,"Grapes","East",22,45,"C"]
[48,"Grapes","West",63,44,"C"]
[50,"Mango","South",321,95,"C"]
[55,"Mango","East",26,77,"C"]
[60,"Mango","West",36,99,"C"]
[65,"Mango","North",88,95,"C"]
[66,"Apple","South",140,65,"C"]
[68,"Grapes","West",142,72,"C"]
[73,"Grapes","North",45,54,"C"]
[78,"Grapes","South",6,36,"C"]
[84,"Orange","West",99,99,"C"]
[89,"Orange","North",22,95,"C"]
[94,"Orange","South",63,17,"C"]
[99,"Orange","East",45,48,"C"]
[101,"Apple","North",26,24,"C"]
[106,"Apple","South",142,33,"C"]
[111,"Apple","East",45,17,"C"]
[119,"Orange","East",4,35,"C"]
[124,"Orange","West",85,87,"C"]
[129,"Orange","North",48,17,"C"]
[137,"Banana","North",87,95,"C"]
[142,"Banana","South",4,17,"C"]
[147,"Banana","East",85,48,"C"]
[null,null,null,{"$f":"SUBTOTAL(9,D64:D93)","v":2327},{"$f":"SUBTOTAL(9,E64:E93)","v":1688},"C Total"]
[1,"Apple","North",140,54,"B"]
[6,"Apple","South",65,36,"B"]
[11,"Apple","East",87,57,"B"]
[16,"Apple","West",4,88,"B"]
[17,"Banana","North",26,95,"B"]
[22,"Banana","South",142,17,"B"]
[27,"Banana","East",45,48,"B"]
[32,"Banana","West",6,94,"B"]
[34,"Orange","South",45,33,"B"]
[39,"Orange","East",140,17,"B"]
[44,"Orange","West",65,72,"B"]
[49,"Orange","North",87,54,"B"]
[51,"Apple","East",6,48,"B"]
[56,"Apple","West",88,94,"B"]
[61,"Apple","North",77,14,"B"]
[69,"Orange","North",324,95,"B"]
[74,"Orange","South",652,95,"B"]
[79,"Orange","East",98,77,"B"]
[85,"Mango","North",140,14,"B"]
[90,"Mango","South",65,65,"B"]
[95,"Mango","East",87,35,"B"]
[102,"Banana","South",88,36,"B"]
[107,"Banana","East",324,57,"B"]
[112,"Banana","West",652,88,"B"]
[120,"Mango","West",26,44,"B"]
[125,"Mango","North",36,24,"B"]
[130,"Mango","South",88,33,"B"]
[138,"Grapes","South",321,65,"B"]
[143,"Grapes","East",26,35,"B"]
[148,"Grapes","West",36,87,"B"]
[null,null,null,{"$f":"SUBTOTAL(9,D95:D124)","v":3986},{"$f":"SUBTOTAL(9,E95:E124)","v":1671},"B Total"]
[2,"Banana","South",35,95,"A"]
[7,"Banana","East",98,77,"A"]
[12,"Banana","West",321,99,"A"]
[18,"Grapes","South",88,65,"A"]
[23,"Grapes","East",324,35,"A"]
[28,"Grapes","West",652,87,"A"]
[33,"Grapes","North",98,17,"A"]
[35,"Mango","East",4,57,"A"]
[40,"Mango","West",35,88,"A"]
[45,"Mango","North",98,95,"A"]
[52,"Banana","West",98,87,"A"]
[57,"Banana","North",99,17,"A"]
[62,"Banana","South",9,33,"A"]
[70,"Mango","South",22,17,"A"]
[75,"Mango","East",63,48,"A"]
[80,"Mango","West",45,94,"A"]
[86,"Apple","South",35,33,"A"]
[91,"Apple","East",98,45,"A"]
[96,"Apple","West",321,44,"A"]
[103,"Grapes","East",99,77,"A"]
[108,"Grapes","West",22,99,"A"]
[113,"Grapes","North",63,95,"A"]
[121,"Apple","North",88,54,"A"]
[126,"Apple","South",77,36,"A"]
[131,"Apple","East",22,57,"A"]
[134,"Orange","South",45,33,"A"]
[139,"Orange","East",6,45,"A"]
[144,"Orange","West",88,44,"A"]
[149,"Orange","North",77,24,"A"]
[150,"Mango","South",9,36,"A"]
[null,null,null,{"$f":"SUBTOTAL(9,D126:D155)","v":3139},{"$f":"SUBTOTAL(9,E126:E155)","v":1733},"A Total"]
[null,null,null,{"$f":"SUBTOTAL(9,D2:D155)","v":16918},{"$f":"SUBTOTAL(9,E2:E155)","v":8390},"Grand Total"]

{"sheet":"ByRegion","index":7,"n_rows":156,"n_cols":7,"rows_kept":156,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[4,"Orange","West",324,87,"D"]
[8,"Grapes","West",45,94,"E"]
[12,"Banana","West",321,99,"A"]
[16,"Apple","West",4,88,"B"]
[20,"Mango","West",140,72,"D"]
[24,"Orange","West",22,44,"E"]
[28,"Grapes","West",652,87,"A"]
[32,"Banana","West",6,94,"B"]
[36,"Apple","West",26,99,"E"]
[40,"Mango","West",35,88,"A"]
[44,"Orange","West",65,72,"B"]
[48,"Grapes","West",63,44,"C"]
[52,"Banana","West",98,87,"A"]
[56,"Apple","West",88,94,"B"]
[60,"Mango","West",36,99,"C"]
[64,"Orange","West",48,88,"D"]
[68,"Grapes","West",142,72,"C"]
[72,"Banana","West",98,44,"D"]
[76,"Apple","West",87,87,"E"]
[80,"Mango","West",45,94,"A"]
[84,"Orange","West",99,99,"C"]
[88,"Grapes","West",324,88,"D"]
[92,"Banana","West",45,72,"E"]
[96,"Apple","West",321,44,"A"]
[100,"Mango","West",4,87,"D"]
[104,"Orange","West",140,94,"E"]
[108,"Grapes","West",22,99,"A"]
[112,"Banana","West",652,88,"B"]
[116,"Apple","West",6,72,"D"]
[120,"Mango","West",26,44,"B"]
[124,"Orange","West",85,87,"C"]
[128,"Grapes","West",37,94,"D"]
[132,"Banana","West",65,99,"E"]
[136,"Apple","West",63,88,"D"]
[140,"Mango","West",98,72,"E"]
[144,"Orange","West",88,44,"A"]
[148,"Grapes","West",36,87,"B"]
[null,null,"West Total",{"$f":"SUBTOTAL(9,D2:D38)","v":4456},{"$f":"SUBTOTAL(9,E2:E38)","v":2991}]
[2,"Banana","South",35,95,"A"]
[6,"Apple","South",65,36,"B"]
[10,"Mango","South",63,33,"C"]
[14,"Orange","South",98,33,"D"]
[18,"Grapes","South",88,65,"A"]
[22,"Banana","South",142,17,"B"]
[26,"Apple","South",98,95,"C"]
[30,"Mango","South",87,36,"D"]
[34,"Orange","South",45,33,"B"]
[38,"Grapes","South",99,33,"C"]
[42,"Banana","South",324,65,"D"]
[46,"Apple","South",45,17,"E"]
[50,"Mango","South",321,95,"C"]
[54,"Orange","South",4,36,"D"]
[58,"Grapes","South",24,33,"E"]
[62,"Banana","South",9,33,"A"]
[66,"Apple","South",140,65,"C"]
[70,"Mango","South",22,17,"A"]
[74,"Orange","South",652,95,"B"]
[78,"Grapes","South",6,36,"C"]
[82,"Banana","South",26,33,"D"]
[86,"Apple","South",35,33,"A"]
[90,"Mango","South",65,65,"B"]
[94,"Orange","South",63,17,"C"]
[98,"Grapes","South",98,95,"D"]
[102,"Banana","South",88,36,"B"]
[106,"Apple","South",142,33,"C"]
[110,"Mango","South",98,33,"D"]
[114,"Orange","South",87,65,"E"]
[118,"Grapes","South",45,17,"D"]
[122,"Banana","South",99,95,"E"]
[126,"Apple","South",77,36,"A"]
[130,"Mango","South",88,33,"B"]
[134,"Orange","South",45,33,"A"]
[138,"Grapes","South",321,65,"B"]
[142,"Banana","South",4,17,"C"]
[146,"Apple","South",24,95,"D"]
[150,"Mango","South",9,36,"A"]
[null,null,"South Total",{"$f":"SUBTOTAL(9,D40:D77)","v":3781},{"$f":"SUBTOTAL(9,E40:E77)","v":1805}]
[1,"Apple","North",140,54,"B"]
[5,"Mango","North",22,24,"C"]
[9,"Orange","North",652,17,"D"]
[13,"Grapes","North",6,14,"E"]
[17,"Banana","North",26,95,"B"]
[21,"Apple","North",35,95,"C"]
[25,"Mango","North",65,54,"D"]
[29,"Orange","North",63,24,"E"]
[33,"Grapes","North",98,17,"A"]
[37,"Banana","North",88,14,"D"]
[41,"Apple","North",142,95,"E"]
[45,"Mango","North",98,95,"A"]
[49,"Orange","North",87,54,"B"]
[53,"Grapes","North",45,24,"E"]
[57,"Banana","North",99,17,"A"]
[61,"Apple","North",77,14,"B"]
[65,"Mango","North",88,95,"C"]
[69,"Orange","North",324,95,"B"]
[73,"Grapes","North",45,54,"C"]
[77,"Banana","North",321,24,"D"]
[81,"Apple","North",4,17,"E"]
[85,"Mango","North",140,14,"B"]
[89,"Orange","North",22,95,"C"]
[93,"Grapes","North",652,95,"D"]
[97,"Banana","North",6,54,"E"]
[101,"Apple","North",26,24,"C"]
[105,"Mango","North",35,17,"D"]
[109,"Orange","North",65,14,"E"]
[113,"Grapes","North",63,95,"A"]
[117,"Banana","North",98,95,"E"]
[121,"Apple","North",88,54,"A"]
[125,"Mango","North",36,24,"B"]
[129,"Orange","North",48,17,"C"]
[133,"Grapes","North",98,14,"E"]
[137,"Banana","North",87,95,"C"]
[141,"Apple","North",45,95,"D"]
[145,"Mango","North",99,54,"E"]
[149,"Orange","North",77,24,"A"]
[null,null,"North Total",{"$f":"SUBTOTAL(9,D79:D116)","v":4210},{"$f":"SUBTOTAL(9,E79:E116)","v":1872}]
[3,"Grapes","East",142,48,"E"," "]
[7,"Banana","East",98,77,"A"]
[11,"Apple","East",87,57,"B"]
[15,"Mango","East",45,17,"C"]
[19,"Orange","East",99,45,"E"]
[23,"Grapes","East",324,35,"A"]
[27,"Banana","East",45,48,"B"]
[31,"Apple","East",321,77,"C"]
[35,"Mango","East",4,57,"A"]
[39,"Orange","East",140,17,"B"]
[43,"Grapes","East",22,45,"C"]
[47,"Banana","East",652,35,"D"]
[51,"Apple","East",6,48,"B"]
[55,"Mango","East",26,77,"C"]
[59,"Orange","East",85,57,"D"]
[63,"Grapes","East",37,17,"E"]
[67,"Banana","East",35,45,"D"]
[71,"Apple","East",65,35,"E"]
[75,"Mango","East",63,48,"A"]
[79,"Orange","East",98,77,"B"]
[83,"Grapes","East",88,57,"D"]
[87,"Banana","East",142,17,"E"]
[91,"Apple","East",98,45,"A"]
[95,"Mango","East",87,35,"B"]
[99,"Orange","East",45,48,"C"]
[103,"Grapes","East",99,77,"A"]
[107,"Banana","East",324,57,"B"]
[111,"Apple","East",45,17,"C"]
[115,"Mango","East",321,45,"D"]
[119,"Orange","East",4,35,"C"]
[123,"Grapes","East",24,48,"D"]
[127,"Banana","East",9,77,"E"]
[131,"Apple","East",22,57,"A"]
[135,"Mango","East",652,17,"E"]
[139,"Orange","East",6,45,"A"]
[143,"Grapes","East",26,35,"B"]
[147,"Banana","East",85,48,"C"]
[null,null,"East Total",{"$f":"SUBTOTAL(9,D118:D154)","v":4471},{"$f":"SUBTOTAL(9,E118:E154)","v":1722}]
[null,null,"Grand Total",{"$f":"SUBTOTAL(9,D2:D154)","v":16918},{"$f":"SUBTOTAL(9,E2:E154)","v":8390}]

{"sheet":"ByItem","index":8,"n_rows":157,"n_cols":7,"rows_kept":157,"cut":false,"hidden":false,"merged":[]}
["No","Item","Region","Price","Quantity","Company"]
[4,"Orange","West",324,87,"D"]
[9,"Orange","North",652,17,"D"]
[14,"Orange","South",98,33,"D"]
[19,"Orange","East",99,45,"E"]
[24,"Orange","West",22,44,"E"]
[29,"Orange","North",63,24,"E"]
[34,"Orange","South",45,33,"B"]
[39,"Orange","East",140,17,"B"]
[44,"Orange","West",65,72,"B"]
[49,"Orange","North",87,54,"B"]
[54,"Orange","South",4,36,"D"]
[59,"Orange","East",85,57,"D"]
[64,"Orange","West",48,88,"D"]
[69,"Orange","North",324,95,"B"]
[74,"Orange","South",652,95,"B"]
[79,"Orange","East",98,77,"B"]
[84,"Orange","West",99,99,"C"]
[89,"Orange","North",22,95,"C"]
[94,"Orange","South",63,17,"C"]
[99,"Orange","East",45,48,"C"]
[104,"Orange","West",140,94,"E"]
[109,"Orange","North",65,14,"E"]
[114,"Orange","South",87,65,"E"]
[119,"Orange","East",4,35,"C"]
[124,"Orange","West",85,87,"C"]
[129,"Orange","North",48,17,"C"]
[134,"Orange","South",45,33,"A"]
[139,"Orange","East",6,45,"A"]
[144,"Orange","West",88,44,"A"]
[149,"Orange","North",77,24,"A"]
[null,"Orange Total",null,{"$f":"SUBTOTAL(9,D2:D31)","v":3680},{"$f":"SUBTOTAL(9,E2:E31)","v":1591}]
[5,"Mango","North",22,24,"C"]
[10,"Mango","South",63,33,"C"]
[15,"Mango","East",45,17,"C"]
[20,"Mango","West",140,72,"D"]
[25,"Mango","North",65,54,"D"]
[30,"Mango","South",87,36,"D"]
[35,"Mango","East",4,57,"A"]
[40,"Mango","West",35,88,"A"]
[45,"Mango","North",98,95,"A"]
[50,"Mango","South",321,95,"C"]
[55,"Mango","East",26,77,"C"]
[60,"Mango","West",36,99,"C"]
[65,"Mango","North",88,95,"C"]
[70,"Mango","South",22,17,"A"]
[75,"Mango","East",63,48,"A"]
[80,"Mango","West",45,94,"A"]
[85,"Mango","North",140,14,"B"]
[90,"Mango","South",65,65,"B"]
[95,"Mango","East",87,35,"B"]
[100,"Mango","West",4,87,"D"]
[105,"Mango","North",35,17,"D"]
[110,"Mango","South",98,33,"D"]
[115,"Mango","East",321,45,"D"]
[120,"Mango","West",26,44,"B"]
[125,"Mango","North",36,24,"B"]
[130,"Mango","South",88,33,"B"]
[135,"Mango","East",652,17,"E"]
[140,"Mango","West",98,72,"E"]
[145,"Mango","North",99,54,"E"]
[150,"Mango","South",9,36,"A"]
[null,"Mango Total",null,{"$f":"SUBTOTAL(9,D33:D62)","v":2918},{"$f":"SUBTOTAL(9,E33:E62)","v":1577}]
[3,"Grapes","East",142,48,"E"," "]
[8,"Grapes","West",45,94,"E"]
[13,"Grapes","North",6,14,"E"]
[18,"Grapes","South",88,65,"A"]
[23,"Grapes","East",324,35,"A"]
[28,"Grapes","West",652,87,"A"]
[33,"Grapes","North",98,17,"A"]
[38,"Grapes","South",99,33,"C"]
[43,"Grapes","East",22,45,"C"]
[48,"Grapes","West",63,44,"C"]
[53,"Grapes","North",45,24,"E"]
[58,"Grapes","South",24,33,"E"]
[63,"Grapes","East",37,17,"E"]
[68,"Grapes","West",142,72,"C"]
[73,"Grapes","North",45,54,"C"]
[78,"Grapes","South",6,36,"C"]
[83,"Grapes","East",88,57,"D"]
[88,"Grapes","West",324,88,"D"]
[93,"Grapes","North",652,95,"D"]
[98,"Grapes","South",98,95,"D"]
[103,"Grapes","East",99,77,"A"]
[108,"Grapes","West",22,99,"A"]
[113,"Grapes","North",63,95,"A"]
[118,"Grapes","South",45,17,"D"]
[123,"Grapes","East",24,48,"D"]
[128,"Grapes","West",37,94,"D"]
[133,"Grapes","North",98,14,"E"]
[138,"Grapes","South",321,65,"B"]
[143,"Grapes","East",26,35,"B"]
[148,"Grapes","West",36,87,"B"]
[null,"Grapes Total",null,{"$f":"SUBTOTAL(9,D64:D93)","v":3771},{"$f":"SUBTOTAL(9,E64:E93)","v":1684}]
[2,"Banana","South",35,95,"A"]
[7,"Banana","East",98,77,"A"]
[12,"Banana","West",321,99,"A"]
[17,"Banana","North",26,95,"B"]
[22,"Banana","South",142,17,"B"]
[27,"Banana","East",45,48,"B"]
[32,"Banana","West",6,94,"B"]
[37,"Banana","North",88,14,"D"]
[42,"Banana","South",324,65,"D"]
[47,"Banana","East",652,35,"D"]
[52,"Banana","West",98,87,"A"]
[57,"Banana","North",99,17,"A"]
[62,"Banana","South",9,33,"A"]
[67,"Banana","East",35,45,"D"]
[72,"Banana","West",98,44,"D"]
[77,"Banana","North",321,24,"D"]
[82,"Banana","South",26,33,"D"]
[87,"Banana","East",142,17,"E"]
[92,"Banana","West",45,72,"E"]
[97,"Banana","North",6,54,"E"]
[102,"Banana","South",88,36,"B"]
[107,"Banana","East",324,57,"B"]
[112,"Banana","West",652,88,"B"]
[117,"Banana","North",98,95,"E"]
[122,"Banana","South",99,95,"E"]
[127,"Banana","East",9,77,"E"]
[132,"Banana","West",65,99,"E"]
[137,"Banana","North",87,95,"C"]
[142,"Banana","South",4,17,"C"]
[147,"Banana","East",85,48,"C"]
[null,"Banana Total",null,{"$f":"SUBTOTAL(9,D95:D124)","v":4127},{"$f":"SUBTOTAL(9,E95:E124)","v":1772}]
[1,"Apple","North",140,54,"B"]
[6,"Apple","South",65,36,"B"]
[11,"Apple","East",87,57,"B"]
[16,"Apple","West",4,88,"B"]
[21,"Apple","North",35,95,"C"]
[26,"Apple","South",98,95,"C"]
[31,"Apple","East",321,77,"C"]
[36,"Apple","West",26,99,"E"]
[41,"Apple","North",142,95,"E"]
[46,"Apple","South",45,17,"E"]
[51,"Apple","East",6,48,"B"]
[56,"Apple","West",88,94,"B"]
[61,"Apple","North",77,14,"B"]
[66,"Apple","South",140,65,"C"]
[71,"Apple","East",65,35,"E"]
[76,"Apple","West",87,87,"E"]
[81,"Apple","North",4,17,"E"]
[86,"Apple","South",35,33,"A"]
[91,"Apple","East",98,45,"A"]
[96,"Apple","West",321,44,"A"]
[101,"Apple","North",26,24,"C"]
[106,"Apple","South",142,33,"C"]
[111,"Apple","East",45,17,"C"]
[116,"Apple","West",6,72,"D"]
[121,"Apple","North",88,54,"A"]
[126,"Apple","South",77,36,"A"]
[131,"Apple","East",22,57,"A"]
[136,"Apple","West",63,88,"D"]
[141,"Apple","North",45,95,"D"]
[146,"Apple","South",24,95,"D"]
[null,"Apple Total",null,{"$f":"SUBTOTAL(9,D126:D155)","v":2422},{"$f":"SUBTOTAL(9,E126:E155)","v":1766}]
[null,"Grand Total",null,{"$f":"SUBTOTAL(9,D2:D155)","v":16918},{"$f":"SUBTOTAL(9,E2:E155)","v":8390}]