tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125951d1319427934-mid-and-find-question-book2
Sheet: Sheet1

 | defg= | & | = | Difference | Numbers
&abc=123435&defg=54321&hijklmno=14& | defg=54321 | 23 | 17 | 6 | 54321
&abc=13435&defg=54372178&hijklmno=14& | defg=54372178 | 25 | 16 | 9 | 54372178
&abc=123435&defg=5432178&hijklmno=14& | defg=5432178 | 25 | 17 | 8 | 5432178
Spreadsheet: 59332d1259824542-drop-down-list-testworksheet
Sheet: data

doral | EF |  |  | Workers | SS# | address | city | state | zip
willow | 1/1 |  |  | xxx yyyyyyyyy | 111-22-333 | 1234 aaaaaa | [NAME] | tx | 75001
fox | 2/1 |  |  | x11 [NAME] | 111-22-333 | 1234 aaaaaa | aaa | tx | 75001
tps | 2/2 |  |  | x22 [NAME] | 111-22-333 | 1234 aaaaaa | bbbb | tx | 75002
del rey | 3/2
 |  | Full Paint (1 bdr. /1bth. apt.) | 40
 |  | Full Paint (2 bdr. /1bth. apt.) | 50
 |  | Full Paint (2 bdr. /2bth. apt.) | 60
 |  | Full Paint (3 bdr. /2bth. apt.) | 70
 |  | Cabinets (k/b) | 40
 |  | Cabinets (k/b/b) | 55
 |  | 1 BDR ceilings | 15
 |  | 2 BDR ceilings | 25
 |  | 3 BDR ceilings | 35
Spreadsheet: 80075d1280306955-excel-2007-freezing-column-book11
Sheet: Sheet1

This I have |  |  | That i want
100 | 250 |  | 0 | 0 | 350
125 | 300 |  | 0 | 0 | 425
123 | 123 |  | 0 | 0 | 246
100 | 110 |  | 0 | 0 | 210
Spreadsheet: 103870d1301532756-linking-cells-in-different-sheets-only-when-the-cell-is-not-blank-itw-spot-sheets
Sheet: MASTER

CUE | pg | SPOT 1 |  |  |  | SPOT 2 |  |  |  | SPOT 3 - JESSIE |  |  |  | SPOT 4 |  |  |  | SPOT 5
Cue # |  | COLOR | INT. | FADE | Notes | COLOR | INT. | FADE | Notes | COLOR | INT. | FADE | Notes | COLOR | INT. | FADE | Notes | COLOR | INT. | FADE | Notes
Line/Cue |  | PERSON |  |  |  | PERSON |  |  |  | PERSON |  |  |  | PERSON |  |  |  | PERSON
 |  | SIZE |  |  |  | SIZE |  |  |  | SIZE |  |  |  | SIZE |  |  |  | SIZE
Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue -- Prologue
124 |  | (2) | 0 | ↓3 | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes
 |  |  |  |  | THIS SHIT IS FO REAL
 |  | [NAME]'s Wife
 |  | 1/2 Body
128 |  | (4) | 0.75 | 4 | Notes | (1+3) | fl | ↑5 | Notes |  |  |  | Notes | (1+5) | 0.75 | ↑5 | Notes |  |  |  | Notes
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Litte Red
 |  |  |  |  |  | Full body |  |  |  |  |  |  |  | Full Body
156 |  |  |  |  | Notes |  |  |  | Notes | (1+5) | 0.75 | ↑5 | Notes |  |  |  | Notes |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  | Litte Red
 |  |  |  |  |  |  |  |  |  | Full Body
 |  |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes
 |  |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes
 |  |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes
 |  |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes |  |  |  | Notes
Spreadsheet: 32046d1228167949-compilation-work-sheet-excel-forum-leger-balance
Sheet: GHI Supply

