tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0d02c194-397f-497c-af70-0b070c06f4ad
Sheet: Sheet1

RPM | PSI | GPM | horsepower | torque
700 | 1800 | 2 | 2.100350058343057 | 15.75862643773962
800 | 1800 | 3 | 3.150525087514586 | 20.68319719953326
900 | 1800 | 4 | 4.200700116686114 | 24.51341890315053
1000 | 1800 | 5 | 5.250875145857643 | 27.57759626604434
1100 | 1800 | 6 | 6.301050175029172 | 30.08465047204837
1200 | 1800 | 7 | 7.3512252042007 | 32.17386231038507
1300 | 1800 | 8 | 8.401400233372229 | 33.9416569428238
1400 | 1800 | 9 | 9.451575262543757 | 35.45690948491415
1500 | 1800 | 10 | 10.50175029171529 | 36.77012835472578
1600 | 1800 | 11 | 11.55192532088681 | 37.91919486581097
1700 | 1800 | 12 | 12.60210035005834 | 38.93307708147437
1800 | 1800 | 13 | 13.65227537922987 | 39.83430571761961
1900 |  |  | 0 | 0
2000 |  |  | 0 | 0
2100 |  |  | 0 | 0
2200 |  |  | 0 | 0
2300 |  |  | 0 | 0
2400 |  |  | 0 | 0
2500 |  |  | 0 | 0
Horsepower = (psi x gpm)/1714
Torque = (hp x 5252)/rpm
 |  | Cub name: | fake
 |  | Cub Owner: | phoney
 |  | Date: | today
Spreadsheet: 816057d1675343037-find-max-date-with-three-conditions-met-find-max-date
Sheet: Sheet1

Branch Code | Transaction Date | Type | Part Number
1111 | 2022-12-21 00:00:00 | Ship Out | 11111111
1111 | 2022-12-21 00:00:00 | Receive In | 11111111
1111 | 2022-12-21 00:00:00 | Ship Out | 11112222
2222 | 2022-12-21 00:00:00 | Ship Out | 22222222
2222 | 2022-12-21 00:00:00 | Ship Out | 22222222
2222 | 2022-12-21 00:00:00 | Ship Out | 22222222
2222 | 2022-12-21 00:00:00 | Receive In | 22222222
2222 | 2022-12-21 00:00:00 | Receive In | 22222222
2222 | 2022-12-21 00:00:00 | Receive In | 22222222
2222 |  | Receive In | 22222222
2222 |  | Receive In | 22222222
2222 |  | Receive In | 22222222
2222 | 2022-12-22 00:00:00 | Ship Out | 22222222
2222 | 2022-12-22 00:00:00 | Ship Out | 22222222
Spreadsheet: 204583d1357581684-copying-columns-of-data-sample
Sheet: 2007-2010

Customers | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | ……… | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
A
B
C
D
E
F
G
H
I
J
K
Spreadsheet: 161109d1339418471-conditional-formatting-and-data-valiation-2007-tester-example2
Sheet: Check Example

PK | PK
String (12) | Number | String (12) | Number | String (12) | Number | String (25) | String (3) | String (12) | String (3) | String (3) | String (2) | String (2) | Date (YYYYMMDD) | Number | Date (YYYYMMDD) | Number | Date (YYYYMMDD)
 |  |  |  |  |  |  |  |  |  |  |  |  | Need to be date YYYYMMDD | [NAME] to source file minus ':' (colons) | Need to be date YYYYMMDD | [NAME] to source file minus ':' (colons) | Need to be date YYYYMMDD
12 |  | 12 |  | 12 |  | 25 | 3 | 12 | 3 | 3 | 2 | 2
Interface .csv produced after Change
14 |  | 7 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 2 | 2
TMVMCU | TMLDNM | TMNMCU | TMORGN | TMMCUX | TMANCC | TMCTY1 | [NAME] | TMADDZ | TMCTR | TMZON | TMLDTY | TMLDLS | TMLOAD_D | TMTMLS | TMPPDJ_D | TMPMDT | TMADDJ_D
GB102701000000 | 4615 | GB10270 | 535996 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 51400 | 20120522 | 51400
GB10270 | 4640 | GB10270 | 535996 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 65030 | 20120522 | 65030
GB15180 | 4887 | GB15180 | 535943 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 30000 | 20120522 | 30000 | 20120522
GB10200 | 4622 | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 81652 | 20120522 | 81652
GB10200 | 4601 | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 53219 | 20120522 | 53219 | 20120522
GB10200 | 4598 | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 65701 | 20120522 | 65701 | 20120522
GB10800 | 4557 | GB10800 | 535988 |  |  |  |  |  |  |  | CS | 80 | 20120521 | 220440 | 20120521 | 220440
GB10800 | 4771 | GB10800 | 535988 |  |  |  |  |  |  |  | ST | 80 | 20120523 | 53057 | 20120523 | 53057
GB10300 | 4554 | GB10300 | 535979 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 51026 | 20120522 | 51026
GB10300 | 4582 | GB10300 | 535979 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 53911 | 20120522 | 53911
GB10270 | 4617 | GB10270 | 535996 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 72049 | 20120522 | 72049
GB10200 | 4936 | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120522 | 74500 | 20120522 | 74500 | 20120522
GB10700 | 6300 | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 210559 | 20120523 | 210559 | 20120523
GB10700 | 6307 | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 0 | 20120523 | 0 | 20120523
GB10700 | 6596 | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120524 | 70000 | 20120524 | 70000 | 20120524
GB10700 | 5875 | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 120500 | 20120523 | 120500
GB10700 | 6272 | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 200500 | 20120523 | 200500 | 20120523
GB10700 | 6274 | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 192500 | 20120523 | 192500 | 20120523
GB10200 | 5785 | GB10200 | 535977 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 44511 | 20120523 | 44511 | 20120523
GB10700 | 6285 | GB10700 | 535986 |  |  |  |  |  |  |  | CS | 80 | 20120523 | 0 | 20120523 | 0 | 20120523
Spreadsheet: 887290d1737526812-schedule-calendar-cover-school-copy-of-absence-timetable-v1
Sheet: So

Period | Time | Monday | Tuesday | Wednesday | Thursday | Friday
 | 0735-0800 | Registration
Period 1 | 0800 -0830 |  |  |  |  | ALN meeting
 | 0830-0900 |  |  | Touch base with [NAME] | 6.4 Rafael- Lit
Period 2 | 0900-0930 | 6.4 Rafael- Lit | 6.4 Rafael- Maths | 6.2 Alex- IPC |  | 6.2 Alex- Maths
 | 0930-1000
 | 1000-1030 | Duty No.5 Duty No.5 Duty No.5
Period 3 | 1030-1100 | (Alex- Counselling social skills) | 6.2 Alex- Lit | 6.2 Alex- Lit | 6.4 Rafael- Maths | 6.2 Alex- IPC
 | 1100-1130
Period 4 | 11:30-12:00 | 6.2 Alex- Music | 6.4 [NAME] | 6.4 Rafael- Lit | 6.2 Alex- Maths
 | 12:00-12:30
Period 5 | 12:30-13:00 | Lunch
 | 1300-1330
Period 6 | 1330-1400 | 6.4 Rafael- Maths |  | 6.4 Rafael- IC
 | 1400-1430 |  |  |  | 6.2 Alex- IPC | 6.4 Rafael- IC
Period 7 | 1430-1500
 | 1500-1515 | Bus Loading/Dismissal
 | 1500-1530
CCAs | 1515-1615 |  |  |  |  | 18 hrs
Spreadsheet: richard_shapiro__32401__Lisa - EIM Budget
Sheet: Scenario 3

Cost Center Owner
Cost Center Number
 | Please use this form only for Outside Services
 | Scenario 3:  How would you implement a 40% reduction from Scenario 1?
 | Retainers and Identified Needs
 | [NAME] | Activity/Region | 2002 Est. $
 | Akin Gump | International Trade Retainer | 198000
 |  |  |  | Target
 |  | Total:
 | [NAME]
 | [NAME] | Activity/Region | 2002 Est. $
 | Akin Gump | Steel Section 201 - Lobbying at the Administration Level | 0
 |  |  |  | Target
 |  | Total:
Spreadsheet: 878488d1725569526-how-to-sum-amounts-by-2-criteria-invoice-and-yes-test
Sheet: Sheet1

Invoice # | Line Amount | Include | Invoice Total | Included Total
12589 | 50 | Yes |  | 125
12589 | 75 | Yes
12589 | 20 | No
12590 | 100 | Yes |  | 100
12591 | 60 | Yes |  | 85
12591 | 25 | Yes
I know how to total by invoice number, but I am looking to add another criteria of only lines marked 'Yes'.
The answers I am looking for are in column E.
Spreadsheet: benjamin_rogers__944__PJMPosMgr
Sheet: Summary

Total |  | Cash Total |  | Term Total
Cash |  |  |  |  | Cash |  |  |  |  | Cash |  |  |  |  | Cash |  |  |  |  | Cash
Zone A | Net Position | Curve Shift | New Deals |  | Zone G | Net Position | Curve Shift | New Deals |  | Zone J | Net Position | Curve Shift | New Deals |  | Nepool | Net Position | Curve Shift | New Deals |  | PJM | Net Position | Curve Shift | New Deals
 | Mw's | $ | $ |  |  | Mw's | $ | $ |  |  | Mw's | $ | $ |  |  | Mw's | $ | $ |  |  | Mw's | $ | $
Term |  |  |  |  | Term |  |  |  |  | Term |  |  |  |  | Term |  |  |  |  | Term
Zone A | Net Position | Curve Shift | New Deals |  | Zone G | Net Position | Curve Shift | New Deals |  | Zone J | Net Position | Curve Shift | New Deals |  | Nepool | Net Position | Curve Shift | New Deals |  | PJM | Net Position | Curve Shift | New Deals
 | Mw's | $ | $ |  |  | Mw's | $ | $ |  |  | Mw's | $ | $ |  |  | Mw's | $ | $ |  |  | Mw's | $ | $
Spreadsheet: 106217d1303397152-excel-2007-data-entry-spreadsheet-h-and-s-doc-reference-numbers
Sheet: LOOKUPS

REF |  | MONTH |  | YEAR |  | DEPT |  | CATEGORY
1 |  | 1 |  | 9 |  | ECD |  | PO
2 |  | 2 |  | 10 |  | AU |  | PR
3 |  | 3 |  | 11 |  | SO |  | RA
4 |  | 4 |  | 12 |  |  |  | SWP
5 |  | 5 |  | 13 |  |  |  | IN
6 |  | 6 |  | 14 |  |  |  | SA
7 |  | 7 |  |  |  |  |  | SI
8 |  | 8 |  |  |  |  |  | CP
9 |  | 9
10 |  | 10
11 |  | 11
12 |  | 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
Spreadsheet: 105527d1302845981-this-could-be-a-more-involved-vba-task-i-am-not-sure-though-example
Sheet: WS

DeeDee Home Décor Incorporated |  |  |  |  |  |  | B/S | I/S | S/E
End of Period Worksheet
For the Year Ended December 31, 2010
 | Unadjusted |  |  |  | Adjusted
Account Title | Trial Balance |  | Adjustments |  | Trial Balance
 | DR | CR | DR | CR | DR | CR
Cash | 360000 | 0 |  |  | 360000
Accounts Receivable | 738500 | 0 |  |  | 738500
Allowance for Doubtful Accounts | 0 | 130000 |  |  |  | 130000
Interest Receivable | 0
Merchandise Inventory | 572500 | 0 |  |  | 572500
LIFO Reserve |  | 40000 |  |  |  | 40000
Prepaid Insurance | 0 | 0
Prepaid Advertising | 0
Prepaid Rent | 16000 |  |  |  | 16000
Office Supplies | 5000 | 0 |  |  | 5000
Note Receivable | 172000 |  |  |  | 172000
Available for Sale Securities | 315000 |  |  |  | 315000
Office Building | 3500000 |  |  |  | 3500000
Accumulated Depreciation - Office Building |  | 75000 |  |  |  | 75000
Storage Building | 1250000 |  |  |  | 1250000
Land | 650000 |  |  |  | 650000
Leasehold Improvements | 468000 | 0 |  |  | 468000
Accumulated Depreciation - Leasehold Improvements | 0 | 62400 |  |  |  | 62400
Office Equipment | 190000 | 0 |  |  | 190000
Accumulated Depreciation - Office Equipment | 0 | 9500 |  |  |  | 9500
Patent | 210000 |  |  |  | 210000
Accounts Payable | 0 | 366700 |  |  |  | 366700
Salaries Payable | 0 | 0
Interest Payable | 0 | 0
Income Tax Payable
Unearned Revenue | 0
Loan Payable - Onstar Bank |  | 1260000 |  |  |  | 1260000
Loan Payable - Coldstar Bank | 0 | 1580000 |  |  |  | 1580000
Common Stock | 0 | 2400000 |  |  |  | 2400000
Additional Paid in Capital |  | 0
[NAME] | 0 | 1279420 |  |  |  | 1279420
Accumulated Other Comprehensive Income |  | 85000 |  |  |  | 85000
Dividends | 200000 | 0 |  |  | 200000
Sales | 0 | 4280150 |  |  |  | 4280150
[NAME] | 21700 | 0 |  |  | 21700
Sales Discounts | 17200 | 0 |  |  | 17200
Cost of Goods Sold | 1257200 | 0 |  |  | 1257200
Sales Salaries Expense | 676400 | 0 |  |  | 676400
Advertising Expense | 104000 | 0 |  |  | 104000
Depreciation Expense - Leasehold Improvements | 0 | 0
Leasing Expense - Stores | 244000 |  |  |  | 244000
Miscellaneous Selling Expense | 16950 | 0 |  |  | 16950
Office Salaries Expense | 434000 | 0 |  |  | 434000
Rent Expense | 60000 | 0 |  |  | 60000
Insurance Expense | 0 | 0
Depreciation Expense - Office Equipment | 0 | 0
Office Supplies Expense | 17500 | 0 |  |  | 17500
[NAME] Expense | 9220 | 0 |  |  | 9220
Rent Revenue | 0 | 48000 |  |  |  | 48000
Interest Revenue on Note Receivable
Dividend Revenue on AFS Securities |  | 29000 |  |  |  | 29000
Interest Expense | 0 | 0
Bad Debt Expense | 140000 | 0 |  |  | 140000
Amortization Expense | 0
Income Tax Expense | 0
Totals: | 11645170 | 11645170
Spreadsheet: 696490d1600853829-cashflow-formula-needed-for-partial-paymen-base-on-date-book2
Sheet: CF

 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
A Sponser
B Sponser
C Sponser
D Sponser
Spreadsheet: 844114f2-ceee-4fce-a0c0-a4a6485d2ec1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6724 | 50265 | [NAME] | [NAME] | PAN | 0 | 00:28:26 | 00:01:38 | 00:47:36 | 00:00:00 | 00:14:27 | 1 | 01:32:09
Spreadsheet: 220377d1363134219-copy-data-from-other-sheets-by-typing-in-unique-identifier-from-them-example
Sheet: Sandwich

FOOD | MAIN INGREDIENT | WEIGHT | UNIQUE CODE | PRICE
Ham and pickle | Ham | 1.4 | Sandwich01 | 2.2
Cheese | Cheese | 2 | Sandwich02 | 2.4
Chicken | Chicken | 3.1 | Sandwich03 | 3
Spreadsheet: 775866d1649354392-rolling-month-sum-trouble-shoot-book-1-for-testing
Sheet: Sheet1

