| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Dalekplunger Slick
   |
Posted - 2005.11.30 19:54:00 -
[1]
Everyone has one. At first I thought IÆd just make one to keep track of my mineral inventory... And then I added construction costs... And then current market values... And then a ôproject templateö that lets me track expected profit of a proposed construction run, (after fees, taxes, and start-up costs of course)... And then I added graphs and pie charts to track return on investment.
And from there it got a little out of control. 
What kind of cool things do you have in your spreadsheets? What kind of formulas have you put together to manage your personal little empire? The neatest one IÆm working on right now is a way to measure demand for large inventories of ammo.
It goes something like this:
(1 / (number of units for sale / an arbitrary ôon-hand inventoryö number that I want to maintain)) * (number of units sold / days since the entire stock went on sale)
IÆm debating if I should add a square root in there somewhere to smooth out the edges. The objective is to have a demand ôscoreö that is penalized for excessive on-hand inventory and improved by good average daily sales.
IÆm starting to get the feeling that this is a sickness. 
|
Minkus
|
Posted - 2005.12.01 02:02:00 -
[2]
Sounds like a spreadsheet I'd like to have :)
|
Sonreir
|
Posted - 2005.12.01 09:06:00 -
[3]
Spreadsheets bug me. That's why I wrote my own program instead. :D
|
Bombaman
|
Posted - 2005.12.01 11:59:00 -
[4]
EVE-Online : Excel Addition \o/
ive got ~40 Spreadsheets, ranging from Mining Stats, POS Costs, Mineral Prices, Hauling Capcaitys, through to Compression Stats, Production and Reactions
|
Feta Solamnia
|
Posted - 2005.12.01 13:33:00 -
[5]
excel sheets are scary, but can be total lifesavers sometimes.
I've met some people that dropped my calculation times from a few hours down to 5 minutes...
 Originally by: Oveur
I have access to all market data. Believe me, we have not reached anything close to deflation yet.
|
George Mead
|
Posted - 2005.12.01 15:00:00 -
[6]
Im kind of new to the manufacturing scene and am interested in using spreadsheets to help me out with production costs etc. Could someone give me a few pointer on how to make one or is there any currently on the internet that i could "borrow"?
|
Dalekplunger Slick
|
Posted - 2005.12.01 15:29:00 -
[7]
Originally by: George Mead
Im kind of new to the manufacturing scene and am interested in using spreadsheets to help me out with production costs etc. Could someone give me a few pointer on how to make one or is there any currently on the internet that i could "borrow"?
The biggest pointer I can give is to avoid repeating information. For example, I have one sheet dedicated to my mineral inventories throughout the galaxy. When those inventories change, I just update that sheet and all of my construction sheets and formulas that reference those values are correctly updated. I have another sheet just for market prices by region. Same deal there.
The simplest way to get started is with this basic formula:
-Break out your construction costs for any given blueprint by mineral.
-Determine how much those minerals cost on the market, (even if you are mining them yourself).
-Determine a sale price for your finished product.
-Add up all of the mineral costs and subtract that from the sale price of the finished product.
-If this number is positive, you can achieve a ROMI, or Return On Mineral Investment. This means instead of just selling off the minerals you can construct something with those minerals, sell that item, and make more money.
-If this number is negative, you will make more money by selling the minerals on the market instead of trying to build anything.
Applying this formula to a large group of different ôflavoredö blueprints and graphing the ROMI will show you what flavors will yield better profits. You can then plan this into future construction projects. For example, medium iridium charge may have a ROMI of 80% while large plutonium may only have a ROMI of 30%. This means if I put 2 million isk worth of minerals into medium iridium I will get 3.6 million isk back. If I put this same 2 million isk into large plutonium I will only get 2.6 million isk back.
ROMI isnÆt the whole story, however. Your spreadsheet should also take in to account other costs like brokers fees, sales tax, lab and factory costs, and initial blueprint investments. If you know all of your costs you are in a very good position to set a fair and profitable price.
I donÆt know how helpful getting someone elseÆs sheet would be. I think they are highly personalized to style, industry, and slang. The layout that makes perfect sense to me would take someone a month to train and learn.
|
robacz
|
Posted - 2005.12.01 15:31:00 -
[8]
Some calculation spreasheets are here: http://www.evehelp.myby.co.uk/
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |