tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838368d1690967111-averageifs-ignoring-blanks-and-zeros-book1
Sheet: Timeline

Start Date | Finish Date | Duration
2022-09-14 00:00:00 | 2022-11-15 00:00:00
2022-09-11 00:00:00 | 2022-11-22 00:00:00
2022-12-19 00:00:00 | 2023-01-03 00:00:00
2022-12-23 00:00:00 | 2023-01-10 00:00:00
2022-11-15 00:00:00 | 2023-01-24 00:00:00
2023-02-20 00:00:00 | 2023-03-07 00:00:00
2023-03-24 00:00:00 | 2023-04-04 00:00:00
2023-02-24 00:00:00 | 2023-04-06 00:00:00
2023-02-24 00:00:00 | 2023-04-06 00:00:00
2023-03-03 00:00:00 | 2023-04-30 00:00:00
2023-04-14 00:00:00 | 2023-05-03 00:00:00
2023-05-24 00:00:00 | 2023-06-14 00:00:00
2023-04-17 00:00:00 | 2023-06-14 00:00:00
2023-06-07 00:00:00
Spreadsheet: 37346d1235330921-remove-duplicates-based-while-keeping-other-rows-in-tact-book1
Sheet: Sheet1

Part Number | Price | Quantity | Name | Description | Category | Manufacturer
KQ437AA#ABA | 1500 | 9 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
KQ437AA#ABA | 2000 | 20 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
KQ437AA#ABA | 1800 | 3 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
KQ437AA#ABA | 2300 | 0 | HP TouchSmart - IQ506 | Want simple, touch access to information, social networks, music, photos, videos, e-mail, TV?... | Laptops | Hewlett-Packard
[NAME] | 400 | 20 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
[NAME] | 350 | 15 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
[NAME] | 380 | 30 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
[NAME] | 345 | 5 | [NAME] ONE A110-1295 | Acer redefines mobile connectivity with the Aspire one, a notebook packed with fun… | Laptops | Acer
KDL-32M4000 | 550 | 0 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
KDL-32M4000 | 680 | 0 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
KDL-32M4000 | 600 | 8 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
KDL-32M4000 | 700 | 0 | Sony - 32" LCD TV | The Sony BRAVIA HDTV KDL-32M4000 offers Sony HD expertise combining the right… | LCD TV | Sony
Spreadsheet: 738648d1625160884-formula-to-calculate-total-amount-of-previous-invoice-total-amount-of-previous-invoice
Sheet: Sheet1

