tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1036__Consolidated 6 Peaker- 051100-NewPrices
Sheet: Assumptions

Unhide Sub Debt, 1999 Columns
SUMMARY OUTPUT
SOURCES & USES:
Sources of Funds | % | 000 $ |  | Uses of Funds 1999 | % | 000 $
Total Equity |  |  |  | 1999 Uses
Bond Proceeds |  |  |  | 2000 Uses
Total Sources |  |  |  | Transactions Costs |  | 0
Equity Partner's Share | 1
Enron's Share |  |  |  | Total Uses
FINANCING ASSUMPTIONS:
 | Tranche 1 | Tranche 2 | Tranche 3 | Total
Debt Financing Summary:
Debt Closing Date | 2001-01-01 00:00:00
Amount ('000 $)
Term (yrs)
Final Maturity |  | 2010-12-31 00:00:00 | 2020-12-31 00:00:00
Average Life (yrs)
Treasury Rate (%) (as of 27-Apr-00) | 0.0658 | 0.0644 | 0.0613
Spread (%) | 0.0225 | 0.035 | 0.04125
All In Coupon Rate (%)
Maximum DSR Amount (12mths) (000 $)
Debt Service Reserve [NAME] | 0.02
Interest Income Rate | 0.05
Equity Financing Summary:
Equity Closing Date | 2001-01-01 00:00:00
Amount ('000 $) | 582042.4619354163
Required Rate of Return (%) | 0.13
Weighted Average Cost of Capital (%)
DEPRECIATION ASSUMPTIONS:
 | Initial Basis (000 $)
 | 1999 | 2000 | Year | Method | Residual (%)
Federal & State Tax Depreciation
Project Cost |  |  | 15 | MACRS | 0
Transaction Costs (for the entire Project) |  |  | 20 | SL | 0
Book Depreciation
Total Project Cost |  |  | 30 | SL | 0.1
SUMMARY OUTPUT:
DSCR |  |  | Min | [NAME].
Fixed Price Period
Market Price Period
 |  |  | 1999 Projects | 2000 Projects | 1999 & 2000 Projects
Average Heat Rate (average) (Btu/kWh)
Total ISO Capacity for 1999 & 2000 Projects (MW)
Salvage Value at the end of 20 years ($/kW)
Equity Partner's After-Tax Returns w/o Salvage Value (20 yrs) (000$)
Equity Partner's After-Tax Returns with Salvage Value (20 yrs) (000$)
 | 2001 | 2002 | 2003 | 2004 | 2005
GenCo EBITDA (000 $)
GenCo Net Income (000 $)
[NAME] (000 $)
GenCo After-Tax Cashflow (000 $)
Spreadsheet: 770493d1646121546-find-unique-value-and-return-adjacent-cell-is-it-possible-using-a-formula-book1
Sheet: Sheet1

Area Code | 0000
Name | Track
Code |  | Contractor | CostCode |  | Item Description | UoM |  | Qty
Z001 |  | C Hire | 80 |  | Blower | EA |  | 27 |  |  |  | 0
Complete: 99.00%, Comment:
Z001 |  | C Hire | 80 |  | Blower | EA |  | 27 |  |  |  | 0
Complete: 0.00%, Comment:
R001 |  | Ready | 36 |  | Fence | EA |  | 650 |  |  |  | 0
Complete: 0.00%, Comment:
R002 |  | Elec | 39 |  | Light | EA |  | 5 |  |  |  | 0
Complete: 0.00%, Comment:
Area Code | 1
Name | Track
Code |  | Contractor | CostCode |  | Item Description | UoM |  | Qty
Z001 |  | C Hire | 80 |  | Blower | EA |  | 4 |  |  |  | 1
Complete: 99.00%, Comment:
Z001 |  | C Hire | 80 |  | Blower | EA |  | 1 |  |  |  | 1
Complete: 0.00%, Comment:
R001 |  | Ready | 36 |  | Fence | EA |  | 10 |  |  |  | 1
Complete: 0.00%, Comment:
R002 |  | Elec | 39 |  | Light | EA |  | 2 |  |  |  | 1
Complete: 0.00%, Comment:
Spreadsheet: 881778d1729950842-i-am-looking-for-the-formulas-to-have-a-lay-not-back-horse-racing-dutching-sheet-lay-dutching-test-1
Sheet: Sheet1

 |  |  | Dutch LAY
 |  |  | STAKE > | 30
 |  |  | 7.8 | LAY AT > |  |  |  |  |  |  |  |  | Dutch LAY |  | Stk  > | 3
 |  |  | 12 | LAY AT > |  |  |  |  |  |  |  |  | Sel 1 |  | 0 | LAY AT >
 |  |  | 11 | LAY AT > |  |  |  |  |  |  |  |  | Sel 2 |  | 3.55 | LAY AT >
 |  |  | 12.5 | LAY AT > |  |  |  |  |  |  |  |  | Sel 3 |  | 4.4 | LAY AT >
 |  |  | 16 | LAY AT > |  |  |  |  |  |  |  |  | Sel 4 |  | 0 | LAY AT >
 |  |  | 16 | LAY AT > |  |  |  |  |  |  |  |  | Sel 5 |  | 0 | LAY AT >
 |  |  | 0 | LAY AT > |  |  |  |  |  |  |  |  | Sel 6 |  | 0 | LAY AT >
 |  |  | 0 | LAY AT > |  |  |  |  |  |  |  |  | Sel 7 |  | 0 | LAY AT >
 |  |  | 0 | LAY AT > |  |  |  |  |  |  |  |  | Sel 8 |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
 |  |  | 0 | LAY AT >
Spreadsheet: 634877c4-6a82-449e-8a8b-ba118cf264d6
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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 | Permit # |  |  | Month: | January | Year:
 | Facility: |  |  |  |  | Class: |  | County:
 | ORC: |  |  |  | Grade: |  | ORC Certification #
 | Has ORC Changed?: |  | False |  | Phone:
 | [NAME]: |  |  |  |  |  |  | Lab#:
 | Person(s) Collecting samples:
 | Comments:
 | Sampling Location: |  | Effluent |  | Discharge #
Date |  |  |  |  |  | 50050 | 00010 | 00400 | 50060 | CO310 | CO610 | CO530 | 31616 | 00300 | [NAME] | CO665
 | Composite Sample Time | Total Composite Time | Operator [NAME] | Operator Time On Site | ORC On Site? | Flow | Temperature | pH | Residual Chlorine | BOD 20° | Ammonia Nitrogen | Total Suspended Residue | Fecal Coliform | [NAME] | Total Nitrogen | Total Phosphorus
 | 2400 clock | Hrs | 2400 clock | Hrs | Y/B/N | mgd | deg c | su | ug/l | mg/l | mg/l | mg/l | #/100ml | mg/l | mg/l | mg/l
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Composite(C)/Grab(G): |  |  |  |  |  | RC | GR | GR | GR | CP | CP | CP | GR | GR | CP | CP
Monthly Average Limit:
Monthly Average:
Daily Maximum: |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Daily Minimum: |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Monthly Avg % Removal (85%):
 | Please remember, System allows entering the following non-numeric values for Daily Value:
 | Code Entered |  | Description
 | BDL |  | Below Detection Limit
 | > and a number |  | Greater Than
 | H |  | Holiday
 | < and a number |  | Less Than
 | T |  | Trace
Spreadsheet: 167902d1342150578-a-complicated-look-up-table-with-multiple-conditions-complexlookup
Sheet: LookUP Data

Month | XX | XX | XX | Brand Text | Product Text | XX | [NAME] | Net  Sales
1.2012 |  |  |  | Z9002 | Z9002 |  | TM72006 | 10
1.2012 |  |  |  | Z9002 | [NAME] |  | TM72006 | 50
1.2012 |  |  |  | [NAME] | XCVD^& |  | TM72001 | 40
1.2012 |  |  |  | [NAME] | XCC&^* |  | TM72001 | 45
1.2012 |  |  |  | X&^% | [NAME] |  | TM72004 | 26
1.2012 |  |  |  | X^&%$ | [NAME] |  | TM72004 | 27
1.2012 |  |  |  | ZA9003 | ZMA00 |  | TM72001 | 28
1.2012 |  |  |  | X&^%SS | ZMA00 |  | TM72001 | 35
1.2012 |  |  |  | Reusable Tips | X&^% |  | TM72006 | 31
1.2012 |  |  |  | Reusable Tips | X^&%$ |  | TM72006 | 33
1.2012 |  |  |  | Disposable Tips | ZA9003 |  | TM72006 | 38
1.2012 |  |  |  | Disposable Tips | X&^%SS |  | TM72006 | 36
1.2012 |  |  |  | Sovereign Accessories | XCVD^& |  | TM72001 | 34
1.2012 |  |  |  | WhiteStar Signature | XCC&^* |  | TM72001 | 32
2.2012 |  |  |  | Z9002 | XCVDG^ |  | TM72006 | 10
2.2012 |  |  |  | Z9002 | [NAME] |  | TM72006 | 50
2.2012 |  |  |  | [NAME] | XCVD^& |  | TM72001 | 40
2.2012 |  |  |  | [NAME] | XCC&^* |  | TM72001 | 45
2.2012 |  |  |  | X&^% | [NAME] |  | TM72004 | 29
2.2012 |  |  |  | X^&%$ | [NAME] |  | TM72004 | 27
2.2012 |  |  |  | ZA9003 | ZMA00 |  | TM72001 | 40
2.2012 |  |  |  | X&^%SS | ZMA00 |  | TM72001 | 35
2.2012 |  |  |  | Reusable Tips | X&^% |  | TM72006 | 31
2.2012 |  |  |  | Reusable Tips | X^&%$ |  | TM72006 | 33
2.2012 |  |  |  | Disposable Tips | ZA9003 |  | TM72006 | 40
2.2012 |  |  |  | Disposable Tips | X&^%SS |  | TM72006 | 36
2.2012 |  |  |  | Sovereign Accessories | XCVD^& |  | TM72001 | 34
2.2012 |  |  |  | WhiteStar Signature | XCC&^* |  | TM72001 | 32
Spreadsheet: 206749d1358270618-linking-information-from-one-worksheet-to-another-attendance-template-linking
Sheet: February

 | Employee Absence Schedule
 | February | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
POSITION | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | CL | T | NCNS | Total Points
LVN/FT | ADKINS PAM | T | NCNS | CI
RN/FT | ALINCASTRE RAFAEL
LVN/PRN | ALLISON GWEN
RN/FT | AMASON CHARLOTTE
 |  |  |  |  |  |  | Cl | Call-in |  |  | T |  |  |  | NCNS |  |  |  |  |  |  |  | FMLA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No call no show
Spreadsheet: 814848d1674634075-formula-to-get-the-value-inside-text-sample-excel-2-
Sheet: Sheet1

Cars
63 Series Performance Air Intake System (TrailBlazer 07-09) |  | <=== Is there any formula that can get the value inside the ()
63 Series Performance Air Intake System (Hummer H3 07-09)
63 Series Performance Air Intake System (Silverado/Sierra 1500 5.3L 14-19)
63 Series Performance Air Intake System (Silverado/Sierra 1500 4.3L 14-18)
63 Series Performance Air Intake System (Silverado/Sierra 15-16)
63 Series Performance Air Intake System (Colorado 16-20)
63 Series Performance Air Intake System (Silverado/Sierra 17-19)
63 Series Performance Air Intake System (Silverado/Sierra 1500 2019+)
63 Series Performance Air Intake System (Titan 08-15/QX56 08-10)
Spreadsheet: 271260d1381876982-in-this-true-or-false-function-i-want-desired-name-instead-of-display-true-or-false-diplay-desired-name
Sheet: Sheet1

MENTIONED CUG | GIVEN CUG | COMPARE A AND B
CUG NEW ([PHONE],[PHONE],[PHONE]) | /919821049
ADMIN NO - [PHONE] | /999900260
ADMIN NO - [PHONE] | /919849643 |  |  |  | IF ANY NUMBERS IN A COLUMN AND NO DATA IN B COLUMN THEN IT SHOUD DISPLAY "CUG NOT GIVEN"
CUG NOT REQUIRED
CUG NOT REQUIRED
CUG NOT REQUIRED
CUG NEW ([PHONE],[PHONE],[PHONE]) |  | CUG NOT GIVEN
CUG NEW ([PHONE],[PHONE],[PHONE]) | /999900636
CUG NEW ([PHONE],[PHONE],[PHONE]) |  | CUG NOT GIVEN
CUG NEW ([PHONE],[PHONE],[PHONE]) |  | CUG NOT GIVEN
CUG NOT REQUIRED | /919840798
CUG NOT REQUIRED
ADMIN NO - [PHONE] |  | CUG NOT GIVEN
CUG NEW ([PHONE],[PHONE]) | /919852051
CUG NEW ([PHONE],[PHONE]) |  | CUG NOT GIVEN
INT - 919852051 |  | CUG NOT GIVEN
CUG 999964248 |  | CUG NOT GIVEN
CUG 877776544 |  | CUG NOT GIVEN
CUG 222244 | CUG 222244
IF ANY NUMBERS IN A COLUMN AND NO DATA IN B COLUMN PAIRS WILL COME THEN IT SHOULD BE  DISPLAY "CUG NOT GIVEN"
others should be blank
Spreadsheet: 91601d1291293712-excel-2007-auto-copy-information-from-one-worksheet-to-another-example-book
Sheet: 2410

 | AWAITING PROCESSING
`DATE` | NAME | 2410 | TSN | A/C# | SERIAL NUMBER | CONDITION | EA | CLASS | NIIN | REMARKS
2010-11-30 00:00:00 | aircraft part | Y | Y | 4572 | B292-05244 | GREEN | 1 | 1680 | 01-261-2044
2010-11-30 00:00:00 | aircraft part | Y | Y | 4572 | AK0811 | GREEN | 1 | 1680 | 01-261-2044
 | SHIPPED
`DATE` | NAME | 2410 | TSN | A/C# | SERIAL NUMBER | CONDITION | EA | CLASS | NIIN | REMARKS
2010-11-30 00:00:00 | aircraft part | 598305 | 1196 | 3417 | 4807 | GREEN | 1 | 6115 | 01-114-9696 | 2010-12-01 00:00:00
2010-11-30 00:00:00 | aircraft part | 675685 | 1967 | 6571 | 137 | GREEN | 1 | 4140 | 01-329-3428 | 2010-11-30 00:00:00
Spreadsheet: 737859d1624628916-find-maximum-for-every-5-rows-finalchoicesetexample
Sheet: Sheet1

Respondent | Choiceset | Alternative | Choice | Probability Prediction | Maximum | Predicted correctly
1146 | 1 | 1 | 0 | 0.1253469
1146 | 1 | 2 | 0 | 0.1944772
1146 | 1 | 3 | 1 | 0.2890968
1146 | 1 | 4 | 0 | 0.2255877
1146 | 1 | 5 | 0 | 0.1654914
1146 | 2 | 1 | 0 | 0.0417012
1146 | 2 | 2 | 0 | 0.1339172
1146 | 2 | 3 | 1 | 0.3449135
1146 | 2 | 4 | 0 | 0.3940507
1146 | 2 | 5 | 0 | 0.0854175
1146 | 3 | 1 | 0 | 0.0457048
1146 | 3 | 2 | 0 | 0.1574961
1146 | 3 | 3 | 0 | 0.3380672
1146 | 3 | 4 | 1 | 0.37475
1146 | 3 | 5 | 0 | 0.0839818
1146 | 4 | 1 | 0 | 0.0267933
1146 | 4 | 2 | 0 | 0.0924478
1146 | 4 | 3 | 0 | 0.2916102
1146 | 4 | 4 | 1 | 0.5648751
1146 | 4 | 5 | 0 | 0.0242736
1146 | 5 | 1 | 0 | 0.0389354
1146 | 5 | 2 | 0 | 0.1544882
1146 | 5 | 3 | 1 | 0.3713331
1146 | 5 | 4 | 0 | 0.3909876
1146 | 5 | 5 | 0 | 0.0442557
1146 | 6 | 1 | 0 | 0.0460409
1146 | 6 | 2 | 0 | 0.1618849
1146 | 6 | 3 | 1 | 0.3783129
1146 | 6 | 4 | 0 | 0.367652
1146 | 6 | 5 | 0 | 0.0461093
1146 | 7 | 1 | 0 | 0.058521
1146 | 7 | 2 | 0 | 0.1395181
1146 | 7 | 3 | 1 | 0.3081291
1146 | 7 | 4 | 0 | 0.4457806
1146 | 7 | 5 | 0 | 0.0480512
1146 | 8 | 1 | 0 | 0.0424551
1146 | 8 | 2 | 0 | 0.1558215
1146 | 8 | 3 | 1 | 0.3429192
1146 | 8 | 4 | 0 | 0.4086733
1146 | 8 | 5 | 0 | 0.050131
1146 | 9 | 1 | 0 | 0.0281882
1146 | 9 | 2 | 0 | 0.1154203
1146 | 9 | 3 | 1 | 0.3381637
1146 | 9 | 4 | 0 | 0.4755266
1146 | 9 | 5 | 0 | 0.0427012
Spreadsheet: 376605d1423661659-assistance-in-linking-cells-into-several-worksheet-full-price-list-sample
Sheet: Quotation Checking

QUOTATION CHECKING LIST
COMPANY : |  | AMOS |  |  |  | SEASTAR MARINE PTE LTD
 |  |  |  |  |  | 60 Benoi Road F2 #02-11, SINGAPORE (629906)
MARKING : |  |  |  |  |  | Off : (65) 6265 8662    Fax : (65) 6265 7616
 |  |  |  |  |  | E-mail : [EMAIL]
DATE : |  |  |  |  |  | GST Reg No. 200708233N
 |  | IMPA No | ITEM | [NAME] | UNIT | PRICE / UNIT
 | 1 | 150691
 | 2 | 174277
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
REMARK :
Spreadsheet: 275625d1383591377-make-unique-name-list-and-sum-data-namelist-and-total-jacc
Sheet: Sheet1

Day1 |  |  | Day2 |  |  | Day3 |  |  | Day4 |  |  | Day5 |  |  | Day6 |  |  | Day7 |  |  |  | WANTED:
Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 |  | UNİQUE NAME LİST | TOTAL DATA  2
a | 1 | 10 | e | 2 | 20 | a | 2 | 25 | m | 6 | 15 | c | 4 | 10 | k | 5 | 20 | a | 1 | 10
b | 2 | 11 | f | 1 | 15 | f | 3 | 10 | n | 2 | 1 | t | 6 | 20 | p | 6 | 30 | x | 6 | 20
c | 1 | 15 | g | 2 | 16 | j | 4 | 6 | a | 1 | 6 | u | 8 | 25 | r | 7 | 15 | t | 6 | 25
d | 2 | 16 | a | 3 | 21 | k | 6 | 15 | h | 3 | 20 | v | 1 | 15 | s | 8 | 10 | s | 8 | 5
e | 3 | 12 | h | 3 | 10 | l | 1 | 16 | t | 4 | 10 | a | 5 | 8 | a | 1 | 5 | z | 5 | 1
 |  |  | x | 1 | 5 | c | 1 | 5
 |  |  |  |  |  | d | 2 | 12
NOTES:
All  This Name Data1 and Data2  columns are coming from another worksheet by formulas.
So, colums are to  row 300 with formula.
Wanted:
In W column , to make a Unique Name List from table above
In X column , to make Total Data2 values to Unique Names
 |  |  |  |  |  | [NAME]
Spreadsheet: 792930d1661238242-want-to-make-simple-dynamic-dashboard-example-1-
Sheet: invalid email

Sl no. | [NAME] | Valid
Spreadsheet: 186420d1350036886-search-beers
Sheet: P

Brewery |  | Beer
Palmers |  | Tally Ho!
 |  | Dorset Gold
Parish |  | Baz’s Bonce Blower
Passageway |  | Redemption
 |  | [NAME]
 |  | Rauch
Pembroke |  | Main Street Bitter
 |  | Signal Failure
Pheonix |  | Oak Best Bitter
 |  | [NAME]
 |  | Wobbly Bob
 |  | Porter
 |  | Golden Glow
 |  | Pale Moonlight
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Plassey |  | Bitter
Plough Inn |  | Bodicote Bitter
Porter |  | [NAME]
Pot Belly |  | Beijing Black
Potton |  | Pheonix
 |  | Village Bike
Preston Brewing Co |  | Pride Ale
 |  | Preston pride
Princetown |  | Best Bitter
Pictish |  | Brewers Gold
 |  | [NAME]
 |  | Alchemists Ale
Spreadsheet: 471802d1469197239-identify-min-value-with-two-conditions-in-a-different-worksheet-copy-of-formula-for-min-with-conditions-in-two-sheets-ndm
Sheet: Summary

 | Coke
 | North |  |  |  | Item | Location | Min of Amount
 | East |  |  |  | Coke | North | 10
 | West |  |  |  |  | East | 100
 | South |  |  |  |  | West | 0
 |  |  |  |  |  | South | 170
 | Waffles |  |  |  | Waffles | North | 0
 | North |  |  |  |  | East | 60
 | East |  |  |  |  | West | 50
 | West |  |  |  |  | South | 190
 | South
 | Need Min Value of Coke and Waffles in North, East, West and South
Spreadsheet: 51954d1251562380-how-to-create-a-dropdown-list-that-returns-values-that-depends-on-another-cell-sample-invoice
Sheet: Invoice

 |  |  |  |  |  | Cust: | [NAME]
 |  |  |  |  |  | Add:
 |  |  |  |  |  | [NAME]:
 |  |  |  |  |  | City:
 |  |  |  |  |  | Phone:
Product | Type | Size | Color | Qty | Unit Price | Discount | Subtotal
ABC | Bed
 |  |  |  |  |  | Total:
 | *** What formula to use in the 'Size' Column above if I want a dropdown list that ONLY shows the size
 | available for that particular product with that particular type. I've managed to make a dropdown list in the
 | Type' column that shows the type available depending on the product entered. But, I don't know how to make
 | a dropdown list in the '[NAME]' column that depends on BOTH the 'product' and 'type' entered.
Spreadsheet: 90767d1290519395-sorting-dates-that-are-referenced-from-other-sheets-forum-reference-example
Sheet: Building Res Est

Customer | BUILDING RESEARCH ESTABLISHMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pages
Bid Number | 2709D524
Version | 3
Status | EMEA approved
Validation date | 15/04/2010
Start date | [NAME]
End date | 15/12/2010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage Increase: | 0
[NAME]
Description | Quantity | Bid price | Part number | 2009 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Total Units | Total Revenue | Bid £ | BDP | % Discount | New Price? | New Discount? | New Price £ Estimate | Current £ Year Estimate
Spreadsheet: 35970d1233705676-excel-2007-formatting-issue-when-linking-a-column-s-of-data-to-other-excel-files-discrete-measures
Sheet: SL

Level | 25PE | 25CS | 5PE | 5CS | 75PE | 75CS | 10PE | 10CS | 15PE | 15CS
Spreadsheet: 700038d1602920637-formula-to-extract-data-based-on-month-and-year-extract-profits
Sheet: BR1

BR1 | 2019-10-01 00:00:00 | Nov 2019 | Dec 2019 | Jan 2020 | Feb 2020 | Mar 2020 | Apr 2020 | May 2020 | Jun 2020 | Jul 2020 | Aug 2020 | Sep 2020
Net Profit Achieved Month-Dept1
Net Profit Achieved Month-Dept2
Net Profit Achieved Month-Dept3
Net Profit Achieved Month-Dept4
Spreadsheet: 56191d1256286134-excel-2007-extended-unicode-characters-appear-as-blank-spaces-in-excel-2007-special-character-problem
Sheet: additional PT Build Program

TestUnit | Smart no. Eng./Transm.
045051301B | PO- E031LDVGAD |  |  |  | PO- E03
045051302B | PO- E032LDVGAD |  |  |  | PO- E031LDVGAD
045051304B | PO- E007LSFGAD
045051306A | PO- E008LSFGAD E013MZ7GAA
045051307B | PO- E033LDVGAD
045051328A | PO- E038LDVGAD E032M26GAA
045051329A | PO- E043LDVGAD E069M26GAA
Spreadsheet: benjamin_rogers__1073__Reconstructed Consolidated 2000 Peaker 8-15-00
Sheet: Summary Output

SUMMARY OUTPUT
SOURCES & USES:
Sources of Funds | % | 000 $ |  | Uses of Funds | % | 000 $
Total Equity |  |  |  | 2000 Plants
Bond Proceeds
Total Sources |  |  |  | Total Uses
FINANCING ASSUMPTIONS:
 | Tranche 1 | Tranche 2 | Tranche 3 | Total
Debt Financing Summary:
Debt Closing Date |  | 2001-01-01 00:00:00
Amount ('000 $) | 0 | 114987 | 240367
Term (yrs)
Final Maturity | #N/A | 2010-12-31 00:00:00 | 2020-12-31 00:00:00
Average Life (yrs)
Treasury Rate (%) | 0.068 | 0.065 | 0.062
Spread (%) | 0.0225 | 0.045 | 0.05
All-in Coupon Rate (%)
Interest Income Rate | 0.05
Equity Financing Summary:
Equity Closing Date | 2001-01-01 00:00:00
Amount ('000 $) | 448708.0669865901
Required After-Tax Return | 0.14
DEPRECIATION ASSUMPTIONS:
 | 2000 Basis | Year | Method | Residual (%)
Federal & State Tax Depreciation
Total Project Cost |  | 15 | MACRS | 0
Book Depreciation
Total Project Cost |  | 30 | SL | 0.1
SUMMARY OUTPUT:
DSCR |  |  | Min | [NAME].
Merchant Price Period
Weighted Average Heat Rate (Btu/kWh)
Summer Capacity (MW)
Salvage Value (2 x EBITDA) at the end of 20 years ($/kW)
Equity's After-Tax Returns with Salvage Value (20 yrs)
 | 2001 | 2002 | 2003 | 2004 | 2005
GenCo EBITDA (000 $)
GenCo Net Income (000 $)
[NAME] (000 $)
GenCo After-Tax Cashflow (000 $)
Spreadsheet: 104148d1301799850-how-to-find-the-value-of-the-max-date-per-year-dystop1a_vl
Sheet: Sheet1

UNUSED SL AS OF: | This should be the result
 | 15
 | 21
 | 21.75
DATE | LEAVE | ENTITLEMENT |  | U S E D |  | B A L A N C E
FILED | DATE/S | V.L | S.L | V.L | S.L | V.L | S.L | Year | Start Month
2009-01-23 00:00:00 | 2009-01-13 00:00:00 |  |  | 0 | 0 |  |  |  | 2009-01-01 00:00:00
2009-01-23 00:00:00 | 2009-01-23 00:00:00 |  |  | 0 | 0
2009-01-23 00:00:00 | Feb16 - Mar 4, 2009 |  |  | 0 | 0
2009-02-04 00:00:00 | 2009-02-06 00:00:00 |  |  | 0 | 0
2009-02-11 00:00:00 | 2009-02-10 00:00:00 |  |  | 0 | 0
2009-06-17 00:00:00 | 2009-06-18 00:00:00 |  |  | 1
2009-12-07 00:00:00 | 2009-12-08 00:00:00 |  |  | 1
2009-12-28 00:00:00 | 2009-12-17 00:00:00 |  |  | 1
2010-02-18 00:00:00 | 2010-02-17 00:00:00 |  |  | 1
2010-02-19 00:00:00 | 2010-02-19 00:00:00 |  |  | 0.5
2010-02-24 00:00:00 | 2009-02-24 00:00:00 |  |  | 1
2010-03-18 00:00:00 | 2010-03-24 00:00:00 |  |  | 1
2010-04-12 00:00:00 | 2010-04-19 00:00:00 |  |  | 0.5
2010-04-12 00:00:00 | April 22, 23, 26, 2010 |  |  | 3
2010-06-16 00:00:00 | 2010-06-25 00:00:00 |  |  | 1
2010-07-28 00:00:00 | 2010-07-20 00:00:00 |  |  | 1
2010-07-28 00:00:00 | July 21-22, 2010 |  |  |  | 2
2010-07-28 00:00:00 | 2010-07-29 00:00:00 |  |  | 1
2010-10-14 00:00:00 | Oct. 8-13, 2010 |  |  |  | 4
2010-12-13 00:00:00 | Oct. 15-Nov. 30 |  |  | 7 | 3
2011-02-24 00:00:00 | 2011-02-24 00:00:00 |  |  | 0
2011-03-14 00:00:00 | 2011-03-10 00:00:00 |  |  |  | 1
2011-03-23 00:00:00 | 2011-03-18 00:00:00 |  |  | 1 | 2
Spreadsheet: 824422d1680573633-show-movements-between-selected-dates-sales-order-movements-andyd1234-
Sheet: Sheet2

1st date for comparison |  | 2023-03-01 00:00:00
2nd date for comparison |  | 2023-03-03 00:00:00
Sales ID | [NAME] | Q1 Revenue | Q2 Revenue | [NAME] | Q4 Revenue | Total Value |  | Sales ID | [NAME] | Q1 Revenue | Q2 Revenue | [NAME] | Q4 Revenue | Total Value
A003 | Mint Ltd | 400 | 400
A008 | E [NAME] |  |  | 150 | 150
A009 | Office Supplies Ltd | 1000 | 1000 | 1000 | 0
A010 | Security plus Ltd | 0 | 0 | 750 | 750
Spreadsheet: 820848d1678307152-matching-two-columns-and-returning-the-third-example
Sheet: Transactions

Date | Type | Description | Value |  | [NAME] | Category should be
2023-03-01 00:00:00 |  | UKI T/A DIRECTLINE | -10 |  |  | wife
2023-03-01 00:00:00 |  | UKI T/A DIRECTLINE | -20 |  |  | me
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -30 |  |  | dog
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -40
2023-03-02 00:00:00 |  | Savings Account | -50 |  |  | To Savings
2023-03-03 00:00:00 |  | SAVINGS ACCOUNT | 60 |  |  | From Savings
2023-03-04 00:00:00 |  | BRITISH GAS | -20 |  |  | Energy
2023-03-05 00:00:00 |  | WATER | -150 |  |  | Energy
Spreadsheet: 143273d1330345097-looking-up-multiple-variables-in-a-table-and-giving-the-results-disc-calc
Sheet: Sheet1

 | Base Discount |  |  |  | Incumbent |  |  |  | DR sub 1,000 |  |  |  | DR over 1,000
 | P | G | S | R | P | G | S | R | P | G | S | R | P | G | S | R
0 | 0.3 | 0.25 | 0.2 | 0.15
1-24% | 0.3 | 0.25 | 0.2 | 0.15
25%-34% | 0.3 | 0.25 | 0.2 | 0.15
35%-44% | 0.25 | 0.2 | 0.15 | 0.15
45%-64% | 0.2 | 0.15 | 0.1 | 0.1
65%-84% | 0.15 | 0.1 | 0.05 | 0.05
 | Pricing Type | Base
 | Partner Status | R
 | Discount Level | 35%-44%
 | Discount Levels |  | Pricing Type
 | [NAME] |  | (blank) |  |  | (blank)
 | 1-24% |  | Base |  |  | R
 | 25%-34% |  | Incumbent |  |  | S
 | 35%-44% |  | DR sub 1,000 |  |  | G
 | 45%-64% |  | DR over 1,000 |  |  | P
 | 65%-84%
Spreadsheet: 880042d1727682722-detect-employee-actual-entry-data-and-exit-date-book6
Sheet: Sheet1

Employee Name | Entry Date | Exit Date | Role | Team | Actual Entry Date | Actualy Exit Date
A | 2021-10-01 00:00:00 | 2021-11-30 00:00:00 | Engineer | Data Science
A | 2021-06-01 00:00:00 | 2021-09-30 00:00:00 | Engineer | Engineering 1
B | 2022-10-01 00:00:00 |  | Manager | Engineering 1
B | 2021-10-15 00:00:00 | 2022-09-30 00:00:00 | Technical Architect | Engineering 1
B | 2021-03-01 00:00:00 | 2021-10-14 00:00:00 | Engineer | Engineering 1
C | 2024-08-01 00:00:00 | 2027-07-31 00:00:00 | Trainee | Apprenticeship
D | 2022-05-23 00:00:00 | 2023-04-30 00:00:00 | Product Manager | Supply Chain
D | 2020-12-01 00:00:00 | 2022-05-22 00:00:00 | Product / Service Owner | Supply Chain
E | 2023-10-01 00:00:00 |  | Engineer | Engineering 2
E | 2020-12-01 00:00:00 | 2022-05-31 00:00:00 | Engineer | Engineering 2