tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 221789d1363669037-data-auto-fill-from-sheet2-and-sheet3-to-sheet1-test
Sheet: Sheet1

 | C.E.T.P. CHARGES BREAK UP
Customer Name : |  | I want here customer name……from sheet2 (i.e. cadila healthcare ltd.)
 |  | Whenever I change the customer name (In cell C2)…... Only those customers data should shown below….
For the month of: |  | If I choose here January 2013 ( then only [NAME]'s data should shown..(i.e.01-01-2013 to 31-01-2013)
Sr. No. | Date | Manifest No. | Total Tanker | Total COD PPM | Total [NAME] | Total Tanker Rs. | Total Testing of Tanker Rs. | Total COD per Rs.
Automatic | From sheet2 (B column) | From sheet2 (C column) | Only Tested Tanker count (from sheet3) if not tested then figure is ZERO ( please refer sheet3 A110 row | From sheet3 (F column) | From sheet3
 |  |  | Whatever the data is generatd in upper format….. I want the sum that data in last row….
Spreadsheet: 2dbb8d11-a7ef-4824-b9f2-3d861fe3d748
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Bates | Cathy | [EMAIL] | [PHONE] |  | Information Technology Services | Raley Hall | Boone | NC | 28608
East Carolina University | Sweet | [NAME] | [EMAIL] | [PHONE] | [PHONE] | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Scott | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Office of Information Technology | 227 Information Technology Center | Elizabeth City | NC | 27909
Fayetteville State University | Ganesan | Nick | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Ellis | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | Smith | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University |  |  |  |  |  |  |  | Raleigh | NC | 27695
UNC Asheville | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Kielt | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Carlin | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Clotfelter | [NAME] | [EMAIL] | [PHONE] | [PHONE] | POB 26170 |  | Greensboro | NC | 27402-6170
UNC Pembroke | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Kraus | Leah | [EMAIL] | [PHONE] |  | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main Street |  | Winston-Salem | NC | 27127
Western Carolina University | Fowler | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Cullowhee | NC | 28723
Winston-Salem State University | McKenzie | Justin | [EMAIL] | [PHONE] | [PHONE] |  |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | Alston | [NAME] | [EMAIL] | [PHONE] |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 750300d1633373376-transposing-a-vertical-list-automatically-after-pasting-it-in-a-column-xxxxxxxx
Sheet: XXXXXXXX

 |  | LAST NAME: | FIRST NAME: | MIDDLE INITIAL: | EMAIL: | CONTACT NUMBER: | BASE | DOH | CONCERN
LAST NAME: | WASHINGTON | WASHINGTON | GEORGE | M | [EMAIL] | [PHONE] | dallas | 1976-07-04 00:00:00 | injury
FIRST NAME: | GEORGE
MIDDLE INITIAL: | M
EMAIL: | [EMAIL]
CONTACT NUMBER: | [PHONE]
BASE: | dallas
DATE OF HIRE (mm/dd/yyyy): | 1976-07-04 00:00:00
concern: | injury
linebreak
LAST NAME: | [NAME]
FIRST NAME: | [NAME]
MIDDLE INITIAL: | k
EMAIL: | [EMAIL]
CONTACT NUMBER: | [PHONE]
BASE: | Orlando
DATE OF HIRE (mm/dd/yyyy): | 2007-03-13 00:00:00
concern: | medical
linebreak
Spreadsheet: 123677d1317803795-find-value-by-testing-sums-in-a-range-solver_find_invoice
Sheet: Matrix_setup

 |  |  | Invoices |  |  |  | Binary help matrix |  |  |  | Cells to combine
 |  | 10 | 5 | 3
 |  | 5 | 18 | 2
 |  | 6 | 20 | 8
 |  | Object f | 15 |  |  | [NAME] help matrix |  | 0
 |  | Target | 15
 |  | Cells to combine:
 |  | To test this model put your target number in cell C11 and run Solver.
 |  | To do a rerun I would recommend you clear the range G4 to I6 prior to
 |  | running Solver.
 |  | If you want to "influence" the number of invoices needed to reach your target sum
 |  | you can do so by adding a constraint i.e. In solver add cell I9 and chose
 |  | a suitable constraint "<=, =, =>" and a number.
Spreadsheet: 104467d1302057894-how-to-compute-allocation-based-on-date-range-dystop1a_alloc
Sheet: Sheet1

Term 1 | 2009-04-27 00:00:00 | 2010-04-26 00:00:00
Term 2 | 2010-04-27 00:00:00 | 2011-04-26 00:00:00
Date | Result |  | For explanation of this undocumented function DATEDIF, click here
2009-06-17 00:00:00 | 1.666666666666667
2009-12-07 00:00:00 | 6.666666666666667
2009-12-28 00:00:00 | 7.5
2010-02-18 00:00:00 | 8.333333333333334
2010-02-19 00:00:00 | 8.333333333333334
2010-02-24 00:00:00 | 8.333333333333334
2010-03-18 00:00:00 | 9.166666666666668
2010-04-12 00:00:00 | 10
2010-04-12 00:00:00 | 10
2010-06-16 00:00:00 | 1.666666666666667
2010-07-21 00:00:00 | 2.5
2010-07-28 00:00:00 | 3.333333333333333
2010-07-28 00:00:00 | 3.333333333333333
2010-10-14 00:00:00 | 5
2010-12-13 00:00:00 | 6.666666666666667
 | 8.333333333333334
2011-03-14 00:00:00 | 9.166666666666668
2011-03-23 00:00:00 | 9.166666666666668
Spreadsheet: 1281a09a-e7f7-4c0c-81c2-63e664b92a65
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 7. LEASE AND COMMERCIAL FINANCE COMMITMENTS, Stocks and Flows: 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
Lease Finance - Total commitments ; |  |  | Original | A2413496R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Lease Finance - Commitments not drawn at end of month ; |  |  | Original | A2413497T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Revolving Credit - New and increased credit limits ; |  |  | Original | A2413498V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Revolving Credit - Cancellations and reductions ; |  |  | Original | A2413499W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Revolving Credit - Total credit limits at end of month ; |  |  | Original | A2413500V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Revolving Credit - Credit used at end of month ; |  |  | Original | A2413501W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 0235aaa2-d8f2-40b0-8fa0-989c02401e1a
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 | Unnamed: 12 | Unnamed: 13
Attachment C - Bid Application Form - PON 2484
Proposal Title: |  |  |  |  |  |  |  |  |  |  |  | Due Date:
Company:
Identify Eligible Technology:
Incentive Guidelines
When this form is completed using Microsoft Excel, Section 2 fields are calculated based on inputs in
Section 1.
Total Dollar Amount must not exceed $3,000,000.
The Incentive Bid is the basis for the price evaluation portion of the proposal.
Performance Period will be 3 yrs.
Section 1 - To Be Completed by Applicant
Select One:
 | NYISO Zone Group G&H |  |  |  |  |  |  |  | Select ONLY one Zone Group
 | NYISO Zone Group I&J
Capacity Block |  |  |  | PV: |  |  |  | kW
 |  |  |  |  |  | or |  |  | Fill out ONLY one Capacity Block
 |  |  | Renewable Biogas: |  |  |  |  | kW
[NAME] |  |  |  |  |  |  |  | $/kWh
Estimated Installed Costs of Capacity Block
Section 2 - Auto-Calculated
Total Dollar Amount |  |  |  |  |  | 0 |  | for PV installations
(Must not exceed $3,000,000)
 |  |  |  |  |  | 0 |  | for Renewable Biogas installations
% Total Dollar Amount of Estimated Installed Costs of Capacity Block |  |  |  |  |  |  |  | %
(Must not exceed 50%)
Note: Total Dollar Amount is calculated based on an assigned capacity factor of 11% for PV and 75% for Renewable Biogas installations
The Applicant is responsible for the accuracy of the information provided on this form.
Applicant Signature:_________________________________________________Date:____________________
 |  |  |  |  |  | Exceeds limit
 |  |  |  | PV |  | 0 |  |  | RB | 0
 |  |  |  |  |  | Select ONLY one Zone Group |  |  |  |  | Select ONLY one technology
 |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | Exceeds 50%
Spreadsheet: 487329d1478021463-reading-age-problem-with-minus-ages-test-data-2
Sheet: NGRT Digital Results Yr 2 Sept

Age at test  in Months | Age at Test in YY:MM | Reading Age | Reading Age | Reading Age Difference
79 |  | 06:08:00
81 |  | 07:01:00
75 |  | 06:04:00
80 |  | 06:07:00
83 |  | 06:10:00
73 |  | 05:10:00
80 |  | 06:04:00
78 |  | 06:01:00
77 |  | 05:10:00
81 |  | 06:02:00
81 |  | 06:00:00
75 |  | 05:05:00
84 |  | 05:09:00
82 |  | 05:05:00
80 |  | 05:02:00
77 |  | 05:00:00
77 |  | 05:00:00
79 |  | 05:00:00
77 |  | 05:00:00
72 |  | 05:00:00
Spreadsheet: 868326d1715057332-in-a-column-the-text-values-is-not-generating-the-result-using-if-but-get-result-for-date-sample
Sheet: Sheet1

SWIFT Remediation Target Date | Condition | Output
To receive extended support evidence by 31Mar24 | If A2="To receive extended support evidence by 31Mar24" or Datevalue<15/07/2024 | in progress
2024-09-30 00:00:00 | if A3>15/07/2024 | Data set beyound 15Jul2024
2024-03-31 00:00:00 | if A4<=15/07/2024 | in progress
Upgraded 19.8.0.2.Build.86 | if A5=<Any text like A5> then | Under Validation
Uninstalled |  | Under Validation
TBD | if A7="TBD" or "TBD-CIO to review existing correspondence" | TBD
Upgraded to 5.9.1-329 |  | Under Validation
2024-04-30 00:00:00 | if A4<=15/07/2024 | in progress
2024-12-31 00:00:00 | if A4<=15/07/2024 | in progress
2024-11-30 00:00:00 | if A4<=15/07/2024 | in progress
2024-05-31 00:00:00 | if A4<=15/07/2024 | in progress
Decommissioned - CHG0418718 |  | Under Validation
2024-02-29 00:00:00 | if A4<=15/07/2024 | in progress
TBD-review existing correspondence | if A7="TBD" or "TBD-review existing correspondence" | TBD
Spreadsheet: 703775d1605171093-changing-a-single-point-of-data-into-a-row-of-data-merging-identical-items-into-total-forum-hlp-sht
Sheet: Working out sheet

Part code | Production line | Full Part Number | Pallet [NAME] contents |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | TOTAL |  |  |  |  | pallets | per pallet | part pallet1 | part pallet2 | part pallet3 | part pallet4 | part pallet5
6000 | 32 | MpXX34-222222XC | 340 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpXX34-222222XC | 3 | 340 | 21
6000L | 32 | MpWE23-343434XC | 165 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpWE23-343434XC | 9 | 165
2001 | 32 | MpQW23-343421CR | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpQW23-343421CR | 3 | 200 | 34
2016 | 32 | PPP8P4-343422DR | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PPP8P4-343422DR | 0 | 0 | 33
This clm filled via [NAME] from linked sheet |  | This clm filled via [NAME] from linked sheet | This clm filled via [NAME] from linked sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MpXX34-222222XC | 1 | 300 | 56
 |  |  |  |  |  |  |  | Could be over 70 pallets for each part in several locations (22 put here for brevity) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The part highlighted is a dupe of the first line, I need to include this in the first line data but cannot get [NAME] to return data from two lines in the stock check….
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I will grab the part no above from the matching line in clm C then Vlookup the other figures from my stock check sheet
 |  | Could be 300+ rows below these each with different parts
Spreadsheet: 747789d1631702166-calculate-benchmarks-by-checking-given-cells-mockup
Sheet: Raw Data

Date | Channel | Platform | Media Type | Reach Score | Reach | New Table
2021-05-04 14:01:17 | HQ | Instagram | video |  | 83362 |  |  | The LOOKUP values correspond to the "REACH" row for the selected CHANNEL (See TBL)
2021-05-29 02:00:04 | CQ | twitter | photo |  | 95797
2021-05-19 18:00:10 | BQ | Tiktok | Video |  | 124206
Spreadsheet: eric_saibi__9732__011102
Sheet: Salem 02

Owner Name | PSEG Power LLC
Station Name | Salem Nuclear Power Station
Unit Name | Salem 02
NERC Region | MAAC
State | NJ
Fuel Type | Nuclear
Capacity | 1,170 MW
Start Date | 2002-01-11 00:00:00
End Date | 2002-01-15 00:00:00
Comments | Diesel Problems
SIC | 4931
Plant ID | 1018459
Unit ID | 1004470
Outage ID | 19447
Spreadsheet: 58942d1259233409-returning-a-certain-result-based-on-a-specific-data-range-test
Sheet: Current Staff

AM | Store | Consultant Name | Start Date | Length of Service | No of Days | 2010 Basic Holiday | Length of Service Related Bonus Days | 2010 Basic + Service Related | 2009 Carry Over | Total 2010 Holiday Allocation | Comments
1 | Store 1 | Person 1 | 2009-11-01 00:00:00 | 0 years, 0 months | 5 | 33 | 0 | 33 | 0 | 33
2 | Store 2 | Person 2 | 2008-11-01 00:00:00 | 1 years, 0 months | 5 | 33 | 0 | 33 | 0 | 33
3 | Store 3 | Person 3 | 2007-11-01 00:00:00 | 2 years, 0 months | 5 | 33 | 3 | 36 | 0 | 36
4 | Store 4 | Person 4 | 2006-11-01 00:00:00 | 3 years, 0 months | 5 | 33 | 5 | 38 | 0 | 38
5 | Store 5 | Person 5 | 2005-11-01 00:00:00 | 4 years, 0 months | 5 | 33 | 5 | 38 | 0 | 38
6 | Store 6 | Person 6 | 2004-12-01 00:00:00 | 4 years, 11 months | 5 | 33 | 5 | 38 | 0 | 38
7 | Store 7 | Person 7 | 2004-10-01 00:00:00 | 5 years, 1 months | 5 | 33 | 5 | 38 | 0 | 38
8 | Store 8 | Person 8 | 1999-12-01 00:00:00 | 9 years, 11 months | 5 | 33 | 5 | 38 | 0 | 38
9 | Store 9 | Person 9 | 1999-10-01 00:00:00 | 10 years, 1 months | 5 | 33 | 2 | 35 | 0 | 35
10 | Store 10 | Person 10 | 1994-12-01 00:00:00 | 14 years, 11 months | 5 | 33 | 2 | 35 | 0 | 35
11 | Store 11 | Person 11 | 1994-10-01 00:00:00 | 15 years, 1 months | 5 | 33 | 3 | 36 | 0 | 36
12 | Store 12 | Person 12 | 1989-12-01 00:00:00 | 19 years, 11 months | 5 | 33 | 3 | 36 | 0 | 36
13 | Store 13 | Person 13 | 1989-10-01 00:00:00 | 20 years, 1 months | 5 | 33 | 4 | 37 | 0 | 37
14 | Store 14 | Person 14 | 1984-12-01 00:00:00 | 24 years, 11 months | 5 | 33 | 4 | 37 | 0 | 37
15 | Store 15 | Person 15 | 1984-10-01 00:00:00 | 25 years, 1 months | 5 | 33 | 5 | 38 | 0 | 38
Spreadsheet: 840941d1693211121-use-lookup-function-to-total-all-cells-that-contain-text-mockexample
Sheet: Sheet1

animal | cost | Petshoop
[NAME] | 7 | petsworld
[NAME] | 10 | total pets
choclate spaniel | 15 | petsRus
shorthair | 6 | petsworld
spynx | 12 | total pets
burmese | 18 | petsRus
 |  | petsworld | total pets | petsRus
dog | 32 | 7 | 10 | 15
cat | 36 | 6 | 12 | 18
Spreadsheet: 2ce66ed3-1d1a-4217-8f97-d5857df7d389
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-12-12 09:55:38.870000
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.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.828 | 101.703 | 101.578 | 101.203
4.25 | 101.13 | 101.005 | 100.88 | 100.505 |  | Note: | Refer To Price [NAME]
4.125 | 100.593 | 100.468 | 100.343 | 99.968 |  |  | For all Price Adjs
4 | 100.152 | 100.027 | 99.902 | 99.277
3.875 | 99.592 | 99.467 | 99.342 | 98.717
3.75 | 98.743 | 98.618 | 98.493 | 97.868
 |  |  |  |  |  | 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.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.366 | 101.241 | 101.116 | 100.741
3.625 | 101.05 | 100.925 | 100.8 | 100.425
3.5 | 100.736 | 100.611 | 100.486 | 100.111
3.375 | 100.331 | 100.206 | 100.081 | 99.456
3.25 | 99.779 | 99.654 | 99.529 | 98.904
 |  |  |  |  |  | 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-12-26 09:55:38.870000
30 DAY | 2012-01-10 09:55:38.870000
45 DAY | 2012-01-25 09:55:38.870000
60 DAY | 2012-02-09 09:55:38.870000
90 DAY | 2012-03-10 09:55:38.870000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: richard_shapiro__32219__99contributions
Sheet: Sheet1

JKS Political Contributions - 1999
Beneficiary | Date | Election Year | Federal | State | Other |  | Notes
Friends for [NAME] | 1999-02-02 00:00:00 | 2000 | 1000
[NAME] for Congress | 1999-03-15 00:00:00 | 2000 | 1000
[NAME] | 1999-03-22 00:00:00 | 2000 | 1000
Markey for Congress | 1999-03-22 00:00:00 | 2000 | 1000
ARMPAC | 1999-03-22 00:00:00 |  |  |  | 5000
Stenholm for Congress | 1999-06-29 00:00:00 | 2000 | 500
Whitman for U.S. Senate | 1999-08-08 00:00:00 | 2000 | 1000
[NAME] | 1999-08-20 00:00:00 | 2000 | 1000
Markey for Congress | 1999-09-29 00:00:00 | 2000 | 1000 |  |  |  | [NAME] for 2000 election
[NAME] for U.S. State Florida | 1999-10-25 00:00:00 |  | 500
Totals
Spreadsheet: 643406d1569855172-help-with-a-string-of-if-statements-cashflow-template-online-example-updated-expected-outcome
Sheet: Data Input & Output

Borrower: | [NAME]
Loan | Value | Rent | Initial Asset Yield | Initial Debt Yield | Initial ICR | Initial Post Tax DSCR | Entry LTV | [NAME] | EIR | WAULT | Debt psf | Borrower Grade | EIR
[NAME] |  |  |  |  | Model Output |  |  | Appetite | Entry | Year 3 | Exit | Notes
[NAME] (years) |  |  |  |  | Opening Loan Balance |  |  | < €15,000,000 |  |  | N/A | Maximum Connection Exposure €25m
Interest Rate |  |  |  |  | Opening LTV |  |  | 0.8 |  |  | N/A | Maximum Zone C LTV 75%
Service Charges & Costs |  |  |  |  | Stressed Case Pre-Tax ICR |  |  | 1.2 |  |  |  | Increased to 1.40 for Zone C
Tax Payable |  |  |  |  | Base Case Pre-Tax DSCR |  |  | 1.1
Arrangement Fee |  |  |  |  | Stressed Case Post-Tax DSCR |  |  | 1
Minimum Redemption Fee |  |  |  |  | Closing Loan Balance |  |  | < €15,000,000 | N/A |  |  | Maximum Connection Exposure €25m
Drawdown Commission |  |  |  |  | Closing LTV |  |  | N/A | N/A
Cashflow Assumptions |  |  |  |  |  | Address | Break | [NAME] (Qtr) | Re-Let (Qtr) | RE-Let ERV | Re-Let ERV %
 |  |  |  |  |  | New York | No | 1 | 40 | 50000 | 1
 |  |  |  |  |  | LA | Yes | 4 | 20 | 98000 | 0.9
 |  |  |  |  |  | London | Yes | 6 | 20 | 40000 | 0.75
 |  |  |  |  |  | Dublin | Yes | 2 | 8 | 120000 | 0.8
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
Spreadsheet: hunter_shively__12734__EnovateDPR0111
Sheet: 5 Day Roll

ENRON CAPITAL AND TRADE RESOURCES
 |  | DO NOT TOUCH!! | ONLY RUN BEFORE YOU LINK ANY NEW ROLLS!!
Commodity | 5 Day Rolling Total | Current Day | Current Day-1 | Current Day-2 | Current Day-3 | Current Day-4
ENA Gas Trading
Short Term Gas |  |  | 87.82937327400799 | 158.7207389439941 | -19.54707007599783 | 4.264501233997128
 |  | 13 | 12 | 11 | 10 | 7 | 6
 |  | 17 | 84 | 12 | -54 | 19 | -53
Spreadsheet: 703610d1605084882-subtraction-calculation-w-requirement-data-is-present-sampj
Sheet: example

TYPE: | # OF ITEMS A: | # OF ITEMS B: | SUM1: | SUM2: | CALC1 | CALC2
Down | 0 | 1 | 763979 | 90121
Down | 3 | 0 | 145566 | 145566
Up | 3 | 0 | 0 | N
Up | 2 | 0 | 0 | 70384
Down | 0 | 1 | 107506615 | N
Up | 1 | 0 | 0 | 29228
Down | 0 | 0 | 0 | N
Down | 2 | 1 | 75667411 | 4133973
Down | 0 | 0 | 0 | N
Up | 1 | 0 | 0 | N
Up | 1 | 0 | 0 | 8255
Down | 1 | 1 | 20 | 10