tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e1496796-78ba-46ee-8250-e22a03bc7d39
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
FIGF2 | Test | FIGF2 | IGF-II | Insulin-Like Growth Factor II | Radioimmunoassay (RIA) after acid-alcohol extraction | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s).  Separate within 1 hour of collection,freeze immediately. Send 0.5 mL serum frozen. Note: 	1. Serum gel tube is okay, but must pour off into a plastic screw  	cap vial and freeze.            	2. Minimum volume does not permit for repeat analysis | 0.1 mL NOTE: Minimum volume does | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icteric	NA | Age		Range (ng/mL)       Mean Prepubertal 	334-642                      488 Pubertal	245-737                      491 Adults		288-736                      512   Test Performed By:   Esoterix Endocrinology                                         4301 Lost Hills Road                                         Calabasas Hills, CA 91301 | Wednesday | 2-8 days | 4-10 days | 1 | 83519 |  |  |  |  | Esoterix Endocrinology
FIGF2 | [NAME] | SERUM | Serum |  |  |  | Frozen | 200 days
FIGF2 | Result | Z2324 | Insulin-Like Growth Factor II | Insulin-Like Growth Factor II | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 2485-1
Spreadsheet: 55602d1255701657-win-loss-draw-formula-game-and-ranking-sheets-09-10-season-copy
Sheet: DIV 1 Ranking  

DIVISION 1 RANKINGS 09 -10
No | Team | Win | Loss | Draw | Shots | Points
1 | [NAME] | 0 | 1 | 0 | -17 | 5
2 | Berri | 0 | 0 | 1 | 0 | 4
3 | Loxton | 0 | 0 | 1 | 0 | 0
3 | Lyrup | 0 | 0 | 1 | 0 | 0
3 | Renmark | 0 | 0 | 1 | 0 | 0
3 | Renmark RSL | 0 | 0 | 1 | 0 | 0
3 | [NAME] | 0 | 0 | 1 | 0 | 0
FINAL RANKINGS
No | Team | Win | Loss | Draw | Shots | Points
1 | [NAME] | 0 | 1 | 0 | -17 | 5
2 | Berri | 0 | 0 | 1 | 0 | 4
3 | Loxton | 0 | 0 | 1 | 0 | 0
4 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
5 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
6 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
7 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 80557d1280785452-matching-values-help-dropdown-beartruck
Sheet: Sheet1

 | Sheet 1
 | [NAME].....blue |  | Select an Additional Bear
 | [NAME].....red |  | Select an Additional Bear
 | [NAME].....pink |  | Select an Additional Bear
 | Toy Truck.......green |  | Select an Additional Truck
 | Toy Truck.......Blue |  | Select an Additional Truck
 | Toy Truck.......Yellow |  | Select an Additional Truck
 | Select an Additional Bear
 | Select an Additional Truck
Spreadsheet: 164907d1340958041-look-values-with-a-twist-look-up-query-v2
Sheet: Result

Account | Amount | Cost Center
5000001 |  | 1405801100
5000001 |  | 1505800650
5000001 |  | 1705800001
5000001 |  | 1705800002
5000001 |  | 1705800012
5000001 |  | 1705800022
5000001 |  | 1805800004
5000001 |  | 1805800005
5000001 |  | 1805800018
5000001 |  | 1805800035
5000001 |  | 1805807100
5000001 |  | 1905800002
5000001 |  | 2305800001
5010001 |  | 1705800001
5010001 |  | 1705800002
5010001 |  | 1705800012
5010001 |  | 2305800001
5010015 |  | 1505800650
5010015 |  | 1805800005
5010015 |  | 1805807100
5010015 |  | 1805800035
5010015 |  | 2305800001
5010015 |  | 1805800004
5010015 |  | 1805800018
5010015 |  | 1905800002
5010015 |  | 1405801100
5010015 |  | 1805800004
5010015 |  | 1805800005
5010015 |  | 1805800035
1379001 |  | X
2203015 |  | X
2206001 |  | X
2200001 |  | X
 | 0
 | To look values from [NAME] and insert above
Spreadsheet: 868917d1715620288-comparing-two-cells-that-contain-comma-delimited-codes-different-order-of-codes-mockup
Sheet: Sheet1

Current record | Code List | Record #
10,4114,4118,4115 | 10,4115,4117,213, | 1
 | 4114,3221,67,2907 | 2
 | 10,140,135,4114 | 3
 | 10,4114,135,67 | 4
 | 10,4117,135,67,25 | 5
 | 4307,4118,140,135,67 | 6
 | 10,4109,4116,135,67 | 7
 | 4115,4117,3221,11 | 8
 | 4114,10,4118,4115 | 9
 | 10,4114,4118,67 | 10
Spreadsheet: 144624d1331062016-how-to-generate-a-list-form-a-master-list-example_v2
Sheet: Before

ID | First Name | Last Name | City | State
1 | [NAME] | Doe | NY | NY
2 | [NAME] | Doe | DC | DC
3 | Uncle | [NAME] | LA | CA
4 | [NAME] | Public | NA | NA
5 | [NAME] | Public | XX | YY
Spreadsheet: 6b51e901-dca8-41bf-bce5-11003f71cc67
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Finance
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2007-08-23 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
08 |  | 8200 |  | 807771 |  | B |  | 80CONV |  | 453920 |  | I
08 |  | 8200 |  | 129620 |  | B |  |  |  | 11650 |  | I
08 |  | 8200 |  | 809611 |  | B |  |  |  | 51730 |  | I
08 |  | 8200 |  | 809600 |  | G |  |  |  | 25000 |  | I
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 542300
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2007-08-23 00:00:00 |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
08 |  | 8200 |  | 807771 |  | 611060 |  | 80CONV |  | 453920 |  | I
08 |  | 8200 |  | 129620 |  | 743050 |  |  |  | 11650 |  | I
08 |  | 8200 |  | 809611 |  | 749840 |  |  |  | 51730 |  | I
08 |  | 8200 |  | 809600 |  | 741100 |  |  |  | 21500 |  | I
08 |  | 8200 |  | 809600 |  | 744010 |  |  |  | 3500 |  | I
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | 542300
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 134534d1325410749-lookup-question-807619_brewers7
Sheet: Data

ID | Selection# | Name | Bdate | [NAME] | Days Old | Age | MP | FG | FGA | FG% | 3P | 3PA | 3P% | FT | FTA | FT% | ORB | DRB | TRB | AST | STL | BLK | TOV | PF | PTS
1 | Starter #1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
1 | Starter #2 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
1 | Starter #3 | Dikembe Mutombo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
1 | Starter #4 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
1 | Starter #5 | LaPhonso Ellis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
1 | Reserve #1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
1 | Reserve #2 | Tyrone Corbin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39
1 | Reserve #3 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
1 | Reserve #4 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
1 | Reserve #5
1 | Reserve #6
1 | Reserve #7
1 | Reserve #8
2 | Starter #1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
2 | Starter #2
2 | Starter #3
2 | Starter #4
2 | Starter #5
2 | Reserve #1
2 | Reserve #2
2 | Reserve #3
2 | Reserve #4
2 | Reserve #5
2 | Reserve #6
2 | Reserve #7
2 | Reserve #8
Spreadsheet: 120899d1315611142-cell-reads-other-cells-from-another-sheet-nfl-football-schedule-2011-2012
Sheet: Teams

Arizona Cardinals
Atlanta Falcons
Baltimore Ravens
Buffalo Bills
Carolina Panthers
Chicago Bears
Cincinnati Bengals
[NAME]
Dallas Cowboys
Denver Broncos
Detroit Lions
Green Bay Packers
Houston Texans
Indianapolis Colts
[NAME]
Kansas City Chiefs
[NAME]
Minnesota Vikings
New England Patriots
New Orleans Saints
New York Giants
New York Jets
Oakland Raiders
Philadelphia Eagles
Pittsburgh Steelers
San Diego Chargers
San Francisco 49ers
[NAME]
St. Louis Rams
Tampa Bay Buccaneers
Tennessee Titans
Washington Redskins
Spreadsheet: 731733d1620549534-multiple-match-data-excel-example
Sheet: Sheet1

Table A |  |  |  |  |  | Table B
ID | AMOUNT |  | Match ID Table A with Table B amounts | Differences |  | ID | AMOUNT
AS303 | 56 |  |  |  |  | AS304 | 35
AS304 | 35 |  |  |  |  | AS303 | 340
AS241 | 95 |  |  |  |  | AS248 | 105
AS303 | 340 |  |  |  |  | AS303 | 56
AS241 | 5 |  |  |  |  | AS241 | 95
 |  |  |  |  |  | AS241 | 5
Spreadsheet: 053c9405-8c6c-4f34-9ae5-a31507a8a4e1
Sheet: September 2013

Spend over £25,000 - Publication template
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2013-09-03 00:00:00 | Group Business Advertising | NMeM Brand | AKA Promotions Limited | 181544 | 26994.07
DCMS | SMG | 2013-09-05 00:00:00 | Build Construction | ScM Major projects | Parkeray Ltd | 181589 | 172517.19
DCMS | SMG | 2013-09-03 00:00:00 | Professional Fees | Science Museum Estates | Department of Energy and Climate Change | 181619 | 144708
DCMS | SMG | 2013-09-12 00:00:00 | Build Construction | National MPG | Elmwood (Glasgow) Ltd | 181740 | 407151.04
DCMS | SMG | 2013-09-12 00:00:00 | Professional Fees | ScM Brand | [NAME] | 181941 | 32990.2
DCMS | SMG | 2013-09-26 00:00:00 | Build Construction | ScM Major projects | Parkeray Ltd | 182189 | 424055.8
DCMS | SMG | 2013-09-26 00:00:00 | Build Construction | ScM Major projects | The Hub Consulting Limited | 182345 | 37135.31
DCMS | SMG | 2013-09-26 00:00:00 | Rates (CILOR) | Science Museum Estates | Royal Borough of Kensington & Chelsea | 182395 | 48707
DCMS | SMG | 2013-09-26 00:00:00 | Build Construction | ScM Major projects | The Hub Consulting Limited | 182453 | 27600
DCMS | SMG | 2013-10-10 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 182498 | 63154.72
DCMS | SMG | 2013-09-26 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 182500 | 57621.42
DCMS | SMG | 2013-09-26 00:00:00 | Security | NMeM Brand | [NAME] | 182557 | 36538
DCMS | SMG | 2013-09-26 00:00:00 | Security | NMeM Brand | [NAME] | 182558 | 38235
DCMS | SMG | 2013-09-26 00:00:00 | Security | NMeM Brand | [NAME] | 182643 | 166425
DCMS | SCMGE | 2013-09-26 00:00:00 | Loco Retail Stock | Visitor Related | Bachmann Industries Europe Ltd | 127536 | 33954.56
DCMS | SCMGE | 2013-09-26 00:00:00 | [NAME] | Visitor Related | [NAME] | 127872 | 26593.47
DCMS | SCMGE | 2013-09-26 00:00:00 | [NAME] | Visitor Related | [NAME] | 127873 | 35218.46
DCMS | SCMGE | 2013-09-26 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 128028 | 82773.15
DCMS | SCMGE | 2013-09-26 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 128029 | 82773.15
DCMS | SCMGE | 2013-09-26 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 128030 | 81423.47
Spreadsheet: 59492d1259976114-macro-to-select-rows-by-cell-content-709671-macro-to-select-rows-by-cell-content
Sheet: Sheet1

Header 1 | [NAME]
Red | 1
Yellow | 2
Green | 3
Cat | 4
Bird | 5
Jazz | Blue
dog | apple
Horse | orange
Jazz | peach
Cow | pear
Goat | [NAME]
[NAME] | Jazz
Sheep | Grape
Jazz | [NAME]
[NAME] | Hawk
S[arrow | Jazz
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: September

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
Period 9 | September | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  | Report Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Entries for BN Numbers
Period 9 | September |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 9 | September |  | Journal Entry      Dated August 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated September 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated August 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated September 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
Spreadsheet: 689190d1596179498-extract-all-values-that-matches-2-criteria-and-sort-sample
Sheet: Sheet2

 |  | Desired
 |  | Alexie Greene
 |  | [NAME]
 |  | [NAME]
 |  | Haniya Mahoney
 |  | [NAME]
 |  | Jackson Bernal
 |  | Jeevan Odling
 |  | Lyla Osborn
 |  | Mahad Haynes
 |  | Maiya Rivera
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: phillip_m_love__30655__9901_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 757990d1638552562-return-different-values-based-on-column-contents-if-with-asterisk-aligw
Sheet: Sheet1

 | [NAME]
 | Heavenly Milk Pistachio | YES | YES | NO
 | Evaporated Milk | NO | NO | NO
 | Condensed Milk | NO | NO | NO
 | Cream | NO | NO | NO
 | [NAME] | NO | NO | NO*
 | [NAME] | YES | YES | NO
Spreadsheet: 854904d1704651122-excluding-vacation-dates-for-calculating-turn-around-time-tat
Sheet: Sheet2

Name | Order Date | Dictation date | Completion Date | TAT excluding weekends) | Vacation dates
A | 2023-12-21 00:00:00 | 2023-12-22 00:00:00 | 2023-12-31 00:00:00
B | 2023-12-14 00:00:00 | 2023-12-17 00:00:00 | 2024-01-02 00:00:00 |  | December 12 to December 22
C | 2023-12-20 00:00:00 | 2023-12-28 00:00:00 | 2024-01-05 00:00:00 |  | December 15 to December 25
D | 2023-11-11 00:00:00 | 2023-12-14 00:00:00 | 2023-12-26 00:00:00 |  | November 15 to December 9
E | 2023-11-15 00:00:00 | 2023-12-10 00:00:00 | 2023-12-14 00:00:00
F | 2023-09-11 00:00:00 | 2023-11-30 00:00:00 | 2023-12-10 00:00:00 |  | September 11 to November 29
G | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-06 00:00:00
H | 2023-10-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-18 00:00:00 |  | November 30 to December 16
I | 2023-11-08 00:00:00 | 2023-12-21 00:00:00 | 2023-12-30 00:00:00 |  | Novemer 21 to December 15 and December 25 to December 27
The database has a running data from January to December. TAT is computed with networkdays.intl - column B is start date and column D is end date
I am able to exclude weekends which are Saturday and Sunday and public holidays for computation of the TAT
How can I exclude vacation dates for each staff (column A) from the TAT to make the data accurate
Column G gives the vacation dates
Spreadsheet: 28562d1222878548-automatic-decimal-format-control-dynamic
Sheet: Sheet1

 | Sample | Test | Data | Date | Tech | Results
 | Petrodiesel1 | CP | -15 | 2008-09-23 00:00:00 | 2 |  |  |  | Distillation | 282C-338C | DI | 2
 | Petrodiesel1 | CP | -15.1 | 2008-09-23 00:00:00 | 4 |  |  |  | [NAME] | 52C Min | FP | 0
 | Petrodiesel1 | CP | -15.3 | 2008-09-23 00:00:00 | 3 |  |  |  | Cu Strip | #3 Max | CS | 2
 | Petrodiesel1 | CP | -15.3 | 2008-09-23 00:00:00 | 1 |  |  |  | Viscosity | 1.9-4.1 mm2/s | KV | 2
 | Petrodiesel1 | FP | 53 | 2008-09-23 00:00:00 | 2 |  |  |  | Ash | .01%W | AS | 2
 | Petrodiesel1 | FP | 58 | 2008-09-23 00:00:00 | 4 |  |  |  | Centane | 40 Min | CE | 2
 | Petrodiesel1 | FP | 57 | 2008-09-23 00:00:00 | 3 |  |  |  | [NAME] |  | CP | 1
 | Petrodiesel1 | FP | 57 | 2008-09-23 00:00:00 | 1 |  |  |  | Centrifuge | .05%V [NAME] | CF | 2
 | Petrodiesel1 | FP | 57 | 2008-09-23 00:00:00 | 3 |  |  |  | Density |  | DE | 2
 | Petrodiesel1 | FP | 58 | 2008-09-23 00:00:00 | 2 |  |  |  | C Residue | .35%W | CR | 2
 | Petrodiesel1 | FP | 58 | 2008-09-23 00:00:00 | 4 |  |  |  | Sulfur | 15ppm [NAME] | SU | 2
 | Petrodiesel2 | FP | 68 | 2008-09-26 00:00:00 | 3 |  |  |  |  |  | V3715 | 2 | 0.0042
 | Petrodiesel2 | FP | 71 | 2008-09-26 00:00:00 | 4 |  |  |  |  |  | V3716 | 2 | 0.004
 | Petrodiesel2 | CP | -7.9 | 2008-09-26 00:00:00 | 1 |  |  |  |  |  | V3720 | 2 | 0.0075
 | Petrodiesel2 | CP | -7.3 | 2008-09-26 00:00:00 | 3 |  |  |  |  |  | V3721 | 2 | 0.0074
 | Petrodiesel2 | FP | 72 | 2008-09-26 00:00:00 | 1
 | Petrodiesel2 | FP | 70 | 2008-09-26 00:00:00 | 2
 | Petrodiesel2 | FP | 71 | 2008-09-26 00:00:00 | 4
 | Petrodiesel2 | FP | 70 | 2008-09-29 00:00:00 | 3
 | Petrodiesel2 | CP | -7 | 2008-09-29 00:00:00 | 3
 | Petrodiesel2 | FP | 66 | 2008-09-29 00:00:00 | 3
 | Petrodiesel2 | FP | 71 | 2008-09-30 00:00:00 | 3
 | Petrodiesel2 | FP | 74 | 2008-09-30 00:00:00 | 3
 | Petrodiesel2 | CP | -7.1 | 2008-09-30 00:00:00 | 3 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Petrodiesel2 | FP | 72 | 2008-09-30 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 1
 | Petrodiesel2 | FP | 74 | 2008-09-30 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  | 2
 | Petrodiesel2 | CP | -7.2 | 2008-09-30 00:00:00 | 4 |  |  | Viscosity tube constants |  |  |  |  |  |  |  |  | 3
 | Petrodiesel2 | V3721 | 423.2 | 2008-10-01 00:00:00 | 3 |  |  | V3715 | 0.0042 |  |  |  |  |  |  |  | 4
 | Petrodiesel2 | V3715 | 712 | 2008-10-01 00:00:00 | 3 |  |  | V3716 | 0.004
 | Petrodiesel2 | V3721 | 426.4 | 2008-10-01 00:00:00 | 4 |  |  | V3720 | 0.0075
 | Petrodiesel2 | V3715 | 715.3 | 2008-10-01 00:00:00 | 4 |  |  | V3721 | 0.0074
 |  |  |  |  |  |  |  | For V3721 and V3721 I need to take the seconds entered into column D and multiply by the associated constant to equal the viscosity in column G
Spreadsheet: 840148-countifs-word-or-another-word-but-not-in-same-cell-countifs-word-or-another-word-but-not-in-same-cell-solution-
Sheet: Sheet1

100 | Good |  |  |  | 100
200 | Bad |  |  |  | 200
300 | [NAME] |  |  |  | 300 |  |  | I want make it count if any of these word exist but not in same cell so code 300 should counted 2 not 4
400 | Good |  |  |  | 400
500 | Good |  |  |  | 500
100 | Good
200 | Bad
300 | [NAME]
400 | Good
500 | Good
Spreadsheet: dc75fae0-e30d-45ec-a9d2-950dc5154b27
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Current Population Survey/Housing Vacancy Survey, Series H-111, Bureau of the Census, Washington DC 20233
 |  | Rate: United States
 |  | Not Seasonally Adjusted Rental Vacancy Rate [Percent]
 |  | Period: 1959 to 2012
 |  | Data Extracted on: November 22, 2014 (12:11 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
1959 | 6.8 | 7.3 | 7.2 | 7
1960 | 8 | 8 | 8.3 | 8.4
1961 | 8.9 | 8.8 | 8.6 | 8.5
1962 | 8.5 | 8.1 | 8 | 8.1
1963 | 8 | 8.2 | 8.3 | 8.3
1964 | 8.1 | 8.1 | 8.4 | 8.3
1965 | 8.5 | 8.2 | 7.8 | 8.5
1966 | 8.3 | 7.4 | 7.4 | 7.7
1967 | 7.3 | 6.9 | 7 | 6.2
1968 | 6.1 | 6.2 | 5.9 | 5.4
1969 | 5.6 | 5.7 | 5.5 | 5.1
1970 | 5.4 | 5.4 | 5.3 | 5.2
1971 | 5.3 | 5.3 | 5.6 | 5.6
1972 | 5.3 | 5.5 | 5.8 | 5.6
1973 | 5.7 | 5.8 | 5.8 | 5.8
1974 | 6.2 | 6.3 | 6.2 | 6
1975 | 6.1 | 6.3 | 6.2 | 5.4
1976 | 5.5 | 5.8 | 5.7 | 5.3
1977 | 5.1 | 5.3 | 5.4 | 5.1
1978 | 5 | 5.1 | 5 | 5
1979 | 5.1 | 5.5 | 5.7 | 5.4
1980 | 5.2 | 5.6 | 5.7 | 5
1981 | 5.2 | 5 | 5 | 5
1982 | 5.3 | 5.1 | 5.3 | 5.5
1983 | 5.7 | 5.5 | 5.8 | 5.5
1984 | 5.6 | 5.5 | 6 | 6.3
1985 | 6.3 | 6.2 | 6.8 | 6.7
1986 | 6.9 | 7.3 | 7.5 | 7.7
1987 | 7.4 | 7.5 | 8.1 | 7.8
1988 | 8 | 7.7 | 7.8 | 7.3
1989 | 7.5 | 7.4 | 7.6 | 7.1
1990 | 7.5 | 7 | 7.2 | 7.2
1991 | 7.5 | 7.3 | 7.6 | 7.3
1992 | 7.4 | 7.7 | 7.3 | 7.1
1993 | 7.8 | 7.6 | 7 | 6.9
1994 | 7.5 | 7.4 | 7.2 | 7.4
1995 | 7.4 | 7.7 | 7.7 | 7.7
1996 | 7.9 | 7.8 | 8 | 7.7
1997 | 7.5 | 7.9 | 7.9 | 7.7
1998 | 7.7 | 8 | 8.2 | 7.8
1999 | 8.2 | 8.1 | 8.2 | 7.9
2000 | 7.9 | 8 | 8.2 | 7.8
2001 | 8.2 | 8.3 | 8.4 | 8.8
2002 | 9.1 | 8.4 | 9 | 9.3
2003 | 9.4 | 9.6 | 9.9 | 10.2
2004 | 10.4 | 10.2 | 10.1 | 10
2005 | 10.1 | 9.8 | 9.9 | 9.6
2006 | 9.5 | 9.6 | 9.9 | 9.8
2007 | 10.1 | 9.5 | 9.8 | 9.6
2008 | 10.1 | 10 | 9.9 | 10.1
2009 | 10.1 | 10.6 | 11.1 | 10.7
2010 | 10.6 | 10.6 | 10.3 | 9.4
2011 | 9.7 | 9.2 | 9.8 | 9.4
2012 | 8.8 | 8.6 | 8.6 | 8.7