tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: david_delainey__8062__Sweetwater_129 MW_13June00_Breakeven
Sheet: CashFlow

 |  |  |  | 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
 | Cash Flow Statement
 | PRODUCTION % PER  YEAR
 | EWC PROJECTED WIND PRODUCTION (MWh)
 | ENERGY RATE
REVENUE | LIQUIDATED DAMAGES
 | ELECTRICITY SALES
 | TOTAL OPERATING INFLOWS
OPEX
 | TOTAL OPEX
 | NET OPERATING CASH
SENIOR DEBT | INTEREST EXPENSE TRANCHE A
 | PRINCIPAL PAYMENT TRANCHE A
 | INTEREST EXPENSE TRANCHE B
 | PRINCIPAL PAYMENT TRANCHE B
 | TOTAL SR DEBT PAYMENTS
 | L/C FEE - SR DEBT
 | NET CASH FLOW AFTER SR DEBT
SUBORDINATE | L/C FEE - O&M
PAYMENTS | MANAGEMENT FEE
 | TOTAL SUBORDINATED PMTS
 | NET CASH AFTER SUB-PMTS
 | ADDITIONAL EQUITY - OUTSIDE
 | ADDITIONAL EQUITY - EWC
 | CASH AVAILABLE FOR JR DEBT
JUNIOR DEBT | INTEREST EXPENSE
 | PRINCIPLE PMT
 | TOTAL JR DEBT PMT
 | L/C FEE JR DEBT
 | NET CASH AFTER JR DEBT
DEFICIT | DEFICIT LOAN
REVOLVER | RETURN PAYMENT
 | NET CASH AFTER REVOLVER
 | BEGINNING CASH BALANCE
 | PLUS: NET CASH
 | LESS: WORKING CAPITAL MIN BALANCE
 | CASH AVAILABLE FOR [NAME]
DISTRIBUTIONS | OUTSIDE EQUITY
 | EWC
 | TOTAL CASH DISTRIBUTIONS
 | ENDING CASH BALANCE
PTC | PROD. TAX CREDIT RATE ¢/kWh
 | TOTAL PROD TAX CREDIT
 | Required Monetization
 | Additional Equity
 | Effective Monetization of Additional Equity
 | Total Effective Monetization
Spreadsheet: 53df8e15-4552-4ac8-8425-33af2a546c70
Sheet: County Team Hours

County Project Team
Instructions: The vendor is asked to provide the amount of resources that will require from the County, in terms of number of hours. These amounts should be based on the functionality the County desires, included in the detailed Functional and Technical Requirements.
Functional Area | Requirements and Design | Configuration and Setup | Implementation | Testing | Training | Total
[NAME]
Zoning
Sanitation and Maintenance
[NAME]
Parcel Maintenance
Assessment Information
Tax Bill Processing
Treasurer & Reciepting
Interfaces
Total Hours By Project Phase:
Spreadsheet: 686499d1594656721-how-to-update-all-linked-workbooks-upon-change-sample-recipe-1
Sheet: Sheet1

 | Sample Recipe 1
[NAME] | Item | Unit Amount | Unit Type | Conversion | Meas | Cost | Yield | Conversion Yield | Con Unit | Date Ingredient Price was Updated:
 |  | 20 | lbs | 20 | lbs |  | 1 |  | lbs
 |  |  |  |  | Total
 |  |  |  |  | Yield % | 0.9
 |  |  |  |  | Total Yield |  | LB
 |  |  |  |  | Price Per |  | LB/QT
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 88 | 324 | 412
Cap/Floor | 16 | 445 | 461
Debt Option | - | - | -
Exotic | - | - | -
Fixed-Fixed | - | 7 | 7
Fixed-Float | 14668 | 3091 | 17759
FRA | 445 | 195 | 640
Inflation | - | 354 | 354
OIS | 92 | 268 | 360
Swaption | - | 1369 | 1369
TOTAL | 15309 | 6053 | 21362
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 10b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 1820880 | 557749 | 860517 | 4822426 | 520157 | 121435 |  | 9077964
Cross-Currency Fixed-Fixed | 61430 | 48883 | 31502 | 226139 | 9884 | 27300 |  | 436688
Cross-Currency Fixed-Float | 134070 | 43808 | 65377 | 325817 | 52633 | 17342 |  | 3539904
TOTAL
Spreadsheet: 493332d1481659785-how-to-create-a-rolling-data-feed-example1
Sheet: Hi$tory

day | Clicks | Views
2016-10-11 00:00:00 | 1588 | 1565
2016-10-12 00:00:00 | 28642 | 28186
2016-10-13 00:00:00 | 33350 | 32776
2016-10-14 00:00:00 | 27915 | 27447
2016-10-15 00:00:00 | 18852 | 18501
2016-10-16 00:00:00 | 26534 | 25961
2016-10-17 00:00:00 | 20608 | 20281
2016-10-18 00:00:00 | 25918 | 25623
2016-10-19 00:00:00 | 29975 | 29629
2016-10-20 00:00:00 | 25147 | 24824
2016-10-21 00:00:00 | 21348 | 21135
2016-10-22 00:00:00 | 20900 | 20657
2016-10-23 00:00:00 | 51720 | 50976
2016-10-24 00:00:00 | 51425 | 50706
2016-10-25 00:00:00 | 37812 | 37364
2016-10-26 00:00:00 | 35682 | 35316
2016-10-27 00:00:00 | 32397 | 32111
2016-10-28 00:00:00 | 18976 | 18826
2016-10-29 00:00:00 | 26871 | 26605
2016-10-30 00:00:00 | 32411 | 32109
2016-10-31 00:00:00 | 40981 | 40545
2016-11-01 00:00:00 | 27373 | 27101
2016-11-02 00:00:00 | 30363 | 30066
2016-11-03 00:00:00 | 90503 | 90131
2016-11-04 00:00:00 | 109664 | 109435
2016-11-05 00:00:00 | 91515 | 91139
2016-11-06 00:00:00 | 104513 | 104216
2016-11-07 00:00:00 | 178171 | 177628
2016-11-08 00:00:00 | 127741 | 127139
2016-11-09 00:00:00 | 126142 | 125823
2016-11-10 00:00:00 | 200355 | 199381
2016-11-11 00:00:00 | 134520 | 134156
2016-11-12 00:00:00 | 174248 | 173743
2016-11-13 00:00:00 | 207767 | 207098
2016-11-14 00:00:00 | 200109 | 199546
2016-11-15 00:00:00 | 202776 | 202283
2016-11-16 00:00:00 | 262193 | 261656
2016-11-17 00:00:00 | 198978 | 198363
2016-11-18 00:00:00 | 207000 | 206583
2016-11-19 00:00:00 | 207383 | 206871
2016-11-20 00:00:00 | 252617 | 252023
2016-11-21 00:00:00 | 296285 | 295727
2016-11-22 00:00:00 | 201421 | 200734
2016-11-23 00:00:00 | 190707 | 190272
2016-11-24 00:00:00 | 181836 | 181395
2016-11-25 00:00:00 | 198849 | 198278
2016-11-26 00:00:00 | 131130 | 130644
2016-11-27 00:00:00 | 201878 | 201145
2016-11-28 00:00:00 | 274670 | 273994
2016-11-29 00:00:00 | 226757 | 226144
2016-11-30 00:00:00 | 275838 | 274968
2016-12-01 00:00:00 | 268876 | 268162
2016-12-02 00:00:00 | 268564 | 267726
2016-12-03 00:00:00 | 230941 | 230302
2016-12-04 00:00:00 | 254523 | 253753
2016-12-05 00:00:00 | 306240 | 305265
2016-12-06 00:00:00 | 144388 | 143696
2016-12-07 00:00:00 | 201966 | 201131
2016-12-08 00:00:00 | 220552 | 219827
2016-12-09 00:00:00 | 193175 | 192729
2016-12-10 00:00:00 | 155766 | 155314
2016-12-11 00:00:00 | 62407 | 61894
2016-12-12 00:00:00 | 82578 | 82083
2016-12-13 00:00:00 | 163902 | 163480
Spreadsheet: 23464d1213003143-update-master-sheet-from-daily-report-june_oil
Sheet: Jhon

JHON
2008-01-06 00:00:00 | Site ID | Site Name | Supervisor | [NAME] reading | Stock ( Lt) | Filling (Lt)
 | PHAN-02 | [NAME] | JHON | 256 | 16 | 40
 | PHDIH-01 | [NAME] Harbour-1 | JHON | 356 |  | 60
 | PHKHI-01 | KhelKuda-1 | JHON | 156 | 65 | 70
 | PHPHA-01 | Patiala | JHON | 400.5 | 80 | 80
2008-04-06 00:00:00 | Site ID | Site Name | Supervisor | [NAME] reading | Stock ( Lt) | Filling (Lt)
 | PHAN-02 | [NAME] | JHON | 300 | 20 | 52
 | PHDIH-01 | [NAME] Harbour-1 | JHON | 400 | 29 | 61
 | PHPHA-01 | Patiala | JHON | 495 | 10 | 75
Spreadsheet: 38517d1236687293-choose-ytd-and-month-figures-test
Sheet: Cash Flow

 | day1 | Nov 08 | Dec 08 | Jan 09 | Feb 09 | Mar 09 | Apr 09 | May 09 | Jun 09 | Jul 09 | Aug 09 | Sep 09 | Oct 09 | Tot 08/09 | Nov 09 | Dec 09 | Jan 10 | Feb 10 | Mar 10 | Apr 10 | May 10 | Jun 10 | Jul 10 | Aug 10 | Sep 10 | Oct 10 | Tot 09/10 | Nov 10 | Dec 10 | Jan 11 | Feb 11 | Mar 11 | Apr 11 | May 11 | Jun 11 | Jul 11 | Aug 11 | Sep 11 | Oct 11 | Tot 10/11
Cash Flow Projections
PBIT
Initial Investment | 57352
Capital Expenditure
Directors Loan (LB) |  | 27000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -27000
Change in Work Cap | -6000
Depreciation -orginal
Depreciation -new
Gain on disposal
Other Loan
Cash Outflows
Cumulative Cash Flow
Closing Bank Balance
Spreadsheet: 833056d1686756174-xlookup-with-arrays-xlookup
Sheet: Feuil1

check | id | valuea | valueb | valuec |  |  | trial (does not work) |  | expected result (spilling)
a,c,d | a | 1 | 2 | 3 |  |  |  |  | 1 | 2
 | b | 6 | 5 | 4 |  |  | 7 |  | 7 | 8
 | c | 7 | 8 | 9 |  |  | 12 |  | 12 | 11
 | d | 12 | 11 | 10
Spreadsheet: 874589d1721159089-linear-measurement-of-differences-between-two-times-measuring-time-diff
Sheet: Sheet1

Their Time | Our Time | Should Show | My Formula
01:00:00 | 22:00:00 | 3 Hours
01:30:00 | 02:30:00 | 1 Hours
02:30:00 | 03:15:00 | 0.75 hours
03:00:00 | 00:30:00 | 2.5 hours
Spreadsheet: 46731a24-cc3f-4f08-9869-01f7db007370
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4490 | 14920 | [NAME] | Macmartin | CAN | 0 |  |  |  |  |  | 1
Spreadsheet: 728641d1618555960-i-need-help-to-generate-attendance-sheet-by-using-excel-19-excel-help
Sheet: Sheet1

Employee Name & ID: | Designation: | Working Address: | [NAME]: | Date | Time |  | Background: This is raw data collected by Google Forms. Normally this form is used for attendance purpose. Everyday one employee must input his / her attendance two times. One is for Time in and another is for Time out. Now, I have to generate attendance sheet based on the collectioned information. The wanted format is given below:
AAA (001) | Support Staff | Kolkata, India | Time In | 15/04/2021 | 08:21:16
BBB (002) | Support Staff | Kolkata, India | Time In | 15/04/2021 | 08:21:43
CCC (003) | Support Staff | Kolkata, India | Time In | 15/04/2021 | 08:37:35
DDD (004) | Support Staff | Kolkata, India | Time In | 15/04/2021 | 08:41:14
EEE (005) | Support Staff | Kolkata, India | Time In | 15/04/2021 | 08:43:16
AAA (001) | Support Staff | Kolkata, India | Time Out | 15/04/2021 | 17:30:20
BBB (002) | Support Staff | Kolkata, India | Time Out | 15/04/2021 | 17:15:10
CCC (003) | Support Staff | Kolkata, India | Time Out | 15/04/2021 | 17:00:50
DDD (004) | Support Staff | Kolkata, India | Time Out | 15/04/2021 | 17:01:25
EEE (005) | Support Staff | Kolkata, India | Time Out | 15/04/2021 | 17:10:20
FFF (006) | Support Staff | Kolkata, India | Time In | 16/04/2021 | 08:41:14
FFF (006) | Support Staff | Kolkata, India | Time Out | 16/04/2021 | 18:10:01
[NAME]
 |  |  |  |  |  |  |  |  |  | How to Generate Attendance Sheet:
Employee Name & ID: | Designation: | Working Address: | 15/04/2021 |  |  | 16/04/2021 |  |  |  | 1. Compare between attendace sheet date and raw data's date AND Compare between attence sheet Employee Name & ID and raw data's Employee Name & ID AND Compare between Attendance Sheet Time In and raw data's Time In, then result put in the attendance data's Time in cell.   2. Compare between attendace sheet date and raw data's date AND Compare between attence sheet Employee Name & ID and raw data's Employee Name & ID AND Compare between Attendance Sheet Time Out and raw data's Time Out, then result put in the attendance data's Time Out cell.  3. Total Hour = Time Out - Time In  4. If any data now matched / found then it will be N
 |  |  | Time In | Time Out | Total Hour | Time In | Time Out | Total Hour
AAA (001) | Support Staff | Kolkata, India
BBB (002) | Support Staff | Kolkata, India
CCC (003) | Support Staff | Kolkata, India
DDD (004) | Support Staff | Kolkata, India
EEE (005) | Support Staff | Kolkata, India
FFF (006) | Support Staff | Kolkata, India
This data will be fixed |  |  | I need help to generate this red portion
 |  |  | 08:21:16 | 17:30:20 |  | N | N | N
 |  |  | 08:21:43 | 17:15:10 |  | N | N | N
 |  |  | 08:37:35 | 17:00:50 |  | N | N | N
 |  |  | 08:41:14 | 17:01:25 |  | N | N | N
 |  |  | 08:43:16 | 17:10:20 |  | N | N | N
 |  |  | N | N | N | 08:41:14 | 18:10:01
Spreadsheet: 844069d1695882464-extract-string-of-letters-and-numbers-from-cells-geoart-challenge-list
Sheet: Geoart Lists GC5GV2W

List of Geoarts from a Challenge Cache
GC5GV2W | GC Number | GC Name
GC4XWJJ Lakeland Geocache Symbol#1 - near Cold Lake, AB - (07/25/21)
[NAME]
GC4EWEB - Georgia Star 11/13/2015
2 - GC2QWBT - Cedar City Moon 11/12/16
1/22/21 Gc 8kzp6 cupids arrow
3 -- 100 -- GC42K3G -- BC -- 09/10/2020 -- Kelowna’s Challenge Bear
TEST GC 22 Test
Test GC22 Test
NO code
Spreadsheet: 789465d1659105613-formula-to-write-1-in-each-cell-of-a-range-range-defined-by-two-cells-sample-file-12
Sheet: Sheet1

 |  |  |  |  |  |  | Starting Row # | Ending Row Number #
 |  |  |  | 1 |  |  | 4 | 25
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
 |  |  |  | 1
Spreadsheet: 857985d1706803510-equal-or-even-distribution-division-excelforum
Sheet: Sheet1

 |  | Total Students | 37
 |  | Students per group | 2 |  | Students per group | 3 |  | Students per group | 4 |  | Students per group | 5
 |  | Total Groups |  |  | Total Groups |  |  | Total Groups |  |  | Total Groups
 |  | Remaining Students |  |  | Remaining Students |  |  | Remaining Students |  |  | Remaining Students
 |  | Group 1 | 2 |  | Group 1 | 3 |  | Group 1 | 4 |  | Group 1 | 5
 |  | Group 2 | 2 |  | Group 2 | 3 |  | Group 2 | 4 |  | Group 2 | 5
 |  | Group 3 | 2 |  | Group 3 | 3 |  | Group 3 | 4 |  | Group 3 | 5
 |  | Group 4 | 2 |  | Group 4 | 3 |  | Group 4 | 4 |  | Group 4 | 5
 |  | Group 5 | 2 |  | Group 5 | 3 |  | Group 5 | 4 |  | Group 5 | 5
 |  | Group 6 | 2 |  | Group 6 | 3 |  | Group 6 | 4 |  | Group 6 | 4
 |  | Group 7 | 2 |  | Group 7 | 3 |  | Group 7 | 4 |  | Group 7 | 4
 |  | Group 8 | 2 |  | Group 8 | 3 |  | Group 8 | 3 |  | Group 8 | 4
 |  | Group 9 | 2 |  | Group 9 | 3 |  | Group 9 | 3 |  | Group 9 | 0
 |  | Group 10 | 2 |  | Group 10 | 3 |  | Group 10 | 3 |  | Group 10 | 0
 |  | Group 11 | 2 |  | Group 11 | 3 |  | Group 11 | 0 |  | Group 11 | 0
 |  | Group 12 | 2 |  | Group 12 | 2 |  | Group 12 | 0 |  | Group 12 | 0
 |  | Group 13 | 2 |  | Group 13 | 2 |  | Group 13 | 0 |  | Group 13 | 0
 |  | Group 14 | 2 |  | Group 14 | 0 |  | Group 14 | 0 |  | Group 14 | 0
 |  | Group 15 | 2 |  | Group 15 | 0 |  | Group 15 | 0 |  | Group 15 | 0
 |  | Group 16 | 2 |  | Group 16 | 0 |  | Group 16 | 0 |  | Group 16 | 0
 |  | Group 17 | 2 |  | Group 17 | 0 |  | Group 17 | 0 |  | Group 17 | 0
 |  | Group 18 | 2 |  | Group 18 | 0 |  | Group 18 | 0 |  | Group 18 | 0
 |  | Group 19 | 1 |  | Group 19 | 0 |  | Group 19 | 0 |  | Group 19 | 0
 |  | Group 20 | 0 |  | Group 20 | 0 |  | Group 20 | 0 |  | Group 20 | 0
 |  | Group 21 | 0 |  | Group 21 | 0 |  | Group 21 | 0 |  | Group 21 | 0
Spreadsheet: 584502d1533225863-how-to-get-the-information-of-one-sheet-in-another-sheet-row-wise-test-tt-260317
Sheet: preview

ABC | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON
TUE
WED
THU
FRI
SAT
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON
TUE
WED
THU
FRI
SAT
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON
TUE
WED
THU
FRI
SAT
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
MON
TUE
WED
THU
FRI
SAT
Spreadsheet: 701926d1603988556-weighted-average-filtering-a-table-with-a-text-pattern-ejemplo
Sheet: Datos

 | Bloque | Impresions | CTR
 | sgeek_m_preroll_home | 1 | 0.001
 | sgeek_m_preroll_inread | 2 | 0.002
 | sgeek_m_preroll_video | 3 | 0.003
 | podcast_990x90_02 | 4 | 0.004
 | podcast_990x90_03 | 5 | 0.005
 | podcast_990x90_04 | 6 | 0.006
 | Total
podcast* | Only Podcast
Spreadsheet: 273175d1382629725-sumif-problem-117
Sheet: Goals vs. Actual

 |  | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Target | Actual
Date |  | Daily Budget |  | Travalos |  | Premiers |  | Mailouts |  | Trans |  | Units
Store Goals
Sunday,
Monday,
Tuesday,
Wednesday,
Thursday,
Friday,
Saturday,
Weekly Total
Sunday,
Monday,
Tuesday,
Wednesday,
Thursday,
Friday,
Saturday,
Week-to-Date
Sunday,
Monday,
Tuesday,
Wednesday,
Thursday,
Friday,
Saturday,
Weekly Total
Sunday,
Monday,
Tuesday,
Wednesday,
Thursday,
Friday,
Saturday,
Weekly Total
Monthly Totals
Spreadsheet: 810109d1671549014-cant-find-correct-formula-to-find-of-volume-that-can-be-produced-in-certain-hour-example-capacity-vs-volume-v2
Sheet: Sheet1

Hour | Production Capacity per hour | Production volume available | Over capacity | Over volume | % of volume from hour that can be produced | Comment
5 | 0 | 7.952782137991804 |  |  | 1 | 100% because the 8 items can be produced in future hours that have production capacity left
6 | 0 | 36.20041896572922 |  |  | 1 | 100% because the 36 items can be produced in future hours that have production capacity left
7 | 0 | 396.4436599035777 |  |  | 1 | 100% because the 396 items can be produced in future hours that have production capacity left
8 | 600 | 609.267709709173 |  |  | 1 | 100% because the 9 items can be produced in future hours that have production capacity left
9 | 600 | 432.3394532962715 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced (+ 168 extra from the over volume we build up above)
10 | 600 | 344.0775876991064 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced (+ 256 extra from the over volume we build up above)
11 | 600 | 418.9859619927965 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced (+ 26 extra from the over volume we build up above)
12 | 600 | 262.8015993439625 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
13 | 600 | 406.2904464414213 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
14 | 600 | 447.0132260567641 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
15 | 600 | 426.4408991195646 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
16 | 600 | 863.4898522992775 |  |  | 1 | 100% because all the 263 items over-volume can be processed in future hours (20+413=433 is enough to process these 263 items)
17 | 600 | 860.1854615467483 |  |  | 0.65 | 65% because from the 260 items over-volume only a part can be produced (20+413=433. 433-263=170. 170/260=65%)
18 | 600 | 579.8056877258844 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
19 | 600 | 878.9928908119233 |  |  | 0.6825993773917576 | 68% because there is no capacity left in future hours to process any extra so 600/879
20 | 600 | 667.7133293606018 |  |  | 0.8985892202789426 | 90% because there is no capacity left in future hours to process any extra so 600/668
21 | 600 | 799.2510120329042 |  |  | 0.7507028342371354 | 75% because there is no capacity left in future hours to process any extra so 600/799
22 | 600 | 692.2458650551082 |  |  | 0.8667440721400846 | 87% because there is no capacity left in future hours to process any extra so 600/692
23 | 600 | 791.5078766584953 |  |  | 0.758046783479928 | 76% because there is no capacity left in future hours to process any extra so 600/792
0 | 600 | 186.5791819043462 |  |  | 1 | 100% because all productionvolume generated in this hour can be produced
Spreadsheet: 112205d1308318250-simplify-a-complex-formula-sample1
Sheet: June

June Numbers as of 06/16/2011
Name | # | W1 | [NAME] | U1 | U2 | EMS | Com. | Total
name | 7 | 12345 | 67894
name | 13 | 67894 | 5495.12
name | 9 | 42513 | 4512.12
name | 20 | 4512.12 | 21654
name | 8 | 12345 | 12345 |  |  | 5
name | 16 | 4512.12 | 5495.12
name | 10 | 4512.12 | 4512.12
name | 24 | 4512.12 | 1245
name | 23 | 4512.12 | 520
---------------------------------------------------------------------------------
name | 21 | 124 | 520 | 1111 | 6548 | 6842
name | 22 |  |  | 1111 | 1245 | 6548
 |  |  |  |  | W Total
 |  |  |  |  | U, EMS, & Com Total
 |  |  |  |  | TOTAL
Spreadsheet: 867341d1714156406-help-on-lookup-to-pull-most-recent-value-based-on-most-recent-date-for-larger-dataset-sample_workbook1
Sheet: calculations

 | Against smaller dataset, formula works
 | cust_id | change_datetime_phone1 | street1
 | 111 |  | 125 street
 | Against larger dataset, I am getting an error
 | cust_id | change_datetime_phone1 | street1
 | 111
 | 112
 | 113
 | 114
 | 115
 | 116
 | 117
 | 118
Spreadsheet: benjamin_rogers__1039__Consolidated 6 Peaker-051800
Sheet: Summary Output

Unhide Sub Debt, 1999 Columns
SUMMARY OUTPUT
SOURCES & USES:
Sources of Funds | % | 000 $ |  | Uses of Funds | % | 000 $
Total Equity |  |  |  | 1999 Plants
Bond Proceeds |  |  |  | 2000 Plants
Amortization of Contract |  |  |  | Amortization of Contract
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 $) | 65000 | 175000 | 450000
Term (yrs)
Final Maturity |  | 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 $) | 594253.7631130051
Required After-Tax Rate of Return (%) | 0.14
DEPRECIATION ASSUMPTIONS:
 | Initial Basis (000 $)
 | 1999 | 2000 | Year | Method | Residual (%)
