tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1185__United American Energy 02-09-00
Sheet: Tracking Sheet

TRACKING SHEET
 | EQUITY | EQUITY | DSCR
 | IRR WITH NO | IRR WITH | FIXED PRICE PERIOD
 | RESIDUAL VALUE | RESIDUAL VALUE | MIN | AVGE
Current |  |  | 1.288896374923169 | 1.392792135186033
Changes
Spreadsheet: kate_symes__18248__EES March Dailies
Sheet: 3-13

POSITIVE [NAME] = LONG POSITION
NEGATIVE VARIANCE = SHORT POSITION
NP15 | 2001-03-13 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak Long | 174.12 | Fixed Off Peak Long | 135.18 |  |  |  | Fixed Peak Long | 164.15 |  | Fixed Off Peak Long | 99.9 |  |  | Fixed Peak Long | 164.15 |  | Fixed Off Peak Long | 99.9
Fixed Peak Short Pos | 184.12 | Fixed Off Peak Short | 145.18 |  |  |  | Fixed Peak Short | 174.15 |  | Fixed Off Peak Short | 109.9 |  |  | Fixed Peak Short | 174.15 |  | Fixed Off Peak Short | 109.9
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | 4.9 | 0 | 0 | -4.9 |  |  | 1 | -50.9 | 0 | 0 | 62.9 |  |  | 1 | 1.97 | 0 | 0 | -1.97
2 | 4.03 | 0 | 0 | -4.03 |  |  | 2 | -50.45 | 0 | 0 | 65.45 |  |  | 2 | 1.94 | 0 | 0 | -1.94
3 | 3.67 | 0 | 0 | -3.67 |  |  | 3 | -50.16 | 0 | 0 | 66.16 |  |  | 3 | 1.93 | 0 | 0 | -1.93
4 | 3.61 | 0 | 0 | -3.61 |  |  | 4 | -50.08 | 0 | 0 | 66.08 |  |  | 4 | 1.92 | 0 | 0 | -1.92
5 | 3.87 | 0 | 0 | -3.87 |  |  | 5 | -50.5 | 0 | 0 | 64.5 |  |  | 5 | 1.93 | 0 | 0 | -1.93
6 | 5.86 | 0 | 0 | -5.86 |  |  | 6 | -52.33 | 0 | 0 | 73.33 |  |  | 6 | 2.02 | 0 | 0 | -2.02
7 | 9.31 | 0 | 0 | -9.31 |  |  | 7 | -9.819999999999993 | 0 | 0 | 91.82 |  |  | 7 | 2.16 | 0 | 0 | -2.16
8 | 11.27 | 0 | 0 | -11.27 |  |  | 8 | -12.1 | 0 | 0 | 85.1 |  |  | 8 | 2.24 | 0 | 0 | -2.24
9 | 11.88 | 0 | 0 | -11.88 |  |  | 9 | -12.73 | 0 | 0 | 79.73 |  |  | 9 | 2.27 | 0 | 0 | -2.27
10 | 12.58 | 0 | 0 | -12.58 |  |  | 10 | -13.22 | 0 | 0 | 75.22 |  |  | 10 | 2.3 | 0 | 0 | -2.3
11 | 12.71 | 0 | 0 | -12.71 |  |  | 11 | -13.52999999999994 | 0 | 0 | 72.53 |  |  | 11 | 2.31 | 0 | 0 | -2.31
12 | 12.35 | 0 | 0 | -12.35 |  |  | 12 | -12.73 | 0 | 0 | 71.73 |  |  | 12 | 2.29 | 0 | 0 | -2.29
13 | 13.07 | 0 | 0 | -13.07 |  |  | 13 | -13.74 | 0 | 0 | 70.74 |  |  | 13 | 2.32 | 0 | 0 | -2.32
14 | 13.09 | 0 | 0 | -13.09 |  |  | 14 | -13.55 | 0 | 0 | 70.55 |  |  | 14 | 2.32 | 0 | 0 | -2.32
15 | 12.8 | 0 | 0 | -12.8 |  |  | 15 | -13.46 | 0 | 0 | 71.46 |  |  | 15 | 2.31 | 0 | 0 | -2.31
16 | 12.93 | 0 | 0 | -12.93 |  |  | 16 | -13.47 | 0 | 0 | 73.47 |  |  | 16 | 2.31 | 0 | 0 | -2.31
17 | 13.05 | 0 | 0 | -13.05 |  |  | 17 | -13.4500000000001 | 0 | 0 | 77.45 |  |  | 17 | 2.31 | 0 | 0 | -2.31
18 | 13.47 | 0 | 0 | -13.47 |  |  | 18 | -14.26 | 0 | 0 | 75.26 |  |  | 18 | 2.33 | 0 | 0 | -2.33
19 | 15.15 | 0 | 0 | -15.15 |  |  | 19 | -15.58 | 0 | 0 | 72.58 |  |  | 19 | 2.4 | 0 | 0 | -2.4
20 | 14.61 | 0 | 0 | -14.61 |  |  | 20 | -15.63 | 0 | 0 | 73.63 |  |  | 20 | 2.39 | 0 | 0 | -2.39
21 | 13.47 | 0 | 0 | -13.47 |  |  | 21 | -14.81 | 0 | 0 | 76.81 |  |  | 21 | 2.34 | 0 | 0 | -2.34
22 | 11.75 | 0 | 0 | -11.75 |  |  | 22 | -12.95 | 0 | 0 | 82.95 |  |  | 22 | 2.26 | 0 | 0 | -2.26
23 | 9.19 | 0 | 0 | -9.19 |  |  | 23 | -56.1 | 0 | 0 | 64.1 |  |  | 23 | 2.16 | 0 | 0 | -2.16
24 | 6.52 | 0 | 0 | -6.52 |  |  | 24 | -53.28 | 0 | 0 | 72.28 |  |  | 24 | 2.04 | 0 | 0 | -2.04
Spreadsheet: 741560d1627139193-auto-populate-table-with-start-and-end-year-expanding-fill-and-border-formatting-zainmerchant-
Sheet: Dates

 | Asset Management
 | Engine Teardown Start Date | 2021-07-01 00:00:00 |  | Start Date
 | Engine Teardown End Date | 2028-06-30 00:00:00 |  | End Date
 | Engine Parts Sale Start Date | 2022-09-01 00:00:00
 | Engine Parts Sale End Date | 2027-08-30 00:00:00 |  | No. of years
 | Engine Straight Sale Date | 2028-12-31 00:00:00 |  | Start Year
 |  |  |  | End Year
 | Lease
 | Engine Acquisition | 2021-11-01 00:00:00
 | Engine Repair Start Date | 2025-08-03 00:00:00
 | Engine Repair End Date | 2025-11-03 00:00:00
 | Lease Start Date | 2021-03-01 00:00:00
 | Lease End Date | 2027-02-28 00:00:00
 | Year
Spreadsheet: 803948d1667819341-formula-for-9-box-grid-9-box-grid
Sheet: Sheet1

EMPLOYEE ID | NAME | DEPARTMENT | POSITION | YEARS OF EXPERIENCE | JOB LEVEL | AGE | PERFORMANCE | POTENTIAL | 9 BOX CATEGORIZATION |  | Potential
1 |  |  |  |  |  |  | 3 | 1 | [NAME] |  |  | 3 | Potential Gem | High potential | Star
2 |  |  |  |  |  |  | 3 | 3 | Star |  |  | 2 | Inconsistent player | Core Player | High performance
3 |  |  |  |  |  |  | 1 | 3 | Potential Gem |  |  | 1 | Risk | Average performer | [NAME]
4 |  |  |  |  |  |  | 1 | 2 | Inconsistent player |  |  |  | 1 | 2 | 3
5 |  |  |  |  |  |  | 3 | 2 | High performance |  | Perfromacne
6 |  |  |  |  |  |  | 2 | 2 | Core Player
7 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
8 |  |  |  |  |  |  | 2 | 3 | High potential
9 |  |  |  |  |  |  | 3 | 1 | [NAME]
10 |  |  |  |  |  |  | 2 | 1 | Average performer
11 |  |  |  |  |  |  | 2 | 2 | Core Player
12 |  |  |  |  |  |  | 2 | 3 | High potential
13 |  |  |  |  |  |  | 3 | 1 | [NAME]
14 |  |  |  |  |  |  | 2 | 1 | Average performer
15 |  |  |  |  |  |  | 1 | 3 | Potential Gem
16 |  |  |  |  |  |  | 1 | 2 | Inconsistent player
17 |  |  |  |  |  |  | 2 | 3 | High potential
18 |  |  |  |  |  |  | 1 | 1 | Risk
19 |  |  |  |  |  |  | 2 | 1 | Average performer
20 |  |  |  |  |  |  | 1 | 3 | Potential Gem
Spreadsheet: 29660d1224749863-creation-formula-with-multiple-criterias-book1-oct23
Sheet: Sheet2

Name | Plant | Room | Stock |  | Name | Plant | Room |  | Total Stock
A | 2110 | 1010 | 1000 |  | A | 2110 | 1010 |  | 3000
A | 2110 |  | 2000 |  |  | 3010 | 2020
A | 3010 | 3010 | 3000 |  |  |  | 2130
A | 2130 | 2010 | 4000
B | 2120 | 1020 | 5000
B | 2120 | 2020 | 6000
B | 2130 |  | 7000
B | 2130 | 1010 | 8000
B | 2130 | 2010 | 9000
Spreadsheet: 221460d1363561681-joining-two-tables-using-a-common-column-joining-two-tables-updated
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | [NAME] | Column 18 | Column 19 | Column 20 | Column 21 | Column 22 | Column 23 | Column 24 | Column 25 | Column 26 | Column 27 | Column 28 | Column 29 | Column 30 | Column 31 | Column 32 | Column 33 | Column 34 | Column 35
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | [EMAIL]
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | [EMAIL]
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | [EMAIL]
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | [EMAIL]
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | [EMAIL]
6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | [EMAIL]
7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | [EMAIL]
8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | [EMAIL]
9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | [EMAIL]
10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | [EMAIL]
11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | [EMAIL]
12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | [EMAIL]
13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | [EMAIL]
14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | [EMAIL]
15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | [EMAIL]
16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | [EMAIL]
17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | [EMAIL]
18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | [EMAIL]
19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | 19 | [EMAIL]
20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | [EMAIL]
21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | [EMAIL]
22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | 22 | [EMAIL]
23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 23 | [EMAIL]
24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | [EMAIL]
25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | [EMAIL]
26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | [EMAIL]
27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | [EMAIL]
Spreadsheet: 076e65be-26e0-4df5-8522-865ab7fcfd7c
Sheet: Sheet1

Degree Level, Top 10 Places of Origin for | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
the United States, 2009-2010
Places of Origin | Top 10 Places of Origin | Total Number of International Students | Undergraduate  International Students | Graduate  International Students | Non-degree-seeking International Students | Optional Practical Training
#1 | China | 127628 | 39921 | 66453 | 10251 | 11003
#2 | India | 104897 | 15192 | 68290 | 1758 | 19657
#3 | South Korea | 72153 | 36234 | 23386 | 6671 | 5862
#4 | Canada | 28145 | 13607 | 11950 | 619 | 1969
#5 | Taiwan | 26685 | 6609 | 14613 | 1894 | 3569
#6 | Japan | 24842 | 13063 | 5390 | 4321 | 2068
#7 | Saudi Arabia | 15810 | 8767 | 3474 | 3247 | 322
#8 | Mexico | 13450 | 7715 | 3911 | 1044 | 780
#9 | Vietnam | 13112 | 8864 | 2454 | 1278 | 516
#10 | Turkey | 12397 | 3656 | 6585 | 989 | 1167
Total of All Places of Origin | Total | 690923 | 274431 | 293885 | 54803 | 67804
Source:  Institute of International Education. (2010). Open Doors Report on International Educational Exchange.
Spreadsheet: 069f0cc8-50ab-4f19-a5b1-89001bb3df0b
Sheet: Sheet1

Spend over £25,000 - Publication template | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Payment
Department family | Entity | Date | Expense type | Expense area | Supplier | Transaction number | Amount
DCMS | NMSI | 2012-03-31 00:00:00 | Electricity | NMEM Estates | Southern Electric Power Distribution Ltd | 152254 | 30351.95
DCMS | NMSI | 2012-03-05 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 152853 | 28944.71
DCMS | NMSI | 2012-03-05 00:00:00 | Security | Security | [NAME] | 152860 | 34147
DCMS | NMSI | 2012-03-05 00:00:00 | Security | Security | [NAME] | 152862 | 31676.25
DCMS | NMSI | 2012-03-05 00:00:00 | Electricity | Science Museum Estates | Natural History Museum | 153054 | 46093.8
DCMS | NMSI | 2012-03-05 00:00:00 | Security | Security | [NAME] | 153059 | 155065.75
DCMS | NMSI | 2012-03-05 00:00:00 | Build Construction | National MPG | Hemcrete Projects Limited | 153075 | 38993.83
DCMS | NMSI | 2012-03-05 00:00:00 | Build Construction | Wroughton Major projects | Hemcrete Projects Limited | 153076 | 101313.23
DCMS | NMSI | 2012-03-29 00:00:00 | Professional Fees | National MPG | Atlas Industrial Removals Ltd | 153268 | 47310
DCMS | NMSI | 2012-03-29 00:00:00 | Maintenance | Science Museum Estates | Cofely Limited | 153269 | 28744.89
DCMS | NMSI | 2012-03-05 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 153310 | 27395.55
DCMS | NMSI | 2012-03-05 00:00:00 | Gas | Science Museum Estates | Gazprom Marketing & Trading Limited | 153351 | 26108.93
DCMS | NMSI | 2012-03-15 00:00:00 | Contract Cleaning | ScM Visitor Experience | Servest (Sherwood) Ltd | 110561 | 84120
DCMS | NMSI | 2012-03-15 00:00:00 | Contract Cleaning | ScM Visitor Experience | Servest (Sherwood) Ltd | 110562 | 84120
DCMS | NMSI | 2012-03-15 00:00:00 | Contract Cleaning | ScM Visitor Experience | Servest (Sherwood) Ltd | 110563 | 84120
Spreadsheet: 784613d1655859210-in-lieu-of-filtering-pivot-tables-what-formula-can-replicate-filtering-car2
Sheet: Sheet1 (3)

Name | Ford | Chevy | Honda | Nissan | Kia |  | Ford
[NAME] | Y
Fred | Y | Y | Y | Y | Y
[NAME] |  |  | Y |  | Y
[NAME] | Y
Kelly |  |  | Y
Candace | Y
Individuals Who Only Have A Ford
1
2
3
4
5
6
Spreadsheet: 71024d1271775753-sum-by-quarter-based-on-date-test
Sheet: data

Curent Week
2010-01-01 00:00:00 | 2010-01-08 00:00:00 | 2010-01-15 00:00:00 | 2010-01-22 00:00:00 | 2010-01-29 00:00:00 | 2010-02-05 00:00:00 | 2010-02-12 00:00:00 | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00
 |  | 122000 | 25000 | 30000 | 0 | 0 |  | 30000 | 107000 | 12600 | 19572 | 46048 | 0 | 20127
YTD
2010-01-01 00:00:00 | 2010-01-08 00:00:00 | 2010-01-15 00:00:00 | 2010-01-22 00:00:00 | 2010-01-29 00:00:00 | 2010-02-05 00:00:00 | 2010-02-12 00:00:00 | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00 | 2010-04-16 00:00:00
0 | 0 | 122000 | 147000 | 177000 | 177000 | 177000 | 177000 | 207000 | 314000 | 326600 | 346172 | 392220 | 392220 | 412347 | 412347
Budget
2010-01-01 00:00:00 | 2010-01-08 00:00:00 | 2010-01-15 00:00:00 | 2010-01-22 00:00:00 | 2010-01-29 00:00:00 | 2010-02-05 00:00:00 | 2010-02-12 00:00:00 | 2010-02-19 00:00:00 | 2010-02-26 00:00:00 | 2010-03-05 00:00:00 | 2010-03-12 00:00:00 | 2010-03-19 00:00:00 | 2010-03-26 00:00:00 | 2010-04-02 00:00:00 | 2010-04-09 00:00:00 | 2010-04-16 00:00:00
0 | 637000 | 1274000 | 1911000 | 2548000 | 3185000 | 3822000 | 4459000 | 5096000 | 5605600 | 6115200 | 6624800 | 7134400 | 7644000 | 8153600 | 8663200
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Criminal Justice 1

