The Bishop
Labour
Down With Factionalism!
Posts: 36,720
|
Post by The Bishop on Jul 3, 2023 10:24:40 GMT
|
|
|
Post by jamesdoyle on Jul 4, 2023 6:40:49 GMT
No, I realised a couple of weeks back that fixing the Scottish elections issue had introduced a different problem, and because of my play I haven't had a chance to fix it. Working on it this week.
|
|
|
Post by jamesdoyle on Jul 4, 2023 11:30:48 GMT
After two hours of beating my head against a wall trying to figure out what had gone wrong, it all comes down to two text fields which apparently had the same text, but one had a trailing space. So the formula saw them as not equal. Bloody buggering hell. Now to update the spreadsheet with the last couple of weeks of by elections, and then I can give you some results.
|
|
J.G.Harston
Lib Dem
Leave-voting Brexit-supporting Liberal Democrat
Posts: 13,686
|
Post by J.G.Harston on Jul 4, 2023 11:34:34 GMT
After two hours of beating my head against a wall trying to figure out what had gone wrong, it all comes down to two text fields which apparently had the same text, but one had a trailing space. So the formula saw them as not equal. Bloody buggering hell. Now to update the spreadsheet with the last couple of weeks of by elections, and then I can give you some results. This sort of thing is so pervasive that in my processing I put a FNstripspc() function around all imported data to remove leading and trailing spaces.
|
|
|
Post by jamesdoyle on Jul 4, 2023 11:36:21 GMT
After two hours of beating my head against a wall trying to figure out what had gone wrong, it all comes down to two text fields which apparently had the same text, but one had a trailing space. So the formula saw them as not equal. Bloody buggering hell. Now to update the spreadsheet with the last couple of weeks of by elections, and then I can give you some results. This sort of thing is so pervasive that in my processing I put a FNstripspc() function around all imported data to remove leading and trailing spaces. Yes indeed. It's just been a long - very long time - since I did this sort of thing every day. Lesson hopefully (re)learned!
|
|
|
Post by jamesdoyle on Jul 4, 2023 12:51:08 GMT
GWBWI
Lab +307 Grn -10 LDm -19 Con -93
Note: West Lancashire not included, as it's a new ward
|
|