Date | Qty | Description | Cost | Amount | Credits | Balance
2008-01-05 00:00:00 | 1 | [NAME] | 1.71 | 1.71 |  | 1.71
2008-01-09 00:00:00 | 6 | Henges | 1.69 | 10.14 |  | 11.85
2008-01-12 00:00:00 | 1 | WD-40 | 2.5 | 2.5 |  | 14.35
2008-01-14 00:00:00 |  |  |  |  | 14.35 | 1.77635683940025e-15
Spreadsheet: 129257d1321525892-combination-of-vlookup-and-hlookup-example3
Sheet: BEFORE

i | 2011-01-01 00:00:00 | Name | FTE | ATT | PL | SL | UL | WD | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
 |  |  |  |  |  |  |  |  | 2011-01-31 00:00:00 | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-06 00:00:00 | 2007-01-07 00:00:00 | 2006-01-08 00:00:00 | 2005-01-09 00:00:00 | 2004-01-11 00:00:00 | 2003-01-12 00:00:00 | 2002-01-13 00:00:00 | 2001-01-14 00:00:00 | 2000-01-16 00:00:00 | 1999-01-17 00:00:00 | 1998-01-18 00:00:00 | 1997-01-19 00:00:00 | 1996-01-21 00:00:00 | 1995-01-22 00:00:00 | 1994-01-23 00:00:00 | 1993-01-24 00:00:00 | 1992-01-26 00:00:00 | 1991-01-27 00:00:00 | 1990-01-28 00:00:00 | 1989-01-29 00:00:00 | 1988-01-31 00:00:00
 |  |  |  |  |  |  |  |  | Dec | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan | Jan
 | Availability
i |  | [NAME] | 0.9545454545454546 | 0.7727272727272727 | 1 | 1 | 1 | 15 | 7.12 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19.12 | UA | BT | SL | UL | RL | PL | CD | TR | N/A
i |  | [NAME] | 0.9545454545454546 | 0.7727272727272727 | 1 | 1 | 1 | 15 | 7.12 | PL | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19.12 | UA | BT | SL | UL | RL | PL | CD | TR | N/A
i |  | [NAME] | 0.9545454545454546 | 0.7727272727272727 | 1 | 1 | 1 | 15 | 7.12 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19.12 | UA | BT | SL | UL | RL | PL | CD | TR | N/A
i |  | [NAME] | 0.9545454545454546 | 0.7727272727272727 | 1 | 1 | 1 | 15 | 7.12 | 8 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19.12 | UA | BT | SL | UL | RL | PL | CD | TR | N/A
i |  | [NAME] | 0.9545454545454546 | 0.7727272727272727 | 1 | 1 | 1 | 15 | 7.12 | UL | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19.12 | UA | BT | SL | UL | RL | PL | CD | TR | N/A
 |  |  |  |  |  |  |  |  | Lets assume that current date is  1/1/2012 I want to see in the schedule in column B each cell to be colored in RED or GREEN depending on current date and if employee should be at work.  I want to change the colors in column B depending on the current date and what is the status of the employee regarding the current date.
 |  |  |  |  |  |  |  |  | EXAMPLE is shown on sheet below which is called AFTER but let me clarify, if current day is 1/1/2012 (cell k2) the employee [NAME] (cell c5) should be at work today from 7 o clock (cell k5)  I need the formula which will color the cell B5 in green because he should be at work today
 |  |  |  |  |  |  |  |  | here are the different status variations which can show if the employee should be at work on current day or not:
 |  |  |  |  |  |  |  |  | 7.12 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 19.12 | employee is at work
 |  |  |  |  |  |  |  |  |  |  |  |  | UA | BT | SL | UL | RL | PL | CD | TR | N/A | employee is not at work
Spreadsheet: e30b34ea-be71-4643-b88e-2aa7707ecefc
Sheet: Sheet1

Secondary Screen - Morphology (Bouton number) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Human Gene | [NAME] | CG | ID | Fold | ID | Fold | Confirmed
 |  | control |  | 1 |  | 1
FUT10 | FucTB | 4435 | GD40519 | 1.613672352169389 | GD40520 | 1.16203187250996 | N
n/d | FucTD | 9169 | CG27008 | 1.673980907569108 | CG27009 | 1.301474103585657 | Y
n/d | egghead | 9659 | GD10137 | 1.764466362032303 | GD405160 | 1.567051792828685 | Y
MAN1B1 | n/d | 11874 | GD101661 | 1.538252725874315 | GD4919 | 1.553784860557769 | Y
MAN1A2 | α-Man-I | 32684 | GD39572 | 1.538252725874315 | GD5528 | 1.447529880478087 | Y
PIGA | n/d | 6401 | KK107714 | 1.900194543727096 | GD39552 | 1.294820717131474 | N
[NAME] | n/d | 6904 | GD35136 | 1.462833099579242 | GD35137 | 1.693227091633466 | Y
GALT | Galt | 9232 | KK100025 | 1.387458716011401 | GD29087 | 1.49402390438247 | Y
n/d | n/d | 2135 | KK103338 | 1.402524544179523 | GD16628 | 1.241713147410359 | N
n/d | α-Man-IIb | 4606 | GD42652 | 1.357281816947925 | KK108043 | 1.338645418326693 | Y
HK1 | Hex-t2 | 32849 | KK100218 | 1.402524544179523 | GD47331 | 1.640119521912351 | Y
n/d | [NAME] | 2958 | KK105118 | 1.372211916934353 | GD45294 | 1.440916334661354 | Y
n/d | lectin-21Cb | 13686 | KK106450 | 1.726779170248383 | GD32507 | 1.51394422310757 | Y
n/d | [NAME] | 33533 | KK107567 | 1.613672352169389 | GD51100 | 1.617529880478088 | Y
Secondary Screen - EJC
Human Gene | [NAME] | CG | ID | Fold | ID | Fold | Confirmed
 |  | control |  | 1 |  | 1
[NAME] | n/d | 4542 | KK104870 | 1.78298334743435 | GD7132 | 1.333961872626061 | Y
ST6GAL1 | ST6Gal | 4871 | KK100284 | 1.464487491529366 | GD47955 | 0.9787258997284349 | N
MAN1B1 | n/d | 11874 | KK101661 | 1.586143846409855 | GD4419 | 1.214332 | Y
GALNT1 | pgant5 | 31651 | GD2629 | 1.858419108949401 | KK110647 | 1.09022095110927 | N
HS6ST3 | hs6st | 4451 | KK101636 | 0.7962 | GD42658 | 0.65888 | Y
SULF1 | [NAME] | 6725 | GD37362 | 1.38972 | GD37361 | 1.32605 | Y
B3GAT3 | GlcAT-I | 32775 | KK107840 | 1.435388606645789 | TRiP.HMS00289 | 1.280938015517973 | Y
n/d | Lamp1 | 3305 | GD7309 | 1.664923754265391 | TRiP.GLV21040 | 1.404054170923387 | Y
n/d | Lectin-galC1 | 9976 | GD38002 | 1.846991270735512 | KK100935 | 1.68085240754608 | Y
Spreadsheet: 824888d1680934697-show-results-based-on-multiple-matching-criteria-results-based-on-multiple-criteria-match
Sheet: Sheet1

 |  |  |  |  |  |  | Car List
Class | Roll | Car | [NAME] |  |  | Class | Car | [NAME] | Role | Role Rank | Column1
A+ | Balance |  |  |  |  | B | NISSAN Skyline GT-R V-spec (1999) | 129 | Balance | 2
 |  |  |  |  |  | A+ | [NAME] 670-4 SV (2009) | 179 | Balance | 2
 |  |  |  |  |  | S+ | Mercedes-Benz 190E 2.5-16 (1988)) | 234 | Balance | 2
 |  |  |  |  |  | B | Porsche 911 Carrera RSR 2.8 (1973) | 131 | Corner | 1
 |  |  |  |  |  | B | Honda NSX-R | 135 | Balance | 1
Expected Results |  |  |  |  |  | A | Porsche 911 Carrera RSR 2.8 (1973) | 140 | Corner | 1
Class | Roll | Car | [NAME] |  |  | B | Mazda MX-5 (1996) | 142 | Top Speed | 1
A+ | Balance |  |  |  |  | A | NISSAN Skyline GT-R V-spec (1999) | 160 | Balance | 1
 |  |  |  |  |  | A+ | Porsche 911 Carrera RSR 2.8 (1973) | 167 | Corner | 1
 |  |  |  |  |  | S | Mercedes-AMG GT Black Series (2020) | 171 | Corner | 1
 |  |  |  |  |  | B | Acura RSX-S (2004) | 172 | Walker | 1
 |  |  |  |  |  | A | Ferrari Testarossa Coupe (1984) | 173 | Walker | 1
 |  |  |  |  |  | A+ | NISSAN Skyline GT-R KPGC10 (1971) | 173 | Balance | 1
 |  |  |  |  |  | A+ | Ferrari Testarossa Coupe (1984) | 193 | Walker | 1
 |  |  |  |  |  | A+ | Lotus Emira | 194 | Top Speed | 1
 |  |  |  |  |  | S | Ferrari F40 (1987) | 195 | Balance | 1
 |  |  |  |  |  | S+ | Lotus Exige S (2006) | 222 | Corner | 1
 |  |  |  |  |  | S | Ferrari Testarossa Coupe (1984) | 224 | Walker | 1
 |  |  |  |  |  | S+ | Porsche 911 Carrera S (1997) | 233 | Balance | 1
 |  |  |  |  |  | S+ | [NAME] (2016) | 245 | Top Speed | 1
Spreadsheet: 219556d1362783167-two-drop-down-lists-to-produce-in-two-other-columns-fruit-and-veggiechallenge
Sheet: Sheet1

Gender | Age | How much Fruits | How much Vegetables | Total consumption |  |  | Gender | Age | FruitsM | [NAME]
Men | 19-30 |  |  |  |  |  | Men | 19-30 | 2 | 3
 |  |  |  |  |  |  | Men | 31-50 | 2 | 3
 |  |  |  |  |  |  | Men | 50+ | 2 | 2.5
 |  |  |  |  |  |  | Women | 19-30 | 2 | 2.5
 |  |  |  |  |  |  | Women | 31-50 | 1.5 | 2.5
 |  |  |  |  |  |  | Women | 50+ | 1.5 | 2
Spreadsheet: dan_hyvl__4693__UGI Utilities Master Firm PurchaseSale 11212000
Sheet: ANEWSWP2

Master Firm Purchase/Sale Agreement
 |  | ATTORNEY:
DATE: | 2000-11-21 00:00:00 | DEAL MAKER:
COUNTERPARTY: | UGI Utilities Inc. | CONTACT: | [NAME]
ADDRESS: | 100 [NAME]., [NAME] 400 | TITLE:
 | Reading, PA 19607 | PHONE: | (610) 796-3505
 |  | FAX:
Incorporation State |  | S&P Rating | A-
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | $10MM
Incorporation State
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings | $6MM | $5MM
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
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
-Below = S&P/Moody's | BBB | BBB-
Financial Covenants
-Funded debt/Worth | > 1.5:1
-Minimum Net Worth
-Cash Flow/CMLTD
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | $10MM
-Guarantor ($[NAME]) |  | $100MM
Change in ownership
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:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: 676561d1588867991-help-w-advanced-formula-search-table-and-return-latest-date-it-shows-up-sample
Sheet: Sheet1

 |  |  |  |  | HELP
 | Type | Latest Date |  |  | I am trying to pull in the most recent date the "Type" appears in the table listed in Sheet2
 | a
 | b
 | c
 | d
 | e
 | f
 | g
 | h
 | i
 | j
 | k
 | l