tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 828390d1683468274-sort-function-or-any-ignoring-header-in-existing-let-function-dummy4_revised
Sheet: Sheet1

Sheet | Sheet2 |  |  |  |  |  |  |  |  |  | Sheet | Sheet2
Group |  |  |  |  |  |  |  |  |  |  | Group
 |  |  |  |  |  |  |  |  |  |  | 3rd Sort-Custom | 2st Sort-ascending |  |  | 1st Sort-ascending
 |  |  |  |  |  |  |  |  | Require > |  | Header1 | Header2 | Header5 | Header6 | Header7 | Header8 | Header9 | Header11
 |  |  |  |  |  |  |  |  |  |  | Rose | Ravi | #Test1 | 0 | Avatar@22% | 2696 | King | 88
 |  |  |  |  |  |  |  |  |  |  | Lily | Ajit | #Test1 | 0 | Jurrasic Park@95% | ADFG | 0 | 66
 |  |  |  |  |  |  |  |  |  |  | Lily | Ajit | #Test1 | 0 | Titanic@99% | 64638 | 0 | 72
 |  |  |  |  |  |  |  |  |  |  | Jasmine | Ram | #Test1 | Desktop | ABC@7% | 64638 | District | 47
 |  |  |  |  |  |  |  |  |  |  | Jasmine | [NAME] | #Test1 | Popy | [NAME] Winlet@80% | 126364 | Text1 | 2
 |  |  |  |  |  |  |  |  |  |  | Jasmine | Ram | #Test1 | Tesla | Madonna@60% | 126364 | [NAME] | 97
 |  |  |  |  |  |  |  |  |  |  | Jasmine | [NAME] | #Test1 | Poly | Madonna@60% | 895634 | Electro | 98
Spreadsheet: 886410d1736438198-concat-groups-of-multiple-cells-in-a-column-into-multiple-single-cells-in-a-column-sample-6-scifisicko-
Sheet: Sheet1

 | Form 51 | Itemised schedule of costs for adjudication
 | ITEMISED SCHEDULE OF COSTS FOR ADJUCATION
 | FIRST PART - SOLICITORS' FEES FROM 4.1.12 TO 28.12.12
 | (Presented pursuant to the orders of His Honour Judge [NAME] dated 29 July 2016)
Amounts | Item No | Date | Original Text |  | Units | Comment |  | Item No | Date | New text | Units
disallowed
 | 1030 | 1/6/12 | Solicitor preparing drafting and sending letter to _____ regarding |  |  |  |  |  |  | Solicitor attending telephone conference upon [NAME]
 |  |  | Instructions provided by client (2 pages) - M
 |  |  |  |  | 4 |  |  |  |  | Solicitor perusing and considering correspondence from Family Court re _______________ enclosing stamped copy of draft index filed on 30th May 2012 for immediate service upon respondent (4 pages) - M
 | 1031 | 1/6/12 | Solicitor attending telephone conference upon [NAME]
 |  |  |  |  | 2 |  |  |  |  | Solicitor attending telephone conference upon X re valuation and passport - M
 | 1032 | 1/6/12 | Solicitor perusing and considering correspondence from Family Court re
 |  |  | _______________ enclosing stamped copy of draft index filed on 30th |  |  |  |  |  |  | Solicitor perusing and considering email 4.14pm from X to Y cc’d to us re Z - Family Court Proceedings enclosing copy of letter dated 1st June 2012 advising that the final hearing date was not addressed due to they had not received the preliminary documents requested in October 2011 by the end of January 2012 (2 pages) - M
 |  |  | May 2012 for immediate service upon respondent (4 pages) - M
 |  |  |  |  | 1
 | 1033 | 1/6/12 | Solicitor attending telephone conference upon X re valuation and
 |  |  | passport - M
 |  |  |  |  | 2
 | 1034 | 1/6/12 | Solicitor perusing and considering email 4.14pm from X to Y
 |  |  | [NAME] to us re Z - Family Court Proceedings enclosing copy of letter dated
 |  |  | 1st June 2012 advising that the final hearing date was not addressed due to they
 |  |  | had not received the preliminary documents requested in October 2011 by the
 |  |  | end of January 2012 (2 pages) - M
 |  |  |  |  | 2
Spreadsheet: joe_parks__14601__POSTIONTRAX_OCT
Sheet: KATY_aug

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 |  |  |  |  |  |  |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 3 DAY ROLL
 |  |  | ROLL VALUE
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 781174d1653045421-formula-for-sequential-id-with-letters-and-numbers-number-sequencing-for-id-aligw
Sheet: Sheet1

ID | NAME
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 90703d1290470183-automatically-update-the-list-primer
Sheet: products

rb | naziv | šifra | jm | cijena | stanje
1 | artikl1 | [NAME] | [NAME] | 7 | 210
2 | artikl2 | A102 | [NAME] | 11 | 110
3 | artikl3 | A103 | [NAME] | 12 | 100
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 1

 | Nov 23 | Nov 30 | Dec 7 | Dec 14 | Dec 21
Total Interest Rates* | 381458122 | 386135995 | 386815002 | 373815958 | 171218535
Cleared** | 175615802 | 176458645 | 176258249 | 178728485 | 171218535
Uncleared | 205842319 | 209677350 | 210556753 | 195087473 | N/A
Total Cross-Currency | 18336792 | 16707328 | 16715730 | 14833311 | N/A
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 18336792 | 16707328 | 16715730 | 14833311 | N/A
Total Credit | 22536533 | 22327751 | 22348723 | 22483711 | 20541675
Cleared | 2782197 | 2722339 | 2756560 | 2774168 | 2540603
Uncleared | 19754336 | 19605412 | 19592163 | 19709543 | 18001072
Total Equities | 6121616 | 6121616 | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 6121616 | 6121616 | N/A | N/A | N/A
Total Commodities | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 431544063 | 434383690 | 428970455 | 414223980 | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared 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: 29ba8440-9a94-4a87-994f-de76c2910b5e
Sheet: Sheet1

Deadline is Thursday, May 7th - 9pm |  |  |  |  |  |  |  | School | _______________________
Late Entries Pay Double - Send Checks to WCHS or bring it with you on May 9th
e-mail this Excel Document to [NAME]
[EMAIL] |  |  |  |  | Coach |  | __________________ |  |  |  |  | Total Entry Fee | __________
List your athletes that will compete in individual events and a realistic seed performance.
Remember, every individual event entered is $3.00 (If [NAME] runs the 100 & LJ, that's $6.00)
Last | First | 100 |  | 400 |  | 3200 |  | 300H |  |  | HJ | PV | LJ | SP | DT
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
(Insert more text rows if needed)
No need to list the names of the Relay team members, just list a seed time for each relay team (Each Relay entry is $10.00)
4x100 Seed Time
4x400 Seed Time
4x800 Seed Time
Spreadsheet: 38524d1236690114-summarizing-data-over-several-sheets-new-bolts-list
Sheet: BoltsP3

 | BOLTS LIST | BOLTS LIST
CLIENT |  |  |  |  |  | JOB No.
PLANT |  |  |  |  |  |  | LIST No.   3   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
Spreadsheet: phillip_allen__28905__Socal_March
Sheet: My_forecast

 |  | Receipts |  | Sendouts |  | Balance
2001-02-14 00:00:00 |  | 3650000
2001-02-15 00:00:00 |  | 3650000
2001-02-16 00:00:00 |  | 3650000
2001-02-17 00:00:00 |  | 3650000
2001-02-18 00:00:00 |  | 3650000
2001-02-19 00:00:00 |  | 3650000
2001-02-20 00:00:00 |  | 3650000
2001-02-21 00:00:00 |  | 3650000
2001-02-22 00:00:00 |  | 3650000
2001-02-23 00:00:00 |  | 3650000
2001-02-24 00:00:00 |  | 3650000
2001-02-25 00:00:00 |  | 3650000
2001-02-26 00:00:00 |  | 3650000
2001-02-27 00:00:00 |  | 3650000
2001-02-28 00:00:00 |  | 3650000
 |  |  |  |  |  | 15000000
2001-03-01 00:00:00 | 31 | 3650000 |  | 3500000
2001-04-01 00:00:00 | 30 | 3650000 |  | 3000000
2001-05-01 00:00:00 | 31 | 3600000 |  | 3000000
2001-06-01 00:00:00 | 30 | 3500000 |  | 3300000
2001-07-01 00:00:00 | 31 | 3500000 |  | 3500000
2001-08-01 00:00:00 | 31 | 3450000 |  | 3700000
2001-09-01 00:00:00 | 30 | 3450000 |  | 3600000
2001-10-01 00:00:00 | 31 | 3400000 |  | 3400000
2001-11-01 00:00:00 | 30 | 3400000 |  | 3500000
2001-12-01 00:00:00 | 31 | 3400000 |  | 3900000
2002-01-01 00:00:00 | 31 | 3400000 |  | 4000000
2002-02-01 00:00:00 | 28 | 3400000 |  | 3700000
2002-03-01 00:00:00 | 31 | 3400000 |  | 3300000
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1

Jornada | 6
Arsenal | 1 | 2 | Chelsea
Everton | 3 | 1 | Southampton
Fulham | 1 | 2 | Manchester City
Norwich City | 2 | 5 | Liverpool
Reading | 2 | 2 | Newcastle United
Stoke City | 2 | 0 | Swansea City
Sunderland | 1 | 0 | Wigan Athletic
[NAME] | 2 | 3 | [NAME]
[NAME] | 1 | 1 | West Bromwich Albion
Queen Parks Rangers | 1 | 2 | West Ham United
Spreadsheet: 38122d1236250765-ms-excel-conditional-rank-conditional-rank
Sheet: Sheet1

Data
Name | Water |  | [NAME]. |  | Petrol
 | LM | TM | LM | TM | LM | TM
[NAME] | 80 | 75 | 90 | 85 | 30 | 60
[NAME] | 70 | 66 | 90 | 22 | 20 | 10
[NAME] | 10 | 15 | 50 | 28 | 25 | 95
Expected Results : To rank horizontally for TM Only
Name | Rank1 | Rank2 | Rank3 | Water |  | [NAME]. |  | Petrol
 |  |  |  | LM | TM | LM | TM | LM | TM
[NAME] | [NAME]. | Water | Petrol | 80 | 75 | 90 | 85 | 30 | 60
[NAME] | Water | [NAME] | Petrol | 70 | 66 | 90 | 22 | 20 | 10
[NAME] | Petrol | [NAME] | Water | 10 | 15 | 50 | 28 | 25 | 95
Spreadsheet: 139538d1328287439-dates-for-4-day-working-week-help-4-week-calander
Sheet: Sheet1

0 | Product | Date | Capacity | Demand | Condor Demand | Total Condor Demand
1 | A | 2012-01-02 00:00:00
2 | B | 2012-01-02 00:00:00
3 | C | 2012-01-02 00:00:00 |  |  |  | 0
4 | D | 2012-01-02 00:00:00
5 | E | 2012-01-02 00:00:00
6 | F | 2012-01-02 00:00:00
7 | G | 2012-01-02 00:00:00
8 | Other | 2012-01-02 00:00:00
1 | A | 2012-01-03 00:00:00
2 | B | 2012-01-03 00:00:00
3 | C | 2012-01-03 00:00:00 |  |  |  | 0
4 | D | 2012-01-03 00:00:00
5 | E | 2012-01-03 00:00:00
6 | F | 2012-01-03 00:00:00
7 | G | 2012-01-03 00:00:00
8 | Other | 2012-01-03 00:00:00
1 | A | 2012-01-04 00:00:00
2 | B | 2012-01-04 00:00:00
3 | C | 2012-01-04 00:00:00 |  |  |  | 0
4 | D | 2012-01-04 00:00:00
5 | E | 2012-01-04 00:00:00
6 | F | 2012-01-04 00:00:00
7 | G | 2012-01-04 00:00:00
8 | Other | 2012-01-04 00:00:00
1 | A | 2012-01-05 00:00:00
2 | B | 2012-01-05 00:00:00
3 | C | 2012-01-05 00:00:00 |  |  |  | 0
4 | D | 2012-01-05 00:00:00
5 | E | 2012-01-05 00:00:00
6 | F | 2012-01-05 00:00:00
7 | G | 2012-01-05 00:00:00
8 | Other | 2012-01-05 00:00:00 |  |  |  |  |  | 2012-01-05 00:00:00 | THURSDAY
1 | A | 2012-01-06 00:00:00 |  |  |  |  |  |  | Monday
2 | B | 2012-01-06 00:00:00
3 | C | 2012-01-06 00:00:00 |  |  |  | 0
4 | D | 2012-01-06 00:00:00
5 | E | 2012-01-06 00:00:00
6 | F | 2012-01-06 00:00:00
7 | G | 2012-01-06 00:00:00
8 | Other | 2012-01-06 00:00:00
1 | A | 2012-01-07 00:00:00
2 | B | 2012-01-07 00:00:00
3 | C | 2012-01-07 00:00:00 |  |  |  | 0
4 | D | 2012-01-07 00:00:00
5 | E | 2012-01-07 00:00:00
6 | F | 2012-01-07 00:00:00
7 | G | 2012-01-07 00:00:00
8 | Other | 2012-01-07 00:00:00
1 | A | 2012-01-08 00:00:00
2 | B | 2012-01-08 00:00:00
3 | C | 2012-01-08 00:00:00 |  |  |  | 0
4 | D | 2012-01-08 00:00:00
5 | E | 2012-01-08 00:00:00
6 | F | 2012-01-08 00:00:00
7 | G | 2012-01-08 00:00:00
8 | Other | 2012-01-08 00:00:00
1 | A | 2012-01-09 00:00:00
2 | B | 2012-01-09 00:00:00
3 | C | 2012-01-09 00:00:00 |  |  |  | 0
4 | D | 2012-01-09 00:00:00
5 | E | 2012-01-09 00:00:00
6 | F | 2012-01-09 00:00:00
7 | G | 2012-01-09 00:00:00
8 | Other | 2012-01-09 00:00:00
1 | A | 2012-01-10 00:00:00
2 | B | 2012-01-10 00:00:00
3 | C | 2012-01-10 00:00:00 |  |  |  | 0
4 | D | 2012-01-10 00:00:00
5 | E | 2012-01-10 00:00:00
6 | F | 2012-01-10 00:00:00
7 | G | 2012-01-10 00:00:00
8 | Other | 2012-01-10 00:00:00
1 | A | 2012-01-11 00:00:00
2 | B | 2012-01-11 00:00:00
3 | C | 2012-01-11 00:00:00 |  |  |  | 0
4 | D | 2012-01-11 00:00:00
5 | E | 2012-01-11 00:00:00
6 | F | 2012-01-11 00:00:00
7 | G | 2012-01-11 00:00:00
8 | Other | 2012-01-11 00:00:00
1 | A | 2012-01-12 00:00:00
2 | B | 2012-01-12 00:00:00
3 | C | 2012-01-12 00:00:00 |  |  |  | 0
4 | D | 2012-01-12 00:00:00
5 | E | 2012-01-12 00:00:00
6 | F | 2012-01-12 00:00:00
7 | G | 2012-01-12 00:00:00
8 | Other | 2012-01-12 00:00:00
1 | A | 2012-01-13 00:00:00
2 | B | 2012-01-13 00:00:00
3 | C | 2012-01-13 00:00:00 |  |  |  | 0
4 | D | 2012-01-13 00:00:00
5 | E | 2012-01-13 00:00:00
6 | F | 2012-01-13 00:00:00
7 | G | 2012-01-13 00:00:00
8 | Other | 2012-01-13 00:00:00
Spreadsheet: 725506d1616706831-vlookup-if-text-is-present-ssp-test
Sheet: Complete Course List

Include (Enter Y) | Course list | Module | Learning Path
 | 101: Getting Started | General | 101
 | Feature Overview: People Groups | General | 101
 | Report Overview: Leakage Tree | Shopper | 101
 | Report Overview: Shopper Metrics | Shopper | 101
 | Report Overview: Psychographics | People | 101
 | Report Overview: Shopper Profile | People | 101
 | Report Overview: Basket Affinity | People | 101
 | Pro Tips: Hierarchies & Advanced Options | General | 201
 | Feature Overview: Trip Groups | General | 201
 | Pro Tips: Advanced People Groups | General | 201
 | Feature Overview: Advanced Product Groups | General | 201
 | Pro Tips: Workflow Tips | General | 201
 | Pro Tips: Efficiency Hacks | General | 201
 | Report Overview: Retailer Share of Wallet | Shopper | [NAME]
 | Report Overview: Store Diagnostics | Shopper | [NAME]
 | Report Overview: Store Loyalty Flow | Shopper | [NAME]
 | Report Overview: Cross Purchase | People | -
 | Report Overvew: Media Consumption | People | -
 | Report Overview: Household Affinity | People | -
 | Report Overview: Lapsed, Repeat, New | Shopper | -
 | Report Overview: Promotion Effectiveness | Shopper | -
 | Report Overview: Shopper Histogram | Shopper | -
 | Report Overview: Trip Circuits | Shopper | -
 | Report Overview: Trip Type Profile | Shopper | -
 | Report Overview: Brand Diagnostics | Brand | -
 | Report Overview: Bricks & Clicks | Brand | -
 | Report Overview: Buyer Loyalty Flow | Brand | -
 | Report Overview: Data Explorer | Brand | Brand
 | Report Overview: High, Medium, Low | Brand | -
 | Report Overview: People Scorecard | Brand | Brand
 | Report Overview: Share Explorer | Brand | Brand
 | Report Overview: Trended Metrics Scorecard | Brand | Brand
 | About Promo | Promo | Promo
 | Promo  Groups | Promo | Promo
 | Promo : Promo Brand Switching | Promo | Promo
 | Promo : Promo Store Switching | Promo | Promo
 | Promo : Promo Shopper Conversion | Promo | Promo
Spreadsheet: 221128d1363373980-comparing-columns-for-greatest-value-across-multiple-columns-example
Sheet: Sheet1

10 | 1 | 6 | 7 | 1
8 | 2 | 1 | 2 | 10
3 | 9 | 6 | 5 | 8
9 | 10 | 9 | 7 | 5
10 | 8 | 4 | 6 | 4
5 | 1 | 6 | 4 | 9
4 | 7 | 1 | 1 | 9
5 | 4 | 3 | 3 | 10
3 | 4 | 3 | 1 | 10
4 | 3 | 2 | 10 | 9
1 | 5 | 10 | 7 | 5
7 | 9 | 4 | 3 | 2
6 | 9 | 6 | 6 | 3
7 | 2 | 3 | 7 | 5
9 | 1 | 2 | 4 | 3
4 | 7 | 5 | 2 | 3
4 | 8 | 7 | 2 | 1
3 | 1 | 3 | 5 | 6
6 | 1 | 4 | 8 | 10
3 | 4 | 2 | 8 | 7
1 | 6 | 5 | 3 | 10
6 | 9 | 4 | 3 | 3
8 | 10 | 2 | 5 | 7
6 | 9 | 1 | 7 | 8
8 | 1 | 9 | 7 | 7
2 | 5 | 1 | 4 | 2
4 | 3 | 10 | 2 | 2
10 | 9 | 3 | 1 | 5
6 | 8 | 9 | 3 | 2
3 | 6 | 9 | 4 | 4
4 | 2 | 9 | 2 | 2
7 | 7 | 2 | 1 | 8
7 | 6 | 5 | 6 | 4
3 | 4 | 4 | 3 | 9
7 | 6 | 7 | 1 | 5
9 | 10 | 9 | 7 | 1
7 | 8 | 8 | 5 | 6
3 | 8 | 7 | 4 | 8
7 | 6 | 7 | 7 | 9
10 | 3 | 10 | 9 | 7
8 | 7 | 7 | 1 | 5
7 | 7 | 4 | 9 | 4
4 | 3 | 5 | 3 | 3
5 | 10 | 7 | 3 | 3
4 | 2 | 4 | 5 | 1
10 | 9 | 3 | 10 | 7
9 | 6 | 8 | 1 | 4
9 | 2 | 1 | 1 | 6
9 | 1 | 5 | 1 | 3
6 | 2 | 7 | 4 | 4
10 | 6 | 7 | 2 | 3
4 | 5 | 1 | 1 | 9
10 | 9 | 10 | 4 | 6
2 | 8 | 9 | 9 | 10
3 | 1 | 6 | 8 | 10
10 | 2 | 1 | 9 | 8
2 | 1 | 5 | 10 | 6
8 | 5 | 7 | 4 | 1
2 | 4 | 6 | 2 | 10
8 | 6 | 5 | 4 | 1
6 | 1 | 10 | 7 | 7
4 | 5 | 5 | 9 | 10
7 | 4 | 2 | 1 | 7
5 | 9 | 4 | 9 | 9
4 | 8 | 10 | 1 | 7
6 | 6 | 3 | 7 | 5
6 | 10 | 2 | 10 | 4
6 | 8 | 10 | 8 | 9
9 | 9 | 8 | 7 | 9
6 | 5 | 10 | 7 | 10
5 | 6 | 10 | 5 | 6
1 | 2 | 10 | 6 | 8
7 | 3 | 3 | 10 | 7
3 | 8 | 1 | 7 | 5
1 | 2 | 3 | 2 | 4
3 | 8 | 1 | 5 | 2
8 | 10 | 3 | 5 | 2
10 | 10 | 5 | 1 | 4
5 | 5 | 1 | 6 | 5
2 | 10 | 2 | 3 | 10
2 | 5 | 7 | 9 | 6
5 | 6 | 9 | 2 | 9
3 | 8 | 7 | 7 | 2
6 | 4 | 1 | 10 | 2
6 | 4 | 3 | 8 | 3
1 | 2 | 3 | 10 | 6
10 | 10 | 3 | 6 | 8
9 | 3 | 2 | 3 | 4
3 | 7 | 1 | 6 | 9
8 | 6 | 6 | 2 | 9
7 | 1 | 9 | 1 | 6
5 | 7 | 4 | 9 | 1
1 | 2 | 9 | 7 | 10
1 | 7 | 6 | 5 | 2
3 | 8 | 5 | 8 | 2
7 | 5 | 9 | 10 | 2
5 | 9 | 5 | 7 | 10
7 | 9 | 5 | 10 | 2
5 | 7 | 4 | 10 | 2
4 | 1 | 8 | 3 | 6
 | Works for 2 columns |  |  |  |  |  |  |  |  |  | Works but doubles the area of the table
Spreadsheet: 58334d1258595021-pulling-multiple-and-varied-of-rows-from-one-sheet-into-another-commission-report-test
Sheet: Incentive Payment Summary

 | Name |  | Employee Name
 | Number |  | 111
 | Employee #: |  | Employee Number
 | Incentive Payment Summary
 |  | Total Incentive Payment | Dealer Incentive | Retail Incentive | Windsor Incentive
 |  | 1137.1229 | 27.968 | 1109.1549 | 0
 | Incentive Payment Details
 | Customer # | Customer Name | Sales | Territory | Cust Type | Currency
 | S018 | AAA | 2549.22 | 1 | L | CD
 | S023 | BBB | 23547.55 | 1 | L | CD
Spreadsheet: 778343d1651010233-index-and-match-with-countif-countif-forum
Sheet: Sheet1

MRN | # Of times Seen |  | MRN Total
18234 | 1 |  | 18234
18259 | 0 |  | 126268
76503 | 0 |  | 129690
80168 | 0 |  | 129690
97881 | 0 |  | 129690
99739 | 0 |  | 168351
126268 | 1
129690 | 3
144634 | 0
160085 | 0
168351 | 1
Spreadsheet: 791259d1660225769-insert-additional-rows-into-data-at-specific-points-insert-extra-rows
Sheet: Sheet1

Raw data (eg 50000 rows) |  |  |  |  | Desired result
x | y | [NAME]
5 | 2 | 1 |  |  | pline | pline
5 | 3 | 2 |  |  |  | 5,2
5 | 4 | 3 |  |  |  | 5,3
5 | 5 | 4 |  |  |  | 5,4
5 | 6 | 5 |  |  |  | 5,5
3 | 7 | 1 |  |  |  | 5,6
4 | 7 | 2
5 | 7 | 3 |  |  | pline | pline
2 | 2 | 1 |  |  |  | 3,7
3 | 3 | 2 |  |  |  | 4,7
4 | 4 | 3 |  |  |  | 5,7
5 | 5 | 4
 |  |  |  |  | pline | pline
 |  |  |  |  |  | 2,2
 |  |  |  |  |  | 3,3
 |  |  |  |  |  | 4,4
 |  |  |  |  |  | 5,5
Spreadsheet: 93981d1293738098-how-to-calculate-the-sum-of-two-names-in-one-formula-worksheet
Sheet: Sheet1

Date | customer/Job | employee | start time | stop time | Actual Time | Billed time | Work Description |  | Employee | Customer | Hours Billed
2010-09-07 00:00:00 | Mr. [NAME] | Billy | 18:30:00 | 23:00:00 |  |  | [NAME] |  | Billy
2010-09-08 00:00:00 | Mrs. [NAME] | [NAME] | 18:00:00 | 1:00:00 | 06:00:00 |  | Welded Chassis |  | [NAME]
2010-09-08 00:00:00 | Mr. [NAME] | [NAME] | 18:30:00 | 19:30:00 |  |  | Trinary Switch for A/C |  | [NAME]
2010-09-09 00:00:00 | Mrs. [NAME] | Billy | 18:30:00 | 19:30:00 |  |  | Trinary Switch for A/C
2010-09-10 00:00:00 | Mr. [NAME] | [NAME] | 09:00:00 | 11:00:00 |  |  | Trinary Switch for A/C
Spreadsheet: 0fe31ad4-7277-49d0-9976-b936ffd5606d
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
 | 5671.0 Lending Finance, Australia
 | TABLE 5. PERSONAL FINANCE COMMITMENTS, Revolving Credit Stocks and Flows: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
New and increased credit limits - Secured ; |  |  | Original | A2413482A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
New and increased credit limits - Unsecured ; |  |  | Original | A2413483C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
New and increased credit limits - Total ; |  |  | Original | A2413484F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Cancellations and reductions ; |  |  | Original | A2413485J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Total credit limits at end of month ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Credit used at end of month ; |  |  | Original | A2413487L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 819992d1677804214-how-to-alternate-cell-format-style-within-a-single-conditional-formatting-rule-book_251717-2
Sheet: Calendar

Month: | Year: |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY
October | 2023
January | 2022
February | 2023
March | 2024
April | 2025
May | 2026
June | 2027
July | 2028
August | 2029
September | 2030
October | 2031
November | 2032
December | 2033
Spreadsheet: 672795d1587014201-function-to-pull-entire-row-based-on-criteria-macro12_-example-month_1
Sheet: Data

Pnr | Pname | Ename | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
[NAME] | Project A | [NAME] | 5
A012345 | Project A | [NAME] | 55
A009876 | Project A | [NAME] | 55
[NAME] | Project B | [NAME] |  | 20
A012345 | Project B | [NAME] | 93 | 2090
[NAME] | Project B | [NAME] |  | 60
[NAME] | Project C | [NAME] |  |  | 80
A012345 | Project C | [NAME]
A009876 | Project C | [NAME] |  |  | 87
Spreadsheet: 840366d1692690340-power-query-fill-up-fill-down-fill
Sheet: Sheet1

 |  |  | DATA
 |  |  | Employee ID | date | [NAME] | Current branchid
 |  |  | 1010 | 2022-11-05 00:00:00 | 526
 |  |  |  | 2022-11-18 00:00:00 | 111
 |  |  | 1010 | 2022-11-23 00:00:00 | 111
 |  |  | 995 | 2022-11-26 00:00:00 | 111
 |  |  | 1050 | 2022-11-26 00:00:00 | 510 | 7
 |  |  | 1010 | 2022-11-28 00:00:00 | 526 | 15
 |  |  | 1050 | 2022-11-28 00:00:00
 |  |  | 995 | 2022-11-28 00:00:00 |  | 8
 |  |  |  | 2022-11-29 00:00:00 | 52
 |  |  | 995 |  | 111
 |  |  | 1050 | 2022-12-03 00:00:00 | 510
 |  |  | 1010 | 2022-12-03 00:00:00 | 526
 |  |  | 995 |  |  | 8
 |  |  | 1010 | 2023-12-04 00:00:00 | 526 | 9
 |  |  | PQ Output
 |  |  |  | Result of a Fillup / Fill Down based on Employee ID and Date |  |  |  |  | Unexpected Result
 |  |  |  |  |  |  |  |  | Expected Results
 |  |  | Employee ID | branchid | date | [NAME] | Current  branchid |  | branchid | Current  branchid
 |  |  | 995 |  | 2022-11-26 00:00:00 | 111 |  |  | 8
 |  |  | 995 | 8 | 2022-11-28 00:00:00 |  |  |  | 8 | 8
 |  |  | 995 | 8 | 2022-12-03 00:00:00 | 111 |  |  | 8
 |  |  | 995 | 8 | 2022-12-05 00:00:00 |  |  |  | 8 | 8
 |  |  | 1010 |  | 2022-11-05 00:00:00 | 526 |  |  | 15
 |  |  | 1010 |  | 2022-11-23 00:00:00 | 111 |  |  | 15
 |  |  | 1010 | 15 | 2022-11-28 00:00:00 | 526 |  |  | 15 | 15
 |  |  | 1010 | 15 | 2022-12-03 00:00:00 | 526 |  |  | 15
 |  |  | 1010 | 9 | 2023-12-04 00:00:00 | 526 |  |  | 9 | 9
 |  |  | 1050 | 7 | 2022-11-26 00:00:00 | 510 |  |  | 7 | 7
 |  |  | 1050 | 7 | 2022-11-28 00:00:00 |  |  |  | 7
 |  |  | 1050 | 7 | 2022-12-03 00:00:00 | 510 |  |  | 7
 |  |  |  |  | 2022-11-18 00:00:00 | 111 |  |  | [NAME]
 |  |  |  |  | 2022-11-29 00:00:00 | 52 |  |  | [NAME]
Spreadsheet: 105455d1302798707-pull-data-from-various-worksheets-into-a-summary-sheet-test-automerge-data-erica
Sheet: 3 BMNNC002

NEAL NORTH UNLOADING REPORT
 | TRAIN SEQUENCE # |  |  | 2 |  | Double click tif icon to see fax / car list.
 | TRAIN ID |  |  | BMNNC002
 | NUMBER OF CARS |  |  | 138
TRAIN STATUS |  |  |  |  | MM/DD/YY HH:MM
TIME IN |  |  |  |  | 2011-01-05 19:30:00
DELAY BETWEEN TIME Y/N---REASON
TIME SPOTTED |  |  |  |  | 2011-01-05 20:30:00
TIME OUT |  |  |  |  | 2011-01-06 05:00:00
 | DISABILITY |  |  |  | MM/DD/YY HH:MM | MM/DD/YY HH:MM
 |  |  |  |  | (Begin) | (End)
MidAmerican Unloading Disability
1 | Shaking of railcars due to accumulation of snow and ice |  |  |  |  |  | 1:00:00
 | Railroad Unloading Delay
 | Additional Comments
 | [NAME] ORDERS
 | Unload Time Spot to release
 | Total Disabilities
 | Net Unloading time
Train Ahead ID
 | Completed by
 | [NAME] |  |  | DISABILITY LETTER |  |  | Y | N