Name | SEQUENCE |  | Note No. | LF No |  | Number | Note No. | LF No | Invoice Total Amount |  |  | Name | Total value project |  | Name selection | LF No | Total Amount of previous invoice | Balance value
L45678990743 | 1 | 1 | LD1 | [NAME] |  | 45678990743 | LD1 | [NAME] | 1000 |  |  |  | 8280 |  | L45678990743 | [NAME] | 0
L45678990743 | 2 | 2 | LD2 | LF2 |  | 45678990743 | LD2 | LF2 | 1010 |  |  | L45678990745 | 8370 |  | L45678990743 | LF2
L45678990743 | 3 | 3 | LD3 | LF3 |  | 45678990743 | LD3 | LF3 | 1020 |  |  | [NAME] | 10220 |  | L45678990743 | LF3
L45678990743 | 4 | 4 | LD4 | LF4 |  | 45678990743 | LD4 | LF4 | 1030 |  |  |  |  |  | L45678990743 | LF4
L45678990743 | 5 | 5 | LD5 | LF5 |  | 45678990743 | LD5 | LF5 | 1040 |  |  |  |  |  | L45678990743 | LF5
L45678990743 | 6 | 6 | LD6 | LF6 |  | 45678990743 | LD6 | LF6 | 1050 |  |  |  |  |  | L45678990743 | LF6
L45678990743 | 7 | 7 | [NAME] | LF7 |  | 45678990743 | [NAME] | LF7 | 1060 |  |  |  |  |  | L45678990743 | LF7
L45678990743 | 8 | 8 | LD8 | LF8 |  | 45678990743 | LD8 | LF8 | 1070 |  |  |  |  |  | L45678990743 | LF8
L45678990745 | 1 | 1 | LD1 | [NAME] |  | 45678990745 | LD1 | [NAME] | 1370
L45678990745 | 2 | 2 | LD2 | LF2 |  | 45678990745 | LD2 | LF2 | 1380
L45678990745 | 3 | 3 | LD3 | LF3 |  | 45678990745 | LD3 | LF3 | 1390
L45678990745 | 4 | 4 | LD4 | LF4 |  | 45678990745 | LD4 | LF4 | 1400
L45678990745 | 5 | 5 | LD5 | LF5 |  | 45678990745 | LD5 | LF5 | 1410
L45678990745 | 6 | 6 | LD6 | LF6 |  | 45678990745 | LD6 | LF6 | 1420
[NAME] | 1 | 1 | LD1 | [NAME] |  | 45678990747 | LD1 | [NAME] | 1430
[NAME] | 2 | 2 | LD2 | LF2 |  | 45678990747 | LD2 | LF2 | 1440
[NAME] | 3 | 3 | LD3 | LF3 |  | 45678990747 | LD3 | LF3 | 1450
[NAME] | 4 | 4 | LD4 | LF4 |  | 45678990747 | LD4 | LF4 | 1460
[NAME] | 5 | 5 | LD5 | LF5 |  | 45678990747 | LD5 | LF5 | 1470
[NAME] | 6 | 6 | LD6 | LF6 |  | 45678990747 | LD6 | LF6 | 1480
[NAME] | 7 | 7 | [NAME] | LF7 |  | 45678990747 | [NAME] | LF7 | 1490
Spreadsheet: 54276d1254295885-change-the-first-day-of-the-week-701430_alienz
Sheet: Formulas

 | Date [NAME]
 | Months |  | startDate | 2008-01-01 00:00:00
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
Method for creating a monthly calendar without using arrays |  |  |  |  |  |  |  |  | Using arrays
 | January 2008
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | January 2008
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | S | M | T | W | Th | F | Sa
1 |  |  | 2008-01-01 00:00:00 | 2008-01-02 00:00:00 | 2008-01-03 00:00:00 | 2008-01-04 00:00:00 | 2008-01-05 00:00:00 |  |  |  | 1 | 2 | 3 | 4 | 5
2 | 2008-01-06 00:00:00 | 2008-01-07 00:00:00 | 2008-01-08 00:00:00 | 2008-01-09 00:00:00 | 2008-01-10 00:00:00 | 2008-01-11 00:00:00 | 2008-01-12 00:00:00 |  | 6 | 7 | 8 | 9 | 10 | 11 | 12
3 | 2008-01-13 00:00:00 | 2008-01-14 00:00:00 | 2008-01-15 00:00:00 | 2008-01-16 00:00:00 | 2008-01-17 00:00:00 | 2008-01-18 00:00:00 | 2008-01-19 00:00:00 |  | 13 | 14 | 15 | 16 | 17 | 18 | 19
4 | 2008-01-20 00:00:00 | 2008-01-21 00:00:00 | 2008-01-22 00:00:00 | 2008-01-23 00:00:00 | 2008-01-24 00:00:00 | 2008-01-25 00:00:00 | 2008-01-26 00:00:00 |  | 20 | 21 | 22 | 23 | 24 | 25 | 26
5 | 2008-01-27 00:00:00 | 2008-01-28 00:00:00 | 2008-01-29 00:00:00 | 2008-01-30 00:00:00 | 2008-01-31 00:00:00 |  |  |  | 27 | 28 | 29 | 30 | 31
6
 | monthNames | startDates
 | January | 2008-01-01 00:00:00
 | February | 2008-02-01 00:00:00
 | March | 2008-03-01 00:00:00
 | April | 2008-04-01 00:00:00
 | May | 2008-05-01 00:00:00
 | June | 2008-06-01 00:00:00
 | July | 2008-07-01 00:00:00
 | August | 2008-08-01 00:00:00
 | September | 2008-09-01 00:00:00
 | October | 2008-10-01 00:00:00
 | November | 2008-11-01 00:00:00
 | December | 2008-12-01 00:00:00
 | January | 2009-01-01 00:00:00
 | February | 2009-02-01 00:00:00
 | March | 2009-03-01 00:00:00
 | April | 2009-04-01 00:00:00
 | May | 2009-05-01 00:00:00
 | June | 2009-06-01 00:00:00
 | July | 2009-07-01 00:00:00
 | August | 2009-08-01 00:00:00
 | September | 2009-09-01 00:00:00
 | October | 2009-10-01 00:00:00
 | November | 2009-11-01 00:00:00
 | December | 2009-12-01 00:00:00
 | January | 2010-01-01 00:00:00
 | February | 2010-02-01 00:00:00
