prince bhatia
New Member
- Joined
- May 30, 2015
- Messages
- 11
hi,
please read the full thread to know what i want to see in result:
this is second post to MR.EXCEL as in first post i didn't get any reply except one from "hike" which i really appreciate
Now , i am creating an excel file file which has two sheets Sheet 1 and sheet 2
in sheet 1 their would be data base which has the columns like :
<tbody>
</tbody>
and in second 2 would be the pivoted of sheet 1 in which their would be two tables first one would be like :
<colgroup><col span="3"><col><col span="2"><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>Now what i want to create an refresh button in the sheet 1 when i press that refresh button i will get in sheet 2 (pivot sheet ) i automatically get the transaction date row labels( QC date),Count of Xid ,count of pass and count of fail,Average would be of column "j" sheet 1 and accuracy score count of XID pass /count of XID created
now data base for the sheet 1:
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
i also posted the same thread in orzid but didn't find any complete resolution please find the link this would be help you to understand what i want to create and how it would help you also accuracy in vba but date wise.. please rely only if you can understand and can find a correct resolution
please read the full thread to know what i want to see in result:
this is second post to MR.EXCEL as in first post i didn't get any reply except one from "hike" which i really appreciate
Now , i am creating an excel file file which has two sheets Sheet 1 and sheet 2
in sheet 1 their would be data base which has the columns like :
Agent Name | XID No. | Process | Transaction date | QC MONTH | QC date | Week | QC Done by | QC Score | Completeness Score | City | Feedback | Improvement Areas | Remarks | Fail | Pass |
<tbody>
</tbody>
and in second 2 would be the pivoted of sheet 1 in which their would be two tables first one would be like :
Transaction date | Row Labels | Count of XID No. | Count of Pass | Count of Fail | Average of QC Score | Accuracy Score |
Grand Total |
<colgroup><col span="3"><col><col span="2"><col></colgroup><tbody>
</tbody>
Now their would be another table in the sheet 2 having the format like:
<colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
now data base for the sheet 1:
QUALITY SLA- 95% | ||||||||||||||||
S.no | Agent Name | XID No. | Process | Transaction date | QC MONTH | QC date | Week | QC Done by | QC Score | Completeness Score | City | Feedback | Improvement Areas | Remarks | Fail | Pass |
Devesh | 171793 | New Launch | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 75% | Mumbai South West | 5E, 3C | Possession Status Incorrect, BN Incorrect- Stop words used. It is an Under Construction project and the completion date will be after 3years- https://housing.com/in/new-projects...everest-builders-developers-in-santacruz-east. "Builders and Developers" is a stop word. We do not use it. | |||||
Devesh | 171811 | Under Construction | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Mumbai Beyond Thane | Yes | ||||||
Devesh | 171819 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 0% | Pune | 1A | Duplicate Project- r99552 | No | ||||
Devesh | 171935 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Pune | Yes | ||||||
Devesh | 171945 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Pune | Yes | ||||||
Devesh | 171997 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Pune | Yes | ||||||
Devesh | 172049 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Hyderabad | Yes | ||||||
Devesh | 172113 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Faridabad | Yes | ||||||
Devrishi | 171799 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Chennai South | Yes | ||||||
Devrishi | 171805 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Chennai South | Yes | ||||||
Devrishi | 171877 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Pune | Yes | ||||||
Devrishi | 171913 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Pune | Yes | ||||||
Devrishi | 171955 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Pune | Yes | ||||||
Devrishi | 172009 | Ready To Move | 5/14/2015 | May | 5/16/2015 | Week 2 | Anjali | 100% | Pune | Yes |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
i also posted the same thread in orzid but didn't find any complete resolution please find the link this would be help you to understand what i want to create and how it would help you also accuracy in vba but date wise.. please rely only if you can understand and can find a correct resolution