tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 773446d1647867576-create-excel-function-that-gives-sum-with-two-conditions-boat1-pack
Sheet: Teste

Boat 1 |  |  |  |  |  |  |  |  |  |  |  | Bluestone 9H00
 | Grupo | Nome | Pack | Portal | A | C | B | [NAME] | Idioma | 09:00:00 | Pack | Portal | A | C | B
09:00:00 | 1 | Edgar | 2 | AIRBNB1 | 4 | 5 | 2 | 96 | EN |  | 2 | AIRBNB1
09:15:00 |  |  | 2 | AIRBNB1 | 2 |  |  |  |  |  |  | AIRBNB2
09:30:00 |  |  | 2 | AIRBNB2 | 5 |  |  |  |  | 11:00:00 | Pack | Portal | A | C | B
09:45:00 |  |  | 2 | AIRBNB1 | 6 |  |  |  |  |  | 3 | AIRBNB1
10:00:00 |  |  |  |  |  |  |  |  |  |  |  | AIRBNB2
10:15:00
10:30:00
10:45:00
10:55:00
Total
 | Grupo | Nome | Pack | Portal | A | C | B | [NAME] | Idioma
11:00:00 | 1 | [NAME] | 3 | AIRBNB1 | 5 |  |  | 96 | EN
11:15:00 |  |  | 3 | AIRBNB1
11:30:00 |  |  | 3 | AIRBNB2 | 9
11:45:00 |  |  | 3 | AIRBNB1
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
Total
Spreadsheet: 675426d1588276692-3d-vlookup-to-sum-values-across-multiple-sheets-3dvlookup
Sheet: 2019

 | January | February | March | April | May | June | July | August | September | October | November | December | YTD
[NAME] | 4 | 5 | 4 | 1 | 3 | 4 | 5 | 4 | 6 | 7 | 5 | 4
[NAME] | 5 | 7 | 8 | 9 | 5 | 7 | 2 | 5 | 6 | 7 | 8 | 4
Spreadsheet: 779448d1651781356-allocating-minutes-by-hour-of-day-test
Sheet: Sheet 1

Status | Case Duration Minutes | Actual Start Time | Actual Out Time | 00:00:01 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
Incorrect | 61 | 23:09:00 | 00:10:00
Correct | 601 | 13:09:00 | 23:10:00
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 7-073,074

 |  |  |  |  |  |  |  | 7-073   7-074
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 45ccc367-4983-4299-b370-2731199bcbf7
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
08/26/2011 | Volleyball | <b>NEW HAMPSHIRE (WVU Invitational)</b> | W, 3-0
08/26/2011 | Volleyball | <B>[NAME] (WVU Invitational)</B> | L, 2-3
08/27/2011 | Volleyball | <b>OHIO STATE (WVU Invitational)</b> | L, 0-3
08/28/2011 | Volleyball | <b>TOWSON (WVU Invitational)</b> | L, 1-3
08/28/2011 | Volleyball | <b>ROBERT MORRIS (WVU Invitational)</b> | W, 3-1
09/04/2011 | Volleyball | at Texas-San Antonio | L, 0-3
09/05/2011 | Volleyball | at Texas State | L, 0-3
09/06/2011 | Volleyball | at Baylor | L, 0-3
09/09/2011 | Volleyball | vs. Houston (Kentucky Invitational) | L, 1-3
09/09/2011 | Volleyball | vs. [NAME] (Kentucky Invitational) | L, 0-3
09/10/2011 | Volleyball | at Kentucky (Kentucky Invitational) | L, 0-3
09/23/2011 | Volleyball | <b>RUTGERS</b> | W, 3-0
09/25/2011 | Volleyball | <b>SETON HALL</b> | L, 1-3
09/30/2011 | Volleyball | at Villanova | L, 0-3
10/02/2011 | Volleyball | at Georgetown | L, 0-3
10/07/2011 | Volleyball | <b>DePAUL</b> | W, 3-0
10/09/2011 | Volleyball | <b>NOTRE DAME</b> | L, 0-3
10/15/2011 | Volleyball | <b>PITT</b> | W, 3-2
10/22/2011 | Volleyball | at Louisville | L, 1-3
10/23/2011 | Volleyball | at Cincinnati | L, 0-3
10/29/2011 | Volleyball | <b>SYRACUSE</b> | W, 3-0
10/30/2011 | Volleyball | <B>MARQUETTE</b> | L, 0-3
11/04/2011 | Volleyball | at Connecticut | L, 1-3
11/06/2011 | Volleyball | at St. John's | W, 3-0
11/12/2011 | Volleyball | <b>USF</b> | L, 2-3
11/25/2011 | Volleyball | at [NAME] | L, 1-3
Spreadsheet: 741311d1626962220-get-info-from-columns-u-and-ab-when-a-needed-text-copy-of-sample
Sheet: Sheet2

