tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2ef59174-9b5f-4a15-859c-4918238104a4
Sheet: Sheet1

ZONEID | [NAME] | KS0180001 | KS0180002 | KS0180003 | KS0180004 | [NAME] | KS0180006 | KS0180007 | KS0180008
00CNGS | ACOCKS GREEN | 10887 | 2386 | 3752 | 100 | 2828 | 509 | 856 | 456
00CNGT | ASTON | 9679 | 1872 | 1680 | 110 | 3283 | 1315 | 861 | 558
00CNGU | BARTLEY GREEN | 11138 | 1999 | 3357 | 216 | 4155 | 600 | 290 | 521
00CNGW | BILLESLEY | 10510 | 2786 | 3805 | 120 | 2763 | 255 | 376 | 405
00CNGX | [NAME] | 9312 | 2570 | 2725 | 86 | 1924 | 596 | 1002 | 409
00CNGY | [NAME] | 11161 | 2705 | 4126 | 123 | 1162 | 1719 | 972 | 354
00CNGZ | BRANDWOOD | 10058 | 2698 | 3527 | 46 | 2617 | 410 | 390 | 370
00CNHA | EDGBASTON | 8530 | 2088 | 1853 | 39 | 1007 | 1275 | 1660 | 608
00CNHB | ERDINGTON | 10315 | 2727 | 3682 | 98 | 2002 | 614 | 812 | 380
00CNHC | HALL GREEN | 9295 | 3339 | 4315 | 52 | 649 | 178 | 560 | 202
00CNHD | HANDSWORTH WOOD | 9710 | 3205 | 3265 | 33 | 628 | 952 | 1031 | 596
00CNHE | HARBORNE | 9552 | 2727 | 3050 | 74 | 931 | 751 | 1667 | 352
00CNHF | HODGE HILL | 9713 | 2840 | 3415 | 103 | 2298 | 370 | 385 | 302
00CNHG | KINGS NORTON | 9990 | 2121 | 3392 | 78 | 3380 | 320 | 292 | 407
00CNHH | KINGSTANDING | 9714 | 1720 | 2929 | 102 | 3551 | 572 | 344 | 496
00CNHJ | LADYWOOD | 7823 | 827 | 1061 | 95 | 2496 | 2019 | 874 | 451
00CNHK | LONGBRIDGE | 10295 | 1957 | 3966 | 115 | 3065 | 423 | 366 | 403
00CNHL | LOZELLS AND EAST HANDSWORTH | 9736 | 2545 | 1754 | 78 | 1405 | 2499 | 960 | 495
00CNHM | MOSELEY AND KINGS HEATH | 10700 | 2602 | 3553 | 53 | 674 | 1511 | 1970 | 337
00CNHN | NECHELLS | 10799 | 1320 | 1649 | 184 | 4224 | 1978 | 816 | 628
00CNHP | NORTHFIELD | 10777 | 3111 | 3997 | 96 | 2400 | 472 | 384 | 317
00CNHQ | OSCOTT | 10119 | 3463 | 4525 | 93 | 1097 | 244 | 437 | 260
00CNHR | PERRY BARR | 8926 | 3083 | 4050 | 53 | 582 | 350 | 589 | 219
00CNHS | QUINTON | 9781 | 2900 | 3488 | 64 | 2297 | 296 | 403 | 333
00CNHT | SELLY OAK | 8308 | 2222 | 2404 | 30 | 543 | 369 | 2406 | 334
00CNHU | SHARD END | 11317 | 2255 | 3316 | 91 | 4302 | 414 | 352 | 587
00CNHW | SHELDON | 9153 | 3166 | 3438 | 51 | 1792 | 92 | 293 | 321
00CNHX | SOHO | 8799 | 2192 | 1986 | 106 | 1716 | 1337 | 1062 | 400
00CNHY | SOUTH YARDLEY | 10915 | 2751 | 4205 | 93 | 2026 | 562 | 893 | 385
[NAME] | SPARKBROOK | 9721 | 1963 | 2019 | 89 | 2019 | 1889 | 1235 | 507
00CNJA | SPRINGFIELD | 9269 | 2918 | 3208 | 48 | 868 | 637 | 1272 | 318
00CNJB | STECHFORD AND YARDLEY NORTH | 9991 | 2598 | 3629 | 71 | 2346 | 500 | 465 | 382
00CNJC | STOCKLAND GREEN | 9175 | 2416 | 3478 | 134 | 992 | 796 | 1085 | 274
00CNJD | SUTTON FOUR OAKS | 9310 | 3995 | 4005 | 28 | 436 | 325 | 331 | 190
00CNJE | SUTTON NEW HALL | 8891 | 3085 | 4424 | 57 | 258 | 477 | 357 | 233
00CNJF | SUTTON TRINITY | 9897 | 3469 | 4295 | 64 | 1063 | 234 | 466 | 306
00CNJG | SUTTON VESEY | 9398 | 3651 | 4387 | 55 | 390 | 272 | 467 | 176
00CNJH | TYBURN | 9282 | 1906 | 2825 | 103 | 1474 | 2149 | 398 | 427
00CNJJ | WASHWOOD HEATH | 8251 | 2423 | 2083 | 69 | 1395 | 1158 | 751 | 372
00CNJK | WEOLEY | 10578 | 2397 | 3167 | 102 | 2773 | 1114 | 529 | 496
Spreadsheet: 703288d1604933651-extract-values-in-a-column-excluding-blanks-extract-values
Sheet: Sheet2

 | Name | Name
