tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 208562d1358869205-get-date-from-week-number-and-year-fiscal-calendar-book1
Sheet: Dates

Week Nr | Saturday
1 | 2013-07-06 00:00:00
2 | 2013-07-13 00:00:00
3 | 2013-07-20 00:00:00
4 | 2013-07-27 00:00:00
5 | 2013-08-03 00:00:00
6 | 2013-08-10 00:00:00
7 | 2013-08-17 00:00:00
8 | 2013-08-24 00:00:00
9 | 2013-08-31 00:00:00
10 | 2013-09-07 00:00:00
11 | 2013-09-14 00:00:00
12 | 2013-09-21 00:00:00
13 | 2013-09-28 00:00:00
14 | 2013-10-05 00:00:00
15 | 2013-10-12 00:00:00
16 | 2013-10-19 00:00:00
17 | 2013-10-26 00:00:00
18 | 2013-11-02 00:00:00
19 | 2013-11-09 00:00:00
20 | 2013-11-16 00:00:00
21 | 2013-11-23 00:00:00
22 | 2013-11-30 00:00:00
23 | 2013-12-07 00:00:00
24 | 2013-12-14 00:00:00
25 | 2013-12-21 00:00:00
26 | 2013-12-28 00:00:00
Spreadsheet: 02eae7d8-237f-466d-9615-18406e5bfe05
Sheet: Sheet1

Field set up and break down assignments | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Opening |  | Set Up Time | Closing
Sat | 2013-03-30 00:00:00 | U16 Girls Division I | U10 Girls Division I | 07:30:00 | U13 Boys Division I
Sun | 2013-03-31 00:00:00
Sat | 2013-04-06 00:00:00 | U9 Girls Division II | U12 Boys Division I | 07:30:00 | U13 Girls Division II
Sun | 2013-04-07 00:00:00
Sat | 2013-04-20 00:00:00 | U9 Girls Division II | U9 Girls Division I | 08:00:00 | U13 Girls Division I
Sun | 2013-04-21 00:00:00 | U12 Boys Division II | U11 Boys Division II | 08:00:00 | U9 Boys Division II
Tue | 2013-04-22 00:00:00 | U10 Girls Division I |  | 17:00:00 | U10 Girls Division I
Fri | 2013-04-26 00:00:00 | U11 Boys Division I |  | 17:00:00 | U11 Boys Division I
Sat | 2013-04-27 00:00:00 | U14 Girls Division I | U11 Girls Division II | 07:30:00 | U14 Boys Division II
Sun | 2013-04-28 00:00:00 | U10 Boys Division II | U10 Boys Division I | 10:00:00 | U10 Boys Division I
Wed | 2013-05-01 00:00:00 | U13 Boys Division I |  | 16:30:00 | U13 Boys Division I
Sat | 2013-05-04 00:00:00 | U13 Boys Division I | U12 Girls Division II | 07:30:00 | U13 Girls Division I
Sun | 2013-05-05 00:00:00 | U11 Boys Division II | U9 Boys Division I | 07:30:00 | U9 Boys Division I
Sat | 2013-05-11 00:00:00 | U14 Girls Division I | U11 Girls Division II | 07:30:00 | U12 Girls Division II
Sun | 2013-05-12 00:00:00 | U9 Boys Division I | U12 Boys Division II | 07:30:00 | U10 Boys Division II
Tue | 2013-05-14 00:00:00 | U12 Girls Division I |  | 17:00:00 | U12 Girls Division I
Sat | 2013-05-18 00:00:00 | U13 Girls Division II | U12 Girls Division II | 07:30:00 | U9 Boys Division II
Sun | 2013-05-19 00:00:00 | U11 Boys Division II | U16 Girls Division I | 08:30:00 | U10 Boys Division I
Fri | 2013-05-31 00:00:00 | U14 Girls Division I |  | 16:30:00 | U14 Girls Division I
Sat | 2013-06-01 00:00:00 | U14 Girls Division I | U11 Boys Division I | 07:30:00 | U11 Girls Division I
Sun | 2013-06-02 00:00:00 | U9 Boys Division I | U9 Boys Division II | 08:00:00 | U10 Boys Division I
Sat | 2013-06-08 00:00:00 | U12 Girls Division I | U14 Girls Division II | 07:30:00 | U12 Girls Division II
Sun | 2013-06-09 00:00:00 | U16 Girls Division I | U11 Boys Division II | 08:30:00 | U10 Boys Division II
Spreadsheet: 685912d1594271853-to-conditional-copy-from-one-column-to-another-sample-data
Sheet: Sheet1

from this |  |  |  | to this |  |  | I have copied it manually how it can be done with the formula
Sun
1 |  |  |  | 16° / 4°
16° / 4° |  |  |  | 18° / 4°
Actual Temp |  |  |  | 19° / 4°
Precip |  |  |  | 16° / 4°
0.0 mm |  |  |  | 10° / 4°
Mon |  |  |  | 9° / 3°
2 |  |  |  | 12° / 3°
18° / 4° |  |  |  | 11° / 3°
Actual Temp |  |  |  | 13° / 3°
Precip |  |  |  | 16° / 3°
0.0 mm |  |  |  | 17° / 2°
Tue |  |  |  | 12° / 3°
3 |  |  |  | 11° / 1°
19° / 4° |  |  |  | 15° / 3°
Actual Temp |  |  |  | 18° / 2°
Precip |  |  |  | 19° / 2°
0.0 mm |  |  |  | 21° / 4°
Wed |  |  |  | 21° / 5°
4 |  |  |  | 21° / 4°
16° / 4° |  |  |  | 21° / 4°
Actual Temp |  |  |  | 14° / 8°
Precip |  |  |  | 19° / 7°
1.0 mm |  |  |  | 21° / 5°
Thu |  |  |  | 13° / 8°
5 |  |  |  | 13° / 6°
10° / 4° |  |  |  | 15° / 4°
Actual Temp |  |  |  | 10° / 6°
Precip |  |  |  | 13° / 1°
7.9 mm |  |  |  | 18° / 6°
Fri |  |  |  | 15° / 5°
6 |  |  |  | 15° / 7°
9° / 3°
Actual Temp
Precip
2.5 mm
Sat
7
12° / 3°
Actual Temp
Precip
0.3 mm
Sun
8
11° / 3°
Actual Temp
Precip
0.5 mm
Mon
9
13° / 3°
Actual Temp
Precip
0.0 mm
Tue
10
16° / 3°
Actual Temp
Precip
0.0 mm
Wed
11
17° / 2°
Actual Temp
Precip
0.0 mm
Thu
12
12° / 3°
Actual Temp
Precip
38.1 mm
Fri
13
11° / 1°
Actual Temp
Precip
1.0 mm
Sat
14
15° / 3°
Actual Temp
Precip
1.0 mm
Sun
15
18° / 2°
Actual Temp
Precip
0.0 mm
Mon
16
19° / 2°
Actual Temp
Precip
0.0 mm
Tue
17
21° / 4°
Actual Temp
Precip
0.0 mm
Wed
18
21° / 5°
Actual Temp
Precip
0.0 mm
Thu
19
21° / 4°
Actual Temp
Precip
0.0 mm
Fri
20
21° / 4°
Actual Temp
Precip
0.0 mm
Sat
21
14° / 8°
Actual Temp
Precip
1.0 mm
Sun
22
19° / 7°
Actual Temp
Precip
0.0 mm
Mon
23
21° / 5°
Actual Temp
Precip
0.0 mm
Tue
24
13° / 8°
Actual Temp
Precip
7.9 mm
Wed
25
13° / 6°
Actual Temp
Precip
1.0 mm
Thu
26
15° / 4°
Actual Temp
Precip
0.0 mm
Fri
27
10° / 6°
Actual Temp
Precip
19.0 mm
Sat
28
13° / 1°
Actual Temp
Precip
17.0 mm
Sun
29
18° / 6°
Actual Temp
Precip
0.0 mm
Mon
30
15° / 5°
Actual Temp
Precip
0.0 mm
Tue
31
15° / 7°
Actual Temp
Precip
2.0 mm
Spreadsheet: 44ff712a-bedf-405d-bff3-e67128e6dd3e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8201 | 21564 | Franz | [NAME] | AUT | 705 | 0:41:44 | 0:01:42 | 4:46:02 | 0:01:53 | 2:37:12 | 1 | 8:08:35
8201 | 60724 | [NAME] | Nothacker | GER | 216 | 0:39:07 | 0:02:05 | 5:01:56 | 0:02:42 | 2:28:04 | 2 | 8:13:57
8201 | 54216 | [NAME] | Maire | FRA | 215 | 0:42:18 | 0:02:16 | 5:01:27 | 0:03:11 | 2:52:58 | 3 | 8:42:11
8201 | 44547 | [NAME] | Smith | USA | 217 | 0:46:04 | 0:02:58 | 5:04:47 | 0:02:38 | 3:05:18 | 4 | 9:01:46
8201 | 60720 | Remy | Jeannaud | FRA | 214 | 0:44:16 | 0:03:08 | 5:21:11 | 0:04:39 | 3:02:47 | 5 | 9:16:03
8201 | 57911 | Erhard | Hofmann | GER | 213 | 0:45:15 | 0:01:58 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
8201 | 16905 | Gaspare | Fumagalli | ITA | 212 | 0:48:40 | 0:03:46 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 814373d1674323663-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test
Sheet: Formulas

 |  |  |  | APR | MAY | JUN
 |  |  | 2022FY Production Claims |  |  |  | <---------- | Expected results. These results shoulb be automatic, considering the months in Columns A
 |  |  |  | APR | MAY | JUN
 |  |  | 2023FY Production Claims |  |  |  | <---------- | Expected results. These results shoulb be automatic, considering the months in Columns A
 |  |  |  |  |  |  |  |  | Portuguese | SOMARPRODUTO((E4=PROC(LIN($5:$50);LIN($5:$50)/(INDIRETO(("'CLAIM MANAGEMENT "&ESQUERDA($D5;6)&"'!A5:A50")<>"");INDIRETO("'CLAIM MANAGEMENT "&ESQUERDA($D5;6)&"'!A5:A50")))*INDIRETO("'CLAIM MANAGEMENT "&ESQUERDA($D5;6)&"'!C5:C50"))
 |  |  |  |  |  |  |  |  | English | SUMPRODUCT((E4=LOOKUP(ROW($5:$50),ROW($5:$50)/(INDIRECT("'CLAIM MANAGEMENT "&LEFT($D5,6)&"'!A5:A50")<>""),INDIRECT("'CLAIM MANAGEMENT "&LEFT($D5,6)&"'!A5:A50")))*INDIRECT("'CLAIM MANAGEMENT "&LEFT($D5,6)&"'!C5:C50"))
Spreadsheet: 50a81e57-2e9a-4837-a29a-99119e405055
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8501.0 Retail Trade, Australia
 | TABLE 14. Retail Turnover ($ millions), Completely enumerated sector: Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Turnover ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Original | A2528409F | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Seasonally Adjusted | A2528412V | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | $ Millions | FLOW | Month | 1
Turnover ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Trend | A2528406X | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | $ Millions | FLOW | Month | 1
% change from preceding month ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Original | A2528410R | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Seasonally Adjusted | A2528413W | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | Percent | PERCENT | Month | 1
% change from preceding month ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Trend | A2528407A | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | Percent | PERCENT | Month | 1
% change from corresponding month of previous year ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Original | A2528411T | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | Percent | PERCENT | Month | 1
% change from corresponding month of previous year ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Seasonally Adjusted | A2528414X | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | Percent | PERCENT | Month | 1
% change from corresponding month of previous year ;  Total CE and [NAME] ;  Total (Industry) ;  Total (State) ; |  |  | Trend | [NAME] | 1994-04-01 00:00:00 | 2009-05-01 00:00:00 | 182 | Percent | PERCENT | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 541898d1507620772-vlookup-with-if-statement-report
Sheet: Sheet1

 |  |  | Type of Claim | Base | Frame | [NAME] | Fix | PCI | Total
 |  |  | Forecasted Percentage of Return | 0.15 | 0.25 | 0.3 | 0.15 | 0.1
 |  |  | Forecasted Days of Return | 28 | 21 | 49 | 28 | 56
Job Number | Client Name | Total Claim | Start Date | Base | Frame | [NAME] | Fix | PCI | 2017-01-02 00:00:00
 | Villareal | 205750
 | Prado | 254687
24250 | Suñiga | 269730
24162 | Galang | 265798
Should be Result
24250 | Suñiga | 269730
24162 | Galang | 265798
Spreadsheet: 108601d1305639562-formula-help-re-recurring-dates-sample-budge
Sheet: Sheet1

Date
2011-05-05 00:00:00 |  | Pay | 1500 |  | Monthly Bill 1 | 10 |  |  |  |  |  |  |  | 5 | Monthly Bill 1 | 10
2011-05-06 00:00:00 |  |  |  |  | Monthly Bill 2 | 20 |  |  |  |  |  |  |  | 6 | Monthly Bill 2 | 20
2011-05-07 00:00:00 |  |  |  |  | Other Expense | 30 |  | Total In | Total Out | Surplus |  |  |  | 13 | Monthly Bill 3 | 30
2011-05-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | Monthly [NAME] | 40
2011-05-09 00:00:00
2011-05-10 00:00:00
2011-05-11 00:00:00
2011-05-12 00:00:00 |  | Pay | 1500
2011-05-13 00:00:00 |  |  |  |  | Monthly Bill 3 | 30
2011-05-14 00:00:00 |  |  |  |  |  |  |  | Total In | Total Out | Surplus
2011-05-15 00:00:00
2011-05-16 00:00:00
2011-05-17 00:00:00
2011-05-18 00:00:00
2011-05-19 00:00:00 |  | Pay | 1500
2011-05-20 00:00:00
2011-05-21 00:00:00 |  |  |  |  |  |  |  | Total In | Total Out | Surplus
2011-05-22 00:00:00 |  |  |  |  | Monthly [NAME] | 40
2011-05-23 00:00:00
2011-05-24 00:00:00
2011-05-25 00:00:00
2011-05-26 00:00:00 |  | Pay | 1500
2011-05-27 00:00:00
2011-05-28 00:00:00 |  |  |  |  |  |  |  | Total In | Total Out | Surplus
2011-05-29 00:00:00
2011-05-30 00:00:00
2011-05-31 00:00:00
2011-06-01 00:00:00
2011-06-02 00:00:00 |  | Pay | 1500
2011-06-03 00:00:00
2011-06-04 00:00:00
2011-06-05 00:00:00
2011-06-06 00:00:00
2011-06-07 00:00:00
2011-06-08 00:00:00
2011-06-09 00:00:00 |  | Pay | 1500
2011-06-10 00:00:00
2011-06-11 00:00:00
2011-06-12 00:00:00
2011-06-13 00:00:00
2011-06-14 00:00:00
2011-06-15 00:00:00
2011-06-16 00:00:00 |  | Pay | 1500
2011-06-17 00:00:00
2011-06-18 00:00:00
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 |  | Pay | 1500
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 |  | Pay | 1500
Spreadsheet: 147519d1332837520-count-if-formula-ex
Sheet: Individual Summary

[NAME]
Name | Julie |  |  |  | Date | 2012-03-27 00:00:00
Holiday
Holiday Entitlement |  |  | 0
Holiday Taken |  |  | 5
Holiday Left to Take |  |  | -5
Sick Record
Total Sick including Days Taken as Holiday |  |  |  |  | 0
Total Sick including Days Taken as Holiday |  |  |  |  | 0
Abscent
Number of days not in other than sick or holiday |  |  |  |  | 0
Spreadsheet: 771017d1646388954-convert-list-into-calculation-sample-workbook-2
Sheet: summary after

 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
product A | 971 | 443 | 253 |  |  |  | 690
product B | 46 | 634 | 539 | 141 | 227 | 674 | 324
product C | 79 | 504 |  |  |  | 482 | 942
product D | 800 | 960 | 529 | 530 | 292 | 214 | 988
product E | 250 | 400 | 350 | 879 | 350 | 400 | 895
Spreadsheet: 673399d1587369276-calculate-total-hours-that-fall-between-a-specific-time-period-over-midnight-time_fall_1
Sheet: Sheet1

 |  | lower | 22:00:00 | 11:00:00 | 00:00:00 | 02:00:00
 |  | upper | 06:00:00 | 18:00:00 | 06:00:00 | 06:00:00
 | time in | time out
formula 1 | 22:00:00 | 05:00:00
formula 2 | 03:00:00 | 11:00:00
Spreadsheet: phillip_m_love__30653__9903_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 31380295 | 51074660.93
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 4233712 | 7481059.08
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 35614007 | 58555720.01
 | Purchases:
6 |  | 3rd Party / Inter Enron | -32360163 | -50963686.00129999
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -4216311 | -7366436.44
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 668 | 1138.46
 | Total Purchases: |  | -36575806 | -58328983.98129999
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 32125532 | 54612316.88
12 |  | Purchases | -30941648 | -53562657.95
 | Total Intra CTS Sales / Purchases |  | 1183884 | 1049658.93
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 4706694 | 8079290.754192021
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 4706694 | 8079290.754192021
 | Storage:
17 |  | Injection (Sales to Stg) | 994162 | 1829413.25
18 |  | W/D (Purchase from Stg) | -5922941 | -10961586.9087
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -5922941 | -10961586.9087
 | Total Storage: |  | -4928779 | -9132173.6587
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | -668 | -25000
 | Transport Expense:
24 |  | Commodity | 0 | -803059.21
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -803059.21
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 300495.52
31 |  | Prior Month Book Balance | 0 | -421545
 |  | Total MTM Income | 0 | -121049.48
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 1032373.95
34 |  | Originations | 0 | 1776930
35 |  | Broker Fees | 0 | -7855
36 |  | Asset Group Demand Charges | 0 | -30000
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 892374
 |  | TOTAL
FT-South Texas
 |  | Current Month MTM | 0 | 11696534
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | -11438321
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 862284d1710034456-seeking-excel-advice-identifying-unpaired-transactions-with-matching-timestamps-example
Sheet: Sheet1

367275930 | 2023-06-15 19:45:53 | Isolated Margin | Transaction Revenue | [NAME] | 633.6706803
367275930 | 2023-06-15 19:47:01 | Isolated Margin | Transaction Spend | [NAME] | -223.776924
367275930 | 2023-06-15 19:47:01 | Isolated Margin | Transaction Buy | BTC | 0.00883
367275930 | 2023-06-15 19:47:02 | Isolated Margin | Isolated Margin Repayment | BTC | -0.00874001
367275930 | 2023-06-15 19:47:16 | Isolated Margin | Isolated Margin Repayment | [NAME] | -402.83514565
367275930 | 2023-06-15 19:52:28 | Cross Margin | Margin Repayment | [NAME] | -4754.16939319
367275930 | 2023-06-16 00:00:00 | USD-M Futures | Funding Fee | USDT | 0.37494785
367275930 | 2023-06-16 00:00:00 | USD-M Futures | Funding Fee | USDT | 0.31155068
367275930 | 2023-06-16 00:00:01 | USD-M Futures | Funding Fee | USDT | 0.05293099
367275930 | 2023-06-16 00:00:01 | USD-M Futures | Funding Fee | USDT | -0.02936219
367275930 | 2023-06-16 00:00:02 | USD-M Futures | Funding Fee | USDT | -0.01097272
367275930 | 2023-06-16 00:00:04 | USD-M Futures | Funding Fee | USDT | -0.00086564
 | For example  2023-06-15 19:52 Have Margin Repayment but doesn't have a Transaction Sold so it highlight or tell me the line for me to check, exact same time by the minute
 | Alternatively if it can group duplicate dates its also fine like this its also fine
 | 367275930 | 2023-06-15 19:45:53 | Isolated Margin | Transaction Revenue | [NAME] | 633.6706803
 | 367275930 | 2023-06-15 19:47:01 | Isolated Margin | Transaction Spend | [NAME] | -223.776924
 | 367275930 | 2023-06-15 19:47:01 | Isolated Margin | Transaction Buy | BTC | 0.00883
 | 367275930 | 2023-06-15 19:47:02 | Isolated Margin | Isolated Margin Repayment | BTC | -0.00874001
 | 367275930 | 2023-06-15 19:47:16 | Isolated Margin | Isolated Margin Repayment | [NAME] | -402.83514565
 | 367275930 | 2023-06-15 19:52:28 | Cross Margin | Margin Repayment | [NAME] | -4754.16939319
 | 367275930 | 2023-06-16 00:00:00 | USD-M Futures | Funding Fee | USDT | 0.37494785
 | 367275930 | 2023-06-16 00:00:00 | USD-M Futures | Funding Fee | USDT | 0.31155068
 | 367275930 | 2023-06-16 00:00:01 | USD-M Futures | Funding Fee | USDT | 0.05293099
 | 367275930 | 2023-06-16 00:00:01 | USD-M Futures | Funding Fee | USDT | -0.02936219
 | 367275930 | 2023-06-16 00:00:02 | USD-M Futures | Funding Fee | USDT | -0.01097272
 | 367275930 | 2023-06-16 00:00:04 | USD-M Futures | Funding Fee | USDT | -0.00086564
 | So the exact same time are grouped in colour together
Spreadsheet: 857221d1706246772-textjoin-with-delimited-for-same-name-textjoin-by-same-name
Sheet: Sheet1

Company Name | Amended Name |  |  | Amended Name | Custom
ABC Ltd (Taiwan) | ABC Ltd (Taiwan) |  |  | ABC Ltd (Taiwan) | ABC Ltd (Taiwan), ABC Ltd (Taiwan) ([NAME]), ABC Ltd (Taiwan) (XJH22222)
ABC Ltd (Taiwan) ([NAME]) | ABC Ltd (Taiwan) |  |  | Tiger Co | Tiger Co (JZZ88888), [NAME] (ABC77777), [NAME]
ABC Ltd (Taiwan) (XJH22222) | ABC Ltd (Taiwan) |  |  | Black Pte Ltd | Black Pte Ltd, Black Pte Ltd (PKD76251)
Tiger Co (JZZ88888) | Tiger Co |  |  | Monbly (Pte) Ltd | Monbly (Pte) Ltd, Monbly (Pte) Ltd (HTT21212)
Tiger Co (ABC77777) | Tiger Co
Tiger Co | Tiger Co
Black Pte Ltd | Black Pte Ltd
Black Pte Ltd (PKD76251) | Black Pte Ltd
Monbly (Pte) Ltd | Monbly (Pte) Ltd
Monbly (Pte) Ltd (HTT21212) | Monbly (Pte) Ltd
Spreadsheet: 121c8257-182b-4fab-b06f-aebb0b1aa981
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
40853651 | 2014-04-05 15:44:23 | AXIS | 0 | 4 | 6 | 1548840 | basilbulgaratanos | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
40853867 | 2014-04-05 15:54:04 | ALLIES | 1 | 6 | 1 | 1548840 | basilbulgaratanos | 12509 | western | 1944-06-06 |  | [Normandy] Vaumicel Manor | Château de Vaumicel
41004265 | 2014-04-15 19:17:32 | ALLIES | 1 | 6 | 5 | 1149185 | kellogs_10 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
41004494 | 2014-04-15 19:30:39 | AXIS | 1 | 6 | 5 | 1149185 | kellogs_10 | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 760299d1640125949-display-names-of-individuals-trained-small-sample
Sheet: Schedule By Day

Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Goal: This is the schedule by day. What I want the spreadsheet to do is on the next worksheet (Run_Taxi) pull data from the training list and only display the individuals by day that are Run/Taxi and then the same for the confined space. This is a very small sample of what I am trying to do, but if I can get the overall formula or steered in the right direction, then I can make the overall live spreadsheet do what I want it to do.
Spreadsheet: 55c96c88-b223-4f44-92c7-a581db3e800b
Sheet: Figure 4.3 (bottom)

Figure 4.3 Trend in NO2 (top) and NOx (middle) annual mean concentrations (2001–2010) at rural (R), urban (U) and traffic (T) stations. Bottom: percentage frequency distribution of estimated annual change of NO2 annual mean concentrations at urban stations (left) and at traffic stations (right)
Note: All stations in EU Member States, with at least 75 % data coverage for at least 8 years were included in the analysis. Concentrations per station type (T= traffic, U=Urban/Suburban, R=Rural) are given in µg/m3. In the top diagrams a geographical bias exists towards central Europe where there is a higher density of stations. In the percentage frequency distribution graphs, closed bars denote stations showing a statistically significant trend, open bars denote stations with a non-significant trend. Statistically significant trends (level of significance 0.1) are calculated by applying the Mann-Kendall test. The applied method is described in de Leeuw, 2012.
Source: ETC/ACM
The layout version will use colors consistently in the figures, consistent with the color used in Figure 4.2 in the 2011 Report.
Annual mean/day
(sub)urban | P<0.1 | sig P>0.1 | P<0.1 | sig P>0.1
< -3 | 0 | 1 | 0 | 0.1524390243902439
-3 - -2 | 0 | 2 | 0 | 0.3048780487804878
-2 - -1 | 15 | 38 | 2.286585365853659 | 5.792682926829269
-1 - 0 | 283 | 188 | 43.14024390243902 | 28.65853658536586
0 - 1 | 104 | 13 | 15.85365853658537 | 1.981707317073171
1 - 2 | 6 | 5 | 0.9146341463414634 | 0.7621951219512195
2 - 3 | 0 | 1 | 0 | 0.1524390243902439
> 3 | 0 | 0 | 0 | 0
urban traffic | P<0.1 | sig P>0.1 | P<0.1 | sig P>0.1
< -3 | 0 | 2 | 0 | 0.5434782608695652
-3 - -2 | 5 | 7 | 1.358695652173913 | 1.902173913043478
-2 - -1 | 22 | 36 | 5.978260869565218 | 9.782608695652174
-1 - 0 | 135 | 51 | 36.68478260869565 | 13.85869565217391
0 - 1 | 76 | 14 | 20.65217391304348 | 3.804347826086957
1 - 2 | 10 | 9 | 2.717391304347826 | 2.445652173913043
2 - 3 | 0 | 0 | 0 | 0
> 3 | 0 | 1 | 0 | 0.2717391304347826
 |  |  |  |  |  |  |  |  |  |  |  |  | µ