tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125640d1319135411-converge-on-solution-hook-distance-from-center-jdk
Sheet: TENSION

LOWER BLOCK HORIZONTAL POSITION
Enter locations of drum, upper sheaves & equalizer. Simplest approach is to use the centerlines of the drum as the zero datum point.  Objects up and to the right are positive.
Enter 'X' location of Lower Block, alter lower block position until the resultant force approaches zero.
 | DRUM | LEFT UPPER SHEAVES | RIGHT   UPPER SHEAVES | EQUALIZER |  | LOWER BLOCK
X | 0 | -38.7 | 38.7 |  |  | 4.5
Y | 0 | -16.75 | -16.75 |  |  | -70.61
Pitch Diameter | 48.5 | 33 | 33 |  |  | 36
Quantity of Item | 1 | 2 | 2 |  |  | 1
Number of Ropes on each Item | 2 | 1 | 2 |  |  | 8
Rope Comes off which side of [NAME] to Lower Block Right/Left (R/L) or [NAME] (I)? | L | I | I |  |  | L | Rope Comes off which side of Lower Block Right/Left (R/L) to Drum?
 |  |  | Reasultant Force = | 0.2320334601078144 | SHOULD BE CLOSE TO ZERO CHANGE LOWER BLOCK POSITION
LOAD: | 500 | 499.9999999999999
LB - X (Starting Assumption) | 4.5
drum wr position | -24.25
lb wr position | -13.5
lb wr position from right | 22.5
left upper sheave wr position | -38.7
right upper sheave wr position | 38.7
equalizer [NAME] position | 0
 |  |  |  | Total Forces
x - drum to lb (wire rope) |  | 10.75
y - drum to lb |  | -70.61
Angle rope from drum |  | -0.151084551030032 | -8.656507123649748
horz force/rope |  | -9.877019799194013 |  | -19.75403959838803 |  | -19.75403959838803 | 0
vert force |  | 64.87594121126412
x - left us to lb |  | 25.2
y - left us to lb |  | -53.86
Angle rope from drum |  | -0.4376227908977448 | -25.07393893717692
[NAME] |  | -27.8104161100205 |  | -55.620832220041 |  | -55.620832220041 | 0
vert force |  | 59.43924649546444
x - right us to lb |  | -16.2
y - right us to lb |  | -53.86
Angle rope from drum |  | 0.2921720532114787 | 16.74022554068944
[NAME] |  | 18.90172631963421 |  | 75.60690527853684 |  | 0 | 75.60690527853684
vert force |  | 62.8424061466357
x - eq to lb |  | -13.5
y - eq to lb |  | -70.61
Angle rope from drum |  | 0.1889112456317497 | 10.82381707725847
[NAME] |  | 12.32341155694953 |  | 0 |  | 0 | 0
vert force |  | 64.45600666934861
 |  |  |  |  |  | -75.37487181842903 | 75.60690527853684
 |  |  |  |  |  | 0.2320334601078144
 |  |  |  |  |  | 4.5
 |  |  |  |  |  | 4.25
Tension |  | 65.62349631161898
Spreadsheet: 272552d1382430803-filter-or-formula-book2
Sheet: Sheet1

Work Order Number | Status | Originator | Asset Number | Original Priority | Origination Date | Origination Time | Start Date | Start Time
C228192 | AWA | [NAME] | PACCESS03 | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-01 00:00:00 | 1631
C228192 | CLO | [NAME] | PACCESS03 | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-07 00:00:00 | 858
C228192 | CMP | [NAME] | PACCESS03 | 5 | 2013-01-01 00:00:00 | 1631 | 2013-01-01 00:00:00 | 1702
C228193 | AWA | [NAME] | BDG001-HVAC | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-01 00:00:00 | 1637
C228193 | CLO | [NAME] | BDG001-HVAC | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-08 00:00:00 | 1325
C228193 | CMP | [NAME] | BDG001-HVAC | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-07 00:00:00 | 1325
C228193 | RDY | [NAME] | BDG001-HVAC | 5 | 2013-01-01 00:00:00 | 1637 | 2013-01-03 00:00:00 | 1053
C228194 | AWA | [NAME] | BDG053-INLT | 5 | 2013-01-01 00:00:00 | 1702 | 2013-01-01 00:00:00 | 1702
C228194 | CLO | [NAME] | BDG053-INLT | 5 | 2013-01-01 00:00:00 | 1702 | 2013-01-29 00:00:00 | 915
C228194 | CMP | [NAME] | BDG053-INLT | 5 | 2013-01-01 00:00:00 | 1702 | 2013-01-28 00:00:00 | 1547
C228194 | IWD | [NAME] | BDG053-INLT | 5 | 2013-01-01 00:00:00 | 1702 | 2013-01-25 00:00:00 | 1115
C228195 | AWA | [NAME] | [NAME] | 5 | 2013-01-01 00:00:00 | 1824 | 2013-01-01 00:00:00 | 1824
C228195 | CLO | [NAME] | [NAME] | 5 | 2013-01-01 00:00:00 | 1824 | 2013-01-04 00:00:00 | 737
C228195 | CMP | [NAME] | [NAME] | 5 | 2013-01-01 00:00:00 | 1824 | 2013-01-01 00:00:00 | 1828
C228196 | AWA | [NAME] | SOFTWARE002 | 5 | 2013-01-01 00:00:00 | 1826 | 2013-01-01 00:00:00 | 1826
C228196 | CLO | [NAME] | SOFTWARE002 | 5 | 2013-01-01 00:00:00 | 1826 | 2013-01-08 00:00:00 | 730
C228196 | CMP | [NAME] | SOFTWARE002 | 5 | 2013-01-01 00:00:00 | 1826 | 2013-01-01 00:00:00 | 1829
Spreadsheet: 163802d1340463232-dynamic-range-inside-array-formula-with-use-of-match-crosspostanswer
Sheet: Data

Category | Case | Value
Category A | 1
Category A | 2
Category A | 3 |  |  |  | Category | Category B
Category A | 4
Category A | 5 |  |  |  | Row Labels | Sum of Case
Category A | 6 |  |  |  | 0.1101735607225764 | 22
Category A | 7 |  |  |  | 0.443196905337237 | 23
Category A | 8 |  |  |  | 0.6282828237926608 | 24
Category A | 9 |  |  |  | Grand Total | 69
Category A | 10
Category A | 11
Category A | 12 |  |  |  | The above is a pivot of your data
Category A | 13 |  |  |  | Filtered by Category B
Category B | 14 |  |  |  | In the Row it shows only top 3 vlaues
Category B | 15 |  |  |  | In the Sum it shows what case
Category B | 16
Category B | 17 |  |  |  | Simply change the filter to show category A
Category B | 18
Category B | 19 |  |  |  | You can do the Min or [NAME] for the Rows to get all your answers.
Category B | 20 |  |  |  | You will need to refresh your pivot table after the Rand() changes.
Category B | 21
Category B | 22
Category B | 23
Category B | 24
Spreadsheet: 856098d1705481871-find-the-index-of-last-zero-after-which-the-entries-start-increasing-help-with-formula-aligw-and-hd
Sheet: Sheet1

 | 150 | 140 | 130 | 120 | 110 | 105 | 100 | 95 | 90 | 85 | 80 | 78 | 76 | 74 | 72 | 70 | 68 | 66 | 64 | 62 | 60 | 59 | 58 | 57 | 56 | 55 | 54 | Determined Index
Series 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 10 | 14 | 0 | 15 | 19 | 20
series 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 9 | 10 | 15 | 18 | 18 | 18 | 20
 | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 125 | 130 | 135 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | [NAME] | [NAME]
Series 1 | 20 | 20 | 20 | 16 | 18 | 17 | 15 | 18 | 15 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
series 2 | 20 | 20 | 20 | 20 | 18 | 18 | 17 | 17 | 17 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 0d41bb23-8375-4278-81e9-a3475816f4ad
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 36. LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), 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 | A2413895X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413896A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413897C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413898F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413899J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413900F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413901J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413902K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413903L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413904R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413905T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413906V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413907W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413908X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413909A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413910K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 752928d1635105308-concat-if-concat-if-test
Sheet: Sheet1

