Thread: RNG Research
View Single Post
Old Nov 25th, 2010, 12:28:15 AM   #549
Kaphotics
Remodeling Kitchens
is a Pokémon Researcheris a Contributor to Smogon
 
Kaphotics's Avatar
 
Join Date: Apr 2009
Posts: 759
Berkeley, CA
Default

Made an Excel spread searcher/filter like Reporter would do for now until Reporter beta comes.

IV SpreadFinder Lite (1.2MB) - 10,000 Frames

Export your results from Researcher to CSV, open that CSV and paste the IV column (custom1) into the spreadsheet IV column.

Spreads:
IVs can be filtered. Click on the column title drop down button and just do a Number Filter with the specified range.

Tools:
Clicking the column title drop down button will allow you to see the range of the spread's IV sums, and you can see what frames a given tri/hex/pent flawless spread will occur on. Hope you are lucky!

To do it for more than 10,000 frames, copy and paste the entire row (frame is a formula that will update) for how many frame rows you want. Then re-paste the IVs from the Researcher output.

Mainly just made this to help me find a pentaflawless spread (maybe hex?) for now and it's something to kill time until Reporter 8.4b.

Screenshot of Lite Version
Kaphotics is offline   Reply With Quote