Catalog Completion Gaps

[1oldtymer]

That works, but if I understand it properly, it will repeat all those element items over and over. That is, for every material number that has a recipe including No., all the No onigos will be listed. I'm not sure what the max of any element type is, so if it isn't large, your format should work just fine and be more self contained than my thought of listing each item only once.

[MSG Commander]

[quote=22190]

It needs formatting and I don’t know how to put multiple tables side by side, but it’s a start. For those who want a sort-able spreadsheet, I could upload one to the forum? I think MSG Commander made it so spreadsheets could be added?

[/quote]

I think that gets the job done. I did set up for spreadsheets but only one format, so if the one you want doesn't work send me a PM with the file extension and I'll see if I can add it.

Aside from the "catalog," it might just be easiest to upload all the other data as a spreadsheet in the forum anyway. At least for starters.

[3beez]

Welp, I give up. I've backtracked and set traps, and more traps, and more traps. I still can't find enemies 22 and 24. They may remain a mystery forever! And so too, the little dude in the Satan Island dungeon. ??

[1oldtymer]

I tried the same: every location set large traps with all 4 baits, and even more traps, and then did the same at the deepest part of every dungeon....with the same empty result. I already bought a one way ticket on the failure bus.

[3beez]

BTW, here's a spreadsheet with all but the two missing critters; so you can sort the catalog by any of the headers:

[1oldtymer]

Yipee! Finally a "table" that supports multiple column sorts. I've lobbied unsuccessfully with MSG Commander for exactly that functionality, but it is a pain to create in the standard "table" format. Your spreadsheet is just what is needed. In Onigo Hunter, it helps to be able to sort on element, name, and location when fooling with the crafting. Thanks for showing us how useful your format can be.

[MSG Commander]

[quote=22456]Yipee! Finally a “table” that supports multiple column sorts. I’ve lobbied unsuccessfully with MSG Commander for exactly that functionality, but it is a pain to create in the standard “table” format. Your spreadsheet is just what is needed. In Onigo Hunter, it helps to be able to sort on element, name, and location when fooling with the crafting. Thanks for showing us how useful your format can be.

[/quote]

Which is why I opened the forum for uploading spreadsheets; there is no practical way to create a walkthrough page with sortable columns. If this format works better, then by all means feel free to upload more spreadsheets.

[Islandi]

Guys, since we can upload and use spreadsheets, why not utilise the Pivot Table function to sort and manipulate the data to show the information we want?

https://www.gcflearnfree.org/excel2013/pivottables/1/
https://exceljet.net/things-to-know-abo ... vot-tables - scroll down to #10. Group a pivot table manually

[3beez]

I've used many a pivot chart; they can be handy, indeed. The filter option I applied to the above spreadsheet allows for the same sorting (sort of). Just click the down arrow beside the category you want to sort by, and choose your preferred sort. Easy-peasy!

Although not everyone can open the XLS file type.

[MSG Commander]

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.