tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69642d1270168348-use-pivot-to-count-unique-entries-by-criteria-sumproduct-to-count-unique-entries-by-criteria-nothingisthis-sdg11
Sheet: Sheet1

ID | Name | CO | Grant_Date | Grant_Total |  | CO
91 | [NAME] | USA | 2006-07-13 00:00:00 | 1217 |  | China | 3 |  |  | '=SUMPRODUCT(--($C$2:$C$20=G2),1/COUNTIF($B$2:$B$20,$B$2:$B$20&""))
91 | [NAME] | USA | 2008-02-11 00:00:00 | 979 |  | Taiwan | 2
102 | [NAME] | China | 2003-01-31 00:00:00 | 880 |  | UK | 1
102 | [NAME] | China | 2008-02-11 00:00:00 | 1106 |  | USA | 3
102 | [NAME] | China | 2008-02-11 00:00:00 | 7050
108 | [NAME] | UK | 2008-02-11 00:00:00 | 22
187 | [NAME] | Taiwan | 2008-02-11 00:00:00 | 20860 |  |  |  |  |  | Sumproduct to count Unique Entries by Criteria - nothingisthis - SDG11.xls
187 | [NAME] | Taiwan | 2008-02-11 00:00:00 | 9690 |  |  |  |  |  | http://www.excelforum.com/excel-general/724019-use-pivot-to-count-unique-entries-by-criteria.html
234 | [NAME] | USA | 2008-02-11 00:00:00 | 523
234 | [NAME] | USA | 2008-02-11 00:00:00 | 979
206 | Louis | China | 2003-01-31 00:00:00 | 1760
206 | Louis | China | 2008-02-11 00:00:00 | 7050
206 | Louis | China | 2008-02-11 00:00:00 | 1383
543 | [NAME] | Taiwan | 2008-02-11 00:00:00 | 83
543 | [NAME] | Taiwan | 2008-02-11 00:00:00 | 56
332 | [NAME] | USA | 2008-02-11 00:00:00 | 1521
332 | [NAME] | USA | 2008-02-11 00:00:00 | 2820
555 | [NAME] | China | 2008-02-11 00:00:00 | 1521
555 | [NAME] | China | 2008-02-11 00:00:00 | 3995
Spreadsheet: monika_causholli__28198__Price Forecast
Sheet: Newsprint

Newsprint Forecast |  |  | $
Firm/Analyst | Units | Current | 2000 | 1Q01 | 2Q01 | 3Q01 | 4Q01 | 2001E | 1Q02 | 2Q02 | 3Q02 | 4Q02 | 2002E | 1Q03 | 2Q03 | 3Q03 | 4Q03 | 2003E | 2004E |  | Date |  | Notes
ABG Sundal Collier US | $/mt |  | 566 |  |  |  |  | 588 |  |  |  |  | 490 |  |  |  |  | 532 |  |  | 2001-09-03 00:00:00
ABG Sundal Collier EUR | $/mt |  | 529 |  |  |  |  | 626 |  |  |  |  | 610 |  |  |  |  | 641 |  |  | 2001-09-03 00:00:00
[NAME] | $/mt |  | 551 |  |  |  |  | 578 |  |  |  |  | 520 |  |  |  |  |  |  |  | 2001-09-26 00:00:00
CIBC Securities | $/mt |  | 565 |  |  |  |  | 590q |  |  |  |  | 540q |  |  |  |  |  |  |  | 2001-09-25 00:00:00 |  | 2001E decreased from 580 to 578 - 2002E decreased from 575 to 520
CS First Boston | $/mt |  | 506 |  | 613 | 585 | 548 | 588q | 540 |  |  |  | 570q |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  | 2001E decreased from 596 to 588. 2002E decreased from 598 to 570.
[NAME] | $/mt |  | 545 |  |  |  |  | 615 |  |  |  |  |  |  |  |  |  |  |  |  | 2001-02-08 00:00:00
Deutsche Bank | $/mt |  | 567 | 610 | 625 | 585 | 550 | 589 | 530 | 500 | 500 | 530 | 515q |  |  |  |  | 575 |  |  | 2001-09-25 00:00:00 |  | 2002E forecast decreased from 560 to 515
First Associate Investment Inc. | $/mt |  |  |  |  |  |  | 565 |  |  |  |  | 600 |  |  |  |  |  |  |  | 2001-08-20 00:00:00
JP Morgan | $/mt |  | 564 |  |  |  |  | 590 |  |  |  |  | 575q |  |  |  |  |  |  |  | 2001-09-27 00:00:00 |  | 2001E decreased from 600 to 590. 2002E decreased from 615 to 575
Lehman Brothers | $/mt |  | 558 |  |  |  |  | 576 |  |  |  |  | 583 |  |  |  |  | 676 |  |  | 2001-07-16 00:00:00
[NAME] | $/mt
[NAME] | $/mt
Merrill Lynch | $/mt |  | 564 |  |  | 583 | 540 | 590 | [NAME] | [NAME] | 580q | [NAME] | 570q | 620 | 660 | 660 | 660 | 650 | 660 |  | 2001-10-18 00:00:00 |  | 2002E for all Quarters decreased from 540;600;630;593 respectively
Morgan Stanley Dean Witter | $/mt
National Bank of Canada | $/mt | 560 | 559 |  | 617 | 580 |  | 580 |  |  |  |  | 535 |  |  |  |  |  |  |  | 2001-10-15 00:00:00
PPW | $/mt |  |  |  |  |  |  | 611 |  |  |  |  | 623 |  |  |  |  |  |  |  | 2001-08-23 00:00:00
[NAME] | $/mt |  |  |  |  |  |  | 590 |  |  |  |  | 580 |  |  |  |  |  |  |  | 2001-08-22 00:00:00
Salman Partners | $/mt |  |  |  |  |  |  | 600 |  |  |  |  |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00
Salomon Smith Barney | $/mt |  | 564 |  |  |  |  | 580 |  |  |  |  | 630 |  |  |  |  | 655 |  |  | 2001-05-29 00:00:00
Scotiabank | $/mt
TD Securities | $/mt |  |  |  |  |  |  | 569 |  |  |  |  | 563 |  |  |  |  |  |  |  | 2001-08-15 00:00:00
Spreadsheet: 26f8a426-2d8d-4fdb-863c-ca92a3a37a78
Sheet: Sheet1

[NAME OF HOSPITAL] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Inpatient Statistics
[YR1] - [YR7]
ITEMS | HISTORICAL |  |  | INTERIM |  | FORECAST
 |  |  |  |  |  | DURING CONSTRUCTION |  | COMPLETION
 | [YR1] | [YR2] | [YR3] | As of [MM] | Annualized | [YR4] | [YR5] | [YR6] | [YR7]
Total [NAME] (same as Hospital License)
Medical/Surgical/Swing
OB/GYN
[NAME] care
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Beds In Service
Medical/Surgical/Swing
OB/GYN
[NAME] care
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Discharges
Medical/Surgical
Swing
OB/GYN
[NAME] care
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Patient Days
Medical/Surgical
Swing
OB/GYN
[NAME] care
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Average Length of Stay
Medical/Surgical
Swing
OB/GYN
[NAME] care
Other (specify)
Total, Adult & Pediatric | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Newborn
GRAND TOTAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
(1) Data is requested for the prior three years (Historical), the current year (Interim), the year(s) of construction, and two full years after completion of construction (Forecasted).
(2) If the above data is available elsewhere in substantially the same form, you may submit such schedule therefore.
(3) Replace [YRX] with Actual Year (ex. 2005)
[NAME]
Spreadsheet: c34dde25-eaec-4f9d-9e87-71f02ca62f0a
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
PTSE | Test | PTSE | Platinum, Serum | Platinum, S | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1 | mL | Collection Container/Tube: Plain, royal blue-top Monoject trace element blood collection tube, product #8881-307006 (Supply T184) Submission Container/Tube: 7-mL Mayo metal-free, screw-capped, polypropylene vial (Supply T173) [NAME]: 1 mL Collection Instructions: 1. Allow the specimen to clot for 30 minutes; then centrifuge the specimen to separate serum from the cellular fraction. 2. Remove the stopper. Carefully pour specimen into a Mayo metal-free, polypropylene vial, avoiding transfer of the cellular components of blood. Do not insert a pipet into the serum to accomplish transfer, and do not ream the specimen with a wooden stick to assist with serum transfer. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Cisplatin Infusion, Peak: 0.6-1.8 mcg/mL Cisplatin Infusion, Trough: 0.1-0.4 mcg/mL Unexposed: <0.04 mcg/mL | Tuesday; 3 p.m. | 1 day | 7 days | 1 | 83789 |  |  |  |  | Rochester
PTSE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 30 days
PTSE | Result | 61749 | Platinum, S | Platinum, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 5714-1
Spreadsheet: 120452d1315311842-multi-filter-on-data-multi-filter
Sheet: Required result

