{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Transposing Columns","Sort Feature","Index Function","VBA"],"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":"Transposing Columns","index":0,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Transposing Columns"]
[]
[null,"Bakery Item","Bread","Milk Bread","Cup Cake","Vanilla Cake","Chocolate Cake"]
[null,"Quantity",20,14,35,22,17]
[null,"Price($)",2,3,5,10,12]
[null,"Commission($)",1,1,2,3,4]
[null,"Production Cost($)",1,1,2,3,6]
[]
[null,"Bakery Item","Quantity","Price($)","Commission($)","Production Cost($)","Helper Column",null,"Bakery Item","Quantity","Price($)","Commission($)","Production Cost($)","Helper Column"]
[null,"Bread",20,2,1,1,1,null,"Chocolate Cake",17,12,5,6,5]
[null,"Milk Bread",14,3,1,1,2,null,"Vanilla Cake",22,10,3,3,4]
[null,"Cup Cake",35,5,2,2,3,null,"Cup Cake",35,5,2,2,3]
[null,"Vanilla Cake",22,10,3,3,4,null,"Milk Bread",14,3,1,1,2]
[null,"Chocolate Cake",17,12,5,6,5,null,"Bread",20,2,1,1,1]
[]
[]
[]
[null,null,null,null,null,null,null,"Bakery Item","Chocolate Cake","Vanilla Cake","Cup Cake","Milk Bread","Bread"]
[null,null,null,null,null,null,null,"Quantity",17,22,35,14,20]
[null,null,null,null,null,null,null,"Price($)",12,10,5,3,2]
[null,null,null,null,null,null,null,"Commission($)",5,3,2,1,1]
[null,null,null,null,null,null,null,"Production Cost($)",6,3,2,1,1]

{"sheet":"Sort Feature","index":1,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Utilizing Sort Feature"]
[]
[null,"Bakery Item","Bread","Milk Bread","Cup Cake","Vanilla Cake","Chocolate Cake",null,null,null,"Bakery Item","Chocolate Cake","Vanilla Cake","Cup Cake","Milk Bread","Bread"]
[null,"Quantity",20,14,35,22,17,null,null,null,"Quantity",17,22,35,14,20]
[null,"Price($)",2,3,5,10,12,null,null,null,"Price($)",12,10,5,3,2]
[null,"Commission($)",1,1,2,3,4,null,null,null,"Commission($)",4,3,2,1,1]
[null,"Production Cost($)",1,1,2,3,6,null,null,null,"Production Cost($)",6,3,2,1,1]
[null,"Helper Row",1,2,3,4,5,null,null,null,"Helper Row",5,4,3,2,1]

{"sheet":"Index Function","index":2,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Combining INDEX and COUNT Functions"]
[]
[null,"Bakery Item","Bread","Milk Bread","Cup Cake","Vanilla Cake","Chocolate Cake"]
[null,"Quantity",20,14,35,22,17]
[null,"Price($)",2,3,5,10,12]
[null,"Commission($)",1,1,2,3,4]
[null,"Production Cost($)",1,1,2,3,6]
[]
[]
[null,"Bakery Item",{"$f":"INDEX($C$4:$G$4,1,COUNTA(C4:G4))","v":"Chocolate Cake"},{"$f":"INDEX($C$4:$G$4,1,COUNTA(D4:H4))","v":"Vanilla Cake"},{"$f":"INDEX($C$4:$G$4,1,COUNTA(E4:I4))","v":"Cup Cake"},{"$f":"INDEX($C$4:$G$4,1,COUNTA(F4:J4))","v":"Milk Bread"},{"$f":"INDEX($C$4:$G$4,1,COUNTA(G4:K4))","v":"Bread"}]
[null,"Quantity",{"$f":"INDEX($C$5:$G$5,1,COUNTA(C5:G5))","v":17},{"$f":"INDEX($C$5:$G$5,1,COUNTA(D5:H5))","v":22},{"$f":"INDEX($C$5:$G$5,1,COUNTA(E5:I5))","v":35},{"$f":"INDEX($C$5:$G$5,1,COUNTA(F5:J5))","v":14},{"$f":"INDEX($C$5:$G$5,1,COUNTA(G5:K5))","v":20}]
[null,"Price($)",{"$f":"INDEX($C$6:$G$6,1,COUNTA(C6:G6))","v":12},{"$f":"INDEX($C$6:$G$6,1,COUNTA(D6:H6))","v":10},{"$f":"INDEX($C$6:$G$6,1,COUNTA(E6:I6))","v":5},{"$f":"INDEX($C$6:$G$6,1,COUNTA(F6:J6))","v":3},{"$f":"INDEX($C$6:$G$6,1,COUNTA(G6:K6))","v":2}]
[null,"Commission($)",{"$f":"INDEX($C$7:$G$7,1,COUNTA(C7:G7))","v":4},{"$f":"INDEX($C$7:$G$7,1,COUNTA(D7:H7))","v":3},{"$f":"INDEX($C$7:$G$7,1,COUNTA(E7:I7))","v":2},{"$f":"INDEX($C$7:$G$7,1,COUNTA(F7:J7))","v":1},{"$f":"INDEX($C$7:$G$7,1,COUNTA(G7:K7))","v":1}]
[null,"Production Cost($)",{"$f":"INDEX($C$8:$G$8,1,COUNTA(C8:G8))","v":6},{"$f":"INDEX($C$8:$G$8,1,COUNTA(D8:H8))","v":3},{"$f":"INDEX($C$8:$G$8,1,COUNTA(E8:I8))","v":2},{"$f":"INDEX($C$8:$G$8,1,COUNTA(F8:J8))","v":1},{"$f":"INDEX($C$8:$G$8,1,COUNTA(G8:K8))","v":1}]

{"sheet":"VBA","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Applying VBA"]
[]
[null,"Bakery Item","Bread","Milk Bread","Cup Cake","Vanilla Cake","Chocolate Cake"]
[null,"Quantity",20,14,35,22,17]
[null,"Price($)",2,3,5,10,12]
[null,"Commission($)",1,1,2,3,4]
[null,"Production Cost($)",1,1,2,3,6]
[]
[]
[]
[null,"Bakery Item","Chocolate Cake","Vanilla Cake","Cup Cake","Milk Bread","Bread"]
[null,"Quantity",17,22,35,14,20]
[null,"Price($)",12,10,5,3,2]
[null,"Commission($)",4,3,2,1,1]
[null,"Production Cost($)",6,3,2,1,1]