tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101567d1299676846-excel-to-mysql-table-example-spreadsheet
Sheet: WK1

[NAME] YOUTH FOOTBALL LEAGUE
2010 GAME SCORES
WEEK 1
AT : | AB |  |  |  |  | AT : | LV |  |  |  |  | AT : | NH
90-N | AB1 | 0 | ME | 0 |  | 120-1 | LV1 | 0 | MC1 | 0 |  | 120-3 | [NAME] | 0 | NS | 0
80-N | AB | 0 | LV3 | 0 |  | 105-3 | LV3 | 0 | PE2 | 0 |  | 105-3 | [NAME] | 0 | LP1 | 0
90-N | AB2 | 0 | LV4 | 0 |  | 105-5 | LV5 | 0 | NS | 0 |  | 105-1 | NH1 | 0 | PE1 | 0
135 | AB | 0 | LV | 0 |  | 105-4 | LV6 | 0 | LV4 | 0 |  | 120-1 | NH1 | 0 | ME | 0
 |  |  |  |  |  | 120-3 | LV3 | 0 | LV2 | 0
AT : | BN |  |  |  |  | 80-N | LV1 | 0 | HR2 | 0 |  | AT : | QK
80-N | BN | 0 | PE1 | 0 |  | 90-N | LV2 | 0 | PD1 | 0 |  | 120-3 | QK2 | 0 | PE2 | 0
120-2 | BN | 0 | PD | 0 |  |  |  |  |  |  |  | 135 | QK | 0 | PE | 0
 |  |  |  |  |  | AT : | LP |  |  |  |  | 105-4 | QK2 | 0 | CO2 | 0
AT : | BR |  |  |  |  | 120-2 | LP | 0 | AB | 0 |  | 105-1 | QK1 | 0 | PT1 | 0
105-2 | BR | 0 | LV2 | 0 |  | 135 | LP | 0 | LA | 0 |  | 90-N | QK1 | 0 | MC1 | 0
120-2 | BR | 0 | QK1 | 0 |  | 80-N | LP | 0 | PE2 | 0 |  | 90-N | QK2 | 0 | BR | 0
 |  |  |  |  |  | 90-N | LP1 | 0 | PD2 | 0 |  | 80-N | QK2 | 0 | CO | 0
AT : | HR
105-2 | HR1 | 0 | PD1 | 0 |  | AT : | MC |  |  |  |  | AT : | PE
105-5 | HR2 | 0 | PD2 | 0 |  | 105-4 | MC4 | 0 | [NAME] | 0 |  | 105-4 | PE3 | 0 | PT2 | 0
 |  |  |  |  |  | 105-1 | MC1 | 0 | LV1 | 0 |  | 105-5 | PE4 | 0 | MC5 | 0
AT : | LA |  |  |  |  | 135 | MC1 | 0 | BR | 0 |  | 120-1 | PE1 | 0 | PT | 0
90-N | LA | 0 | CO | 0 |  | 90-N | MC2 | 0 | PE3 | 0 |  | 90-N | PE2 | 0 | NH1 | 0
105-5 | LA2 | 0 | BN | 0 |  | 90-N | MC3 | 0 | LV3 | 0 |  | 90-N | PE1 | 0 | PT | 0
105-2 | LA1 | 0 | CO1 | 0
120-2 | LA | 0 | HR | 0 |  | AT : | MC |  |  |  |  | AT : | PA
 |  |  |  |  |  | 80-N | MC1 | 0 | HR1 | 0 |  | 80-N | PA | 0 | LA | 0
 |  |  |  |  |  | 80-N | MC2 | 0 | NH | 0 |  | 90-N | PA | 0 | LV1 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 105-3 | PA | 0 | AB2 | 0
 |  |  |  |  |  | AT : | ME |  |  |  |  | 120-3 | PA | 0 | MC3 | 0
 |  |  |  |  |  | 105-2 | ME1 | 0 | MC2 | 0
 |  |  |  |  |  | 105-3 | ME2 | 0 | MC3 | 0 |  | AT : | SD
 |  |  |  |  |  |  |  |  |  |  |  | 105-1 | SD | 0 | AB1 | 0
 |  |  |  |  |  | AT : | NS |  |  |  |  | 120-2 | SD | 0 | MC2 | 0
 |  |  |  |  |  | 90-N | NS | 0 | [NAME] | 0 |  | 135 | SD | 0 | MC2 | 0
BYE TEAMS |  |  |  |  |  | 80-N | NS | 0 | PD | 0 |  | 80-N | SD | 0 | QK1 | 0
JR. MITEY MITE |  |  | LV2 |  |  |  |  |  |  |  |  | 90-N | SD | 0 | [NAME] | 0
Spreadsheet: 2ac6d40c-d724-4af7-acea-153e24be5b16
Sheet: Sheet1

Supplemental Table X. Primers used for strand-specific RT-PCR in this study. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
AGI no | [NAME] | Primer Name | Primer class | Primer sequence | Product length(bp)
At4g36920 | AP2 | AP2-B74F | FP2 | TGG CTG CAG ACA AAT GG | 233
 |  | AP2-B306R | RP2 | GTA ACC GAT GGA GGG AAA AAG
 |  | AP2-C52F | RP1 | CAG CCG CCG GAA ACA GTG AG | 58
 |  | AP2-C109R | FP1 | TTT CCG GGC AGC AGC AAC AT
At3g22890 | APS1 | APS1-B59F | FP2 | CAT GTC CGT GCC TAT TGT TCT C | 60
 |  | APS1-B118R | RP2 | GAC TCG CCG ATA CGT GCT TTT T
 |  | APS1-C98F | RP1 | TCC GCC GCC TCG TGT TTC TTC TC | 78
 |  | APS1-C175R | FP1 | CGC TCC CGA CGG TGG TAA G
AT5G41610(miR856 cleavage site) | CHX18 | [NAME] | FP1 | GATTTGCAGGGTGGGATTATG | 78
 |  | [NAME] | RP1 | CTTCGGGAACACAGCGTCTA
 |  | [NAME] | FP2 | TGTCCTGCTCCGATGAAAG | 78
 |  | [NAME] | RP2 | CGCAAGAGGTAACGCAAAGT
AT5G53950 | CUC2 | CUC2-A59F | FP1 | AACCAAGCTCTCCTTCCTCC | 82
 |  | CUC2-A140R | RP1 | GAGCAACTGCTGTCGGTGTA
 |  | CUC2-B23F | FP2 | ACTACTACGGCCTTGGGCTT | 90
 |  | CUC2-B112R | RP2 | AACGAAACGAGGAAAAGGGT
AT1G56010 | NAC1 | NAC1-A6F | FP1 | GAAGACTGGGTCTTGTGTAGGG | 118
 |  | NAC1-A123R | RP1 | GATCCATCAGTGGAGGAAGC
 |  | NAC1-B67F | FP2 | AAGATTCCATGCAAGAACCC | 80
 |  | NAC1-B146R | RP2 | CAGAATGAGTCGAGGCCTGT
At1g57820 | VIM1 | RING2-B28F | FP2 | CCA AAA CCC TAG CTT CCA CTC T | 182
 |  | RING2-B209R | RP2 | TTG CCT CAT CTT AGC TTT CTC TTC
 |  | RING2-C38F | RP1 | CAG GCG GAG GGT TGG ATT TG | 71
 |  | RING2-C108R | FP1 | GGC GCG TGA CAT CCA ACT CC
Spreadsheet: 161167d1339434465-time-tracking-excluding-nonworking-hours-vsm-correction-tracking
Sheet: GA

Graft Attach
Date | # of Lots through QC | Lot Number | Date/Time Discovered | Date/Time Resolved | Time to Resolve | Type of errors
2012-06-07 00:00:00 |  | TI1213604 | 2012-06-07 17:15:00 | 2012-06-08 08:00:00 | 14:45:00 | Missing OPID/Date
2012-06-08 00:00:00 | 2 |  |  |  | 1900-01-01 00:00:00
2012-06-11 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-12 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-13 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-14 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-15 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-16 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-17 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-18 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-19 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-20 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-21 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-22 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-23 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-24 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-25 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-26 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-27 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-28 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-29 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
2012-06-30 00:00:00 |  |  |  |  | 1900-01-01 00:00:00
 |  |  |  |  | 1900-01-01 00:00:00
Spreadsheet: ecdb71ad-6c61-48ad-b14c-be1f2366d246
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5204 | 30746 | Ernst | Scheiber | AUT | 0 | 00:24:37 | 00:01:53 | 01:03:13 | 00:02:02 | 00:36:42 | 1 | 02:08:27
5204 | 30299 | [NAME] | [NAME] | ESP | 0 | 00:23:19 | 00:01:25 | 01:12:05 | 00:01:01 | 00:31:47 | 2 | [NAME]
Spreadsheet: 598897d1542782354-check-duplicate-values-and-combine-cell-values-to-form-a-single-entry-calc
Sheet: Sheet1

1 | 12 | 2
1 | 32 | 3
1 | 12 | 4
2 | 12 | 4
4 | 23 | 2
5 | 34 | 3
5 | 34 | 3
6 | 56 | 6
6 | 67 | 7
6 | 78 | 7
7 | 78 | 8
8 | 67 | 9
67 | 56 | 5
67 | 67 | 5
67 | 89 | 7
67 | 99 | 7
87 | 23 | 2
76 | 34 | 2
54 | 45 | 5
32 | 45 | 5
24 | 45 | 5
24 | 45 | 5
Spreadsheet: 134689d1325578619-excel-2007-apply-change-formating-for-time-durations-m-ss-and-ss-formating-duration
Sheet: Sheet1

Duration (hh:[NAME]:ss)
0:54
0:47
1:13
0:08
12:19
1:05
0:07
12:52
0:47
0:04
4:59
0:06
4:20
1:24
0:08
0:03
0:04
0:32
6:05
1:29
0:21
0:20
1:12
4:32
0:55
0:43
0:43
0:41
1:10
0:20
0:02
1:40
1:13
0:35
1:59
0:14
0:08
1:03
0:33
0:15
1:40
0:26
0:04
0:54
0:51
0:46
0:24
1:07
0:52
0:27
0:21
1:45
4:49
1:29
0:34
11:42
5:38
2:19
0:51
0:52
0:27
1:37
0:50
0:04
0:03
0:04
1:58
1:02
0:03
3:34
14:07
0:17
0:39
1:10
0:41
0:21
0:36
1:21
2:58
0:53
0:55
0:44
0:04
0:02
0:01
1:21
0:02
0:03
1:37
0:39
1:42
1:55
0:15
1:05
6:43
0:22
0:48
1:09
2:12
0:10
1:00
2:45
0:57
0:49
0:35
0:47
1:39
2:26
2:10
2:27
0:48
0:24
0:38
0:03
0:18
9:56
0:30
3:33
5:46
1:44
3:49
1:42
0:02
0:02
0:05
0:05
0:25
2:15
1:42
4:02
8:59
0:03
0:01
0:39
0:20
3:07
1:20
1:08
1:11
0:05
0:02
0:05
0:13
0:03
0:54
3:51
0:10
1:22
0:18
0:55
1:44
0:15
0:17
3:20
1:14
0:26
0:15
0:56
0:27
0:03
0:02
0:58
1:49
3:30
0:12
0:04
7:38
1:03
0:21
4:25
1:17
0:52
3:30
3:35
0:59
1:02
1:50
0:07
1:04
0:09
0:10
0:58
2:26
8:42
14:50
0:30
0:20
0:22
1:06
1:22
1:24
0:36
0:36
0:07
0:29
0:53
3:58
0:05
0:06
1:01
0:49
0:48
2:04
0:42
2:08
0:45
1:19
0:50
0:12
1:13
0:39
0:26
0:26
0:55
2:07
1:09
0:46
0:07
0:14
1:00
6:34
0:59
0:03
0:03
0:45
4:30
8:29
1:30
11:10
0:45
3:50
0:03
0:04
0:56
0:36
0:05
0:06
0:27
3:45
0:26
5:01
2:53
0:18
0:09
0:06
1:27
0:36
0:37
3:27
0:29
1:50
1:20
0:21
0:03
2:29
2:54
0:35
1:56
1:46
1:11
0:54
0:39
3:37
8:22
3:05
0:42
2:59
6:12
1:07
2:18
0:29
5:36
0:39
1:10
0:18
0:35
3:11
1:56
1:03
0:03
0:03
0:26
1:22
0:34
2:03
0:47
0:14
3:10
0:59
0:28
0:47
0:46
0:04
0:19
0:57
1:05
3:00
0:08
0:06
2:46
0:19
0:55
0:02
2:01
0:54
0:41
0:17
0:06
0:04
0:55
0:15
0:38
0:05
1:27
0:25
2:21
0:10
0:09
0:39
2:57
0:08
0:05
0:37
3:05
Spreadsheet: 812641d1673293402-formula-to-return-a-value-with-a-variable-date-range-and-multiple-criteria-2022-12-21-active-timesheet-data-payroll-tracker-lorie-wip2
Sheet: 2023 Active Employees

Employee Code | Employee First Name | Employee Last Name | Position  Hired For | Home Province | Location Hired For | Field Rate - HR1 | [NAME] | CELL BONUS @15.00
 | [NAME] | Apple | ADMIN - P/T | SK | SK | 20 | 20 | Y
 | Brent | [NAME] | FIELD SUP | AB | MGMT | 38 | 30 | N
 | Troy | Orange | DRILLER ML - HVAC | SK | sk | 30 | 25 | Y
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31561

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20090108 | 2009-01-08 | 2009 | 1 | 47995 | Diamond cutter DCH 300 110V | 1 | 408.1 | 132070 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 93.75 | 133241 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.5199999999999 | 133241 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133241 | 31561
20090223 | 2009-02-23 | 2009 | 2 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 48.6099999999999 | 133241 | 31561
20090119 | 2009-01-19 | 2009 | 1 | 370101 | Battery pack SFB 185 | 1 | 89.8599999999999 | 132370 | 31561
20090303 | 2009-03-03 | 2009 | 3 | 370101 | Battery pack SFB 185 | 1 | 89.8599999999999 | 133475 | 31561
Spreadsheet: 714201d1611140137-creating-rows-in-another-sheet-based-on-data-one-sheet-problem-2-ans
Sheet: Sheet1

 | STATION | P1 | P2 | P3 | P4 | P5 | P6 | TOTAL |  |  | STATION | P1 | P2 | P3 | P4 | P5 | P6 | TOTAL |  | STATION | P1 | P2 | P3 | P4 | P5 | P6 | TOTAL
 | NOIDA |  |  |  |  |  |  |  |  |  | DELHI |  |  |  |  |  |  |  |  | NOIDA | 330 | 650 | 790 | 650 | 530 | 200 | 3150
Spreadsheet: 49211d1248450178-sumif-text-and-values-exampleexcel2
Sheet: Sheet3

Sprint PCS Vision Connection Card $72 Plan with Discount        70MB | ADM Alliance Nutrition Account [PHONE] 0 | [NAME] To | This Month's Charge
Igo, Erwin | MDN [PHONE] ESN HEX 6021E552 ESN DEC [PHONE] | F310015 1750 50 | 73.34
Manning, [NAME] | MDN [PHONE] | F300002 1750 33 | 185.49
[NAME], [NAME] | MDN [PHONE] | F300003 1750 33 | 310.15
[NAME], [NAME] | MDN [PHONE] | F310066 1750 32 | 310.15
Myers, [NAME] | MDN [PHONE] ESN-Hex: 5b0cbdff  ESN_DEC:  [PHONE]          MDIS [PHONE] | OCP5100 1750 50 | 73.33
[NAME], Bob-- was IS loaner | MDN [PHONE] MSID - [PHONE] MSL - 943995 | OCP5200  1750 50 | 73.33
[NAME], [NAME] | MDN [PHONE]            ESN 5BOCE1E6 | OCP5200  1750 50 | 73.33
IS LOANER #4, WAS helpdesk loaner 2 | MDN [PHONE]  MSID - [PHONE]  MSL - 214489 pn#1200718 | OIS5050 1750 50 | 73.33
IS LOANER #1 | MDN [PHONE] MSID [PHONE] MSL 347637 | OIS5050 1750 50 | 73.34
IS LOANER #2 | MDN [PHONE] MSID - [PHONE]     MSL -759432 | OIS5050 1750 50 | 73.34
IS LOANER #3 | MDN [PHONE] ESN HEX 6032334E ESN DEC [PHONE] | OIS5050 1750 50 | 73.34
Linger, [NAME] | MDN [PHONE] MSID [PHONE] ESN HEX 5B06D18F ESN DEC [PHONE] Lock Code 009444 | OMF1500 1750 10 | 73.34
[NAME], Jim- was [NAME] | MDN [PHONE] MSID [PHONE] ESN DEC [PHONE] ESN HEX 5B078C88 | OMF1500 1750 10 | 73.34
Jones, [NAME] | MDN [PHONE] | OMF1500 1750 10 | 338.95
[NAME] returned for redeploy 5/11/06 | MDN [PHONE] MSID [PHONE] Lock Code 709460 | OPM3710 1750 35 | 0
Reynolds, [NAME] | MDN [PHONE] Lock Code 385118 MSID [PHONE] | OPM3740 1750 35 | 73.34
Stuever, [NAME] | MDN [PHONE] MSID [PHONE] ESN HEX 5B070783 ESN DEC [PHONE] Lock Code 153726 | [NAME] 1750 35 | 73.34
[NAME], [NAME] | MDN [PHONE]  ESN-Hex: 5boca398                   MDIS [PHONE] | OPM3900 1750 35 | 73.33
[NAME] | MDN [PHONE] ESN DEC [PHONE] ESN HEX 5B03D488 MSID [PHONE] Lock Code 119296 | OPM3900 1750 35 | 0
Sifri, Mamduh | MDN [PHONE] | OPM3900 1750 35 | 310.15
[NAME] (return for redeploy) | MDN [PHONE] MSID [PHONE] Lock Code 499863 ESN DEC [PHONE] ESN HEX 5B067677 | OPM3900 1750 35 | 0
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Midway-Fri

Hour |  |  |  |  |  |  | Linked Data
Ending
Pacific | Midway physical | (PSCO)CSU | WAPA(CSU) | TSGT | (PSCO)CSU | (PSCO)CSU | To CSU | To San Juan | WAPA |  | Balance
Standard | position | Purch | Purch | Purch | Purch | Purch | Call Option | WAPA trans | Sale
(PST)
 |  | 30 | 35 | 34 | 35 | 40 | 28.9245
100 | 0
200 | 0
300 | 0
400 | 0
500 | 0
600 | 0 | 45 | 25
700 | 0 |  | 25 | 25 | 50 | 25
800 | 0 |  | 25 | 25 | 50 | 25
900 | 0 |  | 25 | 25 | 50 | 25
1000 | 0 |  | 25 | 25 | 50 | 25
1100 | 0 |  | 25 | 25 | 50 | 25
1200 | 0 |  | 25 | 25 | 50 | 25
1300 | 0 |  | 25 | 25 | 50 | 25
1400 | 0 |  | 25 | 25 | 50 | 25
1500 | 0 |  | 25 | 25 | 50 | 25
1600 | 0 |  | 25 | 25 | 50 | 25
1700 | 0 |  | 25 | 25 | 50 | 25
1800 | 0 |  | 25 | 25 | 50 | 25
1900 | 0 |  | 25 | 25 | 50 | 25
2000 | 0 |  | 25 | 25 | 50 | 25
2100 | 0 |  | 25 | 25 | 50 | 25
2200 | 0 |  | 20 | 25 | 50 | 25
2300 | 0
2400 | 0
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: andy_zipper__133__ICE - Mar01 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME |  |  | TRANSACTIONS
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-1-01 thru Mar-1-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for GDM
 | NG Fin BS, LD1 for GDM - Mich - Apr01-Oct01 | Apr01-Oct01 | 0.235 | 0.235 | 0.235 | 0.235 | Mar-01-01 15:28 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - TCO - Apr01-Oct01 | Apr01-Oct01 | 0.23 | 0.23 | 0.23 | 0.23 | Mar-01-01 15:05 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF - NNG-Demarc - Apr01-Oct01 | Apr01-Oct01 | 0.043 | 0.043 | 0.043 | 0.043 | Mar-01-01 14:54 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for NGI
 | NG Fin BS, LD1 for NGI - Socal - Apr01 | Apr01 | 6.05 | 6.05 | 6.05 | 6.05 | Mar-01-01 16:37 GMT | 150000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5.075 | 5.163 | 5.124 | 5.1 | Mar-01-01 20:11 GMT | 2385000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 5.135 | 5.27 | 5.197 | 5.18 | Mar-01-01 20:45 GMT | 7500000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.288 | 5.29 | 5.289 | 5.288 | Mar-01-01 19:43 GMT | 4280000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Cal 02 | Cal 02 | 4.765 | 4.775 | 4.772 | 4.765 | Mar-01-01 18:39 GMT | 5475000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Cal 03 | Cal 03 | 4.475 | 4.48 | 4.478 | 4.48 | Mar-01-01 19:22 GMT | 3650000 | MMBtus
Spreadsheet: 865070d1712151199-replace-duplicates-sample-2
Sheet: Sheet1

 |  | #organic inspire E150 - B&C - WHT|XS-2XL - TU01B | 2.81 | 8.711
 |  | #organic inspire E150 - B&C - WHT|3XL-5XL - TU01B | 3.51 | 10.881
 |  | #organic inspire E150 - B&C - COL|XS-2XL - TU01B | 2.81 | 8.711
 |  | #organic inspire E150 - B&C - COL|3XL-5XL - TU01B | 3.51 | 10.881
 |  | #organic inspire E150 /women - B&C - WHT|XS-2XL - TW02B | 2.81 | 8.711
 |  | #organic inspire E150 /women - B&C - WHT|3XL - TW02B | 3.51 | 10.881
 |  | #organic inspire E150 /women - B&C - COL|XS-2XL - TW02B | 2.81 | 8.711
 |  | #organic inspire E150 /women - B&C - COL|3XL - TW02B | 3.51 | 10.881
 |  | Rhine 16x22 Wash Glove - SG ACCESSORIES -TOWELS - COL|One - TO3502 | 0.5 | 1.55
 |  | Seine 50x100 [NAME] ACCESSORIES -TOWELS - WHT|One - TO5503 | 3.84 | 11.904
 |  | Seine 50x100 [NAME] ACCESSORIES -TOWELS - COL|One - TO5503 | 3.92 | 12.152
 |  | Original Pull-On Beanie - Beechfield - COL|One - B44 | 1.32 | 4.092000000000001
 |  | Original Pull-On Beanie - Beechfield - MAR|One - B44 | 1.42 | 4.401999999999999
 |  | Seine 70x140 BathTowel - SG ACCESSORIES -TOWELS - WHT|One - TO5504 | 8.02 | 24.862
 |  | Seine 70x140 BathTowel - SG ACCESSORIES -TOWELS - COL|One - TO5504 | 8.67 | 26.877
 |  | [NAME] Wicking Polo - Regatta Professional - COL|XS-3XL - TRS147 | 7.74 | 23.994
 |  | Seine 40x60 [NAME] ACCESSORIES -TOWELS - WHT|40X60 - TO5505 | 2.17 | 6.727
 |  | [NAME] ACCESSORIES -TOWELS - WHT|30X50 - TO5505 | 1.77 | 5.487
 |  | Seine 40x60 [NAME] ACCESSORIES -TOWELS - COL|40X60 - TO5505 | 2.27 | 7.037000000000001
 |  | [NAME] ACCESSORIES -TOWELS - COL|30X50 - TO5505 | 1.87 | 5.797000000000001
 |  | Contrast [NAME] | 7.74 | 23.994
 |  | [NAME] | 24.24 | 75.14399999999999
 |  | Baby Reversible Hat - BabyBugz - COL|6-12 to 2-3y - BZ44 | 2.71 | 8.401
 |  | Seine 100x180 Beach Towel - SG ACCESSORIES -TOWELS - WHT|100X180 - TO5506 | 13.85 | 42.935
 |  | [NAME] Towel - SG ACCESSORIES -TOWELS - WHT|100X150 - TO5506 | 13.28 | 41.168
 |  | Seine 100x180 Beach Towel - SG ACCESSORIES -TOWELS - COL|100X180 - TO5506 | 13.83 | 42.873
 |  | [NAME] Towel - SG ACCESSORIES -TOWELS - COL|100X150 - TO5506 | 13.35 | 41.385
 |  | [NAME] [NAME] | 27.15 | 84.16499999999999
 |  | Tiber 50x100 [NAME] ACCESSORIES -TOWELS - WLB|One - TO5001 | 4.14 | 12.834
 |  | Tiber 50x100 [NAME] ACCESSORIES -TOWELS - COL|One - TO5001 | 4.34 | 13.454
 |  | [NAME] [NAME] | 32.99 | 102.269
Spreadsheet: 131075d1322727771-automatic-data-insertion-803727-automatic-data-insertionmy-examplecalc
Sheet: Daily portions

 | Measurement |  |  |  | Calories | Protein | Carbohydrate | Carbs as Sugars | Fat | Fats as Saturates | Fibre | mono-unsaturates | polyunsaturates | Salt | Salt as Sodium
Special Drink | 250
Special Drink | 100
GDA | 250
Special Drink | 250
Milk | 200
Potatoes Mashed | 200
Special Drink | 250 |  | (2) |  | 250 | 14 | 35 | 31 | 2.5 | 0.4 | 4 | 0 | 0 | 0 | 0.24
Special Drink | 100 |  | (3) |  | 100 | 5.600000000000001 | 14 | 12.4 | 1 | 0.16 | 1.6 | 0 | 0 | 0 | 0.09599999999999999
Potatoes Mashed | 200 |  |  |  | 197 | 3.6 | 26.5 |  | 8.1 |  | 3
GDA | 250 |  |  |  | 2500 | 55 | 300 | 120 | 95 | 300 | 24 |  |  | 2.4 | 6
Milk | 200 |  |  |  | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
 | Row 2 - OK
 | Row 3 - OK
 | Row 4 - Value is 10% for some reason.
 | Row 7 - OK
 | Row 9 - Calculated values not correct
 | Row 8 -  I added an item to sheet 1 'Foods'. This is added to drop down list in column A, but returns error in cells.
 | Note: Rows 21 to 25 are copies of items on sheet 1 just for easy reference to compare values as they should appear in calculated rows.
Spreadsheet: 249909d1373655508-get-total-quantity-of-parts-that-match-list-example-multiple-lookup-criteria
Sheet: Parts List

COMP_2D | COMP_3D | COMP_4D | COMP_6D
02P14017 | 02P14029 | 02P14231 | 02P14185
02P14020 | 02P14050 | 02P14233 | 02P14187
02P14002 | 02P14053 | 02P14230 | 02P14225
02P14008 | 02P14061 | 02P14232 | 02P14190
02P14023 | 02P14090 | 02P14234 | 02P14181
02P14005 | 02P14094 | 02P14237 | 02P14183
02P14011 | 02P14041 | 02P14141 | 02P14205
02P14014 | 02P14096 | 02P14162 | 02P14201
 | 02P14099 | 02P14159 | 02P14213
 | 02P14114 | 02P14170 | 02P14215
 | 02P14127 | 02P14172 | 02P14217
 | 02P14132 | 02P14161 | 02P14221
 | 02P14059 | 02P14137 | 02P14227
 | 02P14088 | 02P14146 | 02P14229
 | 02P14092 | 02P14136 | 02P14192
 | 02P14111 | 02P14145 | 02P14193
 | 02P14124 | 02P14173 | 02P14195
 | 02P14129 | 02P14134 | 02P14197
 | 02P14026 | 02P14143 | 02P14203
 | 02P14076 | 02P14166 | 02P14179
 | 02P14079 | 02P14164
 | 02P14038 | 02P14168
 | 02P14082 | 02P14175
 | 02P14085 | 02P14177
 | 02P14056 | 02P14148
 | 02P14070 | 02P14149
 | 02P14073 | 02P14151
 | 02P14102 | 02P14152
 | 02P14105 | 02P14154
 | 02P14108 | 02P14155
 |  | 02P14157
 |  | 02P14139
Spreadsheet: 157964d1337939568-multiple-lookups-from-another-tab-sample1
Sheet: emp1

 |  | Payroll number |  | ABC123
 | Previous Record:
 | Any previous disciplinary records are shown below:
 | ABC123 | [NAME] | 2012-05-20 00:00:00 | 2012-11-23 00:00:00 | 2nd Written warning | 6 months | Issue 2
 | ABC123 | [NAME] | 2012-05-24 00:00:00 | 2012-08-23 00:00:00 | 1st Written warning | 3 months | Issue 2
 | Using this number as the criteria
 | Find all occurances on the "Home Page" tab
 | Copy the results to here
Spreadsheet: 44446d1243075805-extract-duplicates-book1
Sheet: Sheet1

A | B | C | D |  | 1 | 1 | 0
B | D | E | F | B | 1 | 1 | 1
G | H | I | K |  | 0 | 0 | 1
I | A | B | D |  | 0 | 1 | 0
M | N | J | B |  | 0 | 0 | 0
D | B | A | C | D | 1 | 1 | 1
M | N | D | G |  | 0 | 0 | 0
Spreadsheet: 676893d1589042152-pick-up-values-and-list-in-overview-list
Sheet: Blad1

 | item |  |  |  |  | item
 | E125 | E123 | E126 | E127 | E128 | E129 | E130 | E131 | E136 | E150 | E146
ALFA
QTY |  | 4 | 4 | 1 |  | 3 | 4 | 14 | 10
VALUE |  | 13090 | 13090 | 3272 |  | 11319 | 15092 | 52822 | 37730
Example:
find qty of item E123 (C2) in document "kundstat ALFA"
find value of item E123 (C2) in document "kundstat ALFA"
problem I have is that the file where to pick up values can have date in different locations