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, i need help with excel, graph problem, excel 16, draw graph in c, building a graph, ask excel, macro questionaire, new excel, need help with excel, need help excel, simples, simple macro, motorbike, macro excel, macro + excel, lpg, excel based, excel 7, Diesel , excel categories, excel macro row, net spreadsheet, car bike, excel cell

Om arbejdsgiveren:
( 11 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 [url removed, login to view] 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 [url removed, login to view] 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