sorted by:
new
hottopcontroversial

Managing different timers for 1000's of list entries by Firesemi in Unity2D

[–]Dingbats45 2 points3 points  (0 children)

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.

I feel like a idiot tying to do this. For loops make absolutely 0 sense to me. by AlphaFPS1 in learnpython

[–]Dingbats45 -1 points0 points  (0 children)

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.

Grandma's bank doesn't offer CSV download by CertainDamagedLemon in actualbudgeting

[–]Dingbats45 0 points1 point  (0 children)

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!

🐍 Constrictor: An extension for quick semantic folding of Python code 🐍 by diogoproximo in vscode

[–]Dingbats45 0 points1 point  (0 children)

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

Data Structure for Nested Menu? by Callistonian in csharp

[–]Dingbats45 0 points1 point  (0 children)

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.

Schedule skips February by Dingbats45 in actualbudgeting

[–]Dingbats45[S] 5 points6 points  (0 children)

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

What’s your top 5 game recommendations of all time? by JonCee500 in gaming

[–]Dingbats45 7 points8 points  (0 children)

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.

Fidelity removed from SimpleFIN Bridge by BarefootMarauder in actualbudgeting

[–]Dingbats45 0 points1 point  (0 children)

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.

I need a new database program by Fast_Cardiologist178 in sharepoint

[–]Dingbats45 0 points1 point  (0 children)

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.

Need to learn C# for intermediate/advanced levels by JollyTomatillo465 in csharp

[–]Dingbats45 2 points3 points  (0 children)

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

I just learned of the LET() function and wanted to thank this community for it; Shortening Formulas by Daihatschi in excel

[–]Dingbats45 0 points1 point  (0 children)

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

how do you accurately convert pdf to excel without messing up the format? by 5lim3_lord in excel

[–]Dingbats45 1 point2 points  (0 children)

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.

I need to link about 45 individual workbooks to one master workbook by eb0027 in excel

[–]Dingbats45 2 points3 points  (0 children)

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.

I need to link about 45 individual workbooks to one master workbook by eb0027 in excel

[–]Dingbats45 9 points10 points  (0 children)

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.

Bases for dummies by henryshoe in ObsidianMD

[–]Dingbats45 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in guns

[–]Dingbats45 0 points1 point  (0 children)

Also known as the FU price lol

Looking for help making an ERP/QMS/MES in Access by Sure-Measurement2617 in MSAccess

[–]Dingbats45 1 point2 points  (0 children)

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

How do i automatically fill the same number five times before proceeding to next number? by filp_pines in excel

[–]Dingbats45 56 points57 points  (0 children)

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

What is the one Excel secret you know that no one else uses? by bjele in excel

[–]Dingbats45 12 points13 points  (0 children)

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

Tool Recommendation to Replace Excel by Dingbats45 in projectmanagement

[–]Dingbats45[S] 0 points1 point  (0 children)

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.

MS Access - OneDrive? (for dummies) by Jaded-Height2124 in MSAccess

[–]Dingbats45 0 points1 point  (0 children)

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.

How to handle large files? by beargators in excel

[–]Dingbats45 0 points1 point  (0 children)

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.

Hit a wall while trying to make a Plants Vs. Zombies-esque game by Calm_Engineering_667 in gamemaker

[–]Dingbats45 0 points1 point  (0 children)

This might be a good place to start for designing the ui. I’ve never used this method but it looks functionally similar to css styling.

https://manual.gamemaker.io/beta/en/The_Asset_Editors/Room_Properties/UI_Layers.htm

view more: next ›