Friday, March 13, 2015

T3 Profitability Spread Sheet v4



If you hate spread sheets, hate manufacturing and have your own T3 spreadsheet that’s super amazing already, stop here. I don't want you're know it all attitude mucking up my amateur hour shenanigans. 

The last time I tried this I was bombarded by all manner of crazy messages, people and nonsense.This blog post goes out the little guy who doesn’t have any T3 spread sheets and might not know this information already. 

Leave your opinions at the door and come with me on a journey. A journey filled with Excel references, margins, math and Jita market craziness.

Behold my T3 Profitability spread sheet  








Updated as of 10/11/2015 with the T3 Destroyer values.

Why didn’t you put it on a Google sheet? 

I’m happy you asked, well this can be summarized in one sentence that Lotor said to me. “Google Sheets are great if you don’t actually need it to do things Excel can do”.-- lotor

My first attempt to do this was using a Google Sheet formula but I ran into issue after issue, of Google Sheets not updating the XML data from EVE central. This caused the spread sheet to constantly crash and was useless to everyone.

If you’re concerned that I may be transmitting a Virus, this is a good fear, trust no one! I could simply say it doesn't but seriously in this day and age don't ride bare back. Scrub this document with your best virus protection program. Here is my personal favorite http://www.mcafee.com/us/

Now that you have scanned and opened my document, let’s get started.

Why does this document exist:

 I had the question rattling around in the empty cage I call a mind, 'should I build a T3 with the Sleeper materials I find in W-space?' 

People make T3’s all the time, but is it actually worth the time to make them? Version 1 of this document was released by me trying to prove that T3’s were not, in fact profitable, when you combine overhead, research, fuel, investment… whatever.. Well CCP has recently revamped some of the materials needed to construct T3’s and v1 became useless. Figured I would try again.

Terms I use in this document:


  • Sleeper level Items:  The stuff sleepers give you from salvaging their wrecks.



  • Component Level Items: The items that are created using blue prints found in  high sec. These items require sleeper level items.



  • Jita Buy Value: This is the price that matches a Buy order  in Jita. This is also the baseline I use to determine the value of items. It doesn’t matter how much YOU think the item is worth, what matters is how much someone is willing to pay for it at a given instant. ‘But Spear nobody sells to buy orders! That’s just dumb!” Well fucker, there isn’t any other consistent baseline to make a spread sheet from, don’t like it make your own with your own values!



  • Jita Sell Value: This is the lowest price you can fly right up and buy that item if you wanted. It’s often very different then the buy value, but it’s always higher. The difference between the two is the margin value that is enjoyed by station traders.



  • Construction Value: This value’s baseline, comes from the Jita Buy value (sleeper stuff) and the final sell to buy order of the final product. (subsystem/ship). Example: Find sleeper loot, use sleeper loot to make hybrid component, take hybrid component build subsystem or T3. Still with me? This is the amount of money you receive if you salvaged a sleeper, then built a T3. That is all. This doesn’t take in your time, ammo and all other subjective things. I even included the price if you simply wanted to skip the sleepers altogether, bought all the sleeper parts from sellers, and built the thing yourself. Cool right?!


How to use this spread sheet (Excel):

Since Google Sheets is a total pile, you will need to refresh this excel sheet’s XML data call.  


Click the Data Tab at the top the click “Refresh All”. This fills all the cells on the Math Tab with every information imaginable from EVE Central. 

The other tabs pull information from these tabs. It takes a minute or so (longer if your internet connection sucks) , and for some reason it fails at Item ‘30254’. It asks if you want to continue, just click yes and move on with your life. No clue how to fix that, if any of you Excel peeps know how, please message me because I’m stumped on that value. This is the only value that fails, no clue why.

 
Once you “Refresh All” it will give you current EVE Central XML prices currently on Jita.


Interesting things I found out:

Objects in this construction supply chain seem to have 0 memory of items 2 steps before them. Let me explain. 

You know that nifty new industry window with the item value and the construction materials total value you can clearly see? Ever wonder where that information comes from?  I think, and I might be wrong but it looks like that value isn’t based on the SUM of all items it takes to create the final number, but its simply the sum of all the numbers in just this transaction.

Explanation of what a transaction is: Take Hybrid Component level items for example. Sleeper stuff + Hybrid Component blue print = Hybrid Component. Hybrid Component + Subsystem Blue Print = Subsystem. These are two separate transactions to complete 1 item right?  

Well wouldn’t you think the value of the sleeper stuff should define the value of final Subsystem? 

I do, so that’s what I did with this spread sheet. The in game tool keeps those two separate transactions as totally independent from the final Subsystem value and outcome, bad if someone wants a larger pricing/value picture. 

Combine this with a Hybrid Component market that isn’t populated because almost no one makes Hybrid Components to just sell. This is the recipe for some truly crazy construction supply chain discrepancies. 

To the tune of about 10 million + Per unit, to the people who make T3 subsystems. Not only that, but the T3 ship builders make the most from this total mess. To the tune of about 40m per ship.

At first I thought it was just because of how expensive research was. Its not, damn near everyone knows that sleeper data and relic sites are near worthless to run, so thats not it. No idea what the disconnect is, but you can profit by it in a big way. 

Where it does seem to matter is for Confessors, the research mats for those are VERY expensive, but not T3 Cruisers or subs.

Why am I telling you this instead of just profiting from it myself?? I don’t know, guess I’m just a nice guy, I like cheap T3’s and I like sharing information, hence the blog/podcast. 


The fate of this Spread sheet going forward:

This was a fun sheet to create and I like uncovering neat things in EVE so I’ll keep updating it as I find out more information. Or if someone finds a problem or something I overlooked, I’ll update the sheet. Check back in for other versions.

Also, this shit took me a long time make, if it helped you make Space Cash, toss some my way would ya?   

If you lost money from my spread sheet please send the bill to Foedus Latro he’s my sponsor and is covering for my mistakes.

Enjoy


Tuesday, March 10, 2015

Moist. and Salty!




(TLDR: After a Moist cap gank, some Moist pilots are salty, but payback will need to wait.) 

That title!   

A few weeks ago one of our scouts found a wormhole owned and operated by Moist.  A fairly large alliance with a relatively active kill board but with a propensity for running capital escalations in their home. The scout stayed and watched them for a consistent behavior of running escalations with little sub cap support and was not disappointed.

Fast forward to us connecting to them again during their site running time in the normal rolling and scanning of our chain. We formed up and prepared to jump their fleet. Well our targets were not easily ganked, they had crit all the wormholes connected to them, so the quickly conceived plan was for a small group of interdictors and guardians to jump the cap fleet, keep them there till the main fleet arrived from a newly rolled hole.

Well it went to shit. Their Loki pilots were spot on and vaporized our interdictors before they could escape their own bubbles. Kudos to them. 

The interesting thing was the smug shit talking that occurred after our failed gank. I wasn’t a part of this convo and only heard it second hand, but the joke in TS was them asking in a condescending way “What was that plan, lol” I’m sure I’m misquoting it, but it made us all laugh. It was a dumb plan, but god damn it we tried and that should be respected.  

This spurred a renewed vigor to move in a T3/Dread fleet and log off.

The next time they ran home sites, this happened.


https://zkillboard.com/br/29815/ -- Isogen 5 destroyed -- 21,417,410,075.94 In ships


They could have had a chance if their loki didn’t warp off and save himself. Or if all their dreads actually went into siege during the fight. Different things could have happened that could have changed that outcome. That gank was far from one sided.

I think we may have resisted the urge to convo that same guy and say ‘That was the plan’.. though it would have been funny, it was in poor taste and we have a greater level of respect for our targets than that.

Well we patted ourselves on the back and went home, leaving a dread logged off in their system till he could be scouted out at our convenience.

That convenient time never really came around, so the pilot decided to exit the hole during our prime time in force. We just happened to have a direct connect to our home 13 jumps from their direct connect. So we formed up a fleet and started moving through Null sec.

Now normally a 13 jump trip through deep null sec is boring as hell, we might find 1 guy ratting somewhere, but this trip was filled with all levels of random. 2 jumps out we came across a small group of battle cruisers sitting on a gate. Typically we would be all over it, but we had to rescue a dread so we ignored it. This only made the battle cruisers more curious and they started chasing us.

Weirder still, a fleet of 5 Fed Navy Comets flown by no other than Moist themselves passed us on the way to their direct null sec. I guess they saw us in local at some point and figured out what we were going to do, so then it became a race to the Moist direct null before they could close it in our face, further trapping the logged off dread.  

On our journey we came across other ships, at one point we were fighting a Tengu and I might have accidently exploded an unfit hulk that jumped right into my Gila. https://zkillboard.com/kill/45100305/

The Fed Navy Comets fleet beat us there and we expected to have a total brawl on the Null as our Moist scout was calling out watch listed pilot after pilot logging in while we made our way there. This dread rescue fleet could run into a hell of a fight! Nope. We got there, dread exited, no response.  #sadface

O well, guess we should go. The dread jumped to safety.

But… A lone Astero flown by Moist pilot Ithios, (former Archon pilot, recently deaded by our cap gank https://zkillboard.com/kill/45028554/  ) wasn’t going to let us off that easy. I’m guessing this guy had reason to be salty so he was following us for some payback. I can get behind that, good luck bro, bring it.

As we jumped from system to system on our way back Ithios gave pursuit, but we were one stop ahead of him. We didn’t really care if found us, we just wanted to blow him up  (sensing a theme here?). We asked one of our home pilots to set up a bubble in line from one gate to another as ithios followed us. We would be caught in a bubble but so would Ithios, not only that, but it would be at the exact same distance so he would be uncloaked by us.

Well, as we took our time waiting for the interdictor trap to be set up, we got another pilot from Moist following us back to our home. Sergon Echerie also a former Moros capital pilot from our capital gank https://zkillboard.com/kill/45028460/  --Two very salty peeps looking for some pay back. I like it! Good stuff, for good stories!

Sadly,  Sargon’s payback would have to wait because we didn’t catch Ithios with the bubble uncloak trap, we caught Sargon…in his stealth bomber https://zkillboard.com/kill/45100816/  -- a Quick “ggWP” (good game well played) was said in local.  Much respect Sargon, better luck next time.

Ithios still on the loose, saw our little ruse or was told by Sargon, we don’t know, but he avoided it entirely and found our direct Null. But, we weren’t out of tricks yet. So we formed up a gang of interdictors and waited for him on the direct null connection. Wanting to force his hand and kill him, we jumped the archon through to put mass on the hole.  Ithios would either need to try his luck with a dash into the hole or miss his chance as we rolled him out.

He tried his luck and lost. https://zkillboard.com/kill/45100940/ Astero – and pod https://zkillboard.com/kill/45100944/  Both relatively empty. Better luck next time Ithios, nothing personal.

I wanted to ask him, in the same condescending way “So what was the plan there, lol”? but the urge was resisted.

A few days later, we are talking in coms about the Moist guys and I guess they are still salty, to the point where a single pilot of theirs is offering 250million isk for an entrance to our home hole. One of our directors convoed him and offered to sell him an entrance for 1 billion, he refused.

So if you are connected to Isogen 5, want to make a quick buck, convo one of these dudes mentioned. You too, could taste from the great Salt Lick of Content!