(Supvs) SWC WORKSHEET by iuq51574

VIEWS: 6 PAGES: 7

									                                              SUPERVISOR WORKLOAD CREDIT WORKSHEET
               SWC Calculation is for: Post Office:                             Station:


    DISTRICT:                                                            FINANCE #:
 POST OFFICE:
    STATION:
       DATE:

1. EMPLOYEE CREDITS
             EMPLOYEES        WEIGHTED EMPLOYEES                                           SWCS
DELIVERY     a) City Carrier      0   x 1.40                                          0
             b) Rural carrier     0   x 1.25                                          0
             c) VOMA              0   x1                                              0                     FINANCE STATIONS WITH NO
             TOTAL DELIVERY SWCs                                                      =           0   (1)   RESIDENT SUPERVISOR:

WINDOW SVCS d) Window Clerk                          0        x 1 1/3                 0
            (main office only)
            e) Window Clerk                          0        x2                      0
                   (domiciled in finance stations without resident supervisor
                   each station must be listed on page 2)
                   TOTAL WINDOW SERVICES SWCs                                         =           0   (2)

DISTRIBUTION f) Distribution Clerk 0                          x1                      0
             g) Mail Handler       0                          x1                      0
             TOTAL DISTRIBUTION SWCs                                                  =           0   (3)

CUSTODIAL/   h) Custodial       0    x 1/2                                            0
MAINTENANCE * (PS-4 & below)
             i) Maintenance     0    x1                                               0
             TOTAL CUSTODIAL/MAINT SWCs                                               =           0   (4)

ADMIN *            i) Accounting, time & attendance, bulk mail, and secretarial
                                              0     x1                 0                          0   (5)

* DO NOT include employees on district or plant rolls domiciled in post
       offices or stations.                                                                                                POST OFFICE and STATION

2. NON-EMPLOYEE CREDITS                                                                                     # SUPVS                    RANGE
                                                                                                                   0                  0 - 18.49
Number of administrative highway contract            routes                                                        1                18.50 - 50.49
 j) with 100-299 box deliveries                      0      x 1/3                     0                            2                50.50 - 85.49
 k) with 300-399 box deliveries                      0      x2/3                      0                            3               85.50 - 123.49
 l) with 400 or more deliveries                      0      x1                        0                            4              123.50 - 163.49
 m) Number of contract stations and                                                                                5              163.50 - 203.49
   community post offices                            0        x 1/2                   0                            6              203.50 - 243.49
 n) Contract custodians (post offices only)                                                                        7              243.50 - 283.49
    If yes, enter 1; if no, 0                        0        x 1/3                   0                            8              283.50 - 323.49
TOTAL NON-EMPLOYEE SWCs                                                               =           0   (6)   1 Additional   for each additional 40 SWCs


TOTAL SWCs (add 1 through 6)                                                          =           0

SWC calculations are to include on rolls T.E.s, but not casuals, unless a casual employee is occupying a position
authorized to be filled. Vacant positions that are authorized to be filled are also included in the SWC calculation.


Prepared By:




                                                                                  10/27/2010
                                6710b9c1-1690-47e3-86f2-78283ff7b013.xls


