{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["DATASET","Subtotal_Formula","Subtotal_Ribbon","Subtotal_Total row","Aggregate","VBA Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"DATASET","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sum  Columns in Excel When Filtered"]
[]
[null,"Componenets","Manufacturer","Country of \nManufacture","Quanttiy","Unit Price","Total Price"]
[null,"Motherboard","MSI","China",50,200,{"$f":"F5*E5","v":10000}]
[null,"Cpu","AMD","Vietnam",55,340,{"$f":"F6*E6","v":18700}]
[null,"Gpu","Nvidia","Taiwan",35,450,15750]
[null,"Monitor","LG","China",154,200,30800]
[null,"SSD","Samsung","South Korea",65,150,9750]
[null,"HDD","Toshiba","Japan",12,65,780]
[null,"Cooler","Toshiba","Japan",35,45,1575]
[null,"Usb Hub","Baseus","China",25,10,250]
[null,"Ram","Toshiba","Japan",95,70,6650]
[null,"PSU","Apollo","China",45,70,3150]
[null,"Mouse","Logitech ","China",37,85,3145]

{"sheet":"Subtotal_Formula","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sum  Columns in Excel When Filtered"]
[]
[null,"Componenets","Manufacturer","Country of \nManufacture","Quanttiy","Unit Price","Total Price"]
[null,"Motherboard","MSI","China",50,200,{"$f":"F5*E5","v":10000}]
[null,"Cpu","AMD","Vietnam",55,340,{"$f":"F6*E6","v":18700}]
[null,"Gpu","Nvidia","Taiwan",35,450,15750]
[null,"Monitor","LG","China",154,200,30800]
[null,"SSD","Samsung","South Korea",65,150,9750]
[null,"HDD","Toshiba","Japan",12,65,780]
[null,"Cooler","Toshiba","Japan",35,45,1575]
[null,"Usb Hub","Baseus","China",25,10,250]
[null,"Ram","Toshiba","Japan",95,70,6650]
[null,"PSU","Apollo","China",45,70,3150]
[null,"Mouse","Logitech ","China",37,85,3145]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,G5:G15)","v":47345}]

{"sheet":"Subtotal_Ribbon","index":2,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sum  Columns in Excel When Filtered"]
[]
[null,"Componenets","Manufacturer","Country of \nManufacture","Quanttiy","Unit Price","Total Price"]
[null,"Motherboard","MSI","China",50,200,{"$f":"F5*E5","v":10000}]
[null,"Cpu","AMD","Vietnam",55,340,{"$f":"F6*E6","v":18700}]
[null,"Gpu","Nvidia","Taiwan",35,450,15750]
[null,"Monitor","LG","China",154,200,30800]
[null,"SSD","Samsung","South Korea",65,150,9750]
[null,"HDD","Toshiba","Japan",12,65,780]
[null,"Cooler","Toshiba","Japan",35,45,1575]
[null,"Usb Hub","Baseus","China",25,10,250]
[null,"Ram","Toshiba","Japan",95,70,6650]
[null,"PSU","Apollo","China",45,70,3150]
[null,"Mouse","Logitech ","China",37,85,3145]
[]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,G5:G16)","v":47345}]

{"sheet":"Subtotal_Total row","index":3,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sum  Columns in Excel When Filtered"]
[]
[null,"Componenets","Manufacturer","Country of \nManufacture","Quanttiy","Unit Price","Total Price"]
[null,"Motherboard","MSI","China",50,200,{"$f":"F5*E5","v":10000}]
[null,"Cpu","AMD","Vietnam",55,340,{"$f":"F6*E6","v":18700}]
[null,"Gpu","Nvidia","Taiwan",35,450,15750]
[null,"Monitor","LG","China",154,200,30800]
[null,"SSD","Samsung","South Korea",65,150,9750]
[null,"HDD","Toshiba","Japan",12,65,780]
[null,"Cooler","Toshiba","Japan",35,45,1575]
[null,"Usb Hub","Baseus","China",25,10,250]
[null,"Ram","Toshiba","Japan",95,70,6650]
[null,"PSU","Apollo","China",45,70,3150]
[null,"Mouse","Logitech ","China",37,85,3145]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table5[Total Price])","v":9005}]

{"sheet":"Aggregate","index":4,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sum  Columns in Excel When Filtered"]
[]
[null,"Componenets","Manufacturer","Country of \nManufacture","Quanttiy","Unit Price","Total Price"]
[null,"Motherboard","MSI","China",50,200,{"$f":"F5*E5","v":10000}]
[null,"Cpu","AMD","Vietnam",55,340,{"$f":"F6*E6","v":18700}]
[null,"Gpu","Nvidia","Taiwan",35,450,15750]
[null,"Monitor","LG","China",154,200,30800]
[null,"SSD","Samsung","South Korea",65,150,9750]
[null,"HDD","Toshiba","Japan",12,65,780]
[null,"Cooler","Toshiba","Japan",35,45,1575]
[null,"Usb Hub","Baseus","China",25,10,250]
[null,"Ram","Toshiba","Japan",95,70,6650]
[null,"PSU","Apollo","China",45,70,3150]
[null,"Mouse","Logitech ","China",37,85,3145]
[]
[]
[null,null,null,null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,G5:G15)","v":47345}]

{"sheet":"VBA Macro","index":5,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Sum  Columns in Excel When Filtered"]
[]
[null,"Componenets","Manufacturer","Country of \nManufacture","Quanttiy","Unit Price","Total Price"]
[null,"Motherboard","MSI","China",50,200,{"$f":"F5*E5","v":10000}]
[null,"Cpu","AMD","Vietnam",55,340,{"$f":"F6*E6","v":18700}]
[null,"Gpu","Nvidia","Taiwan",35,450,15750]
[null,"Monitor","LG","China",154,200,30800]
[null,"SSD","Samsung","South Korea",65,150,9750]
[null,"HDD","Toshiba","Japan",12,65,780]
[null,"Cooler","Toshiba","Japan",35,45,1575]
[null,"Usb Hub","Baseus","China",25,10,250]
[null,"Ram","Toshiba","Japan",95,70,6650]
[null,"PSU","Apollo","China",45,70,3150]
[null,"Mouse","Logitech ","China",37,85,3145]
[null,null,null,null,null,null,{"$f":"SumColumn(Table4[Total Price])","v":44200}]