tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677060d1589178975-looking-for-the-formula-used-in-this-basic-income-tax-withheld-spreadsheet-2020-05-11-oeldere-scottc72-677037d1589164004-looking-for-the-formula-used-in-this-basic-inc
Sheet: Sheet1

TAX BRACKET CALCULATOR
TAXABLE INCOME $
Tax OWED ON THIS INCOME
tax brackets |  |  |  | Next tax bracket | how much tax | Rate
0 | 18200 | Nil |  | 0 | 0 | 0
18201 | 37000 | 19c for each $1 over $18,200 |  | 18200 | 0 | 0.19
37001 | 90000 | $3,572 plus 32.5c for each $1 over $37,000 |  | 37000 |  | 0.325
90001 | 180000 | $20,797 plus 37c for each $1 over $90,000 |  | 90000 |  | 0.37
180001 | or higher | $54,097 plus 45c for each $1 over $180,000 |  | 180000 |  | 0.45
 | weekly pay | 5000 |  |  |  |  |  |  | week
 | weekly tax
 | net
Spreadsheet: mike_carson__27608__KOCH
Sheet: Sheet1

 | Power for delivery
 | On-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit | EPMI | Total
 |  | Postion | Price |  | Fee | COST | Dollars
 | Entergy | 100 | 18.75 |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -700 | 19.6 |  | 1
 | Comed | -100 | 20.25 |  | 1
 | Off-Peak
 |  | EPMI | [NAME]'s
 |  | MW | AVG |  | Credit |  | Total
 |  | Postion | Price |  | Fee |  | Dollars
 | Entergy | 0 |  |  | 1
 | TVA | 0 |  |  | 1
 | Cinergy | -50 | 14 |  | 1
 | Comed | 0 |  |  | 1
 |  |  |  |  | Total
 |  |  |  |  |  | Net AMT
Spreadsheet: 98418d1297324082-dynamic-data-tables-book2
Sheet: Sheet1

 |  | unit |  | 1 | 2 | 3
 |  | income |  | 3 | 4 | 5
 |  | expense |  | 0.5 | 0.4 | 0.3
 |  | revenue
 |  | tax |  | 0.1 | 0.14 | 0.15
 |  | NI
 |  | unit | 3 | <-- drop-down list
 |  |  | expense and tax effect on NI
 |  |  |  | expense
 |  |  |  | 0.4 | 0.5 | 0.6
 |  | tax | 0.05 |  | 3.995 | 3.995
 |  |  | 0.1 | 3.995 | 3.995 | 3.995
 |  |  | 0.15 | 3.995 | 3.995 | 3.995
Spreadsheet: 802841d1667064903-aggregate-function-problem-in-expenses-spreadshhet-expenses
Sheet: Results required

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IFERROR(INDEX(Report!AA:AA,AGGREGATE(15,6,ROW(Report!$AA$5:$AA$2000)/(COUNTIF(Report!$AA$5:$AA$2000,Report!$AA$5:$AA$200)=AU25),1)),"")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is th [NAME] I cant make work in AU2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | There are hundreds of green codes - so the final result will be a very wide spreadsheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | There us average of about 5000 lines of expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Each individual expense is then printed below line 25 for each code- that bit I have had not trouble with - I just cant create the summary at the top
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 |  |  |  |  | AAA222 |  |  |  |  | BBB111 |  |  |  |  | CCC111
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: ManualTurning

Detail No. | Quantity | [NAME] | Tool Setting | Setting Up Time | Gauge Manufacture | Drilling | Reaming | Tapping | External Threading | Internal Threading | Boring | General Turning Time | Polishing | Tips | Other | Total Time (hours) | NOTES
 | 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
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
. |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0
Spreadsheet: 888019d1738332647-text-to-number-formula-needed-if-function-text-and-number
Sheet: Sheet1

 |  | PRICE | SIMPLE FORMULA |  | REQUIRED ANSWER WITH FORMULA
 |  | False
 |  | False
 |  | False
 |  | False
 |  | False |  |  | 0
 |  | 2021.45
 |  | False
 |  | False |  |  | 0
 |  | 2008.400000000001
 |  | 1789.75
 |  | 1765.25
 |  | False |  |  | 0
 |  | 1510
 |  | 1731.2
Spreadsheet: 116904d1312288604-correction-in-the-if-and-vlookup-formula-required-book1
Sheet: Sheet1

 |  | ProjectName |  |  |  |  |  |  |  | Activity | X | Y | Z
Activity 1 |  | Y |  |  |  |  |  |  |  | Documentation | 1 | 2 | 2
 |  | Documentation |  |  |  |  |  |  |  | Execution | 1.85 | 1.6 | 1.5
 |  |  |  |  |  |  |  |  |  | Review | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | Corrections | 0.87 | 0.65 | 0.75
 |  | IF I select x it is giving me the correct data
 |  | but If I am selecting Y it is adding the value under x and y
 |  | If I select x it should match C5 with Activity list and display value under x
 |  | If I select y it should match C5 with Activity list and display the value under y
Spreadsheet: 0a1f4372-03ed-4dff-9395-453dc83efdcb
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
 | 5671.0 Lending Finance, Australia
 | TABLE 10. LEASE FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($000)
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
Motor cars and station wagons - New ; |  |  | Original | A2413502X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Motor cars and station wagons - Used ; |  |  | Original | A2413503A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Light trucks - New ; |  |  | Original | A2413504C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Light trucks - Used ; |  |  | Original | A2413505F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Heavy trucks - New ; |  |  | Original | A2413506J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Heavy trucks - Used ; |  |  | Original | A2413507K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
Other motor vehicles ; |  |  | Original | A2413508L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2413509R | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: GNH - CS-SPD BULK

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS-SPD BULK
FACILITY: | GREY NUNS HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X | X | X | X
** If more/less linen required please fax in this order by 7:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
20-WRAPPER 18" |  |  |  | BP0002 |  | 7
20-WRAPPER 24" |  |  |  | BP0003 |  | 10
20-WRAPPER 30" |  |  |  | BP0004 |  | 6
20-WRAPPER 36" |  |  |  | BP0005 |  | 9
20-WRAPPER 45" |  |  |  | BP0006 |  | 6
20-WRAPPER 54" |  |  |  | BP0007 |  | 5
100-HUCK TOWEL |  |  |  | BP0010 |  | 3
5-SM FEN DRAPES |  |  |  | BP0012 |  | 2
10-MED FEN DRAPE |  |  |  | BP0025 |  | 2
5-SORTER APRONS MED |  |  |  | BP0057 |  | 3
5-DELIVERY SOAKERS |  |  |  | BP0018 |  | 1
5-ISO GOWN GREEN |  |  |  | GL0010 |  | 4
UPDATED:
June 17th 2009
Spreadsheet: 51076d1250642912-automatically-updated-worksheets-forumquestion-3-
Sheet: Location - CA

Name | Location | Time | Type | ca
[NAME] | CA | Day | A
Michelle | CA | Day | C
[NAME] | CA | Night | A
Jessica | CA | Night | B
Spreadsheet: 799106d1664919090-pull-specific-values-tied-to-names-to-two-separate-columns-with-exclusion-tips
Sheet: Sheet1

 | Team Member | Total eTips | Upsell Total | Google Tally | Absences Tally | eTip Payout | Comm. Payout | Adjustments
 | [NAME] | 71.26 | 292.62
 | Blake | 284.34 | 790
 | [NAME] | 70
 | [NAME] | 49.63
 | Adjustments
 | Employee |  |  |  | Reason | Amount (Each Employee)
 | [NAME] | Blake |  |  | Tip | 10 |  | Absences | 0.33
 | [NAME] |  |  |  | Tip | 30 |  | Processing Fee | 0.95
 | [NAME] |  |  |  | Called In | 20 |  | Commissions | 0.2
 | Blake | [NAME] |  |  | Tip | 15
 | [NAME] |  |  |  | Reimbursement | 50
 | [NAME] |  |  |  | Called In | 20
 | [NAME] | Sy |  |  | Lost Tool | -10
 | [NAME] |  |  |  | Bonus | 50
 | Already Done: | "Adjustments" in column I already pull automatically from B11:G20 based on employee name (B11:F20) relative to it matching the name in B3:B6 and sums the total amount with every instance of an adjustment in G11:G20 |  |  |  | "Adjustments" in column I already pull automatically from B11:G20 based on employee name (B11:F20) relative to it matching the name in B3:B6 and sums the total amount with every instance of an adjustment in G11:G20
 | Goals/Trying to Do: | Trying to get only "Tip" instances listed in F11:F20 to get added to "eTip Payout" (column G). "eTip Payout" from column G already pulls from "Total eTips" in C3:C6 |  |  |  | All other "Reasons" that are listed in F11:F20, I'm trying to get pulled into "Adjustments" I3:I6 that match names in both spots
 |  | All other "Reasons" that are listed in F11:F20, I'm trying to get pulled into "Adjustments" I3:I6 that match names in both spots
 |  | So I basically need to find out how to find certain tip instances while excluding all other "Reasons" and vice versa
Spreadsheet: 839101d1691658790-different-values-corresponding-to-chosen-data-catering
Sheet: List1

Poskytnuté stravování zaměstnavatelem / Provided catering
(označte "x", mark "x")
 |  | Snídaně / Breakfast | Oběd / Lunch | Večeře / Dinner |  | Od |  | Od |  | [NAME] | Sazba | Dle doby | Krácení | Celkem v EUR | Kurz CZK/EUR | Celkem v CZK
1. den / day |  | x |  |  |  | 9 | 12 | 24 | 0 |  | 60 |  |  |  | 23.5
2. den / day |  | x |  |  |  | 0 | 0 | 17 | 24 |  | 60
3. den / day |  |  |  |  |  |  |  |  |  |  | 60
4. den / day |  |  |  |  |  |  |  |  |  |  | 60
5. den / day |  |  |  |  |  |  |  |  |  |  | 60
Spreadsheet: 58cc6acb-fc2d-4155-bbf4-c75d9e2de0ef
Sheet: Sheet1

Project Name: | Enter Multi-particiant Project Name | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
Date Analyzed: | Enter Date |  | Participant Agency or Group Name: |  |  | Enter the Name of the Agency or Group Covered by this [NAME]
Net Present Value (Net Benefits): | 0
Annualized Return on Investment:
[NAME]: | This Year
Payback Period (in Years): | 0
Inflation Rate: | 0.025
Opportunity Cost of Capital: | 0.05
Project Years Indicators: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Project Year Labels: | This Year | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Year 13 | Year 14 | Year 15 | Year 16 | Year 17 | Year 18 | Year 19 | Year 20
Project Life (Number of Years): | 20
Method for Determining Future Years' Cost of Labor:
Derived by Applying Inflation Rate to Current Costs
Notes and Other Assumptions:
Enter notes here.
Options for Future Year Labor Cost Determination: |  |  | Effective Wage Multiplier: |  | 1.025
Independent of Assumed Inflation Rate (See Notes)
Derived by Applying Inflation Rate to Current Costs
Derived by Applying Average Annual Cost of Living Adjustment to Current Costs:
File Directory and Name:
C:\Documents and Settings\nlerner\My Documents\Active Projects\GITA ROI Book\Templates\Multiparticipant Templates\[Financial Details-Future20.xls]Project Setup Sheet
Spreadsheet: e7981e95-7a18-4454-bdbc-fbc1911a358d
Sheet: Sheet1

EGENINNSATS for prosjektet: | Unnamed: 1 | <prosjektnavn> | Unnamed: 3 | Unnamed: 4
Bedrift/foretak: |  | <bedriftsnavn>
Navn på deltaker i prosjektet fra bedriften: |  | <navn>
(Timesatsen regnes ut etter NFR sine standardsater og er slik: Nominell årslønn x 0,0012
Nominell årslønn i kr | <Fyll ut årslønn her>
Timesats: |  | (fylles ut automatisk)
Fyll ut kolonnene nedenfor (timer og kostnader regnes ut automatisk):
År   2010
Dato | Antall timer | Hvilke oppgaver? | Sum timer
Sum timekostnader i perioden
Andre dokumenterte kostnader
Spesifiser hvilke og legg ved [NAME] eller lignende |  |  | Beløp
 |  |  |  | [NAME] nr
 |  |  |  | [NAME] nr
 |  |  |  | [NAME] nr
Sum andre kostnader |  |  | 0
Totale kostnader i perioden
Spreadsheet: 0187d702-c566-42f8-b2da-2e329d7cce7e
Sheet: Sheet1

Lowe's Companies, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Consolidated Statements of Current and Retained Earnings (Unaudited)
In Millions, Except Per Share Data
 |  | Three Months Ended |  |  |  | Six Months Ended
 |  | August 4, 2006 |  | July 29, 2005 |  | August 4, 2006 |  | July 29, 2005
Current Earnings |  | Amount | Percent | Amount | Percent | Amount | Percent | Amount | Percent
Net sales |  | 13389 | 100 | 11929 | 100 | 25310 | 100 | 21842 | 100
Cost of sales |  | 8911 | 66.56 | 7902 | 66.24 | 16664 | 65.84 | 14417 | 66.01
Gross margin |  | 4478 | 33.44 | 4027 | 33.76 | 8646 | 34.16 | 7425 | 33.99
Expenses:
Selling, general and administrative |  | 2617 | 19.54 | 2363 | 19.81 | 5083 | 20.09 | 4499 | 20.6
Store opening costs |  | 28 | 0.21 | 25 | 0.21 | 53 | 0.2 | 50 | 0.23
Depreciation |  | 283 | 2.11 | 236 | 1.97 | 557 | 2.2 | 473 | 2.16
Interest |  | 30 | 0.23 | 39 | 0.33 | 65 | 0.26 | 86 | 0.39
Total expenses |  | 2958 | 22.09 | 2663 | 22.32 | 5758 | 22.75 | 5108 | 23.38
Pre-tax earnings |  | 1520 | 11.35 | 1364 | 11.44 | 2888 | 11.41 | 2317 | 10.61
Income tax provision |  | 585 | 4.37 | 525 | 4.41 | 1112 | 4.39 | 892 | 4.08
Net earnings |  | 935 | 6.98 | 839 | 7.03 | 1776 | 7.02 | 1425 | 6.53
Weighted average shares outstanding - Basic |  | 1541 |  | 1548 |  | 1549 |  | 1548
Basic earnings per share |  | 0.61 |  | 0.54 |  | 1.15 |  | 0.92
Weighted average shares outstanding - Diluted |  | 1571 |  | 1605 |  | 1580 |  | 1608
Diluted earnings per share |  | 0.6 |  | 0.52 |  | 1.13 |  | 0.89
Cash dividends per share |  | 0.05 |  | 0.03 |  | 0.08 |  | 0.05
[NAME]
Balance at beginning of period |  | 12985 |  | 10152 |  | 12191 |  | 9597
Net earnings |  | 935 |  | 839 |  | 1776 |  | 1425
Cash dividends |  | -77 |  | -47 |  | -124 |  | -78
Balance at end of period |  | 13843 |  | 10944 |  | 13843 |  | 10944
Spreadsheet: 824137d1680332832-get-data-from-other-files-overview-invoices-v2
Sheet: Overview

[NAME] | Factuur | Factuurdatum | Vervaldatum | excl BTW | BTW | Totaal bedrag
= cell [NAME] of the invoice | = cell c19 of the invoice | = cell c20 of the invoice | = cell c21 of the invoice | = cell H41 of the invoice | = cell H44 of the invoice | = cell H44 of the invoice
= cell [NAME] of the invoice | = cell c19 of the invoice | = cell c20 of the invoice | = cell c21 of the invoice | = cell H41 of the invoice | = cell H44 of the invoice | = cell H44 of the invoice
= cell [NAME] of the invoice | = cell c19 of the invoice | = cell c20 of the invoice | = cell c21 of the invoice | = cell H41 of the invoice | = cell H44 of the invoice | = cell H44 of the invoice
= cell [NAME] of the invoice | = cell c19 of the invoice | = cell c20 of the invoice | = cell c21 of the invoice | = cell H41 of the invoice | = cell H44 of the invoice | = cell H44 of the invoice
= cell [NAME] of the invoice | = cell c19 of the invoice | = cell c20 of the invoice | = cell c21 of the invoice | = cell H41 of the invoice | = cell H44 of the invoice | = cell H44 of the invoice
Spreadsheet: 106f88dc-7a7a-4f9a-909d-1f96170cf204
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | SUPPLEMENTAL FUNDS-SOURCES & USE | FY13-14 | FY14-15 | TOTAL 13-15
ARCHITECTURAL/ENGINEERING DESIGN SERVICES
TOTAL ARCHITECTURAL/ENGINEERING DESIGN SERVICES |  |  | 0 | 0 | 0
PERMITS/FEES
TOTAL PERMITS/FEES |  |  | 0 | 0 | 0
CONSTRUCTION COSTS
TOTAL CONSTRUCTION COSTS |  |  | 0 | 0 | 0
CONSTRUCTION MANAGEMENT
 |  |  |  | 0
TOTAL CONSTRUCTION MANAGEMENT |  |  | 0 | 0 | 0
TOTAL EXPENSES |  |  | 0 | 0 | 0
Spreadsheet: 770778d1646246293-unique-and-filter-inside-countif-s-function-unique-filter-inside-countifs-function
Sheet: Sheet1

Subject | Student | Score |  |  | Subject | Score
ENGLISH | [NAME] | D |  |  | BIOLOGY | A |  |  |  |  |  | A |  |  |  | 3
PHYSICS | [NAME] | B |  |  |  | C |  |  | #[NAME]! |  | BIOLOGY | C |  |  | CHEMISTRY | 1
ENGLISH | Doe | E |  |  |  | D |  |  | #[NAME]! |  | BIOLOGY | D |  |  | ENGLISH | 3
HISTORY | [NAME] | E |  |  | CHEMISTRY | A |  |  | #[NAME]! |  | CHEMISTRY | A |  |  | GEOGRAPHY | 2
GEOGRAPHY | [NAME] | B |  |  | ENGLISH | A |  |  | #[NAME]! |  | ENGLISH | A |  |  | HISTORY | 3
ENGLISH | [NAME] | A |  |  |  | D |  |  | #[NAME]! |  | ENGLISH | D |  |  | MATHEMATICS | 1
GEOGRAPHY | [NAME] | A |  |  |  | E |  |  | #[NAME]! |  | ENGLISH | E |  |  | PHYSICS | 3
ENGLISH | Doe | D |  |  | GEOGRAPHY | A |  |  | #[NAME]! |  | GEOGRAPHY | A
PHYSICS | [NAME] | A |  |  |  | B |  |  | #[NAME]! |  | GEOGRAPHY | B
HISTORY | [NAME] | A |  |  | HISTORY | A |  |  | #[NAME]! |  | HISTORY | A |  |  |  | 3
GEOGRAPHY | [NAME] | A |  |  |  | C |  |  | #[NAME]! |  | HISTORY | C |  |  | CHEMISTRY | 1
PHYSICS | [NAME] | D |  |  |  | E |  |  | #[NAME]! |  | HISTORY | E |  |  | ENGLISH | 3
MATHEMATICS | Doe | B |  |  | MATHEMATICS | B |  |  | #[NAME]! |  | MATHEMATICS | B |  |  | GEOGRAPHY | 2
HISTORY | [NAME] | C |  |  | PHYSICS | A |  |  | #[NAME]! |  | PHYSICS | A |  |  | HISTORY | 3
PHYSICS | [NAME] | B |  |  |  | B |  |  | #[NAME]! |  | PHYSICS | B |  |  | MATHEMATICS | 1
BIOLOGY | [NAME] | A |  |  |  | D |  |  | #[NAME]! |  | PHYSICS | D |  |  | PHYSICS | 3
PHYSICS | [NAME] | A
BIOLOGY | [NAME] | D
CHEMISTRY | Doe | A
BIOLOGY | [NAME] | A
BIOLOGY | [NAME] | A |  |  | Subject | Score | Count of Student | Distinct Count |  |  | Subject | Score | Count | Distinct Count
BIOLOGY | [NAME] | C |  |  | BIOLOGY | A | 3 | 2 |  |  |  | A | 3 | 2
 |  |  |  |  |  | C | 1 | 1 |  |  | BIOLOGY | C | 1 | 1
 |  |  |  |  |  | D | 1 | 1 |  |  | BIOLOGY | D | 1 | 1
 |  |  |  |  | CHEMISTRY | A | 1 | 1 |  |  | CHEMISTRY | A | 1 | 1
 |  |  |  |  | ENGLISH | A | 1 | 1 |  |  | ENGLISH | A | 1 | 1
 |  |  |  |  |  | D | 2 | 2 |  |  | ENGLISH | D | 2 | 2
 |  |  |  |  |  | E | 1 | 1 |  |  | ENGLISH | E | 1 | 1
 |  |  |  |  | GEOGRAPHY | A | 2 | 2 |  |  | GEOGRAPHY | A | 2 | 2
 |  |  |  |  |  | B | 1 | 1 |  |  | GEOGRAPHY | B | 1 | 1
 |  |  |  |  | HISTORY | A | 1 | 1 |  |  | HISTORY | A | 1 | 1
 |  |  |  |  |  | C | 1 | 1 |  |  | HISTORY | C | 1 | 1
 |  |  |  |  |  | E | 1 | 1 |  |  | HISTORY | E | 1 | 1
 |  |  |  |  | MATHEMATICS | B | 1 | 1 |  |  | MATHEMATICS | B | 1 | 1
 |  |  |  |  | PHYSICS | A | 2 | 2 |  |  | PHYSICS | A | 2 | 2
 |  |  |  |  |  | B | 2 | 2 |  |  | PHYSICS | B | 2 | 2
 |  |  |  |  |  | D | 1 | 1 |  |  | PHYSICS | D | 1 | 1
 |  |  |  |  | Grand Total |  | 22 | 5
Spreadsheet: 777489d1650421826-help-with-multiple-dates-and-values-to-count-occurrences-ohio-river-flood-crest-date-info-qts18-
Sheet: Crests

high  rank | date recent  rank
16 | 1 | 46.12 | ft | 2021-03-07 00:00:00 |  |  | 11 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52
26 | 2 | 44.53 | ft | 2020-02-17 00:00:00
24 | 3 | 44.91 | ft | 2019-02-28 00:00:00
15 | 4 | 46.45 | ft | 2019-02-15 00:00:00
7 | 5 | 50.68 | ft | 2018-02-27 00:00:00
35 | 6 | 42.97 | ft | 2015-12-30 00:00:00
38 | 7 | 42.3 | ft | 2015-04-18 00:00:00
12 | 8 | 47.33 | ft | 2015-03-17 00:00:00
8 | 9 | 49.3 | ft | 2011-04-28 00:00:00
21 | 10 | 45.32 | ft | 2011-03-15 00:00:00
42 | 11 | 41.5 | ft | 2010-05-07 00:00:00
22 | 12 | 45.04 | ft | 2008-03-22 00:00:00
18 | 13 | 46.05 | ft | 2005-01-14 00:00:00
32 | 14 | 43.55 | ft | 2004-01-09 00:00:00
41 | 15 | 41.56 | ft | 2003-02-28 00:00:00
34 | 16 | 43.25 | ft | 2002-03-25 00:00:00
25 | 17 | 44.69 | ft | 2000-02-22 00:00:00
5 | 18 | 52.42 | ft | 1997-03-08 00:00:00
29 | 19 | 44.3 | ft | 1996-05-13 00:00:00
19 | 20 | 46.03 | ft | 1996-01-27 00:00:00
28 | 21 | 44.32 | ft | 1995-05-23 00:00:00
37 | 22 | 42.5 | ft | 1994-04-20 00:00:00
30 | 23 | 44.1 | ft | 1994-03-16 00:00:00
27 | 24 | 44.52 | ft | 1994-02-01 00:00:00
39 | 25 | 42.04 | ft | 1993-03-10 00:00:00
14 | 26 | 46.85 | ft | 1991-01-05 00:00:00
23 | 27 | 45 | ft | 1990-12-25 00:00:00
31 | 28 | 43.63 | ft | 1990-02-17 00:00:00
17 | 29 | 46.08 | ft | 1989-02-21 00:00:00
36 | 30 | 42.51 | ft | 1985-12-04 00:00:00
20 | 31 | 45.85 | ft | 1984-05-12 00:00:00
9 | 32 | 49.08 | ft | 1978-12-15 00:00:00
40 | 33 | 41.94 | ft | 1977-04-11 00:00:00
33 | 34 | 43.5 | ft | 1976-02-23 00:00:00
13 | 35 | 46.9 | ft | 1972-04-21 00:00:00
43 | 36 | 41.2 | ft | 1971-02-25 00:00:00
44 | 37 | 41.2 | ft | 1971-02-25 00:00:00
3 | 38 | 53.9 | ft | 1964-03-08 00:00:00
11 | 39 | 48.8 | ft | 1962-03-06 00:00:00
6 | 40 | 51.3 | ft | 1948-04-20 00:00:00
2 | 41 | 54.4 | ft | 1945-03-08 00:00:00
10 | 42 | 48.9 | ft | 1943-03-24 00:00:00
1 | 43 | 60.8 | ft | 1937-01-27 00:00:00
4 | 44 | 53.8 | ft | 1913-04-01 00:00:00
Spreadsheet: dutch_quigley__9444__Calpine Nymex Quote
Sheet: Sheet1

Start Date | 2002-01-01 00:00:00
End Date | 2006-12-31 00:00:00
Date | Monthly Volume | Daily Equiv.
 | 2041600
 | 1846400
 | 2023200
 | 1988800
 | 2041600
 | 1952000
 | 2041600
 | 2041600
 | 1952000
 | 2060000
 | 1952000
 | 2023200
 | 2397120
 | 2169600
 | 2362560
 | 2344320
 | 2362560
 | 2309760
 | 2397120
 | 2362560
 | 2309760
 | 2431680
 | 2240640
 | 2397120
 | 2656320
 | 2493120
 | 2702400
 | 2609280
 | 2633280
 | 2609280
 | 2656320
 | 2679360
 | 2586240
 | 2656320
 | 2586240
 | 2702400
 | 2656320
 | 2423040
 | 2702400
 | 2586240
 | 2656320
 | 2609280
 | 2633280
 | 2702400
 | 2586240
 | 2656320
 | 2586240
 | 2656320
 | 2656320
 | 2423040
 | 2702400
 | 2563200
 | 2679360
 | 2609280
 | 2633280
 | 2702400
 | 2563200
 | 2679360
 | 2586240
 | 2633280