PDS DAILY REPORT

PDS DAILY REPORT

Requirement: 
Access to DAILY DAILY REPORTS GOOGLE DRIVE FOLDER, (SEE MANAGER IF YOU DONT HAVE) 


login credentials for PDS. 

Log in to PDS



Get the report

Enter date today




Once file is downloaded, open it.

a.  Freeze HEADER
b.  Highlight Supplier column yellow and sort A-Z
c.  Count how many per company then add to doc in company's column
d.  For those who doesnt have company name, count still then add to OTHER column



e.  Highlight column L blue then sort A-Z
f.  Count how many per staff then add to doc in staff's column
g.  Make sure all totals are correct
h.  Send daily report email