I need a simple utility to run under Microsoft Windows (98, NT, 2000, XP) which will download data from a piece of equipment connected to one of the RS232 ports at either 1200 or 9600 baud) and store it in a form suitable for importing into Microsoft Excel. Preferable as a native Excel File. The tool will need to request Equipment ID and Model Number from the connected device (both single ASCII character commands) and if the unit is a supported product request the number of stored tests. The user must be able to select all or a range of tests (0 to 300) for downloading. The results of the tests need to be displayed but not edited on the screen and stored in a file that can be loaded into Excel. The data is all ASCII and consists of: • A Test Number (1 to 300) • Date • Time, • a series of 6 of Numbers Range 0 to 20,000,000 • A single character denoting the standard • A series of 6 Numbers in the range of 0 to 22 • an error code. No calculations are required on the test results. The software would also have to request the 9 digit units serial number, and store this in the file. The location and name of the file must be user selectable. Each test should be a single row in the resulting speadsheet. The software need only be in English. Possible future enhancements may require support for French and German (Translations would be provided), and may need to access other similar products with the same command set but different data formats. It is also possible that I may want to add a graphing capability.) *** Please see chat responses for clarifications. ***
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
Windows 98, NT, 2000, XP - Must be able to run as a standard user not as Admin User.