tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 465104d1465460921-sorting-a-value-depending-on-column-name-example1
Sheet: Sheet3

 | Date | 2016-06-20 00:00:00 | 2016-06-21 00:00:00 | 2016-06-22 00:00:00 | 2016-06-23 00:00:00 | 2016-06-24 00:00:00 | 2016-06-25 00:00:00 | 2016-01-26 00:00:00 | 2016-06-27 00:00:00 | 2016-06-28 00:00:00 | 2016-06-29 00:00:00 | 2016-06-30 00:00:00 | 2016-07-01 00:00:00 | 2016-07-02 00:00:00 | 2016-07-03 00:00:00 | 2016-07-04 00:00:00 | 2016-07-05 00:00:00 | 2016-07-06 00:00:00 | 2016-07-07 00:00:00
 | a |  | 25 |  | 32 |  |  |  | 40 |  |  |  |  |  |  |  | 60
 | b |  |  | 17 |  | 33 |  |  |  | 46 |  |  |  |  |  |  | 64
 | c | 40 |  |  | 33 |  |  | 51 |  |  |  |  |  |  |  |  | 55
 | d |  |  | 19 |  | 46 |  |  |  | 55 |  |  |  |  |  |  |  | 47
 | e |  | 25 |  | 35 |  |  |  | n/a |  |  |  |  |  |  |  |  | 49
 | f |  | 33 |  | 36 |  |  |  | 36 |  |  |  |  |  |  |  |  | 53
 | g |  |  | 34 |  | 40 |  |  |  | 44 |  |  |  |  |  |  |  |  | 60
 | h | 18 |  |  | 19 |  |  | 27 |  |  |  |  |  |  |  |  |  |  | 38
[NAME] in Excel
Manually set up
 |  | 1 | 2 | 3 | 4
 | a | 2016-06-21 00:00:00 | 2016-06-23 00:00:00 | 2016-06-27 00:00:00 | 2016-07-05 00:00:00
 | b | 2016-06-22 00:00:00 | 2016-06-24 00:00:00 | 2016-06-28 00:00:00 | 2016-07-05 00:00:00
 | c | 2016-06-20 00:00:00 | 2016-06-23 00:00:00 | 2016-06-26 00:00:00 | 2016-07-05 00:00:00
 | d | 2016-06-22 00:00:00 | 2016-06-24 00:00:00 | 2016-06-28 00:00:00 | 2016-07-06 00:00:00
 | e | 2016-06-21 00:00:00 | 2016-06-23 00:00:00 | 2016-06-27 00:00:00 | 2016-07-06 00:00:00
 | f | 2016-06-21 00:00:00 | 2016-06-23 00:00:00 | 2016-06-27 00:00:00 | 2016-07-06 00:00:00
 | g | 2016-06-22 00:00:00 | 2016-06-24 00:00:00 | 2016-06-28 00:00:00 | 2016-07-07 00:00:00
 | h | 2016-06-20 00:00:00 | 2016-06-23 00:00:00 | 2016-06-26 00:00:00 | 2016-07-07 00:00:00
Can a function be used to fill in this chart so it looks like this ? |  |  |  |  |  |  | Therefore the Date in row 1 is matched with the date in cell c17 and then the figure alongside 'a' is placed in cell 'C30'
 |  |  |  |  |  |  | and so on
 |  | 1 | 2 | 3 | 4
 | a | 25 | 32 | 40 | 60
 | b | 17 | 33 | 46 | 64
 | c | 40 | 33 | 51 | 55
 | d | 19 | 46 | 55 | 47
 | e | 25 | 35 | n/a | 49
 | f | 33 | 36 | 36 | 53
 | g | 34 | 40 | 44 | 60
 | h | 18 | 19 | 27 | 38
Spreadsheet: 0c958d78-0586-49da-a2f3-4f62f77466e6
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0029945 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Onslow | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 50060 | 31616 | 00610 | 00620 | 00600 | 00400 | 00665 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | Total Nitrogen | pH | Total Phosphorus | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | mg/L | su | mg/L | mg/L | mg/L | NTU
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: |  |  | Recorder | Composite | Grab | Composite | Grab | Grab | Composite | Composite | Composite | Grab | Composite | Composite | Composite | Recorder
Monthly Limit: |  |  | 400000 | 10 |  |  |  | 14 | 4 |  | 10 |  | 2 |  | 5
Daily Limit: |  |  |  | 15 |  |  |  | 25 | 6 |  |  | 6-9 |  |  | 10 | 10
Sample Frequency: |  |  | [NAME] | 2 x Week | 3 x Year | 3 x Year | 5 x Week | 2 x Week | 2 x Week | 2 x Week | 2 x Week | 5 x Week | 2 x Week | 3 x Year | 2 x Week | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 867320d1714141863-help-with-if-formula-over-multiple-columns-task-tracker
Sheet: Sheet1

L0 | l1 | L2 | L3
TE1 | TE2 | EE1 | EE2
P0 | P1 | P2 | P3
Task tracker |  | Task1 | [NAME] | Task3 | Task4
Operative Name | L Code
 | E Code
 | P code
[NAME] |  |  | L2 | L3
 |  | TE1 |  |  | TE2
Operative 1
 |  | ee2 |  | ee1
 |  | p3 | p0
Spreadsheet: 55452d1255557761-help-nesting-indirect-references-into-formulas-indirect-help
Sheet: Workbook 2

 | Big Database Table
 | $B$4
 | 1 | 2 | 3 | 4 | 5
 | 6 | 7 | 8 | 9 | 10
 | 11 | 12 | 13 | 14 | 15
 | 16 | 17 | 18 | 19 | 20
 |  |  |  |  | $F$9
 | Total
 | 210
Spreadsheet: 104942d1302404138-copy-data-contained-in-several-columns-into-a-new-column-movems2end
Sheet: example

Number 1 | Number 5 | Number 6 | Number 7 | Number 8 | Number 9 | new column
2 | text | sample | number | 1 | MS22
3 | text | sample | number | 2 | MS22
4 | text | sample | number | MS21 | text
5 | text | sample | number | MS21 | text
6 | text | sample | number | MS18 | text
7 | text | sample | number | MS18 | text
8 | text | sample | MS07 | 1 | text
9 | text | sample | MS07 | 2 | text
10 | MS09 | sample | number | 3 | text
11 | MS10 | sample | number | 4 | text
Spreadsheet: 785747d1656673552-i-want-to-return-multiple-values-against-a-series-of-values-sample-for-forum
Sheet: Data

Identification Digit | Lender | Calculations |  |  |  | Identification Digit | Lender1 | Lender3 | Column3 | Lender4
1 | ABC | 5 |  |  |  | 1 | ABC | BBC | CBC
1 | BBC | 7 |  |  |  | 2 | ABC
1 | CBC | 1 |  |  |  | 3 | BBC | CBC | ABC | DBC
2 | ABC | 3 |  |  |  | 4 | ABC | DEF
3 | BBC | 15 |  |  |  | 5 | GHI | JKL | MNO
3 | CBC | 12 |  |  |  | 6 | PQR
3 | ABC | 1 |  |  |  | 7 | STU
3 | DBC | 4
4 | ABC | 5
4 | DEF | 7
5 | GHI | 1
5 | JKL | 4
5 | MNO | 5
6 | PQR | 7
7 | STU | 2
Spreadsheet: 268479d1380651290-finding-total-for-individuals-by-monthly-tab-and-unit-counts-bsr-teams-2013
Sheet: Mar

Daily Locked & Funded Loans AS 03/29/2013
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded
[NAME] | - | $4,352,170 (15) | - | $11,618,000 (39)
[NAME] | $870,000 (1) | $8,815,300 (26) | $927,000 (3) | $10,817,050 (36)
[NAME] | - | $7,039,650 (23) | - | $8,218,025 (26)
[NAME] | - | $7,468,007 (23) | $1,096,930 (3) | $7,475,444 (24)
[NAME] | $580,000 (1) | $17,313,600 (46) | $593,000 (2) | $12,620,548 (40)
[NAME] | $213,750 (1) | $10,607,150 (30) | - | $8,695,350 (24)
[NAME] | $366,250 (2) | $14,457,475 (56) | $370,000 (1) | $23,427,348 (78)
[NAME] | - | $11,119,700 (39) | - | $13,427,090 (39)
[NAME] | - | $50,129,200 (148) | $836,500 (2) | $45,322,350 (129)
[NAME] | $400,000 (1) | $15,627,209 (42) | $669,000 (3) | $10,046,000 (26)
Kathi Yelland | - | $305,000 (2) | - | $392,000 (2)
Kris Varia | - | $6,507,500 (21) | $160,000 (1) | $4,378,600 (12)
[NAME] | $190,000 (1) | $10,914,950 (34) | $592,500 (3) | $11,353,000 (42)
[NAME] | - | $12,113,750 (31) | - | $17,489,250 (44)
[NAME] | - | $9,386,400 (25) | $553,900 (2) | $12,466,700 (40)
[NAME] | - | $9,741,274 (29) | - | $6,587,887 (19)
Subtotal | $2,620,000 (7) | $195,898,335 (590) | $5,798,830 (20) | $204,334,642 (620)
Daily HomeLending / Alan Locked & Funded Loans AS 03/29/2013
Account Executive | Daily Locked | Active Locked | Daily Funded | MTD Funded
[NAME] | - | - | - | $2,130,000 (5)
Subtotal | - | - | - | $2,130,000 (5)
Daily Locked & Funded Loans AS 03/29/2013
 | Daily Locked | Active Locked | Daily Funded | MTD Funded
