| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Misty
   |
Posted - 2004.05.13 20:25:00 -
[1]
Anyone know the excel formula to calculate the minerals recovered from reprocessing an item.... given the base minerals, Refining rank, Refining Effeciency, Station yield and scrapmetal processing. I have not be able to create one or find one that consistently given the same results as the stations :(
|
Deloup Drakar
|
Posted - 2004.05.14 02:07:00 -
[2]
Ok, just how it is off of my sheet...
B1= Refining Skill
B2= Refinery Efficiency
D2= Faction
D3= Station % (50% imputed as 50)
J2= 6+2/3 (6.666666...etc)
H7= Processing Skill
G7= H7*0.05
F7= (D3+37.5*((1+0.02*B1)*(1+0.04*B2)))/100
E7= F7+G7
D7= (IF(E7>1:1:E7))-((5-0.75*(IF(D2>J2:J2:D2)))/100)
That D7 should give you the % yeild you'll get from the ore. There is a method to my madness as to why things are spread out as such, it makes sence if you see my layout lol.
|
Fubar
|
Posted - 2004.05.14 04:28:00 -
[3]
Here is your formula:
Adjusted_Station_Yield = station_equipment + (37.5 * (1+(refining_skill_level*0.02)) * (1+(refinery_efficiency_skill_level*0.04)) * (1+(scrapmetal_processing_skill_level*0.05)))
*The adjusted_station_yield has a maximum of 100.
station_fee = 5 - (standings*0.75)
*Use all of the decimal places given to you in the reprocessing plant. Alternately you can use the percentage given in the reprocessing plant.
you_receive = rounddown(basemineral * number_of_items * (adjusted_station_yield/100) * (1-(station_fee/100)),0)
|
Pilthanis
|
Posted - 2004.05.16 11:11:00 -
[4]
any chance someone can post their spreadsheet?
|
Mari Y'Tuk
|
Posted - 2004.05.16 20:10:00 -
[5]
I believe my sheet works perfectly, check out the bottom of the refine sheet, thou i haven;t tested it as much as the bp forumlas.
it is very important to get the station take exact as even 0.000001 makes a difference to the result
My Production Spreadsheet, Most T1 Bp data, Located here. |
Fubar
|
Posted - 2004.05.17 17:28:00 -
[6]
 Originally by: Fubar
Here is your formula:
Adjusted_Station_Yield = station_equipment + (37.5 * (1+(refining_skill_level*0.02)) * (1+(refinery_efficiency_skill_level*0.04)) * (1+(scrapmetal_processing_skill_level*0.05)))
*The adjusted_station_yield has a maximum of 100.
station_fee = 5 - (standings*0.75)
*Use all of the decimal places given to you in the reprocessing plant. Alternately you can use the percentage given in the reprocessing plant.
you_receive = rounddown(basemineral * number_of_items * (adjusted_station_yield/100) * (1-(station_fee/100)),0)
Since not all items can be recycled individually the number_of_items should have been:
number_of_batches = rounddown(number_of_items/item_batch_size,0)
so the final formula would be:
you_receive = rounddown(basemineral * number_of_batches * (adjusted_station_yield/100) * (1-(station_fee/100)),0)
|
Mari Y'Tuk
|
Posted - 2004.05.19 11:31:00 -
[7]
Your right my spreadsheet assumes a full batch, from cost to refining, so 100 for ammo and 10 for missiles
My Production Spreadsheet, Most T1 Bp data, Located here. |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |