Solved

issue with code

Posted on 2011-02-16
15
183 Views
Last Modified: 2012-05-11
I ma having a problem with the word scrape because the position 1 comes up twice.  This will make no sense without the attached file.  Look at the word and the logic of assigning points to word parts.  The issue is that the 'scr' part of the word is assigned two points because it comes up under two headings but the code sees this as an error.
spelling-marker-03.xls
0
Comment
Question by:Dier02
15 Comments
 
LVL 24

Expert Comment

by:StephenJR
ID: 34905913
Why don't you explain what you are doing and your precise problem rather than expecting us to figure it all out?
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34905938
Dier02,

>The issue is that the 'scr' part of the word is assigned two points because it comes up under two headings but the code sees this as an error.

It doesn't show up as an error when I looked at it a minute ago. Can't see a problem with it. However I'm not at all sure why scr merits two lots of points instead of only one set of points.

Patrick
0
 
LVL 11

Expert Comment

by:Runrigger
ID: 34905986
looks like your formula are pointing to the wrong cells, see attached, I think that I have corrected them;


ee-spelling-marker-03.xls
0
 

Author Comment

by:Dier02
ID: 34906125
Runrigger - what about the word discovery - it has three points - one for the 'dis' one for the 'y' and one for the correct spelling but it is only showing 2 marks?
Patrick - its because it comes up under two headings so a point for each - but I think the problem was that the 'scr' occupied the 1st position so it wouldn't give a mark for each position - only one?
0
 

Author Comment

by:Dier02
ID: 34906133
In other words it saw the scr and 1 only once and saw the second entry as an error?
0
 

Author Comment

by:Dier02
ID: 34906142
'trapped' should be four points and it is coming up three as well.  I can;t see why.
0
 
LVL 11

Expert Comment

by:Runrigger
ID: 34906167
My fault, got the second formula wrong!
ee-spelling-marker-03.xls
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 11

Expert Comment

by:Runrigger
ID: 34906176
trapped looks OK now too in the above file
0
 

Author Comment

by:Dier02
ID: 34906195
Looking good. Confidence should be 5 but is showing 4???
0
 

Author Comment

by:Dier02
ID: 34906210
E9 for confidence should show i as position 5 (my bad)
0
 
LVL 11

Accepted Solution

by:
Runrigger earned 500 total points
ID: 34906220
I think that is due to the position value in column U being 1, it should be 5, same with resident, value in U should be 4!
0
 

Author Comment

by:Dier02
ID: 34906274
You are correct!
0
 

Author Comment

by:Dier02
ID: 34906294
I also just worked out that I needed to click save to see the changes!
0
 

Author Closing Comment

by:Dier02
ID: 34906300
Great work.  Thank you!
0
 
LVL 11

Expert Comment

by:Runrigger
ID: 34906353
You are welcome, and thank you for the grading.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now