Statistical Analysis Tools GET/MEMS/*MEMS Elliott Linder

1
Statistical Analysis ToolsGET/MEMS/MEMSElliott
Linder

• QuestelOrbit Workshop
• PIUG Annual Meeting
• 4 May 2003
• Chicago, IL

2
Statistical Analysis Tools

• 1. Competitive Analysis
• Extracting Patent Assignees from a dataset and
  creating a chart in Excel
• GET it ?

3
Competitive Analysis
4
Competitive Analysis
Multiline Entry
5
Competitive Analysis
6
Competitive Analysis
GET PA TOP 10
7
Competitive Analysis
Use MEMS instead of GET to produce a complete
alphabetical listing, e.g., MEMS SET ALPHA
/PAN PRT MEM2 NONSTOP
8
Competitive Analysis
Select and Copy
Be sure to select area out to left margin.
9
Competitive Analysis
Edit gtgt Paste Special
10
Competitive Analysis
Select Text from the list.
11
Competitive Analysis
12
Competitive Analysis
Data gtgt Text to Columns
13
Competitive Analysis
14
Competitive Analysis
Notice data now in separate columns.
15
Competitive Analysis
Chart Wizard
16
Competitive Analysis
17
Competitive Analysis
Series tab
Names added to legend
18
Competitive Analysis
19
Competitive Analysis
Legend tab
Legend tab
20
Competitive Analysis
21
Competitive Analysis
Not looking just right ?
22
Competitive Analysis
Resize and reposition chart and/or source data.
23
Competitive Analysis
Et voilà !
24
Statistical Analysis Tools

• 2. Modifying a Search Strategy
• Extracting and reviewing ECLA codes from a
  PlusPat result set and expanding the search

25
(No Transcript)
26
(No Transcript)
27
(No Transcript)
28
Look up selected codes in ECLADEF file.
29
Bingo !
30
Search ECLA code in PlusPat. NOT out original
set.
31
Not retrieved with text search alone
32
(No Transcript)
33
FAM SS 6 Captures family members not having
ECLA codes.
34
75 families with more than twice the number of
patents
PRT MSTD (standard family display)
35
(No Transcript)
36
Statistical Analysis Tools

• 3. Migrating a Search Strategy
• Extracting IPCs from PlusPat to migrate a search
  or SDI (alert) from USPAT to PCTFULL

37
Run search in USPAT
38
FI PLUSPAT EX 1-24 FROM USPAT
Re-executes search in PlusPat (US class/subclass
available)
39
GET IC TOP 10
40
Decide frequency criteria for review e.g., only
review if FREQgt10
Search desired codes in ECLADEF file.
41
Print ECLADEF records.
42
Review definitions.
43
Modify USPAT strategy, appropriately
incorporating selected IPCs upload and run in
PCTFULL.
44
PCTFULL results
45
PCTFULL History
46
Thank you for being here this afternoon.Enjoy
the PIUG meeting !!!Be sure to attend the IFFI
Players Production of Harvey Tuesday evening.