tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744992d1629640701-excel-updating-a-datasheet-with-new-data-list-test-1-
Sheet: Sheet1

Names | Old remark | New Remarks | New Remarks1 |  |  | Result Table should be:
Paris | rem15 | #N/A | rem15
[NAME] | rem16 | #N/A | rem16 |  |  | Names | Remarks
Ruben | rem17 | #N/A | rem17 |  |  | Paris | rem15 |  |  | new entries
Rosita | rem18 | #N/A | rem18 |  |  | [NAME] | rem16 |  |  | updated entries
[NAME] | rem19 | Newrem1 | rem19 |  |  | Ruben | rem17 |  |  | Old remarks
Gearldine | rem20 | Newrem2 | rem20 |  |  | Rosita | rem18 |  |  | Unchanged remarks
Maryland | rem21 | Newrem3 | rem21 |  |  | [NAME] | rem19 |  | There are no duplicate names
[NAME] | rem22 | Newrem4 | rem22 |  |  | Gearldine | rem20
Ethel | rem23 | Newrem16 | rem23 |  |  | Maryland | rem21
[NAME] | rem24 | Newrem17 | rem24 |  |  | [NAME] | rem22
Zachary | rem25 | Newrem18 | rem25 |  |  | Ethel | rem23
Conchita | rem26 | Newrem19 | rem26 |  |  | [NAME] | rem24
Oda | rem27 | Newrem20 | rem27 |  |  | Zachary | rem25
Elmo | rem28 | Newrem21 | rem28 |  |  | Conchita | rem26
Taisha | rem29 | Newrem22 | rem29 |  |  | Oda | rem27
Christiane | rem41 | #N/A | rem41 |  |  | Elmo | rem28
Lupe | rem48 | #N/A | rem48 |  |  | Taisha | rem29
Suzie | rem49 | #N/A | rem49 |  |  | Christiane | rem41
 |  |  |  |  |  | Lupe | rem48
 |  |  |  |  |  | Suzie | rem49
 |  |  |  |  |  | Annette | Newrem5
 |  |  |  |  |  | Sadie | Newrem6
 |  |  |  |  |  | [NAME] | Newrem7
 |  |  |  |  |  | [NAME] | Newrem8
 |  |  |  |  |  | Maryetta | Newrem9
 |  |  |  |  |  | Adelle | Newrem10
 |  |  |  |  |  | Israel | Newrem11
 |  |  |  |  |  | Shaun | [NAME]
 |  |  |  |  |  | Lezlie | Newrem13
 |  |  |  |  |  | [NAME] | Newrem14
 |  |  |  |  |  | Eleonora | Newrem15
 |  |  |  |  |  | Argelia | Newrem23
 |  |  |  |  |  | Chastity | Newrem24
 |  |  |  |  |  | [NAME] | Newrem25
Spreadsheet: 861630d1709525047-groupby-does-not-sum-the-entire-array-provided-groupby-function-horizontal-sum-2-
Sheet: 1

Name | ID | Product | JAN | FEB | MAR | APR | MAY | JUN
Company A | 1 | A | 1133000 | 1053000 | 1133000 | 259000 | 0 | 40000 |  |  | Q1 | Q2
Company Z | 26 | B | 259000 | 385000 | 1053000 | 385000 | 1000 | 42000 |  | 1 | 3699000 | 301000
Company B | 2 | C | 0 | 1000 | 1133000 | 1053000 | 1133000 | 1053000 |  | 2 | 1134000 | 3239000
Company C | 3 | A | 40000 | 42000 | 259000 | 385000 | 259000 | 385000 |  | 3 | 2798000 | 1681000
Company A | 1 | C | 149000 | 231000 | 0 | 1000 | 0 | 1000 |  | 4 | 87000 | 124000
Company D | 4 | C | 29000 | 18000 | 40000 | 42000 | 40000 | 42000 |  | 6 | 577000 | 611000
Company F | 6 | D | 204000 | 224000 | 149000 | 231000 | 149000 | 231000 |  | 7 | 131000 | 65000
Company G | 7 | C | 23000 | 79000 | 29000 | 18000 | 29000 | 18000 |  | 26 | 1713000 | 609000
Company C | 3 | E | 1270000 | 983000 | 204000 | 224000 | 204000 | 224000
Company Z | 26 | C | -8000 | 1000 | 23000 | 79000 | 23000 | 79000
 |  | Company | Q1
 |  |  | 1282000 | 1284000 | 1133000
 |  | 2 | 0 | 1000 | 1133000
 |  | 3 | 1310000 | 1025000 | 463000
Spreadsheet: 147108d1332526856-value-with-dget-figuring-out-dget
Sheet: Labor

Contractor First Name | Contractor Last Name | Vendor | Classifications | Vendor Classification | ST Rate | OT Rate | ST Rate | OT Rate
[NAME] | Smith | Vendor A | Assistant | Vendor A Assistant | 50 | #N/A | 50 | 75
[NAME] | Hall | Vendor A | Safety | Vendor A Safety | #N/A | #N/A | 50 | 75
[NAME] | Who | Vendor B | Roustabout | Vendor B Roustabout | #N/A | #N/A | 70 | 105
[NAME] | Laughalot | Vendor B | Electrician | Vendor B Electrician | #N/A | #N/A | 65 | 90
Hello | Itsmeagain | Vendor B | Apprentice | Vendor B Apprentice | #N/A | #N/A | 80 | 120
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 35

कार्यक्रम PROGRAM |  |  | बुतनर्ादी ऋण मूल्ािंकन और तनगरानी BASIC CREDIT APPRAISAL & MONITORING (BCAM) | PROG CODE
 |  |  |  | IT 1587
तर्षर् समूह/SUBJECT GROUP |  |  | CREDIT
उद्देश्य/OBJECTIVE |  |  | TO IMPART ANALYSIS AND APPRAISAL SKILLS FOR HANDLING LOANS / ADVANCES
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 5 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration and Knowledge Profiling, Over view of Credit, Present Economic Scenario, Overall Macro Economic View, Challenges faced by  banks  in  lending,  Credit  requirements  of  various  sectors  of economy
 | II | Types  of  Borrowal  Customers  -  Proprietorship  firms,  Partnership firms,  Companies  incorporated  under Companies  Act  (Private Ltd. and  Public  Ltd.),  Trusts;  [NAME];  SHG,  JLG,  Limited  Liability Partnerships; Basic Law and Legal aspects governing each type of borrower entity;
 | III | Lending  Norms:  a)   Identification  of  borrowers;  Customer  Due Diligence (KYC & AML guidelines);  CRILC, b) Borrower’s profile, Pre- sanction   visits   c)   Reports   from   Credit   Information   companies (CIBIL,CRIF, Experian,  Equifax),  ECGC caution  list with Details, d) Credit Investigation Report  (NF588),  Opinion  Letter e) ROC  Search report,  CERSAI  Search  Report  and  other market enquiries, MCA21
 | IV | Priority  Sector:  Classification,  Need  for  priority  sector  lending, Targets  and  Mandatory  Norms,  RIDF  and  RBI  guidelines,  Credit facilities to SC/ST Beneficiaries.
Day 2 | I & II | MSME  Policy & Products
 | III & IV | Financial Statement & Analysis along with Case Study
Day 3 | I & II | Assessment of Working Capital with the help of case study, Non fund based Limits-Concept & Assessment
 | III  & IV | Credit Policy and delegation of Power
Day 4 | I  & II | Term Loan Assessment  and case study
 | III | Legal Aspects of Documentation
 | IV | Monitoring of Advances & Recovery
Day 5 | I | Customer Relationship Management, Data Analytics Tools With the help of DNA
 | II | Implementation of OL at workplace, Prevention of Sexual Harassment and Valediction
 | III | Business Ethics and Value System
 | IV | Exit Test, Feedback & Valediction
Spreadsheet: 212640-group-by-a-description-and-sum-its-values-copy-of-book1
Sheet: Sheet1

 | Code | Desc. | Qty. |  |  | Code | Desc. | Qty.
 | 201 | Eggs | 1 |  |  | 200 | Pineapples | 6
 | 200 | Pineapples | 6 |  | >>>> | 201 | Eggs | 3
 | 205 | Potatoes | 5 |  |  | 202 | Carrots | 12
 | 202 | Carrots | 3 |  |  | 205 | Potatoes | 5
 | 210 | Oranges | 8 |  |  | 210 | Oranges | 8
 | 202 | Carrots | 9
 | 201 | Eggs | 2
 |  |  |  |  | Code | Desc. | Sum of Qty.
 |  |  |  |  | 200 | Pineapples | 6
 |  |  |  |  | 201 | Eggs | 3
 |  |  |  |  | 202 | Carrots | 12
 |  |  |  |  | 205 | Potatoes | 5
 |  |  |  |  | 210 | Oranges | 8
 |  |  |  |  | Grand Total |  | 34
Spreadsheet: 834765d1688058000-help-with-a-byrow-pb_byrow-1-
Sheet: Feuil1

label+list1 |  |  |  |  |  | wires,rods |  | label | list2
Structure≡≡wires,[NAME],sushi,powder||Size≡≡30||Purity≡≡H |  |  |  |  | Form | pasta,sushi,powder |  | Structure | tubes
 |  |  |  |  | Size | 30 |  | Form | paste,powder
 |  |  |  |  | Purity | H |  | Size
 |  |  |  |  |  |  |  | Another | nothing
 |  | A |  |  |  | B |  |  |  | C
 |  | label | list1 | list2 |  | missing (BYROW does not work) |  |  |  | missing (BYROW works) |  |  | missing (MAPS direct works!!!)
 |  |  | wires,rods | tubes
 |  | Form | pasta,sushi,powder | paste,powder |  | pasta |  |  |  | pasta, sushi |  |  | pasta, sushi
Spreadsheet: 00f571a3-beab-443a-a287-8cf91aa5df59
Sheet: Sheet1

Name | Address | City, State, Zip Code | Phone | Fax | e-mail | Contact
[NAME]. | 1 Circuit Drive | Dorchester, MA | [PHONE] |  | l/m
One Source | 5028 Tampa West Blvd | Tampa, FL 33634 | [PHONE]
Sterling Golf | 212 Kenrick Street | Newton, MA  02458 | [PHONE] | [PHONE] | [EMAIL] | [NAME]
Valley Crest | 1010 Pleasant Street | Belmont, MA  02478 | [PHONE] | [PHONE] | no email | sent fax
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 11 Math

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS High School
Grade 11 Mathematics MTAS
Raw Score | Scale Score* | Level
0 | 159 | D
1 | 166 | D
2 | 170 | D
3 | 173 | D
4 | 175 | D
5 | 177 | D
6 | 179 | D
7 | 182 | D
8 | 184 | D
9 | 187 | D
10 | 190 | P
11 | 191 | P
12 | 193 | P
13 | 194 | P
14 | 195 | P
15 | 196 | P
16 | 197 | P
17 | 198 | P
18 | 198 | P
19 | 199 | P
20 | 200 | M
21 | 201 | M
22 | 202 | M
23 | 203 | E
24 | 205 | E
25 | 207 | E
26 | 210 | E
27 | 216 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2012 and 2008/2009/2010/2011 Science MTAS metrics are not comparable
***2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 21067d1208185025-matching-2-lists-sample-vlookup
Sheet: Sheet1

Barcode | Series | Code | Section | Location | SKP | [NAME] | Dept ID | Description
FABG76 | CMS | C*** | IM | In Stock | 800 | 344785 | COMPLAINTS | COMPLAINTS
FAB200 | CMS | C*** | IM | In Stock
named [NAME]
(1)Barcode (2)SKP (3)Cust [NAME] (4)Dept ID (5)Description
FABG76 | 800 | 344785 | COMPLAINTS | COMPLAINTS
FABUZT | 900 | 3889556 | COMPLAINTS | COMPLAINTS
Spreadsheet: 153880d1336077770-excel-2007-help-please-i-thought-this-would-be-easy-but-maybe-not-vlookupexample
Sheet: Sheet2

Code | Value | Item
1 | 25 | [NAME]
2 | 35 | Nail some wood
5 | 65 | Unload Truck
9 | 43 | Inspect Foundation
28 | 46 | Pour Concrete
45 | 35 | Build Dog House
55 | 77 | Walk Dogs
Spreadsheet: 756576d1637648787-excel-consistency-check-across-different-row-and-column-values-based-on-common-value-book2-2-
Sheet: Sheet1

Destination | Travel type |  |  |  |  |  |  |  |  | Customer id |  |  |  |  |  |  |  |  |  |  |  | Customer phone number | Customer phone number | Customer phone number | Customer phone number | Customer phone number | customer Address | Customer place | Customer city | Customer country | Customer country | Customer country | Customer country | Customer country | Customer country | Customer country | Customer country | Customer country | Customer country | Customer country
 |  |  |  |  |  |  |  |  |  | 1234 |  |  |  |  |  |  |  |  |  |  |  | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a | a
 |  |  |  |  |  |  |  |  |  | 1234 |  |  |  |  |  |  |  |  |  |  |  | b | b | b | b | b | a | b | b | b | b | b | b | b | b | b | b | b | b | b
 |  |  |  |  |  |  |  |  |  | 567 |  |  |  |  |  |  |  |  |  |  |  | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b
 |  |  |  |  |  |  |  |  |  | 890 |  |  |  |  |  |  |  |  |  |  |  | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b
 |  |  |  |  |  |  |  |  |  | 1234 |  |  |  |  |  |  |  |  |  |  |  | b | b | b | b | b | c | b | b | b | b | b | b | b | b | b | b | b | b | b
 |  |  |  |  |  |  |  |  |  | 3321 |  |  |  |  |  |  |  |  |  |  |  | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b | b
 |  |  |  |  |  |  |  |  |  | 1234 |  |  |  |  |  |  |  |  |  |  |  | b | b | b | b | b | c | b | b | b | b | b | b | b | b | b | b | b | b | b
 |  |  |  |  |  |  |  |  |  | 890 |  |  |  |  |  |  |  |  |  |  |  | b | b | b | b | b
Spreadsheet: debra_perlingiere__8461__MasterPhys
Sheet: Sheet1

Master Firm Purchase/Sale Agreement Worksheet
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER: | [NAME]
COUNTERPARTY: | [NAME], Inc. | CONTACT:
ADDRESS: | 155 Inverness Dr. [NAME]. 200 | TITLE:
 | Englewood, Co. 80112-5004 | PHONE:
 |  | FAX:
Incorporation State | DE | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 5000000 | USD
Incorporation State
COLLATERAL  THRESHOLD
 | 200000 | 5000000 | USD
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING | 250000 | 250000 | USD
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change
-Below = S&P/Moody's |  | BBB- | S&P
Financial Covenants
-Funded debt/Worth | 01:01:00
-Minimum Net Worth | $40MM |  | USD
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 1000000 | 100000000 | USD
-Guarantor ($[NAME])
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: x | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0906
Spreadsheet: 840122d1692452661-get-number-of-repetative-duplicate-2-digits-from-10-digit-number-sample-workbook-aligw
Sheet: Sheet1

Number | Splitting number in 2 digits |  |  |  |  | Unique 2 digits numbers | Total [NAME] (Most imp column)
6357965796 | 63 | 57 | 96 | 57 | 96 | 63, 57, 96 | 3
6357985798 | 63 | 57 | 98 | 57 | 98 | 63, 57, 98 | 3
6357995798 | 63 | 57 | 99 | 57 | 98 | 63, 57, 99, 98 | 4
8832705612 | 88 | 32 | 70 | 56 | 12 | 88, 32, 70, 56, 12 | 5
9689899689 | 96 | 89 | 89 | 96 | 89 | 96, 89 | 2
8080807060 | 80 | 80 | 80 | 70 | 60 | 80, 70, 60 | 3
6574859674 | 65 | 74 | 85 | 96 | 74 | 65, 74, 85, 96, 74 | 5
Spreadsheet: 104403d1302024916-conditional-formatting-for-future-dates-book1_just_tonight-
Sheet: Sheet1

