tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677508d1589378151-send-a-sheet-by-mail-with-formulas-without-loose-the-values-total-file
Sheet: TOTAL

 |  |  |  |  |  |  |  |  |  | DAY | YEAR
 |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  | E
 |  |  |  |  |  |  |  |  | F
Spreadsheet: 805199d1668586820-divide-as-whole-number-and-allocate-to-month-column-book1-1-
Sheet: Sheet1

Item | Start Date | Months | Finish Date | Qty | 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
1 | 2023-02-01 00:00:00 | 3 |  | 70
2 | 2023-01-01 00:00:00 | 2 |  | 23
3 | 2023-04-01 00:00:00 | 3 |  | 14
Spreadsheet: 24571d1215071488-find-command-with-in-if-command-search-with-in-if
Sheet: Sheet1

A | B | C | D
normal Stock order 23.06.2008 | 10 | 12345 | normal
outbound 23.06.2008 | 10 |  | #N/A
delivery 24.06.2008 | 10 |  | #N/A
case 25.06.2008 | 10 |  | #N/A
invoice 30.06.2008 | 10 |  | #N/A
Spreadsheet: 93140d1292664120-trouble-sorting-dates-with-new-attachment-forexcelforumdates
Sheet: Hoja1

Dates as | Date as Serial Number | Cell as shown
Day-Month-Year | =[NAME]() | in the formula bar
1925-01-05 00:00:00 | #N/A | as 2/3/2009
2009-02-05 00:00:00 | #N/A | as 5/2/2009
22-3-2009 | 39894 | as 22-3-2009
6-4-2009 | 39909 | as 6-4-2009
12-2-1967 | #N/A | as 12-2-1967
21-1-1984 | #N/A | as  21-1-1984
28-5-1932 | #N/A | as  28-5-1932
> Only the first four et correctly sorted as dates (column A)
> Of those four, the ones on lines 3 and 4 don't seem to be stored as dates, since they fail to produce a serial number (column B)
> But these same on lines 3 and 4 are shown in the formula bar with "/", which seem typical of dates (Column C)
> Instead, the ones on lines 5 and 6, produce a serial number in column B, but are shown with "-" in the formula bar (column C)
> The ones on lines 6, 7 and 8 neither get sorted, nor produce a serial number date: theys seem to be stored as text or 'general',
But theres's no way I an convert them to dates.
Spreadsheet: 679815d1590647130-using-other-template-my-raw-transpose-using-multi-criteria-lookup-please-help-transpose-multi-criteria-look-up
Sheet: My Template

 |  | PARK |  |  |  |  |  |  |  |  |  | HOSPITAL
 |  | 2020-05-26 00:00:00 |  |  | 2020-05-27 00:00:00 |  |  | 2020-05-28 00:00:00 |  |  |  |  | 2020-05-26 00:00:00 |  |  | 2020-05-27 00:00:00 |  |  | 2020-05-28 00:00:00
 |  | Park 1 | Park 2 | Park 3 | Park 1 | Park 2 | Park 3 | Park 1 | Park 2 | Park 3 |  |  | Hospital 1 | Hospital 2 | Hospital 3 | Hospital 1 | Hospital 2 | Hospital 3 | Hospital 1 | Hospital 2 | Hospital 3
 | 1 |  |  |  |  |  |  |  |  |  |  | 1
 | 2 |  |  |  |  |  |  |  |  |  |  | 2
 | 3 |  |  |  |  |  |  |  |  |  |  | 3
 | 4 |  |  |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  |  |  |  | 6
 | 7 |  |  |  |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  |  |  |  | 19
 | 20 |  |  |  |  |  |  |  |  |  |  | 20
 | 21 |  |  |  |  |  |  |  |  |  |  | 21
 | 22 |  |  |  |  |  |  |  |  |  |  | 22
 | 23 |  |  |  |  |  |  |  |  |  |  | 23
 | 24 |  |  |  |  |  |  |  |  |  |  | 24
Spreadsheet: 841959d1694076615-is-it-possible-to-use-trend-formula-byrow-on-a-spill-range-trendexample
Sheet: Sheet1

 |  |  |  |  |  |  | Expected/Desired Output (Without referencing spill) |  |  |  |  |  | Attempt with spill reference
 |  |  | 9M | 6M | 12M |  |  |  |  | Up/Down/Flat
 |  | A |  | 66.657 | 74.5 |  |  | 86.668 | 64.49450000000002
 |  | B | 56.143 | 48.5 | 38.2 |  |  | 47.61433333333333 | 38.64283333333334
 |  | C | 35.8 | 35.8 | 36.75 |  |  | 36.11666666666667 | 36.59166666666667
 |  | D | 0 | 0 | 0 |  |  | 0 | 0
 |  | E | 57.25 | 55 | 65 |  |  | 59.08333333333334 | 62.95833333333334
Spreadsheet: 38031d1236150389-looking-for-formula-pls-sample
Sheet: ANIMATION

 | Sc Length | Name | Date
SC 001 | 2 | GAVIN | 2009-03-02 00:00:00
SC 002 | 5 | GAVIN | 2013-03-03 00:00:00
SC 003 | 6 | GAVIN | 2013-03-03 00:00:00
SC 004 | 9 | DAN | 2009-03-02 00:00:00
SC 005 | 1 | DAN | 2013-03-03 00:00:00
SC 006 | 2 | DAN | 2013-03-03 00:00:00
SC 007 | 3 | [NAME] | 2009-03-02 00:00:00
SC 008 | 4 | [NAME] | 2009-03-02 00:00:00
SC 009 | 5 | [NAME] | 2009-03-03 00:00:00
SC 010 | 10 | MARVIN | 2009-03-02 00:00:00
TOTAL | 47
 | GAVIN | DAN | [NAME] | MARVIN | TOTAL
2009-03-02 00:00:00 | 2 | 9 | 7 | 10 | 28
2009-03-03 00:00:00 | 11 | 3 | 5 | 0 | 19
TOTAL | 13 | 12 | 12 | 10 | 47
Spreadsheet: louise_kitchen__22644__Third Qtr Compare 00 - 01 Aug31 EM
Sheet: Aug31 3rd Qtr 

EOL 3rd Quarter Comparison  2000  vs. 2001
Date: 9/5/01
 |  | MTD - July 1 - August 31, 2000 |  |  |  |  |  |  | MTD - July 1 - August 31, 2001
Commodity |  | EOL Deal Count | EOL Volume |  | OTC  Deal Count | OTC  Volume | UOM |  | EOL Deal Count | EOL Volume |  | OTC  Deal Count | OTC  Volume | UOM
US Gas |  | 69585 | 12915918981.74 |  |  |  | MMBtu |  | 141222 | 23807911327.68 |  |  |  | MMBtu
Canadian Gas |  | 9557 | 917409636.27 |  |  |  | MMBtu |  | 9952 | 625594798.8299999 |  |  |  | MMBtu
Continental Gas |  | 174 | 19657500 |  |  |  | MMBtu |  | 450 | 33354211 |  |  |  | MMBtu
UK Gas |  | 2858 | 407895000 |  |  |  | MMBtu |  | 2708 | 414616688.07 |  |  |  | MMBtu
US Power |  | 7238 | 67988220 |  |  |  | MWh |  | 44903 | 431344514 |  |  |  | MWh
Continental Power |  | 2004 | 21247038 |  |  |  | MWh |  | 4588 | 44358234 |  |  |  | MWh
Nordic Power |  | 566 | 7016963 |  |  |  | MWh |  | 531 | 10228319 |  |  |  | MWh
UK Power |  | 440 | 18576960 |  |  |  | MWh |  | 650 | 35883840 |  |  |  | MWh
Crude & Products |  | 2156 | 71232000 |  |  |  | BBL |  | 14547 | 657529750.01 |  |  |  | BBL
LPG |  | 272 | 4274000 |  |  |  | BBL |  | 536 | 12299000 |  |  |  | BBL
Petrochemicals |  | 33 | 704000 |  |  |  | BBL |  | 53 | 554000 |  |  |  | BBL
Coal |  | 459 | 14398250 |  |  |  | TONNE |  | 246 | 6387250 |  |  |  | TONNE
Emissions |  | 137 | 342500 |  |  |  | Contracts |  | 25 | 62500 |  |  |  | Contracts
Paper and Pulp |  | 3 | 22000 |  |  |  | TONNE |  | 109 | 21644 |  |  |  | TONNE
Weather |  | 250 | 50300 |  |  |  | Contracts |  | 121 | 23601 |  |  |  | Contracts
Metals |  | 31 | 9693 |  |  |  | MT |  | 20636 | 6980680 |  |  |  | MT
Spreadsheet: louise_kitchen__23934__AugQTD Orig w notes
Sheet: ERCOT

