Solved

Scoring

Posted on 2014-02-05
15
151 Views
Last Modified: 2014-02-06
Hi Experts,

I need to following steps in my WB via VBA.

01.

On Button click analyze
if C29=”High” then
+1 @ Cell B48 & D48 & F48 & H48

02.

Find C22 Value from Range C2:C10 (+ or – 3 point leverage)
if True then find respective factor in range B39:B47 & Add +1 else nothing next step

03.

Find C23 Value in Range C2:C10(+ or – 3 point leverage)
if true then find respective factor in range D39:D47 & Add +1else nothing next step

04.

Find C22 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range F39:F47 & Add +1 else nothing next step

05.

Find C23 value from range G2:G10(+ or – 3 point leverage)
if true then find respective factor in range H39:H47 & Add +1 else nothing. End
Find attached file

Thanks
Scoring-G.xlsm
0
Comment
Question by:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 5
15 Comments
 
LVL 31

Expert Comment

by:gowflow
ID: 39836469
your file is passwd protected
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39836485
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39836520
if any clarification needed regarding process pls reply.

Thanks
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
LVL 31

Expert Comment

by:gowflow
ID: 39836549
yes step 1 we add 1 to existing ?
step 2,3,4,5 where we add 1 what column
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39836610
ok
yes step 1 we add 1 to existing ?
Yes if there is "" then 1 if there is 3 then add +1 = 4
step 2,3,4,5 where we add 1 what column
ok
first change leverage (+ or – 3 point to 4 points) just for understanding
In Step 4  we found in TRUE value in cell G6 which is 288 & Cell C22 is 284 so assuming 4 point leverage comes to 284+4= 288. Factor for G6 is -180. So we have to put +1 in Cell F43. I guess you understand what am I up to.

Thanks
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39836631
This is Stage 1 of this question. there 2 more. second one  for LOWS & last for applying to all data point Math G

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39836897
would you simply wait till one finishes part 1 so you post part 2 ?? why this rush ??
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39836953
I am just saying Sir I am not gona post before Part one is over.

Thanks
0
 
LVL 31

Accepted Solution

by:
gowflow earned 500 total points
ID: 39836973
Is this what you want ?
pls test it
gowflow
Scoring-G-V01.xlsm
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837001
Yes Sir    :) only confirmation from your side leverage factor is + or - 4 point. m I right?

Thanks You
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837015
May post part 2?

Thanks
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 39837104
Excellent
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837143
yes go ahead although it is 11:30 now will try my best
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837150
here it is Scoring.


Thanks
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39839192
My Bad Sir 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. End
same way for LOW if you need detailed Step pls let me know I will post on that question.

Thanks
Scoring-G-V04.xlsm
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question