tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1432b630-a0c1-47e2-b3a9-bb734d08d6fb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 2. GOODS AND SERVICES, Summary: Original, Current prices
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Balance on goods and services ; |  |  | Original | A2717903C | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Credits, Total goods and services ; |  |  | Original | A2717883F | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Credits, Total goods ; |  |  | Original | A2717881A | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Credits, Rural goods ; |  |  | Original | A2717884J | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Credits, Non-rural goods ; |  |  | Original | A2717931L | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Credits, Net exports of goods under merchanting ; |  |  | Original | A2718034F | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Credits, Non-monetary gold ; |  |  | Original | A2718037L | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Credits, Total services ; |  |  | Original | A2718332C | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Debits, Total goods and services ; |  |  | Original | A2717891F | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Debits, Total goods ; |  |  | Original | A2718054R | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Debits, Consumption goods ; |  |  | Original | A2718056V | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Debits, Capital goods ; |  |  | Original | A2718126R | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Debits, Intermediate and other merchandise goods ; |  |  | Original | A2718182J | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Debits, Non-monetary gold ; |  |  | Original | A2718320V | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
Debits, Total services ; |  |  | Original | A2718454A | 1971-07-01 00:00:00 | 2012-01-01 00:00:00 | 487 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 585057d1533591571-ref-question-monday-reporting-
Sheet: Y01 YeeRah

End Of Week Report
Week Ending |  |  |  |  |  | Total
Sales Actual
Budget Sales
Last Year
Difference
LFL
Sales Issues & Focus  this Week
 | 1 Week | 2 Week | 3 Week | 4 Week | Total | 5 Week | Total
R9 POS Sales
Stock Actual
Stock Theoretical
Difference
[NAME]
Available
Actual
Over/Under
Stock Issues & Focus  this Week
Labour Actual
Labour Target
Difference
Available
Actual
Over/Under
Labour Issues & Focus  this Week
NPS FIB
Review Rating % FIB
Service issues, focus  this week & any other notable points
Spreadsheet: 4afba096-719e-4a21-a533-b52a33f3ac6a
Sheet: Sheet1

Adults Ages 18 Year and Over With 6 or More Teeth Lost Due to [NAME] or Gum Disease,  by Race, Ethnicity and Sexual Orientation, Maine 2002, 2004, 2005, 2006, 2008, 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Year | Unweighted Number |  | Weighted Number |  | % | LCL |  | UCL
2002 | 632 |  | 235963.1031174461 |  | 24.29077517411709 | 22.42865465000051 |  | 26.15289569823367
2004 | 880 |  | 214563.7270419912 |  | 21.12922600269029 | 19.62888729855434 |  | 22.62956470682624
2005 | 920 |  | 203694.518232997 |  | 21.08245922395912 | 19.63553817463367 |  | 22.52938027328457
2006 | 978 |  | 213382.4827729211 |  | 20.59250493492002 | 19.20458050925593 |  | 21.9804293605841
2008 | 1757 |  | 197956.4056762479 |  | 19.02736565897509 | 18.00556565324668 |  | 20.0491656647035
2010 | 2203 |  | 203980.940002869 |  | 19.68919175073596 | 18.6602589050466 |  | 20.71812459642531
Data Source: Behavioral Risk Factor Surveillance System Based on permanent teeth removed because of tooth decay or gum disease, not including teeth lost for other reasons, such as injury or orthodontics.  %= Weighted percentage of respondents LCL= Lower 95% confidence level of the weighted percentage UCL= Upper 95% confidence level of the weighted percentage
Spreadsheet: 02930df3-640c-49ee-87dd-be9565781f1c
Sheet: Sheet1

Set-up and Assumptions | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Current Service
Enter the number of male patients referred for Invasive Urodynamics per annum where the referral question is BOO |  |  |  |  |  |  |  |  |  |  |  | 400
Enter the standard tariff charged to SHAs for the performance of Urodynamic tests (£) |  |  |  |  |  |  |  |  |  |  |  | 425
Potential reduction in the number of Urodynamic studies (%) |  |  |  |  |  |  |  |  |  |  |  | 0.12
Number of Non-Invasive Cuff tests performed per annum |  |  |  |  |  |  |  |  |  |  |  | 400
Staff costs
Annual gross salary of person performing Non-Invasive Cuff tests |  |  |  |  |  |  |  |  |  |  |  | 30000
Inclusive of On-costs (pension, expenses, sickness pay etc - multiplication factor 1.8) |  |  |  |  |  |  |  |  |  |  |  | 54000
Working time (hrs) |  |  |  |  |  |  |  |  |  |  |  | 1575
Cost per hour to employ member of staff |  |  |  |  |  |  |  |  |  |  |  | 34.28571428571428
Time take to perform test including allocation for training (hours) |  |  |  |  |  |  |  |  |  |  |  | 0.5
Staff Cost per test |  |  |  |  |  |  |  |  |  |  |  | 17.14285714285714
Consumable Costs
Cost of single use Non-Invasive Cuff (Including VAT) |  |  |  |  |  |  |  |  |  |  |  | 7.6
Infections following on from Invasive Urodynamics
Estimated Infection rate following full Invaisve Urodynamics |  |  |  |  |  |  |  |  |  |  |  | 0.038
Cost to treat Invasive Urodynamics |  |  |  |  |  |  |  |  |  |  |  | 1320
NB All boxes require user input
19
Spreadsheet: 1bfe6a41-0746-44d1-9445-df2f42e9c974
Sheet: Sheet1

Cigarette Smoking Prevalence by SEC:2001-2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Prevalence Percentage, By Socio-Economic Classification, Great Britain
[NAME]-economic classification | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
Managerial and professional | 19 | 19 | 18 | 19 | 17 | 15 | 15 | 14 | 15 | 13 | 13 | 14
Intermediate | 27 | 26 | 26 | 24 | 23 | 21 | 20 | 21 | 19 | 20 | 20 | 20
Routine and manual | 33 | 31 | 32 | 31 | 31 | 29 | 26 | 29 | 28 | 28 | 28 | 33
Please include the citation provided in our Frequently Asked Questions when reproducing this chart: http://info.cancerresearchuk.org/cancerstats/faqs/#How
Prepared by Cancer Research UK
Original data sources:
1. Data for 2012 onwards: Office for National Statistics. Opinions and [NAME]. Available from http://www.ons.gov.uk/ons/rel/ghs/opinions-and-lifestyle-survey/index.html.
2. Data for 2001-2011: Office for National Statistics. General [NAME], 2011. Available from [NAME].
Spreadsheet: 781987d1653667628-date-time-group-dtg-formulas-3-dtg-formulas
Sheet: DTG #1 Decimal Seconds

 |  |  | Start Time | End Time | Formula #1 Time Transpired (In Minutes) | Formula #2 Time Transpired (In Minutes) | Formula #3 Time Transpired (In Minutes) | Time Greater Than 60 min? | Duration in Hours & Minutes | [mm]:ss
JAN | 1 |  | 170340Z Mar21 | 170359Z Mar21 |  |  |  |  |  |  | START Time |  |  |  | END Time
FEB | 2 |  | 170340.2Z Mar21 | 170359.6Z Mar22 |  |  |  |  |  |  | DDhhmm.s MMMYY |  |  |  | DDhhmm.s | MMM YR
MAR | 3 |  | 170340.2Z Mar21 | 170359.6Z Mar21 |  |  |  |  |  |  | 012345.3 APR 22 |  |  |  | 100130.2 APR 22
APR | 4 |  | 170340Z Apr22 | 010359Z May22
MAY | 5 |  | 170340.2Z Mar24 | 010359.2Z May23 |  |  |  |  |  |  | =UPPER(TEXT($I$4&$J$4*24,"dd hhmmZ mmm yy")) |  |  |  | =UPPER(TEXT($M$4&$N$4*24,"ddhhmmZ mmm yy"))
JUN | 6 |  |  |  |  |  |  |  |  |  | =TEXT($I$4&$J$4*24,"dd hhmmZ mmm yy") |  |  |  | =TEXT($M$4&$N$4*24,"ddhhmmZ mmm yy")
JUL | 7 |  | 271022.2Z MAY22 | 271123.3Z MAY22
AUG | 8 |  |  |  |  |  |  |  |  |  | =DATE(RIGHT(I4,2),VLOOKUP(LEFT(J4,3),{"Jan",1;"Feb",2;"Mar",3;"Apr",4;"May",5;"Jun",6;"Jul",7;"Aug",8;"Sep",9;"Oct",10;"Nov",11;"Dec",12},2,0),LEFT(I4,2))+TEXT(RIGHT(I4,4),"00\:00")
SEP | 9
OCT | 10
NOV | 11
DEC | 12
Spreadsheet: 99214d1297928839-circular-reference-and-its-solution-copy2-of-excelforum-help
Sheet: Sheet1 (with data)

T1 | T2 | Demand | Capacity | [NAME] (demand - capacity) | Queued vehicles
0 | 1 | 350 | 3000 | -2650 | 0
1 | 2 | 250 | 3000 | -2750 | 0
2 | 3 | 200 | 3000 | -2800 | 0
3 | 4 | 300 | 3000 | -2700 | 0
4 | 5 | 900 | 3000 | -2100 | 0
5 | 6 | 2200 | 3000 | -800 | 0
6 | 7 | 3100 | 3000 | 100 | 100
7 | 8 | 3600 | 3000 | 600 | 700
8 | 9 | 2800 | 3000 | -200 | 500
9 | 10 | 2500 | 3000 | -500 | 0
10 | 11 | 2400 | 3000 | -600 | 0
11 | 12 | 2550 | 3000 | -450 | 0
12 | 13 | 2650 | 3000 | -350 | 0
13 | 14 | 2750 | 3000 | -250 | 0
14 | 15 | 2800 | 3000 | -200 | 0
15 | 16 | 3200 | 3000 | 200 | 200
16 | 17 | 3500 | 3000 | 500 | 700
17 | 18 | 3200 | 3000 | 200 | 900
18 | 19 | 2950 | 3000 | -50 | 850
19 | 20 | 2450 | 3000 | -550 | 300
20 | 21 | 2000 | 3000 | -1000 | 0
21 | 22 | 1500 | 3000 | -1500 | 0
22 | 23 | 1050 | 3000 | -1950 | 0
23 | 24 | 800 | 3000 | -2200 | 0
Spreadsheet: lynn_blair__24423__Mid13_Demarc
Sheet: Summary

 | Gas Daily | Btu Daily GW | Difference
2000-09-01 00:00:00 | 4.921 | 4.921 | 0.0001
2000-10-01 00:00:00 | 4.969 | 4.964 | 0.0043
2000-11-01 00:00:00 | 5.284 | 5.29 | -0.0059
2000-12-01 00:00:00 | 9.009 | 9.043 | -0.0347
2001-01-01 00:00:00 | 8.131 | 8.116 | 0.015
2001-02-01 00:00:00 | 5.665 | 5.664 | 0.0014
2001-03-01 00:00:00 | 5.091 | 5.088 | 0.003
2001-04-01 00:00:00 | 5.019 | 5.017 | 0.002
2001-05-01 00:00:00 | 4.014 | 4.018 | -0.004
2001-06-01 00:00:00 | 3.465 | 3.451 | 0.014
2001-07-01 00:00:00 | 2.905 | 2.899 | 0.005
2001-08-01 00:00:00 | 2.823 | 2.817 | 0.006
2001-09-01 00:00:00 | 2.061 | 2.056 | 0.005
Spreadsheet: debra_perlingiere__8510__JD Irving
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
 | ENA | ATTORNEY:
DATE: | 2000-12-06 00:00:00 | ECT CONTACT: | [NAME]
COUNTERPARTY: | J.D. Irving, Limited | CONTACT: | [NAME]
ADDRESS: | 300 Union St. | TITLE:
 | [NAME], NB  E2L 4M3
 | Canada | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ECT ENTITY
COLLATERAL
THRESHOLD  in US$ | 0 | 10
COMMITTED VOLUMES
THRESHOLD in $[NAME] | n/a | n/a
COLLATERAL REQUIRED FOR:
ALL TRADES | n/a | n/a
OTHER
COLLATERAL TYPE
Letter of Credit | x | x
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) |  | Enron Corp. (BBB+)
LIMIT in $[NAME] | n/a | 10
Incorporation State: |  | Oregon
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty | X
-Guarantor |  | X
Debt Ratings Change |  | X
-Below = S&P |  | BBB-
Financial Covenants
-Funded Debt/Equity
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific | X
-Unilateral | X
Ownership Change
-Less than 50.8% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME])
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
OTHER COMMENTS:  Contract should include also include an independent amount specification of $500M
CREDIT REVIEW  PREPARED BY: |  | B. Reves | x-9897
Spreadsheet: 2a9e6075-4ff7-49d4-b0ef-69d81306ecec
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
FCLON | Test | FCLON | Clonidine (Catapres) | Clonidine (Catapres) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 5 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s). ([NAME] is not acceptable.) Spin down and send 5 mL  of sodium heparin plasma refrigerated. Note:	1. Trough levels are most reproducible. 	  2. Indicate plasma on request form. 	3. Label specimen appropriately (plasma).   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 5 mL of serum refrigerated. Note:	1. Trough levels are most reproducible. 	  2. Indicate serum on request form. 	3. Label specimen appropriately (serum). | 1.2 mL Note: Submission of the m | Specimens other than	Plasma, serum Anticoagulants other than	Sodium heparin, EDTA, plain red-top Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | [NAME]: 1.00 - 2.00 ng/mL   Sedation has been associated with serum clonidine concentrations greater than 1.5 ng/mL   Toxic concentration has not been established.   Test Performed By: Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FCLON | Result | Z1184 | Clonidine | Clonidine | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 692648d1598475598-need-formula-to-create-performance-chart-of-employees-sales-related-salesman-perfomance-report-july-and-aug-20-eba
Sheet: Sheet1

S.No | Sales Perfomance Report 23-Aug-20
 | Salesman | Sales | No of Days | Percentage
1
2
3
4
5
6
7
8
9
10
11
12
13
Spreadsheet: 790012d1659496697-distribute-the-amount-based-on-day-difference-if-date-condition-met-true-amount-distributor-1-
Sheet: Sheet1

Recovery Period From | 2020-10-17 00:00:00 | To | 2021-04-25 00:00:00
Exemption Period From | 2021-06-22 00:00:00 | To | 2021-10-01 00:00:00 |  | R
Amount | Recovery | Exemption | Date |  |  |  | Day Diff. of Dates | Day of Recovery | Days of Exemption
430 |  |  | 2020-09-19 00:00:00
528.08 |  |  | 2020-10-13 00:00:00
1252.08 |  |  | 2020-11-20 00:00:00 |  |  |  |  |  |  |  | 2021-10-17 00:00:00 | 2021-10-18 00:00:00 | 2021-10-19 00:00:00 | 2021-10-20 00:00:00
864.08 |  |  | 2020-12-14 00:00:00
854.09 |  |  | 2021-01-09 00:00:00
995.07 |  |  | 2021-02-12 00:00:00
628.11 |  |  | 2021-03-02 00:00:00
686.83 |  |  | 2021-03-27 00:00:00
791.2 |  |  | 2021-04-26 00:00:00 |  |  |  |  |  |  |  | 2021-04-25 00:00:00
718.04 |  |  | 2021-05-25 00:00:00
727 |  |  | 2021-06-25 00:00:00 |  |  |  |  |  |  |  | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00
5812.24 |  |  | 2021-07-24 00:00:00
7404.36 |  |  | 2021-08-26 00:00:00
6131.32 |  |  | 2021-09-27 00:00:00
5814.71 |  |  | 2021-10-30 00:00:00 |  |  |  |  |  |  |  | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00 | 2021-10-01 00:00:00
4130.82 |  |  | 2021-12-01 00:00:00
 | >> Figures shown in Green Cells (Cell B5:C20) I want generate using formula. |  |  |  |  |  | >> Calculation show in yellow cells (F4:M20) are only for your understanding and explain my point of view.
Spreadsheet: 116250d1311699435-hiding-columns-with-no-value-in-pivot-chart-s-886
Sheet: Summary

Start Date | 2011-01-01 00:00:00 | Blank Costs | 11 |  | Old Tool
[NAME]) | 3000 | Total Costs (Old) | 35 |  | Fabrication / Hour |  | 30
[NAME] (New) | 20000 | Cost New | 51.19 |  | Tools / Shift |  | 10
EAV Projected 2011 | 854596 | Total Costs (New) | 51.19 |  | Fabrication / Tool |  | 24
 |  |  |  |  | New Tool
 |  |  |  |  | Fabrication / Hour
 |  |  |  |  | Tools / Shift
Total Savings | 7790.02 |  |  |  | Fabrication / Tool |  | 0
Spreadsheet: 726575d1617299681-sumifs-issue-template
Sheet: MAR

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-03-15 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 25
Spreadsheet: 851216d1701442635-vlookup-formula-or-let-sample-data-for-lookup-2-
Sheet: Lookup

Movement # | VENDER LOCATION ID 1 | VENDER NAME 1 | VENDER LOCATION ID 2 | VENDER NAME 2
690570 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z003
691724 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z003
710693 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z006
715310 |  | VENDOR-Z006 | [PHONE] | VENDOR-Z009
719458 |  | VENDOR-Z006 | [PHONE] | VENDOR-Z005
727931 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z001
732314 |  | VENDOR-Z006 | [PHONE] | VENDOR-Z003
733287 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z000
734341 |  | VENDOR-Z002 | [PHONE] | VENDOR-Z009
1005451507 | 3007535 | VENDOR-Z002 | 3008555 | VENDOR-Z003
Spreadsheet: 55391d1255517801-changes-to-all-worksheets-asa2-analysis-sheet-prototype-
Sheet: 12AS Grades

S/name | Name | T/G | Staff | Jan-09 Unit 1 | Jun-09 Unit 2 | Jan-10 Unit 1 | Jun-10 Unit 1 | Jun-09 Unit 2 | Jan-10 Unit 2 | Jun-10 Unit 2 | Jun-09 Unit 3 | Jan-10 Unit 3 | Jun-10 Unit 3 | Total | Grade
[NAME] | Bloggs 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | [NAME] | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 3 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 4 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 5 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | [NAME] 6 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 7 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 8 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 9 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
[NAME] | Bloggs 10 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | U
Count= | 10
Name | S/name |  |  | Overall grade | AS min target | AS asp target |  | Results Summary
[NAME] | Bloggs 1 |  |  | U | 0 | 0
[NAME] | [NAME] |  |  | U | 0 | 0 |  |  | Total no grade A's = | 0
[NAME] | Bloggs 3 |  |  | U | 0 | 0 |  |  | Total no grade B's = | 0
[NAME] | Bloggs 4 |  |  | U | 0 | 0 |  |  | Total no grade C's = | 0
[NAME] | Bloggs 5 |  |  | U | 0 | 0 |  |  | Total no grade D's = | 0
[NAME] | [NAME] 6 |  |  | U | 0 | 0 |  |  | Total no grade E's = | 0
[NAME] | Bloggs 7 |  |  | U | 0 | 0 |  |  | Total no grade U's = | 10
[NAME] | Bloggs 8 |  |  | U | 0 | 0
[NAME] | Bloggs 9 |  |  | U | 0 | 0
[NAME] | Bloggs 10 |  |  | U | 0 | 0
Spreadsheet: 841516d1693696593-using-sumproduct-to-return-values-based-on-criteria-when-date-filter-changes-excel-formula-09-01-2023-bvj-
Sheet: pivot table examples

B Cases (by account) | Sum of # of Days to [NAME] | Average of # of Days to [NAME] | Cases per Owner |  |  |  | B Cases (By agent) | Number of Requests | Days to [NAME] Per account type
Account Creation | 75 | 9.375 | 8 |  |  |  | [NAME]
[NAME] | 31 | 10.33333333333333 | 3 |  |  |  | Account Creation | 3 | 30
[NAME] | 8 | 8 | 1 |  |  |  | Account Revision/Updates | 2 | 19
[NAME] | 36 | 9 | 4 |  |  |  | [NAME]
Account Revision/Updates | 33 | 11 | 3 |  |  |  | Account Creation | 1 | 0
[NAME] | 27 | 13.5 | 2 |  |  |  | Web Support/SCT | 2 | 9
[NAME] | 6 | 6 | 1 |  |  |  | [NAME]
Web Support/SCT | 10 | 5 | 2 |  |  |  | Account Creation | 4 | 21
[NAME] | 10 | 5 | 2 |  |  |  | Account Revision/Updates | 1 | 8
 |  |  |  |  |  |  | Grand Total | 13 | 87
MM Cases | Sum of # of Days to [NAME] | Count of Case Owner
Account Creation | 60 | 14
[NAME] | 18 | 5
[NAME] | 16 | 3
[NAME] | 7 | 1
[NAME] | 19 | 5
Account Revision/Updates | 38 | 8
[NAME] | 19 | 3
[NAME] | 10 | 1
[NAME] | 7 | 3
WholWorth | 2 | 1
Web Support/SCT | 37 | 6
[NAME] | 37 | 6
Grand Total | 135 | 28
Spreadsheet: 765978d1643708456-sumifs-with-date-and-time-criteria-rainfall-test-2
Sheet: Rainfall 15 min sum

Date and Time | Rainfall in 15 minutes ([NAME]) |  | Manual Calculation
2019-05-02 16:00:00 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 1.2
 |  |  | 0.6
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0.4
 |  |  | 0.2
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: andy_zipper__181__DYNEGY-ICE VOL May11
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  May-11-01 thru May-11-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
May-11-01 | 992858305 |  | Bought | NG [NAME], ID, GDD | [NAME] (NY) | Next Day Gas | May-12-01 | May-14-01 |  |  |  | AEP Energy Services, Inc. | 0.0075 | USD / MMBtu | 35000 | Daily | 105000 | MMBtus | Pimenov, V
May-11-01 | 169242249 |  | Sold | NG [NAME], ID, GDD | TET M3 | Next Day Gas | May-12-01 | May-14-01 |  |  |  | Mirant Americas Energy Marketing, LP | 0 | USD / MMBtu | 10000 | Daily | 30000 | MMBtus | Pimenov, V
May-11-01 | 647422141 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | El Paso Merchant Energy L.P. | 4.43 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
May-11-01 | 174540473 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | AEP Energy Services, Inc. | 4.43 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
May-11-01 | 109868782 |  | Sold | NG Fin BS, LD1 for IF | Perm | Q3 01 | Jul-01-01 | Sep-30-01 |  |  |  | Duke Energy Trading and Marketing LLC | 0.05 | USD / MMBtu | 5000 | Daily | 460000 | MMBtus | [NAME] ,
May-11-01 | 212221527 |  | Sold | NG [NAME], ID, GDD | [NAME] (NY) | Custom | May-12-01 | May-15-01 |  |  |  | Aquila Energy Marketing Corp | 0 | USD / MMBtu | 5000 | Daily | 20000 | MMBtus | Pimenov, V
May-11-01 | 113155446 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | Duke Energy Trading and Marketing LLC | 4.14 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
May-11-01 | 112559960 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | El Paso Merchant Energy L.P. | 4.395 | USD / MMBtu | 2500 | Daily | 912500 | MMBtus | [NAME], J
May-11-01 | 171709709 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | El Paso Merchant Energy L.P. | 4.385 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
May-11-01 | 178415145 |  | Sold | NG [NAME], FP | TET M3 | Next Day Gas | May-12-01 | May-14-01 |  |  |  | Reliant Energy Services, Inc. | 4.51 | USD / MMBtu | 5000 | Daily | 15000 | MMBtus | Pimenov, V
May-11-01 | 202026786 |  | Bought | NG Fin, FP for LD1 | [NAME] | Cal 03 | Jan-01-03 | Dec-31-03 |  |  |  | El Paso Merchant Energy L.P. | 4.12 | USD / MMBtu | 20000 | Daily | 7300000 | MMBtus | [NAME], J
May-11-01 | 915568548 |  | Bought | NG Fin, FP for LD1 | [NAME] | [NAME] | Jun-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 4.3875 | USD / MMBtu | 5000 | Daily | 765000 | MMBtus | [NAME], J
May-11-01  Deals