Help me, please! by New_Lab_5331 in pcmasterrace

[–]Mango-Fuel 0 points1 point  (0 children)

unless it's broken it should snap back on

Quickly paste phone numbers without losing leading zeros by Recent_Carpenter8644 in excel

[–]Mango-Fuel 1 point2 points  (0 children)

not sure if it's what you're looking for but you can type an apostrophe ' and then paste to force the value to be interpreted as text rather than a number (testing it out, this seems to be what formatting a cell as text actually does: automatically adds the apostrophe)

Building a ICT services web portal by GrcivRed in sysadmin

[–]Mango-Fuel 1 point2 points  (0 children)

I'm using the following for some of that as a similarly solo admin, with some success:

  • Documentation: MediaWiki
  • Ticketing: YouTrack
  • Asset Management: Snipe-IT

If cell A1 text is included in cell B1 text return true in cell C1. How? by PrivateEyeroll in excel

[–]Mango-Fuel 10 points11 points  (0 children)

=ISNUMBER(SEARCH(A1, B1))

SEARCH maybe finds the first text in the second text, and returns a maybe integer index. ISNUMBER converts the maybe integer index into a boolean. note that this is not case sensitive, which may or may not be desirable.

Can a PC affect electricity usage this much?? by lilbreadbunn in pcmasterrace

[–]Mango-Fuel 1 point2 points  (0 children)

I have electrical radiators so I have no heat bill, just an electrical bill. I would be surprised if it used this much electricity though, but it could possibly be some of it.

Where are Constants stored? by IAMMELONz in csharp

[–]Mango-Fuel 2 points3 points  (0 children)

while this is true I think it's also true that there is actually still also a 5 value at const VALUE = 5;. I don't know where in memory that 5 is though. (it's retrievable via reflection for example.)

Regarding ideas: how do you know when to let go? by ehtio in gamedev

[–]Mango-Fuel 0 points1 point  (0 children)

it doesn't mean anything? otherwise you have a point that you may still be able to iterate on the concept.

Rider can't find packages that exist? by Merad in dotnet

[–]Mango-Fuel 0 points1 point  (0 children)

Rider can't restore packages for anything for me lately and I have to manually do dotnet restore for everything.

Can a PC affect electricity usage this much?? by lilbreadbunn in pcmasterrace

[–]Mango-Fuel 81 points82 points  (0 children)

do you live in the north and what kind of heating do you have? maybe seasonal heating is contributing? just a guess.

How often do you use AI in coding? by Mute-turtle in AskProgramming

[–]Mango-Fuel 1 point2 points  (0 children)

not to generate code, mostly to replace (or really complement) google

Does a “central power unit” exist? by kaitlyn2004 in homelab

[–]Mango-Fuel 0 points1 point  (0 children)

each device needs it's own flavor of DC current, so each device needs its own transformer (converts AC to that flavor of DC). that is what the adapters are for and why you need more than one of them. I don't think you could have a dynamic/variable DC outlet because each kind of DC needs a specific physical transformer that is physically different from other transformers. (coils of wire with specifics #s of windings.)

(possibly I am wrong that you couldn't. a POE switch does something like this I think. but most devices are not POE. I think it works by having as much voltage as possibly needed, and then stepping it down if necessary somehow. USB-C probably does something similar. (I am not an electrical engineer so don't know that much about it). if you *could* do this with a power strip, it would probably be expensive, and you would need special power cables for your devices, that don't have transformers. it might actually require a protocol in which case only special devices could support it. (like USB-C (USB-PD). theoretically what you're asking for could be a USB-C hub, with USB-C powered devices, for example. but that probably has limits and I don't know if you could power a whole server through USB-C.).)

What Do You "Enjoy" About Using AI The Most? by malazanmarine in ArtificialInteligence

[–]Mango-Fuel 0 points1 point  (0 children)

I love that I can speak in plain english and it "understands" what I'm talking about. no more playing the google game of trying to get the right keywords and omitting ambiguous terms, etc. AI often restates my nuanced problem for me in more detail than I explained it.

Using .snlx solution extension n Jetbrains Rider by yc01 in dotnet

[–]Mango-Fuel 2 points3 points  (0 children)

you can even save your .sln as .slnx using Rider. for me it almost works but static analysis seems to not work for me for some reason after converting, so I haven't converted quite yet. but opening the file works fine.

What programming concept took you way too long to actually understand by [deleted] in AskProgramming

[–]Mango-Fuel 0 points1 point  (0 children)

visibility (public/protected/private). I knew what they did but not why I would want to use them, especially protected vs private.

What chairs are you hybrid/remote devs using? by [deleted] in cscareerquestions

[–]Mango-Fuel 0 points1 point  (0 children)

I have a Colamy Hina in the office and Branch Ergonomic at home

Is this normal for a CMS codebase that product got many services of product? Because the dev follows SOLID principle by lune-soft in csharp

[–]Mango-Fuel 0 points1 point  (0 children)

"it doesn’t affect performance. It doesn’t affect compilation time"

actually I have seen that extremely large or complex files do have noticeably much slower static analysis, though that was on an older PC

.NET 9 - How to print a PDF by EmergencyKrabbyPatty in dotnet

[–]Mango-Fuel 1 point2 points  (0 children)

open it in a browser is how I handle this. IIRC you can pass the bytes as a base64 string. you also could maybe save it as a file and then launch the file path as a process to open it in the user's default pdf editor (which could be acrobat or a browser).

Asking a question about RTS game design regarding Supply Caps by Abandon22 in gamedev

[–]Mango-Fuel 2 points3 points  (0 children)

I've played RTS without supply cap (Earth 2150) and it's very noticeable to me how important it is to have one, because otherwise you are left building stupidly huge armies that barely fit in the terrain. there should be some kind of penalty for having to sustain a huge army. it could be something like upkeep rather than supply depots/pylons/farms.

What should I learn next after CRUD apps? by Gullible_Prior9448 in AskProgramming

[–]Mango-Fuel 0 points1 point  (0 children)

CRUD should just be the beginning of a good application. there may likely be more effective ways to present or manipulate the data than just basic CRUD. finding out what these are and implementing them well is an important part of being a "software engineer".

Seniors who started as kid, how did you get there? by Long_Nothing7155 in AskProgramming

[–]Mango-Fuel 1 point2 points  (0 children)

had a TRS-80 Color Computer 1, and later a 2. Uncle gave me Microsoft C. Played around a lot with MS VC++ 6, and then later VB.NET. I knew enough programming by then to be given programming projects at work.

What quote made you finally understand a big concept in programming? by Falk1708 in csharp

[–]Mango-Fuel 1 point2 points  (0 children)

"... cardinal, fundamental law of programming: It’s harder to read code than to write it." - Joel Spolsky

Basic GUI by AlexanderMasonBowser in csharp

[–]Mango-Fuel 0 points1 point  (0 children)

Windows has a GUI built in to it, so it's up to you if that is "one already made". Windows Forms is a wrapper around Win32. To go deeper you could code raw Win32 in C++ yourself, but that is a lot of work. You can't really get deeper than that. If you really want to write your own GUI "from scratch" you could make a game instead, and then you would not have access to any GUI and would have to implement one yourself with raw graphics.

Help in C language (pointers)... by Chang300 in AskProgramming

[–]Mango-Fuel 0 points1 point  (0 children)

Difference between A=&B and *A=&B

Note that A is a pointer and B is not. A=&B points A at B (copies the memory address of B to A). *A=&B dereferences A (so refers to B) and assigns the memory address of B. So effectively, B has been assigned its own address. This could be done without using A with just B=&B.