tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 686667d1594743064-sumifs-by-month-and-year-newworkbookname
Sheet: Sheet1

EST Close Date | AMOUNT
 | 65162.5 |  |  | 2017 | 2018 | 2019 | 2020
 | 100000 |  | January
 | 100000 |  | February
 | 105000 |  | March
2020-08-30 00:00:00 | 135000 |  | April
2020-07-17 00:00:00 | 174740 |  | May
2017-10-16 00:00:00 | 180000 |  | June
 | 185000 |  | July
 | 191000 |  | August
 | 197395 |  | September
 | 203080 |  | October
2018-07-26 00:00:00 | 205000 |  | November
2019-01-17 00:00:00 | 210680 |  | December
2020-08-06 00:00:00 | 225000
 | 226100
2018-12-18 00:00:00 | 230000
2019-07-22 00:00:00 | 233750
2017-10-17 00:00:00 | 238000
2018-09-04 00:00:00 | 240000
2018-10-23 00:00:00 | 240000
 | 240014
2018-01-26 00:00:00 | 251250
2019-09-23 00:00:00 | 252000
 | 252000
 | 254750
2019-10-31 00:00:00 | 255000
2019-06-11 00:00:00 | 255000
2020-07-17 00:00:00 | 260000
 | 260000
 | 260000
 | 260000
 | 260000
 | 264127.7375
2020-01-06 00:00:00 | 266260.5
2019-08-31 00:00:00 | 272000
2019-04-29 00:00:00 | 273000
 | 273095
 | 275000
2020-01-07 00:00:00 | 277000
 | 279537.5
 | 281801.14
 | 284000
 | 284620
2019-03-22 00:00:00 | 290000
 | 290014
2020-07-17 00:00:00 | 291000
 | 291442.86
 | 291442.86
 | 291442.86
 | 294750
 | 295000
 | 295000
2018-10-09 00:00:00 | 297220
2018-10-30 00:00:00 | 300000
 | 302974.1
 | 304486.875
2020-08-05 00:00:00 | 305500
2019-06-03 00:00:00 | 306000
2018-10-16 00:00:00 | 309765
2017-10-31 00:00:00 | 311250
2020-09-03 00:00:00 | 312085
2018-05-07 00:00:00 | 313625
 | 329000
2020-07-24 00:00:00 | 332000
2018-10-09 00:00:00 | 333000
 | 338000
 | 338318.75
 | 340000
2020-04-21 00:00:00 | 340826
 | 341100
2020-06-07 00:00:00 | 343500
 | 345404
 | 345950
 | 346442.86
 | 349365.62
 | 350000
 | 352939.2075
 | 354642.82
 | 356000
 | 356000
 | 356650
2017-12-26 00:00:00 | 360000
2019-08-26 00:00:00 | 361517
 | 361617.66
 | 362000
 | 363000
 | 364750
 | 364943.04165
2018-01-29 00:00:00 | 365735
 | 367580
 | 368207.8125
 | 368207.8125
 | 370452
2019-03-21 00:00:00 | 378000
2020-07-14 00:00:00 | 380000
 | 380000
 | 383025.76
 | 386270
 | 390000
 | 393000
2020-06-23 00:00:00 | 397000
 | 400000
 | 400000
 | 407000
 | 407000
 | 408405
 | 408405
2018-07-26 00:00:00 | 410125
2020-07-17 00:00:00 | 412000
2018-08-06 00:00:00 | 412153
2018-12-31 00:00:00 | 414950
2019-06-11 00:00:00 | 415850
2019-07-05 00:00:00 | 416100
2020-08-16 00:00:00 | 417000
 | 417000
 | 417000
2019-12-08 00:00:00 | 420000
2019-08-30 00:00:00 | 425000
2020-10-08 00:00:00 | 426000
 | 434551.14
2020-04-27 00:00:00 | 435870
2020-07-17 00:00:00 | 440000
 | 483312.5
 | 495000
 | 495000
2020-04-30 00:00:00 | 501549.34
 | 521000
 | 531000
 | 532174
 | 536000
 | 536000
 | 536000
 | 536000
 | 536000
2020-07-31 00:00:00 | 540000
 | 551900
 | 558352
 | 560000
 | 580000
 | 592250
 | 592250
 | 606550
 | 609900
 | 609900
 | 613679.6875
 | 638226.875
 | 645192
2020-04-23 00:00:00 | 650000
 | 654864.76
2020-04-24 00:00:00 | 667814.76
2020-08-30 00:00:00 | 680000
2020-08-15 00:00:00 | 695382.5
 | 695868.75
2020-04-30 00:00:00 | 742750
Spreadsheet: 707738d1607436117-formulas-to-return-multi-different-net-prices-return-multiple-net-prices-for-same-part-code
Sheet: Sheet1

Order number | Part code | Net Price |  | Order Number | Part code | Net Price
12345 | AAAAA | 10 |  | 12345 | AAAAA
12345 | BBBBB | 20 |  |  | BBBBB
12345 | CCCCC | 10 |  |  | CCCCC
12345 | BBBBB | 30 |  |  | BBBBB
12345 | DDDDD | 5 |  |  | DDDDD
232323 | AAAAA | 5
232323 | DDDDD | 10 |  | Order Number | Part code | Net Price
232323 | DDDDD | 20 |  | 232323 | AAAAA
232323 | CCCCC | 30 |  |  | DDDDD
232323 | BBBBB | 10 |  |  | DDDDD
821821 | AAAAA | 10 |  |  | CCCCC
821821 | BBBBB | 20 |  |  | BBBBB
821821 | BBBBB | 30
821821 | CCCCC | 20 |  | Order Number | Part code | Net Price
821821 | BBBBB | 50 |  | 821821 | AAAAA
 |  |  |  |  | BBBBB
 |  |  |  |  | BBBBB
 |  |  |  |  | CCCCC
 |  |  |  |  | BBBBB
Spreadsheet: 119619d1314624190-call-in-multiple-entries-from-master-sheet-example
Sheet: Master-Database

 | COMPANY | UNITS | PACKAGING |  | PKG TYPE | BRAND | LOT | A | B | C | D | E | F | G
COMP - A_M2 | COMP - A | 45 | 1 | 13 | [NAME] | K40 | M2 | A | B | C | D | E | F | G
COMP - A_M3 | COMP - A | 49 | 1 | 13 | [NAME] | K41 | M3 | A | B | C | D | E | F | G
COMP - A_M4 | COMP - A | 53 | 1 | 13 | [NAME] | K42 | M4 | A | B | C | D | E | F | G
COMP - A_M5 | COMP - A | 57 | 1 | 13 | [NAME] | K43 | M5 | A | B | C | D | E | F | G
COMP - A_M6 | COMP - A | 61 | 1 | 13 | [NAME] | K44 | M6 | A | B | C | D | E | F | G
COMP - A_M7 | COMP - A | 65 | 1 | 13 | [NAME] | K45 | M7 | A | B | C | D | E | F | G
COMP - A_M8 | COMP - A | 69 | 1 | 13 | [NAME] | K46 | M8 | A | B | C | D | E | F | G
COMP - A_M9 | COMP - A | 73 | 1 | 13 | [NAME] | K47 | M9 | A | B | C | D | E | F | G
Spreadsheet: elizabeth_sager__9627__New Power Co P&L as of 10-18
Sheet: New Power Co P&L as of 10-18

Physical/ | Financial | Financial | Physical | Physical | Physical | Physical | Physical | Physical | Physical | Grand Total:
Delivery | FINANCIAL DEAL-R1E Western HUB | Financial Deal - R1B | CINERGY (Into) System | DLC System Border | ERCOT System | NEPOOL PTF | North 2001 | PJM-Western Hub | SP-15
10/1/2001 Total | 0 | 114234.3 | 3837 | 0 | 32046.79 | -24149.58 | 0 | -239732.09 | -32495.06 | -146258.64
11/1/2001 Total | -35752.11 | 276285.26 | 14253.18 | -1126.74 | 26726.18 | -37640.14 | 0 | -512706.14 | -104635.61 | -374596.09
12/1/2001 Total | -49972.56 | 206888.37 | 26102.61 | 7680.86 | 1987.58 | -35776.41 | -12363.78 | -175814.74 | -83325.65 | -114593.69
1/1/2002 Total | 0 | 0 | 180401.92 | 0 | 516726.23 | -17457 | 0 | 38109.58 | 0 | 717780.76
2/1/2002 Total | 0 | 0 | 169347.58 | 0 | 468946.44 | -15842.79 | 0 | 33667.55 | 0 | 656118.78
3/1/2002 Total | 0 | 0 | 0 | 0 | 293862.1 | 0 | 0 | -18160.53 | 0 | 275701.56
4/1/2002 Total | 0 | 0 | 0 | 0 | 302052 | 0 | 0 | -21160.18 | 0 | 280891.82
5/1/2002 Total | 0 | 0 | 0 | 0 | 341277.1 | 0 | 0 | 4645.88 | 0 | 345923
6/1/2002 Total | 0 | 0 | 0 | 0 | 362240.81 | -47146.32 | 0 | 252036.35 | 0 | 567130.84
7/1/2002 Total | 0 | 0 | -435523.81 | 0 | 547604.29 | 107796.13 | 0 | 445491.99 | 0 | 665368.59
8/1/2002 Total | 0 | 0 | -434456.46 | 0 | 546296.71 | 107538.73 | 0 | 444428.23 | 0 | 663807.21
9/1/2002 Total | 0 | 0 | 0 | 0 | 324552.6 | 0 | 0 | -64559.44 | 0 | 259993.15
10/1/2002 Total | 0 | 0 | 0 | 0 | 364188.8 | 0 | 0 | -67104.46 | 0 | 297084.33
11/1/2002 Total | 0 | 0 | 0 | 0 | 300312.16 | 0 | 0 | -46585.41 | 0 | 253726.76
12/1/2002 Total | 0 | 0 | 0 | 0 | 320896.38 | 0 | 0 | -26773.08 | 0 | 294123.3
1/1/2003 Total | 0 | 0 | 0 | 0 | 281686.89 | 0 | 0 | 0 | 0 | 281686.89
2/1/2003 Total | 0 | 0 | 0 | 0 | 255342.83 | 0 | 0 | 0 | 0 | 255342.83
3/1/2003 Total | 0 | 0 | 0 | 0 | 267234 | 0 | 0 | 0 | 0 | 267234
4/1/2003 Total | 0 | 0 | 0 | 0 | 279049.17 | 0 | 0 | 0 | 0 | 279049.17
5/1/2003 Total | 0 | 0 | 0 | 0 | 265443 | 0 | 0 | 0 | 0 | 265443
6/1/2003 Total | 0 | 0 | 0 | 0 | 264526.91 | 0 | 0 | 0 | 0 | 264526.91
7/1/2003 Total | 0 | 0 | 0 | 0 | 276106.85 | 0 | 0 | 0 | 0 | 276106.85
8/1/2003 Total | 0 | 0 | 0 | 0 | 262565.91 | 0 | 0 | 0 | 0 | 262565.91
9/1/2003 Total | 0 | 0 | 0 | 0 | 261591.46 | 0 | 0 | 0 | 0 | 261591.46
10/1/2003 Total | 0 | 0 | 0 | 0 | 285381 | 0 | 0 | 0 | 0 | 285381
11/1/2003 Total | 0 | 0 | 0 | 0 | 234834.55 | 0 | 0 | 0 | 0 | 234834.55
12/1/2003 Total | 0 | 0 | 0 | 0 | 270801.44 | 0 | 0 | 0 | 0 | 270801.44
Grand Total | -85724.67 | 597407.93 | -476037.98 | 6554.12 | 7954280.18 | 37322.62 | -12363.78 | 45783.51 | -220456.32 | 7846765.689999999
Spreadsheet: 743586d1628606680-dynamically-fill-1-sheet-from-another-working-schedule-master-sample
Sheet: Pub-Page3

FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 18:30:00 | MAN UTD | LEEDS UTD
MOTOGP | 2021-08-14 00:00:00 | 19:20:00 | QUALIFYING | SPIELBERG
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | BURNLEY | BRIGHTON
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | CHELSEA | C PALACE
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | EVERTON | SOUTHAMPTON
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | LEICESTER | WOLVES
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 21:00:00 | WATFORD | A VILLA
RUGBY - INTERNATIONAL | 2021-08-14 00:00:00 | 22:00:00 | S AFRICA | ARGENTINA
FOOTBALL - PREM LGE | 2021-08-14 00:00:00 | 23:30:00 | NORWICH | LIVERPOOL
GAA - SFC - SF | 2021-08-15 00:00:00 | 00:00:00 | MAYO | DUBLIN
CRICKET - 100 | 2021-08-15 00:00:00 | 01:00:00 | INVINCIBLES | SPIRIT
FOOTBALL - C'SHIP | 2021-08-15 00:00:00 | 02:00:00 | [NAME] | SHEFFIELD UNITED
FOOTBALL - LGE CUP | 2021-08-15 00:00:00 | 18:00:00 | RAITH ROVERS | ABERDEEN
MOTOGP | 2021-08-15 00:00:00 | 19:00:00 | SPIELBERG
FOOTBALL - PREM LGE | 2021-08-15 00:00:00 | 20:00:00 | NEWCASTLE | WEST HAM
FOOTBALL - LGE CUP | 2021-08-15 00:00:00 | 21:00:00 | CELTIC | HEARTS
GAA - SFC - SF | 2021-08-15 00:00:00 | 21:30:00 | KERRY | TYRONE
FOOTBALL - PREM LGE | 2021-08-15 00:00:00 | 22:30:00 | TOTTENHAM | MAN CITY
NRL | 2021-08-15 11:00:00 | 11:00:00 | WARRIORS | BULLDOGS
NRL | 2021-08-15 13:05:00 | 13:05:00 | SHARKS | KNIGHTS
CRICKET - 100 | 2021-08-16 00:00:00 | 01:00:00 | ROCKETS | ORIGINALS
SNOOKER | 2021-08-16 00:00:00 | TBC | BRITISH OPEN
CRICKET - 100 | 2021-08-17 00:00:00 | 01:00:00 | BRAVE | INVINCIBLES
CRICKET - 100 | 2021-08-18 00:00:00 | 00:30:00 | SUPERCHARGERS | PHOENIX
FOOTBALL - C'SHIP | 2021-08-18 01:45:00 | 01:45:00 | BARNSLEY | LUTON TOWN
FOOTBALL - C'SHIP | 2021-08-18 01:45:00 | 01:45:00 | BLACKPOOL | COVENTRY CITY
FOOTBALL - C'SHIP | 2021-08-18 01:45:00 | 01:45:00 | HUDDERSFIELD | PRESTON N E
FOOTBALL - C'SHIP | 2021-08-18 01:45:00 | 01:45:00 | MILLWALL | FULHAM
FOOTBALL - C'SHIP | 2021-08-18 01:45:00 | 01:45:00 | PETERBOROUGH | CARDIFF CITY
FOOTBALL - C'SHIP | 2021-08-18 01:45:00 | 01:45:00 | [NAME] | STOKE CITY
Spreadsheet: 723317d1615631741-extracting-a-substring-extract-japan-alphabets-ans1
Sheet: Sheet1

 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
?たまねぎL大3 P
?たまねぎL大3 P 大
?たまMねぎL大3 P 大
Spreadsheet: 59621cc8-7008-49a8-8b20-1405e74f2b9f
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Birmingham Project Area Basin Overflow Control Plan Project, Amendment 3
 |  |  |  | X | Not applicable - Project involve study reports
Is this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  |  | 2005
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify source and amount.
 | If no, please identify source and amount of city funds.
 | AL-8181-807769-B, $20,100.00
