{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Guest List","DataAnalysis","What to Bring"],"not_rendered":{"images":2,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":13,"n_cols":7,"rows_kept":13}
[]
[null,"Group Event Planner"]
[null,"Enter event details on the left; summary details appear automatically on the right. Add guests and assign them items to bring. Or share this worksheet so they can RSVP and sign up themselves. "]
[null,"EVENT",null,"SUMMARY",null,null,{"$f":"\"Outstanding RSVPS: \"&OutstandingRSVPs","v":"Outstanding RSVPS: 1"}]
[null,"Neighborhood block party",null,"Guests","Spending","Flag","Bringing"]
[null,"DATE",null,{"$f":"IFERROR(IF(LEN(INDEX(GuestList[#All],ROW($A2),1))=0,\"\",INDEX(GuestList[#All],ROW($A2),1)),\"\")","v":"Person 1"},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",SUMIFS(WhatToBring[Total Cost],WhatToBring[Assigned To],EventSummary[[#This Row],[Guests]])),\"\")","v":{"v":25,"d":"$25.00"}},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",IF(EventSummary[[#This Row],[Spending]]>PER_PERSON_BUDGET,1,0)),\"\")","v":1},{"$f":"IFERROR(IF(AND(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\", EventSummary[[#This Row],[Spending]]>0), CONCATENATE(\"Not Attending but signed up to bring \",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE)),IF(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\",\"Not Attending\",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE))),\"\")","v":"Wine, Juice boxes"}]
[null,{"$f":"TODAY()","v":"2019-07-08"},null,{"$f":"IFERROR(IF(LEN(INDEX(GuestList[#All],ROW($A3),1))=0,\"\",INDEX(GuestList[#All],ROW($A3),1)),\"\")","v":"Person 2"},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",SUMIFS(WhatToBring[Total Cost],WhatToBring[Assigned To],EventSummary[[#This Row],[Guests]])),\"\")","v":{"v":47,"d":"$47.00"}},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",IF(EventSummary[[#This Row],[Spending]]>PER_PERSON_BUDGET,1,0)),\"\")","v":1},{"$f":"IFERROR(IF(AND(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\", EventSummary[[#This Row],[Spending]]>0), CONCATENATE(\"Not Attending but signed up to bring \",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE)),IF(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\",\"Not Attending\",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE))),\"\")","v":"Assorted vegetables, Chicken wings, Cake"}]
[null,"TIME",null,{"$f":"IFERROR(IF(LEN(INDEX(GuestList[#All],ROW($A4),1))=0,\"\",INDEX(GuestList[#All],ROW($A4),1)),\"\")","v":"Person 3"},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",SUMIFS(WhatToBring[Total Cost],WhatToBring[Assigned To],EventSummary[[#This Row],[Guests]])),\"\")","v":{"v":10,"d":"$10.00"}},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",IF(EventSummary[[#This Row],[Spending]]>PER_PERSON_BUDGET,1,0)),\"\")","v":0},{"$f":"IFERROR(IF(AND(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\", EventSummary[[#This Row],[Spending]]>0), CONCATENATE(\"Not Attending but signed up to bring \",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE)),IF(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\",\"Not Attending\",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE))),\"\")","v":"Ice cream, Soda"}]
[null,"2 pm to 4 pm",null,{"$f":"IFERROR(IF(LEN(INDEX(GuestList[#All],ROW($A5),1))=0,\"\",INDEX(GuestList[#All],ROW($A5),1)),\"\")","v":"Person 4"},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",SUMIFS(WhatToBring[Total Cost],WhatToBring[Assigned To],EventSummary[[#This Row],[Guests]])),\"\")","v":{"v":0,"d":"$0.00"}},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",IF(EventSummary[[#This Row],[Spending]]>PER_PERSON_BUDGET,1,0)),\"\")","v":0},{"$f":"IFERROR(IF(AND(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\", EventSummary[[#This Row],[Spending]]>0), CONCATENATE(\"Not Attending but signed up to bring \",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE)),IF(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\",\"Not Attending\",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE))),\"\")","v":""}]
[null,"LOCATION",null,{"$f":"IFERROR(IF(LEN(INDEX(GuestList[#All],ROW($A6),1))=0,\"\",INDEX(GuestList[#All],ROW($A6),1)),\"\")","v":"Person 5"},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",SUMIFS(WhatToBring[Total Cost],WhatToBring[Assigned To],EventSummary[[#This Row],[Guests]])),\"\")","v":{"v":51,"d":"$51.00"}},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",IF(EventSummary[[#This Row],[Spending]]>PER_PERSON_BUDGET,1,0)),\"\")","v":1},{"$f":"IFERROR(IF(AND(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\", EventSummary[[#This Row],[Spending]]>0), CONCATENATE(\"Not Attending but signed up to bring \",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE)),IF(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\",\"Not Attending\",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE))),\"\")","v":"Paper towels, Coffee, Cups, Plates, Spoons, Forks, Stuffed mushrooms"}]
[null,"My House",null,{"$f":"IFERROR(IF(LEN(INDEX(GuestList[#All],ROW($A7),1))=0,\"\",INDEX(GuestList[#All],ROW($A7),1)),\"\")","v":"Person 6"},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",SUMIFS(WhatToBring[Total Cost],WhatToBring[Assigned To],EventSummary[[#This Row],[Guests]])),\"\")","v":{"v":22,"d":"$22.00"}},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",IF(EventSummary[[#This Row],[Spending]]>PER_PERSON_BUDGET,1,0)),\"\")","v":1},{"$f":"IFERROR(IF(AND(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\", EventSummary[[#This Row],[Spending]]>0), CONCATENATE(\"Not Attending but signed up to bring \",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE)),IF(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\",\"Not Attending\",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE))),\"\")","v":"Bruschetta"}]
[null,"PER PERSON BUDGET",null,{"$f":"IFERROR(IF(LEN(INDEX(GuestList[#All],ROW($A8),1))=0,\"\",INDEX(GuestList[#All],ROW($A8),1)),\"\")","v":"Person 7"},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",SUMIFS(WhatToBring[Total Cost],WhatToBring[Assigned To],EventSummary[[#This Row],[Guests]])),\"\")","v":{"v":15,"d":"$15.00"}},{"$f":"IFERROR(IF(LEN(EventSummary[Guests])=0,\"\",IF(EventSummary[[#This Row],[Spending]]>PER_PERSON_BUDGET,1,0)),\"\")","v":0},{"$f":"IFERROR(IF(AND(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\", EventSummary[[#This Row],[Spending]]>0), CONCATENATE(\"Not Attending but signed up to bring \",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE)),IF(VLOOKUP(EventSummary[[#This Row],[Guests]],GuestList[],5,FALSE)=\"No\",\"Not Attending\",VLOOKUP(EventSummary[[#This Row],[Guests]],SortedData[[results]:[Text]],3,FALSE))),\"\")","v":"Not Attending but signed up to bring Pudding cups"}]
[null,{"v":20,"d":"$20"}]

