tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 716642d1612292746-if-date-sunday-then-highlight-monday-timesheet-template-sample-
Sheet: Timesheet Worksheet

 |  |  | Year | 2021 | 2022 |  | Days Formula - Begin June 11
 |  |  |  |  |  |  | 2021-06-11 00:00:00
TIME LIST | LUNCH
 |  |  | Heading |  |  |  |  |  | Year | Date | Holidays | When
06:00:00 |  |  | SCHOOL 1 |  |  |  |  |  |  |  | Independence Day | 2020-07-04 00:00:00
06:05:00 |  |  | SCHOOL 2 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
06:10:00 |  |  | SCHOOL 3 |  |  |  |  |  |  |  | Veteran's Day | 2020-11-11 00:00:00
06:15:00 |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
06:20:00 |  |  |  |  |  |  |  |  |  |  | Thanksgiving Holiday | The 4th Friday in November
06:25:00 |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2020-12-25 00:00:00
06:30:00
06:35:00 |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2020-01-01 00:00:00
06:40:00 |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
06:45:00 |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
06:50:00 |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
06:55:00
07:00:00
07:05:00
07:10:00
07:15:00
07:20:00
07:25:00
07:30:00
07:35:00
07:40:00
07:45:00
07:50:00
07:55:00
08:00:00
08:05:00
08:10:00
08:15:00
08:20:00
08:25:00
08:30:00
08:35:00
08:40:00
08:45:00
08:50:00
08:55:00
09:00:00
09:05:00
09:10:00
09:15:00
09:20:00
09:25:00
09:30:00
09:35:00
09:40:00
09:45:00
09:50:00
09:55:00
10:00:00
10:05:00
10:10:00
10:15:00
10:20:00
10:25:00
10:30:00
10:35:00
10:40:00
10:45:00
10:50:00
10:55:00
11:00:00
11:05:00
11:10:00
11:15:00
11:20:00
11:25:00
11:30:00
11:35:00
11:40:00
11:45:00
11:50:00
11:55:00
12:00:00
12:05:00
12:10:00
12:15:00
12:20:00
12:25:00
12:30:00
12:35:00
12:40:00
12:45:00
12:50:00
12:55:00
13:00:00
13:05:00
13:10:00
13:15:00
13:20:00
13:25:00
13:30:00
13:35:00
13:40:00
13:45:00
13:50:00
13:55:00
14:00:00
14:05:00
14:10:00
14:15:00
14:20:00
14:25:00
14:30:00
14:35:00
14:40:00
14:45:00
14:50:00
14:55:00
15:00:00
15:05:00
15:10:00
15:15:00
15:20:00
15:25:00
15:30:00
15:35:00
15:40:00
15:45:00
15:50:00
15:55:00
16:00:00
16:05:00
16:10:00
16:15:00
16:20:00
16:25:00
16:30:00
16:35:00
16:40:00
16:45:00
16:50:00
16:55:00
17:00:00
17:05:00
17:10:00
17:15:00
17:20:00
17:25:00
17:30:00
17:35:00
17:40:00
17:45:00
17:50:00
17:55:00
18:00:00
18:05:00
18:10:00
18:15:00
18:20:00
18:25:00
18:30:00
18:35:00
18:40:00
18:45:00
18:50:00
18:55:00
19:00:00
19:05:00
19:10:00
19:15:00
19:20:00
19:25:00
19:30:00
19:35:00
19:40:00
19:45:00
19:50:00
19:55:00
20:00:00
Spreadsheet: 697879d1601580638-counting-occurrences-and-sums-based-on-an-id-sample2
Sheet: Sheet5

ID: | Field1 | Field2 | Field3 | Aggregated Count: | Number of:
1155626 | Audit | A | 50 | 74 | 1
1155626 | Interim | A | 83 | 74 | 1
1155626 | Final | A | 96849 | 74 | 1
1155626 | Final | A | 96849 | 74 | 1
1155626 | Audit | A | 50 | 74 | 1
1155626 | Audit | A | 50 | 74 | 1
1155626 | Interim | B | 74 | 74 | 1
1155626 | Final | A | 586543 | 74 | 1
1155626 | Final | A | 586543 | 74 | 1
1155626 | Audit | C | 50 | 74 | 1
1158662 | Interim | B | 5 | 25 | 4
1158662 | Interim | A | 5 | 25 | 4
1158662 | Final | D | 33325 | 25 | 4
1158662 | Interim | B | 5 | 25 | 4
1158662 | Final | F | 0 | 25 | 4
1158662 | Interim | B | 5 | 25 | 4
1158662 | Interim | B | 10 | 25 | 4
1158662 | Interim | A | 5 | 25 | 2
12493 | Interim | B |  |  | 2
12493 | Interim | A | 5 |  | 2
12493 | Final | D | 33325 |  | 2
12493 | Interim | B |  |  | 2
9393 | Final | B | 3202 |  | 0
9393 | Final | A | 5 |  | 0
9393 | Final | D | 33325 |  | 0
9393 | Final | B | 20023 |  | 0
8393 | Interim | B | 50000 | 50000 | 1
8393 | Interim | C | 100000 | 50000 | 1
8393 | Final | D | 20000 | 50000 | 1
8393 | Final | B | 20000 | 50000 | 1
Spreadsheet: 167247d1341933384-data-validation-dependent-on-other-validation-pipe-calculations
Sheet: Pipe Sizes

*Characteristics of Steel - Size, Outside Diameter, Wall Thickness, & Area Reduced for Manufacturing*
Nominal Pipe Size (in) | Outside Diameter (in) | Nominal Wall Thickness (in)† |  |  |  | Reduced for Manufacturing 12.5%* |  |  |  | Area (in²)
 |  | Sch. 40 | Sch. 80 | Sch. 160 | [NAME] | Sch. 40 | Sch. 80 | Sch. 160 | [NAME] | Sch. 40 | Sch. 80 | Sch. 160 | [NAME]
0.125 | 0.405 | 0.068 | 0.095 | - | - |  |  | - | - |  |  | - | -
0.25 | 0.54 | 0.088 | 0.119 | - | - |  |  | - | - |  |  | - | -
0.375 | 0.675 | 0.091 | 0.126 | - | - |  |  | - | - |  |  | - | -
0.5 | 0.84 | 0.109 | 0.147 | 0.188 | 0.294
0.75 | 1.05 | 0.113 | 0.154 | 0.219 | 0.308
1 | 1.315 | 0.133 | 0.179 | 0.25 | 0.358
1.25 | 1.66 | 0.14 | 0.191 | 0.25 | 0.382
1.5 | 1.9 | 0.145 | 0.2 | 0.281 | 0.4
2 | 2.375 | 0.154 | 0.218 | 0.334 | 0.436
2.5 | 2.875 | 0.203 | 0.276 | 0.275 | 0.552
3 | 3.5 | 0.216 | 0.3 | 0.438 | 0.6
3.5 | 4 | 0.226 | 0.318 | - | - |  |  | - | - |  |  | - | -
4 | 4.5 | 0.237 | 0.337 | 0.531 | 0.674
5 | 5.563 | 0.258 | 0.375 | 0.625 | 0.75
†Nominal Wall Thickness values are taken from the ABS Rules for Building and Classifying Steel Vessels: Part-4 Chapter-6 Section-2: Table 8 (pg 392).
*Reduced for Manufacturing value is taken as the percentage negative manufacturing tolerance (12.5%).
Spreadsheet: 814997d1674682243-first-number-greater-than-zero-pasta2
Sheet: Planilha3 (2)

 |  |  |  |  |  |  |  |  | 0.95 |  | 15000
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15065.26 | I wish this was the result
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 11a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | - | 537 | 537
Cross-Currency Fixed-Fixed | - | 51 | 51
Cross-Currency Fixed-Float | - | 55 | 55
TOTAL | - | 643 | 643
Spreadsheet: 159527d1338733004-need-help-with-calculations-derived-from-pivot-data-zenricobook2_solution
Sheet: Sheet1

