Nessly Posted March 30, 2014 Share Posted March 30, 2014 (edited) I put together a little spreadsheet for myself to help sort through items to hunt. I thought it was too useful not to share, so here it is for anyone who would like to use it. It's a spreadsheet of all the drops pulled directly from the drop chart on ( http://www.phantasystaronline.net/droptable.php ) It allows filtering by columns (EX: episode, difficulty, ID, monster, drop, rate, %) to search through the entire chart much more easily. An example of how to use the chart is shown below. ONLINE DROP CHART SPREADSHEET [up to date as of 2015-07-13] (be sure to select the Summer event sheet) NOTE: The link to the online version doesn't change, so you can continue using the same link for all updates.Recent Changes 2015-07-13 Added a sheet for the Summer Event to the drop chart spreadsheet! The Valentines Day Event sheet and normal non-event drop sheet are still there too if you want to refer to them as well. Just make sure to select the SUMMER sheet when you open the spreadsheet to see the SUMMER drops. Drops from http://www.phantasystaronline.net/droptable.php were used as a base in creating the Summer sheet. I'll make changes as everyone confirms Summer drops! If you want to contribute your findings, please do so at the event thread. Confirmed drops so far include: VH Viridia Hildebear ZANBEACON ULT Viridia Garanz TRAP SEARCH ULT Oran Bartle ZANBEACON ULT Skyly Epsilon CENTURION/BATTLE ULT Bluefull Morfos PSYCHO BLACK CRYSTAL ULT Yellowboze Morfos PSYCHO BLACK CRYSTAL ULT Purplenum Saint Million BLOOD SWORD 2015-03-13 Small update to %s. Some event items were made easier. GLIDE DIVINE V.00 0.4892 % -----> 0.9642 % RICO'S PARASOL 0.6363 % ----> 0.9642 % SLICER OF VENGEANCE 1.3771 % ----> 2.1517 % View changes DOWNLOAD OFFLINE VERSION 2015-03-06 Small update to Valentine's Event 2015 drop chart Rates for Glide Divine V.00 & Slicer of Vengeance were made harder Rico's Parasol drop added (Gol Dragon) Whitill ULT Del Rappy, Saint Million, Shambertin, Kondrieu drops are no longer listed as ???. They are regular drops. View all changes here. Changes are highlighted in red. DOWNLOAD FOR OFFLINE VERSION 2015-03-03 Valentine's Event 2015 drop chart in effect DOWNLOAD A new filter was added in the online version so you can see ONLY the event drops. This should help to see JUST the event items. A permanent tab located at the bottom of both the online & offline versions was added to show the drop chart from .../test/newsite page. Use this in case the event ends and the drop chart from the homepage is not updated with regular drops. view changes from Christmas Event 2014 to Valentine's Drop Chart 2015-03-02 Spreadsheet using non-event drop chart from .../test/newsite page The drop chart from the home page is still showing Christmas event items. The drops from http://www.phantasys...e/droptable.php should have all the regular drops during non-events. I've updated the spreadsheets with this NEWSITE chart.2015-01-30 Drop chart updated DOWNLOAD view changes from previous drop chart to this one 2015-01-29 Christmas 2014 drop chart in effect DOWNLOAD view changes from Summer Event 2014 to Christmas Drop Chart 2014-08-11 Drop chart gets updated with Summer Event drops. Other random items are also effected. DOWNLOAD view changes from Easter Drop chart to Summer Event drop chart: 2014-04-24 Larva has made recent changes to the drop chart. Chart now includes these changes. Easter Event drops are now shown in the spreadsheet. DOWNLOAD TIPS FOR USING EXAMPLE OF USE: Download the spreadsheet for offline use After opening the spreadsheet, select File --> Download as --> select the desired output format. Note that free office suite OpenOffice can open Microsoft Excel files and OpenDocument files. You can download OpenOffice here. EXAMPLE OF USE (online version): Finding all Wedding Dress drops STEP 1. Enable filter views. Select Data --> Filter Views... --> Create new temporary filter view STEP 2. Select the Wedding Dress drop as shown in the photo. STEP 3. Now, only the Wedding Dress drop is shown. You can use as many filters as you like. For example, if you want to see only Ep4 Ultimate Redria drops, just enable those filters (ep4 episode, ultimate difficulty, redria ID). EXAMPLE OF USE (offline version): Finding all Limiter drops Step 1. All drops are shown. Step 2. Select item to find (Limiter). Step 3. View all Limiter drops. You can use as many filters as you like. For example, if you want to see only Ep4 Ultimate Redria drops, just enable those filters. Edited July 14, 2015 by Nessly 16 Quote Link to comment Share on other sites More sharing options...
foiexx Posted March 30, 2014 Share Posted March 30, 2014 good job! thank you Quote Link to comment Share on other sites More sharing options...
King Ra Posted March 30, 2014 Share Posted March 30, 2014 That is awesome Quote Link to comment Share on other sites More sharing options...
HandlebarsFakis Posted March 30, 2014 Share Posted March 30, 2014 very awesome job, id give 10 rep up for this if i could haha Quote Link to comment Share on other sites More sharing options...
kajex Posted March 30, 2014 Share Posted March 30, 2014 <3 1 Quote Link to comment Share on other sites More sharing options...
MASSBLADE Posted March 30, 2014 Share Posted March 30, 2014 Excellent Work Nessly, good stuff! Quote Link to comment Share on other sites More sharing options...
Soly Posted March 30, 2014 Share Posted March 30, 2014 (edited) Sadly... i dont wanna be the one telling this... but the dropchart at http://phantasystaronline.net/droptable.php is NOT updated, it is from xmas drops the updated dropchart is here http://www.phantasystaronline.net/test/newsite/droptable.php Although most of the drops are ok... some of them not... you might wanna check that Edited March 30, 2014 by srojasq Quote Link to comment Share on other sites More sharing options...
Nessly Posted March 30, 2014 Author Share Posted March 30, 2014 Ah no problem guys. I hope you find it useful. Sadly... i dont wanna be the one telling this... but the dropchart at http://phantasystaronline.net/droptable.php is NOT updated, it is from xmas drops the updated dropchart is here http://www.phantasystaronline.net/test/newsite/droptable.php Although most of the drops are ok... some of them not... you might wanna check that Ack. Thanks for the heads up Srojasq. >.< How did you come across this link? http://www.phantasystaronline.net/test/newsite/droptable.php Quote Link to comment Share on other sites More sharing options...
Soly Posted March 30, 2014 Share Posted March 30, 2014 there was a link to another chart (was the same in the new link) but chuk moved it (idk why), when i asked he gave me that link! Also you dont have to dupe the complete dropchart (idk if you did this) but you can only take the "best" drops for each item!! 1 Quote Link to comment Share on other sites More sharing options...
Nessly Posted March 31, 2014 Author Share Posted March 31, 2014 (edited) there was a link to another chart (was the same in the new link) but chuk moved it (idk why), when i asked he gave me that link! Also you dont have to dupe the complete dropchart (idk if you did this) but you can only take the "best" drops for each item!! Ah yea, I now see that the old one (on the homepage) still has Xmas drops like Girasole... >.< That should really be fixed. Alright, I've pulled the new chart from http://www.phantasystaronline.net/test/newsite/droptable.php ( phantasystaronline . net / test / newsite / droptable.php ) and remade the spreadsheet. The first post's download link has been updated with the new spreadsheet. Thanks again for the heads up srojasq! Edited March 31, 2014 by Nessly 1 Quote Link to comment Share on other sites More sharing options...
Soly Posted March 31, 2014 Share Posted March 31, 2014 You're welcome... i'll download it now... will be easier to see what to hunt!! Quote Link to comment Share on other sites More sharing options...
kajex Posted March 31, 2014 Share Posted March 31, 2014 Ah yea, I now see that the old one (on the homepage) still has Xmas drops like Girasole... >.< That should really be fixed. You don't want to find Girasole in April? We finally just de-buffed the belras from Halloween LOL. Wait another two months, and we'll update the chart. 2 Quote Link to comment Share on other sites More sharing options...
brofenix Posted April 12, 2014 Share Posted April 12, 2014 Just saw this post Makes me happy to see Glide Divine's drop is lower than 1/7000 haha. Thank you based mods and you as well Nessly! Quote Link to comment Share on other sites More sharing options...
Nessly Posted April 25, 2014 Author Share Posted April 25, 2014 Larva has made recent changes to the drop chart. Please download the new spreadsheet from the first post of this thread for the new chart. Quote Link to comment Share on other sites More sharing options...
Evie Posted April 25, 2014 Share Posted April 25, 2014 Good job Nessly, this is so useful ^-^ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.