tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 289b27f3-ee27-41ed-9e56-88012f6c3301
Sheet: ACRL1-4

ACRL Statistics Questions 1-4, 2012-2013
Question | Measure | Total FY12 | Notes
Question 1 | Titles held June 30, 2012 (all formats) | 1203441 | Records in catalog for unique titles owned by URI
Question 2 | [NAME] held June 30, 2012 (print plus electronic) | 169868 | Added by Acquisitions
Question 3 | Basis of print volume count is | Physical
Question 4 | Electronic books (included in question 2) | 248194 | Includes government publications
Spreadsheet: 807600d1669966718-help-with-formula-when-ref-a-data-table-in-a-different-column-help-2-
Sheet: Sheet1

Data  A | Data B | doubler | input | location
 |  |  | 0.28 | A
 |  |  | 0.33 | B
 |  |  | 0.3 | C
 |  | x | 0.36 | D
 |  |  | 0.28 | E
 |  |  | 0.22 | F
 |  |  | 0.19 | G
 |  | X | 0.18 | H
 |  | X | 0.16 | I
 |  |  | 0.19 | J
 |  |  | 0.21 | K
 |  |  |  | L
Spreadsheet: 883479d1732098286-match-a-word-in-a-column-to-different-worksheets-dianacatz-example-252-spill-365-aligw
Sheet: HT_CFI ex-Cash

 | Name | Symbol | Country | Market Capitalization (bil) [USD] | CFROI Adjusted for Excess Cash LFY | CFROI Adjusted for Excess Cash FY1 | CFROI Adjusted for Excess Cash less CFROI (Spread) LFY | CFROI Adjusted for Excess Cash less CFROI (Spread) FY1 | Industry Name - GICS Sector | Country (Domicile)
 | SLR INVESTMENT CORP | SLRC
 | FIDUS INVESTMENT CORP | FDUS
 | WISDOMTREE INC | WT
 | VICTORY CAPITAL HOLDINGS INC | VCTR
 | CAPITAL SOUTHWEST CORP | CSWC
 | OLAPLEX HOLDINGS INC | OLPX
 | COLLEGIUM PHARMACEUTICAL INC | COLL
 | BARINGS BDC INC | POWL
 | WINMARK CORP | WINA
 | ODDITY TECH LTD | ODD
 | INMODE LTD | INMD
 | ARGAN INC | AGX
 | VIRTUS INVESTMENT PTNRS INC | VRTS
 | ARTISAN PARTNERS ASSET MGMT | APAM
 | FEDERATED HERMES INC | FHI
 | VIRTU FINANCIAL INC | VIRT
 | NMI HOLDINGS INC | NMIH
 | PERDOCEO EDUCATION CORP | PRDO
 | FRONTDOOR INC | FTDR
 | ADDUS HOMECARE CORP | ADUS
 | CATALYST PHARMACEUTICALS INC | CPRX
 | VITA COCO COMPANY INC | COCO
 | RMR GROUP INC | [NAME]
 | DEFINITIVE HEALTHCARE CORP | DH
 | AFFILIATED MANAGERS GRP INC | AMG
 | NEXTRACKER INC | NXT
 | SIMPLY GOOD FOODS COMPANY | SMPL
 | OPTION CARE HEALTH INC | OPCH
 | INTERNATIONAL MONEY EXPR INC | IMXI
 | ASTRANA HEALTH INC | ASTH
 | SUPER GROUP (SGHC) LTD | SGHC
 | ZIFF DAVIS INC | ZD
 | CERTARA INC | CERT
 | EPLUS INC | PLUS
 | YETI HOLDINGS INC | YETI
 | CENTRUS ENERGY CORP | LEU
 | IRADIMED CORP | IRMD
 | VITAL FARMS INC | VITL
 | STRIDE INC | LRN
 | BRIGHTSPHERE INVEST GRP INC | BSIG
 | PAYMENTUS HOLDINGS INC | PAY
 | GRAND CANYON EDUCATION INC | LOPE
 | CELSIUS HOLDINGS INC | CELH
 | BREAD FINANCIAL HOLDINGS INC | BFH
 | NOVA LTD | NVMI
 | GOOSEHEAD INSURANCE | GSHD
 | PROGYNY INC | PGNY
 | ALLIANCEBERNSTEIN HOLDING LP | AB
 | EURONET WORLDWIDE INC | EEFT
 | COHEN & STEERS INC | CNS
 | CLIMB GLOBAL SOLUTIONS INC | CLMB
 | ENTRADA THERAPEUTICS INC | TRDA
 | ONESPAWORLD HOLDINGS LTD | OSW
 | INNOVIVA INC | INVA
 | HACKETT GROUP INC | HCKT
 | SIMULATIONS PLUS INC | SLP
 | LANTHEUS HOLDINGS INC | LNTH
 | OTC MARKETS GROUP INC | OTCM
 | WAYSTAR HOLDING CORP | WAY
 | JANUS INTERNATIONAL GROUP INC | [NAME]
 | PJT PARTNERS INC | PJT
 | TURNING POINT BRANDS INC | TPB
 | SPS COMMERCE INC | SPSC
 | ALIGHT INC | ALIT
 | REVOLVE GROUP INC | RVLV
 | PRIVIA HEALTH GROUP INC | PRVA
