{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","mixed references","array formula","If function","VBA"],"not_rendered":{"charts":0,"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":"Dataset","index":0,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"Make Multiplication Table  In Excel"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]

{"sheet":"mixed references","index":1,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"Using Mixed References"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10]
[null,1,{"$f":"C$4*$B5","v":1},{"$f":"D$4*$B5","v":2},3,4,5,6,7,8,9,10]
[null,2,{"$f":"C$4*$B6","v":2},4,6,8,10,12,14,16,18,20]
[null,3,3,6,9,12,15,18,21,24,27,30]
[null,4,4,8,12,16,20,24,28,32,36,40]
[null,5,5,10,15,20,25,30,35,40,45,50,null,null,null,null,null,null,null,null,null,"Mie"]
[null,6,6,12,18,24,30,36,42,48,54,60]
[null,7,7,14,21,28,35,42,49,56,63,70]
[null,8,8,16,24,32,40,48,56,64,72,80]
[null,9,9,18,27,36,45,54,63,72,81,90]
[null,10,10,20,30,40,50,60,70,80,90,100]

{"sheet":"array formula","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"Using Array Formula"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10]
[null,1,{"$f":"B5:B14*C4:L4","v":1},2,3,4,5,6,7,8,9,10]
[null,2,2,4,6,8,10,12,14,16,18,20]
[null,3,3,6,9,12,15,18,21,24,27,30]
[null,4,4,8,12,16,20,24,28,32,36,40]
[null,5,5,10,15,20,25,30,35,40,45,50]
[null,6,6,12,18,24,30,36,42,48,54,60]
[null,7,7,14,21,28,35,42,49,56,63,70]
[null,8,8,16,24,32,40,48,56,64,72,80]
[null,9,9,18,27,36,45,54,63,72,81,90]
[null,10,10,20,30,40,50,60,70,80,90,100]

{"sheet":"If function","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,11]]}
[]
[null,"Using IF Function"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10]
[null,1,{"$f":"IF(C$4>$B5,C$4*$B5,C$4*$B5)","v":1},{"$f":"IF(D$4>$B5,D$4*$B5,D$4*$B5)","v":2},3,4,5,6,7,8,9,10]
[null,2,{"$f":"IF(C$4>$B6,C$4*$B6,C$4*$B6)","v":2},4,6,8,10,12,14,16,18,20]
[null,3,3,6,9,12,15,18,21,24,27,30]
[null,4,4,8,12,16,20,24,28,32,36,40]
[null,5,5,10,15,20,25,30,35,40,45,50]
[null,6,6,12,18,24,30,36,42,48,54,60]
[null,7,7,14,21,28,35,42,49,56,63,70]
[null,8,8,16,24,32,40,48,56,64,72,80]
[null,9,9,18,27,36,45,54,63,72,81,90]
[null,10,10,20,30,40,50,60,70,80,90,100]

{"sheet":"VBA","index":4,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,10]]}
[]
[null,"Using VBA"]
[]
[null,1,2,3,4,5,6,7,8,9,10]
[null,2,4,6,8,10,12,14,16,18,20]
[null,3,6,9,12,15,18,21,24,27,30]
[null,4,8,12,16,20,24,28,32,36,40]
[null,5,10,15,20,25,30,35,40,45,50]
[null,6,12,18,24,30,36,42,48,54,60]
[null,7,14,21,28,35,42,49,56,63,70]
[null,8,16,24,32,40,48,56,64,72,80]
[null,9,18,27,36,45,54,63,72,81,90]
[null,10,20,30,40,50,60,70,80,90,100]