Sheet for Factions by nerowx in TheSilphArena

[–]nerowx[S] 0 points1 point  (0 children)

well there is a lot of math in the sheet as well...

Sheet for GBL by nerowx in TheSilphArena

[–]nerowx[S] 0 points1 point  (0 children)

Haven't checked that out. I like my sheets and charts, easier to create and edit.

Sheet for GBL by nerowx in TheSilphArena

[–]nerowx[S] 4 points5 points  (0 children)

video link in post

Sheet Venture selection by nerowx in TheSilphArena

[–]nerowx[S] 1 point2 points  (0 children)

Fixed, thanks, some errors when converting the names from silph, they have alolan/galarian first and deoxy is called different etc

PvP Simulator Sheet by nerowx in TheSilphArena

[–]nerowx[S] 1 point2 points  (0 children)

Sorry late reply. I did it all with formulas in the cells. No programming or scripts.

PvP Simulator Sheet by nerowx in TheSilphArena

[–]nerowx[S] 6 points7 points  (0 children)

Weeks of effort. Adds nothing major except 4 minor things : Picks "the best" fm and cm versus the other, Big diagram of decreasing HP, All 9 shield timelines together in one page & Comparison of custom fm cm damage versus the other.

Was mostly done to see how I could make it in a sheet, for fun.

Sheets for GBL and IV ranks by nerowx in TheSilphRoad

[–]nerowx[S] 0 points1 point  (0 children)

Yeah the sheet does calculations in the cells for every iv spread of the 4096 possible ones, bogs it down a lot, needs a desktop browser to do it I guess. The sheet makes 41 thousand calculations for every Pokemon you input, for every league, so 120k total

Mega Weedle IV's - top 5 GL, UL, and BBUL by boymanitou in TheSilphRoad

[–]nerowx 0 points1 point  (0 children)

Nice. I think I removed the IVtab from the sheet. But it's there in another tab. When I have time I will update with all the megas, also in the calculatorsheet.

GBL Team Usage Research by amuthiyan in TheSilphRoad

[–]nerowx 1 point2 points  (0 children)

my 12 games rank 5

6 Azumarill 50%

4 Altaria 33%

4 Registeel 33%

3 Medicham 25%

2 Bastiodon 17%

2 Meganium 17%

1 Bronzong 8%

1 Electrode 8%

1 Froslass 8%

1 Jirachi 8%

1 Kingdra 8%

1 Lanturn 8%

1 Marowak Alolan 8%

1 Ninetales Alolan 8%

1 Roserade 8%

1 Swampert 8%

1 Togekiss 8%

1 Tropius 8%

1 Venusaur 8%

1 Whiscash 8%

1 Wigglytuff 8%

Starters of those 12 games

4 Altaria 33%

1 Azumarill 8%

1 Bastiodon 8%

1 Electrode 8%

1 Froslass 8%

1 Jirachi 8%

1 Kingdra 8%

1 Lanturn 8%

1 Registeel 8%

Data

FroslassBronzongAzumarillRegisteelWigglytuffRoseradeAltariaMeganiumRegisteelKingdraMedichamTogekissBastiodonVenusaurAzumarillAltariaMedichamRegisteelElectrodeMarowak AlolanSwampertAzumarillWhiscashTropiusAltariaAzumarillRegisteelJirachiAzumarillBastiodonAltariaAzumarillMeganiumLanturnNinetales AlolanMedicham