tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 135670d1326174780-solved-unable-to-sort-by-date-after-vlookup-book2
Sheet: Sheet1

Login | FirstName | LastName | Date Created | AuditStr | Login Cleanse | Date Cleanse
gatcl | [NAME] | Gatto | 22/09/2009 02:44 PM | Create
spear | [NAME] | [NAME] | 22/09/2009 02:44 PM | Create
thokr | [NAME] | Thomasson | 22/09/2009 02:44 PM | Create
[NAME] | [NAME] | Whalen | 22/09/2009 02:44 PM | Create
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
yeoem | [NAME] | Yeoman | 24/09/2009 10:05 AM | Create
mashu | Huw | Mason | 24/09/2009 10:05 AM | Create
brola | Lauraine | Brown | 24/09/2009 10:05 AM | Create
freln | [NAME] | Frederiksen | 24/09/2009 10:05 AM | Create
simro | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
oshbr | Briony | [NAME] | 24/09/2009 10:05 AM | Create
metcr | [NAME] | Metters | 24/09/2009 10:05 AM | Create
[NAME] | [NAME] | [NAME] | 23/09/2009 10:05 AM | Create
walgh | [NAME] | Walters | 24/09/2009 10:05 AM | Create
hawbr | [NAME] | Hawtin | 24/09/2009 10:05 AM | Create
kergr | Greg | [NAME] | 24/09/2009 10:05 AM | Create
gooro | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
hargr | Greg | [NAME] | 24/09/2010 10:05 AM | Create
robjh | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
schst | [NAME] | Schoemaker | 24/09/2009 10:05 AM | Create
setba | Bagus | Setiadi | 24/09/2009 10:05 AM | Create
morka | [NAME] | Morgenstern | 24/02/2009 10:05 AM | Create
warjo | Jon | Warby | 24/09/2009 10:05 AM | Create
[NAME] | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
piegr | Greg | Pietsch | 24/09/2009 10:05 AM | Create
smibe | Barrie | [NAME] | 24/09/2009 10:05 AM | Create
hinst | [NAME] | [NAME] | 24/09/2009 10:05 AM | Create
bisst | [NAME] | Bisset | 01/06/2009 10:05 AM | Create
comst | [NAME] | Comino | 24/09/2009 10:05 AM | Create
comgr | Greg | Comber | 24/09/2009 10:05 AM | Create
Spreadsheet: 61538d1262433658-cross-check-names-and-associated-values-to-give-a-total-book1
Sheet: Sheet1

date | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
name | jo | [NAME] | jo | [NAME] | [NAME] | jo | [NAME] | jo | [NAME] | [NAME] | jo | [NAME] | jo | [NAME] | [NAME] | jo | [NAME] | jo | [NAME] | [NAME] | jo
lateness |  | 00:10:00 |  |  |  |  |  | 00:11:00 |  |  |  |  |  | 00:03:00 |  |  |  |  | 00:25:00
 | total time late
jo
[NAME]
[NAME]
Spreadsheet: 45639d1244458253-making-a-formula-to-automatically-fill-a-label-song-list-example
Sheet: CD Tabel

 | CD Nr. | 1 | Album Nr | 1
CD Nr. | CD Code | Author | Piece | Date | Album nr. | Track nr. | Title | Length
1 | CD01 |  |  |  | 1 | 01. | singing me1 | 07:30:00
 |  |  |  |  | 1 | 02. | singing me2 | 07:32:00
 |  |  |  |  | 1 | 03. | singing me3 | 08:32:00
2 | CD02 |  |  |  | 2 | 01. | singing me4 | 09:32:00
 |  |  |  |  | 2 | 02. | singing me5 | 10:32:00
3 | CD03 |  |  |  | 3 | 01. | singing me7 | 12:32:00
Spreadsheet: 269690d1381249209-index-match-or-maybe-a-differnt-formula-to-look-up-multiple-criteria-dsl-test
Sheet: Sheet1

[NAME] | Date | Code | Qty | RateBand | Price
AUR | 20131001 | DS2 | 15 | 5 | ?
AUR | 20131001 | DM1B | 1 |  |  |  | I want to be able to fill in the price (for one, so quanity doesn't matter).
AUR | 20131001 | DM4B | 1 |  |  |  | So it would need to say, if the code is DS2 (Col C) and Rate band 5 (Col E), then the price would be ??
AUR | 20131001 | DS1B | 12 |  |  |  | The pricing guide is on Sheet 2
AUR | 20131001 | DS1FIRE | 1
HUT | 20131001 | IADS4M | 4
HUT | 20131001 | IADSL12 | 54
HUT | 20131001 | IADSL99 | 120
HUT | 20131001 | IDU | 69
HUT | 20131001 | IDUC | 78
HUT | 20131001 | IDUPP | 4
HUT | 20131001 | IVD101 | 10
HUT | 20131001 | IVDS103 | 13
HUT | 20131001 | IVDS10V | 1
HUT | 20131001 | IVDS20 | 4
HUT | 20131001 | IVDS2M | 103
HUT | 20131001 | IVDS4M | 31
HUT | 20131001 | IVDS5 | 46
HUT | 20131001 | IVDSL12 | 17
HUT | 20131001 | IVDSL99 | 111
HUT | 20131001 | IWE | 21
HUT | 20131001 | IWE3 | 2
HUT | 20131001 | [NAME] | 1
HUT | 20131001 | IWE6E | 1
HUT | 20131001 | TVDS2M | 39
HUT | 20131001 | TVDS4M | 2
HUT | 20131001 | TVDSL12 | 19
HUT | 20131001 | [NAME] | 8
Spreadsheet: e4924fa0-8860-4a02-94f2-bcbd19ab6774
Sheet: ER - Schedule 1 QTD

Kraft Foods Inc. and Subsidiaries
Condensed Consolidated Statements of Earnings
For the Three Months Ended June 30,
(in millions of dollars, except per share data)  ([NAME])
 |  |  | As Reported (GAAP)
 |  |  | 2011 |  | 2010 |  | % Change Fav / (Unfav)
Net revenues |  |  | 13878 |  | 12253 |  | 0.133
Cost of sales |  |  | 9007 |  | 7559 |  | -0.192
 | Gross profit |  | 4871 |  | 4694 |  | 0.038
 | Gross profit margin |  | 0.351 |  | 0.383
Selling, general and administrative expenses |  |  | 3008 |  | 2933 |  | -0.026
Amortization of intangibles |  |  | 57 |  | 60 |  | 0.05
 | Operating income |  | 1806 |  | 1701 |  | 0.062
 | Operating income margin |  | 0.13 |  | 0.139
Interest and other expense, net |  |  | 441 |  | 439 |  | -0.005
 | Earnings from continuing operations before income taxes |  | 1365 |  | 1262 |  | 0.082
Provision for income taxes |  |  | 389 |  | 323 |  | -0.204
Effective tax rate |  |  | 0.285 |  | 0.256
 | Earnings from continuing operations |  | 976 |  | 939 |  | 0.039
Earnings from discontinued operations, net of income taxes |  |  | 0 |  | 0 |  | -
 | Net earnings |  | 976 |  | 939 |  | 0.039
Noncontrolling interest |  |  | 0 |  | 2 |  | 100.0%
 | Net earnings attributable to Kraft Foods |  | 976 |  | 937 |  | 0.042
Per share data:
 | Basic earnings per share attributable to Kraft Foods:
 | -  Continuing operations |  | 0.55 |  | 0.54 |  | 0.019
 | -  Discontinued operations |  | 0 |  | 0 |  | -
 | -  Net earnings attributable to Kraft Foods |  | 0.55 |  | 0.54 |  | 0.019
 | Diluted earnings per share attributable to Kraft Foods:
 | -  Continuing operations |  | 0.55 |  | 0.53 |  | 0.038
 | -  Discontinued operations |  | 0 |  | 0 |  | -
 | -  Net earnings attributable to Kraft Foods |  | 0.55 |  | 0.53 |  | 0.038
Average shares outstanding:
 | Basic |  | 1764 |  | 1747 |  | -0.01
 | Diluted |  | 1771 |  | 1752 |  | -0.011
Spreadsheet: 739670d1625849249-looking-to-build-a-schedule-table-for-football-team-using-both-visitor-and-home-columns-practice-coding-2021-prep-fb-master-schedule
Sheet: Sheet2

Date | Opponent | at | Home | at | Off-campus site | , | Time | 1=Conf | Conference
2021-08-20 00:00:00 | Baraboo | at | Onalaska |  |  | , | 7 p.m. | 0 | X-Non-conference
2021-08-27 00:00:00 | Madison East | at | Baraboo |  |  | , | 7 p.m. | 0 | X-Non-conference
2021-09-03 00:00:00 | Monona Grove | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME]
2021-09-10 00:00:00 | Baraboo | at | Stoughton |  |  | , | 7 p.m. | 1 | [NAME]
2021-09-17 00:00:00 | Mount Horeb/Barneveld | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME]
2021-09-24 00:00:00 | Baraboo | at | Fort Atkinson |  |  | , | 7 p.m. | 1 | [NAME]
2021-10-01 00:00:00 | Reedsburg | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME]
2021-10-08 00:00:00 | Baraboo | at | Sauk Prairie |  |  | , | 7 p.m. | 1 | [NAME]
2021-10-15 00:00:00 | Portage | at | Baraboo |  |  | , | 7 p.m. | 1 | [NAME]
Spreadsheet: 00ad30a3-1a01-4b82-af3f-b4cce7f8480c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 47. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (TAS), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413748X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413749A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413750K | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413751L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413752R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413753T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413754V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413755W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413756X | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413757A | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413758C | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 14a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | - | -
Index | 757 | 166 | 923
Europe/Other | 228 | 25 | 253
North America/Asia | 529 | 141 | 670
Other | 2 | 16 | 18
TOTAL | 759 | 182 | 941
Spreadsheet: 819155d1677249881-calculate-difference-between-2-datetimes-in-hours-excluding-weekends-and-holidays-working-hours-assignment
Sheet: josephteh

Requested | Solved | Hours Difference |  |  | Holidays |  | Shift Start Time | Shift End Time |  | Working Days
2022-08-05 14:30:00 | 2022-08-10 11:00:00 |  |  |  | 2022-08-08 00:00:00 |  | 10:00:00 | 19:00:00 |  | Monday to Friday
2022-08-19 09:43:00 | 2022-09-15 22:02:00 |  |  |  | 2022-08-25 00:00:00
2022-08-19 17:34:00 | 2022-09-01 15:06:00
2022-08-23 14:48:00 | 2022-08-31 17:03:00
2022-08-23 19:52:00 | 2022-09-15 22:01:00
2022-08-24 04:46:00 | 2022-09-14 22:45:00
2022-08-24 17:02:00 | 2022-09-02 17:31:00
2022-08-25 22:19:00 | 2022-08-30 13:21:00
2022-08-26 22:36:00 | 2022-08-31 16:23:00 |  |  |  |  | Question:- | I have 2 columns, one is for Requested and another is for Requested (column A) and another is for Solved (Column B). I want difference between solved and requested column in hours. Below are the conditions to calculate this. 1) [NAME] should exclude Saturday & Sundays as those are non-working days for us. 2) [NAME] should exclude Holiday list as shown in column F. 3) [NAME] should consider shift timing as working day instead of default 24 hours. 4) Shift timing can change anytime so that I puted it differently in cell H1 & I1 respectivly.
2022-08-26 23:46:00 | 2022-08-31 14:23:00
2022-08-27 01:22:00 | 2022-08-29 22:02:00
2022-08-27 01:28:00 | 2022-08-30 20:48:00
2022-08-27 01:31:00 | 2022-08-29 22:02:00
2022-08-27 01:34:00 | 2022-08-29 22:03:00
2022-08-27 01:38:00 | 2022-08-29 18:57:00
2022-12-26 22:48:00
2022-12-27 01:56:00 | 2022-12-29 13:01:00
2022-12-27 12:57:00 | 2022-12-28 20:30:00
2022-12-27 15:17:00 | 2022-12-27 18:38:00
2022-12-27 20:05:00 | 2022-12-28 13:14:00
2022-12-27 20:17:00 | 2022-12-28 14:46:00
2022-12-28 00:20:00 | 2022-12-28 13:24:00
2022-12-28 18:47:00 | 2022-12-28 19:13:00
2022-12-28 21:33:00 | 2022-12-28 21:56:00
2022-12-28 22:04:00 | 2022-12-28 22:12:00
Spreadsheet: 717123d1612494063-index-match-combination-issues-supplylistef-dexter2-
Sheet: Results