[NAME] | Item Name | Item Amount
Spreadsheet: benjamin_rogers__1051__Consolidated 6 Peaker-051800
Sheet: Caledonia

INCOME STATEMENT - CALEDONIA
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 579.4 | 573.6 | 567.9 | 562.2 | 556.6 | 551 | 534.5 | 518.5 | 492.6 | 877.7 | 694.8 | 493.7 | 365.7 | 365.7 | 365.7 | 365.7 | 365.7 | 365.7 | 365.7
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - CALEDONIA
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -591.2
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - CALEDONIA
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Paid-In-Capital
[NAME] (less Amortization of Power Contract)
Outstanding Debt
Shareholders Equity & Long Term Debt
State Franchise Tax Rate
State Franchise Tax Liability | 492.4801238999095 | 480.3397141299701 | 467.9943231198228 | 437.857295424058 | 405.6881304021575 | 372.831233126083 | 348.9261230525002 | 327.1730799926456 | 305.4075048566532 | 282.8888835877895 | 261.6387119719189 | 240.2514193410048 | 218.5330722672261 | 196.4264055404024 | 174.225701714002 | 157.8037108301546 | 147.0887364931533 | 136.376623645183 | 125.6694536434528 | 114.9691258121701
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 842685d1694695203-extract-data-from-rows-to-column-order-file_1
Sheet: Input

Order Number | Date | Name | Assigned by | Quantity | Acct No. | Description | Price | Quantity2 | Acct No.2 | Description2 | Price2 | Quantity3 | Acct No.3 | Description3 | Price3 | Quantity4 | Acct No.4 | Description4 | Price4
1 | 2023-09-14 00:00:00 | Deep | Vishal | 2 | M1 | Page | 2 | 3 | M4 | Pen | 1 | 2 | M5 | Pencil | 3
2 | 2023-09-14 00:00:00 | [NAME] | Vishal | 5 | M2 | File | 1 | 2 | M3 | Marker | 6
3 | 2023-09-14 00:00:00 | [NAME] | Vishal | 3 | M1 | Folder | 3 | 2 | M2 | Clip | 1 | 3 | M3 | Glue | 1 | 5 | M4 | Pen | 1
4 | 2023-09-14 00:00:00 | Mahdi | Vishal | 1 | M1 | Page | 5 | 3 | M4 | Work | 2
5 | 2023-09-14 00:00:00 | v | d | 10 | x1 |  | 10/ea | 11 | x2 |  | 3.73/kg
Spreadsheet: 488703d1478789787-payback-formula-payback
Sheet: NPV

 | Discount Rate |  | 0.08
 | Improvement 1 |  |  | 0
 |  |  |  | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
 | Costs (Investments out) |  |  | -20000
 | Benefits (compensation/savings) |  |  |  | 7000 | 7000 | 7000 | 7000 | 7000
 | Cash Flows
 | Discount Rate
 | Discounted Cash Value
 | NPV (From first Principles)
 | NPV |  |  |  |  |  | Payback
 | Check
Spreadsheet: 541000d1507063348-sum-only-visible-example-2-_pivot
Sheet: Sheet3

JOB NAME | VALUE | Main MFG. | Philips Total | DIST'S | CONTRACTORS | Status | FOLLOWUP INFO & NOTES | Quoted By
Warehouse | 130278 |  |  | A | J&J | Not Awarded |  |  |  | Status | Won
School 121 | 28979 |  |  | B | RYDALCH | Won
WCL Library | 153405 |  |  | A | CR | Won |  |  |  | Row Labels | Sum of VALUE
Alta Parking | 233683 |  |  | D | CR | Won |  |  |  | D | 483611
1st West Bank | 249928 |  |  | D | Rydalch | Won |  |  |  | Grand Total | 483611
 |  |  | Want to sort by Dist, [NAME], and Quoted by using drop down arrows
Spreadsheet: kate_symes__18477__New Notification Report 0101
Sheet: Jan 01 Changes

ALL PROPOSED CHANGES SINCE: |  | 2001-01-01 00:00:00
Old Record Information |  |  | New Record Information
Change Type | Old Name | CP ID | New Name
0 | 0 | 0 | 0
0 | 0 | 0 | 0
0 | 0 | 0 | 0
0 | 0 | 0 | 0
Spreadsheet: 97131d1296353945-nested-array-dividing-the-value-form-one-table-over-the-other-one-example-4
Sheet: Sheet1

Min | infected | 0.1645
Min | not infected | 0.1627
Min | some infected | 0.4666666666666667
[NAME] | infected | 1.8772
[NAME] | not infected | 1.353
[NAME] | some infected | 0.883
[NAME]/Min | infected | 11.41155015197568
[NAME]/Min | not infected | #N/A
[NAME]/Min | some infected | #N/A
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 18 Jan 2012

Daily Morning Staff |  |  |  |  | Wednesday
 | 07:30-14:30 |  | 2012-01-18 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 177648d1346378325-any-way-to-extract-numbers-from-text-recording-fee-sample
Sheet: Sheet1

County Name | Fee For First page | Fee for all other pages | 1st Pg | Next 4 Pages
Orange | Charge $10 for the first page | then it's 8/2p and on | 10 | 8
Polk | charge $15 for the first page | then charge $12 for 2nd page and on | 15 | 12
Pasco | charge 9 for 1st page | charge 6 for all other pages | 9 | 6
[NAME] | fee of 28.00 for 1st page | $14/page after the 1st | 28 | 14
Hillsborough | fee of $14.50 for first page | 6/page from 2 on | 14 | 6
Manatee | fee of $18.75 for 1 page | 7 per page from 2nd page on | 18 | 7
Arkansas | 15/1st pg | $5.95 per page beyond 1 page | 15 | 5
I need an automated way to extract the dollar amount from B and from C and put it into D and E respectively.
Note: the dollar amount of the fee always appears first in each cell.  In other words, the number that
represents the page number is always after the dollar amount of the fee.
All per page fees are under 40 so for example you'd never see $41 for the first page nor would you see
$41 for the second page.
We always ignore the pennies after the decimal point so if the fee was $5.98 we ignore the 98 cents and
charge an even $5.00 (in know, not financially smart but we do it that way).
Spreadsheet: 63182d1264111911-payroll-taxes-tax-problems
Sheet: FICA6.2

 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
Pay# | Name | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | YTD TOTAL | 6621.6
8 | SMITH |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 6621.6
13 | JONES |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 6621.6
Spreadsheet: 755886d1637163011-formula-to-get-the-desired-average-at-the-end-of-a-week-sample-3-
Sheet: Data

 | Mon |  | Tue |  | Wed |  | Thu |  | Fri |  | Sat |  | Sun |  | Avg
Week 1
Week 2 |  | 1800 |  | 1700 |  | 1824 |  | 1728 |  | 2100 |  | 1826 |  | 1665 | 1800
Week 3 |  | 1889 |  | 2214 |  |  |  |  |  |  |  |  |  |  | 2000
Week 4 |  | 1900 |  | 1900 |  | 1900 |  | 2075 |  | 2075 |  | 2075 |  | 2075
Week 5
Week 6
Week 7
Week 8
Spreadsheet: 831643d1685795012-i-want-to-group-some-items-from-a-table-i-have-created-s666-pq-quickmart-sales-record
Sheet: Sheet1

Order ID | Date | Item | Item Code | Quantity | Price | Total | Payment Type | Cashier | Till No | Check out Time | Supervisor | Branch
Spreadsheet: 790395d1659690197-return-value-formular-when-no-exact-match-found-help-5-aligw
Sheet: Customers

Customer | Signer 1 Title | Signer 1 Name | Signer 2 Title | Signer 2 Name
Loans and Savings | CEO | [NAME] | Area director | [NAME]
BankCredit | CFO | [NAME] | Manager for Analytics | [NAME]
BankCredit P/F | CTO | [NAME] | Manager for Analytics | [NAME]
Spreadsheet: 842080d1694151769-alternative-to-indirect-for-referencing-named-ranges-sample-excel-1
Sheet: Reports

2023 |  | Annual Salary
 |  |  | DEF | GHI | MMM | NNN | OOO | PPP | QQQ | RRR | Monthly
Date Joined |  |  |  |  |  |  |  |  |  |  | Totals
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Total
Spreadsheet: 851576d1701788415-count-unique-text-strings-in-a-column-book4
Sheet: Sheet1

Dog, Duck, [NAME], Door |  |  | 3
Dog, Cat, Cow |  | Duck | 1
Door, Sheep, Goat |  | [NAME] | 2
[NAME], [NAME], Dog |  | Door | 2
 |  | Cat | 1
 |  | Cow | 1
 |  | Sheep | 1
 |  | Goat | 1
 |  | Farmer | 1
Spreadsheet: 466505d1466227649-how-to-calculate-overtime-if-the-shift-is-pm-to-am-example-overtime
Sheet: Sheet1

AC-No. | Name | Time | Overtime calculation | Overtime Payments
12 | [NAME] | 6/7/2016 7:49 AM
12 | [NAME] | 6/7/2016 5:08 PM
12 | [NAME] | 6/8/2016 7:55 AM
12 | [NAME] | 6/8/2016 5:15 PM
12 | [NAME] | 6/9/2016 7:48 AM
12 | [NAME] | 6/9/2016 10:06 PM
12 | [NAME] | 6/10/2016 7:44 AM
12 | [NAME] | 6/10/2016 6:06 PM
12 | [NAME] | 6/11/2016 11:01 PM
12 | [NAME] | 6/11/2016 7:02 AM
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-01-31 00:00:00 |  | 16766.48
2001-02-03 00:00:00
60874 | 476
500235
500248
500251
500254 | 105
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-01-31 00:00:00 |  | 275313.72
2001-02-03 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-01-31 00:00:00 |  | 467961.61
2001-02-03 00:00:00
500241
500391 | 832
500392 | 234
Duke Energy Trading and Marketing
21665 |  | 73449.16
22664 |  | 23612.35
20248 |  | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: 80315d1280490155-sumproduct-sumifs-book1
Sheet: Sheet2

 | 2010
 | J | F | M | A | M | J | J | A | S | O | N | D
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Mr. [NAME]
Spreadsheet: 0544622f-b377-4262-bcd9-1df4790d7fe7
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0004122 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Chatham | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 53616
Daily Limit:
Sample Frequency: |  |  | [NAME]
Spreadsheet: 270094d1381376438-my-formulas-disappear-job-cost-sheets-ckversion
Sheet: Majestic Cost Sheet 

