带座位的体育馆工程设计记录（01） 荷载组合

        因为是大跨度工程，采用通用软件计算时，自编荷载组合是少不了的，于是先列出荷载数量，然后去一个个组合，把任务交给了小田，鼓捣了一天交回来，我一看EXCEL里小田编的公式，笑坏了，因为公式太长了，虽然公式不复杂，但要读明白可不太容易，小田用了半天时间编出来的，占工作时间的一半！公式如下： 

=CONCATENATE(IF(AND(E3="",E3=0),"",TEXT(E3,"0.000")),IF(AND(E3="",E3=0),"",LEFT($E$1,1)),
IF(F3>0,"+",""),IF(AND(F3="",F3=0),"",TEXT(F3,"0.000")),IF(AND(F3="",F3=0),"",LEFT($F$1,1)&IGHT($F$1,9)),IF(G3>0,"+",""),IF(AND(G3="",G3=0),"",TEXT(G3,"0.000")),IF(AND(G3="",G3=0),"",LEFT($G$1,1)&RIGHT($G$1,9)),IF(H3>0,"+",""),IF(AND(H3="",H3=0),"",TEXT(H3,"0.000")),IF(AND(H3="",H3=0),"",LEFT($H$1,1)&RIGHT($H$1,9)),IF(I3>0,"+",""),IF(AND(I3="",I3=0),"",TEXT(I3,"0.000")),IF(AND(I3="",I3=0),"",LEFT($I$1,1)&RIGHT($I$1,9)),IF(J3>0,"+",""),IF(AND(J3="",J3=0),"",TEXT(J3,"0.000")),IF(AND(J3="",J3=0),"",LEFT($J$1,1)&RIGHT($J$1,9)),IF(K3>0,"+",""),IF(AND(K3="",K3=0),"",TEXT(K3,"0.000")),IF(AND(K3="",K3=0),"",LEFT($K$1,1)&RIGHT($K$1,9)),IF(L3>0,"+",""),IF(AND(L3="",L3=0),"",TEXT(L3,"0.000")),IF(AND(L3="",L3=0),"",LEFT($L$1,1)&RIGHT($L$1,9)),IF(M3>0,"+",""),IF(AND(M3="",M3=0),"",TEXT(M3,"0.000")),IF(AND(M3="",M3=0),"",LEFT($M$1,1)&RIGHT($M$1,9)),IF(N3>0,"+",""),IF(AND(N3="",N3=0),"",TEXT(N3,"0.000")),IF(AND(N3="",N3=0),"",LEFT($N$1,1)&RIGHT($N$1,9)),IF(O3>0,"+",""),IF(AND(O3="",O3=0),"",TEXT(O3,"0.000")),IF(AND(O3="",O3=0),"",LEFT($O$1,1)&RIGHT($O$1,9)),IF(P3>0,"+",""),IF(AND(P3="",P3=0),"",TEXT(P3,"0.000")),IF(AND(P3="",P3=0),"",LEFT($P$1,1)&RIGHT($P$1,9)),IF(Q3>0,"+",""),IF(AND(Q3="",Q3=0),"",TEXT(Q3,"0.000")),IF(AND(Q3="",Q3=0),"",LEFT($Q$1,1)&RIGHT($Q$1,9)),IF(R3>0,"+",""),IF(AND(R3="",R3=0),"",TEXT(R3,"0.000")),IF(AND(R3="",R3=0),"",LEFT($R$1,1)&RIGHT($R$1,9)),IF(S3>0,"+",""),IF(AND(S3="",S3=0),"",TEXT(S3,"0.000")),IF(AND(S3="",S3=0),"",LEFT($S$1,1)&RIGHT($S$1,9)),IF(T3>0,"+",""),IF(AND(T3="",T3=0),"",TEXT(T3,"0.000")),IF(AND(T3="",T3=0),"",LEFT($T$1,1)&RIGHT($T$1,9)),IF(U3>0,"+",""),IF(AND(U3="",U3=0),"",TEXT(U3,"0.000")),IF(AND(U3="",U3=0),"",LEFT($U$1,1)&RIGHT($U$1,9)),IF(V3>0,"+",""),IF(AND(V3="",V3=0),"",TEXT(V3,"0.000")),IF(AND(V3="",V3=0),"",LEFT($V$1,1)&RIGHT($V$1,9)),IF(W3>0,"+",""),IF(AND(W3="",W3=0),"",TEXT(W3,"0.000")),IF(AND(W3="",W3=0),"",LEFT($W$1,1)&RIGHT($W$1,9)),IF(X3>0,"+",""),IF(AND(X3="",X3=0),"",TEXT(X3,"0.000")),IF(AND(X3="",X3=0),"",LEFT($X$1,1)&RIGHT($X$1,9)),IF(Y3>0,"+",""),IF(AND(Y3="",Y3=0),"",TEXT(Y3,"0.000")),IF(AND(Y3="",Y3=0),"",LEFT($Y$1,1)&RIGHT($Y$1,9)),IF(Z3>0,"+",""),IF(AND(Z3="",Z3=0),"",TEXT(Z3,"0.000")),IF(AND(Z3="",Z3=0),"",LEFT($Z$1,1)&RIGHT($Z$1,9)),IF(AA3>0,"+",""),IF(AND(AA3="",AA3=0),"",TEXT(AA3,"0.000")),IF(AND(AA3="",AA3=0),"",LEFT($AA$1,1)&RIGHT($AA$1,9)),IF(AB3>0,"+",""),IF(AND(AB3="",AB3=0),"",TEXT(AB3,"0.000")),IF(AND(AB3="",AB3=0),"",LEFT($AB$1,1)&RIGHT($AB$1,9)),IF(AC3>0,"+",""),IF(AND(AC3="",AC3=0),"",TEXT(AC3,"0.000")),IF(AND(AC3="",AC3=0),"",LEFT($AC$1,1)&RIGHT($AC$1,9)),IF(AD3>0,"+",""),IF(AND(AD3="",AD3=0),"",TEXT(AD3,"0.000")),IF(AND(AD3="",AD3=0),"",LEFT($AD$1,1)&RIGHT($AD$1,9)),IF(AE3>0,"+",""),IF(AND(AE3="",AE3=0),"",TEXT(AE3,"0.000")),IF(AND(AE3="",AE3=0),"",LEFT($AE$1,2)),
IF(AF3>0,"+",""),IF(AND(AF3="",AF3=0),"",TEXT(AF3,"0.000")),IF(AND(AF3="",AF3=0),"",LEFT($AF$1,2)),IF(AG3>0,"+",""),
IF(AND(AG3="",AG3=0),"",TEXT(AG3,"0.000")),IF(AND(AG3="",AG3=0),"",LEFT($AG$1,2)),
IF(AH3>0,"+",""),IF(AND(AH3="",AH3=0),"",TEXT(AH3,"0.000")),IF(AND(AH3="",AH3=0),"",LEFT($AH$1,2)),IF(AI3>0,"+",""),
IF(AND(AI3="",AI3=0),"",TEXT(AI3,"0.000")),IF(AND(AI3="",AI3=0),"",LEFT($AI$1,2)),IF(AJ3>0,"+",""),
IF(AND(AJ3="",AJ3=0),"",TEXT(AJ3,"0.000")),IF(AND(AJ3="",AJ3=0),"",LEFT($AJ$1,2)),IF(AK3>0,"+",""),
IF(AND(AK3="",AK3=0),"",TEXT(AK3,"0.000")),IF(AND(AK3="",AK3=0),"",RIGHT($AK$1,2)&LEFT($AK$1,1)),IF(AL3>0,"+",""),IF(AND(AL3="",AL3=0),"",TEXT(AL3,"0.000")),IF(AND(AL3="",AL3=0),"",RIGHT($AL$1,2)&LEFT($AL$1,1)),IF(AM3>0,"+",""),IF(AND(AM3="",AM3=0),"",TEXT(AM3,"0.000")),IF(AND(AM3="",AM3=0),"",RIGHT($AM$1,2)&LEFT($AM$1,1)))

拷贝后生成了3000多种组合，分别如下：