{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["C(1682 )","Historic","Title","Question","BillVBA","MikeWorksheetFormulas","Abiola David from XLarium","cr gr0912","cr gr0912 (2)","ExcelWizard","Wayne","Predrag Kojić","Peter Bartholomew"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":75,"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":"C(1682 )","index":0,"n_rows":143,"n_cols":25,"rows_kept":143,"cut":false,"hidden":false,"merged":[[1,1,31,17],[35,4,58,14],[142,4,165,14]]}
[]
[null,"Dueling Excel!\nSplit Text, Add Amount, Re-Text"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Duel # 192"]
[]
[]
[null,null,null,null,"Net Project Work Hours for Night Shift, Excluding Weekends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change First Column in Lookup Table? 4 Examples: INDEX, XLOOKUP, LOOKUP or CHOOSE. EMT 1648"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEN(W36)","v":91}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBSTITUTE(REPLACE(CELL(\"filename\"),1,SEARCH(\"(\",CELL(\"filename\")),\"\"),\")\",\"\")","v":"2"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Excel\nMagic\nTrick\n\"&SUBSTITUTE(REPLACE(CELL(\"filename\",A1),1,SEARCH(\"(\",CELL(\"filename\",A1)),\"\"),\")\",\"\")","v":"Excel\nMagic\nTrick\n1682 "}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Power Query"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formula"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Excel\nGet Last 5 In Column.\nAdd, Average or Display"]

{"sheet":"Historic","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Bill \"Historic Excel Awesomeness\" Jelen"]

{"sheet":"Title","index":2,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,192]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Photo by Aditya Wardhana on Unsplash"]

{"sheet":"Question","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Original","Value to Add","Updated"]
[null,"1444,1445,1446,1447,1448,1449,1450,1451,1452",500]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198"]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210"]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357"]
[null,"1474,1475,1476,1477,1478,1479,1480,1481"]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126"]
[null,"889,890,891,892,893,894,895,896,897,898"]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332"]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046"]
[null,"854,855,856,857,858,859,860,861,862,863,864,865"]

{"sheet":"BillVBA","index":4,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Original","Value to Add","Updated"]
[null,"1444,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B8,\",\")+C8)","v":"1944,1945,1946,1947,1948,1949,1950,1951,1952"}]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B9,\",\")+C9)","v":"1290,1291,1292,1293,1294,1295,1296,1297,1298"}]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",700,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B10,\",\")+C10)","v":"1902,1903,1904,1905,1906,1907,1908,1909,1910"}]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B11,\",\")+C11)","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,"1474,1475,1476,1477,1478,1479,1480,1481",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B12,\",\")+C12)","v":"1974,1975,1976,1977,1978,1979,1980,1981"}]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B13,\",\")+C13)","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B14,\",\")+C14)","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B15,\",\")+C15)","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B16,\",\")+C16)","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,"854,855,856,857,858,859,860,861,862,863,864,865",400,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,splitter(B17,\",\")+C17)","v":"1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265"}]

