Weeklysummaryreport(EveryWed)Inspectionsummary打开QAInspectionData数据库，Query0010)右击DesignView,设置所要统计的时间段，然后按run打开G:\EVERYONE\Shanghaistaff\Vicky\weeklysummary路径下的Inspectionsummary.mdb,分别右击countD/I和countpoD/IDesighView,设置所要统计的时间段并save.时间段设置完，双击counttotaolPO如下表：COUNTTOTALPOExpr1MaxOfResultCountRecordsYesA1472YesR4YesS37NoA399NoR27NoS121”yes”代表direct;”no”代表indirect“A”代表”pass”;”R”代表”reject”;”S”代表”skip”InspectionVisitisByLGS全填0双击countD/Ibyresult如下表：CountD/IBYRESULTDirectVendorY/NMaxOfResultCountRecordsYesA49YesR2YesS9NoA60NoR5NoS10ThirdpartyInspectionconducted(visits)=A+RInspectionfactory打开G:\EVERYONE\QualityAssurance\AllPODatabase\TPBooking\TPBookingReleasebackup\WeeklyInspectionSchedule-2011路径下所统计的那周的excel将时间段内的factory复制到G:\EVERYONE\Shanghaistaff\Vicky\统计的factory表格里，remove一下，把新增的factory对应direct和indirect累加FCsummary打开G:\EVERYONE\QualityAssurance\FC\2010NewFCQuotation路径下的FCQuotationMasterList2011，找到时间段内FC的FID打开FC&QMSResultSummary.xlsx，用第一步中找到的FID在这张表格中搜索resultSAsummary打开G:\EVERYONE\QualityAssurance\QADatabases\SocialComplianceAudit路径下的SocialComplianceAuditLogs(ShanghaiOffice).mdb数据库，找到时间段内SA的vendor-factory在G:\EVERYONE\QualityAssurance\inspectionreport,report中找到resultPEvisits在G:\EVERYONE\QualityAssurance\PEschedule路径下找到统计的那周的PEschedule将重复的factory删除，然后分别在masterlist里面查找是direct还是indirect后统计填入PEfactory在G:\EVERYONE\QualityAssurance\PEschedule路径下找到统计的那周的PEschedule将时间段内的factory复制到G:\EVERYONE\Shanghaistaff\Vicky\统计的PEfactory表格里，remove一下，把新增的factory对应direct和indirect累加