tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0e7e74e2-e573-47ac-a2d2-05565576354a
Sheet: Summary

 | Date:
 | Organization:
 | Contact Name:
 | Attachment 3: Budget
 | Exchange rate 1 USD = ……[local currency]
 | Budget sections |  | Total | Notes
 | 1. Staff
 | a) PI
 |  | [Name - Title - % LOE] | 0
 |  | [Name - Title - % LOE] | 0
 | b) Research Assistant
 |  | [Name - Title - % LOE] | 0
 |  | [Name - Title - % LOE] | 0
 | c) Other
 |  | [Name - Title - % LOE] | 0
 |  | [Name - Title - % LOE] | 0
 | 2. Staff [NAME] |  | 0
 | 3. Consultants
 |  | [Name - Title - % LOE] | 0
 |  | [Name - Title - % LOE] | 0
 | 4. Travel
 | a) Domestic
 |  | [Trip 1 - Destination] | 0
 |  | [Trip 2 - Destination] | 0
 | b) International
 |  | [Trip 1 - Destination] | 0
 |  | [Trip 2 - Destination] | 0
 | 5. Subcontract
 |  | [Name - Purpose] | 0
 | 6. Equipment
 | 7. Other Project Expenses |  | 0
 |  | [Expense - Purpose] | 0
 |  | [Expense - Purpose] | 0
 | 8. Indirect Costs |  | 0
 | 9. Cost Share |  | 0
 | Grand Total
Spreadsheet: 269598d1381227411-index-function-animeshdubeyad
Sheet: Sheet1

1 | A
2 | C
1 | B | >>> Sample data
3 | E
1 | C
2 | A
 |  | Needed Output
 |  | >>> in another sheet for the value 1 I need all records of 1 displayed together
Currently what i am getting is :
1 | A
Spreadsheet: chris_germany__1761__IFERC
Sheet: February 2000

Inside FERC's Gas Market Report monthly bidweek price file.
When done, e-mail to [EMAIL]
or fax to [PHONE], attention: [NAME]
Prices must be sent to INSIDE FERC by 3:30 pm EASTERN TIME on the last business day of the month or
they might not be included.  If you have problems, call [PHONE] ([NAME])
SURVEY / WORKBOOK  NOTES:
* The essential fields to fill out below are the price, volume, date and price source fields.
* Add the specific pipeline names and delivery points in column A as you go.
* We round the volumes to the nearest thousand, and truncate the last three zeros,
ie, 15,320 [NAME]/day is entered as 15; 3,000 MMBtu/day, as 3, etc.
* Only report FIXED-PRICED,  BASELOAD DEALS negotiated during BIDWEEK. NO EFPs please.
* In the last two columns on the right, please report a low and a high for BASIS DEALS during BIDWEEK
at each pricing point. The basis should be reported as plus or minus values to the last day NYMEX
[NAME] price, ie., minus a half cents is -0.05, etc.
* Please do not change the format of the file, and do not put formulas in the cells, just values.
Thank you very much for participating, [NAME].
 | Price | Volume | Date | Price Source | IF Reporter | Comments | Bidweek Basis Low | Bidweek Basis High
example:
ANR Louisiana | 2.02 | 15 | 1998-12-24 00:00:00 | company name | [NAME] | baseload | -0.0525 | -0.0325
 | 2.02 | 5 | 1998-12-29 00:00:00 | company name | [NAME] | right after NYMEX close
 | 1.99 | 7 | 1998-12-30 00:00:00 | company name | [NAME]
 | Price | Volume | Date | Price Source | IF Reporter | Comments | Bidweek Basis Low | Bidweek Basis High
 |  |  |  |  |  |  | <-----lianes section 100-199
 |  |  |  |  |  |  | <-----Dosia's section 100-199
 |  |  |  |  |  |  | <-----Liza's section 100-199
 |  |  |  |  |  |  | <-----Louise's section 100-199
 |  |  |  |  |  |  | <-----Mark's section 100-199
 |  |  |  |  |  |  | <-----Karen's section 100-199
 |  |  |  |  |  |  | <-----Val's section 100-199
 |  |  |  |  |  |  | <-----Spillover-1 100-199
 |  |  |  |  |  |  | <-----Spillover-2 100-199
Spreadsheet: 769901d1645720899-reduce-1-minute-data-to-30-minute-data-in-excel-s1_my-file
Sheet: half hourly data

Arithmetic mean from 11/02/2022 at  12:56:26 to 14/02/2022  08:26:26 - Half an hour data - sample interval 3,20 min
 | cDAQ3Mod1/ai0 | cDAQ3Mod1/ai11 | cDAQ3Mod2/ai0
Time | Indoor Thermocouple  [°C] | Outdoor Thermocouple [°C] | Heat Flux Sensor [V] |  | TIMESTAMP | Indoor Thermocouple  [°C] | Outdoor Thermocouple [°C] | Heat Flux Sensor [V]
00:00:00
00:30:00
01:00:00
01:30:00
02:00:00
02:30:00
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
22:00:00
22:30:00
23:00:00
23:30:00
1900-01-01 00:00:00
1900-01-01 00:30:00
1900-01-01 01:00:00
1900-01-01 01:30:00
1900-01-01 02:00:00
1900-01-01 02:30:00
1900-01-01 03:00:00
1900-01-01 03:30:00
1900-01-01 04:00:00
1900-01-01 04:30:00
1900-01-01 05:00:00
1900-01-01 05:30:00
1900-01-01 06:00:00
1900-01-01 06:30:00
1900-01-01 07:00:00
1900-01-01 07:30:00
1900-01-01 08:00:00
1900-01-01 08:30:00
1900-01-01 09:00:00
1900-01-01 09:30:00
1900-01-01 10:00:00
1900-01-01 10:30:00
1900-01-01 11:00:00
1900-01-01 11:30:00
1900-01-01 12:00:00
1900-01-01 12:30:00
1900-01-01 13:00:00
1900-01-01 13:30:00
1900-01-01 14:00:00
1900-01-01 14:30:00
1900-01-01 15:00:00
1900-01-01 15:30:00
1900-01-01 16:00:00
1900-01-01 16:30:00
1900-01-01 17:00:00
1900-01-01 17:30:00
1900-01-01 18:00:00
1900-01-01 18:30:00
1900-01-01 19:00:00
1900-01-01 19:30:00
1900-01-01 20:00:00
1900-01-01 20:30:00
1900-01-01 21:00:00
1900-01-01 21:30:00
1900-01-01 22:00:00
1900-01-01 22:30:00
1900-01-01 23:00:00
1900-01-01 23:30:00
1900-01-02 00:00:00
1900-01-02 00:30:00
1900-01-02 01:00:00
1900-01-02 01:30:00
1900-01-02 02:00:00
1900-01-02 02:30:00
1900-01-02 03:00:00
1900-01-02 03:30:00
1900-01-02 04:00:00
1900-01-02 04:30:00
1900-01-02 05:00:00
1900-01-02 05:30:00
1900-01-02 06:00:00
1900-01-02 06:30:00
1900-01-02 07:00:00
1900-01-02 07:30:00
1900-01-02 08:00:00
1900-01-02 08:30:00
1900-01-02 09:00:00
1900-01-02 09:30:00
1900-01-02 10:00:00
1900-01-02 10:30:00
1900-01-02 11:00:00
1900-01-02 11:30:00
1900-01-02 12:00:00
1900-01-02 12:30:00
1900-01-02 13:00:00
1900-01-02 13:30:00
1900-01-02 14:00:00
1900-01-02 14:30:00
1900-01-02 15:00:00
1900-01-02 15:30:00
1900-01-02 16:00:00
1900-01-02 16:30:00
1900-01-02 17:00:00
1900-01-02 17:30:00
1900-01-02 18:00:00
1900-01-02 18:30:00
1900-01-02 19:00:00
1900-01-02 19:30:00
Spreadsheet: 803172d1667301016-count-cells-with-content-test-
Sheet: Sheet1

 |  |  | Code | Ethnicity  (2001 Census Categories) |  |  |  |  | Reg
 |  |  |  | Other ethnic group: Arab, Arab Scottish or Arab British - Scotland ethnic category 2011 census |  |  |  |  | S
 |  |  |  | White British - ethnic category 2001 census |  |  |  |  | S
 |  |  | E01030743 | [NAME] or British Bangladeshi - ethnic category 2001 census |  |  |  |  | S
 |  |  |  | N African Arab/Iranian (NMO)
 |  |  | E01030711 | Any other group - ethnic category 2001 census
 |  |  |  | English - ethnic category 2001 census
 |  |  |  | White British - ethnic category 2001 census
 |  |  |  | White British - ethnic category 2001 census
 |  |  |  | Indian or British Indian - ethnic category 2001 census
 |  |  |  | White British
 |  |  |  | Punjabi - ethnic category 2001 census |  |  |  |  | S
 |  |  |  | White British - ethnic category 2001 census |  |  |  |  | S
 |  |  | E01030709 | White British
 |  |  | E01030709 | Indian or British Indian - ethnic category 2001 census
 |  |  |  | English - ethnic category 2001 census |  |  |  |  | C
Spreadsheet: 709429d1608302038-check-for-non-consecutive-duplicates-test-book
Sheet: Sheet1

Contract No | FORMULA CELL
12345 |  |  | << UNWANTED DUPLICATE
12346
12347 |  |  | << UNWANTED DUPLICATE
12348
12349
12350 |  |  | << UNWANTED DUPLICATE
12350 |  |  | << UNWANTED DUPLICATE
12351
12352
12353 |  |  | << UNWANTED DUPLICATE
12353 |  |  | << UNWANTED DUPLICATE
12353 |  |  | << UNWANTED DUPLICATE
12354
12355
12347 |  |  | << UNWANTED DUPLICATE
12347 |  |  | << UNWANTED DUPLICATE
12356
12357
12353 |  |  | << UNWANTED DUPLICATE
12358
12359 |  |  | << ACCEPTABLE DUPLICATE
12359 |  |  | << ACCEPTABLE DUPLICATE
12359 |  |  | << ACCEPTABLE DUPLICATE
12360
12345 |  |  | << UNWANTED DUPLICATE
12361
12350 |  |  | << UNWANTED DUPLICATE
12350 |  |  | << UNWANTED DUPLICATE
12362
12363
12364
12365 |  |  | << ACCEPTABLE DUPLICATE
12365 |  |  | << ACCEPTABLE DUPLICATE
12366
Spreadsheet: 745144d1629780567-how-to-pull-relevant-colour-fill-shading-from-an-indexed-cell-raid-log-risks-
Sheet: RAID Log

 |  |  |  | The Risk could affect (tick all that apply)
# | Type | Description of Risk | Status | Timeline / Schedule | Scope / Deliverable | Budget | Consequence / Impact | Likelihood / Probability | Risk Rating | Priority | Due Date | Assigned to | Mitigation/Controls/Follow-up | Discussion
1 |  |  |  |  |  |  | 1 - Insignificant | 5 - Almost Certain
2 |  |  |  |  |  |  | 5 - Severe | 3 - Possible
3 |  |  |  |  |  |  | 1 - Insignificant | 3 - Possible
4 |  |  |  |  |  |  | 1 - Insignificant | 2 - Unlikely
5 |  |  |  |  |  |  | 1 - Insignificant | 1 - Rare
6 |  |  |  |  |  |  | 4 - Major | 3 - Possible
7 |  |  |  |  |  |  | 5 - Severe | 5 - Almost Certain
8 |  |  |  |  |  |  | 1 - Insignificant | 5 - Almost Certain
9 |  |  |  |  |  |  | 2 - Minor | 5 - Almost Certain
10 |  |  |  |  |  |  | 3 - Moderate | 4 - Likely
11 |  |  |  |  |  |  | 4 - Major | 3 - Possible
12 |  |  |  |  |  |  | 5 - Severe | 2 - Unlikely
13 |  |  |  |  |  |  | 5 - Severe | 1 - Rare
14 |  |  |  |  |  |  | 4 - Major | 5 - Almost Certain
15 |  |  |  |  |  |  | 3 - Moderate | 1 - Rare
16 |  |  |  |  |  |  | 2 - Minor | 2 - Unlikely
17 |  |  |  |  |  |  | 1 - Insignificant | 3 - Possible
18 |  |  |  |  |  |  | 1 - Insignificant | 4 - Likely
19 |  |  |  |  |  |  | 2 - Minor | 5 - Almost Certain
20 |  |  |  |  |  |  | 3 - Moderate | 2 - Unlikely
Legend
Type = (R, A, I, D)     R - Risk, A - Assumptions, I - Issues, D - Dependancies
Status (O - Open, C - Closed, A - Active, P - Postponed)
Priority (H - High, M Medium, L - Low)
Avoid, Control, Transfer
Avoid, Control, Transfer
Watch, Assume
 |  |  |  | Risk Probability and Impact Matrix
 |  |  |  |  |  | Consequence/Impact
 |  |  |  |  |  | 1 - Insignificant | 2 - Minor | 3 - Moderate | 4 - Major | 5 - Severe
 |  |  |  | Likelihood/Probability | 5 - Almost Certain | M | H | H | E | E
 |  |  |  |  | 4 - Likely | M | M | H | H | E
 |  |  |  |  | 3 - Possible | L | M | M | H | E
 |  |  |  |  | 2 - Unlikely | L | M | M | M | H
 |  |  |  |  | 1 - Rare | L | L | M | M | H
Spreadsheet: 6b257e8a-c958-4ab7-9ecf-643fc745c8b9
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
[NAME] | Test | [NAME] | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. -8 p.m., Saturday; 8 a.m. -3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6152-3
Spreadsheet: gerald_nemec__11510__Alamac Permit Matrix
Sheet: Kilpatrick Permit Matrix

Alamac Permit Matrix
Permit/Approval | Date of Application |  | Date of Approval |  | Restrictions/Conditions
 | Actual | Expected | Actual | Expected
US Federal Aviation Administration
Notice of Proposed Construction
Federal Energy Regulatory Commission
Certification of Exempt Wholesale Generator Status
Power Marketer Certification
US Department of Energy
Exemption to burn natural gas and No. 2 fuel oil
US Army Corps of Engineers
Wetlands (Letter of Concurrence)
US Fish and Wildlife Service
Threatened and endangered species (Letter of Concurrence)
North Carolina Public Utilities Commission
Certificate of Public Convenience and Necessity
North Carolina Department of Environment, Health and Natural Resources
Authority to Construct Permit (Air Permit)
Title IV Operating Permit (Air Permit)
Title V Operating Permit (Air Permit)
NPDES Stormwater Construction Permit
Sedimentation Control Plan Approval
SPCC Plan
Department of Transportation
Driveway Permit
Department of Cultural Resources
Archaeological survey approval (Letter of Concurrence)
North Carolina Secretary of State
Certificate of Authority (Business License)
County of Edgecombe, City of Rocky Mount
Annexation
Conditional Use Permit
Water service
Local Construction Permit
Certificate of Occupancy
Fire Safety Approval
Spreadsheet: 492975d1481377112-basic-increment-cell-reference-comp-book-template-2016-_-as
Sheet: SPREADSHEET

ACCOUNT# | PARCEL# | SITUS | CITY | NBHD | SUBDIVISION | SALE DATE | SALE PRICE | ACRES | YEAR BUILT | HEATED AREA | BATH | BEDROOM | STORIES
R000123 | 123123123123 | 123 DRGO AVE | DURANGO | LUCAS MESA | CLIFFS | 2015-06-30 00:00:00 | 365000 | 34.6 | 2015 | 2650 | 2 | 3 | 2
R000333 | 333333333333 | 333 DRGO AVE | DURANGO | LUCAS MESA | CLIFFS | 2015-06-20 00:00:00 | 298500 | 25 | 2005 | 2150 | 1.75 | 2 | 1.5
Spreadsheet: 169586d1342969424-how-to-apply-countif-formula-when-data-are-on-different-sheets-book1
Sheet: October

 |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
S.no | Employee Name | SID | Process | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00 | 2012-10-08 00:00:00 | 2012-10-09 00:00:00 | 2012-10-10 00:00:00 | 2012-10-11 00:00:00 | 2012-10-12 00:00:00 | 2012-10-13 00:00:00 | 2012-10-14 00:00:00 | 2012-10-15 00:00:00 | 2012-10-16 00:00:00 | 2012-10-17 00:00:00 | 2012-10-18 00:00:00 | 2012-10-19 00:00:00 | 2012-10-20 00:00:00 | 2012-10-21 00:00:00 | 2012-10-22 00:00:00 | 2012-10-23 00:00:00 | 2012-10-24 00:00:00 | 2012-10-25 00:00:00 | 2012-10-26 00:00:00 | 2012-10-27 00:00:00 | 2012-10-28 00:00:00 | 2012-10-29 00:00:00 | 2012-10-30 00:00:00 | 2012-10-31 00:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 804743d1668263302-missing-alphanumeric-sequence-alphanumeric-sequence
Sheet: Sheet1

Invoice Number |  |  |  | Expected Result
C01063381 |  | C01063382 |  | X01003458
C01063384 |  | C01063388 |  | C01063382
C01063386 |  | CR01005474 |  | C01063388
C01063389 |  | K01003460 |  | CR01005474
CR01005471 |  | X01003458 |  | K01003460
CR01005473
CR01005476
CR01005478
CR01005480
[NAME]
K01003458
[NAME]
[NAME]
K01003465
X01003456
X01003459
X01003461
X01003463
X01003465
C01063383
C01063385
C01063387
C01063390
CR01005472
CR01005475
CR01005477
CR01005479
[NAME]
[NAME]
K01003459
K01003462
K01003464
X01003455
[NAME]
X01003460
X01003462
X01003464
Spreadsheet: 745000d1629645628-find-percentage-of-last-10-weeks-bo-backtesting
Sheet: RESULTS

 | ANNUALIZED GROSS |  |  |  |  |  |  |  |  |  |  |  |  |  | MARKET CAP |  | Min 10 results per section
 |  |  |  |  |  | Price | Shares |  |  |  |  |  |  |  | FLOAT |  | Average results
 | Position size for stocks < |  |  |  |  | 10 | 1000
 | Position size for stocks < > |  |  |  |  |  | 500 |  |  |  |  |  |  |  | TRADES | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Position size for stocks > |  |  |  |  | 30 | 100 |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Selling 1/2 @ | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | NOTES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENTRY | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Entry is within 10c of BO level |  |  |  |  |  |  |  | WEEKLY |  |  |  |  |  | < 100M
 | [NAME] stop loss is -30c |  |  |  |  |  |  |  | WEEK | TRADES | WIN % | G/L | G/L < 13 |  | 100-500M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | GAIN/LOSS |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 |  | All | > 1 pt | > 2 pt | > 3 pt | > 4 pt | > 5 pt
 | Win/Loss % |  |  |  |  |  |  |  |  |  |  |  |  |  | WIN % | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Days |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 | Trades |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | Wins |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 | Gain /s (Total) |  |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | % Gain /s (Total)
 | Gain /s (Wk Ave) |  |  |  |  |  |  |  |  |  |  |  |  |  | G/L | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 | Entry Success % |  |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | SETUP |  |  |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  | Count |  | Win % | Last 10 Wk | G/L | Entry % |  |  |  |  |  |  |  | 1B <
 | PMH
 | PM Consolidation
 | Consolidation
 | Pivot
 | HOD
 | POP
 | Daily Resistance
 | MAX GAIN
 |  | Ave | Mean
 | Entry-High
 | High-Exit
 |  |  | > 1 pt | > 2 pt | > 3 pt | > 4 pt | > 5 pt
 | Trades
 | % of All
 | ENTRY TIMES (WINNING TRADES)
 |  | Trades |  | Ave
 | 8:00-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-14:59
Spreadsheet: 713207d1610596194-extract-values-in-column-c-into-column-j-extract-values_sample1
Sheet: Sheet1

# | ID | Abbr | Names | Extrated Names | Extracted IDs |  | ta |  |  | [NAME]
1 | TA32785655 |  | Tbnor, Aadigan | Tbnor, Aadigan | TA32785655
2 | SA12442673 |  | Abo, [NAME] | Tbnor, Aadigan | TA53245548
3 | AA21259159 |  | Tbra, [NAME] | Tbnor, Aadigan | TA13291311
4 | CA84636028 |  | Abrahaim, Cadman
5 | OA61505754 |  | [NAME], Cadmus
6 | LB71531251 |  | Tbrahame, [NAME]
7 | TB19548089 |  | Abrahamo, [NAME]
8 | SB46327164 |  | [NAME], Cadorette
9 | PB67349700 |  | Abraheem, [NAME]
10 | EB32531079 |  | Tbrahem, [NAME]
11 | SC17296774 |  | Abrahim, Cadwallader
12 | FC70634829 |  | Abrahm, Cadwell
13 | AD17153037 |  | Abrahon, Cady
14 | CD14845828 |  | Abrahsa, Caesar
15 | JG66805710 |  | Abram, Caetano
16 | CH36848865 |  | Abramo, Cafarella
17 | CL41033165 |  | Absalon, Cafarelli
18 | LL21590248 |  | Abselon, Cafaro
19 | RK32756907 |  | Absolom, [NAME]
20 | EM26000697 |  | Absolum, [NAME]
21 | MM12168514 |  | Tbnor, Cadigan
22 | HO10339330 |  | Hub, Oest
23 | RS31728184 |  | Room, Say
24 | SS43010028 |  | Say, Saying
25 | TT33991592 |  | [NAME], [NAME]
26 | CV22833553 |  | Call, Vict
27 | [NAME] |  | [NAME], Wins
28 | JW15786388 |  | [NAME], Winsr
29 | BO44794874 |  | Boy, Crazyin
30 | TA53245548 |  | Tbnor, Aadigan
31 | JS13672576 |  | [NAME], IsLord
32 | TA13291311 |  | Tbnor, Aadigan
Spreadsheet: 186420d1350036886-search-beers
Sheet: W

Brewery |  | Beer
Wadworth |  | Henry’s Original IPA
 |  | 6X
 |  | Old Timer
Wards |  | Thorne Best Bitter
 |  | [NAME]
 |  | Waggledance
Warwickshire |  | Shakespeare County
Waveney |  | East Coast Mild
[NAME] |  | Best Cask Bitter
Wells |  | Eagle IPA
 |  | Bombardier Premium Bitter
Wentworth |  | [NAME]
West Berkshire |  | Skiff
West Coast |  | North County Mild
 |  | DNC Best Bitter
 |  | DNC Guiltless Stout
 |  | DNC Yakima Grande Pale Ale
 |  | Festival Ale (GNW Bolton 1991)
 |  | Big Heavy Jimmie
 |  | Guiltless Stout
West Highland |  | Highland Severe
 |  | Highland Heavy
WFG |  | Hammered
Wharfedale |  | Executioner
White Horse |  | Bitter
White Star |  | U-X-B
Wickwar |  | Coopers WPA
 |  | Brand Oak Bitter
 |  | Olde Merryforde Ale
 |  | Premium Spring Ale
Wild |  | Wild Blonde
[NAME] |  | [NAME]
[NAME] |  | Best Bitter
Wood |  | [NAME]
 |  | [NAME]
 |  | Christmas Cracker
[NAME] |  | [NAME]
Woodforde’s |  | [NAME]
 |  | [NAME]’s revenge
 |  | Norfolk Nog
 |  | Baldric
 |  | Great Eastern Ale
Woodlands |  | [NAME]
Worth |  | [NAME]
Wortley |  | Best Bitter
Wychwood |  | Hobgoblin
 |  | Dr [NAME]
 |  | [NAME]
 |  | Black Wych Stout
 |  | [NAME]
Wye Valley |  | [NAME] Wholesome Stout
 |  | Brew 69
Spreadsheet: 291722d1390387812-copying-code-down-a-column-without-all-cell-references-updating-corrected-messy-formula-rj-tms-v2
Sheet: Sheet1

Select Price Group: | PG0 |  |  |  | DV: =INDIRECT("AshleyAnn[[#Headers],[PG0]:[PGF]]")
Search Items
Code | Description | Price | Qty | Total
[NAME] |  |  | 1
B6DP2D |  |  | 2
B6DP1D3S |  |  | 3
DV: =INDIRECT("AshleyAnn[Product Code:]")
 | =IF(A5="","",VLOOKUP(A5,AshleyAnn,2,0))
 |  | =IF(A5="","",VLOOKUP(A5,AshleyAnn,MATCH($B$2,AshleyAnn[#Headers],0),FALSE))
 |  | replaces:
 | Table1 on Price Table sheet renamed AshleyAnn | =IF(A5="","",VLOOKUP(A5,AshleyAnn,MATCH($B$2,{"a","b","c","PG0","PG1","PG4","PG7","PG9","PG12","PG15","PG18","PG20","PG22","PG25","PG28","PG31","PG34","PG37","PGC","PGD","PGE","PGF"},0),FALSE))
 | (after changing references to AshleyAnn to use Table1 | (which still works)
 | and then deleting the Named Range AshleyAnn)
 | Named Range PriceGroups deleted
 | AshleyAnn still appears in Name Manager but it is now system maintained and cannot be edited
 | No more Named Ranges; Long Live Tables :)