tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__31081__GAS-CENTRAL BOOKS
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Real
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Portfolio |  | Book |  | Portfolio
 | Business Unit |  |  |  | Country |  | Desk |  | Trader |  | [NAME] |  |  |  | Commodity |  | Name |  | Names |  | Name
 |  |  |  |  |  |  | Central
 |  |  |  |  |  |  |  |  | K_RUSCITTI-II
 |  |  |  |  |  |  |  |  |  |  | K_RUSCITTI-II - Gas |  |  |  | - Gas |  |  |  | FT-CENT
 |  |  |  |  |  |  |  |  | J_WILLIAMS-II
 |  |  |  |  |  |  |  |  |  |  | J_WILLIAMS-II - Gas |  |  |  | - Gas |  |  |  | FT-Int-cen-mid
 |  |  |  |  |  |  |  |  | D_PLACHY-II
 |  |  |  |  |  |  |  |  |  |  | D_PLACHY-II - Gas |  |  |  | - Gas |  |  |  | FT-Int-cen-mid2
 |  |  |  |  |  |  |  |  | T_DONOHOE-II
 |  |  |  |  |  |  |  |  |  |  | T_DONOHOE-II - Gas |  |  |  | - Gas |  |  |  | FT-Intra-Gulf
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT-Intra-Gulf2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT-NGPL-Strg
 |  |  |  |  |  |  |  |  | A_LEWIS-II
 |  |  |  |  |  |  |  |  |  |  | A_LEWIS-II - Gas |  |  |  | - Gas |  |  |  | GD-Central
 |  |  |  |  |  |  |  |  | M_CUILLA-II
 |  |  |  |  |  |  |  |  |  |  | M_CUILLA-II - Gas |  |  |  | - Gas |  |  |  |  |  | Souad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Souad
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT-Intra-Ont
 |  |  |  |  |  |  |  |  | G_STOREY-II
 |  |  |  |  |  |  |  |  |  |  | G_STOREY-II - Gas |  |  |  | - Gas |  |  |  | FT-Ontario
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT-Central-Opt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Trans-Cent
 |  |  |  |  |  |  |  |  | V_YAWAPONG-II
 |  |  |  |  |  |  |  |  |  |  | V_YAWAPONG-II - Gas |  |  |  | - Gas |  |  |  | FT-Int-Cen-Mkt
 |  |  |  |  |  |  |  |  | H_SHIVELY-II
 |  |  |  |  |  |  |  |  |  |  | H_SHIVELY-II - Gas |  |  |  | - Gas |  |  |  | FT-Intra-Centr
 |  |  |  |  |  |  |  |  | L_FASCETTI-II
 |  |  |  |  |  |  |  |  |  |  | L_FASCETTI-II - Gas |  |  |  | - Gas
 |  |  |  |  |  |  |  |  | R_TOMASKI-II
 |  |  |  |  |  |  |  |  |  |  | R_TOMASKI-II - Gas |  |  |  | - Gas
 |  |  |  |  |  |  |  |  | J_SIMPSON
 |  |  |  |  |  |  |  |  |  |  | J_SIMPSON - Gas |  |  |  | - Gas |  |  |  | FT-Int-Cen-Mkt2
 |  |  |  |  |  |  |  |  | K_CLAUSSEN
 |  |  |  |  |  |  |  |  |  |  | K_CLAUSSEN - Gas |  |  |  | - Gas
 |  |  |  |  |  |  |  |  | S_MAHMASSANI
 |  |  |  |  |  |  |  |  |  |  | S_MAHMASSANI-GAS |  |  |  | - Gas |  | S_MAHMASSANI-GAS |  | FT-Peoples
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aruba-Sply
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aruba-TP
Spreadsheet: 51373d1251018632-slow-array-formulas-696558_jonathan78
Sheet: Sheet4

 |  | 2009-04-06 00:00:00 | 2009-04-07 00:00:00 | 2009-04-08 00:00:00 | 2009-04-09 00:00:00 | 2009-04-10 00:00:00 | 2009-04-11 00:00:00 | 2009-04-12 00:00:00 | 2009-04-13 00:00:00 | 2009-04-14 00:00:00 | 2009-04-15 00:00:00 | 2009-04-16 00:00:00 | 2009-04-17 00:00:00 | 2009-04-18 00:00:00 | 2009-04-19 00:00:00 | 2009-04-20 00:00:00 | 2009-04-21 00:00:00 | 2009-04-22 00:00:00 | 2009-04-23 00:00:00 | 2009-04-24 00:00:00 | 2009-04-25 00:00:00 | 2009-04-26 00:00:00 | 2009-04-27 00:00:00 | 2009-04-28 00:00:00 | 2009-04-29 00:00:00 | 2009-04-30 00:00:00 | 2009-05-01 00:00:00 | 2009-05-02 00:00:00 | 2009-05-03 00:00:00
 | EMPLOYEE 1 |  | D | D | D |  |  |  | A | A | A |  | D | D | D | D |  |  | A | A | A | A |  | D | D | D
 | EMPLOYEE 2 | A | A | A |  | D | D | D | D |  |  | A | A | A | A |  | D | D | D |  |  |  | A | A | A |  | D | D | D
 | EMPLOYEE 3 |  |  | A | A | A | A | A |  |  | D | D | D | D |  | A | A | A | A | A |  |  | N | N | N |  |  | D | D
