tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 798861d1664791023-search-and-count-data-from-different-column-address-checking-1-
Sheet: address

Original Data |  |  | Split data by comma into different columns |  |  |  |  |  |  | Question :How to list Staff ID who address include cell [NAME] and Field B3
Staff ID | Address |  | Address | Address | Address | Address | Address |  |  | Pittsburgh | Teatown Road |  | Fifth | NY 1111
A1 | 3211 Temple Ave, Pomoma, CA 12345, US |  | 3211 Temple Ave | Pomoma | CA 12345 | US |  |  |  | A2 | A3
A2 | 48 Fifth Ave, Pittsburgh, PA 999, US |  | 48 Fifth Ave | Pittsburgh | PA 999 | US |  |  |  | A4 | A5
A3 | 159 Teatown Road, Croton-on-Hudson, NY 1111 |  | 159 Teatown Road | Croton-on-Hudson | NY 1111 |  |  |  |  |  | A6
A4 | 46, Fifth Ave, Pittsburgh, PA 999, US |  | 46 | Fifth Ave | Pittsburgh | PA 999 | US |  |  |  | A7
A5 | 888,  Teatown Road, Croton-on-Hudson, NY 1111 |  | 888 | Teatown Road | Croton-on-Hudson | NY 1111
A6 | 999 Teatown Road, Croton-on-Hudson, NY 1111 |  | 999 Teatown Road | Croton-on-Hudson | NY 1111
A7 | 333,  Teatown Road, Croton-on-Hudson, NY 1111 |  | 333 | Teatown Road | Croton-on-Hudson | NY 1111
Spreadsheet: 594512d1539802814-time-calculations-xlf20181017-outgoing_forbdd2015_as
Sheet: Outgoing

Scheduled Departure | Actual Departure | Sched.Dep. | Act.Dep. | Time Difference
10/10/2018 07:55
10/10/2018 08:15
10/10/2018 10:30
10/09/2018 22:30 | 10/09/2018 22:26
10/10/2018 05:55 | 10/10/2018 06:02
10/10/2018 06:00 | 10/10/2018 05:30
10/10/2018 01:00 | 10/10/2018 01:00
10/10/2018 02:45 | 10/10/2018 02:15
10/10/2018 06:00 | 10/10/2018 06:00
10/10/2018 06:00 | 10/10/2018 05:55
10/10/2018 08:00 | 10/10/2018 06:35
10/09/2018 23:45 | 10/10/2018 00:04
10/10/2018 03:30 | 10/10/2018 03:15
10/09/2018 20:00 | 10/09/2018 19:44
10/10/2018 03:30 | 10/10/2018 03:29
10/10/2018 06:00 | 10/10/2018 05:45
10/10/2018 06:00 | 10/10/2018 05:45
10/10/2018 03:30 | 10/10/2018 03:20
10/10/2018 05:45 | 10/10/2018 05:30
10/10/2018 06:15 | 10/10/2018 06:00
10/10/2018 06:15 | 10/10/2018 06:00
10/09/2018 21:00 | 10/09/2018 20:52
10/10/2018 00:30 | 10/10/2018 00:25
10/10/2018 03:30 | 10/10/2018 03:15
10/09/2018 22:00 | 10/09/2018 21:59
10/10/2018 02:30 | 10/10/2018 02:15
10/10/2018 06:00 | 10/10/2018 05:45
10/10/2018 06:00 | 10/10/2018 05:55
10/10/2018 03:00 | 10/10/2018 03:00
10/10/2018 00:35 | 10/10/2018 00:25
10/10/2018 06:00 | 10/10/2018 06:09
10/09/2018 21:00 | 10/09/2018 20:59
10/09/2018 22:00 | 10/09/2018 22:06
10/10/2018 03:30 | 10/10/2018 03:15
10/10/2018 04:30 | 10/10/2018 04:29
10/10/2018 05:00 | 10/10/2018 04:45
10/10/2018 03:30 | 10/10/2018 03:15
10/09/2018 22:00 | 10/09/2018 22:10
10/09/2018 22:30 | 10/09/2018 22:30
10/10/2018 05:30 | 10/10/2018 05:29
10/10/2018 02:30 | 10/10/2018 02:15
Spreadsheet: 200620d1355680800-multiple-criteria-matching-example2-bobby_712-oeldere-
Sheet: Payout Matrix

Commission Payout Chart
10 | = base commission rate
0.002 | = Increment |  |  |  |  |  |  |  |  |  |  |  | Sales Growth | GP Growth
0.1 | = Increcemental commission rate |  |  |  |  |  |  |  |  |  |  |  | 1.13 | B
Sales $ as a percent of Sales Target |  |  |  |  |  | =GP% target |  |  |  |  |  |  |  | RESULT
 |  |  |  |  |  | 0
 | A | B | C | D | E | F | G | H | I | J | K
1.25
1.24
1.23
1.22
1.21
1.2
1.19
1.18
1.17
1.16
1.15
1.14
1.13
1.12
1.11
1.1
1.09
1.08
1.07
1.06
1.05
1.04
1.03
1.02
1.01
1
0.99
0.98
0.97
0.96
0.95
0.94
0.93
0.92
0.91
0.9
 |  |  |  |  | Gross Profit Percent (%)
Spreadsheet: 868306d1715027730-validating-2-lists-if-row-info-matches-add-specific-text-in-new-column-on-same-row-book1
Sheet: Sheet1

Employee | Dept | Weekly | Item |  |  | Employee | Team
[NAME] | x | x | x |  |  | [NAME] | Red
[NAME] | x | x | x |  |  | [NAME] | Green
[NAME] | x | x | x |  |  | [NAME] | Blue
Sara | x | x | x |  |  | Sara | Red
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
Employee | Dept | Weekly | Item | Team
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
Sara | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
[NAME] | x | x | x
Spreadsheet: 330515d1404772135-summing-across-multiple-sheets-by-specific-name-vlookup-june_template-trivia-scorecard
Sheet: Cumulative

CUMULATIVE SCORES | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | TOTAL
Stepdads
Danites
[NAME]
Spreadsheet: 769767d1645680405-filter-function-with-scroll-bar-book1
Sheet: Dashboard

 | Trading Portfolio |  |  |  |  |  |  | NIFTY |  |  | SENSEX
 |  | Realised Profit / Loss |  |  |  |  |  |  | Summary |  |  |  |  |  |  | Sectorwise Holding
 |  | Stocks | Quantity | Buy | Sell | Profit / Loss |  |  | Investment:
 |  |  |  |  |  |  |  |  | Networth:
 |  |  |  |  |  |  |  |  |  | Day Loss | (Unrealised):
 |  |  |  |  |  |  |  |  |  | Profit / Loss | (Unrealised):
 |  |  |  |  |  |  |  |  |  | Holding Profit / Loss | (Realised):
 |  |  |  |  |  |  |  |  |  | Overall Profit / Loss | (Realised):
 |  |  |  |  |  |  |  |  | Total Gains |  | t   u | Total Losses
 |  | Holding Stocks
 |  | Stocks | Quantity |  | Investment |  |  |  | Current Market |  |  |  |  |  |  | Unrealised P/L |  | Realised P/L
 |  |  | Total | Long Term | Price | Value |  | % | Price | Value | % | Change | Change % |  | Day Gain | Value | % | Value
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
 |  | #[NAME]!
Spreadsheet: 0f5a5c47-df75-48ae-beaf-639ac0763327
Sheet: Institutional Trends

Percentage of students suspended by institution
 | 2003 - 2004 | 2004-2005 | 2005 -2006 | 2006 - 2007 | 2007-2008 | 2008-2009 | 2009-2010
BHSU | 0.046 | 0.043 | 0.041 | 0.036 | 0.044 | 0.04099999999999999
DSU | 0.014 | 0.019 | 0.02 | 0.018 | 0.015 | 0.019
NSU | 0.022 | 0.026 | 0.026 | 0.022 | 0.021 | 0.017
SDSMT | 0.015 | 0.014 | 0.012 | 0.007 | 0.009 | 0.009
SDSU | 0.018 | 0.016 | 0.014 | 0.018 | 0.015 | 0.017
USD | 0.02 | 0.017 | 0.013 | 0.015 | 0.013 | 0.013
System | 0.023 | 0.021 | 0.018 | 0.019 | 0.018 | 0.019
Percentage of students placed on probation by institution
 | 2003 - 2004 | 2004-2005 | 2005 -2006 | 2006 - 2007 | 2007-2008 | 2008-2009 | 2009-2010
BHSU | 0.095 | 0.092 | 0.086 | 0.079 | 0.073 | 0.07400000000000001
DSU | 0.045 | 0.054 | 0.056 | 0.059 | 0.049 | 0.064
NSU | 0.085 | 0.089 | 0.088 | 0.088 | 0.077 | 0.073
SDSMT | 0.074 | 0.051 | 0.047 | 0.041 | 0.04 | 0.038
SDSU | 0.073 | 0.063 | 0.056 | 0.062 | 0.065 | 0.067
USD | 0.066 | 0.055 | 0.055 | 0.049 | 0.043 | 0.044
System | 0.073 | 0.066 | 0.062 | 0.061 | 0.059 | 0.061
Percentage of students that withdraw by institution
 | 2003 - 2004 | 2004-2005 | 2005 -2006 | 2006 - 2007 | 2007-2008 | 2008-2009 | 2009-2010
BHSU | Data Not Available |  | 0.029 | 0.032 | 0.025 | 0.034
DSU |  |  | 0.024 | 0.024 | 0.024 | 0.023
NSU |  |  | 0.024 | 0.023 | 0.024 | 0.016
SDSMT |  |  | 0.018 | 0.013 | 0.009 | 0.009
SDSU |  |  | 0.015 | 0.013 | 0.017 | 0.013
USD |  |  | 0.009 | 0.015 | 0.022 | 0.019
System |  |  | 0.017 | 0.017 | 0.02 | 0.018
Spreadsheet: 0e0aaa6a-5778-4665-82e8-6946f6dd740d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42966982 | 2014-09-01 00:20:24 | ALLIES | 0 | 3 | 7 | 1024315 | dangie | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42967153 | 2014-09-01 00:36:30 | AXIS | 1 | 7 | 1 | 1024315 | dangie | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
Spreadsheet: 851476d1701706340-filter-with-date-range-selection-date-range
Sheet: Sheet1

 |  |  |  |  | S/N | Vessel | Owners | Charterers | CP Date | Declaration Date
 |  |  |  |  |  | [NAME] | [NAME] | [NAME] | 2024-04-01 00:00:00 | 2024-05-11 00:00:00
 |  |  |  |  |  | [NAME] | aan | aaa | 2024-03-03 00:00:00 | 2024-06-30 00:00:00
 |  |  |  |  |  | [NAME] | [NAME] | Alanannn | 2024-02-03 00:00:00 | 2024-07-18 00:00:00
 |  |  |  |  |  | Finbal | Final | Finally | 2024-03-24 00:00:00 | 2024-05-05 00:00:00
 |  |  |  |  | From | 2024-04-01 00:00:00 |  | Till | 2024-06-01 00:00:00
 |  |  |  |  | S/N | Vessel | Owners | Charterers | CP Date | Declaration Date
 |  |  |  |  |  | Need the formula for data range search, with the outcome search to be on Cell F18 onwards.
Spreadsheet: 46119d1245003818-want-to-automate-the-recording-of-data-from-one-worksheet-to-another-fruitexample
Sheet: Apples

Date | Fruit | Units | Cost
2009-02-17 00:00:00 | Apples | 2 | 14
2009-02-17 00:00:00 | Apples | 4 | 28
2009-02-18 00:00:00 | Apples | 3 | 21
2009-02-19 00:00:00 | Apples | 3 | 21
2009-02-20 00:00:00 | Apples | 5 | 35
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: Credit Suisse 4-17

Current Date
Termination Date
Interest Payment Date
Quarter End Date
Lowest Date
Phantom Stock Hedge |  | Effective Date | 2000-04-17 00:00:00
Credit Suisse |  | Termination Date | 2000-05-08 00:00:00
 |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  |  |  | Total |  |  |  | Total
 |  |  | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  |  |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End
ENE |  |  | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 |  | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 |  | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 |  | Year 2000 |  | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 | 2001-03-31 00:00:00 |  | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 | 2001-06-30 00:00:00 |  | Year 2001 |  | LTD
 | Market Price |  | 76.125
Shares: | 511200
Opening price
Interest Payment Dates |  |  | 2000-05-17 00:00:00 |  |  | 2000-05-17 00:00:00 | 2000-05-17 00:00:00 |  |  | 2000-05-17 00:00:00 | 2000-05-17 00:00:00 |  |  |  |  | 2000-05-17 00:00:00 | 2000-05-17 00:00:00 |  |  | 2000-05-17 00:00:00 | 2000-05-17 00:00:00
Equity Payment (CSFB pays if price goes up/Enron pays if price goes down)
 | Opening value
 | Closing Value
 | MTM
Dividend Payment (CSBI pays)
Expected quarterly dividend |  |  | 0 |  |  | 0.125 |  |  |  | 0.125 |  |  |  |  |  | 0.125 |  |  |  | 0.125
Payment
Interest Payment (Enron pays)
Interest Rate |  |  | 0.062925 |  |  |  | 0.0609 |  |  |  | 0.0609 |  |  |  |  |  | 0.0609 |  |  |  | 0.0609
Spread |  |  | 0.0105 |  |  | 0.0105 | 0.0105 |  |  | 0.0105 | 0.0105 |  |  |  |  | 0.0105 | 0.0105 |  |  | 0.0105 | 0.0105
All in Rate
Annual Day Count |  |  | 365 |  |  | 365 | 365 |  |  | 365 | 365 |  |  |  |  | 365 | 365 |  |  | 365 | 365
Beginning of period
End of period
Day Count
Payment
Net receipt/(payment)
Spreadsheet: 297124d1392295153-sum-duplicate-values-within-an-array-data-123
Sheet: Sheet1

Source |  |  |  | Result |  |  | Result
ID | Name | Sale |  | ID | Sale |  | ID | Sale
1 | [NAME] | 189 |  | 9 | 1661 |  | 9
1 | [NAME] | 782 |  | 1 | 971 |  | 1
4 | [NAME] | 563 |  | 7 | 564 |  | 7
5 | [NAME] | 76 |  | 4 | 563 |  | 4
9 | [NAME] | 899 |  | 8 | 241 |  | 8
8 | [NAME] | 241 |  | 5 | 76 |  | 5
7 | Nick | 564
9 | [NAME] | 762
Spreadsheet: 711658d1609838305-match-row-and-column-and-return-value-example
Sheet: Oversikt 01-2020

 | [NAME] | SLA | VMS | HMS | AMS | SUM | Beskrivelse
 | 2020 | 3461199.178951 | 201700.448209 | 301521.3232099999 | 0 | 3964420.95037 | [NAME] i jan 2020 | [NAME]
 | 2020 | 654215.2378233722 | 22712.16749953388 | 23401.73432969001 | 0 | 700329.1396525961 | [NAME] i jan 2020 (for periode 01-2020) | Inntektsføres
 | 2020 | 329781.7229679754 | 0 | 48929.55129975337 | 0 | 378711.2742677287 | [NAME] i jan 2020 (for periode før 31.12.2019) | Inntektsføres
 | 2019 | 881275.3971605765 | 229798.0632344742 | 300800.7599058413 | 31762.29508196722 | 1443636.515382859 | [NAME] i jan 2020 (for periode 01-2020) | Inntektsføres
 | 2018 | 15144.89704824694 | 7643.126228111123 | 5972.435732868774 | 0 | 28760.45900922684 | [NAME] i jan 2020 (for periode 01-2020) | Inntektsføres
 | 2017 | 34384.1416666667 | 0 | 0 | 0 | 34384.1416666667 | [NAME] i jan 2020 (for periode 01-2020) | Inntektsføres
 |  | 1546397.782284162 | -58452.90875311921 | -77583.15805815347 | -31762.29508196722 | 1378599.420390923
 |  |  |  |  |  | é
 |  |  |  |  |  | [NAME] januar 2020
 | Bokføring 01-2020
 | Beskrivelse | Beløp | D | K | Area | Product
 | Periodisering SLA 01-2020 | 1514635.487202195 | 3911 | 1531 | 110 | 95
 | Periodisering VMS 01-2020 | 58452.90875311921 | 1531 | 3911 | 110 | 80
 | Periodisering HMS 01-2020 | 77583.15805815347 | 1531 | 3911 | 110 | 45
Spreadsheet: 853657d1703582333-search-from-two-sheet-two-different-column-in-two-seach-box-search_revised_hans
Sheet: Step2.1

Search 1 |  | < input field
Search 2 |  | < input field
Search 3 | lumia | < input field |  | words like > |  | watch | 11 | 16 | wat
 |  |  |  | Search1 | Search2 | Search3 |  | 1st Sub | W1 | FM1 | 1st Sub IN | 2nd Sub | 2nd Sub IN | Oqty
Date | Category | [NAME] | TGNo | Party Name | Code | Item Name | Process | IP Length | FW Size | FMC | 1st Part | 2nd Sub | 2nd Sub IN | 2nd Part | HEader18
2023-09-13 00:00:00 | 4C | DC/536 | CS-536 | Microsoft | 61364 | [NAME] |  | ABC | 145 | 90 | 634 |  |  |  | SALMON-50/TC-15 | <Missing
2023-09-13 00:00:00 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75 |  | Shown
 | MCX-3 | AB/663 | MC-34/36 | Microsoft Corp | 9423 | Lumia | DAC | MSC | 36 | 19 | 776 | 36 | LD-45 | 75 |  | <[NAME] by [NAME]
Spreadsheet: 91571d1291280512-lookup-for-specific-values-in-multiple-cells-test
Sheet: Pattern Equipment

Precision Disc Castings LTD |  |  |  |  | Master Information Record
 | Part No. | 12244 |  |  |  | Tooling Ref. | [NAME] |  | Casting Weight |  | Kgs |  |  |  |  | PATT SHOP
 | Customer. |  |  |  |  | Drg/lss.No. |  |  | Casting Wt./Mld |  | Kgs |  |  |  |  | FETT SHOP
 | Material. |  |  |  |  |  |  |  | Yield |  | % |  |  |  |  | CORE SHOP
q | Cust. Spec |  |  |  |  |  |  |  | Castings/Mould
F
[NAME] |  | Equipment |  | AM Number |  | Rack Number |  | Department
 |  |  |  |  |  |  |  | PATT SHOP
PATTERN EQUIPMENT NOTES
qDenotes Customer Significant Characteristic |  |  |  |  |  | pDenotes PDC Significant Characteristic
(WHEN PRINTED) THIS IS AN UNCONTROLLED DOCUMENT
Spreadsheet: 49fe5767-8261-4532-a5ef-ac8167869572
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
FCALP | Test | FCALP | Calprotectin | Calprotectin | Enzyme Linked Immunosorbent Assay (ELISA) | Plastic container: PlCont |  |  | 10 | g | Submit 10 g of random stool. No preservative. Send specimen frozen in a screw-capped, plastic container.   REQUIRED:  Collection date and time | 10 g | Specimens other than	Feces Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; [NAME] OK Lipemia	NA Icteric	NA | < or =50 mcg/g   Test Performed By:  Genova Diagnostics 		       63 Zillicoa Street 		       Asheville, NC  28801-1074 | Monday through Friday | 7 days | 9-11 days | 1 | 83993 |  |  |  |  | Genova Diagnostics
FCALP | [NAME] | FECAL | Fecal |  |  |  | Frozen | 30 days
FCALP | Result | Z0843 | Calprotectin | Calprotectin | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | 38445-3
Spreadsheet: daren_farmer__5724__HPLN0213
Sheet: Sheet1

HPLN0213.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
 |  |  |  |  |  | REVISION #1
SUBJECT:  TXU FUELS NOMINATION - February 13, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-13 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 30 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | 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: 289634d1389639976-pull-data-from-two-different-cells-dedup-data-and-fill-different-tab-sample_file
Sheet: Sheet1

Name Atlanta
Intel
Walmart
Exxon
Vitol
Toyota
Honda
Daimler
ATT |  |  |  |  |  | Name Seattle
Enel |  |  |  |  |  | IBM
Fiat |  |  |  |  |  | Siemens
 |  |  |  |  |  | Nissan
 |  |  |  |  |  | Toyota
 |  |  |  |  |  | Intel
 |  |  |  |  |  | Enel
 |  |  |  |  |  | BMW
 |  |  |  |  |  | Rosneft
 |  |  |  |  |  | Costco
 |  |  |  |  |  | Nestle
Spreadsheet: 883992d1732828509-incremental-cell-references-book1_2
Sheet: Sheet1

DATES | 2023-07-30 00:00:00
WEEK NUMBER
RESULT WANTED | 31
Spreadsheet: 126859d1320009034-transpose-help-please-transpose
Sheet: Sheet1

1320161 | 2068256 | 2078621 | 2078630
2497201 | 2068256 | 2078621 | 2078630
2233635 | 2068256 | 2078621 | 2078630
Spreadsheet: mary_fischer__25628__1473-2001
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 3 MONTHS ENDED 3-31-2001
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 147387d1332777378-formula-for-criteria-in-multiple-columns-
Sheet: Summary

 |  |  | At Fault | Not at Fault
 |  | Before 06:00 | 0.8333333333333334 | 0.1666666666666667
 |  | 06:01 - 09:00 | 0.5 | 0.5
 |  | 09:01 - 11:00 | 0 | 1
 |  | 11:01 - 14:00 | 1 | 0
 |  | 14:01 - 17:00 | 1 | 0
 |  | After 17:01 | 1 | 0
Spreadsheet: 70464d1271199607-conditional-count-sum-for-month-book11
Sheet: Sheet1

2009-11-23 00:00:00 | 385.62
2009-11-24 00:00:00 | 173
2009-11-24 00:00:00
2009-11-24 00:00:00 | 175 |  |  |  |  | # | $
2009-11-30 00:00:00 | 463.83 |  | 11 | 2009 | Nov | 4 | 1197.45
2009-12-04 00:00:00 | 492802.45 |  | 12 | 2009 | Dec | 5 | 502533.1
2009-12-04 00:00:00
2009-12-04 00:00:00 | 5827
2009-12-07 00:00:00 | 3373.03
2009-12-08 00:00:00 | 145
2009-12-10 00:00:00
2009-12-10 00:00:00 | 385.62
Spreadsheet: 47852d1247020357-sorting-non-unique-rows-of-data-into-another-worksheet-example_
Sheet: 110

Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Job Name
01 | ID-2 | GJ | 1/2/2009 |  | 300 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 300 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 234 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 234235 |  | 110
01 | ID-2 | GJ | 1/2/2009 |  | 534 |  | 110
Example of what I want to do but using a function
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: ONT_GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
REGION:  ONTARIO
REGION:  ONTARIO
 |  |  | Total |  | Reclasses |  | June |  | July |  | August |  | September
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  | -148235 | -720238.03 | 3526 | -221994.65 | -1339620
2 |  | Liquidations
3 |  | Interdesk |  |  |  |  |  |  |  |  |  |  | -2576 | -9396
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  |  |  |  |  | 330000 |  | 11000
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  | 183471 |  | -6375
7 |  | Liquidations |  |  |  |  |  |  |  | 0 |  |  |  | 1740993.58
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME] |  |  |  |  |  |  | -13698 | -59997.24 | -211873 | -928003.74
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind |  |  |  |  |  |  | 6723 | 29446.74
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | -1453691 | -6367166.58 | 208347 | 912559.86 | 1342196 | 5878818.48
23 | Fuel: |  |  |  |  |  |  |  | 13698 | 59997.24 | 211873 | 928003.74
 | Transport Expense:
24 |  | Commodity |  |  |  |  |  |  | 3271730.65 | -15338.88 | 0 | 1392796 | 24569.31 | -1190.02
25 |  | Demand |  |  |  |  |  |  |  | -1403140.92 |  | 0
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  | 0 |  |  |  | -4890342
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  | -666007
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM |  |  |  |  | 0 | -126269 | 0 | 385938 | 0 | 0 | 0 | -1740993.58 | 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
 |  | Financial Liquidations |  |  |  |  | 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 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1740994 | 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
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 754370d1636127870-filter-formula-with-and-or-test-fornula-doc
Sheet: Sheet1

Location | User | System 1 | System 2 |  |  |  | Systems | Sys 1 | [NAME] | [NAME]
Loc A | User 1 | Sys 1
[NAME] | User 2 | Sys1 |  |  |  |  |  | User 4 | User 6 | User 6
Loc A (Existing) | User 3 | [NAME] | [NAME] |  |  |  |  | User 5
[NAME] | User 4 | Sys 1 | Sys 1 |  |  |  |  |  |  |  |  |  | =FILTRO(Users[[User]:[User]],NOT(ISERR(SEARCH("Loc A",Users[[Location]:[Location]])))*((Users[[System 1]:[System 1]]=N7)+(Users[[System 2]:[System 2]]=N7)),"No Users")
Loc A | User 5 | Sys 1 |  |  |  | The formula above in row 2 is not pulling the right users. This is what the data should look like.
Loc A | User 6 | [NAME] | [NAME] |  |  |  | Systems | Sys 1 | [NAME] | [NAME] |  | Systems | Sys 1 | [NAME] | [NAME]
 |  |  |  |  |  |  |  | User 1 | User 3 | User 3
 |  |  |  |  |  |  |  | User 5 | User 6 | User 6 |  |  | User 5 | User 6 | User 6
 |  |  |  |  |  | User 4 is showing based on the formula in row 2 but based on my logic only those who are at Loc A and have Sys 1 listed for either system 1 or system 2 should be showing.