Eve Excel Addin and the transformation of by Eve business

The summary of the below is that the use of the Eve Excel Addin is transforming my business activities: it is now quicker to update my orders each night; it is quicker to find new items to sell; and 4 characters are about to be freed up to do something else.

How i used to operate

Each of my 6 omega accounts has one character in Jita that buys the items from Sell Orders on the Jita market to be couriered out the other two characters that sit in Trade Hubs to put these items up as Sell Orders.

I use third party couriers.

The Daily Mechanics of all that

I had got the mechanics of this down to a fine art.  Each of the two Selling characters had the items they were selling in their quickbar and each night i would run through these items and update any where they had been undercut by competition and move any that had been sold into another folder on the quickbar.

For the items sold i would check via EveTycoon if it was profitable to buy them from Sell Orders in Jita to relist and I would also cycle through other items that i had listed in other folders on the quickbar to see if they would be profitable to be sold using EveTycoon.

The Jita Character would then buy everything in that folder to be couriered.

That all took me 45 minutes to cycle through half my business and the next night i would cycle through the the other half.

And a lot of using arrow keys and clicking.

And so it went on

How i operate now

All of that is gone.

I have a number of spreadsheets which almost all use the the Excel Addin to do all that, and more.

The "Sales Orders to update" spreadsheet: by being able to list what sell orders a character has up and by being able to compare to the minimum selling price in the Region i can now instantly get a list of sell orders that have been undercut.  I can then copy that list to the quickbar and quickly cycle through them and update the prices.

The "replace and add more" spreadsheet: by being able to list what items have been sold by my character i can determine if it is profitable to buy them again from Jita Sell Orders to sell again at the sales hub.  I can also look at a list of around 2000 items to see if it is profitable to also buy from Jita Sell Orders to sell at the sales hub.  I just keep a temporary list of items on a spreadsheet that i can then use the simple mechanic of copying from spreadsheet to Market Quickbar to allow one character in Jita to do all the buying.

The "put up the sell orders" spreadsheet: by listing what i have bought recently and increasing the purchase price by 4/3 (that gives me the sales price) i can instantly see what price i need to list an item for sale that has been couriered from Jita.

The "monitoring the skill farm" spreadsheet: for all my characters involved in skill farming i can see where all my Skill Extractors and Skill Injectors are located + therefore how many of each i have  + which skill injector Sell Orders have been undercut + last few days of Skill Injector sales + Skill queues so that i can tell who needs skills points extracted.

This means two things

Firstly, i can go through my entire business in 30-45 minutes.  It is fast and accurate.

Secondly, because i am not relying on the Quickbar in the client which is shared by characters in the same account - i don't therefore need a buyer in Jita for every account.  I just need one buyer in Jita.  Therefore, this will free up 4 high skilled characters in Jita to go elsewhere.

. . . . and i suspect they will start in the Manufacturing business.