Hi,
Went through the UI Dashboard where it says... either to
PICK FROM THE DROP DOWN LIST
CHOSE FROM GA OR GB
Narrows done after you selected 1A
Automatically appears once you have chosen IC
Narrows done after you selected 1F
YOU ENTER THE QUANTITY
and the sheet1 containing the A,B, C, D, E, F paramters.
- Based on the above, the prefilled data dropdown, and entered value or fetched value can be used and come with final scoring.
- Have done some complex solution similar to this.
My Skills:
- 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.,
- 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, UK
- Heating Wire Design, Canada,
- University Scoring, US -
-Roster and Wage calculations , Australia
- System Login/Logout - Greece
- Wood cutting Automation - Peru...