Your friendly data-elf here with another spreadsheet I’ve been working on This time it’s the complete planetary resources as reported by the server.
The difference compared to All embedded resources from all planets (pics + google sheet) is that the numbers are relative to other planets. This means that you can actually see which planet has the most of a resource, the numbers in the in-game resource tab are relative to that planet. 10% diamond on a planet that has a total of 100 seams is worse than a planet with 5% diamond that has a total of 50000 seams.
The server reports the actual object counts, so I can tell you how many desert swords there are, compared to the fibrous leaf count. This data could be refined to tell which planet has the most fibrous leaves too, but somebody else can have the honor of doing that, I’m fine with this version. Hover over the plant etc names to see what they drop. Drop data source is @Pfiffel who made http://www.pfiffel.com/bl/drops
A sneak peek for those who can’t open that atm.
edit: A fun fact, there are 8 rough oortstone (seams?) in the world, let’s see if someone can actually find them
Oh and a big disclaimer, the plant, boulder etc names are manually derived from their respective drop rates when comparing to the resources tab in-game. There might be errors in the column titles but I did my best. Let me know by commenting or pm me here if you find a discrepancy.
Thanks to the original resources spreadsheet for the general feel and visual style and @Simoyd for creating Boundless Proxy UI which I used to collect the data with.
Sorry, yeah I’m bad at explaining, they’re relative counts between the planets, 100% means that’s the highest amount in that column. I’m not sure if that makes any sense either Does somebody know what that’s really called?
The percentage number is relative to the maximum count in that column.
28% means that the amount of that resource on that planet is 28% of the max count.
These are the raw numbers, ruby is highest on Alcyon at 40k seams, Serp is 23k, which is 58% of Alcyon. Does that make any sense? That’s what I mean with “relative to other planets”
I would’ve kept the raw numbers if they were a bit smaller, if I wanted to fit the large numbers in to a nice looking spreadsheet you’d have to scroll the columns a lot, with the percentages I could fit it on a single 1080p screen. But the raw numbers might’ve been easier to understand
No problem, I hope this helps at least one person looking for that best planet for a specific resource. I know I had a lot of trouble finding where to farm each one.
Thanks! Took me a day in total, might be a lot for some, but I’d have done it even if just for myself to give my mind rest about the true best planets for each resource.
The data was taken at about 10am UCT today btw, the numbers are from the situation at that time. Popularity of, for example mining planets in the long run can change the numbers.
Static, I did the data entry with a modified version of the proxy ui program to display me the most recent planetary resource data that has been received (happens when you open up a world’s details from the places menu). Then copy-paste’d that to the corresponding planet’s row. The server reported data is dynamic, the seam numbers change as they are mined and regenerated. But the values in the spreadsheet cells don’t auto-update to reflect live data.