| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Astinius
   |
Posted - 2004.08.23 05:26:00 -
[1]
Edited by: Astinius on 23/08/2004 05:27:21
Does anyone know what the correct calculation formula is for researching time of a blueprint. All the excel spreadsheets I have looked at calculate it wrong (outputs thousands of weeks), except for one which the owner keeps locked so I can't see his forumla.
Thanks.
|
Astinius
|
Posted - 2004.08.23 05:26:00 -
[2]
Edited by: Astinius on 23/08/2004 05:27:21
Does anyone know what the correct calculation formula is for researching time of a blueprint. All the excel spreadsheets I have looked at calculate it wrong (outputs thousands of weeks), except for one which the owner keeps locked so I can't see his forumla.
Thanks.
|
T'el'Alana Luathin
|
Posted - 2004.08.23 09:38:00 -
[3]
Edited by: T'el'Alana Luathin on 23/08/2004 10:30:13
hehe, could u be talking about my sheet? 
It's actually pretty simple, 'research_time'*(1-(0,05*metallurgy_skill)). This gives you total seconds to research.
T.
--
always look on the bright side of the cloning facility. |
T'el'Alana Luathin
|
Posted - 2004.08.23 09:38:00 -
[4]
Edited by: T'el'Alana Luathin on 23/08/2004 10:30:13
hehe, could u be talking about my sheet?
It's actually pretty simple, 'research_time'*(1-(0,05*metallurgy_skill)). This gives you total seconds to research.
T.
--
always look on the bright side of the cloning facility. |
Mari Y'Tuk
|
Posted - 2004.08.23 10:44:00 -
[5]
'copy_time'*(1-(0,05*science_skill))*2*(max_runs/Runs_per_copy)
My Production Spreadsheet, Most T1 Bp data, Located here. |
Mari Y'Tuk
|
Posted - 2004.08.23 10:44:00 -
[6]
'copy_time'*(1-(0,05*science_skill))*2*(max_runs/Runs_per_copy)
My Production Spreadsheet, Most T1 Bp data, Located here. |
Nicodemous
|
Posted - 2004.08.24 10:44:00 -
[7]
/me scratches his head...
Mine looks right too
(reseach time)-(research time*0.05)*metallurgy skill)
|
Nicodemous
|
Posted - 2004.08.24 10:44:00 -
[8]
/me scratches his head...
Mine looks right too
(reseach time)-(research time*0.05)*metallurgy skill)
|
Fubar
|
Posted - 2004.08.24 17:14:00 -
[9]
Blueprint copying time equation
total_copy_time = research_copy_time * (1 - (science_lvl * 0.05)) * 2 * (number_of_runs / max_runs_allowed)
In otherwords to make a full run copy takes twice the amount of time listed on the blueprint.
Material Level Research equation
total_research_time = research_material_time * (1 - (metallurgy_lvl * 0.05))
Productivity Level Research equation
total_research_time = research_productivity_time * (1 - (research_lvl * 0.05))
|
Fubar
|
Posted - 2004.08.24 17:14:00 -
[10]
Blueprint copying time equation
total_copy_time = research_copy_time * (1 - (science_lvl * 0.05)) * 2 * (number_of_runs / max_runs_allowed)
In otherwords to make a full run copy takes twice the amount of time listed on the blueprint.
Material Level Research equation
total_research_time = research_material_time * (1 - (metallurgy_lvl * 0.05))
Productivity Level Research equation
total_research_time = research_productivity_time * (1 - (research_lvl * 0.05))
|
Fubar
|
Posted - 2004.08.24 18:39:00 -
[11]
You can then use this formula to convert the seconds to month, days, hours, minutes, seconds format.
Cell A1 would equal the whatever time in seconds.
=IF(A1>2678400,TRUNC(A1/2678400)&"m ","")&IF(A1>86400,TRUNC(MOD(A1,2678400)/86400)& "d ","") &IF(A1>3600,TRUNC(MOD(A1,86400)/3600)& "h ","")&TRUNC(MOD(A1,3600)/60)& "m "&TRUNC(MOD(A1,60)/1)& "s "
|
Fubar
|
Posted - 2004.08.24 18:39:00 -
[12]
You can then use this formula to convert the seconds to month, days, hours, minutes, seconds format.
Cell A1 would equal the whatever time in seconds.
=IF(A1>2678400,TRUNC(A1/2678400)&"m ","")&IF(A1>86400,TRUNC(MOD(A1,2678400)/86400)& "d ","") &IF(A1>3600,TRUNC(MOD(A1,86400)/3600)& "h ","")&TRUNC(MOD(A1,3600)/60)& "m "&TRUNC(MOD(A1,60)/1)& "s "
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |