{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Basic Datasheet","SUMIF Function","AutoFilter and SUBTOTAL","GET.CELL","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Basic Datasheet","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Product Price List"]
[]
[null,"Product ID","Quantity","Price"]
[null,"MTT102GL",21,1575]
[null,"MTT103GL",25,2710]
[null,"MTT104GL",30,2850]
[null,"OP522NPP",24,2590]
[null,"OP551NPP",23,2078]
[null,"OP666NPP",28,1615]
[null,"71VX40NQ",20,1885]
[null,"71VX41NQ",28,1771]
[null,"71VX42NQ",25,2220]

{"sheet":"SUMIF Function","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Usage of the SUMIF Function",null,null,null,null,null,"Practice Here"]
[]
[null,"Product ID","Quantity","Price","Color",null,null,"Product ID","Quantity","Price","Color"]
[null,"MTT102GL",21,1575,"Blue",null,null,"MTT102GL",21,1575,"Blue"]
[null,"MTT103GL",25,2710,"Blue",null,null,"MTT103GL",25,2710,"Blue"]
[null,"MTT104GL",30,2850,"Blue",null,null,"MTT104GL",30,2850,"Blue"]
[null,"OP522NPP",24,2590,"White",null,null,"OP522NPP",24,2590,"White"]
[null,"OP551NPP",23,2078,"White",null,null,"OP551NPP",23,2078,"White"]
[null,"OP666NPP",28,1615,"White",null,null,"OP666NPP",28,1615,"White"]
[null,"71VX40NQ",20,1885,"White",null,null,"71VX40NQ",20,1885,"White"]
[null,"71VX41NQ",28,1771,"White",null,null,"71VX41NQ",28,1771,"White"]
[null,"71VX42NQ",25,2220,"White",null,null,"71VX42NQ",25,2220,"White"]
[]
[null,"Product ID","MTT102GL",null,null,null,null,"Product ID","MTT102GL"]
[null,"Price",{"$f":"SUMIF(E5:E13,\"Blue\",D5:D13)","v":7135},null,null,null,null,"Price"]

{"sheet":"AutoFilter and SUBTOTAL","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Usage of AutoFilter and SUBTOTAL",null,null,null,null,null,"Practice Here"]
[]
[null,"Product ID","Quantity","Price",null,null,null,"Product ID","Quantity","Price"]
[null,"MTT102GL",21,1575,null,null,null,"MTT102GL",21,1575]
[null,"MTT103GL",25,2710,null,null,null,"MTT103GL",25,2710]
[null,"MTT104GL",30,2850,null,null,null,"MTT104GL",30,2850]
[null,"OP522NPP",24,2590,null,null,null,"OP522NPP",24,2590]
[null,"OP551NPP",23,2078,null,null,null,"OP551NPP",23,2078]
[null,"OP666NPP",28,1615,null,null,null,"OP666NPP",28,1615]
[null,"71VX40NQ",20,1885,null,null,null,"71VX40NQ",20,1885]
[null,"71VX41NQ",28,1771,null,null,null,"71VX41NQ",28,1771]
[null,"71VX42NQ",25,2220,null,null,null,"71VX42NQ",25,2220]
[]
[null,"Product ID","MTT102GL",null,null,null,null,"Product ID","MTT102GL"]
[null,"Price",{"$f":"SUBTOTAL(109,D5:D7)","v":7135},null,null,null,null,"Price"]
[null,null,null,null,null,null,null," "]

{"sheet":"GET.CELL","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,6,1,8],[1,1,1,4]]}
[]
[null,"Usage of GET.CELL Function",null,null,null,null,"Practice Here"]
[]
[null,"Product ID","Quantity","Price","Color Code",null,"Product ID","Quantity","Price"]
[null,"MTT102GL",21,1575,{"$f":"Code","v":33},null,"MTT102GL",21,1575]
[null,"MTT103GL",25,2710,{"$f":"Code","v":33},null,"MTT103GL",25,2710]
[null,"MTT104GL",30,2850,{"$f":"Code","v":33},null,"MTT104GL",30,2850]
[null,"OP522NPP",24,2590,{"$f":"Code","v":0},null,"OP522NPP",24,2590]
[null,"OP551NPP",23,2078,{"$f":"Code","v":0},null,"OP551NPP",23,2078]
[null,"OP666NPP",28,1615,{"$f":"Code","v":0},null,"OP666NPP",28,1615]
[null,"71VX40NQ",20,1885,{"$f":"Code","v":0},null,"71VX40NQ",20,1885]
[null,"71VX41NQ",28,1771,{"$f":"Code","v":0},null,"71VX41NQ",28,1771]
[null,"71VX42NQ",25,2220,{"$f":"Code","v":0},null,"71VX42NQ",25,2220]
[]
[null,"Product ID","MTT102GL",null,null,null,null,"Product ID","MTT102GL"]
[null,"Price",{"$f":"SUMIF(E5:E13,33,D5:D13)","v":7135},null,null,null,null,"Price"]

{"sheet":"VBA Code","index":4,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Usage of VBA Code",null,null,null,null,null,"Practice Here"]
[]
[null,"Product ID","Quantity","Price",null,null,null,"Product ID","Quantity","Price"]
[null,"MTT102GL",21,1575,null,null,null,"MTT102GL",21,1575]
[null,"MTT103GL",25,2710,null,null,null,"MTT103GL",25,2710]
[null,"MTT104GL",30,2850,null,null,null,"MTT104GL",30,2850]
[null,"OP522NPP",24,2590,null,null,null,"OP522NPP",24,2590]
[null,"OP551NPP",23,2078,null,null,null,"OP551NPP",23,2078]
[null,"OP666NPP",28,1615,null,null,null,"OP666NPP",28,1615]
[null,"71VX40NQ",20,1885,null,null,null,"71VX40NQ",20,1885]
[null,"714VX1NQ",28,1771,null,null,null,"71VX41NQ",28,1771]
[null,"7VX142NQ",25,2220,null,null,null,"71VX42NQ",25,2220]
[]
[null,null,"Color","Total Price",null,null,null,null,"Color","Total Price"]
[null,null,"Yellow",{"$f":"SumColoredCells($D$5,D5:D13)","v":7135}]
[null,null,"Blue",{"$f":"SumColoredCells($D$8,D6:D14)","v":6283}]
[null,null,"Orange",{"$f":"SumColoredCells($D$11,D7:D15)","v":5876}]