Saturday, 7 March 2015

Google docs whack-a-mole continued, plus a request of readers

My whack-a-mole with google docs is continuing.



I have added caching and a random delay to my open copy of the trading spreadsheet.  https://docs.google.com/spreadsheets/d/1qL_ofk-QRQCFt2zKTTEXSi6oY4n1gtZX6Mojxxtgs-4/edit#gid=1869404277

I think it should be ... less unstable than it was before.

Readers, can you please have open (and leave open) the above spreadsheet for a few days, using either Firefox or Chrome.  Eve's in game browser has no chance.  Internet explorer and Opera struggle.  It is a published document and I don't mind if you keep it open longer.

A full refresh (daily) will take a couple of minutes to load.  Apart from that, it should be fairly quick.

If it is breaking, please leave a comment on this page.  If you find yourselves using it (either the original - which I can track, or a copy - which I can't), please also leave comments about how.

This is a continuation of http://foo-eve.blogspot.com.au/2015/03/market-spreadsheets-in-space.html


Thursday, 5 March 2015

Whack-a-mole with Google Docs and Eve Central

My primary PI spreadsheet ( https://docs.google.com/spreadsheets/d/1lXM8PqU0Tn4EJJ2xRuI7uo55IrZ7MKWJidK9T_bA9L4/edit#gid=0 ) is fixed again.


In my last post about Google Docs, I inadvertently tripped a google doc limitation.




I have added caching to this spreadsheet, and temporarily disabled it in my other spreadsheets.  This should not only resolve my urlfetch issue, but also significantly speed up the loading of the spreadsheet.  It comes at a 'cost' of encouraging the data to be up to 6 hours older.

I will be rolling the changes out to the other spreadsheets soon.

I also found a github code snippet from 'Haggen', also putting together google docs based eve-central calls https://gist.github.com/haggen/461a454b200efe89f3e6

For those interested, I have raised a bug on Fuzzy Steve's github repository, https://github.com/fuzzysteve/eve-googledocs-script/issues/5

Wednesday, 4 March 2015

PI general questions


A corp member asked a set of general questions about PI.  These are reasonable questions, and I will attempt to give a somewhat reasonable answer.  I will also use too many words to do so.

You know those white, red, green colours when we scan the planets right? White/red means better yield and green/blue means almost none. The longer we extract stuff in a spot, the colours getting more green and blue will gives nothing.
What I want to ask is, Any difference to the the speed of those colours change between cycle times?

If it is, how much different between 1 day, 2 days, or 3 days cycle?

I want to find the optimum setting of my planet and thinking to change stuff a little bit.

All these time when I set the extractor at white area in one day cycle, I got so much yield that eight of my processing facility can't handle, so much to the point some of the yield get wasted. But not too many days later, the colours got green and the yield got low. I have to find another spot because some of my processing facility idling around at those time.


Not to mention maintaining the cycle between 6 pilot takes time too. I spent 2 hours per day to do those stuff and hauling the waters and electrolytes to the coolant manufacturing planet.

I'm trying to find the optimum settings to extend the time between the activity finding new extracting spots while eight of my processors keep working full time.

How you handle these things? considering you got 4 account that means 12 pilots. If using my way, it will be translated to 4 hours spent each day.


Too much white

If you have a planet with too much 'white', I would like you to change your scanning sliders to show more accuracy.

This image is too saturated with 'white'

Scanning sliders

Change your PI selector in the top left from 'build' to 'scan' (1).  Click on the resource (2) want to tweak, and then adjust the slider (3) so it has a better 'mix'.  Personally I try to just have red, or small spots of 'white'.
Good enough

Replenishment

In my experience, I have noticed a few guidelines for resource hotspots and replenishment.

A planet starts out 'pristine'.  That is no one has done PI on it for a long time.  These initially have a bonus to the amount of PI able to be extracted from any hotspot.

The more heavily you farm any given hotspot, the worse that spot becomes.  2 or 3 players farming the same hotspot with daily cycles will strip clean any location in very short order.

There appear to be 2 forms of replenishment:
  • Over time, the entire planet replenishes it's PI hotspots.  The lower the security status, the faster this occurs.
  • Very good 'nodes' of resource also regenerate far more quickly, especially if given 'respite' from over extraction.
On top of this, some (or all?) nodes tend to 'drift' around the planet over time.

So how fast can you extract a resource?  Some of our pilots are extracting huge volumes of P1 very quickly.  They tend to use daily cycles, and I am actually a little jealous of pilots in my own systems earning more out of PI than I do.  I know what they are extracting, because I buy it from them.

Daily cycles come at a cost in time, and they need to spend much more time than I do 'tending them'.

Cycle time differences


I find that for the many of my wormhole planets, on a 2 day cycle, I can leave extractors control units largely alone for months, only shifting heads every week.  This is optimal from a time management, but not optimal from total ISK earned.  One way I solve this is by initially stockpiling the surplus raw extracted material (P0) either on planet, or if you have a low enough tax, in the customs office.  Later as the extraction slows down, feeding that back into the basic manufacturing plants.  After a few months of this, I generally have to move the extractor control units.  http://foo-eve.blogspot.com/2014/02/single-planet-pi-manufacturing-bad.html

I do have some other planets where I have tried alternatives.  I have one lava planet colony which manufactures single planet P2 transmitter, on a pilot with command center upgrades 5.  This planet uses 2 extractor control units.   I barely move the extractor pins, and even less rarely tweak the number of heads on each ECU.  It is amongst my best ISK/active hour planets, but certainly not best ISK per month.  http://foo-eve.blogspot.com/2015/02/single-planet-pi_6.html

Backed by comments from other pilots in corp playing with the difference between a 10 extractor head ECU with 24 and 48 hour extraction cycles, the 24 hour cycle earns nearly twice a 2 daily extraction cycle, but take much longer to manage as it quickly causes local depletion .

Logging in

If you have regular logon/off times, another time saving item is to have extraction cycles slightly less than the period between logons.  That is, if you log on at 7pm every night (for either 1 or 2 day cycles), set your extraction timer for 23.5 or 47 hours.  Otherwise you will find yourself slowly logging in later and later as you either have to cancel the last few minutes of the cycle (taking time and wasting the cycle), or be watching countdown timers as you wait those last 5 minutes for the timer to finish.


I run PI on all 3 pilots on each account.  One of the time consuming parts of this process is logging in.  Watch for http://community.eveonline.com/news/dev-blogs/download-on-demand-is-coming-to-singularity/ .  This, combined with a separate launcher per account will save time for swapping between pilots on an account.

Once download on demand is live, I will be tweaking my current login setup to use download on demand for patching multiple installations.

Flying time

Only fly when you have to.  Your customs office can hold much more than a launchpad or storage unit.  The majority of my planets are Extract P1 + Import P1 to make P2.  My flying cycle is to
  • Wait until the customs office is full, plus a nearly full launchpad on planet.  This will generally consist of the relevant P2, plus some surplus extracted and refined P1
  • Haul out about 75K units of the Import P1.
  • Warp to customs office (generally via an offgrid tac to misdirect anyone cloaked but following too closely).
  • Swap the customs office contents between the Epithal and customs office.  Export of planet the last load in the lauchpad and put that (largely) into the Epithal as well.  This takes longer than the shortest possible time at a customs office, but so far has been safe enough (especially combined with the misdirect warp above).

Hauling to market

Some pilots haul their own PI.  Other pilots take a smaller price and sell it in the wormhole itself.  I don't feel comfortable in highsec with an Epithal full of PI.  I feel much more comfortable in highsec with a freighter (Red Frog is easier), Orca or deep space transport.

Optimisation

PI has several choices to make between optimising for ISK per active hour, vs ISK per elapsed hour.   It is another element of Eve that there is no single 'right' answer.

One of the Foo Corp pilots runs single day cycles, on all 3 accounts, and is plexing his account plus has ISK for shiny toys, despite being relatively new to Eve.

Another Foo Corp pilot runs only single planet PI and has a much higher ISK/active hour.  He however spends more time shooting red crosses for the rest of his ISK.

Work out how much time you are willing to invest in PI, and how many pilots you are willing to do it with.  Then take your earned ISK and do something with it.

Monday, 2 March 2015

Market spreadsheets in space

Eve is sometimes known by another name : Spreadsheets in space.

I have one spreadsheet in particular that is 'way too big', yet at the same time I want more.

I use this spreadsheet to primarily work out what is not being sold by anyone, then provide a suggestion as to where I might buy it in turn.

Screenshot of spreadsheet
 
It shows the buy/sell price in 5 trade hub systems (Jita, Amarr, Dodixie, Hek, Rens), and 1 region (The Forge).  It then shows the full set of data as available from the Eve Central API for yet another system.  I have chosen Sujarento, Sugar Kyle's hub

The item choices are based on what can be used (rather than items consumed in manufacture).  It (tries to) list T1, best named meta, and T2 modules, plus faction ammo.  The item list is a little out of date, and is missing the most recent changes.  I used the static data (in turn downloaded from https://www.fuzzwork.co.uk/dump/ ) and some SQL to build this list.

Use either Chrome or Firefox.  It will break the in game browser, Internet Explorer and occasionally Opera.

Restart your browser may help.  It takes minutes to load, and then I added additional delays to avoid google docs crashing.

When you first open it, it will complain that it is breaking, and then slowly populate data.  At first, some fields populate "#NAME?" and then "Loading..."  and then you wait a few minutes and data will start to appear in sets

I am also playing 'whack-a-mole' with google, working around limitations that google add to their services.  The latest of which is to add a 1 second delay to the googlescript, for every 50 prices in a 'set'.  Sometimes, it fails to load, even for me.  As such, the second tab is snapshot of values in case it chooses to decline to load.
 
Now that I have given the caveats, the spreadsheet itself is
https://docs.google.com/spreadsheets/d/1qL_ofk-QRQCFt2zKTTEXSi6oY4n1gtZX6Mojxxtgs-4/edit?usp=sharing

Please feel free to make a copy of this spreadsheet and tweak to your hearts content.

I will be watching for both comments and pageviews on this post.  If it is 'interesting' I intend to delve into some of the technicalities of how I put this together.

Edit: this is continued in http://foo-eve.blogspot.com/2015/03/google-docs-whack-mole-continued-plus.html

Friday, 6 February 2015

Single planet pi

I am reevaluating single planet PI. 

For the record, I don't like single planet PI.  It is wasteful of CPU and powergrid; either by running 2 extractor control units, or by running additional storage and swapping ECU between them.  It has also historically been a profit destroyer, that is it used to consume more ISK than it created. That is, previously you could sell the mats for more than the final product.
 http://foo-eve.blogspot.com.au/2014/02/single-planet-pi-manufacturing-bad.html presents some alternatives.

All of the above said, what single planet PI is good for is no fuss manufacture of P2 or P3 items.  Also, at the moment at least, conventional knowledge that single planet PI destroys value may be wrong.

I have created a page on my PI spreadsheet for single planet PI.

https://docs.google.com/spreadsheets/d/1lXM8PqU0Tn4EJJ2xRuI7uo55IrZ7MKWJidK9T_bA9L4/edit#gid=964439998





My spreadsheets are provided as is, where is.  Please note that this page is still considered 'draft' and may have errors.  But it has planet types, and what can be extracted and manufactured on a single planet.  As with most of my spreadsheets, it is based around 4% PI tax (being what a Foo corp charges by default).

Column A lists planet types and what can be made on your typical planet without importing. Column C lists the average sell prices across 4 trade hubs.  Columns D and E refer to the value made or destroyed by turning your items into the relevant P2 instead of selling parts.

For example a Barren planet Biocells manufacture on that screenshot (late January 2015) show that not only are the best 'average sell', but also have the best earnings over the component parts, stating that despite my reservations, maybe some forms of single planet PI may be profitable.    What is most profitable to make in the future will change.

Polytextiles are still truly aweful.  If you need polytextiles for other items, consider importing them and let someone else destroy their own ISK.

2 Extractor control heads still are very expensive (Power and CPU) to run.  I still don't like it, but can see value some pilots who are paying high import/output taxes, or who simply don't want to be in system or fiddle with their PI much.

Tuesday, 3 February 2015

Changing PI prices

I am a moderately happy PI farmer.

I have been sitting on stacks of PI scattered around highsec stations as various wormholes allow.  This is generally not something I would consider smart, but events have favoured me.

The following graphs PI prices over the last 3 months, taken from http://eve-marketdata.com

Autotrophs
Industrial Fibers
Polyaramids

Broadcast Node

High-tech Transimtters

Many PI products are showing a roughly 20% price increase since mid to late December.

I can think of 2 contributing factors to the upward pricing that occurred at this time: the jump (freighter) nerf limiting goods from nullsec; and the change to how google docs based price importing works breaking many spreadsheets.

I am somewhat pleasantly surprised as I expected  the lower costs in highsec with player owned customs offices enabling lower PI costs in highsec to counter this, but the graphs above (derived from prices in game) reflect reality rather than expectations.

Sunday, 1 February 2015

Techical update on Google docs & Eve Central

Google docs and the Eve central API for data has not been playing nicely.

I wrote up my implementation of a solution based on Steve Ronuken's google script fix, that works moderately well.

https://docs.google.com/spreadsheets/d/1lXM8PqU0Tn4EJJ2xRuI7uo55IrZ7MKWJidK9T_bA9L4/edit#gid=0

http://foo-eve.blogspot.com.au/2014/12/pi-spreadsheet-working-again.html

The problem I had is that Google was caching data for far too long, and I missed some price changing trends.

The solution is to use a ?cachebuster=<value> parameter when you want a new call.

From the Eve Central API, apparently we are allowed to pull the same data every 5 minutes.  ( https://groups.google.com/forum/#!topic/eve-central/b5FjssiqFIQ ).

For my purposes, I don't care about completely current pricing, and price refreshing makes my spreadsheet unusable for about 30 seconds while it happens.  My current solution is to pass the day of the month as the cachebuster parameter, that is I request different data once per 24 hours.

I will be keeping a bit more of a closer eye on this as PI prices have moved around a bit over the last few weeks (post scheduled for Tuesday my time).