tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: scott_neal__37883__STOR9803
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9803
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-10-27 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 649 | 666
(TX, LA, OK, KS, MS)
Market Area - East |  | 1613 | 1661
Market Area - West |  | 380 | 385
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: mark_whitt__25254__Huber - Existing & Proposed Deals 111201
Sheet: Exposure

 |  | IF NGPL MidContinent index (@ Forgan) | IF NGPL MidContinent index (@ [NAME]) | IF NGPL MidContinent Index minus $0.01 | IF CIG Rocky Mtns. index minus $0.03 (Proposed) | Gas Daily PG&E Topock index minus $0.02 (Proposed) | Gas [NAME] San Juan index minus $0.10 (Proposed) | Gas Daily NWPL Wyoming Pool index minus $0.10 (Proposed) | Total |  | WA Price
Spreadsheet: 814222d1674230162-sumif-based-on-text-between-two-dates-textexample
Sheet: Sheet1

 |  |  |  | OUTPUT NEEDED
Date | Fabric | Units Sold
2022-01-01 00:00:00 | fabric_crepe,fabric_velvet | 5 |  | Between dates |  |  |  | Total Units Sold
2022-01-02 00:00:00 | fabric_velvet | 1 |  | 2022-01-01 00:00:00 | 2022-01-05 00:00:00 |  | fabric_velvet | 22
2022-01-03 00:00:00 | fabric_sequin,fabric_poly | 4 |  |  |  |  | fabric_crepe | 12
2022-01-04 00:00:00 | fabric_crepe,fabric_velvet | 7 |  |  |  |  | texture_feather | 9
2022-01-05 00:00:00 | fabric_velvet,texture_feather | 9
2022-01-06 00:00:00 | fabric_sequin,fabric_poly | 17
2022-01-07 00:00:00 | fabric_crepe,fabric_velvet | 11
2022-01-08 00:00:00 | fabric_velvet | 2
2022-01-09 00:00:00 | fabric_sequin,fabric_poly | 3
2022-01-10 00:00:00 | fabric_crepe,fabric_velvet | 8
2022-01-11 00:00:00 | fabric_velvet | 6
2022-01-12 00:00:00 | fabric_sequin,fabric_poly | 2
2022-01-13 00:00:00 | fabric_crepe,fabric_velvet | 4
Spreadsheet: 274552d1383147979-finding-value-using-formulas-functions-or-macros-in-intersection-of-2-data-series-in-graph-example_book_reattachted
Sheet: EXAMPLE4

 | DATA SERIE1
 | DATA FOR BLACK  LINE
 | Y AXE | X AXE
 | 76.19999999999999 | 100
 | 63.5 | 100
 | 50.8 | 100
 | 38.09999999999999 | 100
 | 25.4 | 100
 | 19.05 | 100
 | 12.5 | 97.8
 | 9.5 | 96.39999999999999
 | 4.75 | 94.1
 | 2 | 92.69999999999999
 | 0.42 | 90.39999999999999
 | 0.075 | 84.69999999999999
 |  |  |  |  | data for red vertical line
 |  |  | NUMBER THAT I WANT  TO FIND  AUTOMATICALLY USING FUNCTIONS  FORMULAS OR [NAME] |  | 0 |  | 0 | 60 | DATA SERIE 2
 |  |  |  |  | THIS NUMBER  IS THE X VALUE FOR WHICH THE Y VALUE FOR THE SERIE1 IS 60 |  |  | NOTE:VALUES IN X AXE IS IN INVERSE ORDER THE SCALE OF X AXE IS IN LOG BASE 10
Spreadsheet: 829083d1683901294-index-match-with-sort-capability-planning-project-test
Sheet: Paste

[NAME] | desc | packs
86932400 | drums | 500
86941100 | thighs | 1000
86932900 | wings | 600
86932300 | drums | 200
86418000 | drums | 4000
86780600 | wings | 2000
86934800 | wings | 1000
Spreadsheet: 852095d1702194567-use-lookup-to-get-2-values-from-2-cells-in-the-same-row-excelforum
Sheet: Results

 | LOOKUPVALUE | Liverpool |  |  | LOOKUPVALUE |  | [NAME] |  |  | Home points | Away points
 | Date | Home Team |  |  | Result |  | Away Team
2023-08-11 20:00:00 |  | Burnley |  |  | 0 | 3 | Man City
2023-08-12 13:00:00 |  | Arsenal |  |  | 2 | 1 | [NAME]
2023-08-12 15:00:00 |  | Bournemouth |  |  | 1 | 1 | West Ham
2023-08-26 12:30:00 |  | Bournemouth |  |  | 0 | 2 | Spurs
2023-09-03 14:00:00 |  | Crystal Palace |  |  | 3 | 2 | Wolves
2023-09-03 14:00:00 |  | Liverpool |  |  | 3 | 0 | [NAME]
2023-09-03 16:30:00 |  | Arsenal |  |  | 3 | 1 | Man Utd
2023-09-16 12:30:00 |  | Wolves |  |  | 1 | 3 | Liverpool
2023-09-16 15:00:00 |  | [NAME] |  |  | 3 | 1 | Crystal Palace
2023-09-16 15:00:00 |  | Fulham |  |  | 1 | 0 | Luton
2023-09-16 15:00:00 |  | Man Utd |  |  | 1 | 3 | Brighton
2023-09-16 15:00:00 |  | Spurs |  |  |  |  | Sheffield Utd
2023-09-16 15:00:00 |  | West Ham |  |  | 1 | 3 | Man City
2023-09-16 17:30:00 |  | Newcastle |  |  | 1 | 0 | Brentford
2023-09-17 14:00:00 |  | Bournemouth |  |  | 0 | 0 | Chelsea
2023-09-17 16:30:00 |  | Everton |  |  | 0 | 1 | Arsenal
2023-09-18 19:45:00 |  | [NAME] |  |  |  |  | Burnley
2023-09-23 15:00:00 |  | Crystal Palace |  |  | 0 | 0 | Fulham
2023-09-23 15:00:00 |  | Luton |  |  | 1 | 1 | Wolves
2023-09-23 15:00:00 |  | Man City |  |  | 2 | 0 | [NAME]
Spreadsheet: 789645d1659267565-dynamic-cumulative-sums-revisited-grouped-calculations-dynamic-cumulative-sumif-gk
Sheet: Sheet1

Thing | Data |  | Cumulative SUM |  | Conventional cumulative SUMIF |  | Dynamic cumulative sum MMULT | Dynamic cumulative sum SUBTOTAL OFFSET |  | Dynamic cumulative SUMIF??? | [NAME] SUMIF?
A | 3 |  |  |  |  |  |  |  |  |  | 3
B | 12 |  |  |  |  |  | 15 |  |  | 12 | 12
B | 5 |  |  |  |  |  | 20 |  |  | 17 | 17
B | 3 |  |  |  |  |  | 23 |  |  | 20 | 20
A | 3 |  |  |  |  |  | 26 |  |  | 6 | 3
A | 1 |  |  |  |  |  | 27 |  |  | 7 | 4
B | 4 |  |  |  |  |  | 31 |  |  | 24 | 4
B | 4 |  |  |  |  |  | 35 |  |  | 28 | 8
C | 8 |  |  |  |  |  | 43 |  |  | 8 | 8
C | 3 |  |  |  |  |  | 46 |  |  | 11 | 11
C | 7 |  |  |  |  |  | 53 |  |  | 18 | 18
D | 1 |  |  |  |  |  | 54 |  |  | 1 | 1
B | 2 |  |  |  |  |  | 56 |  |  | 30 | 2
A | 11 |  |  |  |  |  | 67 |  |  | 18 | 11
Spreadsheet: 77561d1278003936-vlookup-example
Sheet: Sheet1

Account | Department | Data
A | 1
A | 2
A | 3
A | 4
B | 1
B | 2
B | 3
B | 4
C | 1
C | 2
C | 3
C | 4
Spreadsheet: 840199d1692547726-countifs-word-or-another-word-but-not-in-same-cell-countifs-word-or-another-word-but-not-in-same-cell-solution-
Sheet: Sheet1

100 | this man is Good |  |  |  | 100
200 | this man is [NAME] |  |  |  | 200
300 | this man is [NAME] and Bad |  |  |  | 300 |  |  | I want make it count if any of these word exist but not in same cell so code 300 should counted 2 not 4
400 | this man is Good |  |  |  | 400
500 | this man is Good |  |  |  | 500
100 | this man is Good
200 | this man is [NAME]
300 | this man is [NAME]
400 | this man is Good
500 | this man is Good
Spreadsheet: 889661d1740565463-index-match-data
Sheet: INDEX

 |  | Partner: | B
 |  |  |  | P&L Mth | P&L
 |  |  |  | 2024-01-01 00:00:00
 |  |  |  | 2024-02-01 00:00:00
 |  |  |  | 2024-03-01 00:00:00
 |  |  |  | 2024-04-01 00:00:00
 |  |  |  | 2024-05-01 00:00:00
 |  |  |  | 2024-06-01 00:00:00
 |  |  |  | 2024-07-01 00:00:00
 |  |  |  | 2024-08-01 00:00:00
 |  |  |  | 2024-09-01 00:00:00
 |  |  |  | 2024-10-01 00:00:00
 |  |  |  | 2024-11-01 00:00:00
 |  |  |  | 2024-12-01 00:00:00
 |  |  |  | 2025-01-01 00:00:00
 |  |  |  | 2025-02-01 00:00:00
 |  |  |  | 2025-03-01 00:00:00
 |  |  |  | 2025-04-01 00:00:00
 |  |  |  | 2025-05-01 00:00:00
 |  |  |  | 2025-06-01 00:00:00
 |  |  |  | 2025-07-01 00:00:00
 |  |  |  | 2025-08-01 00:00:00
 |  |  |  | 2025-09-01 00:00:00
 |  |  |  | 2025-10-01 00:00:00
 |  |  |  | 2025-11-01 00:00:00
 |  |  |  | 2025-12-01 00:00:00
 |  |  |  | 2026-01-01 00:00:00
 |  |  |  | 2026-02-01 00:00:00
 |  |  |  | 2026-03-01 00:00:00
Spreadsheet: 91807d1291476848-how-to-calculate-the-weightage-using-3-parameters-problem
Sheet: Sheet1

CUST ID | CUST TYPE | MONTH | INVESTMENT
12300120 | RETAIL | JAN | 610961 | HERE I WANT TO GET THE WEGHTAGE OF THIS CUST IN MY PROTFOLIO AGAINST THE CUST TYPE & MONTH
13930352 | NRI | FEB | 685800 | eg :  The value in % form of the total investment by the retail customers in Jan month.
11427937 | HNI | JAN | 270009
9148656 | RETAIL | FEB | 25827.53
12704724 | NRI | JAN | 467914
12687144 | HNI | FEB | 540531
11270239 | RETAIL | JAN | 314344.28
7761371 | RETAIL | FEB | 106739.75
12589677 | NRI | JAN | 423514
8027348 | HNI | FEB | 127259.74
9141183 | RETAIL | JAN | 56039.39
9693478 | NRI | FEB | 18254.01
13649419 | HNI | JAN | 759555
11447642 | RETAIL | FEB | 545757
Spreadsheet: 193036d1352710116-time-sheet-with-formula-cell-to-work-out-the-hours-work-rota-template-november-2012
Sheet: RELIEFS

 |  |  |  | RELIEFS
RELIEF |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY |  |  | T
 |  | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Start | End | Hrs | Hrs
Deputy | Steph 22.5hrs
 | Tasha 37.5hrs
2.5 CSA | [NAME]
 | [NAME] 30hrs
 | Keesha 18hrs
 | [NAME] 22hrs
 | Neerma 30hrs
 | Nivan 12hrs
 | Ramesh 24hrs
 | Ransford 18hrs
 | Ritish 30hrs
 | Shanika 22.5hrs
 | Sunil 18hrs
 | Tamara        15 hrs
 | Yogesh 6hrs
 | [NAME]
 | Pravesh 30hrs
CSA | Byron 18hrs
 | Danielle 30hrs
 | Gayle 6hrs
 | Monique 18hrs
 | Prabat 20hrs
 | Rafata 6hrs
 | Sarka 22hrs
 | Stina 30hrs
Spreadsheet: 05e41bd9-353f-4021-8d1a-638f59e092c1
Sheet: LRC

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Program
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | LRC 900X4 | 1
5 | [NAME] 960X4 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 477145d1472146395-formula-to-add-row-data-if-blank-then-data-from-different-sheet-with-reference-criteria-sumofthings
Sheet: Completed

 |  | Comp | Comp | Comp | Comp | Comp | Comp
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | C Holcom | 15 | 30 | 60 | 100 | 225 | 300
 | A Ivanson | 20 | 60 | 100 | 160 | 400 | 640
 | B Risuto | 20 | 85 | 140 | 200 | 450 | 700
 | M Franklin | 20 | 85 | 140 | 200 | 450 | 700
Spreadsheet: a3528a54-47e1-4c4e-870f-22b532282626
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
CRYE | Test | CRYE | Cultivated Rye, IgE | Cultivated Rye, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
CRYE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CRYE | Result | CRYE | Cultivated Rye, IgE | Cultivated Rye, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6236-4
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: Col

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/24/2001 11:46 am | 5000 | 4.085
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/24/2001 11:58 am | 10000 | 4.0275
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/25/2001 09:59 am | 5000 | 3.93
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/25/2001 10:45 am | 5000 | 3.945
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 01:06 pm | 5000 | 3.8075
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 02:49 pm | 1687 | 3.7375
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 03:08 pm | 10000 | 3.7275
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 03:10 pm | 6211 | 3.735
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 09:45 am | 5000 | 3.855
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 11:04 am | 5000 | 3.86
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 11:08 am | 5000 | 3.8625
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 11:12 am | 5000 | 3.865
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 11:18 am | 2000 | 3.865
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/29/2001 12:19 pm | 5000 | 3.84
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/30/2001 01:37 pm | 5000 | 3.815
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/30/2001 02:01 pm | 31 | 3.83
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/30/2001 09:02 am | 1500 | 3.62
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/30/2001 11:32 am | 49 | 3.6275
US Gas Phy       COL Onshore             Jun01           USD/MM | 05/31/2001 08:37 am | 10000 | 3.785
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 713320d1610644695-string-comparison-exceltestbench
Sheet: Runmap

 |  | LAYUP / RUNMAP
Sort | Part | Material | Ver | Layup | Length (in) | Length (ft) | Length (ft)2 | I.N. | IUM | S1 | S2 | S3 | [NAME] | S5 | S6 | S7 | S8 | S9 | S10 | S11 | S12 | S13 | S14 | S15 | S16 | S17 | S18 | S19 | S20 | S21 | S22 | S23 | S24 | S25 | S26 | [NAME] | S28 | S29 | S30 | S31 | S32 | S33 | S34 | S35 | S36 | S37 | S38 | S39 | S40 | S41 | S42 | S43 | S44 | S45 | S46 | S47 | S48 | S49 | S50 | L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | L8 | L9 | L10 | L11 | L12 | [NAME] | [NAME] | L15 | L16 | L17 | L18 | L19 | L20 | [NAME] | L22 | [NAME] | L24 | [NAME] | L26 | L27 | L28 | L29 | L30 | [NAME] | L32 | [NAME] | L34 | L35 | [NAME] | L37 | L38 | L39 | L40 | [NAME] | L42 | [NAME] | L44 | L45 | L46 | L47 | L48 | L49 | L50
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 2
 | 2
 | 2
 | 3
 | 3
 | 4
 | 4
Spreadsheet: 66646d1267279756-countif-pivot-table-and-pivot-chart-based-on-data-countif
Sheet: Sheet2

Regular Pivot Table |  |  |  | Required Pivot Table
Count of Salary |  |  |  | Count of Salary
Dept | Salary | Total |  | Dept | Salary | Total
ACCOUNTS | 44 | 1 |  | ACCOUNTS | 0-5000 | 3
 | 4844 | 1 |  |  | 5001-10000 | 22
 | 4888 | 1 |  | Grand Total |  | 25
 | 6453 | 1
 | 6824 | 1
 | 6963 | 1
 | 7378 | 1
 | 7771 | 6
 | 8285 | 1
 | 8458 | 1
 | 8631 | 1
 | 8805 | 1
 | 8978 | 2
 | 9151 | 2
 | 9498 | 3
 | 9844 | 1
 | 10017 | 2
 | 10249 | 4
 | 10479 | 1
 | 10595 | 3
 | 10711 | 1
 | 10941 | 2
 | 11288 | 1
 | 11519 | 1
 | 11750 | 4
 | 11865 | 1
 | 11981 | 1
 | 12443 | 2
 | 12674 | 1
 | 13251 | 1
 | 13483 | 1
 | 13598 | 4
 | 14175 | 1
 | 14291 | 1
 | 14522 | 2
 | 14869 | 2
 | 15315 | 3
 | 15661 | 6
 | 16008 | 3
 | 16470 | 2
 | 16701 | 3
 | 16932 | 2
 | 17394 | 2
 | 17625 | 1
 | 18087 | 2
 | 18549 | 1
 | 19011 | 2
 | 19935 | 5
 | 20513 | 2
 | 21667 | 1
 | 22245 | 2
 | 22823 | 2
 | 23400 | 2
 | 25133 | 1
 | 25652 | 1
 | 26403 | 1
 | 27038 | 1
 | 28309 | 1
 | 28655 | 1
 | 29753 | 1
 | 30907 | 1
 | 34950 | 2
 | 35816 | 1
 | 36683 | 1
 | 37549 | 1
 | 38877 | 1
 | 39801 | 1
 | 42342 | 1
 | 44421 | 1
Grand Total |  | 119
Spreadsheet: 219777d1362942737-summing-rows-by-year-formated-from-a-formula-sum-rows-by-year
Sheet: Sheet1

 |  |  |  |  |  | 1993-01-01 00:00:00 | 1993-02-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00
 |  | 1999 | 2000 | 2001
 |  |  |  |  |  | 15 | 30 | 5 | 22 | 50 | 89
 |  |  |  |  |  | 12 | 35 | 10 | 28 | 45 | 75
Spreadsheet: mary_fischer__25629__1580  6-2001
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 06-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other |  |  |  |  |  |  |  |  |  |  |  |  |  | 300773
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  | Unbilled Revenue - Work in Progress (offset to Accounts Receivable) |  |  |  |  |  |  |  | 300772.5
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 678893d1590102161-sorting-random-integers-in-descending-order-and-identifying-the-row-with-each-sorted-value-problem
Sheet: Last Guy

Metric |  | Metric Rank | Row # | Hidden 'helper column'
24
12
12
8
5
20
8
60
60
60
1
60
1
60
20
20
20
10
4
18
30
10
18
50
16
30
3
3
16
30
8
5
5
8
5
4
75
50
50
50
50
18
45
25
25
40
60
Spreadsheet: 782629d1654164662-counting-cells-up-to-a-value-excluding-some-sample-worksheet-attached-copy-vc-aligw
Sheet: Hot & Cold Spot (90.5°C for 10)

 | Time to reach 4.5°C (From start)
 | Time Stamp | Probe 1 | Probe 2 | Probe 3 | Probe 4 | Probe 5 | Probe 6 | Probe 7 | Probe 8
 |  | 3 |  | 3
 |  | 4 |  | 3
 |  | 5 | 3 | 3
 |  | 6 | 4 | 3
 |  | 8 | 5 | 3
 |  | 12 | 6 | 4
 |  | 30 | 8 | 5
 |  | 50 | 12 | 6
 |  | 70 | 30 | 8
 |  | 90 | 50 | 12
 |  | 95 | 70 | 30
 |  | 90.5 | 90 | 50
 |  | 60 | 95 | 70
 |  | 50 | 90.5 | 90
 |  | 30 | 60 | 95
 |  | 20 | 50 | 90.5
 |  | 10 | 30 | 60
 |  | 6 | 20 | 50
 |  | 3 | 10 | 30
 |  | 4.5 | 6 | 20
 |  |  | 3 | 10
 |  |  | 4.5 | 6
 |  |  |  | 3
 |  |  |  | 4.5
Spreadsheet: 212485d1360149999-2-combo-boxes-to-select-row-and-column-5s-plant-entry
Sheet: Score Entry

 |  | Stores Operations |  |  |  |  |  |  |  |  |  | Blending Department |  |  |  |  |  |  |  |  |  | Production Department |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Support Departments |  |  |  |  | Tea Kitting |  |  |  |  | Engineering |  |  |  |  | Work In Progress
Area |  | Stores 1 |  |  |  |  | Stores 2 |  |  |  |  | Blending 1 |  |  |  |  | Blending 2 |  |  |  |  | 50 / 100 pce |  |  |  |  | 20 pce and Rework |  |  |  |  | Dream |  |  |  |  | Manufacturing Offices |  |  |  |  | Building 2 |  |  |  |  | Engineer Stoes / Workshop |  |  |  |  | WIP / Walkway
Period 4 |  | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % | 1S | 2S | 3S | Total | % |  | Daily Plant Total
Mon | Week 17 | 15 | 14 | 21
Tue
Wed
Thu
Fri
WK AVG
Mon | Week 18
Tue
Wed
Thu
Fri
WK AVG
Mon | Week 19
Tue
Wed
Thu
Fri
WK AVG
Mon | Week 20
Tue
Wed
Thu
Fri
WK AVG
Pd AVG
1
Spreadsheet: kate_symes__18898__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-21 00:00:00 |  | 395 | 15200 | 222.02 | 8392
 | 2001-03-20 00:00:00 |  | 379.17 | 18400 | 211.59 | 9640
 | 2001-03-19 00:00:00 |  | 313.9 | 18736 | 207.5 | 11648
 | 2001-03-18 00:00:00 |  |  |  |  |  | 196.24 | 29832
 | 2001-03-17 00:00:00 |  | 205.5 | 18592 | 148.56 | 7024
 | 2001-03-16 00:00:00 |  | 205.98 | 17600 | 148.56 | 7024
 | 2001-03-15 00:00:00 |  | 184.07 | 20192 | 129.29 | 6440
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
 | 2001-03-06 00:00:00 |  | 339.12 | 29856 | 231.76 | 7080
 | 2001-03-05 00:00:00 |  | 299.82 | 13200 | 217.92 | 3080
 | 2001-03-04 00:00:00 |  |  |  |  |  | 217.92 | 9240
 | 2001-03-03 00:00:00 |  | 248.15 | 15920 | 165.24 | 2720
 | 2001-03-02 00:00:00 |  | 248.24 | 16400 | 165.07 | 3320
 | 2001-03-01 00:00:00 |  | 264.44 | 17648 | 164.24 | 7520
 | 2001-02-28 00:00:00 |  | 181.23 | 21200 | 120.65 | 4728
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800
 | 2001-02-25 00:00:00 |  |  |  |  |  | 132.88 | 14400
 | 2001-02-24 00:00:00 |  | 177.7 | 16000 | 131.62 | 11200
 | 2001-02-23 00:00:00 |  | 179.36 | 17040 | 131.62 | 11200
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
Spreadsheet: 115843d1311332828-insert-rows-beneath-cells-containing-specific-text-market-summary-example
Sheet: Sheet1

table | sort
this is the market summary | 1
ccc 1 | 2
[NAME] 2 | 3
[NAME] 3 | 4
this is the market summary | 5
[NAME] | 6
ccc 5 | 7
[NAME] 6 | 8
this is the market summary | 9
[NAME] 7 | 10
[NAME] 8 | 11
[NAME] 9 | 12
this is the market summary | 13
[NAME] 10 | 14
[NAME] | 15
[NAME] 12 | 16
this is the market summary | 17
[NAME] | 18
[NAME] 12 | 19
[NAME] 13 | 20
[NAME] 14 | 21
[NAME] 15 | 22
[NAME] 16 | 23
this is the market summary | 24
[NAME] 17 | 25
 | 1
 | 5
 | 9
 | 13
 | 17
 | 24
Spreadsheet: 58813d1259075312-split-data-into-ranges-708485_mmandel
Sheet: Sheet1

Number
53
21
79
80
94
62
25
95
87
100
75
51
16
66
80
65
80
78
50
73
83
71
98
18
14
51
17
48
51
38
2
67
93
79
72
64
19
29
20
64
12
73
63
18
69
60
42
28
85
22
19
16
72
23
54
100
48
31
46
52
55
86
95
46
40
13
77
16
98
7
37
21
83
45
37
72
43
79
83
58
83
41
19
65
48
45
10
25
84
21
77
72
3
12
47
77
61
30
70