tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__33739__Metrics 0727
Sheet: Energy Capital Res.

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Energy Capital Resources
Results based on Activity through July 27, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 4
 |  | Weekly Summary - 2Q00 through 2Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-07-07 00:00:00
Postings Rollforward:
Beginning |  | 12
+ Entrances |  | 0 | 0 | 0 | 4
- Exits |  | 0 | 0 | 0 | 4
- Executions |  | 0 | 0 | 0 | 1
Ending
Postings Rollforward:
Beginning
+ Entrances
- Exits
+/- [NAME]
- Executions
Ending
Average Deal Size
 |  | Quarterly Summary ($ millions)
 |  |  |  |  |  |  |  | Forward Quarters
 | YTD |  |  | Current Quarter |  | Per |  |  |  |  | Total Year
 | 2000 |  |  | 3Q00 |  | Hot List |  | 4Q00 |  |  | 2000 |  |  | 1Q01 |  |  | 2Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions |  |  |  | 1 | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
DPR/MPR |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  | 0
Postings |  |  |  | 5 | 0 |  |  | 6 | 0 |  |  |  |  | 0 | 0 |  | 0 | 0
Identified Margin
Budget |  | 2
$ Coverage
Spreadsheet: 168554d1342501590-radio-buttons-radiobutton-solution
Sheet: SUMMARY PAGE

 |  | Revenue | Nights | ARR
 | Segment 1 |  |  |  |  |  |  |  | 1
 | Segment 2
 | Segment 3
 | Segment 4
 | Segment 5
 | Segment 6 |  |  |  |  |  | *** Function that once I click Hotel 1, the data from DATA Sheet will populate to column C D E.
 | Segment 7
 | Segment 8
 | Segment 9
 | Segment 10
 | Segment 11
 | Segment 12
Spreadsheet: 862772d1710404153-filtering-issue-based-on-adding-a-rank-column-top-3-aligw
Sheet: Sheet1

id | name | Crit_A | Crit_B | rank
12047 | name A | 1 | 0.1
12610 | name B | 7 | 0.2
12330 | name C | 12 | 0.21
12375 | name D | 1 | 0.14
12505 | name H | 13 | 0.66
12596 | name F | 8 | 0.9
12554 | name E | 7 | 0.77
11909 | name G | 9 | 0.88
12325 | name I | 19 | 0.15
12999 | name J | 1 | 0.01
Spreadsheet: 709594d1608427862-change-formula-to-ignore-hidden-tabs-excelforum1335831programme-test
Sheet: Block 8

Item Name | Price | 52 | 53 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Total | Totals
Product 1 | 0.05
Product 2 | 0.1
Product 3 | 0.15
Product 4 | 0.2
Product 5 | 0.25
Product 6 | 0.3
Product 7 | 0.35
Product 8 | 0.4
Product 9 | 0.45
Product 10 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  | 0.0001 |  |  |  |  |  | Pol:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + 20% VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block | Area | Area | Perimeter (glass/path)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 1 | 23490 | A | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 2 | 6441 | B | 840
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 3 | 5698 | C | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 4 | 8728 | D | 1120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 5 | 2508 | E | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 6 | 13440 | F | 760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 7 | 14976 | G | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 8 | 14940 | H | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 9 | 5455 | I | 430
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 10 | 5698 | J | 430
Spreadsheet: e2b78212-efd0-4857-bd2a-ff53ed82370d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2562 | 13743 | [NAME] | Mcgrath | CAN | 61 | 01:57:00 | 00:12:02 | 04:46:48 | 00:09:23 | 03:32:41 | 1 | 10:37:51
Spreadsheet: 75e56707-1eb8-4eaf-8bed-bcab1377bdbc
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
SALS | Test | SALS | Serologic Agglut Method Ident | Serologic Agglut Method 1 Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87147 |  |  |  |  | Rochester
SALS | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 747646d1631626489-compare-time-may-be-index-and-match-function-ctg
Sheet: Sheet1

Date | CPD Actual or Projected % | [NAME]/MW | CTG 1 MW Achieved | Time On | Time Off | Total Run Time Hours on CTG Unit | NG Flow kg/hr Increase from NG Meter G1.FQG/G1-96FM-T2 | Rational For Peak Firing | Rational For No Peak Firing | Comments | USE Name
2021-07-07 00:00:00 | N/A | >500 | 3 | 12:00:00 | 20:15:00 | 167.23
2021-07-12 00:00:00 | N/A | >501 | 4 | 17:00:00 | 19:00:00 | 169.35
2021-07-14 00:00:00 | 1 | 1000 | 4.5 | 18:45:00 | 22:40:00 | 173.24
2021-07-15 00:00:00 | 0.985 | 430 | 4 | 14:00:00 | 18:35:00 | 177.89
2021-07-26 00:00:00 | N/A | 533 | 4.1 | 13:15:00 | 19:30:00 | 184.18
2021-08-03 00:00:00 | 1.015 | N/A | 3.6 | 13:33:00 | 19:07:00 | 189.7
2021-08-04 00:00:00 | N/A | 750 | 4 | 12:30:00 | 14:30:00 | 191.29
2021-08-04 00:00:00 | N/A | >700 | 3.6 | 14:45:00 | 18:10:00 | 194.75
2021-08-05 00:00:00 | 0.995 | >700 | N/A | 18:45:00 | 22:40:00 | N/A
Spreadsheet: 700516d1603216136-quartile-with-multiple-criteria-without-using-array-sample
Sheet: Sheet1

Date | Service Type | Duration | [NAME]
2020-10-01 00:00:00 | Appointment | 224
2020-10-01 00:00:00 | Appointment | 234
2020-10-01 00:00:00 | Medicare | 289
2020-10-01 00:00:00 | Medicare | 364
2020-10-01 00:00:00 | Prescription | 455
2020-10-01 00:00:00 | Prescription | 494
2020-10-01 00:00:00 | Appointment | 578
2020-10-01 00:00:00 | Appointment | 599
2020-10-01 00:00:00 | Appointment | 934
2020-10-01 00:00:00 | Medicare | 494
Spreadsheet: 489586d1479339682-find-one-cell-up-help
Sheet: Sheet1

 |  |  |  |  | Series Totals
 | Last weeks average | This weeks average |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12
 |  |  | [NAME] |  | 597 | 554 | 588
 |  |  | [NAME] |  | 602
 |  |  | [NAME] |  | 625 | 588 | 615
 |  |  | [NAME] |  |  | 634 | 601
 |  |  | [NAME] |  | 578 | 596
 |  |  | [NAME] |  | 602 | 635 | 575
 |  |  | [NAME] |  | 600 | 600 | 600
 |  |  | Mark |  | 525 | 575 | 584
Spreadsheet: 117682d1312961162-expanding-sum-based-on-months-excel-upload-1-
Sheet: VPA JAN VAR

 | 1 | MONTH |  | February | Note: Select a month from E1
 |  |  |  |  | Note: the fomula  in yellow highligted cells are linked with E1
 |  |  |  |  |  | HEAD OFFICE P&L [NAME]
 |  | Account Number | Account Description |  |  | Variance $ | [NAME] | YTD Actual | YTD Budget | Variance $ | [NAME]
 |  | 2-1-1-820 | TURNOVER - EXTERNAL
 |  | 2-2-1-820 | TURNOVER - EXTERNAL
 |  | 2-3-1-820 | TURNOVER - EXTERNAL
 |  | 2-3-2-820 | TURNOVER - EXTERNAL
 |  | 2-4-1-820 | TURNOVER - EXTERNAL
 |  | 2-5-1-820 | TURNOVER - EXTERNAL
 |  | 2-6-1-820 | TURNOVER - EXTERNAL
 |  | 2-1-1-821 | TURNOVER - INTERCOMPANY
 |  | 2-2-1-821 | TURNOVER - INTERCOMPANY
 |  | 2-3-1-821 | TURNOVER - INTERCOMPANY
 |  | 2-3-2-821 | TURNOVER - INTERCOMPANY
 |  | 2-4-1-821 | TURNOVER - INTERCOMPANY
 |  | 2-5-1-821 | TURNOVER - INTERCOMPANY
 |  | 2-6-1-821 | TURNOVER - INTERCOMPANY
 |  | 2-1-1-800 | PROGRESS CLAIMS - LTD
 |  | 2-2-1-800 | PROGRESS CLAIMS - LTD
 |  | 2-3-1-800 | PROGRESS CLAIMS - LTD
 |  | 2-3-2-800 | PROGRESS CLAIMS - LTD
 |  | 2-4-1-800 | PROGRESS CLAIMS - LTD
 |  | 2-5-1-800 | PROGRESS CLAIMS - LTD
 |  | 2-6-1-800 | PROGRESS CLAIMS - LTD