{"sheet":"Guest List","index":1,"n_rows":9,"n_cols":7,"rows_kept":9}
[null,"Guest List",{"$nulls":4},"Share this list with others so they can RSVP and sign up to bring items in the What to Bring worksheet. Select Share in the upper right or press ALT then YU. Save the file to OneDrive and send the link to your friends."]
[null,"Name","Phone","Email","Shared?","RSVP"]
[null,"Person 1","Phone 1","Email1","Yes","Yes"]
[null,"Person 2","Phone 2","Email2","Yes","Yes"]
[null,"Person 3","Phone 3","Email3","Yes","Yes"]
[null,"Person 4","Phone 4","Email4"]
[null,"Person 5","Phone 5","Email5",null,"Yes"]
[null,"Person 6","Phone 6","Email6",null,"Yes"]
[null,"Person 7","Phone 7","Email7","Yes","No"]

{"sheet":"DataAnalysis","index":2,"n_rows":50,"n_cols":16,"rows_kept":50,"hidden":true}
[]
[{"$nulls":3},"data analysis",{"$nulls":5},"sorted data"]
[null,"start row",3,"TIE BREAK","RANK","Assigned To","Item","NUM",null,"Rank Sorted","assigned to","item","Hdr","results","# of occurences","Text"]
[null,"last entry",{"$f":"IFERROR(COUNTA(WhatToBring[[#All],[Item]]),start_row)","v":16},{"$f":"IFERROR(RANK(E4,DataAnalysis[RANK])+SUMPRODUCT(--(E4=DataAnalysis[RANK]),--(H4<DataAnalysis[NUM])),\"\")","v":8},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":40},{"$f":"IFERROR(IF(AND(last_entry-start_row=0,ISBLANK(INDEX(WhatToBring[Assigned To],1,1))),\"\",IF(last_entry-start_row=0,INDEX(WhatToBring[Assigned To],1,1),INDEX(WhatToBring[Assigned To],last_entry-start_row-H4+1,1))),\"\")","v":"Person 3"},{"$f":"IFERROR(IF(AND(last_entry-start_row=0,ISBLANK(INDEX(WhatToBring[Item],1,1))),\"\",IF(last_entry-start_row=0,INDEX(WhatToBring[Item],1,1),INDEX(WhatToBring[Item],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,1))),\"\")","v":"Soda"},{"$f":"IFERROR(IF(AND(last_entry-start_row=0,ISBLANK(INDEX(WhatToBring[],1,1))),\"\",IF(last_entry-start_row=0,0,last_entry-start_row)),\"\")","v":13},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":14},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 1"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Wine"},{"$f":"IF(K4=K3,M3,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Wine, "},{"$f":"IF(COUNTIF(K$4:K4,K4)=1,K4,\"\")","v":"Person 1"},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K4)),\"\")","v":2},{"$f":"IFERROR(IF(LEN($N4)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":"Wine, Juice boxes"}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E5,DataAnalysis[RANK])+SUMPRODUCT(--(E5=DataAnalysis[RANK]),--(H5<DataAnalysis[NUM])),\"\")","v":13},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":35},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 1"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Juice boxes"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A1)+1,1)),\"\",IF($H4-1<=-1,\"\",$H4-1)),\"\")","v":12},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":13},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 1"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Juice boxes"},{"$f":"IF(K5=K4,M4,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Wine, Juice boxes, "},{"$f":"IF(COUNTIF(K$4:K5,K5)=1,K5,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K5)),\"\")","v":2},{"$f":"IFERROR(IF(LEN($N5)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E6,DataAnalysis[RANK])+SUMPRODUCT(--(E6=DataAnalysis[RANK]),--(H6<DataAnalysis[NUM])),\"\")","v":14},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":35},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 1"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Wine"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A2)+1,1)),\"\",IF($H5-1<=-1,\"\",$H5-1)),\"\")","v":11},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":12},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 2"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Assorted vegetables"},{"$f":"IF(K6=K5,M5,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Assorted vegetables, "},{"$f":"IF(COUNTIF(K$4:K6,K6)=1,K6,\"\")","v":"Person 2"},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K6)),\"\")","v":3},{"$f":"IFERROR(IF(LEN($N6)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":"Assorted vegetables, Chicken wings, Cake"}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E7,DataAnalysis[RANK])+SUMPRODUCT(--(E7=DataAnalysis[RANK]),--(H7<DataAnalysis[NUM])),\"\")","v":10},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":38},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 2"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Cake"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A3)+1,1)),\"\",IF($H6-1<=-1,\"\",$H6-1)),\"\")","v":10},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":11},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 2"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Chicken wings"},{"$f":"IF(K7=K6,M6,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Assorted vegetables, Chicken wings, "},{"$f":"IF(COUNTIF(K$4:K7,K7)=1,K7,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K7)),\"\")","v":3},{"$f":"IFERROR(IF(LEN($N7)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E8,DataAnalysis[RANK])+SUMPRODUCT(--(E8=DataAnalysis[RANK]),--(H8<DataAnalysis[NUM])),\"\")","v":9},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":40},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 3"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Ice cream"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A4)+1,1)),\"\",IF($H7-1<=-1,\"\",$H7-1)),\"\")","v":9},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":10},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 2"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Cake"},{"$f":"IF(K8=K7,M7,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Assorted vegetables, Chicken wings, Cake, "},{"$f":"IF(COUNTIF(K$4:K8,K8)=1,K8,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K8)),\"\")","v":3},{"$f":"IFERROR(IF(LEN($N8)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E9,DataAnalysis[RANK])+SUMPRODUCT(--(E9=DataAnalysis[RANK]),--(H9<DataAnalysis[NUM])),\"\")","v":1},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":47},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 7"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Pudding cups"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A5)+1,1)),\"\",IF($H8-1<=-1,\"\",$H8-1)),\"\")","v":8},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":9},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 3"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Ice cream"},{"$f":"IF(K9=K8,M8,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Ice cream, "},{"$f":"IF(COUNTIF(K$4:K9,K9)=1,K9,\"\")","v":"Person 3"},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K9)),\"\")","v":2},{"$f":"IFERROR(IF(LEN($N9)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":"Ice cream, Soda"}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E10,DataAnalysis[RANK])+SUMPRODUCT(--(E10=DataAnalysis[RANK]),--(H10<DataAnalysis[NUM])),\"\")","v":3},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":45},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 5"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Stuffed mushrooms"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A6)+1,1)),\"\",IF($H9-1<=-1,\"\",$H9-1)),\"\")","v":7},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":8},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 3"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Soda"},{"$f":"IF(K10=K9,M9,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Ice cream, Soda, "},{"$f":"IF(COUNTIF(K$4:K10,K10)=1,K10,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K10)),\"\")","v":2},{"$f":"IFERROR(IF(LEN($N10)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E11,DataAnalysis[RANK])+SUMPRODUCT(--(E11=DataAnalysis[RANK]),--(H11<DataAnalysis[NUM])),\"\")","v":2},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":46},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 6"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Bruschetta"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A7)+1,1)),\"\",IF($H10-1<=-1,\"\",$H10-1)),\"\")","v":6},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":7},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 5"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Paper towels"},{"$f":"IF(K11=K10,M10,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Paper towels, "},{"$f":"IF(COUNTIF(K$4:K11,K11)=1,K11,\"\")","v":"Person 5"},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K11)),\"\")","v":5},{"$f":"IFERROR(IF(LEN($N11)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":"Paper towels, Coffee, Cups, Plates, Spoons, Forks, Stuffed mushrooms"}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E12,DataAnalysis[RANK])+SUMPRODUCT(--(E12=DataAnalysis[RANK]),--(H12<DataAnalysis[NUM])),\"\")","v":4},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":45},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 5"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Plates, Spoons, Forks"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A8)+1,1)),\"\",IF($H11-1<=-1,\"\",$H11-1)),\"\")","v":5},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":6},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 5"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Coffee"},{"$f":"IF(K12=K11,M11,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Paper towels, Coffee, "},{"$f":"IF(COUNTIF(K$4:K12,K12)=1,K12,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K12)),\"\")","v":5},{"$f":"IFERROR(IF(LEN($N12)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E13,DataAnalysis[RANK])+SUMPRODUCT(--(E13=DataAnalysis[RANK]),--(H13<DataAnalysis[NUM])),\"\")","v":5},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":45},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 5"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Cups"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A9)+1,1)),\"\",IF($H12-1<=-1,\"\",$H12-1)),\"\")","v":4},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":5},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 5"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Cups"},{"$f":"IF(K13=K12,M12,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Paper towels, Coffee, Cups, "},{"$f":"IF(COUNTIF(K$4:K13,K13)=1,K13,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K13)),\"\")","v":5},{"$f":"IFERROR(IF(LEN($N13)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E14,DataAnalysis[RANK])+SUMPRODUCT(--(E14=DataAnalysis[RANK]),--(H14<DataAnalysis[NUM])),\"\")","v":6},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":45},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 5"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Coffee"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A10)+1,1)),\"\",IF($H13-1<=-1,\"\",$H13-1)),\"\")","v":3},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":4},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 5"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Plates, Spoons, Forks"},{"$f":"IF(K14=K13,M13,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Paper towels, Coffee, Cups, Plates, Spoons, Forks, "},{"$f":"IF(COUNTIF(K$4:K14,K14)=1,K14,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K14)),\"\")","v":5},{"$f":"IFERROR(IF(LEN($N14)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E15,DataAnalysis[RANK])+SUMPRODUCT(--(E15=DataAnalysis[RANK]),--(H15<DataAnalysis[NUM])),\"\")","v":7},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":45},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 5"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Paper towels"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A11)+1,1)),\"\",IF($H14-1<=-1,\"\",$H14-1)),\"\")","v":2},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":3},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 5"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Stuffed mushrooms"},{"$f":"IF(K15=K14,M14,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Paper towels, Coffee, Cups, Plates, Spoons, Forks, Stuffed mushrooms, "},{"$f":"IF(COUNTIF(K$4:K15,K15)=1,K15,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K15)),\"\")","v":5},{"$f":"IFERROR(IF(LEN($N15)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E16,DataAnalysis[RANK])+SUMPRODUCT(--(E16=DataAnalysis[RANK]),--(H16<DataAnalysis[NUM])),\"\")","v":11},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":38},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 2"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Chicken wings"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A12)+1,1)),\"\",IF($H15-1<=-1,\"\",$H15-1)),\"\")","v":1},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":2},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 6"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Bruschetta"},{"$f":"IF(K16=K15,M15,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Bruschetta, "},{"$f":"IF(COUNTIF(K$4:K16,K16)=1,K16,\"\")","v":"Person 6"},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K16)),\"\")","v":1},{"$f":"IFERROR(IF(LEN($N16)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":"Bruschetta"}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E17,DataAnalysis[RANK])+SUMPRODUCT(--(E17=DataAnalysis[RANK]),--(H17<DataAnalysis[NUM])),\"\")","v":12},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":38},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":"Person 2"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":"Assorted vegetables"},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A13)+1,1)),\"\",IF($H16-1<=-1,\"\",$H16-1)),\"\")","v":0},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":1},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":"Person 7"},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":"Pudding cups"},{"$f":"IF(K17=K16,M16,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":"Pudding cups, "},{"$f":"IF(COUNTIF(K$4:K17,K17)=1,K17,\"\")","v":"Person 7"},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K17)),\"\")","v":1},{"$f":"IFERROR(IF(LEN($N17)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":"Pudding cups"}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E18,DataAnalysis[RANK])+SUMPRODUCT(--(E18=DataAnalysis[RANK]),--(H18<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A14)+1,1)),\"\",IF($H17-1<=-1,\"\",$H17-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K18=K17,M17,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K18,K18)=1,K18,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K18)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N18)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E19,DataAnalysis[RANK])+SUMPRODUCT(--(E19=DataAnalysis[RANK]),--(H19<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A15)+1,1)),\"\",IF($H18-1<=-1,\"\",$H18-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K19=K18,M18,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K19,K19)=1,K19,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K19)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N19)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E20,DataAnalysis[RANK])+SUMPRODUCT(--(E20=DataAnalysis[RANK]),--(H20<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A16)+1,1)),\"\",IF($H19-1<=-1,\"\",$H19-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K20=K19,M19,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K20,K20)=1,K20,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K20)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N20)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E21,DataAnalysis[RANK])+SUMPRODUCT(--(E21=DataAnalysis[RANK]),--(H21<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A17)+1,1)),\"\",IF($H20-1<=-1,\"\",$H20-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K21=K20,M20,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K21,K21)=1,K21,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K21)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N21)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E22,DataAnalysis[RANK])+SUMPRODUCT(--(E22=DataAnalysis[RANK]),--(H22<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A18)+1,1)),\"\",IF($H21-1<=-1,\"\",$H21-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K22=K21,M21,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K22,K22)=1,K22,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K22)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N22)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E23,DataAnalysis[RANK])+SUMPRODUCT(--(E23=DataAnalysis[RANK]),--(H23<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A19)+1,1)),\"\",IF($H22-1<=-1,\"\",$H22-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K23=K22,M22,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K23,K23)=1,K23,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K23)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N23)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E24,DataAnalysis[RANK])+SUMPRODUCT(--(E24=DataAnalysis[RANK]),--(H24<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A20)+1,1)),\"\",IF($H23-1<=-1,\"\",$H23-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K24=K23,M23,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K24,K24)=1,K24,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K24)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N24)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E25,DataAnalysis[RANK])+SUMPRODUCT(--(E25=DataAnalysis[RANK]),--(H25<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A21)+1,1)),\"\",IF($H24-1<=-1,\"\",$H24-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K25=K24,M24,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K25,K25)=1,K25,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K25)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N25)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E26,DataAnalysis[RANK])+SUMPRODUCT(--(E26=DataAnalysis[RANK]),--(H26<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A22)+1,1)),\"\",IF($H25-1<=-1,\"\",$H25-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K26=K25,M25,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K26,K26)=1,K26,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K26)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N26)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E27,DataAnalysis[RANK])+SUMPRODUCT(--(E27=DataAnalysis[RANK]),--(H27<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A23)+1,1)),\"\",IF($H26-1<=-1,\"\",$H26-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K27=K26,M26,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K27,K27)=1,K27,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K27)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N27)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E28,DataAnalysis[RANK])+SUMPRODUCT(--(E28=DataAnalysis[RANK]),--(H28<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A24)+1,1)),\"\",IF($H27-1<=-1,\"\",$H27-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K28=K27,M27,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K28,K28)=1,K28,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K28)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N28)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E29,DataAnalysis[RANK])+SUMPRODUCT(--(E29=DataAnalysis[RANK]),--(H29<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A25)+1,1)),\"\",IF($H28-1<=-1,\"\",$H28-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K29=K28,M28,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K29,K29)=1,K29,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K29)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N29)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E30,DataAnalysis[RANK])+SUMPRODUCT(--(E30=DataAnalysis[RANK]),--(H30<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A26)+1,1)),\"\",IF($H29-1<=-1,\"\",$H29-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K30=K29,M29,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K30)=1,K30,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K30)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N30)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E31,DataAnalysis[RANK])+SUMPRODUCT(--(E31=DataAnalysis[RANK]),--(H31<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A27)+1,1)),\"\",IF($H30-1<=-1,\"\",$H30-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K31=K30,M30,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K31)=1,K31,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K31)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N31)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E32,DataAnalysis[RANK])+SUMPRODUCT(--(E32=DataAnalysis[RANK]),--(H32<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A28)+1,1)),\"\",IF($H31-1<=-1,\"\",$H31-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K32=K31,M31,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K32)=1,K32,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K32)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N32)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E33,DataAnalysis[RANK])+SUMPRODUCT(--(E33=DataAnalysis[RANK]),--(H33<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A29)+1,1)),\"\",IF($H32-1<=-1,\"\",$H32-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K33=K32,M32,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K33)=1,K33,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K33)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N33)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E34,DataAnalysis[RANK])+SUMPRODUCT(--(E34=DataAnalysis[RANK]),--(H34<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A30)+1,1)),\"\",IF($H33-1<=-1,\"\",$H33-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K34=K33,M33,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K34)=1,K34,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K34)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N34)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E35,DataAnalysis[RANK])+SUMPRODUCT(--(E35=DataAnalysis[RANK]),--(H35<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A31)+1,1)),\"\",IF($H34-1<=-1,\"\",$H34-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K35=K34,M34,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K35)=1,K35,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K35)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N35)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E36,DataAnalysis[RANK])+SUMPRODUCT(--(E36=DataAnalysis[RANK]),--(H36<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A32)+1,1)),\"\",IF($H35-1<=-1,\"\",$H35-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K36=K35,M35,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K36)=1,K36,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K36)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N36)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E37,DataAnalysis[RANK])+SUMPRODUCT(--(E37=DataAnalysis[RANK]),--(H37<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A33)+1,1)),\"\",IF($H36-1<=-1,\"\",$H36-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K37=K36,M36,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K37)=1,K37,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K37)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N37)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E38,DataAnalysis[RANK])+SUMPRODUCT(--(E38=DataAnalysis[RANK]),--(H38<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A34)+1,1)),\"\",IF($H37-1<=-1,\"\",$H37-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K38=K37,M37,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K38)=1,K38,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K38)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N38)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E39,DataAnalysis[RANK])+SUMPRODUCT(--(E39=DataAnalysis[RANK]),--(H39<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A35)+1,1)),\"\",IF($H38-1<=-1,\"\",$H38-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K39=K38,M38,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K39)=1,K39,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K39)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N39)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E40,DataAnalysis[RANK])+SUMPRODUCT(--(E40=DataAnalysis[RANK]),--(H40<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A36)+1,1)),\"\",IF($H39-1<=-1,\"\",$H39-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K40=K39,M39,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K40)=1,K40,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K40)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N40)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E41,DataAnalysis[RANK])+SUMPRODUCT(--(E41=DataAnalysis[RANK]),--(H41<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A37)+1,1)),\"\",IF($H40-1<=-1,\"\",$H40-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K41=K40,M40,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K41)=1,K41,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K41)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N41)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E42,DataAnalysis[RANK])+SUMPRODUCT(--(E42=DataAnalysis[RANK]),--(H42<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A38)+1,1)),\"\",IF($H41-1<=-1,\"\",$H41-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K42=K41,M41,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K42)=1,K42,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K42)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N42)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E43,DataAnalysis[RANK])+SUMPRODUCT(--(E43=DataAnalysis[RANK]),--(H43<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A39)+1,1)),\"\",IF($H42-1<=-1,\"\",$H42-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K43=K42,M42,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K43)=1,K43,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K43)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N43)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E44,DataAnalysis[RANK])+SUMPRODUCT(--(E44=DataAnalysis[RANK]),--(H44<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A40)+1,1)),\"\",IF($H43-1<=-1,\"\",$H43-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K44=K43,M43,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K44)=1,K44,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K44)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N44)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E45,DataAnalysis[RANK])+SUMPRODUCT(--(E45=DataAnalysis[RANK]),--(H45<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A41)+1,1)),\"\",IF($H44-1<=-1,\"\",$H44-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K45=K44,M44,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K45)=1,K45,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K45)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N45)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E46,DataAnalysis[RANK])+SUMPRODUCT(--(E46=DataAnalysis[RANK]),--(H46<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A42)+1,1)),\"\",IF($H45-1<=-1,\"\",$H45-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K46=K45,M45,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K46)=1,K46,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K46)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N46)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E47,DataAnalysis[RANK])+SUMPRODUCT(--(E47=DataAnalysis[RANK]),--(H47<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A43)+1,1)),\"\",IF($H46-1<=-1,\"\",$H46-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K47=K46,M46,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K47)=1,K47,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K47)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N47)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E48,DataAnalysis[RANK])+SUMPRODUCT(--(E48=DataAnalysis[RANK]),--(H48<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A44)+1,1)),\"\",IF($H47-1<=-1,\"\",$H47-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K48=K47,M47,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K48)=1,K48,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K48)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N48)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E49,DataAnalysis[RANK])+SUMPRODUCT(--(E49=DataAnalysis[RANK]),--(H49<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A45)+1,1)),\"\",IF($H48-1<=-1,\"\",$H48-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K49=K48,M48,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K49)=1,K49,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K49)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N49)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]
[{"$nulls":3},{"$f":"IFERROR(RANK(E50,DataAnalysis[RANK])+SUMPRODUCT(--(E50=DataAnalysis[RANK]),--(H50<DataAnalysis[NUM])),\"\")","v":""},{"$f":"IFERROR(IF(COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])=0,\"\",COUNTIF(DataAnalysis[Assigned To],\"<=\"&DataAnalysis[Assigned To])),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\",INDEX(WhatToBring[],last_entry-start_row-DataAnalysis[[#This Row],[NUM]]+1,3)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\",INDEX(WhatToBring[#All],last_entry-start_row-DataAnalysis[NUM]+2,1)),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(INDEX(WhatToBring[#All],ROW(A46)+1,1)),\"\",IF($H49-1<=-1,\"\",$H49-1)),\"\")","v":""},null,{"$f":"IFERROR(DataAnalysis[[#This Row],[NUM]]+1,\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],3,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(SortedData[Rank Sorted],DataAnalysis[],4,0),\"\")","v":""},{"$f":"IF(K50=K49,M49,\"\")&REPT(SortedData[[#This Row],[item]]&\", \",SortedData[[#This Row],[item]]<>\"\")","v":""},{"$f":"IF(COUNTIF(K$4:K50,K50)=1,K50,\"\")","v":""},{"$f":"IFERROR(IF(LEN(SortedData[assigned to])=0,\"\",COUNTIF(SortedData[assigned to],K50)),\"\")","v":""},{"$f":"IFERROR(IF(LEN($N50)>0,LEFT(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1),LEN(INDIRECT(\"DataAnalysis!M\"&ROW(SortedData[[#This Row],[results]])+SortedData[[#This Row],['# of occurences]]-1))-2),\"\"),\"\")","v":""}]

