tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: joe_parks__14549__Febfisrt2002
Sheet: 1460 Interstate 

PIPELINE COMPANY |  |  |  |  |  |  |  |  |  |  |  | From: |  | Enron Capital & Trade
301 South Harwood |  |  |  |  |  |  |  |  |  |  |  | Shipper: |  | Enron Capital & Trade
Dallas, TX 75201-5696 |  |  |  |  |  |  |  |  |  |  |  | Contact: |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Phone: |  | [PHONE]
Attn: |  | [NAME]---Scheduling Department |  |  |  |  |  |  |  |  |  | Fax: |  | [PHONE]
Fax: |  | [PHONE]
 |  | Contract #: | LS-MC-1460 | Start Date: |  |  | End Date: | 9-30.01
Receipt Point Information
Station # |  | Station Location Description |  | Upstream Shipper & Contract # |  |  | Previous Nom |  | Nominated |  |  | Fuel % | Fuel Amt | Net Quantity
 |  |  |  |  |  |  | Quantity (MMBtu/D) |  | Quantity (MMBtu/D)
17-7462-50 |  | EPGT-PGE Waha |  | 5095037 |  |  | 0 |  |  | 10101 |  | 0.01
 |  |  |  |  |  |  |  |  |  | 0
Delivery Point Information
Station # |  | Station Location Description |  | Downstream Shipper & Contract # |  |  | Previous Nom |  | Nominated |  |  |  |  | Net Quantity
 |  |  |  |  |  |  | Quantity (MMBtu/D) |  | Quantity (MMBtu/D)
17-0976-13 |  | HPL Texoma |  | 96061532 |  |  | 0 |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Del:
Spreadsheet: 888654d1739222071-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 24

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.8
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 27 Oct Glucose mmol/L
Sat 28 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 29 Oct Glucose mmol/L
Mon 30 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 6.2
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 31 Oct Glucose mmol/L
Wed 1 Nov Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 2 Nov Glucose mmol/L
 |  |  |  |  |  | 6.3
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Fri 3 Nov Glucose mmol/L
Spreadsheet: 42fb00bf-7c37-4195-9e7c-11e6c8109234
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
FMETX | Test | FMETX | Methsuximide ([NAME]) as Desmethylmethsuximide | Methsuximide ([NAME]) | Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp Plain, Red-Top Tube: Red |  |  | 2 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 10.0 - 40.0 ug/mL   Methsuximide measured as desmethylmethsuximide.   Test Performed By:  Medtox Laboratories, Inc.                                402 West County Road D                                St. Paul, MN  55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83858 |  |  |  |  | Medtox Laboratories, Inc.
FMETX | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FMETX | Result | Z1107 | Methsuximide | Methsuximide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 694777d1599786789-need-help-creating-po-with-existing-information-sample-pricing
Sheet: Data Validation

 | Screen Type | Lock Body |  | Barrell Type |  | Multi Lock |  | [NAME] |  | Pet Flap
 | BELLA SD | Austral SD7 | 36.2 | Austral | 10 | N/A | 0 | JPHD21 | 26.38 | Small | 88
 | BELLA HD | Austral Elegance | 35.6 |  |  | Austral Triple | 38.6 | [NAME] | 26.38 | Med | 99
 | Xceed SD | N/A | 0 | N/A | 0 | Lockwood Triple | 50.65 | JPHDD21 | 30.66 | Large | 110
 | Xceed HD | Lockwood 8654 | 37.07 |  |  |  |  | [NAME] | 29.18 | N/A | 0
 |  |  |  |  |  |  |  | JPSD21 | 8.57
 |  |  |  |  |  |  |  | [NAME] | 9.04
 | Secure View SD |  |  |  |  |  |  | JPSD26 | 14
 | Secure View HD |  |  |  |  |  |  | JPFD21 | 26.38
 |  |  |  |  |  |  |  | JPFD23 | 26.38
 |  |  |  |  |  |  |  | JPFDD21 | 30.62
 |  |  |  |  |  |  |  | [NAME] | 30.62
 |  |  |  |  |  |  |  | JPCS21 | 32.8
 | Screen Type Windows |  |  |  |  |  |  | JPCS23 | 35.52
 | BELLA |  |  |  |  |  |  | JPCS26 | 56.6
 | Secure View |  |  |  |  |  |  | JPDSE21 | 16.4
 | Xceed | Mesh Type |  |  |  |  |  | JPDSE23 | 17.82
 |  | Stainless Steel Mesh | 13 |  |  |  |  | JPDSE26 | 26.69
 |  | [NAME] | 1.32 |  |  |  |  | [NAME] | 33.62
 |  | Alum Mesh | 4.15 |  |  |  |  | [NAME] | 35.98
 |  | Sand Fly Mesh | 4.03 |  |  |  |  | JPBP26 | 53.28
 |  | Pet Mesh | 9.35 |  |  |  |  | JPETBP21 | 49.26
 | Type | N/A | 0 |  |  |  |  | JPETBP23 | 53.1
 | Grille HD |  |  |  |  |  |  | [NAME] | 87.44
 | [NAME] |  |  |  |  |  |  | N/A | 0
 | Grille
 | [NAME] | 0 | YES | YES
 | [NAME] | 0 | YES | YES
 | Monument | 0 | YES | YES
 | Palladium Silver P | 0 | YES | YES
 | [NAME] | 0 | YES | YES
 | Primrose | 15 | YES |  | YES
 | Stone Beige | 15 | YES |  | YES
 | [NAME] | 15 | YES |  | YES
 | Paper Bark | 15 | YES |  | YES
 | Deep Ocean | 15 | YES |  | YES
 | Anodic Natural M | 15 | YES |  | YES
 | Ultra Silver | 15 | YES |  | YES
 | [NAME] GL205A | 15 | YES |  | R/O
 | White Birch | 15 | YES |  | YES
 | Clear Ano | 15 | YES |  | EXOTICS
 | [NAME] | 15 | YES |  | EXOTICS
 | Anodic Dark Grey | 15 | YES |  | EXOTICS
 | Other | POA
 | APO Grey | 15 | YES |  | EXOTICS
 | Premium Charges
 | Standard Door Under 2200 |  |  | 15
 | Over [NAME] Over 2200 |  |  | 20
 | Windows Under 2.25sqm |  |  | 5
 | Windows Over 2.25sqm |  |  | 10
 | JJD
 | Door
 | Window
 | FFIT
 | Door
 | Window
Spreadsheet: 220029d1363036993-combine-multiple-workbooks-into-one-whorksheet-dummy
Sheet: REVANALYSIS 220733

Retail Unit |  |  |  |  | Jan (A) | Feb (A) | Mar (P) | Apr (P) | May (P) | Jun (P) | Jul (P) | Aug (P) | Sep (P) | Oct (P) | Nov (P) | Dec (P) | Gross | Agy Disc | Rep Disc | [NAME] | [NAME] | Net | Slp Comm
Apple |  |  |  |  | 255717.77 | 322121.25 | 418074.95 | 200868.04 | 177258.98 | 156820.86 | 114258.83 | 116897.38 | 166129.97 | 165995.81 | 137487.03 | 125624.28 | 2357255.15 | 287813.34 | 24121.69 | 0 | 311935.03 | 2045320.12 | 0
Orange |  |  |  |  | 158379.87 | 185184.56 | 259136.11 | 88353.58 | 71792.79 | 62684.62 | 39511.78 | 39052 | 51421.58 | 48348.2 | 43292.62 | 45616.68 | 1092774.39 | 126778.31 | 24959.18 | 0 | 151737.49 | 941036.9 | 0
Yellow |  |  |  |  | 77719.22 | 117391.81 | 139542.75 | 60391.46 | 47418.53 | 49527.89 | 31703.82 | 29432.46 | 40631.51 | 30861.46 | 30711.71 | 28735.98 | 684068.6 | 61894.88 | 10356.98 | 0 | 72251.86 | 611816.74 | 0
Blue |  |  |  |  | 101895.13 | 111011.48 | 157485.26 | 54739.74 | 63668.78 | 61705.73 | 33469.74 | 35978.15 | 52644.14 | 37992.66 | 33674.65 | 29223.83 | 773489.29 | 64337.47 | 9810.61 | 0 | 74148.08 | 699341.21 | 0
Green |  |  |  |  | 79309.71 | 114273.62 | 151820.53 | 68558.19 | 59453.77 | 60238.09 | 28738.56 | 28623.07 | 35205.41 | 23319.55 | 21596.11 | 19347.28 | 690483.89 | 60100.8 | 13506.85 | 0 | 73607.65 | 616876.24 | 0
Black |  |  |  |  | 4066.84 | 5008.13 | 6678.59 | 1608.67 | 1456.89 | 1265.14 | 181.07 | 107.5 | 183.57 | 81.76 | 33.29 | 39.14 | 20710.59 | 3107.26 | 1929.25 | 0 | 5036.51 | 15674.08 | 0
White |  |  |  |  | 508147.32 | 718182.72 | 872604.94 | 388938.91 | 326740.82 | 322704.73 | 221621.52 | 241318.52 | 291514.36 | 240547.22 | 227069.19 | 231582.34 | 4590972.59 | 524491.94 | 46065.93 | 0 | 570557.87 | 4020414.72 | 0
Spreadsheet: 189558d1351229029-combining-cells-into-one-but-seperated-by-carriage-return-sample
Sheet: Sheet1

[NAME]
Problem No. | Problem |  | Action Taken | Done by | Done on
121 | Oil Leakage | a | Oil Changed | Ravi | 2012-10-01 00:00:00
121 | Oil Leakage | b | Oil Seal Replaced | Ravi | 2012-10-01 00:00:00
121 | Oil Leakage | c | Repared Part sent to Customer | Suresh | 2012-10-05 00:00:00
122 | abnormal Noise | a | [NAME] | Raj | 2012-10-10 00:00:00
122 | abnormal Noise | b | Repared Part sent to Customer | Srinivasan | 2012-10-13 00:00:00
[NAME]
Problem No. | Problem |  | Action Taken | Done by | Done on
121 | Oil Leakage | a b c | Oil Changed Oil Seal Replaced Repared Part sent to Customer | Ravi  Suresh | 01-Oct-12  05-Oct-12
122 | abnormal Noise | a b | [NAME] Part sent to Customer | Raj Srinivasan | 10-Oct-12 13-Oct-12
Macro Requirement :
a) select the ROWS with same PROBLEM No.
b) [NAME] values in each Column
c) For Each Column,   merge data from the rows in selection and puts each cell value on a new line.
d) Repeat for Next Problem No.
Note :The database is sorted based on Complaint No.
Spreadsheet: 700059d1602929875-rank-top-10-by-summed-group-values-fragan
Sheet: Feuil2

GROUP | Value | Number of sales
A | 50 | 69 |  |  | TOP K | 4
A | 33 | 28 |  |  |  |  | k=4 so i should print only 4 top groups by value
B | 51 | 24
A | 68 | 25
B | 91 | 2 |  |  |  |  | Desired Result :
A | 39 | 97 |  |  |  |  |  | GROUP | Value | Number of Sales
B | 68 | 35 |  |  |  |  |  | A | 474 | 557
C | 70 | 146 |  |  |  |  |  | B | 393 | 228
E | 89 | 71 |  |  |  |  |  | C | 213 | 326
A | 64 | 68 |  |  |  |  |  | D | 118 | 160
B | 45 | 5
D | 72 | 73
Z | 21 | 57
E | 22 | 56
A | 93 | 89
B | 79 | 77
D | 46 | 87
C | 43 | 86
A | 7 | 27
B | 51 | 18
C | 97 | 2
A | 83 | 69
Z | 7 | 12
B | 8 | 67
C | 3 | 92
S | 56 | 13
A | 37 | 85
T | 32 | 45
Spreadsheet: 55501d1255615157-rank-problem-game-and-ranking-sheets-09-10-season
Sheet: DIV 4 Ranking

DIVISION 4 RANKINGS 09 -10
No | Team | Win | Loss | Draw | Shots | Points
4 | [NAME] | 2 | 1 | 0 | 13 | 12
2 | Berri | 2 | 1 | 0 | 5 | 14
3 | [NAME] | 2 | 1 | 0 | 14 | 13
6 | Loxton Red | 1 | 1 | 1 | 0 | 5
5 | Renmark | 2 | 1 | 0 | 0 | 7
1 | [NAME] | 1 | 1 | 1 | 7 | 15
FINAL RANKINGS
No | Team | Win | Loss | Draw | Shots | Points
1 | [NAME] | 1 | 1 | 1 | 7 | 15
2 | Berri | 2 | 1 | 0 | 5 | 14
3 | [NAME] | 2 | 1 | 0 | 14 | 13
4 | [NAME] | 2 | 1 | 0 | 13 | 12
5 | Renmark | 2 | 1 | 0 | 0 | 7
6 | Loxton Red | 1 | 1 | 1 | 0 | 5
Spreadsheet: john_griffith__15768__10_18_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 245 | 24 | 25.5 | 83 | 88.2 | 13.18 | 2001-10-18 12:13:00
 | NG Z1 | 275 | 52 | 54 | 72 | 74.8 | 12.69 | 2001-10-18 12:13:00
 | NG F2 | 295 | 72.5 | 74 | 71.7 | 73.1 | 13.43 | 2001-10-18 12:13:00
 | NG G2 | 290 | 82 | 84 | 68.2 | 69.8 | 12.58 | 2001-10-18 12:13:00
 | NG H2 | 290 | 82 | 84 | 60.6 | 62.1 | 11.19 | 2001-10-18 12:13:00
 | NG J2 | 280 | 72 | 76 | 50.1 | 52.9 | 9.07 | 2001-10-18 12:13:00
 | NG K2 | 285 | 72 | 76 | 45.2 | 47.7 | 8.32 | 2001-10-18 12:13:00
 | NG M2 | 290 | 82 | 85 | 46.9 | 48.6 | 8.71 | 2001-10-18 12:13:00
 | NG N2 | 295 | 86 | 90 | 45.7 | 47.8 | 8.67 | 2001-10-18 12:13:00
 | NG Q2 | 300 | 92 | 98 | 45.6 | 48.6 | 8.88 | 2001-10-18 12:13:00
 | NG U2 | 300 | 98 | 101 | 46.3 | 47.7 | 8.86 | 2001-10-18 12:13:00
 | NG V2 |  |  |  |  |  | 8.98 | 2001-10-17 15:08:00
 | [NAME] |  |  |  |  |  | 10.12 | 2001-10-18 10:52:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 692390d1598301182-multi-lookup-array-formula-example
Sheet: CESS-APP

 |  | CURRITD ROW 5 |  |  | 13352 | -62.32 | 13289.68 | 7403.81
 |  | DIFFERENCE TO BELOW DATA
 |  |  |  |  |  |  |  |  |  |  |  |  | S/B ZERO
 | TOTALS
 |  |  |  |  | Gross | Cancel | Net | Earned
 |  |  |  |  | Reserve | Reserve | Reserve | Reserve
 | Dealership | Gross | Cancel | Net | GXRA | CXRA | NXRA | EXR | Paid | Claims |  |  |  | Unearned
Product | Name | Count | Count | Count | GRA | CRA | NRA | ER | Claims | Count |  |  |  | Reserve
AP | [NAME] | GCCT | CCCT | NCCT | SUR1GW | SUR1CW | SUR1NW | SUR1NE | TPC | PCC
719110
 |  |  |  |  | THE VARIABLES IN THE FORMULA ABOVE ARE DEALER NUMBER: "719110" AND PRODUCT "AP"
 |  |  |  |  | SINCE GXRA AND SUR1GW MATCHES ARE ZERO IT SHOULD BE RETURNING ONLY GRA
 |  |  |  |  | WHICH IS THE TOTAL SHOWN IN CELL F1 ABOVE, WHICH COMES FROM THE CURRITD DATA
 |  |  |  |  | I HAVE NO CLUE WHERE THE DIFFERENCE IS COMING FROM
TOTAL STONEEAGLE - PCRS DIFFERENCES 03-31-19
Spreadsheet: 39814d1238085300-looking-up-a-range-of-cells-with-criterias-attached-index-match-offset
Sheet: Sheet2

a | b | c | d | e | f | g | result
0.36 | 0.21 | 0.15 | 0.11 | 0.1 | 0.12 | 0.19 | 0.8
0.41 | 0.25 | 0.19 | 0.17 | 0.14 | 0.16 | 0.23 | 1
0.51 | 0.31 | 0.25 | 0.23 | 0.2 | 0.22 | 0.29 | 1.2
0.55 | 0.37 | 0.31 | 0.29 | 0.26 | 0.28 | 0.35 | 1.4
band | rate
a | 0.6956264222147308 | 1.4
b | 0.6738351165791814 | 1.4
g | 0.07671572290648143 | 0
d | 0.2460343872829887 | 1.2
e | 0.6460528034365378 | 1.4
Spreadsheet: 99e0d92b-ef08-4851-9a46-2c9e8e800601
Sheet: Sheet1

Applicant Name: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Award Number: | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1. | Budget Period 1 | 81.086 |  |  |  |  | 0
2. | Budget Period 2 | 81.086 |  |  |  |  | 0
3. | Budget Period 3 | 81.086 |  |  |  |  | 0
4. | Budget Period 4 | 81.086 |  |  |  |  | 0
 | Totals |  |  |  | 0 | 0 | 0
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total
 |  |  | Budget Period 1 | Budget Period 2 | Budget Period 3 | Budget Period  4
 | [NAME] |  |  |  |  |  | 0
 | [NAME] |  |  |  |  |  | 0
 | c.  Travel |  |  |  |  |  | 0
 | d.  Equipment |  |  |  |  |  | 0
 | e.  Supplies |  |  |  |  |  | 0
 | f.  Contractual |  |  |  |  |  | 0
 | g.  Construction |  |  |  |  |  | 0
 | h.  Other |  |  |  |  |  | 0
 | i.  Total Direct Charges (sum of 6a-6h) |  | 0 | 0 | 0 | 0 | 0
 | j.  Indirect Charges |  |  |  |  |  | 0
 | k.  Totals (sum of 6i-6j) |  | 0 | 0 | 0 | 0 | 0
7. | Program Income |  |  |  |  |  | 0
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Spreadsheet: 72868d1273586638-ranking-the-figures-in-a-column-and-assigning-a-score-depending-on-the-rank-book2
Sheet: Sheet1

Rank | Name | criteria 1 | Score | criteria 2 | Score | criteria 3 | Score | criteria 4 | Score | Overall
 | [NAME] |  | 1 |  | 1 |  | 1 |  | 1
 | [NAME] |  | 2 |  | 3 |  | 3 |  | 4
 | [NAME] |  | 3 |  | 5 |  | 10 |  | 11
 | [NAME] |  | 4 |  | 4 |  | 7 |  | 13
 | [NAME] |  | 5 |  | 7 |  | 5 |  | 6
 | [NAME] |  | 7 |  | 2 |  | 2 |  | 2
 | [NAME] |  | 6 |  | 13 |  | 14 |  | 14
 | [NAME] |  | 8 |  | 8 |  | 4 |  | 5
 | [NAME] |  | 9 |  | 11 |  | 8 |  | 7
 | [NAME] |  | 10 |  | 9 |  | 9 |  | 8
 | [NAME] |  | 11 |  | 10 |  | 11 |  | 3
 | [NAME] |  | 12 |  | 14 |  | 13 |  | 12
 | [NAME] |  | 13 |  | 6 |  | 6 |  | 10
 | [NAME] |  | 14 |  | 12 |  | 12 |  | 9
Spreadsheet: 316bb7df-8e63-41c5-bbc9-d3b51e47d00e
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 1/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13 | 2011/12 | 2012/13
June | 7.41 | 6.7 | 7.13 | 6.54 | 9.18 | 8.31 | 9.26 | 7.78
July | 7.1 | 7.93 | 6.77 | 7.79 | 10.2 | 8.6 | 8.45 | 8.53
August | 7.59 | 8.04 | 7.27 | 7.92 | 10.2 | 7.7 | 8.28 | 8.27
September | 7.54 | 8.27 | 7 | 8.25 | 10.8 | 7.74 | 8.09 | 8.38
October | 7.27 | 8.38 | 6.53 | 8.33 | 9.6 | 7.61 | 8.19 | 8.56
November | 7.3 | 8.46 | 6.44 | 8.38 | 10.3 | 8.16 | 8.43 | 8.65
December | 7.2 | 8.33 | 6.41 | 8.24 | 10.3 | 8.45 | 8.25 | 8.45
January | 7.05 |  | 6.57 |  | 8.84 |  | 8.09
February | 7.1 |  | 6.68 |  | 8.98 |  | 8.01
March | 7.2 |  | 6.7 |  | 8.39 |  | 8.04
April | 7.11 |  | 6.47 |  | 9.22 |  | 7.96
May | 6.67 |  | 6.42 |  | 8.95 |  | 7.93
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 1/12/2013
Spreadsheet: 99104d1297859928-vlookup-result-not-clickable-hyperlink-concept-structuur-hyperlink-documentatie
Sheet: data

KA2S | MCP | Omkasting | LCP/DCS
1 | 0 | 1 | 1 | 1011 | C:\test
1 | 0 | 1 | 0 | 1010 | \\\C:\test
1 | 0 | 0 | 1 | 1001 | Hyperlink3
1 | 0 | 0 | 0 | 1000 | Hyperlink4
1 | 1 | 1 | 1 | 1111 | Hyperlink5
1 | 1 | 1 | 0 | 1110 | Hyperlink6
1 | 1 | 0 | 1 | 1101 | Hyperlink7
1 | 1 | 0 | 0 | 1100 | Hyperlink8
 |  |  |  |  |  |  | Hello folks,
 |  |  |  |  |  |  | I have a issue here, that I coudn't find solved on this site, correct me if wrong.
 |  |  |  |  |  |  | I have a table in sheet (1) with these codes and hyperlinks:
 |  |  |  |  |  |  | A              B
 |  |  |  |  |  |  | 1011 | Hyperlink1
 |  |  |  |  |  |  | 1010 | Hyperlink2
 |  |  |  |  |  |  | 1001 | Hyperlink3
 |  |  |  |  |  |  | 1000 | Hyperlink4
 |  |  |  |  |  |  | 1111 | Hyperlink5
 |  |  |  |  |  |  | 1110 | Hyperlink6
 |  |  |  |  |  |  | 1101 | Hyperlink7
 |  |  |  |  |  |  | 1100 | Hyperlink8
 |  |  |  |  |  |  | This is one of my sheets.
 |  |  |  |  |  |  | Now I have another sheet (2) with cells resulting in one of the codes at A. Then I have another cell in sheet (2) vlooking up the value in the table on sheet (1). No problems with the Vlooking up or the Hyperlinks in sheet (1) but then the resulted [NAME] in sheet (2) is not clickable. Does someone have a solution for this?
 |  |  |  |  |  |  | Thanks in advance and excuse me for my English.
 |  |  |  |  |  |  | Yours,
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | the Netherlands
Spreadsheet: 775635d1649237828-analysing-duplicates-in-a-column-based-on-a-value-in-another-example2
Sheet: Sheet1

Year | Term | Module | Grade
2019 | Spr | ENG12300 | A
2019 | Aut | Ling12300 | B-
2021 | Spr | Ling10010 | Registered
2020 | Aut | Ling10010 | WN
2020 | Spr | Ling10010 | WX
2019 | Aut | Ling10010 | WN
2020 | Aut | ENG10130 | C+
2019 | Spr | ENG10130 | WN
2019 | Aut | ENG10130 | WN
2020 | Aut | GEOG10200 | FM
2020 | Spr | HIS10100 | WN
2020 | Aut | HIS10100 | WN
This is the solution I am looking for from the above data |  |  |  |  |  |  | Notes
Year | Term | Module | Grade |  |  |  | Notes
2019 | Spr | ENG12300 | A |  |  |  | These green modules are fine as they were passed on the first attempt
2019 | Aut | Ling12300 | B-
2021 | Spr | Ling10010 | Registered | proceeding |  |  | This grey module has been allowed reattempts and it is registered now so I don’t need to pay atteming the the earlier ones.
2020 | Aut | Ling10010 | WN | proceeding
2020 | Spr | Ling10010 | WX | proceeding
2019 | Aut | Ling10010 | WN | proceeding
2020 | Aut | ENG10130 | C+ | resolved |  |  | This yellow module has since been passed so the earlier attempts are redundant now
2019 | Spr | ENG10130 | WN | complete
2019 | Aut | ENG10130 | WN | complete
2019 | Aut | GEOG10200 | FM | unresolved |  |  | This orange module was failed and the option to take it again has not being taken again
2020 | Spr | HIS10100 | WN | unresolved |  |  | This blue module has not been taken again
2020 | Aut | HIS10100 | WN | unresolved
Spreadsheet: 85692d1285753828-highlight-according-to-multiple-criteria-test
Sheet: Sheet1

House No | [NAME] | Departure Date
23 | 2009-10-31 00:00:00 | 2010-10-31 00:00:00
90 | 2010-08-26 00:00:00 | 2010-10-07 00:00:00 |  | x
134 | 2010-09-13 00:00:00 | 2010-10-11 00:00:00
53 | 2010-09-15 00:00:00 | 2010-10-02 00:00:00
48 | 2010-09-16 00:00:00 | 2010-11-02 00:00:00
1 | 2010-09-17 00:00:00 | 2010-10-02 00:00:00
4 | 2010-09-21 00:00:00 | 2010-09-28 00:00:00
118 | 2010-09-23 00:00:00 | 2010-09-26 00:00:00 |  | x
111 | 2010-09-25 00:00:00 | 2010-10-03 00:00:00
118 | 2010-09-27 00:00:00 | 2010-10-11 00:00:00 |  | x
117 | 2010-09-28 00:00:00 | 2010-10-12 00:00:00
8 | 2010-09-29 00:00:00 | 2010-10-06 00:00:00 |  | x
45 | 2010-10-04 00:00:00 | 2010-10-13 00:00:00
8 | 2010-10-06 00:00:00 | ? |  | x
90 | 2010-10-07 00:00:00 | ? |  | x
111 | 2010-10-07 00:00:00 | 2010-10-14 00:00:00
130 | 2010-10-13 00:00:00 | 2010-10-17 00:00:00
15 | 2010-10-14 00:00:00 | 2010-11-02 00:00:00
111 | 2010-10-16 00:00:00 | 2010-10-30 00:00:00
4 | 2010-10-17 00:00:00 | 2010-10-27 00:00:00
140 | 2010-10-17 00:00:00 | ?
66 | 2010-10-22 00:00:00 | 2010-10-31 00:00:00
42 | 2010-10-23 00:00:00 | 2010-10-30 00:00:00
119 | 2010-11-24 00:00:00 | 2010-12-12 00:00:00
42 | 2011-05-28 00:00:00 | 2011-06-04 00:00:00
111 | 2011-07-23 00:00:00 | 2011-08-13 00:00:00
Spreadsheet: chris_germany__1753__AGL Daily Requirement
Sheet: Sheet1

 |  | The New Power Company
 |  | AGL Daily Requirements
 |  |  |  | Current | Intra-Day | Tomorrow
 | Pool | Pipeline | Type |  |  |  |  | 2000-09-01 00:00:00
 | Atlanta | SNG | DSR | 0 | 0 | 0 |  | 0
 |  | ETNG | DSR | 188 | 188 | 188 |  | 175
 |  | Transco | DSR | 5628 | 5628 | 5619 |  | 3493
 |  | TBD | DSR
 | DSR Total: |  |  | 6277 | 6277 | 6277 |  | 6267
 |  | SNG | LSR | 0 | 0 | 0 |  | 0
 |  | ETNG | LSR | 692 | 692 | 692 |  | 686
 |  | Transco | LSR | 692 | 692 | 692 |  | 457
 | Total Atlanta:
 | Ex-Atl. SNG | SNG | DSR | 315 | 315 | 315 |  | 316
 | Brunswick | SNG | DSR | 310 | 310 | 310 |  | 314
 | Rome | SNG | DSR | 317 | 317 | 317 |  | 317
 | Augusta | SNG | DSR | 263 | 263 | 263 |  | 265
 | Savannah | SNG | DSR | 285 | 285 | 285 |  | 290
 | Macon | SNG | DSR | 445 | 445 | 445 |  | 450
 |  | Macon | LSR | 68 | 68 | 69 |  | 102
 |  | Atlanta | LSR | 346 | 346 | 346 |  | 343
 | Total Macon:
 | Valdosta | SNG / SGNG | DSR | 81 | 81 | 81 |  | 81
 | Ex-Atl. [NAME] | Transco | DSR | 224 | 224 | 224 |  | 222
 | Total AGL Firm:
 | Sonat IBSS |  |  | 3099 | 3099 | 3099 |  | 0
 | Transco IBSS |  |  | 1069 | 1069 | 1069 |  | 0