Phase of the Project | 1 | 2 | Project No | Project ID | For Period Ending | For Period Starting |  | Project ID | For Period Ending | For Period Starting | Difference
4. Execute |  |  | 237152 | ES10159 | 2012-02-02 00:00:00 | 2012-01-26 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-02-09 00:00:00 | 2012-02-03 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-02-16 00:00:00 | 2012-02-10 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-02-23 00:00:00 | 2012-02-17 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-01 00:00:00 | 2012-02-24 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-15 00:00:00 | 2012-03-02 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-22 00:00:00 | 2012-03-16 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-03-29 00:00:00 | 2012-03-23 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-04-05 00:00:00 | 2012-03-30 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-04-19 00:00:00 | 2012-04-06 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-04-26 00:00:00 | 2012-04-20 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
4. Execute |  |  | 237152 | ES10159 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-19 00:00:00 | 2012-04-13 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-16 00:00:00 | 2012-02-10 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-23 00:00:00 | 2012-02-17 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-05 00:00:00 | 2012-03-29 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-01 00:00:00 | 2012-02-24 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-02 00:00:00 | 2012-01-26 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-01 00:00:00 | 2012-02-24 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-05-03 00:00:00 | 2012-04-27 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-22 00:00:00 | 2012-03-15 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-09 00:00:00 | 2012-02-03 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-02-09 00:00:00 | 2012-02-03 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-26 00:00:00 | 2012-04-20 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-29 00:00:00 | 2012-03-22 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-03-15 00:00:00 | 2012-03-08 00:00:00
2. Initiate |  |  | 356422 | ES12037 | 2012-04-12 00:00:00 | 2012-04-06 00:00:00
Spreadsheet: d66e6005-8c99-40ab-b203-6212d35e8bde
Sheet: Sheet1

Unnamed: 0 | BELKNAP COUNTY OFFICES - Republican | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
2002-09-10 00:00:00 | Sheriff |  | Attorney |  | Treasurer |  | Reg. Of Deeds
 | Collis, r | [NAME] | [NAME], r | [NAME] | Corbin, r | [NAME] | Normandin, r | [NAME]
Alton | 800 | 1 | 779 | 1 | 774 | 1 | 794
Barnstead | 477 |  | 471 |  | 469 |  | 479
Belmont | 688 | 1 | 675 | 1 | 675 | 1 | 709
Center Harbor | 235 |  | 229 |  | 226 |  | 232
Gilford | 1257 | 2 | 1187 | 2 | 1158 |  | 1210
Gilmanton | 463 | 1 | 437 | 2 | 443 |  | 451
[NAME] | 549 |  | 526 |  | 515 | 1 | 546
[NAME] | 318 | 1 | 300 | 4 | 296 | 1 | 317 | 1
[NAME] 3 | 341 |  | 326 | 3 | 325 | 1 | 337
[NAME] | 290 | 1 | 271 | 4 | 278 | 3 | 294 | 1
[NAME] | 209 | 2 | 198 | 1 | 201 | 1 | 206 | 2
[NAME] 6 | 342 | 2 | 322 | 7 | 332 |  | 338
Meredith | 1071 | 1 | 1014 |  | 998 |  | 1033
New Hampton | 271 | 2 | 261 | 1 | 264 |  | 266
Sanbornton | 377 | 1 | 363 | 4 | 359 | 1 | 377
[NAME] | 338 |  | 327 | 1 | 323 | 1 | 336
TOTALS | 8026 | 15 | 7686 | 31 | 7636 | 11 | 7925 | 4
 |  |  |  | COUNTY COMMISSIONERS
 | Reg. Of Probate |  |  | District No. 1 |  |  | District No. 2 |  |  | District No. 3
 | Dearborn | [NAME] |  | Daigneault, r | [NAME] |  | Thurston, r | [NAME]
