tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 13400c62-8e9e-4a45-9952-3522df500b34
Sheet: Sheet1

Verizon Communications Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Condensed Consolidated Statements of Income
 |  |  |  |  | (dollars in millions, except per share amounts)
 |  |  | [NAME]. Ended | [NAME]. Ended
Unaudited |  |  | 2013-03-31 00:00:00 | 2012-03-31 00:00:00 | % Change
Operating Revenues |  |  | 29420 | 28242 | 4.2
Operating Expenses
Cost of services and sales |  |  | 10932 | 11319 | -3.4
Selling, general and administrative expense |  |  | 8148 | 7700 | 5.8
Depreciation and amortization expense |  |  | 4118 | 4028 | 2.2
Total Operating Expenses |  |  | 23198 | 23047 | 0.7
Operating Income |  |  | 6222 | 5195 | 19.8
Equity in earnings of unconsolidated businesses |  |  | -5 | 103 | *
Other income and (expense), net |  |  | 39 | 19 | *
Interest expense |  |  | -537 | -685 | -21.6
Income Before Provision for Income Taxes |  |  | 5719 | 4632 | 23.5
Provision for income taxes |  |  | -864 | -726 | 19
Net Income |  |  | 4855 | 3906 | 24.3
Net income attributable to noncontrolling interest |  |  | 2903 | 2220 | 30.8
Net income attributable to Verizon |  |  | 1952 | 1686 | 15.8
Net Income |  |  | 4855 | 3906 | 24.3
Basic Earnings per Common Share
Net income attributable to Verizon |  |  | 0.68 | 0.59 | 15.3
Weighted average number of common shares (in millions) |  |  | 2866 | 2842
Diluted Earnings per Common Share (1)
Net income attributable to Verizon |  |  | 0.68 | 0.59 | 15.3
Weighted average number of common
 | shares-assuming dilution (in millions) |  | 2872 | 2849
Footnotes:
(1) | Diluted Earnings per Common Share includes the dilutive effect of shares issuable under our stock-based compensation plans, which represents the only potential dilution.
 | Certain reclassifications have been made, where appropriate, to reflect comparable operating results.
* | Not meaningful
Spreadsheet: fc6a28f1-1d68-47bf-b2b2-8903a1ae4cb9
Sheet: Sheet1

February 2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | [NAME] | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 |  | Mon | 31 | Tue | 1 | Wed | 2 | Thu | 3 | Fri | 4 | Sat | 5 | Sun | 6
 | Cassandra
 | [NAME]
 | Brian
 | Emma
 | All
 |  | Mon | 7 | Tue | 8 | Wed | 9 | Thu | 10 | Fri | 11 | Sat | 12 | Sun | 13
 | Cassandra
 | [NAME]
 | Brian
 | Emma
 | All
 |  | Mon | 14 | Tue | 15 | Wed | 16 | Thu | 17 | Fri | 18 | Sat | 19 | Sun | 20
 | Cassandra
 | [NAME]
 | Brian
 | Emma
 | All
 |  | Mon | 21 | Tue | 22 | Wed | 23 | Thu | 24 | Fri | 25 | Sat | 26 | Sun | 27
 | Cassandra
 | [NAME]
 | Brian
 | Emma
 | All
 |  | Mon | 28 | Tue | 1 | Wed | 2 | Thu | 3 | Fri | 4 | Sat | 5 | Sun | 6
 | Cassandra
 | [NAME]
 | Brian
 | Emma
 | All
Spreadsheet: 27a26177-12c6-495f-a33d-1355fcfba422
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: July 22, 2014 (4:07 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 237399
2004 | 223675 | 233241 | 232983 | 246201
2005 | 236033 | 244136 | 244711 | 255856
2006 | 245182 | 254735 | 255745 | 271401
2007 | 257973 | 265739 | 267325 | 281304
2008 | 270223 | 277650 | 277603 | 282873
2009 | 261921 | 266862 | 265511 | 280665
2010 | 267597 | 274785 | 276049 | 291794
2011 | 277416 | 289110 | 288779 | 305253
2012 | 291952 | 300081 | 298950 | 322308
2013 | 306040 | 313234 | 314646 | 340055
2014 | 323715 | X | X | X
Spreadsheet: tracy_geaccone__40277__Non recurring Q3 2001-asset sales
Sheet: Brazil

Azurix Brazil
Pro Forma Loss Calculation
(In millions of US$)
Cash Consideration Received |  |  |  |  |  | 20 |  | 141.5
Less Transaction Costs (estimated) |  |  |  |  |  | -0.7 |  | -3
Outcome of Consideration placed in Escrow |  |  |  |  |  | 0 |  | -10
Net Consideration Received
Cost Basis:
 | Azurix's Equity Investment at 7/31/01 |  |  | 64.5
 | Loans to [NAME] to be contributed at closing |  |  | 22.1
 | Additional funds to be invested or loaned to Azurix
 | Brazil 8/1/01 - closing date |  |  | 0
 | Intercompany net receivables from Azurix Brazil to be
 | contributed at closing |  |  | 0.1 |  | (a)
 | Equity earnings/(loss) from 8/1/01 - closing date |  |  | 0
Total Cost Basis
Working Capital Adjustment |  |  |  |  |  | 0 |  | 0
Debt Adjustment |  |  |  |  |  | 0
Pre-Tax Loss
Tax Loss on 338H-10 Election (estimated) |  |  |  |  |  | 0 |  | 28.2
Pro Forma Azurix Loss on Sale
(a) - Assumes that $3.0mm N/R from Lurgi CFA is transferred to another Azurix entity not being
sold prior to closing.
Spreadsheet: 768374d1644938996-trying-to-look-up-and-filter-data-example
Sheet: K ABV

ABV
Component name | Result text
Spreadsheet: 819281d1677381145-need-a-formula-that-returns-value-based-on-todays-date-sample10
Sheet: Sheet1

Date | Value |  | Current Date
2023-01-01 00:00:00 | 1000 |  | Current Value | [NAME] here
2023-02-01 00:00:00 | 3000
2023-03-01 00:00:00 | 4000
2023-04-01 00:00:00 | 6000
2023-05-01 00:00:00 | 8000
2023-06-01 00:00:00 | 10000
2023-07-01 00:00:00 | 5000
2023-08-01 00:00:00 | 6000
2023-09-01 00:00:00 | 4000
2023-10-01 00:00:00 | 5000
2023-11-01 00:00:00 | 3000
2023-12-01 00:00:00 | 2000
Spreadsheet: 274396d1383104838-extract-certain-data-from-a-column-dependent-on-another-column-to-another-sheet-drafting-report-beta
Sheet: Working Drawings Report

 |  |  | To
Working Drawings Into Drafting |  | This Week
Working Drawings Out of Drafting |  | This Week
Working Drawings Pending |  | Total
Working Drawings Unallocated |  | Needs Planning
 |  | Needs to be allocated
Working Drawings in Progress
Working Drawings in for Checking / Corrections |  | Needs checking
 |  | Needs Corrections
Working Drawings Finalised, Pending Eng/6*/EW
Spreadsheet: 727703d1618044699-sum-and-subtract-sum-and-subtract
Sheet: Sheet1

Settle Date | HAWB | Pieces | Weight | [NAME] | Agent Name | Total
2021-02-21 00:00:00 | 526749643 | 2 | 960 | TAYLORED SERVICES | TOWERS TRUCKING LLC | 28.75
2021-02-21 00:00:00 | 526749650 | 1 | 712 | TAYLOREDSERVICES | TOWERS TRUCKING LLC | 28.75
2021-02-21 00:00:00 | 526749668 | 3 | 5340 | ESSENTIAL INGREDIENTS | TOWERS TRUCKING LLC | 67.01
2021-02-21 00:00:00 | 526749676 | 1 | 225 | UNITEDLEGWEAR | TOWERS TRUCKING LLC | 28.75
 |  |  |  |  | SUBTOTAL
2021-02-22 00:00:00 | 526749684 | 1 | 150 | UNITEDLEGWEAR | TOWERS TRUCKING LLC | 28.75
2021-02-22 00:00:00 | 526749692 | 1 | 718 | OFFICEMATENJWAREHOUSE | TOWERS TRUCKING LLC | 28.75
2021-02-22 00:00:00 | 526749700 | 1 | 335 | OFFICEMATENJWAREHOUSE | TOWERS TRUCKING LLC | 28.75
2021-02-22 00:00:00 | 526749718 | 1 | 298 | OFFICEMATE NJ WAREHOUSE | TOWERS TRUCKING LLC | 28.75
2021-02-22 00:00:00 | 526749726 | 1 | 242 | OFFICEMATE NJ WAREHOUSE | TOWERS TRUCKING LLC | 28.75
2021-02-22 00:00:00 | 526749734 | 1 | 148 | SELECTIVE 1 | TOWERS TRUCKING LLC | 28.75
2021-02-22 00:00:00 | 526749742 | 2 | 2000 | DANKSTOP | TOWERS TRUCKING LLC | 36.2
2021-02-22 00:00:00 | 526847116 | 1 | 1 | MIGHTYMAXBATTERY | TOWERS TRUCKING LLC | 20
2021-02-22 00:00:00 | 526847199 | 1 | 1 | WAYFAIR LINDEN | TOWERS TRUCKING LLC | 20
 |  |  |  |  | SUBTOTAL
2021-02-23 00:00:00 | 2370212 | 3 | 2585 | AIRWAYS FREIGHT CORP | TOWERS TRUCKING LLC | 75
2021-02-23 00:00:00 | 526749056 | 2 | 3024 | HALL'S WAREHOUSE | TOWERS TRUCKING LLC | 48.78
2021-02-23 00:00:00 | 526749759 | 1 | 511 | CA GLOBAL | TOWERS TRUCKING LLC | 28.75
2021-02-23 00:00:00 | 526749767 | 2 | 1597 | HILLSIDE WAREHOUSE | TOWERS TRUCKING LLC | 28.75
2021-02-23 00:00:00 | 526749775 | 3 | 4040 | IPS INDUSTRIES INC | TOWERS TRUCKING LLC | 34.27
 |  |  |  |  | SUBTOTAL
 |  |  |  |  | TOTAL SUM EVERYTING (G2-G22)- (F2-F22)=SUBTOTAL
Spreadsheet: 171749d1343844436-copy-paste-cells-to-from-every-other-row-copy-and-pasteexample
Sheet: Sheet2

DistrictCode | Date | EndDate | SchoolCode | Type | Label | <------ These need to look like these ----> | DistrictCode | Date | EndDate | SchoolCode | Type | Label
0670 | 2012-12-24 00:00:00 | 2012-12-25 00:00:00 | 0529 | Holiday | Christmas |  | 0670 | 2012-12-24 00:00:00 | 2012-12-25 00:00:00 | 0529 | Holiday | Christmas
0670 | 2012-12-24 00:00:00 | 2012-12-25 00:00:00 | 0529 | Holiday | Christmas |  | 0670 | 2012-12-25 00:00:00 | 2012-12-25 00:00:00 | 0529 | Holiday | Christmas
0665 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 0534 | Holiday | Thanksgiving |  | 0665 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 0534 | Holiday | Thanksgiving
0665 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 0534 | Holiday | Thanksgiving |  | 0665 | 2012-11-23 00:00:00 | 2012-11-23 00:00:00 | 0534 | Holiday | Thanksgiving
0755 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 0609 | Holiday | Thanksgiving |  | 0755 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 0609 | Holiday | Thanksgiving
0755 | 2012-11-22 00:00:00 | 2012-11-23 00:00:00 | 0609 | Holiday | Thanksgiving |  | 0755 | 2012-11-23 00:00:00 | 2012-11-23 00:00:00 | 0609 | Holiday | Thanksgiving
0755 | 2013-02-15 00:00:00 | 2013-02-18 00:00:00 | 0609 | Holiday | Semester Break |  | 0755 | 2013-02-15 00:00:00 | 2013-02-18 00:00:00 | 0609 | Holiday | Semester Break
0755 | 2013-02-15 00:00:00 | 2013-02-18 00:00:00 | 0609 | Holiday | Semester Break |  | 0755 | 2013-02-18 00:00:00 | 2013-02-18 00:00:00 | 0609 | Holiday | Semester Break
0815 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 0673 | Holiday | Fall Break |  | 0815 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 0673 | Holiday | Fall Break
0815 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 0673 | Holiday | Fall Break |  | 0815 | 2012-10-26 00:00:00 | 2012-10-26 00:00:00 | 0673 | Holiday | Fall Break
Spreadsheet: 820665d1678227690-counting-available-beds-in-a-facility-sample_mg
Sheet: Tabelle1

 |  |  |  |  |  |  |  |  | I want to count all empty cells in column D, but only if columns E and F are also empty  and only if column C of the same room number is also empty or contains the value "f".
 | Room | Sex | Name | Infos | Planning |  | Available Beds
 | 1
 | 2 |  |  |  |  |  | Female
 | 2 | f | Mrs. [NAME]
 | 3
 | 3 |  |  |  |  |  | Male
 | 4
 | 4 | m | Mr. [NAME]
 | 5 |  |  |  |  |  | Unisex
 | 6
 | 7
 | 7
Spreadsheet: 92135d1291798750-separating-text-and-numbers-from-a-mixed-code-split_exchelp
Sheet: Sheet1

Original data ( To be separated as per Col B to I) | Desired outcome |  |  |  |  |  |  |  | Solution using text to column function
 | 1 | 2 | 3 | 4 ( To be split further) | 4a | 4b | 4c | 4d
BEACON PURCHASING - 78800192.E360 - EURO 360 L | BEACON PURCHASING | 78800192 | E360 | EURO 360 L | EURO | 360 | L |  | BEACON PURCHASING | 78800192.E360 | EURO 360 L | 78800192 | E360
BEACON PURCHASING - 78800192.E660 - EURO 660 L | BEACON PURCHASING | 78800192 | E660 | EURO 660 L | EURO | 660 | L
Belfast Health & Social Care Trust - 44003000.R30C - RORO 30CY Compactor | Belfast Health & Social Care Trust | 44003000 | R30C | RORO 30CY Compactor | RORO | 30 | CY | Compactor | Belfast Health & Social Care Trust | 44003000.R30C | RORO 30CY Compactor |  | RORO | 30CY | Compactor
BUPA CARE HOMES (CFH CARE) LTD - 34002873.E360 - EURO 360 L | BUPA CARE HOMES (CFH CARE) LTD | 34002873 | E360 | EURO 360 L | Euro | 360 | L |  | BUPA CARE HOMES (CFH CARE) LTD | 34002873.E360 | EURO 360 L
Spreadsheet: jeff_dasovich__14234__Vons Model
Sheet: Safeway

Consolidated Balance Sheet
ASSETS
Current assets:
Cash and cash equivalents | 79.7 |  | 74.8 |  | 60.7
Accounts receivable | 160.9 |  | 152.7 |  | 147.9
Inventories | 1283.3 |  | 1191.8 |  | 1136
Deferred income taxes | 0 |  | 0 |  | 0
Other | 130.5 |  | 95.5 |  | 93
Total current assets
Net property plant and equipment | 2756.4 |  | 2592.9 |  | 2506.4
Goodwill | 312.5 |  | 323.8 |  | 331.1
Investment in unconsolidated affiliates | 362.4 |  | 336 |  | 329.3
Other assets |  |  |  |  | 417.7
TOTAL ASSETS
LIABILITIES AND EQUITY
Current liabilities:
Accounts payable | 1153.1 |  | 1040 |  | 1012.1
Accrued liabilities
Current maturities,  long term debt |  |  |  |  | 171.8
Total current liabilities
Accrued self-insurance | 0 |  | 0 |  | 0
Deferred income taxes | 223.8 |  | 108.5 |  | 128.3
Other noncurrent liabilities | 376.1 |  | 401.5 |  | 402.1
Capital lease obligations | 160.4 |  | 166.2
Long term debt | 1568.1 |  | 1783.6
Stockholders' equity | 1186.8 |  | 795.5 |  | 643.8
TOTAL LIABILITIES AND EQUITY
Consolidated Statement of Income
Sales | 17269 |  | 16397.5 |  | 15626.6
Expenses:
Cost of sales, buying, occupancy | 12494.8 |  | 11905.1 |  | 11339.3
Selling and administrative | 3882.5 |  | 3765 |  | 3675.2
Depreciation and amortization | 0 |  | 0 |  | 0
Goodwill amortization | 0 |  | 0 |  | 0
Restructuring charges | 0 |  | 0 |  | 0
Total operating expenses
Operating income (EB IT)
Memo: EBIT without restructuring
Interest expense | 178.5 |  | 199.8 |  | 221.7
Equity earnings of unconsolidated affiliate | 50 |  | 26.9 |  | 27.3
Other income, net | 4.4 |  | 2 |  | 6.4
Income before income taxes
Provision for income taxes | 307 |  | 228.2 |  | 173.9
Net income, before extr. items
Net profit margin (x)
Asset turnover (=)
Return on assets (x)
Financial leverage (=)
Return on equity
Growth:
Sales
EBIT (w/o restructuring)
Net income
Spreadsheet: 887801d1738124426-fixed-asset-depreciation-fixed-asset-depreciation-v3
Sheet: v3

 | Summary |  | 1 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000 |  | 300000 |  |  |  |  |  |  |  |  |  |  |  |  | Input cells
 | Initial Depreciation | 0.2 |  | 0 | -60000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME] required
 | Annual Depreciation | 0.14 |  | -70000 | -112000 | -112000 | -112000 | -112000 | -42000.00000000001 | -42000.00000000001 | 0 | 0 | 0 | 0
 | Net Book Value c/f
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000
 | Initial Depreciation
 | Annual Depreciation
 | Net Book Value c/f
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remove this section
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Net Book Value b/f |  | 0
 | Addition |  |  |  | 300000
 | Initial Depreciation
 | Annual Depreciation
 | Net Book Value c/f
 | Further to my post in:
 | https://www.excelforum.com/excel-formulas-and-functions/1432561-fixed-asset-depreciation.html#post6008830
 | I need a formula for Initial Depreciation and Annual Depreciation for the purchase of new assets without having to break down the 2 purchases and then add them up.
Spreadsheet: 883807d1732537129-pivot-table-doesnt-recognise-dates-generated-by-a-formula-formula_test-version-4
Sheet: List values

 | Survey type |  | Area |  | AMOs
 | HCS |  | Area 1 |  | [NAME]
 | EPC |  | Area 2 |  | Lauren
 | HHSRS |  | Area 3 |  | [NAME]
 | VOID |  | Area 4 |  | [NAME]
 | VOID HCS |  | Area 5 |  | Darren & Lauren
 | VOID EPC |  | Area 6 |  | Darren & Sam
 | HCS & EPC |  | Area 7 |  | Darren & Steve
 | VOID HCS & EPC |  | Area 8 |  | Lauren & Sam
 |  |  | Area 9 |  | Lauren & Steve
 |  |  | Area 10 |  | [NAME]
 |  |  | Area 11 |  | Not recorded
 |  |  | Area 12
 |  |  | Area 13
 |  |  | Area 14
 |  |  | Area 15
 |  |  | Area 16
 |  |  | Area 17
 |  |  | Area 18
 |  |  | Area 19
 |  |  | Area 20
 |  |  | Area 21
 |  |  | Area 22
 |  |  | Area 23
 |  |  | Area 24
Spreadsheet: 724413d1616152873-counting-the-number-of-cell-that-fit-the-condition-e-g-odd-toto
Sheet: formula

Date | Number |  |  |  |  |  |  |  | Odd | Even | 1 to 10 | 11 to 20 | 21 to 30 | 31 to 40 | 40 to 49
44263 | 8 | 13 | 17 | 27 | 33 | 40 | 38 |  | 4 | 3 | 1 | 2 | 1 | 3 | 0
44232 | 8 | 9 | 11 | 24 | 26 | 47 | 34 |  | 3 | 4 | 2 | 1 | 2 | 1 | 1
Spreadsheet: 797950d1664226946-sum-up-until-new-cell-with-data-appears-then-repeat-2022-09-26-oeldere1-rafael1024-summation-test-file-1-
Sheet: Tabel1

Produce | Quantity
Apple | 1 |  |  |  | Rijlabels | Som van Quantity
Apple | 2 |  |  |  | Apple | 9
Apple | 2 |  |  |  | [NAME] | 15
Apple | 4 |  |  |  | Corn | 15
[NAME] | 3 |  |  |  | Pear | 32
[NAME] | 5 |  |  |  | Eindtotaal | 71
[NAME] | 7
Corn | 5
Corn | 5
Corn | 5
Pear | 6
Pear | 8
Pear | 9
Pear | 9
Spreadsheet: 777040d1650093320-how-to-vlookup-table-array-with-wildcard-condition-lookup
Sheet: Sheet1

