tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62ef403f-9153-47ac-b9a0-09806c35ebce
Sheet: Sheet1

MATH 255A
 | Date | Score | Date | Score | Date | Score | Date | Score
Homework O
Chapter 1 Pre-Test
[NAME]
[NAME]
[NAME]
[NAME]. 2-4
Chapter 1 Test
Chapter 2 Pre-Test
[NAME]
Quiz 2.4-2.5
Chapter 3 Pre-Test
[NAME]
Quiz 3.4-3.6
[NAME]. 5
[NAME] Test
[NAME] (Ch. 1-3)
MATH 255B
 | Date | Score | Date | Score | Date | Score | Date | Score
Chapter 4 Pre-Test
[NAME]
[NAME]
Chapter 5 Pre-Test
[NAME]
[NAME]. 6
[NAME] Test
Chapter 6 Pre-Test
[NAME]
[NAME]
[NAME]
[NAME]. 7
Chapter 6 Test Part 1
Chapter 6 Test Part 2
Mod. 2 (Ch. 1-6) Part 1
Mod. 2 (Ch. 1-6) Part 2
MATH 255C
 | Date | Score | Date | Score | Date | Score | Date | Score
[NAME]. 8-10
Study Skills Test
Chapter 8 Pre-Test
[NAME]
[NAME]
Chapter 8 Test
[NAME] (Ch. 1-6,8) Part 1
[NAME] (Ch. 1-6,8) Part 2
MATH 255D
 | Date | Score | Date | Score | Date | Score | Date | Score
Chapter 10 Pre-Test
Quiz 10.1-10.3
[NAME]
Chapter 10 Test
Chapter 11 Pre-Test
[NAME]
Quiz 11.4-11.5
Chapter 11 Test
[NAME] Part 1
[NAME] Part 2
Spreadsheet: 753093d1635247187-translating-dynamic-array-formula-for-ranking-into-power-query-m-code-conditional_rank_power_query
Sheet: Rank

Batch | Step Text | Control recipe | Rank pasted values | Rank with dynamic array formula
14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Printing reference sample labels | 100000000000395235 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14384960 | Taking of reference samples | 100000000000395237 | 1
14733213 | Logbook | 100000000000401798 | 1
14733213 | Logbook | 100000000000401798 | 1
14733213 | Logbook | 100000000000403402 | 2
14733213 | Logbook | 100000000000403402 | 2
14733213 | Within requirements | 100000000000403570 | 1
14384960 | Printing reference sample labels | 100000000000400354 | 2
14384960 | Printing reference sample labels | 100000000000400354 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Taking of reference samples | 100000000000400938 | 2
14384960 | Number approved | 100000000000400940 | 1
14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3
14733213 | Logbook | 100000000000403756 | 3
14733213 | Within requirements | 100000000000404116 | 2
14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4
14733213 | Logbook | 100000000000404597 | 4
14733213 | Within requirements | 100000000000404979 | 3
Spreadsheet: 774358d1648422376-how-to-validate-a-sum-of-data-addingcompareef
Sheet: Sheet2