If ordinance is for construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction):
 | Estimated lifespan of project in years
 | Estimated annual operating and maintenance costs
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please  provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed.
Reference Numbers: (Previously approved legislation): |  |  |  |  | 050096
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 858553d1707204714-calculate-number-of-months-datedif-shifting-month-aligw
Sheet: Sheet1

2023-02-01 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-02 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-03 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-04 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-05 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-06 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-07 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-08 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-09 00:00:00 |  |  | 12 |  | 2023-02-01 00:00:00 | 2024-01-01 00:00:00
2023-02-10 00:00:00 |  |  | 13 |  | 2023-02-01 00:00:00 | 2024-02-01 00:00:00
2023-02-11 00:00:00 |  |  | 13 |  | 2023-02-01 00:00:00 | 2024-02-01 00:00:00
2023-02-12 00:00:00 |  |  | 13 |  | 2023-02-01 00:00:00 | 2024-02-01 00:00:00
2023-02-13 00:00:00 |  |  | 13 |  | 2023-02-01 00:00:00 | 2024-02-01 00:00:00
2023-02-14 00:00:00 |  |  | 13 |  | 2023-02-01 00:00:00 | 2024-02-01 00:00:00
2023-02-15 00:00:00 |  |  | 12 |  | 2023-03-01 00:00:00 | 2024-02-01 00:00:00
2023-02-16 00:00:00 |  |  | 12 |  | 2023-03-01 00:00:00 | 2024-02-01 00:00:00
2023-02-17 00:00:00 |  |  | 12 |  | 2023-03-01 00:00:00 | 2024-02-01 00:00:00
 |  |  | Correct |  | Period
Spreadsheet: 841306d1693495881-counting-field-values-in-columns-where-each-field-can-have-1-or-more-values-test-1-
Sheet: Sheet1

ID | Testing Frequency | Owner
1 | Annual | Mark |  |  | 8 |  |  |  | Annual | Every 1 Year | Every 2 Years | Not Eligible
2 | Every 2 Years | Mary;Dog |  | Every 1 Year | 6 |  |  | Dog | 2 | 0 | 3 | 1
3 | Annual | Mark;Tim;Pizza;Dog |  | Every 2 Years | 4 |  |  | Mark | 5 | 4 | 1 | 2
4 | Every 1 Year | Pizza |  | Not Eligible | 4 |  |  | [NAME] | 0 | 0 | 2 | 0
5 | Every 1 Year | Mark;Tim |  |  |  |  |  | Pizza | 2 | 2 | 0 | 1
6 | Annual | Pizza;Sarh |  |  |  |  |  | [NAME] | 1 | 3 | 1 | 1
7 | Every 2 Years | [NAME] |  |  |  |  |  | Sarh | 1 | 0 | 0 | 1
8 | Every 2 Years | Dog;Mary |  |  |  |  |  | [NAME] | 3 | 1 | 1 | 1
9 | Every 1 Year | [NAME]
10 | Annual | [NAME]
11 | Not Eligible | [NAME]
12 | Every 1 Year | [NAME]
13 | Annual | [NAME]
14 | Not Eligible | [NAME]
15 | Every 2 Years | Dog;Tim
16 | Not Eligible | Dog;Mark
17 | Annual | Mark
18 | Every 1 Year | Pizza
19 | Annual | Mark;Tim
20 | Not Eligible | Pizza;Sarh
21 | Every 1 Year | [NAME]
22 | Annual | Dog
Spreadsheet: 719873d1613862927-weighted-lottery-with-unique-output-weighted-lottery-with-no-duplicates-knewton-
Sheet: Sheet1

Child | Assigned % | Cumulative % | Match | Rank | With Duplicates |  | Distinct
a | 0.05
b | 0.05
c | 0.05
d | 0.1
e | 0.1
f | 0.15
g | 0.2
h | 0.2
Spreadsheet: 852211d1702309351-delete-n-columns-to-the-right-literally-thousands-of-columns-copy-of-ztestdateimittausendenblattspalten
Sheet: Testblatt

F. | Testdatei | Total | Übertrag 1.1.2023 | Jan. | Feb. | Mär. | Apr. | Mai | Jun. | Jul. | Aug. | Sep. | Okt. | Nov. | Dez. | [NAME].
y | . |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
y | . |  |  | 0
y | .
y | . |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
y | .
y | .
y | .
n | .
Spreadsheet: 484061d1476100548-find-text-references-in-a-table-and-list-all-in-a-another-table-20161010-excelforum_ioncila
Sheet: Folha2

 | Table 1 |  |  | Table 2
 | ORDER | Schedules |  | ORDER | AGENDA | SCHEDULES
 | 12345 | Task 22-11-2016 Find Wally; Task 15-11-2016 Find Sally; Task 30-10-2016 Find Molly |  | 45678 | 2016-11-28 00:00:00 | Task 28-11-2016 Find Ford
 | 23456 | Task 20-11-2016 Find Charles; Task 05-11-2016 Find Charlize; Task 25-10-2016 Find Carly |  | 34567 | 2016-11-26 00:00:00 | Task 08-11-2016 Find Daizy
 | 34567 | Task 26-11-2016 Find Rose; Task 08-11-2016 Find Daizy; Task 01-11-2016 Find Tulip |  | 56789 | 2016-11-23 00:00:00 | Task 29-10-2016 Find Monkey
 | 45678 | Task 28-11-2016 Find Ford; Task 03-11-2016 Find Chevy; Task 29-10-2016 Find Tesla |  | 12345 | 2016-11-22 00:00:00 | Task 22-11-2016 Find Wally
 | 56789 | Task 23-11-2016 Find Bear; Task 20-10-2016 Find Lion; Task 29-10-2016 Find Monkey |  | 23456 | 2016-11-20 00:00:00 | Task 05-11-2016 Find Charlize
 | 67890 | Task 12-11-2016 Find Guitar; Task 06-11-2016 Find Drums; Task 30-10-2016 Find Bass |  | 12345 | 2016-11-15 00:00:00 | Task 30-10-2016 Find Molly
 |  |  |  | 67890 | 2016-11-12 00:00:00 | Task 12-11-2016 Find Guitar
 | Hi |  |  | 34567 | 2016-11-08 00:00:00 | Task 08-11-2016 Find Daizy
 | I need to know if there is a way to lookup for references "Task dd-mm-yyyy" in Table 1 and list them all in Table 2 as it shows (Text in red is only to highlight the reference I need) |  |  | 67890 | 2016-11-06 00:00:00 | Task 30-10-2016 Find Bass
 |  |  |  | 23456 | 2016-11-05 00:00:00 | Task 20-11-2016 Find Charles
 |  |  |  | 45678 | 2016-11-03 00:00:00 | Task 03-11-2016 Find Chevy
 |  |  |  | 34567 | 2016-11-01 00:00:00 | Task 01-11-2016 Find Tulip
 |  |  |  | 12345 | 2016-10-30 00:00:00 | Task 22-11-2016 Find Wally
 |  |  |  | 67890 | 2016-10-30 00:00:00 | Task 06-11-2016 Find Drums
 |  |  |  | 45678 | 2016-10-29 00:00:00 | Task 29-10-2016 Find Tesla
 |  |  |  | 56789 | 2016-10-29 00:00:00 | Task 23-11-2016 Find Bear
 |  |  |  | 23456 | 2016-10-25 00:00:00 | Task 05-11-2016 Find Charlize
 |  |  |  | 56789 | 2016-10-20 00:00:00 | Task 29-10-2016 Find Monkey
Spreadsheet: 69949d1270609472-matching-results-matching-results-lvsmr2-sdg10
Sheet: Sheet1

COL 1 |  | COL 2 |  | RESULTS |  |  |  |  |  | Today, 10:10 PM
001 |  | 001 |  |  |  |  |  |  |  | Matching Results - lvsmr2 - SDG10.xls
002 |  | 002 |  |  |  |  |  |  |  | Registered User   Join Date: 22 Jul 2009
003 |  | 005 |  |  |  |  |  |  |  | Location: Sydney, Australia
004 |  | 008 |  |  |  |  |  |  |  | MS Office Version:Excel 2003
005 |  | 014 |  |  |  |  |  |  |  | Posts: 6
006 |  | 021 |  |  |  |  |  |  |  | Matching Results
007 |  | 027 |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/724457-matching-results.html
008 |  | 028 |  |  |  |  |  |  |  | Hi everyone,
009 |  | 033 |  |  |  |  |  |  |  | If somebody could help me with the following it would be greatly appreciated.
010 |  | 035 |  |  |  |  |  |  |  | I have a list in Column A "COL 1" and another in C "COL 2".
011 |  | 039 |  |  |  |  |  |  |  | I then wish to have results in column E which show anything in COL 1 that does not appear in COL 2 shown here.
012 |  | 040 |  |  |  |  |  |  |  | I have attached an example with the shown results. Anything not clear let me know.
013 |  | 041 |  |  |  |  |  |  |  | Thanks heaps in advance.
014 |  | 042
015
016
017
018
019
020
021
022
023
024
025
026
027
028
029
030
031
032
033
034
035
036
037
038
039
040
041
042
043
044
045
Spreadsheet: mary_fischer__25625__1290
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 1290
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:  [NAME]
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 0c53187f-d51c-49e7-9a6a-c8a4fa305953
Sheet: PTOT data median

 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028
High (29) | 0.01099999994039536 | 0.01099999994039536 | 0.0118000004440546 | 0.008999999612569809 | 0.009700000286102295 | 0.01080000028014183 | 0.0130000002682209 | 0.01130000036209822 | 0.01150000002235174 | 0.01099999994039536 | 0.01130000036209822 | 0.01130000036209822 | 0.01250000018626451 | 0.0118000004440546 | 0.008999999612569809 | 0.009999999776482582 | 0.0118000004440546 | 0.0118000004440546 | 0.01229999959468842
Good (143) | 0.03350000083446503 | 0.03495000023394823 | 0.0324999988079071 | 0.02966669946908951 | 0.02975000068545341 | 0.03050000034272671 | 0.03530000150203705 | 0.0389166995882988 | 0.03880000114440918 | 0.03420000150799751 | 0.03449999913573265 | 0.03620000183582306 | 0.02749999985098839 | 0.02800000086426735 | 0.02899999916553497 | 0.02458330057561398 | 0.02999999932944775 | 0.03108330070972443 | 0.02816670015454292
Moderate (340) | 0.1642730012536049 | 0.1495644971728325 | 0.1403999999165535 | 0.1183499991893768 | 0.1293499991297722 | 0.1296999976038933 | 0.1348080039024353 | 0.1365000009536743 | 0.1180834993720055 | 0.1180999986827374 | 0.1079165004193783 | 0.1064334996044636 | 0.09591665118932724 | 0.1016819998621941 | 0.1008335016667843 | 0.1002500001341105 | 0.0963333509862423 | 0.09018750116229057 | 0.09308329969644547
Poor (137) | 0.2140000015497208 | 0.2119999974966049 | 0.1937000006437302 | 0.1759999990463257 | 0.1759999990463257 | 0.1700000017881393 | 0.1808999925851822 | 0.1599999964237213 | 0.1550000011920929 | 0.1500000059604645 | 0.1500000059604645 | 0.1560000032186508 | 0.1400000005960464 | 0.1321000009775162 | 0.1299999952316284 | 0.1265276670455933 | 0.12066700309515 | 0.12066700309515 | 0.1241670027375221
Bad (81) | 0.2599999904632568 | 0.2700000107288361 | 0.2099999934434891 | 0.2020000070333481 | 0.2300000041723251 | 0.2000000029802322 | 0.1881999969482422 | 0.1700000017881393 | 0.1717999950051308 | 0.1601999998092651 | 0.1700000017881393 | 0.1490000039339066 | 0.1420000046491623 | 0.1441670060157776 | 0.1449999958276749 | 0.1480000019073486 | 0.1283999979496002 | 0.125230997800827 | 0.125
Trend moderate
Trend poor
Trend bad
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36