Spreadsheet: 57503d1257720157-if-function-excel-if-question
Sheet: JLL Retail Project Count

 | 10/1/09 Aging Report
 | [NAME]
 | Count of Program
 | Program | Total
 | ATM | 36
 | Initiatives | 147
 | Major R. | 22
 | NS | 54
 | RCI | 165
 | Signage | 43
 | Consolidation | 23
 | Grand Total | 490
Spreadsheet: 494297d1482319156-take-a-staffing-list-to-produce-a-breakdown-by-teams-on-a-second-tab-staff-lists
Sheet: Sheet1

original data |  |  |  |  |  |  | output wanted
Team | Grade | forename | surname | Location | FTE
Team 1 | SO | [NAME] | apples | location 1 | 1
Team 1 | HO | Fred | banana | location 1 | 0.83
Team 2 | SO | Derek | Duck | location 1 | 1 |  | team 1 | [NAME] | apples | SO | 1 |  | team 2 | derek | duck | SO | 1
Team 2 | O | [NAME] | [NAME] | location 3 | 1 |  | team 1 | fred | banana | HO | 0.83 |  | team 2 | [NAME] | eel | O | 1
Team 1 | O | [NAME] | cherry | location 2 | 0.5 |  | team 1 | [NAME] | cherry | O | 0.5 |  | team 2 | freda | fritter | O | 0.75
Team 2 | O | Freda | Fritter | location 2 | 0.75
SO | highest grade |  |  |  |  |  | Team 1 |  |  |  |  |  | Team 2
HO | middle grade
O | lowest grade
Team 1
Team 2
Spreadsheet: 840186d1692540824-dynamic-formula-to-pull-data-from-multiple-columns-in-a-specific-manner-dynamic-array-question
Sheet: Inputs

 |  |  |  | *List of questions in Column B are assumed to be unlimited (upto excel row limitations)
 |  |  |  | *List of answers & Weights below each question in the table are also assumed to be unlimited (upto excel row limitations)
 | List of questions | Table headers
 |  |  |  |  | Weight | Answer | Weight | Answer | Weight | Answer | Weight
 | Question 1 | Answer |  | Q1 A1 | 0.35 | [NAME] | 0.45 | [NAME] | 0.2 | [NAME] | 0.2
 | Question 2 | Weight |  | Q1 A2 | 0.25 | [NAME] | 0.55 | [NAME] | 0.4 | [NAME] | 0.3
 | Question 3 |  |  | Q1 A3 | 0.1 |  |  | [NAME] | 0.4 | [NAME] | 0.25
 | Question 4 |  |  | Q1 A4 | 0.15 |  |  |  |  | [NAME] | 0.25
 |  |  |  | Q1 A5 | 0.1
 |  |  |  | Q1 A6 | 0.05
Spreadsheet: 880687d1728527266-highlighting-the-row-highlight
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Code | Name | Weight | Category | Assigned | Exempted
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 609702822 | M.D. Chem Pvt. Limited. | Mass | Entertainment | 1660160 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300037575 | [NAME] | Mass | Entertainment | 2057061.62 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 609702822 | [NAME] | Mass | Entertainment | 168001 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 600890218 | My life Guide | Mass | Entertainment | 177585.31 | 0
Spreadsheet: 847729d1698599056-summarize-data-on-multiple-sheets-to-one-sheet-sample
Sheet: Plants Delivery

Date | Name | Qty | Price | Amount |  |  |  |  |  | Name | QTY | PRICE
2023-10-01 00:00:00 | Asparagus | 20 | 2
2023-10-02 00:00:00
2023-10-03 00:00:00
2023-10-04 00:00:00
2023-10-05 00:00:00
2023-10-06 00:00:00
2023-10-07 00:00:00
2023-10-08 00:00:00
2023-10-09 00:00:00
2023-10-10 00:00:00
2023-10-11 00:00:00
2023-10-12 00:00:00 | Peppers | 200 | 2
2023-10-13 00:00:00
2023-10-14 00:00:00
2023-10-15 00:00:00
2023-10-16 00:00:00
2023-10-17 00:00:00
2023-10-18 00:00:00
2023-10-19 00:00:00
2023-10-20 00:00:00
2023-10-21 00:00:00
2023-10-22 00:00:00
2023-10-23 00:00:00
2023-10-24 00:00:00
2023-10-25 00:00:00
2023-10-26 00:00:00
2023-10-27 00:00:00
2023-10-28 00:00:00
2023-10-29 00:00:00
2023-10-30 00:00:00
2023-10-31 00:00:00
Spreadsheet: a58807cb-186f-4b3e-923f-5db1b5bcccfd
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
KPC1 | Test | KPC1 | KPC PCR | KPC PCR |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87150 |  |  |  |  | Rochester
KPC1 | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 180039d1347463466-leader-board-lookup-mick-score-sheet
Sheet: Patterns

 | PATTERNS
 | Teams | PAT 1 | PAT 2 | PAT 3 | PAT 4 | PAT 5 | PAT 6 | PAT 7 | PAT 8 | PAT 9 | PAT 10 | PAT 11 | PAT 12 | PAT 13 | PAT 14 | PAT 15 | PAT 16 | PAT 17 | PAT 18 | PAT 19 |  | TOTAL | Overall Score | Rank | Teams
 | IRISH ITF | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRISH ITF
 | GASSOR TKD WALES | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GASSOR TKD WALES
 | EAST COAST TKD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EAST COAST TKD
 | BANNER MARTIAL ARTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BANNER MARTIAL ARTS
Spreadsheet: 047932da-5241-4c24-9c0f-1b2f4d8b0f00
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Fig. 5.3.6 - Specialist stores: number of establishments, sales surface area and employees (*). Veneto - Years 2004-2009
 | (*) The bubble size represents the number of employees
 | Source: processing by [NAME] on Ministry for Economic Development data
 | Specialist stores: number of establishments, sales surface area and employees (*). Veneto - Years 2004-2009
 |  | Number | Sales surface area | Employees
 | 2004 | 139 | 370461 | 2926
 | 2005 | 157 | 437926 | 4226
 | 2006 | 164 | 456559 | 4315
 | 2007 | 182 | 513844 | 5055
 | 2008 | 196 | 548112 | 4862
 | 2009 | 215 | 616821 | 5425
 | (*) The bubble size represents the number of employees
 | Source: processing by [NAME] on Ministry for Economic Development data
Spreadsheet: 170044d1343145831-looking-to-get-rows-in-order-top-8-then-alphabetical-copycopy
Sheet: Tues-17-07-12

sold | 627
 | 54 |  | 28 |  | 37
 | 36 |  | 37 |  | 40
 |  |  | 51 |  | 64
Totals
 | 5 |  | 3 |  | 4
 | 8 |  | 3 |  | 4
 | 6 |  | 0 |  | 0
 | 2 |  | 0 |  | 0
 | 2 |  | 0 |  | 0
 | 3 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 1 |  | 2 |  | 3
 | 11 |  | 0 |  | 0
 | 4 |  | 0 |  | 0
 | 3 |  | 1 |  | 1
Totals
 | 21
 | 4
 | 1 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 1 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
Page Totals
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
Page Totals
Page Totals
Other Grand Totals
Spreadsheet: 718603d1613231567-excel-copy-data-to-another-sheet-without-vlookup-for-a-price-calc-quote-calculator-using-index-aggregate-mrkovacic-
Sheet: Calculator

CALCULATOR |  |  | Wiring Quote | Hardware Quote
 |  | TOTALS:
Item | Price | Quantity | Total
Cat5 | 125
Cat 6 data/phone jack | 159
Cat 6A data/phone jack | 429
Cat 7A data/phone jack | 499 | 2
In-ceiling speaker pair | 649
Pre-wire for future speaker pair | 250
Surround Sound Speaker Package | 1949 | 1
Pre-wire for 5 speaker surround  system and sub | 649
Remote HDMI and cat 6 cabling | 699
Prewire for remote HDMI
Binding Post Plate | 15
[NAME] | 1445 | 1
Wifi Package Prewire | 318
Spreadsheet: 737841d1624624805-formula-to-extract-items-from-one-list-not-present-in-a-second-list-pq-unique-lists-aligw
Sheet: Sheet1

