tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 148350d1333371610-top-25-list-from-data-set-temp
Sheet: Summary

 | Top 25 accounts
 | 01 |  | equals nothing as there is more black cells than filled cells
 | 02 |  | added -1 to end of [NAME] count to get it to calculate the second most frequent count but it errors on text over 1 character long
 | 03 |  | [NAME] to large and changed K to 3 to get 3rd largest value
 | 04
 | 05
 | 06
 | 07
 | 08
 | 09
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 758808d1639072720-sum-frequency-within-a-date-range-count-events-in-range-test
Sheet: Sheet1

Counting "T" Events within Last Year from Today |  |  |  |  |  |  |  |  |  |  |  | Count IF within this range
 |  |  |  |  |  |  |  |  |  |  |  | Today | Today Minus a Year
 |  | All these won't count |  |  | All these events will count |  |  |  |  |  |  |  |  |  | Count "T" within range working |  |  | Count Frequency of "T Events" not working, expected results shown
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count within Range |  |  | Expected Results
 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10
 |  |  |  |  |  |  |  |  |  |  |  | COUNT T | Count T / X Events |  | Count T | Count T / X Events |  | Count T | Count T / X Events
 | Name 1 | T | X | X | T |  | T |  |  |  |  |  |  |  |  |  |  |  | 2
 | Name 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Name 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Name 4 | T |  |  |  | T | T | T |  |  |  |  |  |  |  |  |  |  | 1
 | Name 5 | T | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Name 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Name 7 | T |  |  |  |  | T |  |  |  |  |  |  |  |  |  |  |  | 1
 | Name 8 |  |  |  | T | X | T |  |  |  |  |  |  |  |  |  |  |  | 1
 | Name 9 |  | T |  |  | T |  |  |  | T |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count T within range is working
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count T / X Events within range isn't working
Spreadsheet: 723010d1615478049-need-to-count-number-of-records-by-month-excel-question
Sheet: Dashboard

 |  | Total Orders | Late Orders | OTD %
 | Jan | how many orders with a Jan date? | how many orders with a date = to today or earlier?
 | Feb | how many orders with a Feb date? |  |  | Using these columns as my date ranges (records to count)
 | Mar | how many orders with a [NAME] date? |  |  | Rev Start Date | Rev Finish Date
 | Apr |  |  |  | 2021-02-06 00:00:00 | 2021-02-18 00:00:00
 | May |  |  |  | 2021-02-11 00:00:00 | 2021-02-16 00:00:00
 | Jun |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 | Jul |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 | Aug |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 | Sep
 | Oct |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 | Nov |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 | Dec |  |  |  | 2021-12-01 00:00:00 | 2021-12-01 00:00:00
 |  |  |  |  | 2021-06-10 00:00:00 | 2021-06-14 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-02-04 00:00:00 | 2021-02-10 00:00:00
 |  |  |  |  | 2021-02-19 00:00:00 | 2021-02-23 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-22 00:00:00 | 2021-01-26 00:00:00
 |  |  |  |  | 2021-04-30 00:00:00 | 2021-05-04 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-03-20 00:00:00 | 2021-03-24 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-04-21 00:00:00 | 2021-04-21 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
 |  |  |  |  | 2021-01-01 00:00:00 | 2021-01-01 00:00:00
Spreadsheet: 759350d1639500291-month-to-date-over-prior-and-week-to-date-over-prior-automation-sum-dynamic-range-eba
Sheet: Sheet1

 | Date | Orders | Returns |  |  |  | Week to Date / Prior Week to Date | Month to Date / Prior Month to Date
 | 2021-11-01 00:00:00 | 1991 | 147 |  |  | Units Ordered
 | 2021-11-02 00:00:00 | 2332 | 105 |  |  | Units Returned
 | 2021-11-03 00:00:00 | 2038 | 111 |  |  | Return Rate
 | 2021-11-04 00:00:00 | 1843 | 103
 | 2021-11-05 00:00:00 | 1729 | 123
 | 2021-11-08 00:00:00 | 1862 | 120
 | 2021-11-09 00:00:00 | 2020 | 66
 | 2021-11-10 00:00:00 | 1861 | 162
 | 2021-11-12 00:00:00 | 1546 | 125
 | 2021-11-15 00:00:00 | 1773 | 78
 | 2021-11-16 00:00:00 | 1942 | 68
 | 2021-11-17 00:00:00 | 1772 | 136
 | 2021-11-18 00:00:00 | 1948 | 188
 | 2021-11-19 00:00:00 | 1645 | 115
 | 2021-11-22 00:00:00 | 1744 | 75
 | 2021-11-23 00:00:00 | 1841 | 165
 | 2021-11-24 00:00:00 | 1485 | 92
 | 2021-11-26 00:00:00 | 743 | 0
 | 2021-11-29 00:00:00 | 1636 | 104
 | 2021-11-30 00:00:00 | 1968 | 132
 | 2021-12-01 00:00:00 | 1903 | 155
 | 2021-12-02 00:00:00 | 1753 | 144
 | 2021-12-03 00:00:00 | 1602 | 135
 | 2021-12-06 00:00:00 | 1937 | 108
 | 2021-12-07 00:00:00 | 1805 | 123
 | 2021-12-08 00:00:00 | 1958 | 146
 | 2021-12-09 00:00:00 | 1887 | 143
 | 2021-12-10 00:00:00 | 1696 | 140
 | 2021-12-13 00:00:00 | 1779 | 127
Spreadsheet: 879574d1727167524-capture-data-from-multiple-sheets-sample-data
Sheet: 192-UVW

 |  |  | BU2424 | BU2525
PN | Supplier | Type | Total | Total
192S | 104 NNN | JJ | 20 | 30
192S | 104 NNN | JJ | 20 | 10
192S | 104 NNN | MM | 50 | 10
Spreadsheet: 759246d1639439312-time-between-two-dates-and-times-time-between-days-hours-mins
Sheet: Sheet1

 |  |  |  |  | Time
 |  |  | Day of |  | Between
 | Date Time |  | Week |  | Days/Hrs/Mins
Now |  |  |  |  | [h]:mm:ss | d hh:[NAME] |  |  |  |  | d m hh:[NAME] | Days | Hours
Future Date Time 01 | 2022-01-04 08:00:00
Future Date Time 02 | 2022-01-25 08:30:00 |  |  |  |  |  | <-- More then 30 days does not count right
Spreadsheet: 487812d1478264855-counting-occasions-of-data-sets-drummond
Sheet: Sheet1

2016-08-01 00:00:00 | 2016-08-02 00:00:00 | 2016-08-03 00:00:00 | 2016-08-04 00:00:00 | 2016-08-05 00:00:00 | 2016-08-06 00:00:00 | 2016-08-07 00:00:00 | 2016-08-08 00:00:00 | 2016-08-09 00:00:00 | 2016-08-10 00:00:00 | 2016-08-11 00:00:00 | 2016-08-12 00:00:00 | 2016-08-13 00:00:00
S | S | S |  | S | S
Spreadsheet: 15c075c5-76a7-478f-b641-c335f182860d
Sheet: Sheet1

[NAME] zur Radbundesliga 2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | [NAME]
 |  | Landesverbands-Mannschaft |  |  | Vereinsmannschaft
 |  |  |  |  | Renngemeinschaft
Namentliche Nennung der [NAME] lt. Generalausschreibung bis spätestens zum 28. Februar 2012!
Offizieller Mannschaftsname:
 | Nr. | Zu- und [NAME] | [NAME] | Kader | UCI-Code* | Lizenz-Nr.
 | 1.
Min. | 2.
 | 3.
 | 4.
 | 5.
 | 6.
[NAME]. | 7.
 | 8.
 | 9.
 | 10.
Sportliche/r Leiter/in und [NAME]/in:
Nr. | Vor- und Nachname: |  | Adresse/E-mail: |  |  | Lizenz-Nr.:
1.
2.
Anschrift des verantwortlichen Ansprechpartners (bezügl. Schriftverkehr: Name, [NAME], Telefon, Fax, E-mail)
Name/Vorname:
Straße/Ort:
Telefon/Fax:
Handynummer:
E-mail:
Bankverbindung:
BLZ:
Konto-Nr.:
Nenngelder in Höhe von |  |  | Überweisung ([NAME] beifügen)
€ 250,- bezahlt durch:
[NAME]: Es wird ausdrücklich bestätigt, daß alle [NAME], [NAME] ihr Einverständnis zur Meldung gegeben haben, im Besitz einer gültigen Lizenz sind und die Generalausschreibung und das Reglement der Radbundesliga anerkennen.
Ort/Datum: |  |  | Unterschrift/Stempel:
 |  | BDR-Bankverbindungen: | Commerzbank AG Frankfurt/Main, Kto.-Nr. 5 100 677 00 (BLZ 500 800 00)
 | * UCI-Code setzt sich wie folgt zusammen: GER für Deutschland + Geburtsjahr + Monat + Tag (Bsp.: GER 19660508)
Formular zu senden an [EMAIL] in Digitalform und unterschrieben an die
Geschäftsstelle des BDR ([NAME] 4, 60528 Frankfurt/Main)
Spreadsheet: 156734d1337434546-finding-package-details-ykk-product-information-admin-copy
Sheet: Vlookup tables

 | [NAME] |  |  |  | [NAME]
 | 1 | 1 box of 8x8x12 |  | 1 | 1box of 8x8x8 | Smallest MOQ in b pack is 1M H60F361346B
 | 2 | 1 box of 6.75x14.5x4 |  | 2 | 1 box of 8x8x12
 | 3 | 1 box of 6.5x14.5x4
 | 4 | 1 box of 7.25x14.5x6.5
 | 5 | 1 box of 8x18.5x8
 | 6 | 1 box of 8x8x8
#of carton over 10 | 7 | 1 box of 15.5x18.5x8
11 | 8 | 1 box 8x18.5x8 and 1box 8x8x8
12 | 9 | 1 box 8x18.5x8 and 1box 8x8x8
13 | 10 | 1 box 8x18.5x8 and 1box 8x8x8
14 | 11 | 1 box 8x18.5x8 and 1box 8x8x8
15 | 12 | 1 box of 15.5x18.5x8
16 | 13 | 1 box of 15.5x18.5x8
17 | 14 | 1 box of 15.5x18.5x8
18 | 15 | 1 box of 15.5x18.5x8
19 | 16 | 1 box of 15.5x18.5x8
20 | 17 | 1 box of 15.5x18.5x8
 |  | # Of Cartons to a box
 | 1 | 6
 | 2 | 6
 | 3 | 6
 | 4 | 6
 | 5 | 1
 | 6 | 1
 | 7 | 5
 | 8 | 5
 | 9 | 5
 | 10 | 5
 | 11 | 8
 | 12 | 9
 | 13 | 10
 | 14 | 11
 | 15 | 12
 | 16 | 13
 | 17 | 14
 | 18 | 15
 | 19 | 16
 | 20 | 17
Spreadsheet: 841286d1693482128-find-unique-values-and-copy-them-to-another-tab-financial-administration-2023-tms
Sheet: Overview per quarter 2023

 | Exch. [NAME] | 4.7 | Exch. R. Q2 | 4.7 | Exch. [NAME] | 4.7 | Exch. R. Q4 | 4.7
General: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
January
February
March
Total Q1:
April
May
June
Total Q2:
In-decrease (%)
July
August
September
Total Q3:
In-decrease (%)
October
November
December
Total Q4:
In-decrease (%)
Total:
Projects
January
February
March
Total Q1:
April
May
June
Total Q2:
In-decrease (%)
July
August
September
Total Q3:
In-decrease (%)
October
November
December
Total Q4:
In-decrease (%)
Total:
Spreadsheet: 699956d1602854574-formula-to-extract-data-based-on-month-and-year-profits-br1
Sheet: Sheet2

 | Oct 2019 | Nov 2019 | Dec 2019 | Jan 2020 | Feb 2020 | Mar 2020 | Apr 2020 | May 2020 | Jun 2020 | Jul 2020 | Aug 2020 | Sep 2020
Net profit-Dep1
Net profit-Dep2
Net profit-Dep3
Spreadsheet: 16cde7b8-7c4c-4d3f-8eaa-9049c8288a8b
Sheet: Sheet1

Study Billing Coverage Analysis | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Protocol Title:
IRB-HSR #:
Investigator: |  |  |  |  |  | Study coordinator:
Sponsor(s): |  |  |  |  |  | Budget document reviewed? |  |  | (Yes, w/ version date No, N/A)
I have reviewed the content of this document and agree that it accurately reflects the terms and conditions of the final study budget:
Signature of Investigator: |  |  |  |  | Date: |  |  | SOM CTO: | (Name & phone)
Procedure | Screen | Day | Day | Day | Day | Day | Day | Day | Day | Day | Day | Day
 | Visit 1 | Visit 2 | Visit 3 | Visit 4 | Visit 5 | Visit 6 | Visit 7 | Visit 8 | Visit 9 | Visit 10 | Visit 11 | Visit 12
* Study service or procedure that generates no billable charge (provide explanation w/ footnote)
1 Study visits take place in research designated space
2 Study labs are shipped to the sponsor's central lab and are not processed by UVA Clinical lab; venipuncture performed by study team
3 EKGs are performed by the study team or GCRC and interpreted by PI or the sponsor's central reader
4 Scans sent for interpretation at sponsor's central location, no HSF professional charge
"Patient" - designates charges that are performed as standard of care that are appropriate to bill to a subject/insurance
"Study" - designates charges that are to be billed to the study PTAEO and are not to be billed to subject/insurance
Spreadsheet: dutch_quigley__9366__NEW POWER
Sheet: Sheet1

2001-07-01 00:00:00 | 3.7595
 | 3.8225
 | 3.8655
 | 3.9175
 | 4.124499999999999
 | 4.3275
 | 4.3945
 | 4.259499999999999
 | 4.054499999999999
 | 3.6245
 | 3.564500000000001
Spreadsheet: 34be31f8-2f36-417d-bee9-cef6610bfc8f
Sheet: Sheet1

Annual report | Name of  Centre | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Appendix:
[NAME]
Key Researchers
Name | Institution | Main research area
Visiting  Researchers
Name | Affiliation | Nationality | Sex M/F | Duration | Topic
Postdoctoral researchers with financial support from the Centre budget
Name | Nationality | Period | Sex M/F | Topic
Postdoctoral researchers working on projects in the centre with financial support from other sources
Name | Nationality | Period | Sex M/F | Topic
PhD students with financial support from the Centre budget
Name | Nationality | Period | Sex M/F | Topic
PhD students working on projects in the centre with financial support from other sources
Name | Funding | Nationality | Period | Sex M/F | Topic
Master degrees
Name | Sex M/F | Topic
Spreadsheet: 151725d1335089070-auto-populate-data-into-calendar-scheduler
Sheet: NextVisit

Name | Details | Next Visit
[NAME] | Cat 1 | 2012-03-21 00:00:00
[NAME] | Cat 3 | 2012-03-08 00:00:00
[NAME] | Cat 2 | 2012-04-05 00:00:00
[NAME] | Cat 1 | 2012-04-16 00:00:00
[NAME] | Cat 3 | 2012-03-21 00:00:00
Faye | Cat 1 | 2012-04-17 00:00:00
Lucas | Cat 1 | 2012-03-12 00:00:00
Pater | Cat 1 | 2012-03-29 00:00:00
Jave | Cat 2 | 2012-03-20 00:00:00
Norin | Cat 1 | 2012-06-10 00:00:00
Apple | Cat 3 | 2012-04-18 00:00:00
Fanny | Cat 1 | 2012-05-29 00:00:00
Wayne | Cat 2 | 2012-05-06 00:00:00
June | Cat 1 | 2012-06-13 00:00:00
Zan | Cat 2 | 2012-02-16 00:00:00
Mandy | Cat 3 | 2012-03-19 00:00:00
[NAME] | Cat 1 | 2012-03-19 00:00:00
[NAME] | Cat 3 | 2012-03-20 00:00:00
[NAME] | Cat 2 | 2012-04-18 00:00:00
[NAME] | Cat 1 | 2012-05-27 00:00:00
[NAME] | Cat 1 | 2012-05-20 00:00:00
[NAME] | Cat 3 | 2012-05-20 00:00:00
Kenny | Cat 2 | 2012-01-04 00:00:00
Lydia | Cat 1 | 2012-02-06 00:00:00
[NAME] | Cat 2 | 2012-04-26 00:00:00
Spreadsheet: 167000d1341860605-looking-up-a-range-of-data-in-relation-to-a-period-between-two-dates-staff-sickness-demo
Sheet: Sheet1

First Name | Second Name | Department | [NAME] | 1st Day of Absence | Last Day of absence | Number of days absent | Number of hours absent | total cost of absence
[NAME] | Smith | reception | 10 | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 | 2 |  | 0
[NAME] | Bloggs | reception | 10 |  |  | 0 |  | 0
[NAME] | Pan | reception | 10 |  |  | 0 |  | 0
[NAME] | Duck | attendent | 5 |  |  | 0 |  | 0
Spreadsheet: 130506d1322397180-help-needed-with-information-retrieval-lookup-from-another-worksheet-803230
Sheet: Bid Entry Sheet - ALL BIDS

 |  |  |  |  |  |  | Expected | Expected | Project | Project | % chance
Project Name |  |  | Scope / Progress / Notes |  |  |  | Revenue | Profit | Start | Duration | of confirming | Status
Project A |  |  | Restore Plumbing |  |  |  | 100100.1 | 10000 | 2011-01-01 00:00:00 | 2 weeks | 1 | Confirmed
Project B |  |  | Adjust infrastructure |  |  |  | 40000 | 5000 | 2011-01-11 00:00:00 |  | 0.2 | Development
Project C |  |  | CAD Designs Only |  |  |  | 50000 | 8000 | 2012-04-01 00:00:00 |  | 0.5 | Proposed
Project D |  |  | Build Shuttle System |  |  |  | 20000 | 2000 | 2011-11-01 00:00:00 |  | 0 | Lost
Project F |  |  | Adjust infrastructure and renovate |  |  |  | 250 | 100 | 2011-12-30 00:00:00 |  | 1 | Confirmed
Project G |  |  | Labor for Install |  |  |  | 100 | 20 | 2012-02-04 00:00:00 |  | 0.7 | Development
Project H |  |  | Build Tables |  |  |  | 900000 | 200000 | 2012-02-01 00:00:00 | 1 month | 1 | Confirmed
Project I |  |  | Build Cans |  |  |  | 400000 | 70000 | 2012-01-08 00:00:00 | 1 week | 0.3 | Proposed
Project J |  |  | Redesign for System |  |  |  | 2000 | 500 | 2012-03-05 00:00:00 |  | 0.5 | Proposed
Project K |  |  | Foundation Install |  |  |  | 55 | 20 | 2012-08-01 00:00:00 |  | 0.99 | Proposed
Project L |  |  | Adjust Hinges |  |  |  | 95000 | 22000 | 2012-05-01 00:00:00 | 2 days | 0.75 | Proposed
Spreadsheet: 525497d1498749512-top-10-results-with-dependant-criteria-and-duplicates-example
Sheet: Feuil1

 |  |  |  |  |  |  | Top 10 Table
Main Data Table |  |  |  |  |  |  |  |  | Project: | Cat
I.D | Project | Score | Cost | Action | Date
1 | Cat | 25 | 15061 | Fix |  |  | Position | I.D | Score | Cost
2 | Dog | 15 | 2156 | Fix |  |  | 1
3 | Whale | 5 | 561596 | Fix |  |  | 2 |  |  |  |  | The leaderboard is set by score, but i need the I.D and cost that relates to the score from the original table. This is made more difficult as there are a number of duplicates.
4 | Beetle | 10 | 56 | Fix |  |  | 3
5 | Cat | 10 | 16 | Fix |  |  | 4
6 | Beetle | 10 | 560 | Fix |  |  | 5
7 | Bird | 15 | 156 | Fix |  |  | 6
8 | Whale | 25 | 156 | Fix |  |  | 7
9 | Dog | 25 | 10 | Fix |  |  | 8
10 | Dog | 25 | 560156 | Fix |  |  | 9
11 | Bird | 5 | 1569 | Fix |  |  | 10
12 | Fish | 5 | 1560 | Fix
13 | Fish | 10 | 1591 | Fix
14 | Cat | 15 | 5 | Fix
15 | Beetle | 5 | 105 | Fix
16 | Beetle | 10 | 156 | Fix
17 | Beetle | 10 | 5961 | Fix
18 | Cat | 5 | 51 | Fix
19 | Cat | 25 | 561 | Fix
20 | Whale | 5 | 526 | Fix
21 | Bird | 5 | 105189 | Fix
22 | Cat | 5 | 515 | Fix
23 | Cat | 5 | 159 | Fix
24 | Cat | 5 | 1891 | Fix
25 | Whale | 10 | 891 | Fix
26 | Fish | 15 | 561 | Fix
27 | Dog | 5 | 56 | Fix
28 | Fish | 5 | 123 | Fix
29 | Cat | 15 | 159 | Fix
30 | Bird | 5 | 156 | Fix
31 | Bird | 5 | 1561 | Fix
32 | Fish | 15 | 5156 | Fix
33 | Fish | 5 | 4789 | Fix
34 | Beetle | 10 | 51 | Fix
35 | Whale | 15 | 56 | Fix
36 | Dog | 5 | 648 | Fix
Spreadsheet: 206018d1357990544-tracking-athletic-records-atheltic-records-example
Sheet: Sheet1

Results |  |  |  | Records
Number | Event | Performance |  | Name | Number | 80m | 100m | 200m | 300m | 400m | 1500m
1025 | 100m | [NAME] |  | [NAME] | 1025
6587 | 200m | [NAME] |  | [NAME] | 6587
2398 | 80m | 9.6 Sec |  | [NAME] | 2398
1568 | 300m | 1 Min 5.3 Sec |  | Cara | 1568
1426 | 100m | 25.3 Sec |  | Emma | 1426
7845 | 400m | 2 Min 6.8 Sec |  | Martin | 7845
3355 | 1500m | 5 Min 22.1 Sec |  | [NAME] | 3355
1025 | 100m | 11.3 Sec
6587 | 200m | 24.8 Sec
2398 | 80m | 9.63 Sec
1568 | 300m | 1 Min 15.3 Sec
1426 | 100m | 22.3 Sec
7845 | 400m | 1 Min 46.8 Sec
3355 | 1500m | 4 Min 32.1 Sec
Spreadsheet: 826148d1681826629-advanced-array-formula-help-example
Sheet: Example

 |  | Trainers
Week | WeekOfYear | 1 | 2 | 3 | 4 | 5 | 6 | 7 | Total |  | Gap | 4
2022W1 | 1 |  |  |  |  |  |  |  |  |  | Num | 4
2022W2 | 2 |  |  |  |  |  |  |  |  |  | Start | 6
2022W3 | 3
2022W4 | 4
2022W5 | 5
2022W6 | 6
2022W7 | 7
2022W8 | 8
2022W9 | 9
2022W10 | 10
2022W11 | 11
2022W12 | 12
2022W13 | 13
2022W14 | 14
2022W15 | 15
2022W16 | 16
2022W17 | 17
2022W18 | 18
2022W19 | 19
2022W20 | 20
2022W21 | 21
2022W22 | 22
2022W23 | 23
2022W24 | 24
2022W25 | 25
2022W26 | 26
2022W27 | 27
2022W28 | 28
2022W29 | 29
2022W30 | 30
2022W31 | 31
2022W32 | 32
2022W33 | 33
2022W34 | 34
2022W35 | 35
2022W36 | 36
2022W37 | 37
2022W38 | 38
2022W39 | 39
2022W40 | 40
2022W41 | 41
2022W42 | 42
2022W43 | 43
2022W44 | 44
2022W45 | 45
2022W46 | 46
2022W47 | 47
2022W48 | 48
2022W49 | 49
2022W50 | 50
2022W51 | 51
2022W52 | 52
Spreadsheet: john_griffith__15744__10_16_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 260 | 31 | 33 | 90.4 | 96.3 | 15.26 | 2001-10-16 12:32:00
 | NG Z1 | 285 | 55 | 58 | 71.8 | 75.7 | 13.21 | 2001-10-16 12:32:00
 | NG F2 | 305 | 75 | 78 | 70.7 | 73.5 | 13.83 | 2001-10-16 12:32:00
 | NG G2 | 305 | 84 | 88 | 65.7 | 68.9 | 12.9 | 2001-10-16 12:32:00
 | NG H2 | 300 | 84 | 88 | 59.5 | 62.4 | 11.5 | 2001-10-16 12:32:00
 | NG J2 | 285 | 76 | 80 | 51.6 | 54.4 | 9.5 | 2001-10-16 12:32:00
 | NG K2 | 290 | 78 | 82 | 47.9 | 50.4 | 8.96 | 2001-10-16 12:32:00
 | NG M2 | 295 | 84 | 88 | 47 | 49.3 | 8.93 | 2001-10-16 12:32:00
 | NG N2 | 300 | 88 | 92 | 45.8 | 47.9 | 8.84 | 2001-10-16 12:32:00
 | NG Q2 | 300 | 94 | 98 | 46.5 | 48.5 | 8.96 | 2001-10-16 12:32:00
 | NG U2 | 300 | 94 | 98 | 44.2 | 46.1 | 8.52 | 2001-10-16 12:32:00
 | NG V2 | 305 | 101 | 102 | 44.9 | 45.4 | 8.66 | 2001-10-16 12:32:00
 | [NAME] | 340 | 124 | 133 | 46.1 | 49.5 | 10.22 | 2001-10-16 12:32:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: kimberly_watson__20560__shipsummary
Sheet: Sheet4

TRANSWESTERN  PIPELINE |  |  |  |  |  |  |  | 1.7 | index at 10/9/01
Shipper imbalances
 | 2001-08-31 00:00:00 | 9/2001 | 9/2001 | 2001-09-30 00:00:00 | 2001-10-08 00:00:00 | 10/2001 | 10/2001
Shipper | Balance | activity | payments | Balance | activity | payments | Balance | comments
BP Energy Company |  |  |  | 362637.31 |  |  |  | has agreed to payback volumes of 125,856
Duke Energy Trading & Marketing |  |  |  |  |  |  |  | invoiced 8/31/01
Texaco Natural Gas, Inc |  |  |  |  |  |  |  | invoiced 8/31/01- has agreed to pay
Burlington Resources Trading |  |  | -125393
Reliant Energy Services |  |  | -73576
Williams Energy Marketing |  |  | -46764.71 | 3821.28
Mirant Americas |  |  |  | 2803.88
Enserco Energy | 16048.18 |  |  |  |  |  |  | invoiced 8/31/01
USGT | 26251 |  |  | 26251.25 |  |  |  | invoiced 8/31/01 - they asked for index backup on 10/8/01
Phillips Petroleum | 7264 |  |  |  |  |  |  | has agreed to 960 mmbtus but wants to see pricing language in tariff
Red Cedar Gathering | 6732 |  |  |  |  |  |  | invoiced 8/31/01- vol equiv pymt in Oct 2001
Dynegy Gas Transportation |  |  |  |  |  | -6531 |  | invoiced 8/31/01- verbal promise to pay on 10/5/01
Aurora Natural Gas | 2362.1 |  |  | 2362.1
PGE Electric | 3412 |  |  |  |  |  |  | invoiced 8/31/01
ENA |  |  |  | 4268.02
Arizona Public Service | 1610.08 |  | -1610
Utilicorp | 113
Astra Power | -5.54 |  |  | 246.38
Richardson Products | -180
EES |  |  |  | -1910.98
SMUD | -608 | -158
Tenaska Marketing Ventures | -3718
El Paso Energy Marketing | -8120
PGE Energy Trading
SoCal |  |  |  | -25290.62
Enserch Gas | -29760
Sempra Energy Trading |  |  |  | -92551.75
TXU Energy Trading | 0 | -346
Spreadsheet: 698519d1602015403-lookup-value-in-a-worksheet-help
Sheet: Standings

TW | LW | éê | TEAM | TM# | TOTAL $ | BEHIND BY
1 | 48 |  |  | 1 |  | 0
2 | 11 |  |  | 2
3 | 125 |  |  | 3
4 | 107 |  |  | 4
5 | 105 |  |  | 5
6 | 91 |  |  | 6
7 | 55 |  |  | 7
8 | 78 |  |  | 8
9 | 128 |  |  | 9
10 | 46 |  |  | 10
11 | 89 |  |  | 11
12 | 80 |  |  | 12
13 | 29 |  |  | 13
14 | 51 |  |  | 14
15 | 121 |  |  | 15
16 | 39 |  |  | 16
17 | 5 |  |  | 17
18 | 58 |  |  | 18
19 | 49 |  |  | 19
20 | 119 |  |  | 20
21 | 129 |  |  | 21
22 | 102 |  |  | 22
23 | 72 |  |  | 23
24 | 109 |  |  | 24
Spreadsheet: 826f3dbf-dc8f-4a1b-b7b2-d5b65c09d73b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4436 | 5708 | [NAME] | Lessing | GBR | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 01:59:47 | Elite Men
4436 | 10412 | [NAME] | Beven | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | [NAME] | Elite Men
4436 | 10349 | [NAME] | [NAME] | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:02:07 | Elite Men
4435 | 15364 | [NAME] | Mantak | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | [NAME] | Elite Women
4435 | 14216 | Suzanne | Nielsen | DEN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:19:06 | Elite Women
4435 | 15211 | [NAME] | [NAME] | CAN | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:21:00 | Elite Women