Excel Forum

Code: Select all

<div class="panel-body">
    <!--<p>Lorem ipsum dolor sit amet,</p>-->
    <div class="form-group">
        <label>aaaaaaa</label>
        <select class="form-control" name="txtNumber11" id="txtNumber11" value="" onChange="chksatatus(this.value);" onclick ="chkNum()">
            <!--<option value="8000" selected>8,000</option>-->   
            <option value="8000">8,000</option>
            <option value="9000">9,000</option>
            <option value="10000">10,000</option>
            <option value="11000">11,000</option>
            <option value="12000">12,000</option>
            <option value="13000">13,000</option>
            <option value="14000">14,000</option>
            <option value="15000">15,000</option>
            <option value="16000">16,000</option>
            <option value="17000">17,000</option>
            <option value="18000">18,000</option>
            <option value="19000">19,000</option>
            <option value="20000">20,000</option>
            <option value="21000">21,000</option>
            <option value="22000">22,000</option>
            <option value="23000">23,000</option>
            <option value="24000">24,000</option>
            <option value="25000">25,000</option>
            <option value="26000">26,000</option>
            <option value="27000">27,000</option>
            <option value="28000">28,000</option>
            <option value="29000">29,000</option>
            <option value="30000">30,000</option>
            <option value="31000">31,000</option>
            <option value="32000">32,000</option>
            <option value="33000">33,000</option>
            <option value="34000">34,000</option>
            <option value="35000">35,000</option>
            <option value="36000">36,000</option>
            <option value="37000">37,000</option>
            <option value="38000">38,000</option>
            <option value="39000">39,000</option>
            <option value="40000">40,000</option>
        </select>
    </div>               


    <label>EER</label>
    <input class="form-control" type="text" name="txtNumber14" id="txtNumber14" value="11.60" onblur="masks(this, 11.60, 12.80);" onclick ="chkNum()" onKeyUp="if (isNaN(this.value)) {
                alert('กรุณากรอกตัวเลข');
                this.value = '';
            }"/>
    <input class="form-control" type="text" name="txtNumber15" id="txtNumber15" value="11.00" onblur="masks(this, 11.00, 12.80);" onclick ="chkNum()" onKeyUp="if (isNaN(this.value)) {
                alert('กรุณากรอกตัวเลข');
                this.value = '';
            }"/>


</div>
<br><br>

<div >                    
    <button type="button" class="btn btn-info" name="btnSum" value="Sum" OnClick="calculate1();">zzzzzzzzzzzzzzz</button>                                       
</div> 

<br><br>

<div class="form-group">
    <label>qqq1</label>
    <input class="form-control" id="disabledInput11" type="text" value="" placeholder="Disabled input BTU/h" disabled>
</div>
<br><br> 
<div class="form-group">
    <label>qqq2</label>
    <input class="form-control" id="disabledInput12" type="text" value="" placeholder="Disabled input BTU/h/W" disabled>
</div>



<script language="JavaScript">

    function chksatatus(sx) {
        if (sx <= 27296) {
            document.getElementById("txtNumber14").style.display = 'block';
            document.getElementById("txtNumber15").style.display = 'none';
        } else {
            document.getElementById("txtNumber14").style.display = 'none';
            document.getElementById("txtNumber15").style.display = 'block';
        }
    }

    function masks(name, min, max) {
        if (!name.value.match(/^\d*(\.\d*)?$/) && name.value.length > 0) {
            name.value = '';
            return false;
        } else {

            if (name.value >= min && name.value <= max) {
                return true;
            } else {
                name.value = '';
                alert('กรุณาป้อนข้อมูลระหว่าง ' + min + '-' + max);
                return false;
            }

        }
    }

    function calculate1() {
        //alert("พื้นที่ห้องขนาด");

        var agv_power = 3.96
        var co2 = 0.5113

        var cal_btu1;
        index = document.getElementById("txtNumber11").selectedIndex;
        selected_text = document.getElementById("txtNumber11").options[index].text;
        document.getElementById("disabledInput11").value = selected_text + " Btu/h";

        //var num11 = parseInt(selected_text.replace(",", "")); หรือบรรทัดล่าง
        var num11 = Number(document.getElementById("txtNumber11").value);
        var num14 = Number(document.getElementById("txtNumber14").value);
        var num15 = Number(document.getElementById("txtNumber15").value);

        var cal_eer1 = num14;
        document.getElementById("disabledInput12").value = cal_eer1.toFixed(2).replace(/(\d)(?=(\d{3})+\.)/g, '$1,') + " Btu/h/W";
       
    }

    

</script>


<!-- Bootstrap Core JavaScript -->
<script src="../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>

<!-- Metis Menu Plugin JavaScript -->
<script src="../bower_components/metisMenu/dist/metisMenu.min.js"></script>

<!-- Morris Charts JavaScript -->
<!--<script src="../bower_components/raphael/raphael-min.js"></script>
<script src="../bower_components/morrisjs/morris.min.js"></script>
<script src="../js/morris-data.js"></script>-->

<!-- Custom Theme JavaScript -->
<script src="../dist/js/sb-admin-2.js"></script>

Code: Select all

var myNum;
       if(num11<=27296) {
          myNum = num14;
        }
          else {
          myNum = num15;
        }
        //document.getElementById("disabledInput12").value = cal_eer1.toFixed(2).replace(/(\d)(?=(\d{3})+\.)/g, '$1,') + " Btu/h/W";
       document.getElementById("disabledInput12").value = myNum.toFixed(2).replace(/(\d)(?=(\d{3})+\.)/g, '$1,') + " Btu/h/W";