{"sheet":"What to Bring","index":3,"n_rows":17,"n_cols":7,"rows_kept":17}
[null,"What to Bring"]
[null,"Item","Total Cost","Assigned To","Notes","Rank","Missing"]
[null,"Soda",{"v":0,"d":"$0.00"},"Person 3","2 liter bottles",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":7},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Juice boxes",{"v":5,"d":"$5.00"},"Person 1","Apple and white grape",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":2},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Wine",{"v":20,"d":"$20.00"},"Person 1",null,{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":2},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Cake",{"v":20,"d":"$20.00"},"Person 2","Order from local bakery",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":5},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Ice cream",{"v":10,"d":"$10.00"},"Person 3",null,{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":7},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Pudding cups",{"v":15,"d":"$15.00"},"Person 7","Purchase packaged cups: vanilla and chocolate",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":14},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":1}]
[null,"Stuffed mushrooms",{"v":32,"d":"$32.00"},"Person 5","Button mushrooms stuffed with cream cheese and sausage",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":12},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Bruschetta",{"v":22,"d":"$22.00"},"Person 6","Tomato and basil ",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":13},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Plates, Spoons, Forks",{"v":0,"d":"$0.00"},"Person 5",null,{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":12},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Cups",{"v":0,"d":"$0.00"},"Person 5","assorted",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":12},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Coffee",{"v":15,"d":"$15.00"},"Person 5",null,{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":12},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Paper towels",{"v":4,"d":"$4.00"},"Person 5",null,{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":12},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Chicken wings",{"v":12,"d":"$12.00"},"Person 2","Purchase from local wing shop",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":5},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Assorted vegetables",{"v":15,"d":"$15.00"},"Person 2","Carrot sticks, celery, broccoli, cauliflower, red and green peppers",{"$f":"COUNTIF(WhatToBring[Assigned To],\"<=\"&WhatToBring[Assigned To])","v":5},{"$f":"IFERROR(IF(LEN(WhatToBring[Assigned To])>0,IF(VLOOKUP(WhatToBring[[#This Row],[Assigned To]],GuestList[],5,FALSE)=\"No\",1,\"\"),\"\"),\"\")","v":""}]
[null,"Total",{"$f":"SUBTOTAL(109,WhatToBring[Total Cost])","v":{"v":170,"d":"$170.00"}}]