tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0b2874e7-f1ed-4e5c-8d6b-73b94a9fd916
Sheet: Sheet1

NAME:___________________________________ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | ADVISOR:______________________DATE:________ | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME] | HRS | GR | SEM | DEAF EDUCATION | HRS | GR | SEM
CORE: |  |  |  | LANGUAGE
ENGL 1033 Exposition & Argument | 3 |  |  | CDDE 1003  ASL I | 3
FS 1973  First Seminar | 3 |  |  | CDDE 1013  ASL II | 3
AS 1001  The College Experience | 1 |  |  | CDDE 2003  ASL III | 3
 |  |  |  | CDDE 2013  ASL IV | 3
BLOCK 1
Aesthetic Inquiry and Creative Exp |  |  |  | FOUNDATIONS OF DEAF EDUCATION
EDUC 3103 Children's Literature | 3 |  |  | CDSP 2023  Normal Language Deve | 3
Elective: | 3 |  |  | CDDE 2033  Intro to Deaf Education | 3
 |  |  |  | CDDE 2383  Deaf History & Culture | 3
BLOCK II |  |  |  | CDDE 3203  Intro to Audiology | 3
Historical and Social Interpretation |  |  |  | CDDE 4313  Language Deve D/HH | 3
POL 2053  Governing Ideas in America | 3
HIST 2503  American Republic | 3 |  |  | METHODS COURSES
Elective: | 3 |  |  | CDDE 4073  Audiologic Rehabilitation | 3
Elective: | 3 |  |  | CDDE 4333  Literacy Dev in D/HH | 3
 |  |  |  | CDDE 4353  Auditory Options for D/HH | 3
BLOCK III |  |  |  | CDDE 4343  Methods of Teaching  D/HH | 3
Scientific Investigation*
BIOLOGY Elective: | 3 |  |  | PRACTICUM COURSES
PHYSICS Elective: | 3 |  |  | CDDE 3181  Deaf Educ Practicum I | 1
GEOLOGY Elective: | 3 |  |  | CDDE 3281  Deaf Educ Practicum II | 1
CHEM 4153 Standards Based Chemistry | 3 |  |  | CDDE 3381  Deaf Educ Practicum III | 1
Science Lab* | 1
 |  |  |  | PROFESSIONAL EDUCATION COURSES
MATHEMATICS** |  |  |  | EDUC  1101  Intro to Education | 1
MATH 1053/1093/1103 | 3 |  |  | EDUC  2103  Foundations of Education | 3
MATH 1083 Contemporary Math | 3 |  |  | EDUC  3713  Child/Adol Development | 3
MATH 4373 Concepts & Reasoning | 3 |  |  | EDUC  3733  Measurement & Eval in Educ | 3
SOC OR PSY 2023  Social Science Stats | 3 |  |  | EDUC  4013  Educ of Exceptional Children | 3
 |  |  |  | EDUC 3171   [NAME] for Instructors | 1
[NAME] | 50
TU requires that two courses must be taken that meet the |  |  |  | STUDENT TEACHING
cultural diversity/gender studies requirement. |  |  |  | CDDE 4516  Deaf Educ Elem Student Teaching | 6
The state of OK requires 4 math and 4 sciences courses. |  |  |  | CDDE 4536  Deaf Educ Sec Student Teaching | 6
* TU requires at least one science lab. |  |  |  | EDUC 4971  Student Teaching Seminar | 1
*May be taken simultaneously |  |  |  | CDDE 4971 Study at Gallaudet | 1
 |  |  |  | DEAF EDUCATION HOURS | 70
CED AREA OF CONCENTRATION
Check one:     ___ [NAME]         ___ Secondary Educ
SECONDARY CONTENT AREA________________ |  |  |  | ELEMENTARY EDUCATION METHODS COURSES
EDUC 4214  Teaching Mid/Sec Sch Methods | 3 |  |  | EDUC 4143  Social Studies for Elem Child | 3
___________________________ | 3 |  |  | EDUC 4123  Science for Elem Child | 3
___________________________ | 3 |  |  | EDUC 4133  Math for Elem Sch Children | 3
____________________ |  |  |  | ________________________________
 |  |  |  | TOTAL HOURS | 129
2010-11-04 00:00:00
Spreadsheet: 774156d1648243889-identify-records-with-specific-condition-test11
Sheet: Sheet1

ID | Code | Status | Logins | Expected | Formula 1 | Formula 2
253071690049 | Blue | Active | 2
566369030103 | Green | Active | 0
566369030103 | Blue | Active | 0
566369030103 | Orange | Inactive | 0
566369030103 | Purple | Active | 16
560122395105 | Blue | Active | 0
560122395105 | Green | Active | 0
560122395105 | Purple | Active | 7
560122395105 | Orange | Active | 2
558415928107 | Pink | Active | 0 | Never
558415928107 | Turquoise | Active | 0 | Never
558415928107 | Bergundy | Active | 0 | Never
558415928107 | Red | Active | 0 | Never
558415928107 | None | Active | 0 | Never
558415928107 | White | Active | 0 | Never
558415928107 | Blue | Active | 0 | Never
558415928107 | Black | Active | 0 | Never
558415928107 | Grey | Active | 0 | Never
579036465109 | Duck | Active | 1
579036465109 | Red | Active | 334
766862153562 | Green | Active | 0 | Never
211522904047 | Red | Inactive | 180
576541679105 | Blue | Inactive | 27
576541679105 | Green | Inactive | 575
Spreadsheet: 777472d1650402793-sum-is-off-by-01-according-to-calculator-sheet-shared-1
Sheet: Pricing (2)

not correct off by -.01
 |  |  |  |  |  |  |  | ns | gs | [NAME] | grw
[NAME] | 3.65 | Waste Factor | 1.6
Thickness | 2
[NAME] | 8 |  |  |  |  |  |  |  | Thickness * Width
Margin | 0.65 |  |  |  |  |  |  |  | Margin * Total Footage / Footage A mplus (calculator in mind)
Set up | 100
Run Charge | 0.55 | Other |  |  |  |  |  |  | Set up / Footage A
Knife Charge | 90 | K Width | 6.5 |  |  |  | [NAME] |  | Run charge
Freight Charge | 0.75 | Freight Cost |  |  |  |  |  |  | other run charge
[NAME] | Glue |  | 0.55 |  | list all items used to calculate this total |  |  |  | determining factor for run charge
Footage A | 800 |  |  |  |  |  |  |  | knife charge * kwidth +0.5 / footage A
Footage + | 30 |  |  |  |  |  |  |  | freight charge / .75 /  total footage
Total footage |  |  |  |  |  |  |  |  | freight charge
Sub total |  |  |  |  | 0 |  |  |  | determing cell for freight
Cells with boxes have drop downs all others are fillable |  |  |  |  | 0
Sell Price |  |  |  |  |  |  |  |  | SUM(G3*I5) |  | cost * (thickness* width)
 |  |  |  |  |  |  |  |  | SUM(I17/12) |  | cost * (thickness* width) /12
 |  |  |  |  |  |  |  |  | sum I18/margin |  | cost * (thickness * width) / 12 / margin
 |  |  |  |  |  |  |  |  | I19*total footage |  | cost * (thickness * width) / 12 / margin * total footage
 |  |  |  |  |  |  | base cost |  | i20/footage a |  | cost * (thickness * width) / 12 / margin * total footage / footage a
 |  |  |  |  |  |  |  |  | base cost not rounded
 |  |  |  |  |  |  |  |  | net strip cost sell based on brian numbers |  |  |  | I21  + I8 + I11 + I12 + I15 + D11
Enter footage in cell B12 and enter the additional footage in B13. All cells require input that effect the formulas. There are dropdowns for each category that require you to select one or input their own info. Each blank field with a box outline needs to be filled or left blank
Spreadsheet: 145501d1331626441-help-required-in-stacked-column-bar-chart-graph-1-
Sheet: graph

Date | Overall | DT | NB
2012-03-01 00:00:00 | 8000 | 4000 | 4000
2012-03-02 00:00:00 | 6000 | 3000 | 3000
2012-03-03 00:00:00 | 4000 | 2000 | 2000
2012-03-04 00:00:00 | 10000 | 5000 | 5000
2012-03-05 00:00:00 | 15000 | 7500 | 7500
2012-03-06 00:00:00 | 8000 | 4000 | 4000
2012-03-07 00:00:00 | 7000 | 3500 | 3500
2012-03-08 00:00:00 | 10000 | 5000 | 5000
2012-03-09 00:00:00 | 4000 | 2000 | 2000
2012-03-10 00:00:00 | 26000 | 13000 | 13000
 |  |  |  | I want the graph to be updated as shown in the expected Graph. I want the Split of the Bar & a unique Bar for Overall as Graph.
Date |  | Overall | DT | NB
2012-03-01 00:00:00 |  |  | 4000 | 4000
 |  | 8000
2012-03-02 00:00:00 |  |  | 3000 | 3000
 |  | 6000
2012-03-03 00:00:00 |  |  | 2000 | 2000
 |  | 4000
2012-03-04 00:00:00 |  |  | 5000 | 5000
 |  | 10000
2012-03-05 00:00:00 |  |  | 7500 | 7500
 |  | 15000
2012-03-06 00:00:00 |  |  | 4000 | 4000
 |  | 8000
2012-03-07 00:00:00 |  |  | 3500 | 3500
 |  | 7000
2012-03-08 00:00:00 |  |  | 5000 | 5000
 |  | 10000
2012-03-09 00:00:00 |  |  | 2000 | 2000
 |  | 4000
2012-03-10 00:00:00 |  |  | 13000 | 13000
 |  | 26000
Spreadsheet: 44862d1243598966-formula-to-calculate-sales-projection-for-the-coming-months-sales-projection
Sheet: Sheet1

 | January | February | March | April | May | June | July
Sales Target | 3000 | 3000 | 4000 | 3600 | 4000
Achieved Sales | 2500 | 1800 | 2500 | 1500 | 3800
[NAME] | -500 | -1200 | -1500 | -2100 | -200 | 0 | 0
# of people that were called to acquire sales | 9000 | 8000 | 9200 | 6900 | 7250
Working Days | 20 | 19 | 20 | 21 | 21 | 20 | 20
Number of Agents | 60
Working Days | 20
Average Sales per agent per month | 68
Average Records used per agent per month | 140
Projected sales for June
Spreadsheet: 493895d1481932176-filtering-combined-items-within-a-given-set-of-rows-in-pivot-table-copy-of-sample-workbook-2
Sheet: Source Table

EMP NAME | DATE | Week Num | Week count | DESCR | HOURS | RATE | AMT | DESCR 2 | All Breaks | Paid | ADJ HOURS | Average Pay | PAY PERIOD
[NAME] | 2012-07-02 00:00:00 |  |  | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 |  |  | Hourly | 0 | 0.28 | 9.24 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 |  |  | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-03 00:00:00 |  |  | Hourly | 9 | 8 | 64 |  | 1.33 |  |  | 9.34419817470665
[NAME] | 2012-07-05 00:00:00 |  |  | Hourly | 2 | 0.28 | 10.08 |  | 0 |  |  | 0
[NAME] 2 | 2012-07-02 00:00:00 |  |  | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] 2 | 2012-07-02 00:00:00 |  |  | Hourly | 0 | 0.28 | 12.6 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 |  |  | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 |  |  | Piece Rate | 0 | 0.28 | 8.4 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 |  |  | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 |  |  | Piece Rate | 0 | 0.28 | 12.6 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 |  |  | Salary | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 |  |  | Piece Rate | 0 | 0.28 | 8.96 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 |  |  | Salary | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 |  |  | Salary | 0 | 0.28 | 10.36 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 |  |  | Piece Rate | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 |  |  | Piece Rate | 0 | 0.28 | 7.28 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 |  |  | Salary | 0 | 0.28 | 10.36 |  | 0 |  |  | 0
[NAME] | 2012-07-04 00:00:00 |  |  | Salary | 0 | 0.28 | 10.36 |  | 0 |  |  | 0
Spreadsheet: 63157d1264098381-excel-formula-help-for-finding-and-extracting-data-forumhelp
Sheet: Sheet1

a | b | c | d
[NAME] | hinge | [NAME] | n-6
[NAME] | latch | pull | a-1
hinge | catch | roller | [NAME]
catch | pull | catch | n-1
hinge | pull | [NAME] | n-4
hinge | [NAME] | pull | f-7
n
Spreadsheet: 726157d1617087131-select-a-cell-from-a-list-of-100-cells-example-2
Sheet: INPUT

 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
 | x
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Virginia "Ginny" Lyons

Virginia "Ginny" Lyons
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
How the fair share is determined needs to be clarified- An inclusive, collaborative process will help move this forward.
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
The budgetary consequences of not doing this is that the state would be in significant financial difficulty. People who
have expectations need to be provided for. Statutes should be considered as legally binding. Not funding is simply not an option.
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
As the Health care program is developed we should reassure folks that their access to health care is secure. However one explicit goal of reform is to
remove health care from conditions of employment. Finding the balance between employment benefits and  having health care access regardless of how
or where one is employed will be an ongoing challenge. The transition to the new system of portable health care should include opportunities for
consideration of these important issues.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
Teaching currently attracts high caliber folks. Unfortunately this is not always recognized and these teachers may move on to other endeavors. We need
to listen to what they say about their experiences and improve the teaching work environment to insure that they don't burn out and or leave! Educational
research can inform how to attract and keep high caliber teachers. Having special certifiction goals and a system for achieving those goals will help
teachers work effectively with children.
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
Relicensure sholld be based on educational credentials and experience. Licensure should not be based on a personnel evaluation. Teachers should be
regarded and respected as well qualified professionals.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
Virginia "Ginny" Lyons | [EMAIL] | 241 White Birch Lane, Williston VT 05495 | Senator -- Chittenden County | Yes |  | Chittenden
Spreadsheet: 167027d1341870063-macro-sheet-change-example1
Sheet: Sheet2

Time/Date | Code | Name | Headline |  |  |  | Source
2012-07-09 20:00:00 | - | Tensid | Service Notice |  |  |  | TEN
2012-07-09 18:35:00 | - | HUGIN ASA | End of Day Message |  |  |  | ONE
2012-07-09 18:30:00 | - | RNS | Final Announcement Released |  |  |  | RNS
2012-07-09 18:30:00 | - | Marketwire UK Limited | End of Day Message |  |  |  | MKW
2012-07-09 18:30:00 | - | PR Newswire | End of Day |  |  |  | PRN
2012-07-09 18:30:00 | - | Business Wire | End of Day Message |  |  |  | BZN
2012-07-09 18:27:00 | DPV3 | Downing Planned Exit VCT 3 PLC | Downing Planned Exit VCT 3 PLC : Issue of Equity | Add to Portfolio | View chart |  | ONE
2012-07-09 18:26:00 | DPV2 | Downing Planned Exit VCT 2 PLC | Downing Planned Exit VCT 2 PLC : Issue of Equity | Add to Portfolio | View chart |  | ONE
2012-07-09 18:25:00 | RB. | Reckitt Benckiser Group PLC | Director/PDMR Shareholding | Add to Portfolio | View chart |  | PRN
2012-07-09 18:25:00 | - | Arma Partners LLP | Offer Document Posted |  |  |  | RNS
2012-07-09 18:16:00 | JPEL | J.P. Morgan Private Equity Ltd | Credit Facility | Add to Portfolio | View chart |  | RNS
2012-07-09 18:15:00 | JPEL | J.P. Morgan Private Equity Ltd | Monthly Report - May 2012 | Add to Portfolio | View chart |  | RNS
2012-07-09 18:01:00 | HINT | Henderson Intl. Income Trust PLC | Interim Management Statement | Add to Portfolio | View chart | Order free Annual Report | RNS
2012-07-09 18:01:00 | CQS | CQS Diversified Fund Limited | Net Asset Values 6 July 2012 | Add to Portfolio | View chart |  | RNS
2012-07-09 18:00:00 | FTN | Foresight 2 VCT Plc | Foresight 2 VCT PLC : Transaction in Own Shares & Total Voting Rights | Add to Portfolio | View chart |  | ONE
2012-07-09 18:00:00 | - | Harewood Structured Investment PCC | Net Asset Value(s) |  |  |  | RNS
2012-07-09 18:00:00 | NBLS | NB Global Floating Rate Income Fund | Net Asset Value(s) | Add to Portfolio | View chart |  | RNS
2012-07-09 18:00:00 | - | Harewood Structured Investment PCC | Net Asset Value(s) |  |  |  | RNS
2012-07-09 18:00:00 | - | Harewood Structured Investment PCC | Net Asset Value(s) |  |  |  | RNS
2012-07-09 18:00:00 | AEFS | Alcentra European Fltng Rate Inc Fd | Net Asset Value(s) | Add to Portfolio | View chart |  | RNS
Spreadsheet: 267708d1380144115-help-with-solver-as-solver-gives-wrong-answer-help
Sheet: Q2

Month | January | Temp (F) | Weather
Day | 2013-01-01 00:00:00 |  |  |  | Cloudy
 | 2013-01-02 00:00:00 |  |  |  | Rain
 | 2013-01-03 00:00:00 |  |  |  | Snow
 | 2013-01-04 00:00:00 |  |  |  | Sunny
 | 2013-01-05 00:00:00
 | 2013-01-06 00:00:00
 | 2013-01-07 00:00:00
 | 2013-01-08 00:00:00
 | 2013-01-09 00:00:00
 | 2013-01-10 00:00:00
 | 2013-01-11 00:00:00
 | 2013-01-12 00:00:00
 | 2013-01-13 00:00:00
 | 2013-01-14 00:00:00
 | 2013-01-15 00:00:00
 | 2013-01-16 00:00:00
 | 2013-01-17 00:00:00
 | 2013-01-18 00:00:00
 | 2013-01-19 00:00:00
 | 2013-01-20 00:00:00
 | 2013-01-21 00:00:00
 | 2013-01-22 00:00:00
 | 2013-01-23 00:00:00
 | 2013-01-24 00:00:00
 | 2013-01-25 00:00:00
 | 2013-01-26 00:00:00
 | 2013-01-27 00:00:00
 | 2013-01-28 00:00:00
 | 2013-01-29 00:00:00
 | 2013-01-30 00:00:00
 | 2013-01-31 00:00:00
Average Tempature
Highest Temperature
Number of Sunny Days
Number of Days Above 50 F
Average Temperature of Rainy Days
Highest Temperature of Rainy Days
Day of the Highest Temperature of the Month
Second Highest Temperature of the Month
Spreadsheet: 149387d1333911074-subtraction-if-function-question-excel-project-2-2012
Sheet: Sheet1

 | 2008 | 2009 | 2010 | 2011
