tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1075582b-1b79-4852-bf96-3481f66e6c40
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Property | Protein | Mean | [NAME] | P-value | Property | Protein | Mean | [NAME] | P-value
 |  | Type |  |  |  |  | Type
 | WORM |  |  |  |  | HUMAN
 | RdisAA | HUBS | 0.372 | 0.1737 | 0.0019 | RdisAA | HUBS | 0.4281 | 0.1988 | 0.0036
 |  | ENDS | 0.3181 | 0.1987 |  |  | ENDS | 0.3754 | 0.1975
 | avgScore | HUBS | 0.3924 | 0.1403 | 0.0013 | avgScore | HUBS | 0.4373 | 0.1565 | 0.0044
 |  | ENDS | 0.3461 | 0.1641 |  |  | ENDS | 0.3961 | 0.158
 | RshortDR | HUBS | 0.0072 | 0.0039 | 0.908 | RshortDR | HUBS | 0.007 | 0.0044 | 0.0639
 |  | ENDS | 0.0072 | 0.0048 |  |  | ENDS | 0.0077 | 0.0051
 | RmedDR | HUBS | 0.0024 | 0.0024 | 0.0189 | RmedDR | HUBS | 0.0028 | 0.0029 | 0.2263
 |  | ENDS | 0.0019 | 0.0026 |  |  | ENDS | 0.0025 | 0.003
 | RlongDR | HUBS | 0.0012 | 0.0019 | 0.0116 | RlongDR | HUBS | 0.0016 | 0.0018 | 0.0022
 |  | ENDS | 0.0008 | 0.0016 |  |  | ENDS | 0.0011 | 0.0018
 | RallDR | HUBS | 0.0109 | 0.0042 | 0.0084 | RallDR | HUBS | 0.0114 | 0.005 | 0.8754
 |  | ENDS | 0.0099 | 0.0054 |  |  | ENDS | 0.0113 | 0.0052
 | RmaxDR | HUBS | 0.1404 | 0.1004 | 0.8468 | RmaxDR | HUBS | 0.1611 | 0.1062 | 0.9842
 |  | ENDS | 0.1386 | 0.1305 |  |  | ENDS | 0.1613 | 0.1334
 | FLY |  |  |  |  | YEAST
 | RdisAA | HUBS | 0.4242 | 0.1954 | <.0001 | RdisAA | HUBS | 0.3284 | 0.1605 | 0.0763
 |  | ENDS | 0.3279 | 0.1999 |  |  | ENDS | 0.3017 | 0.155
 | avgScore | HUBS | 0.437 | 0.1579 | <.0001 | avgScore | HUBS | 0.3582 | 0.1315 | 0.0368
 |  | ENDS | 0.3556 | 0.1642 |  |  | ENDS | 0.3326 | 0.126
 | RshortDR | HUBS | 0.0073 | 0.0049 | 0.0304 | RshortDR | HUBS | 0.0076 | 0.0046 | 0.8817
 |  | ENDS | 0.0069 | 0.0048 |  |  | ENDS | 0.0077 | 0.0043
 | RmedDR | HUBS | 0.0028 | 0.003 | <.0001 | RmedDR | HUBS | 0.002 | 0.0021 | 0.8251
 |  | ENDS | 0.0019 | 0.0027 |  |  | ENDS | 0.0019 | 0.0023
 | RlongDR | HUBS | 0.0014 | 0.0019 | <.0001 | RlongDR | HUBS | 0.0008 | 0.0015 | 0.1177
 |  | ENDS | 0.001 | 0.0017 |  |  | ENDS | 0.0006 | 0.0012
 | RallDR | HUBS | 0.0116 | 0.005 | <.0001 | RallDR | HUBS | 0.0105 | 0.0046 | 0.6495
 |  | ENDS | 0.0098 | 0.0053 |  |  | ENDS | 0.0102 | 0.0047
 | RmaxDR | HUBS | 0.1729 | 0.1307 | <.0001 | RmaxDR | HUBS | 0.1266 | 0.1035 | 0.1205
 |  | ENDS | 0.137 | 0.1264 |  |  | ENDS | 0.1116 | 0.0844
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk30

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 686291d1594477468-please-help-with-vloock-up-or-iferror-plano-de-manutencao-de-viaturas-2020
Sheet: Plano de Manutencao

 | Plano de Manutenção de Viaturas - AFUNJI
 | [NAME]:
 | Item | Viatura | [NAME] | Tag | Matricula | Data prevista para Manutenção | Km da Ultima Manutenção | Km Actual | limites [NAME] | Contg | [NAME] para Manutenção | Motorista | Mecânico | Status
 | 1 |  |  | EQ001 |  |  | 50000 | 59450 | 10000
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 12
 | 13
 | 14
 | 15
 | 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
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 66
 | 67
 | 68
 | 69
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
Spreadsheet: 769079d1645281629-adding-extra-spaces-in-a-cell-separating-data-from-a-single-cell-aligw-xlsx-version
Sheet: Sheet3

 | 73.29 BF2192 Brown-line Bright-eye [NAME] conigera
 | 73.291 BF2199 [NAME] Mythimna pallens
 | 73.292 BF2200 [NAME]'s Wainscot [NAME] favicolor
 | 73.293 BF2198 [NAME] [NAME] impura
 | 73.294 BF2197 Southern Wainscot [NAME] straminea
 | 73.295 BF2195 The Delicate [NAME] vitellina
 | 73.296 BF2203 White-speck [NAME] unipuncta
 | 73.297 BF2194 White-point [NAME] albipuncta
 | 73.298 BF2193 The Clay Mythimna ferrago
 | 73.299 BF2201 Shore Wainscot [NAME] litoralis
 | 73.3 BF2202 L-album Wainscot Mythimna l-album
 | [NAME] Shoulder-striped [NAME] Leucania comma
 | 73.302 BF2204 Obscure Wainscot Leucania obsoleta
 | 73.303 BF2206 [NAME] Leucania putrescens
 | 73.3031 BF2210 The Maori Graphania averilla [NAME]
Spreadsheet: 856975d1706103889-how-to-create-a-distinct-count-of-unique-numbers-when-multiple-numbers-are-combined-unique_counts
Sheet: Sheet1

 |  |  |  |  | Organization Matching Trial IDs
Golden ID | Organization Total Matching T ID | Organization ID | Organization Matching T IDs
DD123 | 6 | 73328 | 176786; 261308; 282879; 284709; 342659; 389024 |  |  | Count
DD123 | 1 | 182062 | 282879 |  | DD123 | 8
DD123 | 1 | 178508 | 296218 |  | DD104 | 9
DD123 | 1 | 153709 | 166541
DD123 | 1 | 122573 | 166541
DD104 | 6 | 87107 | 291420; 322838; 333564; 365466; 401791; 427740
DD104 | 2 | 81546 | 358229; 360137
DD104 | 2 | 235739 | 282879; 291420
Spreadsheet: 98973d1297780109-using-a-trigger-number-to-place-numbers-from-another-worksheet-forum-sample-19a
Sheet: NUM SORT

 | 0 |  |  |  | 1 |  |  |  | 2
TOTAL | NUM | ACTIVITY |  | TOTAL | NUM | ACTIVITY |  | TOTAL | NUM | ACTIVITY
0 | 000 | 4
1 | 010 | 4 |  | 1 | 010 | 4
2 | 002 | 7 |  | 2 | 011 | 4 |  | 2 | 002 | 7
2 | 011 | 4
3 | 300 | 2 |  | 3 | 201 | 4 |  | 3 | 201 | 4
3 | 201 | 4 |  | 3 | 111 | 1
4 | 400 | 5 |  | 4 | 103 | 10 |  | 4 | 202 | 7
4 | 103 | 10 |  | 4 | 112 | 2 |  | 4 | 112 | 2
4 | 202 | 7
5 | 005 | 0 |  | 5 | 311 | 4 |  | 5 | 302 | 4
5 | 041 | 4 |  | 5 | 221 | 3 |  | 5 | 221 | 3
5 | 302 | 4 |  | 5 | 041 | 4
6 | 600 | 7 |  | 6 | 051 | 1 |  | 6 | 420 | 5
6 | 051 | 1 |  | 6 | 114 | 0 |  | 6 | 312 | 7
6 | 420 | 5 |  | 6 | 312 | 7 |  | 6 | 222 | 1
6 | 033 | 6
7 | 070 | 4 |  | 7 | 151 | 7 |  | 7 | 322 | 7
7 | 061 | 8 |  | 7 | 241 | 8 |  | 7 | 052 | 9
7 | 052 | 9 |  | 7 | 313 | 3 |  | 7 | 241 | 8
7 | 304 | 7 |  | 7 | 061 | 8
8 | 080 | 5 |  | 8 | 017 | 9 |  | 8 | 260 | 12
8 | 017 | 9 |  | 8 | 161 | 2 |  | 8 | 251 | 9
8 | 260 | 12 |  | 8 | 251 | 9 |  | 8 | 224 | 5
8 | 053 | 7 |  | 8 | 431 | 8 |  | 8 | 323 | 2
8 | 440 | 4
9 | 090 | 3 |  | 9 | 018 | 4 |  | 9 | 207 | 10
9 | 018 | 4 |  | 9 | 117 | 0 |  | 9 | 522 | 6
9 | 207 | 10 |  | 9 | 162 | 12 |  | 9 | 324 | 4
9 | 603 | 10 |  | 9 | 153 | 3 |  | 9 | 162 | 12
9 | 054 | 11 |  | 9 | 144 | 3
10 | 190 | 8 |  | 10 | 190 | 8 |  | 10 | 820 | 12
10 | 820 | 12 |  | 10 | 118 | 6 |  | 10 | 172 | 9
10 | 703 | 7 |  | 10 | 172 | 9 |  | 10 | 226 | 3
10 | 640 | 9 |  | 10 | 613 | 8 |  | 10 | 235 | 8
10 | 055 | 4 |  | 10 | 541 | 8 |  | 10 | 424 | 2
11 | 092 | 7 |  | 11 | 119 | 3 |  | 11 | 092 | 7
11 | 083 | 11 |  | 11 | 821 | 5 |  | 11 | 821 | 5
11 | 704 | 5 |  | 11 | 713 | 14 |  | 11 | 272 | 2
11 | 605 | 10 |  | 11 | 416 | 14 |  | 11 | 263 | 9
 |  |  |  | 11 | 155 | 2 |  | 11 | 245 | 6
12 | 039 | 7 |  | 12 | 129 | 7 |  | 12 | 129 | 7
12 | 480 | 12 |  | 12 | 183 | 11 |  | 12 | 822 | 4
12 | 057 | 8 |  | 12 | 147 | 11 |  | 12 | 723 | 10
12 | 066 | 0 |  | 12 | 516 | 9 |  | 12 | 624 | 4
 |  |  |  |  |  |  |  | 12 | 525 | 2
13 | 409 | 6 |  | 13 | 139 | 3 |  | 13 | 922 | 7
13 | 580 | 8 |  | 13 | 184 | 5 |  | 13 | 238 | 8
13 | 706 | 7 |  | 13 | 751 | 12 |  | 13 | 247 | 7
 |  |  |  | 13 | 616 | 3 |  | 13 | 265 | 8
14 | 950 | 9 |  | 14 | 914 | 4 |  | 14 | 329 | 7
14 | 086 | 9 |  | 14 | 158 | 12 |  | 14 | 482 | 5
14 | 077 | 5 |  | 14 | 617 | 8 |  | 14 | 275 | 5
 |  |  |  |  |  |  |  | 14 | 266 | 5
15 | 609 | 7 |  | 15 | 951 | 13 |  | 15 | 294 | 6
15 | 708 | 4 |  | 15 | 618 | 6 |  | 15 | 285 | 7
 |  |  |  | 15 | 771 | 5 |  | 15 | 276 | 7
16 | 709 | 10 |  | 16 | 169 | 6 |  | 16 | 259 | 9
16 | 808 | 7 |  | 16 | 817 | 8 |  | 16 | 862 | 5
 |  |  |  |  |  |  |  | 16 | 772 | 4
17 | 809 | 12 |  | 17 | 197 | 4 |  | 17 | 926 | 6
 |  |  |  | 17 | 188 | 3 |  | 17 | 287 | 7
18 | 990 | 6 |  | 18 | 198 | 3 |  | 18 | 729 | 4
 |  |  |  |  |  |  |  | 18 | 828 | 2
 |  |  |  | 19 | 991 | 3 |  | 19 | 298 | 8
 |  |  |  |  |  |  |  | 20 | 299 | 4
Spreadsheet: 140122d1328628463-excel-2007-index-match-test-pricing
Sheet: Pricing

 | Select State | Enter WT
 | State | Estimated Wt
 | MS-Mississippi | 1450
 | Estimate Miles from JVC
 | Estimate to Zip
 | Estimate to City
Carrier | Averitt
Est Cost
Transit
Cost per lb |  | I want to look up the zip from C7 and estimated weight from [NAME] (if in between range, then show the lowest return) and match to the next tab to return cost
Cost Per LB W/O Fuel |  | B14 should return 0.1556
[NAME]
AL-Alabama | AL | Alabama
AR-Arkansas | AR | Arkansas
AZ-Arizona | AZ | Arizona
CA-California | CA | California
CO-Colorado | CO | Colorado
CT-Connecticut | CT | Connecticut
DE-Delaware | DE | Delaware
FL-Florida | FL | Florida
GA-Georgia | GA | Georgia
IA-Iowa | IA | Iowa
ID-Idaho | ID | Idaho
IL-Illinois | IL | Illinois
IN-Indiana | IN | Indiana
KS-Kansas | KS | Kansas
KY-Kentucky | KY | Kentucky
LA-Louisiana | LA | Louisiana
MA-Massachusetts | MA | Massachusetts
MD-Maryland | MD | Maryland
ME-Maine | ME | Maine
MI-Michigan | MI | Michigan
MN-Minnesota | MN | Minnesota
MO-Missouri | MO | Missouri
MS-Mississippi | MS | Mississippi
MT-Montana | MT | Montana
NC-North Carolina | NC | North Carolina
ND-North Dakota | ND | North Dakota
NE-Nebraska | NE | Nebraska
NH-New Hampshire | NH | New Hampshire
NJ-New Jersey | NJ | New Jersey
NM-New Mexico | NM | New Mexico
NV-Nevada | NV | Nevada
NY-New York | NY | New York
OH-Ohio | OH | Ohio
OK-Oklahoma | OK | Oklahoma
OR-Oregon | OR | Oregon
PA-Pennsylvania | PA | Pennsylvania
RI-Rhode Island | RI | Rhode Island
SC-South Carolina | SC | South Carolina
SD-South Dakota | SD | South Dakota
TN-Tennessee | TN | Tennessee
TX-Texas | TX | Texas
UT-Utah | UT | Utah
VA-Virginia | VA | Virginia
VT-Vermont | VT | Vermont
WA-Washington | WA | Washington
WI-Wisconsin | WI | Wisconsin
WV-West Virginia | WV | West Virginia
WY-Wyoming | WY | Wyoming
Spreadsheet: 792045d1660719666-move-year-to-the-front-berket_book1
Sheet: Sheet1

 | Year List
2000 |  |  | CHEVROLET SILVERADO CLASSIC 2007 BUMPER FRONT PRIMED W/SPORT SS MODEL GM1000683
 |  |  | <p> CHEVROLET SILVERADO CLASSIC 2007 BUMPER FRONT PRIMED W/SPORT SS MODEL GM1000683 <br> The product images shown are for illustration purposes only and may not be an exact representation of the product </p>
Spreadsheet: 485676d1477008613-replace-values-with-a-value-indicating-ranking-based-on-the-values-within-each-group-example
Sheet: Sheet1

Before:
Group Code | Product Code | Item Name | Modal Rank within Group | ShopA | [NAME] | ShopC | ShopD | ShopE
111 | 1 | [NAME] |  | 100 |  | 795
111 | 2 | item2 |  | 100 | 713.7175569 | 646.1538462 | 355.1724138 | 566.6421591
111 | 3 | item3 |  | 627.6875 | 4971.912442 | 6005 |  | 5297.635328
222 | 1 | a |  | 150 | 1400 | 1255 | 741.3793103 | 2196.666667
222 | 2 | b |  |  | 601.3929762 | 507.6923077 | 262.5 | 524.497992
222 | 3 | c |  | 90.96616669 | 546.4373184 | 405.7692308 | 350
222 | 4 | d |  |  | 7287.373737 | 5295 |  | 6364.736842
222 | 5 | e |  | 84.92283274 | 598.0660744 | 399.4230769 | 251.8518519 | 541.354035
333 | 1 | xx |  | 100 |  | 795
333 | 2 | xxt |  | 100 | 713.7175569 | 646.1538462 | 355.1724138 | 566.6421591
333 | 3 | xxa |  | 627.6875 | 4971.912442 | 6005 |  | 5297.635328
333 | 4 | xxaf |  | 627.6875 | 4971.912442 | 6005 |  | 5297.635328
After: | has 1) ranking items, within each group, from highest (1) to lowest (…) and; 2) calculates the modal rank of the item, between all groups
Group Code | Product Code | Item Name | Modal Rank within Group | ShopA | [NAME] | ShopC | ShopD | ShopE
111 | 1 | [NAME] | 2 | 2 |  | 2
111 | 2 | item2 | 2 | 2 | 2 | 3 | 1 | 2
111 | 3 | item3 | 1 | 1 | 1 | 1 |  | 1
222 | 1 | a | 2 | 1 | 2 | 2 | 1 | 2
222 | 2 | b | 3 |  | 3 | 3 | 3 | 4
222 | 3 | c | 2 | 2 | 5 | 4 | 2
222 | 4 | d | 1 |  | 1 | 1 |  | 1
222 | 5 | e | 5 | 3 | 5 | 5 | 4 | 3
333 | 1 | xx | 2 | 2 |  | 2
333 | 2 | xxt | 2 | 2 | 2 | 3 | 1 | 2
333 | 3 | xxa | 1 | 1 | 1 | 1 |  | 1
333 | 4 | xxaf | 1 | 1 | 1 | 1 |  | 1
 | ideal, with ranking and indication of how many items within each group, but still calculating the rank within group
Group Code | Product Code | Item Name | Modal Rank within Group | ShopA | [NAME] | ShopC | ShopD | ShopE
111 | 1 | [NAME] | 2 | 2/2 |  | 2
111 | 2 | item2 | 2 | 2/2 | 2 | 3 | 1 | 2
111 | 3 | item3 | 1 | 1/2 | 1 | 1 |  | 1
222 | 1 | a | 2 | 1/3 | 2 | 2 | 1 | 2
222 | 2 | b | 3 |  | 3 | 3 | 3 | 4
222 | 3 | c | 2 | 2/3 | 5 | 4 | 2
222 | 4 | d | 1 |  | 1 | 1 |  | 1
222 | 5 | e | 5 | 3/3 | 5 | 5 | 4 | 3
333 | 1 | xx | 2 | 2/4 |  | 2
333 | 2 | xxt | 2 | 2/4 | 2 | 3 | 1 | 2
333 | 3 | xxa | 1 | 1/4 | 1 | 1 |  | 1
333 | 4 | xxaf | 1 | 1/4 | 1 | 1 |  | 1
Spreadsheet: 122411d1316787765-excel-2007-if-statement-tricoder-1-modified3-for-symbolscanner
Sheet: Sheet1

2011-09-22 00:00:00 | 02:22:00 | 01 | Program
2011-09-22 00:00:00 | 02:22:00 | 01 | 0036567
2011-09-22 00:00:00 | 02:22:00 | 01 | 0036603
2011-09-22 00:00:00 | 02:22:00 | 01 | 0036289
2011-09-22 00:00:00 | 14:23:00 | 03 | 0036289
2011-09-22 00:00:00 | 02:23:00 | 03 | 0036062
2011-09-22 00:00:00 | 02:23:00 | 03 | 0036446
2011-09-22 00:00:00 | 02:23:00 | 03 | 0036235
2011-09-22 00:00:00 | 02:23:00 | 04 | 0036586
2011-09-22 00:00:00 | 02:23:00 | 04 | LMO
2011-09-22 00:00:00 | 02:23:00 | 01 | 0036650
2011-09-22 00:00:00 | 02:23:00 | 01 | 0036472
2011-09-22 00:00:00 | 02:23:00 | 01 | 0036679
2011-09-21 00:00:00 | 02:23:00 | 01 | 0036664
2011-09-22 00:00:00 | 02:24:00 | 03 | 0036664
2011-09-23 00:00:00 | 22:25:00 | 03 | 0036664
2011-09-22 00:00:00 | 02:23:00 | 03 | 0036662
2011-09-22 00:00:00 | 02:23:00 | 03 | 0036476
2011-09-22 00:00:00 | 02:23:00 | 04 | 0036348
2011-09-21 00:00:00 | 02:23:00 | 04 | 0036474
2011-09-22 00:00:00 | 02:24:00 | 01 | 0036474
2011-09-23 00:00:00 | 02:28:00 | 01 | 0036474
2011-09-22 00:00:00 | 02:24:00 | 01 | 0036477
2011-09-22 00:00:00 | 02:24:00 | 01 | 0036493
2011-09-22 00:00:00 | 02:24:00 | 03 | 0036666
2011-09-22 00:00:00 | 02:26:00 | 03 | OFFICE
2011-09-22 00:00:00 | 02:26:00 | 03 | 0036731
2011-09-21 00:00:00 | 02:25:00 | 03 | 0036728
2011-09-22 00:00:00 | 22:26:00 | 04 | 0036728
2011-09-23 00:00:00 | 02:27:00 | 04 | 0036728
2011-09-22 00:00:00 | 02:26:00 | 01 | 0036711
2011-09-22 00:00:00 | 02:26:00 | 01 | 0036640
2011-09-22 00:00:00 | 02:27:00 | 01 | 0036709
2011-09-22 00:00:00 | 02:27:00 | 01 | 0036719
2011-09-21 00:00:00 | 02:26:00 | 03 | 0036275
2011-09-22 00:00:00 | 02:27:00 | 03 | 0036275
2011-09-23 00:00:00 | 22:28:00 | 03 | 0036275
2011-09-22 00:00:00 | 02:27:00 | 03 | 0036668
2011-09-22 00:00:00 | 02:27:00 | 04 | 0036656
2011-09-22 00:00:00 | 02:27:00 | 04 | 0036637
2011-09-22 00:00:00 | 02:30:00 | 03 | 0036701
2011-09-22 00:00:00 | 02:34:00 | 03 | DONE
2011-09-22 00:00:00 | 02:34:00 | 03 | 0036539
2011-09-22 00:00:00 | 02:34:00 | 04 | 0036495
2011-09-22 00:00:00 | 02:34:00 | 04 | 0036379
2011-09-22 00:00:00 | 02:35:00 | 01 | 0036582
2011-09-22 00:00:00 | 02:35:00 | 01 | 0036527
2011-09-22 00:00:00 | 02:31:00 | 01 | OFFICE
2011-09-22 00:00:00 | 02:31:00 | 01 | 0036644
2011-09-22 00:00:00 | 02:31:00 | 03 | 0036417
2011-09-22 00:00:00 | 02:34:00 | 03 | 0036417
2011-09-22 00:00:00 | 02:31:00 | 03 | 0036636
2011-09-22 00:00:00 | 02:31:00 | 03 | 0036632
2011-09-22 00:00:00 | 02:39:00 | 04 | DONE
2011-09-22 00:00:00 | 02:40:00 | 04 | LMO
2011-09-22 00:00:00 | 02:25:00 | 04 | 0036661
2011-09-22 00:00:00 | 02:26:00 | 04 | 0036716
2011-09-22 00:00:00 | 02:27:00 | 04 | 0036716
Spreadsheet: 684480d1593396593-getting-result-if-any-one-condition-match-new-microsoft-excel-worksheet
Sheet: Sheet1

Item Code | Work 1 |  |  | Work 2 |  |  | Work 3 |  |  | Work 4
 | P-1 | P-2 | P-3 | P-1 | P-2 | P-3 | P-1 | P-2 | P-3 | P-1 | P-2 | P-3
A-405 | fs |  |  | xvxv
A-820 | fdsf | dfdf | ok | vxvx
A-440 | fdsf | fds | ok | vxvx | fsdssf | ok | fdaf
A-650 | vxv | vxv | ok | xcvv | gsds | ok | vcxxv |  | ok | gdg | gdfgd | ok
A-260 | cxzc | cx | ok | vcxv | xvxc | ok | cvv | vxcv | ok | dgdg | gdgdg | ok
Item Code
Required Resut in Sheet2
Spreadsheet: 270476d1381498041-if-a-cell-has-a-text-value-then-next-one-must-have-a-percentage-0a1-fotis
Sheet: Sheet1

Client2
 |  |  |  |  |  |  |  |  |  | Client1 | 0.05
Choose a customer in A1 from the list and see what happens in B1.. |  |  |  |  |  |  |  |  |  | Client2 | 0.06
 |  |  |  |  |  |  |  |  |  | Client3 | 0.07
 |  |  |  |  |  |  |  |  |  | Client4 | 0.08
 |  |  |  |  |  |  |  |  |  | Client5 | 0.09
 |  |  |  |  |  |  |  |  |  | Client6 | 0.1
 |  |  |  |  |  |  |  |  |  | Client7 | 0.11
 |  |  |  |  |  |  |  |  |  | Client8 | 0.12
 |  |  |  |  |  |  |  |  |  | Client9 | 0.13
 |  |  |  |  |  |  |  |  |  | Client10 | 0.14
 |  |  |  |  |  |  |  |  |  | Client11 | 0.15
 |  |  |  |  |  |  |  |  |  | Client12 | 0.16
 |  |  |  |  |  |  |  |  |  | Client13 | 0.17
 |  |  |  |  |  |  |  |  |  | Client14 | 0.18
 |  |  |  |  |  |  |  |  |  | Client15 | 0.19
 |  |  |  |  |  |  |  |  |  | Client16 | 0.2
 |  |  |  |  |  |  |  |  |  | Client17 | 0.21
 |  |  |  |  |  |  |  |  |  | Client18 | 0.22
 |  |  |  |  |  |  |  |  |  | Client19 | 0.23
 |  |  |  |  |  |  |  |  |  | Client20 | 0.24
Spreadsheet: 86389d1286381271-trendlines-in-two-separate-intervals-dummy
Sheet: Sheet1

 |  |  | temp | elong
 |  |  | 33 | 0.01
 |  |  | 34 | 0.02
 |  |  | 35 | 0.03
 |  |  | 36 | 0.04
 |  |  | 37 | 0.05
 |  |  | 38 | 0.06
 |  |  | 39 | 0.07
 |  |  | 40 | 0.08
 |  |  | 41 | 0.09
 |  |  | 42 | 0.1
 |  |  | 43 | 0.11
 |  |  | 44 | 0.12
 |  |  | 45 | 0.13
Spreadsheet: 682357d1592039755-sum-based-on-order-number-in
Sheet: Sheet3

Invoice Number | Expr1 | WON | [NAME]
4420
4421
4422
4423
4424
4425
4426
4427
 | TOTAL
Spreadsheet: 137138d1326973930-updating-another-spreadsheet-based-on-certain-information-and-certain-conditions-dates
Sheet: Alex Webster

 | 10:00:00 | 10:15:00 | 10:30:00 | 10:45:00 | 11:00:00 | 11:15:00 | 11:30:00 | 11:45:00 | 12:00:00 | 12:15:00 | 12:30:00 | 13:30:00 | 13:45:00 | 14:00:00 | 14:15:00 | 14:30:00 | 14:45:00 | 15:00:00 | 15:15:00 | 15:30:00 | 15:45:00
2012-04-23 00:00:00 | Introduction to the Business
2012-04-24 00:00:00
2012-04-25 00:00:00 | Using the Phones
2012-04-26 00:00:00
2012-04-27 00:00:00
Spreadsheet: 837932d1690537647-help-formula-with-dropdown-list-combobox-dummy-data-5-aligw
Sheet: Master

 | Region |  |  | Branch
 | South |  |  | CHE
 |  |  |  | Apr |  |  | May |  |  | June
 |  | Model | OS | SI | ST | CI | SI | ST | CI | SI | ST | CI
 |  | DMC-FZ2500GA
 |  | DC-FZ10002GW
 |  | DC-S1HGW-K
 |  | DC-S5KGW-K
 |  | DC-S5GW-K
 |  | DC-S5M2WGW
 |  | DC-S5M2KGW
 |  | DC-S5M2GW
 |  | DC-S5M2XWGW
