Custom Chartin Tools

Two custom tools for graphing and displaying data. Should exist as separate application, ability to be used with MS Excel would a big plus. I keep the rights to the source code and IP. Complete specifications enclosed. Each component to be delivered (source code and executable) according to the following milestone schedule: initial prototype, alpha version, beta version, release quality version. Contractor must have ability/desire for future interactions with respect to support/maintenance and coding additional components. ## Deliverables On completion of the each milestone, I expect a documented source code and executable. Semi-complete specifications are enclosed. Regression Tool Specifications: Take command line parameter as XML input file name. Read XML file containing two time series, dates for two series, residuals for regression, regression parameters, current real and estimated values for Y series, text summary as a table. Open a window with two charts and a summary. In chart 1 display a scatter plot + regression line, label current point with value, distance from regressed value (bubble with arrow). Allow user to select three coloring modes, mode 1 (“Simple??) would color all point same color, mode 2, 3 (“By Year??, “By Month??) would color each set of points belonging to each year/month with separate color. In chart 2 display residuals a line-plot on 1st axis, time series X as line plot on 2nd axis, time series Y as line plot on 3rd axis. Axes should have same color as the chart lines and have labels. If user drags a mouse across the chart (along the horizontal axis), show vertical line corresponding to the position of the mouse, show values for each series and residual corresponding to the mouse position on top of the line. If user clicks left button mouse while on top of the chart, place a line (different color) with all labels on top in the position of the click. Have a button “Remove All Labels?? to the side of the chart; this button removes all lines/labels placed on the chart. On the bottom of the window, display a summary as a table on the bottom of the window. Also display buttons to “Save Study As PDF?? (or GIF),??Print Study As PDF??. Print window exactly in the form it is now (including labels and colors), excluding the window title bar and print/save buttons. Time Series Tool Specifications: Take command line parameter as XML input file name. Read XML file containing up to three time series, dates for the series, current values for each series, and text summary as a table. Open a window with two charts and a summary. In chart 1 display a line-plot of each series on a separate axis. Axes should have same color as the chart lines and have labels. If user drags a mouse across the chart (along the horizontal axis), show vertical line corresponding to the position of the mouse, show values for each series and residual corresponding to the mouse position on top of the line. If user clicks left button mouse while on top of the chart, place a line (different color) with all labels on top in the position of the click. Have a button “Remove All Labels?? to the side of the chart; this button removes all lines/labels placed on the chart. Overall, chart shows same behavior as the chart 2 from regression component. Chart 2 should allow user to select a single time series from a drop down menu. Have check-boxes to display series average, median, average +/- 1 std. dev. Average +/- 2 std. dev, N point moving average (have a drop-down menu next to moving average checkbox to select the length of the moving window). Allow the same drag-mouse line behavior, plus allow user to add custom text to each line-label by selecting the line and typing text into a text field below the chart. On the bottom of the window, display a summary as a table on the bottom of the window. Also display buttons to “Save Study As PDF?? (or GIF),??Print Study As PDF??. Print window exactly in the form it is now (including labels and colors), excluding the window title bar and print/save buttons. ## Platform MS Windows, programming language at your discretion, could be VB, C#, C++. Ability to be used from MS Excel VBA would be a big plus.