Hi,
- Have done similar iterations for one of the heating wire design for finding the right resistance, amps and volts for selecting mulitiple wires.
- Went through the sheets and the image file and the formulas in Puntaje sheet.
- The solution could be resolved by going through iterations.
Need better understanding of the usage of formulas and the Blue data sheet, and the Yellow table, to finally arrive at the PUNTUACION
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 - Using Surface, Scatter Dynamically setting axis values, legennd colors(Excel 2013 to Excel 2016)
- 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.
....