tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126074d1319509197-i-need-help-compiling-a-total-in-excel-from-multiple-worksheets-in-the-same-workbook-goodwill
Sheet: Totals_2011

 | Quan. | Net  Value | Gross Value
Womens Suit | 1 | 20 | 20
Womens Shoes | 5 | 5 | 25
2000 Venture Headlamp | 1 | 65 | 65
Black Leather Computer Chair | 1 | 40 | 40
Kids Castle Set | 1 | 30 | 30
Kids Play Foam Squares  Rug | 1 | 20 | 20
Hockey Sticks | 3 | 25 | 75
Kitchen Clock | 1 | 15 | 15
Large [NAME] | 1 | 20 | 20
100 Ft Extention Cord | 1 | 20 | 20
50 Ft Extention Cord | 1 | 15 | 15
25 Ft Extention Cord | 2 | 10 | 20
Pants | 6 | 15 | 47
Shirts | 8 | 6 | 48
Large Rubbermaid Container | 1 | 25 | 25
Wood hanger | 15 | 3 | 45
Shoe Trees | 4 | 3 | 12
Large Books | 15 | 8 | 120
Small Books | 12 | 6 | 72
Dresses | 2 | 15 | 30
small tools | 20 | 3 | 60
small baby toys | 10 | 3 | 30
Plastic Containers | 3 | 4 | 12
Tupperware containers | 12 | 3 | 36
Dress Coats marcia | 2 | 15 | 30
Board games | 10 | 4 | 40
Computer Cords | 20 | 2 | 40
Magazines | 100 | 2 | 200
Notebooks black/white | 6 | 3 | 18
[NAME] | 1 | 10 | 10
Leather [NAME] | 2 | 10 | 20
[NAME] | 1 | 5 | 5
Caulking Gun | 3 | 8 | 24
Angle Levels | 2 | 10 | 20
[NAME] | 1 | 8 | 8
Belts for Sander | 18 | 6 | 108
Short Level | 1 | 15 | 15
Grid Ceiling Punch NEW | 1 | 50 | 50
Shot Lights | 2 | 20 | 40
Wallboard Sanding Block | 1 | 15 | 15
Steel Wool | 3 | 7 | 21
[NAME] | 1 | 25 | 25
Bungy Cords | 10 | 3 | 30
Drawer File Adapters | 8 | 2 | 16
Hammer | 3 | 5 | 15
CD Radio | 1 | 25 | 25
Lincoln Cents Partial Set Old | 1 | 20 | 20
Specialty Bits for Rosetts | 2 | 50 | 100
[NAME] | 35 | 4 | 140
Hole Saw Parts | 7 | 6 | 42
[NAME] | 2 | 5 | 10
[NAME] | 1 | 35 | 35
[NAME] template | 1 | 15 | 15
[NAME] | 1 | 10 | 10
Paint Mixer Paddle | 1 | 15 | 15
Sanding Blocks | 2 | 3 | 6
Steel Wire | 1 | 3 | 3
Elastic Auto Net | 1 | 5 | 5
[NAME] | 1 | 5 | 5
Caulking Tubes | 16 | 4 | 64
[NAME] | 2 | 4 | 8
[NAME] | 1 | 50 | 50
Blades for 10" | 10 | 5 | 50
Tool Box Plastic | 1 | 15 | 15
Paint Mate Painter | 1 | 40 | 40
Shirt | 7 | 5 | 35
Leather Boots | 1 | 15 | 15
Cordless Telephone | 1 | 35 | 35
Swivel Picture Frame | 1 | 10 | 10
Shower Curtain Rings | 1 | 4 | 4
Shoe Trees (pair) | 4 | 4 | 16
Complete Sets of Sheets | 2 | 15 | 30
New MP4 Player | 1 | 75 | 75
Towels | 2 | 3 | 6
New Candle | 1 | 3 | 3
[NAME] | 1 | 2 | 2
Miscelaneous Kitchen Items | 10 | 2 | 20
New Adidas Tennis Shoes | 1 | 30 | 30
Book | 2 | 4 | 8
Tie | 10 | 2 | 20
Laptop Computer IBM With Dock | 1 | 75 | 75
Infant Dishwasher Basket | 1 | 3 | 3
[NAME] Shoes | 1 | 10 | 10
Faux Leather Boots | 1 | 10 | 10
Sweater | 1 | 5 | 5
Thumb Nailer | 1 | 200 | 200
Irrigation Slip Connector (Sprinkler) | 1 | 20 | 20
Spreadsheet: 110431d1307094865-excel-2007-reference-list-of-dates-and-count-back-1-2-or-3-cells-example2
Sheet: Sheet1

 |  |  |  |  |  |  | Current date | 2011-06-03 00:00:00
 |  | # | Date | Country | Circuit
 |  | 1 | 2011-03-27 00:00:00 | Australia | [NAME] |  |  |  |  | Last three results
 |  | 2 | 2011-04-10 00:00:00 | Malaysia | Sepang |  |  |  |  | Race date or name X |  | Race date or name Y |  | Race date or name Z
 |  | 3 | 2011-04-17 00:00:00 | China | Shanghai
 |  | 4 | 2011-05-08 00:00:00 | Turkey | Istanbul Park |  |  |  | driver | points |  | points |  | points
 |  | 5 | 2011-05-22 00:00:00 | Spain | [NAME]
 |  | 6 | 2011-05-29 00:00:00 | Monaco | Monaco
 |  | 7 | 2011-06-12 00:00:00 | Canada | [NAME] |  |  |  | driver | points |  | points |  | points
 |  | 8 | 2011-06-26 00:00:00 | Europe | [NAME]
 |  | 9 | 2011-07-10 00:00:00 | Great-Britain | Silverstone
 |  | 10 | 2011-07-24 00:00:00 | Germany | Nürburgring |  |  |  | driver | points |  | points |  | points
 |  | 11 | 2011-07-31 00:00:00 | Hungary | Hungaroring
 |  | 12 | 2011-08-28 00:00:00 | Belgium | Spa-Francorchamps
 |  | 13 | 2011-09-11 00:00:00 | Italy | Monza |  |  |  | team | points |  | points |  | points
 |  | 14 | 2011-09-25 00:00:00 | Singapore | Marina Bay
 |  | 15 | 2011-10-09 00:00:00 | Japan | [NAME]
 |  | 16 | 2011-10-16 00:00:00 | South Korea | Korea Int'l Circuit |  |  |  |  | total |  | total |  | total
 |  | 17 | 2011-10-30 00:00:00 | India | [NAME]
 |  | 18 | 2011-11-13 00:00:00 | UAE | [NAME]
 |  | 19 | 2011-11-27 00:00:00 | Brazil | Interlagos
Spreadsheet: 165628d1341306498-min-max-if-to-ignore-blanks-ignore-blank-values-for-min-if-copy
Sheet: Sheet1

Group | Result |  | Group | MINs
0 | 0.6286289726180948 |  | 0 |  |  | <<< WRONG |  | CORRECT >>> |  | 0.6286289726180948 |  | Question: how to I exclude groups with blank value (nothing)?
0 | 0.8753961479248742 |  | 1
0 | 0.8609051345121496
0 | 0.7330331871656578
0 | 0.8390286524765075
0 | 0.8133685785731878
0 | 0.8192802406249312
0 | 0.7788857489551921
0 | 0.7655792358115872
0 | 0.7671824664876692
0 | 0.7291503161094215
0 | 0.7675508745779298
0 | 0.8116634304104761
0 | 0.8814461855738658
0 | 0.8335861960856588
0 | 0.7660110479382464
0 | 0.7723747959462228
0 | 0.825472962038932
0 | 0.8048216682317921
0 | 0.8185167646482345
0 | 0.726053441922915
0 | 0.8376183400254205
0 | 0.7282196376458646
0 | 0.7249701437815232
0 | 0.682794850028505
0 | 0.6346692626056771
0 | 0.8335978177175473
0 | 0.7036529058696541
0 | 0.6961139390688356
0 | 0.6954072270428688
0 | 0.768708778658919
0 | 0.8482598860667796
0 | 0.729146981412663
0 | 0.7878995861660644
0 | 0.8166478561859603
0 | 0.9639117606116463
0 | 0.7989588809523843
0 | 0.692400078917906
0 | 0.8379245755728001
0 | 0.7274573472219958
0 | 0.7110637531673721
0 | 0.7882663443571323
0 | 0.8124040602460983
0 | 0.9796913167047462
0 | 0.9339908144081874
0 | 0.875441236309457
0 | 0.7697422488396641
0 | 0.9946183365914176
0 | 0.8490181338361665
0 | 0.8102020614089258
0 | 0.7631055973442163
0 | 1.016935657181375
0 | 0.8836281256026107
0 | 0.8266970428433854
0 | 0.8703167229655686
0 | 0.7941433393065203
0 | 0.7547117476989924
0 | 0.9590395599025473
0 | 0.8406959718203296
0 | 0.756578603798965
 | 0.4481793387186194
 | 0.6570318913118197
 | 0.4625458887685293
 | 0.8472072849192749
 | 0.6823217891539934