Spreadsheet: 858824d1707352899-converting-time-zones-timezone-text-vs-number-
Sheet: Sheet1

original | Dec vs Jul | or | all July
2023-12-07 21:29:13
2023-12-07 21:29:57
2023-12-07 21:33:22
2023-12-07 21:40:08
2023-12-07 21:40:33
2023-12-07 22:29:27
13/07/2023 00:11:09
13/07/2023 00:15:53
13/07/2023 00:16:04
13/07/2023 00:16:23
Spreadsheet: chris_germany__2912__Plant Fuel 02 2000
Sheet: Jun 99

Date | lbs 1CT oil | lbs 1 DB oil | lbs 2 CT oil | lbs 2 DB oil | lbs Aux. Blr oil | daily oil mmbtu | daily oil gallons | Fuel Tank Level | Oil Deliv. Gallons | Trucks | lbs 1 CT gas | lbs 1 DB gas | lbs 2 CT gas | lbs 2 DB gas | lbs Aux. Blr gas | Daily gas mmbtu
2000-06-01 00:00:00
2000-06-02 00:00:00
2000-06-03 00:00:00
2000-06-04 00:00:00
2000-06-05 00:00:00
2000-06-06 00:00:00
2000-06-07 00:00:00
2000-06-08 00:00:00
2000-06-09 00:00:00
2000-06-10 00:00:00
2000-06-11 00:00:00
2000-06-12 00:00:00
2000-06-13 00:00:00
2000-06-14 00:00:00
2000-06-15 00:00:00
2000-06-16 00:00:00
2000-06-17 00:00:00
2000-06-18 00:00:00
2000-06-19 00:00:00
2000-06-20 00:00:00
2000-06-21 00:00:00
2000-06-22 00:00:00
2000-06-23 00:00:00
2000-06-24 00:00:00
2000-06-25 00:00:00
2000-06-26 00:00:00
2000-06-27 00:00:00
2000-06-28 00:00:00
2000-06-29 00:00:00
2000-06-30 00:00:00
mmbtu
gallons
Spreadsheet: 159916d1338903582-lunch-break-timings-calculations-lunch-break-formulae
Sheet: Mon

 |  |  | LUNCH TIME
 | Contract | Contract | OUT |  |  |  | IN |  |  | Time
Name | Days | Hours | Hrs | Mins |  |  | Hrs | Mins |  | Taken
Employee 1 | 5 | 37.5 | 13 | 45 | 13.75 |  | 14 | 10 | 14.16666666666667 | 0.2499999999999996 | -0.5
Employee 2 | 5 | 37.5 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | -0.5
Employee 3 | 5 | 37.5 | 13 | 6 | 13.1 |  | 13 | 35 | 13.58333333333333 | 0.2900000000000006 | -0.5
If an employee takes between 1 min to 30 mins lunch break , then need show in Col "L"  = 0.5
If an employee takes over 31 mins then I need to show in col "L" = 0.75
If an employee does not have a lunch break then I need to show in col "l" = 0
Spreadsheet: sally_beck__35151__MgmtSum-Q3-0914_Global
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
3RD QUARTER 2000 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Agricultural Trading
Office of the Chairman
Subtotal Commercial Expenses
Group
Other Interest Related Charges
Total Expenses
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 275958d1383695603-index-match-based-on-5-criteria-including-a-date-range-test
Sheet: Test

LOOKUP TABLE |  |  |  |  |  |  |  | OUTPUT TABLE
Country | Product Code | Service Level | Service Type | Start Date | End Date | Annual Unit Price (USD) |  | Country | Product Code | Service Level | Service Type | Start Date | Annual Unit Price (USD)
Australia | CISCO2801 | 7 x 24 x 4 | Maintenance | 2011-02-01 00:00:00 | 2015-06-30 00:00:00 | 200 |  | Australia | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2012-09-10 00:00:00 |  | matches columns I, J, K and L
Australia | CISCO2801 | 7 x 24 x 4 | Part Supply | 2012-02-10 00:00:00 | 2015-06-30 00:00:00 | 150 |  | Australia | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2012-09-10 00:00:00 |  | matches column M
Australia | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2012-03-15 00:00:00 | 2012-06-30 00:00:00 | 160
Australia | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2012-07-01 00:00:00 | 2012-11-22 00:00:00 | 215 |  | Australia | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2012-09-10 00:00:00 | 215 | matches columns I, J, K, L and M
Australia | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2013-04-11 00:00:00 | 2015-06-30 00:00:00 | 225
Australia | WS-C6509-E | 7 x 24 x 4 | Part Supply | 2012-02-01 00:00:00 | 2015-06-30 00:00:00 | 115
Australia | WS-C6509-V-E | 7 x 24 x 4 | Part Supply | 2012-02-01 00:00:00 | 2015-06-30 00:00:00 | 145
China | CISCO2801 | 7 x 24 x 4 | Maintenance | 2011-03-01 00:00:00 | 2015-06-30 00:00:00 | 122
China | CISCO2801 | 7 x 24 x 4 | Part Supply | 2012-06-11 00:00:00 | 2015-06-30 00:00:00 | 101
China | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2011-03-15 00:00:00 | 2012-06-12 00:00:00 | 141
China | WS-C6509-E | 7 x 24 x 4 | Maintenance | 2012-07-01 00:00:00 | 2015-06-30 00:00:00 | 152
Spreadsheet: 110777d1307384220-dynamic-rota-pattern-rota
Sheet: Sheet1

Current |  |  |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat
Code | Weeks | Week | W/C Date | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish
ROT | 6 | 1 | 2011-01-02 00:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
[NAME] | [NAME] | 2 | 2011-01-09 00:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
06:00:00 | 14:00:00 | 3 | 2011-01-16 00:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
 |  | 4 | 2011-01-23 00:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF
 |  | 5 | 2011-01-30 00:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | 06:00:00 | 14:00:00 | OFF | OFF
 |  | 6 | 2011-02-06 00:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | OFF | OFF
 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
W/C | Current | Rota | Rota | Rota | Start | Rota | Rota | Core |  |  | Sun |  | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat
Date | Rota | Group | Row | Cycle | Week | Weeks | Offset | Dept |  |  | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish
2011-09-04 00:00:00 | ROT1 | ROT | 3 | 6 | 1 | 6 | 5 |  |  |  | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | 06:00:00 | 14:00:00 | OFF | OFF | OFF | OFF
 | Start Date |  | 2011-01-01 00:00:00
 | End Date |  | 2011-12-31 00:00:00
 | Days |  | 364
 | Network Days |  | 260
 | Count of Certain Days | 4 | 52
