tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ce2b856c-8d0f-40ce-b82a-97d203148d3a
Sheet: Sheet1

1024 [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
(Érvényes: 2011. december 11-től)
Km | Km | Km | Km | [NAME]. | 2 | 4 | 6
 |  |  |  |  | 45 | O | V
0 | 0 | .. | .. | Hollókő, aut. vt. | 14:00:00 | 16:00:00 | 16:00:00
2.3 | 2.3 | .. | .. | Hollókői elág. | 14:02:00 | 16:02:00 | 16:02:00
4.9 | 4.9 | .. | .. | Felsőtold, faluház | 14:03:00 | 16:03:00 | 16:03:00
7 | 7 | .. | .. | Alsótold, vegyesbolt | 14:07:00 | 16:07:00 | 16:07:00
9.6 | 9.6 | .. | .. | Nagymezői elág. | [NAME] | 16:10:00 | 16:10:00
12 | 12 | .. | .. | Kozárd, f. szöv. | 14:15:00 | 16:15:00 | 16:15:00
14.3 | 14.3 | .. | .. | Ecseg, templom | 14:19:00 | 16:19:00 | 16:19:00
15.1 | 15.1 | .. | .. | Keresztvölgyi elág | 14:21:00 | 16:21:00 | 16:21:00
18 | 18 | .. | .. | [NAME] elág. | 14:24:00 | 16:24:00 | 16:24:00
20.8 | 20.8 | .. | .. | Szécsényi útelág. | 14:27:00 | 16:27:00 | 16:27:00
24.5 | 24.5 | .. | .. | Pásztó, vá. | 14:31:00 | 16:31:00 | 16:31:00
24.5 | 24.5 | .. | .. | Pásztó, vá. | 14:34:00 | 16:34:00 | 16:34:00
25.6 | 25.6 | .. | .. | Pásztó, Csillag tér | 14:35:00 | 16:35:00 | 16:36:00
27 | S | .. | .. | Pásztó, [NAME]. út | 14:37:00 | 16:37:00 | S
31.4 | S | .. | .. | [NAME], Szabadság út 169. | 14:42:00 | 16:42:00 | S
32.1 | S | .. | .. | [NAME], óvoda | 14:43:00 | 16:43:00 | S
32.8 | S | .. | .. | [NAME], Szabadság tér | 14:45:00 | 16:45:00 | S
37.2 | 36.3 | .. | .. | Jobbágyi, galgagutai elág. | 14:48:00 | 16:48:00 | 16:48:00
45.2 | 44.3 | .. | .. | Petőfibányai elág. | 14:56:00 | 16:56:00 | 16:56:00
99.1 | 98.2 | .. | .. | Budapest, Szerencs u.
103 | 102.1 | .. | .. | Budapest, [NAME] út | L 15:52 | L 17:52 | L 17:52
106.8 | 105.9 | .. | .. | Budapest, Stadion aut. pu. | 16:00:00 | 18:00:00 | 18:00:00
[NAME]:
A járatok az [NAME], de a mezőben fel [NAME] megállóhelyeknél [NAME] állnak meg.
0 csomagkezelést nem igénylő utasok részére 45 V. 1-től VIII. 31-ig munkanapokon
O | [NAME]
V | [NAME]
 | a járat érinti a megállóhelyet, de nem áll meg
S | a járat nem érinti a megállóhelyet, [NAME]
L | megállás csak leszálló utasok részére
Spreadsheet: 196061d1353815293-2003-excel-printing-copie-de-test-page
Sheet: Feuil1

 | SNACK ARTIST $0.10 PROMO ALLOWANCE WEEKS 46 THRU 52 2011 vs. 2012
 | WEEKLY AVERAGE
 | 2011 |  |  |  |  |  |  | 2012 |  |  |  |  |  |  | CHG
 | Net Sales | Units Sold | [NAME]. Price | AGP $ | AGP Per Unit | AGP % |  | Net Sales | Units Sold | [NAME]. Price | AGP $ | AGP Per Unit | AGP %
SNACK ARTIST PROMO SKU'S
Denver
Dallas
Atlanta
Phoenix
Portland
Texas
Nor Cal
Seattle
Chicago
Eastern
TOTAL CITIES
NATIONAL BRANDS (901 SALTY BAGGED CATEGORY)
Denver
Dallas
Atlanta
Phoenix
Portland
Texas
Nor Cal
Seattle
Chicago
Eastern
TOTAL CITIES
TOTAL 901 SALTY BAGGED CATEGORY
Denver
Dallas
Atlanta
Phoenix
Portland
Texas
Nor Cal
Seattle
Chicago
Eastern
TOTAL CITIES
Spreadsheet: 588302d1535554862-adding-the-total-of-each-specific-strings-xlf20180829-adding-the-total-of-each-specific-strings-example-_-as
Sheet: FG2

Copy of Cell A1 from 'Before' sheet
DARK GREEN=1194;C-8:UK10=54;C-9:UK10=54;C-10:UK10=54;C-11:UK14=54;C-12:UK12=54;C-13:UK12=54;C-14:UK12=54;C-15:UK6=60;C-16:UK8=57;C-17:UK8=60;C-18:UK8=60;C-19:UK8=60;C-20:UK8=60;C-21:UK10=54;C-22:UK6=60;C-23:UK8=60;C-24:UK16=54;C-25:UK14=50;C-26:UK12=45;C-27:UK4=46;C-28:UK10=54;C-29:UK16=28,UK6=8;
Result of Text-to-Columns run on the above using semi-colon as separator
DARK GREEN=1194 | [NAME]:UK10=54 | C-9:UK10=54 | C-10:UK10=54 | C-11:UK14=54 | C-12:UK12=54 | C-13:UK12=54 | C-14:UK12=54 | C-15:UK6=60 | C-16:UK8=57 | C-17:UK8=60 | C-18:UK8=60 | C-19:UK8=60 | C-20:UK8=60 | C-21:UK10=54 | C-22:UK6=60 | C-23:UK8=60 | C-24:UK16=54 | C-25:UK14=50 | C-26:UK12=45 | C-27:UK4=46 | C-28:UK10=54 | [NAME]:UK16=28,UK6=8
Copy those cells and 'Transpose' gives column A below
 | Extract last | These cells | and then | Now list the | and sum the
 | cell into | can now be | the numbers | distinct values | values for each
 | two cells | used to | after the =
 |  | extract the | signs
 |  | UK## parts
DARK GREEN=1194 | DARK GREEN=1194 |  |  |  |  |  | Copied from 'After' - cross-check of figures
[NAME]:UK10=54 | [NAME]:UK10=54 |  |  |  |  |  | UK10 | 270
C-9:UK10=54 | C-9:UK10=54 |  |  |  |  |  | UK14 | 104
C-10:UK10=54 | C-10:UK10=54 |  |  |  |  |  | UK12 | 207
C-11:UK14=54 | C-11:UK14=54 |  |  |  |  |  | UK6 | 128
C-12:UK12=54 | C-12:UK12=54 |  |  |  |  |  | UK8 | 357
C-13:UK12=54 | C-13:UK12=54 |  |  |  |  |  | UK16 | 82
C-14:UK12=54 | C-14:UK12=54 |  |  |  |  |  | UK4 | 46
C-15:UK6=60 | C-15:UK6=60
C-16:UK8=57 | C-16:UK8=57
C-17:UK8=60 | C-17:UK8=60
C-18:UK8=60 | C-18:UK8=60
C-19:UK8=60 | C-19:UK8=60
C-20:UK8=60 | C-20:UK8=60
C-21:UK10=54 | C-21:UK10=54
C-22:UK6=60 | C-22:UK6=60
C-23:UK8=60 | C-23:UK8=60
C-24:UK16=54 | C-24:UK16=54
C-25:UK14=50 | C-25:UK14=50
C-26:UK12=45 | C-26:UK12=45
C-27:UK4=46 | C-27:UK4=46
C-28:UK10=54 | C-28:UK10=54
[NAME]:UK16=28,UK6=8 | C-29:UK16=28
 | UK6=8
Spreadsheet: 09bc9924-b829-4d98-91fc-e6c36129d4cd
Sheet: Table 6.3

Monthly Statistical Bulletin
6.3 Terms of trade
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Implicit price deflator for exports of goods and services (a) (b) – index
September | 79.8 | 96.5 | 104.4 | 89.9 | 93.4
December | 79.1 | 94.8 | 102 | 89.4 | 94.6
March | 82.5 | 99.8 | 95.2 | 90.8 | 95.7
June | 95.2 | 103.4 | 96.9 | 90.6
Annual average | 84.21133486958554 | 98.66203422564234 | 100 | 90.15818851146224
Implicit price deflator for imports of goods and services (a) (b) – index
September | 105.7 | 102 | 98.4 | 99.3 | 107
December | 100.9 | 98 | 101 | 100.2 | 107.2
March | 100.3 | 98.3 | 98.9 | 100.2 | 109.8
June | 101.9 | 98.3 | 101.5 | 100.5
Annual average | 102.0392117565896 | 99.07030247511425 | 100 | 99.93384497361563
Terms of trade (a) (b) (c) – index
September | 75.4 | 94.6 | 106.1 | 90.5 | 87.3
December | 78.4 | 96.6 | 101 | 89.2 | 88.2
March | 82.2 | 101.5 | 96.2 | 90.6 | 87.1
June | 93.5 | 105.2 | 95.5 | 90.2
Annual average | 82.52840591366807 | 99.58790047141073 | 100 | 90.21787216859879
(a) Quarterly figures are seasonally adjusted.
(b) Base: 2010-11 = 100.0.
(c) Index of the ratio of the implicit price deflator for exports of goods and services
to the implicit price deflator for imports of goods and services
Sources: ABS, Balance of payments and international investment position, | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=&
Cat. no. 5302.0
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | Early September 2014
Spreadsheet: 726044d1617026916-pulling-data-at-the-end-of-a-business-day-sample
Sheet: PositionType

Pos # | Enter Position Types Here
 | All
Spreadsheet: 24852d1215720826-putting-text-in-a-referenced-cell-reorg
Sheet: newPattern

Oranges | Water | Mangos | Soda | Man | Carbon
Juice | Apples | Helium | Cat | Wood | Fish
Pineapples | Milk | [NAME] | Girl | [NAME] | Metal
Peaches | Boy | Child | Hydrogen | Bird | Woman
Dog | Paper | Plastic | Horse | [NAME] | Cardboard
Spreadsheet: 21118d1208269299-listing-cells-that-meet-a-criteria-trsetparameters
Sheet: TR4

Date | Neutralization Number (Acid) | D877 | SPGR | Visual | Sediment | Moisture | Furans | Hydrogen | Methane | [NAME] | [NAME] | Ethylene | [NAME] | Total Combustibles
2005-02-22 00:00:00 | 0.02 | 35 | 0.96 | CLR | NONE | 11 | ND | 249 | 42 | 1584 | 13 | 5 | ND | 1893
2008-03-06 00:00:00 | 0.01 | 49 | 0.96 | CLR | NONE | 17 | 1 | 50 | 21 | 610 | 9 | ND | ND | 690
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E
COMPANY NAME    Enron Building Services, Invest Co
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: f05369d2-9b73-4e9c-b88e-ef83e07df1d0
Sheet: Sheet1

Public Service Commissioner (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/24/2013 5:36:58 PM
Precincts Reporting: 696/696 - Total Ballots Cast: 292249
2000 General Election - OFFICIAL RESULTS
Precinct | [NAME] | [NAME] | TOTALS
Combined Precinct | 689 | 737 | 1426
TOTAL | 689 | 737 | 1426
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 779201d1651623017-help-needed-for-sum-up-time-totals-workingpaytemplate-northernwarrior-
Sheet: Sheet6

Sunday |  | Platform |  | Pays
Daily HOS | Overall Hours | Platform | Non Platform | Overtime | Call-Up
Run # | Start Time | End Time | Extend | Duration | Task
Call Up ? | No | 9:30 Booking |  | Additional HOS Minutes
Spreadsheet: 776998d1650056093-retain-only-rows-where-column-a-has-values-in-column-b-and-c-that-are-unique-to-value-in-a-example
Sheet: Raw Data

Login_ID | Role | user_type | Organization
[NAME] | A | 1 | Bubble
[NAME] | B | 1 | Bubble
[NAME] | C | 1 | Bubble
[NAME] | D | 1 | Bubble
[NAME] | A | 1 | Curtain
[NAME] | B | 1 | Curtain
[NAME] | C | 1 | Curtain
[NAME] | D | 1 | Curtain
[NAME] | A | 2 | Bubble
[NAME] | B | 2 | Bubble
[NAME] | A | 1 | Crater
[NAME] | B | 1 | Crater
[NAME] | C | 1 | Crater
[NAME] | D | 1 | Crater
[NAME] | A | 2 | Crater
[NAME] | B | 2 | Crater
[NAME] | A | 1 | Valley
[NAME] | B | 1 | Valley
[NAME] | A | 1 | Hill
[NAME] | B | 1 | Hill
[NAME] | A | 1 | Lake
[NAME] | B | 1 | Lake
[NAME] | A | 1 | Stream
[NAME] | B | 1 | Stream
Scott | A | 2 | Hat
Scott | A | 2 | Belt
[NAME] | A | 1 | Minnesota
[NAME] | B | 1 | Minnesota
[NAME] | C | 1 | Minnesota
[NAME] | D | 1 | Minnesota
[NAME] | A | 2 | Texas
[NAME] | B | 2 | Texas
[NAME] | C | 2 | Texas
[NAME] | D | 2 | Texas
[NAME] | A | 2 | Tree
[NAME] | A | 2 | Rock
Spreadsheet: 270778d1381656105-help-with-day-calculation-formula-visa-passport-2003-off2010-copyright
Sheet: Passport

 |  | Passport validation  ©
 | You MUST have 6 months left on your passport to enter Turkey
 | Enter your next depart date |  |  | 2013-11-15 00:00:00
 |  | Current visa started on |  | 2013-06-01 00:00:00 |  |  |  | 180 part of visa expires
 |  |  |  |  |  |  |  | 180 day roll back from next exit date
 | List your holiday dates using  dd/mm/yy format |  |  |  |  |  |  | Days in turkey on latest 180 roll back
 |  | Arrive | [NAME] | Days used | Days Used from M8
 | 1 | 2013-06-01 00:00:00 | 2013-06-15 00:00:00
 | 2 | 2013-08-01 00:00:00 | 2013-08-24 00:00:00
 | 3 | 2012-10-01 00:00:00 | 2013-11-15 00:00:00
 | 4
 | 5
 | 6
 |  |  | total days used
 | The above information is for guidance only
 |  | Juco   fstorm   Passport   14/8/12
 |  | This calculator may be be used for private use, contact the owner for public use. ©
 |  |  | Use the tabs at the bottom of this page to switch between Visa & Passport
Spreadsheet: 730187d1619599051-combine-data-from-two-columns-combine-data-from-two-columns
Sheet: Sheet1

1) Data from the previous month |  |  | 3) Data from previous month and raw data are combined here |  |  | 2) Raw data from the insurance provider is pasted here
Customers | Comments |  | Customers | Comments |  | Insured
Lazy | Get up |  |  |  |  | Lazy
New | Call |  |  |  |  | New
Old | Boss |  |  |  |  | Old
Cheezy | Good |  |  |  |  | Cheezy
Burger | Later |  |  |  |  | Burger
Chocolate | Smooth |  |  |  |  | Chocolate
Stick |  |  |  |  |  | Stick
Chewy |  |  |  |  |  | Chewy
Puppy |  |  |  |  |  | Puppy
Cat | Get out
Duck | Fly
Dog | Eat a snack
Spreadsheet: james_steffes__12835__PX Values
Sheet: PG&E tables

 |  |  |  |  |  |  |  | ILLUSTRATION OF PX CREDIT
 |  |  |  |  |  |  |  | on Sample Bill
 | Residential rate class. |  |  |  |  |  | CASE ONE:  Assume PX Credit equals the Generation Cost in the existing frozen rate. |  |  | CASE TWO:  Set PX Credit equal to PG&E's JULY value. |  |  | CASE THREE(a)  Set PX Credit equal to MARKET* |  |  | CASE THREE(b)  Set PX Credit equal to LOWER MARKET
 | Assume 1000 kWh per month. |  |  |  |  |  | "SCE METHOD" |  |  | "PG&E METHOD"
 |  |  |  | Bundled |  |  | Direct Access |  |  | Direct Access |  |  | Direct Access |  |  | Direct Access
TARIFF COMPONENT
 |  | Generation (= OAS less T&D&Other)
 |  | T&D&Other
 | "Normal Revenue" (NR)
 | less | PX Credit | varies | 0
 | TOTAL TARIFF PAYMENT
 |  | back out T&D&Other
 |  | Implied CTC payment ("NEGATIVE PX CREDIT")
OTHER COSTS
 | plus | [NAME] |  |  |  |  | 10 |  |  | 10 |  |  | 10 |  |  | 10
 | plus | May 27 3-cent surcharge | 30 |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | plus | Enron's Energy Cost*
 | TOTAL COST to SERVE
 |  | * Enron's Energy Cost is set to break-even point:   (where CTC = 0)
 |  | equal to RESIDUAL GEN + 3 cents  =  $99/MWh
1000 | Unbundle Tariff |  | $/MWh |  |  | $/MWh |  |  | $/MWh |  |  | $/MWh |  |  | $/MWh
kWh
 |  | Transmission | 4.59
 |  | Distribution | 42.06
 |  | PPP | 4.23
 |  | ND | 0.55
 |  | FTA | 12.49
 | Subtotal
 |  | [NAME] | 69.29
 |  | PG&E's Energy "Cost" (PX CREDIT) |  |  |  |  |  |  | 35 |  |  |  |  |  | 55
 |  | CTC payment
 | Total [NAME]
Spreadsheet: 79067d1279294150-counting-multiples-with-criteria-counting-multiples
Sheet: Sheet1

Name | Product | Purchase Month | Purchase Date | Location |  |  | Products | Special Product List
[NAME] | Corn | Jun | 2010-06-14 00:00:00 | Cub |  |  | Bacon | Corn
[NAME] | Cherries | Jun | 2010-06-14 00:00:00 | Cub |  |  | Lettuce | Cherries
[NAME] | Bacon | Jun | 2010-06-14 00:00:00 | Cub |  |  | Tomato | Bacon
[NAME] | Lettuce | Jun | 2010-06-15 00:00:00 | Cub |  |  | Potato
[NAME] | Tomato | Jun | 2010-06-15 00:00:00 | Cub |  |  | Corn
[NAME] | Potato | Jun | 2010-06-30 00:00:00 | Rainbow |  |  | Watermelon
Anders | Corn | Jun | 2010-06-01 00:00:00 | Rainbow |  |  | Cherries
Jan | Cherries | Jun | 2010-06-02 00:00:00 | HyVee
[NAME] | Corn | Jun | 2010-06-05 00:00:00 | Rainbow
[NAME] | Bacon | Jun | 2010-06-05 00:00:00 | Rainbow |  |  |  |  | Question 1 | Question 2
[NAME] | Watermelon | Jun | 2010-06-05 00:00:00 | HyVee |  |  |  |  | # of multiples | # of specials
[NAME] | Cherries | Jun | 2010-06-07 00:00:00 | Cub |  |  |  | Rainbow
[NAME] | Corn | Jun | 2010-06-07 00:00:00 | Rainbow |  |  |  | Cub
[NAME] | Bacon | Jun | 2010-06-07 00:00:00 | Rainbow |  |  |  | HyVee
[NAME] | Watermelon | Jun | 2010-06-12 00:00:00 | HyVee
[NAME] | Lettuce | Jun | 2010-06-12 00:00:00 | HyVee
Brent | Cherries | Jun | 2010-06-17 00:00:00 | Rainbow
Kenyon | Corn | Jun | 2010-06-27 00:00:00 | Rainbow
Jon | Bacon | Jun | 2010-06-25 00:00:00 | Cub
Question 1: | What formula would calculate the number of customers that purchased multiple items?
 | Answer should equal 5 ([NAME], [NAME], Megan, [NAME], [NAME]) (Doesn't matter if they purchased 2 or 3 or 5, as long as it is more than 1)
Question 2: | What formula would calculate the number of times a customer purchased the 3 special products (Corn, Cherries, Bacon)
 | Answer should equal 2 ([NAME], [NAME])
Spreadsheet: f7e4b931-3e65-46f9-9996-79d05af4fe14
Sheet: GAAP to Non-GAAP Measures 2012

 | [NAME], INC. AND SUBSIDIARIES
 | RECONCILIATION OF GAAP NET INCOME TO NON-GAAP MEASURES
 | (Amounts in millions, except earnings per share data)
 | Three Months Ended March 31, 2012 |  |  | Net Revenues | Cost of Sales - Product Costs | Cost of Sales - Online Subscriptions | Cost of Sales - Software Royalties and Amortization | Cost of Sales - Intellectual Property Licenses | Product Development | Sales and Marketing | General and Administrative | Total Costs and Expenses
 | GAAP Measurement |  |  | 1172 | 257 | 59 | 31 | 7 | 124 | 79 | 102
 |  | Less:  Net effect from deferral in net revenues and related cost of sales | (a) | -585 | -119 | 0 | -18 | -1 | 0 | 0 | 0
 |  | Less:  Stock-based compensation | (b) | 0 | 0 | 0 | -3 | 0 | -4 | -2 | -12
 |  | Less:  Amortization of intangible assets | (c) | 0 | 0 | 0 | 0 | -3 | 0 | 0 | 0
 | Non-GAAP Measurement
 |  |  |  | Operating Income | Net Income | Basic Earnings per Share | Diluted Earnings per Share
 | GAAP Measurement |  |  |  | 384 | 0.34 | 0.33
 |  | Less:  Net effect from deferral in net revenues and related cost of sales | (a) |  | -335 | -0.29 | -0.29
 |  | Less:  Stock-based compensation | (b) |  | 16 | 0.01 | 0.01
 |  | Less:  Amortization of intangible assets | (c) |  | 2 | 0 | 0
 | Non-GAAP Measurement |  |  |  |  | 0.06 | 0.06
 |  | (a) Reflects the net change in deferred net revenues and related cost of sales.
 |  | (b) Includes expense related to stock-based compensation.
 |  | (c) Reflects amortization of intangible assets.
 |  | The per share adjustments are presented as calculated, and the GAAP and non-GAAP earnings per share information is also presented as calculated. The sum of these measures, as presented, may differ due to the impact of rounding.
Spreadsheet: daren_farmer__5716__HPLN0208
Sheet: Sheet1

HPLN0208.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - February 08, 2001
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-08 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 83445d1283426980-adding-isna-to-if-vlookup-forecasting-over-50-units
Sheet: Forecast

Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | June
Part Code | Qty |  | Part Code | Qty |  | Part Code | Qty |  | Part Code | Qty |  | Part Code | Qty |  | Part Code | Qty
AAA1 | 40 |  | AAA1 | 4 |  | AAA1 | 423 |  | AAA1 | 40 |  | AAA1 | 4 |  | AAA1 | 423
AAA2 | 1 |  | AAA2 | 1 |  | AAA2 | 1 |  | AAA2 | 1 |  | AAA2 | 1 |  | AAA2 | 1
AAA3 | 30 |  | MMM2 | 2 |  | AAA3 | 75 |  | TTT3 | 30 |  | AAA3 | 2 |  | AAA3 | 75
[NAME] | 50 |  | BBB1 | 455 |  | BBB1 | 35 |  | BBB1 | 50 |  | BBB1 | 455 |  | BBB1 | 35
BBB2 | 1 |  | LLL4 | 344 |  | BBB2 | 6 |  | BBB2 | 4 |  | BBB2 | 10 |  | BBB2 | 6
BBB3 | 2 |  | BBB3 | 21 |  | BBB3 | 8767 |  | BBB3 | 2 |  | BBB3 | 21 |  | BBB3 | 8767
CCC1 | 4 |  | CCC1 | 4 |  | CCC1 | 1 |  | CCC1 | 4 |  | CCC1 | 4 |  | CCC1 | 1
FFF6 | 50 |  | CCC2 | 424 |  | CCC2 | 3 |  | HHH1 | 50 |  | CCC2 | 424 |  | JJJ2 | 3
[NAME] | 82 |  | [NAME] | 7 |  | [NAME] | 6 |  | [NAME] | 82 |  | [NAME] | 7 |  | [NAME] | 6
DDD2 | 40 |  | DDD2 | 61 |  | DDD2 | 534 |  | DDD2 | 40 |  | DDD2 | 61 |  | DDD2 | 534
Spreadsheet: 836480d1689393084-query-across-multiple-columns-and-multiple-criteria-with-flexible-content-ice-monthly-plan-stuart33-
Sheet: Scratchpad

IGNORE
=SUMPRODUCT(SUMIF(INDIRECT("'"&"Project A"&"'!"&G7:V7),G7,INDIRECT("'"& "Project A" &"'!"&G8:V8)))
Does work as not always row 7 or 8
=SUMPRODUCT(SUMIFS(INDIRECT("'"&F3:F6&"'!"&"D3:D7"),INDIRECT("'"&F3:F6&"'!"&"C3:C7"),H3))
 |  | #REF! | #REF!
 | #REF! | #REF! | #REF!
P | A | B | C
X | 1 | 2 | 3
Y | 4 | 5 | 6
Z | 7 | 8 | 9
Spreadsheet: 012d44af-5177-4e44-b226-25fa5756f132
Sheet: Sheet1

Name: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | BS/MS Plan of Study
 |  |  |  |  | 2012-2013
 | Fall |  |  | Winter |  |  | Spring |  |  | Summer
Course | Title | CR | Course | Title | CR | Course | Title | CR | Course | Title | CR
 | GR - |  |  | GR - |  |  | GR - |  |  | GR -
 | UG - |  |  | UG - |  |  | UG - |  |  | UG -
 | Term Total - |  |  | Term Total - |  |  | Term Total - |  |  | Term Total -
 |  |  |  |  | 2013-2014
 | Fall |  |  | Winter |  |  | Spring |  |  | Summer
Course | Title | CR | Course | Title | CR | Course | Title | CR | Course | Title | CR
 | GR - |  |  | GR - |  |  | GR - |  |  | GR -
 | UG - |  |  | UG - |  |  | UG - |  |  | UG -
 | Term Total - |  |  | Term Total - |  |  | Term Total - |  |  | Term Total -
 |  |  |  |  | 2014-2015
 | Fall |  |  | Winter |  |  | Spring |  |  | Summer
Course | Title | CR | Course | Title | CR | Course | Title | CR | Course | Title | CR
 | GR - |  |  | GR - |  |  | GR - |  |  | GR -
 | UG - |  |  | UG - |  |  | UG - |  |  | UG -
 | Term Total - |  |  | Term Total - |  |  | Term Total - |  |  | Term Total -
Please circle your UG degree |  |  |  |  |  | Credit Count
[NAME] |  |  |  |  |  | Current - |  |  | Total # [NAME]
Please circle your intended MS degree |  |  |  |  |  | Plan of Study - |  |  | Total # Undergrad Credits -
MSCS           MSSE |  |  |  |  |  | Total -
Spreadsheet: daren_farmer__5529__Cannon WACOG Winter 2000
Sheet: 2000

 | Volume |  | Index |  | V*I
2000-06-01 00:00:00 | 1568655 |  | 4.38
2000-07-01 00:00:00 | 1620897 |  | 4.38
2000-08-01 00:00:00 | 1620897 |  | 3.86
2000-09-01 00:00:00 | 1568654 |  | 4.64
2000-10-01 00:00:00 | 1620897 |  | 5.3
 |  |  |  |  |  |  | WACOG
 | Volume |  | Index |  | V*I
Extension
2000-06-01 00:00:00 | 392160 |  | 4.38
2000-07-01 00:00:00 | 405232 |  | 4.38
2000-08-01 00:00:00 | 405232 |  | 3.86
2000-09-01 00:00:00 | 392160 |  | 4.64
2000-10-01 00:00:00 | 405232 |  | 5.3
 |  |  |  |  |  |  | WACOG
Spreadsheet: 110910d1307470088-trigger-and-target-references-break-with-insert-ref_macro
Sheet: settings

 | [NAME] | Test | Function | Target | True | False |  |  |  |  |  |  | Function List
 | B14 | Yes | Show | B15 |  |  |  |  |  |  |  |  | Append
 | B15 | Yes | Show | B16 |  |  |  |  |  |  |  |  | ChgVal
 | B17 | Yes | Show | B18:[NAME] |  |  |  |  |  |  |  |  | Change
 |  |  |  |  |  |  |  |  |  |  |  |  | HideChk
 |  |  |  |  |  |  |  |  |  |  |  |  | Show
 |  |  |  |  |  |  |  |  |  |  |  |  | ChangeChk
Spreadsheet: 740394d1626321114-multiple-dates-entries-in-a-gantt-chart-in-a-single-row-scheduler-3a-4a-
Sheet: Settings

Month | Leave Type | Leave Code
2021-01-01 00:00:00 | Other Leave | OL
2021-02-01 00:00:00 | Leave Without Pay | LWP
2021-03-01 00:00:00 | [NAME] | SL
2021-04-01 00:00:00 | Casual Leave | CL
2021-05-01 00:00:00 | Maternity Leave | ML
2021-06-01 00:00:00
2021-07-01 00:00:00
2021-08-01 00:00:00
2021-09-01 00:00:00
2021-10-01 00:00:00
2021-11-01 00:00:00
2021-12-01 00:00:00