tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 538840d1505842843-pivot-table-displaying-old-data-s666-newpts-53rd-street-cost-schedule-4
Sheet: Draw 9 - 08.19.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Line Item | Sum of Line Item # | Sum of Amount
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-07 00:00:00 | 36204 | Robertson's [NAME] | Retaining wall materials |  | Block/Retaining Walls | 3450 | 74348.44
Stormwater BMPs | Erosion Control | 211 | 2017-08-10 00:00:00 | 120 | Art's Trench Plate | Stabilized construction entrance |  | Erosion Control | 211 | 120
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-08-11 00:00:00 | 1390 | [NAME] | Retaining wall labor |  | Inspections | 407 | 100
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-11 00:00:00 | 36.14 | Home Depot | Retaining wall materials |  | Grand Total | 4068 | 74568.44
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-11 00:00:00 | 132.38 | Home Depot | Retaining wall materials
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-11 00:00:00 | 29.66 | [NAME] | Retaining wall materials
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-12 00:00:00 | 679.53 | Home Depot | Retaining wall materials
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-14 00:00:00 | 72.73 | RCP Block and [NAME] | Retaining wall materials
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-16 00:00:00 | 231.5 | RCP Block and [NAME] | Retaining wall materials
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-08-18 00:00:00 | 4910 | [NAME] | Retaining wall labor
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-08-23 00:00:00 | 30662.5 | [NAME] | Retaining wall labor and materials
Inspection Fee | Inspections | 407 | 2017-08-23 00:00:00 | 100 | Pacific Premier Bank | Inspection fee for draw #9
Spreadsheet: 135723d1326207500-how-to-do-sort-with-buttons-in-steps-samplesorting1
Sheet: Sorting sample

 | Logo
 | Data Sorting Period :
1a
 | Coloumn1 | Coloumn2 | Coloumn3 | Coloumn4 | Coloumn5
 | d | 2012-09-27 00:00:00 | d | d | d
 | c | 2012-09-27 00:00:00 | c | c | c
 | b | 2012-09-27 00:00:00 | b | b | b
 | a | 2012-09-27 00:00:00 | a | a | a
 | f | 2012-09-26 00:00:00 | f | f | f
 | e | 2012-09-26 00:00:00 | e | e | e
 | g | 2012-09-24 00:00:00 | g | g | g
 | j | 2012-09-20 00:00:00 | j | j | j
 | i | 2012-09-20 00:00:00 | i | i | i
 | h | 2012-09-20 00:00:00 | h | h | h
 | 4 | 2012-09-09 00:00:00 | m | m | m
 | 5 | 2012-09-09 00:00:00 | l | l | l
 | k | 2012-09-09 00:00:00 | k | k | k
 | k | 2012-09-09 00:00:00 | k | k | k
 | 2 | 2012-09-01 00:00:00 | o | o | o
 | 3 | 2012-09-01 00:00:00 | n | n | n
 | 1 | 2012-07-20 00:00:00 | p | p | p
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Mohammed Al Hamid

Contract Terms (*)
 |  | Consultation | 0.5
 |  | Dental Procedure (After Deducting direct and indirect expenses +OR Cost + Lab Fee) | 0.45
 |  | OHE To Be Deducted From Total Revenue | 0.05
Doctor Calculation
 |  | Gross Revenue
 |  | Doctor Consultation Revenue | 330
 |  | Clinic Fees 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Doctor Revenue Dental Procedure | 4070
 |  | Clinic Fees 5%
 |  | Dental Lab | 0
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Doctor Revenue Implant Procedure | 0
 |  | Clinic Fees 5%
 |  | Consumables | 0
 |  | Net Revenue
 |  | Amount to be Paid | 0
 |  | * Implant Cost : 650 SAR
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO | .......................
Spreadsheet: 727547d1617952423-need-to-extract-data-from-other-sheet-based-on-name-date-and-time-range-to-avoid-duplicates-varun_task-manager-gk
Sheet: Data'21

 | Date | Workers Name | Activity | Start Time | End Time | Workorder | Quantity | Images | Containers | Files | Total Time | Time in Minutes | Images/Min | Quantity/Min | Containers/Min | Files/Min | Comments | Department | Location
 | 2021-02-23 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-23 09:30:15 | 2021-02-23 12:59:58
 | 2021-02-23 00:00:00 | [NAME] | PUT AWAY RECORDS: ONSITE | 2021-02-23 13:41:40 | 2021-02-23 17:00:40
