tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 229244d1366340462-copying-worksheets-issue-1234-my-house
Sheet: Fee Summary

 |  |  |  |  |  |  |  |  | Project Number
 |  |  |  |  |  |  | Exchange Rate
 |  |  |  |  |  |  | 8.034 | USD to MOP
 |  |  |  |  |  |  | 7.7756 | USD to HKD
 |  |  |  |  |  |  | 1.03 | HKD to MOP
 | ID - Interior Consultant Team |  | Firm Name | Proposal Date | HKD |  |  | Comments:
 | Interior Design
 | FFE Specification
 | Lighting Design ID
 | Renderings ID
 | On Site Supervision
 | Other: ID1
 | Other: ID2
 | Macau Tax Estimate
 |  |  | Interior Consultant Sub-total
 | LC - Lead Consultant Team |  |  | Proposal Date
 | Architecture
 | Interior Design Production
 | Structural Design
 | MEP Design
 | ELV Engineering
 | Fire Services Design
 | Fire Safety Engineering
 | Lighting Design LC
 | Acoustic Consultant
 | Traffic Design
 | Audio / Visual Consultant
 | [NAME]
 | Facade Consultant
 | Landscape
 | Renderings LC
 | Other: LC1
 | Other: LC2
 |  |  | Lead Consultant Sub-total
 | DC - Direct Consultants |  |  | Proposal Date
 | [NAME]
 | Signage and Graphics
 | Creative Consultant
 | Cost Planning / Review
 | Statutory Consultant
 | Other: DC1
 | Other: DC2
 |  |  | Direct Consultants Sub-total
 | RSS - Site Survey Team |  |  | Proposal Date
 | RSS Arch / ID (Lead Consultant)
 | RSS Structural
 | RSS MEP
 | 3rd Party Life Safety Checker
 | RSS Fire Safety
 | RSS Statutory Consultant
 | Other: SS1
 | Other: SS2
 |  |  | Site Survey Consultants Sub-total
 | Reimbursable Sums
 | Local reimbursables |  | 0.1
 | International reimbursables |  | 0.1
 |  |  | Total Reimbursable Sum
 |  |  |  | Estimated Grand Total
 | Notes:
Spreadsheet: 881259d1729254262-computing-an-average-with-multiple-criteria-book1-2-
Sheet: Sheet1

