Distance and Time Calculator USER MANUAL - Opti XL
Contents
1. csv Check for update Now you can check for newer version For registered copy Net Framework 4 0 Benefits of latest MS Windows features Many bugs have been fixed for improved stability Minimum requirements The minimum requirements for using the add in are Windows operating system XP Vista and 7 Microsoft NET Framework 4 0 Microsoft MapPoint 2004 or newer Optionally in order to open the output file you need an application compatible with one of these file formats Microsoft Excel 97 2003 or 2007 Microsoft Access 2000 The more powerful your processor is the faster you will be able to compute the distance and time for a given pushpin set It will run on single processor systems easily As an example to compute distances and times between two 65 pushpin sets requires around 10 minutes on an AMD Athlon 2 2 GHz Symmetrical route and Hide MapPoint options selected Opti XL l July 2011 OptiXL Distance and Time Calculator Install and removal How to install After downloading DistTimeCalcSetup msi you can launch the Microsoft installer by double clicking the file to install DistTimeCalc on your computer DistTimeCalcSetup msi It will add to Microsoft MapPoint a new menu item called Distance and Time Calculator in the Tools menu as shown here Tools Find Ctrl F Find nearby places Ctrl D Find coupons Ctri J Search results Ctrl K show in Bing Maps Ctrl H Send to mobi2. Pushpin set Origin and Destination This will reduce the processing time by half o Hide MapPoint during computation This option slightly reduces the processing time because Windows does not have to redraw the routes each time This option should be selected when computing large Pushpin sets New in version 1 2 Computation tweaks Symmetric route Hide MapPoint Opti XL 11 July 2011 OptiXL Distance and Time Calculator Time units The time units used to compute driving and trip times can be in Day Hour Default or Minute Time units O Day Gei Hour C 3 Minute Preferred Output This option remembers your preferred file format to save the result The format can be one of these MS Access 2000 mdb MS Excel 97 2003 xls MS Excel 2007 xlsx Comma Separated Values csv Hyper Text Markup Language html A file will be created for every tables data to export when saving the result in Hyper Text Markup Language or Comma Separated Values format The name of the table will be appended at the end of the filename e g Warehouses to Customers Distance csv Saving the result with more than 256 columns is not possible in MS Excel 97 2003 or MS Access 2000 due to column limitation If ever the limit is exceeded those two formats will not be available to save the file Prefered output MS Excel 37 2003 pds sw MS Excel 97 2003 tds MS Excel 2007 bax MS Access 2000 md
3. ans sivaeesancnan cate ceaniersvnes sate E E 9 PCA VO e cectiecas E ose E octealiomae sips E cen aieameviens scene A 10 Unmatched DUS DUNS eessdengeebggsgeegedeg eg Eeeedegehggeg sde ed 10 EE 10 Configuration EEN 10 Configuration EIERE E esmensasaatanadan dens aeanadesinaktanastasaeaa iP ancanssiaaeeecuaatsonsaae 1 DIGIC TO CIO e r iano teu E EEE AA E E TE E A II Computation tweaks oecceccccccsccccnececneecceeee ce neee ee eee ee eeee eG ee eeEEEEE GEESE AEE E IE SE A SESE GA EEGE ESSE EE ESSE EE ES 1 RE 12 PVC CV PCA Eeer 12 IV EE 12 EE 13 MUS TNC a A E E E E sue A E E EA 13 Opti XL i July 2011 OptiXL Distance and Time Calculator Introduction Distance and Time Calculator DistTimeCalc dll is an Add in for Microsoft MapPoint This add in automates the calculation of driving distance and time between many locations You can calculate quickly the distance between your customers and warehouses or between sales points The Add in will rapidly create a compatible Microsoft Excel workbook or Access Database from pushpin sets for in a few clicks The results are exported in an easy to read matrix format The workbook will contain worksheets for the distances the driving time the trip time and or cost This manual will guide you in installing the software and how to use it New features Version 1 3 has been improved in many ways The following features have been added Two new export formats HTML and Comma Separated values
4. b Comma Separated Values csv mer Ted Markup La General This section contains two options to improve the behavior of the software o Close after computing will automatically close the software after the process is finished when checked Default o Automatically open file after export will open the workbook after it has been saved when checked General Close after computing Automatically open file after export Opti XL 12 July 2011 OptiXL Distance and Time Calculator Known issues Version 1 3 of Distance and Time Calculator is stable and has been tested on different computers versions of Microsoft MapPoint and Windows operating systems There are no known issues Bugs fixed The following bugs have been fixed in Distance and Time Calculator version 1 3 e Error when exporting to MS Excel 2007 more than 256 columns e Resize issue e Better handling of duplicate values and unmatched pushpins Opti XL 13 July 2011
5. i EEN a Se ee ES Distance and Time Calculator Select the Pushpin sets you wantto calculate driving distance and time information for then click Calculate Origin Warehouses m Destination Customers vd Calculate Distance and Time Calculator Version 1 3 USER MANUAL Qpti XL July 2011 Software License THE SOFTWARE IS PROVIDED UNDER THE TERMS OF THIS SOFTWARE LICENSE LICENSE THE SOFTWARE IS PROTECTED BY COPYRIGHT AND OR OTHER APPLICABLE LAW ANY USE OF THE SOFTWARE OTHER THAN AS AUTHORIZED UNDER THIS LICENSE OR COPYRIGHT LAW IS PROHIBITED THE SOFTWARE CAN NOT BE SOLD OR DISTRIBUTED COMMERCIALLY WITHOUT THE WRITTEN CONSENT OF THE AUTHOR OPTIXL THE AUTHOR DOES NOT OFFER ANY WARRANTY ON THE PERFORMANCE OF THE SOFTWARE AND LIMIT LIABILITY FOR ANY DAMAGES TO THE PURCHASE PRICE OF THE SOFTWARE IF APPLICABLE BY ACCEPTING THIS LICENSE THE AUTHOR GRANTS YOU THE RIGHT TO INSTALL AND USE THE SOFTWARE WITHIN THE LIMITS DEFINED THEREAFTER THE TRIAL VERSION HAS A PERIOD OF 30 DAYS AFTER WHICH THE USER WILL BE REQUIRED TO BUY A PRODUCT KEY TO CONTINUE USING THE SOFTWARE PRODUCT KEYS ARE ON A PER USER BASIS HENCE ONLY THE REGISTERED USER IS ENTITLED TO USE THE SOFTWARE EXCEPT FOR CORPORATE LICENSE Privacy policy Softwares developed by OptiXL do not collect any information on the computer or on its use Any information provided to us during registration if required is for the sole purpose of keeping sta
6. ile will look something like this Qa el wi S My Pushpins xls Compatibility Mode Microsoft Excel non co m X toa _ Home Insert Page Layout Formulas Data Review View Add Ins m X B A M5 Sans Seri 710 General A SE E E Be EE B T U A A lz sale 2 Ss Zi Delete 7 bs dar ASE i el i 1 LU EE I Eea ess aa TI Bi Format 2 gt Clipboard Te Font Ej Alignment E Number s Cells Editing aE Gi D E G H E 1 VErormd oilcusg Custe Custi WHI Cust4 Cust6 Custh Cust i Cust U rl z5 406z B07 185675 232 353 301 136 515 55 A Cust dl 2l 0 42 06 bebe 114064 162 544 231 097 445 512 4 Gust 40 61 45 521 0 42 66 157205 205665 266 446 462 911 D WAH Zb Zh 54 041 42 05 0 116 5652 165 052 253 075 440 bh Cust4 166 405 114554 152205 125 725 be 55 121 103 335 208 d Custh 295 405 163 534 201 263 172 723 53 04 0 zegg 309 499 o Cust 303 617 231 746 269 495 243 435 122052 DEER 0 281447 J Cust DId d4d 446 905 466 152 465 092 336 209 308 42 262 409 HU 10 Sac TAH Distance Timey I O C I Ready ISO D 200e e _1 _ ai The unit of measure for the distance can be kilometers or miles depending on what is selected in your options Tools gt Options The unit is indicated next to From To as Km or Miles in the file Saving to another format At the end of computation the button Save As will be enabled to let yo
7. in set or the first 1f only one pushpin set exist in the map Next after selecting a Pushpin set for Origin and Destination you press the Calculate button to start the computation of the driving distance and time information and The bar at the bottom of the window will inform you of the progress d Distance and time calculator EN Select the Pushpin sets you want to calculate driving distance and time information for then click Calculate ee Computing 6 of 16 amp At the end you will be asked to save the file By default the name of the Pushpin sets will be suggested and the save location will be your default folder My Documents Save As Save in My Documents My Recent Documents Desktop My Documents ei My Computer File name Warehouse to Customers xls wt My Network Save as type Excel files 6ds wi This will produce a Microsoft Excel workbook or Microsoft Access database containing a worksheet table for every data to export selected At the end you will be asked if you want to open the file By clicking Yes the output file will be opened by the registered application You will also be able to save the file again or to other formats Oct XL 8 July 2011 OptiXL Distance and Time Calculator Process Complete Route distances and times calculated successfully for My Pushpins to My Pushpins Do you want to open the file now The output for a Microsoft Excel f
8. lculate Origin Warehouses COSES Destination Customers Calculate Data to Export dl Distance E Driving time F Address Origin E Cost E Trip time Computation tweaks Z Symmetric route E7 Hide MapPoint Time units Prefered output ey Day Ms Erce 57 003 bls ZE Ca Hour General eae E Close after computing C 3 Minute LI Automatically open file after export About Distance and Time Calculator Version 1 3 7011 Opti XL Trial version 30 days leit All rights reserved Activate your copy Ready Oct XL 5 July 2011 OptiXL Distance and Time Calculator Enter your e mail and product key to register the product Once registered your e mail and product key will appear in the About section like below About Distance and time Calculator Version 1 3 amp 2011 Opt XL Email sales optil com All rights reserved Product Key AAAAA BBBBBBB Check for update Ready E Oct XL July 2011 OptiXL Distance and Time Calculator How to Use Quick overview Follow these three steps to calculate the driving distances and times for the pushpin set after opening a Map file ptm in MapPoint 1 Go to Tools and click on Distance and Time Calculator 2 Select the pushpin sets Origin and Destination 3 Click Calculate At the end you will have a file with the driving distances and times for the pushpin set Step by step instructions Once you have sta
9. le phone Send to GPS device GPS GPS task pane Ctrl A Navigation pane Ctri B Full screen navigation view F11 Create drivetime zone Highlight Measure distance COM Add ins Options By default it will be started with MapPoint If you do not see the new menu item you can check in the Tools menu COM Add ins and make sure it appears in the list and that it is checked like below COM Add ins Location mscoree all Load behavior Load at startup i Before version 1 2 the application was named Get driving distance and time between a Pushpin set in the Tools menu Opti XL July 2011 OptiXL Distance and Time Calculator If Net Framework version 4 0 is not installed on your computer the message below will be displayed and you will be asked to install it Then you will be able to install this Add in G OptiXl Distance and Time Calculator Thiz setup requires the WET Framework version 4 0 Please install the NET Framework and run this setup again The NET Framework can be obtained from the web would wou like to do this now How to remove Distance and Time Calculator can be removed by starting the Add Remove programs in the Control Panel or by selecting Remove OptiXL Distance and Time Calculator if running DistTimeCalcSetup msi This will delete completely the software but not your results G OptiXL Distance and Time Calculator Sir Welcome to the OptixL Distance and Time Calc
10. mputation to stop Still you will be prompted to save to a file the computations done so far By opening the output file you will be able to determine which pushpin is causing the problem You will need to correct your MapPoint file ptm and then restart the computation Error while calculating A From origin Warehouse 1 to destination Customer As The parameter is incorrect Oct XL 10 July 2011 OptiXL Distance and Time Calculator Configuration options The configuration options are saved so that you don t have to set them each time and they will be the same for all MapPoint files unless you change them The following options can be configured Data to export Computation tweaks Time units Preferred output General The configuration options can be viewed or hidden by clicking on the gear image at the bottom right of the screen red circle below Data to export You can export the Distance Default the Cost the Driving time and the Trip time to your workbook Additionally the Address origin can be added to Distance worksheet Data to Export Distance Griving time Address Origin Gest Trip time Computation tweaks This section contains two performance tweaks in order to reduce the computation time o Symmetric route will calculate the routes as a triangular matrix This feature is only available when computing between the same
11. ontinue To configure or remove the existing version of this product use Add Remove Programs on the Control Panel Opti XL 4 July 2011 OptiXL Distance and Time Calculator Activate your product Buying a product key You can buy a Product Key online at http www optixl com products disttimecalc php The link at the bottom of the message will open your web browser to the proper page Once the purchase process is completed you will receive your Product Key by e mail Entering the product key The Trial version can be used for a period of 30 days and 1s a fully functional version of the product so you can try it before buying a copy After the first use of the product you will be asked to activate your product At start the following message will appear To continue using the trial version just click on the close button Product Activation fel Thanks you for trying our product The trial period will expire in 30 days Help us support this product by purchasing a Product Key for your copy Enter the following information to activate your copy E mail Product Key Visit Distance and Time Calculator web page The link Activate your copy will open the Product Activation form The number of days remaining for the Trial version will appear in the About section Ee Distance and Time Calculator Select the Pushpin sets you want to calculate driving distance and time information for then click Ca
12. rted MapPoint and opened a MapPoint Map you can run the Add in by going in the Tools menu and click on Distance and Time Calculator This will open the following window fy Distance and Time Calculator Select the Pushpin sets you wantto calculate driving distance and time information for then click Calculate Origin Warehouses mr Destination Customers Calculate It will list the Pushpin sets available in your current file for Origins From and Destinations To If no data set is found it will simply end by giving the message below This means that there is no data on the selected map Driving distance and time Information There are no pushpins sets on this map Please import your data and try again Also if the data sets on the map are not of pushpin type the following message will be displayed You will have to convert a data set to a pushpin set first Driving distance and time Information None of the data sets on your map are Pushpin type Try converting the set you want to query to a Pushpin set non aggregated or point data then run the Driving distance and time tool again i Before version 1 2 the application was named Get driving distance and time between a Pushpin set in the Tools menu Oct XL 7 July 2011 OptiXL Distance and Time Calculator By default the Origin will be set to the first pushpin set and the Destination will be set to the second pushp
13. tistics on our software use and will not be sold Support The software activated with a registered PRODUCT KEY receives full support and are eligible for product updates for their product version 1 Any inquiries for modifications or bug fixes are to be submitted through the support page at http www optixl com support php and will be reviewed in priority The TRIAL VERSION is provided with no support other than what is available in the documentation provided with it or on the website http www optixl com Updates will be releases on the website has they become available OptiXL Distance and Time Calculator Table of contents eA EE 1 Privacy OO costa coh streets wesetoiusceinsctsSeasariobyucststnstisisscan eri ie e ea E wuehsonbies 1 vlt e EE i Table or con 1 ae E E E EE E E ee eee li Introduction 3 oso ie soctencecivncte cccnsoreneslndioueineartnsetinosinonuisacnusaasedied oodieneshewseudidovsesaseensoussaaubesnncetone 1 NT TE Geet ee ere ee E EE E E EEA E ee l E EE l Install and TOMO Al sissscensascccoasaecocas cams uidadienssadecasasensdoneacnssencensetnnaandecouassasdeaaareavanssduateneaedectons 2 HOWO S A ee 2 HOW TO TEMOVE te 3 Ee 4 Activate your prod Ct nr soin a ee ee eee ee 3 Buying a DI OGUCE Eet 5 LAE TO ACL EN J How O RE 7 Ee 7 KEE 7 SAVING to another format wocccccccccccc cece cece cc ee een e eee ee ee ek eee ee EEE EEE EEA EE EEE EULA UES EGE E EGE E EGE E GEESE EEE EES 9 STOPPIN he COMPUN ON casos d
14. u save again the file to one of the other supported formats without the need to recalculate everything Stopping the computation During the computation press the cancel button on the Please wait window to stop the process This window will disappear when there is about 2 seconds left in the computation Please wait u Press Cancel to stop the process Estimated time remaining 4 sec Oct XL 9 July 2011 OptiXL Distance and Time Calculator A confirmation message will appear like this one If you choose Yes then the computation will stop when all destinations of the current origin are calculated frl fagf Bit Do you want to stop the process Duplicate values If a duplicate name for a pushpin is found during the computation the second column will have its name appended with a dash followed by a number representing the column number This is required to assure a unique name for each column but the name in the row will not be changed Unmatched pushpins If a pushpin set contains unmatched pushpins they will be ignored during the computation In the output file they will appear empty line column or both Error while calculating If an error occur during the computation an error message titled Error while calculating will be displayed The origin destination pair that 1s causing a problem will appear along with a description of the problem This type of error will cause the co
15. ulator Setup Wizard select whether you wantto repair or remove OpteL Distance and Time Calculator Repair Optixl Distance and Time Calculator Oct XL 3 July 2011 OptiXL Distance and Time Calculator Check for update Users that have activated the product will be able to verify from Distance and Time Calculator if a newer version of the product is available to download by clicking the link Check for update in the bottom section as shown below About Distance and time Calculator Version 1 3 2011 Opti XL Email sales optixl com All rights reserved Product Key AAAAA BBBBBBB Check for update Ready You will be asked if you want to download the newer version By clicking Yes the download will start in your web browser Check for update Version 1 3 of Distance and Time Calculator is available Would you like to download 2 45 MB the new version Je If no update is found you will receive this message Check for update _l Your version is the most up to date version of Distance and Time Calculator While trying to update to a newer version you may receive an error message from the Windows Installer like the one below Therefore you will have to manually remove the program by using the Add Remove programs from the Control Panel before installing the new version Windows Installer Another version of this product is already installed Installation of this version cannot c
Download Pdf Manuals
Related Search