let &qsrq=GETstr("请输入开始日期: ")
let &jzrq=GETstr("请输入结束日期: ")
let C6=XJLL(&qsrq,&jzrq,"借","01",,,"y")
let C7=XJLL(&qsrq,&jzrq,"借","02",,,"y")
let C8=XJLL(&qsrq,&jzrq,"借","03",,,"y")
let C9=ptotal(C6:C8)
let C10=XJLL(&qsrq,&jzrq,"贷","04",,,"y")
let C11=XJLL(&qsrq,&jzrq,"贷","05",,,"y")
let C12=XJLL(&qsrq,&jzrq,"贷","06",,,"y")
let C13=XJLL(&qsrq,&jzrq,"贷","07",,,"y")
let C14=ptotal(C10:C13)
let C15=C9-C14
let C17=XJLL(&qsrq,&jzrq,"借","08",,,"y")
let C18=XJLL(&qsrq,&jzrq,"借","09",,,"y")
let C19=XJLL(&qsrq,&jzrq,"借","10",,,"y")
let C20=XJLL(&qsrq,&jzrq,"借","11",,,"y")
let C21=ptotal(C17:C20)
let C22=XJLL(&qsrq,&jzrq,"贷","12",,,"y")
let C23=XJLL(&qsrq,&jzrq,"贷","13",,,"y")
let C24=XJLL(&qsrq,&jzrq,"贷","14",,,"y")
let C25=ptotal(C22:C24)
let C26=C21-C25
let C28=XJLL(&qsrq,&jzrq,"借","15",,,"y")
let C29=XJLL(&qsrq,&jzrq,"借","16",,,"y")
let C30=XJLL(&qsrq,&jzrq,"借","17",,,"y")
let C31=ptotal(C28:C30)
let C32=XJLL(&qsrq,&jzrq,"贷","18",,,"y")
let C33=XJLL(&qsrq,&jzrq,"贷","19",,,"y")
let C34=XJLL(&qsrq,&jzrq,"贷","20",,,"y")
let C35=ptotal(C32:C34)
let C36=C31-C35
let C37=XJLL(&qsrq,&jzrq,"借","21",,,"y")
let C38=C15+c26+C36+c37
|