表計算ソフト「Excel」(ワープロの表計算機能でも可)でプログラミングすると大変便利です!
RAND = 乱数、CEIL = 端数切り上げ
A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | =SUM(A2,F2) | =SUM(H2,M2) | |||||||||||
2 | (守備力) | (投げ) | (極め) | (パワー) | (打撃) | (飛び技) | (攻撃ポイント) | (投げ) | (極め) | (パワー) | (打撃) | (飛び技) | (守備力) |
3 | =CEIL(A2*B2/20,0) | =CEIL(A2*C2/20,0) | =CEIL(A2*D2/20,0) | =CEIL(A2*E2/20,0) | =CEIL(A2*F2/20,0) | (守備ポイント) | =CEIL(M2*H2/20,0) | =CEIL(M2*I2/20,0) | =CEIL(M2*J2/20,0) | =CEIL(M2*K2/20,0) | =CEIL(M2*L2/20,0) | ||
4 | =CEIL(B2*RAND(0)) | =CEIL(C2*RAND(0)) | =CEIL(D2*RAND(0)) | =CEIL(E2*RAND(0)) | =CEIL(F2*RAND(0)) | =CEIL(H2*RAND(0)) | =CEIL(I2*RAND(0)) | =CEIL(J2*RAND(0)) | =CEIL(K2*RAND(0)) | =CEIL(L2*RAND(0)) | |||
5 | =SUM(B5,F5) | =B4-H3 | =C4-I3 | =D4-J3 | =E4-K3 | =F4-L3 | =H4-B3 | =I4-C3 | =J4-D3 | =K4-E3 | =L4-F3 | =SUM(H5,L5) |