{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dataset","Selection","Numbering","Arithmetic Operations","Change Color"],"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":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Range Operations with Variable Row Number"]
[]
[null,"City","State","Population"]
[null,"New York City","New York",8930002]
[null,"Los Angeles","California",3919973]
[null,"Chicago","Illionis",2756546]
[null,"Houston","Texas",2345606]
[null,"Phoenix","Arizona",1640641]
[null,"Philadelphia","Pennsylvania",1619355]
[null,"San Antonio","Texas",1456069]
[null,"San Diego","California",1402838]
[null,"Dallas","Texas",1325691]
[null,"San Jose","California",1026700]
[null,"Austin","Texas",996147]
[null,"Mesa","Arizona",517302]
[null,"Buffalo","New York",281757]
[null,"Aurora","Illionis",177070]
[null,"Pittsburgh","Pennsylvania",302425]

{"sheet":"Selection","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Selecting a Range with Variable Row Number"]
[]
[null,"City","State","Population"]
[null,"New York City","New York",8930002]
[null,"Los Angeles","California",3919973]
[null,"Chicago","Illionis",2756546]
[null,"Houston","Texas",2345606]
[null,"Phoenix","Arizona",1640641]
[null,"Philadelphia","Pennsylvania",1619355]
[null,"San Antonio","Texas",1456069]
[null,"San Diego","California",1402838]
[null,"Dallas","Texas",1325691]
[null,"San Jose","California",1026700]
[null,"Austin","Texas",996147]
[null,"Mesa","Arizona",517302]
[null,"Buffalo","New York",281757]
[null,"Aurora","Illionis",177070]
[null,"Pittsburgh","Pennsylvania",302425]

{"sheet":"Numbering","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Inserting Number into Range with Variable Row Number"]
[]
[null,"City","State","Population"]
[1,"New York City","New York",8930002]
[2,"Los Angeles","California",3919973]
[3,"Chicago","Illionis",2756546]
[4,"Houston","Texas",2345606]
[5,"Phoenix","Arizona",1640641]
[6,"Philadelphia","Pennsylvania",1619355]
[7,"San Antonio","Texas",1456069]
[null,"San Diego","California",1402838]
[null,"Dallas","Texas",1325691]
[null,"San Jose","California",1026700]
[null,"Austin","Texas",996147]
[null,"Mesa","Arizona",517302]
[null,"Buffalo","New York",281757]
[null,"Aurora","Illionis",177070]
[null,"Pittsburgh","Pennsylvania",302425]

{"sheet":"Arithmetic Operations","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Mathematical Operation on a Range with Variable Row Number"]
[]
[null,"City","State","Population"]
[null,"New York City","New York",4465001]
[null,"Los Angeles","California",1959986.5]
[null,"Chicago","Illionis",1378273]
[null,"Houston","Texas",2345606]
[null,"Phoenix","Arizona",1640641]
[null,"Philadelphia","Pennsylvania",1619355]
[null,"San Antonio","Texas",1456069]
[null,"San Diego","California",1402838]
[null,"Dallas","Texas",1325691]
[null,"San Jose","California",1026700]
[null,"Austin","Texas",996147]
[null,"Mesa","Arizona",517302]
[null,"Buffalo","New York",281757]
[null,"Aurora","Illionis",177070]
[null,"Pittsburgh","Pennsylvania",302425]

{"sheet":"Change Color","index":4,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Changing Cell Colors of Range with Variable Row Number"]
[]
[null,"City","State","Population"]
[null,"New York City","New York",8930002]
[null,"Los Angeles","California",3919973]
[null,"Chicago","Illionis",2756546]
[null,"Houston","Texas",2345606]
[null,"Phoenix","Arizona",1640641]
[null,"Philadelphia","Pennsylvania",1619355]
[null,"San Antonio","Texas",1456069]
[null,"San Diego","California",1402838]
[null,"Dallas","Texas",1325691]
[null,"San Jose","California",1026700]
[null,"Austin","Texas",996147]
[null,"Mesa","Arizona",517302]
[null,"Buffalo","New York",281757]
[null,"Aurora","Illionis",177070]
[null,"Pittsburgh","Pennsylvania",302425]