equipment

Hi all I am facing a challenge: I have few rooms with multiples equipment inside. For each equipment I need to answer 9 questions, there is only 3 option: red, orange or green. The list with all the equipment by room are built as bellow: <tbody> Room 1 Room 2 Room 3 Equipment X...

I have been asked to create a workbook that consists of approx. 70 different sites, each with their own sheet, that ppl can use for equipment tracking and projects. I have a "master" sheet with all of the sites and their assets and a pivot table summarizing the data from this "master" sheet...

I'm not even sure this is possible, but is there a formula that will calculate maintenance hours/miles/days in one column? I know that I can put in a simple C2+30 to get the 30 day date due and D3+100 to get the next 100 hour mileage due. But is there a way that I can tell excel to determine...

Hello, Gents, I facing the issue when trying make new workbook which must store our equipment operation and history log, the workbook hast two worksheet, in the first worksheet, must be something like entry form when you fill the form and hit submit( I don't know another method), data must copy...

Hi I am trying to set up a simple system to track equipment availability I want to place a number of command buttons on a screen which will change colour (green to red and vice versa) and change caption (UP to DOWN and vice versa) every time the button is clicked I also need to timestamp every...

I work in a program that tracks equipment. There are two categories of equipment, Main and Sub. Not all Main will have a Sub attached to it, but when there is a Sub attached it has the same Id as the Main equipment. The Main equip has the project number, task number, work date, start, stop time...

Guys I have the scenario below where I would like to create a loop to distribute along the columns (G column on) the date that that maintenance will ocurr based on its ID, Frequency and Due date. I will distribute it for a period of 01 year (365 days or 365 Columns) For instance, the...

Hi, I need help with this, I am stuck. I have this formula: =IF(AF2<>0;IF(AND(ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller spec"&"'!"&"P"&AF2);Indata!P2));ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller spec"&"'!"&"Q"&AF2);Indata!P2));ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller...

Hi Everyone! I know I'm close but I've hit a brick wall. I have a form where users fill it out and submit via email. There is a Hyperlink Mailto cell (O12:V15) that I want them to click and it generate an email with proper subject depending on cells within the form. Here's what I have already...

Hi All, Ive got a google sheet which automatically updates once my drivers log a fault with their vehicle. The action status of the vehicle changes from available to unavailable when the repairer places the vehicle in-progress meaning they are working on it. i then use vlookups to match the...

Hello! Looking for some help on an old mdb that some friends at a local horse barn had made for them in 1997. They recently purchased new equipment for their office, and are no longer able to use their report for printing #10 envelopes in the same way that the old equipment used to. Nothing...

First off I am new as of today to this board. Thank you in advance for your help. I know a little about excel but when it come to completing advanced formulas I need help. I am creating a set of three sheets for my company to help track our rental equipment and costs yearly. I currently have...

Good afternoon, evening or night, I have been working on modifying a sheet which has been in use for some time. It is a manually input sheet which has data for a bunch of different machines which are given number designations(1, 2, 3, 4, etc). Each of these units has equipment which is...

Hi guys, I need to find the smallest batch size of a product that is made on particular equipment So on the right I have Equipment 1 (Cell K4) and on this equipment, Product A and Product are made What are the smallest batch sizes of these products? The source table is on the left The results...

I am trying to format a report, but am having a difficult time. I have 3 fields that I want to display information on. Equipment Type, Model, and Serial Number. What I would like is for the Equipment Type be centered on the page and grouped. Under it I would like each equipment type (printer...

I have been away from heavy Excel usage for a couple of years, so I'm struggling to remember things! I need to subtotal col E for each category in Col D, but including them only if Col B contains "CA". I thought SUMPRODUCT might be the answer, but I can't get this to work...

Hi Guys, First of all, I would like mention that my knowledge in Excel formulas is limited to basic functions. My request might seem easy but I could not figure it out. I have two dropdown lists. The fist one is straight forward and gives a list of equipment. The second one is dependent on...

Good Afternoon Community! I have been helped countless times thru all of the posts on this forum (THANK YOU!) but I'm truly stuck this time. I don't have any experience with VBA so I'm trying to accomplish this all using formulas. Here's the problem: Problem: I'm trying to set up a Time in...

I'm trying to create a workbook that has a summary page as the first sheet, where you select a piece of equipment from a dropdown menu and have it auto-populate data about that equipment on the summary sheet. My roadblock is in trying to create a table on that "Summary" sheet that pulls rows of...

I'm not sure if this can be done or not. I have dug through the threads and google looking for code. I have multiple rate sheets that are named by client. On the sheets are the equipment we are going to use along with the rates we are going to charge. I don't want to just copy and paste the...