Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Scoring

Posted on 2014-02-05
15
Medium Priority
?
156 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
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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 2000 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

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

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.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

773 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