Invoice | Supply Name |  | Actual
Spreadsheet: 2a54a3ae-1275-4094-871c-caf8bf2ecc42
Sheet: Sheet1

Undergraduate Majors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Faculty of Business (BACC, BBA, and Business Combined Majors)
 |  | 2003-04 | 2004-05 | 2005-06 | 2006-07 | 2007-08 | 2008-09
 | Single | 570 | 657 | 625 | 651 | 648 | 655
 | Combined | 2 | 0 | 1 | 0 | 1 | 1
Year I | Sub-Total: | 572 | 657 | 626 | 651 | 649 | 656
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 572 | 657 | 626 | 651 | 649 | 656
 | Single | 430 | 605 | 564 | 540 | 534 | 595
 | Combined | 5 | 5 | 2 | 4 | 1 | 2
Year II | Sub-Total: | 435 | 610 | 566 | 544 | 535 | 597
 | Gen/Integ Studies | 0 | 0 | 0 | 0 | 0 | 0
 | Total: | 435 | 610 | 566 | 544 | 535 | 597
 | Single | 420 | 502 | 660 | 623 | 580 | 590
 | Combined | 3 | 2 | 4 | 2 | 4 | 5
Year III | Sub-Total: | 423 | 504 | 664 | 625 | 584 | 595
 | Gen/Integ Studies | 3 | 1 | 0 | 0 | 0 | 0
 | Total: | 426 | 505 | 664 | 625 | 584 | 595
 | Single | 519 | 343 | 364 | 472 | 462 | 433
 | Combined | 4 | 3 | 2 | 8 | 6 | 1
Year IV | Sub-Total: | 523 | 346 | 366 | 480 | 468 | 434
 | Gen/Integ Studies | 2 | 0 | 1 | 1 | 0 | 0
 | Total: | 525 | 346 | 367 | 481 | 468 | 434
 | Single | 1939 | 2107 | 2213 | 2286 | 2224 | 2273
 | Combined | 14 | 10 | 9 | 14 | 12 | 9
TOTAL: | Sub-Total: | 1953 | 2117 | 2222 | 2300 | 2236 | 2282
 | Gen/Integ Studies | 5 | 1 | 1 | 1 | 0 | 0
 | Total: | 1958 | 2118 | 2223 | 2301 | 2236 | 2282
Male |  | 1102 | 1214 | 1323 | 1385 | 1395 | 1443
Female |  | 856 | 904 | 900 | 916 | 841 | 839
Full-Time |  | 1465 | 1604 | 1647 | 1669 | 1601 | 1662
Part-Time |  | 493 | 514 | 576 | 632 | 635 | 620
Combined and General/Integrated Studies reflect the number of students enrolled in the B.A. (Honours) program majoring in business and another major. These B.A. programs do not have a co-op option.
Codes: | BACC -- ACCC, ACCN, ACSP; BBA -- FNCE, COMP, QUAN, FNHR,  MKTG, INBU, MGMT, MKGM, INMK, MKFN, ENTR, HMRS, HMMK, PADM, ADMI, ADMN. ADSN, ADSP, GASS, ACTG, ACIN
Spreadsheet: 827614d1682893589-vlookup-or-something-similar-example
Sheet: Sheet1

 | Table 1 |  |  |  | Table 2
 | Item | Cost |  |  | Item | Cost
 | A-B | 3 |  |  | B-c-D-909hfehf-sfkhdfh-f | 5
 | AAA-C | 4 |  |  | POPOD-fhdifheifhiehfiehfi | 6.5
 | B-c-D | 5 |  |  | BB-YUOO-diskdhish45-efd-434343 | 3.5
 | POPOD | 6.5 |  |  | A-B-eidfhidhf00909-9 | 3
 | BB-YUOO | 3.5 |  |  | AAA-C-ekfhidhf-4h4i4h | 4
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 021LS

021LS
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO ASSISTED | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 2009-08-10 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
LIDDY |  | 2009-04-08 00:00:00
Deemer |  | 2010-09-08 00:00:00
GENERAL ACCOUNT INFORMATION / NOTES
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 9c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Fixed-Float | 31642 | 75030 | 174458 | 155868 | 499560 | 271263 | 164463 | 25427 | 1397711
FRA | 68166 | 163619 | 211441 | 167498 | 4000 | - | - | - | 614724
OTHER* | 297200 | 101117 | 74583 | 85034 | 172410 | 75846 | 70902 | 11289 | 888381
TOTAL | 397008 | 339766 | 460482 | 408400 | 675970 | 347109 | 235365 | 36716 | 2900816
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, OIS, Swaption, and Basis.
Spreadsheet: 792969d1661247754-index-match-small-avoid-duplicates-book2-1-
Sheet: Sheet1

ABS |  |  |  |  |  |  |  |  |  | 41 |  |  | Name |  |  |  |  |  | Amount
ABS |  |  |  |  |  |  |  |  |  | -10 |  |  |  |  |  |  |  |  |  |  |  | -30
ABS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EEE | -24
ABS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SBS | -20
ABS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SBD | -11
ABS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABS | -10
ABS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CDC | 11
ABS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SDD | 21
SBS |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  | CDC | 22
SBS |  |  |  |  |  |  |  |  |  | -20 |  |  |  |  |  |  |  |  |  |  | SOM | 22
SBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SBS | 30
SBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABS | 41
SBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOM | 42
SBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EEE | 43
SBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SBD | 50
SBS
SDD |  |  |  |  |  |  |  |  |  | 21
SDD |  |  |  |  |  |  |  |  |  | -30
SDD
SDD
SDD
SDD
SDD
SDD
CDC |  |  |  |  |  |  |  |  |  | 11
CDC |  |  |  |  |  |  |  |  |  | 22
CDC
CDC
CDC
CDC
CDC
CDC
SBD |  |  |  |  |  |  |  |  |  | 50
SBD |  |  |  |  |  |  |  |  |  | -11
SBD
SBD
SBD
SBD
SBD
SBD
SOM |  |  |  |  |  |  |  |  |  | 42
SOM |  |  |  |  |  |  |  |  |  | 22
SOM
SOM
SOM
SOM
SOM
SOM
EEE |  |  |  |  |  |  |  |  |  | 43
EEE |  |  |  |  |  |  |  |  |  | -24
EEE
EEE
EEE
EEE
EEE
EEE
Spreadsheet: louise_kitchen__22538__Consolidated BCP List
Sheet: EGM

ENRON GLOBAL MARKETS - TRADERS LISTING
Operations - Risk Management |  |  |  | Weather
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | S Ramachandran
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
[NAME] |  |  |  | [NAME]
Reno [NAME] |  |  |  | [NAME]
[NAME]
[NAME] |  | 10 |  |  | 8
Freight
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
 |  | 11
