formulaic | performance implementation of Wilkinson formulas | Machine Learning library

I am applying a while loop, but the loop does not stop. Also, the serialmonitor stops writing values. Why is that? Also the stop command is not working. Below is my code

This may be impossible, but I am trying to create a baseball fielding lineup generator that has a few constraints provided by the league (ie. must play twice in infield, twice in outfield, no repeats at any position). I think this would be fairly simple task using any programming language, but I am designing this for my 70yo uncle and he can basically only use excel with no macros. So I can't brute force my way through the problem and I don't think I understand the mathematics behind the problem well enough to even know if there is a excel formulaic solution.

At it's essence it's a Sudoku creator and solver with no repeats in the rows or columns. I have an ok solution for the infield/outfield part via ranking the individuals by position.

Recursively calculating with F9 is ok for the solution since this is just a change in the options menu, but the last time I sent him a macro his university MS account wouldn't let him run it or change the settings.

Well, I have plenty of other info and have gotten close to solutions using huge nested IFs, but this relatively brute force method seems to be pretty dumb and is not giving great solutions.

Thanks for any help!

A Google Sheet has multi-line information in its cells, e.g. address.

Each address can have a different number of lines, but we know:
1st line is always the name
Penultimate line is always the post code and city
Last line is always the country

And we are trying to split the address into 4 columns:
Name
Street address (i.e. the address left over after extracting name, post code & city, country)
Post code and city
Country
So col B (name) reads first line =REGEXEXTRACT(A1,”(\w.*)”)

Of course, I can figure out how many lines there are in each cell by counting next line character
=LEN(A1)-LEN(SUBSTITUTE(A1,CHAR(10),””))
If the formula returns 6, then there are 7 lines
How do we get columns C (street address), D (postcode and city) and E (country) formulaically?

I mean, sure, I can get country for this cell with
=REGEXEXTRACT(A2,”(\n.*){6}”) but I can’t copy the formula over….the 6 above is manual input, which defeats the purpose. Since this is regex, it obviously can’t take cell references instead of 6, e.g.

=REGEXEXTRACT(Amazon!B4,”(\n.*){F1}”)
(if for example, I stored in column F the number of next line characters in column A)

I had a similar question to the poster here and tried using the formula provided: Split cell on delimiter using formulas

In my case, I have a spreadsheet with large text strings containing up to 50 distinct values per cell, delimited by "|". The format is "Product Category 1 > Product 1 | Product Category 2 > Product 2 | ..." etc.

If possible, I'd like to figure out how to extract values into a column formulaically.

The formula "=TRIM(MID(SUBSTITUTE($A$1,"|",REPT(" ",999)),(ROW(1:1)-1)*999+1,999))" (A1 contains the string) + drag & fill seemed to work perfectly, until I attempted to use it on a larger string which gives me a #VALUE! error. Through some experimentation I discovered that the formula will only error out if the string contains greater than 999 total characters.

I don't quite understand how ROW(1:1)*999+1 works as a positional indicator for the MID function, but it does seem to work up to a point. Raising the 999 threshold doesn't seem to make any difference. I've tried every possible combination of increasing the 999 values up to 2000 without success.

I thought the issue might be a hard character limit using the MID or SUBSTITUTE functions but I haven't had any luck finding info to back that up. If any of you brilliant folks wouldn't mind explaining to me what I'm missing, or if you have a more elegant solution for me, I would be much obliged.

Edit: Following @Euler's Disgraced Stepchild 's suggestion, a similar error occurs with >2 delimiters in the cell reference.

Thank you, Patrick

I have the following row in a spreadsheet of daily figures.

I would like to add another row that would create estimates to fill in the gaps (which don't appear in a regular fashion, and can be more than one in width) so that I would be left with:

So the values added to the gaps follow a linear progression from the figure to the left, to the figure to the right (more or less - I'm not too bothered about rounding).

I could do this in a macro, but I'd love to find a formulaic way of doing it.

Thanks

Ok, what am I missing here...

I'm trying to get an image tag to start with the 250px wide "small" image, and then have the browser choose the most appropriate image based on the srcset & sizes attributes - so, you know, "normal".

What is happening

The src is the only thing used. Be it set to superawesomeimagename 250.jpg or superawesomeimagename 1000.jpg - it doesn't change/load a different image.

The HTML Tag itself

I'm tracking the percentage of different stocks in column 3 and I want them to be automatically sorted by descending order every time the data is updated. The data in column 3 is formulaic. They are not text. How can I write this script?

Spreadsheet Here

I using MVVM light library in my project. I trying to add an array to the constructor of the ViewModel.

For example... if the code below is

I created the editor inheriting the TextBox.

The editor loads the data from the file like below.