tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f743b748-3335-450d-a0ad-0f7d4a928415
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
ATTI | Test | ATTI | [NAME], Plasma | [NAME], P | Automated Latex Immunoassay (LIA) | Light blue-top (citrate) tube: LgtBlu |  |  | 1 | mL | See Coagulation Studies in Special Instructions.   Specimen Type: Platelet-poor plasma Collection Container/Tube: Light-blue top (citrate) Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Spin down, remove plasma, and spin plasma again.  2. Freeze specimen immediately at < or =-40 degrees C, if possible. Additional Information: 1. Double-centrifuged specimen is critical for accurate results as platelet contamination may cause spurious results. 2. Each coagulation assay requested should have its own vial. 3. Heparin treatment may lower plasma antithrombin. 4. Coagulation testing is highly complex, often requiring the performance of multiple assays and correlation with clinical information. For that reason, we suggest ordering THRMP/83093 Coagulation Consultation, Thrombosis/Hypercoagulability, Blood and Plasma. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK - refreeze - note to lab Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Adults: 80-130% Normal, full-term newborn infants may have decreased levels (> or =35-40%) which reach adult levels by 180 days postnatal.* Healthy, premature infants (30-36 weeks gestation) may have decreased levels which reach adult levels by 180 days postnatal.* *See Pediatric Hemostasis References in Coagulation Studies in Special Instructions. | Monday through Friday | 2 hours | 4 days | 1 | 85301 |  |  |  |  | Rochester
ATTI | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
ATTI | Result | ATTI | [NAME], P | [NAME], P | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 27812-7 | Antithrombin Ag actual/Normal:RelMCnc:Pt:PPP:Qn:Imm
Spreadsheet: 671580d1586446276-calculate-data-hierarchy-level-calculate-data-hierarchy-level
Sheet: Sheet1

Input | Output | Level
A | B | 0
B | C | 1
B | D | 1 |  | Level 0 |  | Level 1 |  | Level 2
C | E | 2
C | F | 2 |  |  |  |  |  | D
C | G | 2
D | H | 2 |  |  |  | B |  | E
D | I | 2
D | J | 2 |  | A |  |  |  | F
E |  | 3
F |  | 3
G |  | 3 |  |  |  |  |  | H
H |  | 3
I |  | 3 |  |  |  | C |  | I
J |  | 3
 |  |  |  |  |  |  |  | J
Spreadsheet: 335d38d1-4bf8-4167-b9bb-419cdf755c80
Sheet: Sheet1

Release: Non-Manufacturing ISM Report on Business | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=147
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-16 1:10 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Non-Manufacturing ISM Report on Business | 2007-12-05 00:00:00 | Current
Link:
http://www.ism.ws/ISMReport/ | 2007-12-05 00:00:00 | Current
Source:
Institute for Supply Management | 2007-12-05 00:00:00 | Current
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:
2007-12-05 00:00:00
2008-01-04 00:00:00
2008-01-29 00:00:00
2008-02-05 00:00:00
2008-03-05 00:00:00
2008-04-03 00:00:00
2008-05-05 00:00:00
2008-06-04 00:00:00
2008-07-03 00:00:00
2008-08-05 00:00:00
2008-09-04 00:00:00
2008-10-03 00:00:00
2008-11-03 00:00:00
2008-11-04 00:00:00
2008-11-05 00:00:00
2008-12-03 00:00:00
2009-01-06 00:00:00
2009-01-21 00:00:00
2009-02-04 00:00:00
2009-03-04 00:00:00
2009-04-03 00:00:00
2009-05-05 00:00:00
2009-06-03 00:00:00
2009-07-06 00:00:00
2009-08-05 00:00:00
2009-09-03 00:00:00
2009-10-05 00:00:00
2009-11-04 00:00:00
2009-12-03 00:00:00
2010-01-06 00:00:00
2010-01-27 00:00:00
2010-02-03 00:00:00
2010-03-03 00:00:00
2010-04-05 00:00:00
2010-05-05 00:00:00
2010-06-03 00:00:00
2010-07-06 00:00:00
2010-08-04 00:00:00
2010-09-03 00:00:00
2010-10-05 00:00:00
2010-11-03 00:00:00
2010-12-03 00:00:00
2011-01-05 00:00:00
2011-02-03 00:00:00
2011-03-03 00:00:00
2011-04-05 00:00:00
2011-05-04 00:00:00
2011-06-03 00:00:00
2011-07-06 00:00:00
2011-08-03 00:00:00
2011-09-06 00:00:00
2011-10-05 00:00:00
2011-11-03 00:00:00
2011-12-05 00:00:00
2012-01-05 00:00:00
2012-01-31 00:00:00
2012-02-03 00:00:00
2012-03-05 00:00:00
2012-04-04 00:00:00
2012-05-03 00:00:00
2012-06-05 00:00:00
2012-07-05 00:00:00
2012-08-03 00:00:00
2012-09-06 00:00:00
2012-10-03 00:00:00
2012-11-05 00:00:00
2012-12-05 00:00:00
2013-01-04 00:00:00
2013-02-05 00:00:00
2013-03-05 00:00:00
2013-04-03 00:00:00
2013-05-03 00:00:00
2013-06-05 00:00:00
2013-07-03 00:00:00
2013-08-05 00:00:00
2013-09-05 00:00:00
2013-10-03 00:00:00
2013-11-05 00:00:00
2013-12-04 00:00:00
2014-01-06 00:00:00
2014-02-05 00:00:00
2014-03-05 00:00:00
2014-04-03 00:00:00
Spreadsheet: 724584d1616249103-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - GAIUC - Blindagem

 |  | CENTROS DE CUSTOS
 |  | Vale - GAIUC - Blindagem
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | TAG | Observação
 |  | 2021-02-22 00:00:00 | Combustivel | 55656 | 4339.7 | V057 | Logistica
 |  | 2021-02-22 00:00:00 | Combustivel | 55659 | 2715.6 | EQ018 | Gerador
 |  | 2021-02-25 00:00:00 | Combustivel | 55672 | 4320.87 | V048 | Logistica
 |  | 2021-02-25 00:00:00 | Combustivel | 55692 | 3516.5 | V048 | Logistica
 |  | 2021-03-01 00:00:00 | Combustivel | 55720 | 2715.6 | EQ018 | Gerador
 |  | 2021-03-03 00:00:00 | Combustivel | 55726 | 3333.35 | V048 | Logistica
 |  | 2021-03-05 00:00:00 | Combustivel | 55744 | 3536 | V048 | Logistica
 |  | 2021-03-05 00:00:00 | Combustivel | 55747 | 19991.9 | V072 | Camiao Grua
 |  | 2021-03-08 00:00:00 | Combustivel | 55768 | 4187.66 | V048 | Logistica
 |  | 2021-03-10 00:00:00 | Combustivel | 55770 | 882.57 | EQ015 | Gerador
 |  | 2021-03-10 00:00:00 | Combustivel | 55793 | 2355.05 | V048 | Logistica
 |  | 2021-03-12 00:00:00 | Combustivel | 55804 | 3412.2 | V048 | Logistica
 |  | 2021-03-15 00:00:00 | Combustivel | 55822 | 3781.1 | V048 | Logistica
 |  | 2021-03-15 00:00:00 | Combustivel | 55819 | 2715.6 | EQ015 | Gerador
Spreadsheet: 70d836d9-8b98-4759-98fe-2f1e2fc91434
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: April 18, 2014 (5:05 am)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229646
Q2-2004 | 233241
Q3-2004 | 235336
Q4-2004 | 237875
Q1-2005 | 242085
Q2-2005 | 244136
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276019
Q2-2008 | 278206
Q3-2008 | 280691
Q4-2008 | 273572
Q1-2009 | 267266
Q2-2009 | 267665
Q3-2009 | 268736
Q4-2009 | 271174
Q1-2010 | 273058
Q2-2010 | 275612
Q3-2010 | 279685
Q4-2010 | 281383
Q1-2011 | 283078
Q2-2011 | 290271
Q3-2011 | 293177
Q4-2011 | 293795
Q1-2012 | 297910
Q2-2012 | 301286
Q3-2012 | 303811
Q4-2012 | 309614
Q1-2013 | 312286
Q2-2013 | 314808
Q3-2013 | 320087
Q4-2013 | 326018
Q1-2014 | X
Q2-2014 | X
Q3-2014 | X
Q4-2014 | X
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 8c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 2 | 6 | 15 | 25 | 86 | 8 | 54 | 6 | 202
Cap/Floor | 35 | 14 | 8 | 7 | 55 | 12 | 7 | - | 138
Debt Option | - | - | - | - | - | - | - | - | -
Exotic | - | - | - | - | - | - | - | - | -
Fixed-Fixed | 1 | - | - | - | - | - | - | - | 1
Fixed-Float | 136 | 80 | 294 | 1090 | 4674 | 4683 | 4751 | 2374 | 18082
FRA | 113 | 806 | 1876 | 1355 | - | - | - | - | 4150
Inflation | 5 | - | 3 | 3 | 17 | - | 47 | 15 | 90
OIS | 43 | 28 | 77 | 31 | 28 | 8 | 19 | - | 234
Swaption | - | - | - | 13 | 101 | 127 | 271 | 134 | 646
TOTAL | 335 | 934 | 2273 | 2524 | 4961 | 4838 | 5149 | 2529 | 23543
Spreadsheet: 46712d1245659560-count-formula-lookup-or-may-sumif-example-time-sheet
Sheet: Sheet1

 |  | 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
 |  | mon | tues | wed | [NAME] | fri | sat | [NAME] | tue | tues | thu | [NAME] | mon | tue | wed | wed | tues | fri | [NAME] | thu | fri | sat | thu | tues | sat | [NAME] | [NAME] | mon | tue | fri | tues | [NAME]
 | Mr A | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A
 | Mr B | B | K | I | A | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A | P | O | L | K | M | N | J | EF | H | C | D
 | Mr C | J | EF | H | C | D | B | K | I | A | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A | P | O | L | K | M | N
 | Mr D | L | K | M | N | J | EF | H | C | D | B | K | I | A | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A | P | O
 | Mr E | K | I | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A | A | P | O | L | K | M | N | J | EF | H | C | D | B
 | Mr F | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I
 | Mr G | C | D | B | K | I | A | P | O | L | K | M | N | J | EF | H | C | D | B | K | I | A | A | P | O | L | K | M | N | J | EF | H
Staff Hours Pattern |  | Total hours for each pattern each day of the month
A | 3.5 | 7
B | 4 | 4
C | 4.5 | 4.5
D | 8 | 0
EF | 7 | 0
G | 6 | 0
H | 5 | 0
I | 5.5 | 0
J | 7.5 | 7.5
K | 6.5 | 6.5
L | 1.5 | 1.5
M | 8.5 | 0
N | 9 | 0
O | 1 | 0
P | 0.5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total hours
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 23

 | THE ALLSTATE CORPORATION
 | ALLSTATE BRAND STANDARD AUTO LOSS RATIO OF TOP 5 STATES
 |  | Three months ended |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Twelve months ended
 |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Dec. 31,
 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2012 |  |  | 2011
Allstate brand standard auto loss ratio (1)
California |  |  | 71.2 |  |  | 68.8 |  |  | 71.6 |  |  | 78.4 |  |  | 75.3 |  |  | 73.9 |  |  | 67.9 |  |  | 75.1 |  |  | 72.5 |  |  | 73
Florida |  |  | 72.5 |  |  | 65.6 |  |  | 66.6 |  |  | 71.3 |  |  | 68.6 |  |  | 70.4 |  |  | 73.6 |  |  | 77.3 |  |  | 69.02 |  |  | 72.6
New York (2) |  |  | 135.22 |  |  | 67.8 |  |  | 67.7 |  |  | 65.2 |  |  | 78.4 |  |  | 83.9 |  |  | 68.2 |  |  | 80.1 |  |  | 83.6 |  |  | 77.6
Pennsylvania |  |  | 71 |  |  | 71.9 |  |  | 70.3 |  |  | 72.7 |  |  | 70.4 |  |  | 70 |  |  | 74.9 |  |  | 71.3 |  |  | 71.5 |  |  | 71.6
Texas |  |  | 66.8 |  |  | 62.5 |  |  | 81.5 |  |  | 74.5 |  |  | 61.9 |  |  | 64.8 |  |  | 75 |  |  | 60.7 |  |  | 71.3 |  |  | 65.6
All other states & Canada |  |  | 68.8 |  |  | 67 |  |  | 68.7 |  |  | 67.6 |  |  | 68.3 |  |  | 66 |  |  | 74.7 |  |  | 67.6 |  |  | 68 |  |  | 69.1
Total Allstate brand standard auto |  |  | 76.2 |  |  | 66.9 |  |  | 69.9 |  |  | 69.6 |  |  | 69.6 |  |  | 69.3 |  |  | 73.2 |  |  | 70.3 |  |  | 70.7 |  |  | 70.6
(1) | Loss ratios include prior year reserve reestimates.
(2) | Excluding the impact of Sandy, loss ratios in New York for the three months and twelve months ended December 31, 2012 were 71.0 and 67.9, respectively.
Spreadsheet: 216091d1361577591-checkboxes-keep-printing-even-though-ive-set-them-to-not-srf_forms
Sheet: PREPAIDS and OPEN CREDIT CARDS

