tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: adaf8c7e-f90c-49f0-b809-0e22d7ac04ac
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44338845 | 2014-12-07 07:33:38 | AXIS | 0 | 6 | 10 | 1152035 | minderbinder | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44339265 | 2014-12-07 08:22:37 | AXIS | 1 | 10 | 8 | 526619 | askindred | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44339519 | 2014-12-07 08:48:03 | ALLIES | 1 | 10 | 3 | 526619 | askindred | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44368788 | 2014-12-09 07:35:43 | AXIS | 1 | 6 | 3 | 1681726 | player1681726 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44394170 | 2014-12-11 05:14:53 | ALLIES | 1 | 6 | 3 | 780030 | keithdone | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44394263 | 2014-12-11 05:31:07 | AXIS | 1 | 6 | 5 | 780030 | keithdone | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
44408071 | 2014-12-12 07:21:05 | ALLIES | 1 | 6 | 4 | 688270 | Mouchotte72 | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
44408194 | 2014-12-12 07:36:33 | AXIS | 0 | 4 | 6 | 688270 | Mouchotte72 | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
44408327 | 2014-12-12 07:59:55 | ALLIES | 1 | 6 | 0 | 979406 | homez | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
44519223 | 2014-12-20 06:20:29 | ALLIES | 1 | 6 | 4 | 1473232 | [NAME] | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44519396 | 2014-12-20 06:42:50 | ALLIES | 0 | 4 | 6 | 1589254 | Dieudonné de Laubier | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44519547 | 2014-12-20 06:58:56 | ALLIES | 1 | 6 | 3 | 1074409 | ATTappman | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44519647 | 2014-12-20 07:09:46 | AXIS | 0 | 2 | 6 | 1074409 | ATTappman | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
44519733 | 2014-12-20 07:23:35 | ALLIES | 0 | 2 | 6 | 1074409 | ATTappman | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44519839 | 2014-12-20 07:43:15 | AXIS | 1 | 6 | 2 | 1074409 | ATTappman | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44535445 | 2014-12-21 08:40:02 | ALLIES | 1 | 7 | 3 | 1546936 | KATANA PAPA | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44535608 | 2014-12-21 09:01:43 | AXIS | 1 | 7 | 3 | 1546936 | KATANA PAPA | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 703805d1605183493-selecting-value-multiple-times-from-data-validation-list-jaf-quoting-tool
Sheet: RATES

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE: | 2020-11-12 00:00:00
Job Number | 123456 |  |  |  |  |  |  |  |  |  |  |  | Pricing Notes;
Job Name | TEST CASE 1
Location | YORK
Distance | 65
Director
Estimator
Planner
QS
Premium Uplift | 0
Product | Material Type | Price | fitting | adhesive | travel | cutting | cost total | base profit | Base Cost | Waste Price | Base Rate |  | Standard Fitting | Small Area | Large Area | Pattern Work
CT101 | carpet tile | 7.3
[NAME] | matting roll | 10.85
ACT81 | trims | 1.55
APOLLO | carpet roll | 4.81
42OZ HAIRFELT | residential underlay | 1.27
NON SLIP | vinyl sheet | 8.1
BAREFOOT | vinyl sheet | 11.75
SCREED | Latex 3mm | 1.65
Spreadsheet: 85753d1285786889-sorting-womens-grand-prix-2010
Sheet: 4.0 Mixed

Rank | Name | Total | Average | Barber City | SOCC Spring Classic | Tournament 3 | Tournament 4 | Tournament 5 | Tournament 6 | Tournament 7 | Tournament 8 | Tournament 9 | Tournament 10
1 | [NAME] | 100 | 40 | 20 | 80
2 | Heather Farrer | 80 | 25 | 80 | 0
3 | [NAME] | 50 | 25 | 10 | 40
4 | [NAME] | 40 | 20 | 20 | 20
5 | Yolanda Legro | 40 | 20 | 20 | 20
6 | Hedy Bloom | 40 | 20 | 40 | 0
7 | [NAME] | 20 | 10 | 0 | 20
8 | [NAME] | 15 | 7.5 | 15 | 0
9 | Roneva Monreal | 15 | 7.5 | 0 | 15
10 | [NAME] | 10 | 5 | 10 | 0
11 | [NAME] | 10 | 5 | 0 | 10
12 | [NAME] | 10 | 5 | 0 | 10
13 |  | 0 | 0 | 0
14 |  | 0 | 0 | 0
15 |  | 0 | 0 | 0
16 |  | 0 | 0 | 0
17 |  | 0 | 0 | 0
18 |  | 0 | 0 | 0
19 |  | 0 | 0 | 0
20 |  | 0 | 0 | 0
21 |  | 0 | 0 | 0
22 |  | 0 | 0 | 0
23 |  | 0 | 0 | 0
24 |  | 0 | 0 | 0
25 |  | 0 | 0 | 0
26 |  | 0 | 0 | 0
27 |  | 0 | 0 | 0
28 |  | 0 | 0 | 0
29 |  | 0 | 0 | 0
30 |  | 0 | 0 | 0
31 |  | 0 | 0 | 0
32 |  | 0 | 0 | 0
33 |  | 0 | 0 | 0
34 |  | 0 | 0 | 0
35 |  | 0 | 0 | 0
36 |  | 0 | 0 | 0
37 |  | 0 | 0 | 0
38 |  | 0 | 0 | 0
39 |  | 0 | 0 | 0
40 |  | 0 | 0 | 0
41 |  | 0 | 0 | 0
42 |  | 0 | 0 | 0
43 |  | 0 | 0 | 0
44 |  | 0 | 0 | 0
45 |  | 0 | 0 | 0
46 |  | 0 | 0 | 0
47 |  | 0 | 0 | 0
48 |  | 0 | 0 | 0
49 |  | 0 | 0 | 0
50 |  | 0 | 0 | 0
51 |  | 0 | 0 | 0
52 |  | 0 | 0 | 0
53 |  | 0 | 0 | 0
54 |  | 0 | 0 | 0
55 |  | 0 | 0 | 0
56 |  | 0 | 0 | 0
57 |  | 0 | 0 | 0
58 |  | 0 | 0 | 0
59 |  | 0 | 0 | 0
60 |  | 0 | 0 | 0
61 |  | 0 | 0 | 0
62 |  | 0 | 0 | 0
63 |  | 0 | 0 | 0
64 |  | 0 | 0 | 0
65 |  | 0 | 0 | 0
66 |  | 0 | 0 | 0
67 |  | 0 | 0 | 0
68 |  | 0 | 0 | 0
69 |  | 0 | 0 | 0
70 |  | 0 | 0 | 0
71 |  | 0 | 0 | 0
72 |  | 0 | 0 | 0
73 |  | 0 | 0 | 0
74 |  | 0 | 0 | 0
Spreadsheet: 860556fd-bf81-4acb-8eea-2c553a2720e3
Sheet: Sheet1

TRAVEL EXPENSE VOUCHER
See current Travel Regulations for reimbursement rates on the web at www.iup.edu/travel
Name: |  |  |  |  |  | Cost Center/WBSE |  |  | Commitment Item |  | Amount
SAP Number:
Deliver Check to:
Purpose of Travel:
 |  |  |  |  |  | TRAVEL OFFICE USE ONLY
 |  |  |  |  |  | Vendor Number: ______________________ |  |  |  |  | 1099
 |  |  |  |  |  | Travel Officer: |  |  | Date: |  | Yes      No
Itinerary |  |  |  |  | Transportation and Lodging |  | Subsistence | Miscellaneous
Date | Leave Time | Return Time | List Locations | Personal Auto Miles | Provider Name & HO or TO | Cash You Paid | Per Diem Claimed |  | Explanation |  | Cash You Paid
 |  |  | Total Miles
 |  |  | Rate per Mile | 0.565
 |  |  | Totals
 |  |  |  | (A) |  | (B) | (C) |  |  |  | (D)
 |  |  |  |  |  | Total Reimbursement (A+B+C+D)
I certify these expenses are in accordance with established university travel policies and were incurred in the performance of official duties.
[NAME]'s Signature |  |  | Date |  |  |  | Authorizing Signature |  |  |  | Date
Spreadsheet: 27521d1220837310-excel-football-game-excelfootball-2-
Sheet: Sheet1

 |  |  | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100
 |  | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque | Albuquerque
 |  | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage | Anchorage
 |  | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise | Boise
 |  |  |  |  |  |  |  | SCOREBOARD
 |  |  |  |  |  |  | Albuquerque | Anchorage | Boise
 |  | Albuquerque | Anchorage | Boise
 |  |  | 10 | 20
 |  |  | -5 | 20
 |  |  | -15 | 20
 |  |  | -15 | 20
 |  |  | 20 | 20
 |  |  | 20 | 20
 |  |  | 20 | 20
Spreadsheet: 301036d1393631882-advanced-vlookup-issues-fairydust
Sheet: Sheet1

dataset1
ID | PinkPonies | Cupcake | Rainbow | Unicorn | FairyDust
12345
12346
12347 |  |  |  |  |  |  |  |  |  |  |  | dataset2
 |  |  |  |  |  |  |  |  |  |  |  |  | arbitrary numbers
 |  |  |  |  |  |  |  |  |  |  |  | ID | 1 | 2 | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 12345 | PinkPonies | Cupcake | Unicorn | FairyDust
 |  |  |  |  |  |  |  |  |  |  |  | 12346 | Cupcake | Rainbow | Unicorn
 |  |  |  |  |  |  |  |  |  |  |  | 12347 | Unicorn | FairyDust | PinkPonies
Spreadsheet: tracy_geaccone__40573__EA Alloc to Other BUs - Support
Sheet: HR Detail

Business Unit | Headcount | Executive | [NAME] | Commercial Resources/Staff | Recruiting | Comp. | OD&T | MAD | PEP | Service Connection | Totals | PEP Rent Adj. | Bonus Adj. | Adj. Total
EA | 1117 |  |  |  |  |  |  |  |  |  |  | 4329 | 320666
[NAME] | 0 | 0 | 96000 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 170 | 12575
Xcelerator | 0 | 0 | 60000 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 106 | 7860
EGM | 417 |  | 407166 |  |  |  |  |  |  |  |  | 2323 | 172034
EIM | 274 | 130607 | 293966 |  |  |  |  | 55189 |  |  |  | 1440 | 106658
EEOS | 270 | 70778 | 159306 |  |  |  |  | 55189 |  |  |  | 1238 | 91669
ENW | 2610 | 618209 | 1397692 |  |  |  |  | 55189 |  |  |  | 8810 | 652539
EBS | 400 | 0 | 765587 |  |  |  |  | 55189 |  |  |  | 0 | 0
EES | 1375 | 0 | 2342961 | 0 |  |  |  | 55189 |  |  |  | 8000 | 592505
CORP (S.W.) | 1400 | 0 |  | 0 |  |  |  | 0 |  |  |  | 2589 | 191762
CORP (EPI) | 0 | 0 | 145675 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 258 | 19082
CORP (A/A) | 0 | 0 | 0 | 0 | 0 | 140000 | 0 | 0 |  | 0 |  | 248 | 18339
EGAS | 170 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 26 | 1934
ETS-Allocated | 1350 | 0 | 0 | 0 | 0 | 0 |  | 55189 |  | 0 |  | 305 | 22587
EEL | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 90000 | 0 |  | 158 | 11790
Totals:
 |  |  |  |  |  |  |  |  |  |  |  | plus ETS
EWS/CORP/EES |  | 1335867 |  | 193554 | 2668213 | 1592794 | 2469679 | 391552 |  | 801928
EWS |  |  |  |  | 31932 | 237850 |  |  | -90000
 |  |  |  |  | 352833
 |  |  |  |  | 262023
ETS-Direct | 1350 | 343063 | 1671548 | 0 | 0 | 486268 | 299121 | 0 |  | 0
Spreadsheet: 835668d1688714899-separating-auto-updated-data-into-categories-on-other-table-daf-uneven-wrapcols-aligw
Sheet: Sheet1 (2)

 | Team Name | Location |  |  | Team A | Team B | Team C | Team D | Team E
 | Team A | London |  |  | London | Singapore | Jakarta | Moscow | Moscow
 |  | Cairo |  |  | Cairo | Quebec | Lima | Paris | Paris
 |  | Tokyo |  |  | Tokyo | Lima |  | Dubai | Dubai
 |  | Moscow |  |  | Moscow | Dubai |  | Tokyo
 |  | Singapore |  |  | Singapore
 | Team B | Singapore
 |  | Quebec
 |  | Lima
 |  | Dubai
 | Team C | Jakarta
 |  | Lima
 | Team D | Moscow
 |  | Paris
 |  | Dubai
 |  | Tokyo
 | Team E | Moscow
 |  | Paris
 |  | Dubai
Spreadsheet: 208378d1358806436-help-on-a-hostname-generator-imaginglogbook-1-
Sheet: ImagingLogbook

Serial # | Hostname | Operating System | Installed Applications | Completion Time | Checked out to | Deployment Location | Imaged By |  | [NAME] |  | SJH | Logan Hall
12345678910 | SJHB03MOP123 | [NAME] | SCCM, SEP, Star, Citrix Basic Webapp, Microsoft Office 2010 Pro | 01/18/2013 3:43pm | [NAME] | SJH | [NAME] | [NAME] | Windows 7 |  | SJE | [NAME]
[PHONE] | SJHB03MOP124 | Windows 7 | SCCM, SEP, Star, Citrix Basic Webapp, Microsoft Office 2010 Pro | 01/19/2013 11:34am | [NAME] | SJE | Logan Hall | Logan Hall |  |  | SJJ | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Zach Kuhnz
Spreadsheet: 716330d1612178059-transfer-row-info-from-one-sheet-to-second-sheet-triggered-by-entry-in-a-particular-cell-sample-for-richard
Sheet: Results

Company | Ref. # | Partner Ref. # | Date Won | Client | [NAME]. # | Description of Tender
K&S | 10865 |  | 2017-11-09 00:00:00 | Harouge | MR-12426 | [NAME] | -3 | New Year | 2019-01-01 00:00:00
K&S | 11009 |  | 2018-01-03 00:00:00 | Harouge | 17389 | Terex Parts |  | St. Joseph | 2019-03-19 00:00:00
K&S | 11022 |  | 2017-12-31 00:00:00 | Sirte | HED-1740319 | Tools |  | Freedom Day | 2019-03-31 00:00:00
K&S | 11481 |  | 2018-05-31 00:00:00 | Azzawia | AZR/34/180273 | Fork Lift Engine |  | Easter | 2019-04-12 00:00:00
K&S | 11598 |  | 2018-07-18 00:00:00 | Sirte | HEZ-1793719 | Workshop Items |  | [NAME] | 2019-06-07 00:00:00
K&S | 11746 |  | 2018-10-01 00:00:00 | [NAME] | MELL-29695-MSK | Trays Parts |  | Sts. Peter & Paul | 2019-06-29 00:00:00
K&S | 11778 |  | 2018-10-10 00:00:00 | Sirte | HEZ-1890033 | Tools |  | Santa Marija | 2019-08-15 00:00:00
K&S | 11808 |  | 2018-10-23 00:00:00 | Sirte | HED-1840347 | Recorder |  | Independence Day | 2019-09-21 00:00:00
K&S | 11943 |  | 2019-12-16 00:00:00 | Sirte | HEZ-1593714 | Tools |  | Republic Day | 2019-12-13 00:00:00
Spreadsheet: 271871d1382092841-formula-for-forecasting-orders-account-forecast-sheet-
Sheet: Cleaning

Cleaning Forecast |  |  |  | Period: | 7
 |  | Budget | 1000
 |  | Operational Day No | 1 | 2 |  |  | 3 |  | 4 | 5 | 6 | 7 |  |  | 8 | 9 | 10 | 11 | 12 |  |  | 13 | 14 | 15 | 16 | 17 |  |  | 18 | 19 | 20 | 21 | 22
Lookup | Category | Date | 2013-09-26 00:00:00 | 2013-09-27 00:00:00 | 2013-09-28 00:00:00 | 2013-09-29 00:00:00 | 2013-09-30 00:00:00 | 31 | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00 | 2013-10-16 00:00:00 | 2013-10-17 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-21 00:00:00 | 2013-10-22 00:00:00 | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | Total | Budget | [NAME]
 | Cleaning Materials | [NAME] |  |  |  |  |  |  | 15
Spreadsheet: 817876d1676481466-how-to-display-the-values-of-a-drop-down-list-thanks-to-the-selection-of-another-drop-do-teachersubject-tora-v1-
Sheet: TeacherSubjects

[NAME] | [NAME] | [NAME] | [NAME] | Ramesh Chander | [NAME] | [NAME] | [NAME] | [NAME] | .
English | Maths | English | English | Maths | English | English | Maths | English
Maths | Physics | Chemistry | Maths | Chemistry | Maths | Physics | Chemistry | Physics
Biology | History | History | Biology | History | Geography | Biology | Geography | History
Knitting | Knitting | Geography | French | Knitting | German | French |  | French
German |  |  | German |  |  |  |  | German
 |  |  | Woodwork |  |  |  |  | Woodwork
 |  |  | I.T. |  |  |  |  | I.T.
Spreadsheet: 682679d1592252530-need-help-moving-data-from-rows-to-columns-sorta-transposing-but-sorta-not-transposing-example
Sheet: Sheet1

Code | Job or Specialty | Level | Cut | Variable | n Orgs | n Incumbents | 10th Percentile | 25th Percentile | Mean | Median | 75th Percentile | 90th Percentile
123 | Accountant | Level 3 | National | Base Salary | 291 | 11039 | 161183.322362424 | 190962.4 | 233649.3952739946 | 221300 | 258017.5134420095 | 316657.6 |  | Take this format and convert it to the format below
123 | Accountant | Level 3 | National | TCC | 298 | 11454 | 180000 | 207754.1674999997 | 260725.0796480942 | 241085.45 | 299894.082620473 | 358367.2650000001
123 | Accountant | Level 3 | National | Extra 1 | 222 | 7403 | 3000 | 3874.315 | 4945.947221171946 | 4834.84 | 5808.302777777775 | 6939.79
123 | Accountant | Level 3 | National | Extra 2 | 94 | 3147 | 254084.4195744682 | 344237.73 | 496138.6770142969 | 460954.36 | 608322.51 | 783249.2
123 | Accountant | Level 3 | National | Extra 3 | 62 | 1756 | 2 | 4 | 13.77987357817875 | 11 | 21 | 31
 |  |  |  |  | Base |  |  |  |  |  |  |  | TCC |  |  |  |  |  |  |  | Extra 1 |  |  |  |  |  |  |  | Extra 2 |  |  |  |  |  |  |  | Extra 3
Code | Job or Specialty | Level | Cut | Variable | n Orgs | n Incumbents | 10th Percentile | 25th Percentile | Mean | Median | 75th Percentile | 90th Percentile | n Orgs | n Incumbents | 10th Percentile | 25th Percentile | Mean | Median | 75th Percentile | 90th Percentile | n Orgs | n Incumbents | 10th Percentile | 25th Percentile | Mean | Median | 75th Percentile | 90th Percentile | n Orgs | n Incumbents | 10th Percentile | 25th Percentile | Mean | Median | 75th Percentile | 90th Percentile | n Orgs | n Incumbents | 10th Percentile | 25th Percentile | Mean | Median | 75th Percentile | 90th Percentile
123 | Accountant | Level 3 | National | Base Salary | 291 | 11039 | 161183.322362424 | 190962.4 | 233649.3952739946 | 221300 | 258017.5134420095 | 316657.6 | 298 | 11454 | 180000 | 207754.1674999997 | 260725.0796480942 | 241085.45 | 299894.082620473 | 358367.2650000001 | 222 | 7403 | 3000 | 3874.315 | 4945.947221171946 | 4834.84 | 5808.302777777775 | 6939.79 | 94 | 3147 | 254084.4195744682 | 344237.73 | 496138.6770142969 | 460954.36 | 608322.51 | 783249.2 | 62 | 1756 | 2 | 4 | 13.77987357817875 | 11 | 21 | 31
Spreadsheet: 055a6a4b-1208-4b03-b6d0-0e4e35487d68
Sheet: Sheet1

Probe number | Sequence (5' to 3') | position in open reading frame
 |  | (nucleotides)
1 | aaaagttttgatctggcggc | 12
2 | atgcggatgtgtgtgcgtgt | 50
3 | aagctgcggatgttggtgat | 110
4 | tttcggaattgtggcggcaa | 133
5 | atcgaaaagcaaatcgaagg | 155
6 | tagtttatcgctcccgttcg | 178
7 | cagatacggacgtatgtagt | 200
8 | tctggcttgggcatctggtt | 223
9 | [NAME] | 247
10 | [NAME] | 279
11 | [NAME] | 301
12 | tatcgtccctgcagaaagtg | 328
13 | tttcgctgacagatccgcaa | 365
14 | tatcttcacctgggctgtgc | 395
15 | gacgccgacggttcttaaac | 417
16 | tgatccgattggatcttgtg | 439
17 | ctcgtaggactggtccttgt | 461
18 | atcgctctgtttcatacccg | 497
19 | aagctaagagtctgcaagct | 529
20 | tgacggagtcaaagcgttgg | 566
21 | atgtgtgcagtgggcgttga | 595
22 | aatgactcgctgtagtgctc | 619
23 | cattgtagttgtagtaggcg | 642
24 | [NAME] | 668
25 | gatactgcatgtgcatgtga | 690
26 | [NAME] | 731
27 | tgctgctgctggaagaactg | 757
28 | [NAME] | 779
29 | ttgctgctgctgcatctggt | 827
30 | atggtattgctgctgctgag | 854
31 | gcttttgctggaagtcaaag | 876
32 | tccttgaccaggacgcgaca | 907
33 | agctgttgaagttgtagtcg | 939
34 | attcccgatcgcatgtagta | 961
35 | [NAME] | 1036
36 | actttcgtcattcttgggtg | 1058
37 | atgccgatgccacacagact | 1081
38 | ttgctcgttccgtcgtccat | 1150
39 | caagatctgtagcgtcgtct | 1172
40 | tcttgtccagacccttcaaa | 1197
41 | atgtcgtcgctactgccatc | 1225
42 | tcctgctaaggctcttattc | 1253
43 | [NAME] | 1277
44 | gcgaaggcttgccaaatttg | 1299
45 | tattggttcgattcgcccat | 1363
46 | cattatcgtatccatcgtgc | 1388
47 | tccgatggggattatacgct | 1410
48 | agtaggcaaactgcgagttg | 1440
Spreadsheet: 6e65733a-35ce-4884-8720-fc987873cc06
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
LCJC | Test | LCJC | [NAME], Molecular Detection, PCR, Spinal Fluid | JC Virus PCR, CSF | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME], sterile container: SrwStlCont |  |  | 1 | mL | Container/Tube: Sterile vial [NAME]: 1 mL Collection Instructions: Do not centrifuge. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.3 mL | Hemolysis	NA Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Not applicable | Monday through Friday | Monday through Thursday: 2 days Friday, Saturday: 3 days | 5 days | 1 | 87798 |  |  |  |  | Rochester
LCJC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 7 days
LCJC | Result | SRC95 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
LCJC | Result | 88909 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33295-7 | JC virus DNA:ACnc:Pt:CSF:[NAME]:Probe.amp.tar
LCJC | Result | 28313 | Special Information | Special Information | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
LCJC | Result | 28314 | Report Status | Report Status | Alphanumeric
Spreadsheet: 806085d1669102038-retrieving-multiple-column-header-based-on-cell-value-s666-pq-retrieving-multiple-column-header-based-on-cell-value
Sheet: Sheet1

 |  |  | Cross-Sectional Area ( mm2 )
 |  |  | Bar Diameter( [NAME] )
 |  | No. of Bars | 10 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40
 |  | 1 | 78 | 113 | 201 | 314 | 452 | 615 | 804 | 1018 | 1256
 |  | 2 | 156 | 226 | 402 | 628 | 904 | 1230 | 1608 | 2036 | 2512
 |  | 3 | 234 | 339 | 603 | 942 | 1356 | 1845 | 2412 | 3054 | 3768
 |  | 4 | 312 | 452 | 804 | 1256 | 1808 | 2460 | 3216 | 4072 | 5024
 |  | 5 | 390 | 565 | 1005 | 1570 | 2260 | 3075 | 4020 | 5090 | 6280
 |  | 6 | 468 | 678 | 1206 | 1884 | 2712 | 3690 | 4824 | 6108 | 7536
 |  | 7 | 546 | 791 | 1407 | 2198 | 3164 | 4305 | 5628 | 7126 | 8792
 |  | 8 | 624 | 904 | 1608 | 2512 | 3616 | 4920 | 6432 | 8144 | 10048
 |  | 9 | 702 | 1017 | 1809 | 2826 | 4068 | 5535 | 7236 | 9162 | 11304
 |  | 10 | 780 | 1130 | 2010 | 3140 | 4520 | 6150 | 8040 | 10180 | 12560
 | As,req = | 1256 |  |  |  |  |  |  |  |  |  |  | Bar diameter | No of Bars | Area Steel
 | Asmin = | 195 |  | Use As |  | mm2/m |  |  |  |  |  | Provide |  |  |  | mm2/m
Spreadsheet: 606438d1547614723-flag-earliest-date-in-array-flag-earliest-date-in-array
Sheet: Sheet1

Desired Outcome |  |  |  |  | My solution
Account ID | ACCT_Opn_dt | AS_OF_DT | Month# |  | ACCT_ID | ACCT_OPN_DT | ACCT OPN DATE2 | AS_OF_DT | Month#
1 | 2018-06-29 00:00:00 | 2018-12-01 00:00:00 | M6 |  | 1 | 2018-06-29 00:00:00 |  | 2018-12-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-11-01 00:00:00 | M5 |  | 1 | 2018-06-29 00:00:00 |  | 2018-11-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-10-01 00:00:00 | M4 |  | 1 | 2018-06-29 00:00:00 |  | 2018-10-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-09-01 00:00:00 | M3 |  | 1 | 2018-06-29 00:00:00 |  | 2018-09-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-08-01 00:00:00 | M2 |  | 1 | 2018-06-29 00:00:00 |  | 2018-08-01 00:00:00
1 | 2018-06-29 00:00:00 | 2018-07-01 00:00:00 | M1 |  | 1 | 2018-06-29 00:00:00 |  | 2018-07-01 00:00:00 |  | <--should be M1
2 | 2018-03-28 00:00:00 | 2018-08-01 00:00:00 | M6 |  | 2 | 2018-03-28 00:00:00 |  | 2018-08-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-07-01 00:00:00 | M5 |  | 2 | 2018-03-28 00:00:00 |  | 2018-07-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-06-01 00:00:00 | M4 |  | 2 | 2018-03-28 00:00:00 |  | 2018-06-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-05-01 00:00:00 | M3 |  | 2 | 2018-03-28 00:00:00 |  | 2018-05-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-04-01 00:00:00 | M2 |  | 2 | 2018-03-28 00:00:00 |  | 2018-04-01 00:00:00
2 | 2018-03-28 00:00:00 | 2018-03-01 00:00:00 | M1 |  | 2 | 2018-03-28 00:00:00 |  | 2018-03-01 00:00:00