tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 119602d1314613161-excel-rating-system-pp1
Sheet: Sheet1

 |  |  |  |  |  |  | Rule
Total Sales |  | 100000 |  |  | Rating | $ | <-10000 | Large loss
 |  |  |  |  |  | $$ | <0 >-10000 | Small loss
Total costs |  | 50000 |  |  |  | $$$ | 0 | Break even
 |  |  |  |  |  | $$$$ | >0 < 10000 | Small profit
 | Net |  |  |  |  | $$$$$ | >100000 | Large profit
 |  | IF($C$7, H3, G3, IF($C$7, H4, G4, IF($C$7, H5, G5, IF($C$7, H6, G6, IF($C$7, H7, G7)))))
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 13c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 1887925 | - | 231956
Europe | - | 848008 | - | 114461
North America/Asia | - | 1039917 | - | 117495
Index | 3260501 | 8349196 | 1515087 | 2544546
Asia | - | 208275 | - | 50152
Europe | 1487411 | 4043536 | 438494 | 1024584
North America | 1747581 | 3613067 | 1062784 | 1395464
Other | 25509 | 484318 | 13809 | 74346
Other | - | 779898 | - | 343100
Exotic/Total Return Swap | - | 58390 | - | 37569
Swaptions | - | 721508 | - | 305531
TOTAL | 3260501 | 11017019 | 1515087 | 3119602
Spreadsheet: 075338b7-5c7d-4ec1-aff7-f22bcdd1a3bb
Sheet: Sheet1

Index Investment Data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
In Billions of U.S. Dollars and Futures Equivalent Contracts
 | 2009-12-31 00:00:00
U.S. Futures Market1 | Notional Value (Billions US$) |  |  | Futures Equivalent Contracts3 (Thousands)
(Notional Value > 0.5 billion US$)2 | Long | Short | Net L (S) | Long | Short | Net L (S)
Cocoa | 1.3 | -0.4 | 0.9 | 38 | -11 | 27
Coffee | 3.6 | -0.9 | 2.7 | 70 | -18 | 52
Copper | 8.2 | -1.8 | 6.4 | 98 | -22 | 76
Corn | 9.6 | -2.7 | 6.9 | 455 | -131 | 324
Cotton | 4.1 | -1.2 | 2.9 | 108 | -32 | 76
[NAME] | 0.7 | -0.2 | 0.5 | 14 | -4 | 10
Gold | 10.7 | -2.3 | 8.4 | 98 | -21 | 77
Heating Oil | 7.6 | -1.7 | 5.9 | 83 | -19 | 64
[NAME] | 2.9 | -0.7 | 2.2 | 107 | -28 | 79
Live Cattle | 5.4 | -1.4 | 4 | 154 | -40 | 114
Natural Gas | 18.4 | -3.7 | 14.7 | 322 | -61 | 261
RBOB Unleaded Gas | 8.3 | -1.2 | 7.1 | 96 | -14 | 82
Silver | 3.3 | -0.5 | 2.8 | 39 | -6 | 33
Soybean Oil | 2.2 | -0.4 | 1.8 | 89 | -18 | 71
Soybeans | 10.5 | -2.7 | 7.8 | 201 | -51 | 150
Sugar | 9.7 | -2.6 | 7.1 | 329 | -85 | 244
Wheat (CBOT) | 7.9 | -2.7 | 5.2 | 281 | -98 | 183
Wheat (KCBT) | 1 | -0.3 | 0.7 | 38 | -10 | 28
WTI Crude Oil | 50.7 | -14.3 | 36.4 | 626 | -175 | 451
Subtotal (>0.5 billion US$) | 165.8 | -41.7 | 124.1
Subtotal (<0.5 billion US$) | 1.6 | -0.2 | 1.4
Total Notional US Mkts | 167.4 | -41.9 | 125.5
Total Not'l Non-US Mkts | 43.9 | -9.4 | 34.5
Total All Markets | 211.2 | -51.3 | 159.9
1 Each listed U.S. futures market includes index investment for all futures and OTC markets related to or referenced to that U.S. futures market.  For example, the U.S. market listed as “WTI Crude Oil” includes (with the NYMEX’s Light “Sweet” crude oil futures market) investments held in the NYMEX “Crude Oil Financial” market and the ICE Futures-Europe WTI Light Sweet crude oil market, because both of those contracts’ settlement prices are determined by reference to the NYMEX Light “Sweet” crude oil futures contract.
2 US Futures Markets with greater than 0.5 billion US dollars in reported net index investment notional value at the end of at least one of the past four quarters.
3Futures Equivalent Contracts: Futures plus delta-adjusted options, estimating what [NAME] would have been established absent offsets.
(See the Explanatory Notes for more details about this data)
Spreadsheet: 142626d1329934048-sum-only-certain-cells-in-a-column-book1
Sheet: Sheet1

 | ingredient 1 | 0.1
 | ingredient 2 | 0.2
 | ingredient 3 | 0.05
 | ingredient 4 | 0.05
 | ingredient 5 | 0.3
 | ingredient 6 | 0.3
 | Finished good A
 | ingredient 1 | 0.1
 | ingredient 2 | 0.2
 | ingredient 3 | 0.2
 | ingredient 4 | 0.5
 | Finished good B
 | ingredient 1 | 0.3
 | ingredient 2 | 0.3
 | ingredient 3 | 0.4
 | Finished good B
Spreadsheet: 114089d1309949308-a-formula-to-look-up-for-a-certain-value-question-model-template
Sheet: Model template

Models sequence
Body Date | Model | Daily Rate | Total | From |  | To
 |  |  | Qty | Lot | Job # | Lot | Job #
 | Model 1 |  | 41
 | Model 1 |  | 5 | 998 | 12
 | Model 1 | 30 | 8
 | Model 1 |  | 17 | 1
 | Model 1 |  | 5
 | Model 1 | 30 | 25
 | Model 1 |  | 4
 | Model 1 |  | 1
 | H
 | H
 | Model 1 | 30 | 4
 | Model 1 |  | 21
 | Model 1 |  | 5
 | Model 1 | 30 | 25
 | Model 1 |  | 5
 | Model 1 | 30 | 18
 | Model 1 |  | 7
 | Model 1 |  | 5
 | Model 1 | 30 | 5
 | Model 1 |  | 20
 | Model 1 |  | 5
 | Model 1 | 30 | 6
 | Model 1 |  | 19
 | Model 1 |  | 5
 | H
 | H
 | Model 1 | 30 | 2
 | Model 3 |  | 23 | 271 | 1
 | Model 3 |  | 5
 | Model 3 | 30 | 1
 | Model 3 |  | 7
 | Model 2 |  | 17 | 295 | 1
 | Model 2 |  | 5
 | Model 2 | 30 | 25
 | Model 2 |  | 5
 | Model 2 | 30 | 1
 | Model 2 |  | 7
 | Model 4 |  | 4 | 312 | 1
 | Model 4 |  | 8
 | Model 1 |  | 5
 | Model 1 |  | 5
 | Model 1 | 30 | 7
 | Model 1 |  | 12
 | Model 1 |  | 6
 | Model 1 |  | 5
 | H
 | H
 | Model 1 | 30 | 25
 | Model 1 |  | 5
 | Model 1 | 30 | 14
 | Model 2 |  | 11
 | Model 2 |  | 1
 | Model 2 |  | 4
 | Model 2 | 30 | 20
 | Model 3 |  | 5
 | Model 3 |  | 5
 | Model 3 | 17 | 2
 | Model 5 |  | 10 | 29
 | Model 5 |  | 3
 | Model 5 |  | 2
 | Model 5 | 17 | 15
 | Model 5 |  | 2
 | H
 | H
 | H
 | Model 5 | 19 | 6
 | Model 5 |  | 9
 | Model 5 |  | 1
 | Model 6 |  | 1 | 197 | 12
 | Model 6 |  | 2
 | Model 6 | 30 | 9
 | Model 4 |  | 16
 | Model 4 |  | 5
 | Model 4 | 30 | 15
 | Model 1 |  | 10
 | H
 | H
Spreadsheet: 1cc32c65-03aa-4105-8fc8-86c0b40ffdf5
Sheet: Sheet1

Table S1:  ChIP dataset accession numbers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Antibody | Strain | Stage | Platform | modENCODE or GEO accession
H4K20me1-ab9051 | N2 | EE | Nimblegen 2.1 array | modENCODE 2765
H4K20me1-ab9051 | N2 | L3 | Nimblegen 2.1 array | modENCODE 2784
H4K20me1-Diagenode SN-147 | N2 | EE | Nimblegen 2.1 array | modENCODE 3434
H4K20me1-Diagenode SN-147 | N2 | LE | Nimblegen 2.1 array | modENCODE 3196
H4K20me1-Diagenode SN-147 | N2 | L3 | Nimblegen 2.1 array | modENCODE 3538
H4K20me1 Abcam ab9051 lot 104513 | dpy-21 | L3 | Nimblegen 2.1 array | modENCODE 6006
H4K20me3-ab78517 | N2 | L3 | Nimblegen 2.1 array | modENCODE 6005
H4K20me1 Abcam ab9051 lot 104513 | fem-2 | [NAME] | Illumina sequencing | modENCODE 3919
H4K20me1 Abcam ab9051 lot 602259 | N2 | L3 | Illumina sequencing | GEO  GSE39789
H4K20me1 Abcam ab9051 lot 602259 | [NAME] | L3 | Illumina sequencing | GEO  GSE39789
H4K20me1-ab9051 | N2 | MxE | Illumina sequencing | modENCODE 6210
H4K20me1-ab9051 | YPT41 | MxE | Illumina sequencing | modENCODE 6011
Spreadsheet: 761117d1640658402-need-for-a-random-formula-that-generates-a-pre-determined-distribution-random-excelforum
Sheet: Random Distribution

Emp ID | Rating
1
2
3
4
5
6
7
8
9
10
 | SUMMARY
 | Rating | Count | Percent
 | 1
 | 2
 | 3
COPY / PASTE FROM ABOVE WITH NO FORMULAS (THE ABOVE WILL BE DIFFERENT ONCE THIS FILE IS SAVED AND RE-OPENED)
Emp ID | Rating
1 | 3
2 | 3
3 | 1
4 | 1
5 | 1
6 | 2
7 | 1
8 | 1
9 | 3
10 | 2
 | SUMMARY
 | Rating | Count | Percent
 | 1 | 5 | 0.5
 | 2 | 2 | 0.2
 | 3 | 3 | 0.3
 |  | 10 | 1
Spreadsheet: 622883d1556972253-create-one-master-list-from-lists-on-multiple-worksheets-ef1282a_create-one-list-from-multiple-sheets
Sheet: List 4

Obj Category | Object Type | Item No. | Description | Serial No | Own Depot
THYDBST | 101499 | 75115 | List 4 Description 1 |  | Customer 2
THYDBST | 101499 | 75191 | List 4 Description 2 |  | Customer 2
THYDBST | 101499 | 75691 | List 4 Description 3 |  | Customer 2
THYDBST | 101499 | 75692 | List 4 Description 4 |  | Customer 2
THYDCAM | 100217 | 75393 | List 4 Description 5 |  | Customer 2
THYDCAM | 100217 | 75077 | List 4 Description 6 |  | Customer 2
THYDCAM | 100217 | 31307 | List 4 Description 7 |  | Customer 2
THYDCAM | 100217 | 32286 | List 4 Description 8 |  | Customer 2
THYDCAM | 100217 | 32899 | List 4 Description 9 |  | Customer 2
Spreadsheet: 24464d1214887278-simple-problem-sum-of-certain-fields-accross-several-books-online-connect-reg
Sheet: Virgin

 |  |  | [NAME]
No: | Date | Customer Name | Rate Plan | Model | IMEI | Mobile No. | Staff | Total Comm | Staff Comms
MTD |  |  |  |  |  |  |  | 0
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 828626d1683644855-while-using-xlookup-the-first-2-lines-work-than-it-stops-testboox-aligw
Sheet: solarOut

Datum | value (kWh)
2022-01-01 01:00:00 | 0
2022-01-01 02:00:00 | 0
2022-01-01 03:00:00 | 0
2022-01-01 04:00:00 | 0
2022-01-01 05:00:00 | 0
2022-01-01 06:00:00 | 0
2022-01-01 07:00:00 | 0
2022-01-01 08:00:00 | 0
2022-01-01 09:00:00 | 0
2022-01-01 10:00:00 | 0
2022-01-01 11:00:00 | 0
2022-01-01 12:00:00 | 0
2022-01-01 13:00:00 | 0
2022-01-01 14:00:00 | 0
2022-01-01 15:00:00 | 0
2022-01-01 16:00:00 | 0
2022-01-01 17:00:00 | 0
2022-01-01 18:00:00 | 0
2022-01-01 19:00:00 | 0
2022-01-01 20:00:00 | 0
2022-01-01 21:00:00 | 0
2022-01-01 22:00:00 | 0
2022-01-01 23:00:00 | 0
2022-01-02 00:00:00 | 0
2022-01-02 01:00:00 | 0
2022-01-02 02:00:00 | 0
2022-01-02 03:00:00 | 0
2022-01-02 04:00:00 | 0
2022-01-02 05:00:00 | 0
Spreadsheet: 793420d1661454486-multiple-if-statements-to-compare-a-value-to-a-requirement-example-spreadsheet-etaf
Sheet: Sheet1

Requirement |  | Result
Modifier | Value | Value | Formula Output Here
[NAME] | 40 | 50 |  |  |  |  |  |  |  | Look at Column I to determine whether the requirement is [NAME], [NAME], or Pass/Fail Compare Column K to the combined requirement of Column I + Column J If Column I is "[NAME]" and Column K ≥ Column J, output = "Pass". If Column K < Column J, output = "Fail" If Column I is "≤" and Column K ≤ Column J, output = "Pass". If Column K > Column J, output = "Fail" If Column I is "Pass/Fail" and [NAME] is "Pass", output = "Pass". If [NAME] is "Fail", output = "Fail" The OUTPUT from this should be in Column M, which is currently blank in the attached screenshot
Pass/Fail | Pass | Pass
[NAME] | 0.1 | 0.00625
[NAME] | 0.1 | 0.03966666666666666
[NAME] | 290 | 477
[NAME] | 100 | 100
[NAME] | 1 | 2.05
[NAME] | 250 | 491
[NAME] | 1700 | 3390
[NAME] | 130 | 384
[NAME] | 150 | 980
[NAME] | 1 | 0.79
Pass/Fail | Pass | Pass
Pass/Fail | Pass | Pass
[NAME] | 50 | 56
[NAME] | 250 | 384
[NAME] | 2000 | 3390
[NAME] | 390 | 491
[NAME] | 0.9 | 0.79
[NAME] | 40 | 50
[NAME] | 40 | 50
[NAME] | 2000 | 2150
[NAME] | 150 | 358
[NAME] | 350 | 372
[NAME] | 200 | 101
[NAME] | 40 | 50
[NAME] | 25 | 50
Pass/Fail | Pass | Pass
[NAME] | 130 | 384
[NAME] | 1100 | 3390
[NAME] | 50 | 56
[NAME] | 100 | 980
[NAME] | 1 | 0.79
Spreadsheet: 726730d1617389584-holiday-sheet-rota-work-in-progresslastonev3broken
Sheet: Help

HOLIDAY 1 |  |  |  |  |  |  | TOTAL HOURS | BREAKS REMOVED
START: | 2021-04-07 00:00:00 |  | END: | 2021-04-09 00:00:00
DAY | START | FINISH | BREAK | BREAK | BREAK | DINNER
MON | 07:00:00 | 16:30:00 | 0.5 |  |  | 1
TUE | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
WED | 07:00:00 | 15:30:00 | 0.5 |  |  | 1
THUR | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
FRI | 07:00:00 | 16:00:00 | 0.5 |  |  | 1
SAT
SUN
 |  |  |  |  |  |  | WEEKLY HOURS
 |  |  |  |  |  |  | BREAKS REMOVED
Spreadsheet: 215644d1361443293-display-only-numbers-with-a-specific-number-ver1-lookup
Sheet: Sheet3

CustomerID | Full Name | Contact Name | Street | City | County | Postcode | Phone
1 | Helen Smith Enterprises | [NAME] | 123 Maple Street | Leeds | [NAME] | abc 123 | 01244 223344
2 | [NAME] | Mr Barclay Banks | 3 Maple Avenue | Bradford | Cheshire | abc 124 | 1245 223344
3 | CFS aeroproducts | [NAME] | 125 OakStreet | York | Bucks | abc 125 | 1246 223344
4 | Norvic Engines | [NAME] | 126PalmStreet | Chester | Herefordshire | abc 126 | 1247 223344
5 | [NAME] | [NAME] | 127 Apple Street | Liverpool | Hertfordshire | abc 127 | 1248 223344
6 | Back Street Garage | Mr [NAME] | 128 OrangeStreet | [NAME] | Shropshire | abc 128 | 1249 223344
7 | [NAME] | [NAME] | 129 Brown Street | Birmingham | Bedfordshire | abc 129 | 1250 223344
8 | [NAME] | [NAME] | 130 NewStreet | Hull | Lincolnshire | abc 130 | 1251 223344
9 | ACDC Electrics | Miss [NAME] | 131 OldStreet | Preston | Staffordshire | abc 131 | 1252 223344
10 | Billy Bodger & Co | Miss [NAME] | 132 PineStreet | [NAME] | Lancashire | abc 132 | 1253 223344
11 | Grabbit and Run Ltd | Dedarian | 133 WoodStreet | Stoke on Trent | Derbyshire | abc 133 | 1254 223344
12 | Piston & Broke Ltd | Field [NAME] | 134 White Street | Newcastle | West Yorkshire | abc 134 | 1255 223344
13 | Suckit and Sea Engineering | Mr [NAME] | 135 Black grove | Oxford | Flintshire | abc 135 | 1256 223344
Spreadsheet: 5344e292-98e7-4503-9e6a-2d437e60ce11
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5734 | 33084 | [NAME] | Henderson | GBR | 0 | 00:27:40 | 00:02:40 | 01:07:30 | 00:02:06 | 00:51:15 | 1 | 02:31:11
5734 | 33085 | [NAME] | Leonard | GBR | 0 | 00:25:29 | 00:03:08 | 01:12:32 | 00:02:52 | 00:48:44 | 2 | 02:32:45
5734 | 40372 | [NAME] | O'Hara | IRL | 0 | 00:27:33 | 00:03:08 | 01:07:18 | 00:02:37 | [NAME] | 3 | 02:36:37
Spreadsheet: 829623d1684336179-return-a-number-value-depending-on-value-of-cells-in-a-different-column-xlookup-company-number-and-return-with-company-name
Sheet: Sheet1

Company Name | Customer Number - RESULT Needed |  |  | Customer Number | Company Name
Company 1 | 1 |  |  | 1
Company 2 | 2 |  |  | 5
Company 3 | 3
Company 1 | 1
Company 2 | 2
Company 3 | 3
Company 1 | 1
Company 3 | 3
Company 2 | 2
Company 2 | 2
Company 4 | 4
Company 1 | 1
Company 1 | 1
Company 1 | 1
Company 1 | 1
Company 1 | 1
Company 1 | 1
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  | 2
2
3 |  |  | 39 | 40
4 |  |  | 5
5 |  |  | 9
6 |  |  | 1
7 |  |  | 8
8 |  |  | 3
9 |  |  | 8
10 |  |  | 17
11 |  |  | 15
12 |  |  | 10
13 |  |  | 12
14
15
16 |  |  | 16
17 |  |  | 15
18 |  |  | 13
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  |  |  | -18571.37
2001-06-18 00:00:00
Spreadsheet: 83545d1283510243-how-to-v-lookup-and-use-if-statement-cleaning2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | 0 = No (not cleaned)
 |  |  | % receiving required window clean | 0.5995222929936306 | 0.6141078838174274 | 0.6236905721192587 | 0.6460431654676259 | 0.6555160142348755 | 0.7019299499642602 | 0.6584680252986648 |  |  | 1 = 1 (cleaned once)
 |  |  | shops with 1 window clean | 637 | 626 | 663 | 768 | 785 | 843 | 816 |  |  | 2 = 2 (cleaned twice)
 |  |  | shops with 2 window cleans | 116 | 114 | 111 | 130 | 136 | 139 | 121 |  |  | blank = not recorded
 |  |  | shops with missed window cleans | 503 | 465 | 467 | 492 | 484 | 417 | 486
 |  |  | No Report | 215 | 268 | 261 | 117 | 83 | 117 | 101
Shop | Region | Area | R&A | Wk1 | Wk2 | Wk3 | Wk4 | Wk5 | Wk6 | Wk7 | Wk8 | Wk9 |  | Wk8 | Wk8 | Wk9 | Wk9
1554 | HC | 1 | HC1 | NR | No | No | No | No | 1 | No |  |  |  | 1554 | 0 | 1554 | 0
1555 | HC | 1 | HC1 | No | 1 | No |  | 1 | 1 | 1 |  |  |  | 1555 | 0 | 1555 | 0
2072 | HC | 1 | HC1 | 1 | NR | 1 | 1 |  | 1 | 1 |  |  |  | 2072 | 1 | 2072 | 1
2074 | HC | 1 | HC1 |  | 1 | 1 | 1 | No | No | 1 |  |  |  | 2074 | 0 | 2074 | 0
2083 | HC | 1 | HC1 | No | No | No | No | No | No | No |  |  |  | 2083 | 0 | 2083 | 0
2220 | HC | 1 | HC1 | No | NR | NR | NR | NR | 1 | 1 |  |  |  | 2220 | 1 | 2220 | 1
2460 | HC | 1 | HC1 |  | 1 |  | 2 | 2 | 2 | 2 |  |  |  | 2460 | 1 | 2460 | 1
2471 | HC | 1 | HC1 | 1 | No | 1 | 1 | No | 1 | 1 |  |  |  | 2471 | 1 | 2471 | 1
2478 | HC | 1 | HC1 | NR | No | No | No | No | 1 | No |  |  |  | 2478 | 0 | 2478 | 0
2483 | HC | 1 | HC1 | No | No | No | No | 1 | 1 | No |  |  |  | 2483 | 0 | 2483 | 0
2484 | HC | 1 | HC1 | NR | No | No | No | No | No |  |  |  |  | 2484 | 0 | 2484 | 0
2485 | HC | 1 | HC1 |  | NR | NR | NR | No |  |  |  |  |  | 2486 |  | 2485 | 2
2486 | HC | 1 | HC1 | 1 | NR | No | No | 1 | 1 | 1 |  |  |  | 2487 | 1 | 2486
2487 | HC | 1 | HC1 | NR | NR | 1 | NR | 1 | 1 | 1 |  |  |  | 2488 | 1 | 2487 | 1
2488 | HC | 1 | HC1 | NR | 2 | 1 | 1 | 1 | 1 | 1 |  |  |  | 2490 | 0 | 2488 | 1
2490 | HC | 1 | HC1 | No | No | 1 | 1 | 1 | NR | No |  |  |  | 2690 | 0 | 2490 | 0
2690 | HC | 1 | HC1 | NR | No | No |  | No | 1 | No |  |  |  | 2691 | 0 | 2690 | 0
2691 | HC | 1 | HC1 | No | No | No | No | NR | 1 | No |  |  |  | 2695 | 1 | 2691 | 0
2695 | HC | 1 | HC1 | 1 | 1 | No | 1 | 1 | 1 | 2 |  |  |  | 2696 | 1 | 2695 | 1
2696 | HC | 1 | HC1 |  | No | 1 | 1 | 1 | 1 | 1 |  |  |  | 2697 | 1 | 2696 | 1
2697 | HC | 1 | HC1 | 1 | 1 | No | 1 | 1 | No | 1 |  |  |  | 2698 |  | 2697 | 1
Spreadsheet: 153001d1335681010-excel-2007-count-how-many-a-value-occurs-with-given-set-of-criteria-mupa
Sheet: Sheet2

Region | Salesperson | Type | Sales
South | [NAME] | Beverages | 3571
West | Davolio | Dairy | 3338
East | Suyama | Beverages | 5122
North | Suyama | Dairy | 6239
South | Dodsworth | Produce | 8677
South | Davolio | Meat | 450
South | Davolio | Meat | 7673
East | Suyama | Produce | 664
North | Davolio | Produce | 1500
South | Dodsworth | Meat | 6596
[NAME] | Description (result)
=COUNT(IF((A2:A11="South")*(C2:C11="Meat"),D2:D11)) | Number of salespeople who sold meat in the South region (3)
=COUNT(IF((B2:B11="Suyama")*(D2:D11>=1000),D2:D11)) | Number of sales greater than 1000 by [NAME] (2)
Notes
Spreadsheet: 116150d1311626483-going-through-a-sequence-of-numbers-example
Sheet: Sheet1

a | b
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
2 | 1
2 | 2
2 | 3
2 | 4
2 | 5
3 | 1
3 | 2
3 | 3
3 | 4
3 | 5
4 | 1
4 | 2
4 | 3
4 | 4
4 | 5
Spreadsheet: 816884d1675873519-filter-formula-searching-for-variable-date-test-search-etaf
Sheet: Sheet1

Date | Fruit
2009-02-11 00:00:00 | Plum
2020-02-16 00:00:00 | Grapefruit
2021-02-08 00:00:00 | Apple
2021-02-09 00:00:00 | Pear
2021-02-09 00:00:00 | [NAME]
2021-02-10 00:00:00 | Nectarine
2021-02-11 00:00:00 | Blueberry
2021-02-12 00:00:00 | [NAME]
2021-02-13 00:00:00 | Mandarin
2021-02-14 00:00:00 | Papaya
2021-02-15 00:00:00 | Pineapple
2021-02-16 00:00:00 | [NAME]
2021-02-17 00:00:00 | Avocado
2022-02-08 00:00:00 | Watermelon
2022-02-09 00:00:00 | [NAME]
2022-02-10 00:00:00 | Grape
2022-02-11 00:00:00 | Pomegranate
2022-02-12 00:00:00 | [NAME]
2022-02-15 00:00:00 | Lime
2022-02-16 00:00:00 | Melon
2022-02-17 00:00:00 | Peach
2023-02-08 00:00:00 | Orange
2023-02-08 00:00:00 | Mango
2023-02-09 00:00:00 | Blackberry
2023-02-10 00:00:00 | Starfruit
2023-02-10 00:00:00 | Breadfruit
2023-02-11 00:00:00 | Jackfruit
2023-02-11 00:00:00 | [NAME]
2023-02-13 00:00:00 | Kiwi
2023-02-14 00:00:00 | Lemon
2023-02-15 00:00:00 | Coconut
2023-02-16 00:00:00 | [NAME]
Spreadsheet: 771898d1646910675-creating-a-golf-leaderboard-that-automatically-updates-from-the-internet-copy-of-golf
Sheet: Sheet 1 example 

 | These fields all populate from linking https://www.pgatour.com/competition/2022/the-players-championship/leaderboard.html
Player | Round 1 Score | Round 2 Score | Round 3 Score | Total | Number of holes in 1 | Position | Points | Points is based on position and corresponding scoring sheet
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Si-Woo Kim
[NAME]
[NAME]
[NAME]
[NAME]
Talor Gooch
[NAME] Im
Mackenzie Hughes
[NAME]
Campbell
Jon Rahm
Shane Lowry
[NAME]
[NAME]
[NAME]
[NAME]
Pearce
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 486912d1477767478-how-do-i-sort-data-to-another-sheet-test-spreadsheet_spr2017_db
Sheet: Summary

 | # | Last Name | First Name | Date of Entry | Total Hours
 |  |  |  | TOTAL
Spreadsheet: darrell_schoolcraft__7760__imbalsumm0105
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 146667 | 151618
2 | 162921 | 164147
3 | 116543 | 112910
4 | 133793 | 132426
5 | 112076 | 111315
6 | 101413 | 102757
7 | 103933 | 100464
8 | 85031 | 83947
9 | 101768 | 100180
10 | 114756 | 110454
11 | 144643 | 141056
12 | 168673 | 165000
13 | 125642 | 122288
14 | 126077 | 120663
15 | 99818 | 99764
16 | 135287 | 134340
17 | 148464 | 146930
18 | 133395 | 131433
19 | 152492 | 147690
20 | 163458 | 165000
21 | 144756 | 142298
22 | 134148 | 131091
23 | 128131 | 125568
24 | 137957 | 136803
25 | 119094 | 122686
26 | 133339 | 154702
27 | 130712 | 142953
28 | 144329 | 153508
29 | 130090 | 127229
30 | 155752 | 165000
31 | 151414 | 152679
2001-04-30 00:00:00 |  |  | 82528
2001-05-31 00:00:00
Spreadsheet: lynn_blair__24402__JKnight Gathering Imb thru 4-01
Sheet: Ellis-Woodward-Clark

**DRAFT**
Northern and Oneok OBA Reconcilation
As of 4/25/01 (September 2000 thru April 2001)
 |  | 2000-09-01 00:00:00 |  |  |  | 2000-10-01 00:00:00 |  |  |  | 2000-11-01 00:00:00 |  |  |  | 2000-12-01 00:00:00 |  |  |  | 2001-01-01 00:00:00 |  |  |  | 2001-02-01 00:00:00 |  |  |  | 2001-03-01 00:00:00 |  |  |  | 2001-04-01 00:00:00 |  |  |  | Cumulative
 |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME] |  | Scheduled | Allocated | [NAME]
Contract 107444
 | 71410 - NNG/KN/Crescendo Ellis Co. | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 21266 | 16982 |  |  | 22949 | 9662 |  |  | 21304 | 1832 |  |  | 10147 | 18552 |  |  | 12484 | 5601
 | 78109 - Ellis Co. #2/Oneok | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 197418 | 235293 |  |  | 206484 | 185079 |  |  | 170932 | 144288 |  |  | 145765 | 150174 |  |  | 151766 | 166438
 | Total
 | Net Adjust. |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | MIP |  |  | 4.8503 |  |  |  | 4.8727 |  |  |  | 5.209 |  |  |  | 8.7182 |  |  |  | 8 |  |  |  | 5.5555 |  |  |  | 4.9851 |  |  |  | 4.9474
 | Monthly Value
 | Cummulative
Contract 107445
 | 78108 - Woodward Co. #1/Oneok | 0 | 0 |  |  | 0 | 0 |  |  | 0 | 0 |  |  | 14018 | 14544 |  |  | 38243 | 19946 |  |  | 36435 | 24335 |  |  | 24621 | 28468 |  |  | 30277 | 27150
 | Total
 | Net Adjust. |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 | MIP |  |  | 4.8503 |  |  |  | 4.8727 |  |  |  | 5.209 |  |  |  | 8.7182 |  |  |  | 8 |  |  |  | 5.5555 |  |  |  | 4.9851 |  |  |  | 4.9474
 | Monthly Value
 | Cummulative
Contract 107446
 | 78107 - Clark Co. #1/Oneok | 0 | 0 |  |  | 0 | 0 |  |  | 19685 | 34295 |  |  | 20088 | 35446 |  |  | 33674 | 35013 |  |  | 60179 | 30879 |  |  | 38312 | 35176 |  |  | 33335 | 30227
 | Total
 | Net Adjust. |  |  |  | 0 |  |  |  | 0
 | MIP |  |  | 4.8503 |  |  |  | 4.8727 |  |  |  | 5.209 |  |  |  | 8.7182 |  |  |  | 8 |  |  |  | 5.5555 |  |  |  | 4.9851 |  |  |  | 4.9474
 | Monthly Value
 | Cummulative
 | Cummulative Total for all Contracts:
(+) | Amount due [NAME]
(-) | Amount due Northern