machine

I have an excel sheet with the following layout: My goal is to find each occurrence of a machine number that has a downtime equal to or greater than 4 hours and put that info Plus the reason into a separate table. I want to search by machine number find downtime =>4 and return each occurrence of...

Good day, Please assist, I would like to lookup a value for a certain date. Below is a sample of my data. The one sheet will have the contract data e.g. Machine no, date, contract data (is machine in contract for the specific month) <tbody> Machine No Date Contract 123567 01.01.2018 Yes...

Hey guys, Have a sheet with heaps of materials indicated by a machine ID - I'm doing a simple criteria search, which hides lines not relevant then copies and pastes this info to the corresponding sheet. Issue is for some reason... and it wasn't before it's crashing constantly. The code works...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi, I have an issue with adding pauses to a production machine schedule. I would need to say when will order 1 and order 2 finish. Here is an example for Monday: <tbody> A B C D E 1 Machine Start 06:00 2 Shift A Pauze 1A Start 09:00 3 Stop 09:15 00:15 4...

Hello Experts, I need you help to calculate max and min values Based on Designations. Any suggestion please. Thanks, Kamran Noor <colgroup><col><col><col></colgroup><tbody> NAME DESIGNATION PAYROLL SAIRA MALIK ASSISTANT 19,180 FAIZA ALI ASSISTANT 19,970 MUHAMMAD IMTIAZ...

I have column A with the date that a power tool has been reported as "to repair" and column B with the day the repaired tool was returned I have to calculate the number of days that the machine was not present. But... The broken machines are only collected on Tuesdays and Thursdays So, a...

I want to look up a primary machine number in a table. If the primary machine number is a match, I want to look at the grade number. If the grade number is also match, I then want to look at the customer number. If the customer number also matches, I want to sum all tons where the primary...

Good Afternoon, I am trying to run a Macro through excel without opening the Access DB on my machine. The Access DB is on a shared network drive that everyone in my company uses. The issue is that it is running on my machine but not on anyone elses. This is the code that I am using: Sub...

I am trying to calculate production capacity and have the following inputs: Product Group - overall capacity is limited by the bottleneck process Process Machine Product Type - some processes have machines have varying capacity depending on product type Production Shift...

I have 52 weeks as columns and 30 products as rows. There are 3 machine machine 1, machine 2, machine 3. Each product takes certain amount of time on each machine to get completed. Sales W1 W2 W3 P01 xx xx xx Processing Time in minutes Product Machine 1 Machine 2 Machine 3 P 01 0.6...

So, I am working with a sheet that has a certain number in each column KL-LM, only if the number in JX is different from the one in the row above. So JX3 is 1850, that means KL to LM will have this number times a factor. In JX43 there is 1450. Now as you can see in the screenshot, KF3 is 6607...

Hi team, I am building an analysis for output for a new machine. I am having some trouble with creating a formula that is adaptable to different ramp-up scenarios , ideally without the use of VBA. Scenario: A machine completes 10 processes a month @ 100% efficiency, but ramp up over the 4...

<tbody> <tbody> Dear all, I want to organise the data below on a different worksheet so that data for different machines in the column MACHINE is kept separately, for example Barbed wire machine No 1.(Kakuru) fault data is kept seperately in a specific column say A and the FRQ data is kept...

Howdy I have been provided with an Access database (mdb format) which links to - I believe - many underlying SQL Svr tables/views/queries in at least one (possibly more) SQL Svr tables. My problem is that I don't have MS Access installed in my environment. Whilst I can request it, I probably...

Trying to create a spreadsheet where the user can pick a Machine from one cell, then pick the Material to run in the machine from another cell and based on those 2 inputs the cost per Kg is shown in another cell. The idea is to use drop down menus for the selections. Is that possible to use Data...

All, Hopefully this is the correct forum for this question. I am working with some older systems and trying to automate some data collection. So far, for background, my path is: (1) there are (14) .txt files that are saved daily from our production floor (one file per machine) - saved to a...

I am needing to see how I can get info from a long list of items that has can have multiple items in the query. Here is example of my data: <tbody> store reg os model ram Tech Work Needed 1005 1 Microsoft Windows XP Professional OptiPlex 390 3240 Rick Florke RE-IMAGE MACHINE...

I have a sheet where I inserted a map as a background image. I put information in various cells based on their proximity to the map. Works great - on my machine. A coworker opened the same file on his machine and the background image scale was different in relation to his cells (I'm guessing...

Thank you ahead of time for the help. I have some vba code that has been working flawlessley on my machine. Essentially, I use vba to create an email and attach a personal signature from outlook. The part of my code that has worked and is now in question is this: SigString =...