manufacturing

so i got some great help on a bill of material question a month ago. now that i have been running the new system, the bills of materials are not set up traditionally. Usually the whole bill is exploded with all levels. If i have a bunch of bills in a query that are not exploded in levels, how...

Trying to pull the Manufacturing cost index from an XML pull. The XML comes from https://api.eve-industry.org/system-cost-index.xml?name=Osmon I successfully used the WEBSERVICE function in excel to create and pull the data; <CODE>B2 = Above Link, C2 = System name (i.e. Osmon)</CODE><CODE>...

I have become reasonably adept at Excel over the years - mainly thanks from Mr Excel. However. I am a novice with Pivot tables. I am trying to extract & analyse product costs from 50k plus (and growing) rows. I also need to make it as simple to operate, using Macros & VBA if necessary as...

I am identifying component items which will be Made-to-Stock (MTS) for parent items which are Assemble-to-Order (ATO) for manufacturing purposes. What I would like to do is: In column A, list all of my items which are ATO In column B, compare the first 6 characters of column A to a list of...

Sorry about the long title. I work for a small battery pack production company. We are ramping up production and need to have documentation for each lot. I've been searching for a solution that, ideally, would allow me to print several copies of a BUILD TRAVELER with a unique number on each...