Sales
Deli
Dairy
Canned Goods
[NAME]
Meats
Produce
Dry Goods
Video Sales
Total Sales
Cost of Goods Sold
Deli
Dairy
Canned Goods
[NAME]
Meats
Produce
Dry Goods
Video Sales
Total Cost of Goods Sold
Gross Profit
Operating Expenses
Sales and Marketing
General and Administrative
Depreciation | 20000 | 20000 | 20000 | 20000
Wages
Common Costs
Total Operating Expenses
Income Before Taxes
Income Taxes
Net Income
Base Period Sales | 3750000
Store Items | % of Total Sales for Year | [NAME] |  | Rates
Deli | 0.05 | 0.5 |  | 2009 Growth | 0.0625
Dairy | 0.19 | 0.5 |  | 2010 Growth | 0.0775
Canned Foods | 0.1 | 0.75 |  | 2011 Growth | 0.0825
[NAME] | 0.22 | 0.65 |  | Tax | 0.35
Meats | 0.21 | 0.5
Produce | 0.125 | 0.65
Dry Goods | 0.09 | 0.66
Video Sales | 0.015 | 0.3
 | 1 |  |  | Salaries
Operating Expenses |  |  |  | Mr. [NAME] | 0.12
Sales and Marketing | 0.055 |  |  | Store Manager | 57000
General and Administrative | 0.0875 |  |  | Asst. Manager | 42000
Depreciation Expense | 20000
Wage |  |  |  | No. of Employees | 17
Spreadsheet: 272203d1382274087-compare-two-cells-and-pick-up-the-common-number-help-and-thanks-numbermatch
Sheet: Sheet1

12345
34678
Spreadsheet: 734196d1622034027-sumif-countif-overtime-new-microsoft-excel-worksheet
Sheet: Sheet1

Name | Total hours per day
 | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 |  | Normal OT | Holiday Overtime = Sunday
Jone | 8 | 9 | 10 | 11 | 12 | 8 | 8 | 11 | 12 | 13
[NAME] | 9 | 10 | 12 | 8 | 9 | 13 | 14 | 8 | 9 | 12
Jimy | 10 | 11 | 8 | 9 | 10 | 12 | 13 | 8 | 8 | 10
Spreadsheet: 90269d1290020482-macro-to-do-calculations-on-a-dynamic-range-test-file-for-macro2
Sheet: Sheet2

AME | [PHONE] | 13769.21 | 0 | 2390.707058761586 | 2323.198975870518 | 4713.906034632104 | A36 | A
AME | [PHONE] | 17380.7 | 0 | 3483.489751787392 | 3319.899936199591 | 6803.389687986983 | A81 | A
AME | [PHONE] | 17323.13 | 0 |  |  |  | A91 | A
AME | [PHONE] | 11271.4 | 0 | 1809.635970727738 | 1892.22297008247 | 3701.858940810208 | A81 | A
AME | [PHONE] | 5355.18 | 0 | 1360.7736577 | 1676.440003900002 | 3037.213661600002 | A36 | A
AME | [PHONE] | 18082.45 | 0 | 3192.053782426176 | 2026.356063946505 | 5218.409846372682 | A36 | A
AME | [PHONE] | 13027.41 | 0 | 2341.964029 | 1734.465756 | 4076.429785 | A91 | A
AME | [PHONE] | 8632.54 | 0 | 1720.020537 | 1331.934507 | 3051.955043999999 | A36 | A
AME | [PHONE] | 13624.66 | 0 | 2877.539767226888 | 2624.856274105415 | 5502.396041332304 | A36 | A
AME | [PHONE] | 9077.37 | 0 | 1494.173032747215 | 1514.194198942003 | 3008.367231689218 | A81 | A
AME | [PHONE] | 14393.59 | 0 | 3010.348696387297 | 2150.739687005264 | 5161.088383392561 | A36 | A
AME | [PHONE] | 13372.69 | 0 | 2503.293019813742 | 1988.169699942623 | 4491.462719756365 | A95 | A
ASA | [PHONE] | 9674.18 | 0 | 6002.421237592549 | 3289.690829518524 | 9292.112067111073 | A37 | A
ASG | [PHONE] | 2917.88 | -440 | 585.9816423524176 | 553.7708353009647 | 1139.752477653382 | A37 | A
ASG | [PHONE] | 11440.2 | 0 | 2384.263136 | 2342.139306 | 4726.402441999999 | A81 | A
ASG | [PHONE] | 7966.41 | -773 | 1552.451829453795 | 1592.404053462162 | 3144.855882915956 | A37 | A
ASG | [PHONE] | 9662.300000000001 | 0 | 1865.430905914131 | 1998.941262561017 | 3864.372168475147 | A91 | A
ASG | [PHONE] | 18538.16 | 0 | 3577.027889689479 | 3248.214071291547 | 6825.241960981025 | A91 | A
ASG | [PHONE] | 2815.69 | 0 | 690.9866401584712 | 552.0050992773128 | 1242.991739435784 | A37 | A
ASG | [PHONE] | 8453.5 | 0 | 1565.755947373165 | 1648.253809184657 | 3214.009756557822 | A81 | A
ASG | [PHONE] | 4058.93 | 0 | 831.53296 | 836.6062390000001 | 1668.139199 | A91 | A
ASG | [PHONE] | 12265.97 | 0 | 3068.976855269002 | 2260.161098377766 | 5329.137953646768 | A81 | A
ASG | [PHONE] | 5744.02 | 0 | 1166.395444 | 1162.805707 | 2329.201151 | A91 | A
ASG | [PHONE] | 14258.39 | 0 | 1565.677881789024 | 2215.803037545752 | 3781.480919334776 | A91 | A
 |  | 263105.96 | -1213 | 51040.90167317007 | 44283.27342151409 | 95324.17509468418
 |  | 10884.29 | -0.1114450276499432
 |  | 252221.67 | -28108.85098706484
Spreadsheet: 836481d1689397337-merging-formulas-that-reference-sheets-indirect-formulas-test-file
Sheet: Sheet2

 |  |  |  |  |  |  |  | I am trying to figure out a way to combine both formulas (column B and C) so that I can avoid dragging the formula in column C down and having a bunch of references
 | ZONE | TOTALS |  | Solution? |  |  |  | my first attempt at this was with the formula in column E (I replaced B5 with the formula in column B) but I am having no luck.
 | ALPHA-02 |  |  |  |  |  |  |  | INDIRECT("'"&B5&"'!"&TEXT(SUBSTITUTE(ADDRESS(1,COLUMN('ALPHA-01'!$H$222),4),"1","")&ROW('ALPHA-01'!$H$222),0))
 | ALPHA-03 |  |  |  |  |  |  |  |  | ^
 | ALPHA-04 |  |  |  |  |  |  |  |  | IF(SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found")))="","",SORT(UNIQUE(FILTER(Sheet1!A10:A1000,ISNUMBER(SEARCH("ALPHA",Sheet1!A10:A1000)),"not found"))))
 |  |  |  |  |  |  |  |  |  | some test formulas below
 |  |  |  |  |  |  |  |  | Formula 1
 |  |  |  |  |  |  |  |  |  | 'ALPHA-02'!
 |  |  |  |  |  |  |  |  |  | 'ALPHA-03'!
 |  |  |  |  |  |  |  |  |  | 'ALPHA-04'!
 |  |  |  |  |  |  |  |  | Formula 2
 |  |  |  |  |  |  |  |  | Formula 1+2
 |  |  |  |  |  |  |  |  |  | 'ALPHA-02'!H222
 |  |  |  |  |  |  |  |  |  | 'ALPHA-03'!H222
 |  |  |  |  |  |  |  |  |  | 'ALPHA-04'!H222
Spreadsheet: daren_farmer__5620__HPLN1208
Sheet: Sheet1

HPLN1208.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 08, 2000
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-08 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 0 | *
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher