tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0b00624a-2325-4a35-aa9b-d89f98e4540b
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
AMYL | Test | AMYL | Amyloidosis, Transthyretin-Associated Familial, DNA Sequence, Blood | Familial Amyloidosis, DNA Sequence | Polymerase Chain Reaction (PCR) Amplification/DNA Sequencing (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 | [NAME] must arrive within 96 hours of draw.   [NAME] blood 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. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) 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. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Thursday; 10 a.m. | 14 days | 20 days | 1 | 81404 |  |  |  |  | Rochester
AMYL | [NAME] | VARIES | Varies |  |  |  | Ambient
AMYL | Result | 22635 | [NAME] | [NAME] | Alphanumeric
AMYL | Result | 22636 | [NAME] | [NAME] | Alphanumeric
AMYL | Result | 22637 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
AMYL | Result | 22638 | Order Date | Order Date | Alphanumeric
AMYL | Result | 22639 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
AMYL | Result | 22640 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
AMYL | Result | 22641 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21674-7 | FGFR2 gene mutation analysis:Prid:Pt:Bld/Tiss:Nom:Molgen
AMYL | Result | 22642 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
AMYL | Result | 22643 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21674-7 | FGFR2 gene mutation analysis:Prid:Pt:Bld/Tiss:Nom:Molgen
AMYL | Result | 22644 | Reviewed By: | Reviewed By: | Alphanumeric
AMYL | Result | 22645 | Release Date | Release Date | Alphanumeric
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 103999 | 0 | 31627
Cross-Currency Fixed-Fixed | 0 | 2499 | 0 | 1162
Cross-Currency Fixed-Float | 0 | 13231 | 0 | 6828
TOTAL | -
Spreadsheet: 115681d1311217595-data-required-in-cells-engineering-shift-report-register-upload
Sheet: Shift Report Register

Date of Breakdown | Engineer | Equipment Type | Equipment Description | Start Time | End Time | Duration | Problem | Remedy | Parts used | Further Action | Status | Date Completed | Date of Breakdown + 30 | Date/Time Logged | User Details
2011-07-20 00:00:00 | [NAME] | Mobile Packing - PRP-01 | Pressure Pot, Tube Seal Tester | 08:30:00 | 11:00:00 | 02:30:00 |  |  |  |  |  |  | 2011-08-20 00:00:00
Spreadsheet: 044fcb92-162a-4ff0-b4c7-800a982c9f49
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | SURVEY PROGRAM CODE | [NAME] | CONTACT | PHONE
 | AW | Ambient Watershed Monitoring | [NAME] | [PHONE]
 | BN | [NAME] | [NAME] | [PHONE]
 | C2 | Coastal Probabilistic Program | [NAME] | [PHONE]
 | [NAME] | Near Shore Oceanic Probabilistic Special Study | [NAME] | [PHONE]
 | CB | Water Quality and Habitat Monitoring (CBM) | [NAME] | [PHONE]
 | CM | Citizen Monitoring requests performed by DEQ | [NAME] | [PHONE]
 | DM | Dominion Virginia City Hybrid Energy Center | [NAME] | [PHONE]
 | FI | Facility Inspections | [NAME] | [PHONE]
 | FP | Ambient Freshwater Probabilistic | [NAME] | [PHONE]
 | FT | Fish Tissue and Sediment Program | [NAME] | [PHONE]
 | HG | South River South Fork of the Shenandoah River 100 Year Mercury Study | [NAME] | [PHONE]
 | IM | Post TMDL Implementation Monitoring | [NAME] | [PHONE]
 | IR | Incident Response | [NAME] | [PHONE]
 | LB | Lafayette River Bacteriological Sampling | [NAME] | [PHONE]
 | OE | Observed Effects (3C Waters with Observed Effects / Insufficient Data) | [NAME] | [PHONE]
 | PC | Pollution Complaint Investigation/Spill containment (Prep) | [NAME] | [PHONE]
 | PF | Pfiesteria Special Study | [NAME] | [PHONE]
 | QA | Quality Assurance | [NAME] | [PHONE]
 | RB | [NAME] | [NAME] | [PHONE]
 | RL | Reservoir Monitoring | [NAME] | [PHONE]
 | SH | Sheanandoah Fish Kill | [NAME] | [PHONE]
 | SS | Special Studies | [NAME] | [PHONE]
 | TM | TMDL Activities | [NAME] | [PHONE]
 | TR | Ambient Trend Program | [NAME] | [PHONE]
 | TW | Waters of Concern | [NAME] | [PHONE]
Spreadsheet: 151556d1334966510-using-vlookup-funtion-within-if-statement-test_1-1-
Sheet: DataLists

 |  |  |  |  |  |  |  |  | SERVICE TAX EXTRA |  |  |  |  |  | Age | Sum Insured (in Lacks) | No of Persons
 |  |  | MEMBER | 0-25YRS | 26-35YRS | 36-40YRS | 41-45YRS | 46-50 YRS | 51-55 YRS | 56-60 YRS | 61-65 YRS |  |  |  | 0-25YRS | 2 | 1A
2 LAKH |  | 1A | MEMBER-1 | 2575 | 3075 | 3575 | 4275 | 6625 | 7275 | 9074 | 10123 |  |  |  | 26-35YRS | 3 | 1C
 |  | 1C | MEMBER-2 | 3353 | 4073 | 4733 | 5573 | 9288 | 10198 | 13164 | 14985 |  |  |  | 36-40YRS | 4 | 2A
 |  | 2A | MEMBER-3 | 4016 | 4944 | 5749 | 6665 | 11108 | 12200 | 15759 | 17944 |  |  |  | 41-45YRS | 5 | 1A+1C
 |  | 1A+1C | MEMBER-4 | 4612 | 6007 | 6876 | 7975 | 13292 | 14602 | 18562 | 21140 |  |  |  | 46-50 YRS | 7.5 | 2C
 |  | 2C |  |  |  |  |  |  |  |  |  |  |  |  | 51-55 YRS | 10 | 2A+1C
 |  | 2A+1C |  |  |  |  |  |  |  |  |  |  |  |  | 56-60 YRS | 15 | 3A
 |  | 3A |  |  |  |  |  |  |  |  |  |  |  |  | 61-65 YRS |  | 1A+2C
 |  | 1A+2C |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3C
 |  | 3C |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1A+3C
 |  | 1A+3C |  |  |  |  |  |  |  |  |  |  | Age | Members | [NAME] | Amount | 2A+2C
 |  | 2A+2C |  |  |  |  |  |  |  |  |  |  | 0-25 | Member1 | 2 | 2575 | 3A+1C
 |  | 3A+1C |  |  |  |  |  |  |  |  |  |  |  | Member2 |  |  | 4A
 |  | 4A |  |  |  |  |  |  |  |  |  |  |  | Member3 |  |  | 4C
 |  | 4C |  |  |  |  |  |  |  |  |  |  |  | Member4 |  |  | 1A
 |  | 1A
3 LAKH |  | 1A | MEMBER-1 | 3625 | 4275 | 4775 | 5715 | 7992 | 8779 | 10545 | 13250
 |  | 1C | MEMBER-2 | 4718 | 5363 | 6129 | 7445 | 11202 | 12303 | 15817 | 19874
 |  | 2A | MEMBER-3 | 5420 | 6413 | 7332 | 8764 | 13404 | 14726 | 18943 | 23812
 |  | 1A+1C | MEMBER-4 | 6227 | 7547 | 8631 | 10322 | 16048 | 17634 | 22694 | 28064
 |  | 2C
 |  | 2A+1C
 |  | 3A
 |  | 1A+2C
 |  | 3C
 |  | 1A+3C
 |  | 2A+2C
 |  | 3A+1C
 |  | 4A
 |  | 4C
 |  | 1A
Spreadsheet: 735352d1622882948-cell-value-multiplication-by-criteria-prob
Sheet: Sheet1

No | Part Number | Description | QTY | Mass | Bounding Box  Length | Bounding Box  Width | Sheet Metal  Thickness | Total QtY
1 | [NAME] |  | 3 | 1.12
1.1 |  | Lakštas | 1 | 0.08 | 82.6 | 82.6 | 2 | 3
1.2 |  | Lakštas | 3 | 0.21 | 128.7 | 128.7 | 2 | 9
1.3 |  | Lakštas | 1 | 0.42 | 412.6 | 42 | 3 | 3
2 | TOT_Part |  | 5 | 0.07
2.1 |  | Lakštas | 1 | 0.07 | 92.1 | 30 | 3 | 5
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 15d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche | 1398 | 2020 | 19677 | 30 | 260 | 24424
Index | 30920 | 87419 | 106786 | 15131 | 49570 | 43065
Europe | - | - | 103611 | - | - | 42032
North America/Asia | 30920 | 87419 | 1742 | 15131 | 49570 | 315
Other | - | - | 1433 | - | - | 718
OTHER* | - | - | 56419 | - | - | 18959
TOTAL | 32318 | 89439 | 182882 | 15161 | 49830 | 86448
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: louise_kitchen__23837__2QYTD Orig w notes
Sheet: East Gas

East Gas
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
DePaolis |  | Gas |  | East
[NAME] |  | Gas |  | East
Kaiser |  | Gas |  | East |  | 1459732
Muhl |  | Gas |  | East |  | 756363
Ferries |  | Gas |  | East
Concannon |  | Gas |  | East |  | 550919
Smith,[NAME] |  | Gas |  | East
Barbe |  | Gas |  | East |  | 447936.42
DeMoes |  | Gas |  | East |  | 150517
Hodge |  | Gas |  | East |  | 100279.16
Singer |  | Gas |  | East
[NAME] |  | Gas |  | East
Miscellaneous |  | Gas |  | East |  | -10927
Total
Spreadsheet: 673195d1587241942-counting-until-a-certain-number-then-restart-counting-book1
Sheet: Sheet1

NUM | CHK
1 | 1
0
2
0
0
0
2
0
3
1
3
1
0
2
1
0
Spreadsheet: 96556d1295949559-how-to-use-the-function-rate-future-value-calculator
Sheet: Sheet1

PV = | 3000 |  | 3000
Monthly Return Rate = | 0.03437 |  | #N/A
Period = | 12 |  | 12
FV = | 4500.204487835742 |  | 4500
Annual Return = | 1500.204487835742 |  | 1500
Monthly Return = | 125.0170406529785 |  | 125
Weekly Return = | 34.09555654172141
Daily Return = | 2.841296378476784
Spreadsheet: 689579d1596529697-shade-cells-in-staff-rota-if-staff-are-at-work-rota-edit-copy-copy
Sheet: WEEK A

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A WEEK |  |  |  | Task A |  |  |  |  |  |  | Task B |  |  |  |  |  |  | Task C |  |  |  |  |  |  | MANAGEMENT
SUNDAY
 | 00:00:00 |  |  |  | 01:00:00 |  |  |  | 02:00:00 |  |  |  | 03:00:00 |  |  |  | 04:00:00 |  |  |  | 05:00:00 |  |  |  | 06:00:00 |  |  |  | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00                                                19:00
Staff A
Staff B
Staff C
Staff D
Staff E
Staff F
Staff G
Staff H
Staff I
Staff J
Staff K
 | 00:00:00 |  |  |  | 01:00:00 |  |  |  | 02:00:00 |  |  |  | 03:00:00 |  |  |  | 04:00:00 |  |  |  | 05:00:00 |  |  |  | 06:00:00 |  |  |  | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00
Spreadsheet: tracy_geaccone__40573__EA Alloc to Other BUs - Support
Sheet: Research

Research
Analysis of I/C Billings
 |  | 2001 Forecast |  |  |  |  |  | 2002 Plan
 |  | $ |  | % |  | HC |  | $ |  | % |  | HC
Total Direct Expense |  | 8626794 |  |  |  | 53 |  | 13032023 |  |  |  | 67
Allocation to other business units
RAC |  | 748754 |  |  |  |  |  | 2867045
EES Wholesale |  | 1316177 |  |  |  |  |  | 2085124
ETS |  | 485000 |  |  |  |  |  | 651601
Europe |  | 233986 |  |  |  |  |  | 260640
EIC |  | 116999 |  |  |  |  |  | 0
ESS |  | 116999 |  |  |  |  |  | 0
EBS |  | 1335671
ECM |  | 97493 |  |  |  |  |  | 0
EGM |  | 1745150
ELO |  | 116999 |  |  |  |  |  | 0
Total
Net to ENA
Note
2002 Plan Direct Expense and allocations to business units include Bonus Accrual.
Spreadsheet: 138208d1327570189-indirect-cekks-cio-testing-sheet-draft
Sheet: 2010

year | 2012
Name | ID no. | spelling | maths | reading
 |  | 10 | 50 | 1
 |  | 11 | 55 | 2
 |  | 12 | 65 | 3
 |  | 13 | 70 | 4
 |  | 14 | 75 | 5
 |  | 15 | 80 | 6
 | State Average | 12 | 50 | 6
Spreadsheet: 682816d1592337105-hidden-caret-symbol-cannot-be-deleted-using-find-and-replace-example-of-caret-problem
Sheet: Sheet1

 | MCP-1 |  |  |  | MCP-2 |  |  |  | MTP-1 |  |  |  | MD P-1 |  |  |  | MD SP-2
