粗车公式：=CHOOSE(VLOOKUP(S4,{"李永泉",1;"订士义",2;"丁增悦",3;"臧运新",4;"臧运金",5;"订明克",6},2,FALSE),SUM((((((J4+6)-(K4-6))/(2*(IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.074)))*4+(L4/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*V4)+((L4+2)/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*W4)+0)/60*22)*U4,SUM((((((J4+6)-(K4-6))/(2*(IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.074)))*4+(L4/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*V4)+((L4+2)/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*W4)+0)/60*22)*U4,SUM((((((J4+6)-(K4-6))/(2*(IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.074)))*4+(L4/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*V4)+((L4+2)/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*W4)+0)/60*22)*U4,SUM((((((J4+6)-(K4-6))/(2*(IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.074)))*4+(L4/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*V4)+((L4+2)/((IF((J4+6)<=90,200,IF((J4+6)<=130,180,IF((J4+6)<=170,160,IF((J4+6)<=210,120,IF((J4+6)<=250,90,IF((J4+6)<=290,70,IF((J4+6)<=330,50,IF((J4+6)<=400,50))))))))*1.15)*0.13)*W4)+0)/60*22)*U4,SUM(((((J4+20)-(K4-25))/(2*(((IF((J4+20)<=90,220,IF((J4+20)<=130,200,IF((J4+20)<=170,180,IF((J4+20)<=210,150,IF((J4+20)<=250,130,IF((J4+20)<=290,80,IF((J4+20)<=390,60))))))))*1.15)*0.074)))*4+(L4/(((IF((J4+20)<=90,220,IF((J4+20)<=130,200,IF((J4+20)<=170,180,IF((J4+20)<=210,150,IF((J4+20)<=250,130,IF((J4+20)<=290,80,IF((J4+20)<=390,60))))))))*1.15)*0.13)*V4)+((L4+2)/(((IF((J4+20)<=90,220,IF((J4+20)<=130,200,IF((J4+20)<=170,180,IF((J4+20)<=210,150,IF((J4+20)<=250,130,IF((J4+20)<=290,80,IF((J4+20)<=390,60))))))))*1.15)*0.13)*W4)+0)/60*19)*U4,SUM(((((J4+20)-(K4-25))/(2*(((IF((J4+20)<=90,220,IF((J4+20)<=130,200,IF((J4+20)<=170,180,IF((J4+20)<=210,150,IF((J4+20)<=250,130,IF((J4+20)<=290,80,IF((J4+20)<=390,60))))))))*1.15)*0.074)))*4+(L4/(((IF((J4+20)<=90,220,IF((J4+20)<=130,200,IF((J4+20)<=170,180,IF((J4+20)<=210,150,IF((J4+20)<=250,130,IF((J4+20)<=290,80,IF((J4+20)<=390,60))))))))*1.15)*0.13)*V4)+((L4+2)/(((IF((J4+20)<=90,220,IF((J4+20)<=130,200,IF((J4+20)<=170,180,IF((J4+20)<=210,150,IF((J4+20)<=250,130,IF((J4+20)<=290,80,IF((J4+20)<=390,60))))))))*1.15)*0.13)*W4)+0)/60*19)*U4)
精车公式：=CHOOSE(VLOOKUP(AC4,{"王彬",1;"于增强",2;"孙伟",3;"王岩新",4;"永召",5},2,FALSE),SUM(((IF(((J4+3)-(K4-3))/2>=15,(((J4+3)-(K4-3))/2),))/(2*(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.074))*2+(L4/(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.13)*2)+((L4+2)/(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.13)*2)+2)/60*22)*AD4,SUM(((IF(((J4+3)-(K4-3))/2>=15,(((J4+3)-(K4-3))/2),))/(2*(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.074))*2+(L4/(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.13)*2)+((L4+2)/(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.13)*2)+2)/60*22)*AD4,SUM(((IF(((J4+3)-(K4-3))/2>=15,(((J4+3)-(K4-3))/2),))/(2*(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.074))*2+(L4/(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.13)*2)+((L4+2)/(((IF((J4+3)<=50,280,IF((J4+3)<=90,280,IF((J4+3)<=140,220,IF((J4+3)<=180,180,IF((J4+3)<=240,140,IF((J4+3)<=280,110,IF((J4+3)<=340,90))))))))*1.15)*0.13)*2)+2)/60*22)*AD4,SUM((IF(J4>=250,10,0)+(L4/(((IF((J4+6)<=50,280,IF((J4+6)<=90,280,IF((J4+6)<=140,220,IF((J4+6)<=180,180,IF((J4+6)<=240,140,IF((J4+6)<=280,110,IF((J4+6)<=350,90))))))))*1.15)*0.13)*3)+((L4+2)/(((IF((J4+6)<=50,280,IF((J4+6)<=90,280,IF((J4+6)<=140,220,IF((J4+6)<=180,180,IF((J4+6)<=240,140,IF((J4+6)<=280,110,IF((J4+6)<=350,90))))))))*1.15)*0.13)*3)+(IF((J4+6)<=50,2,IF((J4+6)<=90,2,IF((J4+6)<=140,2,IF((J4+6)<=180,2,IF((J4+6)<=240,3,IF((J4+6)<=280,3,IF((J4+6)<=340,4))))))))+(IF((((J4+6)-(K4-6))/2)>=15,(((J4+6)-(K4-6))/2),0))/(2*(((IF((J4+6)<=50,280,IF((J4+6)<=90,280,IF((J4+6)<=140,220,IF((J4+6)<=180,180,IF((J4+6)<=240,140,IF((J4+6)<=280,110,IF((J4+6)<=350,90))))))))*1.15)*0.074))*2)/60*22)*AD4,SUM((IF(J4>=250,10,0)+(L4/(((IF((J4+6)<=50,280,IF((J4+6)<=90,280,IF((J4+6)<=140,220,IF((J4+6)<=180,180,IF((J4+6)<=240,140,IF((J4+6)<=280,110,IF((J4+6)<=350,90))))))))*1.15)*0.13)*3)+((L4+2)/(((IF((J4+6)<=50,280,IF((J4+6)<=90,280,IF((J4+6)<=140,220,IF((J4+6)<=180,180,IF((J4+6)<=240,140,IF((J4+6)<=280,110,IF((J4+6)<=350,90))))))))*1.15)*0.13)*3)+(IF((J4+6)<=50,2,IF((J4+6)<=90,2,IF((J4+6)<=140,2,IF((J4+6)<=180,2,IF((J4+6)<=240,3,IF((J4+6)<=280,3,IF((J4+6)<=340,4))))))))+(IF((((J4+6)-(K4-6))/2)>=15,(((J4+6)-(K4-6))/2),0))/(2*(((IF((J4+6)<=50,280,IF((J4+6)<=90,280,IF((J4+6)<=140,220,IF((J4+6)<=180,180,IF((J4+6)<=240,140,IF((J4+6)<=280,110,IF((J4+6)<=350,90))))))))*1.15)*0.074))*2)/60*22)*AD4)
请大神给优化一下，简洁一些，然后根据（I列 ）同心用以上公式，偏心在公式基础上*2.5
拜托拜托！！！J：外径；K：内径；L：高度；V：外刀数（基础为：3）；W：内刀数（基础为：3）；U：粗车实际数量；AD：精车实际数量。

雇主联系方式
微信	********(投标后可见)
QQ	********(投标后可见)

投标并联系雇主

免责声明：BCCN仅提供信息发布服务，暂未提供担保交易服务，请交易时在线下自行签订合同，以保障双方权益。