Solved

Scoring

Posted on 2014-02-05
15
138 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:itjockey
  • 10
  • 5
15 Comments
 
LVL 29

Expert Comment

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

Author Comment

by:itjockey
ID: 39836485
0
 
LVL 8

Author Comment

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

Thanks
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 29

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:itjockey
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:itjockey
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 29

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:itjockey
ID: 39836953
I am just saying Sir I am not gona post before Part one is over.

Thanks
0
 
LVL 29

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:itjockey
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:itjockey
ID: 39837015
May post part 2?

Thanks
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 39837104
Excellent
0
 
LVL 29

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:itjockey
ID: 39837150
here it is Scoring.


Thanks
0
 
LVL 8

Author Comment

by:itjockey
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

776 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