tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 66454d1267102987-someproduct-or-vlookup-question
Sheet: Sheet1

Table A | Ref | Prod | Date |  | Table B | Ref | Prod | Date
 | 123 | ABC | 2010-02-24 00:00:00 |  |  | 123 | ABC | 2010-02-05 00:00:00
 | 123 | DEF | Discontinued |  |  | 123 | ERT | 2010-05-17 00:00:00
 | 123 | ERT | 2010-05-08 00:00:00 |  |  | 234 | KLM | 2010-02-24 00:00:00
 | 234 | KLM | 2010-02-24 00:00:00 |  |  | 354 | RST | 2010-02-23 00:00:00
 | 354 | RST | 2010-02-23 00:00:00 |  |  | 789 | DEF | 2010-02-21 00:00:00
 | 354 | ABC | 2010-05-10 00:00:00 |  |  | 354 | PQR | 2010-02-24 00:00:00
 | 354 | PQR | Out of stock |  |  | 354 | HIJ | 2010-02-23 00:00:00
 | 354 | HIJ | 2010-02-23 00:00:00 |  |  | 456 | ABC | 30/02/2010
 | 456 | ABC | 2010-02-24 00:00:00 |  |  | 456 | KLM | 2010-02-24 00:00:00
 | 456 | KLM | 2010-02-24 00:00:00 |  |  | 567 | VWX | 2010-02-24 00:00:00
 | 456 | XYZ | 2010-02-19 00:00:00
 | 567 | VWX | 2010-02-24 00:00:00
Spreadsheet: 112363d1308526194-2-data-validation-cells-with-vlookup-fpg-trial-2011-12
Sheet: TEAMS

 | PREMIER LEAGUE |  | CHAMPIONSHIP |  | LEAGUE ONE |  | LEAGUE TWO |  | PLAYERS
1 | Arsenal | 1 | Barnsley | 1 | AFC Bournemouth | 1 | Accrington Stanley | 1 |  |  | V
2 | [NAME] | 2 | Birmingham City | 2 | Brentford | 2 | Aldershot Town | 2 |  |  | -
3 | [NAME] | 3 | Blackpool | 3 | Bury | 3 | Barnet | 3
4 | [NAME] | 4 | [NAME] and Hove Albion | 4 | Carlisle United | 4 | Bradford City | 4
5 | Chelsea | 5 | Bristol City | 5 | [NAME] | 5 | Bristol Rovers | 5
6 | Everton | 6 | Burnley | 6 | Chesterfield | 6 | [NAME] | 6
7 | Fulham | 7 | Cardiff City | 7 | Colchester United | 7 | [NAME] | 7
8 | Liverpool | 8 | Coventry City | 8 | Exeter City | 8 | [NAME] | 8
9 | Manchester City | 9 | Crystal Palace | 9 | Hartlepool United | 9 | [NAME] and [NAME] | 9
10 | [NAME] | 10 | Derby County | 10 | Huddersfield Town | 10 | [NAME] | 10
11 | Newcastle United | 11 | Doncaster Rovers | 11 | Leyton Orient | 11 | Hereford United
12 | Norwich City | 12 | Hull City | 12 | [NAME] | 12 | AFC Wimbledon
13 | Queens Park Rangers | 13 | Ipswich Town | 13 | Notts County | 13 | [NAME]
14 | Stoke City | 14 | [NAME] | 14 | Oldham Athletic | 14 | Morecambe
15 | Sunderland | 15 | Leicester City | 15 | [NAME] | 15 | Northampton Town
16 | Swansea City | 16 | Middlesbrough | 16 | Rochdale | 16 | Oxford United
17 | [NAME] | 17 | Millwall | 17 | Scunthorpe United | 17 | Plymouth Argyle
18 | West Bromwich Albion | 18 | [NAME] | 18 | Sheffield United | 18 | Port Vale
19 | Wigan Athletic | 19 | Peterborough United | 19 | Sheffield Wednesday | 19 | [NAME]
20 | [NAME] | 20 | Portsmouth | 20 | Stevenage Borough | 20 | Shrewsbury Town
 |  | 21 | Reading | 21 | Tranmere Rovers | 21 | Southend United
 |  | 22 | Southampton | 22 | Walsall | 22 | Crawley Town
 |  | 23 | Watford | 23 | Wycombe Wanderers | 23 | Swindon Town
 |  | 24 | West Ham United | 24 | [NAME] | 24 | [NAME]
Spreadsheet: 120324d1315210410-extract-data-from-a-matrix-dataset-in-excel-1
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
FBL | a | On-Time | Delay | On-Time | Delay | Delay | On-Time | On-Time | On-Time | On-Time | Delay | On-Time | On-Time
FBL | b | Delay | On-Time | On-Time | Delay | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | Delay
FBL | c | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
FBL | d | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
FBL | e | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
FBL | f | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
FBL | g | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
FBL | h | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
FBL | i
FBL | j
NE | k | On-Time | Delay | Delay | Delay | On-Time | Delay | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
NE | l | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
NE | m | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
NE | n |  |  | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | Delay | On-Time
NE | o
AMS | p | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
AMS | q | On-Time | On-Time | On-Time | Delay | On-Time | Delay | On-Time | On-Time | On-Time | On-Time | On-Time | Delay
AMS | r | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
AMS | s | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
AMS | a | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted | Not Submitted
EAGM | b | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
EAGM | d | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time | On-Time
EAGM | y | On-Time | On-Time | Delay | Delay | On-Time | On-Time | On-Time | Delay | Delay | On-Time | On-Time | Delay
EAGM | t
EAGM | c
Spreadsheet: 798476d1664494332-how-to-populate-other-cells-based-on-drop-down-value-plus-a-couple-other-questions-sample-pd-sheet
Sheet: OT

PSID | Rcd | Name | Earn ID | PP | Fund | Dept | S/C | Acct | Monthly Base | Shift | Stipend | Calculated OT Rate | Hours | Amount Due
110350077 | 0 | Smith, VALERIE | OTPR | 2022-09-22 00:00:00 | 48541 | 43426 | 00000 | 601933 | 3505 |  |  |  | 5.2
105089348 | 0 | Jones, [NAME] | OTPR | 2022-09-22 00:00:00 | 46715 | 43426 | 42513 | 601933 | 6548 |  |  |  | 3
101016366 | 0 | Test, RICHARD | OTST | 2022-09-22 00:00:00 | 47205 | 63491 | 42512 | 601933 | 4541 |  |  |  | 19
14816 | 0 | Doe, MAYRA | OTPR | 2022-09-22 00:00:00 | 496F6 | 43425 | 42504 | 601933 | 4280 |  |  |  | 27
Spreadsheet: 0a0162b8-4da1-485b-b4bc-17fa0ad8ffb4
Sheet: Sheet1

FY 2010/11 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | EXHIBIT E5 | Unnamed: 8
INN BUDGET SUMMARY
County: |  | Merced County |  |  |  | Date:
INN Programs |  |  | FY 10/11 Requested MHSA Funding | Estimated MHSA Funds by Age Group (if applicable)
 | No. | Name |  | Children and Youth | Transition Age Youth | Adult | Older Adult
Previously Approved Programs
1 |  | Not-Applicable to Merced County | 0
2 |  |  | 0
3 |  |  | 0
4 |  |  | 0
5 |  |  | 0
6 |  |  | 0
7 |  |  | 0
8 |  |  | 0
9 |  |  | 0
10 |  |  | 0
11 |  |  | 0
12 |  |  | 0
13 |  |  | 0
14 |  |  | 0
15 |  |  | 0
16 | Subtotal: Programs |  | 0 | 0 | 0 | 0 | 0 | Percentage
17 | Plus up to 15% County Administration
18 | Plus up to 10% Operating Reserve
19 | Subtotal: Previously Approved Programs/County Admin./Operating Reserve |  | 0
New Programs
1 |  |  | 0
2 |  |  | 0
3 |  |  | 0
4 |  |  | 0
5 |  |  | 0
6 | Subtotal: Programs |  | 0 | 0 | 0 | 0 | 0 | Percentage
7 | Plus up to 15% County Administration
8 | Plus up to 10% Operating Reserve
9 | Subtotal: New Programs/County Admin./Operating Reserve |  | 0
10 | Total MHSA Funds Requested for INN |  | 0
Note:  Previously Approved Programs that propose changes to essential purpose, learning goal, and/or funding as described in the Information Notice are considered New.
Spreadsheet: 472473d1469614649-how-do-i-display-lookup-for-multiple-data-address-mix
Sheet: NEED FORMULA

