Add Values of Radio Buttons into 2 Different Columns

Question

Okay, so currently my code, adds up the values of the first 6 cells into the column labeled 'Overall'. I have been trying to get it to only do the first 5 cells for the 'Overall' column and add the 'Attendance' values into the column labeled 'Attendance Factor', but divide the value of the radio button selected in the 'Attendance' value by 10 so that if '6' was selected 0.6 would show up in the 'Attendance Factor' column.

In an unrelated topic, after this is done, is it possible to add text before the value that shows up in the 'Attendance Factor column (i.e. instead of '0.6' that shows up 'x 0.6'is what shows up).

Anyways here is my code:

    var overall= $('#overall');

    $(document).ready(function() {
    $(':radio').change(function() {
    var row = $(this).closest('.item'); 
    var checkedItems = row.find(":checked")
    if (checkedItems.length == 6) {
    row.find("td.overall").html(getOverall(checkedItems));
    }
    })

    function getOverall(_checkedItems) {
    var total = 0;
    _checkedItems.each(function() {
    total += parseFloat($(this).val());
    });
    return total;
    }


    });

    var tableToExcel = (function() {
    var uri = 'data:application/vnd.ms-excel;base64,'
    , template = '<\/head>{table}<\/table><\/body><\/html>'
    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
    , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
    return function(table, name) {
    if (!table.nodeType) table = document.getElementById(table)
    var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
    window.location.href = uri + base64(format(template, ctx))
    }
    })()table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 115%;
}
td,
th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 5px;
  text-align: center
}
tr:nth-child(even) {
  background-color: #dddddd;
}   
div {
  padding-top: 10px;
}




  
    
  Team
  Player
  Number
  Skating
  Shooting
  Passing
  Puck Control
  Team Play
  Attendance
  Overall
  Attendance Factor
    
  
  

  
  
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
  
  



  
  
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  


  1
  2
  3
  4
  5
  

  6
  7
  8
  9
  10

Roljhon · Accepted Answer

Well you can do it like this, it's mainly filtering the attendance radio button from the execution for the overall data and separate it from others.

 var overall= $('#overall');

    $(document).ready(function() {
      $(':radio').change(function(e) {
        var row = $(this).closest('.item'); 
        var checkedItems = row.find(":checked:not(:radio[name='attendance'])")
      if(e.target.name != "attendance"){
        
        if (checkedItems.length == 5) {
          row.find("td.overall").html(getOverall(checkedItems));
        }
      }else{
      	 row.find("td.attendance").html("x "+parseFloat($(this).val()/10).toFixed(1));
      }  
    })

    function getOverall(_checkedItems) {
    var total = 0;
    _checkedItems.each(function() {
    total += parseFloat($(this).val());
    });
    return total;
    }


    });

    var tableToExcel = (function() {
    var uri = 'data:application/vnd.ms-excel;base64,'
    , template = '<\/head>{table}<\/table><\/body><\/html>'
    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
    , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
    return function(table, name) {
    if (!table.nodeType) table = document.getElementById(table)
    var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
    window.location.href = uri + base64(format(template, ctx))
    }
    })()table {
  font-family: arial, sans-serif;
  border-collapse: collapse;
  width: 115%;
}
td,
th {
  border: 1px solid #dddddd;
  text-align: left;
  padding: 5px;
  text-align: center
}
tr:nth-child(even) {
  background-color: #dddddd;
}   
div {
  padding-top: 10px;
}




  
    
  Team
  Player
  Number
  Skating
  Shooting
  Passing
  Puck Control
  Team Play
  Attendance
  Overall
  Attendance Factor
    
  
  

  
  
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
  
  



  
  
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  
  
    
      1
      2
      3
      4
      5
      

      6
      7
      8
      9
      10
    
  


  1
  2
  3
  4
  5
  

  6
  7
  8
  9
  10

Add Values of Radio Buttons into 2 Different Columns

Answers (2)

Related Questions