data (i)
=SELECT("R1C3")
=VPAGE(1)
=SELECT("R4C5")
=FORMULA(INPUT("Enter X if this is a Post Office, Otherwise press ENTER",2,"CANNOT CANCEL - TYPE ANSWER OR PR
=SELECT("R4C7")
=FORMULA(INPUT("Enter X if this is a carrier station, otherwise press ENTER",2,"CANNOT CANCEL - TYPE ANSWER OR
=SELECT("R6C3")
=FORMULA(INPUT("Enter District Name",2,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ",))
=SELECT("R7C3")
=FORMULA(INPUT("Enter P.O. Name",2,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ",))
=SELECT("R8C3")
=FORMULA(INPUT("Enter Station Name or press ENTER",2,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ",))
=SELECT("R9C3")
=FORMULA(INPUT("Enter Date (mm/dd/yr) or press ENTER for today",2,"CANNOT CANCEL - TYPE ANSWER OR PRESS E
=SELECT("R6C8")
=FORMULA(INPUT("Enter Finance #",2,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ",))
=SELECT("R13C4")
=FORMULA(INPUT("Enter No. of City Carriers",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ","0",))
=SELECT("R14C4")
=FORMULA(INPUT("Enter No. of Rural Carriers",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ","0",))
=SELECT("R15C4")
=FORMULA(INPUT("Enter No. of VOMA",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ","0",))
=SELECT("R18C4")
=FORMULA(INPUT("Enter No. of Window Clerks-Main Ofc only",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER
=SELECT("R20C4")
=FORMULA(INPUT("Enter Number of Window Clerks in Finance Stations without resident supv.",1,"CANNOT CANCEL - TYPE
=SELECT("R25C4")
=FORMULA(INPUT("Enter No. of Distribution Clerks",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ","0",))
=SELECT("R26C4")
=FORMULA(INPUT("Enter No. of Mail Handlers",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ","0",))
=SELECT("R29C4")
=FORMULA(INPUT("Enter No. of Custodial, PS-4 and below",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ","0
=SELECT("R31C4")
=FORMULA(INPUT("Enter No. of Maintenance Employees PS-5 and above",1,"CANNOT CANCEL - TYPE ANSWER OR PRE
=SELECT("R35C4")
=FORMULA(INPUT("Enter No. of Admin employees; accounting, time and attend., secretarial",1,"CANNOT CANCEL - TYPE A
=SELECT("R42C4")
=FORMULA(INPUT("Enter No. of Admin Highway contract routes with 100-299 boxes",1,"CANNOT CANCEL - TYPE ANSWER
=SELECT("R43C4")
=FORMULA(INPUT("Enter No. of Admin Highway contract routes with 300-399 boxes",1,"CANNOT CANCEL - TYPE ANSWER
=SELECT("R44C4")
=FORMULA(INPUT("Enter No. of Admin Highway contract routes with 400 or more boxes",1,"CANNOT CANCEL - TYPE ANSW
=SELECT("R46C4")
=FORMULA(INPUT("Enter No. of contract stations and community P.Os",1,"CANNOT CANCEL - TYPE ANSWER OR PRESS
=SELECT("R48C4")
=FORMULA(INPUT("Contract custodians (P.O. only; if yes enter 1 if no enter 0",1,"CANNOT CANCEL - TYPE ANSWER OR P
=SELECT("R56C3")
=FORMULA(INPUT("Enter Your Name",2," CANNOT CANCEL - TYPE ANSWER OR PRESS ENTER ",))
=SELECT("R17C9")
=FORMULA(INPUT("FIRST Finance Station with no Supervisor:                    Enter Station Name, or press ENTER if none",2
=SELECT("R17C11")


                                                  Page 2
                              6710b9c1-1690-47e3-86f2-78283ff7b013.xls


=FORMULA(INPUT("FIRST Finance Station with no Supervisor: Enter Number of Clerks or press ENTER if none.",2,"CANNO
=SELECT("R18C9")
=FORMULA(INPUT("SECOND Finance Station with no Supervisor: Enter Station Name or press ENTER if none",2,"CANNO
=SELECT("R18C11")
=FORMULA(INPUT("SECOND Finance Station with no Supervisor: Enter Number of Clerks or press ENTER if none",2,"CAN
=SELECT("R19C9")
=FORMULA(INPUT("THIRD Finance Station with no Supervisor: Enter Station Name or press ENTER if none",2,"CANNOT C
=SELECT("R19C11")
=FORMULA(INPUT("THIRD Finance Station with no Supervisor: Enter Number of Clerks or press ENTER if none",2,"CANNO
=SELECT("R20C9")
=FORMULA(INPUT("FOURTH Finance Station with no Supervisor: Enter Station Name or press ENTER if none",2," CANNO
=SELECT("R19C11")
=FORMULA(INPUT("FOURTH Finance Station with no Supervisor: Enter Number of Clerks or press ENTER if none",2,"CAN
=SELECT("R1C1")
=RETURN()




                                               Page 3
                                    macro - station wsc input


Cntrl a   data_a

          =VPAGE(1)
          =SELECT("R4C4:R5C4")
          =CLEAR(1)
          =SELECT("R4C4")
          =SELECT("R4C12:R5C12")
          =CLEAR(1)
          =SELECT("R4C4")
          =SELECT("R12C11:R17C13")
          =CLEAR(3)
          =SELECT("R23C11:R28C13")
          =CLEAR(3)
          =SELECT("R4C4")



STATION   =INPUT("Enter Name of Station",2,"PRESS ESC TO START OVER")
          =IF(station=FALSE,GOTO(STOP.INPUT))
          =IF(AND(station<>"END"),GOTO(GOOD))

GOOD      =FORMULA(station)
          =SELECT("R[1]C")
          =GOTO(OFFICE)


OFFICE    =INPUT("Enter Name of Post Office",2,"PRESS ENTER TO START OVER")
          =IF(OFFICE=FALSE,GOTO(STOP.INPUT))
          =IF(AND(OFFICE<>"END"),GOTO(GOOD2))

GOOD2     =FORMULA(OFFICE)
          =SELECT("R4C12")
          =GOTO(FINANCE)

FINANCE   =INPUT("Enter Finance Number",2," PRESS ESC TO START OVER")
          =IF(FINANCE=FALSE,GOTO(STOP.INPUT))
          =IF(AND(FINANCE<>"END"),GOTO(GOOD3))

GOOD3     =FORMULA(FINANCE)
          =SELECT("R[1]C")
          =GOTO(GRADE)

GRADE     =INPUT("Enter Current Grade or Press ENTER",2,"PRESS ESC TO START OVER")
          =IF(GRADE=FALSE,GOTO(STOP.INPUT))
          =IF(AND(GRADE<>"END"),GOTO(GOOD4))

GOOD4     =FORMULA(GRADE)
          =SELECT("R10C4")
          =GOTO(GENERAL)

GENERAL   =INPUT("Enter average # General Deliveries or Press ENTER for Zero",2,"PRESS ESC TO START OVER","0"
          =IF(GENERAL=FALSE,GOTO(STOP.INPUT))



                                            Page 4
                                    macro - station wsc input


          =IF(AND(GENERAL<>"END"),GOTO(GOOD5))

GOOD5     =FORMULA(GENERAL)
          =SELECT("R[1]C")
          =GOTO(BOXES)

BOXES     =INPUT("Enter # Boxes Rented or Press Enter for Zero",2,"PRESS ESC TO START OVER","0")
          =IF(BOXES=FALSE,GOTO(STOP.INPUT))
          =IF(AND(BOXES<>"END"),GOTO(GOOD6))

GOOD6     =FORMULA(BOXES)
          =SELECT("R[1]C")
          =GOTO(CITY)

CITY      =INPUT("Enter # City Deliveries or Press Enter for Zero",2,"PRESS ESC TO START OVER","0")
          =IF(CITY=FALSE,GOTO(STOP.INPUT))
          =IF(AND(CITY<>"END"),GOTO(GOOD7))

GOOD7     =FORMULA(CITY)
          =SELECT("R[1]C")
          =GOTO(HCR)

HCR       =INPUT("Enter # H C R Deliveries or Press Enter",2,"PRESS ESC TO START OVER","0")
          =IF(HCR=FALSE,GOTO(STOP.INPUT))
          =IF(AND(HCR<>"END"),GOTO(GOOD8))

GOOD8     =FORMULA(HCR)
          =SELECT("R[1]C")
          =GOTO(RURAL)

RURAL     =INPUT("Enter # RURAL Deliveries or Press Enter",2,"PRESS ESC TO START OVER","0")
          =IF(RURAL=FALSE,GOTO(STOP.INPUT))
          =IF(AND(RURAL<>"END"),GOTO(GOOD9))

GOOD9     =FORMULA(RURAL)
          =SELECT("R24C3")
          =GOTO(FINUNIT)

FINUNIT   =FORMULA(INPUT("Enter name of finance unit or Press ENTER",2,"DO NOT CANCEL OR ESC ","0"))
          =SELECT("R[1]C")
          =FORMULA(INPUT("Enter name of finance unit or Press ENTER",2,"DO NOT CANCEL OR ESC ","0"))
          =SELECT("R[1]C")
          =FORMULA(INPUT("Enter name of finance unit or Press ENTER",2,"DO NOT CANCEL OR ESC ","0"))
          =SELECT("R[1]C")
          =FORMULA(INPUT("Enter name of finance unit or Press ENTER",2,"DO NOT CANCEL OR ESC ","0"))
          =SELECT("R[1]C")
          =FORMULA(INPUT("Enter name of finance unit or Press ENTER",2,"DO NOT CANCEL OR ESC ","0"))
          =SELECT("R[1]C")
          =FORMULA(INPUT("Enter name of finance unit or Press ENTER",2,"DO NOT CANCEL OR ESC ","0"))
          =SELECT("R[1]C")
          =FORMULA(INPUT("Enter name of finance unit or Press ENTER",2,"DO NOT CANCEL OR ESC ","0"))
          =SELECT("R43C4")



                                            Page 5
                                           macro - station wsc input


              =FORMULA(INPUT("Average # of Daily deliveries outside service area",2,"DO NOT PRESS CANCEL OR ESC"

              =SELECT("R12C11")

data.input    =INPUT("Enter Name of Station/Post Office where LETTER mail is processed",2,"PRESS ESC TO SKIP TO FL
              =IF(data.input=FALSE,GOTO(flat.input))
              =IF(AND(data.input<>"END"),GOTO(GOOD10))

GOOD10        =FORMULA(data.input)
              =SELECT("RC[1]")
              =GOTO(WEIGHTED)

WEIGHTED      =INPUT("Enter Total Number of Weighted Deliveries (e.g. city, rural, HCR) for this station/post office",2,"PRESS
              =IF(WEIGHTED=FALSE,GOTO(STOP.INPUT))
              =IF(AND(WEIGHTED<>"END"),GOTO(GOOD11))

GOOD11        =FORMULA(WEIGHTED)
              =SELECT("RC[1]")
              =GOTO(PCT)

PCT           =INPUT("Enter % of LETTERS processed for this station/post office ,",2,"PRESS ESC TO START OVER")
              =IF(PCT=FALSE,GOTO(STOP.INPUT))
              =FORMULA(PCT)
moreltr       =INPUT("MORE OFFICES?: ENTER YES OR NO")
              =IF(moreltr="NO",GOTO(FLAT.START))
              =IF(AND(moreltr="YES"),GOTO(loop))

LOOP          =SELECT("R[1]C[-2]")
              =GOTO(data.input)



FLAT.START =SELECT("R23C11")
flat.input =INPUT("Enter Name of Station/Post Office where FLAT mail is processed ",2,"PRESS ESC TO START OVE
           =IF(flat.input=FALSE,GOTO(STOP.INPUT))
           =IF(AND(flat.input<>"END"),GOTO(GOOD12))

GOOD12        =FORMULA(flat.input)
              =SELECT("RC[1]")
              =GOTO(WEIGHTFLT)

WEIGHTFLT =INPUT("Enter Total Number of Weighted Deliveries (e.g. city, rural, HCR) for this station/post office",2,"PRES
          =IF(WEIGHTFLT=FALSE,GOTO(STOP.INPUT))
          =IF(AND(WEIGHTFLT<>"END"),GOTO(GOOD13))

GOOD13        =FORMULA(WEIGHTFLT)
              =SELECT("RC[1]")
              =GOTO(PCTFLT)

PCTFLT        =INPUT("Enter % of FLATS processed for this station/post office ",2,"PRESS ESC TO CANCEL")
              =IF(PCTFLT=FALSE,GOTO(STOP.INPUT))
              =FORMULA(PCTFLT)


                                                    Page 6
                                  macro - station wsc input


moreflt    =INPUT("MORE OFFICES?: ENTER YES OR NO")
           =IF(moreflt="NO",GOTO(STOP.INPUT))
           =IF(AND(moreflt="YES"),GOTO(LOOP2))

LOOP2      =SELECT("R[1]C[-2]")
           =GOTO(flat.input)

STOP.INPUT =SELECT("R48C1")
           =RETURN()




                                          Page 7

								
To top