tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 682956d1592407844-auto-update-another-column-book1b
Sheet: Sheet3

Date | Who | Department | Product | Show/Job No | Budget Code | Quantity | Quantity Full | Quantity Instock | Price | Total Price
2020-02-04 00:00:00 | [NAME] | Dept 1 | Bubble blower | Science Show 2020 | BUD_000625 | 20 | 500
2020-02-04 00:00:00 | [NAME] | Dept 2 | Glow in the dark pens | Japan Conference | BUD_000625 | 150 | 500
2020-02-04 00:00:00 | [NAME] | Dept 3 | Lanyards | UK Business Show | BUD_000625 | 100 | 500
2020-02-04 00:00:00 | [NAME] | Dept 4 | Glow in the dark pens | Science Show 2020 | BUD_000625 | 45 | 500
2020-02-04 00:00:00 | [NAME] | Dept 5 | Memory Stick Blue | Geography Show | BUD_001434 | 1 | 500
2020-02-04 00:00:00 | [NAME] | Dept 5 | Glow in the dark pens | Geography Show | BUD_000268 | 50 | 500
2020-02-06 00:00:00 | [NAME] | Dept 5 | Glow in the dark pens | Geography Show | BUD_001420 | 60 | 500
2020-02-07 00:00:00 | [NAME] | Dept 5 | Memory Stick Blue | Geography Show | [NAME] | 4 | 500
2020-02-09 00:00:00 | [NAME] | Dept 5 | Glow in the dark pens | UK Business Show | BUD_001426 | 750 | 500
2020-02-10 00:00:00 | [NAME] | Dept 1 | Glow in the dark pens | UK Business Show | BUD_001420 | 60 | 500
2020-02-11 00:00:00 | [NAME] | Dept 1 | [NAME] | Japan Conference | BUD_000972 | 4 | 500
2020-02-18 00:00:00 | [NAME] | Dept 1 | Notepad | Japan Conference | BUD_000291 | 10 | 500
2020-02-18 00:00:00 | [NAME] | Dept 1 | Bunting | Japan Conference | BUD_001355 | 1 | 500
2020-02-24 00:00:00 | [NAME] | Dept 2 | Heat sensitive [NAME] | USA Expo | BUD_000134 | 100 | 500
2020-02-24 00:00:00 | [NAME] | Dept 2 | Notepad | USA Expo | BUD_000632 | 35 | 500
2020-02-24 00:00:00 | [NAME] | Dept 2 | Tshirt black | USA Expo | BUD_000586 | 200 | 500
2020-02-25 00:00:00 | [NAME] | Dept 2 | Lanyards | USA Expo | BUD_000327 | 50 | 500
2020-02-25 00:00:00 | [NAME] | Dept 3 | Pencils | UK Business Show | BUD_001424 | 400 | 500
2020-02-26 00:00:00 | [NAME] | Dept 3 | Notepad | Geography Show | [NAME] | 50 | 500
2020-02-28 00:00:00 | [NAME] | Dept 4 | Lanyards | Science Show 2020 | BUD_001367 | 1 | 500
2020-02-28 00:00:00 | [NAME] | Dept 4 | Heat sensitive [NAME] | Science Show 2020 | BUD_001345 | 1 | 500
2020-02-28 00:00:00 | [NAME] | Dept 4 | Glow in the dark pens | Science Show 2020 | BUD_001343 | 1 | 500
2020-02-28 00:00:00 | [NAME] | Dept 1 | Heat sensitive [NAME] | USA Expo | BUD_000586 | 300 | 500
2020-02-25 00:00:00 | [NAME] | Dept 2 | Glow in the dark pens | Geography Show | [NAME] | 5 | 500
2020-02-24 00:00:00 | [NAME] | Dept 3 | Notepad | Geography Show | BUD_000586 | 10 | 500
2020-02-25 00:00:00 | [NAME] | Dept 4 | Notepad | Geography Show | BUD_000587 | 10 | 500
Spreadsheet: 773795d1648050912-if-between-numbers-test-reply
Sheet: Sheet3

 | Name | daily rate | amount
 | a | 400
 | b | 600
 | c | 1200 |  |  |  |  |  |  | daily rate | amount to pay
 | d | 2500 |  |  |  |  |  |  | >=400 | Minim in LE-3500
 |  |  |  |  |  |  |  |  | Over 400>=600 | Minim in LE-4000
 |  |  |  |  |  |  |  |  | Over 600>=950 | Minim in LE-5000
 |  |  |  |  |  |  |  |  | = & over 1000 | Minim in LE-6000
 |  |  |  |  |  |  |  |  | Over 2000 | Maxim in LE-13000
 | Name | daily rate | Reward | Payment |  | Threshold | Reward
 | a | 400 |  |  |  | 0 | 0
 | b | 600 |  |  |  | 400 | 0.01
 | c | 1200 |  |  |  | 600 | 0.02
 | d | 2500 |  |  |  | 950 | 0.025
 |  |  |  |  |  | 1000 | 0.03
 |  |  |  |  |  | 2000 | 0.045
Spreadsheet: dd48b9fd-1e15-492b-8eef-e28a6fd4f7e3
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
EGG | Test | EGG | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
EGG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EGG | Result | EGG | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6106-9 | Egg white Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 875470d1722020989-highlight-stock-level-differences-between-2-sheets-example-etaf
Sheet: Listed Stock

SKU | Product name | Quantity
P01598 | Example Product 45 | 10
P01542 | Example Product 52 | 192
P01548 | Example Product 85 | 59
P01986 | Example Product 32 | 314
P01478 | Example Product 16 | 2
P01689 | Example Product 47 | 75
P06688 | Example Product 40 | 105
P04562 | Example Product 58 | 6
Spreadsheet: louise_kitchen__23077__Schedule C_Reserve901
Sheet: Schedule C

 | Enron North America
 | Schedule C & Specific Reserves
 | Third Quarter 2001
 | in Millions
 | Gas Books
 | Gas & Power Valuation adjustment
 | Credit Reserve
 | Reserve for potential Sithe exposure (OA, etc.) |  | 10.7
 | Napoleanville Pad Gas |  | 1.6
 | APEA Prepay |  | 1.1
 | Canada Toll Rates |  | 1
 | Other |  | 4.4
 | Total Gas Books
 | Power Books
 | California Political risk |  | 21.4
 | Colorado Springs |  | 17.2
 | FP&L / JEA |  | 10.3
 | PG&E claim valuation ($86  claim liab vs. unwind of $137) |  | 26
 | BPA Renegotiation (Oregon open access) |  | 22.8
 | ERCOT Transmission |  | 2.9
 | OPPD |  | 5
 | VEPCO |  | 3
 | MJMUC |  | 2
 | Green Mountain |  | 2.1
 | Welded Tube |  | 0.6
 | Canfibre |  | 2.9
 | Other under $1 million |  | 0.9
 | Total Power Books
 | EES Flash to Actual Reserved on ENA Books |  | 199
 | Total Schedule C
 | Specific Credit Reserves |  | 29.7
 | Total Reserves in PRM Portfolio
 | Allowance for Doubtful Accounts provided by ENA
 | EES PX Credit Reserve |  | 308
 | [NAME] and PX Reserve |  | 22
 | ENA Reserve for PGE US Financial Claim |  | 24
 | Total Allowance for Doubtful Accounts
 | Total ENA Reserves
Spreadsheet: 06ce980e-4d63-41d6-8255-fab54d426b45
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 34. LEASE FINANCE COMMITMENTS, By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413927F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413929K | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413930V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413931W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413932X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413933A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413934C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413935F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413936J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413938L | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413939R | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413940X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413941A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413942C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 146349d1332133593-merge-columns-problem-google-analytics-events-management-sheet
Sheet: Website Events Code

 | Categories | Action | Label | Value |  | GA Event Code
1 | a | d | g |  |  | _gaq.push(['_trackEvent',b3,c3,d3);
2 | b | e | h |  |  | _gaq.push(['_trackEvent',b4,c4,d4);
3 | c | f | i |  |  | _gaq.push(['_trackEvent',b5,c5,d5);
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
Spreadsheet: 728252d1618392640-network-days-spread-through-months-network-days
Sheet: Sheet1

 |  | Task | Start Date | End Date | Number of Days | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22
 |  | Scoping Exercise | 2021-04-14 00:00:00 | 2021-04-30 00:00:00
 |  | Planning Exercise | 2021-05-03 00:00:00 | 2021-05-14 00:00:00
 |  | Design Exercise | 2021-05-17 00:00:00 | 2021-07-20 00:00:00
 |  | Development Exercise | 2021-07-21 00:00:00 | 2021-11-26 00:00:00
Spreadsheet: 856527d1705738916-move-data-from-columns-to-rows-with-some-common-fields-thanks-excel-cloumns-to-rows-example
Sheet: Sheet1

Name | Currency | Performance Bonus | Dividend | Deferral | MEP Payment 1 | MEP Payment 2 | Deferral 2
[NAME] | USD | 55000 | 398 | 10000 | 25000 | 20000 | 1000
[NAME] | USD | 27500 | 146 | 5000 | 10000 | 9000 | 6000
[NAME] | USD | 10000 |  |  |  | 1000
Luisa | GBP | 13000 |  |  | 1432 | 1600
Name | Currency | Type of Payment | Amount
 | USD | Performance Bonus | 55000
[NAME] | USD | Dividend | 398
[NAME] | USD | Deferral | 10000
[NAME] | USD | MEP Payment 1 | 25000
[NAME] | USD | MEP Payment 2 | 20000
[NAME] | USD | Deferral 2 | 1000
[NAME] | USD | Performance Bonus | 27500
[NAME] | USD | Dividend | 146
[NAME] | USD | Deferral | 5000
[NAME] | USD | MEP Payment 1 | 10000
[NAME] | USD | MEP Payment 2 | 9000
[NAME] | USD | Deferral 2 | 6000
[NAME] | USD | Performance Bonus | 10000
[NAME] | USD | MEP Payment 2 | 1000
Luisa | GBP | Performance Bonus | 13000
Luisa | GBP | MEP Payment 1 | 1432
Luisa | GBP | MEP Payment 2 | 1600
Spreadsheet: 776471d1649753468-formula-to-retrieve-all-values-that-fall-under-row-1-header-name-example_michlam
Sheet: Desired output_NEW

Q1r1 | Q1r2 | Q2r1 | Q4 | Q5 | X |  |  | 0 |  | 0 | 0
Spreadsheet: 876284d1722963769-using-time-and-hours-of-day-to-determine-total-count-doorcount
Sheet: Sheet1

employee | date | hour
[NAME] | 2024-08-06 00:00:00 | 1800
[NAME] | 2024-08-05 00:00:00 | 0800
bunny | 2024-08-05 00:00:00 | 2200
margo | 2024-08-04 00:00:00 | 1100
[NAME] | 2024-08-04 00:00:00 | 1800
bunny | 2024-08-03 00:00:00 | 1300
margo | 2024-08-03 00:00:00 | 1100
[NAME] | 2024-08-04 00:00:00 | 1300
bunny | 2024-08-05 00:00:00 | 1400
bunny | 2024-08-06 00:00:00 | 0500
margo | 2024-08-07 00:00:00 | 0900
Spreadsheet: 419532c3-44fb-4527-8bc1-dfdcefb4127c
Sheet: Ex. 23 - Operating Budget

23.  Operating Budget   (Rental)
Project Name
Total Square Feet
# of Units
Total # of Bedrooms
Operating Expenses | HUD Number | Total Annual | Per Unit Cost
Management
Management Fee | 6320
Administrative Rent Free Unit | 6331
sub-total Management Expenses:
Administration
Seminars & Training | 6203
Advertising | 6210
Office Supplies | 6311
Office Rent | 6312
Computer Charges | 6314
Legal | 6210
Other Professional Fees | 6349
Audit | 6350
Bookkeeping | 6351
Telephone (office, fax, data, entry system) | 6360
Bad Debts | 6370
Social/Dues/Travel/Equip. maint. | 6390
Credit Reports | 6394
Mileage/Travel | 6395
Bank Charges | 6396
Other:___________________________ | 6390
sub-total Administration Expenses:
Personnel
On-Site Manager(s) | 6330
[NAME] | 6530
Grounds, Janitorial, Repairs and Maintenance | 6540
Payroll Taxes | 6711
Worker's Compensation | 6722
Health Benefits | 6723
Retirement  Benefits
Unemployment Insurance
Other Salary/Benefit Expenses | 6540
sub-total Personnel Expenses:
Taxes, [NAME] and Permits
Real Estate Taxes | 6710
[NAME], Licenses, and Permits | 6719
sub-total Taxes, License and Permit Expenses:
Insurance
Property and Liability Insurance | 6720
Fidelity Bond Insurance | 6721
Other Insurance | 6729
sub-total Insurance Expenses:
Utilities
Electricity | 6450
Water | 6451
Gas | 6452
Sewer | 6453
Trash Removal | 6525
sub-total Utilities Expenses:
Maintenance
Cleaning Supplies | 6515
Contract Cleaning | 6517
Pest Control | 6519
Security | 6533
Fire Alarm Expense  (incl. phone) | 6534
Grounds, Repairs & Maintenance | 6537
Grounds, Repairs & Maintenance Supplies | 6541
Elevator Maintenance (incl. phone) | 6545
Plumbing, Electrical, HVAC Maintenance | 6546
Painting and Decorating | 6561
Exterior  Paining | 6565
Furniture
Window Covering & Carpeting | 6566
Vehicle and [NAME]Operation and Repairs | 6571
Cable/Tools
Miscellaneous Operating & Maintenance | 6590
sub-total [NAME]:
Services
Social Service Coordination*
sub-total Services Expenses:
Total Operating Expenses
Reserves, Debt Service, & Fees |  | Total Annual | Per Unit Cost
Reserves
Operating Reserve Deposit
Replacement Reserve Deposit
Other: _________________________
sub-total Reserve Deposits:
Debt Service
Lender:___________________________
Lender:___________________________
Lender:___________________________
sub-total Debt Service:
Other Fees
Deferred Developer Fee
Partnership/Asset Management Fee**
City of Oakland Monitoring Fee
sub-total Other Fees:
* Social Service Coordination is an eligible operating cost.  Direct Social Service provision cannot be funded by operations unless it is a requirement of another funding source.
** Review the Developer Fee Guidelines for allowable Partnership and Asset Management Fees.
Spreadsheet: 555148d1515457125-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-2-
Sheet: Tournament 2

 |  |  | Tournament 2
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  | x | x | x
Spreadsheet: 455919d1460565928-conditional-fromatting-cgs2100-27568-grade-spreadsheet
Sheet: CGS2100

Due Date | Due Date2 | Activity | Points | Point Earned
Week 1 | 2016-02-15 00:00:00 | First Day of Class
Week 1 | 2016-02-19 00:00:00 | Introduction | 10 | 10
Week 2 | 2016-02-26 00:00:00 | Calendar | 50 | 50
Week 2 | 2016-02-26 00:00:00 | Class [NAME] | 50 | 50 |  | Total Class Points:
Week 2 | 2016-02-26 00:00:00 | Goals | 50 | 38 |  | Total Points Possible as of today:
Week 2 | 2016-02-26 00:00:00 | Goals | 10 | 10 |  | My Points:
Week 3 | 2016-03-04 00:00:00 | Webpage & LinkedIn | 50 | 50 |  | Class Grade:
Week 3 | 2016-03-04 00:00:00 | Personal Branding | 50 | 50
Week 3 | 2016-03-04 00:00:00 | Resume and Cover Letter | 50 | 50
Week 5 | 2016-03-18 00:00:00 | Research Major | 25 | 25
Week 5 | 2016-03-18 00:00:00 | Major | 10 | 10
Week 6 | 2016-03-25 00:00:00 | Budget/Ledger | 50 | 42
Week 6 | 2016-03-25 00:00:00 | Budget/Ledger | 50 | 50
Week 7 | 2016-04-01 00:00:00 | Address Book | 50 | 50
Week 7 | 2016-04-01 00:00:00 | Address Book | 50 | 50
Week 7 | 2016-04-01 00:00:00 | Spring Break
Week 7 | 2016-04-01 00:00:00 | GPA | 50 | 41
Week 8 | 2016-04-08 00:00:00 | DVD Database | 25
Week 8 | 2016-04-08 00:00:00 | Create your own database | 50
Week 8 | 2016-04-08 00:00:00 | Tracking Spreadsheet | 50
Week 8 | 2016-04-08 00:00:00 | Spreadsheet Advertisement | 50
Week 8.5 | 2016-04-15 00:00:00 | Update a Project | 50
Week 9 | 2016-04-22 00:00:00 | Mail Merge | 50
Week 10 | 2016-04-28 00:00:00 | Final: Goals | 50
Week 10 | 2016-04-28 00:00:00 | Final: Goals | 10
Spreadsheet: 760522d1640266398-lookup-with-multiple-criteria-book2
Sheet: Sheet1

Grp size min | [NAME] | [NAME] factor | Edn.
1 | 1 | 1.461 | 3 | Edition | 3
1 | 1 | 1.461 | 4 | Group Size | 4
1 | 1 | 1.461 | 7 | Result
1 | 1 | 1.461 | 8
2 | 4 | 1.2 | 3
2 | 4 | 1.2 | 4
2 | 4 | 1.2 | 7
2 | 4 | 1.2 | 8
Spreadsheet: 644926d1570811157-freight-cost-calculation-based-on-weight-and-distance-sample-freight-analysis
Sheet: Input &required output

OID | Quote_Weight | Distance(In Miles) | Cost -output required without fuel surcharge | Cost Output -with fuel surcharge
3634 | 138 | 74.666448
3676 | 368 | 1052.471069
3718 | 270 | 732.056664
3760 | 213 | 279.1653
3802 | 100 | 1512
3886 | 348 | 2142.846402
3928 | 333 | 437.544117
Spreadsheet: andy_zipper__179__DYNEGY-ICE VOL Apr26
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-26-01 thru Apr-26-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-26-01 | 153580361 |  | Bought | NG [NAME], ID, GDD | [NAME] (NY) | Next Day Gas | Apr-27-01 | Apr-27-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 7500 | Daily | 7500 | MMBtus | Pimenov, V
Apr-26-01 | 110358497 |  | Bought | NG [NAME], ID, GDD | [NAME] (NY) | Next Day Gas | Apr-27-01 | Apr-27-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 2500 | Daily | 2500 | MMBtus | Pimenov, V
Apr-26-01 | 207729940 |  | Bought | NG [NAME], ID, GDD | [NAME] (NY) | Next Day Gas | Apr-27-01 | Apr-27-01 |  |  |  | AEP Energy Services, Inc. | 0 | USD / MMBtu | 2500 | Daily | 2500 | MMBtus | Pimenov, V
Apr-26-01 | 166645635 |  | Sold | NG Fin BS, LD1 for IF | [NAME] (NY) | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | Mirant Americas Energy Marketing, LP | 1.59 | USD / MMBtu | 10000 | Daily | 1510000 | MMBtus | Mckay, B
Apr-26-01 | 450675317 |  | Sold | NG Fin BS, LD1 for IF | [NAME] (NY) | Nov01-Mar02 | Nov-01-01 | Mar-31-02 |  |  |  | Reliant Energy Services, Inc. | 1.59 | USD / MMBtu | 2500 | Daily | 377500 | MMBtus | Mckay, B
Apr-26-01 | 100245237 |  | Sold | NG Fin, FP for LD1 | [NAME] | Cal 02 | Jan-01-02 | Dec-31-02 |  |  |  | AEP Energy Services, Inc. | 4.83 | USD / MMBtu | 5000 | Daily | 1825000 | MMBtus | [NAME], J
Apr-26-01  Deals
Spreadsheet: 139673d1328375616-dates-for-4-day-working-week-help-4-week-calander
Sheet: Sheet1

0 | Product | Date | Capacity | Demand | Condor Demand | Total Condor Demand
1 | A | 2012-01-02 00:00:00
2 | B | 2012-01-02 00:00:00
3 | C | 2012-01-02 00:00:00 |  |  |  | 0
4 | D | 2012-01-02 00:00:00
5 | E | 2012-01-02 00:00:00
6 | F | 2012-01-02 00:00:00
7 | G | 2012-01-02 00:00:00
8 | Other | 2012-01-02 00:00:00
1 | A | 2012-01-03 00:00:00
2 | B | 2012-01-03 00:00:00
3 | C | 2012-01-03 00:00:00 |  |  |  | 0
4 | D | 2012-01-03 00:00:00
5 | E | 2012-01-03 00:00:00
6 | F | 2012-01-03 00:00:00
7 | G | 2012-01-03 00:00:00
8 | Other | 2012-01-03 00:00:00
1 | A | 2012-01-04 00:00:00
2 | B | 2012-01-04 00:00:00
3 | C | 2012-01-04 00:00:00 |  |  |  | 0
4 | D | 2012-01-04 00:00:00
5 | E | 2012-01-04 00:00:00
6 | F | 2012-01-04 00:00:00
7 | G | 2012-01-04 00:00:00
8 | Other | 2012-01-04 00:00:00
1 | A | 2012-01-05 00:00:00
2 | B | 2012-01-05 00:00:00
3 | C | 2012-01-05 00:00:00 |  |  |  | 0
4 | D | 2012-01-05 00:00:00
5 | E | 2012-01-05 00:00:00
6 | F | 2012-01-05 00:00:00
7 | G | 2012-01-05 00:00:00
8 | Other | 2012-01-05 00:00:00 |  |  |  |  |  | 2012-01-05 00:00:00 | THURSDAY
1 | A | 2012-01-09 00:00:00 |  |  |  |  |  |  | Monday
2 | B | 2012-01-09 00:00:00
3 | C | 2012-01-09 00:00:00 |  |  |  | 0
4 | D | 2012-01-09 00:00:00
5 | E | 2012-01-09 00:00:00
6 | F | 2012-01-09 00:00:00
7 | G | 2012-01-09 00:00:00
8 | Other | 2012-01-09 00:00:00
1 | A | 2012-01-10 00:00:00
2 | B | 2012-01-10 00:00:00
3 | C | 2012-01-10 00:00:00 |  |  |  | 0
4 | D | 2012-01-10 00:00:00
5 | E | 2012-01-10 00:00:00
6 | F | 2012-01-10 00:00:00
7 | G | 2012-01-10 00:00:00
8 | Other | 2012-01-10 00:00:00
1 | A | 2012-01-11 00:00:00
2 | B | 2012-01-11 00:00:00
3 | C | 2012-01-11 00:00:00 |  |  |  | 0
4 | D | 2012-01-11 00:00:00
5 | E | 2012-01-11 00:00:00
6 | F | 2012-01-11 00:00:00
7 | G | 2012-01-11 00:00:00
8 | Other | 2012-01-11 00:00:00
1 | A | 2012-01-12 00:00:00
2 | B | 2012-01-12 00:00:00
3 | C | 2012-01-12 00:00:00 |  |  |  | 0
4 | D | 2012-01-12 00:00:00
5 | E | 2012-01-12 00:00:00
6 | F | 2012-01-12 00:00:00
7 | G | 2012-01-12 00:00:00
8 | Other | 2012-01-12 00:00:00
1 | A | 2012-01-16 00:00:00
2 | B | 2012-01-16 00:00:00
3 | C | 2012-01-16 00:00:00 |  |  |  | 0
4 | D | 2012-01-16 00:00:00
5 | E | 2012-01-16 00:00:00
6 | F | 2012-01-16 00:00:00
7 | G | 2012-01-16 00:00:00
8 | Other | 2012-01-16 00:00:00
1 | A | 2012-01-17 00:00:00
2 | B | 2012-01-17 00:00:00
3 | C | 2012-01-17 00:00:00 |  |  |  | 0
4 | D | 2012-01-17 00:00:00
5 | E | 2012-01-17 00:00:00
6 | F | 2012-01-17 00:00:00
7 | G | 2012-01-17 00:00:00
8 | Other | 2012-01-17 00:00:00
1 | A | 2012-01-18 00:00:00
2 | B | 2012-01-18 00:00:00
3 | C | 2012-01-18 00:00:00 |  |  |  | 0
4 | D | 2012-01-18 00:00:00
5 | E | 2012-01-18 00:00:00
6 | F | 2012-01-18 00:00:00
7 | G | 2012-01-18 00:00:00
8 | Other | 2012-01-18 00:00:00
1 | A | 2012-01-19 00:00:00
2 | B | 2012-01-19 00:00:00
3 | C | 2012-01-19 00:00:00 |  |  |  | 0
4 | D | 2012-01-19 00:00:00
5 | E | 2012-01-19 00:00:00
6 | F | 2012-01-19 00:00:00
7 | G | 2012-01-19 00:00:00
8 | Other | 2012-01-19 00:00:00