percentage of production against quotation
 

Hi,
Can anyone help me? i need to find a percentage which is described in the
following:

Quotation per year
Work Lost
Work in production.

i have 3 columns as above.
column 1 contains all quotes to date
column 2 contains all work lost to date
column 3 contains all work in production to date.

i need to create 2 figures.
1 figure to show percentage of quotes lost to date
1 figure to show percentage of quotes in production to date
example:-
55 quotes to date
7 quotes lost
48 quotes in production

therefore 3.85% quotes lost
96.15% quotes in production

this needs to calculate a range of cells containing text to count between
amount of jobs quoted, amount of jobs lost and amount of jobs in production.

i konw its a bit lengthy but can anyone help me to complete this task s i
have to get it finished pronto.


thanks,

nige

If you already have the totals in A,B,C

Lost: = B2/A2
In Production: = A2/C2

both formatted as percentage

If you have just job details, assuming that row is headings then

Lost =(COUNTA(B:B)-1)/(COUNTA(C:C)-1)
In Production: =(COUNTA(A:A)-1)/(COUNTA(C:C)-1)

again formatted as percentage

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nigel" wrote in message
...
Hi,
Can anyone help me? i need to find a percentage which is described in the
following:

Quotation per year
Work Lost
Work in production.

i have 3 columns as above.
column 1 contains all quotes to date
column 2 contains all work lost to date
column 3 contains all work in production to date.

i need to create 2 figures.
1 figure to show percentage of quotes lost to date
1 figure to show percentage of quotes in production to date
example:-
55 quotes to date
7 quotes lost
48 quotes in production

therefore 3.85% quotes lost
96.15% quotes in production

this needs to calculate a range of cells containing text to count between
amount of jobs quoted, amount of jobs lost and amount of jobs in
production.

i konw its a bit lengthy but can anyone help me to complete this task s i
have to get it finished pronto.


thanks,

nige

Hi,
Here are my actual figures

Quoted = 43
Lost = 7
Prod =24

deficit between are pending

with inputting your formulas i get the following:
lost = 19.05%
production = 54.76%

is this correct as i am unsure.

regards,

Nige

"Bob Phillips" wrote:

If you already have the totals in A,B,C

Lost: = B2/A2
In Production: = A2/C2

both formatted as percentage

If you have just job details, assuming that row is headings then

Lost =(COUNTA(B:B)-1)/(COUNTA(C:C)-1)
In Production: =(COUNTA(A:A)-1)/(COUNTA(C:C)-1)

again formatted as percentage

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nigel" wrote in message
...
Hi,
Can anyone help me? i need to find a percentage which is described in the
following:

Quotation per year
Work Lost
Work in production.

i have 3 columns as above.
column 1 contains all quotes to date
column 2 contains all work lost to date
column 3 contains all work in production to date.

i need to create 2 figures.
1 figure to show percentage of quotes lost to date
1 figure to show percentage of quotes in production to date
example:-
55 quotes to date
7 quotes lost
48 quotes in production

therefore 3.85% quotes lost
96.15% quotes in production

this needs to calculate a range of cells containing text to count between
amount of jobs quoted, amount of jobs lost and amount of jobs in
production.

i konw its a bit lengthy but can anyone help me to complete this task s i
have to get it finished pronto.


thanks,

nige

Doesn't look right to me, the lost should be approx 16%, in production
should be 56%. I also though that lost and in production = quoted, do you
have another 'in quote' category.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nigel" wrote in message
...
Hi,
Here are my actual figures

Quoted = 43
Lost = 7
Prod =24

deficit between are pending

with inputting your formulas i get the following:
lost = 19.05%
production = 54.76%

is this correct as i am unsure.

regards,

Nige

"Bob Phillips" wrote:

If you already have the totals in A,B,C

Lost: = B2/A2
In Production: = A2/C2

both formatted as percentage

If you have just job details, assuming that row is headings then

Lost =(COUNTA(B:B)-1)/(COUNTA(C:C)-1)
In Production: =(COUNTA(A:A)-1)/(COUNTA(C:C)-1)

again formatted as percentage

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nigel" wrote in message
...
Hi,
Can anyone help me? i need to find a percentage which is described in
the
following:

Quotation per year
Work Lost
Work in production.

i have 3 columns as above.
column 1 contains all quotes to date
column 2 contains all work lost to date
column 3 contains all work in production to date.

i need to create 2 figures.
1 figure to show percentage of quotes lost to date
1 figure to show percentage of quotes in production to date
example:-
55 quotes to date
7 quotes lost
48 quotes in production

therefore 3.85% quotes lost
96.15% quotes in production

this needs to calculate a range of cells containing text to count
between
amount of jobs quoted, amount of jobs lost and amount of jobs in
production.

i konw its a bit lengthy but can anyone help me to complete this task
s i
have to get it finished pronto.


thanks,

nige