tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__1938__Mar2002_EstateGas
Sheet: Sheet1

ENA Estate Gas Activity
Counterparty | Sitara | Pipe / Loc | Deal Type | 2002-03-01 00:00:00
Comments |  |  | Price
Louis Dreyfus Natural Gas Corp. (Dominion) | 30468 | FGT / Z1 | Term | 10000
 |  |  | Fixed | 2.1562
City of Tallahassee | 30523 | FGT / Z1 | Term | -10000
 |  |  | Fixed | 3.04
 |  |  | Balance
 |  |  | Profit / (Loss)
Reliant Energy Services, Inc. | 1199419 | FGT / Z2 & Z3 | Day | 2000 | 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
 |  |  | [NAME] | 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
City of Tallahassee | 30534 | FGT / Z2 & Z3 | Term-swing | -2000 | 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
Tall can call on up to 2,000 per day at GD + .10 |  |  | [NAME]
 |  |  | Balance
 |  |  | Profit / (Loss)
Anadarko Energy Services Company | 1198917 | PEPL / Field Pool | Baseload | 5000
 |  |  | Fixed | 2.25
Midland Cogeneration Venture Limited Partnership | 332163 | PEPL / Field Pool | Term | -5000
 |  |  | PEPL IF TXOK + .02833 | 2.25
 |  |  | Balance
 |  |  | Profit / (Loss)
Anadarko Energy Services Company | 1198936 | TRKL / East La | Baseload | 6000
 |  |  | Fixed | 2.28
Midland Cogeneration Venture Limited Partnership | 340305 | TRKL / East La | Term | -6000
 |  |  | NYMX / Trigger | 2.533
 |  |  | Balance
 |  |  | Profit / (Loss)
Anadarko Energy Services Company | 1198936 | TRKL / East La | Baseload | 6800
 |  |  | Fixed | 2.28
Midland Cogeneration Venture Limited Partnership | 340362 | TRKL / East La | Term | -6800
 |  |  | Fixed | 4.23
 |  |  | Balance
 |  |  | Profit / (Loss)
Anadarko Energy Services Company | 1198866 | ANR / Trans Pool | Baseload | 4000
 |  |  | Fixed | 2.28
Midland Cogeneration Venture Limited Partnership | 340305 | ANR / Trans Pool | Term | -4000
 |  |  | Fixed | 2.533
 |  |  | Balance
 |  |  | Profit / (Loss)
The Consumers' Gas Company Ltd. | ??? | UGL / Dawn | Baseload | 10000
 |  |  | Fixed | 0
MidAmerican Energy Company | 1199439 | UGL / Dawn | Baseload | -10000
 |  |  | Fixed | 2.47
 |  |  | Balance
 |  |  | Profit / (Loss)
MichCon Storage | 745463 | MICH | Baseload | 50000
 |  |  | Fixed | 0
CMS Marketing, Services and [NAME] | 1192919 | MICH | Baseload | -50000
 |  |  | Fixed | 2.3845
 |  |  | Balance
 |  |  | Profit / (Loss)