GROUP NO | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS | CUSTOMER ADDRESS & OFFICE ADDRESS
7010/27
7010/29
Spreadsheet: 758599d1638965923-data-validation-with-logic-data-validation-with-logic
Sheet: Activities

Activity Number | Activities | Operation
1 | Built-up Blasting @ Green Belt | Painting
2 | Cold Form Blasting @ Green Belt | Painting
3 | Built-up Painting @ B Bld. | Painting
4 | Built-up Painting @ Green Belt | Painting
5 | Cold Form Painting @ B Bld. | Painting
6 | Cold Form Painting @ Green Belt | Painting
7 | Blasting @ Blastroom | Painting
8 | Cold Form Blasting @ B Bld. | Painting
9 | Built-up Blasting @ B Bld. | Painting
11 | B-up Fabrication <100 Kgs. @ G.B. | Fabrication
12 | B-up Fabrication >100 Kgs. @ G.B. | Fabrication
13 | B-up Normal Fabrication @ G.B. | Fabrication
20 | [NAME].  @ G.B. (Incl. Cut & Punch) | Fabrication
22 | Hand Rail& Bird Mesh  Fab.@ G.B | Fabrication
23 | Louver [NAME] | Fabrication
24 | Other CF Fabrication @ G.B. | Fabrication
25 | Stringer Fabrication @ G.B. | Fabrication
26 | [NAME] | Fabrication
27 | Bird Mesh Fabrication @ G.B. | Fabrication
30 | Welding&Clearing Green Belt | Fabrication
31 | B/up Clearing green belt | Fabrication
33 | Column Fabrication (Star & Box) | Fabrication
67 | Hiring of Trailer (Inter-carting) | Fabrication
Spreadsheet: 860919d1708942507-excel-cant-create-an-auto-scheme-ejercicio-2-1-1
Sheet: Hoja1

Relacion de Gastos
 | Enero | Febrero | Marzo | Abril | Mayo | [NAME] | Total
Ag u a | 200 |  | 180 |  | 210 |  | 590
Luz | 180 | 180 | 180 | 180 | 180 | 180 | 1080
Telefono | 250 | 270 | 272 | 275 | 275 | 281 | 1623
Renta | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 9000
Total | 2130 | 1950 | 2132 | 1955 | 2165 | 1961 | 12293
Spreadsheet: 43923d1242583680-creating-a-list-from-across-sheets-problem-2
Sheet: 3

 |  |  | REGULAR |  | PREMIUM |  |  | PLUS |  | DIESEL
DEL BOL# | 564414 |  | 6003 |  | 2500
DEL BOL# | 21182 |  | 6002 |  | 2002
DEL BOL# | 21205 |  | 5650 |  | 1903 |  |  | 1150
DEL BOL# | 21218 |  | 6500 |  | 806 |  |  | 806
DEL BOL#
DEL BOL#
Spreadsheet: 0f28c94f-dd3a-4975-abe0-e23bb4609eb7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
*** | ***
آذربايجان  شرقي | آذربايجان  شرقي
آذربايجان شرقي | آذربايجان  شرقي
آذربايجان  شرقي | آذربايجان  شرقي
آذربايجان  غربي | آذربايجان  غربي
[NAME] | آذربايجان  غربي
آذربايجان  غربي | آذربايجان  غربي
اردبيل | اردبيل
اصفهان | اصفهان
ايلام | ايلام
بوشهر | بوشهر
تهران | تهران
چهارمحال بختياري | چهارمحال و بختياري
چهارمحال و بختياري | چهارمحال و بختياري
چهارمحال و بختياري | چهارمحال و بختياري
خراسان | خراسان
[NAME] | [NAME]
زنجان | زنجان
سمنان | سمنان
[NAME] و  بلوچستان | [NAME] و  بلوچستان
فارس | فارس
قزوين | قزوين
قم | قم
کرمان | کرمان
كرمان | کرمان
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
کهکیلویه و بویر احمد | كهكيلويه و  بوير احمد
كهكيلويه و  بوير احمد | كهكيلويه و  بوير احمد
گلستان | گلستان
گيلان | گيلان
لرستان | لرستان
مازندران | مازندران
مرکزی | مرکزی
مركزي | مرکزی
هرمزگان | هرمزگان
همدان | همدان
یزد | یزد
يزد | یزد
Spreadsheet: 488391d1478635853-transfer-data-from-one-spreadsheet-to-another-but-other-has-different-layout-copy-of-sample-help-1
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Estate Agency Tracker |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Practice 1
 |  | Agency Name | Address | Telephone Website | Website URL | No. Branches | Quartile | ValPal | CRM | Web Design |  |  |  |  |  |  | Practice 2
Spreadsheet: phillip_m_love__31157__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 11/08/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Direct Energy Resources, a division | YI3198.1 | F | NG | [NAME]
New Counterparty | YI3191.1/2 YI3195.1/2 YI3196.1/2 | P | NGGJ | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
AES Deepwater, Inc. | YI1595.1 | F | NG | AES NewEnergy, Inc.
Aquila Energy Marketing Corporation | YI1246.1 | F | NG | Aquila Risk Management Corporation
Spreadsheet: 771164d1646469089-name-check-data-validation-formula-doofus-writer-data-extraction2-aligw
Sheet: Sheet1

xxxxxxxxxx  written by [NAME] (RE: related document(s) xxxxxxxxxxxxx
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
145455215
1S1S1S1S1S1S1SS1S1S1A1A1S11DD1D1D1
xxxxxxxxxx  written by [NAME] and [NAME]  (RE: related document(s) xxxxxxxxxxxxx
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
145455215
1S1S1S1S1S1S1SS1S1S1A1A1S11DD1D1D1
xxxxxxxxxx  written by [NAME] (RE: related document(s) xxxxxxxxxxxxx
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
145455215
1S1S1S1S1S1S1SS1S1S1A1A1S11DD1D1D1
xxxxxxxxxx  written by Penelope [NAME] (RE: related document(s) xxxxxxxxxxxxx
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
145455215
1S1S1S1S1S1S1SS1S1S1A1A1S11DD1D1D1
xxxxxxxxxx  written by Paddy Chayefsky  (RE: related document(s) xxxxxxxxxxxxx
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
145455215
1S1S1S1S1S1S1SS1S1S1A1A1S11DD1D1D1
Spreadsheet: 220601d1363201375-need-formula-to-figure-out-federal-tax-on-worksheet-john-h-7
Sheet: Input Sheet

Loving Memories
Pay Period | 2013-03-31 00:00:00
 | Employee | Employer | Limits
Oasdi Tax | 0.062
HI Tax | 0.0145
SIT Tax | 0.0307
SUTA Tax | 0.06 | 0.035 | 7000
FUTA tax |  | 0.008 | 8000
CIT Tax | 0.04219
Union Dues | 8
 |  |  |  | Regular Earnings |  |  | Overtime Earnings
 | Department | Martial Status | No. of W/H Allow. |  |  |  |  |  | Account Numbers
 |  |  |  |  |  |  |  |  | 28
 |  |  |  |  | Rate |  |  | Previous
 |  |  |  |  | Per |  |  | Y-T-D | Union | CK.
Name |  |  |  | Hrs. | Hour | Amount | Hrs. | Earnings | Dues | No.
Parker, P. | 4 | 2 | 4 | 80 | 17.65 | 1412 | 2 | 11322 | 8 | 672
Reed, R. | 3 | 2 | 5 | 80 |  | 2250 |  | 23125 |  | 673
Banner, [NAME] | 2 | 1 | 2 | 80 |  | 900 |  | 6300 |  | 674
Wayne, B. | 3 | 2 | 4 | 80 |  | 1350 |  | 5400 |  | 675
[NAME], F. | 1 | 2 | 3 | 80 |  | 2307.69 |  | 42692.27 |  | 676
Fury, N. | 2 | 1 | 1 | 80 |  | 690 |  | 6240 |  | 677
[NAME], T. | 4 | 2 | 4 | 80 | 18 | 1440 | 4 | 14685.3 | 8 | 678
Storm, J. | 4 | 2 | 2 | 80 |  | 2050 |  | 16650 |  | 679
Pym, H. | 2 | 1 | 1 | 72 | 7.5 | 540 |  | 5550 |  | 680
Blake, D. | 2 | 1 | 0 | 80 |  | 1223.08 |  | 10260 |  | 681
Created by | [NAME]
Spreadsheet: 46264d1245163826-summarising-data-summary-ordering-book-example-
Sheet: Tuesday

HSCB No | Contractor No | Organisation Type | Name | Trading As: | Address1 | Address2 | Address3 | Address4 | Postcode | Postcode2 | Ward | DC | Settlement | Cluster Number | Tamiflu 75mg  Number issued | Tamiflu 75mg  Number received | Tamiflu 75mg  Running Balance | Stock Reorder  Tamiflu 75mg  289-5795 | Tamiflu 45mg  Number issued | Tamiflu 45mg number received | Tamiflu 45mg Running Balance | Stock Reorder Tamiflu 45mg     333-8837 | Tamiflu 30mg number issued | Tamiflu 30mg number received | Tamiflu 30mg Running Balance | Stock Reorder Tamiflu 30mg     333-8464 | Tamiflu suspension Number issued | Tamiflu suspension Number received | Tamiflu suspension [NAME] | Stock Reorder Tamiflu susp  289-5811 | [NAME] issued | [NAME] received | [NAME] | Stock Reorder Relenza 5mg     263-9953 | [NAME] issued | [NAME] received | [NAME] balance | Stock Reorder Ostelamivir | Status Level
S | [NAME] | Jones | [NAME] |  |  |  |  |  |  |  |  | Kent | CRAIGAVON URBAN AREA AND BLEARY |  | 15 |  | 5 | 0 |  |  | 1 | 12 |  |  | 3 | 5 |  |  | 0 | 2 |  |  | 1 | 0 |  |  | 0 | 0 |  | 1
DD/MM/YY
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 1567973 | 1171713 | 2015975 | 2872497 | 3913388 | 1767323 | 1299569 | 95501 | 14703939
Fixed-Float | 10535134 | 7895331 | 15191447 | 28153727 | 61911624 | 42578597 | 19988961 | 1960073 | 188214894
FRA | 24364334 | 12270945 | 11902982 | 3430256 | 217864 | - | - | - | 52186381
OIS | 13889375 | 5372262 | 8136531 | 5640846 | 2055737 | 378406 | 212861 | 18531 | 35704549
Swaption | 4082867 | 1696891 | 3036448 | 3756628 | 4648579 | 2305420 | 1059553 | 15402 | 20601788
OTHER* | 2346392 | 1032578 | 1376841 | 2095995 | 4776962 | 4117475 | 2409383 | 193979 | 18349605
TOTAL | 56786075 | 29439720 | 41660224 | 45949949 | 77524154 | 51147221 | 24970327 | 2283486 | 329761156
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 88e23cce-eff7-4aa5-8114-10290be2866e
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
ORCH | Test | ORCH | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
ORCH | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ORCH | Result | ORCH | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6195-2
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5307

5307 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  | 4 | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: 834900d1688139493-consolidate-a-range-based-on-four-columns-consolidation-2-
Sheet: Sheet1

From Jn | To Jn | Chainage | Chainage | Length | start | all starts | stop |  | sum for chain |  |  |  | A | B | 100 | 120
A | B | 100 | 110 | 10 |  |  |  |  |  |  | 0 | 1 | A | B | 122 | 180
A | B | 110 | 120 | 20 |  |  |  |  |  |  | 1 | 0 | B | D | 100 | 120
A | B | 122 | 140 | 20 |  |  |  |  |  |  | 0 | 1 | B | D | 124 | 180
A | B | 140 | 160 | 20 |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  | Solution without helpers
A | B | 160 | 180 | 20 |  |  |  |  |  |  | 1 | 0 |  | B | 100 | 120 | 30 |  |  | B | 100 | 120 | 30
B | D | 100 | 110 | 10 |  |  |  |  |  |  | 0 | 1 | A | B | 122 | 180 | 60 |  | A | B | 122 | 180 | 60
B | D | 110 | 120 | 20 |  |  |  |  |  |  | 1 | 0 | B | D | 100 | 120 | 30 |  | B | D | 100 | 120 | 30
B | D | 124 | 140 | 20 |  |  |  |  |  |  | 0 | 1 | C | D | 180 | 270 | 100 |  | B | D | 124 | 180 | 60
B | D | 140 | 160 | 20 |  |  |  |  |  |  | 0 | 0 | C | D | 280 | 300 | 110 |  | C | D | 180 | 270 | 100
B | D | 160 | 180 | 20 |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  | C | D | 280 | 300 | 110
C | D | 180 | 210 | 10 |  |  |  |  |  |  | 0 | 1
C | D | 210 | 240 | 20 |  |  |  |  |  |  | 0 | 0
C | D | 240 | 260 | 30 |  |  |  |  |  |  | 0 | 0
C | D | 260 | 270 | 40 |  |  |  |  |  |  | 1 | 0
C | D | 280 | 290 | 50 |  |  |  |  |  |  | 0 | 1
C | D | 290 | 300 | 60 |  |  |  |  |  |  | 1 | 0
Spreadsheet: 178202d1346698337-count-the-number-of-items-in-a-column-that-are-equal-to-another-columns-s-in-same-row-sample-excel-sheet
Sheet: Sheet2

 |  |  |  | Adjusted Rent Roll
 |  |  |  | For Month of August
 |  |  | Adjusted | Adjustment | Rent Amount Billed | Rent |  | Adjuested Rent Charge
 | Unit No | Member / Tenant 1 | By | Date |  | Adjustment
Company Name
Avenue5-88 | 201 |  |  | 2012-08-01 00:00:00 | 540 | -150 | 465
CreswoldRd-47 | 203 |  |  | 2012-08-02 00:00:00 | 139 | -139 | 0
somethingbuilding | 301 |  |  | 2012-08-02 00:00:00 | 139 | -139 | 0
Juniper-68 | 101 |  |  | 2012-08-22 00:00:00 | 718 | -507 | 211
Bloor-780 | 102 |  |  | 2012-07-30 00:00:00 | 835 | -429 | 406
Bloor-780 | 307 |  |  | 2012-07-30 00:00:00 | 145 | -145 | 0
Bloor-780 | 409 |  |  | 2012-07-31 00:00:00 | 182 | 21 | 203
Spreadsheet: 115197d1310791586-automatted-football-tipping-tonys-football-tipping-copy
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] in R4:R18 concatenates all other like [NAME]'s names into a comma-separated list.
 |  |  | Single-value array formulas in D4:Q18 return the names of other tippers with the same tips
Spreadsheet: 769358d1645497101-manufacturing-schedules-copy-of-example
Sheet: TimeShift

 |  |  |  |  |  | Time start | Active Hour | After 1 hour |  |  |  | PrvHrSum | EndHrSum
 |  |  |  |  | Mon | 09:00:00 | 1
 |  |  |  |  | Mon |  | 1
 |  |  |  |  | Mon |  | 1
 |  |  |  |  | Mon |  | 0
 |  |  |  |  | Mon |  | 1
 |  |  |  |  | Mon |  | 1
 |  |  |  |  | Mon |  | 1
 |  |  |  |  | Mon |  | 1
 |  |  |  |  | Mon |  | 1
 |  |  |  |  | Mon |  | 0
 |  |  |  |  | Mon |  | 0
 |  |  |  |  | Mon |  | 0
 |  |  |  |  | Mon |  | 0
 |  |  |  |  | Mon |  | 0
 |  |  |  |  | Mon |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 1
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Tue |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 1
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Wed |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 1
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Thu |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 1
 |  |  |  |  | Fri |  | 1
 |  |  |  |  | Fri |  | 1
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 1
 |  |  |  |  | Fri |  | 1
 |  |  |  |  | Fri |  | 1
 |  |  |  |  | Fri |  | 1
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0
 |  |  |  |  | Fri |  | 0