I have a group of employees that have results for various metrics. I want to assign a Score for each of these metrics based on specific values that their result is between. For example, one metric might be quality, and I might have scores 1-5 where 5 is anything greater than 98%, 4 is...
Need help in deriving Grade A to E using two sets of data.
Tried my best and stuck.
Please help in formula.
No macros please as I would share this file.
Example as below:
Grade Table to consider:
I hope I have come to the right place. I have been searching for the past several days for a solution to my conundrum and I haven't been able to find anything.
The company that I work for is...significantly behind the times in regards to data entry and computer use. I have recently been...
Hello! I am creating an Access report. Inside the report, I have created a box that will count the number of project inspections (based on Review type column) given a date. It is worthy to note that a single project inspection on a given day can have multiple findings. I am not interested in...
Need some help on a file that needs filtering though a drop down list.
Background: there are different quality of oil shipments that we are getting from the supplier vs the contracted quality that we agreed upon.
Every sample of oil is presented into a table called the crude oil...
I am using "ActiveSheet.Shapes.AddPicture" to import images into my worksheet, however the pictures decrease quality every time I did that.
Is there any way to set a better resolution or something that help this point?
BoolImage = True
Dim Imagem As Object
I have a column like this.
Quality Score: 5 (20180412)
Quality Score: 5 (20180220)
Quality Score: 4 (xxxxxxxx)
Quality score: 4 (20180713)
Quality Score; 4 (20180605)
I need to get just the scores in a different column so I can average them in a pivot base don toher criteria I have in other...
Hi Can anyone please help - I have to place a thick border in the entire row based on values in Column "A" until two or more cells contains the same value. if cell A2 & A3 have the same value so i have to place a thick border which will show that these rows have same values...
I am facing a live problem and hoping that someone can help me. I have 3 trucks and bunch of vegetables and fruits and I have to distribute these products in each of these trucks. The parameters that I have to check are Type, Quality and Availability.
Explained with the screenshot:
Hi, I have a gantt chart that I log how many high-quality products and low-quality products that are produced per day. How do I keep the get a sum with a criteria for each...
See below, I have used the following formula intending to retrieve the red bits.
instead, it Returns as:
I tried to Change the Format cells as Dates, it still won't work.
I have the code below which selects a range in excel and prints it to a PDF. The range is mainly made up of text boxes, graphs, shapes and 3 pictures. The quality in the PDF is excellent apart from the pictures which are poor (fuzzy) and let the rest down. Any ideas of how I could change the...
I have question regarding weighted percentages.
Apologies in advance if this isn't in the correct thread.
We currently mark our employees from 0 - 100 in what we call there quality score we then apply a weighting to get our new score:
Currently the weighting for quality 25 so we...
my table is like below
I need to count how many r there are for all process only for Quality (5)
I need to count how many r there are for all process only for SHE (2)
Many thanks for any help
I was hoping someone could help me please. I have been asked by my bosses to complete a macro started by someone else as I'm 'a bit IT'. I was a COBOL programmer in a previous life and that was 7 year ago, so have no idea about VBA code! Apologies if my questions are very basic. I would...
I am trying to use the value in a cell, A7, as the data validation range name for another cell.
I have created a range called "Category", which is populated with 3 values, "Quality", "Productivity" and "Value". I have also created ranges named "Quality", "Productivity" and "Value". Each of...
I need some suggestions.
I have a Form that will add records to a table.
These are the fields that will need to be filled using the form:
Reviewer Report Area
I have an excel sheet with multiple columns (A,B,C,D,E,F) below
I'm trying to modify some script that I found on the forum. As it is written it will go out to Sharepoint grab a specific file and save it to a specific path on my hard drive. I am trying to modify it to use a couple of values from the worksheet "MACRO" so that the rest of my team can...