Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Scoring

Posted on 2014-02-05
15
Medium Priority
?
155 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

705 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