Total | $2,620,000 (7) | $195,898,335 (590) | $5,798,830 (20) | $206,464,642 (625)
Spreadsheet: b8216b98-d54e-4b07-a3d9-cfcab2f047d6
Sheet: Sheet1

Grand Rapids 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
2014-04-25 | 1 | Grand Rapids | 2 | [NAME] | 1 | Final OT | Abbotsford Entertainment & Sports Centre Abbotsford, BC
2014-04-26 | 2 | Grand Rapids | 7 | [NAME] | 2 | Final | Abbotsford Entertainment & Sports Centre Abbotsford, BC
2014-04-30 | 3 | [NAME] | 2 | Grand Rapids | 1 | Final | [NAME] Arena Grand Rapids, MI
2014-05-02 | 4 | [NAME] | 3 | Grand Rapids | 5 | Final | [NAME] Arena Grand Rapids, MI
2014-05-08 | 1 | Grand Rapids | 2 | Texas | 5 | Final | Cedar Park Center Cedar Park, TX
2014-05-10 | 2 | Grand Rapids | 0 | Texas | 4 | Final | Cedar Park Center Cedar Park, TX
2014-05-13 | 3 | Texas | 2 | Grand Rapids | 5 | Final | [NAME] Arena Grand Rapids, MI
2014-05-14 | 4 | Texas | 2 | Grand Rapids | 3 | Final | [NAME] Arena Grand Rapids, MI
2014-05-16 | 5 | Texas | 3 | Grand Rapids | 2 | Final OT | [NAME] Arena Grand Rapids, MI
2014-05-18 | 6 | Grand Rapids | 1 | Texas | 7 | Final | Cedar Park Center Cedar Park, TX
Spreadsheet: andy_zipper__302__NYMEX NG Straddle email
Sheet: Sheet1

H | 210 | 24 | 24.5
J | 215 | 33 | 33.5
K | 225 | 38.5 | 40.5
M | 230 | 43.5 | 45.5
N | 235 | 50 | 52
Q | 240 | 57 | 60
U | 240 | 62 | 64
V | 245 | 68 | 70
X | 265 | 78 | 80.5
Z | 285 | 89 | 92
F | 295 | 98 | 100
G | 290 | 99 | 100.5
H03 | 285 | 94 | 98
M03 | 280 | 84 | 88.5
 | Alternate [NAME]
