tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889065d1739761744-if-countif-and-sumif-dosya
Sheet: Y table

FINI | Operation | Column1 | Column2 | Column3 | Column4
A1
A2
A3 | Drilling
A4
A5 | Drilling
A6 | Drilling
B1 | Drilling
B2 | Drilling
B3 | Drilling
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 184558 | 185282
2 | 157855 | 157662
3 | 127105 | 137736
4 | 0 | 8195
5 | 155159 | 154972
6 | 157812 | 157813
7 | 140854 | 142812
8 | 158725 | 158568
9 | 152333 | 147466
10 | 150573 | 147466
11 | 148999 | 147884
12 | 140891 | 135919
13 | 152551 | 150884
14 | 181781 | 181066
15 | 162214 | 160830
16 | 160106 | 158439
17 | 165133 | 163829
18 | 159445 | 162307
19 | 143790 | 142715
20 | 183046 | 184553
21 | 171857 | 172926
22 | 188778 | 187488
23 | 187559 | 187358
24 | 171977 | 171801
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | 0
2001-06-24 00:00:00
Spreadsheet: 872283d1718667970-i-want-to-obtain-data-on-a-small-area-from-a-large-area-618
Sheet: Sheet1

 | 1 | 3 | 5 | 7 | 9 | 11 | 13 | 15 | 17 | 19 | 21 | 23 | 25 | 27 | 29
 | 31 | 33 | 35 | 37 | 39 | 41 | 43 | 45 | 47 | 49 | 51 | 53 | 55 | 57 | 59
 | 61 | 63 | 65 | 67 | 69 | 71 | 73 | 75 | 77 | 79 | 81 | 83 | 85 | 87 | 89
 | 91 | 93 | 95 | 97 | 99 | 101 | 103 | 105 | 107 | 109 | 111 | 113 | 115 | 117 | 119
 | 121 | 123 | 125 | 127 | 129 | 131 | 133 | 135 | 137 | 139 | 141 | 143 | 145 | 147 | 149
 | 151 | 153 | 155 | 157 | 159 | 161 | 163 | 165 | 167 | 169 | 171 | 173 | 175 | 177 | 179
 | 181 | 183 | 185 | 187 | 189 | 191 | 193 | 195 | 197 | 199 | 201 | 203 | 205 | 207 | 209
 | 211 | 213 | 215 | 217 | 219 | 221 | 223 | 225 | 227 | 229 | 231 | 233 | 235 | 237 | 239
 | 241 | 243 | 245 | 247 | 249 | 251 | 253 | 255 | 257 | 259 | 261 | 263 | 265 | 267 | 269
 | 271 | 273 | 275 | 277 | 279 | 281 | 283 | 285 | 287 | 289 | 291 | 293 | 295 | 297 | 299
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: 3103 Services

 |  |  |  | 3103 |  |  |  |  |  |  | 3103 |  |  |  |  |  |  |  | 3103 |  |  |  |  |  |  |  |  |  | 3103
 |  |  |  | CAT Service - ENGINE No. N5F00633 |  |  |  |  |  |  | Fire Suppression |  |  |  |  |  |  |  | Core Service @ |  | 1000 |  |  |  |  |  |  |  | HF @ | 250
 |  |  |  | Frequency @ hr |  | 500 |  |  |  |  | Frequency @ 6 months
Date | @ 500hrs | Hrs when Serviced | Hrs between service dates | Current Hour | Hrs left to run before 500H | Comment |  | Completed by | Date | [NAME] | Next Service | Comment |  | Date | Completed by | @ 1000hrs | Hrs when Serviced | Hrs ran between service dates | Current Hour | Hrs left to run before 1000H | Comment | CAT Service |  | Date | Completed by | Hrs when HF | Hrs ran between HF dates | Next due @ 250hrs | Book when reached | Comment
2020-10-31 00:00:00 |  | 7625 |  |  |  |  |  | Fireward | 2020-11-11 00:00:00 | 7625 |  | 1st service after purchasing |  | 2020-10-23 00:00:00 | MD |  | 7620 |  |  |  | 1st service after purchasing |  |  | 2021-01-17 00:00:00 | AE & CF | 7926 |  |  |  | 1st HF after hiring
2021-02-27 00:00:00 |  | 8188 |  | 8597 |  | 8597 22.04.21 |  |  |  |  |  |  |  | 2021-01-17 00:00:00 | CF |  | 7926 |  | 8641 |  | 8291 08.03.21 |  |  | 2021-03-28 00:00:00 | AE | 8625 |  |  |  | 8597 22.04.21
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-03 00:00:00 | CF |  | 8472 |  | 8597 |  | 8597 22.04.21
Spreadsheet: 702914d1604606602-deleting-rows-with-coinciding-positive-and-negative-values-sample-book
Sheet: Sheet5

A | B | C | D | Before
2856475 | 82962 | 44 | 1 |  | <- We must check the entries in column A, if they coincide (i.e. A3=A4) then we check the entries in column B, if those coincide (B3=B4) then, we will eliminate the rows corresponding to the positive and negative values
2856475 | 82962 | 44 | 1 |  | Yet, we need it to check each subsequent entry, i.e. compare A3 to A4, if false move on to A3 and A5, etc. Then once it finds a match say at A3 and A5, check B3 and [NAME] to see if those are a match, then if they are check D3 and D5
2856475 | 82962 | 44 | 1 |  | If the values coincide, but the signs are different, and all other previous criteria has been met, then we will eliminate these two corresponding columns
2856475 | 85014 | 21 | 1
2856475 | 85610 | 33 | 1
2856475 | 85730 | 50 | 1
2856475 | 90935 | -1676 | -1 | <- | For example, here we see that all criteria is met for Row 9-12, then they would pair off, eliminating each other, i.e. Rows 9 and 11, will cancel each other out and become eliminated
2856475 | 90935 | -1676 | -1 | <- | And Rows 10 and 12 will cancel each other out and be eliminated.
2856475 | 90935 | 1676 | 1 | <- | It doesn't necessarily have to be 9 and 11 or 10 and 12, but can also be 9 and 12 and 10 and 11, but through checking each subsequent entry after each criteria is met, then this should be taken care of by itself.
2856475 | 90935 | 1676 | 1 | <-
 |  |  |  | After
A | B | C | D
2856475 | 82962 | 44 | 1
2856475 | 82962 | 44 | 1
2856475 | 82962 | 44 | 1
2856475 | 85014 | 21 | 1
2856475 | 85610 | 33 | 1
2856475 | 85730 | 50 | 1
Spreadsheet: 1127ef73-d702-47d3-8464-f45ff6cd9e90
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 6. COMMERCIAL FINANCE COMMITMENTS, By Purpose (Fixed Loans): Australia, Original ($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
Construction finance ; |  |  | Original | A2413488R | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Purchase of real property ; |  |  | Original | A2413489T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Wholesale finance ; |  |  | Original | A2413490A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Purchase of plant and equipment ; |  |  | Original | A2413491C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Refinancing ; |  |  | Original | A2413492F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Other ; |  |  | Original | A2413493J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413494K | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Commitments not drawn at end of month ; |  |  | Original | A2413495L | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 0e8a66c9-af6a-46b4-bbc3-0baa7e1b6ced
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Wytheville Community College | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  | Summer Term Appointment
Name |  |  |  |  |  |  |  | Date | 2006-05-23 00:00:00
Your temporary summer appointment to the faculty of Wytheville Community College,
which is subject to VCCS approval and official class enrollments(s)*, is as follows:
Inclusive Dates |  |  |  | From: |  |  |  | To:
 | Class |  |  |  | Credits
 | Totals |  |  |  | 0
A. | Full-time Salary Calculation (0-6 Credits):
 |  |  |  |  |  |  | Regular Salary
 | 0 |  | x | 16.5 |  | x |  |  | = | 0
 | 15 |  |  | 39
B | [NAME] (over 6 credits-maximum of 4 + may be approved for an additional 3 at adjunct rate)
 |  |  |  |  |  |  | [NAME]
 |  |  |  | 0 |  | x |  |  | = | 0
C | Total [NAME]: Full-time [NAME] |  |  |  |  |  |  |  | = | 0
There will be no deductions for retirement or life insurance, nor will you receive any additional credit
toward retirement or insurance accounts. Acceptance of this employment offer assumes agreement
to comply with the general conditions and employment set forth in (a) the Policy Manual of the Virginia
Community College System and (b) the Policies and Procedures Handbook of Wytheville Community College.
If the terms of this appointment are acceptable, please sign, date, and return the original to me by
 |  |  |  | SIGNED:
 |  |  |  |  |  | [NAME], President
DATE: |  |  |  | SIGNED:
 |  |  |  |  |  | Proposed Appointee
SHOULD ENROLLMENTS DICTATE, AN ADJUSTED CONTRACT MAY BE ISSUED.
Spreadsheet: 706085d1606462317-excel-formula-to-compare-multiple-columns-comparing-test
Sheet: Sheet1

Sno | Name | Code | Description | Types | Amount | Date | Code | Description | Description Full | Amount | Types | Date | Output Result
1 | CLR1 | 1001 | Description 1 | Type 1 | 50 | 2011-12-05 00:00:00 | 1001 | Description 1 |  | 50 | Type 11 | 2011-12-03 00:00:00 |  |  |  | Type is Not Matching
2 | CLR1 | 1005 | Description 2 | Type 2 | 30 | 2011-12-05 00:00:00 | 1001 | Description 2 |  | 50 | Type 2 | 2011-12-05 00:00:00 |  |  |  | Description is Not Matching
3 | CLR1 | 1016 | Description 3 | Type 3 | 50 | 2011-12-05 00:00:00 | 1005 | Description 3 |  | 30 | Type 3 | 2011-12-03 00:00:00 |  |  |  | Correct
4 | CLR1 | 2001 | Description 4 | Type 4 | 90 | 2011-12-05 00:00:00 | 1005 | Description 40 |  | 30 | Type 40 | 2011-12-05 00:00:00 |  |  |  | Description is Not Matching, Type is Not Matching
5 | CLR1 | 2002 | Description 5 | Type 5 | 30 | 2011-12-05 00:00:00 | 1016 | Description 5 |  | 50 | Type 5 | 2011-12-03 00:00:00 |  |  |  | Date is Not Matching
6 | CLR1 | 2003 | Description 6 | Type 6 | 30 | 2011-12-05 00:00:00 | 1016 | Description 6 |  | 50 | Type 6 | 2011-12-05 00:00:00 |  |  |  | Correct
7 | CLR1 | 2004 | Description 7 | Type 7 | 30 | 2011-12-05 00:00:00 | 2001 | Description 7 |  | 90 | Type 7 | 2011-12-03 00:00:00 |  |  |  | Correct
8 | CLR1 | 2005 | Description 8 | Type 8 | 30 | 2011-12-05 00:00:00 | 2001 | Description 118 |  | 190 | Type 811 | 2011-12-12 00:00:00 |  |  |  | Description is Not Matching, Type is Not Matching, [NAME] is Not Matching, Amount #is Not Matching
9 | CLR1 | 2006 | Description 9 | Type 9 | 50 | 2011-12-05 00:00:00 | 2002 | Description 9 |  | 30 | Type 9 | 2011-12-03 00:00:00 |  |  |  | Correct
10 | CLR1 | 2007 | Description 10 | Type 10 | 50 | 2011-12-05 00:00:00 | 2002 | Description 10 |  | 30 | Type 10 | 2011-12-05 00:00:00 |  |  |  | Correct
11 | CLR1 | 2008 | Description 11 | Type 11 | 30 | 2011-12-05 00:00:00 | 2003 | Description 11 |  | 30 | Type 11 | 2011-12-03 00:00:00 |  |  |  | Correct
12 | CLR1 | 2009 | Description 12 | Type 12 | 20 | 2011-12-05 00:00:00 | 2003 | Description 12 |  | 30 | Type 12 | 2011-12-05 00:00:00 |  |  |  | Correct
 | Need help in comparing multiple columns and get the result as showing the attachment.
 | Excel formula need to check the following:-
 | - If the column D values is matching column I. In case of not matching the result in column N will not [NAME] is Not Matching.
 | - If the column E values is matching column L. In case of not matching the result in column N will not Type is Not Matching.
 | - IF all the columns are not matching then the result will be in column N Description is Not Matching, Type is Not Matching, [NAME] is Not Matching, Amount is Not Matching.
 | - If all the columns are matching the result will be in column N is Correct
 | Copy of expecting output result is attached for your reference.
Spreadsheet: 863659d1711060922-index-match-formula-indexmatch_min-excel-function
Sheet: MIN Function

 | Construction Month | Project Status | Project Field Area | [NAME] | Well Name (Project Type) | Activity ID | Activity Status | WBS Code | IP - Well year | IP - Extension | IP - Field Name | IP - Iteration Number | IP - Job Category | IP - Job Status | IP - Primary Job Type | IP - Rig Name | IP - Scope Funding | IP - Scope Job Type | IP - Secondary Job Type | IP - Well API Number | IP - Well Type | IP - Wells Name | IP - WOA | Activity Name | START | (*)Start | FINISH | (*)Finish |  | DATE Range: | 2024-01-01 00:00:00 | 2024-12-31 00:00:00
 | 2023-12-31 00:00:00 | In Progress | AC | TBD | Porter 69G | IP.AC.9380 | Not Started | IP - AC.1.193.5.2 | 2024 | Not Reviewed | AC | 4TH | Workover | TBD | TBD | TBD | TBD | Assessment | TBD | 403724225 | Gas Storage | Porter 69G |  | Workover - 4th | 2023-12-15 08:00:00 | 2023-12-15 08:00:00 | 2024-01-24 17:00:00 | 2024-01-24 17:00:00
Spreadsheet: 330725d1404836810-using-mid-function-along-with-leading-zeros-sampleonlinecheckdigit
Sheet: Sheet1

1st Value | 2nd Value | Result |  | End Result
5 | 7
3 | 3
6 | 3
7 | 9
Spreadsheet: 159534d1338734861-formula-to-count-word-occurrence-for-every-nth-cell-copy-of-sample-call-schedule-jckmd
Sheet: Sheet1

SAMPLE CALL SCHEDULE
Date | Day of Week | Worker |  | Worker | Total days | Friday | Saturday | Sunday
2016-07-02 00:00:00 | Sun | Jon |  | Jon | 13 | 2 | 1 | 3
2016-07-03 00:00:00 | Mon | [NAME] |  | [NAME] | 11 | 0 | 3 | 1
2016-07-04 00:00:00 | Tue | [NAME] |  | [NAME] | 10 | 3 | 1 | 2
2016-07-05 00:00:00 | Wed | [NAME] |  | [NAME] | 10 | 1 | 1 | 2
2016-07-06 00:00:00 | Thu | [NAME]
2016-07-07 00:00:00 | Fri | [NAME]
2016-07-08 00:00:00 | Sat | [NAME]
2016-07-09 00:00:00 | Sun | [NAME]
2016-07-10 00:00:00 | Mon | Jon
2016-07-11 00:00:00 | Tue | [NAME]
2016-07-12 00:00:00 | Wed | Jon
2016-07-13 00:00:00 | Thu | [NAME]
2016-07-14 00:00:00 | Fri | Jon
2016-07-15 00:00:00 | Sat | [NAME]
2016-07-16 00:00:00 | Sun | [NAME]
2016-07-17 00:00:00 | Mon | Jon
2016-07-18 00:00:00 | Tue | Jon
2016-07-19 00:00:00 | Wed | [NAME]
2016-07-20 00:00:00 | Thu | [NAME]
2016-07-21 00:00:00 | Fri | [NAME]
2016-07-22 00:00:00 | Sat | Jon
2016-07-23 00:00:00 | Sun | [NAME]
2016-07-24 00:00:00 | Mon | [NAME]
2016-07-25 00:00:00 | Tue | Jon
2016-07-26 00:00:00 | Wed | Jon
2016-07-27 00:00:00 | Thu | [NAME]
2016-07-28 00:00:00 | Fri | [NAME]
2016-07-29 00:00:00 | Sat | [NAME]
2016-07-30 00:00:00 | Sun | Jon
2016-07-31 00:00:00 | Mon | [NAME]
2016-08-01 00:00:00 | Tue | [NAME]
2016-08-02 00:00:00 | Wed | [NAME]
2016-08-03 00:00:00 | Thu | Jon
2016-08-04 00:00:00 | Fri | [NAME]
2016-08-05 00:00:00 | Sat | [NAME]
2016-08-06 00:00:00 | Sun | [NAME]
2016-08-07 00:00:00 | Mon | [NAME]
2016-08-08 00:00:00 | Tue | [NAME]
2016-08-09 00:00:00 | Wed | [NAME]
2016-08-10 00:00:00 | Thu | [NAME]
2016-08-11 00:00:00 | Fri | Jon
2016-08-12 00:00:00 | Sat | [NAME]
2016-08-13 00:00:00 | Sun | [NAME]
2016-07-02 00:00:00 | Sun | Jon
Spreadsheet: 807553d1669942344-formatting-concatenate-ten-digit-number-in-a-cell-to-a-phone-number-phonenumbers
Sheet: Sheet1

Outgoing Phone Number
 |  | Telephone |  |  |  | Cell
Area | Telephone | Line |  |  |  | Formatted
Code | Prefix | Number |  |  |  | Special
Random | Random | Random |  |  |  | Phone
Number | Number | Number |  | CONCATENATE |  | Number
Spreadsheet: 49feb625-097d-46d7-8311-b455450ac304
Sheet: Sheet1

TRAVEL EXPENSE VOUCHER
See current Travel Regulations for reimbursement rates on the web at www.iup.edu/travel
Name: |  |  |  |  |  | Cost Center/WBSE |  |  | Commitment Item |  | Amount
SAP Number
Deliver Check to:
Purpose of Travel:
 |  |  |  |  |  | TRAVEL OFFICE USE ONLY
 |  |  |  |  |  | Vendor Number: ______________________ |  |  |  |  | 1099
 |  |  |  |  |  | Travel Officer: |  |  | Date: |  | Yes      No
Itinerary |  |  |  |  | Transportation and Lodging |  | Subsistence | Miscellaneous
Date | Leave Time | Return Time | List Locations | Personal Auto Miles | Provider Name & HO or TO | Cash You Paid | Per Diem Claimed |  | Explanation |  | Cash You Paid
 |  |  | Total Miles
 |  |  | Rate per Mile | 0.555
 |  |  | Totals
 |  |  |  | (A) |  | (B) | (C) |  |  |  | (D)
 |  |  |  |  |  | Total Reimbursement (A+B+C+D)
I certify these expenses are in accordance with established university travel policies and were incurred in the performance of official duties.
[NAME]'s Signature |  |  | Date |  |  |  | Authorizing Signature |  |  |  | Date
Spreadsheet: 128360d1320930265-newsting-two-if-forumlas-together-two-ifs
Sheet: May Sales.xls

Site | YYMM | Customer | Glass1 | Alcib1 | ProdGrp1 | Glass2 | [NAME] | Spacer | Textured | Georgian | Volume | Price
151 | 2011.05 | 3152 | 6.4mm Optilam Clear Ct | 410064 | H01000 | 4mm Optifloat Clear T | Toughened | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Annealed
151 | 2011.05 | 3152 | 6.4mm Optilam Clear Ct | 410064 | H01000 | 4mm Optifloat Clear T | Toughened | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Annealed
151 | 2011.05 | 3152 | 6.4mm Optilam Clear Ct | 410064 | H01000 | 6.4mm Optilam Clear Ct | Annealed | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Annealed
151 | 2011.05 | 3152 | 6.4mm Optilam Clear Ct | 410064 | H01000 | 6.4mm Optilam Clear Ct | Annealed | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Annealed
151 | 2011.05 | 3152 | 6.4mm Optilam Clear Ct | 410064 | H01000 | 6.4mm [NAME] 3065 | Annealed | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Annealed
151 | 2011.05 | 3152 | 6.4mm Optilam Clear Ct | 410064 | H01000 | 6mm Optifloat Clear T | Toughened | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | LaminatedAnnealedAluminiumNoNo |  | Annealed
151 | 2011.05 | 3152 | 6mm Optifloat Clear T | 300006 | F08000 | 6.4mm Optilam Clear Ct | Toughened | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Annealed
151 | 2011.05 | 3152 | 6mm Optifloat Clear T | 300006 | F08000 | 6mm Optifloat Clear T | Toughened | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Toughened
151 | 2011.05 | 3152 | 6mm Textured Cotswold T | 301806 | FB8000 | 6.4mm Optilam Clear Ct | Toughened | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | Annealed
Spreadsheet: 777438d1650379492-help-with-numbering-system-excel-help
Sheet: Sheet1

[NAME] | Scalar |  |  |  |  |  |  |  |  |  |  | [NAME] | level2 | level3 | level4 | [NAME] | level6 | [NAME] | [NAME]
This is what I would like my results to look like. This column will be deleted eventually | I want to make these columns extract the data from columns M to W and follow the numbering sequence in column A (Column A will be deleted once the formula in these columns is fixed). The problem I have is that I cannot return a blank when the numbers move backwards. For examplke, when row 33 changes to a 2, the only column with a number in it should be column B |  |  |  |  |  |  |  |  |  |  |  | Eventually there will be 11 text columns
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
1 |  |  |  |  |  |  |  |  |  |  |  | Smtih
1.1 |  |  |  |  |  |  |  |  |  |  |  |  | Jones
1.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Edwards
1.1.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Evans
1.1.1.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
1.1.1.1.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duce
1.1.1.1.1.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crowe
1.1.1.1.1.1.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Winzar
1.1.1.1.1.1.2.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | q
1.1.1.1.1.1.2.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w
1.1.1.1.1.1.2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | e
1.1.1.1.1.1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apples
1.1.1.1.1.1.3.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r
1.1.1.1.1.1.3.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t
1.1.1.1.1.1.3.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y
1.1.1.1.1.1.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pears
1.1.1.1.1.1.4.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u
1.1.1.1.1.1.4.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | i
1.1.1.1.1.1.4.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | o
1.1.1.1.1.1.4.3.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u
1.1.1.1.1.1.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plums
1.1.1.1.1.1.5.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v
1.1.1.1.1.1.5.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | f
1.1.1.1.1.1.5.1.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r
1.1.1.1.1.1.5.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rt
1.1.1.1.1.1.5.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t
1.1.1.1.1.1.5.3.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t
1.1.1.1.1.1.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tomatoes
2 |  |  |  |  |  |  |  |  |  |  |  | rgh
2.1 |  |  |  |  |  |  |  |  |  |  |  |  | rth
2.2 |  |  |  |  |  |  |  |  |  |  |  |  | rth
2.2.1 |  |  |  |  |  |  |  |  |  |  |  |  |  | rty
2.2.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rty
2.2.1.1.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rty
2.2.1.1.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rty
2.3 |  |  |  |  |  |  |  |  |  |  |  |  | rty
Spreadsheet: 147681d1332928288-get-data-between-two-datetime-cells-excel1
Sheet: Sheet1

DATETIME | TOTAL FLOWS | SUCCESSFULFLOWS |  | Changed Date Format | Flows Per 15 mins | Flows per Hour
19032012 00:06 | 212 | 212
19032012 00:21 | 212 | 212
19032012 00:36 | 218 | 218
19032012 00:51 | 218 | 218
19032012 01:06 | 222 | 222 |  |  |  |  |  |  | This List goes on and is fetched from a database, Here the flow at 19032012 03:51 is missing, so the entire fomula per hour goes wrong and is continued down.
19032012 01:21 | 226 | 226
19032012 01:36 | 242 | 242
19032012 01:51 | 253 | 253
19032012 02:06 | 260 | 260
19032012 02:21 | 267 | 267
19032012 02:36 | 276 | 276
19032012 02:51 | 283 | 283
19032012 03:06 | 290 | 290
19032012 03:21 | 292 | 292
19032012 03:36 | 300 | 300
19032012 04:06 | 313 | 313
19032012 04:21 | 323 | 323
19032012 04:36 | 330 | 330
19032012 04:51 | 341 | 341
19032012 05:06 | 347 | 347
19032012 05:21 | 354 | 354
19032012 05:36 | 364 | 364
19032012 05:51 | 373 | 373
19032012 06:06 | 377 | 377
19032012 06:21 | 386 | 386
19032012 06:36 | 399 | 399
19032012 06:51 | 408 | 408
19032012 07:06 | 412 | 412
19032012 07:21 | 415 | 415
19032012 07:36 | 417 | 417
Spreadsheet: stacey_white__39173__Consolidated Report
Sheet: Consolidated

EAST POWER TRADING
DAILY POSITION STATEMENT - TERMINATED AND NON-TERMINATED TRANSACTIONS
 |  | Non-Terminated Performing |  | Non-Terminated Non-Performing |  | Total Non-Terminated |  | Total Terminated |  | Grand Total (Non-Terminated and Terminated)
[NAME])  (Million MMbtu)
Net NPV Position (MWH)
Net NPV Position (MMBtu)
Net NPV Position (MM Bbls)
Gross Purchases Position
Gross Sales Position
Net Notional Position
As of December 31, 2001
Gross Purchases Position
Gross Sales Position
Net Notional Position
Change Since December 31, 2001
[NAME]  (in thousands)
Through December 31, 2001
Gross Book Balance
Prudence
Liquidated
LTD Gross Recognized Balance
Originated Transactions / Credit Reserve
Hedge management
New Deals
Change in Price
Change in Basis Price
Change in Index Price
Gamma
Change in Implied Volatility (Vega)
Theta
Change in Time
Change in Interest Rates
Broker Fees
Adjustments
MTD Total Hedge Management
Change in Price Prudence
Financial Liquidations
Physical Liquidations
Other Changes
MTD Income (Loss)
Gross Book Balance (including Current Month Rho & Drift)
Current Month:        Rho
Drift
Gross Book Balance (excluding Current Month Rho & Drift)
Prudence
Liquidated
Gross Recognized Balance
LTD Through December 31, 2001
Gross Recognized Balance
Originated Transactions / Credit Reserve
Gross Book Balance
Prudence
Liquidated
Gross Recognized Balance
Income (Loss) from Today's....
Originated Transactions / Credit Reserve
Hedge management
New Deals
Change in Price
Change in Basis Price
Change in Index Price
Gamma
Change in Implied Volatility (Vega)
Theta
Change in Time
Broker Fees
Adjustments
Today's Total Hedge Management
Change in Price Prudence
Financial Liquidations
Physical Liquidations
Other Changes
Total Income (Loss)