Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Blademaster Hattori
Blood Raven Assault Squadron
0
|
Posted - 2013.08.28 01:33:00 -
[1] - Quote
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 - Export/import tax
Features to come:
- Prices for all major hubs - All PI items to be included - Buy orders to be listed
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 |
Halada
Explorer Corps Disavowed.
9
|
Posted - 2013.08.28 03:52:00 -
[2] - Quote
Bookmarking this, looking forward to see the finished product. |
Blademaster Hattori
Blood Raven Assault Squadron
0
|
Posted - 2013.08.28 14:55:00 -
[3] - Quote
Update 08/28/2013
Integrity Response Drones - added Welcome Page for Q&A - added TypeID - Updated |
Blademaster Hattori
Blood Raven Assault Squadron
2
|
Posted - 2013.09.03 14:28:00 -
[4] - Quote
Update 09/03/2013
Self-Harmonizing Power Core - added PI_Trader - Creating, designing and managing your PI sales market tool |
Blademaster Hattori
Blood Raven Assault Squadron
5
|
Posted - 2013.09.08 21:10:00 -
[5] - Quote
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 PI_Trader - Creating, designing and managing your PI sales market tool |
Invictra Atreides
Toward the Terra
136
|
Posted - 2013.09.09 16:57:00 -
[6] - Quote
I rly like the COLOR scheme you used and the design. I dislike the use of $ instead of ISK.
The Spreadsheet is useful for extraction planets. It can't be used for Factory planets.
Keep it up :) Always good to see someone trying a little bit of spreadsheets Blog |-áTutorials | Youtube "I donGÇÖt know everything, I just know what I know." |
Blademaster Hattori
Flying With Animals
6
|
Posted - 2013.09.09 18:18:00 -
[7] - Quote
Invictra Atreides wrote:I rly like the COLOR scheme you used and the design. I dislike the use of $ instead of ISK.
The Spreadsheet is useful for extraction planets. It can't be used for Factory planets.
Keep it up :) Always good to see someone trying a little bit of spreadsheets
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
PI_Trader - Creating, designing and managing your PI sales market tool |
Blademaster Hattori
Flying With Animals
6
|
Posted - 2013.09.09 18:38:00 -
[8] - Quote
Update 09/09/2013
Switched $ currency to a custom ISK currency as requested. PI_Trader - Creating, designing and managing your PI sales market tool |
Addica
Naval Protection Corp Subjugation
1
|
Posted - 2013.09.09 19:09:00 -
[9] - Quote
Bookmarked! Great layout, thanks for sharing and keep up the good work! |
Havoc Zealot
The Riot Formation Public Disorder.
51
|
Posted - 2013.09.09 20:46:00 -
[10] - Quote
was literally in the process of making this same exact thing myself, thanks for saving me the work...it's great :) |
|
Baggo Hammers
94
|
Posted - 2013.09.10 00:43:00 -
[11] - Quote
Thanks! If you don't know where you're going, any road will take you there. |
Blademaster Hattori
Flying With Animals
7
|
Posted - 2013.09.12 16:32:00 -
[12] - Quote
Update 09/12/2013
Nanite Repair Paste - Added Fixed a few formulas errors ;) PI_Trader - Creating, designing and managing your PI sales market tool |
Blademaster Hattori
Flying With Animals Mayhem and Destruction
10
|
Posted - 2013.10.30 17:55:00 -
[13] - Quote
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. PI_Trader - Creating, designing and managing your PI sales market tool |
Flinchey
Ministry of War Amarr Empire
0
|
Posted - 2013.11.04 02:53:00 -
[14] - Quote
awesome i've been looking for one of these for a few days! manually finding prices was a *****
easy to fix but HUGE flaw:
Polyaramids QTY 5 Profit26,975.00 ISK Total Sale44,555.00 ISK Jita Sell8,911.00 ISK
Genetic Enhenced Livestock QTY 5 Profit15,340.20 ISK Total Sale36,200.00 ISK Jita Sell7,240.00 ISK
QTY should be 10 going into P3, after the 5 out of P2....
>>>
Hermetic Membranes QTY 3 Profit130,445.00 ISK Total Sale211,200.00 ISK Jita Sell70,400.00 ISK
profit should be 49,490 over the P2's.. not 130,000
130,000 would be amazing, hundreds of millions of isk/day for no effort? yes please. |
Styth spiting
Ion Corp. NightSong Directorate
329
|
Posted - 2013.11.04 05:33:00 -
[15] - Quote
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. |
Styth spiting
Ion Corp. NightSong Directorate
329
|
Posted - 2013.11.04 05:36:00 -
[16] - Quote
Styth spiting wrote: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.
Also your values are wrong for each of the PI requirements for P4 items. 3000 P0 make 20 P1, but P2 items require 40 P1 in the P2. P3 require 10 P2, P4 require 6 P3 etc. |
Jdestars
Stars Research systems Incorporation
4
|
Posted - 2013.11.04 12:45:00 -
[17] - Quote
Blademaster Hattori wrote:Hello All,
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 - Export/import tax
Features to come:
- Prices for all major hubs - All PI items to be included - Buy orders to be listed
Layout Design
... Fly safe
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 ...;) |
Blademaster Hattori
Flying With Animals Mayhem and Destruction
11
|
Posted - 2013.11.04 14:22:00 -
[18] - Quote
Not sure what happened to my values. They were correct, however I did do a reload and i'm wondering if it loaded an incorrect version.
I can correct the values easy enough.
A drop down value would be a good idea, I will look at that. I don't pay POCO taxes so this is why that feature was on my list still. I originally created this just for personal use. But a few people in the corp said it was a nice clear layout. PI_Trader - Creating, designing and managing your PI sales market tool |
Blademaster Hattori
Flying With Animals Mayhem and Destruction
11
|
Posted - 2013.11.04 20:18:00 -
[19] - Quote
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 |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |