{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Fill Handle","Formula","Print Titles","VBA","New Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Fill Handle","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Fill Handle"]
[]
[null,"Name","Shift","Branch"]
[null,"Amelia Claire","Day","Buffalo"]
[null,"David Smith","Afternoon","Rochester"]
[null,"Robert Johnson","Night","Syracuse"]
[null,"Amelia Claire","Day","Buffalo"]
[null,"David Smith","Afternoon","Rochester"]
[null,"Robert Johnson","Night","Syracuse"]

{"sheet":"Formula","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Formula"]
[]
[null,"Name","Shift","Branch"]
[null,"Amelia Claire","Day","Buffalo"]
[null,"David Smith","Afternoon","Rochester"]
[null,"Robert Johnson","Night","Syracuse"]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(B5))),INDIRECT(\"Formula!B\"&(ROWS($B$5:B5)-(COUNTA(Formula!B:B)-2))),Formula!B5)","v":"Amelia Claire"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(C5))),INDIRECT(\"Formula!B\"&(ROWS($B$5:C5)-(COUNTA(Formula!C:C)-2))),Formula!C5)","v":"Day"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(D5))),INDIRECT(\"Formula!B\"&(ROWS($B$5:D5)-(COUNTA(Formula!D:D)-2))),Formula!D5)","v":"Buffalo"}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(B6))),INDIRECT(\"Formula!B\"&(ROWS($B$5:B6)-(COUNTA(Formula!B:B)-2))),Formula!B6)","v":"David Smith"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(C6))),INDIRECT(\"Formula!B\"&(ROWS($B$5:C6)-(COUNTA(Formula!C:C)-2))),Formula!C6)","v":"Afternoon"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(D6))),INDIRECT(\"Formula!B\"&(ROWS($B$5:D6)-(COUNTA(Formula!D:D)-2))),Formula!D6)","v":"Rochester"}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(B7))),INDIRECT(\"Formula!B\"&(ROWS($B$5:B7)-(COUNTA(Formula!B:B)-2))),Formula!B7)","v":"Robert Johnson"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(C7))),INDIRECT(\"Formula!B\"&(ROWS($B$5:C7)-(COUNTA(Formula!C:C)-2))),Formula!C7)","v":"Night"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(D7))),INDIRECT(\"Formula!B\"&(ROWS($B$5:D7)-(COUNTA(Formula!D:D)-2))),Formula!D7)","v":"Syracuse"}]
[null,{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(B8))),INDIRECT(\"Formula!B\"&(ROWS($B$5:B8)-(COUNTA(Formula!B:B)-2))),Formula!B8)","v":"Amelia Claire"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(C8))),INDIRECT(\"Formula!B\"&(ROWS($B$5:C8)-(COUNTA(Formula!C:C)-2))),Formula!C8)","v":"Day"},{"$f":"IF(ISBLANK(INDIRECT(\"Formula!B\"&ROW(D8))),INDIRECT(\"Formula!B\"&(ROWS($B$5:D8)-(COUNTA(Formula!D:D)-2))),Formula!D8)","v":"Buffalo"}]

