tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9f676762-1a62-42d7-ade7-c2476cbd43b3
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40811419 | 2014-04-02 18:41:42 | ALLIES | 1 | 6 | 3 | 1524695 | [NAME] | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
40877310 | 2014-04-06 23:44:05 | ALLIES | 1 | 10 | 4 | 1341332 | WiffleWaffle | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40877644 | 2014-04-07 00:14:43 | AXIS | 1 | 10 | 6 | 1341332 | WiffleWaffle | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40933795 | 2014-04-10 23:33:47 | ALLIES | 1 | 6 | 5 | 1553386 | lucascrodrigueslcr | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
40934218 | 2014-04-11 00:22:00 | ALLIES | 1 | 6 | 4 | 1551639 | [NAME] | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40934458 | 2014-04-11 00:56:54 | AXIS | 0 | 4 | 6 | 1551639 | [NAME] | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
40961237 | 2014-04-12 22:10:18 | AXIS | 0 | 3 | 4 | 1300844 | radwit | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40961539 | 2014-04-12 22:21:38 | ALLIES | 0 | 1 | 4 | 1300844 | radwit | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
40961786 | 2014-04-12 22:45:48 | ALLIES | 1 | 4 | 2 | 1556331 | General_cousin | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
40962120 | 2014-04-12 23:24:18 | ALLIES | 1 | 6 | 5 | 703766 | Viridovilas | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
40962540 | 2014-04-13 00:04:05 | AXIS | 0 | 0 | 6 | 703766 | Viridovilas | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
40963076 | 2014-04-13 00:23:13 | ALLIES | 1 | 6 | 3 | 780030 | keithdone | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
40963201 | 2014-04-13 00:33:26 | AXIS | 0 | 2 | 6 | 780030 | keithdone | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
41007883 | 2014-04-15 23:38:37 | ALLIES | 0 | 2 | 6 | 8367 | HiveGod | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
41008244 | 2014-04-16 00:06:10 | AXIS | 0 | 5 | 6 | 8367 | HiveGod | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
41008619 | 2014-04-16 00:24:01 | ALLIES | 1 | 6 | 4 | 1545484 | Rommel_Africakorps | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
41008710 | 2014-04-16 00:36:34 | AXIS | 1 | 6 | 4 | 1545484 | Rommel_Africakorps | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
Spreadsheet: thomas_martin__39870__ubs Jan 28
Sheet: East Master List

Name | Position | Reports_To
[NAME] | [NAME] | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Structuring | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Origination | [NAME] | 1
Claudia Guerra | Assistant | [NAME] | 1
[NAME] | Scheduling | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | [NAME] | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Projects | [NAME] | 1
[NAME] | [NAME] | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | [NAME] | [NAME] | 1
Edith Cross | Origination | [NAME] | 1
[NAME] | Structuring | [NAME] | 1
[NAME] | Cash | [NAME] | 1
[NAME] | [NAME] | [NAME] | 1
[NAME] | Cash | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Scheduling | [NAME] | 1
Gulay [NAME] | Fundamentals | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] | Options | [NAME] | 1
[NAME] | V.P. Options | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Options | [NAME] | 1
[NAME] | Scheduling | [NAME] | 1
[NAME] | Cash | [NAME] | 1
[NAME] | Term | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Cash | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Term | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] | V.P. East Trading | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Scheduling | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Dir. Fundamentals & Projects | [NAME] | 1
[NAME] | Structuring | [NAME] | 1
[NAME] | Scheduling | [NAME] | 1
[NAME] | [NAME] | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] Seely | Physical | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Cash | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
Narsima Misra | Cash | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Scheduling | [NAME] | 1
[NAME] | Term | [NAME] | 1
[NAME] | Cash | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Physical | [NAME] | 1
Punit Rawal | Physical | [NAME] | 1
[NAME] | [NAME] | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] | Term | [NAME] | 1
[NAME] | Options | [NAME] | 1
[NAME] | V.P. South East | [NAME] | 1
[NAME] | Term | [NAME] | 1
[NAME] | Fundamentals | [NAME] | 1
[NAME] | Physical | [NAME] | 1
Smith Day | Scheduling | [NAME] | 1
[NAME] | Options | [NAME] | 1
[NAME] | [NAME] | [NAME] | 1
[NAME] | Origination | [NAME] | 1
[NAME] | Origination | [NAME] | 1
TJ Black | Co-ordinator | [NAME] | 1
[NAME] | Physical | [NAME] | 1
[NAME] | Physical | [NAME] | 1
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: VA IRRRL

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
Final Approval |  | True | False | Team Rosa | Final Approval
CD |  | True | False | Team Rosa | CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
Spreadsheet: 839190d1691742456-finding-value-with-2-criteria-attachment
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 2023-08-21 00:00:00
DATE | 2023-08-22 00:00:00 | look to the column of this date |  |  |  | Test 1 | Test 2 | Test 3
Value | 2 | find this value in the selected date |  |  |  | AAA | Abcdef abcdef | NL |  | 4 | 4 | 4 | 4
 |  | show the name in column Test 2 |  |  |  | BBB | bcdefh bebe | BE |  | 1 |  | 1 | 1
 |  |  |  |  |  | CCC | cjcjccj cjcj | NL |  | 2 | 2 | 2 | 2
 |  |  |  |  |  | DDD | ddkk dkkd | D |  | 3 | 3 | 3
 |  |  |  |  |  | EEE | eeelk eek | NL |  | 5 | 5 | 5 | 5
FORMULA RESULT |  |  |  |  |  | FFF | fkjfjf jfkf | BE |  | 6 | 1 |  | 6
 |  |  |  |  |  | GGG | gkgj gjg | NL |  | 7 | 7 | 7 | 7
 |  |  |  |  |  | HHH | hmcc hhc | D |  | 8 | 8 | 8 | 8
Spreadsheet: 890101d1741275313-forecasting-formula-abramsjeremy-excel-forum-example
Sheet: Uses Dates

 |  |  |  |  |  | 2025-01-06 00:00:00 | 2025-01-13 00:00:00 | 2025-01-20 00:00:00 | 2025-01-27 00:00:00 | 2025-02-03 00:00:00 | 2025-02-10 00:00:00 | 2025-02-17 00:00:00 | 2025-02-24 00:00:00 | 2025-03-03 00:00:00
 | Start Date | Finish Date | Hours Available | Duration In Weeks
 | 2025-01-10 00:00:00 | 2025-02-14 00:00:00 | 60 | 5
 | 2025-01-10 00:00:00 | 2025-02-17 00:00:00 | 60 | 5
Spreadsheet: michael_maggi__26471__NYMEXWEEKLYSTATS
Sheet: SC

Week Ending: | 2001-01-14 00:00:00
 | Futures Settlement Prices
 | BRENT CRUDE OIL |  |  |  |  | Contract Symbol:  SC
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-14 00:00:00 | 2001-01-15 00:00:00 | 2001-01-16 00:00:00 | 2001-01-17 00:00:00 | 2001-01-18 00:00:00 | Interest
 | 2002-02-01 00:00:00 | 19.77 | 19.73 | 19.48 | 19.48 | 19.48 | 49
 | 2002-03-01 00:00:00 | 18.97 | 18.97 | 18.98 | 18.42 | 18.45 | 67
 | 2002-04-01 00:00:00 | 19.1 | 19.14 | 19.21 | 19.61 | 18.64 | 10
 | 2002-05-01 00:00:00 | 19.14 | 19.2 | 19.34 | 19.75 | 18.79 | 20
 | 2002-06-01 00:00:00 | 19.14 | 19.21 | 19.37 | 19.79 | 18.83 | 825
 | 2002-07-01 00:00:00 | 19.16 | 19.24 | 19.4 | 19.83 | 18.87 | 98
 | Total Weekly Volume
 |  |  |  |  | Total Open Interest |  | 1069
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historical Volatility-Spot Month Futures
 |  |  |  | Brent Crude Oil
 | 5 Day Hist. Vol. |  |  | N\A
 | 20 Day Hist. Vol. |  |  | N\A
 | Implied Volatility-Options
 |  |  |  | Brent Crude Oil
 | At the Money Call & Put
 |  |  |  | N\A
 | MON | TUE | WED | THUR | FRI | Total
Volume | 75 | 50 | 17 | 0 | 0
Spreadsheet: dcc4b7f0-cf7b-4244-9275-b23ad1c60786
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTIB | Test | FFTIB | Tin, Blood | Tin, Blood | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 2 | mL | Draw blood in a royal blue-top (metal free EDTA) tube.   Send  2 mL metal free EDTA whole blood refrigerated. | 0.2 mL NOTE: Submission of the m | Specimens other than	Whole blood Anticoagulants other than	Royal blue-top EDTA (metal-free) Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Reference Range: <5.0 ng/mL   Toxic range not established.   Test Performed by: Medtox Laboratories, Inc.                                      402 W. County Road D                                      St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc
FFTIB | [NAME] | WBEDTAMF | [NAME] EDTA - Metal Free (ERB) |  |  |  | Refrigerated
FFTIB | Result | Z1202 | Tin | Tin | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 102684d1300663535-grid-reference-conversion-to-latitude-and-longitude-utmconversions1
Sheet: Convert Lat, Long to UTM

 | Symbol | Value |  |  | Degrees | Minutes | Seconds | Decimal | Radians
Datum Constants |  |  |  | Latitude | 42 | 42 | 41.99999999999777 | 42.71166666666667 | 0.7454592123476447
equatorial radius | a | 6378206.4 |  | Longitude | 90 | 5 | 15.99999999998546 | -90.08777777777777 | -1.572328338027203
polar radius | b | 6356583.8 |  | Zone | 15
flattening | f | 0.003390075303928791 |  | Zone CM | -93 |  |  |  | -1.623156204354726
inverse flattening | 1/f | 294.9786982138982 |  |  |  |  |  | Delta-Long | 2.912222222222226
Mean radius | rm | 6367385.921655473
 |  |  |  | Northing | 4732695.278841988
scale factor | k0 | 0.9996 |  | Easting | 738492.4056613747
eccentricity | e | 0.0822718542230039
 | e'2 | 0.006814784945915193
 | n | 0.001697915682976902 |  | Long Ltr0 | 17 | S | Digraph | 23 | Y
r curv 1 | rho | 6364743.764067129 |  | Lat Ltr0 | 1 | A | Digraph | 8 | H
r curv 2 | nu | 6388161.428910286
Calculate Meridional Arc Length
[NAME] | S | 4730474.362417502
 | A0 | 6367399.689169782
 | B0 | 16216.86233998753
 | C0 | 17.20937118099185
 | D0 | 0.02272671026573846
 | E0 | 0.0003268627299192521
Calculation Constants
Delta Long | p (rad) | 0.05082786632752382
Coefficients for UTM Coordinates
 | Ki | 4728582.172672535
 | Kii | 1591311.344990354
 | Kiii | 299337.0761403464
 | Kiv | 4691993.295828422
 | Kv | 63951.41156985646
 | A6 | 0
Spreadsheet: 850619d1701017094-finding-a-figure-from-choice-of-multiple-ranges-each-with-2-metrics-book1-example-v1
Sheet: Sheet1

Type 1 |  |  |  |  |  | Type 2 |  |  |  |  |  | Type 3
 |  | Category: A. Sub-category: w |  |  |  |  |  | Category: B. Sub-category: w |  |  |  |  |  | Category: C. Sub-category: w
 |  | Metric B |  |  |  |  |  | Metric B |  |  |  |  |  | Metric B
 |  | 1.1-2.1 | 2.2-3.1 | 3.2-4.1 |  |  |  | 1.1-2.1 | 2.2-3.1 | 3.2-4.1 |  |  |  | 1.1-2.1 | 2.2-3.1 | 3.2-4.1
Metric A | 0-3 | 0.95 | 0.95 | 0.95 |  | Metric A | 0-3 | 0.95 | 0.95 | 0.95 |  | Metric A | 0-3 | 0.95 | 0.95 | 0.95
 | 4-10 | 0.93 | 0.94 | 0.95 |  |  | 4-10 | 0.93 | 0.94 | 0.95 |  |  | 4-10 | 0.93 | 0.94 | 0.95
 | 11-15 | 0.91 | 0.92 | 0.93 |  |  | 11-15 | 0.91 | 0.92 | 0.93 |  |  | 11-15 | 0.91 | 0.92 | 0.93
 | 16-20 | 0.9 | 0.91 | 0.92 |  |  | 16-20 | 0.9 | 0.91 | 0.92 |  |  | 16-20 | 0.9 | 0.91 | 0.92
 |  | Category: A Sub-category: x |  |  |  |  |  | Category: B. Sub-category: x |  |  |  |  |  | Category: C. Sub-category: x
 |  | Metric B |  |  |  |  |  | Metric B |  |  |  |  |  | Metric B
 |  | 1.1-2.1 | 2.2-3.1 | 3.2-4.1 |  |  |  | 1.1-2.1 | 2.2-3.1 | 3.2-4.1 |  |  |  | 1.1-2.1 | 2.2-3.1 | 3.2-4.1
Metric A | 0-3 | 0.95 | 0.95 | 0.95 |  | Metric A | 0-3 | 0.95 | 0.95 | 0.95 |  | Metric A | 0-3 | 0.95 | 0.95 | 0.95
 | 4-10 | 0.93 | 0.94 | 0.95 |  |  | 4-10 | 0.93 | 0.94 | 0.95 |  |  | 4-10 | 0.93 | 0.94 | 0.95
 | 11-15 | 0.91 | 0.92 | 0.93 |  |  | 11-15 | 0.91 | 0.92 | 0.93 |  |  | 11-15 | 0.91 | 0.92 | 0.93
 | 16-20 | 0.9 | 0.91 | 0.92 |  |  | 16-20 | 0.9 | 0.91 | 0.92 |  |  | 16-20 | 0.9 | 0.91 | 0.92
Spreadsheet: 41660b7d-7bd5-41d6-b85f-46a733ba2c29
Sheet: Sheet1

Unnamed: 0 | Registration $ Amount Due | First Name | Last Name | Degree(MD, PhD, RN, FANP, RN) | Institution/Hospital  Name | Department or Division | Institution PO Box | Institution Mailing Address | City | State/Province | Country | Postal Code | Registrant Email
 | Group Leader
1 | 575
2 | 575
3 | 575
4 | 575
5 | 575
6 | 575
7 | 575
8 | 575
9 | 575
10 | 575
11 | 575
12 | 575
13 | 575
14 | 575
15 | 575
16 | 575
17 | 575
18 | 575
19 | 575
20 | 575
21 | 575
22 | 575
23 | 575
24 | 575
25 | 575
26 | 575
27 | 575
28 | 575
29 | 575
30 | 575
31 | 575
32 | 575
33 | 575
34 | 575
35 | 575
36 | 575
37 | 575
38 | 575
39 | 575
40 | 575
41 | 575
42 | 575
43 | 575
44 | 575
45 | 575
46 | 575
47 | 575
48 | 575
49 | 575
50 | 575
51 | 575
52 | 575
53 | 575
54 | 575
55 | 575
56 | 575
57 | 575
58 | 575
59 | 575
60 | 575
61 | 575
62 | 575
63 | 575
64 | 575
65 | 575
66 | 575
67 | 575
68 | 575
69 | 575
70 | 575
71 | 575
72 | 575
73 | 575
74 | 575
75 | 575
76 | 575
77 | 575
78 | 575
79 | 575
80 | 575
Spreadsheet: 43338d1242005449-is-product-if_product
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
2 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
5 |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1
4 |  |  |  | 1 |  |  |  | 1 |  |  |  | 1
6 |  |  |  |  |  | 1 |  |  |  |  |  | 1
NB: Blank cell = False
Spreadsheet: 236658d1368911847-filter-data-based-on-columns-display-unique-row-data-example2
Sheet: Daily

 | H, [NAME] | Work Order | Commission | Rate Plan
