Categories
Web Scavenging xlGenie

Topic Search Excel VBA Memory Leaks

Here is a Topic Search that identifies various resources for identifying and controlling Excel VBA memory leaks

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 XLOOKUP

Here is a Topic Search that identifies various resources for XLOOKUP.

Some well known and some not so well known.

My topic search report begins with a list of search strings which are then 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 for Regular Expressions

Here is a Topic Search that identifies various resources for Regular Expressions.

Some well known and some not so well known.

My topic search report begins with a list of search strings which are then 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.

The Topic Search Process has been improved to include the choice of two compound search strings that expand the scope of the Google Search.

String A – To find PDF’s:

chap01 OR chapter 01 OR chap 1 OR chapter 1 OR ch01 OR ch1 OR book OR book-pdf OR books OR dig_lib OR doc OR documents OR downloads OR ebook OR etextbook OR library OR pdf OR readingroom OR themes OR upload filetype:pdf

String B – To focus on Blogs and Newsletters:

blog OR blogposts OR blogspot OR guru OR tutorial OR posts OR newsletter OR podcast OR slideshare OR courses OR online OR MOOC

The composite reports are presented here.

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 gathered from all the Google Searches.

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 Learn Excel VBA

The key to automating Microsoft Excel depends on a mastery of Excel VBA.

Here is a Topic Search that identifies various resources for learning Excel VBA.

Some well known and some not so well known.

My topic search report begins with a list of search strings which are then 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.

The composite reports are presented here.

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 three times!

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

Categories
Uncategorized

Topic Search Cisco Webex

Working from home is the new normal.

Clearly Cisco Webex is a significant application than can effectively make working from home more productive.

To better understand how and why and when to use Cisco Webex, I ran my topic search process to explore the various aspects of Cisco Webex as well as gathering a collection of resources related to Cisco Webex.

My topic search report begins with a list of search strings which are then 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.

The composite reports are presented here. 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 three times!

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

Categories
Uncategorized Web Scavenging

Topic Search for ZOOM

Learning at home is also part of the new normal.

ZOOM is one application that has received a lot of notice.

Clearly Zoom is a significant application than can effectively make learning at home more productive.

To better understand how and why and when to use ZOOM, I ran my topic search process to explore the various aspects of ZOOM as well as gathering a collection of resources related to ZOOM.

My topic search report begins with a list of search strings which are then 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.

The composite reports are presented here.

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

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

Categories
Uncategorized Web Scavenging

Topic Search for Microsoft Teams

Working from home is the new normal.

Clearly Microsoft Teams is a significant application than can effectively make working from home more productive.

To better understand how and why and when to use Microsoft Teams, I ran my topic search process to explore the various aspects of Microsoft Teams as well as gathering a collection of resources related to Microsoft Teams.

My topic search report begins with a list of search strings which are then 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.

The composite reports are presented here.

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 three times!

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

Categories
Dot to Dot Calculus

Arc Length Calculation for 2-D and 3-D Tabular Functions

Arc Length Routines ARCLNG and ARCXYZ

My routines for estimating the arc length of a curve follow the concept of covering the curve with a collection of circular arcs. Examples of this concept can be found in Technical Drafting Text Books.

Following my focus of examining the local behavior of the curve by working with a sliding set of three points

Using a sliding set of three points to capture the local behavior of the curve presents then the image of a circumscribing circle for each set of three points.

Heron’s formula provides a direct way to compute the area a triangle with sides: a, b and c.

Letting s be the semi-perimeter of the triangle: s=(a+b+c)/2

Then the Area = SQRT(s(s-a)(s-b)(s-c))

This formula can be replaced with a simpler computation when the triangle is 2-D.

Area = 0.5 * ((xb – xa) * (yc – yb) + (xb – xc) * (yb – ya)) where the triangle vertices are:

(xa,ya) ,(xb,yb) and (xc,yc)

There are two important features to be noted about this process:

  1. The three points determine a plane as well as a circle.  Applying Heron’s formula for the Area allows this process to approximate the arc length of three-dimensional tabular functions.
  2. As the points slide along the curve, all interior intervals are covered by a left and right arc. My calculation averages the lengths of the two arcs.

ARCLNG – a subroutine to calculate the arc length of a two-dimensional curve.

The ARCLNG routine estimates the two-dimensional arc length distance starting from the first point to each point along the curve.

Usage:        CALL ARCLNG(X,Y,S)

Description of Parameters:

X          input vector of X-coordinate values (DIMENSION N)

Y          input vector of Y-coordinate values (DIMENSION N)

S          output vector of arc lengths (DIMENSION N)

ARCXYZ – a subroutine to calculate the arc length of a three-dimensional space curve.

The ARCXYZ routine estimates the three-dimensional arc length distance from the first point to each point along the curve.

Usage:        CALL ARCXYZ(X,Y,Z,S)

Description of Parameters:

X          input vector of X-coordinate values (DIMENSION N)

Y          input vector of Y-coordinate values (DIMENSION N)

Z          input vector of Z-coordinate values (DIMENSION N)

S          output vector of arc lengths (DIMENSION N)

Note:  The application of these routines is NOT limited to evenly spaced values of the argument.  However, abrupt changes in the spacing of the argument can have an adverse effect on the performance of this subroutine and should be avoided.   On the other hand, as with most numerical procedures, better results can be expected from uniformly spaced argument values.

It’s important to point out that these routines have incorporated two supporting routines that enable the efficient exchange of data between Excel worksheets and VBA arrays.

The way these are used:

Corrected Versions of the Workbooks for ARCLNG and ARCXYZ are available from DropBox

https://www.dropbox.com/l/scl/AABKirG-DWJMXDrLTOlbglZcD-ygq41TpBM

https://www.dropbox.com/l/scl/AACoSxLDbGgHtI1yIGVFD-q4sTl3aA0qin0

Categories
Web Scavenging xlGenie

Topic Search Excel Range Names

Full Report

List of Direct URLs

List of Search Strings

Categories
Web Scavenging xlGenie

Topic Search VBA and Web Scraping

Here is the full report

Here is the list of Direct URLs

Here is the list of Search Strings