Spreadsheet: 38999d1237222328-i-need-excel-to-ignore-a-superscript-book2
Sheet: Sheet2

Fidelity Managed Income Portfolio1 |  |  |  | 5
Fidelity Diversified International |  |  |  | 45
Fidelity Spartan U.S. Equity Index Inv2 |  |  |  | 3
Fidelity Puritan |  |  |  | 6
Fidelity OTC Portfolio |  |  |  | 99
Fidelity Blue Chip Growth |  |  |  | 14
Royce Pennsylvania Mutual Inv |  |  |  | 15
[NAME] Growth A |  |  |  | 8
Fidelity Low Priced Stock |  |  |  | 518
Fidelity U.S. Bond Index2 |  |  |  | 51
Fidelity Dividend Growth |  |  |  | 22
Fidelity Equity Income |  |  |  | 2
Spreadsheet: 0800b23e-0b13-4cb9-9f8f-f4b208a5cfbf
Sheet: Tenure

Tract Number | Housing Units | Units per Acre | Occupied | Owned | Owner Occupancy Rate(1) | Rented | [NAME] Rate(1) | Vacant(2) | Vacancy Rate(1)
3521.01 | 1292 | 13 | 969 | 356 | 0.367 | 613 | 0.633 | 323 | 0.25
3521.02 | 1431 | 14 | 1232 | 674 | 0.547 | 558 | 0.453 | 199 | 0.139
3522 | 1145 | 31 | 1073 | 276 | 0.257 | 797 | 0.743 | 72 | 0.063
3523 | 2069 | 14 | 1775 | 313 | 0.176 | 1462 | 0.824 | 294 | 0.142
3524 | 818 | 7 | 791 | 147 | 0.186 | 644 | 0.814 | 27 | 0.033
3525 | 1267 | 25 | 1207 | 391 | 0.324 | 816 | 0.676 | 60 | 0.047
3526 | 1055 | 18 | 1017 | 302 | 0.297 | 715 | 0.703 | 38 | 0.036
3527 | 1016 | 26 | 977 | 201 | 0.206 | 776 | 0.794 | 39 | 0.038
3528 | 955 | 24 | 899 | 306 | 0.34 | 593 | 0.66 | 56 | 0.059
3529 | 1415 | 19 | 1333 | 640 | 0.48 | 693 | 0.52 | 82 | 0.058
3530 | 2001 | 24 | 1906 | 452 | 0.237 | 1454 | 0.763 | 95 | 0.047
3531.01 | 1035 | 10 | 962 | 101 | 0.105 | 861 | 0.895 | 73 | 0.071
3531.02 | 327 | 1 | 313 | 0 | 0 | 313 | 1 | 14 | 0.043
3532 | 1701 | 13 | 1612 | 574 | 0.356 | 1038 | 0.644 | 89 | 0.052
3533 | 1771 | 15 | 1620 | 695 | 0.429 | 925 | 0.571 | 151 | 0.085
3534 | 1298 | 18 | 1235 | 472 | 0.382 | 763 | 0.618 | 63 | 0.049
3535 | 1330 | 26 | 1271 | 401 | 0.315 | 870 | 0.685 | 59 | 0.044
3536 | 1568 | 9 | 1486 | 499 | 0.336 | 987 | 0.664 | 82 | 0.052
3537 | 1956 | 14 | 1837 | 424 | 0.231 | 1413 | 0.769 | 119 | 0.061
3538 | 2947 | 39 | 2738 | 847 | 0.309 | 1891 | 0.691 | 209 | 0.071
3539 | 1519 | 19 | 1453 | 104 | 0.072 | 1349 | 0.928 | 66 | 0.043
3540 | 2089 | 18 | 1962 | 655 | 0.334 | 1307 | 0.666 | 127 | 0.061
3541 | 1717 | 12 | 1521 | 736 | 0.484 | 785 | 0.516 | 196 | 0.114
3542 | 1404 | 4 | 1291 | 899 | 0.696 | 392 | 0.304 | 113 | 0.08
3543 | 1651 | 5 | 1551 | 639 | 0.412 | 912 | 0.588 | 100 | 0.061
3544 | 802 | 11 | 759 | 434 | 0.572 | 325 | 0.428 | 43 | 0.054
3545 | 1291 | 13 | 1218 | 522 | 0.429 | 696 | 0.571 | 73 | 0.057
3546 | 2192 | 6 | 2078 | 804 | 0.387 | 1274 | 0.613 | 114 | 0.052
3547 | 1207 | 14 | 1145 | 585 | 0.511 | 560 | 0.489 | 62 | 0.051
3548 | 977 | 13 | 913 | 475 | 0.52 | 438 | 0.48 | 64 | 0.066
3549 | 2632 | 9 | 2552 | 722 | 0.283 | 1830 | 0.717 | 80 | 0.03
3550 | 1413 | 12 | 1336 | 589 | 0.441 | 747 | 0.559 | 77 | 0.054
Citywide | 47291 | 12 | 44032 | 15235 | 0.346 | 28797 | 0.654 | 3259 | 0.069
Spreadsheet: 376007d1423451356-taking-multiple-excel-documents-and-grouping-the-data-into-a-single-spreadsheet-apollo-ver2
Sheet: Sheet1