SRF - Prepaid NOS Charges
 | Reservation Name: |  |  |  |  |  | Show Date: |  | Perf Type:
 | Attending Name: |  |  |  |  |  | # of Guests: |  | Table/Sec:
PREPAIDS (gratuity/meal tax/facility fee) |  |  |  |  |  |  |  |  |  |  |  | Section 1
Eve. [NAME]: | QTY: | 1 | @ $6.00 = |  | + 9.5% tax > |  | Total = |  |  |  | Section 1 Total:
Mat. [NAME]: | QTY: | 1 | @ $4.20 = |  | + 9.5% tax > |  | Total = |  |  |  | Subtotal =
Meal Tax: | QTY: | 2 | @ $2.62 = |  | + no tax > |  | Total = |  |  |  | Tax (9.5%)
Fac. Fee: | QTY: | 2 | @ $4.00 = |  | + no tax > |  | Total =
 |  |  |  |  |  |  |  |  |  |  | Total =
PREPAIDS (other) |  |  |  |  |  |  |  |  |  |  |  | Section 2
Item Description: |  |  |  |  | Price | Qty | Grat 18% | Tax 9.5% | Item Total
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1 |  |  |  |  | Section 2 Total:
 |  |  |  |  |  | 1 |  |  |  |  | Subtotal =
 |  |  |  |  |  | 1 |  |  |  |  | Tax (9.5%)
 |  |  |  |  |  | 1 |  |  |  |  | Grat (18%)
 |  |  |  |  |  | 1 |  |  |  |  | Total =
 |  |  |  |  |  |  |  |  |  | Total Prepaid Charge to Customer =
PAYMENT INFORMATION |  |  |  |  |  |  |  |  |  |  |  | Section 3
 | Name:
 | Phone: |  |  |  | [NAME]: |  |  |  | Fax:
 | Payment Type: |  |  | Cash |  | Card |  | [NAME] |  | Check
 | Credit Card #: |  |  |  |  |  | Exp:
Initials: | ZE |  | Trans Date:
Spreadsheet: 873417d1719924232-weighting-different-filters-construction-test
Sheet: Analytics

 |  |  |  | Category Weightings
Shop | Weighting |  | Date |  | Vegetable | Carbs | Drink | Dairy | Meat | Condiment | Fish | Other
 | 0.25
M&S | 0.25 |  | 2024-03-01 00:00:00
Tesco | 0.5 |  | 2024-12-01 00:00:00
Spreadsheet: 119059d1314178818-excel-2007-copy-rows-to-new-tab-still-lost
Sheet: More than 10

name | amount | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
jkl | 15 | a12 | b34 | c56 | d78 | e44 | f12
pqr | 82 | one | two | three | four | five | six
vwx | 10.5 | tree | flower | [NAME] | grass | weed | shrub
Spreadsheet: 81297d1281534061-coloring-the-cells-book1-1-1-
Sheet: Sheet1

