tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862079d1709852607-beginner-trouble-sorting-bilateral-trade-paper-tms
Sheet: EC440 (3)

Herzog, Blake Richard
[EMAIL] | Structured Table: | Table1
 | vvvvvvvvvvvvvvvvv
Country Name | Country Code | Home | Dist | U.S GDP Trillions | Foreign GDP | Foreign GDP (Trillions) | Exports(millions) | Exports(trillions) | Predicted Trade | Actual Trade | Gravity Term
Armenia | ARM | USA | 9088.867 | 21.38 | 13619290539 | 0.001361 | 52.9
Australia | AUS | USA | 16008.79 | 21.38 | 1394670000000 | 1.39467 | 25875.48
Bahrain | BHR | USA | 10643.58 | 21.38 | 38653318085 | 0.003865 | 1406.46
Belarus | BLR | USA | 7125.836 | 21.38 | 64410122847 | 0.00644101 | 125.11
Bolivia | BOL | USA | 6400.357 | 21.38 | 40895322851 | 0.0040895 | 552.27
Switzerland | CHE | USA | 6272.285 | 21.38 | 721369000000 | 0.721369 | 17987.25
Costa Rica | CRI | USA | 3564.9 | 21.38 | 64417670521 | 0.0064417 | 6219.63
Denmark | DNK | USA | 6191.893 | 21.38 | 346499000000 | 0.346 | 3195.19
Dominican Republic | DOM | USA | 2508.955 | 21.38 | 88941372558 | 0.008894 | 9208
Estonia | EST | USA | 6653.48 | 21.38 | 31081901909 | 0.0311 | 410.66
United Kingdom | GBR | USA | 5570.161 | 21.38 | 2851410000000 | 2.85 | 69079.94
Georgia | GEO | USA | 8980.505 | 21.38 | 17470436259 | 0.0175 | 768.65
Ireland | IRL | USA | 5117.716 | 21.38 | 398933000000 | 0.399 | 9796.56
Iraq | IRQ | USA | 9651.111 | 21.38 | 233636000000 | 0.234 | 1189.17
Jamaica | JAM | USA | 2549.896 | 21.38 | 15830766571 | 0.0158 | 2480.26
Cambodia | KHM | USA | 14208.13 | 21.38 | 27089390033 | 0.0271 | 513.94
Kuwait | KWT | USA | 10209.52 | 21.38 | 136192000000 | 0.136 | 3170.73
Lithuania | LTU | USA | 6956.313 | 21.38 | 54808531641 | 0.0548 | 933.93
Malaysia | MYS | USA | 15130.12 | 21.38 | 365178000000 | 0.365 | 13193.72
Nigeria | NGA | USA | 8493.132 | 21.38 | 474517000000 | 0.475 | 3198.11
Norway | NOR | USA | 5916.703 | 21.38 | 408743000000 | 0.409 | 3897.34
Panama | PAN | USA | 3580.789 | 21.38 | 69721787500 | 0.0697 | 7537.82
Peru | PER | USA | 5890.553 | 21.38 | 228326000000 | 0.228 | 9658.28
Portugal | PRT | USA | 5425.189 | 21.38 | 239987000000 | 0.24 | 1715.6
Sudan | SDN | USA | 10225.49 | 21.38 | 32338079165 | 0.0323 | 74.09
Senegal | SEN | USA | 6157.48 | 21.38 | 23403995992 | 0.0234 | 196.74
Serbia | SRB | USA | 8998 | 21.38 | 51514242939 | 0.0515 | 150.72
Tunisia | TUN | USA | 7023.72 | 21.38 | 419905540184 | 0.42 | 460.82
Uruguay | URY | USA | 8617.354 | 21.38 | 62048585619 | 0.062 | 1616.18
Zambia | ZMB | USA | 12156.13 | 21.38 | 23308667781 | 0.0233 | 99.46
Spreadsheet: 0aae3a7b-1b4d-4deb-8dfc-cd6979c04930
Sheet: Sheet1

