;;file;x;.mp3;;;
;;total time (s);150;;splitting factor;=D2/D3;=G2-INT(G2)
;;splitting length (s);60;;;;
;;splitting result;=INT(G2);pieces of;=D3;s;
;;;=SE(H2>0,1,0);pieces of;=D3*H2;s;
Copy the following lines to a batch file:;;Auxiliary math:;;;;;
=CONCATENAR("@java -jar pcutmp3 ",D$1,E$1," --crop t:",C10,"-",D10," --out ",D$1,"-p",E10);;0;=SE(D2<D3,D2,D3*E10);1;;;
=SE(F11=1,"",CONCATENAR("@java -jar pcutmp3 ",D$1,E$1," --crop t:",C11,"-",D11," --out ",D$1,"-p",E11));;=SE(F11=1,"",D10+1);=SE(F11=1,"",SE(E10=D$5,D10+F$6,D$3*E11));2;=SE(E10>=D$5+D$6,1,0);;
=SE(F12=1,"",CONCATENAR("@java -jar pcutmp3 ",D$1,E$1," --crop t:",C12,"-",D12," --out ",D$1,"-p",E12));;=SE(F12=1,"",D11+1);=SE(F12=1,"",SE(E11=D$5,D11+F$6,D$3*E12));3;=SE(E11>=D$5+D$6,1,0);;
=SE(F13=1,"",CONCATENAR("@java -jar pcutmp3 ",D$1,E$1," --crop t:",C13,"-",D13," --out ",D$1,"-p",E13));;=SE(F13=1,"",D12+1);=SE(F13=1,"",SE(E12=D$5,D12+F$6,D$3*E13));4;=SE(E12>=D$5+D$6,1,0);;
wow, very nice, thanks. I managed to get it working - yet another surprise thing Excel can do. You might try not to use Portuguese(?) commands next time though, struggled a bit with these:).
What I want is not a hard feature to implement, I think and I would happy if anyone could code it in. Again, pcutmp3 GUI would be a better place for this feature (IMO).
This spreadsheet works nicely but I still prefer to have this sort of functionality integrated (whether in GUI or cmdline). Available MP3 splitter programs include also splitting by size (kb) and some even have silence detection (for e.g. audiobook chapters). Combining best possible mp3 cutting with these features (and nice GUI) would make the ultimate splitter:)