{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["main","Insert","VBA"],"not_rendered":{"charts":3,"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":"main","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Show Percentage in 100 Stacked Column Chart"]
[]
[null,"Country","Sales Q1","Sales Q2"]
[null,"USA",500,600]
[null,"Canada",1100,875]
[null,"Mexico",240,456]
[null,"Honduras",345,250]

{"sheet":"Insert","index":1,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Value From Cells",null,null,null,"Practice"]
[]
[null,"Country","Sales Q1","Sales Q2",null,"Country","Sales Q1","Sales Q2"]
[null,"USA",500,600,null,"USA",500,600]
[null,"Canada",1100,875,null,"Canada",1100,875]
[null,"Mexico",240,456,null,"Mexico",240,456]
[null,"Honduras",345,250,null,"Honduras",345,250]
[null,"Total",{"$f":"SUM(C5:C8)","v":2185},2181,null,"Total",{"$f":"SUM(G5:G8)","v":2185},2181]
[]
[null,"Country","Sales Q1","Sales Q2",null,"Country","Sales Q1","Sales Q2"]
[null,"USA",{"$f":"C5/C$9","v":0.2288329519450801},{"$f":"D5/D$9","v":0.27510316368638238},null,"USA"]
[null,"Canada",{"$f":"C6/C$9","v":0.50343249427917625},0.40119211370930763,null,"Canada"]
[null,"Mexico",0.10983981693363844,0.20907840440165062,null,"Mexico"]
[null,"Honduras",0.15789473684210525,0.11462631820265932,null,"Honduras"]
[null,"Total",1,1,null,"Total"]

{"sheet":"VBA","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying VBA",null,null,null,"Practice"]
[]
[null,"Country","Sales Q1","Sales Q2",null,"Country","Sales Q1","Sales Q2"]
[null,"USA",500,600,null,"USA",500,600]
[null,"Canada",1100,875,null,"Canada",1100,875]
[null,"Mexico",240,456,null,"Mexico",240,456]
[null,"Honduras",345,250,null,"Honduras",345,250]
[null,"Total",{"$f":"SUM(C5:C8)","v":2185},2181,null,"Total",{"$f":"SUM(G5:G8)","v":2185},2181]
[]
[null,"Country","Sales Q1","Sales Q2",null,"Country","Sales Q1","Sales Q2"]
[null,"USA",{"$f":"C5/C$9","v":0.2288329519450801},{"$f":"D5/D$9","v":0.27510316368638238},null,"USA",{"$f":"G5/G$9","v":0.2288329519450801},{"$f":"H5/H$9","v":0.27510316368638238}]
[null,"Canada",{"$f":"C6/C$9","v":0.50343249427917625},0.40119211370930763,null,"Canada",{"$f":"G6/G$9","v":0.50343249427917625},0.40119211370930763]
[null,"Mexico",0.10983981693363844,0.20907840440165062,null,"Mexico",{"$f":"G7/G$9","v":0.10983981693363844},0.20907840440165062]
[null,"Honduras",0.15789473684210525,0.11462631820265932,null,"Honduras",{"$f":"G8/G$9","v":0.15789473684210525},0.11462631820265932]
[null,"Total",1,1,null,"Total",{"$f":"G9/G$9","v":1},1]