Year | Month | No leap | Leap |  |  | Average
1 | January | 2.29 | 2.29 |  | January
1 | February | 4.89 | 4.89 |  | February
1 | March | 3.05 | 3.41 |  | March
1 | April | 2.17 | 1.81 |  | April
1 | May | 3.41 | 3.41 |  | May
1 | June | 4.529999999999999 | 4.529999999999999 |  | June
1 | July | 3.63 | 3.92 |  | July
1 | August | 4.38 | 4.09 |  | August
1 | September | 4.7 | 4.7 |  | September
1 | October | 2.64 | 2.64 |  | October
1 | November | 3.56 | 3.56 |  | November
1 | December | 9.280000000000001 | 9.280000000000001 |  | December
2 | January | 2.55 | 2.55
2 | February | 5.210000000000001 | 5.440000000000001
2 | March | 5.62 | 5.39
2 | April | 8.229999999999999 | 10.3
2 | May | 7.529999999999999 | 5.460000000000001
2 | June | 3.26 | 3.26
2 | July | 6.93 | 6.93
2 | August | 0.74 | 0.74
2 | September | 8.16 | 8.16
2 | October | 1.22 | 1.35
2 | November | 1.73 | 1.6
2 | December | 7.14 | 7.14
3 | January | 6.02 | 6.02
3 | February | 7.739999999999999 | 7.739999999999999
3 | March | 2.36 | 2.36
3 | April | 2.13 | 2.13
3 | May | 13.02 | 14.65
3 | June | 7.649999999999999 | 6.720000000000001
3 | July | 7.639999999999999 | 7.84
3 | August | 2.17 | 1.27
3 | September | 5.869999999999999 | 5.869999999999999
3 | October | 1.17 | 1.33
3 | November | 3.400000000000001 | 3.240000000000001
3 | December | 3.54 | 3.54
4 | January | 3.91 | 3.91
4 | February | 4.149999999999999 | 4.629999999999999
4 | March | 5.619999999999999 | 5.819999999999999
4 | April | 4.54 | 3.86
4 | May | 2.51 | 2.51
4 | June | 2.75 | 2.75
4 | July | 4.36 | 4.36
4 | August | 4 | 4
4 | September | 4.069999999999999 | 4.39
4 | October | 3.23 | 2.91
4 | November | 1.44 | 1.44
4 | December | 1.59 | 1.68
5 | January | 8.75 | 8.75
5 | February | 6.05 | 6.05
5 | March | 3.21 | 3.21
5 | April | 6.049999999999999 | 6.049999999999999
5 | May | 2.72 | 3.04
5 | June | 5.02 | 4.7
5 | July | 4.91 | 5.04
5 | August | 4.26 | 4.13
5 | September | 4.609999999999999 | 4.609999999999999
5 | October | 2.3 | 2.3
5 | November | 3.64 | 3.79
5 | December | 3.22 | 3.37
6 | January | 2.7 | 2.7
6 | February | 2.66 | 3.6
6 | March | 6.259999999999999 | 5.319999999999999
6 | April | 3.31 | 3.31
6 | May | 7.38 | 7.38
6 | June | 4.13 | 4.13
6 | July | 6.65 | 6.82
6 | August | 3.62 | 3.45
6 | September | 3.75 | 3.75
6 | October | 3.26 | 3.26
6 | November | 1.07 | 1.36
6 | December | 6.54 | 6.26
7 | January | 0.52 | 0.52
7 | February | 7.27 | 7.51
7 | March | 4.27 | 4.029999999999999
7 | April | 3.57 | 3.57
7 | May | 0.49 | 0.49
7 | June | 1.96 | 1.96
7 | July | 5.79 | 5.79
7 | August | 3.37 | 3.37
7 | September | 4.25 | 4.25
7 | October | 3.36 | 3.8
7 | November | 3.92 | 4.94
7 | December | 5.36 | 3.9
8 | January | 4.39 | 4.39
8 | February | 2.82 | 3.2
8 | March | 7.740000000000001 | 7.600000000000001
8 | April | 3.98 | 3.74
8 | May | 2.38 | 2.38
8 | June | 3.54 | 4.05
8 | July | 3.04 | 2.529999999999999
8 | August | 4.279999999999999 | 4.279999999999999
8 | September | 3.52 | 3.52
8 | October | 1.56 | 1.56
8 | November | 3.07 | 3.87
8 | December | 8.549999999999999 | 7.749999999999999
Spreadsheet: 1d6ab074-5cb4-489b-9dd9-e7b608dd5117
Sheet: Sheet1

Unnamed: 0 | Schizophoria | Floweria | Leiopteria | Combined
# species | 18 | 14 | 14 | 46
mean species duration | 7.005 | 7.592 | 4.942 | 6.547
[NAME] (d) | 16.38 | 32.32 | 10.69 | 19.91
Δt | 38.8 | 38.8 | 38.8 | 38.8
R | 0.074 | 0.068 | 0.068 | 0.099
[NAME] (R) | 1.2e-07 | 1.49e-07 | 1.49e-07 | 4.9e-08
S | 0.217 | 0.2 | 0.27 | 0.251
σ (S) | 0.004 | 0.001 | 0.009 | 0.003
E | 0.143 | 0.132 | 0.202 | 0.153
[NAME] (E) | 0.004 | 0.001 | 0.009 | 0.003
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 1

Fixtures | Week 1 |  |  | 13th August |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Hull City |  | - |  | Leicester City |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
Burnley |  | - |  | Swansea City |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
Crystal Palace |  | - |  | West Brom |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Everton |  | - |  | Tottenham |  | 0 | 0 | 0 | 0 | 0 | 5 | 2 | 5 | 5 | 0 | 5 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0
Middlesbrough |  | - |  | Stoke City |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 0
Southampton |  | - |  | Watford |  | 2 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 2 | 0 | 5 | 0 | 0 | 0 | 5 | 0 | 5 | 0 | 0
Manchester City |  | - |  | Sunderland |  | 2 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2 | 5 | 2 | 2 | 2 | 2 | 2
Bournemouth |  | - |  | [NAME] |  | 2 | 2 | 2 | 5 | 0 | 2 | 2 | 2 | 2 | 2 | 5 | 2 | 2 | 2 | 0 | 2 | 2 | 2 | 2 | 2
Arsenal |  | - |  | Liverpool |  | 0 | 0 | 2 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Chelsea |  | - |  | West Ham |  | 0 | 5 | 2 | 0 | 0 | 5 | 0 | 0 | 0 | 2 | 5 | 2 | 0 | 5 | 5 | 5 | 2 | 0 | 2 | 5
 |  |  |  |  | Weekly Total
Home Team |  |  |  | Away Team
Hull City | 2 | - | 1 | Leicester City |  | 1-1 | 1-2 | 0-2 | 1-3 |  | 1-2 | 0-2 | 0-1 | 1-2 | 0-2 |  | 1-1 | 0-3 | 0-2 | 2-1 | 1-3 | 0-1 | 0-2 | 0-2 | 0-2
Burnley | 0 | - | 1 | Swansea City |  | 1-0 | 1-1 | 1-1 | 2-0 |  | 2-2 | 1-0 | 1-1 | 2-2 | 1-1 | 0-2 | 2-1 | 1-1 | 1-1 | 2-1 | 1-1 | 1-1 | 0-0 | 1-1 | 1-2
Crystal Palace | 0 | - | 1 | West Brom |  | 2-1 | 1-0 | 2-1 | 1-1 |  | 2-2 | 3-1 | 1-0 | 3-1 | 2-0 | 2-1 | 2-0 | 2-0 | 2-1 | 2-1 | 2-0 | 1-0 | 1-1 | 1-0 | 2-0
Everton | 1 | - | 1 | Tottenham |  | 2-1 | 1-2 | 1-2 | 2-1 |  | 1-1 | 2-2 | 1-1 | 1-1 | 1-0 | 1-1 | 1-2 | 2-1 | 1-0 | 2-1 | 1-1 | 1-2 | 1-2 | 0-1 | 0-2
Middlesbrough | 1 | - | 1 | Stoke City |  | 1-0 | 0-1 | 2-2 | 3-1 |  | 1-2 | 2-0 | 1-1 | 1-0 | 2-1 | 1-2 | 0-0 | 2-1 | 0-0 | 2-1 | 0-1 | 1-0 | 0-2 | 1-1 | 0-1
Southampton | 1 | - | 1 | Watford |  | 0-0 | 2-0 | 2-0 | 1-0 |  | 3-1 | 0-0 | 2-1 | 3-0 | 2-2 | 2-1 | 1-1 | 3-1 | 2-0 | 2-1 | 1-1 | 2-1 | 1-1 | 3-1 | 2-1
Manchester City | 2 | - | 1 | Sunderland |  | 2-0 | 3-1 | 3-0 | 4-1 |  | 2-0 | 4-0 | 2-0 | 1-2 | 3-0 | 3-1 | 3-1 | 4-0 | 4-0 | 2-1 | 3-0 | 3-0 | 2-0 | 4-0 | 3-0
Bournemouth | 1 | - | 3 | [NAME] |  | 1-2 | 1-2 | 1-2 | 1-3 |  | 1-2 | 0-1 | 0-1 | 2-3 | 0-2 | 1-3 | 1-2 | 1-2 | 0-1 | 2-1 | 1-2 | 1-2 | 0-2 | 0-3 | 0-3
Arsenal | 3 | - | 4 | Liverpool |  | 2-1 | 2-0 | 1-2 | 2-2 |  | 1-1 | 0-1 | 1-1 | 3-1 | 2-1 | 2-2 | 2-1 | 2-1 | 2-2 | 2-1 | 2-2 | 1-1 | 2-1 | 1-1 | 2-1
Chelsea | 2 | - | 1 | West Ham |  | 1-1 | 2-1 | 1-0 | 1-2 |  | 2-1 | 0-2 | 1-1 | 2-2 | 3-2 | 2-1 | 2-0 | 2-2 | 2-1 | 2-1 | 2-1 | 1-0 | 1-1 | 2-0 | 2-1
Spreadsheet: 799340d1665052768-error-while-splitting-date-and-time-temp1
Sheet: TEMP