1 | 0.7641338787112479
1 | 0.7781963266044065
1 | 0.5797474389496209
1 | 0.8145507004056722
1 | 0.8413501644055157
1 | 0.7565908105446826
1 | 0.7073647930563188
Spreadsheet: 733181d1621431364-replacing-multiple-values-in-a-column-based-on-a-pre-defined-list-demo-replace-values
Sheet: Sheet1

Year Month | HS Practice plus Code | BNF Presentation | Items
202004 | ABC | Z  500 mcg tablets | 2
202004 | XYZ | A  1mg modified-release tablets | 2
202005 | [NAME] | Cyanocobalamin 1mg modified-release tablets | 1 |  |  |  | Original value | New Value
202005 | ALWOODLEY | Cyanocobalamin 1mg modified-release tablets | 1 |  |  |  | 202004 | 2020-04-01 00:00:00
202006 | [NAME] (B86051) | ABF 1mg  tablets | 2 |  |  |  | 202005 | 2020-05-01 00:00:00
202007 | [NAME] (B86051) | ABF 1mg  tablets | 1 |  |  |  | 202006 | 2020-06-01 00:00:00
202007 | BELLBROOKE SURGERY (B86081) | ABF 1mg  tablets | 2 |  |  |  | 202007 | 2020-07-01 00:00:00
202008 | [NAME] (B86051) | ABF 1mg  tablets | 1 |  |  |  | 202008 | 2020-08-01 00:00:00
202009 | [NAME] MEDICAL PRACTICE (Y02494) | ABF 1mg  tablets | 4 |  |  |  | 202009 | 2020-09-01 00:00:00
202009 | THE GARDEN SURGERY (B86054) | RST 1 mg capsules | 1 |  |  |  | 202010 | 2020-10-01 00:00:00
202009 | WHITEHALL SURGERY (B86071) | RST 1 mg capsules | 2 |  |  |  | 202011 | 2020-11-01 00:00:00
202010 | [NAME] (B86051) | RST 1 mg capsules | 1
202011 | [NAME] (B86051) | RST 1 mg capsules | 1
202011 | BELLBROOKE SURGERY (B86081) | RST 1 mg capsules | 2
Spreadsheet: 730825d1619975676-payment-forecast-test
Sheet: Service Contracts

Sup | £ ea | £ pa | [NAME] | Inv [NAME] | Nx inv |  | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 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 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00
A | 50 |  | 2021-03-01 00:00:00 | 1 |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
B | 200 |  | 2020-12-01 00:00:00 | 6 |  |  |  |  |  |  |  |  |  |  | 200 |  |  |  |  |  | 200 |  |  |  |  |  | 200
C | 150 |  | 2020-09-01 00:00:00 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150
D | 2000 |  | 2019-07-01 00:00:00 | 24
Spreadsheet: 724856d1616421750-calculating-sales-lift-only-for-cells-based-on-effective-date-pbg-chain-activity-program-template-test
Sheet: TEMPLATE

 | Brand |  | SKU
 | Size |  | CHAIN |  |  |  |  | CHAIN EVENT
 | Event Type |  | Event Length |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
 |  |  |  |  |  |  |  | 4.28571428571428 | 4 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | weeks
 | State | PODs |  | CPSPW |  | EFFECTIVE DATE |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 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 | TOTAL
 | ALABAMA | Current | 100 | Current | 0.5
 |  | Change (+/-) | 50 | Upper | 0.8
 |  | New |  | Lower | 0.4 | 2021-09-01 00:00:00
 | ALASKA | Current | 100 | Current | 0.2
 |  | Change (+/-) | 50 | Upper | 2
 |  | New |  | Lower | 0.5 | MAY
 | ARIZONA | Current | 100 | Current | 1
 |  | Change (+/-) | 50 | Upper | 3
 |  | New |  | Lower | 1.5 | 2021-06-01 00:00:00
 | ARKANSAS | Current | 100 | Current | 0.2
 |  | Change (+/-) | 50 | Upper | 1
 |  | New |  | Lower | 0.5 | JUL
 | CALIFORNIA | Current | 100 | Current | 1
 |  | Change (+/-) | 50 | Upper | 2
 |  | New |  | Lower | 1 | AUG
 | TOTAL | Current |  | Current
 |  | Change (+/-) |  | Upper
 |  | New |  | Lower
Spreadsheet: 437980d1451651658-create-list-from-table-data
Sheet: Output

Articlenr | Option:
123 | Option 1
123 | Option 7
123 | 1
123 | 2
123 | 3
345 | Option 2
345 | Option 5
345 | 2
345 | 3
345 | 4
678 | Option 1
678 | Option 6
678 | 3
678 | 4
678 | 5
678 | 6
678 | 7
Spreadsheet: 02584142-54ea-49a2-be26-08293ed14b05
Sheet: Sheet1

COMVEC TECHNICAL COMMITTEE MEETING SCHEDULE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
October 1-3, 2013
[NAME] Convention Center
5555 N. River Road Rosemont, IL 60018  (Chicago) USA
Tuesday, October 1, 2013
Time | Committee | Chairman | Room | Notes
8am - 5 pm | Participant Ready Room & Standards Lounge - Coffee, networking lounge and SAE staff's home base.                         21
8:00am - 9:00am | Truck and Bus Corrosion Committee | [NAME] | 33
9:00am - 11:00am | Truck and Bus J2711 Update Task Force | [NAME] | 33
9:30am - 10:30am | Truck and Bus Human Factors Committee | [NAME] | 34
10:30am - 12:00pm | Truck and Bus Windshield Wipers and Climate Control Committee | [NAME] | 34
1:00pm - 2:00pm | Access Systems for On-Road Commercial Vehicles Task Group | [NAME] | 34
1:00pm - 2:30pm | Truck Crashworthiness Committee | [NAME] | 33
2:30pm - 3:30pm | Truck and Bus Body and Occupant Environment Steering Committee | [NAME] | 34
2:30pm - 4:00pm | Truck and Bus Hybrid Safety Committee | [NAME] | 33
3:30pm - 5:00pm | Truck and Bus Aerodynamics and Fuel Economy Committee | [NAME] | 32
4:00pm - 5:00pm | Truck and Bus Advanced and Hybrid Powertrain Steering Committee | [NAME] | 33
Wednesday October 2, 2013
Time | Committee | Chairman | Room | Notes
8am - 5 pm | Participant Ready Room & Standards Lounge - Coffee, networking lounge and SAE staff's home base.                         21
8:00am - 9:00am | Truck and Bus Brake Actuator Committee | [NAME] | 34
9:00am - 10:00am | Truck and Bus Hydraulic Brake Committee | [NAME] | 34
9:00am - 10:30am | Truck and Bus Tire Committee | [NAME] | 33
10:00am - 11:00am | Truck and Bus Stability Control Systems Committee | [NAME] | 34
11:00am - 12:00pm | Truck and Bus Brake Supply and Control Components Committee | [NAME] | 34
1:00pm - 2:00pm | Truck and Bus Foundation Brake Committee | [NAME] | 34
2:00pm - 4:00pm | Truck and Bus Active Safety Systems Committee | [NAME] | 32
2:30pm - 4:00pm | Truck and Bus Electrical Systems Committee | [NAME] | 33
3:00pm - 5:00pm | Truck and Bus Air Brake Tubing and Fitting Committee | [NAME] | 34
4:00pm - 5:00pm | Total Vehicle Steering Committee | [NAME] | 33
Thursday, October 3, 2013
Time | Committee | Chairman | Room | Notes
8am - 5 pm | Participant Ready Room & Standards Lounge - Coffee, networking lounge and SAE staff's home base.                          21
8:00am - 9:00am | Truck and Bus Brake Systems Committee | [NAME] | 34
9:00am - 10:00am | Truck and Bus Brake and Stability Control Steering Committee | [NAME] | 34
10:00am - 12:00pm | Getting Ahead and on Top of the Wave Technology Summit | [NAME] | 31
1:00pm - 4:00pm | Truck and Bus Council | [NAME] | 34
Spreadsheet: 3058bff2-0d79-4926-8ffd-4eb08c459846
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
08/31/2013 | Football | William & Mary | W, 24-17
09/07/2013 | Football | at Oklahoma* | L, 7-16
09/14/2013 | Football | Georgia State | W, 41-7
09/21/2013 | Football | vs. Maryland (Baltimore, Md.) | L, 0-37
[NAME] | Football | Oklahoma State* | W, 30-21
10/05/2013 | Football | at Baylor* | L, 42-73
10/19/2013 | Football | Texas Tech* | L, 27-37
10/26/2013 | Football | at Kansas State* | L, 12-35
11/02/2013 | Football | at TCU* | W, 30-27 (OT)
11/09/2013 | Football | Texas* | L, 47-40 (OT)
11/16/2013 | Football | at Kansas* | L, 31-19
11/30/2013 | Football | Iowa State* | L, 44-52 (3 OT)
Spreadsheet: 878461d1725541878-auto-number-generate-with-conditions-srno-help-tpsdas-
Sheet: tbl_Data

Item Type | Attribute | Value | Time | Rank
111 | Receipt _ Dt | 2024-01-01 00:00:00
111 | Receipt _ Dt | 2024-01-05 00:00:00
111 | Receipt _ Dt | 2024-01-05 00:00:00
333 | Receipt _ Dt | 2024-01-05 00:00:00
111 | Return  _ Dt | 2024-01-09 00:00:00
111 | Receipt _ Dt | 2024-01-09 00:00:00
111 | Return  _ Dt | 2024-01-10 00:00:00
111 | Receipt _ Dt | 2024-01-10 00:00:00
333 | Return  _ Dt | 2024-01-11 00:00:00
111 | Return  _ Dt | 2024-01-12 00:00:00
111 | Return  _ Dt | 2024-01-13 00:00:00
111 | Receipt _ Dt | 2024-01-13 00:00:00
111 | Receipt _ Dt | 2024-01-20 00:00:00
111 | Return  _ Dt | 2024-01-22 00:00:00
111 | Receipt _ Dt | 2024-01-25 00:00:00
111 | Receipt _ Dt | 2024-01-26 00:00:00
111 | Return  _ Dt | 2024-01-26 00:00:00
111 | Receipt _ Dt | 2024-01-26 00:00:00
111 | Receipt _ Dt | 2024-01-30 00:00:00
222 | Receipt _ Dt | 2024-01-30 00:00:00
111 | Return  _ Dt | 2024-01-31 00:00:00
111 | Return  _ Dt | 2024-01-31 00:00:00
222 | Return  _ Dt | 2024-02-15 00:00:00
111 | Receipt _ Dt | 2024-02-28 00:00:00
222 | Receipt _ Dt | 2024-02-28 00:00:00
111 | Receipt _ Dt | 2024-03-15 00:00:00
222 | Receipt _ Dt | 2024-03-31 00:00:00
111 | Receipt _ Dt | 2024-07-29 00:00:00
333 | Receipt _ Dt | 2024-07-31 00:00:00
111 | Return  _ Dt | 2024-08-01 00:00:00
333 | Receipt _ Dt | 2024-08-10 00:00:00
222 | Return  _ Dt | 2024-08-11 00:00:00
333 | Return  _ Dt | 2024-08-16 00:00:00
333 | Receipt _ Dt | 2024-08-25 00:00:00
111 | Return  _ Dt | 2024-08-29 00:00:00
Spreadsheet: 872224d1718633015-formula-to-fetch-data-file_updated
Sheet: Overview

Raw data | Raw data number | ID | Correct tag | Final output
:25:AT941810010134880900
:25:4221869693EUR
:25:[NAME]
:25:HR4423600001101234512-978
:25:MBRZRRMM/40702978000000931203/
:25:[PHONE]
 |  |  |  | In the sheet Overview, in the Final output column E (highlighted with yellow), we need to fetch the data from master data sheet, column F highlighted in orange.
 |  |  |  | We need somehow, based on raw data number from column B (sheet overview), to get that data from column F from sheet master data.
 |  |  |  | Let me know if I should add more info to clarify my request…Thanks
Spreadsheet: 0290fdc5-5bd5-4c83-9144-4c8fe8e8025f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
F3AAG | Test | F3AAG | Androstanediol Glucuronide | 3A Androstanediol-G | RIA after Hydrolysis of Glucuronide and Chromatography | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in plain, red-top tube(s). Separate within 1 hour and freeze immediately. Submit 2 mL serum frozen in plastic vial. | 0.7 mL | Specimens other than	Serum Anticoagulants other than	Plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | [NAME] y          <5-42      Adult Males                                       190-900      Adult Females                                    35-200              Occasional normal females with no evidence of hirsutism      may have levels well beyond the normal range.                Test Performed By:  Esoterix Endocrinology                                             4301 Lost Hills Road                                             Calabasas Hills, CA  91301 | Every other Tuesday | 3-12 days | 5-18 days | 1 | 82154 |  |  |  |  | Esoterix Endocrinology
F3AAG | [NAME] | SRED | Serum Red |  |  |  | Frozen | 90 days
F3AAG | Result | Z2250 | 3A Androstanediol-G | 3A Androstanediol-G | Alphanumeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 1680-8
Spreadsheet: 161437d1339519360-pulling-data-from-one-database-into-another-with-multiple-criteria-help-please-
Sheet: Sheet2

Name | Date | [NAME] or Benefits | $ Amt | Account
[NAME] | 01/11 | 1 | 1500.54 | 12216
[NAME] | 01/11 | 2 | 350 | 12216
[NAME] | 02/11 | 1 | 750 | 12216
[NAME] | 02/11 | 2 | 150 | 12216
[NAME] | 03/11 | 1 | 1700 | 12213
[NAME] | 03/11 | 2 | 400 | 12213
[NAME] | 04/11 | 1 | 985 | 12213
[NAME] | 04/11 | 2 | 354 | 12213
[NAME] | 05/11 | 1 | 789 | 12216
[NAME] | 05/11 | 2 | 134 | 12216
JDoe | 01/11 | 1 | 2500 | 12213
JDoe | 01/11 | 2 | 150 | 12213
JDoe | 02/11 | 1 | 750 | 12213
JDoe | 02/11 | 2 | 180 | 12213
JDoe | 03/11 | 1 | 745 | 12213
JDoe | 03/11 | 2 | 352 | 12213
JDoe | 04/11 | 1 | 1200 | 12216
JDoe | 04/11 | 2 | 456 | 12216
JDoe | 05/11 | 1 | 1352 | 12216
JDoe | 05/11 | 2 | 402 | 12216
Spreadsheet: tracy_geaccone__40213__EGA fcst
Sheet: August 1

Enron Global Assets
2001 THIRD QUARTER FORECAST
(Millions of Dollars)
 |  |  |  |  |  | 3rd Quarter
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | From
 |  |  |  |  |  | Forecast |  | 2nd CE |  | 2nd CE |  | Plan
Income Before Int. Expense & Income Taxes * |  |  |  |  |  | 0 |  | 0 |  |  |  | 0
Interest Expense
 | 3rd Party interest expense |  |  |  |  | 0 |  | 0 |  |  |  | 0
 | Intercompany capital charge expense (income) |  |  |  |  | 0 |  | 0 |  |  |  | 0
 | Other intercompany interest expense (income) |  |  |  |  | 0 |  | 0 |  |  |  | 0
 | Other - including capitalized interest |  |  |  |  | 0 |  | 0 |  |  |  | 0
Preferred Stock |  |  |  |  |  | 0 |  | 0 |  |  |  | 0
Pre-tax income
Income Tax |  |  |  |  |  | 0 |  | 0 |  |  |  | 0
Net Income
[NAME] (items greater than $1.0) |  |  |  |  |  |  |  |  |  | Interest |  |  |  | Net
 |  |  |  |  |  |  |  | IBIT |  | Expense |  | Taxes |  | Income
1st Current Estimate
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | [NAME] |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | Other |  |  |  |  |  |  | 0 |  | 0 |  | 0
Current Forecast
*    INCOME BEFORE INTEREST EXPENSE AND INCOME TAXES INCLUDES OUTSIDE (NOT INTERCOMPANY)
INTEREST INCOME.
Spreadsheet: 201188d1355907409-im-sure-this-is-super-easy-how-to-merge-and-sort-data-across-colums-nnjkjj
Sheet: Sheet1

 |  | Go from this:
 |  | A | B | C | D | E | F | G
 |  | H | 1 | 2 |  | H | 3 | 6
 |  | I | 2 | 2 |  | I | 4 | 1
 |  | J | 3 | 4 |  | K | 2 | 4
 |  | K | 2 | 8 |  | L | 3 | 4
 |  | L | 6 | 4 |  | M | 2 | 8
 |  | N | 3 | 2 |  | O | 5 | 8
 |  | To this:
 |  | A | B | C | D | E | F | G
 |  | H | 1 | 2 |  | H | 3 | 6
 |  | I | 2 | 2 |  | I | 4 | 1
 |  | K | 2 | 8 |  | K | 2 | 4
 |  | L | 6 | 4 |  | L | 3 | 4
 |  | J | 3 | 4 |  | M | 2 | 8
 |  | N | 3 | 2 |  | O | 5 | 8
Spreadsheet: 2673878e-30c2-4083-b095-5c05c44f99be
Sheet: Sheet1

Verizon Communications Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Condensed Consolidated Statements of Income
 |  |  |  |  |  |  |  | (dollars in millions, except per share amounts)
 |  | [NAME]. Ended | [NAME]. Ended |  |  | 12 Mos. Ended | 12 Mos. Ended
Unaudited |  | 2013-12-31 00:00:00 | 2012-12-31 00:00:00 | % Change |  | 2013-12-31 00:00:00 | 2012-12-31 00:00:00 | % Change
Operating Revenues |  | 31065 | 30045 | 3.4 |  | 120550 | 115846 | 4.1
Operating Expenses
Cost of services and sales |  | 11962 | 13069 | -8.5 |  | 44887 | 46275 | -3
Selling, general and administrative expense |  | 2857 | 16008 | -82.2 |  | 27089 | 39951 | -32.2
Depreciation and amortization expense |  | 4183 | 4137 | 1.1 |  | 16606 | 16460 | 0.9
Total Operating Expenses |  | 19002 | 33214 | -42.8 |  | 88582 | 102686 | -13.7
Operating Income (Loss) |  | 12063 | -3169 | * |  | 31968 | 13160 | *
Equity in earnings of unconsolidated businesses |  | 8 | 87 | -90.8 |  | 142 | 324 | -56.2
Other income and (expense), net |  | -250 | -1079 | -76.8 |  | -166 | -1016 | -83.7
Interest expense |  | -1061 | -575 | 84.5 |  | -2667 | -2571 | 3.7
Income (Loss) Before (Provision) Benefit for Income Taxes |  | 10760 | -4736 | * |  | 29277 | 9897 | *
(Provision) Benefit for income taxes |  | -2844 | 2810 | * |  | -5730 | 660 | *
Net Income (Loss) |  | 7916 | -1926 | * |  | 23547 | 10557 | *
Net income attributable to noncontrolling interests |  | 2849 | 2303 | 23.7 |  | 12050 | 9682 | 24.5
Net income (loss) attributable to Verizon |  | 5067 | -4229 | * |  | 11497 | 875 | *
Net Income (Loss) |  | 7916 | -1926 | * |  | 23547 | 10557 | *
Basic Earnings (Loss) per [NAME]
Net income (loss) attributable to Verizon |  | 1.77 | -1.48 | * |  | 4.01 | 0.31 | *
Weighted average number of common shares (in millions) |  | 2867 | 2862 |  |  | 2866 | 2853
Diluted Earnings (Loss) per [NAME] (1)
Net income (loss) attributable to Verizon |  | 1.76 | -1.48 | * |  | 4 | 0.31 | *
Weighted average number of common
 | shares-assuming dilution (in millions) | 2875 | 2862 |  |  | 2874 | 2862
Footnotes:
(1) | If there is a net loss, diluted EPS is the same as basic EPS. Diluted Earnings per Common Share includes the dilutive effect of shares issuable under our stock-based compensation plans.
 | Certain reclassifications have been made, where appropriate, to reflect comparable operating results.
* | Not meaningful