tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37665d1235692158-random-input-chores
Sheet: Sheet1

Child | Chore1 | Chore2 | Chore3
ChildName1 | Task3 | Task14 | Task6
ChildName2 | Task10 | Task9 | Task8 |  | Press F9 to get a new set of chores
ChildName3 | Task8 | Task13 | Task18 |  | Keep pressing F9 if any cells light up in yellow indicating duplicated chores
ChildName4 | Task15 | Task20 | Task14
[NAME] | Task19 | Task4 | Task7 |  | This sheet is set to manual calculation, so pressing F9 is required to get
ChildName6 | Task12 | Task12 | Task11 |  | any formulas to update, including the RAND() formulas down below.
ChildName7 | Task18 | Task5 | Task5
ChildName8 | Task9 | Task18 | Task17 |  | You can hide these helper columns if desired.
ChildName9 | Task11 | Task10 | Task3
ChildName10 | [NAME] | Task3 | Task20
ChildName11 | Task17 | [NAME] | Task1
ChildName12 | Task20 | Task11 | Task13
ChildName13 | Task16 | Task17 | Task16
ChildName14 | Task5 | Task16 | [NAME]
ChildName15 | Task6 | Task7 | Task9
ChildName16 | Task1 | Task15 | Task15
ChildName17 | Task7 | Task1 | Task4
ChildName18 | Task4 | Task6 | Task12
ChildName19 | Task13 | Task19 | Task19
ChildName20 | Task14 | Task8 | Task10
Chores |  |  |  |  | Rank | Rand | Rank2 | Rand2 | Rank3 | Rand3
Task1 |  |  |  |  | 16 | 0.2760490504351731 | 17 | 0.1389858998367588 | 11 | 0.3594792016714821
[NAME] |  |  |  |  | 10 | 0.4786450412912497 | 11 | 0.4323935377298831 | 14 | 0.3079327304745616
Task3 |  |  |  |  | 1 | 0.9614517587341862 | 10 | 0.4848367119968975 | 9 | 0.4280701311407391
Task4 |  |  |  |  | 18 | 0.1156509707741327 | 5 | 0.6306655372753609 | 17 | 0.15010436777004
Task5 |  |  |  |  | 14 | 0.4074895477164784 | 7 | 0.5467977967029185 | 7 | 0.5312581943508603
Task6 |  |  |  |  | 15 | 0.290451746664055 | 18 | 0.1336872702327581 | 1 | 0.8409949711961606
Task7 |  |  |  |  | 17 | 0.1212858750508801 | 15 | 0.2033104444845302 | 5 | 0.6927718748416765
Task8 |  |  |  |  | 3 | 0.8377576678630974 | 20 | 0.05272338428400758 | 2 | 0.7785757018258215
Task9 |  |  |  |  | 8 | 0.5714912962625112 | 2 | 0.8584136081300242 | 15 | 0.2824308182308626
Task10 |  |  |  |  | 2 | 0.8907998081247257 | 9 | 0.4971832839055086 | 20 | 0.01163164225077651
Task11 |  |  |  |  | 9 | 0.5093933840937295 | 12 | 0.4105445784776454 | 6 | 0.5605237576045881
Task12 |  |  |  |  | 6 | 0.6002756294211713 | 6 | 0.5488981631839875 | 18 | 0.08322740881283286
Task13 |  |  |  |  | 19 | 0.09985285932575616 | 3 | 0.8289779095684955 | 12 | 0.3430660076876664
Task14 |  |  |  |  | 20 | 0.09745317282461463 | 1 | 0.9218873300675092 | 4 | 0.7071916874172428
Task15 |  |  |  |  | 4 | 0.6808101433154086 | 16 | 0.1405036057081821 | 16 | 0.2084679227618871
Task16 |  |  |  |  | 13 | 0.4164422273540671 | 14 | 0.2828024329731971 | 13 | 0.3268505348718298
Task17 |  |  |  |  | 11 | 0.4559867594923388 | 13 | 0.338058012748399 | 8 | 0.5229293075508663
Task18 |  |  |  |  | 7 | 0.5920987264642505 | 8 | 0.520890388402883 | 3 | 0.768141752019929
Task19 |  |  |  |  | 5 | 0.6131410724227451 | 19 | 0.1175190111516589 | 19 | 0.08051432845067819
Task20 |  |  |  |  | 12 | 0.4349315243347371 | 4 | 0.6439837147070167 | 10 | 0.3719974346590877
Spreadsheet: 162932d1340121253-pull-information-based-on-week-date-falls-under-staff-by-week
Sheet: Sheet1