Federal & State Tax Depreciation
Total Project Cost less Transaction Cost & Amortization of Contract |  |  | 15 | MACRS | 0
Transaction Cost (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
Weighted Average Heat Rate (Btu/kWh)
Total Summer Capacity for 1999 & 2000 Projects (MW)
Salvage Value at the end of 20 years ($/kW)
Equity Partner'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: 273994d1382978603-if-sort-sample-book_alkey
Sheet: Sample 2 Raw

Application | Start Date | Minutes impacted | App1 | App2
App1 | 2012-10-01 00:00:00 | 50
App2 | 2012-10-02 00:00:00 | 65
App1 | 2012-10-05 00:00:00 | 55
App2 | 2012-10-05 00:00:00 | 55
App1 | 2012-10-06 00:00:00 | 45
App2 | 2012-10-10 00:00:00 | 54
 |  |  |  |  | On this sheet, the raw data is manually entered
Spreadsheet: 823643d1680072071-using-let-to-collate-data-and-sorting-data-based-off-date-column-excel-help-8
Sheet: Tim

 | Name | Position | State | Clinic | Hiring Manager | Entity | Employment Type | Completed | Start Date
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | True | 2022-09-12 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PPT | True | 2022-10-14 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | True | 2022-09-19 00:00:00
 | Mathias Friedman | MR | SA | PRA | [NAME] | 1 | Fixed Casual | True | -
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | True | -
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | True | 2022-08-29 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Fixed Casual | True | 2022-09-19 00:00:00
Spreadsheet: 264656d1378928960-can-excel-get-all-names-in-a-column-and-exclude-duplicates-validatefrompivot
Sheet: Sheet1

names |  |  |  |  |  |  |  |  |  |  |  | Row Labels
martin50 |  |  |  |  |  |  |  |  |  |  |  | dave1
fred 1 |  |  |  |  |  |  |  |  |  |  |  | dave2
[NAME] |  |  |  |  |  |  |  |  |  |  |  | dave3
martin8 |  |  |  | names are |  |  |  |  |  |  |  | [NAME]
martin1 |  |  |  | mydropdown | =Sheet1!$M$2:INDEX(Sheet1!$M:$M,COUNTA(Sheet1!$M$2:$M$200)+1) |  |  |  |  |  |  | [NAME]
martin3 |  |  |  | mypivot | =Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A)) |  |  |  |  |  |  | [NAME]
fred 3 |  |  |  |  |  |  |  |  |  |  |  | dave7
martin7 |  |  |  | pivot table source=mypivot |  |  |  |  |  |  |  | fred 1
martin3 |  |  |  | validation = mydropdown |  |  | in cell f1 |  |  |  |  | fred 2
[NAME] |  |  |  |  |  |  |  |  |  |  |  | fred 3
[NAME] |  |  |  | add names to col a then refresh pivot |  |  |  |  |  |  |  | fred 4
martin5 |  |  |  |  |  |  |  |  |  |  |  | martin1
martin7 |  |  |  |  |  |  |  |  |  |  |  | martin10
martin6 |  |  |  |  |  |  |  |  |  |  |  | martin11
martin4 |  |  |  |  |  |  |  |  |  |  |  | martin12
martin6 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
martin5 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
martin10 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
fred 4 |  |  |  |  |  |  |  |  |  |  |  | martin3
fred 1 |  |  |  |  |  |  |  |  |  |  |  | martin4
martin10 |  |  |  |  |  |  |  |  |  |  |  | martin5
[NAME] |  |  |  |  |  |  |  |  |  |  |  | martin6
fred 2 |  |  |  |  |  |  |  |  |  |  |  | martin7
fred 3 |  |  |  |  |  |  |  |  |  |  |  | martin8
martin11 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
fred 2 |  |  |  |  |  |  |  |  |  |  |  | martin50
martin12 |  |  |  |  |  |  |  |  |  |  |  | martin51
[NAME]
fred 4
[NAME]
martin11
martin12
[NAME]
martin4
[NAME]
martin1
dave1
dave2
dave3
[NAME]
[NAME]
[NAME]
dave7
martin51