tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 164896d1340956758-look-values-with-a-twist-look-up-query
Sheet: Data

Account | Cost Center | Amount | Amount
2203015 |  | 0 | 648.38
2206001 |  | 0 | 35226.13
2206001 |  | 0 | 10179.58
5000001 | 1405801100 | 8861.25 | 0
5000001 | 1505800650 | 37980.95 | 0
5000001 | 1705800001 | 58436.78 | 0
5000001 | 1705800002 | 130282.09 | 0
Spreadsheet: 48409d1247629740-count-text-help-me
Sheet: Sheet1

 |  | name | grade
 |  | a | a52
 |  | b | a42
 |  | c | a36
 |  | d | a36
 |  | e | a52 |  | grade | a52 | a42 | a36
 |  | f | a42 |  | summation | 3 | 3 | 4
 |  | g | a36
 |  | h | a52
 |  | i | a42
 |  | j | a36
Spreadsheet: 877560d1724353785-conditional-formatting-with-and-mostrecent
Sheet: Data

 | System | Date/Time | Result | Volume |  | Date/Time | Result
 | X | 2024-08-22 06:13:00 | 1062 | - - - |  | 2024-08-08 08:02:00 | 1054
 | Y | 2024-08-08 23:45:00 | 4166 | - - - |  | 2024-08-09 06:00:00 | 1053
 | Z | 2024-08-21 20:30:00 | 4230 | - - - |  | 2024-08-10 06:00:00 | 1052
 | AA | 2024-08-20 00:00:00 | 4189 | 13976 |  | 2024-08-11 06:00:00 | 1054
 | AB | 2024-08-12 00:00:00 | 4193 | 13919 |  | 2024-08-12 06:52:00 | 1054 | << Expected this to be highlighted
 | AC | 2024-08-15 00:00:00 | 4205 | 13938 |  | 2024-08-13 06:51:00 | 1055
 | AD | 2024-08-18 00:00:00 | 4195 | 13938 |  | 2024-08-14 09:09:00 | 1058
 |  |  |  |  |  | 2024-08-15 08:45:00 | 1059
 |  |  |  |  |  | 2024-08-16 08:22:00 | 1060
 | Conditional Formula: |  |  |  |  | 2024-08-17 07:45:00 | 1062
 | =AND(G3>=MIN($C$6:$C$9),H3=MIN($H$3:$H$17)) |  |  |  |  | 2024-08-18 06:46:00 | 1060
 |  |  |  |  |  | 2024-08-19 08:14:00 | 1058
 |  |  |  |  |  | 2024-08-20 06:11:00 | 1060
 |  |  |  |  |  | 2024-08-21 06:19:00 | 1057
 |  |  |  |  |  | 2024-08-22 06:13:00 | 1062
Spreadsheet: 149360d1333879836-delete-other-numbers-except-cell-numbers-my-data2-error
Sheet: Sheet1

[PHONE] 0092-[PHONE]
[PHONE] [PHONE]
[PHONE] [PHONE]
[PHONE] +[PHONE]
[PHONE] +[PHONE]
[PHONE] [PHONE]
[PHONE] 0092-[PHONE]
[PHONE] [PHONE]
[PHONE] [PHONE]
[PHONE] +[PHONE]
[PHONE] +[PHONE]
[PHONE] [PHONE]
[PHONE] [PHONE]
0092-[PHONE] 0092-[PHONE]
0092-[PHONE] [PHONE]
0092-[PHONE] [PHONE]
0092-[PHONE] +[PHONE]
0092-[PHONE] +[PHONE]
0092-[PHONE] [PHONE]
[PHONE] 0092-[PHONE]
[PHONE] [PHONE]
[PHONE] [PHONE]
[PHONE] +[PHONE]
[PHONE] +[PHONE]
[PHONE] [PHONE]
+[PHONE] 0092-[PHONE]
+[PHONE] [PHONE]
+[PHONE] [PHONE]
[NAME]
+[PHONE] +[PHONE]
+[PHONE] [PHONE]
+92-42-[PHONE]-[PHONE]
+92-42-1234567 [PHONE]
+92-42-1234567 [PHONE]
+92-42-1234567 +[PHONE]
+92-42-1234567 +[PHONE]
+92-42-1234567 [PHONE]
0092-[PHONE] 0092-[PHONE]
0092-[PHONE] [PHONE]
0092-[PHONE] [PHONE]
0092-[PHONE] +[PHONE]
0092-[PHONE] +[PHONE]
0092-[PHONE] [PHONE]
[PHONE] 0092-[PHONE]
[PHONE] [PHONE]
021-31234567 [PHONE]
051-31234567 +[PHONE]
021-31234567 +[PHONE]
[PHONE] [PHONE]
Spreadsheet: 14f93eff-6033-457e-bdda-537ff33efdc8
Sheet: EPR IS

Consolidated Statements of Income (Unaudited and Condensed)
 |  | Periods Ended September 30,
 |  | Fourth Quarters |  |  | Years
 |  | 2013 | 2012 |  | 2013 | 2012
(In millions, except per share amounts)
Revenues
Gaming operations |  | 247.1 | 263.8 |  | 991.4000000000001 | 1040
Product sales |  | 312.2 | 313.4 |  | 1085.2 | 966.8000000000001
Interactive |  | 73 | 53.89999999999999 |  | 265 | 143.9
Total revenues |  | 632.3000000000001 | 631.1 |  | 2341.6 | 2150.7
Costs and operating expenses
Cost of gaming operations |  | 91.6 | 102.1 |  | 374.3 | 405.7
Cost of product sales |  | 156.5 | 139.1 |  | 520.2 | 444.5
Cost of interactive |  | 27.7 | 20.4 |  | 102.7 | 62.9
Selling, general and administrative |  | 135.3 | 106.7 |  | 460.4 | 410.4
Research and development |  | 62.7 | 59.59999999999999 |  | 235 | 217
Depreciation and amortization |  | 19.4 | 21.1 |  | 77.4 | 76.9
Contingent acquisition-related costs |  | 15.3 | 31.3 |  | 73.9 | 69.1
Impairment |  | 0.4 | 42.5 |  | 3.6 | 42.5
Total costs and operating expenses |  | 508.9 | 522.8 |  | 1847.5 | 1729
Operating income |  | 123.4000000000001 | 108.3000000000001 |  | 494.0999999999999 | 421.7000000000003
Other income (expense)
Interest income |  | 10.4 | 11.4 |  | 44.4 | 45.3
Interest expense |  | -31 | -31.3 |  | -123.4 | -122.2
Other |  | -3.299999999999999 | 4.300000000000001 |  | -12.8 | -2
Total other income (expense) |  | -23.9 | -15.6 |  | -91.8 | -78.9
Income from continuing operations before tax |  | 99.50000000000009 | 92.70000000000007 |  | 402.2999999999999 | 342.8000000000003
Income tax provision |  | 36 | 2.599999999999998 |  | 129.6 | 93.1
Income from continuing operations |  | 63.50000000000009 | 90.10000000000008 |  | 272.6999999999999 | 249.7000000000003
Loss from discontinued operations, net of tax |  | 0 | -2 |  | 0 | -3.8
Net income |  | 63.50000000000009 | 88.10000000000008 |  | 272.6999999999999 | 245.9000000000003
Basic earnings (loss) per share
Continuing operations |  | 0.24 | 0.34 |  | 1.04 | 0.86
Discontinued operations |  | 0 | -0.01000000000000001 |  | 0 | -0.01000000000000001
Net income |  | 0.24 | 0.33 |  | 1.04 | 0.85
Diluted earnings (loss) per share
Continuing operations |  | 0.24 | 0.33 |  | 1.03 | 0.86
Discontinued operations |  | 0 | 0 |  | 0 | -0.01000000000000001
Net income |  | 0.24 | 0.33 |  | 1.03 | 0.85
Weighted average shares outstanding
Basic |  | 260.4 | 268.5 |  | 262.6 | 288.8
Diluted |  | 264.7 | 270 |  | 265.2 | 290.4
Spreadsheet: 858507d1707164088-filter-not-bold-values-filtere-not-bold-values
Sheet: Sheet1

 |  | Assets |  |  |  | <<< | I need formula to filter only not bold values.
 |  |  |  |  | Property plant and equipment
 |  | Property plant and equipment |  |  | intangible Assets
 |  | intangible Assets |  |  | Investment
 |  | Investment |  |  | Financial assets
 |  | Financial assets |  |  | Cash and cash equivalents
 |  | Total Non Current Assets |  |  | Prepayments
 |  |  |  |  | Trade and other receivables
 |  | Cash and cash equivalents |  |  | Dividends recievable
 |  | Prepayments |  |  | Interest receivable
 |  | Trade and other receivables |  |  | Capital
 |  | Dividends recievable |  |  | Charter Capital
 |  | Interest receivable |  |  | Retained earnings
 |  | Total Current Assets |  |  | Current Liabilities
 |  | Total Assets |  |  | Trade and other payables
 |  | Capital
 |  | Charter Capital
 |  | Retained earnings
 |  | Total Equity
 |  | Current Liabilities
 |  | Trade and other payables
 |  | Total Current Liabilities
 |  | Total Liabilities
 |  | Total equity and liabilities