{"sheet":"MikeWorksheetFormulas","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,"LET"]
[null,"Original","Value to Add","Updated"]
[null,"44,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.LET(_xlpm.Cell,B8,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C8,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"544,1945,1946,1947,1948,1949,1950,1951,1952"}]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",100,{"$f":"_xlfn.LET(_xlpm.Cell,B9,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C9,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1290,1291,1292,1293,1294,1295,1296,1297,1298"}]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",700,{"$f":"_xlfn.LET(_xlpm.Cell,B10,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C10,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1902,1903,1904,1905,1906,1907,1908,1909,1910"}]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.LET(_xlpm.Cell,B11,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C11,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,"1474,1475,1476,1477,1478,1479,1480,1481",500,{"$f":"_xlfn.LET(_xlpm.Cell,B12,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C12,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1974,1975,1976,1977,1978,1979,1980,1981"}]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.LET(_xlpm.Cell,B13,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C13,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.LET(_xlpm.Cell,B14,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C14,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.LET(_xlpm.Cell,B15,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C15,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.LET(_xlpm.Cell,B16,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C16,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,"854,855,856,857,858,859,860,861,862,863,864,865",400,{"$f":"_xlfn.LET(_xlpm.Cell,B17,_xlpm.NumbChar,LEN(_xlpm.Cell),_xlpm.Seq,_xlfn.SEQUENCE(_xlpm.NumbChar),\n_xlpm.CommaError,ISERROR(MID(\",\"&_xlpm.Cell,_xlpm.Seq,1)+0),\n_xlpm.CommaPosition,_xlfn._xlws.FILTER(_xlpm.Seq,_xlpm.CommaError),\n_xlpm.RemoveFirstRow,_xlfn._xlws.FILTER(_xlpm.CommaPosition,_xlfn.SEQUENCE(COUNT(_xlpm.CommaPosition))>1),\n_xlpm.PreLenthArray,_xlpm.RemoveFirstRow-_xlpm.CommaPosition-1,\n_xlpm.Lengths,IF(ISNA(_xlpm.PreLenthArray),5,_xlpm.PreLenthArray),\n_xlpm.Extract,MID(_xlpm.Cell,_xlpm.CommaPosition,_xlpm.Lengths)+C17,\n_xlpm.Final,_xlfn.TEXTJOIN(\",\",,_xlpm.Extract),_xlpm.Final)","v":"1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265"}]
[]
[null,null,null,"Start 1st number, each number same length, add 1 for increment","LET Concept"]
[null,"Original","Value to Add","Updated","Updated"]
[null,"1444,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B21)-LEN(SUBSTITUTE(B21,\",\",\"\"))+1,,LEFT(B21,SEARCH(\",\",B21)-1),1)+C21)","v":"1944,1945,1946,1947,1948,1949,1950,1951,1952"},{"$f":"_xlfn.TEXTJOIN(\",\",,MID(B21,{1;6;11;16;21;26;31;36;41},{4;4;4;4;4;4;4;4;5})+C21)","v":"1944,1945,1946,1947,1948,1949,1950,1951,1952"}]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",100,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B22)-LEN(SUBSTITUTE(B22,\",\",\"\"))+1,,LEFT(B22,SEARCH(\",\",B22)-1),1)+C22)","v":"1290,1291,1292,1293,1294,1295,1296,1297,1298"}]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",700,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B23)-LEN(SUBSTITUTE(B23,\",\",\"\"))+1,,LEFT(B23,SEARCH(\",\",B23)-1),1)+C23)","v":"1902,1903,1904,1905,1906,1907,1908,1909,1910"}]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B24)-LEN(SUBSTITUTE(B24,\",\",\"\"))+1,,LEFT(B24,SEARCH(\",\",B24)-1),1)+C24)","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,"1474,1475,1476,1477,1478,1479,1480,1481",500,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B25)-LEN(SUBSTITUTE(B25,\",\",\"\"))+1,,LEFT(B25,SEARCH(\",\",B25)-1),1)+C25)","v":"1974,1975,1976,1977,1978,1979,1980,1981"}]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B26)-LEN(SUBSTITUTE(B26,\",\",\"\"))+1,,LEFT(B26,SEARCH(\",\",B26)-1),1)+C26)","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B27)-LEN(SUBSTITUTE(B27,\",\",\"\"))+1,,LEFT(B27,SEARCH(\",\",B27)-1),1)+C27)","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B28)-LEN(SUBSTITUTE(B28,\",\",\"\"))+1,,LEFT(B28,SEARCH(\",\",B28)-1),1)+C28)","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B29)-LEN(SUBSTITUTE(B29,\",\",\"\"))+1,,LEFT(B29,SEARCH(\",\",B29)-1),1)+C29)","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,"854,855,856,857,858,859,860,861,862,863,864,865",400,{"$f":"_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(LEN(B30)-LEN(SUBSTITUTE(B30,\",\",\"\"))+1,,LEFT(B30,SEARCH(\",\",B30)-1),1)+C30)","v":"1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265"}]

{"sheet":"Abiola David from XLarium","index":6,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Abiola David"]
[null,"https://www.exceljetconsult.com.ng/home/blog/split-values-into-multiple-columns-using-filterxml/"]
[]
[null,"Split with XML:"]
[]
[null,"Original","Add","Finished"]
[null,"44,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B8,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C8))","v":"544,1945,1946,1947,1948,1949,1950,1951,1952"}]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B9,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C9))","v":"1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B10,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C10))","v":"1302,1303,1304,1305,1306,1307,1308,1309,1310"}]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B11,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C11))","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,"1474,1475,1476,1477,1478,1479,1480,1481",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B12,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C12))","v":"1674,1675,1676,1677,1678,1679,1680,1681"}]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B13,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C13))","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B14,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C14))","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B15,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C15))","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B16,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C16))","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,"854,855,856,857,858,859,860,861,862,863,864,865",600,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRANSPOSE(_xlfn.FILTERXML(\"<y><z>\"&SUBSTITUTE(B17,\",\",\"</z><z>\")&\"</z></y>\",\"//z\")+C17))","v":"1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465"}]

{"sheet":"cr gr0912","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Original","Add","Finished"]
[null,null,"44,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.LET(_xlpm.tx,C8,_xlpm.ad,D8,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"544,1945,1946,1947,1948,1949,1950,1951,1952"}]
[null,null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",200,{"$f":"_xlfn.LET(_xlpm.tx,C9,_xlpm.ad,D9,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",100,{"$f":"_xlfn.LET(_xlpm.tx,C10,_xlpm.ad,D10,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1302,1303,1304,1305,1306,1307,1308,1309,1310"}]
[null,null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.LET(_xlpm.tx,C11,_xlpm.ad,D11,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,null,"1474,1475,1476,1477,1478,1479,1480,1481",200,{"$f":"_xlfn.LET(_xlpm.tx,C12,_xlpm.ad,D12,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1674,1675,1676,1677,1678,1679,1680,1681"}]
[null,null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.LET(_xlpm.tx,C13,_xlpm.ad,D13,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.LET(_xlpm.tx,C14,_xlpm.ad,D14,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.LET(_xlpm.tx,C15,_xlpm.ad,D15,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.LET(_xlpm.tx,C16,_xlpm.ad,D16,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,null,"854,855,856,857,858,859,860,861,862,863,864,865",600,{"$f":"_xlfn.LET(_xlpm.tx,C17,_xlpm.ad,D17,_xlpm.ch,\",\",_xlpm.sch,\"|\",_xlpm.chtx,_xlpm.ch&_xlpm.tx,_xlpm.txch,_xlpm.tx&_xlpm.ch,_xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1,_xlpm.sqnr,_xlfn.SEQUENCE(_xlpm.nr), _xlpm.midl,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.chtx,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)), _xlpm.midr,SEARCH(_xlpm.sch,SUBSTITUTE(_xlpm.txch,_xlpm.ch,_xlpm.sch,_xlpm.sqnr)),_xlpm.mid,MID(_xlpm.tx,_xlpm.midl,_xlpm.midr-_xlpm.midl), _xlpm.rs,_xlfn.TEXTJOIN(_xlpm.ch,,_xlpm.mid+_xlpm.ad), _xlpm.rs)","v":"1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465"}]

{"sheet":"cr gr0912 (2)","index":8,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Original","Add","Finished"]
[null,null,"44,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.LET(_xlpm.ch,\",\",_xlpm.tx,C8:C17,_xlpm.ad,D8:D17, _xlpm.nr,LEN(_xlpm.tx)-LEN(SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"\"))+1, _xlpm.mxnr,MAX(_xlpm.nr), _xlpm.sqarr,MOD(_xlfn.SEQUENCE(ROWS(_xlpm.tx),_xlpm.mxnr)-1,_xlpm.mxnr)+1, _xlpm.x,\"<a><b>\"&SUBSTITUTE(_xlpm.tx,_xlpm.ch,\"</b><b>\")&\"</b></a>\", _xlpm.rs,IFERROR(_xlfn.FILTERXML(_xlpm.x,\"/a/b[\"&N(IF(1,_xlpm.sqarr))&\"]\")+_xlpm.ad,\"\"),_xlpm.rs)","v":544},1945,1946,1947,1948,1949,1950,1951,1952,"","",""]
[null,null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",200,1390,1391,1392,1393,1394,1395,1396,1397,1398,"","",""]
[null,null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",100,1302,1303,1304,1305,1306,1307,1308,1309,1310,"","",""]
[null,null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,1848,1849,1850,1851,1852,1853,1854,1855,1856,1857,"",""]
[null,null,"1474,1475,1476,1477,1478,1479,1480,1481",200,1674,1675,1676,1677,1678,1679,1680,1681,"","","",""]
[null,null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,""]
[null,null,"889,890,891,892,893,894,895,896,897,898",500,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,"",""]
[null,null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532]
[null,null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,1138,1139,1140,1141,1142,1143,1144,1145,1146,"","",""]
[null,null,"854,855,856,857,858,859,860,861,862,863,864,865",600,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465]

{"sheet":"ExcelWizard","index":9,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Original","Add","Finished"]
[null,"44,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B8,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B8)-LEN(SUBSTITUTE(B8,\",\",))+1,0)*100+1,100)+C8)","v":"544,1945,1946,1947,1948,1949,1950,1951,1952"}]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",200,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B9,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B9)-LEN(SUBSTITUTE(B9,\",\",))+1,0)*100+1,100)+C9)","v":"1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",100,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B10,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B10)-LEN(SUBSTITUTE(B10,\",\",))+1,0)*100+1,100)+C10)","v":"1302,1303,1304,1305,1306,1307,1308,1309,1310"}]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B11,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B11)-LEN(SUBSTITUTE(B11,\",\",))+1,0)*100+1,100)+C11)","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,"1474,1475,1476,1477,1478,1479,1480,1481",200,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B12,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B12)-LEN(SUBSTITUTE(B12,\",\",))+1,0)*100+1,100)+C12)","v":"1674,1675,1676,1677,1678,1679,1680,1681"}]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B13,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B13)-LEN(SUBSTITUTE(B13,\",\",))+1,0)*100+1,100)+C13)","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B14,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B14)-LEN(SUBSTITUTE(B14,\",\",))+1,0)*100+1,100)+C14)","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B15,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B15)-LEN(SUBSTITUTE(B15,\",\",))+1,0)*100+1,100)+C15)","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B16,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B16)-LEN(SUBSTITUTE(B16,\",\",))+1,0)*100+1,100)+C16)","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,"854,855,856,857,858,859,860,861,862,863,864,865",600,{"$f":"_xlfn.TEXTJOIN(\",\",,MID(SUBSTITUTE(B17,\",\",REPT(\" \",100)),_xlfn.SEQUENCE(,LEN(B17)-LEN(SUBSTITUTE(B17,\",\",))+1,0)*100+1,100)+C17)","v":"1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465"}]

{"sheet":"Wayne","index":10,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Original","Add","Finished"]
[null,"44,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B8,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B8)-LEN(SUBSTITUTE(B8,\",\",\"\"))+1,1,SEARCH(\",\",B8)-1),SEARCH(\",\",B8)-1)+_xlfn.SEQUENCE(,LEN(B8)-LEN(SUBSTITUTE(B8,\",\",\"\"))+1,C8,0))","v":"544,514,545,514,546,514,547,514,548"}]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B9,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B9)-LEN(SUBSTITUTE(B9,\",\",\"\"))+1,1,SEARCH(\",\",B9)-1),SEARCH(\",\",B9)-1)+_xlfn.SEQUENCE(,LEN(B9)-LEN(SUBSTITUTE(B9,\",\",\"\"))+1,C9,0))","v":"1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B10,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B10)-LEN(SUBSTITUTE(B10,\",\",\"\"))+1,1,SEARCH(\",\",B10)-1),SEARCH(\",\",B10)-1)+_xlfn.SEQUENCE(,LEN(B10)-LEN(SUBSTITUTE(B10,\",\",\"\"))+1,C10,0))","v":"1302,1303,1304,1305,1306,1307,1308,1309,1310"}]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B11,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B11)-LEN(SUBSTITUTE(B11,\",\",\"\"))+1,1,SEARCH(\",\",B11)-1),SEARCH(\",\",B11)-1)+_xlfn.SEQUENCE(,LEN(B11)-LEN(SUBSTITUTE(B11,\",\",\"\"))+1,C11,0))","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,"1474,1475,1476,1477,1478,1479,1480,1481",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B12,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B12)-LEN(SUBSTITUTE(B12,\",\",\"\"))+1,1,SEARCH(\",\",B12)-1),SEARCH(\",\",B12)-1)+_xlfn.SEQUENCE(,LEN(B12)-LEN(SUBSTITUTE(B12,\",\",\"\"))+1,C12,0))","v":"1674,1675,1676,1677,1678,1679,1680,1681"}]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B13,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B13)-LEN(SUBSTITUTE(B13,\",\",\"\"))+1,1,SEARCH(\",\",B13)-1),SEARCH(\",\",B13)-1)+_xlfn.SEQUENCE(,LEN(B13)-LEN(SUBSTITUTE(B13,\",\",\"\"))+1,C13,0))","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B14,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B14)-LEN(SUBSTITUTE(B14,\",\",\"\"))+1,1,SEARCH(\",\",B14)-1),SEARCH(\",\",B14)-1)+_xlfn.SEQUENCE(,LEN(B14)-LEN(SUBSTITUTE(B14,\",\",\"\"))+1,C14,0))","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B15,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B15)-LEN(SUBSTITUTE(B15,\",\",\"\"))+1,1,SEARCH(\",\",B15)-1),SEARCH(\",\",B15)-1)+_xlfn.SEQUENCE(,LEN(B15)-LEN(SUBSTITUTE(B15,\",\",\"\"))+1,C15,0))","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B16,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B16)-LEN(SUBSTITUTE(B16,\",\",\"\"))+1,1,SEARCH(\",\",B16)-1),SEARCH(\",\",B16)-1)+_xlfn.SEQUENCE(,LEN(B16)-LEN(SUBSTITUTE(B16,\",\",\"\"))+1,C16,0))","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,"854,855,856,857,858,859,860,861,862,863,864,865",600,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,MID(SUBSTITUTE(B17,\",\",\"\"),_xlfn.SEQUENCE(,LEN(B17)-LEN(SUBSTITUTE(B17,\",\",\"\"))+1,1,SEARCH(\",\",B17)-1),SEARCH(\",\",B17)-1)+_xlfn.SEQUENCE(,LEN(B17)-LEN(SUBSTITUTE(B17,\",\",\"\"))+1,C17,0))","v":"1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465"}]

{"sheet":"Predrag Kojić","index":11,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Original","Add","Finished"]
[null,"44,1445,1446,1447,1448,1449,1450,1451,1452",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B21,\",\",REPT(\" \",LEN(B21))),(ROW(INDIRECT(\"1:\"&(LEN(B21)-LEN(SUBSTITUTE(B21,\",\",\"\"))+1)))-1)*LEN(B21)+1,LEN(B21)))+C21)","v":"544,1945,1946,1947,1948,1949,1950,1951,1952"}]
[null,"1190,1191,1192,1193,1194,1195,1196,1197,1198",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B22,\",\",REPT(\" \",LEN(B22))),(ROW(INDIRECT(\"1:\"&(LEN(B22)-LEN(SUBSTITUTE(B22,\",\",\"\"))+1)))-1)*LEN(B22)+1,LEN(B22)))+C22)","v":"1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1202,1203,1204,1205,1206,1207,1208,1209,1210",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B23,\",\",REPT(\" \",LEN(B23))),(ROW(INDIRECT(\"1:\"&(LEN(B23)-LEN(SUBSTITUTE(B23,\",\",\"\"))+1)))-1)*LEN(B23)+1,LEN(B23)))+C23)","v":"1302,1303,1304,1305,1306,1307,1308,1309,1310"}]
[null,"1348,1349,1350,1351,1352,1353,1354,1355,1356,1357",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B24,\",\",REPT(\" \",LEN(B24))),(ROW(INDIRECT(\"1:\"&(LEN(B24)-LEN(SUBSTITUTE(B24,\",\",\"\"))+1)))-1)*LEN(B24)+1,LEN(B24)))+C24)","v":"1848,1849,1850,1851,1852,1853,1854,1855,1856,1857"}]
[null,"1474,1475,1476,1477,1478,1479,1480,1481",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B25,\",\",REPT(\" \",LEN(B25))),(ROW(INDIRECT(\"1:\"&(LEN(B25)-LEN(SUBSTITUTE(B25,\",\",\"\"))+1)))-1)*LEN(B25)+1,LEN(B25)))+C25)","v":"1674,1675,1676,1677,1678,1679,1680,1681"}]
[null,"1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B26,\",\",REPT(\" \",LEN(B26))),(ROW(INDIRECT(\"1:\"&(LEN(B26)-LEN(SUBSTITUTE(B26,\",\",\"\"))+1)))-1)*LEN(B26)+1,LEN(B26)))+C26)","v":"1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226"}]
[null,"889,890,891,892,893,894,895,896,897,898",500,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B27,\",\",REPT(\" \",LEN(B27))),(ROW(INDIRECT(\"1:\"&(LEN(B27)-LEN(SUBSTITUTE(B27,\",\",\"\"))+1)))-1)*LEN(B27)+1,LEN(B27)))+C27)","v":"1389,1390,1391,1392,1393,1394,1395,1396,1397,1398"}]
[null,"1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332",200,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B28,\",\",REPT(\" \",LEN(B28))),(ROW(INDIRECT(\"1:\"&(LEN(B28)-LEN(SUBSTITUTE(B28,\",\",\"\"))+1)))-1)*LEN(B28)+1,LEN(B28)))+C28)","v":"1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532"}]
[null,"1038,1039,1040,1041,1042,1043,1044,1045,1046",100,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B29,\",\",REPT(\" \",LEN(B29))),(ROW(INDIRECT(\"1:\"&(LEN(B29)-LEN(SUBSTITUTE(B29,\",\",\"\"))+1)))-1)*LEN(B29)+1,LEN(B29)))+C29)","v":"1138,1139,1140,1141,1142,1143,1144,1145,1146"}]
[null,"854,855,856,857,858,859,860,861,862,863,864,865",600,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,TRIM(MID(SUBSTITUTE(B30,\",\",REPT(\" \",LEN(B30))),(ROW(INDIRECT(\"1:\"&(LEN(B30)-LEN(SUBSTITUTE(B30,\",\",\"\"))+1)))-1)*LEN(B30)+1,LEN(B30)))+C30)","v":"1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465"}]

{"sheet":"Peter Bartholomew","index":12,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,6,14,6]]}
[]
[null,"Notes","Project Received","Project Due Date","Work Hours?",null,"Formula"]
[null,"Same Day","2020-06-23T19:00:00","2020-06-23T22:36:00",{"$f":" _xlfn.LET(\n  _xlpm.weekStart,       2 + FLOOR( _xlfn.SINGLE(projectStart) - 2, 7 ),\n  _xlpm.modelWeeks, 1 + QUOTIENT(_xlfn.SINGLE(projectDue)-2, 7 )  -  QUOTIENT(_xlfn.SINGLE(projectStart)-2, 7 ),\n  _xlpm.modelDay,       _xlfn.SEQUENCE(1, 7*_xlpm.modelWeeks),\n  _xlpm.shiftStart,         _xlpm.weekStart + (_xlpm.modelDay-1) + 19/24,\n  _xlpm.shiftEnd,           _xlpm.weekStart + _xlpm.modelDay + 4/24,\n  _xlpm.duration,\n        ( IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectDue),    _xlpm.shiftEnd,  _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftStart<_xlfn.SINGLE(projectDue),  _xlpm.shiftStart, _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectStart),   _xlpm.shiftEnd,  _xlfn.SINGLE(projectStart ))\n        + IF( _xlpm.shiftStart<_xlfn.SINGLE(projectStart), _xlpm.shiftStart, _xlfn.SINGLE(projectStart )) ),\n  _xlpm.availableShift?,  (MOD(_xlpm.modelDay-1, 7) < 5 ),\n  SUM( _xlpm.duration * _xlpm.availableShift? ) )","v":0.15000000000145519},null,{"$f":" _xlfn.FORMULATEXT( Table1[[#This Row],[Work Hours?]] )","v":"= LET(\n  weekStart,       2 + FLOOR( @projectStart - 2, 7 ),\n  modelWeeks, 1 + QUOTIENT(@projectDue-2, 7 )  -  QUOTIENT(@projectStart-2, 7 ),\n  modelDay,       SEQUENCE(1, 7*modelWeeks),\n  shiftStart,         weekStart + (modelDay-1) + 19/24,\n  shiftEnd,           weekStart + modelDay + 4/24,\n  duration,\n        ( IF( shiftEnd<@projectDue,    shiftEnd,  @projectDue )\n        - IF( shiftStart<@projectDue,  shiftStart, @projectDue )\n        - IF( shiftEnd<@projectStart,   shiftEnd,  @projectStart )\n        + IF( shiftStart<@projectStart, shiftStart, @projectStart ) ),\n  availableShift?,  (MOD(modelDay-1, 7) < 5 ),\n  SUM( duration * availableShift? ) )"}]
[null,"Sat and Sun excluded","2020-06-26T03:00:00","2020-06-29T20:30:00",{"$f":" _xlfn.LET(\n  _xlpm.weekStart,       2 + FLOOR( _xlfn.SINGLE(projectStart) - 2, 7 ),\n  _xlpm.modelWeeks, 1 + QUOTIENT(_xlfn.SINGLE(projectDue)-2, 7 )  -  QUOTIENT(_xlfn.SINGLE(projectStart)-2, 7 ),\n  _xlpm.modelDay,       _xlfn.SEQUENCE(1, 7*_xlpm.modelWeeks),\n  _xlpm.shiftStart,         _xlpm.weekStart + (_xlpm.modelDay-1) + 19/24,\n  _xlpm.shiftEnd,           _xlpm.weekStart + _xlpm.modelDay + 4/24,\n  _xlpm.duration,\n        ( IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectDue),    _xlpm.shiftEnd,  _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftStart<_xlfn.SINGLE(projectDue),  _xlpm.shiftStart, _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectStart),   _xlpm.shiftEnd,  _xlfn.SINGLE(projectStart ))\n        + IF( _xlpm.shiftStart<_xlfn.SINGLE(projectStart), _xlpm.shiftStart, _xlfn.SINGLE(projectStart )) ),\n  _xlpm.availableShift?,  (MOD(_xlpm.modelDay-1, 7) < 5 ),\n  SUM( _xlpm.duration * _xlpm.availableShift? ) )","v":0.47916666666424135}]
[null,"Next day","2020-07-29T21:00:00","2020-07-30T20:30:00",{"$f":" _xlfn.LET(\n  _xlpm.weekStart,       2 + FLOOR( _xlfn.SINGLE(projectStart) - 2, 7 ),\n  _xlpm.modelWeeks, 1 + QUOTIENT(_xlfn.SINGLE(projectDue)-2, 7 )  -  QUOTIENT(_xlfn.SINGLE(projectStart)-2, 7 ),\n  _xlpm.modelDay,       _xlfn.SEQUENCE(1, 7*_xlpm.modelWeeks),\n  _xlpm.shiftStart,         _xlpm.weekStart + (_xlpm.modelDay-1) + 19/24,\n  _xlpm.shiftEnd,           _xlpm.weekStart + _xlpm.modelDay + 4/24,\n  _xlpm.duration,\n        ( IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectDue),    _xlpm.shiftEnd,  _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftStart<_xlfn.SINGLE(projectDue),  _xlpm.shiftStart, _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectStart),   _xlpm.shiftEnd,  _xlfn.SINGLE(projectStart ))\n        + IF( _xlpm.shiftStart<_xlfn.SINGLE(projectStart), _xlpm.shiftStart, _xlfn.SINGLE(projectStart )) ),\n  _xlpm.availableShift?,  (MOD(_xlpm.modelDay-1, 7) < 5 ),\n  SUM( _xlpm.duration * _xlpm.availableShift? ) )","v":0.35416666666424135}]
[null,"Many days","2020-07-22T21:00:00","2020-07-30T20:30:00",{"$f":" _xlfn.LET(\n  _xlpm.weekStart,       2 + FLOOR( _xlfn.SINGLE(projectStart) - 2, 7 ),\n  _xlpm.modelWeeks, 1 + QUOTIENT(_xlfn.SINGLE(projectDue)-2, 7 )  -  QUOTIENT(_xlfn.SINGLE(projectStart)-2, 7 ),\n  _xlpm.modelDay,       _xlfn.SEQUENCE(1, 7*_xlpm.modelWeeks),\n  _xlpm.shiftStart,         _xlpm.weekStart + (_xlpm.modelDay-1) + 19/24,\n  _xlpm.shiftEnd,           _xlpm.weekStart + _xlpm.modelDay + 4/24,\n  _xlpm.duration,\n        ( IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectDue),    _xlpm.shiftEnd,  _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftStart<_xlfn.SINGLE(projectDue),  _xlpm.shiftStart, _xlfn.SINGLE(projectDue ))\n        - IF( _xlpm.shiftEnd<_xlfn.SINGLE(projectStart),   _xlpm.shiftEnd,  _xlfn.SINGLE(projectStart ))\n        + IF( _xlpm.shiftStart<_xlfn.SINGLE(projectStart), _xlpm.shiftStart, _xlfn.SINGLE(projectStart )) ),\n  _xlpm.availableShift?,  (MOD(_xlpm.modelDay-1, 7) < 5 ),\n  SUM( _xlpm.duration * _xlpm.availableShift? ) )","v":2.2291666666642413}]