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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Scoring

Hi Experts,

Need VBA code for attached procedure, it looks difficult in fist sight but if you understand it is so easy as calculation is lengthy but process is simple.

In attached workbook
Sheet - TEXT is gives you general idea what is the procedure.
Sheet - LT  (Member) data sheet.
Sheet - LT.Z (Sample) is process sheet as well as result sheet.
Sheet - LT.Z is calculation sheet where you can see what are the steps & its calculation.

Thanks
Z-Score.xlsm
0
itjockey79
Asked:
itjockey79
  • 7
  • 2
  • 2
  • +1
3 Solutions
 
[ fanpages ]IT Services ConsultantCommented:
Hi,

Which part of the simple (lengthy) process are you struggling with?

BFN,

fp.
0
 
itjockey79Author Commented:
I am talking about whole part.whole process is lengthy but it is simple.i need vba code which runs on click of macro button.

Thanks
0
 
redmondbCommented:
Hi, itjockey79.

Thanks for the request, but I regret that I will not be able to get involved with this question.

Regards,
Brian.
0
Technology Partners: 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!

 
itjockey79Author Commented:
Ok next time thanks
0
 
itjockey79Author Commented:
Mr.funpages,
Can you code mention procedure?
0
 
RyanProject Engineer, ElectricalCommented:
You're going to need to write a lot of this code before we're going to be able to help you with this.  Your flow diagram is not enough.  I would expect if you hired a programmer locally, and  sat down with them, it would take a few hours to complete. For that reason it's not reasonable to get this completed via this site.
0
 
itjockey79Author Commented:
If you need lot of writing on this I will with proper explanation.it is to easy in nature but lengthy.but pls be with me.

Did you read steps in sheet calculation?
in that which part I.e. Step you don't understand?

Thanks
0
 
RyanProject Engineer, ElectricalCommented:
So you're asking for a macro to do the steps listed in Calculation!D93:D107?

Even still, there's a lot of steps there.  I have no idea what any of the parts of Step3 means.

You're still asking for us, volunteers, to do your project. This site is designed to answer questions related to single tasks, like, "How do I select a sheet if it exists, or copy one if it doesn't?" (Step 1.1 for you)
0
 
[ fanpages ]IT Services ConsultantCommented:
Mr.funpages,
Can you code mention procedure?

I think the consensus of opinion here is that there is a lot of work for a single question.  It may seem like a simple task to you, but for those of us not familiar with the subject matter opening your document without any further explanation is overwhelming.

I would suggest that you request closure of this question, & then create a few additional questions that address specific aspects of your requirements; for example, the first 5 steps as the first question, steps 6 to 10 for the second, & so on.

Personally, I have never liked reading specifications from flowcharts, so unless there is a specific task that requires attention I will be leaving the work for other "Experts" that may have more free time available.

Good luck with your project.
0
 
itjockey79Author Commented:
Give me some time I LL prepare .doc file which contain more screen shot and less reading.even after you guys find difficult to understand then I LL go for deletion. As all calculation part is done.Just need to code it.finger cross hope for best.

Thank You
0
 
itjockey79Author Commented:
ok I had prepared one doc file. mostly screen shot.
that is up till step 6. I had change excel sheet to it may reduce confusion & better result.


Thanks
Naresh
Process.docx
Z-Score.xlsm
0
 
itjockey79Author Commented:
Thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 7
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now