S
Sri Harsha
I am working on creating an Effort Estimate Tool for Clients.
I have 5 products Affinity, Quantim, QES, Interlink and COPE. For each
product we have estimates. Example is stated below. Similar to this, we have
5 other products with estimates in the same way.
Interlink
Estimations for
Severity RN User Guide
Low 1 hour 2 hours
Medium 2 hours 3 hours
High 3 hours 4 hours
I have created a table which has drop downs to chose the product, Severity,
Type of Document. Now based on the selection made, i want the number of
defects to multiple with the estimates provied in the respective product
table.
For Ex: If i select Interlink as a product and say Medium severity 10
Defects for RN document, it has to return 20 hrs as an estimate.
Is this possible with one formula? I am fine if we can split this to a
couple of steps also. Pls suggest.
Regards,
Sri Harsha.
I have 5 products Affinity, Quantim, QES, Interlink and COPE. For each
product we have estimates. Example is stated below. Similar to this, we have
5 other products with estimates in the same way.
Interlink
Estimations for
Severity RN User Guide
Low 1 hour 2 hours
Medium 2 hours 3 hours
High 3 hours 4 hours
I have created a table which has drop downs to chose the product, Severity,
Type of Document. Now based on the selection made, i want the number of
defects to multiple with the estimates provied in the respective product
table.
For Ex: If i select Interlink as a product and say Medium severity 10
Defects for RN document, it has to return 20 hrs as an estimate.
Is this possible with one formula? I am fine if we can split this to a
couple of steps also. Pls suggest.
Regards,
Sri Harsha.