tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94823d1294587016-how-to-select-multiple-name-box-test
Sheet: APR

 | 2009-04-01 00:00:00
 | Monthly Income |  |  |  |  | Expenses
 | Funds from Previous month: | 129.46 |  |  |  | Total Monthly Expense | 0
 | New Funds Added: | 0
 | Summary
 | Surplus This Month: | 129.46 | (Expense Limit)
Breakdown
 | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income
1st |  |  |  |  | 6th |  |  |  |  | 11th |  |  |  |  | 16th |  |  |  |  | 21st |  |  |  |  | 26th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
2nd |  |  |  |  | 7th |  |  |  |  | 12th |  |  |  |  | 17th |  |  |  |  | 22nd |  |  |  |  | 27th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
3rd |  |  |  |  | 8th |  |  |  |  | 13th |  |  |  |  | 18th |  |  |  |  | 23rd |  |  |  |  | 28th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
4th |  |  |  |  | 9th |  |  |  |  | 14th |  |  |  |  | 19th |  |  |  |  | 24th |  |  |  |  | 29th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
5th |  |  |  |  | 10th |  |  |  |  | 15th |  |  |  |  | 20th |  |  |  |  | 25th |  |  |  |  | 30th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Month | Days
 |  |  |  |  |  |  |  |  |  |  |  | Jan | 31
 |  |  |  |  |  |  |  |  |  |  |  | Feb | 28
 |  |  |  |  |  |  |  |  |  |  |  | Mar | 31
 |  |  |  |  |  |  |  |  |  |  |  | Apr | 30
 |  |  |  |  |  |  |  |  |  |  |  | May | 31
 |  |  |  |  |  |  |  |  |  |  |  | Jun | 30
 |  |  |  |  |  |  |  |  |  |  |  | Jul | 30
 |  |  |  |  |  |  |  |  |  |  |  | Aug | 31
 |  |  |  |  |  |  |  |  |  |  |  | Sep | 30
 |  |  |  |  |  |  |  |  |  |  |  | Oct | 31
 |  |  |  |  |  |  |  |  |  |  |  | Nov | 30
 |  |  |  |  |  |  |  |  |  |  |  | Dec | 31
Spreadsheet: 538986d1505916887-formula-sum-a-b-copy-formula-to-sum-d-e-skip-c-automatic-formula-excelforum_myfirstcase
Sheet: Dashboard-Sheet2

 | 2017-01-01 00:00:00 |  | 2017-02-01 00:00:00 |  | 2017-03-01 00:00:00 |  | 2017-04-01 00:00:00 |  | 2017-05-01 00:00:00 |  | 2017-06-01 00:00:00
 | B2B (Together) | B2C | B2B (Together) | B2C | B2B (Together) | B2C | B2B (Together) | B2C | B2B (Together) | B2C | B2B (Together) | B2C
Product Sales
Orders
Ordervalue
Spreadsheet: mary_fischer__25615__32L
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032L |  | (Please print)  PREPARED BY: | Sonya City
COMPANY NAME   Jovinole Associates
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | COMPLETED
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | COMPLETED
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 |  | Equity/Invmt Sub | COMPLETED
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 881236d1729193919-using-isnumber-with-and-or-multiple-conditions-catsonheat-book2
Sheet: Sheet1

Main Data | Data Check 1 | Data Check 2 | Data Check 3 | Data Check 4 |  | Cats | Dogs | Mice | Pigs | Sheep
Cats Dogs Mice Sheep | Cats Dogs | Cats Dogs | Pigs Cats | Mice Sheep Pigs
Pigs Cats | Pigs Cats | Mice Sheep Pigs | Cats Dogs | Cats Sheep Dogs
Mice Sheep Pigs Cats | Mice Sheep Pigs | Cats Sheep Dogs | Cats Sheep Dogs | Cats Dogs
Dogs Pigs | Cats Sheep Dogs | Pigs Cats | Pigs Cats | Mice Sheep Pigs
Mice Cats Sheep | Pigs Dogs | Cats Dogs | Mice Sheep Pigs | Mice Sheep
Sheep Dogs Cats Mice | Mice Sheep | Mice Sheep | Pigs | Dogs
Spreadsheet: 4d077891-a594-4a62-96bc-f445287164b6
Sheet: page1

PERSONAL FINANCIAL STATEMENT
[NAME] |  |  |  |  |  |  |  | Home Phone
Street Address |  |  |  |  |  |  |  | Business Phone
City, State, Zip |  |  |  |  |  |  |  | Date of Birth
Applicant is applying: |  |  |  | Individually, without a co-signer or guaranty of a relative or other person(s) or entity.
 |  |  |  | Jointly, with the co-signature or guaranty of one or more persons or entities (including existing guarantors).
 |  | NOTE: | (if jointly, BOTH INITIAL HERE)
 |  |  |  |  |  | Applicant's Initials
Financial Condition as of (Date):
ASSETS |  |  |  |  |  | LIABILITIES
Cash |  | Section 1
Stocks & Bonds |  | Section 2
Closely Held Business |  | Section 2a |  |  |  | Notes Payable |  | Section 8
Tax |  | Section 3 |  |  |  | Taxes Owed |  | Section 3
Insurance (Cash Value) |  | Section 4 |  |  |  | Insurance Loan |  | Section 4
Notes Receivable |  | Section 5 |  |  |  | Accounts Payable |  | Section 9
Real Estate |  | Section 6 |  |  |  | Real Estate Payable |  | Section 6
Other Assets |  | Section 7 |  |  |  | Other Liabilities |  | Section 10
 |  | TOTAL ASSETS |  |  |  |  | TOTAL LIABILITIES
 |  |  |  |  |  |  | NET WORTH
INCOME AND EXPENSES
Alimony, child support or separate maintenance payment income need not be revealed if you do not wish to have it considered as a basis for repaying this obligation.
Year |  |  |  | Year |  |  |  | Contigent Liabilities
[NAME] or Wages |  |  |  | Property Tax & Assessment |  |  |  | Endorser on Notes/Contracts
Dividends or Interest |  |  |  | Fed & State Income Tax |  |  |  | Legal Claims & Judgements
Rentals (Gross Income) |  |  |  | Real Estate Loan Payments |  |  |  | Provision For Taxes
Business (Net Income) |  |  |  | Payments on Contract/Notes |  |  |  | Other Special Debt (Describe)
Other Income (Describe) |  |  |  | Estimated Living Expenses
 |  |  |  | Other:
TOTAL INCOME |  |  |  | TOTAL EXPENSES |  |  | TOTAL
Section 1 |  |  | CASH
Account Type | Bank |  |  | Balance | Pledged for a loan?
 |  | Total
Section 2 |  |  | STOCKS AND BONDS
 |  |  |  | Registered in |  |  |  | Purchased on | Total
Description |  | No. Shares |  | Name of | Price per share |  |  | Margin/Pledged | Value
 | Applicant applying for this loan
 | Individually, without a co-signer or guaranty of a relative or other person (s) or entity.
 | Jointly, with the co-signature or guaranty of one or more persons or entities (including existing guarantors).
 | Account Type
 | Checking
 | Savings
 | Certificate of Deposit
 | Bank
 | Premier Community Bank
 | Bank of America
 | Key Bank
 | Washington Mutual
 | Wells Fargo
 | Pledged for a Loan
 | No
 | Yes
 | Year
 | 2003
 | 2004
 | 2005
 | Marrital Status
 | Married
 | Separated
 | Unmarried (single, divorced, widowed)
 | Financial Condition as of
 | Registered in Name Of
Spreadsheet: 7337a579-235d-4e15-b4b7-f821e452eed7
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
36245134 | 2013-06-04 03:32:19 | AXIS | 1 | 4 | 2 | 1327315 | rorylarne | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
36245267 | 2013-06-04 03:53:17 | ALLIES | 1 | 4 | 3 | 1327315 | rorylarne | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
Spreadsheet: 250420d1373922064-excel-live-canlader-conditional-formating-with-multiple-cells-in-column-calander
Sheet: Formulas and data

 | YEAR | MONTH
 | 1990 | JANUARY
 | 1991 | FEBRUARY
 | 1992 | [NAME]
 | 1993 | APRIL
 | 1994 | MAY
 | 1995 | [NAME]
 | 1996 | JULY
 | 1997 | AUGUST
 | 1998 | SEPTEMBER
 | 1999 | OCTOBER
 | 2000 | NOVEMBER
 | 2001 | DECEMBER
 | 2002
 | 2003
 | 2004
 | 2005
 | 2006
 | 2007
 | 2008
 | 2009
 | 2010
 | 2011
 | 2012
 | 2013
 | 2014
 | 2015
 | 2016
 | 2017
 | 2018
 | 2019
 | 2020
Spreadsheet: 2a013ae7-e4a6-4b93-acc9-38b4fb5ec737
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
FFOVE | Test | FFOVE | Fusarium oxysporum/vasinfectum IgE | Fusarium oxysporum/vasinfectum IgE | Radioimmunoassay (RIA) |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Cold OK; Warm OK Lipemia:	Mild OK; Gross reject Icterus:	NA Other:	NA | <[NAME]/L  Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 |  | 2 - 3 days | 4 - 7 days | 1 | 86003 |  |  |  |  | Viracor-IBT Laboratories
FFOVE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FFOVE | Result | Z3090 | Fusarium oxysporum/vasinfectum IgE | Fusarium oxysporum/vasinfectum IgE | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FFOVE | Result | Z3091 | Class | Class | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 804493d1668101293-index-match-using-multiple-criteria-index-match-query
Sheet: Sheet1

 |  | Agent Name | 2022-10-24 00:00:00 | 2022-10-31 00:00:00 | 2022-11-07 00:00:00 |  | Agent Name | Person 4
 |  | Person 1 | 488 | 346 | 488 |  | Week Commencing | 2022-10-24 00:00:00
 |  | Person 2 | 121 | 101 | 121
 |  | Person 3 | 138 | 84 | 138 |  | Sales Volume
 |  | Person 4 | 155 | 107 | 155
 |  | Person 5 | 174 | 195 | 174
 |  | Person 6 | 60 | 54 | 60
 |  | Person 7 | 426 | 185 | 426
 |  | Person 8 | 174 | 134 | 174
 |  | Person 9 | 112 | 65 | 112
 |  | Person 10 | 116 | 84 | 116
 |  | Person 11 | 64 | 79 | 64
 |  | Person 12 | 58 | 33 | 58
 |  | Person 13 | 92 | 148 | 92
Spreadsheet: 810387d1671728672-alphanumeric-sorting-on-table-order
Sheet: Prenotazioni

 |  |  |  |  | 2023
H | Cod | Cliente | Dal | Al | Periodo | Base | Costi Extra | sconto Extra | Acconto
 | 1A | [NAME] | 2023-07-15 00:00:00 | 2023-08-15 00:00:00
 | 1A | Caputo | 2023-07-15 00:00:00 | 2023-08-15 00:00:00
 | 2A | Veronica
 | 3A | YYY | 2023-06-04 00:00:00 | 2023-06-12 00:00:00
 | 3A | AABBB | 2023-06-07 00:00:00 | 2023-06-10 00:00:00
 | 3A | [NAME] | 2023-07-01 00:00:00 | 2023-08-31 00:00:00
 | 4A | AAAAA | 2023-06-01 00:00:00 | 2023-09-30 00:00:00
 | 4A | CCCC | 2023-08-10 00:00:00 | 2023-08-20 00:00:00
 | 4B | [NAME] | 2023-06-01 00:00:00 | 2023-09-30 00:00:00
 | 5A | Leone | 2023-06-01 00:00:00 | 2023-09-30 00:00:00
 | 6A | Paola | 2023-06-01 00:00:00 | 2023-09-30 00:00:00
 | 9D | [NAME]
 | 9E | BBBB | 2023-07-05 00:00:00 | 2023-07-12 00:00:00
 | 12F | [NAME]
 | 14A | Seminara | 2023-06-01 00:00:00 | 2023-09-30 00:00:00
 | 15G | [NAME]
 | 16G | Martucci | 2023-06-01 00:00:00 | 2023-09-30 00:00:00
 | 23I | [NAME]
 | 24A | AAA | 2023-06-01 00:00:00 | 2023-06-05 00:00:00
Spreadsheet: 219091d1362667073-if-then-statement-that-assigns-another-cell-value-book2
Sheet: Sheet1

Gross Margin Score
Min | [NAME] | Score
2000000 | 9000000 | 75
1500000 | 1999999 | 65
1000000 | 1499999 | 55
750000 | 999999 | 45
500000 | 749999 | 35
250000 | 499999 | 25
100000 | 249999 | 15
0 | 99999 | 5
Spreadsheet: 833921d1687345559-count-data-in-different-columns-hazards-raised-by
Sheet: Sheet1

Shift | Name | [NAME] |  |  | [NAME] | People Raising
B | [NAME] |  |  | A |  | 2
B | [NAME] | 8 |  | B |  | 3
Eng | [NAME] |  |  | C |  | 1
A | [NAME] | 1 |  | Eng |  | 2
Eng | Pav | 6 |  | WE |  | 1
Eng | [NAME]
B | [NAME] | 3
A | [NAME] | 2 |  |  | =SUMIF(A2:A16,E2,C2:C16) | ???
A | [NAME] |  |  |  |  | This is a manual input, can a formual do it for me?
WE | [NAME] | 1
Eng | [NAME] | 3
A | [NAME]
B | [NAME] | 5
C | [NAME] | 4
C | Jake
Spreadsheet: 1cd0ca45-d9ad-4804-9280-a575fc4db94c
Sheet: Sheet1

Unit/Standard Number | High School Graduation Years 2011, 2012 and 2013  Biotechnology CIP 26.1201 Task Grid | Proficiency Level Achieved: (X) Indicates Competency Achieved to Industry Proficiency Level
 | Secondary Competency Task List
100 | DEMONSTRATE GOOD WORK HABITS
101 | Demonstrate professional work habits.
102 | Demonstrate the ability to organize, implement, and trouble-shoot specific tasks.
103 | Demonstrate the ability to work in teams and as an individual.
200 | DEMONSTRATE KNOWLEDGE OF BIOTECHNOLOGY
201 | Define biotechnology and its role.
202 | Demonstrate knowledge of the history of the biotechnology.
203 | Describe the lifecycle of biotechnology product development.
204 | Identify the application of the biotechnology industry.
205 | Describe careers in biotechnology.
300 | DEMONSTRATE LABORATORY KNOWLEDGE AND SKILLS
301 | Demonstrate competency in validating and using laboratory equipment.
302 | Demonstrate competency in using computer office applications.
303 | Perform basic laboratory math skills.
304 | Apply statistical analysis to interpret data.
305 | Demonstrate the ability to use the scientific method.
306 | Properly prepare buffers and solutions.
307 | Demonstrate the concepts of recombinant technology.
308 | Demonstrate the principles of DNA isolation.
309 | Perform Polymerase Chain Reaction (PCR).
310 | Perform electrophoresis.
311 | Perform separation techniques.
312 | Explain and perform aseptic technique.
313 | Demonstrate the concepts of Microbial culture
314 | Demonstrate the concept of Mammalian cell culture
315 | Demonstrate the concept of Laboratory automation
316 | Perform basic spectrophotometer assays
400 | ETHICS
401 | Demonstrate the knowledge of bioethics.
402 | Demonstrate the knowledge of professional ethics.
500 | DEMONSTRATE SAFETY IN THE BIOTECHNOLOGY LABORATORY
501 | Demonstrate general requirements for laboratory safety.
502 | Identify and use personal protective equipment.
503 | Demonstrate ability to implement safety protocols.
504 | Follow MSDS guidelines for handling, storage, and disposal of hazardous material.
505 | Demonstrate knowledge of safety regulatory agencies, such as OSHA.
600 | DEMONSTRATE THE ABILITY TO WORK IN A HIGHLY REGULATED ENVIRONMENT
601 | Perform documentation according to regulatory agency standards.
602 | Demonstrate an ability to maintain records in accordance with Intellectual Property laws.
603 | Document lab activities and findings according to guidelines.
700 | DEMONSTRATE USE OF APPROPRIATE EQUIPMENT AND INSTRUMENTATION
701 | Use laboratory glassware.
702 | Use volumetric equipment.
703 | Use electrophoresis equipment.
704 | Use spectrophotometer.
705 | Use balances.
706 | Demonstrate knowledge of autoclaves.
707 | Use centrifuges.
708 | Use pH meters.
709 | Demonstrate knowledge of thermocyclers.
710 | Use microscopes.
711 | Demonstrate knowledge of laminar flow hoods.
712 | Demonstrate knowledge of temperature regulating devices (water baths, incubators).
713 | Demonstrate knowledge of chromatographic equipment.
Spreadsheet: 863074d1710624076-dax-test-if-a-consecutive-series-of-cells-fulfill-a-certain-condition-week-violation-logic-3
Sheet: PowerPivot Logic

 | Week
Values | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Stock Days | 36 | 12 | 39 | 46 | 41 | 11 | 57 | 60 | 45 | 54 | 56 | 40 | 18 | 46 | 30 | 45 | 54 | 57 | 39 | 40
[NAME] | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
1 for every single week violation | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1
currWeek | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
LB | 1 | 2 | 2 | 2 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 13 | 13 | 15 | 15 | 15 | 15 | 15 | 15
lastBelow | 1 | 2 | 2 | 2 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 13 | 13 | 15 | 15 | 15 | 15 | 15 | 15
NB | 1 | 2 | 6 | 6 | 6 | 6 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 15 | 15
nextBelow | 1 | 2 | 6 | 6 | 6 | 6 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 15 | 15 | 20 | 20 | 20 | 20 | 20
Series in Violation | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Why is it not capturing the last group of 5 weeks in violation??
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Criteria
Quick Excel Based Logic Test |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > | 4
Spreadsheet: 680424d1591015080-creating-lists-based-on-if-required-column-number-is-above-0-sample
Sheet: Sheet1

Product: |  |  | Product Code: | Current Stock: |  | Required Level: |  | To Be Ordered:
4 x 30 |  |  | 01866430 | 2 |  | 2
4 x 40 |  |  | 01866440 | 1 |  | 2
5 x 30 |  |  | 01866530 | 1 |  | 2
5 x 40 |  |  | 01866540 | 1 |  | 2
5 x 50 |  |  | 01866550 | 1 |  | 2
5 x 60 |  |  | 01866560 | 0 |  | 2
5 x 70 |  |  | 01866570 | 0 |  | 2
5 x 80 |  |  | 01866580 | 1 |  | 2
5 x 90 |  |  | 01866590 | 1 |  | 2
5 x 100 |  |  | 018665100 | 1 |  | 2
4.8 x 50 |  |  | 0218550 | 2 |  | 2
4.8 x 60 |  |  | 0218560 | 1 |  | 2
4.8 x 70 |  |  | 0218570 | 3 |  | 2
Spreadsheet: 685808d1594208382-partial-vlookup-if-a-text-is-found-2020-07-08-oeldere-bart90-685662d1594133506-partial-vlookup-if-a-text-is-found-zeszyt-1-1-
Sheet: Arkusz1

 |  |  | Yellow | Green
Column1 |  |  | Pineapple | Apple
1111*Apple*1111 | If one of cells from D3:D4 is found, then return the value from  Column3, ex Apple from Column2 is found, return Green
-Apple- | If one of cells from D3:D4 is found, then return the value from  Column3, ex Apple from Column2 is found, return Green
---Pineapple--- | If one of cells from D3:D4 is found, then return the value from  Column3, ex Pineapple from Column2 is found, return Yellow
*Pineapple* | If one of cells from D3:D4 is found, then return the value from  Column3, ex Pineapple from Column2 is found, return Yellow
----Banana---- | If one of cells from D3:D4 is found, then return the value from  Column3, ex no cell from Column2 is found, return error
aapple
Spreadsheet: 848186d1698957693-return-data-date-from-one-column-based-on-a-numeric-value-in-another-column-sample-2-
Sheet: Sheet1

Column1 | GRANT | ANDREW | EMP |  | EMP | DATE |  | Attribute | Column1
2024-04-15 00:00:00 | 8 |  |  |  | GRANT |  |  | GRANT | 2024-04-15 00:00:00
2024-04-16 00:00:00 |  |  |  |  | ANDREW |  |  | ANDREW | 2024-04-18 00:00:00
2024-04-17 00:00:00 |  |  |  |  | EMP
2024-04-18 00:00:00 |  | 8
2024-04-19 00:00:00
If there is a number, greater than 0, in a column here, I would like the date to go here for the corresponding person
Spreadsheet: 328049d1403777060-survey-results-table-lookup-errors-scoring-tool-extended
Sheet: AQSCI

Category | Answer | [NAME] | Percentage
Assurance of Supply | 5 | 5
Assurance of Supply | 2 | 5
Assurance of Supply | 4 | 5
Assurance of Supply | 3 | 5
Assurance of Supply | 2 | 5
Assurance of Supply | 2 | 5 |  |  |  |  |  |  |  | This sheet was version 1
Assurance of Supply | 5 | 5
Assurance of Supply | 4 | 5
Assurance of Supply | 4 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 3 | 5
Assurance of Supply | 3 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 5 | 5
Assurance of Supply | 5 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 1 | 5
Assurance of Supply | 5 | 5 |  |  |  |  | Baseline | Score
Assurance of Supply | 5 | 5 |  |  |  | Assurance of Supply | 0.75
Assurance of Supply | 2 | 5 |  |  |  | Quality | 0.75
Assurance of Supply | 4 | 5 |  |  |  | Service | 0.75
Quality | 5 | 5 |  |  |  | Cost | 0.75
Quality | 4 | 5 |  |  |  | Innovation & Technology | 0.75
Quality | 4 | 5
Quality | 3 | 5
Quality | 1 | 5
Quality | 5 | 5
Quality | 5 | 5
Quality | 1 | 5
Quality | 4 | 5
Quality | 1 | 5
Quality | 1 | 5
Quality | 4 | 5
Quality | 1 | 5
Quality | 3 | 5
Quality | 3 | 5
Quality | 5 | 5
Quality | 3 | 5
Quality | 4 | 5
Quality | 2 | 5
Quality | 4 | 5
Quality | 4 | 5
Quality | 5 | 5
Quality | 1 | 5
Service | 4 | 5
Service | 3 | 5
Service | 2 | 5
Service | 5 | 5
Service | 2 | 5
Service | 4 | 5
Service | 2 | 5
Service | 2 | 5
Service | 1 | 5
Service | 5 | 5
Service | 4 | 5
Service | 2 | 5
Service | 1 | 5
Service | 2 | 5
Service | 2 | 5
Service | 5 | 5
Service | 5 | 5
Service | 1 | 5
Service | 3 | 5
Service | 3 | 5
Service | 4 | 5
Service | 4 | 5
Service | 1 | 5
Cost | 3 | 5
Cost | 3 | 5
Cost | 1 | 5
Cost | 5 | 5
Cost | 3 | 5
Cost | 2 | 5
Cost | 2 | 5
Cost | 4 | 5
Cost | 3 | 5
Cost | 5 | 5
Cost | 4 | 5
Cost | 3 | 5
Cost | 2 | 5
Cost | 3 | 5
Cost | 1 | 5
Cost | 4 | 5
Cost | 4 | 5
Cost | 4 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 2 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 4 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 5 | 5
Innovation & Technology | 5 | 5
Innovation & Technology | 2 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 3 | 5
Innovation & Technology | 1 | 5
Innovation & Technology | 1 | 5
Spreadsheet: 787574d1657877926-calculating-commission-with-multiple-hurdles-example-file
Sheet: Sheet1

Invoice | Total Rev | Comp | comp |  |  |  |  |  | From | Percentage | Increment
1 | 300000 |  |  |  |  |  |  |  | 0 | 0.4
2 | 200000 |  |  |  |  |  |  |  | 1000000 | 0.45
3 | 300000 |  |  |  |  |  |  |  | 2000000 | 0.5
4 | 100000 |  |  |  |  |  |  |  | 3000000 | 0.55
5 | 500000
6 | 2000000
7 | 150000
8 | 200000
9 | 300000
10 | 500000
Spreadsheet: 746503d1630776493-lookup-returning-duplicate-values-when-there-a-blank-can-it-search-in-sequence-sheet-for-excelhelp
Sheet: Front Sheet

 | WHO's ON WHAT
R1 | 2017-09-12 00:00:00 |  |  |  |  |  |  |  |  |  |  | Week No.
Rotation |  | Pay No |  |  |  | Duty folder | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rotate | Driver Name
1.1 |  |  |  |  |  | 001 |  | 1001 | 1001 | 1001 | 1001 | 1001 |  |  |  |  |  |  | 1
2.1 |  |  |  |  |  | 002 |  | 1006 | 1006 | 1006 | 1006 | 1801 |  |  |  |  |  |  | 2
2.2 |  |  |  |  |  | 003 | 1010 | 1007 |  |  |  |  |  |  |  |  |  |  | 3
3.1 |  |  |  |  |  | 004 |  |  | 1012 | 1012 | 1012 | 1804 |  |  |  |  |  |  | 4
3.2 |  |  |  |  |  | 005 |  | 1011 | 1011 | 1011 | 1011 | 1803 |  |  |  |  |  |  | 5
4.1 |  |  |  |  |  | 006 |  | 1203 | 1203 | 1203 | 1203 | 1808 |  |  |  |  |  |  | 6
5.1 |  |  |  |  |  | 007 | 1202A | 1202 | 1202 | 1202 | 1202 |  |  |  |  |  |  |  | 7
5.2 |  |  |  |  |  | 008 | 1005 | 1008 | 1008 | 1008 | 1008
6.1 |  |  |  |  |  | 009 |  | 1009 | 1009A | 1009A | 1009A |  |  |  |  |  |  |  | 9
7.1 |  |  |  |  |  | 010 |  | 1013 | 1013 | 1013 | 1013 | 1013
9.1 |  |  |  |  |  | 011 |  | 1204 | 1204 | 1204 | 1204
9.2 |  |  |  |  |  | 012 | 1207 | 1205 | 1205 | 1205 | 1205 |  |  |  |  |  |  |  | 12
10.1 |  |  |  |  |  | 013 | 1206 | 1206 | 1206 | 1206 | 1206 |  |  |  |  |  |  |  | 13
11.1 |  |  |  |  |  | 014 | 1208 | 1208 | 1208 | 1208 | 1208
11.2 |  |  |  |  |  | 015 |  | 1409 | 1409 | 1409 | 1409 | 1812 |  |  |  |  |  |  | 15
12.1 |  |  |  |  |  | 016 | 1209 | 1209 | 1209 | 1209 | 1209 |  |  |  |  |  |  |  | 16
12.2 |  |  |  |  |  | 017 |  | 1408 | 1408 | 1408 | 1408 | 1813 |  |  |  |  |  |  | 17
13.1 |  |  |  |  |  | 018 | 1401 | 1401 | 1401 | 1401 | 1401
13.2 |  |  |  |  |  | 019 |  | 1210 | 1210 | 1210 | 1210 | 1802 |  |  |  |  |  |  | 19
14.1 |  |  |  |  |  | 020 |  | 1403 | 1403 | 1403 | 1403 | 1814 |  |  |  |  |  |  | 20
14.2 |  |  |  |  |  | 021 | 1404 | 1404 | 1404 | 1404 | 1404