Date | DTW | Elevation | Dry? | Notes | DTW | Elevation | Dry? | Notes | DTW | Elevation | Dry? | Notes | DTW | Elevation | Dry? | Notes | DTW | Elevation | Dry? | Notes
1948-06-29 00:00:00
1948-07-07 00:00:00
1948-07-14 00:00:00
1948-07-21 00:00:00
1948-08-04 00:00:00
1948-08-13 00:00:00
1948-08-20 00:00:00
1948-09-01 00:00:00
1948-09-10 00:00:00
1948-09-21 00:00:00
1948-09-25 00:00:00
1948-09-30 00:00:00
1948-10-09 00:00:00
1948-10-13 00:00:00
1948-10-18 00:00:00
1948-10-22 00:00:00
1948-10-29 00:00:00
1948-11-10 00:00:00
1948-11-12 00:00:00
1948-11-29 00:00:00
1948-12-09 00:00:00
1949-01-05 00:00:00
1949-01-20 00:00:00
1949-02-23 00:00:00
1949-03-22 00:00:00
1949-04-25 00:00:00
1949-06-20 00:00:00
1949-07-29 00:00:00
1949-08-29 00:00:00
1949-09-30 00:00:00
1949-10-28 00:00:00
1949-11-26 00:00:00
1949-12-27 00:00:00
1950-01-26 00:00:00
1950-03-06 00:00:00
1950-09-01 00:00:00
1952-02-04 00:00:00
1952-03-17 00:00:00
1952-05-19 00:00:00
1952-08-05 00:00:00
1956-01-06 00:00:00
1956-01-18 00:00:00
1956-01-24 00:00:00
1956-02-01 00:00:00
1956-02-08 00:00:00
1956-02-15 00:00:00
1956-02-21 00:00:00
1956-02-29 00:00:00
1956-03-07 00:00:00
1956-03-14 00:00:00
1956-03-21 00:00:00
Spreadsheet: 806353d1669250071-dynamically-updating-file-path-based-on-date-cell-within-a-vlookup-dynamic-dates
Sheet: Sheet1

Date | HE | Name | Value (Manual) | Variable | Tableau Total | Check | Date 2 | Value (Dynamic) |  |  |  |  | Inputs
2022-11-01 00:00:00 | 1 | Trade Account Net |  | Trade Acount | 993.25 |  |  |  |  |  |  |  | Fiscal Year
2022-11-01 00:00:00 | 2 | Trade Account Net |  | Trade Acount | 1033 |  |  |  |  |  |  |  | Current Yer
2022-11-01 00:00:00 | 3 | Trade Account Net |  | Trade Acount | 1044 |  |  |  |  |  |  |  | Current Day
2022-11-01 00:00:00 | 4 | Trade Account Net |  | Trade Acount | 1109 |  |  |  |  |  |  |  | Current Month
2022-11-01 00:00:00 | 5 | Trade Account Net |  | Trade Acount | 1109 |  |  |  |  |  |  |  | Year-Month
2022-11-02 00:00:00 | 6 | Trade Account Net |  | Trade Acount | 583
2022-11-02 00:00:00 | 7 | Trade Account Net |  | Trade Acount | -942.75
2022-11-02 00:00:00 | 8 | Trade Account Net |  | Trade Acount | -729
2022-11-02 00:00:00 | 9 | Trade Account Net |  | Trade Acount | 31
2022-11-02 00:00:00 | 10 | Trade Account Net |  | Trade Acount | -67
2022-11-03 00:00:00 | 11 | Trade Account Net |  | Trade Acount | -116
2022-11-03 00:00:00 | 12 | Trade Account Net |  | Trade Acount | -51
2022-11-03 00:00:00 | 13 | Trade Account Net |  | Trade Acount | 25
2022-11-03 00:00:00 | 14 | Trade Account Net |  | Trade Acount | -2
2022-11-03 00:00:00 | 15 | Trade Account Net |  | Trade Acount | 166
2022-11-04 00:00:00 | 16 | Trade Account Net |  | Trade Acount | 114.5
2022-11-04 00:00:00 | 17 | Trade Account Net |  | Trade Acount | 362
2022-11-04 00:00:00 | 18 | Trade Account Net |  | Trade Acount | 559
Spreadsheet: 698746d1602158011-searching-for-company-names-that-are-different-between-two-sheets-mr-excel-search-ans
Sheet: Sheet1

CUSTOMER | [NAME] | [NAME]
CUSTOMER A LIMITED | Z | D
CUSTOMER B LIMITED | Y | E
CUSTOMER C LIMITED | X | F
CUSTOMER D LIMITED | W | G
CUSTOMER E LIMITED | V | H
CUSTOMER F LIMITED | U | i
CUSTOMER G LIMITED | T | J
CUSTOMER H LIMITED | S | K
CUSTOMER I LIMITED | R | L
Spreadsheet: 767900d1644705893-what-if-analysis-to-calculate-the-effect-of-new-pricing-example-calculation
Sheet: Desired Result

 |  |  |  |  |  |  |  |  | Product 1 |  | Product 2 |  | Product 3 |  | Product 4 |  | Sum of Quantity | Sum of Amount
Org. | Product 1 | Product 2 | Product 3 | Product 4 | Last Order # | Last Order Date | # Orders 2021 | Account | Quantity | Amount | Quantity | Amount | Quantity | Amount | Quantity | Amount |  |  | Average Price
Reseller 1 | 28.95 |  | 49.95 |  | 10 | 2021-12-01 00:00:00 |  | AAA | 10 |  |  |  | 210
Reseller 2 |  |  |  | 49.95 | 20 | 2021-04-30 00:00:00 |  | BBB | 20 |  |  |  |  |  | 15
Reseller 3 | 26.95 |  |  |  | 100 | 04/05/2021 |  | CCC | 949
Distributor 1 | 19.7 | 20 | 23.4 |  | 1500 | 07/09/2021 |  | DDD | 29000 |  | 9600 |  | 45000
Distributor 2 | 19.5 | 20 | 23.65 | 30 | 10 | 2021-08-03 00:00:00 |  | EEE | 53000 |  | 1200 |  | 14500 |  | 5000
Distributor 3 | 20 | 19.7 | 23.4 | 23.05 | 12 | 10/19/2021 |  | FFF | 28000 |  | 162000 |  | 48000 |  | 125000
New pricing from Current Sales based on org type, product, and order quantity in Pricing Schedule
Updated calculation
Spreadsheet: chris_stokley__3893__Enron True-Upcorrect
Sheet: Sheet2

Harbor True-Up Action Itens
 |  |  |  |  |  |  |  | Net
 | Gas Purchase |  | Gas Sale |  | Services Profit |  |  | Profit
Month | $ | EnPower | $ | EnPower | $ | EnPower |  | $
Jul '00 | 1344508 | 598642.1 | 1336995.67 | 598971.1 | 2843.83 | 598971.1
Aug. | 2233882.21 | 598642.2 | 2211292.1 | 598971.2 | 143934.91 | 598971.2
Sep | 1696221.8 | 598642.3 | 1696221.18 | 598971.3 | 73284.24 | 598971.3
Oct | 828966.58 | 598642.4 | 828966.58 | 598971.4
Nov | 531351.27 | 598642.5 | 531351.27 | 598971.5
Dec | 616304.42 | 598642.6 | 616304.42 | 598971.6
Jan '01 | 1760192.17 | 598642.7 | 1760192.17 | 598971.7
Feb | 195421.1 | 598642.8 | 195421.1 | 598971.8
Mar
Spreadsheet: 50943d1250530959-sumproduct-range-sumproduct-range-vasto-sdg09
Sheet: Sheet1

1 | 0 |  | between 0-9 | < 9 |  | Today, 01:28 PM
2 | 1 |  | 168 | 180 |  | vasto |  | SUMPRODUCT Range - vasto - SDG09.xls
3 | 2 |  |  |  |  | Registered User   Join Date: 08 Dec 2008
4 | 3 |  |  |  |  | Location: montreal
5 | 4 |  |  |  |  | Posts: 36
6 | 5 |  |  |  |  | sumproduct range
7 | 6 |  |  |  |  | http://www.excelforum.com/excel-general/696004-sumproduct-range.html
8 | 7 |  |  |  |  | Trying to sum values in column A, if values in column B have a range between 0-9.
9 | 8 |  |  |  |  | or can we use less than < 9.
10 | 9 |  |  |  |  | using Sumproduct formula
11 | 0
12 | 1
13 | 2
14 | 3
15 | 4
16 | 5
17 | 6
18 | 7
19 | 8
20 | 9
Spreadsheet: 703642d1605096951-search-box-for-named-ranges-test-case-files
Sheet: Dashboard

 |  | SEARCH |  |  |  |  | I would like the case files to be shown here for example
 | Issues | Current Status | Details | region | responsible person | starting week | Note | total cases | Link to the summary (dont touch)
 | CASE1 | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter
 | CASE2 | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter
 | CASE3 | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter
 | CASE4 | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter
 | CASE5 | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter | Doesn’t matter
Spreadsheet: 684286d1593266836-how-to-count-same-numbers-products-from-another-data-from-each-rows-c2-i1000000-inventory
Sheet: Data

Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G
JA-0090-20 | SS-002245 | 574 | 576 | 578 | 580 | 582 | 584 | 586
JA-0090-21 | SS-002246 | 01 | 2985 | 02 | 668 | 88855 | 09 | 888
JA-0090-22 | SS-002247 | 580 | 582 | 584 | 586 | 588 | 590 | 592
JA-0090-23 | SS-002248 | 565 | 567 | 569 | 571 | 573 | 575 | 577
JA-0090-24 | SS-002249 | 566 | 568 | 570 | 572 | 574 | 576 | 578
JA-0090-25 | SS-002250 | 567 | 569 | 571 | 573 | 575 | 577 | 579
JA-0090-26 | SS-002251 | 568 | 570 | 572 | 574 | 576 | 578 | 580
JA-0090-27 | SS-002252 | 569 | 571 | 573 | 575 | 577 | 579 | 581
JA-0090-28 | SS-002253 | 125666 | 125667 | 15 | 556 | 557 | 5599 | 556
JA-0090-29 | SS-002254 | 571 | 573 | 575 | 577 | 579 | 581 | 583
JA-0090-30 | SS-002255 | 572 | 574 | 576 | 578 | 580 | 582 | 584
JA-0090-31 | SS-002256 | 573 | 575 | 577 | 579 | 581 | 583 | 585
JA-0090-32 | SS-002257 | 574 | 576 | 578 | 580 | 582 | 584 | 586
JA-0090-33 | SS-002258 | 575 | 577 | 579 | 581 | 583 | 585 | 587
JA-0090-34 | SS-002259 | 576 | 578 | 580 | 582 | 584 | 586 | 588
JA-0090-35 | SS-002260 | 577 | 579 | 581 | 583 | 585 | 587 | 589
JA-0090-36 | SS-002261 | 333 | 67345986 | 475 | 6664423 | 323 | 67987 | 345934
JA-0090-37 | SS-002262 | 579 | 581 | 583 | 585 | 587 | 589 | 591
Spreadsheet: 169236d1342736521-merge-3-spreadsheets-into-1-master-worksheet-with-conditions-merge_sample_19jul12
Sheet: household

MPO | SURVEY | SAMPN | STRATA | DAY | RIBUS | WABIK | HHVEH | HHSIZ
1 | 2 | 4000001 | 3 | 7 | 2 | 1 | 2 | 3
1 | 1 | 4000064 | 4 | 2 | 2 | 2 | 3 | 3
1 | 1 | 4000066 | 3 | 2 | 2 | 2 | 1 | 1
1 | 2 | 4000136 | 3 | 1 | 2 | 2 | 2 | 2
1 | 2 | 4000154 | 2 | 2 | 2 | 2 | 2 | 1
1 | 2 | 4000158 | 1 | 1 | 2 | 2 | 2 | 2
1 | 1 | 4000160 | 2 | 1 | 2 | 2 | 2 | 2
1 | 2 | 4000176 | 2 | 3 | 2 | 2 | 2 | 2
1 | 2 | 4000193 | 1 | 1 | 2 | 2 | 1 | 1
Spreadsheet: 072e9fb9-86d1-4752-8db7-0a7e23e5d848
Sheet: Zones GC-3N,4N,4Y

Permit No.: |  |  | WQ0005790 |  |  | Facility Name: |  | Oak Island WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did conjunctive utilization occur at this facility? |  |  |  |  |  | Field Name: |  | GC-3N |  | Field Name: |  | [NAME] |  | Field Name: |  | GC-4Y |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 1.6 |  | Area (acres): |  | 0.6 |  | Area (acres): |  | Zones GC-3N,4N,4 |  | Area (acres):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage             (if applicable) | 5-Day Upset              (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading (gallons):
Spreadsheet: 888538d1739053566-update-needed-to-formula-to-only-show-data-for-month-sample-sheet-holger2
Sheet: January

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | 2025-01-01 00:00:00
 | [NAME]
 |  |  |  |  |  |  |  |  | = test date array in above formula for yes/no
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  | Team Score |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  | Team Score
 |  |  |  | Team Score
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score