Spreadsheet: 834250d1687545113-help-with-unique-identifer-sampleworkbook
Sheet: Sheet1

 | Enr. No. | Last Name | First Name | Middle Name | Suffix | Address-M | Address2-M | City-M | State-M | Zip-M | DOB | SSN | [NAME]. | ModDate-M
 | 2801A12345 | [NAME] | [NAME] | Field |  |  | 100 Disney Park Way | Orlando | FL | 1234 | 1900-01-01 00:00:00 | 112-23-3344 | 1999-01-01 00:00:00 | 2023-06-23 00:00:00
Spreadsheet: phillip_m_love__31152__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 11/08/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Bravo Natural Resources, Inc. | YH9864.1/2/3/4 | F | NG | [NAME]
New Counterparty | YI0036.1/2 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
AEP/ES | YH9761.1 | F | NG | AEP Energy Services, Inc.
CES-Morgan Stanley Capital Group | YH9654.1 YH9720.1 | F | C2GC | Morgan Stanley Capital Group
Dominion Resources Inc. | YH9795.1 YH9906.1 | F | NG | Dominion Exploration & Production
Spreadsheet: 3cfcbc94-b7f8-4a8c-8ee5-0a683a6a7c1d
Sheet: ExpHE

DP 3. Exposure to Harmful Energies | Potential Unwanted Events
Detailed Potential Unwanted Events (PUEs) | Struck by / contact with hot surfaces | Struck by/ contact  with electrical components | Struck by/ contact with compressed air | Struck by/ contact with high pressure fluids | Struck by/ contact with/ caught between moving/ falling objects | Exposure to radiation | Residual energy in isolated systems | Unintended or erroneous activation of operational controls | Failure of components, hoses, pipes or fittings
1.     Harm from exposure to energies such as heat; electricity; radiation; compressed air; high pressure fluids, including hydraulic fluids; and falling objects | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1
2.     Friction burns, injection or other harm due to working in close proximity to hydraulic equipment or systems |  |  |  | 3.2
3.     Entanglement in rotating parts including engine fans; pulleys; drive belts; gears; drive drums; rollers; and rotating shafts, including drill rods and steels |  |  |  |  | 3.3
4.     Injury from being struck by a release of poorly secured moving or rotating equipment or components |  |  |  |  | 3.4
5.     Entrapment, entanglement, and/or crushing from moving equipment such as: arms, jaws, gates, doors, pull down ropes/chains, winches and foot clamps |  |  |  |  | 3.5
6.     Scalding or burning from exposure to accessible hot surfaces including but not limited to, engines, hot exhaust, engine components, cooling systems and hydraulic components | 3.6 |  |  | 3.6
7.     Electrocution or burning from contact with electrical switches, wires or devices |  | 3.7
8.  Harm from exposure to:      a. Energy induced in hydraulic systems from cylinders.      b. Energy inadvertently released by secondary systems eg fire systems, air bags.      c. Residual energy retained after isolation and apparent de-energisation eg in springs, ropes, conveyor systems, accumulators, receiver tanks and fire systems      d. Energy released from pressure vessels that have not been safely depressurised, including premature removal of radiator caps |  |  | 3.8 | 3.8 |  | 3.8 | 3.8
9.   Harm from exposure to harmful energy due to        a. unintended activation of controls       b. failure to isolate and secure components with stored energy eg raised, slewed or articulated equipment |  |  |  |  |  | 3.9 | 3.9 | 3.9
10.  Harm from exposure to high pressure fluids as a result of failure of components, hoses, pipes or fittings due to:         a. Corrosion         b. Excessive pressure build up         c. Damage (eg from fallen material) |  |  |  | 3.1 |  |  |  |  | 3.1
Spreadsheet: 844aa489-d402-44ea-97d7-4a2161fb9d80
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
ANISP | Test | ANISP | Anisakis, Parasite, IgE | Anisakis, Parasite, 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
ANISP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ANISP | Result | ANISP | Anisakis, Parasite, IgE | Anisakis, Parasite, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10919-9 | [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 7cfee3c6-1d60-4190-bb0b-9db4d4346872
Sheet: Sheet1

Release: Non-Manufacturing ISM Report on Business | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=147
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-09-02 5:44 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Non-Manufacturing ISM Report on Business | 2007-12-05 00:00:00 | Current
Link:
http://www.ism.ws/ISMReport/ | 2007-12-05 00:00:00 | Current
Source:
Institute for Supply Management | 2007-12-05 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2007-12-05 00:00:00
2008-01-04 00:00:00
2008-01-29 00:00:00
2008-02-05 00:00:00
2008-03-05 00:00:00
2008-04-03 00:00:00
2008-05-05 00:00:00
2008-06-04 00:00:00
2008-07-03 00:00:00
2008-08-05 00:00:00
2008-09-04 00:00:00
2008-10-03 00:00:00
2008-11-03 00:00:00
2008-11-04 00:00:00
2008-11-05 00:00:00
2008-12-03 00:00:00
2009-01-06 00:00:00
2009-01-21 00:00:00
2009-02-04 00:00:00
2009-03-04 00:00:00
2009-04-03 00:00:00
2009-05-05 00:00:00
2009-06-03 00:00:00
2009-07-06 00:00:00
2009-08-05 00:00:00
2009-09-03 00:00:00
2009-10-05 00:00:00
2009-11-04 00:00:00
2009-12-03 00:00:00
2010-01-06 00:00:00
2010-01-27 00:00:00
2010-02-03 00:00:00
2010-03-03 00:00:00
2010-04-05 00:00:00
2010-05-05 00:00:00
2010-06-03 00:00:00
2010-07-06 00:00:00
2010-08-04 00:00:00
2010-09-03 00:00:00
2010-10-05 00:00:00
2010-11-03 00:00:00
2010-12-03 00:00:00
2011-01-05 00:00:00
2011-02-03 00:00:00
2011-03-03 00:00:00
2011-04-05 00:00:00
2011-05-04 00:00:00
2011-06-03 00:00:00
2011-07-06 00:00:00
2011-08-03 00:00:00
2011-09-06 00:00:00
2011-10-05 00:00:00
2011-11-03 00:00:00
2011-12-05 00:00:00
2012-01-05 00:00:00
2012-01-31 00:00:00
2012-02-03 00:00:00
2012-03-05 00:00:00
2012-04-04 00:00:00
2012-05-03 00:00:00
2012-06-05 00:00:00
2012-07-05 00:00:00
2012-08-03 00:00:00
2012-09-06 00:00:00
2012-10-03 00:00:00
2012-11-05 00:00:00
2012-12-05 00:00:00
2013-01-04 00:00:00
2013-02-05 00:00:00
2013-03-05 00:00:00
2013-04-03 00:00:00
2013-05-03 00:00:00
2013-06-05 00:00:00
2013-07-03 00:00:00
2013-08-05 00:00:00
2013-09-05 00:00:00
2013-10-03 00:00:00
2013-11-05 00:00:00
2013-12-04 00:00:00
2014-01-06 00:00:00
2014-02-05 00:00:00
2014-03-05 00:00:00
2014-04-03 00:00:00
2014-05-05 00:00:00
2014-06-04 00:00:00
2014-07-03 00:00:00
2014-08-05 00:00:00
Spreadsheet: 777950d1650719446-compare-and-copy-to-new-collumn-pete_uk-aligw
Sheet: Sheet1

Offer No1 |  |  |  |  |  |  | Offer No2
Part no | Name | Price |  |  |  |  | Part no | Name | Price
101 | [NAME] | 0.1 |  |  |  |  | 101 | [NAME]
102 | Nut | 0.1 |  |  |  |  | 202 | Valve
103 | Hexagon | 0.5 |  |  |  |  | 102 | Nut
104 | Screw | 0.15 |  |  |  |  | 2002 | Screwdiver
105 | Bolt & Nut | 0.2 |  |  |  |  | 105 | Bolt & Nut
106 | [NAME] | 0.8 |  |  |  |  | 106 | [NAME]
 |  |  |  |  |  |  | 1080 | Valve
Spreadsheet: 527ba242-e222-4243-a57f-02f4beba10ba
Sheet: Sheet1

Unintentional Nonfire Related Carbon Monoxide (CO) Poisoning  Emergency Department Visits by County and Public Health District, Maine, 2005-2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Number | Population | Rate  (per 100,000) | Age-adjusted Rate (per 100,000) | 95%CI
Maine | 628 | 6595043 | 9.5 | 9.9 | (9.1 - 10.6)
County
Androscoggin | 92 | 535822 | 17.2 | 18.1 | (14.7 - 22.1)
Aroostook | 23 | 361459 | 6.4 | 6.3 | (4.0 - 9.4)
Cumberland | 107 | 1379528 | 7.8 | 7.9 | (6.4 - 9.4)
Franklin | 17 | 149240 | 11.4 | 12.3 | (7.3 - 19.4)
Hancock | 26 | 267319 | 9.7 | 10.3 | (6.9 - 14.9)
Kennebec | 53 | 604942 | 8.8 | 9.0 | (6.8 - 11.7)
Knox | 14 | 204583 | 6.8 | 6.6 | (3.5 - 11.2)
Lincoln | 15 | 174478 | 8.6 | 8.7 | (4.8 - 14.3)
Oxford | 68 | 283465 | 24.0 | 25.8 | (20.2 - 32.5)
[NAME] | 51 | 741102 | 6.9 | 6.7 | (4.9 - 8.8)
Piscataquis | 9 | 86195 | 10.4 | 9.6 | (4.1 - 18.8)
Sagadahoc | 13 | 182909 | 7.1 | 8.2 | (4.6 - 13.5)
Somerset | 24 | 257898 | 9.3 | 9.7 | (6.3 - 14.3)
[NAME] | 19 | 192560 | 9.9 | 10.7 | (6.6 - 16.4)
Washington | 13 | 164093 | 7.9 | 7.1 | (3.7 - 12.5)
York | 84 | 1009450 | 8.3 | 8.6 | (6.9 - 10.6)
Public Health District
Aroostook | 23 | 361459 | 6.4 | 6.3 | (4.0 - 9.4)
Central | 77 | 862840 | 8.9 | 9.2 | (7.3 - 11.5)
Cumberland | 107 | 1379528 | 7.8 | 7.9 | (6.4 - 9.4)
Downeast | 39 | 431412 | 9.0 | 9.1 | (6.4 - 12.4)
[NAME] | 61 | 754530 | 8.1 | 8.6 | (6.6 - 11.0)
Penquis | 60 | 827297 | 7.3 | 7.0 | (5.3 - 9.0)
Western | 177 | 968527 | 18.3 | 19.3 | (16.5 - 22.0)
York | 84 | 1009450 | 8.3 | 8.6 | (6.9 - 10.6)
Data Source:  Maine Health Data Organization (MHDO) provided the data for this table.  The data were analyzed and table prepared by the Environmental Public Health Tracking Program.  Revision Date:  12/29/2011. Generated 4/5/2012.
This table includes only CO poisoning admissions that are identified as unintentional and are not related to a fire. Preliminary results are presented for Year 2009.  A statistical confidence interval (the column called "95%CI") is provided for the age-adjusted rate.
Spreadsheet: richard_sanders__31765__00-07-25-KW Bullet 1
Sheet: Sheet1

Data for Bullet points
Average 1999 Pool Price | 42.74 | [NAME]
Average Pool Price from 6/1 to 10/18 | 53.15 | [NAME]
Number of Hours from 6/1 to 10/18 | 3360 | Hours
Number of ENR/PWX transactions | 22 | Hours
Fraction of hours in period affected by ENR/PWX transactions
Total Pool volume from 6/1 to 10/18 | 19225140 | MWh
Total energy in ENR/PWX transactions | 1906 | MWh
ENR/PWX transactions as share of total traded volume in period
Number of hours Pool Price equalled of exceeded CAD100/MWh | 204 | Hours
Number of those hours involving ENR/PWX | 16 | Hours
Total value of Power Pool transactions from 6/1 to 10/18 | 1077 | Can$m
Total value of ENR/PWX transactions | 1.299 | Can$m
Spreadsheet: 222540d1363877827-need-help-with-master-posting-entire-line-of-data-for-a-value-on-different-sheet-urgent-fitness-plus-excel-project
Sheet: Master

Date | Catalog Number | Action Requested | Assigned | Completion Date | Notes
2013-01-02 00:00:00 | 12345 | change | Brittany | 2013-02-05 00:00:00
2013-01-03 00:00:00 | 12346 | change | Cleve | 2013-02-06 00:00:00
2013-01-04 00:00:00 | 12347 | move | Scott | 2013-02-07 00:00:00
2013-01-05 00:00:00 | 12348 | change | Brittany | 2013-02-08 00:00:00
2013-01-06 00:00:00 | 12349 | change | Cleve | 2013-02-09 00:00:00
2013-01-07 00:00:00 | 12350 | move | Scott | 2013-02-10 00:00:00
2013-01-08 00:00:00 | 12351 | change | Brittany | 2013-02-11 00:00:00
2013-01-09 00:00:00 | 12352 | change | Cleve | 2013-02-12 00:00:00
2013-01-10 00:00:00 | 12353 | move | Scott | 2013-02-13 00:00:00
Spreadsheet: 851894d1702023916-help-needed-with-a-formula-please-no-attendees-dummy-data-1-2-
Sheet: Dummy data

ID | Date | [NAME]? | [NAME] (Y/N)
1 | 2024-02-14 00:00:00 | to be Attended | N
1 | 2023-11-21 00:00:00 | Did not attend
1 | 2023-11-21 00:00:00 | Did not attend
1 | 2023-11-14 00:00:00 | Attended
2 | 2023-11-21 00:00:00 | Did not attend | Y
2 | 2023-10-21 00:00:00 | Cancelled
2 | 2023-09-14 00:00:00 | Attended
3 | 2023-11-12 00:00:00 | Cancelled | N
3 | 2023-10-12 00:00:00 | Attended
3 | 2023-09-12 00:00:00 | Did not attend
3 | 2023-08-12 00:00:00 | Cancelled
4 | 2023-02-01 00:00:00 | Cancelled | Y
4 | 2023-03-03 00:00:00 | Cancelled
4 | 2023-04-03 00:00:00 | Did not attend
4 | 2023-04-04 00:00:00 | Cancelled
5 | 2023-04-04 00:00:00 | Did not attend | Y
5 | 2023-03-03 00:00:00 | Cancelled
5 | 2023-02-02 00:00:00 | Cancelled
5 | 2023-01-22 00:00:00 | Did not attend
5 | 2023-01-01 00:00:00 | Attended
Spreadsheet: 469989d1468274712-average-sales-per-month-and-year-from-table-w-o-pivot-testbook
Sheet: Sheet2

 |  | Month | Year | Average Sales
 |  | June | 2014
 |  | July | 2014
 |  | August | 2014
 |  | September | 2014
 |  | October | 2014
 |  | November | 2014
 |  | December | 2014
 |  | January | 2015
 |  | February | 2015
 |  | March | 2015
 |  | April | 2015
 |  | May | 2015
 |  | June | 2015
 |  | July | 2015
 |  | August | 2015
 |  | September | 2015
 |  | October | 2015
 |  | November | 2015
 |  | December | 2015
 |  | January | 2016
 |  | February | 2016
 |  | March | 2016
 |  | April | 2016
 |  | May | 2016
 |  | June | 2016
 |  | July | 2016
 |  | August | 2016
 |  | September | 2016
 |  | October | 2016
 |  | November | 2016
 |  | December | 2016
Spreadsheet: 781268d1653119064-vlookup-not-working-book1
Sheet: Sheet2

Company Name | FEIN or TAX ID
3229809 [NAME] Scotia Company
3294027 Nova Scotia Limited
3308597 [NAME] Scotia Company
Dow Chemical Canada ULC
AgroFresh Belgium B.V.B.A.
Rayong Terminal Company Limited
Wacker Chemicals Fumed [NAME] (Zhangjiagang) Holding Co. Private Ltd.
Spreadsheet: chris_germany__2295__NewPower2001
Sheet: TRCO_Z6_TETC_M3

 | All volumes are monthly
 |  | Tetco M3 |  |  |  | Tetco M3 |  |  |  | Tetco M3 |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 | Month | Deal | Volume | Price |  | Deal | Volume | Price |  | Total | [NAME] |  | Deal | Volume | Price |  | Deal | Volume | Price |  | Deal | Volume | Price |  | Total | Bid
 | 2001-01-01 00:00:00 | 377251 | 3650 | NX1 + .59 |  | 377250 | 3015 | NX1 +.68 |  |  | NX1 = 1.75 |  | 377264 | 14568 | NX1 +.835 |  | 377268 | 145 | NX1 + .59 |  | N/A | 0 | 0 |  |  | NX1 + 1.80
 | 2001-02-01 00:00:00 | 377251 | 2900 | NX1 + .59 |  |  | 2395 | NX1 +.68 |  |  | NX1 = 1.55 |  |  | 14423 | NX1 +.835 |  |  | 144 | NX1 + .59 |  |  | 0 | 0 |  |  | NX1 + 1.65
 | 2001-03-01 00:00:00 | 377251 | 2563 | NX1 + .59 |  |  | 2117 | NX1 +.68 |  |  | NX1 = 1.105 |  |  |  |  |  |  | 142 | NX1 + .59 |  |  | 4407 | NX1 +.835 |  |  | NX1 + 1.20
 | 2001-04-01 00:00:00 | 377251 | 1318 | NX1 + .59 |  |  | 1089 | NX1 +.28 |  |  | NX1 = .45 |  |  |  |  |  |  | 141 | NX1 + .59 |  |  | 689 | NX1 +.455 |  |  | NX1 + .45
 | 2001-05-01 00:00:00 | 377251 | 686 | NX1 + .59 |  |  |  |  |  |  | NX1 = .42 |  |  |  |  |  |  | 139 | NX1 + .59 |  |  |  |  |  |  | NX1 + .42
 | 2001-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 138 | NX1 + .59 |  |  |  |  |  |  | NX1 + .42
 | 2001-07-01 00:00:00
 | 2001-08-01 00:00:00
 | 2001-09-01 00:00:00
 | 2001-10-01 00:00:00
 | 2001-11-01 00:00:00
 | 2001-12-01 00:00:00
 | 2002-01-01 00:00:00
 | 2002-02-01 00:00:00
 | 2002-03-01 00:00:00
Spreadsheet: kate_symes__18097__Deal Correction 12-12
Sheet:  Prior Day

Adjustment date | Date of applied calc | Deal Date | Desk | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
2000-12-11 00:00:00 | 2000-12-11 00:00:00 | 2000-11-29 00:00:00 | LTNW | MS | Houston | TFS | Added broker fee | Enpower Deal Blotter defaults | 469388 | SP-15 | Q3-01 | RTC | 50 | 127.5 | So-Cal Edison
2000-12-11 00:00:00 | 2000-12-11 00:00:00 | 2000-12-08 00:00:00 | LTNW | MS | Houston | TFS | Broker: to TFS |  | 477087 | PV | Cal-01 | [NAME] | 25 | 100 | Pinnacle West
 |  |  | MS Count
 |  |  | Grand Count