tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7865779a-f4e0-4a0b-8c5d-3071d6973419
Sheet: Zone 21-24

Permit No.: |  |  | WQ0002284 |  |  | Facility Name: |  | [NAME] |  |  |  |  |  | County: | Dare |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | A4 |  | Field Name: |  | A5A |  | Field Name: |  | A5B |  | Field Name: |  | A5C
 |  |  |  |  |  | Area (acres): |  | 0.74 |  | Area (acres): |  | 0 |  | Area (acres): |  | 0.21 |  | Area (acres): |  | 0.28
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  | 0.3
 |  |  |  |  |  | Annual Rate (in): |  | 161.2 |  | Annual Rate (in): |  | 161.2 |  | Annual Rate (in): |  | 161.2 |  | Annual Rate (in): |  | 161.2
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: 821318d1678619036-matching-data-from-irregular-dataset-s666-pq-matching-data-from-irregular-dataset
Sheet: Sheet1

Description | Family | Qty | Sell
BRAQUE- ANTIQUE BRONZE BASE WITH DOVE GREY SILK SHADE 240V | Braque | 6 | 28
BRAQUE- ANTIQUE BRONZE BASE WITH SLATE GREY SILK SHADE 240V | Braque | 12 | 47
ANVERS SMALL SURFACE MOUNTED LIGHT - SATIN BRASS | Anvers | 1 | 5
ANVERS MEDIUM SURFACE MOUNTED LIGHT - BRONZE | Anvers | 1 | 6
PLUTO - BLACK MARQUINA 240V - EOL | Pluto | 16 | 18
PLUTO - RED LAGUNA 240V - EOL | Pluto | 5 | 25
PLUTO - WHITE CARRARA 240V - EOL | Pluto | 11 | 20
Spreadsheet: stacey_white__38967__Russell's Party List
Sheet: Sheet1

Jill & Pete Bell | [NAME]
Robin & Daryn Ebrecht | [NAME]
Lisa & Randall ? | [NAME]
Star ? & [NAME] | [NAME]
Amber & Stewart Geldersma | Brittney
Amy & Scott Birdwell | Veronica
Mike Wilson & Guest | [NAME]
[NAME] ?
Jackie & Chad Wigman
Mildred & [NAME]
Cheryl & Don Sweet
Melissa & [NAME]
Margaret & [NAME]
Charla & Bobby Jones
[NAME]
Karyn & Lamar White
Robin & Justin Harkey & Lacy
[NAME]
Shirley & Dee Harkey
Terese & Bryan Klesel Clayton & Cameron
Kelly & Kevin Kampe
Deanna & Jeff Harris
Angela & Brad McDonald
Christina & [NAME]
Kim & Brett Sachtleben
Lisa & Jeff Lucia
Rebecca & [NAME]
Chris & Jason Albrecht
Kathy Schueler &
Cassi & [NAME]
[NAME]
[NAME]
Kelly & Johnny Blackwell
Kimberly & Tony Roberts
Spreadsheet: 180834d1347804567-excel-weekly-planner-countif-by-half-hours
Sheet: Sheet1

Day | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00
2012-09-16 00:00:00 | Sleep |  |  |  | Work | Work | Work | Work | Work | Work | Work | Work | Work |  |  | ` | Homework | Homework | Homework | Homework | Homework
2012-09-17 00:00:00 | Sleep |  |  |  | Work | Work | Work | Work | Work | Work | Work | Work | Work
2012-09-18 00:00:00 | Sleep |  |  |  | Work | Work | Work | Work | Work | Work | Work | Work | Work |  |  |  |  |  | Homework | Homework | Homework | Homework | Homework
2012-09-19 00:00:00 | Sleep | Sleep | Sleep |  | Work | Work | Work | Work | Work | Work | Work | Work | Work
2012-09-20 00:00:00 | Sleep |  |  |  | Work | Work | Work | Work | Work | Work | Work | Work | Work
2012-09-21 00:00:00 | Sleep |  |  |  | Work | Work | Work | Work | Work | Work | Work | Work | Work |  |  |  |  | Homework | Homework | Homework | Homework | Homework
2012-09-22 00:00:00 | Sleep |  |  |  | Work | Work | Work | Work | Work | Work | Work | Work | Work | Homework | Homework | Homework | Homework | Homework
Sleep | 9 | <<See this formula
Work | 63
Homework | 20
Spreadsheet: 813063d1673530727-extract-values-from-a-text-string-test-data
Sheet: Sheet1

 |  |  | [NAME]'s way |  | TMS way
PRODUCT | LENGTH | WIDTH | LENGTH | WIDTH | LENGTH | WIDTH |  | LENGTH | WIDTH
SOUNDPRODUCT TE 2400 X 1200 X 12.5 | 2400 | 1200 |  |  |  |  |  | 2400 | 1200
DURAPRODUCT TE 2400 X1200 X15 |  |  |  |  |  |  |  | 2400 | 1200
BES DURAPRODUCT T/E 2550 X 1200 X 15 1TL |  |  |  |  |  |  |  | 2550 | 1200
PRODUCTNAME TEN TE 2400 X 1200 X 12.5 |  |  |  |  |  |  |  | 2400 | 1200
PRODUCTNAME SE 2400 X 1200 X 12.5 |  |  |  |  |  |  |  | 2400 | 1200
PRODUCTNAME TE 2400 X 1200 X 12.5 |  |  |  |  |  |  |  | 2400 | 1200
PRODUCTNAME TE 2700 X 1200 X 12.5 | 2700 | 1200 |  |  |  |  |  | 2700 | 1200
PRODUCTNAME PRODUCX R TE 2400 X 1200 X 9.5 |  |  |  |  |  |  |  | 2400 | 1200
DURAPRODUCT TE 3000 X 1200 X 15 |  |  |  |  |  |  |  | 3000 | 1200
PRODUCTNAME TE 1800 X 900 X 12.5 | 1800 | 900 |  |  |  |  |  | 1800 | 900
PRODUCTNAME SE 1800 X 900 X 9.5 |  |  |  |  |  |  |  | 1800 | 900
BES PRODUCTNAME TEN T/E 2700 X 1200 X 12.5 |  |  |  |  |  |  |  | 2700 | 1200
DPR Prodex T/E 2700 X 1200 X 15 |  |  |  |  |  |  |  | 2700 | 1200
SOUNDPRODUCT F 3000 X 1200 X 15 TE 1TL |  |  |  |  |  |  |  | 3000 | 1200
PRODUCTNAME TE 2400 X 900 X 12.5 |  |  |  |  |  |  |  | 2400 | 900
BES DURAPRODUCT T/E 2750 X 1200 X 15 |  |  |  |  |  |  |  | 2750 | 1200
BES DURAPRODUCT T/E 1925 X 1200 X 15 |  |  |  |  |  |  |  | 1925 | 1200
BES SOUNDPRODUCT T/E 2730 X 1200 X 15 NEW |  |  |  |  |  |  |  | 2730 | 1200
BES SOUNDPRODUCT T/E 2760 X 1200 X 12.5 |  |  |  |  |  |  |  | 2760 | 1200
Spreadsheet: 02cbd2f0-1e2c-4793-85e9-afcb4acee1f5
Sheet: List

 |  |  |  |  | Yearly | Quarterly | Every 2 Months | Twice Yearly | Twice Monthly
1 | January | Twice a Month | April | 4 |  |  |  |  |  |  | 6:00 |  | AM
2 | February | Monthly | April | 16 |  |  |  |  |  |  | 6:30 |  | PM
3 | March | Every 2 Months | August | 8 |  |  |  |  |  |  | 7:00
4 | April | Quarterly | August | 20 |  |  |  |  |  |  | 7:30
5 | May | Every 6 Months | December | 12 |  |  |  |  |  |  | 8:00
6 | June |  | December | 24 |  |  |  |  |  |  | 8:30
7 | July |  | February | 2 |  |  |  |  |  |  | 9:00
8 | August |  | February | 14 |  |  |  |  |  |  | 9:30
9 | September |  | January | 1 |  |  |  |  |  |  | 10:00
10 | October |  | January | 13 |  |  |  |  |  |  | 10:30
11 | November |  | July | 7 |  |  |  |  |  |  | 11:00
12 | December |  | July | 19 |  |  |  |  |  |  | 11:30
13 | January |  | June | 6 |  |  |  |  |  |  | 12:00
14 | February |  | June | 18 |  |  |  |  |  |  | 12:30
15 | March |  | March | 3 |  |  |  |  |  |  | 1:00
16 | April |  | March | 15 |  |  |  |  |  |  | 1:30
17 | May |  | May | 5 |  |  |  |  |  |  | 2:00
18 | June |  | May | 17 |  |  |  |  |  |  | 2:30
19 | July |  | November | 11 |  |  |  |  |  |  | 3:00
20 | August |  | November | 23 |  |  |  |  |  |  | 3:30
21 | September |  | October | 10 |  |  |  |  |  |  | 4:00
22 | October |  | October | 22 |  |  |  |  |  |  | 4:30
23 | November |  | September | 9 |  |  |  |  |  |  | 5:00
24 | December |  | September | 21 |  |  |  |  |  |  | 5:30
 |  |  |  |  |  |  |  |  |  |  | 6:00
 |  |  |  |  |  |  |  |  |  |  | 6:30
Spreadsheet: 702747d1604509800-vlookup-multiple-criteria-return-unique-values-sample-1-
Sheet: sample

ID | Country | Product
1 | Morocco | A
2 | Germany | B
3 | Israel | D
4 | Morocco | F
5 | Algeria | A
6 | Italy | F
7 | Egypt | B
8 | Senegal | G
9 | Algeria | H
10 | Morocco | H
Spreadsheet: 677560d1589396468-vlookup-display-only-oldest-date-book1
Sheet: Sheet1

Batch | Serial nr | Serial nr | [NAME] date |  |  |  |  |  |  | Serial nr | [NAME] date
1 | 25635 | 12345 |  | 07-2019 |  |  |  |  |  | 25635 | 11-2019
2 |  | 89658 | #N/A | 12-2019 |  |  |  |  |  | 89658 | 12-2019
3 | 12345 |  | 07-2019 | #N/A |  |  |  |  |  | 12345 | 07-2019
Spreadsheet: 91256d1291038467-pivot-table-show-values-as-pivot-table_dummy
Sheet: Sheet1

Date | Sales | Shoe Sales
2011-01-01 00:00:00 | 283904 | 33000
2011-01-02 00:00:00 | 293904 | 34000
2011-01-03 00:00:00 | 303904 | 35000
2011-01-04 00:00:00 | 313904 | 36000
2011-01-05 00:00:00 | 323904 | 37000
2011-01-06 00:00:00 | 333904 | 38000
2011-01-07 00:00:00 | 343904 | 39000
2011-01-08 00:00:00 | 353904 | 40000
2011-01-09 00:00:00 | 363904 | 41000
Pivot table |  |  |  |  | Desired Pivot Table Results
 | Values |  |  |  |  | Values
Row Labels | Sum of Sales | Sum of Shoe Sales |  |  | Row Labels | Sum of Sales | Sum of Shoe Sales
2011-01-01 00:00:00 | 283904 | 33000 |  |  | 2011-01-01 00:00:00 | 283904 | 0.1162364743011722
2011-01-02 00:00:00 | 293904 | 34000 |  |  | 2011-01-02 00:00:00 | 293904 | 0.1156840328814851
2011-01-03 00:00:00 | 303904 | 35000 |  |  | 2011-01-03 00:00:00 | 303904 | 0.1151679477729809
2011-01-04 00:00:00 | 313904 | 36000 |  |  | 2011-01-04 00:00:00 | 313904 | 0.1146847443804475
2011-01-05 00:00:00 | 323904 | 37000 |  |  | 2011-01-05 00:00:00 | 323904 | 0.1142313771981822
2011-01-06 00:00:00 | 333904 | 38000 |  |  | 2011-01-06 00:00:00 | 333904 | 0.1138051655565672
2011-01-07 00:00:00 | 343904 | 39000 |  |  | 2011-01-07 00:00:00 | 343904 | 0.1134037405787662
2011-01-08 00:00:00 | 353904 | 40000 |  |  | 2011-01-08 00:00:00 | 353904 | 0.11302500113025
2011-01-09 00:00:00 | 363904 | 41000 |  |  | 2011-01-09 00:00:00 | 363904 | 0.112667077031305
Grand Total | 2915136 | 333000 |  |  | Grand Total | 2915136
Spreadsheet: 606b537b-a8a7-4f82-b094-1ad023f49a06
Sheet: Sheet1

2010-2011 ELC PTO School Spirit Walk-a-Thon
Student: |  | Teacher:                                                   AM/PM
To promote [NAME] and Exercising, my school's PTO is hosting a School Spirit Walk-a Thon.
Your sponsorship will help educate my friends and me on how to live a healthy lifestyle.  The PTO will use
the money we raise for educational assemblies, books and exercise equipment so I will grow up
STRONG & HEALTHY.     My GOAL is to raise |  | $
 | *** Please turn in sponsorship form and money by November 5th!
 | Checks may be made payable to ELC PTO.
 | Name | Sponsorship Amt | Collected
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
THANK YOU FOR YOUR SUPPORT
 | For Office Use Only | Raffle Tickets Earned
 | Total Amount Collected $_____________________________
 | Cash Total $____________  /Check Total $ _______________
Spreadsheet: 833409d1686939897-formula-to-calculate-difference-between-a-day-number-and-the-current-date-book01
Sheet: Sheet1

 | Day of the Month Number (not a date) |  | [NAME] to calculate TRUE only if Day Number is within 0 to 2 days from today's/current date
 | 5
 | 7
 | 8
 | 10
 | 11
 | 15
 | 15
 | 17
 | 20
 | 21
 | 22
 | 25
 | 29
 | Should look like this
 | 10 |  | False
 | 13
 | 15
 | 16 |  | True
 | 17 |  | True
 | 19 |  | False
Spreadsheet: 100330d1298688362-excel-2007-look-up-and-report-from-1-sheet-to-another-ukphoenix-book1
Sheet: Sheet2

Item 1 | 5512 | 24760 | 39859
Item 2 | 27094 | 7534 | 33522
Item 3 | 27037
Item 4
Item 5
Item 6
Item 7
Item 8
Item 9
Item 10
Totals
Spreadsheet: 157678d1337837515-sales-per-month-and-division-formula-test-1-
Sheet: Sheet1

 | Month | Sales | Division
 |  |  |  |  |  |  |  | North | South | East | West
 | April | 1856 | North |  |  |  | January
 | May | 1188 | South |  |  |  | February
 | June | 698 | North |  |  |  | March
 | July | 1005 | South |  |  |  | April
 | August | 694 | North |  |  |  | May
 | September | 221 | South |  |  |  | June
 | October | 1860 | North |  |  |  | July
 | November | 1374 | South |  |  |  | August
 | December | 1823 | North |  |  |  | September
 | January | 1039 | South |  |  |  | October
 | February | 205 | North |  |  |  | November
 | March | 234 | South |  |  |  | December
 | April | 1222 | North
 | May | 201 | South
 | June | 1568 | North
 | July | 226 | North
 | August | 601 | South
 | September | 348 | North
 | October | 511 | East
 | November | 762 | West
 | December | 1373 | East
 | January | 1222 | West
 | February | 971 | East
 | March | 1539 | West
 | April | 1347 | East
 | May | 30 | West
 | June | 969 | East
 | July | 1865 | West
 | August | 902 | East
 | September | 684 | West
 | October | 1966 | East
 | November | 1661 | West
 | December | 1909 | East
 | January | 1487 | West
 | February | 1310 | East
 | March | 299 | West
 | April | 535 | East
 | May | 659 | West
 | June | 113 | East
 | July | 829 | West
 | August | 575 | East
 | September | 709 | West
 | October | 155 | East
 | November | 1280 | West
 | December | 701 | East
 | January | 919 | West
 | February | 10 | East
Spreadsheet: 32364d1228481688-how-to-compare-lines-of-data-and-return-a-given-name-book2
Sheet: Sheet1

Supplier A | Supplier B | Supplier C |  | Lowest | Supplier
17820 | 18180 | 20640 |  | 17820
17820 | 24780 | 30600 |  | 17820
No Bid | 22500 | No Bid |  | 22500
No Bid | 23340 | No Bid |  | 23340
16980 | 23580 | 22680 |  | 16980
24610 | 24370 | 31690 |  | 24370
16140 | 22740 | 26400 |  | 16140
16140 | No Bid | 12072 |  | 12072
16140 | 24660 | 25320 |  | 16140
Spreadsheet: 470386d1468450616-filter-by-unique-values-by-latest-date-book1
Sheet: Sheet1

 | Claim | Date | Money
 | 1 | 2012-01-01 00:00:00
 | 1 | 2013-01-02 00:00:00
 | 1 | 2011-01-02 00:00:00
 | 2 | 2013-01-02 00:00:00
 | 2 | 2014-01-02 00:00:00
 | 2 | 2014-01-03 00:00:00
 | 3 | 2015-01-02 00:00:00
 | 3 | 2015-01-06 00:00:00
 | 3 | 2015-01-08 00:00:00
Spreadsheet: 6233cd66-a4a5-4e28-a51b-5ac21f5cedf7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
15ta. Copa Little Lads del Caribe
23 al 27 de Junio 2011
Santiago, Rep. [NAME].
Resultados de los Juego Serie Todo Contra Todos
[NAME]
JUEGO  1 |  |  | JUE. 23 JUN.. |  |  |  |  | JUEGO   2 |  |  | JUE. 23 JUN..
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  PUERTO RICO | 8 | 11 | 19 | 7 |  | 45 |  | (A)  ABASACA  2 | 2 | 9 | 2 | 10 |  | 23
(B)  ABASACA 1 | 10 | 11 | 4 | 18 |  | 43 |  | (B)  ABASACA 3 | 4 | 3 | 2 | 8 |  | 17
JUEGO  3 |  |  | JUE. 23 JUN.. |  |  |  |  | JUEGO  4 |  |  | JUE. 23 JUN..
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  LA VEGA | 8 | 7 | 11 | 6 |  | 32 |  | (A)  ABASACA  3 | 5 | 10 | 4 | 10 |  | 29
(B)  PUERTO RICO | 8 | 11 | 14 | 10 |  | 43 |  | (B)  ABASACA 1 | 13 | 2 | 12 | 12 |  | 39
JUEGO  5 |  |  | VIE. 24 JUN. |  |  |  |  | JUEGO  6 |  |  | VIE. 24 JUN.
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  ABASACA  2 | 7 | 10 | 7 | 10 |  | 34 |  | (A)  PUERTO RICO | 13 | 13 | 6 | 14 |  | 46
(B)  LA VEGA | 11 | 10 | 17 | 4 |  | 42 |  | (B)  ABASACA 3 | 3 | 2 | 8 | 10 |  | 23
JUEGO  7 |  |  | VIE. 24 JUN. |  |  |  |  | JUEGO  8 |  |  | VIE. 24 JUN.
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  ABASACA  1 | 9 | 19 | 10 | 10 |  | 48 |  | (A)  LA VEGA | 12 | 8 | 15 | 17 |  | 52
(B)  ABASACA 2 | 12 | 9 | 12 | 14 |  | 47 |  | (B)  ABASACA 3 | 1 | 8 | 12 | 8 |  | 29
JUEGO  9 |  |  | SAB. 25 JUN. |  |  |  |  | JUEGO  10 |  |  | SAB. 25 JUN.
E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT |  | E  Q  U  I  P  O  S | T 1 | T 2 | T 3 | T 4 | T E | TOT
(A)  ABASACA  1 | 7 | 14 | 12 | 22 | 14 | 69 |  | (A)  ABASACA  2 | 12 | 4 | 7 | 7 |  | 30
(B)  LA VEGA |  |  |  |  |  | 0 |  | (B)  PUERTO RICO | 12 | 17 | 9 | 10 |  | 48
Spreadsheet: phillip_m_love__30151__9906_OA
Sheet: CE_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  CENTRAL
 |  |  | Total |  | Reclasses |  | June |  | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7440 | -10774.09 |  | 22574.71
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -225039 | -486489.31 | 0 | 0 | 0 | -243244.66
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225039 | 486489.31 | 0 | 0 | 0 | 0
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48941 | 105810.44
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7440 | 16083.79 | -7440 | -16083.79 | -48941 | -105800.65
23 | Fuel: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 225039 | 486489.31 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 232176
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 8250
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 719578d1613729323-creating-a-top-5-list-with-conditionals-orderlist_top5-example
Sheet: Solved by pivot

Example 1 for top 5 |  |  | Example 2 for top 5 |  |  | Example 3 for top 10
 |  |  | Stereo | Basic
Transmission | Manual |  | Responsible | [NAME]
Warranty | Yes |  | Sold? | Yes |  | Sold? | No
Radetiketter | Summer av Price |  | Radetiketter | Summer av Price |  | Radetiketter | Summer av Mileage
170014 | 21650 |  | 170013 | 3120 |  | 170018 | 684962
170001 | 2900 |  | 170001 | 2900 |  | 170015 | 459234
170017 | 2100 |  | 170030 | 1950 |  | 170020 | 274161
170030 | 1950 |  | 170004 | 1950 |  | 170014 | 206972
170004 | 1950 |  |  |  |  | 170021 | 197346
170010 | 1550 |  |  |  |  | 170023 | 144526
 |  |  |  |  |  | 170003 | 101521
 |  |  |  |  |  | 170028 | 95276
 |  |  |  |  |  | 170012 | 85264
 |  |  |  |  |  | 170008 | 70633
 |  |  |  |  |  | 170016 | 64287
 |  |  |  |  |  | 170017 | 60200
 |  |  |  |  |  | 170009 | 55229
 |  |  |  |  |  | 170005 | 45292
 |  |  |  |  |  | 170002 | 37652
 |  |  |  |  |  | 170010 | 28340
 |  |  |  |  |  | 170025 | 19885
 |  |  |  |  |  | 170024 | 16769
 |  |  |  |  |  | 170026 | 13462
 |  |  |  |  |  | 170029 | 9514
Spreadsheet: 104430d1302037176-count-using-multiple-criteria-find-the-number-of-customers-help
Sheet: Sheet1

 |  |  |  | Parts | Service | Parts & Service | Total Customers
 |  |  | 2007 | 2306 | 1762 |  | 2722
CXPPLC | (All) |  | 2008 |  |  |  | 4183
SDHPRF | (All) |  | 2009 |  |  |  | 3926
MONTH(SDTRDT) | (All) |  | 2010 |  |  |  | 3656
SDGAC | (Multiple Items) |  | 2011
Sum of SDSVAL |  |  | YEAR(SDTRDT)
SDCUST | SDNAME | SDGAC2 | 2007 | Grand Total
1153 | THERMAL MECHANICAL, | Parts | 184.26 | 184.26
1181 | WEST COAST COMPRESSO | Parts | 2339 | 2339
1245 | A.I.M. | Parts | 140.19 | 140.19
 |  | Service | 310 | 310
1307 | ADVANCED INDUSTRIAL | Parts | 162.79 | 162.79
1322 | AEROJET | Parts | -216.14 | -216.14
1327 | AERVOE-PACIFIC CO., | CH | 2090.5 | 2090.5
1344 | AIR TECHNOLOGY WEST | Parts | 111.21 | 111.21
1362 | REGIONAL MEDICAL CEN | Parts | 372.42 | 372.42
 |  | Service | 1425.5 | 1425.5
1395 | ALL TECH MACHINE & E | Parts | 166.56 | 166.56
1396 | ALL WELD MACHINE & F | Parts | 2562.34 | 2562.34
 |  | Service | 2504.5 | 2504.5
1461 | APPLIED BIOSYSTEMS | Parts | 1484.81 | 1484.81
 |  | Service | 1295 | 1295
1463 | APPLIED BIOSYSTEMS | Parts | 463 | 463
1464 | APPLIED ENGINEERING | Parts | 117.82 | 117.82
1480 | ARMSTRONG TECHNOLOGY | Parts | 327.2 | 327.2
 |  | Service | 164.5 | 164.5
1481 | ARMSTRONG TECHNOLOGY | Parts | 60.64 | 60.64
1573 | BASIC VI TECHNOLOGY, | Parts | 69.22 | 69.22
 |  | Service | 871.5 | 871.5
 |  | CH | 3602.41 | 3602.41
1582 | BAY EQUIPMENT COMPAN | Parts | 225.67 | 225.67
1592 | BEAR MACHINING | Parts | 1504.97 | 1504.97
Spreadsheet: 187821d1350588416-multiple-look-up-testcase
Sheet: Data 2

Contracts | ID | Cust_Name | Key
127650~[NAME] | 100-1 | A
17960-bbCD-123 | 200-2 | B
1244360-ZZRO~8792x3 | 100-1 | A
1895436-LLGT~90422vT | 100-1 | A
123960-KbLM-12x3 | 300-3 | C
1244360-ZZRO~872x3 | 100-1 | A
196780-nuLM-2Yx3 | 300-3 | C
1560-Nys-123 | 405-9 | D
123960-KbLM-12x3 | 300-3 | C
1000-Sys-123 | 700-4 | E
Spreadsheet: 261ec12c-0467-4291-9076-f27043865dbf
Sheet: EPR 1X CQY

Reconciliations of GAAP to Non-GAAP Adjusted Financial Measures
(In millions, except EPS)
 |  | Cost of  Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
Second Quarter Ended March 31, 2014
GAAP measures |  | 31.4 | 220.7 | 72.09999999999991 | 25.6999999999999 | 0.1
% of revenue |  |  | 0.4303822152886115 | 0.1406006240249608
Acquisition-related charges: (b)
Contingent retention & earn-out |  | 0 | -3.7 | 3.7 | 2.5 | 0.01
Amortization of intangibles |  | -2.7 | -3.4 | 6.1 | 4.1 | 0.02
Business realignment |  | 0 | -16.5 | 16.5 | 11 | 0.05
Alabama note impairment |  | 0 | -1.3 | 1.3 | 0.9 | 0
Litigation accrual |  | 0 | -7.8 | 7.8 | 5.199999999999999 | 0.02
Total non-GAAP adjustments |  | -2.7 | -32.7 | 35.4 | 23.7 | 0.1
Adjusted measures |  | 28.7 | 188 | 107.4999999999999 | 49.3999999999999 | 0.2
% of revenue |  |  | 0.3666146645865835 | 0.2096333853354133
 | (a) Adjustments tax effected at 33%;  (b) Primarily DoubleDown
 |  | Cost of  Interactive | Operating Expenses | Operating Income | Net Earnings (a) | Diluted EPS
Second Quarter Ended March 31, 2013
GAAP measures |  | 26.1 | 212 | 129.3 | 78.20000000000002 | 0.29
% of revenue |  |  | 0.3533333333333333 | 0.2155
Acquisition-related charges: (b)
Contingent retention & earn-out |  | 0 | -21.9 | 21.9 | 14.6 | 0.06
Amortization of intangibles |  | -2.3 | -4.5 | 6.8 | 4.5 | 0.02
Proxy Fees |  | 0 | -3.9 | 3.9 | 2.6 | 0.01
Alabama note Impairment |  | 0 | -1.6 | 1.6 | 1.1 | 0
Certain discrete tax items (benefits) |  | 0 | 0 | 0 | -5.9 | -0.02
Total non-GAAP adjustments |  | -2.3 | -31.9 | 34.2 | 16.90000000000001 | 0.06999999999999999
Adjusted measures |  | 23.8 | 180.1 | 163.5 | 95.10000000000002 | 0.36
% of revenue |  |  | 0.3001666666666666 | 0.2725
 | (a) Adjustments tax effected at 34%;  (b) Primarily DoubleDown