Sample Lookup Value | Expected Lookup Value |  |  | Table Array for lookup
F1-0911_Singapore_HongKong_Bond | 911111.1001 |  |  | F1-0911_*HongKong* | [PHONE]
F1-0911_HongKong_Thailand_SubBond | 911111.1002 |  |  | F1-0911_*Thailand* | [PHONE]
F1-0911_HongKong_Singapore_SubBond | 911111.1003 |  |  | F1-0911_* | [PHONE] | (Not HongKong or Thailand)
F1-0911_Singapore_Cambodia_SubBond | 911111.1003 |  |  | F1-0921_*HongKong* | [PHONE]
F1-0921_Singapore_HongKong_Bond | 921111.1001 |  |  | F1-0921_*Thailand* | [PHONE]
F1-0921_HongKong_Thailand_SubBond | 921111.1002 |  |  | F1-0921_* | [PHONE] | (Not HongKong or Thailand)
F1-0921_Cambodia_Singapore_SubBond | 921111.1003
Spreadsheet: 154871d1336585028-permanent-link-between-sheets-linktest
Sheet: Sheet2

 | NAME | PTS | PRO/ST | PLC | TEAM | MASTER | MPLC
1 | MASON SIMS |  | GA | 3 | NC | 1818 | 3
2 | HUNTER HOFFLER |  | GA | 2 | NC | 1321 | 2
3 | HUNTER ENLOE |  | NC | 5 | NC | 1927 | 5
4 | ASTON BOONE |  | PA | 3 | APPALACHIAN ANGLERS | 1115 | 3
5 | GABRIEL WITTOSCH |  | GA | 3 | DEAD DRIFT | 814 | 3
6 | ANDREW BROWN |  | GA | 2 | NC | 725 | 2
7 | AUSTEN RANDECKER |  | PA | 1 | APPALACHIAN ANGLERS | 380 | 1
8 | [NAME] |  | GA | 1 | DEAD DRIFT | 270 | 1
9 | GARRETT GRESHAM |  | GA | 1 | DEAD DRIFT | 180 | 1
Spreadsheet: 145522d1331634186-about-column-chart-818613c
Sheet: 4

data | [NAME] | frquency | %
0.4747765192177438 | 0.1
0.2368296949413358 | 0.2 | 3
0.8029807100895727 | 0.3 | 1
0.4586084257227299 | 0.4 | 0
0.5260953931122121 | 0.5 | 7
0.122167220516036 | 0.6 | 2
0.4701451170543325 | 0.7 | 1
0.940842112000909 | 0.8 | 2
0.4702137045887462 | 0.9 | 3
0.4752698020103026 | 1 | 1
0.1661522285227299
0.728783673306717
0.4087543367812358
0.8115954071871174
0.8594223761163091
0.6519699014015607
0.4002621682814311
0.7215366767367675
0.5939157954989271
0.1741168973511673
Spreadsheet: errol_mclaughlin_jr__10144__Broker Legal Names
Sheet: Sheet1

BROKER LEGAL NAMES |  |  |  |  |  |  |  | SHORT NAMES
[NAME], L.L.C. |  |  |  |  |  | Bianca |  | ALTRS
Amerex |  |  |  |  |  | [NAME] |  | AMERX
American Gas Marketing |  |  |  |  |  | Bianca |  | AGM
APB |  |  |  |  |  | Bianca |  | APB
Choice |  |  |  |  |  | Bianca |  | CHOIC
Coquest Energy Services |  |  |  |  |  | Bianca |  | CESI
Dataline |  |  |  |  |  | Bianca |  | [NAME]
EDF Mann |  |  |  |  |  | Bianca |  | MAN
Elite Energy Brokers |  |  |  |  |  | Bianca |  | ELITE
GA Options, L.L.C. |  |  |  |  |  | Bianca |  | GAOPT
GFI Group, Inc.  (Formerly GFI Broker, LTD.) |  |  |  |  |  | [NAME] |  | GFIGR
Natsource Inc.  (Formerly Optimum) |  |  |  |  |  | Bianca |  | NAT S
Orion |  |  |  |  |  | [NAME] |  | ORION
Power Merchants |  |  |  |  |  | [NAME] |  | PMGL
Prebon Yamane  (Formerly Prebon Energy) |  |  |  |  |  | Bianca |  | PREBO
SCS Commodities |  |  |  |  |  | [NAME] |  | SCS
[NAME] |  |  |  |  |  | [NAME] |  | SPECT
Syntrade Energy |  |  |  |  |  | [NAME] |  | SYNTD
TCT Natural Gas |  |  |  |  |  | [NAME] |  | TCT
TFS Energy, L.L.C.  (Former Sakura Dellsher & Tradition) |  |  |  |  |  | [NAME] |  | TFS
Tradespark, L.P.  (Formerly Cantor Fitzgerald) |  |  |  |  |  | Bianca |  | TRAPA
United Crude Oil |  |  |  |  |  | [NAME] |  | UNITD
United Fuels Intl. |  |  |  |  |  | [NAME] |  | UNFLS
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 1125 | 180
2 | 1804 | 180
3 | 1335 | 180
4 | 1743 | 180
5 | 1680 | 180
6 | 559 | 180
7 | 56 | 180
8 | 251 | 180
9 | 28 | 180
10 | 61 | 180
11 |  | 180
12 | 56 | 180
13 | 2 | 180
14 |  | 180
15 | 47 | 482
16 |  | 482
17 |  | 482
18 |  | 482
19 |  | 482
20 |  | 482
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 0
2002-02-20 00:00:00
CBS Volume
 |  |  | 0
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 4Inter O&M 11-20

Table 5.2.40.  Present Value of Intermittent Operations and [NAME] (Years 11-20)
 |  |  |  |  |  |  |  |  |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of O&M Costs for Year:
Component | Unit Cost | Unit | Quantity | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Intermittent Operations & Maintenace Costs (Years 11-20):
 |  |  |  |  |  |  |  |  |  |  |  | Total Present Value of Intermittent Operations & Maintenance Costs (Life of Project):
Spreadsheet: 267474d1380089874-problem-using-sumproduct-schedule-of-costs-per-page-example-updated
Sheet: Sheet1

Number of pages
19
 |  |  |  |  |  |  |  |  |  |  | Cost Schedule
 |  |  |  |  |  |  |  |  |  |  | Start | End | Rate
 |  |  |  |  |  |  |  |  |  |  | 0 | 19 | 1.75 |  | 1-19 pages would be charged at 1.75 per page
 |  |  |  |  |  |  |  |  |  |  | 20 | 50 | 1.45 |  | 20-50 pages would be charged at 1.45 per page
 |  |  |  |  |  |  |  |  |  |  | 51 | and over | 1 |  | 51 or more pages would be charged at 1.00 per page
 |  |  |  |  |  |  | Total |  | [NAME] used is   =SUMPRODUCT(--(A2>L$6:$L8),(A2-$L$6:$L$8), $N$6:$N$8)
 |  |  |  |  |  |  |  |  | [NAME] used is  =A2*VLOOKUP(A2,L6:N8,3,1)
 |  | In the above example when 19 is entered into the number of pages, the total cost calculate correctly as $19.00. [NAME] if 21 pages are entered the answer is given as $22.00, when it should be $21.00.
Spreadsheet: 60228d1260806393-fiscal-quarter-year-into-a-date-format-qtrs-in-order
Sheet: Quarters

Row Labels | [NAME] | Need to make these into a date format
2007-10-01 00:00:00 | Q4 CY07
2007-11-01 00:00:00 | Q4 CY07
2007-12-01 00:00:00 | Q4 CY07
2008-01-01 00:00:00 | Q1CY08
2008-02-01 00:00:00 | Q1CY08
2008-03-01 00:00:00 | Q1CY08
2008-04-01 00:00:00 | Q2CY08
2008-05-01 00:00:00 | Q2CY08
2008-06-01 00:00:00 | Q2CY08
2008-07-01 00:00:00 | Q3CY08
2008-08-01 00:00:00 | Q3CY08
2008-09-01 00:00:00 | Q3CY08
2008-10-01 00:00:00 | Q4CY08
2008-11-01 00:00:00 | Q4CY08
2008-12-01 00:00:00 | Q4CY08
2009-01-01 00:00:00 | Q1CY09
2009-02-01 00:00:00 | Q1CY09
2009-03-01 00:00:00 | Q1CY09
2009-04-01 00:00:00 | Q2CY09
2009-05-01 00:00:00 | Q2CY09
2009-06-01 00:00:00 | Q2CY09
2009-07-01 00:00:00 | Q3CY09
2009-08-01 00:00:00 | Q3CY09
2009-09-01 00:00:00 | Q3CY09
2009-10-01 00:00:00 | Q4CY09
2009-11-01 00:00:00 | Q4CY09
2009-12-01 00:00:00 | Q4CY09
2010-01-01 00:00:00 | Q1CY10
2010-02-01 00:00:00 | Q1CY10
2010-03-01 00:00:00 | Q1CY10
Spreadsheet: 685536d1594061652-blood-pressure-formula-blood-pressure
Sheet: Sheet1

