open All Channels
seplocked Science and Industry
blankseplocked [WebTool] Full T1 T2 Capital Manufacturing Calculator.
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.01.19 22:42:00 - [1]
 

Edited by: Kiay Stryx on 28/02/2009 14:51:30
PhoenixToolsManufacturing - Full T1 T2 Capital Manufacturing Calculator.

http://tools.phoenixmandate.com/?manufacturing

Here is one of the tool sets I have been working on for our corporation.
Itís all pretty self explanatory...

  • Find items by name.

  • Select items from drop down box. (Thanks Pwett)

  • Saving of BP information and price data. (Requires registration)

  • Will produce results for all manufacturable items.

  • All calculations are done from base minerals and materials.

  • Will output all required items for build.

  • Will output profit margins.

  • Ability to modify mineral and material prices.

  • Takes into account your Industry, Production Efficiency, Accounting and Broker Relations skills.

  • Material Efficiency from all blueprints for the build are taken into account.

  • Fully in-game compatible.


For added features please register at...
http://phoenixmandate.com/PhoenixToolsPilotPanel.php
...In game, you can login at the same place out of game.

In Development.

  • Item name search and modify.

  • Add PE of BP into installation costs.


Known Problems.

  • Named Items containing single quotations.

  • Named drones.

  • T2 Ammo.



Under heavy development.
Iím coding all this by myself and would appreciate feedback.

Donations to Phoenix Mandate (Corp).
Comments and suggestions to Kiay Stryx.

Thank you.

~Stryx

Markus Relic
Relic Shipyards
Posted - 2009.01.19 23:40:00 - [2]
 

Looks like a nice little app Smile

I checked it against a spreadsheet i've made for T2 ship production but your app doesn't seem to handle the negative ML values you get from invention BPCs. It seems to be treating negative ML values as positive ML values for the calculations which is making the results inaccurate. There is a slight difference to the equation when using negative ML, check out this link to EVE Dev (superb site) for the equation. You just need to test the value entered to see if its less than zero and use that to decide which formula to use.

Would be sweet if you could make it work in the IGB! Twisted Evil


Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.01.19 23:48:00 - [3]
 

Edited by: Kiay Stryx on 19/01/2009 23:47:58
Originally by: Markus Relic
Looks like a nice little app Smile

I checked it against a spreadsheet i've made for T2 ship production but your app doesn't seem to handle the negative ML values you get from invention BPCs. It seems to be treating negative ML values as positive ML values for the calculations which is making the results inaccurate. There is a slight difference to the equation when using negative ML, check out this link to EVE Dev (superb site) for the equation. You just need to test the value entered to see if its less than zero and use that to decide which formula to use.

Would be sweet if you could make it work in the IGB! Twisted Evil




Will look into negative ML. Thanks.

It does work ingame, but IGB is very slow.
At the moment its restricted to only corp members because it has extra features such as remember prices and blueprints. Plan is to open it all up soon.

~Stryx

testkyra
Posted - 2009.01.21 22:34:00 - [4]
 

Very nice! Will you be releasing the code for this?

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.01.23 19:30:00 - [5]
 

Edited by: Kiay Stryx on 23/01/2009 22:22:12
Ok, I belive I have fixed the T2 ML issue.

When the whole system is complete it will be released under some GPL.

Also, All items can now be calculated.

~Stryx

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.01.25 00:35:00 - [6]
 

Edited by: Kiay Stryx on 14/02/2009 21:33:12
Edited by: Kiay Stryx on 25/01/2009 00:51:45
Edited by: Kiay Stryx on 25/01/2009 00:35:57
Also, ive seen a few tools out there, and the math dosnt add up.
If any one is interested in working full equation for final quantities, here ya go...

ProductionEfficiancyWaste = BaseQNT * (0.25 - (0.05 * SkillProductionEfficiency))

WasteIfNegativeME = BaseQNT * (abs(ME) + 1) * (BaseWaste / 100)
WasteIfPositiveME = BaseQNT * ((BaseWaste / 100) / (ME + 1))

