open All Channels
seplocked Science and Industry
blankseplocked Spreadsheet Help (for ME levels)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Yasuki Q'olat
Posted - 2011.07.31 06:10:00 - [1]
 

I am working on a spreadsheet for my manufacturing, and ran into a bit of a snag. When I first started the spreadsheet I simply used numbers that were reflected on the blueprints I currently owned, and changed them if the ME levels changed. This was fine when I had a small handful of BPs, but as my collection has grown, the work required to maintain it has also grown. I thought that I would add a formula to calculate the materials for me based on the ME level that I punched in for the BP.

The math I found for calculating ME levels was this: material = perfect material * (1 + 0.1 / (ME + 1))
I started with the numbers on BPOs at 0ME since I couldn't figure out a quick and easy way to start with the perfect amounts.
If BPO is the amount on a BP at 0 ME and ME is the level ME you've gotten it to.
My version looked like this in the spreadsheet:
(.90* BPO)+(BPO)*(.1/(ME+1))

Basically that's 90% of the printed materials + the inefficiency of the ME level. The problem is that it works fine with clean easy numbers - like 100 or 1000. When I start using real numbers, the results are off. Not so far off that I feel I'm completely wrong, but far enough off that I'm not willing to use them to base my profit numbers/shopping list on them.

I'm guessing it is either a bracketing error on my part, or a rounding error that gets magnified when it is multiplied. I know that there are probably other spreadsheets out there that I could download that do this, but I like to use my own so that I know all the formulae and so that I can organize the data in ways that make sense to me. Is there anyone who is better than me at this sort of thing who can give me a quick tip?

Dedaf
Gallente
United Brothers Of Eve
S E D I T I O N
Posted - 2011.07.31 07:41:00 - [2]
 

Hi, i have build my own sheet aswell, so i know this problem. The best way is of cause to get one of the database dump files that are released ones in a wail.
But i run in to this problem when there are just a few new BPO released, then of cause i don't want to redo my entire database.
So here is what i to.
I have perfect production skills, so the only waist i have is the ME. What i do to find the perfect amount is like you do here. but instead of using .90 you should be using 0.90909090909090 Smile and whats even more important is that you round the number before you do any other calculation with the material amount. This will make you hit the correct number.

Good luck

Akita T
Caldari Navy Volunteer Task Force
Posted - 2011.07.31 13:51:00 - [3]
 

Edited by: Akita T on 31/07/2011 13:51:39

Take the datadumps, they list "perfect build" numbers from the start.
If you can't use that, try the EVE-HQ access database, should be easier to shove into Excel.

If you don't want to do either, you can try doing round(ME0quantity/1.1,0) instead of ME0Quantity*0.9, it won't be perfect but close enough.


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only