- Went through the PO form and the various Part# and its prices.
- Can build the form such that the user selects only the quantities required and select the mode of Delivery (FedEx, BlueDart....) based on which the totals for the client can be calculated including the Delivery Charges and probably add any Sales Tax component to it.
- The template can be built as 3 different one, so that one could be used by majority of the clients, and the remaining two for specific clients you may want.
- Clients will not be able to alter the price of the products but only change the qty required.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- 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.,
- 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.
- Stocks Portfolio - Showing client portfolio stocks with various indicators