tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32d3e60f-ff28-44c0-9cba-43a48101e070
Sheet: Sheet1

 | MODE OF TRANSPORTATION
Classroom # | Car/Bus | Walk | Bike/Scooter
1 |  |  |  |  | 1st Grade Totals
2 |  |  |  |  | Car | Walk | Bike
3
4 |  |  |  |  | % Walk/Bike
5
6
7 |  |  |  |  | 2nd Grade Totals
8 |  |  |  |  | Car | Walk | Bike
9
10 |  |  |  |  | % Walk/Bike
11
12
13
14 |  |  |  |  | 3rd Grade Totals
15 |  |  |  |  | Car | Walk | Bike
16
17 |  |  |  |  | % Walk/Bike
18
19
20
21
22 |  |  |  |  | 4th Grade Totals
23 |  |  |  |  | Car | Walk | Bike
24
25 |  |  |  |  | % Walk/Bike
26
27 |  |  |  |  | 5th Grade Totals
28 |  |  |  |  | Car | Walk | Bike
29
30 |  |  |  |  | % Walk/Bike
31 |  |  |  |  | [NAME]
32 |  |  |  |  | Car | Walk | Bike
33
34 |  |  |  |  | % Walk/Bike
35
36
School Name: | CAR | WALK | BIKE
TOTALS
TOTAL SURVEYED
OVERALL % WALK/BIKE
Spreadsheet: 698324d1601922306-connecting-hr-info-diff-tabs-if-criteria-etc-sample-sheet
Sheet: 501

2020-09-01 00:00:00
IT Division
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | POSITION |  |  |  |  | Auth | MMA | BBR | Rest | BCP | LDC | BCP | Auto |  | Filled | Blanket
NAME |  | NUMBER | CLASSIFICATION | CBID | VACATED | COMMENTS | Pos | Part D | 08/09 | 08/09 | 10/11 | 12/13 | 19/20 | Pos |  | Pos | Pos
[NAME] | C | [PHONE]-910 | Office Technician | E99 |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  | 1
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 1
 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 0
 |  |  |  |  |  |  | 1 |  |  |  |  |  |  | 1 |  | 1
 |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 0
Spreadsheet: 160728d1339175072-assigning-categories-based-on-a-time-stamp-timecategories
Sheet: Cats

00:00:01 | 10 |  |  |  | Alternative category labelling…
 |  |  |  |  | This formula copies as far as you need it--->
 |  |  |  |  | (can use this in column B instead of simple calc)
Spreadsheet: dana_davis__4469__stock options
Sheet: Options

 | Stock Options
 | Market Price | 82.5 | 82.5
 | Option Price | 19.06 | 55.5
 | Gain/(Loss)
 | Fed Tax (28%)
 | Soc Sec (6.2%)
 | Medicare (1.45%)
 | [NAME] (.06/sh) | -0.06 | -0.06
 | Cash/Share
 | Vested Options | 770 | 13
 | Cash Earned
Spreadsheet: 218866d1362596329-search-in-sheet-1-and-return-to-sheet-2-using-lookup-find-and-match
Sheet: Blad2

 |  |  |  |  |  |  | http://www.excelforum.com/excel-formulas-and-functions/904811-search-in-sheet-1-and-return-to-sheet-2-using-lookup.html
 |  |  |  |  |  | Example: if SAN is typed in B3, it should return the values from the same row in column A (in sheet 1)
 | AB |  |  |  |  | SAN
10 | Text 6 |  |  |  | 10 | Text 3
11 | Text 8 |  |  |  | 11 | Text 2
12 | Text 4 |  |  |  | 12 | Text 3
13 | Text 6 |  |  |  | 13 | Text 12
 | Note that AN will give hits for SAN since it's searching for a string within a string.
Spreadsheet: 800510d1665691095-how-to-group-values-together-where-each-group-is-or-a-specific-total-grouped-runs
Sheet: Sheet1

RUN# | RUN WATTAGE | Group Wattage | Group
 | A |  | 0
1 | 24
2 | 64
3 | 40
4 | 72
5 | 57
6 | 20
7 | 16
8 | 38
9 | 52
10 | 74
11 | 27
12 | 10
13 | 16
14 | 44
15 | 50
16 | 32.5
17 | 55.5
18 | 18
19 | 17.5
20 | 41.1
21 | 35
22 | 20.5
23 | 77
Spreadsheet: 44722d1243492958-getting-duplicated-values-depending-on-rank-order-book1
Sheet: Sheet1

name | values | rank |  | small | values?? | should be |  | example 2 |  | example 3
gfd | 92 | 22 |  | 1 |  | vdfs |  | 1 | a | 1 | a
hg | 105 | 35 |  | 2 |  | s |  | 2 | b | 2 | b
ds | 75 | 3 |  | 3 |  | ds |  | 3 | c | 3 | c
s | 74 | 2 |  | 4 |  | gftr |  | 4 | d | 3 | d
gftr | 81 | 4 |  | 4 |  | ghdf |  | 5 | e | 3 | e
b | 89 | 13 |  | 6 |  |  |  | 6 |  | 3 | f
sfd | 94 | 25 |  | 7 |  |  |  | 6 |  | 3 | g
gbfd | 101 | 31 |  | 7 |  |  |  | 6 |  | 3 | h
fds | 88 | 11 |  | 9 |  |  |  | 6 |  | 3 | i
re | 84 | 9 |  | 10 |  |  |  | 6 |  | 3 | j
fds | 101 | 31 |  | 11 |  |  |  | 6 |  | 3 | k
ghdf | 89 | 13 |  | 11 |  |  |  | 6 |  | 12
fsd | 83 | 7 |  | 13 |  |  |  | 6 |  | 13
vdfs | 73 | 1 |  | 13 |  |  |  | 6 |  | 14
gf | 88 | 11 |  | 13 |  |  |  | 6 |  | 14
fds | 90 | 17 |  | 13 |  |  |  | 6 |  | 14
fds | 89 | 13 |  | 17 |  |  |  | 6 |  | 14
sfd | 107 | 36 |  | 17 |  |  |  | 6 |  | 14
s | 83 | 7 |  | 17 |  |  |  | 6 |  | 14
gfd | 89 | 13 |  | 17 |  |  |  | 6
hg | 90 | 17 |  | 21 |  |  |  | …
ds | 98 | 29 |  | 22
s | 95 | 26 |  | 22 |  |  |  | brings back first 5 |  | bring back first n, while small is <=5
gftr | 97 | 28 |  | 24
b | 95 | 26 |  | 25
sfd | 82 | 6 |  | 26
gbfd | 90 | 17 |  | 26
fds | 92 | 22 |  | 28
re | 93 | 24 |  | 29
fds | 90 | 17 |  | 29
ghdf | 81 | 4 |  | 31
fsd | 116 | 39 |  | 31
vdfs | 87 | 10 |  | 33
gf | 111 | 37 |  | 34
fds | 91 | 21 |  | 35
fds | 104 | 34 |  | 36
sfd | 102 | 33 |  | 37
s | 98 | 29 |  | 38
gfd | 113 | 38 |  | 39
Spreadsheet: 156872d1337533626-excel-2007-function-to-enter-data-in-2-columns-and-get-data-in-3rd-column-automatically-datasheet
Sheet: Sheet1

[NAME] | Year | Value
Corel Draw | 1993 | 7000
Ace | 1995 | 5400
Office | 1997 | 9000
Tally | 1998 | 8000
Pagemaker | 1999 | 5600
Tally | 1999 | 10000
Office | 2003 | 6700
Office | 2007 | 9000
Fact | 2007 | 9000
Ace | 2007 | 7800
Tally | 2008 | 10000
 | Below are the blank fields of the above database:
[NAME] | Year | Value
Enter a suitable function in the first cell of the Value field(i.e.cell C18) so that if any one enters the [NAME] name and the Year, the respective Value will be automatically shown
Spreadsheet: 163567d1340368609-excel-2007-creating-a-time-table-from-8-to-8-exampletimesheet
Sheet: May31st

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
In | 09:30:00 | 09:30:00 | 09:45:00 | 10:25:00 | 11:45:00 | 12:13:00 | 12:25:00 | 13:25:00 | 13:40:00 | 14:10:00 | 14:20:00 | 14:50:00 | 15:20:00 | 15:25:00 | 15:40:00 | 16:00:00 | 16:45:00 | 17:25:00 | 18:45:00 | 21:40:00 | 23:45:00
Out | 10:25:00 | 10:50:00 | 11:30:00 | 11:10:00 | 13:10:00 | 12:55:00 | 15:15:00 | 16:05:00 | 14:10:00 | 17:55:00 | 16:00:00 | 15:30:00 | 18:30:00 | 19:00:00 | 17:20:00 | 16:35:00 | 17:14:00 | 19:00:00 | 19:30:00 | 00:30:00 | 01:10:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
1900-01-01 00:00:00
1900-01-01 01:00:00
1900-01-01 02:00:00
1900-01-01 03:00:00
1900-01-01 04:00:00
1900-01-01 05:00:00
1900-01-01 06:00:00
1900-01-01 07:00:00
1900-01-01 08:00:00
Spreadsheet: 726507d1617280851-generating-a-unique-code-for-productnames-test-unique-id
Sheet: Blad1

WERKDAG | MERK | Werk + Merk | Uniek ID
2021-06-16 | E06B | 3639-E06B
2021-06-15 | E06B | 3639-E06B
2021-04-23 | E06B | 3639-E06B
2021-04-22 | E06B | 3639-E06B
Spreadsheet: 691050d1597427274-excel-ranking-and-sorting-the-data-in-alphabetical-order-and-multiply-conditions-2020-08-14-oeldere-koniuuk-691045d1597426418-excel-ranking-and-sorting-the-data-in-alphabetic
Sheet: Sheet1

Store | Unique ID | Criteria | Ranking
A | 1 | Yes
A | 2 | Yes
C | 262 | Yes
C | 263 | Yes
C | 265 | Yes
F | 151 | Yes
F | 152 | Yes
F | 153 | Yes
A | 3 | No
C | 260 | No
C | 261 | No
C | 264 | No
F | 150 | No
Notes:
* Ranking to be done in alphabetical order for the Store Name then Unique ID number but only if criteria is met (cell in column C)
So at the end of it I should have data showing as per following:
Store | Unique ID | Criteria | Ranking
A | 1 | Yes | 1
A | 2 | Yes | 2
A | 3 | No | --
F | 150 | No | --
F | 151 | Yes | 6
F | 152 | Yes | 7
F | 153 | Yes | 8
C | 260 | No | --
C | 261 | No | --
C | 262 | Yes | 3
C | 263 | Yes | 4
C | 264 | No | --
C | 265 | Yes | 5
Spreadsheet: 808056d1670260113-copying-information-from-1-sheet-to-another-sheet-book1
Sheet: Sheet2

Value
Recipient 1a
Recipient 1b
Recipient 1c
Recipient 1d
Recipient 1e
Recipient 2a
Recipient 2b
Recipient 2c
Recipient 2d
Recipient 2e
Recipient 3a
Recipient 3b
Recipient 3c
Recipient 3d
Recipient 3e
Recipient 4a
Recipient 4b
Recipient 4c
Recipient 4d
Recipient 4e
Recipient 5a
Recipient 5b
Recipient 5c
Recipient 5d
Recipient 5e
Spreadsheet: eric_saibi__9928__102901R
Sheet: Welsh 01

Owner Name |  | AEP - Southwestern Electric Power Company
Station Name |  | Welsh Power Company
Unit Name |  | Welsh 01
NERC Region |  | SPP
State |  | TX
Fuel Type |  | Coal
Capacity |  | 558 MW
Start Date |  | 2001-09-28 00:00:00
End Date |  | 2001-11-11 00:00:00
Prv. Start Date |  | 2001-10-29 00:00:00
Prv. End Date |  | 2001-12-12 00:00:00
Comments |  | Turbine / Generator Overhaul
SIC |  | 4911
Plant ID |  | 1014966
Unit ID |  | 1004320
Outage ID |  | 14432
Spreadsheet: monika_causholli__28143__Domestic Pulp Accounts
Sheet: Longs

Stuctured | Sales  & |  |  | Commodity
Origination | Marketing | Company | Description | NBSK | SBSK | NBHK | SBHK | BHKP | UBKP | DIP | BEK | BCTMP | Cotton | Fluff | Dissolving | Synthetic | Sawdust | Wetlap | Speciality | Total
 | GB | Abitibi Consolidated | Newsprint | -290000
 | DR | [NAME] | Paper & Wood Products
CS | GB | Bowater | Newsprint, UCFS, Pulp, Forest Products | -1300000
JB/CS | GB | [NAME] | Consumer Products, [NAME] |  |  |  |  |  |  |  |  |  |  | -400000
FB | GB | Canfor | Forest Products | -1100000
JB/CS | GB | Domtar | Specialty Papers & Lumber | -250000
 | GB | Fraser Paper (Nexfor) | Writing, Printing & Specialty Papers |  |  | -225000
CS | GB | Georgia Pacific | Forest Products |  | -490000
 | GB | Great Lakes Pulp & Fibre |  |  |  |  |  |  |  | -350000
CS | GB | Gulf States Paper | Forest Products |  | -80000
 | GB | International Paper | Forest Products | -490000 | -300000 | -250000 |  |  |  |  |  |  |  | -350000
FB/GD | DR | Millar Western Forest Products | BCTMP Producer |  |  |  |  |  |  |  |  | -300000
FB | GB | Parsons & Whittermore |  |  | -400000 | -200000 | -400000
FB | DR | Pope & Talbot | Forest Products | -500000 |  |  |  |  |  |  |  |  |  |  |  |  | -250000
JB/CS | GB | Rayonier | Lumber |  |  |  |  |  |  |  |  |  |  | -380000 | -250000
FB | GB | Sappi | Coated and Specialty Papers; Pulp |  |  | -250000
CS | GB | Simpson Paper | Lumber & Packaging |  |  |  |  |  | -120000
JB/CS | DR | Slocan Forest Products | CTMP & Lumber Producer |  |  |  |  |  |  |  |  | -300000
DC | GB | Smurfit Stone Container | Containerboard |  |  | -225000 | -225000
JB | GB | Tembec | Forest Products
 | GB | UPM-Kymmene | Forest Products
FB | DR | West Fraser Timber | Timber, Newsprint, Paper |  |  |  |  |  |  |  |  | -350000
FB | DR | Western Pulp Ltd Partnership / Doman | Packaging and Nursery Products | -250000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -150000
DC | GB | Westvaco | Containerboard |  | -25000 |  | -25000
 |  | Total
Spreadsheet: 728412d1618435668-ntn-non-blank-value-non-blank-in-range
Sheet: Data

33 | 2 | 3 | 4 | 5 | 644 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 2 | 17 | 250 | 19
15 | 210 | 12 | 4 | 8 | 14 | 2 | 8 | 9 | 10 | 2 | 12 | 13 | 14 | 5 | 4 | 3 | 125 | 19
 | 3 |  |  |  | 12 |  |  | 2 |  |  |  | 20 |  |  |  |  | 17
Spreadsheet: 838082d1690700370-vba-get-number-of-days-of-hijri-month-in-a-gregorian-month-based-on-input-gregorian-year-arabiccal
Sheet: lookup

 | 01 | Muharram
 | 02 | Safar
 | 03 | Rabi І
 | 04 | Rabi ІІ
 | 05 | [NAME] I
 | 06 | [NAME]
 | 07 | Rajab
 | 08 | Shaban
 | 09 | Ramadan
 | 10 | Shawwal
 | 11 | [NAME]
 | 12 | [NAME]
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 13305 | 1998 | -4206
2 | 1426 | 1998 | -1924
3 | 2 | 1333
4 | 585 |  | -861
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 183895.58
2002-01-05 00:00:00
CBS Volume
 |  |  | -353272
Spreadsheet: 817402d1676204385-display-the-average-of-the-previous-10-games-dynamically-bostoncelticsplayers
Sheet: Last10Avgs

 | Name | MP | FG | FGA | FG% | 3P | 3PA | 3P% | FT | FTA | ORB | DRB | TRB | AST | STL | BLK | TOV | PF | PTS | GMSC | PM
Spreadsheet: 3f43602a-82ad-4cf8-a814-6b3388cdddda
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
IVD | Test | IVD | Isovaleryl-CoA Dehydrogenase (IVD) Mutation Analysis (A282V) | IVD Mutation Analysis (A282V) | Polymerase Chain Reaction (PCR)-based assay (restriction enzyme digest) is used to detect the A282V mutation within exon 9 of the IVD gene. (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL	 Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Biochemical Disorders Patient Information Sheet (Supply T527) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday; 2 p.m. | 5 days | 10 days | 1 | 81400 |  |  |  |  | Rochester
IVD | [NAME] | VARIES | Varies |  |  |  | Ambient
IVD | Result | 22624 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
IVD | Result | 22625 | [NAME] | [NAME] | Alphanumeric
IVD | Result | 22626 | Source | Source | Alphanumeric
IVD | Result | 22627 | Order Date | Order Date | Alphanumeric
IVD | Result | 22628 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
IVD | Result | 22629 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
IVD | Result | 22630 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
IVD | Result | 22631 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
IVD | Result | 22632 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
IVD | Result | 22633 | Reviewed By: | Reviewed By: | Alphanumeric
IVD | Result | 22634 | Release Date | Release Date | Alphanumeric
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Ameed

 |  | Total Revenue
 |  | Anesthesia | 0
 |  | Dental Lab
 |  | Net Revenue
 |  | Dr. Percentage 50%
 |  | Total Lab | 0
 |  | Lab Cost | 0
 |  | Net Lab
 |  | Dr. Percentage 10%
 |  | Net Payment
 |  | Salary | 0
 |  | Monthly Housing Allowance | 0
 |  | Net To Pay
 |  |  | Doctor [NAME] ……………
Spreadsheet: 39885d1238143997-looking-up-a-range-of-cells-with-criterias-attached-forum-example-answer
Sheet: Handlers

Agent | Band | Rate | Value
[NAME] | Euro | 0.56 | 0.55
[NAME] | IRL NB | 0.2 | 1 |  |  | Band & Rate can vary from day to day.
[NAME] | All-In-One | 0.25 | 1
[NAME] | IRL NB | 0.27 | 0.26
Zak | PEN | 0.12 | 0
Spreadsheet: mark_taylor__25018__Allocations Version 2
Sheet: MD

UNIT | 2003-2005 ALLOCATION
Allegany County
Westvaco
Unit 24 | 500
Unit 25 | 440
Unit 26 | 7
Warrior Run (AES) | 378
[NAME]
BGE Wagner
Unit 1 | 74
Unit 2 | 367
Unit 3 | 669
Unit 4 | 156
BGE [NAME]
Unit 1 | 1850
Unit 2 | 1819
Baltimore City
[NAME]
CT5 | 21
BGE Gould Street
Unit 3 | 50
Baltimore County
BGE Riverside
Unit 4 | 26
CT6 | 9
BGE Crane
Unit 1 | 461
Unit 2 | 435
Charles County
PEPCO Morgantown
Unit 1 | 1231
Unit 2 | 1316
CT3 | 11
CT4 | 13
CT5 | 13
CT6 | 12
Dorchester County
[NAME]
Unit 8 | 129
Harford County
BGE Perryman
CT1 | 7
CT2 | 7
CT3 | 5
CT4 | 7
CT51 | 312
Montgomery County
[NAME]
Unit 1 | 452
Unit 2 | 441
Unit 3 | 461
Station H-GT2 | 77
Station H-GT3 | 89
Prince George's County
PEPCO Chalk Point
Unit 1 | 793
Unit 2 | 818
Unit 3 | 339
Unit 4 | 408
CT2 | 1
CT3 | 32
CT4 | 32
CT5 | 54
CT6 | 31
SGT1 | 43
[NAME] | 218
Washington County
[NAME]
Unit 9 | 7
Unit 11 | 119
Total Allocations
Spreadsheet: 419eaedb-a67f-47c7-8583-832d50d2ec4f
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
VZM | Test | VZM | Varicella-Zoster Virus (VZV) Antibody, IgM, Serum | Varicella-Zoster Ab, IgM, S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative (reported as positive or negative) | Monday through Friday; 9 a.m. and 3 p.m., Saturday, Sunday; Varies | Same day/1 day | 2 days | 1 | 86787 |  |  |  |  | Rochester
VZM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
VZM | Result | 80964 | Varicella-Zoster Ab, IgM, S | Varicella-Zoster Ab, IgM, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43588-3
Spreadsheet: 90675d1290455392-dynamic-sum-dynamic-sales-sum-calculation-marwan
Sheet: Sheet1

Inventory Qty
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
0 | 2 | 0 | 0 | 0 | 0
Sales
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
5 | 1 | 5 | 1 | 5 | 1
Because Tuesday was the last inventory qty, I need to sum sales of Wednesday to Saturday for a calculation I need for Sunday
Spreadsheet: 233688d1367897501-extract-rows-to-another-sheet-based-on-specific-words-auto-updates-extracting-data-to-another-worksheet
Sheet: filtered data

Data as I would like to see it |  |  |  |  | Data as I would like to see it |  |  |  |  | Data as I would like to see it
Date | Payee | Memo | Amount |  | Date | Payee | Memo | Amount |  | Date | Payee | Memo | Amount
2013-04-02 00:00:00 | TELECOM |  | -173.95 |  | 2013-04-21 00:00:00 | LOAN - INTEREST | Loan 1 | -715.07 |  | 2013-04-22 00:00:00 | PAYMENT |  | -47.19
2013-04-21 00:00:00 | TELECOM |  | -101.47 |  | 2013-04-21 00:00:00 | LOAN - INTEREST | Loan 1 | -77.28 |  | 2013-04-29 00:00:00 | PAYMENT |  | -2
2013-04-26 00:00:00 | TELECOM |  | -30
Criteria range used for advanced filter
Payee | Payee | Memo | Payee
TELECOM | LOAN - INTEREST | Loan 1 | PAYMENT
Spreadsheet: 782004d1653679883-sumproduct-error-using-2-arrays-sample-sumproduct
Sheet: Sheet1

name | area
red | 1
yellow | 2
blue | 3
yellow | 4 |  |  |  | Sum of | $ [NAME] | Total cost
blue | 5 |  |  |  | yellow
black | 6
red | 1
green | 2
red | 3
Spreadsheet: 08245b36-6a3e-401a-8737-ad79de26e2f9
Sheet: Sheet1

Name | dba | Address | City | State | Zip | Phone | License # | Expiration Date
[NAME], Incorporated |  | 500 South Centre Street | Pottsville | PA | 17901 | (570) 628-4423 | M-00028 | 2012-10-28 00:00:00
Technik MFG., Inc. |  | 1005 17th Street | Columbus | NE | 68601 | (402) 564-3191 | M-00027 | 2012-11-16 00:00:00
US Coin Boards LLC |  | 5060 Ritter Rd 3A | Mechanicsburg | PA | 17055 | (717) 795-1936 | M-00029 | 2012-12-16 00:00:00
Muncie Novelty Co., Inc. | MN Spectrum | [NAME] 823 | Muncie | IN | 47303 | (765) 288-8301 | M-00005 | 2012-12-20 00:00:00
Tabco, Inc. | Tabco USA | 417 Lakeshore Road | St. Catharines, Ontario | Canada | [NAME] | (800) 263-5064 | M-00024 | 2012-12-21 00:00:00
Universal Manufacturing Company |  | 5450 Deramus | Kansas City | MO | 64120 | (816) 231-2771 | M-00017 | 2012-12-31 00:00:00
GameTech International, Inc. |  | 8850 Double Diamond Pkwy | Reno | NV | 89521 | (775) 850-6000 | [NAME] | 2013-04-05 00:00:00
Atlantic Gaming, Inc. |  | 7 Panther Place PO Box 188 | Mount Pearl, NL | Canada | AIN2C2 | (800) 350-9940 | M-00018 | 2013-07-06 00:00:00
Applied Concepts, Inc. |  | 36445 Biltmore Place, Suite E | Willoughby | OH | 44094 | (440) 283-0388 | M-00002 | 2013-08-29 00:00:00
800743  Alberta LTD | The Bingo Paper Company | 417 Lakeshore Road | St.Catharines, ON | Canada | [NAME] | (800) 268-6216 | [NAME] | 2013-09-02 00:00:00
Electronic Game Solutions, Inc. |  | 149 [NAME]. 105 | Maryland Heights | MO | 63043 | (314) 692-2600 | M-00006 | 2013-09-02 00:00:00
[NAME] | Coins Unlimited | 1 Souder Court, Ste. A | Mechanicsburg | PA | 17050 | (717) 791-9513 | M-00004 | 2013-09-03 00:00:00
Bonanza Press, Inc. |  | 19860 141St Pl. N.E. | [NAME] | WA | 98072 | (425) 486-3399 | M-00001 | 2013-09-03 00:00:00
Pollard Games | American Games | 504 34th Avenue | Council Bluffs | IA | 51501 | (712) 366-9553 | M-00009 | 2013-09-03 00:00:00
Lucky Games, Inc. |  | 2044 [NAME] | Chicago | IL | 60614 | (773) 549-9051 | M-00016 | 2013-09-04 00:00:00
Arrow International, Inc. | Capital Game Mfg. Co. | 9900 Clinton Road | Brooklyn | OH | 44144 | (216) 961-3500 | [NAME] | 2013-09-09 00:00:00
[NAME], Inc. |  | 2810 Madison Street | [NAME] | IL | 60104 | (708) 547-8400 | M-00012 | 2013-09-15 00:00:00
VKGS, LLC | Video King Gaming & Power Bingo & Melange Computer Services | 2717 North 118th Circle, Suite 210 | Omaha | NE | 68164 | (800) 635-9912 | [NAME] | 2013-09-23 00:00:00
Paramount Games, Inc. |  | [NAME], 30 Mill St. | Wheatland | PA | 16161 | (724) 346-1671 | M-00011 | 2013-10-02 00:00:00
Columbia Sales, Inc. |  | 2233 Warwood Ave | Wheeling | WV | 26003 | (304) 277-2233 | M-00008 | 2013-10-03 00:00:00
LIF Capital Group LLC |  | 1975 Adams Ave. | [NAME] | CA | 94577 | (510) 562-8900 | M-00021 | 2013-10-20 00:00:00
International Gamco,  Inc. | Gametec | 9335 N. 48th Street | Omaha | NE | 68152 | (402) 571-2449 | M-00007 | 2013-10-30 00:00:00
Spreadsheet: 67060d1267703157-how-to-retrieve-values-from-an-excel-table-spare-parts
Sheet: Spare Parts

Helper | vehicle | Spare | Specification | price
Column
CarTyre30' | Car | Tyre | 30' | 10 |  |  |  |  | Car | Tyre | Seat
CarTyre32' | Car | Tyre | 32' | 12 |  |  |  |  | Jeep | 30' | Normal
CarTyre34' | Car | Tyre | 34' | 12 |  |  |  |  |  | 32' | Leather
 |  |  |  |  |  |  |  |  |  | 34'
JeepSeatNormal | Jeep | Seat | Normal | 20
JeepSeatLeather | Jeep | Seat | Leather | 25
Spreadsheet: 846838d1697989059-compare-two-arrays-and-sum-matches-compare-two-arrays-and-sum-matches
Sheet: Hárok1

Array 1 | 4 | 9 | 12 | 17 | 29 | 30 | 31
[NAME] | 1 | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27 | 29 | 31 | 33 | 35 | 37 | 39 | 41 | 43 | 45 | 47 | 49 | 51 | 53 | 55 | 57 | 59
Count of matching numbers: |  |  | < -- This formula is ok, it works. Four numbers are the same in both arrays (9,17,29,31 – four numbers)
Sum of matching numbers: |  |  | < -- Here I need a formula that calculates the sum of matching numbers with the result 86 (9+17+29+31=86)
Spreadsheet: 8de63791-58b3-4c3b-9d29-235e378b2e73
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260975 | 51219 | Rodrigo | Feola | BRA | 1 | 00:13:06 | 00:01:13 | 00:31:55 | 00:00:47 | 00:20:40 | 1 | 01:07:43