NAME | Shuaiba | KOC | DEPS | DWPS
 | 2010-08-03 00:00:00 | 2010-09-04 00:00:00 | 2010-08-05 00:00:00 | 2010-09-06 00:00:00
 | 2010-09-07 00:00:00 | 2010-09-05 00:00:00 | 2010-09-05 00:00:00 | 2010-09-06 00:00:00
 | 2010-09-10 00:00:00 | 2010-09-06 00:00:00 | 2010-09-05 00:00:00 | 2010-09-06 00:00:00
 | 2010-10-06 00:00:00 | 2010-09-07 00:00:00 | 2010-09-05 00:00:00 | 2010-09-11 00:00:00
 | 2010-09-18 00:00:00 | 2010-09-08 00:00:00 | 2010-09-05 00:00:00 | 2010-08-11 00:00:00
 | 2010-08-18 00:00:00 | 2010-09-09 00:00:00 | 2010-09-05 00:00:00 | 2010-09-06 00:00:00
 | 2010-09-09 00:00:00 | 2010-09-10 00:00:00 | 2010-09-05 00:00:00 | 2010-09-06 00:00:00
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Hani Nassar.

Contract Terms (*)
 |  | 1- Revenue Target | Incentive
 |  | Tier 1 - 200,00 to 300,000 | 3500
 |  | [NAME] to 400,000 | 8000
 |  | [NAME] to 500,000 | 14166
 |  | [NAME] to 600,000 | 20000
 |  | Tier 5 - 600,001 to 700,000 | 25000
 |  | [NAME] to 800,000 | 30000
 |  | Tier 7 - 800,001 to 900,000 | 35000
 |  | [NAME] | 40000
 |  | Tier 9 - 1,000,001 and above | 45000
 |  | Description | Commission
 |  | Lab (after deducting cost) | 0.1
 |  | Consultation | 0.5
 |  | Procedures (after deducting consumables) | 0.5
Doctor Calculation
 |  | Lab Revenue 10% | 0
 |  | Amount to be paid |  | 0.1
 |  | Doctor Revenue | 300000
 |  | Consumables | 62199.02
 |  | [NAME] | 0
 |  | Ulthera Depraciation | 0
 |  | Net Revenue
 |  | Doctor Commision
 |  | Doctor Incentive on Revenue |  | I need the result as per tier - if the revenue is 300k plus so the incentive is 8,000 and so on
 |  | Amount to be Paid
 |  | Total Amount to be Paid
 |  | Less 2.5 % Admin Fee
 |  | Less Monthly Salary | 45000
 |  | Add Monthly Vacation and Tickets | 5000
 |  | Net Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 34865d1232264171-summarize-daily-data-into-weekly-average-average-of-daily-data
Sheet: data

2008-11-03 00:00:00 | 94 | 45.4
2008-11-04 00:00:00 | 56
2008-11-05 00:00:00 | 30
2008-11-06 00:00:00 | 17
2008-11-07 00:00:00 | 30
2008-11-10 00:00:00 | 47 | 74.2
2008-11-11 00:00:00 | 92
2008-11-12 00:00:00 | 94
2008-11-13 00:00:00 | 76
2008-11-14 00:00:00 | 62
2008-11-17 00:00:00 | 35 | 51.6
2008-11-18 00:00:00 | 95
2008-11-19 00:00:00 | 34
2008-11-20 00:00:00 | 55
2008-11-21 00:00:00 | 39
2008-11-24 00:00:00 | 47 | 39.8
2008-11-25 00:00:00 | 67
2008-11-26 00:00:00 | 25
2008-11-27 00:00:00 | 41
2008-11-28 00:00:00 | 19
2008-12-01 00:00:00 | 90 | 78
2008-12-02 00:00:00 | 79
2008-12-03 00:00:00 | 77
2008-12-04 00:00:00 | 93
2008-12-05 00:00:00 | 51
2008-12-08 00:00:00 | 77
2008-12-09 00:00:00 | 20
2008-12-10 00:00:00 | 66
2008-12-11 00:00:00 | 24
2008-12-12 00:00:00 | 80
2008-12-15 00:00:00 | 32
2008-12-16 00:00:00 | 87
2008-12-17 00:00:00 | 27
2008-12-18 00:00:00 | 79
2008-12-19 00:00:00 | 10
2008-12-22 00:00:00 | 8
2008-12-23 00:00:00 | 81
2008-12-24 00:00:00 | 86
2008-12-25 00:00:00 | 23
2008-12-26 00:00:00 | 17
2008-12-29 00:00:00 | 64
2008-12-30 00:00:00 | 21
2008-12-31 00:00:00 | 46
2009-01-01 00:00:00 | 31
2009-01-02 00:00:00 | 19
2009-01-05 00:00:00 | 50
2009-01-06 00:00:00 | 75
2009-01-07 00:00:00 | 5
2009-01-08 00:00:00 | 12
2009-01-09 00:00:00 | 2
2009-01-12 00:00:00 | 67
2009-01-13 00:00:00 | 79
2009-01-14 00:00:00 | 12
2009-01-15 00:00:00 | 37
2009-01-16 00:00:00 | 73
2009-01-19 00:00:00 | 65
2009-01-20 00:00:00 | 72
2009-01-21 00:00:00 | 55
2009-01-22 00:00:00 | 75
2009-01-23 00:00:00 | 5
2009-01-26 00:00:00 | 33
2009-01-27 00:00:00 | 78
2009-01-28 00:00:00 | 37
2009-01-29 00:00:00 | 67
2009-01-30 00:00:00 | 96
Spreadsheet: 39baa9b0-eb1f-4a2a-864d-5a2a2b8750fd
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
SCLE | Test | SCLE | Scale, IgE | Scale, 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
SCLE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SCLE | Result | SCLE | Scale, IgE | Scale, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6239-8
Spreadsheet: 41255d1239744897-sumproduct-complex-sum-arrays-test
Sheet: Project Hours

WBS | Community | Type |  | Resource Group | Project | 2009-04-13 00:00:00 | 2009-04-20 00:00:00
1 |  |  |  |  | Main Category | 50 | 51
1.1 |  |  |  |  | Category | 4 | 4
1.1.1 | PI | PIONE |  | PM | PROJECT1 | 2 | 4
 |  |  |  | PM | [NAME] | 2 | 4
1.1.2 | PI | PIONE |  | CDEV,PM | PROJECT2 | 0 | 0
 |  |  |  | CDEV | LeadDEV | 0 | 0
 |  |  |  | PM | [NAME] | 0 | 0
1.1.3 | PI | PITWO |  | CDEV | PROJECT3 | 2 | 0
 |  |  |  | CDEV | [NAME] | 2
 |  |  |  | CDEV | LeadDEV | 0 | 0
1.1.4 | PI | PITWO |  | CDEV,PM | PROJECT4 | 0 | 0
 |  |  |  | CDEV | [NAME]
 |  |  |  | CDEV | [NAME]
 |  |  |  | CDEV | LeadDEV | 0 | 0
 |  |  |  | PM | [NAME] | 0 | 0
1.48 |  |  |  |  | TT | 46 | 47
1.48.1 |  |  |  |  | General | 16 | 17
1.48.1.1 | TT | TTONE |  | PM | PROJECT11 | 2 | 4
 |  |  |  | PM | [NAME] | 2 | 4
1.48.1.2 | TT | TTONE |  | PM,CDEV | PROJECT22 | 4 | 4
 |  |  |  | PM | [NAME] | 2 | 2
 |  |  |  | CDEV | [NAME] | 2 | 2
1.48.1.3 | TT | TTTHREE |  | PM,CDEV | PROJECT33 | 6 | 5
 |  |  |  | PM | [NAME] | 4 | 4
 |  |  |  | CDEV | [NAME] | 2 | 1
1.48.1.4 | TT | TTTHREE |  | PM | PROJECT44 | 4 | 4
 |  |  |  | PM | Kamal Wink | 4 | 4
1.48.2 |  |  |  |  | NON GENERAL | 30 | 30
1.48.2.1 | TT | TTTWO |  | PM | PROJECT1 | 14 | 14
 |  |  |  | PM | [NAME] | 14 | 14
1.48.2.2 | TT | TTFIVE |  | PM | PROJECT11 | 16 | 16
 |  |  |  | PM | [NAME] | 16 | 16
 |  |  |  |  | PM
 |  |  |  |  | PI | 2 | 4
 |  |  |  |  | PIONE | 2 | 4
 |  |  |  |  | PITWO | 0 | 0
 |  |  |  |  | TT | 36 | 38
 |  |  |  |  | TTONE | 2 | 4
 |  |  |  |  | TTTWO | 14 | 14
 |  |  |  |  | TTTHREE | 4 | 4
 |  |  |  |  | TTFOUR | 0 | 0
 |  |  |  |  | TTFIVE | 16 | 16
 |  |  |  |  | CDEV
 |  |  |  |  | PI | 2 | 0
 |  |  |  |  | PIONE | 0 | 0
 |  |  |  |  | PITWO | 2 | 0
 |  |  |  |  | TC | 0 | 0
 |  |  |  |  | TTONE | 0 | 0
 |  |  |  |  | TTTWO | 0 | 0
 |  |  |  |  | TTTHREE | 0 | 0
 |  |  |  |  | TTFOUR | 0 | 0
 |  |  |  |  | TTFIVE | 0 | 0
Spreadsheet: 24874d1215770128-finding-information-between-two-cells-test-v2
Sheet: Sheet2

LOCATION FROM | LOCATION TO |  | AISLE 20
0502131A01 | 0502146F02 |  | 0502046D01 | Y
0502047D01 | 0502047F02 |  | 0502046D02 | Y
0502501A01 | 0502524F02 |  | 0502046E01 | Y
0502046D01 | 0502047A01 |  | 0502046E02 | Y
0502601A01 | 0502617F02 |  | 0502046F01 | Y |  | I need Excel to give a value in column E (eg "Y" as shown) if it finds the specific location (column D) between two location ranges (ie Highlighted columns A & B). There will be approx 250 lines of ranges (LOCATIONS FROM & LOCATIONS TO) and 60 aisles to check and match up.
 |  |  | 0502046F02 | Y
 |  |  | 0502047A01 | Y
 |  |  | 0502047A02
 |  |  | 0502047B01
 |  |  | 0502047B02
 |  |  | 0502047C01
 |  |  | 0502047C02
 |  |  | 0502047D01 | Y
 |  |  | 0502047D02 | Y
 |  |  | 0502047E01 | Y
 |  |  | 0502047E02 | Y
 |  |  | 0502047F01 | Y
 |  |  | 0502047F02 | Y
 |  |  | 0502048A01
 |  |  | 0502048A02
 |  |  | 0502048B01
 |  |  | 0502048B02
 |  |  | 0502048C01
 |  |  | 0502048C02
 |  |  | 0502048D01
 |  |  | 0502048D02
 |  |  | 0502048E01
 |  |  | 0502048E02
 |  |  | 0502048E02
 |  |  | 0502048F01
 |  |  | 0502048F02
 |  |  | 0502049A01
 |  |  | 0502049A02
 |  |  | 0502049B01
 |  |  | 0502049B02
 |  |  | 0502049C01
 |  |  | 0502049C02
 |  |  | 0502049D01
 |  |  | 0502049D02
 |  |  | 0502049E01
 |  |  | 0502049E02
 |  |  | 0502049F01
 |  |  | 0502049F02
Spreadsheet: 765722d1643548181-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Trade Tracker

YEAR | MODEL | ACV | Deal Stock | Type | Status | Retailable? |  | TRADING CLIENT |  | Sales Rep |  | Total Retailable Trades
 |  |  |  |  |  |  |  |  |  |  |  | Total Trades On New
 |  |  |  |  |  |  |  |  |  |  |  | Total Trades On Used
 |  |  |  |  |  |  |  |  |  |  |  | Percentage of Trades to New Deals
 |  |  |  |  |  |  |  |  |  |  |  | Percentage of Trades to Used Deals
 |  |  |  |  |  |  |  |  |  |  |  | Total Retailable VS Whoesale
 |  |  |  |  |  |  |  |  |  |  |  | Percentage of Retailable Trades to New
 |  |  |  |  |  |  |  |  |  |  |  | Percentage of Retailable Trades to Used
 |  |  |  |  |  |  |  |  |  |  |  | Overall Percentage of Retailable Trades to All Deals