Technical FAQ

Can I change the Route-EXCELerator to meet my special business needs? You can change anything in the copy sent to you.

It is strongly recommended that you make a copy of the version sent to you by us. No not make changes to the original copy!

You should not do any of the following: Delete, Add or Rename any of the the tabs as it will effect the program automation portion of the software.

You can edit cells, formulas, graphics, add or remove customers, and brand products. Before you proceed with any changes, make sure that you have a saved copy that reflects the 'before state' of the proposed changes, as a backup.

You can use the Route-EXCELerator data in many ways. You can copy data from any of the tabs and use it in any other spreadsheets or programs, You can link other spreadsheets to you working copy for automated updates from the original workbook and you can create comma or tab delimiter files (.csv formats) from the Route-EXCELerator for use in many applications.

Why is there a #VALUE! error in one of the Cells? The #Value error indicates that you have a non-numeric value in one of the cells that are read by the formula in the cell that you see the error code. What this means is that the formula is referencing a cell that has non-numeric information. Usually it means that the Daily Sales tabs 1 through 31 has a colon, semicolon, or slash - non-numeric information. So look in the daily sheet for the customer / machine name row for non-numeric data. then do a "Clear Contents" or copy the blank contents from an adjoining cell. Don't space bar the character out because the space bar is also a non-numeric value. Support for this problem type is fee based.

Why is there a #DIV/0! error in one of the Cells? The #DIV/0! error normally indicated that the input cells to the calculation has a 0 (zero) value. The workbook has many formulas that are waiting for data to be inputted. Until the data in inputted this error message will remain.

Why is there a #NAME? error in one of the Cells? The #NAME? error means that one of the cell references in a formula has been changed to something that is invalid. The workbook has a lot of formulas that reference other formulas, or multiple cells. So You must read each formula and find the formula where the error is. Support for this problem type is fee based.

Why is there a #REF? error in one of the Cells? The #REF? error means that one of the cell references in a formula has been changed to something that is an invalid cell reference. The workbook has a lot of formulas that reference other formulas, or multiple cells. So You must read each formula and find the formula where the error is. In these cases look at the cell above, below, or to the sides of the effected cell. The formulas are incremental in nature, meaning they often reference a series of related cells on a different tab. For example, on the Product Sales Tab, in the green cell area the column for the first brand, Pepsi references ever equivalent cell on the Daily Sales Tabs 1 through 31. If you Click on this cell you will see the formula which totals all the possible sales for Pepsi for a specific customer / machine. If you Click on the cells directly above and below the effected cell you will see that it increments the cell references up or down respectively. If in this example the 5th cell down had a #REF? error, then you could look to the cell above and below and see what it should be and make the correction. Support for this problem type is fee based.