|
甘露求める悪戯夜行集計 のバックアップソース(No.39)
#contents
*ドロップ率の集計 [#e674f161]
''入力方法''
%%１．「クリックで開きます」と書かれている文字の左のボタンをクリックし、表を表示します。%%
#br
２．表の右端にある鉛筆のマークをクリックすると入力画面に移動します。
#br
３．2行目の（名前を入力して下さい）と書かれている欄に、自分の名前を入力して下さい。
（1行目の、@number(r)-3は無視して下さい。）
#br
４．3行目から27行目はドロップの入力欄です。
何周目で［ハロウィン］平遥古城がドロップしたかを選択して下さい。
（例 5周目で［ハロウィン］平遥古城がドロップした場合は、5を選択）
また、［ハロウィン］平遥古城がまだドロップしていない場合は、〇の中の数字を選択して下さい。
（例 4周したけど、［ハロウィン］平遥古城がまだドロップしていない場合は、④を選択）
ただし、〇の中の数字は集計結果には反映されませんのでメモ帳の代わりとしてお使い下さい。
#br
５．左下にあるOKボタンをクリックすると入力完了です。
（28行目から32行目も、1行目と同様に無視して下さい。）
**-絶壱-の報告欄 [#i97fd4e2]
//#region("クリックで開きます")
#table_edit2(td_edit=off,tr_edit=edit,table_mod=open,calc=1,format_c=30|31|34,dot=3,form=text=|text=（名前を入力して下さい）|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|text=|text=|text=|text=|text=|text=,){{
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|CENTER:|c
|No|ID|01|02|03|04|05|06|07|08|09|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|周|泥|平均|ドロ率(%)|No|h
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|SIZE(12):CENTER:|c
|@number(r)-3|o|3|3|4|4|3|1|3|1|3|3|1|4|3|2|4|1|3|3|①|||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|Momonari|3|5|5|2|2|1|2|1|2|2|2|1|4|2|6|2|1|2|1|1|3|3|3|1|3|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|tikit|2|1|3|3|4|5|4|3|3|1|4|1|2|3|3|2|3|1|3|6|2|1|3|2|2|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|FZ|1|3|2|1|2|1|4|6|2|||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|r_k|5|2|3|2|4|4|4|1|3|2|2|2|3|2|5|2|3|1|3|1|3|2||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|sleepcat|1|5|1|1|2|2|1|2|3|3|3|5|1|1|1|2|1|3|3|3||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|KN|2|2|2|1|1|6|1|4|1|1|4|1|2|2|3|5|3|3|5|4|6|5|2|1|3|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|cat|3|4|2|1|1|3|2|2|2|4|4|4|3|3|1|4|1|2|1|1|4|2|2|3|4|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|zhizhi|4|2|2|1|3|4|3|3|4|1|4|3|3|1|4|3|4|1|4|3|1|5|1|②||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|形而|3|3|1|4|3|4|3|6|4|4|2|2|3|④||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|tsukamu|1|5|2|5|2|1|4|4|2|3|4|3|1|3|①|||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|cat2|1|2|5|2|2|2|1|2|2|3|2|4|3|1|1|3|1|4|3|3|3|1|2|4|2|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|cat3|4|3|2|2|3|2|2|4||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|Momonari|2|4|2|1|1|4|1|3|4|2|1|1|3|1|2|4|4|4|4|①||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|ことり|2|1|2|3|5|1|1|3|4|2|4|3|2|5|1|2|3|1|3|1|1|1|4|3|3|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|ことり2|2|1|2|4|4|4|2|1|1|4|2|3|3|3|3|5|2|3|2|2|2|2||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|KN2|2|2|3|2|5|1|4|4|2|1|3|2|1|4|2|2|1|3|①|||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|がちゃこ1|1|4|4|2|1|3|2|1|4|1|5|1|4|3|3|5|3|2|4|4|3|4|3|1|1|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|がちゃこ2|4|2|4|4|2|3|3|3|4|1|1|3|1|2|2|4|5|2|4|1|3|1|2|3|1|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|mikan|5|2|3|2|3|2|2|2|4|3|4|1|4|1|1|5|2|2|1|2|2|2|2|3|4|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|mikan|3|2|2|1|1|4|1|5|3|2|3|5|4|2|3|6|1|4|2|4|3|2|2|1|2|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|mikan|1|1|1|1|4|3|2|3|6|3|4|3|3|2|5|4|1|3|1|2|3|2|6|1|2|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|mikan|1|1|2|4|5|3||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//#endregion
**-絶壱-の集計結果
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|CENTER:|c
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|周回数|ドロップ数|平均周回数(1drop)|>|>|>|ドロップ率(%)|h
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|@sum_c(2,300)|@sum_c(2,300)|@cell_ra(0,2)/@cell_ra(0,1)|>|>|>|@cell_ra(0,5)/@cell_ra(0,6)*100|
}}
**-絶弐-の報告欄 [#na670d2a]
//#region("クリックで開きます")
#table_edit2(td_edit=off,tr_edit=edit,table_mod=open,calc=1,format_c=30|31|34,dot=3,form=text=|text=（名前を入力して下さい）|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|select=_1_2_3_4_5_6_7_8_①_②_③_④_⑤_⑥_⑦|text=|text=|text=|text=|text=|text=,){{
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|CENTER:|c
|No|ID|01|02|03|04|05|06|07|08|09|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|周|泥|平均|ドロ率(%)|No|h
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|SIZE(12):CENTER:|c
|@number(r)-3|Momonari|5|1|1|||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|FZ|3|3|3|2|3|2|2|3|4|||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|cat|2|||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|sleepcat|4|||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|形而|1|1|3|1|2|3|4|5|2|1|4|3|3|2|2|2|2|3|2|1|2|4|5|2|1|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|sio|2|1|1|3|1|3|2|2|4|5|4|2|1|3|1|1|2|1|2|1|1|1|5|4|2|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|sio2|2|1|2|3|1|1|1|5|3|2|2|6|1|3|2|4|2|3|3|7|3|2|1|3|1|@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|KN|2|||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|mikan|2|||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//|@number(r)-3|||||||||||||||||||||||||||@sum_r(3,27)|@count_r(3,27)|@avg_r(3,27)|@cell_ra(0,2)/@cell_ra(0,3)*100|@number(r)-3|
//#endregion
**-絶弐-の集計結果
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|CENTER:|c
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|周回数|ドロップ数|平均周回数(1drop)|>|>|>|ドロップ率(%)|消費90当たりのドロップ率（％）|h
|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|>|@sum_c(2,300)|@sum_c(2,300)|@cell_ra(0,2)/@cell_ra(0,1)|>|>|>|@cell_ra(0,5)/@cell_ra(0,6)*100|@cell_ra(0,6)/@cell_ra(0,7)*9000/95|
}}
*コメント [#comment]
#pcomment(,reply,20,)
|
