tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 257bd45d-25bc-40aa-a873-49f3b35bf73f
Sheet: Classified NFE

University of Idaho - Leave Taken Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAY#
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORG# |  | 0
Last Name, First Name |  |  |  |  |  |  |  | V00000000
Pay Period Beginning |  | 2013-12-08 00:00:00 |  |  |  |  | Ending
Work Time | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Week 1 Total | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Week 2 Total | Pay Period Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
DEDUCTIONS
Annual Leave (VAC)*
[NAME] (SIC)*
Medical Appoint (MED)*
Shared Leave (SHL)
LWOP w/Ben (LWB)
LWOP w/o [NAME] (LWO)
LWOP w/o [NAME] (LWA)
Holiday (HOL)
[NAME] (ADL)
Jury Duty (JRY)
Military (MIL)
TOTAL HOURS
Special Instructions
Employee's Signature |  |  |  |  |  |  |  |  |  |  |  |  | Date
Employer's Signature |  |  |  |  |  |  |  |  |  |  |  |  | Date
2013-12-08 00:00:00 | 1
 | 1
 | 27
 | 1
Spreadsheet: 724183d1616056538-look-up-data-dependent-on-multiple-criteria-data-lookup-test-data
Sheet: Test Example

Ticket no. | Mapped Status | Status start | Status end | Current status? | Status Start Copy
100001 | New | 2019-12-18 15:42:22 | 2019-12-18 15:54:51
100001 | Under Investigation | 2019-12-18 15:54:51 | 2019-12-18 16:49:09
100001 | Waiting for Customer | 2019-12-18 16:49:09 | 2019-12-27 11:49:10
100001 | Resolved | 2019-12-27 11:49:10 | 2020-02-17 11:56:02
100001 | Under Investigation | 2020-02-17 11:56:02 | 2020-02-17 12:04:09
100001 | Under Investigation | 2020-02-17 12:04:09 | 2020-02-17 12:10:18
100001 | Under Investigation | 2020-02-17 12:10:18 | 2020-02-17 13:53:09
100001 | Under Investigation | 2020-02-17 13:53:09 | 2020-02-17 13:53:47
100001 | 2nd Line | 2020-02-17 13:53:47 | 2020-02-17 13:53:52
100001 | Under Investigation | 2020-02-17 13:53:52 | 2020-11-12 14:14:36
100001 | Resolved | 2020-11-12 14:14:36 | 2020-11-17 11:14:36
100001 | Resolved | 2020-11-17 11:14:36 |  | Y
100002 | New | 2019-12-18 15:45:23 | 2019-12-18 15:47:39
100002 | Under Investigation | 2019-12-18 15:47:39 | 2019-12-19 09:06:54
100002 | Resolved | 2019-12-19 09:06:54 | 2019-12-19 09:06:56
100002 | Under Investigation | 2019-12-19 09:06:56 | 2019-12-19 09:39:15
100002 | Under Investigation | 2019-12-19 09:39:15 | 2019-12-19 09:39:18
100002 | Resolved | 2019-12-19 09:39:18 | 2019-12-19 09:48:16
100002 | Under Investigation | 2019-12-19 09:48:16 | 2019-12-19 09:48:28
100002 | Under Investigation | 2019-12-19 09:48:28 | 2019-12-19 09:53:41
100002 | 2nd Line | 2019-12-19 09:53:41 | 2019-12-30 11:44:37
100002 | Under Investigation | 2019-12-30 11:44:37 | 2019-12-30 11:49:38
100002 | Resolved | 2019-12-30 11:49:38 | 2019-12-30 11:49:39
100002 | Under Investigation | 2019-12-30 11:49:39 | 2019-12-30 11:59:17
100002 | Under Investigation | 2019-12-30 11:59:17 | 2019-12-30 11:59:20
100002 | Resolved | 2019-12-30 11:59:20 | 2020-01-02 17:29:21
100002 | Resolved | 2020-01-02 17:29:21 |  | Y
(1)
Ticket no. |  | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
100002
(2)
Ticket no. | Status | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
100001 | New
100001 | Under Investigation
100001 | 2nd Line
100001 | Prod Issue
100001 | Waiting for Customer
100001 | Suggestion
100001 | Resolved
100002 | New
100002 | Under Investigation
100002 | 2nd Line
100002 | Prod Issue
100002 | Waiting for Customer
100002 | Suggestion
100002 | Resolved
Spreadsheet: 192569d1352460317-excel-2010-format-all-the-row-based-on-the-value-color-of-1-cell-test_to-upload
Sheet: BIANNUAL - PAYMENT DATE NO EOM

start/coupon days | 2012-08-03 00:00:00 | 2 | 1 | 3
1 | 2013-02-03 00:00:00 | 8 | 7
Accrual date |  |  | Rate | 30/360 days | interest | Interest accr. | Interest capital.
 |  |  |  |  | 0 | 0
 |  | 650000 | 0.069
 |  | 650000
Spreadsheet: 843294d1695186370-a-doosy-complex-logic-for-filtering-can-you-figure-it-out-copy-of-test-formulas
Sheet: Scratch

Vendor | Library Type | Instrument Types A | Instrument Types B | Instrument Types C | Instrument Types D | Instrument Types ALL | Applications A | Applications B | Applications C | Applications ALL |  |  |  |  |  |  |  |  |  |  |  |  |  | Instrument Types ALL HELPER | Applications ALL HELPER
8Dio |  | [NAME] |  |  |  | [NAME]
Cinesamples
Spreadsheet: 870701d1717166549-create-summary-page-using-formula-from-multiple-sheets-data-are-in-different-columns-on-ea-sample-file
Sheet: Sheet1

 | Name | Price A | Price-B | PriceC
 | Brand1 | 5 | 2 | 1
 | Brand2 | 10 | 6 | 25
 | Brand3 | 15 | 10 | 55
 | Brand4 | 20 | 14 | 81
 | Brand5 | 25 | 18 | 108
 | Brand6 | 30 | 22 | 135
 | Brand7 | 35 | 26 | 162
 | Brand1 | 40 | 30 | 189
 | Brand4 | 45 | 34 | 216
 | Brand5 | 55 | 42 | 270
Spreadsheet: 869237d1715859061-transferring-numbers-to-the-table-from-vertical-to-horizontal-mode-table
Sheet: Table

 | Table 1 |  |  |  | Table 2
cod | City | 2022 estimate |  |  | COD | NAME | STATUS | January | February | March | April | New York | Los Angeles | Chicago | Houston | Phoenix | Philadelphia | San Antonio | Dallas | [NAME] | Jacksonville | San Jose | Fort Worth | Columbus | Charlotte | San Francisco
1000 | New York | 635778.86419 |  |  | 1000 | WEK910 | A | 12011 | 7404 | 7404 | 3354
1000 | Los Angeles | 291522.09226 |  |  |  |  | B | 14958 | 7554 | 4200 | 2272
1000 | Chicago | 203262.52453 |  |  |  |  | C | 0 | 0 | 0 | 7000
1000 | Houston | 175640.50506 |  |  |  |  | D | 0 | 0 | 0 | 0
1000 | Phoenix | 125419.07443 |  |  |  |  | E | 0 | 0 | 0 | 7000
1000 | Philadelphia | 119534.76766 |  |  |  |  | F
1000 | San Antonio | 112338.76943 |  |  |  |  | G | 0 | 0 | 0 | 0
1000 | Dallas | 99116.22088000001 |  |  | 2000 | WEK911 | A | 12011 | 7404 | 7404 | 3354
1000 | [NAME] | 74321.07269 |  |  |  |  | B | 14958 | 7554 | 4200 | 2272
1000 | Jacksonville | 74082.50013 |  |  |  |  | C | 0 | 0 | 0 | 7000
1000 | San Jose | 74075.94091 |  |  |  |  | D | 0 | 0 | 0 | 0
1000 | Fort Worth | 72968.19542999999 |  |  |  |  | E | 0 | 0 | 0 | 7000
1000 | Columbus | 69250.94817 |  |  |  |  | F
1000 | Charlotte | 68469.1044 |  |  |  |  | G | 0 | 0 | 0 | 0
1000 | San Francisco | 61659.48999 |  |  | 3000 | WEK912 | A | 12011 | 7404 | 7404 | 3354
2000 | New York | 127155.772838 |  |  |  |  | B | 14958 | 7554 | 4200 | 2272
2000 | Los Angeles | 58304.418452 |  |  |  |  | C | 0 | 0 | 0 | 7000
2000 | Chicago | 40652.504906 |  |  |  |  | D | 0 | 0 | 0 | 0
2000 | Houston | 35128.101012 |  |  |  |  | E | 0 | 0 | 0 | 7000
2000 | Phoenix | 25083.814886 |  |  |  |  | F
2000 | Philadelphia | 23906.953532 |  |  |  |  | G | 0 | 0 | 0 | 0
2000 | San Antonio | 22467.753886
2000 | Dallas | 21068.245148
2000 | [NAME] | 19823.244176
2000 | Jacksonville | 14864.214538
2000 | San Jose | 14816.500026
2000 | Fort Worth | 14815.188182
2000 | Columbus | 14593.639086
2000 | Charlotte | 13850.189634
2000 | San Francisco | 13693.82088
2000 | New York | 13432.992734
2000 | Los Angeles | 12331.897998
3000 | Chicago | 381467.318514
3000 | Houston | 174913.255356
3000 | Phoenix | 121957.514718
3000 | Philadelphia | 105384.303036
3000 | San Antonio | 75251.444658
3000 | Dallas | 71720.860596
3000 | [NAME] | 67403.261658
3000 | Jacksonville | 63204.73544400001
3000 | San Jose | 59469.732528
3000 | Fort Worth | 44592.643614
3000 | Columbus | 44449.500078
3000 | Charlotte | 44445.564546
3000 | San Francisco | 43780.917258
Spreadsheet: 083e956b-f565-42e1-b08f-25f262ea1824
Sheet: Sheet1

Revenue/Income | Unnamed: 1 | Unnamed: 2 | 2011 | Unnamed: 4 | 2012 | Unnamed: 6 | 2013 | Unnamed: 8 | 2014 | 2015 | Expenses | 2011.1 | 2012.1 | 2013.1 | 2014.1 | 2015.1
Rates |  |  |  |  |  |  |  |  |  |  | Operations and Maintenance
Fees and Services |  |  |  |  |  |  |  |  |  |  | Salaries and Benefits
[NAME] |  |  |  |  |  |  |  |  |  |  | Contract Operation
Grants & Loans - e.g. SRF |  |  |  |  |  |  |  |  |  |  | Maintenance
Other Sources - e.g. interest |  |  |  |  |  |  |  |  |  |  | Power and Other Utilities
 |  |  |  |  |  |  |  |  |  |  | Regulatory Fees
 |  |  |  |  |  |  |  |  |  |  | Treatment Chemicals
 |  |  |  |  |  |  |  |  |  |  | Monitoring/Testing
 |  |  |  |  |  |  |  |  |  |  | Transportation
 |  |  |  |  |  |  |  |  |  |  | Materials, Supplies, and Parts
 |  |  |  |  |  |  |  |  |  |  | Office Suplies
 |  |  |  |  |  |  |  |  |  |  | Miscellaneous
 |  |  |  |  |  |  |  |  |  |  | General and Administrative
 |  |  |  |  |  |  |  |  |  |  | Engineering and Professional Services
 |  |  |  |  |  |  |  |  |  |  | Insurance
 |  |  |  |  |  |  |  |  |  |  | Debt Service
 |  |  |  |  |  |  |  |  |  |  | Miscellaneous
 |  |  |  |  |  |  |  |  |  |  | Reserve Funds
 |  |  |  |  |  |  |  |  |  |  | O&M Reserve
 |  |  |  |  |  |  |  |  |  |  | CIP Reserve
 |  |  |  |  |  |  |  |  |  |  | Other Reserve
 |  |  |  |  |  |  |  |  |  |  | Capital Projects
 |  |  |  |  |  |  |  |  |  |  | Multi-year/Recurring
 |  |  |  |  |  |  |  |  |  |  | One time
Total Revenue/Income |  |  | $               - |  | $               - |  | $               - |  | $               - | $               - | Total Expenses | $               - | $               - | $               - | $               - | $               -
2011 | 2012 | 2013 |  | 2014 |  | 2015
Number of Customers:
Average Monthly Revenue Needed per Customer:
(total expenses ÷ # of customers ÷ 12)
Budget                                                                                                                                                                                                                                           3
Spreadsheet: 38295d1236395482-vlookup-and-copy-worksheet-vlookupcopy
Sheet: Source

Bonds
 | Trade date | Value date | Amt | Currency | Inputter
 | 2009-03-01 00:00:00 | 2009-05-30 00:00:00 | 1000000 | USD | [NAME]
 | 2009-03-01 00:00:00 | 2010-05-30 00:00:00 | 15000000 | GBP | [NAME]
 | 2009-03-01 00:00:00 | 2009-05-30 00:00:00 | 1000000 | USD | [NAME]
 | 2009-03-01 00:00:00 | 2009-06-30 00:00:00 | 1000000 | [NAME] | [NAME]
 | 2009-03-01 00:00:00 | 2009-05-30 00:00:00 | 1000000 | USD | [NAME]
Spreadsheet: 55a6a244-d905-4643-918e-378b2b1c9f83
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
APLA1 | Test | APLA1 | [NAME], Plasma | [NAME], P | Automated Turbidimetric Immunoassay | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Collection Container/Tube: Lavender top (EDTA) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Fasting-overnight (12-14 hours).  2. Patient must not consume any alcohol for 24 hours before the specimen is drawn. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | > or =18 years: 106-220 mg/dL Reference values have not been established for patients that are less than 18 years of age. | Monday through Friday; [NAME] | 1 day (not reported on Saturday or Sunday) | 3 days | 1 | 82172 |  |  |  |  | Rochester
APLA1 | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 8 days
APLA1 | Result | APLA1 | [NAME], P | [NAME], P | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 1869-7 | Apolipoprotein A-I:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 728396d1618428528-formatting-numbers-after-decimals-a320-takeoff-qrt-beta
Sheet: IAE

 |  | AIRPORT |  | ZSPD |  | MAX CROSSWIND LIMIT INCLUDING GUST |  | 33
 |  | RWY ° |  | 16R
 |  | ELEVN ft |  | 15 |  | TODAY CROSSWIND
 |  | LENGTH m |  | 3700
 |  | SLOPE % |  | 0
 |  | CWY
 |  |  |  |  |  |  | CONF
 |  | WIND °/kt | 90 | 17 |  |  | THRUST
 |  |  | GUST | 0
 |  | OAT °C |  | 18 |  |  | V1 |  | kt
 |  | QNH hPa |  | 1007 |  |  | VR |  | kt
 |  | RWY COND |  | DRY |  |  | V2 |  | kt
 |  | TOW T |  | 65000
 |  | THRUST |  | FLEX |  |  | REV FOR COMPUTATION
 |  | CONF |  | CONF 2 |  |  | All reversers operative
 |  | AIR COND |  | ON
 |  | A.ICE |  |  |  |  | MTOW |  | T
 |  | TOCG % |  | 33.4
Spreadsheet: 753584d1635533919-if-cell-contains-hyperlink-sample-file
Sheet: Sheet1

Name | Review
Hyperlink1 | Good
[NAME] | Good
check2 | Good
[NAME] | Good
Hyperl2 | Good
[NAME] | Good
chec3 | Good
[NAME] | Good
Hype2 | check
Hype10 | check
Hype4 | check
[NAME] | Good
Hyperlink5 | Good
check5 | check
[NAME] | Good
Spreadsheet: 715175d1611592487-how-to-add-additional-requirements-to-indirect-statements-copy-20200818-obsolete-tooling-rev-1
Sheet: 20200910 Curtis (Oper Supplies)

Material | Short Text | Profit Center | Valuation Class | MRP Controller | MRP | Valuation Type (Batch) | Valuation Type (Batch) | Location | Del. flag: stge type | DF at plant level | Plant-sp.matl status | Total Stock (Qty in Inventory) | Total Value (Value Unrestricted) | Number of Years | Days since consumption | Moving price | Price Unit | OBSOLETE? (Yes / No) | Comments
78-5004-0589-9-00 | CURTAIN,LIGHT [NAME] | 619029705 | 7060 | 5 |  | C1 |  | FM21-3B1 |  |  |  | 3 | 7468.95 |  | 3840 | 248965 | 100 | Yes
78-5004-0589-9-00 | CURTAIN,LIGHT [NAME] | 619029705 | 7060 | 5 |  | C2 |  | FM21-3B1 |  |  |  | 1 | 2489.65 |  | 3840 | 248965 | 100 | Yes
78-5004-0589-6-00 | CURTAIN,LIGHT [NAME] | 619029705 | 7060 | 5 |  | C1 |  | FM21-3B1 |  |  |  | 3 | 7468.95 |  | 3840 | 248965 | 100
Spreadsheet: 84233d1284235240-create-a-list-from-a-table-book2
Sheet: Table

Name
[NAME] | 1969 | 1973
[NAME] | 1949 | 1951
[NAME] | 1989 | 1991 | 1993 | 2002
[NAME] | 1955 | 1961
[NAME] | 1969 | 1971
[NAME] | 1947
[NAME] | 1979 | 1987
[NAME] | 1969 | 1971
[NAME] | 1989 | 1991 | 1993
[NAME] | 2002 | 2004 | 2006 | 2008
[NAME] | 1961
[NAME] | 1971
[NAME] | 1993
[NAME] | 1989 | 1991 | 1993 | 1995 | 1997
[NAME] | 1931
[NAME] | 1981 | 1983 | 1987 | 1995
[NAME] | 2008
[NAME] | 1995 | 1997
[NAME] | 1957 | 1959 | 1961 | 1963
[NAME] | 1969 | 1975 | 1977 | 1981 | 1983 | 1985 | 1991 | 1993
[NAME] | 1955 | 1957 | 1959 | 1961
Fred Funk | 2004
[NAME] | 1957
[NAME] | 1985 | 1995
[NAME] January | 1965 | 1977
[NAME] | 1993 | 1997
[NAME] | 2006
[NAME] | 1947
[NAME] | 2008
[NAME] | 1979 | 1981 | 1983 | 1985 | 1987 | 1989 | 1993
[NAME] | 1953 | 1955 | 1957
[NAME] | 1935
[NAME] | 1995 | 1997 | 1999
[NAME] | 1963 | 1965
[NAME] | 1997 | 1999 | 2008
[NAME] | 1991
[NAME] | 1981
[NAME] | 1961 | 1963 | 1965 | 1967 | 1969 | 1971 | 1975
[NAME] | 1993 | 1995 | 1997 | 1999 | 2002 | 2004
[NAME] | 1995 | 1997 | 1999
[NAME] | 1979
[NAME] | 1981
[NAME] | 1991 | 1999
[NAME] | 1991 | 1993 | 1995
[NAME] | 1983 | 1985
[NAME] | 2004 | 2008
[NAME] | 1935 | 1937
[NAME] | 1983 | 1985
[NAME] | 1987 | 1989 | 1991 | 1993 | 1999
[NAME] Still | 1969
[NAME] | 1971 | 1977
Curtis Strange | 1983 | 1985 | 1987 | 1989 | 1995
[NAME] | 2008
[NAME] | 1985 | 1987 | 1999 | 2002
[NAME] | 2006
[NAME] | 2002 | 2004 | 2006
[NAME] | 1969 | 1971 | 1973 | 1975 | 1979 | 1981
[NAME] | 1953
[NAME] | 1927 | 1929
[NAME] | 1965
[NAME] | 2002 | 2006
[NAME] | 1977 | 1979 | 1983 | 1985 | 1987 | 1989 | 1991 | 1993
Art Wall | 1957 | 1959 | 1961
[NAME] | 1927 | 1929
Spreadsheet: 187991d1350653236-combining-data-in-columns-into-one-row-sample-results
Sheet: Sheet1

Type |  | Position |  | Make |  | Model |  | Year | Year End
1156 |  | Reverse |  | Volkswagen |  | GTI |  | 1966 |  | 1156 Back-up/Reverse Light [NAME] 1966 - 1966
1156 |  | Reverse |  | Volkswagen |  | GTI |  | 1988 |  | 1156 Back-up/Reverse Light [NAME] 1988 - 1992
1156 |  | Reverse |  | Volkswagen |  | GTI |  | 1995 |  | 1156 Back-up/Reverse Light [NAME] 1995 - 2007
Dome 15 |  | Interior |  | Volvo |  | S60 |  | 2001 |  | Dome 15 Interior Dome Light Volvo S60 2001 - 2006
Dome 15 |  | Interior |  | Volvo |  | S60 |  | 2008 |  | Dome 15 Interior Dome Light Volvo S60 2008 -2009
Spreadsheet: 168209d1342300469-countif-previous-cell-formula-countifs-example
Sheet: Sheet1

E | I |  | <<[NAME]
I | O
E | E
I | E
O | I
E | I
I | O
E | E
I | E
O | I
E | I
I | O
E | E
I | E
O | I
E | I
I | O
E | E
I | E
O | I
E | I
I | O
E | E
I | E
O | I
E | I
I | O
E | E
I | E
O | I
E | I
I | O
E | E
I | E
Spreadsheet: 690870d1597335790-formulas-for-return-data-book1
Sheet: order

Order |  |  |  |  |  |  |  | cell link |  |  |  | order | Material | Total Value
600006 |  |  |  |  |  |  |  | 1
600021
600275
600284
600320
600325
600326
600364
600431
600447
600464
600499
600502
600525
600547
600552
600555
600557
600563
600564
600566
600585
600592
600593
600597
600599
600600
600603
600616
600617
600621
600623
600631
600632
Spreadsheet: 745173d1629795922-formula-to-update-a-price-list-from-another-example-supplier-price
Sheet: Sheet1

010275 | ELLIOT 1LT ES SQT PDT BLK | 343.95 | 215.4333333333333
010276 | ELLIOT 1LT ES TALL PDT BLK | 463.95 | 290.25
010277 | ELLIOT 1LT ES SML SQT PDT BLK | 243.95 | 135.1
010298 | ELLIOT 1LT ES SQT PDT COP | 343.95 | 215.4333333333333
010299 | ELLIOT 1LT ES TALL PDT COP | 463.95 | 290.25
010300 | ELLIOT 1LT ES SML SQT PDT COP | 243.95 | 135.1
Spreadsheet: 209978d1359333814-finding-cellson-1-sheet-and-posting-in-another-2013-est
Sheet: input

 |  |  | Player |  |  |  |  | Medical Form |  |  |  |  |  |  |  | Sizes | Shorts |  | Socks |  | Shirt
Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expenses
Round | jumper No | Date | Versus | Team | Result | score | Payment | Trys | Goals | F/Goal | [NAME] | Sent off | B/F  points | Players player | [NAME] | Shirt sox | Doubles | raffle | Other | early Pay | fines
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Elimination Final
Qualifying Final
1st Semi Final
2nd Semi Final
Preliminary Final |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Final
 |  |  |  | After 12 games
 |  |  | Player Signature:…………………. |  |  |  |  | Date Received……………………….. |  |  |  |  |  |  |  |  | TOTAL PAYMENT  DUE |  |  |  | 0
 |  |  | Cheque No:…………………………. |  |  |  |  | President Signature:…………………
Spreadsheet: 33678d1230248935-if-offset-match-or-what-feladvany_en
Sheet: Sheet1

 |  | Phones | Nokia | Samsung | Sony Ericsson |  |  | How to solve that problem that you could only those database that belongs to Nokia (if you choose first Nokia)
 |  | Nokia | N1 | S1 | SE1 |  | Maker | Type
 |  | Sony Ericsson | N2 | S2 | SE2 |  | Nokia | N1
 |  | Samsung | N3 | S3 | SE3
Spreadsheet: 157249d1337682951-excel-2007-applying-a-value-to-a-row-sum-score
Sheet: Sheet1

 | Score | 1 | 1 | 2 | 1 | 3
 |  | Supplier 1 | Supplier 2 | Supplier 1 | Supplier 2 | Supplier 3 |  | Total | Score
 |  | Supplier 3 | Supplier 5 | Supplier 2 |  | Supplier 4 |  | Supplier 1 | 3
 |  | Supplier 5 |  | Supplier 3 |  |  |  | Supplier 2 | 4
 |  |  |  | Supplier 4 |  |  |  | Supplier 3 | 6
 |  |  |  |  |  |  |  | Supplier 4 | 5
 |  |  |  |  |  |  |  | Supplier 5 | 2
Spreadsheet: 679230d1590265383-display-unique-customer-formula-box-data-excel-forum-2-
Sheet: Sample data set

 | Desired result
 | (manual) | Sample Data Set
 |  | All Files/1. [NAME]'s loans with [NAME].  [NAME]
 | show this file name --> | All Files/1. [NAME]'s loans with [NAME].  Approved Loans/Todd & Tina Smith loan file/
 | (ends w/ "loan file/") | All Files/1. [NAME]'s loans with [NAME].  Approved Loans/Todd & Tina Smith loan file/1. Submission/
 |  | All Files/1. [NAME]'s loans with [NAME].  Approved Loans/Todd & Tina Smith loan file/1. Submission/Credit Report.pdf
 |  | All Files/1. [NAME]'s loans with [NAME].  Approved Loans/Todd & Tina Smith loan file/1. Submission/ID Todd.pdf
 | show this file name --> | All Files/1. [NAME]'s loans with MyHang/2.  In Process Loans/Robert & Mary Levander loan file/
 | (ends w/ "loan file/") | All Files/1. [NAME]'s loans with MyHang/2.  In Process Loans/Robert & Mary Levander loan file/5. Funding/
 |  | All Files/1. [NAME]'s loans with MyHang/2.  In Process Loans/Robert & Mary Levander loan file/1. Submission/
 |  | All Files/1. [NAME]'s loans with MyHang/2.  In Process Loans/Robert & Mary Levander loan file/1. Submission/1008.pdf
 | show this file name --> | All Files/1. [NAME]'s loans with [NAME].  Approved Loans/Alice & Frank Jones loan file/
 | (ends w/ "loan file/") | All Files/1. [NAME]'s loans with [NAME].  Approved Loans/Alice & Frank Jones loan file/1. Submission/
 |  | All Files/1. [NAME]'s loans with MyHang/2.  In Process Loans/New folder (2)/
 |  | …and so on
 |  | Goal
 |  | I want to identify one record for each customer, and the file name that ends with "loan file/" seems to be the easiest identifier.
 |  | I don't want to list the sub-folders/files.
 |  | I believe if I had a formula that looked for a string that ended in "loan file/" I could achieve my goal.
 |  | In words, I'd want this formula to say… look for unique records that end in "loan file/" and have nothing after that string.
 |  | Thanks for any help!!
Spreadsheet: 06edc1dd-d75a-4033-bd23-917bb109855c
Sheet: Mathematics Grade 8

2013 Minnesota Comprehensive Assessments-Modified
Grade 8 Mathematics
Raw Score | Scale Score | Level
0 | 133 | D
1 | 148 | D
2 | 157 | D
3 | 163 | D
4 | 167 | D
5 | 170 | D
6 | 173 | D
7 | 176 | D
8 | 178 | D
9 | 180 | D
10 | 182 | D
11 | 184 | D
12 | 186 | D
13 | 187 | D
14 | 189 | D
15 | 190 | P
16 | 192 | P
17 | 194 | P
18 | 195 | P
19 | 197 | P
20 | 198 | P
21 | 200 | M
22 | 202 | M
23 | 204 | E
24 | 205 | E
25 | 207 | E
26 | 209 | E
27 | 211 | E
28 | 213 | E
29 | 216 | E
30 | 219 | E
31 | 222 | E
32 | 226 | E
33 | 232 | E
34 | 241 | E
35 | 256 | E
End of Worksheet
Spreadsheet: 883487d1732109665-how-to-auto-sort-and-extract-values-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Sum
 | AB | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 3
 | ABG | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | ABM | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 3
 | ACA | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5
 | ACAD | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 2
 | ACCD | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 2
 | ACCO | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2
 | ACEL | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 3
 | ACIC | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 2
 | ACIW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | ACLS | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 3
 | ADEA | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2
 | ADMA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | ADUS | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 3
 | ADV | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 2
 | AEO | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2
 | AGM | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 6
 | AGS | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 3
 | AGX | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 6
 | ALE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | ALEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | ALIT | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 2
 | ALK | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2
 | ALX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | AMAL | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 2
 | AMBP | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 6
 | AMED | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 3
 | AMG | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 3
 | AMPH | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 5
 | AMPY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | AMR | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 5
 | AMRX | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2
 | AMWD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | AN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | ANDE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1
 | ANIP | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 4
 | APAM | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 4
 | APEI | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1