{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Title","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Total","YTD","Wrap Up"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2090]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: sardenacarlo / Pixabay"]

{"sheet":"Jan","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1087},1133,1260,1304,1701]
["Betty",1477,1880,1627,1027,1944]
["Claire",1032,1934,1689,1493,1242]
["Dale",1788,1699,1947,1712,1144]
["Eddy",1265,1794,1459,1894,1143]
["Flo",1983,1586,1428,1954,1013]
["Gloria",1976,1841,1197,1591,1787]

{"sheet":"Feb","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1809},1977,1270,1602,1375]
["Betty",1115,1185,1821,1641,1486]
["Claire",1392,1969,1970,1696,1577]
["Dale",1999,1731,1728,1922,1905]
["Eddy",1031,1324,1743,1270,1520]
["Flo",1698,1626,1008,1798,1558]
["Gloria",1987,1210,1636,1382,1962]

{"sheet":"Mar","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1105},1278,1628,1022,1109]
["Betty",1067,1759,1987,1137,1680]
["Claire",1327,1489,1907,1831,1934]
["Dale",1293,1727,1537,1942,1676]
["Eddy",1826,1883,1170,1366,1632]
["Flo",1092,1126,1367,1734,1195]
["Gloria",1860,1805,1765,1865,1987]

{"sheet":"Apr","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1116},1003,1468,1279,1492]
["Betty",1605,1295,1602,1521,1817]
["Claire",1889,1421,1632,1221,1531]
["Dale",1214,1027,1400,1873,1745]
["Eddy",1499,1047,1763,1143,1697]
["Flo",1373,1805,1762,1560,1755]
["Gloria",1661,1664,1718,1563,1768]

{"sheet":"May","index":5,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1734},1852,1382,1619,1702]
["Betty",1940,1677,1339,1080,1980]
["Claire",1420,1582,1571,1902,1090]
["Dale",1711,1298,1606,1411,1203]
["Eddy",1756,1064,1117,1117,1121]
["Flo",1327,1224,1280,1775,1673]
["Gloria",1448,1991,1441,1941,1606]

{"sheet":"Jun","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1991},1433,1917,1960,1283]
["Betty",1373,1778,1232,1586,1764]
["Claire",1898,1767,1718,1756,1070]
["Dale",1405,1222,1543,1051,1194]
["Eddy",1131,1198,1945,1425,1781]
["Flo",1706,1466,1018,1338,1007]
["Gloria",1112,1890,1400,1062,1286]

{"sheet":"Jul","index":7,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1806},1967,1939,1347,1104]
["Betty",1517,1873,1084,1347,1661]
["Claire",1624,1286,1769,1998,1618]
["Dale",1148,1880,1449,1575,1364]
["Eddy",1665,1855,1462,1449,1541]
["Flo",1840,1020,1059,1458,1063]
["Gloria",1948,1564,1306,1194,1104]

{"sheet":"Aug","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"A","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1168},1928,1849,1716,1548]
["Betty",1628,1125,1160,1503,1503]
["Claire",1619,1829,1443,1302,1529]
["Dale",1455,1829,1657,1249,1343]
["Eddy",1702,1700,1609,1472,1814]
["Flo",1350,1261,1692,1146,1334]
["Gloria",1171,1272,1049,1102,1990]

{"sheet":"Sep","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1580},1287,1387,1535,1074]
["Betty",1171,1366,1814,1725,1272]
["Claire",1218,1419,1284,1875,1835]
["Dale",1618,1036,1678,1755,1690]
["Eddy",1563,1779,1263,1186,1183]
["Flo",1159,1038,1595,1095,2000]
["Gloria",1141,1001,1193,1496,1052]

{"sheet":"Oct","index":10,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1257},1068,1318,1708,1593]
["Betty",1867,1301,1701,1590,1192]
["Claire",1610,1418,1957,1637,1997]
["Dale",1414,1526,1229,1817,1477]
["Eddy",1555,1648,1307,1904,1084]
["Flo",1027,1733,1375,1218,1255]
["Gloria",1412,1811,1031,1752,1490]

{"sheet":"Nov","index":11,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1655},1913,1034,1940,1557]
["Betty",1376,1883,1530,1637,1804]
["Claire",1529,1575,1924,1766,1560]
["Dale",1648,1217,1086,1725,1601]
["Eddy",1121,1668,1077,1950,1544]
["Flo",1883,1010,1749,1202,1271]
["Gloria",1739,1274,1561,1104,1620]

{"sheet":"Dec","index":12,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Sales Report"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5"]
["Andy",{"$f":"RANDBETWEEN(1000,2000)","v":1905},1222,1429,1968,1287]
["Betty",1934,1551,1725,1481,1250]
["Claire",1299,1667,1360,1404,1555]
["Dale",1822,1347,1361,1702,1338]
["Eddy",1223,1031,1215,1259,1204]
["Flo",1611,1400,1363,1498,1198]
["Gloria",1222,1436,1381,1616,1392]

{"sheet":"Total","index":13,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Total Sales for Entire Year"]
[]
[null,{"$f":"SUM(Jan:Dec!B4:F10)","v":632639},{"$f":"_xlfn.FORMULATEXT(B3)","v":"=SUM(Jan:Dec!B4:F10)"}]

{"sheet":"YTD","index":14,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sales Report YTD Total"]
[]
[null,"Week 1","Week 2","Week 3","Week 4","Week 5","Total"]
["Andy",{"$f":"SUM(Jan:Dec!B4)","v":18213},{"$f":"SUM(Jan:Dec!C4)","v":18061},{"$f":"SUM(Jan:Dec!D4)","v":17881},{"$f":"SUM(Jan:Dec!E4)","v":19000},{"$f":"SUM(Jan:Dec!F4)","v":16825},{"$f":"SUM(B4:F4)","v":89980}]
["Betty",{"$f":"SUM(Jan:Dec!B5)","v":18070},{"$f":"SUM(Jan:Dec!C5)","v":18673},{"$f":"SUM(Jan:Dec!D5)","v":18622},{"$f":"SUM(Jan:Dec!E5)","v":17275},{"$f":"SUM(Jan:Dec!F5)","v":19353},91993]
["Claire",{"$f":"SUM(Jan:Dec!B6)","v":17857},{"$f":"SUM(Jan:Dec!C6)","v":19356},{"$f":"SUM(Jan:Dec!D6)","v":20224},{"$f":"SUM(Jan:Dec!E6)","v":19881},{"$f":"SUM(Jan:Dec!F6)","v":18538},95856]
["Dale",{"$f":"SUM(Jan:Dec!B7)","v":18515},{"$f":"SUM(Jan:Dec!C7)","v":17539},{"$f":"SUM(Jan:Dec!D7)","v":18221},{"$f":"SUM(Jan:Dec!E7)","v":19734},{"$f":"SUM(Jan:Dec!F7)","v":17680},91689]
["Eddy",{"$f":"SUM(Jan:Dec!B8)","v":17337},{"$f":"SUM(Jan:Dec!C8)","v":17991},{"$f":"SUM(Jan:Dec!D8)","v":17130},{"$f":"SUM(Jan:Dec!E8)","v":17435},{"$f":"SUM(Jan:Dec!F8)","v":17264},87157]
["Flo",{"$f":"SUM(Jan:Dec!B9)","v":18049},{"$f":"SUM(Jan:Dec!C9)","v":16295},{"$f":"SUM(Jan:Dec!D9)","v":16696},{"$f":"SUM(Jan:Dec!E9)","v":17776},{"$f":"SUM(Jan:Dec!F9)","v":16322},85138]
["Gloria",{"$f":"SUM(Jan:Dec!B10)","v":18677},{"$f":"SUM(Jan:Dec!C10)","v":18759},{"$f":"SUM(Jan:Dec!D10)","v":16678},{"$f":"SUM(Jan:Dec!E10)","v":17668},{"$f":"SUM(Jan:Dec!F10)","v":19044},90826]
["Total",{"$f":"SUM(B4:B10)","v":126718},{"$f":"SUM(C4:C10)","v":126674},{"$f":"SUM(D4:D10)","v":125452},{"$f":"SUM(E4:E10)","v":128769},{"$f":"SUM(F4:F10)","v":125026},632639]

{"sheet":"Wrap Up","index":15,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Sum a rectangular range on all worksheets"]
[null,"=SUM("]
[null,"Click on Jan sheet"]
[null,"point to the range"]
[null,"Shift-Click on Dec sheet"]
[null,"press Enter"]
[null,"Or, type =SUM(Jan:Dec!B4)"]
[null,"Bonus trick: Adding Total Row & Column in one click of AutoSum"]