Google Spreadsheet for Manufacturers & Scrappers

HAL

Well-Known Member
Joined
Oct 7, 2016
Messages
22
Likes
70
Points
420
Location
Hokkaido, Japan
Website
www.halnico.com
#1
I made the Google spreadsheet that everybody capable of display Block Information & type a Chunk name to search Blocks!

https://docs.google.com/spreadsheet...hAGzgs8Il6dcH9yjJpNrXSoGw/edit#gid=1956524785

Most of these data collected by Ourmate.
He was a TT Japanese Wiki of Admin, but he quit the Japanese community because of something, so I have undertaken some work now.
Therefore, it’s originally made for Japanese, but I finished adjust to English and open to the public.

I don’t have any confidence with English, so please tell me if there are any mistakes in that. (Also mistake of data;))

How to use the spreadsheet(.gif)
Block Info


Chunk→Block


I hope this will help:)

P.S. I remade sheets and changed URL. Please try again if you 'make a copy' or bookmark.
 
Last edited:

ZeroGravitas

Breaker of Games
Joined
Jun 29, 2017
Messages
3,008
Likes
3,764
Points
675
Age
35
Location
UK
Website
www.youtube.com
#2
Holy... Wow! That's amazing - the slickest spreadsheet I've ever seen...:cool: You guys.:)

Devs, get in here, @Jamie. Also wiki contributors: @streak1, @Baconus_Yum, @WhitePaw2002. You guys seen this? And @layer1 this is relevant to what we were talking about in your thread.

That reverse lookup would be pretty handy for anyone wanting to know which blocks to scrap to get a needed resource or component type. Also, to get an overview of roughly how many blocks use certain chunks.


There are a few price discrepancies I'm seeing, though (from a very quick look). Like the HE missiles are ฿฿144 out. Not sure which sub-component in them has the wrong recipe there... And the GSO Gruntle Guard has a spurious sensory transmitter in it's recipe (making it way out).

Is there an easier way to see and check the raw data? Excuse me if it should be obviously accessible (spreadsheet magic to me).

I've not seen any English mistakes in it, or your forum posts, though.:)
 

HAL

Well-Known Member
Joined
Oct 7, 2016
Messages
22
Likes
70
Points
420
Location
Hokkaido, Japan
Website
www.halnico.com
#3
Thank you so much!
Japanese users weren't said anything when opened to the public, so It means a lot to me.

Oh... It's worse than I had thought.:confused:

Would you be able to modify with me?
I can send you the Invitation if you tell me your Gmail.
 
Last edited:
Likes: Seth_Seth

ZeroGravitas

Breaker of Games
Joined
Jun 29, 2017
Messages
3,008
Likes
3,764
Points
675
Age
35
Location
UK
Website
www.youtube.com
#4
Oh... It's worse than I had thought.:confused:
It could be that some recipes have been tweaked by the devs at some point, I don't know...
Would you be able to modify with me?
I already have a lot of TerraTech related things on the go, so I don't really want to commit to any more, to be honest. But thanks for the offer, maybe sometime.

I'm kinda wondering if the devs are going to implement the in-game Wiki they've talked about previously, and if it would have anything as comprehensively useful as this in it...
 

ZeroGravitas

Breaker of Games
Joined
Jun 29, 2017
Messages
3,008
Likes
3,764
Points
675
Age
35
Location
UK
Website
www.youtube.com
#8
Hey, @HAL. I've just been checking component prices in-game, for this thread, and correcting all the mistakes on the wiki, so I checked the ones in your spreadsheet, too. It looks like only the Fuel Injector sell price is wrong: it should be 340, but it's 321 in your sheet.

I tried to change it but it seemed to mess up the whole sheet, so I undid it. Be nice if you could update it for me, I guess, if you're still into this. :)