Scribd Logo
Upload

Welcome to Scribd!

  • 36 views

    Quiz5 Resause

    Uploaded by

    Sardor Juraev
    The document is a payroll sheet listing employees' information including department, employee number, name, resident registration number, level, position, entering date, employment period, and total payment. It then provides calculations to automatically determine total payment for each employee based on their level using a month payment reference table.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Quiz5 Resause

    Uploaded by

    Sardor Juraev
    36 views5 pages
    The document is a payroll sheet listing employees' information including department, employee number, name, resident registration number, level, position, entering date, employment period, and total payment. It then provides calculations to automatically determine total payment for each employee based on their level using a month payment reference table.

    Original Title

    Quiz5 resause.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a payroll sheet listing employees' information including department, employee number, name, resident registration number, level, position, entering date, employment period, and total payment. It then provides calculations to automatically determine total payment for each employee based on their level using a month payment reference table.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    36 views5 pages

    Quiz5 Resause

    Uploaded by

    Sardor Juraev
    The document is a payroll sheet listing employees' information including department, employee number, name, resident registration number, level, position, entering date, employment period, and total payment. It then provides calculations to automatically determine total payment for each employee based on their level using a month payment reference table.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    급여명세서

    Ü기준 일시 : 12/5/2020 0:00


    employment period
    부서 No. 이름 주민등록번호 level 직위 Entering Date
    Y M D

    편집팀 950401 조다움 5 과장 4/1/1995 25 9380

    671027-1235787 308

    제작팀 950308 김경제 750203-1587452 3 사원 3/8/1995 25 9404


    308

    제작팀 961025 김민기 741231-1568741 4 사원 10/25/1996 24 8807


    289

    기획팀 931201 김민석 600708-2483317 6 차장 12/1/1993 27 9866


    324

    총무팀 930106 조현진 640908-2145256 6 차장 1/6/1993 27 10195

    334

    홍보팀 950506 김주영 741210-2485574 3 사원 5/6/1995 25 9345

    306

    영업팀 910203 김철민 760504-1486572 4 사원 2/3/1991 29 10898

    358

    편집팀 050108 홍길동 770409-1284578 3 사원 10/8/1950 70 25626

    841

    편집팀 910203 홍길순 650109-2487514 5 과장 2/3/1991 29 10898


    358

    제작팀 040509 박문수 770623-1687425 4 사원 2/9/1944 76 28059

    921
    기획팀 051007 이몽룡 791008-1698745 3 사원 12/7/1950 69 25566

    839

    총무팀 950714 서세원 701106-2698745 5 과장 7/14/1995 25 9276

    304

    홍보팀 951026 이바다 690931-2336897 5 과장 10/26/1995 25 9172

    301

    총무팀 031027 최하늘 731030-2983654 3 사원 2/27/1931 89 32789

    1077

    홍보팀 930801 김푸름 620829-1679437 6 차장 8/1/1993 27 9988

    328

    기획팀 951001 이자랑 690827-1679435 5 과장 10/1/1995 25 9197

    302

    기획팀 920431 성시경 610914-2369741 6 차장 5/1/1992 28 10445

    343

    Quiz needs:
    Make entering date from employee No.
    950401 means the entering date is 1995-04-01
    calculate employment period
    calculate total payment
    make construction autometically in column L
    Total PaymentMake construction autometically

    Dear 조다움 From


    462000000 Department 편집팀 your level
    is 5 so your total payment is
    462000000
    Dear 김경제 From
    308000000 Department 제작팀 your level
    is 3 so your total payment is
    308000000
    Dear 김민기 From
    Department 제작팀 your level
    is 4 so your total payment is
    361250000 361250000
    Dear 김민석 From
    584500000 Department 기획팀 your level
    is 6 so your total payment is
    584500000

    584500000 Dear 조현진 From


    Department 총무팀 your level
    is 6 so your total payment is
    584500000

    Dear 김주영 From


    306000000 Department 홍보팀 your level
    is 3 so your total payment is
    306000000

    447500000 Dear 김철민 From


    Department 영업팀 your level
    is 4 so your total payment is
    447500000

    Dear 홍길동 From


    841000000
    Department 편집팀 your level
    is 3 so your total payment is
    841000000
    Dear 홍길순 From
    537000000 Department 편집팀 your level
    is 5 so your total payment is
    537000000

    1151250000 Dear 박문수 From


    Department 제작팀 your level
    is 4 so your total payment is
    1151250000
    839000000 Dear 이몽룡 From
    Department 기획팀 your level
    is 3 so your total payment is
    839000000

    456000000
    Dear 서세원 From
    Department 총무팀 your level
    is 5 so your total payment is
    456000000

    451500000 Dear 이바다 From


    Department 홍보팀 your level
    is 5 so your total payment is
    451500000

    1077000000 Dear 최하늘 From


    Department 총무팀 your level
    is 3 so your total payment is
    1077000000

    574000000 Dear 김푸름 From


    Department 홍보팀 your level
    is 6 so your total payment is
    574000000

    Dear 이자랑 From


    453000000 Department 기획팀 your level
    is 5 so your total payment is
    453000000

    600250000 Dear 성시경 From


    Department 기획팀 your level
    is 6 so your total payment is
    600250000
    Month Payment Reference

    Level Month Payment


    1 500,000
    2 750,000
    3 1,000,000
    4 1,250,000
    5 1,500,000
    6 1,750,000

    You might also like