Scribd Logo
Upload

Welcome to Scribd!

  • 20 views

    02 Lookup Functions

    Uploaded by

    kk
    The third document contains a table with supply items, quantities remaining, and remarks. It can be used as a lookup table to determine the remarks for a given quantity remaining of a supply item.

    Copyright:

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

    02 Lookup Functions

    Uploaded by

    kk
    20 views9 pages
    The third document contains a table with supply items, quantities remaining, and remarks. It can be used as a lookup table to determine the remarks for a given quantity remaining of a supply item.

    Original Title

    Copy of 02 Lookup Functions

    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 third document contains a table with supply items, quantities remaining, and remarks. It can be used as a lookup table to determine the remarks for a given quantity remaining of a supply item.

    Copyright:

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

    02 Lookup Functions

    Uploaded by

    kk
    The third document contains a table with supply items, quantities remaining, and remarks. It can be used as a lookup table to determine the remarks for a given quantity remaining of a supply item.

    Copyright:

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

    RateTable Name Rating Numerical Score

    Excellent 99 Babbitt, George Fair 71


    Very Good 92 Checker, Charles Satisfactory 78
    Good 85 Belli, Melvin Satisfactory 78
    Satisfactory 78 Bench, John Good 85
    Fair 71 Bickle, Travis Poor 65
    Poor 65 Martinet, Jean Satisfactory 78
    Fail 50 Cabot, Sebastian Very Good 92
    Carson, Kit Very Good 92
    Chauvin, Nicolas Very Good 92
    Bates, Norman Very Good 92
    Björling, Jussi Excellent 99
    Claypool, Ida Poor 65

    ADD TRIM
    Last First Sales ID# Find the ID# of theEmployee Roster
    Randall Yvonne 61,113 891 person based on the
    table on the right.
    Roy Margarita 77,945 189 Name
    Noble Michael 98,382 760 Anderson, Teason
    Hoover Evangeline 63,436 452 Bailey, Victor
    Wilkerson Claudia 67,433 307 Bishop, Juan
    Bailey Victor 58,871 654 Carr, Susan
    McGee Carol 85,837 918 Frost, Adam
    Gilligan John 89,659 not found Hardy, Svetlana
    Hood, Renee
    Hoover, Evangeline
    Malone, Daniel
    McGee, Carol
    Noble, Michael
    Randall, Yvonne
    Rodriguez, Scott
    Roy, Margarita
    Sullivan, Robert
    Vega, Alexandra
    Wilkerson, Claudia
    ID#
    642
    654
    206
    770
    384
    262
    366
    452
    184
    918
    760
    891
    306
    189
    536
    939
    307
    Employee Code Name Department Dept Code
    234-1387 Babbitt, George Operations 234
    668-1067 Checker, Charles Accounting 668
    234-1953 Belli, Melvin Operations 392
    234-1276 Bench, John Operations
    392-1002 Bickle, Travis Training
    234-1498 Martinet, Jean Operations
    668-1282 Cabot, Sebastian Accounting
    234-1849 Carson, Kit Operations
    392-1087 Chauvin, Nicolas Training
    234-1928 Bates, Norman Operations
    234-1737 Björling, Jussi Operations
    668-1708 Claypool, Ida Accounting
    Dept Name Find the
    Operations department
    Accounting based on the
    table on the
    Training right.
    Employee Name Salary TaxRate TaxTable
    Allen, Thomas ₱ 23,672.00 3% 0
    Banks, Ryan ₱ 25,749.00 5% 5,000
    Cole, Elbert ₱ 32,647.00 5% 15,000
    Durham, Troy ₱ 34,365.00 5% 25,000
    Hernandez, Glenn ₱ 22,864.00 3% 35,000
    Hicks, Monica ₱ 26,632.00 5% 45,000
    Hoover, Evangeline ₱ 28,227.00 5% 55,000
    House, Paul ₱ 22,999.00 3% 65,000
    Jenkins, Scott ₱ 26,505.00 5% 75,000
    Jensen, Kristina ₱ 32,963.00 5% 85,000
    Lucas, John ₱ 20,451.00 3% 95,000
    Moreno, Christopher ₱ 33,075.00 5%
    Mosley, Michael ₱ 33,852.00 5%
    Newman, Aria ₱ 23,644.00 3%
    Nicholson, Lee ₱ 22,527.00 3%
    Obrien, Madelyn ₱ 34,379.00 5%
    Palmer, Terry ₱ 33,421.00 5%
    Randall, Yvonne ₱ 31,308.00 5%
    Sullivan, Robert ₱ 22,686.00 3%
    Taylor, Hector ₱ 28,360.00 5%
    Walter, Michael ₱ 25,436.00 5%
    0
    1%
    3%
    5%
    6%
    7%
    8%
    10%
    11%
    12%
    13%
    Supplies Quantity Remaining Remarks 0 Urgent Create a lookup table o
    Pencils 111 Overstock 11 Critical the right and solve for t
    remarks based on the
    Markers 127 Overstock 51 On Stock quantity remaining.
    Bond Paper 188 Overstock 91 Overstock
    Pens 163 Overstock
    Folders 6 Urgent
    Paper Clip 17 Critical 0-10 Urgent
    11-50 Critical
    Glue 189 Overstock 51-90 On Stock
    Tape 87 On Stock 91-above Overstock
    Stapler 163 Overstock
    Scissors 108 Overstock
    Ruler 133 Overstock
    Notepad 110 Overstock
    Create a lookup table on
    the right and solve for the
    remarks based on the
    quantity remaining.

    k
    rstock

    You might also like