tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 169337d1342788885-finds-end-of-list-an-populates-listout
Sheet: Search Terms & Keywords

Keywords | Search Terms | Combination
learners license | "add url" | learners license  "add url"
learners permit | "add site" | learners license  "add site"
k53 test | "add website" | learners license  "add website"
martin test | "add your site" | learners license  "add your site"
 | "add a url" | learners license  "add a url"
 | "add * url" | learners license  "add * url"
 | *something* | learners license *something*
 |  | learners permit  "add url"
 |  | learners permit  "add site"
 |  | learners permit  "add website"
 |  | learners permit  "add your site"
 |  | learners permit  "add a url"
 |  | learners permit  "add * url"
 |  | learners permit *something*
 |  | k53 test  "add url"
 |  | k53 test  "add site"
 |  | k53 test  "add website"
 |  | k53 test  "add your site"
 |  | k53 test  "add a url"
 |  | k53 test  "add * url"
 |  | k53 test *something*
 |  | martin test  "add url"
 |  | martin test  "add site"
 |  | martin test  "add website"
 |  | martin test  "add your site"
 |  | martin test  "add a url"
 |  | martin test  "add * url"
 |  | martin test *something*
Spreadsheet: daren_farmer__6582__Buybacklist
Sheet: Dec99

BUYBACK/DEFICIENCY DEALS
1999-12-01 00:00:00
Counterparty | Base Deal |  | Swing Sale |  | Buyback |  | Term |  | [NAME]
Air Products, Inc. | 120265 |  | 122216 |  | 132976 |  | 2000-09-30 00:00:00 |  | 1418
Air Liquide America | 131603 |  | Tiered |  | 131605 |  | 2000-01-31 00:00:00 |  | 8001
BASF Corp. | 120266 |  | 122310 |  | 133000 |  | 2001-10-31 00:00:00 |  | 1437
Bayer Corp. | 131305 |  | Tiered |  | 131309 |  | 1999-12-31 00:00:00 |  | 8056/1550
BMC Limited Ptr. | 93199 |  |  |  |  |  | 2000-06-30 00:00:00 |  | 1428
BMC Limited Ptr. |  |  | 93208 |  | 93202 |  | 1999-12-31 00:00:00 |  | 1428
Chevron Chemical Co. | 116494 |  | 119166 |  |  |  | 2000-03-31 00:00:00 |  | 1024
Chevron Chemical Co. |  |  |  |  | 119167 |  | 1999-12-31 00:00:00 |  | 1024 | 138614 for Jan Buyback
[NAME] | 92787 |  | 92786 |  | 92790 |  | 1999-12-31 00:00:00 |  | 8216
[NAME] | - |  | - |  | 139681 |  | 1999-12-31 00:00:00 |  | 8216 | Spot Deal as of 12/17/99
Enron Methanol | 92803 |  | 92800 |  | 92806 |  | 1999-12-31 00:00:00 |  | 8291
[NAME]
Formosa Hydrocarbons | 92872 |  |  |  | 92881 |  | 2000-07-31 00:00:00 |  | 1000
Formosa Hydrocarbons | 92880 |  | 92876 |  |  |  | 2000-04-30 00:00:00 |  | 1000
Global Octanes |  |  |  |  | 92885 |  | 1999-12-31 00:00:00 |  | 1528 | 137991 for Jan Buyback
Global Octanes | 92886 |  | 92887 |  |  |  | 2000-08-31 00:00:00 |  | 1528
Lyondell-Citgo | 92932 |  | 92905 |  | 92899 |  | 1999-12-31 00:00:00 |  | 1063
Marathon Ashland Petroleum | 119068 |  | Tiered |  | 93371 |  | 2000-09-30 00:00:00 |  | 1431
Petrofina Gas Pipeline | 131348 |  | Tiered |  | 131356 |  | 2000-03-31 00:00:00 |  | 1484
Rohm & Haas Texas, Inc. | 132065 |  | Tiered |  | 132066 |  | 1999-12-31 00:00:00 |  | 1506
Shell Oil Co. | 130133 |  |  |  |  |  | 2000-06-30 00:00:00 |  | 1060/1061/1095/1581
Shell Oil Co. |  |  | 93180 |  |  |  | 2000-07-31 00:00:00 |  | 1060/1061/1095/1581
Shell Oil Co. |  |  |  |  | 93190 |  | 1999-12-31 00:00:00 |  | 1060/1061/1095/1581
Union Carbide
Valero | 119065 |  | Tiered |  | 127304 |  | 2000-09-30 00:00:00 |  | 1233/1394/8018
Spreadsheet: 864289d1711506571-find-the-most-recent-buy-value-find_buy_price_example_v2
Sheet: Sheet1

Date | Signal | Price | #[NAME] | Value | Profit | % Profit
2014-03-27 00:00:00 | Buy | 184.58
2014-03-28 00:00:00 | Ignore | 185.49
2014-03-31 00:00:00 | Sell | 187.01
2014-08-28 00:00:00 | Buy | 200.14
2014-08-29 00:00:00 | Sell | 200.71
2014-09-30 00:00:00 | Buy | 197.02
2014-10-01 00:00:00 | Ignore | 194.35
2014-10-02 00:00:00 | Ignore | 194.38
2014-10-03 00:00:00 | Sell | 196.52
2014-12-31 00:00:00 | Buy | 205.54
2015-01-02 00:00:00 | Ignore | 205.43
2015-01-05 00:00:00 | Ignore | 201.72
2015-01-06 00:00:00 | Ignore | 199.82
2015-01-07 00:00:00 | Ignore | 202.31
2015-01-08 00:00:00 | Sell | 205.9
The $[NAME] after each buy needs to stay constant (Green).
It should only change with the next buy according to =INT(10000/C2) etc
Spreadsheet: 781161d1653038726-tree-network-test_finding_route_node
Sheet: Sheet1

Node | Node | Length |  | Node | Node | Length |  | Node | Node | Length |  | Node | Node | Length |  | Node | Node | Length
1 | 2 | 10 |  | 1 | 2 | 10 |  | 1 | 2 | 10 |  | 1 | 2 | 10 |  | 1 | 2 | 10
2 | 3 | 9 |  | 2 | 3 | 9 |  | 2 | 4 | 8 |  | 2 | 4 | 8 |  | 2 | 4 | 8
2 | 4 | 8 |  |  |  |  |  | 4 | 5 | 15 |  | 4 | 6 | 12 |  | 4 | 7 | 7
4 | 5 | 15
4 | 6 | 12
4 | 7 | 7
Spreadsheet: 391000d1429823072-calculating-a-due-date-based-on-a-range-of-payment-terms-6032wayne-test-sheet
Sheet: After

APPLIC | COMPANY | SITE | AMOUNT | DATE | Due Date | Paid | Chq/BACs | [NAME]
1 | ABC | A | 79901 | 2012-01-23 00:00:00 | 2012-02-22 00:00:00
2 | ADA | F | 128158 | 2012-01-24 00:00:00 | 2012-03-06 00:00:00
3 | BCR | K | 135548 | 2012-02-02 00:00:00 | 2012-03-29 00:00:00
4 | ADA | E | 84602 | 2012-02-04 00:00:00 | 2012-03-29 00:00:00
5 | ADA | G | 93270 | 2012-02-05 00:00:00 | 2012-03-11 00:00:00
6 | BCR | L | 103424 | 2012-02-07 00:00:00 | 2012-03-08 00:00:00
7 | ABC | B | 148591 | 2012-02-12 00:00:00 | 2012-03-29 00:00:00
8 | ABC | D | 147058 | 2012-02-13 00:00:00 | 2012-04-28 00:00:00
9 | BCR | K | 18327 | 2012-02-15 00:00:00 | 2012-03-29 00:00:00
10 | ADA | H | 121585 | 2012-02-18 00:00:00 | 2012-04-18 00:00:00
Spreadsheet: 782891d1654382628-word-listed-items-to-excel-particular-format-2022dirphil_word2excel01
Sheet: 2022DirPhil_Election2022Result

[NAME], CORDILLERA ADMINISTRATIVE REGION
[NAME] | 0.9975 | Returns transmitted | 394 of 395 clustered precincts | As of 2:47 PM - May 13, 2022 |  | Partial, results data as of May 13, 2022, 2:47 PM and from 99.75% of Returns
Governor
1st | VALERA, NIC |  |  | (ASENSO) | 74288
2nd | BERSAMIN, TAKIT |  |  | (PDR) | 63478
Vice Governor |  |  |  |  |  | Partial, results data as of May 13, 2022, 2:47 PM and from 99.75% of Returns
1st | BERNOS, JOY |  |  | (ASENSO) | 102283
2nd | BERSAMIN, [NAME] |  |  | I (PDR) | 34123
Provincial Board Member |  |  |  |  |  | Partial, results data as of May 13, 2022, 2:47 PM from 217 Returns
1st | BRAGAS, [NAME] |  |  | (ASENSO) | 65475
2nd | SEARES, ALLAN |  |  | (ASENSO) | 52726
Provincial Board Member |  |  |  |  |  | Partial, results data as of May 13, 2022, 2:47 PM from 177 Returns
1st | BAROÑA, VICTORINO JR |  |  | . (ASENSO) | 42955
2nd | GAYAO, HENRIETTA |  |  | (ASENSO) | 39464
Congressman |  |  |  |  |  | Partial results data as of May 13, 2022, 2:47 PM from 394 Returns
1st | BERNOS, CHING |  |  | (NP) | 122223
2nd | AQUINO, [NAME] |  |  | (AKSYON) | 5,159
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Spreadsheet: 882576d1730975329-if-a-cell-has-a-number-in-with-a-certain-text-for-it-then-to-be-added-in-a-different-cel-molecular-
Sheet: Sheet1

Molecular
Panel 1 |  |  | Mcps | smokes | heat | bases | sounder base | sounder beacon | wall sounder beacon | I/O
Loop 1
MCP's-3
Opticals-30
Heats-0
Sounder Bases-19
[NAME] Bases-4
Wall Sounder Beacon-2
I/O's-3
Panel 1
[NAME]
MCP's-9
Opticals-3
Heats-37
Multi's-2
Wall Sounder Beacon-9
I/O's-7
Panel 2
Loop 1
MCP's-11
Opticals-49
Heats-3
Multi's-1
Sounder Base-17
[NAME]
Wall Sounder Beacon-5
I/O's-1
Panel 2
[NAME]
MCP's-1
Opticals-1
Sounder Base-1
Panel 3
Loop 1
MCP's-4
Opticals-17
Heats-2
Sounder Bases-6
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-1
Panel 4
Loop 1
MCP's-2
Opticals-9
Wall Sounder Beacons-2
Panel 5
Loop 1
MCP's-5
Opticals-37
Heats-2
Sounder Bases-13
[NAME] Bases-2
Wall Sounder Beacons-3
I/O's-4
Panel 6
Loop 1
MCP's-1
Opticals-1
Sounder Base-1
I/O-1
Spreadsheet: 745030d1629701572-group-by-using-filter-array-and-then-join-columnn-and-rows-pq-and-formula-filter-group-by
Sheet: Sheet1

RAW DATA |  |  |  |  | [NAME] | 1 |  |  | PQ Result
Date | Machine | Scrap | Reason |  |  |  |  |  | Date | Machine | Sum | ScrapTextCombined |  | Date | Machine | T
2021-08-22 00:00:00 | A | 20 | mix |  |  |  |  |  | 2021-08-21 00:00:00 | A | 73 | [NAME], full=5 |  | 2021-08-21 00:00:00 | A | test=55, mix=12, full=5
2021-08-22 00:00:00 | A | 3 | test |  |  |  |  |  | 2021-08-21 00:00:00 | B | 60 | [NAME], full=26 |  | 2021-08-21 00:00:00 | B | [NAME], full=26
2021-08-22 00:00:00 | A | 5 | full |  |  |  |  |  | 2021-08-22 00:00:00 | A | 28 | mix=20, full=5, test=3 |  | 2021-08-22 00:00:00 | A | mix=20, full=5, test=3
2021-08-22 00:00:00 | B | 1 | mix |  |  |  |  |  | 2021-08-22 00:00:00 | B | 6 | full=5 |  | 2021-08-22 00:00:00 | B | full=5
2021-08-22 00:00:00 | B | 5 | full
2021-08-21 00:00:00 | A | 12 | mix
2021-08-21 00:00:00 | A | 55 | test |  |  |  |  |  | Date | Machine
2021-08-21 00:00:00 | B | 21 | full |  |  |  |  |  | 2021-08-21 00:00:00 | B
2021-08-21 00:00:00 | B | 22 | mix
2021-08-21 00:00:00 | A | 5 | full
2021-08-21 00:00:00 | A | 1 | mix
2021-08-21 00:00:00 | B | 5 | full |  |  |  |  | That my filterd list, I need to group them somehow | Filtered list, using the scrap  limit and only showing the 2 columns I need to join
2021-08-21 00:00:00 | B | 12 | mix |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  | full | 21
 |  |  |  |  |  |  |  |  | mix | 12
 |  |  |  |  |  |  |  |  | full | 5
 |  |  |  |  |  |  |  | That my result so far, using LET to make it easier to read
 |  |  |  |  |  |  |  | That’s what I need (from PQ) but I cant get it with formulas | [NAME], full=26
 |  |  |  |  |  |  |  | That’s how my filtered table should look like, then I can use textjoin,.. To create my list
 |  |  |  |  |  |  |  | mix | 34
 |  |  |  |  |  |  |  | full | 26
Spreadsheet: daren_farmer__6581__Texas Weather
Sheet: Mar

[NAME]
 | - NORMAL - |  |  |  | ACTUAL & FORECAST |  |  |  | Cum. | Temp |  | - NORMAL - |  |  |  | ACTUAL & FORECAST |  |  |  | Cum. | Temp
- DATE - | High | Low | AVG | HDD | High | Low | AVG | HDD | HDD | Range |  | High | Low | Avg | HDD | High | Low | AVG | HDD | HDD | Range |  | HOUSTON INTERCONTINENTAL (IAH) |  |  |  | HOUSTON HOBBY (HOU)
2000-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 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
Spreadsheet: 761416d1640883471-monthly-percentage-of-job-volumes-by-area-tangible-dashboard
Sheet: Cost Profit

 | Profit Statement Template |  |  | Jan | Feb | Mar | Apr | May | June | July | August | September | October | November | December
 | Total
 | Profit
 | Operating Profit
 | Operating Profit Margin
Spreadsheet: 63816d1264686693-how-to-get-the-count-of-unique-entries-as-the-subtotal-of-a-pivot-table-counting-of-entries-example
Sheet: Sheet4

Count of ID
ID | Total
2528 | 2
2529 | 2
2550 | 9
2670 | 50
2696 | 29
2707 | 32
2927 | 3
2935 | 2
2969 | 3
2979 | 2
3064 | 18
3065 | 16
3235 | 15
3252 | 1
3375 | 3
3433 | 2
3508 | 14
3526 | 8
3535 | 2
3607 | 1
3622 | 1
3748 | 7
3749 | 2
3769 | 1
3786 | 38
3943 | 4
3981 | 3
3982 | 2
4028 | 4
4116 | 6
4170 | 16
4180 | 2
4414 | 8
5115 | 3
5147 | 1
5232 | 19
5235 | 2
5286 | 11
5287 | 7
5353 | 2
5501 | 1
5539 | 1
5568 | 2
5666 | 2
5923 | 1
6001 | 1
6122 | 19
6144 | 2
6247 | 1
6280 | 2
6332 | 1
6346 | 12
6442 | 6
6445 | 6
6492 | 1
6527 | 2
6537 | 1
6862 | 31
7048 | 3
7204 | 1
7355 | 1
7496 | 8
7705 | 1
7718 | 11
7759 | 13
8074 | 3
8091 | 1
8178 | 1
8445 | 1
8547 | 18
8583 | 1
8918 | 2
9014 | 1
9190 | 2
9430 | 3
9741 | 2
9742 | 1
9746 | 5
9816 | 3
9836 | 1
9918 | 1
10024 | 1
10074 | 1
10155 | 2
10247 | 12
10653 | 2
10799 | 1
10904 | 7
10938 | 3
11010 | 2
11011 | 1
11122 | 29
11453 | 1
11602 | 1
11603 | 1
11699 | 7
11867 | 2
11955 | 1
11958 | 15
11989 | 3
12059 | 10
12164 | 2
13466 | 1
18864 | 1
301503 | 2
302593 | 1
303338 | 1
314960 | 1
315377 | 1
316304 | 2
318754 | 2
323844 | 1
325371 | 1
326295 | 2
327625 | 5
330032 | 43
330129 | 2
330697 | 3
330776 | 1
332793 | 1
333766 | 2
334317 | 1
335396 | 1
336408 | 2
337553 | 2
337609 | 2
338729 | 2
338738 | 12
338966 | 1
339535 | 1
340229 | 1
341275 | 1
343417 | 2
343790 | 3
344813 | 4
345623 | 1
345808 | 2
347724 | 3
347931 | 2
348472 | 1
348594 | 2
348706 | 2
353946 | 1
354466 | 2
355145 | 1
358235 | 7
358454 | 1
359625 | 1
360130 | 1
360197 | 1
362090 | 1
363619 | 1
364131 | 1
367223 | 1
367225 | 1
367367 | 1
3026365 | 2
Grand Total | 777
Unique Entries
157
Spreadsheet: 110305d1307019191-data-from-two-files-book2
Sheet: Sheet2

Item number | Item Name | On-hand
110019 |  | 0
331711 |  | 1
CAM013 |  | 8
CAM203 |  | 1
CAM210 |  | 3
CB042AB |  | 4
CB042BB |  | 23
CB042DB |  | 16
CB044BB |  | 7
CB072A1 |  | 0
CB072C1 |  | 0
DAR0054 |  | 9
ERCDU |  | 3
Spreadsheet: 727098d1617714546-numbers-doesnt-look-right-id-number-format
Sheet: Sheet1

Lookup ID
639299
639368
639756
639813
643511
657825
659006
659022
659544
659641
666508
666747
666803
667101
667201
670159
670191
670222
670263
670278
670317
670375
670423
670528
670649
670660
670685
670696
670824
670856
670886
670926
671091
671151
671201
671321
671336
671380
671416
671482
671499
671533
671537
901054
905698
905757
906452
906788
906810
908130
909390
910080
910963
912200
915038
915512
919804
921372
921557
921677
922462
922598
924732
924967
925203
926176
926377
926515
929221
929228
929895
929984
930014
930145
930237
930533
930574
935682
935823
936409
936577
937572
942446
942800
944357
949931
952170
952928
953547
953852
954038
956531
956650
956846
957434
966053
967113
967487
970429
970701
1002693
1002962
1002996
1003114
1003382
1003569
1003573
1003810
1004096
1004219
1004609
1004730
1005946
1006047
1008993
10612960
10612988
10613072
10613125
10613155
10613226
10613316
10613357
10613446
10613573
10613735
10613790
10613976
10613997
10614377
10616546
10628554
10648142
10648314
41074-1984
44115-1987
45169-1988
50276-1993
51470-1994
51634-1994
52511-1995
53748-1996
56162-1999
57792-2001
58376-2001
61415-2005
63169-2007
64192-2008
64839-2008
64960-2008
66390-2010
66407-2010
666863
68040-2011
70151-2013
70981-2014
71614-2015
72232-2015
72250-2015
72754-2016
941405
957435
26188-1966
26609-1966
27551-1968
29070-1970
30716-1972
31152-1973
32216-1974
Spreadsheet: 473469d1470230497-stage-progression-example
Sheet: Sheet1

LEVEL 3 STUDENTS |  | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3
Doe | [NAME] | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
LEVEL 2 STUDENTS |  | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3
Smith | [NAME] | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00
LEVEL 1 STUDENTS |  | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3
Jones | [NAME] | 2016-04-01 00:00:00
Spreadsheet: 844037d1695835894-calculating-meal-penalties-formula-time-exposure-analysis-template
Sheet: TEMPLATE

 | Standadrd Day |  | Standard Week | 40
 | Regular Rate | 1 | Week #: |  | Week Start: |  | Week End: |  | Pay Date:
 | OT Rate
 | Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 |  | Monday |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:00:00
 |  | Tuesday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Wednesday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Thursday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Friday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Saturday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Sunday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  |  |  |  |  |  |  | Total Hours
 |  |  |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  |  | Total Pay
 | WEEK#: |  | START: |  | END: |  |  |  | PAY DATE:
 | Date | Day | Type | Time In | Time Out | Time In | Time Out | [NAME] | Regular | OT
 |  | Monday |  | 08:00:00 | 13:00:00 | 13:30:00 | 16:57:00
 |  | Tuesday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Wednesday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Thursday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Friday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Saturday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 |  | Sunday |  | 08:00:00 | 13:00:00 | 13:30:00 | 19:00:00
 | Regular Rate | 1 |  |  |  |  |  | Total Hours
 | OT Rate |  |  |  |  |  |  | Rate Per Hour | 1 | 1.5
 |  |  |  |  |  |  |  | Total Pay
Spreadsheet: 234512d1368115512-using-sumproduct-with-conditions-example-mf1
Sheet: Sheet1

 | 2000 |  |  |  |  |  | 2001
 | NAME | Position | A.Return | G.Return | Weight |  | NAME | Position | A.Return | G.Return | Weight
 | a | 1 | 0.5 | 0.5 |  |  | f | 1 | 0.4 | 0.4
 | b | 1 | 0.2 | 0.4 |  |  | g | 1 | 0.1 | 0.7
 | c | 1 | 0.1 | 0.5 |  |  | i | 1 | 0.5 | 0.5
 | d | 1 | 0.3 | 0.1 |  |  | l | 1 | 0.8 | 0.8
 | e | 2 | 0.4 | 0.8 |  |  | p | 2 | 0.9 | 0.7
 | f | 2 | 0.5 | 0.1 |  |  | s | 2 | 0.6 | 0.4
 | g | 2 | 0.4 | 0.9 |  |  | t | 2 | 0.5 | 0.1
 | h | 2 | 0.6 | 0.4 |  |  | u | 2 | 0.7 | 0.4
 | i | 3 | 0.4 | 0.5 |  |  | v | 3 | 0.5 | 0.7
 | j | 3 | 0.2 | 0.4 |  |  | w | 3 | 0.9 | 0.9
 | k | 3 | 0.4 | 0.2 |  |  | x | 3 | 0.6 | 0.5
 | l | 3 | 0.5 | 0.4 |  |  | y | 3 | 0.8 | 0.7
 |  | Portfolio | 2000 |  | 2001
 |  |  | A.Return | G.Return | A.Return | G.Return
 |  | 1
 |  | 2
 |  | 3
 | Should be
Spreadsheet: 82592d1282658467-complex-conditional-formatting-formula-help-example
Sheet: Sheet1

OrderDate | CustomerID
2009-08-28 00:00:00 | 209804
2009-09-04 00:00:00 | 209804
2009-09-04 00:00:00 | 209804
2009-10-17 00:00:00 | 235853
2009-10-17 00:00:00 | 235853
2009-10-17 00:00:00 | 235853
2009-10-17 00:00:00 | 235853
2009-10-17 00:00:00 | 235853
2009-10-17 00:00:00 | 235853
2009-09-24 00:00:00 | 230168
2009-09-25 00:00:00 | 230168
2009-09-07 00:00:00 | 219791
2009-10-27 00:00:00 | 238107
2009-08-27 00:00:00 | 222918
2009-08-27 00:00:00 | 222918
2009-08-27 00:00:00 | 222918
2009-10-24 00:00:00 | 237389
2009-10-24 00:00:00 | 237389
2009-10-04 00:00:00 | 232663
2009-10-04 00:00:00 | 232663
2009-10-25 00:00:00 | 232663
2009-10-25 00:00:00 | 232663
2009-10-25 00:00:00 | 232663
2009-10-25 00:00:00 | 232663
2009-10-25 00:00:00 | 232663
2009-10-14 00:00:00 | 200520
2009-10-14 00:00:00 | 200520
2009-08-25 00:00:00 | 222301
2009-08-25 00:00:00 | 222301
2009-08-25 00:00:00 | 222301
2009-08-28 00:00:00 | 222301
2009-09-02 00:00:00 | 222301
2009-09-10 00:00:00 | 211370
2009-09-16 00:00:00 | 211370
2009-10-21 00:00:00 | 211370
2009-09-01 00:00:00 | 224309
2009-09-01 00:00:00 | 224309
2009-10-06 00:00:00 | 233066
2009-10-06 00:00:00 | 233066
2009-10-06 00:00:00 | 233066
2009-10-15 00:00:00 | 233066
2009-10-21 00:00:00 | 236731
2009-10-21 00:00:00 | 236731
2009-09-24 00:00:00 | 173378
2009-10-26 00:00:00 | 238008
2009-10-11 00:00:00 | 234437
2009-10-11 00:00:00 | 234437
2009-10-11 00:00:00 | 234437
2009-10-11 00:00:00 | 234437
Spreadsheet: 188960d1351036698-summing-and-averageing-based-on-criteria-project1a
Sheet: Sheet1

Name | Type | Start Date | Review Date | Completed Date
[NAME] | A | 2012-08-07 00:00:00 | 2012-08-17 00:00:00 | 2012-08-17 00:00:00
[NAME] | A | 2012-08-13 00:00:00 | 2012-08-20 00:00:00 | 2012-09-04 00:00:00
[NAME] | A | 2012-08-15 00:00:00 | 2012-08-21 00:00:00 | 2012-08-21 00:00:00
[NAME] | A | 2012-08-17 00:00:00 | 2012-08-21 00:00:00 | 2012-08-21 00:00:00
[NAME] | B | 2012-08-28 00:00:00 | 2012-08-31 00:00:00 | 2012-08-31 00:00:00
[NAME] | B | 2012-08-30 00:00:00 | 2012-09-05 00:00:00 | 2012-09-05 00:00:00
[NAME] | A | 2012-08-31 00:00:00 | 2012-09-06 00:00:00 | 2012-09-06 00:00:00
[NAME] | B | 2012-08-14 00:00:00 | 2012-08-20 00:00:00 | 2012-08-20 00:00:00
[NAME] | A | 2012-08-27 00:00:00 | 2012-08-29 00:00:00 | 2012-08-29 00:00:00
Name | Type | Start Date | Ave Review Date (Days) | Ave [NAME] (days)
[NAME] | A | 1
[NAME] | A | 1
Name | Type | Start Date | Ave Review Date (Days) | Ave [NAME] (days)
[NAME] | B | 1
[NAME] | B | 1
Spreadsheet: 477619d1472412477-how-to-highlight-multiple-cells-based-off-a-value-fantasy-football
Sheet: LB

RK | Player | Pos | Team | Bye
1 | [NAME] | LB | SF | 8
2 | [NAME] | LB | TB | 6
3 | [NAME] | LB | CAR | 7
4 | [NAME] | DL | OAK | 10
5 | [NAME] | LB | NE | 9
6 | [NAME] | LB | IND | 10
7 | [NAME] | LB | BAL | 8
8 | [NAME] | LB | DEN | 11
9 | A. Ogletree | LB | LAR | 8
10 | [NAME] | LB | SEA | 5
11 | [NAME] | LB | DAL | 7
12 | [NAME] | LB | OAK | 10
13 | [NAME] | LB | KC | 5
14 | [NAME] | LB | JAC | 5
15 | [NAME] | LB | PHI | 4
16 | [NAME] | LB | MIN | 6
17 | [NAME] | LB | PIT | 8
18 | D. Perryman | LB | SD | 11
19 | [NAME] | LB | DET | 10
20 | [NAME] | LB | TEN | 13
21 | [NAME] | LB | MIA | 8
22 | [NAME] | LB | CAR | 7
23 | [NAME] | LB | NO | 5
24 | [NAME] | LB | DEN | 11
25 | [NAME] | LB | CHI | 9
26 | [NAME] | LB | BUF | 10
27 | [NAME] | LB | PIT | 8
28 | [NAME] | LB | LAR | 8
29 | [NAME] | LB | ARZ | 9
30 | [NAME] | LB | JAC | 5
31 | [NAME] | LB | PHI | 4
32 | [NAME] | LB | NYG | 8
33 | [NAME] | LB | TB | 6
34 | [NAME] | LB | CHI | 9
35 | D. Hightower | LB | NE | 9
36 | M. Ingram | LB | SD | 11
37 | [NAME] | LB | CLE | 13
38 | [NAME] | LB | HOU | 9
39 | [NAME] | LB | MIA | 8
40 | [NAME] | LB | MIN | 6
41 | D. Jones | LB | ATL | 11
42 | [NAME] | LB | NO | 5
43 | [NAME] | LB | WAS | 9
44 | R. McClain | LB | DAL | 7
45 | [NAME] | LB | WAS | 9
46 | K. Dansby | LB | CIN | 9
47 | [NAME] | LB | CIN | 9
48 | [NAME] | LB | NYJ | 11
49 | [NAME] | LB | GB | 4
50 | [NAME] | LB | NYJ | 11
51 | M. Te'o | LB | SD | 11
52 | [NAME] | LB | SEA | 5
53 | [NAME] | LB | GB | 4
54 | [NAME] | LB | BUF | 10
55 | [NAME] | LB | ATL | 11
56 | [NAME] | LB | JAC | 5
57 | [NAME] | LB | DET | 10
58 | [NAME] | LB | CLE | 13
59 | [NAME] | LB | CHI | 9
60 | [NAME] | LB | BUF | 10
61 | [NAME] | LB | GB | 4
62 | [NAME] | LB | NYG | 8
63 | T. Suggs | LB | BAL | 8
64 | B. Cushing | LB | HOU | 9
65 | [NAME] | LB | DEN | 11
66 | [NAME] | LB | SF | 8
67 | [NAME] | LB | DEN | 11
68 | [NAME] | LB | BAL | 8
69 | [NAME] | LB | ARZ | 9
70 | [NAME] | LB | HOU | 9
71 | [NAME] | LB | WAS | 9
72 | [NAME] | LB | IND | 10
73 | [NAME] | LB | TEN | 13
74 | [NAME] | LB | KC | 5
75 | [NAME] | LB | CIN | 9
76 | [NAME] | LB | KC | 5
77 | [NAME] | LB | CAR | 7
78 | [NAME] | LB | SD | 11
79 | [NAME] | LB | HOU | 9
80 | [NAME] | LB | PHI | 4
81 | [NAME] | LB | CLE | 13
82 | [NAME] | LB | TEN | 13
83 | [NAME] | LB | TB | 6
84 | [NAME] | LB | OAK | 10
85 | [NAME] | LB | NYG | 8
86 | [NAME] | LB | BAL | 8
87 | [NAME] | LB | DET | 10
88 | B. Orakpo | LB | TEN | 13
89 | [NAME] | LB | BUF | 10
90 | [NAME] | LB | SF | 8
91 | [NAME] | LB | LAR | 8
92 | [NAME] | LB | MIN | 6
93 | B. Dupree | LB | PIT | 8
94 | R. Maualuga | LB | CIN | 9
95 | [NAME] | LB | IND | 10
96 | [NAME] | LB | MIA | 8
97 | [NAME] | LB | DAL | 7
98 | [NAME] | LB | KC | 5
99 | [NAME] | LB | NE | 9