Forum Discussion

MelissaP4350's avatar
MelissaP4350
Copper Contributor
Jan 29, 2024

Help with Formula to calculate employee efficiency on specific functions throughout the day

We have employees track their time spent on specific prescribed activities with an Activity Code, Time spent from start to finish on that project, Either the # of units, orders or unique SKU's manipulated and the target rate for that activity code and the ultimate efficiency of that work.  In calculating the efficiency I'm struggling with how to use the "activity Code" to pull the correct column of information for the formula.  Some functions require us to evaluate "Picked Items per minute", some by "Picked Orders per minute" some by "Picked items per hour", etc.  In calculating the final efficiency I want the formula to use the activity code entered to pull the correct cell to calculate the efficiency.  How do I go about this?  

excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Silver Contributor
    Jan 30, 2024
    The most likely answer is "by using a table" and one of the many ways to extract values from a table (VLOOKUP, XLOOKUP, INDEX and MATCH, etc). But without being able to see your actual spreadsheet/workbook it's hard to get more specific. Is it possible for you to put a copy of it (no real employee names) on OneDrive or GoogleDrive with a link here that grants access to it?

Resources