tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 586123d1534211128-eliminate-rows-except-the-one-with-the-latest-dates-example-sorted-by-member-associated-date
Sheet: Sheet3

Name | Date | Campaign Event
[NAME] | 2016-05-04 00:00:00 | 2016-05, AMER All, Accelerate Lenovo Channel Partner Forum |  | I want to see…
Jaime Dolly | 2018-01-12 00:00:00 | [NAME] 638 |  | Name | Date | Campaign Event
[NAME] | 2017-05-25 00:00:00 | 2017-05, [NAME], Newsletter Partner Q2
[NAME] | 2017-05-05 00:00:00 | 2017-04, [NAME], ITBA Storage Roadshow - Apr11 - Hamburg
[NAME] | 2016-05-27 00:00:00 | 2016-04, [NAME], ITBA Storage Roadshow - Apr06 - Hamburg
[NAME] | 2017-05-24 00:00:00 | 2017-05, [NAME], Newsletter Partner Q2
[NAME] | 2017-05-05 00:00:00 | 2017-04, [NAME], ITBA Storage Roadshow - Apr11 - Hamburg
[NAME] | 2016-05-27 00:00:00 | 2016-04, [NAME], ITBA Storage Roadshow - Apr06 - Hamburg
[NAME] | 2014-10-08 00:00:00 | 09-2014, [NAME], ITBA Germany Q3 2014
[NAME] | 2017-11-15 00:00:00 | 2017-09, [NAME], ITBA [NAME] Hamburg
[NAME] | 2016-12-28 00:00:00 | 2016-09, [NAME], ITBA Virtualization Roadshow - Sep28 - Hamburg
[NAME] | 2015-06-04 00:00:00 | 04-2015, [NAME], ITBA Roadshow - Apr21 - Hamburg
[NAME] | 2018-01-08 00:00:00 | 2017-12, [NAME], DC Webcast Serie - Teil 7 - All-Flash Märchen
[NAME] | 2017-05-05 00:00:00 | 2017-04, [NAME], ITBA Storage Roadshow - Apr11 - Hamburg
[NAME] | 2016-05-27 00:00:00 | 2016-04, [NAME], ITBA Storage Roadshow - Apr06 - Hamburg
[NAME] | 2014-10-08 00:00:00 | 09-2014, [NAME], ITBA Germany Q3 2014
[NAME] | 2014-12-04 00:00:00 | 05-2014, EMEA CE, Newsletter Partner Q2
[NAME] | 2014-04-23 00:00:00 | 03-2014, [NAME], ITBA Roadshow Hamburg
[NAME] | 2017-11-15 00:00:00 | 2017-09, [NAME], ITBA [NAME] Hamburg
[NAME] | 2016-12-28 00:00:00 | 2016-09, [NAME], ITBA Virtualization Roadshow - Sep28 - Hamburg
[NAME] | 2015-06-04 00:00:00 | 04-2015, [NAME], ITBA Roadshow - Apr21 - Hamburg
[NAME] | 2018-01-12 00:00:00 | [NAME] 638
Lex Luthor | 2014-10-21 00:00:00 | Whitepaper: 36 Reasons To Adopt SDS EN
Lex Luthor | 2015-04-17 00:00:00 | Requested a Virtual SAN
[NAME] | 2015-04-20 00:00:00 | 01-2015, EMEA ALL, Techtarget Asset Syndication
[NAME] | 2016-12-28 00:00:00 | 2016-09, [NAME], ITBA Virtualization Roadshow - Sep28 - Hamburg
Amalia [NAME] | 2017-08-02 00:00:00 | 2017-03, [NAME], IDG Standard Content Syndication Q1/Q2
[NAME] | 2017-04-11 00:00:00 | 2017-03, [NAME], IDG Standard Content Syndication Q1/Q2
[NAME] | 2017-05-10 00:00:00 | Requested a Virtual SAN
[NAME] | 2017-05-10 00:00:00 | Downloaded Virtual SAN Appliance
[NAME] | 2017-05-10 00:00:00 | Support Download: VMware vSphere 1.3 Plug-in for SANsymphony-V
[NAME] | 2017-05-10 00:00:00 | Support Download: Microsoft SCOM Management Pack 1.3
[NAME] | 2017-08-23 00:00:00 | 2017-08, [NAME], Newsletter [NAME]
[NAME] | 2016-06-13 00:00:00 | 2016-06, [NAME], IDC Storage Transformation - Jun07 - Frankfurt
Spreadsheet: 704889d1605795200-find-the-closer-value-from-other-columns-excel-question1
Sheet: Sheet1

 | Black Numbers 1 | Black Numbers 2 | Black Numbers 3 | [NAME] 1 | [NAME] 2 | [NAME] 3 | Red Numbers 1 | Red Numbers 2 | Red Numbers 3 | Closest value 1 | Closest value 2 | Closest value 3
 | 1642016.096 | 264841.3058064517 | 264841.3058064517 | 2973137.692899807 | 479538.3375644851 | 436993.97148 | 2871478.053737678 | 463141.6215705932 | 374538.6778922993 | Red
 | 953579.554585 | 164410.2680318966 | 153803.1539653227 | 1993875.773146834 | 343771.6850253161 | 229614.9389692307 | 2686221.405109441 | 463141.6215705932 | 374538.6778922993 | Yellow
 | 440362.7375 | 440362.7375 | 71026.247983871 | 443280.4868855118 | 443280.4868855118 | 409106.323748387 | 463141.6215705932 | 463141.6215705932 | 374538.6778922993 | Yellow
 | 672483.08652 | 258647.3409692308 | 108465.0139548388 | 1152529.265902331 | 443280.4868855118 | 409106.323748387 | 1204168.216083542 | 463141.6215705932 | 374538.6778922993 | Yellow
 | 1698798.3558 | 249823.2876176471 | 273999.7348064517 | 3260860.695438499 | 479538.3375644851 | 436993.97148 | 3149363.026680034 | 463141.6215705932 | 374538.6778922993 | Red
 | 3235180.781 | 505496.99703125 | 521803.3517741938 | 3069045.360412706 | 479538.3375644851 | 436993.97148 | 2964106.378051797 | 463141.6215705932 | 374538.6778922993 | Yellow
 | 1482785.472 | 449328.9309090909 | 239158.9470967743 | 1582476.513962801 | 479538.3375644851 | 436993.97148 | 1528367.351182958 | 463141.6215705932 | 374538.6778922993 | Red
Spreadsheet: 23056d1212440523-vlookup-ranges-pricing-sap-pricing-online
Sheet: SAP Pricing

ID | Qty | NEW End User Price (2.5x OEM) | 40% Reseller |  | GLT |  | End User |  | MM OEM |  | AP OEM |  | TAH Dist
 |  |  | E41 |  | E43 |  | E44 |  | E47 |  | E48 |  | E49
005-031 | 1 | 1.96875 | 1.18125 | E41005-0311 | 0.7875 | E43005-0311 | 1.96875 | E44005-0311 | 0.7875 | E47005-0311 | 1.96875 | E48005-0311 | 0.7875 | E49005-0311
005-031 | 100 | 1.70625 | 1.02375 | E41005-031100 | 0.6825 | E43005-031100 | 1.70625 | E44005-031100 | 0.6825 | E47005-031100 | 1.70625 | E48005-031100 | 0.6825 | E49005-031100
005-031 | 700 | 1.44375 | 0.86625 | E41005-031700 | 0.5775 | E43005-031700 | 1.44375 | E44005-031700 | 0.5775 | E47005-031700 | 1.44375 | E48005-031700 | 0.5775 | E49005-031700
005-032 | 1 | 4.90875 | 2.94525 | E41005-0321 | 1.9635 | E43005-0321 | 4.90875 | E44005-0321 | 1.9635 | E47005-0321 | 4.90875 | E48005-0321 | 1.9635 | E49005-0321
005-032 | 100 | 4.2525 | 2.5515 | E41005-032100 | 1.701 | E43005-032100 | 4.2525 | E44005-032100 | 1.701 | E47005-032100 | 4.2525 | E48005-032100 | 1.701 | E49005-032100
005-032 | 700 | 3.59625 | 2.15775 | E41005-032700 | 1.4385 | E43005-032700 | 3.59625 | E44005-032700 | 1.4385 | E47005-032700 | 3.59625 | E48005-032700 | 1.4385 | E49005-032700
005-041 | 1 | 2.44125 | 1.46475 | E41005-0411 | 0.9765000000000001 | E43005-0411 | 2.44125 | E44005-0411 | 0.9765000000000001 | E47005-0411 | 2.44125 | E48005-0411 | 0.9765000000000001 | E49005-0411
005-041 | 100 | 2.12625 | 1.27575 | E41005-041100 | 0.8505000000000001 | E43005-041100 | 2.12625 | E44005-041100 | 0.8505000000000001 | E47005-041100 | 2.12625 | E48005-041100 | 0.8505000000000001 | E49005-041100
005-041 | 700 | 1.785 | 1.071 | E41005-041700 | 0.714 | E43005-041700 | 1.785 | E44005-041700 | 0.7140000000000001 | E47005-041700 | 1.785 | E48005-041700 | 0.7140000000000001 | E49005-041700
005-042 | 1 | 5.11875 | 3.07125 | E41005-0421 | 2.0475 | E43005-0421 | 5.11875 | E44005-0421 | 2.0475 | E47005-0421 | 5.11875 | E48005-0421 | 2.0475 | E49005-0421
005-042 | 100 | 4.43625 | 2.66175 | E41005-042100 | 1.7745 | E43005-042100 | 4.43625 | E44005-042100 | 1.7745 | E47005-042100 | 4.43625 | E48005-042100 | 1.7745 | E49005-042100
005-042 | 700 | 3.75375 | 2.25225 | E41005-042700 | 1.5015 | E43005-042700 | 3.75375 | E44005-042700 | 1.5015 | E47005-042700 | 3.75375 | E48005-042700 | 1.5015 | E49005-042700
005-061 | 1 | 3.80625 | 2.28375 | E41005-0611 | 1.5225 | E43005-0611 | 3.80625 | E44005-0611 | 1.5225 | E47005-0611 | 3.80625 | E48005-0611 | 1.5225 | E49005-0611
005-061 | 100 | 3.3075 | 1.9845 | E41005-061100 | 1.323 | E43005-061100 | 3.3075 | E44005-061100 | 1.323 | E47005-061100 | 3.3075 | E48005-061100 | 1.323 | E49005-061100
005-061 | 700 | 2.80875 | 1.68525 | E41005-061700 | 1.1235 | E43005-061700 | 2.80875 | E44005-061700 | 1.1235 | E47005-061700 | 2.80875 | E48005-061700 | 1.1235 | E49005-061700
Spreadsheet: 786963d1657562383-look-up-with-3-conditions-condition-2-and-3-are-approximate-match-pdoc-scoring-model-workfile
Sheet: doctype

ZF32 | PO Comp. Material | Material
ZF31 | PO Prj. Material | Material
ZF42 | Company contract | Service
ZF41 | Project contract | Service
ZF43 | Asset contract | Service
ZF33 | PO Asset. Material | Material
IF32 | I/C PO Material | Material
IF41 | I/C Project contract | Service
IF42 | I/C Company contract | Service
ZK42 | Company agreement | Service
IK42 | I/C Company agreem. | Service
ZK44 | Transport agreement | Service
ZK32 | Company Blanket Ord. | Service
[NAME] | Project Blanket Ord. | Material
Spreadsheet: 50901d1250502061-allocation-of-inventory-items-list-of-stuff
Sheet: results

 | I would like to have a list that populates after each order is allocated showing the balance of the items available
 |  | capped at 0 | straight calc. | if col b is not a direct copy of list in col S of sheet OH use vlookup
 | 111527000000 | 42.0839 | 42.0839 |  | 42.0839 | 42.0839
 | 111529000000 | 23.084 | 23.084 |  | 23.084 | 23.084
 | 111543000000 | 11.5004 | 11.5004 |  | 11.5004 | 11.5004
 | 112318000000 | 25.7502 | 25.7502 |  | 25.7502 | 25.7502
 | 112321000000 | 1.6669 | 1.6669 |  | 1.6669 | 1.6669
 | 112330000000 | 19.2509 | 19.2509 |  | 19.2509 | 19.2509
 | 112625000000 | 0.5006 | 0.5006 |  | 0.5006 | 0.5006
 | 112926000000 | 0.1666 | 0.1666 |  | 0.1666 | 0.1666
 | 112930000000 | 3 | 3 |  | 3 | 3
 | 112940000000 | 3 | 3 |  | 3 | 3
 | 112950000000 | 3 | 3 |  | 3 | 3
 | 113166000000 | 50.6667 | 50.6667 |  | 50.6667 | 50.6667
 | 113168000000 | 0.25 | 0.25 |  | 0.25 | 0.25
 | 113215000000 | 0.7502 | 0.7502 |  | 0.7502 | 0.7502
 | 113216000000 | 3.1666 | 3.1666 |  | 3.1666 | 3.1666
 | 114001000000 | 20.3334 | 20.3334 |  | 20.3334 | 20.3334
 | 114050000000 | 0 | -2 |  | 0 | -2
Spreadsheet: 694843d1599835105-excel-formula-is-not-producing-a-result-test-v3
Sheet: Bench

Resource Name | Group | Code | Bench Now | Bench in 2 Weeks | Bench in 4 Weeks | Bench in 6 Weeks | Bench in 8 Weeks |  | Bench Now | Bench in 2 Weeks | Bench in 4 Weeks | Bench in 6 Weeks | Bench in 8 Weeks
[NAME] | TX Office | 2
Billy | NC Office | 3
[NAME] | VA Office | 1
Caden | SF Office | 2
[NAME] | NF Office | 3
Clint | SF Office | 3
[NAME] | SF Office | 1
[NAME] | NC Office | 2
[NAME] | NF Office | 1 |  |  |  |  |  |  |  | (blank) | (blank) | (blank) | (blank)
[NAME] | NF Office | 3 |  |  |  |  |  |  |  | (blank) | (blank) | (blank) | (blank)
[NAME] | NC Office | 3
Javier | SF Office | 1 |  |  |  |  |  |  |  |  |  | (blank) | (blank)
Jeremy | NF Office | 3
[NAME] | NF Office | 2
[NAME] | SF Office | 3
[NAME] | NC Office | 1
Katelyn | TX Office | 1
[NAME] | WF Office | 3
[NAME] | GA Office | 3
Louis | WF Office | 3
[NAME] | NC Office | 3
[NAME] | NC Office | 2
[NAME] | NC Office | 1
Olaf | SF Office | 2
[NAME] | NC Office | 2
Ray | NF Office | 3
Reidel | SF Office | 2
[NAME] | NC Office | 2
[NAME] | VA Office | 2
[NAME] | NC Office | 2
[NAME] | SF Office | 1
Stephen | TX Office | 2
Sterling | VA Office | 3
[NAME] | NC Office | 3
[NAME] | NF Office | 2
[NAME] | GA Office | 2
Todd | GA Office | 2
[NAME] | NC Office | 2
Vinson | TX Office | 2
Spreadsheet: 0cf00cf6-1491-49fc-a62a-4b430f59eea0
Sheet: Sheet1

Table 6--Wholesale corn milling product and byproduct prices, 8/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Mkt year and month 1/ | Corn meal, yellow,  Chicago, IL (dollars per cwt) |  | Corn meal, yellow,  New York, NY (dollars per cwt) |  | Corn starch,  Midwest 3/ (dollars per cwt) |  | Dextrose,  Midwest (cents per pound) |  | High-fructose corn syrup (42%),  Midwest (cents per pound)
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
Sep | 27.9925 | 29.205 | 30.2975 | 31.03 | 23.25999999999998 | 24.21999999999998 | 30.85 | 34.85 | 21.375 | 23.375
Oct | 26.7825 | 28.555 | 29.0875 | 30.385 | 22.62999999999998 | 23.04999999999998 | 30.85 | 34.85 | 21.375 | 23.3765
Nov | 26.8975 | 28.34 | 29.2025 | 30.17 | 20.04999999999998 | 22.23999999999998 | 30.85 | 35.35 | 21.375 | 23.375
Dec | 25.74 | 28.01 | 28.045 | 29.84 | 20.88999999999998 | 22.26999999999998 | 30.85 | 35.1 | 21.375 | 23.375
Jan | 24.855 | 27.93166666666667 | 26.555 | 29.76166666666667 | 19.89999999999998 | 22.77999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Feb | 26.39833333333333 | 27.6325 | 30.37 | 29.4625 | 21.39999999999998 | 22.26999999999998 | 33.85 | 35.35 | 23.375 | 25.875
Mar | 26.1675 | 27.79 | 27.92 | 29.61375 | 21.78999999999998 | 22.80999999999998 | 35.85 | 35.35 | 23.375 | 25.875
Apr | 25.5175 | 27.1875 | 27.545 | 29.0675 | 22.08999999999998 | 23.07999999999998 | 34.85 | 35.35 | 23.375 | 25.875
May | 24.485 | 27.935 | 26.7675 | 29.765 | 21.33999999999998 | 21.96999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Jun | 24.295 | 28.345 | 25.995 | 30.175 | 21.24999999999998 | 22.71999999999998 | 34.85 | 35.35 | 23.375 | 25.875
Jul | 28.345 | 29.08 | 30.045 | 30.91 | 20.64999999999998 | 23.37999999999998 | 35.35 | 35.35 | 23.375 | 25.875
Aug | 29.86166666666666 | 27.985 | 31.56166666666667 | 29.815 | 24.09999999999998 |  | 34.85 | 35.35 | 23.375 | 25.875
Mkt year 2/ | 26.44479166666666 | 28.16638888888889 | 28.61597222222223 | 29.99961805555556 | 21.61249999999998 |  | 33.55833333333334 | 35.24583333333334 | 22.70833333333333 | 25.04179166666666
1/ September-August. Latest month is preliminary. 2/ Simple average of monthly prices for the marketing year. 3/ Bulk-industrial, unmodified. Source: Milling and Baking News, except for corn starch which is from private industry.
Date run: 8/13/2013
Spreadsheet: 756223d1637339045-summing-up-working-hours-in-a-cw-might-be-vba-example-7-
Sheet: Tabelle1

 |  |  |  | Year 2021 | 2021 |  |  |  |  | V
 |  |  |  | CW | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 |  |  |  | Start of week | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00
 |  |  |  | Workdays | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Target date | Responsible | Department | Working hours | Remaining
Projekt 1 | Worker1 | 611-Boss1 | 40 |  |  |  |  |  |  |  |  |  |  | =IF(SUMPRODUCT(($F$1:$M$1="V")*F7:M7)>0,D7-SUMPRODUCT(($F$1:$M$1="v")*F7:M7)*2,"")
Projekt 1 | Worker2 | 616-Boss3 | 40 |  | 8 | 16 |  |  |  | 10
Projekt 1 | Worker3 | 616-Boss3 | 40
Projekt 1 | Worker4 | 616-Boss3 | 40
Projekt 1 | Worker5 | 616-Boss3 | 40
Projekt 1 | Worker6 | 611-Boss2 | 40 |  |  |  |  |  |  | 8
Projekt 1 | Worker7 | 611-Boss2 | 40
Projekt 1 | Worker8 | 611-Boss2 | 40
Projekt 1 | Worker9 | 611-Boss2 | 20
Projekt 1 | Worker10 | 611-Boss2 | 40 |  |  |  |  | 20
Projekt 1 | Worker11 | 611-Boss2 | 20 |  |  |  |  |  |  | 8
Projekt 1 | Worker12 | 611-Boss2 | 20
Projekt 1 | Worker13 | 612-Boss4 | 32
Projekt 2 | Worker2 | 616-Boss3 | 40 |  | 8 | 16
Projekt 2 | Worker6 | 611-Boss2 | 40
Projekt 2 | Worker9 | 611-Boss2 | 20
Projekt 2 | Worker7 | 611-Boss2 | 40
Projekt 2 | Worker8 | 611-Boss2 | 40
Spreadsheet: 140184d1328642374-excel-2007-function-where-results-cell-equals-partial-text-of-reference-cell-help-sample-excel
Sheet: Expense Report

 |  |  |  | February 2012
Employee Name |  |  |  | For the month ended: |  |  |  |  |  | Account Code: | Total:
Cost Center
Description: | Date: |  |  | Amount: |  |  | Account Code: |  | Total:
[NAME] w/ [NAME] | 2012-02-02 00:00:00 |  |  | 53 |  |  | 6503-Auto & Truck Expense-Maintenance-Cost of Goods Sold |  | 10
 |  |  |  |  |  |  | 6502-Auto & Truck Expense-Fuel, Gas & Propane-Cost of Goods Sold |  | 20
 |  |  |  |  |  |  | 6502-Auto & Truck Expense-Fuel, Gas & Propane-Cost of Goods Sold |  | 30
 |  |  |  |  |  |  | 6502-Auto & Truck Expense-Fuel, Gas & Propane-Cost of Goods Sold |  | 80
Spreadsheet: 5311ea95-11f7-4c83-a707-b67f765d2ea1
Sheet: TABLE OF CONTENTS

TABLE OF CONTENTS
4 | LOW [NAME]
9 | SEDANS & STATION WAGONS
17 | PICKUP TRUCKS 4X2
21 | PICKUP TRUCKS 4X4
12 | SPORT UTILITY [NAME]
15 | SPORT UTILITY VEHICLES 4X4
26 | PASSENGER VANS
28 | CARGO VANS
34 | CAB AND [NAME]
39 | CAB AND CHASSIS 4X4
43 | LIGHT DUTY WITH VOCATIONAL BODY 4X2
51 | LIGHT DUTY WITH VOCATIONAL BODY 4X4
Spreadsheet: 110174d1306929829-help-with-data-arrangement-example
Sheet: Sheet1

 |  | CPT | LHR | MUC | FRA
 | SYD | ? | ? | ? | ?
 | HKG | ? | ? | ? | ?
 | LAX | ? | ? | ? | ?
 | MIA | ? | ? | ? | ?
 | CDG/ORY | ? | ? | ? | ?
Spreadsheet: 716234d1612113951-scheduling-always-evaluate-a-column-range-for-len-0-but-with-a-changing-column-range-excelhelp
Sheet: Jobs And Breakdown

Scheduled Hours by Month
 | Jan | Feb | March | April | May | June
Fit
Weld
Assm
[NAME]
Pack
Paint
Slip
RL
Balance
Cast
Machined
Spreadsheet: 749450d1632813917-splitting-values-within-a-cell-when-it-contains-parentheses-without-using-text-to-columns-book2
Sheet: Sheet1

Original value | Field 1 | Percentage 1 | Field 2 | Percentage 2 | Field 3 | Percentage 3
Plant biology (50), Crop production (25), Cell biology (25) | Plant biology | 50 | Crop production | 25 | Cell biology | 25
Banking (48), Accounting, auditing and accountability (37), Strategy, management and organisational behaviour (14) | Banking | 48 | Accounting, auditing and accountability | 37 | Strategy, management and organisational behaviour | 14
Physical geography (55), Geology (41), Climate change science (4) | Physical geography | 55 | Geology | 41 | Climate change science | 4
Spreadsheet: 214319d1360864238-mass-insert-individual-row-for-a-large-set-of-data-data-sample
Sheet: Frederick Routes Jan - Dec 2012

Month | Route Date | Count
JAN | 2012-01-02 00:00:00 | 1
JAN | 2012-01-02 00:00:00 | 2
JAN | 2012-01-02 00:00:00 | 3
JAN | 2012-01-02 00:00:00 | 5
JAN | 2012-01-02 00:00:00 | 1
JAN | 2012-01-02 00:00:00 | 2
JAN | 2012-01-02 00:00:00 | 3
JAN | 2012-01-02 00:00:00 | 4
JAN | 2012-01-02 00:00:00 | 5
JAN | 2012-01-02 00:00:00 | 1
JAN | 2012-01-02 00:00:00 | 2
JAN | 2012-01-02 00:00:00 | 3
JAN | 2012-01-02 00:00:00 | 4
JAN | 2012-01-02 00:00:00 | 1
JAN | 2012-01-02 00:00:00 | 2
JAN | 2012-01-02 00:00:00 | 3
JAN | 2012-01-02 00:00:00 | 4
JAN | 2012-01-02 00:00:00 | 1
JAN | 2012-01-02 00:00:00 | 2
JAN | 2012-01-02 00:00:00 | 3
JAN | 2012-01-02 00:00:00 | 4
JAN | 2012-01-02 00:00:00 | 5
JAN | 2012-01-02 00:00:00 | 1
JAN | 2012-01-02 00:00:00 | 2
JAN | 2012-01-02 00:00:00 | 3
JAN | 2012-01-02 00:00:00 | 4
JAN | 2012-01-02 00:00:00 | 1
JAN | 2012-01-02 00:00:00 | 4
JAN | 2012-01-02 00:00:00 | 6
JAN | 2012-01-02 00:00:00 | 7
Spreadsheet: b1f1b57c-70e0-4408-a7dc-73d045c3a4eb
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
MGRNA | Test | MGRNA | Neisseria gonorrhoea, [NAME], by Nucleic Acid Amplification (GEN-PROBE) | [NAME], [NAME], Amplified RNA | Transcription Mediated Amplification |  |  |  | 1 | mL | Specimen source is required.    Submit only 1 of the following specimens:   Swab specimen must be collected using an APTIMA Collection Unisex Swab (Supply T583) or APTIMA Collection Vaginal Swab (Supply T584). These swabs are contained in the APTIMA Collection Kit.   Specimen Type: Oral/throat or ocular (corneal/conjunctiva) or rectal/anal Container/Tube: APTIMA Swab Collection System (Supply T583) [NAME]: Swab Collection Instructions: 1. Swab site using APTIMA Collection Unisex Swab. 2. Place swab in transport tube provided in collection kit. Snap off swab at score line so swab fits into closed tube. 3. [NAME] tube securely, and label tube with patient's entire name, and date and time of collection. 4. Transport swab container to laboratory and store (refrigerated is preferred) within 60 days of collection.   [NAME]: Peritoneal fluid (pelvic wash, [NAME]) Container/Tube: APTIMA Specimen Transfer Tube (Supply T652) [NAME]: 1 mL Collection Instructions: 1. Transfer 1 mL of specimen into the APTIMA Specimen Transfer Tube (Supply T652). 2. [NAME] tube securely, and label tube with patient's entire name, and date and time of collection. 3. Transport APTIMA Specimen Transfer Tube to laboratory (refrigerated is preferred) within 30 days of collection. | Peritoneal Fluid: 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Sources other than those listed above. | Negative | Monday through Saturday; varies | 1 day | 3 days | 1 | 87591 |  |  |  |  | Rochester
MGRNA | [NAME] | VARIES | Varies |  |  |  | Refrigerated
MGRNA | Order Question | SRC22 | SOURCE: |  | Plain Text
MGRNA | Result | SRC22 | SOURCE: | SOURCE: | Alphanumeric
MGRNA | Result | 34508 | [NAME], [NAME], Amplified RNA | [NAME], [NAME], Amplified RNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43305-2 | [NAME] rRNA:ACnc:Pt:[NAME]:[NAME]:Probe.amp.tar
Spreadsheet: 543826d1508592231-cleaning-up-address-and-street-names-in-large-database-street-address-in-front-and-not-in-separate-row
Sheet: Sheet1

 |  |  |  |  | ADDRESS | STREET
 |  |  |  |  |  |  |  |  |  | ADDRESS | STREET
 |  |  |  |  | 1400 | 1400 34TH 1 |  | 1400 | 34TH ST
 |  |  |  |  | 15448 | 15448 GULF FWY |  | 15448 | GULF FWY
 |  |  |  |  | 1815 | 1815 14TH 1 |  | 1815 | 14TH ST
 |  |  |  |  | 2 | 2 KRESS |  | 2 | KRESS
 |  |  |  |  |  | 2 MAIN ST |  | 2 | MAIN ST
 |  |  |  |  |  | 2 RANCHO BAUER DR |  | 2 | RANCHO BAUER DR
 |  |  |  |  | 10118 | 10118 ZEBRA LN |  | 10118 | ZEBRA LN
Spreadsheet: 113ff573-0b0e-46f6-9b78-de085193b38e
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
FFTXG | Test | FFTXG | [NAME] (Dye Test), Serum | [NAME] (Dye Test), Serum | Sabin-Feldman Dye | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in a plain, red-top tube(s).  Spin down and send 2.0 mL serum refrigerated.  Note:  Please provide any pertinent clinical information (ie disease status, if patient is pregnant including weeks of gestation). | 0.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	Mild OK; Gross reject Icteric	NA | <1:16 Negative | Tuesday, Thursday | 1 day | 8 days | 1 | 86777 |  |  |  |  | Palo Alto Medical Foundation
FFTXG | [NAME] | SRED | Serum Red |  |  |  | Refrigerated
FFTXG | Result | Z1490 | [NAME] (Dye Test), Serum | [NAME] (Dye Test), Serum | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8039-0
Spreadsheet: 475122d1471108491-copy-every-7th-row-from-column-a1-to-column-b1-ef957_choose_every_7th_row
Sheet: Sheet1

100
200
300
400
500
600
700
800
900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
2200
2300
2400
2500
2600
2700
2800