ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   efficieny (https://www.excelbanter.com/excel-discussion-misc-queries/69019-efficieny.html)

kevcar40

efficieny
 
Hi
i am trying to calcualte the efficieny of a team

a1 = mins_available ( 60)
b1 = target (100)
c1 = stoppages (in minutes)
d1 = achieved (ie 50)

i have this formula
(target*(mins_available-stoppages)/mins_available)/target

problem is this does not take into account the quantity achieved
against the target

what i am trying to do is find out how long they actually worked
take what they actually achieved and work out how efficient they were
in the available time against the target

can anyone help please

kevin


Bob Phillips

efficieny
 
=achieved/(target*(mins_available-stoppages)/mins_available)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"kevcar40" wrote in message
oups.com...
Hi
i am trying to calcualte the efficieny of a team

a1 = mins_available ( 60)
b1 = target (100)
c1 = stoppages (in minutes)
d1 = achieved (ie 50)

i have this formula
(target*(mins_available-stoppages)/mins_available)/target

problem is this does not take into account the quantity achieved
against the target

what i am trying to do is find out how long they actually worked
take what they actually achieved and work out how efficient they were
in the available time against the target

can anyone help please

kevin




kevcar40

efficieny
 
Thank you Bob



All times are GMT +1. The time now is 10:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com