kpi

  1. H

    Workday formula - adjust for a zero occurrence

    Hi there, I have a formula that calculates the KPI days from the date deemed adequate. =IFERROR(WORKDAY([@[Date Allocated or Adequate]],[@[DPE KPI(working days)]],Holidays),"")............ returning the DPE KPI Target Date. If the KPI working days (returned from a vlookup) happen to be zero I...
  2. I

    need help with a sum formula

    Hi guys i have kpi results data below for one person <tbody> Name Alex win rate 56% renewed 5% answered 25% over all Score </tbody> I need to create a formula or come up with away to calculate the over all score. To get the over all score you need to score each kpi first and then...
  3. F

    Show target missed for last how many months

    Hi, I have a KPI dashboard where I have data from 2016 onwards. Each KPI data is organized in each row. KPI name is placed in A column and it's target in B column followed by monthly achievements. I would like to know for how many consecutive previous months the target is not achieved for...
  4. P

    Kpi dashboard

    Was just assigned a project at work to create a new executive financial dashboard. I know the forum is focused around specific questions. My question is does anyone know of free resources that could help me get started? I tried searching the web but all I see are companies selling their...
  5. S

    help required : how to retain previous cell value and showing new formula result

    Hi Folks.Hoping somebody here can point me in the right direction or provide a little assistance with a little quandary I've now found myself with.I run a daily KPI sheet for various sections of my workplace and we have a rather large workbook (30+ sheets) that runs myriad of statistics for a...
  6. S

    KPI/SLA calculation

    Hi all, I've got following issue: i need to determine KPI %. The KPI is about exceptance time, i've got two date/time column (ticket received (column L) and ticket accepted (column AC)) that i have to match, the threshhold is 4 hours (within 4 hours is positive, above for hours is negative)...
  7. S

    Copy and paste multiple ws from wb1 to corresponding ws on wb2

    Hi All,I'm relatively new to VBA and am reintroducing myself to it again now after a short hiatus.My current situation sees me compiling and producing reports based on data we get output from Oracle datatbases. Currently we run an Oracle report that contains multiple worksheets and export them...
  8. T

    KPI - Help required

    I need assistance on a formula to return the KPI scores based on the weighting on the below: The formula should read the number on under detail which in row 1 is 31 and return a kpi score from 0 in line 1 as per the scoring criteria. A <colgroup><col><col><col><col><col...
  9. B

    Sparklines -'Data source reference not valid'

    Hi, I've never used sparklines before and have been asked to include them in a dashboard. That has a large number of KPIs so I'm trying to create dynamic sparkline that I can create against the first KPI and copy against all other KPIs I've got a formula that will, upon error, show me its...
  10. D

    "The Slicer Cache already exists" error macros

    hi all, Im working on a macros involving different pivot tables and slicers. When I run the following: ActiveWorkbook.SlicerCaches.Add(ActiveSheet.PivotTables("sAPivot"), _ "KPI 1 Percentage").Slicers.Add ActiveSheet, , "KPI 1 Percentage", _ "KPI 1 Percentage", 155, 490, 145, 200...
  11. Z

    Auto-Generate Graphs with standardized data

    Hello, I am need to create about 60 graphs for some data I have in a workbook. As I said in the title, my data is standardized. The thing is, I simple have no idea how to approach this since I have never dealt with something like this. My data, normal range, goes like this: <tbody> KPI...
  12. Weeble

    Large amount of data and where to store it

    So daily I pull out a pretty large amount of rows with data for our weekly KPI reviews. The rows can be as long as 20k. What would be the most efficiant way of storing this amount of data? I was thinking of PowerPivot tables, but having problem with IT section to get PowerPivot in to Excel...
  13. T

    Creating scorecard using conditional formatting

    In "b2-B40" I have cells that have background color as yellow and is a 3 point deduction for not meetin Kpi, if background color is red than 7 point deduction for not meeting Kpi. In b50 would like code to calculate score by deducting Kpi error points from 100. Thanks for help,
  14. N

    Pivot Table Different Data type in the Same Column

    Is there any way to have different data type within the same pivot column. I have an report where the columns are in months and the columns are different KPIs. Based on the KPI, I'm switching between a number or a percentage. In the pivot chart, I would change the data type when I filtered to a...
  15. A

    Data connection opening read-only files on refresh

    Hi there First time posting a question – I’m usually a scavenger on this (and other) forum and always seem to find an answer to my question. This time, I’m stumped. This is my first time using data connections, but a brief outline of the setup. There are more connections, but the issue is the...
  16. B

    Change Custom KPI value to previous month Value if Current month value is not available

    Hello All, I have created the custom kpi using below measure. PlanArrows = IF(ISBLANK([PlanSum]),"No Data Available ",[PlanSum])&" "&IF([PlanSum]=[PlanPrevMon],"",IF([PlanSum] > [PlanPrevMon],UNICHAR(8679),UNICHAR(8681))&IF([PlanSum]<=0,"",""))And it works fine for me for perticular month...
  17. B

    KPI with different targets

    Hi, I have no problem setting up KPI using set value. However, I have different targets every month. I can't just change the set value every time I want to view the month. Please help. Any Idea how I can approach this? I tried adding target value to my raw data and sum that column as one of...
  18. Z

    Please Help-Urgent! How to calculate KPI score with target range?

    Hi, i'm in the midst of developing KPI dashboard. My table is as follow: <tbody> KPI Objectives weightage (%) Target Target Actual Achievement KPI Score (%) Actual Score (weightage) Base Stretch 1. New business 90 8 5 6 78% 8% 2. Get agreement signed 10 12 11 12 50% 8% </tbody> My...
  19. K

    Pivot Table Count IF

    I need to display basic performance of the recovery department in operating theatres. Ideally... I'd like to see <TBODY> Hour Patients Admitted Patients Discharged Avg Patient LoS Patients In Recovery ... ... ... ... ... 08:00 10 8 01:34:20 15 09:00 5 7 02:24:04 13...
  20. S

    Employee, Key Performance, Spreadsheet

    Hi Guys, I am trying to create a spreadsheet with a list or 30 or so KPIs we give to our casual staff. I am looking for a tick box system that I can tick the KPIs and it assigns say 5 points to tht employee. I then want to have the totals/percentage scored give a red/amber/green as to how...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top