Week | Start of Week | End of Week | Staff
Week 1 | 2012-07-09 00:00:00 | 2012-07-15 00:00:00 | 11
Week 2 | 2012-07-16 00:00:00 | 2012-07-22 00:00:00 | 15
Week 3 | 2012-07-23 00:00:00 | 2012-07-29 00:00:00 | 16
Week 4 | 2012-07-30 00:00:00 | 2012-08-05 00:00:00 | 11
Week 5 | 2012-08-06 00:00:00 | 2012-08-12 00:00:00 | 17
Week 6 | 2012-08-13 00:00:00 | 2012-08-19 00:00:00 | 11
Week 7 | 2012-08-20 00:00:00 | 2012-08-26 00:00:00 | 21
Week 8 | 2012-08-27 00:00:00 | 2012-09-02 00:00:00 | 11
Week 9 | 2012-09-03 00:00:00 | 2012-09-09 00:00:00 | 14
Week 10 | 2012-09-10 00:00:00 | 2012-09-16 00:00:00 | 11
 | 2012-07-09 00:00:00
Staff
Spreadsheet: 155391d1336797608-need-help-with-macros-for-invoice-worksheet-invoice-sheet-revised
Sheet: Sheet1

Code | Description | Price |  | STOCK |  |  | STOCK
203010 | PART A | 2 |  | 10 |  |  | 10
203011 | PART B | 4 |  | 20 |  |  | 20
203012 | PART C | 6 |  | 28 |  |  | -2
203013 | PART D | 8 |  | 36 |  |  | 36
203014 | PART E | 10 |  | 50 |  |  | 50
203015 | PART F | 12 |  | 60 |  |  | 60
203016 | PART G | 14 |  | 70 |  |  | 70
Spreadsheet: 101402d1299537289-excel-formula-that-sums-the-times-rules-were-observed-by-line-of-business-lob-followrules
Sheet: EOBA vs SafeComm

Safe Comm vs EOBA 2011 YTD |  |  |  |  |  |  | District Avg Safe Comm Score
District | Safe Comm Rules Missed | # of Observations | EOBA Rules Missed | # of Observations |  |  | Hauling Site | [NAME] | [NAME] | Perfect Scores
Atlanta-East | 20 | 8 | 24 | 61 | 2.10655737704918 |  | Jacksonville | 99 | 99 | 2
Atlanta-South | 22 | 8 | 9 | 46 | 2.554347826086957 |  | Mt. Airy | 98.33333333333333 | 98.33333333333333 | 2
Atlanta-West | 12 | 4 | 28 | 45 | 2.377777777777778 |  | Orangeburg | 96.75 | 96.75 | 1
Augusta | 11 | 6 | 19 | 23 | 1.007246376811594 |  | Raleigh | 96.14285714285714 | 96.14285714285714
Columbia | 12 | 4 | 14 | 23 | 2.391304347826087 |  | Stoneville | 93.25 | 93.25 | 1
Fayetteville | 5 | 4 | 56 | 51 | 0.1519607843137254 |  | Spartanburg | 91.5 | 91.5
Gastonia | 10 | 4 | 14 | 22 | 1.863636363636364 |  | Gastonia | 90.5 | 90.5
Granite Quarry | 18 | 8 | 20 | 23 | 1.380434782608696 |  | Granite Quarry | 89.875 | 89.875
Jacksonville | 1 | 3 | 0 | 5 | 0.3333333333333333 |  | Savannah | 90.91666666666667 | 89.75
Mt. Airy | 2 | 3 | 0 | 3 | 0.6666666666666666 |  | Selma | 81.66666666666667 | 89.75 | 1
Orangeburg | 4 | 4 | 5 | 10 | 0.5 |  | Fayetteville | 89.75 | 89.5 | 1
Raleigh | 15 | 7 | 18 | 22 | 1.324675324675324 |  | Augusta | 89.5 | 89.33333333333333 | 1
[NAME] | 11 | 4 | 13 | 23 | 2.184782608695652 |  | Woodstock | 89.33333333333333 | 89.25 | 1
Savannah | 27 | 12 | 29 | 38 | 1.486842105263158 |  | [NAME] | 89.25 | 89
Selma | 8 | 4 | 2 | 15 | 1.866666666666667 |  | Atlanta-East | 89 | 87.25
Spartanburg | 10 | 4 | 28 | 36 | 1.722222222222222 |  | Atlanta-West | 87.25 | 85.5
Stoneville | 3 | 4 | 4 | 20 | 0.55 |  | Columbia | 85.5 | 83.5 | 1
Winston-Salem | 30 | 12 | 21 | 43 | 2.011627906976744 |  | Atlanta-South | 83.5 | 83.125
Woodstock | 22 | 8 | 5 | 34 | 2.602941176470588 |  | Winston-Salem | 83.125 | 81.66666666666667 | 1
 |  |  |  |  |  |  | Market Area | 89.23423423423424 | 89.23423423423424 | 13
Spreadsheet: 847334d1698317577-index-match-if-and-or-unsure-of-if-this-is-possible-book1
Sheet: Sheet1

Name | Company | 1st Activity ID | Activity 1 Date | 2nd Activity ID | Activity 2 Date | 3rd Activity ID | Activity 3 Date | 4th Activity ID | Activity 4 Date | Earliest Date  Attended | Earliest Activity Attended | Earliest Basket Weaving Activity Date | Earliest WoodWork Activity Date | Earliest Plumbing Activity Date | Earliest Electrical Activity Date
Mr A | Acme | 15/08/2004 - Electrical - Venus |  | 11/05/1999 -WoodWork - Saturn |  | 16/01/2009 - Plumbing - Pluto |  |  |  |  |  |  | 1999-05-11 00:00:00 | 2009-01-16 00:00:00 | 2004-08-15 00:00:00
Mr B | Duff Beer | 18/04/2018 - Electrical - Earth |  | 15/08/2004 - Electrical - Venus |  |  |  |  |  |  |  |  |  |  | 2004-08-15 00:00:00
Miss D | Acme | 17/12/2008 - Basket Weaving - Mars |  | 18/04/2018 - Electrical - Earth |  |  |  |  |  |  |  | 2008-12-17 00:00:00 |  |  | 2018-04-18 00:00:00
Mrs E | [NAME] | 18/04/2018 - Electrical - Earth |  | 17/12/2008 - Basket Weaving - Mars |  | 24/09/2021 - Plumbing - Venus |  | 16/01/2009 - Plumbing - Pluto |  |  |  | 2008-12-17 00:00:00 |  | 2009-01-16 00:00:00 | 2018-04-18 00:00:00
[NAME] | [NAME] | 11/05/1999 -WoodWork - Saturn |  | 15/08/2004 - Electrical - Venus |  |  |  |  |  |  |  |  | 1999-05-11 00:00:00 |  | 2004-08-15 00:00:00
Spreadsheet: 791461d1660370590-calculation-formula-problem-more-efficient-formula-aligw
Sheet: Sheet1

A | Cancel | 0 | Complete | 8 | Complete | 7 | Cancel | 4 | sa | Member |  |  | You: | AliGW:
C | Complete | 0 | Complete | 8 | Complete | 7 | Complete | 4 | ds | Claim
B | Complete | 0 | Complete | 8 | Complete | 7 | Complete | 4 | fd | Member
D | Panding | 1 | Panding | 8 | Panding | 7 | Panding | 4 | sa | Member
A | Complete | 1 | Complete | 3 | Panding | 5 | Panding | 0 | rf | Claim
C | Complete | 1 | Complete | 3 | Cancel | 5 | Complete | 0 | hg | Member
B | Panding | 5 | Panding | 3 | Panding | 5 | Cancel | 0 | fd | Claim
D | Complete | 5 | Cancel | 3 | Complete | 9 | Complete | 2 | gg | Member
B | Cancel | 5 | Cancel | 2 | Cancel | 9 | Cancel | 2 | rr | Member
C | Complete | 5 | Complete | 2 | Complete | 9 | Complete | 2 | tt | Other
Spreadsheet: 135278d1325890422-how-can-i-change-the-criteria-in-an-array-to-replace-sumproduct-excel-forum
Sheet: DATA

1 |  |  | 2 |  | 3 |  |  |  | 4 |  | 5 |  |  |  |  |  | 6 |  | 7 | 8 |  |  |  | 9 |  |  |  | 10 |  |  |  |  |  |  |  | 11 |  |  |  | 12
DATE dd/mm/yy |  |  | DEPARTURE |  | ARRIVAL |  |  |  | AIRCRAFT |  | SINGLE-PILOT TIME |  |  |  | MULTI-PILOT TIME |  | TOTAL TIME OF FLIGHT |  | NAME PIC | TAKEOFFS |  | LANDINGS |  | OPERATIONAL CONDITION TIME |  |  |  | PILOT FUNCTION TIME |  |  |  |  |  |  |  | SYNTHETIC TRAINING DEVICES SESSION |  |  |  | REMARKS AND ENDORSMENTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAY | NIGHT | DAY | NIGHT
DATE | MONTH | YEAR | PLACE | TIME | PLACE | TIME | TT |  | MAKE, MODEL, VARIANT | REGISTRATION | SE | ME | TP | TJ |  |  |  |  |  |  |  |  |  | NIGHT |  | IFR |  | PIC |  | CO-PILOT |  | DUAL |  | INSTRUCTOR |  | DATE (dd/mm/yy) | TYPE | TOTAL TIME
2003-01-01 00:00:00 |  |  | EGGD | 6:30:00 | EGHI | 6:50:00 |  |  | BOEING 737-600 | X-XXXX |  | √ |  | √ | 0 | 20 |  |  | SELF | 1 |  | 1 |  |  |  | 0 | 20 | 0 | 20
2003-02-05 00:00:00 | 2 | 2003 | EGGD | 20:20:00 | EGHI | 20:40:00 | 0:20:00 | 0 |  |  |  |  |  |  | 0 | 20 | 0 | 20 | SELF |  | 1 |  | 1 | 0 | 20 | 0 | 20 | 0 | 20
2003-05-10 00:00:00 | 5 | 2003 | EGGD | 21:10:00 | EGHI | 21:30:00 | 0:20:00 | 0 |  |  |  |  |  |  | 0 | 20 | 0 | 20 | SELF |  | 1 |  | 1 | 0 | 20 | 0 | 20 | 0 | 20
2004-10-08 00:00:00 | 10 | 2004 | EGGD | 15:50:00 | EGHI | 16:10:00 | 0:20:00 | 0 |  |  |  |  |  |  | 0 | 20 | 0 | 20 | SELF | 1 |  | 1 |  |  |  | 0 | 20 | 0 | 20
 | 1 | 1904 |  |  |  |  |  | 0
 | 1 | 1904 |  |  |  |  |  | 0
Spreadsheet: 71179d1271876405-counting-consecutive-values-excelforum
Sheet: Ark1

# of wins | # Consecutive wins | # Consecutive losses | Trade 1 | Trade 2 | Trade 3 | Trade 4 | Trade 5 | Trade 6 | Trade 7 | Trade 8 | Trade 9 | Trade 10
Spreadsheet: 106786d1303965230-hide-rows-if-value-0-need-help-please-hiding-rowsadvfilter
Sheet: Sheet1

Building Materials
Unit | Nail Type | Length | Total Length
5 | A1 | 0.7
0 | B1 | 0.9
2 | C1 | 1.1
2 | D1 | 1.3
1 | E1 | 1.5
0 | F1 | 1.7
Spreadsheet: 850474d1700816498-follow-up-to-retrieve-all-entries-of-data-based-on-several-criteria-thread-help3-ans
Sheet: APJ_Plan-On-A-Page_Draft

[NAME]
[NAME]
 |  |  |  | ALLOW MULTI-SELECT FOR QUARTER AND CATEGORY and populate below with all entries
 | Q1-2024 | Won
 | Q2-2024 | Likely
job | id | Stage | Stage Duration | brand 1 | brand 2 | Close Date
 | 1 | done | 49 | 150000 | 0 | 45135
Job 5 | 5 | done | 80 | 20000 | 15000 | 45135
Job 9 | 9 | late | 56 | 50242 | 0 | 45191
Spreadsheet: 08715c54-3d86-4b65-9771-6f38a7e63b00
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
NO | NAME | COUNTRY | THOMAS & UBER CUP | WORLD JUNIOR CHAMPIONSHIPS | WORLD CHAMPIONSHIPS | SUPERSERIES FINALS
 |  |  | 18 - 25 May | 7 - 18 April | 25 - 31 August | 10 - 14 December
1 | [NAME] | BEL | √ | √ | √ | √
2 | [NAME] | BEL | √ |  | √
3 | Jan KOLAR | CZE
4 | [NAME] | CZE
5 | Preben Johannes Hansen | DEN | √
6 | Ole Riis | DEN | √ |  |  | √
7 | [NAME] | DEN |  | √ |  | √
8 | Preben [NAME] | DEN | √ | √ |  | √
9 | [NAME] | DEN | √ |  |  | √
10 | [NAME] | DEN
11 | Yunus SULEMAN | ENG | √ | √
12 | [NAME] | ENG |  |  |  | √
13 | [NAME] | ENG |  |  | √
14 | Deverell Morris | ENG
15 | [NAME] | ENG | √ | √ | √ | √
16 | [NAME] | ENG | √ | √ |  | √
17 | Francois MESTON | FRA | √ |  | √ | √
18 | [NAME] | FRA |  |  | √
19 | [NAME] | FRA |  |  | √ | √
20 | [NAME] | FRA |  |  | √
21 | [NAME] | GER | √ |  | √
22 | [NAME] | GER | √ | √ |  | √
23 | [NAME] | GER |  |  | √
24 | [NAME] | GER | √ |  | √ | √
25 | [NAME] | GER | √ |  | √ | √
26 | [NAME] | HUN
27 | [NAME] | NED | √ |  | √
28 | [NAME] | NED | √ | √ | √
29 | [NAME] | NED | √ | √ | √ | √
30 | [NAME] | NED |  |  | √
31 | [NAME] | NED |  | √ | √ | √
32 | [NAME] | NED | √ | √ |  | √
33 | [NAME] | SCO |  |  | √
34 | [NAME] | SCO |  |  | √
REMARKS:
Reserves will be by National replacement by those not selected in the first place.
Spreadsheet: 0fd8cf86-a96a-4973-8867-1fa4f3bb5c59
Sheet: Sheet1

Table 2.2a: Annual Headline and Underlying Inflation | Unnamed: 1 | 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
Indicator | Partner State | 2000 | 2001 | 2002 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011
Annual headline inflation | Burundi,1991=100 | 27 | 2.6 | -5.1 | 27 | 2.6 | -5.1 | 10.7 | 8.3 | 13.2 | 2.7 | 8.3 | 24.5 | 10.5 | 6.5 | 9.6
 | Tanzania, Sept.2010=100 | 5.923961096374875 | 5.147468002225919 | 4.6 | 5.923961096374875 | 5.147468002225919 | 4.6 | 3.496977899929976 | 4.156004108753519 | 4.371124550256433 | 7.3 | 7 | 10.3 | 12.1 | 5.5 | 12.7
 | Uganda, 2005/06=100 | 5.1 | 1.9 | -0.3 | 5.1 | 1.9 | -0.3 | 8.7 | 3.7 | 8.6 | 7.2 | 6.1 | 12 | 13 | 4 | 18.7
 | [NAME] | 11.8 | 9.9 | 6 | 4.3 | 16.2 | 10.5 | 9.8 | 11.6 | 10.8 | 6 | 4.3 | 16.2 | 10.53765604407351 | 4.083587739155359 | 14
 | Rwanda, Feb 2009=100 | 0 | 3.4 | 2 | 0 | 0 | 8.1 | 7.5 | 11.9 | 9.1 | 8.8 | 9.1 | 15.4 | 10.3 | 2.3 | 5.6
 | Av.EAST AFRICA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | - | - | - | -
Annual underlying inflation | Burundi,1991=100 | 1.059893687492921 | 1.103309929789347 | 2.678571428571445 | 1.059893687492921 | 1.103309929789347 | 2.678571428571445 | 8.357487922705317 | 6.308515381185913 | 9.037534074229399 | 5.67307692307692 | 8.2 | 15.1 | 9.6 | 7.369914688939209 | 9.6
 | Tanzania, Sept.2010=100 | 3.8 | 1 | 3.5 | 3.8 | 1 | 3.5 | 2.002369495953737 | 1.579587577088604 | 2.866372754792157 | 7.6 | 7 | 6.7 | 3.8 | 5.902157968814414 | 7.1
 | Uganda, 2005/06=100 | - | - | - | 3.8 | 5.2 | 1.8 | - | - | - | - | 6.6 | 11.5 | 11 | 4.8 | 17.3
 | [NAME] | 6.6 | 6.8 | 2.6 | 6.6 | 6.8 | 2.6 | 3.6 | 6.8 | 7.4 | 5.5 | 5.7 | 8.7 | 5.6 | 2.990204281976983 | 10.19564046986633
 | Rwanda, Feb 2009=100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.7 | 5.7 | 4 | 9.7 | 17.6 | 8.7 | 1.5 | 5.7
 | Av. EAST AFRICA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | - | - | - | - | - | - | - | -
Source: Partner States
Tanzania has changed its CPI Classification to COICOP and reference period changed to Sept 2010=100
Spreadsheet: 165253d1341125112-combining-negative-data-automate-counting-negative-staffing-sectors-bigjess-oeldere-
Sheet: data

time | group
1:00AM | 1
1:30AM | 1
2:00AM | 1
[NAME] | 1
3:00AM | 1
3:30AM | 1
4:00AM | 1
4:30AM | 2
5:00AM | 2
5:30AM | 2
6:00AM | 2
6:30AM | 2
7:00AM | 2
7:30AM | 2
[NAME] | 2
8:30AM | 3
[NAME] | 3
9:30AM | 3
10:00AM | 3
10:30AM | 3
11:00AM | 3
11:30AM | 3
12:00AM | 3
12:00AM | 3
12:30AM | 3
1:00PM | 4
1:30PM | 4
2:00PM | 4
2:30PM | 4
3:00PM | 4
3:30PM | 4
4:00PM | 4
4:30PM | 5
5:00PM | 5
5:30PM | 5
6:00PM | 5
6:30PM | 5
7:00PM | 5
7:30PM | 5
8:00PM | 5
8:30PM | 6
9:00PM | 6
9:30PM | 6
10:00PM | 6
10:30PM | 6
11:00PM | 6
11:30PM | 6
12:00PM | 6
12:30PM | 6
Spreadsheet: 801693d1666303067-vlookup-seek-two-values-return-a-third-zone-open-order-report-with-priorities-test
Sheet: West

