material

I am creating a quote program for my work. The main page will be the specifications of the job, the second page will be all the formulas for calculating the costs based on those specification and various look ups. What I would like to do is have all of our materials and their associated sq in...

I have a packing table that I can have as many as 8 different materials used in packing a box. I have a table with the item listed and the charge associated with it. I have a column labeled as total material cost. How do I have the 8 different columns go look up the item and the cost...

Hi All, I have the following raw data: <tbody> A B C F G Material Bill Date Unit Price 14/05/2018 A 03/05/2018 323 A 10/05/2018 300 Material Unit Price A 28/05/2018 300 A 323 A 02/06/2018 278 C 1050 A 16/06/2018 210 R 500 C...

Hi everyone, Regarding my previous post, I googled a bit and something called Relationships and Data Model look promising to ease my pain. But I am not familiar with none of these... Well, I am relatively good with excel but very new to Relations and Data Model. I want to keep things simple to...

Hi, I am preparing a BOM project. Sheet5: Raw Materials Column A: Raw Material Code Column B: Raw Material Name Column C: Raw Material Unit (meter, kg, etc...) Column D: Raw Material Cost Sheet4: Semi-Products Column A: Semi-Product Code Column B: Semi-Product Name Column C: Semi-Product Unit...

Good morning, this may have been asked but I will proceed anyway. I have a spreadsheet that we use to calculate costs of material that include the following. Material cost + handling + freight = total cost. Material cost is variable depending on vendor and manually inputted. Handling is static...

Is tree representation possible in excel? Any material to read, examples?

Hello, I am trying to create a formula to rank product run-out dates of items with multiple conditions such as material type, size, etc. My sheet looks like below. I want to prioritize by run-out out date and then group material, then by size. I thought about grouping the run-out dates by...

Somewhere, I've got an error - and I cannot for the life of me figure out where. I'm trying to create a daily calendar sheet. Pick the day, and I have a simple sheet lining up all of the day's meetings to put atop a reference material for each one. To begin with, Table 1 has the detail for...

Let's say we have this data: <colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody> Part No ID OD OD +0.1 OD -0.1 L 196305 36.0 47.0 47.1 46.9 4.2 196306 75.0 90.5 90.6 90.4 6.3 220610 160.0 175.5...

Hi I'm after a bit of help with a sheet. I'm making a costing spreadsheet. Essentially the way it works is that a customer gives me a spec of a piece of material that they need. E.g. Material X, 80mm x 60mm x 1.2 thick. I have in stock, sheets of various materials in various thicknesses and...

Struggling with this one - I have a matrix/grid type setup for an entire product ranges' bills of materials. What I want to do is return every named instance of an individual raw material, based on matching a part number. In addition, it needs to return said raw material name only if the usage...

I have realized that I go through a cycle of writing basic macros every so often at work. I have pieced together some more advanced over the years but have since forgotten them. I have a basic form that I want to automate into a sheet that can be used to input data into an access database. Due...

What formula do I use to have Excel look at 4 columns (D,E,F,G), the first three (D,E,F) are material size, the fourth (G) is the total of the parts for the material size. I figured it'd be SUMIF, but I can't figure out how to link the first three cells without using TEXTJOIN and creating a...

Imagine you have a very long roll of material, (Rolled up like a big spool) and out of that material, you cut sections of material out of it. For an example, we're dealing with a 72" wide piece that's 1000' Feet long. If you were to never cut anything from it, and look at it as if it was...

This is probably easy for you folks. I have a tab, "Request Form" where the customer will place the material they're requesting along with quantity and unit of measure (B3, C3, D3). The first tab, "Items Not To Move" has a list of materials that they are not permitted to request. So here's my...

Dear all, Formula required: if material has same price count should be 1 , if it has multiple price that count should be shown in result column. <colgroup><col style="width: 48pt;" span="3" width="64"> <tbody> Material Price Result X 2 1 X 2 1 X 2 1...

Hi experts... I have an excel with 9 columns as sno/material name/qty/unit/buying price/value/selling prie/value/margin% I just put filter for all columns and filter the data in each columns. Finally, after referring the required information, i removed all filters.. Now i find that some...

Hi There, I am in need of help. I have been working on this issue for quite some time and I am just not experienced enough in Programming with VBA to complete my task. I have to merge 2 worksheets together in one workbook. The first sheet is a Bill of Materials - Titled BOM - Sheet 1 the...

Alright guys, I feel a bit embarrased to ask help for conditional formating, but I have tried and tried to make this work out myself but I cant accomplish anything. I am just stuck. I need to do some multiple condition formating here. I have categories which take part of a material inventory...