{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["C(195)","C(196)","Draw","Mr Excel VBA","excelisfun Power Query","Jiakun Zheng Power Query","Sheet1","Let (2)","Rico S","cr gr0912","Excel Wizard (1)","Excel Wizard (2)","Excel Wizard (3)","Excel Wizard (4)","John Jairo Vergara Domínguez Si","Wayne","Geert","Sandbox","Try(1)","Try(2)","Try(3)","Try(4)","PQ","Let"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":122,"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(195)","index":0,"n_rows":145,"n_cols":26,"rows_kept":145,"cut":false,"hidden":false,"merged":[[2,2,32,18],[37,5,60,15],[144,5,167,15]]}
[]
[]
[null,null,"Dueling Excel\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Duel # 195"]
[]
[]
[]
[null,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,null,{"$f":"LEN(X38)","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,null,{"$f":"SUBSTITUTE(REPLACE(CELL(\"filename\"),1,SEARCH(\"(\",CELL(\"filename\")),\"\"),\")\",\"\")","v":{"$error":"#VALUE!"}}]
[]
[null,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\",B2),1,SEARCH(\"(\",CELL(\"filename\",B2)),\"\"),\")\",\"\")","v":"Excel\nMagic\nTrick\n195"}]
[]
[]
[null,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,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,null,"Formula"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Excel\nGet Last 5 In Column.\nAdd, Average or Display"]

{"sheet":"C(196)","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,2,32,18]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Duel # 195",null,null,null,null,null,"Dueling Excel from Mr Excel & excelisfun #195"]

{"sheet":"Draw","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,8,10,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"2013-2015","è",null,2013,null,"?"]
[null,null,null,null,null,null,2014]
[null,null,null,null,null,null,2015]

{"sheet":"Mr Excel VBA","index":3,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Name","Year"]
["Andy","2013-2015",null,"Andy",2013]
["Barb","2015",null,"Andy",2014]
["Chris","2000-2004",null,"Andy",2015]
["Diane","2001-2006",null,"Barb",2015]
["Ed","2012-2015",null,"Chris",2000]
["Flo","2016-2017",null,"Chris",2001]
["Gary","2005",null,"Chris",2002]
["Hank","2002-2005",null,"Chris",2003]
["Ike","2010",null,"Chris",2004]
["Jared","2014-2018",null,"Diane",2001]
["Kelly","2002-2006",null,"Diane",2002]
["Lou","2001-2006",null,"Diane",2003]
["Mike","2006-2011",null,"Diane",2004]
["Nan","2009",null,"Diane",2005]
["Otto","2002",null,"Diane",2006]
["Paul","2015-2019",null,"Ed",2012]
["Quenten","2010-2011",null,"Ed",2013]
["Raul","2013-2016",null,"Ed",2014]
["Sam","2013-2016",null,"Ed",2015]
[null,null,null,"Flo",2016]
[null,null,null,"Flo",2017]
[null,null,null,"Gary",2005]
[null,null,null,"Hank",2002]
[null,null,null,"Hank",2003]
[null,null,null,"Hank",2004]
[null,null,null,"Hank",2005]
[null,null,null,"Ike",2010]
[null,null,null,"Jared",2014]
[null,null,null,"Jared",2015]
[null,null,null,"Jared",2016]
[null,null,null,"Jared",2017]
[null,null,null,"Jared",2018]
[null,null,null,"Kelly",2002]
[null,null,null,"Kelly",2003]
[null,null,null,"Kelly",2004]
[null,null,null,"Kelly",2005]
[null,null,null,"Kelly",2006]
[null,null,null,"Lou",2001]
[null,null,null,"Lou",2002]
[null,null,null,"Lou",2003]
[null,null,null,"Lou",2004]
[null,null,null,"Lou",2005]
[null,null,null,"Lou",2006]
[null,null,null,"Mike",2006]
[null,null,null,"Mike",2007]
[null,null,null,"Mike",2008]
[null,null,null,"Mike",2009]
[null,null,null,"Mike",2010]
[null,null,null,"Mike",2011]
[null,null,null,"Nan",2009]
[null,null,null,"Otto",2002]
[null,null,null,"Paul",2015]
[null,null,null,"Paul",2016]
[null,null,null,"Paul",2017]
[null,null,null,"Paul",2018]
[null,null,null,"Paul",2019]
[null,null,null,"Quenten",2010]
[null,null,null,"Quenten",2011]
[null,null,null,"Raul",2013]
[null,null,null,"Raul",2014]
[null,null,null,"Raul",2015]
[null,null,null,"Raul",2016]
[null,null,null,"Sam",2013]
[null,null,null,"Sam",2014]
[null,null,null,"Sam",2015]
[null,null,null,"Sam",2016]

{"sheet":"excelisfun Power Query","index":4,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Year","Name"]
["Andy","2013-2015",null,2013,"Andy"]
["Barb","2015",null,2014,"Andy"]
["Chris","2000-2004",null,2015,"Andy"]
["Diane","2001-2006",null,2015,"Barb"]
["Ed","2012-2015",null,2000,"Chris"]
["Flo","2016-2017",null,2001,"Chris"]
["Gary","2005",null,2002,"Chris"]
["Hank","2002-2005",null,2003,"Chris"]
["Ike","2010",null,2004,"Chris"]
["Jared","2014-2018",null,2001,"Diane"]
["Kelly","2002-2006",null,2002,"Diane"]
["Lou","2001-2006",null,2003,"Diane"]
["Mike","2006-2011",null,2004,"Diane"]
["Nan","2009",null,2005,"Diane"]
["Otto","2002",null,2006,"Diane"]
["Paul","2015-2019",null,2012,"Ed"]
["Quenten","2010-2011",null,2013,"Ed"]
["Raul","2013-2016",null,2014,"Ed"]
["Sam","2013-2016",null,2015,"Ed"]
[null,null,null,2016,"Flo"]
[null,null,null,2017,"Flo"]
[null,null,null,2005,"Gary"]
[null,null,null,2002,"Hank"]
[null,null,null,2003,"Hank"]
[null,null,null,2004,"Hank"]
[null,null,null,2005,"Hank"]
[null,null,null,2010,"Ike"]
[null,null,null,2014,"Jared"]
[null,null,null,2015,"Jared"]
[null,null,null,2016,"Jared"]
[null,null,null,2017,"Jared"]
[null,null,null,2018,"Jared"]
[null,null,null,2002,"Kelly"]
[null,null,null,2003,"Kelly"]
[null,null,null,2004,"Kelly"]
[null,null,null,2005,"Kelly"]
[null,null,null,2006,"Kelly"]
[null,null,null,2001,"Lou"]
[null,null,null,2002,"Lou"]
[null,null,null,2003,"Lou"]
[null,null,null,2004,"Lou"]
[null,null,null,2005,"Lou"]
[null,null,null,2006,"Lou"]
[null,null,null,2006,"Mike"]
[null,null,null,2007,"Mike"]
[null,null,null,2008,"Mike"]
[null,null,null,2009,"Mike"]
[null,null,null,2010,"Mike"]
[null,null,null,2011,"Mike"]
[null,null,null,2009,"Nan"]
[null,null,null,2002,"Otto"]
[null,null,null,2015,"Paul"]
[null,null,null,2016,"Paul"]
[null,null,null,2017,"Paul"]
[null,null,null,2018,"Paul"]
[null,null,null,2019,"Paul"]
[null,null,null,2010,"Quenten"]
[null,null,null,2011,"Quenten"]
[null,null,null,2013,"Raul"]
[null,null,null,2014,"Raul"]
[null,null,null,2015,"Raul"]
[null,null,null,2016,"Raul"]
[null,null,null,2013,"Sam"]
[null,null,null,2014,"Sam"]
[null,null,null,2015,"Sam"]
[null,null,null,2016,"Sam"]

{"sheet":"Jiakun Zheng Power Query","index":5,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Name","Custom"]
["Andy","2013-2015",null,"Andy",2013]
["Barb","2015",null,"Andy",2014]
["Chris","2000-2004",null,"Andy",2015]
["Diane","2001-2006",null,"Barb",2015]
["Ed","2012-2015",null,"Chris",2000]
["Flo","2016-2017",null,"Chris",2001]
["Gary","2005",null,"Chris",2002]
["Hank","2002-2005",null,"Chris",2003]
["Ike","2010",null,"Chris",2004]
["Jared","2014-2018",null,"Diane",2001]
["Kelly","2002-2006",null,"Diane",2002]
["Lou","2001-2006",null,"Diane",2003]
["Mike","2006-2011",null,"Diane",2004]
["Nan","2009",null,"Diane",2005]
["Otto","2002",null,"Diane",2006]
["Paul","2015-2019",null,"Ed",2012]
["Quenten","2010-2011",null,"Ed",2013]
["Raul","2013-2016",null,"Ed",2014]
["Sam","2013-2016",null,"Ed",2015]
[null,null,null,"Flo",2016]
[null,null,null,"Flo",2017]
[null,null,null,"Gary",2005]
[null,null,null,"Hank",2002]
[null,null,null,"Hank",2003]
[null,null,null,"Hank",2004]
[null,null,null,"Hank",2005]
[null,null,null,"Ike",2010]
[null,null,null,"Jared",2014]
[null,null,null,"Jared",2015]
[null,null,null,"Jared",2016]
[null,null,null,"Jared",2017]
[null,null,null,"Jared",2018]
[null,null,null,"Kelly",2002]
[null,null,null,"Kelly",2003]
[null,null,null,"Kelly",2004]
[null,null,null,"Kelly",2005]
[null,null,null,"Kelly",2006]
[null,null,null,"Lou",2001]
[null,null,null,"Lou",2002]
[null,null,null,"Lou",2003]
[null,null,null,"Lou",2004]
[null,null,null,"Lou",2005]
[null,null,null,"Lou",2006]
[null,null,null,"Mike",2006]
[null,null,null,"Mike",2007]
[null,null,null,"Mike",2008]
[null,null,null,"Mike",2009]
[null,null,null,"Mike",2010]
[null,null,null,"Mike",2011]
[null,null,null,"Nan",2009]
[null,null,null,"Otto",2002]
[null,null,null,"Paul",2015]
[null,null,null,"Paul",2016]
[null,null,null,"Paul",2017]
[null,null,null,"Paul",2018]
[null,null,null,"Paul",2019]
[null,null,null,"Quenten",2010]
[null,null,null,"Quenten",2011]
[null,null,null,"Raul",2013]
[null,null,null,"Raul",2014]
[null,null,null,"Raul",2015]
[null,null,null,"Raul",2016]
[null,null,null,"Sam",2013]
[null,null,null,"Sam",2014]
[null,null,null,"Sam",2015]
[null,null,null,"Sam",2016]

{"sheet":"Sheet1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Let (2)","index":7,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2019",{"$f":"A2&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B2,4)+0,\n_xlpm.EndYear,RIGHT(B2,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Andy 2013"},"Andy 2014","Andy 2015","Andy 2016","Andy 2017","Andy 2018","Andy 2019",{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(INDEX(C2:H20,INT(_xlfn.SEQUENCE(COUNTA(C2:H20),1,0,1)/6+1),MOD(_xlfn.SEQUENCE(COUNTA(C2:H20),1,0,1),6)+1)))","v":"Andy 2013"},{"$f":"LEFT(_xlfn.ANCHORARRAY(J2),LEN(_xlfn.ANCHORARRAY(J2))-5)","v":"Andy"},{"$f":"RIGHT(_xlfn.ANCHORARRAY(J2),4)","v":"2013"}]
["Barb","2015",{"$f":"A3&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B3,4)+0,\n_xlpm.EndYear,RIGHT(B3,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Barb 2015"},null,null,null,null,null,null,"Andy 2014","Andy","2014"]
["Chris","2000-2004",{"$f":"A4&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B4,4)+0,\n_xlpm.EndYear,RIGHT(B4,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Chris 2000"},"Chris 2001","Chris 2002","Chris 2003","Chris 2004",null,null,"Andy 2015","Andy","2015"]
["Diane","2001-2006",{"$f":"A5&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B5,4)+0,\n_xlpm.EndYear,RIGHT(B5,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Diane 2001"},"Diane 2002","Diane 2003","Diane 2004","Diane 2005","Diane 2006",null,"Andy 2016","Andy","2016"]
["Ed","2012-2015",{"$f":"A6&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B6,4)+0,\n_xlpm.EndYear,RIGHT(B6,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Ed 2012"},"Ed 2013","Ed 2014","Ed 2015",null,null,null,"Andy 2017","Andy","2017"]
["Flo","2016-2017",{"$f":"A7&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B7,4)+0,\n_xlpm.EndYear,RIGHT(B7,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Flo 2016"},"Flo 2017",null,null,null,null,null,"Andy 2018","Andy","2018"]
["Gary","2005",{"$f":"A8&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B8,4)+0,\n_xlpm.EndYear,RIGHT(B8,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Gary 2005"},null,null,null,null,null,null,"Barb 2015","Barb","2015"]
["Hank","2002-2005",{"$f":"A9&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B9,4)+0,\n_xlpm.EndYear,RIGHT(B9,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Hank 2002"},"Hank 2003","Hank 2004","Hank 2005",null,null,null,"Chris 2000","Chris","2000"]
["Ike","2010",{"$f":"A10&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B10,4)+0,\n_xlpm.EndYear,RIGHT(B10,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Ike 2010"},null,null,null,null,null,null,"Chris 2001","Chris","2001"]
["Jared","2014-2018",{"$f":"A11&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B11,4)+0,\n_xlpm.EndYear,RIGHT(B11,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Jared 2014"},"Jared 2015","Jared 2016","Jared 2017","Jared 2018",null,null,"Chris 2002","Chris","2002"]
["Kelly","2002-2006",{"$f":"A12&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B12,4)+0,\n_xlpm.EndYear,RIGHT(B12,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Kelly 2002"},"Kelly 2003","Kelly 2004","Kelly 2005","Kelly 2006",null,null,"Chris 2003","Chris","2003"]
["Lou","2001-2006",{"$f":"A13&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B13,4)+0,\n_xlpm.EndYear,RIGHT(B13,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Lou 2001"},"Lou 2002","Lou 2003","Lou 2004","Lou 2005","Lou 2006",null,"Chris 2004","Chris","2004"]
["Mike","2006-2011",{"$f":"A14&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B14,4)+0,\n_xlpm.EndYear,RIGHT(B14,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Mike 2006"},"Mike 2007","Mike 2008","Mike 2009","Mike 2010","Mike 2011",null,"Diane 2001","Diane","2001"]
["Nan","2009",{"$f":"A15&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B15,4)+0,\n_xlpm.EndYear,RIGHT(B15,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Nan 2009"},null,null,null,null,null,null,"Diane 2002","Diane","2002"]
["Otto","2002",{"$f":"A16&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B16,4)+0,\n_xlpm.EndYear,RIGHT(B16,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Otto 2002"},null,null,null,null,null,null,"Diane 2003","Diane","2003"]
["Paul","2015-2019",{"$f":"A17&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B17,4)+0,\n_xlpm.EndYear,RIGHT(B17,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Paul 2015"},"Paul 2016","Paul 2017","Paul 2018","Paul 2019",null,null,"Diane 2004","Diane","2004"]
["Quenten","2010-2011",{"$f":"A18&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B18,4)+0,\n_xlpm.EndYear,RIGHT(B18,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Quenten 2010"},"Quenten 2011",null,null,null,null,null,"Diane 2005","Diane","2005"]
["Raul","2013-2016",{"$f":"A19&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B19,4)+0,\n_xlpm.EndYear,RIGHT(B19,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Raul 2013"},"Raul 2014","Raul 2015","Raul 2016",null,null,null,"Diane 2006","Diane","2006"]
["Sam","2013-2016",{"$f":"A20&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B20,4)+0,\n_xlpm.EndYear,RIGHT(B20,4)+0,\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Sam 2013"},"Sam 2014","Sam 2015","Sam 2016",null,null,null,"Ed 2012","Ed","2012"]
[null,null,null,null,null,null,null,null,null,"Ed 2013","Ed","2013"]
[null,null,null,null,null,null,null,null,null,"Ed 2014","Ed","2014"]
[null,null,null,null,null,null,null,null,null,"Ed 2015","Ed","2015"]
[null,null,null,null,null,null,null,null,null,"Flo 2016","Flo","2016"]
[null,null,null,null,null,null,null,null,null,"Flo 2017","Flo","2017"]
[null,null,null,null,null,null,null,null,null,"Gary 2005","Gary","2005"]
[null,null,null,null,null,null,null,null,null,"Hank 2002","Hank","2002"]
[null,null,null,null,null,null,null,null,null,"Hank 2003","Hank","2003"]
[null,null,null,null,null,null,null,null,null,"Hank 2004","Hank","2004"]
[null,null,null,null,null,null,null,null,null,"Hank 2005","Hank","2005"]
[null,null,null,null,null,null,null,null,null,"Ike 2010","Ike","2010"]
[null,null,null,null,null,null,null,null,null,"Jared 2014","Jared","2014"]
[null,null,null,null,null,null,null,null,null,"Jared 2015","Jared","2015"]
[null,null,null,null,null,null,null,null,null,"Jared 2016","Jared","2016"]
[null,null,null,null,null,null,null,null,null,"Jared 2017","Jared","2017"]
[null,null,null,null,null,null,null,null,null,"Jared 2018","Jared","2018"]
[null,null,null,null,null,null,null,null,null,"Kelly 2002","Kelly","2002"]
[null,null,null,null,null,null,null,null,null,"Kelly 2003","Kelly","2003"]
[null,null,null,null,null,null,null,null,null,"Kelly 2004","Kelly","2004"]
[null,null,null,null,null,null,null,null,null,"Kelly 2005","Kelly","2005"]
[null,null,null,null,null,null,null,null,null,"Kelly 2006","Kelly","2006"]
[null,null,null,null,null,null,null,null,null,"Lou 2001","Lou","2001"]
[null,null,null,null,null,null,null,null,null,"Lou 2002","Lou","2002"]
[null,null,null,null,null,null,null,null,null,"Lou 2003","Lou","2003"]
[null,null,null,null,null,null,null,null,null,0,{"$error":"#VALUE!"},"0"]

{"sheet":"Rico S","index":8,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015",null,{"$f":"_xlfn.LET(_xlpm._names,A2:A20,\n_xlpm._years,B2:B20,\n_xlpm._firstYr,LEFT(_xlpm._years,4),\n_xlpm._lastYr,RIGHT(_xlpm._years,4),\n_xlpm._yearCnt,_xlpm._lastYr-_xlpm._firstYr+1,\n_xlpm._maxYrCnt,MAX(_xlpm._yearCnt),\n_xlpm._r,COUNTA(_xlpm._years),\n_xlpm._cells,_xlpm._maxYrCnt*_xlpm._r,\n_xlpm._seqYrs,_xlfn.SEQUENCE(_xlpm._r,_xlpm._maxYrCnt)*0+_xlfn.SEQUENCE(1,_xlpm._maxYrCnt,0),\n_xlpm._listYrs2D,_xlpm._firstYr+(_xlpm._seqYrs*(_xlpm._seqYrs<_xlpm._yearCnt)),\n_xlpm._listNames2D,IF(_xlpm._seqYrs>=0,_xlpm._names),\n_xlpm._seqCells,_xlfn.SEQUENCE(_xlpm._cells,1,0),\n_xlpm._rowID,INT(_xlpm._seqCells/_xlpm._maxYrCnt+1),\n_xlpm._colID,MOD(_xlpm._seqCells,_xlpm._maxYrCnt)+1,\n_xlpm._listYrs,INDEX(_xlpm._listYrs2D,_xlpm._rowID,_xlpm._colID),\n_xlpm._listNames,INDEX(_xlpm._listNames2D,_xlpm._rowID,_xlpm._colID),\n_xlpm._listNamesAndYears,_xlfn.SWITCH({1,2},1,_xlpm._listNames,2,_xlpm._listYrs),\n_xlpm._uniqueList,_xlfn.UNIQUE(_xlpm._listNamesAndYears),\n_xlpm._uniqueList)","v":"Andy"},2013]
["Barb","2015",null,"Andy",2014]
["Chris","2000-2004",null,"Andy",2015]
["Diane","2001-2006",null,"Barb",2015]
["Ed","2012-2015",null,"Chris",2000]
["Flo","2016-2017",null,"Chris",2001]
["Gary","2005",null,"Chris",2002]
["Hank","2002-2005",null,"Chris",2003]
["Ike","2010",null,"Chris",2004]
["Jared","2014-2018",null,"Diane",2001]
["Kelly","2002-2006",null,"Diane",2002]
["Lou","2001-2006",null,"Diane",2003]
["Mike","2006-2011",null,"Diane",2004]
["Nan","2009",null,"Diane",2005]
["Otto","2002",null,"Diane",2006]
["Paul","2015-2019",null,"Ed",2012]
["Quenten","2010-2011",null,"Ed",2013]
["Raul","2013-2016",null,"Ed",2014]
["Sam","2013-2016",null,"Ed",2015]
[null,null,null,"Flo",2016]
[null,null,null,"Flo",2017]
[null,null,null,"Gary",2005]
[null,null,null,"Hank",2002]
[null,null,null,"Hank",2003]
[null,null,null,"Hank",2004]
[null,null,null,"Hank",2005]
[null,null,null,"Ike",2010]
[null,null,null,"Jared",2014]
[null,null,null,"Jared",2015]
[null,null,null,"Jared",2016]
[null,null,null,"Jared",2017]
[null,null,null,"Jared",2018]
[null,null,null,"Kelly",2002]
[null,null,null,"Kelly",2003]
[null,null,null,"Kelly",2004]
[null,null,null,"Kelly",2005]
[null,null,null,"Kelly",2006]
[null,null,null,"Lou",2001]
[null,null,null,"Lou",2002]
[null,null,null,"Lou",2003]
[null,null,null,"Lou",2004]
[null,null,null,"Lou",2005]
[null,null,null,"Lou",2006]
[null,null,null,"Mike",2006]
[null,null,null,"Mike",2007]
[null,null,null,"Mike",2008]
[null,null,null,"Mike",2009]
[null,null,null,"Mike",2010]
[null,null,null,"Mike",2011]
[null,null,null,"Nan",2009]
[null,null,null,"Otto",2002]
[null,null,null,"Paul",2015]
[null,null,null,"Paul",2016]
[null,null,null,"Paul",2017]
[null,null,null,"Paul",2018]
[null,null,null,"Paul",2019]
[null,null,null,"Quenten",2010]
[null,null,null,"Quenten",2011]
[null,null,null,"Raul",2013]
[null,null,null,"Raul",2014]
[null,null,null,"Raul",2015]
[null,null,null,"Raul",2016]
[null,null,null,"Sam",2013]
[null,null,null,"Sam",2014]
[null,null,null,"Sam",2015]
[null,null,null,"Sam",2016]

{"sheet":"cr gr0912","index":9,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015",null,{"$f":"_xlfn.LET(_xlpm.nm,A2:A20,_xlpm.yr,B2:B20,_xlpm.r,ROWS(_xlpm.nm),_xlpm.y1r,LEFT(_xlpm.yr,4),_xlpm.y2r,RIGHT(_xlpm.yr,4),_xlpm.i,_xlpm.y2r-_xlpm.y1r+1,_xlpm.c,MAX(_xlpm.i),\n_xlpm.h1r,MOD(_xlfn.SEQUENCE(_xlpm.r,_xlpm.c)-1,_xlpm.c)+_xlpm.y1r,\n_xlpm.h2r,_xlpm.h1r-_xlpm.y2r,\n_xlpm.yarr,IF(_xlpm.h2r<=0,_xlpm.h1r,\"\"),\n_xlpm.narr,REPT(_xlpm.nm,_xlfn.SEQUENCE(,_xlpm.c,1,0)),_xlpm.nmarr,IF(_xlpm.h2r<=0,_xlpm.narr,\"\"),\n_xlpm.sq,_xlfn.SEQUENCE(_xlpm.c*_xlpm.r),_xlpm.md,MOD(_xlpm.sq-1,_xlpm.c)+1,_xlpm.qt,QUOTIENT(_xlpm.sq-1,_xlpm.c)+1,\n_xlpm.nmf,INDEX(_xlpm.nmarr,_xlpm.qt,_xlpm.md),\n_xlpm.yf,INDEX(_xlpm.yarr,_xlpm.qt,_xlpm.md),\n_xlpm.rs,CHOOSE({1,2},_xlpm.nmf,_xlpm.yf),\n_xlpm.rsf,_xlfn._xlws.FILTER(_xlpm.rs,_xlpm.nmf<>\"\"),\n_xlpm.rsf)","v":"Andy"},2013]
["Barb","2015",null,"Andy",2014]
["Chris","2000-2004",null,"Andy",2015]
["Diane","2001-2006",null,"Barb",2015]
["Ed","2012-2015",null,"Chris",2000]
["Flo","2016-2017",null,"Chris",2001]
["Gary","2005",null,"Chris",2002]
["Hank","2002-2005",null,"Chris",2003]
["Ike","2010",null,"Chris",2004]
["Jared","2014-2018",null,"Diane",2001]
["Kelly","2002-2006",null,"Diane",2002]
["Lou","2001-2006",null,"Diane",2003]
["Mike","2006-2011",null,"Diane",2004]
["Nan","2009",null,"Diane",2005]
["Otto","2002",null,"Diane",2006]
["Paul","2015-2019",null,"Ed",2012]
["Quenten","2010-2011",null,"Ed",2013]
["Raul","2013-2016",null,"Ed",2014]
["Sam","2013-2016",null,"Ed",2015]
[null,null,null,"Flo",2016]
[null,null,null,"Flo",2017]
[null,null,null,"Gary",2005]
[null,null,null,"Hank",2002]
[null,null,null,"Hank",2003]
[null,null,null,"Hank",2004]
[null,null,null,"Hank",2005]
[null,null,null,"Ike",2010]
[null,null,null,"Jared",2014]
[null,null,null,"Jared",2015]
[null,null,null,"Jared",2016]
[null,null,null,"Jared",2017]
[null,null,null,"Jared",2018]
[null,null,null,"Kelly",2002]
[null,null,null,"Kelly",2003]
[null,null,null,"Kelly",2004]
[null,null,null,"Kelly",2005]
[null,null,null,"Kelly",2006]
[null,null,null,"Lou",2001]
[null,null,null,"Lou",2002]
[null,null,null,"Lou",2003]
[null,null,null,"Lou",2004]
[null,null,null,"Lou",2005]
[null,null,null,"Lou",2006]
[null,null,null,"Mike",2006]
[null,null,null,"Mike",2007]
[null,null,null,"Mike",2008]
[null,null,null,"Mike",2009]
[null,null,null,"Mike",2010]
[null,null,null,"Mike",2011]
[null,null,null,"Nan",2009]
[null,null,null,"Otto",2002]
[null,null,null,"Paul",2015]
[null,null,null,"Paul",2016]
[null,null,null,"Paul",2017]
[null,null,null,"Paul",2018]
[null,null,null,"Paul",2019]
[null,null,null,"Quenten",2010]
[null,null,null,"Quenten",2011]
[null,null,null,"Raul",2013]
[null,null,null,"Raul",2014]
[null,null,null,"Raul",2015]
[null,null,null,"Raul",2016]
[null,null,null,"Sam",2013]
[null,null,null,"Sam",2014]
[null,null,null,"Sam",2015]
[null,null,null,"Sam",2016]

{"sheet":"Excel Wizard (1)","index":10,"n_rows":124,"n_cols":5,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Name","Years"]
["Andy","2013-2015",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D1,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Andy"},{"$f":"IF(D2=\"\",\"\",LEFT(VLOOKUP(D2,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D1,D2))","v":2013}]
["Barb","2015",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D2,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Andy"},{"$f":"IF(D3=\"\",\"\",LEFT(VLOOKUP(D3,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D2,D3))","v":2014}]
["Chris","2000-2004",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D3,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Andy"},{"$f":"IF(D4=\"\",\"\",LEFT(VLOOKUP(D4,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D3,D4))","v":2015}]
["Diane","2001-2006",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D4,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Barb"},{"$f":"IF(D5=\"\",\"\",LEFT(VLOOKUP(D5,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D4,D5))","v":2015}]
["Ed","2012-2015",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D5,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Chris"},{"$f":"IF(D6=\"\",\"\",LEFT(VLOOKUP(D6,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D5,D6))","v":2000}]
["Flo","2016-2017",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D6,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Chris"},{"$f":"IF(D7=\"\",\"\",LEFT(VLOOKUP(D7,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D6,D7))","v":2001}]
["Gary","2005",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D7,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Chris"},{"$f":"IF(D8=\"\",\"\",LEFT(VLOOKUP(D8,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D7,D8))","v":2002}]
["Hank","2002-2005",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D8,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Chris"},{"$f":"IF(D9=\"\",\"\",LEFT(VLOOKUP(D9,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D8,D9))","v":2003}]
["Ike","2010",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D9,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Chris"},{"$f":"IF(D10=\"\",\"\",LEFT(VLOOKUP(D10,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D9,D10))","v":2004}]
["Jared","2014-2018",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D10,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Diane"},{"$f":"IF(D11=\"\",\"\",LEFT(VLOOKUP(D11,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D10,D11))","v":2001}]
["Kelly","2002-2006",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D11,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Diane"},{"$f":"IF(D12=\"\",\"\",LEFT(VLOOKUP(D12,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D11,D12))","v":2002}]
["Lou","2001-2006",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D12,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Diane"},{"$f":"IF(D13=\"\",\"\",LEFT(VLOOKUP(D13,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D12,D13))","v":2003}]
["Mike","2006-2011",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D13,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Diane"},{"$f":"IF(D14=\"\",\"\",LEFT(VLOOKUP(D14,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D13,D14))","v":2004}]
["Nan","2009",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D14,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Diane"},{"$f":"IF(D15=\"\",\"\",LEFT(VLOOKUP(D15,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D14,D15))","v":2005}]
["Otto","2002",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D15,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Diane"},{"$f":"IF(D16=\"\",\"\",LEFT(VLOOKUP(D16,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D15,D16))","v":2006}]
["Paul","2015-2019",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D16,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Ed"},{"$f":"IF(D17=\"\",\"\",LEFT(VLOOKUP(D17,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D16,D17))","v":2012}]
["Quenten","2010-2011",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D17,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Ed"},{"$f":"IF(D18=\"\",\"\",LEFT(VLOOKUP(D18,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D17,D18))","v":2013}]
["Raul","2013-2016",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D18,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Ed"},{"$f":"IF(D19=\"\",\"\",LEFT(VLOOKUP(D19,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D18,D19))","v":2014}]
["Sam","2013-2016",null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D19,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Ed"},{"$f":"IF(D20=\"\",\"\",LEFT(VLOOKUP(D20,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D19,D20))","v":2015}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D20,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Flo"},{"$f":"IF(D21=\"\",\"\",LEFT(VLOOKUP(D21,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D20,D21))","v":2016}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D21,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Flo"},{"$f":"IF(D22=\"\",\"\",LEFT(VLOOKUP(D22,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D21,D22))","v":2017}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D22,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Gary"},{"$f":"IF(D23=\"\",\"\",LEFT(VLOOKUP(D23,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D22,D23))","v":2005}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D23,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Hank"},{"$f":"IF(D24=\"\",\"\",LEFT(VLOOKUP(D24,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D23,D24))","v":2002}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D24,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Hank"},{"$f":"IF(D25=\"\",\"\",LEFT(VLOOKUP(D25,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D24,D25))","v":2003}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D25,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Hank"},{"$f":"IF(D26=\"\",\"\",LEFT(VLOOKUP(D26,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D25,D26))","v":2004}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D26,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Hank"},{"$f":"IF(D27=\"\",\"\",LEFT(VLOOKUP(D27,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D26,D27))","v":2005}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D27,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Ike"},{"$f":"IF(D28=\"\",\"\",LEFT(VLOOKUP(D28,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D27,D28))","v":2010}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D28,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Jared"},{"$f":"IF(D29=\"\",\"\",LEFT(VLOOKUP(D29,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D28,D29))","v":2014}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D29,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Jared"},{"$f":"IF(D30=\"\",\"\",LEFT(VLOOKUP(D30,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D29,D30))","v":2015}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D30,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Jared"},{"$f":"IF(D31=\"\",\"\",LEFT(VLOOKUP(D31,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D30,D31))","v":2016}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D31,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Jared"},{"$f":"IF(D32=\"\",\"\",LEFT(VLOOKUP(D32,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D31,D32))","v":2017}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D32,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Jared"},{"$f":"IF(D33=\"\",\"\",LEFT(VLOOKUP(D33,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D32,D33))","v":2018}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D33,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Kelly"},{"$f":"IF(D34=\"\",\"\",LEFT(VLOOKUP(D34,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D33,D34))","v":2002}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D34,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Kelly"},{"$f":"IF(D35=\"\",\"\",LEFT(VLOOKUP(D35,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D34,D35))","v":2003}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D35,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Kelly"},{"$f":"IF(D36=\"\",\"\",LEFT(VLOOKUP(D36,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D35,D36))","v":2004}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D36,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Kelly"},{"$f":"IF(D37=\"\",\"\",LEFT(VLOOKUP(D37,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D36,D37))","v":2005}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D37,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Kelly"},{"$f":"IF(D38=\"\",\"\",LEFT(VLOOKUP(D38,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D37,D38))","v":2006}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D38,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Lou"},{"$f":"IF(D39=\"\",\"\",LEFT(VLOOKUP(D39,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D38,D39))","v":2001}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D39,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Lou"},{"$f":"IF(D40=\"\",\"\",LEFT(VLOOKUP(D40,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D39,D40))","v":2002}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D40,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Lou"},{"$f":"IF(D41=\"\",\"\",LEFT(VLOOKUP(D41,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D40,D41))","v":2003}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D41,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Lou"},{"$f":"IF(D42=\"\",\"\",LEFT(VLOOKUP(D42,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D41,D42))","v":2004}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D42,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Lou"},{"$f":"IF(D43=\"\",\"\",LEFT(VLOOKUP(D43,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D42,D43))","v":2005}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D43,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Lou"},{"$f":"IF(D44=\"\",\"\",LEFT(VLOOKUP(D44,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D43,D44))","v":2006}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D44,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Mike"},{"$f":"IF(D45=\"\",\"\",LEFT(VLOOKUP(D45,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D44,D45))","v":2006}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D45,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Mike"},{"$f":"IF(D46=\"\",\"\",LEFT(VLOOKUP(D46,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D45,D46))","v":2007}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D46,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Mike"},{"$f":"IF(D47=\"\",\"\",LEFT(VLOOKUP(D47,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D46,D47))","v":2008}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D47,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Mike"},{"$f":"IF(D48=\"\",\"\",LEFT(VLOOKUP(D48,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D47,D48))","v":2009}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D48,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Mike"},{"$f":"IF(D49=\"\",\"\",LEFT(VLOOKUP(D49,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D48,D49))","v":2010}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D49,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Mike"},{"$f":"IF(D50=\"\",\"\",LEFT(VLOOKUP(D50,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D49,D50))","v":2011}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D50,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Nan"},{"$f":"IF(D51=\"\",\"\",LEFT(VLOOKUP(D51,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D50,D51))","v":2009}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D51,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Otto"},{"$f":"IF(D52=\"\",\"\",LEFT(VLOOKUP(D52,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D51,D52))","v":2002}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D52,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Paul"},{"$f":"IF(D53=\"\",\"\",LEFT(VLOOKUP(D53,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D52,D53))","v":2015}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D53,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Paul"},{"$f":"IF(D54=\"\",\"\",LEFT(VLOOKUP(D54,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D53,D54))","v":2016}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D54,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Paul"},{"$f":"IF(D55=\"\",\"\",LEFT(VLOOKUP(D55,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D54,D55))","v":2017}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D55,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Paul"},{"$f":"IF(D56=\"\",\"\",LEFT(VLOOKUP(D56,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D55,D56))","v":2018}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D56,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Paul"},{"$f":"IF(D57=\"\",\"\",LEFT(VLOOKUP(D57,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D56,D57))","v":2019}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D57,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Quenten"},{"$f":"IF(D58=\"\",\"\",LEFT(VLOOKUP(D58,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D57,D58))","v":2010}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D58,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Quenten"},{"$f":"IF(D59=\"\",\"\",LEFT(VLOOKUP(D59,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D58,D59))","v":2011}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D59,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Raul"},{"$f":"IF(D60=\"\",\"\",LEFT(VLOOKUP(D60,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D59,D60))","v":2013}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D60,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Raul"},{"$f":"IF(D61=\"\",\"\",LEFT(VLOOKUP(D61,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D60,D61))","v":2014}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D61,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Raul"},{"$f":"IF(D62=\"\",\"\",LEFT(VLOOKUP(D62,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D61,D62))","v":2015}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D62,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Raul"},{"$f":"IF(D63=\"\",\"\",LEFT(VLOOKUP(D63,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D62,D63))","v":2016}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D63,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Sam"},{"$f":"IF(D64=\"\",\"\",LEFT(VLOOKUP(D64,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D63,D64))","v":2013}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D64,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Sam"},{"$f":"IF(D65=\"\",\"\",LEFT(VLOOKUP(D65,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D64,D65))","v":2014}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D65,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Sam"},{"$f":"IF(D66=\"\",\"\",LEFT(VLOOKUP(D66,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D65,D66))","v":2015}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D66,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":"Sam"},{"$f":"IF(D67=\"\",\"\",LEFT(VLOOKUP(D67,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D66,D67))","v":2016}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D67,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D68=\"\",\"\",LEFT(VLOOKUP(D68,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D67,D68))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D68,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D69=\"\",\"\",LEFT(VLOOKUP(D69,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D68,D69))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D69,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D70=\"\",\"\",LEFT(VLOOKUP(D70,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D69,D70))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D70,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D71=\"\",\"\",LEFT(VLOOKUP(D71,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D70,D71))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D71,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D72=\"\",\"\",LEFT(VLOOKUP(D72,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D71,D72))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D72,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D73=\"\",\"\",LEFT(VLOOKUP(D73,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D72,D73))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D73,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D74=\"\",\"\",LEFT(VLOOKUP(D74,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D73,D74))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D74,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D75=\"\",\"\",LEFT(VLOOKUP(D75,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D74,D75))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D75,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D76=\"\",\"\",LEFT(VLOOKUP(D76,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D75,D76))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D76,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D77=\"\",\"\",LEFT(VLOOKUP(D77,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D76,D77))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D77,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D78=\"\",\"\",LEFT(VLOOKUP(D78,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D77,D78))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D78,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D79=\"\",\"\",LEFT(VLOOKUP(D79,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D78,D79))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D79,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D80=\"\",\"\",LEFT(VLOOKUP(D80,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D79,D80))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D80,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D81=\"\",\"\",LEFT(VLOOKUP(D81,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D80,D81))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D81,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D82=\"\",\"\",LEFT(VLOOKUP(D82,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D81,D82))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D82,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D83=\"\",\"\",LEFT(VLOOKUP(D83,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D82,D83))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D83,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D84=\"\",\"\",LEFT(VLOOKUP(D84,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D83,D84))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D84,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D85=\"\",\"\",LEFT(VLOOKUP(D85,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D84,D85))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D85,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D86=\"\",\"\",LEFT(VLOOKUP(D86,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D85,D86))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D86,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D87=\"\",\"\",LEFT(VLOOKUP(D87,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D86,D87))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D87,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D88=\"\",\"\",LEFT(VLOOKUP(D88,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D87,D88))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D88,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D89=\"\",\"\",LEFT(VLOOKUP(D89,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D88,D89))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D89,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D90=\"\",\"\",LEFT(VLOOKUP(D90,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D89,D90))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D90,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D91=\"\",\"\",LEFT(VLOOKUP(D91,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D90,D91))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D91,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D92=\"\",\"\",LEFT(VLOOKUP(D92,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D91,D92))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D92,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D93=\"\",\"\",LEFT(VLOOKUP(D93,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D92,D93))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D93,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D94=\"\",\"\",LEFT(VLOOKUP(D94,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D93,D94))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D94,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D95=\"\",\"\",LEFT(VLOOKUP(D95,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D94,D95))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D95,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D96=\"\",\"\",LEFT(VLOOKUP(D96,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D95,D96))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D96,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D97=\"\",\"\",LEFT(VLOOKUP(D97,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D96,D97))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D97,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D98=\"\",\"\",LEFT(VLOOKUP(D98,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D97,D98))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D98,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D99=\"\",\"\",LEFT(VLOOKUP(D99,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D98,D99))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D99,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D100=\"\",\"\",LEFT(VLOOKUP(D100,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D99,D100))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D100,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D101=\"\",\"\",LEFT(VLOOKUP(D101,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D100,D101))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D101,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D102=\"\",\"\",LEFT(VLOOKUP(D102,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D101,D102))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D102,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D103=\"\",\"\",LEFT(VLOOKUP(D103,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D102,D103))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D103,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D104=\"\",\"\",LEFT(VLOOKUP(D104,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D103,D104))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D104,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D105=\"\",\"\",LEFT(VLOOKUP(D105,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D104,D105))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D105,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D106=\"\",\"\",LEFT(VLOOKUP(D106,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D105,D106))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D106,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D107=\"\",\"\",LEFT(VLOOKUP(D107,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D106,D107))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D107,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D108=\"\",\"\",LEFT(VLOOKUP(D108,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D107,D108))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D108,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D109=\"\",\"\",LEFT(VLOOKUP(D109,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D108,D109))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D109,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D110=\"\",\"\",LEFT(VLOOKUP(D110,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D109,D110))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D110,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D111=\"\",\"\",LEFT(VLOOKUP(D111,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D110,D111))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D111,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D112=\"\",\"\",LEFT(VLOOKUP(D112,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D111,D112))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D112,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D113=\"\",\"\",LEFT(VLOOKUP(D113,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D112,D113))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D113,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D114=\"\",\"\",LEFT(VLOOKUP(D114,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D113,D114))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D114,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D115=\"\",\"\",LEFT(VLOOKUP(D115,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D114,D115))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D115,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D116=\"\",\"\",LEFT(VLOOKUP(D116,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D115,D116))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D116,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D117=\"\",\"\",LEFT(VLOOKUP(D117,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D116,D117))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D117,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D118=\"\",\"\",LEFT(VLOOKUP(D118,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D117,D118))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D118,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D119=\"\",\"\",LEFT(VLOOKUP(D119,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D118,D119))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D119,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D120=\"\",\"\",LEFT(VLOOKUP(D120,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D119,D120))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D120,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D121=\"\",\"\",LEFT(VLOOKUP(D121,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D120,D121))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D121,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D122=\"\",\"\",LEFT(VLOOKUP(D122,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D121,D122))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D122,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D123=\"\",\"\",LEFT(VLOOKUP(D123,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D122,D123))","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX($A$2:$A$20,MATCH(0,INDEX(-(COUNTIFS(D$1:D123,$A$2:$A$20)>=RIGHT($B$2:$B$20,4)-LEFT($B$2:$B$20,4)+1),),)),\"\")","v":""},{"$f":"IF(D124=\"\",\"\",LEFT(VLOOKUP(D124,$A$2:$B$20,2,),4)+COUNTIFS(D$1:D123,D124))","v":""}]

{"sheet":"Excel Wizard (2)","index":11,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Name","Years"]
["Andy","2013-2015",null,{"$f":"INDEX(A2:A20,_xlfn.AGGREGATE(15,6,_xlfn.SEQUENCE(ROWS(B2:B20))/(RIGHT(B2:B20,4)-LEFT(B2:B20,4)+1>=_xlfn.SEQUENCE(,MAX(RIGHT(B2:B20,4)-LEFT(B2:B20,4)+1))),_xlfn.SEQUENCE(SUM(RIGHT(B2:B20,4)-LEFT(B2:B20,4)+1))))","v":"Andy"},{"$f":"LEFT(VLOOKUP(_xlfn.ANCHORARRAY(D2),$A$2:$B$20,2,),4)+MOD(_xlfn.AGGREGATE(15,6,_xlfn.SEQUENCE(ROWS(B2:B20))*100+_xlfn.SEQUENCE(,20)-1/(RIGHT(B2:B20,4)-LEFT(B2:B20,4)+1>=_xlfn.SEQUENCE(,20)),_xlfn.SEQUENCE(SUM(RIGHT(B2:B20,4)-LEFT(B2:B20,4)+1))),100)","v":2013}]
["Barb","2015",null,"Andy",2014]
["Chris","2000-2004",null,"Andy",2015]
["Diane","2001-2006",null,"Barb",2015]
["Ed","2012-2015",null,"Chris",2000]
["Flo","2016-2017",null,"Chris",2001]
["Gary","2005",null,"Chris",2002]
["Hank","2002-2005",null,"Chris",2003]
["Ike","2010",null,"Chris",2004]
["Jared","2014-2018",null,"Diane",2001]
["Kelly","2002-2006",null,"Diane",2002]
["Lou","2001-2006",null,"Diane",2003]
["Mike","2006-2011",null,"Diane",2004]
["Nan","2009",null,"Diane",2005]
["Otto","2002",null,"Diane",2006]
["Paul","2015-2019",null,"Ed",2012]
["Quenten","2010-2011",null,"Ed",2013]
["Raul","2013-2016",null,"Ed",2014]
["Sam","2013-2016",null,"Ed",2015]
[null,null,null,"Flo",2016]
[null,null,null,"Flo",2017]
[null,null,null,"Gary",2005]
[null,null,null,"Hank",2002]
[null,null,null,"Hank",2003]
[null,null,null,"Hank",2004]
[null,null,null,"Hank",2005]
[null,null,null,"Ike",2010]
[null,null,null,"Jared",2014]
[null,null,null,"Jared",2015]
[null,null,null,"Jared",2016]
[null,null,null,"Jared",2017]
[null,null,null,"Jared",2018]
[null,null,null,"Kelly",2002]
[null,null,null,"Kelly",2003]
[null,null,null,"Kelly",2004]
[null,null,null,"Kelly",2005]
[null,null,null,"Kelly",2006]
[null,null,null,"Lou",2001]
[null,null,null,"Lou",2002]
[null,null,null,"Lou",2003]
[null,null,null,"Lou",2004]
[null,null,null,"Lou",2005]
[null,null,null,"Lou",2006]
[null,null,null,"Mike",2006]
[null,null,null,"Mike",2007]
[null,null,null,"Mike",2008]
[null,null,null,"Mike",2009]
[null,null,null,"Mike",2010]
[null,null,null,"Mike",2011]
[null,null,null,"Nan",2009]
[null,null,null,"Otto",2002]
[null,null,null,"Paul",2015]
[null,null,null,"Paul",2016]
[null,null,null,"Paul",2017]
[null,null,null,"Paul",2018]
[null,null,null,"Paul",2019]
[null,null,null,"Quenten",2010]
[null,null,null,"Quenten",2011]
[null,null,null,"Raul",2013]
[null,null,null,"Raul",2014]
[null,null,null,"Raul",2015]
[null,null,null,"Raul",2016]
[null,null,null,"Sam",2013]
[null,null,null,"Sam",2014]
[null,null,null,"Sam",2015]
[null,null,null,"Sam",2016]

{"sheet":"Excel Wizard (3)","index":12,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Name","Years"]
["Andy","2013-2015",null,{"$f":"_xlfn.LET(_xlpm.name,A2:A20,_xlpm.y,B2:B20,\n_xlpm.ys,RIGHT(_xlpm.y,4)-LEFT(_xlpm.y,4)+1,\n_xlpm.mx,_xlfn.SEQUENCE(,MAX(_xlpm.ys)),\n_xlpm.ty,_xlfn.SEQUENCE(SUM(_xlpm.ys)),\n_xlpm.ar,_xlfn.SEQUENCE(ROWS(_xlpm.y))/(_xlpm.ys>=_xlpm.mx),\n_xlpm.in,_xlfn.AGGREGATE(15,6,_xlpm.ar,_xlpm.ty),\n_xlpm.pl,MOD(_xlfn.AGGREGATE(15,6,_xlpm.ar*100+_xlpm.mx-1,_xlpm.ty),100),\nCHOOSE({1,2},INDEX(_xlpm.name,_xlpm.in),LEFT(INDEX(_xlpm.y,_xlpm.in),4)+_xlpm.pl))","v":"Andy"},2013]
["Barb","2015",null,"Andy",2014]
["Chris","2000-2004",null,"Andy",2015]
["Diane","2001-2006",null,"Barb",2015]
["Ed","2012-2015",null,"Chris",2000]
["Flo","2016-2017",null,"Chris",2001]
["Gary","2005",null,"Chris",2002]
["Hank","2002-2005",null,"Chris",2003]
["Ike","2010",null,"Chris",2004]
["Jared","2014-2018",null,"Diane",2001]
["Kelly","2002-2006",null,"Diane",2002]
["Lou","2001-2006",null,"Diane",2003]
["Mike","2006-2011",null,"Diane",2004]
["Nan","2009",null,"Diane",2005]
["Otto","2002",null,"Diane",2006]
["Paul","2015-2019",null,"Ed",2012]
["Quenten","2010-2011",null,"Ed",2013]
["Raul","2013-2016",null,"Ed",2014]
["Sam","2013-2016",null,"Ed",2015]
[null,null,null,"Flo",2016]
[null,null,null,"Flo",2017]
[null,null,null,"Gary",2005]
[null,null,null,"Hank",2002]
[null,null,null,"Hank",2003]
[null,null,null,"Hank",2004]
[null,null,null,"Hank",2005]
[null,null,null,"Ike",2010]
[null,null,null,"Jared",2014]
[null,null,null,"Jared",2015]
[null,null,null,"Jared",2016]
[null,null,null,"Jared",2017]
[null,null,null,"Jared",2018]
[null,null,null,"Kelly",2002]
[null,null,null,"Kelly",2003]
[null,null,null,"Kelly",2004]
[null,null,null,"Kelly",2005]
[null,null,null,"Kelly",2006]
[null,null,null,"Lou",2001]
[null,null,null,"Lou",2002]
[null,null,null,"Lou",2003]
[null,null,null,"Lou",2004]
[null,null,null,"Lou",2005]
[null,null,null,"Lou",2006]
[null,null,null,"Mike",2006]
[null,null,null,"Mike",2007]
[null,null,null,"Mike",2008]
[null,null,null,"Mike",2009]
[null,null,null,"Mike",2010]
[null,null,null,"Mike",2011]
[null,null,null,"Nan",2009]
[null,null,null,"Otto",2002]
[null,null,null,"Paul",2015]
[null,null,null,"Paul",2016]
[null,null,null,"Paul",2017]
[null,null,null,"Paul",2018]
[null,null,null,"Paul",2019]
[null,null,null,"Quenten",2010]
[null,null,null,"Quenten",2011]
[null,null,null,"Raul",2013]
[null,null,null,"Raul",2014]
[null,null,null,"Raul",2015]
[null,null,null,"Raul",2016]
[null,null,null,"Sam",2013]
[null,null,null,"Sam",2014]
[null,null,null,"Sam",2015]
[null,null,null,"Sam",2016]

{"sheet":"Excel Wizard (4)","index":13,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Name","Years"]
["Andy","2013-2015",null,{"$f":"TRIM(MID(_xlfn.FILTERXML(\"<n><m>\"&SUBSTITUTE(_xlfn.TEXTJOIN(\"|\",,REPT(A2:A20&REPT(\" \",20)&LEFT(B2:B20,4)+_xlfn.SEQUENCE(,20)-1,RIGHT(B2:B20,4)-LEFT(B2:B20,4)+1>=_xlfn.SEQUENCE(,20))),\"|\",\"</m><m>\")&\"</m></n>\",\"//m\"),{1,21},20))","v":"Andy"},"2013"]
["Barb","2015",null,"Andy","2014"]
["Chris","2000-2004",null,"Andy","2015"]
["Diane","2001-2006",null,"Barb","2015"]
["Ed","2012-2015",null,"Chris","2000"]
["Flo","2016-2017",null,"Chris","2001"]
["Gary","2005",null,"Chris","2002"]
["Hank","2002-2005",null,"Chris","2003"]
["Ike","2010",null,"Chris","2004"]
["Jared","2014-2018",null,"Diane","2001"]
["Kelly","2002-2006",null,"Diane","2002"]
["Lou","2001-2006",null,"Diane","2003"]
["Mike","2006-2011",null,"Diane","2004"]
["Nan","2009",null,"Diane","2005"]
["Otto","2002",null,"Diane","2006"]
["Paul","2015-2019",null,"Ed","2012"]
["Quenten","2010-2011",null,"Ed","2013"]
["Raul","2013-2016",null,"Ed","2014"]
["Sam","2013-2016",null,"Ed","2015"]
[null,null,null,"Flo","2016"]
[null,null,null,"Flo","2017"]
[null,null,null,"Gary","2005"]
[null,null,null,"Hank","2002"]
[null,null,null,"Hank","2003"]
[null,null,null,"Hank","2004"]
[null,null,null,"Hank","2005"]
[null,null,null,"Ike","2010"]
[null,null,null,"Jared","2014"]
[null,null,null,"Jared","2015"]
[null,null,null,"Jared","2016"]
[null,null,null,"Jared","2017"]
[null,null,null,"Jared","2018"]
[null,null,null,"Kelly","2002"]
[null,null,null,"Kelly","2003"]
[null,null,null,"Kelly","2004"]
[null,null,null,"Kelly","2005"]
[null,null,null,"Kelly","2006"]
[null,null,null,"Lou","2001"]
[null,null,null,"Lou","2002"]
[null,null,null,"Lou","2003"]
[null,null,null,"Lou","2004"]
[null,null,null,"Lou","2005"]
[null,null,null,"Lou","2006"]
[null,null,null,"Mike","2006"]
[null,null,null,"Mike","2007"]
[null,null,null,"Mike","2008"]
[null,null,null,"Mike","2009"]
[null,null,null,"Mike","2010"]
[null,null,null,"Mike","2011"]
[null,null,null,"Nan","2009"]
[null,null,null,"Otto","2002"]
[null,null,null,"Paul","2015"]
[null,null,null,"Paul","2016"]
[null,null,null,"Paul","2017"]
[null,null,null,"Paul","2018"]
[null,null,null,"Paul","2019"]
[null,null,null,"Quenten","2010"]
[null,null,null,"Quenten","2011"]
[null,null,null,"Raul","2013"]
[null,null,null,"Raul","2014"]
[null,null,null,"Raul","2015"]
[null,null,null,"Raul","2016"]
[null,null,null,"Sam","2013"]
[null,null,null,"Sam","2014"]
[null,null,null,"Sam","2015"]
[null,null,null,"Sam","2016"]

{"sheet":"John Jairo Vergara Domínguez Si","index":14,"n_rows":67,"n_cols":34,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,"Name","Years",null,null,null,null,null,"Name","Years"]
["Andy","2013-2015",null,{"$f":"_xlfn.LET(_xlpm.n,A2:A20,_xlpm.a,B2:B20,_xlpm.f,ROW(_xlpm.a),_xlpm.i,LEFT(_xlpm.a,4),_xlpm.c,1+RIGHT(_xlpm.a,4)-_xlpm.i,_xlpm.s,_xlfn.SEQUENCE(SUM(_xlpm.c))-1,_xlpm.m,MMULT(--(_xlpm.f>TRANSPOSE(_xlpm.f)),_xlpm.c),IF({1,0},LOOKUP(_xlpm.s,_xlpm.m,_xlpm.n),LOOKUP(_xlpm.s,_xlpm.m,_xlpm.i)-LOOKUP(_xlpm.s,_xlpm.m)+_xlpm.s))","v":"Andy"},2013,null,null,null,null,null,{"$f":"_xlfn.LET(_xlpm.Names,A2:A20,_xlpm.Years,B2:B20,\n_xlpm.Rows,ROW(A2:A20),\n_xlpm.StartY,LEFT(_xlpm.Years,4),\n_xlpm.NumY,1+RIGHT(_xlpm.Years,4)-_xlpm.StartY,\n_xlpm.LookupValues,_xlfn.SEQUENCE(SUM(_xlpm.NumY),,0),\n_xlpm.LookupRange,MMULT(--(_xlpm.Rows>TRANSPOSE(_xlpm.Rows)),_xlpm.NumY),\n_xlpm.FirstColumn,LOOKUP(_xlpm.LookupValues,_xlpm.LookupRange,_xlpm.Names),\n_xlpm.SecondColumn,LOOKUP(_xlpm.LookupValues,_xlpm.LookupRange,_xlpm.StartY)-LOOKUP(_xlpm.LookupValues,_xlpm.LookupRange)+_xlpm.LookupValues,\n_xlpm.Final,IF({1,0},_xlpm.FirstColumn,_xlpm.SecondColumn),_xlpm.Final)","v":"Andy"},2013]
["Barb","2015",null,"Andy",2014,null,null,null,null,null,"Andy",2014]
["Chris","2000-2004",null,"Andy",2015,null,null,null,null,null,"Andy",2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1+RIGHT(B2:B20,4)-LEFT(B2:B20,4)","v":3}]
["Diane","2001-2006",null,"Barb",2015,null,null,null,null,null,"Barb",2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Ed","2012-2015",null,"Chris",2000,null,null,null,null,null,"Chris",2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Flo","2016-2017",null,"Chris",2001,null,null,null,null,null,"Chris",2001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["Gary","2005",null,"Chris",2002,null,null,null,null,null,"Chris",2002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Hank","2002-2005",null,"Chris",2003,null,null,null,null,null,"Chris",2003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Ike","2010",null,"Chris",2004,null,null,null,null,null,"Chris",2004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Jared","2014-2018",null,"Diane",2001,null,null,null,null,null,"Diane",2001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
["Kelly","2002-2006",null,"Diane",2002,null,null,null,null,null,"Diane",2002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Lou","2001-2006",null,"Diane",2003,null,null,null,null,null,"Diane",2003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Mike","2006-2011",null,"Diane",2004,null,null,null,null,null,"Diane",2004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Nan","2009",null,"Diane",2005,null,null,null,null,null,"Diane",2005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["Otto","2002",null,"Diane",2006,null,null,null,null,null,"Diane",2006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
["Paul","2015-2019",null,"Ed",2012,null,null,null,null,null,"Ed",2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Quenten","2010-2011",null,"Ed",2013,null,null,null,null,null,"Ed",2013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Raul","2013-2016",null,"Ed",2014,null,null,null,null,null,"Ed",2014,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Sam","2013-2016",null,"Ed",2015,null,null,null,null,null,"Ed",2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,"Flo",2016,null,null,null,null,null,"Flo",2016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,"Flo",2017,null,null,null,null,null,"Flo",2017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,"Gary",2005,null,null,null,null,null,"Gary",2005]
[null,null,null,"Hank",2002,null,null,null,null,null,"Hank",2002]
[null,null,null,"Hank",2003,null,null,null,null,null,"Hank",2003]
[null,null,null,"Hank",2004,null,null,null,null,null,"Hank",2004]
[null,null,null,"Hank",2005,null,null,null,null,null,"Hank",2005]
[null,null,null,"Ike",2010,null,null,null,null,null,"Ike",2010]
[null,null,null,"Jared",2014,null,null,null,null,null,"Jared",2014]
[null,null,null,"Jared",2015,null,null,null,null,null,"Jared",2015]
[null,null,null,"Jared",2016,null,null,null,null,null,"Jared",2016]
[null,null,null,"Jared",2017,null,null,null,null,null,"Jared",2017]
[null,null,null,"Jared",2018,null,null,null,null,null,"Jared",2018]
[null,null,null,"Kelly",2002,null,null,null,null,null,"Kelly",2002]
[null,null,null,"Kelly",2003,null,null,null,null,null,"Kelly",2003]
[null,null,null,"Kelly",2004,null,null,null,null,null,"Kelly",2004]
[null,null,null,"Kelly",2005,null,null,null,null,null,"Kelly",2005]
[null,null,null,"Kelly",2006,null,null,null,null,null,"Kelly",2006]
[null,null,null,"Lou",2001,null,null,null,null,null,"Lou",2001]
[null,null,null,"Lou",2002,null,null,null,null,null,"Lou",2002]
[null,null,null,"Lou",2003,null,null,null,null,null,"Lou",2003]
[null,null,null,"Lou",2004,null,null,null,null,null,"Lou",2004]
[null,null,null,"Lou",2005,null,null,null,null,null,"Lou",2005]
[null,null,null,"Lou",2006,null,null,null,null,null,"Lou",2006]
[null,null,null,"Mike",2006,null,null,null,null,null,"Mike",2006]
[null,null,null,"Mike",2007,null,null,null,null,null,"Mike",2007]
[null,null,null,"Mike",2008,null,null,null,null,null,"Mike",2008]
[null,null,null,"Mike",2009,null,null,null,null,null,"Mike",2009]
[null,null,null,"Mike",2010,null,null,null,null,null,"Mike",2010]
[null,null,null,"Mike",2011,null,null,null,null,null,"Mike",2011]
[null,null,null,"Nan",2009,null,null,null,null,null,"Nan",2009]
[null,null,null,"Otto",2002,null,null,null,null,null,"Otto",2002]
[null,null,null,"Paul",2015,null,null,null,null,null,"Paul",2015]
[null,null,null,"Paul",2016,null,null,null,null,null,"Paul",2016]
[null,null,null,"Paul",2017,null,null,null,null,null,"Paul",2017]
[null,null,null,"Paul",2018,null,null,null,null,null,"Paul",2018]
[null,null,null,"Paul",2019,null,null,null,null,null,"Paul",2019]
[null,null,null,"Quenten",2010,null,null,null,null,null,"Quenten",2010]
[null,null,null,"Quenten",2011,null,null,null,null,null,"Quenten",2011]
[null,null,null,"Raul",2013,null,null,null,null,null,"Raul",2013]
[null,null,null,"Raul",2014,null,null,null,null,null,"Raul",2014]
[null,null,null,"Raul",2015,null,null,null,null,null,"Raul",2015]
[null,null,null,"Raul",2016,null,null,null,null,null,"Raul",2016]
[null,null,null,"Sam",2013,null,null,null,null,null,"Sam",2013]
[null,null,null,"Sam",2014,null,null,null,null,null,"Sam",2014]
[null,null,null,"Sam",2015,null,null,null,null,null,"Sam",2015]
[null,null,null,"Sam",2016,null,null,null,null,null,"Sam",2016]

{"sheet":"Wayne","index":15,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015",null,{"$f":"A2&\" \"&_xlfn.SEQUENCE(,RIGHT(B2,4)-LEFT(B2,4)+1,LEFT(B2,4),1)","v":"Andy 2013"},"Andy 2014","Andy 2015"]
["Barb","2015",null,{"$f":"A3&\" \"&_xlfn.SEQUENCE(,RIGHT(B3,4)-LEFT(B3,4)+1,LEFT(B3,4),1)","v":"Barb 2015"}]
["Chris","2000-2004",null,{"$f":"A4&\" \"&_xlfn.SEQUENCE(,RIGHT(B4,4)-LEFT(B4,4)+1,LEFT(B4,4),1)","v":"Chris 2000"},"Chris 2001","Chris 2002","Chris 2003","Chris 2004"]
["Diane","2001-2006",null,{"$f":"A5&\" \"&_xlfn.SEQUENCE(,RIGHT(B5,4)-LEFT(B5,4)+1,LEFT(B5,4),1)","v":"Diane 2001"},"Diane 2002","Diane 2003","Diane 2004","Diane 2005","Diane 2006"]
["Ed","2012-2015",null,{"$f":"A6&\" \"&_xlfn.SEQUENCE(,RIGHT(B6,4)-LEFT(B6,4)+1,LEFT(B6,4),1)","v":"Ed 2012"},"Ed 2013","Ed 2014","Ed 2015"]
["Flo","2016-2017",null,{"$f":"A7&\" \"&_xlfn.SEQUENCE(,RIGHT(B7,4)-LEFT(B7,4)+1,LEFT(B7,4),1)","v":"Flo 2016"},"Flo 2017"]
["Gary","2005",null,{"$f":"A8&\" \"&_xlfn.SEQUENCE(,RIGHT(B8,4)-LEFT(B8,4)+1,LEFT(B8,4),1)","v":"Gary 2005"}]
["Hank","2002-2005",null,{"$f":"A9&\" \"&_xlfn.SEQUENCE(,RIGHT(B9,4)-LEFT(B9,4)+1,LEFT(B9,4),1)","v":"Hank 2002"},"Hank 2003","Hank 2004","Hank 2005"]
["Ike","2010",null,{"$f":"A10&\" \"&_xlfn.SEQUENCE(,RIGHT(B10,4)-LEFT(B10,4)+1,LEFT(B10,4),1)","v":"Ike 2010"}]
["Jared","2014-2018",null,{"$f":"A11&\" \"&_xlfn.SEQUENCE(,RIGHT(B11,4)-LEFT(B11,4)+1,LEFT(B11,4),1)","v":"Jared 2014"},"Jared 2015","Jared 2016","Jared 2017","Jared 2018"]
["Kelly","2002-2006",null,{"$f":"A12&\" \"&_xlfn.SEQUENCE(,RIGHT(B12,4)-LEFT(B12,4)+1,LEFT(B12,4),1)","v":"Kelly 2002"},"Kelly 2003","Kelly 2004","Kelly 2005","Kelly 2006"]
["Lou","2001-2006",null,{"$f":"A13&\" \"&_xlfn.SEQUENCE(,RIGHT(B13,4)-LEFT(B13,4)+1,LEFT(B13,4),1)","v":"Lou 2001"},"Lou 2002","Lou 2003","Lou 2004","Lou 2005","Lou 2006"]
["Mike","2006-2011",null,{"$f":"A14&\" \"&_xlfn.SEQUENCE(,RIGHT(B14,4)-LEFT(B14,4)+1,LEFT(B14,4),1)","v":"Mike 2006"},"Mike 2007","Mike 2008","Mike 2009","Mike 2010","Mike 2011"]
["Nan","2009",null,{"$f":"A15&\" \"&_xlfn.SEQUENCE(,RIGHT(B15,4)-LEFT(B15,4)+1,LEFT(B15,4),1)","v":"Nan 2009"}]
["Otto","2002",null,{"$f":"A16&\" \"&_xlfn.SEQUENCE(,RIGHT(B16,4)-LEFT(B16,4)+1,LEFT(B16,4),1)","v":"Otto 2002"}]
["Paul","2015-2019",null,{"$f":"A17&\" \"&_xlfn.SEQUENCE(,RIGHT(B17,4)-LEFT(B17,4)+1,LEFT(B17,4),1)","v":"Paul 2015"},"Paul 2016","Paul 2017","Paul 2018","Paul 2019"]
["Quenten","2010-2011",null,{"$f":"A18&\" \"&_xlfn.SEQUENCE(,RIGHT(B18,4)-LEFT(B18,4)+1,LEFT(B18,4),1)","v":"Quenten 2010"},"Quenten 2011"]
["Raul","2013-2016",null,{"$f":"A19&\" \"&_xlfn.SEQUENCE(,RIGHT(B19,4)-LEFT(B19,4)+1,LEFT(B19,4),1)","v":"Raul 2013"},"Raul 2014","Raul 2015","Raul 2016"]
["Sam","2013-2016",null,{"$f":"A20&\" \"&_xlfn.SEQUENCE(,RIGHT(B20,4)-LEFT(B20,4)+1,LEFT(B20,4),1)","v":"Sam 2013"},"Sam 2014","Sam 2015","Sam 2016"]

{"sheet":"Geert","index":16,"n_rows":20,"n_cols":67,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Wyn from Access Analytic, November 2022 challenge:"]
[null,"Normalize this table:",null,null,null,"Single Cell Solution 1:",null,null,"Single Cell Solution 2:"]
[null,"Label","IDs",null,null,{"$f":"_xlfn.LET(_xlpm.FullTable,fRAW[#All],_xlpm.headers,_xlfn.TAKE(_xlpm.FullTable,1),\n_xlpm.labels,_xlfn.DROP(_xlfn.TAKE(_xlpm.FullTable,,1),1),_xlpm.data,_xlfn.DROP(_xlfn.TAKE(_xlpm.FullTable,,-1),1),\n_xlpm.splitdata,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\";\",,_xlpm.data),\"-\",\";\"),\n_xlpm.LB,_xlfn.TAKE(_xlpm.splitdata,,1), _xlpm.UB,_xlfn.TAKE(_xlpm.splitdata,,-1),\n_xlpm.RangeLabel,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.MAP(_xlpm.labels,_xlpm.LB,_xlpm.UB,_xlfn.LAMBDA(_xlpm.L,_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,IF(_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,1,1),_xlpm.L,\"\"))))),,\",\"),\n_xlpm.RangeData,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.MAP(_xlpm.LB,_xlpm.UB,_xlfn.LAMBDA(_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,_xlpm.a))))),,\",\")+0,\n_xlfn.VSTACK(_xlpm.headers,_xlfn.HSTACK(_xlpm.RangeLabel,_xlpm.RangeData)))","v":"Label"},"IDs",null,{"$f":"_xlfn.LET(_xlpm.FullTable,fRAW[#All],_xlpm.headers,_xlfn.TAKE(_xlpm.FullTable,1),\n_xlpm.labels,_xlfn.DROP(_xlfn.TAKE(_xlpm.FullTable,,1),1),_xlpm.data,_xlfn.DROP(_xlfn.TAKE(_xlpm.FullTable,,-1),1),\n_xlpm.LB,_xlfn.TEXTBEFORE(_xlpm.data,\"-\"), _xlpm.UB,_xlfn.TEXTAFTER(_xlpm.data,\"-\"),\n_xlpm.RangeLabel,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.MAP(_xlpm.labels,_xlpm.LB,_xlpm.UB,_xlfn.LAMBDA(_xlpm.L,_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,IF(_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,1,1),_xlpm.L,\"\"))))),,\",\"),\n_xlpm.RangeData,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.MAP(_xlpm.LB,_xlpm.UB,_xlfn.LAMBDA(_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,_xlpm.a))))),,\",\")+0,\n_xlfn.VSTACK(_xlpm.headers,_xlfn.HSTACK(_xlpm.RangeLabel,_xlpm.RangeData)))","v":"Label"},"IDs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.LET(\n_xlpm.t,fRAW[#All],\n_xlpm.h,_xlfn.TAKE(_xlpm.t,1),\n_xlpm.c,fRAW[[#This Row],[IDs]],\n_xlpm.dl,SEARCH(\"-\",_xlpm.c),\n_xlpm.fl,_xlpm.dl-1,\n_xlpm.ll,LEN(_xlpm.c)-_xlpm.fl-1,\n_xlpm.f,--LEFT(fRAW[[#This Row],[IDs]],_xlpm.fl),\n_xlpm.l,--RIGHT(fRAW[[#This Row],[IDs]],_xlpm.ll),\n_xlpm.seq,_xlfn.SEQUENCE(_xlpm.l-_xlpm.f+1,,_xlpm.f),_xlpm.h)","v":"Label"},"IDs"]
[null,"Label A","1001-1005",null,null,"Label A",1001,null,"Label A",1001]
[null,"Label B","2007-2013",null,null,"Label A",1002,null,"Label A",1002]
[null,"Label C","3005-3009",null,null,"Label A",1003,null,"Label A",1003]
[null,null,null,null,null,"Label A",1004,null,"Label A",1004]
[null,null,null,null,null,"Label A",1005,null,"Label A",1005]
[null,null,null,null,null,"Label B",2007,null,"Label B",2007]
[null,null,null,null,null,"Label B",2008,null,"Label B",2008]
[null,null,null,null,null,"Label B",2009,null,"Label B",2009]
[null,null,null,null,null,"Label B",2010,null,"Label B",2010]
[null,null,null,null,null,"Label B",2011,null,"Label B",2011]
[null,null,null,null,null,"Label B",2012,null,"Label B",2012]
[null,null,null,null,null,"Label B",2013,null,"Label B",2013]
[null,null,null,null,null,"Label C",3005,null,"Label C",3005]
[null,null,null,null,null,"Label C",3006,null,"Label C",3006]
[null,null,null,null,null,"Label C",3007,null,"Label C",3007]
[null,null,null,null,null,"Label C",3008,null,"Label C",3008]
[null,null,null,null,null,"Label C",3009,null,"Label C",3009]

{"sheet":"Sandbox","index":17,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(I6),\"\")","v":"=TEXTSPLIT(TEXTJOIN(\";\",,G6:G8),\"-\",\";\")"},null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(O11),\"\")","v":"=MAP(F6:F8,L6#,M6#,LAMBDA(L,a,b,TEXTJOIN(\",\",,IF(SEQUENCE(,b-a+1,1,1),L,\"\"))))"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(L6),\"\")","v":"=TAKE(I6#,,1)"},null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(O6),\"\")","v":"=MAP(L6#,M6#,LAMBDA(a,b,TEXTJOIN(\",\",,SEQUENCE(,b-a+1,a))))"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(_xlfn.FORMULATEXT(M6),\"\")","v":"=TAKE(I6#,,-1)"},null,null,"",null,"","",null,{"$f":"IFERROR(_xlfn.FORMULATEXT(U6),\"\")","v":"=TEXTSPLIT(TEXTJOIN(\",\",,O6#),,\",\")"}]
[null,null,null,null,null,"Label","IDs",null,"split",null,null,"LB","UB",null,"Range Data",null,null,null,null,"Flat Label","Flat Data",null,"Single Array"]
[null,null,null,{"$f":"_xlfn.TEXTBEFORE(G6:G8,\"-\")","v":"1001"},null,"Label A","1001-1005",null,{"$f":"_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\";\",,G6:G8),\"-\",\";\")","v":"1001"},"1005",null,{"$f":"_xlfn.TAKE(_xlfn.ANCHORARRAY(I6),,1)","v":"1001"},{"$f":"_xlfn.TAKE(_xlfn.ANCHORARRAY(I6),,-1)","v":"1005"},null,{"$f":"_xlfn.MAP(_xlfn.ANCHORARRAY(L6),_xlfn.ANCHORARRAY(M6),_xlfn.LAMBDA(_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,_xlpm.a))))","v":"1001,1002,1003,1004,1005"},null,null,null,null,{"$f":"_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.ANCHORARRAY(O11)),,\",\")","v":"Label A"},{"$f":"_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.ANCHORARRAY(O6)),,\",\")","v":"1001"},null,{"$f":"_xlfn.HSTACK(_xlfn.ANCHORARRAY(T6),_xlfn.ANCHORARRAY(U6))","v":"Label A"},"1001"]
[null,null,null,"2007",null,"Label B","2007-2013",null,"2007","2013",null,"2007","2013",null,"2007,2008,2009,2010,2011,2012,2013",null,null,null,null,"Label A","1002",null,"Label A","1002"]
[null,null,null,"3005",null,"Label C","3005-3009",null,"3005","3009",null,"3005","3009",null,"3005,3006,3007,3008,3009",null,null,null,null,"Label A","1003",null,"Label A","1003"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Label A","1004",null,"Label A","1004"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range Label",null,null,null,null,"Label A","1005",null,"Label A","1005"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.MAP(F6:F8,_xlfn.ANCHORARRAY(L6),_xlfn.ANCHORARRAY(M6),_xlfn.LAMBDA(_xlpm.L,_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,IF(_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,1,1),_xlpm.L,\"\"))))","v":"Label A,Label A,Label A,Label A,Label A"},null,null,null,null,"Label B","2007",null,"Label B","2007"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Label B,Label B,Label B,Label B,Label B,Label B,Label B",null,null,null,null,"Label B","2008",null,"Label B","2008"]
[null,null,null,null,null,{"$f":"_xlfn.LET(_xlpm.labels,F6:F8,_xlpm.data,G6:G8,\n_xlpm.splitdata,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\";\",,_xlpm.data),\"-\",\";\"),\n_xlpm.LB,_xlfn.TAKE(_xlpm.splitdata,,1), _xlpm.UB,_xlfn.TAKE(_xlpm.splitdata,,-1),\n_xlpm.RangeLabel,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.MAP(_xlpm.labels,_xlpm.LB,_xlpm.UB,_xlfn.LAMBDA(_xlpm.L,_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,IF(_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,1,1),_xlpm.L,\"\"))))),,\",\"),\n_xlpm.RangeData,_xlfn.TEXTSPLIT(_xlfn.TEXTJOIN(\",\",,_xlfn.MAP(_xlpm.LB,_xlpm.UB,_xlfn.LAMBDA(_xlpm.a,_xlpm.b,_xlfn.TEXTJOIN(\",\",,_xlfn.SEQUENCE(,_xlpm.b-_xlpm.a+1,_xlpm.a))))),,\",\"),\n_xlfn.HSTACK(_xlpm.RangeLabel,_xlpm.RangeData))","v":"Label A"},"1001",null,null,null,null,null,null,null,"Label C,Label C,Label C,Label C,Label C",null,null,null,null,"Label B","2009",null,"Label B","2009"]
[null,null,null,null,null,"Label A","1002",null,null,null,null,null,null,null,null,null,null,null,null,"Label B","2010",null,"Label B","2010"]
[null,null,null,null,null,"Label A","1003",null,null,null,null,null,null,null,null,null,null,null,null,"Label B","2011",null,"Label B","2011"]
[null,null,null,null,null,"Label A","1004",null,null,null,null,null,null,null,null,null,null,null,null,"Label B","2012",null,"Label B","2012"]
[null,null,null,null,null,"Label A","1005",null,null,null,null,null,null,null,null,null,null,null,null,"Label B","2013",null,"Label B","2013"]
[null,null,null,null,null,"Label B","2007",null,null,null,null,null,null,null,null,null,null,null,null,"Label C","3005",null,"Label C","3005"]
[null,null,null,null,null,"Label B","2008",null,null,null,null,null,null,null,null,null,null,null,null,"Label C","3006",null,"Label C","3006"]
[null,null,null,null,null,"Label B","2009",null,null,null,null,null,null,null,null,null,null,null,null,"Label C","3007",null,"Label C","3007"]
[null,null,null,null,null,"Label B","2010",null,null,null,null,null,null,null,null,null,null,null,null,"Label C","3008",null,"Label C","3008"]
[null,null,null,null,null,"Label B","2011",null,null,null,null,null,null,null,null,null,null,null,null,"Label C","3009",null,"Label C","3009"]
[null,null,null,null,null,"Label B","2012"]
[null,null,null,null,null,"Label B","2013"]
[null,null,null,null,null,"Label C","3005"]
[null,null,null,null,null,"Label C","3006"]
[null,null,null,null,null,"Label C","3007"]
[null,null,null,null,null,"Label C","3008"]
[null,null,null,null,null,"Label C","3009"]

{"sheet":"Try(1)","index":18,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015"]
["Barb","2015"]
["Chris","2000-2004"]
["Diane","2001-2006"]
["Ed","2012-2015"]
["Flo","2016-2017"]
["Gary","2005"]
["Hank","2002-2005"]
["Ike","2010"]
["Jared","2014-2018"]
["Kelly","2002-2006"]
["Lou","2001-2006"]
["Mike","2006-2011"]
["Nan","2009"]
["Otto","2002"]
["Paul","2015-2019"]
["Quenten","2010-2011"]
["Raul","2013-2016"]
["Sam","2013-2016"]

{"sheet":"Try(2)","index":19,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015"]
["Barb","2015"]
["Chris","2000-2004"]
["Diane","2001-2006"]
["Ed","2012-2015"]
["Flo","2016-2017"]
["Gary","2005"]
["Hank","2002-2005"]
["Ike","2010"]
["Jared","2014-2018"]
["Kelly","2002-2006"]
["Lou","2001-2006"]
["Mike","2006-2011"]
["Nan","2009"]
["Otto","2002"]
["Paul","2015-2019"]
["Quenten","2010-2011"]
["Raul","2013-2016"]
["Sam","2013-2016"]

{"sheet":"Try(3)","index":20,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015"]
["Barb","2015"]
["Chris","2000-2004"]
["Diane","2001-2006"]
["Ed","2012-2015"]
["Flo","2016-2017"]
["Gary","2005"]
["Hank","2002-2005"]
["Ike","2010"]
["Jared","2014-2018"]
["Kelly","2002-2006"]
["Lou","2001-2006"]
["Mike","2006-2011"]
["Nan","2009"]
["Otto","2002"]
["Paul","2015-2019"]
["Quenten","2010-2011"]
["Raul","2013-2016"]
["Sam","2013-2016"]

{"sheet":"Try(4)","index":21,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015"]
["Barb","2015"]
["Chris","2000-2004"]
["Diane","2001-2006"]
["Ed","2012-2015"]
["Flo","2016-2017"]
["Gary","2005"]
["Hank","2002-2005"]
["Ike","2010"]
["Jared","2014-2018"]
["Kelly","2002-2006"]
["Lou","2001-2006"]
["Mike","2006-2011"]
["Nan","2009"]
["Otto","2002"]
["Paul","2015-2019"]
["Quenten","2010-2011"]
["Raul","2013-2016"]
["Sam","2013-2016"]

{"sheet":"PQ","index":22,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["Name","Years",null,null,"Name","Year"]
["Andy","2013-2015",null,null,"Andy",2013]
["Barb","2015",null,null,"Andy",2014]
["Chris","2000-2004",null,null,"Andy",2015]
["Diane","2001-2006",null,null,"Barb",2015]
["Ed","2012-2015",null,null,"Chris",2000]
["Flo","2016-2017",null,null,"Chris",2001]
["Gary","2005",null,null,"Chris",2002]
["Hank","2002-2005",null,null,"Chris",2003]
["Ike","2010",null,null,"Chris",2004]
["Jared","2014-2018",null,null,"Diane",2001]
["Kelly","2002-2006",null,null,"Diane",2002]
["Lou","2001-2006",null,null,"Diane",2003]
["Mike","2006-2011",null,null,"Diane",2004]
["Nan","2009",null,null,"Diane",2005]
["Otto","2002",null,null,"Diane",2006]
["Paul","2015-2019",null,null,"Ed",2012]
["Quenten","2010-2011",null,null,"Ed",2013]
["Raul","2013-2016",null,null,"Ed",2014]
["Sam","2013-2016",null,null,"Ed",2015]
[null,null,null,null,"Flo",2016]
[null,null,null,null,"Flo",2017]
[null,null,null,null,"Gary",2005]
[null,null,null,null,"Hank",2002]
[null,null,null,null,"Hank",2003]
[null,null,null,null,"Hank",2004]
[null,null,null,null,"Hank",2005]
[null,null,null,null,"Ike",2010]
[null,null,null,null,"Jared",2014]
[null,null,null,null,"Jared",2015]
[null,null,null,null,"Jared",2016]
[null,null,null,null,"Jared",2017]
[null,null,null,null,"Jared",2018]
[null,null,null,null,"Kelly",2002]
[null,null,null,null,"Kelly",2003]
[null,null,null,null,"Kelly",2004]
[null,null,null,null,"Kelly",2005]
[null,null,null,null,"Kelly",2006]
[null,null,null,null,"Lou",2001]
[null,null,null,null,"Lou",2002]
[null,null,null,null,"Lou",2003]
[null,null,null,null,"Lou",2004]
[null,null,null,null,"Lou",2005]
[null,null,null,null,"Lou",2006]
[null,null,null,null,"Mike",2006]
[null,null,null,null,"Mike",2007]
[null,null,null,null,"Mike",2008]
[null,null,null,null,"Mike",2009]
[null,null,null,null,"Mike",2010]
[null,null,null,null,"Mike",2011]
[null,null,null,null,"Nan",2009]
[null,null,null,null,"Otto",2002]
[null,null,null,null,"Paul",2015]
[null,null,null,null,"Paul",2016]
[null,null,null,null,"Paul",2017]
[null,null,null,null,"Paul",2018]
[null,null,null,null,"Paul",2019]
[null,null,null,null,"Quenten",2010]
[null,null,null,null,"Quenten",2011]
[null,null,null,null,"Raul",2013]
[null,null,null,null,"Raul",2014]
[null,null,null,null,"Raul",2015]
[null,null,null,null,"Raul",2016]
[null,null,null,null,"Sam",2013]
[null,null,null,null,"Sam",2014]
[null,null,null,null,"Sam",2015]
[null,null,null,null,"Sam",2016]

{"sheet":"Let","index":23,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Name","Years"]
["Andy","2013-2015",{"$f":"A2&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B2,4)+0,\n_xlpm.EndYear,IF(LEN(B2)=4,_xlpm.StartYear,MID(B2,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Andy 2013"},"Andy 2014","Andy 2015",null,null,null,null,null,null,null,{"$f":"_xlfn._xlws.SORT(_xlfn.UNIQUE(INDEX(C2:H20,INT(_xlfn.SEQUENCE(COUNTA(C2:H20),1,0,1)/6+1),MOD(_xlfn.SEQUENCE(COUNTA(C2:H20),1,0,1),6)+1)))","v":"Andy 2013"}]
["Barb","2015",{"$f":"A3&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B3,4)+0,\n_xlpm.EndYear,IF(LEN(B3)=4,_xlpm.StartYear,MID(B3,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Barb 2015"},null,null,null,null,null,null,null,null,null,"Andy 2014"]
["Chris","2000-2004",{"$f":"A4&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B4,4)+0,\n_xlpm.EndYear,IF(LEN(B4)=4,_xlpm.StartYear,MID(B4,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Chris 2000"},"Chris 2001","Chris 2002","Chris 2003","Chris 2004",null,null,null,null,null,"Andy 2015"]
["Diane","2001-2006",{"$f":"A5&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B5,4)+0,\n_xlpm.EndYear,IF(LEN(B5)=4,_xlpm.StartYear,MID(B5,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Diane 2001"},"Diane 2002","Diane 2003","Diane 2004","Diane 2005","Diane 2006",null,null,null,null,"Barb 2015"]
["Ed","2012-2015",{"$f":"A6&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B6,4)+0,\n_xlpm.EndYear,IF(LEN(B6)=4,_xlpm.StartYear,MID(B6,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Ed 2012"},"Ed 2013","Ed 2014","Ed 2015",null,null,null,null,null,null,"Chris 2000"]
["Flo","2016-2017",{"$f":"A7&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B7,4)+0,\n_xlpm.EndYear,IF(LEN(B7)=4,_xlpm.StartYear,MID(B7,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Flo 2016"},"Flo 2017",null,null,null,null,null,null,null,null,"Chris 2001"]
["Gary","2005",{"$f":"A8&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B8,4)+0,\n_xlpm.EndYear,IF(LEN(B8)=4,_xlpm.StartYear,MID(B8,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Gary 2005"},null,null,null,null,null,null,null,null,null,"Chris 2002"]
["Hank","2002-2005",{"$f":"A9&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B9,4)+0,\n_xlpm.EndYear,IF(LEN(B9)=4,_xlpm.StartYear,MID(B9,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Hank 2002"},"Hank 2003","Hank 2004","Hank 2005",null,null,null,null,null,null,"Chris 2003"]
["Ike","2010",{"$f":"A10&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B10,4)+0,\n_xlpm.EndYear,IF(LEN(B10)=4,_xlpm.StartYear,MID(B10,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Ike 2010"},null,null,null,null,null,null,null,null,null,"Chris 2004"]
["Jared","2014-2018",{"$f":"A11&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B11,4)+0,\n_xlpm.EndYear,IF(LEN(B11)=4,_xlpm.StartYear,MID(B11,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Jared 2014"},"Jared 2015","Jared 2016","Jared 2017","Jared 2018",null,null,null,null,null,"Diane 2001"]
["Kelly","2002-2006",{"$f":"A12&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B12,4)+0,\n_xlpm.EndYear,IF(LEN(B12)=4,_xlpm.StartYear,MID(B12,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Kelly 2002"},"Kelly 2003","Kelly 2004","Kelly 2005","Kelly 2006",null,null,null,null,null,"Diane 2002"]
["Lou","2001-2006",{"$f":"A13&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B13,4)+0,\n_xlpm.EndYear,IF(LEN(B13)=4,_xlpm.StartYear,MID(B13,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Lou 2001"},"Lou 2002","Lou 2003","Lou 2004","Lou 2005","Lou 2006",null,null,null,null,"Diane 2003"]
["Mike","2006-2011",{"$f":"A14&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B14,4)+0,\n_xlpm.EndYear,IF(LEN(B14)=4,_xlpm.StartYear,MID(B14,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Mike 2006"},"Mike 2007","Mike 2008","Mike 2009","Mike 2010","Mike 2011",null,null,null,null,"Diane 2004"]
["Nan","2009",{"$f":"A15&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B15,4)+0,\n_xlpm.EndYear,IF(LEN(B15)=4,_xlpm.StartYear,MID(B15,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Nan 2009"},null,null,null,null,null,null,null,null,null,"Diane 2005"]
["Otto","2002",{"$f":"A16&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B16,4)+0,\n_xlpm.EndYear,IF(LEN(B16)=4,_xlpm.StartYear,MID(B16,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Otto 2002"},null,null,null,null,null,null,null,null,null,"Diane 2006"]
["Paul","2015-2019",{"$f":"A17&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B17,4)+0,\n_xlpm.EndYear,IF(LEN(B17)=4,_xlpm.StartYear,MID(B17,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Paul 2015"},"Paul 2016","Paul 2017","Paul 2018","Paul 2019",null,null,null,null,null,"Ed 2012"]
["Quenten","2010-2011",{"$f":"A18&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B18,4)+0,\n_xlpm.EndYear,IF(LEN(B18)=4,_xlpm.StartYear,MID(B18,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Quenten 2010"},"Quenten 2011",null,null,null,null,null,null,null,null,"Ed 2013"]
["Raul","2013-2016",{"$f":"A19&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B19,4)+0,\n_xlpm.EndYear,IF(LEN(B19)=4,_xlpm.StartYear,MID(B19,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Raul 2013"},"Raul 2014","Raul 2015","Raul 2016",null,null,null,null,null,null,"Ed 2014"]
["Sam","2013-2016",{"$f":"A20&\" \"&_xlfn.LET(_xlpm.StartYear,LEFT(B20,4)+0,\n_xlpm.EndYear,IF(LEN(B20)=4,_xlpm.StartYear,MID(B20,6,4)),\n_xlpm.YearCount,_xlpm.EndYear-_xlpm.StartYear+1,\n_xlfn.SEQUENCE(1,_xlpm.YearCount,_xlpm.StartYear))","v":"Sam 2013"},"Sam 2014","Sam 2015","Sam 2016",null,null,null,null,null,null,"Ed 2015"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Flo 2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Flo 2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gary 2005"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hank 2002"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hank 2003"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hank 2004"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Hank 2005"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ike 2010"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jared 2014"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jared 2015"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jared 2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jared 2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Jared 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kelly 2002"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kelly 2003"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kelly 2004"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kelly 2005"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kelly 2006"]
[null,null,null,null,null,null,null,null,null,null,null,null,0]