Spreadsheet: 5d7ea817-39b7-4d9d-bd26-668cd6f2faa3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-11-15 09:20:30.970000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.375 | 101.613 | 101.488 | 101.363 | 100.988
4.25 | 100.911 | 100.786 | 100.661 | 100.286 |  | Note: | Refer To Price [NAME]
4.125 | 100.538 | 100.413 | 100.288 | 99.913 |  |  | For all Price Adjs
4 | 100.083 | 99.958 | 99.833 | 99.208
3.875 | 99.509 | 99.384 | 99.259 | 98.634
3.75 | 98.638 | 98.513 | 98.388 | 97.763
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.581 | 101.456 | 101.331 | 100.956
3.75 | 101.067 | 100.942 | 100.817 | 100.442
3.625 | 100.759 | 100.634 | 100.509 | 100.134
3.5 | 100.402 | 100.277 | 100.152 | 99.777
3.375 | 100.019 | 99.894 | 99.769 | 99.144
3.25 | 99.462 | 99.337 | 99.212 | 98.587
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-11-29 09:20:30.970000
30 DAY | 2011-12-14 09:20:30.970000
45 DAY | 2011-12-29 09:20:30.970000
60 DAY | 2012-01-13 09:20:30.970000
90 DAY | 2012-02-12 09:20:30.970000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 2c44002a-873f-4921-8b94-43bbdb7cddd6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FSLFU | Test | FSLFU | Sulfonylurea Screen, [NAME] | [NAME], QT, UR | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) |  |  |  |  |  | Collect 5 mL random urine without preservative. Ship refrigerated in a plastic container. | 1.2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Reference Range:	Not Established   Acetohexamide, UR	ug/mL Chlorpropamide, UR	ug/mL Tolazamide, UR		ug/mL Tolbutamide, UR	ug/mL Glimepiride, UR		ng/mL Glipizide, UR		ng/mL Glyburide, UR		ng/mL Nateglinide, UR		ng/mL Repaglinide, UR	ng/mL   Test Performed by:	Medtox Laboratories, Inc.  			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FSLFU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
FSLFU | Result | [NAME] | Acetohexamide, UR | Acetohexamide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | Z3264 | Chlorpropamide, UR | Chlorpropamide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | Z3265 | Tolazamide, UR | Tolazamide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | Z3266 | Tolbutamide, UR | Tolbutamide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | Z3270 | Glimepiride, UR | Glimepiride, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | Z3271 | Glipizide, UR | Glipizide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | Z3272 | Glyburide, UR | Glyburide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | [NAME] | Nateglinide, UR | Nateglinide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FSLFU | Result | Z3274 | Repaglinide, UR | Repaglinide, UR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 454305d1459786717-problem-with-formula-when-opening-stock-is-greater-than-first-order-for-product-copy-of-book1example-5-1
Sheet: Sales

 |  |  |  |  |  |  |  |  | Running Total
 |  |  |  |  |  |  |  |  | After Sales | Stock Bought
 | Sale orders |  |  |  |  | Opening Cost |  |  | Stock on Hand | Running Total
Order Number | [NAME] | Total Sold | Cost of Order |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | as it came from the forum
1 | 140 |  | =40 x £1.12 plus 160 x £1 |  |  |  |  |  |  |  |  | Cost | Total Qty | Running Total |  | 204.8 | different first formula in column |  |  | =IF(K6>K5,G5,0)*IF(E6=0,0,J5)+(INDEX($M$7:$M$11,MATCH(K6,$O$7:$O$11,0))*IFERROR(B6-F6,B6))
2 | 320 |  | =320 x £1 |  |  |  |  |  |  |  |  |  |  | 0 |  | 320
3 | 30 |  | =30 x £1 |  |  |  |  |  |  |  |  | 1.12 | 200 |  |  | 30
4 | 400 |  | =400 x £1 |  |  |  |  |  |  |  |  | 1 | 1000 |  |  | 400
5 | 250 |  | =90 x £1 plus 160 x £2 |  |  |  |  |  |  |  |  | 2 | 1000 |  |  | 410
6 | 100 |  | =100 x £2 |  |  |  |  |  |  |  |  | 2.2 | 1000 |  |  | 200
7 | 400 |  | =400 x £2 |  |  |  |  |  |  |  |  | 1 | 2000 |  |  | 800
8 | 240 |  | =240 x £2 |  |  |  |  |  |  |  |  |  |  |  |  | 480
9 | 240 |  | =100 x £2 plus 140 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 508
10 | 300 |  | =300 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 660
11 | 400 |  | =400 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 880.0000000000001
12 | 50 |  | =50 x £2.20 |  |  |  |  |  |  |  |  |  |  |  |  | 110
13 | 150 |  | =110 x £2.20 plus 40 x £1 |  |  |  |  |  |  |  |  |  |  |  |  | 282
 |  |  | replaces E7 >>>>>>>>>>
Spreadsheet: 9021169d-48f4-4198-8aac-505a733c5c59
Sheet: Income Statement

AMERICAN CAPITAL, LTD.
CONSOLIDATED STATEMENTS OF OPERATIONS
Three Months Ended March 31, 2012 and 2011
(in millions, except per share data)
(unaudited)
 |  |  |  |  | Three Months Ended
 | Three Months Ended |  |  |  | March 31,
 | March 31, |  |  |  | 2012 Versus 2011
 | 2012 |  | 2011 |  | $ |  | %
OPERATING INCOME
Interest and dividend income | 136 |  | 146 |  | -10 |  | -0.0684931506849315
Fee income | 13 |  | 13 |  | 0 |  | 0
Total operating income | 149 |  | 159 |  | -10 |  | -0.06289308176100629
OPERATING EXPENSES
Interest | 16 |  | 29 |  | -13 |  | -0.4482758620689655
Salaries, benefits and stock-based compensation | 37 |  | 36 |  | 1 |  | 0.02777777777777778
General and administrative | 15 |  | 11 |  | 4 |  | 0.3636363636363636
Total operating expenses | 68 |  | 76 |  | -8 |  | -0.1052631578947368
NET OPERATING INCOME BEFORE INCOME TAXES | 81 |  | 83 |  | -2 |  | -0.02409638554216868
Tax provision | -32 |  | 0 |  | -32 |  | -1
NET OPERATING INCOME | 49 |  | 83 |  | -34 |  | -0.4096385542168675
Net realized (loss) gain
Portfolio company investments | -122 |  | 10 |  | -132 |  | NM
Foreign currency transactions | 1 |  | 0 |  | 1 |  | 1
Derivative agreements | -8 |  | -13 |  | 5 |  | 0.3846153846153846
Tax benefit | 22 |  | 0 |  | 22 |  | 1
Total net realized loss | -107 |  | -3 |  | -104 |  | NM
NET REALIZED (LOSS) EARNINGS | -58 |  | 80 |  | -138 |  | NM
Net unrealized appreciation (depreciation)
Portfolio company investments | 627 |  | 256 |  | 371 |  | 1.44921875
Foreign currency translation | 38 |  | 85 |  | -47 |  | -0.5529411764705883
Derivative agreements | -6 |  | 13 |  | -19 |  | NM
Tax provision | -21 |  | 0 |  | -21 |  | -1
Total net unrealized appreciation | 638 |  | 354 |  | 284 |  | 0.8
NET INCREASE IN NET ASSETS RESULTING FROM OPERATIONS ("NET EARNINGS") | 580 |  | 434 |  | 146 |  | 0.336405529953917
NET OPERATING INCOME PER COMMON SHARE
Basic | 0.15 |  | 0.24 |  | -0.09 |  | -0.375
Diluted | 0.14 |  | 0.23 |  | -0.09 |  | -0.3913043478260869
NET REALIZED (LOSS) EARNINGS PER COMMON SHARE
Basic | -0.18 |  | 0.23 |  | -0.41 |  | NM
Diluted | -0.17 |  | 0.22 |  | -0.39 |  | NM
NET EARNINGS PER COMMON SHARE
Basic | 1.75 |  | 1.25 |  | 0.5 |  | 0.4
Diluted | 1.71 |  | 1.21 |  | 0.5 |  | 0.4132231404958678
WEIGHTED AVERAGE SHARES OF COMMON STOCK OUTSTANDING
Basic | 330.9 |  | 346.1 |  | -15.20000000000005 |  | -0.04391794279110096
Diluted | 339.6 |  | 358.4 |  | -18.79999999999995 |  | -0.05245535714285702
NM = Not meaningful.
Spreadsheet: 03f39a0a-cda6-449d-8835-b00bdef6e3f3
Sheet: March 2013

Spend over £25,000 - Publication template
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | SMG | 2013-03-07 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 172085 | 27149.46
DCMS | SMG | 2013-03-07 00:00:00 | Security | NMeM Security | [NAME] | 172311 | 32309.75
DCMS | SMG | 2013-03-07 00:00:00 | Security | NRM Security | [NAME] | 172317 | 32771
DCMS | SMG | 2013-03-07 00:00:00 | Build Construction | National MPG | Hemcrete Projects Limited | 172335 | 34842.13
DCMS | SMG | 2013-03-21 00:00:00 | Professional Fees | ScM Major projects | Universal Design Studio Limited | 172337 | 38525
DCMS | SMG | 2013-03-07 00:00:00 | Security | ScM Security | [NAME] | 172352 | 149267.33
DCMS | SMG | 2013-03-21 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 172627 | 28974.85
DCMS | SMG | 2013-03-21 00:00:00 | Build Construction | Science Museum Workshops & Gallery Maintenance | Secom Plc | 172921 | 36647
DCMS | SMG | 2013-03-21 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 172986 | 46278.91
DCMS | SMG | 2013-03-21 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 172989 | 41671.11
DCMS | SMG | 2013-03-21 00:00:00 | Security | NRM Security | [NAME] | 173008 | 32771
DCMS | SMG | 2013-03-21 00:00:00 | Security | NMeM Security | [NAME] | 173009 | 32309.75
DCMS | SMG | 2013-03-21 00:00:00 | Security | ScM Security | [NAME] | 173194 | 149267.33
DCMS | SMG | 2013-03-21 00:00:00 | Rates (CILOR) | NRM Estates | City of York Council | 173371 | 56991
DCMS | SMG | 2013-03-21 00:00:00 | Build Construction | National MPG | Elmwood (Glasgow) Ltd | 173446 | 84017.92
DCMS | SMG | 2013-03-28 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 173678 | 26648.64
DCMS | SMG | 2013-03-28 00:00:00 | Build Construction | Science Museum Workshops & Gallery Maintenance | Secom Plc | 173981 | 49004
DCMS | SMG | 2013-03-28 00:00:00 | Professional Fees | NMeM Estates | Honeywell Controls Ltd | 174042 | 25053
DCMS | SMG | 2013-03-28 00:00:00 | Rates (CILOR) | NMeM Estates | Bradford Council | 174209 | 48513
DCMS | SCMGE | 2013-03-21 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 121934 | 85381.8
DCMS | SCMGE | 2013-03-21 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 121935 | 85381.8
DCMS | SCMGE | 2013-03-21 00:00:00 | Contract Cleaning | Visitor Experience | Servest (Sherwood) Ltd | 121936 | 85381.8
DCMS | SCMGE | 2013-03-28 00:00:00 | SCM Retail Stock | Visitor Related | Carlton Books | 122170 | 26250
Spreadsheet: 856557d1705763269-move-data-from-columns-to-rows-with-some-common-fields-thanks-excel-cloumns-to-rows-example-ans
Sheet: Sheet1

Name | Currency | Performance Bonus | Dividend | Deferral | MEP Payment 1 | MEP Payment 2 | Deferral 2
[NAME] | USD | 55000 | 398 | 10000 | 25000 | 20000 | 1000
[NAME] | USD | 27500 | 146 | 5000 | 10000 | 9000 | 6000
[NAME] | USD | 10000 |  |  |  | 1000
Luisa | GBP | 13000 |  |  | 1432 | 1600
Name | Currency | Type of Payment | Amount |  |  |  |  |  |  |  | Name | Currency | Type of Payment | Amount
 | USD | Performance Bonus | 55000 |  |  |  |  |  |  |  | [NAME] | USD | Performance Bonus | 55000
[NAME] | USD | Dividend | 398 |  |  |  |  |  |  |  | [NAME] | USD | Dividend | 398
[NAME] | USD | Deferral | 10000 |  |  |  |  |  |  |  | [NAME] | USD | Deferral | 10000
[NAME] | USD | MEP Payment 1 | 25000 |  |  |  |  |  |  |  | [NAME] | USD | MEP Payment 1 | 25000
[NAME] | USD | MEP Payment 2 | 20000 |  |  |  |  |  |  |  | [NAME] | USD | MEP Payment 2 | 20000
[NAME] | USD | Deferral 2 | 1000 |  |  |  |  |  |  |  | [NAME] | USD | Deferral 2 | 1000
[NAME] | USD | Performance Bonus | 27500 |  |  |  |  |  |  |  | [NAME] | USD | Performance Bonus | 27500
[NAME] | USD | Dividend | 146
[NAME] | USD | Deferral | 5000
[NAME] | USD | MEP Payment 1 | 10000
[NAME] | USD | MEP Payment 2 | 9000
[NAME] | USD | Deferral 2 | 6000
[NAME] | USD | Performance Bonus | 10000
[NAME] | USD | MEP Payment 2 | 1000
Luisa | GBP | Performance Bonus | 13000
Luisa | GBP | MEP Payment 1 | 1432
Luisa | GBP | MEP Payment 2 | 1600
Spreadsheet: benjamin_rogers__1034__Shortlist2
Sheet: Mission