H | 2.1 | 0.24 | 0.245
J | 2.15 | 0.33 | 0.335
K | 2.25 | 0.385 | 0.405
M | 2.3 | 0.435 | 0.455
N | 2.35 | 0.5 | 0.52
Q | 2.4 | 0.57 | 0.6
U | 2.4 | 0.62 | 0.64
V | 2.45 | 0.68 | 0.7
X | 2.65 | 0.78 | 0.805
Z | 2.85 | 0.89 | 0.92
F | 2.95 | 0.98 | 1
G | 2.9 | 0.99 | 1.005
H03 | 2.85 | 0.94 | 0.98
M03 | 2.8 | 0.84 | 0.885
Spreadsheet: thomas_martin__39870__ubs Jan 28
Sheet: East Trading & Origination

 | LEGEND
 | Cash | CSH |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 | Funamentals | FUN |  |  |  |  |  |  |  | East Trading | Staff |  | East Origination | Staff |  |  |  |  | Total Staff
 | [NAME] | FIT |  |  |  |  |  |  |  | [NAME] |  | 1 | M.D.
 | Options | OPT |  |  |  |  |  |  |  | TJ Black |  | 1 | [NAME] |  | 1
 | Origination | ORG |  |  |  |  |  |  |  | Co-ordinator |  |  | Co-ordinator
 | Physical | PHY
 | Projects | PR |  |  |  |  |  |  |  | Claudia Guerra |  | 1 | [NAME] |  | 1
 | Scheduling | SCH |  |  |  |  |  |  |  | Assistant |  |  | Assistant
 | Structuring | STR
 | Term | TRM
 | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 | Mid West | Staff |  | North East | Staff |  | South East | Staff |  | [NAME] | Staff |  | Options | Staff |  | Fund & Projects | Staff |  | East Origination | Staff |  | Structuring | Staff
 | [NAME] |  | 1 | [NAME] |  | 1 | [NAME] |  | 1 | Dir |  | 1 | [NAME] |  | 1 | Dir |  | 1 | M.D. |  | 1 | Dir |  | 1
 |  |  |  | [NAME] | TRM | 1 | [NAME] | TRM | 1 | [NAME] | TRM | 1 | [NAME] | OPT | 1 | [NAME] | PR | 1 | [NAME] | ORG | 1 | [NAME] | STR | 1
 |  |  |  | [NAME] | TRM | 1 |  |  |  |  |  |  | [NAME] | OPT | 1 |  |  |  | [NAME] | ORG | 1 | [NAME] | STR | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | OPT | 1 |  |  |  | [NAME] | ORG | 1
 | [NAME] | CSH |  | Narsimha Misra | CSH | 1 | [NAME] | CSH | 1 | [NAME] | CSH | 1 | [NAME] | OPT | 1 | [NAME] | SCH | 1 | [NAME] | ORG | 1
 | [NAME] | CSH |  | [NAME] | CSH | 1 | [NAME] | CSH | 1 | [NAME] | CSH | 1 |  |  |  |  |  |  | [NAME] | ORG | 1
 |  |  |  | [NAME] | CSH | 1 |  |  |  |  |  |  |  |  |  | [NAME] | FUN | 1 | [NAME] | ORG | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FUN | 1 | [NAME] | ORG | 1
 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 |  |  |  | Moises Benchluch | FUN | 1 | [NAME] | ORG | 1
 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 |  |  |  | [NAME] | FUN | 1 | Edith Cross | ORG | 1
 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] Seely | PHY | 1 | [NAME] | PHY | 1 |  |  |  | [NAME] | FUN | 1 | [NAME] | ORG | 1
 | Punit Rawal | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 |  |  |  | [NAME] | FUN | 1 | [NAME] | ORG | 1
 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 | [NAME] | PHY | 1 |  |  |  | Gulay [NAME] | FUN | 1 | [NAME] | ORG | 1
 |  |  |  | [NAME] | PHY | 1 | [NAME] | PHY | 1 |  |  |  |  |  |  |  |  |  | [NAME] | ORG | 1
 | [NAME] | SCH | 1 | [NAME] | SCH | 1 | [NAME] | SCH | 1 | Smith Day | SCH | 1
 | [NAME] | SCH | 1 | [NAME] | SCH | 1 |  |  |  |  |  |  |  |  |  | [NAME] | FIT | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FIT | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FIT | 1
 |  |  |  | [NAME] | FUN | 1 | Gustavo Giron | FUN | 1 | [NAME] | FUN | 1 |  |  |  | [NAME] | FIT | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | FIT | 1
 | Date Printed
Spreadsheet: lisa_gang__22319__ENA_PGE_JUNE_13_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-13 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 50 | 25 | 25
0800 | 25 | 25 | 50 | 25 | 25
0900 | 25 | 25 | 50 | 25 | 25
1000 | 25 | 25 | 50 | 25 | 25
1100 | 25 | 25 | 50 | 25 | 25
1200 | 25 | 25 | 50 | 25 | 25
1300 | 25 | 25 | 50 | 25 | 25
1400 | 25 | 25 | 50 | 25 | 25
1500 | 25 | 25 | 50 | 25 | 25
1600 | 25 | 25 | 50 | 25 | 25
1700 | 25 | 25 | 50 | 25 | 25
1800 | 25 | 25 | 50 | 25 | 25
1900 | 25 | 25 | 50 | 25 | 25
2000 | 25 | 25 | 50 | 25 | 25
2100 | 25 | 25 | 50 | 25 | 25
2200 | 25 | 25 | 50 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP
 | MID | MIRANT | SNCL | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)MALIN/NP15 | ISO(T)CPJK/NP15 | PUGET | ISO(T)MALIN/SP15
 | MID(L)WESLEY | MIRANT(L)NP15 | SNCL(L)NP15 | PAC | SDGE(L)SP15
 |  |  |  | CDWR
 |  |  |  | SEMP
 |  |  |  | MIRANT
 |  |  |  | MIECO
 |  |  |  | AVISTA
 |  |  |  | DUKE
 |  |  |  | WESCO
 |  |  |  | ISO(T)MALIN/NP15
 |  |  |  | [NAME]