ERCOT Orig
For the Quater Ended August 31
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Curry |  | Power |  | ERCOT Orig |  | 18060000
Jester |  | Power |  | ERCOT Orig |  | 10000
Total
Spreadsheet: 826121d1681807990-complex-3-lookup-ignoring-negative-value-to-sum-up-match
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lookup 1 |  |  |  | Data1 |  |  | [NAME] |  |  |  | Data2 | Lookup 3 |  | Data3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | * | *
* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X1/5-755 | * | * | * | -25 |  |  |  | * | * | * |  | PRT=1/364 | * | 70
* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | * | *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * |  |  |  |  |  |  |  | * | * | * |  | * | * | *
* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | * | *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X1/5-755 | * | * | * | 4 |  |  |  | * | * | * |  | * | * | *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | * | *
*
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRT=1/364 | * | * | * | 50 |  |  | X1/5-755 | * | * | * | 10 | ABCX2 | * | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | * | 45
Spreadsheet: 04de7c86-1f43-402e-970f-3b08b18ab5b0
Sheet: ConsolidateFY07

CALCULATIONS FOR DISTRICTS OPENING IN FY 2007: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PENSION0508_20070514
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2007-05-14 00:00:00
RESOLUTION:  WE ARE CALCULATION THE ADJUSTMENT FOR NEWLY CONSOLIDATED DISTRICTS AS IF THEY HAD ALWAYS BEEN SINGLE ENTITIES.
THIS IS BASED ON A CONVERSATION WITH TOM MELCHER THAT TOOK PLACE ON OCTOBER 24, 2007.
For FY 2007, the primary salary basis is the least salary total from the years FY 1997, FY 2004, FY 2005, FY 2006, and FY 2007.
Districts #2899 and #2902 both opened in FY 2007.  For these new districts, the "least of" salary basis may apply to
one or more of the previous districts, but not for the new districts when dealt with as single entities.
We don't want to punish districts for consolidating.  Therefore, we will ensure new districts of their former "least of" benefit
by basing their "least of" salary totals on their prior district structures.
Here are the details:
 |  |  | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O
 |  |  | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL |  |  |  |  |  |  | FY 2005 | FY 2006 | FY 2007 | FY 2008
 |  |  | FY 1997 | FY 2004 | FY 2005 | FY 2006 | FY 2007 |  |  |  |  |  |  | PENSION | PENSION | PENSION | PENSION
 |  |  | TRA | TRA | TRA | TRA | TRA |  |  |  |  |  |  | REDUCT | REDUCT | REDUCT | REDUCT
 |  |  | SALARIES | SALARIES | SALARIES | SALARIES | SALARIES |  |  |  |  | FY 1997 | OLD LAW | = .0234 | = .0234 | = .0234
 |  |  | BASIC | BASIC | BASIC | BASIC | BASIC | = MIN OF | = MIN OF | = MIN OF | = MIN OF | PERA | PERA
 |  |  | +COORD | +COORD | +COORD | +COORD | +COORD |  |  |  |  | SALARIES | ADJUST |  |  |  | 0.005
2899 | 1 | PLAINVIEW-ELGIN-MILLVILLE
806 | 1 | ELGIN-MILLVILLE | 1687490.62 | 1799998.73 | 1789832.48 | 1617312.98 | N/A |  |  |  |  | 375106 | -992.4 |  |  |  | N/A
810 | 1 | PLAINVIEW | 3126391.32 | 4387846.47 | 4218954.41 | 3993852.2 | N/A |  |  |  |  | 499627 | -1124.01 |  |  |  | N/A
 |  | SUM OF  SEPARATE |  |  |  |  | N/A |  |  |  |  |  |  |  |  |  | N/A
 |  | AS SINGLE DISTRICT |  |  |  |  | 5950720.869999999
 |  | DIFFERENCE | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  | N/A
2902 | 1 | [NAME]
409 | 1 | TYLER | 1021122.39 | 1010946.07 | 999475.3 | 912894.51 | N/A |  |  |  |  | 144194 | -1033.45 |  |  |  | N/A
418 | 1 | [NAME] | 580764.39 | 467380.33 | 481322.47 | 412099.79 | N/A |  |  |  |  | 126548 | -580.15 |  |  |  | N/A
584 | 1 | RUTHTON | 645735.32 | 690955.66 | 728755.19 | 710471.8 | N/A |  |  |  |  | 144537 | -894.1 |  |  |  | N/A
 |  | SUM OF  SEPARATE |  |  |  |  | N/A |  |  |  |  |  |  |  |  |  | N/A
 |  | AS SINGLE DISTRICT |  |  |  |  | 1786518.61
 |  | DIFFERENCE | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  | N/A
Values in the yellow cells are used in the "Districts" worksheet.
Spreadsheet: daren_farmer__5069__HPLN0518
Sheet: Sheet1

HPLN0518.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - May 18, 2001
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-05-18 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | TUFCO Waha |  | Enron | 10 | 0
Enron (S) |  | Sandhills |  | Enron | 8 | 8
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 164073d1340640042-lookup-or-if-formula-when-cell-is-between-a-range-ship-weight-example
Sheet: Sheet1

Item | Weight | SHIP COST
A | 5
B | 6
C | 1
D | 5.6
E | 3.8
F | 2
G | 7.9
H | 4.1
I | 0.7
J | 6.2
K | 5.8
L | 5.9
M | 2.9
Spreadsheet: phillip_allen__28805__Rent_Roll
Sheet: weekly

 |  |  |  | Stagecoach Apartments
 |  |  |  | Rent Worksheet
 |  |  |  | Week ended August 25, 2000
Unit | Name | Bal. Fwd. | Rent Due | Total | Date Pd. | Amount | Fwd. Bal. | Notes
1 |  |  | 100
2 |  |  | 110
3 |  |  | 110
4
5 |  |  | 100
6 |  |  |  | 240
7 |  |  | Mgr
8
9 |  |  | 100
10 |  |  | 110
11 |  |  |  | 200
12 |  |  | 100
13
14 |  |  | 95
15 |  |  |  | 190
16 |  |  | 100
17 |  |  | 100
18 |  |  |  | 200
19
20 |  |  | 105
21 |  |  | 105
22 |  |  | 100
23 |  |  | 100
24 |  |  | Maint
25 |  |  | 100
26 |  |  | 115
27 |  |  | 125
28 |  |  | 115
29 |  |  | 115
30
31
32 |  |  | 100
33 |  |  | 105
34 |  |  | 110
35 |  |  | 110
36 |  |  |  | 250
37 |  |  | 115
38 |  |  | 130
39 |  |  | 120
40 |  |  | 130
41
42 |  |  | 120
43 |  |  | 120
44 |  |  |  | 270
Total
Spreadsheet: 842004d1694099360-calculation-of-holiday-hours-holidays-calculator-magalela-
Sheet: LucasShift

Date | Employee 1 |  |  |  | Employee 2 |  |  |  |  | Annual Holidays
 | Time In | Time Out | Hours | Holiday Hours | Time  In | Time Out | Hours | Holiday Hours
2023-08-01 00:00:00 |  |  |  |  | 07:00:00 | 16:16:00 |  |  |  | 2023-01-01 00:00:00
2023-08-02 00:00:00 |  |  |  |  | 07:00:00 | 16:22:00 |  |  |  | 2023-04-07 00:00:00
2023-08-03 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00 |  |  |  | 2023-04-10 00:00:00
2023-08-04 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:19:00 |  |  |  | 2023-04-19 00:00:00
2023-08-05 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  |  |  | 2023-04-25 00:00:00
2023-08-06 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  |  |  | 2023-05-01 00:00:00
2023-08-07 00:00:00 |  |  |  |  | 07:00:00 | 16:15:00 |  |  |  | 2023-05-18 00:00:00
2023-08-08 00:00:00 |  |  |  |  | 07:00:00 | 16:15:00 |  |  |  | 2023-07-22 00:00:00
2023-08-09 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:11:00 |  |  |  | 2023-08-04 00:00:00
2023-08-10 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:13:00 |  |  |  | 2023-08-06 00:00:00
2023-08-11 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  |  |  | 2023-08-16 00:00:00
2023-08-12 00:00:00 | 16:00:00 | 07:00:00 |  |  |  |  |  |  |  | 2023-08-31 00:00:00
2023-08-13 00:00:00 |  |  |  |  | 07:00:00 | 16:12:00 |  |  |  | 2023-12-25 00:00:00
2023-08-14 00:00:00 |  |  |  |  | 07:00:00 | 16:19:00 |  |  |  | 2023-12-26 00:00:00
2023-08-15 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:14:00 |  |  |  | 2023-12-28 00:00:00
2023-08-16 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:17:00
2023-08-17 00:00:00 | 16:00:00 | 07:00:00
2023-08-18 00:00:00 | 16:00:00 | 07:00:00
2023-08-19 00:00:00 |  |  |  |  | 07:00:00 | 16:24:00
2023-08-20 00:00:00 |  |  |  |  | 07:00:00 | 16:14:00
2023-08-21 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
2023-08-22 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
2023-08-23 00:00:00 | 16:00:00 | 07:00:00
2023-08-24 00:00:00 | 16:00:00 | 07:00:00
2023-08-25 00:00:00 |  |  |  |  | 07:00:00 | 16:15:00
2023-08-26 00:00:00 |  |  |  |  | 07:00:00 | 16:15:00
2023-08-27 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
2023-08-28 00:00:00 | 07:00:00 | 16:00:00 |  |  | 16:00:00 | 07:15:00
2023-08-29 00:00:00 | 16:00:00 | 07:00:00
2023-08-30 00:00:00 | 16:00:00 | 07:00:00
2023-08-31 00:00:00 |  |  |  |  | 16:00:00 | 07:15:00
2023-08-04 00:00:00 | from 07.00 to 16.00 = 9 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours
2023-08-06 00:00:00 | from 16.00 to 00.00 = 8 Hours |  |  |  | -
2023-08-16 00:00:00 | from 07.00 to 16.00 = 9 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours
2023-08-31 00:00:00 | from 00.00 to 07.00 = 7 Hours |  |  |  | from 16.00 to 00.00 = 8 Hours
 | Total Holidays |  |  |  | Total Holidays
Spreadsheet: 772070d1646996076-need-help-on-formula-to-get-score-for-help-calculation
Sheet: Sheet1

 |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5
 |  | 21 | 5 | 16 | 21 | 24 | 27
 |  |  | I need formula in I4
 |  |  | Where on the basis of C4 Value
 |  |  | I should get Out of 5
 |  |  | For e.g
 |  |  | if C4  value falls in between 16 - 21  then out of would be in between 2 to 2.5.. And so on
 |  |  | if C4  value falls in between 21 - 24  then out of would be in between 2.5 to 3.5.. And so on
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 14c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | 0 | 9 | 0 | 5
Index | 5011 | 42 | 7908 | 84
OTHER* | 7 | 34 | 7 | 16
TOTAL | 5018 | 85 | 7915 | 105
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: mark_taylor__24680__Canadian Only Financial Masters
Sheet: Sheet1

 |  | CAN Gas FIN BasisSwap | CAN Gas FIN OPT | CAN Gas FIN Swap
duns link id | Counterparty Name | Enron Canada Corp | Enron Canada Corp | Enron Canada Corp
53490 | Agrium Inc. | 96022656 | 96022656 | 96022656
6194 | Beau Canada Exploration Ltd. | 95000246 | 95000246 | 95000246
58979 | Canadian Natural Resources | 96000154 | 96000154 | 96000154
26427 | Consumers Gas Company Ltd. | 96005790 | 96005790 | 96005790
11110 | Dow Chemical Canada Inc. | 96000237 | 96000237 | 96000237
11105 | Encal Energy Ltd. | 96019312 | 96019312 | 96019312
31131 | Highridge Exploration Ltd. | 96002740 | 96002740 | 96002740
6214 | [NAME] | 96019602 | 96019602 | 96019602
26085 | Northrock Resources Ltd. | 96008774 | 96008774 | 96008774
26211 | Oiltec Resources Ltd. | 95000293 | 95000293 | 95000293
11157 | PanCanadian Petroleum Limited | 96016046 | 96016046 | 96016046
54438 | PG&E Energy Trading, Canada Corporation | 96022603 | 96022603 | 96022603
5177 | SaskEnergy Incorporated | 96019510 | 96019510 | 96019510
6218 | Talisman Energy Inc. | 96019944 | 96019944 | 96019944
55898 | TransAlta Energy Marketing Corp. | 96021810 | 96021810 | 96021810
48528 | TransCanada Energy Financial Products Limited | 96001822 | 96001822 | 96001822
10839 | Vermont Gas Systems Incorporated | 96019313 | 96019313 | 96019313
Spreadsheet: 126643d1319805343-vlookup-perhaps-array-formula-dummy-20ot-20report-202-1-
Sheet: Jan.

 | PAY PERIOD 1                                                                     January 1, 2012 to January 7, 2012 |  |  |  |  |  |  | OT Standard (OT) | OT Other (OTOT) | OT Acting Captain (OTAC) | OT Stat Standard (STAT) | OT Acting PC (OTAPC) | Late By 1 Period | 2nd Late By 1 Period | Late By 2 Periods | 2nd Late By 2 Periods |  | Late 1 | Late 2
*hidden row* | PAY PERIOD 1 - January 1, 2012 to January 7, 2012 |  |  |  |  |  |  | OT | OTOT | OTAC | STAT | OTAPC | L1 | L2 | LL1 | LL2 |  | Shown on another worksheet | Shown on another worksheet
EMPLOYEE | 1 | 2 | 3 | 4 | 5 | 6 | 7
Personel 1 | 15 STAT |  | 10 APC |  | 10 OT L1 | 14 OT LL1 | 6 AC | 24 | 0 | 0 | 15 | 0 | 10 OT L1 |  | 14 OT LL1 |  |  | [[NAME] should search N4:Q4] then show the contents from N4 | [[NAME] should search N4:Q4] then show the contents from P4
Spreadsheet: 0677bd59-e48c-4d46-9fb4-a53b4976f59c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-27 09:48:41
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.514 | 101.389 | 101.264 | 100.889
4.625 | 100.941 | 100.816 | 100.691 | 100.316 |  | Note: | Refer To Price [NAME]
4.5 | 100.426 | 100.301 | 100.176 | 99.801 |  |  | For all Price Adjs
4.375 | 99.817 | 99.692 | 99.567
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.875 | 101.75 | 101.625 | 101.25
4 | 101.551 | 101.426 | 101.301 | 100.926
3.875 | 101.148 | 101.023 | 100.898 | 100.523
3.75 | 100.583 | 100.458 | 100.333 | 99.958
3.625 | 99.468 | 99.343 | 99.218
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-07-11 09:48:41
30 DAY | 2011-07-26 09:48:41
45 DAY | 2011-08-10 09:48:41
60 DAY | 2011-08-25 09:48:41
90 DAY | 2011-09-24 09:48:41
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: kimberly_watson__20552__imbalsumm0108
Sheet: by type

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  |  |  | AVG
 |  |  |  |  |  |  |  | NTXPH
DOLLAR VALUED IMBALANCES
 |  | Calc vol @ | CBS | Calc vol | As of
Operator | $[NAME] | [NAME] | Volume | less CBS vol | Date | Mrktg rep | MS rep | Comments
West of Thoreau
Calpine |  |  |  |  |  |  | [NAME]
Citizens-Griffith |  |  |  |  |  |  | [NAME]
North Star Steel |  |  |  |  |  | M Lokay | [NAME]
Citizens Communications |  |  |  |  |  |  | [NAME]
Total WOT
San Juan
TransColorado |  |  |  |  |  |  | [NAME]
Burlington |  |  |  |  |  |  | [NAME] | balance is cashed out monthly
Total SJ
East of Thoreau
NNG |  |  |  |  |  | TK Lohman | [NAME]
Conoco |  |  |  |  |  |  | [NAME] | [NAME] and Maljamar
Amoco Abo |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  | [NAME]
Duke/GPM |  |  |  |  |  |  | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
CIG |  |  |  |  |  |  | [NAME]
Mewborne |  |  |  |  |  |  | [NAME]
EPFS / PG&E TX |  |  |  |  |  | TK Lohman | [NAME]
PNM |  |  |  |  |  |  | [NAME]
EOG |  |  |  |  |  | L Lindberg | [NAME]
[NAME] |  |  |  |  |  | TK Lohman | [NAME] | cashed out monthly
Continental |  |  |  |  |  |  | [NAME]
El Paso Field Services |  |  |  |  |  |  | [NAME]
Agave |  |  |  |  |  |  | [NAME]
Total EOT
Total $ Value
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  |  |  | AVG
 |  |  |  |  |  |  |  | NTXPH
VOLUMETRIC IMBALANCES
 |  | Calc$ @curr | If $valued | Calc$ less | As of
Operator | Volume | Mo prices | amount | if $valued | Date | Mrktg rep | MS rep | Comments
West of Thoreau
Mojave Pipeline |  |  |  |  |  |  | [NAME] | 129,146 mmbtus was created in 6/01
SoCal |  |  |  |  |  |  | [NAME]
PG&E Topock |  |  |  |  |  |  | [NAME]
Total WOT
San Juan
[NAME] |  |  |  |  |  |  | [NAME] | balance created from 1/01 to present
Red Cedar |  |  |  |  |  | L Lindberg | [NAME] | last cashout was for balance as of 9/30/00
Amoco |  |  |  |  |  |  | [NAME] | 114,758 mmbtu receivable in 4/01
El Paso |  |  |  |  |  |  | [NAME] | payback has been made for the past two months
Northwest |  |  |  |  |  |  | [NAME]
Total SJ
East of Thoreau
NGPL |  |  |  |  |  |  | [NAME]
Panhandle Eastern |  |  |  |  |  |  | [NAME] | Hansford
Oasis |  |  |  |  |  |  | [NAME]
Lonestar |  |  |  |  |  |  | [NAME]
Total EOT
Total Volumetric imbals
NET IMBAL AMOUNT
NET IMBAL VOLUME