tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dc824bc5-ec53-4c5d-aab5-86c1719c1e4b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME | PROGRAM
4488 | 5308 | Hamish | [NAME] | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:10:00 | Elite Men
4488 | 15348 | Stephen | [NAME] | AUS | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:12:21 | Elite Men
4488 | 15027 | [NAME] | Riccitello | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:12:31 | Elite Men
4487 | 15305 | Sabine | [NAME] | GER | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:29:26 | Elite Women
4487 | 10228 | [NAME] | Rose | NZL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:31:59 | Elite Women
4487 | 10334 | [NAME] | Smyers | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:37:13 | Elite Women
Spreadsheet: 841380d1693564331-countifs-not-counting-correctly-help
Sheet: SUMMARY

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SITES | NUMBER OF TEAM LEADERS | NUMBER OF WC | STATUS | JAN AND FEB |  |  | [NAME] |  |  | APRIL |  |  | MAY |  |  | TOTAL (4 MONTHS)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS | % Total/No WC | Completed & Date is Blank | TOTALS | % Total/No WC | Completed & Date is Blank | TOTALS | % Total No. WC | Blank  SCAN | TOTALS | % Total No. WC | Blank SCAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 11
Spreadsheet: 837000d1689778758-if-string-appears-in-array-add-header-name-excel-formula-example-6-
Sheet: REPORT

MNGR | store | employee | ID
 | abc | ash | 1
 | abc | ton | 2
 | abc | [NAME] | 3
 | abc | joy | 4
 | abc | [NAME] | 5
 | abc | alec | 6
 | abc | jor | 7
 | abc | [NAME] | 8
 | [NAME] | ash | 9
 | [NAME] | ton | 10
 | [NAME] | [NAME] | 11
 | lmn | joy | 12
 | lmn | [NAME] | 13
 | [NAME] | alec | 14
 | [NAME] | jor | 15
 | [NAME] | [NAME] | 16
 | hij | ash | 17
 | hij | ton | 18
 | hij | [NAME] | 19
 | hij | joy | 20
 | hij | [NAME] | 21
 | zab | alec | 22
 | zab | jor | 23
 | zab | [NAME] | 24
 | zab | ash | 25
 | [NAME] | ton | 26
 | [NAME] | [NAME] | 27
 | zab | joy | 28
 | zab | [NAME] | 29
 | uvw | alec | 30
 | uvw | jor | 31
 | uvw | [NAME] | 32
 | uvw | ash | 33
 | uvw | ton | 34
 | uvw | [NAME] | 35
 | fgh | joy | 36
 | fgh | [NAME] | 37
 | fgh | alec | 38
 | fgh | jor | 39
 | fgh | [NAME] | 40
 | fgh | ash | 41
 | fgh | ton | 42
 | yza | [NAME] | 43
 | yza | joy | 44
 | yza | [NAME] | 45
 | yza | alec | 46
 | mno | jor | 47
 | pqr | [NAME] | 48
 | pqr | ash | 49
 | pqr | ton | 50
 | pqr | [NAME] | 51
 | pqr | joy | 52
 | mno | [NAME] | 53
 | pqr | alec | 54
 | pqr | jor | 55
 | mno | [NAME] | 56
 | pqr
Spreadsheet: 743457d1628519016-formula-s-for-choosing-and-calculating-milage-rates-expenses_sheet_main
Sheet: February

Employee Business Kilometres & Subsistence Expenses Claim |  |  |  |  |  | Period Ended:
Employee Name: |  |  |  |  | Car Reg
 |  |  |  |  | Engine Size
Home Address:
 |  |  |  |  | Start Odometer Reading
 |  |  |  |  | Current Odometer Reading
Mileage |  |  |  |  |  | Subsistence
 |  |  |  |  |  | <10HR | >10HR | O/N
Date | Reason for Journey |  | To | From | Total | 15.41 | 36.97 | 147
 |  |  |  |  | 100
 |  |  |  |  | 1
 |  | This Month | Last Month | Annual to date
Total Business Kilometres |  |  |  |  | Total
Rate Applicable
Value of Mileage Claim (KM x rate) |  |  |  |  | Total Claim (mileage & subsistence)
Rates per Kilometre are determined by Engine Size
 |  | Distance (KM) | Under 1200cc | 1201 to 1500cc | 1501 and over
 |  | 0 - 1500 | 0.3795 | 0.3986 | 0.4479
 |  | 1501 - 5500 | 0.7 | 0.7321 | 0.8353
 |  | 5501 - 25000 | 0.2755 | 0.2903 | 0.3221
 |  | *Rates change after completing 1500/5500 business kilometres
Signed |  |  |  |  | Date
Approved by |  |  |  |  | Date
Return this form within seven days of month end to accounts department
Spreadsheet: 716393d1612193753-pulling-data-from-a-table-that-changes-size-district-schedule-report-3-1-
Sheet: Page1_1

Schedule for District |  |  |  |  | Jan 31, 2021 - Feb 6, 2021
Property Id | Employee Name | Sunday 31/Jan | Monday 1/Feb | Tuesday 2/Feb | Wednesday 3/Feb | Thursday 4/Feb | Friday 5/Feb | Saturday 6/Feb
12345 | Employee A |  |  |  |  |  |  | 9:30 - 5:00
 | Employee B |  | 9:30 - 6:00
 | Employee C | 9:30 - 6:00 |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12346 | Employee C |  | 9:30 - 6:00
 | Employee D | 9:30 - 5:00 |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12347 | Employee E |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee F | 9:30 - 5:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12348 | Employee G |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee B | 9:30 - 5:00
12349 | Employee H |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00
 | Employee I | 9:30 - 5:00 | 9:30 - 6:00
12350 | Employee J |  |  |  |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee K | 9:30 - 5:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00
12351 | Employee L |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee J | 9:30 - 5:00 | 9:30 - 6:00
12352 | Employee B |  |  |  |  | 9:30 - 6:00
 | Employee I |  |  | 9:30 - 6:00 | 9:30 - 6:00 |  | 9:00 - 6:00
 | Employee E | 9:30 - 5:00 | 9:30 - 6:00 |  |  |  |  | 9:30 - 5:00
12353 | Employee J |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee M | 9:30 - 5:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12354 | Employee A |  |  | 9:30 - 6:00 | 9:30 - 6:00
 | Employee N | 9:30 - 0:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
12355 | Employee O | 9:30 - 5:00 | 9:30 - 6:00 |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee B |  |  | 9:30 - 6:00
12356 | Employee P | 9:30 - 5:00 | 9:30 - 6:00 | 9:30 - 6:00 |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Employee B |  |  |  | 9:30 - 6:00
12357 | Employee A | 9:30 - 5:00 | 9:30 - 6:00
 | Employee Q |  |  | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 6:00 | 9:30 - 5:00
 | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat
Employee A
Employee B
Employee C
Employee D
Employee E
Employee F
Employee G
Employee H
Employee I
Employee J
Employee K
Employee L
Employee M
Employee N
Employee O
Employee P
Employee Q
Spreadsheet: 754429d1636166180-calculate-isblank-with-multiple-conditions-cableghost-trades-template-
Sheet: CALCS

TIME CALCS
START | END | TOTAL TIME | ENTRIES | AVE PRICE | TRADED %
08:00:00 | 08:29:00
08:30:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 15:59:00
FED TAX TABLE
Income
Tax Rate
M-to-M | Yes
INCOME | RATE
19750 | 0.1
80250 | 0.12
171050 | 0.22
326600 | 0.24
414700 | 0.32
622050 | 0.35
 | 0.37
Spreadsheet: 100141d1298568916-how-to-paste-last-row-of-all-sheets-in-master-sheet-in-excel-2007-leave-status
Sheet: Shelendra Kumar

