tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40560d1238916866-trying-to-retrieve-a-cell-from-table-in-sheet-2-to-sheet-1-management-and-billing
Sheet: management

Suwat's Shop |  |  | Management & Billing
TOTAL (Bahts) |  | EMPLOYEE NAME | Time |  | Total Hours | Options | TOTAL (Bahts) |  | Time |  | Total Hours | Options | TOTAL (Bahts) |  | Time |  | Total Hours | Options | TOTAL (Bahts)
TOTAL | EMPLOYEE |  | START | END |  | A / B / C | TOTAL | EMPLOYEE | START | END |  | A / B / C | TOTAL | EMPLOYEE | START | END |  | A / B / C | TOTAL | EMPLOYEE
 |  | Jirattaya | 06:30:00 | 10:30:00 | 04:00:00 | A |  |  | 06:30:00 | 10:30:00 | 04:00:00 | A |  |  | 06:30:00 | 10:30:00 | 04:00:00 | A
 |  | [NAME]
Spreadsheet: louise_kitchen__22552__Hot List Update 07-11-01
Sheet: Wellhead 50+

Deal Description Sheet - 7/2/01
Wellhead
YTD P&L |  | 81988
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
CL&F I |  | Continental Land & Fur | Accounting. | *$10,000 | 2001-05-22 00:00:00 | 0.9 | 2001-07-01 00:00:00 | Initial deal to close in June.  2 wells.  ATS & ENA commodity.
Aspect Resources |  | Aspect Resources | Well Connect Offsystem - Cross Media #1, TNCT #1, Galveston County, TX, [NAME] and 098-9816, FGT Meter 092-0490 and 092-0489. | *$50,000 | 2001-06-08 00:00:00 | 0.5 | 2001-07-01 00:00:00 | Meeting June 8, 2001.  Proposed total outsourcing and supply acquisition.
CL&F II |  | Continental Land & Fur | Accounting and scheduling, outsourcing. | 50000 | 2001-05-22 00:00:00 | 0.5 | 2001-09-01 00:00:00 | 300 wells depending on the success of CL&F II.
 |  |  |  |  |  |  |  | * Accrual
Spreadsheet: 149031d1333654513-excel-2007-help-with-an-expenses-tracker-pullman-audit-trail3
Sheet: P01

Payment Tracker
Payment List
Our ID | Supplier | Reference | Payment Type | £ Payment Amount
 |  |  |  | Net | VAT | Total |  | Counts This Month
1 | Sunderland Council | PL0056 | Staff Wages | 100 | 20 |  |  | Staff Wages
2 |  |  |  |  |  |  |  | Holiday Pay
3 |  |  |  |  |  |  |  | ER's, NI, Pensions
4 |  |  |  |  |  |  |  | Agency/Temp Staff
5 |  |  |  |  |  |  |  | Door Staff
6 |  |  |  |  |  |  |  | Contract Cleaners
7 |  |  |  |  |  |  |  | Management Salary
8 |  |  |  |  |  |  |  | Marketing
9 |  |  |  |  |  |  |  | Entertainment
10 |  |  |  |  |  |  |  | Music and TV License
11 |  |  |  |  |  |  |  | Sky Tv
12 |  |  |  |  |  |  |  | House Repairs
13 |  |  |  |  |  |  |  | Maintenance
14 |  |  |  |  |  |  |  | Epos (Tills)
15 |  |  |  |  |  |  |  | Other EQUIPT Rental
16 |  |  |  |  |  |  |  | Sanitary Services
17 |  |  |  |  |  |  |  | Cash Collection
18 |  |  |  |  |  |  |  | Cleaning Materials
19 |  |  |  |  |  |  |  | Gardening
20 |  |  |  |  |  |  |  | Health and Safety
21 |  |  |  |  |  |  |  | Pub Consumables
22 |  |  |  |  |  |  |  | Pump Gas
23 |  |  |  |  |  |  |  | Security
24 |  |  |  |  |  |  |  | Staff Recr & Training
25 |  |  |  |  |  |  |  | Refuse
26 |  |  |  |  |  |  |  | Uniforms
27 |  |  |  |  |  |  |  | Linen and Laundry
28 |  |  |  |  |  |  |  | Window Cleaning
29 |  |  |  |  |  |  |  | Licenses
30 |  |  |  |  |  |  |  | Knife Sharpening
31 |  |  |  |  | Grand Total |  |  | Other General Expenses
34 |  |  |  |  |  |  |  | Bank Charges
 |  |  |  |  |  |  |  | Credit Card Charges
 |  |  |  |  |  |  |  | Stolen/Forged Cash
 |  |  |  |  |  |  |  | Under and Overbanking
 |  |  |  |  |  |  |  | Proffesional Fees
 |  |  |  |  |  |  |  | Stationary & Postage
 |  |  |  |  |  |  |  | Telephone & Internet
 |  |  |  |  |  |  |  | Vehicle Costs
 |  |  |  |  |  |  |  | Travel Costs
 |  |  |  |  |  |  |  | Other Administraion Costs
 |  |  |  |  |  |  |  | Electricity
 |  |  |  |  |  |  |  | Gas
 |  |  |  |  |  |  |  | Water and Sewage
 |  |  |  |  |  |  |  | Business Rates
 |  |  |  |  |  |  |  | Insurance
 |  |  |  |  |  |  |  | Rent
 |  |  |  |  |  |  |  | Managers Accomodation