Spreadsheet: 46286d1245186685-defining-names-example-sheet
Sheet: Data

Acct Type | Acct no | Amount
R | 1 | 245
R | 2 | 356
S | 1 | 234
P | 3 | 1234
S | 4 | 3546
P | 2 | 457
P | 2 | 345
P | 1 | 357
S | 4 | 65
S | 1 | 74
R | 4 | 5632
S | 2 | 45
P | 3 | 245
R | 3 | 75
Spreadsheet: 815302d1674855856-error-if-value-in-cell-appeared-already-in-the-last-365-days-please-help-me
Sheet: Sheet1 (3)

Date | [NAME] | False if the person in B appears twice or more in column B and the date is not longer than 12 months ago
2021-11-11 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2021-12-15 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-01-15 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-01-17 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-06-06 00:00:00 | [EMAIL] | False | free code will not be given out as last code was given out within the last 365 days
2022-10-23 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2022-12-14 00:00:00 | [EMAIL] | False | free code will not be given out as last code was given out within the last 365 days
2022-12-24 00:00:00 | [EMAIL] | False | free code will not be given out as last code was given out within the last 365 days
2023-01-19 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out
2023-01-16 00:00:00 | [EMAIL] | True | last attempt has been longer than 365 days => free code will be given out. Employee tried on 24th Dec 22 (row 9) but was rejected; he received code on 15th Jan 22 (row4)
Spreadsheet: 3b0c35b4-b414-482b-9691-fabaa8811fcf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4043 | 8609 | Anel | Radford | RSA | 0 | 00:21:00 | 00:00:14 | 01:09:45 | [NAME] | 00:42:35 | 1 | 02:14:01
4043 | 23632 | Sylvie | Reynaud | MRI | 0 | 00:31:18 | 00:00:44 | 01:11:47 | 00:00:31 | 00:49:30 | 2 | 02:33:54
Spreadsheet: 889084d1739788849-populating-data-in-one-sheet-example-8
Sheet: Sheet2

ID | Full Name | Department | Annual Salary
TS08 | A | Marketing
DL17 | B | Sales
SC19 | C | Sales
HB12 | D | Sales
DM15 | E | Finance
BF09 | F | Finance
CB16 | G | Accounting
BE13 | H | Human Resources
LP09 | I | Finance
GH13 | J | Accounting
AG04 | K | Marketing
Spreadsheet: 47284d1246308764-job-hour-summary-using-daily-pivot-totals-can-it-be-done-weekly-timesheet-summary-7-days-
Sheet: Friday

Friday | 2009-01-16 00:00:00
Job # | Employee | Total Hours
830 |  | 73.5
 | [NAME] | 10.5
 | [NAME] | 10.5
 | [NAME] | 10.5
 | [NAME] | 10.5
 | [NAME] | 10.5
 | Pascual Mateo | 10.5
 | [NAME] | 10.5
870 |  | 15
 | [NAME] | 3.5
 | [NAME] | 3.5
 | Chase Payne | 1.5
 | [NAME] | 1.5
 | [NAME] | 3.5
 | [NAME] | 1.5
885 |  | 10.5
 | [NAME] | 10.5
895 |  | 8
 | [NAME] | 8
1234-5678 |  | 43.5
 | [NAME] | 2.5
 | [NAME] | 4
 | Cecil Elliot | 2.5
 | [NAME] | 2.5
 | [NAME] | 4
 | Chase Payne | 1
 | [NAME] | 1
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 2
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 4
 | [NAME] | 2
 | [NAME] | 2.5
 | [NAME] | 2
 | [NAME] | 1
