tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120613d1315407958-need-a-formula-to-add-certain-columns-together-copy-of-115-monks-park
Sheet: Sheet1

SOR Code | Description | SOR | Quantity | SOR Total | SOR -20%
 | Works as per original order 3903172/1
 | Works completed
 | General
730009 | Void:Safety check and test gas installation | 32.4 | 1
730005 | Void:Test and commission central heating system | 21.6 | 1
391301 | Nightlatch: Renew complete | 44.02 | 1
730011 | Void:Temporary cap gas supply | 10.64 | 1
740003 | Cooker:Disconnect seal cap make safe | 6.54 | 1
460028 | Garden: Cut grass NE 100mm | 1.29 | 40
335003 | Door: Ease Adjust Rehang internal new butts | 18.28 | 1
318117 | Window:Ease and Adjust PVCU | 6.62 | 2
450007 | Room: Redecorate 15-20sm Ceiling area | 241.86 | 1
436209 | Window:Prepare paint metal NE 1.50sm | 14.6 | 1
630113 | Sink: Renew NE 42mm combination waste | 38.85 | 2
318117 | Window:Ease and Adjust PVCU | 6.62 | 1
630513 | WC pan:Renew seat complete | 26 | 1
631125 | Shower: Renew curtain | 23.07 | 1
Manual | Locate and repair water hammer | 23.84 | 3
631337 | Tap: Renew bath mixer with shower attachment | 88.38 | 1
318117 | Window:Ease and Adjust PVCU | 6.62 | 2
335003 | Door: Ease Adjust Rehang internal new butts | 18.28 | 1
318117 | Window:Ease and Adjust PVCU | 6.62 | 2
318117 | Window:Ease and Adjust PVCU | 6.62 | 2
335003 | Door: Ease Adjust Rehang internal new butts | 18.28 | 1
415013 | Plaster repair: Repair crack to wall or ceiling | 5.46 | 3
Manual | To get electric key charged | 23.84 | 1
 | Charge Electric key |  |  |  | 20
 |  |  |  | Sub total | 711.65
 |  |  |  | VAT @ 20% | 142.33
 |  |  |  | Total | 853.98
Spreadsheet: 788205d1658325029-extracting-names-into-respective-columns-name_extraction_sample
Sheet: Sheet1

No. | Example | Prefix | First Name(s) | Nickname | Middle Name(s)/Initial(s) | Surname | Suffix(es) |  | Honorific | First | Others | Nickname | Surname | Suffixes |  | Sir
1 | [NAME] |  | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Mr.
2 | [NAME] the Magnificent |  | [NAME] |  |  | the Magnificent |  |  |  |  |  |  |  |  |  | The Rt. Hon.
3 | [NAME] Stratvert |  | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  | [NAME].
4 | [NAME] |  | [NAME] |  |  | [NAME]
5 | [NAME] Stratvert |  | [NAME] |  | [NAME] | [NAME]
6 | [NAME] "Kevkorr" Armstrong Stratvert |  | [NAME] | [NAME] | [NAME] | [NAME]
7 | [NAME] |  | [NAME] |  | [NAME] | [NAME]
8 | [NAME], Jr. |  | [NAME] |  | [NAME] | [NAME] | Jr.
9 | [NAME] Stratvert |  | [NAME] |  | [NAME] | [NAME]
10 | [NAME], Jr. |  | [NAME] |  | [NAME] | [NAME] | Jr.
11 | [NAME], Jr. |  | [NAME] |  | [NAME] | [NAME] | Jr.
12 | Mr. [NAME] Armstrong Stratvert | Mr. | [NAME] |  | [NAME] | [NAME]
13 | Mr. [NAME] | Mr. | [NAME] |  | A. | [NAME]
14 | Sir [NAME] | Sir | [NAME] |  | A. | [NAME]
15 | The Rt. Hon. [NAME], MP | The Rt. Hon. | [NAME] |  | [NAME] | [NAME] | MP
16 | [NAME]. [NAME], Esq. | [NAME]. | [NAME] |  | [NAME] | [NAME] | Esq.
17 | The Rt. Hon. [NAME], MP [NAME] | The Rt. Hon. | [NAME] |  | [NAME] | [NAME] | MP QC
Spreadsheet: darrell_schoolcraft__7347__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2002-01-22 00:00:00
 |  |  | SoCal Gas Price |  | 2.165
 |  |  | San Juan Gas Price |  | 2.025
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 245 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 260 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 260 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 260 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 260 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 260 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 260 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 260 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 260 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 260 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 260 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 260 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 260 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 260 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 260 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 260 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 260 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 245 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 245 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 245 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 245 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 245 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 245 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 245 | 7
Spreadsheet: 454049d1459610611-turning-check-in-and-out-dates-into-number-of-rooms-per-night-for-rooming-lists-example-rooming-list
Sheet: Sheet1

I want to be able to put in a list like this:
Number of PPL | Fname | Lname | Check In | Check Out | Room Nights
1 | [NAME] | Smith | 2016-04-11 00:00:00 | 2016-04-15 00:00:00
 | [NAME] | Ballentine | 2016-04-03 00:00:00 | 2016-04-08 00:00:00
 | [NAME] | Hammer | 2016-04-03 00:00:00 | 2016-04-08 00:00:00
 | Alfred | Newman | 2016-04-03 00:00:00 | 2016-04-16 00:00:00
 | Elena | [NAME] | 2016-04-03 00:00:00 | 2016-04-09 00:00:00
 | [NAME] | [NAME] | 2016-04-04 00:00:00 | 2016-04-08 00:00:00
…and not have to enter 1s to figure out how to….
First Name | Last Name | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00 | 2016-04-09 00:00:00 | 2016-04-10 00:00:00 | 2016-04-11 00:00:00 | 2016-04-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-14 00:00:00 | 2016-04-15 00:00:00 | Total Nights per Person
[NAME] | Smith | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0
[NAME] | Ballentine | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Hammer | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Alfred | Newman | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Elena | [NAME] | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME] | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
…send the hotel a report like this:
Dates: |  | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-07 00:00:00 | 2016-04-08 00:00:00 | 2016-04-09 00:00:00 | 2016-04-10 00:00:00 | 2016-04-11 00:00:00 | 2016-04-12 00:00:00 | 2016-04-13 00:00:00 | 2016-04-14 00:00:00 | 2016-04-15 00:00:00 | Total Room Nights:
Totals By Night:
Spreadsheet: 866045d1712978205-lookup-find-search-formula-to-find-player-s-in-a-table-with-multiple-rows-and-columns-test-scenario2-eba
Sheet: Sheet1

Player | Coach |  |  |  |  | Coach | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
A |  |  |  |  | Round | 1 | C | A | F | V | A
B |  |  |  |  | Round | 2 | A
C |  |  |  |  | Round | 3
D |  |  |  |  | Round | 4
E |  |  |  |  | Round | 5
F |  |  |  |  | Round | 6
G |  |  |  |  | Round | 7
H |  |  |  |  | Round | 8
I |  |  |  |  | Round | 9 |  |  |  |  |  |  | A1
J |  |  |  |  | Round | 10
K |  |  |  |  | Round | 11 |  | V
L |  |  |  |  | Round | 12
M |  |  |  |  | Round | 13 |  |  |  | A1
N |  |  |  |  | Round | 14
O |  |  |  |  | Round | 15
P |  |  |  |  | Round | 16
Q |  |  |  |  | Round | 17
R |  |  |  |  | Round | 18
S
T
U
V
W
X
Y
Z
A1
A2
A3
A4
A5
A6
A7
A8
A9
A10
A11
A12
A13
A14
A15
A16
A17
A18
A19
A20
A21
A22
Spreadsheet: 57246d1257362410-sum-up-a-row-of-numbers-based-on-another-cell-test-5
Sheet: test

 | Please choose your city | num1 | num2 | num3 | num4 | num5
 | Toledo | 10 | 20 | 10 | 3 | 6
 | Springfield | 0 | 0 | 0 | 0 | 0
 | Toledo | 4 | 6 | 9 | 2 | 1
 | Columbus | 9 | 7 | 3 | 1 | 4
 | Lima | 0 | 4 | 2 | 7 | 9
 | Springfield | 7 | 1 | 3 | 2 | 3
Totals
Toledo |  | 14 | 26 | 19 | 5 | 7
Springfield |  | 7 | 1 | 3 | 2 | 3
Columbus |  | 9 | 7 | 3 | 1 | 4
Lima |  | 0 | 4 | 2 | 7 | 9
Spreadsheet: 128297d1320902590-merging-data-from-different-worksheets-into-a-master-sheet-re-done-example
Sheet: Master

[NAME] | Apple | blackberry | [NAME] | Grape | peach | mango | Rockmelon | [NAME] | watermelon
China | 4 |  |  |  | 5 |  |  |  | 12
America | 3 | 4 |  | 53 |  | 23 |  | 1 | 123
Japan | 123 |  | 43 |  |  | 23 | 545 |  | 1233
China
America
Japan
Spreadsheet: 44637d1243415053-calculating-age-of-open-cases-hours
Sheet: Sheet1

Start Date | End Date | Hours | Minutes
1998-03-02 00:00:00 | 1998-03-16 00:00:00 | 264 | 15840
1998-03-03 00:00:00 | 1998-03-13 00:00:00 | 216 | 12960
1998-04-27 00:00:00 | 1998-05-01 00:00:00 | 96 | 5760
 | Holidays
Bank Holiday | 1998-05-01 00:00:00
[NAME] | 1998-12-25 00:00:00
New Year | 1997-01-01 00:00:00
New Year | 1998-01-01 00:00:00
New Year | 1999-01-01 00:00:00
Spreadsheet: 47188d1246098846-move-row-on-cell-change-lookup-from-y_n
Sheet: Sheet2

question 1 | no | reply 1 | stuff 1 | bits 1
question 2 | no | reply 2 | stuff 2 | bits 2
question 3 | no | reply 3 | stuff 3 | bits 3
question 5 | no | reply 5 | stuff 5 | bits 5
question 8 | no | reply 8 | stuff 8 | bits 8
question 10 | no | reply 10 | stuff 10 | bits 10
question 12 | no | reply 12 | stuff 12 | bits 12
Spreadsheet: 126626d1319793777-sumproduct-looking-up-date-and-text-values-sumproduct
Sheet: Sheet1

Month | Outcome |  |  |  |  | 2011-06-11 00:00:00 | 2011-07-11 00:00:00 | 2011-08-11 00:00:00 | 2011-09-11 00:00:00 | 2011-10-11 00:00:00 | 2011-11-11 00:00:00 | 2011-12-11 00:00:00 | 2012-01-12 00:00:00 | 2012-02-12 00:00:00 | 2012-03-12 00:00:00 | 2012-04-12 00:00:00
2011-06-11 00:00:00 | Appointment Accepted |  |  |  | Appointment Accepted | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0
2011-06-11 00:00:00 | Telephone Update |  |  |  | Telephone Update | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0
2011-07-11 00:00:00 | Review Declined |  |  |  | Review Declined | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1
2011-08-11 00:00:00 | Appointment Accepted
2011-09-11 00:00:00 | Telephone Update
2011-10-11 00:00:00 | Review Declined
2011-11-11 00:00:00 | Appointment Accepted
2011-12-11 00:00:00 | Telephone Update
2012-01-12 00:00:00 | Review Declined
2012-02-12 00:00:00 | Appointment Accepted
2012-03-12 00:00:00 | Telephone Update
2012-04-12 00:00:00 | Review Declined
Spreadsheet: 762457d1641565795-help-with-formula-power-query-to-measure-the-precision-of-codes-power-query-for-precision-by-code-modified
Sheet: Input

ctextid | vbillid | agentcode | predictcode
4512 | 231 | A202,A203 | A314,A202,D123
7678 | 235 | A415,A203 | A415,A203,A202
7781 | 213 | D123,E124,F341,A202 | D123,E124,A303,A415
8123 | 214 | D123, F341,A203 | F341,A415
Spreadsheet: daren_farmer__6653__CES - April
Sheet: Avails 4-1 

[NAME] (PennzEnergy) South Texas Properties
2000-04-01 00:00:00
Pipeline | Location | [NAME] | Base | Swing | Total | WIO | Grand Total | Comments
[NAME] | [NAME] | Gulf Plains Plant | 8718 | 459 |  | 0
 | [NAME] | Gulf Plains Plant | 3132 | 165 |  | 0
Carthage | American Central | Tailgate | 64255 | 7139 |  | 1210 |  | 3500 makeup is taken out
 | [NAME] | Tailgate | 0 | 500 |  | 0
 | Ruby-Lacy | Tailgate | 0 | 250 |  | 0
 | [NAME] (Net of PVR)* | Tailgate | 9600 |  |  | 1858 |  | Gathering nomination on [NAME] gathering system as Pennzoil's agent
Corpus Christi Gas Gath. | Virginia | 3358 | 1009 | 88 |  | 0
Delhi (Koch Midstream) | Volpe | LL-1-0027 | 1179 | 102 |  | 0
 | [NAME] | LL-1-0027 | 41 | 4 |  | 7
 | Comitas C.P. | LL-1-0030 | 631 | 55 |  | 315
 |  |  |  |  |  |  |  | Termed up with Delhi (evergreen)
Gulf Energy | [NAME] | 19-1043-00 | 439 | 33 |  | 0 |  | Termed up with Gulf Energy (evergreen)
 | Comitas South | 440-559 | 857 | 74 |  | 446
 | Tejas Plant | 29320 | 106 | 9 |  | 4
 | Jennings 63 Plant | 440-565 | 6642 | 578 |  | 0 |  | Termed up with Tejas thru 12/00
 | Haynes Plant | 440-557 | 180 | 16 |  | 30 |  | MTM - Terminate for 4/99
 | Haynes 17, 18 | 23-603-01 | 1592 | 138 |  | 283
 | [NAME] | 31-504-04 | 4478 | 389 |  | 361
 | Garza Plant | 440-552 |  |  |  | 0 |  | Trevino Plant gas is sometimes re-routed through Garza Plant
 | [NAME] | 21-022-08 | 0 | 71 |  | 0
Lone Star | Sandtrap | 178477 | 3805 | 423 |  | 702 |  | Termed up with TXU Energy thru 11/00
Midcon Texas | [NAME] / TOC | 5553 | 353 | 27 |  | 0
 | Hall Plant | 5576 | 703 | 61 |  | 0
 | Jennings Ranch | 446 | 1229 | 107 |  | 0
Spreadsheet: a6f912df-f398-4f51-b712-cb655248d5dd
Sheet: Sheet1

35　収容所別　収容事由別入所人員 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
国籍 |  | 総数 |  | 東日本 |  | 西日本 |  | 大村
収容事由
総　　　　　　　　数 |  | -6075 | 13131 | -3796 | 8573 | -1110 | 2579 | -1169 | 1979
 | 不法入国・上陸 |  | 3839 |  | 2569 |  | 593 |  | 677
 | 在留資格を取り消された者 |  | 10 |  | 7 |  | 3 |  | 0
 | 資格外活動 |  | 337 |  | 168 |  | 119 |  | 50
 | 不法残留 |  | 8764 |  | 5754 |  | 1777 |  | 1233
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 181 |  | 75 |  | 87 |  | 19
韓　国　・　朝　鮮 |  | -1086 | 1850 | -686 | 1253 | -185 | 350 | -215 | 247
 | 不法入国・上陸 |  | 254 |  | 181 |  | 33 |  | 40
 | 在留資格を取り消された者 |  | 2 |  | 2 |  | 0 |  | 0
 | 資格外活動 |  | 52 |  | 22 |  | 28 |  | 2
 | 不法残留 |  | 1533 |  | 1042 |  | 286 |  | 205
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 9 |  | 6 |  | 3 |  | 0
中　　　　　　　国 |  | -2391 | 5404 | -1359 | 3426 | -425 | 921 | -607 | 1057
 | 不法入国・上陸 |  | 2025 |  | 1323 |  | 253 |  | 449
 | 在留資格を取り消された者 |  | 5 |  | 4 |  | 1 |  | 0
 | 資格外活動 |  | 135 |  | 60 |  | 45 |  | 30
 | 不法残留 |  | 3170 |  | 1996 |  | 606 |  | 568
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 69 |  | 43 |  | 16 |  | 10
フ　ィ　リ　ピ　ン |  | -1185 | 1814 | -787 | 1283 | -197 | 275 | -201 | 256
 | 不法入国・上陸 |  | 584 |  | 378 |  | 118 |  | 88
 | 在留資格を取り消された者 |  | 2 |  | 1 |  | 1 |  | 0
 | 資格外活動 |  | 65 |  | 45 |  | 11 |  | 9
 | 不法残留 |  | 1155 |  | 855 |  | 142 |  | 158
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 8 |  | 4 |  | 3 |  | 1
タ　　　　　　　　イ |  | -266 | 496 | -207 | 392 | -27 | 55 | -32 | 49
 | 不法入国・上陸 |  | 192 |  | 148 |  | 19 |  | 25
 | 在留資格を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 資格外活動 |  | 2 |  | 2 |  | 0 |  | 0
 | 不法残留 |  | 296 |  | 240 |  | 32 |  | 24
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 6 |  | 2 |  | 4 |  | 0
パ　キ　ス　タ　ン |  | 0 | 124 | 0 | 102 | 0 | 18 | 0 | 4
 | 不法入国・上陸 |  | 50 |  | 44 |  | 5 |  | 1
 | 在留資格を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 資格外活動 |  | 0 |  | 0 |  | 0 |  | 0
 | 不法残留 |  | 72 |  | 58 |  | 12 |  | 2
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 2 |  | 0 |  | 1 |  | 1
バングラデシュ |  | -7 | 219 | -6 | 193 | 0 | 17 | -1 | 9
 | 不法入国・上陸 |  | 106 |  | 93 |  | 9 |  | 4
 | 在留資格を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 資格外活動 |  | 3 |  | 1 |  | 2 |  | 0
 | 不法残留 |  | 108 |  | 99 |  | 4 |  | 5
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 2 |  | 0 |  | 2 |  | 0
そ　　　の　　　他 |  | -1140 | 3224 | -751 | 1924 | -276 | 943 | -113 | 357
 | 不法入国・上陸 |  | 628 |  | 402 |  | 156 |  | 70
 | 在留資格を取り消された者 |  | 1 |  | 0 |  | 1 |  | 0
 | 資格外活動 |  | 80 |  | 38 |  | 33 |  | 9
 | 不法残留 |  | 2430 |  | 1464 |  | 695 |  | 271
 | [NAME] |  | 0 |  | 0 |  | 0 |  | 0
 | 難民認定を取り消された者 |  | 0 |  | 0 |  | 0 |  | 0
 | 刑罰法令違反等 |  | 85 |  | 20 |  | 58 |  | 7
 | (注)　(　　　)内は女性であり，内数である。
Spreadsheet: 66579d1267206995-look-for-missing-numbers-between-sheets-missing-number
Sheet: Sheet2

 | 2
 | 2010-01-01 00:00:00
20m11 | 8
20M22 | 1
 | 0
 | 0
20M12 | 3
 | 0
 | 0
20m01 | 25
20m03 | 15
20m07 | 10
20m15 | 2
20m17 | 7
20m99 | 3
20t05 | 51
20t13 | 0
20t08 | 9
20t21 | 0
 | 0
 | 0
20M13 | 7.5
 | 0
 | 0
20m14 | 3
20M23 | 3
 | 0
 | 0
90F01 | 9
90F75 | 5
 | 0
 | 0
90H01 | 3
 | 0
 | 0
98P23 | 0
 | 0
 | 0
95G01 | 2.5
 | 0
 | 0
90L | 3
 | 0
 | 0
95G02 | 0
 | 0
 | 0
90i09 | 0
90R | 4
98P32 | 0
95Z02 | 1.5
20M20 | 2.5
95Z01 | 3
98P26 | 4
 | 0
 | 0
20T07 | 0
20M02 | 4
20M04 | 0
20M06 | 0
20M16 | 0
 | 0
20T01 | 3
20T02 | 2
20T03 | 6
20T04 | 2.5
20T06 | 2
20T10 | 6
20T11 | 3
20T12 | 5
20T16 | 2
20T17 | 4
20T99 | 0
20C01 | 17
20C02 | 5
20C03 | 3
20C04 | 0
20C05 | 0
20C06 | 0
20M05 | 1
20M09 | 1
20M18 | 5
20S01 | 3
90E01 | 0
90E02 | 0.5
90E03 | 8.5
90E07 | 3
90E99 | 1
10C01 | 0
95Z99 | 0
98P03 | 0
98P09 | 0
98P10 | 0
98P11 | 0
98P14 | 0
 | 0
 | 0
 | 0
Total | 272.5
checking | -11.5
Spreadsheet: richard_sanders__31745__Tick Analysis @ 14-Nov-00
Sheet: Summary

[NAME]
Damage Sensitivities
(Dollars in Thousands)
THIS INFORMATION IS CONFIDENTIAL PER SECTION 5 OF THE FACILITATION AGREEMENT
Base Case Plant Capacity (kW) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 263000
Base Case Discount Rate |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
Plant Capacity |  |  |  |  |  |  |  |  |  |  |  |  |  | 245 MW |  | 258 MW |  | 263 MW
Date of Measurement |  |  |  |  |  | 1996-12-31 00:00:00 |  | 2000-12-31 00:00:00 |  | 1996-12-31 00:00:00 |  | 2000-12-31 00:00:00 |  | 2000-12-31 00:00:00 |  | 2000-12-31 00:00:00 |  | 2000-12-31 00:00:00
 |  |  |  |  |  | ML Proforma |  |  |  | As Financed |  |  |  | As Financed |  | As Financed |  | As Financed
Question 1:
What equity value is implied under
Section 11.02(i)(a), both at inception
and point forward?
 | Excluding Interest Rate Adjustment
 | Less:  Project-Level Debt |  |  |  |  | 175275 |  |  |  | 150300.039051 |  | 145482.25
 | Less:  SWAP Unwind Costs |  |  |  |  | 0 |  | -6888 |  | 0 |  | -6888
 | Implied Equity Value
Question 2:
Status quo, what level of damages |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Base Case
is implied under Section 11.02(i)(a)?
 | Implied Equity Value
Question 3:
How would the answer to Question 2
change if the interest rate adjustment
to Capacity Payments was modified?
 | Implied Equity Value
Question 4:
How would the answer to Question 2
change if there were no interest rate
adjustment to Capacity Payments?
 | Implied Equity Value
 |  |  |  | Difference from Base Case (Assumes 12/31/00 Breach)
 |  |  |  | Status Quo
 |  |  |  | Modified i Adjustment
 |  |  |  | No i Adjustment
 |  |  |  |  |  |  |  | 258 |  | 5.7
 |  |  |  |  |  |  |  |  |  | 9500
 |  |  |  |  |  |  |  |  |  | 45000
Spreadsheet: 0706d92f-b8da-47c8-b364-45a9b3928d01
Sheet: Sheet1

Budget Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Totals |  | Expenses per month (% guide) |  | Totals
Earnings/income per month |  |  |  | 6.  Insurance (5% - 15%) | 0 | 0
Salary #1 (net take-home) | 1 |  |  | Auto
Salary #2 (net take-home) |  |  |  | Homeowner's/renter's
Other (less taxes) |  |  |  | Life
Total monthly income |  | 1 |  | Medical/dental
 |  |  |  | Other
Expenses per month (% guide)
1.  Giving - systematic (10%+) | 0 | 0 |  | 7.  Household/personal (15 - 25%) | 0 | 0
Church |  |  |  | Groceries
Other contributions |  |  |  | Clothes/dry cleaning
 |  |  |  | Gifts
2.  Savings (5 - 10%) | 0 | 0 |  | Personal:
Emergency |  |  |  | Cosmetics
Replacement |  |  |  | Haircuts
Long-term |  |  |  | Other
 |  |  |  | Other:
3.  Debt  (0 - 10%) | 0 | 0 |  | Books/magazines
Credit cards: |  |  |  | Allowances
Visa |  |  |  | Music lessons
Master [NAME] |  |  |  | Personal technology
Discover |  |  |  | Education
American Express |  |  |  | Miscellaneous
Gas cards
Department stores |  |  |  | 8.  Entertainment  (5 - 10%) | 0 | 0
 |  |  |  | Going out:
4.  Housing (25 - 38%) | 0 | 0 |  | Meals
Mortgage/taxes/rent |  |  |  | Movies/events
Maintenance/repairs |  |  |  | Babysitting
Utilities: |  |  |  | Travel (vacations/trips)
Electric |  |  |  | Other:
Gas |  |  |  | Fitness/sports
Water |  |  |  | Hobbies
Trash |  |  |  | Media rental
Telephone/Internet |  |  |  | Other
Cable TV
Other |  |  |  | 9.  Professional services (5 - 15%) | 0 | 0
 |  |  |  | Child care
5.  Auto/transportation (12 - 15%) | 0 | 0 |  | Medical/dental/prescriptions
Car payment/license |  |  |  | Other:
Gas and bus/train/parking |  |  |  | Legal
Oil/lube/maintenance |  |  |  | Counseling
Vehicle property tax |  |  |  | Professional dues
 |  |  |  | 10.  [NAME] expenses (2 - 3%) | 0 | 0
Subtotal (Items 1 - 5) |  | 0 |  | Subtotal (Items 6 - 10) |  | 0
 |  |  |  | Total expenses |  | 0
 |  |  |  | Total monthly income |  | 1
 |  |  |  | Less total expenses |  | 0
 |  |  |  | Income over/(under) expenses |  | 1
Note: The percentages are a portion of your total monthly income. Since they are presented in ranges, they will not add up to 100 percent. They are guidelines only
and may differ for individual situations. For instance, Everence is not recommending that you spend 10 percent of your income on credit card debt. However, budget debt
repayment into your plan if you have credit card debt. The same principle would apply to other expenses you regularly incur.
2111544
Spreadsheet: 6b8041ae-2064-400d-8c89-6fa6781cd753
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
COHBB | Test | COHBB | [NAME], Blood | [NAME], B | Carboxyhemoglobin-Co-oximetry | EDTA (lavender-top) tube: EDTA |  |  | 1 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 1 mL Collection Instructions: Avoid exposure of specimen to atmosphere. | 0.1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Normal Concentration Non-Smokers: 0-2% Smokers: < or =9% Toxic concentration: > or =20% | Monday through Friday; 12 a.m. | Same day/1 day | 2 days | 1 | 82375 |  |  |  |  | Rochester
COHBB | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Ambient | 14 days
COHBB | Result | 8649 | [NAME], B | [NAME], B | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 20563-3 | [NAME]/Hemoglobin.total:MFr:Pt:[NAME]:Qn:
Spreadsheet: 552656d1513700498-v-lookup-eror-vlook-up-1-
Sheet: result

No | PLAYER |  | PAR 3 | TOTAL |  | Back 9 | Back 6 | Back 3 | ATT |  |  |  | No | PLAYER |  | PAR 3 | TOTAL |  | Back 9 | Back 6 | Back 3 | PLAYING
1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  |  |  | 6
5 |  |  |  |  |  |  |  |  |  |  |  |  | 7
6 |  |  |  |  |  |  |  |  |  |  |  |  | 8
7 |  |  |  |  |  |  |  |  |  |  |  |  | 11
8 |  |  |  |  |  |  |  |  |  |  |  |  | 12
9 |  |  |  |  |  |  |  |  |  |  |  |  | 14
10 |  |  |  |  |  |  |  |  |  |  |  |  | 16
11 |  |  |  |  |  |  |  |  |  |  |  |  | 18
12 |  |  |  |  |  |  |  |  |  |  |  |  | 20
13 |  |  |  |  |  |  |  |  |  |  |  |  | 21
14 |  |  |  |  |  |  |  |  |  |  |  |  | 22
15 |  |  |  |  |  |  |  |  |  |  |  |  | 26
16 |  |  |  |  |  |  |  |  |  |  |  |  | 27
17 |  |  |  |  |  |  |  |  |  |  |  |  | 29
18 |  |  |  |  |  |  |  |  |  |  |  |  | 31
19 |  |  |  |  |  |  |  |  |  |  |  |  | 32
20 |  |  |  |  |  |  |  |  |  |  |  |  | 33
21 |  |  |  |  |  |  |  |  |  |  |  |  | 33
22 |  |  |  |  |  |  |  |  |  |  |  |  | 33
23 |  |  |  |  |  |  |  |  |  |  |  |  | 33
24 |  |  |  |  |  |  |  |  |  |  |  |  | 33
25 |  |  |  |  |  |  |  |  |  |  |  |  | 33
26 |  |  |  |  |  |  |  |  |  |  |  |  | 33
27 |  |  |  |  |  |  |  |  |  |  |  |  | 33
28 |  |  |  |  |  |  |  |  |  |  |  |  | 33
29 |  |  |  |  |  |  |  |  |  |  |  |  | 33
30 |  |  |  |  |  |  |  |  |  |  |  |  | 33
31 |  |  |  |  |  |  |  |  |  |  |  |  | 33
32 |  |  |  |  |  |  |  |  |  |  |  |  | 33
33 |  |  |  |  |  |  |  |  |  |  |  |  | 33
34 |  |  |  |  |  |  |  |  |  |  |  |  | 33
35 |  |  |  |  |  |  |  |  |  |  |  |  | 33
36 |  |  |  |  |  |  |  |  |  |  |  |  | 33
37 |  |  |  |  |  |  |  |  |  |  |  |  | 33
38 |  |  |  |  |  |  |  |  |  |  |  |  | 33
39 |  |  |  |  |  |  |  |  |  |  |  |  | 33
40 |  |  |  |  |  |  |  |  |  |  |  |  | 33
41 |  |  |  |  |  |  |  |  |  |  |  |  | 33
42 |  |  |  |  |  |  |  |  |  |  |  |  | 33
43 |  |  |  |  |  |  |  |  |  |  |  |  | 33
44 |  |  |  |  |  |  |  |  |  |  |  |  | 33
45 |  |  |  |  |  |  |  |  |  |  |  |  | 33