tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857032d1706120566-need-help-to-optimize-formula-for-automatic-spilling-1-spill-array-formula-02
Sheet: WIP

 | ID | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z |  |  |  |  | column | [NAME] |  |  | Expected Result as Spill Array
 | 1 | 18 | 2 | 2 | 3 | 0 | 2 | 1 | 2 | 1 | 3 | 1 | 2 | 1 | 3 | 26 | 2 | 0 | 22 | 0 | 22 | 2 | 32 | 2 | 4 | 2 | 2 |  |  |  |  | g,i |  |  |  |  | 1,1
 | 2 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 2 | 1 | 4 | 24 | 0 | 0 | 2 | 0 | 2 | 1 | 3 | 2 | 5 | 0 | 0 |  |  |  |  | h,i |  |  |  | h,i | 2,1
 | 3 | 13 | 2 | 2 | 222 | 0 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 24 | 0 | 2 | 2 | 0 | 2 | 1 | 3 | 1 | 5 | 0 | 2 |  |  |  |  | d,e,f |  |  |  | d,e,f | 3,0,2
 | 4 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 0 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  | d,e,g |  |  |  | d,e,g | 3,0,1
 | 5 | 15 | 2 | 2 | 3 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 2 | 1 | 22 | 1 | 4 | 2 | 0 |  |  |  |  | d,e,h |  |  |  | d,e,h | 3,0,2
 | 6 | 20 | 2 | 2 | 2 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 20 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  | d,g,h |  |  |  | d,g,h | 3,1,2
 | 7 | 15 | 2 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 1 | 2 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 2 | 4 | 2 | 0 |  |  |  |  | d,g,i |  |  |  | d,g,i | 3,1,1
 | 8 | 18 | 7 | 2 | 22 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | 0 | 1 | 3 | 21 | 2 | 0 | 2 | 0 | 0 | 0 | 22 | 1 | 4 | 2 | 0 |  |  |  |  | d,e,g,i |  |  |  | d,e,g,i | 3,0,1,1
 | 9 | 8 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 24 | 0 | 0 | 2 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 2 |  |  |  |  | e,f,g |  |  |  | e,f,g | 0,2,1
 | 10 | 14 | 2 | 2 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 12 | 0 | 2 | 22 | 0 | 2 | 1 | 22 | 2 | 3 | 0 | 2 |  |  |  |  | e,f,h |  |  |  | e,f,h | 0,2,2
 | 11 | 14 | 2 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 4 | 0 | 22 |  |  |  |  | e,f,i |  |  |  | e,f,i | 0,2,1
 | 12 | 18 | 2 | 0 | 22 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 28 | 2 | 0 | 2 | 0 | 2 | 1 | 32 | 2 | 5 | 2 | 2 |  |  |  |  | e,g,h |  |  |  | e,g,h | 0,1,2
 | 13 | 20 | 1 | 0 | 22 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 25 | 0 | 0 | 22 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 22 |  |  |  |  | e,g,i |  |  |  | e,g,i | 0,1,1
 | 14 | 24 | 2 | 2 | 222 | 0 | 22 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3 | 15 | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 22 |  |  |  |  | e,h,i |  |  |  | e,h,i | 0,2,1
 | 15 | 8 | 2 | 0 | 3 | 0 | 2 | 1 | 0 | 1 | 3 | 1 | 0 | 1 | 3 | 22 | 0 | 0 | 2 | 0 | 2 | 1 | 2 | 1 | 4 | 0 | 2 |  |  |  |  | f,g,h |  |  |  | f,g,h | 2,1,2
 | 16 | 18 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | 0 | 1 | 4 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 0
 | 17 | 22 | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 20 | 0 | 2 | 0 | 0 | 0 | 0 | 3 | 1 | 4 | 0 | 0
 | 18 | 24 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 5 | 0 | 3 | 2 | 5 | 21 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 1 | 4 | 0 | 0
 | 19 | 22 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 2 | 4 | 0 | 2 | 2 | 4 | 16 | 2 | 2 | 22 | 0 | 0 | 0 | 22 | 1 | 3 | 2 | 0
Spreadsheet: 067a4002-71e0-4d37-8743-f436c09f4771
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
CBL | Test | CBL | Blastomyces Antibody by Immunodiffusion, Spinal Fluid | Blastomyces Ab Immunodiffusion, CSF | Immunodiffusion | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 0.5 | mL | Container/Tube: Sterile vial [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative | Monday through Friday; 9:30 a.m. | 2 days | 5 days | 1 | 86612 |  |  |  |  | Rochester
CBL | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
CBL | Result | 15134 | Blastomyces Immunodiffusion (CSF) | Blastomyces Immunodiffusion (CSF) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51741-7 | Blastomyces [NAME]:ACnc:Pt:CSF:Ord:Immune diffusion
Spreadsheet: 166965d1341855253-excel-2007-calculations-on-a-cell-containing-hours-and-minutes-timesheetexample-bbs10r-oeldere-
Sheet: Sheet1

Whatever National Bank
Contractor Monthly Time Report
Consultant: |  | [NAME] |  |  |  |  |  |  |  | Time Period (mm/yy):04/09
 |  | Date
 | 2009-04-27 00:00:00 | 2009-04-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-30 00:00:00 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | 2009-05-03 00:00:00 | 2009-05-04 00:00:00 | 2009-05-05 00:00:00 | 2009-05-06 00:00:00 | 2009-05-07 00:00:00 | 2009-05-08 00:00:00 | 2009-05-09 00:00:00 | 2009-05-10 00:00:00 |  |  |  | Total
Start Time | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
End Time | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 |  |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00
Unbillable Time
Billable Time | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 0 | 0 |  |  |  | 80
Project #
 |  | Date
 |  | 2009-05-11 00:00:00 | 2009-05-12 00:00:00 | 2009-05-13 00:00:00 | 2009-05-14 00:00:00 | 2009-05-15 00:00:00 | 2009-05-16 00:00:00 | 2009-05-17 00:00:00 | 2009-05-18 00:00:00 | 2009-05-19 00:00:00 | 2009-05-20 00:00:00 | 2009-05-21 00:00:00 | 2009-05-22 00:00:00 | 2009-05-23 00:00:00 | 2009-05-24 00:00:00 |  |  | Total
Start Time |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
End Time |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 |  |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00
Unbilliabe Time |  | 02:00:00 | 01:00:00 | 00:45:00 | 1900-01-01 00:00:00
Billiable Time |  | 6.000000000000002 | 7 | 7.250000000000001 | 8 | 8 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 0 | 0 |  |  | 76.25
 |  |  |  |  |  |  |  |  |  |  |  | Total hours worked in month : |  |  |  |  |  | 156.25
Project #
 |  | Date
Spreadsheet: 700708d1603297791-if-formula-problems-parts-request-aging-master-base-year-1012020lkf
Sheet: Services Back-up

PR# | DATE PR RECEIVED | DATE PART ORDERED | DATE PART RECEIVED | VENDOR | [NAME] | QUANTITY | PRIORITY | [NAME] | NOTES
629117778 | 2020-10-01 00:00:00 | 2020-10-09 00:00:00 |  | Flux | HVAC Installation SOW | 1 | [NAME]
625636233 | 2020-10-01 00:00:00 | 2020-10-09 00:00:00 |  | Cascade | Electrical wiring for HVAC | 1 | [NAME]
725071965 |  |  |  |  | Troubleshoot fuel leak and install fuel pumps | 1 | [NAME]
386337098 |  |  |  |  | [NAME] and Install | 1 | [NAME]
776630801 | 2020-10-05 00:00:00 | 2020-01-07 00:00:00 |  | UPS | Shipping of lube oil samples | 1 | [NAME]
793800830 | 2020-10-13 00:00:00 | 2020-10-13 00:00:00 |  |  | Troubleshoot emergency shut down of STBD MDE on board the Sea Fighter | 1 | Urgent/Mission Critical
798686702 | 2020-10-15 00:00:00 | 2020-10-21 00:00:00 |  | [NAME] | Fixed fee level of effort for October and November 2020 while waiting for the teaming agreement approval. | 1 | Urgent/Mission Critical
797256762 | 2020-10-20 00:00:00 |  |  |  | VDR Annual Performance Test | 1 | Urgent/Mission Critical
Spreadsheet: 745497d1629968925-input-date-based-on-two-criteria-example
Sheet: List

Code | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Country | Column1 | Column2 | Last Entry Date
MARS0002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Czech Republic
MARS0002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hungary
MARS0002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sweden
MARS0002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Russia
MARS0002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South Africa
Spreadsheet: 41853d1240397264-sumproduct-double-criteria-defect-data
Sheet: Master Data

 |  |  |  |  |  | DAILY DEFECT REPORT
No | INSPECT BY | CON / TYPE | PROBLEMS |  | SECTION | DATE | MODEL [NAME] |  | DEFECT REASON |  |  | DEFECT ACTION |  |  |  | CAUSE BY |  |  | QTY
1 |  |  | Defect 1 |  | PI | 2009-04-13 00:00:00 |  |  | ECO,wrong key in 7z-010003-778 (b8) |  |  |  |  |  |  |  |  |  | 1
2 |  |  | Defect 2 |  | QA | 2009-04-22 00:00:00 |  |  | bottom cabinet dented |  |  |  |  |  |  |  |  |  | 1
3 |  |  | Defect 3 |  | PI | 2009-04-22 00:00:00 |  |  | button not smooth |  |  |  |  |  |  |  |  |  | 1
4 |  |  | Defect 1 |  | QA | 2009-04-22 00:00:00 |  |  | pcb no.not appear at printing sample |  |  |  |  |  |  |  |  |  | 1
5 |  |  | Defect 2 |  | PI | 2009-04-22 00:00:00 |  |  | printing wrinkle at back feed |  |  |  |  |  |  |  |  |  | 1
6 |  |  | Defect 3 |  | PI | 2009-04-13 00:00:00 |  |  | printing not balance |  |  |  |  |  |  |  |  |  | 1
7 |  |  | Defect 1 |  | QA | 2009-04-21 00:00:00 |  |  | partial cut printing wrinkle |  |  |  |  |  |  |  |  |  | 1
8 |  |  | Defect 2 |  | PI | 2009-04-22 00:00:00 |  |  | printing wrinkle at partial cut |  |  |  |  |  |  |  |  |  | 1
9 |  |  | Defect 3 |  | QA | 2009-04-22 00:00:00 |  |  | printing wrinkle at partial cut |  |  |  |  |  |  |  |  |  | 1
10 |  |  | Defect 1 |  | PI | 2009-04-20 00:00:00 |  |  | transfer ng (B8) |  |  |  |  |  |  |  |  |  | 1
11 |  |  | Defect 2 |  | PI | 2009-04-08 00:00:00 |  |  | dented at adjust dial (E4) |  |  |  |  |  |  |  |  |  | 1
12 |  |  | Defect 3 |  | PI | 2009-04-22 00:00:00 |  |  | button cabinat dented [scratch] b8 |  |  |  |  |  |  |  |  |  | 1
13 |  |  | Defect 1 |  | QA | 2009-04-22 00:00:00 |  |  | t\head no wrong writing at transf card |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 716702d1612339177-help-filtering-2-columns-silmutaneously-testing
Sheet: Sheet1

CONTRACTOR | COUNTRY OF COMPANY/ LEADER | CONTRACT VALUE | SIGNATURE DATE | AMENDMENT / EXCHANGE SIGNATURE
Gonzales | Greece | 7679169.49 | 2019-07-16 00:00:00 | 2020-08-31 00:00:00
Gonzales | Greece | 1977356.83 | 2019-01-11 00:00:00 | 2020-08-31 00:00:00
Gonzales | Greece | 307600.7 | 2019-05-03 00:00:00 | 2020-08-31 00:00:00
Gonzales | Belgium | 80000 | 2020-05-09 00:00:00 | 2021-01-15 00:00:00
Gonzales | Greece | 607600.7 | 2020-07-30 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 132000 | 2020-09-28 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 38500 | 2020-05-04 00:00:00 | 2021-01-15 00:00:00
Gonzales | Malta | 15000 | 2020-06-22 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 60000 | 2020-06-02 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 44000 | 2020-10-16 00:00:00 | 2020-03-24 00:00:00
Gonzales | Malta | 60000 | 2020-05-26 00:00:00 | 2021-01-20 00:00:00
Gonzales | Malta | 6000 | 2016-04-28 00:00:00 | 2020-06-05 00:00:00
Gonzales | Spain | 300000 | 2016-02-03 00:00:00 | 2020-06-11 00:00:00
Gonzales | Belgium |  | 2016-03-03 00:00:00 | 2020-03-03 00:00:00
Gonzales | Spain | 900000 | 2016-03-03 00:00:00 | 2020-03-03 00:00:00
Gonzales | Belgium |  | 2016-03-04 00:00:00 | 2020-03-03 00:00:00
Gonzales | Belgium | 2000000 | 2016-06-09 00:00:00 | 2020-03-24 00:00:00
Gonzales | Greece |  | 2016-06-09 00:00:00 | 2020-06-03 00:00:00
Gonzales | Belgium |  | 2016-06-09 00:00:00 | 2020-06-16 00:00:00
Gonzales | France | 6000000 | 2016-05-26 00:00:00 | 2020-08-18 00:00:00
Gonzales | Italy |  | 2016-04-19 00:00:00 | 2020-06-24 00:00:00
Gonzales | Greece |  | 2016-02-16 00:00:00 | 2020-03-11 00:00:00
Gonzales | Macedonia | 1000000 | 2016-04-19 00:00:00 | 2020-03-11 00:00:00
Gonzales | Romania | 1200000 | 2016-03-30 00:00:00 | 2020-07-27 00:00:00
Gonzales | Malta | 3000000 | 2016-07-29 00:00:00 | 2020-07-14 00:00:00
Gonzales | Italy | 1600000 | 2016-10-10 00:00:00 | 2020-09-09 00:00:00
Gonzales | Malta | 495000 | 2016-05-10 00:00:00 | 2018-01-04 00:00:00
Gonzales | The Netherlands | 60000 | 2016-12-16 00:00:00 | 2018-01-04 00:00:00
Gonzales | Belgium | 165000 | 2016-11-30 00:00:00 | 2018-10-22 00:00:00
Spreadsheet: 847395d1698338481-new-invoice-allocation-register-test-invoice-allocation-register-emmagizer-
Sheet: JN23-001

PO | PO Description | PO status | PO Value  (ex GST) | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 |  | PO Balance
 |  |  |  | 1611994 | 1625078 | 1638146
 |  |  |  | 2295 | 1000.5 | 564
 |  |  |  | APPROVED | PAID | QUERY/ISSUE
3926 | JN23/001 Insurance claim (Quote 27/9/2023) | Open | 1997.5
3814 | JN23/001 Insurance claim (Quote 23/05/2023) | Open | 5300 | 2295 | 1000.5 | 564
 |  |  | BALANCE/CHECK
Back to Register
Spreadsheet: 77966d1278435736-creating-unique-lists-uniquelist
Sheet: Sheet2

THIS PAGE NEEDS TO BE POPULATED WITH THE TUTOR NAMES
Tutor Name | Tutor Number | Tutor Name (No Duplicates)
[NAME] | 1 | [NAME]
[NAME] | 2 | [NAME]
Georgina Gold | 3 | [NAME]
[NAME] | 4 | [NAME]
[NAME] | 5 | [NAME]
[NAME] | 6 | Fred Flinstone
Fred Flinstone | 7 | Georgina Gold
[NAME]
[NAME]
[NAME]
[NAME]
Georgina Gold
Fred Flinstone
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Georgina Gold
Fred Flinstone
[NAME]
[NAME]
Fred Flinstone
Spreadsheet: 698172d1601826521-vlookup-with-rank-and-if-tournament
Sheet: 1

Team |  |  |  |  |  |  | Round
[NAME] |  | Persons |  |  |  |  |  | [NAME]
9-10 | 1
 | 2
 | 3
15-16 | 1
 | 2
 | 3
11-12 | 1
 | 2
 | 3
15-16 | 1
 | 2
 | 3
13-14 | 1
 | 2
 | 3
 |  | Sum
 |  | HCP
 |  | Sum + HCP
 |  | Opponents
 |  | Vicroty points
Leader: |  | _____________________ |  | Referee: | ___________________________
Spreadsheet: 145967d1331833610-need-help-creating-a-formula-for-survey-results-handwashing-observations-2011-2
Sheet: Sheet2

 |  | Third Quarter Handwashing Observations |  |  | 2009
Health Care Worker Category | Before Patient Contact | Product Used | After Patient Contact | Product used | Date | Dept Submitting
Nursing | yes | sanitizer | yes | soap and water | 2009-09-13 00:00:00 | Recreation
PCA | yes | sanitizer | yes | sanitizer | 2009-09-20 00:00:00 | Nursing
PCA | no | n/a | no | n/a | 2009-08-15 00:00:00 | PCA
PCA | no | n/a | no | n/a | 2009-08-15 00:00:00 | PCA
PCA | no | n/a | no | n/a | 2009-08-15 00:00:00 | PCA
PCA | no | n/a | no | n/a | 2009-08-15 00:00:00 | PCA
PCA | no | n/a | no | n/a | 2009-08-15 00:00:00 | PCA
Therapist | yes | soap and water | yes | soap and water | 2009-09-01 00:00:00 | Recreation
Therapist | yes | soap and water | yes | soap and water | 2009-09-07 00:00:00 | Recreation
Therapist | n/a | n/a | yes | soap and water | 2009-09-12 00:00:00 | Recreation
Therapist | yes | sanitizer | yes | sanitizer | 2009-09-12 00:00:00 | Recreation
Summary:
Nursing | Yes=1 No=0 | S=1 | Yes=1 No=0 | SW=1 | 1 |  | Insufficient data !!
PCA's | Yes=1 No=5 | S=1 N/A=5 | Yes=1 No=5 | S=1 | 0.16
Therapists | Yes=3 No=0 | SW=2 S=1 | Yes=4 No=0 | SW=3 S=1 | 1
Did not meet measurable standards for statistical significance !!!  (need at least 30 observations per quarter)
Spreadsheet: 145826d1331755688-creating-a-total-sum-of-items-matching-a-text-value-example1
Sheet: Sheet1

CR Number | Category | SW Version | SW/Data Impact | Development Time (hours)
2017 | 1 | 1.1.5.29 | S/W | 30
3000 | 2 | 1.1.5.29 | S/W | 2
3004 | 2 | 1.1.5.29 | S/W | 8
3007 | 1 | 1.1.5.29 | S/W | 20
3010 | 3 | 1.1.5.29 | S/W | 8
3020 | 1 | 1.1.5.30 | S/W | 40
3021 | 3 | 1.1.5.31 | S/W | 40
 | Hours
Category 1
Category 2
Category 3
Spreadsheet: 746842d1631067620-rank-by-column-q-data-first-then-by-column-l-data-then-by-column-k-data-to-break-ties-book-2
Sheet: Individual JR.

 |  |  | Test |  |  |  |  |  |  |  | Portfolio
# | Name | County | Correct Number of Test Questions (Don't [NAME]) | TEST Score | Total # of Bonus Questions Correct | Tie-Breaker (Enter -0.000X to order ties) | Test Place | Test Place Points | Total Test Points | Final Test Rank | [NAME] | [NAME] | [NAME] Points | Portfolio Placing | Portfolio Placing Points | Total Portfolio Points | Final Portfoilio Rank | SHOULD BE
 | [NAME] |  | 42 |  | 5 | 0.0002 |  |  |  |  | 171 |  |  | 9
 | [NAME] |  | 30 |  | 5 | 0.0002 |  |  |  |  | 172 |  |  | 8
 | [NAME] |  |  |  | 4 | 0.0002 |  |  |  |  | 174 |  |  | 7
 | [NAME] |  |  |  | 3 | 0.0003 |  |  |  |  | 174 |  |  | 6
 | [NAME] |  | 20 |  | 5 |  |  |  |  |  | 175 |  |  | 5
 | Parker Miner |  | 41 |  | 5 |  |  |  |  |  | 176 |  |  | 4
 | [NAME] |  | 32 |  | 5 | 0.0001 |  |  |  |  | 177 |  |  | 2
 | [NAME] |  | 40.5 |  | 5 |  |  |  |  |  | 177 |  |  | 3
 | [NAME] |  | 42 |  | 5 | 0.0001 |  |  |  |  | 177 |  |  | 1
 | [NAME] |  |  |  | 4 | 0.0001 |  |  |  |  | 171 |  |  |  |  |  |  | 11
 | [NAME] |  | 0.03 |  |  |  |  |  |  |  | 171 |  |  | 10
 | [NAME] |  | 0.01 |  |  |  |  |  |  |  | 171 |  |  |  |  |  |  | 12
 | [NAME] |  | 24 |  | 5 | 0.0001 |  |  |  |  | 157
 | [NAME] |  |  |  | 4 |  |  |  |  |  | 158
 | [NAME] |  |  |  | 5 | 0.0001 |  |  |  |  | 159
 | [NAME] |  | 24 |  | 4 | 0.0002 |  |  |  |  | 160
 | [NAME] |  |  |  | 3 |  |  |  |  |  | 161
 | Dustee Buhl |  | 23.5 |  | 5 |  |  |  |  |  | 162
 | [NAME] |  | 27 |  | 4 | 0.0002 |  |  |  |  | 163
 | [NAME] |  |  |  | 3 |  |  |  |  |  | 164
 | [NAME] |  |  |  |  |  |  |  |  |  | 165
 | [NAME] |  |  |  | 3 | 0.0003 |  |  |  |  | 166
 | [NAME] |  |  |  | 3 | 0.0003 |  |  |  |  | 167
 | Ellie Thurgood |  | 26 |  | 4 |  |  |  |  |  | 168
 | [NAME] |  |  |  | 4 | 0.0001 |  |  |  |  | 169
 | Destiny Zarate |  | 28 |  | 4 |  |  |  |  |  | 170
 | [NAME] |  |  |  | 3 |  |  |  |  |  | 154
 | [NAME] |  | 32 |  | 4 | 0.0002 |  |  |  |  | 153 |  |  |  |  |  |  | 29
 | [NAME] |  |  |  | 5 |  |  |  |  |  | 152
 | [NAME] |  | 44.5 |  | 5 | 0.0001 |  |  |  |  | 150 |  |  |  |  |  |  | 31
 | [NAME] |  | 19.6 |  | 1 |  |  |  |  |  | 150 |  |  |  |  |  |  | 32
 | [NAME] |  | 27.6 |  | 1 |  |  |  |  |  | 149
 | [NAME] |  | 44.5 |  | 5 | 0.0002 |  |  |  |  | 153 |  |  |  |  |  |  | 28
 | [NAME] |  | 27.8 |  | 1 |  |  |  |  |  | 147
 | [NAME] |  | 41.3 |  | 5 |  |  |  |  |  | 146
 | [NAME] |  | 25.5 |  | 1 |  |  |  |  |  | 145
Spreadsheet: e73d2402-a1cd-468e-ad64-e31cd92842a9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Purpose of Long-Term Acute Care
 | Program for Evaluating Payment Patterns Electronic Report
 |  |  |  |  |  |  |  | Visit PEPPERresources.org
 | Data Report Through Q4FY11
 | 000174, Hospital E14
 | The Program for Evaluating Payment Patterns Electronic Report (PEPPER) provides hospital-specific
 | data for Medicare severity diagnosis-related groups (DRGs) and discharges at high risk for
 | improper payments.
 | Please refer to the Long-Term Acute Care PEPPER User's Guide at PEPPERresources.org for
 | guidance using the report. If you need assistance, please contact TMF by visiting PEPPERresources.org
 | and clicking on the “Help/Contact Us” tab.
 | This is LTCH PEPPER version Q4FY11
 | Jurisdiction: Demo Jurisdiction (DMSTR)
 | PEPPER was developed by TMF Health Quality Institute under contract with the Centers for Medicare &
 | Medicaid Services (CMS), an agency of the Department of Health and Human Services (HHS).
Spreadsheet: eec160cb-ad34-40e8-b166-e38ba0478ada
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
SEU | Test | SEU | Selenium, 24 Hour, [NAME] | Selenium, 24 Hr, U | Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) | [NAME], 24-hour graduated: 24Urine |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine collection container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for other acceptable preservatives. 3. High concentrations of gadolinium, iodine, and barium are known to interfere with most metals tests. If gadolinium-, iodine-, or barium-containing contrast media has been administered, a specimen cannot be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 0.3 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-15 years: not established > or =16 years: 10-35 mcg/specimen | Monday, 8 a.m. - 6 p.m. | 1 day | 7 days | 1 | 84255 |  |  |  |  | Rochester
SEU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
SEU | Order Question | TM19 | Collection Duration |  | Plain Text
SEU | Order Question | VL17 | [NAME] |  | Plain Text
SEU | Result | 9793 | Selenium, 24 Hr, U | Selenium, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 5727-3
SEU | Result | TM19 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9
SEU | Result | VL17 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28009-9
SEU | Result | 862 | Se Concentration | Se Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 47976-6
Spreadsheet: 593868d1539361093-formula-with-sorting-book2
Sheet: Sheet1

Term | Symbol | Data
A1 | S1 | 4
D2 | S2 | 6
C4 | S3 | 9
A6 | S6 | 21
B9 | [NAME] | 45
Term | Symbol | Data1
F55 | S9
D5A | S45
FXC | S76