tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 06587209-5403-4ce2-b700-f65172cb46b8
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
FDANT | Test | FDANT | [NAME], Serum/Plasma | [NAME] | Spectrofluorometry (SF) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 1 mL of serum refrigerate in a plastic vial. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum).   [NAME] blood in a lavender-top (EDTA) tube(s). ([NAME] tube  is not acceptable.) Spin down and send 1 mL of EDTA  plasma refrigerate in a plastic vial. Note:	1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma). | 0.3 mL | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, EDTA, heparin Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Reporting limit determined each analysis   Synonym(s):  Dantrium   Usual therapeutic range:  0.2-3.5 mcg/mL   Test Performed By:  NMS Labs                                        3701 Welsh Road                                        P.O. Box 433A                                        [NAME], PA  19090-0437 | Monday | 1 day | 3 -10 days | 1 | 80299 |  |  |  |  | NMS Labs
FDANT | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FDANT | Result | Z1449 | [NAME] | [NAME] | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 9746-9
FDANT | Result | Z1859 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: e71218b8-f5c2-43ef-bd53-32c00bda8963
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
LIME | Test | LIME | Lime, IgE | Lime, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
LIME | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LIME | Result | LIME | Lime, IgE | Lime, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7464-1
Spreadsheet: 752878d1635051377-sumifs-of-different-sheets-on-the-basis-of-header-24102021-sample-format-for-excel-forum
Sheet: Summary

 | From Date | 2021-04-01 00:00:00
 | To Date | 2022-03-31 00:00:00
Month | TOTAL_ ACTUAL_COMMISSION | BASIC_PREMIUM_AMOUNT
2021-04-01 00:00:00 | 134907 | 18571.16 | <<<< I REQUIRE THESE RESULTS
2021-05-01 00:00:00 | 322227 | 40613.03 | <<<< I REQUIRE THESE RESULTS
2021-06-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2021-07-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2021-08-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2021-09-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2021-10-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2021-11-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2021-12-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2022-01-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2022-02-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
2022-03-01 00:00:00 |  |  | <<<< I REQUIRE THESE RESULTS
Spreadsheet: 755772d1637083451-how-to-average-the-first-5-non-zero-numbers-in-a-list-scoring-example1
Sheet: Handicap (2)

Name | Average Score | New Scores to be inserted before "C"
Player 1 |  | 0 | 84 | 0 | 86 | 87 | 0 | 84 | 85 | 86 | 87 | 0 | 99
Player 2 |  | 98 | 99 | 89 | 87 | 0 | 98 | 99 | 89 | 87 | 0
Player 3 |  | 84 | 0 | 90 | 0 | 0 | 84 | 0 | 90 | 0 | 0
Player 4 |  | 75 | 78 | 0 | 89 | 0 | 75 | 78 | 0 | 89 | 0
Player 5 |  | 89 | 98 | 85 | 91 | 0 | 89 | 98 | 85 | 91 | 0
Player 6 |  | 0 | 0 | 85 | 87 | 88 | 0 | 0 | 85 | 87 | 88
Player 7 |  | 84 | 0 | 90 | 0 | 0 | 84 | 0 | 90 | 0 | 0
Player 8 |  | 75 | 78 | 0 | 89 | 0 | 75 | 78 | 0 | 89 | 0
Player 9 |  | 89 | 98 | 85 | 91 | 0 | 89 | 98 | 85 | 91 | 0
Player 10 |  | 0 | 0 | 85 | 87 | 88 | 0 | 0 | 85 | 87 | 88
Spreadsheet: 288b4fce-9d83-4b57-867e-536ba89eb2b0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42344299 | 2014-07-17 23:45:25 | AXIS | 1 | 6 | 1 | 443223 | southoftheborder | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
42344469 | 2014-07-18 00:15:54 | ALLIES | 1 | 6 | 1 | 443223 | southoftheborder | 8708 | western | 1944-07-25 | 1944-07-25 | Operation Spring | Opération Spring
Spreadsheet: 691922d1597948834-separate-values-by-different-delimiters-count-values
Sheet: Sheet1 (2)

