tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 772794d1647464791-combining-vertical-and-horizontal-lookups-to-determine-an-unknown-value-combining-vertical-and-horizontal-lookups-to-determine-an-unknown-value
Sheet: Full Data Set

primary specialty | Value | Percentile
Allergy/Immunology | 16210 |  |  |  | All_Spec | =INDEX(Horizontal!$A:$A,MATCH(1E+307,Horizontal!$A:$A)):INDEX(Horizontal!$2:$2,MATCH("zzzz",Horizontal!$1:$1)-1)
Anesthesiology: Pain Management | 13295 |  |  |  | Percentiles | =Horizontal!$AJ$2:INDEX(Horizontal!$AJ:$AJ,MATCH(1E+307,Horizontal!$AJ:$AJ))
Cardiology | 9494
Dermatology | 5791
Endocrinology/Metabolism | 2888
Family Medicine: Ambulatory Only | 945
Family Medicine: Sports Medicine | 4869
Gastroenterology | 11857
Geriatrics | 2126
Hematology/Oncology | 2660
Hospice/Palliative Care | 1043
Hospitalist: Internal Medicine | 17190
Infectious Disease | 1589
Internal Medicine: Ambulatory Only | 4998
Nephrology | 11855
Neurology | 351
OB/GYN: Maternal and Fetal Medicine | 7517
Obstetrics/Gynecology: General | 6103
Occupational Medicine | 13
Ophthalmology | 16290
[NAME]: General | 14619
Pediatrics: General | 2880
Physiatry (Physical Medicine and Rehabilitation) | 11952
Podiatry: General | 13897
Psychiatry: General | 4057
Pulmonary Medicine: General and Critical Care | 16884
Radiation Oncology | 29630
Radiology: Diagnostic | 6739
Rheumatology | 3998
Surgery: Cardiovascular | 9448
Surgery: General | 8816
Surgery: Neurological | 14091
Surgery: Plastic and Reconstruction | 10764
Urology | 9241
Spreadsheet: 47788d1246969686-text-colour-change-depending-on-outcome-of-formula-tom
Sheet: New Employee

Name | Rate Per Hour | Contracted Hours
[NAME] | 6 | 39
[NAME] | 15 | 30
[NAME] | 5.5 | 30
Gemma | 7.45 | 30
[NAME] | 7 | 14
[NAME] | 12 | 13
Spreadsheet: de8701c5-e505-4d8c-8a65-64937abd28dc
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
VELV | Test | VELV | Velvet Leaf, IgE | Velvet Leaf, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
VELV | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
VELV | Result | VELV | Velvet Leaf, IgE | Velvet Leaf, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6272-9
Spreadsheet: daren_farmer__5976__hpl0616
Sheet: Sheet1

HPLN0616.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 16, 2000
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-16 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM | VOLUME
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 25 | *
Enron (FM) |  | HPL - Katy (DBND) |  | HPL | 0 | 5 | *
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Oasis Turbine |  | Empire | 9.35 | 9.35
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 214207d1360845370-create-top-ten-list-based-on-number-of-classes-currently-overdue-desired-result
Sheet: Overdue

Overdue Top Ten
SECT | NAME | EMP | GRD | UNIT | CCODE | TITLE | DUR | INT | STATUS | COMP | DUE
Overdue Top Ten
 |  |  |  | RANK | CCODE | TITLE | QUANTITY
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
Spreadsheet: 06fdcdb7-b0c7-485d-812a-9b24c51aaf8e
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 3/12/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2011/12 ---------- |  | ---------- 2012/13 ---------- |  | 2013/14
 |  | Mkt year | Jun-Jan | Mkt year | Jun-Jan | Jun-Jan
Oats | Canada | 1556.499397 | 1184.716578 | 1590.304046 | 1167.301306 | 962.0860260000001
 | Finland | 34.84057 | 34.84057 |  |  | 38.947872
 | Sweden | 29.020381 |  | 7.875 |  | 32.914824
 | All other countries | 1.067246 | 0.558388 | 1.912764 | 1.474674 | 2.480323
 | Total 2/ | 1621.427594 | 1220.115536 | 1600.09181 | 1168.77598 | 1036.429045
Malting barley | Canada | 263.660306 | 114.959883 | 342.0999419999999 | 248.761071 | 111.992869
 | All other countries | 0.244638 | 0.244638 | 0.06603 | 0.016775
 | Total 2/ | 263.904944 | 115.204521 | 342.1659720000001 | 248.777846 | 111.992869
Other barley 3/ | Canada | 89.27383699999999 | 58.95385700000001 | 160.983119 | 99.556042 | 90.63406599999999
 | All other countries | 0.7575110000000002 | 0.6405689999999999 | 3.99892 | 1.6826 | 1.466325
 | Total 2/ | 90.031348 | 59.594426 | 164.982039 | 101.238642 | 92.100391
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 3/11/2014
Spreadsheet: 263378d1378462632-drop-down-selection-menus-repair-quote-sheet
Sheet: Sheet1

[NAME]?     Yes  o     No o |  |  |  | Repair Quote  / Job Pending |  |  |  |  |  |  | Page |  |  | of |  |  | Date:
Customer: |  |  |  |  |  | Make and Type: |  |  |  |  |  |  |  |  | Engineer's Name:
Address: |  |  |  |  |  | Model No: |  |  |  |  |  |  |  |  | Completion No:
 |  |  |  |  |  | Serial No: |  |  |  |  |  |  |  |  | [NAME]: |  |  | Notes:
Contact Name: |  |  |  |  |  | Revision No:
Telephone No. |  |  |  |  |  | PNC Code: |  |  |  |  |  |  |  |  |  |  |  | Account Ref:
Fax No. / Email |  |  |  |  |  | Asset No:
Supplier | Tel / Email / Fax No. |  | Part Number |  |  | Lead Time |  | In Stock? | Description |  |  |  |  |  |  | Price £ | % Disc. | Qty | Net Price £
CC Spares |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 30 | 1
(E) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10.5 | 10 | 1
(F) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 20 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 50 | 1
(T) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 | 32.5 | 1
(E)
(F)
(T)
(E)
(F)
(T)
(E)
(F)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Warranty Period:
Action Taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Hours Labour @ | 40
 |  |  |  |  |  |  |  |  |  |  |  | Sub Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delivery |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Price Quoted to Customer : Total £
Order Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAT Total for Order @ |  | 0.2 | VAT
Ordered By
Date Ordered |  |  |  |  |  |  |  |  |  | [NAME] by  [NAME] o   Fax o   Phone o |  |  |  |  |  |  |  | Date:
Date Received
Supplier |  |  |  |  |  |  |  |  |  | Quote Accepted: |  |  | o
 |  |  |  |  |  |  |  |  |  | By: |  |  |  |  |  | WORK Order:
Parts to collect from stores |  |  |  |  |  |  |  |  |  | Cleared with accounts: |  |  | o |  |  | SWP Number:
Spreadsheet: 881812d1730010384-finding-the-average-mark-of-different-weighted-assessment-items-including-a-and-0-marks-ca76-assessment-samples-including-a-and-0-scores-spill-365-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Assessment Items |  |  |  |  | Final Assessment
Date |  |  |  |  |  |  |  |  | Notes | Homeworks | Tests | Research | Python
Assessment Item | Notes | Homeworks | Tests | Research | Python | Python | Tests | Python
 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  | 1
Student | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 0.05 | 0.05 | 0.25 | 0.2 | 0.45
Student 1 | 0 | 0 | 0 | 0 | 100 | 100 | 0
Student 2 | 100 | 0 | 100 | A | 0 | 100 | 100 |  |  |  |  |  |  | 65.625
Student 3 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  | 100
Student 4 | 80 | 90 | A | 60 | 70 | 50 | 40 |  |  |  |  |  |  | 57.5
Student 5 | 67 | 78 | 50 | 50 | 50 | 40 | 60 |  |  |  |  |  |  | 51.25
Student 6 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  | 100
Student 7 | 40 | 80 | 90 | 70 | 30 | 20 | 10 |  |  |  |  |  |  | 43.75
Student 8 | 0 | 0 | 0 | 0 | 100 | 100 | 0 |  |  |  |  |  |  | 45
Student 9 | A | A | 100 | A | 56 | 90 | 100 |  |  |  |  |  |  | 82.64285714285715
Student 10 | 0 | 0 | 30 | 50 | A | A | A |  |  |  |  |  |  | 31.81818181818182
Spreadsheet: 869852d1716399436-gather-data-from-multiple-sheets-to-only-one-sheet-file_updated
Sheet: C

ACCESSID | USER NAME | USER TYPE | USER STATUS | EMPLOYEE ID | EMAIL ADDRESS | USER LOCATION | USER COUNTRY | USER LOGON TYPE | USER LAST LOGON DT | USER LOGON STATUS | USER GROUP MEMBERSHIP | USER ROLE |  |  |  |  |  | # | Name | UserId | User name | [NAME] | User type / Role (if available) | User status (if available)
adr1 | User Adrian | End User | Active |  | [EMAIL] |  |  |  |  | No Log
conu2 | User Con | End User | Active |  | [EMAIL] |  |  |  |  | Active
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME] | fire at Milagro on 15th has prevented payback
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
NNG |  |  |  | Dollar Valued | [NAME] | working on 10,000/d to sell
NGPL |  |  |  | Volumetric | [NAME] | received 35,000 mmbtus in payback in 7/01
[NAME] |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME] | [NAME] is talking to Red Cedar about cash out
SoCal |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Amoco |  |  |  | Volumetric | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME] | 108,000 mmbtus received in payback in 7/01
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
[NAME] |  |  |  | Dollar Valued | [NAME] | 6/30/01 bal of $887,643.73 invoiced-not rec'd as of 7/27/01
EOG |  |  |  | Dollar Valued | [NAME] | 47,000 mmbtus received in payback in 7/01
Oasis |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME] | scheduling 3,000/d in payback
PG&E Topock |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
Continental |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 454035d1459605474-ifs-and-sums-and-nests-or-something-more-simple-example-2-2016-fifo
Sheet: Sales

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Running Totals Sold |  |  | Cost Per Product
 | Order Number | Dispatch Date | Order Date | Month No | Customer | email Address | Order Number | Telephone | Address | Postcode | How Paid? | Auth Number  Invoice Number  Date Payment Rec'd | Dispatch Method | [NAME]  £ | TAX Charged | Sub-Total | Check Qty Bought | Product 1 Name | Product 2 Name | Product 3 Name |  |  |  |  |  |  | Cost Per Order | Nominal Gross Profit | Cost Error
 | 20145 |  | 2016-04-02 00:00:00 |  |  |  |  |  |  |  |  |  |  | 27180 |  |  |  | 3000
 | 20146 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56
 | 20147 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 | 20148 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1325
 | 20149 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 340
 | 20150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | 20151 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 670
 | 20152 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 25
 | 20153 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
 | 20154 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
 | 20155 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 20156 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
 | 20157 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 |  | 1
 | 20158 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000
 | 20159 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | 20160 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
 | 20161 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400
 | 20162 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000
 | 20163 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500
 | 20164 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 | 20165 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 1 | 1
 | 20166 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | 20167
 | 20168
 | 20169
 | 20170
 | 20171
 | 20172
 | 20173
Spreadsheet: 546740d1510174251-vlookup-between-sheets-to-give-different-code-dates-example-spreadsheet
Sheet: 12 Column

Date Produced: |  |  | 2017-11-02 00:00:00
Date Code: |  |  |  |  |  |  |  |  |  | 12
Product: |  |  |  |  |  |  |  | Best By: |  |  | ( |  | days) | Line #:_________
Item Number: |  |  | 87654321 |  |  |  | BAD COLUMN COUNT, USE:
Flavor/Color OK: (YES/NO)_________ |  |  |  |  |  |  |  |  |  |  |  | LINE SUPERVISOR:________________________
Time |  |  |  |  |  |  |  |  |  |  |  |  |  | Inspected By
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Corrective Actions
08:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
09:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
10:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
11:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
12:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
13:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
14:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
15:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
16:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
17:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
18:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
19:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
20:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
21:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
22:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
23:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
1900-01-01 00:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
1900-01-01 01:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
1900-01-01 02:00:00 |  | ERROR |  |  |  |  | ERROR |  |  |  |  | ERROR
Comments:
Spreadsheet: 184172d1349172917-calculating-the-number-of-days-example-ss_rev_b
Sheet: Cycle