List 1 | List 2 | Unique
A | B | A
B | D | C
C | E | G
D | F | H
E |  | I
F
G
H
I
Spreadsheet: aeed4801-cd66-45ad-91df-6b60021f2ec0
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
BILEA | Test | BILEA | [NAME], Total, Serum | [NAME], Total, S | Enzymatic |  |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL Collection Instructions: 1. Fasting (8 hour minimum). 2. Allow specimen to clot completely at ambient temperature before centrifugation. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	NA | < or =10 mcmol/L | Monday through Friday; 3rd shift | 1 day | 3 days | 1 | 82239 |  |  |  |  | New England
BILEA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
BILEA | Result | BILEA | [NAME], Total, S | [NAME], Total, S | Numeric |  |  |  |  | mcmol/L |  |  |  |  |  |  |  |  |  | 14628-2
Spreadsheet: 3e5c43e7-447d-409d-9350-08823f358333
Sheet: Sheet1

District Conservation Techncian Budget and Funds Request | Unnamed: 1
District Name:
Budget period:
[NAME] requested
District match (minimum 27.5% of total budget)
Total Budget Amount: | 0
% match
EXPENSES
[NAME] Salary
Employer social security/medicare/PERA
Employer Health/Retirement Plan contribution
Workers Compensation
Unemployment Insurance
Technician Vehicle Insurance (match only)
Hiring Advertising
[NAME] (per diem/travel and CACD meeting only)
Techncian Office (match only: non-income generating district owned building only)
Administration (match only & w tracking form: flat rate $604.80/yr)
Total Expenses (should equal Total Budget Amount) | 0
Total technician paid hours for budget period
Total costs/hour
*Please note that there is no “ideal” hourly rate we are favoring - it depends on level/quality of expertise being recruited and local job market availability and expectations.
Budget Notes:
Spreadsheet: 31da2e5e-04ad-4f45-aed9-26fad1aa06f0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | أعداد الحجاج للفترة من عام  1416هـ حتى عام 1431هـ
 | The number of pilgrims for the Years From 1416H. (1995G.) to 1431H. (2010G.)
 | العام | الحجاج من الداخل | [NAME] الخارج | إجمالي الحجاج
 | Year | From Inside The Kingdom | From Outside The Kingdom | Total
 | 1416هـ | 784769 | 1080465 | 1865234
 | 1417هـ | 774260 | 1168591 | 1942851
 | 1418هـ | 699770 | 1132344 | 1832114
 | 1419هـ | 775268 | 1056730 | 1831998
 | 1420هـ | 571599 | 1267555 | 1839154
 | 1421هـ | 549271 | 1363992 | 1913263
 | 1422هـ | 590576 | 1354184 | 1944760
 | 1423هـ | 610117 | 1431012 | 2041129
 | 1424هـ | 592368 | 1419706 | 2012074
 | 1425هـ | 629710 | 1534769 | 2164479
 | 1426هـ | 700603 | 1557447 | 2258050
 | 1427هـ | 724229 | 1654407 | 2378636
 | 1428هـ | 746511 | 1707814 | 2454325
 | 1429هـ | 679008 | 1729841 | 2408849
 | 1430هـ | 699313 | 1613965 | 2313278
 | 1431هـ | 989798 | 1799601 | 2789399
Spreadsheet: chris_germany__2076__TW Compressor Gas 1_02
Sheet: March 2002

ECT - Enron Compressor Gas Sold to Richardson |  |  |  |  |  | contract 27789
Date | Nomed | Flowed
2002-03-01 00:00:00 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594 | 11594
 | 11594
 | 11594
 | 11594
 | 11594 |  | UA4
total |  |  |  | Due to pipeline cuts
Spreadsheet: 884326d1733411044-conditional-adding-example2
Sheet: Sheet1

