tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 37950d1236070627-data-validation-problem-cricket
Sheet: BATTING STATS

BATTING STATISTICS
 | Player |  | [NAME]. | Runs | N/O | 50's | 100's | H/S | Average |  | 4's | 6's | % bound. | % Runs
 | BARBER, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | BARBER, [NAME]. |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | BISHOP, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | CHAPMAN, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | COSGROVE, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | COSGROVE, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | COUCHMAN, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | GOODWIN, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | HIRST, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | [NAME], [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | MEREDITH, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | RICHARDSON, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | SIMPSON, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | SKERRETT, [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | #N/A |  | 0 | 0 | #N/A | #N/A
 | Team Stats |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | #N/A | #N/A
Spreadsheet: benjamin_rogers__1109__contact numbers
Sheet: Gleason

 | [NAME]
 | 1166 [NAME], Gleason, TN 38229
 | General Phone Numbers |  |  | Plant Personnel
 | Control Room 1 | [PHONE] |  | Name | Title | Office | Cellular | Home | [NAME]
 | Control Room 2 |  |  | [NAME] | Plant Manager | [PHONE] | [PHONE] | [PHONE] | [EMAIL]
 | Control Room Fax | [PHONE] |  | [NAME] | Plant Supervisor | [PHONE] | [PHONE] | [PHONE] | [EMAIL]
 | On Call Pager 1 |  |  | [NAME] | Admin. [NAME]. |  |  | [PHONE] | [EMAIL]
 | On Call Pager 2 |  |  | [NAME] | Tech |  |  | 901-364-
 |  |  |  | [NAME] | Tech |  |  | [PHONE]
 | Neighboring Control Areas |  |  | [NAME] | Tech |  |  | [PHONE]
 | TVA Security Coordinator | [PHONE] |  | [NAME] | Tech |  |  | [PHONE]
 | TVA Control Room | [PHONE] |  | [NAME] | Tech |  |  | [PHONE]
 | TVA Transmission | [PHONE]
 |  |  |  |  | Emergency Numbers
 | ANR-LA Onshore Pipeline |  |  |  | Fire | [PHONE]
 |  |  |  |  | Police | [PHONE] | or 364-5454
 |  |  |  |  | City Central Dispatch | [PHONE] | or 364-2206
 |  |  |  |  | Sherff | [PHONE] | or 364-2207
 |  |  |  |  | Ambulance | [PHONE]
Spreadsheet: 860976d1708992699-embeding-qr-code-into-cell-engineering-store-system-
Sheet: PRINT LABEL

PRINT STORES LABEL
TO PRINT LABEL, TYPE THE 4 DIGIT STORE CODE NUMBER IN THE YELLOW BOX BELOW AND PRESS PRINT (UNDER THE FILE TAB)
STORES CODE | OEM PART NUMBER | EQUIPMENT | [NAME] | STORES LOCATION | QR CODE
 |  |  | 0001
Spreadsheet: michelle_cash__26489__HR Contacts
Sheet: HR Contacts

HR Contacts
Name | Work Ext | Home | Cell
[NAME] ([NAME]), [NAME] | 5-3791 | [PHONE] | [PHONE]
[NAME], [NAME] | 3-3931 | [PHONE] | [PHONE]
Buckley, [NAME] | 5-4667 | [PHONE] | [PHONE]
Cash, [NAME] | 3-6401 | [PHONE] | [PHONE]
Cashion, Tana | 5-9652 | [PHONE] | [PHONE]
Clyatt, [NAME] | 3-3256 | [PHONE] | [PHONE]
Curless, [NAME] | 5-7842 | [PHONE] | [PHONE]
Davies, [NAME] | 3-7229 | [PHONE] | [PHONE]
Doucet, [NAME] | 828 3-6724 | [PHONE] | n/a
[NAME], [NAME] | 5-2729 | [PHONE] | [PHONE]
[NAME], [NAME] | 5-4360 | [PHONE] | n/a
[NAME], [NAME] | 3-7829 | [PHONE] | n/a
Kearney, Julie | 823-4-7404 | [PHONE] | [PHONE]
Labbe, Anne | 5-7809 | [PHONE] | [PHONE]
[NAME], [NAME] | 3-9134 | [PHONE] | [PHONE]
[NAME], [NAME] | 3-3557 | [PHONE] | [PHONE]
Philpott, [NAME] | 5-7269 | [PHONE] | [PHONE]
Rahaim, [NAME] | 5-2407 | [PHONE] | [PHONE]
[NAME], Estalee | 5-4320 | [PHONE] | [PHONE]
Slone, [NAME] | 5-3847 | [PHONE] | [PHONE]
Yeverino, [NAME] | 3-5164 | [PHONE] | [PHONE]
Spreadsheet: daren_farmer__5858__accrued0500
Sheet: Sheet2

Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity |  |  | Sum of Quantity |  | Sum of Quantity |  | Sum of Quantity
Period | Total | Period | Total | Period | Total | Period | Total |  | Period | Total | Period | Total | Period | Total
01-MAY-2000 | -20454 | 01-MAY-2000 | -78770 | 01-MAY-2000 | -79659 | 01-MAY-2000 | -90176 |  | 01-MAY-2000 | -90608 | 01-MAY-2000 | -86201 | 01-MAY-2000 | -84316
02-MAY-2000 | -60808 | 02-MAY-2000 | -56595 | 02-MAY-2000 | -56535 | 02-MAY-2000 | -54382 |  | 02-MAY-2000 | -63760 | 02-MAY-2000 | -62538 | 02-MAY-2000 | -60297
03-MAY-2000 | -5218 | 03-MAY-2000 | -3242 | 03-MAY-2000 | -3182 | 03-MAY-2000 | -14822 |  | 03-MAY-2000 | -18409 | 03-MAY-2000 | -14565 | 03-MAY-2000 | -12214
Grand Total | -86480 | 04-MAY-2000 | 14191 | 04-MAY-2000 | 18947 | 04-MAY-2000 | 5461 |  | 04-MAY-2000 | 14056 | 04-MAY-2000 | 20312 | 04-MAY-2000 | 22032
 |  | Grand Total | -124416 | 05-MAY-2000 | -42697 | 05-MAY-2000 | -59838 |  | 05-MAY-2000 | -47380 | 05-MAY-2000 | -41123 | 05-MAY-2000 | -39420
 |  |  |  | 06-MAY-2000 | -34026 | 06-MAY-2000 | -31950 |  | 06-MAY-2000 | -43153 | 06-MAY-2000 | -36892 | 06-MAY-2000 | -35496
 |  |  |  | 07-MAY-2000 | -110720 | 07-MAY-2000 | -94435 |  | 07-MAY-2000 | -98617 | 07-MAY-2000 | -92349 | 07-MAY-2000 | -91171
 |  |  |  | Grand Total | -307872 | 08-MAY-2000 | -52630 |  | 08-MAY-2000 | -57744 | 08-MAY-2000 | -51484 | 08-MAY-2000 | -50199
 |  |  |  |  |  | Grand Total | -392772 |  | 09-MAY-2000 | 40566 | 09-MAY-2000 | 47054 | 09-MAY-2000 | 49297
 |  |  |  |  |  |  |  |  | 10-MAY-2000 | -38294 | 10-MAY-2000 | -37802 | 10-MAY-2000 | -34934
 |  |  |  |  |  |  |  |  | 11-MAY-2000 | -13145 | 11-MAY-2000 | -13003 | 11-MAY-2000 | -19540
 |  |  |  |  |  |  |  |  | 12-MAY-2000 | 277 | 12-MAY-2000 | 3918 | 12-MAY-2000 | 2033
 |  |  |  |  |  |  |  |  | 13-MAY-2000 | -104076 | 13-MAY-2000 | -99856 | 13-MAY-2000 | -105097
 |  |  |  |  |  |  |  |  | 14-MAY-2000 | -51817 | 14-MAY-2000 | -36839 | 14-MAY-2000 | -42012
 |  |  |  |  |  |  |  |  | Grand Total | -572104 | 15-MAY-2000 | -60983 | 15-MAY-2000 | -59264
 |  |  |  |  |  |  |  |  |  |  | Grand Total | -562351 | 16-MAY-2000 | -31834
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | -592432
Spreadsheet: 142825d1330021352-sorting-based-on-two-columns-sample-for-new-logic-
Sheet: Copy of date trim for 2000b

START_DATE | END_DATE | TYPES | RECIPIENT | CODE | Result | Pattern
2000-04-27 00:00:00 | 2000-05-13 00:00:00 | PP | VE421113 | 7 |  | 2
2000-05-14 00:00:00 | 2000-07-18 00:00:00 | MM | VE421113 | 10
2000-07-19 00:00:00 | 2000-08-20 00:00:00 | FF | VE421113 | 17
2000-08-25 00:00:00 | 2000-11-01 00:00:00 | PP | VE421113 | 7
2000-08-26 00:00:00 | 2000-10-13 00:00:00 | MM | YN599321 | 20 |  | 3
2000-10-14 00:00:00 | 2000-11-16 00:00:00 | PP | YN599321 | 7
2000-11-20 00:00:00 | 2000-12-01 00:00:00 | PP | YN599321 | 17
2000-01-01 00:00:00 | 2000-02-03 00:00:00 | MM | WA998123 | 7 |  | Not to be considered because of PP is not associated with this
2000-02-05 00:00:00 | 2000-04-25 00:00:00 | FF | WA998123 | 17
2000-01-27 00:00:00 | 2000-02-24 00:00:00 | PP | ZZ072111 | 7 |  | 1
2000-04-01 00:00:00 | 2000-05-03 00:00:00 | FF | ZZ072111 | 11
2000-03-16 00:00:00 | 2000-05-18 00:00:00 | PP | WE034999 | 20 |  | 0
2000-05-19 00:00:00 | 2000-08-15 00:00:00 | MM | WE034999 | 11
2000-04-10 00:00:00 | 2000-05-12 00:00:00 | FF | WE034999 | 11
Spreadsheet: 37868d1235977681-lookup-value-from-an-array-and-place-values-in-boxes-next-to-it-book1
Sheet: Sheet1

Transmission | 1st | 2nd | 3rd | 4th | 5th | 6th
Powerglide | 1.76 | 1 | 0 | 0 | 0 | 0
TH350 | 2.52 | 1.52 | 1 | 0 | 0 | 0
[NAME] | 2.48 | 1.48 | 1 | 0 | 0 | 0
TH200-4R | 2.78 | 1.57 | 1 | 0.67 | 0 | 0
4L60(E) | 3.06 | 1.63 | 1 | 0.7 | 0 | 0
4L80(E) | 2.48 | 1.48 | 1 | 0.75 | 0 | 0
6L80E | 4.02 | 2.36 | 1.53 | 1.15 | 0.85 | 0.67
T5 | 2.95 | 1.94 | 1.34 | 1 | 0.63 | 0
T5 (V6) | 3.75 | 2.19 | 1.41 | 1 | 0.72 | 0
T56 | 2.66 | 1.78 | 1.3 | 1 | 0.74 | 0.5
ZF6 | 2.68 | 1.8 | 1.29 | 1 | 0.63 | 0.5
T56
Spreadsheet: 2eadebf8-6495-4b7a-9a2a-a9cea57d455c
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0029195 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Bradford Crossing Shopping Center | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Iredell | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate
Monthly Limit: |  |  | 4500
Daily Limit:
Sample Frequency: |  |  | Monthly
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: New Albany

INCOME STATEMENT - NEW ALBANY
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
Owner's Expense
Property Taxes Liability | 487.9 | 486.5 | 484.5 | 476.4 | 467.3 | 451.3 | 427.8 | 402.5 | 362.4 | 878.3 | 695.3 | 494 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9 | 365.9
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - NEW ALBANY
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -488.8
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - NEW ALBANY
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Paid-In-Capital
[NAME] (less Amortization of Power Contract)
Outstanding Debt
Shareholders Equity & Long Term Debt
State Franchise Tax Rate
State Franchise Tax Liability | 418.9497182486736 | 408.0399840692683 | 396.9938001587087 | 371.883152531502 | 345.1813107052982 | 317.8479128262229 | 296.259021476169 | 276.3425122495318 | 257.3949639557628 | 237.4610119137425 | 219.1259441469751 | 200.6601225685261 | 181.876767855959 | 162.7244844741364 | 143.5051171219643 | 128.8772971885699 | 118.7866477364092 | 108.709547756894 | 98.64823184583894 | 88.6048174469822
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
State Tax after Allocation of Corporate [NAME]
State Taxable Income before Corporate G&A
Corporate G&A Allocation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Book State Tax after Allocation of Corporate [NAME]
EBT before Corporate [NAME]
Corporate G&A Allocation
EBT
Book State Tax Benefit / (Expense)
Spreadsheet: 4989f394-decc-4786-ae5f-33b61944db0c
Sheet: Sheet1

Portland Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-27 | 1 | Portland | 3 | Syracuse | 4 | Final OT | Onondaga County War Memorial Arena Syracuse, NY
2013-04-28 | 2 | Portland | 2 | Syracuse | 4 | Final | Onondaga County War Memorial Arena Syracuse, NY
2013-05-02 | 3 | Syracuse | 4 | Portland | 3 | Final OT | Cumberland County Civic Center Portland, ME
Spreadsheet: 8ef4fbb1-cce5-41ee-86c7-1a55044ae87e
Sheet: Sheet1

athletes_idAthletes | Rk | Nation | Date of Birth | ID Number | Last Name | First Name | Total Pts | Fenc | Swim | Ride | Comb | Swim time
3881 | 1 | USA | 07/10/91 | W003881 | ISAKSEN | Margaux | 5552 | 1072 | 1120 | 1160 | 2200 | 2:20.02
2054 | 2 | LTU | 28/02/84 | W002054 | ASADAUSKAITE | [NAME] | 5372 | 880 | 1064 | 1200 | 2228 | 2:21.62
39606 | 3 | UKR | 29/01/90 | W039606 | KHOKHLOVA | Iryna | 5344 | 856 | 1120 | 1200 | 2168 | 2:20.05
5097 | 4 | HUN | 12/03/91 | [NAME] | KOVACS | Sarolta | 5288 | 856 | 1196 | 1180 | 2056 | 2:13.72
1778 | 5 | GER | 11/04/86 | W001778 | SCHONEBORN | [NAME] | 5272 | 904 | 1028 | 1180 | 2160 | 2:27.99
1734 | 6 | UKR | 18/02/82 | W001734 | TERESHUK | Victoria | 5272 | 856 | 1072 | 1180 | 2164 | 2:24.00
1329 | 7 | EGY | 20/11/88 | W001329 | [NAME] | Aya | 5240 | 880 | 1156 | 1160 | 2044 | 2:17.11
39969 | 8 | BLR | 20/09/85 | W039969 | PROKOPENKO | Anastasiya | 5212 | 736 | 996 | 1180 | 2300 | 2:30.50
39469 | 9 | FRA | 14/01/89 | W039469 | CLOUVEL | Elodie | 5204 | 928 | 1236 | 1012 | 2028 | 2:10.48
3945 | 10 | GER | 03/04/90 | W003945 | SCHLEU | Annika | 5176 | 640 | 1128 | 1200 | 2208 | 2:19.36
4159 | 11 | RUS | 21/08/89 | W004159 | KHURASKINA | Ekaterina | 5168 | 856 | 952 | 1192 | 2168 | 2:34.14
1784 | 12 | GBR | 31/08/85 | W001784 | SPENCE | Mhairi | 5152 | 856 | 1104 | 1140 | 2052 | 2:21.64
38071 | 13 | ITA | 04/08/86 | W038071 | CESARINI | Claudia | 5140 | 832 | 1024 | 1120 | 2164 | 2:28.01
1201 | 14 | GER | 19/06/82 | W001201 | TRAUTMANN | Eva | 5104 | 784 | 1100 | 1048 | 2172 | 2:21.86
4160 | 15 | GBR | 01/06/89 | W004160 | BURKE | [NAME] | 5100 | 736 | 1136 | 1200 | 2028 | 2:18.90
1464 | 16 | ITA | 08/08/85 | W001464 | CROGNALE | [NAME] | 5032 | 904 | 1056 | 1200 | 1872 | 2:25.52
5056 | 17 | USA | 22/01/88 | W005056 | STETTINIUS | Suzanne | 5000 | 712 | 1020 | 1200 | 2068 | 2:25.01
1575 | 18 | GBR | 03/03/83 | W001575 | FELL | Heather | 4892 | 616 | 1120 | 1200 | 1956 | 2:20.07
Spreadsheet: 250311d1373898924-excel-how-to-calculate-number-of-night-shift-hours-example_nightshift
Sheet: Sheet1

Night shift hours start | 20:00:00
Night shift hours end | 04:00:00
Day | Shift started | Shift ended | Normal hours | Night shift hours
2013-06-01 00:00:00 | 07:30:00 | 15:00:00 | 7.5 | 07:30:00 | there should not be any hours..
2013-06-02 00:00:00 | 15:00:00 | 22:30:00 | 7.5
2013-06-03 00:00:00 | 15:00:00 | 22:30:00 | 7.5
2013-06-04 00:00:00 | 07:30:00 | 15:30:00 | 8
2013-06-05 00:00:00 | 08:00:00 | 15:00:00 | 7
2013-06-06 00:00:00 | 15:15:00 | 22:30:00 | 7.250000000000001
2013-06-07 00:00:00 | 15:15:00 | 22:30:00 | 7.250000000000001
2013-06-08 00:00:00 | 07:30:00 | 15:00:00 | 7.5
2013-06-09 00:00:00 | 08:00:00 | 15:00:00 | 7
2013-06-10 00:00:00 | 08:00:00 | 15:00:00 | 7
2013-06-11 00:00:00 | 07:30:00 | 15:30:00 | 8
2013-06-12 00:00:00 | 22:00:00 | 07:30:00 | 9.5
2013-06-13 00:00:00 | 22:00:00 | 07:30:00 | 9.5
Spreadsheet: 839134d1691684714-dynamic-drop-down-list-in-excel-sample
Sheet: FN

 | FN |  | Bal | PL
 | FN1 |  | FN11 | FN21
 | FN2 |  | FN12 | FN22
 | FN3 |  | FN13 | FN23
 | FN4 |  | FN14 | FN24
 | FN5
 | FN11
 | FN12
 | FN13
 | FN14
 | FN21
 | FN22
 | FN23
 | FN24
Spreadsheet: 0a9f833e-a58c-4f32-9a1d-d4501077c16e
Sheet: Sheet1

Public Service Commissioner - REP (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 12/5/2013 3:52:11 PM
Precincts Reporting: 693/693 - Total Ballots Cast: 94306
2000 Primary Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
Adams | 241 | 241
Barnes | 734 | 734
Benson | 256 | 256
Billings | 143 | 143
Bottineau | 673 | 673
[NAME] | 359 | 359
Burke | 164 | 164
Burleigh | 4122 | 4122
[NAME] | 2790 | 2790
Cavalier | 345 | 345
Dickey | 403 | 403
Divide | 109 | 109
Dunn | 363 | 363
Eddy | 179 | 179
Emmons | 417 | 417
[NAME] | 168 | 168
Golden Valley | 143 | 143
Grand Forks | 4263 | 4263
Grant | 444 | 444
Griggs | 250 | 250
Hettinger | 369 | 369
Kidder | 240 | 240
[NAME] | 382 | 382
Logan | 266 | 266
McHenry | 480 | 480
McIntosh | 336 | 336
McKenzie | 410 | 410
McLean | 787 | 787
Mercer | 940 | 940
[NAME] | 1459 | 1459
[NAME] | 304 | 304
[NAME] | 164 | 164
[NAME] | 291 | 291
Pembina | 561 | 561
Pierce | 277 | 277
Ramsey | 579 | 579
[NAME] | 223 | 223
[NAME] | 223 | 223
Richland | 646 | 646
Rolette | 250 | 250
Sargent | 255 | 255
[NAME] | 382 | 382
Sioux | 70 | 70
Slope | 102 | 102
[NAME] | 2575 | 2575
Steele | 171 | 171
[NAME] | 1120 | 1120
Towner | 118 | 118
Traill | 462 | 462
Walsh | 459 | 459
Ward | 2793 | 2793
Wells | 353 | 353
[NAME] | 1179 | 1179
TOTAL | 35792 | 35792
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 863219d1710785725-join-data-as-a-spilled-array-based-on-criteria-spill-array-formula-03
Sheet: Sheet2

UniqueOutcome
g,i0,1
g,i0,2
h,i0,1
h,i2,2
h,i3,2
d,e,f0,0,0
d,e,g0,0,0
d,g,h0,0,2
d,g,i0,0,2
d,e,g,i3,0,1,1
d,e,g,i2,0,0,1
d,e,g,i222,0,1,1
d,e,g,i3,0,0,1
d,e,g,i22,0,0,1
d,e,g,i22,0,1,1
d,e,g,i22,0,2,2
d,e,g,i222,0,2,2
d,e,g,i0,0,0,1
d,e,g,i0,0,0,2
e,f,g0,0,0
e,f,h0,0,2
e,f,h0,0,3
e,f,i0,0,2
e,g,h0,0,2
e,g,h0,0,3
e,g,i0,0,2
e,h,i0,2,2
e,h,i0,3,2
f,g,h2,1,0
f,g,h22,2,2
f,g,h0,0,0
f,g,h0,0,2
f,g,h0,0,3
f,g,i2,1,1
f,g,i22,2,2
f,g,i0,0,1
f,g,i0,0,2
f,h,i2,0,1
f,h,i22,2,2
f,h,i0,0,1
f,h,i0,2,2
f,h,i0,3,2
g,h,i1,0,1
g,h,i2,2,2
g,h,i0,0,1
g,h,i0,2,2
g,h,i0,3,2
d,e,f,g3,0,2,1
d,e,f,g2,0,0,0
d,e,f,g222,0,2,1
d,e,f,g3,0,0,0
d,e,f,g22,0,0,0
d,e,f,[NAME]
d,e,f,g22,0,22,2
d,e,f,g222,0,22,2
d,e,f,g0,0,0,0
d,e,f,h3,0,2,2
d,e,f,h2,0,0,2
d,e,f,[NAME]
d,e,f,h3,0,0,0
d,e,f,h2,0,0,0
d,e,f,h22,0,0,0
d,e,f,h22,0,2,0
d,e,f,h3,0,2,0
d,e,f,h22,0,22,2
d,e,f,h222,0,22,2
d,e,f,h0,0,0,0
d,e,f,h0,0,0,2
d,e,f,h0,0,0,3
Spreadsheet: eric_saibi__9800__091801
Sheet: West Phoenix 04

Owner Name |  | Arizona Public Service Company
Station Name |  | West Phoenix Power Station
Unit Name |  | Unit 04 CT/HRSG
NERC Region |  | WSCC
State |  | AZ
Fuel Type |  | Natural Gas
Capacity |  | 84 MW
Start Date |  | 2001-10-01 00:00:00
End Date |  | 2001-10-14 00:00:00
Comments |  | Minor Turbine O/H
SIC |  | 4911
Plant ID |  | 1015878
Unit ID |  | 1012476
Outage ID |  | 18488
Spreadsheet: 43884d1242513518-creating-a-list-from-across-sheets-683979
Sheet: LIST

1 | Data1 | A | A1 | 0 | 0
3 | Data1 | B | B1 | B2 | 0
5 | Data2 | C | C1 | 0 | 0
9 | Data2 | D | 0 | D2 | D3
14 | Data3 | E | E1 | 0 | 0
 | Data3 | F | F1 | 0 | 0
 | Data3 | G | [NAME] | 0 | 0
 | Data3 | H | 0 | H2 | H3
 | Data4 | I | 0 | 0 | I3
 | Data4 | J | J1 | 0 | 0
 | Data4 | K | K1 | 0 | K3
 | Data4 | L | L1 | L2 | L3
 | Data4 | M | 0 | M2 | 0
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | I need a formula(s) on each of the previous sheets (or on this sheet) that will result in this sheet.
 |  | [NAME] can be by cell or if using  a range then by rows.  I CANNOT use macros.
 |  | Each previous sheet has 6 data cell rows with cells that may or may not be empty.
 |  | The first cell in each of the rows that have any data at all will always have a value.
 |  | Empty rows will NEVER be before rows that contain data.  They'll always be last if there's any at all.
 |  | The cell ranges on the Data sheets will always be consistent across sheets(ie. they'll all be A1:D6)
 |  | There's no calculations done on any of the data sheets or on this sheet.  (At least, for the purspose of this problem)
 |  | The cell ranges on the Data sheets are only a part of their full sheet but the other information has no influence on this problem.
 |  | Assume the Data sheets are being done on a daily basis and the List sheet is the monthly tally if it helps.
 |  | The main purpose of this sheet is just to correlate the previous Data sheets into a coherent listing.
Spreadsheet: 691046d1597426424-at-wits-end-help-with-nested-if-statements-if-statement-help-try-1
Sheet: Call Log

First Name | Last Name | Phone | [NAME] | Overdue |  |  | # times called | Contact 1 Date | Contact 1 method | Contact 1 Topic | Responded | Contact 2 Date | Contact 2 method | Contact 2 Topic | Responded | Contact 3 Date | Contact 3 method | Contact 3 Topic | Responded | Contact 4 Date | Contact 4 method | Contact 4 Topic | Responded | Contact 5 Date | Contact 5 method | Contact 5 Topic | Responded | Contact 6 Date | Contact 6 method | Contact 6 Topic | Responded | Contact 7 Date | Contact 7 method | Contact 7 Topic | Responded | Notes
 |  |  |  |  | I tried to make it work |  | 1 | 2020-06-01 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00 |  |  |  | 2020-08-12 00:00:00
 |  |  |  |  | I only added AND statement |  | 1 | 2020-06-01 00:00:00
Spreadsheet: john_griffith__15665__1_Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.4 | 0.35 | 0.38 | 0.5048000000000001 | -0.01169999999999871
 | N | 4.45 | 0.63 | 0.68 | 0.5187000000000004 | -0.004799999999999471
 | Q | 4.5 | 0.85 | 0.9 | 0.5382999999999996 | 0.01244999999999863
 | U | 4.55 | 1.02 | 1.07 | 0.5356000000000005 | -0.003299999999999637
 | V | 4.55 | 1.17 | 1.23 | 0.5514000000000004 | 0.00389999999999957
 | X | 4.7 | 1.36 | 1.43 | 0.5636999999999994 | 0.01019999999999888
 | Z | 4.85 | 1.56 | 1.62 | 0.5757999999999995 | 0.009299999999998976
 | F | 4.9 | 1.7 | 1.76 | 0.5797999999999996 | 0.001499999999999835
 | G | 4.95 | 1.73 | 1.8 | 0.5579000000000014 | -0.01439999999999841
 | H | 4.55 | 1.58 | 1.65 | 0.5221999999999993 | -0.004799999999999471
 | J | 4.25 | 1.18 | 1.28 | 0.4063999999999998 | 0.001499999999999835
 | K | 4.2 | 1.11 | 1.21 | 0.3773 | -0.003599999999999604
 |  |  | 2001-05-11 09:29:11.680000