{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cell Value","Interactive","Sheet3","Sheet4"],"not_rendered":{"charts":1,"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":"Cell Value","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Apply Formula to Check Box \nBased on a Cell Value"]
[]
[null,"Check Box","Cell Linked","Value"]
[null,null,true,{"$f":"IF(C5,\"ExcelDemy\", \" \")","v":"ExcelDemy"}]

{"sheet":"Interactive","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[13,1,13,2],[12,1,12,2]]}
[]
[null,"Apply Formula to Check Box to Make an \nInteractive Analysis"]
[]
[null,"Products","Check Box","Status",null,"Cell Linked"]
[null,"Chicken",null,{"$f":"IF(F5,\"Sold\",\"Unsold\")","v":"Sold"},null,true]
[null,"Sausage",null,{"$f":"IF(F6,\"Sold\",\"Unsold\")","v":"Unsold"},null,false]
[null,"Sugar",null,{"$f":"IF(F7,\"Sold\",\"Unsold\")","v":"Sold"},null,true]
[null,"Cake",null,{"$f":"IF(F8,\"Sold\",\"Unsold\")","v":"Unsold"},null,false]
[null,"Beef",null,{"$f":"IF(F9,\"Sold\",\"Unsold\")","v":"Sold"},null,true]
[null,"Oats",null,{"$f":"IF(F10,\"Sold\",\"Unsold\")","v":"Unsold"},null,false]
[null,"Cheese",null,{"$f":"IF(F11,\"Sold\",\"Unsold\")","v":"Unsold"},null,false]
[]
[null,"Number of Products Sold",null,{"$f":"COUNTIF(F5:F11,TRUE)","v":3}]
[null,"Percentage of Products Sold",null,{"$f":"(D13/7)","v":0.42857142857142855}]

{"sheet":"Sheet3","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Apply Formula to Check Box to \nCreate an Dynamic Chart"]
[]
[null,"Products","Jan","Feb","Mar","Apr"]
[null,"Mild Steel",4.4999999999999998E-2,3.5000000000000003E-2,4.65E-2,5.6000000000000001E-2]
[null,"High Carbon Steel",5.1999999999999998E-2,3.6999999999999998E-2,3.8699999999999998E-2,3.4500000000000003E-2]
[]
[null,"Mild Steel",null,true]
[null,"High Carbon Steel",null,true]
[]
[null,"Products","Jan","Feb","Mar","Apr"]
[null,"Mild Steel",{"$f":"IF($D$8,C5, \"N/A\")","v":4.4999999999999998E-2},{"$f":"IF($D$8,D5, \"N/A\")","v":3.5000000000000003E-2},{"$f":"IF($D$8,E5, \"N/A\")","v":4.65E-2},{"$f":"IF($D$8,F5, \"N/A\")","v":5.6000000000000001E-2}]
[null,"High Carbon Steel",{"$f":"IF($D$9,C6, \"N/A\")","v":5.1999999999999998E-2},{"$f":"IF($D$9,D6, \"N/A\")","v":3.6999999999999998E-2},{"$f":"IF($D$9,E6, \"N/A\")","v":3.8699999999999998E-2},{"$f":"IF($D$9,F6, \"N/A\")","v":3.4500000000000003E-2}]

{"sheet":"Sheet4","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Apply Formula to Check Box with VBA"]
[]
[null,"Check Box","Value"]
[null,null,"ExcelDemy"]