Very cool project for automating cabinet design/layout, and related presentation forms, using Visio by simply parsing input data, populating spreadsheet, and using the calculated results to create the Visio drawing.
If the project is successful, your work will be used professionally by dozens of designers / sales people almost immediately, and will form the basis of a much more complete software application to follow.
In general, One or more VBA forms will collect simple data.
User will paste email blob into a memo field;
Data will be parsed and added to excel spreadsheet (future version will use database);
Data will also be formatted and displayed in another VBA or PHP File (probably VBA);
User input will be collected and validated, with helpful error message if needed;
Some results will be calculated based on data entered;
A list of Visio shapes and layout will be calculated;
User can make changes if desired to this layout / choices;
Clicking button will create the VSD file;
drop some shapes and populate some shapes with data from spreadsheet; (the basic master shapes are already created)
User then has ability to modify drawing if desired.
Upon clicking button:
- directory/folder is created using name from input data;
- drawing is printed to pdf printer (this could be manual step);
- pricing spreadsheet file is copied from excel template, populated with data, saved in directory;
- existing macro is called, which creates PDF using this spreadsheet data;
- data is logged to spreadsheet
- optionally, email is created, files attached, and sent.
Must have thorough understanding and professional experience of VBA, OOP, Software Design, C+ and/or Java Programming experience (ideally), Basic UX ability; Testing; Commenting Work. Rapid Prototyping methodology is a plus.
Ideally would have a good working knowledge of Visio
Ideally would have a good working knowledge of the Visio Object Model (or can learn fast via self-study)
Work must be well commented and basic documentation created.
Initial version will be a prototype, and would probably run through multiple iterations with increasing functionality rather than 1 from start to finish version.
If all goes well, could lead to additional work creating further prototyping and possible redesign from ground up for finished application.
Prefer someone who has immediate capacity and can work quickly with little supervision, at least in the beginning. I want to get to one or more basic working prototypes ASAP.
I can hire someone else for form layout design, so you can focus only on the programming function, not worrying too much about making forms look pretty, etc.
Please respond with your interest in the project. Please indicate why you're the best fit for this project, and your related experience and expertise. I'm especially curious to know your ability with VBA and Visio.
Thorough commenting and basic documentation is very important.
Availability and responsiveness are very key as well.
Skills: software-development, prototyping, communication-skills