- This would be a solution for inventory of parts and status of vehicles.
- Like going with your example if you have 20-30 vehicles which being serviced.... each vehicles could have multiple works in progress, pending Yet to start.
- Similarly part numbers used from stock, waiting for purchasing.
- If you have already have a list of part numbers in which the inventory is maintained as the parts are used you can know how much is balance as of today, thereby initiating a purchase order for the part request.
- In the front page we could have have overall summary of each vehicle or get detailed status of one vehicle so that you could know at a glance your overall position and accordingly confirm the dates with customer.
- The solution could be finetuned based on how we envision the overall output.
- 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.,
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, Can