tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e1800cac-8624-4af9-8f6a-9acb968ee099
Sheet: Sheet1

Red triangles at the upper right hand corner indicate design comments | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Please complete the yellow shaded items.
STORMWATER MANAGEMENT PERMIT APPLICATION FORM
401 CERTIFICATION APPLICATION FORM
INFILTRATION BASIN SUPPLEMENT
This form must be filled out, printed and submitted.
The Required Items Checklist (Part III) must be printed, filled out and submitted along with all of the required information.
I.  PROJECT INFORMATION
Project Name
Contact Person
Phone Number
Date
Drainage Area Number
II.  DESIGN INFORMATION
Site Characteristics
Drainage area |  | ft2
Impervious area |  | ft2
Percent impervious |  | %
Design rainfall depth |  | in
Peak Flow Calculations
1-yr, 24-hr rainfall depth |  | in
1-yr, 24-hr intensity |  | in/hr
Pre-development 1-yr, 24-hr discharge |  | ft3/sec
Post-development 1-yr, 24-hr discharge |  | ft3/sec
Pre/Post 1-yr, 24-hr peak flow control |  | ft3/sec
Large Design Storm
Design Storm to control |  | yr
 |  | hr
Rainfall intensity, large design storm | 0 | in/hr
Peak flow, large design storm |  | ft3/sec
Length of overflow weir |  | ft
Storage Volume: Non-SA Waters
Minimum design volume required |  | ft3
Design volume provided |  | ft3
Storage Volume:  SA Waters
1.5" runoff volume |  | ft3
Pre-development 1-yr, 24-hr runoff volume |  | ft3
Post-development 1-yr, 24-hr runoff volume |  | ft3
Minimum required volume |  | ft3
Volume provided |  | ft3
Soils Report Summary
Soil type
Infiltration rate |  | in/hr
SHWT elevation |  | fmsl
Basin Design Parameters
Drawdown time |  | days
Basin side slopes |  | :1
Basin bottom elevation |  | fmsl
Storage elevation |  | fmsl
Storage Surface Area |  | ft2
Top elevation |  | fmsl
Basin Bottom Dimensions
Basin length |  | ft
Basin width |  | ft
[NAME] |  | ft2
Additional Information
Maximum runoff to each inlet to the basin? |  | ac-in
Length of vegetative filter for overflow |  | ft
Distance to structure |  | ft
Distance from surface waters |  | ft
Distance from water supply well(s) |  | ft
Separation from impervious soil layer |  | ft
Naturally occuring soil above shwt |  | ft
Bottom covered with 4-in of clean sand? |  | (Y or N)
Proposed drainage easement provided? |  | (Y or N)
Capures all runoff at ultimate build-out? |  | (Y or N)
Bypass provided for larger storms? |  | (Y or N)
Pretreatment device provided
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -31520 | -15050 |  | -15792
2 | -19906 |  |  | -18793
3 | -29498 |  |  | -30792
4 | -12267 |  |  | -11980
5 | -3810 |  |  | -8792
6 | -21956 |  |  | -17495
7 | -16544 |  |  | -17495
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-09-30 00:00:00 |  |  |  | 69914
 | 2001-10-07 00:00:00
CBS Dollars
 |  |  | 65784
Spreadsheet: 493433d1481720777-max-min-lookup-with-dates-and-other-criteria-example
Sheet: 60 Days

 |  |  |  |  |  |  | Today's Date
 | 60 Day Overview |  |  | Filter | Bespoke
 |  |  |  |  |  |  | 60 Days Ago
 |  | List Growth
 |  | Overall:
 |  | Highest: | 0
 | - | - |  | - | -
 |  | Type: | -
 |  | Date Sent: | -
 |  | Lowest: | 0
 | - | - |  | - | -
 |  | Type: | -
 |  | Date Sent: | -
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ---
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bespoke
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Business
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Excel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IT Business
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IT Practice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pick of the Week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Practice
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tax
Spreadsheet: 158392d1338216343-align-two-graphs-of-the-weight-development-of-my-two-puppy-dogs-rottweilers-copy-of-ggptt
Sheet: chart input

[NAME] data |  | [NAME] data
Date | [NAME] | date | [NAME] |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  | 2011-12-16 00:00:00
Spreadsheet: 62916d1263909301-ranking-formula-pool-league
Sheet: front sheet with Detailed Specs

 |  |  | Ligue de Billard De Cowansville
 | nom: | _________________________________________ | Points | Mon pointage | Résultats |  | Résultats |  | Position % | [NAME]
 |  | Joueurs | Aujourdui | Aujourdui | Avant Noël |  | Après Noël
 | 1 | Alain Piette |  |  | 8
 | 2 | [NAME] |  |  | 12
 | 3 | [NAME] |  |  | 2
 | 4 | [NAME] |  |  | 13
 | 5 | [NAME] |  |  | 8
 | 6 | Jean-Marie Lacasse |  |  | 16
 | 7 | [NAME] |  |  | 7
 | 8 | Sylvain Mercier |  |  | 2
 | 9 | [NAME] |  |  | 6
 | 10 | [NAME] |  |  | 9
 | 11 | [NAME] |  |  | 4
 | 12 | [NAME] |  |  | 14
 | 13 | [NAME] |  |  | 17
 | 14 | [NAME] |  | Total Possible | 18
 | 15 | [NAME] |  | de la journée | 12
 | 16 | [NAME] |  |  | 21
 | 17 | [NAME] |  |  | 15
 | 18 | [NAME] |  |  | 11
 | 19 | [NAME] |  |  | 10
 | 20 | [NAME] |  |  | 5
 | 21 | [NAME]
 | 22 | [NAME]
 | 23 | [NAME]
 | 24
 | 25
Spreadsheet: 266818d1379762863-create-tab-update-leaderboards-automatically-calend-rio-e-tabelas
Sheet: Estatísticas Taça GESTLIGA

 | TAÇA GESTLIGA VILA NOVA DE GAIA 2013 | 2014 |  |  |  |  |  |  |  | TAÇA DIVISÃO GESTLIGA VILA NOVA DE GAIA 2013 | 2014
 | MELHORES MARCADORES |  |  |  |  |  |  |  | DISCIPLINA
 |  | GOLEADORES | EQUIPA | J | G | MÉDIA |  |  | NOME DO [NAME] | EQUIPA | A | V | C/J
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
Spreadsheet: 121836d1316447454-pivot-table-grand-totals-help-cheri-pivot-table-problem
Sheet: Pivot

 | Values
Product | 2009 Sodium | 2010 Sodium | 2010 Y/Y % Change | 2011 Sodium | 2011 Y/Y % Change
Pie | 2 | 1 | -1 | #[NAME]! | #[NAME]!
[NAME] | 2 | 1 | -1 | 1 | 0
Grand Total | 2 | 1 | -1 | 1 | -1
Spreadsheet: mary_fischer__25641__111
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 0111
COMPANY NAME  Pierce Mechanical
ANALYSIS OF GOODWILL
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, January 25 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: theresa_staab__39598__Producer Pricing Detail Nov01
Sheet: Box Draw Detail

[NAME] | Contact: | [NAME] |  |  | Enron North America
 | PH: | [PHONE]
 | FAX: | [PHONE] |  |  | [NAME] | [PHONE]
Inside FERC NGPL Midcont.:
Inside FERC CIG:
First of Month Nomination: |  |  | MMBtu
Additional Purchases: |  |  | MMBtu
 | Wt. Avg. Btu: | Nom. | Pro rata Production | Transportation/MMBtu
