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...
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
Hope you are doing well!!
I need to create an excel sheet for store support.
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...
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.
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 a list of products and associated dates. A product will have multiple materials and each material have a expiry date. Something like table below.
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...
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...
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.
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
Material Number Sales 2019 Sales 2020
123456 555000 600000
But if I add a row in an...
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...
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...
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.
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...