tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 875954d1722587420-help-with-overtime-formula-overtime-example-jt
Sheet: Mon-Thurs 9.15 hr-day 49 hr Wk 

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours in | Overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2024-09-16 00:00:00 | Monday | 09:00:00 | 00:30:00 | 18:00:00
2024-09-17 00:00:00 | Tuesday | 09:00:00 | 00:30:00 | 18:00:00
2024-09-18 00:00:00 | Wednesday | 09:00:00 | 00:30:00 | 18:00:00
2024-09-19 00:00:00 | Thursday | 09:00:00 | 00:30:00 | 18:00:00 |  |  |  |  |  | Mon-Thurs 9.15 hr-day 49 hr Wk
2024-09-20 00:00:00 | Friday | 09:00:00 | 00:30:00 | 17:00:00
2024-09-21 00:00:00 | Saturday
2024-09-22 00:00:00 | Sunday
2024-09-23 00:00:00 | Monday
2024-09-24 00:00:00 | Tuesday
2024-09-25 00:00:00 | Wednesday
2024-09-26 00:00:00 | Thursday
2024-09-27 00:00:00 | Friday
2024-09-28 00:00:00 | Saturday
2024-09-29 00:00:00 | Sunday
2024-09-30 00:00:00 | Monday
2024-10-01 00:00:00 | Tuesday
2024-10-02 00:00:00 | Wednesday
2024-10-03 00:00:00 | Thursday
2024-10-04 00:00:00 | Friday
2024-10-05 00:00:00 | Saturday
2024-10-06 00:00:00 | Sunday
Spreadsheet: 753025d1635187248-move-start-of-week-to-new-tab-week-example-pr1
Sheet: July

 | Week
 | 1
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 2 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 3 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 4 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
 | Week
 | 5 | commencing date:
 |  | day | date
 |  | Sunday
 |  | Monday
 |  | Tuesday
 |  | Wednesday
 |  | Thursday
 |  | Friday
 |  | Saturday
Spreadsheet: 298702d1392877491-totals-items-per-unqiue-id-countif-2
Sheet: Sheet1

Unique ID
11111 | Basketball
11111 | Basketball
11111 | Basketball
33333 | Baseball
33333 | Baseball
22222 | Hockey
44444 | Basketball |  |  |  |  | Unique ID Total
44444 | Basketball |  |  |  | Basketball | 2
44444 | Basketball |  |  |  | Baseball | 4
44444 | Basketball |  |  |  | Hockey | 3
44444 | Basketball
55555 | Baseball
55555 | Baseball
55555 | Baseball
66666 | Baseball
66666 | Baseball
77777 | Baseball
77777 | Baseball
77777 | Baseball
77777 | Baseball
88888 | Hockey
88888 | Hockey
88888 | Hockey
99999 | Hockey
Spreadsheet: 386bf1fb-a854-440d-a141-b50d630060e7
Sheet: Sheet1

