Auto Compute Accuracy based on Two Spreadsheets

[puuts]

Hello, Could you please help me with this.

I have this Accuracy Compute template that will compute for the accuracy.

Formula to get average accuracy = Total errors/Volume of worked


To compute the Average Accuracy, I have this two spreadsheets that have data we needed.

a) Sample Accuracy - List of errors (Color red only)

b) Core Consolidated DATASHEET - list of the volume worked.

I want to populate the average accuracy in Accuracy Compute template based on the two spreadsheet's "Date Received" and "Project Coordinator".

Sample Accuracy - Date Received = Column L, Project Coordinator = Column A
Core Consolidated DATASHEET - Date Received = Column H, Project Coordinator = Column F

For example:

in Sample Accuracy (Color Red Only), Project Coordinator = Rowena Uchi, Date and Time Received = 1/25/13
in Core Consolidated DATASHEET, Project Coordinator = Rowena Uchi, Date and Time Received = 1/25/13

Rowena Uchi got 2 errors for 1/25/13 with process of 6 volumes, so the average accuracy of Rowena should be 33.33% [ = 2/6 ]

I want now to populate the result accuracy in Accuracy Compute with the corresponding date. Thanks in advance

[puuts]

Could you please help me with this?

[puuts]

anyone can help me on this?

[Leith Ross]

Hello puuts,

I don't understand how you computed 33.33% for Rowena based on the data in these worksheets. Can you walk me through the math?

[puuts]

Hi Ross! , example: Column A1=2, Column A2=6, Column A3=Result (I've set the format of the RESULT CELL(A3) to percentage, then you will get 33.33%)

[jaslake]

Hi puuts

You PM'd me with a link to this Thread as it relates to another Thread of yours

http://www.excelforum.com/excel-prog...box-value.html

What's the relationship?

[puuts]

Hi John, sorry I've just paste the wrong link. This thread is what I've talking about.

[puuts]

*****up*****