Categories
Uncategorized

Topic Search for DAX and M

Here is a Topic Search that identifies various resources for the DAX and M

Some are well known, and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

Three sub reports are extracted from the Google source page:

  1. Landing page for each discovered URL.
  2. Title for each discovered URL.
  3. List of Google suggested search terms. Note: Google suggestions are not returned from Google Image searches.

The process begins with the Google “All” search. This search is re-run several times to collect and incorporate new Google search suggestions. Once a fair number of search terms have been processed, the collection of search strings in modified and then processed with the Google Image Search engine. All these uncombined reports are collected to a specific folder. Then the secondary process is executed to aggregate the collection of sub reports.

The five outputs are then collected and posted.

  1. List of the search strings
  2. List of Google Suggestions
  3. Discovered Landing Pages
  4. Discovered URLs and Titles
  5. Complete Report

List of Search Strings

List of Google Suggestions

Landing pages discovered by the Google Searches. Each landing page tabulates the top five search strings that produced the landing page. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some landing page links may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed. It is also possible that the link may no longer be active.

URLs and Titles –details each discovered URL, giving its title and identifying the search strings that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports. – note the complete report enables the user to apply the advanced filter capability of Excel to extract detailed results from the report which may contain hundreds of URLs

For more information, contact me

alfred(dot)vachris(at)gmail(dot)com

Categories
Uncategorized

Topic Search for Power Query

Here is a Topic Search that identifies various resources for the Power Query

Some are well known, and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

Three sub reports are extracted from the Google source page:

  1. Landing page for each discovered URL.
  2. Title for each discovered URL.
  3. List of Google suggested search terms. Note: Google suggestions are not returned from Google Image searches.

The process begins with the Google “All” search. This search is re-run several times to collect and incorporate new Google search suggestions. Once a fair number of search terms have been processed, the collection of search strings in modified and then processed with the Google Image Search engine. All these uncombined reports are collected to a specific folder. Then the secondary process is executed to aggregate the collection of sub reports.

The five outputs are then collected and posted.

  1. List of the search strings
  2. List of Google Suggestions
  3. Discovered Landing Pages
  4. Discovered URLs and Titles
  5. Complete Report

List of the search strings

List of Google Suggestions

Landing pages discovered by the Google Searches. Each landing page tabulates the top five search strings that produced the landing page. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some landing page links may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed. It is also possible that the link may no longer be active.

URLs and Titles –details each discovered URL, giving its title and identifying the search strings that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports. – note the complete report enables the user to apply the advanced filter capability of Excel to extract detailed results from the report which may contain hundreds of URLs

For more information, please contact me at alfred(dot)vachris(at)gmail(dot)com

Categories
Uncategorized

Expanded Topic Search that identifies various resources for working with Excel workbook using Python and Pandas

Here is an Expanded Topic Search that identifies various resources for working with Excel workbook using Python and Pandas

This report is in response to a current series of questions about how to use Python to work with Excel workbooks.

Some of this resources are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Categories
Uncategorized Web Scavenging

Expanded Topic Search that identifies various resources for Creating Research Projects for High School Students.

I believe that this Topic Search Process could provide High School Students a running start at the beginning of their research studies.

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Categories
SmartWare Web Scavenging

Expanded Topic Search for NotePad ++

Here is an Expanded Topic Search that identifies various resources for NotePad ++

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Categories
Web Scavenging xlGenie

Expanded Topic Search for Index and Match

Here is a Topic Search that identifies various resources for Index and Match.

This is a reposting of an earlier report. This new report integrates results from the Ordinal Google Search along with results from Google Image Searching.

As of yet, reporting on YouTube finds, does not include and detailed metadata about the YouTube.

Some links are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms (Search terms are not returned by Google Image search)

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports

Categories
SmartWare Web Scavenging

Topic Search OneNote

Here is a Topic Search that identifies various resources for OneNote

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Categories
Web Scavenging xlGenie

Topic Search Excel Advanced Filter

Here is a Topic Search that identifies various resources for the Excel Advanced Filter

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Categories
SmartWare Web Scavenging

Topic Search AutoHotKeys

Here is a Topic Search that identifies various resources for AutoHotKeys

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Categories
Web Scavenging xlGenie

Topic Search that identifies various resources for Index and Match.

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.