tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40499d1238797408-display-data-in-last-cell-that-if-is-true-credit-card-payment-calculator-1
Sheet: Card 1

Star Card
Beginning Amount | 12000 |  | First Payment
Interest Rate | 0.13 |  | Interest Paid
Min Payment | 150 |  | Pay off Date
Month | Beginning Balance | Interest | Principle Paid | Ending Balance | Min Payment | Actual Payment | Purchase Amount
Spreadsheet: 2d638337-163e-4500-8b92-3a9203feab2e
Sheet: Sheet1

Release: Financial Soundness Indicators | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=238
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-04 5:02 PM CST
 | Real-Time | Period
Name: | Start | End
Financial Soundness Indicators | 2011-11-01 00:00:00 | Current
Link:
http://fsi.imf.org/ | 2011-11-01 00:00:00 | Current
Source:
International Monetary Fund | 2011-11-01 00:00:00 | Current
Notes:
The Financial Soundness Indicators (FSIs) were developed by the IMF, | 2011-11-01 00:00:00 | Current
together with the international community, with the aim of supporting
macroprudential analysis and assessing strengths and vulnerabilities
of financial systems.
The website, hosted by the Statistics Department of the IMF,
disseminates data and metadata on selected FSIs provided by
participating countries. For a description of the various FSIs, as
well as the consolidation basis, consolidation adjustments, and
(http://fsi.imf.org/misc/FSI%20Concepts%20and%20Definitions.pdf). The
Statistics Department will steadily increase the number of countries
reporting FSIs for dissemination on this site.
Reporting countries compile FSI data presented on this website by
using different methodologies, which may also vary for different
points in time for the same country. Users are advised to consult the
accompanying [NAME] (http://fsi.imf.org/CountryList.aspx) to conduct
more meaningful cross-country comparisons or to assess the evolution
of a given FSI for any of the countries. For a customized search of
the database please use the the query builder
(http://elibrary-data.imf.org/QueryBuilder.aspx?s=322&key=1445284&f=1&ts=1&ys=2002&ye=2011&ms=1&me=12&ds=1&de=31&did=323&id=195)
in IMF eLibrary Data.
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-11-01 00:00:00
2012-02-08 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-06-29 00:00:00
2012-08-02 00:00:00
2012-10-01 00:00:00
2012-11-15 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-01 00:00:00
2013-11-01 00:00:00
2013-12-02 00:00:00
Spreadsheet: 85222d1285258967-array-formula-or-pivot-table-array-formula-or-pivot-table-test-file-1-
Sheet: Sheet5

Raw data
Retrieved from an external database
Cons Unit | Partner Unit | Item | Amt
10 | 15 | 11800000 | -272.27
10 | 15 | 47300000 | 261513401.17
10 | 17 | 11800000 | 48957613.76
10 | 17 | 47300000 | 766213.74
10 | 20 | 11800000 | 2449716.09
10 | 21 | 11800000 | -100
44 | 22 | 11800000 | -527073.75
44 | 22 | 47300000 | -9419418.92
44 | 23 | 11800000 | 561690.62
200 | 25 | 11800000 | 1081239.75
200 | 25 | 47300000 | -8938860.19
200 | 30 | 11800000 | -257101814
200 | 30 | 11800010 | 105023650.44 |  | You will need to change all Cons Unit data to Text for the above to work.
200 | 30 | 47300000 | -7153762792.75
Result wanted
If subtotal by Cons Unit/Partner Unit is a negative number, show total only: |  |  |  |  |  | Amt | (Multiple Items)
Cons Unit | Partner Unit | Amt |  |  |  | Sum of Amt
10 | 21 | -100 |  |  |  | Cons Unit | Partner Unit | Total
44 | 22 | -9946492.67 |  |  |  | 10 | 15 | -272.27
200 | 25 | -7857620.439999999 |  |  |  |  | 21 | -100
200 | 30 | -7305840956.31 |  |  |  | 44 | 22 | -9946492.67
 |  |  |  |  |  | 200 | 30 | -7410864606.75
 |  |  |  |  |  |  | 25 | -8938860.19
 |  |  |  |  |  | Grand Total |  | -7429750331.88
Spreadsheet: 151307d1334859571-excel-2007-need-help-combining-vlookup-with-if-examples
Sheet: Schedule

Week | Project | Activity | Status
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
Spreadsheet: 221422d1363548791-export-convert-excel-data-to-calendar-one-month-calendar
Sheet: Sheet1

One month calendar with Milestone
Subject | Start Date | Start Time | End Date | End Time | Description | Location
Weekly status meeting 12 | 2013-03-11 00:00:00 | 09:00:00 | 2013-03-11 00:00:00 | 10:00:00 | Project status report meeting for team members to bring up issues related to the Project. | Conforence room 01
Negotiation meeting Legal | 2013-03-15 00:00:00 | 10:00:00 | 2013-03-15 00:00:00 | 12:00:00 | Negotiation was successful. Contract workers agreed to return to work. | Conforence room 01
Milestone | 2013-03-18 00:00:00 | 09:00:00 | 2013-03-18 00:00:00 | 09:30:00 | Contract workers return to work. Project sponsor called for full force of Project restart. | Construction Site
Weekly status meeting 13 | 2013-03-18 00:00:00 | 10:00:00 | 2013-03-18 00:00:00 | 11:00:00 | Project status report meeting for team members to bring up issues related to the Project. | Conforence room 01
Leadership meeting | 2013-03-19 00:00:00 | 10:00:00 | 2013-03-19 00:00:00 | 11:00:00 | Project Manager and team members meeting with Project Sponsor/Executive reporting Project Progressess. | Conforence room 01
Weekly status meeting 14 | 2013-03-25 00:00:00 | 09:00:00 | 2013-03-25 00:00:00 | 10:00:00 | Project status report meeting for team members to bring up issues related to the Project. | Conforence room 01
Weekly status meeting 15 | 2013-04-01 00:00:00 | 09:00:00 | 2013-04-01 00:00:00 | 10:00:00 | Project status report meeting for team members to bring up issues related to the Project. | Conforence room 01
Spreadsheet: kim_ward__20826__Glendale Loads & Generation Assets
Sheet: Gas Unit Start-up Costs

Reference for:
 | Month of NOVEMBER 1999 |  | GENERATING   UNITS
Fuel: | 3.46 | CITY OF [NAME]GRAYSON POWER PLANT
 | $/MMBTU | OPERATING CHARACTERISTICS OF UNITS
Item | Parameter Description | UNIT # 3 | UNIT # 4 | UNIT # 5 | UNIT # 6 | UNIT # 7 | UNIT # 8A | UNIT # 8BC
 |  |  |  |  |  |  | (Combined Cycle Units)
1 | Nameplate Capability - Net MW | 19 | 44 | 42 | 18 | 21 | 32 | 63
2 | Operating Minimum -  Net MW | 6 | 12 | 12 | 10 | 14 | 20 | 40
 |  | 11 with LFG | 15 with LFG | 15 with LFG
3 | Ramp Rate Capability (MW/Hr) | 14 | 24 | 24 | 18 | 23 | 20 | 40
4 | Minimum UP Time if committed, [NAME] | 24 | 24 | 24 | 0 | 0 | 4 | 4
5 | Min. DOWN Time if decommitted, [NAME] | 12 | 12 | 12 | 0.5 | 0.25 | 0.5 | 0.5
6 | Cool-Down Time,  [NAME]. | 2 | 2 | 2 | 0.5 | 0.5 | 0.5 | 0.5
 | (from minimum load to zero-cooldown)
7 | Total Heat to Start Unit (to zero net load) | 150 | 300 | 300 | 8 | 8 | 47 | 125
 | in MMBTU
8 | Start Fuel Price/    $/MMBtu
 |  | NG | NG | NG | NG | NG | NG | NG
9 | Fuel Start Cost Component,  $/start(Fuel)
10 | Other Fixed Start-up Cost Component | (not available) | (not available) | (not available) | (not available) | (not available) | (not available) | (not available)
11 | Estimated cost of additional labor to start * | 100 | 100 | 100 | 50 | 50 | 50 | 50
 | (*Final cost depending on the manpower availability, check with Operations Supervisor)
12 | TOTAL START-UP COST (Items 9+10+11)=
Spreadsheet: 861918d1709745930-dynamic-drop-down-data-validation-using-indirect-and-or-index-formula-spilldates
Sheet: GraphAve

 |  |  |  |  |  |  | 2022-01-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B1 |  |  |  | B1DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B2 |  |  |  | B2DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B3 |  |  |  | B3DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B4 |  |  |  | B4DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B5 |  |  |  | B5DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B6 |  |  |  | B6DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B7 |  |  |  | B7DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B8 |  |  |  | B8DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B9 |  |  |  | B9DatesD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B90 |  |  |  | B10DatesD
Spreadsheet: 823506d1679994870-number-of-suppliers-grouped-and-not-grouped-book2
Sheet: Sheet1

Logistics
[NAME]
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Supplier 7
Supplier 8
Supplier 9
Supplier 10
Supplier 11
Supplier 12
Supplier 13
Supplier 14
Supplier 15
Supplier 16
Supplier 17
Supplier 18
Logistics/Undefined
Supplier 1
Movable Material Handling Equipment
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 17

Fixtures | Week 17 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  |  |  |  | Weekly Total
Spreadsheet: hunter_shively__12682__11-16 Enovate
Sheet: ENOVATE DPR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As of November 16, 2001
 |  |  |  |  |  |  |  | In thousands (000's)
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD
ENOVATE |  |  |  |  |  |  |  |  |  |  |  | -696.6439339459968 | 465.8994339540196 | 1169.898761822016 | -3037.101238177984 | -3036.910238177984
GAS TRADING |  | -7.87581959198265 | 10 Bcf |  | -5.708152300726952 | 20 Bcf |  | 1433.3376195787 |  | 2000 |  | -696.6439339459968 | 465.8994339540196 | 1169.898761822016 | -3037.101238177984 | -3036.910238177984
Short Term Trading |  | -0.5887336682999997 |  |  |  |  |  | 1433 |  | 2000 | -697 | -696.6439339459968 | 465.8994339540196 | 1169.898761822016 | -3037.101238177984 | -3036.910238177984
Long Term Trading |  | -7.287085923682651 |  |  |  |  |  |  |  | -2000 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 0d2603a3-9f96-43e7-9bc7-5d47a2cf9923
Sheet: Consolidated Results

Lockheed [NAME]
Consolidated Statements of Earnings1
(unaudited; in millions, except per share data)
 |  | Quarters Ended
 |  | March 30, 2014 |  | March 31, 2013
Net sales |  | 10650 |  | 11070
Cost of sales |  | -9279 |  | -10029
Gross profit |  | 1371 |  | 1041
Other income, net |  | 61 |  | 78
Operating profit |  | 1432 |  | 1119
Interest expense |  | -86 |  | -92
Other non-operating income (expense), net |  | 2 |  | -2
Earnings before income taxes |  | 1348 |  | 1025
Income tax expense |  | -415 |  | -264
Net earnings |  | 933 |  | 761
Effective tax rate |  | 30.8 | % | 25.8 | %
Earnings per common share
Basic |  | 2.92 |  | 2.37
Diluted |  | 2.87 |  | 2.33
Weighted average shares outstanding
Basic |  | 319.1 |  | 321.7
Diluted |  | 325.1 |  | 326.3
Common shares reported in stockholders' equity at end of period |  | 315 |  | 318
1 The Corporation closes its books and records on the last Sunday of the calendar quarter to align its financial closing with its business
processes, which was on March 30 for the first quarter of 2014 and March 31 for the first quarter of 2013. The consolidated financial
statements and tables of financial information included herein are labeled based on that convention. This practice only affects interim
periods, as the Corporation's fiscal year ends on Dec. 31.
Spreadsheet: e7afcb22-d8ad-4c51-926b-554f297ed683
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7849 | 40979 | [NAME] | [NAME] | GBR | 66 | 00:16:57 | 00:01:31 | [NAME] | 00:01:17 | 00:38:05 | 1 | 02:15:53
Spreadsheet: chris_germany__1937__ENA-Reliant Prepay
Sheet: Daily Activity

ENA Purchases from Reliant - February 2002
For deliveries on FGT Zone 2 & 3
[NAME] |  | [NAME][PHONE]     [EMAIL]
Backup ENA Trader |  | [NAME]  [PHONE]  [EMAIL]
[NAME] |  | [NAME]  [EMAIL]
[NAME] |  | [NAME][PHONE]  [EMAIL]
[NAME] |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
 | Date | Volume | Price [NAME] | GD Post | Price | Total |  | Prepayments | Balance
Wed | 2002-02-06 00:00:00 | 0 |  | 0 | 0 |  |  | 22500
Thu |  | 2000 | [NAME] | 2.155 |  |  |  | 0
Fri |  | 2000 | [NAME] | 2.17 |  |  |  | 20000
Sat |  | 0 | [NAME] | 2.215 |  |  |  | 0
Sun |  | 0 | [NAME] | 2.215 |  |  |  | 0
Mon |  | 2000 | [NAME] | 2.215 |  |  |  | 0
Tue |  | 2000 | [NAME] | 2.23 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.4 |  |  |  | 0
Thu |  | 2000 | [NAME] | 2.365 |  |  |  | 26000
Fri |  | 2000 | [NAME] | 2.265 |  |  |  | 0
Sat |  | 0 | No activity | 2.175 |  |  |  | 0
Sun |  | 0 | No activity | 2.175 |  |  |  | 0
Mon |  | 0 | No activity | 2.175 |  |  |  | 0
Tue |  | 0 | No activity | 2.175 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.305 |  |  |  | 0
Thu |  | 2000 | [NAME] | 2.43 |  |  |  | 10000
Fri |  | 2000 | [NAME] | 2.38 |  |  |  | 0
Sat |  | 0 | No activity | 0 |  |  |  | 0
Sun |  | 0 | No activity | 0 |  |  |  | 0
Mon |  | 0 | No activity | 0 |  |  |  | 0
Tue |  | 2000 | [NAME] | 2.415 |  |  |  | 0
Wed |  | 2000 | [NAME] | 2.515 |  |  |  | 0
Thu |  | 2000 | [NAME]* | 2.55 |  |  |  | 19000
 | Sum |  | Sitara Deal #1196673
 | **  Estimated Gas Daily Midpoint used for flow date indicated.
Spreadsheet: 795469d1662712761-how-to-get-match-to-return-the-location-of-an-n-a-value-in-an-array-match_na_sample-hd-corrected
Sheet: EE

EEID | last name | first name | work state |  | [NAME] |  | Match(NA() | ifna(Match... | [NAME] | ifna | Filter | Index | Transposed list of names
A023 | GALLUZZO | [NAME] | CA |  |  |  |  |  |  |  |  |  |  | GOODWIN | BAILEY
A046 | HAMBLIN | LISA | MA |  | 24 |  | #N/A | 24 | #N/A | 0 | 6 | GOODWIN
A140 | LECCESE | CHRISTINE | NV |  | 31 |  | #N/A | 31 | #N/A | 0 | 10 | BAILEY
A213 | COTTERELL | SANDRA | XX |  | #N/A |  | #N/A | 105 | 4 | 4
A586 | STANKIE | ANTHONY | AZ |  | 3 |  | #N/A | 3 | #N/A | 0 |  | HD
A587 | GOODWIN | DANIEL |  |  | #N/A |  | #N/A | 107 | 6 | 6
A865 | PONGNON | SHARON | MA |  | 24 |  | #N/A | 24 | #N/A | 0 |  | GOODWIN
A058 | MCDONAG | PATRICK | MA |  | 24 |  | #N/A | 24 | #N/A | 0 |  | BAILEY
A068 | HUO | ZHENGH | MA |  | 24 |  | #N/A | 24 | #N/A | 0
A193 | BAILEY | SHEILA |  |  | #N/A |  | #N/A | 111 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  | HD
 | I expected H14 to return "4": |  |  |  |  |  |  |  |  |  |  | 6
 | So I tried [NAME] as an experiment: |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  | #N/A
Spreadsheet: fd5e2382-7fe7-4e09-a56e-6bcc251c89e9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
NAGW | Test | NAGW | Hexosaminidase A and Total Hexosaminidase, Leukocytes | Hexosaminidase A and Total, WBC | Heat Inactivation, Fluorometric, Semiautomated | Yellow-Top (ACD) Tube: ACD |  |  | 10 | mL | [NAME] must arrive within 96 hours of draw to be stabilized. Draw specimen Monday through Thursday only and not the day before a holiday. [NAME] should be drawn and packaged as close to shipping time as possible.   Container/Tube: Preferred: Yellow top (ACD solution B) Acceptable: Yellow top (ACD solution A) [NAME]: 6 mL Collection Instructions: Do not transfer blood to other containers. Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	Specimens >96 hours old | HEXOSAMINIDASE TOTAL < or =15 years: > or =20 nmol/min/mg > or =16 years: 16.4-36.2 nmol/min/mg   HEXOSAMINIDASE PERCENT A < or =15 years: 20-80% of total > or =16 years: 63-75% of total | Monday, Thursday, Friday; 8 a.m. (not reported on Saturday or Sunday) Specimens are stabilized Monday through Sunday | 4 days | 8 days | 2 | 83080 |  |  |  |  | Rochester
NAGW | [NAME] | ACDZ | [NAME] ACD |  |  |  | Refrigerated | 4 days
NAGW | Result | 8775 | Hexosaminidase Total, WBC | Hexosaminidase Total, WBC | Numeric |  |  |  |  | nmol/min/mg |  |  |  |  |  |  |  |  |  | 24075-4 | Beta-N-acetylhexosaminidase.A:CCnt:Pt:WBC:Qn:
NAGW | Result | 2294 | Hexosaminidase Percent A, WBC | Hexosaminidase Percent A, WBC | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 23825-3 | Beta-N-acetylhexosaminidase.A/Beta-N-acetylhexosaminidase.total:CFr:Pt:WBC:Qn:
NAGW | Result | 2284 | Interpretation (NAGW) | Interpretation (NAGW) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
NAGW | Result | 35029 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 814404d1674351532-need-to-sum-in-a-different-sheet-using-titles-in-current-sheet-to-choose-other-sheets-test-3-
Sheet: CLAIM MANAGEMENT 2023FY

APR |  | 3
 |  | 14
 |  | 84
 |  | 90
 |  | 74
MAY |  | 2
 |  | 56
 |  | 34
 |  | 1
 |  | 2
 |  | 3
 |  | 49
 |  | 100
Jun |  | 91
 |  | 98
Spreadsheet: 788332d1658407946-max-value-in-a-row-max-value
Sheet: Blad1

ARTICLENR | NR of purchases |  |  | Article nr | Highest nr of purchases
1 | 3
2 | 5
3 | 2
4 | 56
5 | 23 |  |  | THIS IS THE RESULT i want to GET
6 | 12
7 | 17
8 | 27
9 | 3
10 | 6
Spreadsheet: 699704d1602711847-find-most-recent-start-date-in-a-list-of-date-ranges-constrained-test
Sheet: Sheet3

Data: |  |  |  |  |  |  |  | Seeking formula(s) to compute column L (currently hard coded)
Event ID | Item Number | Brand code | Item Desc. | Start Date | End Date |  |  | Item Number | Brand code | Item Desc. | Start Date | Notes
1 | 1510 | TFRKY | TEMPEH SESAME GARLIC | 2018-10-21 00:00:00 | 2018-12-29 00:00:00 |  |  | 1510 | TFRKY | TEMPEH SESAME GARLIC | 2018-10-21 00:00:00
2 | 7011 | GRAND | SOAP BAR PINE TAR | 2020-05-10 00:00:00 | 2020-08-01 00:00:00 |  |  | 7011 | GRAND | SOAP BAR PINE TAR | 2020-09-06 00:00:00 | Event 4 & 5 are consecutive days
3 | 7011 | GRAND | SOAP BAR PINE TAR | 2020-08-02 00:00:00 | 2020-09-05 00:00:00 |  |  | 8131 | GRAND | SOAP BAR CHARCOAL | 2020-09-20 00:00:00 | Event 6 & 7 are consecutive days
4 | 7011 | GRAND | SOAP BAR PINE TAR | 2020-09-06 00:00:00 | 2020-09-26 00:00:00 |  |  | 4716 | WHSME | TURBINADO RAW ORG | 2020-06-14 00:00:00 | More than 1 event but not consecutive
5 | 7011 | GRAND | SOAP BAR PINE TAR | 2020-09-27 00:00:00 | 2020-10-10 00:00:00
6 | 8131 | GRAND | SOAP BAR CHARCOAL | 2020-09-20 00:00:00 | 2020-09-26 00:00:00
7 | 8131 | GRAND | SOAP BAR CHARCOAL | 2020-09-27 00:00:00 | 2020-10-10 00:00:00
8 | 4716 | WHSME | TURBINADO RAW ORG | 2020-05-17 00:00:00 | 2020-05-30 00:00:00
9 | 4716 | WHSME | TURBINADO RAW ORG | 2020-06-14 00:00:00 | 2020-06-20 00:00:00
Spreadsheet: 91939d1291636429-lookup-several-possible-matches-vlookup
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | CoCo (Wak) | Number of bighand
 |  |  |  |  |  |  |  |  |  |  | CoCo (Wak) | 138.1666666666667
 |  |  |  |  |  |  |  |  |  |  | CoCo (Hud) | 107.4
 |  |  |  |  |  |  |  |  |  |  | [NAME] (Pudsey) | 314.5
 |  |  |  |  |  |  |  |  |  |  | I have a lise that it pick and is = to L8
 |  |  |  |  |  |  |  |  |  |  | When [NAME] is picked I would like all the data displayed for that area in the exmaple its COCO.
 | Number of bighand
Clinical Negligence | 211
CoCo (Hud) | 107.4
CoCo (Wak) | 138.1666666666667
[NAME] (Pudsey) | 314.5 | 560.0666666666666
Commercial (Hal) | 181.6666666666667
Commercial (Hud) | 149.3333333333333
Commercial (Wak) | 149.3333333333333
Conveyancing (Hal) | 117.5
Conveyancing (Hud) | 41
Conveyancing (Mor) | 713
Conveyancing (Wak) | 347.6666666666667
Conveyancing (Pudsey) | 80
Employment (Hud) | 185.5
Employment (Wak) | 294.25
Family (Hal) | 289
Family (Hud) | 602
Family (Mor) | 269
Family (Pudsey) | 212.5
PI (Hal) | 481.5
PI (Hud) | 577.3333333333334
PI (Mor) | 562.5
PI (Wak) | 269
Probate (Hud) | 146
Probate (Mor) | 674
Probate (Wak) | 97.2
Spreadsheet: 881735d1729871250-data-change-from-vertical-to-horizantal-data-data-and-result
Sheet: Data

Sr.No. | Code | Primary Name | Relation Type | Name of relative(s) | Doc Number
1 | 1234 | [NAME] | Self | Self | ABCD1234Z
 | 56789 | Rikcy Ponting | Self | Rikcy Ponting | ABCD1234Y
 | 56789 | Rikcy Ponting | Spouse/Partner | [NAME] | [NAME]
 | 56789 | Rikcy Ponting | Father | [NAME] | ABCD1234W
 | 56789 | Rikcy Ponting | Mother In-Law | [NAME] | ABCD1234S
 | 56789 | Rikcy Ponting | Father In-Law | [NAME] | ABCD1234Q
 | 21 | Shane Watson | Self | Shane Watson | ABCD1234O
 | 21 | Shane Watson | Spouse/Partner | [NAME] | ABCD1234P
 | 21 | Shane Watson | Son | [NAME] | ABCD1234D
Spreadsheet: 699583d1602672369-trying-to-return-a-large-range-of-vlookup-based-on-dates-new-budget-sheet-2-2-
Sheet: PP Bills

 |  | Pay Day
PP 21
 | 1300 | Mortgage (3755): | ([NAME]) Auto
21 | 0 | Citi CC (3588): | 0
21 | 0 | Chase Freedom CC (9486): | 0
21 | 50.5 | Xfinity Internet: | (6307 Discover) Auto |  | EXPECTED RESULTS BELOW
29 | 140 | Rocky Power: | (Main Chase Checking) Auto
29 | 5.35 | Apple Music: | (6307 Discover) Auto |  | 21 | 0 | Citi CC (3588):
30 | 140 | Koda School: | [NAME] |  | 21 | 0 | Chase Freedom CC (9486):
 |  |  |  |  | 21 | 50.5 | Xfinity Internet: | (6307 Discover) Auto
 |  |  |  |  | 29 | 140 | Rocky Power: | (Main Chase Checking) Auto
 |  |  |  |  | 29 | 5.35 | Apple Music: | (6307 Discover) Auto
 |  |  |  |  | 30 | 140 | Koda School: | [NAME]
 |  |  |  |  | 1 | 1300 | Mortgage (3755): | ([NAME]) Auto
Spreadsheet: 839085d1691651568-give-space-and-without-space-in-name-book1
Sheet: Sheet1

 | Give Space |  |  |  |  | Result should come
JohnBrown |  |  |  |  |  | [NAME]
FrankHill |  |  |  |  |  | [NAME]
AnnClarieBrook |  |  |  |  |  | [NAME]
RonnieAnderson |  |  |  |  |  | [NAME]
 | Without Give Space |  |  |  |  | Result should come
[NAME] |  |  |  |  |  | JohnBrown
[NAME] |  |  |  |  |  | FrankHill
[NAME] |  |  |  |  |  | AnnClarieBrook
[NAME] |  |  |  |  |  | RonnieAnderson