| Pages: [1] :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Gabbelgak
   |
Posted - 2007.01.22 06:33:00 -
[1]
I worked on this in some spare time I had at work/home, hope others find a use for it as well.
What it is:
Excel Document (Made with people who have no excel knowledge in mind)
It has all the info for T1 Rigs available in it, navigatable via an easy drop down menu interface.
You can input prices of components to see how much a rig would cost to make just by buying all the components.
You can input the sell price of rigs to display what the most profitable rig to build with current prices is as well as how much profit you make on any rig.
You can add your number on hand of your components and it will display how much it would cost to purchase the rest of the items.
Here's the Link: Rig Profit Calculator
|
Zarthax Mandatori
Gallente
Insidious Existence
Interstellar Alcohol Conglomerate
|
Posted - 2007.01.22 11:31:00 -
[2]
Edited by: Zarthax Mandatori on 22/01/2007 11:33:50
Nice tool :)
To make it work even better, insert this:
=IF(C27<D27;0;(C27-D27)*E29)
In Cell F-27
=IF(C29<D29;0;(C29-D29)*E29)
In Cell F-29
=IF(C31<D31;0;(C31-D31)*E31)
In cell F-31
What it does:
=IF(C27<D27 -- Determines if you have more materials than needed.
;0; -- Is what to display, IF you have more than needed.
(C27-D27)*E27)-- If you do not have enough, it retracts what you have, from what is needed, nd then multiplies the result with the cost, and displays the actual cost.
These lines give a more accurate number of total cost, based on what you have in hand.
Again, Nice sheet :)
*Edit: changed the numbers to follow the right row :S 
|
Gabbelgak
|
Posted - 2007.01.22 11:57:00 -
[3]
Nice addition, think I'll stick it into an adjacent cell when I update the file. I like being able to see how much it would cost to just purchase all materials as well as remaining materials 
Thanks
|
Zarthax Mandatori
Gallente
Insidious Existence
Interstellar Alcohol Conglomerate
|
Posted - 2007.01.22 12:16:00 -
[4]
You could also change the section for those without maxed skills:
C-40: =IF(D27>B40;0;(B40-D27)*E27)
C-41: =IF(D29>B41;0;(B41-D29)*E29)
C-42: =IF(D31>B42;0;(B42-D31)*E31)
C-43: =SUM(C40+C41+C42)
Then this section will change genericly too :)
|
Gabbelgak
|
Posted - 2007.01.28 04:51:00 -
[5]
Bump for Updated Version
|
ForceM
Gallente
POS Builder Inc.
|
Posted - 2007.02.01 13:37:00 -
[6]
I like your sheet .. but i am missing a part.
Your sheet is calculated with using the Max player skills for 0 player waste).
But your not taking in account the ML of BPO's
As Rig BPO's (at least Tech1) are researchable in less then 2 days to perfect ML (no exceptions) it costs even less then your sheet says.
I got all of them researched to perfect ML now ... If you want i can check them all and send the 0 (player+ML) waste list to you.
Me being a pessimist is a win-win situation:
Either i am right .. or its even better then i said. |
Sphynx Stormlord
Gallente
Anqara Industries
|
Posted - 2007.02.01 23:40:00 -
[7]
Nice sheet.
I wanted to be able to see the info on each rig as i'm looking though what to build on the calculation page, so I added:
A32 =VLOOKUP(A30,'Rig Information'!B:E,4,FALSE)
B32 =VLOOKUP(A30,'Rig Information'!B:E,2,FALSE)
This shows the effect and discription for the currently selected rig in those two cels.
|
ForceM
Gallente
POS Builder Inc.
|
Posted - 2007.02.02 08:47:00 -
[8]
 Originally by: Sphynx Stormlord