{"sheet":"Print Titles","index":2,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"US Statewise Population 2022"]
[]
[null,"Rank","State","2022 Population","Growth 2022","2021 Population","2010 Census","Growth Since 2010","% of US","Density (mi²)"]
[null,1,"California",39995077,5.7000000000000002E-3,39766650,37253956,7.3599999999999999E-2,0.1193,257]
[null,2,"Texas",29945493,1.35E-2,29545499,25145561,0.19089999999999999,8.9300000000000004E-2,115]
[null,3,"Florida",22085563,1.2500000000000001E-2,21811875,18801310,0.17469999999999999,6.59E-2,412]
[null,4,"New York",20365879,4.1000000000000003E-3,20283564,19378102,5.0999999999999997E-2,6.0699999999999997E-2,432]
[null,5,"Pennsylvania",13062764,2.3E-3,13032732,12702379,2.8400000000000002E-2,3.9E-2,292]
[null,6,"Illinois",12808884,-1E-4,12810696,12830632,-1.6999999999999999E-3,3.8199999999999998E-2,231]
[null,7,"Ohio",11852036,2.2000000000000001E-3,11825742,11536504,2.7400000000000001E-2,3.5299999999999998E-2,290]
[null,8,"Georgia",10916760,9.4999999999999998E-3,10814334,9687653,0.12690000000000001,3.2599999999999997E-2,190]
[null,9,"North Carolina",10620168,8.6E-3,10529778,9535483,0.1138,3.1699999999999999E-2,218]
[null,10,"Michigan",10116069,1.9E-3,10096700,9883640,2.35E-2,3.0200000000000001E-2,179]
[null,11,"New Jersey",9388414,5.3E-3,9338704,8791894,6.7799999999999999E-2,2.8000000000000001E-2,1277]
[null,12,"Virginia",8757467,7.3000000000000001E-3,8694430,8001024,9.4500000000000001E-2,2.6100000000000002E-2,222]
[null,13,"Washington",7901429,1.26E-2,7803355,6724540,0.17499999999999999,2.3599999999999999E-2,119]
[null,14,"Arizona",7303398,1.0500000000000001E-2,7227450,6392017,0.1426,2.18E-2,64]
[null,15,"Massachusetts",7126375,6.7999999999999996E-3,7078146,6547629,8.8400000000000006E-2,2.1299999999999999E-2,914]
[null,16,"Tennessee",7023788,8.0999999999999996E-3,6967314,6346105,0.10680000000000001,2.0899999999999998E-2,170]
[null,17,"Indiana",6845874,4.4000000000000003E-3,6815701,6483802,5.5800000000000002E-2,2.0400000000000001E-2,191]
[null,18,"Maryland",6257958,6.4999999999999997E-3,6217591,5773552,8.3900000000000002E-2,1.8700000000000001E-2,645]
[null,19,"Missouri",6188111,2.7000000000000001E-3,6171512,5988927,3.3300000000000003E-2,1.8499999999999999E-2,90]
[null,20,"Wisconsin",5935064,3.5000000000000001E-3,5914391,5686986,4.36E-2,1.77E-2,110]
[null,21,"Colorado",5922618,1.2699999999999999E-2,5848166,5029196,0.17760000000000001,1.77E-2,57]
[null,22,"Minnesota",5787008,7.0000000000000001E-3,5746751,5303925,9.11E-2,1.7299999999999999E-2,73]
[null,23,"South Carolina",5217037,9.4999999999999998E-3,5167731,4625364,0.12790000000000001,1.5599999999999999E-2,174]
[null,24,"Alabama",5073187,4.7999999999999996E-3,5048733,4779736,6.1400000000000003E-2,1.5100000000000001E-2,100]
[null,25,"Louisiana",4682633,2.7000000000000001E-3,4670195,4533372,3.2899999999999999E-2,1.4E-2,108]
[null,26,"Kentucky",4539130,3.7000000000000002E-3,4522483,4339367,4.5999999999999999E-2,1.35E-2,115]
[null,27,"Oregon",4318492,9.4999999999999998E-3,4277874,3831074,0.12720000000000001,1.29E-2,45]
[null,28,"Oklahoma",4000953,5.1999999999999998E-3,3980153,3751351,6.6500000000000004E-2,1.1900000000000001E-2,58]
[null,29,"Connecticut",3612314,8.9999999999999998E-4,3609129,3574097,1.0699999999999999E-2,1.0800000000000001E-2,746]
[null,30,"Utah",3373162,1.5299999999999999E-2,3322389,2763885,0.22040000000000001,1.01E-2,41]
[null,31,"Iowa",3219171,4.4999999999999997E-3,3204770,3046355,5.67E-2,9.5999999999999992E-3,58]
[null,32,"Nevada",3185426,1.2800000000000001E-2,3145020,2700551,0.17949999999999999,9.4999999999999998E-3,29]
[null,33,"Arkansas",3030646,3.2000000000000002E-3,3021085,2915918,3.9300000000000002E-2,8.9999999999999993E-3,58]
[null,34,"Mississippi",2960075,-2.0000000000000001E-4,2960677,2967297,-2.3999999999999998E-3,8.8000000000000005E-3,63]
[null,35,"Kansas",2954832,2.8999999999999998E-3,2946356,2853118,3.5700000000000003E-2,8.8000000000000005E-3,36]
[null,36,"New Mexico",2129190,2.7000000000000001E-3,2123356,2059179,3.4000000000000002E-2,6.4000000000000003E-3,18]
[null,37,"Nebraska",1988536,6.7999999999999996E-3,1975020,1826341,8.8800000000000004E-2,5.8999999999999999E-3,26]
[null,38,"Idaho",1893410,1.4500000000000001E-2,1866258,1567582,0.2079,5.5999999999999999E-3,23]
[null,39,"West Virginia",1781860,-3.3E-3,1787788,1852994,-3.8399999999999997E-2,5.3E-3,74]
[null,40,"Hawaii",1474265,6.4999999999999997E-3,1464768,1360301,8.3799999999999999E-2,4.4000000000000003E-3,230]
[null,41,"New Hampshire",1389741,4.4000000000000003E-3,1383635,1316470,5.57E-2,4.1000000000000003E-3,155]
[null,42,"Maine",1369159,2.5000000000000001E-3,1365759,1328361,3.0700000000000002E-2,4.1000000000000003E-3,44]
[null,43,"Rhode Island",1106341,4.1000000000000003E-3,1101860,1052567,5.11E-2,3.3E-3,1070]
[null,44,"Montana",1103187,8.6999999999999994E-3,1093706,989415,0.115,3.3E-3,8]
[null,45,"Delaware",1008350,9.1999999999999998E-3,999149,897934,0.123,3.0000000000000001E-3,517]
[null,46,"South Dakota",901165,8.0999999999999996E-3,893916,814180,0.10680000000000001,2.7000000000000001E-3,12]
[null,47,"North Dakota",800394,1.35E-2,789744,672591,0.19,2.3999999999999998E-3,12]
[null,48,"Alaska",738023,3.0999999999999999E-3,735707,710231,3.9100000000000003E-2,2.2000000000000001E-3,1]
[null,49,"Vermont",646545,2.7000000000000001E-3,644811,625741,3.32E-2,1.9E-3,70]
[null,50,"Wyoming",579495,2.3E-3,578173,563626,2.8199999999999999E-2,1.6999999999999999E-3,6]

{"sheet":"VBA","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of VBA"]
[]
[null,"Name","Shift","Branch","Repeat"]
[null,"Amelia Claire","Day","Buffalo",2]
[null,"Amelia Claire","Day","Buffalo",2]
[null,"Amelia Claire","Day","Buffalo",2]
[null,"David Smith","Afternoon","Rochester",1]
[null,"David Smith","Afternoon","Rochester",1]
[null,"Robert Johnson","Night","Syracuse",3]
[null,"Robert Johnson","Night","Syracuse",3]
[null,"Robert Johnson","Night","Syracuse",3]
[null,"Robert Johnson","Night","Syracuse",3]

{"sheet":"New Sheet","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of VBA"]
[]
[null,"Name","Shift","Branch","Repeat"]
[null,"Amelia Claire","Day","Buffalo",2]
[null,"David Smith","Afternoon","Rochester",1]
[null,"Robert Johnson","Night","Syracuse",3]