tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120817d1315545694-timesheet-sampletimesheet
Sheet: Sheet1

Name: | employee Name |  | Week Ending: |  | 2011-09-04 00:00:00 |  |  |  |  |  | Employee: |  | 1789 |  | Working Area – Do Not Print
 | 1st Job |  |  | 2nd Job |  |  | 3rd Job
Date | Job Description (and Workorder #) |  | Hours | Job Description (and Workorder #) |  | Hours | Job Description (and Workorder #) |  | Hours | Daily Total | Blank |  | Expenses | Amount |  | 1st job | 2nd job | 3rd job |  | Total
Mon | 20:30:00 | 05:45:00 | 9.250000000000002 |  |  | 0 |  |  | 0 | 9.250000000000002 |  |  |  | 0 | DoubleTime | 0
 | 11-07-78 |  |  |  |  |  |  |  |  | 0 |  |  |  |  | OT | 47.90625000000007
29 | Customer1 |  | cedo |  |  |  |  |  |  | 0 |  |  |  |  | regular | 204.4 |  |  |  | 252.3062500000001
 | 100 Yonge St |  |  |  |  |  |  |  |  | 0
Tue | 21:45:00 | 05:15:00 | 7.5 |  |  | 0 |  |  | 0 | 7.5 |  |  |  | 0 | DoubleTime | 0
 | 11-07-78 |  |  |  |  |  |  |  |  |  |  |  |  |  | OT | 0
30 | Customer1 |  | Level 1 |  |  |  |  |  |  |  |  |  |  |  | regular | 226.65 |  |  |  | 226.65
 | 100 Yonge St
Wed | 21:00:00 | 23:30:00 | 2.499999999999999 | 23:30:00 | 06:30:00 | 7 |  |  | 0 | 9.5 |  |  |  | 0 | DoubleTime | 0
 | 11-07-13 |  |  | 11-08-78 |  |  |  |  |  | 0 |  |  |  |  | OT | 57.4875
31 | Customer2 |  | Level 1 | Customer1 |  | CEDO |  |  |  | 0 |  |  |  |  | regular | 75.54999999999997 |  |  |  | 133.0375
 | 101 Yonge St |  |  | 100 Yonge St |  |  |  |  |  | 0
Thur | 21:00:00 | 1900-01-01 00:00:00 | 3 | 1900-01-01 00:00:00 | 04:15:00 | 4.25 | 04:15:00 | 07:00:00 | 2.75 | 10 |  |  |  | 0 | DoubleTime | 0
 | 11-01-01 |  |  | 11-02-04 |  |  | 11-01-09 |  |  | 0 |  |  |  |  | OT | 76.65
1 | Customer3 |  | Level 1 | Customer4 |  | Level 1 | Customer6 |  | CEDO | 0 |  |  |  |  |  |  |  |  |  | 76.65
 | 102 Yonge St |  |  | 104 Yonge St |  |  | 106 Yonge St |  |  | 0
Fri | 21:00:00 | 02:30:00 | 5.5 | 02:30:00 | 09:00:00 | 6.5 |  |  | 0 | 12 |  |  |  |  | DoubleTime | 102.2
 | 01-02-98 |  |  | 11-06-13 |  |  |  |  |  | 0 |  |  |  |  | OT | 76.65
2 | Customer4 |  | Level 1 | Customer5 |  | CEDO |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 178.85
 | 103 Yonge St |  |  | 105 Yonge St |  |  |  |  |  | 0
Sat |  |  | 0 |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0
3 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
Sun |  |  | 0 |  |  | 0 |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0
4 |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  | Weekly Totals |  |  |  |  | 48.25 |  |  |  | 0
 | Rates (MAY 1 2011)
 | CEDO | 25.55
 | HELPER | 17.77
 | LEVEL 1 | 30.22
 | SP Start Time1:00 pm
 | Shift Premium | 0.15
 | Regular Hours | 8
 | OT Hours | 2
 | OT Rate | 1.5
 | [NAME] | 2
Spreadsheet: 05fbc6fe-6b5c-480d-830f-182beca6fa65
Sheet: Sheet1

Newspaper Audience 2011 by Gender & Age Group
Source: Scarborough USA+ 2011 Release 2 Total (Aug 2010 - Sep 2011)
 |  | Base Total Adults | Men | Women | Adults 18 - 34 | Adults 35 or older | Adults 55 or older
Base Total Adults | Target Pop | 236196496 | 114606675 | 121589821 | 69936023 | 166260473 | 79106367
 | Target % | 1 | 1 | 1 | 1 | 1 | 1
Newspaper Print/E-Edition/Website - Avg. Issue/Yesterday | Target Pop | 103036605 | 52375831 | 50660774 | 20870014 | 82166591 | 45185813
 | Target % | 0.436 | 0.457 | 0.417 | 0.298 | 0.494 | 0.5710000000000001
Sunday-Print or E-edition | Target Pop | 104546760 | 49224843 | 55321917 | 21223365 | 83323395 | 46223395
 | Target % | 0.4429999999999999 | 0.43 | 0.455 | 0.303 | 0.501 | 0.584
5 Weekday Cume - Print or E-edition | Target Pop | 131956754 | 65894725 | 66062029 | 31554411 | 100402343 | 53755529
 | Target % | 0.5589999999999999 | 0.575 | 0.5429999999999999 | 0.451 | 0.604 | 0.68
Past Week Print | Target Pop | 149101657 | 72727674 | 76373983 | 36328776 | 112772881 | 59032821
 | Target % | 0.631 | 0.635 | 0.628 | 0.519 | 0.6779999999999999 | 0.746
Past Week Print or E-edition | Target Pop | 150225643 | 73390558 | 76835085 | 36777493 | 113448150 | 59240125
 | Target % | 0.636 | 0.64 | 0.632 | 0.526 | 0.682 | 0.7490000000000001
Past 7 Days: Print/E-edition/Website | Target Pop | 161770555 | 79187929 | 82582626 | 40968267 | 120802288 | 61136700
 | Target % | 0.685 | 0.691 | 0.679 | 0.586 | 0.727 | 0.773
[NAME] or Newspaper Mobile source Used in Past 30 Days combined with Newspaper Past Week Print/E-Edition | Target Pop | 169159391 | 82739379 | 86420012 | 44784098 | 124375293 | 61906551
 | Target % | 0.716 | 0.722 | 0.711 | 0.64 | 0.748 | 0.7829999999999999
Prepared by: Newspaper Association of America
Spreadsheet: 0a42922c-92a5-42f3-9adc-16e961a698fd
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
State Representatives - BELKNAP County - Republican
District No. 1 (1) | Quinney, r | Gulick ,d | [NAME]
Center Harbor | 144 |  | 2
New Hampton | 205 | 1 | 3
Totals | 349 | 1 | 5
District No. 2 (4) | Worsman, r | Greemore, Jr., r | Leandro, r | Vadney, r | Miller, d | Mucci, d | [NAME], d | [NAME], d | [NAME]
Gilford | 661 | 630 | 728 | 599 | 4 | 4 | 18 | 5 | 26
Meredith | 572 | 540 | 456 | 561 | 2 | 1 |  | 19
Totals | 1233 | 1170 | 1184 | 1160 | 6 | 5 | 18 | 24 | 26
District No. 3 (4) | [NAME], r | Deshaies, r | Flanders, r | Kingsbury, r | Luther, r
Laconia Wd 1 | 205 | 131 | 195 | 161 | 169
Laconia Wd 2 | 154 | 83 | 143 | 114 | 119
Laconia Wd 3 | 222 | 126 | 221 | 152 | 168
Laconia Wd 4 | 153 | 104 | 143 | 117 | 116
Laconia Wd 5 | 105 | 72 | 101 | 91 | 79
Laconia Wd 6 | 248 | 159 | 242 | 195 | 187
Totals | 1087 | 675 | 1045 | 830 | 838
District No. 3 (4) | Fisher, d | Huot, d | Smith, d | Vaillancourt, d | [NAME]
Laconia Wd 1 |  |  |  | 1 | 4
Laconia Wd 2 |  |  |  |  | 2
Laconia Wd 3 |  |  |  | 1 | 11
Laconia Wd 4 | 1 | 2 | 1 | 1 | 1
Laconia Wd 5 |  | 1 |  |  | 1
Laconia Wd 6 |  | 2 |  | 1 | 4
Totals | 1 | 5 | 1 | 4 | 23
District No. 4 (2) | Fields, r | Lang, Sr., r | Alden, d | [NAME], d | [NAME], d | [NAME]
Sanbornton | 246 | 155 |  | 10 |  | 11
[NAME] | 214 | 153 | 3 | 1 |  | 3
Totals | 460 | 308 | 3 | 11 |  | 14
District No. 5 (2) | Burchell, r | [NAME], r | Chase, d | Henry, d | [NAME]
Alton | 372 | 566 |  | 1 | 3
Gilmanton | 280 | 187 | 1 |  | 2
Totals | 652 | 753 | 1 | 1 | 5
District No. 6 (2) | Condo-demetraky, d | Cormier, d | [NAME] | Fink | [NAME] | Ellis-Hopkins
Belmont |  |  |  | 275 | 216 | 140
District No. 7 (1) | [NAME], r | Swinford, r | Marriott, d | [NAME]
Barnstead | 303 | 206
District No. 8 (1) F | Bolster, r | Cormier, r | Smith, d | [NAME]
Alton | 244 | 638
Barnstead | 176 | 292
Gilmanton | 154 | 264
Totals | 574 | 1194
District No. 9 (1) F | Accornero, r | Dewhirst, r | Arsenault, d | [NAME] | Ellis-Hopkins
Belmont | 279 | 205 |  |  | 18
Laconia Wd 1 | 120 | 141
Laconia Wd 2 | 111 | 92
Laconia Wd 3 | 154 | 112 | 1
Laconia Wd 4 | 110 | 94 | 4
Laconia Wd 5 | 133 | 53
Laconia Wd 6 | 152 | 163 | 1 | 2
Totals | 1059 | 860 | 6 | 2 | 18
Spreadsheet: 697739d1601497365-need-help-with-streaks-hits-misses-streaks
Sheet: Simulated Shooter

 |  | streak
H |  | 2
H |  | 1
M |  | 0
H |  | 0
M |  | 0
H |  | 1
M |  | 0
M |  | 0
M |  | 1
H |  | 0
M |  | 1
M |  | 1
M |  | 1
H |  | 0
M |  | 2
M |  | 1
M |  | 1
H |  | 0
M |  | 2
H |  | 0
M |  | 1
M |  | 0
H |  | 0
H |  | 2
M |  | 0
H |  | 0
M |  | 0
M |  | 0
M |  | 2
H |  | 2
H |  | 1
M |  | 3
M |  | 3
M |  | 1
M |  | 0
M |  | 2
M |  | 2
M |  | 4
M |  | 0
M |  | 0
M |  | 0
H |  | 0
H |  | 1
M |  | 1
H |  | 0
H |  | 0
M |  | 1
H |  | 0
M |  | 0
H |  | 0
H |  | 1
H |  | 0
M |  | 1
H |  | 1
H |  | 0
H |  | 2
M |  | 0
H |  | 0
M |  | 5
M |  | 1
H |  | 0
H |  | 0
M |  | 0
H |  | 0
H |  | 1
M |  | 0
H |  | 1
H |  | 0
H |  | 0
H |  | 0
M |  | 0
M |  | 0
M |  | 0
M |  | 3
M |  | 1
H |  | 0
M |  | 0
H |  | 0
M |  | 2
M
M
H
M
M
M
M
H
M
M
H
M
H
M
M
H
H
M
M
M
H
H
H
H
H
M
H
M
M
M
M
M
H
M
M
H
M
M
M
M
M
M
M
H
H
H
M
H
M
M
M
M
H
H
Spreadsheet: 09549165-2d91-4360-bcbe-0e5ebf506f71
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-07 10:02:21.990000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 101.744 | 101.619 | 101.494 | 101.119 |  | and are added to price quote
4.625 | 100.74 | 100.615 | 100.49 | 100.115
4.5 | 100.269 | 100.144 | 100.019 | 99.644 |  | Note: | Refer To Price [NAME]
4.375 | 99.659 | 99.534 | 99.409 | 99.034 |  |  | For all Price Adjs
4.25 | 98.566 | 98.441 | 98.316
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.642 | 101.517 | 101.392 | 101.017
4 | 101.321 | 101.196 | 101.071 | 100.696
3.875 | 100.928 | 100.803 | 100.678 | 100.303
3.75 | 100.358 | 100.233 | 100.108 | 99.733
3.625 | 99.167 | 99.042 | 98.917
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-21 10:02:21.990000
30 DAY | 2011-07-06 10:02:21.990000
45 DAY | 2011-07-21 10:02:21.990000
60 DAY | 2011-08-05 10:02:21.990000
90 DAY | 2011-09-04 10:02:21.990000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 122745d1317128597-date-count-by-month-with-multiple-criteria-multiple-date-ranges
Sheet: Sheet4

Row Labels | Count of Status
2011-01-01 00:00:00 | 9
50 | 2
60 | 3
300 | 4
2011-04-01 00:00:00 | 3
50 | 1
300 | 2
2011-06-01 00:00:00 | 3
50 | 1
60 | 1
300 | 1
Grand Total | 15
Spreadsheet: 377b577f-4167-4b90-970b-22087fc956bb
Sheet: Sheet1

2008-01-08 00:00:00 | VICE-PRESIDENT OF THE UNITED STATES- DEMOCRATIC | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 |  | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Belknap County | Bryk, d | Stebbins, d
Alton | 79 | 165
Barnstead | 91 | 164
Belmont | 134 | 277
Center Harbor | 13 | 34
Gilford | 122 | 278
Gilmanton | 63 | 130
[NAME] | 32 | 87
[NAME] | 56 | 100
[NAME] 3 | 1 | 0
[NAME] | 60 | 103
[NAME] | 63 | 133
[NAME] 6 | 48 | 108
Meredith | 123 | 235
New Hampton | 49 | 60
Sanbornton | 54 | 123
[NAME] | 74 | 134
TOTALS | 1062 | 2131
Carroll County | Bryk, d | Stebbins, d
Albany | 6 | 24
[NAME] | 40 | 95
[NAME] | 10 | 13
Chatham | 7 | 3
Conway | 196 | 404
Eaton | 12 | 12
[NAME] | 23 | 50
Freedom | 19 | 39
Hale's Location | 1 | 1
Hart's Location | 2 | 1
[NAME] | 15 | 31
[NAME] | 57 | 100
Moultonborough | 68 | 169
Ossipee | 63 | 141
Sandwich | 20 | 42
Tamworth | 38 | 105
Tuftonboro | 24 | 54
Wakefield | 80 | 186
Wolfeboro | 92 | 194
TOTALS | 773 | 1664
Spreadsheet: 52802d1252609465-move-cell-value-tomkid-monthly-invoice
Sheet: Annual Accounts

Customer Name | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00
Customer 1 | 54.54999999999999 | 0 | 0 | 0 | 0
Customer 2 | 129.5374999999999 | 0 | 0 | 0 | 0
Customer 3 | 204.5249999999999 | 0 | 0 | 0 | 0
Customer 4 | 279.5124999999999 | 0 | 0 | 0 | 0
Customer 5 | 142.7464285714285 | 386.6374999999999 | 0 | 0 | 0
Spreadsheet: 803336d1667398706-formula-to-summary-countif-greater-than-book2
Sheet: Sheet1

Company Name | June | July | August | September | October
a |  | 2 |  | 4 | 1
b | 3 |  | 3 | 3 | 3 |  |  |  | June | 1
c | 1 |  | 1 |  | 1 |  |  |  | July | 6
d | 4 | 13 | 2 |  |  |  |  |  | August | 8
e |  |  |  | 19 | 2 |  |  |  | September | 11
f |  |  |  | 1 |  |  |  |  | October | 12
g |  |  | 1
h | 2 |  |  |  | 3
i |  | 22 | 91 | 32
j | 1
k |  | 2 | 1
l |  | 1 |  |  | 2
m | 1
n |  | 7 | 1
o |  |  | 10 | 5 | 4
p | 26 | 1
q |  |  | 6 | 6
r |  | 8 | 6 | 12
s |  |  |  | 1
t |  | 4 |  |  | 1
u |  | 1 | 3 | 10
v | 1
w | 3 | 4
x |  | 18
y |  |  | 13 | 5
z |  | 19 | 35
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 11a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | - | 817 | 817
Cross-Currency Fixed-Fixed | - | 63 | 63
Cross-Currency Fixed-Float | - | 708 | 708
TOTAL | - | 1588 | 1588
Spreadsheet: jeffrey_a_shankman__13973__5th floorplan1004
Sheet: Sheet1

5th Floor Analysis
 |  |  |  |  | Total
 |  |  | Actual | Growth | Desks |  | Comments
Generation Development | [NAME] |  | 18
Generation Investments | Tricoli |  | 37
(includes [NAME], Vetters)
Technical Svc | Virgo |  | 3
Mergers & Acquisition | [NAME] |  | 9
Upstream | Mrha |  | 13
Long Term Fundamentals | [NAME] |  | 6
Gas Structuring (w/EES) | [NAME] |  | 20 | 4
Power Structuring | Meyn |  | 10
EES Power Structuring | Aucoin |  | 11 | 3
EES Phoenix | [NAME] |  | 8 | 3
EES DSM | Pagan |  | 10 | 2
EES Pwr Load Forecasting | Frazier |  | 3 | 3
EES URM | Furrow |  | 49 | 1
EES Gas Forecasting | Chmil |  | 1 | 2
EES Curves, Acct/Svc | Wiltfong |  | 3
Fundies | Gaskill/Will |  | 9
Genco | Will |  | 1
Power Regulatory |  |  | 2 |  |  |  | Do we need all 6?
EES Power Risk | Albrecht |  |  | 7
EES Gas Risk | Mills |  | 5 | 3 |  |  | 4 add'l on 6th floor
ENA Power Op's | Hall |  | 20 | 0
ENA Gas Op's | Hall |  | 142
IT Desk Top |  |  | 6
Growth | Kitchen |  | 0 | 23 |  |  | Includes 5 temp IT
Total
Total Trading Desks
Spreadsheet: 484633d1476366278-count-if-help-if-statement-help-1-
Sheet: Sheet1

 |  |  |  |  |  | Sector-GICS |  | Sector-GICS |  | Sector-GICS |  | Sector-GICS |  | Sector-GICS |  | Sector-GICS |  | Sector-GICS |  | Sector-GICS
Symbol | Company Name | [NAME] | GICS Sector | FactSet Sector | FY0 vs FY1 | FY0 vs FY1 | FY1 vs FY2 | FY1 vs FY2 | FY2 vs FY3 | FY2 vs FY3 | FY3 vs FY4 | FY3 vs FY4 | FY4 vs FY5 | FY4 vs FY5 | FY5 vs FY6 | FY5 vs FY6 | FY6 vs FY7 | FY6 vs FY7 | FY7 vs FY8 | FY7 vs FY8 | Score FY0
AAP | Advance Auto Parts, Inc. | 10903.138 | Consumer Discretionary | Retail Trade | -- | 0.2113530300020736 | -- | 0.02629137241749002 | -- | -0.05240155367809596 | -0.2809918882325688 | 0.1348584064239524 | 0.359023061036871 | -0.02426277700605017 | 0.004775894525879121 | 0.009416261481707933 | 0.7285915846268718 | 0.4516571313629001 | 0.6133122266335465 | -0.03980402927084004
 |  |  |  |  | 0
Spreadsheet: 485887d1477151717-table-calling-lists-of-variant-sizes-and-with-duplicate-values-example
Sheet: Sheet1

 | Alpha | Beta | Gamma | Delta | Zeta | Eta | Theta | Iota | Kappa | Lambda | Mu | Nu | [NAME] | Omicron | Pi | Rho | Sigma | Tau | Upsilon | Phi | Chi | Psi | Omega |  |  |  |  |  | Greek letters used as an example for the dropdown values.  To be called in Sheet 2 by dropdown list.
 | A2 | B2 | C2 | D2 | E2 | F2 | G2 | H2 | I2 | J2 | K2 | L2 | MR | NR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values each greek letter is to call when it is selected via dropdown.
 | A2 | B2 | C2 | D2 | E3 | F3 | G3 | H3 | I3 | J3 | K3 | L3 | MP | NP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duplicate values are intentional.
 | A2 | B2 | C2 | D2 | E3 | F3 | G3 |  |  |  |  |  | ML | NL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Varying list sizes are intentional.
 | A3 | B3 |  |  | E3 | F3 | G3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need to figure out how to get the table on Sheet 2 to display a list in full when one of the letter is selected.
 | A3 | B3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The tricky part is the variable sizes of the lists, as well as the duplicate values.  I need to get these to fill
 | A3 | B3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | out properly without Autofilling incorrectly.  Example:  Need to account for the size of [NAME] and Beta,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | without lists with an LCM (such as Mu followed by [NAME]) triggering some manner of list filling out when not called.
Spreadsheet: 4562da93-44e2-4bba-a167-4a2b5ff559db
Sheet: SD_RTUNITASM

Real Time Unit Entitlement Report
SD_RTUNITASM_<customer id>_<settlement date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 | Unit |  |  |  |  |  |  | Customer Share
Trading Interval | Asset ID | Asset Name | Asset Sub-Type | Location Id | Location Name | Location Type | Generator [NAME] | Ownership Share | Customer Share of [NAME] | Settlement Only Flag
Hour End | Number | String | String | Number | String | String | MWh | % | MWh | String
Spreadsheet: 202654d1356667188-any-idea-why-im-getting-calculation-differences-apr-prediction-bvj-
Sheet: APR Predictions

 | Model Years | Tier | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | Term | 720+ | 719-700 | 699-680 | 679-660 | 659-640 | 639-620 | 619-600 | Model YearW | Term W 1 | Term W 2 | Term W 3 | TermW4
 | 2011-2013 | 48 | 1.99 | 2.49 | 3.29 | 4.49 | 6.99 | 9.99 | 10.99 | 0.6026 | 0.0316 | 0 | 0.7964
 |  | 49-66 | 1.99 | 2.49 | 3.49 | 4.99 | 7.49 | 10.99 | 11.99 |  | 0.1511 | 0.06 | 0.2036
 |  | 72 | 1.99 | 2.49 | 4.19 | 5.49 | 8.49 | 11.99 |  |  | 0.6959 | 0.94
 |  | 75-78 | 3.99 | 4.49 | 5.19 |  |  |  |  |  | 0.0325
 |  | 84* | 4.99 | 5.49 | 6.19 |  |  |  |  |  | 0.0889
 | [NAME] per Tier
 | [NAME] |  | 0.7365524736920109 | 0.0913251126620135 | 0.07668243960626704 | 0.05503153901817613 | 0.02570290770310552 | 0.01107848575717606 | 0.0036270415612507
 | 2008-2010 | 48 | 2.79 | 2.99 | 3.89 | 4.99 | 7.09 | 10.49 | 11.99 | 0.1824 | 0.0237 | 0 | 0 | 0.0513
 |  | 49-66 | 2.99 | 3.39 | 4.29 | 5.49 | 7.59 | 10.99 | 12.49 |  | 0.1523 | 0.0602 | 0.0844 | 0.9487
 |  | 72 | 3.79 | 4.19 | 5.09 | 6.49 | 8.59 | 12.24 |  |  | 0.4663 | 0.7165 | 0.9156
 |  | 75-78 | 4.59 | 4.99 | 5.89 |  |  |  |  |  | 0.1076 | 0.2333
 |  | 84* | 4.99 | 5.99 |  |  |  |  |  |  | 0.2501
 | [NAME] per Tier
 | [NAME] |  | 0.4001221873601836 | 0.1623183694388007 | 0.1565264040217351 | 0.1195182437431986 | 0.1007426081662049 | 0.04222443318959546 | 0.0185477540802817
 | 2004-2007 | 48 | 3.59 | 3.89 | 5.39 | 6.29 | 8.09 | 11.99 | 12.99 | 0.1789 | 0.0791 | 0.0774
 |  | 49-66 | 4.49 | 4.99 | 6.49 | 7.39 | 8.99 | 12.99 | 14.49 |  | 0.3144 | 0.9226
 |  | 72 | 4.99 | 5.49 | 6.99 | 7.89 | 9.59 | 14.24 |  |  | 0.6065
 | [NAME] per Tier
 | [NAME] |  | 0.4657358615578827 | 0.1706894388880951 | 0.1314212406229296 | 0.07999683137156362 | 0.1122457989364554 | 0.02888282407573078 | 0.01102800454734272
 | 2002-2003 | 48 | 5.49 | 6.49 | 7.49 | 8.49 | 10.99 | 12.99 | 14.99 | 0.0361 | 0.4126
 |  | 49-66 |  |  |  |  |  |  |  |  | 0.5874
 | [NAME] per Tier
 | [NAME] |  | 0.4305903182766806 | 0.1555521941358843 | 0.1651964437871536 | 0.09855344788660002 | 0.0633713693705001 | 0.05415800958340793 | 0.03257821695977354
 |  |  |  |  |  |  |  |  |  | WAPR |  |  |  |  |  |  |  |  |  |  |  | WAPR
 | WTier
 |  |  | 720+ | 719-700 | 699-680 | 679-660 | 659-640 | 639-620 | 619-600
 | WAPR
 | Reserve |  | 0.6 | 0.6 | 0.35 | 0.35 | 0.35 | 0.35 | 0.35
 | Discount |  | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11 | 0.11
 | COF |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | OPEX |  | 1.7 | 1.75 | 1.8 | 1.85 | 1.9 | 1.95 | 2
 | EL |  | 0.84 | 1.56 | 2.26 | 3.16 | 3.92 | 5.96 | 7.53
 | RETURN
Spreadsheet: 63554d1264452475-payroll-taxes-missyreiber3
Sheet: YTD COMP

 | Year to Date W-2 Compensation
Pay# |  | 2009-01-09 00:00:00 | 2009-02-09 00:00:00 | 2009-03-09 00:00:00 | 2009-04-09 00:00:00 | 2009-05-09 00:00:00 | 2009-06-09 00:00:00 | 2009-07-09 00:00:00 | 2009-08-09 00:00:00 | 2009-09-09 00:00:00 | 2009-10-09 00:00:00 | 2009-11-09 00:00:00 | 2009-12-09 00:00:00 | YTD TOTAL |  | [NAME] for MPP
107 | SMITH |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 14504.36 | 14504.36
Spreadsheet: 708430d1607825178-add-vlookup-function-containing-match-statement-to-one-sheet-from-another-order-template
Sheet: List

46-0-0 UREA
0-0-62 MOP COARSE GRADE
40-0-0+5.5S UREA-SOL BLEND
40-0-0+5.5S AMIDAS
34-0-0+11S
31-10-0+7S
18-18-18+2.5S BALANCED BLEND
14-28-6+3MG+7.3S+.1MN+.1B+.2ZN LOW P CORN STARTER
9-40-4 NO MICROS (STARTER)
9-40-4+2MG+7S+.1B+.2ZN
30-0-17+3S 50% CRN
44-0-0 ESN 100% PCU
CUSTOM 20-24-5+5S+.2ZN NO FILL DC (STARTER)
CUSTOM 24-15-5+7S+.2ZN NO FILL DC (STARTER)
21-0-0+24S AMMONIUM SULPHATE
11-52-0 MAP (MONO AMMONIUM PHOSPHATE)
30-0-20
30-0-17+3S
28-10-10+3S
17-20-0+14S
13-16-10+11S ALL PURPOSE BALANCED BLEND
8-24-24+3S
SE 40-0-0+5.5S+.0057SE SELCOTE - 5.7KG/T
CUSTOM PENERGETIC K 24-15-5+7S+.2ZN NO FILL ULTRA FINE 1KG/T
CUSTOM PENERGETIC K 20-24-5+5S+.2ZN NO FILL ULTRA FINE 1KG/T
Spreadsheet: 679808d1590644243-changing-daily-value-in-cell-test
Sheet: Sheet2

 |  |  |  | daily change
 |  |  |  | =HLOOKUP(TODAY(),$A$19:$R$20,2,0)
 |  | 43979 | 43980 | 43981 | 43982 | 43983 | 43984 | 43985 | 43986 | 43987 | 43988 | 43989 | 43990 | 43991 | 43992 | 43993 | 43994
 |  | 55 | 65 | 67 | 89 | 3 | 5 | 7
Spreadsheet: 843719d1695527547-looking-for-non-array-formula-to-show-dates-in-e2-e6-if-condition-in-column-a5-is-met-sample_weekdayextraction
Sheet: Sheet1

2022-11-01 00:00:00 |  | Desired Output | DayList | Desired Output | DayList |  | Month Numbering | Date | Nth Day | 1 | 2 | 3 | 4 | 5
 |  |  |  | 2022-11-12 00:00:00 |  |  | 1 | 2022-01-01 00:00:00 | 5 | 2022-01-02 00:00:00 | 2022-01-09 00:00:00 | 2022-01-16 00:00:00 | 2022-01-23 00:00:00 | 2022-01-30 00:00:00
 |  | 2022-11-13 00:00:00 |  | 2022-11-19 00:00:00 |  |  | 2 | 2022-02-01 00:00:00 | 4 | 2022-02-06 00:00:00 | 2022-02-13 00:00:00 | 2022-02-20 00:00:00 | 2022-02-27 00:00:00
DayList |  | 2022-11-20 00:00:00 |  | 2022-11-26 00:00:00 |  |  | 3 | 2022-03-01 00:00:00 | 4 | 2022-03-06 00:00:00 | 2022-03-13 00:00:00 | 2022-03-20 00:00:00 | 2022-03-27 00:00:00
Saturday |  | 2022-11-27 00:00:00 |  | 2022-12-03 00:00:00 |  |  | 4 | 2022-04-01 00:00:00 | 4 | 2022-04-03 00:00:00 | 2022-04-10 00:00:00 | 2022-04-17 00:00:00 | 2022-04-24 00:00:00
 |  |  |  |  |  |  | 5 | 2022-05-01 00:00:00 | 5 | 2022-05-01 00:00:00 | 2022-05-08 00:00:00 | 2022-05-15 00:00:00 | 2022-05-22 00:00:00 | 2022-05-29 00:00:00
 |  |  |  |  |  |  | 6 | 2022-06-01 00:00:00 | 4 | 2022-06-05 00:00:00 | 2022-06-12 00:00:00 | 2022-06-19 00:00:00 | 2022-06-26 00:00:00
 |  |  |  |  |  |  | 7 | 2022-07-01 00:00:00 | 5 | 2022-07-03 00:00:00 | 2022-07-10 00:00:00 | 2022-07-17 00:00:00 | 2022-07-24 00:00:00 | 2022-07-31 00:00:00
 |  |  |  |  |  |  | 8 | 2022-08-01 00:00:00 | 4 | 2022-08-07 00:00:00 | 2022-08-14 00:00:00 | 2022-08-21 00:00:00 | 2022-08-28 00:00:00
 |  |  |  |  |  |  | 9 | 2022-09-01 00:00:00 | 4 | 2022-09-04 00:00:00 | 2022-09-11 00:00:00 | 2022-09-18 00:00:00 | 2022-09-25 00:00:00
 |  |  |  |  |  |  | 10 | 2022-10-01 00:00:00 | 5 | 2022-10-02 00:00:00 | 2022-10-09 00:00:00 | 2022-10-16 00:00:00 | 2022-10-23 00:00:00 | 2022-10-30 00:00:00
 |  |  |  |  |  |  | 11 | 2022-11-01 00:00:00 | 4 | 2022-11-06 00:00:00 | 2022-11-13 00:00:00 | 2022-11-20 00:00:00 | 2022-11-27 00:00:00
 |  |  |  |  |  |  | 12 | 2022-12-01 00:00:00 | 4 | 2022-12-04 00:00:00 | 2022-12-11 00:00:00 | 2022-12-18 00:00:00 | 2022-12-25 00:00:00
 |  |  |  |  |  |  | DayList | DayList #
 |  |  |  |  |  |  | Sunday | 1
 |  |  |  |  |  |  | Monday | 2
 |  |  |  |  |  |  | Tuesday | 3
 |  |  |  |  |  |  | Wednesday | 4
 |  |  |  |  |  |  | Thursday | 5
 |  |  |  |  |  |  | Friday | 6
 |  |  |  |  |  |  | Saturday | 7