tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 788948d1658819494-index-function-with-variable-columns-excel-forum
Sheet: Product A

T-Roc
Verlustart | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
Anwesenheitszeiten |  |  |  |  |  |  |  |  | 494
Pausen |  |  |  |  |  |  |  |  | -69.88333333333333
Arbeitszeit |  |  |  |  |  |  |  |  | 424.1166666666667
[NAME] |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  | 0
Rüsten |  |  |  |  |  |  |  |  | -30
Nettoarbeitszeit |  |  |  |  |  |  |  |  | 394.1166666666667
[NAME] |  |  |  |  |  |  |  |  | 0
Logistikanlagenstörung |  |  |  |  |  |  |  |  | 0
Schulung / Einarbeitung |  |  |  |  |  |  |  |  | 0
Fehlteil |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  | 0
Sonstige Mikrostillstände |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  | 394.1166666666667
Teilequalität |  |  |  |  |  |  |  |  | 0
Rotverschraubung |  |  |  |  |  |  |  |  | 0
Nacharbeit |  |  |  |  |  |  |  |  | 0
Effektive Arbeitszeit |  |  |  |  |  |  |  |  | 394.1166666666667
Undokumentiert |  |  |  |  |  |  |  |  | -65.03991666666661
Rückgemeldete Te-Zeiten |  |  |  |  |  |  |  |  | 329.0767500000001
Produktivität
Spreadsheet: 675499d1588330680-formula-name-management-inserisci-si_no
Sheet: Foglio1

 |  |  |  |  |  |  | [NAME]
DATA | PRODOTTO 1 |  | 403 10 |  |  |  | 403 |  | =Foglio1!$H$2:$H$100
DATA | PRODOTTO 2 |  | 404 10 |  |  |  | 404 |  | =SE(CONTA.NUMERI(TROVA(numeri;D2))>0; "SI"; "NO")
DATA | PRODOTTO 3 |  | 405 10 |  |  |  | 171
DATA | PRODOTTO 4 |  | 406 10 |  |  |  | 405
DATA | PRODOTTO 5 |  | 423 10 |  |  |  | 200
DATA | PRODOTTO 6 |  | 408 10
DATA | PRODOTTO 7 |  | 172 10
DATA | PRODOTTO 8 |  | 410 10
DATA | PRODOTTO 9 |  | 800 10
DATA | PRODOTTO 10 |  | 421 10
DATA | PRODOTTO 11 |  | 422 10
DATA | PRODOTTO 12 |  | 171 10
DATA | PRODOTTO 13 |  | 407 10
DATA | PRODOTTO 14 |  | 408 10
DATA | PRODOTTO 15 |  | 417 10
DATA | PRODOTTO 16 |  | 418 10
DATA | PRODOTTO 17 |  | 200 10
DATA | PRODOTTO 18 |  | 420 10
DATA | PRODOTTO 19 |  | 421 10
DATA | PRODOTTO 20 |  | 422 10
DATA | PRODOTTO 21 |  | 423 10
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 1366832 | 998416 | 2059119 | 2581134 | 3548283 | 1719143 | 1251565 | 84234 | 13608727
Fixed-Float | 11163141 | 8299635 | 16105633 | 29451768 | 63860488 | 42327083 | 20124485 | 1997691 | 193329923
FRA | 25634187 | 12902136 | 12936164 | 3371180 | 167636 | 0 | 0 | 0 | 55011303
OIS | 16929404 | 7115285 | 9321229 | 5153809 | 2051440 | 431518 | 231462 | 18078 | 41252226
Swaption | 3422850 | 1868193 | 3540568 | 3949940 | 4440104 | 2239192 | 1001176 | 14717 | 20476739
OTHER* | 1256343 | 867452 | 1434104 | 2230381 | 4871117 | 3914024 | 2262024 | 190151 | 17025597
TOTAL | 59772757 | 32051117 | 45396817 | 46738212 | 78939068 | 50630960 | 24870712 | 2304871 | 340704515
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 52633d1252491006-filters-and-countif-formula-698777_killian12321
Sheet: Data

Surname | Forename | Form | Gender | KS2 (En) | FSM | SEN Stage | Language | Ethnicity | In care | 20. What do you think of ExelForum.com? | 19. I love my life | 18. I hate my life | 20X | 19X | 18X
Franklin | Rich |  | Male | 4 | N |  | ENG | WBRI | N | 1 | 1 | 1 | 1 | 1 | 1
Henderson | [NAME] |  | Male |  | N |  | ENG | WBRI | N | 2 | 2 | 1 | 2 | 2 | 1
Silva | [NAME] |  | Female |  | N |  | ENG | REFU | N | 3 | 3 | 3 | 3 | 3 | 3
White | [NAME] |  | Female |  | N | N | ENG | WBRI | N | 2 | 1 | 2 | 2 | 1 | 2
[NAME] | [NAME] |  | Female |  | N |  | ENG | WBRI | N | 1 | 2 | 1 | 1 | 2 | 1
Parker | [NAME] |  | Male | 5 | Y | N | ENG | REFU | N | 4 | 2 | 0 | 4 | 2 | 0
Kent | [NAME] |  | Male |  | N | P | ENG | BASI | N | 2 | 1 | 2 | 2 | 1 | 2
Man | [NAME] |  | Male |  | N |  | ENG | WBRI | N | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | Flash |  | Male |  | Y |  | ENG | WBRI | N | 2 | 3 | 1 | 2 | 3 | 1
Woman | Cat |  | Female |  | N | A | ENG | REFU | N | 1 | 1 | 2 | 1 | 1 | 2
Spreadsheet: 108937d1305849992-extract-and-schedule-data-by-formula-samplebt
Sheet: Report

Report
 | User input:-
Ref | 107
Start | 2011-01-09 00:00:00
Finish | 2011-01-13 00:00:00
Ref | Team | Name | Hours
 | D | [NAME] | 4 | }
 | B | [NAME] | 8 | }
 |  |  |  | } | Required output
 |  |  |  | }
 |  |  |  | }
Spreadsheet: 76957d1277400665-consolidating-rows-sample-data
Sheet: Sheet1

TOTAL | SUM
2010-06-17 04:00:00 | 0
2010-06-17 04:30:00 | 0
2010-06-17 05:00:00 | 0
2010-06-17 05:30:00 | 0
2010-06-17 06:00:00 | 11
2010-06-17 06:30:00 | 36
2010-06-17 07:00:00 | 45
2010-06-17 07:30:00 | 59
2010-06-17 08:00:00 | 94
2010-06-17 08:30:00 | 114
2010-06-17 09:00:00 | 130
2010-06-17 09:30:00 | 154
2010-06-17 10:00:00 | 143
2010-06-17 10:30:00 | 122
1900-01-01 00:00:00 | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
#N/A | 0
Spreadsheet: 278186d1384607578-listing-specific-rows-from-one-sheet-in-a-second-sheet-students-detention
Sheet: Classroom Detention

 | Date of Detention | Student Name | Year Group | Staff Initials | Attended? | Date referred to SL
 | 2013-11-01 00:00:00 | [NAME] | 10 | PRA | NO |  |  |  |  |  |  | YES
 | 2013-11-03 00:00:00 | [NAME] | 9 | RME | YES |  |  |  |  |  |  | NO
 | 2013-11-03 00:00:00 | [NAME] | 11 | DHA | NO
 | 2013-11-03 00:00:00 | [NAME] | 10 | LDI | YES
 | 2013-11-04 00:00:00 | Angus Young | 9 | PRI | YES
 | 2013-11-05 00:00:00 | [NAME] | 8 | ADE | NO
 | 2013-11-05 00:00:00 | [NAME] | 7 | HDE | YES
 | 2013-11-05 00:00:00 | [NAME] | 7 | PLO | NO |  |  |  | I want students for whom Column F = "NO" to be listed on '!SL Detention'
 | 2013-11-06 00:00:00 | [NAME] | 7 | CGA | NO
 | 2013-11-07 00:00:00 | [NAME] | 9 | BBL | YES
 | 2013-11-07 00:00:00 | [NAME] | 11 | AKI | NO
 | 2013-11-09 00:00:00 | [NAME] | 10 | PRI | YES
 | 2013-11-09 00:00:00 | [NAME] | 8 | DHA | NO
 | 2013-11-09 00:00:00 | Poullain | 10 | PLO | YES
 | 2013-11-09 00:00:00 | [NAME] | 11 | HIK | NO
Spreadsheet: 774114d1648219479-need-sum-based-on-duplicate-ids-sample-data-gk-v2-syedtabassumali-
Sheet: Required

Year | 2022
Week | 10 |  | Change Week number
Agent | Total Missed | Completed by other | Actual Missed | Declined
AG
AC
BC
B
DY
D
E
G
J
M
O
R
RM
RF
T
TW
Total
Spreadsheet: 733677d1621700697-how-to-when-a-cell-decreases-its-value-another-cell-increases-respectively-sample
Sheet: Sheet1

CLIENT 1 |  | CLIENT 1 |  | CLIENT 1 |  | CLIENT 1
CLIENT 2 |  | CLIENT 2 |  | CLIENT 2 |  | CLIENT 2
CLIENT 3 |  | CLIENT 3 |  | CLIENT 3 |  | CLIENT 3
CLIENT 4 |  | CLIENT 4 |  | CLIENT 4 |  | CLIENT 4
CLIENT 5 |  | CLIENT 5 |  | CLIENT 5 |  | CLIENT 5
CLIENT 6 |  | CLIENT 6 |  | CLIENT 6 |  | CLIENT 6
CLIENT 7 |  | CLIENT 7 |  | CLIENT 7 |  | CLIENT 7
CLIENT 8 |  | CLIENT 8 |  | CLIENT 8 |  | CLIENT 8
CLIENT 9 |  | CLIENT 9 |  | CLIENT 9 |  | CLIENT 9
CLIENT 10 |  | CLIENT 10 |  | CLIENT 10 |  | CLIENT 10
CLIENT 11 |  | CLIENT 11 |  | CLIENT 11 |  | CLIENT 11
CLIENT 12 |  | CLIENT 12 |  | CLIENT 12 |  | CLIENT 12
CLIENT 13 |  | CLIENT 13 |  | CLIENT 13 |  | CLIENT 13
CLIENT 14 |  | CLIENT 14 |  | CLIENT 14 |  | CLIENT 14
CLIENT 15 |  | CLIENT 15 |  | CLIENT 15
CLIENT 16 |  | CLIENT 16 |  | CLIENT 16
CLIENT 17 |  | CLIENT 17 |  | CLIENT 17
CLIENT 18 |  | CLIENT 18 |  | CLIENT 18
CLIENT 19 |  |  |  | CLIENT 19
CLIENT 20
0
Spreadsheet: 836644d1689561518-sum-column-based-on-another-list-sum-based-on-match
Sheet: Sheet2

Name | 2023-11-20 00:00:00 | 2023-11-21 00:00:00 | 2023-11-22 00:00:00 |  |  | Key
[NAME] | n | d | ) |  |  | n | 10
[NAME] | n | d | )1 |  |  | nc | 10
[NAME] | n | A | [NAME] |  |  | n1 | 10
[NAME] | ) | P | P |  |  | n2 | 10
[NAME] | d2 | nt | A |  |  | d | 8
Greg | d3 | P12 | N1 |  |  | dc | 8
Suzy | d | N | N |  |  | d1 | 8
[NAME] | A | N1 | N2 |  |  | d2 | 8
 |  |  |  |  |  | d3 | 8
Total |  |  |  |  |  | d* | 8
 |  |  |  |  |  | [NAME] | 8
Needed Result | 78 | 82 | 86 |  |  | a | 12
 |  |  |  |  |  | ac | 12
 |  |  |  |  |  | a1 | 12
 |  |  |  |  |  | a2 | 12
 |  |  |  |  |  | p | 12
 |  |  |  |  |  | nt | 10
 |  |  |  |  |  | ) | 12
 |  |  |  |  |  | )1 | 12
 |  |  |  |  |  | )c | 12
 |  |  |  |  |  | p10 | 10
 |  |  |  |  |  | p12 | 12
Spreadsheet: 863727d1711117564-sortby-with-dynamic-columns-sortby-dynamic-parameter
Sheet: Feuil1

 | START WITH |  |  |  |  | STEP1 |  |  |  |  | STEP2 |  |  |  |  | STEP 3 - EXPECTED RESULT
 | ID | COL1 | COL2 | [NAME] |  | ID | COL1 | COL2 | [NAME] |  | ID | COL1 | COL2 | [NAME] |  | ID | COL1 | COL2 | [NAME]
 |  | C | B | C |  |  | A | B | C |  |  | A | A | B |  |  | A | A | B
 | 2 | C | B | A |  | 8 | A | B | A |  | 7 | A | B | C |  | 8 | A | B | A
 | 3 | C | A | B |  | 9 | A | A | B |  | 8 | A | B | A |  | 7 | A | B | C
 | 4 | B | B | C |  | 4 | B | B | C |  | 6 | B | A | B |  | 6 | B | A | B
 | 5 | B | B | A |  | 5 | B | B | A |  | 4 | B | B | C |  | 5 | B | B | A
 | 6 | B | A | B |  | 6 | B | A | B |  | 5 | B | B | A |  | 4 | B | B | C
 | 7 | A | B | C |  | 1 | C | B | C |  | 3 | C | A | B |  | 3 | C | A | B
 | 8 | A | B | A |  | 2 | C | B | A |  | 1 | C | B | C |  | 2 | C | B | A
 | 9 | A | A | B |  | 3 | C | A | B |  | 2 | C | B | A |  | 1 | C | B | C
 |  |  |  |  |  |  | A | A | B
 |  |  |  |  |  | 8 | A | B | A
1 | C | B | C |  |  | 7 | A | B | C
2 | C | B | A |  |  | 6 | B | A | B
3 | C | A | B |  |  | 5 | B | B | A
4 | B | B | C |  |  | 4 | B | B | C
5 | B | B | A |  |  | 3 | C | A | B
6 | B | A | B |  |  | 2 | C | B | A
7 | A | B | C |  |  | 1 | C | B | C
8 | A | B | A
9 | A | A | B
Spreadsheet: 884475d1733660684-top-10-with-duplicates-ppe-spreadsheet
Sheet: Top 10% 

 | 2024-10-01 00:00:00 |  |  |  |  | 2024-11-01 00:00:00 |  |  |  |  | 2024-12-01 00:00:00
Rank | Name | items | Percentage |  | Rank | Name | items | Percentage |  | Rank | Name | items | Percentage
1 |  |  |  |  | 1 |  |  |  |  | 1
2 |  |  |  |  | 2 |  |  |  |  | 2
3 |  |  |  |  | 3 |  |  |  |  | 3
4 |  |  |  |  | 4 |  |  |  |  | 4
5 |  |  |  |  | 5 |  |  |  |  | 5
6 |  |  |  |  | 6 |  |  |  |  | 6
7 |  |  |  |  | 7 |  |  |  |  | 7
8 |  |  |  |  | 8 |  |  |  |  | 8
9 |  |  |  |  | 9 |  |  |  |  | 9
10 |  |  |  |  | 10 |  |  |  |  | 10
11 |  |  |  |  | 11 |  |  |  |  | 11
12 |  |  |  |  | 12 |  |  |  |  | 12
13 |  |  |  |  | 13 |  |  |  |  | 13
14 |  |  |  |  | 14 |  |  |  |  | 14
Rank | Item | Quantities | Percentage |  | Rank | Item | Quantities | Percentage |  | Rank | Item | Quantities | Percentage
1 |  |  |  |  | 1 |  |  |  |  | 1
2 |  |  |  |  | 2 |  |  |  |  | 2
3 |  |  |  |  | 3 |  |  |  |  | 3
4 |  |  |  |  | 4 |  |  |  |  | 4
5 |  |  |  |  | 5 |  |  |  |  | 5
6 |  |  |  |  | 6 |  |  |  |  | 6
7 |  |  |  |  | 7 |  |  |  |  | 7
8 |  |  |  |  | 8 |  |  |  |  | 8
9 |  |  |  |  | 9 |  |  |  |  | 9
10 |  |  |  |  | 10 |  |  |  |  | 10
11 |  |  |  |  | 11 |  |  |  |  | 11
12 |  |  |  |  | 12 |  |  |  |  | 12
13 |  |  |  |  | 13 |  |  |  |  | 13
14 |  |  |  |  | 14 |  |  |  |  | 14
Spreadsheet: 52071d1251785972-spreadsheets-rgp5_south_earthworks
Sheet: Sheet1

RGP5 South Blast & Excavate Quota - SP16
 | SP16 m3 Rock | Amount/Day Neede | Actual Amount/Day | Daily Excess or Under | Cumulative Excess or Under | Amount Needed Next Day to Meet Quota | Quota Meet This Day | Cumulative Amount | Days Remaining To Acheive Total | Days Remaining To Achieve Target | Graph Neede  Amt Day | Graph Actual Amt Day | Graph Cumulative  Amt Day
2009-09-12 00:00:00 | 500 | 500 | 500 |  |  | 0 |  |  |  | 23
2009-09-13 00:00:00 | 1000 | 500 | 555 |  | 55 |  |  |  |  | 22
2009-09-14 00:00:00 | 1500 | 500 | 450 |  |  |  |  |  |  | 21
2009-09-15 00:00:00 | 2000 | 500 | 444 |  |  |  |  |  |  | 20
2009-09-16 00:00:00 | 2500 | 500 | 560 |  |  |  |  |  |  | 19
2009-09-17 00:00:00 | 3000 | 500 | 555 |  |  |  |  |  |  | 18
2009-09-18 00:00:00 | 3500 | 500 | 430 |  |  |  |  |  |  | 17
2009-09-19 00:00:00 | 4000 | 500 | 506 |  |  |  |  |  |  | 16
2009-09-20 00:00:00 | 4500 | 500 | 555 |  |  |  |  |  |  | 15
2009-09-21 00:00:00 | 5000 | 500 | 565 |  |  |  |  |  |  | 14
2009-09-22 00:00:00 | 5500 | 500 | 345 |  |  |  |  |  |  | 13
2009-09-23 00:00:00 | 6000 | 500 | 235 |  |  |  |  |  |  | 12
2009-09-24 00:00:00 | 6500 | 500 | 335 |  |  |  |  |  |  | 11
2009-09-25 00:00:00 | 7000 | 500 | 445 |  |  |  |  |  |  | 10
2009-09-26 00:00:00 | 7500 | 500 | 567 |  |  |  |  |  |  | 9
2009-09-27 00:00:00 | 8000 | 500 | 0 |  |  |  |  |  |  | 8
2009-09-28 00:00:00 | 8500 | 500 | 0 |  |  |  |  |  |  | 7
2009-09-29 00:00:00 | 9000 | 500 | 0 |  |  |  |  |  |  | 6
2009-09-30 00:00:00 | 9500 | 500 | 0 |  |  |  |  |  |  | 5
2009-10-01 00:00:00 | 10000 | 500 | 0 |  |  |  |  |  |  | 4
2009-10-02 00:00:00 | 10500 | 500 | 0 |  |  |  |  |  |  | 3
2009-10-03 00:00:00 | 11000 | 500 | 0 |  |  |  |  |  |  | 2
2009-10-04 00:00:00 | 11500 | 500 | 0 |  |  |  |  |  |  | 1
2009-10-05 00:00:00 | 12000 | 500 | 0 |  |  |  |  |  |  | 0
Spreadsheet: 851b8669-99a2-4ca0-ad6e-93140f56e99e
Sheet: Sheet1

BUSINESS INNOVATION PROGRAMME | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
ASSET REGISTER TEMPLATE
SCHEDULE 4
Form | ERDF-WI-8-001
Organisation:
Address:
SECTION 1 |  |  |  |  |  | SECTION 2 |  |  | SECTION 3
ERDF Project Reference | Asset description | Serial or identification number | Location of the asset | Purchase price (net recoverable VAT) | Date of acquisition | Details of any charges (where relevant) | Location of the title deeds or ownership records (where relevant); | Date of Depreciation | Value of accumulated depreciation | Current Value
Where an asset is acquired a standard asset register template should be completed (Form - ERDF -WI-8-001)
The Funding Agreement provides the definition of assets as being one of the following;
“Fixed Asset” means any Asset which consists of land and/or buildings, plant, machinery or other thing that is, or is to be, fixed to any land and which is to be acquired, developed, enhanced, constructed and/or installed as part of the Project.
“Major Asset” means an Asset which is not a Fixed Asset but has a value as at the date of this Funding Agreement (or date of acquisition if the acquisition is funded (in whole or in part) by this Grant) of at least £5,000.00.
Section 1 of the register must be completed for all assets. Please provide as much detail as possible.
Section 2 must be completed where a charge is attached to a particular asset.
Section 3 needs only be completed where relevant.
ERDF assets must be retained for a number of years depending on the type of asset. The majority of assets have to be retained for 5 years after the end of the project unless it relates to an investment or jobs created by SME’s in which case the retention period is 3 years
Assets must not be used for any other purpose than that approved throughout the useful economic life of the asset. You cannot change the use of the asset without written consent of Birmingham City Council/DCLG..
You cannot dispose of assets without the consent of Birmingham City Council/DCLG and if you would like to dispose of an asset you must complete an asset disposal template available from Birmingham City Council.
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Skil

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
2898-06 | SKL-AMB-2898_06 |  | 73 | 90 | 125 |  |  |  | X
 | SKL-DRL-2898 | 1 |  | 35 | 33 |  |  |  | X
 | SKL-CHG-SC118C | 1 |  | 27 | 28 |  |  |  | X
 | SKL-BAT-SB18C | 2 |  | 90 | 74 |  |  |  | X
2414-02 | SKL-AMB-2414_02 |  | 46 | 80 | 60 |  |  |  | X
 | SKL-DRL-2414 | 1 |  | 65 | 65 |  |  |  | X
 | SKL-BAT-SB12A_LI | 2 |  | 70 | 40 |  |  |  | X
 | SKL-CHG-SC12A_LI | 1 |  | 29 | 29 |  |  |  | X
 | SKL-CAS-2414_02 | 1 |  | 0 | 0
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: 757017d1637939184-probability-function-find-distrib
Sheet: solver prob

 | mean | std dev | min | median | [NAME] | total | count
Choice1 |  | 4.6 | 1 | 5 | 27 | 16919 | 2850
Choice2 |  | 6.1 | 2 | 11 | 35 | 33786 | 2850
Choice3 |  | 6.7 | 3 | 17 | 39 | 50124 | 2850
Choice4 |  | 6.7 | 4 | 24 | 41 | 67228 | 2850
Choice5 |  | 6.2 | 9 | 30 | 43 | 84160 | 2850
Choice6 |  | 5 | 12 | 37 | 44 | 101005 | 2850
choice #1
numbers | prob distrib | stats
1 | 0.1436312210292894 |  | goal=100%
2 | 0.1221346107714539 |  | < med
3 | 0.1187885931617034 |  | >=med
4 | 0.1154455750375533 |  | mean
5 | 0.06209394529104137 |  | sd
6 | 0.05875692200652344
7 | 0.05542289866584946
8 | 0.05209187519804642
9 | 0.06564043413963785
10 | 0.04543882057369113
11 | 0.04211679018186299
12 | 0.03879775947898099
13 | 0.0354817305848277
14 | 0.001
15 | 0.02381870883076907
16 | 0.001
17 | 0.001
18 | 0.001
19 | 0.001
20 | 0.001
21 | 0.001
22 | 0.001
23 | 0.001
24 | 0.001
25 | 0.001
26 | 0.001
27 | 0.00834011504876955
Spreadsheet: 65623d1266336666-index-and-match-formulas-sample
Sheet: Sample #

Sample# | Die# | [NAME] | Board | 4/c + Coat | 5/c + Coat | 6/c + Coat
060987 | 060987-O-4 | 5.3281 x 1.9531 x 5.2968 | .016 SBS | 028586 | 028574 | 028534
060955 | 060955-O-8 | 2.375 x 1.75 x 5.2968 | .016 SBS |  | 028575 | 028535
060900 | 060900-O-4 | 5.3281 x 2.5 x 4.625 | .016 SBS |  | 028576 | 028536
060996 | 060996-O-4 | 5.3281 x 1.625 x 4.625 | .016 SBS |  | 028577 | 028540
061151 | 061151-O-8 | 2.375 x .75 x 5.2968 | .016 SBS |  | 028579 | 028541
060995 | 060995-O-4 | 5.3281 x 2.875 x 4.625 | .016 SBS |  | 028580 | 028542
060995 | 060995-O-3 | 5.3281 x 2.875 x 4.625 | .020 SBS |  | 028623 | 028622
070913 | 070913-O-6 | 5.1093 x 1.1093 x 6.2031 | .016 SBS |  | 028581 | 028543
081275 | 081275-O-4 | 5.3281 x 1.9531 x 4.625 | .016 SBS |  | 028582 | 028545
080757 | 080757-O-2 | 4.75 x 1.7812 x 10.7187 | .016 SBS |  | 028583 | 028547
090060 | 090060-O-8 | 2.375 x .95 x 5.2968 | .016 SBS |  | 028584 | 028548
Spreadsheet: 290366d1389860987-create-alphabetical-list-but-retain-original-order-alphabetize
Sheet: Employee List

Date hired | Employees |  |  |  |  |  |  | Alphabetical list |  |  |  |  |  |  |  |  |  | Alphabetical list
2014-01-01 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
2014-01-05 00:00:00 | [NAME] | I need to retain original order of column B… |  |  |  |  |  | [NAME] | …but I want to create an alphabetical list of column H to be used in my drop-down |  |  |  |  |  |  |  |  | [NAME]
2014-01-12 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
2014-01-19 00:00:00 | [NAME] |  |  |  |  |  |  | Dom |  |  |  |  |  |  |  |  |  | Dom
2014-02-02 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-04 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-05 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] | <----…...I need it automatically included alphabetically here under (after [NAME]) |  |  |  |  |  |  |  |  | [NAME]
2014-02-09 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Lauren | <---so it looks like this
2014-02-12 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-15 00:00:00 | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-22 00:00:00 | Dom |  |  |  |  |  |  | Tedd |  |  |  |  |  |  |  |  |  | [NAME]
2014-02-23 00:00:00 | Tedd |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Tedd
1900-01-25 00:00:00 | Lauren | <---If I add this entry to column B……… |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 130520d1322410923-sorting-data-of-date-time-format-and-filtering-for-count-duration-calculation-within-same-cell
Sheet: Sheet2

Count of START
Years | START | Total
2010 | lip | 3
 | srp | 4
 | ruj | 1
 | lis | 1
 | [NAME] | 1
 | pro | 2
2011 | sij | 5
 | vlj | 4
 | ožu | 6
 | tra | 1
 | svi | 15
 | lip | 44
 | srp | 55
 | kol | 51
 | ruj | 60
 | lis | 58
 | [NAME] | 46
Grand Total |  | 357
Spreadsheet: 15cb5305-c2c0-428e-8f91-4001d0a3f541
Sheet: Sheet1

Global X MLP ETF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Fund Holdings Data as of 10/24/2014
% of Net Assets | Name | Identifier | Market Price($) | Shares Held | Market Value($)
5.83 | ENERGY TRANSFER PARTNERSP | 29273R109 | 64.81 | 125769 | 8151088.89
5.54 | KINDER MORGAN ENERGY PRTN | 494550106 | 95.36 | 81225 | 7745616
5.41 | [NAME] PARTNERS | 118230101 | 78.76 | 96124 | 7570726.24
5.36 | REGENCY ENERGY PARTNERS | 75885Y107 | 31.41 | 238541 | 7492572.81
5.27 | PLAINS ALL AMERN PIP | 726503105 | 56.11 | 131232 | 7363427.52
5.25 | ENTERPRISE PRODUCTS PRTNR | 293792107 | 38.5 | 190614 | 7338639
5.21 | MAGELLAN MIDSTREAM | 559080106 | 80.63 | 90420 | 7290564.6
5.11 | MARKWEST ENERGY-PART UTS | 570759100 | 72.26 | 98816 | 7140444.16
4.79 | ONEOK PARTNERS LP | 68268N103 | 53.17 | 125885 | 6693305.45
4.59 | [NAME] PARTNERS LP | 96950F104 | 50 | 128254 | 6412700
4.44 | ENBRIDGE ENERGY PARTNERS | 29250R106 | 37.06 | 167522 | 6208365.32
4.18 | SUNOCO LOGISTICS PRTS | 86764L108 | 47.34 | 123344 | 5839104.96
3.72 | TARGA RESOURCES PARTNERS | 87611X105 | 63.66 | 81646 | 5197584.36
3.56 | ACCESS MIDSTREAM PARTNERS | 00434L109 | 60.83 | 81773 | 4974251.59
3.26 | EL PASO PIPELINE PART LP | 283702108 | 41.21 | 110636 | 4559309.56
2.85 | WESTERN GAS PARTNERS L.P. | 958254104 | 72.77 | 54863 | 3992380.51
2.84 | NUSTAR ENERGY LP | 67058H102 | 65.53 | 60518 | 3965744.54
2.73 | DCP MIDSTREAM PARTNER LLP | 23311P100 | 55.07 | 69278 | 3815139.46
2.36 | AMERIGAS PARTNERS-LP | 030975106 | 46.29 | 71164 | 3294181.56
2.05 | EQT MIDSTREAM PARTNERS | 26885B100 | 90.47 | 31617 | 2860389.99
1.99 | GENESIS ENERGY L.P. | 371927104 | 48.78 | 56985 | 2779728.3
1.83 | CRESTWOOD MIDSTREAM PART | 226378107 | 21.24 | 120161 | 2552219.64
1.65 | ENLINK MIDSTREAM PARTNERS | 29336U107 | 31.12 | 73952 | 2301386.24
1.63 | [NAME] | 87233Q108 | 62.77 | 36395 | 2284514.15
1.55 | SPECTRA ENERGY PARTNERS | 84756N109 | 53.44 | 40558 | 2167419.52
1.53 | SUBURBAN PROPANE PARTNERS | 864482104 | 45.51 | 46914 | 2135056.14
1.5 | ATLAS PIPELINE PARTNERS | 049392103 | 36.05 | 58228 | 2099119.4
1.35 | NGL ENERGY PARTNERS LP | 62913M107 | 36.98 | 50920 | 1883021.6
1.26 | TESORO LOGISTICS LP | 88160T107 | 58.35 | 30202 | 1762286.7
1.15 | [NAME]. PART. | 096627104 | 17 | 94250 | 1602250
1.08 | ALLIANCE RESOURCE PTNRLP | 01877R108 | 44.73 | 33664 | 1505790.72
1.06 | ATLAS ENERGY LP | 04930A104 | 39.2 | 37715 | 1478428
0.8 | EV ENERGY PARTNERS L.P. | 26926V107 | 31.79 | 35355 | 1123935.45
0.8 | NORTHERN TIER ENERGY LP | 665826103 | 24.72 | 45254 | 1118678.88
0.75 | CHENIERE ENERGY PARTNERS | 16411Q101 | 31.53 | 33395 | 1052944.35
0.72 | PHILLIPS 66 PARTNERS LP | 718549207 | 66.55 | 15045 | 1001244.75
0.57 | CRESTWOOD EQUITY PARTNERS | 226344109 | 9.19 | 87412 | 803316.28
0.35 | ENABLE MIDSTREAM PARTNERS | 292480100 | 24.44 | 20000 | 488800
0.11 | CASH | CASH | 1 | 155399.37 | 155399.37
0.11 | VIPER ENERGY PARTNERS LP | 92763M105 | 21.36 | 7050 | 150588