Date |  | Occurence |  | Rolling month sum
2000-01-01 00:00:00 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  |  | 5
 |  | 1
 |  | 1
 |  | 1
 |  | 1 | 4
Spreadsheet: richard_sanders__31757__Claim Summary
Sheet: Schedule 5

 |  | Property Damage Summary |  |  |  |  |  | SCHEDULE 5
 |  | Mechanical [NAME], June 14, 2000 - Unit #1
Item |  | Vendor/Description of Activity |  |  |  |  |  |  | Claim | Adjustments | Estimate
11 | Enron North America
 |  | On-site expenses and/or extended support for Virgo, [NAME], etc.
 |  | Invoice #88 |  | Power Systems Mfg. |  |  | 15000
 |  |  | [NAME] Month@ |  |  |  | 4096.68 |  |  | 0
 |  |  | Travel Expenses
 |  | Invoice #99 |  | Power Systems Mfg. |  |  | 30000
 |  |  | [NAME] |  |  |  | 3056.42 |  |  | 0
 |  |  | Travel Expenses
 | On monthly, retainer Involvement needs to be qualified as to full time on project & Retainer arrangements.
12 | [NAME]
 |  | Technical guidance |  |  |  |  |  |  | 1028 | 0
13 | G.L.C. Consulting |  |  | Technical guidance/Loss Summary
 | [NAME] |  |  |  | Rate - $85 ST / $103 OT
 | W/E | ST | OT | ST$ | OT$ | WAGES | EXPENSES | WEEKLY TL
 | 6/25 | 40 | 30 |  |  | 6490 | 1687.33
 | 7/2 | 40 | 34 |  |  | 6902 | 576.13
 | 7/9 | 40 | 30 |  |  | 6490 | 519.79
 | 7/16 | 40 | 31 |  |  | 6593 | 2899.72
 | 7/23 | 40 | 46 |  |  | 8138 | 373.33
 | 7/30 | 40 | 14 |  |  | 4842 | 5591.12
 | 8/6 | 40 | 0 |  |  | 3920 | 223.91
 | 8/13 | 40 | 0 |  |  | 3920 | 297.3
 | 8/20 | 40 | 0 |  |  | 3920 | 287.6
 | 8/27 | 40 | 0 |  |  | 3920 | 1319.09
 | 9/3 | 40 | 0 |  |  | 3920 | 3907.84
 | 9/10 | 40 | 0 |  |  | 3920 | 363
 | 9/17 | 40 | 0 |  |  | 3920 | 95.09
 | 9/24 | 40 | 0 |  |  | 3920 | 1056.05
 | 10/1 | 40 | 0 |  |  | 3920 | 1052.97
 | 10/8 | 40 | 0 |  |  | 3920 | 890.29
 | Gand Totals
 | 50% of all expenses - deducted as other job responsiblities involved
 | [NAME] |  |  |  |  | Rate - $80 ST / $98 OT
 | W/E | ST | OT | ST$ | OT$ | WAGES | EXPENSES | WEEKLY TL
 | 6/25 | 40 | 15 |  |  |  | 790.38
 | 7/2 | 40 | 41 |  |  |  | 350
 | 7/9 | 40 | 19 |  |  |  | 350
 | 7/16 | 40 | 28 |  |  |  | 350
 | 7/23 | 40 | 6 |  |  |  | 300
 | 7/30 | 40 | 0 |  |  |  | 587.31
 | Total
 | 50% of all expenses - deducted as other job responsiblities involved
 | Gand Totals
 |  |  | Invoice #023 |  |  |  |  | 56892.35
 |  |  | Invoice #022 |  |  |  |  | 44627.66
 |  |  | To be Invoiced |  |  |  |  | 30885.24
 |  |  |  |  |  | 50% of [NAME] withdrawn, 8/6 to 10/8 |  | -24346.57
14 | [NAME] Employee |  |  |  |  |  | Withdrawn | 18001 | 0
 |  | Technical guidance
15 | [NAME] |  |  |  |  |  |  |  | 3900.88 | 0
 |  | [NAME] ([NAME])
16 | [NAME] (Gas [NAME]. Serv.) |  |  |  |  |  |  |  | 30069.75 | 0
 |  | Consulting on casing leaks, failure analysis, technical guidance
17 | [NAME] |  |  |  |  |  | Withdrawn | 10967.7 | 0
 |  | EECC 3rd Party QA - Oilfield Materials Consultants - OMC @ Preco -Houston
18 | Swame |  | 6/16/00 to 8/04/00 |  |  |  | Withdrawn | 10703.77 | 0 | 0
 |  | Southwest Research - Failure anaalysis
19 | [NAME] |  |  |  |  |  |  |  | 680 | 0
 |  | EECC QA - Contract Labor
20 | Shengli (Victor) [NAME] |  |  |  |  |  |  |  | 3817
 |  | EECC Performance Engineer |  |  |  | No Support
Spreadsheet: barry_tycholiz__873__3Q YTD Origin West Gas
Sheet: Summary

West Gas
By Team
Originator |  | Commodity |  | Team |  | Revised Total |  | %Total | Original Total | [NAME]
Tycholiz |  | Gas |  | West Gas |  | 22032148 |  |  | 22032148
Whitt |  | Gas |  | West Gas |  | 11726562 |  |  | 11726562
Lucci |  | Gas |  | West Gas |  | 7003877 |  |  | 7003878
Miller |  | Gas |  | West Gas |  | 4124771 |  |  | 4124771
Harrison |  | Gas |  | West Gas |  | 2257911 |  |  | 2257911
Ward |  | Gas |  | West Gas |  | 2097474
Fuller |  | Gas |  | West Gas |  | 313490 |  |  | 313490
Staab |  | Gas |  | West Gas |  | 14969 |  |  | 14969
Total
Spreadsheet: 828907d1683791538-for-each-record-matching-instance-where-date-a-is-after-date-b-book1-138-aligw
Sheet: Sheet3 (2)

 | DomesticE | IF Intl. after domstic |  | International Hith
ID | Arrival Date & Time |  |  | ID | Arrival Date & Time |  |  | AliGW |  | need matching Clients who’s Domestic arrival date is after their Intl. arrival date
4960 | 2023-04-17 12:26:00 |  |  | 4960 | 2023-04-17 16:30:00
7361 | 2023-01-10 18:45:00 |  |  | 7361 | 2023-01-18 18:00:00 |  |  | 14147
9537 | 2023-02-23 22:44:00 |  |  | 9537 | 2023-03-07 17:42:00 |  |  | 23732
10978 | 2023-04-05 06:34:00 |  |  | 10978 |  |  |  | 26177
14147 | 2023-01-14 11:18:00 |  |  | 14147 | 2023-01-09 17:45:00 |  |  | 37590
18816 | 2023-04-16 19:11:00 |  |  | 18816 | 2023-04-27 12:00:00
23732 | 2023-04-07 20:22:00 |  |  | 23732
26177 | 2023-02-04 00:40:00 |  |  | 26177 | 2023-02-22 17:50:00
26177 | 2023-03-03 07:32:00 |  |  | 26177 | 2023-03-17 16:07:00
26177 | 2023-03-23 17:24:00 |  |  | 34074 | 2023-01-09 17:30:00
34074 | 2023-01-04 07:17:00 |  |  | 34074 | 2023-01-23 07:40:00
34074 | 2023-01-22 19:02:00 |  |  | 37590 | 2023-02-15 14:56:00
37590 | 2023-02-09 18:46:00 |  |  | 38524 | 2023-01-17 15:00:00
Spreadsheet: 808712d1670596583-counting-rows-between-specific-events-book1-27-ans
Sheet: Sheet1

WHEEL 1 | WHEEL 2 | WHEEL 3 |  | Delay |  |  | DELAY | TIMES
B | G | R |  |  |  |  | 0 | 0
G | B | R |  |  |  |  | 1 | 2
B | B | B |  |  |  |  | 2 | 0
B | R | R |  |  |  |  | 3 | 0
R | B | G |  |  |  |  | 4 | 0
B | G | B |  |  |  |  | 5 | 0
B | S | R |  |  |  |  | 6 | 0
S | B | B |  |  |  |  | 7 | 0
S | B | R |  |  |  |  | 8 | 0
R | G | R |  |  |  |  | 9 | 0
R | G | G |  |  |  |  | 10 | 0
R | G | R |  |  |  |  | 11 | 0
G | R | R |  |  |  |  | 12 | 0
B | S | S |  |  |  |  | 13 | 0
B | G | R |  |  |  |  | 14 | 0
G | B | B |  |  |  |  | 15 | 0
B | R | G |  |  |  |  | 16 | 1
S | R | B |  |  |  |  | 17 | 0
R | R | B |  |  |  |  | 18 | 0
B | B | B |  |  |  |  | 19 | 0
R | R | B |  |  |  |  | 20 | 0
G | G | G |  |  |  |  | 21 | 0
B | G | G |  |  |  |  | 22 | 0
R | R | R |  |  |  |  | 23 | 0
B | G | R |  |  |  |  | 24 | 0
G | R | R |  |  |  |  | 25 | 0
S | R | R |  |  |  |  | 26 | 0
B | B | R |  |  |  |  | 27 | 0
R | G | G |  |  |  |  | 28 | 0
R | G | R |  |  |  |  | 29 | 0
G | R | G |  |  |  |  | 30 | 0
B | R | R
G | B | R
Spreadsheet: 02f1e363-aa91-4053-a0d4-58024e175d05
Sheet: Sheet1

NAACCR | [NAME] | caBIG | CDISC | HITSP | NCHS/CDC/HL7 | U.S. CENSUS & NHANES | Canadian Census
Code | Value | Code | code | Code | Code | Code | Code
1 | Male | Male | M | Male | M | 1 | Male
2 | Female | Female | F | Female | F | 2 | Female
3 | Other (hermaphrodite) |  | UN | Indeterminate | O
 |  |  |  |  | A
4 | Transsexual
9 | Not stated/Unknown | Unknown | U |  | U
 |  |  |  |  | N
Spreadsheet: jason_wolfe__13337__Simulation Teams
Sheet: Sheet1

NomLogic Simulation Teams
East |  |  | West |  |  | Central
[NAME] | TRCO |  | [NAME] | SCAL, PGEN |  | Mark | ANR
Meredith | TRCO |  | [NAME] | SCAL, PGEN |  | [NAME] | ANR
[NAME] | TRCO
 |  |  |  |  |  | [NAME] | TRKL, PEPL
[NAME] | TETC |  |  |  |  | West | TRKL, PEPL
[NAME] | TETC
Victor | Trader |  | [NAME] | Trader |  | [NAME] | Trader
Spreadsheet: phillip_m_love__30150__9907_OA
Sheet: BUG_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
REGION: Boston Gas
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 9346810 | 21772141
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 16101572 | 41121828
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 25448382 | 62893969
 | Purchases:
6 |  | 3rd Party / Inter Enron | -6719000 | -13748694
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -21579459 | -53470940
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 433218 | 1012453
 | Total Purchases: |  | -27865241 | -66207181
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 13702 | 32748
14 |  | Cash Out | 0 | 0
15 |  | Cash In | -33900 | -98290
16 |  | Synthetic Storage | 0 | -2077
 | Total Imbalances: |  | -20198 | -67619
 | Storage:
17 |  | Injection (Sales to Stg) | 2371256 | 5979653
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 2371256 | 5979653
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 65801 | 149039.265
23 | Fuel: |  | -433218 | -1012453
 | Transport Expense:
24 |  | Commodity | 0 | -512941
25 |  | Demand | 0 | 186651
 | Total Transport Expense: |  | 0 | -326290
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 6564288.632400796
31 |  | Prior Month Book Balance | 0 | -6075073
 |  | Total MTM Income | 0 | 489215.6324007958
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | -567594
34 |  | Originations | 0 | 130708
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH