tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 490549d1479918659-requesting-some-help-with-regards-to-a-vlookup-formula-sample-sheet
Sheet: Sheet1

Date | Time | Location | Repair | A/B |  |  |  |  |  | 3/20 - 3/22 |  |  | your values
2016-03-17 00:00:00 | 250 | 111 access st | road sign | a |  |  |  | Date Range |  | 2016-03-20 00:00:00 | 2016-03-22 00:00:00
2016-03-17 00:00:00 | 1350 | 3941 adams ave | road sign | a |  |  |  | Number of B's | a |  |  |  | 2
2016-03-19 00:00:00 | 1440 | 218 freedom | road sign | a
2016-03-20 00:00:00 | 1445 | 897 rock well | pavement | a |  |  |  | Number of A's | b |  |  |  | 3
2016-03-21 00:00:00 | 1928 | 2240 steam st | pavement | a
2016-03-22 00:00:00 | 120 | 5992 major st | pavement | b |  |  |  | Time Slots | 0 | 700 |  |  | 2
2016-03-22 00:00:00 | 700 | 4876 arthur st west | road sign | b |  |  |  |  | 701 | 1600 |  |  | 0
2016-03-22 00:00:00 | 1850 | 2401 zebra | pavement | B |  |  |  |  | 1601 | 2400 |  |  | 2
2016-03-22 00:00:00 | 1400 | 111 access st | road sign | B
2016-03-23 00:00:00 | 900 | 3941 adams ave | pavement | A
2016-03-25 00:00:00 | 535 | 3946 adams ave | pavement | A |  |  |  |  |  | with dates | without
2016-03-29 00:00:00 | 1900 | 1119 access st | road sign | A |  |  | ACCESS ST | Road Sign | B |  |  |  | 1
2016-03-29 00:00:00 | 2200 | 2200 adams ave | road sign | B |  |  | ACCESS ST | PAVEMENT | B |  |  |  | 0
 |  |  |  |  |  |  | ADAMS AVE | Road Sign | B |  |  |  | 1
 |  |  |  |  |  |  | ADAMS AVE | PAVEMENT | B |  |  |  | 0
 |  |  |  |  |  |  | ACCESS ST | Road Sign | A |  |  |  | 2
 |  |  |  |  |  |  | ACCESS ST | PAVEMENT | A |  |  |  | 0
 |  |  |  |  |  |  | ADAMS AVE | Road Sign | A |  |  |  | 1
 |  |  |  |  |  |  | ADAMS AVE | PAVEMENT | A |  |  |  | 2
Spreadsheet: 764046d1642542597-order-scheduler-formula-help-required-please-order-schedule-test-jt
Sheet: Summary

WK No: | WK2 |  |  |  | [NAME]
Code: |  | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11 | Product 12 | Product 13 | Product 14 | Product 15 | Product 16 | Product 17 | Product 18 | Product 19 | Product 20 | Product 21 | Product 22 | Product 23 | Product 24 | Product 25 | Product 26
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
 | Order Number
 | Quantity
 | Required By
 | Notes:
 | Other Details
Spreadsheet: 550940d1512622519-extract-unique-values-from-duplicates-with-criteria-a-k_test
Sheet: Sheet 1

Name | Lag Time Behind Last Group | Lag Time >=
 |  | 00:12:00
[NAME] | 00:09:00
[NAME] | 00:11:00
[NAME] | 00:11:00
[NAME] | 00:11:00
[NAME] | 00:13:00
[NAME] | 00:18:00
Doug | 00:09:00
Doug | 00:10:00
Doug | 00:10:00
[NAME] | 00:09:00
[NAME] | 00:13:00
[NAME] | 00:19:00
Ian | 00:09:00
Ian | 00:09:00
Ian | 00:12:00
Trevor | 00:10:00
Trevor | 00:10:00
Trevor | 00:12:00
Trevor | 01:16:00
Spreadsheet: 266457d1379617755-trouble-with-indexing-multiple-criteria-with-a-date-range-travel-template-3
Sheet: Govt Version

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Allowable
 |  |  |  |  |  |  |  |  |  | Calculated |  | Subcontractor Submitted Charges
 |  |  |  |  | Number | Persons | Days |  | Total |  |  | POV |  |  |  |  |  | Airline |  |  |  |  |  |  |  | POV |  |  | Subcontractor
Travel Date |  |  |  | Lodging | of | Per | Per | Lodging | M&IE | PER DIEM |  | [NAME] | POV |  | Hotel |  | Total | Bag | Car | Fuel |  |  | Parking | PER DIEM |  | Mileage | Hotel | TOTAL | Submitted | Total
Start | End | Travel From | Travel To | Timeframe | Trips | Trip | Trip | Days | Days | Lodging | M&IE | Per Trip | Cost | Lodging | Taxes | M&IE | Airfare | Fee | Rental | Cost | Taxi | Misc | Cost | Lodging | M&IE | Cost | Taxes | TRAVEL | Travel Cost | Difference | Explanation
2009-03-16 00:00:00 | 2009-03-18 00:00:00 | Elizabethtown, KY | Washington, DC |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 160 | 243.7 |  | 244.01 | 8
2009-03-16 00:00:00 | 2009-03-19 00:00:00 | Springfield, ME | Alexandria, VA |  | 1 | 1 |  |  |  |  |  |  |  |  |  | 224 | 303.89 |  | 259.72 | 4.75 | 50
2009-04-06 00:00:00 | 2009-04-29 00:00:00 |  | [NAME], CA |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  | 541.5
2009-07-27 00:00:00 | 2009-07-30 00:00:00 | Elizabethtown, KY | Washington, DC |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 322.19 |  |  |  | 75
2008-11-10 00:00:00 | 2008-11-13 00:00:00 | Louisville, KY | Huntsville, AL |  | 1 | 1
2008-11-10 00:00:00 | 2008-11-13 00:00:00 | Dallas, TX | Huntsville, AL |  | 1 | 1
2008-11-10 00:00:00 | 2008-11-11 00:00:00 | Chicago, IL | Huntsville, AL |  | 1 | 1
Spreadsheet: eric_saibi__9727__Market briefs
Sheet: Sheet1

Market Brief | Wednesday, January 9
Stocks | Close | Change | % Change
DJIA | 10094.09 | -56.45999999999913 | -0.005562260173093983
DJ 15 Util. | 291.79 | -0.4599999999999795 | -0.001573994867407971
NASDAQ | 2044.89 | -10.83999999999992 | -0.005273066015478647
S&P 500 | 1155.14 | -5.559999999999945 | -0.004790212802619062
Market Vols | Close | Change | % Change
AMEX (000) | 159248 | 24574 | 0.1824702615204123
NASDAQ (000) | 2303936 | 441395 | 0.236985387167316
NYSE (000) | 1455040 | 212660 | 0.1711714612276437
Commodities | Close | Change | % Change
Crude Oil (Feb) | 20.27 | -0.98 | -0.04611764705882355
Heating Oil (Feb) | 0.54 | -0.02949999999999997 | -0.05179982440737484
Nat. Gas (Henry) | 2.249 | -0.05099999999999971 | -0.02217391304347814
Propane (Feb) | 29 | -1.25 | -0.04132231404958678
Palo Verde (Feb) | 23.5 | -1.25 | -0.0505050505050505
COB (Feb) | 23 | -1.75 | -0.0707070707070707
PJM (Feb) | 25.75 | -1.8 | -0.06533575317604358
Dollar US $ | Close | Change | % Change
Australia $ | 1.905 | -0.002999999999999892 | -0.001572327044025101
Canada $ | 1.596 | 0.002000000000000002 | 0.001254705144291093
Germany Dmark | 2.2 | 0.007000000000000117 | 0.00319197446420434
Euro | 0.8895 | -0.002400000000000069 | -0.002690884628321637
Japan ¥en | 132.6 | -0.2000000000000171 | -0.00150602409638567
Mexico NP | 9.2 | 0.01999999999999957 | 0.002178649237472721
[NAME] | 0.6963 | 0.001400000000000068 | 0.002014678370988729
Foreign Indices | Close | Change | % Change
Arg MerVal | 343.22 | 0 | 0
[NAME]. | 3354.9 | -9.299999999999727 | -0.002764401640806054
[NAME] | 14020.79 | -146.7899999999991 | -0.01036097908040746
Can TSE 300 | 7775.8 | -6.199999999999818 | -0.0007967103572346206
Germany DAX | 5288.21 | 51.84000000000015 | 0.009899987968764649
[NAME] | 11440.72 | -272.99 | -0.02330516975407448
Japan Nikkei 225 | 10663.98 | -31.6200000000008 | -0.002956355884662927
[NAME] | 6560.58 | -80.5600000000004 | -0.01213044748341405
UK FTSE 100 | 5228.5 | -21.89999999999964 | -0.004171110772512501
Source:  Yahoo!, TradingDay.com and NYMEX.com
Spreadsheet: john_griffith__16005__Exponential Volatility
Sheet: _Wizard

xCL Close Sheet1!$B$1 | x | xCL | xClose | [NAME] | [NAME] | x4 | x1 | xSheet1 | [NAME] | x|False|year(s)|day(s)|1|1|1/1/1998|7:20am|False|False|7:20am|1/1/1998|False|True|False|False|True|USD|BBL|False | x|True|True|False|True|False|False | xWizard | xa NaN | xDate is within 1 years | xFalse | xFalse | xTrue | xFalse | xTrue | xClose of CL | xFalse | x-1 | [NAME] | xExpiration Day | x | x | x | x | xFalse
xNG Close Sheet1!$A$1 | x | xNG | xClose | [NAME] | [NAME] | x4 | x1 | xSheet1 | [NAME] | x|False|year(s)|day(s)|1|1|1/1/1998|7:20am|False|False|7:20am|1/1/1998|False|True|False|True|False|USD|MMBTU|False | x|True|True|False|True|False|False | xWizard | xa NaN | x | xFalse | xFalse | xTrue | xFalse | xTrue | xClose of NG | xFalse | x-1 | [NAME] | xExpiration Day | x | [NAME] | [NAME] | xUSD | xFalse
Spreadsheet: 49358d1248710995-army-builder-spreadsheet-help-deas
Sheet: Rare

Rare |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Points Spent: |  |  |  | 2246
 | Number |  |  | 2 |  |  | 200 |  |  |  |  | Equipment: |  |  | Special Rules: |  |  | Command: |  |  | Options: |  |  | Pts:
 | Reaper Bolt Thrower (100) |  |  |  |  |  |  |  |  |  |  | Hand Weapon |  |  | Eternal Hatred
 |  | M | WS | BS | S | T | W | I | A | Ld |  | Light Armor |  |  | War Machine
 | D | 5 | 4 | 4 | 3 | 3 | 1 | 5 | 1 | 8 |  |  |  |  | May Take 2 as a Single Rare
 | R | - | - | - | - | 7 | 3 | - | - | -
 | Unit [NAME] with 2 Crew
 | Total |  |  |  |  |  | 200
 | Points |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Com. | 0 |  | Total Options: |  |  | 0
 | Number |  |  | 1 |  |  | 175 |  |  |  |  | Equipment: |  |  | Special Rules Hydra |  |  | Special Rules BM |  |  | Options: |  |  | Pts:
 | War Hydra (175) |  |  |  |  |  |  |  |  |  |  | Beastmasters: |  |  | Eternal Hatred |  |  | Eternal Hatred
 |  | M | WS | BS | S | T | W | I | A | Ld |  | Beastmasters Scourge |  |  | 4+ Scaly Skin |  |  | Beastmasters
 | H | 6 | 4 | 0 | 5 | 5 | 5 | 2 | 7 | 6 |  | Hand Weapon |  |  | Large Target
 | B | 6 | 4 | 4 | 3 | 3 | 1 | 5 | 2 | 8 |  |  |  |  | Terror
 | Unit [NAME] 1 War Hydra 2 Beast Masters |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Total |  |  |  |  |  | 175 |  |  |  |  |  |  |  | Regenerate (5+)
 | Points |  |  |  |  |  |  |  |  |  |  |  |  |  | Monster and Handler |  |  |  |  |  | Total Options: |  |  | 0
Spreadsheet: 844206d1695956266-automatically-insert-rows-for-each-value-that-is-returned-example
Sheet: Presentation

Number | Quantity | Cost | Rate
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Spreadsheet: 159300d1338573418-consolidating-names-and-values-advname_reply
Sheet: SR1

 |  |  |  |  |  |  |  |  |  |  | Sample Manual Entry
 |  |  |  |  |  |  |  | 0 | 0 |  |  | 140 | 55
Date | Hd2 | Hd3 | Name / Code |  | Value |  | Emp Name | 1st to 15th | 16th to 31st |  | Emp Name | 1st to 15th | 16th to 31st
2012-04-01 00:00:00 | other data | other data | [NAME] / Some text | other data | 10 |  |  |  |  |  | [NAME] | 10
2012-04-02 00:00:00 |  |  | [NAME] / Some text |  | 20 |  |  |  |  |  | [NAME] | 40 | 20
2012-04-03 00:00:00 |  |  | Apple |  | 40 |  |  |  |  |  | [NAME] | 10 | 5
2012-04-04 00:00:00 |  |  | [NAME] / Some text |  | 5 |  |  |  |  |  | Franchis | 60 | 30
2012-04-05 00:00:00 |  |  | Mango |  | 50 |  |  |  |  |  | George | 20
2012-04-06 00:00:00 |  |  | Grapes |  | 12
2012-04-07 00:00:00 |  |  | Franchis / Some text |  | 30
2012-04-08 00:00:00 |  |  | [NAME] text |  | 10
2012-04-09 00:00:00 |  |  | [NAME] / Some text |  | 20
2012-04-10 00:00:00 |  |  | Apple |  | 40
2012-04-11 00:00:00 |  |  | [NAME] / Some text |  | 5
2012-04-12 00:00:00 |  |  | Mango |  | 50
2012-04-13 00:00:00 |  |  | Grapes |  | 12
2012-04-14 00:00:00 |  |  | Franchis / Some text |  | 30
2012-04-15 00:00:00 |  |  | [NAME] text |  | 10
2012-04-16 00:00:00 |  |  | [NAME] / Some text |  | 20
2012-04-17 00:00:00 |  |  | Apple |  | 40
2012-04-18 00:00:00 |  |  | [NAME] / Some text |  | 5
2012-04-19 00:00:00 |  |  | Mango |  | 50
2012-04-20 00:00:00 |  |  | Grapes |  | 12
2012-04-21 00:00:00 |  |  | Franchis / Some text |  | 30
Spreadsheet: 533122d1502663021-pivot-table-displaying-old-data-53rd-street-cost-schedule-before
Sheet: Draw 8 - 08.07.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes
Retaining Wall Materials | Block/Retaining Walls | 345 | 2017-08-06 00:00:00 | 114.52 | Home Depot | Retaining wall materials
Grading and Export | Rough Grading | 302 | 2017-08-04 00:00:00 | 4750 | B&M Grading | Grading and export material to [NAME]
Stormwater BMPs | Erosion Control | 211 | 2017-07-31 00:00:00 | 750 | B&M Grading | Stormwater BMPs
Stormwater BMPs | Erosion Control | 211 | 2017-08-01 00:00:00 | 134.69 | Summit Erosion Control | Stormwater BMPs
Stormwater BMPs | Erosion Control | 211 | 2017-08-01 00:00:00 | 408.91 | Summit Erosion Control | Stormwater BMPs
Spreadsheet: 57881d1258092179-find-and-count-text-value-within-array-707124-find-and-count-text-value-within-array
Sheet: Sheet1

Answers |  |  | Count of states in answers
Arizona and Texas |  |  | Arizona
New York |  |  | Texas
all my live in California |  |  | New York
moved from Texas to Virginia |  |  | California
first arizona, then california, then back to arizona |  |  | Virginia
Texas and New York |  |  | South Dakota
mainly in the middle of nowhere
Overseas and then in South Dakota |  |  | note that Arizona is mentioned three times in two cells, but the count returns only two. Is that OK?
New york, texas, South Dakota and Virginia
Spreadsheet: 851580d1701790596-predict-the-score-game-predict-the-score
Sheet: Week 3

2023-12-09 00:00:00
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Jordan |  | [NAME] |  | [NAME] |  | [NAME]
 | Palace
 | Liverpool
 | Wolves
 | Nott Forest
 | Brighton
 | Burnley
 | [NAME]
 | Brentford
 | Man Utd
 | Bournemouth
 | A Villa
 | Arsenal
 | Luton
 | Man City
 | Fulham
 | West  Ham
 | Everton
 | Chelsea
 | Tottenham
 | Newcastle
 |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Jordan |  | [NAME] |  | [NAME] |  | [NAME]
Spreadsheet: 67b4037b-0df0-4bd2-a4b6-02ddaa055b2c
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
BRAZ | Test | BRAZ | Brazil Nut, IgE | Brazil Nut, 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
BRAZ | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BRAZ | Result | BRAZ | Brazil Nut, IgE | Brazil Nut, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6050-9
Spreadsheet: 298193d1392735587-selecting-a-table-based-on-two-dropdown-lists-selecting-a-table-ndm-v2-conditional-formatting-to-hide-errors
Sheet: Table summary

 | Size | Format
 | A34x8.5 | Gloss 4+0
 | 0-499 | 500-4.999 | 5.000-10.000 | 10.000+
Spreadsheet: 806973d1669703338-transfer-of-data-from-a-master-sheet-to-other-sheets-quest
Sheet: cash in hand

Helper |  | Date | Description | Debit | Credit | Amount
Spreadsheet: b95d5920-30a5-467b-9f49-b2d11023cdb4
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
SBK | Test | SBK | Chromosome Analysis, Spontaneous Breakage Analysis, Blood | Chromosomes, Spontaneous Breakage | 72-Hour Culture with Phytohemagglutinin | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  |  |  | Provide a reason for referral with each specimen. The laboratory will not reject testing if this information is not provided, but appropriate testing and interpretation may be compromised or delayed.   Container/Tube: Green top (sodium heparin) [NAME]: 5 mL Collection Instructions: 1. Invert several times to mix blood. 2. Other anticoagulants are not recommended and are harmful to the viability of the cells. Additional Information: Advise Express Mail or equivalent if not on courier service. Forms: If not ordering electronically, submit a Cytogenetics/AFP Congenital Disorders Request Form (Supply T238) with the specimen. | 2 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Clotted blood | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday, 8 a.m.-5 p.m. CST. | 7 days | 8 days |  | Profile |  |  |  |  | Rochester
SBK | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Ambient
SBK | Order Question | CG370 | Reason for Referral |  | Plain Text
SBK | Result | 29996 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
SBK | Result | 29997 | [NAME] | [NAME] | Alphanumeric
SBK | Result | 29998 | Source | Source | Alphanumeric
SBK | Result | 29999 | Order Date | Order Date | Alphanumeric
SBK | Result | CG370 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
SBK | Result | 30010 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
SBK | Result | 50473 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62359-5
SBK | Result | 30015 | Results | Results | Alphanumeric
SBK | Result | 30019 | Interpretaton | Interpretaton | Alphanumeric
SBK | Result | 30020 | Amendment | Amendment | Alphanumeric
SBK | Result | 30021 | Reviewed By | Reviewed By | Alphanumeric
SBK | Result | 30022 | Release Date | Release Date | Alphanumeric
SBK | Billing Component | SBK |  | Ctyo & Molec Cyto Interp & Report |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88291
SBK | Billing Component | SBK |  | Chromosome Analysis Breakage Syndromes |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88248
SBK | Billing Component | SBK |  | Tissue Culture |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 88230
Spreadsheet: 120585d1315394731-recording-previous-value-of-a-group-of-cells-into-one-cell-sample
Sheet: Sample

S. No | Value | Data | Result
1 | 0
2 | 0
3 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
4 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
6 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
9 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Devon

 | Devon SFS Operating
 | POI 36289 - Bilbrey 28 Fed 1 C/P
Day | Measured | Scheduled
1 | 650 | 589
2 | 625 | 589
3 | 616 | 589
4 | 599 | 589
5 | 595 | 589
6 | 616 | 589
7 | 629 | 589
8 | 637 | 589
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 148986
2001-12-08 00:00:00
CBS Volume
 |  |  | 28495
Spreadsheet: 263887d1378720543-adding-values-in-excel-2003-counting-columns-in-excel-2003
Sheet: Sheet1

Original Data
numbers1 | [NAME]
1 | 32 |  | Desired Outcome
1 | 35 |  | lower | 0 | 3 | 6 | 9
1 | 41 |  | upper | 2 | 5 | 8 | 11
3 | 12 |  | Sum | 108 | 318 | 192 | 154
3 | 23
3 | 21
3 | 75
4 | 43
5 | 13
5 | 67
5 | 64
6 | 25
7 | 43
7 | 79
8 | 45
9 | 69
9 | 64
9 | 21
Spreadsheet: jonathan_mckay__16927__grandview buy
Sheet: Enron Direct Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | ECC |  |  |  |  | Deal Date: |  | 2001-08-13 00:00:00 |  |  |  |  | 3 | March
Originator: | [NAME] |  |  |  |  | Deal ID #: |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-10-01 00:00:00 |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  | 6 | June
Deal End Date: | 2006-10-01 00:00:00 |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  | 7 | July
Term Duration (months): | 60 |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  | 4.85 |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Buy |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total
 | January | 1200
 | February | 875
 | March | 840
 | April | 550
 | May | 300
 | June | 220
 | July | 140
 | August | 150
 | September | 280
 | October | 525
 | November | 800
 | December | 1000
 | TOTAL:
Spreadsheet: 740834d1626615979-if-formula-with-multiple-condition-if-condition
Sheet: Sheet1

 | Spec Confirm | Price Comparison | PO | [NAME] | Stock Arrived |  | Result
 | 1 | 1 | 1 | 1 | 1 |  | 1
 | 1 | 1 |  |  |  |  | 40
 | 1 | 1 | 1 |  |  |  | 0.6
 | 1 step = 20%
Spreadsheet: chris_germany__2308__colsale2(April 2000)
Sheet: Central Desk

Sales_Sub_Contract_Name | Delivery_Start_Date | Delivery_End_Date | Pipeline_Id | Pipeline_Point_Code | Point_Name | Quantity | Quantity_Unit_Id | Unit_Price | Statement_Amount | Delivery_Period
229920 | 4/1/2000 [NAME] | 4/30/2000 00:00:00 | ANR | 40186 | MUNCIE | 34500 | MMBtu | 3.01 | 103845 | Apr-00
229922 | 4/1/2000 [NAME] | 4/30/2000 00:00:00 | ANR | 40184 | FORT WAYNE (NIPSCO) | 1594 | MMBtu | 2.965 | 4726.21 | Apr-00
169701 | 4/1/2000 [NAME] | 4/30/2000 00:00:00 | MICH | 9078 | KALKASKA - MICHCON | 43680 | MMBtu | 2.74 | 119683.2 | Apr-00
229922 | 4/1/2000 [NAME] | 4/30/2000 00:00:00 | NGPL | 909260 | NGPL CENTRAL POINT | 22462 | MMBtu | 2.965 | 66599.83 | Apr-00
234799 | 4/4/2000 [NAME] | 4/4/2000 [NAME] | NGPL | 909260 | NGPL CENTRAL POINT | 75 | MMBtu | 2.96 | 222 | Apr-00
235709 | 4/5/2000 00:00:00 | 4/5/2000 00:00:00 | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 2.915 | 1166 | Apr-00
235709 | 4/6/2000 [NAME] | 4/6/2000 [NAME] | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 2.92 | 1168 | Apr-00
235709 | 4/7/2000 [NAME] | 4/7/2000 [NAME] | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 2.975 | 1190 | Apr-00
235709 | 4/8/2000 [NAME] | 4/8/2000 [NAME] | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 3.02 | 1208 | Apr-00
235709 | 4/9/2000 [NAME] | 4/9/2000 [NAME] | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 3.02 | 1208 | Apr-00
235709 | 4/10/2000 00:00:00 | 4/10/2000 00:00:00 | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 3.02 | 1208 | Apr-00
239688 | 4/8/2000 [NAME] | 4/12/2000 00:00:00 | NGPL | 909260 | NGPL CENTRAL POINT | 1500 | MMBtu | 3.03 | 4545 | Apr-00
240476 | 4/11/2000 [NAME] | 4/11/2000 [NAME] | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 3.11 | 1244 | Apr-00
241304 | 4/12/2000 00:00:00 | 4/12/2000 00:00:00 | NGPL | 909260 | NGPL CENTRAL POINT | 400 | MMBtu | 3.065 | 1226 | Apr-00
241304 | 4/13/2000 [NAME] | 4/13/2000 [NAME] | NGPL | 909260 | NGPL CENTRAL POINT | 500 | MMBtu | 3.03 | 1515 | Apr-00
143851 | 4/1/2000 [NAME] | 4/30/2000 00:00:00 | NRAM | 11292 | ATLAS-JEWELLA ROAD | 31000 | MMBtu | 2.8 | 86800 | Apr-00
162135 | 4/1/2000 [NAME] | 4/30/2000 00:00:00 | NRAM | 11259 | PRECISION INDUS - MALVERN | 11700 | MMBtu | 2.36 | 27612 | Apr-00
Spreadsheet: sara_shackleton__36758__Moving US trading activity
Sheet: Ownership 2000_11 Step2A

 |  |  |  |  |  | Enron Corp
 |  | Enron Power Corp |  | Enron Europe LLC
 |  | 0.863 |  | 0.137
 |  |  | ECT Europe Inc |  |  |  |  |  | ENAC |  | Entity employing staff etc
 |  |  |  |  |  |  | ECHI |  | Holding entity
 |  |  |  | ECCL |  |  |  |  | ECCI |  | Dedicated new entity for Debt trading, credit default swaps and bankruptcy swaps
 |  |  |  | Dedicated entity |  |  |  |  |  |  | Positions purchased at market-value
 |  |  |  |  | Existing back-to-backs transferred. For new trades exposure stays in ECCI unless hedge in ECCL
 | Ownership 100% unless otherwise stated
Key: |  | Dedicated trading |  | Shared trading |  | Shared operations |  | New
Spreadsheet: 877999d1724948525-numerically-rank-high-to-low-positives-then-low-to-high-negatives-mr-stern-2-ranking-example-tms
Sheet: Sheet1

Value | Desired rank | TMS | AliGW | Kaper | Kaper | windknife | Phuocam
100 | 2
-50 | 6 | 6 | 6 |  |  |  | 6
-400 | 4 | 4 | 4 |  |  |  | 4
60 | 3 | 3 | 3 |  |  |  | 3
210 | 1 | 1 | 1 |  |  |  | 1
-70 | 5 | 5 | 5 |  |  |  | 5