tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 734380d1622130400-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: vlist

project | Vertrek | Aankomst | begeleider | tijd | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3 |  | Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K | wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
Spreadsheet: 38796d1236942317-summarizing-data-over-several-sheets-bolts-list-13-03-09
Sheet: Summary P1

BOLT SUMMARY
CLIENT… |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | JOB No…
PLANT SECTION… |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | LIST No… |  |  | 1 of 3
All fasteners grade 8.8 BZP, All CSK bolts socket head, All standard bolts hex head
BOLT LENGTH | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
BOLT DIA | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Sub total | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
0.1 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
TOTAL | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 752101d1634580330-reshaping-a-matrix-with-formulas-reshape_matrix
Sheet: Sheet1

 | Original Matrix:
 | 59 | 59 | 63 | 30 | 70 | 9
 | 40 | 6 | 45 | 75 | 92 | 1
 | 6 | 19 | 6 | 93 | 78 | 1
 | 89 | 100 | 30 | 44 | 9 | 9
 | 51 | 80 | 89 | 53 | 62 | 2
 | 81 | 9 | 33 | 39 | 16 | 8
 | 99 | 58 | 74 | 19 | 77 | 2
 | 41 | 66 | 51 | 73 | 7 | 7
 | Reshape to Matrix where MOD(columns_new,columns_old)=0 and MOD(rows_old,rows_new)=0
 | columns_old |  |  |  | columns_new |  | 12 |  | MOD
 | rows_old |  |  |  | rows_new |  | 4 |  | MOD
 | Reshaped Matrix: |  |  | Pattern to repeat: |  |  |  | equiv.
 | Reshape to Matrix where MOD(columns_new,columns_old)<>0 and MOD(rows_old,rows_new)<>0
 | e.g. take 5 × 4 matrix and turn into 10 × 2 matrix
 | 19 | 18 | 99 | 37
 | 100 | 23 | 79 | 15
 | 6 | 20 | 70 | 46
 | 24 | 2 | 90 | 12
 | 90 | 89 | 48 | 85
 | columns_old |  |  |  | columns_new |  | 10 |  | MOD
 | rows_old |  |  |  | rows_new |  | 2 |  | MOD
 | Reshaped Matrix: |  |  | Pattern to repeat: |  |  |  | equiv.
 | Should be:
 | 19 | 18 | 99 | 37 | 100 | 23 | 79 | 15 | 6 | 20
 | 70 | 46 | 24 | 2 | 90 | 12 | 90 | 89 | 48 | 85
Check
 |  | 18 | 99 | 37 | 100 | 23 | 79 | 15 | 6 | 20
 | 70 | 46 | 24 | 2 | 90 | 12 | 90 | 89 | 48 | 85
 |  | 18 | 99 | 37 | 100 | 23 | 79 | 15 | 6 | 20
 | 70 | 46 | 24 | 2 | 90 | 12 | 90 | 89 | 48 | 85
Spreadsheet: 114971d1310630962-automatically-updating-data-from-one-sheet-to-another-june1
Sheet: 9406

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00 | Jalaram | Yes
2011-06-02 00:00:00
2011-06-03 00:00:00
2011-06-04 00:00:00 | Gateway To India | Yes
2011-06-05 00:00:00 | Gateway To India | Yes
2011-06-06 00:00:00 | Gateway To India | Yes
2011-06-07 00:00:00 | Gateway To India | Yes
2011-06-08 00:00:00 | Gateway To India | Yes
2011-06-09 00:00:00 | Gateway To India | Yes
2011-06-10 00:00:00 | [NAME]
2011-06-11 00:00:00 | [NAME]
2011-06-12 00:00:00 | [NAME]
2011-06-13 00:00:00 | [NAME]
2011-06-14 00:00:00 | [NAME]
2011-06-15 00:00:00 | [NAME]
2011-06-16 00:00:00 | [NAME]
2011-06-17 00:00:00 | [NAME]
2011-06-18 00:00:00 | [NAME]
2011-06-19 00:00:00
2011-06-20 00:00:00
2011-06-21 00:00:00
2011-06-22 00:00:00
2011-06-23 00:00:00 | Shari Marriage | Yes
2011-06-24 00:00:00
2011-06-25 00:00:00
2011-06-26 00:00:00
2011-06-27 00:00:00
2011-06-28 00:00:00
2011-06-29 00:00:00
2011-06-30 00:00:00
2011-07-01 00:00:00
2011-07-02 00:00:00
2011-07-03 00:00:00
2011-07-04 00:00:00
2011-07-05 00:00:00
2011-07-06 00:00:00
2011-07-07 00:00:00
2011-07-08 00:00:00
2011-07-09 00:00:00
2011-07-10 00:00:00
2011-07-11 00:00:00
2011-07-12 00:00:00
2011-07-13 00:00:00
2011-07-14 00:00:00
2011-07-15 00:00:00
2011-07-16 00:00:00
2011-07-17 00:00:00
2011-07-18 00:00:00
2011-07-19 00:00:00
2011-07-20 00:00:00
2011-07-21 00:00:00
2011-07-22 00:00:00
2011-07-23 00:00:00
2011-07-24 00:00:00
2011-07-25 00:00:00
2011-07-26 00:00:00
2011-07-27 00:00:00
2011-07-28 00:00:00
2011-07-29 00:00:00
2011-07-30 00:00:00
2011-07-31 00:00:00
Spreadsheet: 154785d1336565402-pulling-two-lists-into-one-and-showing-duplicates-multiple-answers-one-chart
Sheet: Sheet1

 | ID | K1121 |  |  |  | List 1 |  |  | List 2
 |  |  |  |  |  | First | ID # |  | First | ID #
 |  |  |  |  |  | [NAME] | K1121 |  | [NAME] | K1444
 | Pulling multiples by one ID |  |  |  |  | [NAME] | K1121 |  | [NAME] | K555
 | First Name | ID | Where |  |  | [NAME] | K1222 |  | [NAME] | K222
 | =IFERROR(INDEX($G$4:$G$7, SMALL(IF($H$4:$H$7=$C$2, ROW($G$4:$G$7)-2, ""), ROW(A1))), INDEX($J$4:$J$7, SMALL(IF($K$4:$K$7=$C$2, [NAME], ""), ROW(A1)-COUNTIF($H$4:$H$7, $C$2)))) |  |  |  |  | Butch | K1333 |  | [NAME] | K1121
 | [NAME] | K1121 | List 1
 | [NAME] | K1121 | List 2
Spreadsheet: 100787d1299026477-subtracting-column-number-in-workbook-from-one-sheet-to-another-book2
Sheet: Sheet2

Oil Producers Inc. of Kansas |  |  |  | Official Gauge Report
Lease: | Burr 1-5 | Gauger: | Kodi Siroky |  | From: |  |  | To:
Tank #: |  | [NAME]: |  |  | Orifice Plate Size: |  | EGM (Deduct)
Date | Daily Oil Gauge |  | Daily Oil Gauge |  | Daily Oil | Line | Diff | MCF | SW | Remarks
 | Feet | Inches | Feet | Inches | Prod. | Press |  |  | Bbls.
1 |  |  |  |  |  |  |  | 50
2 |  |  |  |  |  |  |  | 50
3 |  |  |  |  |  |  |  | 50
4 |  |  |  |  |  |  |  | 50
5 |  |  |  |  |  |  |  | 50
6 |  |  |  |  |  |  |  | 50
7 |  |  |  |  |  |  |  | 50
8 |  |  |  |  |  |  |  | 50
9 |  |  |  |  |  |  |  | 50
10 |  |  |  |  |  |  |  | 50
11 |  |  |  |  |  |  |  | 50
12 |  |  |  |  |  |  |  | 50
13 |  |  |  |  |  |  |  | 50
14 |  |  |  |  |  |  |  | 50
15 |  |  |  |  |  |  |  | 50
16 |  |  |  |  |  |  |  | 50
17 |  |  |  |  |  |  |  | 50
18 |  |  |  |  |  |  |  | 50
19 |  |  |  |  |  |  |  | 50
20 |  |  |  |  |  |  |  | 50
21 |  |  |  |  |  |  |  | 50
22 |  |  |  |  |  |  |  | 50
23 |  |  |  |  |  |  |  | 50
24 |  |  |  |  |  |  |  | 50
25 |  |  |  |  |  |  |  | 50
26 |  |  |  |  |  |  |  | 50
27 |  |  |  |  |  |  |  | 50
28 |  |  |  |  |  |  |  | 50
29 |  |  |  |  |  |  |  | 50
30 |  |  |  |  |  |  |  | 50
31
Total Oil Produced |  |  |  |  |  | Total MCF
Report of Oil Hauled or Pipeline Runs
Date | Ticket # | Tank # | Open Gauge | Closing Gauge | % BS&W | Net Run | Bbls Oil Sold
Spreadsheet: kate_symes__18389__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 | 2000-12-18 00:00:00 |  | 372.89 | 7600 | 321.88 | 1600 | 378.62 | 360 | 328.33 | 150
 | 2000-12-17 00:00:00 |  |  |  |  |  | 368.41 | 1404 | 355.96 | 663 |  | 321.88 | 4800
 | 2000-12-16 00:00:00 |  | 317.57 | 11504 | 272.19 | 1112 | 374.92 | 642 | 339.88 | 168
 | 2000-12-15 00:00:00 |  | 317.59 | 11424 | 272.19 | 1112 | 364.78 | 598 | 477.91 | 763
 | 2000-12-14 00:00:00 |  | 459.34 | 7024 | 342.87 | 1712 | 380.91 | 1574 | 283 | 1890
 | 2000-12-13 00:00:00 |  | 700.87 | 7824 | 485.4 | 1712 | 391.35 | 1561 | 349.97 | 318
 | 2000-12-12 00:00:00 |  | 956.16 | 9024 | 636.87 | 2712 | 526.56 | 322 | 355.87 | 412
 | 2000-12-11 00:00:00 |  | 3322.42 | 5744 | 2166.67 | 600 | 1285.47 | 695 | 451.85 | 621
 | 2000-12-10 00:00:00 |  |  |  |  |  | 595.02 | 1607 | 516.15 | 975 |  | 2125 | 2400
 | 2000-12-09 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 423.26 | 1913 | 496.71 | 380
 | 2000-12-08 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 604.06 | 1877 | 475.29 | 433
 | 2000-12-07 00:00:00 |  | 628.75 | 8000 | 490 | 1000 | 664.04 | 2134 | 377.22 | 552
 | 2000-12-06 00:00:00 |  | 360.3 | 13200 | 283.68 | 3800 | 417.71 | 480 | 254.49 | 195
 | 2000-12-05 00:00:00 |  | 278.15 | 16000 | 234.69 | 3200 | 305.36 | 1340 | 275 | 1155
 | 2000-12-04 00:00:00 |  | 276.46 | 14800 | 247.86 | 4200 | 261.33 | 1471 | 225.6 | 1552
 | 2000-12-03 00:00:00 |  | 268.33 | 1200 | 231.67 | 600 | 222.94 | 425 | 200 | 70 |  | 249.41 | 10200
 | 2000-12-02 00:00:00 |  | 264.7 | 26400 | 217.08 | 2400 | 223.95 | 2144 | 203.49 | 506
 | 2000-12-01 00:00:00 |  | 264.7 | 26400 | 217.08 | 2400 | 235.86 | 1637 | 204.07 | 800
 | 2000-11-30 00:00:00 |  | 254.19 | 17760 | 205.14 | 2800 | 244.29 | 175 | 204.3 | 465
 | 2000-11-29 00:00:00 |  | 251.79 | 21056 | 202.81 | 3200 | 244.89 | 1103 | 191.93 | 1385
 | 2000-11-28 00:00:00 |  | 252.35 | 10256 | 206.11 | 1800 | 215.95 | 1135 | 187.84 | 670
 | 2000-11-27 00:00:00 |  | 235.87 | 16160 | 212.32 | 3080 | 195.74 | 370 | 163.55 | 1325
 | 2000-11-26 00:00:00 |  | 230 | 400 | 210 | 0 | 200.64 | 1079 | 180.57 | 795 |  | 212.93 | 8400
 |  |  |  |  |  | ..
Spreadsheet: 888352d1738840289-which-formula-would-be-best-to-use-formula-query-6-feb-v3
Sheet: Sheffield - results

Sheffield
Opening hours |  |  |  | Actions per day | ??? | yes, but only half
Monday | 420 | 2400 | 1
Tuesday | 420 | 2400 | 2
Wednesday | 420 | 2400 | 3
Thursday | 420 | 2400 | 4
Friday | 420 | 2400 | 5
Saturday | 420 | 2400 | 6
Sunday | 730 | 2400 | 7
 |  | Total
Screen accessed out of hours |  | NOT WORKING YET
Item accessed | Qty
arrivals & departures
Arrivals & departures button
Back button
flipped
home
Home button
journey planner
Journey planner button
Keyboard
languages
latest travel updates
Latest travel updates button
Menu button
onward travel
Onward travel button
page
Passenger assistance
Passenger assistance banner
Passenger assistance button
station information
Station information button
Unflipped
Total actions
Spreadsheet: d1242c2a-7699-4978-af62-9813d3827a09
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
43074937 | 2014-09-08 17:27:09 | AXIS | 0 | 1 | 6 | 1485314 | [NAME] 62 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43075033 | 2014-09-08 17:35:07 | ALLIES | 1 | 6 | 3 | 1485314 | [NAME] 62 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
43083431 | 2014-09-09 05:49:00 | ALLIES | 1 | 6 | 4 | 1629094 | bawss | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43114578 | 2014-09-11 17:49:12 | ALLIES | 0 | 1 | 6 | 1101042 | Brindavoine | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43115743 | 2014-09-11 19:33:13 | AXIS | 0 | 5 | 6 | 1587662 | christiane13 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43115973 | 2014-09-11 19:45:37 | ALLIES | 1 | 6 | 3 | 1587662 | christiane13 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
43127924 | 2014-09-12 17:06:59 | AXIS | 1 | 4 | 2 | 1633836 | Vaggos678 | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
43137074 | 2014-09-13 07:06:18 | ALLIES | 1 | 7 | 3 | 1503014 | Agent Avacado | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43137231 | 2014-09-13 07:30:21 | AXIS | 0 | 6 | 7 | 1503014 | Agent Avacado | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43157753 | 2014-09-14 17:59:50 | AXIS | 0 | 5 | 6 | 603439 | MickeyScott01 | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
43219636 | 2014-09-19 05:44:48 | AXIS | 1 | 6 | 4 | 1636296 | player1636296 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
43238000 | 2014-09-20 16:32:22 | ALLIES | 0 | 3 | 6 | 1142502 | Soldat d'Automne | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43238211 | 2014-09-20 16:56:56 | AXIS | 1 | 6 | 4 | 1142502 | Soldat d'Automne | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43259402 | 2014-09-22 00:15:50 | AXIS | 1 | 4 | 1 | 1360927 | MajorFlanHigh [DG] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
Spreadsheet: 94166d1294049358-change-formula-to-work-in-conditional-formatting-vba-rule
Sheet: Sheet1

 |  | Name | sDate | eDate | nDays |  | Conditions
 |  | Fred | 2011-01-09 00:00:00 | 2011-01-11 00:00:00 |  |  | Nome | Fred
 |  | Fred | 2011-01-05 00:00:00 | 2011-01-07 00:00:00 |  |  | sDate | 2011-01-06 00:00:00
 |  | [NAME] | 2011-01-10 00:00:00 | 2011-01-15 00:00:00 |  |  | eDate | 2011-01-06 00:00:00
 |  | Smith | 2011-01-06 00:00:00 | 2011-01-07 00:00:00
 |  | Fred | 2011-01-06 00:00:00 | 2011-01-06 00:00:00 |  |  | Nr of Records |  |  | =COUNTIFS(Table1[Name];$I$3;Table1[sDate];"<="&$I$4;Table1[eDate];">="&$I$5)
 |  | Fred | 2011-01-03 00:00:00 | 2011-01-15 00:00:00
 |  |  | I need to create a VBA conditional formatting rule (not an excel conditional formatting rule) that shows RED color if the number of records is greater than 1
Spreadsheet: 9082020a-f7bd-4c0d-a10e-15f1c78e39dc
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
FDM1 | Test | FDM1 | DM1 DNA | DM1 DNA | Polymerase Chain Reaction (PCR), Fragment analysis and Southern blot | EDTA (lavender-top) tube: EDTA |  |  | 30 | mL | 30 mL whole blood collected in a lavender-top EDTA tube(s). Send whole blood at ambient temperature.   Note:  Collection date is required. | 10 mL | Specimens other than	Whole blood Anticoagulants other than	EDTA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | A final report will be attached in MayoAccess.   Test Performed by Athena Diagnostics                                       377 Plantation Street                                       Four Biotech Park                                       Worcester, MA 01605 | Monday, Thursday | 14 - 21 days | 15 - 22 days | 1 | 81401 |  |  |  |  | Athena Diagnostics
FDM1 | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient
FDM1 | Result | [NAME] | DM1 DNA | DM1 DNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 736550d1623734266-combining-similar-areas-of-data-oly-ans
Sheet: Sheet1

London
 | Archery | Gymnastics | Swimming
Canada | 2 | 0 | 1
Germany | 0 | 1 | 1
Italy | 1 | 1 | 3
 |  |  |  |  |  |  |  |  |  | Rio
 |  |  |  |  |  |  |  |  |  |  | Gymnastics | Swimming | Cycling
 |  |  |  |  |  |  |  |  |  | Canada | 0 | 3 | 0
 |  |  |  |  |  |  |  |  |  | UK | 1 | 1 | 3
 |  |  |  |  |  |  |  |  |  | USA | 2 | 3 | 1
 |  |  |  |  |  |  |  |  |  | Germany | 0 | 1 | 2
 |  |  |  |  |  |  |  |  |  | Combined
 |  |  |  |  |  |  |  |  |  |  | Archery | Gymnastics | Swimming | Cycling
 |  |  |  |  |  |  |  |  |  | Canada | 2 | 0 | 4 | 0
 |  |  |  |  |  |  |  |  |  | UK | 0 | 1 | 1 | 3
 |  |  |  |  |  |  |  |  |  | USA | 0 | 2 | 3 | 1
 |  |  |  |  |  |  |  |  |  | Germany | 0 | 1 | 2 | 2
 |  |  |  |  |  |  |  |  |  | Italy | 1 | 1 | 3 | 0
Spreadsheet: 718005d1612949439-comparing-account-numbers-on-two-seerate-sheets-formula-to-compare-account-numbers-of-two-sheets
Sheet: PER AFS

Account Numbers
itens
6233001
6233003
6233008
6233020
6233021
6233022
6233023
6233028
6233040
6233041
6233043
6233048
6233060
6233061
6233063
6233066
6233068
6233080
6233081
6233083
6233086
6233088
6233090
6233091
6233093
6233098
6233100
6233101
6233103
6233108
6233120
6233121
6233123
6233128
6233140
6233141
6233143
6233146
6233148
6233160
6233161
6233163
6233168
6233180
6233181
6233182
6233183
6233186
6233188
6233200
6233201
6233202
6233203
6233208
6233220
6233221
6233222
6233223
6233228
6233240
6233241
6233242
6233243
6233248
6233260
6233261
6233262
6233263
6233268
6233280
6233281
6233283
6233290
6233291
6233293
6233300
6233301
6233303
6233308
6233310
6233311
6233312
6233313
6233410
6233420
6233430
6233432
6233510
6233520
6233550
6233554
6233580
6233610
6233614
6233620
6233630
6233634
6233710
6233714
6233720
6233724
6233730
6233734
6233740
6233744
6233810
6235030
6253000
6253001
6253003
6253008
6253050
6253051
6253053
6253058
6253102
6253103
6253108
6253152
6253153
6253158
6253410
6253420
6253510
6253520
6253550
6253554
6253580
6253610
6253614
6253630
6253634
6253710
6253714
6253720
6253724
6253730
6253734
6253740
6253810
6255010
6255014
6255030
6255050
6263001
6263002
6263003
6263004
6263005
6263011
6263012
6263013
6263014
6263015
6263021
6263022
6263023
6263024
6263025
6263301
6263304
6263311
6263314
6263321
6263324
6263334
6263410
6263420
6263430
6263431
6263450
6263600
6263601
6263650
6263651
6263660
6263661
6263690
6263691
6264025
6265021
6265022
6265030
6273000
6273002
6273004
6273008
6273010
6273012
6273050
6273052
6273054
6273058
6273060
6273062
6273200
6273202
6273204
6273208
6273210
6273212
6273250
6273252
6273254
6273258
6273260
6273262
6273300
6273302
6273304
6273308
6273310
6273312
6273600
6273602
6273606
6273608
6273650
6273652
6273656
6273658
6273700
6273702
6273706
6273708
6273750
6273752
6273756
6273758
6273800
6273802
6273806
6273808
6273910
6273912
6274025
6275030
6299030
Spreadsheet: 799851d1665351021-counting-the-emails-that-match-another-column-while-so-matching-a-condition-in-another-example-question-etaf-2-
Sheet: Sheet2

email | date
[EMAIL] | 2020-05-05 00:00:00 |  |  |  | [EMAIL] | mobile
[EMAIL] | 2020-05-05 00:00:00 |  |  |  | [EMAIL] | computer
[EMAIL] | 2020-05-06 00:00:00 |  |  |  | [EMAIL] | computer
[EMAIL] | 2020-05-06 00:00:00 |  |  |  | [EMAIL] | mobile
[EMAIL] | 2020-05-07 00:00:00 |  |  |  | [EMAIL] | mobile
[EMAIL] | 2020-05-07 00:00:00 |  |  |  | [EMAIL] | computer
Spreadsheet: 788080d1658251941-formu-sample-matching-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected Results | AliGW
 |  |  |  |  |  |  |  | -1 | -1
 |  |  |  |  | -5 |  |  | -2 | -2
 |  |  |  |  |  |  |  | -3 | -3
 |  |  |  |  |  |  |  | -4 | -4
 |  |  |  |  |  |  |  | -4.5 | -5
 |  |  |  |  |  |  |  | -6 | -6
 |  |  |  |  |  |  |  | -7 | -6
 |  |  |  |  |  |  |  | 5 | -6
 |  |  |  |  |  |  |  | 1 | -6
 |  |  |  |  |  |  |  | -10 | -6
 |  |  |  |  |  |  |  | -11 | -6
 |  |  |  |  |  |  |  | -12 | -6
 |  |  |  |  |  |  |  | 10 | -6
 |  |  |  |  |  |  |  | -14 | -6
 |  |  |  |  |  |  |  | -15 | -6
 |  |  |  |  |  |  |  | -16 | -6
 |  |  |  |  |  |  |  | -17 | -6
 |  |  |  |  |  |  |  | 1200 | -6
 |  |  |  |  |  |  |  | -19 | -6
 |  |  |  |  |  |  |  | -20 | -6
 |  |  |  |  |  |  |  | -21 | -6
 |  |  |  |  |  |  |  | -22 | -6
 |  |  |  |  |  |  |  | -23 | -6
 |  |  |  |  |  |  |  | -24 | -6
 |  |  |  |  |  |  |  | -25 | -6
Spreadsheet: 875158d1721733205-display-name-not-code-from-a-cell-into-another-cell-room-inventory-template-new
Sheet: 16 Tables

 | Inventory Count: |  |  |  |  |  |  | TABLE COUNT DATA
 | As of: |  |  | Cultivar | # of Tables |  |  | Table | BPR # | Initial # Plants Plugged | Kill | Current room Count | Harvest Amount | Harvest Date | Density | BPR Variation | Pinched
 |  |  |  |  |  |  |  | 1
 | Plug Date: |  |  |  |  |  |  | 2
 | Cycle: |  |  |  |  |  |  | 3
 | Room: |  |  |  |  |  |  | 4
 | Status: | Flower |  |  |  |  |  | 5
 | Estimated Harvest Date |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 | Room Total Counts |  |  |  |  |  |  | 8
 | Cultivar | Biotrack Count | Room Count | [NAME] | Initial # Plugged | % Remaining |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 | Total |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | Total
 | Room Activity
 | Date | Table | BPR # | Activity | Quantity
Spreadsheet: 111975d1308176446-the-row-number-of-the-last-cell-containing-a-particular-item-sample-worksheet-modified-
Sheet: Sheet1

B
C
A
 |  | Last Row containing:
D |  | A | 14
B |  | B | 11
A |  | C | 2
 |  | D | 10
D |  | E | 13
B
E
A |  | I need a fomula to give me the row number of the last cell containg item B in the range $A$1:$A$20, which is (in this example) 11
Spreadsheet: fletcher_sturm__10988__1017 Cash Sheet
Sheet: Sheet1

2001-10-17 00:00:00
Cinergy |  |  |  | Entergy
 | bid | offer |  |  | bid | offer
 |  |  |  | 2001-10-18 00:00:00 | 20.75 | 22
2001-10-18 00:00:00 | 23 | 24 |  | 2001-10-19 00:00:00 | 19 | 20.5
2001-10-19 00:00:00 | 21.2 | 21.85 |  | Oct 22-Oct 31, 2001 | 19.5 | 20.5
Oct 22-Oct 31, 2001 | 21.5 | 22.5 |  | November, 2001 | 20.5 | 21.2
November, 2001 | 22.5 | 23.25 |  | December, 2001 | 21.4 | 22.15
December, 2001 | 25.25 | 25.95 |  | Jan/Feb 2002 | 24.1 | 24.85
Jan/Feb 2002 | 28.1 | 28.75 |  | March/April , 2002 | 23.2 | 24
Cal 2001 | 31.75 | 32.5 |  | May, 2002 | 25 | 25.8
March/April , 2002 | 26 | 26.75 |  | June, 2002 | 34.25 | 35.15
May, 2002 | 28 | 29 |  | July/August, 2002 | 43.75 | 45.25
June, 2002 | 37.5 | 38.5 |  | Sept, 2002 | 23 | 24
July/August, 2002 | 49.5 | 50.5 |  | Q4, 2002 | 24 | 25
Sept, 2002 | 25.75 | 26.55 |  | Jan/Feb, 2003 | 25.9 | 26.8
Q4, 2002 | 26.7 | 27.5 |  | March/April, 2003 | 25.4 | 26.4
Cal 2003 | 32.15 | 32.85 |  | July/August, 2003 | 41 | 42
Cal 2004 | 32.4 | 34.1 |  | Q4, 2003 | 26 | 27.3
Cal 2005 | 32.15 | 34.3 |  | Cal, 2004 | 30.4 | 32.3
Comed |  |  |  | TVA
 | bid | offer |  |  | bid | offer
 |  |  |  | 2001-10-18 00:00:00 | 22.25 | 23.5
 |  |  |  | 2001-10-19 00:00:00 | 21.5 | 22.75
2001-10-18 00:00:00 | 21 | 21.75 | 117 | Oct 22-Oct 31, 2001 | 21 | 22
2001-10-19 00:00:00 | 20 | 21
Oct 22-Oct 31, 2001 | 21 | 21.85 |  | November, 2001 | 21.5 | 22.6
November, 2001 | 21.6 | 22.4 |  | December, 2001 | 24.15 | 25
December, 2001 | 23.5 | 24.2 |  | Jan/Feb 2002 | 27.15 | 28
Jan/Feb 2002 | 26.5 | 27.3 |  | Cal 2002 | 30.75 | 32
Jul/Aug 2002 | 48 | 49 |  | March/April , 2002 | 25.25 | 26.2
 |  |  |  | May, 2002 | 27.25 | 28.75
 |  |  |  | June, 2002 | 36.25 | 37.5
 |  |  |  | July/August, 2002 | 47.75 | 49
 |  |  | 26.5 | Sept, 2002 | 24.7 | 25.5
 |  |  |  | Q4, 2002 | 25.2 | 26.5
 |  |  |  | Cal 2003
PJM |  |  |  | SOCO
 | bid | offer |  |  | bid | offer
 |  |  | 52.75 | 2001-10-18 00:00:00 | 26.5 | 27.25
November, 2001 | 26.25 | 27.25 |  | Oct 22-Oct 31, 2001 | 26.6 | 27.4
December, 2001 | 28.8 | 29.4 |  | November, 2001 | 26.4 | 27.15
 |  |  |  | December, 2001 | 28 | 28.75
Jan/Feb 2002 | 32.75 | 34 |  | Jan/Feb 2002 | 30.7 | 31.4
Cal 2002 |  |  |  | Cal 2002
March/April , 2002 | 30.75 | 31.55 |  | March/April , 2002 | 28.3 | 29
May, 2002 | 34 | 35 |  | May, 2002 | 31 | 31.8
June, 2002 | 44 | 45 | 91 | June, 2002 | 41.4 | 42
July/August, 2002 | 55.75 | 57 |  | July/August, 2002 | 51.85 | 52.8
Sept, 2002 | 30.15 | 31 |  | Sept, 2002 | 27.1 | 27.9
Q4, 2002 | 30.25 | 31 |  | Q4, 2002 | 27.15 | 27.8
Cal 2003 | 37 | 38.25 |  | Jan/Feb 2003 | 31 | 32
Cal 2004 | 37.5 | 39.25 |  | March/April, 2003 | 29 | 30
 |  |  |  | May, 2003 | 31 | 32
 |  |  |  | June, 2003 | 40.6 | 41.6
Spreadsheet: 101781d1299820866-counting-names-snoopdilla
Sheet: Sheet1

Name | total | mondays | fridays | saturdays
bob
[NAME]
[NAME]
ned
bill
[NAME]
sara
tiff
liz