I need to implement the below excel in QV

[#1]

Hi I need to implement the below excel in QV.

2 diff conditions in Status field..

1) Sometimes its checking for  >

2) Sometime for <

Attached the sample excel.

[Anonymous]

Hi Leela ,

Please find the attached application...

This is application will solve u  r problem ..

Please check it and revert

[#3]

But its not working right?

All the status are showing green..

[Anonymous]

Hi Leela,

Please check my last reply.........

[#5]

[#6]

Hi Venkata ,

We to exactly apply the logic like present in the excel.. where there are 3 different conditions for Status.

[#7]

Did you tried this??

[Anonymous]

Hi,

Can Clearly explain the what are the conditinion ??

for 1st condition wich colour u want and as well as 2 nd & 3rd...

please explain the conditions and related colors  also........

[#9]

HI Pavan

The file you are trying to attach didn't get attached properly.Can you please do it again.

[#10]

Hi Venkata,

The status field is finally what I need to calculate like below.

If you could provide me with a way where I could use any rowno conditions or any other way to do the same.

Type	Target	Value	Status
Schedul	98.0%	100%	if ( value >= Target , status=0, 1)
Estimate	99.0%	95%	same as above
Cost	99.0%	99%	same as above
Applications down time	30.0%	40%	if (value <= Target , Status=0 ,1)
Handled	10.0%	0.0%	same as above
Test Design Productivity (TCs/Hr)	7.5	11.0	If ( value > target, status=0 ,1)
Test Execution Productivity (TCs/Hr)	9	6.9	same as above
Test Case Effectiveness (%)	100.0%	100.0%	if ( value >= Target , status=0, 1)

Thanks.

[Anonymous]

Hi,

Please find the QVW file In the attachments...