Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Unnamed Child
Gallente
|
Posted - 2009.08.05 12:07:00 -
[1]
I propose you an xls file made by myself which will help every Mission Runner. I'm a caldari navy mission runner. So I wanted to know what to buy at LP store and to sell at the market/contracts to get most profit from my LPs. As for now, LvL 4 and LvL 5 mission runners have a lot of LPs. And a lot of ppl just dont know what is better for them to get.
Here is a screen shot, where you can see part of my table. I made this file which includes ALL modules, implants and charges from Caldari Navy LP store.
screenshots:
http://eve-files.com/dl/202757
http://dl.eve-files.com/media/0908/screen_1.jpg
As u see on the screen my programm shows what is included in calculation. Example1 caldary navy invul programm calculates the ammount of needed LP, ISK, Price and quantity of modules needed ty by (jita price used). and the lowerst price we can sell it (at contracts). Then programm calculates the price of 1 LP which we spent on buying caldari navy invul. at this point we can look at what is better for us to get at the LP store.. iplants, modules or charges.
All you need to do at this programm is to refresh price for a module you want to see a price of 1 LP. At the moment you agree to get a programm and help me with some isk in eve I'll send you this file with ALL modules, implants and charges PRICES already REFRESHED. So my advice would be to choose 5-10 most interesting items for you and refresh them once per 2 weeks.
A Dev coder is also invited to help me make a nice look of it and help make price refresh update. There are also other ideas to implement.
If you agree to get this program: - isk from you From me: - this file - all prices for Caldary Navy refreshed - video+voice file at which I'll tell you how to use it or what to do - also will include some advices at what is better to sell and what will get you a better profit but will take longer time.
This file is targeted at lvl 5 mission runners, but is totaly affordable for lvl 4 runners. It gives you real difference in income form LPs. Thnaks for your time reading this, feel free to discuss, I'll include more screenshots if needed. Look for me in EVE by the name of "Unnamed Child" FS
|
Psychotic Maniac
Caldari Head Shrinkers
|
Posted - 2009.08.05 17:09:00 -
[2]
if your program is any good then peeps will give donations. selling it wont work as well.
|
Unnamed Child
Gallente
|
Posted - 2009.08.06 20:06:00 -
[3]
thnx m8, thats i'll probably do just that
|
Seraph Castillon
Gallente
|
Posted - 2009.08.07 07:58:00 -
[4]
Edited by: Seraph Castillon on 07/08/2009 07:59:14 Don't publish it freely. You'll ruin it for those of us who actually make the effort of finding the better items.
|
Dibsi Dei
Salamyhkaisten kilta
|
Posted - 2009.08.07 09:47:00 -
[5]
Sounds cool
Are you going to add other lp stores?
|
Unnamed Child
Gallente
|
Posted - 2009.08.07 11:10:00 -
[6]
I'll think about publishing, thank you for your opinion. About other LP stores - It a lot of job and I need motivation to do it. Im here only to play the game, so I dont ask real money :)
|
Sytoru Hiroshyma
SkillzKillz
|
Posted - 2009.08.07 12:40:00 -
[7]
It's not *that* much work to add the other LP stores. Hell, start with high sec only and you only need to add another 4 and most of the work should have been in getting the actually calculations set up correctly.
|
Unnamed Child
Gallente
|
Posted - 2009.08.07 13:52:00 -
[8]
Calculations are already done, checked and I'm using them now. Now the only tning I need - is info form other LP stores (and Jita market as the 1st place to sell - btw we can add prices form motsu and other large markets).
|
Carniflex
Caldari Fallout Research Fallout Project
|
Posted - 2009.08.07 15:44:00 -
[9]
Originally by: Unnamed Child Edited by: Unnamed Child on 07/08/2009 13:58:42 Calculations are already done, checked and I'm using them now. Now the only tning I need - is info form other LP stores (and Jita market as the 1st place to sell - btw we can add prices form motsu and other large markets).
Originally by: Sytoru Hiroshyma It's not *that* much work to add the other LP stores. Hell, start with high sec only and you only need to add another 4 and most of the work should have been in getting the actually calculations set up correctly.
Can you, or anyone give me a list of MOST USED LP stores plz.
The most used LP store is propably Caldary combat branch. And it's not "only" 4 corps. Every faction has 3 different "flavors" of LP store, a combat, exploration and industry store.
You can find LP store offers here.
I already have a spreadsheet that takes tag costs as input data and lists me offers according to isk/LP for me. One needs still to apply common sense when looking at those offers ofc, as while for example medion amarr cap injector BPC offer might look to have uber isk/LP it can be very time comsuming to actually get isk thru that item.
What would be really interesting tho would be some kind of program that can automatically get the item and tag prices from some external website and do the calculations. For me atm is somewhat time consuming to go over contract prices to see what are the current prices and also keeping eye on the market in general to see what items have actually volume to be able to take the amounts of LP I might be looking to cash in.
Good initiative overall.
|
Mme Pinkerton
Caldari
|
Posted - 2009.08.07 15:54:00 -
[10]
Edited by: Mme Pinkerton on 07/08/2009 15:54:17
Originally by: Carniflex What would be really interesting tho would be some kind of program that can automatically get the item and tag prices from some external website and do the calculations.
At least when using Excel 2007 (don't know how it's done with other versions) you can import (and refresh) price information via XML from eve-central rather easily (data tab -> "From Web", enter XML query in the address bar).
" Credit is the economic judgement on the morality of a man. " |
|
Unnamed Child
Gallente
|
Posted - 2009.08.07 18:30:00 -
[11]
Originally by: Mme Pinkerton Edited by: Mme Pinkerton on 07/08/2009 15:54:17
Originally by: Carniflex What would be really interesting tho would be some kind of program that can automatically get the item and tag prices from some external website and do the calculations.
At least when using Excel 2007 (don't know how it's done with other versions) you can import (and refresh) price information via XML from eve-central rather easily (data tab -> "From Web", enter XML query in the address bar).
I'll try it tomorrow m8. And thank you all for paticipating. As soon as I'll finish the caldri navy store (polish it and check for mistakes), I'll think of making it look more comfortable to use for a ragular user.
|
Unnamed Child
Gallente
|
Posted - 2009.08.08 19:28:00 -
[12]
Got some customers already. I've agreed not to sell a lot of copies. so 12 more left.
50kk per 1 copy. contact me in game via Private massage or eve-mail.
|
Unnamed Child
Gallente
|
Posted - 2009.08.09 18:22:00 -
[13]
I've made some impruvments: 1. Made it look better 2. Refreshed prices for Caldari navy agents 3. added gallente lp store calculations 4. added single item/module calculations 5. sepurated attribute improvement implants 6. separated other implants
Feel free to convo, addition of any other LP store is not a problem. Got ideas? - feel free to write them here or convo me ingame or eve-mail me.
|
Contralto
GCHQ
|
Posted - 2009.08.09 21:23:00 -
[14]
Took delivery of the spreadsheet tonight, looks good initially, will have a closer look tomorrow, can see many attractive items, the Caldary store is way better than the Fed Navy though! many items that return over 2k per Lp.
Got a bit of Cyrillic to clean up and a few typos but the format works well.
|
Unnamed Child
Gallente
|
Posted - 2009.08.09 23:05:00 -
[15]
Sorry for that ppl. I'm Ukrainian. (speak russan, ukranian and a bit english) :) I was making this file for myself and my friend, but at the end thought may be some ppl would be interested in it.
|
Forranz
Shadow of xXDEATHXx
|
Posted - 2009.08.10 00:09:00 -
[16]
Edited by: Forranz on 10/08/2009 00:09:54 So I'm a little confused, 50k isk (50,000 isk) or 50,000,000 isk (50 mil) for it..
and if you added the Amarr LP store I may be interested. Is it all the items? How accurate is it ?
|
Unnamed Child
Gallente
|
Posted - 2009.08.10 00:41:00 -
[17]
Edited by: Unnamed Child on 10/08/2009 00:43:18 Edited by: Unnamed Child on 10/08/2009 00:41:41 At first I had only caldari LP store (because I run it). So I charged 50 mil isk per it Got a customer with a proposition to make Gallente, I added it and he payed me 100 mil isk for it. I won't lie, I got plans to make ammar and minmatar tables. But it dipends on my free time. If you would like to perchase an ammar table, I'll finish it tomorrow. Lot of time takes filling in stuff (all fresh prices).
How accurate is it. Well when I look at items I can see: 1st will give me 380 isk per 1 LP 2nd will give me 1045 isk per 1 LP 3rd will give me 1350 isk per 1 LP and so on (it counts every isk). Right now prices are going up every day.But the best deal changes every time. During last 24 hours I helped my corp mates to spend total of 3 million Loyalty points. My part was 100 isk per LP. You may eve-mail me, and say what are you going to get from LP store and I'll is it a good deal. If it wil be from caldari or gallente store i'll tell you how much higher you may get a deal. Then you may diside is it a good idea to get the file. Also, I am still making it better every day. And any update will be free (most probably update will have fresh prices). If not you can hit me with eve-mail and we shell talk bout refreshing prices privatly for you.
Plans: 1. Want to add columns to count revenue form deal if you want to take 5..10..100 items of the same type from LP store. (example: you want to perchase 5 implants from lp store, - so it will show total revenue). 2. Also when you have 5 imps, and want to "instant sell them" you look at buy orders. I'm thinking of adding extra table which will calculate: 2 imps by 1000 isk, 1 imp by 1200 isk and 2 imps by 1500 isk). So I want my file to give you total avarage income from a deal. So you can see at what price you should stop buying implants and start looking other item to sell from LP store. 3. Want to add "buy order" column. If you put your items for sale they will take more time to get sold, but give you +20%-+40% income per 1 LP. It will take a lot of time to get prices from market, but it shell give result. 4. I want to add "sales TAX" calculation. Different people have this skill at low levels, so they pay up to 1% of total sale ammount. I want them to know where thier money go and what ammount. May be people shell desire to learn a skill a couple lvls.Sale tex % will be needed to enter 1 time and only modify any time you learn the skill. 5. Wish I had free time to add ammar and minmatar LP stores. If I'll get a 100 mil order, I'll add it in 1-2 days from the time I got order. 6. I'll make it look better, It shell look a lot smaller. 7. I want to add "favorite items" ****. But dont know how right now :) Dont want ppl type all by hand. They pay for service lol. :) 8. Lots of other stuff (like get rid of cyrilics :), fix some mistypes)
Any ideas welcome people! Customers welcome even more!
|
Forranz
Shadow of xXDEATHXx
|
Posted - 2009.08.10 00:46:00 -
[18]
Well, in excel there are ways to do certain things
If you want a formula to depend upon 1 cell and never change, you just specify it: $H$13 (You use the $ symbol)
It would take me a few minutes to get use to excel again but if you're wanting the amounts to change, have them depend upon that one cell -- its easy to setup.
|
Unnamed Child
Gallente
|
Posted - 2009.08.10 00:57:00 -
[19]
I know and use a lot $ symbol. But thank you. I want over 800 lines to dipend in 1 sell. :) so player will only enter something like .. item 137 and he'll get its full info in the line near the sell. Excel 07 includes only 57 formulas one into enother. So I'm thinking of some other way.
Thnak you for you post!
|
Unnamed Child
Gallente
|
Posted - 2009.08.10 15:52:00 -
[20]
Edited by: Unnamed Child on 10/08/2009 15:53:19 ok, did some work, so now we got:
1. Caldari LP / isk calculations 2. Gallente LP / isk calculations 3. Amarr LP / isk calculations
4. Single item calculation 5. Attribute enancers implants LP calculation 6. Other implants LP calculation
Didnt get yet purchace for Minmatar or pirate LP stores, so didnt add them yet. Now working on making it easier to use, better look etc.
|
|
Unnamed Child
Gallente
|
Posted - 2009.08.11 22:30:00 -
[21]
I've added a video, where I'm showing parts of my file, also talking bout some stuff I want to add and at what I'm working right now. Feel free to ask any quastions. I'm open to your Ideas :)
Video+voice comments (154 Mb)
|
Unnamed Child
Gallente
|
Posted - 2009.08.19 20:08:00 -
[22]
in 2-4 days Minmatarr LP store will be added. Also, I'll do my best to add new Items which will come with apo 1.5 patch
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |