tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 32a650b9-e38e-4eaf-956c-771474696dfd
Sheet: Sheet1

2013 CIF-SS/FORD 8-MAN FOOTBALL DIVISION 1 CHAMPIONSHIPS, presented by Farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | 8-MAN DIVISION 1
1ST ROUND |  | 2ND ROUND | SEMIFINALS | FINAL ROUND
FRI. NOV. 8 |  | FRI. NOV. 15 | FRI. NOV. 22 | FRI. NOV. 29
 |  |  |  | SAT. NOV. 30
*Mojave | Freelance - At Large
 |  | Mojave
Fri 11/8 @ 7:30 pm |  | 55-6
[NAME] | Heritage - At Large | [NAME]
 |  | Fri. @ 5:00 pm | Avalon | COACHES:
 |  | F | 44-27 | PLEASE REPORT ALL SCORES TO:
*Avalon | Coastal #1 |  |  | www.cifsshome.org
 |  | *Avalon
Fri. 11/8 @ 5:00 pm [NAME] |  | 74-24
Dunn | Condor - At Large
 |  |  |  | *Faith Baptist
 |  |  | Sat. 11/23 @ Noon | 36-28
*Lone Pine | Hi-Lo #1
 |  | *Faith Baptist
Fri. 11/8 @ 7:00 pm |  | 65-14
Faith Baptist | Heritage - At Large
 |  |  | *Faith Baptist
 |  | Fri. @ 2:30 pm | 50-22
*Cate | Condor #1
 |  | Cate
Sat. 11/9 @ 1:30 pm |  | 59-18
Upland Christian | Agape - At Large
 |  |  | F |  | Faith Baptist
 |  |  | Sat. 11/30 @ 1:30 pm |  | 74-22
*Lucerne Valley | Agape #1
 |  | Lucerne Valley
Fri. 11/8 @ 7:00 pm |  | 70-36
Nuview Bridge | Warrior - At Large | Sat. 11/16 @ 2:00 pm
 |  | F | *Lucerne Valley
 |  |  | 36-20
*Thacher | Condor - At Large
 |  | *Thacher
Sat. 11/9 @ 2:00 pm |  | 44-8
[NAME]. | Heritage - At Large
 |  |  |  | Coast Union
 |  |  | Fri. @ 7:00 pm | 48-22
*Laguna Blanca | Condor - At Large
 |  | [NAME]
Sat. 11/9 @ 1:00 pm |  | 47-22
Pacific Lutheran | Freelance - At Large
 |  | F | Coast Union
 |  | Fri. @ 7:00 pm | 47-20
*Coast Union | Coast Valley #1
 |  | *Coast Union
Fri. 11/8 @ 7:00 pm |  | 76-14
Concordia/Sylmar | Omega - At Large
*Denotes Host Team
PLEASE REPORT ALL SCORES TO: |  | www.cifsshome.org
This draw sheet was made based upon information available to the CIF-SS as of 11/3/13.  We reserve the right to adjust the draw sheet as a result of information
which would update any final league standings.  All games will start at 7:30 p.m.on Friday or 1:00 p.m. on Saturday, unless another time is mutually agreed upon and clearance is
received from the CIF-SS office.  Public coin flips will be held in the lobby according to the following schedule: Second Round-Nov.4.
Semifinal round-Nov. 11 at 9:00 a.m., Final round-Nov. 18 at 9:00 a.m. PLEASE CALL SCORES INTO THE SPORTS DESK:  LOS ANGELES TIMES (213) 237-7151 OR
1-800-LA TIMES ([PHONE]) [NAME];  THE REGISTER (714) 796-7804; [NAME] (714) 420-6713 AND L.A. DAILY NEWS (800) 888-6009. Please contact your local paper
as well as the papers listed above with your scores. Draw results available on our web site @  www.cifss.org
Spreadsheet: 215657d1361447500-extracting-rows-from-a-spreadsheet-based-on-a-unique-code-that-may-appear-in-two-columns-example
Sheet: Sheet1

TranMType | TranSType | TranDate | NC Credit | [NAME] | Net
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 123.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 80.85
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 204.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 279.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 179.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 199.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 509.5
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 107.8
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 126.5
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 249.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 115.5
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 137.5
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 107.8
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 214.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 140.8
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 199.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 240.95
PUR | PurInvoice | 41183 | 6610/ | 2626/05 | 260.95
PUR | PurInvoice | 41185 | 6610/ | 2626/05 | 199
PUR | PurInvoice | 41185 | 6610/ | 2626/05 | 6
PUR | PurInvoice | 41186 | 6610/ | 2626/05 | 133
PUR | PurInvoice | 41188 | 6610/ | 2626/05 | 257.4
PUR | PurInvoice | 41193 | 6610/ | 2665/03 | 110
PUR | PurInvoice | 41208 | 6610/ | 2626/05 | -27.99
PUR | PurInvoice | 41213 | 6610/ | 2665/02 | 14.98
PUR | PurInvoice | 41213 | 6610/ | 2665/02 | 31.6
[NAME] | Journal | 41213 |  | 2665/02 | 8.33
PUR | PurInvoice | 41218 | 6610/ | 2626/05 | 146.5
PUR | PurInvoice | 41219 | 6610/ | 2626/05 | 12143.07
PUR | PurInvoice | 41232 | 6610/ | 2626/05 | 440.4
PUR | PurInvoice | 41236 | 6610/ | 2626/25 | 1300
PUR | PurInvoice | 41241 | 6610/ | 2665/02 | 139.6
PUR | PurInvoice | 41243 | 6610/ | 2665/02 | 139.6
PUR | PurInvoice | 41243 | 6610/ | 2665/02 | 58.31
[NAME] | Journal | 41243 |  | 2665/02 | 464
PUR | PurInvoice | 41260 | 6610/ | 2665/03 | 50.5
PUR | PurInvoice | 41271 | 6610/ | 2665/02 | 2.95
PUR | PurInvoice | 41271 | 6610/ | 2665/02 | 11.99
PUR | PurInvoice | 41271 | 6610/ | 2665/02 | 8
PUR | PurInvoice | 41271 | 6610/ | 2665/02 | 81.06
PUR | PurInvoice | 41271 | 6610/ | 2665/02 | 28
PUR | PurInvoice | 41271 | 6610/ | 2665/02 | 3.8
[NAME] | Journal | 41274 | 2626/05 |  | 1683.89
[NAME] | AccPIA | 41274 | 2626/05 |  | 442.5
[NAME] | AccPIA | 41274 | 2626/25 |  | 1191.67
[NAME] | AccPIA | 41274 | 2626/05 |  | 9587.58
Spreadsheet: 148414d1333391567-dropdown-for-multiple-cells-invoice-template-example
Sheet: Invoice Template

 |  |  | INVOICE
 |  |  | DATE:
 |  |  | INVOICE #
 |  |  | TERMS:
 |  |  | DUE DATE:
BILL TO:
Item | Description | Quantity | Rate | Amount
X
Y
Z
X
X
X
X
X
X
 |  |  | TOTAL
Spreadsheet: barry_tycholiz__853__SPPC1
Sheet: Sheet2

 |  |  |  |  |  |  | Market Price | WACOG | Delta
 |  |  |  |  |  |  | 2 | 2.208 | -0.2079999999999997
 |  |  |  |  |  |  | 2.25 | 2.3295 | -0.0794999999999999
 |  |  |  |  |  |  | 2.5 | 2.4795 | 0.02050000000000018
 |  |  |  |  |  |  | 2.75 | 2.6145 | 0.1354999999999995
 |  |  |  |  |  |  | 3 | 2.6895 | 0.3104999999999998
 |  |  |  |  |  |  | 3.25 | 2.7645 | 0.4854999999999996
 |  |  |  |  |  |  | 3.5 | 2.8395 | 0.6604999999999999
 |  |  |  |  |  |  | 3.75 | 2.9145 | 0.8354999999999997
 |  |  |  |  |  |  | 4 | 2.9895 | 1.0105
 |  |  |  |  |  |  | 4.25 | 3.0645 | 1.1855
 |  |  |  |  |  |  | 4.5 | 3.1395 | 1.3605
 |  |  |  |  |  |  | 4.75 | 3.2145 | 1.5355
 |  |  |  |  |  |  | 5 | 3.2895 | 1.7105
 |  |  |  |  |  |  | 5.25 | 3.3645 | 1.8855
 |  |  |  |  |  |  | 5.5 | 3.4395 | 2.0605
 |  |  |  |  |  |  | 5.75 | 3.5145 | 2.2355
 |  |  |  |  |  |  | 6 | 3.5895 | 2.4105
 |  |  |  |  |  |  | 6 | 3.59
 |  |  |  |  |  |  | 5.75 | 3.5145
 |  |  |  |  |  |  | 5.5 | 3.4395
 |  |  |  |  |  |  | 5.25 | 3.3645
 |  |  |  |  |  |  | 5 | 3.2895
 |  |  |  |  |  |  | 4.75 | 3.2145
 |  |  |  |  |  |  | 4.5 | 3.1395
 |  |  |  |  |  |  | 4.25 | 3.0645
 |  |  |  |  |  |  | 4 | 2.9895
 |  |  |  |  |  |  | 3.75 | 2.9145
Nov | 100000 | 100000 |  |  |  |  | 3.5 | 2.8395
Dec | 80000 | 100000 |  |  |  |  | 3.25 | 2.7645
Jan | 70000 | 100000 |  |  |  |  | 3 | 2.6895
Feb | 90000 | 100000 |  |  |  |  | 2.75 | 2.6145
Mar | 100000 | 100000 |  |  |  |  | 2.5 | 2.4795
Apr | 70000 | 100000 |  |  |  |  | 2.25 | 2.3295
May | 120000 | 100000 |  |  |  |  | 2 | 2.208
June | 90000 | 100000
July | 150000 | 100000
Aug | 100000 | 100000
Sept | 110000 | 100000
Oct | 80000 | 100000
Nov | 140000 | 100000
Dec | 70000 | 100000
Jan | 90000 | 100000
Feb | 130000 | 100000
Mar | 100000 | 100000
Apr | 80000 | 100000
May | 130000 | 100000
June | 100000 | 100000
July | 80000 | 100000
Aug | 130000 | 100000
Sept | 90000 | 100000
Spreadsheet: 02b09866-5e95-4436-8cc3-b60b5cb0d9ee
Sheet: Active Inserts

Active inserts (see directions on "Current Qs" tab for instructions on how to refresh data)
Date of insert | Insert Date | [NAME]
2012 | 10/28/12 | SS 10/28/12
 | 11/04/12 | SS 11/4/12
 | 11/18/12 | SS 11/18/12
 | 12/02/12 | SS 12/2/12
 | 12/09/12 | SS 12/9/12
2013 | 1/13/13 | RP 1/13/13
 |  | SS 1/13/13
 | 1/20/13 | SS 1/20/13
 | 1/27/13 | (USA WEEKEND) 1/27/13
 |  | RP 1/27/13
 |  | SS 1/27/13
 | 1/6/13 | SS 1/6/13
 | 2/10/13 | RP 2/10/13
 |  | SS 2/10/13
 |  | (PARADE) 2/10/13
 | 2/17/13 | (Wraparound) RP 2/17/13
 | 2/24/13 | SS 2/24/13
 | 2/3/13 | RP 2/3/13
 |  | RP 2/3/13
 |  | SS 2/3/13
 | 3/10/13 | SS 3/10/13
 |  | RP 3/10/13
 | 3/17/13 | SS 3/17/13
 |  | RP 3/17/13
 |  | (CVS) SS 3/17/13
 | 3/24/13 | RP 3/24/13
 |  | SS 3/24/13
 |  | (TARGET) RP 3/24/13
 |  | (LOS ANGELES TIMES A10) 3/24/13
 |  | (DOLLAR GENERAL) RP 3/24/13
 |  | (TARGET) SS 3/24/13
 |  | (DOLLAR GENERAL) RP 3/24/13
 | 3/3/13 | RP 3/3/13
 |  | SS 3/3/13
 |  | (USA WEEKEND) 3/3/13
 |  | P&G 3/3/13
 | 3/31/13 | P&G 3/31/13
 |  | (USA WEEKEND) 3/31/13
 | 4/14/13 | RP 4/14/13
 |  | SS 4/14/13
 | 4/7/13 | SS 4/7/13
 |  | RP 4/7/13
 |  | (CVS) SS 4/7/13
 |  | (TARGET) RP 4/7/13
 | 04/14/13 | SS 04/14/13
 | ch/April 2013) 3/18/13 | (QUE RICA VIDA March/April 2013) 3/18/13
 | DE/USA WEEKEND) 2/17/13 | (PARADE/USA WEEKEND) 2/17/13
 | DE/USA WEEKEND) 2/24/13 | (PARADE/USA WEEKEND) 2/24/13
 | HS/KROGER logo) SS 4/14/13 | (Mfr Q with RALPHS/KROGER logo) SS 4/14/13
#[NAME]! | #[NAME]! | #[NAME]!
Grand Total
Spreadsheet: 130922d1322661009-concatenation-of-text-in-arrays-with-reference-cells-book3
Sheet: Sheet3

Digits | Frutis | Desired Result1 | Or Desired Result2
1 | Apple | Apple,Apple,Orange,Pine | Apple,Orange,Pine
1 | Apple | Apple,Apple,Orange,Pine | Apple,Orange,Pine
3 | Orange | Orange,Peach | Orange,Peach
4 | Pine | Pine,Peach | Pine,Peach
5 | Peach | Peach | Peach
6 | Peach | Peach | Peach
2 | Pine | Pine | Pine
3 | Peach | Orange,Peach | Orange,Peach
4 | Peach | Pine,Peach | Pine,Peach
1 | Orange | Apple,Apple,Orange,Pine | Apple,Orange,Pine
1 | Pine | Apple,Apple,Orange,Pine | Apple,Orange,Pine
Spreadsheet: 118512d1313742395-return-a-value-from-x-and-y-coordinates-rhc-schedule
Sheet: Class Data

YEAR | SUBJECTCODE | CLASSROOM | COLOUR |  | WEEK
9 | SCA | Y4 |  |  | WEEK 1
10 | SCI | B3 |  |  | WEEK 2
11 | SCI | B8 |  |  | WEEK 3
12 | BIO | [NAME] |  |  | WEEK 4
 |  |  |  |  | WEEK 5
 |  |  |  |  | WEEK 6
 |  |  |  |  | WEEK 7
 |  |  |  |  | WEEK 8
 |  |  |  |  | WEEK 9
 |  |  |  |  | WEEK 10
 |  |  |  |  | WEEK 11
 |  |  |  |  | WEEK 12
 |  |  |  |  | WEEK 13
 |  |  |  |  | WEEK 14
Spreadsheet: 109710d1306492070-index-match-and-count-results-match-and-count
Sheet: Sheet2

[NAME] | Jobtitle | Country
[EMAIL] | IT Director | UK
[EMAIL] | IT Analyst | Canada
[EMAIL] | [NAME] | Austria
[EMAIL] | Information Technology | UK
[EMAIL] | Server Administrator | Canada
[EMAIL] | Manager | Austria
[EMAIL] | IT Director | UK
[EMAIL] | IT Analyst | Canada
[EMAIL] | Information Technology | Austria
[EMAIL] | Server Administrator | UK
[EMAIL] | Manager | Canada
[EMAIL] | IT Director | Austria
[EMAIL] | IT Analyst | UK
[EMAIL] | Information Technology | Canada
Spreadsheet: 93106d1292605236-formula-that-returns-the-contents-of-a-cell-based-on-where-a-value-appears-sample-spreadsheet
Sheet: Sheet1

MH 28-132 | 28-128 TO 28-130 | BC-2.09 | INSTALL CIPP | INVESTIGATE 28-132
22-083 | 28-130 | BC-2.08 | INSTALL SOLID COVER | COAT MANHOLE WITH STANDARD CEMENTITIOUS MORTAR | REBUILD BENCH AND INVERT
22-093 | 28-130 TO 28-131 | BC-2.07 | INSTALL CIPP
MH 22-115 | 28-131 | BC-2.06 | INSTALL SOLID COVER | COAT MANHOLE WITH STANDARD CEMENTITIOUS MORTAR | REBUILD BENCH AND INVERT
22-115.1 | 28-131 TO 28-132 | BC-2.05 | REPLACE EXISTING 8" SEWER FROM MH TO MH | COORDINATE WITH ENGINEER IN THE FIELD TO ESTABLISH SLOPE OF THE NEW SEWER
22-115.1 | 28-132 | BC-2.04 | INSTALL SOLID COVER | COAT MANHOLE WITH STANDARD CEMENTITIOUS MORTAR | REBUILD BENCH AND INVERT
22-115.2 | 28-132 TO 28-133 | BC-2.03 | PERFORM POINT REPAIR FROM APPROXIMATELY 148 FEET FROM MH 28-132 TO MH 28-133 PER DETAIL B | AFTER POINT REPAIR IS COMPLETE, INSTALL CIPP
Spreadsheet: 128256d1320875510-working-out-a-tariff-from-a-date-and-time-peak-time_daddy
Sheet: Sheet3

Arrival/Departure date time UTC | Arrival/Departure time UTC |  | 0
2011-01-01 10:50:00 | 10:50:00 |  | 05:30:00 | morning peak | [NAME]. Saturday and Sunday
2011-01-01 12:13:00 | 12:13:00 |  | 09:00:00
2011-01-02 12:40:00 | 12:40:00 |  | 15:00:00 | evening peak
2011-01-02 14:07:00 | 14:07:00 |  | 19:00:00
2011-01-02 14:30:00 | 14:30:00
2011-01-02 15:40:00 | 15:40:00
2011-01-02 16:01:00 | 16:01:00
2011-01-02 16:29:00 | 16:29:00
2011-01-02 16:32:00 | 16:32:00
2011-01-02 20:28:00 | 20:28:00
2011-01-02 20:56:00 | 20:56:00
2011-01-03 12:00:00 | 12:00:00
2011-01-03 12:03:00 | 12:03:00
2011-01-03 13:17:00 | 13:17:00
2011-01-03 13:59:00 | 13:59:00
2011-01-03 15:17:00 | 15:17:00
2011-01-03 19:39:00 | 19:39:00
2011-01-03 20:04:00 | 20:04:00
2011-01-03 20:38:00 | 20:38:00
2011-01-04 10:06:00 | 10:06:00
2011-01-04 10:28:00 | 10:28:00
2011-01-04 10:39:00 | 10:39:00
2011-01-04 13:58:00 | 13:58:00
2011-01-04 14:54:00 | 14:54:00
2011-01-04 14:57:00 | 14:57:00
2011-01-04 15:24:00 | 15:24:00
2011-01-04 16:44:00 | 16:44:00
2011-01-04 20:04:00 | 20:04:00
2011-01-04 20:22:00 | 20:22:00
2011-01-05 09:31:00 | 09:31:00
2011-01-05 11:44:00 | 11:44:00
2011-01-05 14:32:00 | 14:32:00
2011-01-05 16:05:00 | 16:05:00
2011-01-05 16:40:00 | 16:40:00
2011-01-06 07:05:00 | 07:05:00
2011-01-06 09:48:00 | 09:48:00
2011-01-06 11:13:00 | 11:13:00
2011-01-06 11:33:00 | 11:33:00
2011-01-06 14:52:00 | 14:52:00
2011-01-06 14:58:00 | 14:58:00
2011-01-06 15:33:00 | 15:33:00
Spreadsheet: 830823d1685138872-how-to-use-xlookup-with-a-max-date-criteria-punksters626
Sheet: Sheet1

[NAME] | Value | Value Date |  | Result | [NAME] | Value | Value Date
21185 | -1.27 | 2020-12-12 00:00:00 |  |  | 21185 | -1.27 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-10-21 00:00:00 |  |  | 21219 | -1.1 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-09-30 00:00:00 |  |  | 24011 | -0.95 | 2020-11-10 00:00:00
21219 | -1.1 | 2020-12-12 00:00:00 |  |  | 24015 | -0.45 | 2020-04-04 00:00:00
21219 | -0.4 | 2020-08-29 00:00:00 |  |  | 24031 | 0.111 | 2020-09-30 00:00:00
21219 | -1.29 | 2020-04-11 00:00:00
21219 | 0 | 2020-03-05 00:00:00
24011 | -0.95 | 2020-11-10 00:00:00
24011 | 0 | 2020-09-30 00:00:00
24011 | -0.52 | 2020-02-20 00:00:00
24015 | -0.43 | 2020-02-20 00:00:00
24015 | -0.45 | 2020-04-04 00:00:00
24031 | -0.38 | 2020-03-28 00:00:00
24031 | 0.111 | 2020-09-30 00:00:00
24031 | -0.71 | 2020-05-18 00:00:00
21182
21216
24014
24015
24031
Spreadsheet: 779480d1651807122-count-dynamic-array-based-on-date-to-return-dynamic-array-spill-range-count-dynamic-array-based-on-date-range-as-in-quarters
Sheet: Sheet1

Type | Date |  | Where it'll land |  | # of quarters |  | 10
A | 2023-12-18 00:00:00 |  | 2023-12-31 00:00:00
B | 2022-02-13 00:00:00 |  |  |  | Type |  | A | C
C | 2024-05-09 00:00:00 |  | 2024-06-30 00:00:00 |  |  |  |  |  | Dynamic Array formula resulting in Spill Range
D | 2024-05-03 00:00:00 |  | 2024-06-30 00:00:00
A | 2023-07-15 00:00:00 |  | 2023-09-30 00:00:00
B | 2022-09-05 00:00:00 |  | 2022-09-30 00:00:00 |  | 2022-02-01 00:00:00 |  | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00 | 2024-09-30 00:00:00
C | 2022-12-05 00:00:00 |  | 2022-12-31 00:00:00 |  |  |  | 2 | 1 | 1 | 1 | 4 | 1 | 0 | 2 | 3
D | 2022-09-01 00:00:00 |  | 2022-09-30 00:00:00 |  |  | 0 | 2 | 1 | 1 | 1 | 4 | 1 | 0 | 2 | 3
A | 2024-09-16 00:00:00 |  | 2024-09-30 00:00:00
B | 2024-09-17 00:00:00 |  | 2024-09-30 00:00:00
C | 2023-09-08 00:00:00 |  | 2023-09-30 00:00:00
D | 2023-02-03 00:00:00 |  | 2023-03-31 00:00:00 |  |  |  |  | Desired result to be dynamic array formula to have it Spill based on G7#
A | 2023-05-02 00:00:00 |  | 2023-06-30 00:00:00 |  |  |  |  | also, instead of #[NAME] if there's no value, to show as 0
B | 2023-09-09 00:00:00 |  | 2023-09-30 00:00:00
C | 2024-08-04 00:00:00 |  | 2024-09-30 00:00:00 |  | Current Not Working Formula
D | 2023-07-15 00:00:00 |  | 2023-09-30 00:00:00
 |  |  |  |  |  | =LET(qtrRange, G7#,
 |  |  |  |  |  | beginQuarter, EOMONTH(INDEX(qtrRange, SEQUENCE(1,COLUMNS(qtrRange))),-3)+1,
 |  |  |  |  |  | endQuarter,EOMONTH(INDEX(qtrRange, SEQUENCE(1,COLUMNS(qtrRange))),0),
 |  |  |  |  |  | COUNTA(FILTER(tblDummy[Type],
 |  |  |  |  |  | (ISNUMBER(MATCH(tblDummy[Type],$H$3:$I$3,0)))*
 |  |  |  |  |  | (tblDummy[Date]>=beginQuarter)*
 |  |  |  |  |  | (tblDummy[Date]<=endQuarter)
 |  |  |  |  |  | ))
 |  |  |  |  |  | )
Spreadsheet: 815996d1675301160-allocating-the-most-repeated-text-and-sorting-it-in-a-specific-cell-example-1-
Sheet: Tabelle1

What | Missed points |  |  |  |  |  | Check In | Check Out | Rooming
Check In | a | b | c | d
Check In | b | c | d | f |  |  | d | be | ad
Rooming | ab | ac | ad | ae |  |  | b | bc | af
Check Out | ba | bc | bb | be
Rooming | ac | ad | ae | af
Check Out | bc | bb | be | bf
Check Out | bb | be | bf | bg
Check In | c | d | f | g
Rooming | ad | ae | af | ag
Rooming | ae | af | ag | ah
Spreadsheet: 866141d1713093323-vlookup-and-indirect-and-match-formula-animal-sample
Sheet: 2023

2023-12-31 00:00:00
 |  | CAT | DOG | PARROT | COW | DONKEY | RABBIT
Revenue
+ Sales & Services Revenue
+ Other Revenue
- Cost of Revenue
+ Cost of Goods & Services
+ Depreciation & Amortization
+ Research & Development
Gross Profit
+ Other Operating Income
- Operating Expenses
+ Selling, General & Admin
+ Selling & Marketing
+ General & Administrative
+ Research & Development
+ Other Operating Expense
Operating Income (Loss)
- Non-Operating (Income) Loss
+ Interest Expense, Net
+ Interest Expense
- Interest Income
+ Foreign Exch (Gain) Loss
+ Other Non-Op (Income) Loss
Pretax Income (Loss), Adjusted
- Abnormal Losses (Gains)
+ Merger/Acquisition Expense
+ Disposal of Assets
+ Asset Write-Down
+ Restructuring
+ Other Abnormal Items
Pretax Income (Loss), GAAP
- Income Tax Expense (Benefit)
+ Current Income Tax
+ Deferred Income Tax
Income (Loss) from Cont Ops
- Net Extraordinary Losses (Gains)
+ Discontinued Operations
+ XO & Accounting Changes
Income (Loss) Incl. MI
- Minority Interest
Net Income, GAAP
- Preferred Dividends
- Other Adjustments
Net Income Avail to Common, GAAP
Net Abnormal Losses (Gains)
Net Extraordinary Losses (Gains)
Basic Weighted Avg Shares
Basic EPS, GAAP
Basic EPS from Cont Ops, GAAP
Basic EPS from Cont Ops, Adjusted
Diluted Weighted Avg Shares
Diluted EPS, GAAP
Diluted EPS from Cont Ops, GAAP
Diluted EPS from Cont Ops, Adjusted
Reference Items
Accounting Standard
EBITDA
EBITDA Margin (T12M)
EBITA
EBIT
Gross Margin
Operating Margin
Profit Margin
Sales per Employee
Dividends per Share
Total Cash Common Dividends
Depreciation Expense
Rental Expense
Spreadsheet: 819735d1677672969-list-of-names-count-names-etaf
Sheet: Sheet1

[NAME]
fred
jill
[NAME]
[NAME]
fred
jill
[NAME]
[NAME]
fred
jill
[NAME]
[NAME]
fred
jill
[NAME]
[NAME]
fred
jill
[NAME]
[NAME]
fred
jill
[NAME]
Spreadsheet: 62285d1263254299-excel-2007-insert-list-based-on-drop-down-choice-713605-insert-list-based-on-drop-down-choice
Sheet: Data

Used in Drop [NAME] (b9)
Adjustment
Blend
Cancellation
Extension
Other
AdjustmentList
Adjustment | 1) Fill out all information
Adjustment | 2) Get you manager's approval
Adjustment | 3) Submit to [NAME] for approval
Adjustment | 4) Forward all aprovals to SF9_FSVQuoteFWD
Adjustment
Adjustment
Adjustment
Adjustment
Blend | 1) Fill out all information
Blend | 2) Get you manager's approval
Blend | 3) Submit to [NAME] for approval
Blend | 4) Forward all aprovals to SF9_FSVQuoteFWD
Blend | 5) Wait on us….
Blend | 6) Buy us lunch
Blend
Blend
Cancellation | 1) Fill out all information
Cancellation | 2) Get you manager's approval
Cancellation | 3) Submit to [NAME] for approval
Cancellation | 4) Forward all aprovals to SF9_FSVQuoteFWD
Cancellation | 5) Wait on us….
Cancellation | 6) Buy us Breakfast
Cancellation
Cancellation
Extension | 1) Fill out all information
Extension | 2) Get you manager's approval
Extension | 3) Submit to [NAME] for approval
Extension | 4) Forward all aprovals to SF9_FSVQuoteFWD
Extension | 5) Buy everybody Dinner
Extension
Extension
Extension
Spreadsheet: 844440d1696237838-help-with-date-formulas-please-test1
Sheet: Sheet1

A | B | C | DATE | DATE B | DATE C | TARGET DATE | WITHIN [NAME]? | DAYS TAKEN
 |  |  | 2023-09-23 00:00:00
 |  |  | 2023-09-24 00:00:00
 |  |  | 2023-10-23 00:00:00
 |  |  | 2023-10-24 00:00:00
 |  |  | 2023-10-25 00:00:00
 |  |  | 2023-10-01 00:00:00
Spreadsheet: 764713d1642917707-convert-3-digit-straight-lotto-number-to-3-digit-boxed-lotto-number-3-digits-straights-convert-to-boxed
Sheet: boxed

seq_no | box_1 | box_2 | box_3 | boxed
0 | 0 | 0 | 0 | 0
1 | 0 | 0 | 1 | 1
2 | 0 | 0 | 2 | 2
3 | 0 | 0 | 3 | 3
4 | 0 | 0 | 4 | 4
5 | 0 | 0 | 5 | 5
6 | 0 | 0 | 6 | 6
7 | 0 | 0 | 7 | 7
8 | 0 | 0 | 8 | 8
9 | 0 | 0 | 9 | 9
11 | 0 | 1 | 1 | 11
12 | 0 | 1 | 2 | 12
13 | 0 | 1 | 3 | 13
14 | 0 | 1 | 4 | 14
15 | 0 | 1 | 5 | 15
16 | 0 | 1 | 6 | 16
17 | 0 | 1 | 7 | 17
… | … | … | … | …
… | … | … | … | …
888 | 8 | 8 | 8 | 888
889 | 8 | 8 | 9 | 889
899 | 8 | 9 | 9 | 899
999 | 9 | 9 | 9 | 999
Spreadsheet: 252fe613-6fca-42df-ace5-513e3e867c1b
Sheet: Sheet1

Table 2--Soybean meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  | Ending
Oct. 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 |  |  |  | 1,000 short tons
2010/11 | 301.554 | 39251 | 178.811 | 39731.365 |  | 30277.677 | 9103.688 | 39381.365 | 350
2011/121 | 350 | 40500 | 200 | 41050 |  | 31450 | 9300 | 40750 | 300
2012/132 | 300 | 38335 | 165 | 38800 |  | 30400 | 8100 | 38500 | 300
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2012-07-13 07:08:29.210000
Spreadsheet: 714227d1611148089-hlookup-with-nested-match-function-hlookupfile
Sheet: Interactions

Column1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Xerox | 2 |  | 12 | 1 | 2
Vitol |  | 9 |  | 1
Toyota | 4 |  | 4 | 1
Sunaya | 5 |  |  | 1 | 2
Shell | 6 | 8 |  | 1
Rexall | 3 | 6 | 5 | 2 | 5
[NAME] | 1 |  |  | 2 | 1
PetroCanada |  | 1 | 6 |  | 6
Nortel | 5 |  | 7
Microsoft | 7 | 3 | 8 | 6 | 7
McDonalds |  |  | 2 | 6 | 8
IBM | 1 | 8 | 3
Hutchison | 4 | 7 | 5 |  | 1
Honda |  | 5 | 13 | 4
GM | 6 | 1 |  |  | 2
Enron | 7 | 7 | 5 | 2 | 2
Corel | 8 | 6 | 7
China Railway | 11 |  |  | 12
Chevron |  | 4 | 8 |  | 1
Canon Corp |  |  | 8 | 3 | 1
Belkin | 12 |  | 9 |  | 1
Apple | 6 |  |  | 11 | 1
Spreadsheet: 235981d1368651822-infomation-extraction-help-lee
Sheet: Sheet1

funclothing-504-black-red
funclothing-504-black-red-L
funclothing-504-black-red-M
funclothing-504-black-red-S
funclothing-570-blue
funclothing-570-blue-L
funclothing-570-blue-M
funclothing-570-blue-S
funclothing-570-Pink
funclothing-570-Pink-L
funclothing-570-Pink-M
[NAME]
funclothing-570-Red-Black
funclothing-570-Red-Black-1x
funclothing-570-Red-Black-2x
funclothing-570-Red-Black-3x
Spreadsheet: 120867d1315593385-summarizing-data-from-multiple-sheets-into-one-sheet-championship-score-sheet
Sheet: Points Table

Group | Position | Score |  | Points Table
1 | 3 | 15 |  | Group 1 | Score
2 | 1 | 25 |  | 1 | 35
3 | 2 | 10 |  | 2 | 25
 |  |  |  | 3 | 15
New Table
Group | Position | Score |  | Group 2 | Score
1 | 1 | 35 |  | 1 | 25
2 | 1 | 25 |  | 2 | 15
3 | 1 | 15 |  | 3 | 10
 |  |  |  | Group 3 | Score
 |  |  |  | 1 | 15
 |  |  |  | 2 | 10
 |  |  |  | 3 | 5