Data Spreadsheet

So, I’ve been messing around with a spreadsheet that automatically updates as game patches are pushed to Steam:

It’s set up so that you should be able to (relatively) easily pull data from the spreadsheet, for use in your own projects. Additionally, I’m leveraging @Okkelinor’s excellent world color spreadsheet to generate lists of available item/color pairs (and where to find them).

I’m trying my best to hide game data that isn’t available to us yet (aka spoilers). Please let me know if you see something that shouldn’t be there, or know of things that are missing!

I’m hoping that people will find it useful!

18 Likes

Wow, that is super useful! and all of that info will update on patch? VERY nice.

1 Like

Yup! Though, let’s be honest, it’ll probably break from time to time :stuck_out_tongue: There’s a lot of moving parts behind the scenes to make this happen automatically

Also, a second spreadsheet that auto-updates for testing patches:

1 Like

Well this is going to make my project, Much, Much easier to compile.

1 Like

Heya, There seems to be a few errors with this things pulled data;

  • Bulk and Mass Craft calculations for smelting that are not available ingame
  • All Fresh Vital Essence recipes are showing bones instead of their respective requirements.

I noticed both of these when double checking the data in my Item Estimator after last update for LED Blocks.

1 Like

Doh! I’ll try to dig into those in the next few days; thanks for flagging :+1:

2 Likes

For the bulk and mass furnace options, they are in the game files, so there is likely no error there

Thank you for providing this! I’m putting the known gatherable colors into a searchable table. Having a sheet with that info combined already saves me a lot of time. :100: :trophy:

1 Like

Is there any way you can add a tab that has the colors grouped by their primary name? Here’s a really slapped together js implementation of what I mean: https://gist.github.com/NewDark90/35078c7c2809b93bab0e15b6095cff4c