EVE Technology Lab

Hey guys, i have created a spreadsheet that lists every blueprint that you could buy with LP and the prices and all those shenanigans. (I buy concord lp), and part of buying the blueprints is the tag market. I have recently came into a problem that essentially screws with the prices.

For reference this is the formula i am using. B19-B25 has a list of typeid's

=importxml("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid="&JOIN(",",B19:B35),"//sell/min")

I need large quantities of tags (90 tags for example). I currently do not have enough isk to setup buy orders so i buy the tags when i need them. If there is a low sell order of 30 tags for 2million, and then the rest of the orders are around 3million per tag, it ruins the calculations on the sheet. It says that you could buy 90 tags for 180 million, but in reality, it would cost 240 million.

In eve central, there is a parameter called "minq" which specifies the lowest quantity needed, but for the most part, for the amount of tags i need, they aren't in a single sell order (ex. I need 311 tags, there are sell orders for 40, 30, 79, 75, 56 ect.) and if there IS a huge sell order, the price of them is so large that it wouldn't be accurate at all.

Is there some sort of "average" parameter in eve central? I wasn't able to find one, and if someone could give a hand that would be amazing.