May 15, 2017 at 6:22 pm #22487
I’ve never used spreadsheets in my life so, I’m sorry I didn’t implement them sooner… lol… it just never occurred to me that it would be something people would want. 🤓
If it helps to share them, please feel free to do so.
Spreadsheets are awesome for creating tables and small databases. And math. However, these days I rarely use them for anything other than tables and lists for the games. For me, the “Sort” function is indispensable. I don’t know how you keep your game info straight without ’em! 😉Be silly. Be honest. Be kind.May 16, 2017 at 5:38 am #22489
Guys, I have use @3beez‘s catalog as a database to create 3 Pivot Tables side by side for Item, Equipment and Magic (Crystal) crafting combinations.
You only need to set the filters. You can change the order of information displayed by right-clicking on the filter headers and dragging the fields.May 16, 2017 at 6:20 pm #22494
Nice work, Islandi!
Oh, and this is kind of important. I just realized that uploaded files have metadata in them. The metadata might include info one doesn’t want broadcast to the internet. It’s easy enough to get a “clean” copy to upload (at least for Windows 10. I have no clue about iOS). Here’s how:
- Open ‘File Explorer’ and find the file you want to upload.
Right click the file; select ‘Properties.’
Click the ‘Details’ tab, and at the bottom, click ‘Remove Properties and Personal Information.’
Choose to create a copy with all possible properties removed; click ‘OK.’
In the same folder as the original file, you should now have a clean copy. It will have the same title, but with…wait for it….’-Copy’ added to the title. THAT is the file you want to upload.Be silly. Be honest. Be kind.May 16, 2017 at 6:31 pm #22495
The same technique works in windows 7: just right click on the file to get to Properties, then click “Details” and you will see the link that takes you to the create a copy without the personal info popup.
Older, but not wiserMay 17, 2017 at 12:44 am #22497
Ok, I’ve done what 3beez mentioned and uploaded a “Clean copy” of the Crafting Combinations excel file.
Thanks for reminding to remove personal info for uploaded files.May 19, 2017 at 4:45 am #22505
Found one of the 2 missing monsters. #24: Dark Snake, Geshion Island. Found it on the penultimate screen in that dungeon; trap only, DRG, small; “Waits for it’s prey near to digested bones.”
Edit: I don’t think there is a #22. After getting this one, I got the 100% Catalog Completion achievement. But then again, after this second playthrough, I’m missing 3 treasures again, and the little dude at Satan Island still won’t let me pass.Be silly. Be honest. Be kind.
May 19, 2017 at 10:24 am #22513
- This reply was modified 49 years ago by .
Unbelievable!! Finding that critter was tougher than beating some of the nastiest monsters in all KemcoLand.
I’ve tried using your spreadsheet to narrow the search for #22 and #24, and believe it must be in one of the lands before #26 (so that leaves out a few). I also did some counts by dungeon, and sure enough, Geshion and Seirei both looked odd to me (13 each, when I expected more). I set traps like crazy, but not in the right spot (too bad the final screen in Geshion didn’t have any clean bones, as I spent a lot of time there).
Good luck on #22, but I think we should build a statue of you already and set up here in the Forum.
Older, but not wiserMay 19, 2017 at 5:40 pm #22514
hahahaha! No statue required. My preferred rewards are called “naps.” And I’ve already awarded myself for this…um….”feat of too much time on my hands.” Honestly though, I found the Dark Snake by accident. I did a second playthrough and just threw down traps in random areas as I went along; it was a total fluke that I nabbed the critter. Fluke….ugh. I hate those. I spent hours SYSTEMATICALLY searching…with a system, a plan. And a spreadsheet. (I do the same as you and compare the data for anomalies.) Somewhere at ExeCreate, a developer is “muhahaha-ing” our logical brains.
I think I might need another nap. Oh, wait, I’ve got to update the spreadsheet first. Then, a nap. Yep, now that’s a plan!Be silly. Be honest. Be kind.August 7, 2018 at 4:04 am #29351HawksoupParticipantAugust 7, 2018 at 7:21 pm #29362
Thanks, Hawksoup! With your help, I finally nabbed that ornery critter. 🙂Be silly. Be honest. Be kind.
You must be logged in to reply to this topic.
Members: 509 Forums: 122 Topics: 1,408 Replies: 9,223