GO TO MASTER PRESENT STATUS SHEET
 | [NAME] Officer - Leave Records as on Sep 30, 2009
 | Sl | Project | Dates |  | Days worked | Rotational Leave |  |  | ML
 |  |  | From | To |  | Earned | Availed | Balance
 | 1 | HO - Joining, [NAME] | 2008-12-09 00:00:00 | 2008-12-22 00:00:00 |  |  | - |  | -
 | 2 | HOEC - Margerita | 2008-12-23 00:00:00 | 2009-02-24 00:00:00 |  |  | - |  | -
 |  | Leave |  | 2009-03-21 00:00:00 | - | -
 | 3 | HOEC - Margerita |  | 2009-07-09 00:00:00 |  |  | - |  | -
 |  | Leave |  | 2009-08-20 00:00:00 | - | - |  | -
 | 4 | Cauvery Crew - II |  | 2009-10-11 00:00:00 |  |  | - |  | -
 |  | Leave | 2009-10-12 00:00:00 | 2009-12-17 00:00:00 |  |  |  |  |  | Marked LOP
 | 5 | Naftogaz - Margerita | 2009-12-18 00:00:00 | 2010-04-04 00:00:00
 |  | Leave |  | 2010-05-11 00:00:00
 | 6 | Naftogaz - Margerita |  | 2010-07-05 00:00:00 |  |  | -
 |  | Leave |  | 2010-10-06 00:00:00 |  |  |  |  |  | 18 days [NAME] in Aug,10
 | 7 | Naftogaz - Margerita |  | 2010-12-18 00:00:00
 |  | Leave |  | 2011-01-12 00:00:00
 | 8 | Margerita
 | 9
Spreadsheet: 144679d1331093546-excluding-certain-value-from-max-function-that-has-multiple-separated-values-uniform-20issuance-20analysis-1-
Sheet: Formula Experimentation

Latest Issuance |  |  |  | 1st Issuance |  |  |  | 2nd Issuance |  |  |  | 3rd Issuance |  |  |  | 4th Issuance |  |  |  | 5th Issuance |  |  |  | 6th Issuance |  |  |  |  | 7th Issuance |  |  |  | 8th Issuance
DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY |  | DATE ISSUED | TYPE | SIZE | QTY | DATE ISSUED | TYPE | SIZE | QTY
2011-06-24 00:00:00 | MATERNITY | XL | 1 | 2007-07-25 00:00:00 | D/B - (S) | L | 1 | 2008-08-07 00:00:00 | D/B - (S) | L | 1 | 2009-04-06 00:00:00 | MATERNITY | XL | 2 | 2009-12-29 00:00:00 | D/B - (S) | XL | 1 | 2010-08-02 00:00:00 | D/B - (S) | XL | 1 | 2011-06-24 00:00:00 | MATERNITY | XL | 1 |  | 2008-08-07 00:00:00 | D/B - (S) | L | 1 | 2009-04-06 00:00:00 | MATERNITY | XL | 2
 | OFFSET(INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:[NAME])))), 0, 1, 1, 1)
 | 2100-12-31 00:00:00 | INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4)<>"MATERNITY",E4:[NAME])))
 |  | #N/A
 | if(OFFSET(INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:[NAME])))), 0, 1, 1, 1)="MATERNITY",OFFSET(INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX({E4,I4,M4,Q4,U4,Y4}<>INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:AB4,0))))),E4:[NAME])))), 0, 1, 1, 1),OFFSET(INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:[NAME])))), 0, 1, 1, 1))
 | if(OFFSET(INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:[NAME])))), 0, 1, 1, 1)="MATERNITY",OFFSET(INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX({E4,I4,M4,Q4,U4,Y4}<>INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:AB4,0))))),E4:[NAME])))), 0, 1, 1, 1),OFFSET(INDIRECT(CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:[NAME])))), 0, 1, 1, 1))
 | MAX(E4,I4,M4,Q4,U4,Y4,<>CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:[NAME]))))
 | MAX(E4,I4,M4,Q4,U4,Y4,<>CELL("address",INDEX(E4:AB4,MATCH(MAX(E4,I4,M4,Q4,U4,Y4),E4:[NAME]))))
 | $[NAME]
Spreadsheet: 7b49407d-b47a-49b7-a87a-ef0f3d5bcc6c
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
[NAME] | Football | COASTAL CAROLINA | W, 31-0
09/10/2010 | Football | at [NAME] | W, 24-21 (OT)
09/18/2010 | Football | MARYLAND | W, 31-17
[NAME] | Football | at LSU | L, 14-20
10/09/2010 | Football | UNLV | W, 49-10
10/14/2010 | Football | USF | W, 20-6
10/23/2010 | Football | SYRACUSE | L, 14-19
10/29/2010 | Football | at Connecticut | L, 13-16, OT
11/13/2010 | Football | CINCINNATI | W, 37-10
11/20/2010 | Football | at Louisville | W, 17-10
11/26/2010 | Football | at Pitt | W, 35-10
12/04/2010 | Football | RUTGERS | W, 35-14
12/28/2010 | Football | vs. NC State | L, 7-23
Spreadsheet: 04608b3a-ff08-45d7-8c13-8b5212ea2ef7
Sheet: Breakfast Production Record

Production Record-BREAKFAST
MENU PATTERN |  | MENU |  |  |  |  |  | DATE: |  |  | GRADES:
Meat/Meat Alternate
Grain |  |  |  |  |  |  |  |  |  |  | ADULTS:
Fruit |  |  |  |  |  |  |  | SITE:
Vegetable |  |  |  |  |  |  |  |  |  |  | TOTAL:
[NAME]
 |  | Planned |  |  |  |  |  | Actual
MENU COMPONENTS | STUDENT MEALS |  | ADULT MEALS OR AL A CARTE |  | TOTAL PLANNED SERVINGS | TOTAL PLANNED QUANTITY | PLANNED PURCHASE UNIT | QUANTITY PREPARED | PURCHASE UNIT | FOOD TEMPERATURE |  | ACTUAL SERVED | [NAME]
(Minimum Serving Size) | PLANNED | SERVING SIZE | PLANNED | SERVING SIZE | STUDENT+ADULT |  | (lbs., can, ozs.) |  | (lbs., can, ozs.) | PREP. | SERVING
Meat/ Meat Alternate:
Grains:
Fruit:
Vegetable:
Milk:
Other: (Condiments and [NAME])
Spreadsheet: 217960d1362268388-how-to-fill-row-based-on-multiple-criteria-with-the-most-recent-of-multiple-matches-dummysample-1
Sheet: Sample Inventory

Box | Position | Expression Vector | Concentration (ng/ul) | LOT # | Original Amount (ug) | Deducted (ug) | Amount Remaining | [NAME] (ul) | Requestor | Aliquot # | Date Aliquotted | Aliquotter
1 | 1 | Sample 1 | 500 | 123456 | 250
1 | 2 | Sample 3 | 2000 | 734902 | 250
1 | 3 | Sample 6 | 50 | 749584 | 250
1 | 4 | …
1 | 5 | …
1 | 6 | …
1 | 7 | …
1 | 8 | …
1 | 9 | …
1 | 10 | …
1 | 11 | …
1 | 12 | …
1 | 13 | …
1 | 14 | …
2 | 1 | …
2 | 2 | Sample 2 | 500 | 543253 | 250
2 | 3 | Sample 4 | 700 | 183087 | 250
2 | 4 | …
2 | 5 | …
2 | 6 | …
2 | 7 | …
2 | 8 | …
2 | 9 | …
2 | 10 | …
2 | 11 | …
2 | 12 | …
2 | 13
2 | 14
3
…
…
Spreadsheet: 679332d1590336770-index-match-duplicate-values-need-to-ignore-zeros-or-blanks-in-range-example-copy
Sheet: Sheet1

Team | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7
 |  |  |  |  |  |  |  |  | Top Team | Second Top Team
Score | 1 | 2 | 1 | 3 | 2 | 0 | 1 |  |  |  |  | (Array formula)
 | 4 | 3 | 3 | 0 | 3 | 1 | 2 |  |  |  |  | INDEX($B$4:$H$4,MATCH(LARGE($B7:$H7-COLUMN($B7:$H7)/10^10,COLUMNS($J7:J7)),$B7:$H7-COLUMN($B7:$H7)/10^10,0))
 | 2 | 4 | 2 | 2 | 3 | 4 | 3
 | 4 | 0 | 1 | 3 | 3 | 4 | 2
 | 4 | 1 | 3 | 2 | 3 | 4 | 1
 | 2 | 2 | 3 | 0 | 1 | 2 | 4
 | 1 | 4 | 4 | 3 | 2 | 3 | 0
 | 0 | 1 | 1 | 4 | 4 | 1 | 4
 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  |  |  |  |  |  |  |  | Requirement
 |  |  |  |  |  |  |  |  | I need the answers above, for both top team & second top team to only be teams that have scored greater than 0
 |  |  |  |  |  |  |  |  | See example of the bottom row, the only top score is 1. In this example, as all other scores are 0, the second top team result would be blank. However it is showing as "Team 1." I require it to be blank / ignore 0
Spreadsheet: 76690d1277211672-sorting-columns-spreadsheet2
Sheet: Sheet1

Host | Description | Title | ProductCode
Something | Something2 | Something3 | P567421X
Something | Something3 | Something4 | 125678034
Something | Something4 | Something5 | Product
Something | Something5 | Something6 | 99.223.014
Something | Something6 | Something7 | CB.EF.37.4SB
Spreadsheet: 4aa50182-0eef-4077-a75e-036dab2ebb12
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (10 Entries):
 | 6 Reagents, chemicals 6.2 Reagents/analyzers for clinical chemistry
No. | Company | Country | City | [NAME] | Hall/Booth
1 | Campro Scientific GmbH | Germany | Berlin | 14167 | A2.437
2 | CHROMSYSTEMS Instruments & Chemicals GmbH | Germany | Gräfelfing / München | 82166 | B1.211
3 | Distrilab Particles | Netherlands | Leusden | 3833 AV | A3.150
4 | FEW Chemicals GmbH | Germany | Wolfen | 06766 | A3.506
5 | [NAME] | Germany | Wetzlar | 35578 | A2.205/306
6 | Livchem Logistic GmbH | Germany | Frankfurt | 65933 | A1.508B
7 | New England Biolabs GmbH | Germany | Frankfurt | 65926 | A3.351
8 | RECIPE Chemicals+Instruments GmbH | Germany | München | 80992 | A1.436
9 | Thermo Scientific | Germany | Dreieich | 63303 | B1.101/202
10 | Woodley Laboratory Diagnostics | United Kingdom | [NAME], [NAME] | BL6 5UE | B2.215A
Spreadsheet: 840341d1692664995-offset-indirect-formula-with-increasing-delta-change-in-row-position-examplecalender-astrodude-
Sheet: 10

Week beginning | Use the drop down menu in the 'Week Beginning' column to select the week you wish to view.
 | STORE | TRANSFERS | 2023-01-02 00:00:00
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1 |  |  |  |  |  |  |  | 3
 | Position 2 |  |  |  |  |  |  |  | 4
 | Position 3 |  |  |  |  |  |  |  | 5
 | Position 4 |  |  |  |  |  |  |  | 6
 | Position 5 |  |  |  |  |  |  |  | 7
 | STORE | TRANSFERS
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1 |  |  |  |  |  |  |  | 10
 | Position 2 |  |  |  |  |  |  |  | 11
 | Position 3 |  |  |  |  |  |  |  | 12
 | Position 4 |  |  |  |  |  |  |  | 13
 | Position 5 |  |  |  |  |  |  |  | 14
 | STORE | TRANSFERS
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
 | STORE | TRANSFERS
 | Meetings
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
 | STORE | TRANSFERS
 | Truck
 |  |  |  | Staffing
 |  |  |  | DC Notes
 |  |  |  | Store Notes
 |  |  |  | VACATION CALENDAR
 | Position 1
 | Position 2
 | Position 3
 | Position 4
 | Position 5
Spreadsheet: 61490d1262369047-if-statement-example-of-vlookup-to-replace-nested-if-statements
Sheet: Sheet1

 |  |  |  |  |  |  | Original formula
 |  |  |  |  | Input Cell
 |  |  |  |  | 8 |  | can theoretically be shortened to the below because the first part of each And statement is redundant due to the previous IF test.
 |  |  |  |  |  |  | However, there are still more than 7 Nested If statements therefore the formulae won't work...
 |  |  |  |  |  |  | An alternative approach is to use a lookup table (sorted in ascending order).
 |  |  |  |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  | I have added the "sensitivity" cell as a small amount (this can be made even smaller) to ensure that a value of "8" will return the correct result of "0.6".
 |  |  |  |  |  |  |  |  |  | Sensitivity | 0.01
 |  |  |  |  |  |  |  |  |  | Lookup table
 |  |  |  |  |  |  |  | Amounts from thread |  | Amount | Value to Return
 |  |  |  |  |  |  |  | 0 |  | 0.01 | 0.6
 |  |  |  |  |  |  |  | 8 |  | 8.01 | 0.8
 |  |  |  |  |  |  |  | 13 |  | 13.01 | 0.9
 |  |  |  |  |  |  |  | 18 |  | 18.01 | 1.1
 |  |  |  |  |  |  |  | 24 |  | 24.01 | 1.4
 |  |  |  |  |  |  |  | 30 |  | 30.01 | 1.55
 |  |  |  |  |  |  |  | 40 |  | 40.01 | 1.85
 |  |  |  |  |  |  |  | 55 |  | 55.01 | 2.15
 |  |  |  |  |  |  |  | 68 |  | 68.01 | 2.65
 |  |  |  |  |  |  |  | 85 |  | 85.01 | 3.45
 |  |  |  |  |  |  |  | 100 |  | 100.01 | 4.55
 |  |  |  |  |  |  |  | 120 |  | 120.01 | 6.55
 |  |  |  |  |  |  |  | 150 |  | 150.01 | 10.85
 |  |  |  |  |  |  |  | 210 |  | 210.01 | 15.1
Spreadsheet: f90cf79f-f4e1-4da9-95f1-60977fcd1240
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3916 | 25468 | Hans | Dieben | NED | 0 | [NAME] | 00:00:00 | 02:13:24 | 00:00:00 | 01:26:58 | 1 | 04:37:14
3916 | 8035 | Stuart | Lumb | GBR | 0 | 01:11:27 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 802580d1666929006-lazy-old-man-needs-formula-to-sum-values-by-month-need-formula-for-total-column-thanks-2-
Sheet: Sheet1

Input |  |  |  | Output
Dates | Numbers |  |  | Months Away | Total | Month |  | Note the "OUTPUT" list will automatically calculate so that "Months Away" = 0 will always be the actual current month and the next 24 months (after the current month) will always be displayed. Each month will show the sum of "Numbers" in the [NAME] table that fall within that month.  Any data with dates before the current month will be ignored.  "Months Away" ("0" equals current month, 1= Next month, etc.)  "Total" is the sum of all the Numbers from the [NAME] table in the month (I need a formula for this).  "Month" is the month and year of the month that is "Month's Away" number of months away from the current month. (I need a formula for this)  I just use Edate() for the Month column.  What I need is the formula for the "Total" column.  If possible please provide it as a single formula rather than broken into parts in additional columns.
2023-03-10 00:00:00 | 186 |  | (current month)> | 0 |  | 2023-03-01 00:00:00
2023-08-16 00:00:00 | 70.96 |  | (next month)> | 1 |  | 2023-04-01 00:00:00
2024-12-24 00:00:00 | 50 |  | etc. | 2 |  | 2023-05-01 00:00:00
2024-05-20 00:00:00 | 88.44 |  | . | 3 |  | 2023-06-01 00:00:00
2024-12-03 00:00:00 | 96 |  | . | 4 |  | 2023-07-01 00:00:00
2023-04-02 00:00:00 | 43.27 |  | . | 5 |  | 2023-08-01 00:00:00
2023-03-24 00:00:00 | 499.33 |  | . | 6 |  | 2023-09-01 00:00:00
2024-07-04 00:00:00 | 7 |  | . | 7 |  | 2023-10-01 00:00:00
 |  |  | . | 8 |  | 2023-11-01 00:00:00
Note data pairs in list will be in random date order. |  |  | . | 9 |  | 2023-12-01 00:00:00
 |  |  | . | 10 |  | 2024-01-01 00:00:00
 |  |  |  | 11 |  | 2024-02-01 00:00:00
 |  |  |  | 12 |  | 2024-03-01 00:00:00
 |  |  |  | 13 |  | 2024-04-01 00:00:00
 |  |  |  | 14 |  | 2024-05-01 00:00:00
 |  |  |  | 15 |  | 2024-06-01 00:00:00
 |  |  |  | 16 |  | 2024-07-01 00:00:00
 |  |  |  | 17 |  | 2024-08-01 00:00:00
 |  |  |  | 18 |  | 2024-09-01 00:00:00
 |  |  |  | 19 |  | 2024-10-01 00:00:00
 |  |  |  | 20 |  | 2024-11-01 00:00:00
 |  |  |  | 21 |  | 2024-12-01 00:00:00
 |  |  |  | 22 |  | 2025-01-01 00:00:00
 |  |  |  | 23 |  | 2025-02-01 00:00:00
 |  |  |  | 24 |  | 2025-03-01 00:00:00
Spreadsheet: 97925d1297026936-design-of-table-for-product-market-cost-calculate-procut_market_value-1-
Sheet: RESULT

 |  | SELECT PARTNO
 | 2011 | 02.019.04.0.00
MONTH | YEAR | PARTNO | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | NON BLANK DAY | BLANK DAYS | AVG. NON BLANK DAYS | MONTHLY AVG
JAN
FEB
MAR
APRIL
MAY
[NAME]
JULY
AUG
SEPT
OCT
NOV
DEC
 |  | TOTAL
 |  | AVG. TOTAL/MONTH DAY
Spreadsheet: 866814d1713737322-formula-to-insert-text-into-a-table-looking-at-time-location-sample-1b
Sheet: Sheet1

 |  | [NAME]
TIME |  | L-1 |  | L-2 |  | [NAME] |  | L-4 |  | [NAME] |  | L-6 |  | L-7 |  | L-8
9:00 - 9:59 |  | 22585(9:26) |  |  |  |  |  | 54487(9:48) |  |  |  |  |  |  |  | 22484(9:58)
12:00 - 12:59 |  |  |  | 74485(12:00) |  |  |  |  |  |  |  | 44125(12:44)
14:00-14:59 |  |  |  |  |  | 33226(14:22)
18:00-18:59 |  |  |  |  |  |  |  |  |  | 66598(18:22)
23:00-23:59 |  |  |  |  |  |  |  |  |  |  |  |  |  | 41145(23:16)
02:00-02:59 |  | 63352(2:12)
04:00-04:59 |  |  |  | 77894(4:01) |  |  |  | 22568(4:28) |  |  |  |  |  |  |  | 52289(4:49)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | # | Time | Location | Rte #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:26:00 | L-1 | 22585(9:26)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:48:00 | L-4 | 54487(9:48)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:58:00 | L-8 | 22484(9:58)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:00:00 | L-2 | 74485(12:00)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:44:00 | L-6 | 44125(12:44)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:22:00 | [NAME] | 33226(14:22)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:22:00 | [NAME] | 66598(18:22)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:16:00 | L-7 | 41145(23:16)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 02:12:00 | L-1 | 63352(2:12)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:01:00 | L-2 | 77894(4:01)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:28:00 | L-4 | 22568(4:28)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 04:49:00 | L-8 | 52289(4:49)