I have been out of work for a while and am looking for things to improve my marketability and to possibly produce some amount of income. (Small income is okay) Here are two possibilities from my recent past. Comments of any type are are solicited and appreciated.
Some time ago I wrote a set of macros used to import some log data and prepare a bunch of charts. Many of the controlling parameters are in a worksheet that the user can edit to control how the charts are made. This includes things like the colors and line type for plotting each data item that is charted. But it does require a new macro for each chart.
I am thinking of enhancing and further generalizing the macros such that the user can control all parameters with a worksheet. There will be many parameters, but I think I can make it fairly easy. Once done, the user can import the data and have a set of charts ready for presentation in seconds. I can currently import a two or three megabyte data set and have a dozen complex charts presentation ready in less than 30 seconds start to finish.
My data set was performance data for a tracking antenna. I needed to be able to run an operation (track a satellite) then plot the data quickly for analysis. I believe/suspect that there are many other places where people need to repeatedly collect data from a repeating operation then chart it for analysis.
Does anyone have any comments on how valuable this might be in commercial market?
A second market possibility:
I have work as a test engineer and often had to write and update procedures that require interactions from multiple stations. There always a need to break them up and print out or display the procedure for a single or several stations. But there was a need to see all interaction in a single thread format for overall sequencing and editing. Editing interacting procedures side by side and keeping them synchronized is difficult. With more than two stations involved, it gets much more difficult.
This seems like a good idea for Access. All the steps would be put in a data base. They would all be linked to show sequential and parallel operation. Each step would have an identifier showing who will perform or respond at that step. With various filters and print function we could easily print procedures for each station with check off columns or what ever might be desired.
Comments on this product.
Some time ago I wrote a set of macros used to import some log data and prepare a bunch of charts. Many of the controlling parameters are in a worksheet that the user can edit to control how the charts are made. This includes things like the colors and line type for plotting each data item that is charted. But it does require a new macro for each chart.
I am thinking of enhancing and further generalizing the macros such that the user can control all parameters with a worksheet. There will be many parameters, but I think I can make it fairly easy. Once done, the user can import the data and have a set of charts ready for presentation in seconds. I can currently import a two or three megabyte data set and have a dozen complex charts presentation ready in less than 30 seconds start to finish.
My data set was performance data for a tracking antenna. I needed to be able to run an operation (track a satellite) then plot the data quickly for analysis. I believe/suspect that there are many other places where people need to repeatedly collect data from a repeating operation then chart it for analysis.
Does anyone have any comments on how valuable this might be in commercial market?
A second market possibility:
I have work as a test engineer and often had to write and update procedures that require interactions from multiple stations. There always a need to break them up and print out or display the procedure for a single or several stations. But there was a need to see all interaction in a single thread format for overall sequencing and editing. Editing interacting procedures side by side and keeping them synchronized is difficult. With more than two stations involved, it gets much more difficult.
This seems like a good idea for Access. All the steps would be put in a data base. They would all be linked to show sequential and parallel operation. Each step would have an identifier showing who will perform or respond at that step. With various filters and print function we could easily print procedures for each station with check off columns or what ever might be desired.
Comments on this product.
