Standalone exe EIO

I'm slowly but surely coming to grips with the calculated fields and form design in Access.  Quite a bit of progress has been made where I can safely say there will be a beta version by the end of the month.

I can't promise there will be prices or the full functionality that currently exists in the Excel version, but it will give you the material requirements for multiple items at your own ME and skill levels.

That alone will be a milestone - after that I could start on incorporating prices and giving profit/loss estimates but only if it's called for.

The Combined Asset EIO file will be made available upon request, so if you want it just leave a post with your in game name, or send an eve mail to me, Sidrat Flush and I'll make it available.

In the meantime, thank you.

Sidrat Flush.

Corporate and Personal Inventory

It's been a great Christmas and New Year, but time to get back on the trading treadmill of Eve Online.

To this end, I am now in a position to integrate corporate assets in to the EIO suite of excel workbooks.

This is great news for me as I can now start using offices.  Of course it still uses the xml files generated by Eve HQ, this is for the sake of simplicity.

I expect to have both Refinery and Builder updated by 11th January 2013.

Planetary Interaction

Okay, after creating a PI workbook and entering the numbers required to produce a small pos tower the results I got was strange.  Due to the linear scaling nature of PI it's not very useful to know you'll need a few hundred thousand units of a P0 item to produce enough P4's to cook it together in to a Pos Tower.

So instead I offer this link - Eve_PI_Diagrams_v1_4.pdf

It's an awesome layout, very useful and made setting up a pos fuel PI chain a doddle.  Please go and check it out.

Power of Advertising and Feedback

If you've come here from http://www.wulfbrothers.blogspot.co.uk/ Welcome and thank you for clicking the advert.

If you've used Eve Industrial Organiser, let me know what you think.  If you haven't used it and won't use it, leave a comment.

Wulf Brother Industries is an industrial corp run by Kiger Wulf who is very new to the production side of Eve Online and blogs about his adventures and thoughts.  He's doing quite well and can only do better, and he can write a blog better than I can.

To the Database

Which is where I sign off until next time.

I enjoy creating EIO to keep up with the needs of industrialists everywhere and in order to make it better, I really need feedback.  Without comments I am limited to my own ideas.  I am open to any suggestions that makes the life of the industrialist and self taught Office Hobbyist easier.

EIO Public version 2 release

It is with great pride that I present to you version 2 of EIO incorporating the all new EIO: Builder.

For more information and a graphic overview please see EIO Overview

You can download the winrar file at eve-files from here, just click the orange link underneath the large Download Now button as it's not a torrent file.

EIO: Public version 2 contains the previously released EIO: Refinery and new xml sheets that you generate using Eve HQ.

These are NOT essential, they just make your life easier by automatically downloading your assets, character sheet details and the regional market average prices.

The files contained in the winrar file will be used, but it represent old data of mine, and I know very few people who want to manually update asset inventory on a regular basis.

Good luck all, any questions, refer to the guide - if it's not clear enough let me know.

Progress Update

I've produced a How To picture guide explaining how to update the Market prices in EIO: Char Refinery and all other future editions following feedback in the Eve Online Forum thread.

The EIO: Char Builder is now at a standard where I can offer those who wish to test and provide feedback the opportunity to do so by requesting the link from the forum thread above.  I especially need people who produce boosters to compare the results and ensure 100% accuracy, however all who promise to provide feedback will be more than welcome.

Let me leave you with a screenshot of the WiP.

A few things to do and tidy up, but beautiful already.

Zeros in spreadsheets are ugly - Nested IF() Statements

So I'm sure you're all aware of the formula's in my existing and previous spreadsheets has featured a lot of nested IF() statements.  The reason for them is to hide zero's where ever they may cause eye strain.

I hate zeros on a spreadsheet.

They are not needed, they tell you nothing a blank cell can't.

Here's a simple statement to hide a zero.

If(A1=0,"","FOOD!!")
This will bring a blank cell if the named cell A1 has a zero in it, or is blank, otherwise it will print the word "FOOD!!" where ever you type the formulae.  It didn't have to be blank of course, you could add "Get Some Food" between the quotation marks and it would tell you to do that instead, so that's a simple one.  Things have gotten more interesting lately, take a look at the EIO: Refinery sheet for some extreme examples.

So I've been busy today focusing on the Time and Building formulae both for Raw and Extra materials, and now I've arrived at the stage where I need to add up the possible two figures.

But.

You can't add text and a number together to get a numerical result.  It's just not happening.

That drives even more nested if() statements.

Here's the flow chart I'm about to use to help follow the logic path.  No apologies made about my handwriting skills, it's a sketch not a calligraphy art project.

Believe it or not, I've never tried this method before so I hope it works.  T = True, F=False.

edit: Works like a charm!