metrics

Hi, We've got a fleet of 58 vehicles that we used to manage by registration, so for example we would get individual requests per vehicle for MOTs, servicing, breakdowns, repairs etc. Every entry is tied to an individual vehicle, so there are hundreds of entries but it's fairly straightforward...

I have two tabs in a file. One tab has different facilities and their associated metrics (8-10 metrics). Each metric value is conditional formatted using color schemes option. The second tab is a report which has a drop down to select a facility. Depending on the facility selected, all their...

Please help me update the code below so that the counts work on the ranges of numbers (arrows below) Thanks! Sub Metrics() Dim ws As Worksheet Set ws = Worksheets("Master") '' Total = Application.WorksheetFunction.CountIf(ws.Range("i:i"), ">0") Zeroto14 =...

Can someone point me to code that uploads a file to Google Drive? I have many metrics that we want to automatically post to the cloud.

I pull the below report from our internal application. It gives the performance of various employees based on different metrics. Data is pulled for minimum 60 days time for which I need to sum up and average by dates of all individual metrics such as Metrics 1 Performance on a particular day and...

Good evening everyone! I'm needing help again with my code because it is now giving me an out of memory error. I've been researching this error for the past few days and the only thing that I've found that remotely helped was saving the file after every few sections. Please see below for...

Hi all. Can someone show me how to get the screen metrics when using a 64bit version of Excel i.e. where do I use "long" and where do I use

I want to track performance of my service techs. I want to measure them monthly by service request turnover and average age of service requests. Turnover is how many new requests were generated during the month and how many were closed. Target is 100% Average age of service requests is how many...

I'm trying to figure out how I can calculate certain sales conversions in my Sales Pipeline automatically. My pipeline has the following statuses: Lead -> Enquiry -> Tendered -> Awarded. For instance, I would like to know which projects that has converted from Lead to Enquiry. My data file is...

Hi Team, I have been asked to develop a visual display of metrics from data in a weekly status report. We have a ongoing list of high priority items that each have their respective updates and due date. I need to create a "dashboard" possibly... that keeps track of these due dates and provides...

I have fields "Day", "Posts", "Impressions" in a pivot table and I need to create a new metric for the average Impressions per Post. Ideally, this new metric should function just like the other fields in the pivot table, and not just static, because I'd like to break it out not just by Day, but...

Hi, I am having an awful time figuring out how to recreate the chart included in the picture below. This shows a data series and then two bisecting lines for yearly metrics. I am helping a friend recreate this, and she says she was once able to get it, but couldn't get the 2011 line to go to...