tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163411d1340293585-attendance-tracker-from-time-keeper-attendance-tracker-example
Sheet: Attendance Tracker

 |  |  |  |  |  |  | Sun | Mon | Tue
Name | Employee ID | VAC | Present | UTO | No Call | OUT | 2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00
 | BPTS
[NAME] | 35650 | 0 | 22 | 0 | 0 | 0
[NAME] | 35765 | 0 | 11 | 0 | 0 | 12 | OFF | OFF
[NAME] | 31656 | 0 | 24 | 0 | 0 | 1 | OFF | OFF
[NAME] | 28065 | 0 | 19 | 1 | 0 | 2 | OFF
[NAME] | 32015 | 0 | 25 | 0 | 0 | 1 | OFF | OFF
[NAME] 6 | 29825 | 0 | 2 | 0 | 0 | 0 | LOA | LOA | LOA
[NAME] | 35782 | 0 | 0 | 0 | 0 | 0 | LOA | LOA | LOA
[NAME] | 35690 | 0 | 24 | 0 | 0 | 1 | OFF
[NAME] 9 | 35701 | 0 | 23 | 0 | 0 | 0 | OFF | OFF
[NAME] 10 | 32006 | 0 | 19 | 0 | 0 | 4 | OFF | OFF
[NAME] | 35649 | 0 | 21 | 0 | 0 | 4 | OFF | OFF
[NAME] | 15119 | 0 | 20 | 0 | 0 | 5 | OFF | OFF
[NAME] 13 | 9983 | 0 | 24 | 0 | 0 | 0
[NAME] 14 | 35659 | 0 | 21 | 0 | 0 | 4 |  | OUT
[NAME] 15 | 31824 | 0 | 20 | 0 | 0 | 1 | VAC | OFF | OFF
Spreadsheet: 55303d1255449905-finding-difference-in-timing-between-transactions-part2
Sheet: 100-00021 (2)

Inventory Transactions
Date Range: 8/1/2008 to 9/24/2009 Special Item Type: *, D, F, K, M, O, R, S, T, U, X Action: Select All Company: 002 Account: % Location: Select All PO #: Select All Part #: 100-00021
PO # | Action | From [NAME] | To [NAME] | Part # | Stk | Com | From Acct | To Acct | Qty | Per Unit Cost | Total Trans Value | Date | Clrk | Comments
 | Q |  | RW | 100-00021 | 0 | 002 |  | 122310 | 2 | 1696.698 | 3393.396 | 09/23/08 | 2221 | TAG #'S 6534 & 6533
081436 | B | RW | OTV | 100-00021 | 0 | 002 | 603250 | 122310 | 2 |  |  | 09/29/08 | 394 | Shipped to Vendor for Repair
081436 | T | OTV | WHS | 100-00021 | 0 | 002 | 122310 | 122210 | 2 |  |  | 10/01/08 | 2284 | Repair Return
 | O | WHS |  | 100-00021 | 0 | 002 | 122210 | 623220 | -10 | -1696.698 | -16966.98 | 11/06/08 | 2221 | WAITING ON JOB#
 | O | WHS |  | 100-00021 | 0 | 002 | 122210 | JO2008004840 | -41 | -1696.698 | -69564.618 | 12/02/08 | 2221
 | Q |  | RW | 100-00021 | 0 | 002 |  | 122310 | 1 | 1696.697 | 1696.697 | 02/20/09 | 2284
090322 | B | RW | OTV | 100-00021 | 0 | 002 | 603250 | 122310 | 1 |  |  | 03/03/09 | 394 | Shipped to Vendor for Repair
090322 | T | OTV | WHS | 100-00021 | 0 | 002 | 122310 | 122210 | 1 |  |  | 03/17/09 | 2284 | Repair Return | 25 Days
 | U |  | WHS | 100-00021 | 0 | 002 | JO2009001494 | 122210 | 1 | 1696.697 | 1696.697 | 05/04/09 | 2221
 | O | WHS |  | 100-00021 | 0 | 002 | 122210 | 623220 | -1 | -1696.697 | -1696.697 | 05/26/09 | 2221
 | Q |  | RW | 100-00021 | 0 | 002 | 603250 | 122310 | 1 | 1696.697 | 1696.697 | 07/09/09 | 2284 |  | 1 day
091050 | T | RW | OTV | 100-00021 | 0 | 002 | 122210 | 122210 | 1 |  |  | 07/10/09 | 394 | Shipped to Vendor for Repair
091050 | T | OTV | WHS | 100-00021 | 0 | 002 | 122310 | 122210 | 1 |  |  | 07/27/09 | 2284 | Repair Return
 | U |  | WHS | 100-00021 | 0 | 002 | JO2009003233 | 122210 | 7 | 1696.697 | 11876.879 | 08/18/09 | 2221
 | O | WHS |  | 100-00021 | 0 | 002 | 122210 | 623220 | -1 | -1696.697 | -1696.697 | 09/03/09 | 2284
 | Q |  | RW | 100-00021 | 0 | 002 | 603250 | 122310 | 1 | 1696.697 | 1696.697 | 09/09/09 | 2284 |  | 12 Days
091375 | T | RW | OTV | 100-00021 | 0 | 002 | 122210 | 122210 | 1 |  |  | 09/21/09 | 394 | Shipped to Vendor for Repair
Total: |  |  |  |  |  |  |  |  | -31 |  | -67867.93
Spreadsheet: 884308d1733401937-support-required-for-wallfall-formula-simplification-new-file
Sheet: Requirement Jan to Mar

 |  | Value |  |  | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9
 |  | Month | Plan | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | YTD
 |  | JAN
 |  | FEB
 |  | MAR
 |  | APR
 |  | MAY
 |  | JUN
 |  | JUL
 |  | AUG
 |  | SEP
 |  | OCT
 |  | NOV
 |  | DEC
 |  | JAN
 |  | FEB
 |  | MAR
 |  | TOTAL
Spreadsheet: 786292d1657099421-calculating-day-night-hours-distribution-night-hours-calculations-hd
Sheet: Sheet1

Start time | End time |  |  | Duration | Day hours | Night Hours |  | NH Start | NH Finish
00:00:00 | 01:00:00 |  |  |  |  |  |  | 22:00:00 | 06:00:00
02:00:00 | 06:00:00
00:00:00 | 06:00:00
22:00:00 | 06:30:00
10:00:00 | 14:00:00
06:00:00 | 10:00:00
06:00:00 | 22:30:00
21:45:00 | 04:00:00
21:00:00 | 22:00:00
23:00:00 | 07:00:00
Spreadsheet: 165206d1341089799-correlation-results-unusually-low-caste-query-school-attendance-results
Sheet: Sheet1

 |  | Total | Attends School Observed | Attends School Expected |  | Note -  degrees of freedom. 49  castes, less two nil values . Less 1 = 46
 |  |  |  |  |  | Null hypotheses. That there are no significant differences between the observed and expected frequencies
 |  |  |  |  |  | [NAME] squared value at the 5 % confidence level with 46  degrees of f reedom = 62.83. Actual = 144.19 therefore reject the null  hypotheses.
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7 |  |  | 29
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23 |  |  | 149
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35 |  |  | 1
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
Spreadsheet: 0dd8196b-2008-46b1-9f38-25cb241a00a2
Sheet: Sheet1

Unnamed: 0 | [NAME] 2007 | Revised | Unnamed: 3 | Unnamed: 4
Line | Show goods | House Goods | Move Required | 0-0
Sur-Title |  | RP Screen
1 | GREY TEASER & OPERA SUR-TITLE | [NAME] | Hang Opera Surtitle screen 1' up from bottom of teaser - Trim teaser @ 27' 0" - (Sur-title 90lbs.) | 4"
2 |  | [NAME] | 26' 0" from CL (52' openeing) | 1'
3 4 |  | Main Curtain | Works | 1' 8"
5 | HOUSE BLK BORDER |  | Goods from 60 - Trim @ 26' 0" | 3' 3"
6 |  | Focus Track | No Used | 3' 11"
7 |  |  |  | 4' 7"
8 | ELECTRIC #1 | Elex #1 | Trim @ 28' 2" to lens | 5' 3"
9 |  |  |  | 6' 2"
10 | ELEXTRIC #2 | Elex #2 | Not Used - Fly High | 6' 10"
11 |  |  |  | 7' 6"
12 |  |  |  | 8' 2"
13 | HOUSE BLK BORDER | Border | Trim @ 25' 4" | 8' 10"
14 | HOUSE TRAV AS LEGS | Traveller and 10' Legs | 26' 0" from CL (52' openeing) | 9' 6"
15 |  | Screen |  | 10' 2"
16 |  |  |  | 10' 10"
17 | ELECTRIC #3 | Elex #3 | Trim @ 27' 8" | 11' 6"
18 |  |  |  | 12' 2"
19 |  |  |  | 12' 10"
20 |  |  |  | 13' 6"
21 |  |  |  | 14' 6"
22 | HOUSE BKL BORDER | Border | Trim @ 25' 0" | 15' 2"
23 | HOUSE BLK LEGS | Legs | 26' 0" from CL (52' openeing) | 15' 10"
24 |  |  |  | 16' 6"
25 |  |  |  | 17' 2"
26 | ELECTRIC #4 | Elex #4 | Trim @ 26' 10" to lens | 17' 10'
27 |  |  |  | 18' 6"
28 |  |  |  | 19' 2"
29 |  |  |  | 19' 10"
30 |  |  |  | 20' 6"
31 | Act 2 Wall Flats |  | Onstage edge @ 20' @ 12' 2" from CL (700 lbs) | 21' 2"
32 |  |  |  | 21' 10"
33 | HOUSE BLK BORDER | Border | Trim @ 24' 0" | 22' 6"
34 | HOUSE BLK LEGS | Traveller | Trim @ 26' from CL | 23' 2"
35 | Act 2 SL Grill c/w Door |  | Trim @ 2' 8" from CL (190lbs) | 23' 10"
36 |  |  |  | 24' 6"
37 | ELECTRIC #5 | Elex #5 | Trim @ 25' 8" to lens | 25' 2"
38 |  |  |  | 25' 10"
39 |  |  |  | 26' 6"
40 |  |  |  | 27' 2"
41 |  |  |  | 27' 10"
42 |  |  |  | 28' 6"
43 | HOUSE BLK BORDER | Border | Trim @ 24' 0" | 29' 2"
44 | HOUSE BLK LEGS | Legs | 26' 0" from CL (52' openeing) | 30' 2"
45 |  |  |  | 31' 2"
46 | ELECTRIC #6 | Elex #6 | Trim @ 25' 8" to lens | 31' 10"
47 |  |  |  | 32' 6"
48 |  |  |  | 33' 2"
49 | CYC ELECTRIC #7 | Elex #7 (cyc) | Trim @ 26' 3" to unit | 33' 10"
50 |  |  |  | 34' 6"
51 | House B/O panel |  | Panel (SL only) | 35' 2"
52 | SUN DROP |  | Center @ 10' 0" SR of CL (790 lbs) | 35' 10"
53 |  |  |  | 36' 6"
54 |  | Legs | Not Used | 37' 2"
55 |  |  |  | 37' 10"
56 | HOUSE BLK TRAV AS LEGS | Traveller | 26' 0" from CL (52' openeing) | 38' 6"
57 |  |  |  | 39' 2"
58 |  |  |  | 39' 10"
59 |  |  |  | 40' 6"
60 |  | Black Border | Goods to 5 | 41' 2"
61 | OPERA 36' BLK LEGS | Cyc | Westcoast cyc - add Opera 36' legs @ 26' from CL | 41' 10"
62 | SKY DROP | B/O Drop | B/O to storage - hang show SKY DROP | 42' 6"
Spreadsheet: 774177d1648270135-count-date-based-on-month-book1
Sheet: OSDefect_M

S/No | Car | Defective | Since | Clear | Year | Month | Sno | Expected Result
1 | 28 | Test 1 | 2022-02-01 00:00:00 |  |  |  |  | 1
2 | 3 | Test 3 | 2022-03-02 00:00:00 |  |  |  |  | 1
3 | 14 | Test 2 | 2022-03-25 00:00:00 |  |  |  |  | 2
4 | 1 | Test 7 | 2022-03-26 00:00:00 |  |  |  |  | 3
5 | 2 | Test 4 | 2022-04-04 00:00:00 |  |  |  |  | 1
6 | 4 | Test 5 | 2022-04-25 00:00:00 |  |  |  |  | 2
7 | 1 | Test 6 | 2022-04-30 00:00:00 |  |  |  |  | 3
8 | 1 | Test 8 | 2023-02-15 00:00:00 |  |  |  |  | 1
Spreadsheet: 127866d1320656651-excel-2007-count-cell-from-different-ranges-example
Sheet: Sheet1

Down time | System | Failure cause |  |  |  | System | A | B | C | Mean down time
10 | A | Power |  |  |  | Power | 1 | 0 | 0 | 10
15 | A | Mechanical |  |  |  | Mechanical | 1 | 2 | 0
20 | B | Mechanical |  |  |  | Excercise | 0 | 0 | 1 | 30
30 | C | Excercise
10 | B | Mechanical
Spreadsheet: 848113d1698913985-using-formula-to-return-unique-values-works-but-returns-a-double-value-testsheets-3-1-
Sheet: Partnerships

 | Partner |  | Budget |  | Actuals |  | Opmerkingen |  | Kwartaal
 | Value 1 |  | 10000 |  | 10000 |  | [NAME] ipsum dolor sit amet, consectetur adipiscing elit |  | Q4
 | Value 2 |  | 5000 |  | 5200 |  |  |  | Q2
 | Value 3 |  | 10000 |  | 10500 |  |  |  | Q1
 | Value 4 |  | 4000 |  | 4000 |  |  |  | Q3
 | Value 3 |  | 2500 |  | 2750
 | Value 2 |  | 500 |  | 500
 | Value 3 |  | 1500 |  | 1750
SUBTOTAAL |  |  |  |  |  |  |  | Q1 |  | undesired result
 |  |  |  |  |  |  |  | Q2
 |  |  |  |  |  |  |  | Q3
 |  |  |  |  |  |  |  | Q4
TOTAAL
Spreadsheet: eric_saibi__9967__111201
Sheet: Oyster Creek 01

Owner Name |  | AmerGen Energy Company
Station Name |  | Oyster Creek Nuclear Power Station
Unit Name |  | Oyster Creek  01
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 641 MW
Start Date |  | 11/11/01 pm
End Date |  | 2001-11-17 00:00:00
Comments |  | Unit went down last night due to a blown feeder cable.
SIC |  | 4911
Plant ID |  | 1008986
Unit ID |  | 1004199
Outage ID |  | 18867
Spreadsheet: 825442d1681316217-if-e4-y-copy-data-from-sheet-2-to-sheet-3-test-drawing-list-setup
Sheet: Design Scope (Project Meetings)

 |  |  |  |  |  |  |  |  |  | PLEASE CHANGE ALL RED TEXT TO BLACK
XXXX Project Name DESIGN SCOPE (PROJECT MEETINGS) |  |  |  |  |  |  |  |  |  | DO NOT HIDE ROWS ON THIS TABLE
Item | Included  (Yes/No) | Comments / Inclusions / Exclusions | Stage 1 | Stage 2 | Stage 3 | Stage 4 | Stage 5 | Stage 6 | Virtual (V) /   Face to Face (F)
Project Meetings |  |  | No. of Meetings |  |  |  |  |  |  | UPDATE WITH NUMBER OF MEETINGS FOR EACH STAGE & CHANGE TO BLACK
Client Meetings | Y | Where relevant to landscaping issues only & in accordance with fee agreement.  The number of meetings must be agreed at the start of each stage if potential variation to the initial agreed scope. Involvement where relevant to landscaping issues only. | X | X |  |  |  |  | V
Site Visit(s) & Provide Initial Appraisal | Y |  |  | X |  |  |  |  | F
Stakeholder Engagement Meetings | Y |  |  |  | X |  |  |  | V | REPLACE WITH CEM (IF SCHOOL PROJECT)
Public Consultations | Y |  |  |  | X |  |  |  | F
Design Team Meetings (DTMs) | Y |  |  | 3 | 3 | 5 |  |  | 8V/3F | IF NUMBER OF MEETINGS INCLUDE VIRTUAL & FACE TO FACE SPECIFY THE SPLIT IN THE LAST COLUMN
Construction Progress Meetings | N | Construction programme to be agreed.  Frequency to be agreed prior to commencement of stage. |  |  |  |  | X |  | V
Construction Progress Meetings  including Site Inspections | N |  |  |  |  |  | X | X | F
Common Data Environment (CDE)  Workshops/Training | N | Allowance for CDE specific workshops or training |  | X | X | X | X | X | V | REVIEW CDE REQUIREMENTS WITHIN EIR OR BEP OR REQUEST REQUIREMENT FROM CLIENT | Depending on the procurement there may be a requirement to attend a Client led workshop early on with a Contractor led workshop further on.
BIM Specific Meetings/Workshops | N | Allowance for workstage [NAME]-off Meetings, Strategic BIM meetings including COBie workshops, or bespoke trainings. |  | X | X | X | X |  | V | REVIEW BIM REQUIREMENTS WITHIN EIR OR BEP OR REQUEST REQUIREMENT FROM CLIENT | Refer to documentation & search for any landscape related requirements, ie. 1 workshop/month, or fortnightly workshops. Consider model exchanges & data input. We won't be required at all coordination meetings, just those that have landscape related items. Make a fair allowance for this, ie. 1 in every 4.
BIM Coordination/ Clash Detection Workshops (if scheduled separately from DTMs) | N | Involvement where relevant to landscaping issues only, to be at the beginning/end of workshop agenda. If meeting attendance excluded, OOBE will action any landscape related issues if requested & deemed reasonable. |  |  | X | X | X |  | V | REVIEW BIM WORKSHOP REQUIREMENTS WITHIN EIR OR BEP OR REQUEST REQUIREMENT FROM CLIENT
 |  | Total number of meetings Note the 'Virtual (V) / Face to Face (F)' column which specifies the meetings OOBE will attend via virtual methods (e.g Teams) or when we will attend in person.
 |  |  | N.B. Blank cells = no meeting allowance
Spreadsheet: 768482d1644995792-date-field-and-checking-the-date-portion-of-the-date-field-not-the-time-sr-workbook-ans
Sheet: Output

Quick Project Summary
[NAME] (Previous Day) |  | 2022-02-15 00:00:00
[NAME]
BOOKED
DELAYED
CALLED
NEW
ON HOLD
DESPATCHED
Booked for Today:
Spreadsheet: 854964d1704719273-data-validation-index-book-aligw
Sheet: Indexation

 | Year: | 2024
 | Month: | September
 | Factor:
 | Month | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15
 |  | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037
 | January | 1.3 | 1.5 | 1.8 | 2
 | February | 1.3 | 1.5 | 1.8 | 2
 | March | 1.3 | 1.5 | 1.8 | 2
 | April | 1.3 | 1.5 | 1.8 | 2
 | May | 1.3 | 1.5 | 1.8 | 2
 | June | 1.3 | 1.5 | 1.8 | 2
 | July | 1.3 | 1.5 | 1.8 | 2
 | August | 1.3 | 1.5 | 1.8 | 2
 | September | 1.5 | 1.8 | 2 | 2.2
 | October | 1.5 | 1.8 | 2 | 2.2
 | November | 1.5 | 1.8 | 2 | 2.2
 | December | 1.5 | 1.8 | 2 | 2.2
Spreadsheet: 164024d1340622282-lookup-corresponding-fields-of-identified-row-in-table-with-duplicates-find-fields-in-row-of-top-5-largest-values
Sheet: Sheet1

Key | Value1 | Value2 | Diff | Condition
1 | 100 | 60 |  | Black
2 | 99 | 49 |  | White
3 | 98 | 58 |  | Red
4 | 97 | 47 |  | Red
5 | 96 | 76 |  | Black
6 | 95 | 65 |  | White
7 | 94 | 44 |  | Red
8 | 93 | 23 |  | White
9 | 92 | 62 |  | Red
10 | 91 | 51 |  | Red
Condition: | Red
 | Large Diff | Key of Row
1
2
3
4
5
Results I'm looking for:
 | Large Diff | Key of Row
1 |  | 4
2 |  | 7
3 |  | 3
4 |  | 10
5 |  | 9
Spreadsheet: 228a125c-81ec-453c-9a25-d5fa546eb06c
Sheet: Sheet1

Unnamed: 0 | SOUTHERN METHODIST UNIVERSITY | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Tax Compliance Department | Unnamed: 10
 | MOVING EXPENSE REIMBURSEMENT REQUEST |  |  |  |  |  |  |  | 6116 Expressway Towers, Ste. 203
 |  |  |  |  |  |  |  |  | P.O. Box 750261
 |  |  |  |  |  |  |  |  | Dallas, TX 75275-0261
 |  |  |  |  |  |  |  |  | Tel: (214) 768-2009
 |  |  |  |  |  |  |  |  | Fax: (214) 768-1718
 | Instructions: This form must be completed when a department submits a request for reimbursement of employee
 | relocation expenses. Complete the information below and attach original receipts or vendor invoices for all
 | expenses to the Accounts Payable check request. Attach the completed form to the check request and support
 | documentation and forward to the Tax Compliance Department, Box 0261 for review.
 | Name: |  |  |  |  |  | Employee ID:
 | Place of Departure: |  |  |  |  |  | Department:
 | Move Date(s): |  |  |  |  |  | Department Contact Person:
 | Employee Start Date: |  |  |  |  |  | Department Contact Telephone:
 | Number of Miles Moved:
 | Qualified Moving Expenses: Nontaxable |  |  |  |  |  |  | Reimburse to |  | Pay Directly to
 |  |  |  |  |  |  |  | Employee |  | Third-Party
 | Moving employee and family from old to new home:
 | Mileage Reimbursement (Jan - Dec 2013 - 24 cents per mile)
 | OR out-of-pocket Automobile Expense (car rental)
 | Lodging:
 | Transportation and storage of household goods:
 | Other (Specify):
 | Subtotals: (Amounts reimbursed to employee will be reported on Form W-2, Box 12 "P".) |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | Total Nontaxable: |  |  |  | 0
 | Move must be at least 50 miles from your former home.
 | Unqualified Moving Expenses: Taxable |  |  |  |  |  |  | Reimburse to |  | Pay Directly to
 |  |  |  |  |  |  |  | Employee |  | Third-Party
 | Meals during move from old to new home:
 | House hunting:
 | Temporary Living Expenses (lodging & car rental):
 | Other Pre-move (Specify):
 | Subtotals: (All unqualified reimbursed amounts will be taxed as reportable income.) |  |  |  |  |  |  | 0 |  | 0
 |  |  |  | Total Taxable: |  |  |  | 0
 |  |  |  |  |  |  | Total Reimbursement: |  | 0
 | Employee Certification: "I certify that the expenses listed above were incurred by me in connection with moving myself,
 | my family, and our personal possessions in order to accept employment at Southern Methodist University and I have not
 | previously been reimbursed, either by the University or any other person, institution or government agency."
 | Signature of Employee: |  |  |  |  |  |  | Date:
 | Department Approval: |  |  |  |  |  |  | Date:
Spreadsheet: 721851d1614894694-extract-entire-row-when-condition-is-met-and-create-a-funnel-between-the-tabs-anchoring-values-for-subsequent-sheets-djon2007-
Sheet: Tab3

Internal ID | City | Region | [NAME]?
Spreadsheet: 109247d1306169659-summing-all-cells-upward-from-a-given-row-bottomformula
Sheet: Sheet1

UNIT 1
Check |  |  |  | Home Built 9400 mAh Battery
Column | Time | Battery | [NAME] | Date | Time | Battery | [NAME]
 |  |  |  | 2011-05-19 00:00:00 | 1900-01-01 00:00:00 | 1 | 0
 |  |  |  | 2011-05-19 00:00:00 | 02:36:00 | 0.92 | 104.8
 |  |  |  | 2011-05-20 00:00:00 | 02:10:34 | 0.86 | 86
 |  |  |  | 2011-05-21 00:00:00 | 02:38:22 | 0.81 | 94.2
 |  |  |  | 2011-05-22 00:00:00 | 01:31:05 | 0.78 | 54.1
 |  |  |  | Totals > | 08:56:01 | 0.22 | 339.1
 |  |  |  | Sub Totals > | 1900-01-01 00:00:00 | 0 | 0
Spreadsheet: louise_kitchen__23840__Completed Deals Year to Date
Sheet: Sheet1

Development Deals
Deal Type | Commercial Co - Lead | Customer | Prob. (%) | Deal Description | Size | Status/ Follow-up | Completion Date | Value
Completed Q1 Development Deals
Development | Mitro / Booth / Grube | Intergen | Done | Enron sells 2 GE LM 6000 turbines and one ABB transformer | 96 MW | Done | Q1 | 3509000
Development | Mitro | PSEG | Done | Enron signs exclusivity agreement w/PSEG on Plano, IL site |  | Done | Q1 | 300000
Development | Tapscott | Doyle | Done | Enron receives cash distribution from [NAME] I, L.L.C. |  | Done | Q1 | 1300000
Development | Tapscott | Doyle | Done | Reversal of 2000 Doyle Loss |  | Done | Q1 | 384000
Development | Mitro/Booth | Northwestern | Done | Enron signs exclusivity agreement with Northwestern on 7EA turbines ($1 MM split 50% with West Origination). | 156 MW | Done | Q1
 |  |  |  |  |  |  | Q1 Total
Completed Q2 Development Deals
Development | Mitro / Booth | Montana Power | Done | Enron signs exclusivity agreement with Montana Power on 501D5A turbine ($200,000 split 50% with West Origination). | 119 MW | Done | Q2
Development | Mitro / Booth | Delta Power | Done | Enron sells Las Vegas turbines ($4.2 MM split 50% with West Origination). |  | Done | Q2
Development | Booth | AES | Done | Enron flips Haywood development site to AES with milestone payment for Interconnect Agreement with TVA. | 540 MW | Done -- Possible additional gross margin of up to $4.5 MM by August 1st if interconnect agreement successfully negotiated with TVA. | Q2 | 2734000
Development | Booth | [NAME] | Done | Enron sells 161 kV transformer to [NAME]. |  | Done | Q2 | 225000
Development | Booth | Northwestern | Done | Enron sells 2 7EA turbines ($7 MM split 50% with West Origination). | 156 MW | Done | Q2
 |  |  |  |  |  |  | Q2 Total
 |  |  |  |  |  |  | Year to Date
Spreadsheet: joe_parks__14601__POSTIONTRAX_OCT
Sheet: DEC_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 9.3 | 2.8 |  |  |  |  |  |  |  |  | MTM
 | 15.5 | 2.87 |  |  | 31 | 2.815 |  |  |  |  | ROLLOFF VAULE
 | 38.75 | 2.9075 |  |  | 54.25 | 2.85 |  |  |  |  | NEW DEALS
 |  |  |  |  | 23.25 | 2.98
 |  |  |  |  | 7.75 | 3.0125 |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 797558d1663954082-incorrect-result-from-rank-formula-midshires-master
Sheet:  Master

 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  | Stroke Index |  |  |  |  |  |  |  |  | HANDICAPPING ALTERATIONS
1 | PLAYER | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  | PAR | PTS | Playing H'Cap |  |  | Helper |  | HANDICAP | NEW |  |  | 36 | Winners | Other |  | H'cap |  | catagory
1 |  | S/I |  | 17 |  | 5 |  | 9 |  | 15 |  | 3 |  | 1 |  | 7 |  | 13 |  | 11 |  | 8 |  | 12 |  | 16 |  | 2 |  | 10 |  | 4 |  | 18 |  | 14 |  | 6 | GROSS | 3 |  | S/I 1 | S/I 2 | S/I 3 |  | POST | CHANGE | HANDICAP |  |  |  | Cuts | Cuts | Increase | Change
0 | ADAMS (Brian)
0 | ADAMS ([NAME])
1 | BATTERBEE ([NAME]) |  |  |  |  |  |  |  |  |  | 4 |  | 4 |  | 4
0 | BAXTER (Nick)
1 | BENNETT ([NAME]) |  |  |  |  |  |  |  |  |  | 4 |  | 3 |  | 4
0 | BROMLEY ([NAME])
0 | CURT ([NAME])
0 | CURT (Sean)
0 | DERBYSHIRE ([NAME])
0 | DONNELLY ([NAME])
0 | DOWNER ([NAME])
0 | [NAME] ([NAME])
0 | GELLMAN ([NAME])
0 | GIBOIN ([NAME])
0 | GROUT ([NAME])
0 | [NAME] (Stuart)
0 | [NAME])
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | KOLEK ([NAME])
0 | KOLEK ([NAME])
0 | LEECH ([NAME])
0 | LEECH ([NAME])
0 | LEONARD ([NAME])
0 | LEONARD ([NAME])
0 | [NAME] ([NAME])
0 | LOOM (Scott)
0 | MARVESLEY ([NAME])
0 | MCGILLIVRAY ([NAME])
0 | MCINTYRE ([NAME])
0 | MCKENZIE ([NAME])
0 | MEMOLI ([NAME])
0 | MITCHELL ([NAME])
0 | MOSS ([NAME])
0 | MUNTING ([NAME])
0 | NOONS (Martin)
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | PYM ([NAME])
0 | SMITH ([NAME])
0 | SMITH ([NAME])
0 | TAYLOR ([NAME])
0 | VANN (Martin)
0 | ANDREWS ([NAME])
0 | ATKINS (Allen)
0 | BUCKLE (Eugene)
0 | BURNETT ([NAME])
0 | CLARKE ([NAME])
0 | CRONIN ([NAME])
0 | [NAME] ([NAME])
0 | FAWCETT ([NAME])
0 | HAMMOND ([NAME])
0 | KING ([NAME])
0 | [NAME] (Trevor)
0 | MCDONALD ([NAME])
0 | PRESTON ([NAME])
0 | SPENCER ([NAME])
0 | THORPE ([NAME])
0 | VALENTINE ([NAME])
0 | WARREN (Derek)
0 | WEEKS ([NAME])
0 | WILLS (Stuart)
0 | WOODFORD ([NAME])
 | Number of Players
 | SKINS
 | 1
 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  |  |  |  |  |  |  |  |  |  | Total Cuts
 |  | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 5 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4
 |  | S/I |  | 16 |  | 4 |  | 18 |  | 14 |  | 10 |  | 8 |  | 2 |  | 12 |  | 6 |  | 7 |  | 15 |  | 13 |  | 5 |  | 9 |  | 1 |  | 17 |  | 11 |  | 3 | GROSS
 | Average Score
 | PARS
 | BIRDIES
 | Total Score