Ticker | Ticker letter count | External pull syntax
QQQ
FKDNX
F
MSFT
MTUM
FBALX
PRWCX
FPACX
ACEIX
Spreadsheet: 189322d1351159061-stacked-bar-chart-with-s-stackedbarchartquestion
Sheet: Sheet1

ReportDate | Daily Visits | Returns
2012-09-15 00:00:00 | 0 | 0
2012-09-16 00:00:00 | 1 | 0
2012-09-17 00:00:00 | 0 | 0
2012-09-18 00:00:00 | 0 | 0
2012-09-19 00:00:00 | 10 | 0.2
2012-09-20 00:00:00 | 23 | 0.130434782608696
2012-09-21 00:00:00 | 222 | 0.0765765765765766
2012-09-22 00:00:00 | 336 | 0.119047619047619
2012-09-23 00:00:00 | 359 | 0.133704735376045
2012-09-24 00:00:00 | 518 | 0.111969111969112
2012-09-25 00:00:00 | 538 | 0.087360594795539
2012-09-26 00:00:00 | 252 | 0.0595238095238095
2012-09-27 00:00:00 | 223 | 0.0852017937219731
2012-09-28 00:00:00 | 230 | 0.0521739130434783
2012-09-29 00:00:00 | 7 | 0.571428571428571
2012-09-30 00:00:00 | 4 | 0
2012-10-01 00:00:00 | 269 | 0.100371747211896
2012-10-02 00:00:00 | 184 | 0.114130434782609
2012-10-03 00:00:00 | 104 | 0.153846153846154
2012-10-04 00:00:00 | 46 | 0.152173913043478
2012-10-05 00:00:00 | 46 | 0.217391304347826
2012-10-06 00:00:00 | 37 | 0.135135135135135
2012-10-07 00:00:00 | 54 | 0.0185185185185185
2012-10-08 00:00:00 | 37 | 0.162162162162162
2012-10-09 00:00:00 | 12 | 0
2012-10-10 00:00:00 | 8 | 0.125
2012-10-11 00:00:00 | 2 | 0
2012-10-12 00:00:00 | 2 | 0
2012-10-13 00:00:00 | 2 | 0
2012-10-14 00:00:00 | 2 | 0
2012-10-15 00:00:00 | 3 | 0
2012-10-16 00:00:00 | 3 | 0
2012-10-17 00:00:00 | 2 | 0
2012-10-18 00:00:00 | 3 | 0
2012-10-19 00:00:00 | 5 | 0
2012-10-20 00:00:00 | 4 | 0
2012-10-21 00:00:00 | 4 | 0
Spreadsheet: 836655d1689565546-sum-up-until-a-blank-cell-appears-summations-update
Sheet: Sheet1

 |  |  | [NAME]  in D19
What I currently have
Room # | Room Name | Individual Size | Group size |  |  |  |  | Room # | Room Name | Individual Size | Group size
1-a | KITCHEN LEVEL 1 | 1300.888888888888 |  |  |  |  |  | 1-a | KITCHEN LEVEL 1 | 1300.888888888888
1-b | KITCHEN LEVEL 2 | 405.555555555555 |  |  |  |  |  | 1-b | KITCHEN LEVEL 2 | 405.555555555555
1-c | KITCHEN LEVEL 3 | 833.3333333333352 |  |  |  |  |  | 1-c | KITCHEN LEVEL 3 | 833.3333333333352
1-04 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  |  | 1-04 | PROGRAM LEVEL 1 | 309.9999999999972
 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  |  |  | PROGRAM LEVEL 1 | 309.9999999999972
1-d | PROGRAM LEVEL 2 | 1379.999999999999 |  |  |  |  |  | 1-d | PROGRAM LEVEL 2 | 1379.999999999999
1-e | PROGRAM LEVEL 3 | 309.9999999999997 |  |  |  |  |  | 1-e | PROGRAM LEVEL 3 | 309.9999999999997
1-f | LOBBY LEVEL 1 | 613.3333333333319 |  |  |  |  |  | 1-f | LOBBY LEVEL 1 | 613.3333333333319
1-g | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | 1-g | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
1-h | LOBBY LEVEL 2 | 275.555555555558 |  | This last part generates an #N/A |  |  |  | 1-h | LOBBY LEVEL 2 | 275.555555555558 |  | #N/A goes away if there is another row with info
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 |  |  |  |  |  |  |  | Test |  |  |  | but still shows up
Spreadsheet: 680690d1591140085-formula-to-calculate-minutes-with-conditions-of-data-from-another-sheet-time-different-por2gal-
Sheet: data

Sign on Time | Ignition on | [NAME] | Arrival start point | Route Start Time | Departed first stop
07:15:00 | 07:02:00 | 07:06:00 | 07:32:00 | 07:50:00 | 07:50:00
07:00:00 | 07:03:00 | 07:04:00 | 07:22:00 | 07:30:00 | 07:32:00
06:30:00 | 06:45:00 | 06:48:00 | 07:19:00 | 07:25:00 | 07:25:00
07:00:00 | 07:00:00 | 07:04:00 | 07:25:00 | 07:35:00 | 07:34:00
07:15:00 | 07:05:00 | 07:12:00 | 07:31:00 | 07:40:00 | 07:31:00
07:15:00 | 07:11:00 | 07:15:00 | 07:33:00 | 07:40:00 | 07:37:00
07:35:00 | 07:33:00 | 07:42:00 | 07:57:00 | 08:00:00 | 08:00:00
07:00:00 | 06:54:00 | 06:55:00 | 07:14:00 | 07:25:00 | 07:23:00
06:45:00 |  |  |  | 07:25:00
07:15:00 | 07:23:00 | 07:25:00 | 07:54:00 | 07:45:00 | 07:54:00
07:00:00 | 07:02:00 | 07:07:00 | 07:25:00 | 07:30:00 | 07:30:00
07:15:00 | 07:20:00 | 07:22:00 | 07:36:00 | 07:40:00 | 07:42:00
07:00:00 | 07:02:00 | 07:08:00 | 07:34:00 | 07:35:00 | 07:35:00
07:15:00 | 06:55:00 | 06:56:00 | 07:23:00 | 07:30:00 | 07:31:00
07:05:00 | 07:03:00 | 07:06:00 | 07:20:00 | 07:45:00 | 07:45:00
07:15:00 | 07:16:00 | 07:35:00 | 07:53:00 | 08:00:00 | 08:06:00
07:15:00 | 06:59:00 | 07:03:00 | 07:47:00 | 07:45:00 | 07:47:00
06:45:00 | 07:15:00 | 07:16:00 | 07:32:00 | 07:33:00 | 07:35:00
06:40:00 | 06:56:00 | 06:58:00 | 07:28:00 | 07:25:00 | 07:29:00
07:30:00 | 07:25:00 | 07:30:00 | 07:36:00 | 07:40:00 | 07:40:00
06:45:00 | 06:51:00 | 06:55:00 | 07:25:00 | 07:25:00 | 07:27:00
06:45:00 | 07:01:00 | 07:17:00 | 07:31:00 | 07:30:00 | 07:33:00
07:00:00 | 07:06:00 | 07:06:00 | 07:16:00 | 07:15:00 | 07:20:00
07:00:00 | 06:51:00 | 07:04:00 | 07:13:00 | 07:30:00 | 07:30:00
07:00:00 | 06:58:00 | 07:00:00 | 07:23:00 | 07:45:00 | 07:41:00
06:45:00 | 06:57:00 | 07:16:00 | 07:29:00 | 07:40:00 | 07:40:00
Spreadsheet: 707393d1607244507-find-last-product-sell-date-of-agent-sample5
Sheet: Sheet2

agent | last product sold on date | product number
375333
394833
308833
311833
313833
seach each agent number shown in sheet2 col.A in sheet2 and paste greatest date for each agent in col.B sheet2 with corresponding product number in col C sheet2
Spreadsheet: 386367d1427751684-concatenate-string-based-on-different-levels-example
Sheet: help

Level 1 | Level 2 | Level 3 | Level 4 | Level 5 | Level 6 |  | AM
 | AM
 |  | AM10
 |  | AM20
 |  | [NAME]
 |  | AM40
 |  | AM50
 |  | AM60
 |  | AM70
 |  | AM00
 | DC |  |  |  |  |  | N/A
 |  | DC_VD |  |  |  |  | N/A
 |  |  | DC001 |  |  |  | N/A
 |  |  | DC002_TOT |  |  |  | N/A
 |  |  |  | DC002 |  |  | N/A
 |  |  |  | DC002_VOD |  |  | N/A
 |  |  | DC003 |  |  |  | N/A
 |  |  | DC052 |  |  |  | N/A
Spreadsheet: 39127d1237327622-if-vlookup-payroll
Sheet: Time Card

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TIMECARD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee
 |  |  | Employee |  |  |  |  |  |  |  |  | YTD Hours |  |  |  |  |  |  |  | [NAME]
 |  |  | Name |  |  |  | Emp # |  |  |  |  | Regular | 1.875 |  | Sick Days Earned | 2346.411764705882 |  |  |  | [NAME]
 |  |  | Position |  |  |  | SSN |  |  |  |  | Overtime | #N/A |  | Sick Days Used |  |  |  |  | [NAME]
 |  |  | Date Hired |  |  |  | Pay Category |  |  |  |  | Double Time | #N/A |  | Vacation Earned | 2346.411764705882 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Sick | 24 |  | Vacation Used |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Vacation | 16 |  |  |  |  |  |  | [NAME] 6
 |  |  | Pay Period
 |  |  | From: | 2009-01-01 00:00:00 |  |  | To: | 2009-01-14 00:00:00
 |  |  |  |  |  |  |  |  | Regular | Weekend | Holiday | Sick | Vacation
 |  |  | DATE | TYPE | TIME IN | TIME OUT | LUNCH | Total Hours | Regular Hours | Overtime Hours | Double Time Hours | Sick | Vacation | Remarks
 |  |  | 2009-01-01 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15:00:00 | 0.625
 |  |  | 2009-01-02 00:00:00 | Weekend | 06:00:00 | 22:00:00 | 1 | 15:00:00
 |  |  | 2009-01-03 00:00:00 | Holiday | 06:00:00 | 22:00:00 | 1 | 15:00:00
 |  |  | 2009-01-04 00:00:00 | Sick | 06:00:00 | 22:00:00 | 1 |  |  |  |  | 8
 |  |  | 2009-01-05 00:00:00 | Vacation | 06:00:00 | 22:00:00 | 1 |  |  |  |  |  | 8
 |  |  | 2009-01-06 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15:00:00 | 0.625
 |  |  | 2009-01-07 00:00:00 | Weekend | 06:00:00 | 22:00:00 | 1 | 15:00:00
 |  |  | 2009-01-08 00:00:00 | Holiday | 06:00:00 | 22:00:00 | 1 | 15:00:00
 |  |  | 2009-01-09 00:00:00 | Sick | 06:00:00 | 22:00:00 | 1 |  |  |  |  | 8
 |  |  | 2009-01-10 00:00:00 | Vacation | 06:00:00 | 22:00:00 | 1 |  |  |  |  |  | 8
 |  |  | 2009-01-11 00:00:00 | Regular | 06:00:00 | 22:00:00 | 1 | 15:00:00 | 0.625
 |  |  | 2009-01-12 00:00:00 | Weekend | 06:00:00 | 22:00:00 | 1 | 15:00:00
 |  |  | 2009-01-13 00:00:00 | Holiday | 06:00:00 | 22:00:00 | 1 | 15:00:00
 |  |  | 2009-01-14 00:00:00 | Sick | 06:00:00 | 22:00:00 | 1 |  |  |  |  | 8
 |  |  |  |  |  |  | Totals | 5.625 | 1.875 |  |  | 24 | 16
 |  |  |  |  |  |  | Date |  |  | Signature
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Account Code | Account Code
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <>
Spreadsheet: benjamin_rogers__1036__Consolidated 6 Peaker- 051100-NewPrices
Sheet: CF

ANNUAL CASH FLOW AND IRR
GENCO CASH FLOW
('000 $) | Close | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Check
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00
EBITDA | 0
Plus Property Tax Liability | 0
Less Property Tax Expense | 0 | -1959.1981014
Less Principal Payments | 0
Less Interest Payments | 0
Pre Tax Cash Flow
GenCo's State Tax Benefit / (Expense) | 0
GenCo's Federal Tax Benefit / (Expense) | 0
After Tax Cash Flow
IRR Calculation
('000 $) | Close | 2001
Equity Partner's Contribution |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Equity Partner's Cashflow with No Residual Value
Equity Partner's Net Cashflow
IRR
Equity Partner's Contribution
Equity Partner's Cashflow
Salvage Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Equity Partner's Net Cashflow
IRR
EBITDA Valuation
EBITDA
Discount Rate
NPV
Check
Spreadsheet: 2b93ee27-f5a1-45e4-9bfd-2af6a9ef487c
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-09-23 10:18:11.140000
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.375 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.615 | 101.49 | 101.365 | 100.99
4.125 | 101.205 | 101.08 | 100.955 | 100.58 |  | Note: | Refer To Price [NAME]
4 | 100.844 | 100.719 | 100.594 | 100.219 |  |  | For all Price Adjs
3.875 | 100.324 | 100.199 | 100.074
3.75 | 99.431 | 99.306 | 99.181
 |  |  |  |  |  | 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
3.375 | 101.33 | 101.205 | 101.08 | 100.705
3.25 | 100.775 | 100.65 | 100.525 | 100.15
3.125 | 99.169 | 99.044 | 98.919 | 98.544
3 | 98.846 | 98.721 | 98.596 | 98.221
 |  |  |  |  |  | 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-10-07 10:18:11.140000
30 DAY | 2011-10-22 10:18:11.140000
45 DAY | 2011-11-06 10:18:11.140000
60 DAY | 2011-11-21 10:18:11.140000
90 DAY | 2011-12-21 10:18:11.140000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 02760de4-5028-4c96-b791-9d7939089959
Sheet: Extract

CODE | PER | ENPLANED DOM | ENPLANED INT | ENPLANED COM | ENPLANED TOT | TOTAL PAX | TOTAL INTL | TRANSIT PAX | NON-REV PAX | [NAME] | DEPLANED FRT | TOT FREIGHT | ENPLANED ML | DEPLANED ML | TOT FRT/ML | INTL FRT | DOM PAX A/C | DOM ALL CGO | INT PAX A/C | INT ALL CGO | COMMUTER | GA | MILITARY | TOT A/C OPS | EnpDom-1 | EnpInt-1 | EnpCom-1 | EnpTot-1 | TotPax-1 | TotInt-1 | Transit-1 | NonRev-1 | EnpFrt-1 | DepFrt-1 | TotFrt-1 | EnpMail-1 | DepMail-1 | TotF/M-1 | INTLFRT-1 | DomPaxAC-1 | DomAll-1 | IntPax-1 | IntAll-1 | Commuter-1 | GA-1 | Mili-1 | TotA/COps-1 | STATE | INTLML | INTLML-1 | ENTRYDATE | DATEMODIFIED
CHECK
Spreadsheet: andrea_ring__32__ENRONGAS(1200)
Sheet: FAXES

 |  |  | 14000 Quail Springs Parkway |  |  | Telephone | 405  749-1300
 |  |  | Suite 600 |  |  | Fax | 405  749-6661
 |  |  | Oklahoma City, Oklahoma
 |  |  | 73134-2600
 |  |  | FAX COVER SHEET
[NAME] |  |  | Date:
 |  |  | _____________________________
Natural Gas
 |  |  | Number of pages including cover sheet: _____
 |  |  | To:   ________________________________________________________________ | [NAME] |  | ___________________________ | ___________________________
 |  |  | Company:   __________________________________________________________ |  | ENRON CAPITAL & TRADE |  |  | _________________
 |  |  | Phone:  _______________________  Fax number:   _________________________ | [PHONE] | ________ | Fax Number: ________ |  | [PHONE] | _______
 |  |  | CC:  ________________________________________________________________
 |  |  | From:   _____________________________________________________________ | CELIA GIBSON  ________ |  | _____________________________________________
 |  |  | Phone:  _______________________  Fax number:   _________________________ | 405-748-2736____________ |  | Fax Number: _______ |  | [PHONE]  ________
 |  |  | REMARKS:     ___ Urgent     ___ For your review    ___ Reply ASAP    ___ Please comment