Number Fill Generat...
 

Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop

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

4 Posts
4 Users
2 Reactions
195 Views
Posts: 8561
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: 8561
Free Member
Topic starter
 

Anyone?


 
Posted : 29/07/2024 10:58 pm
Posts: 7089
Full Member
 

I would be tempted to do it all in JavaScript.


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

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


 
Posted : 30/07/2024 7:03 am
Posts: 3150
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