- Can get the maximum length of pipe automatically calculated on click of a button based on the parameters like heat output, elbow joints etc.
- Have done similar heating wire design solution wherein, the heating wire for each room would be selected from the available model of wires, based on the certain, resistance, amp and threshold values.
- The wiring will be picked based on running multiple iterations and the total amp/volts for the entire circuit not crossing a threshold.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries.,
- Data extraction using API.
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
- Pl. review my portfolio on recent projects.
Sample HighComplex Projects using Macros:(via Freelancer)
- Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations.
- System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report.
- Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.