Spreadsheet: 349455d1412337102-range-of-numbers-with-required-result-range
Sheet: Sheet1

 |  |  |  | Range | Multiply
Range Number | 1650 |  |  | 1000 | 80
Results | 240 |  |  | 1200 | 160
 |  |  |  | 1500 | 240
 |  |  |  | 1800 | 320
 |  |  |  | 2000 | 400
 |  |  |  | 2200 | 480
 |  |  |  | 2400 | 560
 |  |  |  | 2500+ | 0.25
Spreadsheet: c4897f09-49b3-41d6-a6d5-903b4f752554
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GB2GP | Test | GB2GP | Beta-2 Glycoprotein 1 Antibodies, IgG, Serum | Beta 2 GP1 Ab IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <10.0 U/mL (negative) 10.0-14.9 U/mL (borderline) > or =15.0 U/mL (positive) Results are expressed in arbitrary units. Reference values apply to all ages. | Monday through Saturday; 8 a.m. | Same day/1 day | 6 days | 1 | 86146 |  |  |  |  | Rochester
GB2GP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
GB2GP | Result | GB2GP | Beta 2 GP1 Ab IgG, S | Beta 2 GP1 Ab IgG, S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 44448-9 | Beta 2 glycoprotein 1 Ab.IgG:ACnc:Pt:Ser:Qn:EIA
Spreadsheet: sally_beck__36212__Weekly Operating Report 5-30
Sheet: WE 4-25 EOL Data

EOL
 | Week ending 04/25 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas | 14790 | 1869240046.280001 | MMBTU
Power | 2956 | 22403354 | MHtz
EGM
Liquids | 1027 | 42950999.99999999 | BBL
Coal | 0 | 0 | TONNE
Coal International | 1 | 45000 | TONNE
Weather | 15 | 4300 | HDD/CDD
IR/FX | 0 | 0 | USD
Emissions | 7 | 17500 | CONTRACTS
EIM
Pulp & Paper | 0 | 0 | TONNE
Steel | 3 | 9000 | TONNE
Number of new EOL Counterparties | 17
Non-EOL
 | Week ending 04/25 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EA
Gas | 3339 | 2319020585.14 | MMBTU
Power | 2968 | 73755269.76 | MHtz
EGM
Liquids | 1830 | 131822933.66 | BBL
Coal | 25 | 2272500 | TONNE
Coal International | 1 | 45000 | TONNE
Weather | 7 | 37000 | HDD/CDD
IR/FX | 645 | 0 | USD
Emissions | 10 | 132600 | CONTRACTS
EIM
Pulp & Paper | 277 | 363558.61 | TONNE
Steel | 50 | 7652 | TONNE
Clickpaper
 | Week ending 04/25 |  | Volumetric
New Deals for: | New Deals | Volume | Units
EIM
Lumber | 5 | 528000 | Board Feet
Newsprint
Pulp (recycled paper) | 3 | 520 | [NAME]
Number of new CP Counterparties | 1
Lumber Converted |  | 528
EIM TOTAL |  | 381258.61
Spreadsheet: mark_taylor__25022__Allowance Peaker
Sheet: Assumptions

 | BARRY 2 |  |  |  | YATES 5
 | discount rate: | 0.08
 | term: |  | 10 |  | term: |  | 10
 | unit size (MW) |  | 139 |  | unit size (MW) |  | 139
 | heat rate: |  | 10346 |  | heat rate: |  | 10391
 | capacity: |  | 0.914 |  | capacity: |  | 0.643
 | heat input: |  |  |  | heat input:
 |  | annual | 10000000 |  |  | annual | 8000000
 |  | O3 season | 4804788 |  |  | O3 season | 3507736
 | generation: |  |  |  | generation:
 |  | annual |  |  |  | annual
 |  | O3 season |  |  |  | O3 season
 | NOx (uncontrolled) |  |  |  | NOx (uncontrolled)
 |  | rate | 0.55 |  |  | rate | 0.328
 |  | tons |  |  |  | tons
1 | Control technology: |  | Noxtech | 1 | Control technology: |  | Noxtech
 |  | efficiency | 0.8 |  |  | efficiency | 0.7
 |  | capex | 3458230 |  |  | capex | 3458230
 |  | annual o+m | 490000 |  |  | annual o+m | 362000
 |  | NPV over term |  |  |  | NPV over term
 | NOx emissions (post control): |  |  |  | NOx emissions (post control):
 |  | rate |  |  |  | rate
 |  | tons |  |  |  | tons
 | [NAME] destroyed (annual): |  |  |  | [NAME] destroyed (annual):
 | variable [NAME] destroyed: |  |  |  | variable [NAME] destroyed:
2 | Control technology: |  | Rotamix | 2 | Control technology: |  | Rotamix
 |  | efficiency | 0.75 |  |  | efficiency | 0.75
 |  | capex | 1676737 |  |  | capex | 1676737
 |  | annual o+m | 377000 |  |  | annual o+m | 356000
 |  | NPV over term |  |  |  | NPV over term
 | NOx emissions (post control): |  |  |  | NOx emissions (post control):
 |  | rate |  |  |  | rate
 |  | tons |  |  |  | tons
 | [NAME] destroyed (annual): |  |  |  | [NAME] destroyed (annual):
 | variable [NAME] destroyed: |  |  |  | variable [NAME] destroyed:
Spreadsheet: tracy_geaccone__40501__2002 Plan Template_REV
Sheet: Merchant

DETAIL MERCHANT ASSETS & INVESTMENTS
(Millions of Dollars)
 |  | 2002 Merchant Activities
 |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
Realized (Gains) from Sales
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 91)
Proceeds from Sales
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 92)
Additions
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 93)
Unrealized (Gains) / Losses
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
x |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other
Total (line 94)
Total Merchant Activities
Spreadsheet: 02465666-1275-4ab9-a4cf-6167dee3ddb0
Sheet: Personnel Type Purchase of Serv

n/a | n/a | SFY 2014 STATE CODE SHEET
SFY 2014 STATE EDRS-UFARS codes crosswalk | n/a | n/a
n/a | n/a | n/a
UFARS Object Codes to EDRS Personnel Type Code | n/a | n/a
Purchase of Services (Salaried Personnel from other Districts) - SERVICE CODE U | n/a | n/a
UFARS OBJECT CODE | EDRS PTC | [NAME]
396 | 1 | Teacher (Requires Setting Code)
396 | 2 | Program Coordinator/Due Process Faciliator/Teacher on Special Education Assgnment (TOSA) (Non-Supervisory)
396 | 3 | Academic & Behavioral Strategist
396 | 4 | Physical Therapy Services
396 | 5 | Occupational Therapy Services
396 | 6 | School Nurse
396 | 7 | Educational Speech/Language Pathologist (Requires Setting Code)
396 | 8 | Paraprofessional/Personal Care Assistant
396 | 9 | Director of Special Education
396 | 10 | Assistant Director/Supervisor
396 | 11 | School Social Worker
396 | 12 | Cultural Liaison (Requires Activity Code)
396 | 13 | School Psychologist
396 | 14 | Audiologist
396 | 15 | Adaptive Physical Education Specialist
396 | 16 | Consultant (Prior Approval Required) (Requires Activity Code)
396 | 23 | Substitute Teachers
396 | 25 | Other Licensed/Certified Therapist - e.g. Music Therapist (Prior Approval Required)
396 | 26 | Foreign Language Interpreter
396 | 27 | Vision Media Assistant
396 | 28 | Interpreter for the Deaf
396 | 29 | Certified Orientation/Mobility Speciaist for Visually Impaired
396 | 34 | Assistative Technology Specialist
396 | 35 | School Counselor
396 | 37 | Certified Orientation/Mobility Assistant for Visually Impaired
396 | 38 | Security Specialist  (Prior Approval Required)
396 | 40 | Social Worker for Interagency Activities
396 | 42 | Physician (Evaluation Only)
396 | 44 | Licensed Nursing Services
396 | 45 | Teacher Clerical Support Aide (Due Process)
396 | 48 | Behavioral Specialist
396 | 49 | Qualified Mental Health Professional
396 | 50 | Mental Health Behavioral Aide
396 | 52 | Mental Health Practitioner
396 | 53 | One - to -  One Paraprofessional
396 | 55 | Mentors for Interpreters of the Deaf & Hard of Hearing
396 | 57 | Contracted Therapeutic Recreational
396 | 58 | Substitute Para/PCA/One - to - One Para
396 | 59 | Speech/Language Pathology Assistant
396 | 60 | Special Transportation Nursing Services (IEP MA Reporting Only)
396 | 61 | Specail Transportation PCA Services (IEP MA Reporting Only)
396 | 62 | Extracurricular Activities (Staff Only) (Requires Activity Code)
396 | 63 | Licensed Staff Extra Duty Time
396 | 64 | Non-Licensed Staff Extra Duty Time
end of worksheet
Spreadsheet: 713473d1610728138-index-and-match-or-vlookup-based-off-of-multiple-criteria-manager-list
Sheet: Sheet1

Name | Title | Department Code | Bonus Amount | In role 6 Months? |  |  | Name | Title | Department Code
 | Manager | 307490
 | Manager | 342441 |  |  |  |  | [NAME] | Manager | 306228
 | Manager | 345321 |  |  |  |  | [NAME] | Manager | 331186
 | Manager | 331383 |  |  |  |  | [NAME] | Manager | 354028
 | Manager | 336421 |  |  |  |  | [NAME] | Manager | 303465
 | Manager | 351927 |  |  |  |  | Dina Simoes | Manager | 330462
 | Manager | 338416 |  |  |  |  | [NAME] | Manager | 336668
 | Manager | 338424
 | Manager | 349843
 | Manager | 356946 |  |  |  |  | [NAME] | Manager | 357114
 | Manager | 338120 |  |  |  |  | [NAME] | Manager | 307490
 | Manager | 303453 |  |  |  |  | [NAME] | Manager | 331383
 | Manager | 331381 |  |  |  |  | [NAME] | Manager | 336421
 | Manager | 348873 |  |  |  |  | [NAME] | Manager | 342441
 | Manager | 351596 |  |  |  |  | [NAME] | Manager | 345321
 | Manager | 343348 |  |  |  |  | [NAME] | Manager | 338120
 | Manager | 338123 |  |  |  |  | [NAME] | Manager | 338416
 | Manager | 303462 |  |  |  |  | [NAME] | Manager | 351927
 | Manager | 339861 |  |  |  |  | [NAME] | Manager | 356946
 | Manager | 336667 |  |  |  |  | [NAME] | Manager | 303462
 | Manager | 336668 |  |  |  |  | Sandra Assis | MUL | 303462
 | Manager | 306228 |  |  |  |  | ARTJOLA BARDHOSHI | Manager | 336667
 | Manager | 331185
 | Manager | 331186 |  |  |  |  | [NAME] | Manager | 338123
 | Manager | 352767 |  |  |  |  | [NAME] | Manager | 339861
 | Manager | 354028 |  |  |  |  | Stephanie Rasun | Manager | 337678
 | Manager | 303465 |  |  |  |  | [NAME] | Manager | 343363
 | Manager | 357114 |  |  |  |  | [NAME] | Manager | 303453
 | Manager | 330462 |  |  |  |  | [NAME] | Manager | 331381
 | Manager | 337680 |  |  |  |  | [NAME] | Manager | 348873
 | Manager | 310018 |  |  |  |  | [NAME] | Manager | 351596
 | Manager | 337678
 | Manager | 343363
 | Manager | 340437
Spreadsheet: 56209e54-aabe-4f8f-a373-ef94f3592677
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CMVM | Test | CMVM | Cytomegalovirus (CMV) Antibodies, IgM, Serum | [NAME], IgM, S | [NAME] (MFI) | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.40 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | Negative (Reported as positive, negative, or equivocal) | Monday through Saturday; 9 a.m. | Same day/1 day | 3 days | 1 | 86645 |  |  |  |  | Rochester
CMVM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CMVM | Result | CMVM | [NAME], IgM, S | [NAME], IgM, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process | [NAME].IgM:ACnc:Pt:Ser:Ord:EIA
Spreadsheet: 867600d1714429257-reverse-irr-with-operating-costs-reverse-irr-example
Sheet: Cashflow

 |  | Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | Total |  | IRR
 | Option 1 | Cost | -196.1 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 | -31.3 |  |  | 0.1
 |  | Income
Spreadsheet: 328362d1403878814-subract-cell-if-older-than-a-year-with-other-conditions-absence-reporting
Sheet: 2014

 |  |  |  |  | TYPE | Code | POINT |  | TOTAL POINTS
 |  |  |  |  | Tardy | T | 0.5 |  | 3 | Verbal Warning
 |  |  |  |  | Missed Punch | MP | 0.5 |  | 6 | Written Warning w/ EAP Referral
 |  |  |  |  | Absence w/1 hr minimum notification | A | 1 |  | 8 | Final Written Warning
 |  |  |  |  | Absence w/1 hr minimum notification on Holiday | A-H | 2 |  | 9 | Termination
 |  |  |  |  | Improper Absence Reporting | IAR | 3 |  | ** | Points are recorded and expunged on a rolling 365 day basis
 |  |  |  |  | No Show | NS | 5 |  | *** | 1 point drops off after 90 days of no attendance occurances
***DO NOT SKIP A DATE/POINTS/CODE SECTION***
Associate ID # | Associate Name | Total Pts | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code | date | points | code
Spreadsheet: 887417d1737651833-get-data-from-one-sheet-and-make-a-weekly-timesheet-ef1664_test
Sheet: SHEET 2

 | 2024-12-30 00:00:00 | <== Start date
 | MONDAY |  | TUESDAY |  | Wednesday |  | THURDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <== formulae will automatically adjust the dates based on B1
 | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT | IN | OUT
PERSON 1
PERSON 2
PERSON 3
Spreadsheet: 755900d1637168593-formula-for-calculating-the-scrabble-value-of-welsh-words-sample
Sheet: Scrabl Values

a | 1
á | 1
à | 1
ä | 1
ã | 1
â | 1
b | 3
c | 4
ç | 4
ch | 5
d | 1
dd | 1
e | 1
é | 1
è | 1
ë | 1
ẽ | 1
ê | 1
f | 2
ff | 4
g | 2
ng | 10
h | 4
i | 1
í | 1
ì | 1
ï | 1
ĩ | 1
î | 1
j | 10
l | 2
ll | 5
m | 3
n | 1
ñ | 1
o | 1
ó | 1
ò | 1
ö | 1
õ | 1
ô | 1
p | 5
ph | 10
r | 1
rh | 10
s | 3
t | 3
th | 4
u | 2
ú | 2
ù | 2
ü | 2
ũ | 2
û | 1
w | 1
ẃ | 1
ẁ | 1
ẅ | 1
ŵ | 1
y | 1
ý | 1
ỳ | 1
ÿ | 1
ỹ | 1
ŷ | 1
Spreadsheet: 117521d1312842260-excel-2007-convert-sales-into-a-currency-corresponding-from-a-drop-down-test-drop-down-currency
Sheet: Sheet1

Display currency: |  | EUR | 1
 |  | USD | 0.7
 |  | CAD | 0.9889
 |  | [NAME] | 12.1409
Product | Number | Currency | Exchange rate | Price in selected currency | Qty | Sales in Euros
Lamp | 111 | USD |  | 20 | 10
Bulb | 222 | EUR |  | 3 | 20
Shelve | 333 | USD |  | 50 | 10
Spreadsheet: 4e3e9480-41e8-4113-9d9c-eefae525b34b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | PROYECTOS PROGRAMA RECUPERACION DE BARRIOS
 | PROYECTO | FINANCIAMIENTO | EJECUCION | PLAZO
1 | [NAME] Barrio Arturo Prat | 93111 | MUNICIPIO
2 | Telecentro Arturo Prat | 18000 | MUNICIPIO
 | Sede vecinal [NAME] | 40500 | MUNICIPIO
3 | Sede Deportiva Arturo Prat | 63900 | S E R V I U | Terminada
4 | Recuperación [NAME] | 46695 | MUNICIPIO
 | [NAME] | 36083 | MUNICIPIO
5 | [NAME] y [NAME] y Reordenamiento de Arborización Existente Barri Sargento Aldea | 91416 | S E R V I U | Terminada
6 | Telecentro S Aldea | 18000 | MUNICIPIO
 | Multicentro S Aldea | 47141 | MUNICIPIO
7 | Etapa II [NAME] | 40000 | MUNICIPIO
 | Etapa I [NAME] | 50000 | MUNICIPIO
 | Telecentro | 18000 | MUNICIPIO
8 | [NAME] y [NAME] y Sede Vecinal Chanchoquin | 115489 | S E R V I U
9 | Mejoramiento Alumbrado Público Chanchoquin | 36000 | MUNICIPIO | Terminada
10 | [NAME] | 57251 | S E R V I U
11 | Telecentro Toqui | 25583 | MUNICIPIO
12 | [NAME] complementarias Mejoramiento Multicancha Club deportivo [NAME] | 7946 | S E R V I U | Terminada
13 | Construcción Parque Deportivo Villa Arauco | 365185 | S E R V I U | Terminada
Spreadsheet: 41308d1239799939-vlookup-and-if-on-two-lists-of-text-book1
Sheet: Sheet1

1pm | 9.00
3i Group | 750.00
Shell | 29.0
4imprint Group | 7.0
3i Group | 750.00
Shell | 29.0
4imprint Group | 7.0
Shell | 29.0
4imprint Group | 7.0
3i Group | 750.00
4imprint Group | 7.0
3i Group | 750.00
Shell | 29.0
4imprint Group | 7.0
Shell | 29.0
4imprint Group | 7.0
3i Group | 750.00
Shell | 29.0
4imprint Group | 7.0
Shell | 29.0
Spreadsheet: 125570d1319108890-excel-2007-moving-values-between-sheets-by-using-number-commands-weight-and-buildup
Sheet: ULD7&8

7 |  |  |  |  |  |  | 8
 |  |  |  | Aircraft Position |  |  |  |  |  |  | Aircraft Position
Built up by: |  |  | Origin | ULD Ident |  |  | Built up by: |  |  | Origin | ULD Ident
Total Pages: |  |  | KEF |  |  |  | Total Pages: |  |  | KEF
AWB | DEST | PCS | WEIGHT |  | Flight Number |  | AWB | DEST | PCS | WEIGHT |  | Flight Number
 |  |  |  |  | Offload Point |  |  |  |  |  |  | Offload Point
 |  |  |  |  | Final Dest |  |  |  |  |  |  | Final Dest
ULD Tare Weight: |  |  |  |  |  |  |  | ULD Tare Weight:
RMK | Total |  |  |  |  |  | RMK | Total
Spreadsheet: 812741d1673354821-production-shortages-excel-test-
Sheet: Day 5 Question

Q1. The Iist has employee names and badge#s of XYZ Inc.
Their Manager name in found in the other table, you will need to use the employee badge to lookup their manager in the manager table. Note Managers rotate randomly each month, so your lookup needs to consider the month also
Month : | Feb
Employee Table
Name | Badge# | Manager
Prashanth, [NAME] | 87423
Tank, Ashwini | 78312
Suri, Aviral | 98722
Kumar, [NAME] | 12235
Tendulkar, Sachin | 23972
Maradonna, Diego | 56431
Singh, [NAME] | 98362
Kumar, Deepak | 18739
Manager Table by Month
Emp Badge# | Jan | Feb | Mar | Apr | May
98362 | Londo, Mollari | Puri, Om | Temp Mgr1 | Prakash, Surya | [NAME], [NAME]
12235 | Londo, Mollari | Londo, Mollari | Londo, Mollari | Prakash, Surya | Puri, Om
78312 | Londo, Mollari | Puri, Om | Londo, Mollari | Jain, [NAME] | [NAME], [NAME]
98722 | Londo, Mollari | Londo, Mollari | Temp Mgr1 | Jain, [NAME] | [NAME], [NAME]
87423 | Puri, Om | Puri, Om | Temp Mgr1 | Jain, [NAME] | Puri, Om
56431 | Puri, Om | Londo, Mollari | Temp Mgr1 | Prakash, Surya | Puri, Om
23972 | Puri, Om | Londo, Mollari | Londo, Mollari | Prakash, Surya | [NAME], [NAME]
18739 | Puri, Om | Puri, Om | Londo, Mollari | Jain, [NAME] | Puri, Om