{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sample Dataset","Basic Formula","MOD & ROW Functions","VBA","Multiple Rows"],"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":"Sample Dataset","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Inserting Rows Between Data Using Formula"]
[]
[null,"Model","Manufacturer\n","Units Sold"]
[null,"RAV4","Toyota",235]
[null,"Camry","Toyota",278]
[null,"Tacoma","Toyota",236]
[null,"Civic","Honda",144]
[null,"CR-V","Honda",178]
[null,"Accord","Honda",567]
[null,"Silverado","Chevrolet",456]
[null,"Equinox","Chevrolet",123]
[null,"Impala","Chevrolet",87]

{"sheet":"Basic Formula","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,7,2,11]]}
[]
[]
[null,"Inserting Rows Between Data Using Formula",null,null,null,null,null,"Practice"]
[]
[null,"Model","Manufacturer\n","Units Sold","Helper Column 1","Helper Column 2",null,"Model","Manufacturer\n","Units Sold","Helper Column 1","Helper Column 2"]
[null,"RAV4","Toyota",235,null,null,null,"RAV4","Toyota",235]
[null,"Camry","Toyota",278,{"$f":"C6=C7","v":true},null,null,"Camry","Toyota",278]
[null,"Tacoma","Toyota",236,null,{"$f":"C8=C7","v":true},null,"Tacoma","Toyota",236]
[null,null,null,null,null,null,null,"Civic","Honda",144]
[null,"Civic","Honda",144,{"$f":"C8=C10","v":false},null,null,"CR-V","Honda",178]
[null,"CR-V","Honda",178,null,{"$f":"C11=C10","v":true},null,"Accord","Honda",567]
[null,"Accord","Honda",567,{"$f":"C11=C12","v":true},null,null,"Silverado","Chevrolet",456]
[null,null,null,null,null,null,null,"Equinox","Chevrolet",123]
[null,"Silverado","Chevrolet",456,null,{"$f":"C14=C12","v":false},null,"Impala","Chevrolet",87]
[null,"Equinox","Chevrolet",123,{"$f":"C14=C15","v":true}]
[null,"Impala","Chevrolet",87,null,{"$f":"C16=C15","v":true}]

{"sheet":"MOD & ROW Functions","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Inserting Rows Between Data Using Formula",null,null,null,null,"Practice"]
[]
[null,"Model","Manufacturer\n","Units Sold","Helper Column",null,"Model","Manufacturer\n","Units Sold","Helper Column"]
[null,"RAV4","Toyota",235,{"$f":"MOD(ROW(C6)-ROW($C$5)-1,3)","v":0},null,"RAV4","Toyota",235]
[null,"Camry","Toyota",278,{"$f":"MOD(ROW(C7)-ROW($C$5)-1,3)","v":1},null,"Camry","Toyota",278]
[null,"Tacoma","Toyota",236,2,null,"Tacoma","Toyota",236]
[null,null,null,null,null,null,"Civic","Honda",144]
[null,"Civic","Honda",144,1,null,"CR-V","Honda",178]
[null,"CR-V","Honda",178,2,null,"Accord","Honda",567]
[null,"Accord","Honda",567,0,null,"Silverado","Chevrolet",456]
[null,null,null,null,null,null,"Equinox","Chevrolet",123]
[null,"Silverado","Chevrolet",456,2,null,"Impala","Chevrolet",87]
[null,"Equinox","Chevrolet",123,0]
[null,"Impala","Chevrolet",87,1]

{"sheet":"VBA","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,5,2,7]]}
[]
[]
[null,"Inserting Rows Between Data Using Formula",null,null,null,"Practice"]
[]
[null,"Model","Manufacturer\n","Units Sold",null,"Model","Manufacturer\n","Units Sold"]
[null,"RAV4","Toyota",235,null,"RAV4","Toyota",235]
[null,"Camry","Toyota",278,null,"Camry","Toyota",278]
[null,"Tacoma","Toyota",236,null,"Tacoma","Toyota",236]
[null,null,null,null,null,"Civic","Honda",144]
[null,"Civic","Honda",144,null,"CR-V","Honda",178]
[null,"CR-V","Honda",178,null,"Accord","Honda",567]
[null,"Accord","Honda",567,null,"Silverado","Chevrolet",456]
[null,null,null,null,null,"Equinox","Chevrolet",123]
[null,"Silverado","Chevrolet",456,null,"Impala","Chevrolet",87]
[null,"Equinox","Chevrolet",123]
[null,"Impala","Chevrolet",87]

{"sheet":"Multiple Rows","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,5,2,7]]}
[]
[]
[null,"Inserting Multiple Rows Between Data Automatically",null,null,null,"Practice"]
[]
[null,"Model","Manufacturer\n","Units Sold",null,"Model","Manufacturer\n","Units Sold"]
[null,"RAV4","Toyota",235,null,"RAV4","Toyota",235]
[null,"Camry","Toyota",278,null,"Camry","Toyota",278]
[null,"Tacoma","Toyota",236,null,"Tacoma","Toyota",236]
[null,null,null,null,null,"Civic","Honda",144]
[null,null,null,null,null,"CR-V","Honda",178]
[null,null,null,null,null,"Accord","Honda",567]
[null,"Civic","Honda",144,null,"Silverado","Chevrolet",456]
[null,"CR-V","Honda",178,null,"Equinox","Chevrolet",123]
[null,"Accord","Honda",567,null,"Impala","Chevrolet",87]
[null,"Silverado","Chevrolet",456]
[null,"Equinox","Chevrolet",123]
[null,"Impala","Chevrolet",87]