tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 385867d1427465756-random-formula-exam
Sheet: Sheet1

Shelby |  | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-10 00:00:00
Aryan |  | 2015-04-02 00:00:00
Christian |  | 2015-04-03 00:00:00
Logan |  | 2015-04-06 00:00:00
[NAME] |  | 2015-04-07 00:00:00
Zaniyah |  | 2015-04-08 00:00:00
[NAME] |  | 2015-04-09 00:00:00
Alexis |  | 2015-04-10 00:00:00
[NAME] |  | 2015-04-13 00:00:00
Anyah |  | 2015-04-14 00:00:00
[NAME] |  | 2015-04-15 00:00:00
Adeline |  | 2015-04-16 00:00:00
Rosemary |  | 2015-04-17 00:00:00
[NAME] |  | 2015-04-20 00:00:00
Lauren |  | 2015-04-21 00:00:00
Tejapreetham |  | 2015-04-22 00:00:00
Lucas |  | 2015-04-23 00:00:00
[NAME] |  | 2015-04-24 00:00:00
Sean |  | 2015-04-27 00:00:00
[NAME] |  | 2015-04-28 00:00:00
Griffin |  | 2015-04-29 00:00:00
Grady |  | 2015-04-30 00:00:00
[NAME] |  | 2015-05-01 00:00:00
[NAME] |  | 2015-05-04 00:00:00
Landon |  | 2015-05-05 00:00:00
Meredith |  | 2015-05-06 00:00:00
[NAME] |  | 2015-05-07 00:00:00
[NAME] |  | 2015-05-08 00:00:00
Grace |  | 2015-05-11 00:00:00
[NAME] |  | 2015-05-12 00:00:00
Dustin |  | 2015-05-13 00:00:00
Mason |  | 2015-05-14 00:00:00
Stella |  | 2015-05-15 00:00:00
Lillian |  | 2015-05-18 00:00:00
Unity |  | 2015-05-19 00:00:00
Iesha |  | 2015-05-20 00:00:00
Emily |  | 2015-05-21 00:00:00
[NAME] |  | 2015-05-22 00:00:00
[NAME] |  | 2015-05-25 00:00:00
[NAME] |  | 2015-05-26 00:00:00
[NAME] |  | 2015-05-27 00:00:00
Gauge |  | 2015-05-28 00:00:00
Campbell |  | 2015-05-29 00:00:00
[NAME] |  | 2015-06-01 00:00:00
Chester |  | 2015-06-02 00:00:00
Dawson |  | 2015-06-03 00:00:00
Piper |  | 2015-06-04 00:00:00
[NAME] |  | 2015-06-05 00:00:00
[NAME] |  | 2015-06-08 00:00:00
Louis |  | 2015-06-09 00:00:00
Rylan |  | 2015-06-10 00:00:00
Madeline |  | 2015-06-11 00:00:00
Molly |  | 2015-06-12 00:00:00
Grant |  | 2015-06-15 00:00:00
Esher |  | 2015-06-16 00:00:00
Leonard |  | 2015-06-17 00:00:00
Joel |  | 2015-06-18 00:00:00
[NAME] |  | 2015-06-19 00:00:00
Amari |  | 2015-06-22 00:00:00
Calvin |  | 2015-06-23 00:00:00
Rian |  | 2015-06-24 00:00:00
[NAME] |  | 2015-06-25 00:00:00
Jinghai |  | 2015-06-26 00:00:00
Elle |  | 2015-06-29 00:00:00
Troy |  | 2015-06-30 00:00:00
[NAME]
Parker
[NAME]
[NAME]
[NAME]
[NAME]
Ava
Greyson
Zachary
Abram
Marcello
[NAME]
Cameron
[NAME]
Maili
Burke
[NAME]
[NAME]
Payton
[NAME]
Riley
[NAME]
[NAME]
Pierce
Ava
Gavin
Jaden
[NAME]
[NAME]
Haven
Mason
[NAME]
[NAME]
Israel
[NAME]
[NAME]
Zhariana
[NAME]
[NAME]
Priyasha
[NAME]
Victoria
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bianca
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Logan
Noor
[NAME]
[NAME]
Christian
Vera
[NAME]
Niklas
Jakub
Nevaeh
[NAME]
[NAME]
Jessica
Mahi
India
[NAME]
Eva
Spreadsheet: 30841d1226525526-making-a-list-of-names-from-inputted-data-aj-quiz
Sheet: Questions

 |  | QUESTIONS |  | ANSWERS
 | [NAME] | Aircraft operating |  |  |  | 0
 | [NAME] | The Air |  |  |  | 0
 | Q.3 | A service |  |  |  | 0
 | [NAME] | Pilots |  |  |  | 0
 | Q.5 | With respect |  |  |  | 0
 | Q.6 | A Basic |  |  |  | 0
 | Q.7 | A Basic Ser |  |  |  | 0
 | [NAME] | When giving |  |  |  | 0
 | Q.9 | An |  |  |  | 0
 | [NAME] | Traffic |  |  |  | 0
 | Q.11 | Traffic S |  |  |  | 0
 | Q.12 | Service is available: |  |  |  | 0
 | Q.13 | If a p |  |  |  | 0
 | Q.14 | A Controller |  |  |  | 0
 | Q.15 | A D |  |  |  | 0
 | Q.16 | A Dec |  |  |  | 0
 | Q.17 | Under a D |  |  |  | 0
 | Q.18 | A Pro |  |  |  | 0
 | Q.19 | Under a |  |  |  | 0
 | Q.20 | Under a P |  |  |  | 0
 |  |  |  |  |  | 0
 |  | Thank you for completing the *** Quiz |  | Please press anywhere within this box to see your results!
Spreadsheet: mary_fischer__25614__32J
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  32J
COMPANY NAME  Williard Investment Company
ANALYSIS OF GOODWILL
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-00 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 8632bd42-e13b-4f17-b976-f5d426f45149
Sheet: Sheet1

Post Holdings, Inc. | Unnamed: 1 | Unnamed: 2
10-Q
02/07/2014
TABLE OF CONTENTS
PART I. | FINANCIAL INFORMATION | Page
Item 1. | Financial Statements (Unaudited). | 1
 | Condensed Consolidated Statements of | 1
 | Operations (Unaudited).
 | Condensed Consolidated Statements of | 2
 | Comprehensive Income (Unaudited).
 | Condensed Consolidated Balance Sheets | 3
 | ([NAME]).
 | Condensed Consolidated Statements of | 4
 | Cash Flows (Unaudited).
 | Notes to Condensed Consolidated Financial | 5
 | Statements (Unaudited).
Item 2. | Management s Discussion and Analysis of | 21
 | Financial Condition and Results of Operations.
Item 3. | Quantitative and Qualitative Disclosures | 26
 | About Market Risk.
Item 4. | Controls and Procedures. | 26
PART II. | OTHER INFORMATION
Item 1. | Legal Proceedings. | 27
Item 1A. | Risk Factors. | 27
Item 6. | Exhibits. | 28
 | SIGNATURE. | 30
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 865420d1712473179-count-cells-that-have-similar-data-counct-simple-cells
Sheet: Sheet1

 |  |  | Name | address | postcode
 |  |  | [NAME] | 1 test ave | SW1
 |  |  | [NAME] | 1 test ave | SW1
 |  |  | claire | 3 test ave | SW1
 |  |  | zoe | 3 test ave | SW1
 |  |  | martin | 6 test ave | SW1
 |  |  | bob | 1 simple street | NW1
 |  |  | chloe | 1 simple street | NW1
 |  |  | v | 8 go yard | SW11
Spreadsheet: 190a287f-104f-4dd5-869b-413507ad4cca
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Teaching Credit Reporting Form | Unnamed: 4 | Unnamed: 5
Department Reporting Credit:
Reporting Period Start Date:
Reporting Period Start Date:
Submitted by:
AOA# | Total Hours | Physician Name
 |  |  |  | For each physician, provide the physician's name, AOA number and the number of hours received during the reporting period.
 |  |  |  | Send the completed form to
 |  |  |  | The Office of Professional
 |  |  |  | and Continuing
 |  |  |  | Education
 |  |  |  | Total hours this report:
 |  |  |  |  | 0
 | 0
Spreadsheet: 267096d1379949197-selecting-a-column-number-from-a-range-price-calculator
Sheet: Sheet1

Discount |  | 0.15
Exchange Rate |  | 1.1
 |  | Quantity Range |  |  |  |  |  |  |  |  |  |  | 0.3 | 0.25 | 0.2
Qty | Part Number | 0-24 | 25-49 | 50-99 | 100-199 | 200-499 | 500-999 | 1000-1499 |  | Range Result | Net Cost |  | 0.7 | 0.75 | 0.8
60 |  | 582.3 | 524.1 | 482.2 | 448.4 | 430.5 | 413.2 | 290.1
Spreadsheet: 1b18705e-5312-4312-a93e-31bf61a5eef3
Sheet: Page 1

Permit No.: |  |  | WQ0002121 |  |  | Facility Name: |  | Sandling Beach - Falls Lake SRA |  |  |  |  |  | County: | Wake |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | LLS |  | Field Name: |  | UPR |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 5 |  | Area (acres): |  | 5 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 20.8 |  | Annual Rate (in): |  | 20.8 |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 100486d1298851748-sumifs-alternative-for-excel-2003-sumproduct-not-working-newkvs
Sheet: RankSRFM

W/C | 2011-02-20 00:00:00 | Rank |  | Manager | TTL
 |  | 1 | 9 | [NAME] | 21.10742496050553
 |  | 2 | 11 | [NAME] | 23.93121693121693
 |  | 3 | 5 | [NAME] | 25.78571428571428
 |  | 4 | 8 | [NAME] | 25.96491228070175
 |  | 5 | 10 | [NAME] | 26
 |  | 6 | 1 | [NAME] | 26.66949152542373
 |  | 7 | 6 | [NAME] | 26.89102564102564
 |  | 8 | 7 | [NAME] | 27.25067385444744
 |  | 9 | 2 | [NAME] | 29.6636690647482
 |  | 10 | 3 | [NAME] | 31.84027777777778
 |  | 11 | 12 | [NAME] | 42.24861878453039
 |  | 12 | 4 | Darren Green | 46.8140243902439
 |  | 13 | #N/A | #N/A | #N/A
 |  | 14 | #N/A | #N/A | #N/A
 |  | 15 | #N/A | #N/A | #N/A
 |  | 16 | #N/A | #N/A | #N/A
 |  | 17 | #N/A | #N/A | #N/A
Spreadsheet: 268402d1380623141-sumproduct-not-working-teachers-attendance-ca-march-2014-
Sheet: Daily Classes

 |  | Teachers' Attendance - CA (March 2014)
 |  | Report Day:
 |  | Date | Course | Sub | Sec | Type | Teacher Name | Standard Start | Standard End | Room No. | Actual Start | Actual End | Standard Duration | Actual Duration | Class Started | Class Ended | Comments
 |  | 2013-09-17 00:00:00 | CA | A1-FE | 2 |  | Mr. [NAME] |  |  |  | 07:00:00 | 09:00:00
 |  | 2013-09-18 00:00:00 | CA | A1-FE | 2 |  | Mr. [NAME] |  |  |  | 07:15:00 | 09:00:00
 |  | 2013-09-18 00:00:00 | CA | A1-FE | 3 |  | Mr. [NAME] |  |  |  | 10:00:00 | 11:30:00
 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 00917f26-d4cd-4e2d-be44-1d3243e691b8
Sheet: Sheet1

PERFORMANCE CONTRACT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  |  |  |  | PC # (B/O Use Only)
WHITMAN COLLEGE BUSINESS OFFICE
(Not to be used when required to compensate a person as an employee through payroll.)
This agreement is entered into this |  |  |  |  | day of
College, hereinafter called the College, and |  |  |  |  |  |  |  |  | , hereinafter called the
Contractor.
Whereas the College has need for the professional services of an individual with the particular training,
ability, knowledge, and experience possessed by the [NAME], now therefore, in consideration of the
sum of $ |  |  | to be paid to the Contractor by the College, the Contractor agrees to perform the
following specific engagement:
In performing the above engagement it is understood and agreed that:
1) | The Contractor is engaged as an independent contractor and will be responsible for any federal or
 | state taxes applicable to this payment.
2) | The Contractor will not be eligible for any federal Social Security, and may not be eligible for
 | industrial accident or unemployment insurance benefits from this contract, except as a self-
 | employed individual.
3) | If this payment is to be charged against federal funds, the Contractor certifies that he or she is not
 | currently employed by the federal government and the amount charged does not exceed the
 | normal charge for the type of service performed.
4) | The College will report the total amount of all payments applicable, including any expenses, in
 | accordance with Federal Internal Revenue Service rules.
5) | The College will not assume any liability for damage or loss of property belonging to Contractor.
The contract and any amendments to this contract will not be effective until approved by the Department
Administrator.
CONTRACTOR:
Signed |  |  |  |  |  |  | TIN or Social Security Number (required)
(Print or Type) |  |  |  |  |  |  | For tax purposes, please complete the following:
 |  |  |  |  |  |  | I am a citizen or permanent resident of the U. S.
Street Address |  |  |  |  |  |  | ________ | Yes | ________ No
City, State, Zip |  |  |  |  |  |  | If not, | please attach a copy of your current visa.
COLLEGE:
Department Administrator |  |  |  |  |  |  | Date
To effect payment, a copy of this form, when approved, must be sent to the Business Office with a Vendor Payment
Authorization form. |  |  |  |  |  |  |  |  | 2006-10-01 00:00:00
Spreadsheet: 154507d1336467937-sumproduct-countif-being-very-slow-and-crashing-exceltip
Sheet: Sheet1

Customer | Type | Job Number |  | CONCATENATE |  | Quantity of Unique Job
[NAME] | Work | 13
[NAME] | Service | 1
Fred | Landmines | 1
[NAME] | Work | 7
0 | 0 | 0
[NAME] | Guns | 9
Fred | Test | 89
Fred | Test | 89
Spreadsheet: 677632d1589448759-trying-to-use-autofill-with-conditional-formatting-with-no-luck-example
Sheet: Sheet1

Correct Conditional Formatted in B3 |  |  | After dragging D3 to remaining cells for autofill
Current Share Price | Share Price Target |  | Current Share Price | Share Price Target
106.335 | 50.2 |  | 106.335 | 50.2
50.99 | 107 |  | 50.99 | 107
263.14 | 75 |  | 263.14 | 75
25.8 | 258 |  | 25.8 | 50
43.525 | 25.2 |  | 43.525 | 25.2
214.945 | 42 |  | 214.945 | 42
41.96 | 172 |  | 41.96 | 105
76.195 | 10.6 |  | 76.195 | 10.6
119.13 | 23.6 |  | 119.13 | 23.6
Spreadsheet: 755351d1636804491-averaging-only-some-data-in-a-row-of-cells-golf-group-spreadsheet
Sheet: ABCD Formula Sheet

Name | Score 1 | Score 2 | Score 3 | Average Score | Player Ranking |  |  | 0 | 79 | A
Fred | 81 | 85 | 81 |  |  |  |  | 80 | 89 | B
[NAME] | 77 | 78 | 80 |  |  |  |  | 90 | 99 | C
[NAME] | 91 | 99 | 95 |  |  |  |  | 100 | 150 | D
[NAME] | 110 | 102 | 107
Doug | 68 | 72 | 71
[NAME] | 95 | 90 | 88
[NAME] | 75 | 88 | 79
Name | Score 1 | Score 2 | Score 3 | Average Score | Player Ranking |  |  | 0 | 78 | A
Fred | 81 | 85 | 81 |  |  |  |  | 79 | 85 | B
[NAME] | 78 | 78 | 80 |  |  |  |  | 86 | 92 | C
[NAME] | 91 | 99 | 95 |  |  |  |  | 93 | 150 | D
[NAME] | 110 | 102 | 107
Doug | 68 | 72 | 71
[NAME] | 98 | 93 | 88
[NAME] | 75 | 88 | 79
Spreadsheet: 274807d1383227432-merge-multiple-cells-into-one-based-on-criteria-eksempel
Sheet: Ark1

Shipping number | Reference | What I Would linke
1110006198 | aaa | aaa, bbb, qqq
1110006198 | bbb
1110006234 | [NAME] | [NAME], ddd, eee
1110006234 | ddd
1110006234 | eee
1110006218 | [NAME] | fff, ggg, hhh, iii, jjj, kkk, lll, mmm
1110006218 | ggg
1110006218 | hhh
1110006218 | iii
1110006218 | jjj
1110006218 | kkk
1110006218 | lll
1110006218 | mmm
abc | nnn | nnn
65r5 | ooo | ooo
123 | ppp | ppp
1110006198 | qqq
Spreadsheet: 100137d1298566939-plotting-series-names-as-numerical-values-in-a-scatter-graph-scatter-graph-problem
Sheet: Sheet1

Names | Test Score | Time spent studying (hours)
[NAME] | 5 | 0 |  |  | So, what I want is the series to be named as in graph 2, but with test score plotted against time spent studying with each series named after a student. Instead, this happens. Any pointers?
[NAME] | 3 | 1
Derek | 10 | 3
[NAME] | 13 | 4
[NAME] | 1 | 2
Elvis | 15 | 0
Hank | 4 | 5
Ferret | 7 | 2
Spreadsheet: 04608b3a-ff08-45d7-8c13-8b5212ea2ef7
Sheet: Weekly Lunch Planner

Weekly Menu Production Record
School/Site: |  |  |  |  |  |  |  | Week of_____________________________ 20______
Grade Group:  □K-5 □ 6-8 □ 9-12
Components | Monday | Tuesday | Wednesday | Thursday | Friday | Totals | √ | [NAME] | Grades 6-8 | Grades 7-12
Meat/Meat Alternate min. 1 oz./day (K-8) 2 oz. (9-12) |  |  |  |  |  |  |  | 8-10 oz. [NAME] | 9-10 oz. [NAME] | 10-12 oz. [NAME]
Grains |  |  |  |  |  |  |  | 1/2 whole-grain rich | 1/2 whole-grain rich | 1/2 whole-grain rich
min. 1 oz./day (K-8) 2 oz. (9-12) |  |  |  |  |  |  |  | 8-9 whole grain eq./week | 8-10 whole grain eq./week | 10-12 whole grain eq./week
Fruits min. 1/2 cup per day; 2 1/2 c per week (K-8) min. 1 cup/day; 5 cups/week (7-12) |  |  |  |  |  |  |  | no more than 1/2 fruit offering can be full strength juice | no more than 1/2 fruit offering can be full strength juice | no more than 1/2 fruit offering can be full strength juice
 |  |  |  |  |  |  |  | 1/4 cup dried = 1/2 cup | 1/4 cup dried = 1/2 cup | 1/4 cup dried = 1/2 cup
Vegetables min. 3/4 cup per day (K-8) min. 1 cup/day (7-12) |  |  |  |  |  |  |  | 1/2 c dark green/week 1 c dk leafy greens=1/2 c | 1/2 c dark green/week 1 c dk leafy greens=1/2 c | 1/2 c dark green/week 1 c dk leafy greens=1/2 c
 |  |  |  |  |  |  |  | [NAME] 3/4 c red-orange/week | [NAME] 3/4 c red-orange/week | [NAME] 1 1/4 c red-orange/week
 |  |  |  |  |  |  |  | 1/2 c legumes/week | 1/2 c legumes/week | 1/2 c legumes/week
 |  |  |  |  |  |  |  | 1/2 c starchy/week | 1/2 c starchy/week | 1/2 c starchy/week
 |  |  |  |  |  |  |  | 1/2 c other/week | 1/2 c other/week | 3/4 c other/week
 |  |  |  |  |  |  |  | 1 c additional vegetables | 1 c additional vegetables | 1 1/2 c additional vegetables
Fat Free (Flavored) Milk |  |  |  |  |  |  |  | 8 fl. Oz/day | 8 fl. Oz/day | 8 fl. Oz/day
Fat Free  (Unflavored) Milk |  |  |  |  |  |  |  | Variety | Variety | Variety
1% (Unflavored) Milk
Other Milk: ____________
Other
Potable Water |  |  |  |  |  |  |  | Available every day | Available every day | Available every day
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet2

Number | Box Number
241 | 86
271 | 823
452 | 507
148 | 600
781 | 253
582 | 816
336 | 212
259 | 915
760 | 271
770 | 0
591 | 289
446 | 52
921 | 940
365 | 783
826 | 114
417 | 823
269 | 352
884 | 831
575 | 894
144 | 581
496 | 269
733 | 76
933 | 190
442 | 244
428 | 491
695 | 622
741 | 872
922 | 363
109 | 784
Spreadsheet: 875316d1721908607-array-interval-between-repeating-integers-in-a-sequence-counting
Sheet: Logistics

 |  | 1 | 2 | 3 | 4
 | 0 | 1 | 0 | 0 | 0
 |  | 0 | 0 | 2 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 5 | 0 | 0
 |  | 0 | 0 | 0 | 6
 |  | 0 | 0 | 0 | 0
 |  | 2 | 0 | 0 | 0
 |  | 0 | 0 | 3 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 6 | 0 | 0
 |  | 0 | 0 | 0 | 1
 |  | 0 | 0 | 0 | 0
 |  | 3 | 0 | 0 | 0
 |  | 0 | 0 | 4 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 1 | 0 | 0
 |  | 0 | 0 | 0 | 2
 |  | 0 | 0 | 0 | 0
 |  | 4 | 0 | 0 | 0
 |  | 0 | 0 | 5 | 0
 |  | 0 | 0 | 0 | 0
Spreadsheet: 862725d1710366790-need-help-nesting-index-and-xmatch-functions-final-project-part-ii-data-file
Sheet: MileageTable

Boyd Logistics Mileage Table
Cities | Chicago | Fargo | Kansas City | Milwaukee | Minneapolis | Omaha | St. Louis
Chicago | 0 | 642 | 510 | 92 | 409 | 466 | 297
Fargo | 642 | 0 | 602 | 571 | 235 | 420 | 794
Kansas City | 510 | 602 | 0 | 567 | 437 | 185 | 248
Milwaukee | 92 | 571 | 567 | 0 | 337 | 507 | 373
Minneapolis | 409 | 235 | 437 | 337 | 0 | 377 | 560
Omaha | 466 | 420 | 185 | 507 | 377 | 0 | 432
St. Louis | 297 | 794 | 248 | 372 | 560 | 432 | 0
Spreadsheet: 258410dc-f7dd-4301-ab6d-68d63e96901b
Sheet: Advising

 | Group | Advisor | [NAME] | Total Advised | Pending Graduation | Attended Group and Individual Meeting | New to COE | [NAME] | Transferring | Not Returning | Not Advised | Semester Total | Early Alerts | Registered for next sem | EPP   2.5 Rquired | EPP 2.75 Required | Total Graduates | GPA 2.5 Required | GPA 2.75 Required
Fall 2010 | 194 | - | 55 |  | 37 | - | - | - | - | - | - | 480 |  | - | 173 | 143 | 37 | 37 | 35
Spring 2011 | 172 | 123 | 53 |  | 47 | - | - | 9 | 10 | 6 | 17 |  |  | - | 173 | 147 | 46 | 46 | 43
Fall 2011 | 197 | 115 | 50 |  | 53 | - | - | 13 | 6 | 4 | 9 |  |  | - | 170 | 152 | 51 | 51 | 47
Spring 2012 | 134 | - | 51 |  | 47 | - | - | - | - | - | - | 405 |  | - | 162 | 143 | 47 | 47 | 43
Fall 2012 | 153 | 141 | 57 |  | 38 | - | - | 2 | 1 | 2 | 15 |  |  | - | 142 | 128 | 38 | 38 | 38
Spring 2013 | 123 | 98 | 35 |  | 62 | - | - | 7 | 6 | 11 | 9 |  | 16 |  | 143 | 132 | 61 | 61 | 58
Fall 2013 | 125 | 127 | 64 |  | 31 | 28 | 35 | 5 | 1 | 3 | 19 | 338 | 14 | 292 | 157 already admited | 118 already admitted based on overall/ content GPA
*Reports used for adivisng are pulled from COGNOS when advising begins (they may not match [NAME] numbers due to students changing majors throughout the semester)
*Fall 2010 First full semester with staff advisor data tracking processes were still in planning stage
*Spring 2012 data incomplete due to staff advisor being on leave
Spreadsheet: 739268d1625597152-formula-to-pull-only-the-differences-between-sheets-occ-geo-template-sample-1-1-
Sheet: (B) ExistingOCC

Employee Number | First Name | Last Name | Location | Position | Term Date | OCC
500079 | ABEL | HERNANDEZ | [NAME] | 11002 - AK C/P Production - MP1770 - FACTORY MANAGER - CASE | 44295.9993055556 | 51-1011
500695 | BENJAMIN B | MERCADO | Terminated - 99999 - Terminated | Terminated | 40252.9993055556 | 45-1011
500079 | NILO | OHMER | [NAME] - AK Shore Dock | 20075 - AK Shore Dock - MP0500 - DOCK WORKER - AK NO R/B |  | 53-7199
500859 | DAVE N | [NAME] | [NAME] - AK Shore Process Maint. (Factory) | 10001 - AK Shore Process Maint (Factory) - SS1800 - MAINTENANCE MECHANIC - AK |  | 16-1098
501058 | [NAME] | GRAY | [NAME] - AK Shore Dock | 20075 - AK Shore Dock - MP0500 - DOCK WORKER - AK NO R/B |  | 51-4041
501287 | [NAME] | PELKEY | [NAME] - AK Shore Dock | 20075 - AK Shore Dock - MP0500 - DOCK WORKER - AK NO R/B |  | 51-3022
501461 | WAYNE | JONES | [NAME] - AK Shore Environmental | 20065 - AK Shore Environmental - SE0100 - ENVIRONMENTAL COORDINATOR |  | 53-5021
501532 | TAI Y | CHO | [NAME] - AK Shore Dock | 20075 - AK Shore Dock - MP0500 - DOCK WORKER - AK NO R/B |  | 11-1021
501531 | [NAME] | CHO | 30000 - AK Shore Salaries - Plant - OL2810 - PLANT MANAGER - CANNERY |  |  | 11-1021
Spreadsheet: 798672d1664627390-formula-to-count-cells-sample
Sheet: OCT 2022

S.NO | NAME OF MR | DESIG | Emp Status | DOJ | DOL | REPORTING TO | HQ | STATE | DIV | DAY | REASON | 12pm | 2pm | 5pm | 6 pm | TOT | Work Day | DAY | REASON | 12pm | 2pm | 5pm | 6 pm | TOT | Work Day | LEAVE
1 | RAMU |  |  |  |  |  |  |  |  | 1 | LEAVE |  |  |  |  |  | 1 | 2 | LEAVE | 4 |  |  |  |  | 1 | 2
2 | SOMU |  |  |  |  |  |  |  |  | 1 |  | 2 | 3 |  |  |  | 1 | 2 | LEAVE |  |  |  |  |  | 1 | 1
3 | KANNAN |  |  |  |  |  |  |  |  | 1 | LEAVE |  |  |  |  |  | 1 | 2 | LEAVE | 2 |  | 2 |  |  | 1 | 2
4 | SAMPATH |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 1 |  |  | 1 | 2 |  | 2 |  | 1 |  |  | 1
5 | DINES |  |  |  |  |  |  |  |  | 1 |  | 2 |  | 1 |  |  | 1 | 2 | LEAVE |  |  |  |  |  | 1 | 1
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: P-9

DENVER - P-9 RTOU ( August 14-16 )
Zone | Trainee | Trainee GPID/Hire Date | RTO Trainer | Position | [NAME] | Room Nights
[NAME] | Brett Saunders | 2018-08-12 00:00:00 | [NAME] | RSA |  | Mon, [NAME], Wed
 | [NAME] | GPID # 80136101-8/5/2018 | [NAME] | RSA |  | Local
 | [NAME] | 2018-08-05 00:00:00 | [NAME] | RSA |  | Local
 | [NAME] | 2018-08-05 00:00:00 | [NAME] | RSA |  | Local
 | [NAME] | GPID # 80129968- 8/12/2018 | [NAME] | RSA |  | Local
 | [NAME] | 2018-08-05 00:00:00 |  | RSA |  | Mon, [NAME], Wed
 | [NAME]
 | [NAME] |  |  | RSA |  | Local
Colorado Springs
[NAME] | Trevor McBeth | 80135071/ 08/12/2018 |  | RSA |  | [NAME] Wed
Albuquerque
 | [NAME] | 80135658 | [NAME] | RSA | L | M, T, W
[NAME] | [NAME] | Pending | [NAME] | RSA | XL | M, T, W
[NAME] | [NAME] | Pending | [NAME] | RSA | XL | M, T, W,th
Spreadsheet: 547566d1510622490-how-to-merge-tabs-and-make-the-columns-inside-each-tab-alternate-with-each-other-3tabs_jm
Sheet: result

Tab1Col1 | [NAME] | Tab3Col1 | Tab1Col2 | [NAME] | Tab3Col2 | Tab1Col3 | Tab2Col3 | Tab3Col3
1 | 5 | 6 | 2 | 12 | 56 | 4 | 3 | 14
2 | 6 | 7 | 3 | 13 | 57 | 5 | 4 | 15
3 | 7 | 8 | 4 | 14 | 58 | 6 | 5 | 16
4 | 8 | 9 | 5 | 15 | 59 | 7 | 6 | 17
5 | 9 | 10 | 6 | 16 | 60 | 8 | 7 | 18
6 | 10 | 11 | 7 | 17 | 61 | 9 | 8 | 19
7 | 11 | 12 | 8 | 18 | 62 | 10 | 9 | 20
8 | 12 | 13 | 9 | 19 | 63 | 11 | 10 | 21
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