PQ - serpentine volleyball seeding

Pool	Team Name	Team Code		Pool	Seed	Team Name	Team Code
R1A	SCVC 14Quiksilver (SC)	b14scvbc1sc		R1A	43	SCVC 14Quiksilver (SC)	b14scvbc1sc
R1A	SASVBC B 14-1 (AH)	b14spser1ah		R1A	2	SASVBC B 14-1 (AH)	b14spser1ah
R1A	Cinci Attack 14 Black (OV)	b14cattk1ov		R1A	22	Cinci Attack 14 Black (OV)	b14cattk1ov
R1A	LEGACY-TAMPA 14 (FL)	b14lgacy1fl		R1A	4	LEGACY-TAMPA 14 (FL)	b14lgacy1fl
R1B	C2 Attack 14-1 SMACK (SO)	b14cavbc1so		R1B	42	C2 Attack 14-1 SMACK (SO)	b14cavbc1so
R1B	SBVC Boys 14-1 (SC)	b14sbarb1sc		R1B	40	SBVC Boys 14-1 (SC)	b14sbarb1sc
R1B	MVP 14 Black (CH)	b14mvpjo1ch		R1B	7	MVP 14 Black (CH)	b14mvpjo1ch
R1B	UC ELITE 14U Oliver (NC)	b14ucelt1nc		R1B	38	UC ELITE 14U Oliver (NC)	b14ucelt1nc
R1C	Balboa Bay 14Blue (SC)	b14balby1sc		R1C	9	Balboa Bay 14Blue (SC)	b14balby1sc
R1C	MUV 14 National Sebi (FL)	b14muted1fl		R1C	37	MUV 14 National Sebi (FL)	b14muted1fl
R1C	The St. James Boys 14 N (CH)	b14stjam1ch		R1C	11	The St. James Boys 14 N (CH)	b14stjam1ch
R1C	Pipeline 14-1 (GL)	b14pipev11gl		R1C	12	Pipeline 14-1 (GL)	b14pipev11gl
R1D	BORINQUEN COQUI 14-1M (PU)	b14coqui1pu		R1D	13	BORINQUEN COQUI 14-1M (PU)	b14coqui1pu
R1D	MVVC B 14 Red (NC)	b14mouvi1nc		R1D	35	MVVC B 14 Red (NC)	b14mouvi1nc
R1D	Roch PaceBootleggr14 Blk (WE)	b14paceb1we		R1D	15	Roch PaceBootleggr14 Blk (WE)	b14paceb1we
R1D	WAVE 14-Nicole (SC)	b14wvevb1sc		R1D	34	WAVE 14-Nicole (SC)	b14wvevb1sc
R1E	Pinnacle 14-JP (SC)	b14pnncl1sc		R1E	17	Pinnacle 14-JP (SC)	b14pnncl1sc
R1E	MKE Sting 14-1 Adam (BG)	b14mlwst1bg		R1E	18	MKE Sting 14-1 Adam (BG)	b14mlwst1bg
R1E	Future 14-Elite (GL)	b14futre1gl		R1E	19	Future 14-Elite (GL)	b14futre1gl
R1E	Kali 14-1 M (PU)	b14397891pu		R1E	20	Kali 14-1 M (PU)	b14397891pu
R1F	HPSTL B14 Royal (GW)	b14hpstl1gw		R1F	21	HPSTL B14 Royal (GW)	b14hpstl1gw
R1F	TORRI 14-1 (PU)	b14torri1pu		R1F	1	TORRI 14-1 (PU)	b14torri1pu
R1F	OCVC14-1 (SC)	b14ocvbc1sc		R1F	23	OCVC14-1 (SC)	b14ocvbc1sc
R1F	Elevation 14 Peak Boys (RM)	b14elevb1rm		R1F	33	Elevation 14 Peak Boys (RM)	b14elevb1rm
R1G	MDJRS 14 Boys Open (CH)	b14mdjrs1ch		R1G	25	MDJRS 14 Boys Open (CH)	b14mdjrs1ch
R1G	COAST Boys 14-Bela (SC)	b14coast1sc		R1G	32	COAST Boys 14-Bela (SC)	b14coast1sc
R1G	Warren Sixpack 14-1 (GE)	b14waren1ge		R1G	31	Warren Sixpack 14-1 (GE)	b14waren1ge
R1G	630 Volleyball 14-1 (GL)	b14630vb1gl		R1G	28	630 Volleyball 14-1 (GL)	b14630vb1gl
R1H	Aspire 14 Groot (AZ)	b14aspir1az		R1H	29	Aspire 14 Groot (AZ)	b14aspir1az
R1H	Ultimate B14 Gold (GL)	b14ultim1gl		R1H	30	Ultimate B14 Gold (GL)	b14ultim1gl
R1H	JJVA Boys 14 Teal (FL)	b14jaxjr1fl		R1H	3	JJVA Boys 14 Teal (FL)	b14jaxjr1fl
R1H	SPORTIME 14-1 (GE)	b14sptmc1ge		R1H	26	SPORTIME 14-1 (GE)	b14sptmc1ge
R1I	Bay to Bay 14-1 (NC)	b14bytby1nc		R1I	27	Bay to Bay 14-1 (NC)	b14bytby1nc
R1I	Academy 14 Adidas (HO)	b14tavbc1ho		R1I	41	Academy 14 Adidas (HO)	b14tavbc1ho
R1I	HVA 14 YOUNG GUNS RED (LS)	b14hvavb1ls		R1I	14	HVA 14 YOUNG GUNS RED (LS)	b14hvavb1ls
R1I	Adversity 14 Adidas (GL)	b14adver1gl		R1I	36	Adversity 14 Adidas (GL)	b14adver1gl
R1J	MB Surf ASICS 14's 1 (SC)	b14mbssv1sc		R1J	8	MB Surf ASICS 14's 1 (SC)	b14mbssv1sc
R1J	MOD B14 Blue (GL)	b14modvb1gl		R1J	24	MOD B14 Blue (GL)	b14modvb1gl
R1J	Orlando Gold 14 Black (FL)	b14ogold1fl		R1J	39	Orlando Gold 14 Black (FL)	b14ogold1fl
R1J	EXCEL 14N Red (NT)	b14excel1nt		R1J	5	EXCEL 14N Red (NT)	b14excel1nt
R1K	VAQUEROS 14-1 (PU)	b14vaque1pu		R1K	16	VAQUEROS 14-1 (PU)	b14vaque1pu
R1K	Team Rockstar 14 Rockstar (SC)	b14rstar1sc		R1K	6	Team Rockstar 14 Rockstar (SC)	b14rstar1sc
R1K	WPVC Boys 14 Armour Black (FL)	b14wpvcb1fl		R1K	10	WPVC Boys 14 Armour Black (FL)	b14wpvcb1fl

Code:

---

// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    EmptyTable = Table.IsEmpty(Source),
    Idx = if not EmptyTable then Table.AddIndexColumn(Source, "Index", 1, 1, Int64.Type) else Source,
    RowCount = Table.RowCount(Idx),
    RandomOrder = if not EmptyTable then GenerateRandomOrder(RowCount) else {},
    RandomIndex = Table.AddColumn(Idx, "Seed", each if not EmptyTable then RandomOrder{[Index] - 1} else null, Int64.Type),
    TSC = Table.SelectColumns(RandomIndex,{"Pool", "Seed", "Team Name", "Team Code"})
in
    TSC

---

Code:

---

// GenerateRandomOrder
let
    GenerateRandomOrder = (count) =>
        let
            randomList = List.Numbers(1, count),
            shuffledList = List.Buffer(List.Sort(randomList, each Number.Random()))
        in
            shuffledList
in
    GenerateRandomOrder

---