EIDSON MISSION
Activity/Strategy: | * Develops, acquires, builds, owns, manages and operates IPP facilities worldwide using gas, oil, coal, geothermal, hydro and other generation technologies
 | * Power marketing
 | * Play an active role as a long-term owner in all phases of power generation, from planning and development through construction and commercial operation
 | * Strategy in the US is to focus on operating power plants; pursuing acquisition of existing plants held by utilities, industrial generators and IPPs; and developing greenfield projects
 | * Look for partners with strong local presence and complimentary attributes
Comments: | * Avoid acquiring electric distributors
 | * Mitigate risks by:
 | * selecting partners with complimentary skills and local experience
 | * managing up-front development costs
 | * linking revenue and expense components
 | * pursuing forward positions through its asset based trading operations
 | * Offers substantial development, financial, engineering and construction experience
Summary: | North America |  |  |  |  |  |  |  |  |  |  | North America (Net Equity) |  |  | International (Net Equity)
 | Net Equity (Op & Construction) | Operation |  |  | Construction |  |  | Development |  |  | Operation | Construction | Development | Operation | Construction | Development
 | (MW) | Plants | MW | Net Equity | Plants | MW | Net Equity | Plants | MW | Net Equity | MW | MW | MW | MW | MW | MW
 |  | 60 | 26648.7 | 22057.32715 | 4 | 1797 | 713.3679999999999 | 3 | 1500 | 643 | 13007.76875 | 0 | 250 | 9049.558400000004 | 713.3679999999999 | 393
Company Type : | Subsidiary of a public IOU
Stock Exchange: | Na
[NAME]: | Na
Holding Company: | Edison International (trade as EIX in NYSE)
Subsidiary/ Affiliate: | Southern California Edison, Edison Capital, Edison Enterprises
Web Page: | http://www.edison.com/profileexa/eme/index.htm
Spreadsheet: 124809d1318620039-average-forumula-separate-ranges-and-excluding-0s-book1
Sheet: Sheet1

Date | Amount | Weekday
2011-02-01 00:00:00 | 120
2011-02-02 00:00:00 | 130
2011-02-03 00:00:00 | 140
2011-02-04 00:00:00 | 150
2011-02-05 00:00:00 | 160
2011-02-06 00:00:00 | 170
2011-02-07 00:00:00 | 180
2011-02-08 00:00:00 | 190
2011-02-09 00:00:00 | 0
2011-02-10 00:00:00 | 0
2011-02-11 00:00:00 | 100
2011-02-12 00:00:00 | 100
2011-02-13 00:00:00 | 100
2011-02-14 00:00:00 | 100
2011-02-15 00:00:00 | 100
2011-02-16 00:00:00 | 100
2011-02-17 00:00:00 | 100
2011-02-18 00:00:00 | 100
2011-02-19 00:00:00 | 0
2011-02-20 00:00:00 | 0
2011-02-21 00:00:00 | 25
2011-02-22 00:00:00 | 50
2011-02-23 00:00:00 | 75
2011-02-24 00:00:00 | 100
2011-02-25 00:00:00 | 125
2011-02-26 00:00:00 | 150
2011-02-27 00:00:00 | 175
2011-02-28 00:00:00 | 200
Spreadsheet: 11c5e348-fa4f-4322-8deb-80b9693a858a
Sheet: Enki eBooks

Enki Library eBooks 2014
 | Collection Size |  | Patrons |  | Circulations
 | Total Titles | Total Copies | Total | New | Total
January | 16540 | 18226 | 40 |  | 79
February | 16540 | 18226 | 45 | 5 | 64
March | 17005 | 18761 | 58 | 13 | 125
April | 18211 | 19967 | 65 |  | 110
May | 18269 | 20029 | 77 |  | 93
June | 18615 | 20392 | 89 |  | 99
July | 22132 | 24020 | 108 |  | 104
August | 22132 | 24020 | 122 |  | 81
September | 22132 | 24020 | 127 | 5 | 48
October | 22132 | 24020 | 135 |  | 137
November | 27659 | 30487 | 155 |  | 166
December
Year to date
Notes
Fully public on January 24, 2014.
Top books are not being recorded for Enki.
 | Currently the only report like this is for all time (not monthly) and all libraries (not broken out for each location).
 | Will start recording this information if it is more specific to KS.
Spreadsheet: 92816d1292356114-compare-and-highlight-cells-based-on-date-compare-date-sample
Sheet: Sheet2

Company Name | PropertyName | Run # | API | 2010-01-10 00:00:00 | 2010-02-10 00:00:00 | 2010-03-10 00:00:00 | 2010-04-10 00:00:00 | 2010-05-10 00:00:00 | 2010-06-08 00:00:00 | 2010-07-10 00:00:00 | 2010-08-10 00:00:00 | 2010-09-10 00:00:00 | 2010-10-10 00:00:00 | 2010-11-10 00:00:00 | 2010-12-10 00:00:00 | YTD
????? | JOHNSTON A #8 | 450 | 3003906836 | 0 | 0 | 0 | 0 | 0 | 897 | 711 | 630 | 548 | 0 | 0 | 0 | 2786
????? | JOHNSTON A #8 | 450 | 3003906836 | 997 | 869 | 913 | 978 | 1050 | 905 | 989 | 805 | 794 | 0 | 0 | 0 | 8300
JOHNSTON A #8 | 2010-01-10 00:00:00 | 1 |  |  |  |  |  |  | =IF(F9>=G9,"1"," ")
JOHNSTON A #8 | 2010-12-31 00:00:00
 |  |  |  |  | JOHNSTON A #8
Spreadsheet: 85237d1285268259-how-to-extract-names-that-are-flagged-by-red-dots-book2-vlookup
Sheet: Sheet1

 |  |  |  | Aug 30th | Aug 31st | Sept 1st | Sept 2nd | Sept 3rd | Sept 4th | Sept  5th | Sept 7th | Sept 10th | Sept 13th | Sept 17th | Sept 19th | Sept 20th | Sept 21st | Sept 22nd | Sept 23rd | Sept 24th | Sept 25th | Sept 28th | Sept 29th | Sept 30th | Oct 1st | Oct 2nd | Oct 5th | Oct 6th
# | e number | NAME
1 | 6710 | A
2 | 6720 | B
3 | 6721 | C
4 | 6730 | D
706 | 6731 | E
404 | 6740 | F
323 | 6741 | G
 | 6750 | H
 | 6751 | I
 | 6760 | J
 | 6761 | K
Spreadsheet: 87971d1287852399-need-to-change-the-range-of-sum-depending-on-some-conditions-simplified-mps
Sheet: Hoja1

Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Orders | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20
MPS | 100 |  |  | 100 |  |  |  | 200 |  |  |  | 150
ATP | 40 |  |  | 20 |  |  |  | 120 |  |  |  | 130
 | I'm trying to calculate ROW 5, which is called ATP.    There are two rules:  1) ATP is ONLY calculated when the MPS cell above it has a value.  2) ATP is calculated as the MPS cell value MINUS the SUM of the Orders cells from that period up to (but not including) the next period which has a MPS value.
 | So in cell B5, the formula is B4-SUM(B3:D3)
 | So in cell E5, the formula is E4-SUM(E3:H3)
 | So in cell I5, the formula is I4-SUM(I3:L3)
 | In other words, the RANGE to be added CHANGES depending on when is the next MPS value…
 | HELP….
Spreadsheet: 874954d1721478502-pulling-data-from-multiple-tables-across-multiple-sheets-book_test-bsb-
Sheet: 10 Min Exception

Hc2 | Hc | CON # | INCIDENT # | NATURE | PRIORITY CODE | ADDRESS | CITY | UNIT | UNIT ASSIGNED | UNIT ON SCENE | RT: | NOTES:
 |  |  |  |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  |  |  |  | O/S 00:08:00
 |  |  |  |  |  |  |  |  |  |  |  | R/M CALL