tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0f05f31a-c57d-4018-ae6f-2c3cbdee2fad
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Contributor Organizations | Host Website | Format | Availability | DOI | Full Text
International H2O Project (IHOP) 2002:  Datasets Related to Atmospheric Moisture and Rainfall Prediction | Schanot, [NAME] [IHOP 2002 PI]; [NAME], [NAME] [IHOP 2002 PI] |  | 1087653 |  |  |  | Collection | Numeric Data |  |  | USDOE SC Office of Biological and Environmental Research ([NAME]); National Aeronautics and Space Administration (NASA); National Oceanic and Atmospheric Administration (NOAA); National Science Foundation (NSF); Department of Defense (DOD); [NAME] for Bildung und Forschung (Germany); Centre National de Recherché Scientifique Service [NAME] (France); Canadian Foundation for Climate and Atmospheric Sciences | 54 ENVIRONMENTAL SCIENCES | Quantitative Precipitation Forecasting; Convection; Atmospheric Boundary Layer | IHOP 2002 was a field experiment that took place over the Southern Great Plains of the United States from 13 May to 25 June 2002. The chief aim of IHOP_2002 was improved characterization of the four-dimensional (4-D) distribution of water vapor and its application to improving the understanding and prediction of convection. The region was an optimal location due to existing experimental and operational facilities, strong variability in moisture, and active convection [copied from http://www.eol.ucar.edu/projects/ihop/].  The project&#x27;s master list of data identifies 146 publicly accessible datasets. |  | NCAR Earth Observing Laboratory |  |  |  | http://www.osti.gov/dataexplorer/servlets/purl/1087653
Spreadsheet: 163344d1340282813-offset-weeks-with-multiple-criteria-example
Sheet: Sheet1

YEAR | WEEK | DAY |  |  |  | current year | 2013
2012 | 51 | mon |  |  |  | current week | 4 |  |  | Week: | 50 | 51 | 52 | 1 | 2
2012 | 51 | tue
2012 | 51 | [NAME]
2012 | 51 | thu
2012 | 51 | fri
2012 | 51 | sat
2012 | 51 | [NAME]
2012 | 52 | mon
2012 | 52 | tue
2012 | 52 | [NAME]
2012 | 52 | thu
2012 | 52 | fri
2012 | 52 | sat
2012 | 52 | [NAME]
2013 | 1 | mon
2013 | 1 | tue
2013 | 1 | [NAME]
2013 | 1 | thu
2013 | 1 | fri
2013 | 1 | sat
2013 | 1 | [NAME]
2013 | 2 | mon
2013 | 2 | tue
2013 | 2 | [NAME]
2013 | 2 | thu
2013 | 2 | fri
2013 | 2 | sat
2013 | 2 | [NAME]
Spreadsheet: 462956d1464258143-lookup-formula-with-more-than-2-criteria-lookup-with-more-than-2-criteria
Sheet: Actual

 |  |  |  |  |  |  |  |  | ACTUAL | ACTUAL | ACTUAL |  | ACTUAL
 | Category |  | Full Year 2015 |  | 2016-01-15 00:00:00 |  | [NAME] |  | 2016-01-15 00:00:00 |  |  |  | Q1 2016
 | Current Assets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual
 | Cash |  | 0 |  |  |  |  |  | 500 | 400 | 250 |  |  |  |  | 2016-01-15 00:00:00 | Planned
 | Bank of America Checking |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Bank of America Payroll |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | [NAME] |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | Q1 2016
 | Petty Cash |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank- Operations |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Union Bank- Payroll |  | 0 |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | Q2 2016
 | Union Bank- Recurring Payments |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
 | Bank of the West- Operations |  | 0 |  | 0 |  |  |  | 0 | 0 | 0
Spreadsheet: 804803d1668367761-make-purchase-order-with-database-in-excel-po-sample
Sheet: Database

S.# | Date | PO NO | Requested By | Cost Centre | M/R Ref. No. | Payment Method | Mode of Payment | Company Name | Address | Contact | [NAME] | Item Description | Model | Make | Unit | Qty. | Disc.(%) | Unit Price | Amount | Subtotal (Rs.) | Sales Tax (%) | Other Cost | Shipping & Handling | Total Amount
1 | 2022-11-09 00:00:00 | 1 | SC PERSON | 8824 | 2254 | 45 Days | Bank Transfer | ABC Private Ltd. | Address: xyz | 313164 | [EMAIL] | Bolts 6x15 | ARK | Local | Nos | 100 | 0.1 | 3.5 | 315 | 315 | 901.8 | 0 | 800 | 9216.8
Spreadsheet: 46123d1245015286-want-to-automate-the-recording-of-data-from-one-worksheet-to-another-fruitexample2
Sheet: Oranges

Key | Date | Fruit | Units | Cost |  | Status: OK
1 | 2009-02-15 00:00:00 | Oranges | 4 | 32
2 | 2009-02-16 00:00:00 | Oranges | 7 | 56 |  | Key column in column A on each fruit page, you can hide this
3 | 2009-02-16 00:00:00 | Oranges | 7 | 56 |  | column once you've copied the formula down far enough.
4 | 2009-02-19 00:00:00 | Oranges | 3 | 24
5 | 2009-02-20 00:00:00 | Oranges | 1 | 8
Spreadsheet: 141406d1329249478-specific-drop-down-selections-transfer-entire-row-to-new-table-job-file-sample-1
Sheet: -

 | Subs | Address | City, ST, Zip | [NAME]) | Fax/Email
 | Job Owners
 | D/C Reasons
 | [NAME]…
 | Partial Work Pmt Request: Sent to JOB OWNER  +
 | Partial Work Pmt: Paid to SUB  -
 | Partial Work Pmt: Factored from BANK  +
 | Full Work Pmt Request: Sent to JOB OWNER  +
 | Full Work Pmt: Paid to SUB  -
 | Full Work Pmt: Factored from BANK  +
 | Supplement Request: Sent to JOB OWNER  +
 | Supplement: Paid to SUB  -
 | Supplement: Factored from BANK  +
 | Change Order Request: Sent to JOB OWNER  +
 | [NAME]: Paid to SUB  -
 | [NAME]: Factored from BANK  +
 | Factor Fee: Paid to BANK  -
 | Factor Fee: Received from SUB  +
 | Wire Fee: Paid to BANK  +
 | Wire Fee: Received from SUB  +
 | [NAME]. Job Expense  -
 | [NAME]. Job Income  +
Spreadsheet: 932c7139-df2e-4258-9676-12fcd81597bf
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
FFTEI | Test | FFTEI | Teichoic Acid Antibody, Quantitative, ID | Teichoic Acid Ab, Quantitative, ID | Immunodiffusion (ID) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube. (Serum gel tube(s) are acceptable.) Spin down and send 1.0 mL of serum, refrigerate. | 0.1 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | REFERENCE RANGE:  <1:1   INTERPRETIVE CRITERIA:                                         <1:1  Antibody not detected                                > or = 1:1  Antibody detected   Antibody titers of 1:4 and greater against Staphylococcal beta-ribitol teichoic acid are associated with deep-seated Staphylococcus aureus infections. Rising and falling titers are of prognostic value in the evaluation of treatment and detection of recurrence.   TEST PERFORMED BY FOCUS DIAGNOSTICS, INC.                                                   5785 CORPORATE AVE                                                   CYPRESS, CA 90630-4750 | Monday through Friday | 2 - 5 days | 4 - 7 days | 1 | 86329 |  |  |  |  | Focus Diagnositics, Inc.
FFTEI | [NAME] | SERUM | Serum |  |  |  | Refrigerated
FFTEI | Result | Z0675 | Teichoic Acid Ab,  Quantitative, ID | Teichoic Acid Ab,  Quantitative, ID | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 62f489a8-cd23-4f61-9ee6-516adca5f95b
Sheet: meetings_map

Locations | Placeholder
Baltimore, MD | 1
Sacramento, CA | 1
Minneapolis, MN | 1
Portland, OR | 1
[NAME], TX | 1
Pittsburgh, PA | 1
Albuquerque, NM | 1
Milwaukee, WI | 1
San Jose, CA | 1
Memphis, TN | 1
Montreal, Canada | 1
Portland, OR | 1
Savannah, GA | 1
Tucson, AZ | 1
[NAME], WI | 1
Snowbird, UT | 1
Spokane, WA | 1
Albuquerque, NM | 1
Providence, RI | 1
Knoxville, TN | 1
Honolulu, HI | 1
San Antonio, TX | 1
Toronto, Canada | 1
[NAME], CA | 1
Columbus, OH | 1
Syracuse, NY | 1
[NAME], CO | 1
Fargo, ND | 1
University Park, PA | 1
[NAME], IN | 1
Stillwater, OK | 1
Athens, GA | 1
East Lansing, MI | 1
New Orleans, LA | 1
[NAME], OR | 1
Tempe, AZ | 1
University of Massachusetts | 1
University of Minnesota | 1
Colorado State University | 1
University of Vermont | 1
University of Wisconsin | 1
College Station, TX | 1
University of Maryland | 1
University of Illinois | 1
University of Colorado | 1
University of Massachusetts | 1
Purdue University | 1
Stillwater, OK | 1
University of Indiana | 1
Stanford University | 1
University of Connecticut | 1
Michigan State University | 1
University of Florida | 1
Ithaca, NY | 1
University of Minnesota | 1
Ohio State University | 1
New York, NY | 1
University of Maryland | 1
Chicago, IL | 1
Boston, MA | 1
St. Louis, MO | 1
Cleveland, OH | 1
 | 1
Dallas, TX | 1
Philadelphia, PA | 1
Richmond, VA | 1
Indianapolis, IN | 1
Atlantic City, NJ | 1
Pittsburgh, PA | 1
Des Moines, IA | 1
Nashville, TN | 1
Kansas City, MO | 1
Washington, DC | 1
Cincinnati, OH | 1
Baltimore, OH
Spreadsheet: 716649d1612299183-if-date-sunday-then-highlight-monday-timesheet-template-sample-
Sheet: June - July 

 | Name: |  |  |  |  |  |  | Supervisor:
 |  |  | Start | End | (Position) | (Position) | TOTAL HOURS | Comments | Substitute | [NAME] | Personal Leave | Other | Holiday
 | Total Hours
 |  |  |  |  |  | Check
 |  |  |  |  |  |  |  | OVERTIME |  | SL | PL | Other | Holiday
 | LAST week/LAST Month
 | Week 1
 | Week 2
 | Week 3
 | Week 4
 | Week 5
 | TOTALS
 | Check
Spreadsheet: 881594d1729699428-need-formula-for-multiple-lookups-to-return-just-one-value-excel-forum-question-multiple-lookup-to-return-one-value
Sheet: Output

YEAR 11
 |  | WORKING AT GRADES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ATTITUDE TO LEARNING
Code | Name | Art | Biology | Business | Chemistry | Computer Science | DT | Drama | [NAME] | Eng Lit | French | Geography | German | History | Maths | Music | Music Tech | PE | Physics | RE | Spanish | Travel&Tourism |  | Art | Biology | Business | Chemistry | Computer Science | DT | Drama | [NAME] | Eng Lit | French | Geography | German | History | Maths | Music | Music Tech | PE | Physics | RE | Spanish | Travel&Tourism
ALD002​ | ALDERTON, [NAME]
BEA003​ | BEAN, [NAME]
CAM009​ | CAMPBELL, Sapphire
CAN006​ | CANTLIFF, Summer
CAT006​ | CATTIGAN, [NAME]
FEN008​ | FENNELL, [NAME]
GRO006 | GROUT, [NAME]
Spreadsheet: 875349d1721933715-sum-based-on-multiple-criteria-demo-250724
Sheet: Vertical

Criteria marked in red font
 |  |  |  |  | Months
Main Vertical | PC Name | PC Code | FS Item/Acct/FA Long | GL Code | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 |  | 2024-04-01 00:00:00 | 2024-05-01 00:00:00
Head Office | Head Office | 629050001 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Franchisee | [NAME] | 629060001 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Franchisee | Fran East | 629060002 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Franchisee | Fran South | 629060003 | Fully Paid Equity Sh MMC /10010000 | 10010000 |  |  | <------Result
Head Office | Head Office | 629050001 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Franchisee | [NAME] | 629060001 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Franchisee | Fran East | 629060002 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Franchisee | Fran South | 629060003 | Share Application Eq MMC /10050000 | 10050000 |  |  | <------Result
Spreadsheet: 726604d1617311967-index-indirect-match-function-issue-indirect-invoice-total
Sheet:  Template

Invoice Period | Name | Invoice No | USD | CCY | Invoice Total CCY | Invoice Total USD
2021-01-01 00:00:00 | Example | 46547-[PHONE] | USD | N/A |  |  | Here is the [NAME] I created but cant get it correct
2021-01-01 00:00:00 | Example | 166465789-[PHONE] | EUR | EUR
2021-01-01 00:00:00 | Example | 98787-299467989 | USD | N/A
2021-01-01 00:00:00 | Example | [PHONE]-[PHONE] | USD | N/A
2021-01-01 00:00:00 | Example | 48-000046549 | USD | N/A
Spreadsheet: 086e0f36-8231-4d9e-a768-b7347a491bc4
Sheet: Sheet1

CIRCLE ONE | Unnamed: 1 | Unnamed: 2 | CIRCLE ONE.1 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | SPORT | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | SCHOOL | Unnamed: 14 | DATE | Unnamed: 16
GENDER: BOYS   GIRLS |  |  | LEVEL:  FR   JV   VAR
YOUR SCORE | OPPONENT | THEIR SCORE | YOUR WIN? | YOUR LOSS? |  | YOUR SCORE | OPPONENT | THEIR SCORE | YOUR WIN? | YOUR LOSS? |  | YOUR SCORE | OPPONENT | THEIR SCORE | YOUR WIN? | YOUR LOSS?
NON-DISTRICT GAMES * |  |  |  |  |  | DISTRICT GAMES |  |  |  |  |  | PLAY-OFFS
 |  |  |  |  |  |  | 1 |  |  |  |  |  | BI-DISTRICT
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3 |  |  |  |  |  | AREA
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5 |  |  |  |  |  | REG SEMI-FINALS
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7 |  |  |  |  |  | REG./REG.FINALS
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9 |  |  |  |  |  | QUARTER FINALS
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11 |  |  |  |  |  | STATE SEMI-FINALS
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 13 |  |  |  |  |  | STATE/STATE FINALS
 |  |  |  |  |  |  | 14
 |  |  |  |  |  | SUB TOTAL OF WON/LOST DISTRICT GAMES
 |  |  |  |  |  | PLACED ____________ IN DISTRICT
 |  |  |  |  |  | (IF NECESSARY, PLAYOFF GAME FOR DISTRICT TIE)
TOTAL OF WON AND LOST                  NON-DISTRICT GAMES |  |  |  |  |  | GRAND TOTAL OF WON/LOST DISTRICT GAMES |  |  |  |  |  | TOTAL PLAYOFF WON/LOST
OVERALL WON/ LOST
* For Volleyball and Basketball, include tournament games as Non-District Games.
COACH: |  |  |  |  |  |  | COORDINATOR:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PAD/FORMS/H.S.WIN/LOSS
Spreadsheet: 88141d1288054833-excel-2010-conditional-formatting-across-mulitpe-colums-patch
Sheet: Sheet1

DEVICE | PORT | DEVICE | PORT | DEVICE | PORT | DEVICE | PORT
EDGE1 | 2/01 | R2C2-PPB | 1 | R5C4-PPA | 3 | CISCO-DWDM-BCT-BCC | SL17-UC
EDGE1 | 2/02 | R2C2-PPA | 19 | R5C4-PPA | 4 | CISCO-DWDM-BCT-BCC | SL8-UC
EDGE1 | 2/03 | R2C2-PPA | 20 | R1C4-PPA | 7 | BDC-NOC-ASA | 1
EDGE1 | 2/04 | R2C2-PPA | 22 |  |  | R1C0-NORTEL SWITCH | 9
EDGE1 | 2/05 | R2C2-PPA | 08 | R2C3-PPY | 2 | BCT-SW1 | 1
EDGE1 | 2/06 | R2C2-PPC | 10 | R1C4-PPA | 9 | BDC-NOC-SW1 | 7
EDGE1 | 2/07 | R2C2-PPA | 7 | R1C2-PPB | 3 | BCC-PIPN1 | GE0/1
EDGE1 | 2/09 | R2C2-PPA | 21
EDGE1 | 2/10 | R2C2-PPA | 11
EDGE1 | 2/12 | R2C2-PPC | 23
EDGE1 | 2/20 | R2C2-PPB | 3
EDGE1 | 2/21 | R2C2-PPC | 9
EDGE1 | 2/22 | R2C2-PPC | 8
EDGE1 | 2/25 | R2C2-PPA | 8
EDGE1 | 2/30 | R2C2-PPA | 13
EDGE1 | 2/37 | R2C2-PPC | 5
EDGE1 | 2/38 | R2C2-PPC | 6
EDGE1 | 2/43 | R2C2-PPC | 13
EDGE1 | 2/44 | R2C2-PPC | 3
EDGE1 | 2/45 | R2C2-PPB | 10
EDGE1 | 2/47 | R2C2-PPA | 23
EDGE1 | 2/48 | BCC-RR1
EDGE1 | 3/01
EDGE1 | 3/03
EDGE1 | 3/07
EDGE1 | 3/08
EDGE1 | 3/10
EDGE1 | 3/11
EDGE1 | 3/13
EDGE1 | 3/14
EDGE1 | 3/17
EDGE1 | 3/20
EDGE1 | 3/22
EDGE1 | 3/23
EDGE1 | 3/24
EDGE1 | 3/26
EDGE1 | 3/28
EDGE1 | 3/31
EDGE1 | 3/32
EDGE1 | 3/34
EDGE1 | 3/35
EDGE1 | 3/36
EDGE1 | 3/37
EDGE1 | 3/38
EDGE1 | 3/39
EDGE1 | 3/41
EDGE1 | 3/42
EDGE1 | 3/43
EDGE1 | 3/44
EDGE1 | 3/45
EDGE1 | 3/47
EDGE1 | 3/48
EDGE1 | 6/1
EDGE1 | 6/2
Spreadsheet: 678602d1589977628-how-to-search-2-columns-for-the-information-entered-in-one-column-samplefile
Sheet: supply

SCAN | [NAME] | UNIT PRICE | QUANTITY | TOTAL COST | ITEM# | CAT.#
172 |  |  | 2
 | I need to have all grey columns populated from the results of the lookup in column A
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: B2

Local 2
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 40
Paiement dû le: | 2013-02-24 00:00:00
[NAME]: | 88
Réservé:
Prix: | 140
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 130759d1322574035-ranked-lookup-first-four-tasks
Sheet: Sheet1

 | Emp ID | Task Code |  | Emp ID | Task 1 | Task 2 | Task 3 | Task 4
 | EMP 0001 | 7047 |  | EMP 0001 | 1248 | 2377 | 3399 | 3849
 | EMP 0001 | 3399 |  | EMP 0002
 | EMP 0001 | 2377 |  | EMP 0003
 | EMP 0001 | 4820
 | EMP 0001 | 1248
 | EMP 0001 | 9538
 | EMP 0001 | 3849
 | EMP 0001 | 9329
 | EMP 0002 | 8178
 | EMP 0002 | 5742
 | EMP 0002 | 9353
 | EMP 0002 | 3498
 | EMP 0002 | 8476
 | EMP 0002 | 4188
 | EMP 0002 | 2397
 | EMP 0002 | 6343
 | EMP 0003 | 1604
 | EMP 0003 | 9993
 | EMP 0003 | 2771
 | EMP 0003 | 6039
 | EMP 0003 | 1611
 | EMP 0003 | 3271
 | EMP 0003 | 7110
 | EMP 0003 | 1498
Spreadsheet: 120515d1315344355-how-to-do-this-lookup-stats-help
Sheet: Sheet1

 | ZONE 1 BEST PICK RATE |  |  |  | ZONE 1 WORST PICK RATE |  |  |  | OVERALL NUMBERS
 | [NAME] | 0.83 | 2011-09-08 00:00:00 |  | [NAME] | 0.6 | 2011-09-06 00:00:00 |  | PICKER | PICKED | NOT PICKED
 |  |  |  |  |  |  |  |  | [NAME] | 178 | 45
 | ZONE 2 BEST PICK RATE |  |  |  | ZONE 2 WORST PICK RATE |  |  |  | [NAME] | 135 | 37
 | [NAME] | 0.92 | 2011-09-05 00:00:00 |  | [NAME] | 0.75 | 2011-09-06 00:00:00 |  | [NAME] | 100 | 46
 |  |  |  |  |  |  |  |  | [NAME] | 37 | 11
 | ZONE 3 BEST PICK RATE |  |  |  | ZONE 3 WORST PICK RATE
 | [NAME] | 1 | 2011-09-06 00:00:00 |  | [NAME] | 0.78 | 2011-09-09 00:00:00
 | ZONE 4 BEST PICK RATE |  |  |  | ZONE 4 WORST PICK RATE
 | [NAME] | 0.83 | 2011-09-08 00:00:00 |  | [NAME] | 0.42 | 2011-09-05 00:00:00
Spreadsheet: 842796d1694773897-problems-with-appending-columns-to-new-tables-combine_column
Sheet: InputOutput

Signal Type |  | Signal Name | Notes: Unallocated signals are left blank. The data in these tables is appended in the CombinedSignals worksheet.
28v_IN0 |  | ctrl_valve_interlk0
28v_IN1 |  | ctrl_valve_interlk1
28v_IN2 |  |  | Unallocatted
5v_IN0 |  | lvl_sch0
5v_IN1 |  |  | Unallocatted
Analog_IN0 |  | eng_temp0
Analog_IN1 |  |  | Unallocatted
Analog_IN2 |  |  | Unallocatted
Signal Type |  | Signal Name
28v_OUT0 |  | ctrl_valve_pos0
28v_OUT1 |  | ctrl_valve_pos1
28v_OUT2 |  |  | Unallocatted
5v_OUT0 |  | eng_alm0
5v_OUT1 |  |  | Unallocatted
PWM_0 |  | [NAME]
Spreadsheet: jeff_dasovich__14057__OAT Valuation 0416
Sheet: OAT Inputs

INPUT SCREENS
Acquirer: |  |  |  |  |  |  | Most recent year end: |  |  | 2000-12-01 00:00:00 | 2000
Target: |  |  |  | Quaker Oats |  |  | Currency: |  |  | Dollars in millions
DISCOUNTED CASH FLOW INPUTS
Discount rate: |  |  |  | 0.12 |  |  | OAT stand alone effective tx rate
Terminal value multiple (x EBITDA): |  |  |  | 7
Resultant valuation:
Total enterprise value ($M)
Value per common share
MERGER MODEL INPUTS
[NAME] stand alone earnings estimates: |  |  |  |  |  |  |  |  |  |  | LTG
 |  |  |  |  |  | 0 | 0 |  |  |  | 0
Anticipated synergies / cost savings: |  |  |  | % of SGA |  | 0 | 0 | 0 | 0 | 0
(enter one OR the other) |  |  |  | total $ (in millions) |  | 0 | 0 | 0 | 0 | 0
 |  |  |  | Accretion | w/ repurch
 |  |  |  |  | w/o repurch
Other inputs |  |  |  |  |  | Purchase Accounting
 |  |  |  |  |  | Allocation of purchase price / mark to market adjustments
Primary shares, seller |  |  |  | 131933000 |  | [NAME] shares not already owned by buyer |  |  |  | 28.8 | million
Primary shares, buyer |  |  |  | 232200000 |  | Exchange ratio |  |  |  | 0
 |  |  |  |  |  | New shares issued |  |  |  |  | million
Goodwill deductible ?? |  |  |  | no
Amortization period of goodwill (yrs) |  |  |  | 0 |  | Safeway stock price per share |  |  |  | 0
Marginal income tax rate |  |  |  | 0 |  | Deal value for part of Vons notalready owned
Equity in undistributed income of seller ($M) |  |  |  | 34 |  | Current investment in Vons
Share repurchase assumptions: |  |  |  |  |  | Value of options assumed by Safeway
Safeway stock price per share |  |  |  | 0 |  | and transaction costs for the deal
Shares repurchased (choose ONE): |  |  |  |  |  | Total deal value
% of post transaction total |  |  |  | 0 |  | Book value of Vons
number of shares to buy back (M) |  |  |  | 0 |  | Premium to book value
Cost of funds to repurchase shares |  |  |  | 0 |  | Allocation of premium
Deal summary: |  | Vons share price, pre transaction |  |  | 43 | Inventory
 |  |  |  |  |  | Other assets
DCF valuation : |  | Vons per share |  |  |  | Deferred tax liability
 |  | Total enterprise value ($M) |  |  |  | Other liabilities
Deal value: |  | Total deal value ($M) |  |  |  | Goodwill
 |  | Total OAT shares
 | Deal value for previously unowned shares |  |  |  |  | Accretion: |  | Book value
 | Previously unowned shares |  |  |  |  |  |  | Earnings per share (year 1)
Spreadsheet: 690201d1596943007-create-combinations-and-count-them-create-combinations-and-count_chris
Sheet: Sheet1

Data |  |  |  |  |  |  |  | Result
Order # | Item #1 | Item #2 | Item #3 |  |  |  |  | Combination | Count
1045 | A | B |  |  |  |  |  | AB or BA | 2
1046 | C | B | A |  |  |  |  | AC or CA | 2
1047 | D | E |  |  |  |  |  | BC or CB | 1
1048 | F | G | B |  |  |  |  | DE or ED | 1
1049 | A | C |  |  |  |  |  | FG or GF | 1
 |  |  |  |  |  |  |  | GB or BG | 1
 |  |  |  |  |  |  |  | BF or FB | 1
Spreadsheet: kate_symes__18286__Deal Correction 4-9
Sheet: 3-28

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-03-28 00:00:00 | 2001-03-28 00:00:00 | 2001-03-27 00:00:00 | LTSW | KS | MM | EDF Man | Futures deals added and backdated |  | 563886/ 928/937 | MID-C/PV/COB | J-01 | On [NAME] | 25/12/1 | 365/300/325 | PWX/Vernon/Avista
 | 2001-03-28 00:00:00 | 2001-03-28 00:00:00 | 2001-03-27 00:00:00 | STSW | TA | Houston | APB | Broker fee: .0075 to .0275 |  | 562195 | Palo Verde | 2001-03-28 00:00:00 | On [NAME] | 25 | 120.02 | LADWP
 | 2001-03-28 00:00:00 | 2001-03-28 00:00:00 | 2001-03-27 00:00:00 | STCA | CM | Houston | Prebon | Added and backdated late deal |  | 562978 | NP-15 | Q2-01 | [NAME] | 25 | 180 | Duke
 |  |  |  | Grand Count
Spreadsheet: 282311d1386337889-conditional-format-dates-greater-than-18-months-and-24-months-certificationtestmetrics
Sheet: Sheet1

AS OF: | 2013-12-05 00:00:00
Name | Primary ORG | Certified (Y/N) | Keysone?  (Y/N) | Date Entered | Time to achieve cert (months) | Date of  Certification
 |  | Y | N |  |  | 2010-03-15 00:00:00
 |  | Y | N |  |  | 2012-02-23 00:00:00
 |  | N | N | 2013-01-24 00:00:00 | 2015-01-24 00:00:00
 |  | N | Y | 2013-08-26 00:00:00 | 2016-08-26 00:00:00
 |  | Y | N |  |  | 2007-08-04 00:00:00
 |  | Y | N |  |  | 2003-05-05 00:00:00
 |  | Y | N |  |  | 1997-06-06 00:00:00
 |  | N | N
 |  | Y | N |  |  | 2000-12-12 00:00:00
 |  | Y | N |  |  | 2008-10-28 00:00:00
 |  | Y | N |  |  | 1997-01-01 00:00:00
Spreadsheet: hunter_shively__12686__Daily Prices
Sheet: Sheet1

Summary of Central Deals
All Central Deals: 11/19/2001 12:03:35 PM
Product ID | [NAME] | Weighted Average ($/MMBtu) | High Trade ($/MMBtu) | Low Trade ($/MMBtu) | [NAME] (MMBtu/day)
27760 | Consumers Pwr | 2.012333823489367 | 2.045 | 1.975 | 36723
27764 | [NAME] | 2.247135809690008 | 2.48 | 2.075 | 208586
27812 | ANR | 1.955681364010608 | 2.36 | 1.895 | 241699
27813 | ANR OK | 2.002938168044897 | 2.365 | 1.745 | 252135
27817 | NGPL LA Pool | 2.017557566808269 | 2.33 | 1.875 | 250231
27818 | NGPL Midcont | 1.900060207452249 | 2.375 | 1.725 | 289416
27822 | NGPL TxOkGCPool | 1.979150549965081 | 2.315 | 1.8575 | 126008
27824 | NNG Demarc | 2.099191950281308 | 2.39 | 1.81 | 372013
27826 | PEPL Pool | 1.938066772105404 | 2.43 | 1.735 | 578535
29399 | NBPL/ANR WillCo | 2.025 | 2.09 | 1.96 | 10000
29490 | OGT | 1.75 | 1.75 | 1.75 | 4783
29602 | Dawn | 2.464718186521366 | 2.55 | 2.22 | 210689
29606 | [NAME], TCPL | 2.439617866632924 | 2.65 | 2.2 | 23709
32775 | Trunkline ELA | 2.00767812641595 | 2.08 | 1.8225 | 44140
32936 | APC/ANR WillCo | 2.155564697083022 | 2.27 | 1.955 | 33425
33427 | Trunkline STX | 2.08 | 2.08 | 2.08 | 6264
35041 | NGPL AmarilloML | 1.865851063829787 | 1.985 | 1.81 | 47000
36733 | Iroquois, TCPL | 2.17 | 2.18 | 2.16 | 20000
47095 | NNG Ventura | 1.965281380961884 | 2.105 | 1.835 | 135297
47186 | Harper | 2.027159805395271 | 2.25 | 1.9 | 61869
47636 | NBPL/Ventura | 2.093606243256316 | 2.115 | 2.06 | 26877
Chicago | Chicago City Gates | 2.033802406511321 | 2.535 | 1.875 | 2545843
Chicago City Gates composed of Peoples, NBPL Nicor, NGPL Nicor, and NIPSCO.