Table ST11 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | E12 | E14 | E16 | E18 | P0 | P2 | P4 | P6 | P10 | Adult
IRBP | 0.007017543859649123 | 0 | 0.007017543859649123 | 0.007017543859649123 | 0.07719298245614035 | 0.06315789473684211 | 0.08421052631578947 | 0.1298245614035088 | 0.1754385964912281 | 0.4491228070175439
RGPRIP | 0.008658008658008658 | 0 | 0.02164502164502164 | 0.02597402597402598 | 0.02597402597402598 | 0.09956709956709957 | 0.1904761904761905 | 0.1948051948051948 | 0.3506493506493507 | 0.08225108225108226
[NAME] | 0.01194029850746269 | 0.005970149253731343 | 0.01492537313432836 | 0.03880597014925373 | 0.01791044776119403 | 0.05373134328358209 | 0.1552238805970149 | 0.2776119402985074 | 0.2865671641791045 | 0.1373134328358209
Unc119h | 0 | 0.005917159763313609 | 0.01479289940828402 | 0.005917159763313609 | 0.04733727810650887 | 0.02662721893491124 | 0.0650887573964497 | 0.1420118343195266 | 0.07396449704142012 | 0.6183431952662722
PDE gamma | 0 | 0 | 0.002076843198338525 | 0.002076843198338525 | 0.002076843198338525 | 0.009345794392523364 | 0.02907580477673936 | 0.1318795430944964 | 0.3655244029075805 | 0.4579439252336449
Arrestin | 0 | 0 | 0.002289377289377289 | 0.001831501831501832 | 0.00641025641025641 | 0.0119047619047619 | 0.03708791208791209 | 0.1268315018315018 | 0.5238095238095238 | 0.2898351648351649
Rhodopsin | 0 | 0.001548586914440573 | 0.0007742934572202865 | 0 | 0.002322880371660859 | 0 | 0.002322880371660859 | 0.02129307007355788 | 0.232288037166086 | 0.7394502516453736
GCAP1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1209677419354839 | 0.8790322580645161
G alpha 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.106280193236715 | 0.893719806763285
Spreadsheet: 97714d1296825211-lookup-formula-cell-not-showing-correct-value-transfers
Sheet: transfer sheet

 | MANAGER [NAME]: |  | TEAM NAME:
 | PLAYERS OUT
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL OUT | 0
 | PLAYERS IN
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL IN | 0
 | MANAGER [NAME]: |  | TEAM NAME:
 | PLAYERS OUT
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL OUT | 0
 | PLAYERS IN
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL IN | 0
 | MANAGER [NAME]: |  | TEAM NAME:
 | PLAYERS OUT
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL OUT | 0
 | PLAYERS IN
 | NUMBER | NAME | TEAM | VALUE
 |  |  | TOTAL IN | 0
Spreadsheet: 98120d1297172695-macro-creates-new-sheet-with-data-from-other-sheets-customer-order
Sheet: Oranges

 | ORANGES
Variety | Quantity | [NAME] | List Price 2010 | List Price 2011 | Customer Discount | Comments
Navel | 20 | 2011-12-31 00:00:00 | 0.36 | 0.4 | 0.05 | Common
Blood | 16 | 2011-12-31 00:00:00 | 0.35 | 0.46 | 0.05 | Delicious
[NAME] | 5 | 2011-12-31 00:00:00 | 0.45 | 0.5 | 0.04 | Pulpy
Fukuhara | 150 | 2011-12-31 00:00:00 | 0.75 | 0.84 | 0.12 | Japanese
Spreadsheet: 85851d1285869388-insert-variables-from-two-cells-in-a-formula-sample
Sheet: September

September |  |  | DATE
No. | NAME, SURNAME |  | 2010-09-01 00:00:00
1 | Name1 | Surname1
2 | [NAME] | Surname2
3 | Name3 | Surname3
4 | Name4 | Surname4
5 | Name5 | Surname5
Spreadsheet: 160314d1339043570-vlookup-with-multiple-criteria-lookup
Sheet: Sheet1

Date | ID | Qty | Price |  |  |  |  | Qty | 2 |  | Def Price | 100
2011-07-22 00:00:00 | 1013 | 25 | 24.12
2012-01-31 00:00:00 | 1013 | 2 | 32.5 |  |  |  |  | ID | Price
2012-01-31 00:00:00 | 850 | 2 | 45 |  |  |  |  | 1013 | 32.5
2012-01-31 00:00:00 | 1013 | 9 | 37.5 |  |  |  |  | 850 | 100
2012-05-21 00:00:00 | 869 | 2 | 3.42 |  |  |  |  | 869 | 3.42
2012-05-21 00:00:00 | 877 | 25 | 0.008666666666666666 |  |  |  |  | 877 | 100
2012-05-21 00:00:00 | 888 | 765 | 0.0131 |  |  |  |  | 888 | 1.3
2011-07-22 00:00:00 | 1013 | 25 | 16.31
2012-05-21 00:00:00 | 888 | 1 | 1.3
2011-10-01 00:00:00 | 1013 | 1 | 37.5
 |  |  |  |  |  |  |  | 888 |  | Gets the first instance with correct ID without regard for date or qty
 |  |  |  |  |  |  |  | 888 |  | gets the [NAME] date for the id without checking qty
Spreadsheet: 04fee099-db87-43b9-b904-3c29cc294be2
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 6.352401214422152 | 11.08516273346781 | 1.389349072135323
13-14 | 43.71942732247128 | 72.8603581484169 | 13.11548119344196
15 | 40.50948296092286 | 68.5765602529703 | 10.93223965333339
16 | 30.46238696934488 | 51.85034511552185 | 7.783031746936182
17 | 25.517909278252 | 45.29451503826485 | 4.463549185610574
18 | 21.29928258911339 | 37.53348852670731 | 4.230729949998238
19 | 16.5266786804043 | 29.27233469026417 | 3.235412305732149
20 | 13.38909367680322 | 23.6939616478932 | 2.6325828536488
21 | 11.89898093895801 | 21.00180375032244 | 2.398469035351363
22 | 10.71271976318731 | 17.75993378372085 | 3.421517626289319
23 | 9.579820183298185 | 16.51486048762422 | 2.431740654994388
24 | 8.496972222315168 | 14.4505652762329 | 2.386076846150304
25-29 | 8.010499237411421 | 13.07107436484025 | 2.912469375402405
30-34 | 7.801287928538081 | 12.2666875123133 | 3.360453995777874
35-39 | 6.140820015154312 | 9.745322879684728 | 2.576037415584668
40-44 | 4.485125437510423 | 7.248329433785709 | 1.78761934544252
45-49 | 2.71140719734275 | 4.35141638445868 | 1.13047671136363
50-54 | 2.369854264402659 | 4.094577580310246 | 0.7379477844287102
55-59 | 1.434914485716632 | 2.261891932181746 | 0.6729669330785775
60-64 | 0.930891918375526 | 1.757303660755646 | 0.1998619010278229
65 and over | 0.3717180491789008 | 0.7716817929227103 | 0.09903301295862144
Spreadsheet: 118927d1314102073-excel-2007-printing-subtotalled-data-to-an-excel-file-commission-test
Sheet: Sheet1

SALES AND COMMISSION REPORT
Rep Name | Customer # | Customer Name | Sales | Charges | Net | Rate | Commission
[NAME] | 105100 | ABC COMPANY | 2500 | -100 |  | 5
[NAME] | 105100 | ABC COMPANY | 3500 | -255 |  | 5
[NAME] | 105100 | ABC COMPANY | 4500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1000 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 2500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 2500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 5000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 8000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1800 | -100 |  | 5
[NAME] | 105100 | ABC COMPANY | 2500 | -100 |  | 5
[NAME] | 105100 | ABC COMPANY | 3500 | -255 |  | 5
[NAME] | 105100 | ABC COMPANY | 4500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1000 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 2500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 2500 | -100 |  | 5
[NAME]
[NAME] | 105100 | ABC COMPANY | 2500 | -100 |  | 5
[NAME] | 105100 | ABC COMPANY | 3500 | -255 |  | 5
[NAME] | 105100 | ABC COMPANY | 4500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1000 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 2500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 2500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 5000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 8000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1800 | -100 |  | 5
JOE SMITH Total
[NAME] | 105300 | GHI COMPANY | 5000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 8000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1800 | -100 |  | 5
[NAME] | 105100 | ABC COMPANY | 2500 | -100 |  | 5
[NAME] | 105100 | ABC COMPANY | 3500 | -255 |  | 5
[NAME] | 105100 | ABC COMPANY | 4500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1500 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 1000 | -100 |  | 5
[NAME] | 105200 | DEF COMPANY | 2500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 2500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 5000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 8000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1500 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1000 | -100 |  | 5
[NAME] | 105300 | GHI COMPANY | 1800 | -100 |  | 5
MARY WHITE Total
Grand Total
Spreadsheet: 472660d1469700663-count-of-employees-absent-on-a-particular-date-employee-attendance-tracker-2
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | Employee 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2011
 |  |  |  |  |  |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  | KEY STATISTICS
 |  |  | Days on Leave |  |  |  |  |  |  |  | Working Days |  |  |  |  |  |  |  | # of Days Sick |  |  |  |  |  |  | on Vacation |  |  |  |  |  |  |  | on Bereavement |  |  |  |  |  |  |  |  | on Other
 |  | January
 |  | February
 |  | March
 |  | April
 |  | May
 |  | June
 |  | July
 |  | August
 |  | September
 |  | October
 |  | November
 |  | December
Spreadsheet: 143474d1330438075-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (11) Bar Finish

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | Bar Finish
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
x | outlet needs cover (exposed wires) | TB men's bathroom near mandoor | complete
x | front guarding needs repair | 103 straightner | carryover
x | fan needs strain relief (two ends) (green tag #20890) | 124 [NAME] | carryover
x | repair or replace e-box labeled Met Lab | [NAME] right of column #7 BAY1 | complete
x | hydraulic leaks, oil on floor | band saws | carryover
x | e-box labeled BF Bay 2/3 LP5 is missing a handle | Column 13 behind the 109 str. BAYII | complete
x | fix leaks on 90 saw | BLDG 52 SAW 90 | carryover
x | replace label on e-box BF52 E-LP9 | BLDG 52 on west wall
x | air line cord wheel broken | YUKON cord wheel for bander | carryover
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - housekeeping okay
ESCORT:
Spreadsheet: 755296d1636759469-retrieve-data-from-string-of-text-retrievedata
Sheet: Sheet1

Raw Data | Result (retrieve values with underscore) | Result (retrieve first date in string, if any) | Result (retrieve second date in string, if any) | Result (value that starts with "ABCD")
Raja 20211113_83378 complete his project of 23/10/2021 by 25/10/2021 | 20211113_83378 | 2021-10-23 00:00:00 | 2021-10-25 00:00:00 | NA
[NAME] has 81918191 by 21/10/2021 of 26/11/2021 | NA | 2021-10-21 00:00:00 | 2021-11-26 00:00:00 | NA
[NAME] has ABCD-1212-14444-4444 of 88110011 by 24/11/2021 | NA | 2021-11-24 00:00:00 | NA | ABCD-1212-14444-4444
[NAME] has 2029221_2291 by 28/10/2021 | 2029221_2291 | 2021-10-28 00:00:00 | NA | NA
[NAME] wants ABCD-111-222-991 of 25/10/2021 | NA | 2021-10-25 00:00:00 | NA | ABCD-111-222-991
Spreadsheet: 298661d1392857344-totals-items-per-unqiue-id-countif
Sheet: Sheet1

11111 | Basketball
11111 | Basketball
11111 | Basketball
33333 | Baseball
33333 | Baseball
22222 | Hockey
Spreadsheet: 144986d1331237095-excel-2007-data-sheet-date-auto-population-test-test-test
Sheet: 2nd idea

January
2012-01-01 00:00:00
2012-01-02 00:00:00
2012-01-03 00:00:00
2012-01-04 00:00:00
2012-01-05 00:00:00
2012-01-06 00:00:00
2012-01-07 00:00:00
2012-01-08 00:00:00
2012-01-09 00:00:00
2012-01-10 00:00:00
2012-01-11 00:00:00
2012-01-12 00:00:00
2012-01-13 00:00:00
2012-01-14 00:00:00
2012-01-15 00:00:00
2012-01-16 00:00:00
2012-01-17 00:00:00
2012-01-18 00:00:00
2012-01-19 00:00:00
2012-01-20 00:00:00
2012-01-21 00:00:00
2012-01-22 00:00:00
2012-01-23 00:00:00
2012-01-24 00:00:00
2012-01-25 00:00:00
2012-01-26 00:00:00
2012-01-27 00:00:00
2012-01-28 00:00:00
2012-01-29 00:00:00
2012-01-30 00:00:00
2012-01-31 00:00:00
Spreadsheet: 83253d1283269852-creating-parent-id-from-id-based-on-level-number-sampledata
Sheet: Sheet1

ID | NAME | LEVEL |  | PARENT ID
1 | OFS | 0 |  | 0
11 | Viewable Navigation | 1 |  | 1
12 | Decor | 2 |  | 11
13 | Window Treatments | 3 |  | 12
14 | Drapery Fabric | 4 |  | 13
15 | Designer [NAME] | 5 |  | 14
16 | [NAME] | 6 |  | 15
17 | [NAME] | 6 |  | 15
18 | [NAME] | 6 |  | 15
19 | [NAME] | 6 |  | 15
20 | Golding Fabrics | 6 |  | 15
21 | Kravet Fabric | 6 |  | 15
22 | [NAME] | 6 |  | 15
23 | [NAME] | 6 |  | 15
24 | Richloom Fabric | 6 |  | 15
25 | [NAME] | 6 |  | 15
26 | Sunbrella Fabrics | 6 |  | 15
27 | Swavelle/ [NAME] | 6 |  | 15
28 | [NAME] | 6 |  | 15
29 | Waverly Fabric | 6 |  | 15
30 | Drapery [NAME] | 5 |  | 14
31 | Armure | 6 |  | 30
32 | [NAME] | 6 |  | 30
33 | Basket Weave Fabrics | 6 |  | 30
34 | Monks Cloth | 7 |  | 33
35 | Hopsack | 7 |  | 33
36 | Bengaline | 6 |  | 30
37 | Boucle | 6 |  | 30
38 | Broadcloth | 6 |  | 30
39 | [NAME] | 6 |  | 30
40 | Chenille | 6 |  | 30
41 | [NAME] | 6 |  | 30
42 | Chintz, [NAME], Polished Cotton | 6 |  | 30
43 | Chintz | 7 |  | 42
44 | [NAME] | 7 |  | 42
45 | Polished Cotton | 7 |  | 42
46 | Cloque | 6 |  | 30
47 | Corduroy | 6 |  | 30
48 | [NAME] | 7 |  | 47
49 | Bannigan Corduroy | 8 |  | 48
50 | Beaverteen Corduroy | 8 |  | 48
Spreadsheet: 584478d1533211912-matching-3-data-and-getting-result-in-f-column-which-is-a-running-balance-test-match-2-
Sheet: Sheet1

 |  | Data 1 | Data 2 | Data 3 | Data 4 | Data 5
 |  | XL0123 | ABC | 35000 |  | 4500
 |  | AB1261 | DWKING | 45600 |  | 25000
 |  | XL0123 | ABC | 35000 |  | 15800 |  | Matching should be done for Data 1,Data2 & Data 3
 |  | AB1261 | DWKING | 45600 |  | 20600
 |  | XL0123 | ABC | 35000 |  | 14700
Added |  | XL0123 | NBC | 4800 |  | 3000
Added |  | XL0123 | ABC | 15000 |  | 4500
Spreadsheet: daren_farmer__6258__Hou Rockets-TX
Sheet: Sheet1

HOUSTON ROCKETS SCHEDULE
TEXAS DESK
2000 – 2001
Date | Opponent
2000-11-02 00:00:00 | Milwaukee | [NAME]
2000-12-02 00:00:00 | Portland | [NAME]
2000-12-05 00:00:00 | Dallas | Elsa / Stacey
2000-12-23 00:00:00 | Golden State (2 tickets) | [NAME]
2001-01-16 00:00:00 | Toronto | Danny / Elsa
2001-01-30 00:00:00 | Miami | Lauri / Ed
2001-02-05 00:00:00 | New York | Carey / Lee
2001-02-13 00:00:00 | Washington | [NAME]
2001-02-20 00:00:00 | Boston | Lauri / Janet
2001-03-15 00:00:00 | New Jersey | Lee / Ed
2001-03-17 00:00:00 | San Antonio | Stacey / Lauri
2001-03-29 00:00:00 | Phoenix | Danny / Elsa
2001-04-07 00:00:00 | Atlanta | Daren / [NAME]
2001-04-17 00:00:00 | Minnesota | Stacey / Janet
Spreadsheet: kevin_ruscitti__20285__Michigan_Flows
Sheet: Flows

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999-09-01 00:00:00 | 1999-08-01 00:00:00 | 1999-07-01 00:00:00
 | Michigan
Capacity |  | MichCon: | Pipelines | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00
300000 |  |  | Great Lakes | 198916 | 28137 | -26769 | -46625 | -10713 | -10713 | 23225 | 72167 | 112677 | 145842 | 280251
155000 |  |  | Panhandle | 118141 | 177200 | 76615 | 24137 | 15222 | 86468 | 138999 |  | 166418 | 144405 | 131774
435000 |  |  | ANR - Willow Run | 116759 | 394119 | 159599 | 111079 | 190487 | 233158 | 303736 | 200074 | 339301 | 202361 | 266964
250000 |  |  | Union - St. Clair |  | -133130 | -88012 | -92593 | -96004 | -115479 | -7460 | -4373 | -7177 | -2363 | 12970
300000 |  |  | ANR - Columbus |  | -46308 | -59451 | -50500 | -54411 | -60498 | -14999 | -8709 | -2554 | 0 | 0
 |  |  | Transport Flows:
 |  |  | Basis to MichCon:
 |  |  | POINT | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00
 |  |  | ANR-SE | -0.148 | -0.152 | -0.051 | 0.004 | -0.098 | -0.159 | -0.207 | -0.19 | -0.186 | -0.181 | -0.222
 |  |  | ANR-OK | -0.182 | -0.205 | -0.089 | -0.071 | -0.177 | -0.176 | -0.269 | -0.292 | -0.263 | -0.211 | -0.245
 |  |  | PEPL | -0.177 | -0.211 | -0.089 | -0.083 | -0.199 | -0.178 | -0.269 | -0.296 | -0.267 | -0.219 | -0.252
 |  |  | Dawn | 0.05300000000000001 | 0.043 | 0.081 | 0.086 | 0.087 | 0.075 | 0.007000000000000006 | -0.004000000000000004 | -0.013 | -0.03 | -0.04899999999999999
 |  |  | ML7 | 0.03599999999999999 | 0.02799999999999998 | 0.093 | 0.141 | 0.06 | 0.019 | 0.01900000000000002 | 0.016 | 0.035 | 0.04100000000000001 | 0.01900000000000002
Spreadsheet: 748109d1631891686-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 6

 |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  |  | 2021-09-09 00:00:00 |  |  |  | 78072
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
P.O. Number |  |  | Terms |  | Rep |  | Ship |  | Via |  | F.O.B. |  |  | Project
PN31022 |  |  | 2%10NET45 |  | HOUSE |  | 2021-09-09 00:00:00 |  | UPS |  | Richmond, VA
Quantity |  | Item Code |  | Description |  |  |  |  |  |  |  | Price Each |  |  |  | Amount
1 |  | 451729 |  | HSG, BRG, ECC SHAFT, CTR BOX-VARI |  |  |  |  |  |  |  | 303 |  |  |  | 303
 |  |  |  |  |  |  |  |  |  |  |  | Total                              $303.00
Payments/Credits                 $0.00 |  |  |  |  |  |  |  | Balance Due |  |  |  |  |  |  | 303
Spreadsheet: 149797d1334147398-solved-lookup-value-against-column-heading-and-value-in-intesecting-row-book1
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | FTE | Manually Enetered End Date | Check
 |  |  | 1 | 3 | 5 | 1 | 10 | Q4 | Q4
 |  |  | 0 | 1 | 1 | 0 | 2 | Q2 | Q3
Spreadsheet: 679250d1590281923-matrix-formula-for-8-numbers-last-delay-and-longest-drawn-lottery_again
Sheet: Planilha2

ball1 | ball2 | [NAME] | ball4 | ball5 | [NAME] | ball7 | ball8 | repeated quantity (8x) | Current Lottery | [NAME] (8x) | Average | Last Delay | Longest delay
1 | 2 | 3 | 10 | 11 | 13 | 18 | 20
2 | 4 | 6 | 17 | 18 | 23 | 24 | 25
1 | 2 | 4 | 5 | 8 | 11 | 23 | 24
1 | 2 | 6 | 12 | 15 | 18 | 24 | 25
2 | 3 | 4 | 10 | 14 | 20 | 21 | 23
2 | 8 | 10 | 11 | 20 | 23 | 24 | 25
3 | 4 | 13 | 15 | 19 | 22 | 24 | 25
1 | 3 | 5 | 8 | 10 | 11 | 23 | 24
1 | 11 | 13 | 15 | 17 | 23 | 24 | 25
2 | 3 | 6 | 9 | 20 | 21 | 23 | 25
2 | 4 | 6 | 12 | 17 | 23 | 24 | 25
2 | 4 | 6 | 13 | 18 | 23 | 24 | 25
2 | 6 | 9 | 13 | 14 | 20 | 23 | 25
3 | 4 | 5 | 10 | 15 | 19 | 24 | 25
3 | 4 | 11 | 13 | 14 | 15 | 22 | 24
3 | 4 | 11 | 13 | 15 | 19 | 21 | 24
3 | 6 | 12 | 14 | 15 | 22 | 24 | 25
4 | 9 | 10 | 12 | 15 | 19 | 23 | 24
5 | 8 | 10 | 11 | 20 | 23 | 24 | 25
Spreadsheet: 546440d1510055809-need-help-on-formula-weekly-numbers
Sheet: Report

Service | A001 |  |  | Criteria 1
Curr.WK | 45 |  |  | [NAME]
WK | Vessel | PK
42 | A001G
43 | A001H
44 | A001I
45 | A001J
If I select B4 as 45, then should show previous 3 Week number in A7,A8 & A9 and corresponding vessel name in B7,B8 & B9 related to Service B3
Spreadsheet: 97903d1297013569-find-highest-number-only-if-two-names-matched-in-columns-tabletennisstats
Sheet: OVERALL STATS

 | Liverpool Table Tennis League (LiTTLe)
 | LATEST RESULTS
 |  |  |  |  |  | vs |  | vs |  | vs |  | vs
 | PLAYER | GP | W | L | PCT | W | L | W | L | W | L | W | L |  |  |  |  | `
 | [NAME] |  |  |  |  | --- | ---
 | [NAME] |  |  |  |  |  |  | --- | ---
 | Sheldon |  |  |  |  |  |  |  |  | --- | ---
 | Al |  |  |  |  |  |  |  |  |  |  | --- | ---
 | OVERALL STANDINGS
 | PLAYER | GP | W | L | PCT | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT | HIGH SCORE | LOW SCORE | BEST MGN | WORST MGN
 | [NAME]
 | [NAME]
 | Sheldon
 | Al
 | HEAD-TO-HEAD STATS
 |  | VS:
 | PLAYER | GP | W | L | PCT | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Al
 | Sheldon
 | [NAME]
 |  | VS:
 | PLAYER | GP | W | L | PCT | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Al
 | Sheldon
 | [NAME]
 |  | VS:
 | PLAYER | GP | W | L | PCT. | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Al
 | [NAME]
 | [NAME]
 |  | VS:
 | PLAYER | GP | W | L | PCT. | PF | PA | PTS DIFF | TOT PTS | PFPG | PPG IN LOSS | % OF GMS OT | OT W | OT L | WIN% IN OT
 | Sheldon
 | [NAME]
 | [NAME]
 | "This ain't ping pong--it's table tennis."