UPPER LEVEL
COUNTRY |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Austria | Austria | a | 50 | 211 | 447 | 117 | 354 | 788 | 108 | 249 | 260 | 528 | 695 | 397
Austria | Austria | b | 30 | 482 | 47 | 221 | 351 | 224 | 684 | 29 | 304 | 581 | 744 | 834
Austria | Austria | c | 279 | 709 | 302 | 671 | 386 | 855 | 475 | 188 | 142 | 335 | 528 | 491
Austria | Austria | d | 513 | 814 | 208 | 590 | 58 | 768 | 248 | 763 | 257 | 786 | 743 | 175
LOWER LEVEL
COUNTRY |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Austria | Austria | a | 54 | 88 | 64 | 75 | 12 | 46 | 27 | 27 | 70 | 32 | 57 | 40
Austria | Austria | b | 64 | 64 | 15 | 73 | 76 | 72 | 55 | 79 | 63 | 60 | 72 | 59
Austria | Austria | c | 60 | 26 | 28 | 81 | 67 | 75 | 80 | 72 | 71 | 26 | 57 | 44
Austria | Austria | d | 39 | 66 | 25 | 42 | 77 | 20 | 14 | 12 | 22 | 89 | 78 | 67
OPTIMISE
COUNTRY |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Austria | Austria | a | 3 | 7 | 7 | 1 | 3 | 4 | 1 | 8 | 2 | 5 | 7 | 7
Austria | Austria | b | 2 | 2 | 5 | 4 | 8 | 7 | 7 | 5 | 6 | 2 | 2 | 7
Austria | Austria | c | 5 | 2 | 7 | 5 | 3 | 7 | 8 | 3 | 3 | 6 | 2 | 7
Austria | Austria | d | 8 | 1 | 8 | 8 | 6 | 6 | 8 | 1 | 5 | 5 | 6 | 3
TOTAL
COUNTRY |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Austria | Austria | a
Austria | Austria | b
Austria | Austria | c
Austria | Austria | d
Spreadsheet: 49523d1248882748-find-average-from-each-column-dcraker-sample-1-
Sheet: Cheryl

Results |  |  |  |  |  |  | Time standards exceeded
 |  |  | 401 | 41 | 0.1022443890274314 |  | h/prepping | time/s | masking | time/s | stuffing | time/s | labels | time/s | depanel | time/s | kiss | time/s | wave | time/s | stuffing/s | time/s | hand/s | time/s | touch up | time/s | wash | time/s
NAME | W/O | PROCESS | # OF BOARD | # OF REJECTS | % | TIME
CHERYL | 455884 | TOUCH UP | 30 | 10 | 0.3333333333333333 |  | 30 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 | 5
CHERYL | 687546 | TOUCH UP | 100 | 6 | 0.06 |  | 100 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 4
CHERYL | 488735 | REWORK SMT | 5 |  | 0
CHERYL | 489754 | hand solder and Touch up | 32 | 7 | 0.21875 |  |  |  |  |  | 32 | 3.9
CHERYL | 2449874 | TOUCH UP | 50 | 2 | 0.04 |  | 150 | 89.2
CHERYL | 1845761 | solder boards | 184 | 16 | 0.08695652173913043
Lists expands throughout the day
Needing to be able to get the average time from each row
and report it to the Results page with overall averages
Spreadsheet: 562f078b-8137-4b1b-9a25-ab7d39540b6d
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
FMTAG | Test | FMTAG | Murine Typhus Antibodies, IgG | Murine Typhus Antibodies, IgG | Indirect Fluorescent Antibody (IFA) |  |  |  | 1 | mL | Draw blood in a plain, red-top tube. (Serum gel tube is acceptable.) Spin down and send 1 mL serum in a screw-capped vial, shipped frozen. | 0.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm Reject; Cold OK Lipemia	NA Icteric	NA | Reference Interval: Negative               <1:64 Present or Past      1:64 Recent/Active       >1:64   Test Performed By:  LabCorp Burlington                               1447 York Court                               Burlington, NC  27215-2230 | Thursday | 1 day | 3 - 16 days | 1 | 86757 |  |  |  |  | LabCorp Burlington
FMTAG | [NAME] | SERUM | Serum |  |  |  | Frozen | 14 days
FMTAG | Result | FMTAG | Murine Typhus Antibodies, IgG | Murine Typhus Antibodies, IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 155995d1337129662-excel-2007-data-migration-help-change-log-v2
Sheet: Client_1

Date | Action | Item | Qty | UoM
2012-05-01 00:00:00 | In | Item_1 | 8 | EA
2012-05-02 00:00:00 | In | Item_2 | 7 | EA
2012-05-03 00:00:00 | Out | Item_3 | 2 | EA
2012-05-04 00:00:00 | Out | [NAME] | 5 | EA
2012-05-04 00:00:00 | In | Item_5 | 1 | EA
2012-05-04 00:00:00 | Out | [NAME] | 3 | EA
2012-05-04 00:00:00 | In | Item_7 | 13 | EA
2012-05-04 00:00:00 | In | Item_8 | 3 | EA
2012-05-04 00:00:00 | In | [NAME] | 6 | EA
2012-05-04 00:00:00 | Out | Item_10 | 1 | EA
2012-05-07 00:00:00 | Out | Item_11 | 3 | EA
2012-05-07 00:00:00 | In | Item_12 | 3 | EA
2012-05-07 00:00:00 | In | Item_13 | 6 | EA
2012-05-07 00:00:00 | Out | Item_14 | 1 | EA
2012-05-07 00:00:00 | Out | Item_15 | 2 | EA
2012-05-09 00:00:00 | Out | Item_16 | 3 | EA
2012-05-09 00:00:00 | In | Item_17 | 2 | EA
2012-05-09 00:00:00 | Out | Item_18 | 5 | EA
2012-05-09 00:00:00 | Out | Item_19 | 6 | EA
2012-05-10 00:00:00 | In | Item_20 | 34 | EA
2012-05-10 00:00:00 | Out | Item_21 | 1 | EA
2012-05-10 00:00:00 | In | Item_22 | 9 | EA
2012-05-12 00:00:00 | In | Item_23 | 10 | EA
2012-05-12 00:00:00 | In | Item_24 | 11 | EA
2012-05-13 00:00:00 | In | Item_25 | 12 | EA
2012-05-13 00:00:00 | Out | Item_26 | 1 | EA
2012-05-13 00:00:00 | Out | Item_27 | 3 | EA
2012-05-13 00:00:00 | In | [NAME] | 13 | EA
2012-05-13 00:00:00 | Out | Item_29 | 3 | EA
2012-05-13 00:00:00 | In | Item_30 | 6 | EA
2012-05-13 00:00:00 | In | Item_31 | 1 | EA
2012-05-13 00:00:00 | In | Item_32 | 3 | EA
2012-05-15 00:00:00 | Out | Item_33 | 3 | EA
2012-05-15 00:00:00 | Out | Item_34 | 21 | EA
2012-05-15 00:00:00 | In | Item_35 | 1 | EA
2012-05-15 00:00:00 | In | Item_36 | 23 | EA
Spreadsheet: 678070d1589702274-merge-two-rows-into-one-pq-group-by-sum-aligw
Sheet: Sheet1

Player | Team | Color | Points |  | Player | Team | Color | Points Total
[NAME] | [NAME] | White | 4 |  | [NAME] | [NAME] | White | 9
[NAME] | [NAME] | White | 2 |  | [NAME] | Tropics | Orange | 13
[NAME] | [NAME] | White | 3 |  | [NAME] | Gothics | Black | 4
[NAME] | Tropics | Orange | 6 |  | Nick | Bluedogs | Blue | 12
[NAME] | Tropics | Orange | 7 |  | [NAME] | Vixens | Yellow | 26
[NAME] | Gothics | Black | 4 |  | Mark | Bulls | Grey | 3
Nick | Bluedogs | Blue | 9
Nick | Bluedogs | Blue | 3
[NAME] | Vixens | Yellow | 5
[NAME] | Vixens | Yellow | 3
[NAME] | Vixens | Yellow | 10
[NAME] | Vixens | Yellow | 8
Mark | Bulls | Grey | 3
Spreadsheet: 677276d1589283386-finding-a-maximum-using-index-match-max-example
Sheet: Desired Output

 | Company A
2019-12-31 00:00:00
2019-11-30 00:00:00
2019-10-31 00:00:00
2019-09-30 00:00:00 |  | etc
2019-08-31 00:00:00
2019-07-31 00:00:00
2019-06-30 00:00:00
2019-05-31 00:00:00
2019-04-30 00:00:00
2019-03-31 00:00:00
2019-02-28 00:00:00
2019-01-31 00:00:00
2018-12-31 00:00:00
2018-11-30 00:00:00
2018-10-31 00:00:00
2018-09-30 00:00:00
2018-08-31 00:00:00
Spreadsheet: 836386d1689320648-count-number-of-rows-where-any-date-between-start-and-finish-are-between-2-dates-example-hd
Sheet: Sheet1

Start | Finish |  | 2023-05-15 00:00:00
 |  | Count:
2023-05-16 00:00:00 | 2023-06-19 00:00:00
2023-05-17 00:00:00 | 2023-06-23 00:00:00
2023-05-19 00:00:00 | 2023-07-03 00:00:00
2023-06-06 00:00:00 | 2023-07-27 00:00:00
2023-06-19 00:00:00 | 2023-08-02 00:00:00
2023-06-20 00:00:00 | 2023-07-28 00:00:00
2023-06-26 00:00:00 | 2023-08-03 00:00:00
2023-06-27 00:00:00 | 2023-07-31 00:00:00
2023-07-10 00:00:00 | 2023-08-11 00:00:00
2023-07-10 00:00:00 | 2023-08-11 00:00:00
2023-07-10 00:00:00 | 2023-08-04 00:00:00
2023-07-12 00:00:00 | 2023-08-08 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-13 00:00:00 | 2023-08-09 00:00:00
2023-07-17 00:00:00 | 2023-08-11 00:00:00
2023-07-18 00:00:00 | 2023-08-21 00:00:00
2023-07-19 00:00:00 | 2023-08-15 00:00:00
2023-07-21 00:00:00 | 2023-08-17 00:00:00
2023-07-25 00:00:00 | 2023-08-21 00:00:00
2023-07-25 00:00:00 | 2023-08-21 00:00:00
2023-08-08 00:00:00 | 2023-09-04 00:00:00
2023-08-17 00:00:00 | 2023-09-20 00:00:00
2023-08-21 00:00:00 | 2023-09-22 00:00:00
2023-08-21 00:00:00 | 2023-09-22 00:00:00
2023-08-21 00:00:00 | 2023-09-15 00:00:00
2023-08-21 00:00:00 | 2023-09-01 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-23 00:00:00 | 2023-09-19 00:00:00
2023-08-25 00:00:00 | 2023-09-21 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-08-30 00:00:00 | 2023-09-27 00:00:00
2023-09-06 00:00:00 | 2023-10-04 00:00:00
Spreadsheet: sally_beck__35225__Global Hot List 1109
Sheet: Hotlist - Completed

E N R O N   G L O B A L   M A R K E T S  -  H O T  L I S T |  |  |  |  |  |  |  |  |  |  |  | 4Q00 DEALS COMPLETED
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  |  |  |  |  |  |  | Energy West |  | 26
 |  | SUBTOTAL
 |  |  |  |  |  |  |  | SUBTOTAL
 |  | Coal Origination & Finance
 |  | Deal |  | Value |  |  |  | Global Risk Markets
 |  |  |  |  |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  | Deal |  | Value |  |  |  | Deal |  | Value
 |  | SUBTOTAL |  |  |  |  |  | SUBTOTAL
 |  |  |  |  |  |  |  | TOTAL DEALS COMPLETED
Spreadsheet: 863763d1711141302-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-dj
Sheet: Game 3

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00 |  |  |  |  | #[NAME]!
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1) |  |  | [NAME] | 44
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  | 6 | C (2) |  | Ty | Cobb | 2
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  | 6 | 1B (3) |  | [NAME] | Gehrig | 4
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  | 6 | 2B (4) |  | [NAME] | Henerson | 22
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  | 6 | 3B (5) |  | [NAME] | Mantle | 7
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  | 6 | SS (6) |  | Willie | Mays | 24
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  | 6 | LF (7) |  | [NAME] | Musial | 6
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  | 6 | CF (8) |  | [NAME] | [NAME] | 20
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  | 6 | RF (9) |  | Babe | [NAME] | 3
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  | 6 | SF (10) |  | [NAME] | [NAME] | 20
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  | 6 | EH () |  | [NAME] | [NAME] | 9
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 768551d1645023518-count-different-type-of-text-and-give-me-text-and-sum-of-numbers-count_something
Sheet: English (3)

 |  | STATE
 | Anne | NY
 | Nina
 | [NAME] | FL
 | [NAME] | MO
 | [NAME]
 | Sigrid | NY
 | [NAME]
 | Heida
 | Sandra
 | Eva
 |  | NY | 2
 |  | FL | 1
 |  | MO | 1
 |  | How to get excel to give me this result?
Spreadsheet: 877366d1724179307-vlookup-and-mean-formulas-new-pcm-draft-megans-copy-no-macros
Sheet: Asbestos Count Sheet

ASBESTOS INSPECTION AIR MONITORING RESULTS
Location: | 275 7A Ave South |  |  |  |  |  |  | Date(s): | Aug 8-10 2024
 | Lethbridge, AB |  |  |  |  |  |  | Project No.: | SES24220
Client: | Paul Davis Restoration Inc. |  |  |  | Analysis Method: |  | NIOSH 7400 Asbestos and Other Fibres by PCM
SAMPLE NO. | SAMPLE LOCATION | SAMPLE TIME |  |  | FLOW (L/min) | SAMPLE VOLUME (L) | FIBRE COUNT | REPORTED FIBRES | NO. OF FIELDS | Vlookup for blanks | Raw Fibre Density (f/mm2) | [NAME] (f/mm2) | Raw Fibre Conc. (f/mm2) | [NAME]. (f/cc)
 |  | ON | OFF | MINS
2024-08-08 00:00:00
24220-1 | Clean Room (Back Entry) | 1904-01-01 09:35:00 | 1904-01-01 12:15:00 |  | 16 |  | 15.5 |  | 100
24220-2 | North Ext. (Neg Air Exhaust) | 1904-01-01 09:35:00 | 1904-01-01 12:15:00 |  | 11 |  | 0 |  | 100
24220-3 | Basement | 1904-01-01 09:40:00 | 1904-01-01 12:17:00 |  | 16 |  | 17 |  | 100
24220-5 | Field Blank |  |  |  | 0 |  | 0 |  | 100
24220-6 | North Ext. (Neg Air Exhaust) | 1904-01-01 12:15:00 | 1904-01-01 15:40:00 |  | 11 |  | 5 |  | 100
24220-7 | Basement | 1904-01-01 12:17:00 | 1904-01-01 15:45:00 |  | 16 |  | 11 |  | 100
24220-8 | Occupational: [NAME] | 1904-01-01 15:23:00 | 1904-01-01 15:44:00 |  | 2.5 |  | 18.5 |  | 100
2024-08-09 00:00:00
24220-9 | Clean Room (Back Entry) | 1904-01-01 09:10:00 | 1904-01-01 11:50:00 |  | 16 |  | 14 |  | 100
24220-10 | North Ext. (Neg Air Exhaust) | 1904-01-01 09:10:00 | 1904-01-01 11:50:00 |  | 11 |  | 2 |  | 100
24220-11 | Basement | 1904-01-01 09:12:00 | 1904-01-01 11:53:00 |  | 16 |  | 16.5 |  | 100
24220-12 | Clean Room (Back Entry) | 1904-01-01 11:50:00 | 1904-01-01 15:45:00 |  | 16 |  | 6 |  | 100
24220-13 | North Ext. (Neg Air Exhaust) | 1904-01-01 11:50:00 | 1904-01-01 15:45:00 |  | 11 |  | 4 |  | 100
24220-14 | Basement | 1904-01-01 11:53:00 | 1904-01-01 15:47:00 |  | 16 |  | 18 |  | 100
2024-08-10 00:00:00
24220-15 | Main Floor FINAL | 1904-01-01 09:05:00 | 1904-01-01 11:50:00 |  | 16 |  | 0 |  | 100
Blanks
24220-4 | Field Blank |  |  |  | 0 |  | 0 |  | 100
24220-16 | Field Blank |  |  |  | 0 |  | 0 |  | 100
Spreadsheet: 29cf46c8-7337-4484-8243-3fa2f781645b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8907 | 25800 | [NAME] | [NAME] | GER | 265 | [NAME] | 00:01:13 | [NAME] | 00:01:03 | 00:20:30 | 1 | 01:18:14
8907 | 55772 | [NAME] | [NAME] | GER | 266 | 00:20:04 | 00:01:03 | 00:39:21 | 00:02:05 | [NAME] | 2 | 01:31:26
Spreadsheet: 869542d1716147807-empty-row-after-every-group-of-data-book1-gk-v2-aligw
Sheet: Sheet1

 |  | User Enter three columns
 |  | Region | Employee | Product |  |  |  | Employee | Pro-1 | Pro-2 | Pro-3 | Pro-4
 |  | REG-1 | Emp-1 | Pro-1 |  |  | REG-1 | Emp-1 | x
 |  | REG-1 | Emp-2 | Pro-2 |  |  | REG-1 | Emp-2 |  | x
 |  | REG-1 | Emp-3 | Pro-4 |  |  | REG-1 | Emp-3 |  |  |  | x
 |  | REG-1 | Emp-4 | Pro-2 |  |  | REG-1 | Emp-4 |  | x
 |  | REG-1 | Emp-5 | Pro-1 |  |  | REG-1 | Emp-5 | x
 |  | REG-1 | Emp-6 | Pro-2 |  |  | REG-1 | Emp-6 |  | x
 |  | [NAME] | Emp-1 | Pro-3 |  |  | [NAME] | Emp-1 |  |  | x
 |  | [NAME] | Emp-2 | Pro-2 |  |  | [NAME] | Emp-2 |  | x
 |  | [NAME] | Emp-3 | Pro-3 |  |  | [NAME] | Emp-3 |  |  | x
 |  | [NAME] | Emp-4 | Pro-2 |  |  | [NAME] | Emp-4 |  | x
 |  | REG-3 | Emp-1 | Pro-3 |  |  | REG-3 | Emp-1 |  |  | x
 |  | REG-3 | Emp-2 | Pro-2 |  |  | REG-3 | Emp-2 |  | x
 |  | REG-3 | Emp-3 | Pro-3 |  |  | REG-3 | Emp-3 |  |  | x
 |  | REG-3 | Emp-4 | Pro-2 |  |  | REG-3 | Emp-4 |  | x
 |  | REG-4 | Emp-1 | Pro-3 |  |  | REG-4 | Emp-1 |  |  | x
 |  | REG-4 | Emp-2 | Pro-1 |  |  | REG-4 | Emp-2 | x
 |  | REG-4 | Emp-3 | Pro-3 |  |  | REG-4 | Emp-3 |  |  | x
 |  | REG-4 | Emp-4 | Pro-2 |  |  | REG-4 | Emp-4 |  | x
 |  | REG-5 | Emp-5 | Pro-1 |  |  | REG-5 | Emp-5 | x
 |  | REG-5 | Emp-6 | Pro-3 |  |  | REG-5 | Emp-6 |  |  | x
 |  |  |  |  |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  | Grand Total |  | 0.2 | 0.4 | 0.35 | 0.05