tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 178625d1346855850-formatting-text-in-drop-down-menu-format-text-in-drop-down-menu-120904
Sheet: data validation

 | Areas |  |  | physical/health |  | financial/career |  | social/cultural |  | spiritual/ethical |  | family/home |  | mental/educational
 | physical/health |  |  | tennis |  | Laurelplus |  | Music |  | church |  | Kathy |  | memory
 | financial/career |  |  | nutrition |  | investments |  | Politics |  | Prayer |  | house |  | languages
 | social/cultural |  |  | strength |  | opportunities |  | [NAME] |  | other |  | relatives |  | computers
 | spiritual/ethical |  |  | medical |  | TE |  | other |  |  |  | other |  | economics
 | family/home |  |  | other |  | other |  |  |  |  |  |  |  | other
 | mental/educational
 |  |  |  | Term
 |  |  |  | week
 |  |  |  | month
 |  |  |  | 3 months
 |  |  |  | year
 |  |  |  | 5yrs
 |  |  |  | over5yrs
Spreadsheet: 63250d1264168954-sumproduct-multiple-criteria-tax-problems
Sheet: JAN 2010

 |  |  | 1.45% | 6.20% | 0.113 | 0.17 |  | 1.45% | 6.20% | 0.113 | 0.17 |  |  |  | 1.45% | 6.20% | 0.113 | 0.17 | 1.45% | 6.20% | 0.113 | 0.17
 |  | Net |  |  | Net | Net | Total | Remaining to [NAME] |  |  |  |  |  |  |  |  |  |  | Calculation
Pay # | Name | Comp | MCR Tax | FICA Tax | Pension | Pension | W-2 | MCR | FICA | 11.3 Pens | 17 Pens |  |  |  | MCR | FICA | 11.3 Pens | 17 Pens | MCR | FICA | 11.3 Pens | 17 Pens
8 | SMITH | 2122.813026925881 | 22.64125699920947 | 96.8108919966198 | 176.4456579938393 | 265.4492199907318 | 1561.47 | 1000000000 | 6621.6 | 1017 | 41137 |  |  |  | 22.64125699920947 | 96.8108919966198 | 176.4456579938393 | 265.4492199907318 | 22.64125699920947 | 96.81089199661982 | 176.4456579938393 | 265.4492199907318
13 | JONES | 21167.46128 | 225.7654936079441 | 965.3421105994852 | 1759.413846737771 | 2646.905787127621 | 15570.03 | 1000000000 | 6621.6 | 1017 | 41137 |  |  |  | 225.7654936079441 | 965.3421105994852 | 1759.413846737771 | 2646.905787127621 | 234.4016755395107 | -993.2702772884074 | 1017 | 2886.857936301646
Spreadsheet: 889084d1739788849-populating-data-in-one-sheet-example-8
Sheet: Sheet4

ID | Full Name | Department | Annual Salary
Spreadsheet: 796637d1663410723-xlookup-with-multiple-criteria-options-example-workbook
Sheet: Results

Country | Guests | Head of State
Oman
Denmark
Japan
[NAME]
Bahrain
Andorra
Monaco
Bhutan
Netherlands
Spreadsheet: 859670d1707983093-trying-to-pull-data-from-two-sheets-with-formulas-vlookup-array-formula-test-excel-6-aligw
Sheet: PRICING & SALES HISTORY

NO HISTORY ITEMS |  | SALES HISTORY |  |  |  |  |  | RPS DATA TAB
 |  | SIM | SIM Description | [NAME] Months | Sales - 24 Months | Market Cost | Margin | [NAME] | Authorization Name | Contract Start Date | Contract Stop Date | Cost-Side Claim | Market Cost (Includes WTT) | Sell | Loaded Margin
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 154143d1336244175-conditional-formatting-highlight-cells-in-a-column-that-contain-1-or-more-words-excel-forum-example
Sheet: Sheet1

 | CAT TIGER
 | MAN
 | CHICKEN, DONKEY
CAT | DUCK, SNAKE |  |  |  |  |  |  | CAT
BULL | MAN |  |  |  |  |  |  | BULL
MONKEY | SNAKE, MONKEY |  |  |  |  |  |  | MONKEY
 | MONKEY, TIGER
 | MAN
 | DOG, BIRD
 | BIRD, SNAKE
 | TIGER, DONKEY
 | MAN
 | LION, MONKEY
 | BULL, LION
 | DONKEY, TIGER
 | MAN
 | COW, SNAKE
 | PIG, COW
 | MAN
 | OWL, MONKEY
 |  |  |  |  |  |  | NOT(AND(ISERROR(FIND($I$4,D9,1)),ISERROR(FIND($I$5,D9,1)),ISERROR(FIND($I$6,D9,1))))
 |  |  | IF(ISERROR(IF(LEN(B1)>0, FIND(","&LOWER(B1)&",", ",cat,monkey,bull,"),#VALUE!)),"=",B1)
 |  |  |  |  | Conditional formatting: Highlight cells in a column that contain 1 or more of a set of words.
 |  |  |  |  | Below: I want all cells in colum B that contain the words "CAT", "MONKEY", or "BULL" highlighted regardless of other punctuation or words in the cell.
 |  |  |  |  | I found the following formula but it does not work:
 |  |  |  |  | =
 |  |  |  |  | Please see attached spreadsheet.
 |  |  |  |  | A        B
 |  |  |  |  | 1 | CAT TIGER
 |  |  |  |  | 2 | MAN
 |  |  |  |  | 3 | CHICKEN, DONKEY854
 |  |  |  |  | 4 | DUCK" SNAKE
 |  |  |  |  | 5 | MAN
 |  |  |  |  | 6 | SNAKE, MONKEY 2658
 |  |  |  |  | 7 | MONKEY: TIGER
 |  |  |  |  | 8 | MAN(
 |  |  |  |  | 9 | DOG, BIRD 4564
 |  |  |  |  | 10 | BIRD, SNAKE
 |  |  |  |  | 11 | TIGER, DONKEY
 |  |  |  |  | 12 | MAN
 |  |  |  |  | 13 | LION, MONKEY
 |  |  |  |  | 14 | BULL, LION
 |  |  |  |  | 15 | DONKEY, TIGER
 |  |  |  |  | 16 | MAN
 |  |  |  |  | 17 | COW, SNAKE..4
 |  |  |  |  | 18 | PIG, COW
 |  |  |  |  | 19 | MAN
 |  |  |  |  | 20 | OWL, MONKEY
 |  |  |  |  | Thank you,
 |  |  |  |  | [NAME]
Spreadsheet: 772205d1647076538-drag-formula-horizontally-with-vertical-reference-with-skipping-columns-drag-horizontal-with-vertical-reference
Sheet: Sheet1

 | Yes/No |  | First Name | Last Name
 | Yes |  | [NAME] | Smith 1
 | Yes |  | [NAME] | Smith 2
 | Yes |  | [NAME] | Smith 3
 | Yes |  | [NAME] | Smith 4
 | Yes |  | [NAME] | Smith 5
 | Yes |  | [NAME] | Smith 6
 | Yes |  | [NAME] | Smith 7
 | Yes |  | [NAME] | Smith 8
 | Yes |  | [NAME] | Smith 9
 | Yes |  | [NAME] 10 | Smith 10
 | Yes |  | [NAME] | Smith 11
 | Yes |  | [NAME] | Smith 12
 | Yes |  | [NAME] | Smith 13
 | Yes |  | [NAME] | Smith 14
 | Yes |  | [NAME] 15 | Smith 15
 | Yes |  | [NAME] | Smith 16
 | Yes |  | [NAME] | Smith 17
 | Yes |  | [NAME] | Smith 18
 | Yes |  | [NAME] | Smith 19
 | Yes |  | [NAME] 20 | Smith 20
 | Yes |  | [NAME] 21 | Smith 21
 | Yes |  | [NAME] | Smith 22
 | Yes |  | [NAME] 23 | Smith 23
 | Yes |  | [NAME] | Smith 24
 | Yes |  | [NAME] | Smith 25
 | Yes |  | [NAME] 26 | Smith 26
 | Yes |  | [NAME] | Smith 27
 | Yes |  | [NAME] | Smith 28
 | Yes |  | [NAME] 29 | Smith 29
 | Yes |  | [NAME] 30 | Smith 30
 | Yes |  | [NAME] | Smith 31
 | Yes |  | [NAME] 32 | Smith 32
 | Yes |  | [NAME] | Smith 33
 | Yes |  | [NAME] 34 | Smith 34
 | Yes |  | [NAME] | Smith 35
 | Yes |  | [NAME] 36 | Smith 36
 | Yes |  | [NAME] | Smith 37
 | Yes |  | [NAME] 38 | Smith 38
 | Yes |  | [NAME] | Smith 39
 | Yes |  | [NAME] | Smith 40
 | Yes |  | [NAME] | Smith 41
 | Yes |  | [NAME] | Smith 42
 | Yes |  | [NAME] | Smith 43
 | Yes |  | [NAME] | Smith 44
 | Yes |  | [NAME] | Smith 45
 | Yes |  | [NAME] | Smith 46
 | Yes |  | [NAME] | Smith 47
 | Yes |  | [NAME] | Smith 48
 | Yes |  | [NAME] | Smith 49
 | Yes |  | [NAME] 50 | Smith 50
Spreadsheet: 295928d1391866781-shared-house-expenses-who-owes-who-to-equalise-payments-feb-house-expenses
Sheet: Graphs

 | Yearly Summary - 2014
 |  | February | March | April | May | June | July | August | September | October | November | December |  | Total
Electricity |  |  |  |  |  |  |  |  |  |  |  |  | Electricity
Gas |  |  |  |  |  |  |  |  |  |  |  |  | Gas
Water |  |  |  |  |  |  |  |  |  |  |  |  | Water
Internet |  |  |  |  |  |  |  |  |  |  |  |  | Internet
Phone |  |  |  |  |  |  |  |  |  |  |  |  | Phone
House Improvements |  |  |  |  |  |  |  |  |  |  |  |  | House Improvements
Groceries |  |  |  |  |  |  |  |  |  |  |  |  | Groceries
Others |  |  |  |  |  |  |  |  |  |  |  |  | Others
Total |  |  |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 86726d1286692402-find-the-most-effective-manufacturer-per-sold-items-carpickernocheating
Sheet: Sheet1

Manufacturer | Item: |  |  | Family car
Toyota | Motorcycle |  |  | Motorcycle
Toyota | Family car |  |  | Bicycle
Toyota | Motorcycle
Hyundai | Family car
Honda | Family car
Kawasaki | Motorcycle | Table cannot be sorted!
Hyundai | Family car
Honda | Family car |  |  | This problem asks for the [NAME]
Hyundai | Family car |  |  | Of the SECOND match on the Item List.
Raleigh | Bicycle |  |  | No using helping columns or sorting
Reynolds | Bicycle |  |  | (No cheating and retyping the list)
 |  | [NAME] with
 |  | Data Validation |  | [NAME] needed here
First runner-up seller of |  | Motorcycle | is: | Toyota | <<Control+Shift+Enter [NAME]
When Family car is selected the result should be: Hyundai
When [NAME] is selected the result should be: Toyota
When [NAME] is selected the result should NOT  be: Raleigh  BECAUSE IT IS THE FIRST MATCH FROM TWO POSSIBLE EQUAL MATCHES
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Physical Therapy Asst

PHYSICAL THERAPY ASSISTANT REGIONAL PROGRAM
Associate in Applied Science
Student Name:  _________________________________________ | ACT | GPA
Student ID:  ___________________________ | ________ | ________
General Education and Support Courses | Semester | Grade
___ BIO 137 (4) Human Anatomy & Physiology
___ BIO 139 (4) Human Anatomy & Physiology II
___ ENG 101 (3) Writing I
___ MAT 150 (3) College Algebra
___ Oral Communication (3)
___ CIT 105 (3) Intro to Computers OR IC3 Computer Literacy Exam
___ Heritage/Humanities (3)
___ PSY 110 (3) General Psychology
___ PSY 223 (3) Developmental Psychology
[NAME] and Support courses may be taken prior to or in conjunction with PTA courses.
Fall Semester
___ PTA 100 (4) Orientation to Physical Therapy Practice
___ PTA 125 (1) Neuroanatomy for the PTA
___ PTA 200 (5) Modalities & Procedures in Physical Therapy
Spring Semester
___ PTA 150 (6) Functional Anatomy & Physiology
___ PTA 160 (3) Medical & Surgical Conditions in Physical Therapy
___ PTA 170 (1) Clinical Practicum I
Fall Semester
___ PTA 220 (5) Physical Therapy Principles & Procedures
___ PTA 240 (2) Clinical Practicum II
Spring Semester
___ PTA 250 (5) Neurological Rehabilitation in Physicla Therapy
___ PTA 260 (2) Seminar in Physical Therapy
___ PTA 280 (5) Clinical Practicum III
Class admitted in each Fall at the Whitesburg Campus.
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 0cbc9508-dfd8-4f79-abc4-2199bcc45ad5
Sheet: Sheet1

ANON # | RANKING
523496 | 2
523501 | 16
523502 | 24
523503 | 8
523505 | 27
523507 | 10
523509 | 20
523511 | 30
523515 | 19
523517 | 24
523523 | 17
523524 | 7
523525 | 27
523526 | 26
523528 | 5
523543 | 11
523550 | 11
523551 | 20
523554 | 8
523566 | 6
523568 | 23
523611 | 30
523623 | 17
523625 | 30
523626 | 30
526274 | 15
526423 | 14
526425 | 2
526428 | 27
526433 | 20
526482 | 2
526483 | 1
526741 | 11
Spreadsheet: hunter_shively__12709__Daily Prices
Sheet: Sheet1

Summary of Central Deals
All Central Deals: 11/27/2001
Product ID | [NAME] | Weighted Average ($/MMBtu) | High Trade ($/MMBtu) | Low Trade ($/MMBtu) | [NAME] (MMBtu/day)
27760 | Consumers Pwr | 2.492989985693848 | 2.5 | 2.4 | 13980
27764 | [NAME] | 2.45168322171783 | 2.5 | 2.07 | 44498
27812 | ANR | 1.937767202960949 | 2 | 1.9 | 26478
27813 | ANR OK | 2.17424748402158 | 2.4 | 2 | 70251
27817 | NGPL LA Pool | 2.130044037134016 | 2.2925 | 1.9 | 71417
27818 | NGPL Midcont | 2.006728062406591 | 2.325 | 1.785 | 252922
27822 | NGPL TxOkGCPool | 1.906837606837607 | 2.1 | 1.9 | 5850
27824 | NNG Demarc | 2.295357805016223 | 2.46 | 1.945 | 155336
27826 | PEPL Pool | 2.111181219814952 | 2.33 | 1.725 | 287601
29606 | [NAME], TCPL | 2.429798101479304 | 2.5 | 2 | 62259
32775 | Trunkline ELA | 1.974503746306458 | 2.0275 | 1.89 | 28428
32779 | Trunkline WLA | 1.74 | 1.74 | 1.74 | 11341
33427 | Trunkline STX | 2.5 | 2.5 | 2.5 | 6264
35041 | NGPL AmarilloML | 2.189583333333333 | 2.41 | 1.89 | 30000
36733 | Iroquois, TCPL | 2.297988578147308 | 2.55 | 2 | 23814
47095 | NNG Ventura | 2.383239933746106 | 2.48 | 2.215 | 202856
29602 | Dawn | 2.471778846153846 | 2.495 | 2.41 | 104000
Chicago | Chicago City Gates | 2.166569069565762 | 2.56 | 1.865 | 1118510
Chicago City Gates composed of Peoples, NBPL Nicor, NGPL Nicor, and NIPSCO.
Spreadsheet: phillip_m_love__30645__finliq07
Sheet: NB FIN

RPT_ID | I/C | DEAL_NUM_STR | DEL_POINT_CD | COMM_CD | REF_IDX_CD | DEL_IDX_CD | BUY_SELL_CD | CTRPTY_LEGAL_NM | SWP_VOL_AMT | OPT_VOL_AMT | TOT_PL_AMT | DEAL_DT | ENTITY_CD | NATR_CD | PMT_CD | PRC_FIX_AMT | PRC_FLOAT_AMT | PRC_PL_AMT | [NAME] | PRC_BOOK_CD | PRC_ORG_CD | BAS_FIX_AMT | [NAME] | BAS_PL_AMT | BAS_PORT_CD | BAS_BOOK_CD | BAS_ORG_CD | PRM_FIX_AMT | [NAME] | PRM_PORT_CD | [NAME] | PRM_ORG_CD | ANN_FIX_AMT | [NAME] | ANN_PORT_CD | ANN_BOOK_CD | ANN_ORG_CD | CTRCT_PRC_AMT | ORIG_CD | TYPE_CD | CALL_PUT_CD | TRAN_START_DT | TRAN_STOP_DT | [NAME] | STATE_OF_INCORPORATION | CURRENCY_CD | UOM_CD | PRC_UOM_CD | ACCT_ENTITY_CD | BookCode | [NAME] | CODED | CoNum | CTRPTY_CD | RegionCode
13846 | 12STOR | EO5623.1 | N/A | NG | ANNUITY |  | B | Storage Book - Bammel | 620000 | 0 | -34100 | 1998-09-08 00:00:00 | ECT | F | 5BDAP | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0.055 | -34100 | N | B | HPLC | 0 | N/A | ANNUITY | C | 1998-09-01 00:00:00 | 1999-10-31 00:00:00 | B |  | USD | MMBTU | MMBTU | 413? | NB | 1999-07-01 00:00:00 | CounterParty Code Fin | 16 | ST-BAMMEL | HPLC
13846 | 12STOR | EV0049.2 | N/A | NG | ANNUITY |  | B | Storage Book - Bammel | 10000 | 0 | -10000 | 1999-03-16 00:00:00 | ECT | F | 5BDAP | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 1 | -10000 | N | B | HPLC | 0 | N/A | ANNUITY | C | 1999-03-01 00:00:00 | 1999-12-31 00:00:00 | B |  | USD | MMBTU | MMBTU | 413? | NB | 1999-07-01 00:00:00 | CounterParty Code Fin | 16 | ST-BAMMEL | HPLC
13846 | 12STOR | EX1218.2 | N/A | NG | ANNUITY |  | B | Storage Book - Spindletop | 5000 | 0 | -5000 | 1999-05-17 00:00:00 | ECT | F | 5BDAP | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 1 | -5000 | N | B | HPLC | 0 | N/A | ANNUITY | C | 1999-05-01 00:00:00 | 2001-07-31 00:00:00 | B |  | USD | MMBTU | MMBTU | 413? | NB | 1999-07-01 00:00:00 | CounterParty Code Fin | 16 | ST-SPINDLETOP | HPLC
 | 12STOR Total
13846 | 12TP | EY2670.1 | N/A | NG | ANNUITY |  | S | Exxon Company, USA, a Division of Exxon Corporation | -46004 | 0 | 2530.22 | 1999-06-18 00:00:00 | HPL | F | 5BDAP | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 0.055 | 2530.22 | N | B | HPLC | 0 | N/A | ANNUITY | C | 1999-06-01 00:00:00 | 2000-08-31 00:00:00 | X |  | USD | MMPD | MMBTU | 012T | NB | 1999-07-01 00:00:00 |  | 12 | EXXONCOMUSA | HPLC
13846 | 12TP | EP4049.3 | N/A | NG | ANNUITY |  | S | North Central Oil Corporation | -9556 | 0 | 9556 | 1998-09-23 00:00:00 | HPL | F | 5BDAP | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  | 1 | 9556 | N | B | HPLC | 0 | GROS | ANNUITY | C | 1998-10-01 00:00:00 | 1999-09-30 00:00:00 | X | DE | USD | MMBTU | MMBTU | 413? | NB | 1999-07-01 00:00:00 |  | 12 | NCENTRALOIL | HPLC
 | 12TP Total
 | Grand Total
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Mar10-Mar16m 

Main Arena
 | 2013-03-10 00:00:00 |  |  | Thru | 2013-03-16 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-03-10 00:00:00 | 2013-03-11 00:00:00 | 2013-03-12 00:00:00 | 2013-03-13 00:00:00 | 2013-03-14 00:00:00 | 2013-03-15 00:00:00 | 2013-03-16 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 877036d1723720670-unequal-rows-together-in-excel-add
Sheet: Pivot

cod | name | sales
3222 | benz | 18051 |  |  |  |  |  | name | Sum of sales
3222 | benz | 11024 |  |  |  |  |  | benz | 76188
3222 | benz | 13950 |  |  |  |  |  | bmw | 1442137
3222 | benz | 9774 |  |  |  |  |  | [NAME] | 423310
3222 | benz | 499 |  |  |  |  |  | Grand Total | 1941635
3222 | benz | 2870
3222 | benz | 2785
3222 | benz | 5869
3222 | benz | 3833
3222 | benz | 5529
3222 | benz | 2004
64425 | bmw | 524185
64425 | bmw | 238597
64425 | bmw | 195618
64425 | bmw | 66463
64425 | bmw | 50211
64425 | bmw | 122789
64425 | bmw | 86433
64425 | bmw | 31304
64425 | bmw | 17396
64425 | bmw | 51245
64425 | bmw | 46980
64425 | bmw | 1265
64425 | bmw | 9651
1923 | [NAME] | 225589
1923 | [NAME] | 38938
1923 | [NAME] | 137206
1923 | [NAME] | 11979
1923 | [NAME] | 4685
1923 | [NAME] | 4119
1923 | [NAME] | 794
Spreadsheet: 826264d1681904519-formula-for-an-action-monitoring-spreadsheet-ifs-problem-for-excel-forum
Sheet: Sheet1

Question A | My first problem is how to automatically fill the 'action due date' with one formula from the 'date of inspection' and 'category of action' where Low=3months, Medium=2 weeks and High=same day.
Date of inspection | Category | Date action due
2022-01-21 00:00:00 | Low
2022-01-21 00:00:00 | Medium
2022-01-21 00:00:00 | High
 |  |  | To be blank
Question B | My second problem is that I'd like a single formula to write 'complete', 'overdue', or 'in date' in the final column. Some of the actions were due in the past, some are due in the future and some are complete.
Action due date | Date action completed | Compliance as of today
2022-01-21 00:00:00 | 2022-01-19 00:00:00
2022-01-21 00:00:00 | 2023-01-23 00:00:00
2023-03-30 00:00:00 | 2023-03-30 00:00:00
2022-01-21 00:00:00
2023-04-30 00:00:00
Spreadsheet: 13966ea9-c8c2-43ef-8227-3edbfbc4c34f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Determining CACFP Sponsor’s Monitoring Staff Ratio
Record each staff person’s name whose job description contains monitoring functions. The job description must identify the duties and specific % of time spent on monitoring functions.  (Note: staff time for the annual update of enrollment forms may also be included in the calculation of monitoring functions.)  Record their job title and their FTE (full time equivalent) as a number (1.0 FTE = 40 hrs/week; 0.50 FTE = 20 hrs/week).  Record the % of their job spent on monitoring functions (record in decimal format: if 50%, record as 0.50).
Staff name | Job title | Centers or sites Monitored | Number of sites assigned | FTE | Monitoring function percentage enter decimal amount (.50=50%) | Monitoring FTE
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
 |  |  |  |  |  | 0
Totals |  |  | 0 |  |  | 0
Highest number of claiming sites during current federal fiscal year
 |  |  |  |  | FTE per Monitoring Sites
The USDA Federal required staffing standards are 1 FTE monitoring staff person for each 25 -150 centers. 7 CFR 226.16(b)(1).
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 70

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
Well #70 | 2013-10-11 00:00:00 | 7.7 | 0.42 | 2.17 | 0.87 | 1.2 | 3.5 |  |  | 0.2 | 0.7 |  | 0.9 | 1.8 | 0.03 | 1 |  | <0.10 | <0.02 |  | 0.3
Well - 70 | 2014-01-27 00:00:00 | 7.9 | 0.37 | 2.03 | 0.82 | 1.3 | 3.2 |  |  | 0.1 | 0.6 |  | 1.1 | 2 | <0.01 | 0.8 |  | <0.10 | <0.02 |  | 0.7
Well 70 | 2016-04-01 00:00:00 | 7.74 | 0.84 | 3.83 | 1.38 | 1.55 | 2.819518823435377 | 2.819518823435377 | 0 | 4.92 | 12.727 | 537.6 | 0.96 | 1.81 | 0.019 | 4.9069 | 0.216 | 0.216 | 0.149 | 0.02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments: Cl and SO4 are way high
Spreadsheet: 849909d1700268856-how-to-vlookup-into-a-dataset-when-value-being-searched-has-multiple-values-that-you-need-vlookup-eba
Sheet: Sheet1

Code | Value 1 | Value 2
123 | A | 1 |  |  |  | F | 1 | 6
124 | B | 2 |  | 124 |  | G | 2 | 7
125 | C | 3 |  | 125 |  | 3
126 | D | 4 |  | 126 |  | 4
127 | E | 5 |  | 127 |  | 5
123 | F | 6
124 | G | 7
Spreadsheet: bfa94d5c-b751-4a8c-adf6-cee2bf1e52f3
Sheet: Sheet1

参考表 １　　主 要 国 の 消 費 者 物 価 指 数 変 化 率 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Reference Table 1 　 Rates of Change in Consumer Price Index of Principal Countries
 |  |  |  |  |  |  | 前年(同月)比 (％)
 |  |  |  |  |  |  | Change over the year in ％
 | 日　本 | アメリカ | イギリス | ド イ ツ | フランス | イタリア※ | カ ナ ダ | 韓 　国 | Year
年　月 |  |  |  |  |  |  |  |  | and
 | Japan | United 　 States | United 　 Kingdom | Fed. Rep. 　of Germany | France | Italy | Canada | Rep. of 　 Korea | month
平成11年平均 | -0.3 | 2.2 | 1.5 | 0.6 | 0.5 | 1.7 | 1.7 | 0.8 | 1999
12 | -0.7 | 3.4 | 3 | 1.4 | 1.7 | 2.5 | 2.7 | 2.3 | 2000
13 | -0.7 | 2.8 | 1.8 | 2 | 1.7 | 2.8 | 2.6 | 4.1 | 2001
14 | -0.9 | 1.6 | 1.7 | 1.4 | 1.9 | 2.5 | 2.2 | 2.7 | 2002
15 | -0.3 | 2.3 | 2.9 | 1.1 | 2.1 | 2.6 | 2.8 | 3.6 | 2003
16 | 0 | 2.7 | 3 | 1.6 | 2.1 | 2.1 | 1.9 | 3.6 | 2004
17 | -0.3 | 3.4 | 2.8 | 2 | 1.7 | 1.8 | 2.2 | 2.7 | 2005
平成16年 7月 | -0.1 | 3 | 3 | 1.8 | 2.3 | 2.2 | 2.3 | 4.4 | July 2004
8 | -0.2 | 2.7 | 3.2 | 2 | 2.4 | 2.2 | 1.9 | 4.8 | Aug.
9 | 0 | 2.5 | 3.1 | 1.8 | 2.1 | 2 | 1.8 | 3.9 | Sep.
10 | 0.5 | 3.2 | 3.3 | 2 | 2.1 | 2 | 2.3 | 3.8 | Oct.
11 | 0.8 | 3.5 | 3.4 | 1.8 | 2 | 1.8 | 2.4 | 3.3 | Nov.
12 | 0.2 | 3.3 | 3.5 | 2.1 | 2.1 | 1.8 | 2.1 | 3 | Dec.
平成17年 1月 | -0.1 | 3 | 3.2 | 1.6 | 1.6 | 1.6 | 2 | 3.1 | Jan. 2005
2 | -0.3 | 3 | 3.2 | 1.8 | 1.6 | 1.6 | 2.1 | 3.3 | Feb.
3 | -0.2 | 3.1 | 3.2 | 1.8 | 1.9 | 1.9 | 2.3 | 3.1 | Mar.
4 | 0 | 3.5 | 3.2 | 1.6 | 1.8 | 1.9 | 2.4 | 3.1 | Apr.
5 | 0.2 | 2.8 | 2.9 | 1.7 | 1.5 | 1.8 | 1.6 | 3.1 | May
6 | -0.5 | 2.5 | 2.9 | 1.8 | 1.7 | 1.7 | 1.7 | 2.7 | June
7 | -0.3 | 3.2 | 2.9 | 2 | 1.7 | 1.9 | 2 | 2.5 | July
8 | -0.3 | 3.6 | 2.8 | 1.9 | 1.8 | 1.8 | 2.6 | 2 | Aug.
9 | -0.3 | 4.7 | 2.7 | 2.5 | 2.2 | 1.8 | 3.4 | 2.7 | Sep.
10 | -0.7 | 4.3 | 2.5 | 2.3 | 1.8 | 2 | 2.6 | 2.5 | Oct.
11 | -0.8 | 3.5 | 2.4 | 2.3 | 1.6 | 2 | 2 | 2.4 | Nov.
12 | -0.1 | 3.4 | 2.2 | 2.1 | 1.5 | 2 | 2.2 | 2.6 | Dec.
平成18年 1月 | 0.5 | 4 | 2.4 | 2.1 | 2 | 2.2 | 2.8 | 2.8 | Jan. 2006
2 | 0.4 | 3.6 | 2.4 | 2.1 | 1.9 | 2.1 | 2.2 | 2.3 | Feb.
3 | 0.3 | 3.4 | 2.4 | 1.8 | 1.5 | 2 | 2.2 | 2 | Mar.
4 | 0.4 | 3.5 | 2.6 | 2 | 1.7 | 2.1 | 2.4 | 2 | Apr.
5 | 0.6 | 4.2 | 3 | 1.9 | 2.1 | 2.1 | 2.8 | 2.4 | May
6 | 1 | 4.3 | 3.3 | 2 | 1.9 | 2.1 | 2.5 | 2.6 | June
※　たばこを除く総合
Excluding Tobacco
Spreadsheet: 158843d1338406173-basic-countif-function-weeknum
Sheet: Sheet2

 | name | status
 | mason | sent
 | mason | sent
 | mason | sent
 | danielle | sent
 | danielle | risk
 | danielle | live
 | danielle | sent
 | danielle | risk
 | danielle | live
 | danielle | sent
 | danielle | risk
 | danielle | live
 | fred | qualified
 | fred | qualified
 | fred | qualified
Spreadsheet: 198786d1354895289-copying-a-vertical-list-to-a-horizontal-not-transposing-example
Sheet: Sheet1

MATERIAL__MAT_ID | AUDIO POLISH ENGLISH MIX | AUDIO POLISH | AUDIO RUSSIAN | AUDIO HUNGARIAN
516284 | Audio Polish English Mix | Audio Polish
516666 |  |  | Audio Russian
516667 |  |  | Audio Russian
516668 | Audio Polish English Mix | Audio Polish
516669 | Audio Polish English Mix | Audio Polish
517286 |  |  | Audio Czech | Audio Hungarian
517306 | Audio Polish English Mix | Audio Polish
517307 | Audio Polish English Mix | Audio Polish
517311 | Audio Polish English Mix | Audio Polish
517482 |  |  |  | Audio Hungarian
519145 |  |  | Audio Russian
519167 |  |  | Audio Russian