tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102162d1300182541-count-to-the-next-value-small_chart
Sheet: Sheet1

DRAWINGS |  |  |  |  | DRAWINGS SINCE HIT CHART |  |  |  |  |  |  |  |  |  |  |  | GAMES OUT
DATE | B1 | B2 | B3 |  | DATE | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | DATE | B1 | B2 | B3
2011-03-04 00:00:00 | 1 | 4 | 5 |  | 2011-03-04 00:00:00 | 1 | XX | 1 | 1 | XX | XX | 1 | 1 | 1 | 1 |  | 2011-03-04 00:00:00 | 4 | 1 | 1
2011-03-03 00:00:00 | 3 | 6 | 8 |  | 2011-03-03 00:00:00 | 2 | 1 | 2 | XX | 1 | 1 | XX | 2 | XX | 2 |  | 2011-03-03 00:00:00 | 2 | 2 | 3
2011-03-02 00:00:00 | 4 | 5 | 9 |  | 2011-03-02 00:00:00 | 3 | 2 | 3 | 1 | XX | XX | 1 | 3 | 1 | XX |  | 2011-03-02 00:00:00 | 2 | 2 | 1
2011-03-01 00:00:00 | 0 | 2 | 7 |  | 2011-03-01 00:00:00 | XX | 3 | XX | 2 | 1 | 1 | 2 | XX | 2 | 1 |  | 2011-03-01 00:00:00 | 1 | 1 | 1
2011-02-28 00:00:00 | 3 | 6 | 9 |  | 2011-02-28 00:00:00 | 1 | 4 | 1 | XX | 2 | 2 | XX | 1 | 3 | XX |  | 2011-02-28 00:00:00 | 0 | 0 | 0
DATA |  |  |  |  | CHART |  |  |  |  |  |  |  |  |  |  |  | SKIPS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 124025d1318003280-countifs-
Sheet: Ιούνιος

 | ΙΟΥΝΙΟΣ
 |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ΡΕΠΟ | ΡΕΠΟ ΣΥΝ | ΡΕΠΟ ΜΕΙΟΝ | ΣΥΝΟΛΟ ΡΕΠΟ
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 |  | Κ/Α |  | ΜΗΧ/ΑΔ |  | ΦΟΙΤ.ΑΔ. |  | ΓΟΝ.ΑΔ. |  | ΑΔ.ΜΗΤ.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 796289d1663200846-need-help-returning-multiple-values-to-one-cell-based-on-a-two-criteria-excel-workbook-v2-hd
Sheet: Summary Dashboard

Property |  |  |  | Property | Tenant | Expiration
Property 1 |  |  |  | Property 1 | Tenant 1 | 2022-09-30 00:00:00
Property 2 |  |  |  | Property 1 | [NAME] | 2022-09-30 00:00:00
Property 3 |  |  |  | Property 2 | Tenant 3 | 2022-10-31 00:00:00
 |  |  |  | Property 2 | [NAME] | 2022-09-30 00:00:00
 |  |  |  | Property 3 | Tenant 5 | 2022-10-31 00:00:00
 |  |  |  | Property 3 | Tenant 6 | 2022-10-31 00:00:00
Spreadsheet: 57550d1257771314-extract-data-from-a-string-array-and-sum-copy-of-stringextract-1-
Sheet: Sheet4

Strings | (All)
Sum of Third | Second
First | BG | CH | (blank) | Grand Total
AB |  | 300 |  | 300
CD | 100 | 100 |  | 200
(blank)
Grand Total | 100 | 400 |  | 500
Spreadsheet: 472913d1469837367-import-specific-cells-in-multiple-sheets-from-hundreds-of-identical-workbooks-imp_ds_templatefordb
Sheet: 15-Soil Chemistry