Spreadsheet: 72652d1273341216-search-multiple-worksheets-acme-schedules
Sheet: SHIFT D

WORK CATEGORY CODES: |  |  |  |  | DIVISION/ [NAME]:
W – WORK           SA – SPECIAL ASSIGNMENT    SL – SICK LEAVE
DO – DAY OFF        HW – HOLIDAY WORKED        AV – ADVANCE |  |  |  |  | STORE 1811
AL – ANNUAL LEAVE   WT – WORK/TRAVEL
 | SHIFT D | PERIOD COVERED |  |  | SHIFT:
 | NAME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THRUSDAY | FRIDAY | SATURDAY
1 | A. TASTE |  |  |  |  |  |  |  | A. TASTE | A. TASTE | A. TASTE | A. TASTE | A. TASTE | A. TASTE | A. TASTE
2 | B. CLORY |  |  |  |  |  |  |  | B. CLORY | B. CLORY | B. CLORY | B. CLORY | B. CLORY | B. CLORY | B. CLORY
3 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
4 | D. IRON |  |  |  |  |  |  |  | D. IRON | D. IRON | D. IRON | D. IRON | D. IRON | D. IRON | D. IRON
5 | E. REAL | SA 60/3A 8A-7P |  |  |  |  |  |  | E. REAL | E. REAL | E. REAL | E. REAL | E. REAL | E. REAL | E. REAL
6 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
7 | G. CENNE |  |  |  |  |  |  |  | G. CENNE | G. CENNE | G. CENNE | G. CENNE | G. CENNE | G. CENNE | G. CENNE
8 | H. JONS |  |  |  |  |  |  |  | H. JONS | H. JONS | H. JONS | H. JONS | H. JONS | H. JONS | H. JONS
9 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
10 | P. NICHOLS |  |  | SA 60/3A 8A-7P |  |  |  |  | P. NICHOLS | P. NICHOLS | P. NICHOLS | P. NICHOLS | P. NICHOLS | P. NICHOLS | P. NICHOLS
11 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
12 | O. REALLY |  |  |  |  |  |  |  | O. REALLY | O. REALLY | O. REALLY | O. REALLY | O. REALLY | O. REALLY | O. REALLY
13 | R. DIPP |  |  |  |  |  |  |  | R. DIPP | R. DIPP | R. DIPP | R. DIPP | R. DIPP | R. DIPP | R. DIPP
14 | S. FICAL |  |  |  |  |  |  |  | S. FICAL | S. FICAL | S. FICAL | S. FICAL | S. FICAL | S. FICAL | S. FICAL
15 | T. BIRD |  |  |  |  |  |  |  | T. BIRD | T. BIRD | T. BIRD | T. BIRD | T. BIRD | T. BIRD | T. BIRD
16 | A. LEAR |  |  |  |  |  | SA 60/3A 8A-7P |  | A. LEAR | A. LEAR | A. LEAR | A. LEAR | A. LEAR | A. LEAR | A. LEAR
17 | B. RICO |  |  |  |  |  |  |  | B. RICO | B. RICO | B. RICO | B. RICO | B. RICO | B. RICO | B. RICO
18 | O. MAY |  |  |  |  |  |  |  | O. MAY | O. MAY | O. MAY | O. MAY | O. MAY | O. MAY | O. MAY
19 | P. NUY |  |  |  |  |  |  |  | P. NUY | P. NUY | P. NUY | P. NUY | P. NUY | P. NUY | P. NUY
20 | T. OPPS |  |  |  |  | SA 60/3A 8A-7P |  |  | T. OPPS | T. OPPS | T. OPPS | T. OPPS | T. OPPS | T. OPPS | T. OPPS
21 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL SOT:
 | CITIES
 | SHIFT:
 | TEMPS:
PREPARED BY |  |  |  |  | SIGNATURE
BRAD PITT |  |  |  |  | [NAME]
Spreadsheet: 5085e64c-6b28-40d2-afc9-0ba1dd35083a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 40. OPERATING LEASE FINANCE COMMITMENTS: By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Banks ; |  |  | Original | A2413831L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Finance Companies ; |  |  | Original | A2413832R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
General Financiers ; |  |  | Original | A2413833T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Other Lessors ; |  |  | Original | A2413834V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413835W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 768142d1644851652-populating-a-list-sample-6-
Sheet: Sheet1

Customer Invoice. Details will be input here. |  |  |  | List of what each item contains |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Picking note for staff to know what to prep for event.
Invoice
Item |  | Qty | Cost | Item | XL Vase | 50cm Vase | 10.5" Vase | 9" Vase | 7.5" Vase | 50cm Stem Vase | 40cm Stem Vase | 30cm Stem Vase | Branches | Trunk | Canopy Trunk | Log Slices | Globes | Floating Candles |  |  | Picking List
XL Candle Cluster | Silver Candles | 2 | £[NAME] | XL Candle Cluster | 1 | 3 | 3 |  | 6 |  |  |  |  |  |  |  |  | 13 |  |  | Item | Qty
Tree | White Blossom | 4 | £[NAME] | Tree |  |  |  |  |  |  |  |  | 10 | 1 |  | 1 | 4 |  |  |  | XL Vase | 2
Canopy Tree | White Blossom | 2 | £[NAME] | Canopy Tree |  |  |  |  |  |  |  |  | 20 |  | 1 |  |  |  |  |  | 50cm Vase | 6
Stemmed Candle Trio | Silver Candles | 2 | £[NAME] | Candle Trio |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 3 |  |  | 10.5" Vase | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5" Vase | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50cm Stem Vase | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40cm Stem Vase | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30cm Stem Vase | 2
 | Is it possible to automate the picking list from the data that’s on the invoice. *note* these will be on different sheets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Branches | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trunk | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Canopy Trunk | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Log Slices | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Globes | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Floating Candles | 32
Spreadsheet: 69220d1269735611-all-worksheets-grand-total-of-a-cell-on-a-new-sheet-book-1
Sheet: FA01

 | FA01
 | Material | Description | Book Bal.
FA0116100-198-7700C | 16100-198-7700C | CARBURETOR ASSY. | 0
FA0116100-198-7710 | [PHONE] | CARBURETTOR ASSY. | 0
FA0116100-198-7720 | [PHONE] | CARBURETTOR ASSY. | 0
FA0116100-198-D010 | 16100-198-D010 | CARBURETTOR ASSY. | 0
FA0116100-KCC-9400C | 16100-KCC-9400C | CARBURETOR ASSY | 0
FA0116100-KCC-9410 | 16100-KCC-9410 | CARBURETTOR ASSY | 0
FA0116100-KCC-9420 | 16100-KCC-9420 | CARBURETTOR ASSY | 2070
FA0116100-KST-9000 | 16100-KST-9000 | CARBURETTOR ASSY. | 0
FA0116100-KST-9210 | 16100-KST-9210 | CARBURETTOR ASSY | 0
FA0116100-KST-9450 | 16100-KST-9450 | CARBURETOR ASSY. | 1491
FA0116100-KTC-9010 | 16100-KTC-9010 | CARBURETTOR ASSY. | 387
FA0116100-KVH-8510 | 16100-KVH-8510 | CARBURETOR ASSY | 469
FA0116100-KVH-9010 | 16100-KVH-9010 | CARBURETOR ASSY | 85
FA0116950-166-0100 | [PHONE] | COCK ASSY.FUEL | 0
FA0116950-KCC-9000 | 16950-KCC-9000 | COCK ASSY.FUEL | 0
FA0116950-KCC-9010 | 16950-KCC-9010 | COCK ASSY.FUEL | 11
 |  | Grand Total
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: PEPITO 3

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
PEPITO 3
onlinePEPITO 3
Add as a friend Send message Donate
Experience level 27
14,240 / 15,000
Location: PolandPoland, [NAME]: CroatiaCroatia
eRepublik birthday
Apr 06, 2011
National rank: 987
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
Member
HV 1.GB Tigrovi HV 1.GB Tigrovi
No media activity
Friends(102)
Z N Gorki
[NAME]
funky_ribar
BeDva
Issacbj
[NAME]
yanbbo
Phantom II
Ban Josip Jelacic II
view all
Land of PEPITO 3: 18 buildings
Visit
Achievements
hard worker
5
Hard Worker
Worked 30 days in a row
congressman
Congress Member
Win the Congress elections
president
Country President
Win the Presidential elections
media mogul
Media Mogul
Reach 1000 subscribers to your newspaper
battle hero
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
6
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
1,599.00
Super soldier:1,599 / 1,750
Rank
Colonel **Colonel **
Rank points:
466,124 / 540,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 134262d1325154367-look-up-multiple-values-both-in-rows-and-columns-lookup-with-multiple-criteria
Sheet: Sheet1

 |  | 2011 | 2011 | 2011 | 2012 | 2012 | 2012
Account | Product | M1 | M2 | M3 | M1 | M2 | M3 |  |  | Account | Product | Month | Year | Sales
A | X | 1 | 2 | 3 | 4 | 5 | 6 |  |  | A | X | M1 | 2011
A | Y | 2 | 4 | 6 | 8 | 10 | 12 |  |  | A | X | M2 | 2011
A | Z | 4 | 8 | 12 | 16 | 20 | 24 |  |  | A | X | M3 | 2011
B | X | 8 | 16 | 24 | 32 | 40 | 48 |  |  | A | X | M1 | 2012
B | Y | 16 | 32 | 48 | 64 | 80 | 96 |  |  | A | X | M2 | 2012
B | Z | 32 | 64 | 96 | 128 | 160 | 192 |  |  | A | X | M3 | 2012
C | X | 64 | 128 | 192 | 256 | 320 | 384 |  |  | A | Y | M1 | 2011
C | Y | 128 | 256 | 384 | 512 | 640 | 768 |  |  | A | Y | M2 | 2011
C | Z | 256 | 512 | 768 | 1024 | 1280 | 1536 |  |  | A | Y | M3 | 2011
 |  |  |  |  |  |  |  |  |  | A | Y | M1 | 2012
 |  |  |  |  |  |  |  |  |  | A | Y | M2 | 2012
 |  |  |  |  |  |  |  |  |  | A | Y | M3 | 2012
 |  |  |  |  |  |  |  |  |  | A | Z | M1 | 2011
 |  |  |  |  |  |  |  |  |  | A | Z | M2 | 2011
 |  |  |  |  |  |  |  |  |  | A | Z | M3 | 2011
 |  |  |  |  |  |  |  |  |  | A | Z | M1 | 2012
 |  |  |  |  |  |  |  |  |  | A | Z | M2 | 2012
 |  |  |  |  |  |  |  |  |  | A | Z | M3 | 2012
 |  |  |  |  |  |  |  |  |  | B | X | M1 | 2011
 |  |  |  |  |  |  |  |  |  | B | X | M2 | 2011
 |  |  |  |  |  |  |  |  |  | B | X | M3 | 2011
 |  |  |  |  |  |  |  |  |  | B | X | M1 | 2012
 |  |  |  |  |  |  |  |  |  | B | X | M2 | 2012
 |  |  |  |  |  |  |  |  |  | B | X | M3 | 2012
 |  |  |  |  |  |  |  |  |  | B | Y | M1 | 2011
 |  |  |  |  |  |  |  |  |  | B | Y | M2 | 2011
 |  |  |  |  |  |  |  |  |  | B | Y | M3 | 2011
 |  |  |  |  |  |  |  |  |  | B | Y | M1 | 2012
 |  |  |  |  |  |  |  |  |  | B | Y | M2 | 2012
 |  |  |  |  |  |  |  |  |  | B | Y | M3 | 2012
 |  |  |  |  |  |  |  |  |  | B | Z | M1 | 2011
 |  |  |  |  |  |  |  |  |  | B | Z | M2 | 2011
 |  |  |  |  |  |  |  |  |  | B | Z | M3 | 2011
 |  |  |  |  |  |  |  |  |  | B | Z | M1 | 2012
 |  |  |  |  |  |  |  |  |  | B | Z | M2 | 2012
 |  |  |  |  |  |  |  |  |  | B | Z | M3 | 2012
 |  |  |  |  |  |  |  |  |  | C | X | M1 | 2011
 |  |  |  |  |  |  |  |  |  | C | X | M2 | 2011
 |  |  |  |  |  |  |  |  |  | C | X | M3 | 2011
 |  |  |  |  |  |  |  |  |  | C | X | M1 | 2012
 |  |  |  |  |  |  |  |  |  | C | X | M2 | 2012
 |  |  |  |  |  |  |  |  |  | C | X | M3 | 2012
 |  |  |  |  |  |  |  |  |  | C | Y | M1 | 2011
 |  |  |  |  |  |  |  |  |  | C | Y | M2 | 2011
 |  |  |  |  |  |  |  |  |  | C | Y | M3 | 2011
 |  |  |  |  |  |  |  |  |  | C | Y | M1 | 2012
 |  |  |  |  |  |  |  |  |  | C | Y | M2 | 2012
 |  |  |  |  |  |  |  |  |  | C | Y | M3 | 2012
 |  |  |  |  |  |  |  |  |  | C | Z | M1 | 2011
 |  |  |  |  |  |  |  |  |  | C | Z | M2 | 2011
 |  |  |  |  |  |  |  |  |  | C | Z | M3 | 2011
 |  |  |  |  |  |  |  |  |  | C | Z | M1 | 2012
 |  |  |  |  |  |  |  |  |  | C | Z | M2 | 2012
 |  |  |  |  |  |  |  |  |  | C | Z | M3 | 2012
Spreadsheet: 82707d1282738407-autofilter-not-working-properly-with-subtotals-in-columns-data-sheet
Sheet: Sheet1

A | B | C | D | E
Import | 7658 | 0.2439552738045937 | 24.39552738045937 | 24.39552738045937
Import | 8765 | 0.2792201586441974 | 27.92201586441973 | 27.92201586441973
Import | 1234 | 0.03931063043547513 | 3.931063043547514 | 3.931063043547514
Import | 9806 | 0.3123825300245293 | 31.23825300245293 | 0
Import | 3928 | 0.1251314070912045 | 12.51314070912045 | 12.51314070912045
Import Total | 31391 | 1 | 100 | 0
Export | 692 | 0.05697348921455623 | 5.697348921455623 | 5.697348921455623
Export | 128 | 0.01053844887205664 | 1.053844887205664 | 1.053844887205664
Export | 483 | 0.03976617816565124 | 3.976617816565124 | 3.976617816565124
Export | 2774 | 0.2283879466491026 | 22.83879466491026 | 22.83879466491026
Export | 6777 | 0.5579614687963116 | 55.79614687963116 | 0
Export | 1292 | 0.1063724683023217 | 10.63724683023218 | 10.63724683023218
Export Total | 12146 | 1 | 100 | 0
Impex | 3087 | 0.3526790814577859 | 35.26790814577859 | 0
Impex | 1283 | 0.1465783160059408 | 14.65783160059408 | 14.65783160059408
Impex | 4383 | 0.5007426025362732 | 50.07426025362732 | 0
Impex Total | 8753 | 1 | 100 | 0
Eximp | 13284 | 0.7779339423752635 | 77.79339423752634 | 0
Eximp | 766 | 0.04485828062778168 | 4.485828062778168 | 4.485828062778168
Eximp | 281 | 0.0164558444600609 | 1.64558444600609 | 1.64558444600609
Eximp | 2745 | 0.1607519325368939 | 16.07519325368939 | 16.07519325368939
Eximp Total | 17076 | 1 | 100 | 0
Grand Total | 69366
Spreadsheet: e1088bd2-f372-4405-a763-5bd5e9698a6f
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
HYMP | Test | HYMP | Hydromorphone   Confirmation, serum | Hydromorphone (Dilaudid)-Forensic | Gas Chromatography-Mass Spectrometry (GC-MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 10 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s).  ([NAME] is not acceptable.)  Spin down and send 5 mL of sodium heparin plasma refrigerated. Note:	1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma).  	3. Trough levels are most reproducible.   Serum Draw blood in a plain, red-top tube(s).  (Serum gel tube is not acceptable.)   Spin down and send 5 mL of serum refrigerated. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum). 	                 3. Trough levels are most reproducible. | 2 mL       Note: Submission of t | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | [NAME]: 10-30 ng/mL   Hydromorphone also known as Dihydromorphinone.   This specimen was handled by Medtox Laboratories as a  forensic specimen under chain of custody protocol.  Compound identification for positive specimens is performed by GCMS.   Performed By Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 5 days | 6 days | 1 | 83925 |  |  |  |  | Medtox Laboratories, Inc
HYMP | [NAME] | VARIES | Varies |  |  |  | Refrigerated
HYMP | Result | Z1050 | Hydromorphone (Dilaudid) | Hydromorphone (Dilaudid) | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3683-0
Spreadsheet: 184389d1349248242-batch-number-generator-batch-no
Sheet: Sheet1

Enter date
2012-10-01 00:00:00
2012-10-01 00:00:00
2012-10-02 00:00:00