DATE & TIME, | DATE | TIME
2022-01-09 11:26:37
2022-01-09 11:28:02
2022-01-09 12:20:19
2022-01-09 12:20:55
2022-01-09 14:01:31
2022-02-09 10:50:49
2022-02-09 10:52:19
2022-02-09 11:49:31
2022-02-09 11:52:45
2022-02-09 12:10:40
2022-02-09 13:54:26
2022-02-09 13:55:31
2022-02-09 13:56:25
2022-03-09 11:36:55
2022-03-09 12:11:41
2022-03-09 12:42:41
2022-03-09 14:01:05
2022-03-09 15:18:41
2022-03-09 15:19:48
2022-03-09 15:20:44
2022-03-09 16:02:55
2022-05-09 13:15:39
2022-05-09 13:38:40
2022-05-09 15:30:23
2022-05-09 15:32:02
2022-05-09 16:04:34
2022-07-09 13:10:30
2022-07-09 14:04:10
2022-07-09 14:05:41
2022-12-09 13:53:08
2022-12-09 13:53:57
2022-12-09 13:54:45
2022-12-09 13:55:23
13/09/2022 10:43:48
13/09/2022 11:32:26
13/09/2022 11:47:19
13/09/2022 11:48:00
13/09/2022 12:41:12
13/09/2022 12:42:14
13/09/2022 13:05:19
13/09/2022 15:45:56
14/09/2022 11:19:52
14/09/2022 12:17:35
14/09/2022 12:19:47
14/09/2022 12:24:12
14/09/2022 [NAME]
14/09/2022 13:41:16
14/09/2022 14:02:35
15/09/2022 11:46:04
15/09/2022 11:48:16
15/09/2022 12:26:13
15/09/2022 15:53:43
15/09/2022 16:40:30
15/09/2022 16:49:21
15/09/2022 17:18:31
15/09/2022 18:00:30
15/09/2022 19:37:33
16/09/2022 [NAME]
16/09/2022 12:25:42
16/09/2022 12:58:16
16/09/2022 13:43:40
16/09/2022 13:51:37
16/09/2022 14:49:37
16/09/2022 15:13:39
16/09/2022 16:35:31
17/09/2022 11:10:11
17/09/2022 11:54:28
17/09/2022 11:55:19
17/09/2022 12:25:02
17/09/2022 12:26:02
17/09/2022 12:32:26
17/09/2022 13:00:38
17/09/2022 15:17:30
19/09/2022 10:57:23
19/09/2022 11:51:38
19/09/2022 12:50:51
19/09/2022 12:51:50
19/09/2022 12:53:15
19/09/2022 14:08:52
19/09/2022 14:09:36
19/09/2022 15:40:13
19/09/2022 15:41:24
19/09/2022 16:28:27
19/09/2022 17:02:05
19/09/2022 17:02:46
20/09/2022 11:19:18
20/09/2022 11:59:07
20/09/2022 11:59:51
20/09/2022 12:33:13
20/09/2022 12:33:57
20/09/2022 13:31:29
20/09/2022 16:12:24
20/09/2022 16:24:26
20/09/2022 16:25:00
20/09/2022 16:26:17
20/09/2022 17:02:10
21/09/2022 11:44:20
21/09/2022 11:44:54
21/09/2022 12:42:18
21/09/2022 12:44:09
21/09/2022 13:15:44
21/09/2022 13:16:40
21/09/2022 14:04:42
22/09/2022 12:15:34
22/09/2022 12:43:41
22/09/2022 12:52:31
22/09/2022 13:03:59
22/09/2022 13:08:40
22/09/2022 14:37:55
22/09/2022 14:38:50
22/09/2022 14:39:28
22/09/2022 15:27:00
22/09/2022 15:36:34
22/09/2022 16:00:12
24/09/2022 13:05:55
24/09/2022 13:37:28
24/09/2022 13:38:07
24/09/2022 14:45:18
26/09/2022 10:46:59
26/09/2022 10:47:56
26/09/2022 11:35:53
26/09/2022 11:38:09
26/09/2022 12:24:47
26/09/2022 12:26:27
26/09/2022 14:57:54
27/09/2022 10:49:46
27/09/2022 11:55:15
27/09/2022 11:56:48
27/09/2022 12:13:19
27/09/2022 13:08:28
27/09/2022 13:09:13
27/09/2022 15:13:49
27/09/2022 15:54:44
27/09/2022 15:56:27
27/09/2022 16:04:25
27/09/2022 16:41:17
27/09/2022 16:41:51
27/09/2022 17:15:23
28/09/2022 11:30:20
28/09/2022 11:34:53
28/09/2022 12:12:28
28/09/2022 12:13:09
28/09/2022 12:13:43
28/09/2022 12:14:44
28/09/2022 13:06:15
28/09/2022 13:07:39
28/09/2022 14:02:10
28/09/2022 14:04:41
Spreadsheet: 881238d1729198919-date-formula-to-populate-column-headers-jimbo79-date-formula-tms
Sheet: Sheet1

 | Desired Outcome | 2024-01-31 00:00:00 |  |  | 2024-Q1 |  |  |  | 2024-Q2 |  |  |  | 2024-Q3 |  |  |  | 2024-Q4 | 2024-FY |  |  |  | 2025-Q1 |  |  |  | 2025-Q2 |  |  |  | 2025-Q3 |  |  |  | 2025-Q4 | 2025-FY |  |  |  | 2026-Q1 |  |  |  | 2026-Q2 |  |  |  | 2026-Q3 |  |  |  | 2026-Q4 | 2026-FY
 | [NAME] | 2024-01-31 00:00:00
 |  |  | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-Q1 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-Q2 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-Q3 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2024-Q4 | 2024-FY