Section 15.0 - Soil Chemistry Data Collection
SPL #
COMPANY/PIPELINE*
STATIONING*
DIG #* |  |  | DIG TYPE* |  |  | DEPTH*
DATE REMOVED* |  | No sample removed, no containers available.
DATE RECEIVED
DATE TESTED
SAMPLED BY*
TESTED BY
CGR TEST * |  | YES |  | NO
SOIL MOISTURE |  |  |  | % BY VOLUME
SAMPLE TYPE*
SOIL |  |  | CORROSION PRODUCT
WATER |  |  | SLUDGE
COATING |  |  | OTHER
* Data Required
Complete form and attach a copy to each soil sample being sent for analysis.
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Recoupment-Supplemental

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Case Management (Undercare)
Activity Name | Recoupment-Supplemental
Activity Description / Purpose | The process of reconciling overpayments and underpayments.
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Receive notification or verification.
Research case information.
Enter overpayment/supplement data in system.
[NAME] authorization.
Send notice to client/State
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 834780d1688070673-replace-names-with-numbers-s666-pq-replace-names-with-numbers-
Sheet: Sheet1

FIRST WORKSHEET
Sample assessment
This is what we receive from the company that provides the assessments (Excel form)
STUDENT  ASSESSMENT IDENTIFICATION NUMBER | Student  Name | Test A Score | Test B Score | Test B Score2 | Test B Score3
12345678 | [NAME] | 23 | 14 | 450 | 1
23456789 | [NAME] | 57 | 9 | 345 | 2
SECOND WORKSHEET
STUDENT IDENTIFICATION NUMBER | Name |  |  |  |  |  | STUDENT IDENTIFICATION NUMBER | Student  Name | Test A Score | Test B Score | Test B Score2 | Test B Score3
87654321 | [NAME] |  |  |  |  |  | 87654321 | [NAME] | 23 | 14 | 450 | 1
98765432 | [NAME] |  |  |  |  |  | 98765432 | [NAME] | 57 | 9 | 345 | 2
OK, here's the issue.  We need to report the data in Worksheet #1 but can not submit names.  So in place of the names
we need to use our Student Identification number.
Spreadsheet: 126562d1319745757-excel-2007-index-match-returns-0-ifandmatch1
Sheet: Result

 | 2011-10-01 00:00:00 | 2011-10-02 00:00:00 | 2011-10-03 00:00:00 | 2011-10-04 00:00:00 | 2011-10-05 00:00:00 | 2011-10-06 00:00:00 | 2011-10-07 00:00:00 | 2011-10-08 00:00:00 | 2011-10-09 00:00:00 | 2011-10-10 00:00:00 | 2011-10-11 00:00:00 | 2011-10-12 00:00:00 | 2011-10-13 00:00:00 | 2011-10-14 00:00:00 | 2011-10-15 00:00:00 | 2011-10-16 00:00:00 | 2011-10-17 00:00:00 | 2011-10-18 00:00:00 | 2011-10-19 00:00:00 | 2011-10-20 00:00:00 | 2011-10-21 00:00:00 | 2011-10-22 00:00:00 | 2011-10-23 00:00:00 | 2011-10-24 00:00:00 | 2011-10-25 00:00:00 | 2011-10-26 00:00:00 | 2011-10-27 00:00:00 | 2011-10-28 00:00:00 | 2011-10-29 00:00:00 | 2011-10-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00 | 2011-11-08 00:00:00 | 2011-11-09 00:00:00 | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 | 2011-11-13 00:00:00 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 | 2011-11-16 00:00:00
a
b
c
d
e
I am trying to get the corresponding letter Column A to align with the dates/letters from the table in Archive.
Results needed:
a | a | a |  | a | a | etc
b | b |  |  | b |  | etc
c |  | c |  | c | c | etc
d |  |  | d
e |  |  |  | e
Spreadsheet: 126440d1319697315-excel-2007-need-some-help-on-conditional-formatting-sample
Sheet: Sheet1

 | Holland | France | Germany | Italy
Holland | 28 | 30 | 45 | 34
France | 30 |  | 72 | 120
Germany | 45 | 72 |  | 200
Italy | 34 | 120 | 200
 |  |  |  |  | I just did an example of holland vs other countries -
 | Source |  | Destination |  | So basically I would like to compare the second table to the first table
 | Holland | Holland CC | France | 30 | Hence, if value of 2nd table is above first table it will be highlighted
 | Holland | Holland TP | France | 50
 | Holland | Holland LD | Italy | 100 | The problem I'm facing is that for example, Holland & France there are two different type of sources,
 | Holland | Holland WC | Germany | 120 | Holland CC & Holland TP.
 | Holland | Holland SC | Germany | 88 | How do I make my conditional formating formula compare to both values (24 & 30) instead of one only.
 |  |  |  |  | Like in this case it only recognises value 30 and not 50 in table 2
 |  |  |  |  | So is that anyway I could detect the 2nd data as well and highlight it with a different color as such
Spreadsheet: 765336d1643284982-how-to-use-vlookup-for-multiples-rows-emmr-example
Sheet: Sheet1

ID | ID No. | Employee Name |  |  | ID |  | ID No. | Employee Name
imti | 78 | Md.Imtiaz |  |  | [NAME]
imti | 72 | [NAME] |  |  |  |  | 100 | [NAME]
[NAME] | 96 | Md. Nasir |  |  |  |  | 17 | Anika
[NAME] | 100 | [NAME]
[NAME] | 17 | Anika |  |  | ID |  | ID No. | Employee Name
nabi | 47 | Masrur |  |  | nabi
nabi | 71 | Afroza |  |  | nabi |  | 71 | Afroza
nabi | 81 | Mafuz |  |  | nabi |  | 81 | Mafuz
nabi | 90 | Md. [NAME] |  |  | nabi |  | 90 | Md. [NAME]
Spreadsheet: 376658d1423673437-indirect-function-on-this-formula-single-cell-array-formulas
Sheet: Sheet9

The row of the nth occurrence of a value
1 |  |  | Value to find: | 1
3 |  |  | Occurrence of Value: | 3
3 |  |  | It's in row:
6
6
6
8
8
3
8
8
8
8
1
1
Spreadsheet: 68082d1268652912-sorting-column-into-various-worksheets-by-name-skypingmaster-1-
Sheet: Master

 |  |  |  |  |  | Sum
 | Names | [NAME] | DDoubles | etc | etc
 | 1 |  |  |  |  | 0
 | 2 |  | a |  |  | 1
 | 3 |  |  |  |  | 0
 | 4 |  |  |  |  | 0
 | 5 |  |  |  |  | 0
 | 6 |  |  | a |  | 1
 | 7 |  |  | a |  | 1
 | 8 |  |  |  |  | 0
 | 9 |  |  |  |  | 0
 | aa |  |  |  |  | 0
 | bb |  | a |  |  | 1
 | dds |  |  | a |  | 1
 | dsd |  |  |  |  | 0
 | qw |  |  |  |  | 0
 | s |  |  |  |  | 0
 | sdsd |  |  |  |  | 0
 | vv |  |  | a |  | 1
Spreadsheet: 697260d1601291981-time-and-date-of-next-value-time-and-date-of-next-value-in-a-2-column-search
Sheet: AFTER

Date | Time |  |  | Value 1 | Value 2 | Date 1 | Time 1 | Date 2 | Time 2
17:08:00 | 2019-06-11 00:00:00 |  |  | watch | pen | 16:03:00 | 2019-06-08 00:00:00 | 14:03:00 | 2019-06-06 00:00:00
18:05:00 | 2019-06-10 00:00:00 |  |  | belt | umbrella | 14:03:00 | 2019-06-06 00:00:00 | 14:28:00 | 2019-06-07 00:00:00
16:40:00 | 2019-06-09 00:00:00 |  |  | pipe | shoes | 13:54:00 | 2019-06-05 00:00:00 | 16:03:00 | 2019-06-08 00:00:00
16:03:00 | 2019-06-08 00:00:00 |  |  | shoes | watch |  |  | 12:50:00 | 2019-06-04 00:00:00
14:28:00 | 2019-06-07 00:00:00 |  |  | lighter | umbrella |  |  | 13:54:00 | 2019-06-05 00:00:00
14:03:00 | 2019-06-06 00:00:00 |  |  | pen | belt | 12:50:00 | 2019-06-04 00:00:00
13:54:00 | 2019-06-05 00:00:00 |  |  | umbrella | watch |  |  | 12:50:00 | 2019-06-04 00:00:00
12:50:00 | 2019-06-04 00:00:00 |  |  | watch | pen
Spreadsheet: 864840d1711983589-auto-populate-a-range-with-selected-rows-from-a-second-range-but-the-nightmarish-way-stone-inventory
Sheet: MAIN

UUID | MATERIAL | Code | MATERIAL NAME | Depth | BATCH / SLAB ID | Cost per m2 | SECTION 1 LENGTH | SECTION 1 HEIGHT | SECTION 2 LENGTH | SECTION 2 HEIGHT | SECTION 3 LENGTH | SECTION 3 HEIGHT | SECTION 4 LENGTH | SECTION 4 HEIGHT | AREA  (m2) | NOTES | [NAME]? | Frame / Rack | Shape | Value
1 |  | CMB |  | 30 |  |  | 2950 | 1950 |  |  |  |  |  |  |  |  | F | 6
2 |  | SGL |  | 30 |  |  | 3000 | 2000 |  |  |  |  |  |  |  |  | F | 1
4 |  | CMF |  | 20 |  |  | 1900 | 1200 |  |  |  |  |  |  |  |  |  | S
3 |  | NH |  | 20 |  |  | 3000 | 1950 |  |  |  |  |  |  |  |  | F | 2
6 |  | NC |  | 20 |  |  | 2000 | 1900 | 800 | 1550 |  |  |  |  |  |  |  | 5
8 |  | PLW |  | 30 |  |  | 2800 | 1900 |  |  |  |  |  |  |  |  | F | 5
Spreadsheet: 60806d1261403169-calculate-which-values-specific-amount-solver
Sheet: Sheet1

Outstanding |  |  |  |  | Paid
68.68 | 1 |  |  |  | 2349.27
638.09 | 1
440.82 | 1
402.5 | 1
104.65 | 1
254.32 | 1 |  |  |  |  |  | Figure to Match
771.59 | 1
301.88 | 1
31.53 | 1 |  |  |  |  |  | From These
41.98 | 1
2392.13 | 1
254.9 | 1
146.04 | 1
 | 5849.11 |  |  | put formula =sumproduct(a2:a14,b2,b14) in cell b15
 |  |  |  | fill b2 to b14 with 1's
 |  |  |  | tools /solver
 |  |  |  | set target cell as b15
 |  |  |  | choose = to value of 239.27
 |  |  |  | set by changing range to b2:b14
 |  |  |  | click add and make the constraint b2:b14 = [NAME]
 |  |  |  | click options and change the precision to [PHONE]
 |  |  |  | run solver
 |  |  |  | those with a 1 next to them should = your total
Spreadsheet: 127894d1320673294-excel-formula-offset-forum
Sheet: Arkusz1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 20 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 45 | 65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | 16 | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column T Column U Column V
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 1 10.00 20.00 30.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 2 15.00 45.00 65.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 3 18.00 16.00 28.00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result Required:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 2 10.00 (Row 1 - column T data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 3 20.00 (Row 1 - column U data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 4 30.00 (Row 1 - column V data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 5 (Blank)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 6 15.00 (Row 2 - column T data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 7 45.00 (Row 2 - column U data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 8 65.00 (Row 2 - column V data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 9 (Blank)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 10 18.00 (Row 3 - column T data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 11 16.00 (Row 3 - column U data)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Row 12 28.00 (Row 3 - column V data)
Spreadsheet: 802362d1666805115-count-between-2-numbers-multiple-times-average-rows-tordah-
Sheet: Sheet1

3 | 11 | 12
8 | 9 | 33 |  |  |  | How many rows between #3
1 | 6 | 23 |  |  |  | Then the average number of rows in the entirety (Count all colored cells and average them)
3 | 9 | 10 |  |  |  | Original sheet has over 4000 cells in one column and will not be color formatted
5 | 14 | 21
8 | 20 | 21 |  |  | Average |  | << Shouldn’t this include the last two rows as was done in the previous file?
7 | 3 | 25 |  |  |  |  | << Average including rows 25:26
7 | 16 | 17 |  |  |  |  | << Average by formula
5 | 10 | 23
3 | 4 | 15
7 | 9 | 21
9 | 11 | 17
7 | 14 | 17
3 | 25 | 28
8 | 18 | 31
9 | 12 | 13
4 | 5 | 14
13 | 16 | 18
11 | 3 | 25
7 | 18 | 23
11 | 18 | 3 |  |  | << Is in the same row as a 3
8 | 14 | 16
4 | 11 | 23
3 | 4 | 19
5 | 17 | 21
6 | 17 | 24
Spreadsheet: 159655d1338808314-if-logical-formula-problem-help-me-please-matt-correct-score-lays
Sheet: Correct Score Lays 

System Name: Correct Score Lays |  |  | Start Balance | 1000
Total P & L: |  |  | Current Balance
 |  |  |  |  |  | NextStake:
Date | Fixture | League | HT Score | FT Score | Qualify | Lay Odds | Stake | Exp. | Win/Loss | Net P & L
2012-06-01 00:00:00 | Shamrock vs Cork City | Irish Premier | 0-0 | 4-0 |  | 3.45 | 20
 |  |  |  |  |  |  |  |  |  |  | No Market ever formed.
 |  |  |  |  |  |  |  |  |  |  | Markets were not in-play
 |  |  |  |  |  |  |  |  |  |  | Match was not in-play
Spreadsheet: 624744d1558048733-help-calendar-correction-employee-absence-schedule-current
Sheet: September 1

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | January | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 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 | Vacation Days Available | Total Vacation  Days Taken | Total Days Picked up | Total Sick Days
 |  |  |  | V | V | V | V |  |  |  |  |  |  | V |  |  | s | s |  | p |  | s | s | p | p | p |  |  | p
 |  |  |  |  |  | S | S |  |  |  |  | P |  |  |  |  |  |  |  |  | S |  |  | v |  | V | V | V
 |  |  |  | P | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s | s |  |  |  | s | s | s | s | s | S
 |  |  |  |  |  |  |  | P |  |  |  |  |  |  |  |  |  |  |  | V | V | V
 |  | v | v | v |  |  |  |  |  |  |  |  |  | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | v | V
 |  |  |  |  |  | v
Spreadsheet: 876003d1722632031-sorting-between-brackets-detect-characters-in-name
Sheet: My Testing Sorted Data

Extracted Zones | Sorted Zones | Filtered Zones
 | DA.1 | FA.11
 | FA.11 | QA.21
 | QA.21 | RA.1
 | RA.1 | ZA.1
 | ZA.1
Spreadsheet: 02e09d4a-5cd3-49e5-9698-0996079c6a0e
Sheet: IgG4

Dunn's multiple comparisons test | Sj_AY813602 | [NAME] | Sj_AY814497 | Sj_AY812195 | Sj_AY814430 | Sj_AY809911 | Sj_AY815945 | Sj_AY808953 | Sj_AY814817 | Sm29A/[NAME] | Sm29B/TSP2 | Sm29 | Sj_AY222868 | Sj_AY815056 | Sj_AF036955 | Sj_AY814261 | Sj_AY813641 | Smp_008310 | Smp_050270 | Sj_AY815815 | Sj_AY812951 | Sj_AY812591 | Sj_AY815690
PR vs. CI-Low | 0.0352 | 0.0065 | 0.0013 | 0.0018 | 0.0002 | ns | ns | ns | ns | ns | 0.002 | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns
PR vs. CI-Med | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | ns | 0.0227 | 0.0009 | 0.0003 | < 0,0001 | < 0,0001 | < 0,0001 | 0.0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001
PR vs. CI-Heavy | < 0,0001 | 0.0027 | 0.005 | ns | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | ns | 0.0071 | ns | ns | ns | < 0,0001 | ns | ns | 0.0003 | ns | ns | ns | < 0,0001 | ns
PR vs. Neg-BZL | ns | ns | ns | ns | ns | ns | ns | ns | 0.007 | < 0,0001 | < 0,0001 | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns
PR vs. Neg-USA | ns | ns | ns | ns | ns | ns | 0.0003 | ns | 0.0193 | < 0,0001 | < 0,0001 | ns | ns | ns | ns | ns | ns | ns | ns | 0.0086 | ns | ns | ns
CI-Low vs. CI-Med | 0.0005 | 0.0221 | 0.0011 | ns | 0.0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | ns | ns | 0.0006 | < 0,0001 | < 0,0001 | < 0,0001 | 0.0002 | 0.0002 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001 | < 0,0001
CI-Low vs. CI-Heavy | 0.0101 | ns | ns | ns | ns | 0.0001 | 0.029 | < 0,0001 | < 0,0001 | ns | ns | ns | ns | ns | 0.0037 | ns | ns | < 0,0001 | ns | ns | 0.0167 | < 0,0001 | < 0,0001
CI-Low vs. Neg-BZL | ns | 0.0312 | 0.0048 | ns | ns | ns | ns | ns | ns | 0.0006 | ns | 0.0298 | ns | ns | ns | ns | ns | ns | ns | ns | ns | 0.0251 | ns
CI-Low vs. Neg-USA | ns | 0.0027 | ns | < 0,0001 | ns | ns | ns | ns | ns | < 0,0001 | 0.001 | ns | ns | ns | ns | ns | ns | ns | ns | 0.0007 | ns | 0.0176 | 0.0001
CI-Med vs. CI-Heavy | ns | 0.4648 | 0.0114 | 0.0055 | ns | ns | ns | ns | ns | ns | ns | ns | 0.0106 | 0.0454 | ns | ns | ns | ns | ns | ns | 0.0204 | ns | ns
CI-Med vs. Neg-BZL | 0.0003 | < 0,0001 | < 0,0001 | < 0,0001 | 0.0002 | 0.0213 | < 0,0001 | 0.005 | 0.0201 | 0.0145 | ns | < 0,0001 | 0.0009 | < 0,0001 | 0.0007 | 0.0001 | ns | 0.0391 | ns | < 0,0001 | 0.0075 | 0.0398 | < 0,0001
CI-Med vs. Neg-USA | < 0,0001 | < 0,0001 | 0.0009 | < 0,0001 | < 0,0001 | < 0,0001 | ns | < 0,0001 | 0.0073 | 0.0036 | 0.0016 | ns | < 0,0001 | < 0,0001 | 0.0008 | 0.002 | < 0,0001 | < 0,0001 | < 0,0001 | ns | ns | ns | ns
CI-Heavy vs. Neg-BZL | 0.0038 | 0.0113 | 0.0114 | ns | 0.0425 | ns | ns | ns | ns | 0.0282 | ns | < 0,0001 | ns | ns | 0.0115 | ns | ns | ns | ns | ns | ns | ns | ns
CI-Heavy vs. Neg-USA | < 0,0001 | 0.0011 | ns | 0.0162 | 0.0122 | < 0,0001 | > 0,9999 | 0.0002 | ns | 0.0076 | 0.007 | ns | ns | ns | 0.0127 | ns | ns | 0.0112 | ns | ns | ns | ns | ns
Neg-BZL vs. Neg-USA | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns | ns | < 0,0001 | ns | ns | ns | ns | ns | ns | ns | 0.0057 | ns | ns | ns
Spreadsheet: 4b904487-a694-41d4-ad61-5d3d1d0299a5
Sheet: Sheet1

Judgeship Number 4 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 11/23/2014 12:31:42 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | TOTALS
District 04 | 456 | 456
District 31 | 702 | 702
District 36 | 4705 | 4705
District 37 | 6028 | 6028
District 39 | 3922 | 3922
TOTAL | 15813 | 15813
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: andy_zipper__166__DYNEGY-ICE VOL Apr10
Sheet: E-Mail

 | 2001-04-10 00:00:00
 | Intercontinental Exchange |  |  | Enron's Activity on ICE
 | Commodity | Volume |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  | ECC
 |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  | EPM | POWER
 |  |  |  | ENA | POWER
 |  |  |  | ENA | US NATURAL GAS
 |  |  |  | ENA | COAL
 |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: louise_kitchen__22534__4base329c
Sheet: Cash-Int-Trans

Transactions
Option Premiums Earned
Settle Put Premium on ENE shares |  |  | 2001-01-26 00:00:00
Total Option Premiums Earned |  | h
Cash Settlement on Put
Transfer to Note
Distributions
to LJM | -40469683.8
LJM additional Equity
Paymentof Interest on Note Receivable |  |  | 2001-03-11 00:00:00
Permitted Investment
Cash Account
Beginning Balance |  |  | 2000-08-31 00:00:00
Net Income
Amortizations
Change in:
Notes Receivable
Interest Receivable
[NAME]
ENE Share Derivative
Notes Payable
Option/Put Obligations
Distributions
LJM Equity
Ending Balance
Permitted Investment Income Summary
Permitted Investment Income
Date | 2000-09-11 00:00:00 |  | End Date | 2000-12-15 00:00:00
Beginning Balance | 71001000 |  | Days
Date |  |  | LIBOR | 0.0666
Interest
Date |  |  | End Date | 2001-01-26 00:00:00
Beginning Balance |  |  | Days
Date |  |  | LIBOR | 0.0658
Interest
Date |  |  | End Date | 2001-03-12 00:00:00
Beginning Balance |  |  | Days
Date |  |  | LIBOR | 0.0658
Interest
Date |  |  | End Date | 2001-03-15 00:00:00
Beginning Balance |  |  | Days
Date |  |  | LIBOR | 0.0658
Interest
Date |  |  | End Date | 2001-06-15 00:00:00
Beginning Balance |  |  | Days
Date |  |  | LIBOR | 0.0538875
Interest
Date |  |  | End Date | 2005-04-18 00:00:00
Beginning Balance |  |  | Days
Date |  |  | LIBOR | 0.0389
Interest
Interest Expense Summary
Interest Expense
Interest from Amort Sheet
Additional Interest included in Amort Sheet
Transaction Date
Amount
Date
Days
Additional Interest
Transaction Date |  |  | Date
Amount |  |  | Days
ENE Shares |  |  | Additional Interest
LJM Maximum Capital
Report Date
Intial Contribution | 2000-08-31 00:00:00
Additional
Capital Return if available
Maxium B/S LJM Capital
Spreadsheet: 116816d1312200289-subtotal-only-visible-columns-subtotal109-with-hidden-columns
Sheet: Sheet2

 |  |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  |  |  |  | Subtotal 109 function cant get to work Help !!!
Sales |  |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100
Spreadsheet: 773356d1647810535-transposing-complex-data-into-usable-format-power-query-merge-using-offset-indexs
Sheet: Table1

VLAN | IP ADDRESS | SUBNET MASK | Table1 (2).IP ADDRESS | Table1 (2).SUBNET MASK
Vlan 10 | 10.10.10.0 | 255.255.255.240 | 10.10.20.0 | 255.255.255.224
Vlan 10 | 10.10.10.16 | 255.255.255.240 | 10.10.20.32 | 255.255.255.224
Vlan 10 | 10.10.10.32 | 255.255.255.240 | 10.10.20.64 | 255.255.255.224