Teaching Roles and Responsibilities | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Please insert additional rows as needed or format the table to suit your needs.
Intramural
Date | [NAME] | Role | Audience
Extramural
Date | [NAME] | Role | Audience
Type of program may include small groups, lectures, grand rounds, postgraduate courses,CME activities,
invited lectures or clinical teaching..
Role may include lecturer, small group facilitator, evaluator, clinical supervisor/preceptor (e.g. SPA), etc.
Audience may Include medical students, graduate students, residents, practicing physicians, etc.
Mentoring, advising and supervision
Date | Name of advisee | Your role | Comment
Include medical student, resident or clinical fellow and/or graduate student or post-doctoral fellow supervision
Mentorship of faculty members may be included here.
This should reflect specific supervisory or advising roles, rather than general supervision.
Spreadsheet: 545151d1509303563-if-formula-error-sample-workbook-for-if-formula-error
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULTS
 | Name | Category | Period |  |  | Count | Name | Category | Period | All |  | Name | Category | Period | All
 | B | ABC | Full Year | 1 |  |  |  |  |  |  |  | B | ABC | Full Year | 1
 | B | CED | Full Year | 2 |  |  |  |  |  |  |  | B | ABC | Full Year | 1
 | B | DEF | Full Year | 3 |  |  |  |  |  |  |  | B | CED | Full Year | 2
 | B | GHI | Full Year | 4 |  |  |  |  |  |  |  | B | DEF | Full Year | 3
 | B | JKL | Full Year | 5 |  |  |  |  |  |  |  | B | GHI | Full Year | 4
 | B | MNO | Full Year | 6 |  |  |  |  |  |  |  | B | JKL | Full Year | 5
 | B | PQR | Full Year | 7 |  |  |  |  |  |  |  | B | MNO | Full Year | 6
 | A | ABC | Full Year | 8 |  |  |  |  |  |  |  | B | PQR | Full Year | 7
 | A | CED | Full Year | 9 |  |  |  |  |  |  |  | A | ABC | Full Year | 8
 | A | DEF | Full Year | 10 |  |  |  |  |  |  |  | A | CED | Full Year | 9
 | A | GHI | Full Year | 11 |  |  |  |  |  |  |  | A | DEF | Full Year | 10
 | A | JKL | Full Year | 12 |  |  |  |  |  |  |  | A | GHI | Full Year | 11
 | A | MNO | Full Year | 13 |  |  |  |  |  |  |  | A | JKL | Full Year | 12
 | A | PQR | Full Year | 14 |  |  |  |  |  |  |  | A | MNO | Full Year | 13
 | C | ABC | Full Year | 15 |  |  |  |  |  |  |  | A | PQR | Full Year | 14
 | C | CED | Full Year | 16 |  |  |  |  |  |  |  | C | ABC | Full Year | 15
 | C | DEF | Full Year | 17 |  |  |  |  |  |  |  | C | CED | Full Year | 16
 | C | GHI | Full Year | 18 |  |  |  |  |  |  |  | C | DEF | Full Year | 17
 | C | JKL | Full Year | 19 |  |  |  |  |  |  |  | C | GHI | Full Year | 18
 | C | MNO | Full Year | 20 |  |  |  |  |  |  |  | C | JKL | Full Year | 19
 | C | PQR | Full Year | 21 |  |  |  |  |  |  |  | C | MNO | Full Year | 20
 |  |  |  |  |  |  |  |  |  |  |  | C | PQR | Full Year | 21
 | TOTAL
Spreadsheet: 863763d1711141302-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-dj
Sheet: Game 5

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00 |  |  |  |  | #[NAME]!
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1) |  |  | [NAME] | 44
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  | 6 | C (2) |  | Ty | Cobb | 2
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  | 6 | 1B (3) |  | [NAME] | Gehrig | 4
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  | 6 | 2B (4) |  | [NAME] | Henerson | 22
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  | 6 | 3B (5) |  | [NAME] | Mantle | 7
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  | 6 | SS (6) |  | Willie | Mays | 24
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  | 6 | LF (7) |  | [NAME] | Musial | 6
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  | 6 | CF (8) |  | [NAME] | [NAME] | 20
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  | 6 | RF (9) |  | Babe | [NAME] | 3
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  | 6 | SF (10) |  | [NAME] | [NAME] | 20
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  | 6 | EH () |  | [NAME] | [NAME] | 9
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 768591d1645038945-highlight-the-greater-value-between-2-columns-and-if-the-value-in-both-columns-are-th-highlight-higher-value
Sheet: Sheet1

COL1 | COL2
1 | 5
2 | 1
3 | 7
4 | 4
5 | 3
6 | 10
7 | 11
8 | 2
9 | 13
10 | 14
11 | 1
Spreadsheet: 12583ebb-1938-4cad-9475-353548f12a0e
Sheet: Figure 5

 |  | Statewide District | Statewide Charter
Percentage of stuents eligible for free or reduced price lunch |  | 0.302 | 0.533
Percentage of schools eligible for Title 1 |  | 0.332 | 0.497
Percent of students by school type
 | Primary (K-5) | 0.452 | 0.504
 | Middle (6-8) | 0.184 | 0.071
 | High (9-12) | 0.334 | 0.27
 | Other (K-12,K-8, etc.) | 0.029 | 0.156
Spreadsheet: 139563d1328303462-excel-2007-vlookup-worktabs-vlookup-within-worktabs-book1
Sheet: Summary

 | [NAME] | Term Sheet | Ranking Sheet | Two Pager |  | [NAME] | Presentations | ODD Report | Audited Financial Statements |  | News Articles | Mgr Call Report |  |  | Comments
A
B
C
D
E
 | KEY:
 | Y | Yes, item is in the binder and looks good
 | Y- | Yes, item in the binder is outdated
 | X | Item is missing entirely from the binder
Spreadsheet: 3806b6ad-d7f4-4d58-b6dd-cb821b87dab9
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
43117549 | 2014-09-11 22:07:32 | AXIS | 1 | 10 | 5 | 1610781 | Blood'nguts | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43118086 | 2014-09-11 22:28:37 | ALLIES | 1 | 7 | 5 | 1610781 | Blood'nguts | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43118389 | 2014-09-11 22:49:26 | AXIS | 1 | 7 | 4 | 1610781 | Blood'nguts | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43118786 | 2014-09-11 23:05:05 | ALLIES | 0 | 1 | 6 | 1610781 | Blood'nguts | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
43212931 | 2014-09-18 19:17:28 | AXIS | 1 | 6 | 5 | 333660 | Per-power | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
Spreadsheet: 92683d1292256371-sumproduct-using-date-range-on-time-test
Sheet: All Depts

 |  | 2011-01-01 00:00:00 | 2011-01-16 00:00:00
 |  | 2011-01-15 00:00:00 | 2011-01-31 00:00:00
 | Jan
Dept | # Due | # Overdue  (1-15) | # Overdue (16-31) | Total Overdue | Monthly On Time %
Total | 19 | #N/A | #N/A | #N/A
100 | 7 | #N/A | #N/A | #N/A
101 | 0 | #N/A | #N/A | #N/A
102 | 1 | #N/A | #N/A | #N/A
103 | 1 | #N/A | #N/A | #N/A
104 | 3 | #N/A | #N/A | #N/A
105 | 2 | #N/A | #N/A | #N/A
106 | 1 | #N/A | #N/A | #N/A
107 | 1 | #N/A | #N/A | #N/A
108 | 1 | #N/A | #N/A | #N/A
109 | 1 | #N/A | #N/A | #N/A
110 | 1 | #N/A | #N/A | #N/A
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Oct21-Oct27p

Pavilion
 | 2012-10-21 00:00:00 |  |  | Thru | 2012-10-27 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-10-21 00:00:00 | 2012-10-22 00:00:00 | 2012-10-23 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 2012-10-27 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 869607d1716216169-help-with-damage-tracker-formulas-please-test-file-16-aligw
Sheet: Damage

 | Operative: | Date: | Reason:
 | [NAME] | 2022-09-27 00:00:00
 | Aleks | 2022-09-27 00:00:00
 | [NAME] | 2022-09-20 00:00:00
 | Oleg | 2022-06-08 00:00:00
 | [NAME] | 2022-09-06 00:00:00
 | Oleg | 2022-07-06 00:00:00
 | [NAME] | 2022-08-16 00:00:00 |  |  |  | Name: | Days since last Damage | Excel 2019 | Excel 365
 | [NAME] | 2022-08-16 00:00:00 |  |  |  | [NAME]
 | [NAME] | 2022-10-04 00:00:00 |  |  |  | [NAME] | 11
 | [NAME] | 2022-10-24 00:00:00 |  |  |  | Aleks Sinicins
 | [NAME] | 2022-10-25 00:00:00 |  |  |  | [NAME]
 | [NAME] | 2022-10-25 00:00:00 |  |  |  | [NAME]
 | [NAME] | 2022-10-28 00:00:00 |  |  |  | Nick
 | [NAME] | 2022-11-22 00:00:00 |  |  |  | Donatas
 | Nick | 2022-12-15 00:00:00 |  |  |  | [NAME] | No recorded damage
2023
 | [NAME] | 2023-01-10 00:00:00
 | [NAME] | 2023-01-16 00:00:00
 | Aleks | 2023-01-20 00:00:00
 | [NAME] | 2023-01-24 00:00:00
 | Aleks | 2023-01-27 00:00:00
 | [NAME] | 2023-02-07 00:00:00
 | Nick | 2023-02-10 00:00:00 |  |  |  | Unique name
 | Donatas | 2023-03-02 00:00:00 |  |  |  | [NAME]
 | [NAME] | 2023-03-13 00:00:00 |  |  |  | [NAME]
 | [NAME] | 2023-03-21 00:00:00 |  |  |  | Aleks
 | Aleks | 2023-03-21 00:00:00 |  |  |  | [NAME]
 | Nick | 2023-03-25 00:00:00 |  |  |  | [NAME]
 | [NAME] | 2023-05-25 00:00:00 |  |  |  | Nick
 | Donatas | 2023-05-31 00:00:00 |  |  |  | Donatas
 | Nick | 2023-06-20 00:00:00 |  |  |  | [NAME]
 | [NAME] | 2023-07-13 00:00:00
 | [NAME] | 2023-07-17 00:00:00
 | Nick | 2023-07-25 00:00:00
 | [NAME] | 2023-08-09 00:00:00
 | Aleks | 2023-08-16 00:00:00
 | Aleks | 2023-08-16 00:00:00
 | Aleks | 2023-08-31 00:00:00
 | [NAME] | 2023-09-05 00:00:00
 | Nick | 2023-10-18 00:00:00
? | Nick | 2023-10-26 00:00:00
 | [NAME] | 2023-12-06 00:00:00
2024
 | [NAME] | 2024-02-05 00:00:00
 | Donatas | 2024-03-01 00:00:00
 | [NAME] | 2024-03-04 00:00:00
 | [NAME] | 2024-03-08 00:00:00
 | Aleks | 2024-04-08 00:00:00
 | [NAME] | 2024-04-18 00:00:00
 | [NAME] | 2024-05-05 00:00:00
 | [NAME] | 2024-05-09 00:00:00
Spreadsheet: 120787d1315514572-totaling-uneven-line-items-example1
Sheet: Sheet1

Company | Item | Price
Coke | Laptop | 900
Coke | Keyboard | 45
Coke | [NAME] | 200
Apple | [NAME] | 200 |  | So basically I need to find a subtotal for Coke, Apple, Micosoft, Home Depot, & Delta all separately without having to do it manually. Any ideas?
Apple | Keyboard | 45
Microsoft | Laptop | 900
Home Depot | Laptop | 900
Home Depot | [NAME] | 200
Home Depot | Keyboard | 45
Home Depot | Keyboard | 45
Delta | Laptop | 900
Delta | [NAME] | 200
What I want
Coke | Total | 1145
Apple | Total | 245
Microsoft | Total | 900
Home Depot | Total | 1190
Delta | Total | 1100
Spreadsheet: 157659d1337822173-simplify-copy-column-removing-non-zero-values-formula-approach-book1
Sheet: Sheet1

Name | Value | Helper | [NAME] | Value
Name1 | 0 |  | [NAME] | 10
[NAME] | 10 | 7 | Name3 | 12
Name3 | 12 | 8 | Name5 | 1
Name4 |  |  | Name6 | -10
Name5 | 1 | 10 | Name7 | 12
Name6 | -10 | 11 | Name10 | 1
Name7 | 12 | 12
Name8 | 0
Name9 | 0
Name10 | 1 | 15
^- List includes blank cells at end
Spreadsheet: 86043d1286011326-ignoring-blank-cells-in-a-chart-cash-deposits-and-orders-sample-4-
Sheet: 09-21-10

CASH ORDER
Denomination |  | 2010-09-21 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 4696600 |  | 1206100
20 |  | 3941740 |  | 901860
10 |  | 97540 |  | 0
5 |  | 658105 |  | 243725
1 |  | 170781 |  | 54755
0.25 |  | 16208 | 12194 | 0 |  |  | 5000
0.05 |  | 4920 | 1203 | 0 |  |  | 1400
0.01 |  | 852 | 386 | 0 |  |  | 300
Total
Spreadsheet: 858071d1706845056-enter-first-date-of-the-year-only-and-will-populate-the-rest-of-the-months-calendar-test
Sheet: May

 |  |  | WK No. |  | 18 | 18 | 18 | 18 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 22 | 22 | 22 | 22 | 22
 |  |  | Day |  | 2024-05-02 00:00:00 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00 | 2024-05-05 00:00:00 | 2024-05-06 00:00:00 | 2024-05-07 00:00:00 | 2024-05-08 00:00:00 | 2024-05-09 00:00:00 | 2024-05-10 00:00:00 | 2024-05-11 00:00:00 | 2024-05-12 00:00:00 | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00 | 2024-05-16 00:00:00 | 2024-05-17 00:00:00 | 2024-05-18 00:00:00 | 2024-05-19 00:00:00 | 2024-05-20 00:00:00 | 2024-05-21 00:00:00 | 2024-05-22 00:00:00 | 2024-05-23 00:00:00 | 2024-05-24 00:00:00 | 2024-05-25 00:00:00 | 2024-05-26 00:00:00 | 2024-05-27 00:00:00 | 2024-05-28 00:00:00 | 2024-05-29 00:00:00 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00
 |  |  |  |  | 2024-05-02 00:00:00 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00 | 2024-05-05 00:00:00 | 2024-05-06 00:00:00 | 2024-05-07 00:00:00 | 2024-05-08 00:00:00 | 2024-05-09 00:00:00 | 2024-05-10 00:00:00 | 2024-05-11 00:00:00 | 2024-05-12 00:00:00 | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00 | 2024-05-16 00:00:00 | 2024-05-17 00:00:00 | 2024-05-18 00:00:00 | 2024-05-19 00:00:00 | 2024-05-20 00:00:00 | 2024-05-21 00:00:00 | 2024-05-22 00:00:00 | 2024-05-23 00:00:00 | 2024-05-24 00:00:00 | 2024-05-25 00:00:00 | 2024-05-26 00:00:00 | 2024-05-27 00:00:00 | 2024-05-28 00:00:00 | 2024-05-29 00:00:00 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00
Spreadsheet: 97640d1296759133-show-rows-from-other-sheet-based-on-criteria-table-tennis-results-refined
Sheet: OVERALL STATS

Liverpool Table Tennis League (LiTTLe)
Latest Results
Standings current as of:
OVERALL
PLAYER | GAMES | W | L | PCT. | PF | PA | TOTAL POINTS PLAYED | PFPG | POINTS DIFF. | PPG IN LOSSES | % OF GAMES OT | OT W | OT L | WINNING % IN OT | HIGH SCORE | LOW SCORE
Sheldon
[NAME]
[NAME]
Al
HEAD-TO-HEAD
DAVE | VS:
PLAYER | GAMES | W | L | PCT. | PF | PA | TOTAL POINTS PLAYED | PFPG | POINTS DIFF. | PPG IN LOSSES | % OF GAMES OT | OT W | OT L | WINNING % IN OT
Al
Sheldon
[NAME]
SHELDON | VS:
PLAYER | GAMES | W | L | PCT. | PF | PA | TOTAL POINTS PLAYED | PFPG | POINTS DIFF. | PPG IN LOSSES | % OF GAMES OT | OT W | OT L | WINNING % IN OT
Al
[NAME]
[NAME]
COLIN | VS:
PLAYER | GAMES | W | L | PCT. | PF | PA | TOTAL POINTS PLAYED | PFPG | POINTS DIFF. | PPG IN LOSSES | % OF GAMES OT | OT W | OT L | WINNING % IN OT
[NAME]
Sheldon
Al
AL | VS:
PLAYER | GAMES | W | L | PCT. | PF | PA | TOTAL POINTS PLAYED | PFPG | POINTS DIFF. | PPG IN LOSSES | % OF GAMES OT | OT W | OT L | WINNING % IN OT
[NAME]
[NAME]
Sheldon
Spreadsheet: 777462d1650392824-counting-distinct-values-within-a-date-range-feeod-sample
Sheet: visits Vs issues

Row Labels | Count of Site ID
Central | 3
other | 2
TMO (replacement) | 1
West | 6
other | 1
TMO (access) | 1
TMO (replacement) | 2
TMO (Transport) | 2
Grand Total | 9
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: Lisas mobile

Orange | Lisas Mobile
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009
April | 2009 | 80.76
May | 2009 | 30.15
June | 2009 | 35.43
July | 2009 | 90.71
August | 2009 | 14.93 | 62.93
September | 2009 | 15 | 30
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 269590d1381224834-out-of-the-box-is-there-a-functionality-to-tell-how-well-cells-look-like-each-other-fuzzy-search-using-helpers
Sheet: Sheet2

Name1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | %Dif
Wabush Hotel Limited | Hotel Wabush Limited |  | Test
Community Recreation Rebroading Service Association | Re-Broading Community Recreation Service Assoc
Test1 Test2 Test3 | Test3 Test1 Test2
Test1 Test2 Test3 | Test3 Test5 Test9
Downing Street 10 | 10, Downing Street
Downing Street 10 | Oxford Street 1
Spreadsheet: 117793d1313019748-using-data-validation-to-specify-cell-selection-cb-test
Sheet: Club_Info

 |  | Copper Blues | COPPER BLUES | Date Starting | 2011-08-08 00:00:00
 |  | Servers |  | BAR
 | 1 | [NAME] | 1
 | 2 | [NAME] | 2
 | 3 | Suzie | 3
 | 4 | [NAME] | 4
 | 5 | Ethel | 5
 | 6 |  | 6
 | 7 |  | 7
 | 8 |  | 8
 | 9 |  | 9
 | 10 |  | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
Spreadsheet: 18424beb-a0d3-49b8-95f0-2fd50b816e64
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
selected from | 454 results | 454 results | aCGH results | aCGH/454 results | aCGH results
target | REXO1L | 7SK | 27 ZNF | FRG2C | FRG2B
BAC | RP11-90G23 | RP11-173M10 | RP11-44B13 | RP11-89H10 | RP11-413F20
 | 8q21.2 | 13q21.1 | 19q13.12 | 3p12.3 | 10q26.3
HeLa (alleles/cells) | 120/39 | 155/41 | 126/42 | 84/43 | 125/42
% alleles | 23.3 | 27.1 | 36.5 | 36.9 | 32
% cells | 64.1 | 80.5 | 73.8 | 65.1 | 73.8
IMR90 (alleles/cells) | 82/41 | 87/44 | 80/41 | 89/44 | 84/42
% alleles | 31.7 | 28.7 | 42.5 | 25.8 | 23.8
% cells | 56.1 | 50 | 70.7 | 47.7 | 40.5
 |  | literature |  |  |  | literature
control | REXO1 | 5S | ZNF557 | FRG2C ctrl | FRG2B ctrl | X cen
BAC | RP11-81M8 | RP5-915N17 | RP11-1137G4 | RP11-89O2 | RP11-123G19 | RP11-434B14
 | 19p13.3 | 1q42.13 | 19p13.3 - 19p13.2 | 3p14.1 | 10q24.1 | Xq11.1
HeLa (alleles/cells) | 116/39 | 246/84 | 130/42 | 84/43 | 127/42 | 80/40
% alleles | 6.1 | 24 | 11.5 | 15.5 | 13.4 | 32.5
% cells | 15.4 | 56 | 33.3 | 27.9 | 38.1 | 55
IMR90 (alleles/cells) | 82/41 | 82/41 | 81/41 | 90/44 | 84/42 | 91/44
% alleles | 8.5 | 6.1 | 19.8 | 13.3 | 7.1 | 25.3
% cells | 17.1 | 12.2 | 34.1 | 27.3 | 16.7 | 43.2
 |  | REXO1L | REXO1 | 5S
 |  | RP11-90G23 | RP11-81M8 | RP5-915N17
 |  | 8q21.2 | 19p13.3 | 1q42.13
Pol II inhibition (alleles/cells) |  | 117/40 | 103/40 | 117/40
 | % alleles | 10.3 | 3.9 | 5.1
 | % cells | 30 | 10 | 15
Pol II+III inhibition (alleles/cells) |  | 112/40 | 112/41 | 115/41
 | % alleles | 11.6 | 2.7 | 8.7
 | % cells | 27.5 | 7.3 | 19.5
Pol I inhibition (alleles/cells) |  | 117/40 | 102/40 | 115/40
 | % alleles | 16.2 | 1 | 7
 | % cells | 35 | 2.5 | 20 |  | Table S7
Spreadsheet: 106214d1303395971-extract-data-between-two-dates-copy-of-data_ex
Sheet: Sheet1

Date | Value | Remark
2001-04-01 00:00:00 | 50 | abc | 1 | 4
2001-04-02 00:00:00 | 30 | bbb | 2
2001-08-03 00:00:00 | 25 | ddd | 3
2002-05-04 00:00:00 | 10 | ggg
2002-12-08 00:00:00 | 15 | ttt
2001-04-07 00:00:00 | 39 | iii | 4
2003-11-09 00:00:00 | 40 | uuu
Spreadsheet: 166762d1341777205-excel-2007-unique-list-of-names-seperated-by-dashes-in-a-column-splitand-transposeuniquenames
Sheet: Sheet1

Data |  | Text to Columns |  |  |  |  | Index the result |  |  |  |  |  | Result
[NAME] |  | [NAME] | george | [NAME] |  |  |  |  | 2.005 |  |  | 2.005 | [NAME]
george |  | george |  |  |  |  |  |  |  |  |  | 4.003 | eva
eva -george |  | eva | george |  |  |  | 4.003 | 4.004 |  |  |  | 4.004 | george
[NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] |  | 5.003 | 5.004 | 5.005 | 5.006 |  | 5.003 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 5.004 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 5.005 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 5.006 | [NAME]
Spreadsheet: 692005d1598009670-top-10-values-from-database-example1836
Sheet: order

Order |  |  |  |  |  |  |  | cell link |  |  |  | order | Material | Total Value | currency
600006 |  |  |  |  |  |  |  | 2 |  |  | 1
600021 |  |  |  |  |  |  |  |  |  |  | 2
600275 |  |  |  |  |  |  |  |  |  |  | 3
600284 |  |  |  |  |  |  |  |  |  |  | 4
600320 |  |  |  |  |  |  |  |  |  |  | 5
600325 |  |  |  |  |  |  |  |  |  |  | 6
600326 |  |  |  |  |  |  |  |  |  |  | 7
600364 |  |  |  |  |  |  |  |  |  |  | 8
600431 |  |  |  |  |  |  |  |  |  |  | 9
600447 |  |  |  |  |  |  |  |  |  |  | 10
600464
600499
600502
600525
600547
600552
600555
600557
600563
600564
600566
600585
600592
600593
600597
600599
600600
600603
600616
600617
600621
600623
600631
600632