Calculating A Score From A Row Of Drop-down Values

Aug 11, 2006

I need help in calculating a score from a row of drop-down values.
I need to use the onChange to tally the score as the user moves across
9 categories (with drop-down selection of 1-9 or N/A) multiplied by a
weighted score. The final column for each employee would be the
calculated score. I know how to accomplish this with vbscript but I
need it to process on the screen so the user can see the calculated
score as they make selections. Also the code needs to execute as many
times as there are employee rows.(loop) I don't know how to do this
with Javascript

Here's the VBscript with the variables involved
Var S1 = Category 1 Weighted score
Var S2 = Category 2 Weighted score
Var S3 = Category 3 Weighted score
Var S4 = Category 4 Weighted score
Var S5 = Category 5 Weighted score
Var S6 = Category 6 Weighted score
Var S7 = Category 7 Weighted score
Var S8 = Category 8 Weighted score
Var S9 = Category 9 Weighted score
D5 = 0.92
Var Q11 = Category 1 drop-down Value(1-9) * S1
Var Q22 = Category 2 drop-down Value(1-9) * S2
Var Q33 = Category 3 drop-down Value(1-9) * S3
Var Q44 = Category 4 drop-down Value(1-9) * S4

If (Category 5 Value = "N/A") THEN
Q55 = ' '
Else
Var Q55 = Category 5 drop-down Value(1-9 or N/A) * S5
End If

Var Q66 = Category 6 drop-down Value(1-9) * S6
Var Q77 = Category 7 drop-down Value(1-9) * S7
Var Q88 = Category 8 drop-down Value(1-9) * S8
Var Q99 = Category 9 drop-down Value(1-9) * S9

If (Category 5 = "N/A") THEN
Var FinalScore = round(((Q11 + Q22 + Q33 + Q44 + Q66 + Q77 + Q88 + Q99)
/ D5),2)
else
Var FinalScore = round((Q11 + Q22 + Q33 + Q44 + Q55 + Q66 + Q77 + Q88 +
Q99),2)
end if

Can anyone help me converting this to javascript?

View 1 Replies


ADVERTISEMENT

Calculating Values From Radio Buttons?

Mar 15, 2009

I have an assignment in which the person has to choose their department and their hourly wage is given for each department. In the text box they must put their hours worked for the week, which I can't seem to get to work this is what I have:

<form id="employeeGroup">
<table width="398" border="0" align="center" cellpadding="10">
<tr>[code]............

View 4 Replies View Related

Exploding Values And Calculating Totals ?

Apr 1, 2009

I have a slight problem with creating dynamic quotes. Basically I have two select boxes and need to calculate a total in real-time using javascript and insert into input.First it needs to explode out the machine price and term years from the values and then calculate.

Here an example: A machine costs �4000 and a term of 2 years(60 months). The calculation would be (4000/60)*3 = �200

<select name="machine">
<option value="2005 - Almida XAS47 (660 Hours) �4000">2005 - Almida XAS47 (660 Hours) �4000</option>
</select>[code].....

View 6 Replies View Related

Calculating Root Values Beyond Math.sqrt

Dec 14, 2007

Well, it's been a while since I last visited CF, but I'm finally back and, for the life of me, am drawing a total blank on something that seems like it should be fairly easy to handle.

The Math.sqrt() function works just fine if all a person needs is the Square Root of a number, but what about needing the Cube Root or even a 4th Root of a number?

My first instinct was to use the Math.pow(x,y) function with a negative value for "y." For instance;

var z=Math.pow(27,-3)

This should return a value of 3. Unfortunately, this doesnt seem to work when I tested it through the W3 reference pages, so I am looking for a clue as to how I might go about finding such values, or if it is even possible through Javascript.

View 2 Replies View Related

Calculating Values Of Columns And Rows According To Formulas?

Sep 26, 2010

calculating the summed values of a column. Also, the row values are subtracted from each other eg:

col1 col2 col3
row1 a b = a-b
row2 c d = c-d
row3 =a+c =b+d =a-b+(c-d)

however there can be N number of rows. I have listed below and example I have done to calculate the subtracted values but I am having difficulty doing the summations.

<table width="362" border="1">
<tr>
<td width="91"> <input name='r1c1' onblur='function update_Total_r1c()' size='6' value=""> r1c1</td>

[Code]....

View 2 Replies View Related

JQuery :: Auto-re-order Drop Down Values On Change The Value Of Drop Down?

Nov 19, 2011

I am implementing auto re-order drop down values in asp.net. My requirement is something: I have five drop down and each has populated using 1 to 5 values. when I changevalue from dropdown, other drop down values(numberordering)should change automatically.

View 1 Replies View Related

Calculate Score In This Script?

May 18, 2010

Code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

[code]...

View 9 Replies View Related

JQuery :: Add A Score Counting To Script?

Mar 26, 2011

I am trying to add some sort of score system to my script, but I have no idea how to get this working. I have two files 1php and 1 javascript (which gets implemented in the php file)

What do I need?

I want to add a score system to my script.[code]...

But how to do this? Score starts with 0 ofcourse.

View 1 Replies View Related

Quiz: Obtaining The User's Score?

Sep 9, 2011

The page will display brief instructions followed by a table containing the quiz.The first is with the Score() function which reads as follows:

function Score(){
for(i=1;i<=10;i++)
if(ans[i]== yourAns[i])

[code]....

Now unless I'm mistaken (which I am since the score isn't being tabulated correctly) this function essentially uses a for to cycle through both arrays, comparing the user's input against the array containing the right answers. If the contents within index i are the same on both arrays the score increases by one point. Once it cycles through the arrays, it passes score over to prequiz.score.value which will later pass this number to the text box that will display the grade to the user.

Thinking it was the setAnsArray(question, answer) function I added a document.writeline to it. However it showed that the values were being passed correctly to the answer array. Added a document.writeline to the Score() function. Unlike the point above, score always displays as 00000 regardless of how many right answers I provide.

The second issue I'm having is that the reset button is not working correctly. If I hit reset and answer the first question, the score will come back as double the score displayed before.

<?xml version="1.0" encoding= "utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

[code]....

View 10 Replies View Related

Play A Tune When A Certain Score Is Reached

Nov 14, 2009

I am trying to write a game in javascript that will play a tune when a certain score is reached. I can get music to play if i put the code behind a button but I would prefer to use an if statement in the header section.

View 2 Replies View Related

Ajax :: Form (Score Sheet) Elements Not Accessible?

Nov 7, 2011

I have a form, EWMS.php, that is a score sheet for a dart league. In this form I first have a user choose a division. Ajax returns that choice via MySQL database and PHP. Upon choosing a division that also fills in the next drop down choices of team, which again calls Ajax and brings in the teams associated with the division choice. All works good so far. The last call on team choice drop down brings in the players on that team in another drop down which is peppered throughout the form as it is based on these players that are chosen. The beginning form tag and ending form tag are located in the EWMS.php file while Ajax loads other input elements from the database into the middle of the form.

So now that the form works with these drop downs grabbing MySQL data, I am testing the data the user input by using action="process.php" method="post" in the form tag. In process.php I have some basic code:
$date=$_POST['date'];
$week=$_POST['week'];
$league=$_POST['league'];
//HOME TEAM
$teamH=$_POST['teamH'];
//VISITING TEAM
$teamV=$_POST['teamV']; .....

When a league is chosen it brings in this findleague.php :
<?php
$league=$_GET['league'];
//echo $league;
include("sparkplug2.php");
$result = mysql_query("SELECT DISTINCT(team) FROM member_data2011spring WHERE division = '$league' ORDER BY team ASC") or die(mysql_error());
$result2 = mysql_query("SELECT DISTINCT(team) FROM member_data2011spring WHERE division = '$league' ORDER BY team ASC") or die(mysql_error());
?> .....

View 9 Replies View Related

Keep A Running Total Score In A Multiple Choice Quiz?

May 13, 2009

I have a multiple choice quiz in HTML. My requirement for scoring this quiz seems to be different from every other quiz I have seen on the net.

This is due mainly, I believe, to the fact that the number of questions involved in this quiz can be from 1 to infinite as the user action brings up the next question from external JS Q&A files.

In addition I want the user to see their score amended each time they answer a question, not at the end of the quiz (which theoretically may never happen).

In the existing code I already determine and provide "Correct" and "Incorrect" messages immediately following the selection of any of the four 'answer' radio buttons.

What I need to do now is to find out how I can arrange to:

1 count all the Correct answers - when they occur and add to a 'running' total (RT1)

2 count all the Incorrect answers - when they occur and add to a 'running' total (RT2)

3 calculate:- (RT1/(RT1 + RT2)) x (100/1) = percentage success rate so far.

The percentage success rate so far� is to be shown in a text field for the user to see.

View 7 Replies View Related

Pass On Values From Drop-down Box

Nov 25, 2005

I wonder if anybody can give me a hint about what I have to do to get
this working: I am creating a drop down box using the script below. The

result is two text fields; now I want to pass those values, which come
from the drop down box, to the next page. The next page should then
simply look like this:

Month:

Year:

And the values should be the ones from the drop-down box...
I have been staring myself blind about how to get this accomplished.
Would be more than grateful if somebody could have a look...here is
what I got so far: Code:

View 19 Replies View Related

Get Values From Drop Down List?

Mar 30, 2009

how to get the values from my drop down list and none of the methods that i have seen actually work with my code.I have read that it is possible only using javascript? but i have also seen people say that it doable with php? i have tried both methods and i still cannot get the values to be entered into my database(All of the other fields enter except the fields that i have to select using a drop down [code]

View 2 Replies View Related

Add Values From 5 Drop Down Boxes?

Feb 17, 2010

i'm trying to develop a code for my sister, i would like to use javascript
to finish off the following task:

1. I want to be able to select marks from 0 to 30, from 5 drop down boxes.

2. and as marks are selected, it should upgrade the total.

3. and then show me the total marks when finished.

i've got up to creating the drop down boxes, now it's just adding the values once selected.

View 13 Replies View Related

Change Drop Down Values

Sep 9, 2010

I have a drop down list on my form called DDPaddrType - let's call it Drop Down 1 Drop Down 1 - DDPaddrType

[Code]...

CONCLUSION It has taken me 1 hour to prepare this post. I am very serious about getting this done ASAP. how this was built (off the shelf product) and how I can acheive this feature.

View 1 Replies View Related

Duplicate Values In Drop Down List Box

Jul 20, 2005

Problem: I have two dropdown list boxes with same data(all data driven).
These are used for two separate entries. For every entry you cannot choose the same value twice. For example, I cannot choose for entry 1 the same value in both selection boxes (gqCategory1Entry1 and gqCategory2Entry1)

This part works.

The second entry is the problem: When I choose a value for Entry
Two that is the same as in entry one it thinks that "Dubplicate
Divisons have been selected").

WHen in fact these are two separate entries.

Code:

View 1 Replies View Related

Referencing Values On A Drop-down Menu

May 8, 2006

I have managed to write a working script to add together two values and display the total. I need to advance from that stage and now I have a 'quantity' box and a drop-down menu with a few options on it, each relating to a price. I am trying to take the quantity entered by the user and multiply it by the price they select from the drop-down and display it in a third box. So far I have:

two = document.autoSumForm.value from menu.value;
document.autoSumForm.total.value = (one * 1) + (two * 1);

How can I rewrite the above to account for the different choices a user can make on a drop-down menu?

View 3 Replies View Related

Dynamically Populating Drop Down Values

Apr 24, 2009

I want to populate drop down box values on the basis of other drop down box value dynamically(without refreshing the page) using java script.

View 3 Replies View Related

Add Group Values To Drop Down Menu?

May 17, 2010

I have a drop down menu that is populated by the following javascript:

Code:
// Place holder
var AS_Airport = [code]....

The drop down category is Heathrow Airport. When that is selected another drop loads the shortcuts (Terminal 1, Terminal 3 etc).what i would like to do is add another selection with another set of shortcuts to the above but am unsure how to do it.for example i have tried the following without success:

Code:
// Place holder
var AS_Airport =
{[code]....

when i use the code above to try and add another group and set of values it doesn't add any of the groups. if someone could please let me know the correct way to add a group to the above i think it will work fine.

View 5 Replies View Related

Calculate Checkbox And Drop Down Values?

Oct 19, 2009

I have the following code working with the checkbox options but once I added a drop down menu with values, it doesn't calculate it. I've done some different things to try to add the drop down to the function but nothing would work that I've tried so far.

I have it setup so when a box is unchecked, that option is taken off the price, the drop down should do the same to switch between the options price.

[Code]...

View 1 Replies View Related

Amend Drop Box Values After Submission Of Form?

Jan 21, 2010

I am creating one website backend, where I have to amend drropbox value after submitting to client.i.e.after posting site on server my client want to amend all drop box values.. my codding is like..

<select name=bed >
<option value=1> 1 </option>
<option value=2> 2 </option> ..

[code]....

View 2 Replies View Related

Iterate Through A Table For Values Of Drop Down Menus?

Dec 22, 2011

I wish to get the values for the 3rd and 4th cell of each row where these contain drop down menus. I've tried various ways but my code doesn't seem to iterate through rows of a table. I can get the values for the first row, but not the rest. There's isn't a fixed row size for the table as the user will be able to add and delete them.

I've put the values in separate arrays but instead of the array containing say [10, 20] it contains [10, 10] as it just duplicates the first row's values.

Here's my code that I have so far:

function calculate(){
var len = document.getElementById(arguments[1]).rows.length;
var cMenus = [];
var gMenus= [];

[Code]...

I've tried adding j to the arguments or putting it in "[]" but nothing seems to work. I don't think the platform I'm using supports jquery,

View 5 Replies View Related

Drag And Drop Functionality With Database Values

Jan 16, 2011

I am planning to show dynamically the different wheels setup of vehicles for eg. 4 wheels, 6 wheels etc. Then I want to allow for instance the user to click the front tyre into a icon representing for instance repair, rethread etc.

View 2 Replies View Related

Drop Down To Display Option Values In An Field?

May 9, 2006

I want the drop down to "activate" the option values in the input field.
So, when the user changed the options, they wil automatically appear int he input field.

Is this possible?

<form name="form1" method="post" action="">
<select name="select"><option value="Option 1">Option 1</option><option value="Option 2">Option 2</option>
</select>
</form><input name="job1amt" type="text" id="job1amt" value="" size="5" ">

View 3 Replies View Related

Move Values Of Two Drop-down Menus To A List Box?

Oct 29, 2009

I want to use dreamweaver with javascript to do a litter project in which I want to move value "Saleman" from drop-menu 1 and value "Billy" from drop-down 2 to a list box. The result should be as follows:

dropdown 1
Manager
Salesman (to be selected)
Cleaner

[Code].....

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved