production

I have a table of production and I would like to be able to show one person how they compare to other doing they same work without showing the other names. For example: steve compare to person 1, 2 ,3 and mary person 1,2,3 without making a separate table for each person.

Sorry but I have not got an access to these platforms. I will attempt to express the requirements herebelow. Basically what I'm trying to attempt can be summarized in the below chart: <tbody> Reference Country Product Range Warehouse Production month Previous Quantity New Quantity Changes...

I have a report where I need to calculate daily sales * production / monthly production. I get it by flattening three tables this model (here's the file, in case you would like to take a look): ... into this model, using Power Query: It works a lot faster than the original SUMIFS and...

Dear Reader, I have an excel problem of which I hope some of you could help me with. For the company I work at, I want to extend the current master production schedule (in excel) with hypothetical values. For instance, the amount of production starts for the coming 6 months is defined (customer...

Hello All, Just starting out in Excel and am working on a real-world case. I work for a company with several production lines. Each line has a team leader, at least one controller, one maintenance officer, and several production line workers. These workers are classed as A, B, and C level...

Full disclosure: I'm a finance guy in Oil & Gas and I use Excel for modeling purposes. Basically I'm looking for a non-array formula and non-VBA UDF formula that can accomplish the below: <tbody> Month Wells Production Total Production 1 9 16,500 181,500 2 9 11,939 119,391 3 10 9,529...

Hi, I am looking at resolving the issue below. Can anyone help? Shipping work has been printed off and you have the line volumes for each work area, but the labour planning tool is not working. You have a 45 minute window (3 cycles) to process these orders before they need to be handed off to...

Hi all, I have a workbook that logs daily production totals. I am able to count totals for production between dates but for the life of me are unable to figure out how to count the employees. I'm using =SUMIFS(DataBase!H:H,DataBase!A:A,">="&$P$1,DataBase!A:A,"<="&$P$2,DataBase!S:S,O4) to...

Hello all, Could you please help me find a solution to a problem that i have in Excel? I don't know exactly if this could be achieved in Excel, so any ideea would be highly appreciated. So, i have a very big production sheet. - On column B i have the dates (in this format: 01.01.2019...

<tbody> </tbody> I have a production schedule that I need to modified from 24 hours per day / 7 days a week to 12 hours per day / 5 days a week no weekend. I cannot figure out how to count for the weekend. I am able to adjustment the hours on schedule if we are ahead or behind in...

Hi everyone, I have pulled together a Pivot Table for associates across several years showing production data by quarter for each. The way this is displayed is by "financial year" and then "quarter". Column labels have associate name (John Smith) & Row labels have FY and Q (FY2015 Q1), with...

I have a data connection that pulls production data into an excel sheet and then I use that data to create an hourly production board. My IT department is URGING me to reduce the size of the connection. In an effort to do so, my thought is to pull less lines of data with each refresh, but I...

On my userform I have two combo boxes and one read-only textbox. In the first text box the user selects a machine production line. Based on the machine production line selected, the second combo box will populate with the products that are ran on that line which is located on a spreadsheet named...

I'm attempting to create a command button that will send the current sheet to someone as an email, but when I click the button nothing happens. Here is the code, and I'm not sure if I assigned it properly. Excel 2010. Thanks for the help. Sub Send_Range()...

Hello All, I am trying to build a spreadsheet to generate sales commission if their production is over a certain amount. For instance, if they produce $1.25mil they get $1.25 per thousand dollars if it below $1.25mil it will be $1 per thousand. So if they do the $1.25mil their commission...

Hi I have a workbook we use for prep and production at the Lobos Stadium here in New Mexico and the workbook has about 12 worksheets that are associated with the stands we have that call production(requisition product). There are like products on several of the worksheets and I am using a...

Hi, I am trying to fill in a formula (depending on the if then statement) down an entire column. My macro works for my first selected cell but does not continue down to the last row. I want the logic to continue down through until the last row. My macro is below. Dim sht As Worksheet Dim...

Hi, I am in need of a VBA code where it search a column based on multiple conditions (Check condition 1, if fails go to next condition.... and so on) in other columns and returns a unique list. Below is the table which explains it better: <tbody> Name Emp ID Date Task ID Production count Task...

Experts, I need you... I have no idea what I'm doing here. Sheet1 Column A = Production # Sheet 2 Column B = Kit # Sheet2 Column A = Production # Sheet2 Column B = Kit # (multiple values in single cell) I need to lookup the production # in sheet 1, match it against the production # in sheet2...

I've got a date measure that works with some operators but not others. Perhaps someone can tell me what I'm doing wrong in formatting? I get an error that the date measure is a text measure and DAX cannot compare text and dates, but only for certain operations. I've got an inflation formula...