tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 781050d1652958484-lookup-value-in-nth-occurence-without-using-arrays-with-multiple-criteria-vloookup-nth-occurence-aligw
Sheet: VLOOOKUP Nth OCCURENCE

 | DATA |  |  | OUTPUT
 | Emp ID | REMARK |  | Emp ID | REMARK
 | 100 |  |  | 100 |  | Using VLOOKUP this will give blank results so how do we get the first Text Value ignoring BLANK and " " Values in the cells
 | 100 |  |  | 200
 | 100 | A |  | 300
 | 100
 | 100
 | 200 | B
 | 200
 | 200
 | 300
 | 300
 | 300
 | 300 | C
Spreadsheet: 837140d1689876186-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-2
Sheet: MAPPING

Path: |  |  |  | A | B | C | D | E | F | G | H
Last Raw |  |  |  |  |  |  |  |  |  |  |  | Path2Price | REAL |  |  |  |  |  | So in the column N, I have the formula I want but its not dynamic. I wish to make it spill depending on the column size like the rest of the functions.
Size
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So in the column O and P, I also have the formula I want but its not dynamic. The same way, I wish to make it spill depending on the column size like the rest of the functions.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In R I have the formula I thought would work for column N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If You put London in Analysis, it adds [NAME] but if u put Paris, there is only [NAME] and [NAME], that why I want it to be dynamic.
Spreadsheet: tracy_geaccone__40225__enron corp infomation request
Sheet: EGS IS

 |  | September
Gross Margin by Business Unit |  | Year-to-Date
ETS
EGAS
PGE
EOTT
EREC
Azurix/Wessex
EEOS
Other
Total Gross Margin
Operating Expenses |  | 0
Depreciation and Amortization |  | 0
Taxes Other Than Income |  | 0
Other Income (Loss) |  | 0
Income / (Loss) Before Interest & Taxes
(3)
Spreadsheet: 64257d1265132910-search-tabs-and-return-results-kc-environmental-aspects-and-impacts-worksheet-questions
Sheet: Process - Activity 12

Operating Condition | Process Evaluated |  | Date |  |  |  |  | Team
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
 |  |  |  |  | 0 | 0
Spreadsheet: 4764fb13-e4c9-4a2b-a948-707acf610172
Sheet: Sheet1

Unnamed: 0 | Permit No.: | Unnamed: 2 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | County: | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Month: | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type:
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied | Average  Concentration | Monthly  Load | Cumulative  Load | Volume Applied | Average  Concentration | Monthly  Load | Cumulative  Load | Volume Applied | Average  Concentration | Monthly  Load | Cumulative  Load | Volume Applied | Average  Concentration | Monthly  Load | Cumulative  Load | Volume Applied | Average  Concentration | Monthly  Load | Cumulative  Load
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
 | 12 Month Floating  Load (lbs/ac/yr):
 | Annual  [NAME] (lbs/ac/yr):
Spreadsheet: 770081d1645801834-naming-manager-duplication-causing-issues-help-version-temp-fix-25th-feb
Sheet: Empire

 | RACE | Empire |  |  | Total Pts |  |  |  |  |  | ARMY NAME
 | CHARACTERS
 | Unit/s |  |  | Points | Unit size | M | WS | BS | S | T | W | I | A | LD | Default Equipment | Weapons | Pts | Weapons | Pts | [NAME] | Pts | [NAME] | Pts | Mount | Pts | Magic Items | Pts | Misc/Notes | Pts | Gear Total | Total Pts
 | General |  |  |  | 1
 | [NAME] |  |  |  | 1
Spreadsheet: 890218d1741515286-populating-cells-using-paste-special-populating-cells-using-paste-special
Sheet: Sheet1

Problem - I require the company name to be populated in column B, but they are blank. However, the company name is actually in column C above the invoice numbers. | INCORRECT LAYOUT |  |  |  |  | CORRECT LAYOUT
 |  | Company 1 |  |  |  |  | Company 1
 |  | Inv Date |  |  |  |  | Inv Date
 |  | 2025-01-01 00:00:00 |  |  |  | Company 1 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 1 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 1 | 2025-01-01 00:00:00
 |  | Company 2 |  |  |  |  | Company 2
 |  | Inv Date |  |  |  |  | Inv Date
 |  | 2025-01-01 00:00:00 |  |  |  | Company 2 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 2 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 2 | 2025-01-01 00:00:00
 |  | Company 3 |  |  |  |  | Company 3
 |  | Inv Date |  |  |  |  | Inv Date
 |  | 2025-01-01 00:00:00 |  |  |  | Company 3 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 3 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 3 | 2025-01-01 00:00:00
 |  | Company 4 |  |  |  |  | Company 4
 |  | Inv Date |  |  |  |  | Inv Date
 |  | 2025-01-01 00:00:00 |  |  |  | Company 4 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 4 | 2025-01-01 00:00:00
 |  | Company 5 |  |  |  |  | Company 5
 |  | Inv Date |  |  |  |  | Inv Date
 |  | 2025-01-01 00:00:00 |  |  |  | Company 5 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 5 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 5 | 2025-01-01 00:00:00
 |  | Company 6 |  |  |  |  | Company 6
 |  | Inv Date |  |  |  |  | Inv Date
 |  | 2025-01-01 00:00:00 |  |  |  | Company 6 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 6 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 6 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 6 | 2025-01-01 00:00:00
 |  | Company 7 |  |  |  |  | Company 7
 |  | Inv Date |  |  |  |  | Inv Date
 |  | 2025-01-01 00:00:00 |  |  |  | Company 7 | 2025-01-01 00:00:00
 |  | 2025-01-01 00:00:00 |  |  |  | Company 7 | 2025-01-01 00:00:00
Spreadsheet: 167756d1342094318-payroll-calculations-using-a-sortable-table-sample_payroll
Sheet: Sheet1

Employee | Rate | Date | Start Time | End Time | Payouts | Hours | Grand Total
[NAME] | 10 | 2012-06-29 00:00:00 | 09:00:00 | 17:00:00 | 0
[NAME] | 10 | 2012-06-30 00:00:00 | 09:00:00 | 13:00:00 | 0
[NAME] | 10 | 2012-07-01 00:00:00 | 00:00:00 | 00:00:00 | 0
[NAME] | 10 | 2012-07-01 00:00:00 | 16:00:00 | 20:00:00 | 0
[NAME] | 10 | 2012-07-02 00:00:00 | 09:00:00 | 17:00:00 | 0
[NAME] | 10 | 2012-07-03 00:00:00 | 09:00:00 | 17:00:00 | 0
[NAME] | 10 | 2012-07-04 00:00:00 | 09:00:00 | 17:00:00 | 0
[NAME] | 10 | 2012-07-05 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-06-29 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-06-30 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-01 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-02 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-03 00:00:00 | 09:00:00 | 17:00:00 | 0
Sophia R | 9.5 | 2012-07-04 00:00:00 | 00:00:00 | 00:00:00 | 0
Sophia R | 9.5 | 2012-07-05 00:00:00 | 09:00:00 | 17:00:00 | 0
Spreadsheet: 83269d1283277552-sorting-book1
Sheet: Sheet1

Fred | Man |  |  |  |  | 1
Barney | Man |  |  |  |  | 2
Wilma | Woman |  |  |  |  | 3
Betty | Woman |  |  |  |  | 4
After sorting Columns A & B, Columns E & F will match up but not Col G
Data that will be sorted |  |  |  | Data is tied into original list |  |  |  | I need these rows to always line up with original in Col E
Spreadsheet: 90386d1290113751-excel-2007-need-to-count-add-records-values-in-a-date-range-forecast
Sheet: Sheet2

Week Ending | Orders | Books | Pages | Sheets | [NAME] | Total Sheets
2010-03-12 00:00:00
2010-03-19 00:00:00
2010-03-26 00:00:00
2010-04-02 00:00:00
2010-04-09 00:00:00
2010-04-16 00:00:00
2010-04-23 00:00:00
2010-04-30 00:00:00
2010-05-07 00:00:00
2010-05-14 00:00:00
2010-05-21 00:00:00
2010-05-28 00:00:00
2010-06-04 00:00:00
2010-06-11 00:00:00
2010-06-18 00:00:00
2010-06-25 00:00:00
2010-07-02 00:00:00
2010-07-09 00:00:00
2010-07-16 00:00:00
2010-07-23 00:00:00
2010-07-30 00:00:00
2010-08-06 00:00:00
2010-08-13 00:00:00
2010-08-20 00:00:00
2010-08-27 00:00:00
2010-09-03 00:00:00
2010-09-10 00:00:00
2010-09-17 00:00:00
2010-09-24 00:00:00
2010-10-01 00:00:00
Spreadsheet: 33561d1230028362-copying-problem-example-1-
Sheet: Sheet1

1
2
3
4
5
6 | *
7
8
9
10
11 | *
12
13 | *
14
15
16
17
18
19
20
21
22
23
24 | *
Spreadsheet: 122056d1316591692-return-column-numbers-based-on-values-example
Sheet: Sheet1

Jan | Feb | Mar | Apr | Mai | Jun | Jul | Aug
 |  | 2775000 |  |  |  |  | 4625000 |  | 3 |  |  |  |  | 8
 |  | 1230000 |  |  | 2050000 |  | 2050000 |  | 3 |  |  | 6 |  | 8
 |  |  | 347433.6 |  | 579056 | 579056 |  |  |  | 4 |  | 6 | 7
 |  |  |  | 1865736 | 3109560 | 3109560 |  |  |  |  | 5 | 6 | 7
 |  |  |  | 575000 | 575000 | 575000 |  |  |  |  | 5 | 6 | 7
 |  |  |  | 120000
 |  |  | 660000 |  |  |  |  |  |  | 4
 |  |  |  | 550000 |  | 2475000 |  |  |  |  | 5 |  | 7
Spreadsheet: sally_beck__33737__MgmtSum-Q3-0728
Sheet: YTD Mgmt Summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  | YTD 2000 EARNINGS ESTIMATE
 |  | Margin |  |  |  | Expenses |  |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan* | [NAME] |  |  | Forecast | Plan | [NAME]
 |  |  |  |  |  |  |  | [NAME] | Cash Exp
Gas Trading
Texas Trading
Power Trading
Financial Drift
Financial Trading
Canada Trading
Coal-Trading
GRM -  Weather
Emissions (Coal)
Total Trading & Risk Mgt. |  |  |  |  | 129970
East Midstream
West Midstream
Industrial Downstream
Generation Investments/IPP
Coal Origination & Finance
Canada Origination & Finance
ENA Upstream Assets
HPL
LRC
GRM - New Products
Mexico
Total Origination |  |  |  |  | 0
Principal Investing
Energy Capital Services
CTG Assets
Total Investing
Commercial Transactions Group
Office of the Chairman
Overview
Total Commercial
Group Total
Group Allocated to Teams
Other Interest Related Charges
Capital Charge Offset
ENA EBIT
Interest Expense/(Income)
[NAME]
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 674156d1587678161-help-with-trading-log-file-index-match-and-counts-2020-04-23-oeldere-pt-start-674153d1587677110-help-with-trading-log-file-index-match-and-co
Sheet: Summary

 | Date | Day | # Trades | Wins | Losses | Win % | $ Result | % Result
 | 2020-04-16 00:00:00 | Thursday | 1 | 2 | 1 | 2 | -258
 | 2020-04-17 00:00:00 | Friday | 1 | 1 | 0 | 1 | 441
 | 2020-04-20 00:00:00 | Monday
 |  | Rijlabels | Aantal van criteria | Som van Profit/Loss
 |  | 2020-04-16 00:00:00 | 3 | -258
 |  | loose | 1 | -276
 |  | win | 2 | 18
 |  | 2020-04-17 00:00:00 | 1 | 441
 |  | win | 1 | 441
 |  | 2020-04-20 00:00:00 | 2 | 1332
 |  | win | 2 | 1332
 |  | Eindtotaal | 6 | 1515
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Electronics Certs 1

ELECTRONICS
Certificates
Student Name:
ID #
Electronics Tester | Semester | Grade
___ ELT 110 (5) Circuits I
___ ELT 114 (5) Circuits II
___ ELT 120 (3) Digital I
Electronics Technician
___ ELT 110 (5) Circuits I
___ ELT 114 (5) Circuits II
___ ELT 210 (4) Devices I
___ ELT 214 (4) Devices II
___ ELT 120 (3) Digital I
___ ELT 220 (3) Digital II
[NAME]
___ CAD 100 (3) Introduction to Computer Aided Drafting & Design
OR Equivalent course with consent of Program Coordinator
___ ELT 110 (5) Circuits I
___ ELT 114 (5) Circuits II
___ ELT 265 (3) Applied Fluid Power
___ ELT 244 (4) Electrical Machinery and Controls
OR ___ EET 270 (2) Electrical Motor Controls I AND ___ EET 271Electrical Motor Controls I Lab
___ ELT 250 (4) Programmable Logic Controllers
OR ___ ELT 276 (2) Programmable Logic Controllers
AND ___ ELT 277 (2) Programmable Logic Controllers
Robotics and Automation Technician
___ ELT 110 (5) Circuits I
___ ELT 114 (5) Circuits II
___ ELT 210 (4) Devices I
___ ELT 120 (3) Digital I
___ ELT 118 (3 ) Manufacturing III, Computer Numerical Control
OR ___ CMM 132 (3) CAD/CAM/CNC
___ ELT 265 (3) Applied Fluid Power
___ ELT 260 (5) Robotics and Industrial Automation
___ ELT 244 (4) Electrical Machinery and Controls
OR ___ EET 270 (2) Electrical Motor Controls I
AND ___ EET 271 (2) Electrical Motor Controls I Lab
___ ELT 250 (4) Programmable Logic Controllers
OR ___ EET 276 (2) Programmable Logic Controllers
AND ___ EET 277 (2) Programmable Logic Controllers
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 111018d1307540707-sorting-columns-to-remove-blanks-on-1-column-matching-with-other-columns-arraysortingproblem
Sheet: Sheet1

a | a | 1 | 1 |  | a | 1 | 6 |  | a | 1 | 6
 | b |  | 2 |  |  |  |  |  | b | 2 | 0
b | c | 2 | 3 |  | b | 2 |  |  | c | 3 | 7
c | d | 3 | 4 |  | c | 3 | 7 |  | d | 4 | 0
d | e | 4 | 5 |  | d | 4 |  |  | e | 5 | 8
 | #N/A |  | #N/A |  |  |  |  |  | #N/A | #N/A | #N/A
e | #N/A | 5 | #N/A |  | e | 5 | 8 |  | #N/A | #N/A | #N/A
5
Spreadsheet: 144a78d9-4524-43c4-a49b-9f810a056f05
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Marketing, Sales and Service: Professional Sales and Marketing
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Professional Sales and Marketing Pathway of the Marketing, Sales and Service [NAME]) can serve as a guide, along with other career planning materials, as
learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used
for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for        Professional Sales and Marketing Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | ►Account Executive ►Administrative Support Representative ►Agent ►Broker ►Business Development Manager ►Channel Sales Manager ►Client Relationship Manager ►Customer Service Representative ►Field Marketing Representative ►Field Representative ►Inbound Call Manager ►Industrial Sales Representative ►Key Account Manager ►Manufacturer’s Representative ►National Account Manager ►Outside Sales Representative ►Regional Sales Manager ►Retail Sales Specialist ►Sales Engineer ►Sales Executive ►Sales Person ►Sales/Marketing Associate ►Solutions Advisor ►Technical Sales Specialist ►Telemarketer ►Territory Representative/ Manager
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: phillip_m_love__30155__9902_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | 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 | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34244 | 91649 | 34244 | 91649
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -34244 | -91649 | -34244 | -91649
7 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
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 |  |  |  |  |  |  |  |  |  |  |  | -1485484
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
Spreadsheet: 837530d1690216754-use-text-result-in-one-cell-as-formula-for-another-textformula
Sheet: Sheet1

Worksheet | Cell
Order Entry | A1
Order Entry | A2
Order Entry | A3
Spreadsheet: 27687d1221139039-advanced-conditional-formatting-sample-
Sheet: Tracker

Agent Name | Time | Date | [NAME] | Issue | Department | Model No. | Contact Number
[NAME] | 16:19:14 | 2008-09-11 00:00:00 | George | leave
Vincent | 17:35:16 | 2008-08-29 00:00:00 | [NAME] | sale | sales
 | Example 2
Vincent | 16:27:12 | 2008-09-11 00:00:00 | [NAME] | Sales | Sales
Spreadsheet: kimberly_watson__20543__sharris0901wk1
Sheet: Current Est Vs. Forecast

Transwestern Pipeline Company
($[NAME])
Current Estimate vs. Forecast
 |  | 2nd Current | Weekly
 |  | Estimate | Forecast | [NAME] |  | Comments
West Demand Revenues |  |  |  |  |  | USGT $0K,  Astra $0K Negotiated Rate
West Commodity Revenues |  |  |  |  |  | Lower Volumes; IT backhaul deals $14K
East Demand Revenues
East Commodity Revenues
[NAME] |  |  |  |  |  | Reliant $2K
[NAME] Revenues
PNR Revenues |  | 0
Revenue Variance
Fuel Price [NAME] |  |  |  |  |  | MTD index price of $1.95 vs. 2nd CE index price of $3.34
Fuel Volume Variance-Unhedged |  |  |  |  |  | Lower retained volumes
Sales Margin Variance on Unhedged |  |  |  |  |  | No over-retained fuel sales for September
Hedging Adjustment
Other Adjustment |  | 0.001
Fuel Variance (Excludes UAF)
Current Month Variance
Reserve |  | 0 | 0
Adjusted Current Month Variance
August 31, Weekly |  | 16.284 | 17.085
July 31, 2001 Actuals |  | 17.126 | 17.011
June 30, 2001 Actuals |  | 17.127 | 17.127
May 31, 2001 Actuals |  | 19.008 | 19.008
April 30, 2001 Actuals |  | 17.829 | 17.829
March 31, 2001(Q 1) Y T D |  | 53.403 | 53.403
August 31,2001 YTD
Spreadsheet: kevin_presto__20238__EIA411 Reporting Forms Revised 01 30 02
Sheet: Report - Schedule 1

U. S. Department of Energy Energy Information Administration Form EIA-411 (2001) |  |  |  |  |  | Coordinated Bulk Power Supply Program Report |  |  |  | Form Approved OMB No. 1905-0129 Approval Expires 11/30/04
Reporting Period: As of January 1, 2002
Council: |  | SERC
Reporting Party:
Reporting Party EIA Code:
SCHEDULE 1. PART A. HISTORICAL AND PROJECTED PEAK DEMAND AND ENERGY - MONTHLY
Line Number |  | Actual Data - 2001
 |  | Units | January | February | March | April | May | June | July | August | September | October | November | December
01 | Peak Hour Demand | MW
02 | Net Energy | [NAME]
 |  | Reporting Year Forecast (2002)
 |  |  | January | February | March | April | May | June | July | August | September | October | November | December
03 | Peak Hour Demand | MW
04 | Net Energy | [NAME]
 |  | Next Year Forecast (2003)
 |  |  | January | February | March | April | May | June | July | August | September | October | November | December
05 | Peak Hour Demand | MW
06 | Net Energy | [NAME]
SCHEDULE 1. PART B. HISTORICAL AND PROJECTED PEAK DEMAND AND ENERGY - ANNUAL
Line Number |  | ACTUAL | PROJECTED
 |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
07 | Summer Peak Hour Demand, June - September (Megawatts)
 |  | 2001/02 | 2002/03 | 2003/04 | 2004/05 | 2005/06 | 2006/07 | 2007/08 | 2008/09 | 2009/10 | 2010/11 | 2011/12
08 | [NAME] Hour Demand, December - March (Megawatts)
 |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
09 | Net Annual Energy (1000s of Megawatthours)
Spreadsheet: f3589e74-c5f4-44f4-8265-b5677e97e5a3
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
BRUC | Test | BRUC | Brucella Culture | Brucella Culture | Conventional Culture Technique | Sterile transport container: StlTrans |  |  |  |  | Specimen source is required.  Submit only 1 of the following specimens:   Preferred: [NAME] marrow Container/Tube: Sterile container [NAME]: 1 mL Specimen Stability Information: Ambient  Alternate: [NAME], respiratory specimen, spinal fluid, sterile body fluid, or tissue Container/Tube: Sterile container	 [NAME]: 1 mL Specimen Stability Information: Refrigerated |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Negative (reported as positive or negative) | Monday, Wednesday, Friday | 14 days | 17 days | 1 | 87081 |  |  |  |  | Rochester
BRUC | [NAME] | VARIES | Varies |  |  |  | See instructions
BRUC | Order Question | Q00M0009 | [NAME] |  | Plain Text
BRUC | Result | BRUC | Brucella Culture | Brucella Culture | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process