tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18083__9-29 Deal Summary
Sheet: EOL Deals

EOL Deals | From: 9/1/2000   To: 9/28/2000 |  |  | EnPower Deals | From: 9/1/2000   To: 9/28/2000
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 3566400 | 264 |  | EPMI Long Term California | 3588995 | 162
EPMI Long Term Northwest | 2618175 | 171 |  | EPMI Long Term Northwest | 12698025 | 329
EPMI Long Term Southwest | 3407200 | 99 |  | EPMI Long Term Southwest | 11433770 | 298
EPMI Short Term California | 449664 | 444 |  | EPMI Long Term West Management | 10400 | 1
EPMI Short Term Northwest | 603600 | 395 |  | EPMI Long Term West Transmission | 243200 | 4
EPMI Short Term Southwest | 2344950 | 616 |  | EPMI Short Term California | 2012800 | 455
 |  |  |  | EPMI Short Term Northwest | 957330 | 410
Grand Total | 12989989 | 1989 |  | EPMI Short Term Southwest | 2367700 | 417
 |  |  |  | Grand Total | 33312220 | 2076
EOL Deals | From: 9/28/2000   To: 9/28/2000 |  |  | EnPower Deals | From: 9/28/2000   To: 9/28/2000
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 173200 | 13 |  | EPMI Long Term California | 204000 | 10
EPMI Long Term Northwest | 448425 | 30 |  | EPMI Long Term Northwest | 492775 | 28
EPMI Long Term Southwest | 326400 | 8 |  | EPMI Long Term Southwest | 182800 | 13
EPMI Short Term California | 57200 | 54 |  | EPMI Long Term West Transmission | 243200 | 4
EPMI Short Term Northwest | 110800 | 35 |  | EPMI Short Term California | 113600 | 35
EPMI Short Term Southwest | 156225 | 31 |  | EPMI Short Term Northwest | 94450 | 28
 |  |  |  | EPMI Short Term Southwest | 76225 | 25
Grand Total | 1272250 | 171
 |  |  |  | Grand Total | 1407050 | 143
Spreadsheet: 540698d1506893917-problem-with-accounting-data-analysis-data-comparison-analysis
Sheet: Data

Account | Document symbol | Description | Dt | Ct | Code1 | Code2 | Transaction date | Document number
241-1-750-75011-4300 | BO/2017 | BO/2017 | 1600 | 0 | 16 | 000000 | 2017-01-01 00:00:00 | 4
241-1-750-75011-4300 | BO/2017 | BO/2017 | -1600 | 0 | 16 | 000000 | 2017-01-01 00:00:00 | 5
241-1-750-75011-4300 | BO/2017 | BO/2017 | 0 | -900 | 16 | 000000 | 2017-01-01 00:00:00 | 5
402-1-450-75011-4300 | 87K3/0424/17 | 87K3/0424/17 car services/Smith J. | 22.9 | 0 | 16 | 000000 | 2017-01-02 00:00:00 | 95
402-1-130-75011-4300 | 65K2/0424/17 | 65K2/0424/17 car services/Green A. | 23.99 | 0 | 16 | 000000 | 2017-01-03 00:00:00 | 95
402-1-450-75011-4300 | 23K3/0424/17 | 23K3/0424/17 car services/Brown J. | 23.99 | 0 | 16 | 000000 | 2017-01-04 00:00:00 | 95
402-1-090-75011-4300 | FF/253/07/17 | FF/253/07/17 car services/Smith J. | 21.9 | 0 | 16 | 000000 | 2017-01-05 00:00:00 | 102
402-1-450-75011-4300 | 412/0424/17 | 412/0424/17 car services/Brown J. | 23.99 | 0 | 16 | 000000 | 2017-01-05 00:00:00 | 103
402-1-450-75011-4300 | FF/254/07/17 | FF/254/07/17 car services/Green A. | 23.99 | 0 | 16 | 000000 | 2017-01-05 00:00:00 | 104
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice 65K2/0424/17 | 0 | 23.99 | 15 | 000000 | 2017-01-06 00:00:00 | 12
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice 87K3/0424/17 | 0 | 22.9 | 16 | 000000 | 2017-01-06 00:00:00 | 12
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice 23K3/0424/17 | 0 | 23.99 | 16 | 000000 | 2017-01-06 00:00:00 | 12
402-1-450-75011-4300 | 891/0654/17 | 891/0654/17 car services/Smith J. | 23.9 | 0 | 16 | 000000 | 2017-01-04 00:00:00 | 105
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice FF/253/07/17 | 0 | 21.9 | 16 | 000000 | 2017-01-06 00:00:00 | 12
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice 412/0424/17 | 0 | 23.99 | 16 | 000000 | 2017-01-06 00:00:00 | 12
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice FF/254/07/17 partial payment | 0 | 13.99 | 16 | 000000 | 2017-01-06 00:00:00 | 12
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice FF/254/07/17 partial payment | 0 | 10 | 16 | 000000 | 2017-01-06 00:00:00 | 12
130-1-750-75011-4300 | EXPENDITURES/EX 12/2017 | EXPENDITURES/EX 12/2017 invoice 891/0654/17 | 0 | 23.9 | 16 | 000000 | 2017-01-06 00:00:00 | 12
Spreadsheet: 796412d1663256335-rent-free-calculation-rent-free-workings
Sheet: Sheet1

Rent Free Period | 3
Fee Start (Month) | 4
Month | 1
Property | 1
Area | 62162.16666666666 | 62162.16666666666 | 62162.16666666666 | 62162.16666666666 | 62162.16666666666 | 62162.16666666666 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 372973 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 62162.16666666666 | 186486.5 | 124324.3333333333 | 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 |  |  | 372973 |  | 0 | 0 | 0 | 372973 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent | 83.28842386580637 | 84.26414083177981 | 84.26414083177981 | 84.26414083177981 | 85.25128824094693 | 85.25128824094693 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 84.26414083177981 | 85.25128824094693 | 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
Total rent | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
Rent Free Period
Property 1
Property 2
Property 3
Property 4
Property 5
Property 6
Total Rent Free | 0 | 0 | 0 |  |  |  |  |  | 0 | 0
Spreadsheet: 78050d1278507269-look-up-value-based-on-multiple-criteria-sample
Sheet: Weekly Total

 | Packaging Line "A" |  |  |  |  |  |  |  |  |  | Packaging Line "B" |  |  |  |  |  |  |  |  |  | L&G Packing
 | Packaging Date |  | [NAME] to pack |  | # of kits expected to pack |  | Actual Units Packed |  | Employees |  | Packaging Date |  | [NAME] to pack |  | # of kits expected to pack |  | Actual Units Packed |  | # of Employees needed |  | Packaging Date |  | [NAME] to pack |  | # of kits expected to pack |  | Actual Units Packed |  | # of Employees needed
 | 2010-07-05 00:00:00 |  | Captain's Loft II #3272 |  | 96 |  | 96 |  |  |  | 2010-07-05 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-05 00:00:00
 | 2010-07-06 00:00:00 |  | Costco (2008) Box #3280 |  | 96 |  |  |  |  |  | 2010-07-06 00:00:00 |  | Costco (2009) Box #3200 |  | 192 |  |  |  |  |  | 2010-07-06 00:00:00
 | 2010-07-07 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-07 00:00:00 |  | Costco (2008) Box #3290 |  | 96 |  |  |  |  |  | 2010-07-07 00:00:00
 | 2010-07-08 00:00:00 |  | Captain's Loft II #3272 |  | 77 |  | 96 |  |  |  | 2010-07-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-08 00:00:00
 | 2010-07-09 00:00:00 |  | Captain's Loft II #3272 |  | 77 |  |  |  |  |  | 2010-07-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-09 00:00:00
 | 2010-07-10 00:00:00 |  | Captain's Loft II #3272 |  | 77 |  |  |  |  |  | 2010-07-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-10 00:00:00
 | 2010-07-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-12 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-12 00:00:00
 | 2010-07-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-13 00:00:00
 | 2010-07-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-14 00:00:00
 | 2010-07-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-15 00:00:00
 | 2010-07-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-16 00:00:00
 | 2010-07-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-17 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-17 00:00:00
 | 2010-07-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-19 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-19 00:00:00
 | 2010-07-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-20 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-20 00:00:00
 | 2010-07-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-21 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-21 00:00:00
 | 2010-07-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-22 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-22 00:00:00
 | 2010-07-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-23 00:00:00
 | 2010-07-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2010-07-24 00:00:00
Spreadsheet: 866958d1713873079-using-vlookup-to-find-different-instances-vlookup
Sheet: Sheet1 (2)

 | DATA
 | Job No
 | 444 | TRAIN |  |  | RESULT IN COLUMN G REQUIRED
 | 666 | BUS
 | 777 | CAR |  |  | job no | result1
 | 888 | BUS |  |  | 444 | TRAIN
 | 444 | CAR |  |  | 666 | BUS
 | 555 | BIKE |  |  | 444 | CAR
 | 444 | bike |  |  | 555 | BIKE
 |  |  |  |  |  | result here
Spreadsheet: 215406d1361371307-sumif-issue-how-to-not-count-specific-values-example
Sheet: Sheet1

Main Table
 | Source | P1 | P2 | P3 | P4 | P5 | P6
Prima | TA |  | 200 | 1000 |  | 1000 | 1000
Cosmo | TA |  | 50 |  | 100
Alpha | TA | 1000 | 500 | 500 |  |  | 1000
Beta |  | 500 |  | 500
Xion | TA |  |  | 500 |  | 1000
Plus | TA |  |  |  |  |  | 500
Totals Table
 | P1 | P2 | P3 | P4 | P5 | P6
Result I need | 1000 | 250 | 500 | 0 | 0 | 500
Using the formula
Spreadsheet: 714dbd3f-75a9-4fe2-b617-d10e82c925b4
Sheet: Impact Analysis

Project Impact Analysis
Application/System | Impact /Dependency | Level | Explanation
Accounts Database
Athletics Ticket System
AdmitM/Nolij Interface
Advance
[NAME]
Apply Yourself
[NAME]
Accounts Receivable
Finance
Financial Aid
Human Resources
Student
Self Service
Blackboard Course Mgmt
[NAME] (ID card system)
[NAME]
Career Services
CollegeNet
CommonApp
Conference Programming/CVent
Course Evaluations
Discoverer
e-print
eSUDS
FAACS –Fixed Asset
FAMIS [NAME]
GER
Harvest
Identipass (Building Access)
Institutional Reporting
Intellicheck
iTunesU
Judicial System
Law School – Career Center
LDAP
Luminis  4
Mainframe
Meal Plan System
Mirapoint Email
MySoft (Telecom)
ODS
One Step (CORE Cashiering)
[NAME]
DOSO Orientation
Parking Services TickeTrax
PBR
PeopleAdmin
PIES
Pitney Bowes Postal System
Protocol and Compliance Management
Pyramed
[NAME] (student file sent)
Remedy
SIRIS (SWEM Library)
SSD-Axiom
State Agency Reporting
Sympa
 |  |  | No longer used
Winstar
Tools | Impact / | Level | Explanation
 | Dependency
Browsers (IE, [NAME], [NAME])
Cascade
Client OS (MAC, VISTA, XP, UNIX)
COBOL/C
ColdFusion
Database Backends (mySQL, SQL Server,, Access)
Development Tools
Discoverer
[NAME] (j:/initiator, [NAME])
Opinio
Oracle APEX
Oracle database
Oracle Web Servers
Functional Offices | Impact / | Level | Explanation
 | Dependency
Admissions
Alumni Association
[NAME] of Students |  |  | Will need to assess impact on orientation goals for new students
Development
Finance |  |  | Outage may conflict with year end reporting
Financial Aid
Human Resources
Intercollegiate Athletics
Public Affairs
[NAME]
School of Arts & Sciences
School of Business
School of Education
School of Law
School of Marine Science
Student Affairs
Swem Library
University Registrar |  |  | Late July outage may conflict with registration windows for Freshman.
Security Considerations | Impact / | Level | Explanation
 | Dependency
Data Sensitivity
Personally Identifiable Information
System Access
Projects | Impact / | Level | Explanation
 | Dependency
Review project list and list those projects that will be impacted.
Data Feeds | Impact / | Level | Explanation
 | Dependency
Alumni Office (Banner to Advance feed)
Campus Post Office
Career Services
[NAME] of Students
Orientation
Transfers
Health Center (student data file for Pyramed)
Identipass (Building Access)
Law School – Career Center
[NAME] (student file sent)
SHEV Report
State Police
SWEM Library (Discoverer file sent – students/fac/staff)
Vendor Transaction Report (sent to APA)
Spreadsheet: 76002bbe-6842-4555-a329-0990a89729b7
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
LPSBF | Test | LPSBF | Lipase, Body Fluid | Lipase, BF | Colorimetric Rate Reaction |  |  |  | 1 | mL | Container/Tube: Sterile container [NAME]: 1 mL Collection Instructions: Centrifuge to remove any cellular material. Additional Information: Indicate specimen source. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	Spinal fluid | Not applicable | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 83690 |  |  |  |  | Rochester
LPSBF | [NAME] | BODYFL | Body Fluid |  |  |  | Frozen | 90 days
LPSBF | Order Question | FLD7 | [NAME] |  | Plain Text
LPSBF | Result | LPBF | Lipase, BF | Lipase, BF | Numeric |  |  |  |  | U/L |  |  |  |  |  |  |  |  |  | 15212-4
LPSBF | Result | FLD7 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6
Spreadsheet: 784437d1655734947-googlesheets-pulling-data-from-a-set-of-dynamic-data-sample
Sheet: Filtered Data

I am Using a Google sheet, I used a Filter function to obtained result below | =[NAME]:F23,'Raw data'!H3:23="yes") |  |  |  |  | And Normally, I will add data behind After I got the filtered result, example
Client Name | Duration | URL | Status | Start Date | End Date | [NAME] | Name
KK Officepoint Sdn. Bhd. | 6 | https://kk-officepointsg.com/ | Ended |  |  | [EMAIL] | [NAME]
City Point Solutions Sdn Bhd | 12 | https://www.citypoint.my/ | Running |  |  | [EMAIL] | [NAME]
CHEMIN HYGIENE SDN BHD | 12 | https://chemin.com.my/ | Ended |  |  | [EMAIL] | [NAME]
S.M (Samas) Enterprises Sdn Bhd | 12 | https://www.smsamas.com/ | Ended |  |  | [EMAIL] | [NAME]
Alpha Bio Medic (M) Sdn Bhd | 12 | http://alphabiomedic.com.my/ | Dropped |  |  | [EMAIL] | [NAME]
ARCHTRON RESEARCH & DEVELOPMENT SDN BHD | 12 | http://bluguard.com.my/ | Ended |  |  | [EMAIL] | [NAME]
Red Ant Print Sdn. Bhd. | 12 | https://redant.com.my/ | Ended |  |  | [EMAIL] | [NAME]
SEVEN STAR PACKING SERVICES SDN BHD | 3 | https://sevenstar.com.my/ | Ended |  |  | [EMAIL] | [NAME]
MULTI FOCUS ENTERPRISE SDN BHD (1127733-T) | 3 | https://multifocus.com.my/ | Ended |  |  | [EMAIL] | [NAME] 9
HSH TRANSPORTATION SDN BHD | 12 | https://hshtrans.com/ | Ended |  |  | [EMAIL] | [NAME] 10
Team Power Marketing | 12 | https://officefurnitureasia.com/ | Ended |  |  | [EMAIL] | [NAME]
JJ Furniture Trading | 12 | https://www.jjfurniture.com.my/ | Ended |  |  | [EMAIL] | 12
NOVO REPERIO SDN BHD | 12 | https://www.novoreperio.com/ | Pause |  |  | [EMAIL] | 13
Green House Ingredient Sdn Bhd | 12 | https://ibake365.com/ | Ended |  |  | [EMAIL] | 14
ORION Food Industries (M) Sdn. Bhd | 12 | http://orionfood.com.my/ | Ended |  |  | [EMAIL] | 15
[NAME]. Bhd | 12 | https://www.goobat.care/ | Dropped |  |  | [EMAIL] | 16
SAUCE EMPIRE MANUFACTURING SDN BHD | 12 | https://nyolike.com/ | Ended |  |  | [EMAIL] | 17
Little Nature Explorer Sdn Bhd | 12 | https://www.oshandpiper.com/ | Ended |  |  | [EMAIL] | 18
ACTIVE NETWORK SECURITY SERVICES SDN BHD | 12 | https://activesecurity.com.my/ | Ended |  |  | [EMAIL] | 19
AMPLIFIED AUDIO | 12 | https://shop.amplifiedhead.com/ | Pause |  |  | [EMAIL] | 20
Spreadsheet: 00d04586-48ca-4ba8-84d8-47c97cf98ec4
Sheet: Sheet1

EDUCATOR PREPARATION PROGRAM CANDIDATES - ADVANCED CERTIFICATIONS ([NAME])
Advanced Cert Description | Admission Year | Total Candidates
Educational Diagnostician | 2008-2009 | 6
 | 2009-2010 | 5
 | 2010-2011 | 4
Principal | 2008-2009 | 47
 | 2009-2010 | 57
 | 2010-2011 | 38
Reading Specialist | 2008-2009 | 4
 | 2009-2010 | 1
 | 2010-2011 | 0
School Counselor | 2008-2009 | 41
 | 2009-2010 | 66
 | 2010-2011 | 69
Superintendent | 2008-2009 | 41
 | 2009-2010 | 14
 | 2010-2011 | 11
Data Retrieved from ASU EPP Database
Spreadsheet: 86204d1286233817-extract-and-filter-by-year-and-or-region-sumproductexamples
Sheet: Sheet1

Date | Name | State | Total | Reason |  |  |  |  | YEAR
2009-01-05 00:00:00 | [NAME] | NJ | 5 | Sale |  |  |  |  | 2009 | 2010 |  | Totals only
2009-01-06 00:00:00 | [NAME] | NJ | 2 | Sale |  |  | REGION | NJ | 11 | 51
2009-02-08 00:00:00 | [NAME] | NJ | 4 | Sale |  |  |  | DE | 3 | 15
2009-04-05 00:00:00 | [NAME] | DE | 3 | Sale |  |  |  | CA | 0 | 55
2010-04-05 00:00:00 | [NAME] | NJ | 12 | Return
2010-06-05 00:00:00 | [NAME] | DE | 15 | [NAME]
2010-07-08 00:00:00 | [NAME] | NJ | 17 | Sale
2010-09-08 00:00:00 | [NAME] | NJ | 22 | Return |  |  |  |  | YEAR
2010-09-15 00:00:00 | [NAME] | DE | 0 | Return |  |  |  |  | 2009 | 2010 |  | Sales only
2010-01-20 00:00:00 | [NAME] | CA | 55 |  |  |  | REGION | NJ | 11 | 17
 |  |  |  |  |  |  |  | DE | 3 | 0
 |  |  |  |  |  |  |  | CA | 0 | 0
 |  |  |  |  |  |  |  |  | YEAR
 |  |  |  |  |  |  |  |  | 2009 | 2010 |  | Sales - Returns
 |  |  |  |  |  |  | REGION | NJ | 11 | -17
 |  |  |  |  |  |  |  | DE | 3 | 0
 |  |  |  |  |  |  |  | CA | 0 | 0
Spreadsheet: kate_symes__18267__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-02 00:00:00 |  | 284.36 | 24400 | 227.63 | 9504
 | 2001-04-01 00:00:00 |  | 236.99 | 2336 | 225 | 0 | 243.67 | 158 | 219.78 | 273 |  | 229.73 | 26352
 | 2001-03-31 00:00:00 |  | 179.66 | 24400 | 125.17 | 9640 | 220.77 | 698 | 100 | 4
 | 2001-03-30 00:00:00 |  | 179.99 | 23600 | 125.18 | 9040 | 203.23 | 798 | 173.41 | 504
 | 2001-03-29 00:00:00 |  | 187.27 | 26400 | 130.98 | 10880 | 181.96 | 553 | 151.95 | 154
 | 2001-03-28 00:00:00 |  | 161.91 | 27600 | 100.36 | 9480 | 170.67 | 208 | 110.85 | 544
 | 2001-03-27 00:00:00 |  | 155.95 | 22800 | 89.58 | 6200 | 152.08 | 1038 | 121.24 | 169
 | 2001-03-26 00:00:00 |  | 334.36 | 15600 | 230.55 | 6600 | 102.59 | 243 | 60.96 | 287
 | 2001-03-25 00:00:00 |  | 260 | 0 | 230 | 0 | 70 | 200 | 41.32 | 456 |  | 229.94 | 19200
 | 2001-03-24 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 113.77 | 1687 | 139.44 | 832
 | 2001-03-23 00:00:00 |  | 312.79 | 15600 | 217.52 | 5960 | 331.82 | 1155 | 150 | 4
 | 2001-03-22 00:00:00 |  | 377.69 | 16800 | 274.53 | 6400 | 233.97 | 521 | 266.13 | 248
 | 2001-03-21 00:00:00 |  | 452.08 | 17280 | 319.69 | 4928 | 443.97 | 58 | 294.11 | 259
 | 2001-03-20 00:00:00 |  | 402.53 | 16000 | 277.64 | 5952 | 456.15 | 488 | 316.05 | 214
 | 2001-03-19 00:00:00 |  | 397.48 | 26800 | 342.53 | 7360 | 398.47 | 1222 | 145.95 | 454
 | 2001-03-18 00:00:00 |  | 370 | 0 | 330 | 0 | 140.35 | 285 | 146.22 | 1255 |  | 343.75 | 22080
 | 2001-03-17 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 400 | 50 | 215.18 | 140
 | 2001-03-16 00:00:00 |  | 245.91 | 18400 | 217.72 | 9200 | 325 | 415 | 188.89 | 405
 | 2001-03-15 00:00:00 |  | 216.73 | 20560 | 174.7 | 10144 | 237.58 | 642 | 186.25 | 260
 | 2001-03-14 00:00:00 |  | 211.45 | 25360 | 172.67 | 8512 | 225.87 | 1552 | 157.5 | 480
 | 2001-03-13 00:00:00 |  | 211.79 | 20960 | 168.03 | 9088 | 235.45 | 33 | 150.36 | 445
 | 2001-03-12 00:00:00 |  | 263.78 | 24240 | 255.08 | 7632 | 223.3 | 996 | 176.32 | 106
 | 2001-03-11 00:00:00 |  | 265 | 0 | 230 | 200 | 219.32 | 111 | 174.9 | 264 |  | 255.41 | 23256
 | 2001-03-10 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 247.11 | 873 | 227.78 | 709
 | 2001-03-09 00:00:00 |  | 224.71 | 20800 | 190.8 | 6912 | 277.5 | 52 | 230.19 | 982
 | 2001-03-08 00:00:00 |  | 262.5 | 14400 | 203.46 | 4624 | 282.12 | 2609 | 247.42 | 748
 | 2001-03-07 00:00:00 |  | 332.94 | 26544 | 285.65 | 15720 | 330.51 | 717 | 232.25 | 507
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232 | 336.81 | 452 | 233.81 | 624
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 |  |  |  |  |  | ..