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.
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.
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.
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!