These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

managing my money flow.
Author
Previous Topic Next Topic
Kalipoli
State War Academy
Caldari State
#1 - 2012-03-21 17:05:29 UTC
Are there any good programs or methods that players have found or created to help manage the isk flow of a decent sized mining/manufacturing/sales entity.

How can i make the issue of isk flow easy. for instance i want to make sure that after a product is sold that the profit is put into profits and the mineral cost for manufacturing is put back into a mineral buy wallet. Im finding this difficult to keep organized when it involves almost 400 different products and our corp mineral buy prices are updated bi-weekly. The changing mineral prices is one of the biggest things as when i manufacture something sometimes it will take more than 2 weeks to manufacture and sell and in order to get the appropriate margins I have to look at what i paid for the minerals when i started the job to allocate the proper profit and cost back into their respective wallets. Im also wondering because i dont want to cheat my investors out of any isk.

Is my only real viable options to create my own program or just dredge through the spreadsheets as always?
Skorpynekomimi
#2 - 2012-03-21 17:26:27 UTC
Improve your spreadsheeting!

Save a copy for each run, delete when finished. Named properly, they will also be searchable.

Economic PVP
Kalipoli
State War Academy
Caldari State
#3 - 2012-03-21 17:51:17 UTC
Hahaha well don't i feel like a dumb#%^ you just blew my mind and made me feel like a dumbass.

It never dawned on me to do more than one spreadsheet.

Zathryon
Amarr General Drilling and Construction
#4 - 2012-03-21 19:03:10 UTC
spreadsheets are great, I also use Eve mentat. works great for my purposes. doesnt really work in every situation but it may be worth checking out.
Tau Cabalander
Retirement Retreat
Working Stiffs
#5 - 2012-03-21 19:13:58 UTC
I really didn't use spreadsheets at all until I started playin' EVE Oops

I use the free OpenOffice which I find gets the job done for me.
Kalipoli
State War Academy
Caldari State
#6 - 2012-03-21 20:57:03 UTC
Just have to mention. OpenOffice.org is great, but LibreOffice is now the more universally supported ( alot of linux distros are going to libreoffice.org) so just a warning that Openoffice.org may go away but it is not without a very suitable replacement.

I havent switched to Libreoffice yet but i use openoffice daily at my work for creating very clean PDF document's. There is an adobe logo in openoffice that allows you to export directly to pdf without having to have adobe acrobat or any other pdf creation software, it is just built into openoffice and Libreoffice and is more useful than you would expect.

But back to the spreadsheets, thank you for the advice because you literally made my day with the most simple suggestion, i just never thought of setting up simple spreadsheets for everything instead of having one big confusing hard to manage spreadsheet.

thank you all, and wow you never can underestimate the power of a spreadsheet in Eve.

Thank you for your input everyone.

spreadsheets seem to be the difference between success or failure in a big way.
Styth spiting
Brutor Tribe
Minmatar Republic
#7 - 2012-03-22 06:49:06 UTC
I use isk per hour http://sourceforge.net/projects/eveiph/

its actually pretty nice but takes quite a while to setup. I don't use it for the hourly side (everything comes up as a negative isk amount for me heh). But it lets you for example add in all your bpo's with their me / pe + all your personal skills and will determine based on jita prices the total cost / time and possible profit from manufacturing.

It lets you add all the items to a shopping list you need to buy etc.

You will still need to copy/paste data into a spread sheet to keep track of but its a good tool to use to collect the data. For example here is the data that I was able to copy to clipboard for mining drones I:

Component Material List for 1 Units of 'Mining Drone I Blueprint' (ME: 0)

Material - Quantity
Tritanium - 83
Nocxium - 14
Isogen - 5
Megacyte - 1

Total Volume of Materials: 1.03 m3
Total Cost of Materials: 9,891.71 ISK

It might be worth checking out. it wont meet your needs, but it should help out getting there.
Maria Yumeno
Venomous Cloud
Scorned Syndicate
#8 - 2012-03-22 07:54:29 UTC
Run everything out of a single wallet division and pay monthly dividends.

Set a base value of isk you would like in the wallet at all times, then anything over this can be split into dividends.

That is the easiest and best way to keep your sanity .
Skorpynekomimi
#9 - 2012-03-22 11:06:23 UTC
Kalipoli wrote:
Hahaha well don't i feel like a dumb#%^ you just blew my mind and made me feel like a dumbass.

It never dawned on me to do more than one spreadsheet.



Nothing stopping you, other than drive space, after all...

And this goes to show I DIDN'T waste two years on A-level computing.

Economic PVP
Styth spiting
Brutor Tribe
Minmatar Republic
#10 - 2012-03-22 12:08:13 UTC
Skorpynekomimi wrote:
Kalipoli wrote:
Hahaha well don't i feel like a dumb#%^ you just blew my mind and made me feel like a dumbass.

It never dawned on me to do more than one spreadsheet.



Nothing stopping you, other than drive space, after all...

And this goes to show I DIDN'T waste two years on A-level computing.



Another option (if this is available in openoffice) I know excel allows you to add / setup different worksheets (the tabs at the bottom of the page). Keep 1 master excel spreadsheet that you use to duplicate. And then whenever you have a new spreadsheet you need to duplicate just copy/paste your master into the new tab and label it accordingly.

This way you have 1 file for each specific spreadsheet, while each worksheet can be used as your "copies" or however you want to refer to it.
Alvar Kesh
Ealurian Shipyards
#11 - 2012-03-22 13:56:00 UTC
I use google sheets, its just like OpenOffice/LibreOffice, and works great in the ingame browser too.

Ealurian Shipyards' BPC shop