Nickname (Species) @ Item | Ability: | Nature & Values | Moves | |
=let(a,unique('1760'!A$2:A),b,index(a,countunique(A$2:A121)+1),d,counta(filter('1760'!AA:AA,'1760'!A:A=b)),e,makearray(d*10,1,lambda(r,c,if((r-1)/10=floor(r/10),b,))),e) | =let(a,match($A2,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A2),0),indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A2,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A2),0)+counta(filter($A$2:$A2,$A$2:$A2=$A2))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A2,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A2),0)+counta(filter($A$2:$A2,$A$2:$A2=$A2))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A2,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A2),0)+counta(filter($A$2:$A2,$A$2:$A2=$A2))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C2 | | | | |
=left(D2,find("e E",D2)) | | | | |
=let(a,len(D2),b,find("EVs:",D2)-1,right(D2,a-b)) | | | | |
IVs: 30 SpA / 30 SpD / 30 Spe | | | | |
=let(a,find("-",E2,2),b,find("-",E2,a+1),c,find("-",E2,b+1),d,{left(E2,a-2);mid(E2,a,b-a-1);mid(E2,b,c-b-1);mid(E2,c,len(E2)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",1,e)))) | | | | |
- Earthquake | | | | |
- Dragon Dance | | | | |
- Ice Beam | | | | |
Dragonite | =let(a,match($A12,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A12),0)+counta(filter(A$2:A11,A$2:A11=$A12)),indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A12,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A12),0)+counta(filter($A$2:$A12,$A$2:$A12=$A12))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A12,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A12),0)+counta(filter($A$2:$A12,$A$2:$A12=$A12))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A12,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A12),0)+counta(filter($A$2:$A12,$A$2:$A12=$A12))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C12 | | | | |
=left(D12,find("e E",D12)) | | | | |
=let(a,len(D12),b,find("EVs:",D12)-1,right(D12,a-b)) | | | | |
=let(a,find("-",E12,2),b,find("-",E12,a+1),c,find("-",E12,b+1),d,{left(E12,a-2);mid(E12,a,b-a-1);mid(E12,b,c-b-1);mid(E12,c,len(E12)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",1,e)))) | | | | |
- Earthquake | | | | |
- Dragon Dance | | | | |
- Ice Beam | | | | |
Dragonite | =let(a,match($A22,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A22),0)+counta(filter(A$2:A22,A$2:A22=$A22))-1,indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A22,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A22),0)+counta(filter($A$2:$A22,$A$2:$A22=$A22))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A22,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A22),0)+counta(filter($A$2:$A22,$A$2:$A22=$A22))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A22,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A22),0)+counta(filter($A$2:$A22,$A$2:$A22=$A22))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C22 | | | | |
=left(D22,find("e E",D22)) | | | | |
=let(a,len(D22),b,find("EVs:",D22)-1,right(D22,a-b)) | | | | |
IVs: 30 SpA / 30 SpD / 30 Spe | | | | |
=let(a,find("-",E22,2),b,find("-",E22,a+1),c,find("-",E22,b+1),d,{left(E22,a-2);mid(E22,a,b-a-1);mid(E22,b,c-b-1);mid(E22,c,len(E22)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",1,e)))) | | | | |
- Earthquake | | | | |
- Dragon Dance | | | | |
- Ice Beam | | | | |
Dragonite | =let(a,match($A32,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A32),0)+counta(filter(A$2:A32,A$2:A32=$A32))-1,indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A32,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A32),0)+counta(filter($A$2:$A32,$A$2:$A32=$A32))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A32,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A32),0)+counta(filter($A$2:$A32,$A$2:$A32=$A32))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A32,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A32),0)+counta(filter($A$2:$A32,$A$2:$A32=$A32))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C32 | | | | |
=left(D32,find("e E",D32)) | | | | |
=let(a,len(D32),b,find("EVs:",D32)-1,right(D32,a-b)) | | | | |
IVs: 30 SpA / 30 SpD / 30 Spe | | | | |
=let(a,find("-",E32,2),b,find("-",E32,a+1),c,find("-",E32,b+1),d,{left(E32,a-2);mid(E32,a,b-a-1);mid(E32,b,c-b-1);mid(E32,c,len(E32)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",1,e)))) | | | | |
- Earthquake | | | | |
- Ice Beam | | | | |
- Roar | | | | |
Dragonite | =let(a,match($A42,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A42),0)+counta(filter(A$2:A42,A$2:A42=$A42))-1,indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A42,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A42),0)+counta(filter($A$2:$A42,$A$2:$A42=$A42))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A42,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A42),0)+counta(filter($A$2:$A42,$A$2:$A42=$A42))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A42,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A42),0)+counta(filter($A$2:$A42,$A$2:$A42=$A42))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C42 | | | | |
=left(D42,find("e E",D42)) | | | | |
=let(a,len(D42),b,find("EVs:",D42)-1,right(D42,a-b)) | | | | |
=let(a,find("-",E42,2),b,find("-",E42,a+1),c,find("-",E42,b+1),d,{left(E42,a-2);mid(E42,a,b-a-1);mid(E42,b,c-b-1);mid(E42,c,len(E42)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",1,e)))) | | | | |
- Earthquake | | | | |
- Ice Beam | | | | |
- Focus Punch | | | | |
Dragonite | =let(a,match($A52,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A52),0)+counta(filter(A$2:A52,A$2:A52=$A52))-1,indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A52,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A52),0)+counta(filter($A$2:$A52,$A$2:$A52=$A52))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A52,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A52),0)+counta(filter($A$2:$A52,$A$2:$A52=$A52))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A52,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A52),0)+counta(filter($A$2:$A52,$A$2:$A52=$A52))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C52 | | | | |
=left(D52,find("e E",D52)) | | | | |
=let(a,len(D52),b,find("EVs:",D52)-1,right(D52,a-b)) | | | | |
IVs: 30 SpA / 30 SpD / 30 Spe | | | | |
=let(a,find("-",E52,2),b,find("-",E52,a+1),c,find("-",E52,b+1),d,{left(E52,a-2);mid(E52,a,b-a-1);mid(E52,b,c-b-1);mid(E52,c,len(E52)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",1,e)))) | | | | |
- Earthquake | | | | |
- Ice Beam | | | | |
- Focus Punch | | | | |
=let(a,unique('1760'!A$2:A),b,index(a,countunique(A$2:A61)+1),d,counta(filter('1760'!W:W,'1760'!A:A=b)),e,makearray(d*10,1,lambda(r,c,if((r-1)/10=floor(r/10),b,))),e) | =let(a,match($A62,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A62),0)+counta(filter($A$2:$A62,$A$2:$A62=$A62))-1,indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A62,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A62),0)+counta(filter($A$2:$A62,$A$2:$A62=$A62))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A62,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A62),0)+counta(filter($A$2:$A62,$A$2:$A62=$A62))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A62,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A62),0)+counta(filter($A$2:$A62,$A$2:$A62=$A62))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C62 | | | | |
=left(D62,find("e E",D62)) | | | | |
=let(a,len(D62),b,find("EVs:",D62)-1,right(D62,a-b)) | | | | |
=let(a,find("-",E62,2),b,find("-",E62,a+1),c,find("-",E62,b+1),d,{left(E62,a-2);mid(E62,a,b-a-1);mid(E62,b,c-b-1);mid(E62,c,len(E62)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",1,e)))) | | | | |
- Surf | | | | |
- Ice Beam | | | | |
- Hidden Power Grass | | | | |
Omastar | =let(a,match($A72,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A72),0)+counta(filter($A$2:$A72,$A$2:$A72=$A72))-1,indirect("1760!R"&a+b&"C"&column('1760'!$X$1),0)) | =let(a,match($A72,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A72),0)+counta(filter($A$2:$A72,$A$2:$A72=$A72))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Y$1),0)) | =let(a,match($A72,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A72),0)+counta(filter($A$2:$A72,$A$2:$A72=$A72))-1,indirect("1760!R"&a+b&"C"&column('1760'!$Z$1),0)) | =let(a,match($A72,'1760'!$A:$A,0),b,match("Spreads",filter('1760'!$S:$S,'1760'!$A:$A=$A72),0)+counta(filter($A$2:$A72,$A$2:$A72=$A72))-1,indirect("1760!R"&a+b&"C"&column('1760'!$AA$1),0)) |
=C72 | | | | |
=left(D72,find("e E",D72)) | | | | |
=let(a,len(D72),b,find("EVs:",D72)-1,right(D72,a-b)) | | | | |
IVs: 0 Atk | | | | |
=let(a,find("-",E72,2),b,find("-",E72,a+1),c,find("-",E72,b+1),d,{left(E72,a-2);mid(E72,a,b-a-1);mid(E72,b,c-b-1);mid(E72,c,len(E72)-c)},map(d,lambda(e,ifs(e="- DoubleEdge","- Double-Edge",e="- WillOWisp","- Will-O-Wisp",e="- SelfDestruct","- Self-Destruct",1,e)))) | | | | |
- Surf | | | | |
- Ice Beam | | | | |
- Toxic | | | | |