| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sabahl
   |
Posted - 2003.11.11 17:57:00 -
[1]
Edited by: Sabahl on 11/11/2003 18:02:04
About time I made this publicly available.
I made this spreadsheet to assist in a large, corporate sales venture. It contains the capability to automatically calculate the mineral requirements for all blueprints for which it has data, taking into account the Miner Efficiency research level of the BP and the Production Efficiency level of the manufacturer. It will calculate the total cost of manufacture given a series of base mineral values (and it will even happily accept your decimal points, Morkt). And it will also tell you how many more mienrals you require for a specific set of builds should you have some minerals in stock.
There is a lot more to the spreadsheet, geared towards corporate manufacturing functions. If properly used it will allow the apportionment of profits from item sales to anyone who should receive a portion of cash so raised. It will allow the tracking of all sales and the extraction of total sales values on a per-person basis. I will not go into detail as to how this is achieved or how it needs to be set up but raw data is included which may be of some use in showing how it operates to those who are interested.
If anyone has any specific requests for additional functionality then I may include it if reimbursed for my time. Think of this as ISK shareware. You're free to use and change it for your own purposes but if you wish to make any changes for public consumption they are to be sent to me so that I can update the master copy. I spent a fair whack of time on this baby and don't want others screwing it up too badly.
The file can be found here. Enjoy.
If anyone wishes to assist in making this absolutely indispensible then what I need are the raw mineral requirements for the missing blueprints. There are rather a lot of them so if you want to you can post them up here and I will see about including them into the sheet. What is needed are the mineral requirements, the wastage amounts and the current ME level oif the blueprints. The required values for the spreadsheet can be extrapolated from this information.
Have fun.
Sabahl
|
Beldaws
|
Posted - 2003.11.11 19:18:00 -
[2]
Edited by: Beldaws on 11/11/2003 19:30:30
Thanks for the great spreadsheet!!
Have the base mineral needs on blueprints changed?
You're base minerals list doesn't match what's the blueprint calculator says.
http://www.crimsonautograph.com/eve/blueprints/blueprint_calculator.php
|
Sabahl
|
Posted - 2003.11.11 20:00:00 -
[3]
So called "base minerals" hgave changed on some items. However, why would you want them, anyway? To calculate the mineral requirements for a given item all you do is locate the item in the blueprint section, update the Me level with the ME level of the blueprint you possess, enter your PE level on the main page and select the item in the item list box.
Takes a little getting used to but once you work it out you'll never need to know (or want to know) the base mineral requirements again.
I am going to upload a replacement, virgin version of the spreadsheet right now with all the ME levels set to zero. Just enter the ME level you need into the relevent blueprint and Bob's your maiden aunty.
PS Of course, some mienral values may be erroneous. Please post errata to this thread.
|
Sabahl
|
Posted - 2003.11.11 20:14:00 -
[4]
Having had a second look at the Crimson Autograph site I believe what you are looking for is under the Base Mienral Needs in the chart labelled "The Effect of Research on Mineral Efficiency". It should be relatively safe to copy the four decimal placed value into the spreadsheet and come up with exactly the same numbers. I have coloured in the area you need to transplant the values within the Blueprints section so as tomake it easier.
|
Badger
|
Posted - 2003.11.11 20:29:00 -
[5]
You are the answer to my prayers. I am not literate with excel and just enough to be dangerous. Two things I can see atm:
1. How do I add or delete the entries to "ownership" as I would like to delete the corp names there and add my own.
2. You have a block for manufacturers charge. I am going to change that name to MSRP price. what is the basic formula so that I can take base cost (after ME and PE) totals and add a percentage. Ie:
ship A total mineral cost = 5,000,000
mark up % = 25%
then block "Retail" will show 6,250,000
I do not want this percentage across the board, but selective so that I can plug in a percentage that I need.
I will start getting you bp mineral req info soon.
Regards,
Badger
Admiral of Ethics
Hadean Drive Yards
"Fear shouldn't hurt, just never put your hand into a bag of angr |
Sabahl
|
Posted - 2003.11.11 20:50:00 -
[6]
 Quote:
1. How do I add or delete the entries to "ownership" as I would like to delete the corp names there and add my own.
The ownership lost list is actually taken from the Current Creditors list, as are a number of other values in the spreadsheet. So if you wish to put in your own corps' names you need to enter them into the Current Creditors area. However, this may require some specfic tweaking to get it exactly as you require for your own corporation as the spreadsheet was written so as to skim a specific amount of handling tax off of each transaction and apportion it to the corporation it was written for. So I say again, if you require detailed rejigging of the sheet I'll happily write your requirements for you...for a price. 
Quote:
2. You have a block for manufacturers charge. I am going to change that name to MSRP price. what is the basic formula so that I can take base cost (after ME and PE) totals and add a percentage.
Actually, the Manufacturing Charge was nver used and is a dead field. All post-sales calculations are instead organisaed on the Sales Ledger page. If you want to add a fixed percentage to every item it is possible to do but would require another lookup function to be entered onto the front-page calculation for every item. It is doable but would require a slight rewrite. Again, my rates are very reasonable. 
Actually, it is a good idea though and one which could be incorporated relatively easily. I may have a quick tweak now and put it in anyway.
|
Sabahl
|
Posted - 2003.11.11 21:07:00 -
[7]
Edited by: Sabahl on 11/11/2003 21:17:16
It turns out I had half completed the lookup anyway. I've now added the manufacturing percentage markup to the spreadsheet. Just enter the value in the relevent row in the blueprints page. So if you want to add a 25% markup to a Tempest, for instance, you would put 25 into the box marked "Manufacturing charge (%)" under the Tempest values and the new price would be reflected in the final value on the front page. Hope this is what you wanted.
|
Badger
|
Posted - 2003.11.12 04:01:00 -
[8]
Calculation does not carry over, no change in price noted.
B
Badger
Admiral of Ethics
Hadean Drive Yards
"Fear shouldn't hurt, just never put your hand into a bag of angr |
Ayar Cachi
|
Posted - 2003.11.12 05:05:00 -
[9]
Very nice, Sabahl. Just coverted mine to your better one.
Issues (maybe):
1) Anyone notice the drone-mineral-cost at crimson is a lot high? Pye seems messed up for most drones.
2) In your spreadsheet, defenders require Zyd. Mine isn't asking for zyd. What's up?
3) Need unit-cost info in there (impt for miserly missile users :) I added the batch sizes above the base info and a unit-cost calc.
Thanks!
|
Sabahl
|
Posted - 2003.11.12 14:00:00 -
[10]
Quote:
Calculation does not carry over, no change in price noted.
Useless information. Need specific cell/page references. Check front page.
Quote:
2) In your spreadsheet, defenders require Zyd. Mine isn't asking for zyd. What's up?
Defenders required Zydrine at the game's launch. They have probably been tweaked since then and the mineral reqs altered. Enter the correct values for base mienrals and all should be well.
|
what
|
Posted - 2003.11.12 18:52:00 -
[11]
The Crimson Autograph has many errors as it no longer seems to be updated.
|
Badger
|
Posted - 2003.11.12 20:52:00 -
[12]
Sorry about the lack of info.
specifically the manufacture percentage. I plug the percentage in and there was no reflected change to cost in the block above.
B
Badger
Admiral of Ethics
Hadean Drive Yards
"Fear shouldn't hurt, just never put your hand into a bag of angr |
Sabahl
|
Posted - 2003.11.12 22:50:00 -
[13]
Quote:
Sorry about the lack of info.
specifically the manufacture percentage. I plug the percentage in and there was no reflected change to cost in the block above.
B
That is correct. Because that value needs to remain constant as it is the value from which all other calculations are based. The change you are looking for is reflected on the first page which should be used for all your calculations. The way the spreadsheet is configured means that the blueprint page should have it's data changed as infrequently as possible. All monetary calculations for your purposes should be made using the tables on the front page instead.
|
Badger
|
Posted - 2003.11.13 01:55:00 -
[14]
got it, thankyou for the hard work you put into this.
B
Badger
Admiral of Ethics
Hadean Drive Yards
"Fear shouldn't hurt, just never put your hand into a bag of angr |
BigBanjo
|
Posted - 2003.11.14 19:59:00 -
[15]
Thank you for your effort. Finally this excel
noob dont need to use only pen, calculator and
massive amouths of paper
Really great work. |
ZhGCAT
|
Posted - 2003.11.15 10:32:00 -
[16]
Excellent work!
Small point ... L proj ammo BP shows no requirement for rarer mins so how do I change your spread sheet?
|
ZhGCAT
|
Posted - 2003.11.15 10:33:00 -
[17]
Ignore that!! Just looked closer! DOH!! 
|
Rotti
|
Posted - 2003.11.17 08:02:00 -
[18]
Excellent work I find this really usefull, noobs builder
|
Bane Sellante
|
Posted - 2003.11.17 16:56:00 -
[19]
Excellent I like it.
Silly question but to get the base reqs for the missing BP's couldnt you just log on to Chaos and get a friendly Bug Hunter to spawn them in your Hanger??
-----------------------
Cold Fusion Inc. Website |
Sabahl
|
Posted - 2003.11.18 13:12:00 -
[20]
Theoretically, yes, but that would require a lot of work and I don't fancy doing it. The important stuff are the calcs, the lookups and the structure of the tables. the raw data you can enter yourselves.
As I get more information on BP requirements I my update the spreadsheet but I have no great desire to do that right now. The next major update will probably be when Tech 2 comes in as that will probably require a major rewrite of the tables.
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |