search

gbrann / EVEProductionSuite

Eve Online - Production Suite is a set of Google and ESI tools to quickly and easily manage production, budget and basic corporate management with installing servers or adding any RL costs to your game play.
GNU General Public License v3.0
3 stars 0 forks source link

Industry Jobs not showing up in Corporate Stock #29

Closed gbrann closed 6 years ago

gbrann commented 6 years ago

Invalid vlookup formula on item name, was pulling from the wrong item ID, thus causing the lookup from Corporate Stock to show incorrect number of jobs.

Formula in GESI-JOBS, column W should be: =arrayformula(if(row(W:W),vlookup(R:R,VLOOKUP!A:B,2,false),IF(ISBLANK(D:D),"","")))

Existing formula was as follows and pulled the blueprint ID not the Item ID of the product it was making.

wytsa commented 6 years ago

formula has been changed to the above.