{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Insertion of Bar Chart","Use of Conditional Formatting","Use of VBA Code"],"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":"Insertion of Bar Chart","index":0,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Insertion of Bar Chart",null,null,null,null,null,"Try Yourself"]
[]
[null,"Sl. No.","Year ","Forecasted Slaes","Actual Sales",null,null,"Sl. No.","Year ","Forecasted Slaes","Actual Sales"]
[null,1,2015,300000,250000,null,null,1,2015,300000,250000]
[null,2,2016,500000,445000,null,null,2,2016,500000,445000]
[null,3,2017,600000,550000,null,null,3,2017,600000,550000]
[null,4,2018,800000,790000,null,null,4,2018,800000,790000]
[null,5,2019,900000,880000,null,null,5,2019,900000,880000]
[null,6,2020,1200000,1100000,null,null,6,2020,1200000,1100000]
[null,7,2021,1500000,1450000,null,null,7,2021,1500000,1450000]

{"sheet":"Use of Conditional Formatting","index":1,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,11]]}
[]
[null,"Use of Conditional Formatting",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sl. No.","Year ","Forecasted Slaes","Actual Sales","Achivement Percentage",null,null,"Sl. No.","Year ","Forecasted Slaes","Actual Sales"]
[null,1,2015,300000,250000,{"$f":"E5/D5","v":0.83333333333333337},null,null,1,2015,300000,250000]
[null,2,2016,500000,445000,{"$f":"E6/D6","v":0.89},null,null,2,2016,500000,445000]
[null,3,2017,600000,550000,0.91666666666666663,null,null,3,2017,600000,550000]
[null,4,2018,800000,790000,0.98750000000000004,null,null,4,2018,800000,790000]
[null,5,2019,900000,880000,0.97777777777777775,null,null,5,2019,900000,880000]
[null,6,2020,1200000,1100000,0.91666666666666663,null,null,6,2020,1200000,1100000]
[null,7,2021,1500000,1450000,0.96666666666666667,null,null,7,2021,1500000,1450000]

{"sheet":"Use of VBA Code","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Sl. No.","Year ","Forecasted Slaes","Actual Sales","Achivement Percentage"]
[null,1,2015,300000,250000,{"$f":"E5/D5","v":0.83333333333333337}]
[null,2,2016,500000,445000,{"$f":"E6/D6","v":0.89}]
[null,3,2017,600000,550000,0.91666666666666663]
[null,4,2018,800000,790000,0.98750000000000004]
[null,5,2019,900000,880000,0.97777777777777775]
[null,6,2020,1200000,1100000,0.91666666666666663]
[null,7,2021,1500000,1450000,0.96666666666666667]