BatchTools



In a few easy steps you can download an Excel workbook template, fill in required values, and submit a batch request to analyze Elevation, HAAT, Radial HAAT, DHAAT/ShortSpacing ( 90.621 ), Service/Interference Contours, and Coverage Maps.

Usage Synopsis

  • If a first-time user, follow the ten steps sequentially.
  • After your first submission, you will most likely use only steps five though ten as you will not need to read the terms and conditions, usage synopsis and have already downloaded ( and possibly modified ) the Excel template workbook file.
  • When batches complete, you can export to HTML or CSV formats. CSV format is recommended for Excel users, although later versions of Excel can also read tables in HTML/XML format.
  • Rules for Modifying the Template Excel Workbook

  • Before submitting an Excel workbook for batch processing, make sure that all rows with blanks are cleared/deleted. You can see the extent of "active" cells by typeing Ctrl-End, if the cursor positions beyond your active data, then you need to select that "blank" range and delete it, as well as perform a clear-all on the same range.
  • The BatchSubmissionTool allows for up to 100 rows in a submission. If you submit more than 100 rows in a workbook, the batch request will be rejected.
  • Required Values for Each Batch Submission

  • Columns (in the template Excel workbook) that have colored cells decending below the heading are required for the batch submission.
  • Different types of batch submissions have different required columns.
  • Columns that are not required are for the most part ignored, however, they are useful to those doing regular spectrum planning to capture the context of the assets under analysis when the result of a batch submission is downloaded.
  • Here is a handy color picking tool that can be used to select a hexadecimal number to represent the color of your contour(s) when using the VisualBatch submission tool.
  • Export Formats after Batch Procesing

  • HTML - A simple HTML table that is importable to some applications ( e.g., Excel ); most applications that can import XML can also deal with this format.
  • CSV - A simiple, Comma-Separated-Values text file that is importable to almost all applications.
  • Google Maps

  • Some batch submissions produce a .KML file URL that is then imported in to Google Maps
  • Google Maps 2.0 lets you paste the .KML file URL directly in to the maps search textbox and then will apply the .KML file to the map. Done.
  • Google Maps 3.0 requires you to "add" the .KML file to "My Places"
  • Some batch submissions produce a Google Maps URL that you can paste directly in to your browser's URL textbox. Done.
  • Browser Issues

  • Not all browsers are configured the same -- some may be configured not to allow downloads, uploads, cookies, javascript, java, etc.
  • Formatting and display layouts vary across browsers.
  • Browsers built on WebKit technology will work fine.
  • Microsoft's IE platform is, at best, problematic; even the most current versions of IE are a mess.
  • Google's Chrome browser works best with this website.



  • Map