tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25627__1292
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  1292
COMPANY NAME    Marlin Fair Value Co.
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 45036d1243838073-dynamic-vlookup-dynamic-lookup-index-match
Sheet: Data

Metric | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Scorecard | 15 | 45 | 65 | 70 | 65
KPI's | 20 | 34 | 36 | 40 | 37
KRA's | 34 | 40 | 42 | 45 | 40
Market Intelligence | 21 | 25 | 28 | 32 | 30
Spreadsheet: 114374d1310119695-updating-indirect-with-closed-workbook-brianformulas
Sheet: Summary

Summary
may
US Dollar cash balance:
Ending balance
Jan
Feb
March
April
May
June
July
Spreadsheet: 2047a074-374d-4a16-916f-3e82e3d8267e
Sheet: At A Glance Sources

[NAME]: A Decade in Review Target Breakdown by Focus Area Pennsylvania
 | Number of objectives that:
Focus Area | Met or exceeded target | Moved toward target | Exhibited no change | Moved away from target | Total number of objectives*
1. Access to Quality Health Services |  | 2 | 1 | 2 | 5
2. Arthritis, Osteoporosis and Chronic Back Conditions | 2 | 2 |  | 3 | 7
3. Cancer | 5 | 7 |  | 2 | 14
4. Chronic Kidney Disease |  | 1 |  | 2 | 3
5. Diabetes | 2 | 2 |  | 3 | 7
6. Disability and Secondary Conditions |  |  | 1 |  | 1
7. Educational and Community-Based Programs | 1 |  |  | 1 | 2
8. Environmental Health | 3 |  |  |  | 3
9. Family Planning | 1 |  |  |  | 1
10. Food Safety | 1 | 2 |  | 2 | 5
11. Health Communication |  | 1 |  |  | 1
12. Heart Disease and Stroke | 5 | 1 |  | 1 | 7
13. HIV | 4 | 2 |  | 1 | 7
14. Immunization and Infectious Diseases | 14 | 6 | 1 | 1 | 22
15. Injury and Violence Prevention | 5 | 10 | 2 | 5 | 22
16. Maternal, Infant and Child Health | 4 | 13 | 1 | 12 | 30
18. Mental Health and Mental Disorders |  |  | 1 |  | 1
19. Nutrition and Overweight |  | 2 |  | 2 | 4
20. Occupational Safety and Health | 2 | 1 |  | 2 | 5
21. Oral Health | 3 | 2 | 1 | 1 | 7
22. Physical Activity and Fitness | 1 | 1 |  | 1 | 3
23. Public Health Infrastructure | 3 | 1 |  |  | 4
24. [NAME] | 1 | 4 |  | 2 | 7
25. [NAME] |  | 2 |  | 3 | 5
26. Substance Abuse | 3 | 12 | 2 | 2 | 19
27. Tobacco Use | 2 | 11 | 2 | 3 | 18
28. Vision and Hearing | 1 |  |  |  | 1
Total | 63 (29.9%) | 85 (40.3%) | 12 (5.7%) | 51 (24.2%) | 211
* Limited to HP2010 objectives for which Pennsylvania data were available.
Spreadsheet: 887029d1737115410-formula-required-for-calculating-who-sits-with-who-at-multiple-tables-table-seating
Sheet: Sheet1

There are two tables, the data below shows who sat at which table each week
 | Which table
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5
 | [NAME] | 1 | 2 | 1 | 1 | 2
 | Debbie | 2 | 1 | 1 | 2 | 2
 | [NAME] | 1 | 1 | 2 | 1 | 1
 | Mark | 2 | 2 | 2 | 2 | 1
Using the countif function it is possible to see how many times each person has sat at each table
 | How many times at each table
 |  | Table 1 | Table 2
 | [NAME]
 | Debbie
 | [NAME]
 | Mark
How am I able to calculate who has sat with each other person in total, (for example, how many times has [NAME] sat at the same table as Debbie)?
 | How many times sat with each other
 |  | [NAME] | Debbie | [NAME] | Mark
 | [NAME] | x
 | Debbie |  | x
 | [NAME] |  |  | x
 | Mark |  |  |  | x
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Oct2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-10-01 00:00:00
2021-10-02 00:00:00
2021-10-03 00:00:00
2021-10-04 00:00:00
2021-10-05 00:00:00
2021-10-06 00:00:00
2021-10-07 00:00:00
2021-10-08 00:00:00
2021-10-09 00:00:00
2021-10-10 00:00:00
2021-10-11 00:00:00
2021-10-12 00:00:00
2021-10-13 00:00:00
2021-10-14 00:00:00
2021-10-15 00:00:00
2021-10-16 00:00:00
2021-10-17 00:00:00
2021-10-18 00:00:00
2021-10-19 00:00:00
2021-10-20 00:00:00
2021-10-21 00:00:00
2021-10-22 00:00:00
2021-10-23 00:00:00
2021-10-24 00:00:00
2021-10-25 00:00:00
2021-10-26 00:00:00
2021-10-27 00:00:00
2021-10-28 00:00:00
2021-10-29 00:00:00
2021-10-30 00:00:00
2021-10-31 00:00:00
Totals:
Spreadsheet: mark_taylor__24765__105657 - O&M Report
Sheet: 105657 - HC

 | ENRON NORTH AMERICA
 | CC 105657
 | HEADCOUNT AS OF 04-30-01
EMPLOYEE |  |  | TOTAL
BAILEY,[NAME] |  | hOther Non-Commercial | 1
[NAME], SAMANTHA |  | hOther Non-Commercial | 1
BRUCE, ROBERT |  | hOther Non-Commercial | 1
COOK, MARY |  | hOther Non-Commercial | 1
ELLIS,REGINA K |  | hOther Non-Commercial | 1
GONZALEZ, ESMERALDA |  | hOther Non-Commercial | 1
GREENBERG, MARK |  | hOther Non-Commercial | 1
HENDRY, BRENT |  | hOther Non-Commercial | 1
JONES,TANA L |  | hOther Non-Commercial | 1
KEISER, HOLLY |  | hOther Non-Commercial | 1
KOEHLER, ANNE |  | hOther Non-Commercial | 1
MILLIGAN, TAFFY |  | hOther Non-Commercial | 1
NELSON, CHERYL |  | hOther Non-Commercial | 1
PANUS, STEPHANIE |  | hOther Non-Commercial | 1
PINTO-LEITE, FRANCISCO |  | hOther Non-Commercial | 1
SAYRE, FRANK |  | hOther Non-Commercial | 1
SHACKLETON,SARA |  | hOther Non-Commercial | 1
ST. CLAIR,CAROL L |  | hOther Non-Commercial | 1
TAYLOR,MARK E |  | hOther Non-Commercial | 1
ZUCHA, THERESA |  | hOther Non-Commercial | 1
Spreadsheet: louise_kitchen__22536__Gas List
Sheet: Personnel Detail 

GROUP |  | DESKS NEEDED
[NAME]
Central - Logistics |  | 10
[NAME]
[NAME]
[NAME]
[NAME] Haynes
[NAME]
[NAME]
Margie Straight
[NAME]
[NAME]
[NAME]
Management - Logistics |  | 2
[NAME]
[NAME]
Northeast and Southeast - Logistics |  | 10
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Meredith Homco
[NAME]
[NAME]
[NAME]
[NAME]
Texas - Logistics |  | 1
[NAME]
Upstream Desk - Logistics |  | 4
[NAME]
[NAME]
[NAME]
[NAME]
West - Logistics |  | 9
[NAME]
[NAME]
Jan Sutherland
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Subtotal for Logistics
RISK MANAGEMENT
Risk Management |  | 16
[NAME]
[NAME]
Anne Bike
Bradley Jones
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Subtotal for Risk Management
TRADING DESKS
Enron Wholesale Executive Office |  | 1
[NAME]
Central - Traders |  | 8
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Patrice Mims
[NAME]
East - Traders |  | 6
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Financial - Traders |  | 6
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] May
[NAME]
Middle Market - Traders |  | 5
[NAME]
Personnel
Personnel
Personnel
Personnel
Texas - Traders |  | 6
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
West - Traders |  | 6
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Subtotal for Trading Desks
ADMINISTRATIVE SUPPORT
Administrative Support |  | 7
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], C.P.S.
Subtotal for Administrative Support |  | 7
TOTAL DESKS NEEDED
Spreadsheet: 212072d1360023244-how-to-auto-populate-one-cell-based-on-the-selections-of-two-drop-downs-try5-oeldere4-
Sheet: Invoice Camper Trailers 

TAX INVOICE |  |  |  |  | No. | 1320
Customer Name: |  |  |  |  |  | Date:
Address:
Suburb: |  |  |  | State: |  | P/Code:
[NAME]:
 |  | Become a member for free & be updated with camping information & special offers.
QTY | Description |  |  |  |  | Unit Price | Subtotal
1 | Sandpiper
1 | ST09KSL
Required Deposit
GST incl
Total
Trailer No:
VIN Number:
Payment Type: |  | VISA
Spreadsheet: 821571d1678800090-methods-to-find-unique-id-and-list-shared-users-with-each-id-peers2
Sheet: Sheet1

 |  |  |  |  | New User |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | User | Old Peers | CNU | GMU | JMU | LU | NSU | ODU | RU | UMW | UVA | UVAW | VCU | VMI | VSU | VT | WM | RBC | new users
 |  |  | CNU | 8 |  |  |  | 2 | 5 |  | 2 | 2 |  |  |  | 1
 |  |  | GMU
 |  |  | JMU
 |  |  | LU | 5 |  |  |  |  | 4 |  | 2 | 1 |  |  |  | 1
 |  |  | NSU
 |  |  | ODU
 |  |  | RU
 |  |  | UMW
 |  |  | UVA
 |  |  | UVAW
 |  |  | VCU
 |  |  | VMI
 |  |  | VSU
 |  |  | VT
 |  |  | WM
 |  |  | RBC
Spreadsheet: 122269d1316704902-excel-2007-vlookup-question-examplespreadsheet_revised
Sheet: SurplusBal

Name | AcctNbr | SurplusBal
Customer 4 | 456789 | 95.83
Customer 5 | 222222 | 249.79
Customer 8 | 444444 | 0.06
Customer 9 | 555555 | 114.12
Customer 10 | 666666 | 52.86
Customer 11 | 777777 | 106.39
Customer 12 | 888888 | 1517.8
Customer 13 | 999999 | 58.13
Customer 14 | 111222 | 59.61
Customer 15 | 111555 | 59.21
Spreadsheet: 182325d1348427007-how-to-calculate-totals-by-page-break-when-printing-forum-sample
Sheet: Sheet1

State | Customer | Code | 2012-09-01 00:00:00 | 2012-09-02 00:00:00 | 2012-09-03 00:00:00 | 2012-09-04 00:00:00 | 2012-09-05 00:00:00 | 2012-09-06 00:00:00 | 2012-09-07 00:00:00 | 2012-09-08 00:00:00 | 2012-09-09 00:00:00 | 2012-09-10 00:00:00 | Totals
AL | a | 5xxx | x | x |  | x | x |  | x | x |  | x
 | b | 3xxx | x | x | x | x | x | x | x | x | x | x
 | c | 1xxx | x | x |  | x | x |  | x | x |  | x
 | d | 5xxx |  | x | x |  | x | x |  | x | x | x
 | e | 3xxx |  | x | x |  | x | x |  | x | x | x
 | f | 1xxx |  | x | x |  | x | x |  | x | x | x
 | g | 5xxx | x | x |  | x | x |  | x | x |  | x
 | h | 3xxx |  | x | x |  | x | x |  | x | x | x
 | i | 1xxx |  | x | x |  | x | x |  | x | x | x
 | j | 5xxx |  | x | x |  | x | x |  | x | x | x
 | k | 3xxx | x | x | x | x | x | x | x | x | x | x
 | l | 1xxx |  | x | x |  | x | x |  | x | x | x
 | m | 5xxx |  | x |  |  | x |  |  | x |  | x
AL Total
NC | a | 5xxx |  | x | x |  | x | x |  | x | x | x
 | b | 3xxx |  | x | x |  | x | x |  | x | x | x
 | c | 1xxx | x | x | x | x | x | x | x | x | x | x
 | d | 5xxx |  | x |  |  | x |  |  | x |  | x
 | e | 3xxx |  | x | x |  | x | x |  | x | x | x
 | f | 1xxx |  | x |  |  | x |  |  | x |  | x
 | g | 5xxx |  | x |  |  | x |  |  | x |  | x
 | h | 3xxx |  | x |  |  | x |  |  | x |  | x
 | i | 1xxx |  | x |  |  | x |  |  | x |  | x
 | j | 5xxx | x | x |  | x | x |  | x | x |  | x
 | k | 3xxx |  | x |  |  | x |  |  | x |  | x
 | l | 1xxx |  | x |  |  | x |  |  | x |  | x
 | m | 5xxx |  | x |  |  | x |  |  | x |  | x
NC Total
TN | a | 5xxx |  | x |  |  | x |  |  | x |  | x
 | b | 3xxx |  | x | x |  | x | x |  | x | x | x
 | c | 1xxx |  | x | x |  | x | x |  | x | x | x
 | d | 5xxx | x | x | x | x | x | x | x | x | x | x
 | e | 3xxx |  | x | x |  | x | x |  | x | x | x
 | f | 1xxx |  | x | x |  | x | x |  | x | x | x
 | g | 5xxx |  | x | x |  | x | x |  | x | x | x
 | h | 3xxx | x | x | x | x | x | x | x | x | x | x
 | i | 1xxx |  | x |  |  | x |  |  | x |  | x
 | j | 5xxx |  | x |  |  | x |  |  | x |  | x
 | k | 3xxx |  | x |  |  | x |  |  | x |  | x
 | l | 1xxx | x | x |  | x | x |  | x | x |  | x
 | m | 5xxx |  | x |  |  | x |  |  | x |  | x
 | n | 5xxx |  | x |  |  | x |  |  | x |  | x
 | o | 3xxx |  | x |  |  | x |  |  | x |  | x
 | p | 1xxx |  | x |  |  | x |  |  | x |  | x
 | q | 5xxx | x | x |  | x | x |  | x | x |  | x
 | r | 3xxx |  | x |  |  | x |  |  | x |  | x
TN Total
Grand Total
Total Orders |  | 5
by Code |  | 3
 |  | 1
Grand Total Orders
Spreadsheet: 768750d1645107964-lookup-results-are-coming-up-offset-samplelookup
Sheet: Class Key

Class | Class Description
A01 | Square Sponge Gaskets
A02 | [NAME]
A03 | Multiseal Gaskets
B01 | Tubular Pail Gaskets
B02 | Drum Dollies
B03 | Drum Racks
B04 | Drum Stands
C01 | Drum Grabber Fork Lift
C02 | Steel Pails
C03 | Steel Reconditioned Drums
C05 | Steel Drums
C06 | Plastic Drums
C07 | [NAME]
C08 | Composite Drums
C09 | Mil-Spec Drums
C10 | Plastic Reconditioned Drums
C12 | Stainless Steel Drums
C15 | Metal Cans
C16 | Plastic Cans
C17 | Slip Cover Cans
C18 | 4G Combination Packaging
C19 | Decorated Cans
C20 | Cubitainers
C22 | Hedpaks
C25 | Winpaks
C26 | Plastic Bottles
C27 | [NAME]
C28 | Small Pack Dispensers
Spreadsheet: 89766d1289504540-converting-time-to-hours-and-minutes-comp-form-fy-2011
Sheet: Nov

Comp Time Form
 | Name : |  |  | Month: | November 2010
 | Title:
 | Earned/Taken  E or T | Date Earned/Taken | Activity | Director [NAME] | Time Worked | Time Granted      (@ time & 1/2) | Time Used | Time Available
 | E |  | Forwarded from Previous Month
 |  |  |  | Sub Totals
Spreadsheet: 105507af-b7b6-4ab9-a12e-8492b32af570
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  | FORM C
المثال جيم
[NAME]
نموذج الابلاغ عن النقل الجوي
الحركة حسب [NAME] (TFS)
الخدمات المنتظمة (الايرادية) - العمليات الدولية
[NAME]: | [NAME] |  |  |  |  | الدولة: | ABC
المنظمة: | MNOP |  |  |  |  | شركة الطيران: | ABC Airways
الهاتف: | (2) 456-7891 |  |  |  |  | السنة: |  | 2000
[NAME]: | (2) 456-7893
البريد الالكتروني: | [EMAIL]
المحطات |  |  |  | [NAME] |  | الحركة الايرادية
 |  |  |  |  | إجمالي
 |  |  |  | مقاعد | سعة | الركاب | الشحن | البريد
 |  |  |  | الركاب | الحمولة | (العدد) | (أطنان) | (أطنان)
من | To | نوع الطائرة | عدد الرحلات | (العدد) | (أطنان)
(أ) | (ب) | (ج) | (د) | (ﻫ) | (و) | (ز) | (ح) | (ط)
ATH | PAR | AB3 | 105 | 26 250 | 31 600 | 16 800 | 370 | 15
ATH | PAR | 727 | 212 | 31 378 | 3 540 | 21 965 | 141 | 39
PAR | LON | AB3 | 105 | 26 250 | 31 600 | 16 800 | 229 | 6
PAR | LON | 727 | 212 | 31 378 | 3 540 | 21 965 | 87 | 16
LON | PAR | AB3 | 105 | 26 250 | 31 600 | 16 800 | 2221 | 3
LON | PAR | 727 | 212 | 31 378 | 3 540 | 21 965 | 84 | 8
PAR | ATH | AB3 | 105 | 26 250 | 31 600 | 16 800 | 369 | 6
PAR | ATH | 727 | 212 | 31 378 | 3 540 | 21 965 | 140 | 16
PAR | NYC | 747 | 98 | 35 392 | 7 644 | 24 774 | 82 | 13
NYC | PAR | 747 | 98 | 35 392 | 7 644 | 24 774 | 120 | 23
الملاحظات (بما في [NAME] أي حيود عن تعليمات الابلاغ) لا يمكن تفاديه :
[NAME] صفحات إضافية حسب الاقتضاء.
Spreadsheet: 457025d1461168303-formula-ending-when-cell-is-blank-formula-test-file
Sheet: Sheet1

 |  |  |  |  |  | Current formula result |  | How I would like the result to be
[NAME] | [NAME] | [NAME] |  |  |  |  |  | [NAME]
[NAME] | Sara | [NAME] | Scott |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  | [NAME]
Spreadsheet: 696855d1601010347-distinct-list-of-dates-from-the-large-list-based-on-criteria-uniquedate_chris1
Sheet: Sheet1

Dates | DateList |  | Unique distinct list |  | Start date: | 2009-01-10 00:00:00
2009-01-04 00:00:00 |  |  |  |  | End date: | 2009-01-18 00:00:00
2009-01-05 00:00:00
2009-01-08 00:00:00
2009-01-10 00:00:00
2009-01-12 00:00:00
2009-01-16 00:00:00
2009-01-17 00:00:00
2009-01-18 00:00:00
2009-01-19 00:00:00
2009-01-19 00:00:00
2009-01-23 00:00:00
2009-01-23 00:00:00
2009-01-27 00:00:00 |  |  |  | Array | =IFERROR(INDEX($A$2:$A$18, MATCH(0, COUNTIF(C$1:$C1,$A$2:$A$18) + (COUNTIF($A$2:$A$18, $A$2:$A$18)<>1), 0)), "")
2009-01-27 00:00:00 |  |  |  | Non-Array | =IFERROR(INDEX($A$2:$A$18, MATCH(0,INDEX(COUNTIF($D$1:D1, $A$2:$A$18)+(COUNTIF($A$2:$A$108, $A$2:$A$18)<>1),0,0), 0)), "")
2009-01-27 00:00:00
2009-01-27 00:00:00
2009-01-28 00:00:00
Spreadsheet: louise_kitchen__23042__AAearn by month
Sheet: Earnings By Month

E N R O N   N O R T H  A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1Q 2001
1999-2001 Margin From DPR
in Millions of $
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | 1999-01-01 00:00:00 | 1999-02-01 00:00:00 | 1999-03-01 00:00:00 | 1999-04-01 00:00:00 | 1999-05-01 00:00:00 | 1999-06-01 00:00:00 | 1999-07-01 00:00:00 | 1999-08-01 00:00:00 | 1999-09-01 00:00:00 | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | 2000-07-01 00:00:00 | 2000-08-01 00:00:00 | 2000-09-01 00:00:00 | 2000-10-01 00:00:00 | 2000-11-01 00:00:00 | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | Margin
Margin
Gas Trading |  |  |  |  |  |  |  |  | 17.6 | 46.8 |  |  |  |  |  |  | 234
Power Trading |  |  |  |  |  | 34.6 |  |  | 36.7 | 7 |  |  |  |  |  |  | 59.5
Other Trading |  |  |  |  |  | 6.1 |  |  |  | 7.6 |  |  |  |  |  |  | 13.4
Peakers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0
Originations/Office of the Chair/Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MPR |  |  |  |  |  | 1.4 |  |  |  | -17.8 |  |  | -10.6 |  |  | -30.5 | 0.5 |  | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
Total Margin
Numbers from 01/99-10/2000 are off the DPR.  From 11/2000 forward, the numbers are off the Management Summary.
Spreadsheet: 695680d1600341141-merging-data-by-using-unique-reference-in-excel-fund-performance
Sheet: Sheet1

Inv Ref | Total Contribution | Units | Unit price | Current Value | Gains or Losses
EXA001 | 100000 | 1000 |  | 135448
EXA002 | 112000 |  |  | 135448
EXA003 | 124000 |  |  | 135448
EXA004 | 136000 |  |  | 135448
EXA005 | 148000 |  |  | 135448
EXA006 | 160000 |  |  | 135448
EXA007 | 172000 |  |  | 135448
EXA008 | 184000 |  |  | 135448
EXA009 | 196000 |  |  | 135448
EXA010 | 208000 |  |  | 135448
EXA011 | 220000 |  |  | 135448
EXA012 | 232000 |  |  | 135448
EXA013 | 244000 |  |  | 135448
EXA014 | 256000 |  |  | 135448
EXA015 | 268000 |  |  | 135448
EXA016 | 280000 |  |  | 135448
EXA017 | 292000 |  |  | 135448
EXA018 | 304000 |  |  | 135448
EXA019 | 316000 |  |  | 135448
EXA020 | 328000 |  |  | 135448
EXA021 | 340000 |  |  | 135448
EXA022 | 352000 |  |  | 135448
EXA023 | 364000 |  |  | 135448
EXA024 | 376000 |  |  | 135448
EXA025 | 388000 |  |  | 135448
EXA026 | 400000 |  |  | 135448
EXA027 | 412000 |  |  | 135448
EXA028 | 424000 |  |  | 135448
EXA029 | 436000 |  |  | 135448
EXA030 | 448000 |  |  | 135448
Spreadsheet: 174497d1345074886-excel-2010-help-with-a-if-formula-and-multiple-conditions-test
Sheet: Sheet1

Sched Start Date | Actual Start Date | Sched Finish Date | Completion | Status | Dates | Delivery
2012-08-09 00:00:00 | 2012-08-09 00:00:00 | 2012-08-14 00:00:00 |  | Completion Overdue
2012-08-04 00:00:00 | 2012-08-04 00:00:00 | 2012-08-25 00:00:00 |  | Tracking
2012-08-04 00:00:00 | 2012-08-09 00:00:00 | 2012-08-15 00:00:00 |  | Mssed Start
2012-08-04 00:00:00 | 2012-08-09 00:00:00 |  | No Date Set | No Date Set
2012-08-04 00:00:00 |  | 2012-08-15 00:00:00 |  | Failed
Spreadsheet: 055ed296-113a-4595-b20a-25c35e6da01a
Sheet: Sheet1

OSSTF JOB EVALUATION SCHEDULE | Unnamed: 1 | Unnamed: 2
DEADLINE DATE (Approved and Signed Job Description Received in HR) | Date of Job Evaluation by Committee | Date Employee Advised of Outcome
2015-01-06 00:00:00 | January 27, 2015, 9:00 a.m. | 2015-02-06 00:00:00
2015-02-03 00:00:00 | February 24, 2015, 9:00 a.m. | 2015-03-06 00:00:00
2015-03-03 00:00:00 | March 24, 2014, 9:00 a.m. | 2015-04-03 00:00:00
2015-04-07 00:00:00 | April 28, 2015, 9:00 a.m. | 2015-05-08 00:00:00
2015-05-05 00:00:00 | May 26, 2015, 9:00 a.m. | 2015-06-05 00:00:00
2015-06-02 00:00:00 | June 23, 2015, 9:00 a.m. | 2015-07-03 00:00:00
2015-07-07 00:00:00 | July 28, 2015, 9:00 a.m. | 2015-08-07 00:00:00
2015-09-01 00:00:00 | September 22, 2015, 9:00 a.m. | 2015-10-02 00:00:00
2015-10-06 00:00:00 | October 27, 2015, 9:00 a.m. | 2015-11-06 00:00:00
2015-11-03 00:00:00 | November 24, 2015, 9:00 a.m. | 2015-12-04 00:00:00
2015-12-01 00:00:00 | December 22, 2015, 9:00 a.m. | 2016-01-09 00:00:00
ADMIN/PROFESSIONAL & EXEMPT JOB EVALUATION SCHEDULE
DEADLINE DATE (Approved and Signed Job Description Received in HR) | Date of Job Evaluation by Committee | Date Employee Advised of Outcome
2014-12-16 00:00:00 | January 15, 2015, 9:00 a.m. | 2015-01-26 00:00:00
2015-01-29 00:00:00 | February 19, 2015, 9:00 a.m. | 2015-03-02 00:00:00
2015-02-26 00:00:00 | March 19, 2015, 9:00 a.m. | 2015-03-30 00:00:00
2015-03-26 00:00:00 | April 16, 2015, 9:00 a.m. | 2015-04-27 00:00:00
2015-04-30 00:00:00 | May 21, 2015, 9:00 a.m. | 2015-06-01 00:00:00
2015-05-28 00:00:00 | June 18, 2015, 9:00 a.m. | 2015-06-29 00:00:00
2015-06-25 00:00:00 | July 16, 2015, 9:00 a.m. | 2015-07-27 00:00:00
2015-08-27 00:00:00 | September 17, 2015, 9:00 a.m. | 2015-09-28 00:00:00
2015-09-24 00:00:00 | October 15, 2015, 9:00 a.m. | 2015-10-26 00:00:00
2015-10-29 00:00:00 | November 19, 2015, 9:00 a.m. | 2015-11-30 00:00:00
2015-11-26 00:00:00 | December 17, 2015, 9:00 a.m. | 2016-01-06 00:00:00
Spreadsheet: 833397d1686933586-the-sum-of-rounded-cells-do-not-equal-original-total-sample-33-
Sheet: Sheet1

 | New Numbers: Press F9
 | Numbers unrounded |  | Numbers rounded |  | Difference
TOTAL
Spreadsheet: 796695d1663440596-how-to-display-a-result-if-all-the-data-in-a-row-from-table1-and-table2-match-s666-pq-display-a-result-if-all-the-data-in-a-row-from-table1-and-table2-match
Sheet: Feuil1

Branche | Ex1 | Ex2 | Ex3 | Table 1 | Ex1 | Ex2 | Ex3 | Table 2 | Branche | Ex1 | Ex2 | Ex3
 | 1 | 18 | 23 |  | 12 | 20 | 20 |  |  | 1 | 18 | 23
 | 14 | 22 | 28 |  | 4 | 4 | 4 |  |  | 14 | 22 | 28
 | 1 | 18 | 12 |  | 1 | 18 | 12 |  | BR | 1 | 18 | 12
 | 0 | 0 | 0 |  | 12 | 2 | 2 |  |  | 0 | 0 | 0
Expected results
Branche | Ex1 | Ex2 | Ex3 | Table3
 | 1 | 18 | 23
 | 14 | 22 | 28
BR | 1 | 18 | 12
 | 0 | 0 | 0
Spreadsheet: 115295d1310951099-pivot-table-and-chart-assistance-help-fabricator-status
Sheet: Supplier Delivery Status

Supplier | Package Name | PO No. | PO Date | Promised Delivery Date | Actual Delivery Dates | Delivery On-Time or Late | Comment
Perth Cutting | Supply and fabricate as per Quote Number 33011 | 69789 | 2011-05-01 00:00:00 | 2011-05-15 00:00:00 | 2011-05-13 00:00:00 | 2
SPM | Supply End Brackets | 78332 | 2011-06-02 00:00:00 | 2011-06-12 00:00:00 | 2011-06-23 00:00:00 | -11
Kimono | Supply flange | 44352 | 2011-05-04 00:00:00 | 2011-05-10 00:00:00 | 2011-05-05 00:00:00 | 5
Perth Cutting | Supply and fabricate as per Quote Number 33011 | 55533 | 2011-06-04 00:00:00 | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | -5
Perth Cutting | Supply and fabricate as per Quote Number 33011 | 55533 | 2011-06-04 00:00:00 | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | -5
Perth Cutting | Supply and fabricate as per quote number 22222 | 77675 | 2011-07-05 00:00:00 | 2011-07-13 00:00:00 | 2011-07-15 00:00:00 | -2
Kimono | End bracket supplied | 77743 | 2011-06-23 00:00:00 | 2011-07-01 00:00:00 | 2011-07-01 00:00:00 | 0
Kimono | roll plates | 77763 | 2011-06-25 00:00:00 | 2011-07-05 00:00:00 | 2011-07-03 00:00:00 | 2
Perth Cutting | 12mm plate | 77624 | 2011-06-27 00:00:00 | 2011-07-07 00:00:00 | 2011-07-14 00:00:00 | -7
Spreadsheet: 93800d1293564339-sumifs-in-only-one-column-sample-mahju
Sheet: Sheet1

Company | Division |  | Jan | Feb | Mar | Apr
10 | 1 |  | 200 | 365 | 521 | 458
10 | 2 |  | 175 | 214 | 478 | 698
10 | 1 |  | 150 | 235 | 963 | 523
10 | 3 |  | 125 | 856 | 236 | 321
10 | 2 |  | 300 | 123 | 145 | 458
10 | 2 |  | 450 | 654 | 563 | 796
20 | 1 |  | 521 | 458 | 200 | 365
20 | 2 |  | 478 | 698 | 175 | 214
20 | 1 |  | 963 | 523 | 150 | 235
20 | 3 |  | 236 | 321 | 125 | 856
20 | 2 |  | 145 | 458 | 300 | 123
20 | 2 |  | 563 | 796 | 450 | 654
 | RESULTS
Enter In Desired Values: | Company | 20 |  | Company | Division
 | Division | 2 |  | 20 | 2
 | Month | Apr
Excel Formula Return: |  | 925 | 991
*Sum of January Sales for Company 10 Division 2*
*Want to be able to change the sum, by simply typing in a new month