我也发个群里面的函数题吧

Deepseek还是厉害，喊他帮我简化直接简化这么点了
=LET(a,(G2+H2)*2-290,HSTACK(50,INT(a/3)+30-(MOD(a,3)>0),20+CHOOSE(MOD(a,3)+1,0,2,1)))

=LET(s,G2:H2,l,MAX(s),w,MIN(s),ls,A2,ps,TOROW(B2:B4),fs,TOROW(C2:C4),es,TOROW(D2:D4),gn,LAMBDA(tl,LET(f,LAMBDA(rs,r,tl,ls,n,IF(OFFSET(ls,1,)=0,IF(MOD(tl,ls)=0,VSTACK(rs,HSTACK(r,tl/ls)),rs),LET(cl,tl-ls*n,IF(cl=0,VSTACK(rs,HSTACK(r,n)),IF(cl>0,f(f(rs,HSTACK(r,n),cl,OFFSET(ls,1,),0),r,tl,ls,n+1),rs))))),rs,f(0,0,tl,ls,0),IF(ROWS(rs)=1,"无解",IFNA(EXPAND(DROP(rs,1,1),,COLUMNS(ps)),0)))),gp,LAMBDA(ns,BYROW(ns,LAMBDA(r,SUM(ps*r)+SUM(IF(r>fs,r-fs,0)*es)))),sn,LAMBDA(tl,LET(ns,gn(tl),IF(@ns="无解",ns,SORTBY(ns,gp(ns))))),br,LAMBDA(a,f,LET(r,f(TAKE(a,1)),IF(@r="N",IF(ROWS(a)>1,br(DROP(a,1),f),r),VSTACK(TAKE(a,1),r)))),rr,LAMBDA(a,rs,f,LET(r,f(a,TAKE(rs,1)),IF(@r="N",IF(ROWS(rs)>1,rr(a,DROP(rs,1),f),r),VSTACK(TAKE(rs,1),r)))),cns,sn((l+w)*2),lns,sn(l),wns,sn(w),IF(OR(@cns="无解",@lns="无解",@wns="无解"),"无解",LET(a,DROP(br(cns,LAMBDA(r,rr(r,lns,LAMBDA(a,r,IF(AND(a-r>=0),rr(a-r,lns,LAMBDA(a,r,IF(AND(a-r>=0),rr(a-r,wns,LAMBDA(a,r,IF(AND(a-r>=0),rr(a-r,wns,LAMBDA(a,r,IF(AND(a-r=0),r,"N"))),"N"))),"N"))),"N"))))),-1),IFNA(HSTACK(a,gp(TAKE(a,1))),""))))

=LET(s,TOCOL(REDUCE(0,A$2:A$4,LAMBDA(x,y,TOROW(x+SEQUENCE(OFFSET(y,,2)+5,,0)*LEFT(y))))),u,TOCOL(REDUCE("",A$2:A$4,LAMBDA(x,y,TOROW(x&"+"&(SEQUENCE(OFFSET(y,,2)+5,,0)))))),长,FILTER(u,s=G2),宽,FILTER(u,s=H2),g,LAMBDA(j,DROP(REDUCE("",j,LAMBDA(x,y,VSTACK(x,y&"|"&DROP(j,MATCH(y,j,)-1)))),1)),f,LAMBDA(k,UNIQUE(MAP(k,LAMBDA(z,ARRAYTOTEXT(BYCOL(--TEXTSPLIT(z,"+","|",1),SUM)))))),TEXTSPLIT(@SORT(REDUCE("",f(g(长)),LAMBDA(z,V,VSTACK(z,TAKE(SORT(REDUCE({"",10000},V&"|"&f(g(宽)),LAMBDA(x,y,LET(p,TOCOL(BYCOL(--TEXTSPLIT(y,",","|"),SUM)),e,SUM(p*B$2:B$4,IF(p-C$2:C$4>0,p-C$2:C$4,)*D$2:D$4),IF(AND(p-C$2:C$4<30),VSTACK(x,HSTACK(TEXTJOIN(",",,p,e),e)),x)))),2),1)))),2),","))
群里有人写的 我wps用不了这个函数

这题有这么难吗，没有运费的时候，都是1米15元，所以290米以内，虽然有很多种采购方案，但是总价是一样的，给一种采购方案就行了吧，也没必要列出所以，就290临界的这个点上下，要考虑怎么组合运费最低，超过临界点过后2米+3米的运费大于5米的，所以临界点过后就不采购2米的了，全部采购3米和5米。

好嘛，好像难点就是越短越难嘛

一天写点点 我看能组合好长
=LET(a,(G12+H12)*2,HSTACK(INT(a/5)+CHOOSE(MOD(a,5)+1,0,2,1,3,2),INT(a/5)-MOD(MOD(a,5),2),0))
长宽大于4米，周长小于158米，采购方案：采购23组合，直到3米的30根用完，现在差158米到运费临界点，及4米以下的采购方案

=LET(s,TOCOL(REDUCE(0,A$2:A$4,LAMBDA(x,y,TOROW(x+SEQUENCE(OFFSET(y,,2)+5,,0)*LEFT(y))))),u,TOCOL(REDUCE("",A$2:A$4,LAMBDA(x,y,TOROW(x&"+"&(SEQUENCE(OFFSET(y,,2)+5,,0)))))),长,FILTER(u,s=G2),宽,FILTER(u,s=H2),g,LAMBDA(j,DROP(REDUCE("",j,LAMBDA(x,y,VSTACK(x,y&"|"&DROP(j,MATCH(y,j,)-1)))),1)),f,LAMBDA(k,UNIQUE(MAP(k,LAMBDA(z,ARRAYTOTEXT(BYCOL(--TEXTSPLIT(z,"+","|",1),SUM)))))),fgc,f(g(长)),fgk,f(g(宽)),TEXTSPLIT(@SORT(REDUCE("",fgc,LAMBDA(z,V,VSTACK(z,TAKE(SORT(REDUCE({"",10000},V&"|"&fgk,LAMBDA(x,y,LET(p,TOCOL(BYCOL(--TEXTSPLIT(y,",","|"),SUM)),e,SUM(p*B$2:B$4,IF(p-C$2:C$4>0,p-C$2:C$4,)*D$2:D$4),IF(AND(p-C$2:C$4<30),VSTACK(x,HSTACK(TEXTJOIN(",",,p,e),e)),x)))),2),1)))),2),","))

=LET(a,(G17+H17)*2,IF(a<150,HSTACK(INT(a/5)+CHOOSE(MOD(a,5)+1,0,2,1,3,2),INT(a/5)-MOD(MOD(a,5),2),0),IF(a<296,HSTACK(30+INT((a-150)/7)+CHOOSE(MOD(a-150,7)+1,0,1,1,-1,2,0,-2),30+IF(MOD(a-150,7)=1,-2,0),INT((a-150)/7)+CHOOSE(MOD(a-150,7)+1,0,1,0,1,0,1,2)),HSTACK(50,INT((a-290)/3)+30+CHOOSE(MOD(a-290,3)+1,0,-3,-1),20+CHOOSE(MOD(a-290,3)+1,0,2,1)))))
周长大于16米的采购方案