tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77222d1277739634-grab-only-necessary-data-make-new-sheet-example-of-data
Sheet: Sheet1

Name of Employee |  |  |  |  |  |  |  |  |  | 1907-02-26 00:00:00
 |  |  |  |  |  |  |  |  |  | 2000-01-01 00:00:00
 | 40002 | Position |  |  |  |  | 2009-11-05 00:00:00
 |  |  | 2010-05-01 00:00:00 |  | 15:00:00 |  | 00:30:00
 |  |  | 2010-05-02 00:00:00 |  | 14:30:00 |  | 22:30:00
 |  |  | 2010-05-03 00:00:00 |  | 15:00:00 |  | 23:00:00
 |  |  | 2010-05-04 00:00:00 |  | 15:00:00
 |  |  | 2010-05-05 00:00:00
 | 40002 | [NAME]
 |  |  | 2010-05-07 00:00:00 |  | 14:30:00 |  | 23:00:00
 |  |  | 2010-05-08 00:00:00 |  | 15:00:00 |  | 23:30:00
 |  |  | 2010-05-09 00:00:00 |  | 15:00:00
 |  |  | 2010-05-10 00:00:00 |  | 15:00:00 |  | 00:30:00
 |  |  | 2010-05-11 00:00:00 |  | 15:00:00
 |  |  | 2010-05-12 00:00:00
 | 40002 | [NAME]
 |  |  | 2010-05-14 00:00:00 |  | 15:30:00 |  | 23:30:00
 |  |  | 2010-05-15 00:00:00 |  | 16:30:00 |  | 01:00:00
 |  |  | 2010-05-16 00:00:00 |  | 15:30:00 |  | 00:30:00
 |  |  | 2010-05-17 00:00:00 |  | 15:00:00 |  | 00:30:00
 |  |  | 2010-05-18 00:00:00 |  | 14:30:00 |  | 23:30:00
 |  |  | 2010-05-19 00:00:00
 | 40002 | [NAME]
 |  |  | 2010-05-21 00:00:00 |  | 15:30:00
 |  |  | 2010-05-22 00:00:00 |  | 15:00:00 |  | 00:30:00
 |  |  | 2010-05-23 00:00:00 |  | 15:30:00 |  | 01:00:00
 |  |  | 2010-05-24 00:00:00 |  | 15:00:00 |  | 23:30:00
 |  |  | 2010-05-25 00:00:00 |  |  | 15:00:00
 |  |  | 2010-05-26 00:00:00
 | 40002 | [NAME]
 |  |  | 2010-05-28 00:00:00 |  |  | 14:30:00 |  |  | 23:30:00
 |  |  | 2010-05-29 00:00:00 |  |  | 14:30:00 |  |  | 23:00:00
 |  |  | 2010-05-30 00:00:00 |  |  | 14:30:00 |  |  | 23:30:00
 |  |  | 2010-05-31 00:00:00 |  |  | 14:30:00 |  |  | 23:30:00
Spreadsheet: 2a7a5df4-40ad-4466-aa25-e87b716dc89c
Sheet: Tble 12

Table 12
U.S. Export Balances and Cumulative Exports (1,000 metric tons)
 | Wheat |  |  |  |  |  | Corn | Soybeans | Total
Week ending | HRW | SRW | HRS | SWW | DUR | All wheat
Export Balances1
This week year ago
Cumulative exports-marketing year 2
2013/14 YTD
2012/13 YTD
YTD 2013/14 as % of 2012/13
Last 4 wks as % of  same period 2012/13
2012/13 Total | 10019 | 5039 | 5825 | 4619 | 591 |  | 17980 | 36220
2011/12 Total | 9904 | 4319 | 6312 | 5601 | 491 |  | 37900 | 36727
1 Current unshipped export sales to date
2 Shipped export sales to date; new marketing year in in effect for corn and soybeans
Note:  YTD = year-to-date.  Marketing Year: wheat = 6/01-5/31, corn & soybeans = 9/01-8/31
Source:  Foreign Agricultural Service/USDA (www.fas.usda.gov)
Spreadsheet: 183551d1348860111-matching-last-2-columns-with-date-2012-09-28-oeldere
Sheet: Blad1

letter | date | %
a, | 1-1-2012, | 0.1 |  |  | Rijlabels | Som van %
b, | 1-5-2012, | 0.2 |  |  | a, | 0.6000000000000001
a, | 1-6-2012, | 0.2 |  |  | 1-1-2012, | 0.1
b, | 2-1-2012, | 0.3 |  |  | 1-6-2012, | 0.2
c, | 2-1-2012, | 0.1 |  |  | 2-3-2012, | 0.3
a, | 2-3-2012, | 0.3 |  |  | b, | 0.5
 |  |  |  |  | 1-5-2012, | 0.2
 |  |  |  |  | 2-1-2012, | 0.3
 |  |  |  |  | c, | 0.1
 |  |  |  |  | 2-1-2012, | 0.1
 |  |  |  |  | Eindtotaal | 1.2
Spreadsheet: 838201d1690815042-calculate-a-value-based-on-several-conditions-dont-think-if-function-works-book1test
Sheet: Sheet1

NAME | MICROMARKET# | STORE QUALITY | MICROMARKET VALUE | STORE VALUE | VALUE BASED ON STORE QUALITY |  | Very Good | ???
STORE A | 1 | MEDIUM | 46632.75468800001 |  |  |  | Good | 1.2
STORE B | 1 | POOR | 46632.75468800001 |  | 20725.66875022223 |  | Medium | 1
STORE C | 2 | GOOD | 287956.669312 |  | 82273.33408914285 |  | Poor | 0.8
STORE E | 2 | MEDIUM | 287956.669312 |  | 68561.11174095239
STORE F | 2 | MEDIUM | 287956.669312 |  | 68561.11174095239
STORE G | 2 | MEDIUM | 287956.669312 |  | 68561.11174095239
STORE H | 3 | POOR | 164148.24192 |  | 22641.13681655173
STORE I | 3 | MEDIUM | 164148.24192 |  | 28301.42102068966
STORE J | 3 | GOOD | 164148.24192 |  | 33961.70522482759
STORE K | 3 | POOR | 164148.24192 |  | 22641.13681655173
STORE L | 3 | MEDIUM | 164148.24192 |  | 28301.42102068966
STORE M | 3 | MEDIUM | 164148.24192 |  | 28301.42102068966
STORE O | 4 | GOOD | 42797.90195200001 |  | 11672.15507781818
STORE P | 4 | MEDIUM | 42797.90195200001 |  | 9726.79589818182
STORE Q | 4 | GOOD | 42797.90195200001 |  | 11672.15507781818
STORE R | 4 | MEDIUM | 42797.90195200001 |  | 9726.79589818182
Spreadsheet: 688339d1595725515-compare-data-from-two-different-size-databases-show-matches-example-data-city-tax
Sheet: Sheet2

Account # | Prime Location Address | Table2.Site_Address
0200-017500 | 13405 SE  252ND ST | 13405 SE  252ND ST
 |  | 15004 SE 256TH ST
 |  | 15008 SE 253RD PL
 |  | 15013 SE 253RD PL
 |  | 15016 SE 253RD PL
 |  | 15016 SE 260TH ST
 |  | 15020 SE 253RD PL
 |  | 15023 SE 256TH ST
 |  | 15045 SE 256TH ST
0200-017508 | 25213  136TH AVE SE | 25213  136TH AVE SE
 |  | 15124 SE 260TH ST
0200-017509 | 25215  135TH AVE SE | 25215  135TH AVE SE
 |  | 15219 SE 251ST ST
 |  | 15220 SE 255TH CT
 |  | 15221 SE 255TH CT
0200-017513 | 25301  135TH AVE SE | 25301  135TH AVE SE
0200-017513 | 25301  135TH AVE SE | 25301  135TH AVE SE
0200-017516 | 25319  135TH AVE SE | 25319  135TH AVE SE
0200-017517 | 25325  135TH AVE SE | 25325  135TH AVE SE
0200-016900 | 13401 SE  252ND ST
0200-017501 | 13409 SE  252ND ST
0200-017502 | 13413 SE  252ND ST
0200-017503 | 13417 SE  252ND ST
0200-017504 | 13421 SE  252ND ST
0200-017505 | 15125 SE  276TH PL
0200-017506 | 25209  135TH AVE SE
0200-017507 | 25211  136TH AVE SE
0200-017510 | 25217  136TH AVE SE
0200-017511 | 25221  135TH AVE SE
0200-017512 | 25223  136TH AVE SE
0200-017514 | 25307  135TH AVE SE
0200-017515 | 25313  135TH AVE SE
Spreadsheet: 6263c4bb-6cb5-46d8-a66c-471cd878254d
Sheet: SW917

SW | SUV | PS# | Ln | Item | Description | UOM | $ | Cat | Cat Desc
SW917 | [NAME] | 2963 | 1 |  |  |  | 203.5 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 2 |  |  |  | 220 |  | Preassembled Wood Picture Frames
SW917 | [NAME] | 2963 | 3 |  |  |  | 126 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 4 |  |  |  | 148.5 |  | Plastic Picture Frames
SW917 | [NAME] | 2963 | 5 |  |  |  | 176 |  | Plastic Picture Frames
SW917 | [NAME] | 2963 | 6 |  |  |  | 97.9 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 7 |  |  |  | 25 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 8 |  |  |  | 25 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 9 |  |  |  | 40 |  | Preassembled Wood Picture Frames
SW917 | [NAME] | 2963 | 10 |  |  |  | 40 |  | Plastic Picture Frames
SW917 | [NAME] | 2963 | 11 |  |  |  | 15 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 12 |  |  |  | 15 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 13 |  |  |  | 22 |  | Preassembled Wood Picture Frames
SW917 | [NAME] | 2963 | 14 |  |  |  | 22 |  | Adjustable Picture Frames
SW917 | [NAME] | 2963 | 15 |  |  |  | 0.01 |  | Frame Kits
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: 2018

 |  |  |  |  |  |  | 2018
 |  |  |  |  |  |  |  | Number   of       Walks | Total   Miles | Total Height | Total   Hours  Walked | Average Speed
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Will
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 7ca0b1f0-20ed-4bbd-aba9-3f40ab38f392
Sheet: Sheet1

Name, Last | Name, First | E-Mail Address | Phone | Department
[NAME] | [NAME] | [EMAIL] | 885-7563 | Facilities
[NAME] | [NAME] | [EMAIL] | 736-3603 | [NAME]
Copeland | Kristi | [EMAIL] | [PHONE] | Aberdeen R & E
Dahmen | [NAME] | [EMAIL] | 885-7665 | College of Engineering
Dobbins | [NAME] | [EMAIL] | 885-6581 | CNR
Eberhardt | [NAME] | [EMAIL] | 885-6772 | Education
[NAME] | [NAME] | [EMAIL] | 885-0235 | Athletics
Haarr | Julie | [EMAIL] | 885-7911 | Conservation Social Sciences
Holthaus | Margo | [EMAIL] | 885-6721 | ITS
Husebye | [NAME] | [EMAIL] | 885-2719 | DFA
Jones | Janice | [EMAIL] | 885-6833 | CALS
Kisha | [NAME] | [EMAIL] | 885-6434 | Fish & Wildlife
Rigby | Debbie | [EMAIL] | 885-5078 | Forest Resources
Robb | Stuart | [EMAIL] | 885-6424 | Parking & Info. Services
Salonen | Carry | [EMAIL] | 885-1177 | Risk Management Office
Vandegrift | [NAME] | [EMAIL] | 885-6182 | Bio & Ag. Engr.
Willis | Dayna | [EMAIL] | 885-6277 | PSES
Wilson | [NAME] | [EMAIL] | 885-8983 | Student Media Services
Spreadsheet: 577994d1528896016-formular-for-cost-of-individual-sold-item-using-fifo-copy-of-fifo-cost-price-for-item-xfile-
Sheet: Sheet1

 |  |  |  | PURCHASE COST |  |  | PURCHASE COST
 | SN | DATE | ITEM | QTY | UNIT PRICE | AMOUNT | QTY | UNIT PRICE | AMOUNT
 | 1 | 2018-05-20 00:00:00 | T-SHIRT | 50 | 21
 | 2 | 2018-05-22 00:00:00 | T-SHIRT | 50 | 23
 | 3 | 2018-05-24 00:00:00 | T-SHIRT |  |  |  | 60
 | 4 | 2018-05-26 00:00:00 | SKIRT
 | 5 | 2018-05-28 00:00:00 | SKIRT
 | 6 | 2018-05-30 00:00:00 | SKIRT
 | 7 | 2018-06-01 00:00:00 | T-SHIRT | 50 | 25
 | 8 | 2018-06-03 00:00:00 | T-SHIRT |  |  |  | 70
 | 9 | 2018-06-05 00:00:00 | T-SHIRT | 100 | 26
 | 10
Spreadsheet: 77045d1277480249-excel-2007-lock-sheet-only-specific-cells-editable-loanamortization1-1-
Sheet: Loan Amortization Schedule

Loan Amortization Schedule
 | Enter values |  |  |  |  |  | Loan summary
 |  | Loan amount | 11405 |  |  |  |  | Scheduled payment
 |  | Annual interest rate | 0.0399 |  |  |  |  | Scheduled number of payments
 |  | Loan period in years | 5 |  |  |  |  | Actual number of payments
 |  | Number of payments per year | 12 |  |  |  |  | Total early payments
 |  | Start date of loan | 2010-06-25 00:00:00 |  |  |  |  | Total interest
 |  | Optional extra payments
 | Lender name:
Pmt. No. | Payment Date | Beginning Balance | Scheduled Payment | Extra Payment | Total Payment | Principal | Interest | Ending Balance | Cumulative Interest
Spreadsheet: 102098d1300139650-how-do-you-selectively-merge-two-workbooks-webdatabase
Sheet: Sheet1

Model | Engine | From | To | Category | Sub Category | Description | Qualifying Text | Illustration | Product Code | Qty | Last Updated | Updated By
Series II-IIA | 2.25 petrol | 1958 | 1971 | engine | gasket kit | full engine gasket set | no main seals |  | [NAME] | 1
Series II-IIA | 2.25 petrol | 1958 | 1971 | engine | gasket kit | head set |  |  | STC1567G | 1
Series II-IIA | 2.25 petrol | 1958 | 1971 | engine | gaskets and seals | head gasket | copper |  | ERC6380C | 1
Series II-IIA | 2.25 petrol | 1958 | 1971 | engine | gaskets and seals | head gasket | composite |  | ERC6380G | 1
Spreadsheet: 54bcd22e-ad67-4dbe-9453-adcf9170cec4
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
FINTB | Test | FINTB | Interleukin 1b | Interleukin 1-Beta | Enzyme Immunoassay (EIA) | EDTA (lavender-top) tube: EDTA Plain, Red-Top or serum gel tube: Red |  |  | 3 | mL | Serum Draw blood in a plain, red-top tube(s), serum-gel tube(s) is acceptable. Separate immediately and send 3 mL of serum frozen in a plastic vial.   [NAME] blood in a lavender-top (EDTA) tube(s). Separate immediately and send 3 mL of EDTA plasma frozen in a plastic vial.   Patient preparation: Patient should NOT be on any Corticosteroids, anti-inflammatory medications or pain killers, if possible, for at least 48 hours prior to collection of specimen. | 1 mL | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | Less than 1.0 pg/mL  Test Performed by:	Interscience Institute 			944 West Hyde Park Blvd 			Inglewood, CA 90302 | Varies; Monday through Friday | 5 - 7 days | 7 - 9 days | 1 | 83519 |  |  |  |  | Inter Science Institute
FINTB | [NAME] | VARIES | Varies |  |  |  | Frozen | 365 days
FINTB | Result | Z0943 | Interleukin 1-Beta | Interleukin 1-Beta | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 13629-1 | Interleukin 1 beta:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 867282d1714127056-looking-for-shortcut-to-put-all-tab-names-on-one-tab-plus-data-template-empty
Sheet: Company Name 5

 |  |  |  |  |  | Company Name 5
 |  | Month ending
 |  | Enter month
 | Date | Invoice number | Total | Materials | Labour | Tax | [NAME] | Payable
 |  | Totals
[NAME]
Company No. 06977736
Spreadsheet: 126431d1319692141-time-based-cash-flow-question-model
Sheet: Expenses

 | Expense Summary by Month
 |  | CY2013 |  |  |  |  |  |  |  |  |  |  | SUM | CY2014 |  |  |  |  |  |  |  |  |  |  |  | CY2015 |  |  |  |  |  |  |  |  |  |  |  | CY2016
 |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00
Compensation | Base Salaries
 | Benefits
 | Performance Bonuses
 | Spot Incentives
 | [NAME]
Spreadsheet: 215490d1361390801-formula-that-can-count-number-of-orders-booked-on-a-date-ignoring-duplicates-unique-counts
Sheet: Sheet1

 |  | Date | Booked Orders
 |  | 2012-08-01 00:00:00
 |  | 2012-09-20 00:00:00
 |  | 2012-12-27 00:00:00
 |  | 2012-10-19 00:00:00
 |  | 2012-10-19 00:00:00
 |  | 2012-11-21 00:00:00
 |  | 2012-11-07 00:00:00
 |  | 2012-11-27 00:00:00
 |  | 2012-11-14 00:00:00
Spreadsheet: 758473d1638889979-formula-to-find-what-year-a-student-will-be-age-5-on-july-31-eligible-for-kindergarten-kdg-year-example
Sheet: Sheet1

 | Grade | Birth Date | Age | KDG Year
[NAME] | PK | 2016-09-11 00:00:00 |  |  | (should be 2022)
[NAME] | PK | 2017-02-22 00:00:00
Camri | PK | 2016-12-13 00:00:00
[NAME] | PK | 2017-05-22 00:00:00
[NAME] | PK | 2016-08-20 00:00:00 |  |  | (should be 2022)
Sandy | PK | 2017-10-10 00:00:00
[NAME] | PK | 2017-11-02 00:00:00
[NAME] | PK | 2018-03-13 00:00:00
Spreadsheet: 717277d1612550226-how-to-count-just-numbers-in-the-second-column-which-are-not-the-same-mysheet-1-frequency
Sheet: Hárok1

 | Val |  |  |  |  |  |  |  | MY FORMULA
 | Dátum | nákladové | Prod. | [NAME] |  | 1.12.
 | 1.12. | 5034 | 2.5 | x
 | 2.12. | 5019 | 2 | x
 | 3.12. | 5021 | 2 | x
 | 2020-12-07 00:00:00 | 5034 | 2 | x
 | 2020-12-08 00:00:00 | 4338 | 4 | x
 | 2020-12-11 00:00:00 | 5028 | 1 | x
 | 2020-12-11 00:00:00 | 4317 | 1 | x
 | 2020-12-14 00:00:00 | 5029 | 3 | x
 | 2020-12-14 00:00:00 | 5090 | 1 | x
 | 2020-12-14 00:00:00 | 4339 | 2 | x
 | 2020-12-14 00:00:00 | 5034 | 1.5 | x
 | 2020-12-16 00:00:00 | 4329 | 3 | x
 | 2020-12-21 00:00:00 | 4332 | 2.5 | x
 | 2020-12-21 00:00:00 | 5101 | 1 | x
 | 2020-12-22 00:00:00 | 4346 | 1.5 | x
 | 2020-12-22 00:00:00 | 5090 | 1 | x
 | 2020-12-22 00:00:00 | 4319 | 1 | x
 | 2020-12-23 00:00:00 | 5020 | 4 | x
 | 2020-12-28 00:00:00 | 4326 | 7.5 | x
 | 2020-12-29 00:00:00 | 5301 | 1.5 | x
 | 2020-12-29 00:00:00 | 5102 | 2 | x
 | 2020-12-29 00:00:00 | 4326 | 3 | x
 | 2020-12-30 00:00:00 | 5019 | 1 | x
 | 1.12. | 5020 | 2 | x
 | 1.12. | 4011 | 3.5 | x
 | 3.12. | 4340 | 0.5 | x
 | 4.12. | 5019 | 2 | x
 | 4.12. | 4314 | 1 | x
 | 30.12. | 4106 | 1 | x
 | 30.12. | 4346 | 1.5 | x
 | 1.12. | 5029 | 1.5 | x
 | 2.12. | 5090 | 1 | x
 | 2.12. | 4103 | 0.5 | x
 | 2020-12-04 00:00:00 | 40 | 1 | x
 | 2020-12-07 00:00:00 | 4338 | 2 | x
 | 2020-12-09 00:00:00 | 5009 | 1 | x
 | 2020-12-10 00:00:00 | 4345 | 1 | x
 | 2020-12-10 00:00:00 | 4339 | 4 | x
 | 2020-12-10 00:00:00 | 5009 | 2 | x
 | 2020-12-11 00:00:00 | 4339 | 1 | x
 | 2020-12-16 00:00:00 | 4315 | 2 | x
 | 2020-12-16 00:00:00 | 4314 | 0.5 | x
 | 2020-12-16 00:00:00 | 4329 | 1 | x
 | 2020-12-18 00:00:00 | 4315 | 1 | x
 | 2020-12-18 00:00:00 | 40 | 0.5 | x
 | 2020-12-21 00:00:00 | 4339 | 5 | x
 | 2020-12-22 00:00:00 | 4339 | 4 | x
 | 2020-12-22 00:00:00 | 5020 | 1 | x
Spreadsheet: 694892d1599857920-sumif-not-working-properly-productn-materials-planning-template
Sheet: BC 6mm

 |  |  |  | Total for 75 batches
100000023980 | 2.43
100000025444 | 5.24
100000024051 | 120
100000024053 | 121.35
100000024052 | 0
100000025425 | 4
100000025424 | 4
100000025436 | 8.69
200000008863 | 133
100000024101 | 60
100000025380 | 1
100000025391 | 0.5
100000025401 | 2
100000025873 | 210.86
100000029113 | 100
100000030080 | 45
100000032512 | 725.68
100000044825 | 40
100000034288 | 75
100000040473 | 364
100000040932 | 130.25
100000045271 | 100
Spreadsheet: 758530d1638920803-find-max-number-based-on-vertical-and-horizontal-criteria-maxfilter
Sheet: Sheet1

 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00
Apples | 42 | 15 | 45 | 91 | 5 | 24 | 43 | 7 | 68 | 4 | 85 | 88 | 37 | 84 | 48 | 24 | 23 | 53 | 52 | 85 | 72 | 4 | 52 | 14 | 35 | 20 | 45 | 83 | 34 | 57 | 6
Oranges | 52 | 61 | 97 | 54 | 76 | 80 | 9 | 62 | 63 | 6 | 73 | 67 | 19 | 28 | 41 | 86 | 6 | 77 | 41 | 49 | 5 | 9 | 85 | 79 | 74 | 50 | 75 | 80 | 23 | 72 | 35
Pears | 86 | 90 | 88 | 64 | 71 | 52 | 8 | 96 | 17 | 30 | 53 | 92 | 75 | 92 | 52 | 11 | 32 | 65 | 8 | 35 | 25 | 43 | 53 | 2 | 75 | 25 | 78 | 25 | 67 | 66 | 54
 | Fruit | Apples
 | Month | 1
 | [NAME]
Spreadsheet: 851217d1701442722-formulas-not-calculating-debt-payoff-crich368-
Sheet: Travel CC

 | Credit Card Info
 | Current Balance | 7613
 | Interest Rate | 0.1324
 | Interest-Only Payment
 | A. Calculate Months to Payoff |  |  | Months | Payment | Interest
 | Monthly Payment | 500 |  | 12
 | (Needs to be greater than the interest-only payment) |  |  | 18
 |  |  |  | 24
 | Months to Payoff |  |  | 30
 | Total Interest |  |  | 36
 |  |  |  | 42
 | B. Calculate Monthly Payment |  |  | 54
 | Payoff Goal (Months) | 36 |  | 60
 | Monthly Payment
 | Total Interest
Spreadsheet: 55266d1255421164-excel-2007-automatic-sorting-duplicate-removal-703044_tyrsius
Sheet: PT

 |  |  |  |  | based off RAW
 | Values
Row Labels | Count of Location ID | Max of Updated Date | Sum of Last Ticket
129 | 1 | 2009-09-26 18:48:53 | 383573
173 | 2 | 2009-10-06 10:17:19 | 379289
185 | 1 | 2009-09-28 17:10:07 | 384144
186 | 3 | 2009-10-08 13:16:18 | 390324
198 | 2 | 2009-10-09 10:07:05 | 383252
200 | 1 | 2009-10-08 07:53:11 | 389811
269 | 2 | 2009-10-07 11:40:09 | 389698
272 | 1 | 2009-09-19 12:49:13 | 376598
280 | 2 | 2009-10-09 17:20:42 | 391586
291 | 1 | 2009-09-18 12:55:27 | 379189
295 | 2 | 2009-10-08 16:09:55 | 390516
314 | 1 | 2009-09-21 19:23:01 | 380494
319 | 1 | 2009-09-27 09:10:18 | 383609
334 | 1 | 2009-10-08 08:47:28 | 389985
336 | 1 | 2009-09-28 09:09:31 | 383849
339 | 1 | 2009-09-18 15:44:01 | 379295
368 | 1 | 2009-10-03 18:44:00 | 387449
369 | 1 | 2009-09-27 18:28:34 | 383687
372 | 3 | 2009-09-29 05:56:17 | 384207
390 | 1 | 2009-09-21 12:55:56 | 380441
406 | 1 | 2009-10-07 11:04:15 | 389645
424 | 1 | 2009-10-03 09:21:31 | 380034
471 | 1 | 2009-09-16 08:34:38 | 377202
517 | 1 | 2009-10-02 12:45:20 | 386527
546 | 1 | 2009-10-07 15:29:44 | 387129
549 | 2 | 2009-10-08 05:08:57 | 388899
568 | 1 | 2009-10-07 10:51:15 | 389370
588 | 1 | 2009-09-25 11:21:48 | 383004
590 | 1 | 2009-10-07 18:56:20 | 389993
Grand Total | 39 | 2009-10-09 17:20:42 | 11162799
Spreadsheet: 486351d1477431842-trying-to-keep-record-and-summarize-daily-activities-for-a-team-of-six-members-compliance-production-report-bsb-
Sheet: Summary

 | Select date : | 2016-10-06 00:00:00