Route Cycle | Exercise | Type | Day | Month | Wk | Distance (Miles) | Time (mins sec) | Cycle No. This Year Sub Total | Days Since Last Cycle | Total Weeks Cycle Miles TOTAL
Torquay-Newton Abbot | Cycle | Ride | 2012-09-22 00:00:00 | 2012-09-22 00:00:00 | 38 | 14.03 | 67.12 |  | 10 | 31.57
Home-Paignton | Cycle | Ride | 2012-09-17 00:00:00 | 2012-09-17 00:00:00 | 38 | 12.32 | 45.12 | 2 | 3
[NAME] | Cycle | Ride | 2012-09-14 00:00:00 | 2012-09-14 00:00:00 | 37 | 5.22 | 36.45 | 1
The Columns in Yellow will up-date
Automatically as you enter a date on the
next line.
Spreadsheet: sally_beck__33713__MgmtSum-Q2-0623 version a
Sheet: Q1 Mgmt Summary

E N R O N   N O R T H   A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  | 1ST QTR 2000 EARNINGS
 |  |  |  |  |  |  |  |  |  |  |  |  | Results based on Activity through March 31, 2000
 |  | Margin |  |  |  | Expenses |  |  |  |  | EBIT
Business Team |  | Actual | Plan | [NAME] |  | Forecast | Plan* | [NAME] |  |  | Forecast | Plan | [NAME]
 |  |  |  |  |  |  |  | [NAME] | Cash Exp
Gas Trading |  |  | 41592 |  |  |  |  | 0
Texas Desk |  | 17193 | 7436 |  |  | 2875 | 3355 | 0
Power Trading |  |  |  |  |  |  |  | 478
Financial Drift |  | 25965 | 22402 |  |  | 1834 | 1630 | 0
Financial Trading |  |  |  |  |  |  |  | 0
Canada Trading |  |  | 11556 |  |  |  |  | 0
Coal-Trading |  | 3398 | 12747 |  |  | 6393 | 4728 | 0 | -1702
GRM -  Weather |  | 5666 | 3215 |  |  | 2609 | 1722 | 0
Emissions (Coal) |  | 3674 | 750 |  |  | 266 | 342 | 0
Total Trading & Risk Mgt. |  |  |  |  | 129970
East Midstream |  | 2838 | 14243 |  |  | 4815 | 6563 | 0
West Midstream |  | 8356 | 13235 |  |  | 5047 | 7464 | -604
Industrial Downstream
Generation Investments/IPP |  | 7219
Coal Origination & Finance |  |  | 0 |  |  | 0 | 0 | 37 | 0
Canada Origination & Finance |  |  | 11556 |  |  |  |  | 183
ENA Upstream Assets |  | 23078 | 30320 |  |  | 62429 | 60693 | 2344
HPL |  |  |  |  |  |  |  | 0 | 0
LRC |  |  |  |  |  |  |  | 0 | 0
GRM - New Products |  | 0 | 7712 |  |  | 1484 | 1217 | 0
Mexico |  | 11 | 4656 |  |  | 2218 | 2456 | 0
Total Origination |  |  |  |  | 0
Principal Investing |  | 93673 | 15379 |  |  | 2669 | 3204 | 625
Energy Capital Services |  | 858 | 0 |  |  | 6027 | 7138 | 1539
CTG Assets |  |  | 14404
Total Investing
Commercial Transactions Group |  | 1400 | 2500 |  |  | 8467 | 8514 | 0
Office of the Chairman |  | 0 | 0 |  |  | 8285 | 7652 | 0
Overview |  | 0 | 48693 |  |  | 0 | 0 | 0
Total Commercial
Group Total |  |  |  |  |  | 79168 | 63376
Group Allocated to Teams |  | 0 |  |  |  |  |  | 0
Other Interest Related Charges |  | -22158 | -10795 |  |  | 14727 | 22603 | 0
Capital Charge Offset |  |  |  |  |  | -32741 | -39874 | -7133
ENA EBIT
Interest Expense/(Income) |  |  |  |  |  | 1223 | 12000 | 0
[NAME]
* Includes Capital Charge & Operating, Direct, and Allocated Expenses
Spreadsheet: 42385d1240953576-if-cell-x-0-then-copy-range-of-cells-test-book111
Sheet: mats order

 |  |  |  | invioce address |  |  |  |  |  |  |  |  |  |  |  |  | delivery address
 |  |  |  |  |  |  |  |  |  |  |  | materials order form
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | required output
 | 8 |  |  |  | ref |  |  | qty |  | description |  |  |  |  | price |  | order |  | total
 | 1 |  |  |  | 1 |  |  | 1 |  | item 1 |  |  |  |  | 1 |  | 1 |  | 1
 | 2 |  |  |  | 2 |  |  | 2 |  | item 2 |  |  |  |  | 2 |  | 2 |  | 2
 | 3 |  |  |  | 3 |  |  | 3 |  | item 3 |  |  |  |  | 3 |  | 3 |  | 3
 | 4 |  |  |  | 4 |  |  | 4 |  | item 4 |  |  |  |  | 4 |  | 4 |  | 4
 | 5 |  |  |  | 5 |  |  | 5 |  | item 5 |  |  |  |  | 5 |  | 5 |  | 5
 | 6 |  |  |  | 10 |  |  | 10 |  | item 10 |  |  |  |  | 10 |  | 10 |  | 10
 | 7 |  |  |  | 77777 |  |  | 23 |  | other Item 7 |  |  |  |  | 12 |  | 2 |  | 1.043478260869565
 | 8 |  |  |  | 166665 |  |  | 31 |  | other Item 15 |  |  |  |  | 20 |  | 5 |  | 3.225806451612903
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total |  |  |  | 29.26928471248247
Spreadsheet: 268467d1380649105-sum-hours-by-date-tcs-summary-jeff-golf-oeldere-
Sheet: Pivot table

Som van Column1
date | Employee | Totaal
2013-01-24 00:00:00 | 12269 | 10:21:38
 | 15848 | 10:30:36
 | 79279 | 10:29:18
 | 89439 | 10:16:59
 | 89798 | 10:21:50
 | 98064 | 01:38:55
 | 9839 | 10:31:22
Totaal 24-01-2013 |  | 1900-01-02 16:10:38
Eindtotaal |  | 1900-01-02 16:10:38
Spreadsheet: 151536d1334956510-how-to-combine-text-from-several-cells-into-one-sample
Sheet: Sheet1

03021100 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: | MFN duties | 0.00% | 0.00%
 | Salmonidae, excluding livers and roes: Trout (Salmo trutta, Oncorhynchus mykiss, | (Applied)
 | Oncorhynchus clarki, Oncorhynchus aquabonita, Oncorhynchus gilae, Oncorhynchus apache
 | and [NAME]
03021200 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: | MFN duties | 0.00% | 0.00%
 | Salmonidae, excluding livers and roes: Pacific Salmon (Oncorhynchus nerka, Oncorhynchus | (Applied)
 | gorbuscha,Oncorhynchus keta, Oncorhynchus tschawytscha, [NAME],
 | Oncorhynchus masou, and Oncorhynchus rhodurus), Atlantic salmon (Salmo salar) and
 | [NAME] salmon (Hucho hucho)
03021900 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: | MFN duties | 0.00% | 0.00%
 | Salmonidae, excluding livers and roes: Other | (Applied)
03022100 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: | MFN duties | 0.00% | 0.00%
 | Salmonidae, excluding livers and roes: Halibut (Reinhardtius hippoglossoides, [NAME], | (Applied)
 | Hippoglossus stenolepis)
03022200 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: | MFN duties | 0.00% | 0.00%
 | Salmonidae, excluding livers and roes: Plaice (Pleuronectes platessa) | (Applied)
03022300 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: | MFN duties | 0.00% | 0.00%
 | Salmonidae, excluding livers and roes: Sole (Solea spp) | (Applied)
03022900 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: | MFN duties | 0.00% | 0.00%
 | Salmonidae, excluding livers and roes: Other | (Applied)
03023100 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: [NAME] (of | MFN duties | 0.00% | 0.00%
 | the genus Thunnus), skipjack of stripe-bellied bonito Euthynus (Katsuwonus) pelamis), | (Applied)
 | excluding livers and roes: [NAME] or longfinned tunas (Thunnus alalunga)
03023200 | Fish, fresh or chilled, excluding fish fillets and other fish meat of heading 03.04: [NAME] (of | MFN duties | 0.00% | 0.00%
 | the genus Thunnus), skipjack of stripe-bellied bonito Euthynus (Katsuwonus) pelamis), | (Applied)
 | excluding livers and roes: Yellowfin tunas (Thunnus albacares)
Spreadsheet: 726395d1617208770-power-pivot-measure-to-sum-unpivoted-values-inquiry1
Sheet: Data 2

Month | ID | Employee | Earnings | Bonus | Tax
February | 1 | Alp
February |  | Bet
February |  | Cio
February |  | Del
February |  | Eps
February |  | Fal
February |  | Guy
February |  | Hyz
February |  | Isa
February |  | [NAME]