Coal/Emissions
[NAME]
[NAME]
[NAME] |  |  | Weather
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] |  | 8
LNG
[NAME]
[NAME] |  | 2
Crude & Products
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Wade Hicks
[NAME]
[NAME]
Friche
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] (Logistics)
[NAME]
[NAME]
[NAME]
[NAME] |  | 32
TOTAL =
Spreadsheet: 832082d1686110798-identify-hostname-by-finding-from-a-string-of-ip-address-in-a-cell-s666-pq-identify-hostname-by-finding-from-a-string-of-ip-address-in-a-cell
Sheet: Sheet1

Data
Hostname | IP address | Status
Hostname1 | Upstream 10.145.1888.0 Downstream 10.16.123.423 Backup 50.45.778.777 Management 11.18.142.785 | Decom
Hostname2 | 11.12.184.35 (U) 12.17.77.47 (B) 13.122.77.45 (M) | Active
Hostname3 | 11.14.22.56  12.15.99.56  13.16.177.36  14.17.188.36 | Pending Decom
Need a Solution to find hostname from below IP addreass
IP address Given | Need to find the hostname | Status |  | IP address Given | Host
10.16.123.423 |  |  |  | 10.16.123.423 | Hostname1
13.122.77.45 |  |  |  | 13.122.77.45 | Hostname2
12.15.99.56
Spreadsheet: 69292d1269846725-conditional-if-circular-pattern
Sheet: Export 6 Mnths

 |  |  |  |  |  |  |  |  |  | These figures in columns A-I originate from an import, column J originates from a simple formula.
22 | 28 | 42 | 345 | 432 | 567 | 1034 | 1235 | 1400
1 | 43 | 455 | 490 | 564 | 986 | 1050 | 1109 | 1398
56 | 87 | 95 | 213 | 986 | 1043 | 1109 | 1387 | 1465
22 | 42 | 43 | 87 | 986 | 1034 | 1109 | 1235 | 4500 | 2010-03-01 00:00:00
Spreadsheet: 471802d1469197239-identify-min-value-with-two-conditions-in-a-different-worksheet-copy-of-formula-for-min-with-conditions-in-two-sheets-ndm
Sheet: Data

 | Item | Location | Amount
 | Coke | North | 10
 | Pepsi | East
 | Wafers | West
 | Chocolates | South
 | Waffles | West
 | Cereal | East
 | Nuts | South
 | Coke | North
 | Pepsi | East
 | Wafers | South
 | Chocolates | East
 | Waffles | West
 | Cereal | South
 | Nuts | North
 | Coke | East
 | Pepsi | South
 | Wafers | West
 | Chocolates | East
 | Waffles | South
 | Cereal | North
 | Nuts | East
 | Coke | South
 | Pepsi | North
 | Wafers | West
 | Chocolates | West
 | Waffles | South
 | Cereal | North
 | Nuts | East
 | Coke | South
 | Pepsi | West
 | Wafers | North
 | Chocolates | South
 | Waffles | East
 | Cereal | East
 | Nuts | South
 | Coke | East
 | Pepsi | West
 | Wafers | North
 | Chocolates | South
 | Waffles | East
 | Cereal | North
 | Nuts | West
 | Cereal | North
 | Nuts | South
Spreadsheet: 850940d1701247401-excel-indirect-demotest
Sheet: Summary