2356-8967 |  | 40.5
 | [NAME] | 3
 | Cecil Elliot | 3
 | [NAME] | 3
 | Chase Payne | 2.5
 | [NAME] | 2.5
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 2
 | [NAME] | 3
 | [NAME] | 3
 | [NAME] | 2
 | [NAME] | 3
 | [NAME] | 2
 | [NAME] | 2.5
3312-6066 |  | 19.5
 | [NAME] | 3
 | [NAME] | 3
 | Chase Payne | 2.5
 | [NAME] | 2.5
 | [NAME] | 1
 | [NAME] | 3
 | [NAME] | 1
 | [NAME] | 1
 | [NAME] | 2.5
5386-8649 |  | 6
 | [NAME] | 3
 | [NAME] | 3
5547-8888 |  | 7
 | [NAME] | 3.5
 | [NAME] | 3.5
5567-9012 |  | 45
 | [NAME] | 3.5
 | Cecil Elliot | 3.5
 | [NAME] | 3.5
 | Chase Payne | 3.5
 | [NAME] | 3.5
 | [NAME] | 3.5
 | [NAME] | 3.5
 | [NAME] | 3.5
 | [NAME] | 1
 | [NAME] | 3.5
 | [NAME] | 3.5
 | [NAME] | 1
 | [NAME] | 3.5
 | [NAME] | 1
 | [NAME] | 3.5
5649-9016 |  | 5
 | [NAME] | 2.5
 | [NAME] | 2.5
5664-9034 |  | 3
 | [NAME] | 1.5
 | [NAME] | 1.5
5678-8734 |  | 6
 | [NAME] | 2
 | [NAME] | 2
 | [NAME] | 2
870 |  | 7.5
 | [NAME] | 2.5
 | [NAME] | 2.5
 | [NAME] | 2.5
8812-5677 |  | 13.5
 | [NAME] | 1.5
 | Cecil Elliot | 1.5
 | [NAME] | 1.5
 | [NAME] | 1.5
 | [NAME] | 1.5
 | [NAME] | 1.5
 | [NAME] | 1.5
 | [NAME] | 1.5
 | [NAME] | 1.5
5547-3345 |  | 3
 | [NAME] | 3
5547-3347 |  | 2.5
 | [NAME] | 2.5
4999-0987 |  | 3
 | [NAME] | 3
5547-3348 |  | 6.5
 | [NAME] | 5.5
 | [NAME] | 1
5547-3349 |  | 4
 | [NAME] | 4
Grand Total |  | 322.5
Spreadsheet: 101544d1299649933-counts-of-unique-values-with-multiple-criteria-testtree
Sheet: Data

Column a | Column B | Column C | Column D | hc | prog
Tree Sale | 1 | 100 | 2011-03-05 00:00:00 | 1 | 1
[NAME] | 2 | 0 | 2011-03-05 00:00:00 |  | 2
Tree Sale | 3 | 200 | 2011-03-06 00:00:00 | 1 | 3
Tree Sale | 4 | 75 | 2011-03-06 00:00:00 |  | 4
[NAME] | 5 | 80 | 2011-03-08 00:00:00 | 1 | 5
[NAME] | 6 | 0 | 2011-03-08 00:00:00 |  | 6
[NAME] | 7 | 125 | 2011-03-08 00:00:00 |  | 7
[NAME] | 8 | 0 | 2011-03-08 00:00:00 |  | 8
Spreadsheet: 126185d1319560576-finding-latest-available-data-example_latest_date_with_data
Sheet: Sheet 1

Example #1 |  |  |  |  |  |  |  | Example #1
2012-10-01 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-01 00:00:00 | 0
2012-10-02 00:00:00 | 0 |  | Latest Date with Data: |  |  | 94 |  | 2012-10-02 00:00:00 | 0 |  | Latest Date with Data: |  |  | 176
2012-10-03 00:00:00 | 148 |  |  |  |  |  |  | 2012-10-03 00:00:00 | 148
2012-10-04 00:00:00 | 99 |  |  |  |  |  |  | 2012-10-04 00:00:00 | 99
2012-10-05 00:00:00 | 236 |  |  |  |  |  |  | 2012-10-05 00:00:00 | 236
2012-10-06 00:00:00 | 64 |  |  |  |  |  |  | 2012-10-06 00:00:00 | 64
2012-10-07 00:00:00 | 53 |  |  |  |  |  |  | 2012-10-07 00:00:00 | 53
2012-10-08 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-08 00:00:00 | 0
2012-10-09 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-09 00:00:00 | 0
2012-10-10 00:00:00 | 107 |  |  |  |  |  |  | 2012-10-10 00:00:00 | 107
2012-10-11 00:00:00 | 142 |  |  |  |  |  |  | 2012-10-11 00:00:00 | 142
2012-10-12 00:00:00 | 176 |  |  |  |  |  |  | 2012-10-12 00:00:00 | 176
2012-10-13 00:00:00 | 102 |  |  |  |  |  |  | 2012-10-13 00:00:00 | 102
2012-10-14 00:00:00 | 137 |  |  |  |  |  |  | 2012-10-14 00:00:00 | 137
2012-10-15 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-15 00:00:00 | 0
2012-10-16 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-16 00:00:00 | 0
2012-10-17 00:00:00 | 170 |  |  |  |  |  |  | 2012-10-17 00:00:00 | 170
2012-10-18 00:00:00 | 73 |  |  |  |  |  |  | 2012-10-18 00:00:00 | 73
2012-10-19 00:00:00 | 202 |  |  |  |  |  |  | 2012-10-19 00:00:00 | 202
2012-10-20 00:00:00 | 116 |  |  |  |  |  |  | 2012-10-20 00:00:00 | 116
2012-10-21 00:00:00 | 94 |  |  |  |  |  |  | 2012-10-21 00:00:00 | 94
2012-10-22 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-22 00:00:00 | 0
2012-10-23 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-23 00:00:00 | 0
2012-10-24 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-24 00:00:00 | 94
2012-10-25 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-25 00:00:00 | 107
2012-10-26 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-26 00:00:00 | 142
2012-10-27 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-27 00:00:00 | 176
2012-10-28 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-28 00:00:00 | 0
2012-10-29 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-29 00:00:00 | 0
2012-10-30 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-30 00:00:00 | 0
2012-10-31 00:00:00 | 0 |  |  |  |  |  |  | 2012-10-31 00:00:00 | 0
Spreadsheet: 42311d1240912356-matrix-help-book1
Sheet: Sheet1

 |  |  |  | Rare | Unlikely | Possible | Likely | Almost | Certain
 |  |  |  | Major | MEDIUM | MEDIUM | HIGH | HIGH | HIGH
 |  |  |  | Very Serious | LOW | MEDIUM | HIGH | HIGH | HIGH
 |  |  |  | Serious | LOW | MEDIUM | HIGH | HIGH | HIGH
 |  |  |  | Significant | LOW | LOW | MEDIUM | MEDIUM | MEDIUM
 |  |  |  | Slight | LOW | LOW | LOW | LOW | MEDIUM
 |  |  |  | No Impact | LOW | LOW | LOW | LOW | LOW
Serious | Almost | HIGH
Spreadsheet: 682822d1592340618-removing-rows-that-do-not-meet-a-condition-to-avoid-duplication-sample
Sheet: Sheet1

A | B
2020-04-05 00:00:00 | 5
2020-04-06 00:00:00 | 5
2020-04-10 00:00:00 | 5
2020-04-10 00:00:00 | 8
2020-04-10 00:00:00 | 9
2020-04-13 00:00:00 | 9
2020-04-10 00:00:00 | 12
2020-04-10 00:00:00 | 12
2020-04-10 00:00:00 | 9
2020-04-10 00:00:00 | 3