tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 8d2805af-5955-4975-8397-b7049e9b201b
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
LCBKP | Test | LCBKP | BK Virus, Molecular Detection, PCR, Plasma | BK Virus DNA by PCR, P | Real-Time Polymerase Chain Reaction (PCR)/DNA [NAME] (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Lavendar-top (EDTA) Tube: EDTA (<1 month old infant) |  |  |  |  | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Collection Instructions: Spin down and separate plasma within 24 hours of collection. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Thrombin-activated tube, green-top (heparin) tube, or yellow-top (ACD) tube | Not applicable | Monday, Wednesday, Friday; 6 a.m. | Monday through Thursday: 2 days Friday, Saturday: 3 days | 5 days | 1 | 87798 |  |  |  |  | Rochester
LCBKP | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 7 days
LCBKP | Result | SRC94 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
LCBKP | Result | 56084 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32362-6 | BK virus DNA:ACnc:Pt:Ser/Plas:[NAME]:Probe.amp.tar
LCBKP | Result | 56085 | Special Information | Special Information | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
LCBKP | Result | 56086 | Report Status | Report Status | Alphanumeric
Spreadsheet: 777684d1650551579-icon-set-formatting-for-month-by-month-tracking-example-2
Sheet: Sheet1

Item | 1.2022 | 2.2022 | 3.2022 | 4.2022 | 5.2022 | 6.2022 | 7.2022 | 8.2022 | 9.2022 | 10.2022 | 11.2022 | 12.2022
Item 1 | 31.5 | 30.5 | 31.5 | 1.5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 2 | 42.07589999999999 | 42.07589999999999 | 41.32529999999999 | 45.9378 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 3 | 125.571 | 127.571 | 127.561 | 128.0735 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 4 | 17.74 | 17.74 | 11.74 | 14.64 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 5 | 134.044 | 134.044 | 135.214 | 61.56399999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 6 | 70.33199999999998 | 70.33199999999998 | 69.27199999999999 | 84.2395 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 7 | 14.55 | 3.25 | 3.25 | 3.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 8 | 14.31 | 25.61 | 24.61 | 24.61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 9 | 27.8 | 27.8 | 27.8 | 27.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Item 10 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Item
 | If Feb month figures are less than Jan month than green
 | If Feb month figures are more than Jan month than red
Spreadsheet: mark_taylor__24701__epgofferanalysis (11-21-00)
Sheet: Annex 1.02

Deferred Payments @ 8.2481% Coupon
Payment | Date | Amortization | Principal | Interest | Payment
1 | 2001-05-15 00:00:00 |  | 2414352.629256787 |  | 14275208.86589462
 | 2001-08-15 00:00:00 |  | 7277360.574615832 |  | 14453648.9767183
 | 2001-11-15 00:00:00 |  | 7609324.957835639 |  | 14634319.58892728
 | 2002-02-15 00:00:00 |  | 7950449.146670907 |  | 14817248.58378887
 | 2002-05-15 00:00:00 |  | 8519479.378015881 |  | 15002464.19108623
 | 2002-08-15 00:00:00 |  | 8665599.58721802 |  | 15189994.99347481
 | 2002-11-15 00:00:00 |  | 9035629.297260087 |  | 15379869.93089324
 | 2003-02-15 00:00:00 |  | 9415725.231761303 |  | 15572118.30502941
 | 2003-05-15 00:00:00 |  | 10000495.14016634 |  | 15766769.78384227
 | 2003-08-15 00:00:00 |  | 10211117.73669155 |  | 15963854.4061403
 | 2003-11-15 00:00:00 |  | 10622951.4690341 |  | 16163402.58621706
 | 2004-02-15 00:00:00 |  | 11045841.4323138 |  | 16365445.11854477
 | 2004-05-15 00:00:00 |  | 11590700.06373261 |  | 16570013.18252658
 | 2004-08-15 00:00:00 |  | 11928140.41029977 |  | 16777138.34730816
 | 2004-11-15 00:00:00 |  | 12385836.4403846 |  | 16986852.52664951
 | 2005-02-15 00:00:00 |  | 12855669.28746361 |  | 17199188.18323263
 | 2005-05-15 00:00:00 |  | 13470845.31773195 |  | 17414178.03552303
 | 2005-08-15 00:00:00 |  | 13835655.35968142 |  | 17631855.26096707
 | 2005-11-15 00:00:00 |  | 14343691.96718953 |  | 17852253.45172916
 | 2006-02-15 00:00:00 |  | 14865045.45476285 |  | 18075406.61987577
 | 2006-05-15 00:00:00 |  | 15494635.44189267 |  | 18301349.20262422
 | 2006-08-15 00:00:00 |  | 15950922.0080414 |  | 18530116.06765702
 | 2006-11-15 00:00:00 |  | 16514162.52650854 |  | 18761742.51850273
 | 2007-02-15 00:00:00 |  | 17092007.94821677 |  | 18996264.29998402
 | 2007-05-15 00:00:00 |  | 17735306.34043928 |  | 19233717.60373382
 | 2007-08-15 00:00:00 |  | 18293930.35698813 |  | 19474139.07378049
 | 2007-11-15 00:00:00 |  | 18917681.48389436 |  | 19717565.81220275
 | 2008-02-15 00:00:00 |  | 19557443.01193846 |  | 19964035.38485528
Totals
 | Contingent Payments
 | If restructuring of Linden occurs:
 | After | On or Before
 | Closing | 2001-12-31 00:00:00 | 26103000
 |  | 2002-12-31 00:00:00 | 29235360
 |  | 2003-12-31 00:00:00 | 32743603.20000001
 | Thereafter |  | 36672835.58400001
Spreadsheet: 156442d1337286659-looping-if-function-to-a-new-sheet-ef95_pick-sheet-and-material-req-for-work-sheet
Sheet: Mat Reg

 |  |  |  | STOCK TRANSFER #:
CUSTOMER: |  |  |  |  | DATE:
LOCATION: |  |  |  |  | BRANCH:
FROM JOB #: |  |  |  |  | TO JOB #:
 |  |  |  | Material Order
QTY ORDER | Item | MATERIAL/PART NUMBER |  |  | QTY RETURN | QTY SOLD | CHECK BY DETAILS
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
DATE OUT |  |  |  |  | DATE IN
PICKED BY |  |  |  |  | VERIFIED
TAKEN BY |  |  |  |  | RETURNED BY
Spreadsheet: e71be82c-1385-48d2-8c6b-0032d56ae44a
Sheet: Sheet1

CAPITAL PROJECT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | North Congress /Barry road to M-152
Is  this ordinance for the following: |  |  |  |  | New Construction
 |  |  |  | X | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  |  | 2004-2005
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify source and amount.
 | Total amount is reimbursable by Missouri Finance Development Grant
 | If no, please identify source and amount of city funds.
 | AL-3650-897254 | 34957.32
 | 06-3090-897282 | 22728.14
If ordinance is for construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  |  | 196347.46
 | Estimated lifespan of project in years
 | Estimated annual operating and maintenance costs
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed.
Reference Numbers: (Previously approved legislation): |  |  |  |  | 040905
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 841731d1693908027-match-data-if-partial-match-and-greater-than-match-data-formula
Sheet: Sheet1

 | Data Columns |  |  |  | Desired Answer
 | Company Name | Product | Sales |  |  | Product A | Product B | Product C | Product D
 | Company A | Product A | 100 |  | Company A | Valid | Valid | Not Valid | Not Valid
 | Company A | Product B | 200 |  | Company B |  | Valid |  | Valid
 | Company A | Product C | 0 |  | Company C |  |  | Not Valid
 | Company A | Product D | -1 |  | Company D |  |  | Not Valid
 | Company B | Product B | 200
 | Company B | Product D | 200
 | Company B | Product C | 0
 | Company C | Product C | 0
 | Company D | Product C | 0
Spreadsheet: 136568d1326726100-summing-the-max-value-of-each-row-in-an-array-with-one-formula-sum-past-given-time
Sheet: Sheet1

Program ID | 1 | 2 | 4 | Result
00:00:00 | 0 | 0 | 50 | 50 |  |  |  | sum the results past |  | 0.125
01:00:00 | 0 | 25 | 50 | 50
02:00:00 | 100 | 25 | 50 | 100
03:00:00 | 0 | 25 | 20 | 20
23:00:00 | 0 | 25 | 0 | 0
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Sanctions

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Sanctions
Activity Description / Purpose | Penalizing the customer for non-compliance.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Record information in case notes
Update information in WMS
Redetermine eligibility
Apply sanction
Decision: Remain eligible? Now ineligible?
Close case if ineligible
Submit recovery of payment if necessary
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 823838d1680165485-connecting-formulas-to-option-buttons-runway-30-3-2022
Sheet: Mashareea

Decapolis for software
[NAME]
All Dates
 | Date | Transaction Type | Location | Due Date | Amount | Open Balance | Expected closing date
[NAME]
 | 23/02/2023 | [NAME] | All Locations | 09/03/2023 | 8655.08 | 8655.08 | 2023-03-04 00:00:00
 | 26/02/2023 | [NAME] | All Locations | 12/03/2023 | 4376.52 | 4376.52 | 2023-03-04 00:00:00
 | 26/02/2023 | [NAME] | All Locations | 12/03/2023 | 4312.77 | 4312.77 | 2023-03-04 00:00:00
 | 27/02/2023 | [NAME] | All Locations | 13/03/2023 | 722.26 | 722.26 | 2023-03-04 00:00:00
 | 03/03/2023 | [NAME] | All Locations | 17/03/2023 | 9481.51 | 9481.51 | 17/04/2023
 | 05/03/2023 | [NAME] | All Locations | 19/03/2023 | 10093.95 | 10093.95 | 17/04/2023
 | 06/03/2023 | [NAME] | All Locations | 20/03/2023 | 7466.55 | 7466.55 | 24/04/2023
 | 06/03/2023 | [NAME] | All Locations | 20/03/2023 | 120.62 | 120.62 | 24/04/2023
 | 10/03/2023 | [NAME] | All Locations | 24/03/2023 | 8323.59 | 8323.59 | 24/04/2023
 | 12/03/2023 | [NAME] | All Locations | 26/03/2023 | 10096.24 | 10096.24 | 30/04/2023
 | 13/03/2023 | [NAME] | All Locations | 27/03/2023 | 74.24 | 74.24 | 30/04/2023
 | 13/03/2023 | [NAME] | All Locations |  | -1365.21 | -1365.21
 | 13/03/2023 | [NAME] | All Locations | 27/03/2023 | 11434.5 | 11434.5 | 30/04/2023
Total for Sharekat Al Masharee' |  |  |  |  | 73792.62 | 73792.62
TOTAL |  |  |  |  | 73792.62 | 73792.62
Sunday, Mar 19, 2023 04:51:43 PM GMT+2
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: Saxet

Saxet Energy
Contract: various | 2000-03-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 477005 | 480660
VALUE | 1158432
NET RATE |  |  |  | 2.54
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
Is this an asset deal
Spreadsheet: 689533d1596486571-how-to-rank-without-duplicates-with-more-than-2-criteria-sample-1-
Sheet: Sheet1

Ranking with sumproduct |  |  |  | Result should be
Item A | Total Items | Percent A | Ranking
37 | 233 | 0.2489082969432314 |  | 3
37 | 233 | 0.238908296943231 |  | 2
37 | 199 | 0.2512562814070352 |  | 1
107 | 197 | 0.4692982456140351 |  | 4
107 | 199 | 0.2512562814070352 |  | 5
Rank with countifs |  |  | Ranking
54 | 142 | 58 |  | 2
54 | 142 | 57 |  | 1
54 | 148 | 56 |  | 4
54 | 145 | 59 |  | 3
Spreadsheet: 0e2411ac-2cbb-461a-a482-71d9129a04cc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  |  |  |  |  | Private and Confidential
 |  |  |  |  |  |  | Validus Holdings, Ltd.
 |  |  |  |  |  |  | [NAME] 31, 2012
 |  |  |  |  |  |  | 2013-01-29 14:00:40.110000
 |  |  |  |  |  |  | Validus Reinsurance, Ltd.
 |  |  |  |  |  |  | Bermuda Commercial Bank Building, 19 Par-la-Ville Road
 |  |  |  |  |  |  | [NAME], HM 11 Bermuda
 |  |  |  |  |  |  | Telephone: (441) 278-9000
 |  |  |  |  |  |  | Facsimile:   (441) 278-9090
 |  |  |  |  |  |  | Website:  [NAME]
 |  |  |  |  |  |  | Mailing Address: Suite 1790 48 Par-la-Ville Road
 |  |  |  |  |  |  | [NAME], HM 11 Bermuda
Spreadsheet: 677759d1589497794-how-to-use-multiple-index-and-match-in-the-multiple-conditions-sample-1r
Sheet: Data

INCIDENT_NUMBER | PART_NUMBER | SEGMENT1 | SEGMENT2 | RESOLUTION_CODE | PARTNUMBER_REPLACED | Checking
4526577 | P190 | SYS | IVI | REPLACE - MAIN PCBA
4526570 | P0885 | SYS | M | REPLACE - POWER SUPPLY PCBA
4526580 | P269 | SYS | M-TURB | REPLACE - MAIN PCBA | P19087-02
4526588 | P082 | SYS | EDG | REPLACE - BATTERY | P15051-20
4526579 | P076 | TRAN | REMAN | REPLACED END ITEM | P076
4526599 | P1932 | SYS | M | SCRAP
Fomula for: | First, find the part number replacement in the repair tab column F
 | Second, If the matching part number replaced is not found in the repair tab go to the PN tab to match it using column E and D
 | as long as column C is "SYS"
 | If the column C is 'TRAN" the return value will be the data in column B
Spreadsheet: 693167d1598819749-sumifs-greater-less-than-and-referencing-date-test-ex
Sheet: Eze Data

 | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date
12 | 06/30/2020 | 07/02/2020 | MSFT | US | Sell |  |  |  |  | 30593 | 247.3647 | 7567628.27 | 329098.572348 | 11351.44 | 493.647841 | 0 | 0 | 7556276.83 | 22.98 | 0 | 22.99502 | 328604.924381
Spreadsheet: ab280cdc-9d13-4ec5-94e3-bc91745f44cd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Table S1: List of all polymorphisms genotyped in this study
rs number | Alternative name** | gene | Chr | ancestral/reference | derived
 |  |  |  | [NAME] | [NAME]
[NAME] |  | [NAME] | 1 | G | C
rs2814778 | Duffy FyA/FyB | DARC | 1 | T | C
rs3024500 |  | IL10 | 1 | G | A
rs1800896 | IL10-1082 | IL10 | 1 | T | C
rs1800890 | IL10-3533 | IL10 | 1 | A | T
rs17047660 | McC(McCoy) | CR1 | 1 | A | G
rs17047661 | SI (Swain-Lanley) | CR1 | 1 | A | G
[NAME] |  | IL1A | 2 | G | T
rs1143634 | [NAME] | IL1B | 2 | G | A
rs708567 | IL17RE | IL17RE | 3 | C | T
rs187084 | TLR9 | TLR9 | 3 | G | A
rs6780995 | IL17RD | IL17RD | 3 | G | A
rs4833095 |  | TLR1 | 4 | C | T
rs5743611 |  | TLR1 | 4 | C | G
rs5743810 |  | TLR6 | 4 | G | T
rs5743809* |  | TLR6 | 4 | A | G
rs1801033 |  | C6 | 5 | T | G
rs2706384 |  | IRF1 | 5 | G | T
rs20541* |  | IL13 | 5 | G | A
rs2243250 | IL4 -589 | IL4 | 5 | C | T
rs2239704 | LTA+77 | LTA | 6 | C | A
rs909253 | LTA [NAME] | LTA | 6 | A | G
rs1799964 | TNFa-1031 | TNF | 6 | T | C
rs1800750 | TNF-376 | TNF | 6 | G | A
rs1800629 | TNF-308 | TNF | 6 | G | A
rs361525 | TNF-238 | TNF | 6 | G | A
rs3093662 | TNF+851 | TNF | 6 | A | G
rs2242665 | CTL4 | CTL4 | 6 | C | T
rs1555498 |  | IL20RA | 6 | C | T
rs2075820 |  | NOD1 | 7 | C | T
rs3211938 | CD36 T1264G | CD36 | 7 | T | G
None assigned | CD36 G1439C* | CD36 | 7 | G | C
rs17140229 |  | CFTR | 7 | T | C
rs4986790 |  | TLR4 | 9 | A | G
rs4986791 |  | TLR4 | 9 | C | T
rs8176746 |  | ABO | 9 | G | T
rs33950507* | HbE | HBB | 11 | C | Del
rs334 | [NAME] | HBB | 11 | T | A
rs7935564* |  | TRIM5 | 11 | G | A
rs542998 |  | RTN3 | 11 | T | C
[NAME]* |  | IL22 | 12 | T | C
rs1012356 |  | IL22 | 12 | A | T
rs2227491 |  | IL22 | 12 | T | C
rs2227485 |  | IL22 | 12 | G | A
rs2227478 |  | IL22 | 12 | G | A
rs229587 |  | SPTB | 14 | T | C
rs2230739 |  | ADCY9 | 16 | T | C
rs10775349 |  | ADCY9 | 16 | C | G
rs1805015 |  | IL4R | 16 | T | C
rs2535611 |  | ADORA2B | 17 | C | T
rs2297518 |  | NOS2 | 17 | G | C
rs12720463* | NOS2A-954 (or-969) | NOS2 | 17 | C | G
rs9282799* | NOS2A -1173 | NOS2 | 17 | G | A
[NAME] | NOS2A -1659 | NOS2 | 17 | G | A
rs373533 |  | EMR1 | 19 | C | A
rs461645 |  | EMR1 | 19 | A | G
rs1799969 | ICAM1 codon241 | ICAM1 | 19 | G | A
rs5498 | ICAM1 codon469 | ICAM1 | 19 | A | G
rs8386* | GNAS | GNAS | 20 | C | T
rs3177244 | DERL3 | DERL3 | 22 | G | A
rs3092945 | CD40LG-727 | CD40LG | X | T | C
rs1126535 | CD40LG+220 | CD40LG | X | T | C
rs1050829 | G6PD+376 | G6PD | X | T | C
rs1050828 | G6PD+202 | G6PD | X | C | T
All SNPs are referred to [NAME] and Ensemble build 63 and genome build GRCh37.5. * SNPs removed from analysis because they had
either a minor allele frequency less than 1% or due to high rates of missing genotype calls.**Alternative name from the literature or from
laboratory usage.
Spreadsheet: 88a05d6f-1742-4717-8b67-f7d33c5ab5f5
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
MSH2K | Test | MSH2K | MSH2 Known Mutation | MSH2 Known Mutation | Polymerase chain reaction (PCR)/DNA sequencing or dosage analysis (multiplex ligation-dependent probe amplification [MLPA] or Southern blot analysis) is utilized to test for the presence of a specific mutation previously identified in an affected family member. (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant  [NAME]: 3 mL  Collection Instructions:		 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. [NAME] (Supply T519) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemic	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 10 a.m. | 10 days | 16 days | 1 | 81296 |  |  |  |  | Rochester
MSH2K | [NAME] | VARIES | Varies |  |  |  | Ambient
MSH2K | Result | 17338 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
MSH2K | Result | 17340 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MSH2K | Result | 17341 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
MSH2K | Result | 17339 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MSH2K | Result | 17342 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MSH2K | Result | 17334 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
MSH2K | Result | 17336 | Source | Source | Alphanumeric
MSH2K | Result | 17343 | Reviewed By: | Reviewed By: | Alphanumeric
MSH2K | Result | 17344 | Release Date | Release Date | Alphanumeric
Spreadsheet: 155652d1337002236-excel-2007-simplify-multiple-vlookups-and-countifs-possible-example2
Sheet: Counter

Code | Name | 1-12M | 2 | 3 | 4 | 5 | Total | 3+ | 1-1M | 2 | 3 | 4 | 5 | PMonth:
Actor1 | John1
Actor2 | [NAME]
Actor3 | John3
Actor4 | John4
Actor5 | [NAME]
Actor6 | John6
Actor7 | [NAME]
Actor8 | John8
Actor9 | John9
Actor10 | [NAME]
Actor11 | John11
Actor12 | John12
Actor13 | [NAME]
Actor14 | [NAME]
Actor15 | John15
Actor16 | John16
Actor17 | John17
Actor18 | John18
Actor19 | John19
Actor20 | [NAME]
Actor21 | John21
Actor22 | John22
Actor23 | John23
Actor24 | [NAME]
Actor25 | [NAME]
Actor26 | [NAME]
Actor27 | [NAME]
Actor28 | [NAME]
Actor29 | John29
Actor30 | John30
Actor31 | [NAME]
Actor32 | John32
Actor33 | John33
Actor34 | John34
Actor35 | John35
Actor36 | John36
Actor37 | [NAME]
Actor38 | John38
Actor39 | [NAME]
Actor40 | [NAME]
Actor41 | John41
Actor42 | John42
Actor43 | John43
Actor44 | [NAME]
Actor45 | John45
Actor46 | John46
Actor47 | John47
Actor48 | [NAME]
Spreadsheet: 186637d1350129809-search-ef216b_beers
Sheet: Search

 | Brewery |  | Beer
Select Brewery:
Initial Letter | A
Full Name | Adnams
Spreadsheet: 781820d1653567933-a-formula-that-looking-in-sheet-1-and-if-the-name-matches-pulls-through-an-id-sample-of-report
Sheet: Access Requests - UAT

Full Name FORMULA (D and E) | First name | Last Name | Laptop ID
 | Fred | Bloggs | v541391
 | [NAME] | Smith | v541384
 | [NAME] | Smart | v541385
 | [NAME] | Jones | v541606
 | Martin | [NAME] | v541383
 | [NAME] | Soanes | v541386
 | Venkata | [NAME] | v541382