Hi,
Went through the Cybersecurity risk questionnaire, based on the implmentation selected scores autogenerated based on implementation method and weightage.
Finally the overall score provided and the security band based on the parameters defined in "Answers and scores".
Have worked on similar scoring projects based on questionnaire and keywords automating the scoring mechanism.
This could you implemented using click of the button.
Could have the customer information Name, details contact person, address etc.
Have the customer fill all the questionnaire.
Finally clicking the button a report sheet with the Customer Details and the Security banding along with score with color coding could be displayed.
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
Have done complex projects using macros, including Grading (Scoring), Heating wire design, System log generation, Roster wage calculation.