未来函数检测结果如下:
该公式包含未来函数: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 之间画柱状线