Spreadsheet: 853092d1703042616-count-lines-in-a-cell-and-in-an-column-using-scan-function-using-reduce-function
Sheet: Planilha2

A | 100 |  |  | 100 |  |  | 100 |  |  | 100
A | 200 |  | A | 200 |  | A | 200 |  | A | 200
A | 300 |  | A | 300 |  | A | 300 |  | A | 300
A | 400 |  | A | 400 |  | A | 400 |  | A | 400
A | 500 |  | A | 500 |  | A | 500 |  | A | 500
A | 600 |  | A | 600 |  | A | 600 |  | A | 600
A | 700 |  | A | 700 |  | A | 700 |  | A | 700
A | 800 |  | A | 800 |  | A | 800 |  | A | 800
B | 300 |  | B | 300 |  | B | 300 |  | B | 300
B | 400 |  | B | 400 |  | B | 400 |  | B | 400
B | 500 |  | B | 500 |  | B | 500 |  | B | 500
B | 600 |  | B | 600 |  | B | 600 |  | B | 600
C | 710 |  | C | 710 |  | C | 710 |  | C | 710
C | 730 |  | C | 730 |  | C | 730 |  | C | 730
C | 740 |  | C | 740 |  | C | 740 |  | C | 740
D | 250 |  | D | 250 |  | D | 250 |  | D | 250
E |  |  | E |  |  | E |  |  | E
F | 231 |  | F | 231 |  | F | 231 |  | F | 231
F | 232 |  | F | 232 |  | F | 232 |  | F | 232
G | 233 |  | G | 233 |  | G | 233 |  | G | 233
G | 234 |  | G | 234 |  | G | 234 |  | G | 234
H | 511 |  | H | 511 |  | H | 511 |  | H | 511
H | 520 |  | H | 520 |  | H | 520 |  | H | 520
H | 611 |  | H | 611 |  | H | 611 |  | H | 611
H | 620 |  | H | 620 |  | H | 620 |  | H | 620
I | 334 |  | I | 334 |  | I | 334 |  | I | 334
I | 344 |  | I | 344 |  | I | 344 |  | I | 344
J | 321 |  | J | 321 |  | J | 321 |  | J | 321
Spreadsheet: 546085d1509847701-having-issue-with-drop-down-that-can-retreive-data-data-validation-punch-in-punch-out
Sheet: whats desired

drop down to choose date |  |  | drop down to choose emplpyee
all data as It relates to that employee appears as such after drop down chosen
date | Name | Duration | Punch in | Punch out
2017-10-23 00:00:00 | [NAME] | 00:06:00 | 10:00:00 | 10:06:00
2017-10-23 00:00:00 | [NAME] | 00:21:00 | 11:00:00 | 11:21:00
2017-10-23 00:00:00 | [NAME] | 00:15:00 | 13:16:00 | 13:31:00
2017-10-23 00:00:00 | [NAME] | 00:16:00 | 16:00:00 | 16:16:00
Spreadsheet: eric_saibi__9700__010302R
Sheet: Colbert 05

Owner Name |  | TVA
Station Name |  | Colbert Power Station
Unit Name |  | Colbert 05
NERC Region |  | SERC
State |  | AL
Fuel Type |  | Coal
Capacity |  | 550 MW
Start Date |  | 2002-01-17 00:00:00
End Date |  | 2002-02-27 00:00:00
Prv. Start Date |  | 2002-01-05 00:00:00
Prv. End Date |  | 2002-02-15 00:00:00
Comments |  | Major [NAME], boiler work
SIC |  | 4911
Plant ID |  | 1018346
Unit ID |  | 1003699
Outage ID |  | 19191
Spreadsheet: 465958d1465950656-organizing-data-for-analysis-sample
Sheet: Sheet1

State | Impact | Impact type | Description | Jobs | Wages | Output | Taxes
Alabama | Economic | Direct Economic Impact | RV Manufacturers & Suppliers | 924 | 49975600 | 377244700
Alabama | Economic | Direct Economic Impact | RV Sales & Service | 535 | 27190700 | 55687900
Alabama | Economic | Indirect impact | Agriculture | 30 | 1771800 | 3567400
Alabama | Economic | Indirect impact | Mining | 8 | 848200 | 2882100
Alabama | Economic | Induced Economic Impact | Agriculture | 24 | 472800 | 1839800
Alabama | Economic | Induced Economic Impact | Mining | 3 | 264100 | 1575100
Alabama | Tax | Tax Impact | Federal Taxes |  |  |  | 39474700
Alabama | Tax | Tax Impact | State Taxes |  |  |  | 28774600
Spreadsheet: 456712d1461005124-help-with-countif-formula-alarm-count
Sheet: Sheet1

Area | Alarms | M F
B2 | 1 | 1 | B1 | 1 alarm | 2 alarms | 3 alarms | 4 alarms | > 4 Alarms
B3 | 1 | 0
DMT | 1 | 2 | 0 M F | 1 M F | 2 M F | 3 M F | 4 M F | > 4 M F
B2 | 1 | 4
B2 | 2 | 3
B3 | 1 | 0 | B2 | 1 alarm | 2 alarms | 3 alarms | 4 alarms | > 4 Alarms
B1 | 1 | 0
DMT | 1 | 3 | 0 M F | 1 M F | 2 M F | 3 M F | 4 M F | > 4 M F
Spreadsheet: 36198d1233958585-sumif-with-criteria-sample-upload-2
Sheet: Data Sum

Day | Date | Name | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00
 | 07/21²08 | [NAME] | 1 | 1 | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | 07/22²08 | [NAME] | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3
 | 07/23²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07/24²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07/25²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07/26²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07/27²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07/28²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07/29²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 07/30²08 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 40874d1239270867-need-combine-formula-which-reduce-the-no-of-additoanl-formulas-columns-student-marks
Sheet: Work

 |  |  |  |  |  | Can we remove these column ???
 |  |  |  |  |  | THESE COLUMN WILL BE HIDDEN
 |  |  |  |  |  | No. of Failed
Students Name | Eng | Math | Phy | Chem | Bio | Subjects | E | M | Ph | Ch | Bi | Remarks
[NAME] | 45 | 10 | 39 | 12 | 50 | 3 |  | M | Ph | Ch |  | M Ph Ch | Need this formula to improve
Maria | 40 | 45 | 45 | 54 | 39 | 1 |  |  |  |  | Bi | Bi
Janny | 55 | 45 | 35 | 48 | 55 | 1 |  |  | Ph |  |  | Ph
Gaughan | 69 | 79 | 79 | 23 | 69 | 1 |  |  |  | Ch |  | Ch
Madona | 85 | 88 | 88 | 88 | 85 | 0 |  |  |  |  |  | Pass
[NAME] | 52 | 99 | 99 | 86 | 52 | 0 |  |  |  |  |  | Pass
 |  | I have some student marks in columns B to F.  If some one get below 40 marks he fails and the subject in which he has been failed will come in [NAME] column.  If he has passed in all subjects remarks column will show Pass.   To bring failed subject initial in [NAME] i have to creat 5 additional column and then thru [NAME] i joined them. Is There any formula to show fail subject in [NAME] column without creating 5 additional columns????
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: JuneMossBluff

 | ENRON NORTH AMERICA MOSS BLUFF STORAGE
[NAME] |  |  |  | NOTE:  1.5% FUEL CHARGED GOING INTO MOSS BLUFF (Injection)
 | NGPL |  |  | CHANNEL (EL PASO) |  |  | HOUSTON PIPELINE (HPL) |  |  | [NAME] (UTTCO) |  |  | TEJAS GAS |  |  | TETCO
 | Inj net fuel | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl |  | Injection | Withdrawl
