Estimates

[Sri Harsha]

Here is a table with details of estimated work hours per page.
Complexity Release Notes User Guides Dictionaries File Layouts
Estimated effort hours per page in the FD Estimated effort hours per page
in the RN/FD Estimated effort hours per page in the RN/FD Estimated effort
Low 4 3 3 8 pages per hour
Medium 6 6 5
High 8 8 8

Now, I want to create a table which gives me the estimates when I select the
complexity, type of document and no. of pages of Source Doc.
For ex: If I have a medium complex FD (Source Doc), with 10 pages and I am
writing a Release Notes, the result should be 60 Hrs.
How do I achieve this?

 

[Stefi]

If you place yor table in A14 like this:

Complexity Release Notes User Guides Dictionaries
Low 4 3 3
Medium 6 6 5
High 8 8 8

In cell G1 create a Data validation drop doen list with source =$A$2:$A$4
for complexity,
in cell G2 another one with source =$B$1:$D$1
and enter No. of pages in G3

then formula is:

=INDEX(A14,MATCH(G1,A:A,0),MATCH(G2,1:1,0))*G3

Regards,
Stefi

„Sri Harsha†ezt írta: