Spreadsheets in Space

My side interest in information aesthetics is present in my work, both professional and personal. I’ve received many comments on how clean and clear my analysis charts, reports, and spreadsheet work can be so I though I would share some of my Eve related spreadsheet work to inspire people.

Here are screenshots from depreciated spreadsheets that I used for industrial production, speculation, and fuel estimations before switching to a custom web-based solution that my partner, Raath, created.

My design goal has always been to use small type-face Arial text that is boxed and columned with important information highlighted in primary colors or shaded in gradients to denote best to worst status. Some of these sheets are old with broken formulas or outdated build requirements. Pay more attention to the organization rather than to the numerical content.

Ammo

Ammo

Compression

Compression

Copy BPOs

Copy BPOs

Copy Capital BPOs

Copy Capital BPOs

Freighter Construction

Freighter Construction

Jump Freighter Construction

Jump Freighter Construction

Margins

Margins

POS Fuel

POS Fuel

POS Fuel Blocks

POS Fuel Blocks

Procurer Speculation

Procurer Speculation

Ship Construction

Ship Construction

T3 Construction

T3 Subsystem Construction

T3 Hull Construction

T3 Hull Construction


Trading Performance: Ammo

Overview

I’ve stated in a few monthly or end of year reports that I’ve had limited success with ammo. I made some database queries and went over my historical trading data to evaluate ammo trading performance.

Market Group Stats

45.481 M units sold, profit of 2.382 B, and average profit/unit of 16,556 ISK.

Analysis 

From this analysis you can see that working with Faction ammo and certain Tech 2 ammo types are the most profitable. I’ve highlighted the ones that I would continue to work in a blueish shade.

2013-01-08_trading_performance_ammo


Inferno Bomb Animations

The art department did an amazing job with the new bomb animations. Each bomb has a very unique explosion and these screenshots barely do them justice. Time to dust off the old, er — new Nemesis. The new Bomber models also give the bombing experience a fresh feel.

[update] Video below!