tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 356393d1415098038-retrieving-a-value-based-on-comparison-of-multiple-columns-sample_dataset
Sheet: Sheet1

userid | date | feedback_id |  |  | userid | date | feedback_id | rating |  |  | Desired output: | userid | date | feedback_id | rating
[EMAIL] | 2014-08-27 00:00:00 | P00061 |  |  | [EMAIL] | 2014-08-27 00:00:00 | P00061 | 1 |  |  |  | [EMAIL] | 2014-08-27 00:00:00 | P00061 | 1
[EMAIL] | 2014-08-28 00:00:00 | QD00026 |  |  | [EMAIL] | 2014-08-31 00:00:00 | P00053 | 2 |  |  |  | [EMAIL] | 2014-08-28 00:00:00 | QD00026
[EMAIL] | 2014-09-25 00:00:00 | QD00038 |  |  | [EMAIL] | 2014-08-25 00:00:00 | QD00023 | 3 |  |  |  | [EMAIL] | 2014-09-25 00:00:00 | QD00038
[EMAIL] | 2014-08-31 00:00:00 | P00053 |  |  | [EMAIL] | 2014-09-01 00:00:00 | QD00015 | 2 |  |  |  | [EMAIL] | 2014-08-31 00:00:00 | P00053 | 2
[EMAIL] | 2014-08-25 00:00:00 | QD00023 |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 5 |  |  |  | [EMAIL] | 2014-08-25 00:00:00 | QD00023 | 3
[EMAIL] | 2014-09-17 00:00:00 | QD00030 |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 6 |  |  |  | [EMAIL] | 2014-09-17 00:00:00 | QD00030
[EMAIL] | 2014-08-28 00:00:00 | [NAME] |  |  | [EMAIL] | 2014-09-26 00:00:00 | QD00039 | 3 |  |  |  | [EMAIL] | 2014-08-28 00:00:00 | [NAME]
[EMAIL] | 2014-08-28 00:00:00 | P00012 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-28 00:00:00 | P00012
[EMAIL] | 2014-09-01 00:00:00 | QD00015 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-01 00:00:00 | QD00015 | 2
[EMAIL] | 2014-08-26 00:00:00 | QD00024 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 5
[EMAIL] | 2014-08-26 00:00:00 | QD00024 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-26 00:00:00 | QD00024 | 6
[EMAIL] | 2014-09-26 00:00:00 | QD00039 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-26 00:00:00 | QD00039 | 3
[EMAIL] | 2014-09-19 00:00:00 | QD00032 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-19 00:00:00 | QD00032
[EMAIL] | 2014-09-16 00:00:00 | QD00029 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-09-16 00:00:00 | QD00029
[EMAIL] | 2014-08-27 00:00:00 | P00061 |  |  |  |  |  |  |  |  |  | [EMAIL] | 2014-08-27 00:00:00 | P00061
Spreadsheet: 686910d1594868477-how-to-differentiate-exactly-word-with-and-no-on-the-data-to-countif-iferror-and-vlook-match-data
Sheet: Sheet3

Stock | Last Price | EP | Remarks
DOLPHIN | 0.11 | 0.11/0.1 | Entry
SCABLE | 0.29 | 0.28/0.275 | Entry
VITROX | 10 | 9.73 | Entry
YSPSAH* | 2.4 | 2.37 | Entry
PHARMA* | 2.72 | 2.63 | Entry
HOMERIZ | 0.615 | 0.61/0.575 | Entry
GRANFLO | 0.27 | 0.27/0.25 | Entry
IRIS* | 0.24 | 0.25/0.235 | Entry
PRESTAR | 0.45 | 0.455/0.43 | Entry
KOSSAN | 12.7 | 0.455/0.43 | Entry
DUFU* | 2.2 | 0.455/0.43 | Entry
Spreadsheet: 727578d1617970958-find-nearest-upper-and-lower-values-in-a-table-index-and-match-lookup-number-example
Sheet: Table1

Values | [NAME] | [NAME] | X-3 | Y-1 | Y-2 | Y-3 | XY0 |  |  | Type | Value | Result
0.001 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 | - | 0.2 |  | example1 | X-3 | 50
0.002 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 | - | 0.2 |  | example2 | Y-2 | 7500 | 375
0.005 | 0.003 | 0.006 | 0.02 | 0.06 | 0.2 | - | 0.2
0.01 | 0.003 | 0.008 | 0.025 | 0.08 | 0.25 | - | 0.25
0.02 | 0.003 | 0.01 | 0.03 | 0.1 | 0.3 | - | 0.3
0.05 | 0.004 | 0.012 | 0.04 | 0.12 | 0.4 | - | 0.4
0.1 | 0.005 | 0.016 | 0.05 | 0.16 | 0.5 | 1.6 | 0.5
0.2 | 0.006 | 0.02 | 0.06 | 0.2 | 0.6 | 2 | 0.6
0.5 | 0.008 | 0.025 | 0.08 | 0.25 | 0.8 | 2.5 | 0.8
1 | 0.01 | 0.03 | 0.1 | 0.3 | 1 | 3 | 1
2 | 0.012 | 0.04 | 0.12 | 0.4 | 1.2 | 4 | 1.2
5 | 0.016 | 0.05 | 0.16 | 0.5 | 1.6 | 5 | 1.6
10 | 0.02 | 0.06 | 0.2 | 0.6 | 2 | 6 | 2
20 | 0.025 | 0.08 | 0.25 | 0.8 | 2.5 | 8 | 2.5
50 | 0.03 | 0.1 | 0.3 | 1 | 3 | 10 | 3
100 | 0.05 | 0.16 | 0.5 | 1.6 | 5 | 16 | 5
200 | 0.1 | 0.3 | 1 | 3 | 10 | 30 | 10
500 | 0.25 | 0.8 | 2.5 | 8 | 25 | 80 | 25
1000 | 0.5 | 1.6 | 5 | 16 | 50 | 160 | 50
2000 | 1 | 3 | 10 | 30 | 100 | 300 | 100
5000 | 2.5 | 8 | 25 | 80 | 250 | 800 | 250
10000 | 5 | 16 | 50 | 160 | 500 | 1600 | 500
20000 | 10 | 30 | 100 | 300 | 1000 | 3000 | 1000
50000 | 25 | 80 | 250 | 800 | 2500 | 8000 | 2500
100000 | - | 160 | 500 | 1600 | 5000 | 16000 | 5000
200000 | - | 300 | 1000 | 3000 | 10000 | 30000 | 10000
500000 | - | 800 | 2500 | 8000 | 25000 | 80000 | 25000
1000000 | - | 1600 | 5000 | 16000 | 50000 | 160000 | 50000
2000000 | - | - | 10000 | 30000 | 100000 | 300000 | 100000
5000000 | - | - | 25000 | 80000 | 250000 | 800000 | -
Spreadsheet: diana_scholtes__8558__Letter Log 01-14
Sheet: Termination

 | Events of Default/Termination
 | As of January 14, 2002
Term | Counterparty | Attorney Assigned | Enron Entity | Amount (if applicable) | Early Termination Date | Nature of Default (if any) | Contract Type(s) | Comments | Margin: (Posted by Enron)/Posted to Enron
Y | Conexant Systems, Inc. |  | EPMI |  | 2002-01-15 00:00:00 | failure to provide performance assurance, bankruptcy | Master Power Purchase and Sale Agreement | Conexant will calculate termination payment
Research | [NAME] |  | ENA |  | 2002-01-08 00:00:00 |  | Deal No. YL5782.1 (11/26/2001)
Research | [NAME] |  | ENA |  | 2002-01-08 00:00:00 |  | Deal Nos. Y81255.1 & Y81256.1 (10/04/2001)
 | Louis Dreyfus LPG Services Ltd. |  | ECTRIC |  | 2002-01-11 00:00:00 | failure to make payment when due | all derivative transactions
Y | Portland General Electric |  | EPMI |  | 2001-12-02 00:00:00 | bankruptcy | Master Energy Purchase Agreement (04/01/1999) | Per [NAME], agreement terminates automatically on bankruptcy filing
Research | Sideriver Investments Limited |  | Enron Corp. | £29,086,154.73 due to Enron | 2001-12-07 00:00:00 |  | Term Loan Facility and ISDA (06/20/2001) | should be 12/06 ltr establishing Early Term Date
 | UtiliCorp. United Inc. |  | EPMI |  | 2001-11-30 00:00:00 | sect. 4.1 | Master Energy Sale Agreement (01/01/2000)
Y | Villers, Donnally |  | ENA |  | 2002-02-28 00:00:00 |  | Gas Purchase Agreement (07/01/1995)
Spreadsheet: 837688d1690358674-calculating-values-between-date-ranges-excel-date-forum-request
Sheet: Raw Data

 | Agent Name | Skill | Status | Effective From | Go-live date
 | [NAME] | BM CHO | Inductee | 2023-07-03 00:00:00 | 2023-09-06 00:00:00
 | [NAME] | BM CHO | Inductee | 2023-07-03 00:00:00 | 2023-09-06 00:00:00
 | Kurt | BM CHO | Inductee | 2023-07-03 00:00:00 | 2023-09-06 00:00:00
 | [NAME] | BM CHO | Inductee | 2023-07-03 00:00:00 | 2023-09-06 00:00:00
 | [NAME] | BM CHO | Inductee | 2023-07-03 00:00:00 | 2023-09-06 00:00:00
 | Fred | BM CORE | Inductee | 2023-09-01 00:00:00 | 2023-11-01 00:00:00
 | [NAME] | BM CORE | Inductee | 2023-09-01 00:00:00 | 2023-11-01 00:00:00
 | Jayce | BM CORE | Inductee | 2023-09-01 00:00:00 | 2023-11-01 00:00:00
Spreadsheet: daren_farmer__5803__HoursSurvey_May_Mgr
Sheet: Hours

 | 1497
 | Manager
RC | Position | Activity Name | Last Month | Hours
1497 | Manager | Bid Week Preparation | 19 | 25
1497 | Manager | Daily Trader/Originator Support | 105
1497 | Manager | [NAME] | 5 | 5
1497 | Manager | Interface w/gas control | 15 | 25
1497 | Manager | Performance Feedback | 5 | 10
1497 | Manager | Provide Mentoring | 16 | 16
1497 | Manager | System Downtime | 0 | 0
Spreadsheet: 121195d1315915648-formula-to-sum-max-of-each-group-excel-formula-need
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group Name | Part Name | Part Number | Engine Qty | Jan Y1 | Feb Y1 | [NAME] | Apr Y1 | May Y1 | [NAME] | [NAME] | Aug Y1 | Sep Y1 | [NAME] | Nov Y1 | Dec Y1
Expected | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0001 | Widget2 | PN3 | 1 | 1 | - | - | - | - | - | - | 1 | - | - | - | -
Part Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  |  | G0001 | Widget2 | PN3A | 1 | 1 | - | 1 | - | - | - | - | - | - | - | - | -
Widget1 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  |  | G0001 | Widget4 | PN5 | 1 | - | - | - | - | - | - | - | - | - | - | - | -
Widget2 | 1 | 3 | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  |  | G0001 | Widget1 | PN22 | 1 | - | - | - | - | - | - | - | 1 | - | - | - | -
Widget3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | G0001 | Widget4 | PN6A | 1 | 1 | - | - | - | - | - | - | - | - | - | - | -
Widget4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 0 |  |  |  | G0001 | Widget4 | PN6 | 1 | - | - | - | - | - | - | - | - | - | - | - | -
Widget5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | G0002 | Widget2 | PN3 | 5 | - | - | - | - | - | - | - | - | - | - | - | -
Widget6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | G0002 | Widget2 | PN3A | 5 | - | - | 5 | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0002 | Widget4 | PN5 | 5 | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0002 | Widget1 | PN22 | 5 | - | 5 | - | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget2 | PN3 | 2 | - | 3 | - | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget2 | PN3A | 2 | - | 2 | 2 | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget4 | PN5 | 2 | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget4 | PN6A | 2 | - | - | - | - | - | - | - | 2 | - | - | - | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G0003 | Widget4 | PN6 | 2 | - | - | - | - | - | - | - | 2 | - | - | - | -
 | Values
Row Labels | [NAME] of Jan Y1 | Max of Feb Y1 | [NAME] of Mar Y1 | [NAME] of Apr Y1 | [NAME] of May Y1 | [NAME] of Jun Y1 | [NAME] of Jul Y1 | [NAME] of Aug Y1 | [NAME] of Sep Y1 | [NAME] of Oct Y1 | Max of Nov Y1 | [NAME] of Dec Y1
Widget1 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Widget2 | 1 | 3 | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
Widget4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0
Spreadsheet: 1ebc6af2-ef20-4764-8235-4fd7ad42b02a
Sheet: Sheet1

The University of Tulsa | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
School of Education
Secondary English Certification
Name:   ______________________________________ |  | ID#:  _______________________
•  Complete Tulsa Curriculum
•   Complete Professional Education Sequence for Secondary Education.
 |  |  | Date | Grade
 | Educ 1101  Introduction to Education |  | ______ | ______
 | Educ 2103  Foundations of Education |  | ______ | ______
 | Educ 3171  Education Technology for Instruction |  | ______ | ______
 | Educ 3713  Child/Adolescent & The Learning Environment |  | ______ | ______
 | Educ 3733  Measurement & Evaluation in Education |  | ______ | ______
 | Educ 4013  Education of the Exceptional Child |  | ______ | ______
 | Educ 4214  Middle and Secondary Teaching Methods |  | ______ | ______
 | Educ 4626  Student Teaching in Middle School |  | ______ | ______
 | Educ 4636  Student Teaching in Secondary School |  | ______ | ______
 | Educ 4971  Student Teachiing Seminar |  | ______ | ______
•   Complete a Major in English, including the following distribution of courses incorporated within the major.
 | American Literature:  (6 hours)
 | ___________________________________ |  | ______ | ______
 | ___________________________________ |  | ______ | ______
 | British Literature:  (6 hours)
 | ___________________________________ |  | ______ | ______
 | ___________________________________ |  | ______ | ______
 | World Literature:  (3 hours)
 | ___________________________________ |  | ______ | ______
 | Language Acquisition, Grammar, [NAME] (3 hours)
 | ___________________________________ |  | ______ | ______
 | Electives in English (12 hours)
 | ___________________________________ |  | ______ | ______
 | ___________________________________ |  | ______ | ______
 | ___________________________________ |  | ______ | ______
 | ___________________________________ |  | ______ | ______
Evaluator  _________________________________ |  | Advisor  ___________________________
Date  _________________
Spreadsheet: 271d28aa-fa50-43cc-a704-c8009f4d8225
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 7/15/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.7 | 7.13 | 6.55 | 7.02 | 8.31 | 8.12 | 7.78 | 7.68
July | 7.89 |  | 7.76 |  | 8.67 |  | 8.39
August | 8.04 |  | 7.92 |  | 7.76 |  | 8.27
September | 8.27 |  | 8.25 |  | 7.77 |  | 8.38
October | 8.38 |  | 8.33 |  | 7.61 |  | 8.56
November | 8.47 |  | 8.38 |  | 8.11 |  | 8.65
December | 8.3 |  | 8.15 |  | 8.31 |  | 8.48
January | 8.12 |  | 8.01 |  | 8.24 |  | 8.34
February | 7.97 |  | 7.85 |  | 8.19 |  | 8.11
March | 7.79 |  | 7.63 |  | 8.12 |  | 7.95
April | 7.71 |  | 7.52 |  | 8.01 |  | 7.9
May | 7.68 |  | 7.49 |  | 8.06 |  | 7.84
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 7/15/2013
Spreadsheet: 701013d1603459508-enter-a-date-in-one-cell-and-return-closed-in-another-shs-sharable
Sheet: Safe Home Study Tracker

Famiy Name | Case Number | [NAME] | [NAME] | POC Name | POC Number | DTE Assigned | DTE Contact Made (w/Recr. & Ret. [NAME]) | [NAME] | DTE Review Due (15 days) | Days Remaining | DTE Approved by Supervisor | Days remining | [NAME] CRRU (20 days) | DTE sent to DFCS | DTE Approve by DFCS | DTE Signed SHS sent to CRRU Super | DTE Binder Delivered | DTE Invoice Sent | Status |  | Today
[NAME] | 1234 |  |  |  |  | 2020-10-20 00:00:00 | 2020-10-22 00:00:00 | 2020-10-22 00:00:00 |  |  | 2020-10-22 00:00:00 |  | 2020-10-25 00:00:00 | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00 |  |  | Warning days |  | 5
Jet | 5678 |  |  |  |  | 2020-09-25 00:00:00 | 2020-10-22 00:00:00 | 2020-10-23 00:00:00 |  |  | 2020-10-25 00:00:00 |  | 2020-10-25 00:00:00 | 2020-10-26 00:00:00 | 2020-10-27 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 2020-10-30 00:00:00
Peach | 9101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legend | Count
Cobbler | 1112 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expired
Georgia | 1314 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | About to Expire
Hello | 1516 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Valid
Axel | 5676
Spreadsheet: 270182d1381410399-formula-help-with-multiple-tabs-sampe-workbook-for-forum
Sheet: Summary

 | Which departments to Include? |  |  | [Blank]
 |  |  |  | [Blank]
 |  |  |  | [Blank]
 |  |  |  | [Blank] |  |  |  |  |  |  |  |  |  | 1 | [Blank]
 |  |  |  | [Blank] |  |  |  |  |  |  |  |  |  | 2 | Dept 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Dept 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Dept 3
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 |  |  |  |  |  | 5 | Dept 4
 | Dept 1
 | Dept 2
 | Dept 3
 | Dept 4
 | Revenue
 | Expenses
 | Net Income
Spreadsheet: 855554d1705084171-how-to-get-the-results-off-from-a-data-point-help
Sheet: Sheet1

Name | Active Status | Grad Date |  |  |  |  | Active Status | Yes
[NAME] | Yes | 2024-04-30 00:00:00
[NAME] | No | 2025-05-01 00:00:00 |  |  |  |  | Row Labels | Count of Name
[NAME] | Yes | 2024-09-30 00:00:00 |  |  |  |  | 2023 | 1
[NAME] | Yes | 2024-08-31 00:00:00 |  |  |  |  | Dec | 1
[NAME] | No | 2026-04-30 00:00:00 |  |  |  |  | 2024 | 6
Calvin H | Yes | 2024-04-30 00:00:00 |  |  |  |  | Apr | 2
Hana S | Yes | 2023-12-31 00:00:00 |  |  |  |  | Aug | 2
Loyd B | No | 2026-07-31 00:00:00 |  |  |  |  | Sep | 1
[NAME] | Yes | 2024-08-31 00:00:00 |  |  |  |  | Dec | 1
[NAME] | No | 2024-12-31 00:00:00 |  |  |  |  | 2025 | 1
[NAME] | Yes | 2024-12-31 00:00:00 |  |  |  |  | May | 1
[NAME] Y | Yes | 2025-05-01 00:00:00 |  |  |  |  | Grand Total | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | List of Students |  | Grad Date
Spreadsheet: 161099d1339417032-excel-help-to-concatenate-concatenate
Sheet: Sheet1

 |  |  | Date | Time | Answer Coming | Answer required
 |  |  | 2012-06-11 00:00:00 | 13:03:00 | 410710.54375 | 2012-06-11 13:03:00
 |  |  | 2012-06-12 00:00:00 | 14:03:00
 |  |  | 2012-06-13 00:00:00 | 15:03:00
 |  |  | 2012-06-14 00:00:00 | 16:03:00
 |  |  | 2012-06-15 00:00:00 | 17:03:00
 |  |  | 2012-06-16 00:00:00 | 18:03:00
 |  |  | 2012-06-17 00:00:00 | 19:03:00
 |  |  | 2012-06-18 00:00:00 | 20:03:00
 |  |  | 2012-06-19 00:00:00 | 21:03:00
 |  |  | 2012-06-20 00:00:00 | 22:03:00
 |  |  | 2012-06-21 00:00:00 | 23:03:00
Spreadsheet: 830622d1685008183-combining-subtotal-lookup-and-if-or-alternative-to-lookup-that-can-be-out-of-order-staff-work-allocations-3-
Sheet: Sheet1

 |  |  |  | Job Allocations
 |  |  |  |  | Technician
 |  |  |  | Task | HIDDEN | AM | HIDDEN | PM | HIDDEN | N
 |  |  | 1 | Autoclaves
 |  |  |  | Wrapping
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME]
 |  |  |  | Booking On |  |  |  |  |  |  |  |  |  |  | 45000 | [NAME]
 |  |  | 2 | [NAME] |  |  |  |  |  |  |  |  |  |  | 45046 | [NAME]
 |  |  |  | Supps |  |  |  |  |  |  |  |  |  |  | 45046 | [NAME]
 |  |  |  | Clean |  |  |  |  |  |  |  |  |  |  | 45058 | peppa SHARP
 |  |  |  | Clean |  |  |  |  |  |  |  |  |  |  | 45062 | [NAME]
 |  |  |  | Clean |  |  |  |  |  |  |  |  |  |  | 45069 | Prince SHAJI
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  |  |  | Clean
 |  | Training - Porter
 |  | Training - Autoclaves
Spreadsheet: 829287d1684091761-is-there-a-formula-to-extract-a-specific-string-from-a-cell-not-in-a-particular-position-s666-pq-extract-a-specific-string-from-a-cell
Sheet: Sheet1

Text | Code |  | Text | Custom
The quick brown fox jumps over the lazy dog; AB12: 025-12345678.12 | 12345678.12 |  | The quick brown fox jumps over the lazy dog; AB12: 025-12345678.12 | 12345678.12
12345678 -The quick brown fox 12345678.12 jumps over the lazy dog | 12345678.12 |  | 12345678 -The quick brown fox 12345678.12 jumps over the lazy dog | 12345678.12
12345678 -The quick brown fox jumps over the lazy dog | 12345678 |  | 12345678 -The quick brown fox jumps over the lazy dog | 12345678
The quick brown fox jumps over the lazy dog; AB12: ABC12345678.12 | 12345678.12 |  | The quick brown fox jumps over the lazy dog; AB12: ABC12345678.12 | 12345678.12
1234567 -The quick brown fox jumps over the lazy dog |  |  | 1234567 -The quick brown fox jumps over the lazy dog
Spreadsheet: 682303d1591991715-static-date-based-on-single-cell-value-excel-help
Sheet: 2020 - WANT

 | AK STOCK |  | 115282.57 |  |  |  |  |  |  |  |  |  |  |  | 74898.96
 | VANGUARD |  | 123647.62
2020 |  |  |  |  |  |  | 0 |  |  |  |  |  | er
 | Jan |  | Feb |  | Mar | 1st Qtr | Apr |  | May |  | Jun | 2nd qtr | moved from AK USA |  |  |  |  |  | Daily Diff - WANT |  | Alternative - WANT
 | 10 |  | 15 |  | 14 |  | 20 |  | 25 |  | 100 |  | 6.25.14
 | Jul |  | Aug |  | Sep | [NAME] | Oct |  | Nov |  | Dec | [NAME]
Spreadsheet: 470808d1468669839-auto-fill-a-row-by-data-from-another-sheet-when-i-type-a-cell-value-auto-populate-row
Sheet: customer data

Cust ID | Name | Phone
728 | [NAME] | 7572
727 | Sasi P R | 7657
726 | USHA BABY | 7675757
725 | [NAME] | 78678686
724 | [NAME] | 767677
723 | [NAME] ABRAHAM | 7676776
722 | JACOB THOMAS | 868767868
721 | [NAME] | 95995
720 | [NAME] | 8598589
719 | N C Puravath | 76767
718 | RASHEENA MATHEW | 767676786
717 | CHINNAMA VARGHESE | 767676
716 | ANIL K PAUL | 7676776
715 | [NAME] | 7676767
714 | M A THAMPI | 7676767
713 | AMMU PRAKASH | 76767
712 | Santha K V | 767767776
Spreadsheet: 121221d1315927716-split-data-into-different-sheets-book2
Sheet: Sheet1

BL00148 |  |  | Apollo | VP820 |  | ORIG. | EACH
BL00157 |  |  | Apti | [NAME] |  | ORIG. | EACH
BL00168 | SP-LAMP-LP2E | 420059 | ASK | C20 |  | ORIG. | EACH
BL00168-14 | SP-LAMP-LP2E | 420059 | ASK | C20 |  | Pro-Gen Module - Philips bulb | EACH
BL00169 | 22000015 | SP-LAMP-006 | ASK | C200 |  | ORIG. | EACH
BL00169-04 | 22000015 | SP-LAMP-006 | ASK | C200 |  | Original Bulb Only - Philips | EACH
BL00169-14 | 22000015 | SP-LAMP-006 | ASK | C200 |  | Pro-Gen Module - Philips bulb | EACH
BL00171 | SP-LAMP-008 | 22000046 | ASK | C300HB |  | ORIG. | EACH
BL00171-04 | SP-LAMP-008 | 22000046 | ASK | C300HB |  | Original Bulb Only - Philips | EACH
BL00171-14 | SP-LAMP-008 | 22000046 | ASK | C300HB |  | Pro-Gen Module - Philips bulb | EACH
BL00172-04 | SP-LAMP-005 | SP-LAMP-005 | ASK | C40 |  | Original Bulb Only - Philips | EACH
BL00173 | 60 257642 | SP-LAMP-007 | ASK | C50 |  | ORIG. | EACH
BL00173-04 | 60 257642 | SP-LAMP-007 | ASK | C50 |  | Original Bulb Only - Philips | EACH
BL00174 | SP-LAMP-LP2E | 420059 | ASK | C60 |  | ORIG. | EACH
BL00174-04 | SP-LAMP-LP2E | 420059 | ASK | C60 |  | Original Bulb Only - Philips | EACH
BL00174-14 | SP-LAMP-LP2E | 420059 | ASK | C60 |  | Pro-Gen Module - Philips bulb | EACH
BL00175-14 | 403321 | LAMP-026 | ASK | C80 |  | Pro-Gen Module - Philips bulb | EACH
BL00176-04 | 60252422 | LAMP-031 | ASK | C85 |  | Original Bulb Only - Philips | EACH
BL00176-14 | 60252422 | LAMP-031 | ASK | C85 |  | Pro-Gen Module - Philips bulb | EACH
Spreadsheet: 697070d1601139164-sum-if-function-returning-0-similar-sumifs-working-fine-portfolio-tracker
Sheet: Cash Summary

 | CASh
 | #[NAME]!
 | Account Detal | Category | Industry | Account | Trade Currency | Value (Trade Currency) | Value (CAD) | Value (USD) | Total Value (CAD Equivalent) | Total Value (USD Equivalent | Shares | Price | Change | Change (%) | MER (%) | Beta | Market cap | Volume | USD Equiv
 | Questrade CAD Cash | Cash |  | Questrade - TFSA | CAD | 0
 | Questrade USD Cash | Cash |  | Questrade - TFSA | USD | 0
 | TD - TFSA | Cash |  | TD - TFSA | CAD | 0
 | TD - Chequing | Cash |  | TD - Chequing | CAD | 300 |  |  | 660
 | Total CAD Value
Spreadsheet: darron_c_giron__8007__AGAVE
Sheet: Jan 00

 |  |  |  | 2000-01-01 00:00:00
 |  | Note: Insert the #'s in red to calculate the customer price
 |  | Crude Merc | IF-Elpaso Perm | IF-HH | IF-Elpaso/SJ | IF-TW-Permian
 |  | 27.014 | 2.19 | 2.36 | 2.18 | 2.18
 |  |  |  | Spot price |  | Index Price
CPR# | Sitara # | TAGG # | PanEnergy/Duke | Facility | Term | Calculated Price
98063 |  | E21728 | 2,500/day | 813780 | 7/95-12/2001
CPR# |  | TAGG # | Union Pacific | Facility | Term | Calculated Price
48853 |  | E11400 | 2,500/day | 813367 | 1/92-12/2003
CPR# |  | TAGG # | Union Pacific | Facility | Term | Calculated Price
3217 |  | E22656 | 7,000/day | 813367 | 1/95-12/2001
CPR# |  | TAGG # | Southern | Facility | Term | Calculated Price
105390 |  | E21977 | 10,000/day | 501079 | 6/96-4/2002
CPR# |  | TAGG # | Agave/Yates | Facility | Term | Calculated Price | Differential
354827 | 56562 | E20337 | 10,000/day | 58649 | 1/93-12/2002
Spreadsheet: 178340d1346766969-using-vlookup-or-match-for-certain-criteria-to-return-a-drop-down-list-delivery-and-orders-example-3
Sheet: Deliveries

Ref | W/E | Date Received | Month | Supplier | Description | Qty | WG Code | Order No | Cost Per Unit | Cost | Accrual | Total
1 | 2012-09-02 00:00:00 | 2012-08-23 00:00:00 | AUGUST | HILTI | VARIOUS ITEMS FOR CREDIT | 1 | 3100 | M0001 |  | 0 | Yes | 0
2 | 2012-09-02 00:00:00 | 2012-08-30 00:00:00 | AUGUST | GLENDINNING | RC40 20 CEM 11/A-LL M300 | 6 | 2200 | M0020 |  | 0 | Yes | 0
3 | 2012-09-02 00:00:00 | 2012-08-28 00:00:00 | AUGUST | PARKER | 380MM BLACK CABLE TIE | 500 | 3100 | M0011 |  | 0 | Yes | 0
 |  |  |  |  |  |  |  |  | Search other tabs for cost per unit but as the descriptions don’t match can all the items under that [NAME] number be displayed in a drop down list so I can select the correct one and it will return the unit price in column J2?