{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Using ThisWorkbook","Using RAND Function and VBA","Pivot Table 1","Pivot Table 2","Pivot Table 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":3},"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":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Refreshing Excel Sheet Automatically VBA"]
[]
[null,"Company","Price"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":2637.95}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":3211.15}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Price\")","v":1486.1}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":1492.95}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":71.5}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":4641.7}]

{"sheet":"Using ThisWorkbook","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using ThisWorkbook Method",null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Company Name","Price",null,null,null,null,"Company Name","Price"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B5,\"Price\")","v":2637.95},null,null,null,null,{"$error":"#VALUE!"},{"$f":"_FV(H5,\"Price\")","v":2637.95}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B6,\"Price\")","v":3211.15},null,null,null,null,{"$error":"#VALUE!"},{"$f":"_FV(H6,\"Price\")","v":3211.15}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B7,\"Price\")","v":1486.1},null,null,null,null,{"$error":"#VALUE!"},{"$f":"_FV(H7,\"Price\")","v":1486.1}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B8,\"Price\")","v":1492.95},null,null,null,null,{"$error":"#VALUE!"},{"$f":"_FV(H8,\"Price\")","v":1492.95}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B9,\"Price\")","v":71.5},null,null,null,null,{"$error":"#VALUE!"},{"$f":"_FV(H9,\"Price\")","v":71.5}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B10,\"Price\")","v":4641.7},null,null,null,null,{"$error":"#VALUE!"},{"$f":"_FV(H10,\"Price\")","v":4641.7}]

{"sheet":"Using RAND Function and VBA","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,7,1,8],[1,1,1,2]]}
[]
[null,"Applying Calculate Method",null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Order No.","Rabdom Number",null,null,null,null,"Order No.","Rabdom Number"]
[null,"P-101",{"$f":"RANDBETWEEN(12,34)","v":24},null,null,null,null,"P-101",{"$f":"RANDBETWEEN(12,34)","v":29}]
[null,"P-102",{"$f":"RANDBETWEEN(12,34)","v":15},null,null,null,null,"P-102",{"$f":"RANDBETWEEN(12,34)","v":28}]
[null,"P-103",33,null,null,null,null,"P-103",14]
[null,"P-104",34,null,null,null,null,"P-104",28]
[null,"P-105",23,null,null,null,null,"P-105",24]
[null,"P-106",24,null,null,null,null,"P-106",14]

{"sheet":"Pivot Table 1","index":3,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Refreshing Pivot Table ",null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Product","Sales","Profit",null,null,null,null,null,"Product","Sales","Profit"]
[null,"Laptop",25000,2000,null,null,null,null,null,"Laptop",25000,2000]
[null,"Mouse",11800,4000,null,null,null,null,null,"Mouse",11800,4000]
[null,"Monitor",18900,6000,null,null,null,null,null,"Monitor",18900,6000]
[null,"Printer",23000,1800,null,null,null,null,null,"Printer",23000,1800]
[null,"Battery",16500,4000,null,null,null,null,null,"Battery",16500,4000]
[]
[]
[null,"Row Labels","Sum of Sales","Sum of Profit"]
[null,"Battery",16500,4000]
[null,"Laptop",25000,2000]
[null,"Monitor",18900,6000]
[null,"Mouse",11800,4000]
[null,"Printer",23000,1800]
[null,"Grand Total",95200,17800]

{"sheet":"Pivot Table 2","index":4,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Refreshing All Pivot Tables ",null,null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Item","Sales","Profit",null,null,null,null,null,"Item","Sales","Profit"]
[null,"Soap",2500,300,null,null,null,null,null,"Soap",2500,300]
[null,"Bread",2220,400,null,null,null,null,null,"Bread",2220,400]
[null,"Milk",1890,650,null,null,null,null,null,"Milk",1890,650]
[null,"Butter",2300,180,null,null,null,null,null,"Butter",2300,180]
[null,"Egg",1650,4000,null,null,null,null,null,"Egg",1650,4000]
[]
[]
[null,"Row Labels","Sum of Sales","Sum of Profit"]
[null,"Bread",2220,400]
[null,"Butter",2300,180]
[null,"Egg",1650,4000]
[null,"Milk",1890,650]
[null,"Soap",2500,300]
[null,"Grand Total",10560,5530]

{"sheet":"Pivot Table 3","index":5,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Refreshing All Pivot Tables",null,null,null,null,null,null,">>> Do Yourself <<<"]
[]
[null,"Month","Sales","Profit",null,null,null,null,"Month","Sales","Profit"]
[null,"January",12000,2000,null,null,null,null,"January",12000,2000]
[null,"February",22200,4000,null,null,null,null,"February",22200,4000]
[null,"March",18900,6000,null,null,null,null,"March",18900,6000]
[null,"April",23000,1800,null,null,null,null,"April",23000,1800]
[null,"May",16500,3300,null,null,null,null,"May",16500,3300]
[]
[null,"Row Labels","Sum of Sales","Sum of Profit"]
[null,"January",12000,2000]
[null,"February",22200,4000]
[null,"March",18900,6000]
[null,"April",23000,1800]
[null,"May",16500,3300]
[null,"Grand Total",92600,17100]