Priority | Month | Whse | Order# | Delivery # | Line# | Subinventory | Delivery Status | Item Number | Description | Serial Number | Qty | Available | Ship To Party | Ship Address 1 | Ship City | State | Merch
 |  | D01 | 10902046 |  | 10 | NEW | B = BACKORDERED | 3077B114 | FIERY JOBFLOW ANNUAL SUPPORT & MAINTENANCE POP AND RENEWAL |  | 1 |  | PRINT CONNECTION LLC | 18101 MOUNT WASHINGTON ST | FOUNTAIN VALLEY | CA | 54
 |  | D01 | 10965658 |  | 14 |  | B = BACKORDERED | 6315AR68 | POWER PDF 3 ADVANCED 1 USER MAINTENANCE AND SUPPORT (ONE YEAR) |  | 3 |  | TEIJIN FRONTIER (U.S.A.), INC. | 3625 DEL AMO BLVD STE 235 | TORRANCE | CA | 54
 |  | D03 | 10965658 |  | 14 |  | B = BACKORDERED | 6315AR68 | POWER PDF 3 ADVANCED 1 USER MAINTENANCE AND SUPPORT (ONE YEAR) |  | 3 |  | TEIJIN FRONTIER (U.S.A.), INC. | 3625 DEL AMO BLVD STE 235 | TORRANCE | CA | 54
 |  | D03 | 10965658 |  | 14 |  | B = BACKORDERED | 6315AR68 | POWER PDF 3 ADVANCED 1 USER MAINTENANCE AND SUPPORT (ONE YEAR) |  | 3 |  | TEIJIN FRONTIER (U.S.A.), INC. | 3625 DEL AMO BLVD STE 235 | TORRANCE | CA | 54
 |  | D01 | 10989982 |  | 15 |  | B = BACKORDERED | 6117B005 | VARIOPRINT DP-LINE TONER 2 BOTTLES/BX |  | 1 |  | VARIABLE IMAGE PRINTING | 8920 ACTIVITY RD STE G | SAN DIEGO | CA | 30
 |  | G04 | 10989982 |  | 27 |  | B = BACKORDERED | 8066B001 | TONER T01 BLACK 56,000 IMPRESSIONS @ 8.5% COVERAGE |  | 1 |  | VARIABLE IMAGE PRINTING | 8920 ACTIVITY RD STE G | SAN DIEGO | CA | 30
 |  | D01 | 10989982 |  | 28 |  | B = BACKORDERED | 8067B001 | TONER T01 CYAN 39,500 IMPRESSIONS @ 8.5% COVERAGE |  | 1 |  | VARIABLE IMAGE PRINTING | 8920 ACTIVITY RD STE G | SAN DIEGO | CA | 30
 |  | G04 | 10989982 |  | 29 |  | B = BACKORDERED | 8068B001 | TONER T01 MAGENTA 39,500 IMPRESSIONS @ 8.5% COVERAGE |  | 1 |  | VARIABLE IMAGE PRINTING | 8920 ACTIVITY RD STE G | SAN DIEGO | CA | 30
 |  | D01 | 10989982 |  | 30 |  | B = BACKORDERED | 8069B001 | TONER T01 YELLOW 39,500 IMPRESSIONS @ 8.5% COVERAGE |  | 1 |  | VARIABLE IMAGE PRINTING | 8920 ACTIVITY RD STE G | SAN DIEGO | CA | 30
 |  | D01 | 10990455 |  | 51 |  | B = BACKORDERED | 3471V313 | WES2009 CONTROLLER UPGRADE KIT - [PHONE] |  | 1 |  | LONG BEACH UNIFIED SCHOOL DIST | 2201 E MARKET ST | LONG BEACH | CA | 20
 |  | G04 | 10991449 |  | 291 |  | B = BACKORDERED | 3340B051 | CIIS PRODUCTION PROFESSIONAL SERVICES |  | 10 |  | OXNARD SCHOOL DISTRICT | 1051 S A ST | OXNARD | CA | 28
 |  | G04 | 11002910 |  | 15 |  | B = BACKORDERED | 9741B027 | ECAREPAK (ADVANCED EXCHANGE PROGRAM) FOR SCAN KIOSK II 2 YEAR |  | 1 |  | UNITED NATURAL FOODS INC | 14900 MERIDIAN PKWY | RIVERSIDE | CA | 20
 |  | G04 | 11002910 |  | 16 |  | B = BACKORDERED | 9739B035 | ECAREPAK (ON-SITE SERVICE PROGRAM) FOR DR-G1100  - 9 MONTHS + 1 PM |  | 1 |  | UNITED NATURAL FOODS INC | 14900 MERIDIAN PKWY | RIVERSIDE | CA | 20
Spreadsheet: 4fb41dc9-e6e3-4bb1-9bcf-3babd509dac9
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42316526 | 2014-07-15 22:29:16 | AXIS | 1 | 6 | 4 | 973858 | Sadoprest | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
Spreadsheet: 61804d1262726949-trying-to-avoid-long-if-statement-712844-trying-to-avoid-long-if-statement
Sheet: Sheet1

Material Estimating
Project:
 | Duct Size |  |  |  | Footage