Spreadsheet: 77316d1277817300-match-numbered-text-to-text-example
Sheet: Sheet1

Imported From Text File
Output File For Lloyds Appointment Figures
Coventry |  | Converted to month |  |  | List of Months |  | Calc to match month of imported file
39845 |  | 2009-02-01 00:00:00 |  |  | Jan |  | NO
Date  29/06/2010 |  |  |  |  | Feb |  | NO |  | Trying to return H6 as 1
Time  13:01:28 |  |  |  |  | Mar |  | NO
 |  |  |  |  | Apr |  | NO
No/Date/Customer/App No/Sat/Sold/Value/Cash/Fin/OTN/Re-App/Dead/Quoted/Comments (1)/Comments (2) |  |  |  |  | May |  | NO
1/1/1/1/-/-/-/-/-/-/-/-/-/-/test |  |  |  |  | Jun |  | NO
1/22/brown/2/Yes/Yes/10000/Yes/No/Yes/No/No/12000/sold/sold |  |  |  |  | Jul |  | NO
1/23/brown 2/3/Yes/No/12000/No/Yes/No/No/No/15000/sold/test |  |  |  |  | Aug |  | NO
21/24/BROWN 3/4/Yes/No/20000/-/-/-/-/-/-/NOT/- |  |  |  |  | Sep |  | NO
1/1/1/1/Yes/No/1/-/-/-/-/-/-/-/- |  |  |  |  | Oct |  | NO
////////////// |  |  |  |  | Nov |  | NO
////////////// |  |  |  |  | Dec |  | NO
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
//////////////
Date/App./Customer/Value/C/F
1/1/dfg/-/-/-
2/3/green/2000/Yes/Yes
/////
/////
/////
/////
/////
/////
/////
/////
/////
Date/App./Customer/Value/C/F/Month/Year
1/1/1/1/Yes/Yes/Feb/2010
2/3/dsfg/2222/Yes/No/Mar/2009
///////
///////
///////
///////
///////
///////
///////
///////
Totals/Month
SAT/4
SOLD/1
PER/0.25
O.T.N/1
PER/1
Value/42001
Spreadsheet: 799078d1664902163-insert-graphs-that-automatically-update-based-on-variables-chart-eba
Sheet: 1

 |  | # | level |  | # | level |  | # | level |  | # | level
 |  | 1 | -5.12 |  | 17 | -4.82 |  | 33 | -5.41 |  | 49 | -5.51
 |  | 2 | -5.01 |  | 18 | -4.82 |  | 34 | -5.12 |  | 50 | -5.21
 |  | 3 | -5.32 |  | 19 | -5.31 |  | 35 | -5.31 |  | 51 | -5.31
 |  | 4 | -5.31 |  | 20 | -5.21 |  | 36 | -4.22 |  | 52 | -4.82
 |  | 5 | -5.12 |  | 21 | -5.11 |  | 37 | -5.02 |  | 53 | -5.4
 |  | 6 | -5.01 |  | 22 | -4.81 |  | 38 | -4.91 |  | 54 | -5.11
 |  | 7 | -5.12 |  | 23 | -5.01 |  | 39 | -5.62 |  | 55 | -5.31
 |  | 8 | -5.71 |  | 24 | -4.61 |  | 40 | -5.21 |  | 56 | -5.11
 |  | 9 | -5.11 |  | 25 | -5.31 |  | 41 | -4.91 |  | 57 | -5.11
 |  | 10 | -4.82 |  | 26 | -4.62 |  | 42 | -4.71 |  | 58 | -4.82
 |  | 11 | -5.11 |  | 27 | -5.12 |  | 43 | -5.21 |  | 59 | -5.32
 |  | 12 | -5.21 |  | 28 | -4.82 |  | 44 | -5.11 |  | 60 | -5.11
 |  | 13 | -5.21 |  | 29 | -4.81 |  | 45 | -5.51 |  | 61 | -5.31
 |  | 14 | -5.31 |  | 30 | -4.62 |  | 46 | -5.41 |  | 62 | -5.31
 |  | 15 | -5.61 |  | 31 | -5.41 |  | 47 | -6.01 |  | 63 | -5.81
 |  | 16 | -3.92 |  | 32 | -5.91 |  | 48 | -5.31 |  | 64 | -4.92
 |  |  |  |  |  |  | SUM 1-64
 |  |  |  |  |  |  | AVG
 |  |  |  |  |  |  | MIN
 |  |  |  |  |  |  | MAX
Spreadsheet: joe_parks__14808__bridgeline 6-20
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
S | NGN2 | 3330 | 25 | 00:30:08 | 905 | 97563 | 4C | 2542 | amk | EO-2542 | 856 | 0 | Y
S | NGN2 | 3335 | 10 | 17:26:27 | 905 | 97563 | 4C | 1766 | amk | EO-1766 | 425 | 0 | Y
B | [NAME] | 3429 | 3 | 08:24:02 | 905 | 97563 | 4C | 3530 | amk | EO-3530 | 1529 | 0 | N
B | [NAME] | 3429 | 1 | 08:31:53 | 905 | 97563 | 4C | 3530 | amk | EO-3530 | 1573 | 0 | N
B | [NAME] | 3429 | 1 | 08:31:59 | 905 | 97563 | 4C | 3530 | amk | EO-3530 | 1574 | 0 | N
B | [NAME] | 3430 | 1 | 08:24:08 | 905 | 97563 | 4C | 3531 | amk | EO-3531 | 1530 | 0 | N
B | [NAME] | 3430 | 23 | 08:24:08 | 905 | 97563 | 4C | 3531 | amk | EO-3531 | 1531 | 0 | N
B | [NAME] | 3430 | 10 | 08:24:08 | 905 | 97563 | 4C | 3531 | amk | EO-3531 | 1532 | 0 | N
Spreadsheet: 838612d1691164017-timesheet-not-calculating-properly-looking-for-help-blank-timesheet-fy24
Sheet: Sheet1

TIME SHEET |  |  | NAME: | [Name] |  | [Role] |  | Salary
DAY | DATE | Non/Union | IN | OUT | BREAK | TOTAL | TOTAL PAID | Show
MONDAY | 2023-07-31 00:00:00 | N | 09:00:00 | 15:00:00 | 0.5
TUESDAY | 2023-08-01 00:00:00 | N | 10:00:00 | 17:00:00 | 1.5
WEDNESDAY | 2023-08-02 00:00:00 | N | 09:30:00 | 16:30:00 | 1
THURSDAY | 2023-08-03 00:00:00 | N | 10:00:00 | 20:00:00 | 2.5
FRIDAY | 2023-08-04 00:00:00 | N | 10:30:00 | 17:30:00 | 2.5
SATURDAY | 2023-08-05 00:00:00 |  | 00:00:00 | 17:00:00
SUNDAY | 2023-08-06 00:00:00
WEEKLY TOTAL: |  | Rate | 25 | Total @ Rate:
 |  | Over Time | 37.5 | Total @ OT:
 |  |  |  | Grand Total:
Submitted by: [NAME] |  |  |  |  | Approved by: |  | [Name]
Spreadsheet: 143212d1330303865-problems-with-pivot-table-sales-20summary-20test-1-
Sheet: Pivot

Channel | (All)
 | Values
Row Labels | Units Sold | $ Sales | $ GM | % GMN | Margin | [NAME]
Medium screw | 360 | 402.45 | 284.85 | 0.7077897875512486
Small screw | 335 | 427.35 | 240.81 | 0.5634959634959634
Large Screw | 92 | 90.61 | 37.22 | 0.4107714380311224
(blank)
Grand Total | 787 | 920.4100000000001 | 562.8800000000001 | 0.611553546788931
 | * How do I insert a calculated field to show the cumulative margin, as a % of total margin?
 | * In trying to use a helper column, I can't get the cell formula in column F to pick up the value in column D. Even removing absolute cell references does not help
Spreadsheet: 275279d1383430361-need-to-copy-all-data-for-each-week-and-compile-to-one-sheet-for-year-to-date-data-consolodate-weeks-sheets-to-summary-sheet-1-
Sheet: Week44

2013-10-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
Employee# | Nameee | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour | Employee# | Name | task | # of hour
1111 | Name1 | task1 | 5 | 1111 | Name1 | task1 | 10 | 1111 | Name1 | task1 | 5 | 1111 | Name1 | task1 | 5 | 1111 | Name1 | task1 | 111 | 1111 | Name1 | task1 | 1111
2222 | [NAME] | [NAME] | 10 | 2222 | [NAME] | [NAME] | 5 | 2222 | [NAME] | [NAME] | 7 | 2222 | [NAME] | [NAME] | 10 | 2222 | [NAME] | [NAME] | 222 | 2222 | [NAME] | [NAME] | 2222
3333 | Namde3 | [NAME] | 15 | 3333 | Namde3 | task1 | 15 | 3333 | Namde3 | [NAME] | 6 | 3333 | Namde3 | [NAME] | 25 | 3333 | Namde3 | task1 | 333 | 3333 | Namde3 | task1 | 3333
 |  |  |  |  |  |  |  | 4444 | name4 | task3 | 10 | 4444 | name4 | task3 | 10
 |  |  |  |  |  |  |  |  |  |  |  | 5555 | name5 | task4 | 11
Spreadsheet: john_zufferli__16813__Enron Security Jan 29 2002
Sheet: Sheet1

Enron Canada Power Corp.
Security Transactions with the Power Pool
 | January | February | March | April
Baseload MWh | 125364 | 113232 | 125364 | 117720
Peak MWh | 24960 | 23040 | 24960 | 18720
Total MWh
Baseload Price | 30 | 30 | 30 | 32
Peak Price | 40 | 40 | 40 | 42
Total Dollar Value
Trading Charge
Dollar Value with GST
60 Day Security Requirement |  | 9747063.9492 | 9747063.9492 | 9998234.1228
 |  | 3821.184000000001 | May - 37,200 MW in ECP- |  | (ETS corrections)
 |  | 3397.258560000001 | Sept -33,073 MW in ECP- |  | (ETS corrections)
 |  | 9027064 | December payable to Enron (per ETS statement)
 |  | 9034282.44256 | Power Pool owes Enron Canada Power on January 29, 2002
 |  | -6950000 | Security deposit to Pool
 |  | 2084282.44256 | Owed to Enron on January 29 after security deposit of $6.95 M withheld
 |  | 2800000 | Security held by [NAME] (received Jan 8, 2002)
 |  | 6950000 | Security held by [NAME] (received Jan 29, 2002)
 |  | 9750000 | Security held by Power Pool for Enron Canada Power
Spreadsheet: mark_taylor__24699__Potential Customers EOL
Sheet: Sheet1

 | Client Category Profile
 | Type of Client | Credit Limit | Product Profile |  |  |  |  |  | Contitions
 | (Definition of Client Type) |  | Arg NG Phy | [NAME] | [NAME] | ENA WTI | Other | Other | PA | RF | ETA | GTC NG Phy | GTC P Phy | GTC P Fin | Other
1 | Power Generators | < 20,000 | Yes | Yes | No | No | No |  | Yes | Yes | No | No | No | No
 |  | > 20,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes
2 | Gas Producers | < 20,000 | Yes | No | No | No | No |  | Yes | Yes | No | No | No | No
 |  | > 20,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes
3 | Power LDC's | < 20,000 | No | Yes | No | No | No |  | Yes | Yes | No | No | No | No
 |  | > 20,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes
4 | Gas LDC's | < 20,000 | Yes | No | No | No | No |  | Yes | Yes | No | No | No | No
 |  | > 20,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes
5 | Marketers | < 20,000 | Yes | Yes | No | No | No |  | Yes | Yes | No | No | No | No | Agreement
 |  | > 20,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Agreement
6 | Third Party Program | < 20,000 | Yes | Yes | No | No | No |  | Yes | Yes | No | No | No | No | Agreement
 |  | > 20,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes | Agreement
7 | Large Industrials | < 20,000 | Yes | Yes | No | No | No |  | Yes | Yes | No | No | No | No
 |  | > 20,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes
8 | Pymes | < 10,000 | Yes | Yes | No | No | No |  | Yes | Yes | No | No | No | No
 |  | > 10,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes
9 | "P" Customers | < 10,000 | Yes | Yes | No | No | No |  | Yes | Yes | No | No | No | No
 |  | > 10,000 | Yes | Yes | Yes | Yes | Yes |  | Yes | Yes | Yes | Yes | Yes | Yes
10
11
Spreadsheet: 830575d1684987038-formula-required-to-determine-payouts-payout-formula
Sheet: Sample Data

 | Payout % of the 40% total column (J) |  |  |  |  |  |  | All results need to be rounded to nearest dollar
 | 1st | 1st | 1
 | 1st, 2nd | 1st | 0.6 | 2nd | 0.4
 | 1st, 2nd, 3rd | 1st | 0.6 | 2nd | 0.3 | 3rd | 0.1
 | Scenario One |  |  |  |  |  |  |  |  |  |  | Scenario Two |  |  |  |  |  |  |  |  |  |  | Scenario Three
 | Total Places | Value 1st | Number of 1st place | Value 2nd | Number of 2nd place | Value 3rd | Number of 3rd place | Total | 40% of Total | Rounded Check Value |  | Total Places | 1st | Number of 1st place | 2nd | Number of 2nd place | 3rd | Number of 3rd place | Total | 40% of Total | Rounded Check Value |  | Total Places | 1st | Number of 1st place | 2nd | Number of 2nd place | 3rd | Number of 3rd place | Total | 40% of Total | Rounded Check Value
 | 1 |  | 1 | 0 |  | 0 |  | 500 | 200 |  |  | 1 |  | 1 | 0 |  | 0 |  | 500 | 200 |  |  | 1 |  | 1 | 0 |  | 0 |  | 500 | 200
 | 2 |  | 1 |  | 1 | 0 |  | 500 | 200 |  |  | 2 |  | 2 | 0 |  | 0 |  | 500 | 200 |  |  | 2 |  | 2 | 0 |  | 0 |  | 500 | 200
 | 3 |  | 1 |  | 1 |  | 1 | 500 | 200 |  |  | 3 |  | 1 |  | 2 | 0 |  | 500 | 200 |  |  | 3 |  | 3 | 0 |  | 0 |  | 500 | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 |  | 1 | 0 |  | 500 | 200
 | All scenarios need to be run on the first row in the blue area. (J8-K8) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 1 |  | 2 |  | 3 | 500 | 200
 | I have shown separate rows and scenrios for ease of understanding what I am trying to accomplish
 | My currect formulas all work except when number of places change.
Spreadsheet: 2543b1ac-8209-457f-b0d2-4c52a13e6e5c
Sheet: Sheet1

Unnamed: 0 | Professional Development Log of Hours Worksheet Form | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Please fill in the number of hours where applicable and the form will automatically add the total hours and calculate the total number of units.
 | TYPE OF EVENT (conference, workshop/seminar, scholarly/creative works) and TITLE OF EVENT OR WORK | DATE      mm/dd/yyyy | TIME OF EVENT + a.m. or p.m. | HOURS OF ATTENDANCE OR WORK  - numbers only.  30 hours = 1 unit | PRESENTER HOURS - numbers only. (do not include in attendance hours)  15 hours = 1 unit
 |  |  |  | TOTAL HOURS | TOTAL PRESENTER HOURS
 |  |  |  | 0 | 0
 |  |  | GRAND TOTAL UNITS | TOTAL UNITS | TOTAL PRESENTER UNITS
 |  |  | 0 | 0 | 0
Spreadsheet: 671267d1586335475-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 12 FRIDAY

DAY: |  | FRIDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: joe_parks__14752__ITM 02 Positions
Sheet: Run Query

Daily Hedge Strip
User ID:
Password:
Included Deals | ALL
Today
Days in Month | 31
Day of Month |  |  | Update this cell daily.
PromptMonth | 2002-04-01 00:00:00 | 2002-04-30 00:00:00
StartRange | D4
Enter NYMEX Date:
[NAME] | NXB2 | NX1
2002-03-22 00:00:00 | 2002-03-25 00:00:00 | 2002-03-26 00:00:00
 | Update this cell daily.
Password: | Current Post Id's | Prior Post Id's
Date |  | Column | # | Name | Type | Book Type | Book
Post Ids | 1498454 | 22 | 1 | Price |  | P | ENA-FT-WC-SOCAL-PRC
 |  | 23 |  | Basis | Basis | D | ENA-FT-WC-SOCAL-BAS
 |  | 24 |  | Index |  | I | ENA-FT-WC-SOCAL-IDX
 |  | 28 |  | Gas Daily | [NAME] | M | ENA-FT-WC-SOCAL-GDL
 |  | 30 |  | GDY | GD Index | Y | ENA-FT-WC-SOCAL-GDI
 | 0 | 7 |  | Physical |  | PHY | ENA-IM-WT-SOCAL-PHY
 | 0 | 15 |  | Price |  | P | FT-WEST-OPT-PRC
 | 0 | 16 | 8 | Basis | Basis | D | FT-WEST-OPT-BAS
 | 0 | 17 | 9 | GDL | [NAME] | M | ENA-FT-WT-SCAN-GDL
 |  |  |  |  |  | PO | FT-WE-XL-OPT-PRC
 |  |  |  |  |  | DO | FT-WE-XL-OPT-BAS