tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02b30c79-db6d-4ce1-8a1e-f061a7c0c88c
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 9. FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($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
Personal Finance - New motor cars and station wagons ; |  |  | Original | A2414166T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Personal Finance - Used motor cars and station wagons ; |  |  | Original | A2414167V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Personal Finance - Motor cycles ; |  |  | Original | A2414168W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Personal Finance - Other motor vehicles ; |  |  | Original | A2414169X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2414170J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Commercial Finance ; |  |  | Original | A2414171K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Value of Lease Finance Commitments ; |  |  | Original | A2414172L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414173R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: kate_symes__18194__EESSales_dailymarch
Sheet: 3-3

NP15 | 2001-03-03 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 267.78 | Fixed Off Peak | 181.22 |  |  |  | Fixed Peak | 251.64 |  | Fixed Off Peak | 172.14 |  |  | Fixed Peak | 251.64 |  | Fixed Off Peak | 172.14
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | -4.89 | 0 | 0 | -4.89 |  |  | 1 | -48.51 | 0 | 0 | -17.51 |  |  | 1 | -1.97 | 0 | 0 | -1.97
2 | -4.01 | 0 | 0 | -4.01 |  |  | 2 | -49.6 | 0 | 0 | -13.6 |  |  | 2 | -1.94 | 0 | 0 | -1.94
3 | -3.39 | 0 | 0 | -3.39 | 0 |  | 3 | -49.8 | 0 | 0 | -11.8 |  |  | 3 | -1.92 | 0 | 0 | -1.92
4 | -3.22 | 0 | 0 | -3.22 |  |  | 4 | -49.92 | 0 | 0 | -9.919999999999995 |  |  | 4 | -1.91 | 0 | 0 | -1.91
5 | -3.4 | 0 | 0 | -3.4 |  |  | 5 | -49.85 | 0 | 0 | -10.85 |  |  | 5 | -1.92 | 0 | 0 | -1.92
6 | -4.05 | 0 | 0 | -4.05 |  |  | 6 | -49.95 | 0 | 0 | -16.95 |  |  | 6 | -1.95 | 0 | 0 | -1.95
7 | -5.55 | 0 | 0 | -5.55 |  |  | 7 | -61.23 | 0 | 0 | -21.23 |  |  | 7 | -2 | 0 | 0 | -2
8 | -7.55 | 0 | 0 | -7.55 |  |  | 8 | -58.97 | 0 | 0 | -26.97 |  |  | 8 | -2.09 | 0 | 0 | -2.09
9 | -9.5 | 0 | 0 | -9.5 |  |  | 9 | -57.05 | 0 | 0 | -35.05 |  |  | 9 | -2.17 | 0 | 0 | -2.17
10 | -10.1 | 0 | 0 | -10.1 |  |  | 10 | -56.34 | 0 | 0 | -41.34 |  |  | 10 | -2.2 | 0 | 0 | -2.2
11 | -10.36 | 0 | 0 | -10.36 |  |  | 11 | -56.01 | 0 | 0 | -47.01 |  |  | 11 | -2.21 | 0 | 0 | -2.21
12 | -10.07 | 0 | 0 | -10.07 |  |  | 12 | -56.38 | 0 | 0 | -48.38 |  |  | 12 | -2.2 | 0 | 0 | -2.2
13 | -9.9 | 0 | 0 | -9.9 |  |  | 13 | -56.21 | 0 | 0 | -48.21 |  |  | 13 | -2.18 | 0 | 0 | -2.18
14 | -9.28 | 0 | 0 | -9.28 |  |  | 14 | -57.25 | 0 | 0 | -48.25 |  |  | 14 | -2.16 | 0 | 0 | -2.16
15 | -8.68 | 0 | 0 | -8.68 |  |  | 15 | -57.38 | 0 | 0 | -47.38 |  |  | 15 | -2.13 | 0 | 0 | -2.13
16 | -8.67 | 0 | 0 | -8.67 |  |  | 16 | -57.62 | 0 | 0 | -46.62 |  |  | 16 | -2.13 | 0 | 0 | -2.13
17 | -8.96 | 0 | 0 | -8.96 |  |  | 17 | -57.26 | 0 | 0 | -44.26 |  |  | 17 | -2.15 | 0 | 0 | -2.15
18 | -10.68 | 0 | 0 | -10.68 |  |  | 18 | -55.45 | 0 | 0 | -46.45 |  |  | 18 | -2.22 | 0 | 0 | -2.22
19 | -12.87 | 0 | 0 | -12.87 |  |  | 19 | -52.98 | 0 | 0 | -46.98 |  |  | 19 | -2.31 | 0 | 0 | -2.31
20 | -12.19 | 0 | 0 | -12.19 |  |  | 20 | -53.66 | 0 | 0 | -43.66 |  |  | 20 | -2.29 | 0 | 0 | -2.29
21 | -11.19 | 0 | 0 | -11.19 |  |  | 21 | -54.69 | 0 | 0 | -39.69 |  |  | 21 | -2.25 | 0 | 0 | -2.25
22 | -9.99 | 0 | 0 | -9.99 |  |  | 22 | -56.61 | 0 | 0 | -34.61 |  |  | 22 | -2.19 | 0 | 0 | -2.19
23 | -8.29 | 0 | 0 | -8.29 |  |  | 23 | -45.4 | 0 | 0 | -29.4 |  |  | 23 | -2.11 | 0 | 0 | -2.11
24 | -6.51 | 0 | 0 | -6.51 |  |  | 24 | -47.1 | 0 | 0 | -23.1 |  |  | 24 | -2.05 | 0 | 0 | -2.05
Spreadsheet: 859729d1708004547-combine-all-tables-of-the-workbook-into-one-but-column-headers-are-different-sample
Sheet: Batch B21

 | Summary of Assessment Outcome  Name of Programme: det  Name of Lecturer- que IV By- win SSO Name- swa
 | Batch B21 result Sheet
 | Student ID | First Name | Surname | Result Unit 502  IV-win | Result Unit 503   IV-win | 1st Term Progression | Result Unit 417  IV-win | Result Unit 506 IV-win | Result Unit 423 IV-win | 2st Term Progression | Result Unit 426 IV-win | Result Unit 501 IV-win | 3rd Term Progression | Unit Pass        out of 7 units | Certificate Claimed Yes/No | Claimed by | Date of Certificate Recieving | Received by | Certificate Claim File | Incorrect Name | [NAME] only File | Correct Name As pe Passport | Checked by
 | 23456 | [NAME] | Sumathi | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 | 23457 | [NAME] | ARIFA | Pass | Pass | PP | Pass | Pass | Resit-Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 | 23458 | Tordai | [NAME] | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  | 2022-12-06 00:00:00 | Student
 | 23459 | Porter | Letaif | Pass | Pass | PP | Resit-Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 | 23460 | Suleman | Ogunbase | Pass | Pass | PP | Resit-Pass | Pass | Pass | PP | Pass | Pass | PP | 7 | Yes |  |  |  | yes
 | 23461 | Porter | Packiarajah | Pass | Pass | PP | Pass | Pass | Pass | PP | Pass | Pass | PT | 7 | Yes |  |  |  | yes
Withdrawn | 21090 | [NAME] | Khanom | Refer | Refer | PT | Not Submitted | Not Submitted | Not Submitted | PT | Withdrawn | Withdrawn | WD | 0 | WD
 | PP= Pass & Progress
 | PT= Progress with Trailing
 | Total Students |  |  | 28 | 28 |  | 28 | 28 | 28 |  | 27 | 27 | 27 | 20
 | Submission |  |  | 28 | 28 |  | 26 | 24 | 24 |  | 20 | 21
 | Submission Rate
 | Pass |  |  | 27 | 27 |  | 24 | 22 | 23 |  | 20 | 20
 | Refer |  |  | 1 | 1 |  | 2 | 2 | 1 |  | 0 | 1
 | Marking Pending |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
 | Not Submitted |  |  | 0 | 0 |  | 2
 | Passing rate |  |  |  |  |  |  |  |  |  |  |  | Overall achievement Rate
Spreadsheet: 827130d1682504705-replace-any-number-from-0-to-9-in-an-alphanumeric-text-with-nothing-test
Sheet: 工作表1

PUNE 1
PUNE 2
PUNE 3
PUNE 4
PUNE 5
PUNE 6
PUNE 7
PUNE1
PUNE2
PUNE3
[NAME]
PUNE5
PUNE6
PUNE7
[NAME]
PUNE-2
[NAME]
PUNE-4
PUNE-5
[NAME]
PUNE-7
PUNE-8
Spreadsheet: 791451d1660349566-find-number-of-streaks-in-a-row-and-length-of-each-streak-streak-count-an-length-bvj-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | streaks per row | length of each streak
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 1 | 0 | 0 | 0 |  | 3
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 0 | 1 | 1 | 0 |  | 1
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 1 | 1 | 0 | 0 |  | 1
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 1 | 1 | 0 | 1 | 0 |  | 4
0 | 1 | 0 | 0 | 0 | 0 |  | 1
0 | 1 | 0 | 0 | 1 | 0 |  | 2
0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 1 |  | 1
0 | 1 | 1 | 0 | 0 | 0 |  | 3
0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 147072d1332512533-chart-display-axis-values-as-a-time-ever-0-30-minute-chart-1-
Sheet: Sheet1

 |  |  |  | ATM Name | Fail time | fix time
 |  |  |  | UNIT # 1 | 09:25:00
 |  |  |  | UNIT # 2
 |  |  |  | UNIT # 3
 |  |  |  | UNIT # 4
 |  |  |  | UNIT # 5
 |  |  |  | UNIT # 6
 |  |  |  | UNIT # 7
 |  |  |  | UNIT # 8
 |  |  |  | UNIT # 9
 |  |  |  | UNIT # 10
 |  |  |  | UNIT # 11
 |  |  |  | UNIT # 12
 |  |  |  | UNIT # 13
 |  |  |  | UNIT # 14
 |  |  |  | UNIT # 15
 |  |  |  | UNIT # 16
Spreadsheet: 128146d1320817724-summarising-data-from-multiple-worksheets-example-file
Sheet: Total

XYZ Factories Total Costs 2011
 |  | Budget | Current Month | Year to Date | Commitments
 | Plant A
 | Plant B
 | Plant C
Spreadsheet: 725446d1616678676-n-a-errors-but-not-consistent-yr-13-tracking-sheet-2020-21-copy-for-excel-forum
Sheet: KEY

Grade | Value
A** | 9
A* | 8
A | 7
B | 6
C | 5
D | 4
E | 3
F | 2
U | 0
P |  | Pass | U | 0
M |  | Merit
DI |  | Distinction
DI* |  | Distinction *
Spreadsheet: 723091d1615507628-help-moving-names-vertically-to-horizontally-sampleteamhelp
Sheet: Sheet1

Golden State |  |  |  |  | Sample: | Golden State | Brooklyn
Brooklyn |  |  |  |  |  | Brooklyn | Golden State
LA Clippers |  |  |  |  |  | LA Clippers | LA Lakers
LA Lakers |  |  |  |  |  | LA Lakers | LA Clippers
Milwaukee |  |  |  |  |  | Milwaukee | Boston
Boston |  |  |  |  |  | Boston | Milwaukee
Dallas |  |  |  |  |  | Dallas | Phoenix
Phoenix |  |  |  |  |  | Phoenix | Dallas
Charlotte
Cleveland
New York
Indiana
Miami
Orlando
Washington
Philadelphia
New Orleans
Toronto
Atlanta
Chicago
San Antonio
Memphis
Detroit
Minnesota
Sacramento
Denver
Utah
Portland
New Orleans
Miami
Golden State
Milwaukee
Spreadsheet: 861656d1709546139-issue-with-drop-down-box-dropdown-aligw
Sheet: Sheet1

 |  | Invoice | Taken |  | Select the Invoice No
 |  | 111 | Taken |  | 112
 |  | 112 |  |  |  |  |  |  | 113
 |  | 113 |  |  |  |  |  |  | 114
 |  | 114 |  |  | a) I hope to select only those are not "taken" |  |  |  | 115
 |  | 115 |  |  |  |  |  |  | 116
 |  | 116 |  |  |  |  |  |  | 117
 |  | 117
 |  | **I would like to Strikthought the Invoice no if  D column is "taken"
Spreadsheet: kevin_hyatt__19606__SD Volumes
Sheet: Demand

Sun Devil Volume
MMBtu/d |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 100% Capacity | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
Phoenix Load
Panda Energy - Gila | 390098 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000
APS - W. Phoenix |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
APS - Red Hawk | 410000 | 100000 | 200000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000 | 300000
SRP - Agua Fria | 97600 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
SRP - Kyrene | 45315 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
Duke - Arlington | 125000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000
Sempra - Mesquite | 220490 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
PG&E - Harquahala | 178825 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000 | 50000
SouthWest Gas | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000
PPL Sundance | 90000
Total Phoenix
East of Calif Market
EDG - Gallup | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000 | 216000
Citizen's Utilities | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000 | 20000
Total SD Market
*Red Hawk Phase I = 1160 Mw by 6/02, Ph II = 530 by 6/06, Ph III = 520 by 6/07, 410 [NAME]/d total consumption
Spreadsheet: 722334d1615204499-add-1-to-a-given-value-in-every-3-years-based-on-a-range-of-dates-sample3-ans-2
Sheet: Sheet1

 |  | From | To |  |  | From | To | Step | [NAME]'s formula for step
 |  | 1980-09-02 00:00:00 | 2001-03-10 00:00:00 |  |  |  |  | 1 |  | 1980-09-02 00:00:00 |  | 1
 |  |  |  |  |  |  |  | 1 |  | 1981-01-01 00:00:00 |  | 1
 |  |  |  |  |  |  |  | 1 |  | 1982-01-01 00:00:00 |  | 1
 |  |  |  |  |  |  |  | 1 |  | 1983-01-01 00:00:00 | 1983-09-01 00:00:00 | 1
 |  |  |  |  |  |  |  | 2 |  | 1983-09-02 00:00:00 | 1983-12-21 00:00:00 | 2
 |  |  |  |  |  |  |  | 2 |  | 1984-01-01 00:00:00 |  | 2
 |  |  |  |  |  |  |  | 2 |  | 1985-01-01 00:00:00 |  | 2
 |  |  |  |  |  |  |  | 2 |  | 1986-01-01 00:00:00 | 1986-09-01 00:00:00 | 2
There will be an additional 1 step in every 3 years but not exceeding 8 with font color red. The cells filled with green are the end dates in each period. |  |  |  |  |  |  |  | 3 |  | 1986-09-02 00:00:00 |  | 3
 |  |  |  |  |  |  |  | 3 |  | 1987-01-01 00:00:00 |  | 3
 |  |  |  |  |  |  |  | 3 |  | 1988-01-01 00:00:00 |  | 3
 |  |  |  |  |  |  |  | 3 |  | 1989-01-01 00:00:00 | 1989-09-01 00:00:00 | 3
 |  |  |  |  |  |  |  | 4 |  | 1989-09-02 00:00:00 |  | 4
 |  |  |  |  |  |  |  | 4 |  | 1990-01-01 00:00:00 |  | 4
 |  |  |  |  |  |  |  | 4 |  | 1991-01-01 00:00:00 |  | 4
 |  |  |  |  |  |  |  | 4 |  | 1992-01-01 00:00:00 | 1992-09-01 00:00:00 | 4
 |  |  |  |  |  |  |  | 5 |  | 1992-09-02 00:00:00 |  | 5
 |  |  |  |  |  |  |  | 5 |  | 1993-01-01 00:00:00 |  | 5
 |  |  |  |  |  |  |  | 5 |  | 1994-01-01 00:00:00 |  | 5
 |  |  |  |  |  |  |  | 5 |  | 1995-01-01 00:00:00 | 1995-09-01 00:00:00 | 5
 |  |  |  |  |  |  |  | 6 |  | 1995-09-02 00:00:00 |  | 6
 |  |  |  |  |  |  |  | 6 |  | 1996-01-01 00:00:00 |  | 6
 |  |  |  |  |  |  |  | 6 |  | 1997-01-01 00:00:00 |  | 6
 |  |  |  |  |  |  |  | 6 |  | 1998-01-01 00:00:00 | 1998-09-01 00:00:00 | 6
 |  |  |  |  |  |  |  | 7 |  | 1998-09-02 00:00:00 |  | 7
 |  |  |  |  |  |  |  | 7 |  | 1999-01-01 00:00:00 |  | 7
 |  |  |  |  |  |  |  | 7 |  | 2000-01-01 00:00:00 |  | 7
 |  |  |  |  |  |  |  | 7 |  | 2001-01-01 00:00:00 | 2001-09-01 00:00:00 | 7
 |  |  |  |  |  |  |  | 8 |  | 2001-09-02 00:00:00 |  | 8
 |  |  |  |  |  |  |  | 8 |  | 2002-01-01 00:00:00 |  | 8
 |  |  |  |  |  |  |  | 8 |  | 2003-01-01 00:00:00 |  | 8
 |  |  |  |  |  |  |  | 8 |  | 2004-01-01 00:00:00 |  | 8
 |  |  |  |  |  |  |  | 8 |  | 2005-01-01 00:00:00 | 2005-03-10 00:00:00 | 8