[NAME] |  |  |  | 0.61
[NAME] |  |  |  | 0.47
Box Draw Net Backs: |  | Index Discount/Premium | Crestone Transport/MMBtu | [NAME] |  | [NAME] | [NAME] (0%*NGPLindex) | Total Receipts Fee Adjustment* |  | Total Net Back
[NAME]. | CIG GD | 0
[NAME]. | IF NGPL Midcont. | 0.01 |  |  |  | -0.1226 | 0
[NAME]. | IF CIG Rockies | 0
Add'l Purchases | CIG GD | See GD Pricing Sheet
Add'l Purchases | CIG GD | 0.1 |  | -0.25
 |  | BOX DRAW
 |  | Over 80% of FOM Nom. | FOM CIG GD Volume MMBtu | [NAME] (Less S. Kitty) 80% of FOM Nom. up to 12,000/Day | NGPL Volume MMBtu | 80% of FOM Nom. Less 12,000/Day | FOM CIG Volume MMBtu | Additional CIG GD +.10 Purchases | Add'l CIG GD + .10 Volume MMBtu | Additional CIG GD - Daily Discount | Add'l CIG GD - Daily Discount Volume MMBtu | Total Box Draw Allocated Fuel MMBtu | Box Draw Wellhead Production MMBtu | Total Purchased Production MMBtu | Total Box Draw Payments by [NAME]
 | CIG GD Rockies | CIG GD less Netback |  | NGPL less Netback |  | CIG less Netback |  | CIG GD less Netback |  | CIG GD less Netback |  |  |  |  | $ FOM CIG GD | $ NGPL | $ FOM CIG | $ Add'l CIG GD + .10 | $ Add'l CIG GD - Daily Discount | Total Payment
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. $/Mmbtu:
*Total Receipts Fee Adjustment is calculated by applying the Field Services Fee to the fuel volume and then dividing that dollar amount(fee times fuel volume) by the volume purchased.
Spreadsheet: 266928d1379857442-sumif-formula-to-exclude-letter-from-range-e3-e6-example
Sheet: Sheet1

Letter | Number
a | 5345
b | 546 |  |  | a
c | 864 |  |  | d
d | 54 |  |  | g
e | 864 |  |  | h
f | 684
g | 534
h | 564
i | 864
j | 684
Spreadsheet: 861462d1709304589-how-to-fill-in-the-corresponding-table-with-the-names-of-each-unit-according-to-their-job-0301
Sheet: Sheet1

Table1 |  |  |  |  |  |  | Table2
Serial Number | unit | Name | position | employee attributes |  |  | unit | staff |  |  |  |  | outsource |  |  |  |  | Self employment
1 | Terminal group | T2 | maintenance | outsource |  |  |  | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle
2 | Terminal group | W1 | maintenance | outsource |  |  | Terminal group |  |  |  |  |  | 3 | T2、W1 | [NAME]
3 | Terminal group | [NAME] | assemble | outsource |  |  | Complaint team | 1 |  |  | T1 |  | 1 |  |  |  | T4
4 | Complaint team | T1 | Receiving orders | staff |  |  | Transport Group |  |  |  |  |  | 2 |  |  | W5 | W4
5 | Complaint team | T4 | handle | outsource |  |  | Support group | 1 |  | T3 |  |  |  |  |  |  |  | 1 |  | W3
6 | Transport Group | W5 | Receiving orders | outsource
7 | Transport Group | W4 | handle | outsource
8 | Support group | T3 | assemble | staff |  |  |  | outsource | outsource | outsource | outsource | outsource | staff | staff | staff | staff | staff | Self employment | Self employment | Self employment | Self employment | Self employment
9 | Support group | W3 | assemble | Self employment |  |  | unit | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle | Number of people | maintenance | assemble | Receiving orders | handle
 |  |  |  |  |  |  | Terminal group | 3 | T2、W1 | [NAME]
 |  |  |  |  |  |  | Complaint team | 1 |  |  |  | T4 | 1 |  |  | T1
 |  |  |  |  |  |  | Transport Group | 2 |  |  | W5 | W4
 |  |  |  |  |  |  | Support group |  |  |  |  |  | 1 |  | T3 |  |  | 1 |  | W3
 |  | 3/4” |  |  | 7/8”
Spreadsheet: 61663d1262606453-combining-tables-but-removing-n-a-demo1
Sheet: Sheet1

Task | Name |  | Task | Name |  | Tasks | Names
1.01 | Alpha |  | 2.01 | Alpha2 |  | 1.01 | Alpha
1.02 | Bravo |  | 2.02 | Bravo2 |  | 1.02 | Bravo
1.03 | [NAME] |  | 2.03 | Charlie2 |  | 1.03 | [NAME]
1.04 | Delta |  | 2.04 | Delta2 |  | 1.04 | Delta
1.05 | Echo |  | #N/A | #N/A |  | 1.05 | Echo
1.06 | Foxtrot |  | #N/A | #N/A |  | 1.06 | Foxtrot
#N/A | #N/A |  | #N/A | #N/A |  | 2.01 | Alpha2
#N/A | #N/A |  | #N/A | #N/A |  | 2.02 | Bravo2
#N/A | #N/A |  | #N/A | #N/A |  | 2.03 | Charlie2
#N/A | #N/A |  | #N/A | #N/A |  | 2.04 | Delta2
#N/A | #N/A |  | #N/A | #N/A
#N/A | #N/A |  | #N/A | #N/A
#N/A | #N/A |  | #N/A | #N/A
#N/A | #N/A |  | #N/A | #N/A
Spreadsheet: 93348d1292947958-v-lookup-with-2-options-work-order-tracking-example
Sheet: tbl_AlarmAccts

Acct | Bldg
CO1000 | CO0527
CO1001 | CO0530
CO1003 | CO0624
CO1010 | CO1977
ND1011 | ND0046
UT1012 | UT0032
CO1013 | CO1977
ND1014 | ND0046
UT1015 | UT0032
Spreadsheet: 116650d1311967045-excel-2007-look-up-value-and-return-multiple-corresponding-values-draft-worksheet
Sheet: Sheet3

Adam | Flacco, [NAME] | QB | Ravens | 25
[NAME] | Manning, Peyton | QB | Colts | 50
Jon | [NAME], [NAME] | QB | Pats | 30
Adam | [NAME], [NAME] | RB | Ravens | 40
Ray | Jones-Drew, [NAME] | RB | [NAME] | 35
[NAME] | McGahee, [NAME] | RB | Broncos | 40
Adam | Jacobs, [NAME] | RB | Giants | 25
Adam
Spreadsheet: 487679d1478191034-multi-purpose-calander-task-manager-master-worklist
Sheet: Master

2016-11-01 00:00:00 |  |  | Todays Date |  |  |  |  |  |  | Legend
First Fax For These Routes: |  |  | Second Fax for These Routes: | Call on These Routes: |  |  |  | Export These Routes: |  | Anchorage Bi Weekly Routes
 |  |  |  |  |  |  |  |  |  | [NAME] Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Weekly Routes
 |  |  |  |  |  |  |  |  |  | Wasilla Weekly Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Monthly Routes
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Anchorage Bi Weekly Routes
 |  |  |  |  |  |  |  |  |  | [NAME] Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Weekly Routes
 |  |  |  |  |  |  |  |  |  | Wasilla Weekly Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Monthly Routes
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Anchorage Bi Weekly Routes
 |  |  |  |  |  |  |  |  |  | [NAME] Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Weekly Routes
 |  |  |  |  |  |  |  |  |  | Wasilla Weekly Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Monthly Routes
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | Anchorage Bi Weekly Routes
 |  |  |  |  |  |  |  |  |  | [NAME] Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Weekly Routes
 |  |  |  |  |  |  |  |  |  | Wasilla Weekly Routes
 |  |  |  |  |  |  |  |  |  | Anchorage Monthly Routes
 |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 777765d1650602451-dependent-drop-down-listing-dropdownexample
Sheet: Sheet1

Province | Districts |  | Result
Bougainville | Central Bougainville District
Bougainville | North Bougainville District |  | Province Name: | Bougainville
Bougainville | South Bougainville District |  | District Name:
Central | Abau District |  |  | North Bougainville District
Central | Goilala District |  |  | South Bougainville District
Central | Kairuku-Hiri District
Central | Rigo District
East New Britain | Gazelle District
East New Britain | Kokopo District
East New Britain | [NAME]
East New Britain | Rabaul District
East Sepik | Ambunti-Dreikikir District
East Sepik | Angoram District
East Sepik | Maprik District
East Sepik | Wewak District
East Sepik | Wosera-Gawi District
East Sepik | Yangoru-Saussia District
Eastern Highlands | Daulo District
Eastern Highlands | Goroka District
Eastern Highlands | [NAME]
Eastern Highlands | Kainantu District
Eastern Highlands | Lufa District
Eastern Highlands | Obura-Wonenara District
Eastern Highlands | Okapa District
Eastern Highlands | Unggai-Benna District
Spreadsheet: 732444d1620961992-count-the-data-of-a-group-with-multiple-conditions-sample-file
Sheet: Sheet2

Desc | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  |  | GroupA | GroupB | GroupC | GroupD | GroupE
AA | Y | Y |  |  |  |  |  |  |  |  |  |  |  |  | AA | AA | AD | AE | AB
AB |  | Y |  |  | Y |  | Y |  | Y | Y |  | Y |  |  | AC | AB | AE | AH | AD
AC | Y |  |  |  |  | Y |  | Y |  |  | Y |  |  |  | AF | AD | AJ |  | AF
AD |  | Y | Y |  | Y | Y | Y |  |  |  | Y | Y |  |  | AI | AG | AK |  | AH
AE |  |  | Y | Y |  | Y |  |  |  |  | Y |  |  |  | AK | AH |  |  | AJ
AF | Y |  |  |  | Y |  |  | Y |  |  |  | Y |  |  |  | AJ |  |  | AK
AG |  | Y |  |  |  |  |  | Y
AH |  | Y |  | Y | Y |  | Y | Y | Y | Y |  | Y
AI | Y |  |  |  |  |  |  |  |  |  | Y
AJ |  | Y | Y |  | Y |  | Y |  | Y | Y | Y | Y
AK | Y |  | Y |  | Y |  |  | Y |  |  | Y | Y
Spreadsheet: 219566d1362786614-autopopulate-formula-from-two-columns-of-data-copy3-of-amc-2013-budget
Sheet: MAR - Report

Allenmore Men's Club                                                        Treasurers Report  -  March 2013
Starting Balance: | 4950
Monthly Income: | 2660
Monthly Expenses: | 224.2
Ending Balance: | 7385.8
Change: | 2435.8
Receipts since last report:
 |  |  | Total Receipts:
Dispursements:
 |  |  | Total Dispursements:
Special Notes:
Prepared By: | Secretary/Treasurer |  | Accepted By:
 | [NAME]
 |  |  | ü | Allenmore Men's Club
 |  |  | ü | General Meeting
 | Signature |  | ü | Membership in Attendance
 |  |  | ü | Passed & Recorded
 |  | Date |  | into Minutes
Spreadsheet: 683189d1592551319-need-help-regarding-if-and-and-formula-need-help
Sheet: ExcelForum (Help!)

 |  |  | 7501.252 |  |  |  |  |  |  | 4246 | 32.39 | 15.95 | 0.14 | 3.35 |  | 13654 | 4 | 3.12 | 7.12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65.93
Spreadsheet: 127227d1320243059-sumif-range-not-equal-to-another-range-sumif_dummyfile
Sheet: Sheet1

 | Do-Not-Sum-Accounts |  | All accounts
 | Account |  | Account | Dollar Amount
 | 1 |  | 1 | 5
 | 2 |  | 2 | 10
 | 3 |  | 3 | 14
 | 4 |  | 4 | 145
 | 5 |  | 7 | 514
 | 6 |  | 10 | 675
 | 7 |  | 11 | 125
 | 8 |  | 15 | 568
 | 9 |  | 8 | 876
 |  |  | 7 | 435
 |  |  | 4 | 765
 |  |  | 3 | 345
 |  |  | 17 | 12
 |  |  | 25 | 4231
 |  |  | 31 | 65
 |  |  | 10 | 324
 | Sum:
Spreadsheet: 863263d1710828441-formulas-for-golf-tournament-assigning-in-separate-cell-and-listing-multiple-names-team-game-scenarios
Sheet: ori

[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
Spreadsheet: 124423d1318405821-sub-coloring-pie-charts-796023
Sheet: Sheet1

Age & Women & Men
0-30 & 7 & 2
31-60 & 3 & 2
61+ & 5 & 1
Total & 15 & 5
 |  |  |  | [NAME] | Total
 |  |  |  |  | 15
 |  |  |  |  | 5
 |  |  |  | 7
 |  |  |  | 3
 |  |  |  | 5
 |  |  |  | 2
 |  |  |  | 2
 |  |  |  | 1
Spreadsheet: 765039d1643131661-need-a-formula-to-pll-data-from-left-and-right-of-delinator-line-book-6
Sheet: Sheet1

Original Data set | to the left | to the right
Phoenix, AZ | CM002
Scottsdale, AZ | 00013
Phoenix, AZ | A4
[NAME], AZ | 0001
St Louis, Missouri | P12
WHAT I WANT
Original Data set | to the left | to the right
Phoenix, AZ | CM002 | Phoenix, AZ | CM002
Scottsdale, AZ | 00013 | Scottsdale, AZ | 00013
Phoenix, AZ | A4 | Phoenix, AZ | A4
[NAME], AZ | 0001 | [NAME], AZ | 0001
St Louis, Missouri | P12 | St Louis, Missouri | P12
Spreadsheet: 878150d1725174221-conditional-formatting-formula-to-highlight-max-and-min-values-zaska-sample-319-365-cf-aligw
Sheet: Sheet1

Year | Value
2024-08-21 00:00:00 | 128
2024-04-02 00:00:00 | 195
2024-02-13 00:00:00 | 108
2024-02-01 00:00:00 | 125
2023-08-09 00:00:00 | 110
2023-08-08 00:00:00 | 156
2023-07-12 00:00:00 | 115
2023-02-17 00:00:00 | 132
2023-02-07 00:00:00 | 115
2022-12-01 00:00:00 | 178
2022-10-28 00:00:00 | 106
2022-09-09 00:00:00 | 167
2022-06-14 00:00:00 | 197
2022-05-31 00:00:00 | 142
2022-05-16 00:00:00 | 187
2022-03-28 00:00:00 | 147
2022-03-11 00:00:00 | 127
2022-02-16 00:00:00 | 139
2021-11-29 00:00:00 | 103
2021-04-13 00:00:00 | 130
2021-03-09 00:00:00 | 130
2020-10-15 00:00:00 | 140
2019-11-22 00:00:00 | 108
2019-11-07 00:00:00 | 116
2019-08-08 00:00:00 | 134
2019-07-23 00:00:00 | 127
Spreadsheet: 738975d1625402248-help-finding-smallest-value-personal-bests-for-runners-runner-pbs-example
Sheet: This competition

 | PHASE 1 |  |  | DATE | 2021-07-20 00:00:00 |  | YOU CAN SEE THE PROBLEM IN E5/F5/G5 AND E46/F46/G46
 | Number | Name | Track | Time | PB
Alkukarsinta | 1 | N | x | 44.52 |  | <--
Alkukarsinta | 2 | G | x | 46.73
Alkukarsinta | 3 | K | x | 52.22
Alkukarsinta | 4 | M | x | 63.44
Alkukarsinta | 5 | A | x | 42.63
Alkukarsinta | 6 | H | x | 52.77
Alkukarsinta | 7 | E | x
Alkukarsinta | 8 | P | x
Alkukarsinta | 9 | I | y
Alkukarsinta | 10 | J | y
Alkukarsinta | 11 | C | y
Alkukarsinta | 12 | O | y
Alkukarsinta | 13 | L | y
Alkukarsinta | 14 | B | y
Alkukarsinta | 15 | F | y
Alkukarsinta | 16 | D | y
 | PHASE 2
 | Number | Name | Track | Time | PB
 | 3 | K | x
 | 2 | G | x
 | 1 | N | x | 43.31 |  | <-- HERE'S THE PROBLEM WITH VLOOKUP
 | 5 | A | x
 | 12 | O | y
 | 11 | C | y
 | 10 | J | y
 | 9 | I | y
 | PHASE 3
 | Number | Name | Track | Time | PB
 | 2 | G | x
 | 1 | N | x
 | 10 | J | y
 | 9 | I | y
Spreadsheet: 91118d1290797247-vlookup-multiple-sheets-in-a-different-other-file-samp_b
Sheet: v13-38

C-code |  |  |  | Qty
c123 |  | xxx | yyy | 8
c125 |  | xxx | yyy | 9
c126 |  | xxx | yyy | 10
c124 |  | xxx | yyy | 21
c128 |  | xxx | yyy | 22
c127 |  | xxx | yyy | 14
Spreadsheet: 764628d1642832445-how-to-exclude-blank-cell-from-drop-down-list-non-blank-drop-down
Sheet: Sheet1

Inst. Short Name | Dept Short Name
MPI | ET |  |  | MIMT | MIST | MPI | MPPI | NMPI | VIMT |  | MIST | MT | CT
MPI | CT
MPI | MT |  |  |  | EmT | CT
MPI | PT |  |  |  |  | ENT
MPI | CmT |  |  |  |  | ET |  |  |  |  |  | EmT | CT
MPI | ENT |  |  |  |  | MT
MIST | EmT |  |  |  |  | PT
MIST | CT
MIMT | MT |  |  |  | =INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0))
BPI | PT |  |  |  | =FILTER(INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0)),INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0))<>"")
VIMT | CmT
MPPI | EnT
NMPI | EmT