Thread: Estimates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sri Harsha[_2_] Sri Harsha[_2_] is offline
external usenet poster
 
Posts: 24
Default Estimates

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?