Spreadsheet: 766872d1644131252-indirekt-wechseln-dynamisch-example2596
Sheet: Vorbereitung

MR | GA | Name
 |  |  | Manuelle Arbeit I
 |  |  | Doublettenentfernen
 |  |  | [NAME] I!
 |  |  | Namensmanager anpassen
Spreadsheet: 708610d1607949697-need-help-with-calculating-averages-over-dynamic-ranges-test-data-gk2-
Sheet: Blad1

Time | Measurement |  |  | From | To | Average | Correct average |  | GK CORRECT average
00:00:01 | 85 |  |  | 00:00:00 | 00:00:20
00:00:02 | 79
00:00:02 | 77
00:00:03 | 75
00:00:04 | 76
00:00:05 | 65
00:00:06 | 68
00:00:07 | 69
00:00:07 | 66
00:00:08 | 64
00:00:09 | 64
00:00:09 | 63
00:00:10 | 70
00:00:11 | 75
00:00:12 | 72
00:00:13 | 73
00:00:13 | 74
00:00:14 | 76
00:00:15 | 78
00:00:15 | 81
00:00:16 | 82
00:00:17 | 84
00:00:18 | 83
00:00:19 | 85
00:00:20 | 86
00:00:20.798000 | 77
00:00:21.963000 | 55
00:00:23.352000 | 82
00:00:23.890000 | 82
00:00:25.127000 | 82
00:00:25.687000 | 82
00:00:26.771000 | 82
00:00:27.359000 | 61
00:00:28.483000 | 85
00:00:29.084000 | 66
00:00:32.006000 | 66
00:00:32.606000 | 66
00:00:33.574000 | 66
00:00:34.148000 | 66
00:00:35.573000 | 66
00:00:36.182000 | 61
00:00:37.334000 | 55
00:00:37.737000 | 87
00:00:38.347000 | 63
00:00:39.239000 | 63
00:00:39.843000 | 63
00:00:40.825000 | 63
00:00:41.390000 | 63
00:00:42.272000 | 63
00:00:42.837000 | 63
00:00:43.818000 | 57
00:00:44.204000 | 90
00:00:44.831000 | 68
00:00:45.660000 | 68
00:00:46.261000 | 68
00:00:47.520000 | 68
00:00:48.098000 | 68
00:00:49.572000 | 68
00:00:50.092000 | 61
00:00:51.517000 | 91
00:00:52.109000 | 61
00:00:52.933000 | 89
00:00:53.489000 | 89
00:00:54.748000 | 89
00:00:55.322000 | 89
00:00:56.156000 | 89
00:00:56.729000 | 64
00:00:57.670000 | 90
00:00:58.248000 | 61
00:00:59.700000 | 87
00:01:00.323000 | 61
00:01:00.852000 | 57
00:01:01.865000 | 85
00:01:02.470000 | 60
00:01:03.554000 | 87
00:01:04.105000 | 87
00:01:05.194000 | 87
00:01:05.763000 | 87
00:01:07.014000 | 87
00:01:07.336000 | 59
00:01:08.349000 | 59
00:01:08.761000 | 66
00:01:10.666000 | 86
00:01:11.262000 | 57
00:01:12.454000 | 82
00:01:13.050000 | 60
00:01:14.260000 | 84
00:01:14.843000 | 64
00:01:15.725000 | 64
00:01:16.344000 | 64
00:01:17.209000 | 64
00:01:17.778000 | 64
00:01:18.822000 | 64
00:01:19.396000 | 71
00:01:20.341000 | 103
00:01:20.897000 | 65
00:01:22.255000 | 92
00:01:22.869000 | 61
00:01:24.419000 | 90
00:01:25.042000 | 63
00:01:26.364000 | 90
00:01:26.956000 | 70
00:01:27.453000 | 70
00:01:28.892000 | 70
00:01:29.416000 | 70
00:01:30.644000 | 70
00:01:31.217000 | 61
00:01:32.665000 | 93
00:01:33.256000 | 63
00:01:34.462000 | 89
00:01:35.044000 | 60
00:01:36.564000 | 88
00:01:37.204000 | 59
00:01:38.652000 | 85
00:01:39.248000 | 60
00:01:40.467000 | 60
00:01:41.076000 | 60
00:01:42.515000 | 60
00:01:43.102000 | 60
00:01:44.173000 | 60
00:01:44.715000 | 68
00:01:46.104000 | 100
00:01:46.687000 | 72
00:01:47.453000 | 56
00:01:48.139000 | 95
00:01:48.775000 | 63
00:01:50.223000 | 87
00:01:50.823000 | 63
00:01:51.993000 | 91
00:01:52.566000 | 91
00:01:53.678000 | 91
00:01:54.242000 | 91
00:01:55.502000 | 91
00:01:56.089000 | 58
00:01:57.500000 | 87
00:01:58.092000 | 60
00:01:59.212000 | 87
00:01:59.786000 | 64
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A32

TABLE A32  FREQUENCY OF PRICE SPIKES IN THE NEW ENGLAND TEN-MINUTE NON-SPINNING RESERVE MARKET DURING JUNE, JULY, AND AUGUST OF 1998, 1999, AND 2000 BEFORE ISO-NE REVISIONS
Price Equals or Exceeds | # of hours |  |  | # of hours |  |  | # of hours
 | % of available hours |  |  | % of available hours |  |  | % of available hours
 | 1998-06-01 00:00:00 | 1999-06-01 00:00:00 | 2000-06-01 00:00:00 | 1998-07-01 00:00:00 | 1999-07-01 00:00:00 | 2000-07-01 00:00:00 | 1998-08-01 00:00:00 | 1999-08-01 00:00:00 | 2000-08-01 00:00:00
100 | NA | 32 | 4 | NA | 52 | 0 | NA | 2 | 0
 |  | 0.04444 | 0.00556 |  | 0.06989 | 0 |  | 0.00269 | 0
250 | NA | 0 | 4 | NA | 0 | 0 | NA | 0 | 0
 |  | 0 | 0.00556 |  | 0 | 0 |  | 0 | 0
500 | NA | 0 | 3 | NA | 0 | 0 | NA | 0 | 0
 |  | 0 | 0.00417 |  | 0 | 0 |  | 0 | 0
750 | NA | 0 | 3 | NA | 0 | 0 | NA | 0 | 0
 |  | 0 | 0.00417 |  | 0 | 0 |  | 0 | 0
1000 | NA | 0 | 2 | NA | 0 | 0 | NA | 0 | 0
 |  | 0 | 0.00278 |  | 0 | 0 |  | 0 | 0
Source:  ISO-NE Website (www.iso-ne.com). Data was only available through August 15, 2000.
Spreadsheet: d2703701-42fc-4a47-8bce-f2574011e4fc
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FCCGG | Test | FCCGG | Cheese Cheddar IgG | Cheese Cheddar IgG | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by: Viracor-IBT Laboratories                              1001 NW Technology Dr                               Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 9 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FCCGG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FCCGG | Result | FCCGG | Cheese Cheddar IgG | Cheese Cheddar IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 684991d1593651535-show-totals-for-each-cell-in-a-single-column-excelforum_sample
Sheet: Sheet1

Data |  | Duplicates
B7G |  | B7G |  | Row Labels | Count of Data
B84 |  | B84 |  | 8SC | 1
B5 |  | B5 |  | 9AE | 1
B9A |  | B9A |  | A12 | 4
B9A |  | UX4 |  | AO8 | 23
UX4 |  | AO8 |  | B4 | 11
B7G |  | B4 |  | B5 | 8
AO8 |  | UX6 |  | B5-15 | 1
B7G |  | Sm7 |  | B5A | 3
B4 |  | A12 |  | B7 | 2
UX4 |  | UX7 |  | B7A | 1
UX4 |  | NV5 |  | B7G | 41
AO8 |  | B7 |  | B8-25 | 1
UX4 |  | NV7 |  | B84 | 1
UX4 |  | [NAME] |  | B8-71 | 1
UX4 |  | B8-25 |  | B8A | 1
UX6 |  | F8 |  | B8B | 3
UX6 |  | B9G |  | [NAME] | 2
Sm7 |  | 8SC |  | B9A | 11
B7G |  | B7A |  | B9B | 1
A12 |  | B9B |  | B9D | 1
Sm7 |  | 9AE |  | B9G | 1
UX7 |  | B5-15 |  | F8 | 1
NV5 |  | B9D |  | NU5 | 1
B7 |  | B8-71 |  | NV5 | 5
NV7 |  | NU5 |  | NV7 | 2
[NAME] |  | B8A |  | Sm7 | 7
B8-25 |  | B8B |  | UX4 | 17
F8 |  | UX5 |  | UX5 | 3
B9G |  | B5A |  | UX6 | 5
Sm7 |  |  |  | UX7 | 7
8SC |  |  |  | Grand Total | 167
B7A
B9B
9AE
B5-15
B9D
B8-71
NU5
A12
B9A
B9A
AO8
UX6
UX6
B8A
UX7
UX4
AO8
B7G
UX4
B7G
A12
UX7
AO8
UX4
UX4
AO8
Sm7
AO8
AO8
UX4
B8B
AO8
B8B
B9A
AO8
B7G
NV5
B7G
UX5
B5
B5
B7
B5
B5
B5
B7G
B7G
B9A
NV5
NV7
B7G
AO8
UX5
AO8
AO8
AO8
B7G
B5A
B5A
B5A
B7G
B7G
B7G
B7G
B7G
B7G
UX7
UX7
B7G
B7G
B7G
B7G
B7G
UX6
B7G
B7G
B7G
AO8
B7G
B7G
A12
Sm7
UX7
NV5
B7G
B5
B5
B7G
B9A
B9A
AO8
B7G
B7G
B7G
B7G
B7G
B4
B7G
UX5
B7G
B7G
B4
B7G
B7G
B4
B4
AO8
AO8
Sm7
UX7
NV5
AO8
UX4
AO8
B4
UX4
UX4
B4
B4
B9A
AO8
UX4
B4
UX4
B4
UX4
B4
B8B
AO8
Sm7
[NAME]
AO8
B7G
B9A
B9A
Spreadsheet: 62229d1263219329-trying-to-use-sumifs-to-sum-a-column-based-on-two-conditions-sumif2conditionspresent
Sheet: Data

Timestamp | Username | Please choose your office location. | # of Care to Share Cards Out?
2010-01-04 16:46:56 | [EMAIL] | Office1 | 0
2010-01-04 17:31:42 | [EMAIL] | Office2 | 0
2010-01-05 09:47:29 | [EMAIL] | Office3 | 4
2010-01-05 13:05:02 | [EMAIL] | Office2 | 0
2010-01-05 13:14:33 | [EMAIL] | Office3 | 5
2010-01-05 13:17:27 | [EMAIL] | Office3 | 2
2010-01-06 07:57:55 | [EMAIL] | Office2 | 4
2010-01-06 09:35:07 | [EMAIL] | Office1 | 0
2010-01-06 16:49:56 | [EMAIL] | Office1 | 0
2010-01-07 10:01:44 | [EMAIL] | Office3 | 2
2010-01-07 10:17:26 | [EMAIL] | Office3 | 4
2010-01-07 11:41:38 | [EMAIL] | Office2 | 3
2010-01-08 10:07:28 | [EMAIL] | Office1 | 0
2010-01-08 17:16:12 | [EMAIL] | Office1 | 0
2010-01-09 09:21:49 | [EMAIL] | Office3 | 0
Spreadsheet: 68832d1269373161-using-min-and-max-function-to-find-times-testendora75
Sheet: Sheet 1

ID | Start Date & Time | End Date & Time
1 | 2010-03-18 01:25:26 | 2010-03-18 01:26:20
2 | 2010-03-11 16:15:58 | 2010-03-11 16:16:26
3 | 2010-03-08 11:55:31 | 2010-03-08 11:55:31
 | MINIMUM START | 01:25:26 |  |  | Once you type in an array formula,
 | MINIMUM END | 01:26:20 |  |  | you cannot use Enter …
 | MAXIMUM START | 16:15:58 |  |  | but the combination of 3 keys
 | MAXIMUM END | 16:16:26 |  |  | Control Shift Enter
 |  |  |  |  | to enter the formula …
 |  |  |  |  | HTH