tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871684d1718107326-unique-sum-with-multiple-criteria-tests
Sheet: Result

 |  | Ref New |  | [NAME] |  | Whatsapp Note
 |  | Quantity | Value | Quantity | Value | Value
 | [NAME]
 | Scented Adhesive Powder
 | Scented & Adhesive Clay
 | [NAME]
 | Freight
 | [NAME]
 | Desten & Biber
 | [NAME]
 | Grand Total
Spreadsheet: 828127d1683233139-dynamically-unpivot-without-power-query-with-merge-columns-and-rows-dynamically-unpivot-without-power-query-including-custom-headers
Sheet: Sheet1

Week | Target | All Products |  | Apple |  |  |  | Target | Product | Count Type | Actual
 |  | Cumulative | Week | Cumulative | Week |  | Week 1 | 75 | All Products | Cumulative | 72.4
Week 1 | 75 | 72.4 | 81.4 | 72.4 | 81.4 |  | Week 1 | 75 | All Products | Week | 81.4
Week 2 | 80 | 72.5 | 77 | 72.5 | 77 |  | Week 1 | 75 | Apple | Cumulative | 72.4
Week 3 | 85 | 72.9 | 79 | 72.9 | 79 |  | Week 1 | 75 | Apple | Week | 81.4
 |  |  |  |  |  |  | Week 2 | 80 | All Products | Cumulative | 72.5
 |  |  |  |  |  |  | Week 2 | 80 | All Products | Week | 77
 | Merge row/column |  |  |  |  |  | Week 2 | 80 | Apple | Cumulative | 72.5
 |  |  |  |  |  |  | Week 2 | 80 | Apple | Week | 77
 |  |  |  |  |  |  | Week 3 | 85 | All Products | Cumulative | 72.9
 |  |  |  |  |  |  | Week 3 | 85 | All Products | Week | 79
 |  |  |  |  |  |  | Week 3 | 85 | Apple | Cumulative | 72.9
 |  |  |  |  |  |  | Week 3 | 85 | Apple | Week | 79
Spreadsheet: 62857d1263858952-count-total-based-on-condition-problem1
Sheet: Complaints

Ref # | Begin Date | Reported Advisor | Organisation | Complainant | Open/Closed | Finish Date | Time Spent (days)
1 | 2008-11-03 00:00:00 | [NAME] | AB Group | [NAME] | Open
2 | 2008-11-05 00:00:00 | [NAME] | AB Group | [NAME] | Closed | 2008-12-16 00:00:00 | 41
3 | 2008-11-29 00:00:00 | [NAME] | AB Group | [NAME] | Closed | 2009-01-05 00:00:00 | 37
4 | 2008-12-12 00:00:00 | [NAME] | AB Group | [NAME] | Open
5 | 2009-01-01 00:00:00 | [NAME] | AB Group | [NAME] | Open
6 | 2009-01-12 00:00:00 | [NAME] | AB Group | [NAME] | Closed | 2009-07-17 00:00:00 | 186
7 | 2009-01-15 00:00:00 | [NAME] | AB Group | [NAME] | Closed | 2009-08-20 00:00:00 | 217
8 | 2009-02-26 00:00:00 | [NAME] | AB Group | [NAME] | Closed | 2009-10-17 00:00:00 | 233
9 | 2009-02-27 00:00:00 | [NAME] | AB Group | [NAME] | Open
10 | 2009-03-01 00:00:00 | [NAME] | AB Group | [NAME] | Closed | 2009-08-15 00:00:00 | 167
Spreadsheet: 810132d1671560677-combine-data-in-2-rows-into-1-single-row-bbl_data_2-rows-merge
Sheet: Output

 | Team Name |  | Result |  | PREPLAY_LAST_TRADED_PRICE |  | PREPLAY_MIN_PRICE |  | PREPLAY_MAX_PRICE |  | INPLAY_MIN_PRICE |  | INPLAY_MAX_PRICE
Date | T1 | T2 | T1 result | T2 result | P_LTP T1 | P_LTP T2 | P_MIN T1 | P_MIN T2 | P_MAX T1 | P_MAX T2 | I_MIN T1 | I_MIN T2 | I_MAX T1 | I_MAX T2
2015-12-17 00:00:00 | [NAME] | [NAME] | W | L | 1.88 | 2.14 | 1.85 | 1.51 | 2.5 | 2.16 | 1.01 | 1.72 | 2.4 | 1000
Spreadsheet: 40636d1239036027-dividing-numbers-evenly-testing
Sheet: Forecast

LOB | Product | Consoldiated Products | WGT | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00
[NAME] PRIVATE BANKING | SEGREGATED INVESTMENT MANAGEMENT |  | 1 | 80 | 68 | 90 | 51 | 58 | 81 | 83 | 56 | 57 | 70 | 63 | 110 | 91 | 50 | 79 | 68 | 74 | 63 | 83 | 90 | 92 | 95 | 56 | 78 | 63 | 64 | 47 | 32
[NAME] PRIVATE BANKING | PRIVATE PORTFOLIO INVESTMENT MANAGEMENT |  | 1 | 287 | 264 | 295 | 344 | 293 | 238 | 298 | 275 | 251 | 239 | 190 | 295 | 310 | 219 | 276 | 397 | 263 | 222 | 278 | 288 | 301 | 277 | 218 | 207 | 136 | 131 | 134 | 182
[NAME] PRIVATE BANKING | ESTATE ADMINISTRATION |  | 1 | 5 | 3 | 5 | 4 | 4 | 4 | 1 | 3 | 5 | 7 | 7 | 4 | 5 | 2 | 3 | 4 | 0 | 2 | 7 | 3 | 6 | 8 | 5 | 4 | 7 | 5 | 6 | 0
[NAME] PRIVATE BANKING | TRUST ADMINISTRATION |  | 1 | 5 | 6 | 10 | 8 | 7 | 10 | 2 | 4 | 7 | 7 | 5 | 4 | 4 | 12 | 6 | 22 | 10 | 8 | 1 | 5 | 3 | 9 | 8 | 5 | 1 | 11 | 3 | 5
[NAME] PRIVATE BANKING | INVESTMENT ADMINISTRATION |  | 1 | 9 | 9 | 2 | 13 | 7 | 9 | 5 | 5 | 7 | 8 | 9 | 13 | 10 | 5 | 13 | 5 | 5 | 13 | 7 | 25 | 22 | 11 | 13 | 18 | 5 | 8 | 15 | 13
Spare
Spare
Spare
Spare
Spare
Spare
Spare
Spare
 |  | TOTAL WGT VOL |  | 386 | 350 | 402 | 420 | 369 | 342 | 389 | 343 | 327 | 331 | 274 | 426 | 420 | 288 | 377 | 496 | 352 | 308 | 376 | 411 | 424 | 400 | 300 | 312 | 212 | 219 | 205 | 232 | 164 | 152 | 185 | 220 | 227 | 214 | 160 | 165
Spreadsheet: 888763d1739344142-sum-lookups-across-multiple-tabs-using-dynamic-formulas-demand-planning
Sheet: Lookups

 | Finishes |  | Status |  | System |  | Access |  | ASM Lead |  | High-Low-rise |  | Insulation |  | Thickness |  | New Build/Retrofit |  | Fund
 | TC15 |  | Tender |  | EWI |  | None |  |  |  | High-rise |  | None |  | TBC |  | New Build |  | Unfunded
 | Silkolitt+ |  | [NAME] |  | Direct Fix |  | Scaffolding |  |  |  | Low-rise |  | Mineral Wool |  | 30[NAME] |  | Retrofit |  | BSF
 | [NAME] |  | Installer on Site |  | Exicco |  | Mast Climbers |  |  |  |  |  | EPS |  | 40mm |  |  |  | SHDF
 | [NAME] |  | Verbal Order |  | Aricco |  |  |  |  |  |  |  | Phenolic |  | 50mm |  |  |  | ECO
 | Dash |  | PO Received |  | Solo |  |  |  |  |  |  |  |  |  | 60mm |  |  |  | HEEPS
 | Mineral TC |  | EWI Supply Started |  |  |  |  |  |  |  |  |  |  |  | 70mm |  |  |  | HUG
 | Brickrend |  | Delayed |  |  |  |  |  |  |  |  |  |  |  | 80mm |  |  |  | City Leap/Ameresco
 |  |  | Completed |  |  |  |  |  |  |  |  |  |  |  | 90mm |  |  |  | LAD
 |  |  | Lost |  |  |  |  |  |  |  |  |  |  |  | 100mm |  |  |  | NIHE LAD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110mm |  |  |  | PSDS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120mm |  |  |  | Other
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 190mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 220mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 230mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240mm
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 250mm
Spreadsheet: 860185d1708384371-time-interval-extraction-time
Sheet: Sheet1

12:08:22
12:08:50
12:08:51 |  |  |  |  |  | 00:00:30
12:09:11
12:09:13
12:09:35
12:09:37
12:10:38
12:11:06
12:11:27
12:11:30
12:11:51
12:11:57
12:12:19
12:12:29
12:14:02
12:14:06
12:17:52
12:17:56
12:18:41
12:18:45
12:19:12
12:19:14
12:20:14
12:20:17
12:20:36
12:20:38
12:20:56
12:21:02
12:21:03
12:21:26
12:21:28
12:21:46
12:21:48
12:22:08
12:22:10
12:22:26
12:22:28
12:23:03
12:23:07
12:23:23
12:23:27
12:38:12
12:38:14
12:38:43
12:38:45
12:39:05
12:39:07
12:39:25
12:39:27
12:39:50
12:39:51
12:40:12
12:40:14
12:40:43
12:40:45
12:41:37
12:41:39
12:42:00
12:42:02
12:42:19
12:42:21
12:42:32
12:42:34
12:42:49
12:42:51
12:43:05
12:43:07
12:43:55
12:43:59
12:45:23
12:45:26
12:45:48
12:45:54
12:46:24
12:46:26
12:46:41
12:46:43
12:47:05
12:47:07
12:47:47
12:47:49
12:47:56
12:48:28
12:48:36
12:48:50
12:48:54
12:49:23
12:49:25
12:49:47
12:49:49
12:50:31
12:50:38
12:54:46
12:54:48
12:55:05
12:55:07
12:55:22
12:55:24
12:55:40
12:55:43
12:56:08
12:56:12
13:06:38
13:06:44
13:09:55
13:10:03
13:10:12
13:10:17
13:10:32
13:10:35
13:10:48
13:10:51
Spreadsheet: 130572d1322471336-calculate-difference-between-two-dates-in-days-months-and-year-book12
Sheet: Sheet1

SI No | Name of the Client | Contract start date | contract end date | Contract Period
1 | abc | 2011-07-13 00:00:00 | 2011-07-30 00:00:00 | 17 Days
2 | def | 2011-07-18 00:00:00 | 2011-08-17 00:00:00 | 1 Month
3 | ghi | 2011-09-13 00:00:00 | 2011-11-15 00:00:00 | 2 Month 2 Days
4 | jkl | 2010-09-01 00:00:00 | 2011-11-01 00:00:00 | 1 Year 1 Month 1 Day
Spreadsheet: 772165d1647030935-time-to-hours-billed-conversion-formula-sample
Sheet: Billable Hours Template

 | Billable Hours Tracker |  |  |  |  | Month Ended: | 2022-03-31 00:00:00
 | Date | Client | Time Started | Time Ended | Work Description | Time Worked | Time Billed |  | Total Billable Time
 | 2022-03-06 00:00:00 | XYZ | 14:55:00 | 16:30:00 | Reviewed contracts and applicable accounting
 | 2022-03-10 00:00:00 |  | 12:50:00 | 15:00:00 | Prepared reports on current financial position
 | 2022-03-11 00:00:00 |  | 10:20:00 | 11:15:00 | Evaluated purchase of line of business |  |  |  | Minutes to Billable Time Conversion Chart
 |  |  |  |  |  |  |  |  | 1 - 6 ⇢ .1
 |  |  |  |  |  |  |  |  | 7 - 12 ⇢ .2
 |  |  |  |  |  |  |  |  | 13 - 18 ⇢ .3
 |  |  |  |  |  |  |  |  | 19 - 24 ⇢ .4
 |  |  |  |  |  |  |  |  | 25 - 30 ⇢ .5
 |  |  |  |  |  |  |  |  | 31 - 36 ⇢ .6
 |  |  |  |  |  |  |  |  | 37 - 42 ⇢ .7
 |  |  |  |  |  |  |  |  | 43 - 48 ⇢ .8
 |  |  |  |  |  |  |  |  | 49 - 54 ⇢ .9
 |  |  |  |  |  |  |  |  | 55 - 60 ⇢ 1
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 11d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 428 | 0 | 162
Cross-Currency Fixed-Fixed | 0 | 21 | 0 | 25
Cross-Currency Fixed-Float | 0 | 235 | 0 | 141
TOTAL | -
Spreadsheet: fe5f24dd-469d-413e-a6b1-1ae2a6e8b2f2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4171 | 21956 | [NAME] | [NAME] | RSA | 74 | 00:11:40 | 00:00:41 | 00:28:49 | 00:00:20 | 00:19:45 | 1 | 01:01:17
4171 | 16010 | Charlotte | [NAME] | ZIM | 71 | 00:12:00 | 00:00:38 | 00:31:22 | 00:00:20 | 00:22:22 | 2 | 01:06:48
4171 | 16036 | [NAME] | [NAME] | ZIM | 72 | 00:14:10 | 00:00:35 | 00:33:23 | 00:00:23 | 00:22:03 | 3 | 01:10:36
4171 | 21971 | Abir | Arbi | TUN | 73 | 00:12:10 | 00:01:18 | 00:33:34 | 00:00:20 | [NAME] | 4 | 01:12:06
Spreadsheet: 61584079-d7c5-4587-be4c-334e6ae80f1f
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
44477764 | 2014-12-17 03:32:03 | ALLIES | 1 | 6 | 1 | 1609999 | ArchNME | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44477967 | 2014-12-17 03:48:41 | AXIS | 1 | 6 | 2 | 1609999 | ArchNME | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 103216d1300991967-automatic-list-update-except-for-one-number-workbook29
Sheet: Sheet1

3 | 4 | 6 | 2 |  |  | 4
306 | 406 | 606 | 206
337 | 437 | 637 | 237
346 | 446 | 646 | 246
301 | 401 | 601 | 201
329 | 429 | 629 | 229
338 | 438 | 638 | 238
347 | 447 | 647 | 247
302 | 402 | 602 | 202
311 | 411 | 611 | 211
339 | 439 | 639 | 239
348 | 448 | 648 | 248
357 | 457 | 657 | 257
303 | 403 | 603 | 203
312 | 412 | 612 | 212
349 | 449 | 649 | 249
358 | 458 | 658 | 258
367 | 467 | 667 | 267
304 | 404 | 604 | 204
322 | 422 | 622 | 222
359 | 459 | 659 | 259
368 | 468 | 668 | 268
377 | 477 | 677 | 277
305 | 405 | 605 | 205
314 | 414 | 614 | 214
369 | 469 | 669 | 269
378 | 478 | 678 | 278
315 | 415 | 615 | 215
324 | 424 | 624 | 224
379 | 479 | 679 | 279
307 | 407 | 607 | 207
316 | 416 | 616 | 216
325 | 425 | 625 | 225
308 | 408 | 608 | 208
317 | 417 | 617 | 217
326 | 426 | 626 | 226
335 | 435 | 635 | 235
344 | 444 | 644 | 244
399 | 499 | 699 | 299
309 | 409 | 609 | 209
318 | 418 | 618 | 218
327 | 427 | 627 | 227
336 | 436 | 636 | 236
345 | 445 | 645 | 245
Spreadsheet: 764246d1642660734-index-required-by-matching-two-columns-index-with-match-two-columns
Sheet: Sheet1

Category | Grade | Slab |  |  |  |  | Category | Grade | Slab
Category-A | Outstanding | 0.15 |  |  |  |  | Category-A |  | 0.15
Category-A | Very Good | 0.12 |  |  |  |  | Category-A |  | 0.12
Category-B | Outstanding | 0.12 |  |  |  |  | Category-B |  | 0.12
Category-B | Very Good | 0.096 |  |  |  |  | Category-B |  | 0.096
Category-C | Outstanding | 0.1 |  |  |  |  | Category-C |  | 0.1
Category-C | Average | 0.04 |  |  |  |  | Category-C |  | 0.04
Category-D | Outstanding | 0.08 |  |  |  |  | Category-D |  | 0.08
Category-D | Below Average | 0 |  |  |  |  | Category-D |  | 0
 |  |  |  |  |  |  |  | I tried and failed 😫
Spreadsheet: 82083d1282136626-sorting-multiple-instances-of-the-same-record-draft
Sheet: Sheet1

 | name | time |  |  |  | name | time totals
 | [NAME] | 01:00:00 |  |  |  | [NAME] | 02:30:00
 | [NAME] | 00:30:00 |  |  |  | [NAME] | 02:30:00
 | tom | 01:00:00 |  |  |  | tom | 03:30:00
 | tom | 01:00:00
 | [NAME] | 00:30:00
 | [NAME] | 01:00:00
 | [NAME] | 00:30:00
 | tom | 00:30:00
 | [NAME] | 01:00:00
 | [NAME] | 00:30:00
 | tom | 01:00:00
Spreadsheet: a23a8578-e7bc-45bc-b062-54b20e9d7b5e
Sheet: Sheet1

Release: Quarterly Starts and Completions by Purpose and Design | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=228
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-08 4:22 PM CST
 | Real-Time | Period
Name: | Start | End
Quarterly Starts and Completions by Purpose and Design | 2011-05-17 00:00:00 | Current
Link:
http://www.census.gov/const/www/newresconstindex_excel.html | 2011-05-17 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2011-05-17 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-05-17 00:00:00
2011-08-16 00:00:00
2011-11-17 00:00:00
2012-02-16 00:00:00
2012-05-16 00:00:00
2012-08-16 00:00:00
2012-11-20 00:00:00
2013-02-20 00:00:00
2013-05-16 00:00:00
2013-08-16 00:00:00
Spreadsheet: 68251d1268779736-column-comparison-forum2
Sheet: Sheet1

a | 1 |  | x |  | 2 | 8 | 7.625
b | b |  |  |  | 14 | 1
v | v |  |  |  | 26 | 37
a | 1 |  |  |  | 38 | 49
x | x |  |  |  | 50 | 61
 |  |  | 1
 |  |  | 1
q | q |  | 1
a | a |  | 1
1 | 1 |  | 1
 | 1 |  | 1
 |  |  | 1
 |  |  | 1
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 4-6T

 | Section 4: Utilization
 | Table 4-6Trend:  Miles - Commercially Leased Vehicles by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Passenger Vehicles | 6262282 | 5961783.9 | 6654121.9 | 3895007 | 2234970
 | Trucks | 22507915.4 | 50917011.7 | 27492901.3 | 18797643 | 30949252.6
 | Other | 16614350.5 | 26209981.2 | 24739044.6 | 7079590.9 | 29778177.3
 | Grand Total | 45384547.9 | 83088777 | 58886067.9 | 29772241 | 62962400
Spreadsheet: 177463d1346318698-consolidate-totals-from-data-0a1fsample-exp
Sheet: Totals

Cost Centre | 2012-01-01 00:00:00 | February | March | April | May | June | July | August | 2012-09-01 00:00:00 | October | November | December | January | February | March | Total
A02501 | 0 |  |  |  |  |  |  |  | 0
[NAME] | 0 |  |  |  |  |  |  |  | 0
A02505 | 0 |  |  |  |  |  |  |  | 0
A02506 | 0 |  |  |  |  |  |  |  | 0
A02510 | 0 |  |  |  |  |  |  |  | 0
A02513 | 0 |  |  |  |  |  |  |  | 0
A02516 | 0 |  |  |  |  |  |  |  | 0
A02517 | 0 |  |  |  |  |  |  |  | 0
A02518 | 0 |  |  |  |  |  |  |  | 0
A02519 | 0 |  |  |  |  |  |  |  | 0
A02520 | 0 |  |  |  |  |  |  |  | 0
A02525 | 0 |  |  |  |  |  |  |  | 0
A02527 | 0 |  |  |  |  |  |  |  | 0
A02530 | 0 |  |  |  |  |  |  |  | 130
A02533 | 0 |  |  |  |  |  |  |  | 0
A02534 | 0 |  |  |  |  |  |  |  | 0
A02538 | 0 |  |  |  |  |  |  |  | 0
A02539 | 0 |  |  |  |  |  |  |  | 0
A02540 | 0 |  |  |  |  |  |  |  | 0
A02544 | 0 |  |  |  |  |  |  |  | 0
A02650 | 0 |  |  |  |  |  |  |  | 0
A02651 | 0 |  |  |  |  |  |  |  | 325
A02652
A02653
A02654
A02656
A02657
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 455 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 101361d1299513600-linking-workbooks-example
Sheet: Sep

 | Unit Sold
Salesman1 | 889
Salesman2 | 555
Salesman3 | 846
Salesman4 | 338
Salesman5 | 889
Salesman6 | 978
Salesman7 | 201
Salesman8 | 483
Salesman9 | 855
Salesman10 | 805
Salesman11 | 434
Salesman12 | 6
Salesman13 | 878
Salesman14 | 135
Salesman15 | 302
Salesman16 | 468
Salesman17 | 400
Salesman18 | 812
Salesman19 | 591
Salesman20 | 906
Salesman21 | 327
Salesman22 | 663
Spreadsheet: 472128d1469457470-comparing-two-sheets-sample
Sheet: Sheet1

clcTotalDonations | Title | Firstname | Surname | Contact ID | Position | Address | Address 2 | Address 2 - Extra | Organisation | Town | County | Post Code | Country | [NAME] | Use Email? | Create Date | CreatedBy | Update Date | Updated By | Newsletter Audit | Correspond via Org. | BPMA Contact | NO MAIL
0 |  | [NAME] | Phan Van Phi | 9733 |  | 97 Rue De Vaugirard |  |  |  | Paris |  | 75006 | FRANCE |  | False | 42321.52006944444 | HARRY | 42321.52006944444 | HARRY | True | False |  | False
0 | Mrs | [NAME] | Haward | 9730 |  | 22 Pembury Road |  |  |  | Havant | Hants | PO9 2TS |  |  | False | 42319.70756944444 | HARRY | 42321.51753472222 | HARRY | True | False |  | False
0 |  | [NAME] | Conlon | 9732 |  | 58 Badliss Road |  |  |  | London |  | E17 5LQ |  |  | False | 42320.62145833333 | HARRY | 42320.62145833333 | HARRY | True | False |  | False
4000 | Dr | [NAME] | [NAME] | 2632 |  | 1 Main Road |  | Littleton |  | WINCHESTER | Hants | SO22 6PS |  |  | False | 40977 | CONVERT | 42303.62177083334 | MARIA | True | False | DM/ AS | False
0 | Professor | [NAME] | Goodey | 4878 |  | 14 Queen Street | [NAME] |  | company 1 | Banbury | [NAME] | OX17 2NP |  |  | True | 40977 | CONVERT | 42303.59417824074 | MARIA | True | False | AS | False
1000 | Dr | Helen | [NAME] | 932 |  | Lovells | The Square |  |  | [NAME] | Oxfordshire | OX17 3RE |  |  | True | 40977 | CONVERT | 42303.49642361111 | MARIA | True | False | AS | False
0 | Ms | Victoria | Lajer | 5235 |  | Stanley Gibbons  Ltd. | 399 Strand | London | company 2 |  |  | WC2R 0LX |  |  | True | 40977 | CONVERT | 42300.69149305556 | MARIA | True | False | DM/ AS | False
Spreadsheet: 883634d1732280721-need-to-combine-formulas-into-1-cell-test-sheet
Sheet: Salaries

Person | Date of Birth | Age | Amount | Hourly Rate Jan 25 | Above National Minimum Wage for 18-20 (April 24) | Above National Minimum Wage for 21+ (April 24) | Above National Minimum Wage for 18-20 (April 25) | Above National Minimum Wage for 21+ (April 25) | Pay Rise Required |  |  |  |  |  |  | Year | Min Wage Over 21 | Min Wage 18-20 | Apprentice & Under 18
Employee 1 | 1993-11-30 00:00:00 |  | 27500 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-04-01 00:00:00 | 11.44 | 8.6 | 6.4
Employee 2 | 1991-12-05 00:00:00 |  | 21300 |  |  |  |  |  |  |  |  |  |  |  |  | 2025-04-01 00:00:00 | 12.21 | 10 | 7.55
Employee 3 | 1997-07-28 00:00:00 |  | 40500
Employee 4 | 1988-02-09 00:00:00 |  | 43000
Employee 5 | 1971-10-07 00:00:00 |  | 21000
Employee 6 | 1985-05-26 00:00:00 |  | 38000
Employee 7 | 1961-01-13 00:00:00 |  | 35000
Employee 8 | 1977-04-07 00:00:00 |  | 42500
Employee 9 | 1979-01-08 00:00:00 |  | 35200
Employee 10 | 1984-02-09 00:00:00 |  | 55000
Employee 11 | 1999-04-28 00:00:00
Employee 12 | 2003-05-23 00:00:00 |  | 27500
Employee 13 | 1982-09-27 00:00:00 |  | 39500
Employee 14 | 1955-02-21 00:00:00
Employee 15 | 1981-04-23 00:00:00
Employee 16 | 1972-08-25 00:00:00
Employee 17 | 1979-12-03 00:00:00
Employee 18 | 1971-02-07 00:00:00
Employee 19 | 1980-10-27 00:00:00
Employee 20 | 1972-07-20 00:00:00
Employee 21 | 1981-05-09 00:00:00
Employee 22 | 1963-05-14 00:00:00
Employee 23 | 1963-10-16 00:00:00
Employee 24 | 1985-05-02 00:00:00 |  | 75000
Employee 25 | 1985-09-27 00:00:00 |  | 30000
Employee 26 | 2003-12-23 00:00:00 |  | 23795.2
Employee 27 | 2004-07-10 00:00:00 |  | 23795.2
Employee 28 | 2005-02-02 00:00:00 |  | 19500
Employee 29 | 2005-07-04 00:00:00 |  | 19500
Employee 30 | 2005-06-01 00:00:00 |  | 17888
Employee 31 | 2004-02-21 00:00:00 |  | 23795.2
Employee 32 | 1974-07-27 00:00:00
Employee 33 | 1989-04-12 00:00:00 |  | 40000
Employee 34 | 1993-04-17 00:00:00 |  | 48000
Employee 35 | 1978-06-30 00:00:00 |  | 55000
Employee 36 | 1993-06-23 00:00:00
Employee 37 | 2003-08-10 00:00:00
Spreadsheet: 829687d1684394605-creating-list-from-numeric-range-sample
Sheet: Sheet1

POINT RANGE |  |  | POINT LIST
Start | End |  | 4 |  |  |  |  | 5 | 6 | 7
4 | 7 |  | 5 |  | 5 |  | 12 | #N/A | #N/A | #N/A
12 |  |  | 6 |  | 6 |  | 15 | 16 | 17 | #N/A
15 | 17 |  | 7 |  | 7 |  | 21 | #N/A | #N/A | #N/A
21 |  |  | 12 |  | 12 |  | 25 | 26 | #N/A | #N/A
25 | 26 |  | 15 |  | 15
 |  |  | 16 |  | 16
 |  |  | 17 |  | 17
 |  |  | 21 |  | 21 |  | 5 | 5
 |  |  | 25 |  | 25 |  | 6 | 6
 |  |  | 26 |  | 26 |  | 7 | 7
 |  |  |  |  |  |  | 12 | 12
 |  |  |  |  |  |  | #N/A | 15
 |  |  |  |  |  |  | #N/A | 16
 |  |  |  |  |  |  | #N/A | 17
 |  |  |  |  |  |  | 15 | 21
 |  |  |  |  |  |  | 16 | 25
 |  |  |  |  |  |  | 17 | 26
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | 21
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | 25
 |  |  |  |  |  |  | 26
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
Spreadsheet: d8998ee7-50bb-4b75-930d-1e48889d76fa
Sheet: ST15

Supplementary Table 15 ([NAME] et al.) Comparison of 410 HP with published genomic scans for human evolution
Region (hg19) | Reference(s) | Nearest TSS
Overlap with 9 scans of positive selection
chr1:148555814-148557118 | 1 | NBPF15
chr11:49582211-49584242 | 1 | LOC440040
chr19:11784427-11785561 | 1 | ZNF833P
chr2:115918003-115921686 | 1 | DPP10
chr4:6246915-6248356 | 2, 3, 4 | WFS1
Overlap with 202 human accelerated regions (HARs)
chr20:61732970-61734710 | 5 | HAR1B
1. [NAME]. 2006. Proc Natl Acad Sci U S A 103: 135-140.
2. [NAME] et al. 2007. [NAME] ONE 2: e286.
3. [NAME] et [NAME]. 2007. [NAME] Biol 5: e171.
4. [NAME] et [NAME]. 2007. [NAME] 3: e90.
5. [NAME]. 2006. [NAME].
Spreadsheet: darrell_schoolcraft__7300__imball0112
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 101751 | 98243
2 | 102927 | 104706
3 | 117477 | 116286
4 | 119833 | 117531
5 | 123072 | 121673
6 | 115143 | 114331
7 | 104853 | 105766
8 | 104302 | 102762
9 | 103913 | 102521
10 | 101722 | 101279
11 | 108378 | 104512
12 | 83509 | 109973
13 | 77877 | 101045
14 | 131278 | 141469
15 | 97603 | 96224
16 | 91854 | 96224
17 | 106236 | 103991
18 | 100249 | 98417
19 | 98119 | 96237
20 | 126430 | 125497
21 | 98320 | 96237
22 | 128666 | 127851
23 | 129018 | 126608
24 | 141956 | 135259
25 | 136288 | 133973
26 | 134730 | 132198
27 | 102542 | 100321
28 | 131265 | 130675
29 | 121742 | 119182
30 | 114424 | 112976
31 | 129578 | 128094
2001-11-30 00:00:00 |  |  | -47216
2001-12-31 00:00:00
CBS Dollars
 |  |  | 234488.68 |  |  |  | 12
 |  |  |  |  |  |  | 500
 |  |  |  |  |  |  | 5895