Spreadsheet: 805747d1668883366-sumproduct-does-not-work-if-there-is-something-other-than-a-number-in-the-cell-example-sum
Sheet: Sheet1

Day A |  |  | Result
3 | 10
3 | 10 |  | Work | Not Work
3" | 10"
Day B
3 | 10
3 | 10
3" | 10"
Day C
3 | 10
3 | 10
3" | 10"
Spreadsheet: 875770d1722375839-combining-consolidating-information-from-multiple-rows-book1
Sheet: Sheet1

Name | Entry | Amount |  |  |  |  | Name | Entry | Amount
B&K Distributing | A - costs received! | 350 |  |  |  |  | B&K Distributing | A - costs received! | 450
B&K Distributing | B - expense@ | 3 |  |  |  |  | B&K Distributing | B - expense@ | 35
B&K Distributing | B - expense@ | 2 |  |  |  |  | [NAME] | A - costs received! | 350
B&K Distributing | B - expense@ | 2 |  |  |  |  | [NAME] | B - expense@ | 209
B&K Distributing | B - expense@ | 22 |  |  |  |  | [NAME] | B - expense@ | 88
B&K Distributing | A - costs received! | 100 |  |  |  |  | [NAME] | E - payment# | 1300
B&K Distributing | B - expense@ | 4 |  |  |  |  | [NAME] | H - profit$ | 320
B&K Distributing | B - expense@ | 2 |  |  |  |  | [NAME] | J - remit$ | 995
[NAME] | B - expense@ | 195
[NAME] | B - expense@ | 3
[NAME] | B - expense@ | 11
[NAME] | A - costs received! | 350
[NAME] | B - expense@ | 50
[NAME] | B - expense@ | 18
[NAME] | B - expense@ | 20
[NAME] | E - payment# | 1300
[NAME] | H - profit$ | 320
[NAME] | J - remit$ | 995
Spreadsheet: 871701d1718116774-unique-sum-with-multiple-criteria-tests
Sheet: Result

 |  | Ref New |  | [NAME] |  | Whatsapp Note
 |  | Quantity | Value | Quantity | Value | Value
 |  | 619.66 | 189705 | 0 | 0 | 0
 | [NAME] | 1320 | 264000 | 0 | 0 | 0
 | Scented Adhesive Powder | 1015.05 | 456717 | 0 | 0 | 12788.76
 | Scented & Adhesive Clay | 238.3 | 94128.5 | 0 | 0 | 0
 | [NAME] | 8231.35 | 1970774.85 | 0 | 0 | 0
 | Freight | 7380.15 | 36900.75 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 4049.5 | 0
 | Desten & Biber | 0 | 0 | 88.3 | 38852 | 0
 | [NAME] | 0 | 0 | 30 | 3300 | 0
 | Grand Total | 18804.51 | 3012226.1 | 118.3 | 46201.5 | 12788.76
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: SITHE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 5376098 | 11250392
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 6498714 | 15325359
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 11874812 | 26575751
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -2210033 | -5334526 |  |  |  |  | 0 | 0
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -9703868 | -21344546
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 6578 | 15328
 | Total Purchases: |  | -11907323 | -26663744
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 18884 | 181988
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 30 |  |  |  |  | 0 | 0
 | Total Imbalances: |  | 18884 | 182018
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 13627 | 31584.03673286546
 |  |  | 0 | 0
23 | Fuel: |  | -6578 | -15328
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -7556
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -7556
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 77884
31 |  | Prior Month Book Balance | 0 | -17435
 |  | Total MTM Income | 0 | 60449
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -202520
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 139400
 |  | TOTAL INTRA-MTH
Spreadsheet: 866063d1713000196-need-formula-that-extracts-every-third-value-in-col-b-based-on-value-1-2-3-in-col-a-transcript-365-aligw
Sheet: Step1

0:0:0.0 --> 0:0:1.470 |  |  | [NAME] | Umm I have about one minute.
[NAME] |  | 0:0:2.990 --> 0:0:3.640 | [NAME] | We can start the meeting.
Umm I have about one minute. |  | 0:0:4.210 --> 0:0:4.750 | [NAME] | Sounds good.
0:0:2.990 --> 0:0:3.640 |  | 0:0:5.630 --> 0:0:6.220 | [NAME] | Thanks, [NAME].
[NAME] |  | 0:0:6.230 --> 0:0:11.900 | [NAME] | So I still see we don't have anyone from Organization X.
We can start the meeting. |  | 0:0:14.0 --> 0:0:21.870 | [NAME] | We can expect other participants as well.
0:0:4.210 --> 0:0:4.750 |  | 0:0:22.400 --> 0:0:24.230 | [NAME] | So let's give it a minute.
[NAME] |  | 0:0:31.740 --> 0:0:32.440 | [NAME] | We certainly do.
Sounds good. |  | 0:0:32.450 --> 0:0:36.770 | [NAME] | Do you know whether someone from Organization Y will join?
0:0:5.630 --> 0:0:6.220 |  | 0:0:36.780 --> 0:0:41.530 | [NAME] | Anybody else from your team will be joining this meeting.
[NAME] |  | 0:0:42.170 --> 0:0:44.250 | [NAME] | IT Help Desk should join.
Thanks, [NAME]. |  | 0:0:44.260 --> 0:0:51.120 | [NAME] | I believe [NAME] is on a telephone call, so I'm not sure if he'll be able to make it in, but I think we're good.
0:0:6.230 --> 0:0:11.900
[NAME]
So I still see we don't have anyone from Organization X.
0:0:14.0 --> 0:0:21.870
[NAME]
We can expect other participants as well.
0:0:22.400 --> 0:0:24.230
[NAME]
So let's give it a minute.
0:0:31.740 --> 0:0:32.440
[NAME]
We certainly do.
0:0:32.450 --> 0:0:36.770
[NAME]
Do you know whether someone from Organization Y will join?
0:0:36.780 --> 0:0:41.530
[NAME]
Anybody else from your team will be joining this meeting.
0:0:42.170 --> 0:0:44.250
[NAME]
IT Help Desk should join.
0:0:44.260 --> 0:0:51.120
[NAME]
I believe [NAME] is on a telephone call, so I'm not sure if he'll be able to make it in, but I think we're good.
Spreadsheet: 857174d1706212158-match-id-to-second-page-and-receive-result-payout-question
Sheet: Contact Info

ID | First Name | Last Name | [NAME] | Payout
999999 | Cloud | Strife | [EMAIL]
888888 | [NAME] | Lockhart | [EMAIL]
123456 | Sephiroth | Hojo | [EMAIL]
987654 | Aerith | Gainsborough | [EMAIL]
456484 | Barret | [NAME] | [NAME]
Spreadsheet: 493864d1481916619-how-to-count-if-a-cell-contains-a-number-which-is-between-2-numbers-score-based-on-if-between-two-times
Sheet: Sheet1

Person | 2016-12-01 00:00:00 | 2016-12-02 00:00:00 | 2016-12-03 00:00:00 | 2016-12-04 00:00:00 | 2016-12-05 00:00:00 | Score
[NAME] | 00:04:00 | 00:10:00 | 00:05:01 | 00:31:00 | 00:00:05 | 5
[NAME] | 00:03:00 | 00:00:36 | 02:35:25 | 00:59:59 | 00:00:48 | 9
 |  |  | Score
 | 00:05:00 | 0.00347222222222222 | 1
 | 00:15:00 | 0.0104166666666667 | 2
 | 00:30:00 | 0.0208333333333333 | 3
 | 01:00:00 | 0.0416666666666666 | 6
Spreadsheet: 1fb6c578-01e1-4eb8-bf39-b17258587aac
Sheet: ethnicity graph

back to tables |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values | White | Hispanic | Unknown | African American | Filipino | Asian | Multi-Race | Native American | Pacific Islander | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY07-08# | 6073 | 3497 | 939 | 819 | 621 | 453 | 204 | 130 | 88 | 12824
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY08-09# | 6628 | 4002 | 1137 | 951 | 647 | 489 | 242 | 144 | 100 | 14340
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY09-10# | 6423 | 4289 | 1013 | 926 | 609 | 443 | 463 | 122 | 87 | 14375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY10-11# | 5563 | 4143 | 670 | 805 | 507 | 414 | 574 | 89 | 62 | 12827
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY11-12# | 4964 | 4339 | 455 | 727 | 455 | 325 | 636 | 66 | 47 | 12014
Spreadsheet: 858432d1707134868-create-list-based-on-top-10-highest-scores-with-criteria-book1
Sheet: Sheet1

Student | Score | Subject
Bianca [NAME] | 75 | Sport |  | TOP 3 Total Score in English
[NAME] | 65 | Sport |  |  | Name | Score
[NAME] | 45 | Sport |  | 1 | [NAME]
[NAME] | 28 | Sport |  | 2 | [NAME]
Bianca [NAME] | 98 | Science |  | 3 | Finna L
[NAME] | 88 | Science
[NAME] | 87 | Science
[NAME] | 69 | Science
[NAME] | 75 | English
Bianca [NAME] | 80 | English
[NAME] | 75 | English
Finna L | 80 | English
Finna L | 40 | English
[NAME] | 78 | English
[NAME] | 45 | English
[NAME] | 38 | English
[NAME] | 78 | English
[NAME] | 58 | English
[NAME] | 28 | English
[NAME] | 78 | English
Spreadsheet: 70801d1271487872-sorting-data-based-on-individual-fields-book1
Sheet: Yearlys

Education Database
Name | Unit | Clinical | Course 1 | Course 2 | Course 3 |  |  |  | Total Staff = | 10
[NAME] | Administration | No | 2009-04-03 00:00:00 | 2009-09-07 00:00:00 | 2009-05-19 00:00:00 |  |  |  | Course 1 Completed % = | 0.6
[NAME] | Housekeeping | No | 2010-04-17 00:00:00 | 2009-05-19 00:00:00 | 2009-09-07 00:00:00 |  |  |  | Course 2 Completed % = | 0.5
flinstone | Maintenance | No | 2009-05-18 00:00:00 | 2009-03-29 00:00:00 | 2010-03-15 00:00:00 |  |  |  | Course 3 Completed % = | 0.7
jane | Maternity | Yes | 2010-03-17 00:00:00 | 2009-03-29 00:00:00 | 2010-02-18 00:00:00
wilma | Maternity | Yes | 2010-03-17 00:00:00 | 2009-05-18 00:00:00 | 2009-05-18 00:00:00
[NAME] | Maternity | Yes | 2010-02-18 00:00:00 | 2010-02-18 00:00:00 | 2010-02-18 00:00:00
buggery | Medical | Yes | 2010-02-18 00:00:00 | 2009-05-19 00:00:00 | 2010-04-17 00:00:00
fellow | Executive | No
jonny bigs | Allied Health | Yes
[NAME] | ICU | Yes
Spreadsheet: marie_heard__24531__Alberta Newsprint Company Omnibus
Sheet: ANEWSWP2

Omnibus Confirmation Annexes B and B1
 |  | ATTORNEY:
DATE: | 2001-10-15 00:00:00 | DEAL MAKER: | [NAME]
COUNTERPARTY: | Alberta Newsprint Company | CONTACT:
ADDRESS: | [NAME] | TITLE:
 | Whitecourt, AB T7S 1P9 | PHONE:
 | Canada | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 17
Incorporation State |  | OR
COLLATERAL  THRESHOLD MATRIX in $ MILLIONS
based on S & P and
Moody's ratings |  | X
 | 12 | 15
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
-Guarantor | X | X
Debt Ratings Change
-Below = S&P/Moody's |  | BBB-
Financial Covenants | X
-Total Debt to Worth | .5 to 1
-Minimum Net Worth | $140 US MM
-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])
-Guarantor ($[NAME]) | 10 | 100
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:
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] | X3-6165
Spreadsheet: 768233d1644891604-simple-formula-ifs-countif-case-monitoring
Sheet: Group

 | Company | 2022 – Number of positive cases
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | Total | Total | Under
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Recovered | Active | Quarantine
 | GSCB | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | PP
 | GSV
 | GSP
 | DOSB
 | Total
 |  |  |  |  |  | COUNTIFS(Sheet1!$A$3:$A$100,L5,Sheet1!$B$3:$B$100,"Feb",Sheet1!,)>0
Spreadsheet: 6b084458-4711-4153-b5e7-237bf787be75
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
[NAME] | Test | [NAME] | Protein, Total, Body Fluid | Protein, Total, BF | Photometric, [NAME] | Plastic vial: PlV |  |  | 1 | mL | Container/Tube: Sterile container [NAME]: 1 mL Collection Instructions: 1. Centrifuge to remove any cellular material. 2. Indicate specimen source. Additional Information: For spinal fluid, see test TPSF/872 Protein, Total, Spinal Fluid. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Spinal fluid | Not applicable | Monday through Sunday; Continuously | Same day/1day | 2 days | 1 | 84157 |  |  |  |  | Rochester
[NAME] | [NAME] | BODYFL | Body Fluid |  |  |  | Refrigerated | 7 days
[NAME] | Order Question | [NAME] | [NAME] |  | Plain Text
[NAME] | Result | TPBF1 | Protein, Total, BF | Protein, Total, BF | Numeric |  |  |  |  | g/dL |  |  |  |  |  |  |  |  |  | 2881-1 | Protein:MCnc:Pt:Body fld:Qn:
[NAME] | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6 | Fluid:Type:Pt:Body fld:Nom:
Spreadsheet: 36913d1234882340-vlookup-data-and-return-results-on-multiple-entries-members
Sheet: Events Attended Total

Account # | Event 1 | Date | Event 2 | Date | Event 3 | Date | Event 4 | Date | Event 5 | Date
12345
Click in cell A2 and select from the list
Spreadsheet: 866667d1713553230-of-vacant-units-using-2-pivot-tables-dynamic-sample-pivot-jeptik-
Sheet: Parking & Lockers - Data

Region | (All) |  |  |  | Region | (All) |  |  |  |  |  |  |  | Region | All
Director | (All) |  |  |  | Director | (All) |  |  |  |  |  |  |  | Director | All
OM | (All) |  |  |  | OM | (All) |  |  |  |  |  |  |  | OM | All
Unit sub t | PARKING |  |  |  | Unit sub t | PARKING |  |  |  |  |  |  |  | Unit sub t | PARKING
Vacant | (All) |  |  |  | Vacant | X |  |  |  |  |  |  |  | Vacant | All
Count of ID | Column Labels |  |  |  | Count of ID | Column Labels |  |  |  |  |  |  |  | % Vacant | Month
Row Labels | Jan | Feb | Mar |  | Row Labels | Jan | Feb | Mar |  | Jan | Feb | Mar |  | Site | Jan | Feb | Mar
A | 48 | 48 | 48 |  | D | 9 | 9 | 9 |  |  |  |  |  | D | 0.1323529411764706 | 0.1323529411764706 | 0.1323529411764706
B | 40 | 40 | 40 |  | E | 151 | 130 | 36 |  |  |  |  |  | E | 0.9741935483870968 | 0.5284552845528455 | 0.232258064516129
C | 86 | 86 | 86 |  | F | 8 | 9 | 9 |  |  |  |  |  | F | 0.126984126984127 | 0.1428571428571428 | 0.1428571428571428
D | 68 | 68 | 68 |  | G | 103 | 87 | 83 |  |  |  |  |  | G | 0.3410596026490066 | 0.2949152542372881 | 0.2813559322033898
E | 155 | 246 | 155 |  | Grand Total | 271 | 235 | 137 |  |  |  |  |  | Grand Total | 0.4608843537414966 | 0.3497023809523809 | 0.2358003442340792
F | 63 | 63 | 63
G | 302 | 295 | 295
Grand Total | 762 | 846 | 755
Spreadsheet: 89026d1288805985-vlookup-using-two-parameters-example
Sheet: Weather

Station | Date | Visibility
Alpha | 2004-05-01 00:00:00 | 6.571331326217626
Alpha | 2004-05-02 00:00:00 | 5.27907401220741
Alpha | 2004-05-03 00:00:00 | 3.724796759432095
Alpha | 2004-05-04 00:00:00 | 1.254605813673123
Alpha | 2004-05-05 00:00:00 | 5.653860538028532
Alpha | 2004-05-06 00:00:00 | 2.847550310242397
Alpha | 2004-05-07 00:00:00 | 4.591011515529894
Alpha | 2004-05-08 00:00:00 | 7.225363136018299
Alpha | 2004-05-09 00:00:00 | 0.02550744565016672
Alpha | 2004-05-10 00:00:00 | 4.325103759217974
Alpha | 2004-05-11 00:00:00 | 5.760643352219946
Alpha | 2004-05-12 00:00:00 | 6.241902100329114
Alpha | 2004-05-13 00:00:00 | 0.1383461407083448
Alpha | 2004-05-14 00:00:00 | 5.400162924288278
Alpha | 2004-05-15 00:00:00 | 7.077034384379976
Alpha | 2004-05-16 00:00:00 | 5.03044670407477
Alpha | 2004-05-17 00:00:00 | 3.004769298396155
Alpha | 2004-05-18 00:00:00 | 2.205369611203814
Alpha | 2004-05-19 00:00:00 | 4.294547515850454
Alpha | 2004-05-20 00:00:00 | 1.682744785667019
Alpha | 2004-05-21 00:00:00 | 0.05299798120353216
Alpha | 2004-05-22 00:00:00 | 0.9715682840618118
Alpha | 2004-05-23 00:00:00 | 0.01856687232663745
Alpha | 2004-05-24 00:00:00 | 7.426149128222448
Alpha | 2004-05-25 00:00:00 | 3.663287564672453
Alpha | 2004-05-26 00:00:00 | 4.791565246139566
Alpha | 2004-05-27 00:00:00 | 7.66754319789816
Alpha | 2004-05-28 00:00:00 | 6.325906230389601
Alpha | 2004-05-29 00:00:00 | 6.919742751741119
Alpha | 2004-05-30 00:00:00 | 0.1766010937419509
Alpha | 2004-05-31 00:00:00 | 6.320098564153291
Bravo | 2005-08-01 00:00:00 | 4.728802089524891
Bravo | 2005-08-02 00:00:00 | 4.949150448361216
Bravo | 2005-08-03 00:00:00 | 2.7078098336374
Bravo | 2005-08-04 00:00:00 | 7.528389394499101
Bravo | 2005-08-05 00:00:00 | 1.670638582897761
Bravo | 2005-08-06 00:00:00 | 0.7780825428296048
Bravo | 2005-08-07 00:00:00 | 2.449559919152554
Bravo | 2005-08-08 00:00:00 | 3.049581468851464
Bravo | 2005-08-09 00:00:00 | 5.939496418291315
Bravo | 2005-08-10 00:00:00 | 6.343158708891877
Bravo | 2005-08-11 00:00:00 | 1.848844798987095
Bravo | 2005-08-12 00:00:00 | 7.021353091234161
Bravo | 2005-08-13 00:00:00 | 6.578136560836249
Bravo | 2005-08-14 00:00:00 | 4.374768357050245
Bravo | 2005-08-15 00:00:00 | 5.178640588319084
Bravo | 2005-08-16 00:00:00 | 4.616827900276727
Bravo | 2005-08-17 00:00:00 | 6.514761997188852
Bravo | 2005-08-18 00:00:00 | 3.020771415885029
Bravo | 2005-08-19 00:00:00 | 6.269924763349552
Bravo | 2005-08-20 00:00:00 | 3.331188081689362
Bravo | 2005-08-21 00:00:00 | 4.120730287184692
Bravo | 2005-08-22 00:00:00 | 0.8363296542088268
Bravo | 2005-08-23 00:00:00 | 5.76071773009642
Bravo | 2005-08-24 00:00:00 | 4.150744374813605
Bravo | 2005-08-25 00:00:00 | 6.744856262467467
Bravo | 2005-08-26 00:00:00 | 6.691016710804508
Bravo | 2005-08-27 00:00:00 | 1.236330251077362
Bravo | 2005-08-28 00:00:00 | 4.695145459601576
Bravo | 2005-08-29 00:00:00 | 5.94816112479864
Bravo | 2005-08-30 00:00:00 | 7.474739936406847
Bravo | 2005-08-31 00:00:00 | 7.031778052746688
Spreadsheet: 775793d1649323897-automation-in-stacking-column-one-below-another-abcefg-solution
Sheet: Sheet1

 |  |  | ABC | EFG | ABCEFG
 |  |  | fjfjif | fpftoi
 |  |  | fiffof | fkjfjfj
 |  |  | fkjfkfjkfj | fjfhfuh
 |  |  | fifjfd | fkfkjf
Spreadsheet: 136312d1326533590-vlookup-limits-multi-year-testing-data-sheets2
Sheet: 2012

year | 2012
Name | age | spelling | maths | reading
 |  | 14 | 6705 | 8
 |  | 15 | 75 | 9
 |  | 16 | 80 | 10
 |  | 17 | 85 | 11
 |  | 18 | 90 | 12
 |  | 1* | 95 | 13