Link to home
Avatar of Dier02
Dier02Flag for Australia

asked on

issue with code

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
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Why don't you explain what you are doing and your precise problem rather than expecting us to figure it all out?
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
looks like your formula are pointing to the wrong cells, see attached, I think that I have corrected them;


ee-spelling-marker-03.xls
Avatar of Dier02

ASKER

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?
Avatar of Dier02

ASKER

In other words it saw the scr and 1 only once and saw the second entry as an error?
Avatar of Dier02

ASKER

'trapped' should be four points and it is coming up three as well.  I can;t see why.
My fault, got the second formula wrong!
ee-spelling-marker-03.xls
trapped looks OK now too in the above file
Avatar of Dier02

ASKER

Looking good. Confidence should be 5 but is showing 4???
Avatar of Dier02

ASKER

E9 for confidence should show i as position 5 (my bad)
ASKER CERTIFIED SOLUTION
Avatar of Runrigger
Runrigger
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Dier02

ASKER

You are correct!
Avatar of Dier02

ASKER

I also just worked out that I needed to click save to see the changes!
Avatar of Dier02

ASKER

Great work.  Thank you!
You are welcome, and thank you for the grading.