I gang

Excel Macro Questionaire

I need help building a complex questionaire in Excel. Questions are arranged in categories.

A simple question might be placed in a row cell with a YES/No answer next to it. If the user selects No the score is 0, if the user hits yes they score a 1 - Simples (even I can do this) but here is where it gets complicated.

A more complicated question might have the answer options Internal/External.

The answer has a score still but this time the spreadsheet asks new questions based on the result.

For example:

Category 1 - Pollution

Question 1 - Are you male or female- Score 0 or 0

Question 2 - Do you have a car ? - Yes/No Score 5 for yes and 0 for No

If Answer 2 = Yes then ask:

Question 2a- Is It Diesel Or Petrol Or LPG - Score 4 for Diesel 2 For Petrol 1 For LPG

If Answer 2a = LPG Then ask:

Question 2aa - Is It Single Or Multipoint Injection ? Score 2 For Single & 1 For Multipoint

If Answer 2 = No Then Ask:

Question 2b - Do you have a Motorbike - Yes/No 1 For yes. 0 For No.

Question 3 ....etc

I need to know the sum of all the scores for each question.

So in out example Question 1 always has a score of 0

Question 2 could have a score of 0 for (no car and no bike), a score of 7 for a multipoint LPG car, or up to 9 for a diesel. I will then sum the questions in each category and draw a graph.

There are several ways to solve this problem. I am open to suggestions.

Færdigheder: .NET, Visual Basic

Se mere: problem graph, graph problem, excel 16, building graph, ask excel, macro questionaire, new excel, need help excel, simples, simple macro, motorbike, macro excel, lpg, excel based, excel 7, diesel, excel categories, excel macro row, net spreadsheet, car bike, excel cell, macro spreadsheet, excel question answer, net questionaire, external internal

Om arbejdsgiveren:
( 10 bedømmelser ) Aylesbury, Isle of Man

Projekt-ID: #952641

Tildelt til:

Varun1981

Hi Sir, Please allow me to work with you on this project. I can deliver th ebest solution available in the market within the range of technology you have specified Please check my PM more details Thanks varu Mere

$330 USD in 3 dage
(6 bedømmelser)
3.7

20 freelancere byder i gennemsnit $426 for dette job

ineedWorkJob

sir plz check pm !

$310 USD in 3 dage
(98 bedømmelser)
6.2
svet63

VBA/Excel developer since 1997. Can do. Regards, Svet.

$750 USD in 15 dage
(45 bedømmelser)
6.1
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

$600 USD in 18 dage
(55 bedømmelser)
5.9
koolsidz

Please see PMB

$550 USD in 5 dage
(38 bedømmelser)
5.0
KellogITSolution

Hello Ready to start right now. Please see your PMB for details. Thanks

$250 USD in 5 dage
(12 bedømmelser)
4.3
muthumuni

{{{{{{Your Search Will End Here!!!}}}}}

$250 USD in 3 dage
(6 bedømmelser)
2.9
pradeep1210

Please see PMB.

$275 USD in 5 dage
(2 bedømmelser)
1.9
guacamole

Please see the PM for suggestions.

$250 USD in 2 dage
(0 bedømmelser)
0.0
willy1509

I'm expert in excel macro and also visual basic .net Ready for the job

$500 USD in 5 dage
(0 bedømmelser)
0.0
VenturSum

15 Years building Excel and VBA Applications. Please see PM.

$305 USD in 3 dage
(0 bedømmelser)
2.4
rengi

I have done many projects in excel.If u are interested i will attach some projects also

$500 USD in 7 dage
(0 bedømmelser)
0.0
tonikutty

good exposure in advanced excel programming and VBA.alrerady done projects for greater clients in the same technology.

$750 USD in 15 dage
(0 bedømmelser)
0.0
philw66

Hi there I am a data analyst and run my own company. Our company has extensive experience in building questionnaires in excel. I would suggest using one of the add-ons in excel to create a form where the user is pre Mere

$250 USD in 7 dage
(0 bedømmelser)
0.0
AlanDHJones

Please see PM

$250 USD in 2 dage
(0 bedømmelser)
0.0
quocduy5781

I'm interested in this work.

$300 USD in 7 dage
(1 bedømmelse)
0.0
kwisatch

British web developer seeks freelance work While I certainly can’t charge as low as people from Pakistan and India etc, you can be assured of working with someone in your timezone who is readily available at the e Mere

$750 USD in 5 dage
(0 bedømmelser)
0.0
clayharryman

I have built many VBA/Excel macros including interoperability with external systems.

$650 USD in 15 dage
(0 bedømmelser)
0.0
bhaskarBLR

I can do it in 5 days. Please check your PM.

$300 USD in 5 dage
(0 bedømmelser)
0.0
VBAMagic

Hi, I would like to bid for your project; please see private message for further details.

$400 USD in 5 dage
(0 bedømmelser)
0.0