Date Next Test Due
2011-03-19 00:00:00
2011-03-20 00:00:00
2011-03-21 00:00:00
2011-03-22 00:00:00
2011-03-23 00:00:00
2011-03-24 00:00:00
2011-03-25 00:00:00
2011-03-26 00:00:00
2011-03-27 00:00:00
2011-03-28 00:00:00
2011-03-29 00:00:00
2011-03-30 00:00:00
2011-03-31 00:00:00
2011-04-01 00:00:00
2011-04-02 00:00:00
2011-04-03 00:00:00
2011-04-04 00:00:00
2011-04-05 00:00:00
2011-04-06 00:00:00
2011-04-07 00:00:00
2011-04-08 00:00:00
2011-04-09 00:00:00
2011-04-10 00:00:00
2011-04-11 00:00:00
2011-04-12 00:00:00
2011-04-13 00:00:00
2011-04-14 00:00:00
2011-04-15 00:00:00
2011-04-16 00:00:00
2011-04-17 00:00:00
2011-04-18 00:00:00
2011-04-19 00:00:00
2011-04-20 00:00:00
2011-04-21 00:00:00
2011-04-22 00:00:00
2011-04-23 00:00:00
2011-04-24 00:00:00
2011-04-25 00:00:00
2011-04-26 00:00:00
2011-04-27 00:00:00
2011-04-28 00:00:00
2011-04-29 00:00:00
2011-04-30 00:00:00
2011-05-01 00:00:00
2011-05-02 00:00:00
2011-05-03 00:00:00
2011-05-04 00:00:00
2011-05-05 00:00:00
2011-05-06 00:00:00
2011-05-07 00:00:00
2011-05-08 00:00:00
2011-05-09 00:00:00
2011-05-10 00:00:00
2011-05-11 00:00:00
2011-05-12 00:00:00
2011-05-13 00:00:00
2011-05-14 00:00:00
2011-05-15 00:00:00
2011-05-16 00:00:00
2011-05-17 00:00:00
Spreadsheet: 8e12b5b1-f709-42c9-88eb-dbbc576b32e0
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
IGGS4 | Test | IGGS4 | Immunoglobulin Subclass IgG4, Serum | Immunoglobulin Subclass IgG4, S | Nephelometry | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 0-<5 months: < or =19.8 mg/dL 5-<9 months: < or =20.8 mg/dL 9-<15 months: < or =22.0 mg/dL 15-<24 months: < or =23.0 mg/dL 2-<4 years: 0.4-49.1 mg/dL 4-<7 years: 0.8-81.9 mg/dL 7-<10 years: 1.0-108.7 mg/dL 10-<13 years: 1.0-121.9 mg/dL 13-<16 years: 0.7-121.7 mg/dL 16-<18 years: 0.3-111.0 mg/dL > or =18 years: 2.4-121.0 mg/dL | Monday through Saturday; Continuously until 3 p.m. | Same day/1 day | 2 days | 1 | 82787 |  |  |  |  | Rochester
IGGS4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
IGGS4 | Result | IGGS4 | Immunoglobulin Subclass IgG4, S | Immunoglobulin Subclass IgG4, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2469-5 | IgG subclass 4:MCnc:Pt:Ser:Qn:
Spreadsheet: 60910d1261487202-formula-find-last-used-cell-and-change-referece-solution4_2
Sheet: Sheet1

1 | 15 |  | 1 |  |  | a | n | a |  |  |  | test 1
2 | 16 |  | 2 |  |  | b | o | b |  |  |  | test 2
3 | 17 |  | 3 |  |  | c | p | c |  |  |  | test 3
4 | 18 |  | 4 |  |  | d | q | d |  |  |  | test 4
5 | 19 |  | 5 |  |  | e | r | e |  |  |  | test 5
6 | 20 |  | 6 |  |  | f | s | f |  |  |  | test 6
7 | 21 |  | 7 |  |  | g | t | g |  |  |  | test 7
8 | 22 |  | 8 |  |  | h | u | h |  |  |  | test 8
9 | 23 |  | 9 |  |  | i | v | i |  |  |  | test 9
10 | 24 |  | 10 |  |  | j | w | j |  |  |  | test 10
11 | 25 |  | 11 |  |  | k | x | k |  |  |  | test 11
12 | 26 |  | 12 |  |  | l | y | l |  |  |  | test 12
13 | 27 |  | 13 |  |  | m | z | m |  |  |  | test 13
14 | 28 |  | 14 |  |  |  | aa | n |  |  |  | test 14
 | 29 |  | 15 |  |  |  | ab | o
 | 30 |  | 16 |  |  |  | ac | p
 | 31 |  | 17 |  |  |  | ad | q
 | 32 |  | 18 |  |  |  | ae | r
 | 33 |  | 19 |  |  |  | af | s
 | 34 |  | 20 |  |  |  | ag | t
 |  |  | 21 |  |  |  |  | u
 |  |  | 22 |  |  |  |  | v
 |  |  | 23 |  |  |  |  | w
 |  |  | 24 |  |  |  |  | x
 |  |  | 25 |  |  |  |  | y
 |  |  | 26 |  |  |  |  | z
 |  |  | 27 |  |  |  |  | aa
 |  |  | 28 |  |  |  |  | ab
 |  |  | 29 |  |  |  |  | ac
 |  |  | 30 |  |  |  |  | ad
 |  |  | 31 |  |  |  |  | ae
 |  |  | 32 |  |  |  |  | af
 |  |  | 33 |  |  |  |  | ag
 |  |  | 34 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Spreadsheet: b1231315-ecef-4210-94c0-ffee99aed3c4
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
AGABS | Test | AGABS | Alpha-Galactosidase, Blood Spot | Alpha-Galactosidase, BS | Fluorometric Enzyme Assay |  |  |  | 2 | Blood spots | Container/Tube:  Preferred: Whatman Protein Saver 903 Paper Acceptable: Ahlstrom 226 filter paper, Supplemental Newborn Screening Card (Supply T493) [NAME]: 2 blood spots Collection Instructions:  1. Do not use device or capillary tube containing EDTA to collect specimen. 2. An alternative blood collection option for a patient >1 year of age is fingerstick. 3. Let blood dry on the filter paper at ambient temperature in a horizontal position for 3 hours.  4. Do not expose specimen to heat or direct sunlight.  5. Do not stack wet specimens.  6. Keep specimen dry.  Forms: 1.   1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | Blood Spot: 1 | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Blood spot specimen that shows serum rings or has multiple layers | Males: > or =1.2 nmol/mL/h  Females: > or =2.8 nmol/mL/h An interpretive report will be provided. | Thursday; morning | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
AGABS | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 90 days
AGABS | Result | 50883 | [NAME] | [NAME] | Alphanumeric
AGABS | Result | 50884 | [NAME] | [NAME] | Numeric
AGABS | Result | 50885 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
AGABS | Result | 50886 | Order Date | Order Date | Alphanumeric
AGABS | Result | 50887 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
AGABS | Result | 50888 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
AGABS | Result | 50889 | Alpha-Galactosidase, BS | Alpha-Galactosidase, BS | Numeric |  |  |  |  | nmol/mL/h |  |  |  |  |  |  |  |  |  | 55908-8 | Alpha galactosidase A:CCnc:Pt:Bld.dot:Qn:
AGABS | Result | 50890 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
AGABS | Result | 50891 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AGABS | Result | 50892 | Reviewed By | Reviewed By | Numeric
AGABS | Result | 50893 | Release Date | Release Date | Alphanumeric
Spreadsheet: 26823d1219346694-auto-populate-cell-based-on-values-in-other-cells-indexing
Sheet: Sheet2

 | Option 1 | Option 2
Product 1 | 30 | 82
Product 2 | 54 | 28
Product 3 | 43 | 27
Product 4 | 33 | 20
Product 5 | 31 | 81
Product 6 | 20 | 11
Product 7 | 73 | 71
Product 8 | 84 | 12
Product 9 | 33 | 49
Product 10 | 16 | 57
Spreadsheet: 153420d1335898541-using-vlookup-with-two-different-columns-sample_excel_parameters
Sheet: Sheet4

 | Values
Row Labels | Sum of Cost | Sum of Revenue | Sum of Profit
Atherton | 7064.690000000001 | 11055.21 | 3990.52
Belvedere | 6295.71 | 11118.63 | 4822.919999999996
Del Monte Forest | 7269.630000000001 | 11850.15 | 4580.52
Diablo | 5050.050000000001 | 9955.230000000005 | 4905.180000000001
Fairbanks Ranch | 6775.309999999999 | 10168.86 | 3393.55
Hidden Hills | 4225.250000000001 | 9169.630000000006 | 4944.379999999999
Hillsborough | 5820.73 | 9212.75 | 3392.02
[NAME] | 3890.720000000002 | 8475.499999999996 | 4584.780000000001
Los Altos Hills | 4869.449999999999 | 9196.470000000003 | 4327.02
Malibu | 5948.329999999998 | 9381.479999999998 | 3433.15
[NAME] | 8266.910000000003 | 12688.49 | 4421.580000000001
Montecito | 6879.86 | 11230.95 | 4351.09
Newport Coast | 8285.050000000001 | 12871.13 | 4586.080000000002
Piedmont | 4661.440000000002 | 8719.720000000001 | 4058.28
[NAME] | 7169.030000000002 | 11551.78 | 4382.750000000002
Rancho Santa Fe | 6567.039999999996 | 11223.44 | 4656.399999999998
Rolling Hills | 7161.250000000001 | 13404.85 | 6243.599999999999
[NAME] | 4257.599999999999 | 8870.25 | 4612.650000000001
Tiburon | 6446.550000000003 | 10475.83 | 4029.28
Woodside | 5821.680000000002 | 11334.99 | 5513.309999999998
Grand Total | 122726.28 | 211955.34 | 89229.06
Spreadsheet: 466605d1466325838-league-table-tiebreaker-standings
Sheet: Results

2011-09-13 00:00:00 | Germany |  | 2 | 0 |  | Ukraine |  |  |  |  |  | Pts |  | W |  | L |  | D |  | GF |  | GA |  | DIFF |  |  | H2H
2011-09-13 00:00:00 | Poland |  | 1 | 0 |  | NI |  |  |  | Germany
2011-09-13 00:00:00 | Ukraine |  | 0 | 2 |  | NI |  |  |  | Poland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ties
2011-09-13 00:00:00 | Germany |  | 0 | 0 |  | Poland |  |  |  | NI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | Tot
2011-09-20 00:00:00 | Germany |  | 5 | 0 |  | NI |  |  |  | Ukraine
2011-09-20 00:00:00 | Poland |  | 0 | 3 |  | Ukraine
Spreadsheet: 694483d1599639486-how-to-count-repeating-purchase-from-different-year-testrpt
Sheet: 2018

No | Name | Product
1 | Adam | [NAME]
2 | [NAME] | USB
3 | [NAME] | PS4
4 | Thor | [NAME]
5 | Thor | KEYBOARD
6 | Adam | [NAME]
7 | [NAME] | KEYBOARD
8 | Dude | KEYBOARD
9 | Duke | [NAME]
10 | Broly | HEADPHONE
Spreadsheet: 219682d1362875809-sumifs-with-multiple-lookups-with-multiple-results-to-lookup-other-values-testmodel2
Sheet: Totals

 |  | Total Mods
Comp1 | AK |  | Lookup state, see combo, then choose comp that have X in that Mod, add total |  |  |  |  |  |  |  | Combo3 | Comp1 | Comp2 | Mod1 | Mod3 | Mod4
Comp2 | AL |  |  |  |  |  |  |  |  |  | Combo2 | Comp2 | Comp4 | Mod1 | Mod2
[NAME] | AL |  |  |  |  |  |  |  |  |  | Combo1 | Comp1 | [NAME] | Mod2 | Mod3
Comp4 | AZ |  |  |  |  |  |  |  |  |  |  | Comp4 |  | Mod2 | Mod3
Comp4 | AK
Comp4 | AZ