open All Channels
seplocked Science and Industry
blankseplocked Planetary Profit Calculator (V 1.E)
 
This thread is older than 90 days and has been locked due to inactivity.


 
Author Topic

electrostatus
Center for Advanced Studies
Posted - 2011.02.11 17:36:00 - [1]
 

Edited by: electrostatus on 06/04/2011 00:20:11
Newest version 1.E
newest stuff mentioned here

You may have seen this floating around: tax picture. I was the one that made that; and ever since Iíve wanted to write a program that would calculate the tax on every component on every step of the way to make a product.
ďWhat do you mean by that?Ē you might say. So here is an example. I am building polyaramids, a refined commodity (P2) level. I am starting from its raw materials (P0). Those would be reactive gas and autotrophs. They come from different planets. I extract each of them and process them to oxidizing compound and industrial fibers. Now, I have to Export one of them off of a planet and Import it to the other. With both of these components now on the same planet, I can process them to my final product, polyaramids. Finally, I Export the polyaramids off the planet to be sold on the market. But how much in import and export fees have racked up on my precious polyaramids? That is what this program does.

The Planetary Profit Calculator.
[Download link]

This program will calculate any incurred taxes on your product (assuming you know what youíre doing). So how to use this program. Download this and unzip it. Inside of the folder there is file labeled planetary profit calculator, run that. This opens the program as shown in the picture above.

Following the example I mentioned, go to the add new plan button. This opens a window Picture 2. You must ask yourself these questions: What am I ultimately building? What products am I starting from? Once you have those answers you may continue.
What you are building is your final product. What products you are starting from are you initial products. Firstly, give your plan a name. It may be the name of the planet(s) youíre on, or your best friend. Secondly, select your final product. For the example, you must change your plan/planet drop down box to plan, as polyarmaids requires more than one planet.

Now select the final product level. Polyarmaids are refined commodities, so select that in the first final product drop down box. The second final product drop down box houses the names of the products of that level. Find and select polyarmaids in that list.
We are starting from its raw materials. Since the initial products are at raw materials, we are done. Picture 2a Now hit the add product button. This adds it to the plan. You may add several final products to a single plan. How many depends on the final product level. But for now, we are done. Hit the finish button at the bottom.

This returns you to the main program. It has now opened a tab, go to it. Picture 3. Here it lists all the products associated with the final product starting from its initial products that you have selected. Each product has a drop down box. This (options) box is what you do to the product just before you process it or sell it on the market.


As per the example, the oxidizing compound was being exported off its planet of gestation and imported to where the industrial fibers are. Select that in the oxidizing compoundís options box. Now when the polyarmaids are finished, it is being exported off the planet to be sold on the market. Select export for its options box. The program tells us that a grand total of 18.12 ISK has incurred on the polyarmaids in taxes while it was being built. Picture 4. The main tab will give a summary of this data as well.

electrostatus
Center for Advanced Studies
Posted - 2011.02.11 17:37:00 - [2]
 

Edited by: electrostatus on 06/04/2011 00:17:59
The program will do most any setup. Are you buying the P2ís of a broadcast node, importing to a planet, building that node and exporting it to sell for profit? The program will calculate the cost and the taxes for that. Picture 5. Building Integrity response drones by buying the gel-matrix biopaste from the market, building the planetary vehicles from its P1 components and making the hazmat detection systems its P2s? it can also do that Picture 6.

So give it a try. If you donít know what the symbols mean in the option boxes, hover your mouse above the table of the products. Iím not real fond of the symbols myself, but I havenít thought anything else to use.

So try it and complain why it didnít solve your (lack of) pants problems!




older versions:
1.d
1.c
1.b
1.a
1.0


Jettarina
Posted - 2011.02.17 14:13:00 - [3]
 

Had a quick look at it, seems to be fairly solid. Lots of stuff to play around with.

electrostatus
Center for Advanced Studies
Posted - 2011.02.20 18:45:00 - [4]
 

After some consideration, I decided to rename the program to the Planetary Profit Calculator, as it describes the program more accurately, seeing as it calculates the cost (including taxes) to build a PI product. So thatís about all this minor update does.

As for the options box symbols, Iím not a fan of them (theyíre not obvious), but I havenít thought of anything else to replace them with, so Iím open to ideas.

Raziel 2O99
Caldari
ROMANIA Renegades
ROMANIAN-LEGION
Posted - 2011.02.21 21:56:00 - [5]
 

I have tried out this software and find it really great in calculating profits.

Some things I would like to point out towards improvement:
- a way to import prices from an online source (or in absence of this from file)
- there are some issues with the callbacks of the price text fields (they dont update if u change just a digit and hit enter)
- when switching from one plan to the other in main view every info is saved for each individual plan and restored EXCEPT the sell price and quantity
- one can specify the total number of buildings for multiple planets but how these are split up amongst the planets is unknown ( for example I can have an extra Launchpad from the remaining unusable grid of 3 planets and still not get a negative PG) it would be nicer to choose the building numbers for each planet individually on 6 columns
- while choosing quantity to produce in a specific plan window it would be nice to see how much of any input material one needs in order to fill up a launchpad

I hope this tool will be developed further as it has a lot of potential. I dont think it will be some kind of "I win at PI" button but rather help speed up some calculations. What and how to make is still up to the player.

In conclusion: 10/10

electrostatus
Center for Advanced Studies
Posted - 2011.02.22 23:29:00 - [6]
 

A solid critique, thank you.
I'm looking into importing prices from eve-central right now, and the program does save whatever prices you already gave it. Having the plans save the sell price and quantity should be easy to add (must be weary of that word, should). As for the price text fields you mention, is that on the main tab or a plan tab? as I'm not seeing that issue.
the input material one needs in order to fill up a launchpad: do you mean the initial products, which list their volume in the lower table of a plan, or the final product, which does not?

Raziel 2O99
Caldari
ROMANIA Renegades
ROMANIAN-LEGION
Posted - 2011.02.23 12:20:00 - [7]
 

The issue happens in the plan window i will try to reproduce this when i get home today.
The plans indeed save prices in a single xml file and this makes prices available to new plns as well but i was thinking of ways to bring all the prices in at once maybe via excel format. In any case online import should be better as long as one can retrieve jita only prices too.
As for the volumes the interesting information is what mixture of quantities to put in the launchpad for inputs so that the launchpad is full but there isnt any extra resource of one kind left after all othershave been depleted. Basically u need to divide the capacity of the launchpad by the total volume of input materials for one batch (which is already calculated for 1 produced unit). It would also be nice to know the expected output volumes for a given quantity of inputs (e.g. one full launchpad). This all helps to decide how many launchpads one needs and how often should one haul materials to avoid overfill. Considering your programs aim is amongs others to set up a multi-planet plan and calculate profits and taxes, knowing how often one needs to haul helps figure out tthe profit relative to play time which is also important.

P.S. mind the spelling, im posting this from my phone

electrostatus
Center for Advanced Studies
Posted - 2011.02.24 04:53:00 - [8]
 

New version: [here]

I've added the ability to grab prices from eve central. this option is on the taxes tab. I've also added a final and initial volume listing under the summary box on the main tab, hover your mouse over those numbers for more information.
Most likely you'll want to keep your current plans, so find these two files within your current PPCalc folder and move them to this new version: planData.xml, Prices.xml

the issue you've mentioned, I think I fixed it, but the problem is that I only see it when I'm not looking for it.

Dillon Arklight
Aliastra
Posted - 2011.02.24 08:11:00 - [9]
 

Edited by: Dillon Arklight on 24/02/2011 11:00:53
Edited by: Dillon Arklight on 24/02/2011 11:00:27
Thanks for this. I have just moved my PI operation into a low sec system and was wondering what to concentrate on. I will try it out and get back to you with feedback.

update:

I just had time to play around with it for a few minutes as downtime was fast approaching and I had networks to setup.

A couple of points to consider;

  • Your tool for working out the powergrid of a network doesn't take into account the powergrid cost of links. I know you can really add this into the calculations because you have no way of knowing how much powergrid links will use, but a note next to the total alerting people may be useful
  • I had a bit of trouble interpreting the symbols for the production chain until I rested my mouse near the top of the page and the Key window appeared. A more visible key would help.