Fund | 1 Week | 1 Month | 3 Month | 6 Month | YTD | 1 Year | 2 Year | 3 Year | 5 Year |  | Average
Quant Small Cap Fund
Motilal Oswal Midcap Fund
JM Flexicap Fund
Spreadsheet: 804618d1668185032-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-dans-driver-list-dz081699-
Sheet: 930

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
[NAME] | [NAME] |  |  | n/a | n/a | n/a | n/a | 91 | 0.83 | 98 | 0.33
[NAME] | Degner |  |  | n/a | n/a | 88 | 1.13 | 88 | 1.47 | n/a | n/a
[NAME] | [NAME] |  |  | n/a | n/a | n/a | n/a | n/a | n/a | 79 | 1.98
[NAME] | Luth |  |  | 93 | 0.85 | 94 | 0.74 | 95 | 0.65 | 94 | 0.76
Nathan | Maly |  |  | 90 | 1.16 | 86 | 1.49 | 87 | 1.41 | 88 | 1.47
[NAME] | [NAME] |  |  | 88 | 0.82 | 86 | 0.9 | 87 | 1.06 | 92 | 0.99
Stevi | [NAME] |  |  | n/a | n/a | 95 | 0.58 | n/a | n/a | n/a | n/a
[NAME] | [NAME] |  |  | 92 | 0.75 | 90 | 1.48 | 92 | 1.18 | 90 | 1.23
Vera | Wildeman |  |  | 98 | 0.2 | 96 | 0.41 | 95 | 0.49 | 95 | 0.45
 | Store Average
Spreadsheet: 833617d1687150914-filter-with-dynamic-number-of-conditions-nested-list-formula-example-ans2
Sheet: Sheet1

Problem: Use a formula to find the count of unique Countries selected by dynamically parsing the required keys from a single text field.
Manual example:  1. Parse the keys from each yellow cell (this list of keys can be arbitrarily long) 2. Get only blue rows with one of the desired keys 3. Select all Countries for these rows 4. [NAME], then count the countries
Key | Country |  | Sample Combined Key Conditions |  |  | Expected
CAT | Aruba |  | CAT,BAM |  |  | 5
CAT | Scuba |  | BAM | 4 |  | 4
CAT | Pine |  | CATER | 1 |  | 1
CAT | Palm
CAT | Cove
CATER | Aruba
SAM | Palm
SAM | Cove
BAM | Scuba
BAM | Pine
BAM | Palm
BAM | Cove
Spreadsheet: 775761d1649309573-how-to-get-the-data-of-column-c-from-the-more-to-less-repeated-column-a-help407
Sheet: Sheet1

DATA
3 |  | 0 |  |  |  |  |  | 5
 |  | 3 |  |  | 3 |  | 3 | 5
 |  | 5 |  |  | 5 |  | 5 | 4
 |  | 6 |  |  | 6 |  | 6 | 3
 |  | 4 |  |  | 4 |  | 4 | 2
4 |  | 8 |  |  | 8 |  | 8 | 2
 |  | 2 |  |  | 2 |  | 2 | 1
 |  | 7 |  |  | 7 |  | 7 | 1
5
0
0
3
8
2
0
8
5
7
6
5
0
3
6
4
5
0
3
6
3
Spreadsheet: sara_shackleton__36628__non terminated deals
Sheet: Sheet1

Counterparty | RMT or ENA | Date of Master Agreement | Cash Collateral -  Held/(Posted) | Accounts Receivable | Accounts Payable | Net AR and AP | Infinity MTM Valuation as 3/18/2002 | RATE AND CURRENCY | GLOBAL LIQUIDS | ENA | EW - WTI PREPAY | WEATHER | EMMISSION SO2 | TOTAL ENRON TRADING COUNTERPARTY EXPOSURE
[NAME] Treasure LLC | ENA | 1999-12-17 00:00:00 |  |  |  |  | 2176513.29 | 2176513.29
Brazos VPP Limited Partnership | ENA | 2000-12-27 00:00:00 |  |  |  |  | 1310114.56 | 1310114.56
Dakota LLC | ENA | 1998-12-15 00:00:00 |  |  |  |  | 108793.65 | 108793.65
Destec Properties Limited Partnership |  | ?? |  |  |  |  | -23611825.18 | -23611825.18
EMP Echo LLC | ENA | Deemed ISDA |  |  |  |  | 292919.18 | 292919.18
Joint Energy Development Investments II Limited Partnership | ENA | 1998-03-15 00:00:00 |  |  |  |  | 8104550.04 | 8104550.04