Name | Date Taken | # | Guest Name | Date | # Of Guests | Service Provided | Res. ID | Add-On Detail | Revised | *Payments /POA | **Sent
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 4 | Tram | 24263819 | - | - | 43 | E
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 2 | Tram | 24263845 | - | - | 17 | D
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 5 | Tram | 24264127 | - | - | 43 | E
Vince | 2015-02-07 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 | 2 | Tram | 24264460 | - | - | 23 | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-10-22 00:00:00 | 50 | Kimmswick | 24263430 | Final: 10/8/15 | - | - | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-08-06 00:00:00 | 2 | Tram | 24263444 | - | - | 17 | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 | 2 | Tram | 24262376 | - | Changed time | - | D
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 2 | Tram | 24263573 | - | - | 23 | E
Vince | 2015-02-06 00:00:00 | 1 | [NAME] | 2015-02-07 00:00:00 | 18 | Tram | 24263309 | - | Changed time | - | D
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-02-08 00:00:00 | 5 | Tram | 24262904 | - | Changed time | - | D
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-02-06 00:00:00 | 7 | Tram | 24262927 | - | - | 48 | E
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 | 34 | Tram | 24262934 | Final: 5/6/15 | - | - | E
Vince | 2015-02-05 00:00:00 | 1 | Red Lake | 2015-03-26 00:00:00 | 90 | Capt/Box/OCH | 24262576 | Final: 3/12/15 | Changed times | - | E
Vince | 2015-02-05 00:00:00 | 1 | Lebanon | 2015-05-08 00:00:00 | 39 | SS | 24263002 | Final: 4/24/15 | - | - | E
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-04-16 00:00:00 | 69 | Tram | 24263011 | Final: 4/2/15 | - | - | E
Vince | 2015-02-05 00:00:00 | 1 | [NAME] | 2015-05-20 00:00:00 | 43 | Tram | 24263043 | Final: 5/6/15 | - | - | E
Vince | 2015-02-02 00:00:00 | 1 | [NAME] | 2015-08-10 00:00:00 | 6 | LAW | 24262441 | - | - | 0 | E
Vince | 2015-02-02 00:00:00 | 1 | [NAME] | 2015-04-29 00:00:00 | 71 | Tram | 24262458 | Final: 4/15/15 | - | - | E
Vince | 2015-02-02 00:00:00 | 1 | Rogers High School | 2015-05-01 00:00:00 | 204 | Tram | 24262583 | Final: 4/17/15 | - | - | E
Spreadsheet: susan_pereira__39445__LAGASMAR
Sheet: ENRON

 | VARIBUS CORPORATION |  |  |  |  |  |  |  | FEBRUARY 29, 2000 |  |  |  |  |  |  | {SERVICES}PSNU~QAGQ
 | P.O. BOX 61000
 | NEW ORLEANS, LA 70161 |  |  |  |  |  | INVOICE NUMBER |  |  |  |  | 00-02-05
 | PH# (504)576-4152
 | IN ACCOUNT WITH
 | LOUISIANA GAS  MARKETING |  |  |  |  |  |  |  | AMOUNT
 | Attn: [NAME]
 | 1400 SMITH ST  Suite 3722A
 | Houston, Texas 7777002
 |  |  |  |  |  | PER
MMBTU'S |  |  | [NAME] |  |  | MMBTU |  |  |  |  |  | AMOUNT
796718 |  |  | Natural Gas Transported to |  |  | 0.03 |  |  |  |  |  | 23901.54
 |  |  | GSU at [NAME] in
 |  |  | Jan 2000 (Via LRC)
 |  |  | Contact Person
 |  |  | Accounting Question
 |  |  | [NAME]Ph# (504)576-4152
 |  |  | Operational Questions
 |  |  | [NAME] Ph# (281)297-3553
 |  |  |  | TOTAL AMOUNT DUE
 | PLEASE REMIT TO:
 | VARIBUS
 | P.O. BOX 61000
 | NEW  ORLEANS, LA.   70161
 | Attn: [NAME]
Spreadsheet: 98384d1297298621-macro-creates-new-sheet-with-data-from-other-sheets-customer-order-2-7-2011-bvj-
Sheet: Report

Fruit Num | Fruit | Variety | Quantity | Customer Discount | Comment
1 | Apples | Empire | 20 | 0.07 | Snacking
2 | Apples | Gala | 16 | 0.11 | Delicious
3 | Apples | [NAME] | 5 | 0.04 | Baking
4 | Apples | Red Delicious | 150 | 0.12 | Classic
5 | Apples | Ginger Gold | 1000 | 0.4 | The Best
6 | Apples | Fuji | 500 | 0.15 | Japanese
7 | Apples | Cortland | 75 | 0.2 | New York State
8 | Apples | Braeburn | 35 | 0.03 | Mealy
9 | Oranges | Navel | 20 | 0.05 | Common
10 | Oranges | Blood | 16 | 0.05 | Delicious
11 | Oranges | [NAME] | 5 | 0.04 | Pulpy
12 | Oranges | Fukuhara | 150 | 0.12 | Japanese
13 | Bananas | Cavendish | 20 | 0.05 | Costa Rica
14 | Bananas | Baby | 16 | 0.05 | Costa Rica
15 | Bananas | Manzano | 400 | 0.04 | Costa Rica
16 | Bananas | Burro | 150 | 0.12 | Costa Rica
17 | Bananas | Plantain | 600 | 0.06 | Costa Rica
Spreadsheet: 90318d1290067812-required-unique-record-book1
Sheet: Sheet4

 | Data
Name | Max of Total Amt. | [NAME] of DIFF. AMT | Min of Total Amt. | Min of DIFF. AMT
FORGE INFOSYS | 40600 | 900 | 20300 | 200
FRNACIS CEMENT CO | 104545 | 3130 | 30450 | 300
HIMALYA STEEL CEMENT | 40600 | 900 | 20300 | 200
ICCHAMANI SUPPLIER | 50750 | 1300 | 10150 | 100
K K INFOSYS | 144840 | 1860 | 10650 | 400
KAILASH TRADERS | 40600 | 400 | 40600 | 400
LUKAS STEEL | 71050 | 1700 | 20300 | 200
S K K  INFRASTRRUCUTRE | 40600 | 400 | 40600 | 400
[NAME] PAPERS | 81200 | 1200 | 20300 | 200
Grand Total | 144840 | 3130 | 10150 | 100
Spreadsheet: 849359d1699881689-spill-rows-from-table1-to-table2-based-on-columnn-in-table1-question
Sheet: ExpectedResult

ID | Description | COLUMN3 | COLUMN4 | COLUMN5
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
 |  | Data to be input by the user | Data to be input by the user | Data to be input by the user
Spreadsheet: 773575d1647941167-lookup-and-due-in-x-days-book1
Sheet: Sheet1

Date | Priority | Action Overdue | Action Status | Due In 30 Days
2022-02-01 00:00:00 | P1 |  | Not Started
2020-02-02 00:00:00 | P2 |  | In Progress
2022-02-03 00:00:00 | P3 |  | Completed
2021-02-04 00:00:00 | P4 |  | Clear
2022-02-05 00:00:00 | P5 |  | Not Started
2022-02-06 00:00:00 | P6 |  | Not Started
2022-02-07 00:00:00 | P1 |  | Not Started
2022-02-08 00:00:00 |  |  | Not Started
2021-02-09 00:00:00 | P3 |  | In Progress
2022-02-10 00:00:00 | P6 |  | Completed
Spreadsheet: 104989d1302472065-search-for-name-across-sheets-and-return-most-recent-date-involvement-final
Sheet: WedTemplate

 |  |  |  |  |  | Date | Service
WED
Singing:
[NAME]:
Closing:
Spreadsheet: 587274d1534939349-selecting-rate-from-one-table-entering-date-in-another-table-example-for-forum2
Sheet: Sheet2

 | DATE | SHIFT | MACHINES | MEN | RATE | AMOUNT |  |  | Rate Chart
 | 2018-07-15 00:00:00 | DAY | 2 | 4 |  |  |  |  | Week Days | DAY | 2000
 | 2018-07-15 00:00:00 | NIGHT | 0 | 4 |  |  |  |  | Week Days | NIGHT | 2000
 | 2018-07-16 00:00:00 | DAY | 3 | 4 | 2000 |  |  |  | Saturday | DAY | 4714
 | 2018-07-16 00:00:00 | NIGHT | 2 | 4 | 2000 |  |  |  | Saturday | NIGHT | 5696
 | 2018-07-17 00:00:00 | DAY | 2 | 4 | 2000 |  |  |  | Sunday | DAY | 6823
 | 2018-07-17 00:00:00 | NIGHT | 0 | 4 | 2000 |  |  |  | Sunday | NIGHT | 4325
 | 2018-07-18 00:00:00 | DAY | 2 | 4 | 2000
 | 2018-07-18 00:00:00 | NIGHT | 2 | 4 | 2000
 | 2018-07-19 00:00:00 | DAY | 2 | 4 | 2000
 | 2018-07-19 00:00:00 | NIGHT | 2 | 4 | 2000
 | 2018-07-20 00:00:00 | DAY | 0 | 4 | 2000
 | 2018-07-20 00:00:00 | NIGHT | 2 | 4 | 2000
 | 2018-07-21 00:00:00 | DAY | 1 | 4
 | 2018-07-21 00:00:00 | NIGHT | 1 | 4
 | 2018-07-22 00:00:00 | DAY | 3 | 4
 | 2018-07-22 00:00:00 | NIGHT | 3 | 4
 | 2018-07-23 00:00:00 | DAY | 3 | 4 | 2000
 | 2018-07-23 00:00:00 | NIGHT | 1 | 4 | 2000
 | 2018-07-24 00:00:00 | DAY | 1 | 4 | 2000
Spreadsheet: 778829d1651343682-get-number-of-seconds-between-two-dates-in-excel-excluding-part-of-weekend-and-holidays-removing-downtime
Sheet: Solutions

 | Start | End
Original Period (the long piece of string) | 2022-04-01 05:00:00 | 2022-04-30 05:00:00
[NAME] (the chunks to cut out) | 2022-04-01 12:00:00 | 2022-04-02 05:00:00
 | 2022-04-30 04:00:00 | 2022-04-30 20:00:00
 | 2022-04-13 05:00:00 | 2022-04-13 07:00:00
 | 2022-04-08 05:00:00 | 2022-04-09 07:00:00
 | 2022-04-25 05:00:00 | 2022-04-25 07:00:00
no crossover, so must be filtered out >> | 2022-05-25 05:00:00 | 2022-05-25 07:00:00
no crossover, so must be filtered out >> | 2022-01-25 05:00:00 | 2022-02-25 07:00:00
Original Period (the long piece of string) | 2022-04-01 12:00:00 | 2022-04-30 23:00:00
Sorted Downtimes (the chunks to cut out)
Remaining Available Uptimes
Spreadsheet: daren_farmer__5772__HPLN0320
Sheet: Sheet1

HPLN0318.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - March 18, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-03-20 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 478150d1472655653-excel-problem-identifying-the-correct-login-and-logout-of-an-employee-based-on-range-sample
Sheet: Report

User ID | EMPLOYEE NAME | [NAME] | [NAME] | ACTUAL LOGIN | ACTUAL LOGOUT
10337 | Agent3 | 18:00:00 | 03:00:00
10398 | Agent8 | 18:00:00 | 03:00:00
10545 | Agent10 | 18:00:00 | 03:00:00
10338 | Agent6 | 18:00:00 | 03:00:00
10492 | Agent4 | 18:00:00 | 03:00:00
10117 | Agent7 | 09:00:00 | 18:00:00
10650 | Agent2 | 13:00:00 | 22:00:00
10752 | Agent5 | 09:00:00 | 18:00:00
10410 | Agent9 | 08:00:00 | 17:00:00
10399 | Agent1 | 08:30:00 | 17:30:00
Spreadsheet: 453769d1459438440-can-i-use-vlookup-to-do-this-copy-of-sample-file-1
Sheet: Result

ID | Company | Quarter | Amount |  |  |  |  | Quarter | Amount
1 | Google | 1 | 1000
1 | Google | 2 | 2000
1 | Google | 3 | 3000
1 | Google | 4 | 4000
2 | Yahoo | 1 | 1000
2 | Yahoo | 2 | 2000
2 | Yahoo | 3 | 3000
2 | Yahoo | 4 | 4000
3 | AOL | 1 | 1000
3 | AOL | 2 | 2000
3 | AOL | 3 | 3000
3 | AOL | 4 | 4000
4 | Microsoft | 1 | 1000
4 | Microsoft | 2 | 2000
4 | Microsoft | 3 | 3000
4 | Microsoft | 4 | 4000
5 | Sony | 1 | 1000
5 | Sony | 2 | 2000
5 | Sony | 3 | 3000
5 | Sony | 4 | 4000
Spreadsheet: 863351d1710865326-split-and-organize-values-from-array-to-new-array-test
Sheet: Feuil1

 | /LABEL A|value01/[NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value06/LABEL G|value07
 | [NAME][NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value08
START WITH SPILLING ARRAY IN B6
 | [NAME][NAME] C|value03/LABEL D|value04/LABEL E|value05/LABEL F|value08
EXPECTED RESULT (spilling array in B10, 2 rows)
common: | [NAME] C|value03/LABEL D|value04/LABEL E|value05
specific: | /LABEL A|value01/LABEL F|value06/LABEL G|value07***/LABEL A|value12/LABEL F|value08
[NAME], FYI
 |  | #N/A
 |  | #N/A
 | LABEL A | value01
 | LABEL B | value02
 | LABEL C | value03
 | LABEL D | [NAME]
 | LABEL E | value05
 | [NAME] | value06
 | LABEL G | value07
 |  | #N/A
 | LABEL A | value12
 | LABEL B | value02
 | LABEL C | value03
 | LABEL D | [NAME]
 | LABEL E | value05
 | [NAME] | value08