Fire Rating | W (in.) | H (in.) | Lgth (ft) | Total (ft2) | Required |  |  | Grease 2-hr | Vent 1-hr | Vent 2-hr | Round 1-hr | Round 2-hr
Round 1-hr | 12 | 12 | 100 | 314.16 | 424.8533333333333 | <<<<<< |  | 1088.888888888889 | 486.1111111111111 | 983.3333333333334 | 424.8533333333333 | 927.4844444444443
Vent 1-hr | 10 | 10 | 50 | 166.6666666666667 | 204.1666666666667 | <<<<<< |  | 466.6666666666666 | 204.1666666666667 | 419.4444444444445 | 181.8833333333333 | 402.6555555555556
Round 2-hr | 36 | 24 | 12 | 113.0976 | 287.2277333333333 | <<<<<< |  | 298.6666666666667 | 142.3333333333333 | 274 | 138.9472 | 287.2277333333333
Grease 2-hr | 14 | 14 | 75 | 350 | 933.3333333333334 | <<<<<< |  | 933.3333333333334 | 422.9166666666667 | 845.8333333333333 | 364.455 | 787.2433333333333
Vent 2-hr | 8 | 10 | 1000 | 3000 | 7666.666666666667 | <<<<<< |  | 8555.555555555555 | 3694.444444444444 | 7666.666666666667 | 3026.8 | 6831.377777777779
Round 1-hr | 8 | 8 | 47 | 98.4368 | 142.2596 | <<<<<< |  | 365.5555555555555 | 155.3611111111111 | 326.3888888888889 | 142.2596 | 321.0747555555556
Round 1-hr | 12 | 12 | 8 | 25.1328 | 33.98826666666666 | <<<<<< |  | 87.11111111111111 | 38.88888888888889 | 78.66666666666666 | 33.98826666666666 | 74.19875555555555
Round 2-hr | 36 | 36 | 8 | 75.3984 | 191.4851555555555 | <<<<<< |  | 236.4444444444445 | 113.5555555555556 | 217.3333333333333 | 92.63146666666665 | 191.4851555555555
Grease 2-hr | 48 | 36 | 32 | 448 | 1095.111111111111 | <<<<<< |  | 1095.111111111111 | 528.8888888888889 | 1008 | 487.8122666666666 | 1000.513422222222
Vent 2-hr | 16 | 18 | 14 | 79.33333333333333 | 188.2222222222222 | <<<<<< |  | 206.8888888888889 | 95.27777777777777 | 188.2222222222222 | 76.58373333333333 | 164.0563555555556
Grease 2-hr | 24 | 27 | 60 | 510 | 1283.333333333333 | <<<<<< |  | 1283.333333333333 | 606.6666666666666 | 1175 | 474.824 | 996.3146666666667
Vent 1-hr | 48 | 42 | 1250 | 18750 | 22118.05555555555 | <<<<<< |  | 45694.44444444445 | 22118.05555555555 | 42083.33333333333 | 19055.16666666667 | 39082.55555555556
 |  |  |  | Total: | 34568.70297777778
[NAME]
Grease 2-hr:
Vent 1-hr:
Vent 2-hr:
Round 1-hr:
Round 2-hr:
 | Depending on selection in Row A, the proper footage formula (found below) must be executed in order to calculate the footage required (Row F). I understand that there are many ways of achieving the results I want however, I would prefer if this could be accomplished without the use of a macro or UDF as I do not understand how they work and I may wish to modify the sheet later on which may involve moving cells around.  Note that the use of INDIRECT and ROW functions in the formulas below may or may not be necessary.  They were put in there in my earlier attempts to create generic formulas in the hope I could find a way to pass along the row number to the formula.
Spreadsheet: 51704d1251326243-indirect-match-stats-test
Sheet: Sheet1

SEASON STATS |  | Bouts Skated | Time Skated | [NAME]
Skater | Team |  |  | [NAME] |  |  | JAMS SKATED
Skater 1 | VEN | 4 |  | 25 |  |  | Jams At Jammer
Skater 2 | BOS | 5 |  | 25 |  |  | Skater 1 | 25
Skater 3 | bos | 4 |  | 21
Skater 4 |  | 6 |  | 11 |  |  |  |  | bos
Skater 5 |  | 5 |  | 32
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: 693878d1599202260-return-header-based-on-row-criteria-and-row-header-criteria-that-contains-duplicates-sample1
Sheet: Sheet1

 | A | B | C |  |  | First formula | 2020-01-01 00:00:00
[NAME] | 2020-01-01 00:00:00 | 2020-01-08 00:00:00 | 2020-01-12 00:00:00 |  |  | [NAME]
[NAME] | 2020-01-08 00:00:00 | 2020-01-10 00:00:00 | 2020-01-05 00:00:00 |  |  | [NAME]
[NAME] | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 | 2020-01-01 00:00:00 |  |  | [NAME]
[NAME] | 2020-01-10 00:00:00 | 2020-01-08 00:00:00 | 2020-01-11 00:00:00 |  |  | [NAME]
[NAME] | 2020-01-01 00:00:00 | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 |  |  | [NAME]
[NAME] | 2020-01-05 00:00:00 | 2020-01-10 00:00:00 | 2020-01-02 00:00:00 |  |  | Second formula
[NAME] | 2020-01-04 00:00:00 | 2020-01-02 00:00:00 | 2020-01-08 00:00:00 |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Desired results
 |  |  |  |  |  | [NAME] | A | C |  |  | A |  |  | B |  | B |  | C
 |  |  |  |  |  | [NAME] |  |  |  |  | C |  |  | A |  | B
 |  |  |  |  |  | [NAME] | C | B |  | A |  |  |  | C |  | A | B
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | B |  | A | C
 |  |  |  |  |  | [NAME] | A |  |  |  |  |  |  |  |  | B | C