tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4da16838-5681-411b-b683-39938112d145
Sheet: Table 5.5

Monthly Statistical Bulletin
5.5 Stock exchange indexes
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
All ordinaries index (a)
July | 4249.5 | 4507.4 | 4500.5 | 4289.400000000001 | 5035.7
August | 4484.1 | 4438.8 | 4369.9 | 4339 | 5125.3
September | 4739.3 | 4636.9 | 4070.7 | 4406.3 | 5217.7
October | 4646.9 | 4733.4 | 4360.5 | 4535.4 | 5420.3
November | 4715.5 | 4676.4 | 4184.7 | 4518 | 5314.3
December | 4882.7 | 4846.9 | 4111 | 4664.6 | 5353.1
January | 4596.9 | 4850 | 4325.7 | 4901 | 5205.1
February | 4651.1 | 4923.6 | 4388.1 | 5120.38 | 5415.4
March | 4893.1 | 4928.6 | 4420 | 4979.9
April | 4833.9 | 4899 | 4467.2 | 5168.6
May | 4453.6 | 4788.9 | 4133.7 | 4914
June | 4324.8 | 4659.8 | 4135.5 | 4775.4
S&P/ASX 200 index (b)
July | 4244 | 4493.5 | 4424.6 | 4269.1 | 5052
August | 4479.1 | 4404.2 | 4296.5 | 4316.1 | 5135
September | 4743.6 | 4582.9 | 4008.6 | 4387 | 5218.9
October | 4643.2 | 4661.6 | 4298.1 | 4517 | 5425.5
November | 4701.4 | 4584.4 | 4119.8 | 4506 | 5320.1
December | 4870.6 | 4745.2 | 4056.6 | 4648.9 | 5352.2
January | 4569.6 | 4753.9 | 4262.7 | 4878.8 | 5190
February | 4637.7 | 4831.7 | 4298.5 | 5104.08 | 5404.8
March | 4875.5 | 4837.9 | 4335.2 | 4966.5
April | 4807.4 | 4823.2 | 4396.6 | 5191.2
May | 4429.7 | 4708.3 | 4076.3 | 4926.6
June | 4301.5 | 4608 | 4094.6 | 4802.6
(a) Index at the end of the month. Base: December 1979 = 500.0. (In March 2000 the
all ordinaries index was at 3 133.3, and this was the base used for the S&P/ASX200
index.)
(b) Index at the end of the month. Base: March 2000 = 3 133.3.
Source: Australian Financial Review | http://www.afr.com/home/
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-04-01 00:00:00
Spreadsheet: 829305d1684126679-trying-to-get-data-from-daily-sheet-sheet-1-for-all-data
Sheet: Main Summary

COMPANY | TODAY'S DATE | TODAY +1 | TODAY +2 | TODAY +3 | TODAY +4 | TODAY [NAME] | TODAY [NAME] | TODAY +7 | TODAY +8
A
B
C
D
2023 | 2024
Total
May
June
July
August
September
October
November
December
Spreadsheet: 713299d1610640396-sla-calculation-for-helpdesk-resolution-time-sample-sla-calc
Sheet: Sheet1

Service Type | Created Time | Resolved | SLA Calculation
Request Local Computer Support | 2020-11-12 19:12:00 | 2020-11-13 12:56:00
Problem Computer Local | 2020-11-12 17:47:00 | 2020-11-13 07:58:00 | 15:11
Request Local Computer Support | 2020-11-12 16:27:00 | 2020-11-12 17:28:00
Problem Computer Local | 2020-11-12 11:46:00 | 2020-11-12 12:03:00 | 0:07
Request Local Computer Support | 2020-11-12 11:36:00 | 2020-11-12 14:31:00
Problem Computer Local | 2020-11-12 11:23:00 | 2020-11-12 12:21:00 | 0:58
Problem Computer Local | 5/12/20 17:05 PM | 5/12/20 17:09 PM | 00:04:00
Spreadsheet: 877686d1724495421-finding-potential-values-for-x-and-y-linear-equation
Sheet: Sheet2 (2)

 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | A | B | A | B | A | B | A | B | A | B | A | B |  | A B | 0
15 | A | + | 25 | B | = | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | A | + |  | B | = | 310
 | A | + |  | B | = | 160
 | A | + |  | B | = | 160
 | A | + |  | B | = | 155
 | A | + |  | B | = | 255
 | A | + |  | B | = | 225
 | A | + |  | B | = | 210
 | A | + |  | B | = | 190
 | A | + |  | B | = | 115
 | A | + |  | B | = | 180
 | A | + |  | B | = | 260
Spreadsheet: 774056d1648195272-finding-position-of-smallest-value-book1
Sheet: Sheet1_helper

 |  |  |  |  |  |  |  | Using [NAME] find the year that has lowest sale
 |  |  |  |  |  |  |  | Using formula find the zone that had lowest sale (all years)
 |  | Sale in Crore |  |  |  |  |  | Using formula find the zone that had lowest sale (Lowest sale year)
 | Year | North | South | East | West
 | 2010 | 100.6533043419225 | 554.1241109765704 | 89.15512267345594 | 919.5781777856055
 |  | 360.9861989156767 | 109.3867370147656 | 680.0083014006053 | 23.77485869608331
 |  | 416.0925219060431 | 959.7285118443558 | 275.8328035724871 | 604.4225554168688
 |  | 238.3565295291449 | 243.4356045908543 | 981.0299732216674 | 770.6190993601399
 |  | 740.1869472820975 | 583.8988905204753 | 189.3958060044824 | 17.06485180142236
Spreadsheet: 698598d1602074226-dependent-drop-down-list-why-is-indirect-formula-not-working-excel-assistance
Sheet: Data

EOCD/EOMQ/EOMD | (All)
Course Name | (All)
Count of Sub Category
Issue Heading | Sub Category | Total
(blank) | (blank)
 | Tools/Equipment | 1
(blank) Total |  | 1
[NAME] | JI's | 9
 | Laptops | 16
 | Library | 4
 | (blank)
 | Facilities | 1
 | Induction | 4
 | School Facilities | 7
 | Pre-Course Learning | 2
 | Handouts/Precis | 1
 | Facilities/library | 7
 | Modnet pcs | 1
 | JIs | 2
 | Laptops | 2
 | Company Induction | 1
 | JIs/Timetable | 1
Admin Total |  | 58
Course | Classrooms | 2
 | General | 2
 | Library | 1
 | Positive Feedback | 5
 | Structure | 1
 | VLE | 3
 | Positive Trainer Feedback | 37
 | Negative Trainer Feedback | 7
 | Electrics | 4
 | Negative Feedback | 5
 | Exams | 9
 | Classroom | 13
 | Equipment | 1
 | [NAME] | 1
 | Assignments | 5
 | Expectations | 1
 | Assessments | 1
 | Course | 1
 | Feedback | 1
 | Resources | 4
 | Pre-Course Learning | 3
 | Handouts/Precis | 10
 | Pace & Length | 1
 | Facilities/library | 2
 | [NAME] | 1
 | Hydraulics | 8
 | Engines | 8
 | Transmissions | 4
 | Inspections | 2
 | Exp Repair | 1
 | Metalsmiths | 5
 | Electrics Wheels + Tyres | 3
 | Transmissions/Suspension Tech Basics | 3
 | Advanced Eng Tech/Transmission/Suspension Tech | 2
 | [NAME] | 4
 | Pace + Length | 30
 | Reliance on previous knowledge | 5
 | Healthcare Issues | 1
 | Covid 19 | 13
 | Healthcare Access | 2
 | Positive/Negative Trainer Feedback | 3
 | Trainers | 1
 | Covid 19 Provisions | 1
 | [NAME] | 1
 | Track tech | 2
 | content | 5
 | Tools Negative Feedback | 1
 | JIs | 1
 | Assessment | 1
 | Bn Staff | 3
 | Staffing | 1
 | Units | 3
 | Metalsmith | 1
 | Repair | 1
 | Handouts/Precise | 1
 | Tools | 1
 | Postive Feedback | 1
 | Future | 1
 | Pace + Length/Handouts/Precis | 1
 | Pace + Length/Equipment | 2
 | Learning | 1
 | Content/IT | 1
 | [NAME] | 1
 | Welding | 1
 | Pinzgauer Auto – | 1
 | Pinz & Feps Elect | 1
 | Hagglunds | 1
 | Electrics, Wheels & Tyres – Engine basic | 1
 | Transmission tech | 2
 | Heavy Engine | 1
 | Suspension Tech | 1
Course Total |  | 256
Course | Smartboards | 1
 | VLE | 3
 | Positive Trainer Feedback | 10
 | Negative Trainer Feedback | 1
 | Classroom | 2
 | Equipment | 1
 | Assignments | 3
 | Expectations | 1
 | Feedback | 1
 | Pre-Course Learning | 1
 | Facilities/library | 2
 | Modnet pcs | 1
 | Pace + Length | 3
 | Assessment | 1
 | Safe Exam Browser | 1
 | Bn Staff | 1
Course  Total |  | 33
General | Laptops | 1
 | Expectations | 3
 | Facilities | 1
 | Facilities/library | 2
 | Covid 19 | 3
 | Bn Staff | 1
 | [NAME] | 3
 | Waiting List | 1
General Total |  | 15
Grand Total |  | 363
Spreadsheet: 701233d1603639150-how-to-count-the-quantity-per-piece-and-box-quantity-ans
Sheet: Sheet1

 |  |  |  | sales |  | remaining |  | Your ans
 | P name | Pieces/box | Pur | box | pieces | box | pieces | box | pieces
 | P1 | 12 | 13 | 1 | 8 |  |  | 11 | 4
 | P2 | 4 | 15 | 3 | 5 |  |  | 11 | 1 | ?
 | P3 | 40 | 20 | 4 | 5 |  |  | 15 | 35
 | P4 | 32 | 2 | 1 | 0 |  |  | 1 | 0
Spreadsheet: 49614d1248969704-returning-multiple-values-excel-sample
Sheet: Master

Zone | Customer | Data | Set #1 | Set #2 | Set #3 | Set #4 | Set #5 | Set #6
Zone 1 | Crystal | Rate
 |  | Volume
Zone 1 | [NAME] | Rate
 |  | Volume
Zone 1 | Jordan | Rate
 |  | Volume
Zone 1 | Michelle | Rate
 |  | Volume
Zone 2 | Crystal | Rate
 |  | Volume
Zone 2 | [NAME] | Rate
 |  | Volume
Zone 2 | Jordan | Rate
 |  | Volume
Zone 2 | Michelle | Rate
 |  | Volume
Spreadsheet: 813470d1673800050-vlookup-2-condition-how-ask-formula-vlookups
Sheet: Sheet2

 |  |  |  | January-23 | % of all | Budget | % Spent | Spent | Funded | Released
Software |  |  |  | Left over
a | asdf |  |  | 14.07766990291262 | 0.004675262902392893 | 14.07766990291262 | 0 | 0
b | asdfg |  |  | 1240.814239482201 | 0.4693306192876887 | 1413.2 | 0 |  | n/a | 172.3857605177994
 | zxcv |  |  | 48.64317152103564 | 0.1376415239697612 | 414.4519741100324 | 0 |  |  | 365.8088025889967
Ex Rate | 14500
Spreadsheet: 44725d1243495951-excel-2007-macro-for-excel-table-corespondance-cells-tabel
Sheet: Sheet1

 | a | b | c | d | e | f
ion | 1 |  | 1 |  | 1
ana |  | 1 | 1 |  | 1
mihai
maria | 1 |  | 1 |  | 1 | 1
ion | a | c | e
ana | b | c | e
mihai
maria | a | c | e | f
Spreadsheet: 05566e31-18fe-46e5-955d-cf54c84a0c05
Sheet: Sheet1

Table 9--Factors used for animal unit calculations, 1/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Factor
Animal Types | GCAU | HPAU | RCAU | G&RCAU
Cattle
Dairy
Cows | 1.0475 | 1 | 1.0354 | 1.0397
[NAME] | 0.1761 | 1.3038 | 0.815 | 0.5662
Beef
Cattle on feed | 1.5323 | 0.5801 | 0.1585 | 0.686
Other | 0.0547 | 1.7216 | 0.7358 | 0.4729
Sheep | 0.0194 | 4.9195 | 0.1715 | 0.1078
Goats |  |  | 0.2301 | 0.0611
Horses and mules | 0.2043 |  | 0.3953 | 0.3197
Poultry
Layers | 0.0217 | 1.5896 | 0.0008 | 0.009
Broilers | 0.002 | 2.7932 |  | 0.0007
Pullets | 0.0054 | 3.3596 |  | 0.0021
Turkey | 0.0155 | 3.552 | 0.0011 | 0.0074
Hogs | 0.2285 | 1.2703 | 0.0294 | 0.1064
Source: USDA, Economic Research Service, and supporting materials.
Data run: 1/12/2013
Spreadsheet: 736486d1623679418-how-to-sumif-a-box-example-sum-box-2
Sheet: Sheet1

 |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 |  | Client | Type | Type 2
 |  | 1 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | b | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | b | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | c | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | c | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | c | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | c | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | c | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | c | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 1 | c | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | c | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 2 | c | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 | b | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 | b | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 | b | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 | b | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 | b | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 3 | b | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 | b | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 | b | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 4 | b | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 5 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 5 | a | R | x | x | x | x | x | x | x | x | x | x | x | x
 |  | 5 | a | N | x | x | x | x | x | x | x | x | x | x | x | x
 |  | Client | Type | Type 2
 |  | 2 | a | R
Spreadsheet: richard_sanders__31686__ICE Sale Calc
Sheet: GL-Tax

ICE DRILLING
Sale of assets
9/30/99
 |  | Gross |  |  |  | Total
 |  | @ 8/31/99 |  | @ 9/30/99
Cash Proceeds |  |  |  | 271646.86
Write off Loan |  | -9979591.85
Write off AIR |  |  |  | -3688.24
Write off BS FV Adj. |  | 1999996
Reverse FV Loss |  | -1999996
Write off Warrants and BS FV Adj. |  | 0
Total realized loss
Unrealized loss as of 6/30/99
3Q realized gain
Total realized loss at 8/31/99
Spreadsheet: 882162d1730406313-dynamic-drop-down-using-tables-henighanhome-copy
Sheet: Invoice Creator

 |  | Select Job to Invoice
 |  | Job-100004 - Cust No:100004 - Isobel  : - General House Improvements and fixes
 |  | Job Number | Customer Number | Total Cost |  | Customer Name | Invoice Date | Customer Address |  | Full Name and Address |  | Job Description
 |  | Job Tasks | Description |  |  | Materials |  | [NAME]) | Rate | Total
 |  |  | Remove cupboard
 |  | 2 | Remove panelling from door to bathroom |  |  | 0 |  | 0.8999999999999999
 |  | 3 | Repair ceiling lights in bathroom |  |  | 0 |  | 0.4
 |  | 4 | Fix lights, plant base, chairs. Make shelf. Fit toilet seat. |  |  | 0 |  | 0.8
 |  | 5 | Assemble IKEA table |  |  | 0 |  | 0.3
Spreadsheet: david_delainey__8072__Master Turbine Listing
Sheet: LM6000 Parts

LM 6000 GTG
 |  | Refrigeration | Inlet Air Heating |  |  | MV | MV | LV | LV |  | BOP | Fuel Oil | Fuel Oil | Fuel Gas | Instrument | S&S
Item # | Location | System | System | SCR | [NAME] | Transformers | Swgr | Transformers | Swgr | CEMS | PLC | Centrifuge | Storage Tanks | Compressors | Air Systems | Pkgs
1
2
3
4
5
6
7
8
9 | [NAME] | Y, Discount Possible | Y, Discount Possible | Y, Discount Possible | NEPCO | NEPCO | NEPCO | NEPCO | NEPCO | NEPCO | NEPCO | N/A | N/A | NEPCO | NEPCO | ?
10 | [NAME] | Y | Y | Y | N | N | N | N | N | N | N | N/A | N/A | N | N | ?
11 | [NAME] | Y | Y | Y | N | N | N | N | N | N | N | N/A | N/A | N | N | ?
12 | [NAME] | Y | Y | Y | N | N | N | N | N | N | N | N/A | N/A | N | N | ?
13
14
15
16
17 | Las Vegas | N | N
18 | Las Vegas | N | N
19 | Las Vegas | N | N
20 | Las Vegas | N | N
21
22
23
24
Spreadsheet: benjamin_rogers__1014__tasking letter deliverables 121799
Sheet: taskingletter

 |  | ENRON ENGINEERING & CONSTRUCTION TASKING LETTER
Customer Company Name |  |  | Enron North America |  | Date: | 1999-12-17 00:00:00
1. Project Name |  |  | Delmarva Project Due Diligence |  | Start Date: | 1999-12-17 00:00:00
 |  |  | 312 MW SCGT facility
2. Scope of work requested (Provide attachment if necessary):
 | see attached
 | Project is a 312  MW nominal rated SCGT located in Virginia
3. Cost Estimate:
 | (provide additional detail with attachment if necessary)
4. Completion Date: |  |  | 2000-03-31 00:00:00
 | (provide milestone(s) by attachment if necessary)
Estimate by:
 | EE&CC Development Engineer |  | [NAME] |  | Date:
 |  |  | print name
 | EE&CC Project Manager |  |  |  | Date:
 |  |  | print name
 | EE&CC Vice President [NAME] |  |  |  | Date:
 |  |  | signature
 | EE&CC VP Proj Dev Approval |  |  |  | Date:
 | (if estimate over $50,000) |  | signature
EE&CC Development Engineer Approval |  |  |  |  | Date:
 |  |  | Signature
EE&CC Project Manager [NAME] |  |  |  |  | Date:
 |  |  | Signature
Customer's Representative
 |  |  | Print Name
Customer's Approval |  |  |  |  | Date:
 |  |  | Signature
5. EE&CC Work Order Number:
Accounting Signature: |  |  |  |  | Date:
6. Tasking Letter Closure
 | Completed:
 | Cancelled:
 | Final Cost: |  |  |  | Date:
EE&CC Development Engineer |  |  |  |  | Date:
EE&CC Manager |  |  |  |  | Date:
Lead Developer |  |  |  |  | Date:
Spreadsheet: 876746d1723478402-pivot-table-second-column-sum-and-values-not-matching-work-progress-dated-12-aug-2024
Sheet: Delivery

MarkNo. | DO Qty | [NAME]. | Drawing wt, MT | ReceivedDate | Assembly Name
QLGF-C2001 | 1 | 1/1 |  | 2024-06-14 00:00:00
QLGF-C2002 | 1 | 1/2 |  | 2024-06-14 00:00:00
QLGF-C2002 | 1 | 2/2 |  | 2024-06-14 00:00:00
QLGF-C2003 | 1 | 1/1 |  | 2024-06-14 00:00:00
QLGF-BM2003 | 1 | 1/1 |  | 2024-06-15 00:00:00
QLGF-BM2004 | 1 | 1/1 | 205.7 | 2024-06-15 00:00:00
QLGF-HB2005 | 1 | 1/1 |  | 2024-06-17 00:00:00
QLGF-HB2009 | 1 | 1/1 |  | 2024-06-17 00:00:00
QL-1-VB2001 | 1 | 1/1 |  | 2024-06-17 00:00:00
QL-1-VB2002 | 1 | 1/1 |  | 2024-06-17 00:00:00
QL-1-BM2002 | 1 | 1/1 | 673.6 | 2024-06-17 00:00:00
QL-1-BM2003 | 1 | 1/1 |  | 2024-06-17 00:00:00
QL-1-BM2004 | 1 | 1/1 |  | 2024-06-17 00:00:00
QT1-CL1002 | 1 | 1/1 |  | 2024-06-17 00:00:00 | Not in Sheet1
QT1-CL1007 | 1 | 1/1 |  | 2024-06-17 00:00:00 | Not in Sheet1
Spreadsheet: richard_ring__31554__EEMC-CECAuditedAnnual-2000
Sheet: Schedule 2E

Annual Report to the California Energy Commission
for the year ending December 31, 2000
SCHEDULE 2E:  RETAIL SALES TO CUSTOMERS SUBJECT TO THE $1,000 FUNDING CAP
Applicable to:  Registered Renewable Providers (Customer Credit Program)
INSTRUCTIONS: Enter Information about sales to non-residential, non-small commercial customers who received the Customer Credit during the period of January 1, 2000 to December 31, 2000.  The data should agree with information reported in Box 7 of the Monthly Performance Reports (MPRs) submitted for the Customer Credit Subaccount.  If the data in this schedule does not agree with data reported in MPRs, attach a written explanation for the difference.
Check if you had NO sales to non-residential, non-small commercial customers
Customer ID #
Rate Schedule
CEC Reg # | Clean ChoiceTM 100 | Clean Choice BIZMIXSM
Eligible kWh Sold to Eligible Customers (kWh) |  |  |  |  | TOTAL (Box 7A)
2000-01-01 00:00:00 | 340526 | 0
2000-02-01 00:00:00 | 0 | 0
2000-03-01 00:00:00 | 67046 | 0
2000-04-01 00:00:00 | 56614 | 0
2000-05-01 00:00:00 | 53680 | 0
2000-06-01 00:00:00 | 31501 | 0
2000-07-01 00:00:00 | 47261 | 0
2000-08-01 00:00:00 | 36028 | 0
2000-09-01 00:00:00 | 31223 | 0
2000-10-01 00:00:00 | 27836 | 0
2000-11-01 00:00:00 | 14806 | 148198485
2000-12-01 00:00:00 | 8922 | 84557066
TOTAL
 |  |  |  |  |  |  |  | CEC Reg. #
Spreadsheet: phillip_m_love__30149__9908_OA
Sheet: EAST-CON-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM) / LRC
REGION:  SOUTHEAST
 |  |  | Total |  | Reclasses |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | July |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-EAST
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: b099dc30-b00b-43d7-b3bc-ea2ba8e02919
Sheet: Page 6

Permit No.: |  |  | WQ0000795 |  |  | Facility Name: |  | Surf City WWTF |  |  |  |  |  | County: | Onslow |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | E |  | Field Name: |  | F |  | Field Name: |  | G |  | Field Name: |  | H
 |  |  |  |  |  | Area (acres): |  | 14.05 |  | Area (acres): |  | 11.6 |  | Area (acres): |  | 14.85 |  | Area (acres): |  | 14.2
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  | 0.6 |  | [NAME] (in): |  | 0.6
 |  |  |  |  |  | Annual Rate (in): |  | 32.3 |  | Annual Rate (in): |  | 32.3 |  | Annual Rate (in): |  | 32.3 |  | Annual Rate (in): |  | 32.3
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 734474d1622190708-match-data-in-one-column-to-another-but-must-keep-links-on-same-line-for-original-column-tools
Sheet: Sheet1

 |  |  |  | Loaned out | Returned | Last loan | last return |  |  |  | loans and returns
Barcode | Item | information1 | information 2
a |  |  |  |  |  |  |  |  |  |  | date | barcode | Loaned | Returned
b |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | a | 1
c |  |  |  |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | b | 1
d |  |  |  |  |  |  |  |  |  |  | 2021-02-02 00:00:00 | a |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2021-02-04 00:00:00 | c | 1
 |  |  |  |  |  |  |  |  |  |  | 2021-03-05 00:00:00 | d | 1
 |  |  |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | a | 1
 |  |  |  |  |  |  |  |  |  |  | 2021-05-03 00:00:00 | d |  | 1
 |  |  |  |  |  |  |  |  |  |  | 2021-05-10 00:00:00 | d | 1
 |  |  |  |  |  |  |  |  |  |  | 2021-04-07 00:00:00 | a |  | 1
Spreadsheet: 329512d1404325980-highlight-a-result-depending-on-another-range-of-values-conditional-formattingvalues
Sheet: Sheet1

Measure | Result |  |  |  |  |  |  | Your Range | Range | Value
800 | 46 | (red) |  |  |  |  |  | 1-1000 | 1 | 45
7539 | 100 | (green) |  |  |  |  |  | 1001-3000 | 1001 | 70
3010 | 81 | (green) | <--- Why do you want green here? |  |  |  |  | 3001-5000 | 3001 | 80
13714 | 92.66 | (green) |  |  |  |  |  | Over 5000 | 5001 | 100
4500 | 82 | (red)