tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 770774d1646245601-unique-and-filter-inside-countif-s-function-unique-filter-inside-countifs-function
Sheet: Sheet1

Subject | Student | Score |  |  | Subject | Score
ENGLISH | [NAME] | D |  |  | BIOLOGY | A
PHYSICS | [NAME] | B |  |  |  | C
ENGLISH | Doe | E |  |  |  | D
HISTORY | [NAME] | E |  |  | CHEMISTRY | A
GEOGRAPHY | [NAME] | B |  |  | ENGLISH | A
ENGLISH | [NAME] | A |  |  |  | D
GEOGRAPHY | [NAME] | A |  |  |  | E
ENGLISH | Doe | D |  |  | GEOGRAPHY | A
PHYSICS | [NAME] | A |  |  |  | B
HISTORY | [NAME] | A |  |  | HISTORY | A
GEOGRAPHY | [NAME] | A |  |  |  | C
PHYSICS | [NAME] | D |  |  |  | E
MATHEMATICS | Doe | B |  |  | MATHEMATICS | B
HISTORY | [NAME] | C |  |  | PHYSICS | A
PHYSICS | [NAME] | B |  |  |  | B
BIOLOGY | [NAME] | A |  |  |  | D
PHYSICS | [NAME] | A
BIOLOGY | [NAME] | D
CHEMISTRY | Doe | A
BIOLOGY | [NAME] | A
BIOLOGY | [NAME] | A
BIOLOGY | [NAME] | C
Spreadsheet: 192895d1352614540-combining-of-3-pivot-tables-datas-into-1-how-sales-datas
Sheet: Plant-2-Pivot

Plant | (All)
 | G/L Code | Values
 | QA10101110 |  | QA10101115 |  | QA10101140 |  | QA10101145 |  | QA10105110 |  | QA10105115 |  | QA10105140 |  | QA20109110 |  | Total Sum of Qty | Total Sum of Amount
Material Group | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount | Sum of Qty | Sum of Amount
GLRADRSCC | -20 | -758288.2 |  |  |  | -17360 |  | -402.6 | -99 | -3446723.61 |  |  |  | -74774.7 |  |  | -119 | -4297549.11
GLRADSSCC |  |  |  |  |  |  |  |  | -77 | -2793726.32 |  |  |  | -7777.04 |  |  | -77 | -2801503.36
GLRADSSCF | -25 | -1124048.25 |  |  |  | -4340 |  | -118.9 |  |  |  |  |  |  |  |  | -25 | -1128507.15
IGNADRSCC | -4 | -162187.8 |  |  |  | -4340 |  | -86.4 |  |  |  |  |  |  |  |  | -4 | -166614.2
MATADSSDX |  |  | -8 | -270131.78 |  |  |  | -35.98 |  |  |  |  |  |  |  |  | -8 | -270167.76
PLNADRSCC |  |  | -4 | -120433 |  |  |  |  |  |  | -81 | -2318580.45 |  |  |  | 16256.5 | -85 | -2422756.95
PPRADRSCC | -20 | -701889 |  |  |  | -17360 |  | -373.2 |  |  |  |  |  |  |  |  | -20 | -719622.2
Grand Total | -69 | -2746413.25 | -12 | -390564.78 |  | -43400 |  | -1017.08 | -176 | -6240449.93 | -81 | -2318580.45 |  | -82551.73999999999 |  | 16256.5 | -338 | -11806720.73
Spreadsheet: 452613d1458828565-sum-a-named-range-across-multiple-worksheets-01-estimator-sample
Sheet: TotalNamesSummarySheet

Name | Reference | Total | Sheet Name
Total |  | 4250 | Concrete
Total |  | 4250 | Concrete (2)'
Total |  | 4250 | Concrete (3)'
Total |  | 827.75 | [NAME]
Total |  | 0 | Summary Sheet'
Total |  | 18298.5125 | Travel
 | Total of Totals | 31048.5125
 |  |  | Concrete (2)
 |  |  | Concrete (3)
 |  |  | Rates
 |  |  | TotalNamesSummarySheet
 |  |  | Summary Sheet
Spreadsheet: 04d650dc-182d-45ee-8dc8-6e95b91fd9bb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Regional Early Childhood Committee Chairs (RECC)  Updated May 2010
Region | Name | Phone | E-mail | Address
1 | [NAME] | 666-6755 x105 | [EMAIL] | [NAME] 411 North 15th Street #104 Couer d'Alene  83814
1 | [NAME] | 265-6156 | [EMAIL] | 36 Granite View Drive Sandpoint  83864
2 | [NAME] | 717-8032 | [EMAIL] | 1444 - 14th Street Lewiston
2 | [NAME] | 305-7511 | [EMAIL] | [NAME] 954 Kamiah  83536
3 | [NAME] | 365-2302 h | [EMAIL] | 7070 Merrill Road Emmett  83617
4 | [NAME] | 377 8070 | [EMAIL] | 5420 [NAME], Ste. A Boise, ID 83705
5 | [NAME] | 320-7332 | [EMAIL] | 3560 North 2900 East [NAME], ID  83301
5 | [NAME] |  | [EMAIL].
6 | [NAME] | 478-6977 w 244-1599 c | [EMAIL] | 981 Sawtooth Chubbuck 315 West Center #101 Pocatello
7 | Remae Murdock | 525-7563 w 523-3538 | [EMAIL] [EMAIL] | 380 West Anderson Idaho Falls  83402 5635 Solitude Lane Idaho Falls  83406
Spreadsheet: 822932d1679600692-if-index-match-function-to-return-value-basis-combination-sample
Sheet: Sheet1

Report number | Grade | Check | Final Grade | Comments
252261956 | E |  | E | This is E because per report number there is no duplicate (C2) so the score should remain E
251919688 | E |  | D | This is D because there is a duplicate (C4) grade which has "D" per the rating system D is worse grade therefore D. If there is a Good rating and also a Worse rating for the same report this cell should return worse score for that report
251919688 | D |  | D | This is D because there is a duplicate (C4) grade which has "D" per the rating system D is worse grade therefore D. If there is a Good rating and also a Worse rating for the same report this cell should return worse score for that report |  | Grade System | Rating
 |  |  |  |  |  | E | Good
 |  |  |  |  |  | D | Worse
Spreadsheet: 89631d1289403667-weighted-average-with-criteria-average-ages
Sheet: Sheet1

 |  | Star | Age | Number
 |  | 3 | 17.9 | 10
 |  | 3 | 17 | 1
 |  | 4 | 5.857142857142857 | 42
 |  | 2 | 17.92307692307692 | 10
 |  | 2 | 16 | 17
 |  | 4 | 8.934426229508198 | 61
 |  | 3 | 10.76744186046512 | 43
 |  | 4 | 13.81818181818182 | 34
 |  | 4 | 8.31578947368421 | 19
 |  | 4 | 8.826086956521738 | 46
 |  | 3 | 14.5 | 3
 |  | 3 | 11.83333333333333 | 5
 |  | 3 | 9.5 | 22
 |  | 4 | 12.6 | 30
 |  | 4 | 13.13793103448276 | 29
 |  | 4 | 10.95652173913044 | 22
 |  | 3 | 13.05769230769231 | 52
 |  | 4 | 7.533333333333333 | 45
 |  | 3 | 19 | 3
 |  | 3 | 18 | 12
 |  | 3 | 16 | 2
 |  | 3 | 18.28571428571428 | 7
 |  | 4 | 9.481481481481481 | 27
 |  | 2 | 19.36363636363636 | 10
 |  | 5 | 0 | 10
 |  | 5 | 0 | 5
 |  | 5 | 0 | 20
 |  | 5 | 0 | 15
 |  | 4 | 8.23076923076923 | 65
 |  | 3 | 18.81818181818182 | 11
 |  | 5 | 2 | 8
 |  | 3 | 14 | 10
 |  | 5 | 3 | 1
 |  | 3 | 18.55882352941176 | 34
 |  | 3 | 19.83333333333333 | 6
 |  | 3 | 17 | 4
 |  | 3 | 17 | 1
 |  | 3 | 14 | 1
 |  | 4 | 10.08695652173913 | 23
 |  | 5 | 3.052631578947369 | 19
 |  | 4 | 4.564102564102564 | 39
 |  | 3 | 16.72222222222222 | 18
 |  | 2 | 11 | 22
 |  | 3 | 17.75 | 4
 |  | 2 | 17.18518518518519 | 26
 |  | 2 | 19.93333333333333 | 16
 |  | 4 | 4.466666666666667 | 15
 |  | 3 | 20.71428571428572 | 7
 |  | 2 | 15.64705882352941 | 7
 |  |  |  | 939
 |  | Average Age
 |  | Star
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | Total | 10.72063154369085
Spreadsheet: 355924d1414859275-auto-filter-test-marks
Sheet: Absent

Name | Marks Science | Maths | English | Physics | History | GK | Remarks
SD | 98 | 56 | 45 | 67 | 98 | 78 | Absent
OI | 67 | 67 | 67 | 45 | 78 | 67 | Absent
FT | 45 | 98 | 98 | 45 | 67 | 45 | Absent
Spreadsheet: 852783d1702732612-how-to-join-the-text-of-several-cells-with-a-single-comma-sample-data1-aligw
Sheet: Foaie1

 |  | Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6 | Field 7 | Field 8 | Field 9 | 2016 | 365
1 | DINING1 |  | pears |  |  |  | grapes
2 | DINING2 |  |  | lemon |  | pears |  |  |  | cherries |  |  | !!!!! In the "Result" column marked with yellow, I would like to join the words from the "Field 1...9" columns, but each word separated from the other by a comma.
3 | DINING3 | oranges |  | pears
4 | DINING4
5 | [NAME] |  |  |  | grapes |  |  |  | pears | cherries
6 | DINING6 |  |  | cherries
7 | DINING7 | pears
8 | DINING8 |  |  |  | oranges
9 | DINING9 |  |  |  | pears
10 | DINING10 |  |  |  |  |  |  | pears
11 | DINING11 |  | oranges
12 | DINING12 |  |  |  |  | grapes
13 | DINING13 |  |  |  |  |  |  | oranges
14 | DINING14 | grapes
15 | [NAME] |  |  |  |  |  |  |  |  | oranges
16 | DINING16 |  | pears
17 | DINING17 |  |  |  | lemon |  | pears
18 | DINING18 |  | cherries |  |  |  |  |  |  | pears
19 | DINING19 |  |  |  |  |  |  |  | pears
20 | DINING20 |  |  | grapes
Spreadsheet: 469913d1468247698-only-need-s-before-oeldere-469908d1468247154-only-need-s-before-removing-s
Sheet: GM - Location Statistics

Location
11417 | F LION #206
1476 | F LION #1476
13539 | F LION #839
1005 | KROGER #533
14705 | NEX SEWELLS POINT SPIRIT
45688 | F LION #2631
10426 | KROGER #532
12704 | HARRIS TEETER #161
2442 | KROGER #539
45736 | FARM FR #672
14044 | F LION #172
19351 | KROGER #537
3925 | F LION #1624
1559 | F LION #1559
1592 | F LION #1592
21215 | F LION #958
11249 | F LION #849
2562 | F LION #2562
Spreadsheet: 2929f591-cff7-4cbc-a28c-8f8497cfb35b
Sheet: Sheet1

[NAME] July 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33
User Name | Names | CTI? | 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
 |  |  | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
Karl_Sue | Karl & Sue | Y |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x
Spreadsheet: 074c5707-ab2d-4b6d-bc0d-639a033bd2d9
Sheet: 09-10 Block Dates

THIRD & FOURTH YEAR REGISTRATION BLOCK DATES
Academic Year 2012 - 2013
 | BLOCK 1 |  |  |  | Last day to add & drop
 | SU12 - Section 001 |  |  |  | 2012-05-07 00:00:00
 | 7/2 - 7/27/12
 | BLOCK 2 |  |  |  | Last day to add & drop
 | SU12 - Section 002 |  |  |  | 2012-06-04 00:00:00
 | 7/30 - 8/24/12
 | BLOCK 3 |  |  |  | Last day to add & drop
 | FA12 - Section 001 |  |  |  | 2012-07-02 00:00:00
 | 8/27 - 9/21/12
 | BLOCK 4 |  |  |  | Last day to add & drop
 | FA12 - Section 002 |  |  |  | 2012-07-30 00:00:00
 | 9/24 - 10/19/12
 | BLOCK 5 |  |  |  | Last day to add & drop
 | FA12 - Section 003 |  |  |  | 2012-08-27 00:00:00
 | 10/22 - 11/16/12
 | BLOCK 6 |  |  |  | Last day to add & drop
 | FA12 - Section 004 |  |  |  | 2012-09-24 00:00:00
 | 11/19 - 12/14/12
 |  |  | 3rd Yr Island 12/17-12/21/2012
 | BLOCK 7-FOURTH YEAR |  |  |  | Last day to add & drop
 | SP13 - Section 001 |  |  |  | 11/12/2012.
 | 1/7 - 2/1/13
 | BLOCK 8-FOURTH YEAR |  |  |  | Last day to add & drop
 | SP13 - Section 002 |  |  |  | 2012-12-10 00:00:00
 | 2/4 - 3/1/13
 | BLOCK 9-FOURTH YEAR |  |  |  | Last day to add & drop
 | SP13 - Section 003 |  |  |  | 2013-01-07 00:00:00
 | 3/4- 3/29/13
 |  |  | 3rd Yr Island 4/1-5/2013
 | BLOCK 10-FOURTH YEAR |  | BLOCK 10 - THIRD YEAR |  | Last day to add & drop
 | SP13 - Section 004 |  | SP13 - Section 004 |  | 2/4/2013-4th YR
 | 4/1 - 4/26/13 |  | 4/8 - 5/3/13 |  | 2/11/2013-3rd YR
 | 4th Yr Island 4/29-5/3/13
 | BLOCK 11 |  |  |  | Last day to add & drop
 | SP13 - Section 005 |  |  |  | 2013-03-11 00:00:00
 | 5/6 - 5/31/13
 | BLOCK 12 |  |  |  | Last day to add & drop
 | SP13 - Section 006 |  |  |  | 2013-04-08 00:00:00
 | 6/3 - 6/28/13
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, December 21 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 94507d1294309702-excel-2007-excel-experts-plz-i-need-help-project-data-4
Sheet: MIS

 |  |  |  | ID | 900012394 |  | Major
 |  |  | MIS
 |  |  |  | Course | Grade |  | Course | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI101 |  |  | ENG204 |  |  |  |  | ENG208 |  |  | MIS303
 |  |  | 1st semester | BIS101 |  | 3rd semester | ACC201 |  |  |  | 5th semester | BLW301 |  | 7th semester | MGT380
 |  |  |  | MTH101 |  |  | ECO201 |  |  |  |  | QBA202 |  |  | MJEXXX
 |  |  |  | HUMXXX |  |  | QBA201 |  |  |  |  | MIS200 |  |  | FREEXXX
 |  |  |  | SCIXXX |  |  | MGT201 |  |  |  |  | FREEXXX |  |  | FREEXXX
 |  |  |  | Course | Grade |  | Course | Grade |  |  |  | Course | Grade |  | Course | Grade
 |  |  |  | WRI102 |  |  | ECO202 |  |  |  |  | [NAME] |  |  | MGT406
 |  |  | 2nd semester | ARAXXX |  | 4th semester | ACC202 |  |  |  | 6th semester | MGT360 |  | 8th semester | MIS405
 |  |  |  | MTH102 |  |  | FIN201 |  |  |  |  | HSSXXX |  |  | MIS404
 |  |  |  | SCIXXX |  |  | MKT201 |  |  |  |  | MIS301 |  |  | FREEXXX
 |  |  |  | HUMXXX |  |  | MIS201 |  |  |  |  | MJEXXX |  |  | FREEXXX
 |  |  |  |  |  |  |  |  |  |  |  | FREEXXX
Spreadsheet: 9b5cc520-2da1-4970-a06e-1722b35cb8ce
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
11/11/2011 | Women's Basketball | YOUNGSTOWN STATE | W, 69-37
11/18/2011 | Women's Basketball | ST. [NAME] | L, 48-56
11/20/2011 | Women's Basketball | NORTH CAROLINA CENTRAL | W, 97-24
11/25/2011 | Women's Basketball | vs. No. 25 UCLA (Northridge, Calif.) | W, 63-54
11/26/2011 | Women's Basketball | vs. Cal State Northridge (Northridge, Calif.) | L, 47-48
11/30/2011 | Women's Basketball | LA [NAME] | W, 63-52
12/03/2011 | Women's Basketball | BOSTON | W, 78-53
12/07/2011 | Women's Basketball | at Syracuse | W, 76-72
12/10/2011 | Women's Basketball | NORTH FLORIDA | W, 86-30
12/17/2011 | Women's Basketball | at Duquesne | L, 55-61
12/20/2011 | Women's Basketball | MOUNT ST. MARY'S | W, 94-32
12/28/2011 | Women's Basketball | BUCKNELL | W, 72-30
12/31/2011 | Women's Basketball | ELON | W, 84-36
01/04/2012 | Women's Basketball | at No. 2/2Connecticut | L, 60-79
01/07/2012 | Women's Basketball | VILLANOVA | W, 61-56
01/10/2012 | Women's Basketball | SETON HALL | W, 79-63
01/14/2012 | Women's Basketball | at Providence | L, 48-51
01/17/2012 | Women's Basketball | vs. [NAME] (Charleston, W. Va.) | W, 69-57
01/21/2012 | Women's Basketball | at Pitt | W, 54-43
01/24/2012 | Women's Basketball | GEORGETOWN | L, 54-64
01/28/2012 | Women's Basketball | MARQUETTE | W, 53-32
[NAME] | Women's Basketball | at USF | W, 55-52
02/04/2012 | Women's Basketball | No. 14/12 LOUISVILLE | W, 66-50
02/12/2012 | Women's Basketball | at No. 2/2 Notre Dame | W, 65-63
02/15/2012 | Women's Basketball | No. 21/18 RUTGERS | W, 60-50
02/18/2012 | Women's Basketball | No. 24/20 DEPAUL | L, 63-77
02/21/2012 | Women's Basketball | at No. 20/25 St. John's | L, 54-63
[NAME] | Women's Basketball | at Cincinnati | W, 66-62
02/27/2012 | Women's Basketball | PITT | W, 60-42
03/03/2012 | Women's Basketball | vs. Syracuse (Hartford, Conn.) | W, 63-48
03/04/2012 | Women's Basketball | vs. No. 12/14 Georgetown (Hartford, Conn.) | W, 39-32
03/05/2012 | Women's Basketball | vs. No. 3/3 Notre Dame (Hartford, Conn.) | L, 45-73
03/17/2012 | Women's Basketball | vs. Texas (Norfolk, Va.) | W, 68-55
03/19/2012 | Women's Basketball | vs. No. 2/2 Stanford (Norfolk, Va.) | L, 55-72
Spreadsheet: 693583d1599047246-checkbox-to-show-percentage-or-real-figure-better-example
Sheet: STATS

False
 | ^ | v
 |  | CHECK | NUMBER | PERCENT
 | JAN |  |  | 0.1
 | FEB
 | MAR
 | APR
 | MAY
 | JUN
 | JUL
 | AUG
 | SEP
 | OCT
 | NOV
 | DEC
 | YTD
Spreadsheet: 780883d1652852873-sortby-and-filter-formula-trouble-sortby-and-filter-test-aligw
Sheet: Full Roster

Employee ID | First Name | Last Name | [NAME] | Code | ID | Anniversary Date | Column13 | Column15
 | [NAME] | Ansari |  | VIP | 04170 | 2011-04-14 00:00:00
 | Selena | [NAME] |  | CIA | 04040 | 1985-01-02 00:00:00
 | [NAME] | [NAME] |  | CIA | 04170 | 2010-08-23 00:00:00
 | [NAME] | [NAME] |  | FBI | 04040 | 2004-02-23 00:00:00
 | Stephen | Colbert |  | CIA | 04040 | 1997-04-01 00:00:00
 | Nicki | Minaj |  | VIP | 04040 | 2011-01-10 00:00:00
 | [NAME] | Murphy |  | VIP | 04170 | 2007-08-09 00:00:00
 | [NAME] | Parsons |  | CIA | 04040 | 2010-01-04 00:00:00
 | [NAME] | Rogen |  | VIP | 04040 | 2006-11-07 00:00:00
 | Sofia | Vergara |  | NSA | 04040 | 2004-05-24 00:00:00
 | [NAME] | [NAME] |  | CIA | 04040 | 2010-03-10 00:00:00
 | Viola | [NAME] |  | VIP | 04170 | 2010-08-09 00:00:00
Spreadsheet: 119457d1314410648-condense-rows-based-on-alphabetic-value-display-max-and-min-values-in-other-columns-fahall_test
Sheet: Sheet2

 | Start | Finish
[NAME] | 12:00:00 | 23:00:00
[NAME] | 12:00:00 | 23:00:00
[NAME] | 07:45:00 | 23:30:00
[NAME] | 12:30:00 | 23:00:00
Elvis | 12:00:00 | 23:00:00
[NAME] | 15:00:00 | 23:30:00
Spreadsheet: 823164d1679773355-retrieving-value-from-adjacent-table-based-on-value-within-table-eflookup
Sheet: GK

Airline | To | Sched. |  |  | Airline | To | To2 | First Flight | Last Flight
American Airlines | Doha | 11:00:00 |  |  |  | Doha | West Palm Beach, FL | 11:00:00 | 14:00:00
American Airlines | [NAME] | 11:10:00
American Airlines | Miami, FL | 11:15:00
American Airlines | Indianapolis, IN | 11:15:00
American Airlines | London | 11:20:00
American Airlines | Columbus, OH | 12:00:00
American Airlines | Cleveland, OH | 12:00:00
American Airlines | Boston, MA | 12:05:00
American Airlines | Worcester, [NAME] | 12:10:00
American Airlines | Boston, MA | 12:10:00
American Airlines | Norfolk, VA | 12:20:00
American Airlines | Jacksonville, FL | 12:20:00
American Airlines | Salt Lake City, UT | 12:27:00
American Airlines | Orlando, FL | 12:30:00
American Airlines | Miami, FL | 12:37:00
American Airlines | West Palm Beach, FL | 12:40:00
American Airlines | [NAME] | 12:41:00
American Airlines | Boston, MA | 13:05:00
American Airlines | Orlando, FL | 13:14:00
American Airlines | Boston, MA | 13:20:00
American Airlines | Tampa, FL | 13:28:00
American Airlines | Syracuse, NY | 13:30:00
American Airlines | San Francisco, CA | 13:30:00
American Airlines | Miami, FL | 13:40:00
American Airlines | Atlanta, GA | 13:40:00
American Airlines | Burlington, VT | 13:44:00
American Airlines | Buffalo, NY | 13:44:00
American Airlines | San Antonio, TX | 13:45:00
American Airlines | Tokyo | 13:45:00
American Airlines | Phoenix, AZ | 13:55:00
American Airlines | West Palm Beach, FL | 14:00:00
Spreadsheet: 714577d1611298252-use-index-in-table-header-with-sumifs-book1
Sheet: months

 |  | 2021
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | ian | feb | [NAME] | apr | mai | [NAME] | iul | aug | sept | oct | nov | dec
 | apple
 | juice
 | candy
Spreadsheet: 151021d1334760746-if-then-with-nested-drop-down-list-2012_04_18-excel-help
Sheet: Main Data Set

Person | Function Code | PSC | Reason Code | Policy 11-01 Letter
 | C403 |  | A | I
 | D401
 | C403 |  | B
 | M310 |  | C
 | C316 |  | I
 | C403 |  | B
 | F000
 | F100
 | F110
 | F120
 | F140
 | F150
 | F160
 | F199
 | F200
 | F300
 | F310
 | F320
 | F399
 | F400
 | F510
 | F520
 | I115
 | M301
 | M302
 | M310
 | M312
 | M320
 | M328
 | M330
 | M334
 | M399
 | R300
 | T700
 | T813
 | T818
 | W410
 | W826
 | W826
 | W826 -
 | Y315
 | Y510
 | Y520
 | Y530
 | Y540
 | Y550
 | Y550
 | Y650
 | Y815
Spreadsheet: 865298d1712329780-would-it-be-possible-to-use-index-match-to-return-sumrange-for-sumif-between-date-ranges-sample
Sheet: Monthly

 | 2024-04-01 00:00:00
 | 2024-04-30 00:00:00
ID
50001
Spreadsheet: e52988e1-0014-4353-8e64-40237a72c0be
Sheet: Sheet1

Potential Mercury Limit NPDES Limit Calculator | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Developed by [NAME] 4/14/03 |  |  |  |  |  |  |  |  | USE FOR OTHER PARAMETERS THAN MERCURY
Use if you have whole effluent toxicity (WET) test percentage |  |  |  |  |  |  |  |  | Use if you have whole effluent toxicity (WET) test percentage
Facility Name = |  |  |  |  |  |  |  |  | Facility Name =
NPDES # [NAME] |  |  |  |  |  |  |  |  | NPDES # [NAME]
Parameter = | Mercury |  |  |  |  |  |  |  | Parameter =
Standard = | 0.012 | µg/l |  |  |  |  |  |  | Standard = |  | µg/l
NPDES Permitted Flow (MGD) = | 5 | MGD |  |  |  |  |  |  | NPDES Permitted Flow (MGD) = |  | MGD
IWC (%) = | 56 | % |  |  |  |  |  |  | IWC (%) = |  | %
Potential NPDES Limit= | 0.02142857142857143 | µg/l |  |  |  |  |  |  | Potential NPDES Limit= |  | µg/l
Use if you have receiving stream 7Q10 in MGD |  |  |  |  |  |  |  |  | Use if you have receiving stream 7Q10 in MGD
Facility Name = |  |  |  |  |  |  |  |  | Facility Name =
NPDES # [NAME] |  |  |  |  |  |  |  |  | NPDES # [NAME]
Parameter = | Mercury |  |  |  |  |  |  |  | Parameter =
Standard = | 0.012 | µg/l |  |  |  |  |  |  | Standard = |  | µg/l
NPDES Permitted Flow (MGD) = | 5 | MGD |  |  |  |  |  |  | NPDES Permitted Flow (MGD) = |  | MGD
Receiving Stream 7Q10s (in MGD)= | 3.88 | MGD |  |  |  |  |  |  | Receiving Stream 7Q10s (in MGD)= |  | MGD
IWC (%) = | 56.30630630630631 | % |  |  |  |  |  |  | IWC (%) = |  | %
Potential NPDES Limit= | 0.021312 | µg/l |  |  |  |  |  |  | Potential NPDES Limit= |  | µg/l
Use if you have receiving stream 7Q10 in cfs |  |  |  |  |  |  |  |  | Use if you have receiving stream 7Q10 in cfs
Facility Name = |  |  |  |  |  |  |  |  | Facility Name =
NPDES # [NAME] |  |  |  |  |  |  |  |  | NPDES # [NAME]
Parameter = | Mercury |  |  |  |  |  |  |  | Parameter =
Standard = | 0.012 | µg/l |  |  |  |  |  |  | Standard = |  | µg/l
NPDES Permitted Flow (MGD) = | 5 | MGD |  |  |  |  |  |  | NPDES Permitted Flow (MGD) = |  | MGD
NPDES Permitted Flow (cfs) = | 7.75 | cfs |  |  |  |  |  |  | NPDES Permitted Flow (cfs) = |  | cfs
Receiving Stream 7Q10s (in cfs)= | 6 | cfs |  |  |  |  |  |  | Receiving Stream 7Q10s (in cfs)= |  | cfs
IWC (%) = | 56.36363636363636 | % |  |  |  |  |  |  | IWC (%) = |  | %
Potential NPDES Limit= | 0.02129032258064516 | µg/l |  |  |  |  |  |  | Potential NPDES Limit= |  | µg/l
Spreadsheet: 704412d1605539116-detect-the-patients-who-returned-to-the-emergency-room-within-24-hours-sample
Sheet:      DATA    

Patient ID | Date of ER Visit | Registration Time | Discharge Time | Returned to ER within 24 hrs
5767686 | 2020-10-02 00:00:00 | 18:13:00 | 18:35:00
5767686 | 2020-10-04 00:00:00 | 09:07:00 | 09:40:00
8446699 | 2020-10-11 00:00:00 | 06:20:00 | 08:05:00
8446699 | 2020-10-12 00:00:00 | 21:04:00 | 23:20:00
8446699 | 2020-10-18 00:00:00 | 06:25:00 | 07:00:00
3439555 | 2020-10-08 00:00:00 | 19:22:00 | 20:40:00
3439555 | 2020-10-10 00:00:00 | 07:15:00 | 14:50:00
3439286 | 2020-10-07 00:00:00 | 12:20:00 | 21:05:00
3439286 | 2020-10-09 00:00:00 | 11:09:00 | 12:55:00
3439286 | 2020-10-10 00:00:00 | 00:37:00 | 08:00:00
3439553 | 2020-10-02 00:00:00 | 15:25:00 | 18:50:00
3439553 | 2020-10-05 00:00:00 | 19:43:00 | 09:30:00
3444488 | 2020-10-02 00:00:00 | 11:00:00 | 13:05:00
3444488 | 2020-10-03 00:00:00 | 21:41:00 | 01:30:00
3291800 | 2020-10-15 00:00:00 | 14:30:00 | 22:20:00
3291800 | 2020-10-17 00:00:00 | 23:35:00 | 15:00:00
3267867 | 2020-10-08 00:00:00 | 20:40:00 | 22:05:00
3267867 | 2020-10-08 00:00:00 | 19:13:00 | 21:10:00
3267867 | 2020-10-13 00:00:00 | 11:15:00 | 12:35:00
3262899 | 2020-10-04 00:00:00 | 23:30:00 | 02:35:00
3262899 | 2020-10-06 00:00:00 | 08:30:00 | 11:35:00
3195176 | 2020-10-31 00:00:00 | 07:20:00 | 10:35:00
3195176 | 2020-10-31 00:00:00 | 07:20:00 | 10:35:00
3168166 | 2020-10-07 00:00:00 | 15:45:00 | 17:55:00
3168166 | 2020-10-07 00:00:00 | 23:20:00 | 07:10:00
2656676 | 2020-10-11 00:00:00 | 03:06:00 | 04:35:00
2656676 | 2020-10-26 00:00:00 | 23:55:00 | 02:25:00
2373667 | 2020-10-19 00:00:00 | 20:10:00 | 23:35:00
2373667 | 2020-10-27 00:00:00 | 08:30:00 | 10:25:00
1666556 | 2020-10-16 00:00:00 | 16:50:00 | 21:45:00
1666556 | 2020-10-19 00:00:00 | 01:33:00 | 03:00:00
333976 | 2020-10-04 00:00:00 | 23:15:00 | 03:20:00
333976 | 2020-10-06 00:00:00 | 11:55:00 | 14:05:00
3344749 | 2020-10-13 00:00:00 | 08:40:00 | 10:25:00
3344749 | 2020-10-18 00:00:00 | 00:45:00 | 18:00:00
5577897 | 2020-10-17 00:00:00 | 08:20:00 | 08:50:00
5577897 | 2020-10-25 00:00:00 | 09:15:00 | 11:05:00