tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Texas - Orig

 | Texas Gas - Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 573145 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 91502 | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 67829
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 388571 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 40000
ENASUPP | Supplies Expense |  |  |  |  |  | 109829
ENAMKTEX | Marketing |  |  |  |  |  | 8571 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 0 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 45714 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 11429 | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 2
 |  |  |  |  |  |  |  | Director | 143000 | 1
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 717365d1612613414-dynamic-named-range-for-a-non-contiguous-range-dnr_for_noncontig
Sheet: sum

Food | ALAN | BILLY | CATHY |  | ALAN | BILLY | CATHY
apple | 70.55474853515625 | 53.34240341186523 |  | 1
spinach | 19.1922492980957 | 67.8913345336914 | 45.42078399658203 | spinach
cocoa | 98.53739166259766 | 80.25873565673828 |  | cocoa |  |  |  | spinach |  | 45.42078399658203
broccoli | 65.2376708984375 | 90.03338623046875 | 23.15966415405273 | broccoli |  |  |  | cocoa |  | 0
squash | 42.01113510131836 |  | 55.84447860717773 | squash |  |  |  | broccoli |  | 23.15966415405273
blueberry | 49.33584213256836 | 45.28281784057617 | 59.779541015625 | blueberry |  |  |  | squash |  | 55.84447860717773
[NAME] | 15.65493965148926 | 64.30648803710938 |  | [NAME] |  |  |  | blueberry |  | 59.779541015625
orange | 94.22235870361328 | 46.68283462524414 | 72.4007797241211 | orange |  |  |  | [NAME] |  | 0
lemon | 39.71416473388672 |  | 80.5818862915039 | lemon |  |  |  | orange |  | 72.4007797241211
lettuce | 22.73047637939453 |  |  | 2 |  |  |  | lemon |  | 80.5818862915039
banana | 85.31307220458984 | 17.29496765136719 | 66.41155242919922 | 3 |  |  |  | 2 |  | 0
chocolate | 65.60359954833984 | 15.20514488220215 | 68.83580017089844 | 3 |  |  |  | 3 |  | 66.41155242919922
candy | 44.76734924316406 | 32.99952697753906 |  | 4 |  |  |  | 3 |  | 68.83580017089844
pumpkin | 94.30778503417969 |  |  | 5 |  |  |  | 4 |  | 0
radish | 26.89656639099121 | 31.06988716125488 |  | 5 |  |  |  | 5 |  | 0
walnut | 78.84426879882812 | 47.21164703369141 | 7.63074779510498 | 5 |  |  |  | 5 |  | 0
almond | 77.33670806884766 | 5.848085880279541 |  | 6 |  |  |  | 5 |  | 7.63074779510498
tofu | 70.5619125366211 | 69.44639587402344 | 73.76341247558594 | 1 |  |  |  | 6 |  | 0
bread | 23.85267639160156 |  | 91.58826446533203 | A |  |  |  | 1 |  | 73.76341247558594
 |  |  |  |  |  |  |  | A |  | 91.58826446533203
Spreadsheet: kim_ward__20778__PNM Isda
Sheet: ANEWSWP2

ISDA SWAP AGREEMENT INFORMATION SHEET
 |  | ATTORNEY:
DATE: | 2001-01-31 00:00:00 | DEAL MAKER: | [NAME]
COUNTERPARTY: | Public Service Company of New Mexico | CONTACT: | [NAME]
ADDRESS: | Alvarado Square | TITLE: | Gas Acquisition Representative
 | 414 Silver Ave S.W | PHONE: | [PHONE]
 | Albuquerque NM, 87158-2610 | FAX: | [PHONE]
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | Enron Corp. (BBB+)
GUARANTOR (RATING) |  | Enron Corp. (BBB+)
LIMIT $ MILLIONS |  | $10MM
Incorporation State |  | Oregon
ELEGIBLE SWAP PARTICIPANT
Counterparty | YES | YES
Guarantor
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | $6MM | $10MM
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X | X
Cash | X | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING
Delivery Amount | 250000 | 250000
Return Amount | 250000 | 250000
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = S&P/Moody's | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | $25MM
-Guarantor ($[NAME]) |  | 100
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
According to the Board, Counterparty cannot enter into financial transactions over 18 months.
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x5-3596
Spreadsheet: 57147d1257296981-nested-ifs-greater-same-or-less-like-this
Sheet: Sheet1

 | Jan | Feb | Mar | April
 | 450 | 450 | 450 | 450
 | 325 | 300
 |  |  | 300
 |  |  |  | 200
 |  |  |  | 300
