tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 808175d1670336380-multiple-replace-of-partial-texts-s666-pq-multiple-replace-of-partial-texts
Sheet: FindAndReplace

 | Data |  | Find | Replace |  | After
 | XX FIAT |  | XX | AA |  | AA FIAT
 | XX GM |  | YY | BB |  | [NAME]
 | [NAME] |  | ZZ | CC |  | [NAME]
 | YY FIAT |  |  |  |  | BB FIAT
 | YY GM |  |  |  |  | BB GM
 | YY HONDA |  |  |  |  | [NAME]
 | FIAT ZZ |  |  |  |  | FIAT CC
 | GM ZZ |  |  |  |  | GM CC
 | HONDA ZZ |  |  |  |  | HONDA CC
Spreadsheet: daren_farmer__5616__HPLN1206
Sheet: Sheet1

HPLN1206.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 06, 2000
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-06 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 40 | 40
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | HPL | 10 | 20
 |  | 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: 35485d1233089714-comparative-analysis-help-qtrly-returns-help
Sheet: Sheet1

Client | Account Registration | Account # | Q4 RETURN | Q1 07 Return | Q3 07 Return | October, 2007 Increase | Q1 2004 | Q2 2004 | Q3 2004 | Q4 2004 | Q1 2005 | Q2 2005 | Q3 2005 | [NAME] | Q1 2006 | Q2 2006 | Q3 2006 | Q4 2006 | Q1 2007 | Q2 2007 | Q3 2007 | Q4 2007 | Q1 2008 | Q2 2008 | Q3 2008 | Q4 2008 | Account Balance as of 12/31/08 |  |  | COUNTBLANK
S & P 500 |  |  |  |  |  |  | -0.0003 | 0.013 | -0.023 | 0.0873 | -0.0259 | 0.0091 | 0.0315 | 0.0159 | 0.0373 | -0.019 | 0.0517 | 0.0617 | 0.0018 | 0.0581 | 0.0156 | -0.0382 | -0.0992 | -0.0323 | -0.0837 | -0.2194
Sample Client | Mr Sample IRA | 31685999999 | 0.0614 | 0.0207 | 0.0301 | 0.0347 |  |  |  |  |  |  |  |  | 0.0697 | -0.0282 | 0.0279 | 0.0614 | 0.0207 | 0.0572 | 0.1117 | -0.0138 | -0.0904 | -0.0002 | -0.1231 | -0.2084 | 529768.87
 | Mr Sample IRA2 | 31686999999 |  |  |  |  | 0.0372 | -0.0193 | -0.0243 | 0.1108 | -0.0221 | 0.024 | 0.0596 | 0.0222
Spreadsheet: 07830dad-04e2-431f-b251-a1c865c3ff5f
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
CRY_S | Test | CRY_S | Cryoglobulin, Serum | Cryoglobulin, S | CRY_S/80988: Quantitation and Qualitative Typing Precipitation at 1 Degree C. Orderable as part of a panel or as a stand alone test. For further information see CRGSP/83659 [NAME] and Cryofibrinogen Panel, Serum and Plasma. IMFXC/28265: Immunofixation |  |  |  |  |  | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 5 mL Collection Instructions: 1. Tube must remain at 37 degrees C. 2. Allow blood to clot at 37 degrees C. 3. Centrifuge at 37 degrees C. (Do not use a refrigerated centrifuge. If absolutely necessary, ambient temperature is acceptable.) It is very important that the specimen remain at 37 degrees C until after separation of serum from red cells. 4. Place serum into an appropriately labeled plastic vial. Additional Information: Analysis cannot be performed with <3 mL of serum. Smaller volumes are insufficient to detect clinically important trace (mixed) cryoglobulins. Less than 3 mL will require draw of a new specimen. | 3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	Serum gel tube; plasma gel tube | Negative (positives reported as percent) | Monday through Friday; 4 pm | 2 days | 10 days | 1 | 82595 |  |  |  |  | Rochester
CRY_S | [NAME] | SERUM | Serum |  |  |  | Refrigerated
CRY_S | Result | 2684 | Cryoglobulin, S | Cryoglobulin, S | Alphanumeric |  |  |  |  | %ppt |  |  |  |  |  |  |  |  |  | In Process
CRY_S | [NAME] | IMFXC | Immunofixation Cryoglobulin | Immunofixation Cryoglobulin | Immunofixation |  |  |  |  |  | Only orderable per lab |  |  | Negative (reported as positive or negative) |  |  | 3 days | 1 | 86334 |  |  | No | No
IMFXC | [NAME] | SERUM | Serum |  |  |  | Refrigerated
IMFXC | Result | 28265 | Immunofixation Cryoglobulin | Immunofixation Cryoglobulin | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2167-5
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesMay

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100506 | 2010-01-12 00:00:00 | Customer1 | ProductA | 10000 | 2.15 | 21500 | 23535.85112205802
 | 100507 | 2010-01-12 00:00:00 | Customer2 | ProductB | 20000 | 1.125 | 22500 | 24630.54187192118
 | 100508 | 2010-01-12 00:00:00 | Customer3 | ProductA | 30000 | 0.7833333333333333 | 23500 | 25725.23262178435
 | 100509 | 2010-01-12 00:00:00 | Customer4 | ProductB | 40000 | 0.6125 | 24500 | 26819.92337164751
 | 100510 | 2010-01-12 00:00:00 | Customer5 | ProductA | 50000 | 0.51 | 25500 | 27914.61412151067
 | 100511 | 2010-01-12 00:00:00 | Customer6 | ProductB | 60000 | 0.4416666666666667 | 26500 | 29009.30487137384
 | 100512 | 2010-01-12 00:00:00 | Customer7 | ProductA | 70000 | 0.3928571428571428 | 27500 | 30103.995621237
 | 100513 | 2010-01-12 00:00:00 | Customer8 | ProductB | 80000 | 0.35625 | 28500 | 31198.68637110016
 | 100514 | 2010-01-12 00:00:00 | Customer9 | ProductA | 90000 | 0.3277777777777778 | 29500 | 32293.37712096333
DOMESTIC
Spreadsheet: 019142f6-1e11-4653-9544-9ffc9bceec6e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5206.0 Australian National Accounts: National Income, Expenditure and Product
 | Table 36. External Account, Current prices, Annual
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Imports of goods and services ; |  |  | Original | A2304626K | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Primary income receivable by non-residents - Compensation of employees ; |  |  | Original | A2304890W | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Primary income receivable by non-residents - Property Income ; |  |  | Original | A2304891X | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Secondary income receivable by non-residents - Current transfers ; |  |  | Original | A2304860J | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Exports of goods and services ; |  |  | Original | A2304641J | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Primary income payable by non-residents - Compensation of employees ; |  |  | Original | A2304894F | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Primary income payable by non-residents - Property Income ; |  |  | Original | A2304896K | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Secondary income payable by non-residents - Current transfers ; |  |  | Original | A2304859X | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Balance on external income account ; |  |  | Original | A2304662V | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Capital transfers - Receivable by non-residents ; |  |  | Original | A2304852J | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Capital transfers - Payable by non-residents ; |  |  | Original | A2304853K | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Balance on external income and capital transfers ; |  |  | Original | [NAME] | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Acquisitions less disposals of non-produced non-financial assets ; |  |  | Original | A2304629T | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
Net lending (+) / net borrowing (-) ; |  |  | Original | A2304663W | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
TOTAL CAPITAL ACCUMULATION AND NET LENDING (+) / NET BORROWING (-) ; |  |  | Original | A2304640F | 1960-06-01 00:00:00 | 2010-06-01 00:00:00 | 51 | $ Millions | DERIVED | Annual | 6
© Commonwealth of Australia  2010
Spreadsheet: 146927d1332427184-excel-2007-live-exchange-rate-data-feed-currency-msn-data-query
Sheet: Sheet1

Currency | In British pound | Per British pound
Algerian dinar | 0.00847 | 118.07115
[NAME] | 0.14467 | 6.91225
Australian dollar | 0.65497 | 1.5268
Baharaini Dinar | 1.68013 | 0.59519
[NAME] | 0.09153 | 10.9249
Brazilian real | 0.34762 | 2.87668
British pound | 1 | 1
Botswana pula | 0.08652 | 11.55779
Canadian dollar | 0.63329 | 1.57905
Chilean peso | 0.0013 | 771.62052
Chinese yuan | 0.10036 | 9.96427
[NAME] | 0.00036 | 2775.49404
Czech koruna | 0.0337 | 29.67842
Danish krone | 0.112 | 8.92833
Egyptian pound | 0.10481 | 9.5415
Euro | 0.833 | 1.20047
[NAME] | 6e-05 | 15810.27667
Guatemalan quetzal | 0.08161 | 12.25296
Hong Kong dollar | 0.08146 | 12.27674
Hungarian forint | 0.00284 | 351.66799
new Israeli shekel | 0.16882 | 5.92364
Indian rupee | 0.01235 | 80.99604
Indonesian rupiah | 7e-05 | 14466.40245
Japanese yen | 0.00765 | 130.71936
Jordanian Dinar | 0.89286 | 1.12
[NAME] | 0.00762 | 131.19368
Kuwaiti dinar | 2.27028 | 0.44047
Malaysian ringgit | 0.20516 | 4.87431
Mexican Peso | 0.04933 | 20.27194
Moroccan Dirham | 0.07485 | 13.35968
Namibian dollar | 0.08237 | 12.14071
New Zealand dollar | 0.51078 | 1.95779
Norwegian krone | 0.10908 | 9.16762
Omani Rial | 1.64328 | 0.60854
Pakistan rupee | 0.007 | 142.83003
Peruvian nuevo sol | 0.23707 | 4.21818
Philippine Peso | 0.0147 | 68.03162
[NAME] | 0.17382 | 5.75304
Russian Rouble | 0.02148 | 46.55146
Saudi Riyal | 0.16867 | 5.92885
Singapore dollar | 0.49925 | 2.00299
South African rand | 0.08192 | 12.20727
Korean Won | 0.00056 | 1792.94858
Swedish krona | 0.09329 | 10.71975
Swiss franc | 0.69099 | 1.44719
Taiwan Dollar | 0.02137 | 46.79367
[NAME] | 0.0004 | 2514.62455
Thai baht | 0.02052 | 48.72727
Tunisian dinar | 0.41777 | 2.39368
New Turkish Lira | 0.35009 | 2.85644
[NAME] | 0.17222 | 5.80648
US dollar | 0.6325 | 1.58103
[NAME] | 0.14743 | 6.78293
Vietnamese dong | 3e-05 | 32861.65952
Zimbabwe dollar | 0.00165 | 608.08755
Spreadsheet: 272108d1382205352-help-extracting-text-from-column-if-two-other-columns-match-test
Sheet: Data

[NAME] | Mar 2013 | 75
[NAME] | Apr 2013 | 7
[NAME] | Jul 2013 | 812
[NAME] | Aug 2013 | 75
Sue | Mar 2013 | 2
Sue | Apr 2013 | 75
[NAME] | Jan 2013 | 753
[NAME] | Feb 2013 | 2
[NAME] | Mar 2013 | 5
[NAME] | Apr 2013 | 756
Spreadsheet: 0fc70a45-29b3-4174-8051-1378c791c3fc
Sheet: Sheet1

What's in Season - Northern California | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Vegetables | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Asian Greens
Asparagus
Beans
Broccoli
[NAME]
Carrots
Cauliflower
Celery
Corn
[NAME]
Eggplant
[NAME]
Lettuce
Mushrooms
Onions
Parsnips
Peas
Peppers
Potatoes
Spinach
Squash, summer
Squash, winter
Sweet potatoes
Tomatoes
Fruit
Apples
Apricots
Blackberries
Blueberries
Boysenberries
Cantaloupe
Cherries
Citrus
Dates
[NAME]
Grapes
Kiwi
Melons
Fruit | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Nectarines
Peaches
Pears
Persimmons
Plums
Pluots
Pomegranates
Prunes
Raspberries
Strawberries
Watermelon
Spreadsheet: 723476d1615727845-search-for-a-value-in-a-worksheet-and-based-on-its-address-add-another-value-to-an-average-test_sheet_2
Sheet: FollowersGrowth2

Follower Growth tracker
Week Beginning | Week no: | Followers | Unfollowers | Growth
2021-01-04 00:00:00 |  | 3 | 2
 |  | 3 | 2
 |  | 33 | 3
 |  | 332 | 2
 |  | 33 | 3
 |  | 22
Spreadsheet: 220952d1363324578-creating-daily-report-report
Sheet: Balance Sheet

Date | Previous Balance | Present Balance | ATM | Deposit | Total Balance
2013-03-13 00:00:00 | 0 | 0 | 0 | 0 | 0
2013-03-14 00:00:00 | 0 | 47 | 10 | 25 | 12
2013-03-15 00:00:00 | 12
Spreadsheet: 700720d1603302489-if-formula-problems-clin-tracking-base-year-10012020lkf
Sheet: INVOICEDPARTS

 |  |  |  | 10 | 11 | 12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
PR/PO # | VENDOR | DATE | AMOUNT | OCTOBER | NOVEMBER | DECEMBER | JANUARY | FEBRUARY | [NAME] | APRIL | MAY | [NAME] | JULY | AUGUST | SEPTEMBER | OCTOBER
 | Total
 | 0.0868
 | Total
Spreadsheet: 885768d1735607918-get-a-new-list-from-one-column-to-a-new-column-treasurer-report-redacted
Sheet: Categories

Categories
50 Cent Drawing
[NAME]
Awards
Convention Assessment
Convention Fund Delegate
Convention Fund -Delegate
DC Travel Fund
[NAME]
Dues
Dues - International
Dues - Local
Dues & Lifeflight
Editor
Heartspring Collected
Heartspring Expense
Lifeflight
Miscellaneous Expense
Miscellaneous Income
[NAME]
[NAME]
Room Rent
Transfer From Savings
Spreadsheet: 46514d1245346848-determining-discounts-on-an-invoice-invoice
Sheet: Service Invoice

Westerley |  |  | INVOICE NO. | [1]
Mount Carbis Road |  |  | DATE | 2009-06-18 00:00:00
Redruth
TR15 2LD
TO | [Name]
 | [Company Name]
 | [Street Address]
 | [City, ST  ZIP Code]
 | [Phone]
SALESPERSON |  | JOB | PAYMENT TERMS |  | DUE DATE
[NAME] |  |  | Due upon receipt
QUANTITY | [NAME] |  |  | UNIT PRICE | LINE TOTAL
 |  |  |  | SUBTOTAL
 |  |  |  | SALES TAX
 |  |  |  | TOTAL
 | Make all checks payable to [Your Company Name] THANK YOU FOR YOUR BUSINESS!
Spreadsheet: 267927d1380295053-grouping-help-example-1
Sheet: Sheet1

id | [NAME] Name | Last Name | Diag Code | Description
[PHONE] | [NAME] | Doe | 428.0 | CONGESTIVE HEART FAILURE UNSPECIFIED
[PHONE] | [NAME] | Doe | 746.85 | CONGENITAL CORONARY ARTERY ANOMALY
[PHONE] | Sandy | Doe 2 | 436 | ACUTE BUT ILL-DEFINED CEREBROVASCULAR DISEASE
[PHONE] | Sandy | Doe 2 | 438.9 | UNSPEC LATE EFF CEREBRVASC DZ DUE CEREBRVASC DZ
[PHONE] | Sandy | Doe 2 | 414.01 | CORONARY ATHEROSCLEROSIS NATIVE CORONARY ARTERY
[PHONE] | [NAME] | Doe 3 | 585.6 | END STAGE RENAL DISEASE
[PHONE] | [NAME] | Doe 3 | 799.3 | UNSPECIFIED DEBILITY
26701299264701 | [NAME] | D0E 4 | 585.6 | END STAGE RENAL DISEASE
26701299264701 | [NAME] | D0E 4 | 586 | UNSPECIFIED RENAL FAILURE
26701299264701 | [NAME] | D0E 4 | 185 | MALIGNANT NEOPLASM OF PROSTATE
[PHONE] | [NAME] | DOE 5 | 414.00 | COR ATHEROSLERO UNSPEC TYPE VESSEL NATIVE/GRAFT
[PHONE] | Shaya | DOE 6 | 414.00 | COR ATHEROSLERO UNSPEC TYPE VESSEL NATIVE/GRAFT
[PHONE] | Shaya | DOE 6 | 438.9 | UNSPEC LATE EFF CEREBRVASC DZ DUE CEREBRVASC DZ
[NAME] I would like to achieve
id | [NAME] Name | Last Name | Diag Code | [NAME]
[PHONE] | [NAME] | Doe | ( 428.0, 746.85) | CONGESTIVE HEART FAILURE UNSPECIFIED,CONGENITAL CORONARY ARTERY ANOMALY
[PHONE] | Sandy | Doe 2 | (436,  438.9, 414.01) | ACUTE BUT ILL-DEFINED CEREBROVASCULAR DISEASE, UNSPEC LATE EFF CEREBRVASC DZ DUE CEREBRVASC DZ
[PHONE] | [NAME] | Doe 3 | (585.6, 799.3) | END STAGE RENAL DISEASE, UNSPECIFIED DEBILITY
26701299264701 | [NAME] | D0E 4 | (585.6, 586) | END STAGE RENAL DISEASE, UNSPECIFIED RENAL FAILURE
[PHONE] | [NAME] | DOE 5 | -414 | COR ATHEROSLERO UNSPEC TYPE VESSEL NATIVE/GRAFT
[PHONE] | Shaya | DOE 6 | (414.00, 438.9) | COR ATHEROSLERO UNSPEC TYPE VESSEL NATIVE/GRAFT,  UNSPEC LATE EFF CEREBRVASC DZ DUE CEREBRVASC DZ
Spreadsheet: 872907d1719364302-alternate-formula-to-filter-data-based-on-criteria-sample
Sheet: Sheet1

 | MSFT |  | 2008-01-01 00:00:00 | 2024-06-21 00:00:00
 | Ticker |  | Start | End
 | Date | Close | Year
Spreadsheet: 34941d1232396675-checklist-problem-linking-multiple-options-together-checklisttest
Sheet: Sheet1

Option | Checklist
518741
518743
518744 | x |  |  | I want option 518752 to be checked "x" when 518744 is checked
518622
518621
518622
518844
518944
518844
518941
518622
518744
518745
518746
518747
518748
518749
518750
518751
518752 | x
Spreadsheet: 193582d1352882292-filtering-problem-sumif
Sheet: Sheet2

Project | Total Cost |  | Project | Total
1 | 903790955 |  | 1 | 3658245609
2 | 903790955
3 | 903790955
5 | 948863332
6 | 948863332
9 | 948863332
4 | 873161482
8 | 873161482
6 | 873161482
3 | 1028357159
2 | 1028357159
5 | 1028357159
9 | 1054349474
7 | 1054349474
4 | 1054349474
5 | 1015440456
6 | 1015440456
3 | 1015440456
2 | 928265311
1 | 928265311
4 | 928265311
5 | 926816014
6 | 926816014
9 | 926816014
8 | 976100958
3 | 976100958
9 | 976100958
6 | 817998734
8 | 817998734
7 | 817998734
4 | 903590367
5 | 903590367
6 | 903590367
3 | 897683641
2 | 897683641
1 | 897683641
5 | 730085416
9 | 730085416
8 | 730085416
6 | 771550706
7 | 771550706
4 | 771550706
8 | 782815062
5 | 782815062
6 | 782815062
9 | 638409071
8 | 638409071
7 | 638409071
4 | 671578974
5 | 671578974
6 | 671578974
3 | 703465702
2 | 703465702
1 | 703465702
2 | 423461537
3 | 423461537
6 | 423461537
9 | 62550780
8 | 62550780
7 | 62550780
9 | 314512815
8 | 314512815
7 | 314512815
4 | 344816923
5 | 344816923
6 | 344816923
3 | 598077259
2 | 598077259
6 | 598077259
5 | 618844132
9 | 618844132
7 | 618844132
4 | 2375200000
5 | 334733255
6 | 334733255
5 | 121129846
2 | 1725919
3 | 1725919
6 | 1725919
9 | 842306599
6 | 842306599
5 | 842306599
2 | 919776361
3 | 113490000
6 | 113490000
5 | 113490000
4 | 225040000
1 | 225040000
2 | 225040000
6 | 225040000
9 | 225040000
7 | 225040000
8 | 1075435806
5 | 1075435806
6 | 1075435806
2 | 1126965207
5 | 1126965207
5 | 1126965207
3 | 984885728
6 | 984885728
Spreadsheet: 782833d1654314051-index-range-and-return-column-header-when-value-greater-than-0-excel_help_upload
Sheet: Sheet1

Product name | Amazon | HN | Catch | Costco | DJ | THX | H | KWH | MBX | MMX | MY | POK | VB | Min Price > 0 | [NAME]
Item 1 | 67.2 |  | 59.95 |  | 0 |  |  |  |  | 37.82
Item 2 | 70.37 |  | 59.95 |  |  |  |  |  |  |  |  | 0
Item 3 | 17.5 |  |  |  |  |  | 8.99 | 8.95 |  |  |  | 0 | 8.95
Item 4 | 68.88 |  |  |  |  |  |  |  |  |  |  | 0
Item 5 | 91.82 |  |  |  |  |  |  | 84.95
Item 6 |  |  |  |  |  |  |  |  |  | 18 |  | 18 | 19.95
Spreadsheet: 05d21891-d515-407e-ad4b-46f96991f49d
Sheet: qryMultiSearch

Basin | 8 Digit HUC | Level IV Ecoregion | Waterbody | Station | County | Latitude | Longitude | Date | Collection No. | Scientific Name | No. Collected
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Ambloplites rupestris | 14
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Campostoma anomalum | 13
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Lepomis auritus | 6
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Lepomis macrochirus | 4
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Luxilus coccogenis | 105
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Nocomis leptocephalus | 85
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Notropis spectrunculus | 59
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Rhinichthys obtusus | 2
SAV | Seneca River | Southern Crystalline Ridges & Mountains | Horsepasture R | NC 281 | Transylvania | 35.0922222222222 | -82.9761111111111 | 1995-05-02 00:00:00 | 95-37 | Salmo trutta | 1
SAV | Tugaloo River | Southern Crystalline Ridges & Mountains | [NAME] | SR 1107 | [NAME] | 35.0591666666667 | -83.1327777777778 | 1995-05-02 00:00:00 | 95-35 | Lepomis auritus | 46
SAV | Tugaloo River | Southern Crystalline Ridges & Mountains | [NAME] | SR 1107 | [NAME] | 35.0591666666667 | -83.1327777777778 | 1995-05-02 00:00:00 | 95-35 | Nocomis leptocephalus | 247
SAV | Tugaloo River | Southern Crystalline Ridges & Mountains | [NAME] | SR 1107 | [NAME] | 35.0591666666667 | -83.1327777777778 | 1995-05-02 00:00:00 | 95-35 | Rhinichthys obtusus | 7
SAV | Tugaloo River | Southern Crystalline Ridges & Mountains | [NAME] | SR 1107 | [NAME] | 35.0591666666667 | -83.1327777777778 | 1995-05-02 00:00:00 | 95-35 | Salmo trutta | 8
SAV | Tugaloo River | Southern Crystalline Ridges & Mountains | [NAME] | SR 1107 | [NAME] | 35.0591666666667 | -83.1327777777778 | 1995-05-02 00:00:00 | 95-35 | Scartomyzon rupiscartes | 61
Spreadsheet: 126570d1319747749-excel-2007-grouping-in-pivot-tables-pivotdatatwotables
Sheet: Sheet2

 | Row Labels | Sum of Amt
 | 10/27/2010 - 11/2/2010 | 341
 | 11/3/2010 - 11/9/2010 | 279
 | 11/10/2010 - 11/16/2010 | 249
 | 11/17/2010 - 11/23/2010 | 359
 | 11/24/2010 - 11/30/2010 | 270
 | 12/1/2010 - 12/7/2010 | 311
 | 12/8/2010 - 12/14/2010 | 176
 | 12/15/2010 - 12/21/2010 | 245
 | 12/22/2010 - 12/28/2010 | 367
 | 12/29/2010 - 1/4/2011 | 389
 | 1/5/2011 - 1/11/2011 | 258
 | 1/12/2011 - 1/18/2011 | 239
 | 1/19/2011 - 1/25/2011 | 168
 | 1/26/2011 - 2/1/2011 | 241
 | 2/2/2011 - 2/8/2011 | 200
 | 2/9/2011 - 2/15/2011 | 245
 | 2/16/2011 - 2/22/2011 | 76
 | 2/23/2011 - 3/1/2011 | 183
 | 3/2/2011 - 3/8/2011 | 156
 | 3/9/2011 - 3/15/2011 | 148
 | 3/16/2011 - 3/22/2011 | 108
 | 3/23/2011 - 3/29/2011 | 203
 | 3/30/2011 - 4/5/2011 | 224
 | 4/6/2011 - 4/12/2011 | 242
 | 4/13/2011 - 4/19/2011 | 310
 | 4/20/2011 - 4/26/2011 | 143
 | 4/27/2011 - 5/3/2011 | 242
 | 5/4/2011 - 5/10/2011 | 190
 | 5/11/2011 - 5/17/2011 | 238
 | 5/18/2011 - 5/24/2011 | 297
 | 5/25/2011 - 5/31/2011 | 240
 | 6/1/2011 - 6/7/2011 | 223
 | 6/8/2011 - 6/14/2011 | 231
 | 6/15/2011 - 6/21/2011 | 201
 | 6/22/2011 - 6/28/2011 | 264
 | 6/29/2011 - 7/5/2011 | 221
 | 7/6/2011 - 7/12/2011 | 202
 | 7/13/2011 - 7/19/2011 | 280
 | 7/20/2011 - 7/26/2011 | 231
 | 7/27/2011 - 8/2/2011 | 302
 | 8/3/2011 - 8/9/2011 | 279
 | 8/10/2011 - 8/16/2011 | 181
 | 8/17/2011 - 8/23/2011 | 263
 | 8/24/2011 - 8/30/2011 | 202
 | 8/31/2011 - 9/6/2011 | 270
 | 9/7/2011 - 9/13/2011 | 241
 | 9/14/2011 - 9/20/2011 | 389
 | 9/21/2011 - 9/27/2011 | 338
 | 9/28/2011 - 10/4/2011 | 311
 | 10/5/2011 - 10/11/2011 | 174
 | 10/12/2011 - 10/18/2011 | 178
 | 10/19/2011 - 10/25/2011 | 344
 | 10/26/2011 - 10/27/2011 | 5
 | Grand Total | 12667