tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 270564d1381524950-list-dates-that-correspond-to-employee-id-numbers-from-a-different-sheet-example4-tallag-oeldere-
Sheet: Sheet1

date | choise
2013-08-15 00:00:00 | 31 |  |  | Rijlabels
2013-08-15 00:00:00 | 32 |  |  | 31
2013-08-15 00:00:00 | 33 |  |  | 2013-08-15 00:00:00
2013-08-15 00:00:00 | 33 |  |  | 2013-08-22 00:00:00
2013-08-15 00:00:00 | 8 |  |  | 2013-08-30 00:00:00
2013-08-15 00:00:00 | 8 |  |  | 32
2013-08-15 00:00:00 | 8 |  |  | 2013-08-15 00:00:00
2013-08-15 00:00:00 | 7 |  |  | 2013-08-22 00:00:00
2013-08-15 00:00:00 | 31 |  |  | 2013-08-30 00:00:00
2013-08-15 00:00:00 | 32 |  |  | 33
2013-08-15 00:00:00 | 31 |  |  | 2013-08-15 00:00:00
2013-08-22 00:00:00 | 8 |  |  | 2013-08-22 00:00:00
2013-08-22 00:00:00 | 8 |  |  | 2013-08-30 00:00:00
2013-08-22 00:00:00 | 31 |  |  | Eindtotaal
2013-08-22 00:00:00 | 33
2013-08-22 00:00:00 | 32
2013-08-22 00:00:00 | 8
2013-08-30 00:00:00 | 31
2013-08-30 00:00:00 | 32
2013-08-30 00:00:00 | 33
2013-08-30 00:00:00 | 7
2013-08-30 00:00:00 | 8
2013-08-30 00:00:00 | 8
Spreadsheet: 756540d1637620230-retrieve-hours-worked-based-on-day-of-week-in-rota-gamersheek-rota
Sheet: September

` | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI
 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 | 2021-09-08 00:00:00 | 2021-09-09 00:00:00 | 2021-09-10 00:00:00 | 2021-09-11 00:00:00 | 2021-09-12 00:00:00 | 2021-09-13 00:00:00 | 2021-09-14 00:00:00 | 2021-09-15 00:00:00 | 2021-09-16 00:00:00 | 2021-09-17 00:00:00 | 2021-09-18 00:00:00 | 2021-09-19 00:00:00 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-25 00:00:00 | 2021-09-26 00:00:00 | 2021-09-27 00:00:00 | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI
 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-05 00:00:00 | 2021-09-06 00:00:00 | 2021-09-07 00:00:00 | 2021-09-08 00:00:00 | 2021-09-09 00:00:00 | 2021-09-10 00:00:00 | 2021-09-11 00:00:00 | 2021-09-12 00:00:00 | 2021-09-13 00:00:00 | 2021-09-14 00:00:00 | 2021-09-15 00:00:00 | 2021-09-16 00:00:00 | 2021-09-17 00:00:00 | 2021-09-18 00:00:00 | 2021-09-19 00:00:00 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-25 00:00:00 | 2021-09-26 00:00:00 | 2021-09-27 00:00:00 | 2021-09-28 00:00:00 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 174667d1345141081-show-only-data-that-meets-criteria-for-two-columns-worksheet
Sheet: Sheet1

ACCT CODE | ACCT [NAME] | YTD ACTUAL | YTD BUDGET | $ [NAME] | % VARIANCE
100 | Office supplies | 10000 | 8000
200 | Equipment | 20000 | 15000
300 | Postage | 5000 | 6000
400 | Taxes | 15000 | 10000
Spreadsheet: 697399d1601337998-using-index-and-match-but-omitting-some-results-report-help
Sheet: Report

Network | Contact | Sign Stat | [NAME] stat | Path stat | Address | Rate | Sign | PATH | DROP
 | xxx-xxxx-xxxx | complete | canceled | complete | 123 Address | [NAME] | [NAME] | Ant
 | xxx-xxxx-xxxx | complete | pending | - | 12 can place | [NAME] | [NAME] | [NAME]
 | xxx-xxxx-xxxx | pending | pending | pending | 1 False st | [NAME] | [NAME] | [NAME]
 | xxx-xxxx-xxxx | pending | pending | pending | 1 False st | [NAME] | [NAME] | [NAME]
 | xxx-xxxx-xxxx | pending | pending | pending | 1 False st | [NAME] | [NAME] | [NAME]
 | xxx-xxxx-xxxx | canceled | pending | complete | 19 fake St | [NAME] | [NAME] | Ant
 | xxx-xxxx-xxxx | canceled | complete | - | 22 fake St | [NAME] | - | [NAME]
 | xxx-xxxx-xxxx | complete | canceled | - | 23 fake St | - | [NAME] | -
 | Want to achieve below
Network | Contact | Sign Stat | [NAME] stat | Path stat | Address | Rate | Sign | PATH | DROP
2233412 | xxx-xxxx-xxxx | complete | canceled | complete | 123 Address | 2 | [NAME]
2233412 | xxx-xxxx-xxxx | complete | pending | - | 12 can place | 2 |  | [NAME]
2233412 | xxx-xxxx-xxxx | pending | pending | pending | 1 False st | 3 | [NAME] | [NAME] | [NAME]
2233412 | xxx-xxxx-xxxx | canceled | pending | complete | 19 fake St | 4 | [NAME]
2233412 | xxx-xxxx-xxxx | canceled | complete | - | 22 fake St | 2 | [NAME]
2233412 | xxx-xxxx-xxxx | complete | canceled | - | 23 fake St | 3 | - | [NAME]
Spreadsheet: 796647d1663416994-network-days-table-for-employees-with-allocations-networkdays
Sheet: Sheet1

 |  |  |  |  |  |  | FTE/Allocations
 |  | Employee ID | Name | Start Date | End Date | Allocation | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 |  | 12345 | Employee 1 | 2022-08-01 00:00:00 |  | 0.5
 |  | 12345 | Employee 4 | 2022-07-18 00:00:00 |  | 0.3
 |  | 12345 | Employee 5 | 2022-08-15 00:00:00 | 2022-09-15 00:00:00 | 1
 |  | 12345 | Employee 6 | 2022-10-05 00:00:00 |  | 1
 |  | 12345 | Employee 7 | 2022-08-01 00:00:00 |  | 1
 |  | 12345 | Employee 8 | 2022-08-15 00:00:00 |  | 1
 |  | 12345 | Employee 9 | 2022-09-01 00:00:00 | 2022-09-30 00:00:00 | 0.1
 |  | 12345 | Employee 13 | 2022-07-01 00:00:00 | 2022-11-22 00:00:00 | 0.5
 |  | 12345 | Employee 15 | 2022-08-15 00:00:00 |  | 0.2
Spreadsheet: 211670d1359880524-pattern-matching-within-a-dynamic-data-set-position_spreadsheet-copy
Sheet: End_Result

Product |  |  |  | Flies | 5 | -8 | 6 | -10
 | Position | UnFlied
2013-03-01 00:00:00 |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2013-06-01 00:00:00 |  |  |  |  |  | -8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2013-09-13 00:00:00 |  |  |  |  | 5 |  |  | -10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2013-12-13 00:00:00 |  |  |  |  | -10 | 16 | -12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2014-03-01 00:00:00 |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2014-06-01 00:00:00 |  |  |  |  |  | -8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2014-09-01 00:00:00 |  |  |  |  |  |  | 6 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2014-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2015-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2015-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2015-09-01 00:00:00 |  |  |  |  |  |  |  | -10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2015-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2016-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2016-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2016-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2017-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2017-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 738035d1624777969-getting-information-from-sheet1-and-populatuing-in-sheet2-with-formatting-copy-of-example
Sheet: Sheet1

Code number | Dept
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
 | 5626
54245826 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
 | 8954
52698536 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
52698536 | 2563
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
 | 5896
23587459 | 5896
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
 | 2563
56985234 | 2563
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
 | 2541
Spreadsheet: 272502d1382410691-count-of-account-numbers-length-of-stay-sample
Sheet: Sheet1

Account Number | Time In | Time Out | Unit | Length of Stay
X123 | 12:53:00 | 12:54:00 | 4
X123 | 12:54:00 | 13:01:00 | 5
X456 | 01:06:00 | 01:10:00 | 4
X789 | 07:08:00 | 07:09:00 | 3
X789 | 07:09:00 | 08:10:00 | 4
X789 | 08:10:00 | 09:00:00 | 5
Spreadsheet: 83042d1283086745-refering-to-specific-entry-in-a-drop-down-list-fsr-wc-2010-statistic-book
Sheet: Sheet2

 |  | Starts
Spreadsheet: 227307d1365671279-competition-generator-leaguekatti
Sheet: Sheet3

Rank | Player | P | W | D | L | F | A | [NAME] | Pts | points deducted | Tie Breaker
 | A |  |  |  |  |  |  |  |  |  |  | 3 | pts
 | B |  |  |  |  |  |  |  |  |  |  | 1 | pts
 | C |  |  |  |  |  |  |  |  |  |  | 0 | pts
 | D
Spreadsheet: 810351d1671712276-sum-constant-52-previous-cells-in-one-column-ignoring-clear-cells-book1
Sheet: (4)

ssp | (Sick)
B | (Basic)
t
9.2 | Rate
 |  |  |  |  | (1) | (2) | (3) | (4)
Week No | Basic Hr | W/E Hr | Total Hours inc Hol Hrs | Days worked W & W/E | Code | Total Money  [NAME] | Other Paymts | [NAME] | SSP | Total Money | Total Pay 52 W | Total Hours 52w | Rate for Holiday Pay
1  2021 | 20 |  |  | 6 | b |  |  | 9.2 |  |  |  |  |  | Example
1  20_21 | 39 | 48 |  |  | b | 1046.1
2 | 39 | 18 |  |  | b | 621.9
3 | 39 | 26.5 |  |  | b | 742.09
4 | 39 | 37 |  |  | b | 890.56
5 | 39 | 56 |  |  | b | 1159.22
6 | 39 | 18.5 |  |  | b | 628.97
7 | 39 | 11.25 |  |  | b | 526.46
8 | 39 | 3.5 |  |  | b | 416.87
9 | 39 | 6.5 |  |  | b | 459.29
10 | 39 | 0 |  |  | b | 367.38
11 | 39 | 4 |  |  | b | 423.94
12 | 39 | 0 |  |  | b | 367.38
13 | 39 | 8.5 |  |  | b | 487.57
14 | 39 | 2.75 |  |  | b | 406.27
15 | 39 | 5.5 |  |  | b | 445.15
16 | 39 | 3 |  |  | b | 409.8
17 | 39 | 15.5 |  |  | b | 586.55
18 | 39 | 19 |  |  | b | 636.04
19 | 39 | 45.5 |  |  | b | 1010.75
20 | 39 | 49 |  |  | b | 1060.24
21 | 39 | 0 |  |  | b | 367.38
22 | 39 | 50 |  |  | b | 1074.38
23 | 39 | 13.5 |  |  | b | 558.27
24 | 39 | 49.25 |  |  | b | 1063.78
25 | 39 | 56.5 |  |  | b | 1166.29
26 | 39 | 39.5 |  |  | b | 925.91
27 | 39 | 47 |  |  | b | 1042.81
28 | 39 | 19.5 |  |  | b | 643.11
29 | 39 | 56.5 |  |  | b | 1166.29
30 | 39 | 23 |  |  | b | 705.4
31 | 39 | 2 |  |  | b | 329.72
32 | 39 | 2 |  |  | b | 406.44
33 | 39 | 10 |  |  | b | 519.63
34 | 39 | 8 |  |  | b | 491.42
35 | 39 | 5.75 |  |  | b | 525.62
36 | 39 | 0 |  |  | b | 380.18
37 | 39 | 1.5 |  |  | b | 401.39
38 | 39 | 0 |  |  | b | 392.98
39 | 39 | 1.5 |  |  | b | 414.35
40 | 39 | 0 |  |  | b | 406.02
41 | 39 | 0 |  |  | b | 378.72
42 | 39 | 0 |  |  | b | 378.79
43 | 39 | 0.5 |  |  | b | 385.65
44 | 39 | 1.5 |  |  | b | 398.74
45 | 39 | 1.5 |  |  | b | 399.65
46 | 39 | 4 |  |  | b | 435
47 | 39 | 2 |  |  | b | 397.23
48 | 39 | 3 |  |  | b | 420.79
49 | 39 | 4 |  |  | b | 423.94
50 | 39 | 7 |  |  | ssp | 466.36
51 | 29.5 | 0 |  |  | ssp | 297.06
52 | 39 | 34 |  |  | b | 848.14
1 21_22 | 39 | 19 |  |  | b | 636.04
2 | 39 | 14.5 |  |  | b | 572.41
3 | 39 | 17.25 |  |  | b | 668.81
4 | 39 | 20.5 |  |  | b | 657.25
5 | 39 | 28 |  |  | b | 763.3
6 | 39 | 55 |  |  | b | 1145.08
7 | 39 | 10.25 |  |  | b | 512.32
8 | 39 | 20.5 |  |  | b | 798.65
9 | 39 | 35.25 |  |  | b | 865.82
10 | 39 | 34.5 |  |  | b | 965.18 |  |  |  |  |  |  |  |  |  |  | needs add 2 weeks adding
11 | 39 | 3 |  |  | b | 409.8 |  |  |  |  |  |  |  |  |  |  | so there are 52 weeks of figures | 416.87
12 | 39 | 11.5 |  |  | b | 529.99 |  |  |  |  |  |  |  |  |  |  |  | 459.29
13 | 39 | 15.5 |  |  | b | 586.55
Spreadsheet: 07932777-3d27-4f6e-a24e-0c325c95863b
Sheet: Sheet1

Table 5--U.S. and world fiber prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Feb. | Mar. | Apr. |  | Apr.
Item | 2013 | 2013 | 2013 |  | 2012
 | Cents per pound
Domestic cotton prices:
Adjusted world price | 69 | 72.92 | 71.74 |  | 78.34
Upland spot 41-34 | 76.87 | 82.8 | 80.94 |  | 83.37
Pima spot 03-46 | 109.05 | 111.65 | 116.5 |  | 127
Average price received by
upland producers | 75.3 | 75.3 | 74.8 |  | 90.4
Far Eastern cotton quotes:
A Index | 89.86 | 94.74 | 92.9 |  | 99.33
Memphis/Eastern | 92.06 | 97.06 | 94.31 |  | 102.13
Memphis/Orleans/Texas | 91.69 | 96.81 | 94.06 |  | 102.13
California/Arizona | 95.31 | 100 | 97.56 |  | 103.5
 |  | Dollars per pound
Wool prices (clean):
U.S. 56s | NQ | NQ | NQ |  | NQ
Australian 56s 1/ | 3.95 | 4 | 3.74 |  | 4.11
U.S. 60s | NQ | NQ | NQ |  | NQ
Australian 60s 1/ | 5.76 | 5.63 | 5.17 |  | 6.03
U.S. 64s | NQ | NQ | NQ |  | NQ
Australian 64s 1/ | 5.95 | 5.84 | 5.38 |  | 6.35
NQ = No quote.
1/  In bond, Charleston, SC.
Sources: USDA, Cotton Price Statistics; Cotlook Ltd., [NAME];
and trade reports.
Last update:  05/14/13.
Spreadsheet: 885241d1734684226-date-of-birth-and-gender-identifucation-excel-forum-id-number
Sheet: Sheet1

 | National Identity Number
 |  |  | 6 Digits from L/H | Gender
 | 8111146100141 |  | 811114 | 6100 | Male
 | 8811131100150 |  | 881113 | 1100 | Female
TABLE
Name | ID No# |  | DATE OF BIRTH | GENDER
[NAME] | 8111146100141 |  | 1981-11-14 00:00:00 | Male
[NAME] | 1311131100150 |  | 2013-11-13 00:00:00 | Female
Spreadsheet: 747820d1631715506-how-to-have-excel-count-the-lengths-of-continuous-ranges-duration-of-ranges
Sheet: Sheet1

220.74 |  | 8
222.42
221.52
224.78
221.77
223.39
226.62
228.43
-208.12 |  | 1
-198.12 |  | 18
-197.47
-194.96
-196.59
-195
-192.05
-192.91
-195.55
-195.91
-194.07
-186.09
-187.77
-181.58
-189.63
-198.39
-202.46
-205.08
-200.46
180.16 |  | 8
178.22
174.22
173.55
174.5
176.12
175.71
169.63
140.61 |  | 7
140.11
141.61
142.37
136.6
137.53
143
124.63 |  | 24
125.15
115.84
124.52
123.61
127.95
133.96
138.32
137.05
132.98
144.88
141.32
143.45
149.15
148.18
148.95
153.18
149.5
152.4
147.53
142.52
144.28
135.81
136.55
128.5 |  | 6
131.91
135.22
134.75
136.12
132.67
132.48
132.21
129.45
131.27
134.27
134.15
134.09
135.01
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 55927 | 56112
2 | 45352 | 41112
3 | 39348 | 38072
4 | 57516 | 58575
5 | 38360 | 38612
6 | 38227 | 38612
7 | 38252 | 38612
8 | 53083 | 55820
9 | 32289 | 18110
10 | 38336 | 40659
11 | 45961 | 45820
12 | 58658 | 58864
13 | 58648 | 58864
14 | 53073 | 52864
15 | 43337 | 45610
16 | 42964 | 45253
17 | 48358 | 50595
18 | 46348 | 48259
19 | 57495 | 59137
20 | 59012 | 59137
21 | 47402 | 49004
22 | 56240 | 57866
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 40735.55
2002-01-22 00:00:00
CBS Volume
 |  |  | 19256
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  | San Juan
2 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 |  |  |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 |  |  |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 |  |  |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 |  |  |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 | -110 |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 | -30073 | -25000 |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10 | -44200 | -42000
11 | -42947 | -40000
12 | -62497 | -57499
13 | -64806 | -72375
14 | -72055 | -68365 |  |  |  | 9/1 - 9/25
15 | -69675 | -70643
16 | -63813 | -77366
17 | -73089 | -80300
18 | -74890 | -78560
19 | -71585 | -80300 |  |  |  | Accumulated @ 9/25/01
20 | -68744 | -54998
21 | -53861 | -54998 |  |  |  | Equilalent volumes at 9/25/01
22 | -59445 | -54998
23 | -70000 | -54998
24 | -69358 | -54998
25 | -76943 | -70198
26 | -82232 | -85298
27 | -85851 | -80298
28 | -83024 | -79925
29 | -83685 | -83482
30 | -57873 | -63682
31
2001-10-31 00:00:00 |  |  | -10179.78
2001-11-30 00:00:00
CBS Volume
 |  |  | 86232
Spreadsheet: mary_fischer__25621__77N
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 077N
COMPANY NAME    Marlin Electrical, Inc
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 119804d1314758830-how-to-sum-data-sourced-through-indirect-and-match-workbook2
Sheet: Rec

Date | Position | AUD | BRL | CAD | CHF | CZK | DKK | EUR | GBP | HKD | HUF | ILS | [NAME] | KRW | NOK | NZD | SEK | SGD | THB | TRY | USD | ZAR
30Aug2011 | Initial | 2360085.93 | 35629.58 | 126589.53 | 0 | 6538 | 0 | 0 | 0 | 0 | 0 | 0 | 135629865 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6016.5 | 0
 | Trade | 542560.08 | <- this cell should sum all of the AUD currency values sourced from sheet 30Aug2011
 | End | 2902646.01
31Aug2011 | Confirmation | (likely hardcoded reconcilation with another source)
 | Trade | sums relevant trades from 31Aug11 tab |  |  |  |  |  | Date | 2011-08-30 00:00:00 | <<You can filter by Date here
 | End | gives running end total
31Aug2011 | Initial | etc |  |  |  |  |  | Sum of Net Cons
 | Trade | etc |  |  |  |  |  | CCY | Total
 | End | etc |  |  |  |  |  | AUD | 11190281.13
 |  |  |  |  |  |  |  | BRL | 992040.9200000002
 |  |  |  |  |  |  |  | DKK | 8618968.26
 |  |  |  |  |  |  |  | GBP | 6602209.619999999
 |  |  |  |  |  |  |  | HUF | 1356906.76
 |  |  |  |  |  |  |  | USD | 3704711.790000001
 |  |  |  |  |  |  |  | Grand Total | 32465118.48
Spreadsheet: 01d93c69-5e6c-4dbc-becd-f9d3219ac6f9
Sheet: Simple Reg

OBS | ACRES | AGE | EDUC | COUNTY |  | SUMMARY OUTPUT
1 | 190 | 50 | 14 | [NAME]
2 | 135 | 59 | 14 | Haynes |  | Regression Statistics
3 | 275 | 39 | 16 | Haynes |  | Multiple R | 0.881415217709351
4 | 185 | 49 | 14 | Haynes |  | R Square | 0.7768927860096226
5 | 340 | 39 | 12 | [NAME] |  | Adjusted R Square | 0.767192472357867
6 | 575 | 32 | 16 | Haynes |  | Standard Error | 82.41994064326634
7 | 210 | 51 | 14 | [NAME] |  | Observations | 25
8 | 95 | 55 | 8 | Haynes
9 | 55 | 67 | 8 | [NAME] |  | ANOVA
10 | 210 | 28 | 12 | Haynes |  |  | df | SS | MS | F | [NAME]
11 | 280 | 35 | 14 | Haynes |  | Regression | 1 | 544051.3678402905 | 544051.3678402905 | 80.0894500838148 | 5.945917423230176e-09
12 | 0 | 68 | 8 | [NAME] |  | Residual | 23 | 156240.0721597096 | 6793.046615639547
13 | 120 | 55 | 12 | Haynes |  | Total | 24 | 700291.4400000002
14 | 80 | 59 | 12 | [NAME]
15 | 600 | 30 | 18 | [NAME] |  |  | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
16 | 415 | 29 | 18 | Haynes |  | Intercept | 746.9159346642468 | 61.10762164567145 | 12.22295868419148 | 1.529266680042506e-11 | 620.5051888139108 | 873.3266805145829 | 620.5051888139108 | 873.3266805145829
17 | 0 | 62 | 8 | Haynes |  | AGE | -11.10961887477314 | 1.241399323837798 | -8.949270924707486 | 5.945917423230176e-09 | -13.67764901894019 | -8.541588730606094 | -13.67764901894019 | -8.541588730606094
18 | 395 | 27 | 16 | Haynes
19 | 480 | 31 | 16 | [NAME]
20 | 180 | 52 | 12 | [NAME]
21 | 60 | 63 | 6 | Haynes
22 | 0 | 61 | 12 | Haynes
23 | 108 | 61 | 12 | Haynes
24 | 225 | 46 | 12 | [NAME]
25 | 295 | 37 | 16 | [NAME]
Spreadsheet: b7639877-b92e-4711-aad1-c1c1430fed05
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Print Music, Word Owned * | 80689463389 | [NAME] | Veggietales 25 Silly Songs | 2013-09-10 | Piano Folio | Na | 17.95 | Y | Available
[NAME] | 38081463575 | Various | The Giant Book Of Christian Sheet Music | 2013-10-22 | Piano Folio | Na | 19.99 | Y | Available
[NAME] | 38081460345 | [NAME] | 2013 Greatest [NAME] | 2013-10-22 | Piano Folio | Na | 10.99 | Y | Available
[NAME] | 38081463490 | [NAME] | An Impressionistic Christmas | 2013-10-22 | Piano Folio | Na | 12.99 | Y | Available
[NAME] | 38081463520 | Various | The Bible | 2013-12-03 | Piano Folio | Na | 14.99 | Y | Available
[NAME] | 38081463216 | [NAME] | What Can I Play On Sunday?, Complete Collection | 2013-12-03 | Piano Folio | Na | 34.99 | Y | Available
[NAME] | 38081464817 | Various | Songs Of Inspiration, Perseverance, And Hope | 2013-12-03 | Piano Folio | Na | 19.99 | Y | Available
[NAME] | 38081472393 | [NAME] | Inspirational Pop Hits | 2013-12-29 | Piano Folio | Na | 12.99 | Y | Available
[NAME] | 38081454153 | [NAME] | A Glorious Wedding Celebration | 2013-12-29 | Piano Folio | Na | 12.99 | Y | Available
Spreadsheet: 689601d1596546442-vlookup-result-that-then-will-not-change-fixed-or-static-vlookup
Sheet: Spreadsheet A

Region | Matter [NAME] | Action Taken
East |  | Wrote on 01/01/20
West |  | Phoned 2/3/20 AM
Central |  | None taken
East |  | Could not reach
North |  | Outstanding
South |  | Could not reach
South |  | None taken
Spreadsheet: mark_taylor__24725__ClickInTradingProducts
Sheet: ContGas

Short Description Boxes for Continental Gas:
Continental Gas Financial |  | Location |  | Delivery Point |  | Term
 |  | Zeebrugge |  | IUK:DTS Flange |  | Winter ' 99
 |  |  |  |  |  | Summer ' 00
 |  |  |  |  |  | Year 2000
Continental Gas Physical |  | Location |  | Delivery Point |  | Term |  | Min daily Qty |  | [NAME]
 |  | Zeebrugge |  | IUK:DTS Flange |  | Winter ' 99
 |  |  |  |  |  | Summer ' 00
 |  |  |  |  |  | Year 2000
Notes: | 1. Include Gas CV into GTCs
 | 2. Later Phases locations may include [NAME] and Blaregnies.
Long Descriptions
Delivery Point: | IUK:DTS Flange | Being the point where the flange(s) connect the Distrigas system with the Interconnector
Term: | Winter ' 99 | Period between 0600 (CST) on 1 November 1999 and 0600 (CST) 31 March 2000
 | Summer ' 00 | Period between 0600 (CST) on 1 April 2000 and 0600 (CST) on 31 October 2000
 | Year 2000 | Period between 0600 (CST) on 1 January 2000 and 0600 (CST) on  31 December 2000