2000-06-01 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-02 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-03 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-04 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-05 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-06 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-07 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-08 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-09 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-10 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-11 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-12 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-13 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-14 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-15 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-16 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-17 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-18 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-19 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-20 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-21 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-22 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-23 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-24 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-25 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-26 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-27 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-28 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-29 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
2000-06-30 00:00:00 | 0
Total Inj/Withdrawl
Net Inj/WithD per Pipe
Ending Balance
Spreadsheet: 092e8147-cab5-402e-aebb-6db47d07ef77
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Belknap County Offices - Republican
2012-09-11 00:00:00 | Sheriff |  |  | Attorney |  |  | Treasurer
 | Wiggin, r |  | [NAME] | [NAME], r |  | [NAME] | Muzzey, r |  | [NAME]
Alton | 729 |  |  | 751 |  | 1 | 708
Barnstead | 402 |  | 3 | 389 |  |  | 390 |  | 1
Belmont | 525 |  | 9 | 491 |  | 2 | 508 |  | 3
Center Harbor | 154 |  |  | 148 |  |  | 150
Gilford | 955 |  | 8 | 898 |  | 5 | 919 |  | 3
Gilmanton | 385 |  | 2 | 367 |  |  | 375 |  | 2
[NAME] | 265 |  |  | 251 |  |  | 253
[NAME] | 200 |  |  | 185 |  |  | 193
[NAME] 3 | 274 |  | 1 | 262 |  | 1 | 270
[NAME] | 205 |  | 1 | 195 |  |  | 196
[NAME] | 133 |  | 1 | 124 |  |  | 131
[NAME] 6 | 306 |  | 4 | 288 |  | 3 | 307 |  | 2
Meredith | 748 |  | 6 | 703 |  | 1 | 714 |  | 1
New Hampton | 223 |  |  | 217 |  | 1 | 220
Sanbornton | 289 |  |  | 265 |  |  | 268
[NAME] | 255 |  | 4 | 249 |  | 2 | 253
TOTALS | 6048 |  | 39 | 5783 |  | 16 | 5855 |  | 12
 | Reg. of Deeds |  |  |  |  | Reg. Of Probate
 | Luther, r | Ahlgren, d | [NAME] |  |  | Brickner, r | Shartar-Howe, d | [NAME]
Alton | 724 |  | 1 |  |  | 718 | 1
Barnstead | 399 |  |  |  |  | 408
Belmont | 520 |  | 2 |  |  | 503 |  | 2
Center Harbor | 153 |  |  |  |  | 150
Gilford | 953 |  | 1 |  |  | 933 | 1
Gilmanton | 375 |  | 1 |  |  | 371
[NAME] | 262 | 1 |  |  |  | 250 | 1
[NAME] | 204 |  |  |  |  | 196
[NAME] 3 | 274 |  |  |  |  | 268
[NAME] | 202 |  |  |  |  | 196 |  | 1
[NAME] | 135 |  |  |  |  | 132
[NAME] 6 | 309 |  | 1 |  |  | 302 |  | 1
Meredith | 729 |  |  |  |  | 722 |  | 1
New Hampton | 221 |  |  |  |  | 219
Sanbornton | 278 |  |  |  |  | 275
[NAME] | 262 |  |  |  |  | 264
TOTALS | 6000 | 1 | 6 |  |  | 5907 | 3 | 5
 | County Commissioners
 | District 1 |  |  | District  2 |  | District 3
 | [NAME], r | Philpot, d | [NAME] | NO ELECTION |  | Nedeau, r |  | [NAME]
Alton |  |  |  |  |  | 714 |  | 1
Barnstead
Belmont
Center Harbor |  |  |  |  |  | 150 |  | 1
Gilford |  |  |  |  |  | 929 |  | 3
Gilmanton
[NAME] | 234
[NAME] | 184 |  | 1
[NAME] 3 | 252 | 3
[NAME] | 184 | 1
[NAME] | 129 |  | 1
[NAME] 6 | 289 | 12 | 1
Meredith |  |  |  |  |  | 742 |  | 3
New Hampton | 215 |  | 1
Sanbornton | 273 | 1
[NAME]
TOTALS | 1760 | 17 | 4 |  |  | 2535 |  | 8