ABCDEFGH
1
Read This before you use this calculation sheet:Enter the No Article Issued to PM and Brought back for deposit columns. Brought back for deposit means without the articles which are redirected/missent/return to sender articles. i.e., Intimation 1 & 2 articles. It will calculate ur office performance automatically. Please don’t touch the column 'E' and 'F'. In H column enter the no of articles as per the remarks given by postman. In Remarks as Per project arrow norms No articles should be returned by the postman other than intimation. So only remarks column restricted with intimation I & II.
2
DateArticle TypeArticle Issued to PMBrought Back for DepositReturn %KPI ReduceRemarksNo of articles
3
RL#DIV/0!#DIV/0!D/L Intimation I
4
D/L Intimation II
5
VPL Intimation
6
Parcel#DIV/0!#DIV/0!D/L Intimation I
7
D/L Intimation II
8
VPL Intimation
9
Speed#DIV/0!#DIV/0!D/L Intimation I
10
D/L Intimation II
11
MO#DIV/0!#DIV/0!D/L Intimation I
12
D/L Intimation II
13
OAP Intimation
14
eMO#DIV/0!#DIV/0!D/L Intimation I
15
D/L Intimation II
16
OAP Intimation
17
Total KPI Reduced#DIV/0!
18
Office Delivery Performance score#DIV/0!
19
20