Spreadsheet: 745745d1630159768-formula-to-search-for-absent-and-present-indexing-values-from-matrix-setup-of-data-hassan-khansa-
Sheet: Sheet2

Date | 2021-11-04 00:00:00
Name | 1st hour | 2nd hour | 3rd hour | 4th hour
Spreadsheet: 677881d1589565028-return-results-based-on-selections-2020-05-15-oeldere-ajhickin-pt-677803d1589531783-return-results-based-on-selections-sample
Sheet: Sheet1

content | Requirements |  |  | Inventory
Content 1 | Box 1
Content 2 | Box 1 |  |  |  |  | Aantal [NAME] | Columnlabel
Content 3 | Box 1 |  |  |  |  | Rowlabel | Box 1 | [NAME] | Eindtotaal
Content 4 | [NAME] |  |  |  |  | Content 1 | 1 |  | 1
Content 5 | [NAME] |  |  |  |  | Content 10 | 1 |  | 1
Content 6 | [NAME] |  |  |  |  | Content 2 | 1 |  | 1
Content 7 | Box 1 | [NAME] |  |  |  | Content 3 | 1 |  | 1
Content 8 | Box 1 | [NAME] |  |  |  | Content 4 |  | 1 | 1
Content 9 | Box 1 | [NAME] |  |  |  | Content 5 |  | 1 | 1
Content 10 | Box 1 | [NAME] |  |  |  | Content 6 |  | 1 | 1
 |  |  |  |  |  | Content 7 | 1 |  | 1
 |  |  |  |  |  | Content 8 | 1 |  | 1
 |  |  |  |  |  | Content 9 | 1 |  | 1
 |  |  |  |  |  | Eindtotaal | 7 | 3 | 10
Spreadsheet: 192622d1352476765-how-could-i-group-the-date-by-value-workbook1
Sheet: Expected Output

 | Start Date | End Date | Price
Item 1 | 2012-10-01 00:00:00 | 2012-10-07 00:00:00 | 3.2
Item 1 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 3.1
Item 2 | 2012-10-01 00:00:00 | 2012-10-09 00:00:00 | 3.5
Item 3 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2.8
Item 3 | 2012-10-03 00:00:00 | 2012-10-07 00:00:00 | 3.9
Item 3 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2.6
Spreadsheet: 49959d1249385984-how-to-auto-populate-but-with-criteria-conslidate-with-criteria-blank
Sheet: Company A

 | CF ID | Participating LE | Participating Subdiv | Flow | Amount | CF currency | Other Currency | Expected date | Realized date | Eligible | Hedgeable Percentage
 | 41239 | 0 | EXTER | Outflow | 1202 | EUR | GBP | 2009-06-15 00:00:00 |  | Eligible | 0
 | 50625 | 0 | EXTER | Outflow | 1668 | EUR | GBP | 2009-06-15 00:00:00 |  | Eligible | 0
 | 50695 | 0 | EXTER | Outflow | 173426 | EUR | GBP | 2009-06-15 00:00:00 |  | Eligible | 100
 | 41286 | 0 | EXTER | Outflow | 2010 | EUR | GBP | 2009-07-15 00:00:00 |  | Eligible | 0
 | 51001 | 0 | EXTER | Outflow | 2010 | EUR | GBP | 2009-07-15 00:00:00 |  | Eligible | 0
 | 50696 | 0 | EXTER | Outflow | 138994 | EUR | GBP | 2009-07-31 00:00:00 |  | Eligible | 100
 | 50697 | 0 | EXTER | Outflow | 93418 | EUR | GBP | 2009-07-31 00:00:00 |  | Eligible | 100
 | 41242 | 0 | EXTER | Outflow | 2010 | EUR | GBP | 2009-08-15 00:00:00 |  | Eligible | 0
 | 51002 | 0 | EXTER | Outflow | 2187 | EUR | GBP | 2009-08-17 00:00:00 |  | Eligible | 0
 | 50698 | 0 | EXTER | Outflow | 93418 | EUR | GBP | 2009-08-31 00:00:00 |  | Eligible | 100