Spreadsheet: 11893421-d1f4-4615-9efa-43066c54302f
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
SYPGN | Test | SYPGN | [NAME], IgG, Serum | [NAME], S | [NAME] | Serum Gel Tube: SGT |  |  | 0.75 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.75 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative | Monday through Saturday; 9 a.m. | Same day/1 day | 4 days | 1 | 86780 |  |  |  |  | Rochester
SYPGN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SYPGN | Result | SYPGN | [NAME], S | [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6561-5
Spreadsheet: 017d4404-145e-4dbd-b902-2d60439b55f7
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Bros Rec | 75993868623 | [NAME] | Whats That [NAME] | 2006-08-08 | DVD | Comedy | 14.95 | Y | Available
Taseis | 859219001397 | [NAME] | Live In Chicago | 2010-10-26 | DVD | Comedy | 11.99 | Y | Available
[NAME] Csr | 80688612290 | [NAME] | Four-Eyed Blonde Clean Comedy | 2004-11-09 | DVD | Comedy | 7.99 | Y | Available
[NAME] Csr | 80688636593 | [NAME] | Last Word Clean Comedy, The | 2004-12-07 | DVD | Comedy | 7.99 | Y | Available
[NAME] Csr | 80688636296 | [NAME] | Girls Night Out Clean Comedy | 2004-11-09 | DVD | Comedy | 7.99 | Y | Available
Image Entertainment | 14381771527 | [NAME] | [NAME] | 2013-12-03 | DVD | Comedy | 14.98 | Y | Available
Spreadsheet: 767871d1644685263-football-score-prediction-football-prediction-template
Sheet: Sheet1

Team |  | Team |  | Actual Score | Actual Score |  | [NAME]
Liverpool | V | Everton |  | 2 | 1 |  | 2 | 1 | 2 | 10 |  | 12
Man Utd | V | Tottenham |  | 0 | 4 |  | 5 | 1 | 0 | 0 |  | 0
Newcastle | V | West Ham |  | 0 | 0 |  | 1 | 1 | 4 |  |  | 4
Leeds | V | Cardiff |  | 3 | 3 |  | 2 | 2 | 4 | 5 |  | 9
Southampton | V | Fulham |  | 1 | 1 |  | 1 | 1 | 4 | 5 |  | 9
West Brom | V | Chelsea |  | 1 | 1 |  | 0 | 4 |  |  |  | 3
Reading | V | Swansea |  | 2 | 3 |  | 2 | 3 |  |  |  | 13
 |  |  |  |  |  |  | Total Points
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wrong |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Home Win |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Draw (under 3 goals) |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Score (under 3 goals) |  | Add 5 points
 |  |  |  |  |  |  |  |  |  |  |  |  |  | over 4 goals, Home, [NAME] or draw |  | Add 5 points
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Correct Score (under 3 goals) |  | Add 10 points
Spreadsheet: 5925a415-9065-446d-89d2-dad38df3804b
Sheet: EPR Q3 proposed non-gaap

Reconciliations of GAAP to Non-GAAP Adjusted Measures (in millions, except EPS)
Third Quarters Ended June 30, | 2012
 | Cost of Gaming Operations |  |  | Continuing Operations |  |  | Continuing Operations
 |  | Operating Expenses | Operating Income | Net Earnings (b) | Diluted EPS |  | Net Earnings (b) | Diluted EPS
GAAP measures | 123 | 207.1 | 95.49999999999989 | 46.89999999999988 | 0.16 |  | 91.80000000000001 | 0.3
% of revenue |  | 0.3887012012012012 | 0.1792417417417415
Acquisition related charges: (a)
Contingent retention & earn-out | 0 | 26 | 26 | 16.614 | 0.06 |  | 0 | 0
Amortization of intangibles | 1.7 | 4.7 | 6.4 | 4.089600000000001 | 0.01 |  | 0 | 0
Professional fees | 0 | 0.1 | 0.1 | 0.06390000000000001 | 0 |  | 0 | 0
Severance | 0 | 1.3 | 1.3 | 0.8307 | 0 |  | 0 | 0
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | 0 |  | -15.1 | -0.04
Total non-GAAP adjustments | 1.7 | 32.1 | 33.8 | 21.5982 | 0.06999999999999999 |  | -15.1 | -0.04
Adjusted measures | 121.3 | 175 | 129.2999999999999 | 68.49819999999988 | 0.23 |  | 76.70000000000002 | 0.26
% of revenue |  | 0.3284534534534535 | 0.24268018018018
Nine Months Ended June 30, | 2012
 | Cost of Gaming Operations |  |  | Continuing Operations |  |  | Continuing Operations
 |  | Operating Expenses | Operating Income | Net Earnings (b) | Diluted EPS |  | Net Earnings (b) | Diluted EPS
GAAP measures | 346 | 554.6999999999999 | 313.5 | 159.6 | 0.54 |  | 232.3000000000001 | 0.77
% of revenue |  | 0.36503027112398 | 0.2063042906027902
Acquisition related charges: (a)
Contingent retention & earn-out | 0 | 37.8 | 37.8 | 24.214 | 0.08 |  | 0 | 0
Amortization of intangibles | 4 | 8.6 | 12.6 | 8.0896 | 0.03 |  | 0 | 0
Professional fees | 0 | 5.8 | 5.8 | 3.6639 | 0.01 |  | 0 | 0
Distributor settlement | 0 | 3.1 | 3.1 | 2 | 0.01 |  | 0 | 0
Severance | 0 | 2.5 | 2.5 | 1.6307 | 0 |  | 0 | 0
Investment gain | 0 | 0 | 0 | 0 | 0 |  | -4.3 | -0.01
Certain discrete tax items (benefits) | 0 | 0 | 0 | 0 | 0 |  | -22.1 | -0.07
Total non-GAAP adjustments | 4 | 57.8 | 61.8 | 39.5982 | 0.13 |  | -26.4 | -0.08
Adjusted measures | 342 | 496.8999999999999 | 375.3 | 199.1982 | 0.67 |  | 205.9000000000001 | 0.6900000000000001
% of revenue |  | 0.326993945775204 | 0.2469728876020006
(a) Primarily related to DoubleDown
(b) Adjustments tax effected at 36%
We believe that certain non-GAAP measures, when presented in conjunction with comparable GAAP (Generally Accepted Accounting Principles) measures, are useful because that information is an appropriate measure for evaluating our operating performance. Non-GAAP information is used to evaluate business performance and management’s effectiveness. These measures should be considered in addition to, not as a substitute for, or superior to, measures of financial performance prepared in accordance with GAAP. Non-GAAP measures may not be calculated in the same manner by all companies and therefore may not be comparable.
Spreadsheet: 707840d1607501709-calculate-cost-basis-of-remaining-shares-of-stock-book1-5-ans
Sheet: Sheet1

 |  |  |  | Date | Description | Symbol | Shares | Debit | Credit | Bal.
 |  |  |  | 2018-01-04 00:00:00 | Bought | XYZ | 650 | 31126.34
 |  |  |  | 2018-03-10 00:00:00 | Bought | XYZ | 150
 |  |  |  | 2018-04-09 00:00:00 | Sold | XYZ | 650 |  | 28543.27
 |  |  |  | 2019-04-08 00:00:00 | Bought | XYZ | 250 | 14283.4
 |  |  |  | 2019-05-10 00:00:00 | Sold | XYZ | 100 |  | 5212
 |  |  |  | 2019-06-07 00:00:00 | Bought | XYZ | 300 | 16077.86
Spreadsheet: 762741d1641789899-formula-to-get-the-year-of-max-record-with-condition-book1
Sheet: Data

 | Category | Quarter | 2021 | Past Highest Record | Year of Past Highest Record
 | A | 1Q |  |  | 2010
 | B | 1Q |  |  | 2019
 | C | 1Q
 | D | 1Q |  |  |  |  | Is there any formula to get this result without using the pivot table below?
 | E | 1Q
 | F | 1Q
 | G | 1Q
 | H | 1Q
 | Category | Month | 2021 | Past Highest Record | Year of Past Highest Record
 | A | 3 |  |  | 2018
 | B | 3 |  |  | 2020
 | C | 3
 | D | 3
 | E | 3
 | F | 3
 | G | 3
 | H | 3
 | Sales Fiscal Quarter | 1Q
 | Sum of Sales | Column Labels
 | Row Labels | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | Grand Total
 | A | 102500 | 58400 | 62000 | 57000 | 69300 | 69400 | 76700 | 90300 | 92900 | 75800 | 60600 | 76200 | 891100
 | B | 12500 | 7300 | 12900 | 13400 | 12900 | 10300 | 16900 | 19000 | 21000 | 24400 | 21300 | 18900 | 190800
 | C | 26300 | 20600 | 30400 | 51400 | 34600 | 58800 | 45900 | 79600 | 61000 | 55000 | 69500 | 52800 | 585900
 | D | 30600 | 17900 | 10800 | 23600 | 16700 | 30300 | 17800 | 36600 | 33400 | 35600 | 39700 | 66300 | 359300
 | E | 7400 | 11500 | 9500 | 18500 | 20500 | 26200 | 14800 | 46000 | 43000 | 31100 | 22800 | 25600 | 276900
 | F | 20100 | 10600 | 18400 | 16500 | 39500 | 24900 | 36700 | 72900 | 96600 | 74900 | 72800 | 91100 | 575000
 | G | 4500 | 7100 | 4700 | 4500 | 4100 | 11200 | 21300 | 33100 | 50000 | 38900 | 25500 | 25500 | 230400
 | H | 0 | 200 | 0 | 200 | 1800 | 6300 | 6200 | 14100 | 20900 | 1200 | 12300 | 3600 | 66800
 | I | 6100 | 2600 | 4400 | 6500 | 10300 | 16700 | 16400 | 28500 | 32700 | 39700 | 12600 | 14200 | 190700
 | Grand Total | 210000 | 136200 | 153100 | 191600 | 209700 | 254100 | 252700 | 420100 | 451500 | 376600 | 337100 | 374200 | 3366900
 | Sales Month | 3
 | Sum of Sales | Column Labels
 | Row Labels | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | Grand Total
 | A | 30800 | 20300 | 21200 | 16800 | 19100 | 25200 | 25300 | 32900 | 35700 | 29800 | 23400 | 43000 | 323500
 | B | 5000 | 2900 | 4100 | 4800 | 4900 | 4100 | 3800 | 7500 | 7300 | 8100 | 8700 | 8700 | 69900
 | C | 7900 | 7200 | 11900 | 9300 | 10600 | 24500 | 13900 | 32000 | 18500 | 16900 | 29000 | 25800 | 207500
 | D | 10200 | 3800 | 5800 | 5600 | 4100 | 8400 | 7600 | 14600 | 12200 | 11500 | 11000 | 32300 | 127100
 | E | 1400 | 5800 | 2400 | 4700 | 8000 | 13900 | 2700 | 20100 | 12600 | 11900 | 7900 | 16500 | 107900
 | F | 6600 | 3500 | 2900 | 3900 | 10200 | 9500 | 12700 | 18200 | 27300 | 31100 | 29400 | 50200 | 205500
 | G |  | 4300 | 1500 |  | 2300 | 6300 | 3800 | 9600 | 22100 | 13800 | 2000 | 12200 | 77900
 | H | 0 | 100 | 0 | 100 | 1700 | 0 | 3900 | 0 | 8200 | 0 | 5500 | 3500 | 23000
 | I | 2300 | 400 | 2200 | 1700 | 2700 | 15200 | 6000 | 13400 | 17000 | 17000 | 7700 | 2500 | 88100
 | Grand Total | 64200 | 48300 | 52000 | 46900 | 63600 | 107100 | 79700 | 148300 | 160900 | 140100 | 124600 | 194700 | 1230400
Spreadsheet: 800910d1665992138-formala-for-pulling-values-from-another-sheet-where-multiple-vlookup-search-results-exist-booking-sample
Sheet: Bookings

 | Date | Name | Address | Booking | Time
 | 2022-10-01 00:00:00 | George | 1 street, parkway | 45 | 2:00pm - 3:00pm
 | 2022-10-01 00:00:00 | [NAME] | 5 big road, city | 56 | 10:00am - 4:00pm
 | 2022-10-01 00:00:00 | Adam | 6 rideway close, sydney | 44 | 4:00pm - 4:00am
 | 2022-10-08 00:00:00 | Wilfred | 33 Hay Street, Melbourne | 34 | 3:00am - 9:00pm
 | 2022-10-08 00:00:00 | [NAME] | 2 Queens close, Reading | 56 | 12:00pm - 4:00pm
Spreadsheet: darrell_schoolcraft__7212__saledoc10_2TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2001-10-15 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 10/17/01-10/19/01 |  |  | FAX Number:
Total Quantity |  |  | 45000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | El Paso Perm Gas Daily
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
10/17/2001 | 10/19/01 | 45000 |  | 15000 |  | 15000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58646 |  | 15000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: frank_ermis__11216__1119
Sheet: Export

[NAME] | [NAME] | Deal No. | Originator | Broker | Type | Deal Date | Status | Brk | Stmt | CP | Trd | Retro | Quantity | Comm | Delivery Ref | Index | Beg Date | End Date | N | Premium | Price | Broker Fee
Aquila Risk Management Corporation | Enron North America Corp. | [NAME] | May [NAME] | GFI Group  I | OPT/Put | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 2000000 MMBtu/month | NG | IF-ELPO/SJ | NX1 | 2001-12-01 00:00:00 | 2001-12-31 00:00:00 | F | 0.07 | US -0.4000 | 1000
ConAgra Energy Services  Inc. | Enron North America Corp. | YK5148.1 | May [NAME] | GFI Group  I | OPT/Put | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 500000 MMBtu/month | NG | IF-ELPO/SJ | NX1 | 2002-01-01 00:00:00 | 2002-01-31 00:00:00 | F | 0.09 | US -0.4500 | 250
BP Corporation North America Inc. | Enron North America Corp. | YK5275.1 | [NAME] | TFS Energy | Swap | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 5000 [NAME]/day | NG | NGI-PGE/CG | NX1 | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | F |  | US 0.24000 | 76.25
Reliant Energy Services  Inc. | Enron North America Corp. | YK5664.1 | May [NAME] | Prebon Yaman | OPT/Call | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 5000 [NAME]/day | NG | NGI-SOCAL | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F | 0.11 | US 0.50000 | 535
Enron North America Corp. | Dynegy Marketing and Trade | YK5689.1 | May [NAME] | Prebon Yaman | OPT/Call | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 20000 MMBtu/day | NG | NGI-SOCAL | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F | 0.11 | US 0.50000 | 0
Dynegy Marketing and Trade | Enron North America Corp. | YK5689.2 | May [NAME] | Prebon Yaman | OPT/Call | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 20000 MMBtu/day | NG | NGI-SOCAL | NX1 | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | F | 0.11 | US 0.50000 | 3650
Enron North America Corp. | El Paso Merchant Energy  L.P. | YK5759.1 | May [NAME] | Prebon Yaman | OPT/Call | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 10000 MMBtu/day | NG | NGI-SOCAL | NX1 | 2002-04-01 00:00:00 | 2002-10-31 00:00:00 | F | 0.1125 | US 0.50000 | 0
El Paso Merchant Energy  L.P. | Enron North America Corp. | YK5759.2 | May [NAME] | Prebon Yaman | OPT/Call | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 10000 MMBtu/day | NG | NGI-SOCAL | NX1 | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | F | 0.12 | US 0.50000 | 1825
Cinergy Marketing & Trading  LLC | Enron North America Corp. | YK5824.1 |  | TFS Energy | Swap | 2001-11-19 00:00:00 | New deal | No | No | No | No | N | 15000 MMBtu/day | NG | NGI-SOCAL | NX1 | 2002-11-01 00:00:00 | 2002-12-31 00:00:00 | F |  | US 0.09000 | 228.75
Spreadsheet: 274857d1383237711-counting-strings-in-a-cell-only-in-a-row-where-another-column-value-0-counttest-abreviated
Sheet: JobList

Qty | Ref | Description | Shortages
Spreadsheet: 749149d1632532054-return-the-week-number-based-on-when-jan-1-started-return-the-week-number-based-on-when-jan-1-started
Sheet: Sheet1

 |  |  |  | 2017
 |  | January |  |  |  |  |  |  |  |  | February
 |  | 1900-01-01 00:00:00 |  |  |  |  |  |  |  |  | 1900-01-02 00:00:00
 | WEEK | SUN | MON | TUE | WED | THU | FRI | SAT |  | WEEK | SUN | MON | TUE | WED | THU | FRI | SAT
Spreadsheet: 128495d1321010789-countif-between-dates-help-testforip2
Sheet: CurrentPeriod

Ref | date | person
lmkasfg | 2011-10-17 00:00:00 | [NAME]
a,djgh | 2011-10-17 00:00:00 | Fred
ajdfh | 2011-10-18 00:00:00 | [NAME]
lmkasfg | 2011-10-19 00:00:00 | [NAME]
a,djgh | 2011-10-19 00:00:00 | [NAME]
ajdfh | 2011-10-20 00:00:00 | [NAME]
lmkasfg | 2011-10-20 00:00:00 | [NAME]
a,djgh | 2011-10-20 00:00:00 | [NAME]
ajdfh | 2011-10-20 00:00:00 | [NAME]
lmkasfg | 2011-10-20 00:00:00 | [NAME]
a,djgh | 2011-10-20 00:00:00 | Sid
ajdfh | 2011-10-20 00:00:00 | [NAME]
lmkasfg | 2011-10-27 00:00:00 | Fred
a,djgh | 2011-10-27 00:00:00 | [NAME]
ajdfh | 2011-10-27 00:00:00 | [NAME]
lmkasfg | 2011-10-27 00:00:00 | [NAME]
a,djgh | 2011-10-27 00:00:00 | [NAME]
ajdfh | 2011-10-27 00:00:00 | [NAME]
lmkasfg | 2011-10-28 00:00:00 | Klaus
a,djgh | 2011-10-31 00:00:00 | [NAME]
ajdfh | 2011-11-01 00:00:00 | Fred
lmkasfg | 2011-11-01 00:00:00 | [NAME]
a,djgh | 2011-11-01 00:00:00 | [NAME]
ajdfh | 2011-11-04 00:00:00 | [NAME]
lmkasfg | 2011-11-04 00:00:00 | [NAME]
a,djgh | 2011-11-04 00:00:00 | [NAME]
ajdfh | 2011-11-04 00:00:00 | [NAME]
lmkasfg | 2011-11-07 00:00:00 | Fred
a,djgh | 2011-11-07 00:00:00 | [NAME]
ajdfh | 2011-11-09 00:00:00 | [NAME]
lmkasfg | 2011-11-09 00:00:00 | [NAME]
Spreadsheet: 705315d1606020910-duplicate-value-with-in-a-cell-test
Sheet: Sheet1

Details | observations | Function results
1334778 | 3 & 7 are duplicate | 3,7
1255669 | 6 is duplicate | 6
2334568 | 3is duplicate | 3
1112467 | 1 is triplicate | 1
1114567 | 1 is triplicate | 1
2456799 | 9 is duplicate | 9
2256799 | 2 & 9 are duplicate | 2,9
2233444 | 2,3,4 has multiple counts | 1,3,4
[NAME] number in cell= 7 digits
Spreadsheet: 103531d1301309138-automatic-sum-up-of-values-for-the-whole-current-work-week-extract-of-project-plan
Sheet: Sheet1

Extract of the project plan
 |  | Total cumulated days | Cumulated Biling Period days | Weekly period (PD) | weekly (CHF) | 2010-11-01 00:00:00 | 2010-11-02 00:00:00 | 2010-11-03 00:00:00 | 2010-11-04 00:00:00 | 2010-11-05 00:00:00 | 2010-11-06 00:00:00 | 2010-11-07 00:00:00 | 2010-11-08 00:00:00 | 2010-11-09 00:00:00 | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | 2010-11-12 00:00:00 | 2010-11-13 00:00:00 | 2010-11-14 00:00:00 | 2010-11-15 00:00:00 | 2010-11-16 00:00:00 | 2010-11-17 00:00:00 | 2010-11-18 00:00:00 | 2010-11-19 00:00:00 | 2010-11-20 00:00:00 | 2010-11-21 00:00:00 | 2010-11-22 00:00:00 | 2010-11-23 00:00:00 | 2010-11-24 00:00:00 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2010-11-27 00:00:00 | 2010-11-28 00:00:00 | 2010-11-29 00:00:00 | 2010-11-30 00:00:00 | 2010-12-01 00:00:00 | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 | 2010-12-04 00:00:00 | 2010-12-05 00:00:00 | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-08 00:00:00 | 2010-12-09 00:00:00 | 2010-12-10 00:00:00 | 2010-12-11 00:00:00 | 2010-12-12 00:00:00 | 2010-12-13 00:00:00 | 2010-12-14 00:00:00 | 2010-12-15 00:00:00 | 2010-12-16 00:00:00 | 2010-12-17 00:00:00 | 2010-12-18 00:00:00 | 2010-12-19 00:00:00 | 2010-12-20 00:00:00 | 2010-12-21 00:00:00 | 2010-12-22 00:00:00 | 2010-12-23 00:00:00 | 2010-12-24 00:00:00 | 2010-12-25 00:00:00 | 2010-12-26 00:00:00 | 2010-12-27 00:00:00 | 2010-12-28 00:00:00 | 2010-12-29 00:00:00 | 2010-12-30 00:00:00 | 2010-12-31 00:00:00
 |  | 28.5 | 28.5 | Here all hours for the current workweek should be summed up (this should be done automatically so that every week the sum is for the current week only) |  | 0 | 0 | 8 | 8 | 0 |  |  |  | 8 | 8 | 8 | 8 |  |  | 4 | 0 | 0 | 0 | 0 |  |  | 4 | 0 | 4 | 4 | 0 |  |  | 4 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 0 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 0 |  |  | 0 | 8 | 8 | 8
Spreadsheet: 192189d1352332497-looking-for-a-text-string-and-putting-that-cell-value-into-a-table-excel-forum-example
Sheet: Sheet1

 | COLUMN B | COLUMN C | COLUMN D | COLUMN E |  | Search Text | Results | helper column | helper column
ROW 2 | Address: 105 Fairway Green Drive Wilmington, NC ; 28557 |  |  |  |  | Aprx Htd SqFt:
ROW 3 | MLS#: 121-458 |  | List Price: $ 229,900 |  |  | SqFt. Upper:
ROW 4 | Property Type: Residential |  | Sales Price: $201,000 |  |  | SqFt. Lower:
ROW 5 | Pin 15: | 635606286652000 |  |  |  | Year Built:
ROW 6 | Status: Closed |  | Bank OwnedNo |  |  | [NAME]:
ROW 7 | Type:Single Family Residential |  | Zoning: | Residential |  | [NAME]:
ROW 8 | Lot Size: | 135 x 125 | Style: [NAME] |  |  | Prop. Taxes:
ROW 9 | Subdivision: [NAME] |  | Subdivision Phase:IV |  |  | Tax Year:
ROW 10 | Area: Morehead City |  | Lot #: | 16 |  | Lot #:
ROW 11 | Rooms: | 8 | Aprx Lot Acres: | 0.39 |  | Aprx Lot Acres:
ROW 12 | Bedrooms: 3 |  |  |  |  | Zoning:
ROW 13 | Bathrooms: 2.00 |  |  |  |  | Lot Size:
ROW 14 | Half Baths: 1.0 |  |  |  |  | Pin 15:
ROW 15 | Aprx Htd SqFt: | 2300 | [NAME]: | X |  | Address:
ROW 16 | SqFt. Upper: | 550 | [NAME]: | 350 |  | MLS#:
ROW 17 | SqFt. Lower: | 1750 | Prop. Taxes: | 1275 |  | List Price:
ROW 18 | Year Built: | 2005 | Tax Year: | 2012 |  | Sales Price:
 |  |  |  |  |  | Status:
 |  |  |  |  |  | Type:
 |  |  |  |  |  | Bank Owned
Spreadsheet: john_griffith__15967__11_16_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG Z1 | 265 | 30 | 32 | 81.9 | 87.3 | 14.09 | 2001-11-16 14:44:00
 | NG F2 | 280 | 60.5 | 63.5 | 82.4 | 86.5 | 14.87 | 2001-11-16 14:44:00
 | NG G2 | 290 | 75.5 | 78 | 73.9 | 76.3 | 13.69 | 2001-11-16 14:44:00
 | NG H2 | 290 | 79 | 81 | 66 | 67.6 | 12.18 | 2001-11-16 14:44:00
 | NG J2 | 285 | 75 | 80 | 56.5 | 60.3 | 10.46 | 2001-11-16 14:44:00
 | NG K2 | 290 | 79 | 83 | 52.8 | 55.5 | 9.87 | 2001-11-16 14:44:00
 | NG M2 | 295 | 84 | 88 | 50.5 | 52.9 | 9.59 | 2001-11-16 14:44:00
 | NG N2 | 300 | 92 | 96 | 51 | 53.3 | 9.84 | 2001-11-16 14:44:00
 | NG Q2 | 305 | 98 | 104 | 50.2 | 53.4 | 9.93 | 2001-11-16 14:44:00
 | NG U2 | 305 | 103 | 109 | 50 | 53 | 9.88 | 2001-11-16 14:44:00
 | NG V2 | 310 | 11 | 114 | 4.9 | 52.2 | 5.56 | 2001-11-16 14:44:00
 | NG X2 | 330 | 125 | 127 | 51.4 | 52.2 | 10.75 | 2001-11-16 14:44:00
 | [NAME] | 350 | 135 | 140 | 50.6 | 52.5 | 11.34 | 2001-11-16 14:44:00
 | NG H3 |  |  |  |  |  |  | 2001-11-12 14:47:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 869083d1715749092-formula-to-ignore-blank-cells-test-sheet
Sheet: Sheet1

day | start | end | rest period | rest period
[NAME] | 2024-04-07 18:00:00 | 2024-04-08 04:00:00
tue | 2024-04-09 07:00:00 | 2024-04-09 15:45:00
wed | 2024-04-10 18:00:00 | 2024-04-11 04:00:00
[NAME] | 2024-04-11 18:00:00 | 2024-04-12 03:00:00
fri | 2024-04-12 18:00:00 | 2024-04-13 05:15:00
sat
[NAME]
mon | 2024-04-15 18:00:00 | 2024-04-16 04:00:00