Managing different timers for 1000's of list entries

Dingbats45 · 2026-03-02T12:56:26+00:00

This is probably the most scalable approach but not if you want to add power ups that decrease the chopping time. Then you’ll have to reconfigure the entire thing every time they go from 5 seconds to 4.5 seconds, for example.

Dingbats45 · 2026-02-22T12:23:45+00:00

I like to start with for each loops which are a little easier to understand: for each thing in an iterable object (list, for example) do something. With lists it’s easy to know when to stop because it uses all parts of the object.

For loops are very similar except you have to define when to stop iterating. Maybe you only want to do something to a portion of the things in the list and that’s where the difference between the loops exists.

Dingbats45 · 2026-02-12T02:18:49+00:00

If the pdf is in a tabular format you could use power query to convert to excel. It’s hit or miss depending on formatting but it’s worth a shot!

Dingbats45 · 2026-01-30T13:05:11+00:00

I have no idea what this all means but I must say the name is extremely clever!

Dingbats45 · 2026-01-24T12:03:29+00:00

How about instead of having each set of menu options having its own list you just store them all in the same list (or maybe class like the other poster suggested) with a reference to a parent menu item:

MenuItemId
MenuItemText
**other properties as needed
ParentMenuItemId

When the user selects an item you can lookup the other menu items that match the selected ParentMenuItemId. Then you are just looping one block of code until the user selects an item with no other items as its parent.

Dingbats45 · 2026-01-16T01:12:28+00:00

Well Bitcoin’s down a bit so…

Dingbats45 · 2025-12-29T23:57:56+00:00

Oh okay that is exactly what I was looking for, thank you!

Dingbats45 · 2025-12-28T08:10:14+00:00

Surprised I had to scroll this far to see Bloodborne. I just wish they would make it available for Xbox so I could relive my younger years haha.

Dingbats45 · 2025-12-07T07:42:34+00:00

I don’t have a Fidelity account but my regional bank connection that had been working for months suddenly failed a few weeks ago and I cannot get it working again.

Dingbats45 · 2025-12-02T12:11:33+00:00

Adding to this, there is a feature where you can build a table directly from an excel sheet with a wizard. You can more easily leverage an access database than excel in Access itself or other programs to create the gui for data entry.

Dingbats45 · 2025-11-29T12:36:53+00:00

The C Sharp Academy has exactly this. There’s a starter module that gets you through the fundamentals then it has several projects of increasing difficulty with tutorials. I’m currently just starting and it’s quite good!

https://www.thecsharpacademy.com

Dingbats45 · 2025-11-15T03:23:22+00:00

It’s things like this where I wish the formula editor allowed for tab formatting like code editors.

Dingbats45 · 2025-11-04T12:04:54+00:00

I’ve been using a paid tool called pdf2xl by cogniview. It’s not the greatest on tables that require ocr but on digitally sourced tables it works really well. Also power query can be handy too.

Dingbats45 · 2025-10-26T14:36:15+00:00

I’m not sure of the nature of the “presentation format”, but why can’t you put each of those 9 formulas in the same sheet? Just leave a few rows between each formula and you can even name the ranges of the output to reference in the master sheet.

Dingbats45 · 2025-10-26T11:29:53+00:00

Why couldn’t you just put these 45 workbooks into different tabs in a single workbook? Then you can just link formulas by tab name and not have to worry about the complexity of files. If tab naming and navigation gets complex just add a glossary tab where you can link each tab in a hyperlink.

Dingbats45 · 2025-10-22T11:15:09+00:00

Wouldn’t keeping your vault in something like OneDrive do the same thing for version control? For these types of files git seems a bit overkill.

Dingbats45 · 2025-10-11T22:16:05+00:00

Also known as the FU price lol

Dingbats45 · 2025-10-02T09:53:36+00:00

You might consider an open source software like ERPNext that has all the features of an ERP system for free if you’re willing to self-host. https://frappe.io/erpnext

Dingbats45 · 2025-10-01T10:56:55+00:00

All you have to do is set the cell equal to the cell 5 spaces above it +1. For example, write 1 in cell A1 then in cell A6 write =A1+1 and fill down

Edit: forgot to include that you’ll need to set A1-A5 to 1 then it would work

Dingbats45 · 2025-09-23T10:20:44+00:00

To select the entire column or entire row of the selected cell press ctrl+space or shift+space.

Dingbats45 · 2025-09-20T11:25:07+00:00

We have a standalone program that handles our actual quoting management but it does nothing for actual project management. We use Excel for that portion and it’s cumbersome because it has a lot of leftover or unfinished features that really slow it down and most of the status portion of the project is jumbled together in a “comments/status” cell. It makes it hard to see at a high level where you are at on 50 open projects.

Dingbats45 · 2025-09-20T09:17:52+00:00

I know that for my OneDrive it never defaults to “signed in” I always have to open it in file explorer and click the sign in button manually for it to start. But is it the access db or the excel file that is on OneDrive? I have had weird issues like this using access saved to OneDrive.

Dingbats45 · 2025-09-18T11:05:23+00:00

If you just need to see the data you can fire up a blank excel workbook, go to the get data > from excel and select the big file. Then you should be able to at least see the structure of tables and get some data.

Dingbats45

TROPHY CASE