As i said thats all the time i had to play with the tool but i did realise that im loosing money by not selling Noble Metals directly to the market instead of using them to construct Refined goods. Why the heck is the price of Noble Metals so high?!

Thanks for this tool and the hard work you have put into it.

electrostatus
Center for Advanced Studies
Posted - 2011.02.25 03:59:00 - [10]
 

The power grid and cpu of links is actually taken in account, somewhat. Hovering the mouse over the remaining power grid or cpu will list the length of a level 0 link you can make with that amount. I would like to add more with the links, but I simply have no idea how the levels affect the pg and cpu cost of a link. I'm thinking the pg cost of a link is a function of length and level (this goes for the cpu cost as well), but I've never figured it out and ccp hasn't mentioned how its calculated.

As for the symbols, yes I know they're not apparent, but I think I finally have an idea for replacements.


Hmmm... perhaps I should put a note somewhere mentioning that a bunch of info is hidden in the mouseover text.

Raziel 2O99
Caldari
ROMANIA Renegades
ROMANIAN-LEGION
Posted - 2011.02.28 13:19:00 - [11]
 

Sorry for the delayed reply

The issue with the prices in plan view can be reproduced as follows:
Lets say I have 6600 for Construction Blocks already in the field. If I want to change that to 6500 by simply selecting the second 6 with the mouse and pressing 5 on the keyboard the 6 will be replaced with the 5 but the other fields do not update even if I press enter. In short, the text fields react to deleting and typing in characters but somehow not to select/insert combo.

Other notes about the recent changes and suggestions:
- the import prices options are really great and this part does not need further improvement
- the volumes for input and output help a lot and now it is easy to deduce how much of any material one needs to fill up the hauler, the customs office or a launchpad (basically what I use it for is to figure out how many mats I can haul to the customs office and how much of those I can import at one time in my launchpad all without having leftover mats at the end of the day. this is because I route from advanced to high tech processors directly)
- a nice feature for plans that involve extraction would be to show what the average extraction should be. For example, I want to make coolant and in the plan I set everything to be produced from extracted resources on the planet. The boxes with the raw materials should say how much I need to extract (per hour) to continuously produce coolant.

In closing, I would like to thank you again for this wonderful tool and also would like to offer my help should you need testing or further suggestions. It may be a personal opinion but I think this tool approaches the PI setup calculations in a better way than the other tools I have tried. I also think it has the potential to become THE ultimate PI tool.

Razuvi Erata
Posted - 2011.02.28 22:23:00 - [12]
 

This tool looks like it is very solid. However, I am a bit confused on a couple of things.

First, there is a difference in total cost between the Main page and the individual plan tabs. For example, with Sterile Conduits, the Main page reflects a total per unit of 429,011.20 isk, but the plan tab shows 644,048.00. The taxes are the same between the 2 places, so it must be in the calculation of the total price. I am encountering this off of all the P4 I have put in. I have also imported the prices through the tax page.

Any ideas on this?

electrostatus
Center for Advanced Studies
Posted - 2011.03.01 01:59:00 - [13]
 

Razuvi Erata, What exactly are you doing to build the conduits? Where are you starting from and what do you do to the initial and intermediate products to build them? Or could the quantity numbers be different?
Imported prices shouldn't cause such a discrepancy, as the number on the main tab takes the number calculated on the plan tab.

Raziel, as for the prices not causing updates, that could be an issue with the price box not sending a signal when it should, but I now have a place to look. As for calculating what a good extraction rate would be for continuous production, That might be a while to add. Good idea though.

I should have an update in a few days, but I would like to add the product icons though I can't find any sorted icon sheet or list, or even icons that have all the PI products in them.

Razuvi Erata
Posted - 2011.03.01 03:35:00 - [14]
 

I am starting from P1 and building up to p4. So importing P1 to my planets which builds up to P3. I then move the P3 to my high techs on another planet. I'll have post screenshots later.

Raziel 2O99
Caldari
ROMANIA Renegades
ROMANIAN-LEGION
Posted - 2011.03.02 17:38:00 - [15]
 

I have been thinking about the idea with the needed extraction rates further and I realised that the 'plan' type of plan can actually be enhanced even further by adding the option to calculate which planets are needed for the extracted products or even the needed planets in general for a single final product such as p3 or p4. I can think of two settings for this right now: either have as few resources per planet as possible to allow bigger extraction rates (more than one ECU) or minimize the number of required planets, possibly allowing a single planet to produce p2. The general idea is to give as input the available planets and what product to make and get as output which of the planets to use (considering also the number of planets of each type) and what to do on them.

I also have another question. I have some programming experience but am an absolute beginner in Python. As such my question is if you would be willing to work with (possibly poorly written) pseudo-code and flowcharts because as previously stated I am interested in lending a helping hand and it would make it easier to break down eventual ideas (also, by doing so I don't need to see your code). In any case PM me if interested :D

electrostatus
Center for Advanced Studies
Posted - 2011.03.03 16:00:00 - [16]
 

Edited by: electrostatus on 03/03/2011 16:12:07
So new update: I couldn't get all of the PI icons, so that'll have to wait. This update adds some information on plan tabs: hover the mouse over the 'i' icon to the right of the delete button. I've also changed how the volume is calculated; itís less painful now (its apparent when you change the quantity quickly). I also fixed the import prices button from locking up when there are no prices to grab. This version also opens a command window and prints things (because I just canít find that issue of the prices not updating). If you see something starting with ĎQTableWidget:í, I already know about that.
I have also changed the symbols in the options box of each product, please tell me if they're more apparent than the previous ones.
As before, copy your current planData and Prices xml's to this new folder.

Download here

Raziel, you mean having the program figuring out what planets you need to build a product? I had glanced at doing something like that for the query window (which, as far as I can tell, no one has looked at [from the feedback]), but I gave up on it as I couldnít figure that.

Raziel 2O99
Caldari
ROMANIA Renegades
ROMANIAN-LEGION
Posted - 2011.03.04 16:13:00 - [17]
 

Edited by: Raziel 2O99 on 06/03/2011 09:55:52
Yeah thats what I meant Very Happy

EDIT: The problem I mentioned with the text fields is now gone :D. I have inspected the query window a little closer and, indeed, having the program calculate the needed numbers should be easy to implement there (also makes alot of sense). Another thing that might make plans more flexible is to allow to change the starting products after the plan was created. This requires the list of input products to be updated more often but also gives the following advantage: lets say I'm making a P4 that requires 3 P3's to build, I want to import one of the P3's, make one out of P2's and build the last P3 out of extracted materials. The way the inputs are set for the plan do not allow this at the moment. One can fake it by starting from P0 and just importing P2 or further down the production line. I suggest removing the option to choose from what materials to start completely at the creation of a plan and display all the items from P0 to whatever is built in the plan window. A new menu item is needed for items that are not used (an X should be fine).

electrostatus
Center for Advanced Studies
Posted - 2011.03.15 00:11:00 - [18]
 

Since its pi day, hereís an update: version 1.d

  • icons added

  • issue where total power grid was being subtracted from total installation cost before displayed fixed

  • issue where dimensional portals would sometimes open and aliens appear now wonít happen

  • prices updated more consistently

  • console window no longer opens

  • other things I forgot



I'm also looking into searching the star systems to locate planets.

Duskiej
Posted - 2011.03.22 13:03:00 - [19]
 

Sorry for the necropost

Just downloaded this tool. It works great, but I noticed a mistake

The tool assumes Gel-Matrix Biopaste only requires 10 Biocells and 10 Oxides per cycle, but it also requires 10 Superconductors

electrostatus
Center for Advanced Studies
Posted - 2011.03.22 23:10:00 - [20]
 

Oh interesting. I found the error in the xml, it was stored incorrectly.

Download this, unzip it, and replace the Commodities.xml that is in the program's folder with it. That should take care of the issue.


I wish I knew how to make it not look cluttered in there.

electrostatus
Center for Advanced Studies
Posted - 2011.04.06 00:16:00 - [21]
 

Version 1.E


This version adds the ability to search the stars for planets. Itís a bit of an experiment, so see how works. The database may take some time to load on the first running.

Also added is a checkbox on the taxes tab thatíll ignore prices of a raw material if youíre extracting them. If you want to be like Ďhey, I personally didnít pay to get these materials!í or want to start a whole Ďwhat I extract is free with my free time!í argument. An icon for the program itself has been added so it stands out in that mess of files in the folder.

Also included is the fixed commodities database mentioned in my previous post.

mogsub
Posted - 2011.05.06 07:15:00 - [22]
 

thanks for the program. It makes calculating profit margins very easy and fast.

One question though: Why when I add a new plan with Advanced Commodities (P4) nothing shows up on the list?


electrostatus
Center for Advanced Studies
Posted - 2011.05.06 13:10:00 - [23]
 

The Plan/Planet drop down box (the first one on the plan builder window) restricts what final product can be built. Since no advanced commodity can be built on any one planet, they don't show up. You'll need to switch this drop down box to 'Plan', which covers every product.

Grukni
Posted - 2011.07.24 17:18:00 - [24]
 

I'm playing with the tool and it's pretty solid. Great job.

I wonder however, which prices do you take from eve-central. I would expect the minimum sell order price for product costs. However, I see discripancies with your tool. A direct search in Eve-Central for Industrial Fibers yields a 368.99 price in Jita but your tool gives a price of 446.99.

I also would love a hint with the max buy prices from Eve-Central for setting the sell price.

electrostatus
Center for Advanced Studies
Posted - 2011.07.26 00:18:00 - [25]
 

I grab the median sell price of the initial products. I have no idea if thatís a good number to grab or not. Are the industrial fibers an initial product or the final product in your plan? Because that would change the number presented. The cost of the intermediate products and final product are built from the initial product prices.
The grab prices will get the overall median sell price, unless you have checkmarked a region or system. Merely selecting a location and not hitting its adjacent checkbox wonít work.
I personally prefer to manually put the initial product prices in however.
As for the selling price hint suggestion, havenít got an idea how or where Iíd place that kind of hint right now. Or see how it'd work.

Speaking of hints, remember that hovering the mouse over numbers or text will yield hints or more information!

Grukni
Posted - 2011.08.11 21:48:00 - [26]
 

Originally by: electrostatus
I grab the median sell price of the initial products. I have no idea if thatís a good number to grab or not. Are the industrial fibers an initial product or the final product in your plan? Because that would change the number presented. The cost of the intermediate products and final product are built from the initial product prices.
The grab prices will get the overall median sell price, unless you have checkmarked a region or system. Merely selecting a location and not hitting its adjacent checkbox wonít work.
I personally prefer to manually put the initial product prices in however.
As for the selling price hint suggestion, havenít got an idea how or where Iíd place that kind of hint right now. Or see how it'd work.

Speaking of hints, remember that hovering the mouse over numbers or text will yield hints or more information!



For initial products of the plan, grabbing the minimum sell price is best. For selling the stuff, the maximum buy price could (and in my opinion should) be the reference.

electrostatus
Center for Advanced Studies
Posted - 2011.08.17 04:45:00 - [27]
 

Unfortunately college started as of yesterday, so I won't have time to develop this for a while. I could release the code (tentatively titled ADVENTURES IN UNDOCUMENTED CODE!) if enough people would want such a mess thing. It's written in Python and uses PyQt.
I also had thought of making a extraction simulation so you can see how your skills would affect what you see. But that fell apart pretty quickly when I realized no one really knows precisely how one's skills affect how the raw resources are shown. Also I'd need data of a planet.

MegabitOne
Caldari
The Black Ops
Posted - 2011.08.21 10:56:00 - [28]
 

Edited by: MegabitOne on 21/08/2011 11:00:59
electrostatus, could you please enlighten us on the meaning of the icons used in the plans? Thanks!
And now that I hovered the (i) information icon, you did just that Embarassed


 

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