電價計算 (11689)

(先) E2:E8{=INDEX(FREQUENCY(IF(LEFT($A3,FIND("-",$A3)-1)+ROW($1:$62)-1-MID($A3,FIND("-",$A3)+1,9)<=0,LEFT($A3,FIND("-",$A3)-1)+ROW($1:$62)-1),{"5/31","9/30"}*1),2)

(次) D2:D8{=MATCH(MID($A3,FIND("-",$A3)+1,9),TEXT(LEFT($A3,FIND("-",$A3)-1)+ROW($1:$62)-1,"M/D"),)-E3

(後) C2:C8{=ROUND(SUM(TEXT(B3-{0;240;660;1000;1400;2000},"0;!0")*D3:E3/SUM(D3:E3)*(H$4:I$9-N(+H$3:I$8))),)