新裁定方法Excel用プログラム

戻る

表計算ソフト「Excel」(ワープロの表計算機能でも可)でプログラミングすると大変便利です!

RAND = 乱数、CEIL = 端数切り上げ

 
          =SUM(A2,F2)   =SUM(H2,M2)          
(守備力) (投げ) (極め) (パワー) (打撃) (飛び技) (攻撃ポイント) (投げ) (極め) (パワー) (打撃) (飛び技) (守備力)
  =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)  
  =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))  
=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)
[PR]動画