tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 771334d1646635716-comparing-multiple-columns-on-2-sheets-time-stamp-relative-match-book1
Sheet: Sheet1

Sheet1Name | Sheet1Timestamp | Product |  | Sheet2Name | Shheet2Timestamp | Case | Expected result
[NAME] | 1/26/2022 8:23:50 AM | Apple |  | [NAME] | 2021-07-02 01:48:56 | case1 | [NAME] | Apple | case9
[NAME] | 1/31/2022 5:59:58 AM | Samsung |  | [NAME] | 2021-07-07 02:02:05 | case2 | [NAME] | Samsung | case11
[NAME] | 8/6/2021 6:20:25 AM | OnePlus |  | [NAME] | 2021-07-12 10:34:38 | case3 | [NAME] | OnePlus
Shane | 12/9/2021 7:52:14 AM | Apple |  | [NAME] | 2021-07-14 02:42:00 | case4 | Shane | Apple | case14
Shane | 2022-02-04 18:12:34 | OnePlus |  | [NAME] | 2021-08-03 09:16:19 | case5 | Shane | OnePlus
 |  |  |  | [NAME] | 2021-08-08 09:16:19 | case6
 |  |  |  | [NAME] | 2022-01-24 02:34:17 | case7
 |  |  |  | [NAME] | 2022-01-25 01:44:23 | case8
 |  |  |  | [NAME] | 2022-01-27 03:42:13 | case9
 |  |  |  | [NAME] | 2022-01-31 06:01:39 | case10
 |  |  |  | [NAME] | 2022-01-31 15:01:39 | case11
 |  |  |  | [NAME] | 2022-02-01 03:12:42 | case12
 |  |  |  | Shane | 2021-12-06 05:22:14 | case13
 |  |  |  | Shane | 2021-12-10 03:12:14 | case14
 |  |  |  | Shane | 2021-12-12 19:52:14 | case15
Spreadsheet: 66686d1267362905-transferring-data-from-multiple-sheets-into-one-french
Sheet: Sheet1

Knowledge Object No. | Knowledge Object Name | Knowledge Object Name in French | Date Started | Date Ended
1 | [NAME] | aaaaaa | 2010-01-26 00:00:00 | 2010-01-29 00:00:00
2 | Last Samurai | [NAME] | 2010-01-27 00:00:00 | 2010-01-30 00:00:00
3 | Schindler's List | llleee | 2010-01-30 00:00:00 | 2010-02-02 00:00:00
4 | Lord of Rings | ooorrr | 2010-02-02 00:00:00 | 2010-02-05 00:00:00
5 | Godfather | iiiwww | 2010-02-04 00:00:00 | 2010-02-07 00:00:00
6 | Shawshank Redemption | mmmvvv | 2010-02-10 00:00:00 | 2010-02-13 00:00:00
7 | Good, Bad, Ugly | cccsss | 2010-02-13 00:00:00 | 2010-02-16 00:00:00
8 | School of Rock | zzzqqq | 2010-02-18 00:00:00 | 2010-02-21 00:00:00
9 | Ninja Assasin | ssshhh | 2010-02-19 00:00:00 | 2010-02-22 00:00:00
10 | Drunken Master | aaammm | 2010-02-22 00:00:00 | 2010-02-25 00:00:00
Spreadsheet: 169775d1343057072-pulling-only-last-30-days-data-from-larger-all-time-table-list1
Sheet: Sheet1

ID | Incident Date | Issue Title | Impact Time
567 | 2012-07-20 00:00:00 | Slowness issues | 0.58
561 | 2012-07-19 00:00:00 | Slowness issues | 0.57
562 | 2012-07-19 00:00:00 | Update Not Received | 0
563 | 2012-07-19 00:00:00 | Update Not Received | 0
564 | 2012-07-19 00:00:00 | Update Not Received | 0
565 | 2012-06-12 00:00:00 | Update Not Received | 1
566 | 2012-06-11 00:00:00 | Update Not Received | 0
544 | 2012-06-10 00:00:00 | Slowness issues | 0
547 | 2012-06-09 00:00:00 | Slowness issues | 3
548 | 2012-06-08 00:00:00 | Update Not Received | 0
549 | 2012-06-07 00:00:00 | Update Not Received | 2.1
550 | 2012-06-06 00:00:00 | Update Not Received | 0
551 | 2012-05-02 00:00:00 | Slowness issues | 0.5
552 | 2012-05-01 00:00:00 | Update Not Received | 0
542 | 2012-04-20 00:00:00 | Update Not Received | 0
553 | 2012-04-15 00:00:00 | Update Not Received | 0
560 | 2012-03-13 00:00:00 | Update Not Received | 6.3
537 | 2012-03-13 00:00:00 | Update Not Received | 0
538 | 2012-03-13 00:00:00 | Update Not Received | 0
Spreadsheet: 863395d1710888894-calculating-weighted-averages-slightly-differently-daily-completion2
Sheet: BASIC

 | Activity | % Complete | Weight | Weighted Score
 | physical | 100 | -2
 | emotional | 0 | 0
 | financial | 0 | 0
 | professional | 0 | 0
 |  | Daily score
Spreadsheet: 795443d1662700598-why-does-using-a-string-as-a-boolean-in-and-and-if-give-different-results-evaluation-empty-cells-hd
Sheet: Sheet1

Result | [NAME] | Input |  | Evaluation |  |  |  | Explanation
 |  |  |  | --> =IF(0;TRUE;FALSE) --> FALSE |  |  |  | [NAME] is empty and single --> C3 is be replaced by 0
 |  |  |  | --> =IF(AND(TRUE);TRUE;FALSE --> TRUE |  |  |  | [NAME] is empty, but not single  --> C3 is ignogerd
 |  |  |  | --> =0*7 --> 0 |  |  |  | C8 is empty and single --> C8 is replaced by 0
 |  |  |  | --> =PRODUCT(7) --> 7 |  |  |  | C8 is empty, but not single  --> C8 is ignogerd
Spreadsheet: 876427d1723115034-multi-criteria-lookup-multi-condition-lookup
Sheet: Sheet1

Order | Period | Year | % split 1 | Cost Centre 1 | % split 2 | Cost Centre 2 |  | Order Split & CC Master Table
Ord1 | 12 | 2024 |  |  |  |  |  | Order | From Year | From Period | To Year | To Period | % split | Cost Centre
Ord1 | 4 | 2025 |  |  |  |  |  | Ord1 | 2024 | 1 | 2024 | 12 | 1 | A
Ord2 | 3 | 2025 |  |  |  |  |  | Ord1 | 2025 | 1 |  |  | 1 | C
Ord2 | 1 | 2025 |  |  |  |  |  | Ord2 | 2022 | 1 | 2025 | 1 | 0.5 | D
 |  |  |  |  |  |  |  | Ord2 | 2022 | 1 | 2025 | 1 | 0.5 | E
 |  |  |  |  |  |  |  | Ord2 | 2025 | 2 |  |  | 0.5 | F
 |  |  |  |  |  |  |  | Ord2 | 2025 | 2 |  |  | 0.5 | G
Steps: |  |  |  |  |  |  |  |  |  |  | *Note blank end year/periods means it's the latest active rule
1. Take [NAME] number, period & year (columns A, B & C)
2. Use the info from step 1 to find the relevant info from the master table on the right (blue)
Spreadsheet: 77e051a7-6634-4ec2-b8bf-efdef1c76b8c
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | GIVING PERMISSION TO TWA LOFTS, LLC, TO CONSTRUCT AND MAINTAIN
 | LANDSCAPING, PLANTERS, A BIKE RACK AND TRASH RECEPTACLES
 | IN THE PUBLIC RIGHT OF WAY FOR THE BUILDING AT 1735 BALTIMORE AVENUE . . .
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund |  |  | $ | 4125 |  | $
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 4125 |  | $ | 0
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known or, if grant revenue, please identify source of funds (federal or state) and duration of grant support.)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2005-06 |  |  | FY 2006-07
 | General Fund |  |  | $ |  |  | $
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimated number of people to be served, who is currently delivering services to that population, service
 | performance expectations and, if grant supported, provisions for support if grant support ends.)
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
0ffice of Management and Budget |  |  |  |  |  | OMB Approval Date
Spreadsheet: 182237d1348380363-fantasy-football-statistics-problem-conditional-formatting-maximums-with-reference-league
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTERBACKS |  |  |  |  | RUNNINGBACKS
 |  |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | week 10 | week 11 | week 12 |  | MAX | MAX 2 | MAX 3 |  |  | MAX | MAX 2 | MAX 3
QB | [NAME] | DAL | 23.5 | 26.2 | 19.1 |  |  |  |  |  |  |  |  |  | 26.2 | 26.2 | 23.5 | 19.1
WR | [NAME] | NYG | 17 | 9.3 | 2.3 |  |  |  |  |  |  |  |  |  | 17
WR | [NAME] | TB | 8.4 | 7.6 | 13.9 |  |  |  |  |  |  |  |  |  | 13.9
WR | [NAME] | JAC | 6.5 | 6.8 | 3.4 |  |  |  |  |  |  |  |  |  | 6.8
RB | [NAME] | BAL | 22.6 | 17.5 | 26.8 |  |  |  |  |  |  |  |  |  | 26.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
QB | [NAME] | NO | 28.3 | 21.3 | 22.2 |  |  |  |  |  |  |  |  |  | 28.3 | 28.3 | 22.2 | 21.3
WR | [NAME] | CHI | 12.2 | 17 | 11.8 |  |  |  |  |  |  |  |  |  | 17
WR | [NAME] | NE | 12.9 | 7.2 | 16.9 |  |  |  |  |  |  |  |  |  | 16.9
WR | [NAME] | PHI | 15.2 | 14.9 | 11.4 |  |  |  |  |  |  |  |  |  | 15.2
RB | [NAME] | TB | 12.3 | 22.1 | 17.1 |  |  |  |  |  |  |  |  |  | 22.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Points | Player | Team | Week |  | Points | Player | Team | Week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | 28.3 | ? | ? | ? | 1st
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd | 26.2 | ? | ? | ? | 2nd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd | 23.5 | ? | ? | ? | 3rd
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 10c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, November 9 weekly snapshot, by product type and major currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: andy_zipper__242__DYNEGY-ICE VOL Jun1
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:   Jun-1-01 thru Jun-1-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 733174d1621428157-how-to-return-date-format-in-cell-instead-of-general-format-blank-project-planner_eh
Sheet: Project planner snapshot

ID | Tasks | Owner | Start Date | Duration | Priority |  | Status |  |  | ID |  |  |  |  | Task owners (Adhoc tasks excluded)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Task meter (Adhoc tasks excluded)
 | Phase 2 | Owner |  |  |  |  | Status |  |  | Adhoc queries
 | Phase 3 | Owner |  |  |  |  | Status
 |  |  |  |  |  |  |  |  |  | Deadlines
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | Not started
 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tasks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority tracker
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low Priority
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On hold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In progress
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tasks
Spreadsheet: kam_keiser__17854__quotesheet
Sheet: 12-6 morning

Large Deal Quote Sheet (Generic)
Date & Time of Quote | Prompt Merc price, and commodity | Dealer/Third Party | Market/Location | Term | Notional Amount | Bid/Ask
2001-12-06 08:22:08.560000 | Jan '02 | Natsource | Permian | Jan - Mar '02 | 10,000/d | -.16 @ -.1475
2001-12-06 08:06:22.540000 | Jan '02 | Natsource | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-06 08:13:25.940000 | Jan '02 | APB | Waha | Jan - Mar '02 | 10,000/d | -.13 @
2001-12-06 08:31:23.190000 | Jan '02 | APB | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.015
2001-12-06 08:25:10.340000 | Jan '02 | Amerex | Permian | Jan - Mar '02 | 10,000/d | -.16 @ -.14
2001-12-06 08:09:06.280000 | Jan '02 | Amerex | HSC | Jan - Mar '02 | 10,000/d | -.02 @ -.0125
Spreadsheet: 740301d1626273998-sumifs-with-two-conditions-sample3
Sheet: sample3

 | 2011 | 0
 | 2013
 | 2016
 | 2017
 | 2018 | 0
 | 2019
 | 2020
QWE1770LALFI_EC___2011M0000DEGD000P4_N | 2011 | 1
QWE1770LALFI_LQ___2019M0000DEGD000P2_N | 2019 | 2
QWE1770LALFI_LQ_CE2019M5038OIIPNFNP2_N | 2019 | 3
[NAME] | 2018 | 4
QWE1770LALHG_MRTED2019M4183OIIPPNNG2_N | 2019 | 5
QWE1770LALVBGB_MRT2019M5078OIIPNFNP2_N | 2019 | 6
QWE1774LALLQ_439_C2016M5078OIIPNNNP2_N | 2016 | 7
[NAME] | 2020 | 8
QWE1770LALLQ_ELGM_2020O4421GBGIPNNP2_N | 2020 | 9
QWE1773LALTV_LQ___2010O0000ATGD000P2_N | 2010 | 10
QWE1773LALTV_LQ___2013O0000ATGD000P2_N | 2013 | 11
QWE1773LALTV_LQ_CE2019M4756OIIPPNNP2_N | 2019 | 12
QWE1773LALTV_LQ_CE2020M4756OIIPPNNP4_N | 2020 | 13
QWE1775LALKT______2017O0000FRGD000P2_N | 2017 | 14
Spreadsheet: 729776d1619341158-how-to-calculate-count-and-percentage-form-data-base-based-on-current-month-and-previous-month-test
Sheet: Sheet2

Date | Data | Remarks |  |  |  |  | April'21
2021-04-01 00:00:00 | 1911 | Reject |  |  |  |  | Total In April | 9 | Percentage
2021-04-04 00:00:00 | 1802 | Accept |  |  |  |  | Reject | 5
2021-04-09 00:00:00 | 1911 | Accept |  |  |  |  | Accept | 4
2021-04-11 00:00:00 | 1788 | Reject
2021-04-15 00:00:00 | 1678 | Reject |  |  |  |  | how many data accepted after rejection in April | 2 |  | 40% accepted after rejection within the month
2021-04-15 00:00:00 | 1566 | Accept
2021-04-21 00:00:00 | 1788 | Accept
2021-04-23 00:00:00 | 1900 | Reject
2021-04-28 00:00:00 | 1090 | Reject
2021-05-01 00:00:00 | 1999 | Accept |  |  |  |  | May'21
2021-05-05 00:00:00 | 2000 | Accept |  |  |  |  | Total In April | 6 | Percentage
2021-05-06 00:00:00 | 1987 | Reject |  |  |  |  | Reject | 2
2021-05-06 00:00:00 | 1678 | Accept |  |  |  |  | Accept | 3
2021-05-11 00:00:00 | 3022 | Reject
2021-05-15 00:00:00 | 1900 | Accept |  |  |  |  | how many data accepted after rejection May | 0 |  | 0% accepted after rejection within the month
 |  |  |  |  |  |  | how many data accepted in May'21 after rejection in April'21 | 2 |  | 40% accepted in May'21 after rejection in April'21
Spreadsheet: 852203d1702306614-need-help-converting-a-google-sheets-formula-to-excel-ks-schedule-12112023
Sheet: TAURO 2

T2 |  | Total hours
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 8 Pass | 2024-01-15 00:00:00 |  | T2 | For production quote- [NAME]
 | 819 | 67.1-R | SURL | 20 | 22 | 22 | PAP-SO-1354 - ULTRABOARD 3/16IN WHITE 48X96 | 2 | 4 Pass | 45261 |  | T2
 | 819 | 134.1-R | SURL | 7 | 52 | 10 | PAP-SO-1354 - ULTRABOARD 3/16IN WHITE 48X96 | 2 | 4 Pass | 45261 |  | T2
 | 242778 | 2 | Equestrian Sports Productions LLC | 6999 | 8 | 6 | PAP-444450 - 48X96 30PT STYRENE | 1 | 4 Pass | 45261 |  | T2
 | 242697 | 1 | Perfect Promotions | 10 | 36 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 2 | 4 Pass | 45261 |  | T2
 | 242684 | 1 | Wompas Graphix | 18 | 22 | 16 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 1 | 4 Pass | 45261 |  | T2
Spreadsheet: mike_carson__27615__BrokerQuote(SouthEast)
Sheet: Sheet1

Broker | Prebon
Date | 2002-02-06 00:00:00
Time | 15.30PM |  |  |  | Please time stamp the quote sheet before sending back
ONPEAK |  |  |  |  |  |  |  | [NAME]
PRICE | SOUTHEAST |  |  |  |  |  |  | PRICE | SOUTHEAST
 | SOCO |  | Entergy |  |  |  |  |  | SOCO |  | Entergy
 | Bid | Offer | Bid | Offer |  |  |  |  | Bid | Offer | Bid | Offer
Dailies | 23.5 | 24.5 | - | - |  |  |  | Dailies
Next Week | 23 | 25 | - | - |  |  |  | Next Week
[NAME] | 23 | 25 | 18.85 | 19 |  |  |  | [NAME]
M/A 02 | 22.25 | 22.95 | 19.7 | 19.95 |  |  |  | M/A 02
2002-05-01 00:00:00 | 25.75 | 26 | 22.75 | 22.95 |  |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 | 30.5 | 31 | 26.8 | 27.25 |  |  |  | 2002-06-01 00:00:00
Sum 02 | 39 | 39.5 | 33.75 | 34.25 |  |  |  | Sum 02
2002-09-01 00:00:00 | 23.1 | 23.6 | 21.25 | 21.5 |  |  |  | 2002-09-01 00:00:00
Q4 02 | 23 | 23.5 | 21.6 | 21.8 |  |  |  | Q4 02
Bal CAL-02 | 26.85 | 27.5 | 23.9 | 24.25 |  |  |  | CAL-02
W 03 | 26.5 | 27 | 24.5 | 25 |  |  |  | W 03
M/A 03 | 25 | 25.75 | 22.75 | 23.25 |  |  |  | M/A 03
2003-05-01 00:00:00 | 26.5 | 27 | 24.5 | 25 |  |  |  | 2003-05-01 00:00:00
2003-06-01 00:00:00 | 31.5 | 32 | 28.5 | 29.25 |  |  |  | 2003-06-01 00:00:00
Sum 03 | 40.25 | 40.75 | 35 | 35.5 |  |  |  | Sum 03
2003-09-01 00:00:00 | 25.4 | 26.15 | 23.5 | 24..25 |  |  |  | 2003-09-01 00:00:00
Q4 03 | 26.15 | 26.9 | 24.25 | 24.75 |  |  |  | Q4 03
CAL-03 | 29 | 29.75 | 26.25 | 26.6 |  |  |  | CAL-03
[NAME] | 31 | 31.75 | 27.75 | 28.25 |  |  |  | [NAME]
Cal-05 | 32 | 32.5 | 28.5 | 29.25 |  |  |  | Cal-05 | 22 | 24
Cal-06 | - | - | 29.5 | 30.5 |  |  |  | Cal-06
Cal-07 | - | - | 30 | 31 |  |  |  | Cal-04-06 | 21.5 | 22.5
Spreadsheet: craig_dean__4355__11-1act
Sheet: EPEData

 | 37292.96944444445
 | NEWMAN 1 ,ECON, 42  , 75  , 39  , 83  , 32  ,1
 | NEWMAN 2 ,MANL, 37  , 77  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 35  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,MANL,106  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 219 ,  467,  194, 483 ,  72 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 25  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,ECON, 80  ,121  , 56  ,151  , 21  ,1
 | RIOGRANDE,, 106 ,  159,   88, 200 ,  21 ,
 | PALOVERDE,[NAME]  ,189  ,189  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 82  , 82  , 82  ,104  ,  0  ,1
 | LAMBDA, 32.78,  665,  667,  260,   11,    0,17276,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 848659d1699350640-how-do-i-sort-by-multiple-criteria-excel7
Sheet: Sheet1

 |  |  | A |  |  |  |  | B
Transaction  Date | [NAME] | Quantity | Price | Serial number |  | Transaction  Date | [NAME] | Quantity | Price | Serial number
2023-09-18 06:00:00 | PURCH | 1 | 112.15 | DE000C7PB9W9 |  | 2023-09-18 06:00:00 | SOLD | 1 | 15999 | DE000C6LWLT1
2023-09-18 06:00:00 | PURCH | 1 | 112.15 | DE000C7PB9W9 |  | 2023-09-18 06:00:00 | PURCH | 1 | 15998 | DE000C6LWLT1
2023-09-18 06:00:00 | PURCH | 1 | 112.15 | DE000C7PB9W9 |  | 2023-09-18 06:00:00 | PURCH | 3 | 112.12 | DE000C7PB9W9
2023-09-18 06:00:00 | PURCH | 14 | 116.1 | DE000C7PB9Z2 |  | 2023-09-18 06:00:00 | PURCH | 14 | 116.1 | DE000C7PB9Z2
2023-09-18 06:00:00 | PURCH | 1 | 124.69 | DE000C7PB934 |  | 2023-09-18 06:00:00 | PURCH | 1 | 124.69 | DE000C7PB934
2023-09-18 06:00:00 | SOLD | 1 | 112.15 | DE000C7PB9W9 |  | 2023-09-18 06:00:00 | SOLD | 1 | 112.15 | DE000C7PB9W9
2023-09-18 06:00:00 | SOLD | 1 | 15999 | DE000C6LWLT1 |  | 2023-09-18 06:00:00 | PURCH | 1 | 112.15 | DE000C7PB9W9
2023-09-18 06:00:00 | PURCH | 1 | 15998 | DE000C6LWLT1 |  | 2023-09-18 06:00:00 | PURCH | 1 | 112.15 | DE000C7PB9W9
2023-09-18 06:00:00 | PURCH | 3 | 112.12 | DE000C7PB9W9 |  | 2023-09-18 06:00:00 | PURCH | 1 | 112.15 | DE000C7PB9W9
Spreadsheet: 780248d1652360612-help-with-max-value-sample-workbook
Sheet: After

UNIQUE ID | AMOUNT | DATE | Desired Outcome
1 | 112.91 | 2021-12-01 00:00:00
1 | 117.17 | 2022-01-01 00:00:00 | 117.17
1 | 109.22 | 2022-02-01 00:00:00
1 | 102.06 | 2022-03-01 00:00:00
2 | 31.72 | 2021-12-01 00:00:00
2 | 33.84 | 2022-01-01 00:00:00
2 | 34.84 | 2022-02-01 00:00:00 | 34.84
2 | 29.41 | 2022-03-01 00:00:00
3 | 26.75 | 2021-12-01 00:00:00
3 | 30.48 | 2022-01-01 00:00:00 | 30.48
3 | 29.75 | 2022-02-01 00:00:00
3 | 24.54 | 2022-03-01 00:00:00
Spreadsheet: 838014d1690607965-divide-and-sum-an-array-s1-aligw
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 351 | 2892 | 234 | 184 | 243 | 2137 | 247 | 83
2 | 1536 | 4836 | 1010 | 928 | 1183 | 5364 | 1657 | 588
3 | 58 | 942 | 31 | 29 | 29 | 477 | 50 | 11
4 | - | - | - | - | - | - | - | -
5 | 155 | 2201 | 121 | 109 | 108 | 1335 | 165 | 45
6 | 84 | 2189 | 132 | 105 | 100 | 1623 | 81 | 30
7 | 360 | 3615 | 210 | 183 | 194 | 1471 | 258 | 75
8 | 566 | 4275 | 256 | 241 | 273 | 2201 | 347 | 102
9 | 123 | 1573 | 78 | 54 | 59 | 1137 | 85 | 17
10 | 1766 | 10926 | 2021 | 1251 | 2027 | 1753 | 1746 | 830
11 | - | - | - | - | - | - | - | -
12
 |  |  |  |  |  |  |  |  |  |  | SUM
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1
2
3
4
5
6
7
8
9
10
11
12
 | Total | Total | Total | Total | Total | Total | Total | Total |  |  | SUM
Spreadsheet: d0b8db40-70bc-433f-93c1-a0c0389151a2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7129 | 40955 | [NAME] | Judge | GBR | 35 | 00:17:23 | 00:01:26 | 00:36:19 | 00:00:57 | 00:20:34 | 1 | 01:16:37
7129 | 13699 | [NAME] | Averesch | GER | 36 | 00:19:01 | 00:01:58 | 00:37:32 | 00:01:23 | 00:20:59 | 2 | [NAME]
7129 | 30688 | [NAME] | Smith | GBR | 34 | 00:17:36 | 00:01:46 | 00:38:49 | 00:00:15 | 00:27:52 | 3 | 01:26:16
7129 | 40953 | [NAME] | [NAME] | GBR | 32 | 00:20:17 | 00:02:45 | 00:43:19 | 00:01:22 | 00:36:14 | 4 | 01:43:56
7129 | 7972 | [NAME] | Wagner | RSA | 33 | 00:17:28 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 2d88de83-c35c-4308-9c82-6f960691b2c3
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0006254 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Corolla Light WWTP #1 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Currituck | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 50060 | 31616 | 00610 | 00620 | 00400 | 00665 | 70300 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | pH | Total Phosphorus | Total Dissolved Solids | Total Suspended Solids
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mg/L | mg/L | mg/L
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Composite | Composite | Grab | Grab | Composite | Composite | Grab | Composite | Composite | Composite
Monthly Limit: |  |  | 80000 | 10 |  |  |  | 14 | 4 |  |  |  |  | 20
Daily Limit: |  |  |  |  |  |  |  | 43 |  |  | 6-9
Sample Frequency: |  |  | [NAME] | See Permit | 4 x Year | 4 x Year | 5 x Week | See Permit | See Permit | See Permit | 5 x Week | 4 x Year | 4 x Year | See Permit
 |  | Average
 |  | Geomean
 |  | MAX/MIN