編集用Excelコード

※列幅や色分けは調整してください。	↓B2セルをコピーして貼り付けます
	"=""|[[""&$B$7&""]]:&br;""&TEXTJOIN(""&br;"",TRUE,$D$30:$D$59)&""|"""	←出力	※無効・付与などは入力しないでください。	※最大10行まで出力します
	※B列にはタイミング、スキル進化を記載		※(○○ターンまで)や(重複可)などは入れてください。				状態異常時	状態異常無効	無効
	※切り取り(Ctrl+X)を使うと上手く動作しなくなります。		※特攻は「対象のみ入力」で行けますが、「大特攻」などの場合は出力後に手動でお願いします。				状態特攻	状態特攻	特攻
	×××		※「強化解除無効(を) 無効」「弱体無効 無効」などのスペースも手動でお願いします。				特攻	特攻	特攻
	↓スキル名		※ある程度自動で色付けは行いますが、自身へのデメリットやスキル進化による範囲の変化には対応できていません。				特防	特防	特防
	月の大天使(仮)	例:攻撃強化/40%					デメリット
							スキル進化
	↓タイミング	↓対象	↓効果/確率		←		移動時	移動時	移動力増加
	フェーズ開始時	味方全体	闘志/40%	↑
	フェーズ開始時	敵	CP激減/40%				※末尾が「付与」以外のものを管理(HP回復、CP回復なども対応)
	状態異常時	自身	強化無効/45%			×
	デメリット	自身	2ヒット目以降与ダメージ減少			×
	攻撃後	自身	HP大回復/5%			×
	スキル進化					×
	フェーズ開始時	味方全体	闘志/40%			×
	攻撃後	自身	HP大回復/10%			×
	攻撃後	敵	CP激減/40%			×
	状態異常時	自身	強化無効/46%		××	×
	××	×	××
	××
	×
	×
	×
	×
	×
	×
	×××		※1行目(30行目)のみ数式が異なります		状態特攻
	カウント			効果名称	スキル進化番号判定	末尾			組み立て1	スキル文色	スキル進化後の場合赤色	確率のみ変化する場合は部分的に囲む
	"=IF(OR($B$10=""スキル進化"",C30<>""[]""),MAX(B$29:B29)+1,"""")"	"=""[""&B10&""]"""	"=IF(B30<>"""",IF(F30<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C29=C30,""　"",IF(B30>MAX(F$30:F$39),IF(COUNTIF(C28:C$30,C30),C30&""&br;　"",""&color(Red){""&C30&""};&br;　""),C30&""&br;　""))&L30&C10&""に""&E30&G30&M30),"""")"	"=IF(C10<>"""",IF(COUNTIF(D10,""*""&""%""),MID(D10,1,LEN(D10)-(FIND(""%"",D10)-FIND(""/"",D10)+1)),IF(OR(COUNTIF(B10,""状態特攻""),COUNTIF(B10,""特攻""),COUNTIF(B10,""特防"")),"""",D10)),"""")"	"=IF(OR(B10=""スキル進化""),B30,"""")"	"=IF(B10<>"""",IF(ISNA(MATCH(B10,$H$3:$H$9,0)),IF(OR(COUNTIF(E30,""*HP*回復""),COUNTIF(E30,""*CP*""),COUNTIF(E30,""*解除""),COUNTIF(E30,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B10,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B10,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D10,""*/*""),""/"","""")"	"=IF(B30<>"""",IF(COUNTIF(D10,""*""&""%""),MID(D10,FIND(""/"",D10)+1,FIND(""%"",D10)-FIND(""/"",D10)+1),""""),"""")"	"=IF(B10=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B30<>"""",C30&C10&E30,""""))"	"=IF(B30>MAX(F$30:$F$39),IFNA(IF(INDEX(C29:C$30,MATCH(J30,J29:J$30,0))=C30,""黒"",""赤""),""赤""),""黒"")"	"=IF(K30=""黒"","""",IF(K30=""赤"",""&color(Red){"",""""))"	"=IF(B30>MAX(F$30:$F$38),IFNA(IF(AND(C30=INDEX(C29:C$30,MATCH(J30,J29:J$30,0),1),I30=INDEX(I29:I$30,MATCH(J30,J29:J$30,0),1)),H30&I30,IF(K30=""黒"",H30&""&color(Red){""&I30&""};"",H30&I30)),H30&I30&""};""),H30&I30)"	×
	"=IF(OR($B$10=""スキル進化"",C31<>""[]""),MAX(B$29:B30)+1,"""")"	"=""[""&B11&""]"""	"=IF(B31<>"""",IF(F31<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C30=C31,""　"",IF(B31>MAX(F$30:F$39),IF(COUNTIF(C29:C$30,C31),C31&""&br;　"",""&color(Red){""&C31&""};&br;　""),C31&""&br;　""))&L31&C11&""に""&E31&G31&M31),"""")"	"=IF(C11<>"""",IF(COUNTIF(D11,""*""&""%""),MID(D11,1,LEN(D11)-(FIND(""%"",D11)-FIND(""/"",D11)+1)),IF(OR(COUNTIF(B11,""状態特攻""),COUNTIF(B11,""特攻""),COUNTIF(B11,""特防"")),"""",D11)),"""")"	"=IF(OR(B11=""スキル進化""),B31,"""")"	"=IF(B11<>"""",IF(ISNA(MATCH(B11,$H$3:$H$9,0)),IF(OR(COUNTIF(E31,""*HP*回復""),COUNTIF(E31,""*CP*""),COUNTIF(E31,""*解除""),COUNTIF(E31,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B11,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B11,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D11,""*/*""),""/"","""")"	"=IF(B31<>"""",IF(COUNTIF(D11,""*""&""%""),MID(D11,FIND(""/"",D11)+1,FIND(""%"",D11)-FIND(""/"",D11)+1),""""),"""")"	"=IF(B11=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B31<>"""",C31&C11&E31,""""))"	"=IF(B31>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C30,MATCH(J31,J$30:J30,0))=C31,""黒"",""赤""),""赤""),""黒"")"	"=IF(K31=""黒"","""",IF(K31=""赤"",""&color(Red){"",""""))"	"=IF(B31>MAX(F$30:$F$38),IFNA(IF(AND(C31=INDEX(C$30:C30,MATCH(J31,J$30:J30,0),1),I31=INDEX(I$30:I30,MATCH(J31,J$30:J30,0),1)),H31&I31,IF(K31=""黒"",H31&""&color(Red){""&I31&""};"",H31&I31)),H31&I31&""};""),H31&I31)"	×
	"=IF(OR($B$10=""スキル進化"",C32<>""[]""),MAX(B$29:B31)+1,"""")"	"=""[""&B12&""]"""	"=IF(B32<>"""",IF(F32<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C31=C32,""　"",IF(B32>MAX(F$30:F$39),IF(COUNTIF(C$30:C30,C32),C32&""&br;　"",""&color(Red){""&C32&""};&br;　""),C32&""&br;　""))&L32&C12&""に""&E32&G32&M32),"""")"	"=IF(C12<>"""",IF(COUNTIF(D12,""*""&""%""),MID(D12,1,LEN(D12)-(FIND(""%"",D12)-FIND(""/"",D12)+1)),IF(OR(COUNTIF(B12,""状態特攻""),COUNTIF(B12,""特攻""),COUNTIF(B12,""特防"")),"""",D12)),"""")"	"=IF(OR(B12=""スキル進化""),B32,"""")"	"=IF(B12<>"""",IF(ISNA(MATCH(B12,$H$3:$H$9,0)),IF(OR(COUNTIF(E32,""*HP*回復""),COUNTIF(E32,""*CP*""),COUNTIF(E32,""*解除""),COUNTIF(E32,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B12,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B12,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D12,""*/*""),""/"","""")"	"=IF(B32<>"""",IF(COUNTIF(D12,""*""&""%""),MID(D12,FIND(""/"",D12)+1,FIND(""%"",D12)-FIND(""/"",D12)+1),""""),"""")"	"=IF(B12=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B32<>"""",C32&C12&E32,""""))"	"=IF(B32>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C31,MATCH(J32,J$30:J31,0))=C32,""黒"",""赤""),""赤""),""黒"")"	"=IF(K32=""黒"","""",IF(K32=""赤"",""&color(Red){"",""""))"	"=IF(B32>MAX(F$30:$F$38),IFNA(IF(AND(C32=INDEX(C$30:C31,MATCH(J32,J$30:J31,0),1),I32=INDEX(I$30:I31,MATCH(J32,J$30:J31,0),1)),H32&I32,IF(K32=""黒"",H32&""&color(Red){""&I32&""};"",H32&I32)),H32&I32&""};""),H32&I32)"	×
	"=IF(OR($B$10=""スキル進化"",C33<>""[]""),MAX(B$29:B32)+1,"""")"	"=""[""&B13&""]"""	"=IF(B33<>"""",IF(F33<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C32=C33,""　"",IF(B33>MAX(F$30:F$39),IF(COUNTIF(C$30:C31,C33),C33&""&br;　"",""&color(Red){""&C33&""};&br;　""),C33&""&br;　""))&L33&C13&""に""&E33&G33&M33),"""")"	"=IF(C13<>"""",IF(COUNTIF(D13,""*""&""%""),MID(D13,1,LEN(D13)-(FIND(""%"",D13)-FIND(""/"",D13)+1)),IF(OR(COUNTIF(B13,""状態特攻""),COUNTIF(B13,""特攻""),COUNTIF(B13,""特防"")),"""",D13)),"""")"	"=IF(OR(B13=""スキル進化""),B33,"""")"	"=IF(B13<>"""",IF(ISNA(MATCH(B13,$H$3:$H$9,0)),IF(OR(COUNTIF(E33,""*HP*回復""),COUNTIF(E33,""*CP*""),COUNTIF(E33,""*解除""),COUNTIF(E33,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B13,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B13,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D13,""*/*""),""/"","""")"	"=IF(B33<>"""",IF(COUNTIF(D13,""*""&""%""),MID(D13,FIND(""/"",D13)+1,FIND(""%"",D13)-FIND(""/"",D13)+1),""""),"""")"	"=IF(B13=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B33<>"""",C33&C13&E33,""""))"	"=IF(B33>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C32,MATCH(J33,J$30:J32,0))=C33,""黒"",""赤""),""赤""),""黒"")"	"=IF(K33=""黒"","""",IF(K33=""赤"",""&color(Red){"",""""))"	"=IF(B33>MAX(F$30:$F$38),IFNA(IF(AND(C33=INDEX(C$30:C32,MATCH(J33,J$30:J32,0),1),I33=INDEX(I$30:I32,MATCH(J33,J$30:J32,0),1)),H33&I33,IF(K33=""黒"",H33&""&color(Red){""&I33&""};"",H33&I33)),H33&I33&""};""),H33&I33)"	×
	"=IF(OR($B$10=""スキル進化"",C34<>""[]""),MAX(B$29:B33)+1,"""")"	"=""[""&B14&""]"""	"=IF(B34<>"""",IF(F34<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C33=C34,""　"",IF(B34>MAX(F$30:F$39),IF(COUNTIF(C$30:C32,C34),C34&""&br;　"",""&color(Red){""&C34&""};&br;　""),C34&""&br;　""))&L34&C14&""に""&E34&G34&M34),"""")"	"=IF(C14<>"""",IF(COUNTIF(D14,""*""&""%""),MID(D14,1,LEN(D14)-(FIND(""%"",D14)-FIND(""/"",D14)+1)),IF(OR(COUNTIF(B14,""状態特攻""),COUNTIF(B14,""特攻""),COUNTIF(B14,""特防"")),"""",D14)),"""")"	"=IF(OR(B14=""スキル進化""),B34,"""")"	"=IF(B14<>"""",IF(ISNA(MATCH(B14,$H$3:$H$9,0)),IF(OR(COUNTIF(E34,""*HP*回復""),COUNTIF(E34,""*CP*""),COUNTIF(E34,""*解除""),COUNTIF(E34,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B14,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B14,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D14,""*/*""),""/"","""")"	"=IF(B34<>"""",IF(COUNTIF(D14,""*""&""%""),MID(D14,FIND(""/"",D14)+1,FIND(""%"",D14)-FIND(""/"",D14)+1),""""),"""")"	"=IF(B14=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B34<>"""",C34&C14&E34,""""))"	"=IF(B34>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C33,MATCH(J34,J$30:J33,0))=C34,""黒"",""赤""),""赤""),""黒"")"	"=IF(K34=""黒"","""",IF(K34=""赤"",""&color(Red){"",""""))"	"=IF(B34>MAX(F$30:$F$38),IFNA(IF(AND(C34=INDEX(C$30:C33,MATCH(J34,J$30:J33,0),1),I34=INDEX(I$30:I33,MATCH(J34,J$30:J33,0),1)),H34&I34,IF(K34=""黒"",H34&""&color(Red){""&I34&""};"",H34&I34)),H34&I34&""};""),H34&I34)"	×
	"=IF(OR($B$10=""スキル進化"",C35<>""[]""),MAX(B$29:B34)+1,"""")"	"=""[""&B15&""]"""	"=IF(B35<>"""",IF(F35<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C34=C35,""　"",IF(B35>MAX(F$30:F$39),IF(COUNTIF(C$30:C33,C35),C35&""&br;　"",""&color(Red){""&C35&""};&br;　""),C35&""&br;　""))&L35&C15&""に""&E35&G35&M35),"""")"	"=IF(C15<>"""",IF(COUNTIF(D15,""*""&""%""),MID(D15,1,LEN(D15)-(FIND(""%"",D15)-FIND(""/"",D15)+1)),IF(OR(COUNTIF(B15,""状態特攻""),COUNTIF(B15,""特攻""),COUNTIF(B15,""特防"")),"""",D15)),"""")"	"=IF(OR(B15=""スキル進化""),B35,"""")"	"=IF(B15<>"""",IF(ISNA(MATCH(B15,$H$3:$H$9,0)),IF(OR(COUNTIF(E35,""*HP*回復""),COUNTIF(E35,""*CP*""),COUNTIF(E35,""*解除""),COUNTIF(E35,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B15,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B15,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D15,""*/*""),""/"","""")"	"=IF(B35<>"""",IF(COUNTIF(D15,""*""&""%""),MID(D15,FIND(""/"",D15)+1,FIND(""%"",D15)-FIND(""/"",D15)+1),""""),"""")"	"=IF(B15=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B35<>"""",C35&C15&E35,""""))"	"=IF(B35>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C34,MATCH(J35,J$30:J34,0))=C35,""黒"",""赤""),""赤""),""黒"")"	"=IF(K35=""黒"","""",IF(K35=""赤"",""&color(Red){"",""""))"	"=IF(B35>MAX(F$30:$F$38),IFNA(IF(AND(C35=INDEX(C$30:C34,MATCH(J35,J$30:J34,0),1),I35=INDEX(I$30:I34,MATCH(J35,J$30:J34,0),1)),H35&I35,IF(K35=""黒"",H35&""&color(Red){""&I35&""};"",H35&I35)),H35&I35&""};""),H35&I35)"	×
	"=IF(OR($B$10=""スキル進化"",C36<>""[]""),MAX(B$29:B35)+1,"""")"	"=""[""&B16&""]"""	"=IF(B36<>"""",IF(F36<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C35=C36,""　"",IF(B36>MAX(F$30:F$39),IF(COUNTIF(C$30:C34,C36),C36&""&br;　"",""&color(Red){""&C36&""};&br;　""),C36&""&br;　""))&L36&C16&""に""&E36&G36&M36),"""")"	"=IF(C16<>"""",IF(COUNTIF(D16,""*""&""%""),MID(D16,1,LEN(D16)-(FIND(""%"",D16)-FIND(""/"",D16)+1)),IF(OR(COUNTIF(B16,""状態特攻""),COUNTIF(B16,""特攻""),COUNTIF(B16,""特防"")),"""",D16)),"""")"	"=IF(OR(B16=""スキル進化""),B36,"""")"	"=IF(B16<>"""",IF(ISNA(MATCH(B16,$H$3:$H$9,0)),IF(OR(COUNTIF(E36,""*HP*回復""),COUNTIF(E36,""*CP*""),COUNTIF(E36,""*解除""),COUNTIF(E36,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B16,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B16,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D16,""*/*""),""/"","""")"	"=IF(B36<>"""",IF(COUNTIF(D16,""*""&""%""),MID(D16,FIND(""/"",D16)+1,FIND(""%"",D16)-FIND(""/"",D16)+1),""""),"""")"	"=IF(B16=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B36<>"""",C36&C16&E36,""""))"	"=IF(B36>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C35,MATCH(J36,J$30:J35,0))=C36,""黒"",""赤""),""赤""),""黒"")"	"=IF(K36=""黒"","""",IF(K36=""赤"",""&color(Red){"",""""))"	"=IF(B36>MAX(F$30:$F$38),IFNA(IF(AND(C36=INDEX(C$30:C35,MATCH(J36,J$30:J35,0),1),I36=INDEX(I$30:I35,MATCH(J36,J$30:J35,0),1)),H36&I36,IF(K36=""黒"",H36&""&color(Red){""&I36&""};"",H36&I36)),H36&I36&""};""),H36&I36)"	×
	"=IF(OR($B$10=""スキル進化"",C37<>""[]""),MAX(B$29:B36)+1,"""")"	"=""[""&B17&""]"""	"=IF(B37<>"""",IF(F37<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C36=C37,""　"",IF(B37>MAX(F$30:F$39),IF(COUNTIF(C$30:C35,C37),C37&""&br;　"",""&color(Red){""&C37&""};&br;　""),C37&""&br;　""))&L37&C17&""に""&E37&G37&M37),"""")"	"=IF(C17<>"""",IF(COUNTIF(D17,""*""&""%""),MID(D17,1,LEN(D17)-(FIND(""%"",D17)-FIND(""/"",D17)+1)),IF(OR(COUNTIF(B17,""状態特攻""),COUNTIF(B17,""特攻""),COUNTIF(B17,""特防"")),"""",D17)),"""")"	"=IF(OR(B17=""スキル進化""),B37,"""")"	"=IF(B17<>"""",IF(ISNA(MATCH(B17,$H$3:$H$9,0)),IF(OR(COUNTIF(E37,""*HP*回復""),COUNTIF(E37,""*CP*""),COUNTIF(E37,""*解除""),COUNTIF(E37,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B17,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B17,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D17,""*/*""),""/"","""")"	"=IF(B37<>"""",IF(COUNTIF(D17,""*""&""%""),MID(D17,FIND(""/"",D17)+1,FIND(""%"",D17)-FIND(""/"",D17)+1),""""),"""")"	"=IF(B17=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B37<>"""",C37&C17&E37,""""))"	"=IF(B37>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C36,MATCH(J37,J$30:J36,0))=C37,""黒"",""赤""),""赤""),""黒"")"	"=IF(K37=""黒"","""",IF(K37=""赤"",""&color(Red){"",""""))"	"=IF(B37>MAX(F$30:$F$38),IFNA(IF(AND(C37=INDEX(C$30:C36,MATCH(J37,J$30:J36,0),1),I37=INDEX(I$30:I36,MATCH(J37,J$30:J36,0),1)),H37&I37,IF(K37=""黒"",H37&""&color(Red){""&I37&""};"",H37&I37)),H37&I37&""};""),H37&I37)"	×
	"=IF(OR($B$10=""スキル進化"",C38<>""[]""),MAX(B$29:B37)+1,"""")"	"=""[""&B18&""]"""	"=IF(B38<>"""",IF(F38<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C37=C38,""　"",IF(B38>MAX(F$30:F$39),IF(COUNTIF(C$30:C36,C38),C38&""&br;　"",""&color(Red){""&C38&""};&br;　""),C38&""&br;　""))&L38&C18&""に""&E38&G38&M38),"""")"	"=IF(C18<>"""",IF(COUNTIF(D18,""*""&""%""),MID(D18,1,LEN(D18)-(FIND(""%"",D18)-FIND(""/"",D18)+1)),IF(OR(COUNTIF(B18,""状態特攻""),COUNTIF(B18,""特攻""),COUNTIF(B18,""特防"")),"""",D18)),"""")"	"=IF(OR(B18=""スキル進化""),B38,"""")"	"=IF(B18<>"""",IF(ISNA(MATCH(B18,$H$3:$H$9,0)),IF(OR(COUNTIF(E38,""*HP*回復""),COUNTIF(E38,""*CP*""),COUNTIF(E38,""*解除""),COUNTIF(E38,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B18,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B18,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D18,""*/*""),""/"","""")"	"=IF(B38<>"""",IF(COUNTIF(D18,""*""&""%""),MID(D18,FIND(""/"",D18)+1,FIND(""%"",D18)-FIND(""/"",D18)+1),""""),"""")"	"=IF(B18=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B38<>"""",C38&C18&E38,""""))"	"=IF(B38>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C37,MATCH(J38,J$30:J37,0))=C38,""黒"",""赤""),""赤""),""黒"")"	"=IF(K38=""黒"","""",IF(K38=""赤"",""&color(Red){"",""""))"	"=IF(B38>MAX(F$30:$F$38),IFNA(IF(AND(C38=INDEX(C$30:C37,MATCH(J38,J$30:J37,0),1),I38=INDEX(I$30:I37,MATCH(J38,J$30:J37,0),1)),H38&I38,IF(K38=""黒"",H38&""&color(Red){""&I38&""};"",H38&I38)),H38&I38&""};""),H38&I38)"	×
	"=IF(OR($B$10=""スキル進化"",C39<>""[]""),MAX(B$29:B38)+1,"""")"	"=""[""&B19&""]"""	"=IF(B39<>"""",IF(F39<>"""",""→&color(Red){""&$B$7&""+};:"",IF(C38=C39,""　"",IF(B39>MAX(F$30:F$39),IF(COUNTIF(C$30:C37,C39),C39&""&br;　"",""&color(Red){""&C39&""};&br;　""),C39&""&br;　""))&L39&C19&""に""&E39&G39&M39),"""")"	"=IF(C19<>"""",IF(COUNTIF(D19,""*""&""%""),MID(D19,1,LEN(D19)-(FIND(""%"",D19)-FIND(""/"",D19)+1)),IF(OR(COUNTIF(B19,""状態特攻""),COUNTIF(B19,""特攻""),COUNTIF(B19,""特防"")),"""",D19)),"""")"	"=IF(OR(B19=""スキル進化""),B39,"""")"	"=IF(B19<>"""",IF(ISNA(MATCH(B19,$H$3:$H$9,0)),IF(OR(COUNTIF(E39,""*HP*回復""),COUNTIF(E39,""*CP*""),COUNTIF(E39,""*解除""),COUNTIF(E39,""*転写"")),"""",""付与""),IF(INDEX($H$3:$J$9,MATCH(B19,$H$3:$H$9,0),3)<>0,INDEX($H$3:$J$9,MATCH(B19,$H$3:$H$9,0),3),"""")),"""")"	"=IF(COUNTIF(D19,""*/*""),""/"","""")"	"=IF(B39<>"""",IF(COUNTIF(D19,""*""&""%""),MID(D19,FIND(""/"",D19)+1,FIND(""%"",D19)-FIND(""/"",D19)+1),""""),"""")"	"=IF(B19=""スキル進化"",""→&color(Red){""&$B$7&""+};:"",IF(B39<>"""",C39&C19&E39,""""))"	"=IF(B39>MAX(F$30:$F$39),IFNA(IF(INDEX(C$30:C38,MATCH(J39,J$30:J38,0))=C39,""黒"",""赤""),""赤""),""黒"")"	"=IF(K39=""黒"","""",IF(K39=""赤"",""&color(Red){"",""""))"	"=IF(B39>MAX(F$30:$F$38),IFNA(IF(AND(C39=INDEX(C$30:C38,MATCH(J39,J$30:J38,0),1),I39=INDEX(I$30:I38,MATCH(J39,J$30:J38,0),1)),H39&I39,IF(K39=""黒"",H39&""&color(Red){""&I39&""};"",H39&I39)),H39&I39&""};""),H39&I39)"	×
	×××

※シート名「スキル個別」	40行xW列	※オートフィル対象・B3:V3~22
	カウント	スキル進化の番号カウント	[タイミング](全角スペース挿入)				「()」で始まる場合下の列へ移動、「▲」の削除	完成文	合計文字数	「に」の位置(効果の前の文字数)	確率・末尾の文字数	分末の括弧の文字数を加算	効果名称抽出(「付与」と付いていない場合は/が残ります)	置き換え(Xは判定用)		結合	データベースにあるものは≪≫	2度目の登場なら除外する	スキルリストへ戻る完成	特攻対象を抽出	特攻対象が重複していたら削除
	"=IF(H3<>"""",MAX(B$2:B2)+1,"""")"	"=IF(COUNTIF(入力シート!B7,""→*""),B3,"""")"	"=IF(COUNTIF(入力シート!B7,""*]""),""　""&入力シート!B7,IF(C3<>"""",""→&color(Red){""&MID(入力シート!B7,2,LEN(入力シート!B7)-2)&""};:"",D2))"	"=MID(D3,3,LEN(D3)-3)"	"=IF(AND(B3<>"""",COUNTIF(データベース!$I$3:$I$10,E3)),""○"",""×"")"	"=IF(OR(COUNTIF(入力シート!B7,""[*""),入力シート!B7=""""),"""",MID(入力シート!B7,2,LEN(入力シート!B7)-1))"	"=IF(OR(IFERROR(FIND("")"",G3),"""")=LEN(G3),IFERROR(FIND(""）"",G3),"""")=LEN(G3)),"""",IF(AND(G2<>"""",H2=""""),G2,"""")&IFERROR(LEFT(G3,FIND(""▲"",G3)-1)&MID(G3,FIND(""▲"",G3)+1,LEN(G3)),G3))"	"=IF(B3<>"""",IF(B3>MAX($C$3:$C$23),""　"","""")&IF(AND(D1=D3,I2<>""""),""　&color(transparent){[""&E3&""]};"",D3)&IF(C3<>"""","""",H3),"""")"	=LEN(H3)	"=IFERROR(FIND(""に"",H3),0)"	"=IFERROR(FIND(""%"",H3),0)-IFERROR(FIND(""/"",H3)-1,0)+IF(F3=""○"",1+LEN(INDEX(データベース!$I$3:$J$10,MATCH(E3,データベース!$I$3:$I$10,0),2)),IF(COUNTIF(H3,""*付与*""),3,0))"	"=IFERROR(FIND("")"",MID(H3,K3,J3-(K3)))-FIND(""("",MID(H3,K3,J3-(K3)))+1,0)+L3"	"=IF(B3=MAX($C$3:$C$22),"""",IFERROR(MID(H3,K3+1,J3-(K3+M3)+1),""""))"	"=IF(F3=""○"",IFNA(INDEX(データベース!$I$3:$K$10,MATCH(E3,データベース!$I$3:$I$10,0),3),""""),IFERROR(INDEX(データベース!$L$3:$L$14,IFERROR(FIND(""1"",TEXTJOIN("""",TRUE,IFERROR(MATCH(""*""&データベース!$L$3:$L$14&""*"",N3,0),""X""))),""""))&""X"",N3))"	"=IF(O3<>"""",IFERROR(""X""&INDEX(データベース!$M$3:$N$14,IFERROR(FIND(""1"",TEXTJOIN("""",TRUE,IFERROR(MATCH(""*""&データベース!$M$3:$M$14&""*"",N3,0),""X""))),""""),2),""""),"""")"	"=IF(COUNTIF(O3,""*X""),LEFT(O3,LEN(O3)-1),O3)&IF(COUNTIF(P3,""X*""),RIGHT(P3,LEN(P3)-1),"""")"	"=IF(COUNTIF(H3,""*付与*""),""【】"",""《》"")"	"=IF(COUNTIF(Q$2:Q2,Q3),"""",IF(Q3<>"""",LEFT(R3,1)&Q3&RIGHT(R3,1),""""))"	"=IF(S3<>"""",IF(B3>MAX($C$2:$C$23),""[[&color(Red){""&S3&""};>スキル/効果/""&Q3&""]]"",""[[""&S3&"">スキル/効果/""&Q3&""]]""),"""")"	"=IF(B3<>"""",IF(E3=""特攻"",""「[[""&IFERROR(LEFT(H3,K3-1)&""]]」"",""""),IF(E3=""状態特攻"",""【""&IFERROR(LEFT(H3,K3-1)&""】(状態特攻)"",""""),"""")),"""")"	"=IF(COUNTIF($V$2:V2,U3),IF(U3<>"""","""",""""),U3)"	←オートフィルここから
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						×
																						←ここまで
	"=IF(I23<>"""",MAX($B$3:$B$22)+1,"""")"	"=IF(COUNT(C3:C22)=0,999,0)"	×	×	×	×	※→以下テンプレ通り	//	×	×	×	×	×	×			×	×	×	×	×	×
	"=IF(I24<>"""",MAX($B$3:$B$23)+1,"""")"	↑スキル進化が無い場合はダミー挿入						//期間限定イベントでピックアップされた場合にイベント期間限定効果テンプレを挿入										"=TEXTJOIN("""",TRUE,T3:T22)"
	"=IF(I25<>"""",MAX($B$3:$B$24)+1,"""")"							//											特攻テンプレの挿入→	"=IF(20>COUNTIF($U$3:$U$22,""""),""○"",""×"")"
	"=IF(I26<>"""",MAX($B$3:$B$25)+1,"""")"							"=""||CENTER:~スキル所持キャラクター|h"""
	"=IF(I27<>"""",MAX($B$3:$B$26)+1,"""")"						※→入力フォームの【スキル番号】参照	"=""|基本スキル[1]|""&IF(入力シート!$B$5=1,データベース!$G$3,"""")&""|"""
	"=IF(I28<>"""",MAX($B$3:$B$27)+1,"""")"							"=""|基本スキル[2]|""&IF(入力シート!$B$5=2,データベース!$G$3,"""")&""|"""
	"=IF(I29<>"""",MAX($B$3:$B$28)+1,"""")"							"=""|基本スキル[3]|""&IF(入力シート!$B$5=3,データベース!$G$3,"""")&""|"""
	"=IF(I30<>"""",MAX($B$3:$B$29)+1,"""")"							"=""|基本スキル[4]|""&IF(入力シート!$B$5=4,データベース!$G$3,"""")&""|"""
	"=IF(I31<>"""",MAX($B$3:$B$30)+1,"""")"							"=""-備考"""
	"=IF(I32<>"""",MAX($B$3:$B$31)+1,"""")"							スキルの性能、使用感、使用する際の注意等を書き込んでください。
	"=IF(I33<>"""",MAX($B$3:$B$32)+1,"""")"							(ユニークスキルじゃない場合は)キャラクター自体の性能や相性はキャラページで。
	"=IF(I34<>"""",MAX($B$3:$B$33)+1,"""")"							//
	"=IF(I35<>"""",MAX($B$3:$B$34)+1,"""")"						※→特攻スキルが含まれていればテンプレ	"=IF($U$25=""○"",""#BR"","""")"
	"=IF(I36<>"""",MAX($B$3:$B$35)+1,"""")"							"=IF(I35<>"""",""|LEFT:5|||c"","""")"
	"=IF(I37<>"""",MAX($B$3:$B$36)+1,"""")"							"=IF(I36<>"""",""|特&br;攻|BGCOLOR(#FFCBBF):→|""&TEXTJOIN(""&br;"",TRUE,$V$3:$V$22)&""|"","""")"
	"=IF(I38<>"""",MAX($B$3:$B$37)+1,"""")"							"=IF(I37<>"""",""|~|BGCOLOR(#B2F2FF):←||"","""")"
	"=IF(I39<>"""",MAX($B$3:$B$38)+1,"""")"							"=""----"""
	"=IF(I40<>"""",MAX($B$3:$B$39)+1,"""")"							"=""　スキル一覧に戻る:""&$S$24"
×

※シート名「スキルリスト」	25行xR列		※オートフィル対象:B5:Q5~24
																	×
	×××
	カウント	スキル進化後した行を記録	タイミング		タイミングが上と同じか	表示	「▲」があれば取り除く	完成文	透明色判定	「/」の位置	確率表記の桁数	スキル文抽出	デメリット判定			確率
	"=IF(OR(COUNTIF(H5,""*]""),H5=""""),"""",MAX(B4:B$4)+1)"	"=IF(COUNTIF(入力シート!B7,""→*""),B5,"""")"	"=IF(COUNTIF(入力シート!B7,""*]""),""　""&入力シート!B7,IF(C5<>"""",""→&color(Red){""&MID(入力シート!B7,2,LEN(入力シート!B7)-2)&""};:"",D4))"	"=MID(D5,3,LEN(D5)-3)"	"=IF(AND(D3=D5,H5<>""""),""○"",""×"")"	"=IF(入力シート!B7<>"""",MID(入力シート!B7,2,LEN(入力シート!B7)-1),"""")"	"=IF(OR(IFERROR(FIND("")"",G5),FALSE)=LEN(G5),IFERROR(FIND(""）"",G5),FALSE)=LEN(G5)),"""",IF(AND(G4<>"""",H4=""""),G4,"""")&IFERROR(LEFT(G5,FIND(""▲"",G5)-1)&MID(G5,FIND(""▲"",G5)+1,LEN(G5)),G5))"	"=IF(B5>MAX($C$6:$C$25),""　"","""")&IF(B5="""","""",IF(B5=C5,""→&color(Red){''""&入力シート!$H$3&""+''};:"",J5&Q5))"	"=IF(B5<>"""",IF(AND(F5=""○"",J4<>""""), ""　&color(transparent){【''""&E5&""''】};""&P5,""　【&color(firebrick){''""&E5&""''};】""&P5),"""")"	"=IFERROR(FIND(""/"",H5),0)"	"=IF(K5>0,LEN(H5)-K5+1,0)"	"=IF(B5<>"""",MID(H5,1,LEN(H5)-L5),"""")"	"=IF(E5=""状態異常時"","""",IF(AND(OR(COUNTIF(M5,""*自身*""),COUNTIF(M5,""*味方*"")),IFERROR(SUMPRODUCT(COUNTIF(M5,""*""&データベース!$B$47:$B$73&""*"")),FALSE)>0),""デ"",""""))"	"=IF(N5=""デ"",IFERROR(FIND(""自身"",M5),IFERROR(FIND(""味方"",M5),0)),0)"	"=IF(N5=""デ"",IF(O5>1,LEFT(M5,O5-1),"""")&""&color(Purple){""&MID(M5,O5,2)&""};""&MID(M5,O5+2,LEN(M5)-O5-1),M5)"	"=IF(L5>0,""/&color(firebrick){''""&MID(H5,K5+1,L5)&""''};"","""")"	←ここから
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	×
																	←ここまで
	※→スキル未進化ならダミー	"=IF(COUNT(C5:C24)=0,999,"""")"	×××