- Can build the ranking and standard deviation for the 30cyles, with the user clicking the button.
- I have good skills in Excel automation and used 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.
- Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them.
- With summary data plotting graphs, bringing pivot tables
Sample projects completed via Freelancer.
-For a Canadian firm Tax firm - based on employee, wage, hours, resideing province based on the reference tables calculate the Provinical and the Fed tax.
- Australian based Event management Co - Have done a simple template for an Event management company whereby the services he offers based on the Event, Service & Food & Beverages the amount, rate, hour are calculated including the Sales Tax and billed to the customer based on the agreed instaillments which is also in Excel.
- Canada based Heating Design Soln: Have implemented a very complex heating model, selection of wires based on Amp, Volt, Resistance, and the total amps for the rooms not exceeding a certain threshold. If so reiterate the solution with the next available wire model.