Alton | 781 |  |  |  |  |  |  |  |  | No Election
Barnstead | 470 |  |  |  |  |  | 463
Belmont | 699 |  |  |  |  |  | 666 | 2
Center Harbor | 225
Gilford | 1168
Gilmanton | 445 |  |  |  |  |  | 436
[NAME] | 528 |  |  | 519 | 1
[NAME] | 311 |  |  | 297 | 4
[NAME] 3 | 333 |  |  | 316
[NAME] | 284 | 1 |  | 279 | 2
[NAME] | 202 |  |  | 204 | 1
[NAME] 6 | 335 |  |  | 320 | 1
Meredith | 1024
New Hampton | 268
Sanbornton | 364 |  |  |  |  |  | 368 | 1
[NAME] | 332 |  |  |  |  |  | 330 | 2
TOTALS | 7769 | 1 |  | 1935 | 9 |  | 2263 | 5
Spreadsheet: 823164d1679773355-retrieving-value-from-adjacent-table-based-on-value-within-table-eflookup
Sheet: Sheet1

Airline | To | Sched. |  | Airline | To | To2 | First Flight | Last Flight
American Airlines | Doha | 11:00:00 |  | American Airlines
American Airlines | [NAME] | 11:10:00
American Airlines | Miami, FL | 11:15:00
American Airlines | Indianapolis, IN | 11:15:00 |  |  | Doha | West Palm Beach, FL
American Airlines | London | 11:20:00
American Airlines | Columbus, OH | 12:00:00
American Airlines | Cleveland, OH | 12:00:00
American Airlines | Boston, MA | 12:05:00 |  |  | 11:20 AM
American Airlines | Worcester, [NAME] | 12:10:00
American Airlines | Boston, MA | 12:10:00
American Airlines | Norfolk, VA | 12:20:00
American Airlines | Jacksonville, FL | 12:20:00
American Airlines | Salt Lake City, UT | 12:27:00
American Airlines | Orlando, FL | 12:30:00
American Airlines | Miami, FL | 12:37:00
American Airlines | West Palm Beach, FL | 12:40:00
American Airlines | [NAME] | 12:41:00
American Airlines | Boston, MA | 13:05:00
American Airlines | Orlando, FL | 13:14:00
American Airlines | Boston, MA | 13:20:00
American Airlines | Tampa, FL | 13:28:00
American Airlines | Syracuse, NY | 13:30:00
American Airlines | San Francisco, CA | 13:30:00
American Airlines | Miami, FL | 13:40:00
American Airlines | Atlanta, GA | 13:40:00
American Airlines | Burlington, VT | 13:44:00
American Airlines | Buffalo, NY | 13:44:00
American Airlines | San Antonio, TX | 13:45:00
American Airlines | Tokyo | 13:45:00
American Airlines | Phoenix, AZ | 13:55:00
American Airlines | West Palm Beach, FL | 14:00:00
Spreadsheet: 868237d1714985056-tier-incentive-will-be-automatically-calculated-based-on-tier-hani-calculation-
Sheet: Dr. Nawara Al Arfaj

 |  |  | Total Revenue
 |  |  | Consumables
 |  |  | Hospital Fees -
 |  |  | The Clinics OR Fees
 |  |  | Dr. [NAME]
 |  |  | Lab Revenue | 0
 |  |  | Lab 10%
 |  |  | Net Payment
 |  |  | Service | Amount | OHE | % | Comm. % | Comm.
 |  |  | Consultation |  | 0.05 |  | 0.5
 |  |  | Referral |  | 0.05 |  | 0.1
 |  |  | Procedure |  | 0.05 |  | 0.45
 |  |  | OR In the Clinics |  | 0.05 |  | 0.5
 |  |  | OR Outside the Clinics |  | 0.05 |  | 0.55
 |  |  | Other Exp.
 |  |  | Marketing (50-50) | 0
 |  |  |  |  | Doctor [NAME] ……………
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 461MM

461MM
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-11-02 00:00:00 |  |  | JAD | N/A | N/A | N/A | N/A |  | 2010-06-23 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
DEEMER |  | 2010-09-08 00:00:00 |  | THIS ACCOUNT HAS CAT B AUTHORIZATIONS; THESE ASSETS ARE MAINTAINED IN BASE STOCK. NO AM427G INVENTORY COUNT SHEET IS REQUIRED. THE SIGNED RESULTS LETTER FULFILLS THE REQUIREMENT FOR A QUARTERLY INVENTORY.
GENERAL ACCOUNT INFORMATION / NOTES
THIS ACCOUNT HAS NO ON HAND ASSETS BUT HAS CAT B AUTHORIZATIONS. A QUARTERLY ACCOUNT REVIEW MFR PACKAGE IS EMAILED TO CUSTODIAN EVERY QUARTER.
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 172164d1344010022-split-a-line-of-words-each-word-in-a-separate-cell-example-modified-by-tigeravatar-
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
!BERLIN, !LONDON, !MADRID, !PARIS, !ROME, !ATHENS
!UK, !FRANCE, !GERMANY, ![NAME], !SPAIN
!ONE, !TWO, !THREE, !FOUR
Spreadsheet: 792802d1661175469-xlookup-concatenated-lookup-inexact-date-match-formula-help-ans
Sheet: Sheet1

 | This is what's currently happening
 |  | Date | ID | Payment |  |  | Date | ID | Payment | [NAME] | FORMULA
 |  | 2022-07-07 00:00:00 | 3323 | 500 |  |  | 2022-07-08 00:00:00 | 3323 | 500
 |  | 2022-07-07 00:00:00 | 3323 | 100
 |  | 2022-07-21 00:00:00 | 3417 | 3000 |  |  |  |  |  | XLOOKUP($H$5&$I$5&$J$5,C5:C9&D5:D9&E5:E9,E5:E9,"***Value Not Found***")
 |  | 2022-07-11 00:00:00 | 3537 | 1895
 |  | 2022-07-11 00:00:00 | 3765 | 495.84
 | This is what I'd like for the formula to return if the Date is an inexact match up to 4 Days
 |  | Date | ID | Payment |  |  | Date | ID | Payment | [NAME]
 |  | 2022-07-07 00:00:00 | 3323 | 500 |  |  | 2022-07-08 00:00:00 | 3323 | 500 | 500
 |  | 2022-07-07 00:00:00 | 3323 | 100
 |  | 2022-07-21 00:00:00 | 3417 | 3000
 |  | 2022-07-11 00:00:00 | 3537 | 1895
 |  | 2022-07-11 00:00:00 | 3765 | 495.84
Spreadsheet: 121944d1316521251-how-to-use-excel-to-link-specific-condo-bedroom-types-to-individual-transactions-property-20excel-1-
Sheet: Sheet1

 |  | Before
 |  | Project Name | Unit No. | Bedroom Type
 |  | Condo A | #01-03 |  |  |  |  | Condo A | #01-01 | 1 Bedroom |  |  |  | Condo A
 |  | Condo A | #01-02 |  |  |  |  |  | #01-03 | 2 Bedroom |  |  |  | #01-01 | #01-03 | #02-03 | #03-03
 |  | Condo A | #01-01 |  |  |  |  |  | #02-03 | 3 Bedroom |  |  |  | #01-02
 |  | Condo A | #02-03 |  |  |  |  |  | #03-03 | Penthouse |  |  |  | 1 Bedroom | 2 Bedroom | 3 Bedroom | Penthouse
 |  | Condo A | #03-03 |  |  |  |  |  | #01-02 | 1 Bedroom
 |  | Condo B | #01-02 |  |  |  |  | Condo B | #01-02 | Studio |  |  |  | Condo B
 |  | Condo B | #02-04 |  |  |  |  |  | #02-04 | 2 Bedroom |  |  |  | Studio | 2 Bedroom | 4 Bedroom | Penthouse
 |  | Condo B | #01-03 |  |  |  |  |  | #01-04 | 4 Bedroom |  |  |  | #01-02 | #02-04 | #01-04 | #03-02
 |  | Condo B | #03-02 |  |  |  |  |  | #03-02 | Penthouse |  |  |  |  |  | #01-03
 |  | Condo B | #01-04 |  |  |  |  |  | #01-03 | 4 Bedroom
 |  | Condo C | #01-03 |  |  |  |  | Condo C | #03-03 | 1 Bedroom |  |  |  | Condo C
 |  | Condo C | #03-03 |  |  |  |  |  | #01-03 | 3 Bedroom |  |  |  | 1 Bedroom | 3 Bedroom | 4 Bedroom | Penthouse
 |  | Condo C | #01-01 |  |  |  |  |  | #01-01 | 4 Bedroom |  |  |  | #03-03 | #01-03 | #01-01 | #01-02
 |  | Condo C | #01-02 |  |  |  |  |  | #01-02 | Penthouse |  |  |  |  | #01-04
 |  | Condo C | #01-04 |  |  |  |  |  | #01-04 | 3 Bedroom
 |  | After
 |  | Project Name | Unit No. | Bedroom Type
 |  | Condo A | #01-03 | 2 Bedroom
 |  | Condo A | #01-02 | 1 Bedroom
 |  | Condo A | #01-01 | 1 Bedroom
 |  | Condo A | #02-03 | 3 Bedroom
 |  | Condo A | #03-03 | Penthouse
 |  | Condo B | #01-02 | Studio
 |  | Condo B | #02-04 | 2 Bedroom
 |  | Condo B | #01-03 | 4 Bedroom
 |  | Condo B | #03-02 | Penthouse
 |  | Condo B | #01-04 | 4 Bedroom
 |  | Condo C | #01-03 | 3 Bedroom
 |  | Condo C | #03-03 | 1 Bedroom
 |  | Condo C | #01-01 | 4 Bedroom
 |  | Condo C | #01-02 | Penthouse
 |  | Condo C | #01-04 | 3 Bedroom
Spreadsheet: 272623d1382448170-simple-morgage-finance-repayment-formula-simple-mortgage
Sheet: Sheet1

Selling Price | 1500000 | <--Enter Selling Price
Down Payment | 0.15 | <--Enter Down Payment Percentage
Mortgage |  | Calculated
Interest Rate | 0.055 | <--Enter interest rate
Mnthly Standard Pmt |  | Calculated
Additional Mnthly Pmt | 250 | <--Enter Additional Payment, If none enter zero
Years to Finance | 25 | <--Enter years to finance
First Pmt Date | 2014-01-01 00:00:00 | <--Enter first payment date using first day of a month
Date | Balance | Payment | Interest | Principle | Additional Principle | Ending Balance
Spreadsheet: 59532d1260073149-league-spreadsheet-709588-league-spreadsheet
Sheet: Preview

Week | 4 | preview |  |  |  |  |  | data entry | enter week number in B1
 |  |  |  |  |  |  |  |  | set up pairing blocks for each pairing and enter the pairing number in the pink cell
number of pairings |  | 3 |  |  |  |  |  |  | all else is calculated.
 |  |  |  |  |  |  |  |  | Don't know what to do with handicap, please check back.
team # | team name | team members | Avg score | [NAME] | rank in team | Handicap | VS | team # | team name | team members | Avg score | [NAME] | rank in team | Handicap
Pairing # | 1
3 | yellow | [NAME] | 239 | 18.33333333333333 | 3 | ? |  | 6 | orange | oliver | 300 | 55 | 1 | ?
 |  | erin | 266.6666666666667 | 23.33333333333333 | 1 | ? |  |  |  | [NAME] | 214 | 10 | 3 | ?
 |  | elwood | 252.3333333333333 | 28.33333333333333 | 2 | ? |  |  |  | otto | 254 | 20 | 2 | ?
Pairing # | 2
4 | green | gary | 278.3333333333333 | 35.33333333333334 | 1 | ? |  | 2 | red | [NAME] | 278.3333333333333 | 33 | 2 | ?
 |  | grendel | 263.6666666666667 | 29.66666666666667 | 2 | ? |  |  |  | ron | 255 | 30 | 3 | ?
 |  | greg | 245.6666666666667 | 34 | 3 | ? |  |  |  | ray | 300 | 52.33333333333334 | 1 | ?
Pairing # | 3
5 | purple | [NAME] | 289 | 44 | 1 | ? |  | 3 | yellow | [NAME] | 239 | 18.33333333333333 | 3 | ?
 |  | pete | 271 | 39 | 2 | ? |  |  |  | erin | 266.6666666666667 | 23.33333333333333 | 1 | ?
 |  | [NAME] | 260 | 35 | 3 | ? |  |  |  | elwood | 252.3333333333333 | 28.33333333333333 | 2 | ?
Standings
Blue | 3
red | 2
yellow | 2
green | 0
purple | 0
orange | 1
Spreadsheet: 120608d1315406034-compare-dates-using-2-conditions-book1
Sheet: Sheet1

ID | Date | Type | Test
1 | 2010-01-31 00:00:00 | A
1 | 2012-02-01 00:00:00 | I
1 | 2011-12-31 00:00:00 | A
1 | 2011-12-31 00:00:00 | C | Yes
2 | 2010-12-31 00:00:00 | I
2 | 2012-02-28 00:00:00 | C | Yes
3 | 2011-03-31 00:00:00 | I
3 | 2011-11-30 00:00:00 | A
3 | 2011-11-30 00:00:00 | C | Yes
4 | 2011-04-30 00:00:00 | I
4 | 2011-09-30 00:00:00 | C | Yes
5 | 2011-03-31 00:00:00 | I
5 | 2012-08-31 00:00:00 | C | Yes
6 | 2011-04-30 00:00:00 | I
6 | 2011-10-31 00:00:00 | C | Yes
7 | 2011-12-31 00:00:00
7 | 2011-12-31 00:00:00 | A
7 | 2011-12-31 00:00:00 | A
7 | 2011-12-31 00:00:00 | A
7 | 2011-12-31 00:00:00 | C | No
8 | 2011-03-31 00:00:00
8 | 2011-05-31 00:00:00 | A
8 | 2011-05-31 00:00:00 | C | Yes
Spreadsheet: 53100d1253024935-dropdown-table-example-9
Sheet: Reference sheet

 | Product no | Product | customer 1 | customer 2 | customer 3 | customer 4 |  |  |  | customer 1
 | 1799 | product 1 | 9.10016998248248 | 9.052554879879878 | 10.16149629727865 | 10.12248256240272 |  |  |  | customer 2
 | 356703 | product 2 | 7.968753684210526 | 7.927058526315789 | 8.898126212137129 | 8.86396302132577 |  |  |  | customer 3
 | 356707 | product 3 | 7.968753684210526 | 7.927058526315789 | 8.898126212137129 | 8.86396302132577 |  |  |  | customer 4
 | 356710 | product 4 | 8.184125405405407 | 8.141303351351352 | 9.138616109762458 | 9.103529589469712
 | 548286 | product 5 | 9.418326948051947 | 9.369047142857141 | 10.5167589829 | 10.47638126344713
Spreadsheet: ac7fcd5b-8eca-419d-b290-ffe9922bab20
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
261237 | 39201 | Fabian | Villanueva | MEX | 24 | 00:30:10 | 00:00:32 | 00:58:06 | 00:00:26 | 00:14:15 | 1 | 01:43:29
261237 | 44538 | [NAME] | Cordova | MEX | 21 | 00:30:09 | 00:00:30 | 00:58:09 | 00:00:27 | 00:14:15 | 2 | 01:43:30
261237 | 53155 | Edgar | Espinoza | MEX | 22 | 00:30:09 | 00:00:29 | 00:58:10 | 00:00:29 | 00:14:37 | 3 | 01:43:54
261237 | 32522 | [NAME] | Guete | COL | 25 | 00:30:10 | 00:00:30 | 00:59:52 | 00:00:32 | 00:15:09 | 4 | 01:46:13
261237 | 78779 | [NAME] | [NAME] | VEN | 23 | 00:30:18 | 00:00:34 | 01:02:08 | 00:00:34 | 00:16:02 | 5 | 01:49:36
Spreadsheet: 688190d1595609597-using-index-to-find-matches-across-multiple-worksheets-with-multiple-matches-test1
Sheet: Sheet1

Name | Var1 | Var2 | VAR4-1 | VAR4-2 | VAR4-3
[NAME] | green | Up
[NAME] | blue | Down
[NAME] | purple | Left
[NAME] | Pink | Right
Spreadsheet: 756540d1637620230-retrieve-hours-worked-based-on-day-of-week-in-rota-gamersheek-rota
Sheet: June

` | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU
 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-19 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU
 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-19 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00
[NAME]
Scott
Adam