tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 474474d1470764715-text-to-rows-within-a-list-oeldere2-474426d1470754458-text-to-rows-within-a-list-example-sheet
Sheet: Rooming List Report

Rooming List Report  (Last updated 09/08/2016 14:17:03)
Hotel: Holiday Inn
Booking Ref | Room ID |  | Booking Name |  |  |  | Names | Room Type |  | Hotel Ref | [NAME] | [NAME] | Arrival Flight No | Total Nights | Departure Date | Departure Flight Time | Departure Flight No | Passenger Notes
[NAME]
GUPK45156 | 1 |  | SIR172NHT/Michelle  Roberts/Scotland v Ireland 2017 - 2 Night Hotel and ticket package |  |  |  | M Walmsley Mr, [NAME] | [NAME] (2 People in 1 Bed) |  |  | 03/02/2017 |  |  | 2 | 05/02/2017 |  |  |  |  | M Walmsley Mr | [NAME]
GUPK45570 | 2 |  | SIR172NHT/[NAME]/Scotland v Ireland 2017 - 2 Night Hotel and ticket package |  |  |  | [NAME], [NAME] | [NAME] (2 People in 1 Bed) |  |  | 03/02/2017 |  |  | 2 | 05/02/2017 |  |  |  |  | [NAME] | [NAME]
[NAME]
GUPK45405 | 3 |  | SIR171NHT/Janet  Hickey/Scotland v Ireland 2017 - 1 Night Hotel and ticket package |  |  |  | [NAME], [NAME] | [NAME] (2 People in 1 Bed) |  |  | 04/02/2017 |  |  | 1 | 05/02/2017 |  |  |  |  | [NAME] | [NAME]
GUPK45652 | 4 |  | SIR171NHT/[NAME] v Ireland 2017 - 1 Night Hotel and ticket package |  |  |  | [NAME], [NAME] Mr | [NAME] (2 People in 1 Bed) |  |  | 04/02/2017 |  |  | 1 | 05/02/2017 |  |  |  |  | [NAME] | [NAME] Mr
 | Total Rooms |  |  |  |  |  | 4 |  |  |  |  | Total Nights | 6
Hotel Summary
 |  | 03/02/2017 |  | 04/02/2017
[NAME] (2 People in 1 Bed) |  | 2 |  | 4
Total |  | 2 |  | 4
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: CHCC DGB

DGB20 for Coffs Council
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | 20mm Roadbase | White Roadbase | Pit Fines | Dust | MB20 1602-1 | Laceys Clay Liner | ROSA | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 99 | 100 | 100 | 100 | 99 | 100 | 100 | 99.01 | 95 | 100 | 0 | 0.9899999999999949
13.2 | 86 | 86 | 100 | 100 | 87 | 100 | 100 | 87.13 | 78 | 92 | 0 | 11.88000000000001 | 6 | 18 | 0
9.5 | 77 | 68 | 100 | 100 | 78 | 100 | 100 | 78.22 | 63 | 83 | 0 | 8.909999999999997 | 7 | 17 | 0
6.7 | 67 | 54 | 100 | 100 | 69 | 100 | 100 | 69.31 | 50 | 70 |  |  | 10 | 21
4.75 | 57 | 42 | 100 | 96 | 61 | 100 | 100 | 61.39 | 44 | 64 | 0 | 16.83 | 13 | 25 | 0
2.36 | 30 | 29 | 100 | 60 | 41 | 100 | 100 | 41.59 | 35 | 55 | 0 | 19.8 | 7 | 19 | 0.7999999999999972
0.425 | 14 | 17 | 65 | 18 | 11 | 97 | 100 | 11.86 | 14 | 23 | -2.140000000000001 | 29.73 | 14 | 30 | 0 | A | 28.51647030536186 |  | 35-55
0.075 | 9 | 12 | 35 | 8 | 5 | 92 | 100 | 5.87 | 7 | 14 | -1.13 | 5.989999999999999 | 6 | 13 | -0.01000000000000068 | B | 49.49409780775717 | 0.4949409780775717 | 45-65
0.0135 | 6.1 | 6 | 17 | 0 | 1 | 73 | 40 | 1.72 | 3 | 7 | -1.28 | 4.15 | 3 | 8 | 0 | C | 29.3015332197615
PI | 0 | 7 | 0 |  | 0 | 46 |  | 3.762225969645868
Ratio | 0 | 0 | 0 | 0 | 99 | 1 | 0 | 100
Spreadsheet: 769972d1645741237-dropdown-list-from-multiple-sheets-example
Sheet: Summary

[NAME]
Quarterly Financials Summary File
Period
Updated per: | 31/12/2021 | Revenues | Gross Income | EBITDA | Cash & Cash Equivalents
 | Company  1
 | Company  2
 | Company  3
 | Company  4
 | Company  5
 | Company  6
 | Company  7
 | Company  8
 | Company  9
 | Company  10
 | Company  11
 | Company  12
Q1 2021
Q2 2021
Q3 2021
Q4 2021
FY 2021
Q1 2022
Q2 2022
Q3 2022
[NAME]
FY 2022
Q1 2023
Q2 2023
Q3 2023
Q4 2023
FY 2023
Spreadsheet: 221283d1363454627-if-value-found-in-column-then-adjacent-cell-in-values-row-example-visits
Sheet: EXAMPLE VISITS

CITY | SIGHTS | DATE |  | CITIES | FREQUENCY | VISIT ONE | VISIT TWO | VISIT THREE
DALLAS |  | 2013-01-08 00:00:00 |  | DALLAS
DENVER |  | 2013-01-10 00:00:00 |  | DENVER
HOUSTON |  | 2013-01-15 00:00:00 |  | HOUSTON
LOS ANGELES |  | 2013-01-17 00:00:00 |  | LOS ANGELES
DALLAS
LOS ANGELES
Spreadsheet: 850913d1701214598-sort-data-conditional-upon-its-status-forum-help-sheet-for-sorting
Sheet: Sheet1

 |  |  |  |  |  |  |  | Debts Not Paid Off and Sorted by Interest Rate in Descending Order
 | Debt | Balance | Payment | Interest Rate | Pay Off?
 |  |  |  |  |  |  |  |  | Balance | Payment | Interest Rate
 | Debt 1 | 100000 | 600 | 0.05 | False |  |  | Remaining Debt 1
 | Debt 2 | 25000 | 350 | 0.075 | False |  |  | Remaining Debt 2
 | Debt 3 | 10000 | 225 | 0.08 | True |  |  | Remaining Debt 3
 | Debt 4 | 5000 | 150 | 0.19 | True |  |  | Remaining Debt 4
 | Debt 5 | 2000 | 50 | 0.26 | False |  |  | Remaining Debt 5
 | *Checked box = TRUE and means will be paid off
Spreadsheet: 95323d1294933484-excel-2007-adding-2-sets-of-data-to-a-single-calendar-calendar-test
Sheet: Instal Input

Install Date | Temp Date | Company | Job # | Installer | Sq Ft | combined
2011-01-13 00:00:00 | 2011-01-06 00:00:00 | KRAFT | HYATT RESTAURANT | Ramiro | 173.06 | KRAFT-HYATT RESTAURANT {Ramiro} 173.06
2011-01-14 00:00:00 | 2011-01-07 00:00:00 | Stock | Classics Lot 18 | Ramiro | 130.25 | Stock-Classics Lot 18 {Ramiro} 130.25
2011-01-18 00:00:00 | 2011-01-11 00:00:00 | Stock | Sarita 136 | Ramiro | 130.51 | Stock-Sarita 136 {Ramiro} 130.51
2011-01-26 00:00:00 | 2011-01-19 00:00:00 | Stock | ALDEN WOODS 3-101 | Ramiro | 77.5 | Stock-ALDEN WOODS 3-101 {Ramiro} 77.5
2011-01-26 00:00:00 | 2011-01-19 00:00:00 | Stock | ALDEN WOODS 3-102 | Ramiro | 77.5 | Stock-ALDEN WOODS 3-102 {Ramiro} 77.5
2011-01-26 00:00:00 | 2011-01-19 00:00:00 | Stock | ALDEN WOODS 3-201 | Ramiro | 85.66999999999999 | Stock-ALDEN WOODS 3-201 {Ramiro} 85.67
2011-01-26 00:00:00 | 2011-01-19 00:00:00 | Stock | ALDEN WOODS 3-202 | Ramiro | 85.66999999999999 | Stock-ALDEN WOODS 3-202 {Ramiro} 85.67
2011-01-28 00:00:00 | 2011-01-21 00:00:00 | Stock | CALDECOTT 13 | 0 | 105.15 | Stock-CALDECOTT 13 {0} 105.15
2011-01-31 00:00:00 | 2011-01-24 00:00:00 | Stock | MARTINIQUE 1 | 0 | 0 | Stock-MARTINIQUE 1 {0} 0
2012-01-06 00:00:00 | 2011-12-30 00:00:00 | Stock | Lakoya 147 | RAMIRO | 137.3 | Stock-Lakoya 147 {RAMIRO} 137.3
Spreadsheet: 121731d1316361481-if-condition-too-complex-testif
Sheet: JuneTB

JuneAccount | Description | JuneOB | JuneActivity | JuneCB
1110 | Revenue | -12000000 | 5000 | -11995000
1110 | Revenue | -1600000 | 1000 | -1599000
1110 | Revenue | -23000000 | -25000000 | -48000000
1110 | Revenue | -8000000 | 1000000 | -7000000
1110 | Revenue | -4000000 | 5000 | -3995000
1110 | Revenue | -100000 | 0 | -100000
1110 | Revenue | -5000000 | -350000 | -5350000
Spreadsheet: 0a1c2c98-7aff-4cd2-8ec0-adf029728e59
Sheet: Sheet1

Table 6--Cottonseed oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | Million pounds
2011/12 | 165 | 755 | 10.34710675614 | 930.34710675614 |  | 571.6191067561399 | 258.728 | 830.34710675614 | 100
2012/131 | 100 | 800 | 19.9174 | 919.9174 |  | 599.2454 | 220.672 | 819.9174 | 100
2013/142 | 100 | 695 | 0.3 | 795.3 |  | 485.3 | 210 | 695.3 | 100
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2014-01-14 08:07:33.930000
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Sodium Sterate

Raw Material |  | Sodium Sterate
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 13
Total
Spreadsheet: 203944d1357303872-finding-duplicate-values-in-multiple-columns-trial-upload
Sheet: Sheet1

Region | Area | Store Type | Address | P/C | [NAME] | Product | Date
South | RA18 | C | Long Lane | AB1 2CD | C | R20 | C13 - 2012
South | RA18 | C | Long Lane | AB1 2CD | C | RB20 | C11-2012
South | RA18 | C | Long Lane | AB1 2CD | C | RR24 | C12 - 2012
South | RA18 | C | Long Lane | AB1 2CD | C | RR24 | C11-2012
South | RA18 | C | Long Lane | AB1 2CD | C | RR24 | C10-2012
South | RA18 | C | Long Lane | AB1 2CD | C | R40 | C12 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | CC125 | C13 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | PMR19 | C13 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | PM125 | C13 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | PMSKR19 | C13 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | PMSKR19 | C10-2012
South | RA18 | C | Short Lane | EF3 4GH | C | RG20 | C13 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | RB20 | C12 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | RR40 | C12 - 2012
South | RA18 | C | Short Lane | EF3 4GH | C | RR40 | C11-2012
South | RA18 | C | Over Road | [NAME] | C | PMCO | C13 - 2012
South | RA18 | C | Over Road | [NAME] | C | PMCO | C12 - 2012
South | RA18 | C | Over Road | [NAME] | C | PMCO | C11-2012
South | RA18 | C | Over Road | [NAME] | C | PMCO | C10-2012
South | RA18 | C | Over Road | [NAME] | C | PMB19 | C10-2012
South | RA18 | C | Under Road | NO7 8PQ | C | CC125 | C11-2012
South | RA18 | C | Under Road | NO7 8PQ | C | CC25 | C11-2012
Spreadsheet: 7c585658-f320-4121-8fec-038bac548498
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5765 | 40957 | Iain | Dawson | GBR | 36 | 00:12:42 | 00:03:01 | [NAME] | 00:02:18 | 00:23:33 | 1 | 01:10:26
5765 | 30685 | [NAME] | [NAME] | GBR | 37 | 00:13:44 | 00:03:25 | 00:29:44 | 00:02:35 | 00:21:32 | 2 | 01:11:00
5765 | 30797 | [NAME] | [NAME] | GBR | 35 | 00:15:43 | [NAME] | 00:32:06 | 00:02:34 | 00:22:57 | 3 | 01:16:54
Spreadsheet: 809441d1671093303-combining-if-and-vlookup-functions-scoring-sheet
Sheet: Scoring Standards

< 30 BMI |  |  | >= 30 BMI
Push Up # (2mins) | Score % |  | Push Up # (2mins) | Score %
30 | 1 |  | 13 | 1
29 | 0.96 |  | 12 | 0.95
28 | 0.92 |  | 11 | 0.9
27 | 0.88 |  | 10 | 0.85
26 | 0.84 |  | 9 | 0.8
25 | 0.8 |  | 8 | 0.75
24 | 0.76 |  | 7 | 0.7
23 | 0.72 |  | 6 | 0.65
22 | 0.68 |  | 5 | 0.6
21 | 0.64 |  | 4 | 0.5
20 | 0.6 |  | 3 | 0.4
19 | 0.56 |  | 2 | 0.3
18 | 0.52 |  | 1 | 0.2
17 | 0.48 |  | 0 | 0
16 | 0.44
15 | 0.4
14 | 0.36
13 | 0.32
12 | 0.28
11 | 0.24
10 | 0.2
9 | 0.18
8 | 0.16
7 | 0.14
6 | 0.12
5 | 0.1
4 | 0.08
3 | 0.06
2 | 0.04
1 | 0.02
0 | 0
Spreadsheet: 34848d1232204618-excel-macro-problem-solution-facturare
Sheet: SG

 |  |  |  |  |  | factura 1 | factura 2 | factura 3
descriere | spec | stas | material | cant | unit
bec 25 w | 150 | sr en 100:2000 | - | 0 | buc
bec 60 w | 150 | sr en 100:2000 | - | 2 | buc | 2
bec 100w | 150 | sr en 100:2000 | - | 3 | buc |  |  | 3
neon 15w | 150 | sr en 100:2000 | - | 0 | buc
neon 25w | 150 | sr en 100:2000 | - | 0 | buc
cablu | 150 | sr en 100:2000 | metalic, invelis pvc | 0 | m
priza | 150 | sr en 100:2000 | plastic | 3.2 | buc | 3.2
comutator | 150 | sr en 100:2000 | plastic | 6 | buc |  |  | 6
Spreadsheet: 21cfb8cc-0546-4513-affb-a75861d52a41
Sheet: Denials 2011

MULTNOMAH COUNTY LOAN DENIAL RATES BY INCOME-RACE GROUPINGS : 2011
FHA Loans for Home Purchase & Occupation
I.  Total Applications
Race/Ethnicity | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 1 | 4 | 8 | 1 | 14 | 28
Asian | 2 | 35 | 60 | 21 | 51 | 170
Black or African American | 1 | 25 | 23 | 8 | 19 | 76
Native Hawaiian or Pacific Islander | 0 | 4 | 8 | 2 | 13 | 27
White | 27 | 317 | 660 | 264 | 717 | 2015
Hispanic | 8 | 60 | 57 | 21 | 50 | 199
Overall Total | 33 | 431 | 856 | 339 | 884 | 2584
II.  Total Denials
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian | 1 | 0 | 2 | 0 | 2 | 5
Asian | 0 | 6 | 8 | 0 | 4 | 19
Black or African American | 1 | 6 | 5 | 0 | 2 | 14
Native Hawaiian or Pacific Islander | 0 | 1 | 0 | 1 | 2 | 4
White | 9 | 43 | 62 | 20 | 57 | 195
Hispanic | 2 | 11 | 6 | 2 | 8 | 29
Overall Total | 9 | 64 | 82 | 24 | 74 | 261
III. Denial Rates (II/I) * 100
 | 0-30% MFI | 31-50% MFI | 51-80% MFI | 81-95% MFI | >95% MFI | Total
American Indian
Asian
Black or African American
Native Hawaiian or Pacific Islander | 0
White
Hispanic
Overall Total
Source: HMDA (LAR)
Note: Data reported here is for Multnomah County. These are loans for the purpose of purchasing a home. The loans are for homes that are meant for a primary occupancy of the owner. These are all represented for conventional loans. For ethnic and racial breakout, these are loans originated by households where either the applicant or co-applicant are representative of that group.
Spreadsheet: 767011d1644237946-best-easiest-way-of-reordering-address-fields-to-populate-a-mandatory-city-field-address-reorder-workbook
Sheet: Data Source

Address 1 | Address 2 | Address 3 | Address 4 | Address 5
Flat 16 | Sapphire Court | Lord Street | Watford | Hertfordshire
Flat 125 | Nine Acre Court | 27 Taylorson Street | Salford | Greater Manchester
Flat 5 | Midsummer Court | 119 Hindes Road | Harrow
Flat 44 | [NAME] | 77 Manor Road | Bournemouth
18 Hertford Avenue | London
10 Bullfinch Way | Innsworth
8 Brewery Close | Stamfordham
467 Lytham Road | Blackpool
8 [NAME] | Rossendale
Yallingup | Pilgrims Way | Chew Stoke
Oaklea | [NAME] | Tittensor
Spreadsheet: 31bf4071-9dbf-45c5-b289-fe4145be4039
Sheet: Sheet1

Release: Harmonized Indices of Consumer Prices (HICP) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=251
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-03-15 12:17 AM CDT
 | Real-Time | Period
Name: | Start | End
Harmonized Indices of Consumer Prices (HICP) | 2012-06-15 00:00:00 | Current
Link:
http://epp.eurostat.ec.europa.eu/portal/page/portal/hicp/data/main_tables | 2012-06-15 00:00:00 | Current
Source:
Eurostat | 2012-06-15 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:
2012-06-15 00:00:00
2012-07-15 00:00:00
2012-08-16 00:00:00
2012-09-14 00:00:00
2012-10-16 00:00:00
2012-11-15 00:00:00
2012-12-14 00:00:00
2013-01-16 00:00:00
2013-02-28 00:00:00
2013-03-15 00:00:00
2013-04-16 00:00:00
2013-05-16 00:00:00
2013-06-14 00:00:00
2013-07-16 00:00:00
2013-08-16 00:00:00
2013-09-16 00:00:00
2013-10-16 00:00:00
2013-11-15 00:00:00
2013-12-20 00:00:00
2014-01-21 00:00:00
2014-02-24 00:00:00
Spreadsheet: 696883d1601023229-how-to-increment-a-columns-cell-reference-by-1-then-by-2-then-by-1-etc-1-then-2-pattern-to-cell-references
Sheet: Sheet1

1
6
9
14
7
8
3
10
5
2
1 |  | *+1 cell ref
6 |  |  |  | *+2 cell ref
9 |  | *+1 cell ref
14 |  |  |  | *+2 cell ref
7 |  | *+1 cell ref
8 |  |  |  | *+2 cell ref
3 |  | *+1 cell ref
10
5
2
9
Spreadsheet: 674344d1587765958-sum-total-past-due-invoices-from-a-list-of-clients-sum-total-past-due-invoices-from-a-list-of-clients
Sheet: Sheet1

 | The goal is to write a formula in column P that separately sums the total Past Due invoice amounts in column M for each individual client
 |  |  |  |  |  |  |  |  |  |  |  |  | Wrong |  | Wrong
Cust # | Name | Invoice # | Inv date | Due date | Order # | Inv amt | Paid | Cr/Adj | Balance | Age Balance as of Today | Days Past Due | Past Due | Client |  | Total
16625 | XYZ Corp | 81624 | 2020-02-10 00:00:00 | 2020-03-11 00:00:00 | 48752 | 600 | 0 | 55312.4 | -55312.4
 |  | 81668 | 2020-02-28 00:00:00 | 2020-03-29 00:00:00 | 48112 | 375849 | 0 | 0 | 375849
Customer total |  | Ph |  |  | Fax |  |  |  | 320536.6
16704 | ABC Corp | 81560 | 2020-01-20 00:00:00 | 2020-02-19 00:00:00 | 48516 | 12266.2 | 0 | 0 | 12266.2
 |  | 81599 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48711 | 0 | 0 | 1340 | -1340
 |  | 81600 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48713 | 0 | -1742.98 | 3317.76 | -1574.78
 |  | 81604 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48717 | 0 | 0 | 9097.02 | -9097.02
 |  | 81605 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48718 | 0 | 0 | 254.4 | -254.4
 |  | 81681 | 2020-03-04 00:00:00 | 2020-04-03 00:00:00 | 47924 | 576175.56 | 0 | 0 | 576175.56
 |  | 81739 | 2020-03-27 00:00:00 | 2020-04-26 00:00:00 | 48854 | 1950 | 0 | 0 | 1950
 |  | 81746 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 48846 | 1447.55 | 0 | 0 | 1447.55
Customer total |  | PH |  |  | Fax |  |  |  | 3305.56
14300 | DFG Corp | 81641 | 2020-02-19 00:00:00 | 2020-02-19 00:00:00 | 48647 | 4141.18 | 0 | 0 | 4141.18
 |  | 81720 | 2020-03-18 00:00:00 | 2020-03-18 00:00:00 | 48154 | 111438.26 | 0 | 0 | 111438.26
Customer total |  | PH |  |  | Fax |  |  |  | 115579.44
Spreadsheet: 261ec12c-0467-4291-9076-f27043865dbf
Sheet: EPR OpEx

Operating Expenses
 |  | Second Quarters |  |  |  | Six Months
Periods Ended March 31, | 2014 | 2013 | % Change |  |  | 2014 | 2013 | % Change
(In millions, unless otherwise noted)
Operating Expenses
Selling, general & administrative | 124.1 | 110.7 | 0.1210478771454383 |  |  | 242.1 | 210.9 | 0.1479374110953059
Research & development | 58.5 | 58.09999999999999 | 0.006884681583476862 |  |  | 118.8 | 112.5 | 0.0560000000000001
Depreciation & amortization | 16.6 | 19.7 | -0.1573604060913704 |  |  | 33.2 | 38.7 | -0.1421188630490956
Contingent acquisition-related costs | 3.7 | 21.9 | -0.8310502283105023 |  |  | 15 | 39.3 | -0.6183206106870228
Impairment and restructuring | 17.8 | 1.6 | * |  |  | 17.8 | 1.6 | *
Total operating expenses | 220.7 | 212 | 0.04103773584905669 |  |  | 426.9 | 403 | 0.05930521091811423
Adjusted Operating Expenses
Total | 188 | 180.1 | 0.04386451971127171 |  |  | 377.4 | 349.3 | 0.08044660750071578
Adjusted operating expenses is a non-GAAP financial measure.  Reconciliations between GAAP and non-GAAP measures are provided at the end of this release.
Spreadsheet: 078138d7-0cf9-4208-bef3-1f7dba36ad0a
Sheet: Sheet1

Penalty and Interest Calculation | 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
2013-01-01 00:00:00 | = | Tax Year Beginning from the Report (Use the XX/XX/XX Format for All Date Entries)
2013-12-31 00:00:00 | = | Tax Year End from the Report
0 | = | Current Tax Year's County Tax (Line 12)
0 | = | Current Tax Year's City Regular Fee (Line 22) |  |  |  |  |  |  |  |  | County Quarterly Pmts |  |  | City Quarterly Pmts
0 | = | Prior Tax Year's County Tax (Line 12) |  |  |  |  |  |  |  |  | Amount | Date |  | Amount | Date
0 | = | Prior Tax Year's City Regular Fee (Line 22) |  |  |  |  |  |  |  |  | 0 | carryforward |  | 0 | carryforward
N | = | Was an Extension Filed? (Y or N) - Skip to Line 14 if N |  |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 |  |  | 2013-04-15 00:00:00
 | = | Date County Extension Filed |  |  |  |  |  |  |  |  |  | 2013-06-15 00:00:00 |  |  | 2013-06-15 00:00:00
0 | = | County Amount Paid with Extension |  |  |  |  |  |  |  |  |  | 2013-09-15 00:00:00 |  |  | 2013-09-15 00:00:00
0 | = | City Amount Paid with Extension |  |  |  |  |  |  |  |  |  | 2013-12-15 00:00:00 |  |  | 2013-12-15 00:00:00
2013-08-06 00:00:00 | = | Date Combined Report Form Filed
 | = Entered fields. All other fields are calculated.
 |  |  | County Penalty and Interest Summary: |  |  |  | City Penalty and Interest Summary:
 |  |  | Late (after due date) Penalty |  | 0 |  | Late (after due date) Penalty |  | 0
 |  |  | Late (after ext. due date) Penalty |  | 0 |  | Late (after ext. due date) Penalty |  | 0
 |  |  | Underpayment Penalty |  | 0 |  | Underpayment Penalty |  | 0
 |  |  |  | Total Penalties - Multnomah | 0 |  |  | Total Penalties - Portland | 0
 |  |  | Underpayment Interest |  | 0 |  | Underpayment Interest |  | 0
 |  |  | Quarterly Interest |  | 0 |  | Quarterly Interest |  | 0
 |  |  |  | Total Interest - Multnomah | 0 |  |  | Total Interest - Portland | 0
 |  |  |  |  |  | Prepared by
Spreadsheet: 122159d1316634440-get-all-combinations-from-2-columns-sample
Sheet: Hoja1

AAA1 | BBB1
AAA2 | BBB2
AAA3 | BBB3
AAA4 | BBB4
 | BBB5
 | BBB6
 | BBB7
Result should be:
AAA1 | BBB1
AAA1 | BBB2
AAA1 | BBB3
AAA1 | BBB4
AAA1 | BBB5
AAA1 | BBB6
AAA1 | BBB7
AAA2 | BBB1
AAA2 | BBB2
AAA2 | BBB3
AAA2 | BBB4
AAA2 | BBB5
AAA2 | BBB6
AAA2 | BBB7
Spreadsheet: 58726d1258996017-excel-incorrectly-calculating-sumproduct-sumproduct
Sheet: Sheet1

Quarter | # Struckoffs | Auction Price | SF | $/SF | [NAME]
4Q 2008
1Q 2009 | 290 | 123678 | 2120 | 58.75 | 0.842
2Q 2009 | 257 | 134633 | 2266 | 60.75 | 0.865
3Q 2009 | 287 | 130987 | 2315 | 57.42 | 0.842
Total/Average
Spreadsheet: 113823d1309706258-pull-column-from-one-sheet-to-another-affiliated-new-order-book
Sheet: Napkin Isle

Order | Item # | UPC # | Name | Cost | % |  | # of Items | SRP
1 | 30315 | 0-3700-34884 | BOUNTY NAPKINS | 38.58 | 0.25 |  | 100
4 | 31060 | 0-37000-28316 | BOUNTY TOWEL BASIC PRINT - 8 RL | 8.99 | 0 |  | 8
0 | 30622 | 0-12587-57263 | [NAME] SANDWICH ZIPPER | 23.99 | 0.25 |  | 50
4 | 31051 | 0-37000-28839 | BOUNTY TOWEL WHITE |  | 0.25
1 |  | 30602 | SF Bag Sandwich
0 |  |  | Kotex Maxi
0 |  |  | Care Free To Go
0 |  |  | [NAME] / doux
0 |  |  | [NAME]
0 |  |  | Kleenex 250 2 PLY WHITE
0 |  |  | Diamond Daily 24 - 8 Forks, Spoons, Knives
0 |  |  | Chinet Classic White
0 |  |  | [NAME]
0 |  |  | Penley Round Toothpics
0 |  |  | [NAME]
0 |  |  | [NAME]
0 |  |  | [NAME] Zipper 10 [NAME]
0 |  |  | [NAME] Zipper 20 Bag
0 |  |  | Dart 20 Cups
0 |  |  | [NAME]
0 |  |  | Reynolds Freeze Paper
0 |  |  | [NAME]
0 |  |  | [NAME]
0 |  |  | Reynolds Wrap
0 |  |  | [NAME] Tall [NAME]
0 |  |  | Reynolds Wrap Heavy Duty
0 |  |  | Reynolds Wrap Super Strength
0 |  |  | [NAME] and [NAME]
0 |  |  | Wide Mouth 12 Bands with Dome Lights
0 |  |  | [NAME] 3 Way
0 |  |  | [NAME]
0 |  |  | Diamond Strike on Box Match
0 |  |  | Reynolds Cut Rite Wax Paper
Spreadsheet: 194709d1353303745-use-colour-for-specific-numbers-prime-number
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 55154d1255297279-excel-2007-class-awards-class
Sheet: class

irish class | english class | french class | science class | history class | maths class |  |  |  |  |  |  | irish class | english class | french class | science class | history class | maths class
 |  |  |  |  |  |  |  |  |  |  |  | j ryan 36 | a fitzgerald 49 | m delaney 63 | j ryan 77 | d stapleton 68 | n fogarty 52
 |  |  |  |  |  |  |  |  |  |  |  | o baker 47 | p byrne 86 | v kavanagh 70 | b walsh 91 | k treacy 82 | h phelan 74
 |  |  |  |  |  |  |  |  |  |  |  | t maher 77 | m molloy 64 | a daly 50 | m dowling 72 | [NAME] 47 | m treacy 62
 |  |  |  |  |  |  |  |  |  |  |  | a daly 86 | j daisy 69 | j sweeney 39 | l white 88 | d giles 72 | [NAME] 38
 |  |  |  |  |  |  |  |  |  |  |  | g browne 68 | g down 71 | a greene 44 | j dowling 45 | p smeaton 76 | w martins 76
 |  |  |  |  |  |  |  |  |  |  |  | p byrne 92 | m beehan 45 | t grill 90 | t grill 57 | w rice 73 | I dowling 98
 |  |  |  |  |  |  |  |  |  |  |  | k davy 73 | n staples 55 | d freeney 75 | d dea 42 | d cassidy 47 | f gerathy 40
Spreadsheet: 82324d1282321815-locking-cells-based-on-other-cell-value-sample-student-data-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Data validation lists
Student name | Student ID | Year | Gender | Allergy | Age | New/transfer/graduated | Current course selection | Previous course selection |  | Student type | Course options
1 | 2 |  |  |  |  | Transfer |  |  |  | New | 3RFT
 |  |  |  |  |  |  |  |  |  | Transfer | 4DER
 |  |  |  |  |  |  |  |  |  | Graduated | 3GET