Spreadsheet: 714101d1611088220-sum-with-multiple-criteria-sumifs-query-v3-1-sumproduct
Sheet: Sheet1

 |  | TABLE A
 |  |  |  |  |  |  |  | 2020/21 | 2020/21 | 2020/21
 |  | CostCtre | DeptCode | Job Number | Project Number i.e. this is the NOC, NPFC or AT number | Project Header | Activity | Period Number | Period Number | Period Number
 |  |  |  |  |  |  |  | 10 | 11 | 12
 |  | ABC | DEP | 123 |  | Labour_Solutions | Start Up | 1644.522530953505 | 1644.522530953505 | 1644.522530953505
 |  | DEF | DEP | 123 |  | Labour_Solutions | Feasibility | 27359.39386884803 | 27359.39386884803 | 27359.39386884803
 |  | GHI | DEP | 123 |  | Labour_Solutions | Closure | 48410.2402067556 |  | 48410.2402067556
 |  | JKL | DEP | 123 |  | Labour_Solutions | Invoicing | 3979.475667812074 | 3979.475667812074 | 3979.475667812074
 |  | MNO | DEP | 123 |  | Labour_Quality | Implementation | 16018.07660019648 | 16018.07660019648
 |  | PQR | DEP | 123 |  | Labour_Quality | Documentation | 8009.038300098238 | 8009.038300098238
 |  | TABLE B
 |  | Project | Project Header | Phase | Stage | Activity | Period Number | Period Number | Period Budget
 |  | 123 | Labour_Solutions |  |  | Start Up | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Feasibility | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Closure | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Invoicing | 10 | 2020
 |  | 123 | Labour_Quality |  |  | Implementation | 10 | 2020
 |  | 123 | Labour_Quality |  |  | Documentation | 10 | 2020
 |  | 123 | Labour_Solutions |  |  | Start Up | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Feasibility | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Closure | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Invoicing | 11 | 2020
 |  | 123 | Labour_Quality |  |  | Implementation | 11 | 2020
 |  | 123 | Labour_Quality |  |  | Documentation | 11 | 2020
 |  | 123 | Labour_Solutions |  |  | Start Up | 12 | 2020
 |  | 123 | Labour_Solutions |  |  | Feasibility | 12 | 2020
 |  | 123 | Labour_Solutions |  |  | Closure | 12 | 2020
 |  | 123 | Labour_Solutions |  |  | Invoicing | 12 | 2020
 |  | 123 | Labour_Quality |  |  | Implementation | 12 | 2020
 |  | 123 | Labour_Quality |  |  | Documentation | 12 | 2020
 |  |  |  |  | Hi, How do I get the values in col H, I & J from table A into the table below by Project header, Project Activity code and Period Number please?  I think it is some form of sumifs statement, but nothing I do is working.  Hoping someone can advise please.  Thank you so much in advance!  [NAME]
Spreadsheet: 889667d1740570664-calculating-pick-errors-with-yes-no-test-pick-data
Sheet: FEB

Pick Code | Required Date | [NAME] | Customer Reference | Customer Name | Pick Type | [NAME] | Pick Lines | Pick Units | Pick Cases | [NAME] By | YES/NO | ERROR Units | SKU
PICK006179 | 2024-08-21 00:00:00 | 98894233 | OI 663315 | PulseSync Labs | Case/Unit | 2024-10-22 11:35:00 | 15 | 5182 | 830 | [NAME] | NO
PICK006180 | 2024-08-21 00:00:00 | 98894233 | OI 663315 | Nexora Technologies | Full Pallet | 2024-10-22 06:43:00 | 1 | 1080 | 90 | [NAME] | NO
PICK006183 | 2024-09-09 00:00:00 | 98898960 | OI 661517 | Evercore Innovations | Case/Unit | 2024-10-22 07:38:00 | 1 | 4 | 1 | [NAME] | NO
PICK006184 | 2024-09-09 00:00:00 | 98898962 | OI 663315 | Vertex Dynamics | Case/Unit | 2024-10-22 06:20:00 | 1 | 396 | 33 | Ava Sinclair | NO
PICK006181 | 2024-09-09 00:00:00 | 98898964 | OI 664576 | BlueHorizon Enterprises | Full Pallet | 2024-10-23 10:40:00 | 1 | 696 | 116 | [NAME] | Yes | 6 | 475487
PICK006185 | 2024-09-09 00:00:00 | 98898964 | OI 664576 | Luminex Solutions | Case/Unit | 2024-10-22 10:21:00 | 7 | 2184 | 263 | [NAME] | NO
PICK006182 | 2024-09-09 00:00:00 | 98898972 | OI 664576 | Skyline Ventures | Full Pallet | 2024-10-22 06:43:00 | 1 | 1080 | 180 | [NAME] | NO
PICK006186 | 2024-09-09 00:00:00 | 98898972 | OI 664576 | PulseSync Labs | Case/Unit | 2024-10-22 10:23:00 | 6 | 2157 | 262 | [NAME] | NO
PICK004962 | 2024-09-27 00:00:00 | 98899282 | PO1406617 | NovaFusion Industries | Full Pallet | 2024-10-03 18:52:00 | 4 | 971 | 203 | Ava Sinclair | NO
PICK004963 | 2024-09-27 00:00:00 | 98899282 | PO1406617 | PulseSync Labs | Case/Unit | 2024-10-03 20:03:00 | 17 | 1944 | 411 | [NAME] | Yes | 12 | 457845
PICK005034 | 2024-10-10 00:00:00 | 98899283 | PO1406979 | Nexora Technologies | Full Pallet | 2024-10-07 15:56:00 | 1 | 4160 | 1040 | [NAME] | NO
PICK005035 | 2024-10-10 00:00:00 | 98899284 | PO1406977 | Evercore Innovations | Full Pallet | 2024-10-07 15:57:00 | 1 | 4160 | 1040 | [NAME] | NO
Spreadsheet: 861413d1709280827-index-match-help-race-2
Sheet: Race

BANK MAUR
Post. | Mar. | Venue | Class | Dist. | Con. | Wgt. | Bar. | Other Runners | Off. Race Time
21 days since last run
9-13 | 4.3 | CAUL | Group 2 | 1100 | Good | 59 | 1 | 1-Kallos | 0:01:02.900000
Spell - 106 days
7-7 | 11.2 | M V | Group 3 | 2040 | Good | 60 | 1 | 1-Ain'tnodeeldun | 0:02:05.220000
14-16 | 13 | FLEM | Group 1 | 2000 | Good | 56 | 3 | 1-Gold Trip | 0:02:01.620000
9-15 | 4.4 | CAUL | Group 1 | 1800 | Good | 58 | 1 | 1-Alligator Blood | 0:01:48.530000
8-14 | 2.9 | CAUL | Group 1 | 1400 | Good | 58.5 | 7 | 1-Mr Brightside | 0:01:23.220000
Spell - 161 days
13-16 | 7.4 | FLEM | Group 1 | 2000 | Good | 54.5 | 7 | 1-Cascadian | 0:02:01.430000
1-11 | 0.8 | M V | Group 2 | 2040 | Good | 57 | 1 | 2-Suizuro | 0:02:06.440000
4-15 | 1.3 | FLEM | Group 1 | 1600 | Good | 57 | 15 | 1-Legarto | 0:01:36.340000
7-14 | 1.5 | FLEM | Group 3 | 1400 | Good | 57 | 8 | 1-Elliptical | 0:01:21.960000
2-11 | 0.1 | SANH | Group 3 | 1300 | Good | 57 | 3 | 1-Jacquinot | 0:01:17.670000
Spreadsheet: 763049d1641959163-alternative-to-xlookup-for-multiple-possible-results-example-question-for-excel-help
Sheet: Sheet1

Customer ID | Fruit | Date Purchased |  |  | Customer ID | Veg | Date Purchased
1 | Orange | 2021-02-01 00:00:00 |  |  | 1 | Broccoli | 2021-02-02 00:00:00
2 | Lemon | 2021-02-01 00:00:00 |  |  | 1 | Broccoli | 2021-02-03 00:00:00
2 | Orange | 2021-02-02 00:00:00 |  |  | 3 | Cauliflower | 2021-02-01 00:00:00
2 | Lemon | 2021-02-03 00:00:00 |  |  | 3 | Broccoli | 2021-02-02 00:00:00
3 | Orange | 2021-02-03 00:00:00 |  |  | 4 | Cauliflower | 2021-02-02 00:00:00
4 | Lemon | 2021-02-01 00:00:00 |  |  | 4 | Broccoli | 2021-02-03 00:00:00
5 | Orange | 2021-02-01 00:00:00 |  |  | 6 | Cauliflower | 2021-02-01 00:00:00
5 | [NAME] | 2021-02-02 00:00:00 |  |  | 6 | Broccoli | 2021-02-02 00:00:00
5 | Lemon | 2021-02-03 00:00:00 |  |  | 6 | Carrot | 2021-02-03 00:00:00
Spreadsheet: 3e3a2759-ace7-41bc-922a-b63acd79ae2f
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
EGFR | Test | EGFR | [NAME], 29 Mutation Panel, Tumor | [NAME], Tumor | Polymerase Chain Reaction (PCR) Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Plastic container: PlCont |  |  |  | Varies | Pathology report must accompany specimen in order for testing to be performed.   Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions.   Preferred: [NAME]: Tissue Container/Tube: Tissue block Collection Instructions: Submit a formalin-fixed, paraffin-embedded tissue block.   Acceptable: [NAME]: Tissue Container/Tube: Slides Specimen Volume: 1 stained and 5 unstained Collection Instructions: Submit 1 slide stained with hematoxylin and eosin and 5 unstained, nonbaked slides with 5-micron thick sections of the tumor tissue. | Formalin-fixed, paraffin-embedde | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; 10 am | 5 days | 7 days | 1 | 81235 |  |  |  |  | Rochester
EGFR | [NAME] | VARIES | Varies |  |  |  | Ambient
EGFR | Result | 33305 | [NAME] | [NAME] | Alphanumeric
EGFR | Result | 33306 | [NAME] | [NAME] | Alphanumeric
EGFR | Result | 33307 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
EGFR | Result | 33308 | Order Date | Order Date | Alphanumeric
EGFR | Result | 33309 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
EGFR | Result | 33310 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
EGFR | Result | 33311 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
EGFR | Result | 33312 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
EGFR | Result | 33313 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
EGFR | Result | 33314 | Reviewed By: | Reviewed By: | Alphanumeric
EGFR | Result | 33315 | Release Date | Release Date | Alphanumeric
EGFR | [NAME] | SLRVW | Slide Review ([NAME] Only) | Slide Review |  |  |  |  |  |  | For billing purposes only. |  |  |  |  |  |  | 1 | 88381 |  |  | Yes | No
Spreadsheet: larry_campbell__21333__NERC Training Schedule
Sheet: Sheet1

NERC Certification Training
Teams: | Beginning Date | Room Location
#1, [NAME], [NAME], | 2000-09-18 00:00:00 | Classroom 3109 |  |  | Swapped [NAME] and [NAME] because [NAME]
[NAME], [NAME], [NAME], | 2000-09-25 00:00:00 | Sample Testing |  |  | was not going to be in house.08/23/00
[NAME], [NAME], [NAME].
#2 , [NAME], [NAME], | 2000-10-02 00:00:00 | Classroom 3109 |  |  | Check w/[NAME] about [NAME] and available
[NAME], [NAME], | 2000-10-09 00:00:00 | Sample Testing |  |  | space for PC usage?
[NAME], [NAME],[NAME]
 |  |  |  |  | Have [NAME] book a room for the training period
#3, [NAME], [NAME], [NAME], | 2000-10-16 00:00:00 | Classroom 3109
Chad Starnes, [NAME], Dean Laurent | 2000-10-23 00:00:00 | Sample Testing
[NAME], [NAME]
#4 [NAME], [NAME], | 2000-10-30 00:00:00 | Classroom 3109
[NAME], Russel Ballato, [NAME], | 2000-11-06 00:00:00 | Sample Testing
[NAME], [NAME]
#5 Cyril Price, [NAME], [NAME], | 2000-11-13 00:00:00 | Classroom 3109
[NAME], [NAME], [NAME] | 2000-11-20 00:00:00 | Sample Testing
[NAME]
Note: The training is structured as:
Week one will consist of classroom training from 08:00 until 04:00. A copy of the NERC book will be
issued on the first day of class. Planned for Monday through Friday.
Week two NERC sample test will be taken. This will be performed in a classroom
setting with one practice test a day for a duration of 2-3 hours.
You will then report to your work station.
A large amount of information will be covered in a short time. To make the most of our classroom
time together please eat and use the restroom before leaving the house since there will not be any
scheduled breaks for such time consuming activities.Thanks for your support on this matter.
Spreadsheet: 812358d1673093330-conditonal-format-issue-cond-ratio-highlight-1-cf
Sheet: Sheet1

139 : 32 | 13 : 340 | 13 : 20 | 45 : 294 | 15 : 22
140 : 31 | 13 : 341 | 13 : 19 | 9 : 59 | 45 : 65
140 : 31 | 13 : 342 | 13 : 18 | 45 : 297 | 5 : 7
141 : 31 | 13 : 343 | 13 : 17 | 45 : 298 | 45 : 62
141 : 31 | 14 : 344 | 14 : 16 | 3 : 20 | 45 : 60
142 : 31 | 14 : 345 | 14 : 15 | 45 : 302 | 45 : 58
71 : 15 | 14 : 346 | 01:01:00 | 15 : 101 | 45 : 57
71 : 15 | 14 : 347 | 14 : 13 | 45 : 305 | 9 : 11
71 : 15 | 14 : 348 | 14 : 12 | 5 : 34 | 45 : 54
143 : 31 | 14 : 349 | 14 : 11 | 45 : 308 | 45 : 52
144 : 31 | 14 : 350 | 14 : 10 | 15 : 103 | 9 : 10
24 : 5 | 1 : 27 | 14 : 9 | 45 : 311 | 15 : 16
24 : 5 | 14 : 352 | 14 : 8 | 15 : 104 | 45 : 47
29 : 6 | 14 : 353 | 14 : 7 | 45 : 314 | 1 : 1
29 : 6 | 14 : 354 | 14 : 6 | 1 : 7 | 45 : 44
29 : 6 | 14 : 355 | 14 : 5 | 45 : 317 | 15 : 14
73 : 15 | 14 : 356 | 14 : 4 | 45 : 319 | 9 : 8
147 : 30 | 14 : 357 | 14 : 3 | 9 : 64 | 15 : 13
147 : 30 | 2 : 51 | 7 : 1 | 45 : 322 | 45 : 38
148 : 30 | 7 : 179 | 14 : 1 | 45 : 324 | 5 : 4
148 : 30 | 14 : 360 | 1 : 0 | 9 : 65 | 45 : 35
149 : 30 | 1 : 0 | 1 : 0 | 45 : 327 | 15 : 11
149 : 30 | 14 : 2 | 14 : 2 | 45 : 329 | 45 : 31
149 : 29 | 7 : 1 | 7 : 1 | 3 : 22 | 45 : 30
150 : 29 | 14 : 4 | 14 : 4 | 45 : 332 | 45 : 28
150 : 29 | 7 : 2 | 7 : 2 | 5 : 37 | 45 : 27
151 : 29 | 14 : 6 | 14 : 6 | 45 : 335 | 9 : 5
151 : 29 | 7 : 3 | 7 : 3 | 15 : 112 | 45 : 24
Spreadsheet: 546295d1509981357-cascading-drop-down-data-validation-lists-with-only-unique-items-dynamic-drop-down
Sheet: Table

base table | skill 1 | skill 2 | skill 3
[NAME] | manager | cashier | janitor |  | Use this table as your base table as you stated in your post, this then transfers to the List Sheet
[NAME] | cashier | janitor
[NAME] | janitor
 |  |  | drop downs using data validation and named ranges (ctrl+F3) for dynamic lists
 |  | "job" list | in named range screen (ctrl+F3) enter the name and this formula
 |  |  | =OFFSET(anchorcell,,1,,COUNTA(List!$1:$1)-1)
 |  | janitor | the formula for the data validation list in C10 is
 |  |  | =job
 |  | [NAME] | the formula for the data validation list in C14 is
 |  |  | =OFFSET(anchorcell,1,MATCH($C11,job,0),COUNTIF(OFFSET(anchorcell,,MATCH($C11,job,0),100,1),"?*")-1,1)
 |  |  | Using INDEX and MATCH to link to another table and give you how much the person would earn
Spreadsheet: 206430d1358186491-excel-sheet-test
Sheet: Sheet1

Amanda [NAME] | [NAME] | 2013-08-24 00:00:00 | NY | http://ZwolakAndSaddleson.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] | 2013-09-07 00:00:00 | IA | http://ZwiefelAndBuck.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] | 2013-04-27 00:00:00 | VA | http://ZwernerPiper.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] | 2013-07-27 00:00:00 | MI | http://ZwemmerHruby.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] | 2013-04-14 00:00:00 | CT | http://ZweifelAndCox.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] zwahlen | 2013-08-17 00:00:00 | MA | http://zwahlenAndFisher.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] | 2013-06-08 00:00:00 | KS | http://ZurovskyKlein.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] | 2013-06-01 00:00:00 | NE | http://ZulkoskiHammrich.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
Dustin Zuch | [NAME] | 2013-10-05 00:00:00 | MA | http://Zuch-Heitz.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
[NAME] | [NAME] | 2013-07-20 00:00:00 | CT | http://ZuberCummings.ourwedding.com?&cm_mmc=Affiliate-_-TheKnot-_-HPSearch-_-HPSearch
Spreadsheet: 159618d1338787153-if-problem-cell-contains-text-and-numbers-fifts-1-
Sheet: Sheet1

00:01:11 | $ |  | 5f | 5.5f | 6f | 6.5f | 7f | 8.3f | 8.5f
 |  |  |  |  |  |  |  |  |  |  |  | 00:00.0
 |  | 1c | :22.2 | 22.45 | 22.45 | 23.02 | 23.3 | 23.54 | 25.25 |  |  |  |  | Restored
 |  |  |  |  | 0.2 | 0.6 | 0.8 | 1s | 2.8
