This is a great starting tool for anyone looking to investigate rough estimate profits on the fly
I seem to be having issues with some Items returning 0 for the prices.
I do use eve marketer api and I did see last night that it wasn’t returning prices on some items. May just have to wait it out
My taxes calculation was off by a very very small margin, I’ve just updated it and confirms it matches in games to the decimal. For those who dont want to reclone update the following:
Update the formula in F2 to be =((C2 * TotalSellFee) + (D2 * TotalBuyFee))
And then you need to click the little square in the bottom right hand corner of F2 and drag it all the way down to the last row of the F column to apply that forumla to all of F
Many thanks for this speadsheet. Tonight I’m gonna try to add a second column so I can have 2 vs 2 hubs instead of 1 vs 1, but I guess the drop down menu will be tricky
Not hard, but you will want to become very familiar with Named Ranges, as thats where most of the magic resides.
1 Like
Hi, great sheet but I had an old one with 1000 lines and I copied and pasted the items but although the typeid updates, all the prices do not?
I copied and pasted the rows but it wont go past row 153, any idea what I am doing wrong?
153 is the happy limit for google sheets, past that it gets grumpy
Is there another way I could get the prices?
My sheet has them and I use vlookups to pull the prices in for numerous items I build as I use a production line to build all components etc.
You can try expanding past 153. You just have to apply each columns formula further down
I have already tried that and all I get is N/A.
prioritise your products into relevant tabs.
great spreadsheet all what I needed, question about Markup tab, I have no idea what is it, confused.
Also is it possible to get the amount of items? I mean to input like 5 Hulks and see the net potential
A year ago, someone asked for a markup column and gave me this formula to apply:
nope actually just add a new colum, (profit total/cost)*100
Link about the difference between markup and margin
And as far as getting the possible amount of items for your example of 5 hulks, that would easier just to add yourself in a new column and very simple to do.
Just do a simple =sum(Cell1 * Cell2) where Cell1 is the cell you want to get ( I assume it would be the net profit) and have another cell where you input the count
Added in the Volume returned from the EveMarketer API.
Added in a FAQ page with some frequently asked questions
Did a bit of color redo to clean things up
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.