Thread Rules 1. This is not a "do my homework for me" thread. If you have specific questions, ask, but don't post an assignment or homework problem and expect an exact solution. 2. No recruiting for your cockamamie projects (you won't replace facebook with 3 dudes you found on the internet and $20) 3. If you can't articulate why a language is bad, don't start slinging shit about it. Just remember that nothing is worse than making CSS IE6 compatible. 4. Use [code] tags to format code blocks.
Unfortunately I'm a total noob with excel but I think someone here might be able to help you.
My recent forays into Rust have been OK so far but I'm noticing some weird things when it comes to the language.
// if you have a method call and this method returns a result that can be error etc. // the compiler will complain that you have not handled it struct.call();
// if you don't care about the result at the time of calling (don't want to handle errors // at this stage) and you don't want the compiler to complain you have to do stuff // like that let _ = struct.call();
On December 03 2020 16:15 JumboJohnson wrote: Idk if this is really the spot for it but I don't want to make a new thread and my google-fu is failing me.
I have an excel spreadsheet that I use to track my debt. I have it set up to add the column up and when I add a month I can just drag the cell over and it puts the sum equation under the new column.
What I want to do is put a cell under that takes the sum above and subtracts it from the cell to its left. The equation is obviously easy enough but I can't just drag it over like I do with the sum when I add a new month. What am I missing?
Thanks for any help and sorry it's not a more interesting problem like you all normally discuss :D
I am not sure o understand. Can You post equation You are using? I suspect You have problem with fact that when You copy formulas the range of the sum stays fixed. So if You have in one cell a formula that sums for example five cells and then copy it to next cell it still will still sum five cells (but diffrent as adresses will change but not range). Am i getting this right? Or this is something else?
On December 03 2020 17:24 Manit0u wrote: Unfortunately I'm a total noob with excel but I think someone here might be able to help you.
My recent forays into Rust have been OK so far but I'm noticing some weird things when it comes to the language.
// if you have a method call and this method returns a result that can be error etc. // the compiler will complain that you have not handled it struct.call();
// if you don't care about the result at the time of calling (don't want to handle errors // at this stage) and you don't want the compiler to complain you have to do stuff // like that let _ = struct.call();
Ugly as hell...
I have no idea what is there to complain about that. I really wish our C++ code at work had this. (And adding [[nodiscard]] to all success values in the code base is sadly not possible.)
On December 03 2020 17:24 Manit0u wrote: Unfortunately I'm a total noob with excel but I think someone here might be able to help you.
My recent forays into Rust have been OK so far but I'm noticing some weird things when it comes to the language.
// if you have a method call and this method returns a result that can be error etc. // the compiler will complain that you have not handled it struct.call();
// if you don't care about the result at the time of calling (don't want to handle errors // at this stage) and you don't want the compiler to complain you have to do stuff // like that let _ = struct.call();
Ugly as hell...
I have no idea what is there to complain about that. I really wish our C++ code at work had this. (And adding [[nodiscard]] to all success values in the code base is sadly not possible.)
I guess my example wasn't clear enough
Imagine having to do that:
let _ = st.set_id(1); let _ = st.set_name("my obj");
// I wan't to just call the setters and validate at the end...
On December 03 2020 16:15 JumboJohnson wrote: Idk if this is really the spot for it but I don't want to make a new thread and my google-fu is failing me.
I have an excel spreadsheet that I use to track my debt. I have it set up to add the column up and when I add a month I can just drag the cell over and it puts the sum equation under the new column.
What I want to do is put a cell under that takes the sum above and subtracts it from the cell to its left. The equation is obviously easy enough but I can't just drag it over like I do with the sum when I add a new month. What am I missing?
Thanks for any help and sorry it's not a more interesting problem like you all normally discuss :D
I am not sure o understand. Can You post equation You are using? I suspect You have problem with fact that when You copy formulas the range of the sum stays fixed. So if You have in one cell a formula that sums for example five cells and then copy it to next cell it still will still sum five cells (but diffrent as adresses will change but not range). Am i getting this right? Or this is something else?
I think you've got it. Here's a better description. In column H for example I'd put =G12-H12 and I'd get the number I'm looking for. I just can't get the equation to drag over into column I or G and change the inputs. It just keeps the original numbers.
On December 03 2020 16:15 JumboJohnson wrote: Idk if this is really the spot for it but I don't want to make a new thread and my google-fu is failing me.
I have an excel spreadsheet that I use to track my debt. I have it set up to add the column up and when I add a month I can just drag the cell over and it puts the sum equation under the new column.
What I want to do is put a cell under that takes the sum above and subtracts it from the cell to its left. The equation is obviously easy enough but I can't just drag it over like I do with the sum when I add a new month. What am I missing?
Thanks for any help and sorry it's not a more interesting problem like you all normally discuss :D
I am not sure o understand. Can You post equation You are using? I suspect You have problem with fact that when You copy formulas the range of the sum stays fixed. So if You have in one cell a formula that sums for example five cells and then copy it to next cell it still will still sum five cells (but diffrent as adresses will change but not range). Am i getting this right? Or this is something else?
I think you've got it. Here's a better description. In column H for example I'd put =G12-H12 and I'd get the number I'm looking for. I just can't get the equation to drag over into column I or G and change the inputs. It just keeps the original numbers.
Without being able to look at it, it sounds like you're using fixed references to cells ie $G$12 etc. instead of relative ones.
On December 14 2020 17:33 enigmaticcam wrote: For anyone who likes this kind of thing, adventofcode.com is up for 2020. Finally completed all available problems today.
On December 14 2020 17:33 enigmaticcam wrote: For anyone who likes this kind of thing, adventofcode.com is up for 2020. Finally completed all available problems today.
return random_res(ary) if nums.uniq.count < 3 return nums end
def answer(ary) uniq_ary = ary.uniq
loop do res = random_res(uniq_ary)
return res.reduce() if res.sum == 2020 end end
puts answer(report)
LOL. i code about 100-200 hours a year in PHP. and i take year long breaks between coding sessions. so when i first get back at it i rely on the code editor complaining. when i'm working within some conditional multi-nested monstrosity i include a line in each branch that is a living tribute to Ayn Rand.
Code golf is a travesty in my eyes. It's like the evil twin brother of spaghetti code.
My solution wasn't funny because of brevity but because of algorithm (or lack thereof) used: it basically picks 3 non-duplicate numbers from an array at random and checks if they sum to 2020 until it finds a match
You can optimize it with memoization etc. but I'm lazy.
Code golf can definitely be dangerous to teach you the wrong habits. I think almost all code you write in your free time should be stuff you find interesting, but it should almost always be "proper" code. Otherwise it's like practicing your baseball swing incorrectly on purpose. You're just going to make it harder to do it properly.
Thats like saying motor sport teaches you to ignore traffic rules and sudoku makes you unable to handle numbers with more than one digit... You can safely assume every code golfer using those golf languages (or writing their own like that guy, who btw is also leading the current AoC, obv not with golfed solutions) knows the difference between proper code and golf and also considers golfing a completely different discipline.
Oh, I'm sure they're capable. What I'm saying is that they're getting rewarded for unclear, but short, solutions. This incentivizes them more and more to write terse, unclear solutions, and makes them much more familiar with that sort of code, meaning they'll use it in actuality more, making their code worse to work with.
On December 15 2020 23:18 WarSame wrote: Oh, I'm sure they're capable. What I'm saying is that they're getting rewarded for unclear, but short, solutions. This incentivizes them more and more to write terse, unclear solutions, and makes them much more familiar with that sort of code, meaning they'll use it in actuality more, making their code worse to work with.
This phenomenon can be a form of turf protecting that I've seen on several occasions.
Sometimes the employer and the coder are on very bad terms and this is the employee's way of submarine-ing the project.
The impossible to detect method of submarine-ing a project is to use some cutting edge unproven tech. Like say, .NET Core 1. If you suspect .NET Core 2 will be really solid this can be a path to higher pay and an abundance of work in the future.
On December 15 2020 23:18 WarSame wrote: Oh, I'm sure they're capable. What I'm saying is that they're getting rewarded for unclear, but short, solutions. This incentivizes them more and more to write terse, unclear solutions, and makes them much more familiar with that sort of code, meaning they'll use it in actuality more, making their code worse to work with.
This phenomenon can be a form of turf protecting that I've seen on several occasions.
Sometimes the employer and the coder are on very bad terms and this is the employee's way of submarine-ing the project.
The impossible to detect method of submarine-ing a project is to use some cutting edge unproven tech. Like say, .NET Core 1. If you suspect .NET Core 2 will be really solid this can be a path to higher pay and an abundance of work in the future.
Combined with your earlier messages, this sounds like first-hand experience
Anyway, just as I don't think Hamilton tries to stop people from passing while driving 200+ km/hour in British traffic, I don't think code golfers confuse their hobby with their job as coders.
Exactly what I was thinking, sounds a little to accurate to not be first-hand
I don't think they'd confuse it, but I would imagine pro drivers might mix in moves that are either street-illegal or dangerous on the street because their surrounding drivers have no idea what's going on.
On November 19 2020 21:33 Manit0u wrote: Lazy devs. Devs that think they're super clever when they're not and are trying super hard to create code that only smart people like them will understand. And devs that perhaps think that if they write unintelligible spaghetti code they will become indispensable and they'll be able to work on it for years on end. Beats me.
I call that 'turf protecting'. I prefer to constantly expand my turf so if i lose some of it.. who cares. Developers that do that crap have self confidence issues. If you are reliable, hard-working, know how to play the game of internal political BS while having only average talent ... there will always be a spot for you.
The more talented you are.. the more you can fuck around and get away with it.
On November 19 2020 21:00 WombaT wrote:
On November 19 2020 19:53 Manit0u wrote: The loops with exception control flow was a piece of software written in Java and used by national airlines...
I have some PHP horror stories too if you want
I've seen a 30k lines of code class being extended several times and each class that extended it had 15-30k lines of code and was itself extended by similarly large classes, each calling parent's constructor at different points in their own constructors.
I've had to reverse engineer 5k lines of code script written by non-programmer that was full of global variables that stored data in arrays that were being manipulated, reversed and overridden in multiple nested loops etc. etc.
Hey at least that gave you something to do.
How the fuck do such things happen haha?
I notice you are changing careers.. so this is an honest respectful question sir.. Have you ever worked in an IT department before? Do you know someone who has? i guess not?
Dude, most IT departments could start their own puppy farm with the amount of dog-fucking that goes on.
For about 30% of the year when I'm in hermit-coder-mode I produce a lot and I learn a lot. For a good portion of the other 70%... I'm just dicking around. Like right now.
Most of my close friends are software engineers, actually was them that thought it would suit my particular brain and got me pondering the option. Won’t go into the dear diary aspects of why I’m rather underemployed mind, depressing enough held in my brain never mind shared.
My ‘how the fuck?’ more springs from confusion and exasperation than any kind of surprise, although I usually reserve it for HR departments
i'm not sure how far along you are in becoming a software developer.. however.. you might find this guy on youtube informative..
if you are at a beginner level i recommend codepen and some starter javascript projects...