Friday, March 13, 2015

T3 Profitability Spread Sheet v3



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  








OR



(Not sure if either of those methods of file sharing worked, but open that file in Excel. If you still can't get it in Excel.. well I'm out of ideas. Please comment on this post with an alternative.)

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!

Tuesday, February 24, 2015

Shattered Wormhole Backpacking Trip Day 5ish Final day



See that Sabre? Yea I do too, a little too often. I saw that Sabre named cleverly, “Scanner Probe”, just one too many times on my D-scan. The interesting thing is he would appear each time I logged in my Confessor pilot, for two day straight. 





My time in W-space has taught me many lessons, one of them is to notice patterns in player behaviors that I might interact with.  “But Spear, you’re just being paranoid.” My paranoia keeps me alive and keeps others dead. Seeing the same ship, named the same way two days in a row exactly after I log on my character means that guy has me watch listed.

For those of you who may not know what a watch list is or what “watch listing” is. Its where you’re hunting a player and add them as a contact, adding the little check mark to notify you when that player logs in. This is commonly used by player hunters to map a targets play times.

What our Sabre friend did was simply add my character to his watch list on an alt. Each time my character logged in, he would log off his main and jump on his Sabre pilot. The thing is, he was sloppy about it. He didn’t wait or change his ships name each time he logged in. Two Sabres in the hole can be coincidence, two Sabres in the hole named the exact same thing long after all connections have cycled…. Well that’s a pattern.

Sure it could be someone lost, without a cloak, without probes… that just so happens to play at the exact same time as me. Nope. I’m not that mark.

I suspect I picked up a dedicated screen sniper from one of my broad casts. Its not like I made a huge effort to hide my character’s name or location. It could be found when I moused over the planet list when I right click and go to my book marks.

Now my opinions on screen sniping. The one hand I’m happy for any use of intel to murder another player, even outside of game tools. Anything that brings players together for the sake of shots being fired makes me happy. On the other hand, he was so very lazy in hiding his intentions and honestly that can’t be rewarded.

Its hard to describe to someone that hasn’t ever hunted another player. That extreme tense buildup of making all the right choices while the fate of another players’ hard work rests in your fingertips. Knowing that the prey could flee the second you fuck up. That level of commitment needs to be rewarded. Even while I assume the role of prey and you hunter I can respect a good game.

Well Sabre pilot you dun fked up. Work harder next time.

Since the outcome of most pvp engagements is determined before shots are fired. This is how the battle would have gone down.

Sabre pilot would have turned on my twitch stream and waited till the moment I refit for salvagers. Without salvagers loaded I couldn’t fight back. I would have warped onto grid to salvage my wrecks, he would have appeared bubbled and I would  be forced to refit on the spot or die to him. I might have had a chance if I could refit and tanked him, but that’s iffy. Good chance that he wasn’t alone.

I decided to evac all scouts and all loots from the frig hole. Git while the gitten’s good.


Summary:

Total backpacking isk gains: 1,423,000,000

Not a bad total for logging in every few days and running sites for a few hours.(2-3 hours every 2 or 3 days, wasn't keeping track. No clue what my isk per hour was, I just know how much money I have now. )


What I would have done differently:

Instead of using cans to hold my sleeper loot, I should have brought in an alt in a cloaky hauler destroyer. Think a destroyer with all cargo expanders and small cargo rigs. You can get them fairly high, not sure how high but I would have slept better at night knowing my loot wasn’t floating in space waiting for Wingspan to come and fly to it.

I would have brought more crystals, just Aurora and Gleam. I wasn’t sure which crystals to use the first time but Gleam at under 10k in a Wolf Rayte is like crack… Its sooooo good. People on my stream were telling me that pulse lasers with conflag was better, meh, I don’t know enough about lasers to counter it. I just know I was dishing way more damage than I should.


IF I was serious about doing this as a longer lasting PVE thing, I sure as hell wouldn’t blog about it, or stream it. There are just too many snipers out there.


That’s about it, everything else was flawless IMO. The fit was amazing, it buffered quite well when I screwed up the timers, it was flexible enough to swap out stuff fairly easy. Honestly the confessor is amazing in that hole.


For those of you waiting to see my confessor explode, well it happened, in a truly hilarious way.

I had dropped off my loot and I was cruising around in High sec and saw a Covert Research Anom. Oooo I can do that, I warped to it hacked 3 cans, the rats showed up, I flipped into tank mode because I have resistances right?  NOPE.

KAAABoooOOM. 







Living in a C13 for about 2 weeks, running sites without scanning out the chain, doing massive salvaging in a combat ship, totally alone... I lived! Then I out wit a scene sniper and his friends… only to have the 275 million isk confessor explode to this bull shit, I had to laugh. 

This is Bobs way of showing I should have stayed in his bountiful domain.


I have been telling people this for years, high sec is the most dangerous sec in the game. Shit is crazy out there!


Thank you for everyone who read this series, asked questions and is having more fun in wormholes because of it. 

Bob Bless. o7