Find Jobs
Hire Freelancers

Build me a scored survey form and results sheet / report using macros in Excel

£750-1500 GBP

Completed
Posted over 4 years ago

£750-1500 GBP

Paid on delivery
We have developed an assessment questionnaire for our customers (IT businesses) to use with their end users to assess how cyber secure they are. We want to create and easy to use, customer facing excel-based interface (using macros and forms in Excel) where customers can select an appropriate answer, each section is score and another sheet generates a score per section and recommendations as a result of the score. It should look clean and be simple to use and our customer should be able to enter their company details and the name of the company they are doing the audit / assessment for on the report sheet. The excel sheet with the first couple of sections and scoring system is attached to illustrate - full survey will be shared once a partner for the project is found
Project ID: 22827816

About the project

27 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application that your clients will open and fill their data. Based on their answers additional data will be displayed along with some attractive graphs. I plan to use a combination of formulas and VBA code to accomplish this. The Excel file will run on PCs. I will charge you $1000* and can deliver within ten days (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 340 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.
£1,000 GBP in 10 days
4.9 (347 reviews)
8.0
8.0
27 freelancers are bidding on average £877 GBP for this job
User Avatar
Dear Employer, I have checked your sample survey and I understand you need a MAcro/VBA based automation on your excel survey in which a customer will record their answers and on the basis of scoring system a sheet is generated to show the results. I will do a neat and clean perfect job for you. Advantage working with me is I have been doing these jobs since 12 years now. Please give me this opportunity. Please do check my previous reviews for your kind consideration!! Thanks and Regards, Ash
£750 GBP in 3 days
5.0 (246 reviews)
8.1
8.1
User Avatar
Hi there,I am Excel expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agreed deadline. Check out my profile and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
£850 GBP in 7 days
4.9 (165 reviews)
7.8
7.8
User Avatar
Dear client I understand the scope of work involved in the project. I am an excel expert and I have previously carried out a number of projects in excel in the past using macros and formulas. I can definitely help you in this project. Kindly contact me for further details. Roy
£750 GBP in 7 days
4.9 (471 reviews)
7.4
7.4
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 260 projects successfully completed here. I would like to help you create the Excel tool you need. I can create a series of userforms, easy to use, for data entry and an additional section of output, in which the results can be observed. These results can be manipulated through a series of pivots and slicers. Contact me to discuss the details. Best regards
£1,000 GBP in 10 days
4.9 (309 reviews)
7.4
7.4
User Avatar
Hi, Would you like to see a quick demo of your project on developing an Excel Macro-based interface/tool with which customers will assess how cyber secure there are, which will be scored and proffer suggestions based on the score before you award the project? You can consider it professionally done in less than 24 hrs. I am confident I can exceed your expectations since I am accustomed to doing this sort of job on a regular basis. I am highly skilled in the following areas: 1. Software Architecture 2. Visual Basic for Apps 3. Business Analysis 4. Excel Macro 5. Excel I am passionate about flawless results and I can assure you of a job well done. I’d love to discuss more on what would make this project a success for you. Can we have a quick chat? Thanks for your time.
£1,000 GBP in 5 days
4.9 (68 reviews)
6.9
6.9
User Avatar
Hi, I am an Excel expert. I have gone through the example sheet and can create a survey form and results sheet as per your requirement. I have created many user friendly templates to perform complex calculations/data processing with ease. Please take a look at my portfolio and reviews for Excel projects and consider me for quality work. Regards Mamta
£750 GBP in 7 days
5.0 (165 reviews)
6.5
6.5
User Avatar
Hi I am a very experienced statistician, data scientist, software developer and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU, POWER BI, MACROSand EXCEL tools like machine learning, deep learning, AI, NLP, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
£1,500 GBP in 7 days
4.7 (90 reviews)
6.9
6.9
User Avatar
Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I checked the attached excel file. I think I understand the requirements broadly. I can develop a neat excel tool for you using VBA and userforms as you specified. The forms would be clean, fool proof and easy to use. The tool would have all the required capabilities for calculation of the scores based on the responses, sectional results, providing recommendations, generating printable and properly formatted audit reports with organisation name, logo, etc based on the prescribed format. In short, I can provide you with all sorts of functions that you desire from the tool. I have designed several such forms for various organisations for all sorts of purposes from stock management, ERPs to questionnaires, surveys, etc. I would be glad to share some of my previous such works with you. I also have quite some experience with making userforms compatible with all sorts of excel versions by not using controls specific to one version or using/developing own alternatives. Therefore, I would love to provide my services for this project. I look forward to a positive response from your side :) Regards Sourabh
£750 GBP in 5 days
5.0 (156 reviews)
6.2
6.2
User Avatar
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.
£750 GBP in 7 days
4.6 (51 reviews)
6.2
6.2
User Avatar
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f If you can use Ms Access then another solution will be to create very friendly ms Access app for managing this questionnaires. So you can choose any solution - I'm ready for both. I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
£1,125 GBP in 7 days
4.8 (24 reviews)
5.6
5.6
User Avatar
Hi... I have gone through your project specification you have provided and it seems like it is doable for me. I am a professional and experienced writer who would like to work on your project. You will get your work done fast and accurate in touch for further discussions. ( https://freelancer.com/u/SupremeWriters ) please visit my profile :-)
£750 GBP in 1 day
4.9 (34 reviews)
4.7
4.7
User Avatar
Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this with a mix of VBA Userform and Excel Macros. It will be quick and accurate. If interested, we can discuss this further on chat.
£750 GBP in 2 days
4.6 (25 reviews)
4.8
4.8
User Avatar
My last excel survey application was "Your Voice" developed for HR department. You do not need Forms with survey, as it is extra workload and not flexible to migrate so many text fields to Form elements. Instead, dedicated sheets should be formatted as input forms with ActiveX buttons. The ideal file structure for surveys is to separate the user area from survey logic, masterdata and database, with only one visible intuitive sheet for user. User will have intuitive buttons which will easily guide through the process on the same sheet, without pop ups of additional windows or Forms. This will give user a feeling of web like experience, one space, no extra pop ups, easy and intuitive process. Time needed to develop the application can vary from 3 days to 7 days depending of the survey logic complexity and volume. I suggest very convenient price 50£ per day with max limit 500£ for entire project. 13 years excellence in office automation and business application development. Responsible for what i deliver! Payment only after 100% satisfaction. European freelancer. Seamless communication.
£750 GBP in 5 days
5.0 (20 reviews)
4.1
4.1
User Avatar
Hello!! Am very interested in ur project and I'm an expert in PDF/Word/Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further discussion.
£750 GBP in 1 day
5.0 (25 reviews)
4.2
4.2
User Avatar
"I have 10+ years of experience working with Microsoft Excel (+VBA Macros development), PowerPoint, Word. I am also very good at capturing data from internet and organizing it in a way which becomes very easy to retrieve for self as well as others. I also have proven experience of maintaining data privacy, business ethics, speed, and accuracy of parameters and English language. Data privacy, safety is one of my focus areas. I am willing to sign an NDA if required. Please see my creations in Excel workbooks. I deliver Excel, Reporting, dashboard, VBA Macros repairing, creating projects for Schools, University and Corporates. Most of my clients so far are from Denmark, Sweden, London & India. You can see my work on my Freelancer portfolio page."
£750 GBP in 6 days
5.0 (6 reviews)
2.8
2.8
User Avatar
Hi, i understand your requirement to be an application based on EXCEL. I am expert in EXCEL , macros, functions, pivot tables etc. I had seen the sample file attached
£1,200 GBP in 8 days
5.0 (6 reviews)
2.4
2.4
User Avatar
Hello, Good day!! I would like to help you. I have done some projects in Excel VBA (Automation / Macros). I understand you need a scored survey Form built in Excel with user Friendly Forms. I prefer Job satisfaction and Good experience than money. I have bid for the lowest amount allowed. Please let me know more about the project to give exact time line and cost. Hope to work with you soon. Thanks!
£750 GBP in 10 days
5.0 (4 reviews)
1.4
1.4
User Avatar
I have professional experience for 5 years in the information technology field. I can to the work efficiently and as soon as possible. I am available to work immediately. You can reach me out by chat.
£1,000 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I checked your Excel sheet attached. So, I will make forms as well as the excel sheets as per your requirements fully programmed and automated with macros. I will have buttons for operation organized with a nice-looking Dashboard. Let's have a discussion and start working on it. I am new here on this website but have experience of 6 years working as an Excel specialist in Pakistan. I will give you the least rates and provide the most time until you are satisfied. 100% satisfaction Guaranteed.
£750 GBP in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am new on this site but want to earn good name. Relevant Skills and Experience I have working experience of 5.8yrs on Excel, you can send me any work for cross-checking my skills.
£766 GBP in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Hessle, United Kingdom
5.0
1
Payment method verified
Member since Dec 12, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.