<h1>劉任昌2021年1月期末考</h1>
<table border="1">
<tbody>
<tr><td>現值</td><td><input id="p"
type="number" /></td><td><input
onclick="CompP()" type="button" value="計算現值" /></td><td id="p_"
width="180"></td></tr>
<tr><td>利率</td><td><input id="y"
type="number" value="0.001" /></td></tr>
<tr><td>期數</td><td><input id="n"
type="number" value="240"
/></td><td><input onclick="CompN()"
type="button" value="計算期數"
/></td><td id="n_"
width="180"></td></tr>
<tr><td>金流</td><td><input id="m"
type="number" value="0" /></td><td><input
onclick="CompM()" type="button" value="計算金流" /></td><td
id="m_"></td></tr>
<tr><td>終值</td><td><input id="f"
type="number" value="0" /></td><td><input
onclick="CompF()" type="button" value="計算終值" /></td><td
id="f_"></td></tr>
</tbody></table>
<h1>對照EXCEL先打開從範圍定義名稱</h1>
<div class="separator"
style="clear: both;"><a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVAiLBKCGD8MO3WXeyo0GifU2ujmgakGqOlrfXJTrPXLNXaMOt0BrxEuyNsoSbIxPez_ANHUAlsflSkZF1J8MitRsyrji4q05HYXGdwUqgrQ4ecCkKK5Eai9ax4tWpAXtIlTXj_mg9vsy9/s734/1.PNG"
style="display: block; padding: 1em 0px; text-align:
center;"><img alt="" border="0"
data-original-height="553" data-original-width="734"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVAiLBKCGD8MO3WXeyo0GifU2ujmgakGqOlrfXJTrPXLNXaMOt0BrxEuyNsoSbIxPez_ANHUAlsflSkZF1J8MitRsyrji4q05HYXGdwUqgrQ4ecCkKK5Eai9ax4tWpAXtIlTXj_mg9vsy9/s600/1.PNG"
width="600" /></a></div>
<h1>對照EXCEL先打開從範圍定義名稱</h1>
<div class="separator"
style="clear: both;"><a
href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiboaNnldTnaLjWwM78-qwFiRrvhXoCH7DuBOe3TuJHrWyrseiGvufajmCEsqLaa9OneH-wEPMSpAJPCd8Lk8371GbDLPbndYEiMUnV-HSr00LXNMA5g9dwGLtnsAmsPsfYwdIfKAr_IWiF/s1103/2.PNG"
style="display: block; padding: 1em 0px; text-align:
center;"><img alt="" border="0"
data-original-height="467" data-original-width="1103"
src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiboaNnldTnaLjWwM78-qwFiRrvhXoCH7DuBOe3TuJHrWyrseiGvufajmCEsqLaa9OneH-wEPMSpAJPCd8Lk8371GbDLPbndYEiMUnV-HSr00LXNMA5g9dwGLtnsAmsPsfYwdIfKAr_IWiF/s600/2.PNG"
width="600" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiboaNnldTnaLjWwM78-qwFiRrvhXoCH7DuBOe3TuJHrWyrseiGvufajmCEsqLaa9OneH-wEPMSpAJPCd8Lk8371GbDLPbndYEiMUnV-HSr00LXNMA5g9dwGLtnsAmsPsfYwdIfKAr_IWiF/s1103/2.PNG"
style="display: block; padding: 1em 0px; text-align: left;"><br
/></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiboaNnldTnaLjWwM78-qwFiRrvhXoCH7DuBOe3TuJHrWyrseiGvufajmCEsqLaa9OneH-wEPMSpAJPCd8Lk8371GbDLPbndYEiMUnV-HSr00LXNMA5g9dwGLtnsAmsPsfYwdIfKAr_IWiF/s1103/2.PNG"
style="display: block; padding: 1em 0px; text-align:
center;"><br /></a></div>
<script>
function CompF(){
var
y = document.getElementById("y").value; //輸入
var
m = document.getElementById("m").value;
var
p = document.getElementById("p").value;
var
n = document.getElementById("n").value;
var
fvif = y;
fvif++;
pvif = fvif ** n ;
var
f = p * fvif - m / y * (fvif - 1) ;
document.getElementById("f_").innerHTML = f.toFixed(6);
}
function CompP(){ //計算現值 p
var
y = document.getElementById("y").value;
var
n = document.getElementById("n").value;
var
m = document.getElementById("m").value;
var
f = document.getElementById("f").value;
var
pvif = y;
pvif++;
pvif =1/pvif**n;
var
p = (1-pvif)*m/y + f * pvif;
document.getElementById("p_").innerHTML = p;
}
function CompN(){ //計算期數 n
var
y = document.getElementById("y").value; //從html表格取得 id=y
var
n = document.getElementById("n").value;
var
m = document.getElementById("m").value;
var
f = document.getElementById("f").value;
var
pvif = y;
pvif++;
pvif =1/pvif**n;
var
p = Math.log((f-m/y)/(p-m/y))/Math.log(pvif);
document.getElementById("n_").innerHTML = n;
}
function CompM(){ //計算金流 m
var
y = document.getElementById("y").value;
var
n = document.getElementById("n").value;
var
p = document.getElementById("p").value;
var
f = document.getElementById("f").value;
var
pvif = y; //pvif =利率
pvif++; //pvif =利率 + 1
pvif
=1/pvif**n; //pvif =1/(利率+1)^n
var
m = y *(p-f*pvif)/(1-pvif);
document.getElementById("m_").innerHTML = m;
}
</script>
import openpyxl #蔣姿如輸入import openpyxl處理EXCEL的函式庫 book = openpyxl.load_workbook(r'wb.xlsx') #開啟EXCEL工作簿wb.xlsx print("1. 列出所...
