tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1071__Consolidated 2000 Peaker 8-15-00
Sheet: Gleason

INCOME STATEMENT - GLEASON
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
Revenue
Merchant Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Variable Revenue
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 174.46 | 348.92 | 436.15 | 436.15 | 436.15 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 872.3 | 872.3 | 1308.45 | 743.9310449999999 | 758.8096658999999 | 773.985859218 | 789.4655764023599 | 805.2548879304072
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - GLEASON
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA
Plus Property Tax Liability
Less Property Tax Expense | -92.2251014
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - GLEASON
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Book Value of Assets
Paid-In-Capital
[NAME]
Outstanding Debt
Total Capitalization
Greater of Book Value and Capitalization
State Franchise Tax Rate
State Franchise Tax Liability | 570.3529586993795 | 547.9125512817553 | 530.4259804961674 | 512.9394097105795 | 495.4528389249916 | 477.9662681394037 | 460.4796973538158 | 442.9931265682279 | 425.50655578264 | 408.0199849970521 | 390.5334142114642 | 373.0468434258763 | 355.5602726402884 | 338.0737018547005 | 320.5871310691126 | 303.1005602835246 | 285.6139894979367 | 268.1274187123487 | 250.6408479267608 | 233.1542771411729
STATE TAXES
Pretax Book Income
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: tracy_geaccone__40581__Reconciliation_OrigPlan
Sheet: Sheet1

2001 Plan Reconciliation
O&M Expense
 |  | NNG |  | TW |  | FGT |  | NBPL |  | HPL
Orig. Plan - Operations |  | 88467 |  | 22107 |  | 28269 |  | 15914 |  | 12990
Adjustments:
KN Reimbursements
Remediation |  | 400 |  | 900
Overhaul Amortization |  | 433 |  | 333
[NAME]
PCB Testing - SoCal |  |  |  | 463
PCB Testing - PG&E |  |  |  | 1000
Total Direct - Original Plan
Spreadsheet: 297887d1392639698-name-sorting-based-on-highest-total-value-sorting
Sheet: Details

No | Players Name | Runs | Balls
1 | Vembuli | 28 | 50
2 | Ganesh | 8 | 21
3 | Praveen | 26 | 16
4 | [NAME] | 6 | 6
5 | [NAME] | 4 | 2
6 | Ravi | 3 | 4
7 | [NAME] | 0 | 2
8 | Gopi | 1 | 5
9 | Santhosh | 0 | -
10 | Raji | 0 | -
11 | Surendar | 0 | -
1 | Vembuli | 3 | 9
2 | Ganesh | 25 | 35
3 | Vijay | 52 | 50
4 | Praveen | 8 | 13
5 | Marimuthu | 0 | -
6 | [NAME] | 0 | -
7 | Ravi | 0 | -
8 | Gopi | 0 | -
9 | [NAME] | 0 | -
10 | Anand | 0 | -
1 | Vembuli | 31 | 20
2 | Ganesh | 15 | 23
3 | Vijay | 0 | 1
4 | Marimuthu | 2 | 4
5 | Praveen | 0 | -
6 | [NAME] | 0 | -
7 | Ravi | 0 | -
8 | [NAME] | 0 | -
9 | Gopi | 0 | -
10 | Santhosh | 0 | -
11 | [NAME] | 0 | -
1 | Vembuli | 26 | 23
2 | Ganesh | 1 | 4
3 | [NAME] | 7 | 17
4 | [NAME] | 7 | 6
5 | Praveen | 0 | 2
6 | Vijay | 8 | 7
7 | Ravi | 0 | 2
8 | [NAME] | 4 | 3
9 | Gopi | 0 | -
10 | [NAME] | 0 | -
11 | Marimuthu | 2 | 2
1 | Vembuli | 27 | 38
2 | Ravi | 1 | 2
3 | Vijay | 1 | 3
4 | Marimuthu | 13 | 14
5 | Praveen | 15 | 12
6 | [NAME] | 10 | 13
7 | White | 2 | 4
8 | Raji | 3 | 3
9 | Santhosh | 4 | 2
10 | Surendar | 2 | 1
11 | [NAME] | 0 | -
Spreadsheet: 674883d1588067056-sumif-formula-returning-0-2020-04-28-oeldere-mitch1989-table-674876d1588065325-multiple-if-criteria-example
Sheet: Sheet1

Plan Type | Type | Discount Code | Commission Rate % |  |  |  |  |  |  |  |  | table
POWER | A | YES |  |  |  |  | Power plans with discount code at 5% |  |  |  |  | POWER YES | 0.05
POWER | M | YES |  |  |  |  | Standard plans with discount code at 10% |  |  |  |  | STARDARD YES | 0.1
STARDARD | A | NO |  |  |  |  |  |  |  |  |  | POWER NO | 0.15
POWER | M | NO |  |  |  |  | Power plans without discount at 15% |  |  |  |  | STARDARD NO | 0.2
STARDARD | M | NO |  |  |  |  | Standard plans without discount at 20%
STARDARD | A | YES
POWER | M | NO
STARDARD | A | NO
STARDARD | A | YES
STARDARD | A | YES
Spreadsheet: 212940d1360286766-darts-scoreboard-cricket-game-cricket
Sheet: Sheet1

 |  | Player 2
 |  | rd 1 | rd 2 | rd 3 | rd 4 | rd 5
 | Dart 1 | t19 | b | 1 | 0 | 0
 | Dart 2 | d19 | t10 | d2 | 0 | 0
 | Dart 3 | 19 | db | t3 | 0 | 0
 | value
 | points
 |  | rd 1 | rd 2 | rd 3 | rd 4 | rd 5
Spreadsheet: 01f2d6c3-9d50-4014-958d-2810139ebd05
Sheet: Sheet1

Course # | Sect | Title | Instructor(s) | Response(s) | Course Rating | Instructor Rating
45-710 | F5 | Finance | Routledge, [NAME] | 27 | 4.22 | 4.22
45-791 | G5 | Interpersonal Managerial Communication | Hajduk, [NAME] | 12 | 2.83 | 2.33
45-791 | F5 | Interpersonal Managerial Communication | Young, [NAME] | 10 | 4.2 | 4.2
45-822 | E5 | Marketing Research | Corder, Lloyd | 15 | 4.87 | 4.87
45-868 | E5 | Sustainable Operations | Enders, [NAME] | 15 | 3.6 | 3.53
45-872 | E5 | Information Resources Management | Mukhopadhyay, Tridas | 16 | 3 | 3.12
45-911 | E5 | Optimization Methods in Finance | Pena, Javier | 5 | 4.2 | 4.4
45-915 | E5 | Valuation and Financial Information | O Brien, [NAME] | 7 | 4.43 | 4.29
45-941 | E5 | Introduction to Strategic Management | [NAME], Starling | 19 | 2.84 | 2.47
45-960 | M5 | Organizational Change | Beenen, [NAME] | 6 | 4.17 | 4.5
Spreadsheet: 830735d1685064976-organizing-text-from-random-cells-into-one-column-excel-forum-example-2
Sheet: Sheet1

Company Name | Discount Profile | Contract Profile
A PLUS GENERAL CONTRACTORS INC | CADP1A | YQQ01MLT | MSDAI07 | YGA05323 | YCA05323
ABSOLUTE AIRFLOW INC | AZSPEC | ZAL05MLT | VQQ02MLT | MSDAI09 | VGX90323 | VCX90323
ACTIVE AIR | CADP1A | YQQ01MLT | YGA05323 | YCA05323
ADRIAN J TORRES | CADP1A | [NAME] | MSDAI07 | YGA05323 | YCA05323
AIR CARE HEATING AND AIR COND | CADP1A | MSDAI09 | YGA05323 | YCA05323
ALL PHASE INC | CADP1A | MSDAI01 | YGA05323 | YCA05323
BASIC AIR INC | CADP1A | MSDAI05 | YGA03323 | [NAME]
BEST APPLIANCE & AIR INC | CADP1A | YQQ01MLT | MSDAI07 | YGA20323 | YCA20323
BREEZY AIR SERVICES | CADP1A | YQQ01MLT | MSDAI09 | YGA18323 | YCA18323
COMMAND AIR CORP | [NAME] | UQR01MLT | MSDAI05 | ZGL16MLT | ZCL15MLT | ZAL05MLT
COOL AIR REFRIGERATION | [NAME] | YQQ01MLT | MSDAI05 | YGA07323 | YCA07323
Spreadsheet: 730016d1619497188-pulling-data-from-another-sheet-based-on-certain-criteria-without-creating-blank-rows-media-fill-requalification
Sheet: Overview

GMF [NAME] in < 30 Days | Days Until
Spreadsheet: 85767d1285795621-lookup-help-excel-help
Sheet: Sheet1

 | 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
Invoice 1 | 1
Invoice 2 | 0 |  | 2
Invoice 3 |  | 3
Invoice 4 |  |  |  | 4
Invoice 5 |  | 0 |  |  | 4
Invoice 6 | 1
Invoice 7 |  | 3
Invoice 8 |  |  | 4
Invoice 9 |  | 0 | 0 | 5
Invoice 10 |  |  |  |  | 5
Invoice 1 | 1
Invoice 2 | 2
Invoice 3 | 3
Invoice 4 | 4
Invoice 5 | 4
Invoice 6 | 1
Invoice 7 | 3
Invoice 8 | 4
Invoice 9 | 5
Invoice 10 | 5
Spreadsheet: 49597d1248960575-thesaurus-hlp1
Sheet: Sheet1

Backyard |  |  | Swing
Pool |  |  | Swim
Park |  |  | Crawl
Park |  |  | Jump
Park |  |  | Jump
Park |  |  | Swing
Frontyard |  |  | Skip
Backyard |  |  | Run
Backyard |  |  | Dance
Backyard |  |  | Dance
Park |  |  | Walk
Frontyard |  |  | Crawl
Frontyard |  |  | Jump
Backyard |  |  | Crawl
Pool |  |  | Crawl
Backyard |  |  | Swing
Park |  |  | Dance
Park |  |  | Swing
Pool |  |  | Run
Park |  |  | Run
Backyard |  |  | Run
Backyard |  |  | Dance
Pool |  |  | Jump
Park |  |  | Skip
Park |  |  | Swim
Park |  |  | Swim
Park |  |  | Swing
Frontyard |  |  | Jump
Backyard |  |  | Swing
Backyard |  |  | Swim
Backyard |  |  | Crawl
Park |  |  | Jump
Frontyard |  |  | Jump
Frontyard |  |  | Swing
Backyard |  |  | Skip
Pool |  |  | Run
Backyard |  |  | Dance
Park |  |  | Dance
Park |  |  | Walk
Pool |  |  | Crawl
Park |  |  | Jump
Backyard |  |  | Crawl
Backyard |  |  | Crawl
Pool |  |  | Swing
Park |  |  | Dance
Park |  |  | Swing
Park |  |  | Run
Park |  |  | Run
Frontyard |  |  | Run
Backyard |  |  | Dance
Backyard |  |  | Jump
Backyard |  |  | Skip
Park |  |  | Swim
Frontyard |  |  | Swim
Frontyard |  |  | Swing
Backyard |  |  | Jump
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Assets

Assets
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Hilgurt |  | Gas |  | Assets
Grass |  | Gas |  | Assets
Meyer |  | Gas |  | Assets
Mrha |  | Gas |  | Assets
Bieniawski |  | Gas |  | Assets |  | 425000
Total
Spreadsheet: 159832d1338863789-dates-in-excel-counting-the-number-of-months-in-a-year-new-dates
Sheet: Sheet3

 |  |  |  |  |  |  |  | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 |  | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00
 |  |  |  |  |  |  |  | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 |  | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00
 | Title | Total Hours | N/A | Asia Price | Start Date | End Date | Term | # of Months in 2010 | # of Months in 2011 | 2011 Amort | # of Months in 2012 | # of Months in 2013 | # of Months in 2014 | # of Months in 2015 | # of Months in 2016
 | [NAME] | 2 |  |  | 2010-07-01 00:00:00 | 2012-12-31 00:00:00 | 30
 | YYY | 2 |  |  | 2010-11-01 00:00:00 | 2013-04-30 00:00:00 | 30
 | ZZZ | 2 |  |  | 2010-06-01 00:00:00 | 2012-11-30 00:00:00 | 30
 | Airline Disaster | 2 |  |  | 2010-07-01 00:00:00 | 2012-12-31 00:00:00 | 30
 | Artic Blast | 2 |  |  | 2010-11-01 00:00:00 | 2013-04-30 00:00:00 | 30
 | [NAME] (aka [NAME]) | 2 |  |  | 2011-02-01 00:00:00 | 2013-07-31 00:00:00 | 30
 | Stonehenge (aka Stonehenge Apocalypse) | 2 |  |  | 2010-09-01 00:00:00 | 2013-02-28 00:00:00 | 30
 | Sinbad and the Minotaur | 2 |  |  | 2011-02-15 00:00:00 | 2014-02-15 00:00:00 | 36
Spreadsheet: john_lavorato__16485__Balance of Energy
Sheet: Balance

Balance of Energy (Avg MW)
 | 1995
GENERATION
Hydroplant
Itaipu
Thermoplant
Total Gen
LOAD
SE-MW
S
NE
N
Total Load
[NAME]
from Paraguai to Brazil | 0 | 0 | 0 | 0
from Argentina to Brazil | 0 | 0 | 0 | 0
Total Trans
Balance
Spreadsheet: 79374d1279648340-excel-2007-max-function-in-pivot-analysis-example-worksheet-copy
Sheet: Sheet1

Survey Respondent | Item | Answer
[NAME] | www.cnn.com | media
[NAME] | www.bbc.com | news
[NAME] | www.bbc.com | entertainment
Klaus | www.bbc.com | entertainment
Klaus | www.bbc.com | media
Klaus | www.bbc.com | entertainment | Row Labels | Count of Survey Respondent
Klaus | www.slate.com | media | www.bbc.com | 12
[NAME] | www.slate.com | media | entertainment | 3 |  | Since I have 5,000 "items" (like bbc or cnn), I need
[NAME] | www.foxnews.com | news | media | 4 |  | a program to figure out which Answer is the most
[NAME] | www.foxnews.com | entertainment | news | 5 |  | prevalent for each "item"
[NAME] | www.slate.com | entertainment | www.cnn.com | 8
[NAME] | www.cnn.com | entertainment | entertainment | 2 |  | So for BBC, it's News
[NAME] | www.slate.com | entertainment | media | 3 |  | For CNN, it's Media
[NAME] | www.cnn.com | news | news | 2 |  | For Fox, it's entertainment, etc.
[NAME] | www.slate.com | news | news | 1
[NAME] | www.slate.com | news | www.foxnews.com | 14 |  | I just can't go down the list of 5,000 items by hand.
[NAME] | www.slate.com | entertainment | entertainment | 6
[NAME] | www.foxnews.com | entertainment | media | 4 |  | Any ideas?
[NAME] | www.bbc.com | media | news | 4
[NAME] | www.slate.com | media | www.slate.com | 15
[NAME] | www.cnn.com | news | entertainment | 5
[NAME] | www.foxnews.com | entertainment | media | 7
[NAME] | www.bbc.com | news | news | 3
[NAME] | www.slate.com | entertainment | Grand Total | 49
[NAME] | www.slate.com | news
[NAME] | www.foxnews.com | media
[NAME] | www.cnn.com | news
[NAME] | www.foxnews.com | entertainment
[NAME] | www.slate.com | media
[NAME] | www.foxnews.com | news
[NAME] | www.cnn.com | media
[NAME] | www.foxnews.com | news
[NAME] | www.slate.com | media
[NAME] | www.bbc.com | news
Branson | www.foxnews.com | news
[NAME] | www.foxnews.com | media
[NAME] | www.cnn.com | entertainment
[NAME] | www.bbc.com | media
[NAME] | www.slate.com | media
Branson | www.bbc.com | news
Ina | www.foxnews.com | entertainment
Danielle | www.foxnews.com | entertainment
Branson | www.slate.com | entertainment
[NAME] | www.foxnews.com | media
[NAME] | www.foxnews.com | media
Danielle | www.slate.com | media
Danielle | www.bbc.com | news
Danielle | www.cnn.com | media
[NAME] | www.bbc.com | media
Spreadsheet: 216209d1361641773-returning-a-value-from-a-cell-in-onecolumn-having-checked-for-conditions-in-another-column-for-olives-2
Sheet: Sheet1

45 |  | 32.3 | 101 | 1
 |  | 42.6 | 115 | 2 |  |  | OPTION 2  FORMULA
 |  | 54.3 | 156 | 3
 |  | 64.1 | 124 | 4
 |  | 22.3 | 111 |  |  | QUE STION 1 | I used the formula in H3 to find the highest value in Column C from those whose corresponding value in Column B
 |  |  |  |  |  |  | were lower than the value in A1
 |  |  |  |  |  |  | I copied the formula to H4 and I got the 2nd highest value. Is this by design?
 |  |  |  |  |  | QUE STION 2 | How can I change the conditions in H3 to compare A1 and the values in Column C
 |  |  |  | I would like to add these reference numbers above. |  |  | and choose the values  in Column C that are LESSER THAN A1 and then go to the corresponding values in Column D
 |  |  |  | and put them in Column B (as below!) |  |  | and return the highest value in D?
 |  |  |  | BUT! They ruin the formula in H3 :( !
 |  |  |  |  |  |  | I'd like to use the formula currently in H3 AND have the one I'm describing above.
 |  |  |  |  |  | QUE STION 3 | Is there a way to ALSO return the value in Column D? Which I would like to move to Column B…
 |  | for display purposes I put these numbers here.
 |  |  |  |  |  | DESIRED OUTPUT (EVERYTHING BELOW) |  |  |  |  |  |  | This formula yields
 | REFERENCE |  |  |  |  |  |  |  |  |  |  |  | values in Column D
 | NO. |  |  |  | OPTION 2  FORMULA |  |  |  | OPTION 3  FORMULA |  |  |  | corresponding to
45 | 1 | 32.3 | 101 |  |  |  |  |  |  |  |  |  | values in Column C
 | 2 | 42.6 | 115 |  | 3 | 156 |  |  | 2 | 115 |  |  | that are LESSER THAN A21
 | 3 | 54.3 | 156 |  | 4 | 124 |  |  | 5 | 111
 | 4 | 64.1 | 124 |  |  |  |  |  | 1 | 101
 | 5 | 22.3 | 111 |  |  |  |  | HIGHEST VALUES first |  |  |  | HIGHEST VALUES first
 |  |  |  |  |  |  | This formula yields
 |  |  |  |  |  |  | values in Column D
 |  |  |  |  |  |  | corresponding to
 |  |  |  |  |  |  | values in Column C
 |  |  |  |  |  |  | that are GREATER THAN A21
Spreadsheet: 456935d1461136457-new-variable-based-on-multiple-date-ranges-nested-ifs-book1-1-
Sheet: Sheet1

2014-01-01 00:00:00 |  | Date | [NAME] |  | 1A |  | 2011-01-01 00:00:00 | 1A
2014-01-02 00:00:00 |  | 2011-06-03 00:00:00 |  |  | 1A |  | 2011-02-03 00:00:00 | 1B
2014-01-03 00:00:00 |  |  |  |  | 1A |  | 2011-03-03 00:00:00 | 1C
2014-01-04 00:00:00 |  |  |  |  | 1A |  | 2011-04-03 00:00:00 | 1D
2014-01-05 00:00:00 |  |  |  |  | 1B |  | 2011-05-03 00:00:00 | 1E
2014-01-06 00:00:00 |  |  |  |  | 1B |  | 2011-06-03 00:00:00 | Other
2014-01-07 00:00:00 |  |  |  |  | 1B
2014-01-08 00:00:00 |  |  |  |  | 1B
2014-01-09 00:00:00 |  |  |  |  | 1C
2014-01-10 00:00:00 |  |  |  |  | 1C
2014-01-11 00:00:00 |  |  |  |  | 1C
2014-01-12 00:00:00 |  |  |  |  | 1C
2014-01-13 00:00:00 |  |  |  |  | Other
2014-01-14 00:00:00 |  |  |  |  | 1D
2014-01-15 00:00:00 |  |  |  |  | 1D
2014-01-16 00:00:00 |  |  |  |  | 1D
2014-01-17 00:00:00 |  |  |  |  | 1D
2014-01-18 00:00:00 |  |  |  |  | 1E
2014-01-19 00:00:00 |  |  |  |  | 1E
2014-01-20 00:00:00 |  |  |  |  | 1E
2014-01-21 00:00:00 |  |  |  |  | 1E
2014-01-22 00:00:00 |  |  |  |  | Other
2014-01-23 00:00:00 |  |  |  |  | Other
2014-01-24 00:00:00 |  |  |  |  | Other
2014-01-25 00:00:00 |  |  |  |  | Other
2014-01-26 00:00:00 |  |  |  |  | Other
2014-01-27 00:00:00 |  |  |  |  | Other
2014-01-28 00:00:00 |  |  |  |  | Other
2014-01-29 00:00:00 |  |  |  |  | Other
2014-01-30 00:00:00 |  |  |  |  | Other
2014-01-31 00:00:00 |  |  |  |  | Other
2014-02-01 00:00:00 |  |  |  |  | Other
2014-02-02 00:00:00 |  |  |  |  | Other
2014-02-03 00:00:00 |  |  |  |  | Other
2014-02-04 00:00:00 |  |  |  |  | Other
2014-02-05 00:00:00 |  |  |  |  | Other
2014-02-06 00:00:00 |  |  |  |  | Other
2014-02-07 00:00:00 |  |  |  |  | Other
2014-02-08 00:00:00 |  |  |  |  | Other
2014-02-09 00:00:00 |  |  |  |  | Other
Spreadsheet: 194523d1353225924-multiple-vlookup-value-multiple-vlookup-value
Sheet: Sheet1

Component code | component type | description | active | expire date | component stock quantity | SAP | component usage/ FG | FCC | FCC Date
T090002s | blank sticker | description | active | - | 4000 | xx | 1 | 800 | 2012-12-01 00:00:00
 |  |  |  |  |  | xx1 | 2 | 900 | 2012-12-01 00:00:00
 |  |  |  |  |  | xx2 | 1 | 1000 | 2012-12-01 00:00:00
 |  |  |  |  |  | xx3 | 1 | 200 | 2012-12-15 00:00:00
 |  |  |  |  |  | xx4 | 3 | 400 | 2012-12-15 00:00:00
 |  |  |  |  |  | xx5 | 1 | 500 | 2012-12-30 00:00:00
B020001A | Window box | SAP code , description | inactive | 2012-11-01 00:00:00 | 500 | xx | 1 | 800 | 2012-12-01 00:00:00
B020002B | Window box | SAP code , description | active | - | 900 | xx9 | 2 | 800 | 2012-12-10 00:00:00
V020001A | pop up sleeve | SAP code , description | active | - | 400 | xx6 | 1 | 800 | 2012-12-14 00:00:00
L010001A | Belt | SAP code , description | active | - | 1000 | xx2 | 2 | 800 | 2012-12-01 00:00:00
S070001S | Blank sticker | description | active | - | 3000 | xx | 1 | 800 | 2012-12-01 00:00:00
 |  |  |  |  |  | xx2 | 1 | 800 | 2012-12-02 00:00:00
 |  |  |  |  |  | xx4 | 1 | 800 | 2012-12-03 00:00:00
SEARCH
v020001a
Spreadsheet: 267934d1380297394-sumif-not-working-here-excel_samplesumifs-ans2
Sheet: Sheet1

 |  |  | Hours |  |  |  |  |  | 2013-09-11 00:00:00 | 2013-10-11 00:00:00 | 2013-11-11 00:00:00 |  |  | 2013-09-11 00:00:00 | 2013-10-11 00:00:00 | 2013-11-11 00:00:00
Project | Start Date | End Date | BD | Finance | HR |  |  | BD |  |  |  |  | BD | 16 | 19 | 3
1 | 2013-08-31 00:00:00 | 2013-10-12 00:00:00 | 8 | 4 | 3 |  |  | Finance |  |  |  |  | Finance | 10 | 12 | 2
2 | 2013-09-21 00:00:00 | 2013-10-14 00:00:00 | 8 | 6 | 2 |  |  | HR |  |  |  |  | HR | 5 | 12 | 7
3 | 2013-10-12 00:00:00 | 2014-01-04 00:00:00 | 3 | 2 | 7
 |  |  |  |  |  |  |  |  | [NAME] are here
 |  | Sum if not working here |  |  |  |  |  |  | bibyui
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-09-01 00:00:00 | 2013-10-01 00:00:00
 |  |  | Hours |  |  |  |  |  |  |  |  |  | BD
Project | Start Date | End Date | Supply Chain | Eng | Finance | BD | Production | IT | HR | Aftermarket | Returns this |  | IT
1 | 2013-08-31 00:00:00 | 2013-10-12 00:00:00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | Finance
2 | 2013-09-21 00:00:00 | 2013-10-14 00:00:00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | HR
3 | 2013-10-12 00:00:00 | 2014-01-04 00:00:00 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  | Production
 |  |  |  |  |  |  |  |  |  |  |  |  | Supply Chain
 |  |  |  |  |  |  |  |  |  |  |  |  | Aftermarket
 |  |  |  |  |  |  |  |  |  |  |  |  | Eng
 |  |  |  |  |  |  |  | 2013-09-11 00:00:00 | 2013-10-11 00:00:00
 |  |  |  |  |  |  | BD | 8 | 12
 |  |  |  |  |  |  | IT | 12 | 18 |  | Needs to return this - Error with Match function
 |  |  |  |  |  |  | Finance | 6 | 9
 |  |  |  |  |  |  | HR | 14 | 21
 |  |  |  |  |  |  | Production | 10 | 15
 |  |  |  |  |  |  | Supply Chain | 2 | 3
 |  |  |  |  |  |  | Aftermarket | 16 | 24
 |  |  |  |  |  |  | Eng | 4 | 6
Spreadsheet: 786723d1657393111-function-to-highlight-numbers-in-sequence-copy-corresponding-numbers-test1
Sheet: Sheet1

TABLE A |  |  |  |  |  |  |  | TABLE B |  |  |  |  |  |  |  | Table C
1 | 3 | 5 | 7 | 8 | 10 | 16 |  | 2 | 1 | 1 | 3 | 2 | 5 | 1 |  | 3,2
12 | 15 | 16 | 20 | 26 | 30 | 40 |  | 3 | 4 | 1 | 5 | 1 | 1 | 2 |  | 4,1
1 | 3 | 5 | 7 | 9 | 14 | 21 |  | 1 | 2 | 1 | 1 | 2 | 4 | 2
11 | 14 | 17 | 21 | 24 | 25 | 30 |  | 1 | 4 | 3 | 2 | 1 | 1 | 1 |  | 1,1
1 | 2 | 3 | 11 | 17 | 21 | 31 |  | 1 | 2 | 1 | 2 | 2 | 1 | 1 |  | 1,2,1,
5 | 23 | 24 | 27 | 30 | 34 | 35 |  | 3 | 3 | 4 | 1 | 2 | 2 | 1 |  | 3,4,2,1,
Table A |  |  |  |  |  |  |  | Table B
Consecutive numbers are highlighted |  |  |  |  |  |  |  | one to one Corresponding numbers to table A are highlighted
Function to highlight consecutive number in Table A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Function  to [NAME]  up yellow highlighted in table B
Spreadsheet: 0fca549f-b7ae-4bc6-8136-891762ff931f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Risk Parity II MV Fund
 | [NAME]
 | Inception Date | 2012-11-05 00:00:00
 |  |  |  | 60/40
 |  |  |  | Blended
 |  | Class I | Class N | S&P / Barc
 | Date | QRMIX | QRMNX | Custom Index
** | 2012-11-30 00:00:00 | 0.01500000000000012 | 0.01500000000000012 | 0.001828994995952371
 | 2012-12-31 00:00:00 | 0.0026150309460653 | 0.001970443349753603 | 0.004914398215677274
 | 2013-01-31 00:00:00 | 0.02066929133858264 | 0.01966568338249752 | 0.02827941685265651
 | 2013-02-28 00:00:00 | -0.0009643201542912649 | -0.0009643201542911539 | 0.01014975740510864
 | 2013-03-31 00:00:00 | 0.0212355212355213 | 0.0212355212355213 | 0.02282147985681564
 | 2013-04-30 00:00:00 | 0 | 0 | 0.01560733007385746
 | 2013-05-31 00:00:00 | -0.035 | -0.0359 | 0.0069
 | 2013-06-30 00:00:00 | -0.06758080313418224 | -0.0676470588235294 | -0.01424466825939661
 | 2013-07-31 00:00:00 | 0.02100840336134469 | 0.02208201892744488 | 0.03107744658451166
 | 2013-08-31 00:00:00 | -0.005144032921810759 | -0.006172839506172867 | -0.01942164826431785
 | 2013-09-30 00:00:00 | 0.0237849018 | 0.0227743271 | 0.0226
 | 2013-10-31 00:00:00 | 0.0242424242 | 0.024291498 | 0.03081525070913016
 | 2013-11-30 00:00:00 | -0.0009861932938856066 | -0.0009881422924901129 | 0.01674754374759413
 | 2013-12-31 00:00:00 | -0.010305906 | -0.010326287 | 0.01292918979277449
 | 2014-01-31 00:00:00 | 0.0009990009990010762 | 0 | -0.01483426358353035
 | * annualized for periods 1 year or greater
 | ** partial month return, inception date 11/5/2012
 | Risk Parity II MV Fund
 | [NAME]
 |  |  |  | 60/40
 |  |  |  | Blended
 | Month-end Returns as of | Class I | Class N | S&P / Barc
 | January 31, 2014 | QRMIX | QRMNX | Custom Index
 | 1 Year | -0.03224525035944592 | -0.03513970679933209 | 0.1264835551145882
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.005195679643573925 | 0.0005601240490928916 | 0.1663044848751418
 | Since Inception Annualized Return | 0.004193532656163068 | 0.0004522881849493565 | 0.1322755365917492
* | Since Inception Annualized Monthly Volatility | 0.08597865057690354 | 0.08622585364884103 | 0.05681850147220999
 | Since Inception [NAME] | 0.03794728508106448 | -0.005550401493684214
 |  |  |  | 60/40
 |  |  |  | Blended
 | Quarter-end Returns as of | Class I | Class N | S&P / Barc
 | December 31, 2013 | QRMIX | QRMNX | Custom Index
 | 1 Year | -0.01322823147736829 | -0.01616506976490406 | 0.1757879620356184
 | 3 Years
 | 5 Years
 | 10 Years
 | Since Inception Cumulative Return | 0.004192490342532329 | 0.0005601240490928916 | 0.1838725652564748
 | Since Inception Annualized Return | 0.003633807502768205 | 0.0004856001504724983 | 0.1575884326732437