CRIMINAL JUSTICE
Associate in Applied Science
Student Name:  _________________________________________
Student ID:  ___________________________
General Education | Semester | Grade
___ ENG 101 (3) Writing I
___ ENG 102 (3) Writing II
___ COM 191 (3) Basic Public Speaking
OR ___ COM 252 (3) Introduction to Interpersonal Communication
___ POL 101 (3) American Government
OR POL 235 (3) State Government
___ PSY 110 (3) General Psychology
___ SOC 101 (3) Introduction to Sociology
___ [NAME] (3)
___ Heritage/Humanities (3)
___ Natural Science (3-4)
___ CIT 105 (3) Introduction to Computers OR IC3 Computer Literacy Exam
___ Elective (3)
___ Elective (3)
Technical Core
___ CRJ 100 (3) Introduction to Criminla Justice
___ CRJ 216 (3) Criminal Law
___ CRJ 217 (3) Criminal Procedures
___ CRJ 204 (3) Criminal Investigations
___ CRJ 202 (3) Issues and Ethics in Criminal Justice
Corrections Track
Required
___ CRJ 102 (3) Introduction to Corrections
Electives - Choose 6 hours from the following:
___ CRJ 203 (3) Community Corrections/Probation & Patrol
___ CRJ 208 (3) Delinquency and the Juvenile Justice System
___ CRJ 220 (3) Introduction to Computer Forensics
___ CRJ 222 (3) Prison and Jail Administration
___ CRJ 231 (3) Legal Aspects of Corrections
___ CRJ 277 (3) Introduction to Criminology
___ CRJ 290 (3) Internship in Criminal Justice
___ CRJ 299 (1-3) Selected Topics in Criminal Justice
Technical Elective
___  Approved by Program Coordinator (0-3)
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 685717d1594152040-last-6-months-rolling-sum-rolling-sum
Sheet: Sheet1

Name | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | Uses Last 6 Months | Uses Last 3 Months | YTD AVG Usese |  |  | Expected Values in N
[NAME] | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 2
Sue | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 5
[NAME] | 2 | 1 | 0 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 10
[NAME] | 3 | 0 | 35 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 39
Sara | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
[NAME] | 0 | 4 | 0 | 45 | 31 | 10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 months from last full month (June)
Would like a formula that is rolling off Today (). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Using EDATE
Start date is 6 months back to the most current full month.  For now that would be Jan to Jun. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End date
Sum if between the Start date (1/1/2020) and the end date (6/30/2020) (or would that be 7/1?) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start date
Been tinkering with:
=SUMIFS(B2:M2,B1:M1,"<="&R11,B1:M1,">="&R12)
Which just gets me zero
Tried every combination I could find.  No luck.  Looking for a roling 6 months (and 3)
Spreadsheet: 811f5e77-f26d-49ae-98d1-e0f48297f17f
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Maxey | Maranda | [EMAIL] | [PHONE] | [PHONE] | Anne Belk Hall |  | Boone | NC | 28608
East Carolina University | Johnston | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | [NAME] | Felecia | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
NC Agricultural and Technical State University | Oliphant | Peggy | [EMAIL] | [PHONE]-2901 | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | [NAME] | Kesha | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Newmiller | Mark | [EMAIL] | [PHONE] |  | Student Health Services Center 1900 | Box 7509 | Raleigh | NC | 27695-7509
UNC Asheville | Kaufman | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 2126 Student Academic Services Building  North | [NAME] | Chapel Hill | NC | 27514-1015
UNC Greensboro | Pomeroy | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Walker | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Turner | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1533 S. Main Street |  | Winston-Salem | NC | 27127
Winston-Salem State University | Waddell | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
Spreadsheet: 876612d1723333045-index-and-2-matches-formula-not-working-windme-indexmatch-sample-tms
Sheet: Sheet2

 |  |  | 1 | 6 | 5 | 2 | 8 | 9 | 4 | 7 | 0 | 3 |  |  | Q4 to R7 are user imputs
 |  | 6 | L | P | L | M | M | B | M | L | B | P |  |  |  |  |  |  | [NAME]
 |  | 3 | B | M | L | P | L | P | M | M | L | B |  |  | 1st | 6 | 0 |  | =INDEX($D$3:$M$12, MATCH(Q4, $C$3:$C$12, 0), [NAME], $[NAME], 0)) | L
 |  | 7 | B | P | M | L | M | B | B | L | M | L |  |  | 2nd | 7 | 3 |  | =INDEX($D$3:$M$12, MATCH(Q5, $C$3:$C$12, 0), MATCH(R5, $[NAME], 0)) | M
 |  | 1 | M | L | L | P | B | P | M | L | B | B |  |  | 3rd | 0 | 0 |  | =INDEX($D$3:$M$12, MATCH(Q6, $C$3:$C$12, 0), MATCH(R6, $[NAME], 0)) | L
 |  | 8 | M | L | P | P | B | L | M | L | B | M |  |  | 4th | 3 | 3 |  | =INDEX($D$3:$M$12, MATCH(Q7, $C$3:$C$12, 0), [NAME], $[NAME], 0)) | B
 |  | 0 | P | L | P | M | B | P | B | B | L | P
 |  | 2 | P | L | M | P | M | B | M | P | B | P |  |  |  |  |  |  | Looking for it to return in U4:u:7
 |  | 4 | L | M | L | B | L | L | P | L | B | M |  |  | 1st example [NAME], R4=0 is highlighted in E8
 |  | 5 | M | P | B | L | L | M | P | B | P | B
 |  | 9 | P | B | P | M | P | P | M | B | B | M |  |  | R = Row, Q = Column
Spreadsheet: 5fa0c338-b60e-495a-8648-ccd9dcbb0cfa
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5561 | 16439 | [NAME] | Streumer | NED | 448 | 00:36:57 | 00:00:47 | 01:04:27 | 00:01:03 | 00:22:13 | 1 | 02:05:26
5561 | 11113 | [NAME] | Alemanni | ITA | 446 | 00:38:22 | 00:00:56 | 01:07:03 | 00:01:02 | 00:20:52 | 2 | 02:08:12
5561 | 34055 | Trevor | [NAME] | GBR | 444 | 00:42:05 | [NAME] | 01:07:30 | 00:01:30 | 00:22:40 | 3 | [NAME]
5561 | 11665 | [NAME] | Luck | GBR | 445 | 00:48:37 | 00:01:04 | 01:13:27 | 00:00:54 | 00:25:15 | 4 | 02:29:16
5561 | 16320 | Iwao | [NAME] | JPN | 447 | 01:06:20 | 00:01:35 | 00:00:00 | 01:38:18 | 00:40:31 | 5 | 03:25:32
Spreadsheet: 146171d1331933077-using-dropdown-lists-to-populate-range-of-cells-workouttable
Sheet: Master

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swim/Dive - Spring 2012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CORE | CL | SQ | BP | DL | OH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Train Max | 100 | 100 | 100 | 100 | 100
 | Monday | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  |  |  |  |  |  |  |  |  | Monday | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4
 |  | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA |  |  |  |  |  |  |  |  |  | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA | % | GR | WT | RA
UP | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | [NAME] | 0 | x10 |  |  | 0 | x10 |  |  | 0 | [NAME] |  |  | 0.7 | [NAME]
EX |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SL | Week 1: 5-1-X | 0.5 | 8 |  |  | 0.5 | 8 |  |  | 0.5 | 8 |  |  | 0.8 | x2
% | Programs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % | Week 2: 3-1-X | 0.75 | x5 |  |  | 0.8 | x5 |  |  | 0.85 | x5 |  |  | 0.92 | x1
1 | 531 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0.75 | x5 |  |  | 0.8 | x5 |  |  | 0.85 | x5 |  |  | 0.92 | x1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.75 | x5 |  |  | 0.8 | x5 |  |  | 0.85 | x5 |  |  | 0.92 | x1
UB | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
HIP | BB Overhead |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
V |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | SH - UB - PZ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SH - UB - PZ
UP | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
UP | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press
UP | Push Press |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UP | Push Press