Start | End | Duration
04:50:00 | 13:36:00
05:15:00 | 15:17:00
05:17:00 | 08:37:00
05:19:00 | 12:49:00
05:30:00 | 15:36:00
05:30:00 | 09:02:00
05:37:00 | 09:27:00
05:40:00 | 08:56:00
05:46:00 | 08:02:00
05:47:00 | 11:34:00
05:50:00 | 08:59:00
05:52:00 | 09:17:00
05:52:00 | 09:56:00
05:53:00 | 08:02:00
05:57:00 | 10:00:00
06:00:00 | 08:02:00
06:02:00 | 09:39:00
06:03:00 | 09:33:00
06:04:00 | 16:04:00
06:05:00 | 16:04:00
06:05:00 | 08:02:00
06:12:00 | 10:15:00
06:12:00 | 10:16:00
06:15:00 | 10:32:00
06:17:00 | 10:12:00
06:25:00 | 10:26:00
06:28:00 | 07:43:00
06:32:00 | 14:36:00
06:33:00 | 11:12:00
06:35:00 | 14:15:00
06:46:00 | 14:38:00
06:50:00 | 14:41:00
06:50:00 | 12:26:00
06:50:00 | 10:54:00
06:52:00 | 08:05:00
06:55:00 | 16:22:00
07:00:00 | 11:45:00
07:02:00 | 12:09:00
07:03:00 | 15:03:00
07:12:00 | 12:06:00
07:17:00 | 14:42:00
07:20:00 | 15:51:00
07:23:00 | 17:43:00
07:29:00 | 12:00:00
07:30:00 | 11:32:00
07:30:00 | 11:06:00
10:25:00 | 16:28:00
10:35:00 | 17:13:00
10:57:00 | 17:12:00
11:20:00 | 17:30:00
11:38:00 | 12:42:00
11:47:00 | 18:05:00
11:52:00 | 19:55:00
12:05:00 | 17:42:00
12:16:00 | 20:45:00
13:07:00 | 21:41:00
13:25:00 | 18:28:00
13:30:00 | 18:17:00
13:30:00 | 17:48:00
13:32:00 | 20:13:00
13:45:00 | 22:31:00
13:50:00 | 18:06:00
13:54:00 | 19:30:00
14:00:00 | 21:21:00
14:07:00 | 22:37:00
14:08:00 | 22:48:00
14:10:00 | 18:10:00
14:12:00 | 18:19:00
14:22:00 | 18:52:00
14:25:00 | 21:54:00
14:30:00 | 21:43:00
14:31:00 | 17:56:00
14:32:00 | 1900-01-01 01:03:00
14:32:00 | 18:02:00
14:33:00 | 1900-01-01 00:58:00
14:38:00 | 23:41:00
14:42:00 | 18:47:00
14:42:00 | 1900-01-01 00:25:00
14:42:00 | 19:14:00
14:42:00 | 19:02:00
14:42:00 | 19:13:00
14:42:00 | 22:30:00
14:45:00 | 23:46:00
14:45:00 | 18:59:00
14:45:00 | 18:58:00
14:46:00 | 22:30:00
14:48:00 | 18:47:00
14:49:00 | 19:03:00
14:52:00 | 18:01:00
14:55:00 | 19:32:00
14:55:00 | 20:55:00
14:59:00 | 19:14:00
15:00:00 | 1900-01-01 00:52:00
15:00:00 | 19:00:00
15:01:00 | 19:13:00
15:10:00 | 19:14:00
15:14:00 | 1900-01-01 00:20:00
15:22:00 | 1900-01-01 00:05:00
15:32:00 | 16:53:00
15:35:00 | 23:59:00
17:24:00 | 1900-01-01 01:11:00
17:42:00 | 1900-01-01 01:20:00
Spreadsheet: 023bbae0-7ca4-4979-bdb9-f90c1d94f9ad
Sheet: Sheet1

Title | Speaker | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Coverage | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Publisher | Country of Publication | Language | Format | Availability | Rights | System Entry Date
Developing Creativity and Innovation in Engineering and Science | Professor [NAME] | 2007-12-03T05:00:00Z | 987326 |  |  | Other: Developing Creativity and Innovation in Engineering, Science, and Medicine | Other | Multimedia Presentation |  |  |  |  |  |  |  | United States | English |  |  |  | 2010-12-21T05:00:00Z
Spreadsheet: 820884d1678321662-last-5-home-results-for-each-home-team-in-soccer-data-last-5
Sheet: Last 5

HomeTeam (HT) | Away Team | Date | HT result |  |  | Home Team | Last 5 Home Results
Leeds | Chelsea | 2023-01-01 00:00:00 | D |  | 1ST FORMULA | Chelsea
Liverpool | Man Utd | 2023-01-01 00:00:00 | W |  |  | Liverpool
Chelsea | Forest | 2023-01-05 00:00:00 | W
Man City | Liverpool | 2023-01-05 00:00:00 | D
Arsenal | Chelsea | 2023-01-09 00:00:00 | D
Liverpool | Newcastle | 2023-01-09 00:00:00 | W
Liverpool | Man City | 2023-01-15 00:00:00 | D
Chelsea | Everton | 2023-01-15 00:00:00 | D
Leeds | Liverpool | 2023-01-21 00:00:00 | L | 1ST FORMULA WORKS OK ON ROWS 2 TO 19 ONLY
Arsenal | Chelsea | 2023-01-21 00:00:00 | W |  | WHEN I ADD EXTRA ROWS 20 TO 31 THEN IT FAILS
Liverpool | West Ham | 2023-01-26 00:00:00 | L
Chelsea | Newcastle | 2023-01-26 00:00:00 | L | 2ND FORMULA IS PICKING UP RESULTS BUT THEY ARE NOT CORRECT (LAST 5)
Tottenham | Liverpool | 2023-02-01 00:00:00 | L
Chelsea | Arsenal | 2023-02-01 00:00:00 | W
Liverpool | Everton | 2023-02-11 00:00:00 | W
Newcastle | Chelsea | 2023-02-11 00:00:00 | L
Chelsea | [NAME] | 2023-02-20 00:00:00 | D
Fulham | Liverpool | 2023-02-20 00:00:00 | L
Liverpool | Man City | 2023-01-15 00:00:00 | D
Chelsea | Everton | 2023-01-15 00:00:00 | D
Leeds | Liverpool | 2023-01-21 00:00:00 | L
Arsenal | Chelsea | 2023-01-21 00:00:00 | W
Liverpool | West Ham | 2023-01-26 00:00:00 | L
Chelsea | Newcastle | 2023-01-26 00:00:00 | L
Tottenham | Liverpool | 2023-02-01 00:00:00 | L
Chelsea | Arsenal | 2023-02-01 00:00:00 | W
Liverpool | Everton | 2023-02-11 00:00:00 | W
Newcastle | Chelsea | 2023-02-11 00:00:00 | L
Chelsea | [NAME] | 2023-02-20 00:00:00 | D
Fulham | Liverpool | 2023-02-20 00:00:00 | L
Chelsea |  |  | X
Spreadsheet: 275283d1383431877-vlookup-on-multiple-column-data-test
Sheet: After

[NAME] |  |  | D&B # - AIMS (via SFDC) | D&B # | D&B # - SFDC | Name | FORMULA
1234232 |  |  | 124213123 | 123123 | 156192481 | a
243574188 |  |  | 1232321313 | 243574188 | 243574188 | b | b
248175676 |  |  | 2142141 | 12321321 | 248175676 | c | c
248134236 |  |  | 322132 | 23213123 | 248134236 | d | d
42324124 |  |  | 213213 | 2321321 | 12123213 | e
12314521421 |  |  | 12321311 | 243113938 | 123213 | f
123213 |  |  | 113213 | 123213 | 1232131 | g | g
124214 |  |  | 1232124 | 2321 | 1232132 | h
12321 |  |  | 1223213 | 23213 | 252004577 | i
123213 |  |  | 1213213 | 12321 | 200521102 | j
257432823 |  |  | 142321 | 123221 | 257432823 | k
123213 |  |  | 1213213 | 243967259 | 12321312 | l
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -2334 | -2100 |  | -25
2 | -2234 | -2100 |  | -25
3 | -2230 | -2100 |  | -25
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
index
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92208.92
2002-02-03 00:00:00
CBS Volume
 |  |  | 38214
Spreadsheet: 709550d1608385024-2-columns-of-formula-data-to-1-with-no-blanks-sample-workbook
Sheet: Engine

This is my "engine" that consolidates various data
 |  |  |  |  |  |  |  |  |  |  | This is currently what I have and am trying to eliminate the blank cells in my final list
Month | 2
*this is to demonstrate varied inputs that I have
Spreadsheet: 144358d1330952280-how-to-count-a-cell-with-a-number-or-letter-as-1-or-an-empty-cell-as-0-counta-and-countif-with-formulae-in-cells
Sheet: Sheet1

Test Column |  | [NAME] |  |  | [NAME] | Returns |  | Minus | or | Minus |  | Result
abc1 |  | 1 |  |  |  |  |  | COUNTBLANK(A2:A30) |  | COUNTIF(A2:A30,"")
abc2 |  | 1 |  |  | COUNTA(A2:A30) | 29 | - | 7 |  | 7 |  | 22
abc3 |  | 1
abc4 |  | 1 |  |  | COUNTIF(A2:A30,"<>""") | 29 | - | 7 |  | 7 |  | 22
[NAME] |  | 1
abc6 |  | 1 |  |  | Refering to whole Column |  |  | COUNTBLANK(A:A) |  | COUNTIF(A:A,"")
[NAME] |  | 1 |  |  | [NAME]:A) | 30 | - | 65513 |  | 65513 |  | -65483
abc8 |  | 1
abc9 |  | 1 |  |  | COUNTIF(A:A,"<>""") | 65536 | - | 65513 |  | 65513 |  | 23
abc10 |  | 1
abc11 |  | 1
abc12 |  | 1
1 |  | 1
2 |  | 1
3 |  | 1
4 |  | 1
5 |  | 1
1 |  | 1
2 |  | 1
3 |  | 1
4 |  | 1
5 |  | 1
 |  |  | Result |  | Dynamic Formulae
 |  |  | 22 |  | 22
Spreadsheet: d39fb993-96ce-40e1-bc0a-f65da1822356
Sheet: Sheet1

Symbol | HPV1 | HPV5 | HPV8 | HPV9 | HPV3 | HPV18 | HPV33 | HPV16 | HPV39 | [NAME] | HPV11 | HPV32
ACTN1 | 1.39 | 0.74 | 2.09 | 8.57 | 4.31 | 1.04 | 0.8 | 2.03 | 0.84 | 0.56 | 0.65 | 0.5
BCL2L1 | 25.68 | 29.83 | 25.52 | 50.97 | 9.3 | 6.15 | 5.38 | 3.19 | 3.23 | 1.58 | 7.66 | 1.66
BCL2L13 | 9.73 | 67.06 | 31.86 | 33.57 | 7.2 | 5.75 | 22.14 | 3.69 | 7.85 | 8.83 | 13.54 | 2.34
CASP8 | 50.62 | 27.29 | 11.46 | 14.6 | 53.49 | 21.64 | 23.76 | 11.38 | 16.02 | 11.69 | 6.99 | 3.37
HSPA5 | 13.25 | 15.56 | 11.65 | 19.41 | 4.67 | 4.79 | 5.42 | 3.54 | 2.22 | 1.4 | 1.58 | 1.49
HSPB1 | 14.1 | 7.06 | 8.98 | 27.85 | 15.75 | 7.16 | 3.44 | 3.71 | 2.9 | 2.6 | 2.48 | 1.85
[NAME] | 2.26 | 15.49 | 8.72 | 9.39 | 2.41 | 0.8 | 6.2 | 1.11 | 1.14 | 1.03 | 1.51 | 0.68
NR4A1 | 25.71 | 44.77 | 32 | 62.6 | 6 | 10.29 | 16.76 | 9.37 | 7.8 | 6.92 | 6.87 | 4.37
SKP2 | 2.31 | 2.76 | 4.27 | 3.7 | 1.08 | 2.43 | 2.23 | 1.15 | 1.15 | 0.7 | 0.69 | 0.75
TAX1BP1 | 138.42 | 18.36 | 48.03 | 19.19 | 226.78 | 71.3 | 46.04 | 21.17 | 18.67 | 22.17 | 23.23 | 20.8
TP53 | 14.23 | 26.43 | 17.11 | 31.42 | 23.81 | 11.38 | 12.83 | 5.68 | 6.61 | 4.71 | 7.89 | 6.58
UACA | 3.54 | 6.59 | 5.31 | 10.98 | 1.79 | 2.25 | 3.13 | 1.01 | 2.38 | 0.88 | 0.87 | 0.53
Spreadsheet: 40388d1238693006-transposing-grades-grades-sample
Sheet: Sheet1

Here's what it looks like now
 | 2008-2009 |  |  |  | 2008-08-12 00:00:00 | 2008-08-13 00:00:00 | 2008-08-14 00:00:00 | 2008-08-15 00:00:00 | 2008-08-15 00:00:00 | 2008-08-18 00:00:00 | 2008-08-19 00:00:00 | 2008-08-20 00:00:00 | 2008-08-21 00:00:00 | 2008-08-22 00:00:00 | 2008-08-25 00:00:00 | 2008-08-26 00:00:00 | 2008-08-27 00:00:00 | 2008-08-27 00:00:00 | 2008-08-28 00:00:00 | 2008-08-28 00:00:00 | 2008-08-29 00:00:00 | 2008-09-02 00:00:00 | 2008-09-03 00:00:00 | 2008-09-03 00:00:00 | 2008-09-04 00:00:00 | 2008-09-05 00:00:00 | 2008-09-08 00:00:00 | 2008-09-10 00:00:00 | 2008-09-12 00:00:00 | 2008-09-15 00:00:00 | 2008-09-16 00:00:00 | 2008-09-17 00:00:00 | 2008-09-18 00:00:00 | 2008-09-19 00:00:00 | 2008-09-22 00:00:00 | 2008-09-23 00:00:00 | 2008-09-24 00:00:00 | 2008-09-25 00:00:00 | 2008-09-26 00:00:00 | 2008-10-01 00:00:00 | 2008-10-02 00:00:00 | 2008-10-03 00:00:00 | 2008-10-06 00:00:00 | 2008-10-07 00:00:00 | 2008-10-08 00:00:00
 | Grades | AVG (with lowest grade dropped) | FINAL AVG | Grade | Assignment 1 | Assignment 2 | Assignment 3 | Assignment 4 | Assignment 5 | Assignment 6 | Assignment 7 | Assignment 8 | Assignment 9 | Assignment 10 | Assignment 11 | Assignment 12 | Assignment 13 | Assignment 14 | Assignment 15 | Assignment 16 | Assignment 17 | Assignment 18 | Assignment 19 | Assignment 20 | Assignment 21 | Assignment 22 | Assignment 23 | Assignment 24 | Assignment 25 | Assignment 26 | Assignment 27 | Assignment 28 | Assignment 29 | Assignment 30 | Assignment 31 | Assignment 32 | Assignment 33 | Assignment 34 | Assignment 35 | Assignment 36 | Assignment 37 | Assignment 38 | Assignment 39 | Assignment 40 | 9 Weeks Test
1 | Student A | 86.33333333333333 | 87.63333333333333 | B | 100 | 100 | 100 | 100 | - | 100 | 100 | 100 | 100 | 100 | 70 | 100 | 100 | 38 | 90 | 39 | 83 | 80 | 100 | 70 | 80 | 70 | 100 | 80 | 95 | 70 | 90 | 70 | 70 | 95 | 70 | 70 | 89 | 92 | 90 | 87 | 75 | 100 | 80 | 67 | 95
2 | Student B | 80.55 | 80.6175 | C | 67 | 83 | 72 | 84 | 97 | 84 | 73 | 73 | 92 | 76 | 71 | 73 | 100 | 70 | 83 | 72 | 69 | 81 | 74 | 72 | 89 | 77 | 95 | 67 | 75 | 67 | 86 | 87 | 85 | 95 | 71 | 90 | 95 | 83 | 78 | 85 | 79 | 69 | 74 | 95 | 81
3 | Student C | 82.875 | 85.14375 | B | 93 | 73 | 73 | 81 | 76 | 88 | 73 | 98 | 99 | 73 | 85 | 78 | 75 | 98 | 80 | 71 | 78 | 98 | 84 | 73 | 79 | 76 | 81 | 82 | 88 | 95 | 86 | 75 | 84 | 81 | 100 | 66 | 80 | 66 | 81 | 80 | 89 | 80 | 93 | 74 | 98
Spreadsheet: 776471d1649753468-formula-to-retrieve-all-values-that-fall-under-row-1-header-name-example_michlam
Sheet: Sheet1

Q1r1 | Q1r2 | Q2r1 | X | Q5
1 | 1 | 1 | 1 | 1
2 | 2 | 2 | 2 | 2
3 | 3 | 3 | 3 | 3
Spreadsheet: 744041d1628875857-running-balance-with-multiple-bank-account-transactions-in-one-table-accountingtemplatebackup
Sheet: Dashboard

Menu |  | [NAME] |  | Transactions |  | Chart of Accounts |  | Reports |  | Print Area | 'Print Area'!A1 | Dashboard 2021
 |  |  |  |  |  |  |  |  |  |  |  |  | Year 2021
 |  |  | To Do List |  |  |  |  |  |  | Monthly Net Profit
 |  |  | # | Task |  |  |  |  |  | Month | Sales | Expenses | Net Profit
 |  |  | 1 | Import Bank Statements |  |  |  |  |  | January
 |  |  | 2 | [NAME] by Category and Account |  |  |  |  |  | Feburary
 |  |  | 3 | Verify Account Balances |  |  |  |  |  | March
 |  |  | 4 |  |  |  |  |  |  | April
 |  |  | 5 |  |  |  |  |  |  | May
 |  |  | 6 |  |  |  |  |  |  | June
 |  |  | 7 |  |  |  |  |  |  | July
 |  |  | 8 |  |  |  |  |  |  | August
 |  |  | 9 |  |  |  |  |  |  | September
 |  |  | 10 |  |  |  |  |  |  | October
 |  |  | 11 |  |  |  |  |  |  | November
 |  |  | 12 |  |  |  |  |  |  | December
Spreadsheet: 770440d1646067618-need-help-solving-this-sumif-scenario-updated_sampledata_excelhelp
Sheet: Sheet3

Type | TK1 | TK2 | TK3 | TK4 | RESULT WANTED |  |  | TK1OUT | 0
NB | OUT | COMP | PEND | COMP |  |  |  | TK2OUT | 0
DP | PEND | PEND | COMP | OUT |  |  |  | TK3EOUT | 0
RG | COMP | COMP | COMP | COMP |  |  |  | TK4OUT | 0
AP | OUT | OUT | OUT | OUT |  |  |  | TK1PEND | 10
ZZ | PEND | COMP | COMP | OUT |  |  |  | TK2PEND | 15
CP | COMP | OUT | COMP | PEND |  |  |  | TK3PEND | 20
 |  |  |  |  |  |  |  | [NAME] | 5
 |  |  |  |  |  |  |  | TK1COMP | 20
 |  |  |  |  |  |  |  | [NAME] | 30
 |  |  |  |  |  |  |  | TK3COMP | 40
 |  |  |  |  |  |  |  | TK4COMP | 10
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: Z6NY

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/25/2001 10:02 am | 5000 | 4.39
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/25/2001 12:31 pm | 125 | 4.4075
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/29/2001 02:31 pm | 5000 | 4.1775
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/29/2001 02:36 pm | 4919 | 4.165
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/29/2001 03:00 pm | 5000 | 4.175
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/29/2001 12:29 pm | 2500 | 4.29
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/31/2001 07:47 am | 5000 | 4.225
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/31/2001 08:17 am | 14 | 4.23
US Gas Phy       [NAME] NY           Jun01           USD/MM | 05/31/2001 08:23 am | 5000 | 4.21
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 116649d1311966565-help-with-rotational-formulas-color-formatting-player-rotation
Sheet: Sheet1

 | Player | Default Band | Nickname |  | Squad | Player | Index | Starter
 |  |  |  |  | 1 | [NAME] | 1 | [NAME]
 |  |  |  |  | 1 | Betty | 2
 |  |  |  |  | 1 | Charlotte | 3 |  |  |  |  |  |  |  |  |  | EXAMPLE
 |  |  |  |  | 1 | [NAME] | 4 |  |  |  |  |  |  | Period | Squad | Point Guard (1) | Guard (2) | Guard (3) | Forward (4) | Forward (5)
 |  |  |  |  | 1 | [NAME] | 5 |  |  |  |  |  |  | 1 | 1 | [NAME] | Betty | Charlotte | [NAME] | [NAME]
 |  |  |  |  | 2 | Felicity | 6 |  |  |  |  |  |  | 2 | 2 | [NAME] | Heather | Izzi | [NAME] | Felicity
 |  |  |  |  | 2 | [NAME] | 7 |  |  |  |  |  |  | 3 | 1 | Charlotte | [NAME] | [NAME] | [NAME] | Betty
 |  |  |  |  | 2 | Heather | 8 |  |  |  |  |  |  | 4 | 2 | Izzi | [NAME] | Felicity | [NAME] | Heather
 |  |  |  |  | 2 | Izzi | 9 |  |  |  |  |  |  | 5 | 1 | [NAME] | [NAME] | Betty | Charlotte | [NAME]
 |  |  |  |  | 2 | [NAME] | 10 |  |  |  |  |  |  | 6 | 2 | Felicity | [NAME] | Heather | Izzi | [NAME]
 |  |  |  |  |  |  |  | AUTO
 |  |  |  |  | Period | Squad | Point Guard (1) | Guard (2) | Guard (3) | Forward (4) | Forward (5)
 |  |  |  |  | 1 | 1
 |  |  |  |  | 2 | 2
 |  |  |  |  | 3 | 1
 |  |  |  |  | 4 | 2
 |  |  |  |  | 5 | 1
 |  |  |  |  | 6 | 2
 |  |  |  |  |  |  |  | CUSTOM
 |  |  |  |  | Period | Squad | Point Guard (1) | Guard (2) | Guard (3) | Forward (4) | Forward (5)
 |  |  |  |  | 1 | 1
 |  |  |  |  | 2 | 2
 |  |  |  |  | 3 | 1
 |  |  |  |  | 4 | 2
 |  |  |  |  | 5 | 1
 |  |  |  |  | 6 | 2
Spreadsheet: 114794d1310513582-no-display-if-cell-is-blank-sched01
Sheet: Sheet2

Layout # | Tool # | SRF # | Due Date | Completed | [NAME] | Customer | Layout Due Date: | Engineer | Customer | Verified
 |  |  |  |  |  |  |  |  |  | x
RP110551 | w985 | 2011-06-13 00:00:00 | 2011-07-05 00:00:00 | 2011-07-05 00:00:00 | b | r1 | 2011-07-01 00:00:00 | y | r2
RP110552 | w5986 | 2011-06-13 00:00:00 | 2011-07-05 00:00:00 | 2011-07-05 00:00:00 | c | c1 | 2011-07-01 00:00:00 | x | r3
RP110553 | w51086 | 2011-06-20 00:00:00 | 2011-07-06 00:00:00 |  | d |  | 2011-07-05 00:00:00 | w | r4
RP110554 | c6141 | 2011-06-21 00:00:00 | 2011-07-05 00:00:00 | 2011-07-05 00:00:00 | e |  | 2011-07-05 00:00:00
RP110555 | [NAME] | N/A | 2011-07-06 00:00:00 | 2011-07-06 00:00:00 | f |  | 2011-07-06 00:00:00
RP110556 | RA6143 | 2011-06-21 00:00:00 | 2011-07-05 00:00:00 | 2011-07-05 00:00:00 | g |  | 2011-07-08 00:00:00
RP110557 | 6021 | 2011-06-27 00:00:00 | 2011-06-30 00:00:00 | 2011-06-30 00:00:00 | h |  | 2011-06-30 00:00:00
RP110558 | 20 | 2011-06-27 00:00:00 | 2011-06-30 00:00:00 | 2011-07-01 00:00:00 | I |  | 2011-06-30 00:00:00
RP110559 | swA6019 | 2011-06-27 00:00:00 | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 | k |  | 2011-06-30 00:00:00
RP110560 | R5981 | 2011-06-13 00:00:00 | 2011-07-05 00:00:00 |  |  |  | 2011-07-08 00:00:00
RP110561 | R266 | 2011-06-13 00:00:00 | Cancelled | 2011-06-30 00:00:00 |  |  | 2011-07-12 00:00:00
Spreadsheet: 180598d1347649333-problem-with-if-statement-not-meeting-changing-criterion-if-problem
Sheet: Sheet1

 | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GOAL for this month
 | y | y | y |  |  |  |  | n | n | n | n | n | n | n |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  | As you can see, as the number of "n" increase, the message does not go blank
 |  |  |  |  |  |  |  | Thanks
Spreadsheet: 769587d1645609775-dynamic-array-conditional-sequence-dynamic_array_conditional_sequence
Sheet: Tabelle1

 | Static |  |  |  | Dynamic
 | Return | Winning Streak | Performance WS |  | Return | Winning Streak (1) | Winning Streak (2) | Performance WS
 | 0 |  |  |  |  |  |  |  |  | Longest Winning Streak
 | -0.01545626943881018 |  |  |  | -0.01545626943881018 | 0 |  |  |  | Best Performance in Winning Streak
 | 0.03369892736663838 |  |  |  | 0.03369892736663838 | 1
 | -0.001846343942486617 |  |  |  | -0.001846343942486617 | 0
 | 0.005226264815557213 |  |  |  | 0.005226264815557213 | 1
 | 0.008269160080059734 |  |  |  | 0.008269160080059734 | 1
 | 0.002595125286664279 |  |  |  | 0.002595125286664279 | 1
 | -0.00312499219321527 |  |  |  | -0.00312499219321527 | 0
 | -0.002897811345622836 |  |  |  | -0.002897811345622836 | 0
 | 0.003305101321253057 |  |  |  | 0.003305101321253057 | 1
 | 0.003622012071362368 |  |  |  | 0.003622012071362368 | 1
 | -0.001154500013708204 |  |  |  | -0.001154500013708204 | 0
 | 0.02627803870136236 |  |  |  | 0.02627803870136236 | 1
 | -0.006187996630119375 |  |  |  | -0.006187996630119375 | 0
 | -0.004138740521268058 |  |  |  | -0.004138740521268058 | 0
 | -0.00167449307631562 |  |  |  | -0.00167449307631562 | 0
 | 0.005296431101133203 |  |  |  | 0.005296431101133203 | 1
 | 0.01362155466038506 |  |  |  | 0.01362155466038506 | 1
 | -0.00633591555532409 |  |  |  | -0.00633591555532409 | 0
 | 0.0007600600096542287 |  |  |  | 0.0007600600096542287 | 1
Spreadsheet: 820820d1678296078-four-cascading-data-validation-lists-that-can-be-used-on-multiple-rows-cascadedatavalexample
Sheet: Sheet1

Sheet 1 |  |  |  |  |  |  |  | Sheet 2
Name 1 | Name 2 | Name 3 | Location1 | misc1 | misc2 | misc3 |  | Name 1 | Name 2 | Name 3 | Location 1
[NAME] | [NAME] | [NAME] | Amber Place |  |  |  |  | [NAME] | [NAME] | [NAME] | Amber Place
[NAME] | [NAME] | [NAME] | St. Vale |  |  |  |  | [NAME] | [NAME] | [NAME] | St. Vale
[NAME] | [NAME] | [NAME] | The Prime |  |  |  |  | [NAME] | [NAME] | [NAME] | The Prime
[NAME] | [NAME] | [NAME] | [NAME] |  |  |  |  | [NAME] | [NAME] | [NAME] | The Place
*Each color is a separate data validation row based on Sheet 2 data |  |  |  |  |  |  |  | [NAME] | [NAME] | Brand [NAME] | The Thing
 |  |  |  |  |  |  |  | [NAME] | [NAME] | Osric Doe | The Guy
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | The Hospital
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | The Pizza Place
Spreadsheet: 150268d1334359077-update-values-based-on-drop-down-list-dropdownupdatehelp
Sheet: Sheet1

Northeast
 | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00
A | 4 | 5 | 7
B | 3 | 34 | 2
C | 76 | 4 | 3
Southeast
 | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00
A | 6 | 77 | 8
B | 5 | 6 | 7
C | 43 | 56 | 78
Gulfcoast
 | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00
A | 8 | 6 | 7
B | 42 | 11 | 22
C | 5 | 44 | 3
Spreadsheet: 877967d1724912022-if-formula-thealndyn-ifsample-1-365-aligw
Sheet: Sheet1

Start_Date | Date Convert | Week | [NAME] | Start Time | End Time | Not Ready Time | Not Ready Reason
2024-06-30 19:50:29 | 2024-07-01 00:00:00 | 27 |  |  | 2024-07-01 08:09:59
2024-06-30 20:13:48 | 2024-07-01 00:00:00 | 27 |  |  | 2024-07-01 08:28:40