tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 855240d1704887379-concerting-time-to-degrees-time-and-degrees
Sheet: Sheet1

TIME | DEGREE
18:00:00 | 0
20:00:00 | 30
21:00:00 | 45 |  |  | 24 | HOURs
22:00:00 | 60 |  |  | 360 | DEGREES
22:48:00 | 72
00:00:00 | 90 |  |  |  | DEGRESS/HOUR
02:00:00 | 120
03:00:00 | 135
03:36:00 | 144
04:00:00 | 150
06:00:00 | 180
08:00:00 | 210
08:24:00 | 216
09:00:00 | 225
10:00:00 | 240
12:00:00 | 270
13:12:00 | 288
14:00:00 | 300
15:00:00 | 315
16:00:00 | 330
18:00:00 | 360
17:59:59
Spreadsheet: 160311d1339040778-to-get-minimum-value-from-a-database-with-criteria-else-return-na-min-example_2
Sheet: Sheet1

 |  |  | Criteria | Result
 | 6.1.1Wafer mount and saw |  | 6.1apple
 | 6.1.2Wafer mount and saw |  | 6.2orange
 | 6.1.3Wafer mount and saw |  | 6.3grape
 | Process |  | 6.4kiwi |  | ----How I make this to become "NA"instead return me to "0"
 | 6.1.1Wafer mount and saw |  | Fruit | Qty
 | 6.1.1Wafer mount and saw |  | 6.1apple | 1
 | 6.1.3Wafer mount and saw |  | 6.2orange | 2
 | 6.1.2Wafer mount and saw |  | 6.3grape | 3
 | 6.1.2Wafer mount and saw |  | 6.1apple | 4
 | 6.1.3Wafer mount and saw |  | 6.1apple | 5
 | 6.1.1Wafer mount and saw |  | 6.3grape | 6
 | 6.1.1Wafer mount and saw |  | 6.1apple | 7
 | 6.1.3Wafer mount and saw |  | 6.2orange | 2
 | 6.1.1Wafer mount and saw |  | 6.3grape | 9
 | 6.1.3Wafer mount and saw |  | 6.1apple | 1
 | 6.1.2Wafer mount and saw |  | 6.1apple | 1
 |  |  | 6.3grape | 7
 |  |  | 6.2orange | 4
 |  |  | 6.3grape | 6
 |  |  | 6.3grape | 8
 | Hope this help.
 | Pichart Y.
Spreadsheet: e2e71c40-0664-447c-96d3-6541be99c4d8
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
GUIN | Test | GUIN | Guinea Pig Epithelium, IgE | Guinea Pig Epithelium, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
GUIN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GUIN | Result | GUIN | Guinea Pig Epithelium, IgE | Guinea Pig Epithelium, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6134-1 | Guinea pig epithelium [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 276b4688-f685-429a-8578-48ac8a88552b
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (8 [NAME]):
 | 5 Labortechnische Geräte 5.4 Labortechnik und Laboreinrichtung 5.4.3 Pumpen, Förder- und Verbindungstechnik 5.4.3.10 Mehrwegeventile
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | ASCO Numatics GmbH | Deutschland | [NAME] | 75248 | A1.217
2 | Bio-Chem Fluidics Inc. | USA | Boonton | NJ 07005 | B2.120
3 | Bürkert GmbH & Co. [NAME] | Deutschland | Ingelfingen | 74653 | A1.304
4 | CLIPPARD Inc. | USA | Cincinnati | OH 45239 | A1.234
5 | DURATEC Analysentechnik GmbH | Deutschland | [NAME] | 68766 | A1.111
6 | Fluid Automation Systems s.a. | [NAME] | [NAME] | 1290 | A2.417
7 | IDEX Health & Science | Deutschland | Wertheim | 97877 | A3.221/320
8 | [NAME] Miniaturkomponenten GmbH | Deutschland | Sulzbach | 65843 | A2.506
Spreadsheet: 773793d1648050156-data-validation-on-excel-tables-validation-of-area-codes
Sheet: Validation

 |  |  | TABLE BASED DATA |  |  |  |  |  |  | NON TABLE BASED DATA
 |  |  | City | State | Country | Area Code | Column1 |  |  | City | State | Country | Area Code
 |  |  | New York | NY | US | 212 |  |  |  | New York | NY | US | 337
 |  |  | El Centro | CA | US |  |  |  |  | El Centro | CA | US
 |  |  | Lafayette | LA | US | 337 |  |  |  | Lafayette | LA | US | 337
 |  |  | Islamorada | FL | US | 305 |  |  |  | Islamorada | FL | US | 305
 |  |  | Islamorada | FL | US |  |  |  |  | Islamorada | FL | US
 |  |  | Little Torch Key | FL | US | 305 |  |  |  | Little Torch Key | FL | US | 305
 |  |  | Chicago | IL | US | 312 |  |  |  | Chicago | IL | US | 312
 |  |  | Chicago | IL | US | 312 |  |  |  | Chicago | IL | US | 312
 |  |  | Sonora | CA | US | 209 |  |  |  | Sonora | CA | US | 209
 |  |  | Sonora | CA | US | 209 |  |  |  | Sonora | CA | US | 209
 |  |  | Ocean City | MD | US | 410 |  |  |  | Ocean City | MD | US | 410
 |  |  | Panama City Beach | FL | US | 850 |  |  |  | Panama City Beach | FL | US | 850
 |  |  | Tempe | AZ | US | 480 |  |  |  | Tempe | AZ | US | 480
 |  |  | Tempe | AZ | US | 480 |  |  |  | Tempe | AZ | US | 480
 |  |  | Casper | WY | US | 307 |  |  |  | Casper | WY | US | 307
 |  |  | West Lafayette | IN | US | 765 |  |  |  | West Lafayette | IN | US | 765
 |  |  | Toronto | ON | CA |  |  |  |  | Toronto | ON | CA
 |  |  | Montreal | QC | CA |  |  |  |  | Montreal | QC | CA
 |  |  | Montreal | QC | CA |  |  |  |  | Montreal | QC | CA
 |  |  | Yorkville | ON | CA |  |  |  |  | Yorkville | ON | CA
 |  |  | Halifax | NS | CA |  |  |  |  | Halifax | NS | CA
 |  |  | Medicine  Hat | AB | CA | 403 |  |  |  | Medicine  Hat | AB | CA | 403
 |  |  | Quebec City | QC | CA | 418 |  |  |  | Quebec City | QC | CA | 418
 |  |  | [NAME] | NS | CA | 902 |  |  |  | [NAME] | NS | CA | 902
 |  |  | Summerside | PE | CA |  |  |  |  | Summerside | PE | CA
 |  |  | Toronto | ON | CA |  |  |  |  | Toronto | ON | CA
 |  |  | Vancouver | BC | CA | 604 |  |  |  | Vancouver | BC | CA | 604
 |  |  | [NAME] | ON | CA | 905 |  |  |  | [NAME] | ON | CA | 905
 |  |  | Hearst | ON | CA | 705 |  |  |  | Hearst | ON | CA | 705
 |  |  | Vancouver | BC | CA | 604 |  |  |  | Vancouver | BC | CA | 604
 |  |  | [NAME] | AB | CA | 780 |  |  |  | [NAME] | AB | CA | 780
 |  |  | Fort Saint John | BC | CA | 250 |  |  |  | Fort Saint John | BC | CA | 250
 |  |  | Calgary | AB | CA | 403 |  |  |  | Calgary | AB | CA | 403
 |  |  | Laval | QC | CA |  |  |  |  | Laval | QC | CA
 |  |  | Vancouver | BC | CA | 236 |  |  |  | Vancouver | BC | CA | 236
 |  |  | Kelowna | BC | CA |  |  |  |  | Kelowna | BC | CA
Spreadsheet: 794998d1662458546-switching-collumn-in-sum-formula-based-on-current-date-month-test
Sheet: Tabelle1

 | value | JOP | [NAME] | April | Mai | Juni | [NAME] | August | September | Okt. | November | [NAME] | Januar | Februar | März | FY
 | planned |  |  | 2.32 | 2.1 | 2.51 | 2.4 | 2.1 | 2.4 | 2.4 | 2.3 | 2.55 | 2.3 | 2.35 | 2.5
 | actual |  |  | 2.112 | 1.995 | 2.758 | 2.354
 | planned
 | actual
 | planned |  |  | 0.4 | 0.2 | 0.4 | 0.4 | 0.2 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4
 | actual |  |  | 0.394 | 0.262 | 0.3 | 0.454
 | planned |  |  | 0.32 | 0.3 | 0.41 | 0.4 | 0.3 | 0.3 | 0.4 | 0.3 | 0.45 | 0.3 | 0.35 | 0.4
 | actual |  |  | 0.13 | 0.29 | 0.466 | 0.38
 | planned
 | actual
Spreadsheet: 268479d1380651290-finding-total-for-individuals-by-monthly-tab-and-unit-counts-bsr-teams-2013
Sheet: Apr

Daily Locked & Funded Loans AS 04/30/2013
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded
[NAME] | $382,000 (2) | $12,322,835 (32) | - | $4,358,750 (15)
[NAME] | $2,120,000 (4) | $16,894,918 (43) | $815,700 (2) | $8,063,325 (26)
[NAME] | $1,540,000 (4) | $13,121,575 (42) | $410,000 (1) | $7,070,200 (24)
[NAME] | $656,000 (2) | $11,627,198 (30) | - | $7,832,760 (21)
[NAME] | $1,848,000 (5) | $24,822,400 (68) | $344,000 (1) | $14,662,800 (41)
[NAME] | $280,000 (1) | $15,909,800 (45) | $1,185,950 (4) | $8,540,325 (27)
[NAME] | $1,460,000 (6) | $35,325,750 (122) | $500,000 (2) | $16,349,475 (63)
[NAME] | $716,500 (4) | $18,271,490 (52) | $1,238,000 (3) | $12,470,150 (40)
[NAME] | $5,450,500 (15) | $72,715,295 (199) | $1,815,200 (6) | $46,173,842 (137)
[NAME] | $473,000 (2) | $22,926,225 (60) | $1,559,600 (4) | $14,872,859 (39)
Kathi Yelland | - | $1,251,950 (6) | - | $552,000 (2)
Kris Varia | $706,288 (2) | $8,802,988 (25) | - | $5,393,300 (17)
[NAME] | $1,742,000 (5) | $10,837,250 (30) | $547,250 (2) | $13,111,700 (42)
[NAME] | $879,501 (2) | $29,664,751 (77) | - | $13,651,050 (36)
[NAME] | $556,000 (2) | $9,354,350 (26) | - | $6,406,050 (18)
[NAME] | $342,000 (1) | $18,231,027 (52) | $99,500 (1) | $9,198,024 (25)
Subtotal | $19,151,789 (57) | $322,079,802 (909) | $8,515,200 (26) | $188,706,610 (573)
Daily HomeLending / Alan Locked & Funded Loans AS 04/30/2013
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded
[NAME] | $1,492,000 (4) | $3,417,000 (8) | - | -
Subtotal | $1,492,000 (4) | $3,417,000 (8) | - | -
Daily Locked & Funded Loans AS 04/30/2013
 | Daily Locked | Active Locked | Daily Funded | MTD Funded
Total | $20,643,789 (61) | $325,496,802 (917) | $8,515,200 (26) | $188,706,610 (573)
Spreadsheet: 04d70e2e-e32d-465e-a5fd-a1898e505850
Sheet: FY 13 AC Name Changes 

 | Allocation Category Update Cross-Walk for FY12 to FY13
 | Related Services
 | FY12 | FY13
 | TL Summer Mandated Shared - IEP Paras portion | TL RS IEP Summer Mandated Shared
 | IDEA IEP Para | IDEA RS IEP Para
 | IDEA SBST Shared | IDEA RS SBST Shared
 | IDEA SBST Shared D79 | IDEA RS SBST Shared D79
 | TL APE Teacher Shared | TL RS APE Teacher Shared
 | TL Assistive Technology | TL RS Assistive Technology
 | TL IEP Para | TL RS IEP Para
 |  | TL RS IEP Para D79
 | TL IEP Para for Non Pubs | TL RS IEP Para for Non Pubs
 | TL IEP Teacher | TL RS IEP Teacher
 | TL IEP Teacher HS | TL RS IEP Teacher HS
 | TL Mandated Counseling Shared | TL RS Mandated Counseling Shared
 | TL Mandated Speech Shared | TL RS Mandated Speech Shared
 | IDEA Section 611 Therapist Shared | TL RS Occupational Therapist PS Shared
 |  | TL RS Physical Therapist PS Shared
 | TL Therapist PS Shared | TL RS Occupational Therapist PS Shared
 |  | TL RS Physical Therapist PS Shared
 | TL Therapist Summer Shared PS | TL RS Occupational Therapist Summer Shared PS
 |  | TL RS Physical Therapist Summer Shared PS
 | TL Related Services CW | TL RS Related Services CW
 | New for FY13 | TL ASA RS Rolled IEP Paras to be Reconciled
 | New for FY13 | TL ASA RS Speech Teachers
 | Special Education Allocation Name Changes
 | FY12 | FY13
 | TL Phase I SE Transitional Funding | TL SE Transitional Funding
 | TL Phase I SE Transitional Funding HS | TL SE Transitional Funding  HS
 | Other Allocations
 | FY12 | FY13
 | TL MS Task Force | Program TBD for FY13
 | Universal Prek Program Support | Universal Prek Program Support Shared
 | Title I DSSI SGO | Title I OSS SGO
 | Title I Translation SWP | Title I Translation Services SWP
 | Title I Translation Targeted Assistance | Title I Translation Services Targeted Assistance
 | TL Summer Mandated Shared - Secretaries, Selected A.P.s portion | TL Summer School Support Shared
 | Expired Allocation Categories
 | FY12 | FY13
 | 21st Century 60 | Expired
 | 21st Century 61 | Expired
 | 21st Century 62 | Expired
 | 21st Century 63 | Expired
 | 21st Century 64 | Expired
 | 21st Century 65 | Expired
 | 21st Century 66 | Expired
 | 21st Century 67 | Expired
 | 21st Century 68 | Expired
 | 21st Century 69 | Expired
Spreadsheet: 42652d1241188545-match-and-return-another-cell-value-lid-ecab-link-beta1
Sheet: Calculation

 |  |  |  |  |  |  |  | Showend | - | - | - | - | - |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | eCab Code Turn Around | Cornice Exception |  |  |  |  |  | Cornice Exception |  |  |  |  |  |  | eCab Code Turn Around
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name | Directory | Type | Quantity |  |  |  |  | Height |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | Depth |  |  |  |  |  |  | New Name |  |  |  |  | Code |  |  |  |  | Final New Name |  |  |  |  |  | Type |  |  | Name |  |  |  |  | New Name |  | Height |  | [NAME] |  | Depth |  | New Name = Height | Width = Depth
Spreadsheet: 686886d1594852249-remove-the-tables-descriptions-and-blank-rows-for-range-of-cells-book1-1-
Sheet: results

 | Pay Item | Description of Work | Quantity | Unit
 | G1P1. | New bridge 1500mm Super T (8055m2) | 953 | m2
 | G1P3. | Protection slab - Sewer 1752 x 1700mm (365m) | 496 | [NAME]
 | G1P4. | Demolition of existing bridge Grand Ave Bridge (500m2) | 395 | [NAME]
 | G1P5. | Demolition of existing Pedestrian bridge (755m2) | 216 | [NAME]
 | G1P6. | Retaining walls - Less than 2m high (900m2) - Updated quantity | 438 | [NAME]
 | G2-C2P1. | Primary Testing Subcontract (Provisional Sum) 1% of Construction Costs | 566 | Provisional Sum
 | [NAME]. | WAE Drawings 1% of Construction Costs | 511 | [NAME]
 | G2-C2P3. | Wet Weather Delay Costs | 385 | Rate Only (day)
 | G4P1. | Establishment of Principal's Project Accommodation | 163 | [NAME]
 | G4P2. | Maintenance of Principal's Project Accommodation until Completion | 573 | week
 | [NAME]. | Maintenance of Principal?s Project Accommodation after Completion (Item with Provisional Quality) | 486 | week
 | G4P4. | Removal of Principal's Project Accommodation | 280 | [NAME]
 | G7P1. | Coordination and Management of Utility Adjustment work | - | [NAME]
 | G7P6.1. | Relocate - 395m underground Electrical service | 447 | m
 | G7P7. | Engagement of Water Servicing Coordinator | 965 | [NAME]
 | G7P8. | Water Mains | 873
 | G7P8.1. | Relocate - 150mm (310m) | 57 | m
 | G7P8.2. | Relocate - 250mm (400m) | 340 | m
 | G7P8.3. | Relocate - 300mm (65m) | 484 | m
 | G7P10. | Traffic signals | 156 | [NAME]
 | G7P10.1. | Reonstruct - James Ruse / Grand / Hassall | 756 | [NAME]
 | G7P10.2. | Decommision - James Ruse / Prospect | 529 | [NAME]
 | G7P10.3. | Reconstruct - Hassall / Arthur | 195 | [NAME]
 | G7P12. | Telecommunications | 419
 | G7P12.1. | Relocate - 50mm Local service (200m) | 807 | m
 | G7P12.2. | Relocate - 35mm Local service (20m) | 442 | m
Spreadsheet: 852875d1702871414-partial-text-lookup-search-with-partial-text-in-source-book1
Sheet: Specialty

Church | NOTED
Carondelet Baptist Church | Y
Cornerstone Evangelical Free Church | Y
[NAME] | Y
First Baptist Church of Ferguson | Y
First Baptist Church of St. Charles | Y
First Christian Church of Florissant | Y
First Free Church | Y
First St. Charles United Methodist Church | Y
Good Shepherd Presbyterian Church | Y
Memorial Tabernacle Christian Life Center | Y
Messenger Church | Y
New Song Church | Y
New Wind International | Y
Refuge and Restoration Church | Y
ROC Ministries | Y
Rooftop | Y
St. Luke's United Methodist Church | Y
[NAME]. [NAME] and Paul Ecumenical Catholic Church USA | Y
Tower Grove Baptist Church | Y
True Gospel Miracle Church of God Apostolic Faith | Y
Spreadsheet: 275449d1383517885-sum-cells-based-on-current-month-report-template
Sheet: TVOD D W MTD YTD LTD

 | Daily |  | Customer Type | Transaction Count
 | PURCHASE TVOD |  | RESIDENTIAL | 26
 | PURCHASE TVOD |  | SLINGSHOT | 2
 | Weekly |  | Customer Type | Transaction Count
 | PURCHASE TVOD |  | RESIDENTIAL | 179
 | PURCHASE TVOD |  | SLINGSHOT | 28
 | PURCHASE TVOD |  | ZERO $ STB | 2
 | MTD |  | Customer Type | Transaction Count
 | PURCHASE TVOD |  | RESIDENTIAL | 816
 | PURCHASE TVOD |  | SLINGSHOT | 149
 | PURCHASE TVOD |  | ZERO $ STB | 6
 | Transaction Type |  | Customer Type | Transaction Count
 | PURCHASE TVOD |  | EMPLOYEE | 3
 | PURCHASE TVOD |  | RESIDENTIAL | 4047
 | PURCHASE TVOD |  | SLINGSHOT | 996
 | PURCHASE TVOD |  | ZERO $ STB | 8
 | Transaction Type |  | Customer Type | Transaction Count
 | PURCHASE TVOD |  | EMPLOYEE | 13
 | PURCHASE TVOD |  | RESIDENTIAL | 8393
 | PURCHASE TVOD |  | SLINGSHOT | 1428
 | PURCHASE TVOD |  | ZERO $ STB | 8
 |  | Transaction Type | Customer Type | Transaction Count
 |  | PURCHASE TVOD | EMPLOYEE | 13
 |  | PURCHASE TVOD | RESIDENTIAL | 8393
 |  | PURCHASE TVOD | SLINGSHOT | 1428
 |  | PURCHASE TVOD | ZERO $ STB | 8
Spreadsheet: 288226d1389126212-conversion-horizontal-grouped-data-to-vertical-separated-data-book1_ckeil_2
Sheet: Sheet1

INPUT
BOB | RED | one | three | six
BOB | BLUE | one
SAM | RED | two | four
SAM | ORANGE | one
JESS | BLUE | two
JESS | GREEN | four | six | seven
OUTPUT
BOB | RED | one
BOB | RED | three
BOB | BLUE | six
SAM | RED | two
SAM | RED | four
SAM | ORANGE | one
JESS | BLUE | two
JESS | GREEN | four
JESS | GREEN | six
JESS | GREEN | seven
Spreadsheet: 770467d1646091230-need-help-solving-this-sumif-scenario-sample-data
Sheet: SAMPLE

 |  |  | NBM |  |  |  | MBMS |  |  |  | NBIS |  |  |  | DPIS
 |  |  | ColumnName | Value |  |  | ColumnName | Value |  |  | ColumnName | Value |  |  | ColumnName | Value
 |  |  | 0005 | 15 |  |  | 0990 | 2 |  |  | 0005 | 17 |  |  | 0005 | 10
 |  |  | 0006 | 5 |  |  | 0006 | 30 |  |  | 0006 | 20 |  |  | 0006 | 15
Helper Tables | >>>>>>>>>>>>> |  | 0007 | 8 |  |  | 0025 | 20 |  |  | 0017 | 5 |  |  | 0015 | 8
 |  |  | 0010 | 10 |  |  | 0200 | 18 |  |  | 0032 | 10 |  |  | 0017 | 4
 |  |  | 0015 | 5 |  |  | 0135 | 30 |  |  | 0050 | 10 |  |  | 0032 | 12
 |  |  | 0017 | 4 |  |  |  |  |  |  | 0053 | 6 |  |  | 0035 | 15
 |  |  | 0020 | 6 |  |  |  |  |  |  | 0070 | 7 |  |  | 0050 | 3
 |  |  | 0030 | 10 |  |  | Total Pecent |  |  |  | 0135 | 15 |  |  | 0053 | 6
 |  |  | 0032 | 5 |  |  |  |  |  |  | 0200 | 5 |  |  | 0060 | 16
 |  |  | 0040 | 6 |  |  |  |  |  |  | 0990 | 5 |  |  | 0070 | 6
 |  |  | 0050 | 8 |  |  |  |  |  |  |  |  |  |  | 0135 | 5
 |  |  | 0053 | 4 |  |  |  |  |  |  | Total Pecent
 |  |  | 0070 | 5 |  |  |  |  |  |  |  |  |  |  | Total Pecent
 |  |  | 0081 | 2
 |  |  | 0082 | 2
 |  |  | 0135 | 3 |  |  |  | LEGEND | VALUE
 |  |  | 0990 | 2 |  |  |  | COMP | FULL VALUE
 |  |  |  |  |  |  |  | PEND | 0.5
 |  |  | Total Percentage |  |  |  |  | OUT | 0
 |  |  |  |  |  |  |  | BLANK | 0
 | The table below consist of ALL the columnName, but not all Type will utilize every columnName. The helper table for those [NAME] are listed below with the value. The ColumnName, although same, will have different value based on Type. Assuming all ColumnName are followed and COMP, they should equate to 100%
 | TABLE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | What I want to achieve
 | Type | Code# | 0005 | 0006 | 0007 | 0010 | 0015 | 0017 | 0020 | 0030 | 0032 | 0040 | 0050 | 0053 | 0070 | 0081 | 0082 | 0135 | 0990 | 0035 | 0060 | 0025 | 0200 | Total %
 | NBM | a | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP | COMP |  |  |  |  | 100
 | NBM | b | OUT | PEND | COMP | PEND | COMP | OUT | OUT | OUT | PEND | PEND | OUT | COMP | COMP | COMP | OUT | OUT |  |  |  |  |  | 37
 | MBMS | c |  | COMP |  |  |  |  |  |  |  |  |  |  |  |  |  | COMP | COMP |  |  | COMP | COMP | 100
 | MBMS | d |  | OUT |  |  |  |  |  |  |  |  |  |  |  |  |  | PEND | COMP |  |  | OUT | PEND | 26
 | NBIS | e | COMP | COMP |  |  |  | COMP |  |  | COMP |  | COMP | COMP | COMP |  |  | COMP | COMP |  |  |  | COMP | 100
 | NBIS | f | PEND | PEND |  |  |  | OUT |  |  | OUT |  | COMP | COMP | OUT |  |  | PEND | PEND |  |  |  | COMP | 49.5
 | DPIS | g | COMP | COMP |  |  | COMP | COMP |  |  | COMP |  | COMP | COMP | COMP |  |  | COMP |  | COMP | COMP |  |  | 100
 | DPIS | h | PEND | OUT |  |  | PEND | COMP |  |  | OUT |  | PEND | COMP | COMP |  |  | OUT |  | PEND | PEND |  |  | 47
 | OTHER | i
Spreadsheet: f0c043dd-db3f-45d1-b06f-9acdbcc48d51
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
FNAD | Test | FNAD | Nadolol, Serum/Plasma | Nadolol | High Performance Liquid Chromatography/Tandem Mass Spectrometry (LC-MS/MS) | EDTA (lavender-top) tube: EDTA OR |  |  | 1 | mL | Submit only 1 of the following specimens.  Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 1 mL of serum refrigerated in a plastic vial.   [NAME] blood in a lavender-top (EDTA) or [NAME] top tube(s). ([NAME] tube is not acceptable.) Spin down and send 1 mL of EDTA plasma refrigerated in a plastic vial. | 0.4 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Reporting limit determined each analysis   Synonym(s): Corgard   Mean steady-state plasma levels following a daily regimen:   80 mg:	  26 - 36 ng/mL  160 mg:	  52 - 74 ng/mL  320 mg:	154 - 191 ng/mL      Test Performed by:	NMS Labs 			3701 Welsh Road 			PO Box 433A 			Willow Grove, PA 19090-0437 | Tuesday and Thursday | 2 days | 4 - 7 days | 1 | 83789 |  |  |  |  | NMS Labs
FNAD | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 30 days
FNAD | Result | Z1430 | Nadolol | Nadolol | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 12406-5
FNAD | Result | Z1867 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 690136d1596888277-unique-list-of-entries-sample-49-ans
Sheet: Data

[NAME] for July  2020
Sl No | Descriptions |  |  |  |  |  | Qty | Unit | Rate | Amount | MPL NO | Procurment Issued Date | PO Number | PO Issued date | Expected date | Vendor details | Contact details | Qty Received | Invoice Detail | Received Date | Po Status Open or Close | Credit terms | Payment Status | Remarks
 | Product | Make | Size | Code no | Shade | Thickness
1 | Laminate | [NAME] | 8x4 |  |  | 1mm | 92 | nos | 995 |  |  | 1.7.20 | 45 | 3.7.20 | 4.7.20 | [NAME]
2 | Laminate | [NAME] | 8x4 |  |  | 1 mm | 18 | nos | 995 |  |  | 1.7.20 | 45 | 3.7.20 | 3.7.20 | [NAME]
3 | Laminate | [NAME] | 8x4 |  |  | 0.8mm | 1000 | nos | 415 |  |  | 1.7.20 | 46 | 3.7.20 | 3.7.20 | Lords Distributors
4 | Laminate | Green | 8x4 |  |  | 1 mm | 20 | nos | 1055 |  |  | 1.7.20 | 46 | 3.7.20 | 4.7.20 | Green Marketing
5 | Laminate | Green | 8x4 |  |  | 1 mm | 6 | nos | 1055 |  |  | 1.7.20 | 46 | 3.7.20 | 4.7.20 | Green Marketing
6 | Laminate | Green | 8x4 |  |  | 1 mm | 37 | nos | 1055 |  |  | 1.7.20 | 46 | 3.7.20 | 4.7.20 | Green Marketing
7 | Hinges | Hafele |  |  |  | 0 crank | 40 | sets | 223.25 |  |  | 1.7.20 | 47 | 3.7.20 | 6.6.20 | Industry Lane
8 | Hinges | Hafele |  |  |  | 8 crank | 20 | sets | 224.66 |  |  | 1.7.20 | 47 | 3.7.20 | 6.6.20 | Industry Lane
9 | Laminate | [NAME] | 8x4 |  |  | 1 mm | 4 | nos | 995 |  |  | 1.7.20 | 48 | 3.7.20 | 6.6.20 | [NAME]
10 | Comm ply | [NAME] | 8x4 |  |  | 16 mm | 200 | nos | 1600 |  |  | 1.7.20 | 49 | 3.7.20 | 7.7.20 | EcoWoods
11 | Comm ply | [NAME] | 8x4 |  |  | 6 mm | 50 | nos | 800 |  |  | 1.7.20 | 49 | 3.7.20 | 7.7.20 | EcoWoods
12 | Comm ply | [NAME] | 8x4 |  |  | 12 mm | 50 | nos | 1120 |  |  | 1.7.20 | 49 | 3.7.20 | 7.7.20 | EcoWoods
13 | Laminate | Green | 8x4 |  |  | 1 mm | 4 | nos | 1055 |  |  | 3.7.20 | 50 | 3.7.20 | 5.7.20 | Green Marketing
14 | [NAME] | Rehau | 22x0.8 |  |  | 2 mm | 606 | mtrs | 9.05 |  |  | 3.7.20 | 51 | 3.7.20 | 6.7.20 | [NAME]
15 | [NAME] | Rehau | 22x2 |  |  | 2 mm | 456 | mtrs | 18 |  |  | 3.7.20 | 51 | 3.7.20 | 6.7.20 | [NAME]
16 | MDF |  |  |  |  | 17 mm | 163 | sq ft | 150 |  |  | 3.7.20 | 52 | 3.7.20 | 6.7.20 | Sri Maruthi Plywoods
17 | Laminate | Green | 8x4 |  |  | 1mm | 9 | nos | 1055 |  |  | 8.7.20 | 39 | 8.7.20 | 8.7.20 | Green Marketing