Science & Industry

Hello All,

I wanted to share the first release of my PI Trader spreadsheet. I know there are a bunch of these out there. However in PI Trader I have tried to aim for new players or players that need multiple amounts information on a single screen.

In this beta release you will be able to view and see profit for creating a "Broadcast Node" on a single spreadsheet with the following features:

- Profit for making each Item from RAW to advance allowing you to find the sweet spot in the market
- Ordering of what materials make what items
- Display of QTY needed for each stage

Whats not included

- Sales tax - In progress
- Export/import tax In progress

Features to come:

- Prices for all major hubs
- All PI items to be included - Complete
- Buy orders to be listed

Layout Design

Each stage will have 3 to 4 rows which calculate the following:

QTY - Quantity of materials extracted or required per cycle

Profit - This is the overall profit you will make selling the item at that stage. After the first stage you will start to see I'm taking into account the profit from the previous stage. What this does is shows if its best to sell on stage 1 or sell at stage 2 rather than stage 3 etc...

POCO Tax This will be the rate in which your POCO's are set up. The default is 0%. You can change the flat rate at the bottom which will change the rate for all sections. You can also overwrite different rates for each section.

Import Tax This will be the tax cost to import that material using the default cycle amount

Export Tax This will be the tax cost to export your completed product from that POCO at the required stage per cycle.

Total Sale - This is basically the full sale price of the item created at the current jita price. This value does not take into consideration of the previous stage profit that could have been made.

Jita Price - The lookup price from the TypID sheet to pull current prices. I'm search for Sale/Maximum

PI_Trader

Please feel free to keep an eye on my progression and also let me know if you have any features or improvements. I have basic skills in spreadsheets ;)

Fly safe

Update 08/29/2013

Organic Mortar Applicators - added
Recursive Computing Module - added

Update 08/28/2013

Integrity Response Drones - added
Nano-Factory - added
Welcome Page for Q&A - added
TypeID - Updated

Update 09/08/2013

With the release of the update most of my eve market queries were down thus why there has been delay.

POS Fuels - Added

I believe I can create a custom format to display isk I will look into that.

I agree it does not help on factory planets, but it does give you a rough idea what is worth making on the planet.

Thank you for your feedback

Bookmarked! Great layout, thanks for sharing and keep up the good work!

Thanks!

Sorry for the lack of updates.

I will finish the last production line this week. I'm also adding a WH reactions tab as well.

You should add a drop down that lets a person set their tax rate since the tax rate is the #1 deciding factor if an item is profitable or not to extract, manufacture and sell.

Sound Interessing but ... but what ... have se the new change ... of what ? High sec Custome office and mechanical
whats mean ?
have you see Dust and conquerable District Cost ?
if an Eve corporation shall managed a district for control Custom office ? how it cost It each day in Constested Time Zone ?
38m per package of 150 Clone for each wave and lot of 150 stuff trooper isk in dust .. and more in Eve ( custom office build and defense )

have you count expand of attack / defense security business in your sheet : lost ship for exemple too
so the Taxe and primary invest in planets are not enough for evaluate the cost of your production ;) lot of factor will be add

- Prices for all major hubs : price of what ? seller offer book or current echange price ?

for current exchange price we can't have an intraday value , juste an average value each day ...
he way to be traveled sowed(scattered) with trap in the work of evaluation of the production costs of objects in Eve... courage

Noted:the raw at 10 isk / pc are not a heresy if we count all random factor of rigor of space ...;)

Ps: there are difference between average price exchange with volume available at this price and necessary volume of your production (see the sell order volume statistique for That )
in some Ev market Agregator a indicator at 5% indicate low price but low volume , you need to evaluate over factor like average harmonic and more for ( ex : http://eve-central.com/home/quicklook.html?typeid=2310 ) and aggregate some market data are not good indcator for single market
and some other site truncated order sell providing some false date . so warning when you use them

OK I have now added the POCO tax for one of the sections "Broadcast Node".

The TAX value per item is based around the default CCP values as below:

PI Tax Rates
R0 = 5 isk base cost
P1 = 500 isk base cost
P2 = 9,000 isk base cost
P3 = 70,000 isk base cost
P4 = 1,350,000 isk base cost

The default POCO tax rate is currently at 0% which can be changed at the bottom of the table. You can also overwrite the tax value per resource section.

Please do check my calculations I done this while at work ;) Lazy day.

I also correct the amount of resources required for the next stage and accounted that in the values