Name |  |  |  | [NAME] |  |  |  | Name3 |  |  |  | Name4 |  |  |  | Name5 |  |  |  | Name6
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Total Calls |  |  |  | Total Calls |  |  |  | Total Calls |  |  |  | Total Calls |  |  |  | Total Calls |  |  |  | Total Calls
Rehabs |  |  |  | Rehabs |  |  |  | Rehabs |  |  |  | Rehabs |  |  |  | Rehabs |  |  |  | Rehabs
[NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
Third Party | You will need to explain how these are identified on Totals sheet |  |  | Third Party |  |  |  | Third Party |  |  |  | Third Party |  |  |  | Third Party |  |  |  | Third Party
Admin | Is this the same as row 2? |  |  | Admin |  |  |  | Admin |  |  |  | Admin |  |  |  | Admin |  |  |  | Admin
O>15 Min |  |  |  | O>15 Min |  |  |  | O>15 Min |  |  |  | O>15 Min |  |  |  | O>15 Min |  |  |  | O>15 Min
O<15 Min |  |  |  | O<15 Min |  |  |  | O<15 Min |  |  |  | O<15 Min |  |  |  | O<15 Min |  |  |  | O<15 Min
Total | I don't know what you're trying to total here. |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
Spreadsheet: darrell_schoolcraft__7774__imbalsumm0106
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1
2 |  |  |  | 3639
3 | 4302 |  |  | 3639
4 |  |  |  | 3639
5 | 18615 |  |  | 10000
6 | 26699 |  |  | 26000
7 | 56421 |  |  | 55000
8 | 23123 |  |  | 22806
9 | 301 |  |  | 2577
10 |  |  |  | 2577
11 | 1242 |  |  | 2577
12 | 19627 |  |  | 20408
13 | 3631 |  |  | 5000
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  |  |  | 61895
 | 2001-06-13 00:00:00
Spreadsheet: 868566d1715271028-i-need-to-print-only-specific-columns-one-pag-ts
Sheet: Sheet1

X1 | X2 | X3 | X21 | X22 | X23 | X24 | X25 | [NAME] | X27 | X28 | X29 | X30 | X31 | X32 | X33 | X34 | X35 | X36 | X37 | X38 | X39 | X40 | X41 | X42 | X43
Spreadsheet: 2eb56c63-6d23-414a-ba0a-fa600213d773
Sheet: DC Enrll Top Ten 10-11

Dual Credit Enrollment
Students 2011-12
Top 10 Courses Enrolled In by 2011-12 Academic Year
 | Course | Number of Students
1 (1) | FIN 1010 | 725
2 (2) | ENG 1101 | 265
3 (4) | PSY 1105 | 202
4 (3) | IT 1010 | 175
5 (6) | MATH 1310 | 156
6 (5) | CSE 1101 | 153
7 (7) | SPAN 1101 | 131
8 (8) | ENG 1102 | 124
9 (-) | MLT 1010 | 123
10 (10) | HLTH 1001 | 107
* Number inside parentheses () is last year's ranking
Top 10 Course Success Rates by Course - 2011-12 Academic Year (Minimum enrollment of 10 students)
 | Course | Number of Students | Course Success Rate
1 | CHEM 1492 | 18 | 1
2 | MUS 1103 | 15 | 1
3 | CARP 1030 | 13 | 1
4 | PHYS 1010 | 13 | 1
5 | AUTC 1130 | 12 | 1
6 | CARP 1092 | 12 | 1
7 | WELD 1192 | 10 | 1
8 | ENG 1150 | 83 | 0.9879518072289156
9 | EMS 1003 | 26 | 0.9615384615384616
10 | MATH 1330 | 21 | 0.9523809523809523
Top 10 Course Success Rates by Course - 2011-12 Academic Year (Minimum enrollment of 20 students)
 | Course | Number of Students | Course Success Rate
1 | ENG 1150 | 83 | 0.9879518072289156
2 | EMS 1003 | 26 | 0.9615384615384616
3 | MATH 1330 | 21 | 0.9523809523809523
4 | PSCI 1110 | 21 | 0.9523809523809523
5 | HLTH 1001 | 107 | 0.9439252336448598
6 | MATH 1316 | 28 | 0.9285714285714286
7 | MUS 1139 | 33 | 0.9090909090909091
8 | ENG 1102 | 124 | 0.9032258064516129
9 | ARTS 1106 | 34 | 0.8787878787878788
10 | FREN 1101 | 36 | 0.8611111111111112