tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 5

THE ALLSTATE CORPORATION
BOOK VALUE PER SHARE
($ in millions, except per share data )
 |  |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31, |  |  | Dec. 31, |  |  | Sept. 30, |  |  | June 30, |  |  | March 31,
 |  |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2012 |  |  | 2011 |  |  | 2011 |  |  | 2011 |  |  | 2011
Book value per share
 | Numerator:
 |  | Shareholders' equity | $ | 20580 |  | $ | 20837 |  | $ | 19475 |  | $ | 19182 |  | $ | 18298 |  | $ | 17732 |  | $ | 18382 |  | $ | 18898
 | Denominator:
 |  | Shares outstanding and dilutive potential
 |  | shares outstanding |  | 485.5 |  |  | 488.7 |  |  | 490.2 |  |  | 497.3 |  |  | 505.8 |  |  | 509 |  |  | 522 |  |  | 529
 |  | Book value per share | $ | 42.38928939237899 |  | $ | 42.63760998567628 |  | $ | 39.72868217054263 |  | $ | 38.57229036798713 |  | $ | 36.17635429023329 |  | $ | 34.83693516699411 |  | $ | 35.21455938697318 |  | $ | 35.72400756143667
Book value per share, excluding the
 | impact of unrealized net capital gains
 | and losses on fixed income securities *
 | Numerator:
 |  | Shareholders' equity | $ | 20580 |  | $ | 20837 |  | $ | 19475 |  | $ | 19182 |  | $ | 18298 |  | $ | 17732 |  | $ | 18382 |  | $ | 18898
 |  | Unrealized net capital gains and losses on
 |  | fixed income securities |  | 2549 |  |  | 2602 |  |  | 1919 |  |  | 1620 |  |  | 1311 |  |  | 1136 |  |  | 1091 |  |  | 671
 |  | Adjusted shareholders' equity | $ | 18031 |  | $ | 18235 |  | $ | 17556 |  | $ | 17562 |  | $ | 16987 |  | $ | 16596 |  | $ | 17291 |  | $ | 18227
 | Denominator:
 |  | Shares outstanding and dilutive potential
 |  | shares outstanding |  | 485.5 |  |  | 488.7 |  |  | 490.2 |  |  | 497.3 |  |  | 505.8 |  |  | 509 |  |  | 522 |  |  | 529
 |  | Book value per share, excluding the
 |  | impact of unrealized net capital gains
 |  | and losses on fixed income securities | $ | 37.13903192584964 |  | $ | 37.31328013095969 |  | $ | 35.81395348837209 |  | $ | 35.31469937663382 |  | $ | 33.58442071965204 |  | $ | 32.60510805500982 |  | $ | 33.12452107279694 |  | $ | 34.45557655954632
Spreadsheet: b730f455-36c0-4f75-832f-de9257c9ba41
Sheet: Sheet1

Release: Annual Estimates of the Population of Metropolitan and Micropolitan Statistical Areas | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=111
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-12-21 12:23 PM CST
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population of Metropolitan and Micropolitan | 2005-06-07 00:00:00 | Current
Statistical Areas
Link:
http://www.census.gov/popest/ | 2005-06-07 00:00:00 | Current
Source:
US. Bureau of the Census | 2005-06-07 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:
2005-06-07 00:00:00
2006-01-19 00:00:00
2006-08-21 00:00:00
2006-09-14 00:00:00
2007-04-05 00:00:00
2008-03-27 00:00:00
2009-03-19 00:00:00
2010-03-25 00:00:00
2012-04-05 00:00:00
2013-03-27 00:00:00
2014-06-20 00:00:00
Spreadsheet: 825349d1681266242-cell-formatting-to-display-a-certain-text-or-number-try-out-report
Sheet: NORMAL HRS

D A I L Y   L A B O R   R E P O R T
DISTRICT: |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE:
FOREMAN: |  |  |  |  |  | R/M HIGHWAY |  | X |  |  | OTHER |  |  |  |  | APPROVED:
 |  |  |  |  |  |  |  |  |  |  | W.O. #
L A B O R |  |  |  |  |  |  |  |  |  |  | E Q U I P M E N T (County & Rental)
HC NO | PAY | NAME |  |  | AREA | JOB | HOURS | HRLY | AMOUNT |  | CH NO. | HOURS | HRLY | EQUIP | REMARKS
 | CODE |  |  |  | CODE | CODE |  | RATE |  |  |  |  | RATE | COST
 |  |  |  |  |  | 210 |  |  |  |  | CH4194
M A T E R I A L S  &  S U P P L I E S |  |  |  |  |  |  |  |  |  |  | J O B  C O S T  SUMMARY
QTY | ITEMS |  |  |  |  | AREA                  CODE | JOB          CODE | UNIT | AMOUNT |  | AREA | JOB | HRS |  |  | M/S | C/S | TOTAL
 |  |  |  |  |  |  |  | COST |  |  | CODE | CODE |  | LABOR | EQUIP
 |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL
Spreadsheet: 8fab1449-36e6-4f93-831f-6033ce8bce8f
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
FBUHB | Test | FBUHB | Bupropion (Wellbutrin, [NAME]) and Hydroxybupropion | Bupropion (Wellbutrin) | High-Performance Liquid Chromatography with Ultraviolet Detection (HPLC-UV) |  |  |  | 3 | mL | Submit only 1 of the following specimens:  Serum Draw blood in a plain, red-top tube(s), separate and freeze immediately. (Serum get tube is not acceptable.) Send 3 mL of serum frozen. Note: 1. Indicate serum on request form. 2. Label specimen appropriately (serum). 3. Send a steady state collection.  [NAME] blood in a green-top (sodium or lithium heparin) tube(s), separate and freeze immediately. ([NAME] tube is not acceptable.) Send 3 mL of sodium heparin plasma frozen. Note: 1. Indicate plasma on the request form. 2. Label specimen appropriately (plasma). 3. Send a steady state collection. | 0.6 mL | Hemolysis:	NA Thawing:	Warm reject; Cold reject Lipemia:	NA Icterus:	NA Other:	NA | Bupropion:	 	50-100 ng/mL Hydroxybupropion:	600-2000 ng/mL  Note: Expected concentration range for hydroxybupropion:          600 - 2000 ng/mL.  Test Performed by: Medtox Laboratories, Inc                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82492 |  |  |  |  | Medtox Laboratories, Inc
FBUHB | Result | Z2800 | Bupropion | Bupropion | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 6706-6
FBUHB | Result | Z2801 | Hydroxybupropion | Hydroxybupropion | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 9418-5
Spreadsheet: 61633d1262585487-excel-2007-whther-sumif-to-be-used-or-some-other-formula-may-work-sgn
Sheet: PIVOT

CLOSDT | (All)
Sum of OSNPADT
CUSTID | Total
550087030 | -43561
550087896 | -349779
550088198 | -355257.1
550144835 | -270824
550217772 | -471151
550217806 | -494361
550896707 | -19217
550900962 | -825511
550972049 | -6261
550972051 | -5788
551344092 | -1429
551359310 | -15356
551371692 | -100
551371817 | -10467
551372069 | -43391
551372208 | -7608
551372224 | -100
551372260 | -100
551372277 | -100
551372295 | -100
551372297 | -100
551372429 | -100
551372448 | -100
551414929 | -17198
APU000039 | -58241
D10097040 | -100
D10369761 | -410016
D10442532 | -22627
D10559482 | -970145
Grand Total | -4399088.1
Spreadsheet: 154541d1336480517-returning-an-array-of-lookup-values-from-an-input-array-rather-than-single-value-sampleworkbook
Sheet: Sheet1

Lookup_Items | Lookup_Value |  |  |  |  |  |  |  | Lookup_Table
Item2 | Value10 |  |  |  |  |  |  | Lookup_Row -> |  | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Item8 | Item9 | Item10
Item4 |  | 1 |  |  |  |  |  |  | Value1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0
Item6 |  | 0 |  |  |  |  |  |  | Value2 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 1
Item7 |  | 0 |  |  |  |  |  |  | Value3 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Value4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Value5 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1
 |  |  |  |  |  |  |  |  | Value6 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Value7 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 1
 |  |  | 1 | 0 | 0 |  |  |  | Value8 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  | Value9 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  | Value10 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  | Value11 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 1
 |  |  |  |  |  |  |  |  | Value12 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1
 |  |  |  |  |  |  |  |  | Value13 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 |  |  |  |  |  |  |  |  | Value14 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 0
 |  |  |  |  |  |  |  |  | Value15 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0
Spreadsheet: 743756d1628698476-dynamic-sumifs-criteria-range-dynamic-sumifs
Sheet: Sheet1

 | 2021-07-01 00:00:00 |  |  |  |  |  | CM Target |  | Today's Date
CA | [NAME] | Alexis | [NAME] | [NAME] | Samantha |  | 53
TX | [NAME] | [NAME] | Samantha | [NAME] | Alexis |  | 73
NY | [NAME] | Samantha | [NAME] | Alexis | [NAME] |  | 92
GA | Alexis | [NAME] | [NAME] | Samantha | [NAME] |  | 60
IL | [NAME] | [NAME] | Alexis | [NAME] | [NAME] |  | 118 |  | [NAME]
AL | Samantha | [NAME] | [NAME] | [NAME] | [NAME] |  | 139 |  | [NAME]
OR | [NAME] | [NAME] | [NAME] | [NAME] | Samantha |  | 141 |  | [NAME]
ME | [NAME] | [NAME] | Samantha | [NAME] | [NAME] |  | 91 |  | Alexis
ND | [NAME] | [NAME] | Alexis | Alexis | [NAME] |  | 112 |  | [NAME]
LA | Samantha | [NAME] | [NAME] | [NAME] | [NAME] |  | 97 |  | Samantha
Spreadsheet: 84993d1285076014-formula-to-forecast-end-dates-of-individual-activities-progress-master
Sheet: OVERALL REPORT

PROGRESS REPORT                                                                                                                                                                                                                                                                                                                                                                   Items in RED = Planned Completed activites by 30-Nov-10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Report Week | 2 |  | Report Date | 2010-09-08 00:00:00
Schedule based on EPS3 Programme to Completion WTC/0003Final
Y | Y | Y |  |  | Y |  | Y |  | Y |  |  | Y | Y | Y | Y | Y | Y |  | Y | Y
BAR ID | Description | Complete by End Nov'10 | D/P/C/M | Headers | Responsibility | Original Duration (Days) | Original Duration (Weeks) | Remaining Original Duration (Days) | Remaining Original Duration (Weeks) | Forecast Completion Date | Remaining Actual Duration (Weeks) | Planned Start Date | Actual Start Date | Planned End Date | Actual End Date | Planned % Complete | Actual % Complete | [NAME](+/- Days) | [NAME] (+/- Days) | Comments
WTC0003 EPS3 Programme to Completion - B10 |  |  |  | h |  | 715 | 143 |  | 143 |  |  | 2009-09-14 00:00:00 |  | 2012-07-10 00:00:00 |  | 0.1
Milestones/Overview |  |  |  | h |  | 399 | 79.8 |  | 79.8 |  |  | 2010-11-30 00:00:00 |  | 2012-07-10 00:00:00
Contract Milestones |  |  |  | h |  | 399 | 79.8 |  | 79.8 |  |  | 2010-11-30 00:00:00 |  | 2012-07-10 00:00:00
PM01-1030 | END OF NOVEMBER - PROPOSED TRANSFER DATE | Y |  |  |  | 1 | 0.2 | 1 | 0.2 | 1900-01-01 00:00:00 |  | 2010-11-30 00:00:00 |  | 2010-11-30 00:00:00
PM01-1020 | CONTRACT COMPLETION DATE |  |  |  |  | 1 | 0.2 | 1 | 0.2 | 2011-01-27 00:00:00 |  | 2011-01-26 00:00:00 |  | 2011-01-26 00:00:00
Spreadsheet: 58725d1258995930-re-establishing-formulas-on-text-input-for-a-specific-cell-original-formula-act-worksheet-original-formulas-activation-on-zeroed-worksheet
Sheet: WORK-SHEET

 |  |  |  |  |  |  | 2009-11-20 00:00:00
 |  |  |  |  |  | NO: | [NAME] | WEEK STARTING DATE: | DAYS ON LOCATION: | CASH AMNT: | PHONE ALLOWANCE: | WEEK-ENDING DATE: |  |  | DATA VALIDATION LIST (P9:NQ13) BELOW WILL BE 'HIDDEN' |  |  | REFERENCE PURPOSES ONLY: BELOW
 |  |  |  |  |  | NO: | NAME: | WEEK START: | DAYS: | CASH AMNT: | PHONE: | WEEK-END: |  |  | FULL WEEK | 120 |  | FRIDAY | THURSDAY | DAY | 7 DAYS
 |  |  |  |  |  | 1 |  |  | FULL WEEK |  | 10 |  |  |  | TUESDAY (ARR) | 50 |  | TUESDAY | THURSDAY | ARRIVE | 3 DAYS
 |  |  |  |  |  | 2 |  |  | FULL WEEK |  | 10 |  |  |  | SATURDAY (ARR) | 100 |  | SATURDAY | THURSDAY |  | 6 DAYS
 |  |  |  |  |  | 3 |  |  | FULL WEEK |  | 10 |  |  |  | TUESDAY (DEP) | 85 |  | FRIDAY | TUESDAY | DEPART | 5 DAYS
 |  |  |  |  |  | 4 |  |  | FULL WEEK |  | 10 |  |  |  | SATURDAY (DEP) | 35 |  | FRIDAY | SATURDAY |  | 2 DAYS
 |  |  |  |  |  | 5 |  |  | FULL WEEK |  | 10 |  |  |  | DAYS | AMOUNT
 |  |  |  |  |  | 6 |  |  | FULL WEEK |  | 10
 |  |  |  |  |  | 7 |  |  | FULL WEEK |  | 10
 |  |  |  |  |  | 8 |  |  | SATURDAY (ARR) |  | 10
 |  |  |  |  |  | 9 |  |  | TUESDAY (DEP) |  | 10
 |  |  |  |  |  | 10 |  |  | SATURDAY (DEP) |  | 10
 |  |  |  |  |  |  |  |  | TOTAL:
Spreadsheet: 114557d1310312603-counting-unique-names-with-three-column-condition-example
Sheet: Blad1

Title | Date | Status | Archive ID
A | 2005-05-01 00:00:00 | Idea
B | 2005-05-02 00:00:00 | Idea
C | 2005-05-03 00:00:00 | Idea
D | 2005-05-04 00:00:00 | Idea
E | 2005-05-05 00:00:00 | Idea
F | 2005-05-06 00:00:00 | Idea
G | 2005-05-07 00:00:00 | Idea
H | 2005-05-08 00:00:00 | Idea
I | 2005-05-09 00:00:00 | Idea
J | 2005-05-10 00:00:00 | Idea
K | 2005-05-11 00:00:00 | Idea
L | 2005-05-12 00:00:00 | Idea
M | 2005-05-13 00:00:00 | Idea
N | 2005-05-14 00:00:00 | Idea
O | 2005-05-15 00:00:00 | Idea
P | 2005-05-16 00:00:00 | Idea
Q | 2005-05-17 00:00:00 | Idea
B | 2005-05-18 00:00:00 | Archive | 1
A | 2005-05-19 00:00:00 | Archive | 2
C | 2005-05-20 00:00:00 | Archive | 2
D | 2005-05-21 00:00:00 | Archive | 3
F | 2005-05-22 00:00:00 | Archive | 0
G | 2005-05-23 00:00:00 | Archive | 1
H | 2005-05-24 00:00:00 | Archive | 2
I | 2005-05-25 00:00:00 | Archive | 3
J | 2005-05-26 00:00:00 | Archive | 2
K | 2005-05-27 00:00:00 | Archive | 1
A | 2005-05-28 00:00:00 | Archive | 1
C | 2005-05-29 00:00:00 | Archive | 0
I | 2005-05-30 00:00:00 | Archive | 2
P | 2005-05-31 00:00:00 | Archive | 1
O | 2005-06-01 00:00:00 | Archive | 0
N | 2005-06-02 00:00:00 | Archive | 0
Spreadsheet: 103186d1300980069-linking-different-datasets-query
Sheet: Address

ID No | House No | Street Name | Town | Postcode
1 | 1 | Nowhere rd | Cardiff | CF4 5FD
2 | 2 | somewhere st | Cardiff | CF1 3ED
3 | 3 | Nowhere rd | Swansea | SW7 9TG
4 | 4 | somewhere st | Bristol | BS2 7JM
Spreadsheet: 35603d1233187231-lookup-a-column-header-based-on-first-column-with-value-0-test
Sheet: data

ROL Account Number | 2006-01-30 00:00:00 | 2006-02-28 00:00:00 | 2006-03-31 00:00:00 | 2006-04-30 00:00:00 | 2006-05-31 00:00:00 | 2006-06-30 00:00:00 | 2006-07-31 00:00:00
269845 | 0 | 2 | 0 | 0 | 0 | 345 | 0
269828 | 0 | 0 | 0 | 2 | 0 | 0 | 5
273705 | 0 | 0 | 0 | 0 | 3 | 0 | 0
271989 | 0 | 0 | 0 | 0 | 0 | 4 | 0
271987 | 0 | 34 | 0 | 345 | 0 | 0 | 5
273749 | 0 | 0 | 0 | 0 | 0 | 0 | 0
269784 | 0 | 0 | 435 | 0 | 0 | 0 | 0
269284 | 0 | 0 | 0 | 0 | 3 | 0 | 0
259227 | 0 | 0 | 0 | 0 | 0 | 0 | 0
259612 | 0 | 0 | 0 | 0 | 345 | 0 | 0
258938 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 691926d1597951437-index-match-array-formula-help-indexmatcharray_ql-days
Sheet: CompiledJul-Aug

District | Name | 1-Jul | 2-Jul | 3-Jul | 4-Jul | 5-Jul | 6-Jul | 7-Jul | 8-Jul | 9-Jul | 10-Jul | 11-Jul | 12-Jul | 13-Jul | 14-Jul | 15-Jul | 16-Jul | 17-Jul | 18-Jul | 19-Jul | 20-Jul | 21-Jul | 22-Jul | 23-Jul | 24-Jul | 25-Jul | 26-Jul | 27-Jul | 28-Jul | 29-Jul | 30-Jul | 31-Jul | 1-Aug | 2-Aug | 3-Aug | 4-Aug | 5-Aug | 6-Aug | 7-Aug | 8-Aug | 9-Aug | 10-Aug | 11-Aug | 12-Aug | 13-Aug | 14-Aug | 15-Aug | 16-Aug | 17-Aug | 18-Aug | 19-Aug | 20-Aug | 21-Aug | 22-Aug | 23-Aug | 24-Aug | 25-Aug | 26-Aug | 27-Aug | 28-Aug | 29-Aug | 30-Aug | 31-Aug | 1-Sep | 2-Sep | 3-Sep | 4-Sep | 5-Sep | 6-Sep | 7-Sep | 8-Sep | 9-Sep | 10-Sep | 11-Sep | 12-Sep | 13-Sep | 14-Sep | 15-Sep | 16-Sep | 17-Sep | 18-Sep | 19-Sep | 20-Sep | 21-Sep | 22-Sep | 23-Sep | 24-Sep | 25-Sep | 26-Sep | 27-Sep | 28-Sep | 29-Sep | 30-Sep
BELLINGHAM | [NAME]
BELLINGHAM | [NAME]
Burlington | [NAME]
Burlington | [NAME]
Burlington | [NAME]
Burlington | [NAME]
Burlington | [NAME]
Burlington | [NAME]
GONZALES | [NAME]
GONZALES | [NAME]
GONZALES | [NAME]
GONZALES | [NAME]
GONZALES | [NAME]
GONZALES | Lionel Carr
GONZALES | [NAME]
GONZALES | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
GRIFFITH | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | Colton Case
LAPORTE | Curtis Addington
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | Mitchell Rivers
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
LAPORTE | [NAME]
POCA | [NAME]
POCA | [NAME]
POCA | [NAME]
POCA | [NAME]
POCA | [NAME]
POCA | [NAME]
POCA | [NAME]
POCA | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
RANCHO | [NAME]
SALT LAKE CITY | [NAME]
SALT LAKE CITY | [NAME]
SALT LAKE CITY | [NAME]
SALT LAKE CITY | [NAME]
SANDUSKY | [NAME]
SANDUSKY | [NAME]
SANDUSKY | [NAME]
SANDUSKY | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
TULSA | [NAME]
Spreadsheet: 703926d1605237440-conditional-formatting-a-range-of-cells-based-on-a-range-of-cells-on-another-sheet-operationsahcc-schedule-opening-week-15-21
Sheet: Availability

EMPLOYEE | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  | Not Available
Daylen |  |  |  |  |  |  |  |  |  | Full Availability
[NAME], Jared |  |  |  |  |  |  |  |  |  | Evenings
Dunford, Annie-Laurie |  |  |  |  |  |  |  |  |  | Mornings
Bourgaize, [NAME]
Nowdlak, Haali
Cloutier-Ellsworth, Mister
[NAME], Harley
Flores, [NAME]
D'argencourt, Katia
McNeil, Lauren
Okalik, Nathalia
Freda, [NAME]
Akpik, [NAME]
Carbonneau, [NAME]
Eaton, [NAME]
Spreadsheet: 169297d1342775459-countifs-statement-with-a-vlookup-as-well-countif-based-on-vlookup
Sheet: Totals

 | FY 09
 | 1st Qtr | 2nd Qtr | [NAME] | [NAME]
CA | 1 | 0 | 1 | 1
IL | 0 | 0 | 0 | 0
VT | 0 | 1 | 0 | 1
AZ | 1 | 1 | 0 | 1
OH | 0 | 0 | 0 | 0
MA | 0 | 0 | 0 | 0
OR | 0 | 0 | 0 | 0
WY | 0 | 0 | 1 | 0
 |  |  | SUMPRODUCT(VLOOKUP(Recieved!E:E,'Zip Codes'!'Zip Codes'!$C:$C,1,True))
 |  |  | COUNTIFS(VLOOKUP(Recieved!E:E,'Zip Codes'!$C$2$:C$11,3,true),,Recieved!I:I,2009,Recieved!J:J,1)
 | What I am trying to do is countif Received I:I, 2009 and Received J:J 1 and if Received E:E contains the first 5 numbers for the zip code for CA as marked in Zip Codes column C
Spreadsheet: 876007d1722637588-sorting-between-brackets-detect-characters-in-name
Sheet: Sorted Data

Sorted by Zone | Unique instance of zone for the group of names | Full Name
DA.1 | DA.1 | BB OT - [DA.1] - Nurse - Core
DA.1 |  | C OT - [DA.1] - Nurse
DA.1 |  | CB OT - [DA.1] - Nurse - Core
DA.1 |  | CZ OT - [DA.1] - Nurse
DA.1 |  | Z OT - [DA.1] - Nurse
FA.11 | FA.11 | B Partial - [FA.11] - Nurse
FA.11 |  | C Partial - [FA.11] - Nurse - Core
QA.21 | QA.21 | A PM - [QA.21] - Nurse
RA.1 | RA.1 | A Full - [RA.1] - Nurse
ZA.1 | ZA.1 | A DTM - [ZA.1] - Nurse
ZA.1 |  | B DTM - [ZA.1] - Nurse
ZA.1 |  | DTM - [ZA.1] - Nurse
Final Result
Spreadsheet: e51065aa-755d-4a57-ba4c-95820e805700
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
FHE4 | Test | FHE4 | HE4 | HE4 | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 1.5 | mL | Draw blood in a plain red-top tube. Separate within 24 hours and send 1.5 mL of serum frozen in plastic vial. | 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reference Values: <=114   HE4 Assay Manufacturer: [NAME] Methodology: Enzyme Immunometric Assay Assay Sensitivity: 15 pmol/L   HE4 values obtained with different assay methods or kits cannot be used interchangeably. Results cannot be interpreted as absolute evidence of the presence or absence of malignant disease.   Test Performed by:	Women and Infants 			AFP Laboratory, Second Floor 			70 Elm Street 			Providence, RI 02903 | Thursday | 1 day | 3 - 18 days | 1 | 86305 |  |  |  |  | Women and Infants Hospital AFP Laboratory, Second Floor
FHE4 | [NAME] | SRED | Serum Red |  |  |  | Frozen
FHE4 | Result | Z2378 | HE4 | HE4 | Numeric |  |  |  |  | pmol/L |  |  |  |  |  |  |  |  |  | 55180-4
Spreadsheet: 882874d1731349721-values-to-be-changed-depending-which-year-goes-on-yearfilechange
Sheet: Blad1

 |  | Sheet name: Headfile
 |  |  | 100 | 200 | 300 | 400
 |  | Sheet name: | YEAR 2021 |  |  | I want the values to move one step backwards for each new year that goes on!
 |  |  |  |  |  | Values to be picked up from diffferent sheet depending on which year.
 |  | Value in cell D10 | 100 |  |  | In my case I have made the sheet name be: YEAR 2021
 |  | Sheetname: | YEAR 2022
 |  | Value in cell D10: | 200
 |  | Sheetname: | YEAR 2023
 |  | Value in cell D10 | 300
Spreadsheet: 143474d1330438075-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (15) Melt shop

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | Melt Shop
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
x | fix bent yellow safety pole & fix or remove beam hanging down | Above 194 & 195 E-box (across from plate area) | carryover
x | toe board needed | south end of rebricking platform | carryover
x | fall protection/railings needed on old #2 Furnace Platform | area closest to #1 furnace | carryover
x | re-secure roof line trim | outside west wall south of lime tank | carryover
x | replace metal wall section next to beam 15 | NW corner nearAOD Baghouse hopper | carryover
x | repair chains on plaform around ladle area | Rebricking platform | carryover
x | repair pole for fall protection chains | #1 furnace | carryover
x | emergency light out | in entrance way to back door of lower locker rm | complete
x | e-box door broken | behind ladle wall near AOD
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - Housekeeping okay, keep items away from mandoors, clean up items behind #1 furance pit
ESCORT: | [NAME]
Spreadsheet: 2b11c850-ce10-477c-8b36-1c2f5fdf89b0
Sheet: Computing

COMPUTING CAR
Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
Biology | BIOL 350
Business | BUSN 336
Chemistry | CHEM 325
 | CHEM 340
Computer Science | CSCI 106
 | CSCI 107
 | CSCI 111
 | CSCI 112
 | CSCI 181
Drama | DRAM 331
Economics | ECON 312
Educations | EDUC 346
Mathematics | MATH 107
 | MATH 113
 | MATH 141
 | MATH 142
 | MATH 203
Music | MUSC 322
 | MUSC 371
Political Science | PSCI 301
Psychology | PSYC 201
Sociology | SOCI 300
Honors Program | HONR 249
 | HONR 254
 | HONR 258
 | HONR 292