tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 184164d1349170999-calculating-the-number-of-days-0a1_fot_example2-1-2-
Sheet: Sheet2

Route | Exercise | Type | Day | Month | Wk | Distance (Miles) | Time (mins sec) | Run No. This Year TOTAL | Days Since Last Run | Total Weeks Run Miles | Cycle No. This Year TOTAL | Days Since Last Cycle | Total Weeks Cycle Miles
Track 2x500m, 3x1k, 2x500m | Run | Reps | Tue | 2012-09-25 00:00:00 | 39 | 4.97 | 35.11 | 4 | 5 | 4.97 | 0 |  | 0 | MATCH(B2;B3:$B$8;0)
Torquay-Newton Abbot | Cycle | Ride | Sat | 2012-09-22 00:00:00 | 38 | 14.03 | 67.12 | 3 | 5 | 11.81 | 2 | 10 | 26.35 | 3
Track Pyramid | Run | Reps | Thu | 2012-09-20 00:00:00 | 38 | 5.64 | 49.4 | 3 | 2 | 11.81 | 2 |  | 26.35 | 1
Track 2x1 mile, 3x800m, 4x400m | Run | Reps | Tue | 2012-09-18 00:00:00 | 38 | 6.17 | 49.36 | 2 | 2 | 11.81 | 2 |  | 26.35 | 2
Home-Paignton | Cycle | Ride | Mon | 2012-09-17 00:00:00 | 38 | 12.32 | 45.12 | 1 | 3 | 11.81 | 2 | 15 | 26.35 | 2
[NAME] | Run | Run | Sun | 2012-09-16 00:00:00 | 37 | 14.52 | 117.18 | 1 |  | 14.52 | 1 |  | 5.22 | #N/A
[NAME] | Cycle | Ride | Fri | 2012-09-14 00:00:00 | 37 | 5.22 | 36.45 | 0 | 0 | 14.52 | 1 | 18 | 5.22 | 1
 |  |  |  |  |  |  |  |  | 5
 | Exercise | Type | Day | Month | Wk | Distance (Miles) | Time (mins sec) | Run No. This Year TOTAL | Days Since Last Run | Total Weeks Run Miles | Cycle No. This Year TOTAL | Days Since Last Cycle | Total Weeks Cycle Miles
 | Run | Reps | Tue | 2012-09-25 00:00:00 | 39 | 4.97 | 35.11 | 4 | 5 | 4.97 | - | - | -
 | Cycle | Ride | Sat | 2012-09-22 00:00:00 | 38 | 14.03 | 67.12 | - | - | - | 3 |  | 26.35
 | Run | Reps | Thu | 2012-09-20 00:00:00 | 38 | 5.64 | 49.4 | 3 | 2 | 11.81 | - | - | -
 | Run | Reps | Tue | 2012-09-18 00:00:00 | 38 | 6.17 | 49.36 | 2 | 2 | 11.81 | - | - | -
 | Cycle | Ride | Mon | 2012-09-17 00:00:00 | 38 | 12.32 | 45.12 | - | - | - | 2 |  | 26.35
 | Run | Run | Sun | 2012-09-16 00:00:00 | 37 | 14.52 | 117.18 | 1 |  | 14.52 | - | - | -
 | Cycle | Ride | Fri | 2012-09-14 00:00:00 | 37 | 5.22 | 36.45 | - | - | - | 1 | 0 | 5.22
Spreadsheet: benjamin_rogers__1049__Consolidated 6 Peaker-051800-PE
Sheet: Power Price Assumption

POWER PRICE ASSUMPTION
 |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FIXED PRICE PERIOD
 | Fixed Price Demand Charge ($/kW-month) |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MERCHANT PRICE PERIOD
ICF Capacity Price Escalator
TVA Capacity Curves:
(for Brownsville, Caledonia, New Albany and Gleason)
1998 $
 | ICF Base ($/kW-year) |  | 60.97229916897507 | 62.13174241580138 | 63.31323352142478 | 64.51719174576061 | 65.74404432132964 | 64.64769576191091 | 63.56962992568251 | 62.50954192970881 | 61.46713197528612 | 60.44210526315789 | 59.7920389893765 | 59.14896430131946 | 58.51280600315997 | 57.88348970781654 | 57.26094182825485 | 56.38631795268188 | 55.52505339149143 | 54.67694408979114 | 53.84178910949526 | 53.01939058171745
Nominal $
 | ICF Base ($/kW-year )
 | ICF Base ($/kW-month)
TVA Plants' Capacity Price Curve
Southern ECAR Capacity Curves:
(for Wheatland)
1998 $
 | ICF Base ($/kW-year) |  | 63.67765957446809 | 65.10077977694303 | 66.55570502885331 | 68.04314613534935 | 69.56382978723404 | 68.90950818778056 | 68.26134117695196 | 67.61927086431456 | 66.98323990395568 | 66.3531914893617 | 65.24668478364941 | 64.15863019851045 | 63.08872002613617 | 62.03665169005747 | 61.00212765957447 | 60.12086017238765 | 59.25232391956542 | 58.39633497927836 | 57.55271208672454 | 56.72127659574468
Nominal $
 | ICF Base ($/kW-year )
 | ICF Base ($/kW-month)
Wheatland Capacity Price Curve
Com Ed Capacity Curves:
(for Wilton Center)
1998 $
 | ICF Base ($/kW-year) |  | 64.11023686899189 | 65.16178520495788 | 66.23058123734297 | 67.31690786615431 | 68.42105263157895 | 67.76722835163707 | 67.11965194676579 | 66.47826371293745 | 65.84300451664971 | 65.21381578947368 | 64.55936411358543 | 63.91148017171007 | 63.27009805351133 | 62.63515251009445 | 62.00657894736842 | 61.12669629598323 | 60.25929931133455 | 59.40421081993954 | 58.56125616243361 | 57.73026315789474
Nominal $
 | ICF Base ($/kW-year )
 | ICF Base ($/kW-month)
Wilton Capacity Price Curve |  |  | 4 | 4 | 4
Spreadsheet: 48461116-a936-4a3b-968d-304cb59ae6c3
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
 | 5671.0 Lending Finance, Australia
 | TABLE 38. LEASE FINANCE COMMITMENTS, By Purpose: State (ACT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413863F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413864J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413865K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413866L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413868T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413869V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413870C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413871F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413872J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413873K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413874L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413875R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413876T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413877V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413878W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: FIJ

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
FIJI WATER 12/1.5L | 09055
FIJI WATER 12/1L | 09054
FIJI WATER 12/700ML | 09053
FIJI WATER 24/500ML | 09052
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
FIJI WATER 12/1.5L | 09055
FIJI WATER 12/1L | 09054
FIJI WATER 12/700ML | 09053
FIJI WATER 24/500ML | 09052
Spreadsheet: 164837d1340904477-excel-2007-how-to-count-if-multiple-criteria-occurs-example1
Sheet: Sheet1

user | date | successful
user 1 | 2012-05-14 00:00:00 | y
user 2 | 2012-05-15 00:00:00 | y
user 1 | 2012-05-16 00:00:00 | y
user 1 | 2012-05-17 00:00:00 | y
user 1 | 2012-05-18 00:00:00 | y
user 1 | 2012-05-19 00:00:00 | n
user 1 | 2012-05-20 00:00:00 | n
user 1 | 2012-05-21 00:00:00 | n
user2 | 2012-05-22 00:00:00 | n
user2 | 2012-05-23 00:00:00 | n
user2 | 2012-05-24 00:00:00 | y
user2 | 2012-05-25 00:00:00 | y
user2 | 2012-05-26 00:00:00 | n
user2 | 2012-05-27 00:00:00 | y
user2 | 2012-05-28 00:00:00 | y
user2 | 2012-05-29 00:00:00 | n
user2 | 2012-05-30 00:00:00 | n
user2 | 2012-05-31 00:00:00 | y
user2 | 2012-06-01 00:00:00 | n
user2 | 2012-06-02 00:00:00 | y
user2 | 2012-06-03 00:00:00 | n
user2 | 2012-06-04 00:00:00 | y
user2 | 2012-06-05 00:00:00 | y
user2 | 2012-06-06 00:00:00 | n
user2 | 2012-06-07 00:00:00 | n
user2 | 2012-06-08 00:00:00 | y
user2 | 2012-06-09 00:00:00 | n
user2 | 2012-06-10 00:00:00 | y
user 1 | 2012-06-11 00:00:00 | y
user 1 | 2012-06-12 00:00:00 | y
user 1 | 2012-06-13 00:00:00 | n
user 1 | 2012-06-14 00:00:00 | y
user 1 | 2012-06-15 00:00:00 | y
user 1 | 2012-06-16 00:00:00 | y
user 1 | 2012-06-17 00:00:00 | n
user 1 | 2012-06-18 00:00:00 | y
user 1 | 2012-06-19 00:00:00 | n
user 1 | 2012-06-20 00:00:00 | n
user 1 | 2012-06-21 00:00:00 | y
user3 | 2012-06-22 00:00:00 | n
user3 | 2012-06-23 00:00:00 | y
user3 | 2012-06-24 00:00:00 | y
user3 | 2012-06-25 00:00:00 | y
user3 | 2012-06-26 00:00:00 | n
user3 | 2012-06-27 00:00:00 | y
user3 | 2012-06-28 00:00:00 | y
user3 | 2012-06-29 00:00:00 | y
user3 | 2012-06-30 00:00:00 | n
user3 | 2012-07-01 00:00:00 | y
user3 | 2012-07-02 00:00:00 | n
user3 | 2012-07-03 00:00:00 | n
user3 | 2012-07-04 00:00:00 | y
user3 | 2012-07-05 00:00:00 | n
user3 | 2012-07-06 00:00:00 | y
user3 | 2012-07-07 00:00:00 | y
user3 | 2012-07-08 00:00:00 | y
user3 | 2012-07-09 00:00:00 | n
Spreadsheet: drew_fossum__8711__redrock n
Sheet: INCREMENTAL DEPR. EXPENSE

 |  |  |  |  |  |  |  |  |  |  |  |  | Exhibit N
 |  |  |  |  |  |  |  |  |  |  |  |  | Page  3 of 7
Estimated   Incremental   Depreciation    Expense
 |  |  |  | Months in
Line |  |  |  | Service
No. |  | Description |  | Year 1 | Year   1 |  | Year  2 |  | Year  3 |  | Year  4 |  | Year  5 |  | Year  6 |  | Year  7 |  | Year  8 |  | Year  9 |  | Year  10
 |  |  |  |  | -1 |  | -2 |  | -3 |  | -4 |  | -5 |  | -6 |  | -7 |  | -8 |  | -9 |  | -10
 |  | Rate    1/
1 |  | Depreciation   Rate |  |  | 0.012
2 |  | Capital   Investments
3 |  | Compression   Facilities
4 |  | Town Border Stations
5 |  | Main Line Extension
6 |  | Pipeline  Tie Over
7 |  | Branch Line Loops
8 |  | Total
9 |  | Less: Plant Retired
 |  | Depreciation   and
 |  | Amortization   Expense
10 |  | Depreciation - @ 1.20%
11 |  | Less: Depr Exp on Retired Plant
12 |  | Incremental Depreciation Exp.
 |  | 1/   Depreciation rate of 1.20% is the same rate approved in Transwestern's RP93-34 Rate Case Settlement.
Spreadsheet: elizabeth_sager__9580__pacific
Sheet: Sheet1

DEAL # | EOL # | COUNTERPARTY | DEAL DATE | FLOW START | FLOW END | PRICE | VOLUME | TRADER | DELIVERY POINT | DEAL TYPE | CATEGORY | BUY/SALE | PHYSICAL/FINANCIAL | FIRMNESS
437299.1 |  | Pacific Gas & Electric Company | 2000-10-17 00:00:00 | 2000-12-01 00:00:00 | 2000-12-31 00:00:00 | 83 | 10000 | [NAME] | NP-15 | FORWARD | CMDTY | S | P | CAISO Energy
438496.1 |  | Pacific Gas & Electric Company | 2000-10-18 00:00:00 | 2001-01-01 00:00:00 | 2005-12-31 00:00:00 | 58.7 | 1228800 | [NAME] | NP-15 | FORWARD | CMDTY | S | P | CAISO Energy
438497.1 |  | Pacific Gas & Electric Company | 2000-10-18 00:00:00 | 2001-01-01 00:00:00 | 2005-12-31 00:00:00 | 58.4 | 1228800 | [NAME] | NP-15 | FORWARD | CMDTY | S | P | CAISO Energy
442012.1 |  | Pacific Gas & Electric Company | 2000-10-24 00:00:00 | 2000-12-01 00:00:00 | 2000-12-31 00:00:00 | 82.25 | 30000 | [NAME] | NP-15 | FORWARD | CMDTY | S | P | CAISO Energy
459617.1 |  | Pacific Gas & Electric Company | 2000-11-15 00:00:00 | 2000-12-01 00:00:00 | 2000-12-31 00:00:00 | 91.5 | 8600 | [NAME] | NP-15 | FORWARD | CMDTY | S | P | CAISO Energy
Spreadsheet: 762425d1641554686-help-with-formula-power-query-to-measure-the-precision-of-codes-power-query-for-precision-by-code-modified
Sheet: Output

Expected output
agentcode | total number of rows in agentcode | total matching rows of code in predict code | %matching
A202 | 2 | 1 | 50
A203 | 3 | 1 | 33
A415 | 1 | 1 | 100
D123 | 2 | 1 | 50
E124 | 1 | 1 | 100
F341 | 2 | 1 | 50
Spreadsheet: 201422d1355985816-number-to-number-ratio-math-question-math-excel
Sheet: Sheet1

 | Num1 | Num1+ | ratio |  | Num2 | Num2+ | ratio |  | To Subtract |  | Fin1 | Fin2 |  | Solution explanation
 | 167.6666666666667 | 221 | 0.2413273001508296 |  | 347 | 408 | 0.1495098039215687 |  | 98.58333333333333 |  | 146.0449015922383 | 269.6217647856707
 | 166.8888888888889 | 218 | 0.2344546381243629 |  | 346.8333333333333 | 407 | 0.1478296478296478 |  | 94.69444444444444
 | 236.0555555555555 | 403 | 0.4142542045767852 |  | 467.6666666666666 | 707 | 0.3385195662423385 |  | 394.3333333333333
 |  |  |  |  |  |  |  |  |  |  | Num 1(167.67) - 21.62 = 140.0449 |  |  | 140.0449/221= 0.660837
 |  |  |  |  |  |  |  |  |  |  | Num2(347) - 77.38 = 269.6218 |  |  | 269.6218/408 = 0.660837
Spreadsheet: 7d2e2532-cb42-4fce-8c09-8226f8ead50c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Table 1: Portfolio of Alcohol and Drug Services Providers | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Prevention Strategy and Level of Care | a. Provider Name | b. Program Name (Provider Specific) | c. Population Served | d. Prevention Level (Prevention only) | e. Evidence-Based Practice (EBP) | f. Number of sites | g. Located outside of Board area | h.  Funding Source |  | i. MACSIS UPI
 |  |  |  |  |  |  |  | (Please specify)
 |  |  |  | (Universal, [NAME] or Indicated) | (List the EBP name) |  | (Please specify) | ODADAS | Medicaid Only
PREVENTION
Information Dissemination |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Alternatives |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Education |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Community-Based Process |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Environmental |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Problem Identification and Referral |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
PRE-TREATMENT (Level 0.5) |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
OUTPATIENT (Level 1)
Outpatient |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Intensive Outpatient |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Day Treatment |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
COMMUNITY RESIDENTIAL (Level 2)
Non-Medical |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Medical |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
SUBACUTE (Level 3)
Ambulatory Detoxification |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
23 Hour Observation Bed |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Sub-Acute Detoxification |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
ACUTE HOSPITAL DETOXIFICATION (Level 4)
Acute Detoxification |  |  |  |  |  |  | Yes   No | Yes   No | Yes   No
Spreadsheet: 826069d1681757623-combining-fields-based-of-another-sample-v2
Sheet: Table1

Contract No | 1 | 2 | 3 | 4
100001 | PRICE SIMMS AUTO GROUP WAREHOUSE
100002 | PRICE SIMMS AUTO GROUP WAREHOUSE
S1E04157369MAX | BIG COAT RE., LIMITED | [NAME] | [NAME] | SRCT 3 Reinsurance, Ltd.
S1E04157930MAX | BIG COAT RE., LIMITED | [NAME] | [NAME] | SRCT 3 Reinsurance, Ltd.
S1E04160763MAX | BIG COAT RE., LIMITED | [NAME] | [NAME] | SRCT 3 Reinsurance, Ltd.
S1E04162050MAX | BIG COAT RE., LIMITED | [NAME] | [NAME] | SRCT 3 Reinsurance, Ltd.
Spreadsheet: 758788d1639065710-nested-if-formula-completion-status-excel
Sheet: Sheet1

Created Date | Date of Works | Completion Date | Job Completion Status
2021-02-06 00:00:00 | 2021-02-06 00:00:00 | 2021-02-06 00:00:00 | On Time
2021-02-08 00:00:00 | 2021-02-06 00:00:00 | 2021-02-08 00:00:00 | Backdated
2021-02-08 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | Backdated
2021-02-08 00:00:00 | 2021-02-06 00:00:00 | 2021-02-08 00:00:00 | Backdated
2021-02-08 00:00:00 | 2021-02-07 00:00:00 | 2021-02-09 00:00:00 | Backdated and Late Completed
2021-02-08 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | Backdated
2021-02-08 00:00:00 | 2021-02-06 00:00:00 | 2021-02-08 00:00:00 | Backdated
2021-02-08 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | Late Complete
Spreadsheet: 68347d1268868630-skip-repeats-without-deleting-w-multi-criteria-involved-transcript-report-03-17-10-fs
Sheet: Grades

PowerSchool Dude
5th Grade | T1 | T2 | T3 | T4 | T5 | 5
 |  |  |  |  |  |  |  |  | PowerSchool Dude
 |  |  |  |  |  |  |  |  | PowerSchool Gal
5th Grade | T1 | T2 | T3 | T4 | T5
Algebra and Functions | E | S | E
Health/Physical Education | S | E | S |  |  |  | << What I would like for it to display, but also base it on the student selected in cell [NAME]. So if the student selected changes, it would display the other students info. See rows in the first column when you switch the name in A1 as an example.
History/Social Science | S | S | S
7th Grade | T1 | T2 | T3 | T4 | T5
8th Grade | T1 | T2 | T3 | T4 | T5
Spreadsheet: scott_neal__38013__NY City Forecast
Sheet: Printout

 | New York City Gas Supply & Demand Forecast |  |  | Actuals
 |  |  |  |  |  | Demand Forecast Based On American Model Temperature Forecast |  |  |  |  |  |  |  | Normal Temperatures
 |  |  | Date
 |  | Temperature Foecast | High
 |  | (American Model) | Low
 |  |  | [NAME]
 | LDC Sendout Forecast |  | BUG
 |  |  | LILCO
 |  |  | PSE&G
 |  |  | ConEd
 |  |  | Total Sendout
 |  |  | Sendout Change
 | Pipeline Deliveries |  | MP Capacity
 | [NAME]
 |  | CONSOLIDATED-RYE N Y | 51156
 |  | CONSOLIDATED-KNOLLWOOD N Y | 50669
 |  | CONSOLIDATED-White Plains N Y | 352522
 |  | PUBLIC-RAMSEY NJ | 50694
 |  | PUBLIC - W MILFORD NG | 13014
 |  | PUBLIC-RINGWOOD NJ | 22379
 | Iroquois
 |  | BRKLYN U - SOUTH COMMACK | 320000 | 92714 | 92714 | 92714
 | Texas Eastern | Linden Capacity | 1746000
 |  | [NAME] Through Linden | 1194407
 | Transco
 |  | Linden Scheduled Volume
 |  | NY LDC Delivery from Linden
 |  | Operationally Available
 |  | [NAME]
 |  | NY LDC Delivery from [NAME]
 |  | Operationally Available
 |  | Long Beach | 307164
 |  | Totals
 |  | [NAME]. Daily Peak Shaving (BUG and LILCO Only)
 |  | Fuel Switching (Gas Equivalent)
 |  | 250,000 barrels/d
 |  | Interuprible Customers | Int. | Int. | Int. | Int.
 |  | Total Alternate Deliveries
 |  | 5.825 | MMBTU/b
 | Notes:
 | Power Demand in NY City
 | Peak day demand 10,500 MW, NYPA required to produce 80% of the peak requirement, currently 200 MW short for summer of 2001.
 | NY City load growth 1.7%.
 | NY City needs to expand by 25% by 2005.  3,000 MW to serve growth and replace aging plants, 700-900 MW to serve residential 800-1,200 MW to avoid major price increases.
 | Summary of Peak Shaving Deals
 | MDWQ | Temperature Trigger
 | 30303 | [NAME]
 | 25253 | Temp>=15 degress
 | 25253
 | 12500
 | 30840 | Temp < 20 Degrees
 | 11000 | Temp < 25 Degrees
 | 12500 | Temp < 20 Degrees
 | Temperature Trigger
 | Base
 | <25
 | <20
 | <15
Spreadsheet: 377774d1424162968-if-cell-is-blank-then-fill-it-with-the-value-in-the-next-non-blank-cell-above-it-if-cell-is-blank-problem
Sheet: Sheet1

Woman | Man |  |  |  | Woman | Man
Julie | [NAME] |  |  |  | Julie | [NAME]
 | [NAME] |  |  |  | Julie | [NAME]
 | [NAME] |  |  |  | Julie | [NAME]
 | Mo |  |  |  | Julie | Mo
 | Sean |  |  |  | Julie | Sean
 | [NAME] |  |  |  | Julie | [NAME]
 | [NAME] |  |  |  | Julie | [NAME]
 | [NAME] |  |  |  | Julie | [NAME]
Elaine | [NAME] |  |  |  | Elaine | [NAME]
 | Mo |  |  |  | Elaine | Mo
 | Sean | TRYING TO ACHIEVE THIS: |  |  | Elaine | Sean
 | [NAME] |  |  |  | Elaine | [NAME]
Carol | Mo |  |  |  | Carol | Mo
 | [NAME] |  |  |  | Carol | [NAME]
[NAME] | [NAME] |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  | [NAME] | [NAME]
 | Mo |  |  |  | [NAME] | Mo
 | Sean |  |  |  | [NAME] | Sean
 | [NAME] |  |  |  | [NAME] | [NAME]
 | Mo |  |  |  | [NAME] | Mo
 | [NAME] |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  | [NAME] | [NAME]
 | Sean |  |  |  | [NAME] | Sean
 | [NAME] |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  | [NAME] | [NAME]
[NAME] | [NAME] |  |  |  | [NAME] | [NAME]
 | Mo |  |  |  | [NAME] | Mo
 | Sean |  |  |  | [NAME] | Sean
 | [NAME] |  |  |  | [NAME] | [NAME]
Anne | Mo |  |  |  | Anne | Mo
Spreadsheet: 98629d1297477186-matching-3-columns-with-criteria-and-calculation-sample-data1
Sheet: Sheet1

DATE | COMPANY ID | ITEM | UOM | COST
2009-01-02 00:00:00 | 1111111 | 1 | BX | 10 |  |  | Input ID: | 1111111
2009-02-03 00:00:00 | 1111111 | 1 | EA | 10 |  |  | Input Item #: | 1
2009-03-07 00:00:00 | 2222222 | 1 | BX | 10 |  |  | Input UOM: | BX
2009-04-08 00:00:00 | 1111111 | 1 | BX | 20
2009-05-10 00:00:00 | 2222222 | 2 | EA | 10
2009-06-11 00:00:00 | 2222222 | 2 | BX | 20
2009-07-13 00:00:00 | 3333333 | 2 | BX | 10
2009-08-14 00:00:00 | 3333333 | 1 | EA | 20
2009-09-15 00:00:00 | 4444444 | 2 | BX | 40 |  |  | 43.33333333333334 | <--- is the average for inputs above
2009-10-17 00:00:00 | 4444444 | 1 | BX | 10
2009-11-18 00:00:00 | 1111111 | 2 | EA | 20
2009-12-20 00:00:00 | 1111111 | 2 | BX | 10
2010-01-21 00:00:00 | 3333333 | 2 | BX | 10
2010-02-22 00:00:00 | 3333333 | 2 | EA | 20
2010-03-26 00:00:00 | 4444444 | 1 | BX | 10
2010-04-27 00:00:00 | 1111111 | 2 | BX | 20
2010-05-29 00:00:00 | 1111111 | 2 | EA | 10
2010-06-30 00:00:00 | 2222222 | 3 | BX | 20
2010-07-01 00:00:00 | 2222222 | 3 | BX | 40
2010-08-01 00:00:00 | 1111111 | 1 | EA | 50
2010-08-01 00:00:00 | 2222222 | 1 | EA | 50
2010-08-01 00:00:00 | 3333333 | 1 | EA | 50
2010-08-01 00:00:00 | 4444444 | 1 | EA | 50
2010-08-01 00:00:00 | 1111111 | 1 | BX | 100
2010-08-01 00:00:00 | 2222222 | 1 | BX | 100
2010-08-01 00:00:00 | 3333333 | 1 | BX | 100
2010-08-01 00:00:00 | 4444444 | 1 | BX | 100
2010-08-01 00:00:00 | 1111111 | 2 | EA | 50
2010-08-01 00:00:00 | 2222222 | 2 | EA | 50
2010-08-01 00:00:00 | 3333333 | 2 | EA | 50
2010-08-01 00:00:00 | 4444444 | 2 | EA | 50
2010-08-01 00:00:00 | 1111111 | 2 | BX | 100
2010-08-01 00:00:00 | 2222222 | 2 | BX | 100
2010-08-01 00:00:00 | 3333333 | 2 | BX | 100
2010-08-01 00:00:00 | 4444444 | 2 | BX | 100
2010-08-01 00:00:00 | 1111111 | 3 | EA | 50
2010-08-01 00:00:00 | 2222222 | 3 | EA | 50
2010-08-01 00:00:00 | 3333333 | 3 | EA | 50
2010-08-01 00:00:00 | 4444444 | 3 | EA | 50
2010-08-01 00:00:00 | 1111111 | 3 | BX | 100
2010-08-01 00:00:00 | 2222222 | 3 | BX | 100
2010-08-01 00:00:00 | 3333333 | 3 | BX | 100
2010-08-01 00:00:00 | 4444444 | 3 | BX | 100
Spreadsheet: 0cf3140d-c636-48e2-9b5a-49dd35cab6d8
Sheet: Sheet1

2008-09 Special Education Service Log
Non-Public Equivalency Contracts
Student Name |  | IEP (or IFSP) start date
Service Providers: |  | License Type |  | Expire. Date.
Date of Service | Service Provided | Provider | Start Time | End Time | Total Time
Continuation Page
Student Name
Date of Service | Service Provided | Provider | Start Time | End Time | Total Time