Date | Time | SYS | DIA | Status
2020-07-05 00:00:00 | 16:12:00 | 119 | 79
 |  | 129 | 79
 |  | 139 | 89
 |  | 179 | 119
 |  | 180 | 120
Spreadsheet: 168258d1342352389-excel-2007-vlookup-returns-n-a-with-special-characters-folderlist
Sheet: Sheet1

Job Number | Folder ID | Result I would like to have ([NAME])
Order 1 | 9(Dij':``%U33O7DX@MM | Data
Order 2 | 3Y=A[$(c!/VH!ga`,T&u | Folder 1
Order 3 | -uecBgd@Do[XaZ.T5%0g
Order 4 | +0*2hqH"+sJ\&`X?c[sQ
Order 5 | +0*2hqH"+sJ\&`X?c[sQ
Order 6 | 9(Dij':``%U33O7DX@MM
Order 7 | 3Y=A[$(c!/VH!ga`,T&u
Order 8 | 3Y=A[$(c!/VH!ga`,T&u
Order 9 | 3Y=A[$(c!/VH!ga`,T&u
Order 10 | N[0$CF$h<CM0qqoVjoPs
Order 11 | 9(Dij':``%U33O7DX@MM
Order 12 | 9(Dij':``%U33O7DX@MM
Order 13 | 3Y=A[$(c!/VH!ga`,T&u
Order 14 | 3Y=A[$(c!/VH!ga`,T&u
Order 15 | 3Y=A[$(c!/VH!ga`,T&u
Order 16 | 9(Dij':``%U33O7DX@MM
Order 17 | gQ1rgV*`$kO9JKLjcCC"
Order 18 | gQ1rgV*`$kO9JKLjcCC"
Order 19 | gQ1rgV*`$kO9JKLjcCC"
Order 20 | N[0$CF$h<CM0qqoVjoPs
Order 21 | -uecBgd@Do[XaZ.T5%0g
Order 22 | -uecBgd@Do[XaZ.T5%0g
Order 23 | 3Y=A[$(c!/VH!ga`,T&u
Order 24 | Kjo@FZoK4%T$qe.WC
Order 25 | `&HC#GeTG1S>+s?J#A1g
Order 26 | Kjo@FZoK4%T$qe.WC
Order 27 | 9(Dij':``%U33O7DX@MM
Order 28 | Kjo@FZoK4%T$qe.WC
Order 29 | 3Y=A[$(c!/VH!ga`,T&u
Order 30 | 9(Dij':``%U33O7DX@MM
Order 31 | gQ1rgV*`$kO9JKLjcCC"
Order 32 | -uecBgd@Do[XaZ.T5%0g
Order 33 | -uecBgd@Do[XaZ.T5%0g
Order 34 | 9(Dij':``%U33O7DX@MM
Order 35 | 3Y=A[$(c!/VH!ga`,T&u
Order 36 | \BqcJLABFgS<hh=?,Nhq
Order 37 | !!!!!!!!!!!!!!!!!!!!
Order 38 | `&HC#GeTG1S>+s?J#A1g
Order 39 | 3Y=A[$(c!/VH!ga`,T&u
Order 40 | `&HC#GeTG1S>+s?J#A1g
Order 41 | 9(Dij':``%U33O7DX@MM
Order 42 | 3Y=A[$(c!/VH!ga`,T&u
Order 43 | 9(Dij':``%U33O7DX@MM