Pair | Buy price | Size | Reserve
EURUSDTSHORT 16 | 6970.15924060414 | 732537.3
Add Reserve |  | 12153.28
EURUSDTLONG 20 | 7268.15279022877 | 708057.36
EURUSDTLONG 20 | 7446.54696768 | 737361.33
Add Reserve |  | 2114.03
EURUSDTLONG 20 | 8045.55126290948 | 1039588.44
Add Reserve |  | 96.78
EURUSDTLONG 20 | 8025.35258067907 | 1081895.74
Add Reserve |  | 589.56
EURUSDTLONG 12 | 8404.83306199336 | 709289.86
Add Reserve |  | 3128.24
EURUSDTLONG 20 | 8957.96784322828 | 1304639.74
EURUSDTSHORT 10 | 8640.86612497366 | 729218.57
Add Reserve |  | 399.08
EURUSDTLONG 10 | 8726.38974294753 | 741405.14
Add Reserve |  | 6765.54
EURUSDTLONG 24 | 9456.61284334023 | 2064336.08
EURUSDTSHORT 23 | 9262.93194490644 | 2091009.97
Add Reserve |  | 684.58
EURUSDTLONG 20 | 9394.79264656037 | 1928936.82
Add Reserve |  | 18102.94
EURUSDTSHORT 21 | 9997.07847676397 | 3056131.82
EURUSDTLONG 11 | 10251.7072986215 | 1805862.71
EURUSDTSHORT 11 | 9541.267034273 | 1850500.38
Add deposit |  | 44034.07
EURUSDTSHORT 19 | 9556.97402369288 | 2574577.56
Add Reserve |  | 72091.87
EURUSDTLONG 12 | 9095.8577753263 | 2609341.04
EURUSDTSHORT 20 | 8954.70146689864 | 4091802.3
Add Reserve |  | 50946.34
EURUSDTSHORT 14 | 7652.46242478179 | 5859823.21
Add deposit |  | 123038.22
EURUSDTSHORT 11 | 7615.79195159953 | 3940991.73
Add Reserve |  | 391380.37
Out |  | 1224068.03
Spreadsheet: 151820d1335138213-circular-refrence-necessary-or-is-there-a-better-way-help-book2
Sheet: Sheet1

 |  |  |  |  |  | ordering code | Btl Cost | Case Cost | Btl Case | Volume | [NAME] | Inventory |  | Cost |  |  |  | Cost per OZ
 |  |  |  |  |  |  |  |  |  |  |  | Btl | Case | Btl | Case
 |  |  |  |  |  | 82605 |  | 74 | 4 | 3000 |  |  | 1
 |  |  |  |  |  | 47944 |  | 87 | 6 | 1800 |  |  | 1
 |  |  |  |  |  | 12765 |  | 74 | 12 | 750 |  |  | 1
 |  |  |  |  |  | 756168 |  | 23.99 | 6 | 1500 |  |  | 1
 |  |  |  |  |  | 102073 |  | 189 | 6 | 1800 |  |  | 1
 |  |  |  |  |  | 102057 |  | 196.5 | 6 | 1800 |  |  | 1
 |  |  |  |  |  |  |  | 228 | 12 | 720 |  |  | 1
 |  |  |  |  |  | 104741 | 29.03 |  | 12 | 720 |  |  | 1
 |  |  |  |  |  | 75604 |  | 136.02 | 6 | 720 |  |  | 2
 |  |  |  |  |  | 103156 | 40 |  | 6 | 1800 |  |  | 1
 |  |  |  |  |  | 103270 | 22.59 |  | 12 | 720 |  |  | 1
 |  |  |  |  |  | 100998 | 23 |  | 12 | 720 |  |  | 1
 |  |  |  |  |  |  | 24 |  |  | 720
 |  |  |  |  |  |  |  | 24 |  | 720
 |  |  |  |  |  | 171052 |  | 99 | 6 | 750 |  |  | 2
 |  |  |  |  |  | 1040
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Projected Loss %
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Profit
Spreadsheet: 701416d1603748180-find-highest-number-and-then-display-above-cell-highest_partnership
Sheet: Result

Highe Partnerships | 1st Wicket Partnership | 2nd Wicket Partnership | 3rd Wicket Partnership | 4th Wicket Partnership | 5th Wicket Partnership | 6th Wicket Partnership | 7th Wicket Partnership | 8th Wicket Partnership | 9th Wicket Partnership | 10th Wicket Partnership | 11th Wicket Partnership | 12th Wicket Partnership | 13th Wicket Partnership | 14th Wicket Partnership | 15th Wicket Partnership |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Runs | [NAME]
Batters | Miles Ward & Adam Sidhu |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME]
Partnership |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st Wicket Partnership | [NAME]
Spreadsheet: 5ea09b3f-55f1-4db1-9d91-a06fb6f514ed
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
FALBU | Test | FALBU | Albuterol, Serum/Plasma | Albuterol | High Performance Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | EDTA (lavender-top) tube: EDTA OR Plain, Red-Top Tube: Red OR |  |  | 3 | mL | Submit only one of the following specimens:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 3 mL serum refrigerated in plastic vial. Note:  	1. Indicate serum on request form. 	2. Label specimen appropriately (serum).   [NAME] blood in a lavender-top (EDTA) tube(s). ([NAME] is not acceptable.) Spin down and send 3 mL EDTA plasma refrigerated in plastic vial. Note:  	1.  Indicate plasma on request form. 	2.  [NAME] specimen appropriately (plasma). | 1.2 mL | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, EDTA, heparin Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reporting limit determined each analysis   Synonym(s): Proventil   Peak plasma levels following a single 4 mg oral solution:   18 ng/mL at 2.5 hours post dose. Peak plasma levels following a single 0.04-0.1 mg [NAME] dose: 0.6-1.4 ng/mL at 3-5 hours post dose. Steady state trough plasma levels following a 2 mg (conventional tablet) every 6 hours regimen:  3.8-4.3 ng/mL. Steady state trough plasma levels following a 4 mg (extended- release tablet) every 12 hours regimen:  3.0-4.8 ng/mL. Steady state trough plasma levels following a 4 mg (conventional tablet) every 6 hours regimen:  7.8-12.0 ng/mL.     Test Performed By: NMS Labs                                        3701 Welsh Road                                        P.O. Box 433A                                        [NAME], PA 19090-0437 | Tuesday | 2 days | 4-9 days | 1 | 83789 |  |  |  |  | NMS Labs
FALBU | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FALBU | Result | Z1441 | Albuterol | Albuterol | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 9311-2
FALBU | Result | [NAME] | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 136848d1326843892-excel-2007-create-custom-list-from-excel-table-with-array-formula-data6
Sheet: Sheet6

 | ACCOUNT | [NAME] | NSA |  | BRZ |  | EUM |  | MEA |  | APR |  | CORPORATE |  | TOTAL
Short Term Investments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SMALL(IF(ABS($D$3:$N$28)>=5000000,ROW($D$3:$N$28)),ROW(1:1))
 | 021000 | ACCOUNTS RECEIVABLE - BILLED | 30836822.32999999 |  | 0 |  | 6807259.110000003 |  | 72834486.03 |  | 4182788.440000001 |  | 0 |  | 114661355.91 |  |  | 30836822.32999999
 | 021001 | JDE Machine generated AR | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 6807259.110000003
 | 021002 | JDE AR2 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 72834486.03
 | 021099 | TRADE REC-RECLASS | 742550.72 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 742550.72 |  |  | 29798360.23999999
 | 021100 | [NAME] | -1781012.81 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | -1781012.81 |  |  | 6807259.110000003
A/R Billed |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 113622893.8200001 |  |  | 72834486.03
 | 023000 | A/R - ACCRUED DAYWORK REVENUE | 0 |  | 112171.8 |  | 0 |  | 0 |  | 0 |  | 0 |  | 112171.8000000003 |  |  | 34250877.41
 | 023100 | Accrued Revenue | -4112684.060000002 |  | 18126.91 |  | 52909.72000000253 |  | 34250877.41 |  | 14409876.24 |  | 0 |  | 44619106.22 |  |  | 14409876.24
A/R Unbilled Dayrates |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 44731278.02 |  |  | 34250877.41
 | 024000 | A/R - UNBILLED REIMBURSABLES | 1337498.640000001 |  | 29145489.04 |  | -935897.9799999999 |  | 24666403.64 |  | -1042070.2 |  | 0 |  | 53171423.13999999 |  |  | 14409876.24
 | 24099 | PR ContraA/R - UNBILLED | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 29145489.04
 | 024100 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 24666403.64
 | 024101 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 29145489.04
 | 024170 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 24666403.64
 | 024171 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 024172 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 024176 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 024180 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 024185 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 024192 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | 024601 | CONVERSION | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
A/R Unbilled Reimbursables |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 53171423.13999999
 | 025000 | JV RECEIVABLES | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Joint Venture Receivables |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | 028000 | ALLOWANCE FOR DOUBTFUL ACCOUNT | -1298004.316000001 |  | -101636.159 |  | -73916.74199999997 |  | -125997.26 |  | -105071.277 |  | 0 |  | -1704625.754000001
Allowance for Doubtful Accts |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | -1704625.754000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =INDEX($A$1:$N$28,SMALL(IF(ABS($D$3:$N$28)>=5000000,ROW($D$3:$N$28)),ROW(1:1)),COLUMN($D$3:$N$28))