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.
 

Google Spreadsheet Equation Question.
Author
Previous Topic Next Topic
Optimus Ormand
Optimus Industries
#1 - 2013-04-12 01:54:11 UTC
I'm trying to set up my manufacturing spreadsheet so that I can put in a BPO with its base stats (no ML and PL), and then having a cell for ML, PL, and my PE level.

I found this equation in another post:

Total Material = ROUND(Base Material * (1.25 + Base Waste / (1 + Material Level) - Production Efficiency Skill * 0.05))

Whenever I use that as an equation, the figure is off when compared to EVE isk per hour.

Also, I make sure not to include the extra material if there is any.

On top of that equation, what would be the equation for PL?

Thanks a bunch,

Optimus
Rutger Janssen
Chanuur
The Initiative.
#2 - 2013-04-12 06:45:27 UTC  |  Edited by: Rutger Janssen
These formulas seem to be quite accurate: http://wiki.eve-id.net/Equations

In my sheets I leave out Production efficiency part, if you don't have it at 5, you're doing something wrong :)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2013-04-12 09:22:34 UTC
http://www.fuzzwork.co.uk/2012/10/24/eve-sde-sql-blueprint-details/ might be of interest. It's sql specific, but might be useful.


The main question is:
What are you using as the base material?

If it's not the details out of the SDE, but instead out of the client, your numbers will be wrong, as the numbers out of the client already have waste added. In addition, Extra Materials don't get waste from ME, and only get waste from Production efficiency, if they're also in the base materials.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Optimus Ormand
Optimus Industries
#4 - 2013-04-12 21:57:13 UTC
Steve Ronuken wrote:
http://www.fuzzwork.co.uk/2012/10/24/eve-sde-sql-blueprint-details/ might be of interest. It's sql specific, but might be useful.


The main question is:
What are you using as the base material?

If it's not the details out of the SDE, but instead out of the client, your numbers will be wrong, as the numbers out of the client already have waste added. In addition, Extra Materials don't get waste from ME, and only get waste from Production efficiency, if they're also in the base materials.



I was using what the in game client said for base material. That was the problem! Thanks so much for that.



What's the equation to figure out how much each Production levels helps for a BPO?
Optimus Ormand
Optimus Industries
#5 - 2013-04-12 22:27:29 UTC
Actually, I figured it out, but one last question. What's a productivity modifier on a BPO?
Rengerel en Distel
#6 - 2013-04-12 22:45:52 UTC
Optimus Ormand wrote:
Actually, I figured it out, but one last question. What's a productivity modifier on a BPO?


https://forums.eveonline.com/default.aspx?g=posts&m=2819856#post2819856

With the increase in shiptoasting, the Report timer needs to be shortened.