Fuzzwork
Category: Dev
Understanding the Eve Online SDE - Part 1
How many parts is something I can't yet answer. As many as it takes. The SDE is a Static Data Extract from Eve Online. It contains information like where stars and planets are, how much Tritanium goes into a Typhoon, what skills are needed for which modules and so on. It's a useful bag of […] Read more
Getting all market aggregates from Market.fuzzwork.co.uk - Excel
This is for Excel only I'm afraid. And only 2013 and up. Google Sheets just won't load the size of file that this uses. On https://market.fuzzwork.co.uk I generate aggregate data for all items sold on the market. This is things like average price, minimum price, maximum price, and the average price if you were to […] Read more
Google Sheets - Updating from a Menu
Something which has been a problem people have run into, is that google sheets have a problem with automatically updating figures from custom functions. You'll often find functions which suggest having a useless reference to a cell which you can then use to trigger the updates. This is obviously somewhat suboptimal. So as a potential […] Read more
Using ESI with Google Sheets
I've been meaning to write this post for a while now, so here it finally is; How to use ESI, with google sheets. Now, the unauthenticated endpoints are relatively easy. You'll still need to write a little code for them, or steal it from somewhere else, but other than that, it should just work. Authenticated […] Read more
Ore compression calculator
I've updated the compression calculator with a couple of new features, and stomped out a bug. The bug was it had the wrong volume for some ores. (oops. it was hooked up to an old database.) That's now sorted, and hooked up to the DB which updates when a new version comes out. New Features: […] Read more
market.fuzzwork.co.uk
With the introduction (a wee while ago) of the new eve market data endpoint, and the problems which surfaced at Eve Central while that was happening, I decided to create my own market data website. And so, I present market.fuzzwork.co.uk I posted it was out a few days ago, but thought I should write a […] Read more
New SDE Migration process
CCP Tellus is a wonderful person. Until recently, the SDE (Static Data Extract) was a mix of YAML, an MS SQL server backup, and an SQLite Database for universe data. This was a bit of a pain to convert, with a whole bunch of steps. Now, the SDE is being provided as a bunch of […] Read more
Using Crest with Excel: Crest Strikes Back
If you've read my older post on it, using Crest with Excel can be a complete pain in the ass. You have to load in a module, then write something in VBA, using it, because VBA doesn't support json natively, and doing it with a user defined function, well, I never got that far, before […] Read more
CREST market data
This has been out for a while, but I've now got something public ( https://www.fuzzwork.co.uk/market/viewer2/ ) out there, I thought I'd write some words. Of all the things which have happened in my CSM term, the availability of 'live' market data is one of the ones I'm happiest about. It might not seem like a […] Read more
Eve Vegas
I know I've been light on posting. Sorry about that, I've just not had much to talk about that I can talk about publicly. At least, not that hasn't been covered in detail by other people. Sugar Kyle has been great at this. Lots of writing. :) However, I've been poked by people that think […] Read more
