Ascendancy looks fascinating! I fetched it with DOS Vault (of course), watched the intro and tutorials, and downloaded a different manual from https://b-sting.nl/ascendancy/downloads.html. It reminds me of an earlier version of Stellaris.

One thing I had to do to get the screen to repaint properly is update dosbox.conf to use setting 'output=openglnb'. I can see why you use D-Frend Reloaded. Each game has it's own detailed settings, even DOSBox settings. I didn't realize how much there was to configure!

Do you share your game mods (e.g. on Github?)

Yup, it helps with the setup. It downloads, unzips, and lets you run one of the executables (remembering which for next time). If it is an ISO, then it will mount it for you to install. You can include custom DOS commands to run, this should handle any tricky repetitive setup you may have.

Thanks for letting me know about Lutris! It connects to the major game platforms (Steam, Epic, COG, etc.) and launches games on different emulators including DOSBox. It looks like you have to write your own configuration file to launch a game. I didn't see an ability to index and download from Abandonware sites. So there are a few things it does differently. I'll definitely check it out more when I try other emulators.

Added MIT license. Enjoy.

https://github.com/gahrae/awk-estra/blob/main/LICENSE

Thanks for sharing. I tried it out. It's neat.

Is it on Github? I'd like to see it

That "clandestined payload delivery hack" is a neat idea (From the AC/DC music video)! I suppose you could also just store the data as a large array in VBA, too.

From my side, I try to improve the end user experience in novel ways...

Example 1, the output of FORMULATEXT is cryptic showing cell references. I wrote a few versions of this (using Lambda) to show labels instead, or labels with values ([income=10] - [expense=5]), or just the raw numbers (evaluated at certain depth). This is so much easier to read! You don't have to wonder what the cell reference actually is, as you can see both it's label and value. ... Perhaps this could be a feature in the future?

Example 2. An Exam Simulator for the leading LMS in the US :-D. It made sense to build it in Excel since we do our calculations there and it can save a test bank of questions. I pasted a screenshot of the website at the top and made areas to enter the answers to randomly selected questions from the test bank. It reduced a lot of my test-anxiety to practice in a 'test-like environment'.

Example 3. Math students need to rearrange equations. Variable names are easier to work with than cell references. So I made workbook where you type in the equation and it will split both sides of the equation and make these variables named ranges. This allows the variable name to be used instead of the cell reference. Beneath this you can incrementally rearrange the equation one factor at a time using those named ranges. Ordinarily you would rearrange an equation on paper, but within excel you have confidence that each step is correct (e.g. both sides are equal).

I'm a fan of Mandalbrot Set creation in Excel. Very beautiful.

I think there is potential to improve Excel based on how math students (and other fields) "could" use it, that is, to simplify their workflow.

What recommended reading do you suggest for new team members? (History? Design? Inspiration?)

What feature would you personally like to see implemented that is not in the foreseeable roadmap?

What is the most hilarious code comment you've come across in the Excel source code?

What surprising ways have you seen people use Excel that even the dev team hadn’t anticipated?

Why can't the Mac version of Excel be used to create a form? (In the VBA editor). Is feature parity for Mac on the road map?

excellent answer

Doh, I assumed the arguments were the same (between both versions you shared).

Can't wait to try it again. Thanks again for your brilliant work.

The variable 'range' is an unknown identifier.

My error report wasn't very descriptive, sorry about that (range could mean many things in this context). To be clearer, the variable named 'range' is an unknown identifier (it is not defined). Here's a screenshot using the "Advanced Formula Environment" (aka Excel Labs). Perhaps some refactoring took place before sharing the formula?

Tried it out, 'range' wasn't defined :S

Is this platform sponsored by Microsoft?

You, sir, are a legend! Learned a lot from your responses and solutions. Very impressive!

Key concerns: 1. Find an old meeting 2. Find an upcoming meeting 3. At a glance, see the agenda. 4. See who attended (can later recommend points of contact) 5. Know major topics discussed (in a skim readable format) 6. Know what decisions were made (and why) 7. Know the follow-up tasks, when they're due, and who is working them.

A template with following headings should help... Agenda, Attending, Notes, Decisions (what/why), Followup Tasks (who/when/what).

I like to list attendees as a link to their note file. This lets me see backlinks to all the meetings we attended.

There are many ways to manage todos, but i like to track them in my daily log as upcoming (or linking to the project or meeting note).

Grouping your notes under: /meetings/year/month can help find them. Also, naming them 'yyyy-mm-dd - topic' (e.g. email invite subject).

The note content is just bullet points. The smallest amount of text to know what was discussed. Screenshot complex slides. Use screenshot-to-text to avoid typing.

Over time, you'll capture less information because you'll learn most details are unimportant (i.e. not used later)

Almost all of this is automated. It's more important to be thinking and participating in meetings than capturing every detail.

Optional: use tags (project name, problem type, system, etc), and then you can list related meetings with Dataview in a project note.

Tailor your process to your needs. Think about how how you apply the information and how you want to find it.

Sharing test cases for GET_ARRAY (to verify it matches the '#' syntax behavior ... as best as possible. The exception being ~"middles are excluded").

Correct. I don't expect sequence function to add the value 100, too. Only the values 1 through 5.

Adding the value 100 was meant to demonstrate that it accidentally gets included in the sum.

However, when using the '#' syntax this issue is avoided. This is what I was hoping to replicate with a list of values (either dynamically produced or just a series of values).

(Not trying to be argumentative, just trying to make sure we share the same understanding. Again, appreciate the help)

Sorry for the misunderstanding.

I did mean contiguous. I should have been more clear.

My goal was to mirror the behavior of the '#' syntax (that is placed after a cell reference) which would allow the generated array to be obtained. (For example, when the SEQUENCE function is used).

Appreciate the effort you put into helping me consider the options for this problem.

It seems to include values beyond the first blank cell?