tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 20bc2010-bc49-4033-8781-c2cc5f56eae5
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
APO1S | Test | APO1S | Apolipoprotein A-I (APOA1) Gene, Full Gene Analysis | APOA1 Gene, Full Gene Analysis | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 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. 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. 2. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Wednesday 10 am | 14 days | 20 days | 1 | 81479 |  |  |  |  | Rochester
APO1S | [NAME] | VARIES | Varies |  |  |  | Ambient
APO1S | Result | 33382 | [NAME] | [NAME] | Alphanumeric
APO1S | Result | 33383 | [NAME] | [NAME] | Alphanumeric
APO1S | Result | 33384 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
APO1S | Result | 33385 | Order Date | Order Date | Alphanumeric
APO1S | Result | 33386 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
APO1S | Result | 33387 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
APO1S | Result | 33388 | Result | Result | Alphanumeric
APO1S | Result | 33389 | Interpretation | Interpretation | Alphanumeric
APO1S | Result | 33390 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
APO1S | Result | 33391 | Reviewed By | Reviewed By | Alphanumeric
APO1S | Result | 33392 | Release Date | Release Date | Alphanumeric
Spreadsheet: 589a05b1-8385-417e-accc-960907e565dd
Sheet: Sheet1

Release: State Leading Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=208
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-19 3:18 AM CDT
 | Real-Time | Period
Name: | Start | End
State Leading Indexes | 2011-02-01 00:00:00 | Current
Link:
http://www.philadelphiafed.org/research-and-data/regional-economy/indexes/leading/ | 2011-02-01 00:00:00 | Current
Source:
Federal Reserve Bank of Philadelphia | 2011-02-01 00:00:00 | Current
Notes:
The leading index for each state predicts the six-month growth rate of | 2011-02-01 00:00:00 | Current
the models include other variables that lead the economy: state-level
housing permits (1 to 4 units), state initial unemployment insurance
claims, delivery times from the Institute for Supply Management (ISM)
manufacturing survey, and the interest rate spread between the 10-year
Treasury bond and the 3-month Treasury bill.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-02-01 00:00:00
2011-03-22 00:00:00
2011-03-31 00:00:00
2011-04-28 00:00:00
2011-05-31 00:00:00
2011-06-28 00:00:00
2011-08-02 00:00:00
2011-08-30 00:00:00
2011-09-29 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2011-12-29 00:00:00
2012-02-02 00:00:00
2012-03-20 00:00:00
2012-04-03 00:00:00
2012-04-27 00:00:00
2012-05-29 00:00:00
2012-06-28 00:00:00
2012-07-31 00:00:00
2012-08-28 00:00:00
2012-10-02 00:00:00
2012-10-30 00:00:00
2012-12-04 00:00:00
2013-01-03 00:00:00
2013-01-31 00:00:00
2013-03-26 00:00:00
2013-04-04 00:00:00
2013-04-30 00:00:00
2013-05-28 00:00:00
2013-07-02 00:00:00
2013-07-30 00:00:00
2013-08-29 00:00:00
2013-10-01 00:00:00
2013-12-04 00:00:00
2014-01-02 00:00:00
2014-02-04 00:00:00
2014-03-24 00:00:00
2014-04-03 00:00:00
Spreadsheet: 113883d1309775191-sumif-and-matches-example-for-questions-few-rows-v2
Sheet: Data

ID | DATE | PROD code | % | y/n | cat | value | WEEK
12345 | 2010-03-09 00:00:00 | 90862 | 0.03 | N | abc | 11.6 | 201037
12345 | 2010-03-09 00:00:00 | 166759001 | 0 | y | def | 89 | 201037 | This purchase passes (first few digits of code match code below and Y and % test) so now take the associated value 89 and add to purchases made on the same day (3/9/2010) by the same person
12345 | 2010-03-09 00:00:00 | 170752 | 0.1 | N | abc | 249 | 201037
34567 | 2010-03-09 00:00:00 | 139295005 | 0.09 | N | fgh | 79.98 | 201037
34567 | 2010-03-09 00:00:00 | 166759001 | 0.01 | N | abc | 26.8 | 201037 | This purchases passes code test and has N or % is less than 2%, therefore take 26.8 and sum up all of person's (34567) purchases on 3/9/2010 and put in N column
34567 | 2009-11-26 00:00:00 | 168592 | 0.04 | N | def | 149 | 201037
45678 | 2009-11-27 00:00:00 | 1894373 | 0.03 | N | fgh | 19 | 201037
45678 | 2009-11-28 00:00:00 | 166759002 | 0.015 | Y | abc | 38.99 | 201037 | This purchase passes (first few digits of code match code below and Y and % test) so now take the associated value 38.99 and add to purchases made on the same day (3/9/2010) by the same person
45678 | 2009-11-29 00:00:00 | 82831 | 0.05 | N | jkl | 39 | 201037
 |  |  |  |  |  |  |  | output required would be as follows
 |  |  |  |  |  |  |  | PROD code | 16675 | (only have first few digits on code and sometimes codes have extra digits that are not needed)
 |  |  |  |  |  |  |  | % test | 0.02
 |  |  |  |  |  |  |  | WEEK | Value if (PROD, Y OR %<2%) ) | Value (PROD, N OR %<2% )
 |  |  |  |  |  |  |  | 201037
 |  |  |  |  |  |  |  | 201038
 |  |  |  |  |  |  |  | start of formula
 |  |  |  |  |  |  |  |  | Issues with formula is that I need to have Y OR <2% (not Y AND <2%) in the sumif. Also it should only add values for the same person and for the same day. Obviously the ID and the date continuously change.
Spreadsheet: 668173d1584668115-advanced-sumifs-for-dashboard-building-slicer-replication-help-me-for-covid-immunity
Sheet: Scenarios

 |  |  | Summary
 |  |  | No. Of scenarios considered | Volume gained (k hL) | Volume lost (k hL) | Net volume (k hL) | Impact
 |  |  | Scenario Building |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Discuss on how assumptions for this scenario are going to be made
 |  |  | Support | 1 hL | 100000000
 |  |  | Support |  |  | 1 | 2 | 3 | 4 | 5 | 6
 |  |  | Scenarios |  |  | Target cluster |  |  |  |  |  |  |  | Volume pools |  |  |  |  |  |  |  | Opportunity
 |  |  | Scenarios |  |  | Criteria combinations to set cluster volume pool |  |  |  |  |  |  |  | Occasion volume pool |  | Occasion beer volume pool |  | Target cluster volume pool |  |  |  | New business assumption |  |  | Attack SKU |  |  |  |  |  | Cannibalized SKU |  |  |  |  |  |  |  |  | Impact
 |  |  | Taken into account | Scenario | Nombre oportunidad | Occasion | Age | Gender | Income Level | Channel | Region | Hide1 | Hide2 | Total liquid volume pool of occasion (k hL) | % from total liquid volume pool overall | Total beer volume pool of occasion (k hL) | Share of beer in total liquid volume pool per occasion (k hL) | Total liquid khL per target cluster (k hL) | Total beer khL per target cluster (k hL) | Share of beer in total liquid volume pool per target cluster (k hL) | Volume pools ( + ) ---> | Potential | Potential (k hL) | New share of beer of total liquid per cluster (k hL) | Brand | Container | Hide3 | Presentation | Margin of Chosen SKU (per hL) | Margin | Brand | Container | Hide4 | Presentation | Margin of Chosen SKU (per hL) | % of volume cannibalized | Volume lost | Margin lost | Opportunities ( + ) ---> | MACO
 |  |  | 1 | 1 | 3XX | Meals for 1 or 2 | 25-34 | Female | medium-low |  |  |  |  |  |  |  |  |  |  |  |  | 0.25 |  |  | Golden | RB |  | 330 |  |  | Mikes | CAN |  | 350 |  | 0.12
Spreadsheet: 33439796-c517-409f-b481-baaaa058c16d
Sheet: Option 2

Cycle Menu Template for Grades 6-8
(Include serving sizes and component contribrtions daily for each menu item)
Daily Menus | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 |  |  |  |  |  |  |  |  |  |  | Weekly Total
Daily Total | Serving Size | Component Contribution* | Serving Size | Component Contribution | Serving Size | Component Contribution | Serving Size | Component Contribution | Serving Size | Component Contribution | Total Component Contribution for week
Meat/Meat Alternates (oz) (minimum 1 oz./day)
Grains (minimum 1 oz./day)
Vegetables (cups)  (minimum 3/4 cup/day)
dark green  (½ c minimum)
red/orange  (¾ c minimum)
beans/legumes  ([NAME] c minimum)
starchy  ([NAME] c minimum)
other  (½ c minimum)
additional  (1 c minimum)
Fruit (1/2 cup minimum/day)
Milk (1 cup; offer variety)
* Component contribution should represent the Food Buying Guide and/or the Child Nutrition (CN) labels or manufacturer's signed specificiation
 |  | 4-day School Week | Grades 6-8 |  | 5-day Week | Grades 6-8
 |  | Fruit | 2 cups |  | Fruit | 2 1/2 cups
 |  | Vegetables | 3 cups |  | Vegetables | 3.75
 |  | Grains | 6.5 - 8 |  | Grains | 8 - 10
 | Meat/Meat Alternates |  | 7 - 8 | Meat/Meat Alternates |  | 9 - 10
 |  | Milk (cups) | 4 |  | Milk (cups) | 5
Spreadsheet: 57143d1257293741-count-columns-using-just-a-formula-705877-count-columns-using-just-a-formula
Sheet: Hoja1

Date | Server A | New Server | Server B | Server C | new [NAME]
2009-01-01 00:00:00 | OK |  |  |  | failed
2009-01-02 00:00:00 |  |  |  | OK
2009-01-03 00:00:00
2009-01-04 00:00:00 |  | ok
2009-01-05 00:00:00 |  | failed
2009-01-06 00:00:00
2009-01-07 00:00:00 | Failed
2009-01-08 00:00:00 |  |  |  | OK
2009-01-09 00:00:00 |  |  | Failed
2009-01-10 00:00:00 | Failed
 | Failed | Failed | Failed |  | Failed
Total servers | 4
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: November

Name | Site |  |  | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 | 2021-11-14 00:00:00 | 2021-11-15 00:00:00 | 2021-11-16 00:00:00 | 2021-11-17 00:00:00 | 2021-11-18 00:00:00 | 2021-11-19 00:00:00 | 2021-11-20 00:00:00 | 2021-11-21 00:00:00 | 2021-11-22 00:00:00 | 2021-11-23 00:00:00 | 2021-11-24 00:00:00 | 2021-11-25 00:00:00 | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: 103715d1301439182-list-matching-values-indexmatch-example2witharray
Sheet: Sheet2

A Series |  |  |  | 15 | B Series |  |  |  | 15
Person 2 | Here | 2 | A7033 |  | Person 1 | Here | 1 | B1198
Person 5 | Here | 5 | A8212 |  | Person 3 | Here | 3 | B453
Person 6 | Here | 6 | A3665 |  | Person 4 | Here | 4 | B428
Person 7 | Here | 7 | A2738 |  | Person 9 | Here | 9 | B6152
Person 8 | Here | 8 | A7304 |  | Person 10 | Here | 10 | B8681
Person 12 | Here | 12 | A2367 |  | Person 11 | Here | 11 | B249
Person 13 | Here | 13 | A5785 |  | Person 17 | There | 17 | B7710
Person 14 | Here | 14 | A561 |  | Person 18 | There | 18 | B4485
Person 15 | Here | 15 | A3798 |  | Person 19 | There | 19 | B2025
Person 16 | There | 16 | A6848 |  | Person 20 | There | 20 | B3749
Person 21 | There | 21 | A929 |  | Person 25 | There | 25 | B9608
Person 22 | There | 22 | A4906 |  | Person 26 | There | 26 | B4748
Person 23 | There | 23 | A4657 |  | Person 27 | There | 27 | B2202
Person 24 | There | 24 | A3681 |  | Person 29 | There | 29 | B2352
Person 28 | There | 28 | A9962 |  | Person 30 | There | 30 | B7266
Spreadsheet: 830878d1685196172-vlookup-help-costing-template
Sheet: Estimate

JOB NAME |  |  |  |  | JOB #
MATERIALS |  |  | COST |  | MARK UP |  |  | GRAND TOTAL
QTY | Part No. | MATERIALS DESCRIPTION | UNIT | EXTENDED | % | Unit Price | Total Extended
 |  | INTRUSION
 | PROA7PLUS-1 | ProSeries 7" All-In-One Control Touchscreen Panel |  |  | 0.5
 | PROLTE-V2 | ProSeries LTE Cellular Communications Module, Verizon |  |  | 0.5
 | PROSIXGB | ProSeries SiX Wireless [NAME], 25' Range |  |  | 0.5
 | [NAME] | ProSeries SiX 2-Way Wireless Door Sensor |  |  | 0.5
 | V128BPT-KS1 | Vista 128 [NAME] |  |  | 0.5
 |  |  |  |  | 0.5
 | 6160 | [NAME] Cust Alpha Prog |  |  | 0.5
 |  |  |  |  | 0.5
 | [NAME] | LTE M Communicator - Verizon |  |  | 0.5
 | 4193SN | V-Plex 2-Zone Expander |  |  | 0.5
 |  | CCTV
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  | ACCESS CONTROLS
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  | INTERCOMS
 | IX-MV7-B | Aiphone IX-MV7-HB 7" Touchscreen IP Video Master Station |  |  | 0.5
 | IX-DVM | Aiphone IX-DV IP Video Door Station |  |  | 0.5
 |  |  |  |  | 0.5
 |  |  |  |  | 0.5
 |  | MISC / OTHER
 | [NAME] | Administrative Time |  |  | 0.5
 | Freight | Freight / Shipping Charges |  |  | 0.5
 | [NAME] | *Need Lift Type & Quote From Vendor |  |  | 0.5
 | Tech Training | Additional Safety Training or Licensing Required For Job |  |  | 0.5
 | Tech PPE | Additional Safety Equipment/ Clothing Required For Job |  |  | 0.5
 | Account Mgmt | Vendor Credentialing |  |  | 0.5
 | Other |  |  |  | 0.5
0
GRAND TOTAL (MATERIALS)
LABOR |  |  | COST |  | MARK UP |  |  | GRAND TOTAL
HRS | ITEM | LABOR DESCRIPTION | UNIT | EXTENDED | % | Unit Price | Total Extended
 | Drawings/ Permits | [NAME]
 | Installation | Labor To Install All Equipment Listed | 55
 | Project Mgmt | Project Management | 55
 | Site Assessments | Labor To Asses Site & Design | 55
 | Training | Training Customer Of System | 55
 | Travel | Travel / Drive Time | 55
 | Per Diem / Hotel | Per Diem & Hotel (Per Day, Per Tech) | 200
 | Lead Fee | Commission Payment to Third Party
GRAND TOTAL (LABOR)
 | Contact Info (New Software Support Agreements Only) |  |  | PROJECT OVERVIEW
 | Name: |  |  |  |  | COST | MARKUP | JOB TOTAL
 | Job Title |  |  | MATERIALS
 | Phone # |  |  | LABOR
 | [NAME]
 |  |  |  | Total [NAME] |  | Subtotal
 |  |  |  |  |  | Tax (Zip Code)
 |  |  |  |  |  | GRAND TOTAL
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: 9905

May 1999 Transport Expense Flash
 |  |  | Commodity Expenses |  |  | Demand Charges |  |  | Comments
Texas Co. 78 |  |  |  |  |  |  |  |  | Long term deal commodity expense
Texas Co. 78 |  |  | 1177 |  |  |  |  |  | payable to Pan Grande Pipeline 96019628
Texas Co. 16 |  |  | 139074 |  |  |  |  |  | payable to Oasis Pipeline- 96015445
Texas Co. 16 |  |  | 148089 |  |  |  |  |  | payable to PG&E/Valero 96006479/96006482/96009903/96011842/96016347
Texas Co. 16 |  |  | 3022.5 |  |  |  |  |  | payable to Channel Industries-96017837
Texas Co. 16 |  |  | 2175 |  |  |  |  |  | payable to Lone Star
Texas Co. 16 |  |  | 14123 |  |  |  |  |  | payable to Black Marlin
Texas Co. 16 |  |  | 15095 |  |  |  |  |  | payable to Northern Natural Gas
Texas Co. 16 |  |  |  |  |  |  | 98300 |  | Centana Storage Demand Charge
 |  |  |  |  |  |  |  |  | *Top level entry in P/L
Totals
Spreadsheet: 855438d1704992313-timesheet-database-sample-timesheet
Sheet: 22-Jan-24

Staff Name | Project | Project Number | Project Name | Mon | Tue | Wed | Thu | Fri
Employee 1 | 23001 - Project 1 |  |  |  |  |  |  | 7.5
Employee 1 | 23002 - Project 2
Employee 1 | 23003 - Project 3
Employee 1 | 23004 - Project 4 |  |  |  |  |  | 7.5
Employee 1 | 23005 - Project 5 |  |  | 7.5 | 7.5 | 7.5
Employee 1 | 23006 - Project 6
Employee 1 | 23007 - Project 7
Employee 1 | 23008 - Project 8
Employee 1 | 23009 - Project 9
Employee 1 | 23010 - Project 10
Spreadsheet: 137834d1327404173-text-to-numbers-addup
Sheet: Sheet1

 | 10.1 |  |  | 55.99999999999999
10.1 |  |  | 10.1
$7.8 |  |  | 7.8
$1.9 |  |  | 1.9
$12.3 |  |  | 12.3
$3.3 |  |  | 3.3
$6.4 |  |  | 6.4
$2.6 |  |  | 2.6
0 |  |  | 0
$9.5 |  |  | 9.5
$2.1 |  |  | 2.1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 69853d1270541088-pulling-info-out-of-an-old-layout-oct-08
Sheet: 10-22-08 1st

Daily Problem Report |  |  |  |  |  | 1st shift |  | Date |  | 2008-10-22 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 2 |  | 0.75 |  | 3.5
PR |  | 1 |  |  |  | 2.06
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
 |  |  |  |  | No pull repairs or emergency repairs on 1st shift 10-22-08
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
CM: |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 874953d1721477004-pulling-data-from-multiple-tables-across-multiple-sheets-book_test
Sheet: 20 Min Exception

Hc2 | Hc | CON # | INCIDENT # | NATURE | PRIORITY CODE | ADDRESS | CITY | UNIT | UNIT ASSIGNED | UNIT ON SCENE | RT: | NOTES:
 |  |  |  |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  |  |  |  | IFT CALL
Spreadsheet: 851688d1701867802-chronological-order-for-a-criteria-by-customer-id-excel-forum
Sheet: Sheet1

Client ID | Invoice date (month/day/year) | Cronological order of invoices by client
A | 2007-02-05 00:00:00 | 1 |  |  | need results in column C to come from a formula, IN CRONOLOGICAL ORDER
B | 2020-02-12 00:00:00 | 1
C | 2021-02-18 00:00:00 | 1
D | 2020-01-10 00:00:00 | 1
A | 2020-01-27 00:00:00 | 2
A | 2020-03-05 00:00:00 | 3
A | 2021-07-31 00:00:00 | 4
C | 2021-03-31 00:00:00 | 2
Spreadsheet: 97175d1296409745-delete-certain-rows-based-on-their-partial-cell-content-sample1
Sheet: Sheet1

location | manu | code | produ
AL79D01 | s | 2273 | ga
AS58G02 | t | 2276 | pr
AR68D02 | f | 2293 | nu
AH54A01 | g | 2313 | gs
AS26H05 | t | 2314 | fr
AE45A01 | d | 2316 | vo
AS24H03 | t | 2319 | mo
AM28F01 | n | 2325 | to
Spreadsheet: 789148d1658929672-lookup-sum-between-two-dates-values-from-ranges-aligw
Sheet: Sheet9

 |  |  |  |  |  | AliGW
 |  |  |  | 2021-10-01 00:00:00 | 100 |  |  | 2021-10-01 00:00:00 | 2021-10-31 00:00:00 | 100
 |  |  |  | 2021-10-02 00:00:00 | 100 |  |  | 2021-10-10 00:00:00 | 2021-10-10 00:00:00 | 100
 |  |  |  | 2021-10-03 00:00:00 | 100
 |  |  |  | 2021-10-04 00:00:00 | 100
 |  |  |  | 2021-10-05 00:00:00 | 100
 |  |  |  | 2021-10-06 00:00:00 | 100
 |  |  |  | 2021-10-07 00:00:00 | 100
 |  |  |  | 2021-10-08 00:00:00 | 100
 |  |  |  | 2021-10-09 00:00:00 | 100
 |  |  |  | 2021-10-10 00:00:00 | 200
 |  |  |  | 2021-10-11 00:00:00 | 100
 |  |  |  | 2021-10-12 00:00:00 | 100
 |  |  |  | 2021-10-13 00:00:00 | 100
 |  |  |  | 2021-10-14 00:00:00 | 100
 |  |  |  | 2021-10-15 00:00:00 | 100
 |  |  |  | 2021-10-16 00:00:00 | 100
 |  |  |  | 2021-10-17 00:00:00 | 100
 |  |  |  | 2021-10-18 00:00:00 | 100
 |  |  |  | 2021-10-19 00:00:00 | 100
 |  |  |  | 2021-10-20 00:00:00 | 100
 |  |  |  | 2021-10-21 00:00:00 | 100
 |  |  |  | 2021-10-22 00:00:00 | 100
 |  |  |  | 2021-10-23 00:00:00 | 100
 |  |  |  | 2021-10-24 00:00:00 | 100
 |  |  |  | 2021-10-25 00:00:00 | 100
 |  |  |  | 2021-10-26 00:00:00 | 100
 |  |  |  | 2021-10-27 00:00:00 | 100
 |  |  |  | 2021-10-28 00:00:00 | 100
 |  |  |  | 2021-10-29 00:00:00 | 100
 |  |  |  | 2021-10-30 00:00:00 | 100
 |  |  |  | 2021-10-31 00:00:00 | 100
Spreadsheet: 765930d1643674229-conditional-formatting-with-a-difference-copy-of-sample
Sheet: Sheet2

 |  |  | Bonus Matrix
 |  |  | 0.05 | 0.15 | 0.25 | 0.5
 |  |  | 0.15 | 0.25 | 0.5 | 0.75
 |  |  | 0.25 | 0.5 | 0.75 | 1
 | 1 |  | Value |  |  |  | Val | 0.46
 |  |  | 0.35 | 0.38 | 0.41 | 0.45 | Vol | 0.53
 | Volume | 0.35
 |  | 0.4
 |  | 0.45
 | 2 |  | Value |  |  |  | Val | 0.85
 |  |  | 0.8 | 0.825 | 0.85 | 0.87 | Vol | 0.37
 | Volume | 0.35
 |  | 0.4
 |  | 0.5
 | 3 |  | Value |  |  |  | Val | 0.43
 |  |  | 0.35 | 0.38 | 0.41 | 0.45 | Vol | 0.44
 | Volume | 0.35
 |  | 0.4
 |  | 0.5
 | 4 |  | Value |  |  |  | Val | 0.41
 |  |  | 0.35 | 0.4 | 0.45 | 0.5 | Vol | 0.48
 | Volume | 0.4
 |  | 0.48
 |  | 0.5
 | 5 |  | Value |  |  |  | Val | 0.43
 |  |  | 0.35 | 0.38 | 0.41 | 0.45 | Vol | 0.35
 | Volume | 0.35
 |  | 0.4
 |  | 0.5
Spreadsheet: 491397d1480452062-weighted-percentile-calculation-help-copy-of-weightedpercentilesample
Sheet: Sheet1

Sample Data |  |  |  |  |  |  | Desired Result
Item Number | Qty | Value |  |  |  |  |  |  | 0.05
101 | 1 | 289 |  |  |  |  |  |  | 0.25
102 | 1 | 207 |  |  |  |  |  |  | 0.5
103 | 1 | 255
104 | 2 | 204
105 | 3 | 270
106 | 1 | 277
107 | 5 | 272
108 | 1 | 259
109 | 1 | 257
110 | 1 | 253