using efficency in excel ?

  • Thread starter Thread starter Manny
  • Start date Start date
M

Manny

Hi,

I have created an Excel spreadsheet which is based on 3 shift systems. I
have a target say for example of 50'000, if the shift 1 - 40'000 shift 2 -
35'000 and shift 3 = 30'000, how do i implement efficiency in %

appreciate any help

thanks
 
If by efficiency you're referring to % of target attained, then

A1: 50000
B1: 40000
C1: =B1/A1

Format C1 as a percentage.

If you mean something else by efficiency, post back with an explanation.
 
Hi,

Your kind of on the right tracks, but how do I tell the spreadsheer is say
for example target is 50k?

eg

Shift 1 outputs 40'000
Shift 2 outputs 30'000
Shift 3 outputs 35'000

there target is 50'000

i need to know what the efficiency in % of these 3 shifts

appreciate your help
 
Presumably you enter the value in a cell and refer to that cell, the way
I did in my example. Or am I misunderstanding completely?
 
Back
Top