Spreadsheet: 552426d1513573861-summation-based-on-flag-index-in-another-column-work
Sheet: Sheet1

Sl. No. | Description | Qty | Unit | Rate | Amount | Flag
 | Heading 1 |  |  |  |  | h
 | Item 1 |  |  |  |  | m
 | Sub-1 of Item 1 | 5 | Nos | 50 | 250 | s
 | Sub-2 of Item 1 | 15 | Nos | 750 | 11250 | s
 | Sub-3 of Item 1 | 12 | Set | 100 | 1200 | s
 | Item 2 |  |  |  |  | m
 | Sub-1 of Item 2 | 7 | m | 20 | 140 | s
 | Sub-2 of Item 2 | 9 | m | 352 | 3168 | s
 | Item 3 | 8 | Nos | 58 | 464 | m
 | Item 4 |  |  |  |  | m
 | Sub-1 of Item 4 | 2 | Nos | 1 | 2 | s
 | Sub-2 of Item 4 | 7 | Nos | 202 | 1414 | s
 | TOTAL |  |  |  |  | tot
 | Heading 2 |  |  |  |  | h
 | Item 1 |  |  |  |  | m
 | Sub-1 of Item 1 | 8 | Set | 50 | 400 | s
 | Item 2 |  |  |  |  | m
 | Sub-1 of Item 2 | 4 | Nos | 20 | 80 | s
 | Sub-2 of Item 2 | 5 | Nos | 352 | 1760 | s
 | Item 3 | 8 | m | 58 | 464 | m
 | TOTAL |  |  |  |  | tot
Spreadsheet: larry_campbell__21602__FinalGasDealTicket100201_v2klw(1)_Sample
Sheet: Formulas

 | Strategic Account | False
 | EESI | False
 | EESO | False
 | Enron Direct Canada | False
 | Industrial: | False
 | Commercial: | False
 | [NAME]: | False
 | Utility Data Attached | False
1. [NAME]
 | Consumption Band | False
 | Monthly | False
 | Yearly | False
2. SERVICES / DELIVERY / TERM
SERVICES: | Fully Managed | False
 | Citygate Managed | False
 | Nominations Only | False
 | None | False
TRANSPORTATION: | Firm | False
 | IT/RFT | False
 | Burnertip | False
 | CityGate | False
3. CONTRACT
 | Sell | False
 | Buy | False
 | Financial | False
 | Physical | False
 | Fixed | False
 | Index | False
 | Nymex | False
 | New | False
 | Renew | False
 | Modify | False
 | Unwind | False
 | 1 [NAME] | False
 | 2 [NAME] | True
 | 3 [NAME] | False
 | Evergreen | False
4. DOCUMENT OPTIONS
 | Spot Deal | False
 | Industrial New Term Deal | False
 | Amendment | False
 | Other | False
5. CONTRACT PRICE
 | Fixed: | False
 | Index: | False
 | NYMEX (NX1): | False
 | NYMEX (NX3): | False
 | Basis: | False
 | Transport Price $ | False
 | Consumption Band | False
Tax Status: | Exempt | False
 | Non-Exempt | False
 | Marketer Balance | False
 | Penalty Pass Through | False
 | N/A | False
 | Applicable | False
 | Fixed | False
6. BILLING INFORMATION
 | Summary Billing | False
 | Actual | False
 | Noms | False
Spreadsheet: 684192d1593187966-abc-on-unsorted-data-exmaple-data-copy
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Expected Result
Product | Category | Sales Value ($) | % Sales | Grade |  | Grade | Range |  |  | Product | Category | Sales Value ($) | % Sales | % Cumm Sales | Grade
A-1 | A | 69 |  |  |  | A | <= 50% |  |  | A-364 | A | 447
A-2 | A | 149 |  |  |  | B | 50 % < x <= 80% |  |  | A-20 | A | 398
A-20 | A | 398 |  |  |  | C | > 80% |  |  | A-375 | A | 398
A-126 | A | 209 |  |  |  |  |  |  |  | A-527 | A | 349
A-141 | A | 249 |  |  |  |  |  |  |  | A-365 | A | 298
A-364 | A | 447 |  |  |  |  |  |  |  | A-141 | A | 249
A-365 | A | 298 |  |  |  |  |  |  |  | A-126 | A | 209
A-375 | A | 398 |  |  |  |  |  |  |  | A-2 | A | 149
A-527 | A | 349 |  |  |  |  |  |  |  | A-1 | A | 69
B-696 | B | 369 |  |  |  |  |  |  |  | B-873 | B | 448
B-702 | B | 379 |  |  |  |  |  |  |  | B-869 | B | 439
B-729 | B | 69 |  |  |  |  |  |  |  | B-865 | B | 418
B-744 | B | 398 |  |  |  |  |  |  |  | B-775 | B | 399
B-775 | B | 399 |  |  |  |  |  |  |  | B-744 | B | 398
B-865 | B | 418 |  |  |  |  |  |  |  | B-702 | B | 379
B-869 | B | 439 |  |  |  |  |  |  |  | B-696 | B | 369
[NAME] | B | 69 |  |  |  |  |  |  |  | B-729 | B | 69
B-873 | B | 448 |  |  |  |  |  |  |  | [NAME] | B | 69
Spreadsheet: 729522d1619142445-formula-to-count-absences-based-on-criteria-and-matching-dates-book2
Sheet: Sheet1

Employee | Date | Hours Type | Code |  |  | Absences Formula #1 | Absecnes Formula #2
[NAME] | 2021-02-01 00:00:00 | LA | # | absent
[NAME] | 2021-02-02 00:00:00 | RF | TS | absent
[NAME] | 2021-02-03 00:00:00 | RF | # | present
[NAME] | 2021-02-04 00:00:00 | RF | TS | absent
[NAME] | 2021-02-04 00:00:00 | LS | #
[NAME] | 2021-02-08 00:00:00 | RF | TS | absent
[NAME] | 2021-02-09 00:00:00 | RF | # | present
[NAME] | 2021-02-10 00:00:00 | OS | # | absent
Basically, I am trying to use a formula to calculate the # of times a person is absent from class based upon hours type and code (2 conditions).
If hours type (Column C) begins with anything BUT "R" it should count as an absence. You will notice 3 absences in Column C (LA, LS, OS) on 2/1, 2/4 and 2/10.
Next, i am trying to also count an absence for any hours type that begins with "R" and the Code (Column D) begins with "T". There are 2 of these occurrences on 2/2 and 2/8.
So i am manually counting 5 absences, but you will notice on 2/4/2021, Excel is counting the 2 occurrences (RF with TS code, and the LS) on this date twice resulting in 6 absences instead of 5.
I believe im neglecting some check of dates for duplications or matches/not matches etc.? I am really struggling with referencing the dates and creating rules based on the date as well.
Spreadsheet: 785896d1656808350-index-formula-problems-autocall-datasheets
Sheet: SEARCH

Select The Product For Which You Are Seeking A Data Sheet From The Dropdown List Below
 | Addressable speaker
 | '=IFERROR(INDEX(Sheet2!$B$9:$O$612,Sheet2!S9,1),"")
 | Product Name/PID | Link
Spreadsheet: 744188d1629053845-finding-the-second-fifth-working-day-of-a-given-month-meeting-dates-table
Sheet: Formulas

 |  |  | 2021
Wk | Day | Mth | Date | Notes
3 | 2 | 15 |  | 3rd Monday in March
1 | 6 | 17 |  | 1st Friday in May
1 | 2 | 11 |  | 2nd Monday in November
 |  |  |  |  |  |  | 1st day of month
1 | 6 | 15 |  | Last Friday in March
1 | 6 | 16 |  | Last Friday in April
1 | 6 | 11 |  | Last Friday in November
1 | 2 | 13 |  | Last Tuesday in Jan - other meeting at Harrow |  |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 | 2 | 19 |  | Friday before First Monday in July |  |  |  | "=first Monday of month
1 | 2 | 14 |  | Last working day of February Excluding Saturday |  |  |  | "=first Monday of month
1 | 7 | 19 |  | Last Saturday in July
1 | 4 | 16 |  | Last Wednesday in April
1 | 3 | 15 |  | 2nd 5th weekday in March including Saturdays
 |  |  | Used to identify a day in the first week of the month, result shown in column H
 |  |  | Calculation in D then looks for the last working day of that month
 |  |  | Calculations to count the number of occurrences of each day
 |  |  | Using numbers 13 to 19 in the month column allow me to structure the calendar from September to July each year which is how we meet
Spreadsheet: louise_kitchen__23950__YTD Orig Analysis
Sheet: Sheet1

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  | East Power                                          June 19, 2001
Alamac |  | Q101 |  | Kroll | Southeast |  | Enron sells its interest in North Carolina Power Holdings |  | 7261
Central Maine Power |  | Q101 |  | Llorda/Wood | Northeast |  | Standard offer; Taking over the utilities' obligation to supply power to their customers |  | 5000
Nstar |  | Q101 |  | [NAME] | Northeast |  | Serve 25% of their default needs for residential class |  | 3000
Intergen |  | Q101 |  | Mitro/Booth/Walker | Development |  | Sale of Turbines |  | 2509
43 Deals |  | Q101 |  | Various | Various |  | Deals < $1M each
Doyle |  | Q101 |  | Tapscott | Development |  | Settlement payment with [NAME] |  | 1300
Intergen |  | Q101 |  | Mitro/Booth/Walker | Development |  | Adjustment to the gain for Intergen based on transfer price allocation |  | 1000
CRRA |  | Q101 |  | Berstein | Northeast |  | Back-to-back commodity with $225M prepay
Xcel |  | Q101 |  | Baughman | Midwest |  | Enron sells 100 MW capacity |  | 600
Exelon |  | Q101 |  | Hammond | Northeast |  | Load shape/load following to West Hub |  | 500
Northwestern |  | Q101 |  | Booth | Development |  | Exclusivity fee on the GE 7EAs of $1M with a 50% split with West Origination |  | 500
Doyle |  | Q101 |  | Tapscott | Development |  | Reversal of 2000 Doyle Loss |  | 384
Structuring Fees |  | Q101 |  | [NAME] | Development |  | Structuring Fees |  | -250
Q1 COMPLETED DEALS
Blue Dog Turbines (Northwestern) |  | Q201 |  | Booth | Development |  | Sale of Blue Dog Turbines.  Total deal value is $8M with a 50/50 split with West Power.  $1M was recognized in Q1. |  | 3500
AES |  | Q201 |  | Booth | Development |  | Enron flips Haywood development site to AES with milestone payment for Interconnect Agreement with TVA.  Definitive agreements with AES 100% complete.  Interconnect Agreement with TVA being negotiated.  AES agreed to additional $1.2M cost savings incentive.
Las Vegas Turbines |  | Q201 |  | [NAME] | Development |  | Sale of Las Vegas turbines - Total deal value is $5.7M ($2.1M - East, $2.1M West and $1.5M QF) |  | 2100
BP Energy (Green Mountain Power) |  | Q201 |  | Curry | ERCOT |  | QSE/All Req.  Power Supply. |  | 2000
OPPD |  | Q201 |  | Clynes | Midwest |  | Buyout of '02 capacity contract |  | 1500
Various |  | Q201 |  | Various | Various |  | Deals < $1M each
CRRA |  | Q201 |  |  | Northeast |  | Reversal of Q1 origination that should have been granted to the Interest Rate Desk. |  | -701
Structuring Fees |  | Q201 |  | [NAME] | Development |  | Quarterly structuring fees associated with off balance sheet assets |  | -250
[NAME]
 |  |  |  |  |  |  | Total YTD
Management Summary Total As of 6-15-01