tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9680ce43-b797-4337-bc78-8641b7675fc1
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
NIU | Test | NIU | Nickel, 24 Hour, [NAME] | Nickel, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	No 50% Acetic Acid	Yes Na2CO3	No Toluene	No 6N HNO3	Yes Boric Acid	No Thymol	No | 0.9 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-6.0 mcg/specimen  Reference values apply to all ages. | Thursday; 5 p.m. | 1 day | 7 days | 1 | 83885 |  |  |  |  | Rochester
NIU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
NIU | Order Question | TM18 | Collection Duration |  | Plain Text
NIU | Order Question | VL30 | [NAME] |  | Plain Text
NIU | Result | 8626 | Nickel, 24 Hr, U | Nickel, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 5705-9 | Nickel:MRat:24H:[NAME]:Qn:
NIU | Result | TM18 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
NIU | Result | VL30 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
NIU | Result | 868 | Ni Concentration | Ni Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 29936-2 | Nickel:MCnc:24H:[NAME]:Qn:
Spreadsheet: 832423d1686320965-count-if-consecutive-values-are-true-skipping-blanks-formula
Sheet: Sheet1

 |  | VALUE | FORMULA |  |  |  |  |  | VALUE | FORMULA | Should Be | Why
 |  | False |  |  |  |  |  |  | False |  | False | column j is false
 |  | True |  |  |  |  |  |  | False |  | False | column j is false
 |  | False |  |  |  |  |  |  | True |  | False | column j is false
 |  | False
 |  | True |  |  |  |  |  |  | True |  | False | column j is false
 |  | True |  |  |  |  |  |  | True |  | True | column j is true
 |  | True |  |  |  |  |  |  | True |  | False | column j is false
 |  | True |  |  |  |  |  |  | True |  | True | column j is true
 |  | True
 |  | True |  |  |  |  |  |  | True |  | True | column j is true
 |  | True |  |  |  |  |  |  | False |  | True | 5 in a row were true
 |  | False
 |  | True |  |  |  |  |  |  | False |  | True | 5 in a row were true
 |  | True |  |  |  |  |  |  | False |  | True | 5 in a row were true
 |  | False |  |  |  |  |  |  | True |  | True | 5 in a row were true
 |  | True
 |  | True |  |  |  |  |  |  | False |  | True | 5 in a row were true
Spreadsheet: 820437d1678108550-i-need-help-for-formula-count-if-distinct-s666-pq-ronyn
Sheet: sheet

product_code | type
[PHONE] | 009 |  |  | Pivot |  |  |  | Power Query
[PHONE] | 000
[PHONE] | 000 |  |  | product_code | type | Count of type |  | product_code | type | Count
[PHONE] | 000 |  |  | [PHONE] | 000 | 1 |  | [PHONE] | 009 | 2
[PHONE] | 000 |  |  | [PHONE] | 000 | 1 |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  | [PHONE] | 000 | 1 |  | [PHONE] | 000 | 3
[PHONE] | 000 |  |  | [PHONE] | 000 | 1 |  | [PHONE] | 000 | 3
[PHONE] | 000 |  |  | [PHONE] | 000 | 4 |  | [PHONE] | 000 | 1
[PHONE] | 009 |  |  |  | 009 | 2 |  | [PHONE] | 000 | 1
[PHONE] | 009 |  |  | [PHONE] | 000 | 3 |  | [PHONE] | 009 | 2
[PHONE] | 000 |  |  | [PHONE] | 000 | 1 |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  | [PHONE] | 000 | 1 |  | [PHONE] | 000 | 1
[PHONE] | 010 |  |  | [PHONE] | 000 | 3 |  | [PHONE] | 010 | 2
[PHONE] | 009 |  |  |  | 009 | 2 |  | [PHONE] | 000 | 3
[PHONE] | 000 |  |  |  | 010 | 2 |  | [PHONE] | 000 | 4
[PHONE] | 000 |  |  | [PHONE] | 000 | 3 |  | [PHONE] | 000 | 1
[PHONE] | 000 |  |  | Grand Total |  | 25 |  | Total
[PHONE] | 000
[PHONE] | 000
[PHONE] | 000
[PHONE] | 010
[PHONE] | 000
[PHONE] | 000
[PHONE] | 000
[PHONE] | 000
Spreadsheet: 97838d1296936024-text-to-columns-example
Sheet: Sheet1

what it paste like
Smith, [NAME] 02/05/2011 08:34 AM 11111111 Successful with Sale   Residence   $50.00 $50.00  $2,500.00 $100.00 $50.00  CC101 Residence - 02/05/2011 - $50.00 - Successful with Sale
Wilson, [NAME] 08:44 AM 12121212 No Sale   Business   $5,500.00 $250.00 $125.00  CCTD201 Business - No Sale
Smith, [NAME] 02/05/2011 08:34 AM 33334444 Successful with Sale   Residence   $100.00  $4,500.00 $200.00 $100.00  AA45 Business - 02/05/2011 - $100.00 - Successful with Sale
what want to look like
Name | Date | Time | code | action | place | amount | [NAME] | balance | [NAME] | min | special code | outcome
Smith, [NAME] | 2011-02-05 00:00:00 | 8:34 AM | 11111111 | Successful with Sale | Residence | 50 | 50 | 2500 | 100 | 50 | CC101 | Residence - 02/05/2011 - $50.00 - Successful with Sale
Wilson, [NAME] | 2011-02-05 00:00:00 | 08:44:00 | 12121212 | No Sale | Business |  |  | 5500 | 250 | 125 | CCTD201 | Business - No Sale
Smith, [NAME] | 2011-02-05 00:00:00 | 08:54:00 | 33334444 | Successful with Sale | Business | 100 |  | 4500 | 200 | 100 | AA45 | Business - 02/05/2011 - $100.00 - Successful with Sale
Spreadsheet: 726575d1617299681-sumifs-issue-template
Sheet: SEPT

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-09-01 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 40
Spreadsheet: darrell_schoolcraft__7761__imbalsumm0106
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1
2
3
4
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-05-31 00:00:00 |  |  | 353361
2001-06-04 00:00:00
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 6 Math

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 6
Grade 6 Mathematics MTAS-III
Raw Score | Scale Score** | Level
0 | 140 | D
1 | 149 | D
2 | 155 | D
3 | 159 | D
4 | 162 | D
5 | 165 | D
6 | 169 | D
7 | 172 | D
8 | 177 | D
9 | 183 | D
10 | 188 | D
11 | 190 | P
12 | 194 | P
13 | 196 | P
14 | 197 | P
15 | 198 | P
16 | 200 | M
17 | 201 | M
18 | 202 | M
19 | 203 | M
20 | 205 | M
21 | 206 | M
22 | 208 | E
23 | 209 | E
24 | 211 | E
25 | 214 | E
26 | 218 | E
27 | 226 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 471155d1468898129-suppress-div-0-errors-rt-overview
Sheet: Overview

 | JAN | FEB | MAR | 1st QTR | APR | MAY | JUN | 2nd QTR | JUL | AUG | SEP | 3rd QTR | OCT | NOV | DEC | 4th QTR | YTD
RRT Statistics
Total RRT's Activated
Average Response Time to Arrival | 4
Total Response Time Fall-Outs (> 11 minute goal)
Total Responses Meeting 11 Minute [NAME]
% of Total Responses Meeting 11 Minute [NAME]
Average of Length of Event
Total Time of All Events
Patients with Multiple RRT Activations this Month
RRT’s within 12 hours of Admission/Transfer to Unit
Spreadsheet: b111088d-5e6e-4377-bdba-6fd058fec31a
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
43464308 | 2014-10-06 15:34:12 | ALLIES | 0 | 4 | 6 | 1644681 | player1644681 | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
43481770 | 2014-10-07 20:48:33 | AXIS | 1 | 5 | 3 | 225841 | sacas | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43482017 | 2014-10-07 21:04:53 | ALLIES | 0 | 4 | 5 | 225841 | sacas | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43482804 | 2014-10-07 22:32:07 | AXIS | 1 | 7 | 4 | 1600642 | ZZZED | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
43483544 | 2014-10-07 22:55:09 | ALLIES | 1 | 7 | 2 | 1600642 | ZZZED | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
43582543 | 2014-10-14 21:16:01 | AXIS | 1 | 5 | 2 | 23966 | Johnnyboyb | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43582738 | 2014-10-14 21:28:05 | ALLIES | 1 | 5 | 3 | 23966 | Johnnyboyb | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
43609964 | 2014-10-16 22:18:18 | AXIS | 1 | 5 | 4 | 799634 | lucky91 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43610222 | 2014-10-16 22:34:38 | ALLIES | 1 | 5 | 1 | 799634 | lucky91 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
Spreadsheet: 698862d1602206832-how-to-find-next-date-based-on-criteria-1-and-2-book1-3-
Sheet: Sheet1

Name | Start Date | end date
[NAME] | 2015-01-01 00:00:00 | 2017-03-31 00:00:00
Jones | 2010-02-17 00:00:00 | 2016-03-31 00:00:00
[NAME] | 2013-01-01 00:00:00 | 2018-05-01 00:00:00
Flower | 2013-02-04 00:00:00 | 2015-08-31 00:00:00
Jones | 2016-04-01 00:00:00 | 2019-09-01 00:00:00
[NAME] | 2017-04-01 00:00:00 | 2017-05-03 00:00:00
Flower | 2012-07-02 00:00:00 | 2013-02-03 00:00:00
[NAME] | 2017-05-04 00:00:00 | 2018-08-04 00:00:00
 | Earliest date | Next date
[NAME]
Spreadsheet: 775272d1648974791-position-fluctuate-pos-fluct
Sheet: Sheet1

 | R13
1 | 10–3 | 571 | Odongkara, [NAME] (A4) | 2W:396-362:A19
2 | 9–4 | 880 | [NAME], [NAME] (A2) | 1W:499-284:A21
3 | 9–4 | 541 | Magwanga, [NAME] (A13) | 1W:489-388:A3
4 | 9–4 | 338 | Njoroge, Stanley (A11) | 2W:362-351:A6
5 | 9–4 | 179 | Magu, Fred (A19) | 1L:362-396:A4
6 | 9–4 | -116 | Mboya, [NAME] (A21) | 2L:284-499:A2
7 | 8–5 | 652 | Okechi, Richard (A28) | 1W:417-396:A1
8 | 8–5 | 515 | Outi, Tobias (A3) | 2L:388-489:A13
9 | 8–5 | 357 | [NAME], [NAME] (A6) | 1L:351-362:A11
10 | 8–5 | 334 | Mutahi, Martins (A5) | 1W:475-464:A8
 | R14 |  |  |  |  | FLUCT
1 | 10–4 | 898 | [NAME], [NAME] (A2) | 2W:404-386:A4
2 | 10–4 | 553 | Odongkara, [NAME] (A4) | 1L:386-404:A2
3 | 10–4 | 416 | Njoroge, Stanley (A11) | 1W:472-394:A13
4 | 10–4 | 205 | Magu, Fred (A19) | 1W:488-462:A21
5 | 9–5 | 562 | Outi, Tobias (A3) | 1W:511-464:A28
6 | 9–5 | 463 | Magwanga, [NAME] (A13) | 2L:394-472:A11
7 | 9–5 | 395 | [NAME], [NAME] (A6) | 2W:457-419:A5
8 | 9–5 | -142 | Mboya, [NAME] (A21) | 2L:462-488:A19
9 | 8–6 | 618 | Oyende, [NAME] (A1) | 2W:460-414:A15
10 | 8–6 | 605 | Okechi, Richard (A28) | 2L:464-511:A3
Spreadsheet: 0c876c01-4d64-4ad0-8f8d-04beb9d4c712
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
JAK2M | Test | JAK2M | JAK2 V617F Mutation Detection, Bone Marrow | JAK2 V617F Mutation Detection, BM | Point Mutation Detection in DNA Using Quantitative Polymerase Chain Reaction (PCR) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Varies: Var |  |  | 2 | mL | [NAME] must arrive within 96 hours of collection.   Container/Tube: Preferred: Lavender top (EDTA) Acceptable: ACD [NAME]: 2 mL Collection Instructions: 1. Invert several times to mix bone marrow. 2. Send specimen in original tube. Forms:  1. Hematopathology Patient Information Sheet (Supply T676) in Special Instructions 2. If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; 12 p.m. | 2 days | 5 days | 1 | 81270 |  |  |  |  | Rochester
JAK2M | [NAME] | BNMARW | Bone Marrow |  |  |  | Ambient | 4 days
JAK2M | Result | 31157 | JAK2 V617F Mutation Detection, BM | JAK2 V617F Mutation Detection, BM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43399-5 | JAK2 gene.p.V617F:Arb:Pt:Bld/Tiss:[NAME]:Molgen
Spreadsheet: 776127d1649512594-dynamically-transpose-a-list-to-every-nth-cell-book3
Sheet: Data Entry

2022-04-08 02:00:44 | Orion | 6 | 8 | 2 | 2 | 1 | 4 | 4
2022-04-09 00:00:00 | Orion | 6 | 5 | 3 | 3 | 3 | 1 | 1
2022-04-10 00:00:00 | [NAME] | 6 | 7 | 4 | 4 | 4 | 2 | 3
2022-04-11 00:00:00 | Jake | 6 | 5 | 3 | 2 | 2 | 3 | 3
2022-04-12 00:00:00 | Jared | 6 | 5 | 4 | 4 | 1 | 2 | 4
2022-04-13 00:00:00 | Adam | 6 | 5 | 4 | 1 | 1 | 3 | 3
2022-04-14 00:00:00 | [NAME] | 6 | 9 | 4 | 4 | 3 | 3 | 2
2022-04-15 00:00:00 | Jake | 6 | 7 | 1 | 0 | 2 | 2 | 3
2022-04-16 00:00:00 | [NAME] | 6 | 5 | 3 | 5 | 4 | 4 | 3
2022-04-08 02:00:44 | Adam | 6 | 8 | 2 | 2 | 1 | 4 | 4
2022-04-09 00:00:00 | [NAME] | 6 | 5 | 3 | 3 | 3 | 1 | 1
2022-04-10 00:00:00 | Orion | 6 | 7 | 4 | 4 | 4 | 2 | 3
2022-04-11 00:00:00 | [NAME] | 6 | 5 | 3 | 2 | 2 | 3 | 3
2022-04-12 00:00:00 | Jake | 6 | 5 | 4 | 4 | 1 | 2 | 4
2022-04-13 00:00:00 | Jared | 6 | 5 | 4 | 1 | 1 | 3 | 3
2022-04-14 00:00:00 | Adam | 6 | 9 | 4 | 4 | 3 | 3 | 2
2022-04-15 00:00:00 | [NAME] | 6 | 7 | 1 | 0 | 2 | 2 | 3
2022-04-16 00:00:00 | Orion | 6 | 5 | 3 | 5 | 4 | 4 | 3
Spreadsheet: 101491d1299604962-index-and-match-function-for-last-month-figures-index-and-match-for-last-month-figures
Sheet: Sheet1

Actual | Actual | Actual |  |  |  |  |  |  |  |  |  | Last Month
Data |  |  |  |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00
Jan-11 | Feb-11 | Mar-11 | Apr-11 | May-11 | Jun-11 | Jul-11 | Aug-11 | Sep-11 | Oct-11 | Nov-11 | Dec-11
40241.21327084606 | 40069.28235109957 | 40938.315 | 41356.97866666666 | 41356.97866666666 | 41356.97866666666 | 41031.53633333333 | 41031.53633333333 | 41031.53633333333 | 36728.37299999999 | 36728.37299999999 | 36728.37299999999 | 40938.315
Spreadsheet: 108050d1305149862-auto-populating-excel-calendar-ts1019273743
Sheet: JUN

 | June 2011
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  | 1 |  | 2 |  | 3 |  | 4
 | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11
 | 12 |  | 13 |  | 14 | Flag Day | 15 |  | 16 |  | 17 |  | 18
 | 19 | Father's Day | 20 |  | 21 | First Day of Summer | 22 |  | 23 |  | 24 |  | 25
 | 26 |  | 27 |  | 28 |  | 29 |  | 30
Spreadsheet: 138041d1327498548-top-5-return-value-and-name-w-multiple-criteria-duplicate_jpr73
Sheet: Weekly Overview

 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
 |  |  |  |  |  |  | All | Home | Travel | Business
 |  |  |  |  |  | All | Helen | [NAME]
 | Chain | [NAME] |  |  |  | All | 2010-11 | 2011-12
 | Year | 2011-12 |  |  |  | All | Fix | Dont Fix
 | Type | Fix
 | MA | Business
 | Week | Cost | Spend
 | 31
 | Top 5 by Spend |  |  | Top 5 by Spend Cost <1500
 | 1 |  |  | 1
 | 2 |  |  | 2
 | 3 |  |  | 3
 | 4 |  |  | 4
 | 5 |  |  | 5
 | Year | 2011-12 |  |  | Year | 2011-12 |  |  | Top 5 return value and name w multiple criteria
 | Type | Fix |  |  | Type | Fix
 | MA | Business |  |  | MA | Business
 | Week | Account | Spend |  | Week | Account | Spend
 | 35 | [NAME] | 3153.92 |  | 30 | [NAME] | 1405.65
 | 36 | [NAME] | 2961.9 |  | 31 | [NAME] | 1390.41
 | 37 | [NAME] | 2226.29 |  | 32 | [NAME] | 1288.33
 | 33 | [NAME] | 1727.33 |  | 29 | [NAME] | 1171.94
 | 30 | [NAME] | 1405.65 |  | 34 | [NAME] | 735.3000000000001
Spreadsheet: 214225d1360850016-extract-values-from-one-column-based-on-criteria-from-another-column-formula-needed
Sheet: Sheet1

Vendor | Item | Item Type | Desc | Effective Date | Curr Repl Instock % |  |  |  |  |  |  |  | Instock Goal
Vendor A | 202255 | 33 | Product 1 | 01/26/2007 | 97.283531 |  |  |  |  |  |  |  | 98
Vendor A | 202247 | 33 | Product 2 | 01/26/2007 | 98.122867
Vendor A | 265279 | 33 | Product 3 | 09/26/2011 | 70.37037
Vendor A | 218881 | 33 | Product 4 | 09/26/2011 | 75.952381
Vendor A | 551002962 | 33 | Product 5 | 12/31/2012 | 79.539642
Vendor A | 265120 | 33 | Product 6 | 07/05/2010 | 88.66171
Vendor A | 218938 | 33 | Product 7 | 09/26/2011 | 88.888889
Vendor A | 218939 | 33 | Product 8 | 01/26/2007 | 98.469388
Vendor A | 218940 | 33 | Product 9 | 01/26/2007 | 98.809524
Vendor A | 218941 | 33 | Product 10 | 09/26/2011 | 75.211864
Vendor A | 218942 | 33 | Product 11 | 09/26/2011 | 86.873508
Vendor A | 218943 | 33 | Product 12 | 12/31/2013 | 83.418367
Vendor A | 218944 | 33 | Product 13 | 07/05/2011 | 88.66171
Vendor A | 218945 | 33 | Product 14 | 09/26/2012 | 88.888889
Spreadsheet: 745169d1629793788-partial-match-between-two-lists-with-names-partial-match-sample
Sheet: Sheet1

 | Need formula | Need formula | Need Formula |  | Lookup table
Account name | Partial Match | Account Name 2 | Account No. |  | Account name 2 | Account No.
[NAME] | Yes | [NAME] | 1 |  | [NAME] | 1
Academia LTD B.V | Yes | Academia LTD BV | 2 |  | Academia LTD BV | 2
Åkes Værksted Hellerup | Yes | Aakes Vaerksted Hellerup | 3 |  | Aakes Vaerksted Hellerup | 3
Yrsted Hansi | Yes | [NAME] | 4 |  | [NAME] | 4
Chocolate 123 | No |  |  |  | Yhanska 123 | 5
Tysale LTD | Yes | Tysale LTD | 6 |  | Kjalovo ABC | 7
 |  |  |  |  | Tysale LTD | 6
Spreadsheet: 0144f649-7a28-4bcf-a0bf-03172bc370e3
Sheet: Population

 | 1960 | 1961 | 1962 | 1963 | 1964 | 1965 | 1966 | 1967 | 1968 | 1969 | 1970 | 1971 | 1972 | 1973 | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
Population 20-24 years |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1921838 | 1939667 | 1979551 | 1998175 | 2006186 | 1999571 | 1994322 | 1960854 | 1937671 | 1918760 | 1902136 | 1871602 | 1859677 | 1831670 | 1800721 | 1779571 | 1824814 | 1851573 | 1900270 | 1958757 | 2001787 | 1992372 | 2004871 | 1977231 | 1928089 | 1864520 | 1760487 | 1675596 | 1642305 | 1589926 | 1586737
eng.stat.gov.tw/public/data/dgbas03/bs2/yearbook_eng/y011_I.pdf
Spreadsheet: 679366d1590351820-help-with-filter-subtotal-and-getting-nonadjacent-cell-data-book1
Sheet: Sheet2

SYMBOL | date | OPEN | HIGH | LOW | CLOSE | volume | con | TIMESTAMP |  |  | volume | con
AAA | 2020-05-28 00:00:00 | 17499.5 | 17899.95 | 17005.95 | 17216.1 | 1762440 | 384000 | 2020-05-22 00:00:00 |  | total
AAA | 2020-06-25 00:00:00 | 17531.05 | 17895 | 17022 | 17236.15 | 275560 | 99520 | 2020-05-22 00:00:00
BBB | 2020-07-30 00:00:00 | 17500 | 17935 | 17070 | 17284.5 | 23350 | 3625 | 2020-05-22 00:00:00 |  | [NAME]
CCC | 2020-05-28 00:00:00 | 9001.4 | 9123.6 | 8940 | 9027.8 | 7361100 | -150225 | 2020-05-22 00:00:00
DDD | 2020-06-25 00:00:00 | 9023.75 | 9124.25 | 8942.3 | 9026.55 | 2318400 | 322275 | 2020-05-22 00:00:00 |  | HIGH
BBB | 2020-07-30 00:00:00 | 9017.6 | 9116.2 | 8945 | 9033.85 | 299025 | 6750 | 2020-05-22 00:00:00
CCC | 2020-05-28 00:00:00 | 13550 | 13829 | 13550 | 13774 | 1550 | 0 | 2020-05-22 00:00:00
BBB | 2020-06-25 00:00:00 | 13745 | 13849 | 13744 | 13780 | 200 | 100 | 2020-05-22 00:00:00
AAA | 2020-05-28 00:00:00 | 1170.65 | 1232.45 | 1163.3 | 1226.7 | 1484400 | 7200 | 2020-05-22 00:00:00
Spreadsheet: 735273d1622806434-lookup-data-based-on-tab-cross-reference-example-4-
Sheet: 1

City | Population
Los Angeles | 3966936
San Diego | 1409573
San Jose | 1027690
San Francisco | 874961
Fresno | 525010
Sacramento | 500930
Long Beach | 466776
Oakland | 425097
Bakersfield | 377917
Anaheim | 349964
Santa Ana | 332794
Riverside | 326414
[NAME] | 309228
[NAME] | 273157
[NAME] | 268920
Fremont | 235740
San Bernardino | 216089
Santa Clarita | 213411
Modesto | 212616
Fontana | 210759
Spreadsheet: 3cb4e23b-f7f1-487d-aa38-bb356a948840
Sheet: Sheet1

Practice_Code | Cost_Share_Program | Practice_Name | Component | Unit_Type | Unit_Cost | Cost_Type | Share_Rate
340 | EQIP 2014 | Cover Crop | One or Two Species | Ac | 58.7 | PR | 100
340 | EQIP 2014 | Cover Crop | 3 or More Species | Ac | 81.81 | PR | 100
Spreadsheet: 220679d1363226904-displaying-or-filtering-data-based-on-a-drop-down-selection-sample-work-book
Sheet: Data Sheet 1

Company A |  |  | Company 1
ALL |  |  | ALL
Package a | Company 1 equivalent |  | Package 1 | Company A equivalent
product 1 | product g |  | product a | product 4
product 2 | product h |  | product b | product 5
product 3 | product i |  | product c | product 6
Package b |  |  | Package 2
product 4 | product a |  | product d | product 7
product 5 | product b |  | product e | product 8
product 6 | product c |  | product f | product 9
Package c |  |  | Package 3
product 7 | product d |  | product g | product 1
product 8 | product e |  | product h | product 2
product 9 | product f |  | product i | product 3
Spreadsheet: 39166457-7e1d-47e0-aa84-4ccf47839b6e
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Quelle: http://ergebnisse.vimentis.ch/
Frage:
[NAME] müssen gleich behandelt werden wie private [NAME] (sie erhalten keine [NAME] öffentlichen Hand und können [NAME] gehen).
 | Welcher Partei haben [NAME] bei der letzten <b>Nationalratswahl im [NAME] 2007</b> hauptsächlich [NAME] gegeben?
Antwort | CVP | EDU | EVP | FDP | Grüne | Liberale (LPS) | SD | SP | SVP | Andere | Weiss nicht | Grünliberale | nicht zur Wahl gegangen
[NAME] | 0.25 | 0.28 | 0.17 | 0.33 | 0.16 | 0.25 | 0.24 | 0.16 | 0.34 | 0.2 | 0.24 | 0.25 | 0.23
[NAME] | 0.67 | 0.55 | 0.71 | 0.58 | 0.73 | 0.64 | 0.6 | 0.77 | 0.53 | 0.73 | 0.6 | 0.65 | 0.64
Neutral / Weiss nicht | 0.09 | 0.17 | 0.12 | 0.09 | 0.11 | 0.1 | 0.16 | 0.07 | 0.13 | 0.07 | 0.16 | 0.1 | 0.13
Angaben zu den [NAME]
Erhebungsjahr | 2010
Stichprobengrösse | 29292
Erhebungszeitraum | 02.10.2010 bis: 06.12.2010
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.