tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 832402d1686311927-price-pick-from-last-updated-date-with-condition-sample-27-
Sheet: Sheet1

 |  |  |  |  |  |  |  | Fruit | Valid From | Price
 |  |  |  |  |  |  |  | APPLE | 2020-06-23 00:00:00 | 100
 |  |  |  |  |  |  |  | APPLE | 2022-12-02 00:00:00 | 113.11 |  |  | Fruit | Date | Price
 |  |  |  |  |  |  |  | APPLE | 2023-01-30 00:00:00 | 121.86 |  | Ex 1 | APPLE | 2022-12-02 00:00:00
 |  |  |  |  |  |  |  | Orange | 2004-11-08 00:00:00 | 76.28
 |  |  |  |  |  |  |  | Orange | 2012-03-01 00:00:00 | 108.05 |  | Ex2 | Grapes | 2008-07-01 00:00:00
 |  |  |  |  |  |  |  | Grapes | 2004-11-08 00:00:00 | 76.28
 |  |  |  |  |  |  |  | Grapes | 2006-07-01 00:00:00 | 76.28 |  | Ex3 | Grapes | 2014-02-27 00:00:00
 |  |  |  |  |  |  |  | Grapes | 2007-07-01 00:00:00 | 76.28
 |  |  |  |  |  |  |  | Grapes | 2008-04-30 00:00:00 | 78.49
 |  |  |  |  |  |  |  | Grapes | 2008-07-01 00:00:00 | 78.49
 |  |  |  |  |  |  |  | Grapes | 2009-07-01 00:00:00 | 78.49
 |  |  |  |  |  |  |  | Grapes | 2010-03-29 00:00:00 | 95.6
 |  |  |  |  |  |  |  | Grapes | 2010-08-26 00:00:00 | 100.19
 |  |  |  |  |  |  |  | Grapes | 2012-03-01 00:00:00 | 108.05
 |  |  |  |  |  |  |  | Grapes | 2012-08-10 00:00:00 | 108.05
 |  |  |  |  |  |  |  | Grapes | 2012-11-19 00:00:00 | 103.35
 |  |  |  |  |  |  |  | Grapes | 2014-03-01 00:00:00 | 106.1
 |  |  |  |  |  |  |  | Grapes | 2015-03-01 00:00:00 | 107.71
 |  |  |  |  |  |  |  | Grapes | 2016-07-01 00:00:00 | 107.71
 |  |  |  |  |  |  |  | Grapes | 2017-09-22 00:00:00 | 113.11
Spreadsheet: chris_germany__2129__FebCohCHOICE-ENA
Sheet: Feb 20

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-02-20 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | Upstream K# | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1118 |  | 604 |  | 67694 |  |  |  |  |  |  | 29 | 1 | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 2 | 37
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 7597 |  | 5948 |  | 67694 |  |  |  |  |  |  | 29 | 3 | 37
 |  |  |  |  |  |  |  |  | 3000 |  | 3000 |  | 68918 | 103722 | 0 |  |  |  |  | 33 | 4 | 37
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | 5 | 42
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2307 |  | 1692 |  | 67694 |  |  |  |  |  |  | 33 | 6 | 40
 |  |  |  |  |  |  |  |  | 2000 |  | 2000 |  | 68915 | 103722 | 0 |  |  |  |  | 31 | 7 | 36
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69148 |  | 0 |  |  |  |  | 35 | 8 | 43
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0 |  |  |  |  | 36 | 9 | 43
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | 15 | 50
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 17263 |  | 14106 |  | 67694 |  |  |  |  |  |  | 35 | 35 | 41
 |  |  |  |  |  |  |  |  | 25 |  | 25 |  | 68917 | 103722 | 0 |  |  |  |  | 33 | 39 | 37
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 |  | 0
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69693 |  | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2044 |  | 1274 |  | 67694 |  |  |  |  |  |  | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Storage
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1371 |  | 1064 |  | 67694 |  |  |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 68916 | 103722 | 0 |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 11994 |  | 7517 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2406 |  | 1669 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2901 |  | 1990 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 3470 |  | 2486 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 848 |  | 390 |  | 67694
 |  |  |  |  |  |  |  |  | 257 |  | 257 |  | 69708 | 53858 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 53858 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 35 |  | 31 |  | 67694 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20146 | FOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86918 | 20596 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 857427d1706451613-need-help-with-kpi-reports-commerce-return-and-cancelled-orders-17012024
Sheet: Summary

 |  |  |  |  | MTD Commerce Returned & Cancelled Orders
 | Sum of VALUE
 | WH | STATUS | RESPONSIBLE DEPT. | Total
 | S901 | CANCELLED | SALES | 9963.91
 |  |  | PLANNING | 248.07
 |  |  | PROCUREMENT | 615
 |  | RETURNED | SALES | 18974.55
 |  |  | [NAME] | 58110.49
 |  |  | DATA ENTRY | 14800
 |  |  | WAREHOUSE | 3816
 | S901 Total |  |  | 106528.02
 | Grand Total |  |  | 106528.02
 |  |  |  |  |  | Sum of VALUE
 |  |  |  |  |  | STATUS | RESPONSIBLE DEPT. | DRIVER NAME | Total
 |  |  |  |  |  | CANCELLED | SALES | [NAME] 1 | 1143.44
 |  |  |  |  |  |  |  | [NAME] 2 | 660.03
 |  |  |  |  |  |  |  | [NAME] 3 | 2145
 |  |  |  |  |  |  |  | DRIVER 5 | 1114
 |  |  |  |  |  |  |  | [NAME] 6 | 557
 |  |  |  |  |  |  |  | DRIVER 7 | 557
 |  |  |  |  |  |  |  | DRIVER 10 | 1314.48
 |  |  |  |  |  |  |  | DRIVER 11 | 958.08
 |  |  |  |  |  |  |  | DRIVER 12 | 1514.88
 |  |  |  |  |  |  | SALES Total |  | 9963.91
 |  |  |  |  |  |  | PLANNING | [NAME] 2 | 91.92
 |  |  |  |  |  |  |  | [NAME] 3 | 156.15
 |  |  |  |  |  |  | PLANNING Total |  | 248.07
 |  |  |  |  |  |  | PROCUREMENT | [NAME] 1 | 570
 |  |  |  |  |  |  |  | [NAME] 2 | 45
 |  |  |  |  |  |  | PROCUREMENT Total |  | 615
 |  |  |  |  |  | RETURNED | SALES | [NAME] 1 | 210.24
 |  |  |  |  |  |  |  | [NAME] 2 | 4699.34
 |  |  |  |  |  |  |  | [NAME] 3 | 4774.51
 |  |  |  |  |  |  |  | DRIVER 13 | 941.76
 |  |  |  |  |  |  |  | [NAME] 14 | 1839.12
 |  |  |  |  |  |  |  | DRIVER 15 | 6509.58
 |  |  |  |  |  |  | SALES Total |  | 18974.55
 |  |  |  |  |  |  | [NAME] | [NAME] 1 | 1135.62
 |  |  |  |  |  |  |  | [NAME] 2 | 8633.45
 |  |  |  |  |  |  |  | [NAME] 3 | 17928.62
 |  |  |  |  |  |  |  | [NAME] 4 | 2640.3
 |  |  |  |  |  |  |  | [NAME] 8 | 4410
 |  |  |  |  |  |  |  | DRIVER 9 | 23362.5
 |  |  |  |  |  |  | LOGISTICS Total |  | 58110.49
 |  |  |  |  |  |  | DATA ENTRY | [NAME] 3 | 14800
 |  |  |  |  |  |  | DATA ENTRY Total |  | 14800
 |  |  |  |  |  |  | WAREHOUSE | [NAME] 1 | 3816
 |  |  |  |  |  |  | WAREHOUSE Total |  | 3816
 |  |  |  |  |  | Grand Total |  |  | 106528.02
Spreadsheet: 116352d1311780861-excel-claim-sorting-claims-sorting-tracker-cst-
Sheet: Claims Sorted

2008-08-01 00:00:00 | 2009-07-31 00:00:00 | #N/A | #N/A | #N/A
Serial | Date | Paid | Oustanding | Total | Title
5 | 2008-08-02 00:00:00 | 0 | 0 | 0 | EL
0 |  | 0 | 0 | 0 | 0 |  |  | 2011-08-01 00:00:00 |  |  |  |  | Do not delete
0 |  | 0 | 0 | 0 | 0 |  |  | 2011-08-01 00:00:00 | To | 2012-07-31 00:00:00 |  |  | 0 | 12
0 |  | 0 | 0 | 0 | 0 |  |  | 2010-08-01 00:00:00 | To | 2011-07-31 00:00:00 |  |  | -12 | 0
0 |  | 0 | 0 | 0 | 0 |  |  | 2009-08-01 00:00:00 | To | 2010-07-31 00:00:00 |  |  | -24 | -12
0 |  | 0 | 0 | 0 | 0 |  |  | 2008-08-01 00:00:00 | To | 2009-07-31 00:00:00 |  |  | -36 | -24
0 |  | 0 | 0 | 0 | 0 |  |  | 2007-08-01 00:00:00 | To | 2008-07-31 00:00:00 |  |  | -48 | -36
0 |  | 0 | 0 | 0 | 0 |  |  | 2006-08-01 00:00:00 | To | 2007-07-31 00:00:00 |  |  | -60 | -48
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0 |  |  | Note: | Select the date from Cell A1
0 |  | 0 | 0 | 0 | 0 |  |  |  | Copy paste the formula in A3:F3 below
0 |  | 0 | 0 | 0 | 0 |  |  |  | Hide column M:O
0 |  | 0 | 0 | 0 | 0 |  |  |  | there is similar formula in A3&C3:F3
0 |  | 0 | 0 | 0 | 0 |  |  |  | There is separate formula in B3
0 |  | 0 | 0 | 0 | 0 |  |  |  | These are array formulas and should be confirmed throgh Ctrl+Shift+Enter
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
#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
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 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: sally_beck__33820__Wellesley_102400_Participants
Sheet: Sheet1

Wellesley College
[NAME], [NAME]
EVENT: | RECEPTION & FALL INTERVIEWS
DATE: | November 27, 2000 - Reception
 | November 28 - 29, 2000 - Interviews
TIME: | 7:00 PM - 9:00 PM - Reception
 | 8:00 AM - 5:00 PM - Interviews
PLACE: | Reception | Interviews
 | [NAME] | Wellesley College
 | 92 Central Street | College Club
 | (781) 237-5788
Contacts: | [NAME], [NAME] | Cell Phone: | (713) 417-2236
 | [NAME], Coordinator | Cell Phone: | (713) 501-6486
 | Career Services: Bernice Tita | Office | (781) 283-2452
Enron
Participants:
 | [NAME] | [NAME]
 | Mariella Mahan | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
Flight
Arrangements: | Should be made by each participant
Hotel
Information: | To all participants, rooms are reserved under your name at the following hotel:
 | [NAME]
Hotel | Name                               Confirmation # | Dates | Name | Confirmation # | Dates
Guests: | [NAME]73610 | 27 - 29 | [NAME] | 73616 | 28 - 29
 | Mariella Mahan                73611 | 27 - 28 | [NAME] | 81124 | 28 - 29
 | [NAME] | 27 - 28 | [NAME] | 81125 | 28 - 29
 | [NAME] | 27 - 28 | [NAME] | 81126 | 28 - 29
 | [NAME] | 27 - 28 | [NAME] | 73615 | 27 - 28
Ground
Information: | [NAME], Rental Car (You are responsible for arranging transportation)
Additional
Information: | The attire for the Presentation is Business Casual.  Please remember to bring your business cards.  Please submit
 | all completed/signed SAP expense reimbursements to [NAME] at EB1166 fpr coding and processing.  Please
 | keep a copy of your expense report for your files.
Spreadsheet: 867273d1714120760-question-about-lambda-text
Sheet: Sheet1

Name | Ctry |  |  |  |  |  |  | DDD | EEE
A | China |  |  | China, SG |  |  |  | A | China, SG |  | <---- How do I convert this back to A1:[NAME]???
A | SG |  | B | SG, Msia |  |  |  | B | SG, Msia
B | SG |  | C | Msia, SG, Usa |  |  |  | C | Msia, SG, Usa
B | Msia |  | D | Vietnam, SG |  |  |  | D | Vietnam, SG
C | Msia
C | SG
C | Usa
D | Vietnam
D | SG
 |  |  | My formula in D2 as below
 |  |  | LET(x,UNIQUE(Table1[Name]),HSTACK(x,BYROW(x,[NAME],TEXTJOIN(", ",TRUE,IF((Table1[Name]=q),Table1[Ctry],""))))))
 |  |  |  |  |  |  |  |  |  | What does q mean?
 |  |  |  |  |  |  |  |  |  | *Why not Table1[Name]=x??
Spreadsheet: 82527d1282592549-format-add-rows-of-data-adding-rows-of-data
Sheet: 1

Product 1
Product 2
Product 3
Product 4
Product 5
Product 6
Product 7
Product 8
Product 9
Product 10
Product 11
Product 12
Product 13
Product 14
Product 15
Product 16
Product 17
Product 18
Product 19
Product 20
Product 21
Product 22
Product 23
Product 24
Product 25
Product 26
Product 27
Product 28
Product 29
Product 30
Product 31
Product 32
Product 33
Product 34
Product 35
Spreadsheet: 807468d1669911249-formular-for-analyze-best-and-weak-students-g666-ver1-ans
Sheet: 5 BEST AND WEK FEMALE STUDENT

I. FIVE BEST FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
J. FIVE WEAK FEMALE STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 871660d1718088134-formula-to-pull-date-from-other-tab-formula
Sheet: Master

Financial Row | - No Cost Center - | COGS: [NAME]: Global | [NAME]: Licence - Product & Solutions | COGS: Maintenance - Customer Success | COGS: Maintenance - Infrastructure & Data | COGS: Professional Services - Customer Success | G&A: Corporate Existence | G&A: Facilities | G&A: Finance | G&A: Human Resources | G&A: Infrastructure & Data | G&A: Management | G&A: Operations | G&A: [NAME] | N/A: Only Balance Sheet entries | R&D: Product and Solutions: Global | R&D: Technology: R&D | S&M: Marketing | S&M: Office of Sales Strategy | S&M: Partner Channel Sales | S&M: Sales | S&M: Sales Engineering | Total
 | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount | Amount
Gross Profit
Overheads
610000 - Bank Charges | if B1 and A5 are matched in working tab, then pull the figures from b5 | if c1 and a5 are matched in working tab, then pull the figures from c5
620000 - Depreciation | if B1 and A5 are matched in working tab, then pull the figures from b6 | if c1 and a5 are matched in working tab, then pull the figures from c6
630000 - Insurance
635000 - Professional Fees
635001 - Subscription Services
635002 - Other Professional Fees
645001 - Meals and Entertainment:Entertainment Meals, Events & Other
645002 - Meals and Entertainment: Subsistence
645004 - Business Meals
650000 - Office Supplies
655000 - Operating Lease  Expenses
655000 - Operating Lease  Expenses
655200 - Variable Lease Expenses
Total - 655000 - Operating Lease  Expenses
660001 - Repair & Maintenance
664000 - Learning and Development
665102 - Salaries & Wages :Employee Benefits :Health Insurance
665104 - Salaries & Wages: Employee Benefits: Employer Payroll Taxes
665108 - Salaries & Wages: Employee Benefits: PTO Expense
665109 - Salaries & Wages: Defined Benefit Plan
665501 - Salaries & Wages: Bonus
665502 - Salaries & Wages: Other Compensation
665503 - Salaries & Wages: Salary
665505 - Salaries & Wages: Commissions
670000 - Shipping & Delivery
680000 - Taxes & Licenses
685001 - Travel: Lodging
685101 - Travel: Transportation: Airfare, Train and Bus Travel
685103 - Travel:Transportation: Mileage
685105 - Travel: Transportation: Taxi and Shuttle
691000 - Telecommunications
Total - Overheads
Operating Profit
Other Income
710000 - Exchange Gain
Total - Other Income
Other Expenses
810000 - Exchange Loss
810002 - Unrealized Gain/Loss
811009 - Rounding Gain/Loss (system)
Total - Other Expenses
Net Profit/(Loss)
Spreadsheet: 117467d1312817288-sumproduct-with-multiple-criteria-test-goods-out-sheet
Sheet: Stock Movement

Period / WK | Date | Order No./Rec No. | Tech Intl. / Stock In | Technician Name | Product No. | Item Description | Stock Movement | Cost Centre - Incoming Stock Only
 |  |  | km | [NAME] | 001 | 16 watt GLS ES Energy Saver Softone | 5 | Capex
 |  |  | del | DELIVERY | 001 | 16 watt GLS ES Energy Saver Softone | 10
 |  |  | del | DELIVERY | 001 | 16 watt GLS ES Energy Saver Softone | 10
 |  |  | SAVCIN | Stock Adjustment [NAME] In | 001 | 16 watt GLS ES Energy Saver Softone | 10
 |  |  | SAVILIN | Stock Adjustment Lodges - Goods In | 001 | 16 watt GLS ES Energy Saver Softone | 10
 |  |  | Ret | Stock Returned | 001 | 16 watt GLS ES Energy Saver Softone | 10
 |  | What I need to happen is any items that has either DEL, SAVCIN, SAVILIN or Ret against the product no. is added to the relevent stock according to column L's prefix of either [NAME] or [NAME], any criteria outside of the above descriptions needs to be reduced from the relvent holding stock, this happens on the data & stock check sheet - the issues and goods inward need to tie up with the relevent product code. I am looking to use only one coloumn on this sheet to record items going out and coming in.
Spreadsheet: 4cde9eed-2776-46c2-9c1c-c8c4094ab789
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
10/14/2011 | Men's Swimming &amp; Diving | WEST VIRGINIA STATE GAMES | 1st place
10/15/2011 | Men's Swimming &amp; Diving | WEST VIRGINIA STATE GAMES | 1st place
10/22/2011 | Men's Swimming &amp; Diving | at Penn State | L, 143-98
11/12/2011 | Men's Swimming &amp; Diving | CINCINNATI | W, 178-107
11/12/2011 | Men's Swimming &amp; Diving | VILLANOVA | W, 190-100
11/18/2011 | Men's Swimming &amp; Diving | at Pitt Invitational | 2nd place
11/19/2011 | Men's Swimming &amp; Diving | at Pitt Invitational | 2nd place
11/20/2011 | Men's Swimming &amp; Diving | at Pitt Invitational | 2nd place
12/01/2011 | Men's Swimming &amp; Diving | Miami Diving Invitational (Miami, Ohio) | Results
12/01/2011 | Men's Swimming &amp; Diving | U.S. Winter Nationals (Atlanta, Ga.) | Results
12/02/2011 | Men's Swimming &amp; Diving | U.S. Winter Nationals (Atlanta, Ga.) | Results
12/02/2011 | Men's Swimming &amp; Diving | Miami Diving Invitational (Miami, Ohio) | Results
12/03/2011 | Men's Swimming &amp; Diving | Miami Diving Invitational (Miami, Ohio) | Results
12/03/2011 | Men's Swimming &amp; Diving | U.S. Winter Nationals (Atlanta, Ga.) | Results
01/02/2012 | Men's Swimming &amp; Diving | [NAME] Relays ([NAME], Fla.) | Results
01/07/2012 | Men's Swimming &amp; Diving | PITT | L, 124.5-175.5
01/21/2012 | Men's Swimming &amp; Diving | at Maryland | L, 180-120
02/10/2012 | Men's Swimming &amp; Diving | BIG EAST Diving Championships (Pittsburgh, Pa.) | 3rd place
02/11/2012 | Men's Swimming &amp; Diving | BIG EAST Diving Championships (Pittsburgh, Pa.) | 3rd place
02/15/2012 | Men's Swimming &amp; Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 3rd place
02/16/2012 | Men's Swimming &amp; Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 4th place
02/17/2012 | Men's Swimming &amp; Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 4th place
02/18/2012 | Men's Swimming &amp; Diving | BIG EAST Swimming Championships (Pittsburgh, Pa.) | 4th place
03/09/2012 | Men's Swimming &amp; Diving | NCAA Zone Diving (Buffalo, N.Y.) | Results
03/10/2012 | Men's Swimming &amp; Diving | NCAA Zone Diving (Buffalo, N.Y.) | Results
03/29/2012 | Men's Swimming &amp; Diving | U.S. Grand Prix (Indianapolis, Ind.) | TBD
03/30/2012 | Men's Swimming &amp; Diving | U.S. Grand Prix (Indianapolis, Ind.) | TBD
03/31/2012 | Men's Swimming &amp; Diving | U.S. Grand Prix (Indianapolis, Ind.) | TBD
Spreadsheet: 77111d1277554509-formula-calculation-based-on-yes-no-list-quote_analyser-1-
Sheet: 28-06-10

Job # | Quote Value | Sector | Description | Job Won | Sectors | Job Won
1 | 100 |  |  | Yes | Building | Yes
2 | 100 |  |  |  | Landscaping | No
3 | 100
4 | 100 |  |  | No
5 | 100
6 | 100
7 | 100 |  |  | Yes
8 | 100
9 | 100
10 | 100
Spreadsheet: john_griffith__15742__10_16_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 255 | 29.5 | 31 | 87.7 | 92.2 | 14.42 | 2001-10-16 10:52:00
 | NG Z1 | 280 | 55 | 56.5 | 73.1 | 75.1 | 13.04 | 2001-10-16 10:52:00
 | NG F2 | 300 | 73 | 77 | 69.9 | 73.8 | 13.55 | 2001-10-16 10:52:00
 | NG G2 | 300 | 81 | 85 | 64.4 | 67.7 | 12.46 | 2001-10-16 10:52:00
 | NG H2 | 290 | 81 | 84 | 59.4 | 61.6 | 11.03 | 2001-10-16 10:52:00
 | NG J2 | 285 | 75 | 77 | 50.9 | 52.3 | 9.25 | 2001-10-16 10:52:00
 | NG K2 | 285 | 76 | 80 | 47.5 | 50 | 8.73 | 2001-10-16 10:52:00
 | NG M2 | 290 | 81 | 85 | 46.1 | 48.4 | 8.61 | 2001-10-16 10:52:00
 | NG N2 | 295 | 84 | 90 | 44.4 | 47.7 | 8.54 | 2001-10-16 10:52:00
 | NG Q2 | 300 | 91 | 97 | 44.9 | 48 | 8.76 | 2001-10-16 10:52:00
 | NG U2 | 300 | 95 | 101 | 44.7 | 47.6 | 8.7 | 2001-10-16 10:52:00
 | NG V2 | 300 | 99 | 106 | 44.7 | 48 | 8.74 | 2001-10-16 10:52:00
 | [NAME] | 340 | 124 | 133 | 46.1 | 49.5 | 10.22 | 2001-10-16 10:52:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 789473d1659108702-count-the-number-of-results-in-a-table-last-man-standing
Sheet: week 1

 | Week 1
 | NAME | TEAM
 |  |  |  |  | Teams | amount Picked
 |  |  |  |  | [NAME] | 1
 |  |  |  |  | [NAME] | 2
 |  |  |  |  | Northampton Town | 4
Spreadsheet: 149377d1333901245-using-vlookup-with-separate-worksheets-e02m3grades_ballardcharles
Sheet: Documentation

Prepared by
Updated on
Purpose
[NAME] |  |  | List of Range Names
Breakpoints | Grade |  | Name | Location
95-100 | A
90-94.9 | A-
87-89.9 | [NAME]
83-86.9 | B
80-82.9 | B-
77-79.9 | C+
73-76.9 | C
70-72.9 | C-
67-69.9 | [NAME]
63-66.9 | D
60-62.9 | D-
0-59.9 | F
Spreadsheet: 807944d1670178099-dynamic-dependent-dropdown-list-in-excel-categories-tms
Sheet: Sheet1 (TMS)

 | STEP 1
 | Categories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prep
 | Cat 1 | << 1. Up to 10 but not necessarily 10 (and with blanks) |  |  |  |  | << 2. Categories reorganized to remove blanks
 | Cat 2 |  |  |  |  | Cat 2
 | Cat 3 |  |  |  |  | Cat 3
 | Cat 4 |  |  |  |  | Cat 4 |  |  | Cat 1 | << 3. Dropdown on only available categories, without blanks
 | Cat 5 |  |  |  |  | Cat 5 |  |  | "DV: $G$5#"
 |  |  |  |  |  | Cat 6
 | Cat 6 |  |  |  |  | Cat 7
 | Cat 7
 | STEP 2 | << Up to 16 but not necessarily 16 (and with blanks). Each associated with a Category
 | Sub Categories | Associated Cat
1 | Sub 1 | Cat 1 | << Using categories dropdown previously created to associate category to each sub
 | Sub 2 | Cat 4
 | Sub 3 | Cat 6
 | Sub4 | Cat 4 |  | Cat Dropdown
 | Sub 5 | Cat 2 |  | Cat 2 |  |  | Cat 2 | Cat 3 | Cat 4 | Cat 5 | Cat 6 | Cat 7
 | Sub 6 | Cat 3 |  | "DV: $G$5#"
 |  |  |  | [NAME]?? |  | Sub7 |  | Sub 13 | Sub4 | Sub 12 | Sub 10 | Sub 11
 | Sub7 | Cat 1 |  | Sub 1
 | Sub 8 | Cat 7 |  | "DV: =INDIRECT(SUBSTITUTE($E$24," ","_"))"
 | Sub 9 | Cat 5
 | Sub 10 | Cat 6
 |  |  |  | (copied across)
 | Sub 11 | Cat 7
 | Sub 12 | Cat 5
 | Sub 13 | Cat 3
Spreadsheet: 65195175-5eef-4826-ad07-6e25f186c983
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
FABP | Test | FABP | Amyloid Beta-Protein | Amyloid B-Protein | Radioimmunoassay (RIA) | EDTA (lavender-top) tube: EDTA OR |  |  | 3 | mL | Draw blood in a lavender-top (EDTA) tube(s). Spin down and send 3 mL of EDTA plasma frozen in plastic vial. | 1 mL | Specimens other than	Plasma Anticoagulants other than	EDTA Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | [NAME]): 20-80 pg/ml   This test was developed and its performance characteristics determined by Inter Science Institute. It has not been cleared or approved by the US Food and Drug Administration. The FDA has determined that such clearance or approval is not necessary.   Test Performed by: Inter Science Inst                                        944 West Hyde Park                                        Inglewood, CA 90302 | Monday through Friday | 10 - 12 days | 12 - 16 days | 1 | 83519 |  |  |  |  | Inter Science Institute
FABP | [NAME] | PLEDTA | [NAME] |  |  |  | Frozen | 30 days
FABP | Result | Z0940 | Amyloid B-Protein | Amyloid B-Protein | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 714315d1611168813-create-list-including-duplicates-from-range-book1
Sheet: Sheet2

ID | Owner
506 | Team 1
506 | Team 7
505 | Team 1
505 | Team 7
504 | Team 1
504 | Team 7
502 | Team 4
502 | Team 7
495 | Team 1
495 | Team 2
495 | Team 7
495 | Team 9
492 | Team 1
492 | Team 2
492 | Team 6
479 | Team 2
479 | Team 3
475 | Team 3
475 | Team 4
474 | Team 4
474 | Team 7
471 | Team 3
471 | Team 8
424 | Team 2
424 | Team 7
407 | Team 3
407 | Team 6
393 | Team 1
393 | Team 7