BuildQNT = round((BaseQNT + Waste + ProductionEfficiancyWaste))


Results where verified ingame.

*edit*
Little tip, when building T2, all T1 items required for the T2 build (E.G. Thorax for Deimos build) do not use any equation. They should be set to BaseQNT.
Same for R.A.M.

~Stryx

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.01.31 00:31:00 - [7]
 

Bug found in T2 components that require Tungsten Carbide.
It doesn't show or calculate.

Will fix over weekend.

~Stryx

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.03 15:39:00 - [8]
 

Originally by: Kiay Stryx
Bug found in T2 components that require Tungsten Carbide.
It doesn't show or calculate.



Fixed

~Stryx

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.04 23:41:00 - [9]
 

Public should now have access to in-game site (for the patient).
Will need trust.

Also there is a bug with the eve browser, if you click "do not ask again about this site" button, it will auto reject trust.
You will need to go into trusted options and re-trust our site.

~Stryx

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.11 04:58:00 - [10]
 

Added sales tax, and broker fees to equations.

~Stryx

Henry Fredyericus
Gallente
H.F. Enterprises
Interstellar Trade Syndicate
Posted - 2009.02.12 08:26:00 - [11]
 

App works very well Smile

Only request we would have with the app is to have a drop-down list for the item names to choose from. Would save quite a bit of time on proof-reading.

Thank you

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.12 17:09:00 - [12]
 

Originally by: Henry Fredyericus
App works very well Smile

Only request we would have with the app is to have a drop-down list for the item names to choose from. Would save quite a bit of time on proof-reading.

Thank you


Just tried it,
Unfortunately it increases the script run time allot while it tries to populate the drop down box. A noticeable two seconds per page load.

I was planning on adding a search feature instead.

~Stryx

Pwett
QUANT Corp.
QUANT Hegemony
Posted - 2009.02.12 17:45:00 - [13]
 

Originally by: Kiay Stryx
Originally by: Henry Fredyericus
App works very well Smile

Only request we would have with the app is to have a drop-down list for the item names to choose from. Would save quite a bit of time on proof-reading.

Thank you


Just tried it,
Unfortunately it increases the script run time allot while it tries to populate the drop down box. A noticeable two seconds per page load.

I was planning on adding a search feature instead.

~Stryx



Have tried optimizing the indices in your DB? It shouldn't take more than a fraction of a second to grab manufacturables.

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.12 18:01:00 - [14]
 

Edited by: Kiay Stryx on 12/02/2009 18:11:53
Originally by: Pwett
Have tried optimizing the indices in your DB? It shouldn't take more than a fraction of a second to grab manufacturables.


I think it was just the method I was using to populate the drop down box.
Everything server side is fine. The extended script run time comes from printing all the <options></options> in the markup.

Originally by: PhoenixToolsManufacturing
$query = "SELECT invblueprinttypes.blueprintTypeID, invtypes.typeName FROM invblueprinttypes, invtypes WHERE invblueprinttypes.productTypeID = invtypes.typeID ORDER BY invtypes.typeName ASC";
mysql_query($query);
$ressult = mysql_query($query);
while($nt=mysql_fetch_array($ressult)){
print "<option value='".$nt[typeName]."'>$nt[typeName]</option>";
}



There probably a better method? But that's the one I came up with to quickly test it out.
I'm by no means a PHP expert, its something I've picked up over the last few months to try and get me into university.

~Stryx

Pwett
QUANT Corp.
QUANT Hegemony
Posted - 2009.02.12 19:02:00 - [15]
 

Edited by: Pwett on 12/02/2009 19:02:46

$query = "SELECT `invblueprinttypes`.`blueprintTypeID`, `invtypes`.`typeName`
FROM `invblueprinttypes`
LEFT JOIN `invTypes`
ON `invTypes`.`typeID` = `invblueprinttypes`.`productTypeID`
WHERE `invTypes`.`published` = 1
ORDER BY `invtypes`.`typeName` ASC";
mysql_query($query);
$ressult = mysql_query($query);

while($nt=mysql_fetch_array($ressult))
{
$HTML .= "<option value='".$nt['typeName']."'>$nt['typeName']</option>";
}


couple things:
1. If you're interested in some mySQL classes for PHP which deal with memory bloat, drop me an email which you can find on starvingpoet.net
2. You'll save yourself a ton of time by caching all your echos into a single string then outputting them all at once
3. Using Joins instead of Where clauses are easier on the DB. This way we're only pulling data from invTypes after reading all the product type IDs in invBlueprints.
4. Make sure that when you call things in that while loop that array keys are encased in quotes. PHP can figure out their strings but if they're not en-quoted it will check to see if any constants exist with that name.
5. You can also run this query once, store it all into a single html file, and include it within the script so that there is no processing. See www.starvingpoet.net/itemDB.html. I only regenerate that file when the DB changes.


Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.12 21:16:00 - [16]
 

Thanks Pwett.
Any idea on how to get the items with ' marks through the script?

If you select one of the 1st few items from the drop down list, my script seems to discard them.

~Stryx

Pwett
QUANT Corp.
QUANT Hegemony
Posted - 2009.02.12 21:18:00 - [17]
 

Edited by: Pwett on 12/02/2009 21:20:19
Edited by: Pwett on 12/02/2009 21:18:47
Originally by: Kiay Stryx
Thanks Pwett.
Any idea on how to get the items with ' marks through the script?

If you select one of the 1st few items from the drop down list, my script seems to discard them.

~Stryx

see if this works:

str_replace("'", "& # 3 9 ;", $nt['typeName']);
drop the spaces in the second set of quotes Smile

place that where ever you normally have $nt['typeName']

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.12 21:52:00 - [18]
 

Originally by: Pwett
see if this works:

str_replace("'", "& # 3 9 ;", $nt['typeName']);
drop the spaces in the second set of quotes Smile

place that where ever you normally have $nt['typeName']


Thanks, everything seems to work =)
Also had to swap the query quotations around.

~Stryx

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.16 18:42:00 - [19]
 

Edited by: Kiay Stryx on 16/02/2009 18:50:39
You can now register in game. Visit...
http://phoenixmandate.com/PhoenixToolsPilotPanel.php
...from your in game browser.

Passwords are MD5 encrypted in our database.

Login out of game...
http://phoenixmandate.com/PhoenixToolsPilotPanel.php

Once logged in you can save all your BP information, like ML, PL, sell prices, material/mineral costs.

When logged in it will automatically load these values for you.

~Stryx

Veleck
Gallente
Journey Construction Ltd.
Apocalypse Now.
Posted - 2009.02.16 20:18:00 - [20]
 

How about options to adjust install cost and cost per hour?

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.16 20:51:00 - [21]
 

Originally by: Veleck
How about options to adjust install cost and cost per hour?


Added.

~Stryx

Veleck
Gallente
Journey Construction Ltd.
Apocalypse Now.
Posted - 2009.02.16 22:25:00 - [22]
 

Unable to register/login. When registering from the in-game browser it brings you back to the same page, no additional messages. When trying to login using the credentials entered while registering, it says, "Error".

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.16 23:23:00 - [23]
 

Originally by: Veleck
Unable to register/login. When registering from the in-game browser it brings you back to the same page, no additional messages. When trying to login using the credentials entered while registering, it says, "Error".


Seems to works fine in all my tests.
In game you just want to add a password.

Then login out of game with your in game name and the password you used.

~Stryx

Kiay Stryx
Gallente
Phoenix Mandate
Phoenix Virtue
Posted - 2009.02.25 13:29:00 - [24]
 

Increased form security.
Added Price Index for future expansion.

Price Data provided by Eve-Central.
If you want your region price data, contribute here, and ill add the region.

~Stryx


 

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only