tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 725327d1616620183-sum-data-by-month-and-category-210324-formula-question
Sheet: Sheet1

 | Date | Account | Description | Category | Amount
 | 2021-01-01 00:00:00 | Checking | [NAME] | Grocery | 100
 | 2021-02-15 00:00:00 | Savings | Betterment | Investment | 1500
 | 2021-03-01 00:00:00 | Credit Card 1 | Amazon | Clothing | 225
 | 2021-03-10 00:00:00 | Credit Card 2 | Amazon | Pet Food | 50
 | 2021-03-24 00:00:00 | Credit Card 1 | Saks | Clothing | 125
 |  |  | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | Total
 |  | Clothing
 |  | Grocery
 |  | Investment
 |  | Pet Food
Spreadsheet: 48805d1248109962-creating-a-time-sheet-trial-timecard
Sheet: Sheet4

Martin | June/July
Job# | Name | Total | 28 | 2009-06-29 00:00:00 | 2009-06-30 00:00:00 | 2009-07-01 00:00:00 | 2009-07-02 00:00:00 | 2009-07-03 00:00:00 | 2009-07-04 00:00:00 | 2009-07-05 00:00:00 | 2009-07-06 00:00:00 | 2009-07-07 00:00:00 | 2009-07-08 00:00:00 | 2009-07-09 00:00:00 | 2009-07-10 00:00:00 | 2009-07-11 00:00:00 | 2009-07-12 00:00:00
 |  | Hours | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S
 | Over Time
 | Total
Spreadsheet: 850995d1701271988-formula-to-pull-filtered-list-from-another-sheet-based-on-search-box-calculetor-2-jacc
Sheet: Data

Item Name | Brand | Company1 | Price1 | Company2 | Price2 | Company3 | Price3
DAGI TALA CHABI |  | TYT/H
WATER BODY MEHRAN | GMB | TYT/H
CROSS NO 1 | CYB | TYT/H
CHMTA MEHRAN SP | SP555 | TYT/H
CHMTA MEHRAN RAP | RAP | TYT/H
CHABI SWITCH MEHRAN | CH | TYT/H
DISC XLI FRONT 2012 A73 | ASUKI | TYT/H
PISTON MEHRAN | NET | TYT/H
VALVE MEHRAN | SUPREM | TYT/H
RING MEHRAN | NPR | TYT/H
FRONT SHOCK | GABRIAL | TYT/H
FRONT SHOCK SPRING 7K | CH | TYT/H
FRONT SHOCK SPRING 8K | CH | TYT/H
FRY WHEEL RING | RAVI | TYT/H
MAIN BEGIAN 050 | THAI | TYT/H
[NAME]*204 | KOYO | TYT/H
[NAME] | HOS | TYT/H
[NAME] | LOC | TYT/H
DOOR KUNDA REAR BOLN | LOC | TYT/H
CONECTOR ROD KABLA W*N | KABLI | TYT/H
CORBORETOR JET 85NO | CH | TYT/H
CV JOINT MEHRAN INNER | BMX | TYT/H
HEAD TAKI 20 NUMBER | LOC | TYT/H
CLUMP 0 SIZE | CHI | TYT/H
EXCEL CONE RED KANARI | KOYO | TYT/H
EXCEL CONE SADA | KOYO | TYT/H
[NAME] | LOC | TYT/H
[NAME] | LOC | TYT/H
VALVE GUIDE | JPN | TYT/H
OIL PIMP MEHRAN (w) | RAVI | TYT/H
REVERSE SWITCH MEHRAN | TIW | TYT/H
WATER BODY CULTUS | GMB | TYT/H
BATTERY TERMINAL HAVI/D | F/BHARI | FN/H
PISTON [NAME] | ART | MN
RING WAGNOR | NPR | MN
MAIN BEGIAN WAGNOR | THI | MN
THIRS COLOR WAGNOR | PSGP | MN
OIL PUMP KIT WANOR | FUJI | MN
JAIN [NAME] COMPLET | CHI | MN
FAN BELT WAGNOR JPN | BANDO | MN
CLUTCH SET WAGNOR | PSGP | MN
WATER BODY WAGNOR | GMB | MN
CLUTCH BEARING WAGNOR | NTN | MN
RADIATIOR PIP LOHA WAGNOR |  | MN
WATER JACKET | PSGP | MN
BEARING 6002 | KOYO | MN
volvo
saab
toyota
Spreadsheet: 57400d1257516219-excel-2007-shifting-cells-based-on-data-from-a-cell-whose-position-varies-yllek
Sheet: Sheet1

Start Date (First Day of Sacred Year) |  | 2009-03-22 00:00:00 |  |  |  |  |  | [NAME] | Exodus 4
 |  |  |  |  |  |  |  |  | Exodus 5
 | Exodus 1-3 |  | Exodus 4-6 |  | Exodus 7-9 |  | Exodus 10-12 |  | Exodus 6
 | Exodus 13-14 |  | Exodus 15-16 |  | Exodus 17-20 |  | [NAME] 25-26 |  | Exodus 7
 | [NAME] 27-28 |  | [NAME] |  | [NAME] |  | [NAME] |  | Exodus 8
 | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] 20-21 |  | Exodus 9
 | Song 1-4 |  | Song 5-8 |  | Exodus 21-23 |  | Exodus 24-26 |  | Exodus 10
 | Exodus 27-28 |  | Exodus 29-30 |  | Exodus 31-33 |  | Exodus 34-35 |  | Exodus 11
 | Exodus 36-38 |  | Exodus 39-40 |  | [NAME] |  | [NAME] |  | Exodus 12
 | [NAME] |  | Gen 12-14 |  | Gen 15-18 |  | Gen 19-21 |  | Exodus 13
 | Gen 22-24 |  | Gen 25-27 |  | Gen 28-29 |  | Gen 30-31
 | Gen 32-34 |  | Gen 35-37 |  | Gen 38-39 |  | [NAME]
 | Gen 32-35 |  | Gen 35-38 |  | Gen 38-40 |  | [NAME]
 | Gen 32-36 |  | Gen 35-39 |  | Gen 38-41 |  | [NAME]
 | Gen 32-37 |  | Gen 35-40 |  | Gen 38-42 |  | [NAME]
 | Gen 32-38 |  | Gen 35-41 |  | Gen 38-43 |  | [NAME]
 | Gen 32-39 |  | Gen 35-42 |  | Gen 38-44 |  | [NAME]
 | Exodus 1 |  | Exodus 2 |  | Exodus 3 |  | Exodus 4
 |  |  | Gen 35-46 |  | Gen 38-48 |  | [NAME]
 | Gen 32-44 |  | Gen 35-47 |  | Gen 38-49 |  | [NAME]
Spreadsheet: 805026d1668494952-countif-from-filtered-table-countif-from-filtered-table
Sheet: Sheet1

aa | ss
1 | a
2 | b
3 | c
4 | a
5 | b
6 | c
7 | c
8 | a
 |  |  | aa | ss
 |  |  | a | 2
 |  |  | b | 1
Spreadsheet: 176069d1345722557-problems-with-an-if-statement-database
Sheet: TaxRates

[NAME]
 |  | Home Page | Section Data | Tax Rates | Staff
 |  | Tax Rates (Weekly Gross)
 |  | From $ | To $ | Rate
 |  | 0 | 200 | 0.05
 |  | 201 | 500 | 0.09
 |  | 501 | 900 | 0.14
 |  | 901 | 1400 | 0.23
 |  | 1401 | 1402< | 0.34
 |  | Sales Bonus | 0.025
 |  | Overtime Rate | 1.5 | of normal rate
Spreadsheet: 328064d1403782164-find-duplicates-within-a-specific-timeframe-test1
Sheet: Data

Emp Code | Emp Name | Cust. Acct. No. | System Code | Date of Req (DOR) | [NAME] | Mode of Delivery | Comments | Days Diff | Unique/Duplicate
1 | [NAME] | 2242424 | EML | 2014-06-01 00:00:00 | [NAME] | [NAME] | [EMAIL]
2 | [NAME] | 987654 | EML | 2014-06-03 00:00:00 | [NAME] | [NAME] | [EMAIL]
3 | [NAME] | 555555 | EML | 2014-06-02 00:00:00 | Statement | [NAME] | [EMAIL]
1 | [NAME] | 6245845 | ML | 2014-06-02 00:00:00 | Invoice | MAIL | Mailing
1 | [NAME] | 2242424 | EML | 2014-06-12 00:00:00 | Invoice | [NAME] | [EMAIL]
2 | [NAME] | 159548 | ML | 2014-06-15 00:00:00 | Invoice | MAIL | Mailing
3 | [NAME] | 258258 | FX | 2014-06-06 00:00:00 | [NAME] | FAX | [PHONE]
4 | Adam | 1121121 | EML | 2014-06-01 00:00:00 | Invoice | [NAME] | [EMAIL]
2 | [NAME] | 354789 | FX | 2014-06-18 00:00:00 | [NAME] | FAX | [PHONE]
4 | Adam | 1121121 | FX | 2014-06-04 00:00:00 | Invoice | FAX | [PHONE]
3 | [NAME] | 1648952 | FX | 2014-06-08 00:00:00 | Statement | FAX | [PHONE]
2 | [NAME] | 6245845 | ML | 2014-06-10 00:00:00 | Invoice | MAIL | Mailing
3 | [NAME] | 2242424 | FX | 2014-06-18 00:00:00 | [NAME] | [NAME] | [EMAIL]
3 | [NAME] | 159548 | ML | 2014-06-28 00:00:00 | Invoice | MAIL | Mailing
2 | [NAME] | 2242424 | EML | 2014-06-18 00:00:00 | [NAME] | [NAME] | [EMAIL]
Spreadsheet: 271494d1381952353-need-help-with-a-formula-to-populate-a-summary-table-exceltables
Sheet: Sheet1

 | (miscExpensesTable) |  |  |  |  |  | (miscExpensesSummary table output example - dates are 'week beginning on')
 | Code | Date | Amount | Column1 |  |  | Code | 10/7/2013 | 10/14/2013 | 10/21/2013
 | b | 2013-10-08 00:00:00 | 6 |  |  |  | 3 | 4 | -2
 | a7 | 2013-10-21 00:00:00 | 0 |  |  |  | 14 | 11
 | 14 | 2013-10-12 00:00:00 | 3 |  |  |  | a7 | 9
 | 3 | 2013-10-17 00:00:00 | -7 |  |  |  | b | 6
 | gh | 2013-10-11 00:00:00 | 12 |  |  |  | gh | 12 |  | 4
 | a7 | 2013-10-08 00:00:00 | 9 |  |  |  | xx
 | gh | 2013-10-21 00:00:00 | 4
 | 14 | 2013-10-12 00:00:00 | 8
 | 3 | 2013-10-19 00:00:00 | 5
 | 3 | 2013-10-13 00:00:00 | 4
 | xx | 2013-10-16 00:00:00 | 0 |  | << xx entry appears in the Summary table above because $$=0, not blank (this is a place holder entry).
 | yy | 2013-10-21 00:00:00 |  |  | << yy  entry doesn't appear in the Summary table above because $$ is blank, not 0.
 | zz |  | 18 |  | << zz  entry doesn't appear in the Summary table because one (or more) of the entry cells is blank.
 |  |  |  |  |  |  | Code | 2013-10-07 00:00:00 | 2013-10-14 00:00:00 | 2013-10-21 00:00:00
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | a7
 |  |  |  |  |  |  | b
 |  |  |  |  |  |  | gh
 |  |  |  |  |  |  | xx
 |  |  |  |  |  |  | yy
Spreadsheet: 64682d1265477122-vlookup-and-non-numeric-data-treasury-yields
Sheet: Feb 1

 | Yield
 | 2010-02-01 00:00:00 | 2009-12-31 00:00:00 | 2009-01-30 00:00:00
3-Month Treasury [NAME] | 0.001 | 0.0006 | 0.0024
1-Year Treasury Bill | 0.003 | 0.0044 | 0.0048
5-Year Treasury Note | 0.0238 | 0.0269 | 0.0185
10-Year Treasury Note | 0.0368 | 0.0385 | 0.0287
Spreadsheet: 150783d1334678992-combining-table-tab-information-startup-prl
Sheet: General Contractor

Project Name:
Project Team: |  |  | G.C. Super:
Project Manager:
Mechancial Engineer:
Controls Engineer:
Field Technician (TAB):
 |  |  |  |  | Problem-Resolution Log (PRL) - General Contactor
Issue No. | Date Entered | Entered By: | Equipment or System | Description of Issue | Action By | Progress | Date Corrected | Corrected By: | Date Approved | Resolved by | [NAME] | Approved By:
1 | 2012-04-05 00:00:00 |  |  | Chiller Repair
 | 2012-04-05 00:00:00 |  |  | Domestic Water Meters
 | 2012-04-05 00:00:00 |  |  | Owner signoff on??? | [NAME]
 | 2012-04-05 00:00:00 |  |  | [NAME]?
 | 2012-04-16 00:00:00 | EM | AHU-241 | Mechanical Room and Electrical Room doors are not installed.  Unable to finalize [NAME].
Spreadsheet: 544708d1509007091-target-increase-spreadsheet-example
Sheet: Sheet1

Week No | Sales 2017 | Actual sales 2018 | Running Target | Up / Down
1 | 1000 | 1200
2 | 1200 | 1100
3 | 1300 | 1200
4 | 1100
5 | 1200
6 | 1000
7 | 1300
8 | 1500
9 | 2000
10 | 2100
11 | 750
12 | 1000
13 | 200
14 | 1700
15 | 1600
16 | 1300
17 | 1000
18 | 1200
19 | 1300
20 | 1100
21 | 1200
22 | 1000
23 | 1300
24 | 1500
25 | 2000
26 | 2100
27 | 750
28 | 1000
29 | 200
30 | 1700
31 | 1600
32 | 1300
33 | 1000
34 | 1200
35 | 1300
36 | 1100
37 | 1200
38 | 1000
39 | 1300
40 | 1500
41 | 2000
42 | 2100
43 | 750
44 | 1000
45 | 200
46 | 1700
47 | 1600
48 | 1300
49 | 200
50 | 1700
51 | 1600
52 | 1300
Spreadsheet: darrell_schoolcraft__7565__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2002-01-07 00:00:00
 |  |  | SoCal Gas Price |  | 2.24
 |  |  | San Juan Gas Price |  | 2.045
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 420 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 540 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 540 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 540 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 540 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 540 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 540 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 540 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 540 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 540 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 540 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 540 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 540 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 540 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 540 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 540 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 540 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 505 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 505 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 505 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 505 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 505 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 505 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 505 | 7
Spreadsheet: robin_rodrigue__33364__IMPositions_070700
Sheet: Summary

 | CANADA INTRA-MONTH POSITION REPORT (contracts)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End of Day: |  |  |  | 2000-07-07 00:00:00
 |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts |  | Contracts
 |  | Total Alberta |  | AECO |  | SUMAS |  | Nymex |  | [NAME] |  | Sumas |  | Stn2 |  | Chicago |  | Malin |  | Malin |  | Dawn |  | Chicago |  | Rockies |  | Rockies |  | San Juan
 |  | Fixed Price |  | Gas Daily |  | Gas Daily |  | Fixed Price |  | Fixed Price |  | Fixed Price |  | Fixed Price |  | Gas Daily |  | Fixed Price |  | Gas Daily |  | Gas Daily |  | MI |  | Gas Daily |  | Fixed Price |  | Fixed Price |  | Total Fixed Price
2000-07-01 00:00:00 |  |  |  |  |  | 0
2000-08-01 00:00:00 |  |  |  |  |  | 0
2000-09-01 00:00:00
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
Includes the following positions: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero |  |  |  | summary page does not equal west plus bc |  | summary page does not equal west plus bc
BC GD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check - s/b zero |  |  |  | summary page does not equal total of template |  | summary page does not equal total of template
Opt [NAME]
AB Fin
AB [NAME]
Total
Spreadsheet: 119999d1314906915-problem-with-index-indirect-match-match-sample-indirect-index-match
Sheet: Upcomming Games

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | _2011 | _2010
 |  |  |  |  |  |  |  |  |  |  |  |  | SELECT YEAR & DATE |  |  |  |  |  |  | 2011-09-01 00:00:00 | 2010-09-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | _2010 |  | 2010 | 2010-09-25 00:00:00 |  |  |  |  |  | 2011-09-02 00:00:00 | 2010-09-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Team |  | Will Play |  |  |  |  |  | 2011-09-03 00:00:00 | 2010-09-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010Illinois | Illinois |  | Bye |  |  |  |  |  | 2011-09-10 00:00:00 | 2010-09-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010Indiana | Indiana |  | Akron |  |  |  |  |  | 2011-09-17 00:00:00 | 2010-09-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010Iowa | Iowa |  | [NAME] |  |  |  |  |  | 2011-09-24 00:00:00 | 2010-10-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010Michigan | Michigan |  | Bowling Green |  |  |  |  |  | 2011-10-01 00:00:00 | 2010-10-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  | 2010Michigan State | Michigan State |  | #N/A |  |  |  |  |  | 2011-10-08 00:00:00 | 2010-10-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-15 00:00:00 | 2010-10-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-22 00:00:00 | 2010-10-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-29 00:00:00 | 2010-11-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-05 00:00:00 | 2010-11-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-12 00:00:00 | 2010-11-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-19 00:00:00 | 2010-11-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-11-26 00:00:00
