tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 622880d1556967556-create-one-master-list-from-lists-on-multiple-worksheets-excel-forum-example-create-one-list-from-multiple-sheets
Sheet: MASTER LIST

ID | Description
72193 | List 1 Description 1 | List 1
125823 | List 1 Description 2
125824 | List 1 Description 3
133099 | List 1 Description 4
243049 | List 1 Description 5
243050 | List 1 Description 6
243051 | List 1 Description 7
243052 | List 1 Description 8
243054 | List 1 Description 9
243055 | List 1 Description 10
8842298 | List 1 Description 11
8843293 | List 1 Description 12
8843666 | List 1 Description 13
8844083 | List 1 Description 14
9971099 | List 2 Description 1 | List 2
9971101 | List 2 Description 2
9971429 | List 2 Description 3
9962347 | List 2 Description 4
9962032 | List 2 Description 5
9962241 | List 2 Description 6
9971488 | List 2 Description 7
9970412 | List 2 Description 8
9970954 | List 2 Description 9
9972091 | List 2 Description 10
9972092 | List 2 Description 11
9970285 | List 2 Description 12
9970333 | List 2 Description 13
9970370 | List 2 Description 14
9970371 | List 2 Description 15
9970372 | List 2 Description 16
9970373 | List 2 Description 17
9970391 | List 2 Description 18
9970607 | List 2 Description 19
9970608 | List 2 Description 20
9970610 | List 2 Description 21
9970718 | List 2 Description 22
9970720 | List 2 Description 23
9970908 | List 2 Description 24
9970934 | List 2 Description 25
9970936 | List 2 Description 26
9971097 | List 2 Description 27
9971126 | List 2 Description 28
UA-3740 | List 3 Description 1 | List 3
UA-3738 | List 3 Description 2
UA-3737 | List 3 Description 3
UA-3739 | List 3 Description 4
UA-3765 | List 3 Description 5
UA-3766 | List 3 Description 6
UA-3763 | List 3 Description 7
UA-3764 | List 3 Description 8
UA-3768 | List 3 Description 9
UA-3762 | List 3 Description 10
UA-3761 | List 3 Description 11
UA-3767 | List 3 Description 12
UA-3732 | List 3 Description 13
UA-3733 | List 3 Description 14
UA-3734 | List 3 Description 15
UA-3731 | List 3 Description 16
UA-102524 | List 3 Description 17
UA-102523 | List 3 Description 18
UA-3736 | List 3 Description 19
UA-3735 | List 3 Description 20
UA-3828 | List 3 Description 21
UA-3831 | List 3 Description 22
UA-3829 | List 3 Description 23
UA-4625 | List 3 Description 24
UA-4626 | List 3 Description 25
UA-4624 | List 3 Description 26
UA-4911 | List 3 Description 27
UA-102504 | List 3 Description 28
UA-102233 | List 3 Description 29
UA-102505 | List 3 Description 30
UA-102234 | List 3 Description 31
UA-4914 | List 3 Description 32
UA-102502 | List 3 Description 33
UA-4562 | List 3 Description 34
UH-11082 | List 3 Description 35
UA-3775 | List 3 Description 36
75115 | List 4 Description 1 | List 4
75191 | List 4 Description 2
75691 | List 4 Description 3
75692 | List 4 Description 4
75393 | List 4 Description 5
75077 | List 4 Description 6
31307 | List 4 Description 7
32286 | List 4 Description 8
32899 | List 4 Description 9
Spreadsheet: 43644d1242288577-how-to-key-a-formula-to-compute-the-due-date-jn8-19
Sheet: PastDue

[NAME], Inc.
Past Due Accounts
Invoice No. | Amount Due | Invoice Date | Due Date | Days Late | 2nd Notice | If you want to be fancy
KK101 | 1000 | 2009-01-01 00:00:00 | 2009-01-31 00:00:00 | 103 |  | 103
KK120 | 2000 | 2009-02-01 00:00:00 | 2009-03-03 00:00:00 | 72 |  | 72
[NAME] | 23500 | 2009-03-01 00:00:00 | 2009-03-31 00:00:00 | 44 |  | 44
KK154 | 4500 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 13 |  | 13
KK201 | 20000 | 2009-04-14 00:00:00 | 2009-05-14 00:00:00 | 0 |  | 0
[NAME] | 45000 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 0 |  | -48
KK307 | 39000 | 2009-07-01 00:00:00 | 2009-07-31 00:00:00 | 0 |  | -78
KK338 | 535 | 2009-08-01 00:00:00 | 2009-08-31 00:00:00 | 0 |  | -109
[NAME] | 7745 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 0 |  | -140
[NAME] | 2545 | 2009-10-01 00:00:00 | 2009-10-31 00:00:00 | 0 |  | -170
[NAME] | 8450 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 0 |  | -201
KK490 | 15575 | 2009-12-01 00:00:00 | 2009-12-31 00:00:00 | 0 |  | -231
Spreadsheet: 155161d1336690348-statistics-problem-generate-trial-data-excel-forum-heteroskedastic
Sheet: 1

Input Data |  |  |  |  |  |  |  |  |  |  |  |  | Simulated Data Output - Lognormal
Year | Point Estimate (Mean Value) | Minus 1 Standard Deviation | Plus 1 Standard Deviation |  |  |  |  |  |  |  |  |  | Year | Trial 1 | Trial 2 | Trial 3
1 | 3 | 2 | 4 |  |  |  |  |  |  |  |  |  | 1
2 | 5 | 4 | 7 |  |  |  |  |  |  |  |  |  | 2
3 | 7 | 5 | 8 |  |  |  |  |  |  |  |  |  | 3
4 | 10 | 6 | 12 |  |  |  |  |  |  |  |  |  | 4
5 | 16 | 11 | 19 |  |  |  |  |  |  |  |  |  | 5
6 | 24 | 20 | 27 |  |  |  |  |  |  |  |  |  | 6
7 | 22 | 20 | 26 |  |  |  |  |  |  |  |  |  | 7
8 | 29 | 25 | 34 |  |  |  |  |  |  |  |  |  | 8
9 | 35 | 30 | 41 |  |  |  |  |  |  |  |  |  | 9
10 | 40 | 35 | 50 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | Example Output:
 |  |  |  |  |  |  |  |  |  |  |  |  | Year | Trial 1 | Trial 2 | Trial 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 4.196327969029048 | 0.456477751438001 | 4.065262511421833
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7.607204729168712 | 0.8041440357849075 | 8.337343982331733
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 8.822277362550222 | 8.395502610462145 | 5.712391408033618
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 13.69753133184609 | 0.1713262717142165 | 12.65485675777519
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 30.35524948184185 | 10.1830481760327 | 4.407394289973016
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 23.12498353757692 | 38.98674743226884 | 40.49782514555993
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 18.09409591142277 | 22.77474050961455 | 37.77232569955957
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 41.3370550467293 | 42.91858105219432 | 39.3697858896069
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 28.31308407501567 | 45.04068348353692 | 23.77443500417312
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 72.07211669632562 | 40.3580315709894 | 49.36270214886378
Spreadsheet: 782214d1653910507-formula-to-get-data-horizontal-with-collumn-name-example-v3-1-
Sheet: Sheet2

interface | ipv4 | shutdown | voice_vlan | DHCP_Option | description | allowed_vlan | native_vlan | Cisco int. | Macro | Command_INT | Command_macro | Port_config_apply
Bridge-Aggregation1 |  |  |  |  |  |  |  | veld1 | M1
NULL0 |  |  |  |  |  |  |  | veld2 | M2
Vlan-interface1 |  |  |  |  |  |  |  | veld3 | M3
Vlan-interface11 |  |  |  |  | mgmt |  |  | veld4 | M4
GigabitEthernet1/0/1 |  |  | 1111 |  | DES1 | 1111 | 1111 | G1/0/2 | M4
GigabitEthernet1/0/2 |  |  | 1111 |  | DES2 | 1111 | 1111 | G1/0/1 | M4
GigabitEthernet1/0/3 |  |  | 1111 |  | [NAME] | 1111 | 1111 | G1/0/4 | M4
GigabitEthernet1/0/4 |  | shutdown | 1111 |  | DES4 | 1111 | 1111 | G1/0/3 | M4
GigabitEthernet1/0/5 |  | shutdown | 1111 |  | DES5 | 1111 | 1111 | G1/0/6 | M4
GigabitEthernet1/0/6 |  |  | 1111 |  | DES6 | 1111 | 1111 | G1/0/5 | M4
GigabitEthernet1/0/7 |  |  | 1111 |  | DES7 | 1111 | 1111 | G1/0/8 | M4
GigabitEthernet1/0/8 |  |  | 1111 |  | DES8 | 1111 | 1111 | G1/0/7 | M4
GigabitEthernet1/0/9 |  |  | 1111 |  | DES9 | 1111 | 1111 | G1/0/10 | M4
GigabitEthernet1/0/10 |  |  | 1111 |  | DES10 | 1111 | 1111 | G1/0/9 | M4
GigabitEthernet1/0/11 |  |  | 1111 |  | DES11 | 1111 | 1111 | G1/0/12 | M4
GigabitEthernet1/0/12 |  |  | 1111 |  | DES12 | 1111 | 1111 | G1/0/11 | M4
GigabitEthernet1/0/13 |  |  | 1111 |  | DES13 | 1111 | 1111 | G1/0/14 | M4
GigabitEthernet1/0/14 |  |  | 1111 |  | DES14 | 1111 | 1111 | G1/0/13 | M4
GigabitEthernet1/0/15 |  | shutdown | 1111 |  | DES15 | 1111 | 1111 | G1/0/16 | M4
Spreadsheet: 786572d1657282122-spaties-wissen-toevoegen-aan-formule-voorbeeld-bestand
Sheet: Blad1

Onderstaande index komt uit kolom A tabblad objecten
[NAME] bijvoorbeeld A ook met en zonder spatie terugkomen. |  |  |  |  |  | ALS ik de spaties wissen ervoor zet, [NAME] doortrek naar benden komt er overal A te staan.
Ik wil voorkomen dat A dubbel voorkomt in de Index.
En ook deze gegeven weer gebruiken voor [NAME] voor het resultaat in rij B.
Hoe kan ik de spaties wissen in kolom A binnen de fomule die nu gebruikt wordt om de index te maken ?
Spreadsheet: 108669d1305685723-best-match-lookup-example-looup
Sheet: Entry_Results

Entry/Results |  |  |  |  |  |  |  | Lookup Table |  |  |  |  |  |  |  | [NAME]=Value
UPC | Result | Color | Size |  |  |  |  | UPC | Style # | Color | Size |  |  |  |  | Size | Value
34758759088 | True | BLACK | Small |  |  |  |  | 34758759088 | 824041 | BLACK | Small |  |  |  |  | Small | 2
34758853861 | Small | BLACK | Large |  |  |  |  | 34758853861 | 824041 | BLACK | Large |  |  |  |  | Large | 3
84971752182 | Medium | BROWN | Large |  |  |  |  | 84971752182 | 1P32024 | BROWN | Large |  |  |  |  | XXLarge | 4
84971751574 | Medium | BROWN | Small |  |  |  |  | 84971751574 | 1P32024 | BROWN | Small |  |  |  |  | Medium | 1
84971743791 | Medium | BROWN | XXLarge |  |  |  |  | 84971743791 | 1P32024 | BROWN | XXLarge
58665738738 | Small | BLACK | XXLarge |  |  |  |  | 58665738738 | 824041 | BLACK | XXLarge
58665738745 | True | BROWN | Medium |  |  |  |  | 58665738745 | 1P32024 | BROWN | Medium
731517834191 | True | Red | XXLarge |  |  |  |  | 731517834191 | 91295 | Red | XXLarge
What I've been working on
UPC | Style # | Color | Size | Size=Value
34758759088
34758853861
84971752182
84971751574
84971743791
58665738738
58665738745
731517834191
Spreadsheet: 206653d1358248676-extracting-text-numbers-form-varying-source-data-book1
Sheet: Sheet1

Source data | 001-code | :-code
LP552/ATM506;3;40;001362344;VLANP799;39;119 |  | 119:39
001362344;VLANP799;3923;11;ED |  | 11:3923
001362344;VLANP799;390;19 |  | 19:390
001362344;VLANP799;390;19; |  | 19:390
LP552/ATM506;3;40;001362344;VLANP799;39;119; |  | 119:39
LP552/ATM506;3;40;001362344;VLANP799;39;119;ED |  | 119:39
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 33733
 | Loans | 107
 | Municipal | 107
 | Recovery | 107
 | Sovereign | 2174
Index Tranche | Asia | <100
 | Europe | <100
 | North America | <100
Index | Asia | 155
 | Europe | 3570
 | North America | 3095
TOTAL |  | 43048
Estimated swap transaction volumes, week ending January 25, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
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 Data Dictionary for product 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: 92033d1291711462-excel-2007-find-duplicates-with-different-formatting-finddups
Sheet: LIST CHANGES DAILY

COMPANY | LIST CHANGES DAILY | A | B | C | D | E
 | ABBATT JOSHUA TOM | ** | SC | 2011-08-01 00:00:00 | 2017-06-16 00:00:00 | 2012-04-15 00:00:00
 | [NAME] | ** | ** | 2011-08-01 00:00:00 | 2018-09-13 00:00:00 | 2011-08-11 00:00:00
 | SADAMS MACK SHAWN | SC | SC | 2011-08-01 00:00:00 | 2016-12-03 00:00:00 | 2012-04-14 00:00:00
 | ABRHAMS MACKENZIE SAM | ** | SC | 2011-08-01 00:00:00 | 2017-02-25 00:00:00 | 2012-04-20 00:00:00
 | ALEXANDER MAGGIE N | ** | SC | **2011/08/01 | 2016-05-28 00:00:00 | 2012-05-04 00:00:00
 | ALEX [NAME] | ** | SC | 2011-08-01 00:00:00 | 2017-07-13 00:00:00 | 2012-06-06 00:00:00
 | ALFORD NATHANIEL [NAME] | SC | SC | 2011-08-01 00:00:00 | 2017-07-29 00:00:00 | 2012-02-02 00:00:00
 | ALLEN EAVIAN DIMITRI | ** | ** | 2011-08-01 00:00:00 | 2020-04-04 00:00:00 | 2012-10-03 00:00:00
 | ALLEN GENEVIEVE MIREILLE | ** | SC | 2011-08-01 00:00:00 | 2017-03-16 00:00:00 | 2012-04-14 00:00:00
 | [NAME] | SC | SC | 2011-08-01 00:00:00 | 2017-04-14 00:00:00 | 2012-04-12 00:00:00
 | SNAPPLEBY KEN J | SC | SC | 2011-08-01 00:00:00 | 2013-05-05 00:00:00 | *2010/09/05
 | CAMBROISE MANUEL J | ** | SC | 2011-08-01 00:00:00 | 2014-06-01 00:00:00 | 2011-08-05 00:00:00
 | SANDERSON JACK SCOTT | SC | SC | 2011-08-01 00:00:00 | 2016-06-13 00:00:00 | 2012-05-11 00:00:00
 | ASHANTY SHASE HAILE | SC | SC | 2011-08-01 00:00:00 | 2017-06-05 00:00:00 | 2012-05-11 00:00:00
 | SANDERSON MITCHELL LATRAK | SC | SC | 2011-08-01 00:00:00 | 2017-01-08 00:00:00 | 2012-04-12 00:00:00
 | ANDREWS TROY WOODROW | SC | SC | 2011-08-01 00:00:00 | 2018-08-12 00:00:00 | 2011-08-05 00:00:00
 | APPLEBY [NAME] | SC | SC | 2011-08-01 00:00:00 | 2014-02-21 00:00:00 | 2012-04-18 00:00:00
 | ARNAD DENNY A | SC | SC | **2010/08/01 | 2016-05-06 00:00:00 | 2012-04-19 00:00:00
 | [NAME] SAYERS | SC | SC | 2011-08-01 00:00:00 | 2018-05-18 00:00:00 | 2012-05-11 00:00:00
 | ALEXANDER MAGGIE N | SC | SC | 2011-08-01 00:00:00 | 2020-05-31 00:00:00 | 2011-08-07 00:00:00
 | [NAME] | SC | SC | 2011-08-01 00:00:00 | 2016-08-27 00:00:00 | 2012-05-11 00:00:00
 | RAUMBACH SAUL FITZ | SC | SC | **2011/08/01 | 2018-07-21 00:00:00 | 2011-04-29 00:00:00
 | SASKEW SCOTT DAN | SC | SC | 2011-08-01 00:00:00 | 2014-08-30 00:00:00 | *2010/09/23
 | FABIN MATT T | ** | SC | 2011-08-01 00:00:00 | 2019-01-21 00:00:00 | 2012-04-14 00:00:00
 | TACCAIRE NICK ADAM | SC | SC | 2011-08-01 00:00:00 | 2016-06-13 00:00:00 | 2012-05-11 00:00:00
 | SHAER PHIL RYAN | SC | SC | 2011-08-01 00:00:00 | 2017-06-05 00:00:00 | 2012-05-11 00:00:00
 | SANKS [NAME] | SC | SC | 2011-08-01 00:00:00 | 2017-01-08 00:00:00 | 2012-04-12 00:00:00
 | TANKS BRITT NICKY | SC | SC | 2011-08-01 00:00:00 | 2018-08-12 00:00:00 | 2011-08-05 00:00:00
 | BAPTISTE MARK H | SC | SC | 2011-08-01 00:00:00 | 2014-02-21 00:00:00 | 2012-04-18 00:00:00
Spreadsheet: 140063d1328614501-massive-if-together-with-date-formula-microsoft-excel-worksheet
Sheet: Sheet1

Year: | 4 |  |  |  |  |  |  |  |  | 4
 |  |  | Question is how to make date of return have fixed month and day |  |  |  |  |  |  | 5
Date of issue: |  |  | but change year depending on the year |  |  |  |  |  |  | L6
Required date of return: |  |  | 4 = +4 years |  |  |  |  |  |  | U6
 |  |  | 5 = +3 years
 |  |  | L6 = +2 yers
 |  |  | U6 = +1 year
 |  |  | This also only applies if today's date is not more that 31 december, because if
 |  |  | it is january, than;
 |  |  | 4 = +3 years
 |  |  | 5 = +2 years
 |  |  | L6 = +1 year
 |  |  | U6 = same year
Spreadsheet: 144507d1331010563-generate-report-of-count-of-unique-occurences-of-data-for-each-column-sales
Sheet: results

JAN |  |  |  | FEB
Unique | Count | Total |  | Unique | Count | Total
1 | 4 | 4 |  | 1 | 8 | 8
2 | 4 | 8 |  | 2 | 10 | 20
3 | 4 | 12
5 | 1 | 5
9 | 1 | 9
Spreadsheet: 83171d1283216916-conncurrent-call-counter-sample
Sheet: Sheet1

Start Date/Time | End Date/Time | Site Code 1 | Concurrent Call Count
2010-07-26 12:53:44 | 2010-07-26 12:54:51 | AL006
2010-07-19 12:52:01 | 2010-07-19 12:53:14 | CT014
2010-07-21 09:32:56 | 2010-07-21 09:36:27 | CT014
2010-07-22 11:53:56 | 2010-07-22 11:58:24 | CT014
2010-07-28 10:19:48 | 2010-07-28 10:23:51 | CT014
2010-08-05 12:06:56 | 2010-08-05 12:08:40 | CT014
2010-08-09 15:08:39 | 2010-08-09 15:36:17 | CT014
2010-08-13 09:51:23 | 2010-08-13 09:56:43 | CT014
2010-08-13 10:50:07 | 2010-08-13 10:50:08 | CT014
2010-08-13 10:50:37 | 2010-08-13 10:53:24 | CT014
2010-07-19 13:11:10 | 2010-07-19 13:13:26 | CT015
2010-07-20 08:39:53 | 2010-07-20 08:41:47 | CT015
2010-07-20 10:00:26 | 2010-07-20 10:00:53 | CT015
2010-07-20 10:16:59 | 2010-07-20 10:26:36 | CT015
2010-07-20 15:11:55 | 2010-07-20 15:12:25 | CT015
2010-07-21 13:09:37 | 2010-07-21 13:35:01 | CT015
2010-07-21 18:44:33 | 2010-07-21 18:45:00 | CT015
2010-07-21 18:45:43 | 2010-07-21 18:46:38 | CT015
2010-07-22 09:28:32 | 2010-07-22 09:32:32 | CT015
2010-07-22 11:44:25 | 2010-07-22 11:46:36 | CT015
2010-07-22 13:44:54 | 2010-07-22 13:45:09 | CT015
2010-07-22 14:11:23 | 2010-07-22 15:21:25 | CT015
2010-07-22 14:21:40 | 2010-07-22 14:21:47 | CT015
2010-07-22 14:36:46 | 2010-07-22 14:37:18 | CT015
2010-07-23 09:54:35 | 2010-07-23 09:57:20 | CT015
2010-07-23 11:53:13 | 2010-07-23 11:53:25 | CT015
2010-07-23 11:53:49 | 2010-07-23 12:07:58 | CT015
2010-07-23 12:07:02 | 2010-07-23 12:50:29 | CT015
2010-07-23 12:28:51 | 2010-07-23 12:32:45 | CT015
2010-07-23 13:00:24 | 2010-07-23 13:00:27 | CT015
2010-07-23 14:57:53 | 2010-07-23 14:58:19 | CT015
2010-07-23 17:44:47 | 2010-07-23 18:09:25 | CT015
Spreadsheet: 801777d1666362535-pull-information-from-one-sheet-if-criteria-met-mock-up
Sheet: Available

SECTION 1 |  |  |  |  |  | West Section
Cemetery | Section | Block | Lot | Space |  | Cemetery | Section | Block | Lot | Space |  | Cemetery | Section | Block | Lot | Space
Spreadsheet: 110162d1306921894-eliminating-numbers-outside-a-designated-range-workbook40
Sheet: Sheet1

 | LOWEST | HIGHEST
 | 9 | 19
400 | 4 |  |  | Eliminate all numbers which fall outside of a designated "sum" range.  Example: B2: 9 through C2: 19.  Column A is the number, Column B is the sum of that number.  This will vary - lets say a sum range of 7 through 11 or 12 through 17, etc. (Sum ranges from "0" to "27")
402 | 6
404 | 8
406 | 10 | 406
408 | 12 | 408
411 | 6
413 | 8
415 | 10 | 415
417 | 12 | 417
419 | 14 | 419
422 | 8
424 | 10 | 424
426 | 12 | 426
428 | 14 | 428
433 | 10 | 433
435 | 12 | 435
437 | 14 | 437
439 | 16 | 439
401 | 5
403 | 7
405 | 9 | 405
407 | 11 | 407
409 | 13 | 409
412 | 7
414 | 9 | 414
416 | 11 | 416
418 | 13 | 418
423 | 9 | 423
425 | 11 | 425
427 | 13 | 427
429 | 15 | 429
434 | 11 | 434
436 | 13 | 436
438 | 15 | 438
444 | 12 | 444
446 | 14 | 446
448 | 16 | 448
455 | 14 | 455
457 | 16 | 457
459 | 18 | 459
467 | 17 | 467
469 | 19 | 469
478 | 19 | 478
488 | 20
499 | 22
445 | 13 | 445
447 | 15 | 447
449 | 17 | 449
456 | 15 | 456
458 | 17 | 458
466 | 16 | 466
468 | 18 | 468
477 | 18 | 477
479 | 20
489 | 21
Spreadsheet: 200934d1355820477-extracting-date-value-from-date-time-book1
Sheet: Sheet1

No | Date
1 | 18-12-2012 3:25:41 PM
2 | 18-12-2012 3:14:30 PM
3 | 18-12-2012 2:59:47 PM
4 | 18-12-2012 2:41:26 PM
5 | 18-12-2012 2:40:49 PM
6 | 18-12-2012 2:38:24 PM
7 | 18-12-2012 2:20:12 PM
8 | 18-12-2012 1:51:11 PM
9 | 18-12-2012 1:49:47 PM
10 | 18-12-2012 1:48:03 PM
11 | 9-12-2012 10:13:51 PM
12 | 9-12-2012 9:52:21 PM
13 | 9-12-2012 6:18:45 PM
14 | 9-12-2012 5:56:58 PM
15 | 9-12-2012 5:53:47 PM
16 | 9-12-2012 5:51:42 PM
17 | 9-12-2012 5:17:57 PM
18 | 9-12-2012 5:01:26 PM
19 | 9-12-2012 4:40:09 PM
20 | 9-12-2012 3:56:27 PM
21 | 9-12-2012 3:34:56 PM
22 | 9-12-2012 3:21:16 PM
23 | 9-12-2012 3:02:33 PM
24 | 9-12-2012 2:58:48 PM
25 | 9-12-2012 2:26:03 PM
26 | 9-12-2012 2:12:48 PM
27 | 9-12-2012 1:54:04 PM
28 | 9-12-2012 1:21:57 PM
Spreadsheet: 15f43cf4-072d-4b4e-afd8-3c5f12417896
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
CDB | Test | CDB | Cadmium, Blood | Cadmium, B | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Royal blue-top Monoject trace element blood collection tube: RylBlue |  |  | 1 | mL | Container/Tube: Royal blue-top (EDTA) [NAME] plastic trace element blood collection tube, catalog #368381 (Supply T183) [NAME]: Full tube Collection Instructions: 1. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 2. Send specimen in original tube. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; Gross reject Other	Green-top (heparin) tube | 0.0-4.9 ng/mL Reference values apply to all ages. | Monday through Friday; 8 a.m.-2 p.m.; Saturday; 8 a.m.-3 p.m. Continuously | 1 day | 3 days | 1 | 82300 |  |  |  |  | Rochester
CDB | [NAME] | BLOOD | Whole blood |  |  |  | Refrigerated | 21 days
CDB | Result | 8682 | Cadmium, B | Cadmium, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 5609-3 | Cadmium:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 55667d1255795140-help-with-array-extracting-data-from-tables-production-control-problem
Sheet: Egresos

[NAME] | [NAME] | SECTOR | LOSA (M3) | CORDON (M3) | DENTELLON (M3)
1 | 2 | ASDFASDF | 25 | 50 | 10 |  |  |  | FACTORS |  |  |  |  |  | FACTORES DE HORMIGONES
2 | 1 |  |  |  |  |  |  |  | SLAB | CORDON | DENTELLON |  |  |  | H-11 | H-13 | H-18 | H-21 | H-23 | H-25 | H-35 | CORDON | DENTELLON
 |  |  |  |  |  |  |  | CEMENTO | 320 | 250 | 200 |  |  | CEMENTO
 |  |  |  |  |  |  |  | RIPIO 1 1/2 | 0.5 | 0.4 | 0.3 |  |  | RIPIO 1 1/2
 |  |  |  |  |  |  |  | RIPIO 3/4 | 0.5 | 0.4 | 0.3 |  |  | RIPIO 3/4
 |  |  |  |  |  |  |  | RIPIO 3/8 | 0.5 | 0.4 | 0.3 |  |  | RIPIO 3/8
 |  |  |  |  |  |  |  | ARENILLA | 0.5 | 0.4 | 0.3 |  |  | ARENILLA
 |  |  |  |  |  |  |  | MONTHLY PRODUCTION
 |  |  |  |  |  |  |  | MONTH | SLAB | CORDON | DENTELLON |  |  |  |  |  |  |  | MESES
 |  |  |  |  |  |  |  | Enero | 0 | 0 | 0 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Febrero | 25 | 50 | 10 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | Marzo | 0 | 0 | 0 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | Abril | 0 | 0 | 0 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | Mayo | 0 | 0 | 0 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | Septiembre | 0 | 0 | 0 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | Octubre | 0 | 0 | 0 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | Noviembre | 0 | 0 | 0 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | Diciembre | 0 | 0 | 0 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | MONTHLY CONSUMPTION
 |  |  |  |  |  |  |  | MONTH | CEMENTO | RIPIO 1 1/2 | RIPIO 3/4 | RIPIO 3/8 | ARENILLA
 |  |  |  |  |  |  |  | Enero | 0 | 0
 |  |  |  |  |  |  |  | Febrero | 22500 | 35.5
 |  |  |  |  |  |  |  | Marzo | 0 | 0
 |  |  |  |  |  |  |  | Abril | 0 | 0
 |  |  |  |  |  |  |  | Mayo | 0 | 0
 |  |  |  |  |  |  |  | [NAME] | 0 | 0
 |  |  |  |  |  |  |  | [NAME] | 0 | 0
 |  |  |  |  |  |  |  | [NAME] | 0 | 0
 |  |  |  |  |  |  |  | Septiembre | 0 | 0
 |  |  |  |  |  |  |  | Octubre | 0 | 0
 |  |  |  |  |  |  |  | Noviembre | 0 | 0
 |  |  |  |  |  |  |  | Diciembre | 0 | 0
 |  |  |  |  |  |  |  | MES | CEMENTO | RIPIO 1 1/2 | RIPIO 3/4 | RIPIO 3/8 | ARENILLA
 |  |  |  |  |  |  |  | Enero | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Febrero | 0 | 35.5 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Marzo | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Abril | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Mayo | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | [NAME] | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | Septiembre | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | Octubre | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | Noviembre | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  | Diciembre | #N/A | #N/A | #N/A | #N/A | #N/A