judicial report edited

Upload: sui-generis

Post on 05-Oct-2015

219 views

Category:

Documents


0 download

DESCRIPTION

excel tracking sample

TRANSCRIPT

Sheet1Judical Reports WorkflowName and RankDocket no.Docket TitleStatusJurisdictionCourtType of ErrorDate of CommissionRaw ScoreTotal ScoreDeficitRemarksRecommendationTacorda, Lorilee Jane Not ReviewedStateCritical1. Incorrect Judge16.7593.06Good jobGood JobPS3 QA accuracy should be 90-100%No errorFAR EXCEEDEDMinor1. Missed out orderNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorCurimao, Paul VicenteCritical7. Multiple errors14.2579.166666666710.8333333333Warning (did not meet the range score)PS3 QA accuracy should be 90-100%Critical7. Multiple errorsPARTIALLY METCritical7. Multiple errorsMinor3. Missed out partyMinor2. Missed out motionNo errorNo errorMinorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorPornea, Emma MizielCritical0080Warning (did not meet the range score)PS2 transtiionee. QA accuracy should be 80-85%CriticalNEEDS IMPROVEMENT / COACHINGCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalCriticalSabaldica, ReneeNo error1794.4444444444Good jobGood jobPS2 transtiionee. QA accuracy should be 80-85%No errorFAR EXCEEDEDNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorNo errorCriticalNo error

Sheet2ErrorCriticalMinorCritical1. Incorrect Judge1. Missed out orderMinor2. Incorrect Motion2. Missed out motion3. Incorrect ATD3. Missed out party4. Misinterpreted order/ Failed to log order4. Missed out ATD5. Docket left in "In Process" status6. Incorrect / No parties7. Multiple errors

Sheet3ErrorScoreErrorScoreRaw ScoreTotal ScoreDeficitRangeRemarkDEFICITREMARKSCritical1Jane1Critical116.7593.0555555556Good jobJane90Good JobJane-3.0555555556FAR EXCEEDEDMinor0.252No error014.2579.166666666710.8333333333Paul90Warning (did not meet the range score)Paul10.8333333333PARTIALLY METNo error03Minor0.250080Emma80Warning (did not meet the range score)Emma80NEEDS IMPROVEMENT / COACHING4No error01794.4444444444Good jobRenee80Good jobRenee-14.4444444444FAR EXCEEDED5No error06No error07No error08No error0rangeremarks9No error0-20FAR EXCEEDED10No error01EXCEEDED11No error05ACHIEVED12No error09PARTIALLY MET13No error013NOT MET14No error017NEEDS IMPROVEMENT / COACHING15No error016No error017No error018No error0Paul1Critical12Critical13Critical14Minor0.255Minor0.256No error07No error08Minor0.259No error010No error011No error012No error013No error014No error015No error016No error017No error018No error0Emma1Critical12Critical13Critical14Critical15Critical16Critical17Critical18Critical19Critical110Critical111Critical112Critical113Critical114Critical115Critical116Critical117Critical118Critical1Renee1No error02No error03No error04No error05No error06No error07No error08No error09No error010No error011No error012No error013No error014No error015No error016No error017Critical118No error0