The macro file will be a set of questions about the problem statement of the customer, scope of objects to be involved, budget, duration etc.
There would be dependent scope items viz. when one scope item is selected a few dependent scope items will be shown automatically. Once all details are entered, the effort should be calculated in the backend and a high level quotation would be generated
I can build the effort estimation model in MS Excel using VBA. I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance
- Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites
- Buy and sell bitcoins on Coinfloor and GDAX using respective APIs
- Built a POS and inventory management system
- Built a hotel price comparison that pulls data using the website's API
You can see the reviews of the same in my profile
Thanks,
Archana