tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 275127d1383334529-vlookup-with-multiple-sheets-customers
Sheet: Calendar

Date |  |  | Customer
2013-11-01 00:00:00 |  |  | APS
2013-11-02 00:00:00 |  |  | #N/A
2013-11-03 00:00:00 |  |  | #N/A
2013-11-04 00:00:00 |  |  | hello
2013-11-05 00:00:00 |  |  | #N/A
2013-11-06 00:00:00 |  |  | #N/A
2013-11-07 00:00:00 |  |  | #N/A
2013-11-08 00:00:00 |  |  | #N/A
2013-11-09 00:00:00 |  |  | #N/A
2013-11-10 00:00:00 |  |  | #N/A
2013-11-11 00:00:00 |  |  | #N/A
2013-11-12 00:00:00 |  |  | #N/A
2013-11-13 00:00:00 |  |  | #N/A
2013-11-14 00:00:00 |  |  | #N/A
2013-11-15 00:00:00 |  |  | #N/A
2013-11-16 00:00:00 |  |  | #N/A
2013-11-17 00:00:00 |  |  | #N/A
2013-11-18 00:00:00 |  |  | #N/A
2013-11-19 00:00:00 |  |  | #N/A
2013-11-20 00:00:00 |  |  | #N/A
2013-11-21 00:00:00 |  |  | #N/A
2013-11-22 00:00:00 |  |  | #N/A
2013-11-23 00:00:00 |  |  | #N/A
2013-11-24 00:00:00 |  |  | #N/A
2013-11-25 00:00:00 |  |  | #N/A
2013-11-26 00:00:00 |  |  | #N/A
2013-11-27 00:00:00 |  |  | #N/A
2013-11-28 00:00:00 |  |  | #N/A
2013-11-29 00:00:00 |  |  | #N/A
2013-11-30 00:00:00 |  |  | #N/A
2013-12-01 00:00:00 |  |  | #N/A
Spreadsheet: 70256d1271030793-filter-if-row-contains-only-showonlyrowsdevelopment
Sheet: Sheet1

Col A | Col B | Col C
development | development
development | development | Development
development
UAT | Development | development
Development
Production | development | development
development | contingency | development
development |  | development
development | development | development
Development | Test | development
development | development | development
 |  | development
development | development | development | development | Development
development | development | development
development | development
Test | development | development | development
development | UAT | contingency
development | DEVELOPMENT | development
 | development | development
development | 123 | development
development | development | development
development | development | development
Development | development | Test
 | development | development
development | development | development
Spreadsheet: 14b89298-10c2-4bc8-9497-71fb8af19b40
Sheet: Degrees

C& I meeting Date | New Degrees
2011-11-09 00:00:00 | Kineasology | Degree Modofications | Modification Details | Degrees Dropped | Effective Date | Approved by AA | Date BOT approved | CO's Approval Date
2012-04-25 00:00:00 | N/A |  |  |  | / | 2011-12-07 00:00:00 | 2012-02-27 00:00:00
 |  | CHOREOGRAPHIC studies and [NAME] | Dance 131 and 132 deleted from the degree | N/A | Fall 2012 | 2012-05-02 00:00:00 | N/A | ??
 |  |  |  | N/A
Spreadsheet: 695548d1600272412-cash-flow-workbook-is-sumifs-the-best-function-sample
Sheet: Cash Flow

September
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Income | Expenses | Balance
0 | 0 | 1
 |  |  |  | 1 |  |  |  |  | 125
October
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
November
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1
 |  | 1 |  | 3
December
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  |  |  | 1
Monthly Income
Item | Amount | Per Week
Work | 4000
Rental | 1200
Cell Phone | 40
Monthly Expenses
Item | Due Date | Amount
Gym | 1 | 50
Cell phone | 6 | 100
Mortgage | 8 | 1500
Insurance | 15 | 150
Loan | 20 | 200
Car | 21 | 300
Utilities | 25 | 100
TV/Internet | 30 | 75
Spreadsheet: 693870d1599193130-summing-multiple-arrays-with-multiple-criteria-inventory_tracker_example
Sheet: Calendar

 |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
Week # | Date | Brand | Grain | Brand | Grain | Brand | Grain | Brand | Grain | Brand | Grain | Brand | Grain
Week 36 | 2020-08-23 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2020-08-24 00:00:00 | Beer 1 | Grain - Silo 2 | Beer 2 | Grain - Bags | - | - | - | - | - | - | - | -
 | 2020-08-25 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2020-08-26 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2020-08-27 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2020-08-28 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
 | 2020-08-29 00:00:00 | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 455911d1460560603-help-with-if-functions-for-inventory-or-maybe-different-function-completely-copy-of-corn-inventory
Sheet: Corn Inventory

 |  |  |  |  |  |  |  | Date | 2015-06-26 00:00:00 | 2015-08-05 00:00:00 | 2015-09-09 00:00:00 | 2015-09-14 00:00:00 | 2015-10-06 00:00:00 | 2015-10-12 00:00:00 | 2015-11-05 00:00:00 | 2015-11-11 00:00:00 | 2015-12-02 00:00:00 | 2015-12-22 00:00:00 | 2016-01-18 00:00:00 | 2016-02-01 00:00:00 | 2016-02-10 00:00:00 | 2016-02-15 00:00:00 | 2016-02-15 00:00:00
 |  |  |  |  |  |  |  | [NAME]/delivery | 107.1428571428571 | 138.3928571428571 | 147.3214285714286 | 28.57142857142857 | 57.14285714285715 | 151.7857142857143 | 156.25 | 60.71428571428572 | 160.7142857142857 | 160.7142857142857 | 160.7142857142857 | 160.7142857142857 | 32.14285714285715 | 128.5714285714286 | 96.42857142857143
 |  | [NAME] | Bu. Left ?? | Price per bu | Price
2015-05-16 00:00:00 | [NAME] | 1500 |  | 3.5
2015-05-16 00:00:00 | [NAME] | 143.92 |  | 3.39
2015-07-03 00:00:00 | [NAME] | 482 |  | 3.5
2015-08-13 00:00:00 | [NAME] | 585 |  | 3.25
 |  |  |  |  |  |  |  | Cost of Delivery
 |  |  |  |  |  |  |  | Date | Inventory | [NAME]/delivery | price | Cost of Delivery
Spreadsheet: 826058d1681755091-combining-and-looking-up-unique-fields-s666-pq-combining-and-looking-up-unique-fields-4-1-
Sheet: Sheet1

Dealer Number | Reinsurance Company Name | Reinsurance Type
[NAME] | DA0723 Reinsurance Company, Ltd.
[NAME] | DHW No. 4 Reinsurance Company, Ltd.
[NAME] | DHW Reinsurance Company, Ltd.
[NAME] | DHW Squared Reinsurance Company, Ltd.
[NAME] | Preston Group 20% Share GS Re 2
TPE03581394DAR | DA0723 Reinsurance Company, Ltd.
TPE03581394DAR | DHW No. 4 Reinsurance Company, Ltd.
TPE03581394DAR | DHW Reinsurance Company, Ltd.
TPE03581394DAR | DHW Squared Reinsurance Company, Ltd.
TPE03581394DAR | Preston Group 20% Share GS Re 2
Spreadsheet: 493410d1481710997-insert-lines-with-formula-lines-and-formula
Sheet: Folha1

 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
Spreadsheet: 683243d1592575508-how-to-match-duplicate-unique-values-in-two-columns-example-jackdanes-
Sheet: Sheet1

Keyword list a | Keyword list b |  | Duplicates list a | Duplicates list b
trainers | buy trainers
blue trainers | buy trainers
blue sport trainers | trainers
buy trainers | blue sport trainers
 | running trainers
 | trainers for sale
Spreadsheet: 860288d1708442018-dynamic-dropdown-list-based-on-the-value-entered-in-the-adjacent-cell-andrews_sample-filtered-fixed-again
Sheet: EmplFilters

 | Employee |  | EMP0024 | EMP0025 | EMP0026
 | Array location
 | Array:
 |  | Berlin |  | New York | Oslo
 |  | New Delhi |  | Beijing | Wengen
 |  |  |  | Mumbai
Spreadsheet: 872389d1718790265-sort-and-transpose-paradiser-sort-and-transpose-aligw
Sheet: Sheet2

Date | Particulars | Voucher Type | Entry No. | Ref. No. | ID | Value | Gross | Local VDS |  |  |  |  | USD
2023-08-18 00:00:00 | Kaline Trading Company Pvt.Ltd | Cont | JVN00203 | [NAME] | 609543911 |  | 1351.76 | 155.51 | Repair & Maintance-Electricals | 1196.25
2023-08-18 00:00:00 | Mata Hardware | Cont | [NAME] | Ma-2 | 300069242 |  | 776.83 | 89.37 | Repair & Maintenance Building | 687.46
2023-08-18 00:00:00 | Phonex Machinery & Tools | Cont | [NAME] | Ma-5 | 104224739 |  | 1988.8 | 228.8 | Combule | 1760
2023-08-20 00:00:00 | Elastics Lights & Electric Centre | Cont | JVN00211 | Ma-9 | 301647984 |  | 1887.1 | 217.1 | Repair & Maintance-Electricals | 1670
2023-08-20 00:00:00 | Mother dairy | Cont | JVN00212 | Ma-10 | 302009099 |  | 5190.02 | 597.08 | Combule | 4592.94
2023-08-20 00:00:00 | [NAME] | Cont | JVN00213 | Ma-11 | 300072334 |  | 1074.63 | 123.63 | Combule | 951
2023-08-20 00:00:00 | Nividea | Cont | [NAME] | Ma-12 | 305501703 |  | 10341.76 | 1189.76 | Repair and Maintenance-Plant and [NAME] | 9152
2023-08-18 00:00:00 | Myslef Freight Services Pvt Ltd | Cont | JVN00301 | [NAME] | [PHONE] |  | 586.22 | 67.44 | MBL MC 003ILUI230803002 | 518.78 | Jamal MC 57132 | 551
2023-08-18 00:00:00 | [NAME] | Cont | JVN00331** | Ma-114 | 609544808 |  | 52418.38 | 6111.56 | Freight [NAME] | 47012 | USD Payable-Int. @1.5% |  | -705.18
 | Kaline Trading Company Pvt.Ltd | Cont | JVN00203 | [NAME] | 609543911 | 0 | 1351.76 | 155.51 | Repair & Maintance-Electricals | 1196.25
2023-08-18 00:00:00 | Mata Hardware | Cont | [NAME] | Ma-2 | 300069242 | 0 | 776.83 | 89.37 | Repair & Maintenance Building |  | -687.46
2023-08-18 00:00:00 | Phonex Machinery & Tools | Cont | [NAME] | Ma-5 | 104224739 | 0 | 1988.8 | 228.8 | Combule | 1760
2023-08-20 00:00:00 | Elastics Lights & Electric Centre | Cont | JVN00211 | Ma-9 | 301647984 | 0 | 1887.1 | 217.1 | Repair & Maintance-Electricals | 1670
2023-08-20 00:00:00 | Mother dairy | Cont | JVN00212 | Ma-10 | 302009099 | 0 | 5190.02 | 597.08 | Combule | 4592.94
2023-08-20 00:00:00 | [NAME] | Cont | JVN00213 | Ma-11 | 300072334 | 0 | 1074.63 | 123.63 | Combule | 951
2023-08-20 00:00:00 | Nividea | Cont | [NAME] | Ma-12 | 305501703 | 0 | 10341.76 | 1189.76 | Repair and Maintenance-Plant and [NAME] | 9152
2023-08-18 00:00:00 | Myslef Freight Services Pvt Ltd | Cont | JVN00301 | [NAME] | [PHONE] | 0 | 586.22 | 67.44 | MBL MC 003ILUI230803002 | 518.78 |  | Jamal MC 57132 | 551
2023-08-18 00:00:00 | [NAME] | Cont | JVN00331** | Ma-114 | 609544808 | 0 | 52418.38 | 6111.56 | Freight [NAME] | 47012 |  | USD Payable-Int. @1.5% |  | -705.18
Spreadsheet: 66612d1267228355-multiple-page-layout-in-worksheet-print
Sheet: Sheet1

aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa | aaaaaa
Spreadsheet: 767158d1644318617-need-formula-to-spread-depreciation-throughout-the-period-as-per-start-and-end-date-test
Sheet: Sheet1

 |  |  |  |  | 1 | 31 |  |  |  |  | 31
Contract Item Term | Start Date | End Date | Days | Amount royalties | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00
12 | 2021-06-30 00:00:00 | 2022-06-29 00:00:00 |  | 5438.8995
1 | 2021-06-30 00:00:00 | 2021-06-30 00:00:00 |  | 60995.361
12 | 2021-06-30 00:00:00 | 2022-06-29 00:00:00 |  | 15248.841
12 | 2021-12-01 00:00:00 | 2022-11-30 00:00:00 |  | 11379.552
12 | 2021-12-01 00:00:00 | 2022-11-30 00:00:00 |  | 3108.747
1 | 2021-12-01 00:00:00 | 2021-12-01 00:00:00 |  | 56897.757
12 | 2021-12-31 00:00:00 | 2022-12-30 00:00:00 |  | 6873.929999999999
1 | 2021-12-31 00:00:00 | 2021-12-31 00:00:00 |  | 76758.885
12 | 2021-12-31 00:00:00 | 2022-12-30 00:00:00 |  | 15351.777
Spreadsheet: 1e00ac37-02a1-4947-b804-82ae323f2117
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
CCRYP | Test | CCRYP | Cryptococcus Antigen Screen, Spinal Fluid | Cryptococcus Ag Screen, CSF | Enzyme Immunoassay (EIA) |  |  |  |  |  | Container/Tube: Sterile vial [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday through Friday; 11 a.m., Saturday, Sunday; 1 p.m. | Same day/1 day | 2 days | 1 | 87327 |  |  |  |  | Rochester
CCRYP | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
CCRYP | Result | 86166 | Cryptococcus Ag Screen, CSF | Cryptococcus Ag Screen, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29896-8 | Cryptococcus sp Ag:ACnc:Pt:CSF:Ord:EIA
CCRYP | [NAME] | [NAME] | [NAME], [NAME] | Cryptococcus Ag, CSF | Latex Agglutination | [NAME], round-bottom, plastic vial: ScwRBPl |  |  |  |  | Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.25 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative If positive, results are titered. | Monday through Sunday; 2 p.m. | Same day/1 day | 2 days | 1 | 86403 |  |  | No | Yes
[NAME] | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
[NAME] | Result | 81540 | Cryptococcus Ag, CSF | Cryptococcus Ag, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38390-1 | Cryptococcus neoformans Ag:ACnc:Pt:CSF:[NAME]:
Spreadsheet: 810406d1671735879-search-2-columns-based-on-text-criteria-to-excel-rentable
Sheet: TO EXCEL-RENTABLE

LEVEL 1 | COMMERCIAL | 14335
LEVEL 1 | COMMERCIAL | 3553
LEVEL 1 | SHARED AREA | 1694
LEVEL 1 | SHARED AREA | 1622
LEVEL 1 | SHARED AREA | 240
LEVEL 1 | RESIDENTIAL | 8095
LEVEL 1 | SHARED AREA | 972
LEVEL 1 | RESIDENTIAL | 293
LEVEL 1 | RESIDENTIAL | 351
LEVEL 1 | RESIDENTIAL | 455
LEVEL 2 | COMMERCIAL PARKING | 18259
LEVEL 2 | RESIDENTIAL | 5196
LEVEL 2 | RESIDENTIAL PARKING | 10780
LEVEL 2 | SHARED AREA | 1019
LEVEL 2 | RESIDENTIAL | 917
LEVEL 2 | RESIDENTIAL | 126
LEVEL 2 | RESIDENTIAL | 153
LEVEL 2 | COMMERCIAL | 186
LEVEL 3 | RESIDENTIAL PARKING | 44225
LEVEL 3 | RESIDENTIAL | 153
LEVEL 3 | RESIDENTIAL | 263
LEVEL 3 | RESIDENTIAL | 917
LEVEL 3 | RESIDENTIAL | 6531
LEVEL 4 | RESIDENTIAL PARKING | 44637
LEVEL 4 | RESIDENTIAL | 153
LEVEL 4 | RESIDENTIAL | 263
LEVEL 4 | RESIDENTIAL | 917
LEVEL 4 | RESIDENTIAL | 6124
LEVEL 5 | RESIDENTIAL PARKING | 44637
LEVEL 5 | RESIDENTIAL | 153
LEVEL 5 | RESIDENTIAL | 263
LEVEL 5 | RESIDENTIAL PARKING | 917
LEVEL 5 | RESIDENTIAL | 6120
LEVEL 6 | RESIDENTIAL PARKING | 44637
LEVEL 6 | RESIDENTIAL | 153
LEVEL 6 | RESIDENTIAL | 263
LEVEL 6 | RESIDENTIAL | 917
LEVEL 6 | RESIDENTIAL | 6120
LEVEL 7 | RESIDENTIAL PARKING | 44523
LEVEL 7 | RESIDENTIAL | 231
LEVEL 7 | RESIDENTIAL | 263
LEVEL 7 | RESIDENTIAL | 917
LEVEL 7 | RESIDENTIAL | 6156
LEVEL 8 | RESIDENTIAL | 15491
LEVEL 8 | RESIDENTIAL | 164
LEVEL 8 | RESIDENTIAL | 252
LEVEL 8 | RESIDENTIAL | 252
LEVEL 8 | RESIDENTIAL | 252
LEVEL 8 | RESIDENTIAL | 636
LEVEL 8 | RESIDENTIAL | 252
LEVEL 8 | RESIDENTIAL | 252
Spreadsheet: 1cdbc2a2-e47e-4ba6-9baf-fdce7d4d8c89
Sheet: Sheet1

503213 | 2
503246 | 25
503262 | 4
503393 | 27
503429 | 15
503469 | 12
503471 | 22
503472 | 18
503479 | 13
503486 | 6
503488 | 16
503494 | 21
503501 | 4
503506 | 1
503507 | 24
503509 | 9
503517 | 26
503519 | 31
503524 | 16
503531 | 8
503533 | 19
503534 | 11
503538 | 7
503541 | 30
503544 | 29
503545 | 14
503546 | 28
503553 | 3
503556 | 20
503558 | 10
503565 | 23
Spreadsheet: 669314d1585315639-sort-ranges-test
Sheet: Data

ANDERSEN, [NAME] | ANDERSEN, [NAME] | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Yearly TOTAL
 | High Compliance | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 6
 | Compliant |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 | Partial Compliance | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 | Low Compliance |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Non-Compliant |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL CALLS | 4 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | TOTAL WEIGHT | 35 | 54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MONTHLY SCORE | 8.75 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | QUARTERLY SCORE | Q1 |  | 8.9 | Q2 |  | 0 | Q3 |  | 0 | Q4 |  | 0 | 8.9
SMITH, [NAME] | SMITH, [NAME] | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Yearly TOTAL
 | High Compliance | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 6
 | Compliant |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 | Partial Compliance | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 | Low Compliance |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Non-Compliant |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL CALLS | 4 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | TOTAL WEIGHT | 35 | 54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MONTHLY SCORE | 8.75 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | QUARTERLY SCORE | Q1 |  | 8.9 | Q2 |  | 0 | Q3 |  | 0 | Q4 |  | 0 | 8.9
SMITH, [NAME] | SMITH, [NAME] | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Yearly TOTAL
 | High Compliance | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 6
 | Compliant |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 | Partial Compliance | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 | Low Compliance |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Non-Compliant |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL CALLS | 4 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | TOTAL WEIGHT | 35 | 54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MONTHLY SCORE | 8.75 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | QUARTERLY SCORE | Q1 |  | 8.9 | Q2 |  | 0 | Q3 |  | 0 | Q4 |  | 0 | 8.9
Jones, [NAME] | Jones, [NAME] | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Yearly TOTAL
 | High Compliance | 3 | 3 |  |  |  |  |  |  |  |  |  |  | 6
 | Compliant |  | 3 |  |  |  |  |  |  |  |  |  |  | 3
 | Partial Compliance | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
 | Low Compliance |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Non-Compliant |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | TOTAL CALLS | 4 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10
 | TOTAL WEIGHT | 35 | 54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | MONTHLY SCORE | 8.75 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | QUARTERLY SCORE | Q1 |  | 8.9 | Q2 |  | 0 | Q3 |  | 0 | Q4 |  | 0 | 8.9
Spreadsheet: 125471d1319048987-certain-ranges-determining-a-value-vlookup_partialmatchexample
Sheet: Sheet1

Ceiling | Rating |  | value | rating
0 | 1 |  | 10
1000000 | 2 |  | 5999999
6000000 | 3 |  | 5999999
14000000 | 4 |  | 6000000
25000000 | 5 |  | 13999999
 |  |  | 14000000
 |  |  | 24999999
 |  |  | 25000000
 |  |  | 25000001
 |  |  | 30000000
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.24.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-24 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 3 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0
 | 4TH FL | 38 | 22 | 18 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 16 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 21 | 0 | 5 | 1 | 0 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 1 | 1 | 0 | 1 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 0 | 0 | 1 | 1 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-24 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 17 | 0 | 4 | 0 | 3 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 18 | 0 | 5 | 2 | 1 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 4 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 2 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 6 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: eb0e6627-7506-4746-8c67-b6a46de8a675
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
HL58O | Test | HL58O | HLA-B*5801 Genotype, Allopurinol Hypersensitivity, Saliva | HLA-B 5801, Allopurinol, Saliva | Qualitative allele-specific real-time Polymerase Chain Reaction (PCR)  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple saliva genotype tests can be performed on a single specimen after a single extraction. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.  Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions:  1. Fill to tube line. 2. Send specimen in original container per kit instructions. Forms: 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. | 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday and Thursday | 1 day | 8 days | 1 | 81381 |  |  |  |  | Rochester
HL58O | [NAME] | SALIVA | Saliva |  |  |  | Ambient
HL58O | Result | 35104 | HLA-B 5801 Saliva Result | HLA-B 5801 Saliva Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HL58O | Result | 35105 | HLA-B 5801 Saliva Interpretation | HLA-B 5801 Saliva Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2 | Clinical cytogeneticist review:Imp:Pt:XXX:Nar:
HL58O | Result | 35106 | Reviewed by | Reviewed by | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: john_griffith__15901__11_13_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22 | 65 | 75 | 70.7 | 81.6 | 1.05 | 2001-11-13 11:26:00
 | CL F2 | 22 | 260 | 270 | 51 | 53 | 0.72 | 2001-11-13 11:26:00
 | CL G2 | 22 | 370 | 385 | 50.8 | 52.8 | 0.72 | 2001-11-13 11:26:00
 | CL H2 | 22 | 440 | 455 | 50.3 | 52 | 0.71 | 2001-11-13 11:26:00
 | CL J2 | 22 | 480 | 495 | 48.1 | 49.6 | 0.68 | 2001-11-13 11:26:00
 | CL K2 | 22 | 530 | 540 | 47.3 | 48.2 | 0.66 | 2001-11-13 11:26:00
 | CL M2 | 22 | 545 | 560 | 44.9 | 46.1 | 0.63 | 2001-11-13 11:26:00
 | CL N2 | 22 | 560 | 580 | 42.7 | 44.2 | 0.6 | 2001-11-13 11:26:00
 | CL Q2 | 22 | 562 | 582 | 40.3 | 41.7 | 0.57 | 2001-11-13 11:26:00
 | CL U2 | 22 | 565 | 590 | 38.5 | 40.2 | 0.54 | 2001-11-13 11:26:00
 | [NAME] | 22 | 565 | 590 | 36.5 | 38.1 | 0.52 | 2001-11-13 11:26:00
 | CL X2 | 22 | 565 | 590 | 35 | 36.6 | 0.5 | 2001-11-13 11:26:00
 | [NAME] | 22 | 565 | 590 | 33.8 | 35.3 | 0.48 | 2001-11-13 11:26:00
 | CL M3 | 21.5 | 560 | 585 | 28.8 | 30.1 | 0.4 | 2001-11-13 11:26:00
 | CL Z3 | 21.5 | 560 | 585 | 25.5 | 26.7 | 0.35 | 2001-11-13 11:26:00