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 that we needed.
a) Sample Accuracy - List of errors (Color red only)
b) Core Consolidated DATASHEET - list of the volume worked.
Now here's what I want (seriously i don't know what to do, i'm new in vba) I want to populate the average accuracy in Accuracy Compute template based on the two spreadsheet's "Date Received" and "Project Coordinator". What is the easiest way to compute this? normal formula or vba is okay.
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 ] <-- to compute this, i've set the result cell to percentage so we can get 33.33%
I want now to populate the result accuracy in Accuracy Compute with the corresponding date. Thanks in million advance. My head is aching for this
Bookmarks