fbrdphreak
Lifer
Hello folks - I need to put together a little script, preferrably with a simple GUI front-end, within Excel.
Long story short, a metrics tool I'm using outputs data in XML format. There are multiple data sets within each XML file with data points that would be graphed. The XML output is such that I am not easily able to graph each of the datasets together in an efficient manner.
My thought is to compare cell values and then copy cell contents from the XML file to another spreadsheet in a particular order, thus formatting the data in a regular table structure so that I can manually generate graphs easily.
It would be awesome if it was easy to put a front-end on this that allowed you to select the XML file, maybe parse the individual data sets, and automatically generate a graph based on user input for the graph type, etc. That is my dream, but as close as we can get to that without a ton of work would be good.
This wouldn't pay much, but I'm assuming that at least the basic functionality (compare cell values, copy to new spreadsheet, etc) would be pretty easy for someone experienced in Excel VBA.
I do have a programming background, but have run out of time to sit down and teach myself this. Hopefully I can find someone who wants to make a few extra bucks and save me some time 🙂
I'm happy to answer specific questions about the project here, but please e-mail to discuss project timeline and costs. ecetim (AT) gmail (DOT) com
If my idea of the time needed to do this and thus the cost is way off, I will just suck it up and do it myself, I'm just hoping to free up some time by outsourcing 😉
Long story short, a metrics tool I'm using outputs data in XML format. There are multiple data sets within each XML file with data points that would be graphed. The XML output is such that I am not easily able to graph each of the datasets together in an efficient manner.
My thought is to compare cell values and then copy cell contents from the XML file to another spreadsheet in a particular order, thus formatting the data in a regular table structure so that I can manually generate graphs easily.
It would be awesome if it was easy to put a front-end on this that allowed you to select the XML file, maybe parse the individual data sets, and automatically generate a graph based on user input for the graph type, etc. That is my dream, but as close as we can get to that without a ton of work would be good.
This wouldn't pay much, but I'm assuming that at least the basic functionality (compare cell values, copy to new spreadsheet, etc) would be pretty easy for someone experienced in Excel VBA.
I do have a programming background, but have run out of time to sit down and teach myself this. Hopefully I can find someone who wants to make a few extra bucks and save me some time 🙂
I'm happy to answer specific questions about the project here, but please e-mail to discuss project timeline and costs. ecetim (AT) gmail (DOT) com
If my idea of the time needed to do this and thus the cost is way off, I will just suck it up and do it myself, I'm just hoping to free up some time by outsourcing 😉
Last edited:
