tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 104935d1302394170-updating-budgets-without-skewing-previous-data-otter-repair-shop
Sheet: Otter Parts

Employee Code | FTE Budget | Part/Repair | Month | FTE Actual
Tail Affixer: | 1 | Parts | Jan | 2
[NAME]: | 2.7 | Parts | Jan | 0.5
Ear Stasher: | 14.5 | Parts | Jan | 16.1
Tooth Gluer: | 0.5 | Parts | Jan | 0.4
Whisker Pusher: | 11.5 | Parts | Jan | 11
Otter Secretary: | 2.15 | Parts | Jan | 2
Tail Affixer: | 1 | Parts | Feb | 4
[NAME]: | 2.7 | Parts | Feb | 2
Ear Stasher: | 14.5 | Parts | Feb | 15.1
Tooth Gluer: | 0.5 | Parts | Feb | 0.6
Whisker Pusher: | 11.5 | Parts | Feb | 11.33
Otter Secretary: | 2.15 | Parts | Feb | 2
Tail Affixer: | 1 | Parts | Mar | 3
[NAME]: | 2.7 | Parts | Mar | 2.6
Ear Stasher: | 14.5 | Parts | Mar | 14
Tooth Gluer: | 0.5 | Parts | Mar | 0.5
Whisker Pusher: | 11.5 | Parts | Mar | 11.6
Otter Secretary: | 2.15 | Parts | Mar | 2
Nail Clipper: | 2 | Repair | Jan | 2
[NAME]: | 5.5 | Repair | Jan | 6
Ear Cleaner: | 3.5 | Repair | Jan | 3
[NAME]: | 16.3 | Repair | Jan | 20
Whisker Toucher: | 11 | Repair | Jan | 11
Otter Belly Patter: | 9.5 | Repair | Jan | 10
Nail Clipper: | 2 | Repair | Feb | 2.3
[NAME]: | 5.5 | Repair | Feb | 5.6
Ear Cleaner: | 3.5 | Repair | Feb | 3.6
[NAME]: | 16.3 | Repair | Feb | 18.5
Whisker Toucher: | 11 | Repair | Feb | 11
Otter Belly Patter: | 9.5 | Repair | Feb | 9.7
Nail Clipper: | 2 | Repair | Mar | 2
[NAME]: | 5.5 | Repair | Mar | 5.5
Ear Cleaner: | 3.5 | Repair | Mar | 3.6
[NAME]: | 16.3 | Repair | Mar | 17.3
Whisker Toucher: | 11 | Repair | Mar | 11
Otter Belly Patter: | 9.5 | Repair | Mar | 9.5
Spreadsheet: 38596d1236761675-summarizing-data-over-several-sheets-bolts-20list-1-
Sheet: BoltsP2

 | BOLTS LIST | BOLTS LIST
CLIENT |  | 0 |  |  |  | JOB No. |  | A
PLANT |  | 0 |  |  |  |  | LIST No.  2   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
20 | 6 |  | 10 | M12 | 25
21 | 14 |  | 12 | M12 | 35
22 | 18 |  | 14 | M12 | 40
23 | 18 |  | 16 | M12 | 40
24 | 24 |  | 18 | M12 | 45
25 | 36 |  | 20 | M12 | 55
26 | 12 |  | 2 | M12 | 35
27 | 8 |  | 4 | M12 | 30
28 | 16 |  | 6 | M12 | 35
29 | 10 |  | 8 | M12 | 30
30 | 8 |  | 10 | M12 | 30
31 | 16 |  | 8 | M12 | 35
32 | 18 |  | 45 | M24 | 55
33 | 10 |  | 23 | M10CSK | 30
34 | 52 |  | 75 | M20CSK | 80
35 | 20 |  | 60 | M16 | 45
36 | 38 |  | 40 | M30CSK | 80
37 | 30 |  | 12 | M10CSK | 50
38 | 18 |  | 6 | M8 | 35
Spreadsheet: 470787d1468659449-ref-error-when-inserting-row-into-table-precious-metals-template
Sheet: Gold (Inventory)

 |  | TOTAL P/L |  |  |  | TOTALS
 | Year | Description | Mint | Purchase Date | Units | Weight (oz) | Total Weight | Purchase Price | Spot Value | Premium | P/L ($) | P/L (%)
Totals
Spreadsheet: 178980d1346972022-searching-multiple-columns-to-return-a-value-from-a-different-column-sample
Sheet: Sheet1

Concatenated
 | 9.625 | 2 | 1.5 | 1.5 | 12.2
 | 9.625 | 2.5 | 1.5 | 1.5 | 9.8
 | 9.625 | 3 | 1.5 | 1.5 | 8.2
 | 7 | 2 | 1.2 | 1.2 | 8.6
 | 7 | 2.5 | 1.2 | 1.2 | 6.8
 | 7 | 3 | 1.2 | 1.2 | 5.1
Value 1 | 9.625
Value 2 | 2.5
Result
Spreadsheet: 160888d1339277408-counting-number-randomly-roulette
Sheet: Sheet3

0 |  | 1 thr 18 | 19-36 |  | odd | even |  | 1ST | 2ND | 3RD
12
9
36
28
14
27
19
18
31
7
16
34
21
17
35
14
28
10
23
18
27
36
31
29
27
4
4
6
6
15
20
24
32
13
3
12
Spreadsheet: 116915d1312299122-selective-columns-handicapscorecards-master3
Sheet: Cards

[NAME]. [NAME] |  | Handicap |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  | Nett Differentials above buffer zone Handicap increases by 0.1 ([NAME] 28 :  Ladies 36)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tee |  |  |  | Nett Differentials below zero Handicap decreases by value shown in Reduction per Shot
HOLE > |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IN | OUT | Total
Par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSS | CSS adj | CSS | Nett | Nett Differential
Stroke Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSS
Strokes added for Handicap
Handicap Adjusted Par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Handicap | Exact | Category | Buffer Zone | Reduction per Shot
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current
Strokes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjustment
Nett Par |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New
[NAME]
PAR 3 points
Tie breakers by S/I
INDEX 1
INDEX 2
INDEX 3
Spreadsheet: 537657d1505218528-power-query-date-time-pomaster
Sheet: OS Vendor Contact info

Vendor Description | Phone # | Location | [NAME] | Contact | Ext
Aerospace Testing Labs | (860) 882-1575 | [NAME], CT |  | Nick | 360
AA Precision Machine | (508) 673-1698 | Fall River, MA |  | [NAME]
Aluminum Finishing | (203) 366-5871 | Bridgeport, CT | [EMAIL] | Anna
AMERICAN FINISHING SPECIALISTS | (203) 367-0663 | Bridgeport, CT | [EMAIL]
AMERICAN-URETHANE, INC. | (410) 672-2100 | Odenton, MD | [EMAIL]
BEEHIVE HEAT TREATING SVCS INC | (203) 866-1635 | Norwalk, CT | [EMAIL]
BENNETT HEAT TREAT NJ | (973) 589-0590 | Newark NJ | [EMAIL]
BENNETT HEAT TREAT PA | (215) 674-8120 | Ivyland, PA
[NAME] | (631) 643-6660 | West Babylon, NY |  | Kamil, [NAME] | 124/117
CENTRAL CT WATERJET | (860) 828-3877 | Berlin,CT |  | [NAME]
DANIELLS CENTERLESS GRINDING | (203) 877-9667 | Milford, CT
DICRONITE DRY LUBE NORTHEAST | (413) 562-5019 | Westfield,MA | [EMAIL]
FOUNTAIN PLATING COMPANY | (413) 781-4651 | West Springfield, MA
GARRICK MACHINE | (203) 579-7733 | Bridgeport, CT | [EMAIL]
GENERAL MAGNAPLATE CORP. | (908) 862-6200 | Linden, NJ | [EMAIL] | Aixa [NAME] | 120
Hygrade Precision Technologies | (860) 747-5773 | Plainville, Connecticut
IMPERIAL METAL FINISHING, INC. | (203) 377-1229 | Stratford, CT | [EMAIL] | [NAME] or [NAME]
METAL IMPROVEMENT-WINDSOR | (860) 688-6201 | Windsor, CT | [EMAIL]
METALLURGICAL PROCESSING | (860) 224-2648 | New Britain, CT
MET-L-TEST, INC. | (203) 377-2429 | Stratford, CT | [EMAIL] | [NAME]
Moore Tool Comapny | (203) 366-3224 | Bridgeport, CT | [EMAIL] | [NAME] | 336
NORTHEAST LASER ENGRAVING, INC | (203) 268-7238 | [NAME], CT
Nutmeg Precision | (203) 367-5692 | Bridgeport, CT | [EMAIL] | Syl   -     Tessi is receptionist
Pauway Corp | (866) 247-4082 | Wallingford, CT | [EMAIL] | [NAME] or [NAME]
PHILLIPS PRECISION | (203) 576-1949 | Elmwood Park, NJ | [EMAIL]
Prestige Industrial Finishing | (203) 924-7720 | Shelton, CT |  | Eva
QUALITY GRINDING & MACHINE | (203) 334-1566 | Bridgeport, CT | [EMAIL]
Quality Wire Edm | (860) 583-9867 | Bristol, CT |  | [NAME] or [NAME]
RAM SPEC. FABRICATION INC. | (203) 729-2289 | Naugatuck, CT | [EMAIL] | [NAME]/[NAME] | 113/122
RELIABLE PLATING | (203) 366-5261 | Bridgeport, CT | [EMAIL] | Scott
Seaboard Metal Finishing Co. | (203) 933-1603 | West Haven, CT
SPEC PLATING, INC. | (203) 366-3638 | Bridgeport, CT | [EMAIL]
THE SOUSA CORP | (860) 523-9090 | Newington, CT
TIODIZE CO., INC. | (714) 898-4377 | Huntington Beach, CA | [EMAIL]
Unas Grinding | (860) 289-1538 | East Hartford, CT
Valley Plating | (413) 788-7375 | Springfield, MA
Westport Precision | (203) 378-2175 | Stratford, CT |  | [NAME]
WESTFIELD ELECTROPLATING CO., | (413) 568-3716 | Westfield, MA | [EMAIL]
Spreadsheet: john_griffith__16196__1_30_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19 | 160 | 170 | 52.1 | 55.4 | 0.64 | 2002-01-30 13:40:00
 | CL J2 | 19 | 262 | 272 | 50 | 52 | 0.61 | 2002-01-30 13:40:00
 | CL K2 | 19.5 | 342 | 357 | 48.3 | 50.5 | 0.61 | 2002-01-30 13:40:00
 | CL M2 | 19.5 | 390 | 400 | 47.2 | 48.4 | 0.59 | 2002-01-30 13:40:00
 | CL N2 | 19.5 | 430 | 440 | 45.8 | 46.8 | 0.57 | 2002-01-30 13:40:00
 | CL Q2 | 20 | 460 | 475 | 43.4 | 44.9 | 0.56 | 2002-01-30 13:40:00
 | CL U2 | 20 | 475 | 495 | 41.6 | 43.4 | 0.53 | 2002-01-30 13:40:00
 | [NAME] | 20 | 485 | 505 | 39.5 | 41.1 | 0.51 | 2002-01-30 13:40:00
 | CL X2 | 20 | 490 | 510 | 37.6 | 39.2 | 0.48 | 2002-01-30 13:40:00
 | [NAME] | 20 | 495 | 515 | 36.2 | 37.7 | 0.46 | 2002-01-30 13:40:00
 | CL F3 | 20 | 505 | 530 | 35.3 | 37 | 0.45 | 2002-01-30 13:40:00
 | CL G3 | 20 | 510 | 535 | 34.2 | 35.9 | 0.44 | 2002-01-30 13:40:00
 | CL M3 | 20.5 | 530 | 560 | 30.5 | 32.2 | 0.4 | 2002-01-30 13:40:00
 | CL Z3 | 20.5 | 540 | 570 | 27 | 28.6 | 0.36 | 2002-01-30 13:40:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 0ff4e195-c614-4fb3-a793-2c8224aa757d
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
APPLICATIONS PROCESSED
UNIVERSITY OF HAWAI‘I - WEST O‘AHU
FALL 2005 TO FALL 2009
 | STUDENT LEVEL |  | 2005 |  |  | 2006 |  |  | 2007 |  |  | 2008 |  |  | 2009
 |  |  | No. | V% |  | No. | V% |  | No. | V% |  | No. | V% |  | No. | V%
 | TOTAL ………………………………………………………………………………………………………………………………… |  | 436 | 100 |  | 493 | 100 |  | 627 | 100 |  | 842 | 100 |  | 882 | 100
 | Accepted ………………………………………………………………………………………….. |  | 388 | 88.9908256880734 |  | 437 | 88.64097363083164 |  | 555 | 88.51674641148325 |  | 710 | 84.32304038004752 |  | 762 | 86.39455782312925
 | Enrolled; % of Accepted ……………………………………………………………………………………………………..………. |  | 303 | 78.09278350515464 |  | 359 | 82.15102974828376 |  | 402 | 72.43243243243244 |  | 454 | 63.94366197183099 |  | 520 | 68.24146981627297
 | Not Enrolled; % of Accepted ………………………………………………………………………………………………… |  | 85 | 21.90721649484536 |  | 78 | 17.84897025171625 |  | 153 | 27.56756756756757 |  | 256 | 36.05633802816902 |  | 242 | 31.75853018372704
 | Denied / Redirected …………………………………………………………………………………….. |  | 24 | 5.504587155963304 |  | 42 | 8.519269776876268 |  | 15 | 2.392344497607656 |  | 23 | 2.731591448931117 |  | 14 | 1.587301587301587
 | Incomplete / Pending / No Action ………………………………………………………………………… |  | 7 | 1.605504587155963 |  | 6 | 1.217038539553752 |  | 28 | 4.465709728867624 |  | 67 | 7.957244655581948 |  | 78 | 8.843537414965986
 | Cancelled …………………………………………………………………………………………………………… |  | 17 | 3.89908256880734 |  | 8 | 1.622718052738337 |  | 29 | 4.625199362041467 |  | 42 | 4.98812351543943 |  | 28 | 3.174603174603174
 | Note:  V% shows percent of total applications, unless otherwise indicated.
 | Source: Effective Fall 2005, data are from Banner Operational Data Store (ODS) IRO_ADMISSIONS.
Spreadsheet: 845501d1697006275-copy-formulas-and-format-from-existing-row-to-a-new-row-my-gites-aligw
Sheet: Facture

 |  |  |  |  |  |  |  | Entre nom du client | 3 Mick Jagger
 |  |  |  |  |  |  |  | Reservation | All
Facture
Dates |  | Description |  | No. Nuits | Prix | Total Prix
 |  |  |  |  | Total prix de séjour
 |  |  |  |  | Taxe
 |  |  |  |  | Acomptes Reçu
 |  |  |  |  | A Payé
Spreadsheet: 127153d1320181209-excel-2007-extraction-of-values-following-a-pattern-vlookup-tags
Sheet: NewWay

AAA | tag | AAA |  |  |  |  |  |  |  | AAA | 12 | 23 | 456 | 13 | 0
AAA | fg | [NAME] |  |  |  |  |  |  |  | BBB | 56 | 2 | 0 | 0 | 0
AAA | 14 | { | dfb
AAA | = | vdv | 45
AAA | flag | AAA
AAA | flag | BBB
AAA | [NAME] | >
Owned-AAA | owned | 12 | 23 | 456 | 13
Owned-AAA
Owned-AAA
Owned-AAA
BBB | tag | BBB
BBB | flag | AAA
BBB | flag | CCC
BBB | wdh | 546
BBB | { | 2 | }
Owned-BBB | owned | 56 | 2
Spreadsheet: scott_neal__38532__Neal Short Bonds Exe
Sheet: Enter

(000) |  |  |  |  |  |  | [NAME]. | [NAME]. Call | Par | Pre-Re
Par | DTD | Settlement | Rating | Description | Coupon | Maturity | Call | Price | Call | Y=Yes | Price | SC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL SC
50 | 1992-09-01 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | ALBUQUERQUE NM | 0.0575 | 2012-07-01 00:00:00 | 2002-07-01 00:00:00 | 102 |  | Y=Yes | 104.042
250 | 1992-05-15 00:00:00 | 2001-11-23 00:00:00 | AAA/ | MIDWAY TX ISD PSF | 0.06125 | 2008-08-01 00:00:00 | 2002-08-01 00:00:00 | 100 |  | Y=Yes | 102.633
50 | 1995-12-01 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | [NAME] | 0.04375 | 2002-10-01 00:00:00 |  |  |  |  | 101.918
50 | 1998-06-15 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | UTAH STATE | 0.05 | 2003-07-01 00:00:00 |  |  |  |  | 104.229
300 | 1995-12-15 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | BUCKS CO PA | 0.0465 | 2003-08-15 00:00:00 |  |  |  |  | 104.123
50 | 1993-04-01 00:00:00 | 2001-11-23 00:00:00 | AAA/AAA | CLEVELAND OHIO | 0.05 | 2003-09-01 00:00:00 |  |  |  |  | 104.475
260 | 1992-08-13 00:00:00 | 2001-11-23 00:00:00 | AA3/AA | DELAWARE CO PA | 0 | 2003-11-15 00:00:00 |  |  |  |  | 95.126
 |  | Settlement |  | Enter Account/Broker Name: |  | [NAME]:
 |  | 2001-11-16 00:00:00 |  | [NAME] Bonds |  | 1.538 |  |  |  |  | SC=
Spreadsheet: 671260d1586331961-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 13 SATURDAY

DAY: |  | SATURDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 8c7a19ff-e47f-4335-a9e1-c06fd33349bb
Sheet: AdministrativeIndirect

 | Integration Revenue Budget Worksheet
 | FY14
 | Administrative/Indirect
District Name: |  |  |  |  |  | District Number:
Please include on this worksheet all Admin./Indirect proposed expenditures from your FY14 budget. No more than 10 percent of the total budget may be spent on Admin./Indirect costs. See FY14 Budget Guide for details.
Line Item Description | UFARS Code (Required) |  |  |  | Budgeted Amount | Actual Expenditures
Provide a short description of the expenditure | ORG | PROG | FIN | OBJ | Provide the total amount budgeted for this line item | Resubmit this form with the actual FY14 expenditures by 12/01/2014
(example - Administrator salary) |  | 030 |  | 110
(example - Administrator benefits) |  | 030 |  | 210
TOTAL
Notes or Comments:
Spreadsheet: d52ea7ea-a9fc-4cfa-8fa3-88d6fc360f6d
Sheet: Sheet1

Reporting School: | Kankakee Valley | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Date: | 2010-02-26 00:00:00 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Overall Record:
Conference Record:
School | 1st | 2nd | 3rd | 4th | OT | Final
Kankakee Valley | 11 | 9 | 18 | 14
North Judson | 18 | 25 | 17 | 19
Add. Stats
 |  |  |  |  |  |  | Total | Offensive | Defensive | Total |  |  | Blocked
Player | 2PA | 2PM | 3PA | 3PM | FTA | FTM | Points | Rebounds | Rebounds | Rebounds | Assists | Steals | Shots | TO | Fouls | #GM
Zach Overby | 9 | 4 | 0 | 0 | 4 | 4 | 12 | 2 | 2 | 4 | 2 | 2 | 0 | 1 | 1 | 20
Brad Leegwater | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 2 | 0 | 20
[NAME] | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20
Zach DeFries | 2 | 0 | 1 | 1 | 2 | 2 | 5 | 1 | 0 | 1 | 2 | 0 | 0 | 3 | 0 | 20
[NAME] Dahm | 5 | 1 | 4 | 1 | 0 | 0 | 5 | 1 | 3 | 4 | 1 | 2 | 1 | 2 | 3 | 20
[NAME] | 6 | 2 | 3 | 2 | 1 | 1 | 11 | 0 | 1 | 1 | 3 | 1 | 1 | 2 | 4 | 20
[NAME] | 4 | 2 | 0 | 0 | 4 | 4 | 8 | 1 | 1 | 2 | 0 | 1 | 0 | 2 | 3 | 20
[NAME] | 3 | 1 | 0 | 0 | 7 | 6 | 8 | 0 | 5 | 5 | 1 | 1 | 1 | 3 | 2 | 20
[NAME] | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 5 | 20
[NAME] | 3 | 1 | 0 | 0 | 2 | 1 | 3 | 0 | 0 | 0 | 3 | 1 | 0 | 4 | 2 | 20
[NAME] | DNP |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 20
Brent VanSoest | DNP |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 20
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
Spreadsheet: 86544d1286500124-find-group-and-sum-by-each-projectcharges
Sheet: Data Dump Tab

 | Name | ID | Proj ID | Totals
 | [NAME] | 1111 | 55555 | 34
 | [NAME] | 1111 | 121212 | 44 |  |  | Row Labels | Sum of Totals |  | Row Labels | Sum of Totals |  | Row Labels | Sum of Totals
 | [NAME] | 1111 | 3232323 | 22 |  |  | 24565 | 234 |  | [NAME] | 2286 |  | 1111 | 2286
 | [NAME] | 2222 | 55555 | 335 |  |  | Mart Doe | 234 |  | 55555 | 34 |  | [NAME] | 2286
 | [NAME] | 2222 | 121212 | 456 |  |  | 55555 | 33458 |  | 121212 | 44 |  | 2222 | 48751
 | [NAME] | 1111 | 434343 | 2132 |  |  | [NAME] | 34 |  | 434343 | 2132 |  | [NAME] | 48751
 | [NAME] | 1111 | 434356 | 54 |  |  | [NAME] | 32767 |  | 434356 | 54 |  | 3333 | 88409
 | [NAME] | 2222 | 68757 | 7668 |  |  | Mart Doe | 657 |  | 3232323 | 22 |  | Mart Doe | 88409
 | [NAME] | 2222 | 76578 | 7453 |  |  | 68757 | 7668 |  | [NAME] | 48751 |  | Grand Total | 139446
 | Mart Doe | 3333 | 24565 | 234 |  |  | [NAME] | 7668 |  | 55555 | 32767
 | Mart Doe | 3333 | 55555 | 657 |  |  | 76578 | 7453 |  | 68757 | 7668
 | Mart Doe | 3333 | 3232323 | 2243 |  |  | [NAME] | 7453 |  | 76578 | 7453
 | Mart Doe | 3333 | 345345 | 76576 |  |  | 121212 | 500 |  | 121212 | 456
 | Mart Doe | 3333 | 654645 | 7566 |  |  | [NAME] | 44 |  | 343434 | 65
 | [NAME] | 2222 | 3232323 | 342 |  |  | [NAME] | 456 |  | 3232323 | 342
 | [NAME] | 2222 | 55555 | 32432 |  |  | 234324 | 788 |  | Mart Doe | 88409
 | [NAME] | 2222 | 343434 | 65 |  |  | Mart Doe | 788 |  | 24565 | 234
 | Mart Doe | 3333 | 34534636 | 345 |  |  | 343434 | 65 |  | 55555 | 657
 | Mart Doe | 3333 | 234324 | 788 |  |  | [NAME] | 65 |  | 234324 | 788
 |  |  |  |  |  |  | 345345 | 76576 |  | 345345 | 76576
 |  |  |  |  |  |  | Mart Doe | 76576 |  | 654645 | 7566
 |  |  |  |  |  |  | 434343 | 2132 |  | 3232323 | 2243
 |  |  |  |  |  |  | [NAME] | 2132 |  | 34534636 | 345
 |  |  |  |  |  |  | 434356 | 54 |  | Grand Total | 139446
 |  |  |  |  |  |  | [NAME] | 54
 |  |  |  |  |  |  | 654645 | 7566
 |  |  |  |  |  |  | Mart Doe | 7566
 |  |  |  |  |  |  | 3232323 | 2607
 |  |  |  |  |  |  | [NAME] | 22
 |  |  |  |  |  |  | [NAME] | 342
 |  |  |  |  |  |  | Mart Doe | 2243
 |  |  |  |  |  |  | 34534636 | 345
 |  |  |  |  |  |  | Mart Doe | 345
 |  |  |  |  |  |  | Grand Total | 139446
Spreadsheet: 88225d1288110028-look-up-column-and-row-example-of-question
Sheet: Sheet1

 | DATABASE
 | Retail Number | Name | School | Street |  |  |  |  |  | Retail Number | Name | School | Street
 | 1 | [NAME] | USC | Main |  |  |  |  |  | 100
 | 100 | [NAME] | SC | Fairview |  |  |  |  |  | 20
 | 20 | [NAME] | UGA | Jameston |  |  |  |  |  | 458
 | 45 | [NAME] | AU | Sterling |  |  |  |  |  | 208
 | 458 | [NAME] | Mich | Selwyn
 | 35 | Erin | Org | Queens
 | 208 | Nick | TX | Kings
 | 124 | [NAME] | TN | Devine |  |  |  |  |  | Example- I need to reference both the 100 in K5 and Street in N5 and return a value based on the database from B4:E12 into cell N5
Spreadsheet: 39240d1237414950-calendar-and-buttons-3m-brookings-copy
Sheet: PG USP

[NAME] USP
2845 Lbs./Tote
[NAME]
Lot # | CB59601108
Batch # | 999999-T
PO | USMMMFP906
Rel. | 3 | 2009-03-18 00:00:00
[NAME] USP
2845 Lbs./Tote
[NAME]
Lot # | CB59601108
Batch # | 999999-T
PO | USMMMFP906
Rel. | 3 | 2009-03-18 00:00:00
Spreadsheet: 839109d1691669085-lookup-based-on-2-values-exceltest
Sheet: Sheet1

 | Class | A
 |  |  | name | val1 | val2 | val3 | val4 |  | target
 |  |  | Fred | 37.79 | 42.5 | 39.54 | 38.81
 |  |  | [NAME] | 38.64 | 39.33 | 41.3 | 39.29
 |  |  | Sandra | 44.5 | 39.53 | 39.3 | 39.44
 |  |  | [NAME] | 38.8 | 39.96 | 37.73 | 49.6
Spreadsheet: 298860d1392928212-complicated-lookup-merit-2014
Sheet: Sheet2

Level | Low | Median | [NAME]
11 | 0 | 33.67788461538461 | 55.95461538461539
10 | 0 | 28.89951923076923 | 44.93942307692308
9 | 0 | 26.04807692307692 | 40.57211538461538
8 | 0 | 23.84 | 37.1202
7 | 0 | 22.4 | 34.8768
6 | 0 | 21.17 | 33.0762
5 | 0 | 19.06 | 29.6652
4 | 0 | 16.91 | 26.3226
3 | 0 | 14.73 | 22.929
2 | 0 | 12.46 | 19.4088
1 | 0 | 9.79 | 15.2328
Spreadsheet: 863263d1710828441-formulas-for-golf-tournament-assigning-in-separate-cell-and-listing-multiple-names-team-game-scenarios
Sheet: Sheet2

[NAME] | 1 |  | [NAME]
[NAME] | 3 |  | [NAME]
[NAME] | 0 |  | [NAME]
[NAME] | 3 |  | [NAME]
[NAME] | 3 |  | [NAME]
[NAME] | 3 |  | [NAME]
Jake | 3 |  | Jake
[NAME] | 5 |  | [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] | 5 |  | [NAME]
Mark | 6 |  | Mark
[NAME] | 5 |  | [NAME]
Pablo | 5 |  | 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] | 3 | 5 | 6 |  | Hole 2
[NAME] | 3 | 5 | 8 |  | Hole 3
[NAME] | 3 | 4 | 9
[NAME] | 3 | 5 | 7 |  | Full formula
[NAME] | 6 | 6 | 6 |  | Using LET
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 | 5
[NAME] | 4 | 4 | 5
Zach | 8 | 4 | 9