Solved

issue with code

Posted on 2011-02-16
15
185 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
ScreenConnect 6.0 Free Trial

At ScreenConnect, partner feedback doesn't fall on deaf ears. We collected partner suggestions off of their virtual wish list and transformed them into one game-changing release: ScreenConnect 6.0. Explore all of the extras and enhancements for yourself!

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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.

778 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