material

Hello everybody, I am currently managing a list of materials for different sections: The top of the list looks like this: I have about 6 sections (EM, Formulering, Inspektion & more - please let me know if you want all the names). I want to create some sort of pivot table (I assume? I...

I am looking for a "less manual" way to do my current process. I have a sales channel "NHOM" or "NHAF" and multiple material groups "W01 or "W02" for example. I pick out the main material groups and then any others are grouped as "Other". There are different types and count of material groups...

Hello, I am producing a list of patterns references and each pattern needs to have a unique reference. Example pattern 1 is 100-1525/1525/8-001 and is made from a sheet of material 1525 x 1525 x 8 thick 100 = Denotes type of material 1525 = dimension 1 1525 = dimension 2 8 = thickness 001 =...

Hi Hope you are doing well!! I need to create an excel sheet for store support. Application details: I have a material which has a QR code and some Location racks with QR Code. Whenever i get the material to my store i will scan QR code in material and rack.this two data should be recorded in...

Hi There, I'm trying to multiply a cell within a table that I would input a number into by another cell and struggling with the VBA formula. For example, I would input 5600 into F2 and want it to multiply by D2 and display the result within F2. <tbody> A B1 C D E F G 1 material Desc...

Hello. I am trying to take the percentage based on plant and material number and segregate the handling units to two different plants. For example, in the information below, I want excel to look at another worksheet. if the plant and material match, plant 1 will get 20% of the total 5,801 and...

I have raw materials. I want to be able to get the finished goods total from the raw material reference. the raw material is in another tab. I am desperate. Any help is appreciated.

Hi, I have a list of products and associated dates. A product will have multiple materials and each material have a expiry date. Something like table below. <colgroup><col span="2"><col></colgroup><tbody> Product Material Material Expiry AA a 16-Aug-23 AA b 17-May-23 BB b 18-Aug-25...

Hi All, I am looking for help regarding forecasting future material requirement from finished goods forecast. I have this set up currently in excel with a few index and sumproduct formulas. However the material code within the finished goods can change depending on promotion etc, at various...

If I have in cell A1 this value [CLIN 0010 MATERIAL COST SUMMARY A3382276.xlsx] can I write a dynamic formula that uses this value? Sort of using a concatenate This is my formula. But I want to change it so that the part that says [CLIN 0002 MATERIAL COST SUMMARY B53388.xlsx] is dynamic...

Hi All, I need a Excel formula to calculate my selling price based on a predetermined profit. What is know is: 1) The final profit after all the cost ($20) 2) The item cost 3) The merchant fee which is 10% (0.10) 4) The payment processor fee which is 2.9% + $0.30 5) The shipping material cost...

Hi, I have a number of tables (in a single sheet). Each table has some properties (temperature, presssure) pertaining to a particular pipe material group. What I want is that when i select one of the material groups (in another sheet), it displays all the values related to that table underneath.

Hi All, I have a question about Pivot Tables. Not exactly sure how to describe this but I'll try It's about Row Labels. When there is one entry in a row everything is fine eg Material Number Sales 2019 Sales 2020 123456 555000 600000 But if I add a row in an...

Hello, I have a list with articles which have technical criteria. I would now like to have the criteria returned as text but the complicated bit for me is how I can show the different temperatures... I tried if functions but it didn't really work. Would anybody know how best to solve this? My...

The following table in PBI has price changes. I want to get a table of a) monthly date-wise weighted average price. maybe i could create a table in PQ for each date in calendar and then group. But how do i do in DAX, since there are many materials. b) simple average by material with considering...

<tbody> Finish Product code Finish Item Qty 2001 Burger 2 2002 Caffe tea 3 </tbody> <tbody> Finish Product Code Raw Material Code Raw material item Qty Sub Qty 2001 1001 Salat 0.2 ? 2001 1002 Sugar 1 ? 2002 1003 Caffe 0.7 ? 2002 1001 Water 0.9 ? 2002 1003 Tea 0.2 ? </tbody> MY...

Example: I have one item number ABCDE but this item number appears 3 times, on rows 1 through 3. Each row lists a different raw material off the bill of material, along with the budgeted tons. Material A 5 lb. 500 tons ABCDE Material B 1 lb. 500 tons ABCDE Material C 2lb. 500 tons...

I have a workbook for budgeting construction projects. Each element of a project gets its own tab (for example, walls, roof, floor, etc.). Within each of those tabs the user chooses a category of material from a drop down menu, then the actual material from a second drop down menu. Those drop...

Hi all, I am facing issue for match and interpolation of values as below. I need exact value and intermediate values if i select temperature and material group. <colgroup><col><col><col><col><col><col span="9"></colgroup><tbody> <colgroup><col><col><col><col><col><col...

I have over 800 lines of data. I am trying to create a forecast for each material based on the plant. I have consumption for two years. I want the forecast to be automatic so when someone enters the plant and material, the forecast is auto populated. Currently the issue I am having is how to...