期末余额和期初余额分别公式如下;
QM(\"101\",月,\"借\",\"001\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"002\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"003\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"004\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"005\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"006\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"007\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"008\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"009\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"010\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"011\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"012\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"013\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"014\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"015\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"017\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"001\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"002\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"003\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"004\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"005\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"006\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"007\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"008\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"009\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"010\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"011\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"012\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"013\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"014\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"015\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"017\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"001\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"002\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"003\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"004\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"005\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"006\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"007\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"008\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"009\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"010\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"011\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"012\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"013\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"014\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"015\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"201\",月,\"借\",\"017\",,\"\",,,,,)+QM(\"352\",月,\"借\",\"016\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"019\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"019\",,\"\",,,,,)+QM(\"103\",月,\"借\",\"020\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"020\",,\"\",,,,,)+QM(\"101\",月,\"借\",\"021\",,,,,,,)+QM(\"103\",月,\"借\",\"021\",,,,,,,)+QM(\"103\",月,\"借\",\"021\",,,,,,,)+QM(\"201\",月,\"借\",\"021\",,,,,,,)\n\n\n\n\n\nQC(\"101\",月,\"借\",\"001\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"002\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"003\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"004\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"005\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"006\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"007\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"008\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"009\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"010\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"011\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"012\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"013\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"014\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"015\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"017\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"001\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"002\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"003\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"004\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"005\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"006\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"007\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"008\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"009\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"010\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"011\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"012\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"013\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"014\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"015\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"017\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"001\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"002\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"003\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"004\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"005\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"006\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"007\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"008\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"009\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"010\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"011\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"012\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"013\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"014\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"015\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"201\",月,\"借\",\"017\",,\"\",,,,,)+QC(\"352\",月,\"借\",\"016\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"019\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"019\",,\"\",,,,,)+QC(\"103\",月,\"借\",\"020\",,\"\",,,,,)+QC(\"101\",月,\"借\",\"020\",,\"\",,,,,)
|