sandy666
07-10-2023, 10:32 PM
PoolTeam NameTeam CodePoolSeedTeam NameTeam Code
R1ASCVC 14Quiksilver (SC)b14scvbc1scR1A
43SCVC 14Quiksilver (SC)b14scvbc1sc
R1ASASVBC B 14-1 (AH)b14spser1ahR1A
2SASVBC B 14-1 (AH)b14spser1ah
R1ACinci Attack 14 Black (OV)b14cattk1ovR1A
22Cinci Attack 14 Black (OV)b14cattk1ov
R1ALEGACY-TAMPA 14 (FL)b14lgacy1flR1A
4LEGACY-TAMPA 14 (FL)b14lgacy1fl
R1BC2 Attack 14-1 SMACK (SO)b14cavbc1soR1B
42C2 Attack 14-1 SMACK (SO)b14cavbc1so
R1BSBVC Boys 14-1 (SC)b14sbarb1scR1B
40SBVC Boys 14-1 (SC)b14sbarb1sc
R1BMVP 14 Black (CH)b14mvpjo1chR1B
7MVP 14 Black (CH)b14mvpjo1ch
R1BUC ELITE 14U Oliver (NC)b14ucelt1ncR1B
38UC ELITE 14U Oliver (NC)b14ucelt1nc
R1CBalboa Bay 14Blue (SC)b14balby1scR1C
9Balboa Bay 14Blue (SC)b14balby1sc
R1CMUV 14 National Sebi (FL)b14muted1flR1C
37MUV 14 National Sebi (FL)b14muted1fl
R1CThe St. James Boys 14 N (CH)b14stjam1chR1C
11The St. James Boys 14 N (CH)b14stjam1ch
R1CPipeline 14-1 (GL)b14pipev11glR1C
12Pipeline 14-1 (GL)b14pipev11gl
R1DBORINQUEN COQUI 14-1M (PU)b14coqui1puR1D
13BORINQUEN COQUI 14-1M (PU)b14coqui1pu
R1DMVVC B 14 Red (NC)b14mouvi1ncR1D
35MVVC B 14 Red (NC)b14mouvi1nc
R1DRoch PaceBootleggr14 Blk (WE)b14paceb1weR1D
15Roch PaceBootleggr14 Blk (WE)b14paceb1we
R1DWAVE 14-Nicole (SC)b14wvevb1scR1D
34WAVE 14-Nicole (SC)b14wvevb1sc
R1EPinnacle 14-JP (SC)b14pnncl1scR1E
17Pinnacle 14-JP (SC)b14pnncl1sc
R1EMKE Sting 14-1 Adam (BG)b14mlwst1bgR1E
18MKE Sting 14-1 Adam (BG)b14mlwst1bg
R1EFuture 14-Elite (GL)b14futre1glR1E
19Future 14-Elite (GL)b14futre1gl
R1EKali 14-1 M (PU)b14397891puR1E
20Kali 14-1 M (PU)b14397891pu
R1FHPSTL B14 Royal (GW)b14hpstl1gwR1F
21HPSTL B14 Royal (GW)b14hpstl1gw
R1FTORRI 14-1 (PU)b14torri1puR1F
1TORRI 14-1 (PU)b14torri1pu
R1FOCVC14-1 (SC)b14ocvbc1scR1F
23OCVC14-1 (SC)b14ocvbc1sc
R1FElevation 14 Peak Boys (RM)b14elevb1rmR1F
33Elevation 14 Peak Boys (RM)b14elevb1rm
R1GMDJRS 14 Boys Open (CH)b14mdjrs1chR1G
25MDJRS 14 Boys Open (CH)b14mdjrs1ch
R1GCOAST Boys 14-Bela (SC)b14coast1scR1G
32COAST Boys 14-Bela (SC)b14coast1sc
R1GWarren Sixpack 14-1 (GE)b14waren1geR1G
31Warren Sixpack 14-1 (GE)b14waren1ge
R1G630 Volleyball 14-1 (GL)b14630vb1glR1G
28630 Volleyball 14-1 (GL)b14630vb1gl
R1HAspire 14 Groot (AZ)b14aspir1azR1H
29Aspire 14 Groot (AZ)b14aspir1az
R1HUltimate B14 Gold (GL)b14ultim1glR1H
30Ultimate B14 Gold (GL)b14ultim1gl
R1HJJVA Boys 14 Teal (FL)b14jaxjr1flR1H
3JJVA Boys 14 Teal (FL)b14jaxjr1fl
R1HSPORTIME 14-1 (GE)b14sptmc1geR1H
26SPORTIME 14-1 (GE)b14sptmc1ge
R1IBay to Bay 14-1 (NC)b14bytby1ncR1I
27Bay to Bay 14-1 (NC)b14bytby1nc
R1IAcademy 14 Adidas (HO)b14tavbc1hoR1I
41Academy 14 Adidas (HO)b14tavbc1ho
R1IHVA 14 YOUNG GUNS RED (LS)b14hvavb1lsR1I
14HVA 14 YOUNG GUNS RED (LS)b14hvavb1ls
R1IAdversity 14 Adidas (GL)b14adver1glR1I
36Adversity 14 Adidas (GL)b14adver1gl
R1JMB Surf ASICS 14's 1 (SC)b14mbssv1scR1J
8MB Surf ASICS 14's 1 (SC)b14mbssv1sc
R1JMOD B14 Blue (GL)b14modvb1glR1J
24MOD B14 Blue (GL)b14modvb1gl
R1JOrlando Gold 14 Black (FL)b14ogold1flR1J
39Orlando Gold 14 Black (FL)b14ogold1fl
R1JEXCEL 14N Red (NT)b14excel1ntR1J
5EXCEL 14N Red (NT)b14excel1nt
R1KVAQUEROS 14-1 (PU)b14vaque1puR1K
16VAQUEROS 14-1 (PU)b14vaque1pu
R1KTeam Rockstar 14 Rockstar (SC)b14rstar1scR1K
6Team Rockstar 14 Rockstar (SC)b14rstar1sc
R1KWPVC Boys 14 Armour Black (FL)b14wpvcb1flR1K
10WPVC Boys 14 Armour Black (FL)b14wpvcb1fl
// 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
// GenerateRandomOrder
let
GenerateRandomOrder = (count) =>
let
randomList = List.Numbers(1, count),
shuffledList = List.Buffer(List.Sort(randomList, each Number.Random()))
in
shuffledList
in
GenerateRandomOrder
R1ASCVC 14Quiksilver (SC)b14scvbc1scR1A
43SCVC 14Quiksilver (SC)b14scvbc1sc
R1ASASVBC B 14-1 (AH)b14spser1ahR1A
2SASVBC B 14-1 (AH)b14spser1ah
R1ACinci Attack 14 Black (OV)b14cattk1ovR1A
22Cinci Attack 14 Black (OV)b14cattk1ov
R1ALEGACY-TAMPA 14 (FL)b14lgacy1flR1A
4LEGACY-TAMPA 14 (FL)b14lgacy1fl
R1BC2 Attack 14-1 SMACK (SO)b14cavbc1soR1B
42C2 Attack 14-1 SMACK (SO)b14cavbc1so
R1BSBVC Boys 14-1 (SC)b14sbarb1scR1B
40SBVC Boys 14-1 (SC)b14sbarb1sc
R1BMVP 14 Black (CH)b14mvpjo1chR1B
7MVP 14 Black (CH)b14mvpjo1ch
R1BUC ELITE 14U Oliver (NC)b14ucelt1ncR1B
38UC ELITE 14U Oliver (NC)b14ucelt1nc
R1CBalboa Bay 14Blue (SC)b14balby1scR1C
9Balboa Bay 14Blue (SC)b14balby1sc
R1CMUV 14 National Sebi (FL)b14muted1flR1C
37MUV 14 National Sebi (FL)b14muted1fl
R1CThe St. James Boys 14 N (CH)b14stjam1chR1C
11The St. James Boys 14 N (CH)b14stjam1ch
R1CPipeline 14-1 (GL)b14pipev11glR1C
12Pipeline 14-1 (GL)b14pipev11gl
R1DBORINQUEN COQUI 14-1M (PU)b14coqui1puR1D
13BORINQUEN COQUI 14-1M (PU)b14coqui1pu
R1DMVVC B 14 Red (NC)b14mouvi1ncR1D
35MVVC B 14 Red (NC)b14mouvi1nc
R1DRoch PaceBootleggr14 Blk (WE)b14paceb1weR1D
15Roch PaceBootleggr14 Blk (WE)b14paceb1we
R1DWAVE 14-Nicole (SC)b14wvevb1scR1D
34WAVE 14-Nicole (SC)b14wvevb1sc
R1EPinnacle 14-JP (SC)b14pnncl1scR1E
17Pinnacle 14-JP (SC)b14pnncl1sc
R1EMKE Sting 14-1 Adam (BG)b14mlwst1bgR1E
18MKE Sting 14-1 Adam (BG)b14mlwst1bg
R1EFuture 14-Elite (GL)b14futre1glR1E
19Future 14-Elite (GL)b14futre1gl
R1EKali 14-1 M (PU)b14397891puR1E
20Kali 14-1 M (PU)b14397891pu
R1FHPSTL B14 Royal (GW)b14hpstl1gwR1F
21HPSTL B14 Royal (GW)b14hpstl1gw
R1FTORRI 14-1 (PU)b14torri1puR1F
1TORRI 14-1 (PU)b14torri1pu
R1FOCVC14-1 (SC)b14ocvbc1scR1F
23OCVC14-1 (SC)b14ocvbc1sc
R1FElevation 14 Peak Boys (RM)b14elevb1rmR1F
33Elevation 14 Peak Boys (RM)b14elevb1rm
R1GMDJRS 14 Boys Open (CH)b14mdjrs1chR1G
25MDJRS 14 Boys Open (CH)b14mdjrs1ch
R1GCOAST Boys 14-Bela (SC)b14coast1scR1G
32COAST Boys 14-Bela (SC)b14coast1sc
R1GWarren Sixpack 14-1 (GE)b14waren1geR1G
31Warren Sixpack 14-1 (GE)b14waren1ge
R1G630 Volleyball 14-1 (GL)b14630vb1glR1G
28630 Volleyball 14-1 (GL)b14630vb1gl
R1HAspire 14 Groot (AZ)b14aspir1azR1H
29Aspire 14 Groot (AZ)b14aspir1az
R1HUltimate B14 Gold (GL)b14ultim1glR1H
30Ultimate B14 Gold (GL)b14ultim1gl
R1HJJVA Boys 14 Teal (FL)b14jaxjr1flR1H
3JJVA Boys 14 Teal (FL)b14jaxjr1fl
R1HSPORTIME 14-1 (GE)b14sptmc1geR1H
26SPORTIME 14-1 (GE)b14sptmc1ge
R1IBay to Bay 14-1 (NC)b14bytby1ncR1I
27Bay to Bay 14-1 (NC)b14bytby1nc
R1IAcademy 14 Adidas (HO)b14tavbc1hoR1I
41Academy 14 Adidas (HO)b14tavbc1ho
R1IHVA 14 YOUNG GUNS RED (LS)b14hvavb1lsR1I
14HVA 14 YOUNG GUNS RED (LS)b14hvavb1ls
R1IAdversity 14 Adidas (GL)b14adver1glR1I
36Adversity 14 Adidas (GL)b14adver1gl
R1JMB Surf ASICS 14's 1 (SC)b14mbssv1scR1J
8MB Surf ASICS 14's 1 (SC)b14mbssv1sc
R1JMOD B14 Blue (GL)b14modvb1glR1J
24MOD B14 Blue (GL)b14modvb1gl
R1JOrlando Gold 14 Black (FL)b14ogold1flR1J
39Orlando Gold 14 Black (FL)b14ogold1fl
R1JEXCEL 14N Red (NT)b14excel1ntR1J
5EXCEL 14N Red (NT)b14excel1nt
R1KVAQUEROS 14-1 (PU)b14vaque1puR1K
16VAQUEROS 14-1 (PU)b14vaque1pu
R1KTeam Rockstar 14 Rockstar (SC)b14rstar1scR1K
6Team Rockstar 14 Rockstar (SC)b14rstar1sc
R1KWPVC Boys 14 Armour Black (FL)b14wpvcb1flR1K
10WPVC Boys 14 Armour Black (FL)b14wpvcb1fl
// 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
// GenerateRandomOrder
let
GenerateRandomOrder = (count) =>
let
randomList = List.Numbers(1, count),
shuffledList = List.Buffer(List.Sort(randomList, each Number.Random()))
in
shuffledList
in
GenerateRandomOrder