Learn VBA & Macros in 1 Week!

JavaScript - Calculate Volume Discount

Full Excel VBA Course - Beginner to Expert

Calculate Volume Discount	View Content

Full Excel VBA Course - Beginner to Expert

Calculate, Discount Plus Other Cost

Similar Tutorials

View Content

Hi there

I have tried to work on this code for the last 2 weeks, can not figure out what is wrong with my code, please have a look for me, it will greatly appreciated from me; here my details;

I work on <script type="text/javascript" language="javascript"> from dreamweaver
to set my code to calculate, different
Fiji tour (4 options, choose 1 in options)
Payment (4 options, choose 1 in options)
The cost of tour - discount base on tour cost. (discount has 4 different calculate)
Need to be alert if they not choose 1 in each type.

Second cost if they choose to fly out , will cost plus $400 on top the above cost. This is an optional, so they don;t need to buy if they want.

I have attached my code, please have a look,

Thank you very much

Calculate Sum, Discount Automatically When The Value Entered Into Textbox

Similar Tutorials

View Content

Hello,

I am not well-versed with javascript.

Actually i have some calculations has to be displayed in total (textbox) as soon as i enter the values in other text box.

I have done that. But if multiple rows added (its dynamically added ) that code doesn't work for 2nd row or 3rd row...

I don't know how to do it.

Here is my form where i am entering data and displaying result

Code:

 <input type="text" class="span2"  name="item[]" id="category" value="<?php echo $row1['item'];?>"  />&nbsp;&nbsp;
  <input type="text" class="span1" name="uom[]" id="category" value="<?php echo $row1['uom'];?>"  />&nbsp;&nbsp;
  <input type="text" name="description[]" id="category" value="<?php echo $row1['description'];?>"  />&nbsp;&nbsp;
 
 <input type="text" class="span1" name="quantity[]" id="qty"  onkeyup="getValues(1)" />&nbsp;&nbsp;
 
 <input type="text" class="span1" name="price[]" id="price" value="<?php echo $row1['selling_price'];?>" onkeyup="getValues(2)" />&nbsp;&nbsp;
 
 <input type="text" class="span1" name="discount[]" id="discount" value="<?php echo $row1['discount'];?>" onkeyup="getValues(3)" />&nbsp;&nbsp;
 <select name="tax[]" class="span1" id="tax" onkeyup="getValues(4)">
 <option value="<?php echo $row1['tax'];?>"><?php echo $row1['tax'];?></option>
 <?php $l1 = mysql_query("select * from taxes") or die (mysql_error());
 while($l2 = mysql_fetch_array($l1))
 { ?>
 <option value="<?php echo $l2['rate']; ?>"> <?php echo $l2['name'];?> - <?php echo $l2['rate'];?>% </option>
 <?php } ?> </select>&nbsp;&nbsp;
 

 
<input type="text" class="span1" name="freight[]" id="freight" onkeyup="getValues(5)" placeholder="Freight"  />&nbsp;&nbsp;
 
<!--<input type="text" class="span1" name="freight_tax[]" id="frtax" placeholder="Frt Tax"   />&nbsp;&nbsp; -->
 
<input type="text" class="span2" name="total[]" id="total" />&nbsp;&nbsp;

And java script

Code:

<script language="javascript">
function getValues(val){

var numVal1=parseInt(document.getElementById("qty").value);
var numVal2=parseInt(document.getElementById("price").value);
var numVal3=parseInt(document.getElementById("discount").value);
var numVal4=parseFloat(document.getElementById("tax").value);

var numVal5=parseFloat(document.getElementById("freight").value);


var sub_total = (numVal1 * numVal2) - numVal3;
var subt_tax =  sub_total * (numVal4/100);
var total = parseFloat(sub_total + subt_tax);
var totalValue = parseFloat(total + numVal5);

document.getElementById("total").value = totalValue;
}
</script>

Adjusting The Volume Of An Embedded Object

Similar Tutorials

View Content

I have a javascript sound board that I've made for a Church skit but I'm wanting to be able to smoothly fade out the longer SFX without having to do it manually with the volume slider.

The Object:
Code:

<span id="player_holder"><embed id="player" hidden="true" autostart="true" loop="false" volume="100"/></span>

How do I modify the volume value from:
Code:

document.getElementById('player')

Any ideas?

Javascript Calcuate Volume & Total Dynamic Fields

Similar Tutorials

View Content

Hi,
jI have a javascript script that adds/deletes input in a form.

I'd like to calculate the volume for each ligne : l*h*d
Then a total of all the volume fileds

The data will be inserted in a php table.

Thanks for your help (I hope you can understand my english) I have trouble with php but even more with javascript versions.

PHP Code:
-- Structure of mysql table named 'tbox'
--

CREATE TABLE IF NOT EXISTS 'tbox' (
'tboxid' int(11) NOT NULL AUTO_INCREMENT,
'tboxidtproid' int(11) NOT NULL,
'tboxdate' date NOT NULL,
'tboxL' int(11) NOT NULL,
'tboxD' int(11) NOT NULL,
'tboxH' int(11) NOT NULL,
'tboxnet' float NOT NULL,
'tboxgros' float NOT NULL,
PRIMARY KEY ('tboxid')
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=55 ;

The html page wiith js :

PHP Code:
<html>
<head>
<script type="text/JavaScript">

// add a box
<!--
function create_champ(i){

var l = document.getElementById('l_1').value;
var d = document.getElementById('d_1').value;
var h = document.getElementById('h_1').value;
var v = document.getElementById('v_1').value = (l * d * h) ;

var i2 = i + 1;
document.getElementById('champs_'+i).innerHTML = '<span id="ligne_'+i+'">L <input type="text" size="9" maxlength="9" name="l[]" id="l_'+i+'" \/> D <input type="text" size="9" maxlength="9" name="d[]" id="d_'+i+'" \/> H <input type="text" size="9" maxlength="9" name="h[]" id="h_'+i+'" \/> Volume : <input type="text" size="9" maxlength="50" name="v[]" id="v_'+i+'" value = "" " disabled="true" \/> <input type="button" value="x" id="boutton_'+i+'"onclick="delete_champ('+i+')" \/><br \/><\/span>';

document.getElementById('champs_'+i).innerHTML += '<span id="champs_'+i2+'"><input type="button" value="Add a box" onclick="create_champ('+i2+')" \/><\/span>';

}

function delete_champ(i){
document.getElementById("ligne_"+i).innerHTML="";
}

</script>
</head>

<body>

<form id="1" name="addalbum" method="post" action="">
<td width="250" valign="top"><fieldset>
<legend>Boxes Dimensions(mm)</legend>
<table width="95%" border="0" cellspacing="0" cellpadding="3">

<tr>

<span id="ligne_1">

L <input type="text" name="l[]" id="l_1" size="9" maxlength="9" value="" />
D <input type="text" name="d[]" id="d_1" size="9" maxlength="9" value="" />
H <input type="text" name="h[]" id="h_1" size="9" maxlength="9" value="" />
Volume : <input type="text" name="v[]" id="v_1" size="9" maxlength="9" value="" disabled="true" />
<input type="button" value="x" id="boutton_1" onclick="delete_champ(1)" />
<br />
</span>

<span id="champs_2"> <input type="button" value="Add a box" onclick="create_champ(2)" \/></span>

</table>
</fieldset></td>
<label>
<input type="submit" name="button" id="button" value="Envoyer">
</label>

</form>

<?php
/*

insert fields in table tbox
*/

?>
</body>
</html>

Javascript Calculator With Discount. I Need Help!

Similar Tutorials

View Content

I am no JavaScript guru but I am trying to make a form that will calculate a discount if the quantity is greater than 4. I need it to also calculate a total with discounts at the very end. I have the discount working but I need it to work over multiple fields. Any help would be greatly appreciated. I have been pulling my hair out over this one for 3 days. Thanks in advance. Here is the code.
Code:

<html>
<header>
<SCRIPT type = "text/JavaScript">
function calcPrice(){
var discount, price, total, savings;
var v = parseInt(document.getElementById("value").value);
var q = parseInt(document.getElementById("quantity").value);
if (q <= 3) discount = 0;
else if (q>=4) {discount = .25}

price = q * v;
savings = q * v * discount;
total = q * v - savings;
alert(total);

}
     

</SCRIPT>

 
Number of Bedrooms


  <input type="text" id="quantity"  />
   <input type="hidden" id="value" value="10"  />
 

<input type="button" onclick="calcPrice()">

</header>
<body>
</body>
</html>

Applying Discount On Email Address

Similar Tutorials

View Content

If..else..if..else For Percentage Discount, Dependent On Total

Similar Tutorials

View Content

I have my cumulative totals box at the very end of my order form and I'm required to have another underneath that one that will give a particular discount depending on how great the total of the order is.

Would someone please be able to give me the javascript codes that will allow me to do this and also tell me where I'm to put them.

Calculate The Age

Similar Tutorials

View Content

hi, I've got a problem and i really need help.
this is my code

<script>
var y= new Date();
y.getFullYear() + '<br />';
alert(y);
var year = new Date();
year.setFullYear(prompt('Enter the year','1990'),prompt('Enter the month','1'), prompt('Enter the day','1'));
alert(year);
var yy = y-year;
alert(yy);
</script>

i want when a user write his/her birthday JS calculate the age. that's all

How Do I Calculate Value From Drop Box

Similar Tutorials

View Content

I have tried many time to make the calculation to appear at the total text box. however, I fail to find where the problem is. Please help me..

here is my coding..

<html>
<head>

<title>
PRESENTATION EVALUATION FORM
</title></head>

<style type="text/css">
.style1 {
text-align: center;
}
</style>

<script type="text/javascript">

function add($g1,$g2,$g3,$g4,$g5,$g6,$g7,$g8,$g9,$g10,$g11,$g12,$g13)
{
$g1=$_POST['document.myForm.gred1.value'];
$g2=$_POST['gred3.value'];
$g3=$_POST['gred3.value'];
$g4=$_POST['gred4.value'];
$g5=$_POST['gred5.value'];
$g6=$_POST['gred6.value'];
$g7=$_POST['gred7.value'];
$g8=$_POST['gred8.value'];
$g9=$_POST['gred9.value'];
$g10=$_POST['gred10.value'];
$g11=$_POST['gred11.value'];
$g12=$_POST['gred12.value'];
$g13=$_POST['gred13.value'];

$total=$g1+$g2+$g3+$g4+$g5+$g6+$g7+$g8+$g9+$g10+$g11+$g12+$g13;
}

</script>

<body>

<center><img src="logo.gif" height="200" weight="240"></center>
<p><center><b>FAKULTI SISTEM KOMPUTER & KEJURUTERAAN PERISIAN<br>UNIVERSITI MALAYSIA PAHANG</b></center></p>

<table width="100% "border="1">
<form name="myForm" method="post">

<tr>
<th style="width: 447px">ITEM</th>
<th style="width: 340px">SCORE</th>
</tr>

<tr>
<td style="width: 447px"> A) SLIDES</td>
<td style="width: 340px"> </td>
</tr>

<tr>
<td style="width: 447px">        i.
Use of Diagram and Animations
</td>
<td style="width: 340px" class="style1">
<select name="gred1" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</tr>

<tr>
<td style="width: 447px">       ii. Layout, Font and Color (Readable, Consistent, Attractive)
</td>
<td style="width: 340px" class="style1">
<select name="gred2" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</tr>

<tr>
<td style="width: 447px">      iii. Content Structure</td>
<td style="width: 340px" class="style1">
<select name="gred4" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select></td>
</tr>

<tr>
<td style="width: 447px; height: 28px;">      iv. Slide Content</td>
<td style="width: 340px; height: 28px;" class="style1">
 <select name="gred3" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select></tr>

<tr>
<td style="width: 447px">  B) PRESENTATION</td>
<td style="width: 340px"></td>
</tr>

<tr>
<td style="width: 447px">       i. Explaining and
Not Reading The Slides </td>
<td style="width: 340px" class="style1">
<select name="gred5" onchange="add()" style="width: 45px; height: 22px;">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
</tr>

<tr>
<td style="width: 447px">      ii. Voice, Eye Contact and Gestures</td>
<td style="width: 340px" class="style1">
<select name="gred6" onchange="add()" style="width: 45px; height: 22px;">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
</tr>

<tr>
<td style="width: 447px">     iii. Capture Audience Interest</td>
<td style="width: 340px" class="style1">
<select name="gred7" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
</tr>

<tr>
<td style="width: 447px">     iv. Proper Introduction and Closing</td>
<td style="width: 340px" class="style1">
<select name="gred8" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select></td>
</tr>

<tr>
<td style="width: 447px">  C) LANGUAGE</td>
<td style="width: 340px" class="style1"> </tr>

<tr>
<td style="width: 447px">       i. Fluency
</td>
<td style="width: 340px" class="style1">
<select name="gred9" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select></td>
</tr>

<tr>
<td style="width: 447px">      ii. Correctness</td>
<td style="width: 340px" class="style1">
<select name="gred10" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</tr>

<tr>
<td style="width: 447px">     iii. English Vocabulary</td>
<td style="width: 340px" class="style1">
<select name="gred11" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</tr>

<tr>
<td style="width: 447px">  D) QUESTION AND ANSWER HANDLING</td>
<td style="width: 340px" class="style1"> </tr>

<tr>
<td style="width: 447px">       i. Confidence</td>
<td style="width: 340px" class="style1">
<select name="gred12" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
</tr>

<tr>
<td style="width: 447px">      ii. Logic Responds</td>
<td style="width: 340px" class="style1">
<select name="gred13" onchange="add()" style="width: 45px">
<option value="0">0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>
</tr>

<tr>
<td style="width: 447px; height: 27px;"><center><b>Total</b></center></td>
<td style="width: 340px; height: 27px;"><center>
<input name="totalmark" type="text" style="width: 52px" value="0" >
<?php echo $_POST["$total"];></center></td>
</table>

<table>
<tr>
<td class="style1" style="width: 802px"><br><input type="button" name="total" value="CALCULATE" onclick= "add()">       
<input type="RESET" value="RESET"></td>
</tr>
</form>
</table>
</body>
</html>

Calculate Timezone.

Similar Tutorials

View Content

Hi there,
I'm new here in this forum and I've registered to ask a question about JavaScript or Jquery. I don't know which to use.

I have my code php like that:
<?php
//Get the data from system and return in EU format
function ShowDate() {
$Date = date("d"."/"."m"."/"."Y");
return $Date;
}
//Get the time from system
function ShowTime() {
$Time = date("H".":"."i");
return $Time;
}
?>

Now I have two input box

<html>
<head>
</head>
<body>
Type the date:<input name="txtdate" type="text" class="input" id="txtdate" title="e.g dd/mm/yyyy" value="<?php echo ShowDate(); ?>" size="9" maxlength="10">
<br>
Type the time:<input name="txttime" type="text" id="txttime" value="<?php echo ShowTime(); ?>" size="5" maxlength="5">
<br>
London: Friday May 21 2010 05:12:00 <br>
New York: Friday May 21 2010 00:12:00<br>
Hong Kong: Friday May 21 2010 12:12:00<br>
Tokyo: Friday May 21 2010 13:12:00<br>
</body>
</html>

So.... the important is the user can interactive with the date. If I change the date or time all this values will be change as well.
Someone knows how can I do this?
The field txtdate I will get from a calendar plugin (javascript) that I already put in my code.

Thank you for your help.

Andrei Andrade

Calculate Questionnaire %

Similar Tutorials

View Content

hi, i need a help for experts out there.
i've a set of questionnaire with 10 questions.answer for each question to choose from is 0-6 using radio button.for all the questions answered i need to calculate overall percentage based on the scores.
i've done the html coding but having problem with javascript..is there any websites i can refer to write a coding or anyone can give example how to do it.
pls help..

Calculate Ip Length

Similar Tutorials

View Content

Hello.

I wonder is there any javascript to calculate IP length

For example I have

Start ADDR:

VLAN_ADDR which is:

10.52.28.0

Stop ADDR:

VLAN_LAST which is

10.52.29.254

As I know:result is 512

or another example:

Start ADDR:

VLAN_ADDR which is:

10.52.64.11

Stop ADDR:

VLAN_LAST which is

10.52.64.15

