Introduction:
This is a tool that can be used to find the nearest existing site for a bulk of newly planned sites.This tool can be used by those don't have map info. This tool can be used up to 19999 existing sites . But there is no limitations on new planned sites count. The only thing that we need remember is ,the time required to complete the process will increases based on the newly planned site count. The approximate time required to get the output has mentioned below.
| Planned Site Count : | 25 | 50 | 100 | 300 | 500 | 1000 |
| Total Existing Site : | 19999 | 19999 | 19999 | 19999 | 19999 | 19999 |
| Approximate Time to Complete (Min) in PC: | 1 | 1.5 | 3 | 8.3 | 16 | 30 |
| Approximate
Time to Complete (Min) in
Laptop : |
0.2 | 0.45 | 1.5 | 3.5 | 7.5 | 15 |
Instructions:
1. Do not change the File name of this tool
2.Ensure The Existing Site count should not exceed 19999
3.The Tool is password protected . Password : techspoon
4.Do not Alter any data in Sheet3
5.If u want to stop in between , please use Esc button.
6.If Tool Hang , Close the Tool without Saving. Then Re-open
7.Avoid Blanks in the site entry
8.Ensure the Calculation Option is selected as " Automatic"
9.Ensure this file size not exceeds more than 3MB while closing this macro. (This may slow down the processing speed)
10. Please refer "Instructions " sheet in the tool to know ,How to execute the tool.
Please use this tool either in Laptop or PC. Using in Mobile is not recommended.
The tool can be download from the below link.
ClickHere:Tool to Find The Shortest Site for New Planned Sites without Map Info.
If any issue observed while running the tool please post in the comment section.
Thanks and Reg
Aneesh.M