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.
 

T2 Ship Goo excel
Author
Previous Topic Next Topic
Kusum Fawn
Perkone
Caldari State
#1 - 2012-05-11 18:33:39 UTC
I started on this a while ago but never got around to finishing it before now.

Starts with a ship, calculates the various types of Components , composites and goos you need.

All t2 ships, + JF as well as a small POS fuel calc

There are four hidden pages (cause im kind of messy) and also because my Excel-fu is in its beginner phase.
Hidden pages are calculation sheets and not necessary for general use.

Please pay attention to the things written in Red boxes.

http://www.mediafire.com/view/?8owsuf6t33u83di


Please tell me what you think and how it could be improved

Its not possible to please all the people all the time, but it sure as hell is possible to Displease all the people, most of the time.
Avvalina
DVA Enterprises
#2 - 2012-05-11 19:48:34 UTC
1.) Put it in Google docs so people can actually see what it is
2.) ???
3.) Profit
Kusum Fawn
Perkone
Caldari State
#3 - 2012-05-13 01:11:47 UTC
the site that i put it on (mediafire) has a download button on the top right, it deosnt show up well on the mediafire reader thing, as every excel sheet tends to do on browsers.

Its not possible to please all the people all the time, but it sure as hell is possible to Displease all the people, most of the time.
Kusum Fawn
Perkone
Caldari State
#4 - 2012-05-14 16:47:59 UTC
any comments about the excel other then it shoudl be on google docs?

Its not possible to please all the people all the time, but it sure as hell is possible to Displease all the people, most of the time.
Raiku Onni
CONCORD Research
#5 - 2012-05-14 17:31:33 UTC
You might want to check your rounding. The numbers you produce are slightly wrong for some ships.

For instance according to your sheet a Panther at ME -1, PE 5 needs 1,306.80 Deflector Shield Emitters. This should actually be 1307.

A tiny error but it will lead to someone going shopping for slightly too few ingredients.
Kusum Fawn
Perkone
Caldari State
#6 - 2012-05-14 18:55:56 UTC
Raiku Onni wrote:
You might want to check your rounding. The numbers you produce are slightly wrong for some ships.

For instance according to your sheet a Panther at ME -1, PE 5 needs 1,306.80 Deflector Shield Emitters. This should actually be 1307.

A tiny error but it will lead to someone going shopping for slightly too few ingredients.


which sheet are you looking at?
The component sheet lists it at 1,306.80 but the main page is rounded up to 1,307

or does it not round properly on the main page for you?

also as a note, all Intermediates and goo numbers are rounded up to the nearest whole reactor cycle amounts. so there will be some composites left over when starting from base goos, or intermediates.

Its not possible to please all the people all the time, but it sure as hell is possible to Displease all the people, most of the time.
Raiku Onni
CONCORD Research
#7 - 2012-05-14 19:24:00 UTC  |  Edited by: Raiku Onni
I see the 1307 on the main page but you still calculate that to 26,136.00 Fernite Carbide which you must have arrived at by using 1306.8 from the component page in the calculation. The actual calculation should have been 1307 * 20 = 26,140.

Only the number of components is right on the front page. The goo breakdown still has the rounding error in it.
Malamber
Venomous Cloud
Scorned Syndicate
#8 - 2012-05-15 17:40:08 UTC
I can't access it... it starts to download, then 404 error. Do you have to have a mediafire account?
Kusum Fawn
Perkone
Caldari State
#9 - 2012-05-15 18:21:49 UTC
Malamber wrote:
I can't access it... it starts to download, then 404 error. Do you have to have a mediafire account?


I do have an account, it downloads fine for me on separate computers, so i dont know what to tell you,

I do have to fix it so ..

Its not possible to please all the people all the time, but it sure as hell is possible to Displease all the people, most of the time.