As I know:result is 5

How to count it in javascript code ?
Results are "numbers"

Best regards

Leos.

Calculate Many Textfield

Similar Tutorials

View Content

anyone would you help me

I have some problem to calculate
PHP Code:
<table width="415" cellspacing="1" cellpadding="1">
    <tr>
      <th width="151" scope="col">Price</th>
      <th width="189" scope="col">qty</th>
      <th width="63" scope="col">total</th>
    </tr>
    <tr>
      <td><label>
        <input name="price" type="text" id="price" value="2000">
      </label></td>
      <td><label>
        <input name="qty" type="text" id="qty" value="2">
      </label></td>
      <td><label>
        <input name="total" type="text" id="total" value="4000">
      </label></td>
    </tr>
    <tr>
      <td><input name="price" type="text" id="price" value="2000"></td>
      <td><input name="qty" type="text" id="qty" value="4"></td>
      <td><input name="total" type="text" id="total" value="8000"></td>
    </tr>
    <tr>
      <td> </td>
      <td>Total</td>
      <td><label>
        <input name="gtotal" type="text" id="gtotal" value="12000">
      </label></td>
    </tr>
  </table>

How to calucate it from price * qty = Total and gtotal=sum of total, in the first rows.
Ican do it if there is one row, but i dont know how to calculate samae name of text field like in 2nd or more rows

Calculate The Value Of The Select Box

Similar Tutorials

View Content

I want to do a calculation between selectbox values. The problem with my code is that the first part of the calculation only gives me 0, which Motherboard value*quantity. the second part works fine which Chassis*quantity. My formulas is motherbord*Quanity+chassis*quantity.

Code:

function calculate() {   
  var parsedMotherboard = parseFloat(document.calcform.Motherboard.value || 0);     
var parsedQuantity = parseFloat(document.calcform.Quantity.value || 0);     var parsedChassis = parseFloat(document.calcform.Chassis.value || 0);     
var parsedQuantity1 = parseFloat(document.calcform.Quantity1.value ||0);      
document.calcform.total.value = (parsedMotherboard * parsedQuantity + parsedChassis * parsedQuantity1); }

PHP Code:
echo "<tr><td align='left' width='90%'>";

$result = mysql_query("SELECT Motherboard_Part_Number, Motherboard_Name, Motherboard_Price FROM Motherboard ")
or die(mysql_error());
echo '<select id="Motherboard" class="SelectClass" name="Motherboard" ONCHANGE="calculate()">';
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo '<option Name="Motherboard" value= ',$row['Motherboard_Price'],'>',$row['Motherboard_Part_Number'],'   ',$row['Motherboard_Name'],'    $',$row['Motherboard_Price'],' ','</option>';

}

echo '</select>';

echo "</td>";

echo "<td align='right' width='10%'>";

$result= mysql_query("SELECT Number FROM Quantity")
or die(mysql_error());
echo '<select id="Quantity" class="SelectClass" name="Quantity" Value="Quantity" ONCHANGE="calculate()" >';

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result)) {
    // Print out the contents of each row into a table

    echo '<option value=',$row['Number'],'>',$row['Number'],'</option>';
}

echo '</select>';

echo "</td></tr>";

echo "<tr><td align='left' width='90%'>";

$result = mysql_query("SELECT Chassis_Part_Number, Chassis_Name, Chassis_Price FROM Chassis where Chassis_Form_Factor='ATX'")
or die(mysql_error());
echo '<select id="Chassis" class="SelectClass" name="Chassis" ONCHANGE="calculate()">';
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
    // Print out the contents of each row into a table
    echo '<option Name="Chassis" value= ',$row['Chassis_Price'],'>',$row['Chassis_Part_Number'],'   ',$row['Chassis_Name'],'    $',$row['Chassis_Price'],' ','</option>';

}

echo '</select>';

echo "</td>";

echo "<td align='right' width='10%'>";

$result= mysql_query("SELECT Number FROM Quantity")
or die(mysql_error());
echo '<select id="Quantity" class="SelectClass" name="Quantity1" Value="Quantity" ONCHANGE="calculate()" >';

// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result)) {
    // Print out the contents of each row into a table

    echo '<option value=',$row['Number'],'>',$row['Number'],'</option>';
}

echo '</select>';

echo "</td></tr>";

Calculate Once New Value Is Typed In

Similar Tutorials

View Content

I'm working on creating a custom calculator to determine the amount of money / credits users may earn from referrals. I've tested onChange, and it will work only when I have changed to a new field or clicked off that field. How do I make this calculate live?

So if the current value is 5 and I change it to 6, it will automatically recalculate the new value.

You can see what I'm working on he

http://sheetmusichaven.com/admin/mys...calculator.php

Note: The one I'm testing is the 1st Level field. For now i'm just having it display the date.

Calculate Values

Similar Tutorials

View Content

Calculate Time Difference

Similar Tutorials

View Content

Please can u help? how would i get the total work hours between two times (8:30 to 5:30) from a web form.
I tried just minusing one from the orther but it came back with "Nan"

Autocompute Or Auto Calculate

Similar Tutorials

View Content

hi,

can someone help me create an auto pro rata calculator where there are four [4] boxes. first box should be where we could enter the customer's plan [29,39,40 etc.] and it should be divided with what ever i will enter on the second box w/c will be for the number of days in a month [28,29,30,31]. the 3rd box should be where i can enter the number of days the cust. was able to use the service and it needs to be multiplied from box 2. 4th box should be a read only box where the pro rata will be displayed.

so:

[box 1] divided "/" by [box 2] multiplied "*" by [box 3] equals "=" to box four

thanks!!!

Auto Calculate Values

Similar Tutorials

View Content

Hi.I have found this nice code through forum.Now I want to modify it a little bit.But dont know how to
It calculates amount column value by multiplying quantity to amount.i.e. amount=qty*rate and gross total is sum of all the array elements in amount.Here I want to add two more columns viz vat% and vat amount.Simply it will be amount*vat% / 100.Can anyone please tell me how I can do that?Other thing is, is it possible to separate the 5% vat and 12.5% vat values and display the total of them in respective column?
Here is the link for reference : http://kavisandeepdwivedi.com/forum.php
Please go through the code below and help me out
Code:

<html>
<head>
<script type="text/javascript">
function tot(elem) {
var d=document.getElementById("total").value;
var total=Number(d); 
var e=document.getElementById("vat5").value;
var vat5=Number(e); 
var f=document.getElementById("vat12_5").value;
var vat12_5=Number(f); 
var g=document.getElementById("cash_discount").value;
var cash_discount=Number(g); 

var h=(total+vat5+vat12_5)-cash_discount;
document.getElementById("grand_total").value = h;
}

var total = 0;
function getValues() {
var qty = 0;
var rate = 0;
var obj = document.getElementsByTagName("input");
      for(var i=0; i<obj.length; i++){
         if(obj[i].name == "qty[]"){var qty = obj[i].value;}
         if(obj[i].name == "rate[]"){var rate = obj[i].value;}
         if(obj[i].name == "amt[]"){
          		if(qty > 0 && rate > 0){obj[i].value = qty*rate;total+=(obj[i].value*1);}
          				else{obj[i].value = 0;total+=(obj[i].value*1);}
          		}
         	 }
        document.getElementById("total").value = total*1;
        total=0;
}

</script>
<script type="text/javascript">
function addRow(tableID) {
            var table = document.getElementById(tableID);
            var rowCount = table.rows.length;
            var row = table.insertRow(rowCount);
            var colCount = table.rows[0].cells.length;
            for(var i=0; i<colCount; i++) {
                var newcell = row.insertCell(i);
                newcell.innerHTML = table.rows[0].cells[i].innerHTML;
                //alert(newcell.childNodes);
                switch(newcell.childNodes[0].type) {
                    case "text":
                            newcell.childNodes[0].value = "";
                            break;
                    case "checkbox":
                            newcell.childNodes[0].checked = false;
                            break;
                    case "select-one":
                            newcell.childNodes[0].selectedIndex = 0;
                            break;
                }
            }
        }
		
				function deleteRow(tableID)
{
            try
                 {
                var table = document.getElementById(tableID);
                var rowCount = table.rows.length;
                    for(var i=0; i<rowCount; i++)
                        {
                        var row = table.rows[i];
                        var chkbox = row.cells[0].childNodes[0];
                        if (null != chkbox && true == chkbox.checked)
                            {
                            if (rowCount <= 1)
                                {
                                alert("Cannot delete all the rows.");
                                break;
                                }
                            table.deleteRow(i);
                            rowCount--;
                            i--;
                            }
                        }
                    } catch(e)
                        {
                        alert(e);
                        }
   getValues();
}
</script>
</head>
<body>
<form name="gr" method="post" action="<?php echo htmlentities($_SERVER['PHP_SELF']); ?>" onSubmit="return validateForm(this)">
<tr>
<td class="forhead" style="white-space:nowrap;"><input type="button" value="Add Row" onClick="addRow('dataTable')" >&nbsp;
<input type="button" value="Delete Row" onClick="deleteRow('dataTable')" ></td>
<table width="38%" align="center" cellpadding="0" cellspacing="0" class="normal-text" border="0">
<td width="20"></td>
<td width="80" class="forhead" style="white-space:nowrap;">Qty</td>
<td width="80" class="forhead" style="white-space:nowrap;">Rate</td>
<td width="80" class="forhead" style="white-space:nowrap;">Amount</td>
<td width="80" class="forhead" style="white-space:nowrap;">Vat</td>
<td width="80" class="forhead" style="white-space:nowrap;">Vat Amount</td>
</tr>
</table>
<table border="0" id="dataTable" width="38%" align="center" cellpadding="0" cellspacing="0" class="normal-text">
<tr>
<td class="forhead" style="white-space:nowrap;" width="20"><input type="checkbox" name="chk[]"/></td>
<td class="forhead" style="white-space:nowrap;" width="80"><input type="text"  name="qty[]"  onkeyup="getValues()" style="width:80px;" onBlur=""></td>
<td class="forhead" style="white-space:nowrap;" width="80"><input type="text"  name="rate[]" onKeyUp="getValues()" style="width:80px;" value=""></td>
<td class="forhead" style="white-space:nowrap;" width="80"><input type="text"  name="amt[]" style="width:80px;" 
onKeyUp="getValues()"></td>
<td width="80" align="right" class="forhead" style="white-space:nowrap;">
<select name="vat[]" style="width:80px" onChange="getValues()">
<option value="0">Select</option>
<option value="5">5</option>
<option value="12.5">12.5</option>
</select>
</td>
<td class="forhead" style="white-space:nowrap;" width="80"><input type="text"  name="vat_amt[]" style="width:80px;"></td>
</tr>
</table>
<table width="38%" align="center" cellpadding="0" cellspacing="0" class="normal-text" border="0">
<tr>
<td width="20" class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td width="80" class="forhead" style="white-space:nowrap;">Gross Total:</td>
<td width="80" class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td width="80" class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td width="80" class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td width="80" class="forhead" style="white-space:nowrap;"><input type="text"  id="total" name="total[]" style="width:80px;" value=""></td>

</tr>
<tr>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">Vat 5%:</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;"><input type="text"  name="vat5[]" id="vat5" style="width:80px;"></td>
</tr>
<tr>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">Vat 12.5%:</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;"><input type="text"  name="vat12_5[]" id="vat12_5" style="width:80px;"></td>
</tr>
<tr>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">Cash Dis :</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;"><input type="text"  id="cash_discount" name="cash_discount[]" style="width:80px;" value=""></td>
</tr>
<tr>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">Total :</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;">&nbsp;</td>
<td class="forhead" style="white-space:nowrap;"><input type="text"  name="grand_total" id="grand_total" onKeyUp="tot()" style="width:80px;"></td>
</tr>
<tr>
<td align="center" colspan="6">
<input name="Submit" type="submit" value="Save" style="text-decoration:none"/>
<input type="reset" value="Cancel" onClick="window.location.href='<?php echo $_SERVER['PHP_SELF'];?>'">
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</form>
</body>
</html>

Calculate Date 30 Days Ago?

Similar Tutorials

View Content

I am trying to figure out how to calculate the date 30 days ago. I also will need to be able to change the interval.

Anyone have a piece of code that does this?