Link to home
Start Free TrialLog in
Avatar of Naresh Patel
Naresh PatelFlag for India

asked on

Scoring

Sir gowflow need little modification.

01.

On Button click analyze
if C29=”High” then
+1 @ Cell B49 & D49 & F49 & H49

02.

Find C22 Value from Range C2:C11 (+ or – 3 point leverage)
if True then find respective factor in range B39:B48 & Add +1 (if  it is at Close Hits then put +1 @ Unity)else nothing next step

03.

Find C23 Value in Range C2:C11(+ or – 3 point leverage)
if true then find respective factor in range D39:D48 & Add +1(if  it is at Close Hits then put +1 @ Unity )else nothing next step

04.

Find C22 value from range G2:G11(+ or – 3 point leverage)
if true then find respective factor in range F39:F48 & Add +1 (if  it is at Point Hits then put +1 @ Unity )else nothing next step

05.

Find C23 value from range G2:G11(+ or – 3 point leverage)
if true then find respective factor in range H39:H48 & Add +1 (if  it is at Point Hits then put +1 @ Unity )else nothing. Endsame way for LOW if you need detailed Step pls let me know I will post here.

Thanks
Scoring-G-V04.xlsm
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

All this should replace the previoous code or it is on top of the previous code ?
gowflow
file is password protected. pls remove the password
gowflow
Avatar of Naresh Patel

ASKER

it s your call, what ever you feel to do so? I just add one row Unity in Both High & Low process.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Jacques Geday
Jacques Geday
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Perfect
May I Post My Next Question?

Thanks
here it is Scoring.


Thanks