Jurisdiction
Affinity Health Plans
[NAME], Nose & Throat Clinic, Baptist Medical Center, Cancer Care Specialists of Central Illinois, Coastal Carolina Health Care, PC
Boston Medical Center Corporation, HITECH, MA
Central Florida Health Alliance
Boston Medical Center Corporation, HITECH, MA
Dean McGee Eye Institute, Emerson Hospital
Eastern Great Lakes Pathology
Boston Medical Center Corporation, HITECH, MA
Allscripts Healthcare, LLC, HITECH, IL
Boston Medical Center Corporation, HITECH, MA
HITECH, Riverside Medical Center
HITECH, State of Vermont, Department of Health Access, VT
Medical Data Systems, Inc
Boston Medical Center Corporation, HITECH, MA
Outpatient Imaging, P.C.,
Rotech Healthcare Inc
San Joaquin County Health Commission d/b/a Health Plan of San Joaquin, and San Joaquin Health Admin
Sarasota Memorial Hospital
Boston Medical Center Corporation, HITECH, MA
UCSF Medical Center
Unity Point - Quicy Medical Group
Boston Medical Center Corporation, HITECH, MA
Advanced Data Systems Corporation, HITECH, NY
HITECH
Automated Health Systems
Allscripts Healthcare, LLC, HITECH, OR
Allscripts Healthcare, LLC, HITECH, IL
Boston Medical Center Corporation, HITECH, MA
Abeo Management Corporation, Bozeman Deaconess Hospital, Central Utah Clinic, P.C, DermSoft LLC, [NAME], Fletcher Allen Healthcare Care | University of Vermont Medical Center, HITECH
Allscripts Healthcare, LLC, HITECH, OR
Advanced Data Systems Corporation, HITECH, NJ, NY
Allscripts Healthcare, LLC, HITECH, OR
Greenway Health
Anesthesia Associates of La Porte, P.C.
HITECH, IN, Indiana University Health
AU medical Center formerly MGC Health Inc
Norton Healthcare, The Methodist Hospital (Houston Methodist)
Our Lady of Lourdes Memorial Hospital, Inc, ProHealth Solutions LLC
HITECH, ProHealth Solutions LLC, Professional Emergency Care
Allscripts Healthcare, LLC, HITECH, OR
HITECH, NC
North Broward Hospital District
HITECH
County of Fairfax, HITECH, VA
Computer Programs and Systems, Inc
Boston Medical Center Corporation, HITECH, MA
[NAME] Health
Skagit Valley Hospital
[NAME], LLC
CA, HITECH, Palomar Pomerado Health System
Allscripts Healthcare, LLC, HITECH, IL
Boston Medical Center Corporation, HITECH, MA
Boston Medical Center Corporation
Suburban Radiologists, S.C. Services
Allscripts Healthcare, LLC, HITECH, WI
Delta Dental Plan of Illinois
Allscripts Healthcare, LLC, HITECH, MO
Boston Medical Center Corporation
Spreadsheet: 867790d1714577812-viewing-all-text-in-cells-tree-schedule
Sheet: Sheet1

T | Tree Number | Tree Species | Height (m) | Stem or Base Ø (mm) | N - Radius (m) | S - Radius (m) | E - Radius (m) | W - Radius (m) | Category
T | 1 |  | 10 |  | 0 | 0 | 0 | 0 | A1
T | 2 |  | 10 |  | 0 | 0 | 0 | 0 | A1
T | 3 |  | 10 |  | 0 | 0 | 0 | 0 | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  | 10 |  |  |  |  |  | A1
 |  |  |  |  |  |  |  |  | A1
Spreadsheet: 136f7aa5-0b0f-4274-b884-205098e8c251
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
FEDERAL FUNDING REQUEST
For All Federal Non-SAPT Block Grant Funding
Ohio Department of Alcohol & Drug Addiction Services
1. Funding source:  Please select funding source.
STAR SI |  |  | Safe & Drug Free Schools
Underage Drinking 2007 |  |  | Underage Drinking 2008
Access to Recovery |  |  | Other (Please Specify)
2. Header Information:
Agency/Board Name:
For ODADAS USE ONLY:
Purchase Order #: |  | Vendor Number: |  |  | Payment Address/EFT:
3. Expenses  SFY 2009
Program Category |  | Actual Expenses Thru   (Enter Date) | Projected Expenses Thru  (Enter Date) | Total | Funds Received To Date | Period Request | Total Award/ Allocation | Available Balance
 |  | (A) | (B) | (C=A+B) | (D) | (E=C-D) | (F) | (G=F-D-E)
2020D - Drug Free Schools |  |  |  | 0 |  | 0 |  | 0
2020G - Underage Drinking |  |  |  | 0 |  | 0 |  | 0
2080L - Access To Recovery |  |  |  | 0 |  | 0 |  | 0
2150E - STAR SI (see NOTE) |  |  |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  | 0
TOTAL |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOTE:  For STAR SI drawdown requests - the first drawdown request for the current fiscal year cannot exceed 25% of the total allocated.  Federal regulations require that all federal funds be drawn down on a reimbursement basis and/or no more than thirty (30) days in advance of projected expenditures.  NO FUNDS WILL BE DISBURSED UNLESS COLUMNS A-G ARE COMPLETED.
4. CERTIFICATION
I certify that the financial information shown in this funding request is correct.
Requestor's Signature/Title |  |  |  | Phone Number |  |  | Date
Board Executive Director's Signature |  |  |  | Phone Number |  |  | Date
Spreadsheet: 89485d1289276565-how-to-copy-the-function-to-the-next-cell-by-skipping-every-two-columns-sample-tony
Sheet: Sheet1

 |  |  |  |  | human |  |  | 4 | 4 | 6
bee |  | human
 | cat |  |  | dophin
 |  | dophin |  |  | dophin
 |  |  |  | lion |  |  |  |  | How to paste the formula in cell
 | lion |  |  |  |  |  |  |  | I4 with substitution from C&D to
 |  |  | tiger |  |  |  |  |  | A&B automatically ?
 | human |  | human
 |  |  |  |  | rat
 |  |  |  | elephant
Spreadsheet: 46019d1244799719-read-only-the-number-value-of-a-cell-forum-sample
Sheet: Sheet1

[NAME]
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | # [NAME] | Not Out | Runs | High Score | 4s | 6s | Average
 | 41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
23 | 41 | 77 | 75 | 0 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 2
 |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
0 | 0 |  | 4 | 33 | 69* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 8
 |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
4 | 8 | 50* | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  | 26 | 21 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1
1* | 8* |  | 8* | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
19 |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | 10 | 12 | 17 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 3
22 | 31 | 0 | 11 | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
6 | 12 |  | 3 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
0 |  | 16* | 2 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1
 | 6 | 9 |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
0 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
1
 | 5*
 |  |  |  |  | 62* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 1
 |  |  | 0* | 4*
Spreadsheet: 48342d1247571966-finding-a-text-in-a-list-against-a-specific-item-and-returning-the-text-in-new-sheet-lookup-text
Sheet: Sheet2

 | Store Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data
 | Store 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Store 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Store 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z
 | Store 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Store 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Store 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z
 | Store 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Store 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Store 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z
 | Store 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Store 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Store 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z
 | Store 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Store 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Store 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z
 | Store 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
 | Store 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y
 | Store 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Z
Spreadsheet: 871468d1717876051-detect-double-posting-under-the-same-credit-card-number-sample-datas
Sheet: Sheet1

DATA |  |  |  |  |  | RESULT
Credit Card | Cabin | Name | Amount |  |  | No | Credit Card | Cabin | Name | Amount
43** XXXX XXXX 4672 | 41517 | [NAME] | 3 |  |  | 1 | 43** XXXX XXXX 4672 | 41517 | [NAME] | 3
43** XXXX XXXX 4672 | 41517 | [NAME] | 2 |  |  | 2 | 43** XXXX XXXX 4672 | 41517 | [NAME] | 2
43** XXXX XXXX 4672 | 41517 | [NAME] | 1 |  |  | 3 | 41** XXXX XXXX 9976 | 12746 | [NAME] | 600
43** XXXX XXXX 4672 | 41517 | [NAME] | -1 |  |  | 4 | 41** XXXX XXXX 9976 | 12746 | [NAME] | 600
41** XXXX XXXX 9976 | 12746 | [NAME] | 600 |  |  | 5 | 44** XXXX XXXX 9529 | 16724 | [NAME], [NAME] | 508.1
41** XXXX XXXX 9976 | 12746 | [NAME] | 600 |  |  | 6 | 44** XXXX XXXX 9529 | 16724 | [NAME], [NAME] | 185.1
44** XXXX XXXX 6731 | 10146 | Thurner, [NAME] | 209.87 |  |  | 7 | 42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | 180.54
44** XXXX XXXX 6731 | 10146 | Thurner, [NAME] | -209.87 |  |  | 8 | 42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | 511.23
44** XXXX XXXX 6731 | 10146 | Thurner, [NAME] | 209.87
44** XXXX XXXX 9529 | 16724 | [NAME], [NAME] | 218.11
44** XXXX XXXX 9529 | 16724 | [NAME], [NAME] | 508.1
44** XXXX XXXX 9529 | 16724 | [NAME], [NAME] | -218.11
44** XXXX XXXX 9529 | 16724 | [NAME], [NAME] | 185.1
42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | 511.23
42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | 180.54
42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | -511.23
42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | 100.57
42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | -100.57
42** XXXX XXXX 1165 | 13308 | Hagen, [NAME] | 511.23
Spreadsheet: 141459d1329283677-show-part-codes-only-whose-have-book-qty-bal-in-pivot-table-pivot
Sheet: Sheet1

 | Material | Material Description | SLoc | Book Bal. | Price | Total Amount | Phy.Bal.
 | [PHONE] | CRANK CASE COMP RIGHT P19 | AL01 | 7002 | 248.09 |  | 0
 | [PHONE] | CRANK/C COMP.RIGHT(CSTG.) | AL01 | 4526 | 248.48 |  | 0
 | 11100-KPH-9000C | CRANK CASE COMP.  RIGHT | AL01 | 0 | 0 |  | 0
 | 11100-KPH-9000C | CRANK CASE COMP.  RIGHT | ST01 | 100 | 0 |  | 0
 | 11100-KTC-9210 | CRANK CASE COMP.RIGHT ( CORE 1) | AL01 | 114 | 264.57 |  | 0
 | 11100-KTC-A000 | CRANK CASE COMP.RIGHT ( CORE 1) SPS MMC | AL01 | 98 | 305.42 |  | 0
 | 11100-KTC-A200 | CRANK CASE COMP.RIGHT GLRM 11 | AL01 | 442 | 369.41 |  | 0
 | 11100-KTC-AA10 | CRANK CASE COMP.RIGHT(CSTG) | AL01 | 1 | 264.35 |  | 0
 | 11100-KTC-AA30 | CRANK CASE COMP RIGHT (CSTG) | AL01 | 274 | 305.2 |  | 0
 | 11100-KTC-AAA0 | CRANK CASE RIGHT (CSTG) | AL01 | 429 | 370.32 |  | 0
 | 11100-KWA-9000 | CRANK CASE COMP. R (BLK) | AL01 | 535 | 267.94 |  | 0
 | 11100-KWA-AA00 | CRANK CASE COMP RIGHT (CASTING) | AL01 | 3 | 268.63 |  | 0
 | 11100-KWH-9600 | CRANK CASE COMP. RIGHT SPR | AL01 | 2000 | 269.6 |  | 0
 | 11100-KWH-AA60 | CRANK CASE COMP.RIGHT(CSTG) | AL01 | 7572 | 270.59 |  | 0
 | 1132A-KST-9400 | PLATE OIL SEPARATE SUB. ASSY. | ST01 | 142 | 46.43 |  | 0
 | 1132A-KST-9400 | PLATE OIL SEPARATE SUB. ASSY. | AL01 | 0 | 46.43 |  | 0
 | 1132A-KWA-9300 | PLATE OIL SEPARATE SUB ASSY | ST01 | 541 | 46.97 |  | 0
 | 1132A-KWA-9300 | PLATE OIL SEPARATE SUB ASSY | AL01 | 0 | 46.97 |  | 0
 | 1132A-KWA-9400 | PLATE OIL SEPARATE SUB ASSY | ST01 | 54 | 51.63 |  | 0
 | 1132A-KWA-9400 | PLATE OIL SEPARATE SUB ASSY | AL01 | 0 | 51.63 |  | 0
Spreadsheet: 698357d1601944842-how-to-create-a-vlookup-from-different-sources-vlookup
Sheet: SOURCE 1

MAIN SOURCE
SOURCE 1
BIL | FORM | NAME | NO 1 | NO 2 | IMK |  |  |  |  |  | HOLLAND | INDEX | KOD
3 | 3G | [NAME] | [PHONE] | BN11558 | R|20 | S|16 | E|12 | K|8 | [NAME] | I|6 | R(20)|S(16)|E(12) | 14
2 | 3F | FELIX | [PHONE] | BN11557 | S|20 | R|18 | A|17 | K|15 | I|14 | E|12 | S(20)|R(18)|A(17) | 8
1 | 3E | RAYMOND | [PHONE] | BN11556 | K|20 | S|18 | R|17 | I|12 | E|10 | A|7 | K(20)|S(18)|R(17) | 13
4 | 3A | SIMON | [PHONE] | BN11559 | S|13 | R|12 | I|10 | [NAME] | A|9 | E|6 | S(13)|R(12)|I(10) | 7
Spreadsheet: 749257d1632650593-counting-details-from-multiple-sheets-file_ans
Sheet: Vehicle Three

Log
SR.# | DATE | SALES EXECUTIVE |  | [NAME] | [NAME] | [NAME] | Ashraf [NAME] | [NAME] | [NAME] | [NAME]. [NAME] | [NAME]
1 | 2021-09-01 00:00:00 | Savanna
2 | 2021-09-04 00:00:00 | Krystin
3 | 2021-09-04 00:00:00 | [NAME]
4 | 2021-09-05 00:00:00 | Isobel
5 | 2021-09-07 00:00:00 | [NAME]
6 | 2021-09-11 00:00:00 | Savanna
7 | 2021-09-11 00:00:00 | Krystin
8 | 2021-09-12 00:00:00 | [NAME]
9 | 2021-09-14 00:00:00 | Isobel
10 | 2021-09-14 00:00:00 | [NAME]
11 | 2021-09-15 00:00:00 | Savanna
12 | 2021-09-15 00:00:00 | Krystin
13 | 2021-09-16 00:00:00 | [NAME]
14 | 2021-09-18 00:00:00 | Isobel
15 | 2021-09-18 00:00:00 | [NAME]
16 | 2021-09-18 00:00:00 | Savanna
17 | 2021-09-21 00:00:00 | Krystin
18 | 2021-09-22 00:00:00 | [NAME]
19 | 2021-09-23 00:00:00 | Isobel
20 | 2021-09-25 00:00:00 | [NAME]
21 | 2021-09-25 00:00:00 | Savanna
Spreadsheet: 674253d1587735129-list-multiple-pages-and-remove-duplicates-test123
Sheet: Wednesday

 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Carmen Pace
 | [NAME]
 | [NAME]
Total
Spreadsheet: 847913d1698758068-conditional-formatting-of-referenced-cells-conditional-formatting-example
Sheet: Item 2

 | Goal | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | YTD
Disposition |  | 100 | 100 | 12 | 62 | 98 | 100 | 65 | 12 | 18 |  |  |  | 63
Source Code |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Source Code tab, line 3
Template |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Template tab, line 3
Submittal |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expecting results from Submittal tab, line 3
Spreadsheet: 873022d1719474544-help-with-formulas-to-populate-from-one-sheet-with-dynamic-data-to-another-sheet-as-a-list-auto-list
Sheet: Sheet1

 | Help Column fake | Help Column fake | Last Position | SAILED DATE | Current POSITION | OP | ETS | CARGO |  | NEXT Position1 | OP1 | ETA1 | NEXT Position 2 | OP2 | ETA2 | NEXT Position 3 | ETA3 | OP3 | NEXT Position 4 | ETA4 | OP4
 |  |  |  |  |  |  |  | TYPE | QTY
Sample-Bravo | yes | No | previous | 2024-06-25 00:00:00 | start | Discharge | 2024-06-28 00:00:00 | candy | 200 | a | Loading | 2024-06-19 00:00:00 | b | Discharge | 2024-07-10 00:00:00 | c | 2024-07-15 00:00:00 | Loading | d | 2024-07-30 00:00:00 | Discharge
Bravo | yes | No
Spreadsheet: 62265d1263239067-poker-payout-calculator-percentage-20calculator-1-
Sheet: Sheet1

TABLE 1 |  |  | TABLE 2
Buy-in amount £ | 10 |  | Total £ | 0
No. of buy-ins | 30
Total £ |  |  | no. of buy-ins |  | 1 to 6 |  | 7 to 20 |  | 21 to 30 |  | 31 to 40
1 |  |  | 1 | 0.75 |  | 0.5 |  | 0.5 |  | 0.4
2 |  |  | 2 | 0.25 |  | 0.3 |  | 0.25 |  | 0.25
3 |  |  | 3 |  |  | 0.2 |  | 0.15 |  | 0.2
4 |  |  | 4 |  |  |  |  | 0.1 |  | 0.1
5 |  |  | 5 |  |  |  |  |  |  | 0.05
I'd like the table on the left to show the same results as the table on the right but using a simpler format. I have used a simple formula to calculate the total cash pot available by  multiplying the buy in amount by the number of buy ins. What I require is that the payout positions 1-5 are automatically generated based on the number of buy-ins. For example if the total number of buy ins is <7 then only positions 1 and 2 are filled but if the number of buy ins is between 21 and 30 then the top 4 places are filled in, all based on the percentages of the total cash available shown in B3. The table on the right is one i currently use and works but is a little bigger than it needs to be. Would it also be possible to show the percentages of the cash pot along with the £ amount for reference. The buy in amount is variable depending on tournament so the table needs to allow for this. Feel free to add/remove columns/edit as necessary.
Spreadsheet: 831990d1686046486-if-function-with-3-conditions-within-column-new-microsoft-excel-worksheet
Sheet: ND

Reference standard Purity (%P): | 0,46
 | RT | Peak area of Progesterone
Reference sol.  a (0,2%) | 17.089 | 28588
 | RT | Peak area of Impurity H
Reference sol.  d | 13.766 | 99044
System suitability
Peak to valley ratio between Progesterone & Impurity M |  |  | specification (P/V) [NAME] 4.0 | 22.98
Test solution |  |  | Reference solution d
Weight(g) | 1 |  | Weight(mg) | 10.15
Volume (mL) | 25 |  | Volume (mL) | 25
Label claim (mg/g) | 10 |  | Purity (%P) | 0.46
Ctest (mg/mL) |  |  | Cref (mg/mL)
Test solution
241 nm
Name | Rt | Area | Result | Calculation
Impurity I | 1 | 0
Impurity B | 1 | 0
Impurity C | 1 | 0
Impurity D & E | 1 | 0
Impurity G | 1 | 0
Impurity J | 1 | 0
Impurity K | 1 | 0
Impurity L | 1 | 0
Impurity M | 0.05 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
 | 1 | 0
Impurity H (286 nm) | 13.851 | 0
%Total
[NAME] (%): | 0.05 | %Content any impurity = Atest/Astd *0,2
BRT: Below Reporting Threshold |  | %Content impurity H = Atest/Aref *(Cref)/(Ctest) *%P
ND: Not Detected |  | %Total = % any impurity content (exc. Imp. I) + % impurity H content
Analyst |  |  |  | Reviewer