00:01:10 |  |  |  |  | 1 | 3 | 4 | 5 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22.47
 |  | 2c | 45.42 | 45.52 | 45.2 | 45.57 | 46.24 | 47.93 | 50.03 | 00:01:10 |  |  |  |  |  | Create table for all combinations
 |  |  |  | 0.2 |  |  |  |  |  |  |  |  |  |  |  | In K12 below formula ctrl+shift+enter   not just enter
 |  |  |  | 1 |  |  |  | 4 |  |  |  |  | 00:01:09 |  | 1St | 11 |  | [NAME] is: | INDEX(S11:S22,MATCH(I12&J12,Q11:Q22&R11:R22,0))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1St | 2nd | 3rd | For second (2nd) formula change S11:S22 to T11:T22
 |  |  |  |  |  |  |  | age/sex | distance | 1st | 2nd | 3rd | fin | rate |  | 3up m&f | 4.5 | 1
 | Ç | distance | 1st | 2nd | 3rd | fin |  | 3up fem | 6 | 22.67 | 45.08 |  | 1900-01-01 00:00:00 |  |  | 3up m&f | 5 | 2
 |  | 4.5 | 22.32 | 45.41 | 51.34 |  | 0 | 3up m&f | 4.5f | 22.40290322580645 | 45.20387096774193 |  |  | 0.267096774193547 |  | 3up m&f | 5.5 | 3
 |  | 5 | 22.07 | 45.16 | 57.76 |  | 5 | 3up fem | 5f | 22.15290322580645 | 44.95387096774193 |  |  | 0.517096774193547 |  | 3up m&f | 6 | 4
 |  | 5.5 | 22.48 | 45.37 |  | 00:01:04 | 5.5 | 2yr | 5.5f | 22.56290322580645 | 45.16387096774193 |  |  | 0.1070967741935469 |  | 3up m&f | 6.5 | 5
 |  | 6 | 22.58709677419355 | 45.28612903225807 |  | 00:01:10 | 6 | 3up fem | 6f | 22.67 | 45.08 |  |  | 0 |  | 3up m&f | 7 | 6
 |  | 6.5 | 23.12 | 45.82 | 00:01:11 | 00:01:17 | 6.5 | 3 fem | 6.5f | 23.20290322580646 | 45.61387096774193 |  |  | -0.5329032258064537 |  | 3up m&f | 7.5 | 7
 |  | 7 | 23.12 | 45.85 | 00:01:11 | 00:01:23 | 7 | 3up m&f | 7f | 23.20290322580646 | 45.64387096774193 |  |  | -0.5329032258064537 |  | 3up fem | 4.5 | 8
 | 1Ñ m | 8.3 | 24.91 | 49.26 | 00:01:13 | 00:01:03 | 1 | 3up fem | 1Ñ | 24.99290322580645 | 49.05387096774193 |  |  | -2.322903225806453 |  | 3up fem | 5 | 9
 | 1ˆ m | 8.5 | 25 | 49.4 | 00:01:14 | 00:01:45 | 1 | 2yr | 1ˆ | 25.08290322580645 | 49.19387096774193 |  |  | -2.412903225806453 |  | 3up fem | 5.5 | 10
 | 1„ m | 9 | 24.88 | 49.86 | 00:01:14 | 00:01:51 | 1 | 3 m&f | 1„ | 24.96290322580645 | 49.65387096774193 |  |  | -2.292903225806452 |  | 3up fem | 6 | 11
 | 1[NAME] m | 10 | 24.2 | 48.4 | 00:01:13 | 00:01:39 | 00:02:05 | 3 fem | 1[NAME] | 24.28290322580645 | 48.19387096774193 |  |  | -1.612903225806452 |  | 3up fem | 6.5 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3up fem | 7 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3up fem | 7.5 | 14
 |  |  |  |  |  | age/sex | 3up m&f | 3up fem | 2yr | 3 m&f | 3 fem
 |  | 1mile - | 1760 yards |  |  | restriction | 1 | 2 | 3 | 4 | 5
 |  | 1mile - | 8 furlongs
 |  | 1 furlong - | 220 yards
 |  | 70 yards - | 0.31818 furlongs
 | 1