Number Fill Generat...
 

Number Fill Generator - Spreadsheet. Improve ? for the Excel/Google Sheets Gods

4 Posts
4 Users
2 Reactions
152 Views
Posts: 8482
Free Member
Topic starter
 

This could be improved massively.

My Mum loves doig these number crossword things, suffering a bit with a bit memory loss etc.

So made this spreadsheet to generate some number fill on the fly.

https://docs.google.com/spreadsheets/d/1BaPh7aAudYLBa5VceixdPnnnlYEkToqnqlqMuKUz_kw/edit?usp=sharing

Its horrible, using Concatenate and Radom numbers etc.

Any suggestions how I could generate a random grid like above and generate the numbers on the side.

Any thoughts, if your bored in your lunch break 🙂

Thanks.

 
Posted : 29/07/2024 12:24 pm
Posts: 8482
Free Member
Topic starter
 

Anyone?

 
Posted : 29/07/2024 10:58 pm
Posts: 7039
Free Member
 

I would be tempted to do it all in JavaScript.

 
Posted : 29/07/2024 11:22 pm
Posts: 8552
Full Member
 

I'd ask Co-pilot or ChatGPT if they could do it for me

 
Posted : 30/07/2024 7:03 am
Posts: 3109
Free Member
 

MMMmmm - interesting.

There's an error in cell R4 - references H3  twice.

There are Excel Sudoku solvers out there - maybe that would give you some ideas ?

https://www.microsoft.com/en-us/microsoft-365/blog/2008/09/30/building-a-basic-understandable-sudoku-solver-using-excel-iterative-calculation-part-12/

 
Posted : 30/07/2024 7:09 am