Spreadsheet: 536ac731-beb6-44f9-a28f-82f9b33a783d
Sheet: Sheet1

Monthly Pass & Ticket Order by Mail
Complete this form and mail it along with your check payable to Frederick County Treasurer:
TransIT Services of Frederick County
1040 Rocky Springs Road, Frederick, MD 21702
Connector Bus & Shuttle Tickets
 |  |  |  |  |  |  | Price |  |  | How Many? |  |  | Total
GENERAL PUBLIC TICKETS
Monthly Pass-Regular |  |  |  |  |  |  | 45 |  |  | 1 month |  |  | $
 |  |  |  |  | month
10-Trip Regular Fare |  |  |  |  |  |  | 12 |  |  |  |  |  | $
20-Trip Regular Fare |  |  |  |  |  |  | 22 |  |  |  |  |  | $
STUDENT TICKETS - I.D. REQUIRED TO USE TICKET
Monthly Pass - Student |  |  |  |  |  |  | 30 |  |  | 1 month |  |  | $
 |  |  |  |  | month
10-Trip Student Fare |  |  |  |  |  |  | 8 |  |  |  |  |  | $
REDUCED FARE TICKETS - for Citizens age 60+ and People w/Disabilities
VALID I.D. REQUIRED TO USE TICKET -
(TransIT Reduced Fare I.D., MVA-issued I.D., Medicare I.D., City of Frederick Senior Citizen or Handicapped I.D. card)
Monthly Pass-Reduced Fare |  |  |  |  |  |  | 30 |  |  | 1 month |  |  | $
 |  |  |  |  | month
10-Trip Reduced Fare |  |  |  |  |  |  | 5.5 |  |  |  |  |  | $
21-Trip Reduced Fare |  |  |  |  |  |  | 11 |  |  |  |  |  | $
TransIT-plus Tickets
Demand response transportation for PRE-REGISTERED senior citizens (age 60+) and
people with disabilities
TransIT-plus Multi-Ride Ticket |  |  |  |  |  |  | 15 |  |  |  |  |  | $
[NAME]: (for questions) |  |  |  |  |  |  |  |  |  | [NAME]:
Mail Pass/Tickets to: (please print clearly)
Name:
Mailing Address: |  |  |  |  |  |  |  |  |  |  |  |  | Apt.#
City and Zip Code:
TransIT Services is not responsible for delay in the mail or lost/stolen mail.
1040 Rocky Springs Rd. |  |  |  |  |  |  |  |  |  | Phone: | [PHONE]
Frederick, MD 21702 |  |  |  |  |  |  |  |  |  | Fax: | [PHONE]
www.FrederickCountyMD.gov/transit |  |  |  |  |  |  |  |  |  | [NAME]: | [EMAIL]
Spreadsheet: 680216d1590858613-sumproduct-based-on-year-date-or-datevalue-test2_inv2020
Sheet: Sheet1

Date | Unit | Costs
2018-10-01 00:00:00 | 236 | 100.89
2018-10-01 00:00:00 | 29 | 101.17
2018-09-26 00:00:00 | 220 | 114.47
2019-02-26 00:00:00 | 6 | 157.86
2019-03-22 00:00:00 | 0.005 | 182.79
2019-06-21 00:00:00 | 0.006 | 153.52
2019-09-20 00:00:00 | 0.005 | 177.04
 |  |  | =SUMPRODUCT(B2:B8,C2:C8,(YEAR(A2:A8=2018)))
 |  |  | =SUMPRODUCT(YEAR(A2:A8=2018),B2:B8,C2:C8)
 |  |  | =SUMPRODUCT(A2:A8<DATE(2019,1,1),B2:B8,C2:C8)
 |  |  | =SUMPRODUCT(A2:A9<DATEVALUE("1/1/2019"),B2:B9,C2:C9)
Spreadsheet: 137049d1326925240-finding-a-column-value-based-on-date-and-column-header-example
Sheet: Weekly_new

Weekending | 2012-01-08 00:00:00 |  |  |  | Month of January |  |  |  |  | Month of February |  |  |  |  | Month of March |  |  |  |  |  | Month of April |  |  |  |  | Month of May |  |  |  |  | Month of June |  |  |  |  |  | Month of July |  |  |  |  | Month of August |  |  |  |  |  | Month of September |  |  |  |  | Month of October |  |  |  |  | Month of November |  |  |  |  |  | Month of December
Alize Gold
Alize Red
[NAME]
Spreadsheet: 032eb855-5dbc-4d13-b09c-36c1e8d50a9c
Sheet: Ranked List

Rank | Reference | Outcome
1 | BB/L02540X/1 | Funded
2 | BB/L025582/1 | Funded
2 | BB/[NAME] | Funded
2 | BB/L025531/1 | Funded
2 | BB/L025566/1 | Funded
3 | BB/L025272/1 | Funded
3 | BB/L025299/1 | Funded
3 | BB/L025477/1 | Funded
4 | BB/L02554X/1 | Funded
5 | BB/L025515/1 | Funded
5 | BB/L025248/1 | Funded
5 | BB/L025264/1 | Funded
5 | BB/L025396/1 | Funded
6 | BB/L025485/1 | Funded
7 | BB/L025434/1 | Fundable
7 | BB/L025256/1 | Fundable
8 | BB/L025574/1 | Fundable
9 | BB/L025507/1 | Fundable
10 | BB/L025442/1 | Fundable
10 | BB/L025329/1 | Fundable
11 | BB/L025337/1 | Fundable
12 | BB/L025493/1 | Fundable
12 | BB/L025388/1 | Fundable
13 | BB/L025361/1 | Fundable
13 | BB/L025353/1 | Fundable
14 | BB/L02537X/1 | Fundable
14 | BB/L025310/1 | Fundable
14 | BB/L025426/1 | Fundable
15 | BB/L025469/1 | Fundable
16 | BB/[NAME] | Fundable
17 | BB/L025558/1 | Fundable
Spreadsheet: 71289d1271960577-stopping-spreadsheet-at-a-certain-number-roadmap-template
Sheet: Client Data

 |  |  |  | Roadmap Analysis: Prepared for Sam & Sally Sample
 |  |  | Analysis Date: | 2009-12-31 00:00:00
 |  |  |  | Basic Client Information
Last Name | Sample
First Name | [NAME]
Date of Birth | 1955-12-31 00:00:00
Current Age | 53
First Name | [NAME]
Date of Birth | 1955-12-31 00:00:00
Address | 123 Elm St |  | Best Daytime Phone | [PHONE]
City, State  ZIP | Anytown, US  12231 |  | [NAME] | [EMAIL]
 |  |  |  | Basic Assumptions
 |  |  | Estimated Monthly Contributions to Investment Plan Prior to Retirement | 5000
 |  |  | Target Retirement Age | 65
 |  |  | Years to Retire | 11
 |  |  | Years of Retirement | 30
 |  |  | Estimated Household Income | 250000
 |  |  | Marginal Tax Rate | 0.33
 |  |  | LT Capital Gains Tax Rate | 0.15
 |  |  | Qualified Dividend Tax Rate | 0.15
 |  |  | Blended Investment Tax Rate Estimate | 0.0525
 |  |  | TOTAL Desired Monthly Retirement Income | 20000
 |  |  | (NET: AFTER Taxes & INCLUDING expected Social Security)
 |  |  |  | Marginal Tax Rate Table
Spreadsheet: 758179d1638722436-index-formulas-to-rearrange-from-vertical-to-horizontal-tf16400504_win32
Sheet: Meal Planner - Updated

 |  | Meal Planner | Recipe Index
 | Week starting
 | Day of the Week | Recipe | Select your recipe for each weekday. The weekdays are automatically adjusted based on the starting day of the week entered in cell C2.
 |  | Spinach Feta Pizza
 |  | My New Recipe
 | Breakfast |  |  |  |  |  |  |  | [NAME]
 | Lunch
 | Dinner
 | Snacks
 | Other
 | Notes |  |  |  |  |  |  |  | Free text
Spreadsheet: 678754d1590050767-find-a-closing-balance-by-date-lookup-last-entry-against-date
Sheet: Sheet1

Weekending | Balance |  | Closing Balance
2020-05-10 00:00:00 | 7
2020-05-10 00:00:00 | 11 |  | Weekending | Balance
2020-05-10 00:00:00 | 16 |  | 2020-05-10 00:00:00
2020-05-10 00:00:00 | 13 |  | 2020-05-17 00:00:00
2020-05-17 00:00:00 | 13
2020-05-17 00:00:00 | 20
2020-05-17 00:00:00 | 5
Spreadsheet: 1a1f99ab-608c-4b41-9285-de84f988474f
Sheet: Sheet1

Table 3--U.S. fiber supply | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | May |  | June |  | July |  | July
Item | 2013 |  | 2013 |  | 2013 |  | 2012
 | 1,000 480-lb. [NAME]
Cotton:
Stocks, beginning | 7887 |  | 6209 | 6209 | 5049 |  | 4404
Ginnings | 0 |  | 0 |  | 0 |  | 0
Imports since August 1 | 5.3 |  | 8.6 |  | 9.9 |  | 18.7
 | Million pounds
Manmade:
Production | 536 |  | 515.2 |  | 584.8 |  | 507.9
Noncellulosic | 536 |  | 515.2 |  | 584.8 |  | 507.9
Cellulosic
Total since January 1 | 2625 |  | 3140.2 | 3140.2 | 3689 |  | 3543.7
 | Apr. |  | May |  | June |  | June
 | 2013 |  | 2013 |  | 2013 |  | 2012
 | Million pounds
Raw fiber imports: | 158.9 |  | 167.3 |  | 141.7 |  | 159.2
Noncellulosic | 147.2 |  | 153.5 |  | 129.8 |  | 145.1
Cellulosic | 11.7 |  | 13.8 |  | 11.9 |  | 14.1
Total since January 1 | 448.1 |  | 615.4 |  | 757.1 |  | 945.4
 | 1,000 pounds
Wool and mohair:
Raw wool imports, clean | 819.7 |  | 909.1 |  | 878.4 |  | 944.7
48s-and-finer | 569 |  | 541.2 |  | 494.1 |  | 540.3
Not-finer-than-46s | 250.7 |  | 367.9 |  | 384.3 |  | 404.3
Total since January 1 | 1887.1 |  | 2796.2 |  | 3674.6 |  | 5443.8
Wool top imports | 564.1 |  | 532.8 |  | 401.8 |  | 317.2
Total since January 1 | 2339.1 |  | 2872 |  | 3273.7 |  | 1969.3
Mohair imports, clean | 0 |  | 0 | 0 | 0 |  | 0
Total since January 1 | 0 |  | 0 | 0 | 0 |  | 0
NA = Not available.
Sources: USDA, National Agricultural Statistics Service;
U.S. Dept. of Commerce, U.S. Census Bureau; and [NAME].
Last update: 09/16/13.
Spreadsheet: 95b5ae42-51e7-46c2-9d5f-bb98733c0449
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
BCARO | Test | BCARO | Beta-Carotene, Serum | Beta-Carotene, S | High-Performance Liquid Chromatography (HPLC) |  |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Amber vial (Supply T192) [NAME]: 1 mL Collection Instructions: Send specimen in amber vial to protect from light. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =18 years: 2.3-65.0 mcg/dL <18 years: not established | Varies, batched 2 times per week | 2 days | 6 days | 1 | 82380 |  |  |  |  | New England
BCARO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BCARO | Result | 62166 | Beta-Carotene, S | Beta-Carotene, S | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2053-7 | [NAME]:MCnc:Pt:Ser:Qn:
Spreadsheet: 697496d1601384795-getting-inconsistent-formula-and-dont-know-why-sample-sheet
Sheet: Joel. sample sheet

Why does this generate an "Inconsistent Formula" Error? |  |  |  |  |  |  |  |  |  | Why does adding a blank column fix the error?
Income | Monthly Bills |  | Expenses |  | Other |  |  |  |  | Income | Monthly Bills |  |  | Expenses |  |  | Other
777.27 | 138.67 |  | 150 |  | 43.21 |  |  |  |  | 777.27 | 138.67 |  |  | 150 |  |  | 43.21
 | 70 |  | 25.5 |  |  |  |  |  |  |  | 70 |  |  | 25.5
 | 90.68 |  | 40 |  |  |  |  |  |  |  | 90.68 |  |  | 40