- - Went through the Resource Allocation Model - Scope of Work .docx, and its details.
- Depending on the rail line, type the allocation perios for Jan2019, Dec 2020 can be allocated using VBA code.
- Based on the above to model the allocation of trains for the different scenarios.
1) Base Case (as above)
2) Increased Maintenance
3) New Trains Delayed
4) Increased Services (trains required)
5) Combinations of 2, 3 & 4
- Result comparions can be done in Excel Graphing, as have not used Power BI.
- Can discuss more.
My Skills:
- 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.,
- 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 projects done - https://www.freelancer.com/u/satishtl
Sample HighComplex Projects using Macros: (via Freelancer)
- Complex Data anlaysis and graphing - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016)
- Heating Wire Design, Canada, - .... More....