JOB NAME: |  |  |  |  |  |  | DATE:
ADDRESS: |  |  |  |  |  |  | INVOICE#:
INSTALL DATE: |  |  |  |  |  |  | SOLD BY:
MATERIALS |  |  |  |  | SOURCE | CUT | QTY | UNIT COST | TOTAL
 |  |  |  |  |  | COST OF MATERIALS
 |  |  |  |  |  | ADD: 8.10% SALES TAX
 |  |  |  |  |  | TOTAL COST OF MATERIALS
MISC / NON-TAXABLE ITEMS |  |  |  |  |  |  |  | UNIT COST | TOTAL
 |  |  |  |  |  | TOTAL MISC. / NON-TAX ITEMS
LABOR / TYPE OF WORK |  |  |  |  |  |  | QTY | COST | TOTAL
 |  |  |  |  |  | LABOR COST
 |  |  |  |  |  | ADD: 10% SIIS
 |  |  |  |  |  | ADD: 10% VENDOR MARK-UP
 |  |  |  |  |  | TOTAL LABOR COST
 |  |  |  |  |  | ADD: TOTAL COST OF MATERIALS
 |  |  |  |  |  | ADD: TOTAL MISC/NON-TAX ITEMS
 |  |  |  |  |  | TOTAL JOB COST
Spreadsheet: 751276d1634026177-matching-extracted-number-with-an-array-of-extracted-numbers-matching-codes
Sheet: Sheet2

 | Description |  |  |  | Extracted Code
 | AURORA SPAR (35668)(2)
 | AVONWOOD SUPERSPAR (35977)(2)
 | BEACH ROAD KWIKSPAR & TOPS (36071)(2)
 | BELHAR SUPERSPAR (35353)(2)
 | BELLVILLE SPAR & TOPS (35682)(2)
 | [NAME] (35568)(2)
 | CAPE GATE SUPERSPAR (35975)(2)
 | CINNAMON SQUARE SPAR (35777)(2)
 | DE HELDERBOSCH [NAME] (35615)(2)
 | DE TYGER [NAME] (35921)(2)
 | DELFT SPAR (35802)(2)
 | DURBANVILLE KWIKSPAR & TOPS (35870)(2)
 | EERSTE RIVER SUPERSPAR (36145)(2)
 | [NAME] (36020)(2)
 | FIRGROVE EXPRESS (36042)(2)
 | GORDONS BAY SPAR (35213)(2)
 | GRASSY PARK SPAR (36156)(2)
 | GUGULETHU SUPERSPAR (36175)(2)
 | HAASENDAL SUPERSPAR (36117)(2)
 | [NAME] (36003)(2)
 | [NAME] (35673)(2)
 | KENSINGTON SPAR & TOPS (35828)(2)
 | KHAYELITSHA SUPERSPAR (35876)(2)
 | KRAAIFONTEIN SUPERSPAR (35036)(2)
 | KUILSRIVER SUPERSPAR (35037)(2)
 | [NAME] (35900)(2)
 | [NAME] LANGVERWACHT (36224)(2)
Spreadsheet: 889600d1740475697-one-more-issue-in-excel-test
Sheet: Fuel Prices

 |  | From Date | To Date | Diesel (HSD) | Petrol (PMG)
 |  | 2025-02-01 00:00:00 | 2025-02-15 00:00:00 | 268.87 | 258.05
 |  | 2025-02-16 00:00:00 | 2025-02-28 00:00:00 | 264.87 | 257.06
 |  | 2025-03-01 00:00:00 | 2025-03-15 00:00:00
 |  | 2025-03-16 00:00:00 | 2025-03-31 00:00:00
 |  | 2025-04-01 00:00:00 | 2025-04-15 00:00:00
 |  | 2025-04-16 00:00:00 | 2025-04-30 00:00:00
Spreadsheet: phillip_m_love__30054__PowerRiskCalc Jan01 Sithe 1-30-01
Sheet: Curve shift

 | Curve shift
 |  | Valuation date
 | Avg. Start Date | Avg. End Date | Curve ($/MWhr) | Vol % | Years until averaging begins | Years until averaging ends | # of settle prices | Strike price ($/MWhr) | Interest rate | Set days | Avg. Price to Date | Time to [NAME] | Call/Put (1/0) | Option Premium ($/MWhr) | Total MWhrs | Total value
 |  |  |  |  |  |  |  |  |  |  |  |  | Call
Spreadsheet: 470162d1468364466-creating-table-that-conditionally-retrieves-data-in-another-sheet-sample-workbook
Sheet: Desired outcome

No. | Name | Property 1 | calculation | Property 4
6 | dog TEST | 4.173 | x | 0.8389
7 | cat TEST | 4.173 | x | 4.7791
10 | horse TEST | 4.174 | x | 40.047
Spreadsheet: 104596d1302132390-first-in-first-out-comparing-creation-dt-to-start-dt-first-in-first-out
Sheet: Sheet1

ORDER_NUM | CREATED | START_TS
A1 | 2011-01-01 00:24:23 | 2011-01-01 05:36:55
A2 | 2011-01-01 00:37:35 | 2011-01-02 02:28:16
A3 | 2011-01-01 00:38:06 | 2011-01-01 00:38:06
A4 | 2011-01-01 00:42:47 | 2011-01-01 00:47:22
A5 | 2011-01-01 00:51:49 | 2011-01-01 05:14:54
A6 | 2011-01-01 00:57:53 | 2011-01-01 01:56:38
A7 | 2011-01-01 01:07:03 | 2011-01-01 05:17:47
A8 | 2011-01-01 02:03:27 | 2011-01-01 18:40:34
A9 | 2011-01-01 02:07:50 | 2011-01-01 02:12:17
A10 | 2011-01-01 02:17:45 | 2011-01-01 06:37:14
A11 | 2011-01-01 02:20:30 | 2011-01-01 02:22:57
A12 | 2011-01-01 02:22:44 | 2011-01-02 03:18:18
A13 | 2011-01-01 02:33:26 | 2011-01-02 02:52:22
A14 | 2011-01-01 03:40:11 | 2011-01-02 01:28:27
A15 | 2011-01-01 04:20:13 | 2011-01-01 21:50:30
A16 | 2011-01-01 04:29:30 | 2011-01-02 03:34:03
A17 | 2011-01-01 04:31:26 | 2011-01-02 13:22:32
A18 | 2011-01-01 04:32:27 | 2011-01-02 02:58:58
A19 | 2011-01-01 04:35:00 | 2011-01-02 02:30:21
Spreadsheet: 191034d1351878599-count-unique-values-in-column-a-according-to-a-criteria-in-column-b-unique-values-problem
Sheet: Sheet1

Clinician | Intake Date
Zoe | 2012-08-01 00:00:00
Zoe | 2012-08-01 00:00:00
Dale | 2012-08-01 00:00:00
Cecile | 2012-08-01 00:00:00
Cecile | 2012-08-01 00:00:00
[NAME] | 2012-08-01 00:00:00
Izaak | 2012-08-02 00:00:00
Anne R | 2012-08-02 00:00:00
[NAME] | 2012-08-02 00:00:00
[NAME] | 2012-08-02 00:00:00
 | Unique Names
2012-08-01 00:00:00 | 4
2012-08-02 00:00:00 | 3
Spreadsheet: 878033d1725000563-xlookup-columns-based-on-random-text-search-book2
Sheet: Sheet1

Invested In | STOCK_NO |  | Stock Name | I need to X ookup the Stock_No
HDFC Bank Ltd | 1 |  | HDFC
Reliance Industries Ltd | 2 |  | Reliance | 1
ICICI Bank Ltd | 3 |  | ICICI | 1
Infosys Ltd | 4 |  | Infosys Ltd. | 4
Larsen & Toubro Ltd | 5 |  | Toubro | 1
ITC Ltd | 6 |  | ITC Ltd. | 6
Tata Consultancy Services Ltd | 7 |  | Tata Consultancy Services Ltd | 7
Bharti Airtel Ltd | 8 |  | BhartiAirtel | 1
Axis Bank Ltd | 9 |  | Axis Bank Ltd | 9
State Bank of India | 10 |  | State Bank of India | 10
Spreadsheet: 809184d1670950774-check-to-see-if-two-inputs-share-the-same-data-ex2
Sheet: Sheet1

 |  |  |  |  |  | EXAMPLE A |  |  | EXAMPLE B
 | Category | Data |  |  |  | Input | Output |  | Input | Output
 | 1 | circle | square | triangle |  | 1 | Triangle |  | 1 | Circle, Square, Triangle
 | 2 | oval | rhombus | triangle |  | 2 | Triangle |  | 2 | Triangle
 | 3 | circle | square | sphere |  |  |  |  | 3 | Circle, Square
 | Category | Data | 1 | 2 | 3
 | 1 | circle
 | 1 | square
 | 1 | triangle
 | 2 | oval
 | 2 | rhombus
 | 2 | triangle
 | 3 | circle
 | 3 | square
 | 3 | sphere
Spreadsheet: 863225d1710788219-formulas-for-golf-tournament-assigning-in-separate-cell-and-listing-multiple-names-team-game-scenarios
Sheet: Sheet1

[NAME] | -4 |  | [NAME]
[NAME] | 3 |  | [NAME] |  |  | In this scenario, I need  the number 25 to fill into column E for every player except for the (3) highest scores (which would be Zach, [NAME], [NAME] and [NAME]). The (3) highest scores only get the number 10. Since [NAME] and [NAME] both tied for the 3rd highest score, is there a way to give them each the number 17 or 18 which would be 25+10/2?
[NAME] | -2 |  | [NAME]
[NAME] | 0 |  | [NAME]
[NAME] | -3 |  | [NAME]
[NAME] | -3 |  | [NAME]
Jake | -6 |  | Jake
[NAME] | 2 |  | [NAME]
[NAME] | 5 |  | [NAME]
Mark | -3 |  | Mark
[NAME] | -5 |  | [NAME]
Pablo | -6 |  | Pablo
[NAME] | 0 |  | [NAME]
[NAME] | 3 |  | [NAME]
Zach | 6 |  | Zach
 | Hole 1 | Hole 2 | Hole 3
[NAME] | 3 | 6 | 5 |  | Hole 1 |  |  | In this scenario, I would like to list each player that shot the lowest score for each hole. So for Hole 1, it would show [NAME], [NAME], [NAME] in cell G21. For Hole 2, it would show, [NAME], [NAME], [NAME], [NAME], Zach in cell G22, etc. Is there a way for a cell to show "..."  or something similar if the amount of players is too long to fit in the cell? So let's say Hole 1 has 10 guys tie for the lowest score. If only 5 names can fit, can it show the first five names and then show "..." to indicate there are more names than what are shown?
[NAME] | 4 | 5 | 6 |  | Hole 2
[NAME] | 4 | 5 | 8 |  | Hole 3
[NAME] | 5 | 4 | 9
[NAME] | 8 | 5 | 7
[NAME] | 6 | 6 | 6
Jake | 3 | 5 | 5
[NAME] | 5 | 6 | 6
[NAME] | 6 | 4 | 6
Mark | 4 | 4 | 8
[NAME] | 3 | 5 | 5
Pablo | 5 | 6 | 5
[NAME] | 4 | 7 | 9
[NAME] | 4 | 4 | 6
Zach | 8 | 4 | 9