Spreadsheets in Space
Posted: 2013-03-13 Filed under: eveonline, industry, market | Tags: anshar, aurora, bpc, bpo, carrier, pos, scorch, spreadsheet 11 CommentsMy 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.
Blake’s Papercuts
Posted: 2012-09-27 Filed under: eveonline, industry, market, nullsec | Tags: api, bpc, bpo, inventory, me, pe, pos 2 CommentsInspired by Jester’s post about accepting Eve as it stands, I started to record my own personal headaches while performing Industry and Trade related tasks.
Manufacturing/Invention
1. Menu items on Blueprints: I want to be able to Right-click, build or Right-click, invent from the hangar.
3. Batch processing: multi-select right-click, build/invent.
3. Two stage jobs, like capitals that have components that are build from minerals, can be built with one click from the capital Blueprint.
4. Easy display of Blueprints ME/PE from hanger view.
5. Stack Blueprints of equal ME/PE levels.
6. Multi cycle runs. Make 10 items 10 times as long as you have the required items in stock.
7. Pause jobs if they run out of materials and allow resume when sufficient items are placed in the hangar.
Booster Trade
1. Expand profession. Currently I know of a few major manufacturers of drugs and distribute to niche markets. I want to be able to have more players in the market, many more markets, and a feeling of sneaking contraband around the galaxy.
2. Given the limitations on production to POS’es, the barrier of entry for manufacturers is high. I remember a long time ago hearing about how Mittani proposed a drug manufacturing ship; imagine a stealthy ship that arrives out of nowhere, makes you drugs, and retreats into the abyss.
API
1. Expose Blueprint ME/PE/Run/Remaining.
2. Expose tower CPU/Power utilization and any timers such as anchoring, on-lining, or reinforced. (Metagame++;)
3. Expose saved ship fits for read/write to allow developers to create alliance/corp/mobile 3rd party applications for working with fits using XML.
4. Do not allow the buying, selling, modification of orders (I’ve wrote about the potential botting implications here).
POS Rework
1. Grant the ability to move POS’es between characters, corporations, and alliances.
2. Scrap the worthless Refining Arrays. They refine at too high a loss, are cumbersome to load and start refine jobs. In the new system you should be able to create paths between modules like we have in PI to transfer goods for constant production.
3. Add a mechanic for hacking/taking over offlined and abondoned towers.
Unified Inventory
1. Dragging something to the station Item or Ship hangar should automatically place it in the proper hangar. I hate having to drag ships to ships and item to items. The goods are going to my local hangar, just put them there.
General
1. Automatically remove me from my ship, stop skills from training, and initiate the clone jump.
2. Prompt/warn me that my clone is out of date before undocking.
Timers
1. I want to be able to see the time remaining for various things (GCC, etc) in the same fashion as the undock timer.
Kill Reports
1. Add Logistic repair amount.
2. Add coordinate and time data down to the millisecond to allow people to develop applications to replay and analyse battles.
Mass Tech 3 Hull Production
Posted: 2012-07-08 Filed under: industry, ships | Tags: bpc, legion, loki, pos, proteus, sleeper, tech 3, tengu 3 CommentsIn addition to the massive stock of Subsystem BPCs that I recently acquired on a bulk deal, I have also picked up a large amount of Tech 3 hull BPCs.
I thought that a large batch of hulls would go along nicely with the production run of the Subsystems so I bought them after running the numbers.
The bulk deal was for enough BPCs to make 443 Hulls. The average BPC price per run on the deal came out to 18.35 M. On public contract right now, a Tengu BPC is trading at about 20-25 M/run.
Construction Skill Prerequisites That I Need
Frigate Construction IV
Cruiser Construction 5
Amarrian Starship Engineering 5
Caldari Starship Engineering 5
Gallentean Starship Engineering 5
Minmatar Starship Engineering 5
I will need to train up Cruiser Construction to V and each racial Starship Engineering to V. Each one will take around ~22 days to get to V.
I currently have 6.7 M skills in Science on my industry, invention, and research alt so this will help round him out by giving him the ability to produce a large variety of Tech 2/3 ships.
The Stock
I now have enough BPCs to make 119 Legion, 61 Loki, 51 Proteus, and 212 Tengu Hulls.
Production Run Considerations
Tech 3 Hulls and Subsystems can only be made in an Subsystem Assembly Array anchored at a POS.
A mobile assembly facility where advanced subsystems and hulls of strategic cruisers can be manufactured
3 manufacturing slots:
Base time multiplier: 1.0
Base material multiplier: 1.0(Note: Tech III hulls cannot be assembled at starbase structures. The hulls and subsystems can only be assembled whilst docked in a station.)
Just the 212 Tengu Hulls will take 7 months to produce on 1 production line. I’m not sure how many Subsystem Assembly Array modules will go live for the run or how many characters will be trained up to produce yet.
Profit Estimations
Making 443 Hulls will produce a profit of 12.9 B minus the investment for the BPCs at 8.1 B. The profit estimation is around 4.7 B.
Note that the previous profit number does not account for the cost of running POS.
Botting Journey to Deep Nullsec
Posted: 2012-03-01 Filed under: eveonline | Tags: bots, Botting, bubbles, drake, nullsec, pos, ratting 1 CommentAfter seeing JonnyPew’s videos on how to fit a bomber and search for bot activity in nullsec, I set on my own journey to see if I could find them action.
His guide shows how to fit a Hound, which I cannot fly. Luckily the fitting differences between racial bombers are not that high so I changed one or two modules and bought up Nemesis fit. The total was around 36 M, which included four bombs and a compliment of torpedoes.
After looking at a few regions on Dotlan, I found a pocket of space that contained a high (inhuman) amount of NPC kills. You can easily see these by filtering for NPC Kills over the past 24 hours and seeing areas where 10,000+ NPC kills occurred.
I set course and flew out of Jita 4-4 towards the unknown, 67 jumps to be exact.
I’ve spent a far amount of time in nullsec, navigating with large fleets and going on solo roams in cloakey ships so I was confident in my ability to dodge bubble camps. I did have to pass through the N-RAEL system, which is a known hotspot as it connects Empire space to the Great Wildlands. I watched the gate and picked a quiet hour to sneak in after seeing a few industrialists go back and forth.
Pretty uneventful until I got into the destination constellation, where the locals were pretty active. The final jump laded me right into a pile of bubbles. It was clear that the locals did not want a lot of traffic to get around easily.
I found a celestial, aligned, cycled the MWD, and cloaked. When I breached the bubbles, I went into warp. I made a few safe spots and refreshed the directional scanner to get a good feeling of what was around me. There was only one Force Field on scanner, a Drake, and a few frigates.
Note: Count the number of towers and force fields listed on the directional scanner. If the count does not match, then a tower is offline and you might be able to see if any goodies were left anchored.
I’ve been hanging around the deep nullsec system for a week now, monitoring activities and taking names. I haven’t pounced on a ratter yet as every time I login, I see a lonely Drake warp to a safe POS and disconnect.