performance

Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance, Sheet 1 “Supplier...

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I...

Dear all, Greetings! MY concern my excel sheet is getting with late performance, even though file is below one mb. Need VBA code to boost the performance of excel sheet.

Hi, I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example: In Category 1, Customer A had growth of 2% in the market but our business...

I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery. My data is: 1st 2nd 3rd 4th 50% 67% -55% -78% Keep in mind that positive % =...

I am trying to create a tracking system for the data below. The macro will run in the first tab and track the data from the second tab. I need the macro to match the sections then look up the date from the first tab and determine which date range it falls into on the second tab. Once it has...

Hi, I am trying to automate a monthly investment commentary where I would write predetermined sentences in Word with certain portions of the sentences being left blank and meant to be linked to cells in an Excel worksheet; somewhat similarly to a mail merge greetings linked to an address book...

Hello all, Working on a Footy Performance selection EXCEL 2010 matrix to enable experienced assessors to record player performance and then select a team of performing players. The formula I am trying to use is not working correctly but I cannot find the error...

Hi! I have a workbook that has a dashboard of my organizations performance data separated by individuals. I have a slicer that includes the names of the individuals so I can toggle in between everyone’s performance metrics. Is there a way that I can somehow password protect or reorganize my...

Hello I have an ISO 9000 Requirement to track Vendor Performance. I need help tracking performance in Percentage on on time delivery. Pivot table: Requested Due date: C7 Vendor Name: D7 Date Received: O7 Performance Rating: P7 (Unable to determine % based on Completion dates Vs Due dates.)...

Hi, I'm new here. This is the situation: In my office I have 2 pc with very similar configuration. 16 GB ram and similar CPU (I7 4790 vs I7 6700). When I try to update, or simply put or remove a filter on a column the performance is very different. For example, If I insert a filter on a column...

So Im working on a sheet to measure performance in our warehouse. A1=226 cases per hour B1 = 74% (performance) In order for me to see what A1 would look like if B2 were 100% I make a formula like this "A1/B1" which equals 306 cases per hour. That's all fine and dandy, but what if i want to...

Hi, am hoping someone can point me in the right direction... I have created an excel based audit tool for hospitals. It takes scores from staff and managers in response to around 30 questions. These are combined and triangulated to produce a lovely dashboard / performance summary... All good so...

I've spent a lot of time trying to optimize my workbook (which streams in a high-volume of real-time stock quotes) for speed, e.g.: (i) getting rid of resource-hogging dynamic functions, (ii) and particularly hardcoding values wherever possible (with macros that calculate formulas and then paste...

One tab on an Excel spreadsheet is running very slowly. When I go Find & Select, Selection Pane, I can see there are at least 50 shapes, all called "AutoShape 140" (no idea where these came from). Whenever I try to delete any of these (even individually), Excel crashes. I have tried...

I have a relatively large (8MB) workbook that pulls in tick-by-tick stock market data (hundreds of symbols at a time) via DDE API and runs a ton of formulas. I've optimized it as much as I can (no dynamic formulas, hardcoding wherever possible) and performance is passable but not great (3-5...

We have a macro which as the below code. The code is suppose to superscript the text which appears after the year. It fails when the month changes. It was working fine when the month was May/June/July. Is there a better code to raplace the existing code? Sheets("review").Select...

Hello All :biggrin: I have a spreadsheet I use to pay our employees on a 4-weekly basis. We also include a production bonus, which we're modifying to a performance based one. My head is a little pickled!... I have a cell with a "Bonus Pot" for the month - this is the ££ figure I have to share...

Hi folks, I have the following lookup: =INDEX('[Form-0439 Vendor Performance Assessment 2016.xlsx]Revised'!$AU:$AU,MATCH(A:A,'[Form-0439 Vendor Performance Assessment 2016.xlsx]Revised'!$B:$B,0)) What I want is to change the lookup each year to reflect the year in the form name. I was...

I need the fastest way to look across a range of cells where each cell in the range contains a long string to see if any words in a list occurs in any of those cells. The first thing I did of course was to read the range of cells into an array, then I loop through my list (for each item in...