tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30643__HS FT Ont Central
Sheet: Financial Position Prior Day

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NYMEX Equivalent Gas Position
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Canadian Intra-Month Positions 1 Day Lag
TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  | 2000-05-25 17:25:10.540000 |  | 2000-06-30 00:00:00 |  | 2000-06-30 00:00:00 |  | 2000-07-31 00:00:00 |  | 2000-08-31 00:00:00 |  | 2000-09-30 00:00:00 |  | 2000-10-31 00:00:00 |  | 2000-11-30 00:00:00 |  | 2001-01-31 00:00:00 |  | 2002-01-31 00:00:00 |  | 2003-01-31 00:00:00 |  | 2004-01-31 00:00:00 |  | 2005-01-31 00:00:00 |  | 2011-01-31 00:00:00 |  | 2016-01-31 00:00:00 |  | Total ECT
To: | Order |  |  |  | 2000-05-25 17:25:10.540000 |  | Index |  | 2000-06-30 00:00:00 |  | 2000-07-31 00:00:00 |  | 2000-08-31 00:00:00 |  | 2000-09-30 00:00:00 |  | 2000-10-31 00:00:00 |  | 2000-12-31 00:00:00 |  | 2001-12-31 00:00:00 |  | 2002-12-31 00:00:00 |  | 2003-12-31 00:00:00 |  | 2004-12-31 00:00:00 |  | 2010-12-31 00:00:00 |  | 2015-12-31 00:00:00 |  | 2023-10-31 00:00:00 |  | May-00/Oct-23
FT - ONT - CENTRAL
Gas Daily | 1 |  | NGPRICE | P | 7 |  | 269.55834587 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 7
Index | 1 |  | NGPRICE | P | 0 |  | 741.8658013300002 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Basis - Notional | 3 |  | NGLTX | P |  |  |  |  | 573.6354349600001 |  | 349.1838404700001 |  | 380.33564327 |  | 287.2908973799999 |  | 451.6873953499999 |  | -135.87396294 |  | -183.3596992800001 |  | -145.0397149200001 |  | -181.42065193 |  | 161.23885733 |  | 248.35217528 |  | 0 |  | 0 |  | 1806.03021497
Basis - Equivalent | 4 |  | NGFPL | P |  |  |  |  | 3.323209422744469 |  | 3.875499637959621 |  | 1.578652494544208 |  | 1.514990107590449 |  | 1.596257774095541 |  | -1.905948616265419 |  | 0.0227695425597858 |  | 4.358183219019999 |  | 1.845843615995 |  | 0 |  | 0 |  | 0 |  | 0 |  | 16.20945719824365
Price | 5 |  | NGFPL | D |  |  |  |  | 99.68498686999999 |  | 5.809523889999994 |  | 73.67074810000003 |  | 3.086856800000007 |  | 11.34944082 |  | 29.87586836999999 |  | -50.78745851000001 |  | 0 |  | 1.4210854715202e-14 |  | 0 |  | -7.105427357601002e-15 |  | 0 |  | 0 |  | 172.68996634
TOTAL: |  |  |  |  | 7 |  | 1011.4241472 |  | 103.0081962927445 |  | 9.685023527959615 |  | 75.24940059454423 |  | 4.601846907590456 |  | 12.94569859409554 |  | 27.96991975373457 |  | -50.76468896744023 |  | 4.358183219019999 |  | 1.845843615995014 |  | 0 |  | -7.105427357601002e-15 |  | 0 |  | 0 |  | 195.8994235382436
Basis Roll-off |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Post Ids
Price |  |  |  |  | 790954
Basis |  |  |  |  | 790954
Gas Daily |  |  |  |  | 790957
Spreadsheet: 217946d1362260418-pulling-date-from-9-sheets-to-be-displayed-on-front-sheet-packing-list-final
Sheet: Collections

Courier Collections Today
 | Collection Date |  |  |  |  |  | -
 | [NAME] |  |  | Magnum |  |  | TNT Post |  |  | TNT UK |  |  | Dachser |  |  | Returns |  |  | Delivery |  |  | Showroom |  |  | Store
Total number of Collections
Total Number Packed
 | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Courier Collections Next 7 Days
 | Collection Date |  |  |  |  |  | -
 | [NAME] |  |  | Magnum |  |  | TNT Post |  |  | TNT UK |  |  | Dachser |  |  | Returns |  |  | Delivery |  |  | Showroom |  |  | Store
Total number of Collections
Total Number Packed
 | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C | Packing No. | P | C
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Spreadsheet: 328167d1403801689-populate-a-column-based-on-a-value-from-another-range-help
Sheet: List

Date | 2014-06-30 00:00:00 | 2014-07-01 00:00:00 | 2014-07-02 00:00:00 | 2014-07-03 00:00:00 | 2014-07-04 00:00:00 | 2014-07-05 00:00:00 | 2014-07-06 00:00:00 | 2014-07-07 00:00:00
Name |  | 2 | 1 | 1 |  |  | 2
[NAME] |  | 1 |  |  |  |  | 1
[NAME] |  | 1
[NAME] |  |  |  | 1
[NAME] R |  |  | 1 |  |  |  | 1
Spreadsheet: 790776d1659986592-mentor-and-mentee-matching-mentor-and-mentee-solver
Sheet: Sheet2

Matching
 |  |  |  |  |  |  |  |  | difference between mentor and mentee |  |  | difference between 1st mentee and 2 others
Mentor Circle Lead | Mentees |  |  |  | variables |  |  |  | 1st |  |  | 2nd | 3rd | difference between 2nd and 3rd
[NAME] |  |  |  |  | 8 | 3 | 7
Anna |  |  |  |  | 6 | 5 | 4
Tyler |  |  |  |  | 2 | 12 | 10
[NAME] |  |  |  |  | 9 | 1 | 11
Spreadsheet: 827061d1682454248-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3-netspy-
Sheet: XX-XX-XX

 | ANIMAL KINGDOM |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off | off |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Comments |  |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 7 | 8 | 9
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 7 | 8 | 9 |  |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 852233d1702320888-need-to-combine-and-replace-multiple-words-in-col-a-sentence-with-one-string-in-col-b-copy-replace-mutiple-strings-in-cell-with-one-string
Sheet: Sheet1

Original | If Cell contains 3H, Creatinine and Electrolyte, replace  with "Symptom Group 1". | 3H
C-Reactive Protein, CRP quantitative, CBC, Creatinine, [NAME], Rajpal kft, Urea, Uric acid
3H, A-one kFT, CBC, Creatinine, Electrolyte, Glucose, Random (RBS), Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, Lipid Profile, PTI, Urea, Uric acid
CBC, Creatinine, [NAME], Rajpal kft, SGOT/AST, SGPT/ALT, Urea, Uric acid
3H, A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), HbA1C, Glycosylated Hemoglobin, Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, PTI, Urea, Uric acid, [NAME], Vitamin D
3H, Blood Group ABO & Rh Typing, Blood, CBC, Creatinine, Electrolyte, Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, [NAME], SGOT/AST, SGPT/ALT, Urea, Uric acid
A-one kFT, CBC, Creatinine, Electrolyte, Urea, Uric acid, [NAME]
CBC, Creatinine, Electrolyte, LFT, Lipid Profile, [NAME], Urea, Uric acid
A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Urea, Uric acid, [NAME]
CBC, Creatinine, [NAME], Rajpal kft, Urea, Uric acid, [NAME]
3H, A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, PTI, Urea, Uric acid, [NAME]
3H, A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), Hepatitis B Surface Antigen (HBsAg) Australia Antigen, Rapid Card, Hepatitis C Total Antibody (Anti HCV), [NAME], HIV 1 & 2 spot test, LFT, PTI, Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Culture- urine, Electrolyte, Glucose, Random (RBS), LFT, Urea, Uric acid, [NAME], Vitamin D
A-one kFT, CBC, Creatinine, Electrolyte, FSH, Follicle Stimulating Hormone, [NAME], Random (RBS), LFT, Lipid Profile, [NAME], LH, Prolactin, Serum, Testosterone, Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Culture- urine, Dengue Rapid, Electrolyte, LFT, Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Electrolyte, Glucose, Random (RBS), LFT, Lipid Profile, Urea, Uric acid, [NAME], Vitamin D
Creatinine, [NAME], Rajpal kft, Urea, Uric acid
Creatinine, [NAME], Rajpal kft, Urea, Uric acid
Amylase, Serum, C-Reactive Protein, CRP quantitative, CBC, Creatinine, Dengue Rapid, Electrolyte, ESR, Erythrocyte Sedimentation Rate, LFT, [NAME], [NAME], Urea, Uric acid, [NAME]
A-one kFT, CBC, Creatinine, Electrolyte, Urea, Uric acid
C-Reactive Protein, CRP quantitative, Creatinine, Electrolyte, HbA1C, Glycosylated Hemoglobin, Lipid Profile, [NAME], Urea, Uric acid
Spreadsheet: 468672d1467444809-lookup-problem-to-excel-forum-010716-part2
Sheet: receipt

 | rdate | [NAME] | Date |  | Particulars | Voucher | asper formula | correct answers
M/S M | 2015-05-26 00:00:00 |  | [NAME] | LS/15-16/1315 | 100 |  |  | 2015-05-21 00:00:00
M/S E | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/7939 | 101 |  |  | 2015-03-09 00:00:00
M/S C | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/8000 | 102 |  |  | 2015-03-12 00:00:00
M/S C | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/7772 | 103 |  |  | 2015-03-02 00:00:00
M/S D | 2015-05-26 00:00:00 |  | [NAME] | LS/14-15/8008 | 104 |  |  | 2015-06-02 00:00:00
formula in c column | INDEX(sales!$A$1:$A$45000,MATCH(1,(sales!$B$1:$B$45000=RECEIPTS!A7862)*(sales!$D$1:$D$45000[NAME]))
formula in h column | [NAME])))
The last figure in ecolumn may differ by 1 or 2  so if idont get result in c colmn I will get in hcolumn
actual data is around 50000 rows
ist suggestion-IFERROR(LOOKUP(MID(E2,1,12),sales!$D$1:$D$6,sales!$A$1:$A$6),(LOOKUP(A2,sales!$B$1:$B$6,sales!$A$1:$A$6))) and format cell as date
2nd suggestion-IFERROR(INDEX(sales!$A$2:$A$6,MATCH(MID(receipt!E2,1,12),INDEX(MID(sales!$D$2:$D$6,1,12),),0)),"")
Spreadsheet: 886075d1736069416-extract-string-of-specific-pattern-extract-string-of-specific-pattern
Sheet: Sheet1

Data |  | text to extract | [NAME] | [NAME] | [NAME] | windknife
ad%#h odh oshscp8828g 82hsjsh |  | scp8828g
hasjdhlll 8jjsk gau7181h8jkk |  | gau7181h |  |  | gau7181h
sbc6611pjdiajan78jja |  | sbc6611p |  |  | sbc6611p
k&hsj-kak5555zhoho |  | kak5555z |  |  | kak5555z
ad%#h odh oshsc/8828g 82hsjsh |  | kak5555z
ad%#h odh oshsc/8828g 82hsjsh
ad%#h odh oshsc[882182hsjsh
asdf2w(**)(2234(()_sdfsd
Spreadsheet: 166979d1341857509-excel-2007-calculations-on-a-cell-containing-hours-and-minutes-timesheetexample-bbs10r-oeldere2-
Sheet: Sheet1

Whatever National Bank
Contractor Monthly Time Report
Consultant: |  | [NAME] |  |  |  |  |  |  |  | Time Period (mm/yy):04/09
 |  | Date
 | 2009-04-27 00:00:00 | 2009-04-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-30 00:00:00 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | 2009-05-03 00:00:00 | 2009-05-04 00:00:00 | 2009-05-05 00:00:00 | 2009-05-06 00:00:00 | 2009-05-07 00:00:00 | 2009-05-08 00:00:00 | 2009-05-09 00:00:00 | 2009-05-10 00:00:00 |  |  |  | Total
Start Time | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
End Time | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 |  |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00
Unbillable Time
Billable Time | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 0 | 0 |  |  |  | 80
Project #
 |  | Date
 |  | 2009-05-11 00:00:00 | 2009-05-12 00:00:00 | 2009-05-13 00:00:00 | 2009-05-14 00:00:00 | 2009-05-15 00:00:00 | 2009-05-16 00:00:00 | 2009-05-17 00:00:00 | 2009-05-18 00:00:00 | 2009-05-19 00:00:00 | 2009-05-20 00:00:00 | 2009-05-21 00:00:00 | 2009-05-22 00:00:00 | 2009-05-23 00:00:00 | 2009-05-24 00:00:00 |  |  | Total
Start Time |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 |  |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
End Time |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 |  |  | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00 | 17:00:00
Unbilliabe Time |  | 02:00:00 | 01:00:00 | 00:45:00 | 0.5 | 0.75 | 0 | 0 | 1.25
Billiable Time |  | 6.000000000000002 | 7 | 7.250000000000001 | 7.5 | 7.25 | 0 | 0 | 6.75 | 8 | 8 | 8 | 8 | 0 | 0 |  |  | 73.75
 |  |  |  |  |  |  |  |  |  |  |  | Total hours worked in month : |  |  |  |  |  | 153.75
Project #
 |  | Date
Spreadsheet: 70844d1271559529-sumif-formula-with-month-year-correct-date
Sheet: Sheet1

 |  |  |  |  |  |  | CHQ#
2010-03-05 00:00:00 | CHQ#00367 | 1 |  |  |  | 2010-03-01 00:00:00 | 0
2010-03-05 00:00:00 | CHQ#00368 | 2 |  |  |  | 2009-01-09 00:00:00 | 0
2010-03-05 00:00:00 | CHQ#00366 | 1
2010-03-05 00:00:00 | CHQ#00364 | 2
2009-01-01 00:00:00 | CHQ#003 | 1 | I need to correct the formula in order to work with G column type date formate. There is a formula already applied in H2 cell.
2009-01-02 00:00:00 | CHQ#0032 | 1
2009-01-03 00:00:00 | CHQ#0034 | 2
2009-01-04 00:00:00 | CHQ#004 | 1
 |  |  | I want to correct this formula in order to work with G column type formate.
Spreadsheet: dan_hyvl__4731__Select Energy - CWS
Sheet: Collateral Threshold

 |  |  | Northeast Utilities |  | Enron Corp
Total Combined Collateral Threshold
S&P | Moody's
A- or above | A3 or above |  | 40000000 |  | 90000000
BBB+ | Baa1 |  | 30000000 |  | 65000000
BBB | Baa2 |  | 17500000 |  | 40000000
BBB- | Baa3 |  | 15000000 |  | 30000000
BB+ | Ba1 |  | 0 |  | 0
Ratings are tied to guarantor Senior Unsecured Debts.  Collateral Threshold shall be the higher of the
two credit ratings (Moody's or S&P), so long as neither credit rating is placed on Moody's Watchlist or S&P's
CreditWatch with negative outlooks, negative or developing implications or under review for possible
downgrade.  In no case shall the Collateral Threshold be more than one credit rating higher than the
lowest credit rating and in the event that either credit rating is below BBB- or Baa3, the threshold shall be $0.
POWER - EEI Master Energy Purchase and Sale Agreement
S&P | Moody's
A- or above | A3 or above |  | 30250000 |  | 63000000
BBB+ | Baa1 |  | 21500000 |  | 43500000
BBB | Baa2 |  | 12250000
BBB- | Baa3 |  | 10000000
BB+ | Ba1
ISDA
S&P | Moody's
A- or above | A3 or above |  | 5750000 |  | 18000000
BBB+ | Baa1 |  | 5500000 |  | 15000000
BBB | Baa2 |  | 3500000
BBB- | Baa3 |  | 3500000
GAS (physical)
S&P | Moody's
A- or above | A3 or above
BBB+ | Baa1
BBB | Baa2
BBB- | Baa3
Spreadsheet: 754364d1636126228-lookups-between-workbooks-with-lookup-info-on-multiple-tabs-conditional-format-a-s-and-w-c-formula-example
Sheet: Sheet1

Name | Employee number | Leave type | Leave start date | Return to work Date | Amount of days out | Pro-ration Done? | Total intermittent FMLA hours used on year prior to today
[NAME] | 12345 | A/S | 2021-02-01 00:00:00 | 2021-04-02 00:00:00 |  | Y
[NAME] | 12345 | A/S | 2021-08-01 00:00:00 | 2021-09-10 00:00:00
[NAME] | 23456 | W/C | 2021-01-01 00:00:00 | 2021-03-31 00:00:00
[NAME] | 23456 | W/C | 2021-04-01 00:00:00 | 2021-08-15 00:00:00
[NAME] | 34567 | A/S | 2021-01-01 00:00:00 | 3/1/2021
[NAME] | 34567 | A/S | 2021-06-01 00:00:00 | 2021-07-31 00:00:00
Spreadsheet: 876787d1723514661-calculate-a-shift-by-time-and-day-of-week-doc1
Sheet: Sheet1

Date | DOW | Shift Start
2024-07-28 00:00:00 |  | 06:00:00
2024-07-28 00:00:00 |  | 18:00:00
2024-07-29 00:00:00 |  | 06:00:00
2024-07-29 00:00:00 |  | 16:30:00
2024-07-30 00:00:00 |  | 06:00:00
2024-07-30 00:00:00 |  | 16:30:00
2024-07-31 00:00:00 |  | 06:00:00
2024-07-31 00:00:00 |  | 16:30:00
2024-08-01 00:00:00 |  | 06:00:00
2024-08-01 00:00:00 |  | 16:30:00
2024-08-02 00:00:00 |  | 06:00:00
2024-08-02 00:00:00 |  | 18:00:00
2024-08-03 00:00:00 |  | 06:00:00
2024-08-03 00:00:00 |  | 18:00:00
2024-08-04 00:00:00 |  | 06:00:00
2024-08-04 00:00:00 |  | 18:00:00
2024-08-05 00:00:00 |  | 06:00:00
2024-08-05 00:00:00 |  | 16:30:00
2024-08-06 00:00:00 |  | 06:00:00
2024-08-06 00:00:00 |  | 16:30:00
2024-08-07 00:00:00 |  | 06:00:00
2024-08-07 00:00:00 |  | 16:30:00
2024-08-08 00:00:00 |  | 06:00:00
2024-08-08 00:00:00 |  | 16:30:00
2024-08-09 00:00:00 |  | 06:00:00
2024-08-09 00:00:00 |  | 18:00:00
2024-08-10 00:00:00 |  | 06:00:00
2024-08-10 00:00:00 |  | 18:00:00
2024-08-11 00:00:00 |  | 06:00:00
2024-08-11 00:00:00 |  | 18:00:00
Spreadsheet: 716354d1612184284-rent-spreadsheet-formulas-functions-assistance-please-rent-spread-sheet-gk2
Sheet: Payments

Tenant | Date | Amount
1 | 2020-02-02 00:00:00 | 100
2 | 2020-01-02 00:00:00 | 200
3 | 2020-01-03 00:00:00 | 300
4 | 2020-01-04 00:00:00 | 400
3 | 2020-01-08 00:00:00 | 300
2 | 2020-01-09 00:00:00 | 200
1 | 2020-01-10 00:00:00 | 100
4 | 2020-01-11 00:00:00 | 400
3 | 2020-01-15 00:00:00 | 300
2 | 2020-01-16 00:00:00 | 200
4 | 2020-01-17 00:00:00 | 250
1 | 2020-01-18 00:00:00 | 100
Spreadsheet: 703875d1605202183-count-occurrances-with-crieria-from-other-column-s-samph
Sheet: report1605200133665

id: |  | status: | job: | Expected Value:
113062 |  | Complete | Job-12485 |  | 5
113062 |  | Complete | Job-124855 |  | 5
113062 |  | Complete | Job-124856 |  | 5
113062 |  | Complete | [NAME] |  | 5
113062 |  | Complete | Job-124858 |  | 5
113062 |  | Cancelled | [NAME] |  | 5
1144 |  | Complete | Job-138624 |  | 1
114443 |  | Cancelled | [NAME] |  | 0
11543 |  | Complete | Job-147 |  | 1
1155 |  | Complete | Job-150 |  | 2
1155 |  | Complete | Job-176 |  | 2
Spreadsheet: 752744d1634918569-filter-by-date-and-time-book1
Sheet: Sheet1

Time | Registration | Date
01:30:08 | BK20 FUV | 2021-10-13 00:00:00
04:54:32 | PF65 UHB | 2021-10-14 00:00:00
04:59:09 | PJ68 KZY | 2021-10-14 00:00:00
05:15:57 | MX70 LMV | 2021-10-15 00:00:00
05:17:52 | HK65 OMU | 2021-10-14 00:00:00 |  |  | You would write in below and it would fill all the info from the dataset
05:21:06 | HK65 OMU | 2021-10-12 00:00:00
05:57:53 | HK65 OMU | 2021-10-14 00:00:00 |  |  | Start Time | End Time | Registration | Data
06:55:07 | HK65 OMU | 2021-10-16 00:00:00
07:31:11 | HK65 OMU | 2021-10-11 00:00:00
07:49:24 | HK65 OMU | 2021-10-11 00:00:00
08:01:50 | MX70 LOD | 2021-10-13 00:00:00
08:08:20 | HK65 OMU | 2021-10-13 00:00:00
08:34:15 | HK65 OMU | 2021-10-13 00:00:00
08:35:03 | HK65 OMU | 2021-10-14 00:00:00
09:13:06 | MX70 LRL | 2021-10-14 00:00:00
10:02:40 | PF65 YUA | 2021-10-14 00:00:00
10:08:21 | WT19 TZB | 2021-10-14 00:00:00
10:41:25 | WT19 TZB | 2021-10-14 00:00:00
10:43:34 | PN16 BYB | 2021-10-14 00:00:00
11:26:14 | WT19 TZB | 2021-10-15 00:00:00
11:46:03 | PN16 BYB | 2021-10-15 00:00:00
11:58:26 | PJ68 KZX | 2021-10-15 00:00:00
12:01:20 | WX18 WWD | 2021-10-16 00:00:00
12:05:47 | WX18 WWD | 2021-10-10 00:00:00
12:10:18 | WT19 TZB | 2021-10-11 00:00:00
12:33:37 | WX18 WWD | 2021-10-11 00:00:00
12:53:11 | WM69 MYR | 2021-10-11 00:00:00
13:03:09 | WP65 RUJ | 2021-10-11 00:00:00
13:19:59 | WR69 AZX | 2021-10-11 00:00:00
13:37:18 | WP65 RUJ | 2021-10-12 00:00:00
13:39:53 | WP65 RUJ | 2021-10-12 00:00:00
13:41:46 | WM69 MYR | 2021-10-12 00:00:00
13:46:18 | HK65 OMU | 2021-10-12 00:00:00
13:50:10 | WP65 RUJ | 2021-10-12 00:00:00
13:53:25 | WP65 RUJ | 2021-10-12 00:00:00
13:54:15 | WM69 MYR | 2021-10-12 00:00:00
13:56:39 | WR69 AZX | 2021-10-13 00:00:00
13:57:13 | WX18 WWD | 2021-10-13 00:00:00
14:03:14 | HK65 OMU | 2021-10-13 00:00:00
14:05:05 | PJ65 HYT | 2021-10-13 00:00:00
14:05:43 | HK65 OMU | 2021-10-13 00:00:00
14:07:53 | WT19 TZB | 2021-10-13 00:00:00
14:10:06 | WT19 TZB | 2021-10-13 00:00:00
14:11:13 | WR69 AZX | 2021-10-13 00:00:00
14:19:21 | WX18 WWD | 2021-10-13 00:00:00
14:22:41 | WT19 TZB | 2021-10-13 00:00:00
14:24:33 | WM69 MYR | 2021-10-14 00:00:00
14:26:47 | WT19 TZB | 2021-10-14 00:00:00
14:30:33 | WM69 MYR | 2021-10-14 00:00:00
14:31:12 | WM69 LCW | 2021-10-14 00:00:00
Spreadsheet: 161851d1339658292-excel-2007-counting-date-in-specific-month-by-month-book1
Sheet: Sheet1

 |  | 6 | 7 | 8 | 9 | 10
2012-06-28 00:00:00 | 2012-07-03 00:00:00 | 2 | 3 | 0 | 0 | 0
2012-06-13 00:00:00 | 2012-06-15 00:00:00 | 2 | 0 | 0 | 0 | 0
2012-06-20 00:00:00 | 2012-10-05 00:00:00 | 10 | 31 | 31 | 30 | 5
Spreadsheet: 9f3b5c24-f49e-4ab1-b785-726906a552ab
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
263466 | 69956 | [NAME] | [NAME] | USA |  | 00:24:19 | 00:03:10 | 00:48:41 | 00:02:42 | 00:32:44 | 5 | 01:51:38
263466 | 51374 | [NAME] | Lesicko | USA |  | 00:14:58 | 00:01:31 | 00:44:44 | 00:02:07 | 00:32:06 | 3 | 01:35:29
263466 | 32652 | [NAME] | Fisher | USA |  | 00:14:37 | 00:01:59 | 00:35:42 | 00:02:42 | 00:26:58 | 1 | 01:21:59
263466 | 32650 | [NAME] | Draper | USA |  | 00:20:12 | 00:01:55 | 00:44:27 | 00:02:52 | [NAME] | 4 | 01:37:16
263466 | 60933 | [NAME] | [NAME] | USA |  | 00:14:38 | 00:01:52 | 00:39:54 | 00;02:37 | 00:27:12 | 2 | 01:26:15
Spreadsheet: jane_tholt__13063__blanco traders
Sheet: Sheet1

Enron Online
EPNG Blanco Approved Trading Partners
 | Company | Global ID |  | Status
1 | Amoco Energy Trading Corporation | 12 |  | Execute
2 | Burlington Resources Trading Inc. | 49935 |  | Execute
3 | Conoco Inc | 3497 |  | Execute
4 | Duke Energy Trading and Marketing, LLC | 54979 |  | Execute
5 | e prime, inc. | 51163 |  | Execute
6 | El Paso Merchant Energy - Gas, L.P. | 72297 |  | Execute
7 | Enron Energy Services, Inc. | 57956 |  | Execute
8 | Nevada Power Company | 2325 |  | Execute
9 | ONEOK Energy Marketing and Trading Company, II (formly, Oneok Gas Marketing Company) | 2425 |  | Execute
10 | Occidental Energy Marketing, Inc. | 63665 |  | Execute
11 | PanCanadian Energy Services Inc. | 61839 |  | Execute
12 | Phillips Petroleum Company | 2089 |  | Execute
13 | PNM Gas Services |  |  | Currently Not on EnronOnline
14 | Salt River Project Agricultural Improvement and Power District | 2765 |  | Execute
15 | SG Interests I, Ltd. | 193 |  | READ ONLY
16 | Southern California Gas Company | 2872 |  | Execute
17 | Southern Company Energy Marketing, L.P. | 56264 |  | Execute
18 | Southwest Gas Corporation | 2907 |  | Execute
19 | Texaco Natural Gas Inc. | 3022 |  | Execute
20 | Tristar Gas Marketing Company | 11187 |  | Execute
21 | Williams Energy Marketing and Trading Company | 64245 |  | Execute
Spreadsheet: kim_ward__20785__California
Sheet: Calpine Deal

Includes no ramp-up.  Simply a step-up from 200 to 1000 MW on Jan '04
Deal Value | 4600000000
Start | 2001-10-01 00:00:00
End | 2003-12-31 00:00:00 | 2011-12-31 00:00:00
MW | 200 | 1000
Days
Hours
MWh
Total MWh
$/KWh
Assumes a linear increase from 200 MW on Oct '01 to 1000 MW on Jan '04
Deal Value | 4600000000
Start | 2001-10-01 00:00:00
End | 2003-12-31 00:00:00 | 2011-12-31 00:00:00
MW | 600 | 1000
Days
Hours
MWh
Total MWh
$/KWh
Conclusion: The actual value probably lies somewhere in between.  $0.058/KWh is a reasonable approximation.
Spreadsheet: 161581d1339568080-excel-2007-identify-nth-value-in-a-range-example
Sheet: Sheet1

name | status
client 1 | x
client 2 | x
client 3 | x
client 4
client 5
client 6 | x
client 7
client 8
client 9 | x
client 10
client 11 | x
client 12 | x
client 13
client 14