未来函数检测结果如下:
该公式包含未来函数:WINNER
该公式包含未来函数:COST


HB:=COST(99.9);

LB:=COST(0.1);

B3:=(HB-LB)/50;

B31:=HB-B3;

B32:=HB-2*B3;

B33:=HB-3*B3;

B34:=HB-4*B3;

B35:=HB-5*B3;

B36:=HB-6*B3;

B37:=HB-7*B3;

B38:=HB-8*B3;

B39:=HB-9*B3;

B310:=HB-10*B3;

B311:=HB-11*B3;

B312:=HB-12*B3;

B313:=HB-13*B3;

B314:=HB-14*B3;

B315:=HB-15*B3;

B316:=HB-16*B3;

B317:=HB-17*B3;

B318:=HB-18*B3;

B319:=HB-19*B3;

B320:=HB-20*B3;

B321:=HB-21*B3;

B322:=HB-22*B3;

B323:=HB-23*B3;

B324:=HB-24*B3;

B325:=HB-25*B3;

B326:=HB-26*B3;

B327:=HB-27*B3;

B328:=HB-28*B3;

B329:=HB-29*B3;

B330:=HB-30*B3;

B331:=HB-31*B3;

B332:=HB-32*B3;

B333:=HB-33*B3;

B334:=HB-34*B3;

B335:=HB-35*B3;

B336:=HB-36*B3;

B337:=HB-37*B3;

B338:=HB-38*B3;

B339:=HB-39*B3;

B340:=HB-40*B3;

B341:=HB-41*B3;

B342:=HB-42*B3;

B343:=HB-43*B3;

B344:=HB-44*B3;

B345:=HB-45*B3;

B346:=HB-46*B3;

B347:=HB-47*B3;

B348:=HB-48*B3;

B349:=HB-49*B3;

A1:=WINNER(HB)*100-WINNER(B31)*100;

A2:=WINNER(B31)*100-WINNER(B32)*100;

A3:=WINNER(B32)*100-WINNER(B33)*100;

A4:=WINNER(B33)*100-WINNER(B34)*100;

A5:=WINNER(B34)*100-WINNER(B35)*100;

A6:=WINNER(B35)*100-WINNER(B36)*100;

A7:=WINNER(B36)*100-WINNER(B37)*100;

A8:=WINNER(B37)*100-WINNER(B38)*100;

A9:=WINNER(B38)*100-WINNER(B39)*100;

A10:=WINNER(B39)*100-WINNER(B310)*100;

A11:=WINNER(B310)*100-WINNER(B311)*100;

A12:=WINNER(B311)*100-WINNER(B312)*100;

A13:=WINNER(B312)*100-WINNER(B313)*100;

A14:=WINNER(B313)*100-WINNER(B314)*100;

A15:=WINNER(B314)*100-WINNER(B315)*100;

A16:=WINNER(B315)*100-WINNER(B316)*100;

A17:=WINNER(B316)*100-WINNER(B317)*100;

A18:=WINNER(B317)*100-WINNER(B318)*100;

A19:=WINNER(B318)*100-WINNER(B319)*100;

A20:=WINNER(B319)*100-WINNER(B320)*100;

A21:=WINNER(B320)*100-WINNER(B321)*100;

A22:=WINNER(B321)*100-WINNER(B322)*100;

A23:=WINNER(B322)*100-WINNER(B323)*100;

A24:=WINNER(B323)*100-WINNER(B324)*100;

A25:=WINNER(B324)*100-WINNER(B325)*100;

A26:=WINNER(B325)*100-WINNER(B326)*100;

A27:=WINNER(B326)*100-WINNER(B327)*100;

A28:=WINNER(B327)*100-WINNER(B328)*100;

A29:=WINNER(B328)*100-WINNER(B329)*100;

A30:=WINNER(B329)*100-WINNER(B330)*100;

A31:=WINNER(B330)*100-WINNER(B331)*100;

A32:=WINNER(B331)*100-WINNER(B332)*100;

A33:=WINNER(B332)*100-WINNER(B333)*100;

A34:=WINNER(B333)*100-WINNER(B334)*100;

A35:=WINNER(B334)*100-WINNER(B335)*100;

A36:=WINNER(B335)*100-WINNER(B336)*100;

A37:=WINNER(B336)*100-WINNER(B337)*100;

A38:=WINNER(B337)*100-WINNER(B338)*100;

A39:=WINNER(B338)*100-WINNER(B339)*100;

A40:=WINNER(B339)*100-WINNER(B340)*100;

A41:=WINNER(B340)*100-WINNER(B341)*100;

A42:=WINNER(B341)*100-WINNER(B342)*100;

A43:=WINNER(B342)*100-WINNER(B343)*100;

A44:=WINNER(B343)*100-WINNER(B344)*100;

A45:=WINNER(B344)*100-WINNER(B345)*100;

A46:=WINNER(B345)*100-WINNER(B346)*100;

A47:=WINNER(B346)*100-WINNER(B347)*100;

A48:=WINNER(B347)*100-WINNER(B348)*100;

A49:=WINNER(B348)*100-WINNER(B349)*100;

A50:=WINNER(B349)*100-WINNER(LB)*100;

STICKLINE(BARSTATUS=2,HB ,HB ,A1*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B31 ,B31 ,A1*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B32 ,B32 ,A2*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B33 ,B33 ,A3*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B34 ,B34 ,A4*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B35 ,B35 ,A5*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B36 ,B36 ,A6*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B37 ,B37 ,A7*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B38 ,B38 ,A8*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B39 ,B39 ,A9*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B310 ,B310 ,A10*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B311 ,B311 ,A11*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B312 ,B312 ,A12*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B313 ,B313 ,A13*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B314 ,B314 ,A14*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B315 ,B315 ,A15*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B316 ,B316 ,A16*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B317 ,B317 ,A17*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B318 ,B318 ,A18*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B319 ,B319 ,A19*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B320 ,B320 ,A20*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B321 ,B321 ,A21*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B322 ,B322 ,A22*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B323 ,B323 ,A23*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B324 ,B324 ,A24*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B325 ,B325 ,A25*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B326 ,B326 ,A26*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B327 ,B327 ,A27*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B328 ,B328 ,A28*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B329 ,B329 ,A29*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B330 ,B330 ,A30*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B331 ,B331 ,A31*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B332 ,B332 ,A32*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B333 ,B333 ,A33*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B334 ,B334 ,A34*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B335 ,B335 ,A35*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B336 ,B336 ,A36*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B337 ,B337 ,A37*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B338 ,B338 ,A38*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B339 ,B339 ,A39*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B340 ,B340 ,A40*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B341 ,B341 ,A41*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B342 ,B342 ,A42*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B343 ,B343 ,A43*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B344 ,B344 ,A44*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B345 ,B345 ,A45*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B346 ,B346 ,A46*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B347 ,B347 ,A47*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B348 ,B348 ,A48*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,B349 ,B349 ,A49*50 ,0 ),COLORLIGRAY;

STICKLINE(BARSTATUS=2,LB ,LB ,A50*50 ,0 ),COLORLIGRAY;

原理解析:
HB赋值:获利盘为99.9%的成本分布


LB赋值:获利盘为0.1%的成本分布


B3赋值:(HB-LB)/50


B31:=HB-B3


B32:=HB-2*B3


B33:=HB-3*B3


B34:=HB-4*B3


B35:=HB-5*B3


B36:=HB-6*B3


B37:=HB-7*B3


B38:=HB-8*B3


B39:=HB-9*B3


B310:=HB-10*B3


B311:=HB-11*B3


B312:=HB-12*B3


B313:=HB-13*B3


B314:=HB-14*B3


B315:=HB-15*B3


B316:=HB-16*B3


B317:=HB-17*B3


B318:=HB-18*B3


B319:=HB-19*B3


B320:=HB-20*B3


B321:=HB-21*B3


B322:=HB-22*B3


B323:=HB-23*B3


B324:=HB-24*B3


B325:=HB-25*B3


B326:=HB-26*B3


B327:=HB-27*B3


B328:=HB-28*B3


B329:=HB-29*B3


B330:=HB-30*B3


B331:=HB-31*B3


B332:=HB-32*B3


B333:=HB-33*B3


B334:=HB-34*B3


B335:=HB-35*B3


B336:=HB-36*B3


B337:=HB-37*B3


B338:=HB-38*B3


B339:=HB-39*B3


B340:=HB-40*B3


B341:=HB-41*B3


B342:=HB-42*B3


B343:=HB-43*B3


B344:=HB-44*B3


B345:=HB-45*B3


B346:=HB-46*B3


B347:=HB-47*B3


B348:=HB-48*B3


B349:=HB-49*B3


A1赋值:HB计算的获利盘比例*100-WINNER(B31)*100


A2赋值:B31计算的获利盘比例*100-WINNER(B32)*100


A3赋值:B32计算的获利盘比例*100-WINNER(B33)*100


A4赋值:B33计算的获利盘比例*100-WINNER(B34)*100


A5赋值:B34计算的获利盘比例*100-WINNER(B35)*100


A6赋值:B35计算的获利盘比例*100-WINNER(B36)*100


A7赋值:B36计算的获利盘比例*100-WINNER(B37)*100


A8赋值:B37计算的获利盘比例*100-WINNER(B38)*100


A9赋值:B38计算的获利盘比例*100-WINNER(B39)*100


A10:=B39计算的获利盘比例*100-WINNER(B310)*100


A11:=B310计算的获利盘比例*100-WINNER(B311)*100


A12:=B311计算的获利盘比例*100-WINNER(B312)*100


A13:=B312计算的获利盘比例*100-WINNER(B313)*100


A14:=B313计算的获利盘比例*100-WINNER(B314)*100


A15:=B314计算的获利盘比例*100-WINNER(B315)*100


A16:=B315计算的获利盘比例*100-WINNER(B316)*100


A17:=B316计算的获利盘比例*100-WINNER(B317)*100


A18:=B317计算的获利盘比例*100-WINNER(B318)*100


A19:=B318计算的获利盘比例*100-WINNER(B319)*100


A20:=B319计算的获利盘比例*100-WINNER(B320)*100


A21:=B320计算的获利盘比例*100-WINNER(B321)*100


A22:=B321计算的获利盘比例*100-WINNER(B322)*100


A23:=B322计算的获利盘比例*100-WINNER(B323)*100


A24:=B323计算的获利盘比例*100-WINNER(B324)*100


A25:=B324计算的获利盘比例*100-WINNER(B325)*100


A26:=B325计算的获利盘比例*100-WINNER(B326)*100


A27:=B326计算的获利盘比例*100-WINNER(B327)*100


A28:=B327计算的获利盘比例*100-WINNER(B328)*100


A29:=B328计算的获利盘比例*100-WINNER(B329)*100


A30:=B329计算的获利盘比例*100-WINNER(B330)*100


A31:=B330计算的获利盘比例*100-WINNER(B331)*100


A32:=B331计算的获利盘比例*100-WINNER(B332)*100


A33:=B332计算的获利盘比例*100-WINNER(B333)*100


A34:=B333计算的获利盘比例*100-WINNER(B334)*100


A35:=B334计算的获利盘比例*100-WINNER(B335)*100


A36:=B335计算的获利盘比例*100-WINNER(B336)*100


A37:=B336计算的获利盘比例*100-WINNER(B337)*100


A38:=B337计算的获利盘比例*100-WINNER(B338)*100


A39:=B338计算的获利盘比例*100-WINNER(B339)*100


A40:=B339计算的获利盘比例*100-WINNER(B340)*100


A41:=B340计算的获利盘比例*100-WINNER(B341)*100


A42:=B341计算的获利盘比例*100-WINNER(B342)*100


A43:=B342计算的获利盘比例*100-WINNER(B343)*100


A44:=B343计算的获利盘比例*100-WINNER(B344)*100


A45:=B344计算的获利盘比例*100-WINNER(B345)*100


A46:=B345计算的获利盘比例*100-WINNER(B346)*100


A47:=B346计算的获利盘比例*100-WINNER(B347)*100


A48:=B347计算的获利盘比例*100-WINNER(B348)*100


A49:=B348计算的获利盘比例*100-WINNER(B349)*100


A50:=B349计算的获利盘比例*100-WINNER(LB)*100
当满足条件BARSTATUS=2时,在HB 和HB 之间画柱状线
当满足条件BARSTATUS=2时,在B31 和B31 之间画柱状线
当满足条件BARSTATUS=2时,在B32 和B32 之间画柱状线
当满足条件BARSTATUS=2时,在B33 和B33 之间画柱状线
当满足条件BARSTATUS=2时,在B34 和B34 之间画柱状线
当满足条件BARSTATUS=2时,在B35 和B35 之间画柱状线
当满足条件BARSTATUS=2时,在B36 和B36 之间画柱状线
当满足条件BARSTATUS=2时,在B37 和B37 之间画柱状线
当满足条件BARSTATUS=2时,在B38 和B38 之间画柱状线
当满足条件BARSTATUS=2时,在B39 和B39 之间画柱状线
当满足条件BARSTATUS=2时,在B310 和B310 之间画柱状线
当满足条件BARSTATUS=2时,在B311 和B311 之间画柱状线
当满足条件BARSTATUS=2时,在B312 和B312 之间画柱状线
当满足条件BARSTATUS=2时,在B313 和B313 之间画柱状线
当满足条件BARSTATUS=2时,在B314 和B314 之间画柱状线
当满足条件BARSTATUS=2时,在B315 和B315 之间画柱状线
当满足条件BARSTATUS=2时,在B316 和B316 之间画柱状线
当满足条件BARSTATUS=2时,在B317 和B317 之间画柱状线
当满足条件BARSTATUS=2时,在B318 和B318 之间画柱状线
当满足条件BARSTATUS=2时,在B319 和B319 之间画柱状线
当满足条件BARSTATUS=2时,在B320 和B320 之间画柱状线
当满足条件BARSTATUS=2时,在B321 和B321 之间画柱状线
当满足条件BARSTATUS=2时,在B322 和B322 之间画柱状线
当满足条件BARSTATUS=2时,在B323 和B323 之间画柱状线
当满足条件BARSTATUS=2时,在B324 和B324 之间画柱状线
当满足条件BARSTATUS=2时,在B325 和B325 之间画柱状线
当满足条件BARSTATUS=2时,在B326 和B326 之间画柱状线
当满足条件BARSTATUS=2时,在B327 和B327 之间画柱状线
当满足条件BARSTATUS=2时,在B328 和B328 之间画柱状线
当满足条件BARSTATUS=2时,在B329 和B329 之间画柱状线
当满足条件BARSTATUS=2时,在B330 和B330 之间画柱状线
当满足条件BARSTATUS=2时,在B331 和B331 之间画柱状线
当满足条件BARSTATUS=2时,在B332 和B332 之间画柱状线
当满足条件BARSTATUS=2时,在B333 和B333 之间画柱状线
当满足条件BARSTATUS=2时,在B334 和B334 之间画柱状线
当满足条件BARSTATUS=2时,在B335 和B335 之间画柱状线
当满足条件BARSTATUS=2时,在B336 和B336 之间画柱状线
当满足条件BARSTATUS=2时,在B337 和B337 之间画柱状线
当满足条件BARSTATUS=2时,在B338 和B338 之间画柱状线
当满足条件BARSTATUS=2时,在B339 和B339 之间画柱状线
当满足条件BARSTATUS=2时,在B340 和B340 之间画柱状线
当满足条件BARSTATUS=2时,在B341 和B341 之间画柱状线
当满足条件BARSTATUS=2时,在B342 和B342 之间画柱状线
当满足条件BARSTATUS=2时,在B343 和B343 之间画柱状线
当满足条件BARSTATUS=2时,在B344 和B344 之间画柱状线
当满足条件BARSTATUS=2时,在B345 和B345 之间画柱状线
当满足条件BARSTATUS=2时,在B346 和B346 之间画柱状线
当满足条件BARSTATUS=2时,在B347 和B347 之间画柱状线
当满足条件BARSTATUS=2时,在B348 和B348 之间画柱状线
当满足条件BARSTATUS=2时,在B349 和B349 之间画柱状线
当满足条件BARSTATUS=2时,在LB 和LB 之间画柱状线

声明:本站所有资源,均为用户自主上传,仅作为学习交流之用,其版权归原作者或原出版社所有,本站不对所涉及的版权问题负法律责任。如有侵权,请联系我们删除!