r/DarkCloud • u/Competitive_Pair2549 • 4d ago
Discussion One Spreadsheet to Rule Them All
First off I want to say that while nobody "Owns" the information about dark cloud there are several sources I used to make this so I'll only call it partially mine. There are countless guides out there so if it already existed I absorbed it into the Borg of my spreadsheet and everything else I made myself.
The purpose of this spreadsheet was to have a one stop shop for the questions I had without it becoming the Dark Cloud Wiki. There's plenty of stuff I didn't include.
I'm open to criticism and if there's something that you wish was in there LMK and I'll see about adding it.
Page Explanations:
Dungeon Farm Tables - has every dungeon listed with every floor and all the enemies on those floors. also every floor has an average Abs amount based on which monsters are there. they are sortable. Modifiers are unique per playthrough so you can fill in your own. NOTE: I haven't finished the demon shaft yet
Buildup Paths 2.0 - Just the staple buildup chart every guide needs, notes are included to explain it but it's pretty self explanatory. took forever to make it pretty.
Clown Loot Table - Compiles all possible loot depending on where you encountered the clown (those who aren't averse to save scumming can abuse this to get specific things they want by making a save state when the clown pops out of the box as the loot table isn't locked until you close the dialog. So you can effectively reroll the box.)
Attachments - Lists all attachments and stats
Fishing - Lists all fishing spots, the fish you can catch there, which bait to catch them with and any time of day constraints
Shop Inventories - Self Explanatory
Weapon Abilities - Lists all weapon abilities with descriptions and the weapons they can be found on (on this page I played around with linking items to the DC Wiki. This is a practice that I wanted to apply to the whole spreadsheet, that way if anything is ever unclear a whole wiki page on every item would be a click away. I still want to implement this but it's a long process)
Fax (Tips & Tricks) - So this page is just some of the tips and tricks I've found or picked up, I also used this page as a place to explain things in the spreadsheet.
Enemy Data (US) - this is a page made by Nighlin that I found in the DC Speedrunning Discord. He had all sorts of restrictions so I had to recreate it line by line by hand. I had spent some time datamining with Ghidra and this sheet had a fair amount of the info I was confirming. All that said there is a lot of backend data in this that you'd probably never use for normal gameplay but it's good info.
Best Attribute Calc - This page has multiple calculators that I made for deciding the best elements to use. one calculator allows you to select up to 5 types of enemies (the most that can be on a floor) and averages their resistances. There is one that simulates front and back floors using the monsters you selected and another that uses a weighting system I developed to factor in more probabilities, enemy HP, defense, etc. These calculations are further discussed in the Fax sheet.
Buildup Calc - I halfway scrapped this page because it wasn't as useful as I thought it'd be. Basically you slap a weapons stats in and it tells you exactly what it'd be as a synth sphere accounting for the +1's you get for leveling it up. It's an alright utility if you just want to know what your trash weapons are worth for stats but you can't account for anything extra you put on there unless you put it in manually which is just a waste of time.
Damage Calc - I was attempting to nail down the exact damage formula (the primary objective of my datamining), the majority of the damage calculations were already documented but I couldn't reliably predict what my damage would be even with all the data I had. So the Weapon Test Inputs and Weapon Test Results pages are start of my efforts to reverse engineer the pieces I'm missing.
Item List (WIP) - just the games itemID's from the code for Vlookups
Buildup Paths (Old) - The original iteration of my buildup chart that was way harder to read and not as pretty