Nice sheet.
I wanted to be able to see the info on each rig as i'm looking though what to build on the calculation page, so I added:
A32 =VLOOKUP(A30,'Rig Information'!B:E,4,FALSE)
B32 =VLOOKUP(A30,'Rig Information'!B:E,2,FALSE)
This shows the effect and discription for the currently selected rig in those two cels.
Have you even looked at the sheet?
A47 to F52 whows excactly what your describing here ...
Me being a pessimist is a win-win situation:
Either i am right .. or its even better then i said. |
Sphynx Stormlord
Gallente
Anqara Industries
|
Posted - 2007.02.02 10:39:00 -
[9]
Heh, so it does. And yet somehow I failed to notice it when playing around with it for well over 1/2 an hour. I was mostly looking at the two sections at the top; the component costs and the rig choice, and clearly failed to direct my attention below the 'non-maxed-skills' section (which is a waste of space, because production efficency doesnt work on rig production).
Still, I learnt how to use the VLOOKUP function from experimenting with that sheet, which has to be a good thing.
|
vanBuskirk
Caldari
|
Posted - 2007.02.02 12:05:00 -
[10]
Originally by: ForceM
I like your sheet .. but i am missing a part.
Your sheet is calculated with using the Max player skills for 0 player waste).
But your not taking in account the ML of BPO's
As Rig BPO's (at least Tech1) are researchable in less then 2 days to perfect ML (no exceptions) it costs even less then your sheet says.
I got all of them researched to perfect ML now ... If you want i can check them all and send the 0 (player+ML) waste list to you.
Sure - it only takes 2 days to research the BPO. Once it's been stuck in the lab waiting for a slot for three weeks, that is.
More ME slots please CCP!
----------------------------------------------
"Violence is the last refuge of the incompetent."
Great site:National Nutrition (UK only) |
ForceM
Gallente
POS Builder Inc.
|
Posted - 2007.02.02 20:25:00 -
[11]
Originally by: Sphynx Stormlord
Heh, so it does. And yet somehow I failed to notice it when playing around with it for well over 1/2 an hour. I was mostly looking at the two sections at the top; the component costs and the rig choice, and clearly failed to direct my attention below the 'non-maxed-skills' section (which is a waste of space, because production efficency doesnt work on rig production).
Yes it does ..
Me being a pessimist is a win-win situation:
Either i am right .. or its even better then i said. |
ForceM
Gallente
POS Builder Inc.
|
Posted - 2007.02.02 20:32:00 -
[12]
Originally by: vanBuskirk
Sure - it only takes 2 days to research the BPO. Once it's been stuck in the lab waiting for a slot for three weeks, that is.
More ME slots please CCP!
Well some ppl whine on the forums like ... uhh .. like YOU ..
Others find the sollutions that CCP implemented (like mobile labs or low sec systems).
Me being a pessimist is a win-win situation:
Either i am right .. or its even better then i said. |
Erfnam
Time Cube Syndicate
Daikoku Trade Syndicate
|
Posted - 2007.02.02 20:35:00 -
[13]
Originally by: vanBuskirk
Originally by: ForceM
I like your sheet .. but i am missing a part.
Your sheet is calculated with using the Max player skills for 0 player waste).
But your not taking in account the ML of BPO's
As Rig BPO's (at least Tech1) are researchable in less then 2 days to perfect ML (no exceptions) it costs even less then your sheet says.
I got all of them researched to perfect ML now ... If you want i can check them all and send the 0 (player+ML) waste list to you.
Sure - it only takes 2 days to research the BPO. Once it's been stuck in the lab waiting for a slot for three weeks, that is.
More ME slots please CCP!
Bring me any Rig BPO and i'll research it to ME 20 for 700k...you'll have your bpo back in 2-3 days.
TCSyn is recruiting |
voidvim
Minmatar
Genco
Interstellar Alcohol Conglomerate
|
Posted - 2007.02.02 22:04:00 -
[14]
woot - very nice
|
Gabbelgak
|
Posted - 2007.02.03 11:01:00 -
[15]
Originally by: ForceM
I like your sheet .. but i am missing a part.
Your sheet is calculated with using the Max player skills for 0 player waste).
But your not taking in account the ML of BPO's
As Rig BPO's (at least Tech1) are researchable in less then 2 days to perfect ML (no exceptions) it costs even less then your sheet says.
I got all of them researched to perfect ML now ... If you want i can check them all and send the 0 (player+ML) waste list to you.
Sure I'll take that info and plug in the ability to view 0ME vrs No Waste. If you could, could ya post the completed list in here insted of mailing it if ya don't mind, I only plan on updating this at work in my spare time now. Don't have access to the game at work.
|
ForceM
Gallente
POS Builder Inc.
|
Posted - 2007.02.03 11:11:00 -
[16]
Originally by: Gabbelgak
Originally by: ForceM
I like your sheet .. but i am missing a part.
Your sheet is calculated with using the Max player skills for 0 player waste).
But your not taking in account the ML of BPO's
As Rig BPO's (at least Tech1) are researchable in less then 2 days to perfect ML (no exceptions) it costs even less then your sheet says.
I got all of them researched to perfect ML now ... If you want i can check them all and send the 0 (player+ML) waste list to you.
Sure I'll take that info and plug in the ability to view 0ME vrs No Waste. If you could, could ya post the completed list in here insted of mailing it if ya don't mind, I only plan on updating this at work in my spare time now. Don't have access to the game at work.
Sure ...
Ill make a sheet(based on your "rig information" sheet) and post it on Eve-files for you.
Expect it in 2 days tops).
Me being a pessimist is a win-win situation:
Either i am right .. or its even better then i said. |
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |