tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 463059d1464283100-threat-matrix-tiering-system-threat-matrix-ndm-4-
Sheet: Sheet1

Criteria
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
TOTALS
Gang | Question | Answer | Score |  |  | Question
 |  | 8 |  |  | Answer | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  | 3 |  |  | 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 |  | 2 |  |  | 2 | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30
 |  | 9 |  |  | 3 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 | 39 | 42 | 45
 |  | 5 |  |  | 4 | 4 | 8 | 12 | 16 | 20 | 24 | 28 | 32 | 36 | 40 | 44 | 48 | 52 | 56 | 60
 |  | 5 |  |  | 5 | 5 | 10 | 15 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75
 |  | 5 |  |  | 6 | 6 | 12 | 18 | 24 | 30 | 36 | 42 | 48 | 54 | 60 | 66 | 72 | 78 | 84 | 90
 |  | 4 |  |  | 7 | 7 | 14 | 21 | 28 | 35 | 42 | 49 | 56 | 63 | 70 | 77 | 84 | 91 | 98 | 105
 |  | 3 |  |  | 8 | 8 | 16 | 24 | 32 | 40 | 48 | 56 | 64 | 72 | 80 | 88 | 96 | 104 | 112 | 120
 |  | 7 |  |  | 9 | 9 | 18 | 27 | 36 | 45 | 54 | 63 | 72 | 81 | 90 | 99 | 108 | 117 | 126 | 135
 |  | 1 |  |  | 10 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150
 |  | 1
 |  | 1
 |  | 4
 |  | 5
 |  | 2
 |  | 8
 |  | 7
 |  | 4
 |  | 7
 |  | 4
 |  | 7
 |  | 1
 |  | 9
 |  | 5
 |  | 9
 |  | 1
 |  | 4
 |  | 1
 |  | 2
 |  | 2
 |  | 9
 |  | 5
 |  | 5
 |  | 9
 |  | 6
 |  | 8
 |  | 5
 |  | 10
 |  | 8
 |  | 6
 |  | 6
 |  | 3
 |  | 8
 |  | 1
 |  | 2
 |  | 7
 |  | 2
 |  | 2
 |  | 4
 |  | 6
 |  | 8
 |  | 10
 |  | 10
 |  | 8
 |  | 5
 |  | 8
 |  | 4
 |  | 2
 |  | 2
 |  | 10
 |  | 10
 |  | 7
 |  | 7
 |  | 10
 |  | 7
 |  | 4
 |  | 10
 |  | 4
 |  | 8
 |  | 10
 |  | 8
 |  | 6
 |  | 6
 |  | 7
 |  | 3
 |  | 3
 |  | 3
 |  | 5
 |  | 1
 |  | 5
 |  | 6
 |  | 10
 |  | 5
 |  | 1
 |  | 3
 |  | 8
 |  | 6
 |  | 9
 |  | 2
Spreadsheet: 455610d1460432989-how-do-i-set-up-my-recipe-so-that-my-ingredients-and-costs-transfer-over-doggie-delights-inventory-and-sales-v1
Sheet: Inventory

 | Inventory
 | Items Currently Instock | Product | Size | Starting Stock
 |  | Assorted | Small | 5
 |  | Assorted | Medium | 5
 |  | [NAME] | Small | 2
 |  | [NAME] | Medium | 3
 |  | Bowser's Best Biscuits | Small | 4
 |  | Bowser's Best Biscuits | Medium | 5
 |  | Breath Busters | Small | 0
 |  | Breath Busters | Medium | 0
 |  | Carrot & Green Bean Veggie Bites | Small | 2
 |  | Carrot & Green Bean Veggie Bites | Medium | 1
 |  | Carrot Cookies | Small | 7
 |  | Carrot Cookies | Medium | 5
 |  | Carrot [NAME] | Small | 0
 |  | Carrot [NAME] | Medium | 4
 |  | Emma's Rewards | Small | 3
 |  | Emma's Rewards | Medium | 3
 |  | [NAME] | Small | 4
 |  | [NAME] | Medium | 2
 |  | Green Bean Veggie Bites | Small | 1
 |  | Green Bean Veggie Bites | Medium | 2
 |  | Henry's Power Crisps | Small | 2
 |  | Henry's Power Crisps | Medium | 1
 |  | [NAME] | Small | 0
 |  | [NAME] | Medium | 0
 |  | Low-Fat Beef & Bean | Small | 0
 |  | Low-Fat Beef & Bean | Medium | 0
 |  | Low-Fat Chicken & Bean | Small | 0
 |  | Low-Fat Chicken & Bean | Medium | 4
 |  | Low-Fat Moose Cookies | Small | 0
 |  | Low-Fat Moose Cookies | Medium | 4
 |  | Minty Stars | Small | 0
 |  | Minty Stars | Medium | 0
 |  | Moose Snaps | Small | 3
 |  | Moose Snaps | Medium | 4
 |  | Nemo's Nibblers | Small | 8
 |  | Nemo's Nibblers | Medium | 14
 |  | Peanut Butter Bites | Small | 0
 |  | Peanut Butter Bites | Medium | 0
 |  | [NAME] (Gluten Free) | Small | 0
 |  | [NAME] (Gluten Free) | Medium | 0
 |  | Reilly's Oatmeal Bites | Medium | 3
 |  | [NAME] | Small | 5
 |  | [NAME] | Medium | 2
 |  | Total Small Inventory
 |  | Total Medium Inventory
 |  | Total Inventory
Spreadsheet: 102230d1300213960-autofill-based-on-relationships-book2
Sheet: Sheet1

ID 1 | ID 2
1 | 100
2 | 101
1 | 102
2 | 103
1 | 104
2 | 105
2 | 106
3 | 107
4 | 108
5 | 109
Spreadsheet: phillip_m_love__30145__200003_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Denver |  | Texas-HPLR |  | Texas-EGM |  | Texas-HPLC |  | Storage |  | Ontario |  | Aruba |  | Sithe |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 0 |  |  | -138 |  |  |  |  | 0
2 |  | Liquidations |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 5000
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  | 0 |  | 2029585 |  |  |  |  |  | 214900 |  |  |  |  |  |  |  |  |  |  |  | 64775 |  |  |  | 0 |  | -4004028
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  | -6444 |  | 6444 |  |  |  |  |  |  |  |  | 138 | -2887352
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage |  |  |  |  |  |  |  |  |  |  | 1797081
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg) |  |  |  |  |  |  |  |  |  |  | -1797081 | -4352530
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel: |  |  |  |  | 208782
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  | 34847 |  |  |  |  |  | 0 |  | 311714 |  |  |  |  |  | 93300 |  |  |  | 0 |  | 547052 |  |  |  | -34847
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1556140
31 |  | Prior Month Book Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1556140
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 174746 |  | 0 |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  |  |  | -311714
 |  | TOTAL
Spreadsheet: 108980d1305897208-how-to-pick-out-multiple-values-from-a-range-that-are-in-a-separate-table-forum-example2
Sheet: Sheet2

 | 2011-01-01 00:00:00 |  | 2011-02-03 00:00:00 |  | 2011-02-04 00:00:00 |  | 2011-02-05 00:00:00 |  | 2011-04-05 00:00:00 |  | 2011-04-22 00:00:00 |  | 2011-05-01 00:00:00 |  | 2011-06-06 00:00:00 |  | 2011-09-13 00:00:00 |  | 2011-10-01 00:00:00 |  | 2011-10-05 00:00:00 |  | 2011-12-20 00:00:00 |  | 2011-12-22 00:00:00 |  | 2011-12-25 00:00:00
 | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN | PHW/PHO | DIL TAKEN
Spreadsheet: 762481d1641573436-weekday-workday-holidays-formula-to-calculate-finish-date-formula-sample-workbook
Sheet: WORKDAY FORMULA

JOB | HRS | DAYS | PROJECTED START | PROJECTED FINISH |  |  | HOLIDAYS
1 | 2 |  |  |  |  |  | 2022-01-10 00:00:00
2 | 4 |  |  |  |  |  | 2022-01-11 00:00:00
3 | 6 |  |  |  |  |  | 2022-01-12 00:00:00
4 | 8 |  |  |  |  |  | 2022-01-13 00:00:00
5 | 10 |  |  |  |  |  | 2022-01-14 00:00:00
6 | 8
7 | 6
8 | 4
9 | 2
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 11c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | <100 | <100 | <100 |  |  |  |  | <100 |  | <100
FRA |  |  | <100 | <100 |  | <100 |  | <100 |  | <100
IRS- [NAME] | 760 | 838 | 538 | <100 |  | 142 | 192 | 459 | 486 | 3415
OIS |  | <100 | <100 |  |  |  |  |  |  | <100
VNS
Zero Coupon |  | <100 |  |  |  |  |  |  |  | <100
TOTAL | 760 | 838 | 538 | <100 |  | 142 | 192 | 459 | 486 | 3415
Estimated swap transaction volumes, week ending February 1, by product type and major currency (millions of USD), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for major currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 793620d1661583647-group-by-year-and-quarter-from-dynamic-array-date-sequence-year-and-quarter-dynamic
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25
2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00
 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00
 |  |  | Desired Result
 |  |  |  |  |  |  |  |  |  |  |  | Dynamic Range
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9
2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024
Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19
2022-11-30 00:00:00 | 2022-12-31 00:00:00 | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00
 |  |  | Desired Result
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
2022 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024
Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2
Spreadsheet: 83928d1283963171-lookup-and-count-if-meeting-criteria-sumproduct_resourcesusage-1-
Sheet: report

 | SUMPRODUCT (All versions of Excel)
 | Resources | Usage <1 | Usage 2-4 | Usage>5
 | asset1 | 1 | 0 | 1
 | asset2 | 0 | 1 | 0
 | asset3 | 0 | 1 | 0
 | asset4 | 0 | 1 | 0
 | asset5 | 0 | 0 | 1
 | COUNTIFS (2007 onwards) This will return #[NAME]? error with earlier versions
 | Resources | Usage <1 | Usage 2-4 | Usage>5
 | asset1 | 1 | 0 | 1
 | asset2 | 0 | 1 | 0
 | asset3 | 0 | 1 | 0
 | asset4 | 0 | 1 | 0
 | asset5 | 0 | 0 | 1
Spreadsheet: 0f30e2ab-8343-49fc-857c-6d120f507a6b
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Contributor Organizations | Host Website | Format | Availability | DOI | Full Text
Image Gallery of the U.S. Global Change Research Program |  |  | 1091087 |  |  |  | Collection | Still Images or Photos |  |  | U.S. Department of Energy (DOE); National Science Foundation (NSF): U.S. Department of Agriculture (USDA); U.S. Department of Commerce; U.S. Department of Defense (DOD); U.S. Department of Health and Human Services; U.S. Department of the Interior; U.S. Department of State; U.S. Department of Transportation; Environmental Protection Agency; National Aeronautics and Space Administration; Smithsonian Institution; U.S. Agency for International Development | 54 ENVIRONMENTAL SCIENCES | Global Change Research; Climate Change | More than 700 non-copyrighted images related to global climate change are available for free download from the U.S. Global Change Research Program at globalchange.gov. The only requirement is to give a photo credit when using an image in your own publication or on your website. Thumbnails are grouped by year from 2003 to the present and are easy to scroll through, enlarge, and save to your own device. |  | U.S. Global Change Research Program (globalchange.gov) |  |  |  | http://www.osti.gov/dataexplorer/servlets/purl/1091087
Spreadsheet: 708376d1607770681-convert-multiple-columns-to-multiple-rows-sample_columns-to-rows
Sheet: Sheet4

EE Name | tin | tout
[NAME] | 12/08/2020 08:00:00 | 12/08/2020 17:00:00
[NAME] | 12/09/2020 08:00:00 | 12/09/2020 17:00:00
Trump | 13/09/2020 08:00:00 | 12/09/2020 17:00:00
Trump | 13/09/2020 08:00:00 | 12/09/2020 17:00:00
Biden | 14/09/2020 08:00:00 | 12/09/2020 17:00:00
Biden | 14/09/2020 08:00:00 | 12/09/2020 17:00:00
Spreadsheet: 111725d1308056284-matching-duplicate-data-to-different-categories-in-sorted-array-arraymatchproblem
Sheet: Sheet1

A | 50 |  | I | 95 |  | I | 95
B | 22 |  | H | 78 |  | H | 78
C | 24 |  | A | 50 |  | A | 50
D | 0 |  | A | 50 |  | L | 50
E | 3 |  | J | 40 |  | J | 40
F | 0 |  | P | 30 |  | P | 30
G | 0 |  | C | 24 |  | C | 24
H | 78 |  | C | 24 |  | K | 24
I | 95 |  | B | 22 |  | B | 22
J | 40 |  | N | 8 |  | N | 8
K | 24 |  | O | 6 |  | O | 6
L | 50 |  | E | 3 |  | E | 3
M | 0 |  | D | 0 |  | D | 0
N | 8 |  | D | 0 |  | F | 0
O | 6 |  | D | 0 |  | G | 0
P | 30 |  | D | 0 |  | M | 0
Spreadsheet: 776545d1649781484-formula-must-ignore-empty-cells-actually-containing-formula-but-showing-empty-book4
Sheet: Sheet1

 | dgfhicjskeoiuis
Spreadsheet: benjamin_rogers__1264__NewCo-7-15-00
Sheet: Pacific Crest

Pacific Crest
INCOME STATEMENT
('000 $) |  |  | 1999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Net Total
Revenue
PPA Period:
Demand Payment |  |  | 1
Energy Payment |  |  | 1
Block Payment |  |  | 1
Market Period:
Demand Payment |  |  | 1
Variable Revenue |  |  | 1
Energy Margin |  |  | 1
Interest Income |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel  (Includes Fixed Transportation) |  |  | 0
Fixed O&M |  |  | 0
Variable O&M |  |  | 0
Major Maintenance & Ongoing Capex (Cash) |  |  | 0
Insurance |  |  | 0
SG&A |  |  | 0
Utility Start Up Power (included in O&M) |  |  | 0
Property, Other Taxes |  |  | 0
Debt Service L/C Fee |  |  | 0
Marketing Fee |  |  | 0
Administrative Fee |  |  | 0
O&M Fees |  |  | 0
Total Expense
EBITDA
Depreciation & Amortization |  |  |  | 0
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense) |  | 0.05
Shareholder Fed. Tax Benefit / (Expense) |  | 0.35
Net Income
PTC
CASH FLOW
FPLE Interest |  | 0.5
('000 $) |  |  | 1999
EBITDA
Capital Expenditures |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service
 |  |  |  | 0
Pre Tax Cash Flow
Cash Taxes Benefit (Expense)
After Tax Cash Flow
Net Income to FPLE
Distributable Cash to FPLE
Valuation
Pre Tax Cash Flow
Tax Benefit / (Expense)
PTC
Residual Value |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
After Tax Cash Flow |  |  |  | -59108.83051374373
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual Value
NPV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019 EBITDA
Equity Discount Rate |  | 0.09 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjustment Factor |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted EBITDA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EBITDA Multiple |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual Value
Depreciable Basis
Debt (12/31/00)
Equity
Percent Depreciable |  |  | 0.9
Depreciable Basis
GAAP Depreciation
Life | 30 | SL
Additional Depreciation @ FPLE
Tax Depreciation
Basis
Depreciation Rate: 5 Year 200% MACRS HY |  |  |  |  | 0.2 | 0.32 | 0.192 | 0.1152 | 0.1152 | 0.0576 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tax Depreciation
Additional Depreciation @ FPLE
Taxable Income
Tax Depreciation
Interest Expense
Taxable Income
State Income Tax
Federal Income Tax
FPLE Net Income
Interest Income - Loan Receivable
Fee Income
Total Other Income
State Taxes
Federal Taxes
Net Income from Interest and Fee to FPLE
Total FPLE Net Income
FPLE Other Cash Flows
Principal on Note Receivable
NPV
Equity Discount Rate
Valuation of FPLE's Project Interest
FPLE's Share of Project Equity
Note Receivable
Capital Contribution
PV of Fee Income
Value of FPLE's Interest
Spreadsheet: 544839d1509048813-changing-color-of-line-chart-with-source-data-chart-samples
Sheet: Fill Between 2 Sets

a | b | c | ab temp | ac temp
1 | 5 | 3 |  |  | can also use array in place of c temp for source data
2 | 4 | 3
3 | 4 | 5 |  |  |  | secondary axis to use 2 lines 2 shades
4 | 3 | 5
5 | 2 | 4
6 | 2 | 3
7 | 2 | 4
8 | 1 | 2
Spreadsheet: 180445d1347606976-individual-record-to-show-in-one-click-dummy-for-individual-training-record
Sheet: Sheet2

Enter an Employee | Total Hours
Kunal Kumar
Training Topic | Hours |  | 0
Spreadsheet: 821279d1678571203-filtering-subjects-which-have-value-10-and-arrange-subjects-in-one-cell-for-each-student-book3
Sheet: Sheet1

current data
 |  |  |  |  |  |  |  |  |  | Output
Subject: | A | B | C | D | 10 |  |  |  |  | Name 1 | A,D
Name 1 | 10 | 0 | 0 | 10 |  |  |  |  |  | Name 2 | B,C
Name 2 |  | 10 | 10 |  |  |  |  |  |  | Name 3 | D
Name 3 | 0 | 0 | 0 | 10
Spreadsheet: 836525d1689444736-use-aggregate-function-with-multiple-criteria-book1
Sheet: Sheet1

Lv | Whatever
1 | 0.1
2 | 0.1
3 | 0.1
4 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
6 | 0.1
6 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
5 | 0.1
6 | 0.1
5 | 0.1
8 | 0.1
9 | 0.1
6 | 0.1
5 |  |  | Firstly need to sum the values of each lv which should be rounded-up to 0 dp on each lv
5 |  |  | [NAME] work but need to account for hidden rows & error values
Sum Of Spec'd Floors
01:03 |  |  | Secondly need to sum values of a specified range, with the same rounded-up conditions (Lv) as each floor above. Specfified range needs to be dynamic (not fixed).
01:03 |  |  | [NAME] works but want to use aggregate to avoid error & hidden values.
Spreadsheet: 136347d1326556736-copy-data-if-planning
Sheet: Import

ID | Prio | RFC | Titel | Deadline | Status | Change | FM/ Opdrachtgever | DM | Ontwerp | Rev. [NAME] | Uitvoering | Def. review | Live | Totaal uren | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24 | Week 25 | Week 26 | Week 27 | Week 28 | Week 29 | Week 30 | Week 31 | Week 32 | Week 33 | Week 34 | Week 35 | Week 36 | Week 37 | Week 38 | Week 39 | Week 40 | Week 41 | Week 42 | Week 43 | Week 44 | Week 45 | Week 46 | Week 47 | Week 48 | Week 49 | Week 50 | Week 51 | Week 52
1 | 1 | 1444 | 1444 RFC excamle 1 | 2011-10-28 00:00:00 | Gereed | Minor |  | Martijn |  |  |  |  |  | 0
2 | 0 | 2127 | 2127 RFC excamle 2 | 2012-01-01 00:00:00 | On hold | Minor | Kees | Martijn |  |  |  |  |  | 0
3 | 1 | 2133 | 2133 RFC excamle 3 | 2012-01-01 00:00:00 | Gereed | Minor | [NAME] | Martijn |  |  |  |  |  | 0
4 | 1 | 2187 | 2187 RFC excamle 4 | 2012-01-01 00:00:00 | Gereed | Medium NonTech | Esther | [NAME] |  |  |  |  |  | 0
5 | 1 | 2188 | 2188 RFC excamle 5 | 2012-01-01 00:00:00 | Gereed | Medium NonTech | Esther | Martijn |  |  |  |  |  | 0
6 | 1 | 2116 | 2116 RFC excamle 6 | 2012-01-05 00:00:00 | Gereed | Minor | [NAME] | Martijn |  |  |  |  |  | 0
7 | 1 | OPL | OPL: Comon tasks | 2012-12-31 00:00:00 | Werkende | Opleiding |  | [NAME] |  |  |  |  |  | 208 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
8 | 2 | OPL | excample 1 | 2012-07-01 00:00:00 | Oppakken | Opleiding |  | Martijn |  |  |  |  |  | 60 | 60
9 | 2 | OPL | excample 2 | 2012-03-31 00:00:00 | In afwachting | Opleiding | Roos | [NAME] |  |  |  |  |  | 40 | 40
10 | 1 | OPL | excample 3 | 2012-04-15 00:00:00 | On hold | Opleiding | Kees | [NAME] |  |  |  |  |  | 32 | 32
11 | 2 | OPL | excample 4 | 2012-10-15 00:00:00 | On hold | Opleiding | Kees | [NAME] |  |  |  |  |  | 32 | 32
Spreadsheet: b3736972-f1d5-4af6-a6e8-f3befb94a7c2
Sheet: non-GAAP Operating Income

The NASDAQ OMX Group, Inc.
Reconciliation of GAAP to Non-GAAP Operating Income
(in millions)
(unaudited)
 |  | Three Months Ended
 |  | December 31, |  | September 30, |  | December 31,
 |  | 2010 |  | 2010 |  | 2009
GAAP Operating Income: |  | 175 |  | 165 |  | 149
Adjustments:
Professional fees |  | 1 |  | 0 |  | 2
Technology |  | 2 |  | 0 |  | 3
Occupancy |  | 1 |  | 2 |  | 8
Workforce reductions |  | 2 |  | 2 |  | 6
Merger and strategic initiatives |  | 3 |  | 1 |  | 0
Asset retirements |  | 0 |  | 2 |  | 0
Foreign currency revaluation |  | 0 |  | -3 |  | 0
Regulatory |  | 0 |  | 0 |  | -3
Total Adjustments |  |  |  |  |  | 16
Non-GAAP Operating Income |  |  |  |  |  | 165
Total revenues less transaction rebates, brokerage,
clearance and exchange fees |  | 400 |  | 372 |  | 369
Non-GAAP Operating Margin (1) |  |  |  |  |  | 0.4471544715447154
(1) Non-GAAP Operating Margin equals Non-GAAP Operating Income divided by total revenues less transaction rebates,
brokerage, clearance, and exchange fees.
Spreadsheet: 885704d1735533242-match-and-array-not-working-at-all-worksheet-not-working
Sheet: DATA

13 |  | 420 RAMP | 70mm |  | LH |  | 0 |  | 100x50x3 NWF | NWF 01 | S1: LEFT HAND EXTRUSION
17 |  | 550 RAMP | 220mm |  | RH |  | 15 |  | 150x50x3 NWF | NWF 01 | S1: RIGHT HAND EXTRUSION
 |  | 655 RAMP | 327mm |  | CHOOSE |  | 30 |  | CHOOSE | NWF 01 | T1: TOP EXTRUSION
 |  | 800 RAMP | 472mm |  |  |  |  |  |  | NWF 01 | T1: BOTTOM EXTRUSION
 |  | 850 RAMP | 522mm |  |  |  |  |  |  | NWF 02 | T2a: TRANSOM
 |  | 1010 RAMP | 682mm |  |  |  |  |  |  | NWF 04 | T2b: TRANSOM
 |  | 1350 RAMP | 1022[NAME] |  |  |  |  |  |  | NWF 04 | T1: TOP EXTRUSION
 |  | CHOOSE | CHOOSE |  |  |  |  |  |  | NWF 04 | T1: BOTTOM EXTRUSION
Spreadsheet: 39145d1237344664-vlookup-list-problem-schedule-weekly
Sheet: list

ITEM Code | ITEM | Category | Unit per Pkg | Type | Unit per Case | Pgk Wgt | [NAME]
63602 | 1
116 | 2
325 | 3
331 | 4
61412 | 5
66093 | 6
68001 | 7
68002 | 8
64001 | 9
64002 | 10
64003 | 11
9801662 | 12
1772 | 13
68003 | 14
61425 | 15
68005 | 16
68006 | 17
61423 | 18
68007 | 19
6138 | 20
68008 | 21
1863 | 22
9104 | 23
68009 | 24
6413 | 25
737 | 26
68010 | 27
941 | 28
68003s | 29
1919 | 33 | new #
68011 | 34 | new #
1927 | 35 | new #
A1919 | 30
A68011 | 31
[NAME] | 32
End List