Follow

ID286 - Excel Active Contract Equipment by ZipCode with volume/segment/model (MIF/Territory) Sample

REQUIRES EXCEL 2007 or HIGHER!!!: This an Excel Spreadsheet to query out the data from eAuto and will find all active contract equipment and report machine location/zip/territory/technician/#CMCalls/Volume/Revenue/Cost/Customer for the last rolling 12 months. The spreadsheet reports by Zip Code, and then by territory within that Zip Code. MIF. Will show average monthly usage. Requires that the connection string be updated in the excel data portion for each client!!! This report is run manually so there is no need to input 'To' and 'From' addresses in the email section. You manually update the data for this report by looking under the Data tab within the Spreadsheet *REQUIRES DGIs ANALYTICS TO BE INSTALLED.

**You may also want to consider ID923/Contract MIF Report

Sample:

Please note this excel document has pivot tables for sorting and filtering. This sample below is showing population by zip code.

ID286.png

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk